[Home] [Help]
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,
448: ecx_inbound.process_xml_doc (i_doc,i_map_id, i_header_id, i_rcv_tp_id,
449: i_xmldoc, l_parseXML);
450: end if;
451:
452: xmlparser.freeparser(ecx_utils.g_parser);
453: if(ecx_utils.dom_printing = false and ecx_utils.structure_printing = true) -- xmltoxml different dtds.
454: then
455: xmlparser.freeparser(ecx_utils.g_inb_parser);
456: end if;
449: i_xmldoc, l_parseXML);
450: end if;
451:
452: xmlparser.freeparser(ecx_utils.g_parser);
453: if(ecx_utils.dom_printing = false and ecx_utils.structure_printing = true) -- xmltoxml different dtds.
454: then
455: xmlparser.freeparser(ecx_utils.g_inb_parser);
456: end if;
457:
451:
452: xmlparser.freeparser(ecx_utils.g_parser);
453: if(ecx_utils.dom_printing = false and ecx_utils.structure_printing = true) -- xmltoxml different dtds.
454: then
455: xmlparser.freeparser(ecx_utils.g_inb_parser);
456: end if;
457:
458: if (ecx_utils.dom_printing or (ecx_utils.structure_printing and l_parseXML)) then
459: if(l_statementEnabled) then
454: then
455: xmlparser.freeparser(ecx_utils.g_inb_parser);
456: end if;
457:
458: if (ecx_utils.dom_printing or (ecx_utils.structure_printing and l_parseXML)) then
459: if(l_statementEnabled) then
460: ecx_debug.log(l_statement,'XML is validated by the parser.',i_method_name);
461: end if;
462: writeXMLToFile(i_xmldoc);
461: end if;
462: writeXMLToFile(i_xmldoc);
463:
464: begin
465: if not xmlDOM.isNull(ecx_utils.g_xmldoc) then
466: xmlDOM.freeDocument(xmlDOM.makeDocument(ecx_utils.g_xmldoc));
467: end if;
468: exception
469: when others then
462: writeXMLToFile(i_xmldoc);
463:
464: begin
465: if not xmlDOM.isNull(ecx_utils.g_xmldoc) then
466: xmlDOM.freeDocument(xmlDOM.makeDocument(ecx_utils.g_xmldoc));
467: end if;
468: exception
469: when others then
470: null;
474: ecx_debug.log(l_statement,'XML is not validated by the parser.',i_method_name);
475: end if;
476: end if;
477: --for bug 5609625
478: xmlparser.freeparser(ecx_utils.g_parser);
479: if(ecx_utils.dom_printing = false and ecx_utils.structure_printing = true) -- xmltoxml different dtds.
480: then
481: xmlparser.freeparser(ecx_utils.g_inb_parser);
482: end if;
475: end if;
476: end if;
477: --for bug 5609625
478: xmlparser.freeparser(ecx_utils.g_parser);
479: if(ecx_utils.dom_printing = false and ecx_utils.structure_printing = true) -- xmltoxml different dtds.
480: then
481: xmlparser.freeparser(ecx_utils.g_inb_parser);
482: end if;
483: ---end of 5609625
477: --for bug 5609625
478: xmlparser.freeparser(ecx_utils.g_parser);
479: if(ecx_utils.dom_printing = false and ecx_utils.structure_printing = true) -- xmltoxml different dtds.
480: then
481: xmlparser.freeparser(ecx_utils.g_inb_parser);
482: end if;
483: ---end of 5609625
484:
485: if (l_procedureEnabled) then
486: ecx_debug.pop(i_method_name);
487: end if;
488:
489: exception
490: when ecx_utils.program_exit then
491: if (l_procedureEnabled) then
492: ecx_debug.pop(i_method_name);
493: end if;
494: if(l_unexpectedEnabled) then
496: end if;
497: ecx_print_local.last_printed := -1;
498:
499: begin
500: if not xmlDOM.isNull(ecx_utils.g_xmldoc) then
501: xmlDOM.freeDocument(xmlDOM.makeDocument(ecx_utils.g_xmldoc));
502: end if;
503: exception
504: when others then
497: ecx_print_local.last_printed := -1;
498:
499: begin
500: if not xmlDOM.isNull(ecx_utils.g_xmldoc) then
501: xmlDOM.freeDocument(xmlDOM.makeDocument(ecx_utils.g_xmldoc));
502: end if;
503: exception
504: when others then
505: null;
503: exception
504: when others then
505: null;
506: end;
507: raise ecx_utils.program_exit;
508:
509: when others then
510: ecx_debug.setErrorInfo(1,20,SQLERRM||' - ECX_INBOUND_TRIG.processXMLData ');
511: if(l_unexpectedEnabled) then
508:
509: when others then
510: ecx_debug.setErrorInfo(1,20,SQLERRM||' - ECX_INBOUND_TRIG.processXMLData ');
511: if(l_unexpectedEnabled) then
512: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
513: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
514: ecx_debug.log(l_unexpected,'Clean-up last_printed',i_method_name);
515: end if;
516: ecx_print_local.last_printed := -1;
509: when others then
510: ecx_debug.setErrorInfo(1,20,SQLERRM||' - ECX_INBOUND_TRIG.processXMLData ');
511: if(l_unexpectedEnabled) then
512: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
513: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
514: ecx_debug.log(l_unexpected,'Clean-up last_printed',i_method_name);
515: end if;
516: ecx_print_local.last_printed := -1;
517: if (l_procedureEnabled) then
518: ecx_debug.pop(i_method_name);
519: end if;
520:
521: begin
522: if not xmlDOM.isNull(ecx_utils.g_xmldoc) then
523: xmlDOM.freeDocument(xmlDOM.makeDocument(ecx_utils.g_xmldoc));
524: end if;
525: exception
526: when others then
519: end if;
520:
521: begin
522: if not xmlDOM.isNull(ecx_utils.g_xmldoc) then
523: xmlDOM.freeDocument(xmlDOM.makeDocument(ecx_utils.g_xmldoc));
524: end if;
525: exception
526: when others then
527: null;
525: exception
526: when others then
527: null;
528: end;
529: raise ecx_utils.program_exit;
530: end processXMLData;
531:
532: procedure validate_message
533: (
635: ecx_debug.log(l_statement,'m_party_ext_code',m_party_ext_code,i_method_name);
636: ecx_debug.log(l_statement,'m_document_number',m_document_number,i_method_name);
637: ecx_debug.log(l_statement,'m_routing_ext_code',m_routing_ext_code,i_method_name);
638: end if;
639: ecx_utils.i_ret_code :=0;
640: ecx_utils.i_errbuf :=null;
641: --MLS
642: ecx_utils.i_errparams := null;
643: ecx_utils.g_ret_code := 0;
636: ecx_debug.log(l_statement,'m_document_number',m_document_number,i_method_name);
637: ecx_debug.log(l_statement,'m_routing_ext_code',m_routing_ext_code,i_method_name);
638: end if;
639: ecx_utils.i_ret_code :=0;
640: ecx_utils.i_errbuf :=null;
641: --MLS
642: ecx_utils.i_errparams := null;
643: ecx_utils.g_ret_code := 0;
644:
638: end if;
639: ecx_utils.i_ret_code :=0;
640: ecx_utils.i_errbuf :=null;
641: --MLS
642: ecx_utils.i_errparams := null;
643: ecx_utils.g_ret_code := 0;
644:
645: --Check whether the Document has been enabled in the Exchange Server.
646: --If yes get the Map Id.
639: ecx_utils.i_ret_code :=0;
640: ecx_utils.i_errbuf :=null;
641: --MLS
642: ecx_utils.i_errparams := null;
643: ecx_utils.g_ret_code := 0;
644:
645: --Check whether the Document has been enabled in the Exchange Server.
646: --If yes get the Map Id.
647: open c_tp_details ( m_ext_type, m_ext_subtype,m_party_ext_code,m_message_standard, m_message_type);
672: m_party_ext_code);
673: end if;
674:
675: close c_tp_details;
676: raise ecx_utils.program_exit;
677: end if;
678:
679: close c_tp_details;
680: -- Set the Sender's tp_id
677: end if;
678:
679: close c_tp_details;
680: -- Set the Sender's tp_id
681: ecx_utils.g_snd_tp_id := i_header_id;
682: if(l_statementEnabled) then
683: ecx_debug.log(l_statement,'i_map_id',i_map_id,i_method_name);
684: ecx_debug.log(l_statement,'i_routing_id',i_routing_id,i_method_name);
685: ecx_debug.log(l_statement,'i_header_id',i_header_id,i_method_name);
687: end if;
688:
689: 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
690: ecx_debug.setErrorInfo(2, 25, 'ECX_ROUTING_NOT_SUPPORTED');
691: raise ecx_utils.program_exit;
692: end if;
693: end if;
694:
695: --Call the Send and Receive TP Id api's over here
731: m_party_ext_code);
732: end if;
733:
734: close get_routing_for_extcode;
735: raise ecx_utils.program_exit;
736: end if;
737:
738: close get_routing_for_extcode;
739:
765: end if;
766:
767:
768: close get_receiver_tp_id;
769: raise ecx_utils.program_exit;
770: end if;
771: close get_receiver_tp_id;
772: if(l_statementEnabled) then
773: ecx_debug.log(l_statement,'Static Routing',i_method_name);
773: ecx_debug.log(l_statement,'Static Routing',i_method_name);
774: end if;
775:
776: end if;
777: ecx_utils.g_rec_tp_id := i_rcv_tp_id;
778: if(l_statementEnabled) then
779: ecx_debug.log(l_statement,'Receiver Tp Id ',i_rcv_tp_id,i_method_name);
780: end if;
781:
814: m_party_ext_code);
815: end if;
816:
817: close get_routing_for_extcode;
818: raise ecx_utils.program_exit;
819: end if;
820: close get_routing_for_extcode;
821: else
822: -- if neither static nor dynamic routing is specified.
826:
827: if (i_map_type = 2) then
828: -- Only if map is xml to xml or dtd to dtd type
829: -- Give warning message.
830: ecx_utils.g_ret_code := 1;
831: if(l_statementEnabled) then
832: ecx_debug.log(l_statement,'ecx_utils.g_ret_code',' 1',i_method_name);
833: end if;
834: end if;
828: -- Only if map is xml to xml or dtd to dtd type
829: -- Give warning message.
830: ecx_utils.g_ret_code := 1;
831: if(l_statementEnabled) then
832: ecx_debug.log(l_statement,'ecx_utils.g_ret_code',' 1',i_method_name);
833: end if;
834: end if;
835: end if;
836: end if;
836: end if;
837:
838: -- need to set the g_routing_id here, so that it would set it
839: -- for both dynamic and static routing.
840: ecx_utils.g_routing_id := i_routing_id;
841: if(l_statementEnabled) then
842: ecx_debug.log(l_statement,'ecx_utils.g_routing_id',ecx_utils.g_routing_id,
843: i_method_name);
844: end if;
838: -- need to set the g_routing_id here, so that it would set it
839: -- for both dynamic and static routing.
840: ecx_utils.g_routing_id := i_routing_id;
841: if(l_statementEnabled) then
842: ecx_debug.log(l_statement,'ecx_utils.g_routing_id',ecx_utils.g_routing_id,
843: i_method_name);
844: end if;
845:
846: /**
845:
846: /**
847: Since we have the sender tp_id , we can call the senders_tp_info and populate the org_id
848: **/
849: if ( ecx_utils.g_snd_tp_id is not null )
850: then
851: null;
852: ecx_trading_partner_pvt.get_tp_info
853: (
850: then
851: null;
852: ecx_trading_partner_pvt.get_tp_info
853: (
854: ecx_utils.g_snd_tp_id,
855: p_party_id,
856: p_party_site_id,
857: ecx_utils.g_org_id,
858: p_admin_email,
853: (
854: ecx_utils.g_snd_tp_id,
855: p_party_id,
856: p_party_site_id,
857: ecx_utils.g_org_id,
858: p_admin_email,
859: retcode,
860: retmsg
861: );
903: (
904: m_msgid,
905: null,
906: 'Inbound processing complete.',
907: ecx_utils.g_logfile,
908: null
909: );
910: end if;
911:
916: if (l_procedureEnabled) then
917: ecx_debug.pop(i_method_name);
918: end if;
919: exception
920: when ecx_utils.program_exit then
921: --ecx_utils.g_map_id := -1;
922: if (l_procedureEnabled) then
923: ecx_debug.pop(i_method_name);
924: end if;
917: ecx_debug.pop(i_method_name);
918: end if;
919: exception
920: when ecx_utils.program_exit then
921: --ecx_utils.g_map_id := -1;
922: if (l_procedureEnabled) then
923: ecx_debug.pop(i_method_name);
924: end if;
925:
926: if o_payload is not null
927: then
928: dbms_lob.freetemporary (o_payload);
929: end if;
930: raise ecx_utils.program_exit;
931: when others then
932: --ecx_utils.g_map_id := -1;
933: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_INBOUND_TRIG.VALIDATE_MESSAGE ');
934: if(l_unexpectedEnabled) then
928: dbms_lob.freetemporary (o_payload);
929: end if;
930: raise ecx_utils.program_exit;
931: when others then
932: --ecx_utils.g_map_id := -1;
933: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_INBOUND_TRIG.VALIDATE_MESSAGE ');
934: if(l_unexpectedEnabled) then
935: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
936: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
931: when others then
932: --ecx_utils.g_map_id := -1;
933: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_INBOUND_TRIG.VALIDATE_MESSAGE ');
934: if(l_unexpectedEnabled) then
935: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
936: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
937: end if;
938:
939: if o_payload is not null
932: --ecx_utils.g_map_id := -1;
933: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_INBOUND_TRIG.VALIDATE_MESSAGE ');
934: if(l_unexpectedEnabled) then
935: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
936: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
937: end if;
938:
939: if o_payload is not null
940: then
942: end if;
943: if (l_procedureEnabled) then
944: ecx_debug.pop(i_method_name);
945: end if;
946: raise ecx_utils.program_exit;
947: end validate_message;
948:
949:
950: procedure getmsg_from_queue
1035: elsif (l_retcode >= 2 ) then
1036: if(l_unexpectedEnabled) then
1037: ecx_debug.log(l_unexpected,l_retmsg,i_method_name);
1038: end if;
1039: raise ecx_utils.program_exit;
1040: end if;
1041: end;
1042: if(l_statementEnabled) then
1043: ecx_debug.log(l_statement,'MessageId', i_msgid,i_method_name);
1050: if (l_procedureEnabled) then
1051: ecx_debug.pop(i_method_name);
1052: end if;
1053: exception
1054: when ecx_utils.program_exit then
1055: raise;
1056: when others then
1057: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_INBOUND_TRIG.GETMSG_FROM_QUEUE');
1058: if(l_unexpectedEnabled) then
1055: raise;
1056: when others then
1057: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_INBOUND_TRIG.GETMSG_FROM_QUEUE');
1058: if(l_unexpectedEnabled) then
1059: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
1060: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1061: end if;
1062: raise ecx_utils.program_exit;
1063: end getmsg_from_queue;
1056: when others then
1057: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_INBOUND_TRIG.GETMSG_FROM_QUEUE');
1058: if(l_unexpectedEnabled) then
1059: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
1060: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1061: end if;
1062: raise ecx_utils.program_exit;
1063: end getmsg_from_queue;
1064:
1058: if(l_unexpectedEnabled) then
1059: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
1060: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1061: end if;
1062: raise ecx_utils.program_exit;
1063: end getmsg_from_queue;
1064:
1065:
1066: procedure put_on_outbound
1154: and etd.tp_header_id = eth.tp_header_id;
1155: exception
1156: when others then
1157: ecx_debug.setErrorInfo(1,25,'ECX_NO_UNIQUE_TP_SETUP');
1158: raise ecx_utils.program_exit;
1159: end;
1160:
1161: if i_hub_user_id is not null
1162: then
1177: and ehu.hub_user_id = i_hub_user_id;
1178: exception
1179: when others then
1180: ecx_debug.setErrorInfo(1,25,'ECX_DELIVERY_HUB_NOT_SETUP');
1181: raise ecx_utils.program_exit;
1182: end;
1183: end if;
1184:
1185: if i_destination_address is null
1189: 'p_transaction_type', i_ext_type,
1190: 'p_transaction_subtype', i_ext_subtype,
1191: 'p_standard', i_standard_code);
1192:
1193: raise ecx_utils.program_exit;
1194: end if;
1195: if (l_statementEnabled) then
1196: ecx_debug.log(l_statement,'i_standard_type',i_standard_type,i_method_name);
1197: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
1225: i_event.addParameterToList('PROTOCOL_TYPE', i_destination_type);
1226: i_event.addParameterToList('PROTOCOL_ADDRESS', i_destination_address);
1227: i_event.addParameterToList('USERNAME', i_username);
1228: i_event.addParameterToList('PASSWORD', i_password);
1229: i_event.addParameterToList('ATTRIBUTE1', ecx_utils.g_company_name);
1230: i_event.addParameterToList('ATTRIBUTE2', null);
1231: i_event.addParameterToList('ATTRIBUTE3', i_destination_code);
1232: i_event.addParameterToList('ATTRIBUTE4', null);
1233: i_event.addParameterToList('ATTRIBUTE5', null);
1230: i_event.addParameterToList('ATTRIBUTE2', null);
1231: i_event.addParameterToList('ATTRIBUTE3', i_destination_code);
1232: i_event.addParameterToList('ATTRIBUTE4', null);
1233: i_event.addParameterToList('ATTRIBUTE5', null);
1234: i_event.addParameterToList('DIRECTION', ecx_utils.g_direction);
1235: i_event.addParameterToList('LOGFILE', ecx_utils.g_logfile);
1236: i_event.addParameterToList('ECX_MSG_ID', i_msgid);
1237:
1238: i_event.event_data := i_xmldoc;
1231: i_event.addParameterToList('ATTRIBUTE3', i_destination_code);
1232: i_event.addParameterToList('ATTRIBUTE4', null);
1233: i_event.addParameterToList('ATTRIBUTE5', null);
1234: i_event.addParameterToList('DIRECTION', ecx_utils.g_direction);
1235: i_event.addParameterToList('LOGFILE', ecx_utils.g_logfile);
1236: i_event.addParameterToList('ECX_MSG_ID', i_msgid);
1237:
1238: i_event.event_data := i_xmldoc;
1239:
1259: -- check the retcode and retmsg. This should be populated here only
1260: -- in the case of dup val index when inserting in doclogs (since no
1261: -- exception is raised in this case)
1262: if (ecx_out_wf_qh.retmsg is not null) then
1263: --ecx_utils.error_type := 30;
1264: --ecx_utils.i_ret_code := ecx_out_wf_qh.retcode;
1265: --ecx_utils.i_errbuf := ecx_out_wf_qh.retmsg;
1266: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);
1267: if(l_statementEnabled) then
1260: -- in the case of dup val index when inserting in doclogs (since no
1261: -- exception is raised in this case)
1262: if (ecx_out_wf_qh.retmsg is not null) then
1263: --ecx_utils.error_type := 30;
1264: --ecx_utils.i_ret_code := ecx_out_wf_qh.retcode;
1265: --ecx_utils.i_errbuf := ecx_out_wf_qh.retmsg;
1266: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);
1267: if(l_statementEnabled) then
1268: ecx_debug.log(l_statement,ecx_debug.getMessage(ecx_utils.i_errbuf,
1261: -- exception is raised in this case)
1262: if (ecx_out_wf_qh.retmsg is not null) then
1263: --ecx_utils.error_type := 30;
1264: --ecx_utils.i_ret_code := ecx_out_wf_qh.retcode;
1265: --ecx_utils.i_errbuf := ecx_out_wf_qh.retmsg;
1266: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);
1267: if(l_statementEnabled) then
1268: ecx_debug.log(l_statement,ecx_debug.getMessage(ecx_utils.i_errbuf,
1269: ecx_utils.i_errparams),i_method_name); -- MLS
1264: --ecx_utils.i_ret_code := ecx_out_wf_qh.retcode;
1265: --ecx_utils.i_errbuf := ecx_out_wf_qh.retmsg;
1266: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);
1267: if(l_statementEnabled) then
1268: ecx_debug.log(l_statement,ecx_debug.getMessage(ecx_utils.i_errbuf,
1269: ecx_utils.i_errparams),i_method_name); -- MLS
1270: end if;
1271: end if;
1272:
1265: --ecx_utils.i_errbuf := ecx_out_wf_qh.retmsg;
1266: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);
1267: if(l_statementEnabled) then
1268: ecx_debug.log(l_statement,ecx_debug.getMessage(ecx_utils.i_errbuf,
1269: ecx_utils.i_errparams),i_method_name); -- MLS
1270: end if;
1271: end if;
1272:
1273: if(l_statementEnabled) then
1276: if (l_procedureEnabled) then
1277: ecx_debug.pop(i_method_name);
1278: end if;
1279: exception
1280: WHEN ECX_UTILS.PROGRAM_EXIT THEN
1281: --dbms_lob.freetemporary(i_xmldoc);
1282: if (l_procedureEnabled) then
1283: ecx_debug.pop(i_method_name);
1284: end if;
1281: --dbms_lob.freetemporary(i_xmldoc);
1282: if (l_procedureEnabled) then
1283: ecx_debug.pop(i_method_name);
1284: end if;
1285: raise ecx_utils.program_exit;
1286: when others then
1287: --dbms_lob.freetemporary(i_xmldoc);
1288: if (ecx_out_wf_qh.retmsg is null AND ecx_out_wf_qh.retcode = 0)
1289: then
1288: if (ecx_out_wf_qh.retmsg is null AND ecx_out_wf_qh.retcode = 0)
1289: then
1290: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.PUT_ON_OUTBOUND');
1291: else
1292: --ecx_utils.i_ret_code := ecx_out_wf_qh.retcode;
1293: --ecx_utils.i_errbuf := ecx_out_wf_qh.retmsg;
1294: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);
1295: end if;
1296: --ecx_utils.error_type := 30;
1289: then
1290: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.PUT_ON_OUTBOUND');
1291: else
1292: --ecx_utils.i_ret_code := ecx_out_wf_qh.retcode;
1293: --ecx_utils.i_errbuf := ecx_out_wf_qh.retmsg;
1294: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);
1295: end if;
1296: --ecx_utils.error_type := 30;
1297: if(l_unexpectedEnabled) then
1292: --ecx_utils.i_ret_code := ecx_out_wf_qh.retcode;
1293: --ecx_utils.i_errbuf := ecx_out_wf_qh.retmsg;
1294: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);
1295: end if;
1296: --ecx_utils.error_type := 30;
1297: if(l_unexpectedEnabled) then
1298: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,
1299: ecx_utils.i_errparams),i_method_name); -- MLS
1300: end if;
1294: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);
1295: end if;
1296: --ecx_utils.error_type := 30;
1297: if(l_unexpectedEnabled) then
1298: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,
1299: ecx_utils.i_errparams),i_method_name); -- MLS
1300: end if;
1301: raise ecx_utils.program_exit;
1302: end put_on_outbound;
1295: end if;
1296: --ecx_utils.error_type := 30;
1297: if(l_unexpectedEnabled) then
1298: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,
1299: ecx_utils.i_errparams),i_method_name); -- MLS
1300: end if;
1301: raise ecx_utils.program_exit;
1302: end put_on_outbound;
1303:
1297: if(l_unexpectedEnabled) then
1298: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,
1299: ecx_utils.i_errparams),i_method_name); -- MLS
1300: end if;
1301: raise ecx_utils.program_exit;
1302: end put_on_outbound;
1303:
1304: /**
1305: Old put_on_outbound - pre BES integration
1381:
1382: exception
1383: when others then
1384: ecx_debug.setErrorInfo(1,25,'ECX_NO_UNIQUE_TP_SETUP');
1385: raise ecx_utils.program_exit;
1386: end;
1387:
1388: if i_hub_user_id is not null
1389: then
1408: ecx_debug.setErrorInfo(1,25,'ECX_DELIVERY_HUB_NOT_SETUP');
1409: if(l_unexpectedEnabled) then
1410: ecx_debug.log(l_unexpected,'ERROR', SQLERRM,i_method_name);
1411: end if;
1412: raise ecx_utils.program_exit;
1413: end;
1414: end if;
1415:
1416:
1420: 'p_tp_location_code', i_source_code,
1421: 'p_transaction_type', i_ext_type,
1422: 'p_transaction_subtype', i_ext_subtype,
1423: 'p_standard', i_standard_code);
1424: raise ecx_utils.program_exit;
1425: end if;
1426:
1427: ecx_obfuscate.ecx_data_encrypt
1428: (
1434: );
1435:
1436: if (o_retcode > 0)
1437: then
1438: --ecx_utils.i_ret_code := o_retcode;
1439: --ecx_utils.i_errbuf := o_retmsg;
1440: --ecx_utils.error_type := 30;
1441: ecx_debug.setErrorInfo(o_retcode,30,o_retmsg);
1442: raise ecx_utils.program_exit;
1435:
1436: if (o_retcode > 0)
1437: then
1438: --ecx_utils.i_ret_code := o_retcode;
1439: --ecx_utils.i_errbuf := o_retmsg;
1440: --ecx_utils.error_type := 30;
1441: ecx_debug.setErrorInfo(o_retcode,30,o_retmsg);
1442: raise ecx_utils.program_exit;
1443: end if;
1436: if (o_retcode > 0)
1437: then
1438: --ecx_utils.i_ret_code := o_retcode;
1439: --ecx_utils.i_errbuf := o_retmsg;
1440: --ecx_utils.error_type := 30;
1441: ecx_debug.setErrorInfo(o_retcode,30,o_retmsg);
1442: raise ecx_utils.program_exit;
1443: end if;
1444: if(l_statementEnabled) then
1438: --ecx_utils.i_ret_code := o_retcode;
1439: --ecx_utils.i_errbuf := o_retmsg;
1440: --ecx_utils.error_type := 30;
1441: ecx_debug.setErrorInfo(o_retcode,30,o_retmsg);
1442: raise ecx_utils.program_exit;
1443: end if;
1444: if(l_statementEnabled) then
1445: ecx_debug.log(l_statement,'i_standard_type',i_standard_type,i_method_name);
1446: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
1468: i_destination_address,
1469: i_username,
1470: m_password,
1471: i_xmldoc,
1472: ecx_utils.g_company_name,
1473: null,
1474: i_destination_code,
1475: null,
1476: null
1485: and etd.tp_detail_id = i_tp_detail_id;
1486: exception
1487: when others then
1488: ecx_debug.setErrorInfo(1,30, SQLERRM);
1489: raise ecx_utils.program_exit;
1490: end;
1491:
1492: v_message.party_type := i_party_type;
1493:
1538: elsif (l_retcode >= 2 ) then
1539: if(l_unexpectedEnabled) then
1540: ecx_debug.log(l_unexpected, l_retmsg,i_method_name);
1541: end if;
1542: raise ecx_utils.program_exit;
1543: end if;
1544: end;
1545:
1546: -- maintain attachment mappings if this is a passthrough case
1552: if (l_procedureEnabled) then
1553: ecx_debug.pop(i_method_name);
1554: end if;
1555: exception
1556: WHEN ECX_UTILS.PROGRAM_EXIT THEN
1557: i_hub_user_id := null;
1558: if (l_procedureEnabled) then
1559: ecx_debug.pop(i_method_name);
1560: end if;
1557: i_hub_user_id := null;
1558: if (l_procedureEnabled) then
1559: ecx_debug.pop(i_method_name);
1560: end if;
1561: raise ecx_utils.program_exit;
1562: when others then
1563: i_hub_user_id := null;
1564: ecx_debug.setErrorInfo(2,30, SQLERRM|| ' - ECX_INBOUND_TRIG.PUT_ON_OUTBOUND');
1565: if(l_unexpectedEnabled) then
1562: when others then
1563: i_hub_user_id := null;
1564: ecx_debug.setErrorInfo(2,30, SQLERRM|| ' - ECX_INBOUND_TRIG.PUT_ON_OUTBOUND');
1565: if(l_unexpectedEnabled) then
1566: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
1567: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1568: end if;
1569: raise ecx_utils.program_exit;
1570: end put_on_outbound;
1563: i_hub_user_id := null;
1564: ecx_debug.setErrorInfo(2,30, SQLERRM|| ' - ECX_INBOUND_TRIG.PUT_ON_OUTBOUND');
1565: if(l_unexpectedEnabled) then
1566: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
1567: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1568: end if;
1569: raise ecx_utils.program_exit;
1570: end put_on_outbound;
1571:
1565: if(l_unexpectedEnabled) then
1566: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
1567: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1568: end if;
1569: raise ecx_utils.program_exit;
1570: end put_on_outbound;
1571:
1572: --This is for Internal testing and Debugging Only. Takes the Message
1573: --off from the given Queue in the Browse Mode and processes it.
1603: end if;
1604: -- /logging enabled
1605:
1606: IF (ecx_logging_enabled ) THEN
1607: ecx_utils.getLogDirectory;
1608: ecx_debug.enable_debug_new(i_debug_level,ecx_utils.g_logdir, 'IN'||i_queue_name||'.log', 'in.'||i_queue_name||'.log');
1609: END IF;
1610:
1611: /* Assign local variables with the ecx_debug global variables*/
1604: -- /logging enabled
1605:
1606: IF (ecx_logging_enabled ) THEN
1607: ecx_utils.getLogDirectory;
1608: ecx_debug.enable_debug_new(i_debug_level,ecx_utils.g_logdir, 'IN'||i_queue_name||'.log', 'in.'||i_queue_name||'.log');
1609: END IF;
1610:
1611: /* Assign local variables with the ecx_debug global variables*/
1612: l_procedure := ecx_debug.g_procedure;
1637: ecx_debug.disable_debug;
1638: END IF;
1639:
1640: exception
1641: when ecx_utils.program_exit then
1642: if(l_unexpectedEnabled) then
1643: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1644: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1645: end if;
1639:
1640: exception
1641: when ecx_utils.program_exit then
1642: if(l_unexpectedEnabled) then
1643: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1644: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1645: end if;
1646: IF (ecx_logging_enabled ) THEN
1647: ecx_debug.print_log;
1640: exception
1641: when ecx_utils.program_exit then
1642: if(l_unexpectedEnabled) then
1643: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1644: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1645: end if;
1646: IF (ecx_logging_enabled ) THEN
1647: ecx_debug.print_log;
1648: ecx_debug.disable_debug;
1647: ecx_debug.print_log;
1648: ecx_debug.disable_debug;
1649: END IF;
1650: when others then
1651: ecx_utils.i_errbuf := SQLERRM || ' - ECX_INBOUND_TRIG.PROCESSMSG_FROM_QUEUE';
1652: if(l_unexpectedEnabled) then
1653: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1654: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1655: end if;
1649: END IF;
1650: when others then
1651: ecx_utils.i_errbuf := SQLERRM || ' - ECX_INBOUND_TRIG.PROCESSMSG_FROM_QUEUE';
1652: if(l_unexpectedEnabled) then
1653: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1654: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1655: end if;
1656: IF (ecx_logging_enabled ) THEN
1657: ecx_debug.print_log;
1650: when others then
1651: ecx_utils.i_errbuf := SQLERRM || ' - ECX_INBOUND_TRIG.PROCESSMSG_FROM_QUEUE';
1652: if(l_unexpectedEnabled) then
1653: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1654: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1655: end if;
1656: IF (ecx_logging_enabled ) THEN
1657: ecx_debug.print_log;
1658: ecx_debug.disable_debug;
1688: -- /logging enabled
1689:
1690: IF (ecx_logging_enabled ) THEN
1691: --get the Log directory from the Profile Option.
1692: ecx_utils.getLogDirectory;
1693: ecx_debug.enable_debug_new(i_debug_level, ecx_utils.g_logdir, 'IN' ||i_msgid||'.log', 'in.'||i_msgid||'.log');
1694: END IF;
1695:
1696: /* Assign local variables with the ecx_debug global variables*/
1689:
1690: IF (ecx_logging_enabled ) THEN
1691: --get the Log directory from the Profile Option.
1692: ecx_utils.getLogDirectory;
1693: ecx_debug.enable_debug_new(i_debug_level, ecx_utils.g_logdir, 'IN' ||i_msgid||'.log', 'in.'||i_msgid||'.log');
1694: END IF;
1695:
1696: /* Assign local variables with the ecx_debug global variables*/
1697: l_procedure := ecx_debug.g_procedure;
1721: ecx_debug.disable_debug;
1722: END IF;
1723:
1724: exception
1725: when ecx_utils.program_exit then
1726: if(l_unexpectedEnabled) then
1727: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1728: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1729: end if;
1723:
1724: exception
1725: when ecx_utils.program_exit then
1726: if(l_unexpectedEnabled) then
1727: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1728: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1729: end if;
1730: IF (ecx_logging_enabled ) THEN
1731: ecx_debug.print_log;
1724: exception
1725: when ecx_utils.program_exit then
1726: if(l_unexpectedEnabled) then
1727: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1728: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1729: end if;
1730: IF (ecx_logging_enabled ) THEN
1731: ecx_debug.print_log;
1732: ecx_debug.disable_debug;
1732: ecx_debug.disable_debug;
1733: END IF;
1734:
1735: when others then
1736: ecx_utils.i_errbuf := SQLERRM || ' - ECX_INBOUND_TRIG.PROCESSMSG_FROM_TABLE';
1737: if(l_unexpectedEnabled) then
1738: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1739: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1740: end if;
1734:
1735: when others then
1736: ecx_utils.i_errbuf := SQLERRM || ' - ECX_INBOUND_TRIG.PROCESSMSG_FROM_TABLE';
1737: if(l_unexpectedEnabled) then
1738: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1739: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1740: end if;
1741:
1742: IF (ecx_logging_enabled ) THEN
1735: when others then
1736: ecx_utils.i_errbuf := SQLERRM || ' - ECX_INBOUND_TRIG.PROCESSMSG_FROM_TABLE';
1737: if(l_unexpectedEnabled) then
1738: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1739: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1740: end if;
1741:
1742: IF (ecx_logging_enabled ) THEN
1743: ecx_debug.print_log;
1819: raise msg_not_found;
1820: end if;
1821:
1822: close get_msg;
1823: ecx_utils.g_direction := 'IN';
1824: ecx_utils.g_logfile :=null;
1825: ecx_debug.g_v_module_name :='ecx.plsql.';
1826: ecx_utils.g_transaction_type := m_transaction_type;
1827: ecx_utils.g_transaction_subtype := m_transaction_subtype;
1820: end if;
1821:
1822: close get_msg;
1823: ecx_utils.g_direction := 'IN';
1824: ecx_utils.g_logfile :=null;
1825: ecx_debug.g_v_module_name :='ecx.plsql.';
1826: ecx_utils.g_transaction_type := m_transaction_type;
1827: ecx_utils.g_transaction_subtype := m_transaction_subtype;
1828: ecx_utils.g_msgid := i_msgid;
1822: close get_msg;
1823: ecx_utils.g_direction := 'IN';
1824: ecx_utils.g_logfile :=null;
1825: ecx_debug.g_v_module_name :='ecx.plsql.';
1826: ecx_utils.g_transaction_type := m_transaction_type;
1827: ecx_utils.g_transaction_subtype := m_transaction_subtype;
1828: ecx_utils.g_msgid := i_msgid;
1829: begin
1830: select standard_id
1823: ecx_utils.g_direction := 'IN';
1824: ecx_utils.g_logfile :=null;
1825: ecx_debug.g_v_module_name :='ecx.plsql.';
1826: ecx_utils.g_transaction_type := m_transaction_type;
1827: ecx_utils.g_transaction_subtype := m_transaction_subtype;
1828: ecx_utils.g_msgid := i_msgid;
1829: begin
1830: select standard_id
1831: into ecx_utils.g_standard_id
1824: ecx_utils.g_logfile :=null;
1825: ecx_debug.g_v_module_name :='ecx.plsql.';
1826: ecx_utils.g_transaction_type := m_transaction_type;
1827: ecx_utils.g_transaction_subtype := m_transaction_subtype;
1828: ecx_utils.g_msgid := i_msgid;
1829: begin
1830: select standard_id
1831: into ecx_utils.g_standard_id
1832: from ecx_standards
1827: ecx_utils.g_transaction_subtype := m_transaction_subtype;
1828: ecx_utils.g_msgid := i_msgid;
1829: begin
1830: select standard_id
1831: into ecx_utils.g_standard_id
1832: from ecx_standards
1833: where standard_code = m_message_standard
1834: and standard_type = nvl(m_message_type, 'XML');
1835: if(l_statementEnabled) then
1832: from ecx_standards
1833: where standard_code = m_message_standard
1834: and standard_type = nvl(m_message_type, 'XML');
1835: if(l_statementEnabled) then
1836: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
1837: end if;
1838: exception
1839: when others then
1840: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');
1837: end if;
1838: exception
1839: when others then
1840: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');
1841: raise ecx_utils.program_exit;
1842: end;
1843: ecx_debug.module_enabled;
1844: g_instlmode := wf_core.translate('WF_INSTALL');
1845:
1864: Fetch the Run Id for the Transaction
1865: **/
1866: open get_run_s;
1867: fetch get_run_s
1868: into ecx_utils.g_run_id;
1869: close get_run_s;
1870:
1871: --get the Log directory from the Profile Option.
1872: ecx_utils.getLogDirectory;
1868: into ecx_utils.g_run_id;
1869: close get_run_s;
1870:
1871: --get the Log directory from the Profile Option.
1872: ecx_utils.getLogDirectory;
1873:
1874: 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';
1875:
1876: p_aflog_module_name := '';
1870:
1871: --get the Log directory from the Profile Option.
1872: ecx_utils.getLogDirectory;
1873:
1874: 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';
1875:
1876: p_aflog_module_name := '';
1877: IF (m_message_standard is not null) THEN
1878: p_aflog_module_name := p_aflog_module_name||m_message_standard||'.';
1883: END IF;
1884: IF (m_transaction_subtype is not null) THEN
1885: p_aflog_module_name := p_aflog_module_name||m_transaction_subtype||'.';
1886: END IF;
1887: IF (ecx_utils.g_run_id is not null) THEN
1888: p_aflog_module_name := p_aflog_module_name||ecx_utils.g_run_id;
1889: END IF;
1890: p_aflog_module_name := p_aflog_module_name||'.log';
1891:
1884: IF (m_transaction_subtype is not null) THEN
1885: p_aflog_module_name := p_aflog_module_name||m_transaction_subtype||'.';
1886: END IF;
1887: IF (ecx_utils.g_run_id is not null) THEN
1888: p_aflog_module_name := p_aflog_module_name||ecx_utils.g_run_id;
1889: END IF;
1890: p_aflog_module_name := p_aflog_module_name||'.log';
1891:
1892: ecx_debug.enable_debug_new(i_debug_level,ecx_utils.g_logdir,i_logfile, p_aflog_module_name);
1888: p_aflog_module_name := p_aflog_module_name||ecx_utils.g_run_id;
1889: END IF;
1890: p_aflog_module_name := p_aflog_module_name||'.log';
1891:
1892: ecx_debug.enable_debug_new(i_debug_level,ecx_utils.g_logdir,i_logfile, p_aflog_module_name);
1893: END IF;
1894:
1895: /* Assign local variables with the ecx_debug global variables*/
1896: l_procedure := ecx_debug.g_procedure;
1907: if(l_statementEnabled) then
1908: ecx_debug.log(l_statement,'i_msgid',i_msgid,i_method_name);
1909: ecx_debug.log(l_statement,'i_debug_level',i_debug_level,i_method_name);
1910: end if;
1911: ecx_utils.g_document_id :=m_internal_control_number;
1912:
1913: IF (ecx_logging_enabled and g_instlmode = 'STANDALONE') THEN
1914: ecx_utils.g_logfile :=i_logfile;
1915: END IF;
1910: end if;
1911: ecx_utils.g_document_id :=m_internal_control_number;
1912:
1913: IF (ecx_logging_enabled and g_instlmode = 'STANDALONE') THEN
1914: ecx_utils.g_logfile :=i_logfile;
1915: END IF;
1916:
1917: /*ecx_utils.g_direction := 'IN';
1918:
1913: IF (ecx_logging_enabled and g_instlmode = 'STANDALONE') THEN
1914: ecx_utils.g_logfile :=i_logfile;
1915: END IF;
1916:
1917: /*ecx_utils.g_direction := 'IN';
1918:
1919: ecx_utils.g_transaction_type := m_transaction_type;
1920: ecx_utils.g_transaction_subtype := m_transaction_subtype;
1921: ecx_utils.g_msgid := i_msgid;*/
1915: END IF;
1916:
1917: /*ecx_utils.g_direction := 'IN';
1918:
1919: ecx_utils.g_transaction_type := m_transaction_type;
1920: ecx_utils.g_transaction_subtype := m_transaction_subtype;
1921: ecx_utils.g_msgid := i_msgid;*/
1922:
1923: /*begin
1916:
1917: /*ecx_utils.g_direction := 'IN';
1918:
1919: ecx_utils.g_transaction_type := m_transaction_type;
1920: ecx_utils.g_transaction_subtype := m_transaction_subtype;
1921: ecx_utils.g_msgid := i_msgid;*/
1922:
1923: /*begin
1924: select standard_id
1917: /*ecx_utils.g_direction := 'IN';
1918:
1919: ecx_utils.g_transaction_type := m_transaction_type;
1920: ecx_utils.g_transaction_subtype := m_transaction_subtype;
1921: ecx_utils.g_msgid := i_msgid;*/
1922:
1923: /*begin
1924: select standard_id
1925: into ecx_utils.g_standard_id
1921: ecx_utils.g_msgid := i_msgid;*/
1922:
1923: /*begin
1924: select standard_id
1925: into ecx_utils.g_standard_id
1926: from ecx_standards
1927: where standard_code = m_message_standard
1928: and standard_type = nvl(m_message_type, 'XML');
1929: if(l_statementEnabled) then
1926: from ecx_standards
1927: where standard_code = m_message_standard
1928: and standard_type = nvl(m_message_type, 'XML');
1929: if(l_statementEnabled) then
1930: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
1931: end if;
1932: exception
1933: when others then
1934: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');
1931: end if;
1932: exception
1933: when others then
1934: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');
1935: raise ecx_utils.program_exit;
1936: enid;*/
1937: validate_message
1938: (
1939: i_msgid,
1955: ecx_debug.disable_debug;
1956: END IF;
1957:
1958: exception
1959: when ecx_utils.program_exit then
1960: --ecx_utils.g_map_id := -1;
1961: if(l_unexpectedEnabled) then
1962: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1963: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1956: END IF;
1957:
1958: exception
1959: when ecx_utils.program_exit then
1960: --ecx_utils.g_map_id := -1;
1961: if(l_unexpectedEnabled) then
1962: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1963: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1964: end if;
1958: exception
1959: when ecx_utils.program_exit then
1960: --ecx_utils.g_map_id := -1;
1961: if(l_unexpectedEnabled) then
1962: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1963: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1964: end if;
1965: if (l_procedureEnabled) then
1966: ecx_debug.pop(i_method_name);
1959: when ecx_utils.program_exit then
1960: --ecx_utils.g_map_id := -1;
1961: if(l_unexpectedEnabled) then
1962: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1963: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1964: end if;
1965: if (l_procedureEnabled) then
1966: ecx_debug.pop(i_method_name);
1967: end if;
1972: END IF;
1973:
1974: raise;
1975: when msg_not_found then
1976: --ecx_utils.g_map_id := -1;
1977: ecx_debug.setErrorInfo(1,30,'ECX_MSGID_NOT_FOUND',
1978: 'p_msgid',
1979: i_msgid);
1980: close get_msg;
1979: i_msgid);
1980: close get_msg;
1981: raise;
1982: when others then
1983: --ecx_utils.g_map_id := -1;
1984: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
1985: if(l_unexpectedEnabled) then
1986: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1987: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1982: when others then
1983: --ecx_utils.g_map_id := -1;
1984: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
1985: if(l_unexpectedEnabled) then
1986: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1987: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1988: end if;
1989: if (l_procedureEnabled) then
1990: ecx_debug.pop(i_method_name);
1983: --ecx_utils.g_map_id := -1;
1984: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
1985: if(l_unexpectedEnabled) then
1986: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1987: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1988: end if;
1989: if (l_procedureEnabled) then
1990: ecx_debug.pop(i_method_name);
1991: end if;
2055: logging_enabled varchar2(20);
2056: module varchar2(2000);
2057:
2058: begin
2059: ecx_utils.g_logfile :=null;
2060: ecx_debug.g_v_module_name :='ecx.plsql.';
2061: fnd_profile.get('AFLOG_ENABLED',logging_enabled);
2062: fnd_profile.get('AFLOG_MODULE',module);
2063: if(logging_enabled = 'Y' AND ((lower(module) like 'ecx%'
2093: Fetch the Run Id for the Transaction
2094: **/
2095: open get_run_s;
2096: fetch get_run_s
2097: into ecx_utils.g_run_id;
2098: close get_run_s;
2099:
2100: --get the Log directory from the Profile Option.
2101: ecx_utils.getLogDirectory;
2097: into ecx_utils.g_run_id;
2098: close get_run_s;
2099:
2100: --get the Log directory from the Profile Option.
2101: ecx_utils.getLogDirectory;
2102:
2103: i_logfile := m_message_standard||'IN'||m_transaction_type||m_transaction_subtype||ecx_utils.g_run_id||'.log';
2104:
2105: p_aflog_module_name := '';
2099:
2100: --get the Log directory from the Profile Option.
2101: ecx_utils.getLogDirectory;
2102:
2103: i_logfile := m_message_standard||'IN'||m_transaction_type||m_transaction_subtype||ecx_utils.g_run_id||'.log';
2104:
2105: p_aflog_module_name := '';
2106: IF (m_message_standard is not null) THEN
2107: p_aflog_module_name := p_aflog_module_name||m_message_standard||'.';
2112: END IF;
2113: IF (m_transaction_subtype is not null) THEN
2114: p_aflog_module_name := p_aflog_module_name||m_transaction_subtype||'.';
2115: END IF;
2116: IF (ecx_utils.g_run_id is not null) THEN
2117: p_aflog_module_name := p_aflog_module_name||ecx_utils.g_run_id;
2118: END IF;
2119: p_aflog_module_name := p_aflog_module_name||'.log';
2120:
2113: IF (m_transaction_subtype is not null) THEN
2114: p_aflog_module_name := p_aflog_module_name||m_transaction_subtype||'.';
2115: END IF;
2116: IF (ecx_utils.g_run_id is not null) THEN
2117: p_aflog_module_name := p_aflog_module_name||ecx_utils.g_run_id;
2118: END IF;
2119: p_aflog_module_name := p_aflog_module_name||'.log';
2120:
2121: ecx_debug.enable_debug_new(i_debug_level,ecx_utils.g_logdir,i_logfile, p_aflog_module_name);
2117: p_aflog_module_name := p_aflog_module_name||ecx_utils.g_run_id;
2118: END IF;
2119: p_aflog_module_name := p_aflog_module_name||'.log';
2120:
2121: ecx_debug.enable_debug_new(i_debug_level,ecx_utils.g_logdir,i_logfile, p_aflog_module_name);
2122: END IF;
2123:
2124: /* Assign local variables with the ecx_debug global variables*/
2125: l_procedure := ecx_debug.g_procedure;
2136: if(l_statementEnabled) then
2137: ecx_debug.log(l_statement,'i_msgid',i_msgid,i_method_name);
2138: ecx_debug.log(l_statement,'i_debug_level',i_debug_level,i_method_name);
2139: end if;
2140: ecx_utils.g_document_id :=m_internal_control_number;
2141:
2142: IF (ecx_logging_enabled ) THEN
2143: ecx_utils.g_logfile :=i_logfile;
2144: END IF;
2139: end if;
2140: ecx_utils.g_document_id :=m_internal_control_number;
2141:
2142: IF (ecx_logging_enabled ) THEN
2143: ecx_utils.g_logfile :=i_logfile;
2144: END IF;
2145:
2146: ecx_utils.g_direction := 'IN';
2147:
2142: IF (ecx_logging_enabled ) THEN
2143: ecx_utils.g_logfile :=i_logfile;
2144: END IF;
2145:
2146: ecx_utils.g_direction := 'IN';
2147:
2148: ecx_utils.g_transaction_type := m_transaction_type;
2149: ecx_utils.g_transaction_subtype := m_transaction_subtype;
2150: ecx_utils.g_msgid := i_msgid;
2144: END IF;
2145:
2146: ecx_utils.g_direction := 'IN';
2147:
2148: ecx_utils.g_transaction_type := m_transaction_type;
2149: ecx_utils.g_transaction_subtype := m_transaction_subtype;
2150: ecx_utils.g_msgid := i_msgid;
2151:
2152: begin
2145:
2146: ecx_utils.g_direction := 'IN';
2147:
2148: ecx_utils.g_transaction_type := m_transaction_type;
2149: ecx_utils.g_transaction_subtype := m_transaction_subtype;
2150: ecx_utils.g_msgid := i_msgid;
2151:
2152: begin
2153: select standard_id
2146: ecx_utils.g_direction := 'IN';
2147:
2148: ecx_utils.g_transaction_type := m_transaction_type;
2149: ecx_utils.g_transaction_subtype := m_transaction_subtype;
2150: ecx_utils.g_msgid := i_msgid;
2151:
2152: begin
2153: select standard_id
2154: into ecx_utils.g_standard_id
2150: ecx_utils.g_msgid := i_msgid;
2151:
2152: begin
2153: select standard_id
2154: into ecx_utils.g_standard_id
2155: from ecx_standards
2156: where standard_code = m_message_standard
2157: and standard_type = nvl(m_message_type, 'XML');
2158: if(l_statementEnabled) then
2155: from ecx_standards
2156: where standard_code = m_message_standard
2157: and standard_type = nvl(m_message_type, 'XML');
2158: if(l_statementEnabled) then
2159: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
2160: end if;
2161: exception
2162: when others then
2163: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');
2160: end if;
2161: exception
2162: when others then
2163: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');
2164: raise ecx_utils.program_exit;
2165: end;
2166:
2167: validate_message
2168: (
2186: END IF;
2187:
2188: commit;
2189: exception
2190: when ecx_utils.program_exit then
2191: --ecx_utils.g_map_id := -1;
2192: if(l_unexpectedEnabled) then
2193: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
2194: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
2187:
2188: commit;
2189: exception
2190: when ecx_utils.program_exit then
2191: --ecx_utils.g_map_id := -1;
2192: if(l_unexpectedEnabled) then
2193: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
2194: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
2195: end if;
2189: exception
2190: when ecx_utils.program_exit then
2191: --ecx_utils.g_map_id := -1;
2192: if(l_unexpectedEnabled) then
2193: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
2194: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
2195: end if;
2196: IF (ecx_logging_enabled ) THEN
2197: ecx_debug.print_log;
2190: when ecx_utils.program_exit then
2191: --ecx_utils.g_map_id := -1;
2192: if(l_unexpectedEnabled) then
2193: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
2194: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
2195: end if;
2196: IF (ecx_logging_enabled ) THEN
2197: ecx_debug.print_log;
2198: ecx_debug.disable_debug;
2198: ecx_debug.disable_debug;
2199: END IF;
2200: rollback;
2201: when msg_not_found then
2202: --ecx_utils.g_map_id := -1;
2203: ecx_debug.setErrorInfo(1,30,'ECX_MSGID_NOT_FOUND',
2204: 'p_msgid',
2205: i_msgid);
2206: close get_msg;
2205: i_msgid);
2206: close get_msg;
2207: rollback;
2208: when others then
2209: --ecx_utils.g_map_id := -1;
2210: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
2211: if(l_unexpectedEnabled) then
2212: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
2213: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
2208: when others then
2209: --ecx_utils.g_map_id := -1;
2210: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
2211: if(l_unexpectedEnabled) then
2212: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
2213: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
2214: end if;
2215: IF (ecx_logging_enabled ) THEN
2216: ecx_debug.print_log;
2209: --ecx_utils.g_map_id := -1;
2210: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
2211: if(l_unexpectedEnabled) then
2212: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
2213: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
2214: end if;
2215: IF (ecx_logging_enabled ) THEN
2216: ecx_debug.print_log;
2217: ecx_debug.disable_debug;
2273: Fetch the Run Id for the Transaction
2274: **/
2275: open get_run_s;
2276: fetch get_run_s
2277: into ecx_utils.g_run_id;
2278: close get_run_s;
2279:
2280: --get the Log directory from the Profile Option.
2281: ecx_utils.getLogDirectory;
2277: into ecx_utils.g_run_id;
2278: close get_run_s;
2279:
2280: --get the Log directory from the Profile Option.
2281: ecx_utils.getLogDirectory;
2282: i_logfile := 'IN'||ecx_utils.g_run_id||'.log';
2283: END IF;
2284:
2285: IF g_instlmode = 'EMBEDDED' THEN
2278: close get_run_s;
2279:
2280: --get the Log directory from the Profile Option.
2281: ecx_utils.getLogDirectory;
2282: i_logfile := 'IN'||ecx_utils.g_run_id||'.log';
2283: END IF;
2284:
2285: IF g_instlmode = 'EMBEDDED' THEN
2286: IF (ecx_logging_enabled ) THEN
2283: END IF;
2284:
2285: IF g_instlmode = 'EMBEDDED' THEN
2286: IF (ecx_logging_enabled ) THEN
2287: i_log_file := ecx_debug.g_sqlprefix || 'in.'||ecx_utils.g_run_id||'.log';
2288: ELSE
2289: i_log_file := 'Please ensure that FND-Logging is enabled for module '||ecx_debug.g_sqlprefix||'%';
2290: END IF;
2291: ELSE
2289: i_log_file := 'Please ensure that FND-Logging is enabled for module '||ecx_debug.g_sqlprefix||'%';
2290: END IF;
2291: ELSE
2292: IF (ecx_logging_enabled ) THEN
2293: i_log_file := ecx_utils.g_logdir||'/'||i_logfile;
2294: ELSE
2295: i_log_file := 'Please ensure that logging is enabled';
2296: END IF;
2297: END IF;
2296: END IF;
2297: END IF;
2298:
2299: IF (ecx_logging_enabled ) THEN
2300: ecx_debug.enable_debug_new(i_debug_level,ecx_utils.g_logdir,i_logfile, 'in.'||ecx_utils.g_run_id||'.log');
2301: END IF;
2302:
2303: /* Assign local variables with the ecx_debug global variables*/
2304: l_procedure := ecx_debug.g_procedure;
2317: ecx_debug.log(l_statement,'i_debug_level',i_debug_level,i_method_name);
2318: end if;
2319:
2320: IF (ecx_logging_enabled ) THEN
2321: ecx_utils.g_logfile :=i_logfile;
2322: END IF;
2323: ecx_utils.g_direction := 'IN';
2324:
2325: begin
2319:
2320: IF (ecx_logging_enabled ) THEN
2321: ecx_utils.g_logfile :=i_logfile;
2322: END IF;
2323: ecx_utils.g_direction := 'IN';
2324:
2325: begin
2326: select map_id
2327: into i_map_id
2331: when others then
2332: ecx_debug.setErrorInfo(2,30,'ECX_MAP_NOT_FOUND',
2333: 'MAP_CODE',
2334: i_map_code);
2335: raise ecx_utils.program_exit;
2336: end;
2337:
2338: begin
2339: select standard_id
2336: end;
2337:
2338: begin
2339: select standard_id
2340: into ecx_utils.g_standard_id
2341: from ecx_standards
2342: where standard_code = i_message_standard
2343: and standard_type = nvl(i_message_type, 'XML');
2344: if(l_statementEnabled) then
2341: from ecx_standards
2342: where standard_code = i_message_standard
2343: and standard_type = nvl(i_message_type, 'XML');
2344: if(l_statementEnabled) then
2345: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
2346: end if;
2347: exception
2348: when others then
2349: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');
2346: end if;
2347: exception
2348: when others then
2349: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');
2350: raise ecx_utils.program_exit;
2351: end;
2352:
2353: processXMLData
2354: (
2360: o_payload,
2361: i_message_type
2362: );
2363:
2364: --ecx_utils.i_ret_code :=0;
2365: --ecx_utils.i_errbuf := 'XML Document Successfully processed';
2366: ecx_debug.setErrorInfo(0,10,'ECX_DOCUMENT_PROCESSED');
2367:
2368: if(ecx_utils.i_ret_code = 0 ) then
2361: i_message_type
2362: );
2363:
2364: --ecx_utils.i_ret_code :=0;
2365: --ecx_utils.i_errbuf := 'XML Document Successfully processed';
2366: ecx_debug.setErrorInfo(0,10,'ECX_DOCUMENT_PROCESSED');
2367:
2368: if(ecx_utils.i_ret_code = 0 ) then
2369: if(l_statementEnabled) then
2364: --ecx_utils.i_ret_code :=0;
2365: --ecx_utils.i_errbuf := 'XML Document Successfully processed';
2366: ecx_debug.setErrorInfo(0,10,'ECX_DOCUMENT_PROCESSED');
2367:
2368: if(ecx_utils.i_ret_code = 0 ) then
2369: if(l_statementEnabled) then
2370: ecx_debug.log(l_statement, 'Ret Code',ecx_utils.i_ret_code,i_method_name);
2371: ecx_debug.log(l_statement, 'Ret Msg ',ecx_utils.i_errbuf,i_method_name);
2372: end if;
2366: ecx_debug.setErrorInfo(0,10,'ECX_DOCUMENT_PROCESSED');
2367:
2368: if(ecx_utils.i_ret_code = 0 ) then
2369: if(l_statementEnabled) then
2370: ecx_debug.log(l_statement, 'Ret Code',ecx_utils.i_ret_code,i_method_name);
2371: ecx_debug.log(l_statement, 'Ret Msg ',ecx_utils.i_errbuf,i_method_name);
2372: end if;
2373: else
2374: if(l_unexpectedEnabled) then
2367:
2368: if(ecx_utils.i_ret_code = 0 ) then
2369: if(l_statementEnabled) then
2370: ecx_debug.log(l_statement, 'Ret Code',ecx_utils.i_ret_code,i_method_name);
2371: ecx_debug.log(l_statement, 'Ret Msg ',ecx_utils.i_errbuf,i_method_name);
2372: end if;
2373: else
2374: if(l_unexpectedEnabled) then
2375: ecx_debug.log(l_unexpected, 'Ret Code',ecx_utils.i_ret_code,i_method_name);
2371: ecx_debug.log(l_statement, 'Ret Msg ',ecx_utils.i_errbuf,i_method_name);
2372: end if;
2373: else
2374: if(l_unexpectedEnabled) then
2375: ecx_debug.log(l_unexpected, 'Ret Code',ecx_utils.i_ret_code,i_method_name);
2376: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_utils.i_errbuf,i_method_name);
2377: end if;
2378: end if;
2379:
2372: end if;
2373: else
2374: if(l_unexpectedEnabled) then
2375: ecx_debug.log(l_unexpected, 'Ret Code',ecx_utils.i_ret_code,i_method_name);
2376: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_utils.i_errbuf,i_method_name);
2377: end if;
2378: end if;
2379:
2380: if (l_procedureEnabled) then
2385: ecx_debug.print_log;
2386: ecx_debug.disable_debug;
2387: END IF;
2388:
2389: i_ret_code := ecx_utils.i_ret_code;
2390: i_errbuf := ecx_utils.i_errbuf;
2391:
2392: exception
2393: when ecx_utils.program_exit then
2386: ecx_debug.disable_debug;
2387: END IF;
2388:
2389: i_ret_code := ecx_utils.i_ret_code;
2390: i_errbuf := ecx_utils.i_errbuf;
2391:
2392: exception
2393: when ecx_utils.program_exit then
2394: --dbms_lob.freetemporary(o_payload);
2389: i_ret_code := ecx_utils.i_ret_code;
2390: i_errbuf := ecx_utils.i_errbuf;
2391:
2392: exception
2393: when ecx_utils.program_exit then
2394: --dbms_lob.freetemporary(o_payload);
2395: --ecx_utils.g_map_id := -1;
2396: if(l_unexpectedEnabled) then
2397: ecx_debug.log(l_unexpected,'Ret Code',ecx_utils.i_ret_code,i_method_name);
2391:
2392: exception
2393: when ecx_utils.program_exit then
2394: --dbms_lob.freetemporary(o_payload);
2395: --ecx_utils.g_map_id := -1;
2396: if(l_unexpectedEnabled) then
2397: ecx_debug.log(l_unexpected,'Ret Code',ecx_utils.i_ret_code,i_method_name);
2398: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_debug.getMessage(ecx_utils.i_errbuf,
2399: ecx_utils.i_errparams),i_method_name);
2393: when ecx_utils.program_exit then
2394: --dbms_lob.freetemporary(o_payload);
2395: --ecx_utils.g_map_id := -1;
2396: if(l_unexpectedEnabled) then
2397: ecx_debug.log(l_unexpected,'Ret Code',ecx_utils.i_ret_code,i_method_name);
2398: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_debug.getMessage(ecx_utils.i_errbuf,
2399: ecx_utils.i_errparams),i_method_name);
2400: end if;
2401: if (l_procedureEnabled) then
2394: --dbms_lob.freetemporary(o_payload);
2395: --ecx_utils.g_map_id := -1;
2396: if(l_unexpectedEnabled) then
2397: ecx_debug.log(l_unexpected,'Ret Code',ecx_utils.i_ret_code,i_method_name);
2398: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_debug.getMessage(ecx_utils.i_errbuf,
2399: ecx_utils.i_errparams),i_method_name);
2400: end if;
2401: if (l_procedureEnabled) then
2402: ecx_debug.pop(i_method_name);
2395: --ecx_utils.g_map_id := -1;
2396: if(l_unexpectedEnabled) then
2397: ecx_debug.log(l_unexpected,'Ret Code',ecx_utils.i_ret_code,i_method_name);
2398: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_debug.getMessage(ecx_utils.i_errbuf,
2399: ecx_utils.i_errparams),i_method_name);
2400: end if;
2401: if (l_procedureEnabled) then
2402: ecx_debug.pop(i_method_name);
2403: end if;
2404: IF (ecx_logging_enabled ) THEN
2405: ecx_debug.print_log;
2406: ecx_debug.disable_debug;
2407: END IF;
2408: i_ret_code := ecx_utils.i_ret_code;
2409: i_errbuf := ecx_utils.i_errbuf;
2410:
2411: when others then
2412: --dbms_lob.freetemporary(o_payload);
2405: ecx_debug.print_log;
2406: ecx_debug.disable_debug;
2407: END IF;
2408: i_ret_code := ecx_utils.i_ret_code;
2409: i_errbuf := ecx_utils.i_errbuf;
2410:
2411: when others then
2412: --dbms_lob.freetemporary(o_payload);
2413: --ecx_utils.g_map_id := -1;
2409: i_errbuf := ecx_utils.i_errbuf;
2410:
2411: when others then
2412: --dbms_lob.freetemporary(o_payload);
2413: --ecx_utils.g_map_id := -1;
2414: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
2415: if(l_unexpectedEnabled) then
2416: ecx_debug.log(l_unexpected,'Ret Code',ecx_utils.i_ret_code,i_method_name);
2417: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_debug.getMessage(ecx_utils.i_errbuf,
2412: --dbms_lob.freetemporary(o_payload);
2413: --ecx_utils.g_map_id := -1;
2414: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
2415: if(l_unexpectedEnabled) then
2416: ecx_debug.log(l_unexpected,'Ret Code',ecx_utils.i_ret_code,i_method_name);
2417: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_debug.getMessage(ecx_utils.i_errbuf,
2418: ecx_utils.i_errparams),i_method_name);
2419: end if;
2420: if (l_procedureEnabled) then
2413: --ecx_utils.g_map_id := -1;
2414: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
2415: if(l_unexpectedEnabled) then
2416: ecx_debug.log(l_unexpected,'Ret Code',ecx_utils.i_ret_code,i_method_name);
2417: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_debug.getMessage(ecx_utils.i_errbuf,
2418: ecx_utils.i_errparams),i_method_name);
2419: end if;
2420: if (l_procedureEnabled) then
2421: ecx_debug.pop(i_method_name);
2414: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
2415: if(l_unexpectedEnabled) then
2416: ecx_debug.log(l_unexpected,'Ret Code',ecx_utils.i_ret_code,i_method_name);
2417: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_debug.getMessage(ecx_utils.i_errbuf,
2418: ecx_utils.i_errparams),i_method_name);
2419: end if;
2420: if (l_procedureEnabled) then
2421: ecx_debug.pop(i_method_name);
2422: end if;
2423: IF (ecx_logging_enabled ) THEN
2424: ecx_debug.print_log;
2425: ecx_debug.disable_debug;
2426: END IF;
2427: i_ret_code := ecx_utils.i_ret_code;
2428: i_errbuf := ecx_utils.i_errbuf;
2429: end processXML;
2430:
2431:
2424: ecx_debug.print_log;
2425: ecx_debug.disable_debug;
2426: END IF;
2427: i_ret_code := ecx_utils.i_ret_code;
2428: i_errbuf := ecx_utils.i_errbuf;
2429: end processXML;
2430:
2431:
2432: procedure reprocess
2453: (
2454: i_trigger_id,
2455: i_msgid,
2456: null,
2457: ecx_utils.i_ret_code,
2458: ecx_utils.i_errbuf
2459: );
2460:
2461: */
2454: i_trigger_id,
2455: i_msgid,
2456: null,
2457: ecx_utils.i_ret_code,
2458: ecx_utils.i_errbuf
2459: );
2460:
2461: */
2462:
2472: if(i_process_id is null) -- means TP setup wrong. Message never got into transaction queue.
2473: then
2474: return;
2475: end if;
2476: ecx_errorlog.inbound_engine(i_process_id,ecx_utils.i_ret_code,
2477: ecx_utils.i_errbuf);
2478: ecx_utils.g_logfile := null;
2479: exception
2480: when others then
2473: then
2474: return;
2475: end if;
2476: ecx_errorlog.inbound_engine(i_process_id,ecx_utils.i_ret_code,
2477: ecx_utils.i_errbuf);
2478: ecx_utils.g_logfile := null;
2479: exception
2480: when others then
2481: ecx_errorlog.inbound_engine(i_process_id,ecx_utils.i_ret_code, ecx_utils.i_errbuf,ecx_utils.i_errparams);
2474: return;
2475: end if;
2476: ecx_errorlog.inbound_engine(i_process_id,ecx_utils.i_ret_code,
2477: ecx_utils.i_errbuf);
2478: ecx_utils.g_logfile := null;
2479: exception
2480: when others then
2481: ecx_errorlog.inbound_engine(i_process_id,ecx_utils.i_ret_code, ecx_utils.i_errbuf,ecx_utils.i_errparams);
2482: i_retcode := ecx_utils.i_ret_code;
2477: ecx_utils.i_errbuf);
2478: ecx_utils.g_logfile := null;
2479: exception
2480: when others then
2481: ecx_errorlog.inbound_engine(i_process_id,ecx_utils.i_ret_code, ecx_utils.i_errbuf,ecx_utils.i_errparams);
2482: i_retcode := ecx_utils.i_ret_code;
2483: i_errbuf := ecx_utils.i_errbuf;
2484: ecx_utils.g_logfile := null;
2485: end;
2478: ecx_utils.g_logfile := null;
2479: exception
2480: when others then
2481: ecx_errorlog.inbound_engine(i_process_id,ecx_utils.i_ret_code, ecx_utils.i_errbuf,ecx_utils.i_errparams);
2482: i_retcode := ecx_utils.i_ret_code;
2483: i_errbuf := ecx_utils.i_errbuf;
2484: ecx_utils.g_logfile := null;
2485: end;
2486:
2479: exception
2480: when others then
2481: ecx_errorlog.inbound_engine(i_process_id,ecx_utils.i_ret_code, ecx_utils.i_errbuf,ecx_utils.i_errparams);
2482: i_retcode := ecx_utils.i_ret_code;
2483: i_errbuf := ecx_utils.i_errbuf;
2484: ecx_utils.g_logfile := null;
2485: end;
2486:
2487: --Changed for MLS
2480: when others then
2481: ecx_errorlog.inbound_engine(i_process_id,ecx_utils.i_ret_code, ecx_utils.i_errbuf,ecx_utils.i_errparams);
2482: i_retcode := ecx_utils.i_ret_code;
2483: i_errbuf := ecx_utils.i_errbuf;
2484: ecx_utils.g_logfile := null;
2485: end;
2486:
2487: --Changed for MLS
2488: ecx_debug.setErrorInfo(0,10,'ECX_MESSAGE_REPROCESSED');
2485: end;
2486:
2487: --Changed for MLS
2488: ecx_debug.setErrorInfo(0,10,'ECX_MESSAGE_REPROCESSED');
2489: i_retcode := ecx_utils.i_ret_code;
2490: i_errbuf := ecx_utils.i_errbuf;
2491: exception
2492: when others then
2493: i_retcode := ecx_utils.i_ret_code;
2486:
2487: --Changed for MLS
2488: ecx_debug.setErrorInfo(0,10,'ECX_MESSAGE_REPROCESSED');
2489: i_retcode := ecx_utils.i_ret_code;
2490: i_errbuf := ecx_utils.i_errbuf;
2491: exception
2492: when others then
2493: i_retcode := ecx_utils.i_ret_code;
2494: i_errbuf := ecx_utils.i_errbuf;
2489: i_retcode := ecx_utils.i_ret_code;
2490: i_errbuf := ecx_utils.i_errbuf;
2491: exception
2492: when others then
2493: i_retcode := ecx_utils.i_ret_code;
2494: i_errbuf := ecx_utils.i_errbuf;
2495: raise;
2496: end reprocess;
2497:
2490: i_errbuf := ecx_utils.i_errbuf;
2491: exception
2492: when others then
2493: i_retcode := ecx_utils.i_ret_code;
2494: i_errbuf := ecx_utils.i_errbuf;
2495: raise;
2496: end reprocess;
2497:
2498: end ecx_inbound_trig;