eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CLN_XMLG_EVENT_HANDLER_PKG dependencies on STANDARD

Line 56: l_message_standard VARCHAR2(30);

52: l_int_con_no VARCHAR2(255);
53: l_debug_mode VARCHAR2(255);
54: l_error_code VARCHAR2(255);
55: l_error_msg VARCHAR2(1000);
56: l_message_standard VARCHAR2(30);
57: l_doc_type VARCHAR2(30);
58:
59: BEGIN
60:

Line 89: doclogs.document_number, doclogs.protocol_type, estd.standard_code

85: -- from ecx tables using message ID
86: SELECT header.tp_header_id , header.party_id, header.party_site_id,
87: header.party_type, doclogs.internal_control_number, doclogs.attribute5,
88: transaction.transaction_type, transaction.transaction_subtype,
89: doclogs.document_number, doclogs.protocol_type, estd.standard_code
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

Line 93: l_xmlg_doc_id, l_sender_component, l_message_standard

89: doclogs.document_number, doclogs.protocol_type, estd.standard_code
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

Line 95: ecx_ext_processes processes, ecx_transactions transaction, ecx_standards estd

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
99: doclogs.transaction_subtype = ext_subtype and

Line 103: estd.standard_id = processes.standard_id and

99: doclogs.transaction_subtype = ext_subtype and
100: header.tp_header_id = details.tp_header_id and
101: details.ext_process_id = processes.ext_process_id and
102: processes.transaction_id = transaction.transaction_id and
103: estd.standard_id = processes.standard_id and
104: rownum < 2;
105: EXCEPTION
106: WHEN NO_DATA_FOUND THEN
107: IF (l_Debug_Level <= 1) THEN

Line 112: transaction_subtype, document_number, protocol_type, message_standard

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
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);

Line 114: l_xmlg_tran_subtype, l_xmlg_doc_id, l_sender_component, l_message_standard

110:
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:

Line 132: ecx_cln_debug_pub.Add('Message Standard:' || l_message_standard, 1);

128: ecx_cln_debug_pub.Add('Transaction Type:' || l_xmlg_tran_type, 1);
129: ecx_cln_debug_pub.Add('Transaction Subtype:' || l_xmlg_tran_subtype, 1);
130: ecx_cln_debug_pub.Add('Document ID:' || l_xmlg_doc_id, 1);
131: ecx_cln_debug_pub.Add('Application reference ID from attribute5:' || l_app_ref_id, 1);
132: ecx_cln_debug_pub.Add('Message Standard:' || l_message_standard, 1);
133: END IF;
134:
135:
136:

Line 159: CLN_CH_COLLABORATION_PKG.GET_DATA_AREA_REFID(p_msg_id, l_message_standard, l_app_ref_id, l_app_id, l_coll_type);

155: p_doc_type => l_doc_type);
156:
157: -- Getting Application Refernce ID by Calling GET_DATA_AREA_REFID
158: IF l_app_ref_id IS NULL THEN
159: CLN_CH_COLLABORATION_PKG.GET_DATA_AREA_REFID(p_msg_id, l_message_standard, l_app_ref_id, l_app_id, l_coll_type);
160: IF (l_Debug_Level <= 1) THEN
161: ecx_cln_debug_pub.Add('Application reference ID obtained thru payload parsing:'|| l_app_ref_id, 1);
162: END IF;
163:

Line 480: l_message_standard VARCHAR2(30);

476: l_coll_id NUMBER;
477: l_dtl_coll_id NUMBER;
478: l_msg VARCHAR2(1000);
479: i_cln_not_parameters wf_parameter_list_t;
480: l_message_standard VARCHAR2(30);
481: BEGIN
482: -- Sets the debug mode to be FILE
483: --l_debug_mode := ecx_cln_debug_pub.Set_Debug_Mode('FILE');
484:

Line 498: SELECT TRANSACTION_TYPE, TRANSACTION_SUBTYPE, DIRECTION, ATTRIBUTE5, message_standard

494: ecx_cln_debug_pub.Add('Message ID:' || l_msg_id, 1);
495: END IF;
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:

Line 499: INTO l_txn_type, l_txn_subtype, l_direction, l_app_ref_id, l_message_standard

495: END IF;
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

Line 547: CLN_CH_COLLABORATION_PKG.GET_DATA_AREA_REFID(l_msg_id, l_message_standard, l_app_ref_id, l_app_id, l_coll_type);

543: RETURN 'SUCCESS';
544: END IF;
545:
546: IF l_app_ref_id IS NULL THEN
547: CLN_CH_COLLABORATION_PKG.GET_DATA_AREA_REFID(l_msg_id, l_message_standard, l_app_ref_id, l_app_id, l_coll_type);
548: IF (l_Debug_Level <= 1) THEN
549: ecx_cln_debug_pub.Add('Application reference ID obtained thru payload parsing:'|| l_app_ref_id, 1);
550: END IF;
551: