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_NP_PROCESSOR_PKG dependencies on STANDARD

Line 155: p_collaboration_standard IN VARCHAR2,

151: p_coll_point IN VARCHAR2,
152: p_doc_dir IN VARCHAR2,
153: p_coll_id IN NUMBER,
154: x_dtl_coll_id IN OUT NOCOPY VARCHAR2,
155: p_collaboration_standard IN VARCHAR2,
156: p_notification_event IN WF_EVENT_T,
157: p_application_id IN NUMBER )
158: IS
159: l_application_id NUMBER(10);

Line 225: ecx_cln_debug_pub.Add('p_collaboration_standard:' || p_collaboration_standard, 1);

221: ecx_cln_debug_pub.Add('p_tp_id:' || p_tp_id, 1);
222: ecx_cln_debug_pub.Add('p_reference:' || p_reference, 1);
223: ecx_cln_debug_pub.Add('p_statuslvl:' || p_statuslvl, 1);
224: ecx_cln_debug_pub.Add('p_header_desc:' || p_header_desc, 1);
225: ecx_cln_debug_pub.Add('p_collaboration_standard:' || p_collaboration_standard, 1);
226: END IF;
227:
228:
229: IF(p_update_collaboration_flag) THEN

Line 454: p_collaboration_standard => p_collaboration_standard);

450: p_xmlg_internal_control_number => p_int_con_no,
451: p_xmlg_msg_id => NULL,
452: p_rosettanet_check_required => FALSE,
453: x_dtl_coll_id => x_dtl_coll_id,
454: p_collaboration_standard => p_collaboration_standard);
455: ELSE
456: IF (l_Debug_Level <= 2) THEN
457: ecx_cln_debug_pub.Add('INVOKING CLN_CH_COLLABORATION_PKG.UPDATE_COLLABORATION', 2);
458: END IF;

Line 472: p_collaboration_standard => p_collaboration_standard);

468: p_xmlg_internal_control_number => p_int_con_no,
469: p_xmlg_msg_id => NULL,
470: p_rosettanet_check_required => FALSE,
471: x_dtl_coll_id => x_dtl_coll_id,
472: p_collaboration_standard => p_collaboration_standard);
473: END IF;
474:
475: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
476: x_ret_desc := l_msg_data;

Line 1022: p_collaboration_standard IN VARCHAR2)

1018: p_int_con_no IN VARCHAR2,
1019: p_coll_point IN VARCHAR2,
1020: p_doc_dir IN VARCHAR2,
1021: p_coll_id IN NUMBER,
1022: p_collaboration_standard IN VARCHAR2)
1023: IS
1024: l_all_reason_codes VARCHAR2(255);
1025: l_reason_code VARCHAR2(100);
1026: l_position_code NUMBER;

Line 1058: ecx_cln_debug_pub.Add('p_collaboration_standard:' || p_collaboration_standard, 1);

1054: ecx_cln_debug_pub.Add('p_int_con_no:' || p_int_con_no, 1);
1055: ecx_cln_debug_pub.Add('p_coll_point:' || p_coll_point, 1);
1056: ecx_cln_debug_pub.Add('p_doc_dir:' || p_doc_dir, 1);
1057: ecx_cln_debug_pub.Add('p_coll_id:' || p_coll_id, 1);
1058: ecx_cln_debug_pub.Add('p_collaboration_standard:' || p_collaboration_standard, 1);
1059: END IF;
1060:
1061:
1062: x_ret_code := FND_API.G_RET_STS_SUCCESS;

Line 1073: p_coll_id, l_dtl_coll_id,p_collaboration_standard, null,null);

1069: TAKE_ACTIONS_INTERNAL(l_return_code, l_return_desc, p_statuslvl, l_reason_desc,
1070: p_tp_id, p_reference, p_statuslvl, p_header_desc,
1071: l_update_collaboration_flag, true, p_reason_code,
1072: p_int_con_no, p_coll_point, p_doc_dir,
1073: p_coll_id, l_dtl_coll_id,p_collaboration_standard, null,null);
1074: IF l_return_code <> FND_API.G_RET_STS_SUCCESS THEN
1075: x_ret_desc := l_return_desc;
1076: RAISE FND_API.G_EXC_ERROR;
1077: END IF;

Line 1094: p_coll_id, l_dtl_coll_id,p_collaboration_standard,null,null);

1090: TAKE_ACTIONS_INTERNAL(l_return_code, l_return_desc, l_reason_code, l_reason_desc,
1091: p_tp_id, p_reference, p_statuslvl, p_header_desc,
1092: l_update_collaboration_flag, true, p_reason_code,
1093: p_int_con_no, p_coll_point, p_doc_dir,
1094: p_coll_id, l_dtl_coll_id,p_collaboration_standard,null,null);
1095: IF l_return_code <> FND_API.G_RET_STS_SUCCESS THEN
1096: x_ret_desc := l_return_desc;
1097: RAISE FND_API.G_EXC_ERROR;
1098: END IF;

Line 1314: FROM ECX_DOCLOGS doclogs, ecx_ext_processes eep, ecx_tp_details etd, ecx_tp_headers eth, ecx_standards estd

1310:
1311: BEGIN
1312: SELECT to_char(eth.tp_header_id)
1313: INTO p_tr_partner_id
1314: FROM ECX_DOCLOGS doclogs, ecx_ext_processes eep, ecx_tp_details etd, ecx_tp_headers eth, ecx_standards estd
1315: WHERE doclogs.internal_control_number = p_xmlg_internal_control_number
1316: AND eep.ext_type = doclogs.transaction_type
1317: AND eep.ext_subtype = doclogs.transaction_subtype
1318: AND eep.standard_id = estd.standard_id

Line 1318: AND eep.standard_id = estd.standard_id

1314: FROM ECX_DOCLOGS doclogs, ecx_ext_processes eep, ecx_tp_details etd, ecx_tp_headers eth, ecx_standards estd
1315: WHERE doclogs.internal_control_number = p_xmlg_internal_control_number
1316: AND eep.ext_type = doclogs.transaction_type
1317: AND eep.ext_subtype = doclogs.transaction_subtype
1318: AND eep.standard_id = estd.standard_id
1319: AND estd.standard_code = doclogs.message_standard
1320: AND eep.ext_process_id = etd.ext_process_id
1321: AND etd.source_tp_location_code = doclogs.party_site_id
1322: AND eep.direction = 'IN'

Line 1319: AND estd.standard_code = doclogs.message_standard

1315: WHERE doclogs.internal_control_number = p_xmlg_internal_control_number
1316: AND eep.ext_type = doclogs.transaction_type
1317: AND eep.ext_subtype = doclogs.transaction_subtype
1318: AND eep.standard_id = estd.standard_id
1319: AND estd.standard_code = doclogs.message_standard
1320: AND eep.ext_process_id = etd.ext_process_id
1321: AND etd.source_tp_location_code = doclogs.party_site_id
1322: AND eep.direction = 'IN'
1323: AND eth.party_type = NVL(doclogs.party_type,eth.party_type);

Line 1543: l_collaboration_standard VARCHAR2(30);

1539: l_coll_type VARCHAR2(30);
1540: l_return_msg VARCHAR2(1000);
1541: l_return_code VARCHAR2(1000);
1542: l_org_id VARCHAR2(100);
1543: l_collaboration_standard VARCHAR2(30);
1544: l_doc_type VARCHAR2(100);
1545: l_document_number VARCHAR2(255);
1546:
1547: l_dtl_coll_id NUMBER;

Line 1621: ecx_cln_debug_pub.Add('Getting values for External Transaction type and SubType and msg standard',1);

1617: IF((l_xmlg_int_transaction_type IS NOT NULL) AND (l_xmlg_int_transaction_subtype IS NOT NULL) AND (l_tr_partner_id IS NOT NULL) AND (l_tr_partner_site IS NOT NULL)) THEN
1618: IF ((l_xmlg_transaction_type IS NULL) OR (l_xmlg_transaction_subtype IS NULL)) THEN
1619:
1620: IF (l_Debug_Level <= 1) THEN
1621: ecx_cln_debug_pub.Add('Getting values for External Transaction type and SubType and msg standard',1);
1622: END IF;
1623:
1624: BEGIN
1625: SELECT ecxproc.EXT_TYPE,ecxproc.EXT_SUBTYPE

Line 1627: FROM ecx_tp_headers eth, ecx_tp_details etd, ECX_TRANSACTIONS ecxtrans, ECX_EXT_PROCESSES ecxproc, ecx_standards estd

1623:
1624: BEGIN
1625: SELECT ecxproc.EXT_TYPE,ecxproc.EXT_SUBTYPE
1626: INTO l_xmlg_transaction_type, l_xmlg_transaction_subtype
1627: FROM ecx_tp_headers eth, ecx_tp_details etd, ECX_TRANSACTIONS ecxtrans, ECX_EXT_PROCESSES ecxproc, ecx_standards estd
1628: WHERE eth.party_id = l_tr_partner_id
1629: AND eth.party_site_id = l_tr_partner_site
1630: AND eth.party_type = nvl(l_tr_partner_type, eth.party_type)
1631: AND eth.tp_header_id = etd.tp_header_id

Line 1637: AND estd.standard_id = ecxproc.standard_id;

1633: AND ecxtrans.transaction_id = ecxproc.transaction_id
1634: AND ecxtrans.transaction_type = l_xmlg_int_transaction_type
1635: AND ecxtrans.transaction_subtype = l_xmlg_int_transaction_subtype
1636: AND ecxproc.direction = nvl(l_doc_dir,ecxproc.direction)
1637: AND estd.standard_id = ecxproc.standard_id;
1638:
1639: IF (l_Debug_Level <= 1) THEN
1640: ecx_cln_debug_pub.Add('====Parameters Received From ECX_TRANSACTIONS/ECX_EXT_PROCESSES====',1);
1641: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION TYPE ----- >>>'||l_xmlg_transaction_type,1);

Line 1729: p_collaboration_standard => l_collaboration_standard);

1725: p_tr_partner_id => l_tr_partner_id,
1726: p_tr_partner_site => l_tr_partner_site,
1727: p_sender_component => l_sender_component,
1728: p_xml_event_key => l_xml_event_key,
1729: p_collaboration_standard => l_collaboration_standard);
1730:
1731: IF ( x_return_status <> 'S') THEN
1732: l_msg_data := 'Error in GET_TRADING_PARTNER_DETAILS ';
1733: -- x_msg_data is set to appropriate value by GET_TRADING_PARTNER_DETAILS

Line 1791: p_collaboration_standard => null,

1787: p_coll_point => l_collaboration_pt,
1788: p_doc_dir => l_doc_dir,
1789: p_coll_id => l_coll_id,
1790: x_dtl_coll_id => l_dtl_coll_id,
1791: p_collaboration_standard => null,
1792: p_notification_event => p_notification_event,
1793: p_application_id => l_application_id );
1794:
1795:

Line 1883: l_collaboration_standard VARCHAR2(30);

1879: l_return_status VARCHAR2(1000);
1880: l_return_msg VARCHAR2(1000);
1881: l_return_code VARCHAR2(1000);
1882: l_org_id VARCHAR2(100);
1883: l_collaboration_standard VARCHAR2(30);
1884:
1885: BEGIN
1886: IF (l_Debug_Level <= 2) THEN
1887: ecx_cln_debug_pub.Add('ENTERING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIF_BATCH_EVT', 2);

Line 1949: ecx_cln_debug_pub.Add('Queried the display setup using application id/collaboration standard/attribute name as :'|| l_application_id||'/'||l_collaboration_std||'/'||l_attribute_name, 1);

1945: RAISE FND_API.G_EXC_ERROR;
1946: END IF;
1947:
1948: IF (l_Debug_Level <= 4) THEN
1949: ecx_cln_debug_pub.Add('Queried the display setup using application id/collaboration standard/attribute name as :'|| l_application_id||'/'||l_collaboration_std||'/'||l_attribute_name, 1);
1950: END IF;
1951:
1952:
1953: -- GET THE ATTRIBUTE COLUMN NAME

Line 1960: AND collaboration_standard = l_collaboration_std

1956: INTO l_attribute_col_value
1957: FROM CLN_CH_DISPLAY_LABELS_DTL_tl tl, CLN_CH_DISPLAY_LABELS_DTL_VL vl, CLN_CH_DISPLAY_LABELS_hdr hdr
1958: WHERE tl.guid = vl.guid
1959: AND parent_guid = hdr.guid
1960: AND collaboration_standard = l_collaboration_std
1961: AND application_id = l_application_id
1962: AND cln_columns = l_attribute_name
1963: AND collaboration_type IS NULL
1964: AND LANGUAGE = USERENV('LANG');

Line 1978: ecx_cln_debug_pub.Add('Display SetUp Not Found forapplication id/collaboration standard/attribute name as :'|| l_application_id||'/'||l_collaboration_std||'/'||l_attribute_name, 4);

1974: FND_MESSAGE.SET_TOKEN('APPLID',l_application_id);
1975: FND_MESSAGE.SET_TOKEN('COLLSTD',l_collaboration_std);
1976:
1977: IF (l_Debug_Level <= 4) THEN
1978: ecx_cln_debug_pub.Add('Display SetUp Not Found forapplication id/collaboration standard/attribute name as :'|| l_application_id||'/'||l_collaboration_std||'/'||l_attribute_name, 4);
1979: END IF;
1980:
1981: x_msg_data := FND_MESSAGE.GET;
1982: RAISE FND_API.G_EXC_ERROR;