DBA Data[Home] [Help]

APPS.ECX_STANDARD dependencies on STANDARD

Line 1: package body ECX_STANDARD as

1: package body ECX_STANDARD as
2: -- $Header: ECXWACTB.pls 120.1.12010000.2 2008/11/18 18:11:43 cpeixoto ship $
3:
4: /** bug 3357213 */
5: /**

Line 10: G_PKG_NAME CONSTANT VARCHAR2(15):= 'ECX_STANDARD';

6: * Other errors
7: */
8: PROCESSOR_ERR CONSTANT NUMBER := -20100;
9: NULL_ERR CONSTANT NUMBER := -20103;
10: G_PKG_NAME CONSTANT VARCHAR2(15):= 'ECX_STANDARD';
11: /** bug 3357213 */
12:
13: MAX_JAVA_MEMORY CONSTANT NUMBER := 1 * 1024 * 1024 *1024; -- bug 6889689
14:

Line 221: wf_core.context('ECX_STANDARD','XMLtoXMLCover',i_map_code,i_debug_level);

217: END IF;
218: end if;
219: exception
220: when others then
221: wf_core.context('ECX_STANDARD','XMLtoXMLCover',i_map_code,i_debug_level);
222: raise;
223: end XMLtoXMLCover;
224:
225: procedure processXMLCover

Line 284: wf_core.context('ECX_STANDARD','processXMLCover',i_map_code,i_debug_level);

280: END IF;
281: end if;
282: exception
283: when others then
284: wf_core.context('ECX_STANDARD','processXMLCover',i_map_code,i_debug_level);
285: raise;
286: end processXMLCover;
287:
288: procedure getXMLCover

Line 290: i_message_standard IN VARCHAR2 default null,

286: end processXMLCover;
287:
288: procedure getXMLCover
289: (
290: i_message_standard IN VARCHAR2 default null,
291: i_transaction_type IN VARCHAR2 default null,
292: i_transaction_subtype IN VARCHAR2 default null,
293: i_tp_type IN VARCHAR2 default null,
294: i_tp_id IN VARCHAR2 default null,

Line 310: i_message_standard => i_message_standard,

306: g_instlmode varchar2(100);
307: begin
308: ecx_outbound.getXML
309: (
310: i_message_standard => i_message_standard,
311: i_map_code => i_map_code,
312: i_transaction_type => i_transaction_type,
313: i_transaction_subtype => i_transaction_subtype,
314: i_tp_type => i_tp_type,

Line 360: wf_core.context('ECX_STANDARD','getXMLCover',i_message_standard,i_transaction_type,i_transaction_subtype);

356: END IF;
357: end if;
358: exception
359: when others then
360: wf_core.context('ECX_STANDARD','getXMLCover',i_message_standard,i_transaction_type,i_transaction_subtype);
361: raise;
362: end getXMLCover;
363:
364: /** (Synchronous) Send Direct api to avoid racing condition **/

Line 429: wf_core.context('ECX_STANDARD','sendDirectCover',transaction_type,transaction_subtype);

425: END IF;
426: end if;
427: exception
428: when others then
429: wf_core.context('ECX_STANDARD','sendDirectCover',transaction_type,transaction_subtype);
430: raise;
431: end sendDirectCover;
432:
433:

Line 435: -- Standard XML Gateway Raise Event

431: end sendDirectCover;
432:
433:
434: -- setEventDetails (PUBLIC)
435: -- Standard XML Gateway Raise Event
436: -- IN:
437: -- eventname - Event to be processes
438: -- eventkey - Event key
439: -- parameter1..10 - Event Parameters

Line 506: -- Standard XML Gateway to generate event data

502: end setEventDetails;
503:
504:
505: -- Generate (PUBLIC)
506: -- Standard XML Gateway to generate event data
507: -- IN:
508: -- p_event_name - Event to be processes
509: -- p_event_key - Event key
510: -- p_parameter_list - parameter list

Line 585: wf_core.context('ECX_STANDARD', 'Generate', p_event_name, p_event_key);

581: --dbms_lob.freetemporary(p_xmldoc);
582: return p_xmldoc;
583: exception
584: when others then
585: wf_core.context('ECX_STANDARD', 'Generate', p_event_name, p_event_key);
586: raise;
587: end Generate;
588:
589: -- XMLtoXML

Line 590: -- Standard Workflow Activity XMLtoXML

586: raise;
587: end Generate;
588:
589: -- XMLtoXML
590: -- Standard Workflow Activity XMLtoXML
591: -- Processes a given XML. The Output is an XML /a API call.
592: -- OUT
593: -- result - null
594: -- ACTIVITY ATTRIBUTES REFERENCED

Line 690: Wf_Core.Context('ECX_STANDARD', 'XMLtoXML',itemtype,itemkey, to_char(actid), funcmode);

686:
687: resultout := 'COMPLETE:';
688: exception
689: when others then
690: Wf_Core.Context('ECX_STANDARD', 'XMLtoXML',itemtype,itemkey, to_char(actid), funcmode);
691: raise;
692: end XMLtoXML;
693:
694: procedure ProcessXML(itemtype in varchar2,

Line 759: Wf_Core.Context('ECX_STANDARD', 'PROCESSXML',itemtype,itemkey, to_char(actid), funcmode);

755:
756: resultout := 'COMPLETE:';
757: exception
758: when others then
759: Wf_Core.Context('ECX_STANDARD', 'PROCESSXML',itemtype,itemkey, to_char(actid), funcmode);
760: raise;
761: end processXML;
762:
763: -- IsDeliveryRequired

Line 764: -- Standard ECX Workflow Activity

760: raise;
761: end processXML;
762:
763: -- IsDeliveryRequired
764: -- Standard ECX Workflow Activity
765: -- Determine if trading partner is enabled to recieve document
766: -- OUT
767: -- result - T - Trading Partner is enabled
768: -- F - Trading Partner is NOT enabled

Line 875: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);

871: resultout := 'COMPLETE:F';
872: end if;
873: exception
874: when ecx_document.ecx_transaction_not_defined then
875: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
876: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
877: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
878: wf_core.raise('ECX_TRANSACTION_NOT_DEFINED');
879: when ecx_document.ecx_delivery_setup_error then

Line 880: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);

876: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
877: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
878: wf_core.raise('ECX_TRANSACTION_NOT_DEFINED');
879: when ecx_document.ecx_delivery_setup_error then
880: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
881: wf_core.token('ECX_PARTY_ID', party_id);
882: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
883: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
884: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);

Line 888: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);

884: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
885: wf_core.raise('ECX_DELIVERY_SETUP_ERROR');
886:
887: when ecx_utils.program_exit then
888: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
889: g_instlmode := wf_core.translate('WF_INSTALL');
890: IF g_instlmode = 'EMBEDDED'
891: THEN
892: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,

Line 909: -- Standard ECX Workflow Activity

905: end isDeliveryRequired;
906:
907:
908: -- Send
909: -- Standard ECX Workflow Activity
910: -- Send Event to AQ for delivery
911: -- OUT
912: -- result - null
913: --

Line 1107: Wf_Core.Context('ECX_STANDARD', 'Send', itemtype, itemkey, to_char(actid), funcmode);

1103: end if;
1104:
1105: exception
1106: when others then
1107: Wf_Core.Context('ECX_STANDARD', 'Send', itemtype, itemkey, to_char(actid), funcmode);
1108: raise;
1109: end send;
1110:
1111: -- GetXMLTP

Line 1112: -- Standard ECX Workflow Activity

1108: raise;
1109: end send;
1110:
1111: -- GetXMLTP
1112: -- Standard ECX Workflow Activity
1113: -- Retrieve XML document
1114: -- OUT
1115: -- result - null
1116: --

Line 1162: p_message_standard varchar2(240);

1158: i_error_type pls_integer;
1159:
1160: p_party_type varchar2(240);
1161: p_message_type varchar2(240);
1162: p_message_standard varchar2(240);
1163: p_ext_type varchar2(240);
1164: p_ext_subtype varchar2(240);
1165: p_source_code varchar2(240);
1166: p_destination_code varchar2(240);

Line 1301: p_message_type, p_message_standard,

1297: party_id, party_site_id,
1298: document_id, ecx_utils.i_ret_code,
1299: ecx_utils.i_errbuf, trigger_id,
1300: p_party_type, p_party_id, p_party_site_id,
1301: p_message_type, p_message_standard,
1302: p_ext_type, p_ext_subtype, p_source_code,
1303: p_destination_code, p_destination_type,
1304: p_destination_address, p_username, p_password,
1305: p_map_code, p_queue_name, p_tp_header_id

Line 1362: i_message_standard => p_message_standard,

1358: end if;
1359:
1360: getXMLcover
1361: (
1362: i_message_standard => p_message_standard,
1363: i_map_code => p_map_code,
1364: i_transaction_type => transaction_type,
1365: i_transaction_subtype => transaction_subtype,
1366: i_tp_type => p_party_type,

Line 1389: ecx_utils.g_event.addParameterToList('MESSAGE_STANDARD', p_message_standard);

1385: ecx_utils.g_event.addParameterToList('PARTYID', p_party_id);
1386: ecx_utils.g_event.addParameterToList('PARTY_SITE_ID', p_source_code);
1387: ecx_utils.g_event.addParameterToList('DOCUMENT_NUMBER', ecx_utils.g_document_id);
1388: ecx_utils.g_event.addParameterToList('MESSAGE_TYPE', p_message_type);
1389: ecx_utils.g_event.addParameterToList('MESSAGE_STANDARD', p_message_standard);
1390: ecx_utils.g_event.addParameterToList('TRANSACTION_TYPE', p_ext_type);
1391: ecx_utils.g_event.addParameterToList('TRANSACTION_SUBTYPE', p_ext_subtype);
1392: ecx_utils.g_event.addParameterToList('PROTOCOL_TYPE', p_destination_type);
1393: ecx_utils.g_event.addParameterToList('PROTOCOL_ADDRESS', p_destination_address);

Line 1434: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);

1430: p_party_id, p_party_site_id, p_party_type,
1431: document_id, ecx_utils.i_ret_code, ecx_utils.i_errbuf
1432: );
1433:
1434: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1435: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
1436: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
1437: wf_core.raise('ECX_TRANSACTION_NOT_DEFINED');
1438: when ecx_document.ecx_no_delivery_required then

Line 1446: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);

1442: p_party_id, p_party_site_id, p_party_type,
1443: document_id, ecx_utils.i_ret_code, ecx_utils.i_errbuf
1444: );
1445:
1446: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1447: g_instlmode := wf_core.translate('WF_INSTALL');
1448: IF g_instlmode = 'EMBEDDED'
1449: THEN
1450: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,

Line 1468: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);

1464: p_party_id, p_party_site_id, p_party_type,
1465: document_id, ecx_utils.i_ret_code, ecx_utils.i_errbuf
1466: );
1467:
1468: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1469: wf_core.token('ECX_PARTY_ID', party_id);
1470: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
1471: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
1472: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);

Line 1482: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);

1478: p_party_id, p_party_site_id, p_party_type,
1479: document_id, ecx_utils.i_ret_code, ecx_utils.i_errbuf
1480: );
1481:
1482: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1483: wf_core.token('ECX_PARTY_ID', party_id);
1484: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
1485: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
1486: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);

Line 1496: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);

1492: p_party_id, p_party_site_id, p_party_type,
1493: document_id, ecx_utils.i_ret_code, ecx_utils.i_errbuf
1494: );
1495:
1496: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1497: g_instlmode := wf_core.translate('WF_INSTALL');
1498: IF g_instlmode = 'EMBEDDED'
1499: THEN
1500: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,

Line 1518: Wf_Core.Context('ECX_STANDARD', 'getXMLTP', itemtype, itemkey, to_char(actid), funcmode);

1514: p_party_id, p_party_site_id, p_party_type,
1515: document_id, ecx_utils.i_ret_code, ecx_utils.i_errbuf
1516: );
1517:
1518: Wf_Core.Context('ECX_STANDARD', 'getXMLTP', itemtype, itemkey, to_char(actid), funcmode);
1519: raise;
1520: end getXMLTP;
1521:
1522:

Line 1524: -- Standard ECX Workflow Activity

1520: end getXMLTP;
1521:
1522:
1523: -- GetXML
1524: -- Standard ECX Workflow Activity
1525: -- Retrieve XML document
1526: -- OUT
1527: -- result - null
1528: --

Line 1697: Wf_Core.Context('ECX_STANDARD', 'getXML', itemtype, itemkey, to_char(actid), funcmode);

1693: resultout := 'COMPLETE:';
1694:
1695: exception
1696: when others then
1697: Wf_Core.Context('ECX_STANDARD', 'getXML', itemtype, itemkey, to_char(actid), funcmode);
1698: raise;
1699: end getXML;
1700:
1701:

Line 1825: wf_core.context('ECX_STANDARD', 'Reprocess_Inbound',itemtype, itemkey, to_char(actid),funcmode,retcode, errmsg);

1821: return;
1822:
1823: exception
1824: when others then
1825: wf_core.context('ECX_STANDARD', 'Reprocess_Inbound',itemtype, itemkey, to_char(actid),funcmode,retcode, errmsg);
1826: raise;
1827: end Reprocess_Inbound;
1828:
1829: procedure resend

Line 1912: wf_core.context('ECX_STANDARD', 'ReSend',itemtype, itemkey, to_char(actid),funcmode,retcode, ecx_debug.getMessage(errmsg,ecx_utils.i_errparams));

1908: return;
1909:
1910: exception
1911: when others then
1912: wf_core.context('ECX_STANDARD', 'ReSend',itemtype, itemkey, to_char(actid),funcmode,retcode, ecx_debug.getMessage(errmsg,ecx_utils.i_errparams));
1913: raise;
1914: end resend;
1915:
1916: -- getEventDetails (PUBLIC)

Line 1917: -- Standard XML Gateway Event API

1913: raise;
1914: end resend;
1915:
1916: -- getEventDetails (PUBLIC)
1917: -- Standard XML Gateway Event API
1918: -- OUT:
1919: -- eventname - Event to the processes
1920: -- eventkey - Event key
1921: -- NOTE:

Line 1977: -- Standard XML Gateway Event API

1973: retmsg := substr(SQLERRM,1,200);
1974: end getEventDetails;
1975:
1976: -- getEventDetails (PUBLIC)
1977: -- Standard XML Gateway Event API
1978: -- OUT:
1979: -- eventname - Event to the processes
1980: -- eventkey - Event key
1981: -- NOTE:

Line 2209: i_retmsg:= SQLERRM || ' - ECX_STANDARD.PERFORM_XSLT_TRANSFORMATION';

2205: then
2206: xmldom.freeDocument(l_xml_doc);
2207: end if;
2208: when others then
2209: i_retmsg:= SQLERRM || ' - ECX_STANDARD.PERFORM_XSLT_TRANSFORMATION';
2210: i_retcode := 2;
2211:
2212: -- free all the used variables
2213: l_dtd_payload := null;

Line 2275: -- Standard call to check for call compatibility

2271: l_node XMLDOM.DOMNODE;
2272:
2273: INVALID_NODE_IN_NODELIST EXCEPTION;
2274: BEGIN
2275: -- Standard call to check for call compatibility
2276: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
2277: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
2278: END IF;
2279:

Line 2379: end ecx_standard;

2375: END GET_VALUE_FOR_XPATH;
2376:
2377: /** bug 3357213 */
2378:
2379: end ecx_standard;