33: when others then
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;
47: when others then
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;
189: then
190: return;
191: elsif retcode = 1
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));
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
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,
202: ecx_utils.i_errparams));
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,
202: ecx_utils.i_errparams));
203: wf_core.token('ECX_LOGFILE',logfile);
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;
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');
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'
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));
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
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,
216: ecx_utils.i_errparams));
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,
216: ecx_utils.i_errparams));
217: wf_core.token('ECX_LOGFILE',logfile);
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;
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;
221: exception
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;
221: exception
222: when others then
219: END IF;
220: end if;
221: exception
222: when others then
223: wf_core.context('ECX_STANDARD','XMLtoXMLCover',i_map_code,i_debug_level);
224: raise;
225: end XMLtoXMLCover;
226:
227: procedure processXMLCover
252: then
253: return;
254: elsif retcode = 1
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));
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
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,
265: ecx_utils.i_errparams));
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,
265: ecx_utils.i_errparams));
266: wf_core.token('ECX_LOGFILE',logfile);
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;
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');
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'
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));
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
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,
279: ecx_utils.i_errparams));
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,
279: ecx_utils.i_errparams));
280: wf_core.token('ECX_LOGFILE',logfile);
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;
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;
284: exception
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;
284: exception
285: when others then
282: END IF;
283: end if;
284: exception
285: when others then
286: wf_core.context('ECX_STANDARD','processXMLCover',i_map_code,i_debug_level);
287: raise;
288: end processXMLCover;
289:
290: procedure getXMLCover
328: then
329: return;
330: elsif retcode = 1
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));
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
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,
341: ecx_utils.i_errparams));
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,
341: ecx_utils.i_errparams));
342: wf_core.token('ECX_LOGFILE',logfile);
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;
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');
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'
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));
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
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,
355: ecx_utils.i_errparams));
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,
355: ecx_utils.i_errparams));
356: wf_core.token('ECX_LOGFILE',logfile);
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;
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;
360: exception
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;
360: exception
361: when others then
358: END IF;
359: end if;
360: exception
361: when others then
362: wf_core.context('ECX_STANDARD','getXMLCover',i_message_standard,i_transaction_type,i_transaction_subtype);
363: raise;
364: end getXMLCover;
365:
366: /** (Synchronous) Send Direct api to avoid racing condition **/
397: then
398: return;
399: elsif retcode = 1
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));
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
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));
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));
411: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
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;
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');
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'
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));
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
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));
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));
425: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
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;
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
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
430: when others then
427: END IF;
428: end if;
429: exception
430: when others then
431: wf_core.context('ECX_STANDARD','sendDirectCover',transaction_type,transaction_subtype);
432: raise;
433: end sendDirectCover;
434:
435:
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:
507: -- Generate (PUBLIC)
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');
551: end if;
552:
553: /** Everything else is optional set of parameters **/
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');
551: end if;
552:
553: /** Everything else is optional set of parameters **/
554: transaction_type := wf_event.getValueForParameter('ECX_TRANSACTION_TYPE',p_parameter_list);
583: --dbms_lob.freetemporary(p_xmldoc);
584: return p_xmldoc;
585: exception
586: when others then
587: wf_core.context('ECX_STANDARD', 'Generate', p_event_name, p_event_key);
588: raise;
589: end Generate;
590:
591: -- XMLtoXML
641: -- Get ecx map code
642:
643: i_map_code := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MAP_CODE');
644: if (i_map_code is null ) then
645: wf_core.token('ECX_MAP_CODE','NULL');
646: wf_core.raise('WFSQL_ARGS');
647: end if;
648:
649:
642:
643: i_map_code := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MAP_CODE');
644: if (i_map_code is null ) then
645: wf_core.token('ECX_MAP_CODE','NULL');
646: wf_core.raise('WFSQL_ARGS');
647: end if;
648:
649:
650:
654: -- Verify that the attr type = EVENT
655:
656: i_inevent := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE_IN');
657: if (i_inevent is null ) then
658: wf_core.token('ECX_EVENT_MESSAGE_IN','NULL');
659: wf_core.raise('WFSQL_ARGS');
660: end if;
661:
662: aname := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE_OUT');
655:
656: i_inevent := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE_IN');
657: if (i_inevent is null ) then
658: wf_core.token('ECX_EVENT_MESSAGE_IN','NULL');
659: wf_core.raise('WFSQL_ARGS');
660: end if;
661:
662: aname := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE_OUT');
663: if ( aname is null ) then
660: end if;
661:
662: aname := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE_OUT');
663: if ( aname is null ) then
664: wf_core.token('ECX_EVENT_MESSAGE_OUT','NULL');
665: wf_core.raise('WFSQL_ARGS');
666: end if;
667:
668: --Wf_Engine.GetItemAttrInfo(itemtype, aname ,atype, asubtype, aformat);
661:
662: aname := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE_OUT');
663: if ( aname is null ) then
664: wf_core.token('ECX_EVENT_MESSAGE_OUT','NULL');
665: wf_core.raise('WFSQL_ARGS');
666: end if;
667:
668: --Wf_Engine.GetItemAttrInfo(itemtype, aname ,atype, asubtype, aformat);
669: --if (atype <> 'EVENT' ) then
666: end if;
667:
668: --Wf_Engine.GetItemAttrInfo(itemtype, aname ,atype, asubtype, aformat);
669: --if (atype <> 'EVENT' ) then
670: --wf_core.token('VTYPE',atype);
671: --wf_core.raise('WFXXXV_VTYPE');
672: --end if;
673:
674: i_outevent := Wf_Engine.GetItemAttrEvent(itemtype, itemkey, aname);
667:
668: --Wf_Engine.GetItemAttrInfo(itemtype, aname ,atype, asubtype, aformat);
669: --if (atype <> 'EVENT' ) then
670: --wf_core.token('VTYPE',atype);
671: --wf_core.raise('WFXXXV_VTYPE');
672: --end if;
673:
674: i_outevent := Wf_Engine.GetItemAttrEvent(itemtype, itemkey, aname);
675:
688:
689: resultout := 'COMPLETE:';
690: exception
691: when others then
692: Wf_Core.Context('ECX_STANDARD', 'XMLtoXML',itemtype,itemkey, to_char(actid), funcmode);
693: raise;
694: end XMLtoXML;
695:
696: procedure ProcessXML(itemtype in varchar2,
727: -- Get ecx map code
728:
729: i_map_code := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MAP_CODE');
730: if (i_map_code is null ) then
731: wf_core.token('ECX_MAP_CODE','NULL');
732: wf_core.raise('WFSQL_ARGS');
733: end if;
734:
735:
728:
729: i_map_code := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MAP_CODE');
730: if (i_map_code is null ) then
731: wf_core.token('ECX_MAP_CODE','NULL');
732: wf_core.raise('WFSQL_ARGS');
733: end if;
734:
735:
736:
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');
742: end if;
743:
744: -- extract payload and pass to ECX
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');
742: end if;
743:
744: -- extract payload and pass to ECX
745:
761: resultout := 'COMPLETE:';
762: end if;
763: exception
764: when others then
765: Wf_Core.Context('ECX_STANDARD', 'PROCESSXML',itemtype,itemkey, to_char(actid), funcmode);
766: raise;
767: end processXML;
768:
769: -- IsDeliveryRequired
813: -- Retreive Activity Attributes
814:
815: transaction_type := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_TYPE');
816: if ( transaction_type is null ) then
817: wf_core.token('ECX_TRANSACTION_TYPE','NULL');
818: wf_core.raise('WFSQL_ARGS');
819: end if;
820:
821: transaction_subtype := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_SUBTYPE');
814:
815: transaction_type := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_TYPE');
816: if ( transaction_type is null ) then
817: wf_core.token('ECX_TRANSACTION_TYPE','NULL');
818: wf_core.raise('WFSQL_ARGS');
819: end if;
820:
821: transaction_subtype := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_SUBTYPE');
822: if ( transaction_subtype is null ) then
819: end if;
820:
821: transaction_subtype := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_SUBTYPE');
822: if ( transaction_subtype is null ) then
823: wf_core.token('ECX_TRANSACTION_SUBTYPE','NULL');
824: wf_core.raise('WFSQL_ARGS');
825: end if;
826:
827: party_site_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_SITE_ID');
820:
821: transaction_subtype := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_SUBTYPE');
822: if ( transaction_subtype is null ) then
823: wf_core.token('ECX_TRANSACTION_SUBTYPE','NULL');
824: wf_core.raise('WFSQL_ARGS');
825: end if;
826:
827: party_site_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_SITE_ID');
828: if ( party_site_id is null ) then
825: end if;
826:
827: party_site_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_SITE_ID');
828: if ( party_site_id is null ) then
829: wf_core.token('ECX_PARTY_SITE_ID','NULL');
830: wf_core.raise('WFSQL_ARGS');
831: end if;
832:
833: -- party_id is optional. Only party_site_id is required
826:
827: party_site_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_SITE_ID');
828: if ( party_site_id is null ) then
829: wf_core.token('ECX_PARTY_SITE_ID','NULL');
830: wf_core.raise('WFSQL_ARGS');
831: end if;
832:
833: -- party_id is optional. Only party_site_id is required
834:
877: resultout := 'COMPLETE:F';
878: end if;
879: exception
880: when ecx_document.ecx_transaction_not_defined then
881: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
882: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
883: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
884: wf_core.raise('ECX_TRANSACTION_NOT_DEFINED');
885: when ecx_document.ecx_delivery_setup_error then
878: end if;
879: exception
880: when ecx_document.ecx_transaction_not_defined then
881: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
882: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
883: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
884: wf_core.raise('ECX_TRANSACTION_NOT_DEFINED');
885: when ecx_document.ecx_delivery_setup_error then
886: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
879: exception
880: when ecx_document.ecx_transaction_not_defined then
881: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
882: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
883: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
884: wf_core.raise('ECX_TRANSACTION_NOT_DEFINED');
885: when ecx_document.ecx_delivery_setup_error then
886: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
887: wf_core.token('ECX_PARTY_ID', party_id);
880: when ecx_document.ecx_transaction_not_defined then
881: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
882: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
883: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
884: wf_core.raise('ECX_TRANSACTION_NOT_DEFINED');
885: when ecx_document.ecx_delivery_setup_error then
886: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
887: wf_core.token('ECX_PARTY_ID', party_id);
888: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
882: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
883: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
884: wf_core.raise('ECX_TRANSACTION_NOT_DEFINED');
885: when ecx_document.ecx_delivery_setup_error then
886: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
887: wf_core.token('ECX_PARTY_ID', party_id);
888: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
889: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
890: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
883: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
884: wf_core.raise('ECX_TRANSACTION_NOT_DEFINED');
885: when ecx_document.ecx_delivery_setup_error then
886: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
887: wf_core.token('ECX_PARTY_ID', party_id);
888: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
889: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
890: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
891: wf_core.raise('ECX_DELIVERY_SETUP_ERROR');
884: wf_core.raise('ECX_TRANSACTION_NOT_DEFINED');
885: when ecx_document.ecx_delivery_setup_error then
886: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
887: wf_core.token('ECX_PARTY_ID', party_id);
888: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
889: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
890: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
891: wf_core.raise('ECX_DELIVERY_SETUP_ERROR');
892:
885: when ecx_document.ecx_delivery_setup_error then
886: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
887: wf_core.token('ECX_PARTY_ID', party_id);
888: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
889: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
890: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
891: wf_core.raise('ECX_DELIVERY_SETUP_ERROR');
892:
893: when ecx_utils.program_exit then
886: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
887: wf_core.token('ECX_PARTY_ID', party_id);
888: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
889: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
890: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
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);
887: wf_core.token('ECX_PARTY_ID', party_id);
888: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
889: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
890: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
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');
890: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
891: wf_core.raise('ECX_DELIVERY_SETUP_ERROR');
892:
893: when ecx_utils.program_exit then
894: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
895: g_instlmode := wf_core.translate('WF_INSTALL');
896: IF g_instlmode = 'EMBEDDED'
897: THEN
898: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,
891: wf_core.raise('ECX_DELIVERY_SETUP_ERROR');
892:
893: when ecx_utils.program_exit then
894: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
895: g_instlmode := wf_core.translate('WF_INSTALL');
896: IF g_instlmode = 'EMBEDDED'
897: THEN
898: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,
899: ecx_utils.i_errparams));
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
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));
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));
905: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
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;
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
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
910: raise;
972: -- We need to determine which parameters are required and which are optional
973:
974: transaction_type := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_TYPE');
975: if ( transaction_type is null ) then
976: wf_core.token('ECX_TRANSACTION_TYPE','NULL');
977: wf_core.raise('WFSQL_ARGS');
978: end if;
979:
980: transaction_subtype := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_SUBTYPE');
973:
974: transaction_type := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_TYPE');
975: if ( transaction_type is null ) then
976: wf_core.token('ECX_TRANSACTION_TYPE','NULL');
977: wf_core.raise('WFSQL_ARGS');
978: end if;
979:
980: transaction_subtype := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_SUBTYPE');
981: if ( transaction_subtype is null ) then
978: end if;
979:
980: transaction_subtype := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_SUBTYPE');
981: if ( transaction_subtype is null ) then
982: wf_core.token('ECX_TRANSACTION_SUBTYPE','NULL');
983: wf_core.raise('WFSQL_ARGS');
984: end if;
985:
986: party_site_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_SITE_ID');
979:
980: transaction_subtype := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_SUBTYPE');
981: if ( transaction_subtype is null ) then
982: wf_core.token('ECX_TRANSACTION_SUBTYPE','NULL');
983: wf_core.raise('WFSQL_ARGS');
984: end if;
985:
986: party_site_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_SITE_ID');
987: if ( transaction_type <> 'ECX' and transaction_subtype <> 'CBODO' )
987: if ( transaction_type <> 'ECX' and transaction_subtype <> 'CBODO' )
988: then
989: if ( party_site_id is null )
990: then
991: wf_core.token('ECX_PARTY_SITE_ID','NULL');
992: wf_core.raise('WFSQL_ARGS');
993: end if;
994: end if;
995:
988: then
989: if ( party_site_id is null )
990: then
991: wf_core.token('ECX_PARTY_SITE_ID','NULL');
992: wf_core.raise('WFSQL_ARGS');
993: end if;
994: end if;
995:
996: -- party_id is optional. Only party_site_id is required
1004: -- It is an optional Field
1005: document_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_DOCUMENT_ID');
1006: /**
1007: if ( document_id is null ) then
1008: wf_core.token('ECX_DOCUMENT_ID','NULL');
1009: wf_core.raise('WFSQL_ARGS');
1010: end if;
1011: **/
1012:
1005: document_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_DOCUMENT_ID');
1006: /**
1007: if ( document_id is null ) then
1008: wf_core.token('ECX_DOCUMENT_ID','NULL');
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);
1109: end if;
1110:
1111: exception
1112: when others then
1113: Wf_Core.Context('ECX_STANDARD', 'Send', itemtype, itemkey, to_char(actid), funcmode);
1114: raise;
1115: end send;
1116:
1117: -- GetXMLTP
1212: -- Retreive Activity Attributes
1213:
1214: transaction_type := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_TYPE');
1215: if ( transaction_type is null ) then
1216: wf_core.token('ECX_TRANSACTION_TYPE','NULL');
1217: wf_core.raise('WFSQL_ARGS');
1218: end if;
1219:
1220: transaction_subtype := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_SUBTYPE');
1213:
1214: transaction_type := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_TYPE');
1215: if ( transaction_type is null ) then
1216: wf_core.token('ECX_TRANSACTION_TYPE','NULL');
1217: wf_core.raise('WFSQL_ARGS');
1218: end if;
1219:
1220: transaction_subtype := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_SUBTYPE');
1221: if ( transaction_subtype is null ) then
1218: end if;
1219:
1220: transaction_subtype := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_SUBTYPE');
1221: if ( transaction_subtype is null ) then
1222: wf_core.token('ECX_TRANSACTION_SUBTYPE','NULL');
1223: wf_core.raise('WFSQL_ARGS');
1224: end if;
1225:
1226: party_site_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_SITE_ID');
1219:
1220: transaction_subtype := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_SUBTYPE');
1221: if ( transaction_subtype is null ) then
1222: wf_core.token('ECX_TRANSACTION_SUBTYPE','NULL');
1223: wf_core.raise('WFSQL_ARGS');
1224: end if;
1225:
1226: party_site_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_SITE_ID');
1227:
1227:
1228: if ( transaction_type <> 'ECX' and transaction_subtype <> 'CBODO' )
1229: then
1230: if ( party_site_id is null ) then
1231: wf_core.token('ECX_PARTY_SITE_ID','NULL');
1232: wf_core.raise('WFSQL_ARGS');
1233: end if;
1234: end if;
1235:
1228: if ( transaction_type <> 'ECX' and transaction_subtype <> 'CBODO' )
1229: then
1230: if ( party_site_id is null ) then
1231: wf_core.token('ECX_PARTY_SITE_ID','NULL');
1232: wf_core.raise('WFSQL_ARGS');
1233: end if;
1234: end if;
1235:
1236: -- party_id is optional. Only party_site_id is required
1249: -- Verify that the attr type = EVENT
1250:
1251: evt_name := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE');
1252: if ( evt_name is null ) then
1253: wf_core.token('ECX_EVENT_MESSAGE','NULL');
1254: wf_core.raise('WFSQL_ARGS');
1255: end if;
1256:
1257: Wf_Engine.GetItemAttrInfo(itemtype, evt_name ,atype, asubtype, aformat);
1250:
1251: evt_name := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE');
1252: if ( evt_name is null ) then
1253: wf_core.token('ECX_EVENT_MESSAGE','NULL');
1254: wf_core.raise('WFSQL_ARGS');
1255: end if;
1256:
1257: Wf_Engine.GetItemAttrInfo(itemtype, evt_name ,atype, asubtype, aformat);
1258: if (atype <> 'EVENT' ) then
1255: end if;
1256:
1257: Wf_Engine.GetItemAttrInfo(itemtype, evt_name ,atype, asubtype, aformat);
1258: if (atype <> 'EVENT' ) then
1259: wf_core.token('VTYPE',atype);
1260: wf_core.raise('WFXXXV_VTYPE');
1261: end if;
1262:
1263: i_event := Wf_Engine.GetItemAttrEvent(itemtype, itemkey, evt_name);
1256:
1257: Wf_Engine.GetItemAttrInfo(itemtype, evt_name ,atype, asubtype, aformat);
1258: if (atype <> 'EVENT' ) then
1259: wf_core.token('VTYPE',atype);
1260: wf_core.raise('WFXXXV_VTYPE');
1261: end if;
1262:
1263: i_event := Wf_Engine.GetItemAttrEvent(itemtype, itemkey, evt_name);
1264: /**
1351: begin
1352: select name
1353: into i_from_system_name
1354: from wf_systems
1355: where guid = wf_core.translate('WF_SYSTEM_GUID');
1356: exception
1357: when others then
1358: raise;
1359: end;
1436: p_party_id, p_party_site_id, p_party_type,
1437: document_id, ecx_utils.i_ret_code, ecx_utils.i_errbuf
1438: );
1439:
1440: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1441: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
1442: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
1443: wf_core.raise('ECX_TRANSACTION_NOT_DEFINED');
1444: when ecx_document.ecx_no_delivery_required then
1437: document_id, ecx_utils.i_ret_code, ecx_utils.i_errbuf
1438: );
1439:
1440: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1441: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
1442: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
1443: wf_core.raise('ECX_TRANSACTION_NOT_DEFINED');
1444: when ecx_document.ecx_no_delivery_required then
1445: ecx_errorlog.outbound_trigger
1438: );
1439:
1440: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1441: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
1442: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
1443: wf_core.raise('ECX_TRANSACTION_NOT_DEFINED');
1444: when ecx_document.ecx_no_delivery_required then
1445: ecx_errorlog.outbound_trigger
1446: (
1439:
1440: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1441: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
1442: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
1443: wf_core.raise('ECX_TRANSACTION_NOT_DEFINED');
1444: when ecx_document.ecx_no_delivery_required then
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');
1454: IF g_instlmode = 'EMBEDDED'
1455: THEN
1456: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,
1449: document_id, ecx_utils.i_ret_code, ecx_utils.i_errbuf
1450: );
1451:
1452: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1453: g_instlmode := wf_core.translate('WF_INSTALL');
1454: IF g_instlmode = 'EMBEDDED'
1455: THEN
1456: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,
1457: ecx_utils.i_errparams));
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
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));
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));
1463: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
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;
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
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
1468: (
1470: p_party_id, p_party_site_id, p_party_type,
1471: document_id, ecx_utils.i_ret_code, ecx_utils.i_errbuf
1472: );
1473:
1474: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1475: wf_core.token('ECX_PARTY_ID', party_id);
1476: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
1477: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
1478: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
1471: document_id, ecx_utils.i_ret_code, ecx_utils.i_errbuf
1472: );
1473:
1474: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1475: wf_core.token('ECX_PARTY_ID', party_id);
1476: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
1477: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
1478: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
1479: wf_core.raise('ECX_NO_PARTY_SETUP');
1472: );
1473:
1474: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1475: wf_core.token('ECX_PARTY_ID', party_id);
1476: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
1477: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
1478: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
1479: wf_core.raise('ECX_NO_PARTY_SETUP');
1480: when ecx_document.ecx_delivery_setup_error then
1473:
1474: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1475: wf_core.token('ECX_PARTY_ID', party_id);
1476: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
1477: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
1478: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
1479: wf_core.raise('ECX_NO_PARTY_SETUP');
1480: when ecx_document.ecx_delivery_setup_error then
1481: ecx_errorlog.outbound_trigger
1474: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1475: wf_core.token('ECX_PARTY_ID', party_id);
1476: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
1477: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
1478: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
1479: wf_core.raise('ECX_NO_PARTY_SETUP');
1480: when ecx_document.ecx_delivery_setup_error then
1481: ecx_errorlog.outbound_trigger
1482: (
1475: wf_core.token('ECX_PARTY_ID', party_id);
1476: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
1477: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
1478: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
1479: wf_core.raise('ECX_NO_PARTY_SETUP');
1480: when ecx_document.ecx_delivery_setup_error then
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);
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');
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
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
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: (
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,
1499: document_id, ecx_utils.i_ret_code, ecx_utils.i_errbuf
1500: );
1501:
1502: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1503: g_instlmode := wf_core.translate('WF_INSTALL');
1504: IF g_instlmode = 'EMBEDDED'
1505: THEN
1506: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,
1499: document_id, ecx_utils.i_ret_code, ecx_utils.i_errbuf
1500: );
1501:
1502: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1503: g_instlmode := wf_core.translate('WF_INSTALL');
1504: IF g_instlmode = 'EMBEDDED'
1505: THEN
1506: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,
1507: ecx_utils.i_errparams));
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
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));
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));
1513: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
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;
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
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
1518: (
1520: p_party_id, p_party_site_id, p_party_type,
1521: document_id, ecx_utils.i_ret_code, ecx_utils.i_errbuf
1522: );
1523:
1524: Wf_Core.Context('ECX_STANDARD', 'getXMLTP', itemtype, itemkey, to_char(actid), funcmode);
1525: raise;
1526: end getXMLTP;
1527:
1528:
1607: return;
1608: end if;
1609: i_map_code := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MAP_CODE');
1610: if (i_map_code is null ) then
1611: wf_core.token('ECX_MAP_CODE','NULL');
1612: wf_core.raise('WFSQL_ARGS');
1613: end if;
1614:
1615:
1608: end if;
1609: i_map_code := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MAP_CODE');
1610: if (i_map_code is null ) then
1611: wf_core.token('ECX_MAP_CODE','NULL');
1612: wf_core.raise('WFSQL_ARGS');
1613: end if;
1614:
1615:
1616: document_id := Wf_Engine.GetActivityAttrTEXT(itemtype, itemkey, actid, 'ECX_DOCUMENT_ID');
1628: -- Verify that the attr type = EVENT
1629:
1630: evt_name := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE');
1631: if ( evt_name is null ) then
1632: wf_core.token('ECX_EVENT_MESSAGE','NULL');
1633: wf_core.raise('WFSQL_ARGS');
1634: end if;
1635:
1636: Wf_Engine.GetItemAttrInfo(itemtype, evt_name ,atype, asubtype, aformat);
1629:
1630: evt_name := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE');
1631: if ( evt_name is null ) then
1632: wf_core.token('ECX_EVENT_MESSAGE','NULL');
1633: wf_core.raise('WFSQL_ARGS');
1634: end if;
1635:
1636: Wf_Engine.GetItemAttrInfo(itemtype, evt_name ,atype, asubtype, aformat);
1637: if (atype <> 'EVENT' ) then
1634: end if;
1635:
1636: Wf_Engine.GetItemAttrInfo(itemtype, evt_name ,atype, asubtype, aformat);
1637: if (atype <> 'EVENT' ) then
1638: wf_core.token('VTYPE',atype);
1639: wf_core.raise('WFXXXV_VTYPE');
1640: end if;
1641:
1642: i_event := Wf_Engine.GetItemAttrEvent(itemtype, itemkey, evt_name);
1635:
1636: Wf_Engine.GetItemAttrInfo(itemtype, evt_name ,atype, asubtype, aformat);
1637: if (atype <> 'EVENT' ) then
1638: wf_core.token('VTYPE',atype);
1639: wf_core.raise('WFXXXV_VTYPE');
1640: end if;
1641:
1642: i_event := Wf_Engine.GetItemAttrEvent(itemtype, itemkey, evt_name);
1643:
1699: resultout := 'COMPLETE:';
1700:
1701: exception
1702: when others then
1703: Wf_Core.Context('ECX_STANDARD', 'getXML', itemtype, itemkey, to_char(actid), funcmode);
1704: raise;
1705: end getXML;
1706:
1707:
1764: result := 'COMPLETE:';
1765: return;
1766: elsif retcode = 1
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));
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
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));
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));
1778: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
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;
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
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');
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));
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
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));
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));
1793: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
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;
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:
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:
1798: result := 'COMPLETE:';
1827: return;
1828:
1829: exception
1830: when others then
1831: wf_core.context('ECX_STANDARD', 'Reprocess_Inbound',itemtype, itemkey, to_char(actid),funcmode,retcode, errmsg);
1832: raise;
1833: end Reprocess_Inbound;
1834:
1835: procedure resend
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,
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));
1882: wf_core.raise('ECX_RESEND_ERROR');
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:
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:';
1886: return;
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)