eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ECE_ADVO_ADVICE_PKG dependencies on EC_DEBUG

Line 51: ec_debug.enable_debug ( v_debug_mode );

47: ORDER BY line_id;
48:
49: BEGIN
50:
51: ec_debug.enable_debug ( v_debug_mode );
52: ec_debug.push ( 'ECE_ADVO_ADVICE_PKG.Extract_ADVO_Outbound' );
53: ec_debug.pl ( 3, 'cOutput_Path: ',cOutput_Path );
54: ec_debug.pl ( 3, 'cOutput_Filename: ',cOutput_Filename );
55: ec_debug.pl ( 3, 'p_TP_Group: ',p_TP_Group );

Line 52: ec_debug.push ( 'ECE_ADVO_ADVICE_PKG.Extract_ADVO_Outbound' );

48:
49: BEGIN
50:
51: ec_debug.enable_debug ( v_debug_mode );
52: ec_debug.push ( 'ECE_ADVO_ADVICE_PKG.Extract_ADVO_Outbound' );
53: ec_debug.pl ( 3, 'cOutput_Path: ',cOutput_Path );
54: ec_debug.pl ( 3, 'cOutput_Filename: ',cOutput_Filename );
55: ec_debug.pl ( 3, 'p_TP_Group: ',p_TP_Group );
56: ec_debug.pl ( 3, 'p_TP: ',p_TP );

Line 53: ec_debug.pl ( 3, 'cOutput_Path: ',cOutput_Path );

49: BEGIN
50:
51: ec_debug.enable_debug ( v_debug_mode );
52: ec_debug.push ( 'ECE_ADVO_ADVICE_PKG.Extract_ADVO_Outbound' );
53: ec_debug.pl ( 3, 'cOutput_Path: ',cOutput_Path );
54: ec_debug.pl ( 3, 'cOutput_Filename: ',cOutput_Filename );
55: ec_debug.pl ( 3, 'p_TP_Group: ',p_TP_Group );
56: ec_debug.pl ( 3, 'p_TP: ',p_TP );
57: ec_debug.pl ( 3, 'p_Response_to_doc: ',p_Response_to_doc );

Line 54: ec_debug.pl ( 3, 'cOutput_Filename: ',cOutput_Filename );

50:
51: ec_debug.enable_debug ( v_debug_mode );
52: ec_debug.push ( 'ECE_ADVO_ADVICE_PKG.Extract_ADVO_Outbound' );
53: ec_debug.pl ( 3, 'cOutput_Path: ',cOutput_Path );
54: ec_debug.pl ( 3, 'cOutput_Filename: ',cOutput_Filename );
55: ec_debug.pl ( 3, 'p_TP_Group: ',p_TP_Group );
56: ec_debug.pl ( 3, 'p_TP: ',p_TP );
57: ec_debug.pl ( 3, 'p_Response_to_doc: ',p_Response_to_doc );
58: ec_debug.pl ( 3, 'cDate_From: ',cDate_From );

Line 55: ec_debug.pl ( 3, 'p_TP_Group: ',p_TP_Group );

51: ec_debug.enable_debug ( v_debug_mode );
52: ec_debug.push ( 'ECE_ADVO_ADVICE_PKG.Extract_ADVO_Outbound' );
53: ec_debug.pl ( 3, 'cOutput_Path: ',cOutput_Path );
54: ec_debug.pl ( 3, 'cOutput_Filename: ',cOutput_Filename );
55: ec_debug.pl ( 3, 'p_TP_Group: ',p_TP_Group );
56: ec_debug.pl ( 3, 'p_TP: ',p_TP );
57: ec_debug.pl ( 3, 'p_Response_to_doc: ',p_Response_to_doc );
58: ec_debug.pl ( 3, 'cDate_From: ',cDate_From );
59: ec_debug.pl ( 3, 'cDate_To: ',cDate_To );

Line 56: ec_debug.pl ( 3, 'p_TP: ',p_TP );

52: ec_debug.push ( 'ECE_ADVO_ADVICE_PKG.Extract_ADVO_Outbound' );
53: ec_debug.pl ( 3, 'cOutput_Path: ',cOutput_Path );
54: ec_debug.pl ( 3, 'cOutput_Filename: ',cOutput_Filename );
55: ec_debug.pl ( 3, 'p_TP_Group: ',p_TP_Group );
56: ec_debug.pl ( 3, 'p_TP: ',p_TP );
57: ec_debug.pl ( 3, 'p_Response_to_doc: ',p_Response_to_doc );
58: ec_debug.pl ( 3, 'cDate_From: ',cDate_From );
59: ec_debug.pl ( 3, 'cDate_To: ',cDate_To );
60: ec_debug.pl ( 3, 'p_ext_ref1: ',p_ext_ref1 );

Line 57: ec_debug.pl ( 3, 'p_Response_to_doc: ',p_Response_to_doc );

53: ec_debug.pl ( 3, 'cOutput_Path: ',cOutput_Path );
54: ec_debug.pl ( 3, 'cOutput_Filename: ',cOutput_Filename );
55: ec_debug.pl ( 3, 'p_TP_Group: ',p_TP_Group );
56: ec_debug.pl ( 3, 'p_TP: ',p_TP );
57: ec_debug.pl ( 3, 'p_Response_to_doc: ',p_Response_to_doc );
58: ec_debug.pl ( 3, 'cDate_From: ',cDate_From );
59: ec_debug.pl ( 3, 'cDate_To: ',cDate_To );
60: ec_debug.pl ( 3, 'p_ext_ref1: ',p_ext_ref1 );
61: ec_debug.pl ( 3, 'p_ext_ref2: ',p_ext_ref2 );

Line 58: ec_debug.pl ( 3, 'cDate_From: ',cDate_From );

54: ec_debug.pl ( 3, 'cOutput_Filename: ',cOutput_Filename );
55: ec_debug.pl ( 3, 'p_TP_Group: ',p_TP_Group );
56: ec_debug.pl ( 3, 'p_TP: ',p_TP );
57: ec_debug.pl ( 3, 'p_Response_to_doc: ',p_Response_to_doc );
58: ec_debug.pl ( 3, 'cDate_From: ',cDate_From );
59: ec_debug.pl ( 3, 'cDate_To: ',cDate_To );
60: ec_debug.pl ( 3, 'p_ext_ref1: ',p_ext_ref1 );
61: ec_debug.pl ( 3, 'p_ext_ref2: ',p_ext_ref2 );
62: ec_debug.pl ( 3, 'p_ext_ref3: ',p_ext_ref3 );

Line 59: ec_debug.pl ( 3, 'cDate_To: ',cDate_To );

55: ec_debug.pl ( 3, 'p_TP_Group: ',p_TP_Group );
56: ec_debug.pl ( 3, 'p_TP: ',p_TP );
57: ec_debug.pl ( 3, 'p_Response_to_doc: ',p_Response_to_doc );
58: ec_debug.pl ( 3, 'cDate_From: ',cDate_From );
59: ec_debug.pl ( 3, 'cDate_To: ',cDate_To );
60: ec_debug.pl ( 3, 'p_ext_ref1: ',p_ext_ref1 );
61: ec_debug.pl ( 3, 'p_ext_ref2: ',p_ext_ref2 );
62: ec_debug.pl ( 3, 'p_ext_ref3: ',p_ext_ref3 );
63: ec_debug.pl ( 3, 'p_ext_ref4: ',p_ext_ref4 );

Line 60: ec_debug.pl ( 3, 'p_ext_ref1: ',p_ext_ref1 );

56: ec_debug.pl ( 3, 'p_TP: ',p_TP );
57: ec_debug.pl ( 3, 'p_Response_to_doc: ',p_Response_to_doc );
58: ec_debug.pl ( 3, 'cDate_From: ',cDate_From );
59: ec_debug.pl ( 3, 'cDate_To: ',cDate_To );
60: ec_debug.pl ( 3, 'p_ext_ref1: ',p_ext_ref1 );
61: ec_debug.pl ( 3, 'p_ext_ref2: ',p_ext_ref2 );
62: ec_debug.pl ( 3, 'p_ext_ref3: ',p_ext_ref3 );
63: ec_debug.pl ( 3, 'p_ext_ref4: ',p_ext_ref4 );
64: ec_debug.pl ( 3, 'p_ext_ref5: ',p_ext_ref5 );

Line 61: ec_debug.pl ( 3, 'p_ext_ref2: ',p_ext_ref2 );

57: ec_debug.pl ( 3, 'p_Response_to_doc: ',p_Response_to_doc );
58: ec_debug.pl ( 3, 'cDate_From: ',cDate_From );
59: ec_debug.pl ( 3, 'cDate_To: ',cDate_To );
60: ec_debug.pl ( 3, 'p_ext_ref1: ',p_ext_ref1 );
61: ec_debug.pl ( 3, 'p_ext_ref2: ',p_ext_ref2 );
62: ec_debug.pl ( 3, 'p_ext_ref3: ',p_ext_ref3 );
63: ec_debug.pl ( 3, 'p_ext_ref4: ',p_ext_ref4 );
64: ec_debug.pl ( 3, 'p_ext_ref5: ',p_ext_ref5 );
65: ec_debug.pl ( 3, 'p_ext_ref6: ',p_ext_ref6 );

Line 62: ec_debug.pl ( 3, 'p_ext_ref3: ',p_ext_ref3 );

58: ec_debug.pl ( 3, 'cDate_From: ',cDate_From );
59: ec_debug.pl ( 3, 'cDate_To: ',cDate_To );
60: ec_debug.pl ( 3, 'p_ext_ref1: ',p_ext_ref1 );
61: ec_debug.pl ( 3, 'p_ext_ref2: ',p_ext_ref2 );
62: ec_debug.pl ( 3, 'p_ext_ref3: ',p_ext_ref3 );
63: ec_debug.pl ( 3, 'p_ext_ref4: ',p_ext_ref4 );
64: ec_debug.pl ( 3, 'p_ext_ref5: ',p_ext_ref5 );
65: ec_debug.pl ( 3, 'p_ext_ref6: ',p_ext_ref6 );
66: ec_debug.pl ( 3, 'v_debug_mode: ',v_debug_mode );

Line 63: ec_debug.pl ( 3, 'p_ext_ref4: ',p_ext_ref4 );

59: ec_debug.pl ( 3, 'cDate_To: ',cDate_To );
60: ec_debug.pl ( 3, 'p_ext_ref1: ',p_ext_ref1 );
61: ec_debug.pl ( 3, 'p_ext_ref2: ',p_ext_ref2 );
62: ec_debug.pl ( 3, 'p_ext_ref3: ',p_ext_ref3 );
63: ec_debug.pl ( 3, 'p_ext_ref4: ',p_ext_ref4 );
64: ec_debug.pl ( 3, 'p_ext_ref5: ',p_ext_ref5 );
65: ec_debug.pl ( 3, 'p_ext_ref6: ',p_ext_ref6 );
66: ec_debug.pl ( 3, 'v_debug_mode: ',v_debug_mode );
67:

Line 64: ec_debug.pl ( 3, 'p_ext_ref5: ',p_ext_ref5 );

60: ec_debug.pl ( 3, 'p_ext_ref1: ',p_ext_ref1 );
61: ec_debug.pl ( 3, 'p_ext_ref2: ',p_ext_ref2 );
62: ec_debug.pl ( 3, 'p_ext_ref3: ',p_ext_ref3 );
63: ec_debug.pl ( 3, 'p_ext_ref4: ',p_ext_ref4 );
64: ec_debug.pl ( 3, 'p_ext_ref5: ',p_ext_ref5 );
65: ec_debug.pl ( 3, 'p_ext_ref6: ',p_ext_ref6 );
66: ec_debug.pl ( 3, 'v_debug_mode: ',v_debug_mode );
67:
68: /* Check to see if the transaction is enabled. If not, abort */

Line 65: ec_debug.pl ( 3, 'p_ext_ref6: ',p_ext_ref6 );

61: ec_debug.pl ( 3, 'p_ext_ref2: ',p_ext_ref2 );
62: ec_debug.pl ( 3, 'p_ext_ref3: ',p_ext_ref3 );
63: ec_debug.pl ( 3, 'p_ext_ref4: ',p_ext_ref4 );
64: ec_debug.pl ( 3, 'p_ext_ref5: ',p_ext_ref5 );
65: ec_debug.pl ( 3, 'p_ext_ref6: ',p_ext_ref6 );
66: ec_debug.pl ( 3, 'v_debug_mode: ',v_debug_mode );
67:
68: /* Check to see if the transaction is enabled. If not, abort */
69: xProgress := 'ADVO-10-1001';

Line 66: ec_debug.pl ( 3, 'v_debug_mode: ',v_debug_mode );

62: ec_debug.pl ( 3, 'p_ext_ref3: ',p_ext_ref3 );
63: ec_debug.pl ( 3, 'p_ext_ref4: ',p_ext_ref4 );
64: ec_debug.pl ( 3, 'p_ext_ref5: ',p_ext_ref5 );
65: ec_debug.pl ( 3, 'p_ext_ref6: ',p_ext_ref6 );
66: ec_debug.pl ( 3, 'v_debug_mode: ',v_debug_mode );
67:
68: /* Check to see if the transaction is enabled. If not, abort */
69: xProgress := 'ADVO-10-1001';
70: fnd_profile.get('ECE_' || p_Transaction_Type || '_ENABLED',cEnabled);

Line 85: ec_debug.pl ( 0,

81: INTO p_run_id
82: FROM sys.dual;
83: EXCEPTION
84: WHEN NO_DATA_FOUND THEN
85: ec_debug.pl ( 0,
86: 'EC',
87: 'ECE_GET_NEXT_SEQ_FAILED',
88: 'PROGRESS_LEVEL',
89: xProgress,

Line 93: ec_debug.pl ( 3, 'p_run_id: ',p_run_id );

89: xProgress,
90: 'SEQ',
91: 'ECE_OUTPUT_RUNS_S' );
92: END;
93: ec_debug.pl ( 3, 'p_run_id: ',p_run_id );
94:
95: xProgress := 'ADVO-10-1010';
96: ec_debug.pl ( 0, 'EC', 'ECE_ADVO_START', NULL );
97:

Line 96: ec_debug.pl ( 0, 'EC', 'ECE_ADVO_START', NULL );

92: END;
93: ec_debug.pl ( 3, 'p_run_id: ',p_run_id );
94:
95: xProgress := 'ADVO-10-1010';
96: ec_debug.pl ( 0, 'EC', 'ECE_ADVO_START', NULL );
97:
98: xProgress := 'ADVO-10-1020';
99: ec_debug.pl ( 0, 'EC', 'ECE_RUN_ID', 'RUN_ID', p_run_id );
100:

Line 99: ec_debug.pl ( 0, 'EC', 'ECE_RUN_ID', 'RUN_ID', p_run_id );

95: xProgress := 'ADVO-10-1010';
96: ec_debug.pl ( 0, 'EC', 'ECE_ADVO_START', NULL );
97:
98: xProgress := 'ADVO-10-1020';
99: ec_debug.pl ( 0, 'EC', 'ECE_RUN_ID', 'RUN_ID', p_run_id );
100:
101: xProgress := 'ADVO-10-1030';
102: ECE_ADVO_ADVICE_PKG.EXTRACT_FROM_BASE_APPS ( p_communication_method,
103: p_transaction_type,

Line 153: ec_debug.pl ( 3, 'l_line_text: ',l_line_text );

149: end if;
150:
151: EXIT WHEN c_output%NOTFOUND;
152:
153: ec_debug.pl ( 3, 'l_line_text: ',l_line_text );
154:
155: /*
156: **
157: ** Write the data from ece_output to the output file.

Line 186: ec_debug.pl ( 0, 'EC', 'ECE_ADVO_COMPLETE', NULL );

182: **
183: */
184:
185: xProgress := 'ADVO-10-1090';
186: ec_debug.pl ( 0, 'EC', 'ECE_ADVO_COMPLETE', NULL );
187:
188: xProgress := 'ADVO-10-1100';
189: DELETE
190: FROM ece_output

Line 195: ec_debug.pl ( 0,

191: WHERE run_id = p_run_id;
192:
193: IF SQL%NOTFOUND
194: THEN
195: ec_debug.pl ( 0,
196: 'EC',
197: 'ECE_NO_ROW_DELETED',
198: 'PROGRESS_LEVEL',
199: xProgress,

Line 208: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);

204: --- Everything is successful. Commit the Changes.
205: commit;
206:
207: IF ec_mapping_utils.ec_get_trans_upgrade_status(p_transaction_type) = 'U' THEN
208: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);
209: retcode := 1;
210: END IF;
211:
212: ec_debug.pop ( 'ece_advo_advice_pkg.Extract_ADVO_Outbound' );

Line 212: ec_debug.pop ( 'ece_advo_advice_pkg.Extract_ADVO_Outbound' );

208: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);
209: retcode := 1;
210: END IF;
211:
212: ec_debug.pop ( 'ece_advo_advice_pkg.Extract_ADVO_Outbound' );
213: ec_debug.disable_debug;
214:
215: EXCEPTION
216: WHEN ece_transaction_disabled THEN

Line 213: ec_debug.disable_debug;

209: retcode := 1;
210: END IF;
211:
212: ec_debug.pop ( 'ece_advo_advice_pkg.Extract_ADVO_Outbound' );
213: ec_debug.disable_debug;
214:
215: EXCEPTION
216: WHEN ece_transaction_disabled THEN
217: ec_debug.pl(0,'EC','ECE_TRANSACTION_DISABLED','TRANSACTION',p_Transaction_type);

Line 217: ec_debug.pl(0,'EC','ECE_TRANSACTION_DISABLED','TRANSACTION',p_Transaction_type);

213: ec_debug.disable_debug;
214:
215: EXCEPTION
216: WHEN ece_transaction_disabled THEN
217: ec_debug.pl(0,'EC','ECE_TRANSACTION_DISABLED','TRANSACTION',p_Transaction_type);
218: retcode := 1;
219: ec_debug.disable_debug;
220: ROLLBACK;
221:

Line 219: ec_debug.disable_debug;

215: EXCEPTION
216: WHEN ece_transaction_disabled THEN
217: ec_debug.pl(0,'EC','ECE_TRANSACTION_DISABLED','TRANSACTION',p_Transaction_type);
218: retcode := 1;
219: ec_debug.disable_debug;
220: ROLLBACK;
221:
222: WHEN utl_file.write_error THEN
223:

Line 224: ec_debug.pl ( 0,

220: ROLLBACK;
221:
222: WHEN utl_file.write_error THEN
223:
224: ec_debug.pl ( 0,
225: 'EC',
226: 'ECE_UTL_WRITE_ERROR',
227: NULL );
228:

Line 229: ec_debug.pl ( 0,

225: 'EC',
226: 'ECE_UTL_WRITE_ERROR',
227: NULL );
228:
229: ec_debug.pl ( 0,
230: 'EC',
231: 'ECE_ERROR_MESSAGE',
232: 'ERROR_MESSAGE',
233: SQLERRM );

Line 236: ec_debug.disable_debug;

232: 'ERROR_MESSAGE',
233: SQLERRM );
234:
235: retcode := 2;
236: ec_debug.disable_debug;
237: ROLLBACK;
238: RAISE;
239:
240: WHEN utl_file.invalid_path THEN

Line 242: ec_debug.pl ( 0,

238: RAISE;
239:
240: WHEN utl_file.invalid_path THEN
241:
242: ec_debug.pl ( 0,
243: 'EC',
244: 'ECE_UTIL_INVALID_PATH',
245: NULL );
246:

Line 247: ec_debug.pl ( 0,

243: 'EC',
244: 'ECE_UTIL_INVALID_PATH',
245: NULL );
246:
247: ec_debug.pl ( 0,
248: 'EC',
249: 'ECE_ERROR_MESSAGE',
250: 'ERROR_MESSAGE',
251: SQLERRM );

Line 254: ec_debug.disable_debug;

250: 'ERROR_MESSAGE',
251: SQLERRM );
252:
253: retcode := 2;
254: ec_debug.disable_debug;
255: ROLLBACK;
256: RAISE;
257:
258: WHEN utl_file.invalid_operation THEN

Line 260: ec_debug.pl ( 0,

256: RAISE;
257:
258: WHEN utl_file.invalid_operation THEN
259:
260: ec_debug.pl ( 0,
261: 'EC',
262: 'ECE_UTIL_INVALID_OPERATION',
263: NULL );
264:

Line 265: ec_debug.pl ( 0,

261: 'EC',
262: 'ECE_UTIL_INVALID_OPERATION',
263: NULL );
264:
265: ec_debug.pl ( 0,
266: 'EC',
267: 'ECE_ERROR_MESSAGE',
268: 'ERROR_MESSAGE',
269: SQLERRM );

Line 272: ec_debug.disable_debug;

268: 'ERROR_MESSAGE',
269: SQLERRM );
270:
271: retcode := 2;
272: ec_debug.disable_debug;
273: ROLLBACK;
274: RAISE;
275:
276: WHEN OTHERS THEN

Line 278: ec_debug.pl ( 0,

274: RAISE;
275:
276: WHEN OTHERS THEN
277:
278: ec_debug.pl ( 0,
279: 'EC',
280: 'ECE_PROGRAM_ERROR',
281: 'PROGRESS_LEVEL',
282: xProgress );

Line 284: ec_debug.pl ( 0,

280: 'ECE_PROGRAM_ERROR',
281: 'PROGRESS_LEVEL',
282: xProgress );
283:
284: ec_debug.pl ( 0,
285: 'EC',
286: 'ECE_ERROR_MESSAGE',
287: 'ERROR_MESSAGE',
288: SQLERRM );

Line 291: ec_debug.disable_debug;

287: 'ERROR_MESSAGE',
288: SQLERRM );
289:
290: retcode := 2;
291: ec_debug.disable_debug;
292: ROLLBACK;
293: RAISE;
294:
295: END Extract_ADVO_Outbound;

Line 410: ec_debug.push ( 'ece_advo_advice_pkg.Extract_From_Base_Apps' );

406: ** Debug statements for the parameter values.
407: **
408: */
409:
410: ec_debug.push ( 'ece_advo_advice_pkg.Extract_From_Base_Apps' );
411: ec_debug.pl ( 3, 'cCommunication_Method: ', cCommunication_Method );
412: ec_debug.pl ( 3, 'cTransaction_Type: ',cTransaction_Type );
413: ec_debug.pl ( 3, 'iOutput_width: ',iOutput_width );
414: ec_debug.pl ( 3, 'dTransaction_date: ',dTransaction_date );

Line 411: ec_debug.pl ( 3, 'cCommunication_Method: ', cCommunication_Method );

407: **
408: */
409:
410: ec_debug.push ( 'ece_advo_advice_pkg.Extract_From_Base_Apps' );
411: ec_debug.pl ( 3, 'cCommunication_Method: ', cCommunication_Method );
412: ec_debug.pl ( 3, 'cTransaction_Type: ',cTransaction_Type );
413: ec_debug.pl ( 3, 'iOutput_width: ',iOutput_width );
414: ec_debug.pl ( 3, 'dTransaction_date: ',dTransaction_date );
415: ec_debug.pl ( 3, 'iRun_id: ',iRun_id );

Line 412: ec_debug.pl ( 3, 'cTransaction_Type: ',cTransaction_Type );

408: */
409:
410: ec_debug.push ( 'ece_advo_advice_pkg.Extract_From_Base_Apps' );
411: ec_debug.pl ( 3, 'cCommunication_Method: ', cCommunication_Method );
412: ec_debug.pl ( 3, 'cTransaction_Type: ',cTransaction_Type );
413: ec_debug.pl ( 3, 'iOutput_width: ',iOutput_width );
414: ec_debug.pl ( 3, 'dTransaction_date: ',dTransaction_date );
415: ec_debug.pl ( 3, 'iRun_id: ',iRun_id );
416: ec_debug.pl ( 3, 'cHeader_Interface: ',cHeader_Interface );

Line 413: ec_debug.pl ( 3, 'iOutput_width: ',iOutput_width );

409:
410: ec_debug.push ( 'ece_advo_advice_pkg.Extract_From_Base_Apps' );
411: ec_debug.pl ( 3, 'cCommunication_Method: ', cCommunication_Method );
412: ec_debug.pl ( 3, 'cTransaction_Type: ',cTransaction_Type );
413: ec_debug.pl ( 3, 'iOutput_width: ',iOutput_width );
414: ec_debug.pl ( 3, 'dTransaction_date: ',dTransaction_date );
415: ec_debug.pl ( 3, 'iRun_id: ',iRun_id );
416: ec_debug.pl ( 3, 'cHeader_Interface: ',cHeader_Interface );
417: ec_debug.pl ( 3, 'cLine_Interface: ',cLine_Interface );

Line 414: ec_debug.pl ( 3, 'dTransaction_date: ',dTransaction_date );

410: ec_debug.push ( 'ece_advo_advice_pkg.Extract_From_Base_Apps' );
411: ec_debug.pl ( 3, 'cCommunication_Method: ', cCommunication_Method );
412: ec_debug.pl ( 3, 'cTransaction_Type: ',cTransaction_Type );
413: ec_debug.pl ( 3, 'iOutput_width: ',iOutput_width );
414: ec_debug.pl ( 3, 'dTransaction_date: ',dTransaction_date );
415: ec_debug.pl ( 3, 'iRun_id: ',iRun_id );
416: ec_debug.pl ( 3, 'cHeader_Interface: ',cHeader_Interface );
417: ec_debug.pl ( 3, 'cLine_Interface: ',cLine_Interface );
418: ec_debug.pl ( 3, 'p_TP_Group: ',p_TP_Group );

Line 415: ec_debug.pl ( 3, 'iRun_id: ',iRun_id );

411: ec_debug.pl ( 3, 'cCommunication_Method: ', cCommunication_Method );
412: ec_debug.pl ( 3, 'cTransaction_Type: ',cTransaction_Type );
413: ec_debug.pl ( 3, 'iOutput_width: ',iOutput_width );
414: ec_debug.pl ( 3, 'dTransaction_date: ',dTransaction_date );
415: ec_debug.pl ( 3, 'iRun_id: ',iRun_id );
416: ec_debug.pl ( 3, 'cHeader_Interface: ',cHeader_Interface );
417: ec_debug.pl ( 3, 'cLine_Interface: ',cLine_Interface );
418: ec_debug.pl ( 3, 'p_TP_Group: ',p_TP_Group );
419: ec_debug.pl ( 3, 'p_Response_to_doc: ',p_Response_to_doc );

Line 416: ec_debug.pl ( 3, 'cHeader_Interface: ',cHeader_Interface );

412: ec_debug.pl ( 3, 'cTransaction_Type: ',cTransaction_Type );
413: ec_debug.pl ( 3, 'iOutput_width: ',iOutput_width );
414: ec_debug.pl ( 3, 'dTransaction_date: ',dTransaction_date );
415: ec_debug.pl ( 3, 'iRun_id: ',iRun_id );
416: ec_debug.pl ( 3, 'cHeader_Interface: ',cHeader_Interface );
417: ec_debug.pl ( 3, 'cLine_Interface: ',cLine_Interface );
418: ec_debug.pl ( 3, 'p_TP_Group: ',p_TP_Group );
419: ec_debug.pl ( 3, 'p_Response_to_doc: ',p_Response_to_doc );
420: ec_debug.pl ( 3, 'p_Date_From: ',p_Date_From );

Line 417: ec_debug.pl ( 3, 'cLine_Interface: ',cLine_Interface );

413: ec_debug.pl ( 3, 'iOutput_width: ',iOutput_width );
414: ec_debug.pl ( 3, 'dTransaction_date: ',dTransaction_date );
415: ec_debug.pl ( 3, 'iRun_id: ',iRun_id );
416: ec_debug.pl ( 3, 'cHeader_Interface: ',cHeader_Interface );
417: ec_debug.pl ( 3, 'cLine_Interface: ',cLine_Interface );
418: ec_debug.pl ( 3, 'p_TP_Group: ',p_TP_Group );
419: ec_debug.pl ( 3, 'p_Response_to_doc: ',p_Response_to_doc );
420: ec_debug.pl ( 3, 'p_Date_From: ',p_Date_From );
421: ec_debug.pl ( 3, 'p_Date_To: ',p_Date_To );

Line 418: ec_debug.pl ( 3, 'p_TP_Group: ',p_TP_Group );

414: ec_debug.pl ( 3, 'dTransaction_date: ',dTransaction_date );
415: ec_debug.pl ( 3, 'iRun_id: ',iRun_id );
416: ec_debug.pl ( 3, 'cHeader_Interface: ',cHeader_Interface );
417: ec_debug.pl ( 3, 'cLine_Interface: ',cLine_Interface );
418: ec_debug.pl ( 3, 'p_TP_Group: ',p_TP_Group );
419: ec_debug.pl ( 3, 'p_Response_to_doc: ',p_Response_to_doc );
420: ec_debug.pl ( 3, 'p_Date_From: ',p_Date_From );
421: ec_debug.pl ( 3, 'p_Date_To: ',p_Date_To );
422: ec_debug.pl ( 3, 'p_ext_ref1: ',p_ext_ref1 );

Line 419: ec_debug.pl ( 3, 'p_Response_to_doc: ',p_Response_to_doc );

415: ec_debug.pl ( 3, 'iRun_id: ',iRun_id );
416: ec_debug.pl ( 3, 'cHeader_Interface: ',cHeader_Interface );
417: ec_debug.pl ( 3, 'cLine_Interface: ',cLine_Interface );
418: ec_debug.pl ( 3, 'p_TP_Group: ',p_TP_Group );
419: ec_debug.pl ( 3, 'p_Response_to_doc: ',p_Response_to_doc );
420: ec_debug.pl ( 3, 'p_Date_From: ',p_Date_From );
421: ec_debug.pl ( 3, 'p_Date_To: ',p_Date_To );
422: ec_debug.pl ( 3, 'p_ext_ref1: ',p_ext_ref1 );
423: ec_debug.pl ( 3, 'p_ext_ref2: ',p_ext_ref2 );

Line 420: ec_debug.pl ( 3, 'p_Date_From: ',p_Date_From );

416: ec_debug.pl ( 3, 'cHeader_Interface: ',cHeader_Interface );
417: ec_debug.pl ( 3, 'cLine_Interface: ',cLine_Interface );
418: ec_debug.pl ( 3, 'p_TP_Group: ',p_TP_Group );
419: ec_debug.pl ( 3, 'p_Response_to_doc: ',p_Response_to_doc );
420: ec_debug.pl ( 3, 'p_Date_From: ',p_Date_From );
421: ec_debug.pl ( 3, 'p_Date_To: ',p_Date_To );
422: ec_debug.pl ( 3, 'p_ext_ref1: ',p_ext_ref1 );
423: ec_debug.pl ( 3, 'p_ext_ref2: ',p_ext_ref2 );
424: ec_debug.pl ( 3, 'p_ext_ref3: ',p_ext_ref3 );

Line 421: ec_debug.pl ( 3, 'p_Date_To: ',p_Date_To );

417: ec_debug.pl ( 3, 'cLine_Interface: ',cLine_Interface );
418: ec_debug.pl ( 3, 'p_TP_Group: ',p_TP_Group );
419: ec_debug.pl ( 3, 'p_Response_to_doc: ',p_Response_to_doc );
420: ec_debug.pl ( 3, 'p_Date_From: ',p_Date_From );
421: ec_debug.pl ( 3, 'p_Date_To: ',p_Date_To );
422: ec_debug.pl ( 3, 'p_ext_ref1: ',p_ext_ref1 );
423: ec_debug.pl ( 3, 'p_ext_ref2: ',p_ext_ref2 );
424: ec_debug.pl ( 3, 'p_ext_ref3: ',p_ext_ref3 );
425: ec_debug.pl ( 3, 'p_ext_ref4: ',p_ext_ref4 );

Line 422: ec_debug.pl ( 3, 'p_ext_ref1: ',p_ext_ref1 );

418: ec_debug.pl ( 3, 'p_TP_Group: ',p_TP_Group );
419: ec_debug.pl ( 3, 'p_Response_to_doc: ',p_Response_to_doc );
420: ec_debug.pl ( 3, 'p_Date_From: ',p_Date_From );
421: ec_debug.pl ( 3, 'p_Date_To: ',p_Date_To );
422: ec_debug.pl ( 3, 'p_ext_ref1: ',p_ext_ref1 );
423: ec_debug.pl ( 3, 'p_ext_ref2: ',p_ext_ref2 );
424: ec_debug.pl ( 3, 'p_ext_ref3: ',p_ext_ref3 );
425: ec_debug.pl ( 3, 'p_ext_ref4: ',p_ext_ref4 );
426: ec_debug.pl ( 3, 'p_ext_ref5: ',p_ext_ref5 );

Line 423: ec_debug.pl ( 3, 'p_ext_ref2: ',p_ext_ref2 );

419: ec_debug.pl ( 3, 'p_Response_to_doc: ',p_Response_to_doc );
420: ec_debug.pl ( 3, 'p_Date_From: ',p_Date_From );
421: ec_debug.pl ( 3, 'p_Date_To: ',p_Date_To );
422: ec_debug.pl ( 3, 'p_ext_ref1: ',p_ext_ref1 );
423: ec_debug.pl ( 3, 'p_ext_ref2: ',p_ext_ref2 );
424: ec_debug.pl ( 3, 'p_ext_ref3: ',p_ext_ref3 );
425: ec_debug.pl ( 3, 'p_ext_ref4: ',p_ext_ref4 );
426: ec_debug.pl ( 3, 'p_ext_ref5: ',p_ext_ref5 );
427: ec_debug.pl ( 3, 'p_ext_ref6: ',p_ext_ref6 );

Line 424: ec_debug.pl ( 3, 'p_ext_ref3: ',p_ext_ref3 );

420: ec_debug.pl ( 3, 'p_Date_From: ',p_Date_From );
421: ec_debug.pl ( 3, 'p_Date_To: ',p_Date_To );
422: ec_debug.pl ( 3, 'p_ext_ref1: ',p_ext_ref1 );
423: ec_debug.pl ( 3, 'p_ext_ref2: ',p_ext_ref2 );
424: ec_debug.pl ( 3, 'p_ext_ref3: ',p_ext_ref3 );
425: ec_debug.pl ( 3, 'p_ext_ref4: ',p_ext_ref4 );
426: ec_debug.pl ( 3, 'p_ext_ref5: ',p_ext_ref5 );
427: ec_debug.pl ( 3, 'p_ext_ref6: ',p_ext_ref6 );
428:

Line 425: ec_debug.pl ( 3, 'p_ext_ref4: ',p_ext_ref4 );

421: ec_debug.pl ( 3, 'p_Date_To: ',p_Date_To );
422: ec_debug.pl ( 3, 'p_ext_ref1: ',p_ext_ref1 );
423: ec_debug.pl ( 3, 'p_ext_ref2: ',p_ext_ref2 );
424: ec_debug.pl ( 3, 'p_ext_ref3: ',p_ext_ref3 );
425: ec_debug.pl ( 3, 'p_ext_ref4: ',p_ext_ref4 );
426: ec_debug.pl ( 3, 'p_ext_ref5: ',p_ext_ref5 );
427: ec_debug.pl ( 3, 'p_ext_ref6: ',p_ext_ref6 );
428:
429: /*

Line 426: ec_debug.pl ( 3, 'p_ext_ref5: ',p_ext_ref5 );

422: ec_debug.pl ( 3, 'p_ext_ref1: ',p_ext_ref1 );
423: ec_debug.pl ( 3, 'p_ext_ref2: ',p_ext_ref2 );
424: ec_debug.pl ( 3, 'p_ext_ref3: ',p_ext_ref3 );
425: ec_debug.pl ( 3, 'p_ext_ref4: ',p_ext_ref4 );
426: ec_debug.pl ( 3, 'p_ext_ref5: ',p_ext_ref5 );
427: ec_debug.pl ( 3, 'p_ext_ref6: ',p_ext_ref6 );
428:
429: /*
430: **

Line 427: ec_debug.pl ( 3, 'p_ext_ref6: ',p_ext_ref6 );

423: ec_debug.pl ( 3, 'p_ext_ref2: ',p_ext_ref2 );
424: ec_debug.pl ( 3, 'p_ext_ref3: ',p_ext_ref3 );
425: ec_debug.pl ( 3, 'p_ext_ref4: ',p_ext_ref4 );
426: ec_debug.pl ( 3, 'p_ext_ref5: ',p_ext_ref5 );
427: ec_debug.pl ( 3, 'p_ext_ref6: ',p_ext_ref6 );
428:
429: /*
430: **
431: ** The "Init_Table" procedure will build the internal PL/SQL

Line 619: ec_debug.pl ( 3, 'cHeader_select: ',cHeader_select );

615: xProgress := 'ADVOB-10-1180';
616: cHeader_select := cHeader_select ||
617: cHeader_from ||
618: cHeader_where;
619: ec_debug.pl ( 3, 'cHeader_select: ',cHeader_select );
620:
621: xProgress := 'ADVOB-10-1190';
622: cLine_select := cLine_select ||
623: cLine_from ||

Line 625: ec_debug.pl ( 3, 'cLine_select: ',cLine_select );

621: xProgress := 'ADVOB-10-1190';
622: cLine_select := cLine_select ||
623: cLine_from ||
624: cLine_where;
625: ec_debug.pl ( 3, 'cLine_select: ',cLine_select );
626:
627: /*
628: **
629: ** Open a cursor for each of the SELECT calls. This tells the

Line 681: ec_debug.pl ( 3, 'iHeader_count: ',iHeader_count );

677: */
678:
679: xProgress := 'ADVOB-10-1240';
680: iHeader_count := l_header_tbl.count;
681: ec_debug.pl ( 3, 'iHeader_count: ',iHeader_count );
682:
683: xProgress := 'ADVOB-10-1250';
684: iLine_count := l_line_tbl.count;
685: ec_debug.pl ( 3, 'iLine_count: ',iLine_count );

Line 685: ec_debug.pl ( 3, 'iLine_count: ',iLine_count );

681: ec_debug.pl ( 3, 'iHeader_count: ',iHeader_count );
682:
683: xProgress := 'ADVOB-10-1250';
684: iLine_count := l_line_tbl.count;
685: ec_debug.pl ( 3, 'iLine_count: ',iLine_count );
686:
687: /*
688: **
689: ** Define the data type for every column in each SELECT statement

Line 723: ec_debug.pl(3, 'n_trx_date_pos: ',n_trx_date_pos );

719: xProgress := 'ADVOB-10-1280';
720: ece_extract_utils_pub.Find_pos ( l_header_tbl,
721: ece_extract_utils_pub.G_Transaction_date,
722: n_trx_date_pos );
723: ec_debug.pl(3, 'n_trx_date_pos: ',n_trx_date_pos );
724:
725: xProgress := 'ADVOB-10-1290';
726: ece_extract_utils_pub.Find_pos ( l_header_tbl,
727: 'ADVICE_HEADER_ID',

Line 729: ec_debug.pl(3, 'n_advice_header_id_pos: ',n_advice_header_id_pos );

725: xProgress := 'ADVOB-10-1290';
726: ece_extract_utils_pub.Find_pos ( l_header_tbl,
727: 'ADVICE_HEADER_ID',
728: n_advice_header_id_pos );
729: ec_debug.pl(3, 'n_advice_header_id_pos: ',n_advice_header_id_pos );
730:
731:
732: xProgress := 'ADVOB-10-1291';
733: IF p_TP_Group IS NOT NULL

Line 860: ec_debug.pl ( 3, 'l_header_tbl(n_advice_header_id_pos).value: ',l_header_tbl(n_advice_header_id_pos).value );

856:
857:
858: END LOOP;
859:
860: ec_debug.pl ( 3, 'l_header_tbl(n_advice_header_id_pos).value: ',l_header_tbl(n_advice_header_id_pos).value );
861:
862: /*
863: **
864: ** Update ECE_ADVO_HEADERS to archive the current Advice header.

Line 875: ec_debug.pl ( 0,

871: WHERE advice_header_id = l_header_tbl(n_advice_header_id_pos).value;
872:
873: IF SQL%NOTFOUND
874: THEN
875: ec_debug.pl ( 0,
876: 'EC',
877: 'ECE_NO_ROW_UPDATED',
878: 'PROGRESS_LEVEL',
879: xProgress,

Line 895: ec_debug.pl ( 3, 'l_header_tbl(n_trx_date_pos).value: ',l_header_tbl(n_trx_date_pos).value );

891: */
892:
893: xProgress := 'ADVOB-10-1330';
894: l_header_tbl(n_trx_date_pos).value := TO_CHAR(dTransaction_date,'YYYYMMDD HH24MISS' );
895: ec_debug.pl ( 3, 'l_header_tbl(n_trx_date_pos).value: ',l_header_tbl(n_trx_date_pos).value );
896:
897: /*
898: **
899: ** Pass the PL/SQL table to the Code Cross Reference engine.

Line 925: ec_debug.pl ( 0,

921: INTO l_header_fkey
922: FROM sys.dual;
923: EXCEPTION
924: WHEN NO_DATA_FOUND THEN
925: ec_debug.pl ( 0,
926: 'EC',
927: 'ECE_GET_NEXT_SEQ_FAILED',
928: 'PROGRESS_LEVEL',
929: xProgress,

Line 934: ec_debug.pl ( 3, 'l_header_fkey: ',l_header_fkey );

930: 'SEQ',
931: 'ECE_ADVO_HEADERS_INTERFACE_S' );
932: END;
933:
934: ec_debug.pl ( 3, 'l_header_fkey: ',l_header_fkey );
935:
936: xProgress := 'ADVOB-10-1360';
937: ece_Extract_Utils_PUB.insert_into_interface_tbl ( iRun_id,
938: cTransaction_Type,

Line 1033: ec_debug.pl ( 0,

1029: INTO l_line_fkey
1030: FROM sys.dual;
1031: EXCEPTION
1032: WHEN NO_DATA_FOUND THEN
1033: ec_debug.pl ( 0,
1034: 'EC',
1035: 'ECE_GET_NEXT_SEQ_FAILED',
1036: 'PROGRESS_LEVEL',
1037: xProgress,

Line 1042: ec_debug.pl ( 3, 'l_line_fkey: ',l_line_fkey );

1038: 'SEQ',
1039: 'ECE_ADVO_DETAILS_INTERFACE_S' );
1040: END;
1041:
1042: ec_debug.pl ( 3, 'l_line_fkey: ',l_line_fkey );
1043:
1044: xProgress := 'ADVOB-10-1440';
1045: ece_Extract_Utils_PUB.insert_into_interface_tbl ( iRun_id,
1046: cTransaction_Type,

Line 1070: ec_debug.pl ( 0,

1066: xProgress := 'ADVOB-10-1443';
1067: IF ( dbms_sql.last_row_count = 0 )
1068: THEN
1069: v_LevelProcessed := 'DETAIL';
1070: ec_debug.pl ( 0,
1071: 'EC',
1072: 'ECE_NO_DB_ROW_PROCESSED',
1073: 'PROGRESS_LEVEL',
1074: xProgress,

Line 1087: ec_debug.pl ( 0,

1083: xProgress := 'ADVOB-10-1446';
1084: IF ( dbms_sql.last_row_count = 0 )
1085: THEN
1086: v_LevelProcessed := 'HEADER';
1087: ec_debug.pl ( 0,
1088: 'EC',
1089: 'ECE_NO_DB_ROW_PROCESSED',
1090: 'PROGRESS_LEVEL',
1091: xProgress,

Line 1110: ec_debug.pop('ece_advo_advice_pkg.Extract_From_Base_Apps' );

1106:
1107: xProgress := 'ADVOB-10-1460';
1108: dbms_sql.close_cursor(Line_sel_c );
1109:
1110: ec_debug.pop('ece_advo_advice_pkg.Extract_From_Base_Apps' );
1111:
1112: EXCEPTION
1113: WHEN OTHERS THEN
1114:

Line 1115: ec_debug.pl ( 0,

1111:
1112: EXCEPTION
1113: WHEN OTHERS THEN
1114:
1115: ec_debug.pl ( 0,
1116: 'EC',
1117: 'ECE_PROGRAM_ERROR',
1118: 'PROGRESS_LEVEL',
1119: xProgress );

Line 1121: ec_debug.pl ( 0,

1117: 'ECE_PROGRAM_ERROR',
1118: 'PROGRESS_LEVEL',
1119: xProgress );
1120:
1121: ec_debug.pl ( 0,
1122: 'EC',
1123: 'ECE_ERROR_MESSAGE',
1124: 'ERROR_MESSAGE',
1125: SQLERRM );

Line 1249: ec_debug.push ( 'ece_advo_advice_pkg.Put_Data_To_Output_Table' );

1245: ** Debug statements for the parameter values.
1246: **
1247: */
1248:
1249: ec_debug.push ( 'ece_advo_advice_pkg.Put_Data_To_Output_Table' );
1250: ec_debug.pl ( 3, 'cCommunication_Method: ', cCommunication_Method );
1251: ec_debug.pl ( 3, 'cTransaction_Type: ',cTransaction_Type );
1252: ec_debug.pl ( 3, 'iOutput_width: ',iOutput_width );
1253: ec_debug.pl ( 3, 'iRun_id: ',iRun_id );

Line 1250: ec_debug.pl ( 3, 'cCommunication_Method: ', cCommunication_Method );

1246: **
1247: */
1248:
1249: ec_debug.push ( 'ece_advo_advice_pkg.Put_Data_To_Output_Table' );
1250: ec_debug.pl ( 3, 'cCommunication_Method: ', cCommunication_Method );
1251: ec_debug.pl ( 3, 'cTransaction_Type: ',cTransaction_Type );
1252: ec_debug.pl ( 3, 'iOutput_width: ',iOutput_width );
1253: ec_debug.pl ( 3, 'iRun_id: ',iRun_id );
1254: ec_debug.pl ( 3, 'cHeader_Interface: ',cHeader_Interface );

Line 1251: ec_debug.pl ( 3, 'cTransaction_Type: ',cTransaction_Type );

1247: */
1248:
1249: ec_debug.push ( 'ece_advo_advice_pkg.Put_Data_To_Output_Table' );
1250: ec_debug.pl ( 3, 'cCommunication_Method: ', cCommunication_Method );
1251: ec_debug.pl ( 3, 'cTransaction_Type: ',cTransaction_Type );
1252: ec_debug.pl ( 3, 'iOutput_width: ',iOutput_width );
1253: ec_debug.pl ( 3, 'iRun_id: ',iRun_id );
1254: ec_debug.pl ( 3, 'cHeader_Interface: ',cHeader_Interface );
1255: ec_debug.pl ( 3, 'cLine_Interface: ',cLine_Interface );

Line 1252: ec_debug.pl ( 3, 'iOutput_width: ',iOutput_width );

1248:
1249: ec_debug.push ( 'ece_advo_advice_pkg.Put_Data_To_Output_Table' );
1250: ec_debug.pl ( 3, 'cCommunication_Method: ', cCommunication_Method );
1251: ec_debug.pl ( 3, 'cTransaction_Type: ',cTransaction_Type );
1252: ec_debug.pl ( 3, 'iOutput_width: ',iOutput_width );
1253: ec_debug.pl ( 3, 'iRun_id: ',iRun_id );
1254: ec_debug.pl ( 3, 'cHeader_Interface: ',cHeader_Interface );
1255: ec_debug.pl ( 3, 'cLine_Interface: ',cLine_Interface );
1256:

Line 1253: ec_debug.pl ( 3, 'iRun_id: ',iRun_id );

1249: ec_debug.push ( 'ece_advo_advice_pkg.Put_Data_To_Output_Table' );
1250: ec_debug.pl ( 3, 'cCommunication_Method: ', cCommunication_Method );
1251: ec_debug.pl ( 3, 'cTransaction_Type: ',cTransaction_Type );
1252: ec_debug.pl ( 3, 'iOutput_width: ',iOutput_width );
1253: ec_debug.pl ( 3, 'iRun_id: ',iRun_id );
1254: ec_debug.pl ( 3, 'cHeader_Interface: ',cHeader_Interface );
1255: ec_debug.pl ( 3, 'cLine_Interface: ',cLine_Interface );
1256:
1257:

Line 1254: ec_debug.pl ( 3, 'cHeader_Interface: ',cHeader_Interface );

1250: ec_debug.pl ( 3, 'cCommunication_Method: ', cCommunication_Method );
1251: ec_debug.pl ( 3, 'cTransaction_Type: ',cTransaction_Type );
1252: ec_debug.pl ( 3, 'iOutput_width: ',iOutput_width );
1253: ec_debug.pl ( 3, 'iRun_id: ',iRun_id );
1254: ec_debug.pl ( 3, 'cHeader_Interface: ',cHeader_Interface );
1255: ec_debug.pl ( 3, 'cLine_Interface: ',cLine_Interface );
1256:
1257:
1258:

Line 1255: ec_debug.pl ( 3, 'cLine_Interface: ',cLine_Interface );

1251: ec_debug.pl ( 3, 'cTransaction_Type: ',cTransaction_Type );
1252: ec_debug.pl ( 3, 'iOutput_width: ',iOutput_width );
1253: ec_debug.pl ( 3, 'iRun_id: ',iRun_id );
1254: ec_debug.pl ( 3, 'cHeader_Interface: ',cHeader_Interface );
1255: ec_debug.pl ( 3, 'cLine_Interface: ',cLine_Interface );
1256:
1257:
1258:
1259: /*

Line 1348: ec_debug.pl ( 3, 'cHeader_select: ',cHeader_select );

1344: cHeader_select := cHeader_select ||
1345: cHeader_from ||
1346: cHeader_where ||
1347: ' FOR UPDATE';
1348: ec_debug.pl ( 3, 'cHeader_select: ',cHeader_select );
1349:
1350: xProgress := 'ADVOB-20-1090';
1351: cLine_select := cLine_select ||
1352: cLine_from ||

Line 1355: ec_debug.pl ( 3, 'cLine_select: ',cLine_select );

1351: cLine_select := cLine_select ||
1352: cLine_from ||
1353: cLine_where ||
1354: ' FOR UPDATE';
1355: ec_debug.pl ( 3, 'cLine_select: ',cLine_select );
1356:
1357: xProgress := 'ADVOB-20-1100';
1358: cHeader_delete1 := 'DELETE FROM ' ||
1359: cHeader_Interface ||

Line 1361: ec_debug.pl ( 3, 'cHeader_delete1: ',cHeader_delete1 );

1357: xProgress := 'ADVOB-20-1100';
1358: cHeader_delete1 := 'DELETE FROM ' ||
1359: cHeader_Interface ||
1360: ' WHERE ROWID = :col_rowid';
1361: ec_debug.pl ( 3, 'cHeader_delete1: ',cHeader_delete1 );
1362:
1363: xProgress := 'ADVOB-20-1110';
1364: cLine_delete1 := 'DELETE FROM ' ||
1365: cLine_Interface ||

Line 1367: ec_debug.pl ( 3, 'cLine_delete1: ',cLine_delete1 );

1363: xProgress := 'ADVOB-20-1110';
1364: cLine_delete1 := 'DELETE FROM ' ||
1365: cLine_Interface ||
1366: ' WHERE ROWID = :col_rowid';
1367: ec_debug.pl ( 3, 'cLine_delete1: ',cLine_delete1 );
1368:
1369: xProgress := 'ADVOB-20-1120';
1370: cHeader_delete2 := 'DELETE FROM ' ||
1371: cHeader_X_Interface ||

Line 1373: ec_debug.pl ( 3, 'cHeader_delete2: ',cHeader_delete2 );

1369: xProgress := 'ADVOB-20-1120';
1370: cHeader_delete2 := 'DELETE FROM ' ||
1371: cHeader_X_Interface ||
1372: ' WHERE ROWID = :col_rowid';
1373: ec_debug.pl ( 3, 'cHeader_delete2: ',cHeader_delete2 );
1374:
1375: xProgress := 'ADVOB-20-1130';
1376: cLine_delete2 := 'DELETE FROM ' ||
1377: cLine_X_Interface ||

Line 1379: ec_debug.pl ( 3, 'cLine_delete2: ',cLine_delete2 );

1375: xProgress := 'ADVOB-20-1130';
1376: cLine_delete2 := 'DELETE FROM ' ||
1377: cLine_X_Interface ||
1378: ' WHERE ROWID = :col_rowid';
1379: ec_debug.pl ( 3, 'cLine_delete2: ',cLine_delete2 );
1380:
1381: /*
1382: **
1383: ** Open a cursor for each SELECT and DELETE call. This tells

Line 1494: ec_debug.pl ( 3, 'iHeader_count: ',iHeader_count );

1490: */
1491:
1492: xProgress := 'ADVOB-20-1260';
1493: iHeader_count := l_header_tbl.count;
1494: ec_debug.pl ( 3, 'iHeader_count: ',iHeader_count );
1495:
1496: xProgress := 'ADVOB-20-1270';
1497: iLine_count := l_line_tbl.count;
1498: ec_debug.pl ( 3, 'iLine_count: ',iLine_count );

Line 1498: ec_debug.pl ( 3, 'iLine_count: ',iLine_count );

1494: ec_debug.pl ( 3, 'iHeader_count: ',iHeader_count );
1495:
1496: xProgress := 'ADVOB-20-1270';
1497: iLine_count := l_line_tbl.count;
1498: ec_debug.pl ( 3, 'iLine_count: ',iLine_count );
1499:
1500: /*
1501: **
1502: ** Define the data type for every column in the Header

Line 1579: ec_debug.pl ( 3, 'nTrans_code_pos: ',nTrans_code_pos );

1575: xProgress := 'ADVOB-20-1340';
1576: ece_flatfile_pvt.Find_pos ( l_header_tbl,
1577: ece_flatfile_pvt.G_Translator_Code,
1578: nTrans_code_pos );
1579: ec_debug.pl ( 3, 'nTrans_code_pos: ',nTrans_code_pos );
1580:
1581: xProgress := 'ADVOB-20-1350';
1582: ece_flatfile_pvt.Find_pos ( l_header_tbl,
1583: c_header_common_key_name,

Line 1585: ec_debug.pl ( 3, 'nHeader_key_pos: ',nHeader_key_pos );

1581: xProgress := 'ADVOB-20-1350';
1582: ece_flatfile_pvt.Find_pos ( l_header_tbl,
1583: c_header_common_key_name,
1584: nHeader_key_pos );
1585: ec_debug.pl ( 3, 'nHeader_key_pos: ',nHeader_key_pos );
1586:
1587: xProgress := 'ADVOB-20-1360';
1588: ece_flatfile_pvt.Find_pos ( l_header_tbl,
1589: 'ADVICE_HEADER_ID',

Line 1591: ec_debug.pl ( 3, 'n_advice_header_id_pos: ',n_advice_header_id_pos );

1587: xProgress := 'ADVOB-20-1360';
1588: ece_flatfile_pvt.Find_pos ( l_header_tbl,
1589: 'ADVICE_HEADER_ID',
1590: n_advice_header_id_pos );
1591: ec_debug.pl ( 3, 'n_advice_header_id_pos: ',n_advice_header_id_pos );
1592:
1593:
1594: xProgress := 'ADVOB-20-1370';
1595: ece_flatfile_pvt.Find_pos ( l_line_tbl,

Line 1598: ec_debug.pl ( 3, 'nLine_key_pos: ',nLine_key_pos );

1594: xProgress := 'ADVOB-20-1370';
1595: ece_flatfile_pvt.Find_pos ( l_line_tbl,
1596: c_line_common_key_name,
1597: nLine_key_pos );
1598: ec_debug.pl ( 3, 'nLine_key_pos: ',nLine_key_pos );
1599:
1600: xProgress := 'ADVOB-20-1371';
1601: dbms_sql.bind_variable ( Header_sel_c,
1602: 'l_iRun_id',

Line 1673: ec_debug.pl ( 3, 'c_file_common_key: ',c_file_common_key );

1669: ' '),
1670: 22) ||
1671: c_key_3 ||
1672: c_key_3;
1673: ec_debug.pl ( 3, 'c_file_common_key: ',c_file_common_key );
1674:
1675: /*
1676: **
1677: ** Write the record to the output table.

Line 1773: ec_debug.pl ( 3, 'c_file_common_key: ',c_file_common_key );

1769: RPAD(NVL(SUBSTRB(l_line_tbl(nLine_key_pos).value, 1, 22),
1770: ' '),
1771: 22) ||
1772: c_key_3;
1773: ec_debug.pl ( 3, 'c_file_common_key: ',c_file_common_key );
1774:
1775: /*
1776: **
1777: ** Write the record to the output table.

Line 1824: ec_debug.pl ( 0,

1820: xProgress := 'ADVOB-20-1575';
1821: IF ( dbms_sql.last_row_count = 0 )
1822: THEN
1823: v_LevelProcessed := 'LINE';
1824: ec_debug.pl ( 0,
1825: 'EC',
1826: 'ECE_NO_DB_ROW_PROCESSED',
1827: 'PROGRESS_LEVEL',
1828: xProgress,

Line 1870: ec_debug.pl ( 0,

1866: xProgress := 'ADVOB-20-1615';
1867: IF ( dbms_sql.last_row_count = 0 )
1868: THEN
1869: v_LevelProcessed := 'HEADER';
1870: ec_debug.pl ( 0,
1871: 'EC',
1872: 'ECE_NO_DB_ROW_PROCESSED',
1873: 'PROGRESS_LEVEL',
1874: xProgress,

Line 1899: ec_debug.pop ( 'ece_advo_advice_pkg.Put_Data_To_Output_Table' );

1895:
1896: xProgress := 'ADVOB-20-1650';
1897: dbms_sql.close_cursor ( Line_del_c1 );
1898:
1899: ec_debug.pop ( 'ece_advo_advice_pkg.Put_Data_To_Output_Table' );
1900:
1901: EXCEPTION
1902: WHEN OTHERS THEN
1903:

Line 1904: ec_debug.pl ( 0,

1900:
1901: EXCEPTION
1902: WHEN OTHERS THEN
1903:
1904: ec_debug.pl ( 0,
1905: 'EC',
1906: 'ECE_PROGRAM_ERROR',
1907: 'PROGRESS_LEVEL',
1908: xProgress );

Line 1910: ec_debug.pl ( 0,

1906: 'ECE_PROGRAM_ERROR',
1907: 'PROGRESS_LEVEL',
1908: xProgress );
1909:
1910: ec_debug.pl ( 0,
1911: 'EC',
1912: 'ECE_ERROR_MESSAGE',
1913: 'ERROR_MESSAGE',
1914: SQLERRM );