31: when others then
32:
33: -- If item attribute does not exist then create it;
34:
35: if ( wf_core.error_name = 'WFENG_ITEM_ATTR' ) then
36: wf_engine.AddItemAttr(itemtype,itemkey,'ECX_ERROR_TYPE',null,ecx_utils.error_type,null);
37: else
38: raise;
39: end if;
45: when others then
46:
47: -- If item attribute does not exist then create it;
48:
49: if ( wf_core.error_name = 'WFENG_ITEM_ATTR' ) then
50: wf_engine.AddItemAttr(itemtype,itemkey,'ECX_LOG_FILE',ecx_utils.g_logfile,null,null);
51: else
52: raise;
53: end if;
187: then
188: return;
189: elsif retcode = 1
190: then
191: g_instlmode := wf_core.translate('WF_INSTALL');
192: IF g_instlmode = 'EMBEDDED'
193: THEN
194: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
195: ecx_utils.i_errparams));
190: then
191: g_instlmode := wf_core.translate('WF_INSTALL');
192: IF g_instlmode = 'EMBEDDED'
193: THEN
194: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
195: ecx_utils.i_errparams));
196: wf_core.token('ECX_LOGFILE',logfile);
197: wf_core.raise('ECX_PROCESS_XMLERROR_EMBD');
198: ELSE
192: IF g_instlmode = 'EMBEDDED'
193: THEN
194: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
195: ecx_utils.i_errparams));
196: wf_core.token('ECX_LOGFILE',logfile);
197: wf_core.raise('ECX_PROCESS_XMLERROR_EMBD');
198: ELSE
199: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
200: ecx_utils.i_errparams));
193: THEN
194: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
195: ecx_utils.i_errparams));
196: wf_core.token('ECX_LOGFILE',logfile);
197: wf_core.raise('ECX_PROCESS_XMLERROR_EMBD');
198: ELSE
199: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
200: ecx_utils.i_errparams));
201: wf_core.token('ECX_LOGFILE',logfile);
195: ecx_utils.i_errparams));
196: wf_core.token('ECX_LOGFILE',logfile);
197: wf_core.raise('ECX_PROCESS_XMLERROR_EMBD');
198: ELSE
199: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
200: ecx_utils.i_errparams));
201: wf_core.token('ECX_LOGFILE',logfile);
202: wf_core.raise('ECX_PROCESS_XMLERROR');
203: END IF;
197: wf_core.raise('ECX_PROCESS_XMLERROR_EMBD');
198: ELSE
199: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
200: ecx_utils.i_errparams));
201: wf_core.token('ECX_LOGFILE',logfile);
202: wf_core.raise('ECX_PROCESS_XMLERROR');
203: END IF;
204: else
205: g_instlmode := wf_core.translate('WF_INSTALL');
198: ELSE
199: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
200: ecx_utils.i_errparams));
201: wf_core.token('ECX_LOGFILE',logfile);
202: wf_core.raise('ECX_PROCESS_XMLERROR');
203: END IF;
204: else
205: g_instlmode := wf_core.translate('WF_INSTALL');
206: IF g_instlmode = 'EMBEDDED'
201: wf_core.token('ECX_LOGFILE',logfile);
202: wf_core.raise('ECX_PROCESS_XMLERROR');
203: END IF;
204: else
205: g_instlmode := wf_core.translate('WF_INSTALL');
206: IF g_instlmode = 'EMBEDDED'
207: THEN
208: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
209: ecx_utils.i_errparams));
204: else
205: g_instlmode := wf_core.translate('WF_INSTALL');
206: IF g_instlmode = 'EMBEDDED'
207: THEN
208: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
209: ecx_utils.i_errparams));
210: wf_core.token('ECX_LOGFILE',logfile);
211: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
212: ELSE
206: IF g_instlmode = 'EMBEDDED'
207: THEN
208: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
209: ecx_utils.i_errparams));
210: wf_core.token('ECX_LOGFILE',logfile);
211: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
212: ELSE
213: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
214: ecx_utils.i_errparams));
207: THEN
208: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
209: ecx_utils.i_errparams));
210: wf_core.token('ECX_LOGFILE',logfile);
211: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
212: ELSE
213: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
214: ecx_utils.i_errparams));
215: wf_core.token('ECX_LOGFILE',logfile);
209: ecx_utils.i_errparams));
210: wf_core.token('ECX_LOGFILE',logfile);
211: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
212: ELSE
213: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
214: ecx_utils.i_errparams));
215: wf_core.token('ECX_LOGFILE',logfile);
216: wf_core.raise('ECX_PROGRAM_EXIT');
217: END IF;
211: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
212: ELSE
213: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
214: ecx_utils.i_errparams));
215: wf_core.token('ECX_LOGFILE',logfile);
216: wf_core.raise('ECX_PROGRAM_EXIT');
217: END IF;
218: end if;
219: exception
212: ELSE
213: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
214: ecx_utils.i_errparams));
215: wf_core.token('ECX_LOGFILE',logfile);
216: wf_core.raise('ECX_PROGRAM_EXIT');
217: END IF;
218: end if;
219: exception
220: when others then
217: END IF;
218: end if;
219: exception
220: when others then
221: wf_core.context('ECX_STANDARD','XMLtoXMLCover',i_map_code,i_debug_level);
222: raise;
223: end XMLtoXMLCover;
224:
225: procedure processXMLCover
250: then
251: return;
252: elsif retcode = 1
253: then
254: g_instlmode := wf_core.translate('WF_INSTALL');
255: IF g_instlmode = 'EMBEDDED'
256: THEN
257: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
258: ecx_utils.i_errparams));
253: then
254: g_instlmode := wf_core.translate('WF_INSTALL');
255: IF g_instlmode = 'EMBEDDED'
256: THEN
257: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
258: ecx_utils.i_errparams));
259: wf_core.token('ECX_LOGFILE',logfile);
260: wf_core.raise('ECX_PROCESS_XMLERROR_EMBD');
261: ELSE
255: IF g_instlmode = 'EMBEDDED'
256: THEN
257: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
258: ecx_utils.i_errparams));
259: wf_core.token('ECX_LOGFILE',logfile);
260: wf_core.raise('ECX_PROCESS_XMLERROR_EMBD');
261: ELSE
262: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
263: ecx_utils.i_errparams));
256: THEN
257: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
258: ecx_utils.i_errparams));
259: wf_core.token('ECX_LOGFILE',logfile);
260: wf_core.raise('ECX_PROCESS_XMLERROR_EMBD');
261: ELSE
262: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
263: ecx_utils.i_errparams));
264: wf_core.token('ECX_LOGFILE',logfile);
258: ecx_utils.i_errparams));
259: wf_core.token('ECX_LOGFILE',logfile);
260: wf_core.raise('ECX_PROCESS_XMLERROR_EMBD');
261: ELSE
262: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
263: ecx_utils.i_errparams));
264: wf_core.token('ECX_LOGFILE',logfile);
265: wf_core.raise('ECX_PROCESS_XMLERROR');
266: END IF;
260: wf_core.raise('ECX_PROCESS_XMLERROR_EMBD');
261: ELSE
262: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
263: ecx_utils.i_errparams));
264: wf_core.token('ECX_LOGFILE',logfile);
265: wf_core.raise('ECX_PROCESS_XMLERROR');
266: END IF;
267: else
268: g_instlmode := wf_core.translate('WF_INSTALL');
261: ELSE
262: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
263: ecx_utils.i_errparams));
264: wf_core.token('ECX_LOGFILE',logfile);
265: wf_core.raise('ECX_PROCESS_XMLERROR');
266: END IF;
267: else
268: g_instlmode := wf_core.translate('WF_INSTALL');
269: IF g_instlmode = 'EMBEDDED'
264: wf_core.token('ECX_LOGFILE',logfile);
265: wf_core.raise('ECX_PROCESS_XMLERROR');
266: END IF;
267: else
268: g_instlmode := wf_core.translate('WF_INSTALL');
269: IF g_instlmode = 'EMBEDDED'
270: THEN
271: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
272: ecx_utils.i_errparams));
267: else
268: g_instlmode := wf_core.translate('WF_INSTALL');
269: IF g_instlmode = 'EMBEDDED'
270: THEN
271: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
272: ecx_utils.i_errparams));
273: wf_core.token('ECX_LOGFILE',logfile);
274: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
275: ELSE
269: IF g_instlmode = 'EMBEDDED'
270: THEN
271: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
272: ecx_utils.i_errparams));
273: wf_core.token('ECX_LOGFILE',logfile);
274: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
275: ELSE
276: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
277: ecx_utils.i_errparams));
270: THEN
271: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
272: ecx_utils.i_errparams));
273: wf_core.token('ECX_LOGFILE',logfile);
274: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
275: ELSE
276: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
277: ecx_utils.i_errparams));
278: wf_core.token('ECX_LOGFILE',logfile);
272: ecx_utils.i_errparams));
273: wf_core.token('ECX_LOGFILE',logfile);
274: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
275: ELSE
276: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
277: ecx_utils.i_errparams));
278: wf_core.token('ECX_LOGFILE',logfile);
279: wf_core.raise('ECX_PROGRAM_EXIT');
280: END IF;
274: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
275: ELSE
276: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
277: ecx_utils.i_errparams));
278: wf_core.token('ECX_LOGFILE',logfile);
279: wf_core.raise('ECX_PROGRAM_EXIT');
280: END IF;
281: end if;
282: exception
275: ELSE
276: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
277: ecx_utils.i_errparams));
278: wf_core.token('ECX_LOGFILE',logfile);
279: wf_core.raise('ECX_PROGRAM_EXIT');
280: END IF;
281: end if;
282: exception
283: when others then
280: END IF;
281: end if;
282: exception
283: when others then
284: wf_core.context('ECX_STANDARD','processXMLCover',i_map_code,i_debug_level);
285: raise;
286: end processXMLCover;
287:
288: procedure getXMLCover
326: then
327: return;
328: elsif retcode = 1
329: then
330: g_instlmode := wf_core.translate('WF_INSTALL');
331: IF g_instlmode = 'EMBEDDED'
332: THEN
333: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
334: ecx_utils.i_errparams));
329: then
330: g_instlmode := wf_core.translate('WF_INSTALL');
331: IF g_instlmode = 'EMBEDDED'
332: THEN
333: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
334: ecx_utils.i_errparams));
335: wf_core.token('ECX_LOGFILE',logfile);
336: wf_core.raise('ECX_GET_XMLERROR_EMBD');
337: ELSE
331: IF g_instlmode = 'EMBEDDED'
332: THEN
333: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
334: ecx_utils.i_errparams));
335: wf_core.token('ECX_LOGFILE',logfile);
336: wf_core.raise('ECX_GET_XMLERROR_EMBD');
337: ELSE
338: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
339: ecx_utils.i_errparams));
332: THEN
333: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
334: ecx_utils.i_errparams));
335: wf_core.token('ECX_LOGFILE',logfile);
336: wf_core.raise('ECX_GET_XMLERROR_EMBD');
337: ELSE
338: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
339: ecx_utils.i_errparams));
340: wf_core.token('ECX_LOGFILE',logfile);
334: ecx_utils.i_errparams));
335: wf_core.token('ECX_LOGFILE',logfile);
336: wf_core.raise('ECX_GET_XMLERROR_EMBD');
337: ELSE
338: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
339: ecx_utils.i_errparams));
340: wf_core.token('ECX_LOGFILE',logfile);
341: wf_core.raise('ECX_GET_XMLERROR');
342: END IF;
336: wf_core.raise('ECX_GET_XMLERROR_EMBD');
337: ELSE
338: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
339: ecx_utils.i_errparams));
340: wf_core.token('ECX_LOGFILE',logfile);
341: wf_core.raise('ECX_GET_XMLERROR');
342: END IF;
343: else
344: g_instlmode := wf_core.translate('WF_INSTALL');
337: ELSE
338: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
339: ecx_utils.i_errparams));
340: wf_core.token('ECX_LOGFILE',logfile);
341: wf_core.raise('ECX_GET_XMLERROR');
342: END IF;
343: else
344: g_instlmode := wf_core.translate('WF_INSTALL');
345: IF g_instlmode = 'EMBEDDED'
340: wf_core.token('ECX_LOGFILE',logfile);
341: wf_core.raise('ECX_GET_XMLERROR');
342: END IF;
343: else
344: g_instlmode := wf_core.translate('WF_INSTALL');
345: IF g_instlmode = 'EMBEDDED'
346: THEN
347: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
348: ecx_utils.i_errparams));
343: else
344: g_instlmode := wf_core.translate('WF_INSTALL');
345: IF g_instlmode = 'EMBEDDED'
346: THEN
347: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
348: ecx_utils.i_errparams));
349: wf_core.token('ECX_LOGFILE',logfile);
350: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
351: ELSE
345: IF g_instlmode = 'EMBEDDED'
346: THEN
347: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
348: ecx_utils.i_errparams));
349: wf_core.token('ECX_LOGFILE',logfile);
350: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
351: ELSE
352: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
353: ecx_utils.i_errparams));
346: THEN
347: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
348: ecx_utils.i_errparams));
349: wf_core.token('ECX_LOGFILE',logfile);
350: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
351: ELSE
352: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
353: ecx_utils.i_errparams));
354: wf_core.token('ECX_LOGFILE',logfile);
348: ecx_utils.i_errparams));
349: wf_core.token('ECX_LOGFILE',logfile);
350: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
351: ELSE
352: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
353: ecx_utils.i_errparams));
354: wf_core.token('ECX_LOGFILE',logfile);
355: wf_core.raise('ECX_PROGRAM_EXIT');
356: END IF;
350: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
351: ELSE
352: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
353: ecx_utils.i_errparams));
354: wf_core.token('ECX_LOGFILE',logfile);
355: wf_core.raise('ECX_PROGRAM_EXIT');
356: END IF;
357: end if;
358: exception
351: ELSE
352: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
353: ecx_utils.i_errparams));
354: wf_core.token('ECX_LOGFILE',logfile);
355: wf_core.raise('ECX_PROGRAM_EXIT');
356: END IF;
357: end if;
358: exception
359: when others then
356: END IF;
357: end if;
358: exception
359: when others then
360: wf_core.context('ECX_STANDARD','getXMLCover',i_message_standard,i_transaction_type,i_transaction_subtype);
361: raise;
362: end getXMLCover;
363:
364: /** (Synchronous) Send Direct api to avoid racing condition **/
395: then
396: return;
397: elsif retcode = 1
398: then
399: g_instlmode := wf_core.translate('WF_INSTALL');
400: IF g_instlmode = 'EMBEDDED'
401: THEN
402: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
403: ecx_utils.i_errparams));
398: then
399: g_instlmode := wf_core.translate('WF_INSTALL');
400: IF g_instlmode = 'EMBEDDED'
401: THEN
402: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
403: ecx_utils.i_errparams));
404: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
405: wf_core.raise('ECX_SENDDIRECT_ERROR_EMBD');
406: ELSE
400: IF g_instlmode = 'EMBEDDED'
401: THEN
402: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
403: ecx_utils.i_errparams));
404: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
405: wf_core.raise('ECX_SENDDIRECT_ERROR_EMBD');
406: ELSE
407: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
408: ecx_utils.i_errparams));
401: THEN
402: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
403: ecx_utils.i_errparams));
404: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
405: wf_core.raise('ECX_SENDDIRECT_ERROR_EMBD');
406: ELSE
407: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
408: ecx_utils.i_errparams));
409: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
403: ecx_utils.i_errparams));
404: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
405: wf_core.raise('ECX_SENDDIRECT_ERROR_EMBD');
406: ELSE
407: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
408: ecx_utils.i_errparams));
409: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
410: wf_core.raise('ECX_SENDDIRECT_ERROR');
411: END IF;
405: wf_core.raise('ECX_SENDDIRECT_ERROR_EMBD');
406: ELSE
407: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
408: ecx_utils.i_errparams));
409: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
410: wf_core.raise('ECX_SENDDIRECT_ERROR');
411: END IF;
412: else
413: g_instlmode := wf_core.translate('WF_INSTALL');
406: ELSE
407: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
408: ecx_utils.i_errparams));
409: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
410: wf_core.raise('ECX_SENDDIRECT_ERROR');
411: END IF;
412: else
413: g_instlmode := wf_core.translate('WF_INSTALL');
414: IF g_instlmode = 'EMBEDDED'
409: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
410: wf_core.raise('ECX_SENDDIRECT_ERROR');
411: END IF;
412: else
413: g_instlmode := wf_core.translate('WF_INSTALL');
414: IF g_instlmode = 'EMBEDDED'
415: THEN
416: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
417: ecx_utils.i_errparams));
412: else
413: g_instlmode := wf_core.translate('WF_INSTALL');
414: IF g_instlmode = 'EMBEDDED'
415: THEN
416: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
417: ecx_utils.i_errparams));
418: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
419: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
420: ELSE
414: IF g_instlmode = 'EMBEDDED'
415: THEN
416: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
417: ecx_utils.i_errparams));
418: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
419: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
420: ELSE
421: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
422: ecx_utils.i_errparams));
415: THEN
416: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
417: ecx_utils.i_errparams));
418: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
419: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
420: ELSE
421: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
422: ecx_utils.i_errparams));
423: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
417: ecx_utils.i_errparams));
418: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
419: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
420: ELSE
421: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
422: ecx_utils.i_errparams));
423: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
424: wf_core.raise('ECX_PROGRAM_EXIT');
425: END IF;
419: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
420: ELSE
421: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
422: ecx_utils.i_errparams));
423: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
424: wf_core.raise('ECX_PROGRAM_EXIT');
425: END IF;
426: end if;
427: exception
420: ELSE
421: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
422: ecx_utils.i_errparams));
423: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
424: wf_core.raise('ECX_PROGRAM_EXIT');
425: END IF;
426: end if;
427: exception
428: when others then
425: END IF;
426: end if;
427: exception
428: when others then
429: wf_core.context('ECX_STANDARD','sendDirectCover',transaction_type,transaction_subtype);
430: raise;
431: end sendDirectCover;
432:
433:
497: exception
498: when others then
499: retcode := 2;
500: retmsg := ecx_debug.getTranslatedMessage('ECX_BUSINESS_EVT_SET_ERROR');
501: wf_core.raise('ECX_EVENT_ERROR');
502: end setEventDetails;
503:
504:
505: -- Generate (PUBLIC)
543: map_code := wf_event.getValueForParameter('ECX_MAP_CODE',p_parameter_list);
544: debug_level := wf_event.getValueForParameter('ECX_DEBUG_LEVEL',p_parameter_list);
545: /** Which exception to use here for throwing the Error to BES **/
546: if (map_code is null ) then
547: wf_core.token('MAP_CODE','NULL');
548: wf_core.raise('WFSQL_ARGS');
549: end if;
550:
551: /** Everything else is optional set of parameters **/
544: debug_level := wf_event.getValueForParameter('ECX_DEBUG_LEVEL',p_parameter_list);
545: /** Which exception to use here for throwing the Error to BES **/
546: if (map_code is null ) then
547: wf_core.token('MAP_CODE','NULL');
548: wf_core.raise('WFSQL_ARGS');
549: end if;
550:
551: /** Everything else is optional set of parameters **/
552: transaction_type := wf_event.getValueForParameter('ECX_TRANSACTION_TYPE',p_parameter_list);
581: --dbms_lob.freetemporary(p_xmldoc);
582: return p_xmldoc;
583: exception
584: when others then
585: wf_core.context('ECX_STANDARD', 'Generate', p_event_name, p_event_key);
586: raise;
587: end Generate;
588:
589: -- XMLtoXML
639: -- Get ecx map code
640:
641: i_map_code := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MAP_CODE');
642: if (i_map_code is null ) then
643: wf_core.token('ECX_MAP_CODE','NULL');
644: wf_core.raise('WFSQL_ARGS');
645: end if;
646:
647:
640:
641: i_map_code := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MAP_CODE');
642: if (i_map_code is null ) then
643: wf_core.token('ECX_MAP_CODE','NULL');
644: wf_core.raise('WFSQL_ARGS');
645: end if;
646:
647:
648:
652: -- Verify that the attr type = EVENT
653:
654: i_inevent := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE_IN');
655: if (i_inevent is null ) then
656: wf_core.token('ECX_EVENT_MESSAGE_IN','NULL');
657: wf_core.raise('WFSQL_ARGS');
658: end if;
659:
660: aname := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE_OUT');
653:
654: i_inevent := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE_IN');
655: if (i_inevent is null ) then
656: wf_core.token('ECX_EVENT_MESSAGE_IN','NULL');
657: wf_core.raise('WFSQL_ARGS');
658: end if;
659:
660: aname := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE_OUT');
661: if ( aname is null ) then
658: end if;
659:
660: aname := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE_OUT');
661: if ( aname is null ) then
662: wf_core.token('ECX_EVENT_MESSAGE_OUT','NULL');
663: wf_core.raise('WFSQL_ARGS');
664: end if;
665:
666: --Wf_Engine.GetItemAttrInfo(itemtype, aname ,atype, asubtype, aformat);
659:
660: aname := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE_OUT');
661: if ( aname is null ) then
662: wf_core.token('ECX_EVENT_MESSAGE_OUT','NULL');
663: wf_core.raise('WFSQL_ARGS');
664: end if;
665:
666: --Wf_Engine.GetItemAttrInfo(itemtype, aname ,atype, asubtype, aformat);
667: --if (atype <> 'EVENT' ) then
664: end if;
665:
666: --Wf_Engine.GetItemAttrInfo(itemtype, aname ,atype, asubtype, aformat);
667: --if (atype <> 'EVENT' ) then
668: --wf_core.token('VTYPE',atype);
669: --wf_core.raise('WFXXXV_VTYPE');
670: --end if;
671:
672: i_outevent := Wf_Engine.GetItemAttrEvent(itemtype, itemkey, aname);
665:
666: --Wf_Engine.GetItemAttrInfo(itemtype, aname ,atype, asubtype, aformat);
667: --if (atype <> 'EVENT' ) then
668: --wf_core.token('VTYPE',atype);
669: --wf_core.raise('WFXXXV_VTYPE');
670: --end if;
671:
672: i_outevent := Wf_Engine.GetItemAttrEvent(itemtype, itemkey, aname);
673:
686:
687: resultout := 'COMPLETE:';
688: exception
689: when others then
690: Wf_Core.Context('ECX_STANDARD', 'XMLtoXML',itemtype,itemkey, to_char(actid), funcmode);
691: raise;
692: end XMLtoXML;
693:
694: procedure ProcessXML(itemtype in varchar2,
725: -- Get ecx map code
726:
727: i_map_code := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MAP_CODE');
728: if (i_map_code is null ) then
729: wf_core.token('ECX_MAP_CODE','NULL');
730: wf_core.raise('WFSQL_ARGS');
731: end if;
732:
733:
726:
727: i_map_code := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MAP_CODE');
728: if (i_map_code is null ) then
729: wf_core.token('ECX_MAP_CODE','NULL');
730: wf_core.raise('WFSQL_ARGS');
731: end if;
732:
733:
734:
734:
735: i_debug_level := nvl(wf_engine.GetItemAttrText(itemtype,itemkey,'ECX_DEBUG_LEVEL',true),0);
736: i_event := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE');
737: if (i_event is null ) then
738: wf_core.token('ECX_EVENT_MESSAGE','NULL');
739: wf_core.raise('WFSQL_ARGS');
740: end if;
741:
742: -- extract payload and pass to ECX
735: i_debug_level := nvl(wf_engine.GetItemAttrText(itemtype,itemkey,'ECX_DEBUG_LEVEL',true),0);
736: i_event := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE');
737: if (i_event is null ) then
738: wf_core.token('ECX_EVENT_MESSAGE','NULL');
739: wf_core.raise('WFSQL_ARGS');
740: end if;
741:
742: -- extract payload and pass to ECX
743:
755:
756: resultout := 'COMPLETE:';
757: exception
758: when others then
759: Wf_Core.Context('ECX_STANDARD', 'PROCESSXML',itemtype,itemkey, to_char(actid), funcmode);
760: raise;
761: end processXML;
762:
763: -- IsDeliveryRequired
807: -- Retreive Activity Attributes
808:
809: transaction_type := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_TYPE');
810: if ( transaction_type is null ) then
811: wf_core.token('ECX_TRANSACTION_TYPE','NULL');
812: wf_core.raise('WFSQL_ARGS');
813: end if;
814:
815: transaction_subtype := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_SUBTYPE');
808:
809: transaction_type := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_TYPE');
810: if ( transaction_type is null ) then
811: wf_core.token('ECX_TRANSACTION_TYPE','NULL');
812: wf_core.raise('WFSQL_ARGS');
813: end if;
814:
815: transaction_subtype := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_SUBTYPE');
816: if ( transaction_subtype is null ) then
813: end if;
814:
815: transaction_subtype := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_SUBTYPE');
816: if ( transaction_subtype is null ) then
817: wf_core.token('ECX_TRANSACTION_SUBTYPE','NULL');
818: wf_core.raise('WFSQL_ARGS');
819: end if;
820:
821: party_site_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_SITE_ID');
814:
815: transaction_subtype := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_SUBTYPE');
816: if ( transaction_subtype is null ) then
817: wf_core.token('ECX_TRANSACTION_SUBTYPE','NULL');
818: wf_core.raise('WFSQL_ARGS');
819: end if;
820:
821: party_site_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_SITE_ID');
822: if ( party_site_id is null ) then
819: end if;
820:
821: party_site_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_SITE_ID');
822: if ( party_site_id is null ) then
823: wf_core.token('ECX_PARTY_SITE_ID','NULL');
824: wf_core.raise('WFSQL_ARGS');
825: end if;
826:
827: -- party_id is optional. Only party_site_id is required
820:
821: party_site_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_SITE_ID');
822: if ( party_site_id is null ) then
823: wf_core.token('ECX_PARTY_SITE_ID','NULL');
824: wf_core.raise('WFSQL_ARGS');
825: end if;
826:
827: -- party_id is optional. Only party_site_id is required
828:
871: resultout := 'COMPLETE:F';
872: end if;
873: exception
874: when ecx_document.ecx_transaction_not_defined then
875: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
876: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
877: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
878: wf_core.raise('ECX_TRANSACTION_NOT_DEFINED');
879: when ecx_document.ecx_delivery_setup_error then
872: end if;
873: exception
874: when ecx_document.ecx_transaction_not_defined then
875: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
876: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
877: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
878: wf_core.raise('ECX_TRANSACTION_NOT_DEFINED');
879: when ecx_document.ecx_delivery_setup_error then
880: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
873: exception
874: when ecx_document.ecx_transaction_not_defined then
875: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
876: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
877: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
878: wf_core.raise('ECX_TRANSACTION_NOT_DEFINED');
879: when ecx_document.ecx_delivery_setup_error then
880: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
881: wf_core.token('ECX_PARTY_ID', party_id);
874: when ecx_document.ecx_transaction_not_defined then
875: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
876: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
877: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
878: wf_core.raise('ECX_TRANSACTION_NOT_DEFINED');
879: when ecx_document.ecx_delivery_setup_error then
880: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
881: wf_core.token('ECX_PARTY_ID', party_id);
882: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
876: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
877: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
878: wf_core.raise('ECX_TRANSACTION_NOT_DEFINED');
879: when ecx_document.ecx_delivery_setup_error then
880: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
881: wf_core.token('ECX_PARTY_ID', party_id);
882: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
883: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
884: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
877: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
878: wf_core.raise('ECX_TRANSACTION_NOT_DEFINED');
879: when ecx_document.ecx_delivery_setup_error then
880: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
881: wf_core.token('ECX_PARTY_ID', party_id);
882: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
883: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
884: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
885: wf_core.raise('ECX_DELIVERY_SETUP_ERROR');
878: wf_core.raise('ECX_TRANSACTION_NOT_DEFINED');
879: when ecx_document.ecx_delivery_setup_error then
880: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
881: wf_core.token('ECX_PARTY_ID', party_id);
882: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
883: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
884: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
885: wf_core.raise('ECX_DELIVERY_SETUP_ERROR');
886:
879: when ecx_document.ecx_delivery_setup_error then
880: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
881: wf_core.token('ECX_PARTY_ID', party_id);
882: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
883: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
884: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
885: wf_core.raise('ECX_DELIVERY_SETUP_ERROR');
886:
887: when ecx_utils.program_exit then
880: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
881: wf_core.token('ECX_PARTY_ID', party_id);
882: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
883: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
884: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
885: wf_core.raise('ECX_DELIVERY_SETUP_ERROR');
886:
887: when ecx_utils.program_exit then
888: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
881: wf_core.token('ECX_PARTY_ID', party_id);
882: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
883: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
884: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
885: wf_core.raise('ECX_DELIVERY_SETUP_ERROR');
886:
887: when ecx_utils.program_exit then
888: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
889: g_instlmode := wf_core.translate('WF_INSTALL');
884: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
885: wf_core.raise('ECX_DELIVERY_SETUP_ERROR');
886:
887: when ecx_utils.program_exit then
888: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
889: g_instlmode := wf_core.translate('WF_INSTALL');
890: IF g_instlmode = 'EMBEDDED'
891: THEN
892: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,
885: wf_core.raise('ECX_DELIVERY_SETUP_ERROR');
886:
887: when ecx_utils.program_exit then
888: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
889: g_instlmode := wf_core.translate('WF_INSTALL');
890: IF g_instlmode = 'EMBEDDED'
891: THEN
892: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,
893: ecx_utils.i_errparams));
888: wf_core.context('ECX_STANDARD','isDeliveryRequiredCover',transaction_type,transaction_subtype, party_id,party_site_id);
889: g_instlmode := wf_core.translate('WF_INSTALL');
890: IF g_instlmode = 'EMBEDDED'
891: THEN
892: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,
893: ecx_utils.i_errparams));
894: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
895: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
896: ELSE
890: IF g_instlmode = 'EMBEDDED'
891: THEN
892: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,
893: ecx_utils.i_errparams));
894: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
895: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
896: ELSE
897: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
898: ecx_utils.i_errparams));
891: THEN
892: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,
893: ecx_utils.i_errparams));
894: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
895: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
896: ELSE
897: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
898: ecx_utils.i_errparams));
899: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
893: ecx_utils.i_errparams));
894: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
895: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
896: ELSE
897: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
898: ecx_utils.i_errparams));
899: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
900: wf_core.raise('ECX_PROGRAM_EXIT');
901: END IF;
895: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
896: ELSE
897: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
898: ecx_utils.i_errparams));
899: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
900: wf_core.raise('ECX_PROGRAM_EXIT');
901: END IF;
902:
903: when others then
896: ELSE
897: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
898: ecx_utils.i_errparams));
899: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
900: wf_core.raise('ECX_PROGRAM_EXIT');
901: END IF;
902:
903: when others then
904: raise;
966: -- We need to determine which parameters are required and which are optional
967:
968: transaction_type := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_TYPE');
969: if ( transaction_type is null ) then
970: wf_core.token('ECX_TRANSACTION_TYPE','NULL');
971: wf_core.raise('WFSQL_ARGS');
972: end if;
973:
974: transaction_subtype := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_SUBTYPE');
967:
968: transaction_type := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_TYPE');
969: if ( transaction_type is null ) then
970: wf_core.token('ECX_TRANSACTION_TYPE','NULL');
971: wf_core.raise('WFSQL_ARGS');
972: end if;
973:
974: transaction_subtype := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_SUBTYPE');
975: if ( transaction_subtype is null ) then
972: end if;
973:
974: transaction_subtype := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_SUBTYPE');
975: if ( transaction_subtype is null ) then
976: wf_core.token('ECX_TRANSACTION_SUBTYPE','NULL');
977: wf_core.raise('WFSQL_ARGS');
978: end if;
979:
980: party_site_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_SITE_ID');
973:
974: transaction_subtype := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_SUBTYPE');
975: if ( transaction_subtype is null ) then
976: wf_core.token('ECX_TRANSACTION_SUBTYPE','NULL');
977: wf_core.raise('WFSQL_ARGS');
978: end if;
979:
980: party_site_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_SITE_ID');
981: if ( transaction_type <> 'ECX' and transaction_subtype <> 'CBODO' )
981: if ( transaction_type <> 'ECX' and transaction_subtype <> 'CBODO' )
982: then
983: if ( party_site_id is null )
984: then
985: wf_core.token('ECX_PARTY_SITE_ID','NULL');
986: wf_core.raise('WFSQL_ARGS');
987: end if;
988: end if;
989:
982: then
983: if ( party_site_id is null )
984: then
985: wf_core.token('ECX_PARTY_SITE_ID','NULL');
986: wf_core.raise('WFSQL_ARGS');
987: end if;
988: end if;
989:
990: -- party_id is optional. Only party_site_id is required
998: -- It is an optional Field
999: document_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_DOCUMENT_ID');
1000: /**
1001: if ( document_id is null ) then
1002: wf_core.token('ECX_DOCUMENT_ID','NULL');
1003: wf_core.raise('WFSQL_ARGS');
1004: end if;
1005: **/
1006:
999: document_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_DOCUMENT_ID');
1000: /**
1001: if ( document_id is null ) then
1002: wf_core.token('ECX_DOCUMENT_ID','NULL');
1003: wf_core.raise('WFSQL_ARGS');
1004: end if;
1005: **/
1006:
1007: debug_mode := nvl(Wf_Engine.GetItemAttrText(itemtype, itemkey, 'ECX_DEBUG_LEVEL',true),0);
1103: end if;
1104:
1105: exception
1106: when others then
1107: Wf_Core.Context('ECX_STANDARD', 'Send', itemtype, itemkey, to_char(actid), funcmode);
1108: raise;
1109: end send;
1110:
1111: -- GetXMLTP
1206: -- Retreive Activity Attributes
1207:
1208: transaction_type := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_TYPE');
1209: if ( transaction_type is null ) then
1210: wf_core.token('ECX_TRANSACTION_TYPE','NULL');
1211: wf_core.raise('WFSQL_ARGS');
1212: end if;
1213:
1214: transaction_subtype := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_SUBTYPE');
1207:
1208: transaction_type := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_TYPE');
1209: if ( transaction_type is null ) then
1210: wf_core.token('ECX_TRANSACTION_TYPE','NULL');
1211: wf_core.raise('WFSQL_ARGS');
1212: end if;
1213:
1214: transaction_subtype := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_SUBTYPE');
1215: if ( transaction_subtype is null ) then
1212: end if;
1213:
1214: transaction_subtype := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_SUBTYPE');
1215: if ( transaction_subtype is null ) then
1216: wf_core.token('ECX_TRANSACTION_SUBTYPE','NULL');
1217: wf_core.raise('WFSQL_ARGS');
1218: end if;
1219:
1220: party_site_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_SITE_ID');
1213:
1214: transaction_subtype := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_SUBTYPE');
1215: if ( transaction_subtype is null ) then
1216: wf_core.token('ECX_TRANSACTION_SUBTYPE','NULL');
1217: wf_core.raise('WFSQL_ARGS');
1218: end if;
1219:
1220: party_site_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_SITE_ID');
1221:
1221:
1222: if ( transaction_type <> 'ECX' and transaction_subtype <> 'CBODO' )
1223: then
1224: if ( party_site_id is null ) then
1225: wf_core.token('ECX_PARTY_SITE_ID','NULL');
1226: wf_core.raise('WFSQL_ARGS');
1227: end if;
1228: end if;
1229:
1222: if ( transaction_type <> 'ECX' and transaction_subtype <> 'CBODO' )
1223: then
1224: if ( party_site_id is null ) then
1225: wf_core.token('ECX_PARTY_SITE_ID','NULL');
1226: wf_core.raise('WFSQL_ARGS');
1227: end if;
1228: end if;
1229:
1230: -- party_id is optional. Only party_site_id is required
1243: -- Verify that the attr type = EVENT
1244:
1245: evt_name := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE');
1246: if ( evt_name is null ) then
1247: wf_core.token('ECX_EVENT_MESSAGE','NULL');
1248: wf_core.raise('WFSQL_ARGS');
1249: end if;
1250:
1251: Wf_Engine.GetItemAttrInfo(itemtype, evt_name ,atype, asubtype, aformat);
1244:
1245: evt_name := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE');
1246: if ( evt_name is null ) then
1247: wf_core.token('ECX_EVENT_MESSAGE','NULL');
1248: wf_core.raise('WFSQL_ARGS');
1249: end if;
1250:
1251: Wf_Engine.GetItemAttrInfo(itemtype, evt_name ,atype, asubtype, aformat);
1252: if (atype <> 'EVENT' ) then
1249: end if;
1250:
1251: Wf_Engine.GetItemAttrInfo(itemtype, evt_name ,atype, asubtype, aformat);
1252: if (atype <> 'EVENT' ) then
1253: wf_core.token('VTYPE',atype);
1254: wf_core.raise('WFXXXV_VTYPE');
1255: end if;
1256:
1257: i_event := Wf_Engine.GetItemAttrEvent(itemtype, itemkey, evt_name);
1250:
1251: Wf_Engine.GetItemAttrInfo(itemtype, evt_name ,atype, asubtype, aformat);
1252: if (atype <> 'EVENT' ) then
1253: wf_core.token('VTYPE',atype);
1254: wf_core.raise('WFXXXV_VTYPE');
1255: end if;
1256:
1257: i_event := Wf_Engine.GetItemAttrEvent(itemtype, itemkey, evt_name);
1258: /**
1345: begin
1346: select name
1347: into i_from_system_name
1348: from wf_systems
1349: where guid = wf_core.translate('WF_SYSTEM_GUID');
1350: exception
1351: when others then
1352: raise;
1353: end;
1430: p_party_id, p_party_site_id, p_party_type,
1431: document_id, ecx_utils.i_ret_code, ecx_utils.i_errbuf
1432: );
1433:
1434: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1435: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
1436: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
1437: wf_core.raise('ECX_TRANSACTION_NOT_DEFINED');
1438: when ecx_document.ecx_no_delivery_required then
1431: document_id, ecx_utils.i_ret_code, ecx_utils.i_errbuf
1432: );
1433:
1434: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1435: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
1436: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
1437: wf_core.raise('ECX_TRANSACTION_NOT_DEFINED');
1438: when ecx_document.ecx_no_delivery_required then
1439: ecx_errorlog.outbound_trigger
1432: );
1433:
1434: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1435: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
1436: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
1437: wf_core.raise('ECX_TRANSACTION_NOT_DEFINED');
1438: when ecx_document.ecx_no_delivery_required then
1439: ecx_errorlog.outbound_trigger
1440: (
1433:
1434: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1435: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
1436: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
1437: wf_core.raise('ECX_TRANSACTION_NOT_DEFINED');
1438: when ecx_document.ecx_no_delivery_required then
1439: ecx_errorlog.outbound_trigger
1440: (
1441: trigger_id, transaction_type, transaction_subtype,
1442: p_party_id, p_party_site_id, p_party_type,
1443: document_id, ecx_utils.i_ret_code, ecx_utils.i_errbuf
1444: );
1445:
1446: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1447: g_instlmode := wf_core.translate('WF_INSTALL');
1448: IF g_instlmode = 'EMBEDDED'
1449: THEN
1450: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,
1443: document_id, ecx_utils.i_ret_code, ecx_utils.i_errbuf
1444: );
1445:
1446: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1447: g_instlmode := wf_core.translate('WF_INSTALL');
1448: IF g_instlmode = 'EMBEDDED'
1449: THEN
1450: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,
1451: ecx_utils.i_errparams));
1446: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1447: g_instlmode := wf_core.translate('WF_INSTALL');
1448: IF g_instlmode = 'EMBEDDED'
1449: THEN
1450: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,
1451: ecx_utils.i_errparams));
1452: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1453: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
1454: ELSE
1448: IF g_instlmode = 'EMBEDDED'
1449: THEN
1450: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,
1451: ecx_utils.i_errparams));
1452: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1453: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
1454: ELSE
1455: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1456: ecx_utils.i_errparams));
1449: THEN
1450: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,
1451: ecx_utils.i_errparams));
1452: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1453: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
1454: ELSE
1455: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1456: ecx_utils.i_errparams));
1457: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1451: ecx_utils.i_errparams));
1452: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1453: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
1454: ELSE
1455: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1456: ecx_utils.i_errparams));
1457: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1458: wf_core.raise('ECX_PROGRAM_EXIT');
1459: END IF;
1453: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
1454: ELSE
1455: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1456: ecx_utils.i_errparams));
1457: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1458: wf_core.raise('ECX_PROGRAM_EXIT');
1459: END IF;
1460: when ecx_document.ecx_no_party_setup then
1461: ecx_errorlog.outbound_trigger
1454: ELSE
1455: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1456: ecx_utils.i_errparams));
1457: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1458: wf_core.raise('ECX_PROGRAM_EXIT');
1459: END IF;
1460: when ecx_document.ecx_no_party_setup then
1461: ecx_errorlog.outbound_trigger
1462: (
1464: p_party_id, p_party_site_id, p_party_type,
1465: document_id, ecx_utils.i_ret_code, ecx_utils.i_errbuf
1466: );
1467:
1468: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1469: wf_core.token('ECX_PARTY_ID', party_id);
1470: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
1471: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
1472: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
1465: document_id, ecx_utils.i_ret_code, ecx_utils.i_errbuf
1466: );
1467:
1468: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1469: wf_core.token('ECX_PARTY_ID', party_id);
1470: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
1471: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
1472: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
1473: wf_core.raise('ECX_NO_PARTY_SETUP');
1466: );
1467:
1468: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1469: wf_core.token('ECX_PARTY_ID', party_id);
1470: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
1471: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
1472: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
1473: wf_core.raise('ECX_NO_PARTY_SETUP');
1474: when ecx_document.ecx_delivery_setup_error then
1467:
1468: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1469: wf_core.token('ECX_PARTY_ID', party_id);
1470: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
1471: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
1472: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
1473: wf_core.raise('ECX_NO_PARTY_SETUP');
1474: when ecx_document.ecx_delivery_setup_error then
1475: ecx_errorlog.outbound_trigger
1468: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1469: wf_core.token('ECX_PARTY_ID', party_id);
1470: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
1471: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
1472: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
1473: wf_core.raise('ECX_NO_PARTY_SETUP');
1474: when ecx_document.ecx_delivery_setup_error then
1475: ecx_errorlog.outbound_trigger
1476: (
1469: wf_core.token('ECX_PARTY_ID', party_id);
1470: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
1471: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
1472: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
1473: wf_core.raise('ECX_NO_PARTY_SETUP');
1474: when ecx_document.ecx_delivery_setup_error then
1475: ecx_errorlog.outbound_trigger
1476: (
1477: trigger_id, transaction_type, transaction_subtype,
1478: p_party_id, p_party_site_id, p_party_type,
1479: document_id, ecx_utils.i_ret_code, ecx_utils.i_errbuf
1480: );
1481:
1482: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1483: wf_core.token('ECX_PARTY_ID', party_id);
1484: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
1485: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
1486: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
1479: document_id, ecx_utils.i_ret_code, ecx_utils.i_errbuf
1480: );
1481:
1482: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1483: wf_core.token('ECX_PARTY_ID', party_id);
1484: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
1485: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
1486: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
1487: wf_core.raise('ECX_DELIVERY_SETUP_ERROR');
1480: );
1481:
1482: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1483: wf_core.token('ECX_PARTY_ID', party_id);
1484: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
1485: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
1486: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
1487: wf_core.raise('ECX_DELIVERY_SETUP_ERROR');
1488: when ecx_utils.program_exit then
1481:
1482: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1483: wf_core.token('ECX_PARTY_ID', party_id);
1484: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
1485: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
1486: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
1487: wf_core.raise('ECX_DELIVERY_SETUP_ERROR');
1488: when ecx_utils.program_exit then
1489: ecx_errorlog.outbound_trigger
1482: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1483: wf_core.token('ECX_PARTY_ID', party_id);
1484: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
1485: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
1486: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
1487: wf_core.raise('ECX_DELIVERY_SETUP_ERROR');
1488: when ecx_utils.program_exit then
1489: ecx_errorlog.outbound_trigger
1490: (
1483: wf_core.token('ECX_PARTY_ID', party_id);
1484: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
1485: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
1486: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
1487: wf_core.raise('ECX_DELIVERY_SETUP_ERROR');
1488: when ecx_utils.program_exit then
1489: ecx_errorlog.outbound_trigger
1490: (
1491: trigger_id, transaction_type, transaction_subtype,
1492: p_party_id, p_party_site_id, p_party_type,
1493: document_id, ecx_utils.i_ret_code, ecx_utils.i_errbuf
1494: );
1495:
1496: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1497: g_instlmode := wf_core.translate('WF_INSTALL');
1498: IF g_instlmode = 'EMBEDDED'
1499: THEN
1500: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,
1493: document_id, ecx_utils.i_ret_code, ecx_utils.i_errbuf
1494: );
1495:
1496: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1497: g_instlmode := wf_core.translate('WF_INSTALL');
1498: IF g_instlmode = 'EMBEDDED'
1499: THEN
1500: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,
1501: ecx_utils.i_errparams));
1496: wf_core.context('ECX_STANDARD','getXMLTP',transaction_type,transaction_subtype,party_id,party_site_id);
1497: g_instlmode := wf_core.translate('WF_INSTALL');
1498: IF g_instlmode = 'EMBEDDED'
1499: THEN
1500: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,
1501: ecx_utils.i_errparams));
1502: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1503: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
1504: ELSE
1498: IF g_instlmode = 'EMBEDDED'
1499: THEN
1500: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,
1501: ecx_utils.i_errparams));
1502: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1503: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
1504: ELSE
1505: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,
1506: ecx_utils.i_errparams));
1499: THEN
1500: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,
1501: ecx_utils.i_errparams));
1502: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1503: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
1504: ELSE
1505: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,
1506: ecx_utils.i_errparams));
1507: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1501: ecx_utils.i_errparams));
1502: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1503: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
1504: ELSE
1505: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,
1506: ecx_utils.i_errparams));
1507: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1508: wf_core.raise('ECX_PROGRAM_EXIT');
1509: END IF;
1503: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
1504: ELSE
1505: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,
1506: ecx_utils.i_errparams));
1507: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1508: wf_core.raise('ECX_PROGRAM_EXIT');
1509: END IF;
1510: when others then
1511: ecx_errorlog.outbound_trigger
1504: ELSE
1505: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,
1506: ecx_utils.i_errparams));
1507: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1508: wf_core.raise('ECX_PROGRAM_EXIT');
1509: END IF;
1510: when others then
1511: ecx_errorlog.outbound_trigger
1512: (
1514: p_party_id, p_party_site_id, p_party_type,
1515: document_id, ecx_utils.i_ret_code, ecx_utils.i_errbuf
1516: );
1517:
1518: Wf_Core.Context('ECX_STANDARD', 'getXMLTP', itemtype, itemkey, to_char(actid), funcmode);
1519: raise;
1520: end getXMLTP;
1521:
1522:
1601: return;
1602: end if;
1603: i_map_code := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MAP_CODE');
1604: if (i_map_code is null ) then
1605: wf_core.token('ECX_MAP_CODE','NULL');
1606: wf_core.raise('WFSQL_ARGS');
1607: end if;
1608:
1609:
1602: end if;
1603: i_map_code := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MAP_CODE');
1604: if (i_map_code is null ) then
1605: wf_core.token('ECX_MAP_CODE','NULL');
1606: wf_core.raise('WFSQL_ARGS');
1607: end if;
1608:
1609:
1610: document_id := Wf_Engine.GetActivityAttrTEXT(itemtype, itemkey, actid, 'ECX_DOCUMENT_ID');
1622: -- Verify that the attr type = EVENT
1623:
1624: evt_name := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE');
1625: if ( evt_name is null ) then
1626: wf_core.token('ECX_EVENT_MESSAGE','NULL');
1627: wf_core.raise('WFSQL_ARGS');
1628: end if;
1629:
1630: Wf_Engine.GetItemAttrInfo(itemtype, evt_name ,atype, asubtype, aformat);
1623:
1624: evt_name := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE');
1625: if ( evt_name is null ) then
1626: wf_core.token('ECX_EVENT_MESSAGE','NULL');
1627: wf_core.raise('WFSQL_ARGS');
1628: end if;
1629:
1630: Wf_Engine.GetItemAttrInfo(itemtype, evt_name ,atype, asubtype, aformat);
1631: if (atype <> 'EVENT' ) then
1628: end if;
1629:
1630: Wf_Engine.GetItemAttrInfo(itemtype, evt_name ,atype, asubtype, aformat);
1631: if (atype <> 'EVENT' ) then
1632: wf_core.token('VTYPE',atype);
1633: wf_core.raise('WFXXXV_VTYPE');
1634: end if;
1635:
1636: i_event := Wf_Engine.GetItemAttrEvent(itemtype, itemkey, evt_name);
1629:
1630: Wf_Engine.GetItemAttrInfo(itemtype, evt_name ,atype, asubtype, aformat);
1631: if (atype <> 'EVENT' ) then
1632: wf_core.token('VTYPE',atype);
1633: wf_core.raise('WFXXXV_VTYPE');
1634: end if;
1635:
1636: i_event := Wf_Engine.GetItemAttrEvent(itemtype, itemkey, evt_name);
1637:
1693: resultout := 'COMPLETE:';
1694:
1695: exception
1696: when others then
1697: Wf_Core.Context('ECX_STANDARD', 'getXML', itemtype, itemkey, to_char(actid), funcmode);
1698: raise;
1699: end getXML;
1700:
1701:
1758: result := 'COMPLETE:';
1759: return;
1760: elsif retcode = 1
1761: then
1762: g_instlmode := wf_core.translate('WF_INSTALL');
1763: IF g_instlmode = 'EMBEDDED'
1764: THEN
1765: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1766: ecx_utils.i_errparams));
1761: then
1762: g_instlmode := wf_core.translate('WF_INSTALL');
1763: IF g_instlmode = 'EMBEDDED'
1764: THEN
1765: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1766: ecx_utils.i_errparams));
1767: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1768: wf_core.raise('ECX_REPROCESS_INBOUND_EMBD');
1769: ELSE
1763: IF g_instlmode = 'EMBEDDED'
1764: THEN
1765: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1766: ecx_utils.i_errparams));
1767: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1768: wf_core.raise('ECX_REPROCESS_INBOUND_EMBD');
1769: ELSE
1770: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1771: ecx_utils.i_errparams));
1764: THEN
1765: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1766: ecx_utils.i_errparams));
1767: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1768: wf_core.raise('ECX_REPROCESS_INBOUND_EMBD');
1769: ELSE
1770: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1771: ecx_utils.i_errparams));
1772: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1766: ecx_utils.i_errparams));
1767: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1768: wf_core.raise('ECX_REPROCESS_INBOUND_EMBD');
1769: ELSE
1770: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1771: ecx_utils.i_errparams));
1772: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1773: wf_core.raise('ECX_REPROCESS_INBOUND');
1774: END IF;
1768: wf_core.raise('ECX_REPROCESS_INBOUND_EMBD');
1769: ELSE
1770: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1771: ecx_utils.i_errparams));
1772: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1773: wf_core.raise('ECX_REPROCESS_INBOUND');
1774: END IF;
1775:
1776: else
1769: ELSE
1770: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1771: ecx_utils.i_errparams));
1772: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1773: wf_core.raise('ECX_REPROCESS_INBOUND');
1774: END IF;
1775:
1776: else
1777: g_instlmode := wf_core.translate('WF_INSTALL');
1773: wf_core.raise('ECX_REPROCESS_INBOUND');
1774: END IF;
1775:
1776: else
1777: g_instlmode := wf_core.translate('WF_INSTALL');
1778: IF g_instlmode = 'EMBEDDED'
1779: THEN
1780: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1781: ecx_utils.i_errparams));
1776: else
1777: g_instlmode := wf_core.translate('WF_INSTALL');
1778: IF g_instlmode = 'EMBEDDED'
1779: THEN
1780: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1781: ecx_utils.i_errparams));
1782: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1783: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
1784: ELSE
1778: IF g_instlmode = 'EMBEDDED'
1779: THEN
1780: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1781: ecx_utils.i_errparams));
1782: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1783: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
1784: ELSE
1785: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1786: ecx_utils.i_errparams));
1779: THEN
1780: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1781: ecx_utils.i_errparams));
1782: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1783: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
1784: ELSE
1785: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1786: ecx_utils.i_errparams));
1787: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1781: ecx_utils.i_errparams));
1782: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1783: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
1784: ELSE
1785: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1786: ecx_utils.i_errparams));
1787: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1788: wf_core.raise('ECX_PROGRAM_EXIT');
1789: END IF;
1783: wf_core.raise('ECX_PROGRAM_EXIT_EMBD');
1784: ELSE
1785: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1786: ecx_utils.i_errparams));
1787: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1788: wf_core.raise('ECX_PROGRAM_EXIT');
1789: END IF;
1790: end if;
1791:
1784: ELSE
1785: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1786: ecx_utils.i_errparams));
1787: wf_core.token('ECX_LOGFILE',ecx_utils.g_logfile);
1788: wf_core.raise('ECX_PROGRAM_EXIT');
1789: END IF;
1790: end if;
1791:
1792: result := 'COMPLETE:';
1821: return;
1822:
1823: exception
1824: when others then
1825: wf_core.context('ECX_STANDARD', 'Reprocess_Inbound',itemtype, itemkey, to_char(actid),funcmode,retcode, errmsg);
1826: raise;
1827: end Reprocess_Inbound;
1828:
1829: procedure resend
1866: result := 'COMPLETE:';
1867: return;
1868: elsif retcode = 1
1869: then
1870: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1871: ecx_utils.i_errparams));
1872: wf_core.raise('ECX_RESEND_WARNING');
1873: else
1874: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1868: elsif retcode = 1
1869: then
1870: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1871: ecx_utils.i_errparams));
1872: wf_core.raise('ECX_RESEND_WARNING');
1873: else
1874: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1875: ecx_utils.i_errparams));
1876: wf_core.raise('ECX_RESEND_ERROR');
1870: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1871: ecx_utils.i_errparams));
1872: wf_core.raise('ECX_RESEND_WARNING');
1873: else
1874: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1875: ecx_utils.i_errparams));
1876: wf_core.raise('ECX_RESEND_ERROR');
1877: end if;
1878:
1872: wf_core.raise('ECX_RESEND_WARNING');
1873: else
1874: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(errmsg,
1875: ecx_utils.i_errparams));
1876: wf_core.raise('ECX_RESEND_ERROR');
1877: end if;
1878:
1879: result := 'COMPLETE:';
1880: return;
1908: return;
1909:
1910: exception
1911: when others then
1912: wf_core.context('ECX_STANDARD', 'ReSend',itemtype, itemkey, to_char(actid),funcmode,retcode, ecx_debug.getMessage(errmsg,ecx_utils.i_errparams));
1913: raise;
1914: end resend;
1915:
1916: -- getEventDetails (PUBLIC)