192: then
193: g_instlmode := wf_core.translate('WF_INSTALL');
194: IF g_instlmode = 'EMBEDDED'
195: THEN
196: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
197: ecx_utils.i_errparams));
198: wf_core.token('ECX_LOGFILE',logfile);
199: wf_core.raise('ECX_PROCESS_XMLERROR_EMBD');
200: ELSE
197: ecx_utils.i_errparams));
198: wf_core.token('ECX_LOGFILE',logfile);
199: wf_core.raise('ECX_PROCESS_XMLERROR_EMBD');
200: ELSE
201: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
202: ecx_utils.i_errparams));
203: wf_core.token('ECX_LOGFILE',logfile);
204: wf_core.raise('ECX_PROCESS_XMLERROR');
205: END IF;
206: else
207: g_instlmode := wf_core.translate('WF_INSTALL');
208: IF g_instlmode = 'EMBEDDED'
209: THEN
210: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
211: ecx_utils.i_errparams));
212: wf_core.token('ECX_LOGFILE',logfile);
213: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
214: ELSE
211: ecx_utils.i_errparams));
212: wf_core.token('ECX_LOGFILE',logfile);
213: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
214: ELSE
215: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
216: ecx_utils.i_errparams));
217: wf_core.token('ECX_LOGFILE',logfile);
218: wf_core.raise('ECX_PROGRAM_EXIT');
219: END IF;
255: then
256: g_instlmode := wf_core.translate('WF_INSTALL');
257: IF g_instlmode = 'EMBEDDED'
258: THEN
259: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
260: ecx_utils.i_errparams));
261: wf_core.token('ECX_LOGFILE',logfile);
262: wf_core.raise('ECX_PROCESS_XMLERROR_EMBD');
263: ELSE
260: ecx_utils.i_errparams));
261: wf_core.token('ECX_LOGFILE',logfile);
262: wf_core.raise('ECX_PROCESS_XMLERROR_EMBD');
263: ELSE
264: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
265: ecx_utils.i_errparams));
266: wf_core.token('ECX_LOGFILE',logfile);
267: wf_core.raise('ECX_PROCESS_XMLERROR');
268: END IF;
269: else
270: g_instlmode := wf_core.translate('WF_INSTALL');
271: IF g_instlmode = 'EMBEDDED'
272: THEN
273: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
274: ecx_utils.i_errparams));
275: wf_core.token('ECX_LOGFILE',logfile);
276: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
277: ELSE
274: ecx_utils.i_errparams));
275: wf_core.token('ECX_LOGFILE',logfile);
276: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
277: ELSE
278: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
279: ecx_utils.i_errparams));
280: wf_core.token('ECX_LOGFILE',logfile);
281: wf_core.raise('ECX_PROGRAM_EXIT');
282: END IF;
331: then
332: g_instlmode := wf_core.translate('WF_INSTALL');
333: IF g_instlmode = 'EMBEDDED'
334: THEN
335: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
336: ecx_utils.i_errparams));
337: wf_core.token('ECX_LOGFILE',logfile);
338: wf_core.raise('ECX_GET_XMLERROR_EMBD');
339: ELSE
336: ecx_utils.i_errparams));
337: wf_core.token('ECX_LOGFILE',logfile);
338: wf_core.raise('ECX_GET_XMLERROR_EMBD');
339: ELSE
340: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
341: ecx_utils.i_errparams));
342: wf_core.token('ECX_LOGFILE',logfile);
343: wf_core.raise('ECX_GET_XMLERROR');
344: END IF;
345: else
346: g_instlmode := wf_core.translate('WF_INSTALL');
347: IF g_instlmode = 'EMBEDDED'
348: THEN
349: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
350: ecx_utils.i_errparams));
351: wf_core.token('ECX_LOGFILE',logfile);
352: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
353: ELSE
350: ecx_utils.i_errparams));
351: wf_core.token('ECX_LOGFILE',logfile);
352: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
353: ELSE
354: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
355: ecx_utils.i_errparams));
356: wf_core.token('ECX_LOGFILE',logfile);
357: wf_core.raise('ECX_PROGRAM_EXIT');
358: END IF;
400: then
401: g_instlmode := wf_core.translate('WF_INSTALL');
402: IF g_instlmode = 'EMBEDDED'
403: THEN
404: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
405: ecx_utils.i_errparams));
406: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
407: wf_core.raise('ECX_SENDDIRECT_ERROR_EMBD');
408: ELSE
405: ecx_utils.i_errparams));
406: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
407: wf_core.raise('ECX_SENDDIRECT_ERROR_EMBD');
408: ELSE
409: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
410: ecx_utils.i_errparams));
411: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
412: wf_core.raise('ECX_SENDDIRECT_ERROR');
413: END IF;
414: else
415: g_instlmode := wf_core.translate('WF_INSTALL');
416: IF g_instlmode = 'EMBEDDED'
417: THEN
418: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
419: ecx_utils.i_errparams));
420: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
421: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
422: ELSE
419: ecx_utils.i_errparams));
420: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
421: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
422: ELSE
423: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
424: ecx_utils.i_errparams));
425: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
426: wf_core.raise('ECX_PROGRAM_EXIT');
427: END IF;
493: ecx_utils.g_event.addParameterToList('PARAMETER9', parameter9);
494: ecx_utils.g_event.addParameterToList('PARAMETER10', parameter10);
495:
496: retcode :=0;
497: retmsg := ecx_debug.getTranslatedMessage('ECX_BUSINESS_EVT_SET');
498:
499: exception
500: when others then
501: retcode := 2;
498:
499: exception
500: when others then
501: retcode := 2;
502: retmsg := ecx_debug.getTranslatedMessage('ECX_BUSINESS_EVT_SET_ERROR');
503: wf_core.raise('ECX_EVENT_ERROR');
504: end setEventDetails;
505:
506:
542: -- map_code ect. should come from paramter list
543:
544: dbms_lob.createtemporary(p_xmldoc,true,dbms_lob.session);
545: map_code := wf_event.getValueForParameter('ECX_MAP_CODE',p_parameter_list);
546: debug_level := wf_event.getValueForParameter('ECX_DEBUG_LEVEL',p_parameter_list);
547: /** Which exception to use here for throwing the Error to BES **/
548: if (map_code is null ) then
549: wf_core.token('MAP_CODE','NULL');
550: wf_core.raise('WFSQL_ARGS');
647: end if;
648:
649:
650:
651: i_debug_level := nvl(wf_engine.GetItemAttrText(itemtype,itemkey,'ECX_DEBUG_LEVEL',true),0);
652:
653:
654: -- Verify that the attr type = EVENT
655:
733: end if;
734:
735:
736:
737: i_debug_level := nvl(wf_engine.GetItemAttrText(itemtype,itemkey,'ECX_DEBUG_LEVEL',true),0);
738: i_event := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE');
739: if (i_event is null ) then
740: wf_core.token('ECX_EVENT_MESSAGE','NULL');
741: wf_core.raise('WFSQL_ARGS');
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,
899: ecx_utils.i_errparams));
900: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
901: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
902: ELSE
899: ecx_utils.i_errparams));
900: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
901: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
902: ELSE
903: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
904: ecx_utils.i_errparams));
905: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
906: wf_core.raise('ECX_PROGRAM_EXIT');
907: END IF;
1009: wf_core.raise('WFSQL_ARGS');
1010: end if;
1011: **/
1012:
1013: debug_mode := nvl(Wf_Engine.GetItemAttrText(itemtype, itemkey, 'ECX_DEBUG_LEVEL',true),0);
1014:
1015: /** Check for the Item Attribute of type ECX_EVENT_MESSAGE. If found , then use that to initialize the
1016: global variable for ecx_utils.g_event or create a local instance.
1017: **/
1205: return;
1206: end if;
1207:
1208:
1209: i_debug_level := nvl(Wf_Engine.GetItemAttrText(itemtype, itemkey, 'ECX_DEBUG_LEVEL',true),0);
1210:
1211:
1212: -- Retreive Activity Attributes
1213:
1297: close c1;
1298:
1299: -- invoke trigger_outbound which will invoke outbound_trigger, getConfirmation and
1300: -- get_delivery_attribs
1301: ecx_debug.setErrorInfo(10,10,'ECX_TRIGGER_OUTBOUND');
1302: ecx_document.trigger_outbound(transaction_type, transaction_subtype,
1303: party_id, party_site_id,
1304: document_id, ecx_utils.i_ret_code,
1305: ecx_utils.i_errbuf, trigger_id,
1310: p_destination_address, p_username, p_password,
1311: p_map_code, p_queue_name, p_tp_header_id
1312: );
1313: -- do outbound logging
1314: ecx_debug.setErrorInfo(10,10, 'ECX_PROCESSING_MESSAGE');
1315: ecx_errorlog.outbound_engine (trigger_id,
1316: ecx_utils.i_ret_code,
1317: ecx_utils.i_errbuf,
1318: null,null,p_party_type
1376: i_debug_level => i_debug_level,
1377: i_xmldoc => ecx_utils.g_event.event_data,
1378: i_message_type => p_message_type);
1379:
1380: ecx_debug.setErrorInfo(0,10,'ECX_MESSAGE_CREATED');
1381: ecx_errorlog.outbound_engine (trigger_id,
1382: ecx_utils.i_ret_code,
1383: ecx_utils.i_errbuf,
1384: null,null,p_party_type
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,
1457: ecx_utils.i_errparams));
1458: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1459: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
1460: ELSE
1457: ecx_utils.i_errparams));
1458: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1459: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
1460: ELSE
1461: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1462: ecx_utils.i_errparams));
1463: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1464: wf_core.raise('ECX_PROGRAM_EXIT');
1465: END IF;
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,
1507: ecx_utils.i_errparams));
1508: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1509: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
1510: ELSE
1507: ecx_utils.i_errparams));
1508: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1509: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
1510: ELSE
1511: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,
1512: ecx_utils.i_errparams));
1513: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1514: wf_core.raise('ECX_PROGRAM_EXIT');
1515: END IF;
1613: end if;
1614:
1615:
1616: document_id := Wf_Engine.GetActivityAttrTEXT(itemtype, itemkey, actid, 'ECX_DOCUMENT_ID');
1617: i_debug_level := nvl(Wf_Engine.GetItemAttrText(itemtype, itemkey, 'ECX_DEBUG_LEVEL',true),0);
1618: event_name := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_EVENT_NAME');
1619: event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_EVENT_KEY');
1620:
1621: /* Start changes for bug Bug 2120165 */
1737:
1738: if (funcmode = 'RUN') then
1739:
1740: message_id := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MSGID');
1741: debug_level := nvl(Wf_Engine.GetItemAttrText(itemtype, itemkey,'ECX_DEBUG_LEVEL',true),0);
1742:
1743: ecx_inbound_trig.reprocess
1744: (
1745: i_msgid => message_id,
1767: then
1768: g_instlmode := wf_core.translate('WF_INSTALL');
1769: IF g_instlmode = 'EMBEDDED'
1770: THEN
1771: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1772: ecx_utils.i_errparams));
1773: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1774: wf_core.raise('ECX_REPROCESS_INBOUND_EMBD');
1775: ELSE
1772: ecx_utils.i_errparams));
1773: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1774: wf_core.raise('ECX_REPROCESS_INBOUND_EMBD');
1775: ELSE
1776: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1777: ecx_utils.i_errparams));
1778: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1779: wf_core.raise('ECX_REPROCESS_INBOUND');
1780: END IF;
1782: else
1783: g_instlmode := wf_core.translate('WF_INSTALL');
1784: IF g_instlmode = 'EMBEDDED'
1785: THEN
1786: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1787: ecx_utils.i_errparams));
1788: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1789: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
1790: ELSE
1787: ecx_utils.i_errparams));
1788: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1789: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
1790: ELSE
1791: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1792: ecx_utils.i_errparams));
1793: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1794: wf_core.raise('ECX_PROGRAM_EXIT');
1795: END IF;
1872: result := 'COMPLETE:';
1873: return;
1874: elsif retcode = 1
1875: then
1876: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1877: ecx_utils.i_errparams));
1878: wf_core.raise('ECX_RESEND_WARNING');
1879: else
1880: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1876: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1877: ecx_utils.i_errparams));
1878: wf_core.raise('ECX_RESEND_WARNING');
1879: else
1880: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1881: ecx_utils.i_errparams));
1882: wf_core.raise('ECX_RESEND_ERROR');
1883: end if;
1884:
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)
2104: -- check for nulls
2105: if (i_xml_file is null)
2106: then
2107: i_retcode := 2;
2108: i_retmsg := ecx_debug.getTranslatedMessage('ECX_XML_FILE_NULL');
2109: return;
2110: end if;
2111:
2112: if(i_xslt_file_name is null)
2111:
2112: if(i_xslt_file_name is null)
2113: then
2114: i_retcode := 2;
2115: i_retmsg := ecx_debug.getTranslatedMessage('ECX_XSLT_FILE_NULL');
2116: return;
2117: end if;
2118:
2119: if (i_xslt_application_code is null)
2118:
2119: if (i_xslt_application_code is null)
2120: then
2121: i_retcode := 2;
2122: i_retmsg := ecx_debug.getTranslatedMessage('ECX_XSLT_APP_CODE_NULL');
2123: return;
2124: end if;
2125:
2126: fnd_profile.get('ECX_MAX_JAVA_MEMORY',pECX_MAX_JAVA_MEMORY);
2206: xmldom.freeDocument(l_xml_doc);
2207: end if;
2208:
2209: i_retcode := 0;
2210: i_retmsg := ecx_debug.getTranslatedMessage('ECX_XSLT_TRANSFORMED');
2211:
2212: exception
2213: when ecx_utils.program_exit then
2214: i_retcode := ecx_utils.i_ret_code;
2211:
2212: exception
2213: when ecx_utils.program_exit then
2214: i_retcode := ecx_utils.i_ret_code;
2215: i_retmsg := ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams);
2216:
2217: -- free all the used variables
2218: l_dtd_payload := null;
2219: xmlparser.freeParser(l_parser);