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_CH_COLLABORATION_PKG dependencies on ECX_DOCLOGS

Line 98: SELECT payload into l_xmlDoc FROM ecx_doclogs WHERE msgid = HEXTORAW(p_msgId);

94: END IF;
95:
96: x_doc_creation_date := NULL;
97:
98: SELECT payload into l_xmlDoc FROM ecx_doclogs WHERE msgid = HEXTORAW(p_msgId);
99:
100: l_ini_pos := -1;
101: l_ini_pos := dbms_lob.instr(l_xmlDoc, '!DOCTYPE ');
102: IF (l_Debug_Level <= 2) THEN

Line 277: SELECT payload into l_xmlDoc FROM ecx_doclogs WHERE msgid = HEXTORAW(p_msgId);

273: RETURN;
274: END IF;
275: x_app_ref_id := NULL;
276:
277: SELECT payload into l_xmlDoc FROM ecx_doclogs WHERE msgid = HEXTORAW(p_msgId);
278:
279: l_ini_pos := -1;
280: l_ini_pos := dbms_lob.instr(l_xmlDoc, '!DOCTYPE ');
281: IF (l_Debug_Level <= 2) THEN

Line 430: SELECT payload into l_xmlDoc FROM ecx_doclogs WHERE msgid = HEXTORAW(p_msgId);

426: END IF;
427:
428: x_app_ref_id := NULL;
429:
430: SELECT payload into l_xmlDoc FROM ecx_doclogs WHERE msgid = HEXTORAW(p_msgId);
431: IF (l_Debug_Level <= 1) THEN
432: ecx_cln_debug_pub.Add('payload obtained', 1);
433: END IF;
434:

Line 3742: ecx_cln_debug_pub.Add('-- Before SQL query to find the trading partner set up from ECX_DOCLOGS --',1);

3738: ) THEN
3739:
3740: BEGIN
3741: IF (l_Debug_Level <= 1) THEN
3742: ecx_cln_debug_pub.Add('-- Before SQL query to find the trading partner set up from ECX_DOCLOGS --',1);
3743: END IF;
3744:
3745:
3746: IF (p_xmlg_msg_id is not null ) THEN

Line 3753: FROM ECX_DOCLOGS

3749: message_standard, message_type, event_key
3750: INTO l_xmlg_internal_control_number, l_xmlg_msg_id, l_xmlg_transaction_type, l_xmlg_transaction_subtype,
3751: l_xmlg_document_id, l_tr_partner_type, l_tr_partner_id, l_tr_partner_site, l_doc_dir, l_sender_component,
3752: l_xmlg_msg_standard, l_xmlg_msg_type, l_xml_event_key
3753: FROM ECX_DOCLOGS
3754: WHERE MSGID = HEXTORAW(p_xmlg_msg_id);
3755: ELSIF (p_xmlg_internal_control_number is not null ) THEN
3756: SELECT internal_control_number, msgid, transaction_type, transaction_subtype,
3757: document_number, party_type, partyid, party_site_id, direction, protocol_type,

Line 3762: FROM ECX_DOCLOGS

3758: message_standard, message_type, event_key
3759: INTO l_xmlg_internal_control_number, l_xmlg_msg_id, l_xmlg_transaction_type,
3760: l_xmlg_transaction_subtype, l_xmlg_document_id, l_tr_partner_type, l_tr_partner_id,
3761: l_tr_partner_site, l_doc_dir, l_sender_component, l_xmlg_msg_standard, l_xmlg_msg_type, l_xml_event_key
3762: FROM ECX_DOCLOGS
3763: WHERE INTERNAL_CONTROL_NUMBER = p_xmlg_internal_control_number;
3764: ELSIF (p_xmlg_transaction_type is not null and p_xmlg_transaction_subtype is not null and p_xmlg_document_id IS not NULL) THEN
3765: SELECT internal_control_number, msgid, transaction_type, transaction_subtype,
3766: document_number, party_type, partyid, party_site_id, direction, protocol_type,

Line 3771: FROM ECX_DOCLOGS

3767: message_standard, message_type, event_key
3768: INTO l_xmlg_internal_control_number, l_xmlg_msg_id, l_xmlg_transaction_type,
3769: l_xmlg_transaction_subtype, l_xmlg_document_id, l_tr_partner_type, l_tr_partner_id,
3770: l_tr_partner_site, l_doc_dir, l_sender_component, l_xmlg_msg_standard, l_xmlg_msg_type, l_xml_event_key
3771: FROM ECX_DOCLOGS
3772: WHERE transaction_type = p_xmlg_transaction_type
3773: AND transaction_subtype = p_xmlg_transaction_subtype
3774: AND document_number = p_xmlg_document_id
3775: AND direction = NVL(p_doc_dir,direction)

Line 3784: FROM ECX_TRANSACTIONS ecxtrans, ECX_EXT_PROCESSES ecxproc, ECX_DOCLOGS doclogs

3780: doclogs.protocol_type, doclogs.message_standard, doclogs.message_type, doclogs.event_key
3781: INTO l_xmlg_internal_control_number, l_xmlg_msg_id, l_xmlg_transaction_type, l_xmlg_transaction_subtype,
3782: l_xmlg_document_id, l_tr_partner_type, l_tr_partner_id,l_tr_partner_site, l_doc_dir,
3783: l_sender_component, l_xmlg_msg_standard, l_xmlg_msg_type, l_xml_event_key
3784: FROM ECX_TRANSACTIONS ecxtrans, ECX_EXT_PROCESSES ecxproc, ECX_DOCLOGS doclogs
3785: WHERE ecxtrans.TRANSACTION_TYPE = NVL(p_xmlg_int_transaction_type,l_xmlg_int_transaction_type)
3786: AND ecxtrans.TRANSACTION_SUBTYPE = NVL(p_xmlg_int_transaction_subtype,l_xmlg_int_transaction_subtype)
3787: AND ecxproc.TRANSACTION_ID = ecxtrans.TRANSACTION_ID
3788: AND ecxproc.DIRECTION = NVL(p_doc_dir,ecxproc.direction)

Line 3796: ecx_cln_debug_pub.Add('-- After SQL query to find the trading partner set up from ECX_DOCLOGS --',1);

3792: AND doclogs.transaction_subtype = ecxproc.EXT_SUBTYPE
3793: AND doclogs.document_number = p_xmlg_document_id;
3794: END IF;
3795: IF (l_Debug_Level <= 1) THEN
3796: ecx_cln_debug_pub.Add('-- After SQL query to find the trading partner set up from ECX_DOCLOGS --',1);
3797: END IF;
3798:
3799:
3800: EXCEPTION

Line 3929: THEN -- based on the ecx doclogs values we have to get actual TP values

3925: p_xml_event_key := NVL(p_xml_event_key, l_xml_event_key);
3926: p_collaboration_standard := NVL(p_collaboration_standard, l_xmlg_msg_standard);
3927:
3928: IF (p_tr_partner_type IS NULL OR p_tr_partner_id IS NULL OR p_tr_partner_site IS NULL or l_xmlg_msg_standard is null )
3929: THEN -- based on the ecx doclogs values we have to get actual TP values
3930: BEGIN
3931: IF (l_Debug_Level <= 1) THEN
3932: ecx_cln_debug_pub.Add('-- Before SQL query to find the trading partner set up from ecx_ext_processes /ecx_tp_details /ecx_tp_headers',1);
3933: END IF;

Line 4021: -- values obtained after the query to ecx_doclogs table

4017:
4018: RETURN;
4019: END IF;
4020:
4021: -- values obtained after the query to ecx_doclogs table
4022: IF (l_Debug_Level <= 1) THEN
4023: ecx_cln_debug_pub.Add('====Parameters Just Before Returning To the Main Calling Procedure======',1);
4024: ecx_cln_debug_pub.Add('XMLG INTERNAL CONTROL NO ----- >>>'||p_xmlg_internal_control_number,1);
4025: ecx_cln_debug_pub.Add('XMLG MESSAGE ID ----- >>>'||p_xmlg_msg_id,1);

Line 4192: -- values obtained after the query to ecx_doclogs table

4188: p_coll_type := NVL(p_coll_type,l_collaboration_type);
4189: p_doc_type := NVL(p_doc_type,l_document_type);
4190:
4191:
4192: -- values obtained after the query to ecx_doclogs table
4193: IF (l_Debug_Level <= 1) THEN
4194: ecx_cln_debug_pub.Add('==========Parameters After Query To ECX_DOCLOGS=============',1);
4195: ecx_cln_debug_pub.Add('APPLICATION ID ----- >>>'||p_app_id,1);
4196: ecx_cln_debug_pub.Add('COLLABORATION TYPE ----- >>>'||p_coll_type,1);

Line 4194: ecx_cln_debug_pub.Add('==========Parameters After Query To ECX_DOCLOGS=============',1);

4190:
4191:
4192: -- values obtained after the query to ecx_doclogs table
4193: IF (l_Debug_Level <= 1) THEN
4194: ecx_cln_debug_pub.Add('==========Parameters After Query To ECX_DOCLOGS=============',1);
4195: ecx_cln_debug_pub.Add('APPLICATION ID ----- >>>'||p_app_id,1);
4196: ecx_cln_debug_pub.Add('COLLABORATION TYPE ----- >>>'||p_coll_type,1);
4197: ecx_cln_debug_pub.Add('COLLABORATION DOCUMENT TYPE ----- >>>'||p_doc_type,1);
4198: ecx_cln_debug_pub.Add('=============================================================',1);

Line 4655: ecx_cln_debug_pub.Add('Trying to find collaboration based on data area reference id through ecx_doclogs' ,1);

4651: END IF;
4652:
4653: IF l_data_area_refid IS NOT NULL THEN
4654: IF (l_Debug_Level <= 1) THEN
4655: ecx_cln_debug_pub.Add('Trying to find collaboration based on data area reference id through ecx_doclogs' ,1);
4656: END IF;
4657:
4658: BEGIN
4659: IF (l_Debug_Level <= 1) THEN

Line 4665: FROM ecx_doclogs doclogs, ecx_ext_processes eep, ecx_tp_details etd, ecx_tp_headers eth, ecx_standards estd

4661: END IF;
4662:
4663: SELECT doclogs.internal_control_number
4664: INTO l_corrspnd_internal_cntrl_num
4665: FROM ecx_doclogs doclogs, ecx_ext_processes eep, ecx_tp_details etd, ecx_tp_headers eth, ecx_standards estd
4666: WHERE doclogs.direction = 'IN' and doclogs.field7 = l_data_area_refid
4667: AND eep.ext_type = doclogs.transaction_type
4668: AND eep.ext_subtype = doclogs.transaction_subtype
4669: AND eep.standard_id = estd.standard_id