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.ECX_STANDARD dependencies on STANDARD

Line 1: package body ECX_STANDARD as

1: package body ECX_STANDARD as
2: -- $Header: ECXWACTB.pls 120.15.12020000.2 2013/03/21 11:25:35 jmaddila 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 223: wf_core.context('ECX_STANDARD','XMLtoXMLCover',i_map_code,i_debug_level);

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

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

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

Line 292: i_message_standard IN VARCHAR2 default null,

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

Line 312: i_message_standard => i_message_standard,

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

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

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

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

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

Line 437: -- Standard XML Gateway Raise Event

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

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

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

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

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

Line 592: -- Standard Workflow Activity XMLtoXML

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

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

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

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

761: resultout := 'COMPLETE:';
762: end if;
763: exception
764: when others then
765: Wf_Core.Context('ECX_STANDARD', 'PROCESSXML',itemtype,itemkey, to_char(actid), funcmode);
766: raise;
767: end processXML;
768:
769: -- IsDeliveryRequired

Line 770: -- Standard ECX Workflow Activity

766: raise;
767: end processXML;
768:
769: -- IsDeliveryRequired
770: -- Standard ECX Workflow Activity
771: -- Determine if trading partner is enabled to recieve document
772: -- OUT
773: -- result - T - Trading Partner is enabled
774: -- F - Trading Partner is NOT enabled

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

877: resultout := 'COMPLETE:F';
878: end if;
879: exception
880: when ecx_document.ecx_transaction_not_defined then
881: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
882: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
883: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
884: wf_core.raise('ECX_TRANSACTION_NOT_DEFINED');
885: when ecx_document.ecx_delivery_setup_error then

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

882: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
883: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
884: wf_core.raise('ECX_TRANSACTION_NOT_DEFINED');
885: when ecx_document.ecx_delivery_setup_error then
886: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
887: wf_core.token('ECX_PARTY_ID', party_id);
888: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
889: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
890: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);

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

890: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
891: wf_core.raise('ECX_DELIVERY_SETUP_ERROR');
892:
893: when ecx_utils.program_exit then
894: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
895: g_instlmode := wf_core.translate('WF_INSTALL');
896: IF g_instlmode = 'EMBEDDED'
897: THEN
898: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,

Line 915: -- Standard ECX Workflow Activity

911: end isDeliveryRequired;
912:
913:
914: -- Send
915: -- Standard ECX Workflow Activity
916: -- Send Event to AQ for delivery
917: -- OUT
918: -- result - null
919: --

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

1109: end if;
1110:
1111: exception
1112: when others then
1113: Wf_Core.Context('ECX_STANDARD', 'Send', itemtype, itemkey, to_char(actid), funcmode);
1114: raise;
1115: end send;
1116:
1117: -- GetXMLTP

Line 1118: -- Standard ECX Workflow Activity

1114: raise;
1115: end send;
1116:
1117: -- GetXMLTP
1118: -- Standard ECX Workflow Activity
1119: -- Retrieve XML document
1120: -- OUT
1121: -- result - null
1122: --

Line 1168: p_message_standard varchar2(240);

1164: i_error_type pls_integer;
1165:
1166: p_party_type varchar2(240);
1167: p_message_type varchar2(240);
1168: p_message_standard varchar2(240);
1169: p_ext_type varchar2(240);
1170: p_ext_subtype varchar2(240);
1171: p_source_code varchar2(240);
1172: p_destination_code varchar2(240);

Line 1307: p_message_type, p_message_standard,

1303: party_id, party_site_id,
1304: document_id, ecx_utils.i_ret_code,
1305: ecx_utils.i_errbuf, trigger_id,
1306: p_party_type, p_party_id, p_party_site_id,
1307: p_message_type, p_message_standard,
1308: p_ext_type, p_ext_subtype, p_source_code,
1309: p_destination_code, p_destination_type,
1310: p_destination_address, p_username, p_password,
1311: p_map_code, p_queue_name, p_tp_header_id

Line 1368: i_message_standard => p_message_standard,

1364: end if;
1365:
1366: getXMLcover
1367: (
1368: i_message_standard => p_message_standard,
1369: i_map_code => p_map_code,
1370: i_transaction_type => transaction_type,
1371: i_transaction_subtype => transaction_subtype,
1372: i_tp_type => p_party_type,

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

1391: ecx_utils.g_event.addParameterToList('PARTYID', p_party_id);
1392: ecx_utils.g_event.addParameterToList('PARTY_SITE_ID', p_source_code);
1393: ecx_utils.g_event.addParameterToList('DOCUMENT_NUMBER', ecx_utils.g_document_id);
1394: ecx_utils.g_event.addParameterToList('MESSAGE_TYPE', p_message_type);
1395: ecx_utils.g_event.addParameterToList('MESSAGE_STANDARD', p_message_standard);
1396: ecx_utils.g_event.addParameterToList('TRANSACTION_TYPE', p_ext_type);
1397: ecx_utils.g_event.addParameterToList('TRANSACTION_SUBTYPE', p_ext_subtype);
1398: ecx_utils.g_event.addParameterToList('PROTOCOL_TYPE', p_destination_type);
1399: ecx_utils.g_event.addParameterToList('PROTOCOL_ADDRESS', p_destination_address);

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

1436: p_party_id, p_party_site_id, p_party_type,
1437: document_id, ecx_utils.i_ret_code, ecx_utils.i_errbuf
1438: );
1439:
1440: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1441: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
1442: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
1443: wf_core.raise('ECX_TRANSACTION_NOT_DEFINED');
1444: when ecx_document.ecx_no_delivery_required then

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

1448: p_party_id, p_party_site_id, p_party_type,
1449: document_id, ecx_utils.i_ret_code, ecx_utils.i_errbuf
1450: );
1451:
1452: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1453: g_instlmode := wf_core.translate('WF_INSTALL');
1454: IF g_instlmode = 'EMBEDDED'
1455: THEN
1456: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,

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

1470: p_party_id, p_party_site_id, p_party_type,
1471: document_id, ecx_utils.i_ret_code, ecx_utils.i_errbuf
1472: );
1473:
1474: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1475: wf_core.token('ECX_PARTY_ID', party_id);
1476: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
1477: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
1478: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);

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

1484: p_party_id, p_party_site_id, p_party_type,
1485: document_id, ecx_utils.i_ret_code, ecx_utils.i_errbuf
1486: );
1487:
1488: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1489: wf_core.token('ECX_PARTY_ID', party_id);
1490: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
1491: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
1492: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);

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

1498: p_party_id, p_party_site_id, p_party_type,
1499: document_id, ecx_utils.i_ret_code, ecx_utils.i_errbuf
1500: );
1501:
1502: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1503: g_instlmode := wf_core.translate('WF_INSTALL');
1504: IF g_instlmode = 'EMBEDDED'
1505: THEN
1506: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,

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

1520: p_party_id, p_party_site_id, p_party_type,
1521: document_id, ecx_utils.i_ret_code, ecx_utils.i_errbuf
1522: );
1523:
1524: Wf_Core.Context('ECX_STANDARD', 'getXMLTP', itemtype, itemkey, to_char(actid), funcmode);
1525: raise;
1526: end getXMLTP;
1527:
1528:

Line 1530: -- Standard ECX Workflow Activity

1526: end getXMLTP;
1527:
1528:
1529: -- GetXML
1530: -- Standard ECX Workflow Activity
1531: -- Retrieve XML document
1532: -- OUT
1533: -- result - null
1534: --

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

1699: resultout := 'COMPLETE:';
1700:
1701: exception
1702: when others then
1703: Wf_Core.Context('ECX_STANDARD', 'getXML', itemtype, itemkey, to_char(actid), funcmode);
1704: raise;
1705: end getXML;
1706:
1707:

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

1827: return;
1828:
1829: exception
1830: when others then
1831: wf_core.context('ECX_STANDARD', 'Reprocess_Inbound',itemtype, itemkey, to_char(actid),funcmode,retcode, errmsg);
1832: raise;
1833: end Reprocess_Inbound;
1834:
1835: procedure resend

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

1914: return;
1915:
1916: exception
1917: when others then
1918: wf_core.context('ECX_STANDARD', 'ReSend',itemtype, itemkey, to_char(actid),funcmode,retcode, ecx_debug.getMessage(errmsg,ecx_utils.i_errparams));
1919: raise;
1920: end resend;
1921:
1922: -- getEventDetails (PUBLIC)

Line 1923: -- Standard XML Gateway Event API

1919: raise;
1920: end resend;
1921:
1922: -- getEventDetails (PUBLIC)
1923: -- Standard XML Gateway Event API
1924: -- OUT:
1925: -- eventname - Event to the processes
1926: -- eventkey - Event key
1927: -- NOTE:

Line 1983: -- Standard XML Gateway Event API

1979: retmsg := substr(SQLERRM,1,200);
1980: end getEventDetails;
1981:
1982: -- getEventDetails (PUBLIC)
1983: -- Standard XML Gateway Event API
1984: -- OUT:
1985: -- eventname - Event to the processes
1986: -- eventkey - Event key
1987: -- NOTE:

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

2229: then
2230: xmldom.freeDocument(l_xml_doc);
2231: end if;
2232: when others then
2233: i_retmsg:= SQLERRM || ' - ECX_STANDARD.PERFORM_XSLT_TRANSFORMATION';
2234: i_retcode := 2;
2235:
2236: -- free all the used variables
2237: l_dtd_payload := null;

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

2297: l_node XMLDOM.DOMNODE;
2298:
2299: INVALID_NODE_IN_NODELIST EXCEPTION;
2300: BEGIN
2301: -- Standard call to check for call compatibility
2302: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
2303: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
2304: END IF;
2305:

Line 2405: end ecx_standard;

2401: END GET_VALUE_FOR_XPATH;
2402:
2403: /** bug 3357213 */
2404:
2405: end ecx_standard;