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 STANDARD

Line 235: p_collaboration_standard IN VARCHAR2,

231: -- Uses a DOM Parser to parse the document and retrieve the application reference ID
232:
233: PROCEDURE GET_CONTROL_AREA_REFID(
234: p_msgId IN RAW,
235: p_collaboration_standard IN VARCHAR2,
236: x_app_ref_id IN OUT NOCOPY VARCHAR2,
237: p_app_id IN VARCHAR2,
238: p_coll_type IN VARCHAR2
239: )

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

260: END IF;
261: IF (l_Debug_Level <= 2) THEN
262: ecx_cln_debug_pub.Add('WITH PARAMETERS', 1);
263: ecx_cln_debug_pub.Add('p_msgId:' || p_msgId, 1);
264: ecx_cln_debug_pub.Add('p_collaboration_standard:' || p_collaboration_standard, 1);
265: ecx_cln_debug_pub.Add('p_app_id:' || p_app_id, 1);
266: ecx_cln_debug_pub.Add('p_coll_type:' || p_coll_type, 1);
267: END IF;
268:

Line 269: IF p_collaboration_standard is NULL THEN

265: ecx_cln_debug_pub.Add('p_app_id:' || p_app_id, 1);
266: ecx_cln_debug_pub.Add('p_coll_type:' || p_coll_type, 1);
267: END IF;
268:
269: IF p_collaboration_standard is NULL THEN
270: IF (l_Debug_Level <= 2) THEN
271: ecx_cln_debug_pub.Add('-----------EXITING GET_APP_REFID as collaboration standard is null-----------', 1);
272: END IF;
273: RETURN;

Line 271: ecx_cln_debug_pub.Add('-----------EXITING GET_APP_REFID as collaboration standard is null-----------', 1);

267: END IF;
268:
269: IF p_collaboration_standard is NULL THEN
270: IF (l_Debug_Level <= 2) THEN
271: ecx_cln_debug_pub.Add('-----------EXITING GET_APP_REFID as collaboration standard is null-----------', 1);
272: END IF;
273: RETURN;
274: END IF;
275: x_app_ref_id := NULL;

Line 314: IF(p_collaboration_standard = 'OAG') THEN

310: xmlparser.parseClob(l_parser,l_xmlDoc);
311: END IF;
312:
313: l_domDoc := xmlparser.getDocument(l_parser);
314: IF(p_collaboration_standard = 'OAG') THEN
315: l_nodeList := Xmldom.getElementsByTagName(l_domDoc, 'CNTROLAREA');
316: l_element := xmldom.makeElement(xmldom.item( l_nodeList, 0 ));
317: l_nodeList := Xmldom.getElementsByTagName(l_element, 'REFERENCEID');
318: ELSIF (p_collaboration_standard = 'ROSETTANET') THEN

Line 318: ELSIF (p_collaboration_standard = 'ROSETTANET') THEN

314: IF(p_collaboration_standard = 'OAG') THEN
315: l_nodeList := Xmldom.getElementsByTagName(l_domDoc, 'CNTROLAREA');
316: l_element := xmldom.makeElement(xmldom.item( l_nodeList, 0 ));
317: l_nodeList := Xmldom.getElementsByTagName(l_element, 'REFERENCEID');
318: ELSIF (p_collaboration_standard = 'ROSETTANET') THEN
319: l_nodeList := Xmldom.getElementsByTagName(l_domDoc, 'thisDocumentIdentifier');
320: l_element := xmldom.makeElement(xmldom.item( l_nodeList, 0 ));
321: l_nodeList := Xmldom.getElementsByTagName(l_element, 'ProprietaryDocumentIdentifier');
322: ELSE

Line 324: ecx_cln_debug_pub.Add('-----------EXITING GET_APP_REFID as the collaboration standard is not supported-----------', 1);

320: l_element := xmldom.makeElement(xmldom.item( l_nodeList, 0 ));
321: l_nodeList := Xmldom.getElementsByTagName(l_element, 'ProprietaryDocumentIdentifier');
322: ELSE
323: IF (l_Debug_Level <= 2) THEN
324: ecx_cln_debug_pub.Add('-----------EXITING GET_APP_REFID as the collaboration standard is not supported-----------', 1);
325: END IF;
326: RETURN;
327: END IF;
328: l_node := xmldom.item( l_nodeList, 0 );

Line 340: IF(p_collaboration_standard = 'ROSETTANET' and p_app_id is not null and p_coll_type is not null and x_app_ref_id is not null) THEN

336: IF (l_Debug_Level <= 5) THEN
337: ecx_cln_debug_pub.Add(l_msg_data,6);
338: END IF;
339: x_app_ref_id := xmldom.getNodeValue(l_node);
340: IF(p_collaboration_standard = 'ROSETTANET' and p_app_id is not null and p_coll_type is not null and x_app_ref_id is not null) THEN
341: x_app_ref_id := p_app_id || p_coll_type || x_app_ref_id;
342: END IF;
343: END IF;
344:

Line 388: p_collaboration_standard IN VARCHAR2,

384: -- Uses a DOM Parser to parse the document and retrieve the application reference ID
385:
386: PROCEDURE GET_DATA_AREA_REFID(
387: p_msgId IN RAW,
388: p_collaboration_standard IN VARCHAR2,
389: x_app_ref_id IN OUT NOCOPY VARCHAR2,
390: p_app_id IN VARCHAR2,
391: p_coll_type IN VARCHAR2)
392: IS

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

412: END IF;
413: IF (l_Debug_Level <= 2) THEN
414: ecx_cln_debug_pub.Add('WITH PARAMETERS', 1);
415: ecx_cln_debug_pub.Add('p_msgId:' || p_msgId, 1);
416: ecx_cln_debug_pub.Add('p_collaboration_standard:' || p_collaboration_standard, 1);
417: ecx_cln_debug_pub.Add('p_app_id:' || p_app_id, 1);
418: ecx_cln_debug_pub.Add('p_coll_type:' || p_coll_type, 1);
419: END IF;
420:

Line 421: IF p_collaboration_standard is NULL THEN

417: ecx_cln_debug_pub.Add('p_app_id:' || p_app_id, 1);
418: ecx_cln_debug_pub.Add('p_coll_type:' || p_coll_type, 1);
419: END IF;
420:
421: IF p_collaboration_standard is NULL THEN
422: IF (l_Debug_Level <= 2) THEN
423: ecx_cln_debug_pub.Add('-----------EXITING GET_APP_REFID as collaboration standard is null-----------', 1);
424: END IF;
425: RETURN;

Line 423: ecx_cln_debug_pub.Add('-----------EXITING GET_APP_REFID as collaboration standard is null-----------', 1);

419: END IF;
420:
421: IF p_collaboration_standard is NULL THEN
422: IF (l_Debug_Level <= 2) THEN
423: ecx_cln_debug_pub.Add('-----------EXITING GET_APP_REFID as collaboration standard is null-----------', 1);
424: END IF;
425: RETURN;
426: END IF;
427:

Line 482: IF(p_collaboration_standard = 'OAG') THEN

478: l_domDoc := xmlparser.getDocument(l_parser);
479: IF (l_Debug_Level <= 1) THEN
480: ecx_cln_debug_pub.Add('dom doc obtained', 1);
481: END IF;
482: IF(p_collaboration_standard = 'OAG') THEN
483: l_nodeList := Xmldom.getElementsByTagName(l_domDoc, 'DATAAREA');
484: IF (l_Debug_Level <= 1) THEN
485: ecx_cln_debug_pub.Add('IN OAG, data area found', 1);
486: END IF;

Line 495: ELSIF (p_collaboration_standard = 'ROSETTANET') THEN

491: l_nodeList := Xmldom.getElementsByTagName(l_element, 'REFERENCEID');
492: IF (l_Debug_Level <= 1) THEN
493: ecx_cln_debug_pub.Add('Reference id element obtained', 1);
494: END IF;
495: ELSIF (p_collaboration_standard = 'ROSETTANET') THEN
496: l_nodeList := Xmldom.getElementsByTagName(l_domDoc, 'requestingDocumentIdentifier');
497: l_element := xmldom.makeElement(xmldom.item( l_nodeList, 0 ));
498: l_nodeList := Xmldom.getElementsByTagName(l_element, 'ProprietaryDocumentIdentifier');
499: ELSE

Line 501: ecx_cln_debug_pub.Add('-----------EXITING GET_APP_REFID as the collaboration standard is not supported-----------', 1);

497: l_element := xmldom.makeElement(xmldom.item( l_nodeList, 0 ));
498: l_nodeList := Xmldom.getElementsByTagName(l_element, 'ProprietaryDocumentIdentifier');
499: ELSE
500: IF (l_Debug_Level <= 2) THEN
501: ecx_cln_debug_pub.Add('-----------EXITING GET_APP_REFID as the collaboration standard is not supported-----------', 1);
502: END IF;
503: RETURN;
504: END IF;
505:

Line 518: IF(p_collaboration_standard = 'ROSETTANET' and p_app_id is not null and p_coll_type is not null and x_app_ref_id is not null) THEN

514: x_app_ref_id := xmldom.getNodeValue(l_node);
515: IF (l_Debug_Level <= 1) THEN
516: ecx_cln_debug_pub.Add('x_app_ref_id:' || x_app_ref_id, 1);
517: END IF;
518: IF(p_collaboration_standard = 'ROSETTANET' and p_app_id is not null and p_coll_type is not null and x_app_ref_id is not null) THEN
519: x_app_ref_id := p_app_id || p_coll_type || x_app_ref_id;
520: END IF;
521: IF (l_Debug_Level <= 1) THEN
522: ecx_cln_debug_pub.Add('x_app_ref_id:' || x_app_ref_id, 1);

Line 1006: p_collaboration_standard IN VARCHAR2,

1002: p_xmlg_int_transaction_type IN VARCHAR2,
1003: p_xmlg_int_transaction_subtype IN VARCHAR2,
1004: p_msg_text IN VARCHAR2,
1005: p_xml_event_key IN VARCHAR2,
1006: p_collaboration_standard IN VARCHAR2,
1007: p_attribute1 IN VARCHAR2,
1008: p_attribute2 IN VARCHAR2,
1009: p_attribute3 IN VARCHAR2,
1010: p_attribute4 IN VARCHAR2,

Line 1064: l_collaboration_standard VARCHAR2(30);

1060: l_owner_role VARCHAR2(30);
1061: l_coll_pt VARCHAR2(20);
1062: l_xml_event_key VARCHAR2(240);
1063: l_rosettanet_check_required BOOLEAN;
1064: l_collaboration_standard VARCHAR2(30);
1065: l_doc_creation_date DATE;
1066:
1067: BEGIN
1068:

Line 1079: -- Standard Start of API savepoint

1075: END IF;
1076:
1077:
1078:
1079: -- Standard Start of API savepoint
1080: SAVEPOINT CREATE_COLLABORATION_PUB;
1081:
1082: -- Initialize API return status to success
1083: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1126: ecx_cln_debug_pub.Add('Collaboration Standard ----- >>>'||p_collaboration_standard,1);

1122: ecx_cln_debug_pub.Add('SENDER COMPONENT ----- >>>'||p_sender_component,1);
1123: ecx_cln_debug_pub.Add('XMLG INTERNAL CONTROL NO ----- >>>'||p_xmlg_internal_control_number,1);
1124: ecx_cln_debug_pub.Add('XMLG EVENT KEY ----- >>>'||p_xml_event_key,1);
1125: ecx_cln_debug_pub.Add('MSG TXT ----- >>>'||p_msg_text,1);
1126: ecx_cln_debug_pub.Add('Collaboration Standard ----- >>>'||p_collaboration_standard,1);
1127: ecx_cln_debug_pub.Add('ATTRIBUTE1 ----- >>>'||p_attribute1,1);
1128: ecx_cln_debug_pub.Add('ATTRIBUTE2 ----- >>>'||p_attribute2,1);
1129: ecx_cln_debug_pub.Add('ATTRIBUTE3 ----- >>>'||p_attribute3,1);
1130: ecx_cln_debug_pub.Add('ATTRIBUTE4 ----- >>>'||p_attribute4,1);

Line 1174: l_collaboration_standard := p_collaboration_standard;

1170: l_coll_pt := p_coll_pt;
1171: l_rosettanet_check_required := p_rosettanet_check_required;
1172: l_msg_text := p_msg_text;
1173: l_xml_event_key := p_xml_event_key;
1174: l_collaboration_standard := p_collaboration_standard;
1175: l_doc_creation_date := p_doc_creation_date;
1176:
1177:
1178: -- Set Default values.

Line 1259: p_collaboration_standard => l_collaboration_standard);

1255: p_tr_partner_id => l_tr_partner_id,
1256: p_tr_partner_site => l_tr_partner_site,
1257: p_sender_component => l_sender_component,
1258: p_xml_event_key => l_xml_event_key,
1259: p_collaboration_standard => l_collaboration_standard);
1260:
1261: IF ( x_return_status <> 'S') THEN
1262: l_msg_data := 'Error in GET_TRADING_PARTNER_DETAILS ';
1263: -- x_msg_data is set to appropriate value by GET_TRADING_PARTNER_DETAILS

Line 1325: p_coll_standard => l_collaboration_standard

1321: p_doc_status => 'SUCCESS',
1322: p_doc_type => l_doc_type,
1323: p_doc_dir => l_doc_dir,
1324: p_coll_id => null,
1325: p_coll_standard => l_collaboration_standard
1326: );
1327:
1328: IF ( x_return_status <> 'S') THEN
1329: l_msg_data := 'Error in DEFAULT_XMLGTXN_MAPPING';

Line 1384: IF (l_collaboration_standard = 'OAG') and (l_doc_type <> 'CONFIRM_BOD' )

1380: END IF;
1381: END IF;
1382:
1383:
1384: IF (l_collaboration_standard = 'OAG') and (l_doc_type <> 'CONFIRM_BOD' )
1385: and (l_doc_dir = 'OUT') and (l_ref_id is null)
1386: and (g_xmlg_oag_application_ref_id is not null) THEN
1387: l_ref_id := g_xmlg_oag_application_ref_id;
1388: g_xmlg_oag_application_ref_id := NULL;

Line 1402: p_collaboration_standard => l_collaboration_standard,

1398: ecx_cln_debug_pub.Add('Application Reference ID is Null',1);
1399: END IF;
1400:
1401: GET_CONTROL_AREA_REFID(p_msgId => l_xmlg_msg_id,
1402: p_collaboration_standard => l_collaboration_standard,
1403: x_app_ref_id => l_ref_id,
1404: p_app_id => l_app_id,
1405: p_coll_type => l_coll_type);
1406: END IF;

Line 1432: XML_EVENT_KEY, COLLABORATION_STANDARD,OWNER_ROLE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,

1428: COLLABORATION_STATUS,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,
1429: LAST_UPDATE_LOGIN,XMLG_MSG_ID,UNIQUE_ID1,UNIQUE_ID2,UNIQUE_ID3,UNIQUE_ID4,UNIQUE_ID5,
1430: XMLG_TRANSACTION_TYPE, XMLG_TRANSACTION_SUBTYPE,XMLG_DOCUMENT_ID, TRADING_PARTNER_TYPE, TRADING_PARTNER_SITE,
1431: XMLG_INTERNAL_CONTROL_NUMBER, DOCUMENT_DIRECTION, XMLG_INT_TRANSACTION_TYPE, XMLG_INT_TRANSACTION_SUBTYPE,
1432: XML_EVENT_KEY, COLLABORATION_STANDARD,OWNER_ROLE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,
1433: ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,
1434: ATTRIBUTE14,ATTRIBUTE15,DATTRIBUTE1,DATTRIBUTE2,DATTRIBUTE3,DATTRIBUTE4,DATTRIBUTE5 )
1435: VALUES( x_coll_id,l_app_id,l_ref_id,p_org_id,p_rel_no,l_doc_no,p_doc_rev_no,
1436: p_partner_doc_no,nvl(l_coll_type,'UNKNOWN'),l_tr_partner_id,l_resend_flag,p_resend_count,

Line 1442: l_xml_event_key, l_collaboration_standard,l_owner_role,p_attribute1,p_attribute2,p_attribute3,p_attribute4,p_attribute5,

1438: SYSDATE,FND_GLOBAL.USER_ID,SYSDATE,FND_GLOBAL.USER_ID,FND_GLOBAL.LOGIN_ID,l_xmlg_msg_id,
1439: p_unique1,p_unique2,p_unique3,p_unique4,p_unique5,
1440: l_xmlg_transaction_type, l_xmlg_transaction_subtype, l_xmlg_document_id,l_tr_partner_type, l_tr_partner_site,
1441: l_xmlg_internal_control_number, l_doc_dir, l_xmlg_int_transaction_type, l_xmlg_int_transaction_subtype,
1442: l_xml_event_key, l_collaboration_standard,l_owner_role,p_attribute1,p_attribute2,p_attribute3,p_attribute4,p_attribute5,
1443: p_attribute6,p_attribute7,p_attribute8,p_attribute9,p_attribute10,p_attribute11,p_attribute12,p_attribute13,
1444: p_attribute14,p_attribute15, p_dattribute1,p_dattribute2,p_dattribute3,p_dattribute4,p_dattribute5 );
1445:
1446: IF (l_Debug_Level <= 1) THEN

Line 1636: p_collaboration_standard IN VARCHAR2,

1632: p_doc_owner IN VARCHAR2,
1633: p_xmlg_int_transaction_type IN VARCHAR2,
1634: p_xmlg_int_transaction_subtype IN VARCHAR2,
1635: p_xml_event_key IN VARCHAR2,
1636: p_collaboration_standard IN VARCHAR2,
1637: p_attribute1 IN VARCHAR2,
1638: p_attribute2 IN VARCHAR2,
1639: p_attribute3 IN VARCHAR2,
1640: p_attribute4 IN VARCHAR2,

Line 1692: l_collaboration_standard VARCHAR2(30);

1688: l_coll_pt VARCHAR2(20);
1689: l_doc_status VARCHAR2(10);
1690: l_xml_event_key VARCHAR2(240);
1691: l_rosettanet_check_required BOOLEAN;
1692: l_collaboration_standard VARCHAR2(30);
1693: l_doc_creation_date DATE;
1694:
1695:
1696: BEGIN

Line 1707: -- Standard Start of API savepoint

1703: ecx_cln_debug_pub.Add('--------- Entering UPDATE_COLLABORATION API ------------ ',2);
1704: END IF;
1705:
1706:
1707: -- Standard Start of API savepoint
1708: -- SAVEPOINT UPDATE_COLLABORATION_PUB;
1709:
1710:
1711: -- Initialize API return status to success

Line 1759: ecx_cln_debug_pub.Add('Collaboration Standard ----- >>>'||p_collaboration_standard,1);

1755: ecx_cln_debug_pub.Add('DOCUMENT REVISION DATE ----- >>>'||p_doc_revision_date,1);
1756: ecx_cln_debug_pub.Add('DOCUMENT OWNER ----- >>>'||p_doc_owner,1);
1757: ecx_cln_debug_pub.Add('OWNER ROLE ----- >>>'||p_owner_role,1);
1758: ecx_cln_debug_pub.Add('XMLG EVENT KEY ----- >>>'||p_xml_event_key,1);
1759: ecx_cln_debug_pub.Add('Collaboration Standard ----- >>>'||p_collaboration_standard,1);
1760: ecx_cln_debug_pub.Add('ATTRIBUTE1 ----- >>>'||p_attribute1,1);
1761: ecx_cln_debug_pub.Add('ATTRIBUTE2 ----- >>>'||p_attribute2,1);
1762: ecx_cln_debug_pub.Add('ATTRIBUTE3 ----- >>>'||p_attribute3,1);
1763: ecx_cln_debug_pub.Add('ATTRIBUTE4 ----- >>>'||p_attribute4,1);

Line 1809: l_collaboration_standard := P_collaboration_standard;

1805: l_coll_pt := p_coll_pt;
1806: l_doc_status := p_doc_status;
1807: l_rosettanet_check_required := p_rosettanet_check_required;
1808: l_xml_event_key := p_xml_event_key;
1809: l_collaboration_standard := P_collaboration_standard;
1810: l_doc_creation_date := p_doc_creation_date;
1811:
1812: -- enhancement done to support translation issues //15-Nov-2002
1813: l_msg_text := p_msg_text;

Line 1899: p_collaboration_standard => l_collaboration_standard);

1895: p_tr_partner_id => l_tr_partner_id,
1896: p_tr_partner_site => l_tr_partner_site,
1897: p_sender_component => l_sender_component,
1898: p_xml_event_key => l_xml_event_key,
1899: p_collaboration_standard => l_collaboration_standard);
1900:
1901: IF ( x_return_status <> 'S') THEN
1902: l_msg_data := 'Error in GET_TRADING_PARTNER_DETAILS ';
1903: -- x_msg_data is set to appropriate value by GET_TRADING_PARTNER_DETAILS

Line 2003: IF (l_collaboration_standard = 'OAG') and (l_doc_type <> 'CONFIRM_BOD' )

1999:
2000:
2001: -- Defaulting Application Reference ID
2002:
2003: IF (l_collaboration_standard = 'OAG') and (l_doc_type <> 'CONFIRM_BOD' )
2004: and (l_doc_dir = 'OUT') and (l_ref_id is null)
2005: and (g_xmlg_oag_application_ref_id is not null) THEN
2006: l_ref_id := g_xmlg_oag_application_ref_id;
2007: g_xmlg_oag_application_ref_id := NULL;

Line 2020: p_collaboration_standard => l_collaboration_standard,

2016: IF(l_ref_id IS NULL AND l_doc_dir = 'OUT'
2017: AND l_doc_type <> 'CONFIRM_BOD'
2018: AND l_xmlg_msg_id IS NOT NULL) THEN
2019: GET_CONTROL_AREA_REFID(p_msgId => l_xmlg_msg_id,
2020: p_collaboration_standard => l_collaboration_standard,
2021: x_app_ref_id => l_ref_id,
2022: p_app_id => l_app_id,
2023: p_coll_type => l_coll_type);
2024: END IF;

Line 2129: p_coll_standard => l_collaboration_standard

2125: p_doc_status => l_doc_status,
2126: p_doc_type => l_doc_type,
2127: p_doc_dir => l_doc_dir,
2128: p_coll_id => l_coll_id,
2129: p_coll_standard => l_collaboration_standard
2130: );
2131:
2132: IF ( x_return_status <> 'S') THEN
2133: l_msg_data := 'Error in DEFAULT_XMLGTXN_MAPPING';

Line 2203: COLLABORATION_STANDARD = NVL(p_collaboration_standard,NVL(COLLABORATION_STANDARD,l_collaboration_standard)),

2199: DOCUMENT_CREATION_DATE = NVL(DOCUMENT_CREATION_DATE,l_doc_creation_date),
2200: DOCUMENT_REVISION_DATE = NVL(p_doc_revision_date,DOCUMENT_REVISION_DATE),
2201: DOCUMENT_OWNER = NVL(l_doc_owner,DOCUMENT_OWNER),
2202: XML_EVENT_KEY = NVL(l_xml_event_key, XML_EVENT_KEY),
2203: COLLABORATION_STANDARD = NVL(p_collaboration_standard,NVL(COLLABORATION_STANDARD,l_collaboration_standard)),
2204: ATTRIBUTE1 = NVL(p_attribute1 ,ATTRIBUTE1),
2205: ATTRIBUTE2 = NVL(p_attribute2 ,ATTRIBUTE2),
2206: ATTRIBUTE3 = NVL(p_attribute3 ,ATTRIBUTE3),
2207: ATTRIBUTE4 = NVL(p_attribute4 ,ATTRIBUTE4),

Line 2226: /* Note on collaboraiton standard update in the above query

2222: DATTRIBUTE4 = NVL(p_dattribute4 ,DATTRIBUTE4),
2223: DATTRIBUTE5 = NVL(p_dattribute5 ,DATTRIBUTE5),
2224: OWNER_ROLE = NVL(p_owner_role,OWNER_ROLE)
2225: WHERE (COLLABORATION_ID = l_coll_id);
2226: /* Note on collaboraiton standard update in the above query
2227: ------------------------------------------------------------
2228: 1. The criteria is, if caller passes collaboration standard to the API explicitely,
2229: then the column has to be updated with that value.
2230: 2. If caller doesnt pass and if the column is already filled in,

Line 2228: 1. The criteria is, if caller passes collaboration standard to the API explicitely,

2224: OWNER_ROLE = NVL(p_owner_role,OWNER_ROLE)
2225: WHERE (COLLABORATION_ID = l_coll_id);
2226: /* Note on collaboraiton standard update in the above query
2227: ------------------------------------------------------------
2228: 1. The criteria is, if caller passes collaboration standard to the API explicitely,
2229: then the column has to be updated with that value.
2230: 2. If caller doesnt pass and if the column is already filled in,
2231: then the value of the column should be unchanged
2232: 3. If caller doesnt pass and if the column is empty,

Line 3144: l_msg_data := 'Collaboration is on RosettaNet standards';

3140:
3141:
3142: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ROSETTANET_STD');
3143: x_msg_data := FND_MESSAGE.GET;
3144: l_msg_data := 'Collaboration is on RosettaNet standards';
3145: x_update_reqd := FALSE;
3146: l_protocol_type := p_sender_component ;
3147:
3148:

Line 3652: p_collaboration_standard IN OUT NOCOPY VARCHAR2)

3648: p_tr_partner_id IN OUT NOCOPY VARCHAR2,
3649: p_tr_partner_site IN OUT NOCOPY VARCHAR2,
3650: p_sender_component IN OUT NOCOPY VARCHAR2,
3651: p_xml_event_key IN OUT NOCOPY VARCHAR2,
3652: p_collaboration_standard IN OUT NOCOPY VARCHAR2)
3653:
3654: IS
3655:
3656: l_error_code NUMBER;

Line 3667: l_collaboration_standard VARCHAR2(30);

3663: l_xmlg_transaction_subtype VARCHAR2(100);
3664: l_xmlg_int_transaction_type VARCHAR2(100);
3665: l_xmlg_int_transaction_subtype VARCHAR2(100);
3666: l_xmlg_document_id VARCHAR2(256);
3667: l_collaboration_standard VARCHAR2(30);
3668:
3669: l_xml_event_key VARCHAR2(240);
3670:
3671: l_doc_dir VARCHAR2(240);

Line 3681: l_xmlg_msg_standard VARCHAR2(100);

3677: l_txn_partner_id VARCHAR2(256);
3678: l_txn_partner_site VARCHAR2(256);
3679:
3680: l_sender_component VARCHAR2(500);
3681: l_xmlg_msg_standard VARCHAR2(100);
3682: l_xmlg_msg_type VARCHAR2(100);
3683: l_enhanced_combination_key BOOLEAN DEFAULT FALSE;
3684:
3685: BEGIN

Line 3714: ecx_cln_debug_pub.Add('Collab Standard ----- >>>'||p_collaboration_standard,1);

3710: ecx_cln_debug_pub.Add('TRADING PARTNER ID ----- >>>'||p_tr_partner_id,1);
3711: ecx_cln_debug_pub.Add('TRADING PARTNER SITE ----- >>>'||p_tr_partner_site,1);
3712: ecx_cln_debug_pub.Add('SENDER COMPONENT ----- >>>'||p_sender_component,1);
3713: ecx_cln_debug_pub.Add('XMLG EVENT KEY ----- >>>'||p_xml_event_key,1);
3714: ecx_cln_debug_pub.Add('Collab Standard ----- >>>'||p_collaboration_standard,1);
3715: ecx_cln_debug_pub.Add('===========================================',1);
3716: END IF;
3717:
3718:

Line 3723: l_xmlg_msg_standard := p_collaboration_standard;

3719:
3720: -- assigning values to local variables for transaction tyoe/subtype
3721: l_xmlg_transaction_type := p_xmlg_transaction_type;
3722: l_xmlg_transaction_subtype := p_xmlg_transaction_subtype;
3723: l_xmlg_msg_standard := p_collaboration_standard;
3724:
3725: -- Check if we need to call an API to get the trading partner set up details
3726: IF ( (p_xmlg_internal_control_number IS NULL)
3727: OR (p_xmlg_msg_id IS NULL)

Line 3737: OR (p_collaboration_standard IS NULL)

3733: OR (p_tr_partner_id IS NULL)
3734: OR (p_tr_partner_site IS NULL)
3735: OR (p_sender_component IS NULL)
3736: OR (p_xml_event_key IS NULL)
3737: OR (p_collaboration_standard IS NULL)
3738: ) THEN
3739:
3740: BEGIN
3741: IF (l_Debug_Level <= 1) THEN

Line 3749: message_standard, message_type, event_key

3745:
3746: IF (p_xmlg_msg_id is not null ) THEN
3747: SELECT internal_control_number, msgid, transaction_type, transaction_subtype,
3748: document_number, party_type, partyid, party_site_id, direction, protocol_type,
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

Line 3752: l_xmlg_msg_standard, l_xmlg_msg_type, l_xml_event_key

3748: document_number, party_type, partyid, party_site_id, direction, protocol_type,
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,

Line 3758: message_standard, message_type, event_key

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,
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

Line 3761: l_tr_partner_site, l_doc_dir, l_sender_component, l_xmlg_msg_standard, l_xmlg_msg_type, l_xml_event_key

3757: document_number, party_type, partyid, party_site_id, direction, protocol_type,
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,

Line 3767: message_standard, message_type, event_key

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,
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

Line 3770: l_tr_partner_site, l_doc_dir, l_sender_component, l_xmlg_msg_standard, l_xmlg_msg_type, l_xml_event_key

3766: document_number, party_type, partyid, party_site_id, direction, protocol_type,
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

Line 3780: doclogs.protocol_type, doclogs.message_standard, doclogs.message_type, doclogs.event_key

3776: AND (event_key is null or p_xml_event_key is null or event_key = p_xml_event_key);
3777: ELSIF (p_xmlg_int_transaction_type is not null and p_xmlg_int_transaction_subtype is not null and p_xmlg_document_id IS not NULL) THEN
3778: SELECT doclogs.internal_control_number, doclogs.msgid, doclogs.transaction_type, doclogs.transaction_subtype,
3779: doclogs.document_number, doclogs.party_type, doclogs.partyid, doclogs.party_site_id, doclogs.direction,
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

Line 3783: l_sender_component, l_xmlg_msg_standard, l_xmlg_msg_type, l_xml_event_key

3779: doclogs.document_number, doclogs.party_type, doclogs.partyid, doclogs.party_site_id, doclogs.direction,
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

Line 3823: ecx_cln_debug_pub.Add('XMLG MESSAGE STANDARD ID ----- >>>'||l_xmlg_msg_standard,1);

3819: ecx_cln_debug_pub.Add('TRADING PARTNER TYPE ----- >>>'||l_tr_partner_type,1);
3820: ecx_cln_debug_pub.Add('TRADING PARTNER ID ----- >>>'||l_tr_partner_id,1);
3821: ecx_cln_debug_pub.Add('TRADING PARTNER SITE ----- >>>'||l_tr_partner_site,1);
3822: ecx_cln_debug_pub.Add('SENDER COMPONENT ----- >>>'||l_sender_component,1);
3823: ecx_cln_debug_pub.Add('XMLG MESSAGE STANDARD ID ----- >>>'||l_xmlg_msg_standard,1);
3824: ecx_cln_debug_pub.Add('XMLG EVENT KEY ----- >>>'||l_xml_event_key,1);
3825: ecx_cln_debug_pub.Add('===========================================',1);
3826: END IF;
3827:

Line 3831: IF ((l_xmlg_transaction_type IS NULL) OR (l_xmlg_transaction_subtype IS NULL) OR (l_xmlg_msg_standard IS NULL ) ) THEN

3827:
3828:
3829: -- Getting External Transaction type and Subtype associated with Internal transaction type
3830: -- and Internal transaction subtype
3831: IF ((l_xmlg_transaction_type IS NULL) OR (l_xmlg_transaction_subtype IS NULL) OR (l_xmlg_msg_standard IS NULL ) ) THEN
3832: IF (l_Debug_Level <= 1) THEN
3833: ecx_cln_debug_pub.Add('Getting values for External Transaction type and SubType and msg standard',1);
3834: END IF;
3835:

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

3829: -- Getting External Transaction type and Subtype associated with Internal transaction type
3830: -- and Internal transaction subtype
3831: IF ((l_xmlg_transaction_type IS NULL) OR (l_xmlg_transaction_subtype IS NULL) OR (l_xmlg_msg_standard IS NULL ) ) THEN
3832: IF (l_Debug_Level <= 1) THEN
3833: ecx_cln_debug_pub.Add('Getting values for External Transaction type and SubType and msg standard',1);
3834: END IF;
3835:
3836: BEGIN
3837: SELECT ecxproc.EXT_TYPE,ecxproc.EXT_SUBTYPE, estd.standard_code

Line 3837: SELECT ecxproc.EXT_TYPE,ecxproc.EXT_SUBTYPE, estd.standard_code

3833: ecx_cln_debug_pub.Add('Getting values for External Transaction type and SubType and msg standard',1);
3834: END IF;
3835:
3836: BEGIN
3837: SELECT ecxproc.EXT_TYPE,ecxproc.EXT_SUBTYPE, estd.standard_code
3838: INTO l_xmlg_transaction_type, l_xmlg_transaction_subtype, l_xmlg_msg_standard
3839: FROM ecx_tp_headers eth, ecx_tp_details etd, ECX_TRANSACTIONS ecxtrans, ECX_EXT_PROCESSES ecxproc, ecx_standards estd
3840: WHERE eth.party_id = p_tr_partner_id
3841: AND eth.party_site_id = p_tr_partner_site

Line 3838: INTO l_xmlg_transaction_type, l_xmlg_transaction_subtype, l_xmlg_msg_standard

3834: END IF;
3835:
3836: BEGIN
3837: SELECT ecxproc.EXT_TYPE,ecxproc.EXT_SUBTYPE, estd.standard_code
3838: INTO l_xmlg_transaction_type, l_xmlg_transaction_subtype, l_xmlg_msg_standard
3839: FROM ecx_tp_headers eth, ecx_tp_details etd, ECX_TRANSACTIONS ecxtrans, ECX_EXT_PROCESSES ecxproc, ecx_standards estd
3840: WHERE eth.party_id = p_tr_partner_id
3841: AND eth.party_site_id = p_tr_partner_site
3842: AND eth.party_type = nvl(l_tr_partner_type, eth.party_type)

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

3835:
3836: BEGIN
3837: SELECT ecxproc.EXT_TYPE,ecxproc.EXT_SUBTYPE, estd.standard_code
3838: INTO l_xmlg_transaction_type, l_xmlg_transaction_subtype, l_xmlg_msg_standard
3839: FROM ecx_tp_headers eth, ecx_tp_details etd, ECX_TRANSACTIONS ecxtrans, ECX_EXT_PROCESSES ecxproc, ecx_standards estd
3840: WHERE eth.party_id = p_tr_partner_id
3841: AND eth.party_site_id = p_tr_partner_site
3842: AND eth.party_type = nvl(l_tr_partner_type, eth.party_type)
3843: AND eth.tp_header_id = etd.tp_header_id

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

3845: AND ecxtrans.transaction_id = ecxproc.transaction_id
3846: AND ecxtrans.transaction_type = nvl(p_xmlg_int_transaction_type,l_xmlg_int_transaction_type)
3847: AND ecxtrans.transaction_subtype = nvl(p_xmlg_int_transaction_subtype,l_xmlg_int_transaction_subtype)
3848: AND ecxproc.direction = nvl(p_doc_dir,ecxproc.direction)
3849: AND estd.standard_id = ecxproc.standard_id;
3850:
3851: IF (l_Debug_Level <= 1) THEN
3852: ecx_cln_debug_pub.Add('====Parameters Received From ECX_TRANSACTIONS/ECX_EXT_PROCESSES====',1);
3853: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION TYPE ----- >>>'||l_xmlg_transaction_type,1);

Line 3855: ecx_cln_debug_pub.Add('XMLG Message Standard ----- >>>'||l_xmlg_msg_standard,1);

3851: IF (l_Debug_Level <= 1) THEN
3852: ecx_cln_debug_pub.Add('====Parameters Received From ECX_TRANSACTIONS/ECX_EXT_PROCESSES====',1);
3853: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION TYPE ----- >>>'||l_xmlg_transaction_type,1);
3854: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION SUBTYPE ----- >>>'||l_xmlg_transaction_subtype,1);
3855: ecx_cln_debug_pub.Add('XMLG Message Standard ----- >>>'||l_xmlg_msg_standard,1);
3856: ecx_cln_debug_pub.Add('==================================================================',1);
3857: END IF;
3858:
3859:

Line 3926: p_collaboration_standard := NVL(p_collaboration_standard, l_xmlg_msg_standard);

3922: p_xmlg_document_id := NVL(p_xmlg_document_id,l_xmlg_document_id);
3923: p_doc_dir := NVL(p_doc_dir,l_doc_dir);
3924: p_sender_component := NVL(p_sender_component,l_sender_component);
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

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

3924: p_sender_component := NVL(p_sender_component,l_sender_component);
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);

Line 3936: SELECT eth.party_id, eth.party_site_id, eth.party_type, estd.standard_code

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;
3934:
3935:
3936: SELECT eth.party_id, eth.party_site_id, eth.party_type, estd.standard_code
3937: INTO l_txn_partner_id, l_txn_partner_site, l_txn_partner_type, l_xmlg_msg_standard
3938: FROM ecx_ext_processes eep, ecx_tp_details etd, ecx_tp_headers eth, ecx_standards estd
3939: WHERE eep.ext_type = l_xmlg_transaction_type
3940: AND eep.ext_subtype = l_xmlg_transaction_subtype

Line 3937: INTO l_txn_partner_id, l_txn_partner_site, l_txn_partner_type, l_xmlg_msg_standard

3933: END IF;
3934:
3935:
3936: SELECT eth.party_id, eth.party_site_id, eth.party_type, estd.standard_code
3937: INTO l_txn_partner_id, l_txn_partner_site, l_txn_partner_type, l_xmlg_msg_standard
3938: FROM ecx_ext_processes eep, ecx_tp_details etd, ecx_tp_headers eth, ecx_standards estd
3939: WHERE eep.ext_type = l_xmlg_transaction_type
3940: AND eep.ext_subtype = l_xmlg_transaction_subtype
3941: AND eep.standard_id = estd.standard_id

Line 3938: FROM ecx_ext_processes eep, ecx_tp_details etd, ecx_tp_headers eth, ecx_standards estd

3934:
3935:
3936: SELECT eth.party_id, eth.party_site_id, eth.party_type, estd.standard_code
3937: INTO l_txn_partner_id, l_txn_partner_site, l_txn_partner_type, l_xmlg_msg_standard
3938: FROM ecx_ext_processes eep, ecx_tp_details etd, ecx_tp_headers eth, ecx_standards estd
3939: WHERE eep.ext_type = l_xmlg_transaction_type
3940: AND eep.ext_subtype = l_xmlg_transaction_subtype
3941: AND eep.standard_id = estd.standard_id
3942: AND estd.standard_code = l_xmlg_msg_standard

Line 3941: AND eep.standard_id = estd.standard_id

3937: INTO l_txn_partner_id, l_txn_partner_site, l_txn_partner_type, l_xmlg_msg_standard
3938: FROM ecx_ext_processes eep, ecx_tp_details etd, ecx_tp_headers eth, ecx_standards estd
3939: WHERE eep.ext_type = l_xmlg_transaction_type
3940: AND eep.ext_subtype = l_xmlg_transaction_subtype
3941: AND eep.standard_id = estd.standard_id
3942: AND estd.standard_code = l_xmlg_msg_standard
3943: AND eep.ext_process_id = etd.ext_process_id
3944: AND etd.source_tp_location_code = l_tr_partner_site
3945: AND eep.direction = l_doc_dir

Line 3942: AND estd.standard_code = l_xmlg_msg_standard

3938: FROM ecx_ext_processes eep, ecx_tp_details etd, ecx_tp_headers eth, ecx_standards estd
3939: WHERE eep.ext_type = l_xmlg_transaction_type
3940: AND eep.ext_subtype = l_xmlg_transaction_subtype
3941: AND eep.standard_id = estd.standard_id
3942: AND estd.standard_code = l_xmlg_msg_standard
3943: AND eep.ext_process_id = etd.ext_process_id
3944: AND etd.source_tp_location_code = l_tr_partner_site
3945: AND eep.direction = l_doc_dir
3946: AND eth.party_type = NVL(l_tr_partner_type,eth.party_type)

Line 3948: AND estd.standard_type = l_xmlg_msg_type;

3944: AND etd.source_tp_location_code = l_tr_partner_site
3945: AND eep.direction = l_doc_dir
3946: AND eth.party_type = NVL(l_tr_partner_type,eth.party_type)
3947: AND eth.tp_header_id = etd.tp_header_id
3948: AND estd.standard_type = l_xmlg_msg_type;
3949:
3950: IF (l_Debug_Level <= 1) THEN
3951: ecx_cln_debug_pub.Add('-- After SQL query ----',1);
3952: END IF;

Line 3960: ecx_cln_debug_pub.Add('Message Standard ----- >>>'||l_xmlg_msg_standard,1);

3956: ecx_cln_debug_pub.Add('====Trading Partner Parameters Changed To IDs Using ecx_ext_processes /ecx_tp_details /ecx_tp_headers =====',1);
3957: ecx_cln_debug_pub.Add('TRADING PARTNER TYPE ----- >>>'||l_txn_partner_id,1);
3958: ecx_cln_debug_pub.Add('TRADING PARTNER ID ----- >>>'||l_txn_partner_site,1);
3959: ecx_cln_debug_pub.Add('TRADING PARTNER SITE ----- >>>'||l_txn_partner_type,1);
3960: ecx_cln_debug_pub.Add('Message Standard ----- >>>'||l_xmlg_msg_standard,1);
3961: ecx_cln_debug_pub.Add('===========================================================================',1);
3962: END IF;
3963:
3964:

Line 3975: SELECT eth.party_id, eth.party_site_id, eth.party_type, estd.standard_code

3971: ecx_cln_debug_pub.Add('Trying to find details without considering party type',1);
3972: END IF;
3973:
3974: BEGIN
3975: SELECT eth.party_id, eth.party_site_id, eth.party_type, estd.standard_code
3976: INTO l_txn_partner_id, l_txn_partner_site, l_txn_partner_type, l_xmlg_msg_standard
3977: FROM ecx_ext_processes eep, ecx_tp_details etd, ecx_tp_headers eth, ecx_standards estd
3978: WHERE eep.ext_type = l_xmlg_transaction_type
3979: AND eep.ext_subtype = l_xmlg_transaction_subtype

Line 3976: INTO l_txn_partner_id, l_txn_partner_site, l_txn_partner_type, l_xmlg_msg_standard

3972: END IF;
3973:
3974: BEGIN
3975: SELECT eth.party_id, eth.party_site_id, eth.party_type, estd.standard_code
3976: INTO l_txn_partner_id, l_txn_partner_site, l_txn_partner_type, l_xmlg_msg_standard
3977: FROM ecx_ext_processes eep, ecx_tp_details etd, ecx_tp_headers eth, ecx_standards estd
3978: WHERE eep.ext_type = l_xmlg_transaction_type
3979: AND eep.ext_subtype = l_xmlg_transaction_subtype
3980: AND eep.standard_id = estd.standard_id

Line 3977: FROM ecx_ext_processes eep, ecx_tp_details etd, ecx_tp_headers eth, ecx_standards estd

3973:
3974: BEGIN
3975: SELECT eth.party_id, eth.party_site_id, eth.party_type, estd.standard_code
3976: INTO l_txn_partner_id, l_txn_partner_site, l_txn_partner_type, l_xmlg_msg_standard
3977: FROM ecx_ext_processes eep, ecx_tp_details etd, ecx_tp_headers eth, ecx_standards estd
3978: WHERE eep.ext_type = l_xmlg_transaction_type
3979: AND eep.ext_subtype = l_xmlg_transaction_subtype
3980: AND eep.standard_id = estd.standard_id
3981: AND estd.standard_code = l_xmlg_msg_standard

Line 3980: AND eep.standard_id = estd.standard_id

3976: INTO l_txn_partner_id, l_txn_partner_site, l_txn_partner_type, l_xmlg_msg_standard
3977: FROM ecx_ext_processes eep, ecx_tp_details etd, ecx_tp_headers eth, ecx_standards estd
3978: WHERE eep.ext_type = l_xmlg_transaction_type
3979: AND eep.ext_subtype = l_xmlg_transaction_subtype
3980: AND eep.standard_id = estd.standard_id
3981: AND estd.standard_code = l_xmlg_msg_standard
3982: AND eep.ext_process_id = etd.ext_process_id
3983: AND etd.source_tp_location_code = l_tr_partner_site
3984: AND eep.direction = l_doc_dir

Line 3981: AND estd.standard_code = l_xmlg_msg_standard

3977: FROM ecx_ext_processes eep, ecx_tp_details etd, ecx_tp_headers eth, ecx_standards estd
3978: WHERE eep.ext_type = l_xmlg_transaction_type
3979: AND eep.ext_subtype = l_xmlg_transaction_subtype
3980: AND eep.standard_id = estd.standard_id
3981: AND estd.standard_code = l_xmlg_msg_standard
3982: AND eep.ext_process_id = etd.ext_process_id
3983: AND etd.source_tp_location_code = l_tr_partner_site
3984: AND eep.direction = l_doc_dir
3985: AND eth.tp_header_id = etd.tp_header_id

Line 3986: AND estd.standard_type = l_xmlg_msg_type;

3982: AND eep.ext_process_id = etd.ext_process_id
3983: AND etd.source_tp_location_code = l_tr_partner_site
3984: AND eep.direction = l_doc_dir
3985: AND eth.tp_header_id = etd.tp_header_id
3986: AND estd.standard_type = l_xmlg_msg_type;
3987: EXCEPTION
3988: WHEN OTHERS THEN
3989: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TP_DETAILS_NOT_FOUND');
3990: x_msg_data := FND_MESSAGE.GET;

Line 4008: p_collaboration_standard := NVL(p_collaboration_standard,l_xmlg_msg_standard);

4004: END;
4005: p_tr_partner_type := NVL(p_tr_partner_type,l_txn_partner_type);
4006: p_tr_partner_id := NVL(p_tr_partner_id,l_txn_partner_id);
4007: p_tr_partner_site := NVL(p_tr_partner_site,l_txn_partner_site);
4008: p_collaboration_standard := NVL(p_collaboration_standard,l_xmlg_msg_standard);
4009: END IF;
4010: ELSE
4011: x_return_status := FND_API.G_RET_STS_SUCCESS;
4012: FND_MESSAGE.SET_NAME('CLN','CLN_CH_API_CALL_NOT_REQD');

Line 4037: ecx_cln_debug_pub.Add('Message Standard ----- >>>'||p_collaboration_standard,1);

4033: ecx_cln_debug_pub.Add('TRADING PARTNER ID ----- >>>'||p_tr_partner_id,1);
4034: ecx_cln_debug_pub.Add('TRADING PARTNER SITE ----- >>>'||p_tr_partner_site,1);
4035: ecx_cln_debug_pub.Add('SENDER COMPONENT ----- >>>'||p_sender_component,1);
4036: ecx_cln_debug_pub.Add('XMLG EVENT KEY ----- >>>'||p_xml_event_key,1);
4037: ecx_cln_debug_pub.Add('Message Standard ----- >>>'||p_collaboration_standard,1);
4038: ecx_cln_debug_pub.Add('=============================================================',1);
4039: END IF;
4040:
4041:

Line 4261: p_coll_standard IN VARCHAR2

4257: p_doc_status IN VARCHAR2,
4258: p_doc_type IN VARCHAR2,
4259: p_doc_dir IN VARCHAR2,
4260: p_coll_id IN NUMBER,
4261: p_coll_standard IN VARCHAR2
4262: )
4263:
4264: IS
4265: l_error_code NUMBER;

Line 4291: ecx_cln_debug_pub.Add('COLL STANDARD ----- >>>'||p_coll_standard,1);

4287: IF (l_Debug_Level <= 1) THEN
4288: ecx_cln_debug_pub.Add('------------Parameters Received-------------',1);
4289: ecx_cln_debug_pub.Add('APPLCATION ID ----- >>>'||p_app_id,1);
4290: ecx_cln_debug_pub.Add('COLL TYPE ----- >>>'||p_coll_type,1);
4291: ecx_cln_debug_pub.Add('COLL STANDARD ----- >>>'||p_coll_standard,1);
4292: ecx_cln_debug_pub.Add('DOC STATUS ----- >>>'||p_doc_status,1);
4293: ecx_cln_debug_pub.Add('DOC TYPE ----- >>>'||p_doc_type,1);
4294: ecx_cln_debug_pub.Add('DOC DIRECTION ----- >>>'||p_doc_dir,1);
4295: ecx_cln_debug_pub.Add('COLLABORATION ID ----- >>>'||p_coll_id,1);

Line 4328: AND nvl(collaboration_standard,nvl(p_coll_standard,'~')) = nvl(p_coll_standard,'~')

4324: INTO l_message_count
4325: FROM CLN_COLL_COMPLETED_STATUS
4326: WHERE application_id = p_app_id
4327: AND collaboration_type = p_coll_type
4328: AND nvl(collaboration_standard,nvl(p_coll_standard,'~')) = nvl(p_coll_standard,'~')
4329: AND document_type = p_doc_type
4330: AND document_direction = p_doc_dir;
4331:
4332: IF (l_Debug_Level <= 1) THEN

Line 4441: p_collaboration_standard IN VARCHAR2)

4437: p_unique4 IN VARCHAR2,
4438: p_unique5 IN VARCHAR2,
4439: p_xmlg_internal_control_number IN NUMBER,
4440: p_xml_event_key IN VARCHAR2,
4441: p_collaboration_standard IN VARCHAR2)
4442: IS
4443: l_error_code NUMBER;
4444: l_error_msg VARCHAR2(2000);
4445: l_msg_data VARCHAR2(2000);

Line 4642: IF (p_doc_dir = 'OUT') and (p_xmlg_msg_id IS NOT NULL) and (p_collaboration_standard is not null) THEN

4638:
4639: RETURN;
4640: END IF;
4641:
4642: IF (p_doc_dir = 'OUT') and (p_xmlg_msg_id IS NOT NULL) and (p_collaboration_standard is not null) THEN
4643: IF (l_Debug_Level <= 1) THEN
4644: ecx_cln_debug_pub.Add('----- Finding Collaboration ID using the reference id of the payload and then FIELD7 of doclogs',1);
4645: END IF;
4646:

Line 4647: GET_DATA_AREA_REFID(p_xmlg_msg_id,p_collaboration_standard,l_data_area_refid, p_app_id, p_coll_type);

4643: IF (l_Debug_Level <= 1) THEN
4644: ecx_cln_debug_pub.Add('----- Finding Collaboration ID using the reference id of the payload and then FIELD7 of doclogs',1);
4645: END IF;
4646:
4647: GET_DATA_AREA_REFID(p_xmlg_msg_id,p_collaboration_standard,l_data_area_refid, p_app_id, p_coll_type);
4648:
4649: IF (l_Debug_Level <= 1) THEN
4650: ecx_cln_debug_pub.Add('Data area reference id got as : ' || l_data_area_refid ,1);
4651: END IF;

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

Line 4669: AND eep.standard_id = estd.standard_id

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
4670: AND estd.standard_code = doclogs.message_standard
4671: AND eep.ext_process_id = etd.ext_process_id
4672: AND etd.source_tp_location_code = doclogs.party_site_id
4673: AND eep.direction = doclogs.direction

Line 4670: AND estd.standard_code = doclogs.message_standard

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
4670: AND estd.standard_code = doclogs.message_standard
4671: AND eep.ext_process_id = etd.ext_process_id
4672: AND etd.source_tp_location_code = doclogs.party_site_id
4673: AND eep.direction = doclogs.direction
4674: --AND eth.party_type = NVL(doclogs.party_type,eth.party_type)

Line 4676: AND estd.standard_type = doclogs.message_type

4672: AND etd.source_tp_location_code = doclogs.party_site_id
4673: AND eep.direction = doclogs.direction
4674: --AND eth.party_type = NVL(doclogs.party_type,eth.party_type)
4675: AND eth.tp_header_id = etd.tp_header_id
4676: AND estd.standard_type = doclogs.message_type
4677: AND eth.party_id = p_tr_partner_id
4678: AND eth.party_site_id = p_tr_partner_site
4679: AND eth.party_type = p_tr_partner_type;
4680: IF (l_Debug_Level <= 1) THEN

Line 4824: p_collaboration_standard IN VARCHAR2,

4820: p_doc_owner IN VARCHAR2,
4821: p_xmlg_int_transaction_type IN VARCHAR2,
4822: p_xmlg_int_transaction_subtype IN VARCHAR2,
4823: p_xml_event_key IN VARCHAR2,
4824: p_collaboration_standard IN VARCHAR2,
4825: p_attribute1 IN VARCHAR2,
4826: p_attribute2 IN VARCHAR2,
4827: p_attribute3 IN VARCHAR2,
4828: p_attribute4 IN VARCHAR2,

Line 4866: l_collaboration_standard VARCHAR2(30);

4862: l_tr_partner_type VARCHAR2(30);
4863: l_tr_partner_id VARCHAR2(256);
4864: l_tr_partner_site VARCHAR2(256);
4865: l_sender_component VARCHAR2(500);
4866: l_collaboration_standard VARCHAR2(30);
4867: l_app_id VARCHAR2(10);
4868: l_coll_type VARCHAR2(30);
4869: l_doc_type VARCHAR2(100);
4870:

Line 4933: ecx_cln_debug_pub.Add('Collaboration Standard ----- >>>'||p_collaboration_standard,1);

4929: ecx_cln_debug_pub.Add('INIT DATE ----- >>>'||p_init_date,1);
4930: ecx_cln_debug_pub.Add('DOCUMENT OWNER ----- >>>'||p_doc_owner,1);
4931: ecx_cln_debug_pub.Add('OWNER ROLE ----- >>>'||p_owner_role,1);
4932: ecx_cln_debug_pub.Add('XMLG EVENT KEY ----- >>>'||p_xml_event_key,1);
4933: ecx_cln_debug_pub.Add('Collaboration Standard ----- >>>'||p_collaboration_standard,1);
4934: ecx_cln_debug_pub.Add('ATTRIBUTE1 ----- >>>'||p_attribute1,1);
4935: ecx_cln_debug_pub.Add('ATTRIBUTE2 ----- >>>'||p_attribute2,1);
4936: ecx_cln_debug_pub.Add('ATTRIBUTE3 ----- >>>'||p_attribute3,1);
4937: ecx_cln_debug_pub.Add('ATTRIBUTE4 ----- >>>'||p_attribute4,1);

Line 4974: l_collaboration_standard := p_collaboration_standard;

4970: l_tr_partner_site := p_tr_partner_site;
4971: l_doc_dir := p_doc_dir;
4972: l_sender_component := p_sender_component;
4973: l_xml_event_key := p_xml_event_key;
4974: l_collaboration_standard := p_collaboration_standard;
4975:
4976: -- call the API to get the trading partner set up details
4977: IF (l_Debug_Level <= 1) THEN
4978: ecx_cln_debug_pub.Add('==========Call to GET_TRADING_PARTNER_DETAILS API=============',1);

Line 4998: p_collaboration_standard => l_collaboration_standard);

4994: p_tr_partner_id => l_tr_partner_id,
4995: p_tr_partner_site => l_tr_partner_site,
4996: p_sender_component => l_sender_component,
4997: p_xml_event_key => l_xml_event_key,
4998: p_collaboration_standard => l_collaboration_standard);
4999:
5000: IF ( x_return_status <> 'S') THEN
5001: l_msg_data := 'Error in GET_TRADING_PARTNER_DETAILS ';
5002: -- x_msg_data is set to appropriate value by GET_TRADING_PARTNER_DETAILS

Line 5054: p_collaboration_standard => l_collaboration_standard);

5050: p_unique4 => p_unique4,
5051: p_unique5 => p_unique5,
5052: p_xmlg_internal_control_number => l_xmlg_internal_control_number,
5053: p_xml_event_key => l_xml_event_key,
5054: p_collaboration_standard => l_collaboration_standard);
5055:
5056: IF ( x_return_status <> 'S') THEN
5057: l_msg_data := 'Error in FIND_COLLABORATION_ID';
5058: -- x_msg_data is set to appropriate value by FIND_COLLABORATION_ID

Line 5115: p_collaboration_standard => l_collaboration_standard,

5111: p_xmlg_int_transaction_type => l_xmlg_int_transaction_type,
5112: p_xmlg_int_transaction_subtype => l_xmlg_int_transaction_subtype,
5113: p_msg_text => p_msg_text,
5114: p_xml_event_key => l_xml_event_key,
5115: p_collaboration_standard => l_collaboration_standard,
5116: p_attribute1 => p_attribute1,
5117: p_attribute2 => p_attribute2,
5118: p_attribute3 => p_attribute3,
5119: p_attribute4 => p_attribute4,

Line 5214: p_collaboration_standard => l_collaboration_standard,

5210: p_doc_owner => p_doc_owner,
5211: p_xmlg_int_transaction_type => l_xmlg_int_transaction_type,
5212: p_xmlg_int_transaction_subtype => l_xmlg_int_transaction_subtype,
5213: p_xml_event_key => l_xml_event_key,
5214: p_collaboration_standard => l_collaboration_standard,
5215: p_attribute1 => p_attribute1,
5216: p_attribute2 => p_attribute2,
5217: p_attribute3 => p_attribute3,
5218: p_attribute4 => p_attribute4,