45: when others then
46: ecx_debug.setErrorInfo(2, 30,
47: SQLERRM||' - ECX_INBOUND_TRIG.IS_ROUTING_SUPPORTED');
48: if(l_unexpectedEnabled) then
49: --ecx_debug.log(l_statement, ecx_utils.i_errbuf, i_method_name);
50: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
51: end if;
52: raise ecx_utils.program_exit;
53: end is_routing_supported;
46: ecx_debug.setErrorInfo(2, 30,
47: SQLERRM||' - ECX_INBOUND_TRIG.IS_ROUTING_SUPPORTED');
48: if(l_unexpectedEnabled) then
49: --ecx_debug.log(l_statement, ecx_utils.i_errbuf, i_method_name);
50: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
51: end if;
52: raise ecx_utils.program_exit;
53: end is_routing_supported;
54:
48: if(l_unexpectedEnabled) then
49: --ecx_debug.log(l_statement, ecx_utils.i_errbuf, i_method_name);
50: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
51: end if;
52: raise ecx_utils.program_exit;
53: end is_routing_supported;
54:
55:
56: procedure get_element_value
100: when others then
101: ecx_debug.setErrorInfo(2,30,
102: SQLERRM ||' - ECX_INBOUND_TRIG.GET_ELEMENT_VALUE');
103: if(l_unexpectedEnabled) then
104: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
105: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
106: end if;
107: raise ecx_utils.program_exit;
108: end get_element_value;
101: ecx_debug.setErrorInfo(2,30,
102: SQLERRM ||' - ECX_INBOUND_TRIG.GET_ELEMENT_VALUE');
103: if(l_unexpectedEnabled) then
104: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
105: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
106: end if;
107: raise ecx_utils.program_exit;
108: end get_element_value;
109:
103: if(l_unexpectedEnabled) then
104: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
105: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
106: end if;
107: raise ecx_utils.program_exit;
108: end get_element_value;
109:
110: procedure getAttributes
111: (
173: end loop;
174:
175: /** remove the last , and put the statement for the where clause **/
176: i_string := substr(i_string,1,length(i_string)-1);
177: i_string := i_string || ' where msgid = '||i_single||ecx_utils.g_msgid||i_single;
178:
179: if i_attr_rec.count > 0
180: then
181: if(l_statementEnabled) then
189: exception
190: when others then
191: ecx_debug.setErrorInfo(2,30,SQLERRM ||' - ECX_INBOUND_TRIG.getAttributes');
192: if(l_unexpectedEnabled) then
193: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
194: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
195: end if;
196: raise ecx_utils.program_exit;
197: end getAttributes;
190: when others then
191: ecx_debug.setErrorInfo(2,30,SQLERRM ||' - ECX_INBOUND_TRIG.getAttributes');
192: if(l_unexpectedEnabled) then
193: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
194: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
195: end if;
196: raise ecx_utils.program_exit;
197: end getAttributes;
198:
192: if(l_unexpectedEnabled) then
193: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
194: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
195: end if;
196: raise ecx_utils.program_exit;
197: end getAttributes;
198:
199: /**
200: For BES - removed send_error
210: begin
211: if (l_procedureEnabled) then
212: ecx_debug.push(i_method_name);
213: end if;
214: xmlparser.parseCLOB(ecx_utils.g_parser,i_payload);
215: if (l_procedureEnabled) then
216: ecx_debug.pop(i_method_name);
217: end if;
218: exception
219: -- Put All DOM Parser Exceptions Here.
220: when xmlDOM.INDEX_SIZE_ERR then
221: ecx_debug.setErrorInfo(1,20,SQLERRM);
222: if(l_unexpectedEnabled) then
223: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
224: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
225: end if;
226: if (l_procedureEnabled) then
227: ecx_debug.pop(i_method_name);
220: when xmlDOM.INDEX_SIZE_ERR then
221: ecx_debug.setErrorInfo(1,20,SQLERRM);
222: if(l_unexpectedEnabled) then
223: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
224: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
225: end if;
226: if (l_procedureEnabled) then
227: ecx_debug.pop(i_method_name);
228: end if;
225: end if;
226: if (l_procedureEnabled) then
227: ecx_debug.pop(i_method_name);
228: end if;
229: raise ecx_utils.program_exit;
230: when xmlDOM.DOMSTRING_SIZE_ERR then
231: ecx_debug.setErrorInfo(1,20,SQLERRM);
232: if(l_unexpectedEnabled) then
233: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
229: raise ecx_utils.program_exit;
230: when xmlDOM.DOMSTRING_SIZE_ERR then
231: ecx_debug.setErrorInfo(1,20,SQLERRM);
232: if(l_unexpectedEnabled) then
233: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
234: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
235: end if;
236: if (l_procedureEnabled) then
237: ecx_debug.pop(i_method_name);
230: when xmlDOM.DOMSTRING_SIZE_ERR then
231: ecx_debug.setErrorInfo(1,20,SQLERRM);
232: if(l_unexpectedEnabled) then
233: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
234: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
235: end if;
236: if (l_procedureEnabled) then
237: ecx_debug.pop(i_method_name);
238: end if;
235: end if;
236: if (l_procedureEnabled) then
237: ecx_debug.pop(i_method_name);
238: end if;
239: raise ecx_utils.program_exit;
240: when xmlDOM.HIERARCHY_REQUEST_ERR then
241: ecx_debug.setErrorInfo(1,20,SQLERRM);
242: if(l_unexpectedEnabled) then
243: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
239: raise ecx_utils.program_exit;
240: when xmlDOM.HIERARCHY_REQUEST_ERR then
241: ecx_debug.setErrorInfo(1,20,SQLERRM);
242: if(l_unexpectedEnabled) then
243: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
244: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
245: end if;
246: if (l_procedureEnabled) then
247: ecx_debug.pop(i_method_name);
240: when xmlDOM.HIERARCHY_REQUEST_ERR then
241: ecx_debug.setErrorInfo(1,20,SQLERRM);
242: if(l_unexpectedEnabled) then
243: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
244: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
245: end if;
246: if (l_procedureEnabled) then
247: ecx_debug.pop(i_method_name);
248: end if;
245: end if;
246: if (l_procedureEnabled) then
247: ecx_debug.pop(i_method_name);
248: end if;
249: raise ecx_utils.program_exit;
250: when xmlDOM.WRONG_DOCUMENT_ERR then
251: ecx_debug.setErrorInfo(1,20,SQLERRM);
252: if(l_unexpectedEnabled) then
253: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
249: raise ecx_utils.program_exit;
250: when xmlDOM.WRONG_DOCUMENT_ERR then
251: ecx_debug.setErrorInfo(1,20,SQLERRM);
252: if(l_unexpectedEnabled) then
253: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
254: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
255: end if;
256: if (l_procedureEnabled) then
257: ecx_debug.pop(i_method_name);
250: when xmlDOM.WRONG_DOCUMENT_ERR then
251: ecx_debug.setErrorInfo(1,20,SQLERRM);
252: if(l_unexpectedEnabled) then
253: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
254: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
255: end if;
256: if (l_procedureEnabled) then
257: ecx_debug.pop(i_method_name);
258: end if;
255: end if;
256: if (l_procedureEnabled) then
257: ecx_debug.pop(i_method_name);
258: end if;
259: raise ecx_utils.program_exit;
260: when xmlDOM.INVALID_CHARACTER_ERR then
261: ecx_debug.setErrorInfo(1,20,SQLERRM);
262: if(l_unexpectedEnabled) then
263: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
259: raise ecx_utils.program_exit;
260: when xmlDOM.INVALID_CHARACTER_ERR then
261: ecx_debug.setErrorInfo(1,20,SQLERRM);
262: if(l_unexpectedEnabled) then
263: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
264: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
265: end if;
266: if (l_procedureEnabled) then
267: ecx_debug.pop(i_method_name);
260: when xmlDOM.INVALID_CHARACTER_ERR then
261: ecx_debug.setErrorInfo(1,20,SQLERRM);
262: if(l_unexpectedEnabled) then
263: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
264: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
265: end if;
266: if (l_procedureEnabled) then
267: ecx_debug.pop(i_method_name);
268: end if;
265: end if;
266: if (l_procedureEnabled) then
267: ecx_debug.pop(i_method_name);
268: end if;
269: raise ecx_utils.program_exit;
270: when xmlDOM.NO_DATA_ALLOWED_ERR then
271: ecx_debug.setErrorInfo(1,20,SQLERRM);
272: if(l_unexpectedEnabled) then
273: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
269: raise ecx_utils.program_exit;
270: when xmlDOM.NO_DATA_ALLOWED_ERR then
271: ecx_debug.setErrorInfo(1,20,SQLERRM);
272: if(l_unexpectedEnabled) then
273: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
274: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
275: end if;
276: if (l_procedureEnabled) then
277: ecx_debug.pop(i_method_name);
270: when xmlDOM.NO_DATA_ALLOWED_ERR then
271: ecx_debug.setErrorInfo(1,20,SQLERRM);
272: if(l_unexpectedEnabled) then
273: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
274: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
275: end if;
276: if (l_procedureEnabled) then
277: ecx_debug.pop(i_method_name);
278: end if;
275: end if;
276: if (l_procedureEnabled) then
277: ecx_debug.pop(i_method_name);
278: end if;
279: raise ecx_utils.program_exit;
280: when xmlDOM.No_MODIFICATION_ALLOWED_ERR then
281: ecx_debug.setErrorInfo(1,20,SQLERRM);
282: if(l_unexpectedEnabled) then
283: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
279: raise ecx_utils.program_exit;
280: when xmlDOM.No_MODIFICATION_ALLOWED_ERR then
281: ecx_debug.setErrorInfo(1,20,SQLERRM);
282: if(l_unexpectedEnabled) then
283: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
284: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
285: end if;
286: if (l_procedureEnabled) then
287: ecx_debug.pop(i_method_name);
280: when xmlDOM.No_MODIFICATION_ALLOWED_ERR then
281: ecx_debug.setErrorInfo(1,20,SQLERRM);
282: if(l_unexpectedEnabled) then
283: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
284: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
285: end if;
286: if (l_procedureEnabled) then
287: ecx_debug.pop(i_method_name);
288: end if;
285: end if;
286: if (l_procedureEnabled) then
287: ecx_debug.pop(i_method_name);
288: end if;
289: raise ecx_utils.program_exit;
290: when xmlDOM.NOT_FOUND_ERR then
291: ecx_debug.setErrorInfo(1,20,SQLERRM);
292: if(l_unexpectedEnabled) then
293: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
289: raise ecx_utils.program_exit;
290: when xmlDOM.NOT_FOUND_ERR then
291: ecx_debug.setErrorInfo(1,20,SQLERRM);
292: if(l_unexpectedEnabled) then
293: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
294: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
295: end if;
296: if (l_procedureEnabled) then
297: ecx_debug.pop(i_method_name);
290: when xmlDOM.NOT_FOUND_ERR then
291: ecx_debug.setErrorInfo(1,20,SQLERRM);
292: if(l_unexpectedEnabled) then
293: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
294: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
295: end if;
296: if (l_procedureEnabled) then
297: ecx_debug.pop(i_method_name);
298: end if;
295: end if;
296: if (l_procedureEnabled) then
297: ecx_debug.pop(i_method_name);
298: end if;
299: raise ecx_utils.program_exit;
300: when xmlDOM.NOT_SUPPORTED_ERR then
301: ecx_debug.setErrorInfo(1,20,SQLERRM);
302: if(l_unexpectedEnabled) then
303: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
299: raise ecx_utils.program_exit;
300: when xmlDOM.NOT_SUPPORTED_ERR then
301: ecx_debug.setErrorInfo(1,20,SQLERRM);
302: if(l_unexpectedEnabled) then
303: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
304: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
305: end if;
306: if (l_procedureEnabled) then
307: ecx_debug.pop(i_method_name);
300: when xmlDOM.NOT_SUPPORTED_ERR then
301: ecx_debug.setErrorInfo(1,20,SQLERRM);
302: if(l_unexpectedEnabled) then
303: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
304: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
305: end if;
306: if (l_procedureEnabled) then
307: ecx_debug.pop(i_method_name);
308: end if;
305: end if;
306: if (l_procedureEnabled) then
307: ecx_debug.pop(i_method_name);
308: end if;
309: raise ecx_utils.program_exit;
310: when xmlDOM.INUSE_ATTRIBUTE_ERR then
311: ecx_debug.setErrorInfo(1,20,SQLERRM);
312: if(l_unexpectedEnabled) then
313: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
309: raise ecx_utils.program_exit;
310: when xmlDOM.INUSE_ATTRIBUTE_ERR then
311: ecx_debug.setErrorInfo(1,20,SQLERRM);
312: if(l_unexpectedEnabled) then
313: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
314: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
315: end if;
316: if (l_procedureEnabled) then
317: ecx_debug.pop(i_method_name);
310: when xmlDOM.INUSE_ATTRIBUTE_ERR then
311: ecx_debug.setErrorInfo(1,20,SQLERRM);
312: if(l_unexpectedEnabled) then
313: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
314: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
315: end if;
316: if (l_procedureEnabled) then
317: ecx_debug.pop(i_method_name);
318: end if;
315: end if;
316: if (l_procedureEnabled) then
317: ecx_debug.pop(i_method_name);
318: end if;
319: raise ecx_utils.program_exit;
320: when others then
321: ecx_debug.setErrorInfo(1,20,SQLERRM||' - ECX_INBOUND_TRIG.PARSEPAYLOAD ');
322: if(l_unexpectedEnabled) then
323: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
319: raise ecx_utils.program_exit;
320: when others then
321: ecx_debug.setErrorInfo(1,20,SQLERRM||' - ECX_INBOUND_TRIG.PARSEPAYLOAD ');
322: if(l_unexpectedEnabled) then
323: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
324: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
325: end if;
326: if (l_procedureEnabled) then
327: ecx_debug.pop(i_method_name);
320: when others then
321: ecx_debug.setErrorInfo(1,20,SQLERRM||' - ECX_INBOUND_TRIG.PARSEPAYLOAD ');
322: if(l_unexpectedEnabled) then
323: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
324: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
325: end if;
326: if (l_procedureEnabled) then
327: ecx_debug.pop(i_method_name);
328: end if;
325: end if;
326: if (l_procedureEnabled) then
327: ecx_debug.pop(i_method_name);
328: end if;
329: raise ecx_utils.program_exit;
330: end parsepayload;
331:
332:
333: /**
354: ecx_debug.push(i_method_name);
355: end if;
356: dbms_lob.createtemporary(i_xmldoc, TRUE,DBMS_LOB.SESSION);
357: dbms_lob.trim(i_xmldoc, 0);
358: xmlDOM.writetoCLOB(ecx_utils.g_xmldoc,i_xmldoc);
359:
360: -- write XML to FS if debug > 0
361: if (l_statementEnabled)
362: then
372: End Loop;
373: fnd_log_attachment.close(attachment_id);
374: end if;
375: ELSE
376: xmlDOM.writetofile(ecx_utils.g_xmldoc,
377: ecx_utils.g_logdir||ecx_utils.getFileSeparator()||
378: substr(ecx_utils.g_logfile, 1,
379: length(ecx_utils.g_logfile)-4) ||'.xml');
380: END IF;
373: fnd_log_attachment.close(attachment_id);
374: end if;
375: ELSE
376: xmlDOM.writetofile(ecx_utils.g_xmldoc,
377: ecx_utils.g_logdir||ecx_utils.getFileSeparator()||
378: substr(ecx_utils.g_logfile, 1,
379: length(ecx_utils.g_logfile)-4) ||'.xml');
380: END IF;
381: end if;
374: end if;
375: ELSE
376: xmlDOM.writetofile(ecx_utils.g_xmldoc,
377: ecx_utils.g_logdir||ecx_utils.getFileSeparator()||
378: substr(ecx_utils.g_logfile, 1,
379: length(ecx_utils.g_logfile)-4) ||'.xml');
380: END IF;
381: end if;
382:
375: ELSE
376: xmlDOM.writetofile(ecx_utils.g_xmldoc,
377: ecx_utils.g_logdir||ecx_utils.getFileSeparator()||
378: substr(ecx_utils.g_logfile, 1,
379: length(ecx_utils.g_logfile)-4) ||'.xml');
380: END IF;
381: end if;
382:
383:
408: if (l_procedureEnabled) then
409: ecx_debug.push(i_method_name);
410: end if;
411: if(l_statementEnabled) then
412: ecx_debug.log(l_statement,'ecx_utils.g_map_id',ecx_utils.g_map_id,i_method_name);
413: ecx_debug.log(l_statement,'i_map_id',i_map_id,i_method_name);
414: ecx_debug.log(l_statement,'i_header_id',i_header_id,i_method_name);
415: ecx_debug.log(l_statement,'i_rcv_tp_id',i_rcv_tp_id,i_method_name);
416: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name);
415: ecx_debug.log(l_statement,'i_rcv_tp_id',i_rcv_tp_id,i_method_name);
416: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name);
417: end if;
418: -- Set the Transaction direction
419: ecx_utils.g_rec_tp_id := i_rcv_tp_id;
420: ecx_utils.g_direction := 'IN';
421: ecx_utils.initialize (i_map_id,l_same_map);
422: ecx_utils.g_source := ecx_utils.g_empty_source;
423: ecx_utils.g_target := ecx_utils.g_empty_target;
416: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name);
417: end if;
418: -- Set the Transaction direction
419: ecx_utils.g_rec_tp_id := i_rcv_tp_id;
420: ecx_utils.g_direction := 'IN';
421: ecx_utils.initialize (i_map_id,l_same_map);
422: ecx_utils.g_source := ecx_utils.g_empty_source;
423: ecx_utils.g_target := ecx_utils.g_empty_target;
424:
417: end if;
418: -- Set the Transaction direction
419: ecx_utils.g_rec_tp_id := i_rcv_tp_id;
420: ecx_utils.g_direction := 'IN';
421: ecx_utils.initialize (i_map_id,l_same_map);
422: ecx_utils.g_source := ecx_utils.g_empty_source;
423: ecx_utils.g_target := ecx_utils.g_empty_target;
424:
425: if (not ecx_utils.dom_printing) then
418: -- Set the Transaction direction
419: ecx_utils.g_rec_tp_id := i_rcv_tp_id;
420: ecx_utils.g_direction := 'IN';
421: ecx_utils.initialize (i_map_id,l_same_map);
422: ecx_utils.g_source := ecx_utils.g_empty_source;
423: ecx_utils.g_target := ecx_utils.g_empty_target;
424:
425: if (not ecx_utils.dom_printing) then
426: ecx_inbound_new.process_xml_doc (i_payload, i_map_id, i_xmldoc, l_parseXML);
419: ecx_utils.g_rec_tp_id := i_rcv_tp_id;
420: ecx_utils.g_direction := 'IN';
421: ecx_utils.initialize (i_map_id,l_same_map);
422: ecx_utils.g_source := ecx_utils.g_empty_source;
423: ecx_utils.g_target := ecx_utils.g_empty_target;
424:
425: if (not ecx_utils.dom_printing) then
426: ecx_inbound_new.process_xml_doc (i_payload, i_map_id, i_xmldoc, l_parseXML);
427: else
421: ecx_utils.initialize (i_map_id,l_same_map);
422: ecx_utils.g_source := ecx_utils.g_empty_source;
423: ecx_utils.g_target := ecx_utils.g_empty_target;
424:
425: if (not ecx_utils.dom_printing) then
426: ecx_inbound_new.process_xml_doc (i_payload, i_map_id, i_xmldoc, l_parseXML);
427: else
428: /** Parse the Payload and handle any errors **/
429: begin
429: begin
430: parsepayload(i_payload);
431: exception
432: when others then
433: raise ecx_utils.program_exit;
434: end;
435:
436: i_doc := xmlparser.getDocument(ecx_utils.g_parser);
437:
432: when others then
433: raise ecx_utils.program_exit;
434: end;
435:
436: i_doc := xmlparser.getDocument(ecx_utils.g_parser);
437:
438: /** Assign it to the Global XML Document **/
439: ecx_utils.g_xmldoc := xmlDOM.makeNode(i_doc);
440:
435:
436: i_doc := xmlparser.getDocument(ecx_utils.g_parser);
437:
438: /** Assign it to the Global XML Document **/
439: ecx_utils.g_xmldoc := xmlDOM.makeNode(i_doc);
440:
441: /** Get all the attributes in a generic way for a given standard and save in ecx_doclogs**/
442: getAttributes (
443: i_message_standard,
449: i_xmldoc, l_parseXML);
450: end if;
451:
452: /* bug 8718549 , commented free parser code as it was done twice in this procedure
453: xmlparser.freeparser(ecx_utils.g_parser);
454: if(ecx_utils.dom_printing = false and ecx_utils.structure_printing = true) -- xmltoxml different dtds.
455: then
456: xmlparser.freeparser(ecx_utils.g_inb_parser);
457: end if; */
450: end if;
451:
452: /* bug 8718549 , commented free parser code as it was done twice in this procedure
453: xmlparser.freeparser(ecx_utils.g_parser);
454: if(ecx_utils.dom_printing = false and ecx_utils.structure_printing = true) -- xmltoxml different dtds.
455: then
456: xmlparser.freeparser(ecx_utils.g_inb_parser);
457: end if; */
458:
452: /* bug 8718549 , commented free parser code as it was done twice in this procedure
453: xmlparser.freeparser(ecx_utils.g_parser);
454: if(ecx_utils.dom_printing = false and ecx_utils.structure_printing = true) -- xmltoxml different dtds.
455: then
456: xmlparser.freeparser(ecx_utils.g_inb_parser);
457: end if; */
458:
459: if (ecx_utils.dom_printing or (ecx_utils.structure_printing and l_parseXML)) then
460: if(l_statementEnabled) then
455: then
456: xmlparser.freeparser(ecx_utils.g_inb_parser);
457: end if; */
458:
459: if (ecx_utils.dom_printing or (ecx_utils.structure_printing and l_parseXML)) then
460: if(l_statementEnabled) then
461: ecx_debug.log(l_statement,'XML is validated by the parser.',i_method_name);
462: end if;
463: writeXMLToFile(i_xmldoc);
462: end if;
463: writeXMLToFile(i_xmldoc);
464:
465: begin
466: if not xmlDOM.isNull(ecx_utils.g_xmldoc) then
467: xmlDOM.freeDocument(xmlDOM.makeDocument(ecx_utils.g_xmldoc));
468: end if;
469: exception
470: when others then
463: writeXMLToFile(i_xmldoc);
464:
465: begin
466: if not xmlDOM.isNull(ecx_utils.g_xmldoc) then
467: xmlDOM.freeDocument(xmlDOM.makeDocument(ecx_utils.g_xmldoc));
468: end if;
469: exception
470: when others then
471: null;
475: ecx_debug.log(l_statement,'XML is not validated by the parser.',i_method_name);
476: end if;
477: end if;
478: --for bug 5609625
479: xmlparser.freeparser(ecx_utils.g_parser);
480: if(ecx_utils.dom_printing = false and ecx_utils.structure_printing = true) -- xmltoxml different dtds.
481: then
482: xmlparser.freeparser(ecx_utils.g_inb_parser);
483: end if;
476: end if;
477: end if;
478: --for bug 5609625
479: xmlparser.freeparser(ecx_utils.g_parser);
480: if(ecx_utils.dom_printing = false and ecx_utils.structure_printing = true) -- xmltoxml different dtds.
481: then
482: xmlparser.freeparser(ecx_utils.g_inb_parser);
483: end if;
484: ---end of 5609625
478: --for bug 5609625
479: xmlparser.freeparser(ecx_utils.g_parser);
480: if(ecx_utils.dom_printing = false and ecx_utils.structure_printing = true) -- xmltoxml different dtds.
481: then
482: xmlparser.freeparser(ecx_utils.g_inb_parser);
483: end if;
484: ---end of 5609625
485:
486: if (l_procedureEnabled) then
487: ecx_debug.pop(i_method_name);
488: end if;
489:
490: exception
491: when ecx_utils.program_exit then
492: if (l_procedureEnabled) then
493: ecx_debug.pop(i_method_name);
494: end if;
495: if(l_unexpectedEnabled) then
497: end if;
498: ecx_print_local.last_printed := -1;
499:
500: begin
501: if not xmlDOM.isNull(ecx_utils.g_xmldoc) then
502: xmlDOM.freeDocument(xmlDOM.makeDocument(ecx_utils.g_xmldoc));
503: end if;
504: exception
505: when others then
498: ecx_print_local.last_printed := -1;
499:
500: begin
501: if not xmlDOM.isNull(ecx_utils.g_xmldoc) then
502: xmlDOM.freeDocument(xmlDOM.makeDocument(ecx_utils.g_xmldoc));
503: end if;
504: exception
505: when others then
506: null;
504: exception
505: when others then
506: null;
507: end;
508: raise ecx_utils.program_exit;
509:
510: when others then
511: ecx_debug.setErrorInfo(1,20,SQLERRM||' - ECX_INBOUND_TRIG.processXMLData ');
512: if(l_unexpectedEnabled) then
509:
510: when others then
511: ecx_debug.setErrorInfo(1,20,SQLERRM||' - ECX_INBOUND_TRIG.processXMLData ');
512: if(l_unexpectedEnabled) then
513: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
514: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
515: ecx_debug.log(l_unexpected,'Clean-up last_printed',i_method_name);
516: end if;
517: ecx_print_local.last_printed := -1;
510: when others then
511: ecx_debug.setErrorInfo(1,20,SQLERRM||' - ECX_INBOUND_TRIG.processXMLData ');
512: if(l_unexpectedEnabled) then
513: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
514: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
515: ecx_debug.log(l_unexpected,'Clean-up last_printed',i_method_name);
516: end if;
517: ecx_print_local.last_printed := -1;
518: if (l_procedureEnabled) then
519: ecx_debug.pop(i_method_name);
520: end if;
521:
522: begin
523: if not xmlDOM.isNull(ecx_utils.g_xmldoc) then
524: xmlDOM.freeDocument(xmlDOM.makeDocument(ecx_utils.g_xmldoc));
525: end if;
526: exception
527: when others then
520: end if;
521:
522: begin
523: if not xmlDOM.isNull(ecx_utils.g_xmldoc) then
524: xmlDOM.freeDocument(xmlDOM.makeDocument(ecx_utils.g_xmldoc));
525: end if;
526: exception
527: when others then
528: null;
526: exception
527: when others then
528: null;
529: end;
530: raise ecx_utils.program_exit;
531: end processXMLData;
532:
533: procedure validate_message
534: (
636: ecx_debug.log(l_statement,'m_party_ext_code',m_party_ext_code,i_method_name);
637: ecx_debug.log(l_statement,'m_document_number',m_document_number,i_method_name);
638: ecx_debug.log(l_statement,'m_routing_ext_code',m_routing_ext_code,i_method_name);
639: end if;
640: ecx_utils.i_ret_code :=0;
641: ecx_utils.i_errbuf :=null;
642: --MLS
643: ecx_utils.i_errparams := null;
644: ecx_utils.g_ret_code := 0;
637: ecx_debug.log(l_statement,'m_document_number',m_document_number,i_method_name);
638: ecx_debug.log(l_statement,'m_routing_ext_code',m_routing_ext_code,i_method_name);
639: end if;
640: ecx_utils.i_ret_code :=0;
641: ecx_utils.i_errbuf :=null;
642: --MLS
643: ecx_utils.i_errparams := null;
644: ecx_utils.g_ret_code := 0;
645:
639: end if;
640: ecx_utils.i_ret_code :=0;
641: ecx_utils.i_errbuf :=null;
642: --MLS
643: ecx_utils.i_errparams := null;
644: ecx_utils.g_ret_code := 0;
645:
646: --Check whether the Document has been enabled in the Exchange Server.
647: --If yes get the Map Id.
640: ecx_utils.i_ret_code :=0;
641: ecx_utils.i_errbuf :=null;
642: --MLS
643: ecx_utils.i_errparams := null;
644: ecx_utils.g_ret_code := 0;
645:
646: --Check whether the Document has been enabled in the Exchange Server.
647: --If yes get the Map Id.
648: open c_tp_details ( m_ext_type, m_ext_subtype,m_party_ext_code,m_message_standard, m_message_type);
673: m_party_ext_code);
674: end if;
675:
676: close c_tp_details;
677: raise ecx_utils.program_exit;
678: end if;
679:
680: close c_tp_details;
681: -- Set the Sender's tp_id
678: end if;
679:
680: close c_tp_details;
681: -- Set the Sender's tp_id
682: ecx_utils.g_snd_tp_id := i_header_id;
683: if(l_statementEnabled) then
684: ecx_debug.log(l_statement,'i_map_id',i_map_id,i_method_name);
685: ecx_debug.log(l_statement,'i_routing_id',i_routing_id,i_method_name);
686: ecx_debug.log(l_statement,'i_header_id',i_header_id,i_method_name);
688: end if;
689:
690: if (i_routing_id is not null or m_routing_ext_code is not null) then if not (is_routing_supported(i_map_id)) then
691: ecx_debug.setErrorInfo(2, 25, 'ECX_ROUTING_NOT_SUPPORTED');
692: raise ecx_utils.program_exit;
693: end if;
694: end if;
695:
696: --Call the Send and Receive TP Id api's over here
732: m_party_ext_code);
733: end if;
734:
735: close get_routing_for_extcode;
736: raise ecx_utils.program_exit;
737: end if;
738:
739: close get_routing_for_extcode;
740:
766: end if;
767:
768:
769: close get_receiver_tp_id;
770: raise ecx_utils.program_exit;
771: end if;
772: close get_receiver_tp_id;
773: if(l_statementEnabled) then
774: ecx_debug.log(l_statement,'Static Routing',i_method_name);
774: ecx_debug.log(l_statement,'Static Routing',i_method_name);
775: end if;
776:
777: end if;
778: ecx_utils.g_rec_tp_id := i_rcv_tp_id;
779: if(l_statementEnabled) then
780: ecx_debug.log(l_statement,'Receiver Tp Id ',i_rcv_tp_id,i_method_name);
781: end if;
782:
815: m_party_ext_code);
816: end if;
817:
818: close get_routing_for_extcode;
819: raise ecx_utils.program_exit;
820: end if;
821: close get_routing_for_extcode;
822: else
823: -- if neither static nor dynamic routing is specified.
827: i_no_routing := 'Y';
828: if (i_map_type = 2) then
829: -- Only if map is xml to xml or dtd to dtd type
830: -- Give warning message.
831: ecx_utils.g_ret_code := 1;
832: if(l_statementEnabled) then
833: ecx_debug.log(l_statement,'ecx_utils.g_ret_code',' 1',i_method_name);
834: end if;
835: end if;
829: -- Only if map is xml to xml or dtd to dtd type
830: -- Give warning message.
831: ecx_utils.g_ret_code := 1;
832: if(l_statementEnabled) then
833: ecx_debug.log(l_statement,'ecx_utils.g_ret_code',' 1',i_method_name);
834: end if;
835: end if;
836: end if;
837: end if;
837: end if;
838:
839: -- need to set the g_routing_id here, so that it would set it
840: -- for both dynamic and static routing.
841: ecx_utils.g_routing_id := i_routing_id;
842: if(l_statementEnabled) then
843: ecx_debug.log(l_statement,'ecx_utils.g_routing_id',ecx_utils.g_routing_id,
844: i_method_name);
845: end if;
839: -- need to set the g_routing_id here, so that it would set it
840: -- for both dynamic and static routing.
841: ecx_utils.g_routing_id := i_routing_id;
842: if(l_statementEnabled) then
843: ecx_debug.log(l_statement,'ecx_utils.g_routing_id',ecx_utils.g_routing_id,
844: i_method_name);
845: end if;
846:
847: /**
846:
847: /**
848: Since we have the sender tp_id , we can call the senders_tp_info and populate the org_id
849: **/
850: if ( ecx_utils.g_snd_tp_id is not null )
851: then
852: null;
853: ecx_trading_partner_pvt.get_tp_info
854: (
851: then
852: null;
853: ecx_trading_partner_pvt.get_tp_info
854: (
855: ecx_utils.g_snd_tp_id,
856: p_party_id,
857: p_party_site_id,
858: ecx_utils.g_org_id,
859: p_admin_email,
854: (
855: ecx_utils.g_snd_tp_id,
856: p_party_id,
857: p_party_site_id,
858: ecx_utils.g_org_id,
859: p_admin_email,
860: retcode,
861: retmsg
862: );
917: (
918: m_msgid,
919: null,
920: 'Inbound processing complete.',
921: ecx_utils.g_logfile,
922: null
923: );
924: end if;
925:
931: if (l_procedureEnabled) then
932: ecx_debug.pop(i_method_name);
933: end if;
934: exception
935: when ecx_utils.program_exit then
936: --ecx_utils.g_map_id := -1;
937: if (l_procedureEnabled) then
938: ecx_debug.pop(i_method_name);
939: end if;
932: ecx_debug.pop(i_method_name);
933: end if;
934: exception
935: when ecx_utils.program_exit then
936: --ecx_utils.g_map_id := -1;
937: if (l_procedureEnabled) then
938: ecx_debug.pop(i_method_name);
939: end if;
940:
941: if o_payload is not null
942: then
943: dbms_lob.freetemporary (o_payload);
944: end if;
945: raise ecx_utils.program_exit;
946: when others then
947: --ecx_utils.g_map_id := -1;
948: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_INBOUND_TRIG.VALIDATE_MESSAGE ');
949: if(l_unexpectedEnabled) then
943: dbms_lob.freetemporary (o_payload);
944: end if;
945: raise ecx_utils.program_exit;
946: when others then
947: --ecx_utils.g_map_id := -1;
948: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_INBOUND_TRIG.VALIDATE_MESSAGE ');
949: if(l_unexpectedEnabled) then
950: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
951: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
946: when others then
947: --ecx_utils.g_map_id := -1;
948: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_INBOUND_TRIG.VALIDATE_MESSAGE ');
949: if(l_unexpectedEnabled) then
950: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
951: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
952: end if;
953:
954: if o_payload is not null
947: --ecx_utils.g_map_id := -1;
948: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_INBOUND_TRIG.VALIDATE_MESSAGE ');
949: if(l_unexpectedEnabled) then
950: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
951: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
952: end if;
953:
954: if o_payload is not null
955: then
957: end if;
958: if (l_procedureEnabled) then
959: ecx_debug.pop(i_method_name);
960: end if;
961: raise ecx_utils.program_exit;
962: end validate_message;
963:
964:
965: procedure getmsg_from_queue
1050: elsif (l_retcode >= 2 ) then
1051: if(l_unexpectedEnabled) then
1052: ecx_debug.log(l_unexpected,l_retmsg,i_method_name);
1053: end if;
1054: raise ecx_utils.program_exit;
1055: end if;
1056: end;
1057: if(l_statementEnabled) then
1058: ecx_debug.log(l_statement,'MessageId', i_msgid,i_method_name);
1065: if (l_procedureEnabled) then
1066: ecx_debug.pop(i_method_name);
1067: end if;
1068: exception
1069: when ecx_utils.program_exit then
1070: raise;
1071: when others then
1072: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_INBOUND_TRIG.GETMSG_FROM_QUEUE');
1073: if(l_unexpectedEnabled) then
1070: raise;
1071: when others then
1072: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_INBOUND_TRIG.GETMSG_FROM_QUEUE');
1073: if(l_unexpectedEnabled) then
1074: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
1075: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1076: end if;
1077: raise ecx_utils.program_exit;
1078: end getmsg_from_queue;
1071: when others then
1072: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_INBOUND_TRIG.GETMSG_FROM_QUEUE');
1073: if(l_unexpectedEnabled) then
1074: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
1075: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1076: end if;
1077: raise ecx_utils.program_exit;
1078: end getmsg_from_queue;
1079:
1073: if(l_unexpectedEnabled) then
1074: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
1075: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1076: end if;
1077: raise ecx_utils.program_exit;
1078: end getmsg_from_queue;
1079:
1080:
1081: procedure put_on_outbound
1169: and etd.tp_header_id = eth.tp_header_id;
1170: exception
1171: when others then
1172: ecx_debug.setErrorInfo(1,25,'ECX_NO_UNIQUE_TP_SETUP');
1173: raise ecx_utils.program_exit;
1174: end;
1175:
1176: if i_hub_user_id is not null
1177: then
1192: and ehu.hub_user_id = i_hub_user_id;
1193: exception
1194: when others then
1195: ecx_debug.setErrorInfo(1,25,'ECX_DELIVERY_HUB_NOT_SETUP');
1196: raise ecx_utils.program_exit;
1197: end;
1198: end if;
1199:
1200: if i_destination_address is null
1204: 'p_transaction_type', i_ext_type,
1205: 'p_transaction_subtype', i_ext_subtype,
1206: 'p_standard', i_standard_code);
1207:
1208: raise ecx_utils.program_exit;
1209: end if;
1210: if (l_statementEnabled) then
1211: ecx_debug.log(l_statement,'i_standard_type',i_standard_type,i_method_name);
1212: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
1240: i_event.addParameterToList('PROTOCOL_TYPE', i_destination_type);
1241: i_event.addParameterToList('PROTOCOL_ADDRESS', i_destination_address);
1242: i_event.addParameterToList('USERNAME', i_username);
1243: i_event.addParameterToList('PASSWORD', i_password);
1244: i_event.addParameterToList('ATTRIBUTE1', ecx_utils.g_company_name);
1245: i_event.addParameterToList('ATTRIBUTE2', null);
1246: i_event.addParameterToList('ATTRIBUTE3', i_destination_code);
1247: i_event.addParameterToList('ATTRIBUTE4', null);
1248: i_event.addParameterToList('ATTRIBUTE5', null);
1245: i_event.addParameterToList('ATTRIBUTE2', null);
1246: i_event.addParameterToList('ATTRIBUTE3', i_destination_code);
1247: i_event.addParameterToList('ATTRIBUTE4', null);
1248: i_event.addParameterToList('ATTRIBUTE5', null);
1249: i_event.addParameterToList('DIRECTION', ecx_utils.g_direction);
1250: i_event.addParameterToList('LOGFILE', ecx_utils.g_logfile);
1251: i_event.addParameterToList('ECX_MSG_ID', i_msgid);
1252:
1253: i_event.event_data := i_xmldoc;
1246: i_event.addParameterToList('ATTRIBUTE3', i_destination_code);
1247: i_event.addParameterToList('ATTRIBUTE4', null);
1248: i_event.addParameterToList('ATTRIBUTE5', null);
1249: i_event.addParameterToList('DIRECTION', ecx_utils.g_direction);
1250: i_event.addParameterToList('LOGFILE', ecx_utils.g_logfile);
1251: i_event.addParameterToList('ECX_MSG_ID', i_msgid);
1252:
1253: i_event.event_data := i_xmldoc;
1254:
1274: -- check the retcode and retmsg. This should be populated here only
1275: -- in the case of dup val index when inserting in doclogs (since no
1276: -- exception is raised in this case)
1277: if (ecx_out_wf_qh.retmsg is not null) then
1278: --ecx_utils.error_type := 30;
1279: --ecx_utils.i_ret_code := ecx_out_wf_qh.retcode;
1280: --ecx_utils.i_errbuf := ecx_out_wf_qh.retmsg;
1281: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);
1282: if(l_statementEnabled) then
1275: -- in the case of dup val index when inserting in doclogs (since no
1276: -- exception is raised in this case)
1277: if (ecx_out_wf_qh.retmsg is not null) then
1278: --ecx_utils.error_type := 30;
1279: --ecx_utils.i_ret_code := ecx_out_wf_qh.retcode;
1280: --ecx_utils.i_errbuf := ecx_out_wf_qh.retmsg;
1281: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);
1282: if(l_statementEnabled) then
1283: ecx_debug.log(l_statement,ecx_debug.getMessage(ecx_utils.i_errbuf,
1276: -- exception is raised in this case)
1277: if (ecx_out_wf_qh.retmsg is not null) then
1278: --ecx_utils.error_type := 30;
1279: --ecx_utils.i_ret_code := ecx_out_wf_qh.retcode;
1280: --ecx_utils.i_errbuf := ecx_out_wf_qh.retmsg;
1281: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);
1282: if(l_statementEnabled) then
1283: ecx_debug.log(l_statement,ecx_debug.getMessage(ecx_utils.i_errbuf,
1284: ecx_utils.i_errparams),i_method_name); -- MLS
1279: --ecx_utils.i_ret_code := ecx_out_wf_qh.retcode;
1280: --ecx_utils.i_errbuf := ecx_out_wf_qh.retmsg;
1281: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);
1282: if(l_statementEnabled) then
1283: ecx_debug.log(l_statement,ecx_debug.getMessage(ecx_utils.i_errbuf,
1284: ecx_utils.i_errparams),i_method_name); -- MLS
1285: end if;
1286: end if;
1287:
1280: --ecx_utils.i_errbuf := ecx_out_wf_qh.retmsg;
1281: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);
1282: if(l_statementEnabled) then
1283: ecx_debug.log(l_statement,ecx_debug.getMessage(ecx_utils.i_errbuf,
1284: ecx_utils.i_errparams),i_method_name); -- MLS
1285: end if;
1286: end if;
1287:
1288: if(l_statementEnabled) then
1291: if (l_procedureEnabled) then
1292: ecx_debug.pop(i_method_name);
1293: end if;
1294: exception
1295: WHEN ECX_UTILS.PROGRAM_EXIT THEN
1296: --dbms_lob.freetemporary(i_xmldoc);
1297: if (l_procedureEnabled) then
1298: ecx_debug.pop(i_method_name);
1299: end if;
1296: --dbms_lob.freetemporary(i_xmldoc);
1297: if (l_procedureEnabled) then
1298: ecx_debug.pop(i_method_name);
1299: end if;
1300: raise ecx_utils.program_exit;
1301: when others then
1302: --dbms_lob.freetemporary(i_xmldoc);
1303: if (ecx_out_wf_qh.retmsg is null AND ecx_out_wf_qh.retcode = 0)
1304: then
1303: if (ecx_out_wf_qh.retmsg is null AND ecx_out_wf_qh.retcode = 0)
1304: then
1305: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.PUT_ON_OUTBOUND');
1306: else
1307: --ecx_utils.i_ret_code := ecx_out_wf_qh.retcode;
1308: --ecx_utils.i_errbuf := ecx_out_wf_qh.retmsg;
1309: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);
1310: end if;
1311: --ecx_utils.error_type := 30;
1304: then
1305: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.PUT_ON_OUTBOUND');
1306: else
1307: --ecx_utils.i_ret_code := ecx_out_wf_qh.retcode;
1308: --ecx_utils.i_errbuf := ecx_out_wf_qh.retmsg;
1309: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);
1310: end if;
1311: --ecx_utils.error_type := 30;
1312: if(l_unexpectedEnabled) then
1307: --ecx_utils.i_ret_code := ecx_out_wf_qh.retcode;
1308: --ecx_utils.i_errbuf := ecx_out_wf_qh.retmsg;
1309: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);
1310: end if;
1311: --ecx_utils.error_type := 30;
1312: if(l_unexpectedEnabled) then
1313: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,
1314: ecx_utils.i_errparams),i_method_name); -- MLS
1315: end if;
1309: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);
1310: end if;
1311: --ecx_utils.error_type := 30;
1312: if(l_unexpectedEnabled) then
1313: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,
1314: ecx_utils.i_errparams),i_method_name); -- MLS
1315: end if;
1316: raise ecx_utils.program_exit;
1317: end put_on_outbound;
1310: end if;
1311: --ecx_utils.error_type := 30;
1312: if(l_unexpectedEnabled) then
1313: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,
1314: ecx_utils.i_errparams),i_method_name); -- MLS
1315: end if;
1316: raise ecx_utils.program_exit;
1317: end put_on_outbound;
1318:
1312: if(l_unexpectedEnabled) then
1313: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,
1314: ecx_utils.i_errparams),i_method_name); -- MLS
1315: end if;
1316: raise ecx_utils.program_exit;
1317: end put_on_outbound;
1318:
1319: /**
1320: Old put_on_outbound - pre BES integration
1396:
1397: exception
1398: when others then
1399: ecx_debug.setErrorInfo(1,25,'ECX_NO_UNIQUE_TP_SETUP');
1400: raise ecx_utils.program_exit;
1401: end;
1402:
1403: if i_hub_user_id is not null
1404: then
1423: ecx_debug.setErrorInfo(1,25,'ECX_DELIVERY_HUB_NOT_SETUP');
1424: if(l_unexpectedEnabled) then
1425: ecx_debug.log(l_unexpected,'ERROR', SQLERRM,i_method_name);
1426: end if;
1427: raise ecx_utils.program_exit;
1428: end;
1429: end if;
1430:
1431:
1435: 'p_tp_location_code', i_source_code,
1436: 'p_transaction_type', i_ext_type,
1437: 'p_transaction_subtype', i_ext_subtype,
1438: 'p_standard', i_standard_code);
1439: raise ecx_utils.program_exit;
1440: end if;
1441:
1442: ecx_obfuscate.ecx_data_encrypt
1443: (
1449: );
1450:
1451: if (o_retcode > 0)
1452: then
1453: --ecx_utils.i_ret_code := o_retcode;
1454: --ecx_utils.i_errbuf := o_retmsg;
1455: --ecx_utils.error_type := 30;
1456: ecx_debug.setErrorInfo(o_retcode,30,o_retmsg);
1457: raise ecx_utils.program_exit;
1450:
1451: if (o_retcode > 0)
1452: then
1453: --ecx_utils.i_ret_code := o_retcode;
1454: --ecx_utils.i_errbuf := o_retmsg;
1455: --ecx_utils.error_type := 30;
1456: ecx_debug.setErrorInfo(o_retcode,30,o_retmsg);
1457: raise ecx_utils.program_exit;
1458: end if;
1451: if (o_retcode > 0)
1452: then
1453: --ecx_utils.i_ret_code := o_retcode;
1454: --ecx_utils.i_errbuf := o_retmsg;
1455: --ecx_utils.error_type := 30;
1456: ecx_debug.setErrorInfo(o_retcode,30,o_retmsg);
1457: raise ecx_utils.program_exit;
1458: end if;
1459: if(l_statementEnabled) then
1453: --ecx_utils.i_ret_code := o_retcode;
1454: --ecx_utils.i_errbuf := o_retmsg;
1455: --ecx_utils.error_type := 30;
1456: ecx_debug.setErrorInfo(o_retcode,30,o_retmsg);
1457: raise ecx_utils.program_exit;
1458: end if;
1459: if(l_statementEnabled) then
1460: ecx_debug.log(l_statement,'i_standard_type',i_standard_type,i_method_name);
1461: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
1483: i_destination_address,
1484: i_username,
1485: m_password,
1486: i_xmldoc,
1487: ecx_utils.g_company_name,
1488: null,
1489: i_destination_code,
1490: null,
1491: null
1500: and etd.tp_detail_id = i_tp_detail_id;
1501: exception
1502: when others then
1503: ecx_debug.setErrorInfo(1,30, SQLERRM);
1504: raise ecx_utils.program_exit;
1505: end;
1506:
1507: v_message.party_type := i_party_type;
1508:
1553: elsif (l_retcode >= 2 ) then
1554: if(l_unexpectedEnabled) then
1555: ecx_debug.log(l_unexpected, l_retmsg,i_method_name);
1556: end if;
1557: raise ecx_utils.program_exit;
1558: end if;
1559: end;
1560:
1561: -- maintain attachment mappings if this is a passthrough case
1567: if (l_procedureEnabled) then
1568: ecx_debug.pop(i_method_name);
1569: end if;
1570: exception
1571: WHEN ECX_UTILS.PROGRAM_EXIT THEN
1572: i_hub_user_id := null;
1573: if (l_procedureEnabled) then
1574: ecx_debug.pop(i_method_name);
1575: end if;
1572: i_hub_user_id := null;
1573: if (l_procedureEnabled) then
1574: ecx_debug.pop(i_method_name);
1575: end if;
1576: raise ecx_utils.program_exit;
1577: when others then
1578: i_hub_user_id := null;
1579: ecx_debug.setErrorInfo(2,30, SQLERRM|| ' - ECX_INBOUND_TRIG.PUT_ON_OUTBOUND');
1580: if(l_unexpectedEnabled) then
1577: when others then
1578: i_hub_user_id := null;
1579: ecx_debug.setErrorInfo(2,30, SQLERRM|| ' - ECX_INBOUND_TRIG.PUT_ON_OUTBOUND');
1580: if(l_unexpectedEnabled) then
1581: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
1582: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1583: end if;
1584: raise ecx_utils.program_exit;
1585: end put_on_outbound;
1578: i_hub_user_id := null;
1579: ecx_debug.setErrorInfo(2,30, SQLERRM|| ' - ECX_INBOUND_TRIG.PUT_ON_OUTBOUND');
1580: if(l_unexpectedEnabled) then
1581: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
1582: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1583: end if;
1584: raise ecx_utils.program_exit;
1585: end put_on_outbound;
1586:
1580: if(l_unexpectedEnabled) then
1581: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
1582: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1583: end if;
1584: raise ecx_utils.program_exit;
1585: end put_on_outbound;
1586:
1587: --This is for Internal testing and Debugging Only. Takes the Message
1588: --off from the given Queue in the Browse Mode and processes it.
1618: end if;
1619: -- /logging enabled
1620:
1621: IF (ecx_logging_enabled ) THEN
1622: ecx_utils.getLogDirectory;
1623: ecx_debug.enable_debug_new(i_debug_level,ecx_utils.g_logdir, 'IN'||i_queue_name||'.log', 'in.'||i_queue_name||'.log');
1624: END IF;
1625:
1626: /* Assign local variables with the ecx_debug global variables*/
1619: -- /logging enabled
1620:
1621: IF (ecx_logging_enabled ) THEN
1622: ecx_utils.getLogDirectory;
1623: ecx_debug.enable_debug_new(i_debug_level,ecx_utils.g_logdir, 'IN'||i_queue_name||'.log', 'in.'||i_queue_name||'.log');
1624: END IF;
1625:
1626: /* Assign local variables with the ecx_debug global variables*/
1627: l_procedure := ecx_debug.g_procedure;
1652: ecx_debug.disable_debug;
1653: END IF;
1654:
1655: exception
1656: when ecx_utils.program_exit then
1657: if(l_unexpectedEnabled) then
1658: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1659: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1660: end if;
1654:
1655: exception
1656: when ecx_utils.program_exit then
1657: if(l_unexpectedEnabled) then
1658: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1659: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1660: end if;
1661: IF (ecx_logging_enabled ) THEN
1662: ecx_debug.print_log;
1655: exception
1656: when ecx_utils.program_exit then
1657: if(l_unexpectedEnabled) then
1658: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1659: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1660: end if;
1661: IF (ecx_logging_enabled ) THEN
1662: ecx_debug.print_log;
1663: ecx_debug.disable_debug;
1662: ecx_debug.print_log;
1663: ecx_debug.disable_debug;
1664: END IF;
1665: when others then
1666: ecx_utils.i_errbuf := SQLERRM || ' - ECX_INBOUND_TRIG.PROCESSMSG_FROM_QUEUE';
1667: if(l_unexpectedEnabled) then
1668: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1669: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1670: end if;
1664: END IF;
1665: when others then
1666: ecx_utils.i_errbuf := SQLERRM || ' - ECX_INBOUND_TRIG.PROCESSMSG_FROM_QUEUE';
1667: if(l_unexpectedEnabled) then
1668: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1669: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1670: end if;
1671: IF (ecx_logging_enabled ) THEN
1672: ecx_debug.print_log;
1665: when others then
1666: ecx_utils.i_errbuf := SQLERRM || ' - ECX_INBOUND_TRIG.PROCESSMSG_FROM_QUEUE';
1667: if(l_unexpectedEnabled) then
1668: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1669: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1670: end if;
1671: IF (ecx_logging_enabled ) THEN
1672: ecx_debug.print_log;
1673: ecx_debug.disable_debug;
1703: -- /logging enabled
1704:
1705: IF (ecx_logging_enabled ) THEN
1706: --get the Log directory from the Profile Option.
1707: ecx_utils.getLogDirectory;
1708: ecx_debug.enable_debug_new(i_debug_level, ecx_utils.g_logdir, 'IN' ||i_msgid||'.log', 'in.'||i_msgid||'.log');
1709: END IF;
1710:
1711: /* Assign local variables with the ecx_debug global variables*/
1704:
1705: IF (ecx_logging_enabled ) THEN
1706: --get the Log directory from the Profile Option.
1707: ecx_utils.getLogDirectory;
1708: ecx_debug.enable_debug_new(i_debug_level, ecx_utils.g_logdir, 'IN' ||i_msgid||'.log', 'in.'||i_msgid||'.log');
1709: END IF;
1710:
1711: /* Assign local variables with the ecx_debug global variables*/
1712: l_procedure := ecx_debug.g_procedure;
1736: ecx_debug.disable_debug;
1737: END IF;
1738:
1739: exception
1740: when ecx_utils.program_exit then
1741: if(l_unexpectedEnabled) then
1742: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1743: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1744: end if;
1738:
1739: exception
1740: when ecx_utils.program_exit then
1741: if(l_unexpectedEnabled) then
1742: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1743: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1744: end if;
1745: IF (ecx_logging_enabled ) THEN
1746: ecx_debug.print_log;
1739: exception
1740: when ecx_utils.program_exit then
1741: if(l_unexpectedEnabled) then
1742: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1743: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1744: end if;
1745: IF (ecx_logging_enabled ) THEN
1746: ecx_debug.print_log;
1747: ecx_debug.disable_debug;
1747: ecx_debug.disable_debug;
1748: END IF;
1749:
1750: when others then
1751: ecx_utils.i_errbuf := SQLERRM || ' - ECX_INBOUND_TRIG.PROCESSMSG_FROM_TABLE';
1752: if(l_unexpectedEnabled) then
1753: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1754: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1755: end if;
1749:
1750: when others then
1751: ecx_utils.i_errbuf := SQLERRM || ' - ECX_INBOUND_TRIG.PROCESSMSG_FROM_TABLE';
1752: if(l_unexpectedEnabled) then
1753: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1754: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1755: end if;
1756:
1757: IF (ecx_logging_enabled ) THEN
1750: when others then
1751: ecx_utils.i_errbuf := SQLERRM || ' - ECX_INBOUND_TRIG.PROCESSMSG_FROM_TABLE';
1752: if(l_unexpectedEnabled) then
1753: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1754: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1755: end if;
1756:
1757: IF (ecx_logging_enabled ) THEN
1758: ecx_debug.print_log;
1834: raise msg_not_found;
1835: end if;
1836:
1837: close get_msg;
1838: ecx_utils.g_direction := 'IN';
1839: ecx_utils.g_logfile :=null;
1840: ecx_debug.g_v_module_name :='ecx.plsql.';
1841: ecx_utils.g_transaction_type := m_transaction_type;
1842: ecx_utils.g_transaction_subtype := m_transaction_subtype;
1835: end if;
1836:
1837: close get_msg;
1838: ecx_utils.g_direction := 'IN';
1839: ecx_utils.g_logfile :=null;
1840: ecx_debug.g_v_module_name :='ecx.plsql.';
1841: ecx_utils.g_transaction_type := m_transaction_type;
1842: ecx_utils.g_transaction_subtype := m_transaction_subtype;
1843: ecx_utils.g_msgid := i_msgid;
1837: close get_msg;
1838: ecx_utils.g_direction := 'IN';
1839: ecx_utils.g_logfile :=null;
1840: ecx_debug.g_v_module_name :='ecx.plsql.';
1841: ecx_utils.g_transaction_type := m_transaction_type;
1842: ecx_utils.g_transaction_subtype := m_transaction_subtype;
1843: ecx_utils.g_msgid := i_msgid;
1844: begin
1845: select standard_id
1838: ecx_utils.g_direction := 'IN';
1839: ecx_utils.g_logfile :=null;
1840: ecx_debug.g_v_module_name :='ecx.plsql.';
1841: ecx_utils.g_transaction_type := m_transaction_type;
1842: ecx_utils.g_transaction_subtype := m_transaction_subtype;
1843: ecx_utils.g_msgid := i_msgid;
1844: begin
1845: select standard_id
1846: into ecx_utils.g_standard_id
1839: ecx_utils.g_logfile :=null;
1840: ecx_debug.g_v_module_name :='ecx.plsql.';
1841: ecx_utils.g_transaction_type := m_transaction_type;
1842: ecx_utils.g_transaction_subtype := m_transaction_subtype;
1843: ecx_utils.g_msgid := i_msgid;
1844: begin
1845: select standard_id
1846: into ecx_utils.g_standard_id
1847: from ecx_standards
1842: ecx_utils.g_transaction_subtype := m_transaction_subtype;
1843: ecx_utils.g_msgid := i_msgid;
1844: begin
1845: select standard_id
1846: into ecx_utils.g_standard_id
1847: from ecx_standards
1848: where standard_code = m_message_standard
1849: and standard_type = nvl(m_message_type, 'XML');
1850: if(l_statementEnabled) then
1847: from ecx_standards
1848: where standard_code = m_message_standard
1849: and standard_type = nvl(m_message_type, 'XML');
1850: if(l_statementEnabled) then
1851: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
1852: end if;
1853: exception
1854: when others then
1855: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');
1852: end if;
1853: exception
1854: when others then
1855: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');
1856: raise ecx_utils.program_exit;
1857: end;
1858: ecx_debug.module_enabled;
1859: g_instlmode := wf_core.translate('WF_INSTALL');
1860:
1879: Fetch the Run Id for the Transaction
1880: **/
1881: open get_run_s;
1882: fetch get_run_s
1883: into ecx_utils.g_run_id;
1884: close get_run_s;
1885:
1886: --get the Log directory from the Profile Option.
1887: ecx_utils.getLogDirectory;
1883: into ecx_utils.g_run_id;
1884: close get_run_s;
1885:
1886: --get the Log directory from the Profile Option.
1887: ecx_utils.getLogDirectory;
1888:
1889: i_logfile := substr(m_message_standard,1,10)||'IN'||substr(m_transaction_type,1,20)||substr(m_transaction_subtype,1,20)||ecx_utils.g_run_id||'.log';
1890:
1891: p_aflog_module_name := '';
1885:
1886: --get the Log directory from the Profile Option.
1887: ecx_utils.getLogDirectory;
1888:
1889: i_logfile := substr(m_message_standard,1,10)||'IN'||substr(m_transaction_type,1,20)||substr(m_transaction_subtype,1,20)||ecx_utils.g_run_id||'.log';
1890:
1891: p_aflog_module_name := '';
1892: IF (m_message_standard is not null) THEN
1893: p_aflog_module_name := p_aflog_module_name||m_message_standard||'.';
1898: END IF;
1899: IF (m_transaction_subtype is not null) THEN
1900: p_aflog_module_name := p_aflog_module_name||m_transaction_subtype||'.';
1901: END IF;
1902: IF (ecx_utils.g_run_id is not null) THEN
1903: p_aflog_module_name := p_aflog_module_name||ecx_utils.g_run_id;
1904: END IF;
1905: p_aflog_module_name := p_aflog_module_name||'.log';
1906:
1899: IF (m_transaction_subtype is not null) THEN
1900: p_aflog_module_name := p_aflog_module_name||m_transaction_subtype||'.';
1901: END IF;
1902: IF (ecx_utils.g_run_id is not null) THEN
1903: p_aflog_module_name := p_aflog_module_name||ecx_utils.g_run_id;
1904: END IF;
1905: p_aflog_module_name := p_aflog_module_name||'.log';
1906:
1907: ecx_debug.enable_debug_new(i_debug_level,ecx_utils.g_logdir,i_logfile, p_aflog_module_name);
1903: p_aflog_module_name := p_aflog_module_name||ecx_utils.g_run_id;
1904: END IF;
1905: p_aflog_module_name := p_aflog_module_name||'.log';
1906:
1907: ecx_debug.enable_debug_new(i_debug_level,ecx_utils.g_logdir,i_logfile, p_aflog_module_name);
1908: END IF;
1909:
1910: /* Assign local variables with the ecx_debug global variables*/
1911: l_procedure := ecx_debug.g_procedure;
1922: if(l_statementEnabled) then
1923: ecx_debug.log(l_statement,'i_msgid',i_msgid,i_method_name);
1924: ecx_debug.log(l_statement,'i_debug_level',i_debug_level,i_method_name);
1925: end if;
1926: ecx_utils.g_document_id :=m_internal_control_number;
1927:
1928: IF (ecx_logging_enabled and g_instlmode = 'STANDALONE') THEN
1929: ecx_utils.g_logfile :=i_logfile;
1930: END IF;
1925: end if;
1926: ecx_utils.g_document_id :=m_internal_control_number;
1927:
1928: IF (ecx_logging_enabled and g_instlmode = 'STANDALONE') THEN
1929: ecx_utils.g_logfile :=i_logfile;
1930: END IF;
1931:
1932: /*ecx_utils.g_direction := 'IN';
1933:
1928: IF (ecx_logging_enabled and g_instlmode = 'STANDALONE') THEN
1929: ecx_utils.g_logfile :=i_logfile;
1930: END IF;
1931:
1932: /*ecx_utils.g_direction := 'IN';
1933:
1934: ecx_utils.g_transaction_type := m_transaction_type;
1935: ecx_utils.g_transaction_subtype := m_transaction_subtype;
1936: ecx_utils.g_msgid := i_msgid;*/
1930: END IF;
1931:
1932: /*ecx_utils.g_direction := 'IN';
1933:
1934: ecx_utils.g_transaction_type := m_transaction_type;
1935: ecx_utils.g_transaction_subtype := m_transaction_subtype;
1936: ecx_utils.g_msgid := i_msgid;*/
1937:
1938: /*begin
1931:
1932: /*ecx_utils.g_direction := 'IN';
1933:
1934: ecx_utils.g_transaction_type := m_transaction_type;
1935: ecx_utils.g_transaction_subtype := m_transaction_subtype;
1936: ecx_utils.g_msgid := i_msgid;*/
1937:
1938: /*begin
1939: select standard_id
1932: /*ecx_utils.g_direction := 'IN';
1933:
1934: ecx_utils.g_transaction_type := m_transaction_type;
1935: ecx_utils.g_transaction_subtype := m_transaction_subtype;
1936: ecx_utils.g_msgid := i_msgid;*/
1937:
1938: /*begin
1939: select standard_id
1940: into ecx_utils.g_standard_id
1936: ecx_utils.g_msgid := i_msgid;*/
1937:
1938: /*begin
1939: select standard_id
1940: into ecx_utils.g_standard_id
1941: from ecx_standards
1942: where standard_code = m_message_standard
1943: and standard_type = nvl(m_message_type, 'XML');
1944: if(l_statementEnabled) then
1941: from ecx_standards
1942: where standard_code = m_message_standard
1943: and standard_type = nvl(m_message_type, 'XML');
1944: if(l_statementEnabled) then
1945: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
1946: end if;
1947: exception
1948: when others then
1949: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');
1946: end if;
1947: exception
1948: when others then
1949: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');
1950: raise ecx_utils.program_exit;
1951: enid;*/
1952: validate_message
1953: (
1954: i_msgid,
1970: ecx_debug.disable_debug;
1971: END IF;
1972:
1973: exception
1974: when ecx_utils.program_exit then
1975: --ecx_utils.g_map_id := -1;
1976: if(l_unexpectedEnabled) then
1977: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1978: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1971: END IF;
1972:
1973: exception
1974: when ecx_utils.program_exit then
1975: --ecx_utils.g_map_id := -1;
1976: if(l_unexpectedEnabled) then
1977: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1978: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1979: end if;
1973: exception
1974: when ecx_utils.program_exit then
1975: --ecx_utils.g_map_id := -1;
1976: if(l_unexpectedEnabled) then
1977: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1978: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1979: end if;
1980: if (l_procedureEnabled) then
1981: ecx_debug.pop(i_method_name);
1974: when ecx_utils.program_exit then
1975: --ecx_utils.g_map_id := -1;
1976: if(l_unexpectedEnabled) then
1977: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1978: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1979: end if;
1980: if (l_procedureEnabled) then
1981: ecx_debug.pop(i_method_name);
1982: end if;
1987: END IF;
1988:
1989: raise;
1990: when msg_not_found then
1991: --ecx_utils.g_map_id := -1;
1992: ecx_debug.setErrorInfo(1,30,'ECX_MSGID_NOT_FOUND',
1993: 'p_msgid',
1994: i_msgid);
1995: close get_msg;
1994: i_msgid);
1995: close get_msg;
1996: raise;
1997: when others then
1998: --ecx_utils.g_map_id := -1;
1999: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
2000: if(l_unexpectedEnabled) then
2001: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
2002: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1997: when others then
1998: --ecx_utils.g_map_id := -1;
1999: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
2000: if(l_unexpectedEnabled) then
2001: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
2002: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
2003: end if;
2004: if (l_procedureEnabled) then
2005: ecx_debug.pop(i_method_name);
1998: --ecx_utils.g_map_id := -1;
1999: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
2000: if(l_unexpectedEnabled) then
2001: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
2002: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
2003: end if;
2004: if (l_procedureEnabled) then
2005: ecx_debug.pop(i_method_name);
2006: end if;
2070: logging_enabled varchar2(20);
2071: module varchar2(2000);
2072:
2073: begin
2074: ecx_utils.g_logfile :=null;
2075: ecx_debug.g_v_module_name :='ecx.plsql.';
2076: fnd_profile.get('AFLOG_ENABLED',logging_enabled);
2077: fnd_profile.get('AFLOG_MODULE',module);
2078: if(logging_enabled = 'Y' AND ((lower(module) like 'ecx%'
2108: Fetch the Run Id for the Transaction
2109: **/
2110: open get_run_s;
2111: fetch get_run_s
2112: into ecx_utils.g_run_id;
2113: close get_run_s;
2114:
2115: --get the Log directory from the Profile Option.
2116: ecx_utils.getLogDirectory;
2112: into ecx_utils.g_run_id;
2113: close get_run_s;
2114:
2115: --get the Log directory from the Profile Option.
2116: ecx_utils.getLogDirectory;
2117:
2118: i_logfile := m_message_standard||'IN'||m_transaction_type||m_transaction_subtype||ecx_utils.g_run_id||'.log';
2119:
2120: p_aflog_module_name := '';
2114:
2115: --get the Log directory from the Profile Option.
2116: ecx_utils.getLogDirectory;
2117:
2118: i_logfile := m_message_standard||'IN'||m_transaction_type||m_transaction_subtype||ecx_utils.g_run_id||'.log';
2119:
2120: p_aflog_module_name := '';
2121: IF (m_message_standard is not null) THEN
2122: p_aflog_module_name := p_aflog_module_name||m_message_standard||'.';
2127: END IF;
2128: IF (m_transaction_subtype is not null) THEN
2129: p_aflog_module_name := p_aflog_module_name||m_transaction_subtype||'.';
2130: END IF;
2131: IF (ecx_utils.g_run_id is not null) THEN
2132: p_aflog_module_name := p_aflog_module_name||ecx_utils.g_run_id;
2133: END IF;
2134: p_aflog_module_name := p_aflog_module_name||'.log';
2135:
2128: IF (m_transaction_subtype is not null) THEN
2129: p_aflog_module_name := p_aflog_module_name||m_transaction_subtype||'.';
2130: END IF;
2131: IF (ecx_utils.g_run_id is not null) THEN
2132: p_aflog_module_name := p_aflog_module_name||ecx_utils.g_run_id;
2133: END IF;
2134: p_aflog_module_name := p_aflog_module_name||'.log';
2135:
2136: ecx_debug.enable_debug_new(i_debug_level,ecx_utils.g_logdir,i_logfile, p_aflog_module_name);
2132: p_aflog_module_name := p_aflog_module_name||ecx_utils.g_run_id;
2133: END IF;
2134: p_aflog_module_name := p_aflog_module_name||'.log';
2135:
2136: ecx_debug.enable_debug_new(i_debug_level,ecx_utils.g_logdir,i_logfile, p_aflog_module_name);
2137: END IF;
2138:
2139: /* Assign local variables with the ecx_debug global variables*/
2140: l_procedure := ecx_debug.g_procedure;
2151: if(l_statementEnabled) then
2152: ecx_debug.log(l_statement,'i_msgid',i_msgid,i_method_name);
2153: ecx_debug.log(l_statement,'i_debug_level',i_debug_level,i_method_name);
2154: end if;
2155: ecx_utils.g_document_id :=m_internal_control_number;
2156:
2157: IF (ecx_logging_enabled ) THEN
2158: ecx_utils.g_logfile :=i_logfile;
2159: END IF;
2154: end if;
2155: ecx_utils.g_document_id :=m_internal_control_number;
2156:
2157: IF (ecx_logging_enabled ) THEN
2158: ecx_utils.g_logfile :=i_logfile;
2159: END IF;
2160:
2161: ecx_utils.g_direction := 'IN';
2162:
2157: IF (ecx_logging_enabled ) THEN
2158: ecx_utils.g_logfile :=i_logfile;
2159: END IF;
2160:
2161: ecx_utils.g_direction := 'IN';
2162:
2163: ecx_utils.g_transaction_type := m_transaction_type;
2164: ecx_utils.g_transaction_subtype := m_transaction_subtype;
2165: ecx_utils.g_msgid := i_msgid;
2159: END IF;
2160:
2161: ecx_utils.g_direction := 'IN';
2162:
2163: ecx_utils.g_transaction_type := m_transaction_type;
2164: ecx_utils.g_transaction_subtype := m_transaction_subtype;
2165: ecx_utils.g_msgid := i_msgid;
2166:
2167: begin
2160:
2161: ecx_utils.g_direction := 'IN';
2162:
2163: ecx_utils.g_transaction_type := m_transaction_type;
2164: ecx_utils.g_transaction_subtype := m_transaction_subtype;
2165: ecx_utils.g_msgid := i_msgid;
2166:
2167: begin
2168: select standard_id
2161: ecx_utils.g_direction := 'IN';
2162:
2163: ecx_utils.g_transaction_type := m_transaction_type;
2164: ecx_utils.g_transaction_subtype := m_transaction_subtype;
2165: ecx_utils.g_msgid := i_msgid;
2166:
2167: begin
2168: select standard_id
2169: into ecx_utils.g_standard_id
2165: ecx_utils.g_msgid := i_msgid;
2166:
2167: begin
2168: select standard_id
2169: into ecx_utils.g_standard_id
2170: from ecx_standards
2171: where standard_code = m_message_standard
2172: and standard_type = nvl(m_message_type, 'XML');
2173: if(l_statementEnabled) then
2170: from ecx_standards
2171: where standard_code = m_message_standard
2172: and standard_type = nvl(m_message_type, 'XML');
2173: if(l_statementEnabled) then
2174: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
2175: end if;
2176: exception
2177: when others then
2178: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');
2175: end if;
2176: exception
2177: when others then
2178: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');
2179: raise ecx_utils.program_exit;
2180: end;
2181:
2182: validate_message
2183: (
2201: END IF;
2202:
2203: commit;
2204: exception
2205: when ecx_utils.program_exit then
2206: --ecx_utils.g_map_id := -1;
2207: if(l_unexpectedEnabled) then
2208: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
2209: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
2202:
2203: commit;
2204: exception
2205: when ecx_utils.program_exit then
2206: --ecx_utils.g_map_id := -1;
2207: if(l_unexpectedEnabled) then
2208: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
2209: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
2210: end if;
2204: exception
2205: when ecx_utils.program_exit then
2206: --ecx_utils.g_map_id := -1;
2207: if(l_unexpectedEnabled) then
2208: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
2209: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
2210: end if;
2211: IF (ecx_logging_enabled ) THEN
2212: ecx_debug.print_log;
2205: when ecx_utils.program_exit then
2206: --ecx_utils.g_map_id := -1;
2207: if(l_unexpectedEnabled) then
2208: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
2209: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
2210: end if;
2211: IF (ecx_logging_enabled ) THEN
2212: ecx_debug.print_log;
2213: ecx_debug.disable_debug;
2213: ecx_debug.disable_debug;
2214: END IF;
2215: rollback;
2216: when msg_not_found then
2217: --ecx_utils.g_map_id := -1;
2218: ecx_debug.setErrorInfo(1,30,'ECX_MSGID_NOT_FOUND',
2219: 'p_msgid',
2220: i_msgid);
2221: close get_msg;
2220: i_msgid);
2221: close get_msg;
2222: rollback;
2223: when others then
2224: --ecx_utils.g_map_id := -1;
2225: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
2226: if(l_unexpectedEnabled) then
2227: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
2228: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
2223: when others then
2224: --ecx_utils.g_map_id := -1;
2225: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
2226: if(l_unexpectedEnabled) then
2227: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
2228: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
2229: end if;
2230: IF (ecx_logging_enabled ) THEN
2231: ecx_debug.print_log;
2224: --ecx_utils.g_map_id := -1;
2225: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
2226: if(l_unexpectedEnabled) then
2227: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
2228: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
2229: end if;
2230: IF (ecx_logging_enabled ) THEN
2231: ecx_debug.print_log;
2232: ecx_debug.disable_debug;
2288: Fetch the Run Id for the Transaction
2289: **/
2290: open get_run_s;
2291: fetch get_run_s
2292: into ecx_utils.g_run_id;
2293: close get_run_s;
2294:
2295: --get the Log directory from the Profile Option.
2296: ecx_utils.getLogDirectory;
2292: into ecx_utils.g_run_id;
2293: close get_run_s;
2294:
2295: --get the Log directory from the Profile Option.
2296: ecx_utils.getLogDirectory;
2297: i_logfile := 'IN'||ecx_utils.g_run_id||'.log';
2298: END IF;
2299:
2300: IF g_instlmode = 'EMBEDDED' THEN
2293: close get_run_s;
2294:
2295: --get the Log directory from the Profile Option.
2296: ecx_utils.getLogDirectory;
2297: i_logfile := 'IN'||ecx_utils.g_run_id||'.log';
2298: END IF;
2299:
2300: IF g_instlmode = 'EMBEDDED' THEN
2301: IF (ecx_logging_enabled ) THEN
2298: END IF;
2299:
2300: IF g_instlmode = 'EMBEDDED' THEN
2301: IF (ecx_logging_enabled ) THEN
2302: i_log_file := ecx_debug.g_sqlprefix || 'in.'||ecx_utils.g_run_id||'.log';
2303: ELSE
2304: i_log_file := 'Please ensure that FND-Logging is enabled for module '||ecx_debug.g_sqlprefix||'%';
2305: END IF;
2306: ELSE
2304: i_log_file := 'Please ensure that FND-Logging is enabled for module '||ecx_debug.g_sqlprefix||'%';
2305: END IF;
2306: ELSE
2307: IF (ecx_logging_enabled ) THEN
2308: i_log_file := ecx_utils.g_logdir||'/'||i_logfile;
2309: ELSE
2310: i_log_file := 'Please ensure that logging is enabled';
2311: END IF;
2312: END IF;
2311: END IF;
2312: END IF;
2313:
2314: IF (ecx_logging_enabled ) THEN
2315: ecx_debug.enable_debug_new(i_debug_level,ecx_utils.g_logdir,i_logfile, 'in.'||ecx_utils.g_run_id||'.log');
2316: END IF;
2317:
2318: /* Assign local variables with the ecx_debug global variables*/
2319: l_procedure := ecx_debug.g_procedure;
2332: ecx_debug.log(l_statement,'i_debug_level',i_debug_level,i_method_name);
2333: end if;
2334:
2335: IF (ecx_logging_enabled ) THEN
2336: ecx_utils.g_logfile :=i_logfile;
2337: END IF;
2338: ecx_utils.g_direction := 'IN';
2339:
2340: begin
2334:
2335: IF (ecx_logging_enabled ) THEN
2336: ecx_utils.g_logfile :=i_logfile;
2337: END IF;
2338: ecx_utils.g_direction := 'IN';
2339:
2340: begin
2341: select map_id
2342: into i_map_id
2346: when others then
2347: ecx_debug.setErrorInfo(2,30,'ECX_MAP_NOT_FOUND',
2348: 'MAP_CODE',
2349: i_map_code);
2350: raise ecx_utils.program_exit;
2351: end;
2352:
2353: begin
2354: select standard_id
2351: end;
2352:
2353: begin
2354: select standard_id
2355: into ecx_utils.g_standard_id
2356: from ecx_standards
2357: where standard_code = i_message_standard
2358: and standard_type = nvl(i_message_type, 'XML');
2359: if(l_statementEnabled) then
2356: from ecx_standards
2357: where standard_code = i_message_standard
2358: and standard_type = nvl(i_message_type, 'XML');
2359: if(l_statementEnabled) then
2360: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
2361: end if;
2362: exception
2363: when others then
2364: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');
2361: end if;
2362: exception
2363: when others then
2364: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');
2365: raise ecx_utils.program_exit;
2366: end;
2367:
2368: /*bug16442475 return status to notified and will set to complete from java*/
2369: if ecx_utils.g_from_processxml and ECX_UTIL_API.isInJavaProcessEnabled then
2365: raise ecx_utils.program_exit;
2366: end;
2367:
2368: /*bug16442475 return status to notified and will set to complete from java*/
2369: if ecx_utils.g_from_processxml and ECX_UTIL_API.isInJavaProcessEnabled then
2370: raiseEvent(
2371: i_msgid => null,
2372: i_document_number => null,
2373: i_map_id => i_map_id,
2378: if(l_statementEnabled) then
2379: ecx_debug.log(l_statement, 'ECX', 'Raised an event to process an xml at java layer',i_method_name);
2380: end if;
2381: /*set status to 0, other wise wffunction(caller of this function) will throw wf error for non zero error code */
2382: if(ecx_utils.i_ret_code = 10) then
2383: ecx_utils.i_ret_code := 0;
2384: end if;
2385: else
2386: ecx_debug.log(l_statement,'==>i_map_id',i_map_id,i_method_name);
2379: ecx_debug.log(l_statement, 'ECX', 'Raised an event to process an xml at java layer',i_method_name);
2380: end if;
2381: /*set status to 0, other wise wffunction(caller of this function) will throw wf error for non zero error code */
2382: if(ecx_utils.i_ret_code = 10) then
2383: ecx_utils.i_ret_code := 0;
2384: end if;
2385: else
2386: ecx_debug.log(l_statement,'==>i_map_id',i_map_id,i_method_name);
2387: processXMLData
2393: i_message_standard,
2394: o_payload,
2395: i_message_type
2396: );
2397: --ecx_utils.i_ret_code :=0;
2398: --ecx_utils.i_errbuf := 'XML Document Successfully processed';
2399: ecx_debug.setErrorInfo(0,10,'ECX_DOCUMENT_PROCESSED');
2400: end if;
2401:
2394: o_payload,
2395: i_message_type
2396: );
2397: --ecx_utils.i_ret_code :=0;
2398: --ecx_utils.i_errbuf := 'XML Document Successfully processed';
2399: ecx_debug.setErrorInfo(0,10,'ECX_DOCUMENT_PROCESSED');
2400: end if;
2401:
2402: --ecx_utils.i_ret_code :=0;
2398: --ecx_utils.i_errbuf := 'XML Document Successfully processed';
2399: ecx_debug.setErrorInfo(0,10,'ECX_DOCUMENT_PROCESSED');
2400: end if;
2401:
2402: --ecx_utils.i_ret_code :=0;
2403: --ecx_utils.i_errbuf := 'XML Document Successfully processed';
2404: ecx_debug.setErrorInfo(0,10,'ECX_DOCUMENT_PROCESSED');
2405:
2406: if(ecx_utils.i_ret_code = 0 ) then
2399: ecx_debug.setErrorInfo(0,10,'ECX_DOCUMENT_PROCESSED');
2400: end if;
2401:
2402: --ecx_utils.i_ret_code :=0;
2403: --ecx_utils.i_errbuf := 'XML Document Successfully processed';
2404: ecx_debug.setErrorInfo(0,10,'ECX_DOCUMENT_PROCESSED');
2405:
2406: if(ecx_utils.i_ret_code = 0 ) then
2407: if(l_statementEnabled) then
2402: --ecx_utils.i_ret_code :=0;
2403: --ecx_utils.i_errbuf := 'XML Document Successfully processed';
2404: ecx_debug.setErrorInfo(0,10,'ECX_DOCUMENT_PROCESSED');
2405:
2406: if(ecx_utils.i_ret_code = 0 ) then
2407: if(l_statementEnabled) then
2408: ecx_debug.log(l_statement, 'Ret Code',ecx_utils.i_ret_code,i_method_name);
2409: ecx_debug.log(l_statement, 'Ret Msg ',ecx_utils.i_errbuf,i_method_name);
2410: end if;
2404: ecx_debug.setErrorInfo(0,10,'ECX_DOCUMENT_PROCESSED');
2405:
2406: if(ecx_utils.i_ret_code = 0 ) then
2407: if(l_statementEnabled) then
2408: ecx_debug.log(l_statement, 'Ret Code',ecx_utils.i_ret_code,i_method_name);
2409: ecx_debug.log(l_statement, 'Ret Msg ',ecx_utils.i_errbuf,i_method_name);
2410: end if;
2411: else
2412: if(l_unexpectedEnabled) then
2405:
2406: if(ecx_utils.i_ret_code = 0 ) then
2407: if(l_statementEnabled) then
2408: ecx_debug.log(l_statement, 'Ret Code',ecx_utils.i_ret_code,i_method_name);
2409: ecx_debug.log(l_statement, 'Ret Msg ',ecx_utils.i_errbuf,i_method_name);
2410: end if;
2411: else
2412: if(l_unexpectedEnabled) then
2413: ecx_debug.log(l_unexpected, 'Ret Code',ecx_utils.i_ret_code,i_method_name);
2409: ecx_debug.log(l_statement, 'Ret Msg ',ecx_utils.i_errbuf,i_method_name);
2410: end if;
2411: else
2412: if(l_unexpectedEnabled) then
2413: ecx_debug.log(l_unexpected, 'Ret Code',ecx_utils.i_ret_code,i_method_name);
2414: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_utils.i_errbuf,i_method_name);
2415: end if;
2416: end if;
2417:
2410: end if;
2411: else
2412: if(l_unexpectedEnabled) then
2413: ecx_debug.log(l_unexpected, 'Ret Code',ecx_utils.i_ret_code,i_method_name);
2414: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_utils.i_errbuf,i_method_name);
2415: end if;
2416: end if;
2417:
2418: if (l_procedureEnabled) then
2423: ecx_debug.print_log;
2424: ecx_debug.disable_debug;
2425: END IF;
2426:
2427: i_ret_code := ecx_utils.i_ret_code;
2428: i_errbuf := ecx_utils.i_errbuf;
2429:
2430: exception
2431: when ecx_utils.program_exit then
2424: ecx_debug.disable_debug;
2425: END IF;
2426:
2427: i_ret_code := ecx_utils.i_ret_code;
2428: i_errbuf := ecx_utils.i_errbuf;
2429:
2430: exception
2431: when ecx_utils.program_exit then
2432: --dbms_lob.freetemporary(o_payload);
2427: i_ret_code := ecx_utils.i_ret_code;
2428: i_errbuf := ecx_utils.i_errbuf;
2429:
2430: exception
2431: when ecx_utils.program_exit then
2432: --dbms_lob.freetemporary(o_payload);
2433: --ecx_utils.g_map_id := -1;
2434: if(l_unexpectedEnabled) then
2435: ecx_debug.log(l_unexpected,'Ret Code',ecx_utils.i_ret_code,i_method_name);
2429:
2430: exception
2431: when ecx_utils.program_exit then
2432: --dbms_lob.freetemporary(o_payload);
2433: --ecx_utils.g_map_id := -1;
2434: if(l_unexpectedEnabled) then
2435: ecx_debug.log(l_unexpected,'Ret Code',ecx_utils.i_ret_code,i_method_name);
2436: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_debug.getMessage(ecx_utils.i_errbuf,
2437: ecx_utils.i_errparams),i_method_name);
2431: when ecx_utils.program_exit then
2432: --dbms_lob.freetemporary(o_payload);
2433: --ecx_utils.g_map_id := -1;
2434: if(l_unexpectedEnabled) then
2435: ecx_debug.log(l_unexpected,'Ret Code',ecx_utils.i_ret_code,i_method_name);
2436: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_debug.getMessage(ecx_utils.i_errbuf,
2437: ecx_utils.i_errparams),i_method_name);
2438: end if;
2439: if (l_procedureEnabled) then
2432: --dbms_lob.freetemporary(o_payload);
2433: --ecx_utils.g_map_id := -1;
2434: if(l_unexpectedEnabled) then
2435: ecx_debug.log(l_unexpected,'Ret Code',ecx_utils.i_ret_code,i_method_name);
2436: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_debug.getMessage(ecx_utils.i_errbuf,
2437: ecx_utils.i_errparams),i_method_name);
2438: end if;
2439: if (l_procedureEnabled) then
2440: ecx_debug.pop(i_method_name);
2433: --ecx_utils.g_map_id := -1;
2434: if(l_unexpectedEnabled) then
2435: ecx_debug.log(l_unexpected,'Ret Code',ecx_utils.i_ret_code,i_method_name);
2436: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_debug.getMessage(ecx_utils.i_errbuf,
2437: ecx_utils.i_errparams),i_method_name);
2438: end if;
2439: if (l_procedureEnabled) then
2440: ecx_debug.pop(i_method_name);
2441: end if;
2442: IF (ecx_logging_enabled ) THEN
2443: ecx_debug.print_log;
2444: ecx_debug.disable_debug;
2445: END IF;
2446: i_ret_code := ecx_utils.i_ret_code;
2447: i_errbuf := ecx_utils.i_errbuf;
2448:
2449: when others then
2450: --dbms_lob.freetemporary(o_payload);
2443: ecx_debug.print_log;
2444: ecx_debug.disable_debug;
2445: END IF;
2446: i_ret_code := ecx_utils.i_ret_code;
2447: i_errbuf := ecx_utils.i_errbuf;
2448:
2449: when others then
2450: --dbms_lob.freetemporary(o_payload);
2451: --ecx_utils.g_map_id := -1;
2447: i_errbuf := ecx_utils.i_errbuf;
2448:
2449: when others then
2450: --dbms_lob.freetemporary(o_payload);
2451: --ecx_utils.g_map_id := -1;
2452: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
2453: if(l_unexpectedEnabled) then
2454: ecx_debug.log(l_unexpected,'Ret Code',ecx_utils.i_ret_code,i_method_name);
2455: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_debug.getMessage(ecx_utils.i_errbuf,
2450: --dbms_lob.freetemporary(o_payload);
2451: --ecx_utils.g_map_id := -1;
2452: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
2453: if(l_unexpectedEnabled) then
2454: ecx_debug.log(l_unexpected,'Ret Code',ecx_utils.i_ret_code,i_method_name);
2455: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_debug.getMessage(ecx_utils.i_errbuf,
2456: ecx_utils.i_errparams),i_method_name);
2457: end if;
2458: if (l_procedureEnabled) then
2451: --ecx_utils.g_map_id := -1;
2452: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
2453: if(l_unexpectedEnabled) then
2454: ecx_debug.log(l_unexpected,'Ret Code',ecx_utils.i_ret_code,i_method_name);
2455: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_debug.getMessage(ecx_utils.i_errbuf,
2456: ecx_utils.i_errparams),i_method_name);
2457: end if;
2458: if (l_procedureEnabled) then
2459: ecx_debug.pop(i_method_name);
2452: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
2453: if(l_unexpectedEnabled) then
2454: ecx_debug.log(l_unexpected,'Ret Code',ecx_utils.i_ret_code,i_method_name);
2455: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_debug.getMessage(ecx_utils.i_errbuf,
2456: ecx_utils.i_errparams),i_method_name);
2457: end if;
2458: if (l_procedureEnabled) then
2459: ecx_debug.pop(i_method_name);
2460: end if;
2461: IF (ecx_logging_enabled ) THEN
2462: ecx_debug.print_log;
2463: ecx_debug.disable_debug;
2464: END IF;
2465: i_ret_code := ecx_utils.i_ret_code;
2466: i_errbuf := ecx_utils.i_errbuf;
2467: end processXML;
2468:
2469:
2462: ecx_debug.print_log;
2463: ecx_debug.disable_debug;
2464: END IF;
2465: i_ret_code := ecx_utils.i_ret_code;
2466: i_errbuf := ecx_utils.i_errbuf;
2467: end processXML;
2468:
2469:
2470: procedure reprocess
2491: (
2492: i_trigger_id,
2493: i_msgid,
2494: null,
2495: ecx_utils.i_ret_code,
2496: ecx_utils.i_errbuf
2497: );
2498:
2499: */
2492: i_trigger_id,
2493: i_msgid,
2494: null,
2495: ecx_utils.i_ret_code,
2496: ecx_utils.i_errbuf
2497: );
2498:
2499: */
2500:
2510: if(i_process_id is null) -- means TP setup wrong. Message never got into transaction queue.
2511: then
2512: return;
2513: end if;
2514: ecx_errorlog.inbound_engine(i_process_id,ecx_utils.i_ret_code,
2515: ecx_utils.i_errbuf);
2516: ecx_utils.g_logfile := null;
2517: exception
2518: when others then
2511: then
2512: return;
2513: end if;
2514: ecx_errorlog.inbound_engine(i_process_id,ecx_utils.i_ret_code,
2515: ecx_utils.i_errbuf);
2516: ecx_utils.g_logfile := null;
2517: exception
2518: when others then
2519:
2512: return;
2513: end if;
2514: ecx_errorlog.inbound_engine(i_process_id,ecx_utils.i_ret_code,
2515: ecx_utils.i_errbuf);
2516: ecx_utils.g_logfile := null;
2517: exception
2518: when others then
2519:
2520: select process_id into i_process_id from ecx_inbound_logs where msgid=i_msgid; -- fix for bug 7609421 / 8629681
2517: exception
2518: when others then
2519:
2520: select process_id into i_process_id from ecx_inbound_logs where msgid=i_msgid; -- fix for bug 7609421 / 8629681
2521: ecx_errorlog.inbound_engine(i_process_id,ecx_utils.i_ret_code, ecx_utils.i_errbuf,ecx_utils.i_errparams);
2522: i_retcode := ecx_utils.i_ret_code;
2523: i_errbuf := ecx_utils.i_errbuf;
2524: ecx_utils.g_logfile := null;
2525: end;
2518: when others then
2519:
2520: select process_id into i_process_id from ecx_inbound_logs where msgid=i_msgid; -- fix for bug 7609421 / 8629681
2521: ecx_errorlog.inbound_engine(i_process_id,ecx_utils.i_ret_code, ecx_utils.i_errbuf,ecx_utils.i_errparams);
2522: i_retcode := ecx_utils.i_ret_code;
2523: i_errbuf := ecx_utils.i_errbuf;
2524: ecx_utils.g_logfile := null;
2525: end;
2526:
2519:
2520: select process_id into i_process_id from ecx_inbound_logs where msgid=i_msgid; -- fix for bug 7609421 / 8629681
2521: ecx_errorlog.inbound_engine(i_process_id,ecx_utils.i_ret_code, ecx_utils.i_errbuf,ecx_utils.i_errparams);
2522: i_retcode := ecx_utils.i_ret_code;
2523: i_errbuf := ecx_utils.i_errbuf;
2524: ecx_utils.g_logfile := null;
2525: end;
2526:
2527: --Changed for MLS
2520: select process_id into i_process_id from ecx_inbound_logs where msgid=i_msgid; -- fix for bug 7609421 / 8629681
2521: ecx_errorlog.inbound_engine(i_process_id,ecx_utils.i_ret_code, ecx_utils.i_errbuf,ecx_utils.i_errparams);
2522: i_retcode := ecx_utils.i_ret_code;
2523: i_errbuf := ecx_utils.i_errbuf;
2524: ecx_utils.g_logfile := null;
2525: end;
2526:
2527: --Changed for MLS
2528: ecx_debug.setErrorInfo(0,10,'ECX_MESSAGE_REPROCESSED');
2525: end;
2526:
2527: --Changed for MLS
2528: ecx_debug.setErrorInfo(0,10,'ECX_MESSAGE_REPROCESSED');
2529: i_retcode := ecx_utils.i_ret_code;
2530: i_errbuf := ecx_utils.i_errbuf;
2531: exception
2532: when others then
2533: i_retcode := ecx_utils.i_ret_code;
2526:
2527: --Changed for MLS
2528: ecx_debug.setErrorInfo(0,10,'ECX_MESSAGE_REPROCESSED');
2529: i_retcode := ecx_utils.i_ret_code;
2530: i_errbuf := ecx_utils.i_errbuf;
2531: exception
2532: when others then
2533: i_retcode := ecx_utils.i_ret_code;
2534: i_errbuf := ecx_utils.i_errbuf;
2529: i_retcode := ecx_utils.i_ret_code;
2530: i_errbuf := ecx_utils.i_errbuf;
2531: exception
2532: when others then
2533: i_retcode := ecx_utils.i_ret_code;
2534: i_errbuf := ecx_utils.i_errbuf;
2535: raise;
2536: end reprocess;
2537: /*
2530: i_errbuf := ecx_utils.i_errbuf;
2531: exception
2532: when others then
2533: i_retcode := ecx_utils.i_ret_code;
2534: i_errbuf := ecx_utils.i_errbuf;
2535: raise;
2536: end reprocess;
2537: /*
2538: * Raising an event(oracle.apps.ecx.inbound.process_at_java)
2562: if(l_statementEnabled) then
2563: ecx_debug.log(l_statement, 'ECX', 'Raising an event to processing an xml at middle tier',l_method_name);
2564: ecx_debug.log(l_statement, 'Event Name',l_event_name,l_method_name);
2565: ecx_debug.log(l_statement, 'Event Key',l_event_key,l_method_name);
2566: ecx_debug.log(l_statement, 'LOGFILE', ecx_utils.g_logfile,l_method_name);
2567: ecx_debug.log(l_statement, 'ecx_utils.g_item_type',ecx_utils.g_item_type,l_method_name);
2568: ecx_debug.log(l_statement, 'ITEM_TYPE', ecx_utils.g_item_type,l_method_name);
2569: ecx_debug.log(l_statement, 'ITEM_KEY', ecx_utils.g_item_key,l_method_name);
2570: ecx_debug.log(l_statement, 'ACTIVITY_ID', ecx_utils.g_activity_id,l_method_name);
2563: ecx_debug.log(l_statement, 'ECX', 'Raising an event to processing an xml at middle tier',l_method_name);
2564: ecx_debug.log(l_statement, 'Event Name',l_event_name,l_method_name);
2565: ecx_debug.log(l_statement, 'Event Key',l_event_key,l_method_name);
2566: ecx_debug.log(l_statement, 'LOGFILE', ecx_utils.g_logfile,l_method_name);
2567: ecx_debug.log(l_statement, 'ecx_utils.g_item_type',ecx_utils.g_item_type,l_method_name);
2568: ecx_debug.log(l_statement, 'ITEM_TYPE', ecx_utils.g_item_type,l_method_name);
2569: ecx_debug.log(l_statement, 'ITEM_KEY', ecx_utils.g_item_key,l_method_name);
2570: ecx_debug.log(l_statement, 'ACTIVITY_ID', ecx_utils.g_activity_id,l_method_name);
2571: ecx_debug.log(l_statement, 'DOCUMENT_ID', i_document_number,l_method_name);
2564: ecx_debug.log(l_statement, 'Event Name',l_event_name,l_method_name);
2565: ecx_debug.log(l_statement, 'Event Key',l_event_key,l_method_name);
2566: ecx_debug.log(l_statement, 'LOGFILE', ecx_utils.g_logfile,l_method_name);
2567: ecx_debug.log(l_statement, 'ecx_utils.g_item_type',ecx_utils.g_item_type,l_method_name);
2568: ecx_debug.log(l_statement, 'ITEM_TYPE', ecx_utils.g_item_type,l_method_name);
2569: ecx_debug.log(l_statement, 'ITEM_KEY', ecx_utils.g_item_key,l_method_name);
2570: ecx_debug.log(l_statement, 'ACTIVITY_ID', ecx_utils.g_activity_id,l_method_name);
2571: ecx_debug.log(l_statement, 'DOCUMENT_ID', i_document_number,l_method_name);
2572: ecx_debug.log(l_statement, 'PROCESS_ID', l_process_id,l_method_name);
2565: ecx_debug.log(l_statement, 'Event Key',l_event_key,l_method_name);
2566: ecx_debug.log(l_statement, 'LOGFILE', ecx_utils.g_logfile,l_method_name);
2567: ecx_debug.log(l_statement, 'ecx_utils.g_item_type',ecx_utils.g_item_type,l_method_name);
2568: ecx_debug.log(l_statement, 'ITEM_TYPE', ecx_utils.g_item_type,l_method_name);
2569: ecx_debug.log(l_statement, 'ITEM_KEY', ecx_utils.g_item_key,l_method_name);
2570: ecx_debug.log(l_statement, 'ACTIVITY_ID', ecx_utils.g_activity_id,l_method_name);
2571: ecx_debug.log(l_statement, 'DOCUMENT_ID', i_document_number,l_method_name);
2572: ecx_debug.log(l_statement, 'PROCESS_ID', l_process_id,l_method_name);
2573: ecx_debug.log(l_statement, 'MSGID', i_msgid,l_method_name);
2566: ecx_debug.log(l_statement, 'LOGFILE', ecx_utils.g_logfile,l_method_name);
2567: ecx_debug.log(l_statement, 'ecx_utils.g_item_type',ecx_utils.g_item_type,l_method_name);
2568: ecx_debug.log(l_statement, 'ITEM_TYPE', ecx_utils.g_item_type,l_method_name);
2569: ecx_debug.log(l_statement, 'ITEM_KEY', ecx_utils.g_item_key,l_method_name);
2570: ecx_debug.log(l_statement, 'ACTIVITY_ID', ecx_utils.g_activity_id,l_method_name);
2571: ecx_debug.log(l_statement, 'DOCUMENT_ID', i_document_number,l_method_name);
2572: ecx_debug.log(l_statement, 'PROCESS_ID', l_process_id,l_method_name);
2573: ecx_debug.log(l_statement, 'MSGID', i_msgid,l_method_name);
2574: ecx_debug.log(l_statement, 'i_no_routing', i_no_routing,l_method_name);
2576: wf_event_t.initialize(l_event);
2577: if (l_msg_id_null = 'N') then
2578: select process_id into l_process_id from ecx_inbound_logs where msgid=i_msgid;
2579: end if;
2580: l_event.addParameterToList('ROUTING_ID', ecx_utils.g_routing_id);
2581: if(l_statementEnabled) then
2582: l_event.addParameterToList('STAMENT_LEVEL_ENABLED', 'Y');
2583: end if;
2584: ecx_debug.log(l_statement, 'ecx_utils.g_org_id',ecx_utils.g_org_id,l_method_name);
2580: l_event.addParameterToList('ROUTING_ID', ecx_utils.g_routing_id);
2581: if(l_statementEnabled) then
2582: l_event.addParameterToList('STAMENT_LEVEL_ENABLED', 'Y');
2583: end if;
2584: ecx_debug.log(l_statement, 'ecx_utils.g_org_id',ecx_utils.g_org_id,l_method_name);
2585: l_event.addParameterToList('MSGID', i_msgid);
2586: l_event.addParameterToList('DOCUMENT_ID', i_document_number);
2587: l_event.addParameterToList('PROCESS_ID', l_process_id);
2588: l_event.addParameterToList('MAP_CODE', i_map_id);
2585: l_event.addParameterToList('MSGID', i_msgid);
2586: l_event.addParameterToList('DOCUMENT_ID', i_document_number);
2587: l_event.addParameterToList('PROCESS_ID', l_process_id);
2588: l_event.addParameterToList('MAP_CODE', i_map_id);
2589: l_event.addParameterToList('ORG_ID', ecx_utils.g_org_id);
2590: l_event.addParameterToList('SENDER_TP_ID', ecx_utils.g_snd_tp_id);
2591: l_event.addParameterToList('RECV_TP_ID', i_rcv_tp_id);
2592: l_event.addParameterToList('MAP_CODE', i_map_id);
2593: l_event.addParameterToList('LOGFILE', ecx_utils.g_logfile);
2586: l_event.addParameterToList('DOCUMENT_ID', i_document_number);
2587: l_event.addParameterToList('PROCESS_ID', l_process_id);
2588: l_event.addParameterToList('MAP_CODE', i_map_id);
2589: l_event.addParameterToList('ORG_ID', ecx_utils.g_org_id);
2590: l_event.addParameterToList('SENDER_TP_ID', ecx_utils.g_snd_tp_id);
2591: l_event.addParameterToList('RECV_TP_ID', i_rcv_tp_id);
2592: l_event.addParameterToList('MAP_CODE', i_map_id);
2593: l_event.addParameterToList('LOGFILE', ecx_utils.g_logfile);
2594: l_event.addParameterToList('STANDARD_ID', ecx_utils.g_standard_id);
2589: l_event.addParameterToList('ORG_ID', ecx_utils.g_org_id);
2590: l_event.addParameterToList('SENDER_TP_ID', ecx_utils.g_snd_tp_id);
2591: l_event.addParameterToList('RECV_TP_ID', i_rcv_tp_id);
2592: l_event.addParameterToList('MAP_CODE', i_map_id);
2593: l_event.addParameterToList('LOGFILE', ecx_utils.g_logfile);
2594: l_event.addParameterToList('STANDARD_ID', ecx_utils.g_standard_id);
2595: l_event.addParameterToList('ITEM_TYPE', ecx_utils.g_item_type);
2596: l_event.addParameterToList('ITEM_KEY', ecx_utils.g_item_key);
2597: l_event.addParameterToList('ACTIVITY_ID', ecx_utils.g_activity_id);
2590: l_event.addParameterToList('SENDER_TP_ID', ecx_utils.g_snd_tp_id);
2591: l_event.addParameterToList('RECV_TP_ID', i_rcv_tp_id);
2592: l_event.addParameterToList('MAP_CODE', i_map_id);
2593: l_event.addParameterToList('LOGFILE', ecx_utils.g_logfile);
2594: l_event.addParameterToList('STANDARD_ID', ecx_utils.g_standard_id);
2595: l_event.addParameterToList('ITEM_TYPE', ecx_utils.g_item_type);
2596: l_event.addParameterToList('ITEM_KEY', ecx_utils.g_item_key);
2597: l_event.addParameterToList('ACTIVITY_ID', ecx_utils.g_activity_id);
2598: l_event.addParameterToList('NO_ROUTING', i_no_routing);
2591: l_event.addParameterToList('RECV_TP_ID', i_rcv_tp_id);
2592: l_event.addParameterToList('MAP_CODE', i_map_id);
2593: l_event.addParameterToList('LOGFILE', ecx_utils.g_logfile);
2594: l_event.addParameterToList('STANDARD_ID', ecx_utils.g_standard_id);
2595: l_event.addParameterToList('ITEM_TYPE', ecx_utils.g_item_type);
2596: l_event.addParameterToList('ITEM_KEY', ecx_utils.g_item_key);
2597: l_event.addParameterToList('ACTIVITY_ID', ecx_utils.g_activity_id);
2598: l_event.addParameterToList('NO_ROUTING', i_no_routing);
2599: wf_event.raise( P_EVENT_NAME=>l_event_name , P_EVENT_KEY => l_event_key, p_event_data =>i_payload ,p_parameters => l_event.getparameterlist());
2592: l_event.addParameterToList('MAP_CODE', i_map_id);
2593: l_event.addParameterToList('LOGFILE', ecx_utils.g_logfile);
2594: l_event.addParameterToList('STANDARD_ID', ecx_utils.g_standard_id);
2595: l_event.addParameterToList('ITEM_TYPE', ecx_utils.g_item_type);
2596: l_event.addParameterToList('ITEM_KEY', ecx_utils.g_item_key);
2597: l_event.addParameterToList('ACTIVITY_ID', ecx_utils.g_activity_id);
2598: l_event.addParameterToList('NO_ROUTING', i_no_routing);
2599: wf_event.raise( P_EVENT_NAME=>l_event_name , P_EVENT_KEY => l_event_key, p_event_data =>i_payload ,p_parameters => l_event.getparameterlist());
2600: ecx_debug.setErrorInfo(10, 10, 'Event(key:'||l_event_key ||') has been raised for messgae processing at java layer');
2593: l_event.addParameterToList('LOGFILE', ecx_utils.g_logfile);
2594: l_event.addParameterToList('STANDARD_ID', ecx_utils.g_standard_id);
2595: l_event.addParameterToList('ITEM_TYPE', ecx_utils.g_item_type);
2596: l_event.addParameterToList('ITEM_KEY', ecx_utils.g_item_key);
2597: l_event.addParameterToList('ACTIVITY_ID', ecx_utils.g_activity_id);
2598: l_event.addParameterToList('NO_ROUTING', i_no_routing);
2599: wf_event.raise( P_EVENT_NAME=>l_event_name , P_EVENT_KEY => l_event_key, p_event_data =>i_payload ,p_parameters => l_event.getparameterlist());
2600: ecx_debug.setErrorInfo(10, 10, 'Event(key:'||l_event_key ||') has been raised for messgae processing at java layer');
2601: end raiseEvent;