[Home] [Help]
1: PACKAGE BODY ecx_outbound as
2: -- $Header: ECXOUBXB.pls 120.12 2006/12/18 09:40:38 susaha ship $
3:
4: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
5: l_statement PLS_INTEGER := ecx_debug.g_statement;
6: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
7: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;
8: l_statementEnabled boolean := ecx_debug.g_statementEnabled;
1: PACKAGE BODY ecx_outbound as
2: -- $Header: ECXOUBXB.pls 120.12 2006/12/18 09:40:38 susaha ship $
3:
4: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
5: l_statement PLS_INTEGER := ecx_debug.g_statement;
6: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
7: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;
8: l_statementEnabled boolean := ecx_debug.g_statementEnabled;
9: l_unexpectedEnabled boolean := ecx_debug.g_unexpectedEnabled;
2: -- $Header: ECXOUBXB.pls 120.12 2006/12/18 09:40:38 susaha ship $
3:
4: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
5: l_statement PLS_INTEGER := ecx_debug.g_statement;
6: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
7: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;
8: l_statementEnabled boolean := ecx_debug.g_statementEnabled;
9: l_unexpectedEnabled boolean := ecx_debug.g_unexpectedEnabled;
10:
3:
4: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
5: l_statement PLS_INTEGER := ecx_debug.g_statement;
6: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
7: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;
8: l_statementEnabled boolean := ecx_debug.g_statementEnabled;
9: l_unexpectedEnabled boolean := ecx_debug.g_unexpectedEnabled;
10:
11: TYPE l_stack is table of pls_integer index by binary_integer;
4: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
5: l_statement PLS_INTEGER := ecx_debug.g_statement;
6: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
7: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;
8: l_statementEnabled boolean := ecx_debug.g_statementEnabled;
9: l_unexpectedEnabled boolean := ecx_debug.g_unexpectedEnabled;
10:
11: TYPE l_stack is table of pls_integer index by binary_integer;
12: i_stack l_stack;
5: l_statement PLS_INTEGER := ecx_debug.g_statement;
6: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
7: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;
8: l_statementEnabled boolean := ecx_debug.g_statementEnabled;
9: l_unexpectedEnabled boolean := ecx_debug.g_unexpectedEnabled;
10:
11: TYPE l_stack is table of pls_integer index by binary_integer;
12: i_stack l_stack;
13:
26: i_method_name varchar2(2000) := 'ecx_outbound.move_from_source_to_target';
27: i pls_integer;
28: begin
29: if (l_procedureEnabled) then
30: ecx_debug.push(i_method_name);
31: end if;
32: if(l_statementEnabled) then
33: ecx_debug.log(l_statement,'i_target_level',i_target_level,i_method_name);
34: end if;
29: if (l_procedureEnabled) then
30: ecx_debug.push(i_method_name);
31: end if;
32: if(l_statementEnabled) then
33: ecx_debug.log(l_statement,'i_target_level',i_target_level,i_method_name);
34: end if;
35: /**
36: Move the Values from Source to the Target
37: **/
72: then
73: ecx_utils.g_target(i).value := ecx_utils.g_target(i).default_value;
74: End if;
75: if(l_statementEnabled) then
76: ecx_debug.log(l_statement, ecx_utils.g_target(i).attribute_name,ecx_utils.g_target(i).value,
77: i_method_name);
78: end if;
79: End if;
80: **/
80: **/
81:
82: If ecx_utils.g_target(i).clob_value is not null Then
83: if(l_statementEnabled) then
84: ecx_debug.log(l_statement,i||'=>'||ecx_utils.g_target(i).parent_attribute_id||'=>'||
85: ecx_utils.g_target(i).attribute_type||'=>'||
86: ecx_utils.g_target(i).attribute_name,ecx_utils.g_target(i).clob_value,
87: i_method_name);
88: end if;
93: then
94: ecx_utils.g_target(i).value := ecx_utils.g_target(i).default_value;
95: End if;
96: if(l_statementEnabled) then
97: ecx_debug.log(l_statement,i||'=>'||ecx_utils.g_target(i).parent_attribute_id||'=>'||
98: ecx_utils.g_target(i).attribute_type||'=>'||
99: ecx_utils.g_target(i).attribute_name,ecx_utils.g_target(i).value,
100: i_method_name);
101: end if;
101: end if;
102: End If;
103: end loop;
104: if (l_procedureEnabled) then
105: ecx_debug.pop(i_method_name);
106: end if;
107: exception
108: when others then
109: if(l_unexpectedEnabled) then
106: end if;
107: exception
108: when others then
109: if(l_unexpectedEnabled) then
110: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
111: 'ECX_OUTBOUND.MOVE_FROM_SOURCE_TO_TARGET');
112: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
113: end if;
114: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.MOVE_FROM_SOURCE_TO_TARGET');
108: when others then
109: if(l_unexpectedEnabled) then
110: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
111: 'ECX_OUTBOUND.MOVE_FROM_SOURCE_TO_TARGET');
112: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
113: end if;
114: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.MOVE_FROM_SOURCE_TO_TARGET');
115: if(l_unexpectedEnabled) then
116: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.MOVE_FROM_SOURCE_TO_TARGET',
110: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
111: 'ECX_OUTBOUND.MOVE_FROM_SOURCE_TO_TARGET');
112: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
113: end if;
114: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.MOVE_FROM_SOURCE_TO_TARGET');
115: if(l_unexpectedEnabled) then
116: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.MOVE_FROM_SOURCE_TO_TARGET',
117: i_method_name);
118: end if;
112: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
113: end if;
114: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.MOVE_FROM_SOURCE_TO_TARGET');
115: if(l_unexpectedEnabled) then
116: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.MOVE_FROM_SOURCE_TO_TARGET',
117: i_method_name);
118: end if;
119: if (l_procedureEnabled) then
120: ecx_debug.pop(i_method_name);
116: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.MOVE_FROM_SOURCE_TO_TARGET',
117: i_method_name);
118: end if;
119: if (l_procedureEnabled) then
120: ecx_debug.pop(i_method_name);
121: end if;
122: raise ecx_utils.PROGRAM_EXIT;
123: end move_from_source_to_target;
124:
138:
139: begin
140:
141: if (l_procedureEnabled) then
142: ecx_debug.push(i_method_name);
143: end if;
144: if(l_statementEnabled) then
145: ecx_debug.log(l_statement,'i_target',i_target,i_method_name);
146: end if;
141: if (l_procedureEnabled) then
142: ecx_debug.push(i_method_name);
143: end if;
144: if(l_statementEnabled) then
145: ecx_debug.log(l_statement,'i_target',i_target,i_method_name);
146: end if;
147:
148: -- don't need t execute stage 10, level 0 action for target as this is
149: -- already done in the initilization phase
170: -- Post Processing Stage for Target
171: ecx_actions.execute_stage_data ( 30, i_target, 'T');
172: end if;
173: if (l_procedureEnabled) then
174: ecx_debug.pop(i_method_name);
175: end if;
176:
177: exception
178: when ecx_utils.program_exit then
175: end if;
176:
177: exception
178: when ecx_utils.program_exit then
179: ecx_debug.pop('ECX_OUTBOUND.processTarget');
180: raise ecx_utils.program_exit;
181: when others then
182: if(l_unexpectedEnabled) then
183: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
179: ecx_debug.pop('ECX_OUTBOUND.processTarget');
180: raise ecx_utils.program_exit;
181: when others then
182: if(l_unexpectedEnabled) then
183: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
184: 'ECX_OUTBOUND.PROCESSTARGET');
185: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
186: end if;
187: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PROCESSTARGET');
181: when others then
182: if(l_unexpectedEnabled) then
183: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
184: 'ECX_OUTBOUND.PROCESSTARGET');
185: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
186: end if;
187: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PROCESSTARGET');
188: if(l_unexpectedEnabled) then
189: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.PROCESSTARGET',
183: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
184: 'ECX_OUTBOUND.PROCESSTARGET');
185: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
186: end if;
187: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PROCESSTARGET');
188: if(l_unexpectedEnabled) then
189: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.PROCESSTARGET',
190: i_method_name);
191: end if;
185: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
186: end if;
187: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PROCESSTARGET');
188: if(l_unexpectedEnabled) then
189: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.PROCESSTARGET',
190: i_method_name);
191: end if;
192: if (l_procedureEnabled) then
193: ecx_debug.pop(i_method_name);
189: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.PROCESSTARGET',
190: i_method_name);
191: end if;
192: if (l_procedureEnabled) then
193: ecx_debug.pop(i_method_name);
194: end if;
195: raise ecx_utils.PROGRAM_EXIT;
196: end processTarget;
197:
213: i_msg_data varchar2(2000);
214: j pls_integer;
215: begin
216: if (l_procedureEnabled) then
217: ecx_debug.push(i_method_name);
218: end if;
219: if(l_statementEnabled) then
220: ecx_debug.log(l_statement,'i',i,i_method_name);
221: ecx_debug.log(l_statement,'i_stage',i_stage,i_method_name);
216: if (l_procedureEnabled) then
217: ecx_debug.push(i_method_name);
218: end if;
219: if(l_statementEnabled) then
220: ecx_debug.log(l_statement,'i',i,i_method_name);
221: ecx_debug.log(l_statement,'i_stage',i_stage,i_method_name);
222: ecx_debug.log(l_statement,'i_next',i_next,i_method_name);
223: end if;
224:
217: ecx_debug.push(i_method_name);
218: end if;
219: if(l_statementEnabled) then
220: ecx_debug.log(l_statement,'i',i,i_method_name);
221: ecx_debug.log(l_statement,'i_stage',i_stage,i_method_name);
222: ecx_debug.log(l_statement,'i_next',i_next,i_method_name);
223: end if;
224:
225: if i < 0
218: end if;
219: if(l_statementEnabled) then
220: ecx_debug.log(l_statement,'i',i,i_method_name);
221: ecx_debug.log(l_statement,'i_stage',i_stage,i_method_name);
222: ecx_debug.log(l_statement,'i_next',i_next,i_method_name);
223: end if;
224:
225: if i < 0
226: then
224:
225: if i < 0
226: then
227: if (l_procedureEnabled) then
228: ecx_debug.pop(i_method_name);
229: end if;
230: return;
231: end if;
232:
247: else
248: ecx_utils.g_source(j).value := ecx_utils.g_source(j).default_value;
249: end if;
250: if(l_statementEnabled) then
251: ecx_debug.log(l_statement,'Source '||ecx_utils.g_source(j).attribute_name,
252: ecx_utils.g_source(j).value,i_method_name);
253: end if;
254: end loop;
255: end loop;
288: i_return_status = ecx_code_conversion_pvt.G_RET_STS_UNEXP_ERROR
289: )
290: THEN
291: if(l_statementEnabled) then
292: ecx_debug.log(l_statement,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
293: 'ECX_OUTBOUND.PROCESS_DATA');
294: ecx_debug.log(l_statement,'ECX','EC_CODE_CONVERSION_FAILED',i_method_name,'LEVEL',i);
295: end if;
296: ecx_utils.i_ret_code := 2;
290: THEN
291: if(l_statementEnabled) then
292: ecx_debug.log(l_statement,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
293: 'ECX_OUTBOUND.PROCESS_DATA');
294: ecx_debug.log(l_statement,'ECX','EC_CODE_CONVERSION_FAILED',i_method_name,'LEVEL',i);
295: end if;
296: ecx_utils.i_ret_code := 2;
297: RAISE ecx_utils.PROGRAM_EXIT;
298: END IF;
315: else
316: ecx_utils.g_target(k).value := ecx_utils.g_target(k).default_value;
317: end if;
318: if(l_statementEnabled) then
319: ecx_debug.log(l_statement,'target '||ecx_utils.g_target(k).attribute_name,
320: ecx_utils.g_target(k).value,i_method_name);
321: end if;
322: end loop;
323: end loop;
323: end loop;
324:
325: /** Check for Collapsion. Do depth checking for Collapsion only **/
326: if(l_statementEnabled) then
327: ecx_debug.log(l_statement,'Previous Level',i,i_method_name);
328: ecx_debug.log(l_statement,'Current Level',i_next,i_method_name);
329: end if;
330:
331: if ( ecx_utils.g_source_levels(i).last_source_level -
324:
325: /** Check for Collapsion. Do depth checking for Collapsion only **/
326: if(l_statementEnabled) then
327: ecx_debug.log(l_statement,'Previous Level',i,i_method_name);
328: ecx_debug.log(l_statement,'Current Level',i_next,i_method_name);
329: end if;
330:
331: if ( ecx_utils.g_source_levels(i).last_source_level -
332: ecx_utils.g_source_levels(i).first_source_level > 0 )
337: and
338: ( i_next <= ecx_utils.g_source_levels(i).last_source_level )
339: then
340: if(l_statementEnabled) then
341: ecx_debug.log(l_statement,'Skipping Source',i,i_method_name);
342: end if;
343: else
344: processTarget(ecx_utils.g_source_levels(i).first_target_level);
345: end if;
375:
376: -- for all the target levels mapped to this source level print the discont elements
377: j := ecx_utils.g_source_levels(i).last_target_level;
378: if (l_statementEnabled) then
379: ecx_debug.log(l_statement,'last target level', ecx_utils.g_source_levels(i).last_target_level,i_method_name);
380: ecx_debug.log(l_statement, 'first target level', ecx_utils.g_source_levels(i).first_target_level,
381: i_method_name);
382: end if;
383: while (j >= ecx_utils.g_source_levels(i).first_target_level)
376: -- for all the target levels mapped to this source level print the discont elements
377: j := ecx_utils.g_source_levels(i).last_target_level;
378: if (l_statementEnabled) then
379: ecx_debug.log(l_statement,'last target level', ecx_utils.g_source_levels(i).last_target_level,i_method_name);
380: ecx_debug.log(l_statement, 'first target level', ecx_utils.g_source_levels(i).first_target_level,
381: i_method_name);
382: end if;
383: while (j >= ecx_utils.g_source_levels(i).first_target_level)
384: loop
390: end loop;
391: end if;
392:
393: if (l_procedureEnabled) then
394: ecx_debug.pop(i_method_name);
395: end if;
396: exception
397: when ecx_utils.program_exit then
398: if (l_procedureEnabled) then
395: end if;
396: exception
397: when ecx_utils.program_exit then
398: if (l_procedureEnabled) then
399: ecx_debug.pop(i_method_name);
400: end if;
401: raise ecx_utils.program_exit;
402: when others then
403: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PROCESS_DATA');
399: ecx_debug.pop(i_method_name);
400: end if;
401: raise ecx_utils.program_exit;
402: when others then
403: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PROCESS_DATA');
404: if(l_unexpectedEnabled) then
405: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.PROCESS_DATA',i_method_name);
406: end if;
407: if (l_procedureEnabled) then
401: raise ecx_utils.program_exit;
402: when others then
403: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PROCESS_DATA');
404: if(l_unexpectedEnabled) then
405: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.PROCESS_DATA',i_method_name);
406: end if;
407: if (l_procedureEnabled) then
408: ecx_debug.pop(i_method_name);
409: end if;
404: if(l_unexpectedEnabled) then
405: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.PROCESS_DATA',i_method_name);
406: end if;
407: if (l_procedureEnabled) then
408: ecx_debug.pop(i_method_name);
409: end if;
410: raise ecx_utils.program_exit;
411: end process_data;
412:
416: i_method_name varchar2(2000) := 'ecx_outbound.print_stack';
417: begin
418:
419: if(l_statementEnabled) then
420: ecx_debug.log(l_statement,'Stack Status','====',i_method_name);
421: end if;
422: for i in 1..i_stack.COUNT
423: loop
424: if(l_statementEnabled) then
421: end if;
422: for i in 1..i_stack.COUNT
423: loop
424: if(l_statementEnabled) then
425: ecx_debug.log(l_statement,i_stack(i),i_method_name);
426: end if;
427: end loop;
428: exception
429: when others then
426: end if;
427: end loop;
428: exception
429: when others then
430: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PRINT_STACK');
431: if(l_unexpectedEnabled) then
432: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.PRINT_STACK',i_method_name);
433: end if;
434: raise ecx_utils.program_exit;
428: exception
429: when others then
430: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PRINT_STACK');
431: if(l_unexpectedEnabled) then
432: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.PRINT_STACK',i_method_name);
433: end if;
434: raise ecx_utils.program_exit;
435: end print_stack;
436:
442: i_method_name varchar2(2000) := 'ecx_outbound.pop';
443:
444: begin
445: if (l_procedureEnabled) then
446: ecx_debug.push(i_method_name );
447: end if;
448: if(l_statementEnabled) then
449: ecx_debug.log(l_statement,'i_next',i_next,i_method_name);
450: print_stack;
445: if (l_procedureEnabled) then
446: ecx_debug.push(i_method_name );
447: end if;
448: if(l_statementEnabled) then
449: ecx_debug.log(l_statement,'i_next',i_next,i_method_name);
450: print_stack;
451: end if;
452:
453: if i_stack.COUNT = 0
452:
453: if i_stack.COUNT = 0
454: then
455: if(l_statementEnabled) then
456: ecx_debug.log(l_statement,'Stack Error. Nothing to pop','xxxxx',i_method_name);
457: end if;
458: if (l_procedureEnabled) then
459: ecx_debug.pop(i_method_name);
460: end if;
455: if(l_statementEnabled) then
456: ecx_debug.log(l_statement,'Stack Error. Nothing to pop','xxxxx',i_method_name);
457: end if;
458: if (l_procedureEnabled) then
459: ecx_debug.pop(i_method_name);
460: end if;
461: return;
462: end if;
463:
469: if(l_statementEnabled) then
470: print_stack;
471: end if;
472: if (l_procedureEnabled) then
473: ecx_debug.pop(i_method_name );
474: end if;
475: exception
476: when ecx_utils.program_exit then
477: if (l_procedureEnabled) then
474: end if;
475: exception
476: when ecx_utils.program_exit then
477: if (l_procedureEnabled) then
478: ecx_debug.pop(i_method_name);
479: end if;
480: raise ecx_utils.program_exit;
481: when others then
482: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.POP');
478: ecx_debug.pop(i_method_name);
479: end if;
480: raise ecx_utils.program_exit;
481: when others then
482: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.POP');
483: if(l_unexpectedEnabled) then
484: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.POP',i_method_name);
485: end if;
486: if (l_procedureEnabled) then
480: raise ecx_utils.program_exit;
481: when others then
482: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.POP');
483: if(l_unexpectedEnabled) then
484: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.POP',i_method_name);
485: end if;
486: if (l_procedureEnabled) then
487: ecx_debug.pop(i_method_name);
488: end if;
483: if(l_unexpectedEnabled) then
484: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.POP',i_method_name);
485: end if;
486: if (l_procedureEnabled) then
487: ecx_debug.pop(i_method_name);
488: end if;
489: raise ecx_utils.program_exit;
490: end pop;
491:
497:
498: i_method_name varchar2(2000) := 'ecx_outbound.push';
499: begin
500: if (l_procedureEnabled) then
501: ecx_debug.push(i_method_name);
502: end if;
503: if(l_statementEnabled) then
504: ecx_debug.log(l_statement,i,i_method_name);
505: print_stack;
500: if (l_procedureEnabled) then
501: ecx_debug.push(i_method_name);
502: end if;
503: if(l_statementEnabled) then
504: ecx_debug.log(l_statement,i,i_method_name);
505: print_stack;
506: end if;
507:
508: if i_stack.COUNT = 0
517: print_stack;
518: end if;
519:
520: if (l_procedureEnabled) then
521: ecx_debug.pop(i_method_name);
522: end if;
523:
524: return;
525: end if;
539: print_stack;
540: end if;
541:
542: if (l_procedureEnabled) then
543: ecx_debug.pop(i_method_name);
544: end if;
545: return;
546: end if;
547:
581: print_stack;
582: end if;
583:
584: if (l_procedureEnabled) then
585: ecx_debug.pop(i_method_name);
586: end if;
587: exception
588: when ecx_utils.program_exit then
589: if (l_procedureEnabled) then
586: end if;
587: exception
588: when ecx_utils.program_exit then
589: if (l_procedureEnabled) then
590: ecx_debug.pop(i_method_name);
591: end if;
592: raise ecx_utils.program_exit;
593: when others then
594: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PUSH');
590: ecx_debug.pop(i_method_name);
591: end if;
592: raise ecx_utils.program_exit;
593: when others then
594: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PUSH');
595: if(l_unexpectedEnabled) then
596: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.PUSH',i_method_name);
597: end if;
598: if (l_procedureEnabled) then
592: raise ecx_utils.program_exit;
593: when others then
594: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PUSH');
595: if(l_unexpectedEnabled) then
596: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.PUSH',i_method_name);
597: end if;
598: if (l_procedureEnabled) then
599: ecx_debug.pop(i_method_name);
600: end if;
595: if(l_unexpectedEnabled) then
596: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.PUSH',i_method_name);
597: end if;
598: if (l_procedureEnabled) then
599: ecx_debug.pop(i_method_name);
600: end if;
601: raise ecx_utils.program_exit;
602: end push;
603:
606: is
607: i_method_name varchar2(2000) := 'ecx_outbound.popall';
608: begin
609: if (l_procedureEnabled) then
610: ecx_debug.push(i_method_name );
611: end if;
612: /** In-Process the last Level on the Stack **/
613: if i_stack.COUNT <> 0
614: then
628: print_stack;
629: end if;
630:
631: if (l_procedureEnabled) then
632: ecx_debug.pop(i_method_name );
633: end if;
634:
635: exception
636: when ecx_utils.program_exit then
634:
635: exception
636: when ecx_utils.program_exit then
637: if (l_procedureEnabled) then
638: ecx_debug.pop(i_method_name );
639: end if;
640: raise ecx_utils.program_exit;
641: when others then
642: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.POPALL');
638: ecx_debug.pop(i_method_name );
639: end if;
640: raise ecx_utils.program_exit;
641: when others then
642: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.POPALL');
643: if(l_unexpectedEnabled) then
644: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.POPALL',i_method_name);
645: end if;
646: if (l_procedureEnabled) then
640: raise ecx_utils.program_exit;
641: when others then
642: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.POPALL');
643: if(l_unexpectedEnabled) then
644: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.POPALL',i_method_name);
645: end if;
646: if (l_procedureEnabled) then
647: ecx_debug.pop(i_method_name );
648: end if;
643: if(l_unexpectedEnabled) then
644: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.POPALL',i_method_name);
645: end if;
646: if (l_procedureEnabled) then
647: ecx_debug.pop(i_method_name );
648: end if;
649: raise ecx_utils.program_exit;
650: end popall;
651:
666: l_clob clob;
667: i_len pls_integer;
668: BEGIN
669: if (l_procedureEnabled) then
670: ecx_debug.push(i_method_name );
671: end if;
672: if(l_statementEnabled) then
673: ecx_debug.log(l_statement,'i_level',i_level,i_method_name);
674: ecx_debug.log(l_statement,'Source level',ecx_utils.g_source_levels.COUNT,i_method_name);
669: if (l_procedureEnabled) then
670: ecx_debug.push(i_method_name );
671: end if;
672: if(l_statementEnabled) then
673: ecx_debug.log(l_statement,'i_level',i_level,i_method_name);
674: ecx_debug.log(l_statement,'Source level',ecx_utils.g_source_levels.COUNT,i_method_name);
675: ecx_debug.log(l_statement,'target_source_levels',ecx_utils.g_target_source_levels.COUNT,i_method_name);
676: end if;
677: -- push root element on stack
670: ecx_debug.push(i_method_name );
671: end if;
672: if(l_statementEnabled) then
673: ecx_debug.log(l_statement,'i_level',i_level,i_method_name);
674: ecx_debug.log(l_statement,'Source level',ecx_utils.g_source_levels.COUNT,i_method_name);
675: ecx_debug.log(l_statement,'target_source_levels',ecx_utils.g_target_source_levels.COUNT,i_method_name);
676: end if;
677: -- push root element on stack
678: if (i_level = 0)
671: end if;
672: if(l_statementEnabled) then
673: ecx_debug.log(l_statement,'i_level',i_level,i_method_name);
674: ecx_debug.log(l_statement,'Source level',ecx_utils.g_source_levels.COUNT,i_method_name);
675: ecx_debug.log(l_statement,'target_source_levels',ecx_utils.g_target_source_levels.COUNT,i_method_name);
676: end if;
677: -- push root element on stack
678: if (i_level = 0)
679: then
684: loop
685: IF ecx_utils.g_source_levels(i).parent_level = i_level
686: THEN
687: if(l_statementEnabled) then
688: ecx_debug.log(l_statement,'SQL Statement',ecx_utils.g_source_levels(i).sql_stmt,i_method_name);
689: end if;
690: -- Set the Global Variable for Current Level
691: ecx_utils.g_current_level := i;
692:
693: /* Bind the Variables for the Where Clause */
694: ecx_actions.bind_variables_for_view(10,i);
695: i_rows_processed := dbms_sql.execute (ecx_utils.g_source_levels(i).Cursor_Handle);
696: if(l_statementEnabled) then
697: ecx_debug.log(l_statement,'Cursor Handle',ecx_utils.g_source_levels(i).Cursor_handle,
698: i_method_name);
699: end if;
700:
701:
703: LOOP
704: push(i);
705:
706: if(l_statementEnabled) then
707: ecx_debug.log(l_statement,'Executing Fetch Rows',i_method_Name);
708: end if;
709:
710: -- Get Values from the View
711: -- Initialize the Column Counter
757: /** Change required for Clob Support -- 2263729 ***/
758: if ecx_utils.g_source(j).data_type = 112 Then
759: if ecx_utils.g_source(j).clob_value is null Then
760:
761: ecx_debug.log(l_statement,
762: ecx_utils.g_source(j).base_column_name,
763: ecx_utils.g_source(j).value,
764: i_method_name
765: );
765: );
766:
767: else
768:
769: ecx_debug.log(l_statement,
770: ecx_utils.g_source(j).base_column_name,
771: ecx_utils.g_source(j).clob_value,
772: i_method_name
773: );
773: );
774: end if;
775: else
776:
777: ecx_debug.log(l_statement,
778: ecx_utils.g_source(j).base_column_name,
779: ecx_utils.g_source(j).value,
780: i_method_name
781: );
786: exit when j = ecx_utils.g_source_levels(i).file_end_pos;
787: j := ecx_utils.g_source.next(j);
788: end loop;
789: if(l_statementEnabled) then
790: ecx_debug.log(l_statement,'All Rows fetched',i_method_name);
791: end if;
792:
793:
794: i_count :=0;
796: then
797: for m in ecx_utils.g_source_levels.first..ecx_utils.g_source_levels.last
798: loop
799: if(l_statementEnabled) then
800: ecx_debug.log(l_statement,'Source level '||m,'Parent level'||ecx_utils.g_source_levels(m).parent_level,
801: i_method_name);
802: end if;
803: if ecx_utils.g_source_levels(m).parent_level=i
804: then
806: end if;
807: end loop;
808: end if;
809: if(l_statementEnabled) then
810: ecx_debug.log(l_statement,'i_count',i_count,i_method_name);
811: end if;
812:
813: if i_count > 0
814: then
825: end if;
826: END IF;
827: end loop;
828: if (l_procedureEnabled) then
829: ecx_debug.pop(i_method_name );
830: end if;
831: EXCEPTION
832: WHEN invalid_number then
833: if(l_unexpectedEnabled) then
830: end if;
831: EXCEPTION
832: WHEN invalid_number then
833: if(l_unexpectedEnabled) then
834: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
835: 'PROGRESS_LEVEL','ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');
836: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,
837: 'ERROR_MESSAGE',SQLERRM);
838: end if;
832: WHEN invalid_number then
833: if(l_unexpectedEnabled) then
834: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
835: 'PROGRESS_LEVEL','ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');
836: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,
837: 'ERROR_MESSAGE',SQLERRM);
838: end if;
839: ecx_debug.setErrorInfo(2,30,'ECX_INVALID_NUMBER - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW' );
840: if (l_procedureEnabled) then
835: 'PROGRESS_LEVEL','ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');
836: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,
837: 'ERROR_MESSAGE',SQLERRM);
838: end if;
839: ecx_debug.setErrorInfo(2,30,'ECX_INVALID_NUMBER - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW' );
840: if (l_procedureEnabled) then
841: ecx_debug.pop(i_method_name);
842: end if;
843: raise ecx_utils.program_exit;
837: 'ERROR_MESSAGE',SQLERRM);
838: end if;
839: ecx_debug.setErrorInfo(2,30,'ECX_INVALID_NUMBER - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW' );
840: if (l_procedureEnabled) then
841: ecx_debug.pop(i_method_name);
842: end if;
843: raise ecx_utils.program_exit;
844: WHEN ecx_utils.PROGRAM_EXIT then
845: raise;
844: WHEN ecx_utils.PROGRAM_EXIT then
845: raise;
846: WHEN OTHERS THEN
847: if(l_unexpectedEnabled) then
848: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
849: 'ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');
850: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
851: end if;
852: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');
846: WHEN OTHERS THEN
847: if(l_unexpectedEnabled) then
848: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
849: 'ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');
850: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
851: end if;
852: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');
853: if(l_unexpectedEnabled) then
854: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW',
848: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
849: 'ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');
850: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
851: end if;
852: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');
853: if(l_unexpectedEnabled) then
854: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW',
855: i_method_name);
856: end if;
850: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
851: end if;
852: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');
853: if(l_unexpectedEnabled) then
854: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW',
855: i_method_name);
856: end if;
857: if (l_procedureEnabled) then
858: ecx_debug.pop(i_method_name );
854: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW',
855: i_method_name);
856: end if;
857: if (l_procedureEnabled) then
858: ecx_debug.pop(i_method_name );
859: end if;
860: raise ecx_utils.PROGRAM_EXIT;
861: END fetch_data_from_view;
862:
865: i_method_name varchar2(2000);
866: begin
867: i_method_name:='ecx_outbound.log_summary';
868: if (l_procedureEnabled) then
869: ecx_debug.push(i_method_name);
870: end if;
871:
872: ecx_debug.log(level,'Processing Summary','====',i_method_name);
873: if (ecx_utils.g_source_levels.count <> 0)
868: if (l_procedureEnabled) then
869: ecx_debug.push(i_method_name);
870: end if;
871:
872: ecx_debug.log(level,'Processing Summary','====',i_method_name);
873: if (ecx_utils.g_source_levels.count <> 0)
874: then
875: for i in ecx_utils.g_source_levels.first..ecx_utils.g_source_levels.last
876: loop
873: if (ecx_utils.g_source_levels.count <> 0)
874: then
875: for i in ecx_utils.g_source_levels.first..ecx_utils.g_source_levels.last
876: loop
877: ecx_debug.log(level,ecx_utils.g_source_levels(i).rows_processed||
878: ' row(s) processed for Level : '|| ecx_utils.g_source_levels(i).start_element
879: || '('|| i || ') ',i_method_name);
880: end loop;
881: end if;
879: || '('|| i || ') ',i_method_name);
880: end loop;
881: end if;
882: if (l_procedureEnabled) then
883: ecx_debug.pop(i_method_name);
884: end if;
885: exception
886: when others then
887: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.LOG_SUMMARY');
883: ecx_debug.pop(i_method_name);
884: end if;
885: exception
886: when others then
887: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.LOG_SUMMARY');
888: if(l_unexpectedEnabled) then
889: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.LOG_SUMMARY',i_method_name);
890: end if;
891: if (l_procedureEnabled) then
885: exception
886: when others then
887: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.LOG_SUMMARY');
888: if(l_unexpectedEnabled) then
889: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.LOG_SUMMARY',i_method_name);
890: end if;
891: if (l_procedureEnabled) then
892: ecx_debug.pop(i_method_name);
893: end if;
888: if(l_unexpectedEnabled) then
889: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.LOG_SUMMARY',i_method_name);
890: end if;
891: if (l_procedureEnabled) then
892: ecx_debug.pop(i_method_name);
893: end if;
894:
895: raise ecx_utils.program_exit;
896: end log_summary;
953: begin
954:
955:
956: if (l_procedureEnabled) then
957: ecx_debug.push(i_method_name );
958: end if;
959: if(l_statementEnabled) then
960: ecx_debug.log(l_statement,'ECX','ECX_START_OUTBOUND','MAP_ID',i_map_id,i_method_name);
961: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name);
956: if (l_procedureEnabled) then
957: ecx_debug.push(i_method_name );
958: end if;
959: if(l_statementEnabled) then
960: ecx_debug.log(l_statement,'ECX','ECX_START_OUTBOUND','MAP_ID',i_map_id,i_method_name);
961: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name);
962: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name);
963: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name);
964: ecx_debug.log(l_statement,'i_tp_id',i_tp_id,i_method_name);
957: ecx_debug.push(i_method_name );
958: end if;
959: if(l_statementEnabled) then
960: ecx_debug.log(l_statement,'ECX','ECX_START_OUTBOUND','MAP_ID',i_map_id,i_method_name);
961: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name);
962: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name);
963: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name);
964: ecx_debug.log(l_statement,'i_tp_id',i_tp_id,i_method_name);
965: ecx_debug.log(l_statement,'i_tp_site_id',i_tp_site_id,i_method_name);
958: end if;
959: if(l_statementEnabled) then
960: ecx_debug.log(l_statement,'ECX','ECX_START_OUTBOUND','MAP_ID',i_map_id,i_method_name);
961: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name);
962: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name);
963: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name);
964: ecx_debug.log(l_statement,'i_tp_id',i_tp_id,i_method_name);
965: ecx_debug.log(l_statement,'i_tp_site_id',i_tp_site_id,i_method_name);
966: ecx_debug.log(l_statement,'i_tp_type',i_tp_type,i_method_name);
959: if(l_statementEnabled) then
960: ecx_debug.log(l_statement,'ECX','ECX_START_OUTBOUND','MAP_ID',i_map_id,i_method_name);
961: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name);
962: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name);
963: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name);
964: ecx_debug.log(l_statement,'i_tp_id',i_tp_id,i_method_name);
965: ecx_debug.log(l_statement,'i_tp_site_id',i_tp_site_id,i_method_name);
966: ecx_debug.log(l_statement,'i_tp_type',i_tp_type,i_method_name);
967: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name);
960: ecx_debug.log(l_statement,'ECX','ECX_START_OUTBOUND','MAP_ID',i_map_id,i_method_name);
961: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name);
962: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name);
963: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name);
964: ecx_debug.log(l_statement,'i_tp_id',i_tp_id,i_method_name);
965: ecx_debug.log(l_statement,'i_tp_site_id',i_tp_site_id,i_method_name);
966: ecx_debug.log(l_statement,'i_tp_type',i_tp_type,i_method_name);
967: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name);
968: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name);
961: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name);
962: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name);
963: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name);
964: ecx_debug.log(l_statement,'i_tp_id',i_tp_id,i_method_name);
965: ecx_debug.log(l_statement,'i_tp_site_id',i_tp_site_id,i_method_name);
966: ecx_debug.log(l_statement,'i_tp_type',i_tp_type,i_method_name);
967: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name);
968: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name);
969: end if;
962: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name);
963: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name);
964: ecx_debug.log(l_statement,'i_tp_id',i_tp_id,i_method_name);
965: ecx_debug.log(l_statement,'i_tp_site_id',i_tp_site_id,i_method_name);
966: ecx_debug.log(l_statement,'i_tp_type',i_tp_type,i_method_name);
967: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name);
968: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name);
969: end if;
970:
963: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name);
964: ecx_debug.log(l_statement,'i_tp_id',i_tp_id,i_method_name);
965: ecx_debug.log(l_statement,'i_tp_site_id',i_tp_site_id,i_method_name);
966: ecx_debug.log(l_statement,'i_tp_type',i_tp_type,i_method_name);
967: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name);
968: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name);
969: end if;
970:
971: /** check for the Event Object. If null , initialize it **/
964: ecx_debug.log(l_statement,'i_tp_id',i_tp_id,i_method_name);
965: ecx_debug.log(l_statement,'i_tp_site_id',i_tp_site_id,i_method_name);
966: ecx_debug.log(l_statement,'i_tp_type',i_tp_type,i_method_name);
967: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name);
968: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name);
969: end if;
970:
971: /** check for the Event Object. If null , initialize it **/
972: if ecx_utils.g_event is null
979: then
980: for i in i_parameterList.FIRST..i_parameterList.LAST
981: loop
982: i_parameter := i_parameterList(i);
983: ecx_debug.log(l_statement,i_parameter.getName(),i_parameter.getValue(),i_method_name);
984: end loop;
985: end if;
986: end if;
987:
1001:
1002: ecx_utils.g_standard_id := i_standard_id;
1003: exception
1004: when others then
1005: ecx_debug.setErrorInfo(1, 30, 'ECX_CODE_CONVERSION_DISABLED',
1006: 'MESSAGE_STANDARD', i_message_standard);
1007: if(l_statementEnabled) then
1008: ecx_debug.log(l_statement,'ECX', 'ECX_CODE_CONVERSION_DISABLED',i_method_name,
1009: 'MESSAGE_STANDARD', i_message_standard);
1004: when others then
1005: ecx_debug.setErrorInfo(1, 30, 'ECX_CODE_CONVERSION_DISABLED',
1006: 'MESSAGE_STANDARD', i_message_standard);
1007: if(l_statementEnabled) then
1008: ecx_debug.log(l_statement,'ECX', 'ECX_CODE_CONVERSION_DISABLED',i_method_name,
1009: 'MESSAGE_STANDARD', i_message_standard);
1010: end if;
1011: end;
1012:
1017: from ecx_mappings
1018: where map_code = i_map_code;
1019: exception
1020: when others then
1021: ecx_debug.setErrorInfo(1, 30, 'ECX_MAP_NOT_FOUND', 'MAP_CODE', i_map_code);
1022: if(l_unexpectedEnabled) then
1023: ecx_debug.log(l_unexpected,'ECX', 'ECX_MAP_NOT_FOUND', i_method_name,'MAP_CODE', i_map_code);
1024: end if;
1025: raise ecx_utils.program_exit;
1019: exception
1020: when others then
1021: ecx_debug.setErrorInfo(1, 30, 'ECX_MAP_NOT_FOUND', 'MAP_CODE', i_map_code);
1022: if(l_unexpectedEnabled) then
1023: ecx_debug.log(l_unexpected,'ECX', 'ECX_MAP_NOT_FOUND', i_method_name,'MAP_CODE', i_map_code);
1024: end if;
1025: raise ecx_utils.program_exit;
1026: end;
1027:
1037: /** Set the GLobal g_rcv_tp_id **/
1038: ecx_utils.g_rec_tp_id:= i_tp_header_id;
1039: exception
1040: when others then
1041: ecx_debug.setErrorInfo(1, 30, 'ECX_TP_NOT_FOUND', 'PARTY_ID', i_tp_id);
1042: if(l_statementEnabled) then
1043: ecx_debug.log(l_statement,'ECX', 'ECX_TP_NOT_FOUND', i_method_name,'PARTY_ID', i_tp_id);
1044: end if;
1045: end;
1039: exception
1040: when others then
1041: ecx_debug.setErrorInfo(1, 30, 'ECX_TP_NOT_FOUND', 'PARTY_ID', i_tp_id);
1042: if(l_statementEnabled) then
1043: ecx_debug.log(l_statement,'ECX', 'ECX_TP_NOT_FOUND', i_method_name,'PARTY_ID', i_tp_id);
1044: end if;
1045: end;
1046:
1047: begin
1054: and eo.object_type in ('DTD','XML')
1055: and eo.object_id = 2;
1056: exception
1057: when others then
1058: ecx_debug.setErrorInfo(1, 30, 'ECX_ROOT_ELEMENT_NOT_FOUND', 'MAP_ID', i_map_id);
1059: if(l_unexpectedEnabled) then
1060: ecx_debug.log(l_unexpected,'ECX', 'ECX_ROOT_ELEMENT_NOT_FOUND',i_method_name, 'MAP_ID', i_map_id);
1061: end if;
1062: raise ecx_utils.program_exit;
1056: exception
1057: when others then
1058: ecx_debug.setErrorInfo(1, 30, 'ECX_ROOT_ELEMENT_NOT_FOUND', 'MAP_ID', i_map_id);
1059: if(l_unexpectedEnabled) then
1060: ecx_debug.log(l_unexpected,'ECX', 'ECX_ROOT_ELEMENT_NOT_FOUND',i_method_name, 'MAP_ID', i_map_id);
1061: end if;
1062: raise ecx_utils.program_exit;
1063: end;
1064:
1236: /** DOCUMENT NODE **/
1237: if (not ecx_utils.g_delete_doctype) then
1238: ecx_print_local.document_node(i_root_element,i_filename,null);
1239: if(l_statementEnabled) then
1240: ecx_debug.log(l_statement, 'Printed DOCTYPE', i_method_name);
1241: end if;
1242: end if;
1243:
1244: fetch_data_from_view (0);
1246: ecx_print_local.xmlPOPALL(i_xmldoc);
1247:
1248: ecx_util_api.parseXML(ecx_utils.g_parser, i_xmldoc, l_parseXML, ecx_utils.g_xmldoc);
1249: if(l_statementEnabled) then
1250: ecx_debug.log(l_statement, 'Parsed XML', l_parseXML,i_method_name);
1251: end if;
1252:
1253: -- Post-Processing for the Document on Target Side
1254: ecx_actions.execute_stage_data
1276: if (l_statementEnabled)
1277: then
1278: IF g_instlmode = 'EMBEDDED' THEN
1279: fnd_message.set_name('ecx', 'XML File for logging');
1280: attachment_id := fnd_log.message_with_attachment(fnd_log.level_statement, substr(ecx_debug.g_aflog_module_name,1,length(ecx_debug.g_aflog_module_name)-4)||'.xml', TRUE);
1281: if(attachment_id <> -1 AND i_xmldoc is not null) then
1282: clength := dbms_lob.getlength(i_xmldoc);
1283: while clength >= offset LOOP
1284: ctemp := dbms_lob.substr(i_xmldoc,g_varmaxlength,offset);
1297:
1298: if(l_statementEnabled) then
1299: ecx_outbound.log_summary(l_statement);
1300:
1301: ecx_debug.log(l_statement,'ECX','ECX_DOCUMENTS_PROCESSED',i_method_name,'NO_OF_DOCS',
1302: ecx_utils.g_source_levels(0).rows_processed);
1303: ecx_debug.log(l_statement,'ECX','ECX_FINISH_OUTBOUND',i_method_name,'MAP_ID',i_map_id);
1304: end if;
1305:
1299: ecx_outbound.log_summary(l_statement);
1300:
1301: ecx_debug.log(l_statement,'ECX','ECX_DOCUMENTS_PROCESSED',i_method_name,'NO_OF_DOCS',
1302: ecx_utils.g_source_levels(0).rows_processed);
1303: ecx_debug.log(l_statement,'ECX','ECX_FINISH_OUTBOUND',i_method_name,'MAP_ID',i_map_id);
1304: end if;
1305:
1306: if not XMLDom.isNull(ecx_utils.g_xmldoc) then
1307: i_node_type := xmlDOM.getNodeType(ecx_utils.g_xmldoc);
1312: end if;
1313: xmlparser.freeparser(ecx_utils.g_parser);
1314: end if;
1315: if (l_procedureEnabled) then
1316: ecx_debug.pop(i_method_name );
1317: end if;
1318:
1319: EXCEPTION
1320: WHEN ecx_utils.PROGRAM_EXIT then
1318:
1319: EXCEPTION
1320: WHEN ecx_utils.PROGRAM_EXIT then
1321: if(l_unexpectedEnabled) then
1322: ecx_debug.log(l_unexpected, 'Clean-up i_stack, l_node_stack, i_tmpxml and last_printed',
1323: i_method_name);
1324: ecx_outbound.log_summary(l_unexpected);
1325: end if;
1326: i_stack.DELETE;
1327: ecx_print_local.i_tmpxml.DELETE;
1328: ecx_print_local.l_node_stack.DELETE;
1329: ecx_print_local.last_printed := -1;
1330: if (l_procedureEnabled) then
1331: ecx_debug.pop(i_method_name );
1332: end if;
1333: raise ecx_utils.program_exit;
1334: WHEN OTHERS THEN
1335: if(l_unexpectedEnabled) then
1332: end if;
1333: raise ecx_utils.program_exit;
1334: WHEN OTHERS THEN
1335: if(l_unexpectedEnabled) then
1336: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
1337: 'ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');
1338: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1339: ecx_outbound.log_summary(l_unexpected);
1340: end if;
1334: WHEN OTHERS THEN
1335: if(l_unexpectedEnabled) then
1336: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
1337: 'ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');
1338: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1339: ecx_outbound.log_summary(l_unexpected);
1340: end if;
1341: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');
1342: if(l_unexpectedEnabled) then
1337: 'ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');
1338: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1339: ecx_outbound.log_summary(l_unexpected);
1340: end if;
1341: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');
1342: if(l_unexpectedEnabled) then
1343: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS',i_method_name);
1344: ecx_debug.log(l_unexpected, 'Clean-up i_stack, l_node_stack, i_tmpxml and last_printed',i_method_name);
1345: end if;
1339: ecx_outbound.log_summary(l_unexpected);
1340: end if;
1341: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');
1342: if(l_unexpectedEnabled) then
1343: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS',i_method_name);
1344: ecx_debug.log(l_unexpected, 'Clean-up i_stack, l_node_stack, i_tmpxml and last_printed',i_method_name);
1345: end if;
1346: i_stack.DELETE;
1347: ecx_print_local.i_tmpxml.DELETE;
1340: end if;
1341: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');
1342: if(l_unexpectedEnabled) then
1343: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS',i_method_name);
1344: ecx_debug.log(l_unexpected, 'Clean-up i_stack, l_node_stack, i_tmpxml and last_printed',i_method_name);
1345: end if;
1346: i_stack.DELETE;
1347: ecx_print_local.i_tmpxml.DELETE;
1348: ecx_print_local.l_node_stack.DELETE;
1347: ecx_print_local.i_tmpxml.DELETE;
1348: ecx_print_local.l_node_stack.DELETE;
1349: ecx_print_local.last_printed := -1;
1350: if (l_procedureEnabled) then
1351: ecx_debug.pop(i_method_name );
1352: end if;
1353: raise ecx_utils.PROGRAM_EXIT;
1354: end process_outbound_documents;
1355:
1438: p_aflog_module_name := p_aflog_module_name||ecx_utils.g_run_id;
1439: END IF;
1440: p_aflog_module_name := p_aflog_module_name||'.log';
1441:
1442: ecx_debug.enable_debug_new(i_debug_level,ecx_utils.g_logdir,ecx_utils.g_logfile, p_aflog_module_name);
1443: end if;
1444:
1445: -- Assign local variables with the ecx_debug global variables
1446: l_procedure := ecx_debug.g_procedure;
1441:
1442: ecx_debug.enable_debug_new(i_debug_level,ecx_utils.g_logdir,ecx_utils.g_logfile, p_aflog_module_name);
1443: end if;
1444:
1445: -- Assign local variables with the ecx_debug global variables
1446: l_procedure := ecx_debug.g_procedure;
1447: l_statement := ecx_debug.g_statement;
1448: l_unexpected := ecx_debug.g_unexpected;
1449: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1442: ecx_debug.enable_debug_new(i_debug_level,ecx_utils.g_logdir,ecx_utils.g_logfile, p_aflog_module_name);
1443: end if;
1444:
1445: -- Assign local variables with the ecx_debug global variables
1446: l_procedure := ecx_debug.g_procedure;
1447: l_statement := ecx_debug.g_statement;
1448: l_unexpected := ecx_debug.g_unexpected;
1449: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1450: l_statementEnabled := ecx_debug.g_statementEnabled;
1443: end if;
1444:
1445: -- Assign local variables with the ecx_debug global variables
1446: l_procedure := ecx_debug.g_procedure;
1447: l_statement := ecx_debug.g_statement;
1448: l_unexpected := ecx_debug.g_unexpected;
1449: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1450: l_statementEnabled := ecx_debug.g_statementEnabled;
1451: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1444:
1445: -- Assign local variables with the ecx_debug global variables
1446: l_procedure := ecx_debug.g_procedure;
1447: l_statement := ecx_debug.g_statement;
1448: l_unexpected := ecx_debug.g_unexpected;
1449: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1450: l_statementEnabled := ecx_debug.g_statementEnabled;
1451: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1452:
1445: -- Assign local variables with the ecx_debug global variables
1446: l_procedure := ecx_debug.g_procedure;
1447: l_statement := ecx_debug.g_statement;
1448: l_unexpected := ecx_debug.g_unexpected;
1449: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1450: l_statementEnabled := ecx_debug.g_statementEnabled;
1451: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1452:
1453: if (l_procedureEnabled) then
1446: l_procedure := ecx_debug.g_procedure;
1447: l_statement := ecx_debug.g_statement;
1448: l_unexpected := ecx_debug.g_unexpected;
1449: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1450: l_statementEnabled := ecx_debug.g_statementEnabled;
1451: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1452:
1453: if (l_procedureEnabled) then
1454: ecx_debug.push(i_method_name);
1447: l_statement := ecx_debug.g_statement;
1448: l_unexpected := ecx_debug.g_unexpected;
1449: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1450: l_statementEnabled := ecx_debug.g_statementEnabled;
1451: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1452:
1453: if (l_procedureEnabled) then
1454: ecx_debug.push(i_method_name);
1455: end if;
1450: l_statementEnabled := ecx_debug.g_statementEnabled;
1451: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1452:
1453: if (l_procedureEnabled) then
1454: ecx_debug.push(i_method_name);
1455: end if;
1456:
1457: if(l_statementEnabled) then
1458: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name );
1454: ecx_debug.push(i_method_name);
1455: end if;
1456:
1457: if(l_statementEnabled) then
1458: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name );
1459: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name );
1460: ecx_debug.log(l_statement,'i_party_id',i_party_id,i_method_name );
1461: ecx_debug.log(l_statement,'i_party_site_id',i_party_site_id,i_method_name );
1462: ecx_debug.log(l_statement,'i_party_type',i_party_type,i_method_name );
1455: end if;
1456:
1457: if(l_statementEnabled) then
1458: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name );
1459: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name );
1460: ecx_debug.log(l_statement,'i_party_id',i_party_id,i_method_name );
1461: ecx_debug.log(l_statement,'i_party_site_id',i_party_site_id,i_method_name );
1462: ecx_debug.log(l_statement,'i_party_type',i_party_type,i_method_name );
1463: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name );
1456:
1457: if(l_statementEnabled) then
1458: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name );
1459: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name );
1460: ecx_debug.log(l_statement,'i_party_id',i_party_id,i_method_name );
1461: ecx_debug.log(l_statement,'i_party_site_id',i_party_site_id,i_method_name );
1462: ecx_debug.log(l_statement,'i_party_type',i_party_type,i_method_name );
1463: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name );
1464: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name );
1457: if(l_statementEnabled) then
1458: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name );
1459: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name );
1460: ecx_debug.log(l_statement,'i_party_id',i_party_id,i_method_name );
1461: ecx_debug.log(l_statement,'i_party_site_id',i_party_site_id,i_method_name );
1462: ecx_debug.log(l_statement,'i_party_type',i_party_type,i_method_name );
1463: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name );
1464: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name );
1465: ecx_debug.log(l_statement,'i_message_type',i_message_type,i_method_name );
1458: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name );
1459: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name );
1460: ecx_debug.log(l_statement,'i_party_id',i_party_id,i_method_name );
1461: ecx_debug.log(l_statement,'i_party_site_id',i_party_site_id,i_method_name );
1462: ecx_debug.log(l_statement,'i_party_type',i_party_type,i_method_name );
1463: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name );
1464: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name );
1465: ecx_debug.log(l_statement,'i_message_type',i_message_type,i_method_name );
1466: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name );
1459: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name );
1460: ecx_debug.log(l_statement,'i_party_id',i_party_id,i_method_name );
1461: ecx_debug.log(l_statement,'i_party_site_id',i_party_site_id,i_method_name );
1462: ecx_debug.log(l_statement,'i_party_type',i_party_type,i_method_name );
1463: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name );
1464: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name );
1465: ecx_debug.log(l_statement,'i_message_type',i_message_type,i_method_name );
1466: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name );
1467: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name );
1460: ecx_debug.log(l_statement,'i_party_id',i_party_id,i_method_name );
1461: ecx_debug.log(l_statement,'i_party_site_id',i_party_site_id,i_method_name );
1462: ecx_debug.log(l_statement,'i_party_type',i_party_type,i_method_name );
1463: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name );
1464: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name );
1465: ecx_debug.log(l_statement,'i_message_type',i_message_type,i_method_name );
1466: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name );
1467: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name );
1468: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name );
1461: ecx_debug.log(l_statement,'i_party_site_id',i_party_site_id,i_method_name );
1462: ecx_debug.log(l_statement,'i_party_type',i_party_type,i_method_name );
1463: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name );
1464: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name );
1465: ecx_debug.log(l_statement,'i_message_type',i_message_type,i_method_name );
1466: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name );
1467: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name );
1468: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name );
1469: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name );
1462: ecx_debug.log(l_statement,'i_party_type',i_party_type,i_method_name );
1463: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name );
1464: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name );
1465: ecx_debug.log(l_statement,'i_message_type',i_message_type,i_method_name );
1466: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name );
1467: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name );
1468: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name );
1469: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name );
1470: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name );
1463: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name );
1464: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name );
1465: ecx_debug.log(l_statement,'i_message_type',i_message_type,i_method_name );
1466: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name );
1467: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name );
1468: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name );
1469: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name );
1470: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name );
1471: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name );
1464: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name );
1465: ecx_debug.log(l_statement,'i_message_type',i_message_type,i_method_name );
1466: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name );
1467: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name );
1468: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name );
1469: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name );
1470: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name );
1471: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name );
1472: ecx_debug.log(l_statement,'i_username',i_username,i_method_name );
1465: ecx_debug.log(l_statement,'i_message_type',i_message_type,i_method_name );
1466: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name );
1467: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name );
1468: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name );
1469: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name );
1470: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name );
1471: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name );
1472: ecx_debug.log(l_statement,'i_username',i_username,i_method_name );
1473: ecx_debug.log(l_statement,'i_password',i_password,i_method_name );
1466: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name );
1467: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name );
1468: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name );
1469: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name );
1470: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name );
1471: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name );
1472: ecx_debug.log(l_statement,'i_username',i_username,i_method_name );
1473: ecx_debug.log(l_statement,'i_password',i_password,i_method_name );
1474: ecx_debug.log(l_statement,'i_attribute1',i_attribute1,i_method_name );
1467: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name );
1468: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name );
1469: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name );
1470: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name );
1471: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name );
1472: ecx_debug.log(l_statement,'i_username',i_username,i_method_name );
1473: ecx_debug.log(l_statement,'i_password',i_password,i_method_name );
1474: ecx_debug.log(l_statement,'i_attribute1',i_attribute1,i_method_name );
1475: ecx_debug.log(l_statement,'i_attribute2',i_attribute2,i_method_name );
1468: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name );
1469: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name );
1470: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name );
1471: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name );
1472: ecx_debug.log(l_statement,'i_username',i_username,i_method_name );
1473: ecx_debug.log(l_statement,'i_password',i_password,i_method_name );
1474: ecx_debug.log(l_statement,'i_attribute1',i_attribute1,i_method_name );
1475: ecx_debug.log(l_statement,'i_attribute2',i_attribute2,i_method_name );
1476: ecx_debug.log(l_statement,'i_attribute3',i_attribute3,i_method_name );
1469: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name );
1470: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name );
1471: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name );
1472: ecx_debug.log(l_statement,'i_username',i_username,i_method_name );
1473: ecx_debug.log(l_statement,'i_password',i_password,i_method_name );
1474: ecx_debug.log(l_statement,'i_attribute1',i_attribute1,i_method_name );
1475: ecx_debug.log(l_statement,'i_attribute2',i_attribute2,i_method_name );
1476: ecx_debug.log(l_statement,'i_attribute3',i_attribute3,i_method_name );
1477: ecx_debug.log(l_statement,'i_attribute4',i_attribute4,i_method_name );
1470: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name );
1471: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name );
1472: ecx_debug.log(l_statement,'i_username',i_username,i_method_name );
1473: ecx_debug.log(l_statement,'i_password',i_password,i_method_name );
1474: ecx_debug.log(l_statement,'i_attribute1',i_attribute1,i_method_name );
1475: ecx_debug.log(l_statement,'i_attribute2',i_attribute2,i_method_name );
1476: ecx_debug.log(l_statement,'i_attribute3',i_attribute3,i_method_name );
1477: ecx_debug.log(l_statement,'i_attribute4',i_attribute4,i_method_name );
1478: ecx_debug.log(l_statement,'i_attribute5',i_attribute5,i_method_name );
1471: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name );
1472: ecx_debug.log(l_statement,'i_username',i_username,i_method_name );
1473: ecx_debug.log(l_statement,'i_password',i_password,i_method_name );
1474: ecx_debug.log(l_statement,'i_attribute1',i_attribute1,i_method_name );
1475: ecx_debug.log(l_statement,'i_attribute2',i_attribute2,i_method_name );
1476: ecx_debug.log(l_statement,'i_attribute3',i_attribute3,i_method_name );
1477: ecx_debug.log(l_statement,'i_attribute4',i_attribute4,i_method_name );
1478: ecx_debug.log(l_statement,'i_attribute5',i_attribute5,i_method_name );
1479: end if;
1472: ecx_debug.log(l_statement,'i_username',i_username,i_method_name );
1473: ecx_debug.log(l_statement,'i_password',i_password,i_method_name );
1474: ecx_debug.log(l_statement,'i_attribute1',i_attribute1,i_method_name );
1475: ecx_debug.log(l_statement,'i_attribute2',i_attribute2,i_method_name );
1476: ecx_debug.log(l_statement,'i_attribute3',i_attribute3,i_method_name );
1477: ecx_debug.log(l_statement,'i_attribute4',i_attribute4,i_method_name );
1478: ecx_debug.log(l_statement,'i_attribute5',i_attribute5,i_method_name );
1479: end if;
1480:
1473: ecx_debug.log(l_statement,'i_password',i_password,i_method_name );
1474: ecx_debug.log(l_statement,'i_attribute1',i_attribute1,i_method_name );
1475: ecx_debug.log(l_statement,'i_attribute2',i_attribute2,i_method_name );
1476: ecx_debug.log(l_statement,'i_attribute3',i_attribute3,i_method_name );
1477: ecx_debug.log(l_statement,'i_attribute4',i_attribute4,i_method_name );
1478: ecx_debug.log(l_statement,'i_attribute5',i_attribute5,i_method_name );
1479: end if;
1480:
1481: ecx_errorlog.outbound_engine
1474: ecx_debug.log(l_statement,'i_attribute1',i_attribute1,i_method_name );
1475: ecx_debug.log(l_statement,'i_attribute2',i_attribute2,i_method_name );
1476: ecx_debug.log(l_statement,'i_attribute3',i_attribute3,i_method_name );
1477: ecx_debug.log(l_statement,'i_attribute4',i_attribute4,i_method_name );
1478: ecx_debug.log(l_statement,'i_attribute5',i_attribute5,i_method_name );
1479: end if;
1480:
1481: ecx_errorlog.outbound_engine
1482: (
1566: i_from_agt.setsystem(i_system);
1567: ecx_utils.g_event.setFromAgent(i_from_agt);
1568:
1569: if(l_statementEnabled) then
1570: ecx_debug.log(l_statement, 'Calling WF_EVENT.Send for Enqueue', i_method_name);
1571: end if;
1572: wf_event.send(ecx_utils.g_event);
1573: ecx_errorlog.outbound_log(ecx_utils.g_event);
1574:
1582: -- check the retcode and retmsg. This should be populated here only
1583: -- in the case of dup val index when inserting in doclogs (since no
1584: -- exception is raised in this case)
1585: if (ecx_out_wf_qh.retmsg is not null) then
1586: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode, 30, ecx_out_wf_qh.retmsg);
1587: if(l_unexpectedEnabled) then
1588: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
1589: end if;
1590: end if;
1584: -- exception is raised in this case)
1585: if (ecx_out_wf_qh.retmsg is not null) then
1586: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode, 30, ecx_out_wf_qh.retmsg);
1587: if(l_unexpectedEnabled) then
1588: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
1589: end if;
1590: end if;
1591:
1592: if dbms_lob.istemporary(i_xmldoc) = 1 then
1593: dbms_lob.freetemporary(i_xmldoc);
1594: end if;
1595:
1596: if(l_statementEnabled) then
1597: ecx_debug.log(l_statement,'msgid',i_msgid,i_method_name);
1598: end if;
1599: if (l_procedureEnabled) then
1600: ecx_debug.pop(i_method_name);
1601: end if;
1596: if(l_statementEnabled) then
1597: ecx_debug.log(l_statement,'msgid',i_msgid,i_method_name);
1598: end if;
1599: if (l_procedureEnabled) then
1600: ecx_debug.pop(i_method_name);
1601: end if;
1602:
1603: if NOT ( i_direct )
1604: then
1601: end if;
1602:
1603: if NOT ( i_direct )
1604: then
1605: ecx_debug.print_log;
1606: ecx_debug.disable_debug;
1607: ecx_utils.g_logfile:=null;
1608: end if;
1609:
1602:
1603: if NOT ( i_direct )
1604: then
1605: ecx_debug.print_log;
1606: ecx_debug.disable_debug;
1607: ecx_utils.g_logfile:=null;
1608: end if;
1609:
1610: EXCEPTION
1612: if dbms_lob.istemporary(i_xmldoc) = 1 then
1613: dbms_lob.freetemporary(i_xmldoc);
1614: end if;
1615: if (l_procedureEnabled) then
1616: ecx_debug.pop(i_method_name);
1617: end if;
1618: if NOT ( i_direct )
1619: then
1620: ecx_debug.print_log;
1616: ecx_debug.pop(i_method_name);
1617: end if;
1618: if NOT ( i_direct )
1619: then
1620: ecx_debug.print_log;
1621: ecx_debug.disable_debug;
1622: ecx_utils.g_logfile:=null;
1623:
1624: ecx_errorlog.outbound_engine
1617: end if;
1618: if NOT ( i_direct )
1619: then
1620: ecx_debug.print_log;
1621: ecx_debug.disable_debug;
1622: ecx_utils.g_logfile:=null;
1623:
1624: ecx_errorlog.outbound_engine
1625: (
1637:
1638: WHEN OTHERS THEN
1639: if (ecx_out_wf_qh.retmsg is null AND ecx_out_wf_qh.retcode = 0)
1640: then
1641: ecx_debug.setErrorInfo(2, 30, SQLERRM);
1642: if(l_unexpectedEnabled) then
1643: ecx_debug.log(l_unexpected, 'ECX', SQLERRM,i_method_name);
1644: end if;
1645: else
1639: if (ecx_out_wf_qh.retmsg is null AND ecx_out_wf_qh.retcode = 0)
1640: then
1641: ecx_debug.setErrorInfo(2, 30, SQLERRM);
1642: if(l_unexpectedEnabled) then
1643: ecx_debug.log(l_unexpected, 'ECX', SQLERRM,i_method_name);
1644: end if;
1645: else
1646: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode, 30, ecx_out_wf_qh.retmsg);
1647: if(l_unexpectedEnabled) then
1642: if(l_unexpectedEnabled) then
1643: ecx_debug.log(l_unexpected, 'ECX', SQLERRM,i_method_name);
1644: end if;
1645: else
1646: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode, 30, ecx_out_wf_qh.retmsg);
1647: if(l_unexpectedEnabled) then
1648: ecx_debug.log(l_unexpected, 'msg and code set in queue handler',i_method_name);
1649: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1650: end if;
1644: end if;
1645: else
1646: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode, 30, ecx_out_wf_qh.retmsg);
1647: if(l_unexpectedEnabled) then
1648: ecx_debug.log(l_unexpected, 'msg and code set in queue handler',i_method_name);
1649: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1650: end if;
1651: end if;
1652:
1645: else
1646: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode, 30, ecx_out_wf_qh.retmsg);
1647: if(l_unexpectedEnabled) then
1648: ecx_debug.log(l_unexpected, 'msg and code set in queue handler',i_method_name);
1649: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1650: end if;
1651: end if;
1652:
1653: if dbms_lob.istemporary(i_xmldoc) = 1 then
1654: dbms_lob.freetemporary(i_xmldoc);
1655: end if;
1656:
1657: if (l_procedureEnabled) then
1658: ecx_debug.pop(i_method_name);
1659: end if;
1660: if NOT ( i_direct )
1661: then
1662: IF (ecx_logging_enabled ) THEN
1659: end if;
1660: if NOT ( i_direct )
1661: then
1662: IF (ecx_logging_enabled ) THEN
1663: ecx_debug.print_log;
1664: ecx_debug.disable_debug;
1665: ecx_utils.g_logfile:=null;
1666: END IF;
1667: ecx_errorlog.outbound_engine
1660: if NOT ( i_direct )
1661: then
1662: IF (ecx_logging_enabled ) THEN
1663: ecx_debug.print_log;
1664: ecx_debug.disable_debug;
1665: ecx_utils.g_logfile:=null;
1666: END IF;
1667: ecx_errorlog.outbound_engine
1668: (
1721: logging_enabled varchar2(20);
1722: module varchar2(2000);
1723:
1724: begin
1725: --To populate the global variable ecx_debug.g_v_module_name , need to call ecx_debug.module_enabled
1726: ecx_debug.g_v_module_name := 'ecx.plsql.';
1727: ecx_debug.module_enabled(i_message_standard,i_transaction_type,i_transaction_subtype,i_document_id);
1728: fnd_profile.get('AFLOG_ENABLED',logging_enabled);
1729: fnd_profile.get('AFLOG_MODULE',module);
1722: module varchar2(2000);
1723:
1724: begin
1725: --To populate the global variable ecx_debug.g_v_module_name , need to call ecx_debug.module_enabled
1726: ecx_debug.g_v_module_name := 'ecx.plsql.';
1727: ecx_debug.module_enabled(i_message_standard,i_transaction_type,i_transaction_subtype,i_document_id);
1728: fnd_profile.get('AFLOG_ENABLED',logging_enabled);
1729: fnd_profile.get('AFLOG_MODULE',module);
1730: if(logging_enabled = 'Y' AND ((lower(module) like 'ecx%'
1723:
1724: begin
1725: --To populate the global variable ecx_debug.g_v_module_name , need to call ecx_debug.module_enabled
1726: ecx_debug.g_v_module_name := 'ecx.plsql.';
1727: ecx_debug.module_enabled(i_message_standard,i_transaction_type,i_transaction_subtype,i_document_id);
1728: fnd_profile.get('AFLOG_ENABLED',logging_enabled);
1729: fnd_profile.get('AFLOG_MODULE',module);
1730: if(logging_enabled = 'Y' AND ((lower(module) like 'ecx%'
1731: AND instr(lower(ecx_debug.g_v_module_name),rtrim(lower(module),'%'))> 0)
1727: ecx_debug.module_enabled(i_message_standard,i_transaction_type,i_transaction_subtype,i_document_id);
1728: fnd_profile.get('AFLOG_ENABLED',logging_enabled);
1729: fnd_profile.get('AFLOG_MODULE',module);
1730: if(logging_enabled = 'Y' AND ((lower(module) like 'ecx%'
1731: AND instr(lower(ecx_debug.g_v_module_name),rtrim(lower(module),'%'))> 0)
1732: OR module='%')
1733: AND FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) then
1734: ecx_logging_enabled := true;
1735: end if;
1780: i_trigger_id ,
1781: i_msgid );
1782: Exception
1783: WHEN OTHERS THEN
1784: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.putmsg ');
1785: if(l_unexpectedEnabled) then
1786: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.putmsg ',
1787: i_method_name);
1788: end if;
1782: Exception
1783: WHEN OTHERS THEN
1784: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.putmsg ');
1785: if(l_unexpectedEnabled) then
1786: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.putmsg ',
1787: i_method_name);
1788: end if;
1789: raise ecx_utils.PROGRAM_EXIT;
1790: end putmsg;
1825: logging_enabled varchar2(20);
1826: module varchar2(2000);
1827:
1828: begin
1829: --To populate the global variable ecx_debug.g_v_module_name , need to call ecx_debug.module_enabled
1830: ecx_debug.g_v_module_name := 'ecx.plsql.';
1831: ecx_debug.module_enabled(i_message_standard,i_transaction_type,i_transaction_subtype,i_document_id);
1832:
1833: g_instlmode := wf_core.translate('WF_INSTALL');
1826: module varchar2(2000);
1827:
1828: begin
1829: --To populate the global variable ecx_debug.g_v_module_name , need to call ecx_debug.module_enabled
1830: ecx_debug.g_v_module_name := 'ecx.plsql.';
1831: ecx_debug.module_enabled(i_message_standard,i_transaction_type,i_transaction_subtype,i_document_id);
1832:
1833: g_instlmode := wf_core.translate('WF_INSTALL');
1834:
1827:
1828: begin
1829: --To populate the global variable ecx_debug.g_v_module_name , need to call ecx_debug.module_enabled
1830: ecx_debug.g_v_module_name := 'ecx.plsql.';
1831: ecx_debug.module_enabled(i_message_standard,i_transaction_type,i_transaction_subtype,i_document_id);
1832:
1833: g_instlmode := wf_core.translate('WF_INSTALL');
1834:
1835: if(g_instlmode = 'EMBEDDED')
1836: then
1837: fnd_profile.get('AFLOG_ENABLED',logging_enabled);
1838: fnd_profile.get('AFLOG_MODULE',module);
1839: if(logging_enabled = 'Y' AND ((lower(module) like 'ecx%'
1840: AND instr(lower(ecx_debug.g_v_module_name),rtrim(lower(module),'%'))> 0)
1841: OR module='%')
1842: AND FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) then
1843: ecx_logging_enabled := true;
1844: end if;
1879: IF (ecx_utils.g_run_id is not null) THEN
1880: p_aflog_module_name := p_aflog_module_name||ecx_utils.g_run_id;
1881: END IF;
1882: p_aflog_module_name := p_aflog_module_name||'.log';
1883: ecx_debug.enable_debug_new(i_debug_level,ecx_utils.g_logdir,ecx_utils.g_logfile, p_aflog_module_name);
1884: END IF;
1885:
1886: IF g_instlmode = 'EMBEDDED' THEN
1887: IF (ecx_logging_enabled ) THEN
1884: END IF;
1885:
1886: IF g_instlmode = 'EMBEDDED' THEN
1887: IF (ecx_logging_enabled ) THEN
1888: i_log_file := ecx_debug.g_sqlprefix || p_aflog_module_name;
1889: ELSE
1890: i_log_file := 'Please ensure that FND-Logging is enabled for module '||ecx_debug.g_sqlprefix||'%';
1891: END IF;
1892: ELSE
1886: IF g_instlmode = 'EMBEDDED' THEN
1887: IF (ecx_logging_enabled ) THEN
1888: i_log_file := ecx_debug.g_sqlprefix || p_aflog_module_name;
1889: ELSE
1890: i_log_file := 'Please ensure that FND-Logging is enabled for module '||ecx_debug.g_sqlprefix||'%';
1891: END IF;
1892: ELSE
1893: if (ecx_logging_enabled) then
1894: i_log_file := ecx_utils.g_logdir||ecx_utils.getFileSeparator()||ecx_utils.g_logfile;
1896: i_log_file := 'Please ensure that logging is enabled';
1897: end if;
1898: END IF;
1899:
1900: /* Assign local variables with the ecx_debug global variables*/
1901: l_procedure := ecx_debug.g_procedure;
1902: l_statement := ecx_debug.g_statement;
1903: l_unexpected := ecx_debug.g_unexpected;
1904: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1897: end if;
1898: END IF;
1899:
1900: /* Assign local variables with the ecx_debug global variables*/
1901: l_procedure := ecx_debug.g_procedure;
1902: l_statement := ecx_debug.g_statement;
1903: l_unexpected := ecx_debug.g_unexpected;
1904: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1905: l_statementEnabled := ecx_debug.g_statementEnabled;
1898: END IF;
1899:
1900: /* Assign local variables with the ecx_debug global variables*/
1901: l_procedure := ecx_debug.g_procedure;
1902: l_statement := ecx_debug.g_statement;
1903: l_unexpected := ecx_debug.g_unexpected;
1904: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1905: l_statementEnabled := ecx_debug.g_statementEnabled;
1906: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1899:
1900: /* Assign local variables with the ecx_debug global variables*/
1901: l_procedure := ecx_debug.g_procedure;
1902: l_statement := ecx_debug.g_statement;
1903: l_unexpected := ecx_debug.g_unexpected;
1904: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1905: l_statementEnabled := ecx_debug.g_statementEnabled;
1906: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1907:
1900: /* Assign local variables with the ecx_debug global variables*/
1901: l_procedure := ecx_debug.g_procedure;
1902: l_statement := ecx_debug.g_statement;
1903: l_unexpected := ecx_debug.g_unexpected;
1904: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1905: l_statementEnabled := ecx_debug.g_statementEnabled;
1906: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1907:
1908: if (l_procedureEnabled) then
1901: l_procedure := ecx_debug.g_procedure;
1902: l_statement := ecx_debug.g_statement;
1903: l_unexpected := ecx_debug.g_unexpected;
1904: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1905: l_statementEnabled := ecx_debug.g_statementEnabled;
1906: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1907:
1908: if (l_procedureEnabled) then
1909: ecx_debug.push(i_method_name);
1902: l_statement := ecx_debug.g_statement;
1903: l_unexpected := ecx_debug.g_unexpected;
1904: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1905: l_statementEnabled := ecx_debug.g_statementEnabled;
1906: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1907:
1908: if (l_procedureEnabled) then
1909: ecx_debug.push(i_method_name);
1910: end if;
1905: l_statementEnabled := ecx_debug.g_statementEnabled;
1906: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1907:
1908: if (l_procedureEnabled) then
1909: ecx_debug.push(i_method_name);
1910: end if;
1911:
1912: if(l_statementEnabled) then
1913: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name );
1909: ecx_debug.push(i_method_name);
1910: end if;
1911:
1912: if(l_statementEnabled) then
1913: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name );
1914: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name );
1915: ecx_debug.log(l_statement,'i_tp_id',i_tp_id,i_method_name );
1916: ecx_debug.log(l_statement,'i_tp_site_id',i_tp_site_id,i_method_name );
1917: ecx_debug.log(l_statement,'i_tp_type',i_tp_type,i_method_name );
1910: end if;
1911:
1912: if(l_statementEnabled) then
1913: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name );
1914: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name );
1915: ecx_debug.log(l_statement,'i_tp_id',i_tp_id,i_method_name );
1916: ecx_debug.log(l_statement,'i_tp_site_id',i_tp_site_id,i_method_name );
1917: ecx_debug.log(l_statement,'i_tp_type',i_tp_type,i_method_name );
1918: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name );
1911:
1912: if(l_statementEnabled) then
1913: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name );
1914: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name );
1915: ecx_debug.log(l_statement,'i_tp_id',i_tp_id,i_method_name );
1916: ecx_debug.log(l_statement,'i_tp_site_id',i_tp_site_id,i_method_name );
1917: ecx_debug.log(l_statement,'i_tp_type',i_tp_type,i_method_name );
1918: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name );
1919: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name );
1912: if(l_statementEnabled) then
1913: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name );
1914: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name );
1915: ecx_debug.log(l_statement,'i_tp_id',i_tp_id,i_method_name );
1916: ecx_debug.log(l_statement,'i_tp_site_id',i_tp_site_id,i_method_name );
1917: ecx_debug.log(l_statement,'i_tp_type',i_tp_type,i_method_name );
1918: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name );
1919: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name );
1920: end if;
1913: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name );
1914: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name );
1915: ecx_debug.log(l_statement,'i_tp_id',i_tp_id,i_method_name );
1916: ecx_debug.log(l_statement,'i_tp_site_id',i_tp_site_id,i_method_name );
1917: ecx_debug.log(l_statement,'i_tp_type',i_tp_type,i_method_name );
1918: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name );
1919: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name );
1920: end if;
1921: -- initialize i_tmpxmldoc
1914: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name );
1915: ecx_debug.log(l_statement,'i_tp_id',i_tp_id,i_method_name );
1916: ecx_debug.log(l_statement,'i_tp_site_id',i_tp_site_id,i_method_name );
1917: ecx_debug.log(l_statement,'i_tp_type',i_tp_type,i_method_name );
1918: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name );
1919: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name );
1920: end if;
1921: -- initialize i_tmpxmldoc
1922: dbms_lob.createtemporary(i_tmpxmldoc,TRUE,DBMS_LOB.SESSION);
1915: ecx_debug.log(l_statement,'i_tp_id',i_tp_id,i_method_name );
1916: ecx_debug.log(l_statement,'i_tp_site_id',i_tp_site_id,i_method_name );
1917: ecx_debug.log(l_statement,'i_tp_type',i_tp_type,i_method_name );
1918: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name );
1919: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name );
1920: end if;
1921: -- initialize i_tmpxmldoc
1922: dbms_lob.createtemporary(i_tmpxmldoc,TRUE,DBMS_LOB.SESSION);
1923:
1940: if i_tmpxmldoc is not null
1941: then
1942: dbms_lob.freetemporary (i_tmpxmldoc);
1943: end if;
1944: ecx_debug.setErrorInfo(0, 10, 'ECX_SUCCESSFUL_EXECUTION');
1945: i_ret_code := ecx_utils.i_ret_code;
1946: i_errbuf := ecx_utils.i_errbuf;
1947:
1948: if(ecx_utils.i_ret_code = 0 ) then
1946: i_errbuf := ecx_utils.i_errbuf;
1947:
1948: if(ecx_utils.i_ret_code = 0 ) then
1949: if(l_statementEnabled) then
1950: ecx_debug.log(l_statement, 'Ret Code',ecx_utils.i_ret_code,i_method_name);
1951: ecx_debug.log(l_statement, 'Ret Msg ',ecx_utils.i_errbuf,i_method_name);
1952: end if;
1953: else
1954: if(l_unexpectedEnabled) then
1947:
1948: if(ecx_utils.i_ret_code = 0 ) then
1949: if(l_statementEnabled) then
1950: ecx_debug.log(l_statement, 'Ret Code',ecx_utils.i_ret_code,i_method_name);
1951: ecx_debug.log(l_statement, 'Ret Msg ',ecx_utils.i_errbuf,i_method_name);
1952: end if;
1953: else
1954: if(l_unexpectedEnabled) then
1955: ecx_debug.log(l_unexpected, 'Ret Code',ecx_utils.i_ret_code,i_method_name);
1951: ecx_debug.log(l_statement, 'Ret Msg ',ecx_utils.i_errbuf,i_method_name);
1952: end if;
1953: else
1954: if(l_unexpectedEnabled) then
1955: ecx_debug.log(l_unexpected, 'Ret Code',ecx_utils.i_ret_code,i_method_name);
1956: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_utils.i_errbuf,i_method_name);
1957: end if;
1958: end if;
1959:
1952: end if;
1953: else
1954: if(l_unexpectedEnabled) then
1955: ecx_debug.log(l_unexpected, 'Ret Code',ecx_utils.i_ret_code,i_method_name);
1956: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_utils.i_errbuf,i_method_name);
1957: end if;
1958: end if;
1959:
1960: if(l_procedureEnabled) then
1957: end if;
1958: end if;
1959:
1960: if(l_procedureEnabled) then
1961: ecx_debug.pop(i_method_name);
1962: end if;
1963: IF (ecx_logging_enabled ) THEN
1964: ecx_debug.print_log;
1965: ecx_debug.disable_debug;
1960: if(l_procedureEnabled) then
1961: ecx_debug.pop(i_method_name);
1962: end if;
1963: IF (ecx_logging_enabled ) THEN
1964: ecx_debug.print_log;
1965: ecx_debug.disable_debug;
1966: END IF;
1967: EXCEPTION
1968: WHEN ecx_utils.program_exit THEN
1961: ecx_debug.pop(i_method_name);
1962: end if;
1963: IF (ecx_logging_enabled ) THEN
1964: ecx_debug.print_log;
1965: ecx_debug.disable_debug;
1966: END IF;
1967: EXCEPTION
1968: WHEN ecx_utils.program_exit THEN
1969: i_ret_code := ecx_utils.i_ret_code;
1968: WHEN ecx_utils.program_exit THEN
1969: i_ret_code := ecx_utils.i_ret_code;
1970: i_errbuf := ecx_utils.i_errbuf;
1971: if(l_unexpectedEnabled) then
1972: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1973: end if;
1974: if(l_procedureEnabled) then
1975: ecx_debug.pop(i_method_name);
1976: end if;
1971: if(l_unexpectedEnabled) then
1972: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1973: end if;
1974: if(l_procedureEnabled) then
1975: ecx_debug.pop(i_method_name);
1976: end if;
1977: -- free i_tmpxmldoc
1978: if i_tmpxmldoc is not null
1979: then
1979: then
1980: dbms_lob.freetemporary (i_tmpxmldoc);
1981: end if;
1982: IF (ecx_logging_enabled ) THEN
1983: ecx_debug.print_log;
1984: ecx_debug.disable_debug;
1985: END IF;
1986: WHEN OTHERS THEN
1987: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PUTMSG');
1980: dbms_lob.freetemporary (i_tmpxmldoc);
1981: end if;
1982: IF (ecx_logging_enabled ) THEN
1983: ecx_debug.print_log;
1984: ecx_debug.disable_debug;
1985: END IF;
1986: WHEN OTHERS THEN
1987: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PUTMSG');
1988: if(l_unexpectedEnabled) then
1983: ecx_debug.print_log;
1984: ecx_debug.disable_debug;
1985: END IF;
1986: WHEN OTHERS THEN
1987: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PUTMSG');
1988: if(l_unexpectedEnabled) then
1989: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.PUTMSG',i_method_name);
1990: end if;
1991: i_ret_code := ecx_utils.i_ret_code;
1985: END IF;
1986: WHEN OTHERS THEN
1987: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PUTMSG');
1988: if(l_unexpectedEnabled) then
1989: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.PUTMSG',i_method_name);
1990: end if;
1991: i_ret_code := ecx_utils.i_ret_code;
1992: i_errbuf := ecx_utils.i_errbuf;
1993: if(l_procedureEnabled) then
1990: end if;
1991: i_ret_code := ecx_utils.i_ret_code;
1992: i_errbuf := ecx_utils.i_errbuf;
1993: if(l_procedureEnabled) then
1994: ecx_debug.pop(i_method_name);
1995: end if;
1996: -- free i_tmpxmldoc
1997: if i_tmpxmldoc is not null
1998: then
1998: then
1999: dbms_lob.freetemporary (i_tmpxmldoc);
2000: end if;
2001: IF (ecx_logging_enabled ) THEN
2002: ecx_debug.print_log;
2003: ecx_debug.disable_debug;
2004: END IF;
2005: end GETXML;
2006:
1999: dbms_lob.freetemporary (i_tmpxmldoc);
2000: end if;
2001: IF (ecx_logging_enabled ) THEN
2002: ecx_debug.print_log;
2003: ecx_debug.disable_debug;
2004: END IF;
2005: end GETXML;
2006:
2007: end ecx_outbound;