[Home] [Help]
1: PACKAGE BODY ecx_outbound as
2: -- $Header: ECXOUBXB.pls 120.14 2011/03/14 09:38:30 jmaddila 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.14 2011/03/14 09:38:30 jmaddila 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.14 2011/03/14 09:38:30 jmaddila 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:
665: i_len pls_integer;
666: l_temp VARCHAR2(32767);
667: BEGIN
668: IF (l_procedureEnabled) THEN
669: ecx_debug.push(i_method_name );
670: END IF;
671: IF(l_statementEnabled) THEN
672: ecx_debug.log(l_statement,'i_level',i_level,i_method_name);
673: ecx_debug.log(l_statement,'Source level',ecx_utils.g_source_levels.COUNT,i_method_name);
668: IF (l_procedureEnabled) THEN
669: ecx_debug.push(i_method_name );
670: END IF;
671: IF(l_statementEnabled) THEN
672: ecx_debug.log(l_statement,'i_level',i_level,i_method_name);
673: ecx_debug.log(l_statement,'Source level',ecx_utils.g_source_levels.COUNT,i_method_name);
674: ecx_debug.log(l_statement,'target_source_levels',ecx_utils.g_target_source_levels.COUNT,i_method_name);
675: END IF;
676: -- push root element on stack
669: ecx_debug.push(i_method_name );
670: END IF;
671: IF(l_statementEnabled) THEN
672: ecx_debug.log(l_statement,'i_level',i_level,i_method_name);
673: ecx_debug.log(l_statement,'Source level',ecx_utils.g_source_levels.COUNT,i_method_name);
674: ecx_debug.log(l_statement,'target_source_levels',ecx_utils.g_target_source_levels.COUNT,i_method_name);
675: END IF;
676: -- push root element on stack
677: IF (i_level = 0) THEN
670: END IF;
671: IF(l_statementEnabled) THEN
672: ecx_debug.log(l_statement,'i_level',i_level,i_method_name);
673: ecx_debug.log(l_statement,'Source level',ecx_utils.g_source_levels.COUNT,i_method_name);
674: ecx_debug.log(l_statement,'target_source_levels',ecx_utils.g_target_source_levels.COUNT,i_method_name);
675: END IF;
676: -- push root element on stack
677: IF (i_level = 0) THEN
678: push(i_level);
680: FOR i IN 1..ecx_utils.g_source_levels.last
681: LOOP
682: IF ecx_utils.g_source_levels(i).parent_level = i_level THEN
683: IF(l_statementEnabled) THEN
684: ecx_debug.log(l_statement,'SQL Statement',ecx_utils.g_source_levels(i).sql_stmt,i_method_name);
685: END IF;
686: -- Set the Global Variable for Current Level
687: ecx_utils.g_current_level := i;
688: /* Bind the Variables for the Where Clause */
688: /* Bind the Variables for the Where Clause */
689: ecx_actions.bind_variables_for_view(10,i);
690: i_rows_processed := dbms_sql.execute (ecx_utils.g_source_levels(i).Cursor_Handle);
691: IF(l_statementEnabled) THEN
692: ecx_debug.log(l_statement,'Cursor Handle',ecx_utils.g_source_levels(i).Cursor_handle, i_method_name);
693: END IF;
694: WHILE (dbms_sql.fetch_rows( ecx_utils.g_source_levels(i).Cursor_handle) > 0)
695: LOOP
696: push(i);
694: WHILE (dbms_sql.fetch_rows( ecx_utils.g_source_levels(i).Cursor_handle) > 0)
695: LOOP
696: push(i);
697: IF(l_statementEnabled) THEN
698: ecx_debug.log(l_statement,'Executing Fetch Rows',i_method_Name);
699: END IF;
700: -- Get Values from the View
701: -- Initialize the Column Counter
702: i_column_counter :=0;
721: ecx_utils.g_source(j).clob_length := NULL;
722: EXCEPTION
723: WHEN OTHERS THEN
724: ecx_utils.g_source(j).is_clob := 'Y';
725: ecx_debug.log(l_statement,'Unable to convert clob to varchar, using clob itself',i_method_name);
726: END;
727: ELSE
728: ecx_utils.g_source(j).is_clob := 'Y';
729: END IF;
736: IF ecx_utils.g_source(j).base_column_name IS NOT NULL THEN
737: /** Change required for Clob Support -- 2263729 ***/
738: IF ecx_utils.g_source(j).data_type = 112 THEN
739: IF ecx_utils.g_source(j).clob_value IS NULL THEN
740: ecx_debug.log(l_statement, ecx_utils.g_source(j).base_column_name, ecx_utils.g_source(j).value, i_method_name );
741: ELSE
742: ecx_debug.log(l_statement, ecx_utils.g_source(j).base_column_name, ecx_utils.g_source(j).clob_value, i_method_name );
743: END IF;
744: ELSE
738: IF ecx_utils.g_source(j).data_type = 112 THEN
739: IF ecx_utils.g_source(j).clob_value IS NULL THEN
740: ecx_debug.log(l_statement, ecx_utils.g_source(j).base_column_name, ecx_utils.g_source(j).value, i_method_name );
741: ELSE
742: ecx_debug.log(l_statement, ecx_utils.g_source(j).base_column_name, ecx_utils.g_source(j).clob_value, i_method_name );
743: END IF;
744: ELSE
745: ecx_debug.log(l_statement, ecx_utils.g_source(j).base_column_name, ecx_utils.g_source(j).value, i_method_name );
746: END IF;
741: ELSE
742: ecx_debug.log(l_statement, ecx_utils.g_source(j).base_column_name, ecx_utils.g_source(j).clob_value, i_method_name );
743: END IF;
744: ELSE
745: ecx_debug.log(l_statement, ecx_utils.g_source(j).base_column_name, ecx_utils.g_source(j).value, i_method_name );
746: END IF;
747: END IF;
748: END IF;
749: END IF;
751: WHEN j = ecx_utils.g_source_levels(i).file_end_pos;
752: j := ecx_utils.g_source.next(j);
753: END LOOP;
754: IF(l_statementEnabled) THEN
755: ecx_debug.log(l_statement,'All Rows fetched',i_method_name);
756: END IF;
757: i_count :=0;
758: IF (ecx_utils.g_source_levels.count <> 0) THEN
759: FOR m IN ecx_utils.g_source_levels.first..ecx_utils.g_source_levels.last
758: IF (ecx_utils.g_source_levels.count <> 0) THEN
759: FOR m IN ecx_utils.g_source_levels.first..ecx_utils.g_source_levels.last
760: LOOP
761: IF(l_statementEnabled) THEN
762: ecx_debug.log(l_statement,'Source level '||m,'Parent level'||ecx_utils.g_source_levels(m).parent_level, i_method_name);
763: END IF;
764: IF ecx_utils.g_source_levels(m).parent_level=i THEN
765: i_count := i_count+1;
766: END IF;
766: END IF;
767: END LOOP;
768: END IF;
769: IF(l_statementEnabled) THEN
770: ecx_debug.log(l_statement,'i_count',i_count,i_method_name);
771: END IF;
772: IF i_count > 0 THEN
773: fetch_data_from_view(i);
774: END IF;
780: END IF;
781: END IF;
782: END LOOP;
783: IF (l_procedureEnabled) THEN
784: ecx_debug.pop(i_method_name );
785: END IF;
786: EXCEPTION
787: WHEN invalid_number THEN
788: IF(l_unexpectedEnabled) THEN
785: END IF;
786: EXCEPTION
787: WHEN invalid_number THEN
788: IF(l_unexpectedEnabled) THEN
789: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name, 'PROGRESS_LEVEL','ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');
790: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,
791: 'ERROR_MESSAGE',SQLERRM);
792: end if;
793: ecx_debug.setErrorInfo(2,30,'ECX_INVALID_NUMBER - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW' );
786: EXCEPTION
787: WHEN invalid_number THEN
788: IF(l_unexpectedEnabled) THEN
789: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name, 'PROGRESS_LEVEL','ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');
790: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,
791: 'ERROR_MESSAGE',SQLERRM);
792: end if;
793: ecx_debug.setErrorInfo(2,30,'ECX_INVALID_NUMBER - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW' );
794: if (l_procedureEnabled) then
789: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name, 'PROGRESS_LEVEL','ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');
790: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,
791: 'ERROR_MESSAGE',SQLERRM);
792: end if;
793: ecx_debug.setErrorInfo(2,30,'ECX_INVALID_NUMBER - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW' );
794: if (l_procedureEnabled) then
795: ecx_debug.pop(i_method_name);
796: end if;
797: raise ecx_utils.program_exit;
791: 'ERROR_MESSAGE',SQLERRM);
792: end if;
793: ecx_debug.setErrorInfo(2,30,'ECX_INVALID_NUMBER - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW' );
794: if (l_procedureEnabled) then
795: ecx_debug.pop(i_method_name);
796: end if;
797: raise ecx_utils.program_exit;
798: WHEN ecx_utils.PROGRAM_EXIT then
799: raise;
798: WHEN ecx_utils.PROGRAM_EXIT then
799: raise;
800: WHEN OTHERS THEN
801: if(l_unexpectedEnabled) then
802: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
803: 'ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');
804: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
805: end if;
806: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');
800: WHEN OTHERS THEN
801: if(l_unexpectedEnabled) then
802: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
803: 'ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');
804: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
805: end if;
806: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');
807: if(l_unexpectedEnabled) then
808: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW',
802: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
803: 'ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');
804: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
805: end if;
806: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');
807: if(l_unexpectedEnabled) then
808: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW',
809: i_method_name);
810: end if;
804: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
805: end if;
806: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');
807: if(l_unexpectedEnabled) then
808: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW',
809: i_method_name);
810: end if;
811: if (l_procedureEnabled) then
812: ecx_debug.pop(i_method_name );
808: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW',
809: i_method_name);
810: end if;
811: if (l_procedureEnabled) then
812: ecx_debug.pop(i_method_name );
813: end if;
814: raise ecx_utils.PROGRAM_EXIT;
815: END fetch_data_from_view;
816:
819: i_method_name varchar2(2000);
820: begin
821: i_method_name:='ecx_outbound.log_summary';
822: if (l_procedureEnabled) then
823: ecx_debug.push(i_method_name);
824: end if;
825:
826: ecx_debug.log(level,'Processing Summary','====',i_method_name);
827: if (ecx_utils.g_source_levels.count <> 0)
822: if (l_procedureEnabled) then
823: ecx_debug.push(i_method_name);
824: end if;
825:
826: ecx_debug.log(level,'Processing Summary','====',i_method_name);
827: if (ecx_utils.g_source_levels.count <> 0)
828: then
829: for i in ecx_utils.g_source_levels.first..ecx_utils.g_source_levels.last
830: loop
827: if (ecx_utils.g_source_levels.count <> 0)
828: then
829: for i in ecx_utils.g_source_levels.first..ecx_utils.g_source_levels.last
830: loop
831: ecx_debug.log(level,ecx_utils.g_source_levels(i).rows_processed||
832: ' row(s) processed for Level : '|| ecx_utils.g_source_levels(i).start_element
833: || '('|| i || ') ',i_method_name);
834: end loop;
835: end if;
833: || '('|| i || ') ',i_method_name);
834: end loop;
835: end if;
836: if (l_procedureEnabled) then
837: ecx_debug.pop(i_method_name);
838: end if;
839: exception
840: when others then
841: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.LOG_SUMMARY');
837: ecx_debug.pop(i_method_name);
838: end if;
839: exception
840: when others then
841: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.LOG_SUMMARY');
842: if(l_unexpectedEnabled) then
843: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.LOG_SUMMARY',i_method_name);
844: end if;
845: if (l_procedureEnabled) then
839: exception
840: when others then
841: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.LOG_SUMMARY');
842: if(l_unexpectedEnabled) then
843: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.LOG_SUMMARY',i_method_name);
844: end if;
845: if (l_procedureEnabled) then
846: ecx_debug.pop(i_method_name);
847: end if;
842: if(l_unexpectedEnabled) then
843: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.LOG_SUMMARY',i_method_name);
844: end if;
845: if (l_procedureEnabled) then
846: ecx_debug.pop(i_method_name);
847: end if;
848:
849: raise ecx_utils.program_exit;
850: end log_summary;
907: begin
908:
909:
910: if (l_procedureEnabled) then
911: ecx_debug.push(i_method_name );
912: end if;
913: if(l_statementEnabled) then
914: ecx_debug.log(l_statement,'ECX','ECX_START_OUTBOUND','MAP_ID',i_map_id,i_method_name);
915: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name);
910: if (l_procedureEnabled) then
911: ecx_debug.push(i_method_name );
912: end if;
913: if(l_statementEnabled) then
914: ecx_debug.log(l_statement,'ECX','ECX_START_OUTBOUND','MAP_ID',i_map_id,i_method_name);
915: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name);
916: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name);
917: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name);
918: ecx_debug.log(l_statement,'i_tp_id',i_tp_id,i_method_name);
911: ecx_debug.push(i_method_name );
912: end if;
913: if(l_statementEnabled) then
914: ecx_debug.log(l_statement,'ECX','ECX_START_OUTBOUND','MAP_ID',i_map_id,i_method_name);
915: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name);
916: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name);
917: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name);
918: ecx_debug.log(l_statement,'i_tp_id',i_tp_id,i_method_name);
919: ecx_debug.log(l_statement,'i_tp_site_id',i_tp_site_id,i_method_name);
912: end if;
913: if(l_statementEnabled) then
914: ecx_debug.log(l_statement,'ECX','ECX_START_OUTBOUND','MAP_ID',i_map_id,i_method_name);
915: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name);
916: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name);
917: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name);
918: ecx_debug.log(l_statement,'i_tp_id',i_tp_id,i_method_name);
919: ecx_debug.log(l_statement,'i_tp_site_id',i_tp_site_id,i_method_name);
920: ecx_debug.log(l_statement,'i_tp_type',i_tp_type,i_method_name);
913: if(l_statementEnabled) then
914: ecx_debug.log(l_statement,'ECX','ECX_START_OUTBOUND','MAP_ID',i_map_id,i_method_name);
915: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name);
916: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name);
917: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name);
918: ecx_debug.log(l_statement,'i_tp_id',i_tp_id,i_method_name);
919: ecx_debug.log(l_statement,'i_tp_site_id',i_tp_site_id,i_method_name);
920: ecx_debug.log(l_statement,'i_tp_type',i_tp_type,i_method_name);
921: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name);
914: ecx_debug.log(l_statement,'ECX','ECX_START_OUTBOUND','MAP_ID',i_map_id,i_method_name);
915: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name);
916: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name);
917: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name);
918: ecx_debug.log(l_statement,'i_tp_id',i_tp_id,i_method_name);
919: ecx_debug.log(l_statement,'i_tp_site_id',i_tp_site_id,i_method_name);
920: ecx_debug.log(l_statement,'i_tp_type',i_tp_type,i_method_name);
921: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name);
922: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name);
915: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name);
916: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name);
917: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name);
918: ecx_debug.log(l_statement,'i_tp_id',i_tp_id,i_method_name);
919: ecx_debug.log(l_statement,'i_tp_site_id',i_tp_site_id,i_method_name);
920: ecx_debug.log(l_statement,'i_tp_type',i_tp_type,i_method_name);
921: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name);
922: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name);
923: end if;
916: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name);
917: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name);
918: ecx_debug.log(l_statement,'i_tp_id',i_tp_id,i_method_name);
919: ecx_debug.log(l_statement,'i_tp_site_id',i_tp_site_id,i_method_name);
920: ecx_debug.log(l_statement,'i_tp_type',i_tp_type,i_method_name);
921: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name);
922: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name);
923: end if;
924:
917: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name);
918: ecx_debug.log(l_statement,'i_tp_id',i_tp_id,i_method_name);
919: ecx_debug.log(l_statement,'i_tp_site_id',i_tp_site_id,i_method_name);
920: ecx_debug.log(l_statement,'i_tp_type',i_tp_type,i_method_name);
921: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name);
922: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name);
923: end if;
924:
925: /** check for the Event Object. If null , initialize it **/
918: ecx_debug.log(l_statement,'i_tp_id',i_tp_id,i_method_name);
919: ecx_debug.log(l_statement,'i_tp_site_id',i_tp_site_id,i_method_name);
920: ecx_debug.log(l_statement,'i_tp_type',i_tp_type,i_method_name);
921: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name);
922: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name);
923: end if;
924:
925: /** check for the Event Object. If null , initialize it **/
926: if ecx_utils.g_event is null
933: then
934: for i in i_parameterList.FIRST..i_parameterList.LAST
935: loop
936: i_parameter := i_parameterList(i);
937: ecx_debug.log(l_statement,i_parameter.getName(),i_parameter.getValue(),i_method_name);
938: end loop;
939: end if;
940: end if;
941:
955:
956: ecx_utils.g_standard_id := i_standard_id;
957: exception
958: when others then
959: ecx_debug.setErrorInfo(1, 30, 'ECX_CODE_CONVERSION_DISABLED',
960: 'MESSAGE_STANDARD', i_message_standard);
961: if(l_statementEnabled) then
962: ecx_debug.log(l_statement,'ECX', 'ECX_CODE_CONVERSION_DISABLED',i_method_name,
963: 'MESSAGE_STANDARD', i_message_standard);
958: when others then
959: ecx_debug.setErrorInfo(1, 30, 'ECX_CODE_CONVERSION_DISABLED',
960: 'MESSAGE_STANDARD', i_message_standard);
961: if(l_statementEnabled) then
962: ecx_debug.log(l_statement,'ECX', 'ECX_CODE_CONVERSION_DISABLED',i_method_name,
963: 'MESSAGE_STANDARD', i_message_standard);
964: end if;
965: end;
966:
971: from ecx_mappings
972: where map_code = i_map_code;
973: exception
974: when others then
975: ecx_debug.setErrorInfo(1, 30, 'ECX_MAP_NOT_FOUND', 'MAP_CODE', i_map_code);
976: if(l_unexpectedEnabled) then
977: ecx_debug.log(l_unexpected,'ECX', 'ECX_MAP_NOT_FOUND', i_method_name,'MAP_CODE', i_map_code);
978: end if;
979: raise ecx_utils.program_exit;
973: exception
974: when others then
975: ecx_debug.setErrorInfo(1, 30, 'ECX_MAP_NOT_FOUND', 'MAP_CODE', i_map_code);
976: if(l_unexpectedEnabled) then
977: ecx_debug.log(l_unexpected,'ECX', 'ECX_MAP_NOT_FOUND', i_method_name,'MAP_CODE', i_map_code);
978: end if;
979: raise ecx_utils.program_exit;
980: end;
981:
991: /** Set the GLobal g_rcv_tp_id **/
992: ecx_utils.g_rec_tp_id:= i_tp_header_id;
993: exception
994: when others then
995: ecx_debug.setErrorInfo(1, 30, 'ECX_TP_NOT_FOUND', 'PARTY_ID', i_tp_id);
996: if(l_statementEnabled) then
997: ecx_debug.log(l_statement,'ECX', 'ECX_TP_NOT_FOUND', i_method_name,'PARTY_ID', i_tp_id);
998: end if;
999: end;
993: exception
994: when others then
995: ecx_debug.setErrorInfo(1, 30, 'ECX_TP_NOT_FOUND', 'PARTY_ID', i_tp_id);
996: if(l_statementEnabled) then
997: ecx_debug.log(l_statement,'ECX', 'ECX_TP_NOT_FOUND', i_method_name,'PARTY_ID', i_tp_id);
998: end if;
999: end;
1000:
1001: begin
1008: and eo.object_type in ('DTD','XML')
1009: and eo.object_id = 2;
1010: exception
1011: when others then
1012: ecx_debug.setErrorInfo(1, 30, 'ECX_ROOT_ELEMENT_NOT_FOUND', 'MAP_ID', i_map_id);
1013: if(l_unexpectedEnabled) then
1014: ecx_debug.log(l_unexpected,'ECX', 'ECX_ROOT_ELEMENT_NOT_FOUND',i_method_name, 'MAP_ID', i_map_id);
1015: end if;
1016: raise ecx_utils.program_exit;
1010: exception
1011: when others then
1012: ecx_debug.setErrorInfo(1, 30, 'ECX_ROOT_ELEMENT_NOT_FOUND', 'MAP_ID', i_map_id);
1013: if(l_unexpectedEnabled) then
1014: ecx_debug.log(l_unexpected,'ECX', 'ECX_ROOT_ELEMENT_NOT_FOUND',i_method_name, 'MAP_ID', i_map_id);
1015: end if;
1016: raise ecx_utils.program_exit;
1017: end;
1018:
1190: /** DOCUMENT NODE **/
1191: if (not ecx_utils.g_delete_doctype) then
1192: ecx_print_local.document_node(i_root_element,i_filename,null);
1193: if(l_statementEnabled) then
1194: ecx_debug.log(l_statement, 'Printed DOCTYPE', i_method_name);
1195: end if;
1196: end if;
1197:
1198: fetch_data_from_view (0);
1200: ecx_print_local.xmlPOPALL(i_xmldoc);
1201:
1202: ecx_util_api.parseXML(ecx_utils.g_parser, i_xmldoc, l_parseXML, ecx_utils.g_xmldoc);
1203: if(l_statementEnabled) then
1204: ecx_debug.log(l_statement, 'Parsed XML', l_parseXML,i_method_name);
1205: end if;
1206:
1207: -- Post-Processing for the Document on Target Side
1208: ecx_actions.execute_stage_data
1227: else get clob output from dom node
1228: */
1229: if(ecx_utils.g_cnt_xslt_defined > 0) then
1230: if(l_statementEnabled) then
1231: ecx_debug.log(l_statement, 'xslt transformation is defined and getting transformed output',i_method_name);
1232: end if;
1233: i_xmldoc := ecx_utils.g_out_transformed;
1234: else
1235: dbms_lob.trim(i_xmldoc, 0);
1241: if (l_statementEnabled)
1242: then
1243: IF g_instlmode = 'EMBEDDED' THEN
1244: fnd_message.set_name('ecx', 'XML File for logging');
1245: 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);
1246: if(attachment_id <> -1 AND i_xmldoc is not null) then
1247: clength := dbms_lob.getlength(i_xmldoc);
1248: while clength >= offset LOOP
1249: ctemp := dbms_lob.substr(i_xmldoc,g_varmaxlength,offset);
1262:
1263: if(l_statementEnabled) then
1264: ecx_outbound.log_summary(l_statement);
1265:
1266: ecx_debug.log(l_statement,'ECX','ECX_DOCUMENTS_PROCESSED',i_method_name,'NO_OF_DOCS',
1267: ecx_utils.g_source_levels(0).rows_processed);
1268: ecx_debug.log(l_statement,'ECX','ECX_FINISH_OUTBOUND',i_method_name,'MAP_ID',i_map_id);
1269: end if;
1270:
1264: ecx_outbound.log_summary(l_statement);
1265:
1266: ecx_debug.log(l_statement,'ECX','ECX_DOCUMENTS_PROCESSED',i_method_name,'NO_OF_DOCS',
1267: ecx_utils.g_source_levels(0).rows_processed);
1268: ecx_debug.log(l_statement,'ECX','ECX_FINISH_OUTBOUND',i_method_name,'MAP_ID',i_map_id);
1269: end if;
1270:
1271: if not XMLDom.isNull(ecx_utils.g_xmldoc) then
1272: i_node_type := xmlDOM.getNodeType(ecx_utils.g_xmldoc);
1277: end if;
1278: xmlparser.freeparser(ecx_utils.g_parser);
1279: end if;
1280: if (l_procedureEnabled) then
1281: ecx_debug.pop(i_method_name );
1282: end if;
1283:
1284: EXCEPTION
1285: WHEN ecx_utils.PROGRAM_EXIT then
1283:
1284: EXCEPTION
1285: WHEN ecx_utils.PROGRAM_EXIT then
1286: if(l_unexpectedEnabled) then
1287: ecx_debug.log(l_unexpected, 'Clean-up i_stack, l_node_stack, i_tmpxml and last_printed',
1288: i_method_name);
1289: ecx_outbound.log_summary(l_unexpected);
1290: end if;
1291: i_stack.DELETE;
1292: ecx_print_local.i_tmpxml.DELETE;
1293: ecx_print_local.l_node_stack.DELETE;
1294: ecx_print_local.last_printed := -1;
1295: if (l_procedureEnabled) then
1296: ecx_debug.pop(i_method_name );
1297: end if;
1298: raise ecx_utils.program_exit;
1299: WHEN OTHERS THEN
1300: if(l_unexpectedEnabled) then
1297: end if;
1298: raise ecx_utils.program_exit;
1299: WHEN OTHERS THEN
1300: if(l_unexpectedEnabled) then
1301: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
1302: 'ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');
1303: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1304: ecx_outbound.log_summary(l_unexpected);
1305: end if;
1299: WHEN OTHERS THEN
1300: if(l_unexpectedEnabled) then
1301: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
1302: 'ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');
1303: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1304: ecx_outbound.log_summary(l_unexpected);
1305: end if;
1306: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');
1307: if(l_unexpectedEnabled) then
1302: 'ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');
1303: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1304: ecx_outbound.log_summary(l_unexpected);
1305: end if;
1306: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');
1307: if(l_unexpectedEnabled) then
1308: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS',i_method_name);
1309: ecx_debug.log(l_unexpected, 'Clean-up i_stack, l_node_stack, i_tmpxml and last_printed',i_method_name);
1310: end if;
1304: ecx_outbound.log_summary(l_unexpected);
1305: end if;
1306: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');
1307: if(l_unexpectedEnabled) then
1308: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS',i_method_name);
1309: ecx_debug.log(l_unexpected, 'Clean-up i_stack, l_node_stack, i_tmpxml and last_printed',i_method_name);
1310: end if;
1311: i_stack.DELETE;
1312: ecx_print_local.i_tmpxml.DELETE;
1305: end if;
1306: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');
1307: if(l_unexpectedEnabled) then
1308: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS',i_method_name);
1309: ecx_debug.log(l_unexpected, 'Clean-up i_stack, l_node_stack, i_tmpxml and last_printed',i_method_name);
1310: end if;
1311: i_stack.DELETE;
1312: ecx_print_local.i_tmpxml.DELETE;
1313: ecx_print_local.l_node_stack.DELETE;
1312: ecx_print_local.i_tmpxml.DELETE;
1313: ecx_print_local.l_node_stack.DELETE;
1314: ecx_print_local.last_printed := -1;
1315: if (l_procedureEnabled) then
1316: ecx_debug.pop(i_method_name );
1317: end if;
1318: raise ecx_utils.PROGRAM_EXIT;
1319: end process_outbound_documents;
1320:
1403: p_aflog_module_name := p_aflog_module_name||ecx_utils.g_run_id;
1404: END IF;
1405: p_aflog_module_name := p_aflog_module_name||'.log';
1406:
1407: ecx_debug.enable_debug_new(i_debug_level,ecx_utils.g_logdir,ecx_utils.g_logfile, p_aflog_module_name);
1408: end if;
1409:
1410: -- Assign local variables with the ecx_debug global variables
1411: l_procedure := ecx_debug.g_procedure;
1406:
1407: ecx_debug.enable_debug_new(i_debug_level,ecx_utils.g_logdir,ecx_utils.g_logfile, p_aflog_module_name);
1408: end if;
1409:
1410: -- Assign local variables with the ecx_debug global variables
1411: l_procedure := ecx_debug.g_procedure;
1412: l_statement := ecx_debug.g_statement;
1413: l_unexpected := ecx_debug.g_unexpected;
1414: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1407: ecx_debug.enable_debug_new(i_debug_level,ecx_utils.g_logdir,ecx_utils.g_logfile, p_aflog_module_name);
1408: end if;
1409:
1410: -- Assign local variables with the ecx_debug global variables
1411: l_procedure := ecx_debug.g_procedure;
1412: l_statement := ecx_debug.g_statement;
1413: l_unexpected := ecx_debug.g_unexpected;
1414: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1415: l_statementEnabled := ecx_debug.g_statementEnabled;
1408: end if;
1409:
1410: -- Assign local variables with the ecx_debug global variables
1411: l_procedure := ecx_debug.g_procedure;
1412: l_statement := ecx_debug.g_statement;
1413: l_unexpected := ecx_debug.g_unexpected;
1414: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1415: l_statementEnabled := ecx_debug.g_statementEnabled;
1416: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1409:
1410: -- Assign local variables with the ecx_debug global variables
1411: l_procedure := ecx_debug.g_procedure;
1412: l_statement := ecx_debug.g_statement;
1413: l_unexpected := ecx_debug.g_unexpected;
1414: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1415: l_statementEnabled := ecx_debug.g_statementEnabled;
1416: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1417:
1410: -- Assign local variables with the ecx_debug global variables
1411: l_procedure := ecx_debug.g_procedure;
1412: l_statement := ecx_debug.g_statement;
1413: l_unexpected := ecx_debug.g_unexpected;
1414: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1415: l_statementEnabled := ecx_debug.g_statementEnabled;
1416: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1417:
1418: if (l_procedureEnabled) then
1411: l_procedure := ecx_debug.g_procedure;
1412: l_statement := ecx_debug.g_statement;
1413: l_unexpected := ecx_debug.g_unexpected;
1414: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1415: l_statementEnabled := ecx_debug.g_statementEnabled;
1416: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1417:
1418: if (l_procedureEnabled) then
1419: ecx_debug.push(i_method_name);
1412: l_statement := ecx_debug.g_statement;
1413: l_unexpected := ecx_debug.g_unexpected;
1414: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1415: l_statementEnabled := ecx_debug.g_statementEnabled;
1416: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1417:
1418: if (l_procedureEnabled) then
1419: ecx_debug.push(i_method_name);
1420: end if;
1415: l_statementEnabled := ecx_debug.g_statementEnabled;
1416: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1417:
1418: if (l_procedureEnabled) then
1419: ecx_debug.push(i_method_name);
1420: end if;
1421:
1422: if(l_statementEnabled) then
1423: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name );
1419: ecx_debug.push(i_method_name);
1420: end if;
1421:
1422: if(l_statementEnabled) then
1423: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name );
1424: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name );
1425: ecx_debug.log(l_statement,'i_party_id',i_party_id,i_method_name );
1426: ecx_debug.log(l_statement,'i_party_site_id',i_party_site_id,i_method_name );
1427: ecx_debug.log(l_statement,'i_party_type',i_party_type,i_method_name );
1420: end if;
1421:
1422: if(l_statementEnabled) then
1423: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name );
1424: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name );
1425: ecx_debug.log(l_statement,'i_party_id',i_party_id,i_method_name );
1426: ecx_debug.log(l_statement,'i_party_site_id',i_party_site_id,i_method_name );
1427: ecx_debug.log(l_statement,'i_party_type',i_party_type,i_method_name );
1428: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name );
1421:
1422: if(l_statementEnabled) then
1423: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name );
1424: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name );
1425: ecx_debug.log(l_statement,'i_party_id',i_party_id,i_method_name );
1426: ecx_debug.log(l_statement,'i_party_site_id',i_party_site_id,i_method_name );
1427: ecx_debug.log(l_statement,'i_party_type',i_party_type,i_method_name );
1428: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name );
1429: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name );
1422: if(l_statementEnabled) then
1423: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name );
1424: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name );
1425: ecx_debug.log(l_statement,'i_party_id',i_party_id,i_method_name );
1426: ecx_debug.log(l_statement,'i_party_site_id',i_party_site_id,i_method_name );
1427: ecx_debug.log(l_statement,'i_party_type',i_party_type,i_method_name );
1428: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name );
1429: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name );
1430: ecx_debug.log(l_statement,'i_message_type',i_message_type,i_method_name );
1423: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name );
1424: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name );
1425: ecx_debug.log(l_statement,'i_party_id',i_party_id,i_method_name );
1426: ecx_debug.log(l_statement,'i_party_site_id',i_party_site_id,i_method_name );
1427: ecx_debug.log(l_statement,'i_party_type',i_party_type,i_method_name );
1428: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name );
1429: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name );
1430: ecx_debug.log(l_statement,'i_message_type',i_message_type,i_method_name );
1431: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name );
1424: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name );
1425: ecx_debug.log(l_statement,'i_party_id',i_party_id,i_method_name );
1426: ecx_debug.log(l_statement,'i_party_site_id',i_party_site_id,i_method_name );
1427: ecx_debug.log(l_statement,'i_party_type',i_party_type,i_method_name );
1428: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name );
1429: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name );
1430: ecx_debug.log(l_statement,'i_message_type',i_message_type,i_method_name );
1431: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name );
1432: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name );
1425: ecx_debug.log(l_statement,'i_party_id',i_party_id,i_method_name );
1426: ecx_debug.log(l_statement,'i_party_site_id',i_party_site_id,i_method_name );
1427: ecx_debug.log(l_statement,'i_party_type',i_party_type,i_method_name );
1428: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name );
1429: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name );
1430: ecx_debug.log(l_statement,'i_message_type',i_message_type,i_method_name );
1431: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name );
1432: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name );
1433: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name );
1426: ecx_debug.log(l_statement,'i_party_site_id',i_party_site_id,i_method_name );
1427: ecx_debug.log(l_statement,'i_party_type',i_party_type,i_method_name );
1428: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name );
1429: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name );
1430: ecx_debug.log(l_statement,'i_message_type',i_message_type,i_method_name );
1431: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name );
1432: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name );
1433: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name );
1434: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name );
1427: ecx_debug.log(l_statement,'i_party_type',i_party_type,i_method_name );
1428: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name );
1429: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name );
1430: ecx_debug.log(l_statement,'i_message_type',i_message_type,i_method_name );
1431: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name );
1432: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name );
1433: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name );
1434: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name );
1435: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name );
1428: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name );
1429: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name );
1430: ecx_debug.log(l_statement,'i_message_type',i_message_type,i_method_name );
1431: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name );
1432: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name );
1433: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name );
1434: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name );
1435: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name );
1436: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name );
1429: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name );
1430: ecx_debug.log(l_statement,'i_message_type',i_message_type,i_method_name );
1431: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name );
1432: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name );
1433: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name );
1434: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name );
1435: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name );
1436: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name );
1437: ecx_debug.log(l_statement,'i_username',i_username,i_method_name );
1430: ecx_debug.log(l_statement,'i_message_type',i_message_type,i_method_name );
1431: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name );
1432: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name );
1433: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name );
1434: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name );
1435: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name );
1436: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name );
1437: ecx_debug.log(l_statement,'i_username',i_username,i_method_name );
1438: ecx_debug.log(l_statement,'i_password',i_password,i_method_name );
1431: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name );
1432: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name );
1433: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name );
1434: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name );
1435: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name );
1436: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name );
1437: ecx_debug.log(l_statement,'i_username',i_username,i_method_name );
1438: ecx_debug.log(l_statement,'i_password',i_password,i_method_name );
1439: ecx_debug.log(l_statement,'i_attribute1',i_attribute1,i_method_name );
1432: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name );
1433: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name );
1434: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name );
1435: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name );
1436: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name );
1437: ecx_debug.log(l_statement,'i_username',i_username,i_method_name );
1438: ecx_debug.log(l_statement,'i_password',i_password,i_method_name );
1439: ecx_debug.log(l_statement,'i_attribute1',i_attribute1,i_method_name );
1440: ecx_debug.log(l_statement,'i_attribute2',i_attribute2,i_method_name );
1433: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name );
1434: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name );
1435: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name );
1436: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name );
1437: ecx_debug.log(l_statement,'i_username',i_username,i_method_name );
1438: ecx_debug.log(l_statement,'i_password',i_password,i_method_name );
1439: ecx_debug.log(l_statement,'i_attribute1',i_attribute1,i_method_name );
1440: ecx_debug.log(l_statement,'i_attribute2',i_attribute2,i_method_name );
1441: ecx_debug.log(l_statement,'i_attribute3',i_attribute3,i_method_name );
1434: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name );
1435: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name );
1436: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name );
1437: ecx_debug.log(l_statement,'i_username',i_username,i_method_name );
1438: ecx_debug.log(l_statement,'i_password',i_password,i_method_name );
1439: ecx_debug.log(l_statement,'i_attribute1',i_attribute1,i_method_name );
1440: ecx_debug.log(l_statement,'i_attribute2',i_attribute2,i_method_name );
1441: ecx_debug.log(l_statement,'i_attribute3',i_attribute3,i_method_name );
1442: ecx_debug.log(l_statement,'i_attribute4',i_attribute4,i_method_name );
1435: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name );
1436: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name );
1437: ecx_debug.log(l_statement,'i_username',i_username,i_method_name );
1438: ecx_debug.log(l_statement,'i_password',i_password,i_method_name );
1439: ecx_debug.log(l_statement,'i_attribute1',i_attribute1,i_method_name );
1440: ecx_debug.log(l_statement,'i_attribute2',i_attribute2,i_method_name );
1441: ecx_debug.log(l_statement,'i_attribute3',i_attribute3,i_method_name );
1442: ecx_debug.log(l_statement,'i_attribute4',i_attribute4,i_method_name );
1443: ecx_debug.log(l_statement,'i_attribute5',i_attribute5,i_method_name );
1436: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name );
1437: ecx_debug.log(l_statement,'i_username',i_username,i_method_name );
1438: ecx_debug.log(l_statement,'i_password',i_password,i_method_name );
1439: ecx_debug.log(l_statement,'i_attribute1',i_attribute1,i_method_name );
1440: ecx_debug.log(l_statement,'i_attribute2',i_attribute2,i_method_name );
1441: ecx_debug.log(l_statement,'i_attribute3',i_attribute3,i_method_name );
1442: ecx_debug.log(l_statement,'i_attribute4',i_attribute4,i_method_name );
1443: ecx_debug.log(l_statement,'i_attribute5',i_attribute5,i_method_name );
1444: end if;
1437: ecx_debug.log(l_statement,'i_username',i_username,i_method_name );
1438: ecx_debug.log(l_statement,'i_password',i_password,i_method_name );
1439: ecx_debug.log(l_statement,'i_attribute1',i_attribute1,i_method_name );
1440: ecx_debug.log(l_statement,'i_attribute2',i_attribute2,i_method_name );
1441: ecx_debug.log(l_statement,'i_attribute3',i_attribute3,i_method_name );
1442: ecx_debug.log(l_statement,'i_attribute4',i_attribute4,i_method_name );
1443: ecx_debug.log(l_statement,'i_attribute5',i_attribute5,i_method_name );
1444: end if;
1445:
1438: ecx_debug.log(l_statement,'i_password',i_password,i_method_name );
1439: ecx_debug.log(l_statement,'i_attribute1',i_attribute1,i_method_name );
1440: ecx_debug.log(l_statement,'i_attribute2',i_attribute2,i_method_name );
1441: ecx_debug.log(l_statement,'i_attribute3',i_attribute3,i_method_name );
1442: ecx_debug.log(l_statement,'i_attribute4',i_attribute4,i_method_name );
1443: ecx_debug.log(l_statement,'i_attribute5',i_attribute5,i_method_name );
1444: end if;
1445:
1446: ecx_errorlog.outbound_engine
1439: ecx_debug.log(l_statement,'i_attribute1',i_attribute1,i_method_name );
1440: ecx_debug.log(l_statement,'i_attribute2',i_attribute2,i_method_name );
1441: ecx_debug.log(l_statement,'i_attribute3',i_attribute3,i_method_name );
1442: ecx_debug.log(l_statement,'i_attribute4',i_attribute4,i_method_name );
1443: ecx_debug.log(l_statement,'i_attribute5',i_attribute5,i_method_name );
1444: end if;
1445:
1446: ecx_errorlog.outbound_engine
1447: (
1531: i_from_agt.setsystem(i_system);
1532: ecx_utils.g_event.setFromAgent(i_from_agt);
1533:
1534: if(l_statementEnabled) then
1535: ecx_debug.log(l_statement, 'Calling WF_EVENT.Send for Enqueue', i_method_name);
1536: end if;
1537: wf_event.send(ecx_utils.g_event);
1538: ecx_errorlog.outbound_log(ecx_utils.g_event);
1539:
1547: -- check the retcode and retmsg. This should be populated here only
1548: -- in the case of dup val index when inserting in doclogs (since no
1549: -- exception is raised in this case)
1550: if (ecx_out_wf_qh.retmsg is not null) then
1551: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode, 30, ecx_out_wf_qh.retmsg);
1552: if(l_unexpectedEnabled) then
1553: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
1554: end if;
1555: end if;
1549: -- exception is raised in this case)
1550: if (ecx_out_wf_qh.retmsg is not null) then
1551: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode, 30, ecx_out_wf_qh.retmsg);
1552: if(l_unexpectedEnabled) then
1553: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
1554: end if;
1555: end if;
1556:
1557: if dbms_lob.istemporary(i_xmldoc) = 1 then
1558: dbms_lob.freetemporary(i_xmldoc);
1559: end if;
1560:
1561: if(l_statementEnabled) then
1562: ecx_debug.log(l_statement,'msgid',i_msgid,i_method_name);
1563: end if;
1564: if (l_procedureEnabled) then
1565: ecx_debug.pop(i_method_name);
1566: end if;
1561: if(l_statementEnabled) then
1562: ecx_debug.log(l_statement,'msgid',i_msgid,i_method_name);
1563: end if;
1564: if (l_procedureEnabled) then
1565: ecx_debug.pop(i_method_name);
1566: end if;
1567:
1568: if NOT ( i_direct )
1569: then
1566: end if;
1567:
1568: if NOT ( i_direct )
1569: then
1570: ecx_debug.print_log;
1571: ecx_debug.disable_debug;
1572: ecx_utils.g_logfile:=null;
1573: end if;
1574:
1567:
1568: if NOT ( i_direct )
1569: then
1570: ecx_debug.print_log;
1571: ecx_debug.disable_debug;
1572: ecx_utils.g_logfile:=null;
1573: end if;
1574:
1575: EXCEPTION
1577: if dbms_lob.istemporary(i_xmldoc) = 1 then
1578: dbms_lob.freetemporary(i_xmldoc);
1579: end if;
1580: if (l_procedureEnabled) then
1581: ecx_debug.pop(i_method_name);
1582: end if;
1583: if NOT ( i_direct )
1584: then
1585: ecx_debug.print_log;
1581: ecx_debug.pop(i_method_name);
1582: end if;
1583: if NOT ( i_direct )
1584: then
1585: ecx_debug.print_log;
1586: ecx_debug.disable_debug;
1587: ecx_utils.g_logfile:=null;
1588:
1589: ecx_errorlog.outbound_engine
1582: end if;
1583: if NOT ( i_direct )
1584: then
1585: ecx_debug.print_log;
1586: ecx_debug.disable_debug;
1587: ecx_utils.g_logfile:=null;
1588:
1589: ecx_errorlog.outbound_engine
1590: (
1602:
1603: WHEN OTHERS THEN
1604: if (ecx_out_wf_qh.retmsg is null AND ecx_out_wf_qh.retcode = 0)
1605: then
1606: ecx_debug.setErrorInfo(2, 30, SQLERRM);
1607: if(l_unexpectedEnabled) then
1608: ecx_debug.log(l_unexpected, 'ECX', SQLERRM,i_method_name);
1609: end if;
1610: else
1604: if (ecx_out_wf_qh.retmsg is null AND ecx_out_wf_qh.retcode = 0)
1605: then
1606: ecx_debug.setErrorInfo(2, 30, SQLERRM);
1607: if(l_unexpectedEnabled) then
1608: ecx_debug.log(l_unexpected, 'ECX', SQLERRM,i_method_name);
1609: end if;
1610: else
1611: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode, 30, ecx_out_wf_qh.retmsg);
1612: if(l_unexpectedEnabled) then
1607: if(l_unexpectedEnabled) then
1608: ecx_debug.log(l_unexpected, 'ECX', SQLERRM,i_method_name);
1609: end if;
1610: else
1611: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode, 30, ecx_out_wf_qh.retmsg);
1612: if(l_unexpectedEnabled) then
1613: ecx_debug.log(l_unexpected, 'msg and code set in queue handler',i_method_name);
1614: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1615: end if;
1609: end if;
1610: else
1611: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode, 30, ecx_out_wf_qh.retmsg);
1612: if(l_unexpectedEnabled) then
1613: ecx_debug.log(l_unexpected, 'msg and code set in queue handler',i_method_name);
1614: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1615: end if;
1616: end if;
1617:
1610: else
1611: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode, 30, ecx_out_wf_qh.retmsg);
1612: if(l_unexpectedEnabled) then
1613: ecx_debug.log(l_unexpected, 'msg and code set in queue handler',i_method_name);
1614: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1615: end if;
1616: end if;
1617:
1618: if dbms_lob.istemporary(i_xmldoc) = 1 then
1619: dbms_lob.freetemporary(i_xmldoc);
1620: end if;
1621:
1622: if (l_procedureEnabled) then
1623: ecx_debug.pop(i_method_name);
1624: end if;
1625: if NOT ( i_direct )
1626: then
1627: IF (ecx_logging_enabled ) THEN
1624: end if;
1625: if NOT ( i_direct )
1626: then
1627: IF (ecx_logging_enabled ) THEN
1628: ecx_debug.print_log;
1629: ecx_debug.disable_debug;
1630: ecx_utils.g_logfile:=null;
1631: END IF;
1632: ecx_errorlog.outbound_engine
1625: if NOT ( i_direct )
1626: then
1627: IF (ecx_logging_enabled ) THEN
1628: ecx_debug.print_log;
1629: ecx_debug.disable_debug;
1630: ecx_utils.g_logfile:=null;
1631: END IF;
1632: ecx_errorlog.outbound_engine
1633: (
1686: logging_enabled varchar2(20);
1687: module varchar2(2000);
1688:
1689: begin
1690: --To populate the global variable ecx_debug.g_v_module_name , need to call ecx_debug.module_enabled
1691: ecx_debug.g_v_module_name := 'ecx.plsql.';
1692: ecx_debug.module_enabled(i_message_standard,i_transaction_type,i_transaction_subtype,i_document_id);
1693: fnd_profile.get('AFLOG_ENABLED',logging_enabled);
1694: fnd_profile.get('AFLOG_MODULE',module);
1687: module varchar2(2000);
1688:
1689: begin
1690: --To populate the global variable ecx_debug.g_v_module_name , need to call ecx_debug.module_enabled
1691: ecx_debug.g_v_module_name := 'ecx.plsql.';
1692: ecx_debug.module_enabled(i_message_standard,i_transaction_type,i_transaction_subtype,i_document_id);
1693: fnd_profile.get('AFLOG_ENABLED',logging_enabled);
1694: fnd_profile.get('AFLOG_MODULE',module);
1695: if(logging_enabled = 'Y' AND ((lower(module) like 'ecx%'
1688:
1689: begin
1690: --To populate the global variable ecx_debug.g_v_module_name , need to call ecx_debug.module_enabled
1691: ecx_debug.g_v_module_name := 'ecx.plsql.';
1692: ecx_debug.module_enabled(i_message_standard,i_transaction_type,i_transaction_subtype,i_document_id);
1693: fnd_profile.get('AFLOG_ENABLED',logging_enabled);
1694: fnd_profile.get('AFLOG_MODULE',module);
1695: if(logging_enabled = 'Y' AND ((lower(module) like 'ecx%'
1696: AND instr(lower(ecx_debug.g_v_module_name),rtrim(lower(module),'%'))> 0)
1692: ecx_debug.module_enabled(i_message_standard,i_transaction_type,i_transaction_subtype,i_document_id);
1693: fnd_profile.get('AFLOG_ENABLED',logging_enabled);
1694: fnd_profile.get('AFLOG_MODULE',module);
1695: if(logging_enabled = 'Y' AND ((lower(module) like 'ecx%'
1696: AND instr(lower(ecx_debug.g_v_module_name),rtrim(lower(module),'%'))> 0)
1697: OR module='%')
1698: AND FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) then
1699: ecx_logging_enabled := true;
1700: end if;
1745: i_trigger_id ,
1746: i_msgid );
1747: Exception
1748: WHEN OTHERS THEN
1749: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.putmsg ');
1750: if(l_unexpectedEnabled) then
1751: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.putmsg ',
1752: i_method_name);
1753: end if;
1747: Exception
1748: WHEN OTHERS THEN
1749: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.putmsg ');
1750: if(l_unexpectedEnabled) then
1751: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.putmsg ',
1752: i_method_name);
1753: end if;
1754: raise ecx_utils.PROGRAM_EXIT;
1755: end putmsg;
1790: logging_enabled varchar2(20);
1791: module varchar2(2000);
1792:
1793: begin
1794: --To populate the global variable ecx_debug.g_v_module_name , need to call ecx_debug.module_enabled
1795: ecx_debug.g_v_module_name := 'ecx.plsql.';
1796: ecx_debug.module_enabled(i_message_standard,i_transaction_type,i_transaction_subtype,i_document_id);
1797:
1798: g_instlmode := wf_core.translate('WF_INSTALL');
1791: module varchar2(2000);
1792:
1793: begin
1794: --To populate the global variable ecx_debug.g_v_module_name , need to call ecx_debug.module_enabled
1795: ecx_debug.g_v_module_name := 'ecx.plsql.';
1796: ecx_debug.module_enabled(i_message_standard,i_transaction_type,i_transaction_subtype,i_document_id);
1797:
1798: g_instlmode := wf_core.translate('WF_INSTALL');
1799:
1792:
1793: begin
1794: --To populate the global variable ecx_debug.g_v_module_name , need to call ecx_debug.module_enabled
1795: ecx_debug.g_v_module_name := 'ecx.plsql.';
1796: ecx_debug.module_enabled(i_message_standard,i_transaction_type,i_transaction_subtype,i_document_id);
1797:
1798: g_instlmode := wf_core.translate('WF_INSTALL');
1799:
1800: if(g_instlmode = 'EMBEDDED')
1801: then
1802: fnd_profile.get('AFLOG_ENABLED',logging_enabled);
1803: fnd_profile.get('AFLOG_MODULE',module);
1804: if(logging_enabled = 'Y' AND ((lower(module) like 'ecx%'
1805: AND instr(lower(ecx_debug.g_v_module_name),rtrim(lower(module),'%'))> 0)
1806: OR module='%')
1807: AND FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) then
1808: ecx_logging_enabled := true;
1809: end if;
1844: IF (ecx_utils.g_run_id is not null) THEN
1845: p_aflog_module_name := p_aflog_module_name||ecx_utils.g_run_id;
1846: END IF;
1847: p_aflog_module_name := p_aflog_module_name||'.log';
1848: ecx_debug.enable_debug_new(i_debug_level,ecx_utils.g_logdir,ecx_utils.g_logfile, p_aflog_module_name);
1849: END IF;
1850:
1851: IF g_instlmode = 'EMBEDDED' THEN
1852: IF (ecx_logging_enabled ) THEN
1849: END IF;
1850:
1851: IF g_instlmode = 'EMBEDDED' THEN
1852: IF (ecx_logging_enabled ) THEN
1853: i_log_file := ecx_debug.g_sqlprefix || p_aflog_module_name;
1854: ELSE
1855: i_log_file := 'Please ensure that FND-Logging is enabled for module '||ecx_debug.g_sqlprefix||'%';
1856: END IF;
1857: ELSE
1851: IF g_instlmode = 'EMBEDDED' THEN
1852: IF (ecx_logging_enabled ) THEN
1853: i_log_file := ecx_debug.g_sqlprefix || p_aflog_module_name;
1854: ELSE
1855: i_log_file := 'Please ensure that FND-Logging is enabled for module '||ecx_debug.g_sqlprefix||'%';
1856: END IF;
1857: ELSE
1858: if (ecx_logging_enabled) then
1859: i_log_file := ecx_utils.g_logdir||ecx_utils.getFileSeparator()||ecx_utils.g_logfile;
1861: i_log_file := 'Please ensure that logging is enabled';
1862: end if;
1863: END IF;
1864:
1865: /* Assign local variables with the ecx_debug global variables*/
1866: l_procedure := ecx_debug.g_procedure;
1867: l_statement := ecx_debug.g_statement;
1868: l_unexpected := ecx_debug.g_unexpected;
1869: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1862: end if;
1863: END IF;
1864:
1865: /* Assign local variables with the ecx_debug global variables*/
1866: l_procedure := ecx_debug.g_procedure;
1867: l_statement := ecx_debug.g_statement;
1868: l_unexpected := ecx_debug.g_unexpected;
1869: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1870: l_statementEnabled := ecx_debug.g_statementEnabled;
1863: END IF;
1864:
1865: /* Assign local variables with the ecx_debug global variables*/
1866: l_procedure := ecx_debug.g_procedure;
1867: l_statement := ecx_debug.g_statement;
1868: l_unexpected := ecx_debug.g_unexpected;
1869: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1870: l_statementEnabled := ecx_debug.g_statementEnabled;
1871: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1864:
1865: /* Assign local variables with the ecx_debug global variables*/
1866: l_procedure := ecx_debug.g_procedure;
1867: l_statement := ecx_debug.g_statement;
1868: l_unexpected := ecx_debug.g_unexpected;
1869: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1870: l_statementEnabled := ecx_debug.g_statementEnabled;
1871: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1872:
1865: /* Assign local variables with the ecx_debug global variables*/
1866: l_procedure := ecx_debug.g_procedure;
1867: l_statement := ecx_debug.g_statement;
1868: l_unexpected := ecx_debug.g_unexpected;
1869: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1870: l_statementEnabled := ecx_debug.g_statementEnabled;
1871: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1872:
1873: if (l_procedureEnabled) then
1866: l_procedure := ecx_debug.g_procedure;
1867: l_statement := ecx_debug.g_statement;
1868: l_unexpected := ecx_debug.g_unexpected;
1869: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1870: l_statementEnabled := ecx_debug.g_statementEnabled;
1871: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1872:
1873: if (l_procedureEnabled) then
1874: ecx_debug.push(i_method_name);
1867: l_statement := ecx_debug.g_statement;
1868: l_unexpected := ecx_debug.g_unexpected;
1869: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1870: l_statementEnabled := ecx_debug.g_statementEnabled;
1871: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1872:
1873: if (l_procedureEnabled) then
1874: ecx_debug.push(i_method_name);
1875: end if;
1870: l_statementEnabled := ecx_debug.g_statementEnabled;
1871: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1872:
1873: if (l_procedureEnabled) then
1874: ecx_debug.push(i_method_name);
1875: end if;
1876:
1877: if(l_statementEnabled) then
1878: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name );
1874: ecx_debug.push(i_method_name);
1875: end if;
1876:
1877: if(l_statementEnabled) then
1878: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name );
1879: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name );
1880: ecx_debug.log(l_statement,'i_tp_id',i_tp_id,i_method_name );
1881: ecx_debug.log(l_statement,'i_tp_site_id',i_tp_site_id,i_method_name );
1882: ecx_debug.log(l_statement,'i_tp_type',i_tp_type,i_method_name );
1875: end if;
1876:
1877: if(l_statementEnabled) then
1878: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name );
1879: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name );
1880: ecx_debug.log(l_statement,'i_tp_id',i_tp_id,i_method_name );
1881: ecx_debug.log(l_statement,'i_tp_site_id',i_tp_site_id,i_method_name );
1882: ecx_debug.log(l_statement,'i_tp_type',i_tp_type,i_method_name );
1883: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name );
1876:
1877: if(l_statementEnabled) then
1878: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name );
1879: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name );
1880: ecx_debug.log(l_statement,'i_tp_id',i_tp_id,i_method_name );
1881: ecx_debug.log(l_statement,'i_tp_site_id',i_tp_site_id,i_method_name );
1882: ecx_debug.log(l_statement,'i_tp_type',i_tp_type,i_method_name );
1883: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name );
1884: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name );
1877: if(l_statementEnabled) then
1878: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name );
1879: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name );
1880: ecx_debug.log(l_statement,'i_tp_id',i_tp_id,i_method_name );
1881: ecx_debug.log(l_statement,'i_tp_site_id',i_tp_site_id,i_method_name );
1882: ecx_debug.log(l_statement,'i_tp_type',i_tp_type,i_method_name );
1883: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name );
1884: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name );
1885: end if;
1878: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name );
1879: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name );
1880: ecx_debug.log(l_statement,'i_tp_id',i_tp_id,i_method_name );
1881: ecx_debug.log(l_statement,'i_tp_site_id',i_tp_site_id,i_method_name );
1882: ecx_debug.log(l_statement,'i_tp_type',i_tp_type,i_method_name );
1883: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name );
1884: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name );
1885: end if;
1886: -- initialize i_tmpxmldoc
1879: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name );
1880: ecx_debug.log(l_statement,'i_tp_id',i_tp_id,i_method_name );
1881: ecx_debug.log(l_statement,'i_tp_site_id',i_tp_site_id,i_method_name );
1882: ecx_debug.log(l_statement,'i_tp_type',i_tp_type,i_method_name );
1883: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name );
1884: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name );
1885: end if;
1886: -- initialize i_tmpxmldoc
1887: dbms_lob.createtemporary(i_tmpxmldoc,TRUE,DBMS_LOB.SESSION);
1880: ecx_debug.log(l_statement,'i_tp_id',i_tp_id,i_method_name );
1881: ecx_debug.log(l_statement,'i_tp_site_id',i_tp_site_id,i_method_name );
1882: ecx_debug.log(l_statement,'i_tp_type',i_tp_type,i_method_name );
1883: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name );
1884: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name );
1885: end if;
1886: -- initialize i_tmpxmldoc
1887: dbms_lob.createtemporary(i_tmpxmldoc,TRUE,DBMS_LOB.SESSION);
1888:
1905: if i_tmpxmldoc is not null
1906: then
1907: dbms_lob.freetemporary (i_tmpxmldoc);
1908: end if;
1909: ecx_debug.setErrorInfo(0, 10, 'ECX_SUCCESSFUL_EXECUTION');
1910: i_ret_code := ecx_utils.i_ret_code;
1911: i_errbuf := ecx_utils.i_errbuf;
1912:
1913: if(ecx_utils.i_ret_code = 0 ) then
1911: i_errbuf := ecx_utils.i_errbuf;
1912:
1913: if(ecx_utils.i_ret_code = 0 ) then
1914: if(l_statementEnabled) then
1915: ecx_debug.log(l_statement, 'Ret Code',ecx_utils.i_ret_code,i_method_name);
1916: ecx_debug.log(l_statement, 'Ret Msg ',ecx_utils.i_errbuf,i_method_name);
1917: end if;
1918: else
1919: if(l_unexpectedEnabled) then
1912:
1913: if(ecx_utils.i_ret_code = 0 ) then
1914: if(l_statementEnabled) then
1915: ecx_debug.log(l_statement, 'Ret Code',ecx_utils.i_ret_code,i_method_name);
1916: ecx_debug.log(l_statement, 'Ret Msg ',ecx_utils.i_errbuf,i_method_name);
1917: end if;
1918: else
1919: if(l_unexpectedEnabled) then
1920: ecx_debug.log(l_unexpected, 'Ret Code',ecx_utils.i_ret_code,i_method_name);
1916: ecx_debug.log(l_statement, 'Ret Msg ',ecx_utils.i_errbuf,i_method_name);
1917: end if;
1918: else
1919: if(l_unexpectedEnabled) then
1920: ecx_debug.log(l_unexpected, 'Ret Code',ecx_utils.i_ret_code,i_method_name);
1921: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_utils.i_errbuf,i_method_name);
1922: end if;
1923: end if;
1924:
1917: end if;
1918: else
1919: if(l_unexpectedEnabled) then
1920: ecx_debug.log(l_unexpected, 'Ret Code',ecx_utils.i_ret_code,i_method_name);
1921: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_utils.i_errbuf,i_method_name);
1922: end if;
1923: end if;
1924:
1925: if(l_procedureEnabled) then
1922: end if;
1923: end if;
1924:
1925: if(l_procedureEnabled) then
1926: ecx_debug.pop(i_method_name);
1927: end if;
1928: IF (ecx_logging_enabled ) THEN
1929: ecx_debug.print_log;
1930: ecx_debug.disable_debug;
1925: if(l_procedureEnabled) then
1926: ecx_debug.pop(i_method_name);
1927: end if;
1928: IF (ecx_logging_enabled ) THEN
1929: ecx_debug.print_log;
1930: ecx_debug.disable_debug;
1931: END IF;
1932: EXCEPTION
1933: WHEN ecx_utils.program_exit THEN
1926: ecx_debug.pop(i_method_name);
1927: end if;
1928: IF (ecx_logging_enabled ) THEN
1929: ecx_debug.print_log;
1930: ecx_debug.disable_debug;
1931: END IF;
1932: EXCEPTION
1933: WHEN ecx_utils.program_exit THEN
1934: i_ret_code := ecx_utils.i_ret_code;
1933: WHEN ecx_utils.program_exit THEN
1934: i_ret_code := ecx_utils.i_ret_code;
1935: i_errbuf := ecx_utils.i_errbuf;
1936: if(l_unexpectedEnabled) then
1937: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1938: end if;
1939: if(l_procedureEnabled) then
1940: ecx_debug.pop(i_method_name);
1941: end if;
1936: if(l_unexpectedEnabled) then
1937: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1938: end if;
1939: if(l_procedureEnabled) then
1940: ecx_debug.pop(i_method_name);
1941: end if;
1942: -- free i_tmpxmldoc
1943: if i_tmpxmldoc is not null
1944: then
1944: then
1945: dbms_lob.freetemporary (i_tmpxmldoc);
1946: end if;
1947: IF (ecx_logging_enabled ) THEN
1948: ecx_debug.print_log;
1949: ecx_debug.disable_debug;
1950: END IF;
1951: WHEN OTHERS THEN
1952: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PUTMSG');
1945: dbms_lob.freetemporary (i_tmpxmldoc);
1946: end if;
1947: IF (ecx_logging_enabled ) THEN
1948: ecx_debug.print_log;
1949: ecx_debug.disable_debug;
1950: END IF;
1951: WHEN OTHERS THEN
1952: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PUTMSG');
1953: if(l_unexpectedEnabled) then
1948: ecx_debug.print_log;
1949: ecx_debug.disable_debug;
1950: END IF;
1951: WHEN OTHERS THEN
1952: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PUTMSG');
1953: if(l_unexpectedEnabled) then
1954: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.PUTMSG',i_method_name);
1955: end if;
1956: i_ret_code := ecx_utils.i_ret_code;
1950: END IF;
1951: WHEN OTHERS THEN
1952: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PUTMSG');
1953: if(l_unexpectedEnabled) then
1954: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.PUTMSG',i_method_name);
1955: end if;
1956: i_ret_code := ecx_utils.i_ret_code;
1957: i_errbuf := ecx_utils.i_errbuf;
1958: if(l_procedureEnabled) then
1955: end if;
1956: i_ret_code := ecx_utils.i_ret_code;
1957: i_errbuf := ecx_utils.i_errbuf;
1958: if(l_procedureEnabled) then
1959: ecx_debug.pop(i_method_name);
1960: end if;
1961: -- free i_tmpxmldoc
1962: if i_tmpxmldoc is not null
1963: then
1963: then
1964: dbms_lob.freetemporary (i_tmpxmldoc);
1965: end if;
1966: IF (ecx_logging_enabled ) THEN
1967: ecx_debug.print_log;
1968: ecx_debug.disable_debug;
1969: END IF;
1970: end GETXML;
1971:
1964: dbms_lob.freetemporary (i_tmpxmldoc);
1965: end if;
1966: IF (ecx_logging_enabled ) THEN
1967: ecx_debug.print_log;
1968: ecx_debug.disable_debug;
1969: END IF;
1970: end GETXML;
1971:
1972: end ecx_outbound;