[Home] [Help]
27: )
28: is
29: begin
30: begin
31: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ECX_ERROR_TYPE',ecx_utils.error_type);
32: exception
33: when others then
34:
35: -- If item attribute does not exist then create it;
34:
35: -- If item attribute does not exist then create it;
36:
37: if ( wf_core.error_name = 'WFENG_ITEM_ATTR' ) then
38: wf_engine.AddItemAttr(itemtype,itemkey,'ECX_ERROR_TYPE',null,ecx_utils.error_type,null);
39: else
40: raise;
41: end if;
42: end;
41: end if;
42: end;
43:
44: begin
45: wf_engine.SetItemAttrText(itemtype,itemkey,'ECX_LOG_FILE',ecx_utils.g_logfile);
46: exception
47: when others then
48:
49: -- If item attribute does not exist then create it;
48:
49: -- If item attribute does not exist then create it;
50:
51: if ( wf_core.error_name = 'WFENG_ITEM_ATTR' ) then
52: wf_engine.AddItemAttr(itemtype,itemkey,'ECX_LOG_FILE',ecx_utils.g_logfile,null,null);
53: else
54: raise;
55: end if;
56: end;
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
201: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
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
215: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
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;
220: end if;
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
264: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
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
278: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
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;
283: end if;
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
340: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
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
354: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
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;
359: end if;
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
409: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
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
409: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
410: 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
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');
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
423: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
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
423: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
424: 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;
428: end if;
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;
428: end if;
429: exception
463: x_from_agt wf_agent_t := wf_agent_t(null,null);
464: x_to_agt wf_agent_t := wf_agent_t(null,null);
465:
466: begin
467: wf_event_t.initialize(ecx_utils.g_event);
468: /**
469: Set the Event Data with the passed in parameters,
470: so that the Business Event can be raised.
471: **/
469: Set the Event Data with the passed in parameters,
470: so that the Business Event can be raised.
471: **/
472:
473: ecx_utils.g_event.setEventName(ltrim(rtrim(eventName)));
474: ecx_utils.g_event.setEventKey(ltrim(rtrim(eventKey)));
475:
476: /**
477: x_from_agt has to be set.
470: so that the Business Event can be raised.
471: **/
472:
473: ecx_utils.g_event.setEventName(ltrim(rtrim(eventName)));
474: ecx_utils.g_event.setEventKey(ltrim(rtrim(eventKey)));
475:
476: /**
477: x_from_agt has to be set.
478: In this case, what is the from agent? Inbound engine?!
478: In this case, what is the from agent? Inbound engine?!
479: Setting it to null for now.
480: **/
481:
482: ecx_utils.g_event.from_agent := x_from_agt ;
483: ecx_utils.g_event.to_agent := x_to_agt ;
484:
485: ecx_utils.g_event.addParameterToList('PARAMETER1', parameter1);
486: ecx_utils.g_event.addParameterToList('PARAMETER2', parameter2);
479: Setting it to null for now.
480: **/
481:
482: ecx_utils.g_event.from_agent := x_from_agt ;
483: ecx_utils.g_event.to_agent := x_to_agt ;
484:
485: ecx_utils.g_event.addParameterToList('PARAMETER1', parameter1);
486: ecx_utils.g_event.addParameterToList('PARAMETER2', parameter2);
487: ecx_utils.g_event.addParameterToList('PARAMETER3', parameter3);
481:
482: ecx_utils.g_event.from_agent := x_from_agt ;
483: ecx_utils.g_event.to_agent := x_to_agt ;
484:
485: ecx_utils.g_event.addParameterToList('PARAMETER1', parameter1);
486: ecx_utils.g_event.addParameterToList('PARAMETER2', parameter2);
487: ecx_utils.g_event.addParameterToList('PARAMETER3', parameter3);
488: ecx_utils.g_event.addParameterToList('PARAMETER4', parameter4);
489: ecx_utils.g_event.addParameterToList('PARAMETER5', parameter5);
482: ecx_utils.g_event.from_agent := x_from_agt ;
483: ecx_utils.g_event.to_agent := x_to_agt ;
484:
485: ecx_utils.g_event.addParameterToList('PARAMETER1', parameter1);
486: ecx_utils.g_event.addParameterToList('PARAMETER2', parameter2);
487: ecx_utils.g_event.addParameterToList('PARAMETER3', parameter3);
488: ecx_utils.g_event.addParameterToList('PARAMETER4', parameter4);
489: ecx_utils.g_event.addParameterToList('PARAMETER5', parameter5);
490: ecx_utils.g_event.addParameterToList('PARAMETER6', parameter6);
483: ecx_utils.g_event.to_agent := x_to_agt ;
484:
485: ecx_utils.g_event.addParameterToList('PARAMETER1', parameter1);
486: ecx_utils.g_event.addParameterToList('PARAMETER2', parameter2);
487: ecx_utils.g_event.addParameterToList('PARAMETER3', parameter3);
488: ecx_utils.g_event.addParameterToList('PARAMETER4', parameter4);
489: ecx_utils.g_event.addParameterToList('PARAMETER5', parameter5);
490: ecx_utils.g_event.addParameterToList('PARAMETER6', parameter6);
491: ecx_utils.g_event.addParameterToList('PARAMETER7', parameter7);
484:
485: ecx_utils.g_event.addParameterToList('PARAMETER1', parameter1);
486: ecx_utils.g_event.addParameterToList('PARAMETER2', parameter2);
487: ecx_utils.g_event.addParameterToList('PARAMETER3', parameter3);
488: ecx_utils.g_event.addParameterToList('PARAMETER4', parameter4);
489: ecx_utils.g_event.addParameterToList('PARAMETER5', parameter5);
490: ecx_utils.g_event.addParameterToList('PARAMETER6', parameter6);
491: ecx_utils.g_event.addParameterToList('PARAMETER7', parameter7);
492: ecx_utils.g_event.addParameterToList('PARAMETER8', parameter8);
485: ecx_utils.g_event.addParameterToList('PARAMETER1', parameter1);
486: ecx_utils.g_event.addParameterToList('PARAMETER2', parameter2);
487: ecx_utils.g_event.addParameterToList('PARAMETER3', parameter3);
488: ecx_utils.g_event.addParameterToList('PARAMETER4', parameter4);
489: ecx_utils.g_event.addParameterToList('PARAMETER5', parameter5);
490: ecx_utils.g_event.addParameterToList('PARAMETER6', parameter6);
491: ecx_utils.g_event.addParameterToList('PARAMETER7', parameter7);
492: ecx_utils.g_event.addParameterToList('PARAMETER8', parameter8);
493: ecx_utils.g_event.addParameterToList('PARAMETER9', parameter9);
486: ecx_utils.g_event.addParameterToList('PARAMETER2', parameter2);
487: ecx_utils.g_event.addParameterToList('PARAMETER3', parameter3);
488: ecx_utils.g_event.addParameterToList('PARAMETER4', parameter4);
489: ecx_utils.g_event.addParameterToList('PARAMETER5', parameter5);
490: ecx_utils.g_event.addParameterToList('PARAMETER6', parameter6);
491: ecx_utils.g_event.addParameterToList('PARAMETER7', parameter7);
492: ecx_utils.g_event.addParameterToList('PARAMETER8', parameter8);
493: ecx_utils.g_event.addParameterToList('PARAMETER9', parameter9);
494: ecx_utils.g_event.addParameterToList('PARAMETER10', parameter10);
487: ecx_utils.g_event.addParameterToList('PARAMETER3', parameter3);
488: ecx_utils.g_event.addParameterToList('PARAMETER4', parameter4);
489: ecx_utils.g_event.addParameterToList('PARAMETER5', parameter5);
490: ecx_utils.g_event.addParameterToList('PARAMETER6', parameter6);
491: ecx_utils.g_event.addParameterToList('PARAMETER7', parameter7);
492: ecx_utils.g_event.addParameterToList('PARAMETER8', parameter8);
493: ecx_utils.g_event.addParameterToList('PARAMETER9', parameter9);
494: ecx_utils.g_event.addParameterToList('PARAMETER10', parameter10);
495:
488: ecx_utils.g_event.addParameterToList('PARAMETER4', parameter4);
489: ecx_utils.g_event.addParameterToList('PARAMETER5', parameter5);
490: ecx_utils.g_event.addParameterToList('PARAMETER6', parameter6);
491: ecx_utils.g_event.addParameterToList('PARAMETER7', parameter7);
492: ecx_utils.g_event.addParameterToList('PARAMETER8', parameter8);
493: ecx_utils.g_event.addParameterToList('PARAMETER9', parameter9);
494: ecx_utils.g_event.addParameterToList('PARAMETER10', parameter10);
495:
496: retcode :=0;
489: ecx_utils.g_event.addParameterToList('PARAMETER5', parameter5);
490: ecx_utils.g_event.addParameterToList('PARAMETER6', parameter6);
491: ecx_utils.g_event.addParameterToList('PARAMETER7', parameter7);
492: ecx_utils.g_event.addParameterToList('PARAMETER8', parameter8);
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');
490: ecx_utils.g_event.addParameterToList('PARAMETER6', parameter6);
491: ecx_utils.g_event.addParameterToList('PARAMETER7', parameter7);
492: ecx_utils.g_event.addParameterToList('PARAMETER8', parameter8);
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:
556: party_id := wf_event.getValueForParameter('ECX_PARTY_ID',p_parameter_list);
557: party_site_id := wf_event.getValueForParameter('ECX_PARTY_SITE_ID',p_parameter_list);
558: document_id := wf_event.getValueForParameter('ECX_DOCUMENT_ID',p_parameter_list);
559:
560: if ecx_utils.g_event is null
561: then
562: wf_event_t.initialize(ecx_utils.g_event);
563: end if;
564:
558: document_id := wf_event.getValueForParameter('ECX_DOCUMENT_ID',p_parameter_list);
559:
560: if ecx_utils.g_event is null
561: then
562: wf_event_t.initialize(ecx_utils.g_event);
563: end if;
564:
565: ecx_utils.g_event.setparameterlist(p_parameter_list);
566:
561: then
562: wf_event_t.initialize(ecx_utils.g_event);
563: end if;
564:
565: ecx_utils.g_event.setparameterlist(p_parameter_list);
566:
567:
568: getXMLCover
569: (
577: i_xmldoc => p_xmldoc
578: );
579:
580: -- Removed for time being as the parameters are IN type only.
581: --wf_event.addParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type,p_parameter_list);
582: --wf_event.addParameterToList('ECX_LOG_FILE', ecx_utils.g_logfile,p_parameter_list);
583: --dbms_lob.freetemporary(p_xmldoc);
584: return p_xmldoc;
585: exception
578: );
579:
580: -- Removed for time being as the parameters are IN type only.
581: --wf_event.addParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type,p_parameter_list);
582: --wf_event.addParameterToList('ECX_LOG_FILE', ecx_utils.g_logfile,p_parameter_list);
583: --dbms_lob.freetemporary(p_xmldoc);
584: return p_xmldoc;
585: exception
586: when others then
627: a1subtype varchar2(8);
628:
629: begin
630: -- Set the Global itemtype,itemkey and the activity_id
631: ecx_utils.g_item_type := itemtype;
632: ecx_utils.g_item_key := itemkey;
633: ecx_utils.g_activity_id := actid;
634:
635: -- Do nothing in cancel or timeout mode
628:
629: begin
630: -- Set the Global itemtype,itemkey and the activity_id
631: ecx_utils.g_item_type := itemtype;
632: ecx_utils.g_item_key := itemkey;
633: ecx_utils.g_activity_id := actid;
634:
635: -- Do nothing in cancel or timeout mode
636: if (funcmode <> wf_engine.eng_run) then
629: begin
630: -- Set the Global itemtype,itemkey and the activity_id
631: ecx_utils.g_item_type := itemtype;
632: ecx_utils.g_item_key := itemkey;
633: ecx_utils.g_activity_id := actid;
634:
635: -- Do nothing in cancel or timeout mode
636: if (funcmode <> wf_engine.eng_run) then
637: resultout := wf_engine.eng_null;
713: aname_log_file varchar2(30);
714:
715: begin
716: -- Set the Global itemtype,itemkey and the activity_id
717: ecx_utils.g_item_type := itemtype;
718: ecx_utils.g_item_key := itemkey;
719: ecx_utils.g_activity_id := actid;
720:
721: -- Do nothing in cancel or timeout mode
714:
715: begin
716: -- Set the Global itemtype,itemkey and the activity_id
717: ecx_utils.g_item_type := itemtype;
718: ecx_utils.g_item_key := itemkey;
719: ecx_utils.g_activity_id := actid;
720:
721: -- Do nothing in cancel or timeout mode
722: if (funcmode <> wf_engine.eng_run) then
715: begin
716: -- Set the Global itemtype,itemkey and the activity_id
717: ecx_utils.g_item_type := itemtype;
718: ecx_utils.g_item_key := itemkey;
719: ecx_utils.g_activity_id := actid;
720:
721: -- Do nothing in cancel or timeout mode
722: if (funcmode <> wf_engine.eng_run) then
723: resultout := wf_engine.eng_null;
743:
744: -- extract payload and pass to ECX
745:
746: i_payload := i_event.event_data;
747: ecx_utils.g_from_processxml := true;
748: processXMLCover
749: (
750: i_map_code,
751: i_payload,
753: );
754:
755: /*bug16442475: Returning status to notified and will set to complete from java*/
756: if ECX_UTIL_API.isInJavaProcessEnabled then
757: ecx_utils.g_from_processxml := false;
758: resultout := wf_engine.eng_notified;
759: else
760: addItemAttributes(itemtype,itemkey);
761: resultout := 'COMPLETE:';
798: g_instlmode varchar2(100);
799: begin
800:
801: -- Set the Global itemtype,itemkey and the activity_id
802: ecx_utils.g_item_type := itemtype;
803: ecx_utils.g_item_key := itemkey;
804: ecx_utils.g_activity_id := actid;
805:
806: -- Do nothing in cancel or timeout mode
799: begin
800:
801: -- Set the Global itemtype,itemkey and the activity_id
802: ecx_utils.g_item_type := itemtype;
803: ecx_utils.g_item_key := itemkey;
804: ecx_utils.g_activity_id := actid;
805:
806: -- Do nothing in cancel or timeout mode
807:
800:
801: -- Set the Global itemtype,itemkey and the activity_id
802: ecx_utils.g_item_type := itemtype;
803: ecx_utils.g_item_key := itemkey;
804: ecx_utils.g_activity_id := actid;
805:
806: -- Do nothing in cancel or timeout mode
807:
808: if (funcmode <> wf_engine.eng_run) then
889: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
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
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
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
903: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
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
903: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
904: 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;
908:
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;
908:
909: when others then
958: result varchar2(30);
959: status varchar2(8);
960: begin
961: -- Set the Global itemtype,itemkey and the activity_id
962: ecx_utils.g_item_type := itemtype;
963: ecx_utils.g_item_key := itemkey;
964: ecx_utils.g_activity_id := actid;
965:
966: -- Do nothing in cancel or timeout mode
959: status varchar2(8);
960: begin
961: -- Set the Global itemtype,itemkey and the activity_id
962: ecx_utils.g_item_type := itemtype;
963: ecx_utils.g_item_key := itemkey;
964: ecx_utils.g_activity_id := actid;
965:
966: -- Do nothing in cancel or timeout mode
967: if (funcmode <> wf_engine.eng_run) then
960: begin
961: -- Set the Global itemtype,itemkey and the activity_id
962: ecx_utils.g_item_type := itemtype;
963: ecx_utils.g_item_key := itemkey;
964: ecx_utils.g_activity_id := actid;
965:
966: -- Do nothing in cancel or timeout mode
967: if (funcmode <> wf_engine.eng_run) then
968: resultout := wf_engine.eng_null;
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: **/
1018: begin
1019: -- Initialize the Event before using it.
1020: wf_event_t.initialize(ecx_utils.g_event);
1016: global variable for ecx_utils.g_event or create a local instance.
1017: **/
1018: begin
1019: -- Initialize the Event before using it.
1020: wf_event_t.initialize(ecx_utils.g_event);
1021: ecx_utils.g_event := Wf_Engine.GetItemAttrEvent(itemtype, itemkey,'ECX_EVENT_MESSAGE');
1022: exception
1023: when others then
1024: if ecx_utils.g_event is null
1017: **/
1018: begin
1019: -- Initialize the Event before using it.
1020: wf_event_t.initialize(ecx_utils.g_event);
1021: ecx_utils.g_event := Wf_Engine.GetItemAttrEvent(itemtype, itemkey,'ECX_EVENT_MESSAGE');
1022: exception
1023: when others then
1024: if ecx_utils.g_event is null
1025: then
1020: wf_event_t.initialize(ecx_utils.g_event);
1021: ecx_utils.g_event := Wf_Engine.GetItemAttrEvent(itemtype, itemkey,'ECX_EVENT_MESSAGE');
1022: exception
1023: when others then
1024: if ecx_utils.g_event is null
1025: then
1026: wf_event_t.initialize(ecx_utils.g_event);
1027: end if;
1028: end;
1022: exception
1023: when others then
1024: if ecx_utils.g_event is null
1025: then
1026: wf_event_t.initialize(ecx_utils.g_event);
1027: end if;
1028: end;
1029:
1030:
1037: /* End of changes for bug 2120165*/
1038:
1039: -- Add the above Parameters to the Global Event Message Object
1040: -- For backward compatability , we are passing ECX_PARAMETER1 -> PARAMETER1 on the Engine.
1041: ecx_utils.g_event.addparametertolist('PARAMETER1',parameter1);
1042: ecx_utils.g_event.addparametertolist('PARAMETER2',parameter2);
1043: ecx_utils.g_event.addparametertolist('PARAMETER3',parameter3);
1044: ecx_utils.g_event.addparametertolist('PARAMETER4',parameter4);
1045: ecx_utils.g_event.addparametertolist('PARAMETER5',parameter5);
1038:
1039: -- Add the above Parameters to the Global Event Message Object
1040: -- For backward compatability , we are passing ECX_PARAMETER1 -> PARAMETER1 on the Engine.
1041: ecx_utils.g_event.addparametertolist('PARAMETER1',parameter1);
1042: ecx_utils.g_event.addparametertolist('PARAMETER2',parameter2);
1043: ecx_utils.g_event.addparametertolist('PARAMETER3',parameter3);
1044: ecx_utils.g_event.addparametertolist('PARAMETER4',parameter4);
1045: ecx_utils.g_event.addparametertolist('PARAMETER5',parameter5);
1046:
1039: -- Add the above Parameters to the Global Event Message Object
1040: -- For backward compatability , we are passing ECX_PARAMETER1 -> PARAMETER1 on the Engine.
1041: ecx_utils.g_event.addparametertolist('PARAMETER1',parameter1);
1042: ecx_utils.g_event.addparametertolist('PARAMETER2',parameter2);
1043: ecx_utils.g_event.addparametertolist('PARAMETER3',parameter3);
1044: ecx_utils.g_event.addparametertolist('PARAMETER4',parameter4);
1045: ecx_utils.g_event.addparametertolist('PARAMETER5',parameter5);
1046:
1047:
1040: -- For backward compatability , we are passing ECX_PARAMETER1 -> PARAMETER1 on the Engine.
1041: ecx_utils.g_event.addparametertolist('PARAMETER1',parameter1);
1042: ecx_utils.g_event.addparametertolist('PARAMETER2',parameter2);
1043: ecx_utils.g_event.addparametertolist('PARAMETER3',parameter3);
1044: ecx_utils.g_event.addparametertolist('PARAMETER4',parameter4);
1045: ecx_utils.g_event.addparametertolist('PARAMETER5',parameter5);
1046:
1047:
1048: send_mode := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_SEND_MODE');
1041: ecx_utils.g_event.addparametertolist('PARAMETER1',parameter1);
1042: ecx_utils.g_event.addparametertolist('PARAMETER2',parameter2);
1043: ecx_utils.g_event.addparametertolist('PARAMETER3',parameter3);
1044: ecx_utils.g_event.addparametertolist('PARAMETER4',parameter4);
1045: ecx_utils.g_event.addparametertolist('PARAMETER5',parameter5);
1046:
1047:
1048: send_mode := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_SEND_MODE');
1049:
1194: from dual;
1195:
1196: begin
1197: -- Set the Global itemtype,itemkey and the activity_id
1198: ecx_utils.g_item_type := itemtype;
1199: ecx_utils.g_item_key := itemkey;
1200: ecx_utils.g_activity_id := actid;
1201:
1202: -- Do nothing in cancel or timeout mode
1195:
1196: begin
1197: -- Set the Global itemtype,itemkey and the activity_id
1198: ecx_utils.g_item_type := itemtype;
1199: ecx_utils.g_item_key := itemkey;
1200: ecx_utils.g_activity_id := actid;
1201:
1202: -- Do nothing in cancel or timeout mode
1203: if (funcmode <> wf_engine.eng_run) then
1196: begin
1197: -- Set the Global itemtype,itemkey and the activity_id
1198: ecx_utils.g_item_type := itemtype;
1199: ecx_utils.g_item_key := itemkey;
1200: ecx_utils.g_activity_id := actid;
1201:
1202: -- Do nothing in cancel or timeout mode
1203: if (funcmode <> wf_engine.eng_run) then
1204: resultout := wf_engine.eng_null;
1265: Populate the Parameters in the original event Object being passed. if it is null , initialize and create
1266: a new Instance and populate the variables
1267: if i_event is null
1268: then
1269: wf_event_t.initialize(ecx_utils.g_event);
1270: else
1271: ecx_utils.g_event := i_event;
1272: end if;
1273: **/
1267: if i_event is null
1268: then
1269: wf_event_t.initialize(ecx_utils.g_event);
1270: else
1271: ecx_utils.g_event := i_event;
1272: end if;
1273: **/
1274:
1275: /* Always initialize ecx_utils.g_event before using it */
1271: ecx_utils.g_event := i_event;
1272: end if;
1273: **/
1274:
1275: /* Always initialize ecx_utils.g_event before using it */
1276: wf_event_t.initialize(ecx_utils.g_event);
1277: if i_event is not null
1278: then
1279: ecx_utils.g_event := i_event;
1272: end if;
1273: **/
1274:
1275: /* Always initialize ecx_utils.g_event before using it */
1276: wf_event_t.initialize(ecx_utils.g_event);
1277: if i_event is not null
1278: then
1279: ecx_utils.g_event := i_event;
1280: End If;
1275: /* Always initialize ecx_utils.g_event before using it */
1276: wf_event_t.initialize(ecx_utils.g_event);
1277: if i_event is not null
1278: then
1279: ecx_utils.g_event := i_event;
1280: End If;
1281:
1282: parameter1 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER1');
1283: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER2');
1285: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER4');
1286: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER5');
1287: -- Add the above Parameters to the Global Event Message Object
1288: -- For backward compatability , we are passing ECX_PARAMETER1 -> PARAMETER1 on the Engine.
1289: ecx_utils.g_event.addparametertolist('PARAMETER1',parameter1);
1290: ecx_utils.g_event.addparametertolist('PARAMETER2',parameter2);
1291: ecx_utils.g_event.addparametertolist('PARAMETER3',parameter3);
1292: ecx_utils.g_event.addparametertolist('PARAMETER4',parameter4);
1293: ecx_utils.g_event.addparametertolist('PARAMETER5',parameter5);
1286: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER5');
1287: -- Add the above Parameters to the Global Event Message Object
1288: -- For backward compatability , we are passing ECX_PARAMETER1 -> PARAMETER1 on the Engine.
1289: ecx_utils.g_event.addparametertolist('PARAMETER1',parameter1);
1290: ecx_utils.g_event.addparametertolist('PARAMETER2',parameter2);
1291: ecx_utils.g_event.addparametertolist('PARAMETER3',parameter3);
1292: ecx_utils.g_event.addparametertolist('PARAMETER4',parameter4);
1293: ecx_utils.g_event.addparametertolist('PARAMETER5',parameter5);
1294:
1287: -- Add the above Parameters to the Global Event Message Object
1288: -- For backward compatability , we are passing ECX_PARAMETER1 -> PARAMETER1 on the Engine.
1289: ecx_utils.g_event.addparametertolist('PARAMETER1',parameter1);
1290: ecx_utils.g_event.addparametertolist('PARAMETER2',parameter2);
1291: ecx_utils.g_event.addparametertolist('PARAMETER3',parameter3);
1292: ecx_utils.g_event.addparametertolist('PARAMETER4',parameter4);
1293: ecx_utils.g_event.addparametertolist('PARAMETER5',parameter5);
1294:
1295: open c1;
1288: -- For backward compatability , we are passing ECX_PARAMETER1 -> PARAMETER1 on the Engine.
1289: ecx_utils.g_event.addparametertolist('PARAMETER1',parameter1);
1290: ecx_utils.g_event.addparametertolist('PARAMETER2',parameter2);
1291: ecx_utils.g_event.addparametertolist('PARAMETER3',parameter3);
1292: ecx_utils.g_event.addparametertolist('PARAMETER4',parameter4);
1293: ecx_utils.g_event.addparametertolist('PARAMETER5',parameter5);
1294:
1295: open c1;
1296: fetch c1 into trigger_id;
1289: ecx_utils.g_event.addparametertolist('PARAMETER1',parameter1);
1290: ecx_utils.g_event.addparametertolist('PARAMETER2',parameter2);
1291: ecx_utils.g_event.addparametertolist('PARAMETER3',parameter3);
1292: ecx_utils.g_event.addparametertolist('PARAMETER4',parameter4);
1293: ecx_utils.g_event.addparametertolist('PARAMETER5',parameter5);
1294:
1295: open c1;
1296: fetch c1 into trigger_id;
1297: close c1;
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,
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,
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,
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,
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
1319: );
1320:
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
1319: );
1320:
1321: -- prepare WS related event if it is SOAP protocol type
1319: );
1320:
1321: -- prepare WS related event if it is SOAP protocol type
1322: if (upper(p_destination_type) = 'SOAP') then
1323: prepareWS(itemtype, itemkey, actid, ecx_utils.g_event);
1324: end if;
1325:
1326: -- if the from agent is not yet set by users, reset it based on the retrieve
1327: -- protocol_type. Otherwise, honor whatever has been set by the users.
1324: end if;
1325:
1326: -- if the from agent is not yet set by users, reset it based on the retrieve
1327: -- protocol_type. Otherwise, honor whatever has been set by the users.
1328: if (not ecx_utils.g_event.GetFromAgent() is null)
1329: then
1330: i_from_agent_name := ecx_utils.g_event.GetFromAgent().GetName();
1331: i_from_system_name := ecx_utils.g_event.GetFromAgent().GetSystem();
1332: end if;
1326: -- if the from agent is not yet set by users, reset it based on the retrieve
1327: -- protocol_type. Otherwise, honor whatever has been set by the users.
1328: if (not ecx_utils.g_event.GetFromAgent() is null)
1329: then
1330: i_from_agent_name := ecx_utils.g_event.GetFromAgent().GetName();
1331: i_from_system_name := ecx_utils.g_event.GetFromAgent().GetSystem();
1332: end if;
1333:
1334: if (i_from_agent_name is null AND i_from_system_name is null)
1327: -- protocol_type. Otherwise, honor whatever has been set by the users.
1328: if (not ecx_utils.g_event.GetFromAgent() is null)
1329: then
1330: i_from_agent_name := ecx_utils.g_event.GetFromAgent().GetName();
1331: i_from_system_name := ecx_utils.g_event.GetFromAgent().GetSystem();
1332: end if;
1333:
1334: if (i_from_agent_name is null AND i_from_system_name is null)
1335: or (i_from_agent_name = 'WF_DEFERRED')
1358: raise;
1359: end;
1360:
1361: i_from_agent := wf_agent_t(i_from_agent_name, i_from_system_name);
1362: ecx_utils.g_event.setFromAgent(i_from_agent);
1363:
1364: end if;
1365:
1366: getXMLcover
1373: i_tp_id => p_party_id,
1374: i_tp_site_id => p_party_site_id,
1375: i_document_id => document_id,
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,
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
1385: );
1386:
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
1385: );
1386:
1387: -- Following part is needed only when getxmltp is used with wf_event.send
1384: null,null,p_party_type
1385: );
1386:
1387: -- Following part is needed only when getxmltp is used with wf_event.send
1388: -- set ecx_utils.g_event with the envelope information. This will later be used
1389: -- by the queue handler to enqueue on ECX_OUTBOUND
1390: ecx_utils.g_event.addParameterToList('PARTY_TYPE', p_party_type);
1391: ecx_utils.g_event.addParameterToList('PARTYID', p_party_id);
1392: ecx_utils.g_event.addParameterToList('PARTY_SITE_ID', p_source_code);
1386:
1387: -- Following part is needed only when getxmltp is used with wf_event.send
1388: -- set ecx_utils.g_event with the envelope information. This will later be used
1389: -- by the queue handler to enqueue on ECX_OUTBOUND
1390: ecx_utils.g_event.addParameterToList('PARTY_TYPE', p_party_type);
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);
1387: -- Following part is needed only when getxmltp is used with wf_event.send
1388: -- set ecx_utils.g_event with the envelope information. This will later be used
1389: -- by the queue handler to enqueue on ECX_OUTBOUND
1390: ecx_utils.g_event.addParameterToList('PARTY_TYPE', p_party_type);
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);
1388: -- set ecx_utils.g_event with the envelope information. This will later be used
1389: -- by the queue handler to enqueue on ECX_OUTBOUND
1390: ecx_utils.g_event.addParameterToList('PARTY_TYPE', p_party_type);
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);
1389: -- by the queue handler to enqueue on ECX_OUTBOUND
1390: ecx_utils.g_event.addParameterToList('PARTY_TYPE', p_party_type);
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);
1390: ecx_utils.g_event.addParameterToList('PARTY_TYPE', p_party_type);
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);
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);
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);
1400: ecx_utils.g_event.addParameterToList('USERNAME', p_username);
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);
1400: ecx_utils.g_event.addParameterToList('USERNAME', p_username);
1401: ecx_utils.g_event.addParameterToList('PASSWORD', p_password);
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);
1400: ecx_utils.g_event.addParameterToList('USERNAME', p_username);
1401: ecx_utils.g_event.addParameterToList('PASSWORD', p_password);
1402: ecx_utils.g_event.addParameterToList('ATTRIBUTE1', ecx_utils.g_company_name);
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);
1400: ecx_utils.g_event.addParameterToList('USERNAME', p_username);
1401: ecx_utils.g_event.addParameterToList('PASSWORD', p_password);
1402: ecx_utils.g_event.addParameterToList('ATTRIBUTE1', ecx_utils.g_company_name);
1403: ecx_utils.g_event.addParameterToList('ATTRIBUTE2', null);
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);
1400: ecx_utils.g_event.addParameterToList('USERNAME', p_username);
1401: ecx_utils.g_event.addParameterToList('PASSWORD', p_password);
1402: ecx_utils.g_event.addParameterToList('ATTRIBUTE1', ecx_utils.g_company_name);
1403: ecx_utils.g_event.addParameterToList('ATTRIBUTE2', null);
1404: ecx_utils.g_event.addParameterToList('ATTRIBUTE3', p_destination_code);
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);
1400: ecx_utils.g_event.addParameterToList('USERNAME', p_username);
1401: ecx_utils.g_event.addParameterToList('PASSWORD', p_password);
1402: ecx_utils.g_event.addParameterToList('ATTRIBUTE1', ecx_utils.g_company_name);
1403: ecx_utils.g_event.addParameterToList('ATTRIBUTE2', null);
1404: ecx_utils.g_event.addParameterToList('ATTRIBUTE3', p_destination_code);
1405: ecx_utils.g_event.addParameterToList('ATTRIBUTE4', null);
1398: ecx_utils.g_event.addParameterToList('PROTOCOL_TYPE', p_destination_type);
1399: ecx_utils.g_event.addParameterToList('PROTOCOL_ADDRESS', p_destination_address);
1400: ecx_utils.g_event.addParameterToList('USERNAME', p_username);
1401: ecx_utils.g_event.addParameterToList('PASSWORD', p_password);
1402: ecx_utils.g_event.addParameterToList('ATTRIBUTE1', ecx_utils.g_company_name);
1403: ecx_utils.g_event.addParameterToList('ATTRIBUTE2', null);
1404: ecx_utils.g_event.addParameterToList('ATTRIBUTE3', p_destination_code);
1405: ecx_utils.g_event.addParameterToList('ATTRIBUTE4', null);
1406: ecx_utils.g_event.addParameterToList('ATTRIBUTE5', null);
1399: ecx_utils.g_event.addParameterToList('PROTOCOL_ADDRESS', p_destination_address);
1400: ecx_utils.g_event.addParameterToList('USERNAME', p_username);
1401: ecx_utils.g_event.addParameterToList('PASSWORD', p_password);
1402: ecx_utils.g_event.addParameterToList('ATTRIBUTE1', ecx_utils.g_company_name);
1403: ecx_utils.g_event.addParameterToList('ATTRIBUTE2', null);
1404: ecx_utils.g_event.addParameterToList('ATTRIBUTE3', p_destination_code);
1405: ecx_utils.g_event.addParameterToList('ATTRIBUTE4', null);
1406: ecx_utils.g_event.addParameterToList('ATTRIBUTE5', null);
1407: ecx_utils.g_event.addParameterToList('LOGFILE', ecx_utils.g_logfile);
1400: ecx_utils.g_event.addParameterToList('USERNAME', p_username);
1401: ecx_utils.g_event.addParameterToList('PASSWORD', p_password);
1402: ecx_utils.g_event.addParameterToList('ATTRIBUTE1', ecx_utils.g_company_name);
1403: ecx_utils.g_event.addParameterToList('ATTRIBUTE2', null);
1404: ecx_utils.g_event.addParameterToList('ATTRIBUTE3', p_destination_code);
1405: ecx_utils.g_event.addParameterToList('ATTRIBUTE4', null);
1406: ecx_utils.g_event.addParameterToList('ATTRIBUTE5', null);
1407: ecx_utils.g_event.addParameterToList('LOGFILE', ecx_utils.g_logfile);
1408: ecx_utils.g_event.addParameterToList('TRIGGER_ID', trigger_id);
1401: ecx_utils.g_event.addParameterToList('PASSWORD', p_password);
1402: ecx_utils.g_event.addParameterToList('ATTRIBUTE1', ecx_utils.g_company_name);
1403: ecx_utils.g_event.addParameterToList('ATTRIBUTE2', null);
1404: ecx_utils.g_event.addParameterToList('ATTRIBUTE3', p_destination_code);
1405: ecx_utils.g_event.addParameterToList('ATTRIBUTE4', null);
1406: ecx_utils.g_event.addParameterToList('ATTRIBUTE5', null);
1407: ecx_utils.g_event.addParameterToList('LOGFILE', ecx_utils.g_logfile);
1408: ecx_utils.g_event.addParameterToList('TRIGGER_ID', trigger_id);
1409: ecx_utils.g_event.addParameterToList('ITEM_TYPE', itemtype);
1402: ecx_utils.g_event.addParameterToList('ATTRIBUTE1', ecx_utils.g_company_name);
1403: ecx_utils.g_event.addParameterToList('ATTRIBUTE2', null);
1404: ecx_utils.g_event.addParameterToList('ATTRIBUTE3', p_destination_code);
1405: ecx_utils.g_event.addParameterToList('ATTRIBUTE4', null);
1406: ecx_utils.g_event.addParameterToList('ATTRIBUTE5', null);
1407: ecx_utils.g_event.addParameterToList('LOGFILE', ecx_utils.g_logfile);
1408: ecx_utils.g_event.addParameterToList('TRIGGER_ID', trigger_id);
1409: ecx_utils.g_event.addParameterToList('ITEM_TYPE', itemtype);
1410: ecx_utils.g_event.addParameterToList('ITEM_KEY', itemkey);
1403: ecx_utils.g_event.addParameterToList('ATTRIBUTE2', null);
1404: ecx_utils.g_event.addParameterToList('ATTRIBUTE3', p_destination_code);
1405: ecx_utils.g_event.addParameterToList('ATTRIBUTE4', null);
1406: ecx_utils.g_event.addParameterToList('ATTRIBUTE5', null);
1407: ecx_utils.g_event.addParameterToList('LOGFILE', ecx_utils.g_logfile);
1408: ecx_utils.g_event.addParameterToList('TRIGGER_ID', trigger_id);
1409: ecx_utils.g_event.addParameterToList('ITEM_TYPE', itemtype);
1410: ecx_utils.g_event.addParameterToList('ITEM_KEY', itemkey);
1411:
1404: ecx_utils.g_event.addParameterToList('ATTRIBUTE3', p_destination_code);
1405: ecx_utils.g_event.addParameterToList('ATTRIBUTE4', null);
1406: ecx_utils.g_event.addParameterToList('ATTRIBUTE5', null);
1407: ecx_utils.g_event.addParameterToList('LOGFILE', ecx_utils.g_logfile);
1408: ecx_utils.g_event.addParameterToList('TRIGGER_ID', trigger_id);
1409: ecx_utils.g_event.addParameterToList('ITEM_TYPE', itemtype);
1410: ecx_utils.g_event.addParameterToList('ITEM_KEY', itemkey);
1411:
1412: -- Populate event structure and set item attribute
1405: ecx_utils.g_event.addParameterToList('ATTRIBUTE4', null);
1406: ecx_utils.g_event.addParameterToList('ATTRIBUTE5', null);
1407: ecx_utils.g_event.addParameterToList('LOGFILE', ecx_utils.g_logfile);
1408: ecx_utils.g_event.addParameterToList('TRIGGER_ID', trigger_id);
1409: ecx_utils.g_event.addParameterToList('ITEM_TYPE', itemtype);
1410: ecx_utils.g_event.addParameterToList('ITEM_KEY', itemkey);
1411:
1412: -- Populate event structure and set item attribute
1413:
1406: ecx_utils.g_event.addParameterToList('ATTRIBUTE5', null);
1407: ecx_utils.g_event.addParameterToList('LOGFILE', ecx_utils.g_logfile);
1408: ecx_utils.g_event.addParameterToList('TRIGGER_ID', trigger_id);
1409: ecx_utils.g_event.addParameterToList('ITEM_TYPE', itemtype);
1410: ecx_utils.g_event.addParameterToList('ITEM_KEY', itemkey);
1411:
1412: -- Populate event structure and set item attribute
1413:
1414: if event_name is not null
1421: i_event.SetEventKey(event_key);
1422: end if;
1423:
1424: -- set the event data back
1425: wf_engine.SetItemAttrEvent(itemtype, itemkey, evt_name, ecx_utils.g_event);
1426:
1427: addItemAttributes(itemtype,itemkey);
1428:
1429: resultout := 'COMPLETE:';
1433: ecx_errorlog.outbound_trigger
1434: (
1435: trigger_id, transaction_type, transaction_subtype,
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);
1445: ecx_errorlog.outbound_trigger
1446: (
1447: trigger_id, transaction_type, transaction_subtype,
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');
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
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
1461: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
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
1461: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1462: 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;
1466: when ecx_document.ecx_no_party_setup then
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;
1466: when ecx_document.ecx_no_party_setup then
1467: ecx_errorlog.outbound_trigger
1467: ecx_errorlog.outbound_trigger
1468: (
1469: trigger_id, transaction_type, transaction_subtype,
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);
1481: ecx_errorlog.outbound_trigger
1482: (
1483: trigger_id, transaction_type, transaction_subtype,
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);
1493: wf_core.raise('ECX_DELIVERY_SETUP_ERROR');
1494: when ecx_utils.program_exit then
1495: ecx_errorlog.outbound_trigger
1496: (
1497: trigger_id, transaction_type, transaction_subtype,
1498: p_party_id, p_party_site_id, p_party_type,
1495: ecx_errorlog.outbound_trigger
1496: (
1497: trigger_id, transaction_type, transaction_subtype,
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');
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
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
1511: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,
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
1511: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,
1512: ecx_utils.i_errparams));
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;
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;
1516: when others then
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;
1516: when others then
1517: ecx_errorlog.outbound_trigger
1517: ecx_errorlog.outbound_trigger
1518: (
1519: trigger_id, transaction_type, transaction_subtype,
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;
1596: end if;
1597:
1598:
1599: -- Set the Global itemtype,itemkey and the activity_id
1600: ecx_utils.g_item_type := itemtype;
1601: ecx_utils.g_item_key := itemkey;
1602: ecx_utils.g_activity_id := actid;
1603:
1604: -- Do nothing in cancel or timeout mode
1597:
1598:
1599: -- Set the Global itemtype,itemkey and the activity_id
1600: ecx_utils.g_item_type := itemtype;
1601: ecx_utils.g_item_key := itemkey;
1602: ecx_utils.g_activity_id := actid;
1603:
1604: -- Do nothing in cancel or timeout mode
1605: if (funcmode <> wf_engine.eng_run) then
1598:
1599: -- Set the Global itemtype,itemkey and the activity_id
1600: ecx_utils.g_item_type := itemtype;
1601: ecx_utils.g_item_key := itemkey;
1602: ecx_utils.g_activity_id := actid;
1603:
1604: -- Do nothing in cancel or timeout mode
1605: if (funcmode <> wf_engine.eng_run) then
1606: resultout := wf_engine.eng_null;
1645: Populate the Parameters in the original event Object being passed. if it is null , initialize and create
1646: a new Instance and populate the variables
1647: if i_event is null
1648: then
1649: wf_event_t.initialize(ecx_utils.g_event);
1650: else
1651: ecx_utils.g_event := i_event;
1652: end if;
1653: **/
1647: if i_event is null
1648: then
1649: wf_event_t.initialize(ecx_utils.g_event);
1650: else
1651: ecx_utils.g_event := i_event;
1652: end if;
1653: **/
1654:
1655: /*Always initialize ecx_utils.g_event before using it */
1651: ecx_utils.g_event := i_event;
1652: end if;
1653: **/
1654:
1655: /*Always initialize ecx_utils.g_event before using it */
1656: wf_event_t.initialize(ecx_utils.g_event);
1657: if i_event is not null
1658: then
1659: ecx_utils.g_event := i_event;
1652: end if;
1653: **/
1654:
1655: /*Always initialize ecx_utils.g_event before using it */
1656: wf_event_t.initialize(ecx_utils.g_event);
1657: if i_event is not null
1658: then
1659: ecx_utils.g_event := i_event;
1660: End If;
1655: /*Always initialize ecx_utils.g_event before using it */
1656: wf_event_t.initialize(ecx_utils.g_event);
1657: if i_event is not null
1658: then
1659: ecx_utils.g_event := i_event;
1660: End If;
1661:
1662:
1663: -- Add the above Parameters to the Global Event Message Object
1661:
1662:
1663: -- Add the above Parameters to the Global Event Message Object
1664: -- For backward compatability , we are passing ECX_PARAMETER1 -> PARAMETER1 on the Engine.
1665: ecx_utils.g_event.addparametertolist('PARAMETER1',parameter1);
1666: ecx_utils.g_event.addparametertolist('PARAMETER2',parameter2);
1667: ecx_utils.g_event.addparametertolist('PARAMETER3',parameter3);
1668: ecx_utils.g_event.addparametertolist('PARAMETER4',parameter4);
1669: ecx_utils.g_event.addparametertolist('PARAMETER5',parameter5);
1662:
1663: -- Add the above Parameters to the Global Event Message Object
1664: -- For backward compatability , we are passing ECX_PARAMETER1 -> PARAMETER1 on the Engine.
1665: ecx_utils.g_event.addparametertolist('PARAMETER1',parameter1);
1666: ecx_utils.g_event.addparametertolist('PARAMETER2',parameter2);
1667: ecx_utils.g_event.addparametertolist('PARAMETER3',parameter3);
1668: ecx_utils.g_event.addparametertolist('PARAMETER4',parameter4);
1669: ecx_utils.g_event.addparametertolist('PARAMETER5',parameter5);
1670:
1663: -- Add the above Parameters to the Global Event Message Object
1664: -- For backward compatability , we are passing ECX_PARAMETER1 -> PARAMETER1 on the Engine.
1665: ecx_utils.g_event.addparametertolist('PARAMETER1',parameter1);
1666: ecx_utils.g_event.addparametertolist('PARAMETER2',parameter2);
1667: ecx_utils.g_event.addparametertolist('PARAMETER3',parameter3);
1668: ecx_utils.g_event.addparametertolist('PARAMETER4',parameter4);
1669: ecx_utils.g_event.addparametertolist('PARAMETER5',parameter5);
1670:
1671: -- KH comment: is null values for TP info going to casue an issue in GetXMLCover
1664: -- For backward compatability , we are passing ECX_PARAMETER1 -> PARAMETER1 on the Engine.
1665: ecx_utils.g_event.addparametertolist('PARAMETER1',parameter1);
1666: ecx_utils.g_event.addparametertolist('PARAMETER2',parameter2);
1667: ecx_utils.g_event.addparametertolist('PARAMETER3',parameter3);
1668: ecx_utils.g_event.addparametertolist('PARAMETER4',parameter4);
1669: ecx_utils.g_event.addparametertolist('PARAMETER5',parameter5);
1670:
1671: -- KH comment: is null values for TP info going to casue an issue in GetXMLCover
1672: getXMLcover(i_map_code => i_map_code,
1665: ecx_utils.g_event.addparametertolist('PARAMETER1',parameter1);
1666: ecx_utils.g_event.addparametertolist('PARAMETER2',parameter2);
1667: ecx_utils.g_event.addparametertolist('PARAMETER3',parameter3);
1668: ecx_utils.g_event.addparametertolist('PARAMETER4',parameter4);
1669: ecx_utils.g_event.addparametertolist('PARAMETER5',parameter5);
1670:
1671: -- KH comment: is null values for TP info going to casue an issue in GetXMLCover
1672: getXMLcover(i_map_code => i_map_code,
1673: i_transaction_type => transaction_type,
1675: i_tp_id => party_id,
1676: i_tp_site_id => party_site_id,
1677: i_document_id => document_id,
1678: i_debug_level => i_debug_level,
1679: i_xmldoc => ecx_utils.g_event.event_data
1680: );
1681:
1682: -- Populate event structure and set item attribute
1683:
1691: i_event.SetEventKey(event_key);
1692: end if;
1693:
1694: -- set the event data back
1695: wf_engine.SetItemAttrEvent(itemtype, itemkey, evt_name, ecx_utils.g_event);
1696:
1697: addItemAttributes(itemtype,itemkey);
1698:
1699: resultout := 'COMPLETE:';
1728: g_instlmode varchar2(100);
1729: begin
1730:
1731: -- Set the Global itemtype,itemkey and the activity_id
1732: ecx_utils.g_item_type := itemtype;
1733: ecx_utils.g_item_key := itemkey;
1734: ecx_utils.g_activity_id := actid;
1735:
1736: -- RUN mode - normal process execution
1729: begin
1730:
1731: -- Set the Global itemtype,itemkey and the activity_id
1732: ecx_utils.g_item_type := itemtype;
1733: ecx_utils.g_item_key := itemkey;
1734: ecx_utils.g_activity_id := actid;
1735:
1736: -- RUN mode - normal process execution
1737:
1730:
1731: -- Set the Global itemtype,itemkey and the activity_id
1732: ecx_utils.g_item_type := itemtype;
1733: ecx_utils.g_item_key := itemkey;
1734: ecx_utils.g_activity_id := actid;
1735:
1736: -- RUN mode - normal process execution
1737:
1738: if (funcmode = 'RUN') 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
1776: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
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
1776: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1777: 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;
1781:
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;
1781:
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
1791: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
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
1791: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1792: 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;
1796: end if;
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;
1796: end if;
1797:
1846: errmsg varchar2(2000);
1847: begin
1848:
1849: -- Set the Global itemtype,itemkey and the activity_id
1850: ecx_utils.g_item_type := itemtype;
1851: ecx_utils.g_item_key := itemkey;
1852: ecx_utils.g_activity_id := actid;
1853:
1854:
1847: begin
1848:
1849: -- Set the Global itemtype,itemkey and the activity_id
1850: ecx_utils.g_item_type := itemtype;
1851: ecx_utils.g_item_key := itemkey;
1852: ecx_utils.g_activity_id := actid;
1853:
1854:
1855: -- RUN mode - normal process execution
1848:
1849: -- Set the Global itemtype,itemkey and the activity_id
1850: ecx_utils.g_item_type := itemtype;
1851: ecx_utils.g_item_key := itemkey;
1852: ecx_utils.g_activity_id := actid;
1853:
1854:
1855: -- RUN mode - normal process execution
1856:
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,
1881: ecx_utils.i_errparams));
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:
1885: result := 'COMPLETE:';
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)
1952: itemkey := null;
1953: parentitemtype := null;
1954: parentitemkey := null;
1955:
1956: if ecx_utils.g_event is not null
1957: then
1958: eventname := ecx_utils.g_event.event_name;
1959: eventkey := ecx_utils.g_event.event_key;
1960: itemtype := ecx_utils.g_item_type;
1954: parentitemkey := null;
1955:
1956: if ecx_utils.g_event is not null
1957: then
1958: eventname := ecx_utils.g_event.event_name;
1959: eventkey := ecx_utils.g_event.event_key;
1960: itemtype := ecx_utils.g_item_type;
1961: itemkey := ecx_utils.g_item_key;
1962:
1955:
1956: if ecx_utils.g_event is not null
1957: then
1958: eventname := ecx_utils.g_event.event_name;
1959: eventkey := ecx_utils.g_event.event_key;
1960: itemtype := ecx_utils.g_item_type;
1961: itemkey := ecx_utils.g_item_key;
1962:
1963: p_parameter_list := ecx_utils.g_event.parameter_list;
1956: if ecx_utils.g_event is not null
1957: then
1958: eventname := ecx_utils.g_event.event_name;
1959: eventkey := ecx_utils.g_event.event_key;
1960: itemtype := ecx_utils.g_item_type;
1961: itemkey := ecx_utils.g_item_key;
1962:
1963: p_parameter_list := ecx_utils.g_event.parameter_list;
1964: if p_parameter_list is not null
1957: then
1958: eventname := ecx_utils.g_event.event_name;
1959: eventkey := ecx_utils.g_event.event_key;
1960: itemtype := ecx_utils.g_item_type;
1961: itemkey := ecx_utils.g_item_key;
1962:
1963: p_parameter_list := ecx_utils.g_event.parameter_list;
1964: if p_parameter_list is not null
1965: then
1959: eventkey := ecx_utils.g_event.event_key;
1960: itemtype := ecx_utils.g_item_type;
1961: itemkey := ecx_utils.g_item_key;
1962:
1963: p_parameter_list := ecx_utils.g_event.parameter_list;
1964: if p_parameter_list is not null
1965: then
1966: i_string := wf_event.getValueForParameter('#CONTEXT',p_parameter_list);
1967: if i_string is not null
2003: to_agent := null;
2004: from_system := null;
2005: to_system := null;
2006:
2007: if ecx_utils.g_event is not null
2008: then
2009: if ecx_utils.g_event.from_agent is not null
2010: then
2011: from_agent := ecx_utils.g_event.from_agent.name;
2005: to_system := null;
2006:
2007: if ecx_utils.g_event is not null
2008: then
2009: if ecx_utils.g_event.from_agent is not null
2010: then
2011: from_agent := ecx_utils.g_event.from_agent.name;
2012: from_system := ecx_utils.g_event.from_agent.system;
2013: else
2007: if ecx_utils.g_event is not null
2008: then
2009: if ecx_utils.g_event.from_agent is not null
2010: then
2011: from_agent := ecx_utils.g_event.from_agent.name;
2012: from_system := ecx_utils.g_event.from_agent.system;
2013: else
2014: -- Use the Local System
2015: from_system := wf_event.local_system_name;
2008: then
2009: if ecx_utils.g_event.from_agent is not null
2010: then
2011: from_agent := ecx_utils.g_event.from_agent.name;
2012: from_system := ecx_utils.g_event.from_agent.system;
2013: else
2014: -- Use the Local System
2015: from_system := wf_event.local_system_name;
2016: end if;
2014: -- Use the Local System
2015: from_system := wf_event.local_system_name;
2016: end if;
2017:
2018: if ecx_utils.g_event.to_agent is not null
2019: then
2020: to_agent := ecx_utils.g_event.to_agent.name;
2021: to_system := ecx_utils.g_event.to_agent.system;
2022: else
2016: end if;
2017:
2018: if ecx_utils.g_event.to_agent is not null
2019: then
2020: to_agent := ecx_utils.g_event.to_agent.name;
2021: to_system := ecx_utils.g_event.to_agent.system;
2022: else
2023: -- Use the Local System
2024: from_system := wf_event.local_system_name;
2017:
2018: if ecx_utils.g_event.to_agent is not null
2019: then
2020: to_agent := ecx_utils.g_event.to_agent.name;
2021: to_system := ecx_utils.g_event.to_agent.system;
2022: else
2023: -- Use the Local System
2024: from_system := wf_event.local_system_name;
2025: end if;
2056: retcode => i_retcode,
2057: retmsg => i_retmsg
2058: );
2059:
2060: if ecx_utils.g_event.from_agent is not null
2061: then
2062: i_from_system := ecx_utils.g_event.from_agent.system;
2063: else
2064: i_from_system := wf_event.local_system_name;
2058: );
2059:
2060: if ecx_utils.g_event.from_agent is not null
2061: then
2062: i_from_system := ecx_utils.g_event.from_agent.system;
2063: else
2064: i_from_system := wf_event.local_system_name;
2065: end if;
2066:
2159: into l_dtd_payload;
2160: close get_dtd;
2161: end if;
2162:
2163: -- convert i_xml_file from CLOB to DOMNode and set in ecx_utils.g_xmldoc
2164: l_parser := xmlparser.newParser;
2165:
2166: if (l_dtd_payload is not null)
2167: then
2175: xmlparser.parseCLOB(l_parser, i_xml_file);
2176:
2177: l_xml_doc := xmlparser.getDocument(l_parser);
2178:
2179: ecx_utils.g_xmldoc := xmlDOM.makeNode(l_xml_doc);
2180:
2181: /* Bug #2517237 : Trim the Clob before writing the transformed xml */
2182: dbms_lob.trim(i_xml_file, 0);
2183: /* bug 10254870: Calling overloaded procedure by passing out parameter of type clob
2187: i_version,
2188: i_xslt_application_code,
2189: i_xml_file
2190: );
2191: -- get the transformed xml from ecx_utils.g_xml_doc
2192: -- convert from DOMNode to clob and set it in original xmlfile
2193: /*bug 10254870: getting transformed i_xml_file clob and hence not required to copy from node to clob here */
2194: -- xmlDOM.writeToClob(ecx_utils.g_xmldoc, i_xml_file);
2195:
2190: );
2191: -- get the transformed xml from ecx_utils.g_xml_doc
2192: -- convert from DOMNode to clob and set it in original xmlfile
2193: /*bug 10254870: getting transformed i_xml_file clob and hence not required to copy from node to clob here */
2194: -- xmlDOM.writeToClob(ecx_utils.g_xmldoc, i_xml_file);
2195:
2196: -- free all the used variables
2197: l_dtd_payload := null;
2198: xmlparser.freeParser(l_parser);
2195:
2196: -- free all the used variables
2197: l_dtd_payload := null;
2198: xmlparser.freeParser(l_parser);
2199: if (not xmldom.isNull(ecx_utils.g_xmldoc)) then
2200: xmldom.freeDocument(xmldom.makeDocument(ecx_utils.g_xmldoc));
2201: end if;
2202: ecx_utils.g_logdir := null;
2203: ecx_utils.g_logfile := null;
2196: -- free all the used variables
2197: l_dtd_payload := null;
2198: xmlparser.freeParser(l_parser);
2199: if (not xmldom.isNull(ecx_utils.g_xmldoc)) then
2200: xmldom.freeDocument(xmldom.makeDocument(ecx_utils.g_xmldoc));
2201: end if;
2202: ecx_utils.g_logdir := null;
2203: ecx_utils.g_logfile := null;
2204: if (not xmldom.isNull(l_xml_doc))
2198: xmlparser.freeParser(l_parser);
2199: if (not xmldom.isNull(ecx_utils.g_xmldoc)) then
2200: xmldom.freeDocument(xmldom.makeDocument(ecx_utils.g_xmldoc));
2201: end if;
2202: ecx_utils.g_logdir := null;
2203: ecx_utils.g_logfile := null;
2204: if (not xmldom.isNull(l_xml_doc))
2205: then
2206: xmldom.freeDocument(l_xml_doc);
2199: if (not xmldom.isNull(ecx_utils.g_xmldoc)) then
2200: xmldom.freeDocument(xmldom.makeDocument(ecx_utils.g_xmldoc));
2201: end if;
2202: ecx_utils.g_logdir := null;
2203: ecx_utils.g_logfile := null;
2204: if (not xmldom.isNull(l_xml_doc))
2205: then
2206: xmldom.freeDocument(l_xml_doc);
2207: end if;
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;
2215: i_retmsg := ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams);
2216:
2217: -- free all the used variables
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;
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;
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);
2216:
2217: -- free all the used variables
2218: l_dtd_payload := null;
2219: xmlparser.freeParser(l_parser);
2220: if (not xmldom.isNull(ecx_utils.g_xmldoc)) then
2221: xmldom.freeDocument(xmldom.makeDocument(ecx_utils.g_xmldoc));
2222: end if;
2223: ecx_utils.g_logdir := null;
2224: ecx_utils.g_logfile := null;
2217: -- free all the used variables
2218: l_dtd_payload := null;
2219: xmlparser.freeParser(l_parser);
2220: if (not xmldom.isNull(ecx_utils.g_xmldoc)) then
2221: xmldom.freeDocument(xmldom.makeDocument(ecx_utils.g_xmldoc));
2222: end if;
2223: ecx_utils.g_logdir := null;
2224: ecx_utils.g_logfile := null;
2225: ecx_utils.i_ret_code := 0;
2219: xmlparser.freeParser(l_parser);
2220: if (not xmldom.isNull(ecx_utils.g_xmldoc)) then
2221: xmldom.freeDocument(xmldom.makeDocument(ecx_utils.g_xmldoc));
2222: end if;
2223: ecx_utils.g_logdir := null;
2224: ecx_utils.g_logfile := null;
2225: ecx_utils.i_ret_code := 0;
2226: ecx_utils.i_errbuf := null;
2227: ecx_utils.i_errparams := null;
2220: if (not xmldom.isNull(ecx_utils.g_xmldoc)) then
2221: xmldom.freeDocument(xmldom.makeDocument(ecx_utils.g_xmldoc));
2222: end if;
2223: ecx_utils.g_logdir := null;
2224: ecx_utils.g_logfile := null;
2225: ecx_utils.i_ret_code := 0;
2226: ecx_utils.i_errbuf := null;
2227: ecx_utils.i_errparams := null;
2228: if (not xmldom.isNull(l_xml_doc))
2221: xmldom.freeDocument(xmldom.makeDocument(ecx_utils.g_xmldoc));
2222: end if;
2223: ecx_utils.g_logdir := null;
2224: ecx_utils.g_logfile := null;
2225: ecx_utils.i_ret_code := 0;
2226: ecx_utils.i_errbuf := null;
2227: ecx_utils.i_errparams := null;
2228: if (not xmldom.isNull(l_xml_doc))
2229: then
2222: end if;
2223: ecx_utils.g_logdir := null;
2224: ecx_utils.g_logfile := null;
2225: ecx_utils.i_ret_code := 0;
2226: ecx_utils.i_errbuf := null;
2227: ecx_utils.i_errparams := null;
2228: if (not xmldom.isNull(l_xml_doc))
2229: then
2230: xmldom.freeDocument(l_xml_doc);
2223: ecx_utils.g_logdir := null;
2224: ecx_utils.g_logfile := null;
2225: ecx_utils.i_ret_code := 0;
2226: ecx_utils.i_errbuf := null;
2227: ecx_utils.i_errparams := null;
2228: if (not xmldom.isNull(l_xml_doc))
2229: then
2230: xmldom.freeDocument(l_xml_doc);
2231: end if;
2235:
2236: -- free all the used variables
2237: l_dtd_payload := null;
2238: xmlparser.freeParser(l_parser);
2239: if (not xmldom.isNull(ecx_utils.g_xmldoc)) then
2240: xmldom.freeDocument(xmldom.makeDocument(ecx_utils.g_xmldoc));
2241: end if;
2242: ecx_utils.g_logdir := null;
2243: ecx_utils.g_logfile := null;
2236: -- free all the used variables
2237: l_dtd_payload := null;
2238: xmlparser.freeParser(l_parser);
2239: if (not xmldom.isNull(ecx_utils.g_xmldoc)) then
2240: xmldom.freeDocument(xmldom.makeDocument(ecx_utils.g_xmldoc));
2241: end if;
2242: ecx_utils.g_logdir := null;
2243: ecx_utils.g_logfile := null;
2244: ecx_utils.i_ret_code := 0;
2238: xmlparser.freeParser(l_parser);
2239: if (not xmldom.isNull(ecx_utils.g_xmldoc)) then
2240: xmldom.freeDocument(xmldom.makeDocument(ecx_utils.g_xmldoc));
2241: end if;
2242: ecx_utils.g_logdir := null;
2243: ecx_utils.g_logfile := null;
2244: ecx_utils.i_ret_code := 0;
2245: ecx_utils.i_errbuf := null;
2246: ecx_utils.i_errparams := null;
2239: if (not xmldom.isNull(ecx_utils.g_xmldoc)) then
2240: xmldom.freeDocument(xmldom.makeDocument(ecx_utils.g_xmldoc));
2241: end if;
2242: ecx_utils.g_logdir := null;
2243: ecx_utils.g_logfile := null;
2244: ecx_utils.i_ret_code := 0;
2245: ecx_utils.i_errbuf := null;
2246: ecx_utils.i_errparams := null;
2247: if (not xmldom.isNull(l_xml_doc))
2240: xmldom.freeDocument(xmldom.makeDocument(ecx_utils.g_xmldoc));
2241: end if;
2242: ecx_utils.g_logdir := null;
2243: ecx_utils.g_logfile := null;
2244: ecx_utils.i_ret_code := 0;
2245: ecx_utils.i_errbuf := null;
2246: ecx_utils.i_errparams := null;
2247: if (not xmldom.isNull(l_xml_doc))
2248: then
2241: end if;
2242: ecx_utils.g_logdir := null;
2243: ecx_utils.g_logfile := null;
2244: ecx_utils.i_ret_code := 0;
2245: ecx_utils.i_errbuf := null;
2246: ecx_utils.i_errparams := null;
2247: if (not xmldom.isNull(l_xml_doc))
2248: then
2249: xmldom.freeDocument(l_xml_doc);
2242: ecx_utils.g_logdir := null;
2243: ecx_utils.g_logfile := null;
2244: ecx_utils.i_ret_code := 0;
2245: ecx_utils.i_errbuf := null;
2246: ecx_utils.i_errparams := null;
2247: if (not xmldom.isNull(l_xml_doc))
2248: then
2249: xmldom.freeDocument(l_xml_doc);
2250: end if;