APIs Defined in ECX_ERRORLOG

getDoclogDetails

PL/SQL Syntax

procedure getDoclogDetails
(i_msgid in raw,
 i_message_type out varchar2,
 i_message_standard out varchar2,
 i_transaction_type out varchar2,
 i_transaction_subtype out varchar2,
 i_document_number out varchar2,
 i_party_id out varchar2,
 i_party_site_id out varchar2,
 i_protocol_type out varchar2,
 i_protocol_address out varchar2,
 i_username out varchar2,
 i_password out varchar2,
 i_attribute1 out varchar2,
 i_attribute2 out varchar2,
 i_attribute3 out varchar2,
 i_attribute4 out varchar2,
 i_attribute5 out varchar2,
 i_logfile out varchar2,
 i_internal_control_number out number,
 i_status out varchar2,
 i_time_stamp out date,
 i_direction out varchar2,
 o_retcode out pls_integer,
 o_retmsg out varchar2);

Description

Gets information about transactions processed by XML Gateway. An entry is written to the ECX_DOCLOGS table for each outbound message created by XML Gateway and each inbound message processed by XML Gateway.

Error recovery is performed using the stored copy of a message. For details regarding error recovery, see XML Gateway Error Processing Item Type.

Arguments (input)

i_msgid Message identifier provided by the XML Gateway execution engine for each message processed.

Arguments (output)

i_message_type The message type is defaulted to "XML"
i_message_standard The XML standard associated with the business document as entered using the Define XML Standards window and used by the Define Trading Partners window.
i_transaction_type External transaction type associated with the business document as entered using the Define Transactions window and used by the Define Trading Partners window.
i_transaction_ subtype External transaction subtype associated with the business document as entered using the Define Transactions window and used by the Define Trading Partners window.
i_document_ number Unique identifier from the Oracle E-Business Suite for the outbound business document.
Unique identifier for an inbound business document received from the Trading Partner.
i_party_id Trading Partner identifier associated with the business document as entered using the Define Trading Partners window.
i_party_site_id Trading Partner site identifier associated with the business document as entered using the Define Trading Partners window.
i_protocol_type Communication method associated with the business document as entered using the Define Trading Partners window.
i_protocol_address Address/URL associated with the communication method as entered using the Define Trading Partners window.
i_username The username associated with the Trading Partner as entered using the Define Trading Partners window.
i_password The password associated with the username as entered using the Define Trading Partners window.
i_attribute1 User-defined field to pass data.
i_attribute2 User-defined field to pass data.
i_attribute3 The Destination Trading Partner Location Code as entered using the Define Trading Partners window.
i_attribute4 User-defined field to pass data.
i_attribute5 User-defined field to pass data.
i_logfile Identifies the name of the log file created by the XML Gateway execution engine for the business document processed. The log files are written to the directory identified in the ECX: Log File Path system profile.
i_internal_control_number The unique identifier as defined by the XML Gateway execution engine for each business document processed.
i_status The status of the business document processed.
i_time_stamp Time stamp from the XML Gateway execution engine representing when the outbound business document was created or when the inbound business document was processed.
i_direction Identifies whether the business document was outbound from the Oracle E-Business Suite or inbound into the Oracle E-Business Suite.
o_retcode Return code for the procedure.
o_retmsg Return message for the procedure.