APPS.ECE_INBOUND dependencies on EC_DEBUG

Line 29: if ec_debug.G_debug_level >= 2 then

25: )
26: is
27: i_select_cursor INTEGER;
28: BEGIN
29: if ec_debug.G_debug_level >= 2 then
30: ec_debug.PUSH('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
31: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
32: ec_debug.pl(3,'i_document_id',i_document_id);
33: end if;

Line 30: ec_debug.PUSH('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');

26: is
27: i_select_cursor INTEGER;
28: BEGIN
29: if ec_debug.G_debug_level >= 2 then
30: ec_debug.PUSH('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
31: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
32: ec_debug.pl(3,'i_document_id',i_document_id);
33: end if;
34:

Line 31: ec_debug.pl(3,'i_transaction_type',i_transaction_type);

27: i_select_cursor INTEGER;
28: BEGIN
29: if ec_debug.G_debug_level >= 2 then
30: ec_debug.PUSH('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
31: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
32: ec_debug.pl(3,'i_document_id',i_document_id);
33: end if;
34:
35: ec_utils.g_stack.DELETE;

Line 32: ec_debug.pl(3,'i_document_id',i_document_id);

28: BEGIN
29: if ec_debug.G_debug_level >= 2 then
30: ec_debug.PUSH('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
31: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
32: ec_debug.pl(3,'i_document_id',i_document_id);
33: end if;
34:
35: ec_utils.g_stack.DELETE;
36: ec_utils.g_documents_skipped := 0;

Line 62: if ec_debug.G_debug_level >= 2 then

58: IF dbms_sql.IS_OPEN(i_select_cursor)
59: then
60: dbms_sql.close_cursor(i_select_cursor);
61: end if;
62: if ec_debug.G_debug_level >= 2 then
63: ec_debug.POP('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
64: end if;
65:
66: EXCEPTION

Line 63: ec_debug.POP('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');

59: then
60: dbms_sql.close_cursor(i_select_cursor);
61: end if;
62: if ec_debug.G_debug_level >= 2 then
63: ec_debug.POP('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
64: end if;
65:
66: EXCEPTION
67: WHEN EC_UTILS.DOCUMENTS_UNDER_PROCESS then

Line 68: ec_debug.pl(0,'EC','ECE_DOCUMENTS_UNDER_PROCESS',null);

64: end if;
65:
66: EXCEPTION
67: WHEN EC_UTILS.DOCUMENTS_UNDER_PROCESS then
68: ec_debug.pl(0,'EC','ECE_DOCUMENTS_UNDER_PROCESS',null);
69: raise EC_UTILS.PROGRAM_EXIT;
70: WHEN EC_UTILS.PROGRAM_EXIT then
71: raise;
72: WHEN OTHERS THEN

Line 73: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');

69: raise EC_UTILS.PROGRAM_EXIT;
70: WHEN EC_UTILS.PROGRAM_EXIT then
71: raise;
72: WHEN OTHERS THEN
73: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
74: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
75: ec_utils.i_ret_code := 2;
76: raise EC_UTILS.PROGRAM_EXIT;
77: END process_inbound_documents;

Line 74: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

70: WHEN EC_UTILS.PROGRAM_EXIT then
71: raise;
72: WHEN OTHERS THEN
73: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
74: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
75: ec_utils.i_ret_code := 2;
76: raise EC_UTILS.PROGRAM_EXIT;
77: END process_inbound_documents;
78:

Line 102: if ec_debug.G_debug_level >= 2 then

98: i_select_cursor INTEGER;
99: i_count number:=0;
100:
101: begin
102: if ec_debug.G_debug_level >= 2 then
103: ec_debug.PUSH('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
104: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
105: ec_debug.pl(3,'i_run_id',i_run_id);
106: end if;

Line 103: ec_debug.PUSH('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');

99: i_count number:=0;
100:
101: begin
102: if ec_debug.G_debug_level >= 2 then
103: ec_debug.PUSH('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
104: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
105: ec_debug.pl(3,'i_run_id',i_run_id);
106: end if;
107:

Line 104: ec_debug.pl(3,'i_transaction_type',i_transaction_type);

100:
101: begin
102: if ec_debug.G_debug_level >= 2 then
103: ec_debug.PUSH('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
104: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
105: ec_debug.pl(3,'i_run_id',i_run_id);
106: end if;
107:
108: ec_utils.g_stack.DELETE;

Line 105: ec_debug.pl(3,'i_run_id',i_run_id);

101: begin
102: if ec_debug.G_debug_level >= 2 then
103: ec_debug.PUSH('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
104: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
105: ec_debug.pl(3,'i_run_id',i_run_id);
106: end if;
107:
108: ec_utils.g_stack.DELETE;
109: ec_utils.g_documents_skipped := 0;

Line 141: ec_debug.pl(0,'EC','ECE_DOCUMENTS_PROCESSED','NO_OF_DOCS',g_count); --Bug 2422787

137: */
138: g_count := g_count + 1;
139: end loop;
140: commit;
141: ec_debug.pl(0,'EC','ECE_DOCUMENTS_PROCESSED','NO_OF_DOCS',g_count); --Bug 2422787
142:
143: /**
144: Close the Cursors and print the information.
145: **/

Line 152: if ec_debug.G_debug_level >= 2 then

148: IF dbms_sql.IS_OPEN(i_select_cursor)
149: then
150: dbms_sql.close_cursor(i_select_cursor);
151: end if;
152: if ec_debug.G_debug_level >= 2 then
153: ec_debug.POP('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
154: end if;
155:
156: EXCEPTION

Line 153: ec_debug.POP('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');

149: then
150: dbms_sql.close_cursor(i_select_cursor);
151: end if;
152: if ec_debug.G_debug_level >= 2 then
153: ec_debug.POP('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
154: end if;
155:
156: EXCEPTION
157: WHEN EC_UTILS.DOCUMENTS_UNDER_PROCESS then

Line 158: ec_debug.pl(0,'EC','ECE_DOCUMENTS_UNDER_PROCESS',null);

154: end if;
155:
156: EXCEPTION
157: WHEN EC_UTILS.DOCUMENTS_UNDER_PROCESS then
158: ec_debug.pl(0,'EC','ECE_DOCUMENTS_UNDER_PROCESS',null);
159: raise EC_UTILS.PROGRAM_EXIT;
160: WHEN EC_UTILS.PROGRAM_EXIT then
161: raise;
162: WHEN OTHERS THEN

Line 163: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');

159: raise EC_UTILS.PROGRAM_EXIT;
160: WHEN EC_UTILS.PROGRAM_EXIT then
161: raise;
162: WHEN OTHERS THEN
163: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
164: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
165: ec_utils.i_ret_code := 2;
166: raise EC_UTILS.PROGRAM_EXIT;
167: end process_inbound_documents;

Line 164: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

160: WHEN EC_UTILS.PROGRAM_EXIT then
161: raise;
162: WHEN OTHERS THEN
163: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
164: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
165: ec_utils.i_ret_code := 2;
166: raise EC_UTILS.PROGRAM_EXIT;
167: end process_inbound_documents;
168:

Line 192: if ec_debug.G_debug_level >= 2 then

188: i_select_cursor number;
189: i_count number:=0;
190:
191: begin
192: if ec_debug.G_debug_level >= 2 then
193: ec_debug.PUSH('ECE_INBOUND.PROCESS_RUN_INBOUND');
194: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
195: ec_debug.pl(3,'i_run_id',i_run_id);
196: end if;

Line 193: ec_debug.PUSH('ECE_INBOUND.PROCESS_RUN_INBOUND');

189: i_count number:=0;
190:
191: begin
192: if ec_debug.G_debug_level >= 2 then
193: ec_debug.PUSH('ECE_INBOUND.PROCESS_RUN_INBOUND');
194: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
195: ec_debug.pl(3,'i_run_id',i_run_id);
196: end if;
197: /**

Line 194: ec_debug.pl(3,'i_transaction_type',i_transaction_type);

190:
191: begin
192: if ec_debug.G_debug_level >= 2 then
193: ec_debug.PUSH('ECE_INBOUND.PROCESS_RUN_INBOUND');
194: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
195: ec_debug.pl(3,'i_run_id',i_run_id);
196: end if;
197: /**
198: Gather table Statistics for CBO ( ece_stage , ece_rule_violations ).

Line 195: ec_debug.pl(3,'i_run_id',i_run_id);

191: begin
192: if ec_debug.G_debug_level >= 2 then
193: ec_debug.PUSH('ECE_INBOUND.PROCESS_RUN_INBOUND');
194: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
195: ec_debug.pl(3,'i_run_id',i_run_id);
196: end if;
197: /**
198: Gather table Statistics for CBO ( ece_stage , ece_rule_violations ).
199: **/

Line 288: ec_debug.pl(1,'EC','ECE_DELETE_FAILED_STAGING','DOCUMENT_ID',c1.document_id);

284: where document_id = c1.document_id;
285:
286: if sql%notfound
287: then
288: ec_debug.pl(1,'EC','ECE_DELETE_FAILED_STAGING','DOCUMENT_ID',c1.document_id);
289: ec_utils.i_ret_code :=1;
290: rollback to Document_Start;
291: end if;
292: end if;

Line 305: ec_debug.pl(0,'EC','ECE_DOCUMENTS_PROCESSED','NO_OF_DOCS',g_count); --Bug 2422787

301: */
302: g_count := g_count + 1;
303:
304: end loop;
305: ec_debug.pl(0,'EC','ECE_DOCUMENTS_PROCESSED','NO_OF_DOCS',g_count); --Bug 2422787
306: /**
307: Close the Cursors and print the information.
308: **/
309: close_inbound;

Line 315: if ec_debug.G_debug_level >= 2 then

311: IF dbms_sql.IS_OPEN(i_select_cursor)
312: then
313: dbms_sql.close_cursor(i_select_cursor);
314: end if;
315: if ec_debug.G_debug_level >= 2 then
316: ec_debug.POP('ECE_INBOUND.PROCESS_RUN_INBOUND');
317: end if;
318: EXCEPTION
319: WHEN EC_UTILS.DOCUMENTS_UNDER_PROCESS then

Line 316: ec_debug.POP('ECE_INBOUND.PROCESS_RUN_INBOUND');

312: then
313: dbms_sql.close_cursor(i_select_cursor);
314: end if;
315: if ec_debug.G_debug_level >= 2 then
316: ec_debug.POP('ECE_INBOUND.PROCESS_RUN_INBOUND');
317: end if;
318: EXCEPTION
319: WHEN EC_UTILS.DOCUMENTS_UNDER_PROCESS then
320: ec_debug.pl(0,'EC','ECE_DOCUMENTS_UNDER_PROCESS',null);

Line 320: ec_debug.pl(0,'EC','ECE_DOCUMENTS_UNDER_PROCESS',null);

316: ec_debug.POP('ECE_INBOUND.PROCESS_RUN_INBOUND');
317: end if;
318: EXCEPTION
319: WHEN EC_UTILS.DOCUMENTS_UNDER_PROCESS then
320: ec_debug.pl(0,'EC','ECE_DOCUMENTS_UNDER_PROCESS',null);
321: raise EC_UTILS.PROGRAM_EXIT;
322: WHEN EC_UTILS.PROGRAM_EXIT then
323: raise;
324: WHEN OTHERS THEN

Line 325: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_RUN_INBOUND');

321: raise EC_UTILS.PROGRAM_EXIT;
322: WHEN EC_UTILS.PROGRAM_EXIT then
323: raise;
324: WHEN OTHERS THEN
325: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_RUN_INBOUND');
326: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
327: ec_utils.i_ret_code := 2;
328: raise EC_UTILS.PROGRAM_EXIT;
329: end process_run_inbound;

Line 326: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

322: WHEN EC_UTILS.PROGRAM_EXIT then
323: raise;
324: WHEN OTHERS THEN
325: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_RUN_INBOUND');
326: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
327: ec_utils.i_ret_code := 2;
328: raise EC_UTILS.PROGRAM_EXIT;
329: end process_run_inbound;
330:

Line 354: if ec_debug.G_debug_level >= 2 then

350: i_select_cursor number;
351: i_count number:=0;
352:
353: begin
354: if ec_debug.G_debug_level >= 2 then
355: ec_debug.PUSH('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
356: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
357: ec_debug.pl(3,'i_status',i_status);
358: end if;

Line 355: ec_debug.PUSH('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');

351: i_count number:=0;
352:
353: begin
354: if ec_debug.G_debug_level >= 2 then
355: ec_debug.PUSH('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
356: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
357: ec_debug.pl(3,'i_status',i_status);
358: end if;
359: ec_utils.g_stack.DELETE;

Line 356: ec_debug.pl(3,'i_transaction_type',i_transaction_type);

352:
353: begin
354: if ec_debug.G_debug_level >= 2 then
355: ec_debug.PUSH('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
356: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
357: ec_debug.pl(3,'i_status',i_status);
358: end if;
359: ec_utils.g_stack.DELETE;
360: ec_utils.g_documents_skipped := 0;

Line 357: ec_debug.pl(3,'i_status',i_status);

353: begin
354: if ec_debug.G_debug_level >= 2 then
355: ec_debug.PUSH('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
356: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
357: ec_debug.pl(3,'i_status',i_status);
358: end if;
359: ec_utils.g_stack.DELETE;
360: ec_utils.g_documents_skipped := 0;
361: ec_utils.g_insert_failed := 0;

Line 392: ec_debug.pl(0,'EC','ECE_DOCUMENTS_PROCESSED','NO_OF_DOCS',g_count); --Bug 2422787

388: */
389: g_count := g_count + 1;
390:
391: end loop;
392: ec_debug.pl(0,'EC','ECE_DOCUMENTS_PROCESSED','NO_OF_DOCS',g_count); --Bug 2422787
393:
394: /**
395: Close the Cursors and print the information.
396: **/

Line 403: if ec_debug.G_debug_level >= 2 then

399: IF dbms_sql.IS_OPEN(i_select_cursor)
400: then
401: dbms_sql.close_cursor(i_select_cursor);
402: end if;
403: if ec_debug.G_debug_level >= 2 then
404: ec_debug.POP('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
405: end if;
406: EXCEPTION
407: WHEN EC_UTILS.DOCUMENTS_UNDER_PROCESS then

Line 404: ec_debug.POP('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');

400: then
401: dbms_sql.close_cursor(i_select_cursor);
402: end if;
403: if ec_debug.G_debug_level >= 2 then
404: ec_debug.POP('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
405: end if;
406: EXCEPTION
407: WHEN EC_UTILS.DOCUMENTS_UNDER_PROCESS then
408: ec_debug.pl(0,'EC','ECE_DOCUMENTS_UNDER_PROCESS',null);

Line 408: ec_debug.pl(0,'EC','ECE_DOCUMENTS_UNDER_PROCESS',null);

404: ec_debug.POP('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
405: end if;
406: EXCEPTION
407: WHEN EC_UTILS.DOCUMENTS_UNDER_PROCESS then
408: ec_debug.pl(0,'EC','ECE_DOCUMENTS_UNDER_PROCESS',null);
409: raise EC_UTILS.PROGRAM_EXIT;
410: WHEN EC_UTILS.PROGRAM_EXIT then
411: raise;
412: WHEN OTHERS THEN

Line 413: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');

409: raise EC_UTILS.PROGRAM_EXIT;
410: WHEN EC_UTILS.PROGRAM_EXIT then
411: raise;
412: WHEN OTHERS THEN
413: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
414: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
415: ec_utils.i_ret_code := 2;
416: raise EC_UTILS.PROGRAM_EXIT;
417: end process_inbound_documents;

Line 414: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

410: WHEN EC_UTILS.PROGRAM_EXIT then
411: raise;
412: WHEN OTHERS THEN
413: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
414: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
415: ec_utils.i_ret_code := 2;
416: raise EC_UTILS.PROGRAM_EXIT;
417: end process_inbound_documents;
418:

Line 439: if ec_debug.G_debug_level >= 2 then

435: i_select_cursor number;
436: i_count number:=0;
437:
438: begin
439: if ec_debug.G_debug_level >= 2 then
440: ec_debug.PUSH('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
441: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
442: end if;
443: ec_utils.g_stack.DELETE;

Line 440: ec_debug.PUSH('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');

436: i_count number:=0;
437:
438: begin
439: if ec_debug.G_debug_level >= 2 then
440: ec_debug.PUSH('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
441: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
442: end if;
443: ec_utils.g_stack.DELETE;
444: ec_utils.g_documents_skipped := 0;

Line 441: ec_debug.pl(3,'i_transaction_type',i_transaction_type);

437:
438: begin
439: if ec_debug.G_debug_level >= 2 then
440: ec_debug.PUSH('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
441: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
442: end if;
443: ec_utils.g_stack.DELETE;
444: ec_utils.g_documents_skipped := 0;
445: ec_utils.g_insert_failed := 0;

Line 478: ec_debug.pl(0,'EC','ECE_DOCUMENTS_PROCESSED','NO_OF_DOCS',g_count);

474: end loop;
475:
476: commit;
477:
478: ec_debug.pl(0,'EC','ECE_DOCUMENTS_PROCESSED','NO_OF_DOCS',g_count);
479:
480: /**
481: Close the Cursors and print the information.
482: **/

Line 489: if ec_debug.G_debug_level >= 2 then

485: IF dbms_sql.IS_OPEN(i_select_cursor)
486: then
487: dbms_sql.close_cursor(i_select_cursor);
488: end if;
489: if ec_debug.G_debug_level >= 2 then
490: ec_debug.POP('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
491: end if;
492: EXCEPTION
493: WHEN EC_UTILS.DOCUMENTS_UNDER_PROCESS then

Line 490: ec_debug.POP('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');

486: then
487: dbms_sql.close_cursor(i_select_cursor);
488: end if;
489: if ec_debug.G_debug_level >= 2 then
490: ec_debug.POP('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
491: end if;
492: EXCEPTION
493: WHEN EC_UTILS.DOCUMENTS_UNDER_PROCESS then
494: ec_debug.pl(0,'EC','ECE_DOCUMENTS_UNDER_PROCESS',null);

Line 494: ec_debug.pl(0,'EC','ECE_DOCUMENTS_UNDER_PROCESS',null);

490: ec_debug.POP('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
491: end if;
492: EXCEPTION
493: WHEN EC_UTILS.DOCUMENTS_UNDER_PROCESS then
494: ec_debug.pl(0,'EC','ECE_DOCUMENTS_UNDER_PROCESS',null);
495: raise EC_UTILS.PROGRAM_EXIT;
496: WHEN EC_UTILS.PROGRAM_EXIT then
497: raise;
498: WHEN OTHERS THEN

Line 499: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');

495: raise EC_UTILS.PROGRAM_EXIT;
496: WHEN EC_UTILS.PROGRAM_EXIT then
497: raise;
498: WHEN OTHERS THEN
499: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
500: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
501: ec_utils.i_ret_code := 2;
502: raise EC_UTILS.PROGRAM_EXIT;
503: end process_inbound_documents;

Line 500: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

496: WHEN EC_UTILS.PROGRAM_EXIT then
497: raise;
498: WHEN OTHERS THEN
499: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
500: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
501: ec_utils.i_ret_code := 2;
502: raise EC_UTILS.PROGRAM_EXIT;
503: end process_inbound_documents;
504:

Line 545: if ec_debug.G_debug_level >= 2 then

541: i_select_cursor number;
542: i_count number:=0;
543:
544: begin
545: if ec_debug.G_debug_level >= 2 then
546: ec_debug.PUSH('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
547: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
548: ec_debug.pl(3,'i_tp_code',i_tp_code);
549: ec_debug.pl(3,'i_status',i_status);

Line 546: ec_debug.PUSH('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');

542: i_count number:=0;
543:
544: begin
545: if ec_debug.G_debug_level >= 2 then
546: ec_debug.PUSH('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
547: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
548: ec_debug.pl(3,'i_tp_code',i_tp_code);
549: ec_debug.pl(3,'i_status',i_status);
550: end if;

Line 547: ec_debug.pl(3,'i_transaction_type',i_transaction_type);

543:
544: begin
545: if ec_debug.G_debug_level >= 2 then
546: ec_debug.PUSH('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
547: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
548: ec_debug.pl(3,'i_tp_code',i_tp_code);
549: ec_debug.pl(3,'i_status',i_status);
550: end if;
551: ec_utils.g_stack.DELETE;

Line 548: ec_debug.pl(3,'i_tp_code',i_tp_code);

544: begin
545: if ec_debug.G_debug_level >= 2 then
546: ec_debug.PUSH('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
547: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
548: ec_debug.pl(3,'i_tp_code',i_tp_code);
549: ec_debug.pl(3,'i_status',i_status);
550: end if;
551: ec_utils.g_stack.DELETE;
552: ec_utils.g_documents_skipped := 0;

Line 549: ec_debug.pl(3,'i_status',i_status);

545: if ec_debug.G_debug_level >= 2 then
546: ec_debug.PUSH('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
547: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
548: ec_debug.pl(3,'i_tp_code',i_tp_code);
549: ec_debug.pl(3,'i_status',i_status);
550: end if;
551: ec_utils.g_stack.DELETE;
552: ec_utils.g_documents_skipped := 0;
553: ec_utils.g_insert_failed := 0;

Line 560: if ec_debug.G_debug_level = 3 then

556: select_stage ( i_select_cursor );
557:
558: if i_tp_code is not null
559: then
560: if ec_debug.G_debug_level = 3 then
561: ec_debug.pl(3,'i_tp_code',i_tp_code);
562: end if;
563: for c1 in documents
564: (

Line 561: ec_debug.pl(3,'i_tp_code',i_tp_code);

557:
558: if i_tp_code is not null
559: then
560: if ec_debug.G_debug_level = 3 then
561: ec_debug.pl(3,'i_tp_code',i_tp_code);
562: end if;
563: for c1 in documents
564: (
565: p_status => i_status ,

Line 592: if ec_debug.G_debug_level = 3 then

588: g_count := g_count + 1;
589: end loop;
590: elsif i_tp_code is null
591: then
592: if ec_debug.G_debug_level = 3 then
593: ec_debug.pl(3,'i_tp_code','NULL');
594: end if;
595: for c1 in documents_fornulltp
596: (

Line 593: ec_debug.pl(3,'i_tp_code','NULL');

589: end loop;
590: elsif i_tp_code is null
591: then
592: if ec_debug.G_debug_level = 3 then
593: ec_debug.pl(3,'i_tp_code','NULL');
594: end if;
595: for c1 in documents_fornulltp
596: (
597: p_status => i_status ,

Line 623: ec_debug.pl(3,'iii','invalid tp code');

619: g_count := g_count + 1;
620:
621: end loop;
622: else
623: ec_debug.pl(3,'iii','invalid tp code');
624: end if;
625:
626: commit;
627:

Line 628: ec_debug.pl(1,'EC','ECE_DOCUMENTS_PROCESSED','NO_OF_DOCS',g_count); --Bug 2422787

624: end if;
625:
626: commit;
627:
628: ec_debug.pl(1,'EC','ECE_DOCUMENTS_PROCESSED','NO_OF_DOCS',g_count); --Bug 2422787
629:
630: /**
631: Close the Cursors and print the information.
632: **/

Line 639: if ec_debug.G_debug_level >= 2 then

635: IF dbms_sql.IS_OPEN(i_select_cursor)
636: then
637: dbms_sql.close_cursor(i_select_cursor);
638: end if;
639: if ec_debug.G_debug_level >= 2 then
640: ec_debug.POP('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
641: end if;
642: EXCEPTION
643: WHEN EC_UTILS.DOCUMENTS_UNDER_PROCESS then

Line 640: ec_debug.POP('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');

636: then
637: dbms_sql.close_cursor(i_select_cursor);
638: end if;
639: if ec_debug.G_debug_level >= 2 then
640: ec_debug.POP('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
641: end if;
642: EXCEPTION
643: WHEN EC_UTILS.DOCUMENTS_UNDER_PROCESS then
644: ec_debug.pl(0,'EC','ECE_DOCUMENTS_UNDER_PROCESS',null);

Line 644: ec_debug.pl(0,'EC','ECE_DOCUMENTS_UNDER_PROCESS',null);

640: ec_debug.POP('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
641: end if;
642: EXCEPTION
643: WHEN EC_UTILS.DOCUMENTS_UNDER_PROCESS then
644: ec_debug.pl(0,'EC','ECE_DOCUMENTS_UNDER_PROCESS',null);
645: raise EC_UTILS.PROGRAM_EXIT;
646: WHEN EC_UTILS.PROGRAM_EXIT then
647: raise;
648: WHEN OTHERS THEN

Line 649: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');

645: raise EC_UTILS.PROGRAM_EXIT;
646: WHEN EC_UTILS.PROGRAM_EXIT then
647: raise;
648: WHEN OTHERS THEN
649: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
650: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
651: ec_utils.i_ret_code := 2;
652: raise EC_UTILS.PROGRAM_EXIT;
653: end process_inbound_documents;

Line 650: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

646: WHEN EC_UTILS.PROGRAM_EXIT then
647: raise;
648: WHEN OTHERS THEN
649: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
650: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
651: ec_utils.i_ret_code := 2;
652: raise EC_UTILS.PROGRAM_EXIT;
653: end process_inbound_documents;
654:

Line 701: if ec_debug.G_debug_level >= 2 then

697: nvl(ignore_flag,'N') = 'Y';
698:
699:
700: BEGIN
701: if ec_debug.G_debug_level >= 2 then
702: ec_debug.push('ECE_INBOUND.RUN_INBOUND');
703: ec_debug.pl(3,'i_document_id',i_document_id);
704: ec_debug.pl(3,'i_select_cursor',i_select_cursor);
705: end if;

Line 702: ec_debug.push('ECE_INBOUND.RUN_INBOUND');

698:
699:
700: BEGIN
701: if ec_debug.G_debug_level >= 2 then
702: ec_debug.push('ECE_INBOUND.RUN_INBOUND');
703: ec_debug.pl(3,'i_document_id',i_document_id);
704: ec_debug.pl(3,'i_select_cursor',i_select_cursor);
705: end if;
706: --Set the Document Id package variable

Line 703: ec_debug.pl(3,'i_document_id',i_document_id);

699:
700: BEGIN
701: if ec_debug.G_debug_level >= 2 then
702: ec_debug.push('ECE_INBOUND.RUN_INBOUND');
703: ec_debug.pl(3,'i_document_id',i_document_id);
704: ec_debug.pl(3,'i_select_cursor',i_select_cursor);
705: end if;
706: --Set the Document Id package variable
707: ec_utils.g_document_id := i_document_id;

Line 704: ec_debug.pl(3,'i_select_cursor',i_select_cursor);

700: BEGIN
701: if ec_debug.G_debug_level >= 2 then
702: ec_debug.push('ECE_INBOUND.RUN_INBOUND');
703: ec_debug.pl(3,'i_document_id',i_document_id);
704: ec_debug.pl(3,'i_select_cursor',i_select_cursor);
705: end if;
706: --Set the Document Id package variable
707: ec_utils.g_document_id := i_document_id;
708:

Line 739: if ec_debug.G_debug_level = 3 then

735: dbms_sql.column_value(i_select_cursor,5,i_status);
736:
737: dbms_sql.column_value(i_select_cursor,6,i_map_id);
738:
739: if ec_debug.G_debug_level = 3 then
740: ec_debug.pl(3,'i_stage_id',i_stage_id);
741: ec_debug.pl(3,'i_document_number',i_document_number);
742: ec_debug.pl(3,'i_previous_level',i_previous_level);
743: ec_debug.pl(3,'i_level',i_level);

Line 740: ec_debug.pl(3,'i_stage_id',i_stage_id);

736:
737: dbms_sql.column_value(i_select_cursor,6,i_map_id);
738:
739: if ec_debug.G_debug_level = 3 then
740: ec_debug.pl(3,'i_stage_id',i_stage_id);
741: ec_debug.pl(3,'i_document_number',i_document_number);
742: ec_debug.pl(3,'i_previous_level',i_previous_level);
743: ec_debug.pl(3,'i_level',i_level);
744: ec_debug.pl(3,'i_line_number',i_line_number);

Line 741: ec_debug.pl(3,'i_document_number',i_document_number);

737: dbms_sql.column_value(i_select_cursor,6,i_map_id);
738:
739: if ec_debug.G_debug_level = 3 then
740: ec_debug.pl(3,'i_stage_id',i_stage_id);
741: ec_debug.pl(3,'i_document_number',i_document_number);
742: ec_debug.pl(3,'i_previous_level',i_previous_level);
743: ec_debug.pl(3,'i_level',i_level);
744: ec_debug.pl(3,'i_line_number',i_line_number);
745: ec_debug.pl(3,'i_status',i_status);

Line 742: ec_debug.pl(3,'i_previous_level',i_previous_level);

738:
739: if ec_debug.G_debug_level = 3 then
740: ec_debug.pl(3,'i_stage_id',i_stage_id);
741: ec_debug.pl(3,'i_document_number',i_document_number);
742: ec_debug.pl(3,'i_previous_level',i_previous_level);
743: ec_debug.pl(3,'i_level',i_level);
744: ec_debug.pl(3,'i_line_number',i_line_number);
745: ec_debug.pl(3,'i_status',i_status);
746: ec_debug.pl(3,'i_map_id',i_map_id);

Line 743: ec_debug.pl(3,'i_level',i_level);

739: if ec_debug.G_debug_level = 3 then
740: ec_debug.pl(3,'i_stage_id',i_stage_id);
741: ec_debug.pl(3,'i_document_number',i_document_number);
742: ec_debug.pl(3,'i_previous_level',i_previous_level);
743: ec_debug.pl(3,'i_level',i_level);
744: ec_debug.pl(3,'i_line_number',i_line_number);
745: ec_debug.pl(3,'i_status',i_status);
746: ec_debug.pl(3,'i_map_id',i_map_id);
747: ec_debug.pl(3,'g_previous_map_id',g_previous_map_id);

Line 744: ec_debug.pl(3,'i_line_number',i_line_number);

740: ec_debug.pl(3,'i_stage_id',i_stage_id);
741: ec_debug.pl(3,'i_document_number',i_document_number);
742: ec_debug.pl(3,'i_previous_level',i_previous_level);
743: ec_debug.pl(3,'i_level',i_level);
744: ec_debug.pl(3,'i_line_number',i_line_number);
745: ec_debug.pl(3,'i_status',i_status);
746: ec_debug.pl(3,'i_map_id',i_map_id);
747: ec_debug.pl(3,'g_previous_map_id',g_previous_map_id);
748: end if;

Line 745: ec_debug.pl(3,'i_status',i_status);

741: ec_debug.pl(3,'i_document_number',i_document_number);
742: ec_debug.pl(3,'i_previous_level',i_previous_level);
743: ec_debug.pl(3,'i_level',i_level);
744: ec_debug.pl(3,'i_line_number',i_line_number);
745: ec_debug.pl(3,'i_status',i_status);
746: ec_debug.pl(3,'i_map_id',i_map_id);
747: ec_debug.pl(3,'g_previous_map_id',g_previous_map_id);
748: end if;
749: if (i_level = 1) and (i_map_id <> g_previous_map_id) then

Line 746: ec_debug.pl(3,'i_map_id',i_map_id);

742: ec_debug.pl(3,'i_previous_level',i_previous_level);
743: ec_debug.pl(3,'i_level',i_level);
744: ec_debug.pl(3,'i_line_number',i_line_number);
745: ec_debug.pl(3,'i_status',i_status);
746: ec_debug.pl(3,'i_map_id',i_map_id);
747: ec_debug.pl(3,'g_previous_map_id',g_previous_map_id);
748: end if;
749: if (i_level = 1) and (i_map_id <> g_previous_map_id) then
750: initialize_inbound (i_transaction_type, i_map_id);

Line 747: ec_debug.pl(3,'g_previous_map_id',g_previous_map_id);

743: ec_debug.pl(3,'i_level',i_level);
744: ec_debug.pl(3,'i_line_number',i_line_number);
745: ec_debug.pl(3,'i_status',i_status);
746: ec_debug.pl(3,'i_map_id',i_map_id);
747: ec_debug.pl(3,'g_previous_map_id',g_previous_map_id);
748: end if;
749: if (i_level = 1) and (i_map_id <> g_previous_map_id) then
750: initialize_inbound (i_transaction_type, i_map_id);
751: g_previous_map_id := i_map_id;

Line 762: if ec_debug.G_debug_level = 3 then

758: before continue processing the new fetched data.
759: **/
760:
761: if (i_level <= i_previous_level) and NOT (i_insert) then
762: if ec_debug.G_debug_level = 3 then
763: ec_debug.pl(3,'Ready to insert into open interface table');
764: ec_debug.pl(3,'i_interface_level',i_interface_level);
765: end if;
766: /**

Line 763: ec_debug.pl(3,'Ready to insert into open interface table');

759: **/
760:
761: if (i_level <= i_previous_level) and NOT (i_insert) then
762: if ec_debug.G_debug_level = 3 then
763: ec_debug.pl(3,'Ready to insert into open interface table');
764: ec_debug.pl(3,'i_interface_level',i_interface_level);
765: end if;
766: /**
767: If the last_insert_level is a lower level, then we have to

Line 764: ec_debug.pl(3,'i_interface_level',i_interface_level);

760:
761: if (i_level <= i_previous_level) and NOT (i_insert) then
762: if ec_debug.G_debug_level = 3 then
763: ec_debug.pl(3,'Ready to insert into open interface table');
764: ec_debug.pl(3,'i_interface_level',i_interface_level);
765: end if;
766: /**
767: If the last_insert_level is a lower level, then we have to
768: make sure we clean up all the lower level data so that it would

Line 793: ec_debug.pl(1,'EC','ECE_INSERT_SKIPPED','DOCUMENT_ID',i_document_id);

789: if NOT ( i_insert_ok) then
790: ec_utils.g_ext_levels(1).Status := 'INSERT_FAILED';
791: ec_utils.g_ext_levels(i_level).Status := ec_utils.g_ext_levels(1).status;
792: ec_utils.g_insert_failed := ec_utils.g_insert_failed + 1;
793: ec_debug.pl(1,'EC','ECE_INSERT_SKIPPED','DOCUMENT_ID',i_document_id);
794:
795: /**
796: Exit the processing for the Document
797: **/

Line 816: ec_debug.pl(0,'This Line has Lossy Conversion Exception ');

812:
813: --Bug 2164672
814: if ec_utils.g_ext_levels(i_level).status = 'LOSSY_CONVERSION' then
815: ec_utils.g_ext_levels(i_level).Status := 'SKIP_DOCUMENT';
816: ec_debug.pl(0,'This Line has Lossy Conversion Exception ');
817: goto skip_document;
818: end if;
819:
820: /**

Line 854: if ec_debug.G_debug_level = 3 then

850: To extract Field3 , first Find out the relative position of the Column
851: in the Select Statement which is 6 + 3 ( 3 for Field3 , 5 for Field5).
852: Pass this to the DBMS_SQL call to get the Column Value.
853: **/
854: if ec_debug.G_debug_level = 3 then
855: ec_debug.pl(3,'EC','ECE_FIELDS_EXTRACTED_STAGING',null);
856: end if;
857: for i in ec_utils.g_ext_levels(i_level).file_start_pos..ec_utils.g_ext_levels(i_level).file_end_pos
858: loop

Line 855: ec_debug.pl(3,'EC','ECE_FIELDS_EXTRACTED_STAGING',null);

851: in the Select Statement which is 6 + 3 ( 3 for Field3 , 5 for Field5).
852: Pass this to the DBMS_SQL call to get the Column Value.
853: **/
854: if ec_debug.G_debug_level = 3 then
855: ec_debug.pl(3,'EC','ECE_FIELDS_EXTRACTED_STAGING',null);
856: end if;
857: for i in ec_utils.g_ext_levels(i_level).file_start_pos..ec_utils.g_ext_levels(i_level).file_end_pos
858: loop
859: if ec_utils.g_file_tbl(i).Staging_Column is not null

Line 888: if ec_debug.G_debug_level = 3 then --bug 2500898

884: then
885: ec_utils.g_file_tbl(i).value := m_file_tbl_empty(i).value;
886: end if;
887:
888: if ec_debug.G_debug_level = 3 then --bug 2500898
889: if ec_utils.g_file_tbl(i).value is not null
890: then
891: ec_debug.pl(3,'i_Interface_Column_Name',ec_utils.g_file_tbl(i).Interface_Column_Name);
892: ec_debug.pl(3,'i_field_name',ec_utils.g_file_tbl(i).Staging_Column);

Line 891: ec_debug.pl(3,'i_Interface_Column_Name',ec_utils.g_file_tbl(i).Interface_Column_Name);

887:
888: if ec_debug.G_debug_level = 3 then --bug 2500898
889: if ec_utils.g_file_tbl(i).value is not null
890: then
891: ec_debug.pl(3,'i_Interface_Column_Name',ec_utils.g_file_tbl(i).Interface_Column_Name);
892: ec_debug.pl(3,'i_field_name',ec_utils.g_file_tbl(i).Staging_Column);
893: ec_debug.pl(3,'i_field_value',ec_utils.g_file_tbl(i).value);
894: end if;
895: end if;

Line 892: ec_debug.pl(3,'i_field_name',ec_utils.g_file_tbl(i).Staging_Column);

888: if ec_debug.G_debug_level = 3 then --bug 2500898
889: if ec_utils.g_file_tbl(i).value is not null
890: then
891: ec_debug.pl(3,'i_Interface_Column_Name',ec_utils.g_file_tbl(i).Interface_Column_Name);
892: ec_debug.pl(3,'i_field_name',ec_utils.g_file_tbl(i).Staging_Column);
893: ec_debug.pl(3,'i_field_value',ec_utils.g_file_tbl(i).value);
894: end if;
895: end if;
896:

Line 893: ec_debug.pl(3,'i_field_value',ec_utils.g_file_tbl(i).value);

889: if ec_utils.g_file_tbl(i).value is not null
890: then
891: ec_debug.pl(3,'i_Interface_Column_Name',ec_utils.g_file_tbl(i).Interface_Column_Name);
892: ec_debug.pl(3,'i_field_name',ec_utils.g_file_tbl(i).Staging_Column);
893: ec_debug.pl(3,'i_field_value',ec_utils.g_file_tbl(i).value);
894: end if;
895: end if;
896:
897: end if; --- Staging Column mapped to the Interface Column

Line 918: ec_debug.pl(0,'EC','ECE_VARIABLE_NOT_ON_STACK','VARIABLE_NAME','P_ADDRESS_TYPE');

914: i_plsql_pos
915: );
916: if not (m_var_found)
917: then
918: ec_debug.pl(0,'EC','ECE_VARIABLE_NOT_ON_STACK','VARIABLE_NAME','P_ADDRESS_TYPE');
919: ec_utils.i_ret_code :=2;
920: raise ec_utils.program_exit;
921: end if;
922:

Line 1051: ec_debug.pl(1,'EC','ECE_DOCUMENT_SKIPPED','DOCUMENT_ID',i_document_id);

1047: run of the transaction.
1048: **/
1049: if ec_utils.g_ext_levels(i_level).Status = 'SKIP_DOCUMENT'
1050: then
1051: ec_debug.pl(1,'EC','ECE_DOCUMENT_SKIPPED','DOCUMENT_ID',i_document_id);
1052: ec_utils.g_documents_skipped := ec_utils.g_documents_skipped + 1;
1053: end if;
1054:
1055: /**

Line 1083: ec_debug.pl (3, 'i', i);

1079: loop
1080: if ec_utils.g_int_ext_levels(i).external_level = i_level then
1081: i_interface_level := ec_utils.g_int_ext_levels(i).interface_level;
1082: i_insert := FALSE;
1083: ec_debug.pl (3, 'i', i);
1084: if i < ec_utils.g_int_ext_levels.COUNT then
1085: if ec_utils.g_int_ext_levels(i+1).interface_level <>
1086: ec_utils.g_int_ext_levels(i).interface_level then
1087: i_insert := TRUE;

Line 1095: if ec_debug.G_debug_level = 3 then

1091: end if;
1092:
1093: if i_insert then
1094: i_last_insert_level := i_level;
1095: if ec_debug.G_debug_level = 3 then
1096: ec_debug.pl(3,'Ready to insert into open interface table');
1097: ec_debug.pl(3,'i_interface_level',i_interface_level);
1098: end if;
1099: --Insert_into_prod_interface;

Line 1096: ec_debug.pl(3,'Ready to insert into open interface table');

1092:
1093: if i_insert then
1094: i_last_insert_level := i_level;
1095: if ec_debug.G_debug_level = 3 then
1096: ec_debug.pl(3,'Ready to insert into open interface table');
1097: ec_debug.pl(3,'i_interface_level',i_interface_level);
1098: end if;
1099: --Insert_into_prod_interface;
1100: i_insert_ok := Insert_Into_prod_Interface

Line 1097: ec_debug.pl(3,'i_interface_level',i_interface_level);

1093: if i_insert then
1094: i_last_insert_level := i_level;
1095: if ec_debug.G_debug_level = 3 then
1096: ec_debug.pl(3,'Ready to insert into open interface table');
1097: ec_debug.pl(3,'i_interface_level',i_interface_level);
1098: end if;
1099: --Insert_into_prod_interface;
1100: i_insert_ok := Insert_Into_prod_Interface
1101: (

Line 1112: ec_debug.pl(1,'EC','ECE_INSERT_SKIPPED','DOCUMENT_ID',i_document_id);

1108: then
1109: ec_utils.g_ext_levels(1).Status := 'INSERT_FAILED';
1110: ec_utils.g_ext_levels(i_level).Status := ec_utils.g_ext_levels(1).status;
1111: ec_utils.g_insert_failed := ec_utils.g_insert_failed + 1;
1112: ec_debug.pl(1,'EC','ECE_INSERT_SKIPPED','DOCUMENT_ID',i_document_id);
1113:
1114: /**
1115: Exit the processing for the Document
1116: **/

Line 1133: ec_debug.pl(1,'EC','ECE_DOCUMENT_SKIPPED','DOCUMENT_ID',i_document_id);

1129: /**
1130: Keep Track of how many documents have been skipped in this
1131: run of the transaction.
1132: **/
1133: ec_debug.pl(1,'EC','ECE_DOCUMENT_SKIPPED','DOCUMENT_ID',i_document_id);
1134: ec_utils.g_documents_skipped := ec_utils.g_documents_skipped + 1;
1135:
1136: /**
1137: Exit the processing for the Document

Line 1161: if ec_debug.G_debug_level = 3 then

1157: ec_utils.g_file_tbl(k).value := m_file_tbl_empty(k).value;
1158: end loop;
1159: end if;
1160:
1161: if ec_debug.G_debug_level = 3 then
1162: ec_debug.pl(3,'Ready to insert into open interface table');
1163: ec_debug.pl(3,'i_interface_level',i_interface_level);
1164: end if ;
1165:

Line 1162: ec_debug.pl(3,'Ready to insert into open interface table');

1158: end loop;
1159: end if;
1160:
1161: if ec_debug.G_debug_level = 3 then
1162: ec_debug.pl(3,'Ready to insert into open interface table');
1163: ec_debug.pl(3,'i_interface_level',i_interface_level);
1164: end if ;
1165:
1166: --Insert_into_prod_interface;

Line 1163: ec_debug.pl(3,'i_interface_level',i_interface_level);

1159: end if;
1160:
1161: if ec_debug.G_debug_level = 3 then
1162: ec_debug.pl(3,'Ready to insert into open interface table');
1163: ec_debug.pl(3,'i_interface_level',i_interface_level);
1164: end if ;
1165:
1166: --Insert_into_prod_interface;
1167: i_insert_ok := Insert_Into_prod_Interface

Line 1178: ec_debug.pl(1,'EC','ECE_INSERT_SKIPPED','DOCUMENT_ID',i_document_id);

1174: if NOT ( i_insert_ok) then
1175: ec_utils.g_ext_levels(1).Status := 'INSERT_FAILED';
1176: ec_utils.g_ext_levels(i_level).Status := ec_utils.g_ext_levels(1).status;
1177: ec_utils.g_insert_failed := ec_utils.g_insert_failed + 1;
1178: ec_debug.pl(1,'EC','ECE_INSERT_SKIPPED','DOCUMENT_ID',i_document_id);
1179: end if;
1180:
1181: end if;
1182:

Line 1184: if ec_debug.G_debug_level >= 1 then

1180:
1181: end if;
1182:
1183: i_total_records := dbms_sql.last_row_count;
1184: if ec_debug.G_debug_level >= 1 then
1185: ec_debug.pl(1,'EC','ECE_TOTAL_RECORDS_PROCESSED','TOTAL_RECORDS',i_total_records,'DOCUMENT_ID',i_document_id);
1186:
1187: ec_debug.POP('ECE_INBOUND.RUN_INBOUND');
1188: end if;

Line 1185: ec_debug.pl(1,'EC','ECE_TOTAL_RECORDS_PROCESSED','TOTAL_RECORDS',i_total_records,'DOCUMENT_ID',i_document_id);

1181: end if;
1182:
1183: i_total_records := dbms_sql.last_row_count;
1184: if ec_debug.G_debug_level >= 1 then
1185: ec_debug.pl(1,'EC','ECE_TOTAL_RECORDS_PROCESSED','TOTAL_RECORDS',i_total_records,'DOCUMENT_ID',i_document_id);
1186:
1187: ec_debug.POP('ECE_INBOUND.RUN_INBOUND');
1188: end if;
1189:

Line 1187: ec_debug.POP('ECE_INBOUND.RUN_INBOUND');

1183: i_total_records := dbms_sql.last_row_count;
1184: if ec_debug.G_debug_level >= 1 then
1185: ec_debug.pl(1,'EC','ECE_TOTAL_RECORDS_PROCESSED','TOTAL_RECORDS',i_total_records,'DOCUMENT_ID',i_document_id);
1186:
1187: ec_debug.POP('ECE_INBOUND.RUN_INBOUND');
1188: end if;
1189:
1190: EXCEPTION
1191: WHEN EC_UTILS.DOCUMENTS_UNDER_PROCESS then

Line 1192: ec_debug.pl(0,'EC','ECE_DOCUMENTS_UNDER_PROCESS',null);

1188: end if;
1189:
1190: EXCEPTION
1191: WHEN EC_UTILS.DOCUMENTS_UNDER_PROCESS then
1192: ec_debug.pl(0,'EC','ECE_DOCUMENTS_UNDER_PROCESS',null);
1193: ec_utils.i_ret_code :=0;
1194: raise EC_UTILS.PROGRAM_EXIT;
1195: WHEN EC_UTILS.PROGRAM_EXIT then
1196: raise;

Line 1198: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.RUN_INBOUND');

1194: raise EC_UTILS.PROGRAM_EXIT;
1195: WHEN EC_UTILS.PROGRAM_EXIT then
1196: raise;
1197: WHEN OTHERS THEN
1198: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.RUN_INBOUND');
1199: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1200: ec_utils.i_ret_code := 2;
1201: raise EC_UTILS.PROGRAM_EXIT;
1202: END run_inbound;

Line 1199: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

1195: WHEN EC_UTILS.PROGRAM_EXIT then
1196: raise;
1197: WHEN OTHERS THEN
1198: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.RUN_INBOUND');
1199: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1200: ec_utils.i_ret_code := 2;
1201: raise EC_UTILS.PROGRAM_EXIT;
1202: END run_inbound;
1203:

Line 1208: if ec_debug.G_debug_level >= 2 then

1204: procedure update_document_status
1205: is
1206: BEGIN
1207:
1208: if ec_debug.G_debug_level >= 2 then
1209: ec_debug.push('ECE_INBOUND.UPDATE_DOCUMENT_STATUS');
1210: end if;
1211: /**
1212: Update Header record in the Staging Table.

Line 1209: ec_debug.push('ECE_INBOUND.UPDATE_DOCUMENT_STATUS');

1205: is
1206: BEGIN
1207:
1208: if ec_debug.G_debug_level >= 2 then
1209: ec_debug.push('ECE_INBOUND.UPDATE_DOCUMENT_STATUS');
1210: end if;
1211: /**
1212: Update Header record in the Staging Table.
1213: **/

Line 1222: ec_debug.pl(0,'EC','ECE_STATUS_UPDATE_FAILED','DOCUMENT_ID',

1218: and line_number = 1;
1219:
1220: if sql%notfound
1221: then
1222: ec_debug.pl(0,'EC','ECE_STATUS_UPDATE_FAILED','DOCUMENT_ID',
1223: ec_utils.g_ext_levels(ec_utils.g_current_level).Document_Id);
1224: ec_utils.i_ret_code := 2;
1225: raise EC_UTILS.PROGRAM_EXIT;
1226: end if;

Line 1252: ec_debug.pl(0,'EC','ECE_STATUS_UPDATE_FAILED','DOCUMENT_ID',

1248: where stage_id = ec_utils.g_ext_levels(ec_utils.g_current_level).stage_id;
1249:
1250: if sql%notfound
1251: then
1252: ec_debug.pl(0,'EC','ECE_STATUS_UPDATE_FAILED','DOCUMENT_ID',
1253: ec_utils.g_ext_levels(ec_utils.g_current_level).Document_Id);
1254: ec_utils.i_ret_code := 2;
1255: raise EC_UTILS.PROGRAM_EXIT;
1256: end if;

Line 1259: if ec_debug.G_debug_level >= 2 then

1255: raise EC_UTILS.PROGRAM_EXIT;
1256: end if;
1257:
1258: end if;
1259: if ec_debug.G_debug_level >= 2 then
1260: ec_debug.pop('ECE_INBOUND.UPDATE_DOCUMENT_STATUS');
1261: end if;
1262: EXCEPTION
1263: WHEN EC_UTILS.PROGRAM_EXIT then

Line 1260: ec_debug.pop('ECE_INBOUND.UPDATE_DOCUMENT_STATUS');

1256: end if;
1257:
1258: end if;
1259: if ec_debug.G_debug_level >= 2 then
1260: ec_debug.pop('ECE_INBOUND.UPDATE_DOCUMENT_STATUS');
1261: end if;
1262: EXCEPTION
1263: WHEN EC_UTILS.PROGRAM_EXIT then
1264: raise;

Line 1266: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.UPDATE_DOCUMENT_STATUS');

1262: EXCEPTION
1263: WHEN EC_UTILS.PROGRAM_EXIT then
1264: raise;
1265: WHEN OTHERS THEN
1266: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.UPDATE_DOCUMENT_STATUS');
1267: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1268: ec_utils.i_ret_code := 2;
1269: raise EC_UTILS.PROGRAM_EXIT;
1270: END update_document_status;

Line 1267: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

1263: WHEN EC_UTILS.PROGRAM_EXIT then
1264: raise;
1265: WHEN OTHERS THEN
1266: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.UPDATE_DOCUMENT_STATUS');
1267: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1268: ec_utils.i_ret_code := 2;
1269: raise EC_UTILS.PROGRAM_EXIT;
1270: END update_document_status;
1271:

Line 1279: if ec_debug.G_debug_level >= 2 then

1275: i_map_id IN number
1276: )
1277: is
1278: begin
1279: if ec_debug.G_debug_level >= 2 then
1280: ec_debug.push('ECE_INBOUND.INITIALIZE_INBOUND');
1281: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1282: end if;
1283:

Line 1280: ec_debug.push('ECE_INBOUND.INITIALIZE_INBOUND');

1276: )
1277: is
1278: begin
1279: if ec_debug.G_debug_level >= 2 then
1280: ec_debug.push('ECE_INBOUND.INITIALIZE_INBOUND');
1281: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1282: end if;
1283:
1284: if g_count=0 then -- Bug 2422787

Line 1281: ec_debug.pl(3,'i_transaction_type',i_transaction_type);

1277: is
1278: begin
1279: if ec_debug.G_debug_level >= 2 then
1280: ec_debug.push('ECE_INBOUND.INITIALIZE_INBOUND');
1281: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1282: end if;
1283:
1284: if g_count=0 then -- Bug 2422787
1285:

Line 1426: if ec_debug.G_debug_level>= 2 then

1422:
1423: end if;
1424:
1425:
1426: if ec_debug.G_debug_level>= 2 then
1427: ec_debug.pop('ECE_INBOUND.INITIALIZE_INBOUND');
1428: end if;
1429: EXCEPTION
1430: WHEN OTHERS THEN

Line 1427: ec_debug.pop('ECE_INBOUND.INITIALIZE_INBOUND');

1423: end if;
1424:
1425:
1426: if ec_debug.G_debug_level>= 2 then
1427: ec_debug.pop('ECE_INBOUND.INITIALIZE_INBOUND');
1428: end if;
1429: EXCEPTION
1430: WHEN OTHERS THEN
1431: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.INITIALIZE_INBOUND');

Line 1431: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.INITIALIZE_INBOUND');

1427: ec_debug.pop('ECE_INBOUND.INITIALIZE_INBOUND');
1428: end if;
1429: EXCEPTION
1430: WHEN OTHERS THEN
1431: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.INITIALIZE_INBOUND');
1432: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1433: ec_utils.i_ret_code := 2;
1434: raise EC_UTILS.PROGRAM_EXIT;
1435: end initialize_inbound;

Line 1432: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

1428: end if;
1429: EXCEPTION
1430: WHEN OTHERS THEN
1431: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.INITIALIZE_INBOUND');
1432: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1433: ec_utils.i_ret_code := 2;
1434: raise EC_UTILS.PROGRAM_EXIT;
1435: end initialize_inbound;
1436:

Line 1440: if ec_debug.G_debug_level >= 2 then

1436:
1437: procedure close_inbound
1438: is
1439: begin
1440: if ec_debug.G_debug_level >= 2 then
1441: ec_debug.push('ECE_INBOUND.CLOSE_INBOUND');
1442: end if;
1443:
1444: g_count:=0; --Bug 2422787

Line 1441: ec_debug.push('ECE_INBOUND.CLOSE_INBOUND');

1437: procedure close_inbound
1438: is
1439: begin
1440: if ec_debug.G_debug_level >= 2 then
1441: ec_debug.push('ECE_INBOUND.CLOSE_INBOUND');
1442: end if;
1443:
1444: g_count:=0; --Bug 2422787
1445:

Line 1448: ec_debug.pl(0,'EC','ECE_TOTAL_SKIPPED','SKIPPED',ec_utils.g_documents_skipped);

1444: g_count:=0; --Bug 2422787
1445:
1446: if ec_utils.g_documents_skipped > 0
1447: then
1448: ec_debug.pl(0,'EC','ECE_TOTAL_SKIPPED','SKIPPED',ec_utils.g_documents_skipped);
1449: ec_utils.i_ret_code :=1;
1450: end if;
1451:
1452: if ec_utils.g_insert_failed > 0

Line 1454: ec_debug.pl(0,'EC','ECE_TOTAL_FAILED','FAILED',ec_utils.g_insert_failed);

1450: end if;
1451:
1452: if ec_utils.g_insert_failed > 0
1453: then
1454: ec_debug.pl(0,'EC','ECE_TOTAL_FAILED','FAILED',ec_utils.g_insert_failed);
1455: ec_utils.i_ret_code :=1;
1456: end if;
1457:
1458:

Line 1474: if ec_debug.G_debug_level >= 2 then

1470: dbms_sql.Close_cursor(ec_utils.g_ext_levels(i).Cursor_Handle);
1471: end if;
1472: end loop;
1473:
1474: if ec_debug.G_debug_level >= 2 then
1475: ec_debug.pop('ECE_INBOUND.CLOSE_INBOUND');
1476: end if;
1477: EXCEPTION
1478: WHEN OTHERS THEN

Line 1475: ec_debug.pop('ECE_INBOUND.CLOSE_INBOUND');

1471: end if;
1472: end loop;
1473:
1474: if ec_debug.G_debug_level >= 2 then
1475: ec_debug.pop('ECE_INBOUND.CLOSE_INBOUND');
1476: end if;
1477: EXCEPTION
1478: WHEN OTHERS THEN
1479: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.CLOSE_INBOUND');

Line 1479: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.CLOSE_INBOUND');

1475: ec_debug.pop('ECE_INBOUND.CLOSE_INBOUND');
1476: end if;
1477: EXCEPTION
1478: WHEN OTHERS THEN
1479: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.CLOSE_INBOUND');
1480: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1481: ec_utils.i_ret_code := 2;
1482: raise EC_UTILS.PROGRAM_EXIT;
1483: end close_inbound;

Line 1480: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

1476: end if;
1477: EXCEPTION
1478: WHEN OTHERS THEN
1479: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.CLOSE_INBOUND');
1480: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1481: ec_utils.i_ret_code := 2;
1482: raise EC_UTILS.PROGRAM_EXIT;
1483: end close_inbound;
1484:

Line 1491: if ec_debug.G_debug_level >= 2 then

1487: i_document_id IN number
1488: )
1489: is
1490: begin
1491: if ec_debug.G_debug_level >= 2 then
1492: ec_debug.push('ECE_INBOUND.INSERT_INTO_VIOLATIONS');
1493: ec_debug.pl(3,'i_document_id',i_document_id);
1494: end if;
1495: /**

Line 1492: ec_debug.push('ECE_INBOUND.INSERT_INTO_VIOLATIONS');

1488: )
1489: is
1490: begin
1491: if ec_debug.G_debug_level >= 2 then
1492: ec_debug.push('ECE_INBOUND.INSERT_INTO_VIOLATIONS');
1493: ec_debug.pl(3,'i_document_id',i_document_id);
1494: end if;
1495: /**
1496: Delete the Old violations for this Document

Line 1493: ec_debug.pl(3,'i_document_id',i_document_id);

1489: is
1490: begin
1491: if ec_debug.G_debug_level >= 2 then
1492: ec_debug.push('ECE_INBOUND.INSERT_INTO_VIOLATIONS');
1493: ec_debug.pl(3,'i_document_id',i_document_id);
1494: end if;
1495: /**
1496: Delete the Old violations for this Document
1497: **/

Line 1545: if ec_debug.G_debug_level >= 2 then

1541: end loop;
1542: /** Clean the PL/SQL table for next set of violations.
1543: **/
1544: ece_rules_pkg.g_rule_violation_tbl.DELETE;
1545: if ec_debug.G_debug_level >= 2 then
1546: ec_debug.pop('ECE_INBOUND.INSERT_INTO_VIOLATIONS');
1547: end if;
1548: EXCEPTION
1549: WHEN OTHERS THEN

Line 1546: ec_debug.pop('ECE_INBOUND.INSERT_INTO_VIOLATIONS');

1542: /** Clean the PL/SQL table for next set of violations.
1543: **/
1544: ece_rules_pkg.g_rule_violation_tbl.DELETE;
1545: if ec_debug.G_debug_level >= 2 then
1546: ec_debug.pop('ECE_INBOUND.INSERT_INTO_VIOLATIONS');
1547: end if;
1548: EXCEPTION
1549: WHEN OTHERS THEN
1550: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.INSERT_INTO_VIOLATIONS');

Line 1550: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.INSERT_INTO_VIOLATIONS');

1546: ec_debug.pop('ECE_INBOUND.INSERT_INTO_VIOLATIONS');
1547: end if;
1548: EXCEPTION
1549: WHEN OTHERS THEN
1550: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.INSERT_INTO_VIOLATIONS');
1551: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1552: ec_utils.i_ret_code := 2;
1553: raise EC_UTILS.PROGRAM_EXIT;
1554: end Insert_Into_Violations;

Line 1551: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

1547: end if;
1548: EXCEPTION
1549: WHEN OTHERS THEN
1550: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.INSERT_INTO_VIOLATIONS');
1551: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1552: ec_utils.i_ret_code := 2;
1553: raise EC_UTILS.PROGRAM_EXIT;
1554: end Insert_Into_Violations;
1555:

Line 1566: ec_debug.enable_debug(i_debug_mode);

1562: i_debug_mode in number
1563: )
1564: is
1565: begin
1566: ec_debug.enable_debug(i_debug_mode);
1567: if ec_debug.G_debug_level >= 2 then
1568: ec_debug.push('ECE_INBOUND.PROCESS_FOR_REQID');
1569: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1570: ec_debug.pl(3,'i_transaction_type',i_transaction_type);

Line 1567: if ec_debug.G_debug_level >= 2 then

1563: )
1564: is
1565: begin
1566: ec_debug.enable_debug(i_debug_mode);
1567: if ec_debug.G_debug_level >= 2 then
1568: ec_debug.push('ECE_INBOUND.PROCESS_FOR_REQID');
1569: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1570: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1571: ec_debug.pl(3,'i_reqid',i_reqid);

Line 1568: ec_debug.push('ECE_INBOUND.PROCESS_FOR_REQID');

1564: is
1565: begin
1566: ec_debug.enable_debug(i_debug_mode);
1567: if ec_debug.G_debug_level >= 2 then
1568: ec_debug.push('ECE_INBOUND.PROCESS_FOR_REQID');
1569: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1570: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1571: ec_debug.pl(3,'i_reqid',i_reqid);
1572: ec_debug.pl(3,'i_debug_mode',i_debug_mode);

Line 1569: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);

1565: begin
1566: ec_debug.enable_debug(i_debug_mode);
1567: if ec_debug.G_debug_level >= 2 then
1568: ec_debug.push('ECE_INBOUND.PROCESS_FOR_REQID');
1569: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1570: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1571: ec_debug.pl(3,'i_reqid',i_reqid);
1572: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
1573: end if;

Line 1570: ec_debug.pl(3,'i_transaction_type',i_transaction_type);

1566: ec_debug.enable_debug(i_debug_mode);
1567: if ec_debug.G_debug_level >= 2 then
1568: ec_debug.push('ECE_INBOUND.PROCESS_FOR_REQID');
1569: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1570: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1571: ec_debug.pl(3,'i_reqid',i_reqid);
1572: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
1573: end if;
1574: ece_inbound.process_inbound_documents

Line 1571: ec_debug.pl(3,'i_reqid',i_reqid);

1567: if ec_debug.G_debug_level >= 2 then
1568: ec_debug.push('ECE_INBOUND.PROCESS_FOR_REQID');
1569: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1570: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1571: ec_debug.pl(3,'i_reqid',i_reqid);
1572: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
1573: end if;
1574: ece_inbound.process_inbound_documents
1575: (

Line 1572: ec_debug.pl(3,'i_debug_mode',i_debug_mode);

1568: ec_debug.push('ECE_INBOUND.PROCESS_FOR_REQID');
1569: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1570: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1571: ec_debug.pl(3,'i_reqid',i_reqid);
1572: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
1573: end if;
1574: ece_inbound.process_inbound_documents
1575: (
1576: i_transaction_type => i_transaction_type,

Line 1581: if ec_debug.G_debug_level >= 2 then

1577: i_run_id => i_reqid
1578: );
1579: retcode := ec_utils.i_ret_code;
1580:
1581: if ec_debug.G_debug_level >= 2 then
1582: ec_debug.pl(3,'errbuf',errbuf);
1583: ec_debug.pl(3,'retcode',retcode);
1584: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1585: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_REQID');

Line 1582: ec_debug.pl(3,'errbuf',errbuf);

1578: );
1579: retcode := ec_utils.i_ret_code;
1580:
1581: if ec_debug.G_debug_level >= 2 then
1582: ec_debug.pl(3,'errbuf',errbuf);
1583: ec_debug.pl(3,'retcode',retcode);
1584: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1585: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_REQID');
1586: end if;

Line 1583: ec_debug.pl(3,'retcode',retcode);

1579: retcode := ec_utils.i_ret_code;
1580:
1581: if ec_debug.G_debug_level >= 2 then
1582: ec_debug.pl(3,'errbuf',errbuf);
1583: ec_debug.pl(3,'retcode',retcode);
1584: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1585: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_REQID');
1586: end if;
1587: ec_debug.disable_debug;

Line 1584: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);

1580:
1581: if ec_debug.G_debug_level >= 2 then
1582: ec_debug.pl(3,'errbuf',errbuf);
1583: ec_debug.pl(3,'retcode',retcode);
1584: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1585: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_REQID');
1586: end if;
1587: ec_debug.disable_debug;
1588: EXCEPTION

Line 1585: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_REQID');

1581: if ec_debug.G_debug_level >= 2 then
1582: ec_debug.pl(3,'errbuf',errbuf);
1583: ec_debug.pl(3,'retcode',retcode);
1584: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1585: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_REQID');
1586: end if;
1587: ec_debug.disable_debug;
1588: EXCEPTION
1589: WHEN EC_UTILS.PROGRAM_EXIT then

Line 1587: ec_debug.disable_debug;

1583: ec_debug.pl(3,'retcode',retcode);
1584: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1585: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_REQID');
1586: end if;
1587: ec_debug.disable_debug;
1588: EXCEPTION
1589: WHEN EC_UTILS.PROGRAM_EXIT then
1590: ece_flatfile_pvt.print_attributes;
1591: retcode := ec_utils.i_ret_code;

Line 1592: ec_debug.disable_debug;

1588: EXCEPTION
1589: WHEN EC_UTILS.PROGRAM_EXIT then
1590: ece_flatfile_pvt.print_attributes;
1591: retcode := ec_utils.i_ret_code;
1592: ec_debug.disable_debug;
1593: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_REQID');
1594: WHEN OTHERS THEN
1595: retcode :=2;
1596: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_REQID');

Line 1593: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_REQID');

1589: WHEN EC_UTILS.PROGRAM_EXIT then
1590: ece_flatfile_pvt.print_attributes;
1591: retcode := ec_utils.i_ret_code;
1592: ec_debug.disable_debug;
1593: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_REQID');
1594: WHEN OTHERS THEN
1595: retcode :=2;
1596: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_REQID');
1597: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 1596: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_REQID');

1592: ec_debug.disable_debug;
1593: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_REQID');
1594: WHEN OTHERS THEN
1595: retcode :=2;
1596: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_REQID');
1597: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1598: ece_flatfile_pvt.print_attributes;
1599: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_REQID');
1600: ec_debug.disable_debug;

Line 1597: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

1593: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_REQID');
1594: WHEN OTHERS THEN
1595: retcode :=2;
1596: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_REQID');
1597: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1598: ece_flatfile_pvt.print_attributes;
1599: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_REQID');
1600: ec_debug.disable_debug;
1601: end process_for_reqid;

Line 1599: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_REQID');

1595: retcode :=2;
1596: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_REQID');
1597: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1598: ece_flatfile_pvt.print_attributes;
1599: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_REQID');
1600: ec_debug.disable_debug;
1601: end process_for_reqid;
1602:
1603: procedure process_for_document_id

Line 1600: ec_debug.disable_debug;

1596: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_REQID');
1597: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1598: ece_flatfile_pvt.print_attributes;
1599: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_REQID');
1600: ec_debug.disable_debug;
1601: end process_for_reqid;
1602:
1603: procedure process_for_document_id
1604: (

Line 1613: ec_debug.enable_debug(i_debug_mode);

1609: i_debug_mode IN number
1610: )
1611: is
1612: begin
1613: ec_debug.enable_debug(i_debug_mode);
1614: if ec_debug.G_debug_level >= 2 then
1615: ec_debug.push('ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');
1616: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1617: ec_debug.pl(3,'i_transaction_type',i_transaction_type);

Line 1614: if ec_debug.G_debug_level >= 2 then

1610: )
1611: is
1612: begin
1613: ec_debug.enable_debug(i_debug_mode);
1614: if ec_debug.G_debug_level >= 2 then
1615: ec_debug.push('ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');
1616: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1617: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1618: ec_debug.pl(3,'i_document_id',i_document_id);

Line 1615: ec_debug.push('ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');

1611: is
1612: begin
1613: ec_debug.enable_debug(i_debug_mode);
1614: if ec_debug.G_debug_level >= 2 then
1615: ec_debug.push('ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');
1616: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1617: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1618: ec_debug.pl(3,'i_document_id',i_document_id);
1619: ec_debug.pl(3,'i_debug_mode',i_debug_mode);

Line 1616: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);

1612: begin
1613: ec_debug.enable_debug(i_debug_mode);
1614: if ec_debug.G_debug_level >= 2 then
1615: ec_debug.push('ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');
1616: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1617: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1618: ec_debug.pl(3,'i_document_id',i_document_id);
1619: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
1620: end if;

Line 1617: ec_debug.pl(3,'i_transaction_type',i_transaction_type);

1613: ec_debug.enable_debug(i_debug_mode);
1614: if ec_debug.G_debug_level >= 2 then
1615: ec_debug.push('ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');
1616: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1617: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1618: ec_debug.pl(3,'i_document_id',i_document_id);
1619: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
1620: end if;
1621: ece_inbound.process_inbound_documents

Line 1618: ec_debug.pl(3,'i_document_id',i_document_id);

1614: if ec_debug.G_debug_level >= 2 then
1615: ec_debug.push('ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');
1616: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1617: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1618: ec_debug.pl(3,'i_document_id',i_document_id);
1619: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
1620: end if;
1621: ece_inbound.process_inbound_documents
1622: (

Line 1619: ec_debug.pl(3,'i_debug_mode',i_debug_mode);

1615: ec_debug.push('ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');
1616: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1617: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1618: ec_debug.pl(3,'i_document_id',i_document_id);
1619: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
1620: end if;
1621: ece_inbound.process_inbound_documents
1622: (
1623: i_transaction_type => i_transaction_type,

Line 1627: if ec_debug.G_debug_level >= 2 then

1623: i_transaction_type => i_transaction_type,
1624: i_document_id => i_document_id
1625: );
1626: retcode := ec_utils.i_ret_code;
1627: if ec_debug.G_debug_level >= 2 then
1628: ec_debug.pl(3,'errbuf',errbuf);
1629: ec_debug.pl(3,'retcode',retcode);
1630: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1631: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');

Line 1628: ec_debug.pl(3,'errbuf',errbuf);

1624: i_document_id => i_document_id
1625: );
1626: retcode := ec_utils.i_ret_code;
1627: if ec_debug.G_debug_level >= 2 then
1628: ec_debug.pl(3,'errbuf',errbuf);
1629: ec_debug.pl(3,'retcode',retcode);
1630: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1631: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');
1632: end if;

Line 1629: ec_debug.pl(3,'retcode',retcode);

1625: );
1626: retcode := ec_utils.i_ret_code;
1627: if ec_debug.G_debug_level >= 2 then
1628: ec_debug.pl(3,'errbuf',errbuf);
1629: ec_debug.pl(3,'retcode',retcode);
1630: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1631: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');
1632: end if;
1633: ec_debug.disable_debug;

Line 1630: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);

1626: retcode := ec_utils.i_ret_code;
1627: if ec_debug.G_debug_level >= 2 then
1628: ec_debug.pl(3,'errbuf',errbuf);
1629: ec_debug.pl(3,'retcode',retcode);
1630: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1631: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');
1632: end if;
1633: ec_debug.disable_debug;
1634: EXCEPTION

Line 1631: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');

1627: if ec_debug.G_debug_level >= 2 then
1628: ec_debug.pl(3,'errbuf',errbuf);
1629: ec_debug.pl(3,'retcode',retcode);
1630: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1631: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');
1632: end if;
1633: ec_debug.disable_debug;
1634: EXCEPTION
1635: WHEN EC_UTILS.PROGRAM_EXIT then

Line 1633: ec_debug.disable_debug;

1629: ec_debug.pl(3,'retcode',retcode);
1630: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1631: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');
1632: end if;
1633: ec_debug.disable_debug;
1634: EXCEPTION
1635: WHEN EC_UTILS.PROGRAM_EXIT then
1636: retcode := ec_utils.i_ret_code;
1637: ece_flatfile_pvt.print_attributes;

Line 1638: ec_debug.disable_debug;

1634: EXCEPTION
1635: WHEN EC_UTILS.PROGRAM_EXIT then
1636: retcode := ec_utils.i_ret_code;
1637: ece_flatfile_pvt.print_attributes;
1638: ec_debug.disable_debug;
1639: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');
1640: WHEN OTHERS THEN
1641: retcode :=2;
1642: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');

Line 1639: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');

1635: WHEN EC_UTILS.PROGRAM_EXIT then
1636: retcode := ec_utils.i_ret_code;
1637: ece_flatfile_pvt.print_attributes;
1638: ec_debug.disable_debug;
1639: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');
1640: WHEN OTHERS THEN
1641: retcode :=2;
1642: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');
1643: ec_debug.pl(1,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 1642: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');

1638: ec_debug.disable_debug;
1639: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');
1640: WHEN OTHERS THEN
1641: retcode :=2;
1642: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');
1643: ec_debug.pl(1,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1644: ece_flatfile_pvt.print_attributes;
1645: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');
1646: ec_debug.disable_debug;

Line 1643: ec_debug.pl(1,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

1639: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');
1640: WHEN OTHERS THEN
1641: retcode :=2;
1642: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');
1643: ec_debug.pl(1,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1644: ece_flatfile_pvt.print_attributes;
1645: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');
1646: ec_debug.disable_debug;
1647: end process_for_document_id;

Line 1645: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');

1641: retcode :=2;
1642: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');
1643: ec_debug.pl(1,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1644: ece_flatfile_pvt.print_attributes;
1645: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');
1646: ec_debug.disable_debug;
1647: end process_for_document_id;
1648:
1649: procedure process_for_status

Line 1646: ec_debug.disable_debug;

1642: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');
1643: ec_debug.pl(1,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1644: ece_flatfile_pvt.print_attributes;
1645: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');
1646: ec_debug.disable_debug;
1647: end process_for_document_id;
1648:
1649: procedure process_for_status
1650: (

Line 1659: ec_debug.enable_debug(i_debug_mode);

1655: i_debug_mode in number
1656: )
1657: is
1658: begin
1659: ec_debug.enable_debug(i_debug_mode);
1660: if ec_debug.G_debug_level >= 2 then
1661: ec_debug.push('ECE_INBOUND.PROCESS_FOR_STATUS');
1662: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1663: ec_debug.pl(3,'i_transaction_type',i_transaction_type);

Line 1660: if ec_debug.G_debug_level >= 2 then

1656: )
1657: is
1658: begin
1659: ec_debug.enable_debug(i_debug_mode);
1660: if ec_debug.G_debug_level >= 2 then
1661: ec_debug.push('ECE_INBOUND.PROCESS_FOR_STATUS');
1662: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1663: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1664: ec_debug.pl(3,'i_status',i_status);

Line 1661: ec_debug.push('ECE_INBOUND.PROCESS_FOR_STATUS');

1657: is
1658: begin
1659: ec_debug.enable_debug(i_debug_mode);
1660: if ec_debug.G_debug_level >= 2 then
1661: ec_debug.push('ECE_INBOUND.PROCESS_FOR_STATUS');
1662: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1663: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1664: ec_debug.pl(3,'i_status',i_status);
1665: ec_debug.pl(3,'i_debug_mode',i_debug_mode);

Line 1662: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);

1658: begin
1659: ec_debug.enable_debug(i_debug_mode);
1660: if ec_debug.G_debug_level >= 2 then
1661: ec_debug.push('ECE_INBOUND.PROCESS_FOR_STATUS');
1662: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1663: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1664: ec_debug.pl(3,'i_status',i_status);
1665: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
1666: end if;

Line 1663: ec_debug.pl(3,'i_transaction_type',i_transaction_type);

1659: ec_debug.enable_debug(i_debug_mode);
1660: if ec_debug.G_debug_level >= 2 then
1661: ec_debug.push('ECE_INBOUND.PROCESS_FOR_STATUS');
1662: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1663: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1664: ec_debug.pl(3,'i_status',i_status);
1665: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
1666: end if;
1667:

Line 1664: ec_debug.pl(3,'i_status',i_status);

1660: if ec_debug.G_debug_level >= 2 then
1661: ec_debug.push('ECE_INBOUND.PROCESS_FOR_STATUS');
1662: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1663: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1664: ec_debug.pl(3,'i_status',i_status);
1665: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
1666: end if;
1667:
1668: ece_inbound.process_inbound_documents

Line 1665: ec_debug.pl(3,'i_debug_mode',i_debug_mode);

1661: ec_debug.push('ECE_INBOUND.PROCESS_FOR_STATUS');
1662: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1663: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1664: ec_debug.pl(3,'i_status',i_status);
1665: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
1666: end if;
1667:
1668: ece_inbound.process_inbound_documents
1669: (

Line 1674: if ec_debug.G_debug_level >= 2 then

1670: i_transaction_type => i_transaction_type,
1671: i_status => i_status
1672: );
1673: retcode := ec_utils.i_ret_code;
1674: if ec_debug.G_debug_level >= 2 then
1675: ec_debug.pl(3,'errbuf',errbuf);
1676: ec_debug.pl(3,'retcode',retcode);
1677: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1678: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_STATUS');

Line 1675: ec_debug.pl(3,'errbuf',errbuf);

1671: i_status => i_status
1672: );
1673: retcode := ec_utils.i_ret_code;
1674: if ec_debug.G_debug_level >= 2 then
1675: ec_debug.pl(3,'errbuf',errbuf);
1676: ec_debug.pl(3,'retcode',retcode);
1677: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1678: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_STATUS');
1679: end if;

Line 1676: ec_debug.pl(3,'retcode',retcode);

1672: );
1673: retcode := ec_utils.i_ret_code;
1674: if ec_debug.G_debug_level >= 2 then
1675: ec_debug.pl(3,'errbuf',errbuf);
1676: ec_debug.pl(3,'retcode',retcode);
1677: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1678: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_STATUS');
1679: end if;
1680: ec_debug.disable_debug;

Line 1677: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);

1673: retcode := ec_utils.i_ret_code;
1674: if ec_debug.G_debug_level >= 2 then
1675: ec_debug.pl(3,'errbuf',errbuf);
1676: ec_debug.pl(3,'retcode',retcode);
1677: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1678: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_STATUS');
1679: end if;
1680: ec_debug.disable_debug;
1681: EXCEPTION

Line 1678: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_STATUS');

1674: if ec_debug.G_debug_level >= 2 then
1675: ec_debug.pl(3,'errbuf',errbuf);
1676: ec_debug.pl(3,'retcode',retcode);
1677: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1678: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_STATUS');
1679: end if;
1680: ec_debug.disable_debug;
1681: EXCEPTION
1682: WHEN EC_UTILS.PROGRAM_EXIT then

Line 1680: ec_debug.disable_debug;

1676: ec_debug.pl(3,'retcode',retcode);
1677: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1678: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_STATUS');
1679: end if;
1680: ec_debug.disable_debug;
1681: EXCEPTION
1682: WHEN EC_UTILS.PROGRAM_EXIT then
1683: retcode := ec_utils.i_ret_code;
1684: ece_flatfile_pvt.print_attributes;

Line 1685: ec_debug.disable_debug;

1681: EXCEPTION
1682: WHEN EC_UTILS.PROGRAM_EXIT then
1683: retcode := ec_utils.i_ret_code;
1684: ece_flatfile_pvt.print_attributes;
1685: ec_debug.disable_debug;
1686: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_STATUS');
1687: WHEN OTHERS THEN
1688: retcode :=2;
1689: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_STATUS');

Line 1686: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_STATUS');

1682: WHEN EC_UTILS.PROGRAM_EXIT then
1683: retcode := ec_utils.i_ret_code;
1684: ece_flatfile_pvt.print_attributes;
1685: ec_debug.disable_debug;
1686: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_STATUS');
1687: WHEN OTHERS THEN
1688: retcode :=2;
1689: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_STATUS');
1690: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 1689: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_STATUS');

1685: ec_debug.disable_debug;
1686: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_STATUS');
1687: WHEN OTHERS THEN
1688: retcode :=2;
1689: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_STATUS');
1690: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1691: ece_flatfile_pvt.print_attributes;
1692: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_STATUS');
1693: ec_debug.disable_debug;

Line 1690: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

1686: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_STATUS');
1687: WHEN OTHERS THEN
1688: retcode :=2;
1689: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_STATUS');
1690: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1691: ece_flatfile_pvt.print_attributes;
1692: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_STATUS');
1693: ec_debug.disable_debug;
1694: end process_for_status;

Line 1692: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_STATUS');

1688: retcode :=2;
1689: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_STATUS');
1690: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1691: ece_flatfile_pvt.print_attributes;
1692: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_STATUS');
1693: ec_debug.disable_debug;
1694: end process_for_status;
1695:
1696: procedure process_for_transaction

Line 1693: ec_debug.disable_debug;

1689: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_STATUS');
1690: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1691: ece_flatfile_pvt.print_attributes;
1692: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_STATUS');
1693: ec_debug.disable_debug;
1694: end process_for_status;
1695:
1696: procedure process_for_transaction
1697: (

Line 1705: ec_debug.enable_debug(i_debug_mode);

1701: i_debug_mode in number
1702: )
1703: is
1704: begin
1705: ec_debug.enable_debug(i_debug_mode);
1706: if ec_debug.G_debug_level >= 2 then
1707: ec_debug.push('ECE_INBOUND.PROCESS_FOR_TRANSACTION');
1708: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1709: ec_debug.pl(3,'i_transaction_type',i_transaction_type);

Line 1706: if ec_debug.G_debug_level >= 2 then

1702: )
1703: is
1704: begin
1705: ec_debug.enable_debug(i_debug_mode);
1706: if ec_debug.G_debug_level >= 2 then
1707: ec_debug.push('ECE_INBOUND.PROCESS_FOR_TRANSACTION');
1708: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1709: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1710: ec_debug.pl(3,'i_debug_mode',i_debug_mode);

Line 1707: ec_debug.push('ECE_INBOUND.PROCESS_FOR_TRANSACTION');

1703: is
1704: begin
1705: ec_debug.enable_debug(i_debug_mode);
1706: if ec_debug.G_debug_level >= 2 then
1707: ec_debug.push('ECE_INBOUND.PROCESS_FOR_TRANSACTION');
1708: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1709: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1710: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
1711: end if;

Line 1708: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);

1704: begin
1705: ec_debug.enable_debug(i_debug_mode);
1706: if ec_debug.G_debug_level >= 2 then
1707: ec_debug.push('ECE_INBOUND.PROCESS_FOR_TRANSACTION');
1708: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1709: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1710: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
1711: end if;
1712: ece_inbound.process_inbound_documents

Line 1709: ec_debug.pl(3,'i_transaction_type',i_transaction_type);

1705: ec_debug.enable_debug(i_debug_mode);
1706: if ec_debug.G_debug_level >= 2 then
1707: ec_debug.push('ECE_INBOUND.PROCESS_FOR_TRANSACTION');
1708: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1709: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1710: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
1711: end if;
1712: ece_inbound.process_inbound_documents
1713: (

Line 1710: ec_debug.pl(3,'i_debug_mode',i_debug_mode);

1706: if ec_debug.G_debug_level >= 2 then
1707: ec_debug.push('ECE_INBOUND.PROCESS_FOR_TRANSACTION');
1708: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1709: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1710: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
1711: end if;
1712: ece_inbound.process_inbound_documents
1713: (
1714: i_transaction_type => i_transaction_type

Line 1718: if ec_debug.G_debug_level >= 2 then

1714: i_transaction_type => i_transaction_type
1715: );
1716: retcode := ec_utils.i_ret_code;
1717:
1718: if ec_debug.G_debug_level >= 2 then
1719: ec_debug.pl(3,'errbuf',errbuf);
1720: ec_debug.pl(3,'retcode',retcode);
1721: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1722: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TRANSACTION');

Line 1719: ec_debug.pl(3,'errbuf',errbuf);

1715: );
1716: retcode := ec_utils.i_ret_code;
1717:
1718: if ec_debug.G_debug_level >= 2 then
1719: ec_debug.pl(3,'errbuf',errbuf);
1720: ec_debug.pl(3,'retcode',retcode);
1721: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1722: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TRANSACTION');
1723: end if;

Line 1720: ec_debug.pl(3,'retcode',retcode);

1716: retcode := ec_utils.i_ret_code;
1717:
1718: if ec_debug.G_debug_level >= 2 then
1719: ec_debug.pl(3,'errbuf',errbuf);
1720: ec_debug.pl(3,'retcode',retcode);
1721: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1722: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TRANSACTION');
1723: end if;
1724: ec_debug.disable_debug;

Line 1721: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);

1717:
1718: if ec_debug.G_debug_level >= 2 then
1719: ec_debug.pl(3,'errbuf',errbuf);
1720: ec_debug.pl(3,'retcode',retcode);
1721: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1722: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TRANSACTION');
1723: end if;
1724: ec_debug.disable_debug;
1725: EXCEPTION

Line 1722: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TRANSACTION');

1718: if ec_debug.G_debug_level >= 2 then
1719: ec_debug.pl(3,'errbuf',errbuf);
1720: ec_debug.pl(3,'retcode',retcode);
1721: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1722: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TRANSACTION');
1723: end if;
1724: ec_debug.disable_debug;
1725: EXCEPTION
1726: WHEN EC_UTILS.PROGRAM_EXIT then

Line 1724: ec_debug.disable_debug;

1720: ec_debug.pl(3,'retcode',retcode);
1721: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1722: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TRANSACTION');
1723: end if;
1724: ec_debug.disable_debug;
1725: EXCEPTION
1726: WHEN EC_UTILS.PROGRAM_EXIT then
1727: retcode := ec_utils.i_ret_code;
1728: ece_flatfile_pvt.print_attributes;

Line 1729: ec_debug.disable_debug;

1725: EXCEPTION
1726: WHEN EC_UTILS.PROGRAM_EXIT then
1727: retcode := ec_utils.i_ret_code;
1728: ece_flatfile_pvt.print_attributes;
1729: ec_debug.disable_debug;
1730: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TRANSACTION');
1731: WHEN OTHERS THEN
1732: retcode :=2;
1733: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_TRANSACTION');

Line 1730: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TRANSACTION');

1726: WHEN EC_UTILS.PROGRAM_EXIT then
1727: retcode := ec_utils.i_ret_code;
1728: ece_flatfile_pvt.print_attributes;
1729: ec_debug.disable_debug;
1730: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TRANSACTION');
1731: WHEN OTHERS THEN
1732: retcode :=2;
1733: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_TRANSACTION');
1734: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 1733: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_TRANSACTION');

1729: ec_debug.disable_debug;
1730: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TRANSACTION');
1731: WHEN OTHERS THEN
1732: retcode :=2;
1733: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_TRANSACTION');
1734: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1735: ece_flatfile_pvt.print_attributes;
1736: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TRANSACTION');
1737: ec_debug.disable_debug;

Line 1734: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

1730: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TRANSACTION');
1731: WHEN OTHERS THEN
1732: retcode :=2;
1733: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_TRANSACTION');
1734: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1735: ece_flatfile_pvt.print_attributes;
1736: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TRANSACTION');
1737: ec_debug.disable_debug;
1738: end process_for_transaction;

Line 1736: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TRANSACTION');

1732: retcode :=2;
1733: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_TRANSACTION');
1734: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1735: ece_flatfile_pvt.print_attributes;
1736: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TRANSACTION');
1737: ec_debug.disable_debug;
1738: end process_for_transaction;
1739:
1740: procedure process_for_tpstatus

Line 1737: ec_debug.disable_debug;

1733: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_TRANSACTION');
1734: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1735: ece_flatfile_pvt.print_attributes;
1736: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TRANSACTION');
1737: ec_debug.disable_debug;
1738: end process_for_transaction;
1739:
1740: procedure process_for_tpstatus
1741: (

Line 1751: ec_debug.enable_debug(i_debug_mode);

1747: i_debug_mode in number
1748: )
1749: is
1750: begin
1751: ec_debug.enable_debug(i_debug_mode);
1752: if ec_debug.G_debug_level >= 2 then
1753: ec_debug.push('ECE_INBOUND.PROCESS_FOR_TPSTATUS');
1754: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1755: ec_debug.pl(3,'i_transaction_type',i_transaction_type);

Line 1752: if ec_debug.G_debug_level >= 2 then

1748: )
1749: is
1750: begin
1751: ec_debug.enable_debug(i_debug_mode);
1752: if ec_debug.G_debug_level >= 2 then
1753: ec_debug.push('ECE_INBOUND.PROCESS_FOR_TPSTATUS');
1754: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1755: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1756: ec_debug.pl(3,'i_tp_code',i_tp_code);

Line 1753: ec_debug.push('ECE_INBOUND.PROCESS_FOR_TPSTATUS');

1749: is
1750: begin
1751: ec_debug.enable_debug(i_debug_mode);
1752: if ec_debug.G_debug_level >= 2 then
1753: ec_debug.push('ECE_INBOUND.PROCESS_FOR_TPSTATUS');
1754: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1755: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1756: ec_debug.pl(3,'i_tp_code',i_tp_code);
1757: ec_debug.pl(3,'i_status',i_status);

Line 1754: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);

1750: begin
1751: ec_debug.enable_debug(i_debug_mode);
1752: if ec_debug.G_debug_level >= 2 then
1753: ec_debug.push('ECE_INBOUND.PROCESS_FOR_TPSTATUS');
1754: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1755: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1756: ec_debug.pl(3,'i_tp_code',i_tp_code);
1757: ec_debug.pl(3,'i_status',i_status);
1758: ec_debug.pl(3,'i_debug_mode',i_debug_mode);

Line 1755: ec_debug.pl(3,'i_transaction_type',i_transaction_type);

1751: ec_debug.enable_debug(i_debug_mode);
1752: if ec_debug.G_debug_level >= 2 then
1753: ec_debug.push('ECE_INBOUND.PROCESS_FOR_TPSTATUS');
1754: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1755: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1756: ec_debug.pl(3,'i_tp_code',i_tp_code);
1757: ec_debug.pl(3,'i_status',i_status);
1758: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
1759: end if;

Line 1756: ec_debug.pl(3,'i_tp_code',i_tp_code);

1752: if ec_debug.G_debug_level >= 2 then
1753: ec_debug.push('ECE_INBOUND.PROCESS_FOR_TPSTATUS');
1754: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1755: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1756: ec_debug.pl(3,'i_tp_code',i_tp_code);
1757: ec_debug.pl(3,'i_status',i_status);
1758: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
1759: end if;
1760: ece_inbound.process_inbound_documents

Line 1757: ec_debug.pl(3,'i_status',i_status);

1753: ec_debug.push('ECE_INBOUND.PROCESS_FOR_TPSTATUS');
1754: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1755: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1756: ec_debug.pl(3,'i_tp_code',i_tp_code);
1757: ec_debug.pl(3,'i_status',i_status);
1758: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
1759: end if;
1760: ece_inbound.process_inbound_documents
1761: (

Line 1758: ec_debug.pl(3,'i_debug_mode',i_debug_mode);

1754: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1755: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1756: ec_debug.pl(3,'i_tp_code',i_tp_code);
1757: ec_debug.pl(3,'i_status',i_status);
1758: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
1759: end if;
1760: ece_inbound.process_inbound_documents
1761: (
1762: i_transaction_type => i_transaction_type,

Line 1768: if ec_debug.G_debug_level >=2 then

1764: i_status => i_status
1765: );
1766: retcode := ec_utils.i_ret_code;
1767:
1768: if ec_debug.G_debug_level >=2 then
1769: ec_debug.pl(3,'errbuf',errbuf);
1770: ec_debug.pl(3,'retcode',retcode);
1771: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1772: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TPSTATUS');

Line 1769: ec_debug.pl(3,'errbuf',errbuf);

1765: );
1766: retcode := ec_utils.i_ret_code;
1767:
1768: if ec_debug.G_debug_level >=2 then
1769: ec_debug.pl(3,'errbuf',errbuf);
1770: ec_debug.pl(3,'retcode',retcode);
1771: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1772: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TPSTATUS');
1773: end if;

Line 1770: ec_debug.pl(3,'retcode',retcode);

1766: retcode := ec_utils.i_ret_code;
1767:
1768: if ec_debug.G_debug_level >=2 then
1769: ec_debug.pl(3,'errbuf',errbuf);
1770: ec_debug.pl(3,'retcode',retcode);
1771: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1772: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TPSTATUS');
1773: end if;
1774: ec_debug.disable_debug;

Line 1771: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);

1767:
1768: if ec_debug.G_debug_level >=2 then
1769: ec_debug.pl(3,'errbuf',errbuf);
1770: ec_debug.pl(3,'retcode',retcode);
1771: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1772: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TPSTATUS');
1773: end if;
1774: ec_debug.disable_debug;
1775: EXCEPTION

Line 1772: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TPSTATUS');

1768: if ec_debug.G_debug_level >=2 then
1769: ec_debug.pl(3,'errbuf',errbuf);
1770: ec_debug.pl(3,'retcode',retcode);
1771: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1772: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TPSTATUS');
1773: end if;
1774: ec_debug.disable_debug;
1775: EXCEPTION
1776: WHEN EC_UTILS.PROGRAM_EXIT then

Line 1774: ec_debug.disable_debug;

1770: ec_debug.pl(3,'retcode',retcode);
1771: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1772: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TPSTATUS');
1773: end if;
1774: ec_debug.disable_debug;
1775: EXCEPTION
1776: WHEN EC_UTILS.PROGRAM_EXIT then
1777: retcode := ec_utils.i_ret_code;
1778: ece_flatfile_pvt.print_attributes;

Line 1779: ec_debug.disable_debug;

1775: EXCEPTION
1776: WHEN EC_UTILS.PROGRAM_EXIT then
1777: retcode := ec_utils.i_ret_code;
1778: ece_flatfile_pvt.print_attributes;
1779: ec_debug.disable_debug;
1780: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TPSTATUS');
1781: WHEN OTHERS THEN
1782: retcode :=2;
1783: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_TPSTATUS');

Line 1780: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TPSTATUS');

1776: WHEN EC_UTILS.PROGRAM_EXIT then
1777: retcode := ec_utils.i_ret_code;
1778: ece_flatfile_pvt.print_attributes;
1779: ec_debug.disable_debug;
1780: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TPSTATUS');
1781: WHEN OTHERS THEN
1782: retcode :=2;
1783: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_TPSTATUS');
1784: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 1783: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_TPSTATUS');

1779: ec_debug.disable_debug;
1780: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TPSTATUS');
1781: WHEN OTHERS THEN
1782: retcode :=2;
1783: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_TPSTATUS');
1784: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1785: ece_flatfile_pvt.print_attributes;
1786: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TPSTATUS');
1787: ec_debug.disable_debug;

Line 1784: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

1780: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TPSTATUS');
1781: WHEN OTHERS THEN
1782: retcode :=2;
1783: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_TPSTATUS');
1784: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1785: ece_flatfile_pvt.print_attributes;
1786: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TPSTATUS');
1787: ec_debug.disable_debug;
1788: end process_for_tpstatus;

Line 1786: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TPSTATUS');

1782: retcode :=2;
1783: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_TPSTATUS');
1784: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1785: ece_flatfile_pvt.print_attributes;
1786: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TPSTATUS');
1787: ec_debug.disable_debug;
1788: end process_for_tpstatus;
1789:
1790: procedure process_documents

Line 1787: ec_debug.disable_debug;

1783: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_TPSTATUS');
1784: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1785: ece_flatfile_pvt.print_attributes;
1786: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TPSTATUS');
1787: ec_debug.disable_debug;
1788: end process_for_tpstatus;
1789:
1790: procedure process_documents
1791: (

Line 1798: if ec_debug.G_debug_level >= 2 then

1794: i_select_cursor IN INTEGER
1795: )
1796: is
1797: BEGIN
1798: if ec_debug.G_debug_level >= 2 then
1799: ec_debug.push('ECE_INBOUND.PROCESS_DOCUMENTS');
1800: ec_debug.pl(3,'i_document_id',i_document_id);
1801: ec_debug.pl(3,'i_select_cursor',i_select_cursor);
1802: end if;

Line 1799: ec_debug.push('ECE_INBOUND.PROCESS_DOCUMENTS');

1795: )
1796: is
1797: BEGIN
1798: if ec_debug.G_debug_level >= 2 then
1799: ec_debug.push('ECE_INBOUND.PROCESS_DOCUMENTS');
1800: ec_debug.pl(3,'i_document_id',i_document_id);
1801: ec_debug.pl(3,'i_select_cursor',i_select_cursor);
1802: end if;
1803: /**

Line 1800: ec_debug.pl(3,'i_document_id',i_document_id);

1796: is
1797: BEGIN
1798: if ec_debug.G_debug_level >= 2 then
1799: ec_debug.push('ECE_INBOUND.PROCESS_DOCUMENTS');
1800: ec_debug.pl(3,'i_document_id',i_document_id);
1801: ec_debug.pl(3,'i_select_cursor',i_select_cursor);
1802: end if;
1803: /**
1804: Savepoint for the document. If any error encountered during processing of the

Line 1801: ec_debug.pl(3,'i_select_cursor',i_select_cursor);

1797: BEGIN
1798: if ec_debug.G_debug_level >= 2 then
1799: ec_debug.push('ECE_INBOUND.PROCESS_DOCUMENTS');
1800: ec_debug.pl(3,'i_document_id',i_document_id);
1801: ec_debug.pl(3,'i_select_cursor',i_select_cursor);
1802: end if;
1803: /**
1804: Savepoint for the document. If any error encountered during processing of the
1805: document , the whole document will be rolled back to this savepoint.

Line 1854: ec_debug.pl(1,'EC','ECE_DELETE_FAILED_STAGING','DOCUMENT_ID',i_document_id);

1850: where document_id = i_document_id;
1851:
1852: if sql%notfound
1853: then
1854: ec_debug.pl(1,'EC','ECE_DELETE_FAILED_STAGING','DOCUMENT_ID',i_document_id);
1855: ec_utils.i_ret_code :=1;
1856: rollback to Document_Start;
1857: end if;
1858: end if;

Line 1862: if ec_debug.G_debug_level >=2 then

1858: end if;
1859:
1860: /** Save the Violations. **/
1861: Insert_Into_Violations(i_Document_Id);
1862: if ec_debug.G_debug_level >=2 then
1863: ec_debug.pop('ECE_INBOUND.PROCESS_DOCUMENTS');
1864: end if;
1865: EXCEPTION
1866: WHEN EC_UTILS.DOCUMENTS_UNDER_PROCESS then

Line 1863: ec_debug.pop('ECE_INBOUND.PROCESS_DOCUMENTS');

1859:
1860: /** Save the Violations. **/
1861: Insert_Into_Violations(i_Document_Id);
1862: if ec_debug.G_debug_level >=2 then
1863: ec_debug.pop('ECE_INBOUND.PROCESS_DOCUMENTS');
1864: end if;
1865: EXCEPTION
1866: WHEN EC_UTILS.DOCUMENTS_UNDER_PROCESS then
1867: ec_debug.pl(0,'EC','ECE_DOCUMENTS_UNDER_PROCESS',null);

Line 1867: ec_debug.pl(0,'EC','ECE_DOCUMENTS_UNDER_PROCESS',null);

1863: ec_debug.pop('ECE_INBOUND.PROCESS_DOCUMENTS');
1864: end if;
1865: EXCEPTION
1866: WHEN EC_UTILS.DOCUMENTS_UNDER_PROCESS then
1867: ec_debug.pl(0,'EC','ECE_DOCUMENTS_UNDER_PROCESS',null);
1868: raise EC_UTILS.PROGRAM_EXIT;
1869: WHEN EC_UTILS.PROGRAM_EXIT then
1870: raise;
1871: WHEN OTHERS THEN

Line 1872: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_DOCUMENTS');

1868: raise EC_UTILS.PROGRAM_EXIT;
1869: WHEN EC_UTILS.PROGRAM_EXIT then
1870: raise;
1871: WHEN OTHERS THEN
1872: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_DOCUMENTS');
1873: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1874: ec_utils.i_ret_code :=2;
1875: raise EC_UTILS.PROGRAM_EXIT;
1876: end process_documents;

Line 1873: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

1869: WHEN EC_UTILS.PROGRAM_EXIT then
1870: raise;
1871: WHEN OTHERS THEN
1872: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_DOCUMENTS');
1873: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1874: ec_utils.i_ret_code :=2;
1875: raise EC_UTILS.PROGRAM_EXIT;
1876: end process_documents;
1877:

Line 1895: if ec_debug.G_debug_level >=2 then

1891: i_map_id ece_stage.map_id%TYPE;
1892: i_columns ece_stage.field1%TYPE;
1893:
1894: begin
1895: if ec_debug.G_debug_level >=2 then
1896: ec_debug.push('ECE_INBOUND.SELECT_STAGE');
1897: end if;
1898:
1899: i_Select_Stmt := 'select Stage_Id ,Document_Number ,transaction_level ,line_number ,Status , map_id, ';

Line 1896: ec_debug.push('ECE_INBOUND.SELECT_STAGE');

1892: i_columns ece_stage.field1%TYPE;
1893:
1894: begin
1895: if ec_debug.G_debug_level >=2 then
1896: ec_debug.push('ECE_INBOUND.SELECT_STAGE');
1897: end if;
1898:
1899: i_Select_Stmt := 'select Stage_Id ,Document_Number ,transaction_level ,line_number ,Status , map_id, ';
1900:

Line 1924: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.SELECT_STAGE');

1920: dbms_sql.parse(i_Cursor_handle,i_Select_Stmt,dbms_sql.native);
1921: EXCEPTION
1922: WHEN OTHERS THEN
1923: error_position := dbms_sql.last_error_position;
1924: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.SELECT_STAGE');
1925: ece_error_handling_pvt.print_parse_error (error_position,i_Select_Stmt);
1926: ec_utils.i_ret_code :=2;
1927: raise EC_UTILS.PROGRAM_EXIT;
1928: END;

Line 1944: ec_debug.pl(3,'Select Statement',i_select_stmt);

1940: loop
1941: dbms_sql.define_column(i_Cursor_Handle,i,i_columns,500);
1942: end loop;
1943:
1944: ec_debug.pl(3,'Select Statement',i_select_stmt);
1945:
1946: i_Select_Cursor := i_Cursor_Handle;
1947: if ec_debug.G_debug_level >=2 then
1948: ec_debug.pl(3,'i_select_cursor',i_select_cursor);

Line 1947: if ec_debug.G_debug_level >=2 then

1943:
1944: ec_debug.pl(3,'Select Statement',i_select_stmt);
1945:
1946: i_Select_Cursor := i_Cursor_Handle;
1947: if ec_debug.G_debug_level >=2 then
1948: ec_debug.pl(3,'i_select_cursor',i_select_cursor);
1949: ec_debug.pop('ECE_INBOUND.SELECT_STAGE');
1950: end if;
1951: EXCEPTION

Line 1948: ec_debug.pl(3,'i_select_cursor',i_select_cursor);

1944: ec_debug.pl(3,'Select Statement',i_select_stmt);
1945:
1946: i_Select_Cursor := i_Cursor_Handle;
1947: if ec_debug.G_debug_level >=2 then
1948: ec_debug.pl(3,'i_select_cursor',i_select_cursor);
1949: ec_debug.pop('ECE_INBOUND.SELECT_STAGE');
1950: end if;
1951: EXCEPTION
1952: WHEN EC_UTILS.PROGRAM_EXIT then

Line 1949: ec_debug.pop('ECE_INBOUND.SELECT_STAGE');

1945:
1946: i_Select_Cursor := i_Cursor_Handle;
1947: if ec_debug.G_debug_level >=2 then
1948: ec_debug.pl(3,'i_select_cursor',i_select_cursor);
1949: ec_debug.pop('ECE_INBOUND.SELECT_STAGE');
1950: end if;
1951: EXCEPTION
1952: WHEN EC_UTILS.PROGRAM_EXIT then
1953: raise;

Line 1955: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.SELECT_STAGE');

1951: EXCEPTION
1952: WHEN EC_UTILS.PROGRAM_EXIT then
1953: raise;
1954: WHEN OTHERS then
1955: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.SELECT_STAGE');
1956: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1957: ec_utils.i_ret_code :=2;
1958: raise EC_UTILS.PROGRAM_EXIT;
1959: end select_stage;

Line 1956: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

1952: WHEN EC_UTILS.PROGRAM_EXIT then
1953: raise;
1954: WHEN OTHERS then
1955: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.SELECT_STAGE');
1956: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1957: ec_utils.i_ret_code :=2;
1958: raise EC_UTILS.PROGRAM_EXIT;
1959: end select_stage;
1960:

Line 1982: if ec_debug.G_debug_level >=2 then

1978: i_success BOOLEAN := TRUE;
1979: error_position pls_integer;
1980:
1981: BEGIN
1982: if ec_debug.G_debug_level >=2 then
1983: ec_debug.push('ECE_INBOUND.INSERT_INTO_PROD_INTERFACE');
1984: ec_debug.pl(3,'i_Insert_Cursor',i_Insert_Cursor);
1985: ec_debug.pl(3,'i_level',i_level);
1986: end if;

Line 1983: ec_debug.push('ECE_INBOUND.INSERT_INTO_PROD_INTERFACE');

1979: error_position pls_integer;
1980:
1981: BEGIN
1982: if ec_debug.G_debug_level >=2 then
1983: ec_debug.push('ECE_INBOUND.INSERT_INTO_PROD_INTERFACE');
1984: ec_debug.pl(3,'i_Insert_Cursor',i_Insert_Cursor);
1985: ec_debug.pl(3,'i_level',i_level);
1986: end if;
1987:

Line 1984: ec_debug.pl(3,'i_Insert_Cursor',i_Insert_Cursor);

1980:
1981: BEGIN
1982: if ec_debug.G_debug_level >=2 then
1983: ec_debug.push('ECE_INBOUND.INSERT_INTO_PROD_INTERFACE');
1984: ec_debug.pl(3,'i_Insert_Cursor',i_Insert_Cursor);
1985: ec_debug.pl(3,'i_level',i_level);
1986: end if;
1987:
1988: if i_Insert_Cursor = 0

Line 1985: ec_debug.pl(3,'i_level',i_level);

1981: BEGIN
1982: if ec_debug.G_debug_level >=2 then
1983: ec_debug.push('ECE_INBOUND.INSERT_INTO_PROD_INTERFACE');
1984: ec_debug.pl(3,'i_Insert_Cursor',i_Insert_Cursor);
1985: ec_debug.pl(3,'i_level',i_level);
1986: end if;
1987:
1988: if i_Insert_Cursor = 0
1989: then

Line 1991: ec_debug.pl(3,'i_Insert_Cursor',i_Insert_Cursor);

1987:
1988: if i_Insert_Cursor = 0
1989: then
1990: i_Insert_Cursor := -911;
1991: ec_debug.pl(3,'i_Insert_Cursor',i_Insert_Cursor);
1992: end if;
1993:
1994: if i_Insert_Cursor < 0
1995: then

Line 2011: if ec_debug.G_debug_level = 3 then

2007: cInsert_stmt := RTRIM (cInsert_stmt, ',') || ') ';
2008: cValue_stmt := RTRIM (cValue_stmt, ',') || ')';
2009: cInsert_stmt := cInsert_stmt || cValue_stmt;
2010:
2011: if ec_debug.G_debug_level = 3 then
2012: ec_debug.pl(3,'Insert_Statement',cInsert_stmt);
2013: end if;
2014:
2015: i_Insert_Cursor := dbms_sql.open_cursor;

Line 2012: ec_debug.pl(3,'Insert_Statement',cInsert_stmt);

2008: cValue_stmt := RTRIM (cValue_stmt, ',') || ')';
2009: cInsert_stmt := cInsert_stmt || cValue_stmt;
2010:
2011: if ec_debug.G_debug_level = 3 then
2012: ec_debug.pl(3,'Insert_Statement',cInsert_stmt);
2013: end if;
2014:
2015: i_Insert_Cursor := dbms_sql.open_cursor;
2016:

Line 2022: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',

2018: dbms_sql.parse(i_Insert_Cursor, cInsert_stmt, dbms_sql.native);
2019: exception
2020: when others then
2021: error_position := dbms_sql.last_error_position;
2022: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',
2023: 'ECE_INBOUND.INSERT_INTO_PROD_INTERFACE');
2024: ece_error_handling_pvt.print_parse_error (error_position,cInsert_stmt);
2025: ec_utils.i_ret_code :=2;
2026: ec_debug.pop('ECE_INBOUND.INSERT_INTO_PROD_INTERFACE');

Line 2026: ec_debug.pop('ECE_INBOUND.INSERT_INTO_PROD_INTERFACE');

2022: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',
2023: 'ECE_INBOUND.INSERT_INTO_PROD_INTERFACE');
2024: ece_error_handling_pvt.print_parse_error (error_position,cInsert_stmt);
2025: ec_utils.i_ret_code :=2;
2026: ec_debug.pop('ECE_INBOUND.INSERT_INTO_PROD_INTERFACE');
2027: raise EC_UTILS.PROGRAM_EXIT;
2028: end;
2029: end if;
2030:

Line 2050: if ec_debug.G_debug_level = 3 then

2046: d_date := to_date(ec_utils.g_file_tbl(k).value,'YYYYMMDD HH24MISS');
2047: else
2048: d_date := NULL;
2049: end if;
2050: if ec_debug.G_debug_level = 3 then
2051: ec_debug.pl(3,ec_utils.g_file_tbl(k).Base_Column_Name,d_date);
2052: end if;
2053: dbms_sql.bind_variable(i_Insert_Cursor, 'b'||k, d_date);
2054:

Line 2051: ec_debug.pl(3,ec_utils.g_file_tbl(k).Base_Column_Name,d_date);

2047: else
2048: d_date := NULL;
2049: end if;
2050: if ec_debug.G_debug_level = 3 then
2051: ec_debug.pl(3,ec_utils.g_file_tbl(k).Base_Column_Name,d_date);
2052: end if;
2053: dbms_sql.bind_variable(i_Insert_Cursor, 'b'||k, d_date);
2054:
2055: elsif 'NUMBER' = ec_utils.g_file_tbl(k).data_type

Line 2063: if ec_debug.G_debug_level = 3 then

2059: n_number := to_number(ec_utils.g_file_tbl(k).value);
2060: else
2061: n_number := NULL;
2062: end if;
2063: if ec_debug.G_debug_level = 3 then
2064: ec_debug.pl(3,ec_utils.g_file_tbl(k).Base_Column_Name,n_number);
2065: end if;
2066: dbms_sql.bind_variable(i_Insert_Cursor, 'b'||k, n_number);
2067:

Line 2064: ec_debug.pl(3,ec_utils.g_file_tbl(k).Base_Column_Name,n_number);

2060: else
2061: n_number := NULL;
2062: end if;
2063: if ec_debug.G_debug_level = 3 then
2064: ec_debug.pl(3,ec_utils.g_file_tbl(k).Base_Column_Name,n_number);
2065: end if;
2066: dbms_sql.bind_variable(i_Insert_Cursor, 'b'||k, n_number);
2067:
2068: else

Line 2069: if ec_debug.G_debug_level = 3 then

2065: end if;
2066: dbms_sql.bind_variable(i_Insert_Cursor, 'b'||k, n_number);
2067:
2068: else
2069: if ec_debug.G_debug_level = 3 then
2070: ec_debug.pl(3,ec_utils.g_file_tbl(k).Base_Column_Name,ec_utils.g_file_tbl(k).value);
2071: end if;
2072: dbms_sql.bind_variable(i_Insert_Cursor, 'b'||k,ec_utils.g_file_tbl(k).value);
2073: end if; -- End If for Data Type

Line 2070: ec_debug.pl(3,ec_utils.g_file_tbl(k).Base_Column_Name,ec_utils.g_file_tbl(k).value);

2066: dbms_sql.bind_variable(i_Insert_Cursor, 'b'||k, n_number);
2067:
2068: else
2069: if ec_debug.G_debug_level = 3 then
2070: ec_debug.pl(3,ec_utils.g_file_tbl(k).Base_Column_Name,ec_utils.g_file_tbl(k).value);
2071: end if;
2072: dbms_sql.bind_variable(i_Insert_Cursor, 'b'||k,ec_utils.g_file_tbl(k).value);
2073: end if; -- End If for Data Type
2074:

Line 2077: ec_debug.pl(0,'EC','ECE_DATATYPE_CONVERSION_FAILED',

2073: end if; -- End If for Data Type
2074:
2075: EXCEPTION
2076: WHEN OTHERS then
2077: ec_debug.pl(0,'EC','ECE_DATATYPE_CONVERSION_FAILED',
2078: 'DATATYPE',ec_utils.g_file_tbl(k).data_type);
2079: ec_debug.pl(0,ec_utils.g_file_tbl(k).Base_Column_Name,ec_utils.g_file_tbl(k).value);
2080: raise;
2081: END; --- Data Type Conversion Trap.

Line 2079: ec_debug.pl(0,ec_utils.g_file_tbl(k).Base_Column_Name,ec_utils.g_file_tbl(k).value);

2075: EXCEPTION
2076: WHEN OTHERS then
2077: ec_debug.pl(0,'EC','ECE_DATATYPE_CONVERSION_FAILED',
2078: 'DATATYPE',ec_utils.g_file_tbl(k).data_type);
2079: ec_debug.pl(0,ec_utils.g_file_tbl(k).Base_Column_Name,ec_utils.g_file_tbl(k).value);
2080: raise;
2081: END; --- Data Type Conversion Trap.
2082:
2083: end if; -- End if for i_level and Base Table Name

Line 2092: if ec_debug.G_debug_level >= 2 then

2088: end;
2089:
2090: end if;
2091:
2092: if ec_debug.G_debug_level >= 2 then
2093: ec_debug.pl(3,'i_success',i_success);
2094: ec_debug.pop('ECE_INBOUND.INSERT_INTO_PROD_INTERFACE');
2095: end if;
2096: return i_success;

Line 2093: ec_debug.pl(3,'i_success',i_success);

2089:
2090: end if;
2091:
2092: if ec_debug.G_debug_level >= 2 then
2093: ec_debug.pl(3,'i_success',i_success);
2094: ec_debug.pop('ECE_INBOUND.INSERT_INTO_PROD_INTERFACE');
2095: end if;
2096: return i_success;
2097: EXCEPTION

Line 2094: ec_debug.pop('ECE_INBOUND.INSERT_INTO_PROD_INTERFACE');

2090: end if;
2091:
2092: if ec_debug.G_debug_level >= 2 then
2093: ec_debug.pl(3,'i_success',i_success);
2094: ec_debug.pop('ECE_INBOUND.INSERT_INTO_PROD_INTERFACE');
2095: end if;
2096: return i_success;
2097: EXCEPTION
2098: WHEN EC_UTILS.PROGRAM_EXIT then

Line 2101: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',

2097: EXCEPTION
2098: WHEN EC_UTILS.PROGRAM_EXIT then
2099: raise;
2100: WHEN OTHERS THEN
2101: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',
2102: 'ECE_INBOUND.INSERT_INTO_PROD_INTERFACE');
2103: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
2104: i_success := FALSE;
2105: ec_utils.i_ret_code :=1;

Line 2103: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

2099: raise;
2100: WHEN OTHERS THEN
2101: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',
2102: 'ECE_INBOUND.INSERT_INTO_PROD_INTERFACE');
2103: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
2104: i_success := FALSE;
2105: ec_utils.i_ret_code :=1;
2106: ec_debug.pl(0,'EC','ECE_INSERT_FAILED',null);
2107: ec_debug.pl(3,'i_success',i_success);

Line 2106: ec_debug.pl(0,'EC','ECE_INSERT_FAILED',null);

2102: 'ECE_INBOUND.INSERT_INTO_PROD_INTERFACE');
2103: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
2104: i_success := FALSE;
2105: ec_utils.i_ret_code :=1;
2106: ec_debug.pl(0,'EC','ECE_INSERT_FAILED',null);
2107: ec_debug.pl(3,'i_success',i_success);
2108: ec_debug.pop('ECE_INBOUND.INSERT_INTO_PROD_INTERFACE');
2109: return i_success;
2110: END insert_into_prod_interface;

Line 2107: ec_debug.pl(3,'i_success',i_success);

2103: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
2104: i_success := FALSE;
2105: ec_utils.i_ret_code :=1;
2106: ec_debug.pl(0,'EC','ECE_INSERT_FAILED',null);
2107: ec_debug.pl(3,'i_success',i_success);
2108: ec_debug.pop('ECE_INBOUND.INSERT_INTO_PROD_INTERFACE');
2109: return i_success;
2110: END insert_into_prod_interface;
2111:

Line 2108: ec_debug.pop('ECE_INBOUND.INSERT_INTO_PROD_INTERFACE');

2104: i_success := FALSE;
2105: ec_utils.i_ret_code :=1;
2106: ec_debug.pl(0,'EC','ECE_INSERT_FAILED',null);
2107: ec_debug.pl(3,'i_success',i_success);
2108: ec_debug.pop('ECE_INBOUND.INSERT_INTO_PROD_INTERFACE');
2109: return i_success;
2110: END insert_into_prod_interface;
2111:
2112: