APPS.CLN_XMLG_EVENT_HANDLER_PKG dependencies on ECX_DOCLOGS

Line 94: FROM ecx_doclogs doclogs, ecx_tp_details details, ecx_tp_headers header,

90: INTO l_np_tp_id, l_party_id, l_tp_location_code,
91: l_party_type, l_int_con_no, l_app_ref_id,
92: l_xmlg_tran_type, l_xmlg_tran_subtype,
93: l_xmlg_doc_id, l_sender_component, l_message_standard
94: FROM ecx_doclogs doclogs, ecx_tp_details details, ecx_tp_headers header,
95: ecx_ext_processes processes, ecx_transactions transaction, ecx_standards estd
96: WHERE doclogs.msgid = HEXTORAW(p_msg_id) and
97: doclogs.party_site_id = source_tp_location_code and
98: doclogs.transaction_type = ext_type and

Line 108: ecx_cln_debug_pub.Add('INVALID_DATA_FOUND EXCEPTION IN ECX_DOCLOGS FOR MESSSAGE ID:' || p_msg_id, 1);

104: rownum < 2;
105: EXCEPTION
106: WHEN NO_DATA_FOUND THEN
107: IF (l_Debug_Level <= 1) THEN
108: ecx_cln_debug_pub.Add('INVALID_DATA_FOUND EXCEPTION IN ECX_DOCLOGS FOR MESSSAGE ID:' || p_msg_id, 1);
109: END IF;
110:
111: SELECT internal_control_number, attribute5, transaction_type,
112: transaction_subtype, document_number, protocol_type, message_standard

Line 115: FROM ecx_doclogs

111: SELECT internal_control_number, attribute5, transaction_type,
112: transaction_subtype, document_number, protocol_type, message_standard
113: INTO l_int_con_no, l_app_ref_id, l_xmlg_tran_type,
114: l_xmlg_tran_subtype, l_xmlg_doc_id, l_sender_component, l_message_standard
115: FROM ecx_doclogs
116: WHERE msgid = HEXTORAW(p_msg_id);
117: END;
118:
119:

Line 500: FROM ecx_doclogs

496:
497:
498: SELECT TRANSACTION_TYPE, TRANSACTION_SUBTYPE, DIRECTION, ATTRIBUTE5, message_standard
499: INTO l_txn_type, l_txn_subtype, l_direction, l_app_ref_id, l_message_standard
500: FROM ecx_doclogs
501: WHERE msgid = HEXTORAW(l_msg_id);
502:
503: IF (l_Debug_Level <= 1) THEN
504: ecx_cln_debug_pub.Add('Transaction Type:' || l_txn_type, 1);