DBA Data[Home] [Help]

APPS.ECE_SPSO_TRANS1 dependencies on EC_DEBUG

Line 46: ec_debug.enable_debug(v_debug_mode);

42: ORDER BY line_id;
43:
44: BEGIN
45:
46: ec_debug.enable_debug(v_debug_mode);
47: ec_debug.push ( 'ECE_SPSO_Trans1.Extract_SPSO_Outbound' );
48: ec_debug.pl ( 3, 'cOutput_Path: ',cOutput_Path );
49: ec_debug.pl ( 3, 'cOutput_Filename: ',cOutput_Filename );
50: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );

Line 47: ec_debug.push ( 'ECE_SPSO_Trans1.Extract_SPSO_Outbound' );

43:
44: BEGIN
45:
46: ec_debug.enable_debug(v_debug_mode);
47: ec_debug.push ( 'ECE_SPSO_Trans1.Extract_SPSO_Outbound' );
48: ec_debug.pl ( 3, 'cOutput_Path: ',cOutput_Path );
49: ec_debug.pl ( 3, 'cOutput_Filename: ',cOutput_Filename );
50: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );
51: ec_debug.pl ( 3, 'v_debug_mode: ',v_debug_mode );

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

44: BEGIN
45:
46: ec_debug.enable_debug(v_debug_mode);
47: ec_debug.push ( 'ECE_SPSO_Trans1.Extract_SPSO_Outbound' );
48: ec_debug.pl ( 3, 'cOutput_Path: ',cOutput_Path );
49: ec_debug.pl ( 3, 'cOutput_Filename: ',cOutput_Filename );
50: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );
51: ec_debug.pl ( 3, 'v_debug_mode: ',v_debug_mode );
52: ec_debug.pl(3,'p_batch_id: ',p_batch_id);

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

45:
46: ec_debug.enable_debug(v_debug_mode);
47: ec_debug.push ( 'ECE_SPSO_Trans1.Extract_SPSO_Outbound' );
48: ec_debug.pl ( 3, 'cOutput_Path: ',cOutput_Path );
49: ec_debug.pl ( 3, 'cOutput_Filename: ',cOutput_Filename );
50: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );
51: ec_debug.pl ( 3, 'v_debug_mode: ',v_debug_mode );
52: ec_debug.pl(3,'p_batch_id: ',p_batch_id);
53: /* Check to see if the transaction is enabled. If not, abort */

Line 50: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );

46: ec_debug.enable_debug(v_debug_mode);
47: ec_debug.push ( 'ECE_SPSO_Trans1.Extract_SPSO_Outbound' );
48: ec_debug.pl ( 3, 'cOutput_Path: ',cOutput_Path );
49: ec_debug.pl ( 3, 'cOutput_Filename: ',cOutput_Filename );
50: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );
51: ec_debug.pl ( 3, 'v_debug_mode: ',v_debug_mode );
52: ec_debug.pl(3,'p_batch_id: ',p_batch_id);
53: /* Check to see if the transaction is enabled. If not, abort */
54: xProgress := 'SPSO-10-1001';

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

47: ec_debug.push ( 'ECE_SPSO_Trans1.Extract_SPSO_Outbound' );
48: ec_debug.pl ( 3, 'cOutput_Path: ',cOutput_Path );
49: ec_debug.pl ( 3, 'cOutput_Filename: ',cOutput_Filename );
50: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );
51: ec_debug.pl ( 3, 'v_debug_mode: ',v_debug_mode );
52: ec_debug.pl(3,'p_batch_id: ',p_batch_id);
53: /* Check to see if the transaction is enabled. If not, abort */
54: xProgress := 'SPSO-10-1001';
55: fnd_profile.get('ECE_' || p_Transaction_Type || '_ENABLED',cEnabled);

Line 52: ec_debug.pl(3,'p_batch_id: ',p_batch_id);

48: ec_debug.pl ( 3, 'cOutput_Path: ',cOutput_Path );
49: ec_debug.pl ( 3, 'cOutput_Filename: ',cOutput_Filename );
50: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );
51: ec_debug.pl ( 3, 'v_debug_mode: ',v_debug_mode );
52: ec_debug.pl(3,'p_batch_id: ',p_batch_id);
53: /* Check to see if the transaction is enabled. If not, abort */
54: xProgress := 'SPSO-10-1001';
55: fnd_profile.get('ECE_' || p_Transaction_Type || '_ENABLED',cEnabled);
56:

Line 70: ec_debug.pl ( 0,

66: INTO p_run_id
67: FROM sys.dual;
68: EXCEPTION
69: WHEN NO_DATA_FOUND THEN
70: ec_debug.pl ( 0,
71: 'EC',
72: 'ECE_GET_NEXT_SEQ_FAILED',
73: 'PROGRESS_LEVEL',
74: xProgress,

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

74: xProgress,
75: 'SEQ',
76: 'ECE_OUTPUT_RUNS_S' );
77: END;
78: ec_debug.pl ( 3, 'p_run_id: ',p_run_id );
79:
80: xProgress := 'SPSO-10-1010';
81: ec_debug.pl ( 0, 'EC', 'ECE_SPSO_START', NULL );
82:

Line 81: ec_debug.pl ( 0, 'EC', 'ECE_SPSO_START', NULL );

77: END;
78: ec_debug.pl ( 3, 'p_run_id: ',p_run_id );
79:
80: xProgress := 'SPSO-10-1010';
81: ec_debug.pl ( 0, 'EC', 'ECE_SPSO_START', NULL );
82:
83: xProgress := 'SPSO-10-1020';
84: ec_debug.pl ( 0, 'EC', 'ECE_RUN_ID', 'RUN_ID', p_run_id );
85:

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

80: xProgress := 'SPSO-10-1010';
81: ec_debug.pl ( 0, 'EC', 'ECE_SPSO_START', NULL );
82:
83: xProgress := 'SPSO-10-1020';
84: ec_debug.pl ( 0, 'EC', 'ECE_RUN_ID', 'RUN_ID', p_run_id );
85:
86: xProgress := 'SPSO-10-1030';
87: ece_spso_trans1.populate_supplier_sched_api1 ( p_communication_method,
88: p_transaction_type,

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

143: -- Write the data from ece_output to the output file.
144:
145: xProgress := 'SPSO-10-1090';
146: utl_file.put_line ( uFile_type,l_line_text );
147: ec_debug.pl ( 3, 'l_line_text: ',l_line_text );
148:
149: END LOOP;
150:
151: CLOSE c_output;

Line 161: ec_debug.pl ( 0, 'EC', 'ECE_SPSO_COMPLETE ',NULL );

157: utl_file.fclose ( uFile_type );
158: end if;
159:
160: xProgress := 'SPSO-10-1110';
161: ec_debug.pl ( 0, 'EC', 'ECE_SPSO_COMPLETE ',NULL );
162:
163: -- Assume everything went ok so delete the records from ece_output.
164:
165: xProgress := 'SPSO-10-1120';

Line 172: ec_debug.pl ( 0,

168: WHERE run_id = p_run_id;
169:
170: IF SQL%NOTFOUND
171: THEN
172: ec_debug.pl ( 0,
173: 'EC',
174: 'ECE_NO_ROW_PROCESSED',
175: 'PROGRESS_LEVEL',
176: xProgress,

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

178: 'ECE_OUTPUT' );
179: END IF;
180:
181: IF ec_mapping_utils.ec_get_trans_upgrade_status(p_transaction_type) = 'U' THEN
182: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);
183: retcode := 1;
184: END IF;
185:
186: ec_debug.pop ( 'ECE_SPSO_Trans1.Extract_SPSO_Outbound' );

Line 186: ec_debug.pop ( 'ECE_SPSO_Trans1.Extract_SPSO_Outbound' );

182: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);
183: retcode := 1;
184: END IF;
185:
186: ec_debug.pop ( 'ECE_SPSO_Trans1.Extract_SPSO_Outbound' );
187: ec_debug.disable_debug;
188: COMMIT;
189:
190: EXCEPTION

Line 187: ec_debug.disable_debug;

183: retcode := 1;
184: END IF;
185:
186: ec_debug.pop ( 'ECE_SPSO_Trans1.Extract_SPSO_Outbound' );
187: ec_debug.disable_debug;
188: COMMIT;
189:
190: EXCEPTION
191: WHEN ece_transaction_disabled THEN

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

188: COMMIT;
189:
190: EXCEPTION
191: WHEN ece_transaction_disabled THEN
192: ec_debug.pl(0,'EC','ECE_TRANSACTION_DISABLED','TRANSACTION',p_Transaction_type);
193: retcode := 1;
194: ec_debug.disable_debug;
195: ROLLBACK;
196:

Line 194: ec_debug.disable_debug;

190: EXCEPTION
191: WHEN ece_transaction_disabled THEN
192: ec_debug.pl(0,'EC','ECE_TRANSACTION_DISABLED','TRANSACTION',p_Transaction_type);
193: retcode := 1;
194: ec_debug.disable_debug;
195: ROLLBACK;
196:
197: WHEN utl_file.write_error THEN
198:

Line 199: ec_debug.pl ( 0,

195: ROLLBACK;
196:
197: WHEN utl_file.write_error THEN
198:
199: ec_debug.pl ( 0,
200: 'EC',
201: 'ECE_UTL_WRITE_ERROR',
202: NULL );
203:

Line 204: ec_debug.pl ( 0,

200: 'EC',
201: 'ECE_UTL_WRITE_ERROR',
202: NULL );
203:
204: ec_debug.pl ( 0,
205: 'EC',
206: 'ECE_ERROR_MESSAGE',
207: 'ERROR_MESSAGE',
208: SQLERRM );

Line 211: ec_debug.disable_debug;

207: 'ERROR_MESSAGE',
208: SQLERRM );
209:
210: retcode := 2;
211: ec_debug.disable_debug;
212: ROLLBACK;
213: RAISE;
214:
215: WHEN utl_file.invalid_path THEN

Line 217: ec_debug.pl ( 0,

213: RAISE;
214:
215: WHEN utl_file.invalid_path THEN
216:
217: ec_debug.pl ( 0,
218: 'EC',
219: 'ECE_UTIL_INVALID_PATH',
220: NULL );
221:

Line 222: ec_debug.pl ( 0,

218: 'EC',
219: 'ECE_UTIL_INVALID_PATH',
220: NULL );
221:
222: ec_debug.pl ( 0,
223: 'EC',
224: 'ECE_ERROR_MESSAGE',
225: 'ERROR_MESSAGE',
226: SQLERRM );

Line 229: ec_debug.disable_debug;

225: 'ERROR_MESSAGE',
226: SQLERRM );
227:
228: retcode := 2;
229: ec_debug.disable_debug;
230: ROLLBACK;
231: RAISE;
232:
233: WHEN utl_file.invalid_operation THEN

Line 235: ec_debug.pl ( 0,

231: RAISE;
232:
233: WHEN utl_file.invalid_operation THEN
234:
235: ec_debug.pl ( 0,
236: 'EC',
237: 'ECE_UTIL_INVALID_OPERATION',
238: NULL );
239:

Line 240: ec_debug.pl ( 0,

236: 'EC',
237: 'ECE_UTIL_INVALID_OPERATION',
238: NULL );
239:
240: ec_debug.pl ( 0,
241: 'EC',
242: 'ECE_ERROR_MESSAGE',
243: 'ERROR_MESSAGE',
244: SQLERRM );

Line 247: ec_debug.disable_debug;

243: 'ERROR_MESSAGE',
244: SQLERRM );
245:
246: retcode := 2;
247: ec_debug.disable_debug;
248: ROLLBACK;
249: RAISE;
250:
251: WHEN OTHERS THEN

Line 253: ec_debug.pl ( 0,

249: RAISE;
250:
251: WHEN OTHERS THEN
252:
253: ec_debug.pl ( 0,
254: 'EC',
255: 'ECE_PROGRAM_ERROR',
256: 'PROGRESS_LEVEL',
257: xProgress );

Line 259: ec_debug.pl ( 0,

255: 'ECE_PROGRAM_ERROR',
256: 'PROGRESS_LEVEL',
257: xProgress );
258:
259: ec_debug.pl ( 0,
260: 'EC',
261: 'ECE_ERROR_MESSAGE',
262: 'ERROR_MESSAGE',
263: SQLERRM );

Line 266: ec_debug.disable_debug;

262: 'ERROR_MESSAGE',
263: SQLERRM );
264:
265: retcode := 2;
266: ec_debug.disable_debug;
267: ROLLBACK;
268: RAISE;
269:
270: END Extract_SPSO_Outbound;

Line 315: ec_debug.enable_debug(v_debug_mode);

311: ORDER BY line_id;
312:
313: BEGIN
314:
315: ec_debug.enable_debug(v_debug_mode);
316: ec_debug.push ( 'ECE_SPSO_Trans1.Extract_SSSO_Outbound' );
317: ec_debug.pl ( 3, 'cOutput_Path: ',cOutput_Path );
318: ec_debug.pl ( 3, 'cOutput_Filename: ',cOutput_Filename );
319: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );

Line 316: ec_debug.push ( 'ECE_SPSO_Trans1.Extract_SSSO_Outbound' );

312:
313: BEGIN
314:
315: ec_debug.enable_debug(v_debug_mode);
316: ec_debug.push ( 'ECE_SPSO_Trans1.Extract_SSSO_Outbound' );
317: ec_debug.pl ( 3, 'cOutput_Path: ',cOutput_Path );
318: ec_debug.pl ( 3, 'cOutput_Filename: ',cOutput_Filename );
319: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );
320: ec_debug.pl ( 3, 'v_debug_mode: ',v_debug_mode );

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

313: BEGIN
314:
315: ec_debug.enable_debug(v_debug_mode);
316: ec_debug.push ( 'ECE_SPSO_Trans1.Extract_SSSO_Outbound' );
317: ec_debug.pl ( 3, 'cOutput_Path: ',cOutput_Path );
318: ec_debug.pl ( 3, 'cOutput_Filename: ',cOutput_Filename );
319: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );
320: ec_debug.pl ( 3, 'v_debug_mode: ',v_debug_mode );
321: ec_debug.pl ( 3, 'p_batch_id ',p_batch_id );

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

314:
315: ec_debug.enable_debug(v_debug_mode);
316: ec_debug.push ( 'ECE_SPSO_Trans1.Extract_SSSO_Outbound' );
317: ec_debug.pl ( 3, 'cOutput_Path: ',cOutput_Path );
318: ec_debug.pl ( 3, 'cOutput_Filename: ',cOutput_Filename );
319: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );
320: ec_debug.pl ( 3, 'v_debug_mode: ',v_debug_mode );
321: ec_debug.pl ( 3, 'p_batch_id ',p_batch_id );
322:

Line 319: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );

315: ec_debug.enable_debug(v_debug_mode);
316: ec_debug.push ( 'ECE_SPSO_Trans1.Extract_SSSO_Outbound' );
317: ec_debug.pl ( 3, 'cOutput_Path: ',cOutput_Path );
318: ec_debug.pl ( 3, 'cOutput_Filename: ',cOutput_Filename );
319: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );
320: ec_debug.pl ( 3, 'v_debug_mode: ',v_debug_mode );
321: ec_debug.pl ( 3, 'p_batch_id ',p_batch_id );
322:
323: /* Check to see if the transaction is enabled. If not, abort */

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

316: ec_debug.push ( 'ECE_SPSO_Trans1.Extract_SSSO_Outbound' );
317: ec_debug.pl ( 3, 'cOutput_Path: ',cOutput_Path );
318: ec_debug.pl ( 3, 'cOutput_Filename: ',cOutput_Filename );
319: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );
320: ec_debug.pl ( 3, 'v_debug_mode: ',v_debug_mode );
321: ec_debug.pl ( 3, 'p_batch_id ',p_batch_id );
322:
323: /* Check to see if the transaction is enabled. If not, abort */
324: xProgress := 'SSSO-10-1001';

Line 321: ec_debug.pl ( 3, 'p_batch_id ',p_batch_id );

317: ec_debug.pl ( 3, 'cOutput_Path: ',cOutput_Path );
318: ec_debug.pl ( 3, 'cOutput_Filename: ',cOutput_Filename );
319: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );
320: ec_debug.pl ( 3, 'v_debug_mode: ',v_debug_mode );
321: ec_debug.pl ( 3, 'p_batch_id ',p_batch_id );
322:
323: /* Check to see if the transaction is enabled. If not, abort */
324: xProgress := 'SSSO-10-1001';
325: fnd_profile.get('ECE_' || p_Transaction_Type || '_ENABLED',cEnabled);

Line 340: ec_debug.pl ( 0,

336: INTO p_run_id
337: FROM sys.dual;
338: EXCEPTION
339: WHEN NO_DATA_FOUND THEN
340: ec_debug.pl ( 0,
341: 'EC',
342: 'ECE_GET_NEXT_SEQ_FAILED',
343: 'PROGRESS_LEVEL',
344: xProgress,

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

344: xProgress,
345: 'SEQ',
346: 'ECE_OUTPUT_RUNS_S' );
347: END;
348: ec_debug.pl(3, 'p_run_id: ',p_run_id);
349:
350: xProgress := 'SSSO-10-1010';
351: ec_debug.pl ( 0, 'EC', 'ECE_SSSO_START', NULL );
352:

Line 351: ec_debug.pl ( 0, 'EC', 'ECE_SSSO_START', NULL );

347: END;
348: ec_debug.pl(3, 'p_run_id: ',p_run_id);
349:
350: xProgress := 'SSSO-10-1010';
351: ec_debug.pl ( 0, 'EC', 'ECE_SSSO_START', NULL );
352:
353: xProgress := 'SSSO-10-1020';
354: ec_debug.pl ( 0, 'EC', 'ECE_RUN_ID', 'RUN_ID', p_run_id );
355:

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

350: xProgress := 'SSSO-10-1010';
351: ec_debug.pl ( 0, 'EC', 'ECE_SSSO_START', NULL );
352:
353: xProgress := 'SSSO-10-1020';
354: ec_debug.pl ( 0, 'EC', 'ECE_RUN_ID', 'RUN_ID', p_run_id );
355:
356: xProgress := 'SSSO-10-1030';
357: ece_spso_trans1.populate_supplier_sched_api1 ( p_communication_method,
358: p_transaction_type,

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

413:
414: xProgress := 'SSSO-10-1090';
415: utl_file.put_line ( uFile_type,
416: l_line_text );
417: ec_debug.pl ( 3, 'l_line_text: ',l_line_text );
418:
419: END LOOP;
420:
421: CLOSE c_output;

Line 431: ec_debug.pl ( 0, 'EC', 'ECE_SSSO_COMPLETE', NULL );

427: utl_file.fclose ( uFile_type );
428: end if;
429:
430: xProgress := 'SSSO-10-1110';
431: ec_debug.pl ( 0, 'EC', 'ECE_SSSO_COMPLETE', NULL );
432:
433: -- Assume everything went ok so delete the records from ece_output.
434:
435: xProgress := 'SSSO-10-1120';

Line 442: ec_debug.pl ( 0,

438: WHERE run_id = p_run_id;
439:
440: IF SQL%NOTFOUND
441: THEN
442: ec_debug.pl ( 0,
443: 'EC',
444: 'ECE_NO_ROW_PROCESSED',
445: 'PROGRESS_LEVEL',
446: xProgress,

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

449: END IF;
450:
451:
452: IF ec_mapping_utils.ec_get_trans_upgrade_status(p_transaction_type) = 'U' THEN
453: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);
454: retcode := 1;
455: END IF;
456:
457: ec_debug.pop ( 'ECE_SPSO_Trans1.Extract_SSSO_Outbound' );

Line 457: ec_debug.pop ( 'ECE_SPSO_Trans1.Extract_SSSO_Outbound' );

453: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);
454: retcode := 1;
455: END IF;
456:
457: ec_debug.pop ( 'ECE_SPSO_Trans1.Extract_SSSO_Outbound' );
458: ec_debug.disable_debug;
459: COMMIT;
460:
461: EXCEPTION

Line 458: ec_debug.disable_debug;

454: retcode := 1;
455: END IF;
456:
457: ec_debug.pop ( 'ECE_SPSO_Trans1.Extract_SSSO_Outbound' );
458: ec_debug.disable_debug;
459: COMMIT;
460:
461: EXCEPTION
462: WHEN ece_transaction_disabled THEN

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

459: COMMIT;
460:
461: EXCEPTION
462: WHEN ece_transaction_disabled THEN
463: ec_debug.pl(0,'EC','ECE_TRANSACTION_DISABLED','TRANSACTION',p_Transaction_type);
464: retcode := 1;
465: ec_debug.disable_debug;
466: ROLLBACK;
467:

Line 465: ec_debug.disable_debug;

461: EXCEPTION
462: WHEN ece_transaction_disabled THEN
463: ec_debug.pl(0,'EC','ECE_TRANSACTION_DISABLED','TRANSACTION',p_Transaction_type);
464: retcode := 1;
465: ec_debug.disable_debug;
466: ROLLBACK;
467:
468: WHEN utl_file.write_error THEN
469:

Line 470: ec_debug.pl ( 0,

466: ROLLBACK;
467:
468: WHEN utl_file.write_error THEN
469:
470: ec_debug.pl ( 0,
471: 'EC',
472: 'ECE_UTL_WRITE_ERROR',
473: NULL );
474:

Line 476: ec_debug.pl ( 0,

472: 'ECE_UTL_WRITE_ERROR',
473: NULL );
474:
475:
476: ec_debug.pl ( 0,
477: 'EC',
478: 'ECE_ERROR_MESSAGE',
479: 'ERROR_MESSAGE',
480: SQLERRM );

Line 483: ec_debug.disable_debug;

479: 'ERROR_MESSAGE',
480: SQLERRM );
481:
482: retcode := 2;
483: ec_debug.disable_debug;
484: ROLLBACK;
485: RAISE;
486:
487: WHEN utl_file.invalid_path THEN

Line 489: ec_debug.pl ( 0,

485: RAISE;
486:
487: WHEN utl_file.invalid_path THEN
488:
489: ec_debug.pl ( 0,
490: 'EC',
491: 'ECE_UTIL_INVALID_PATH',
492: NULL );
493:

Line 494: ec_debug.pl ( 0,

490: 'EC',
491: 'ECE_UTIL_INVALID_PATH',
492: NULL );
493:
494: ec_debug.pl ( 0,
495: 'EC',
496: 'ECE_ERROR_MESSAGE',
497: 'ERROR_MESSAGE',
498: SQLERRM );

Line 501: ec_debug.disable_debug;

497: 'ERROR_MESSAGE',
498: SQLERRM );
499:
500: retcode := 2;
501: ec_debug.disable_debug;
502: ROLLBACK;
503: RAISE;
504:
505: WHEN utl_file.invalid_operation THEN

Line 507: ec_debug.pl ( 0,

503: RAISE;
504:
505: WHEN utl_file.invalid_operation THEN
506:
507: ec_debug.pl ( 0,
508: 'EC', '
509: ECE_UTIL_INVALID_OPERATION',
510: NULL );
511:

Line 512: ec_debug.pl ( 0,

508: 'EC', '
509: ECE_UTIL_INVALID_OPERATION',
510: NULL );
511:
512: ec_debug.pl ( 0,
513: 'EC',
514: 'ECE_ERROR_MESSAGE',
515: 'ERROR_MESSAGE',
516: SQLERRM );

Line 519: ec_debug.disable_debug;

515: 'ERROR_MESSAGE',
516: SQLERRM );
517:
518: retcode := 2;
519: ec_debug.disable_debug;
520: ROLLBACK;
521: RAISE;
522:
523: WHEN others then

Line 525: ec_debug.pl ( 0,

521: RAISE;
522:
523: WHEN others then
524:
525: ec_debug.pl ( 0,
526: 'EC',
527: 'ECE_PROGRAM_ERROR',
528: 'PROGRESS_LEVEL',
529: xProgress );

Line 531: ec_debug.pl ( 0,

527: 'ECE_PROGRAM_ERROR',
528: 'PROGRESS_LEVEL',
529: xProgress );
530:
531: ec_debug.pl ( 0,
532: 'EC',
533: 'ECE_ERROR_MESSAGE',
534: 'ERROR_MESSAGE',
535: SQLERRM );

Line 538: ec_debug.disable_debug;

534: 'ERROR_MESSAGE',
535: SQLERRM );
536:
537: retcode := 2;
538: ec_debug.disable_debug;
539: ROLLBACK;
540: RAISE;
541:
542: END Extract_SSSO_Outbound;

Line 730: ec_debug.push ( 'ece_spso_trans1.Populate_Supplier_Sched_API1' );

726: d_dummy_date DATE;
727: g_item_id NUMBER;
728: BEGIN
729:
730: ec_debug.push ( 'ece_spso_trans1.Populate_Supplier_Sched_API1' );
731: ec_debug.pl ( 3, 'cCommunication_Method: ', cCommunication_Method );
732: ec_debug.pl ( 3, 'cTransaction_Type: ',cTransaction_Type );
733: ec_debug.pl ( 3, 'dTransaction_date: ',dTransaction_date );
734: ec_debug.pl ( 3, 'iRun_id: ',iRun_id );

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

727: g_item_id NUMBER;
728: BEGIN
729:
730: ec_debug.push ( 'ece_spso_trans1.Populate_Supplier_Sched_API1' );
731: ec_debug.pl ( 3, 'cCommunication_Method: ', cCommunication_Method );
732: ec_debug.pl ( 3, 'cTransaction_Type: ',cTransaction_Type );
733: ec_debug.pl ( 3, 'dTransaction_date: ',dTransaction_date );
734: ec_debug.pl ( 3, 'iRun_id: ',iRun_id );
735: ec_debug.pl ( 3, 'p_document_type: ',p_document_type );

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

728: BEGIN
729:
730: ec_debug.push ( 'ece_spso_trans1.Populate_Supplier_Sched_API1' );
731: ec_debug.pl ( 3, 'cCommunication_Method: ', cCommunication_Method );
732: ec_debug.pl ( 3, 'cTransaction_Type: ',cTransaction_Type );
733: ec_debug.pl ( 3, 'dTransaction_date: ',dTransaction_date );
734: ec_debug.pl ( 3, 'iRun_id: ',iRun_id );
735: ec_debug.pl ( 3, 'p_document_type: ',p_document_type );
736: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );

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

729:
730: ec_debug.push ( 'ece_spso_trans1.Populate_Supplier_Sched_API1' );
731: ec_debug.pl ( 3, 'cCommunication_Method: ', cCommunication_Method );
732: ec_debug.pl ( 3, 'cTransaction_Type: ',cTransaction_Type );
733: ec_debug.pl ( 3, 'dTransaction_date: ',dTransaction_date );
734: ec_debug.pl ( 3, 'iRun_id: ',iRun_id );
735: ec_debug.pl ( 3, 'p_document_type: ',p_document_type );
736: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );
737: ec_debug.pl ( 3, 'cHeader_Interface: ',cHeader_Interface );

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

730: ec_debug.push ( 'ece_spso_trans1.Populate_Supplier_Sched_API1' );
731: ec_debug.pl ( 3, 'cCommunication_Method: ', cCommunication_Method );
732: ec_debug.pl ( 3, 'cTransaction_Type: ',cTransaction_Type );
733: ec_debug.pl ( 3, 'dTransaction_date: ',dTransaction_date );
734: ec_debug.pl ( 3, 'iRun_id: ',iRun_id );
735: ec_debug.pl ( 3, 'p_document_type: ',p_document_type );
736: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );
737: ec_debug.pl ( 3, 'cHeader_Interface: ',cHeader_Interface );
738: ec_debug.pl ( 3, 'cItem_Interface: ',cItem_Interface );

Line 735: ec_debug.pl ( 3, 'p_document_type: ',p_document_type );

731: ec_debug.pl ( 3, 'cCommunication_Method: ', cCommunication_Method );
732: ec_debug.pl ( 3, 'cTransaction_Type: ',cTransaction_Type );
733: ec_debug.pl ( 3, 'dTransaction_date: ',dTransaction_date );
734: ec_debug.pl ( 3, 'iRun_id: ',iRun_id );
735: ec_debug.pl ( 3, 'p_document_type: ',p_document_type );
736: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );
737: ec_debug.pl ( 3, 'cHeader_Interface: ',cHeader_Interface );
738: ec_debug.pl ( 3, 'cItem_Interface: ',cItem_Interface );
739: ec_debug.pl ( 3, 'cItem_D_Interface: ',cItem_D_Interface );

Line 736: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );

732: ec_debug.pl ( 3, 'cTransaction_Type: ',cTransaction_Type );
733: ec_debug.pl ( 3, 'dTransaction_date: ',dTransaction_date );
734: ec_debug.pl ( 3, 'iRun_id: ',iRun_id );
735: ec_debug.pl ( 3, 'p_document_type: ',p_document_type );
736: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );
737: ec_debug.pl ( 3, 'cHeader_Interface: ',cHeader_Interface );
738: ec_debug.pl ( 3, 'cItem_Interface: ',cItem_Interface );
739: ec_debug.pl ( 3, 'cItem_D_Interface: ',cItem_D_Interface );
740:

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

733: ec_debug.pl ( 3, 'dTransaction_date: ',dTransaction_date );
734: ec_debug.pl ( 3, 'iRun_id: ',iRun_id );
735: ec_debug.pl ( 3, 'p_document_type: ',p_document_type );
736: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );
737: ec_debug.pl ( 3, 'cHeader_Interface: ',cHeader_Interface );
738: ec_debug.pl ( 3, 'cItem_Interface: ',cItem_Interface );
739: ec_debug.pl ( 3, 'cItem_D_Interface: ',cItem_D_Interface );
740:
741: -- Retreive the system profile option ECE_OUT_FILE_PATH. This will

Line 738: ec_debug.pl ( 3, 'cItem_Interface: ',cItem_Interface );

734: ec_debug.pl ( 3, 'iRun_id: ',iRun_id );
735: ec_debug.pl ( 3, 'p_document_type: ',p_document_type );
736: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );
737: ec_debug.pl ( 3, 'cHeader_Interface: ',cHeader_Interface );
738: ec_debug.pl ( 3, 'cItem_Interface: ',cItem_Interface );
739: ec_debug.pl ( 3, 'cItem_D_Interface: ',cItem_D_Interface );
740:
741: -- Retreive the system profile option ECE_OUT_FILE_PATH. This will
742: -- be the directory where the output file will be written.

Line 739: ec_debug.pl ( 3, 'cItem_D_Interface: ',cItem_D_Interface );

735: ec_debug.pl ( 3, 'p_document_type: ',p_document_type );
736: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );
737: ec_debug.pl ( 3, 'cHeader_Interface: ',cHeader_Interface );
738: ec_debug.pl ( 3, 'cItem_Interface: ',cItem_Interface );
739: ec_debug.pl ( 3, 'cItem_D_Interface: ',cItem_D_Interface );
740:
741: -- Retreive the system profile option ECE_OUT_FILE_PATH. This will
742: -- be the directory where the output file will be written.
743: -- NOTE: THIS DIRECTORY MUST BE SPECIFIED IN THE PARAMETER utl_file_dir IN

Line 750: ec_debug.pl ( 3, 'cOutput_path: ',cOutput_path );

746:
747: xProgress := 'SPSOB-10-0100';
748: fnd_profile.get ( 'ECE_OUT_FILE_PATH',
749: cOutput_path );
750: ec_debug.pl ( 3, 'cOutput_path: ',cOutput_path );
751:
752:
753: xProgress := 'SPSOB-10-1000';
754: ece_flatfile_pvt.INIT_TABLE ( cTransaction_Type,

Line 854: ec_debug.pl ( 3, 'cHeader_view: ',cHeader_view );

850: cItem_view := 'ECE_SSSO_ITEMS_V';
851:
852: END IF;
853:
854: ec_debug.pl ( 3, 'cHeader_view: ',cHeader_view );
855: ec_debug.pl ( 3, 'cItem_view: ',cItem_view );
856:
857: -- *****************************
858: -- if user passed in a 0 (zero)

Line 855: ec_debug.pl ( 3, 'cItem_view: ',cItem_view );

851:
852: END IF;
853:
854: ec_debug.pl ( 3, 'cHeader_view: ',cHeader_view );
855: ec_debug.pl ( 3, 'cItem_view: ',cItem_view );
856:
857: -- *****************************
858: -- if user passed in a 0 (zero)
859: -- select everything

Line 899: ec_debug.pl ( 3, 'cHeader_where: ',cHeader_where );

895: ' OR ' || ':l_p_schedule_id' || ' = 0)'|| 'AND ' || cHeader_view||'.BATCH_ID='||':l_p_batch_id';
896:
897: end if;
898:
899: ec_debug.pl ( 3, 'cHeader_where: ',cHeader_where );
900:
901: xProgress := 'SPSOB-10-1080';
902: cItem_where := cItem_where ||
903: cItem_view ||

Line 906: ec_debug.pl ( 3, 'cItem_where: ',cItem_where );

902: cItem_where := cItem_where ||
903: cItem_view ||
904: '.SCHEDULE_ID = :schedule_id';
905:
906: ec_debug.pl ( 3, 'cItem_where: ',cItem_where );
907:
908: xProgress := 'SPSOB-10-1090';
909: cHeader_select := cHeader_select ||
910: cHeader_from ||

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

909: cHeader_select := cHeader_select ||
910: cHeader_from ||
911: cHeader_where;
912:
913: ec_debug.pl ( 3, 'cHeader_select: ',cHeader_select );
914:
915: xProgress := 'SPSOB-10-1100';
916: cItem_select := cItem_select ||
917: cItem_from ||

Line 920: ec_debug.pl ( 3, 'cItem_select: ',cItem_select );

916: cItem_select := cItem_select ||
917: cItem_from ||
918: cItem_where;
919:
920: ec_debug.pl ( 3, 'cItem_select: ',cItem_select );
921:
922: -- ***************************************************
923: -- ***
924: -- *** Get data setup for the dynamic SQL call.

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

1022:
1023: xProgress := 'SPSOB-10-1190';
1024: n_trx_date_pos := ece_extract_utils_pub.POS_OF ( l_header_tbl,
1025: ece_extract_utils_pub.G_Transaction_date );
1026: ec_debug.pl ( 3, 'n_trx_date_pos: ',n_trx_date_pos );
1027:
1028: xProgress := 'SPSOB-10-1200';
1029: n_vendor_id_pos := ece_extract_utils_pub.POS_OF ( l_header_tbl,
1030: 'VENDOR_ID' );

Line 1031: ec_debug.pl ( 3, 'n_vendor_id_pos: ',n_vendor_id_pos );

1027:
1028: xProgress := 'SPSOB-10-1200';
1029: n_vendor_id_pos := ece_extract_utils_pub.POS_OF ( l_header_tbl,
1030: 'VENDOR_ID' );
1031: ec_debug.pl ( 3, 'n_vendor_id_pos: ',n_vendor_id_pos );
1032:
1033: xProgress := 'SPSOB-10-1210';
1034: n_vendor_site_id_pos := ece_extract_utils_pub.POS_OF ( l_header_tbl,
1035: 'VENDOR_SITE_ID' );

Line 1036: ec_debug.pl ( 3, 'n_vendor_site_id_pos: ',n_vendor_site_id_pos );

1032:
1033: xProgress := 'SPSOB-10-1210';
1034: n_vendor_site_id_pos := ece_extract_utils_pub.POS_OF ( l_header_tbl,
1035: 'VENDOR_SITE_ID' );
1036: ec_debug.pl ( 3, 'n_vendor_site_id_pos: ',n_vendor_site_id_pos );
1037:
1038: xProgress := 'SPSOB-10-1220';
1039: n_organization_id_pos := ece_extract_utils_pub.POS_OF ( l_header_tbl,
1040: 'ORGANIZATION_ID' );

Line 1041: ec_debug.pl ( 3, 'n_organization_id_pos: ',n_organization_id_pos );

1037:
1038: xProgress := 'SPSOB-10-1220';
1039: n_organization_id_pos := ece_extract_utils_pub.POS_OF ( l_header_tbl,
1040: 'ORGANIZATION_ID' );
1041: ec_debug.pl ( 3, 'n_organization_id_pos: ',n_organization_id_pos );
1042:
1043: xProgress := 'SPSOB-10-1230';
1044: n_st_org_code_pos := ece_extract_utils_pub.POS_OF ( l_header_tbl,
1045: 'ST_ORG_CODE' );

Line 1046: ec_debug.pl ( 3, 'n_st_org_code_pos: ',n_st_org_code_pos );

1042:
1043: xProgress := 'SPSOB-10-1230';
1044: n_st_org_code_pos := ece_extract_utils_pub.POS_OF ( l_header_tbl,
1045: 'ST_ORG_CODE' );
1046: ec_debug.pl ( 3, 'n_st_org_code_pos: ',n_st_org_code_pos );
1047:
1048: xProgress := 'SPSOB-10-1240';
1049: n_schedule_type_pos := ece_extract_utils_pub.POS_OF ( l_header_tbl,
1050: 'SCHEDULE_TYPE' );

Line 1051: ec_debug.pl ( 3, 'n_schedule_type_pos: ',n_schedule_type_pos );

1047:
1048: xProgress := 'SPSOB-10-1240';
1049: n_schedule_type_pos := ece_extract_utils_pub.POS_OF ( l_header_tbl,
1050: 'SCHEDULE_TYPE' );
1051: ec_debug.pl ( 3, 'n_schedule_type_pos: ',n_schedule_type_pos );
1052:
1053: xProgress := 'SPSOB-10-1250';
1054: n_st_name_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1055: 'ST_NAME' );

Line 1056: ec_debug.pl ( 3, 'n_st_name_pos: ',n_st_name_pos );

1052:
1053: xProgress := 'SPSOB-10-1250';
1054: n_st_name_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1055: 'ST_NAME' );
1056: ec_debug.pl ( 3, 'n_st_name_pos: ',n_st_name_pos );
1057:
1058: ece_extract_utils_pub.Find_pos ( l_header_tbl,
1059: 'SCHEDULE_ID',
1060: n_schedule_id_pos );

Line 1061: ec_debug.pl ( 3, 'n_schedule_id_pos: ',n_schedule_id_pos );

1057:
1058: ece_extract_utils_pub.Find_pos ( l_header_tbl,
1059: 'SCHEDULE_ID',
1060: n_schedule_id_pos );
1061: ec_debug.pl ( 3, 'n_schedule_id_pos: ',n_schedule_id_pos );
1062:
1063: xProgress := 'SPSOB-10-1260';
1064: n_item_id_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1065: 'SCHEDULE_ITEM_ID' );

Line 1066: ec_debug.pl ( 3, 'n_item_id_pos: ',n_item_id_pos );

1062:
1063: xProgress := 'SPSOB-10-1260';
1064: n_item_id_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1065: 'SCHEDULE_ITEM_ID' );
1066: ec_debug.pl ( 3, 'n_item_id_pos: ',n_item_id_pos );
1067:
1068: xProgress := 'SPSOB-10-1270';
1069: n_enable_cum_flag_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1070: 'ENABLE_CUM_FLAG' );

Line 1071: ec_debug.pl ( 3, 'n_enable_cum_flag_pos: ',n_enable_cum_flag_pos );

1067:
1068: xProgress := 'SPSOB-10-1270';
1069: n_enable_cum_flag_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1070: 'ENABLE_CUM_FLAG' );
1071: ec_debug.pl ( 3, 'n_enable_cum_flag_pos: ',n_enable_cum_flag_pos );
1072:
1073: xProgress := 'SPSOB-10-1280';
1074: n_cum_period_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1075: 'CUM_PERIOD_START_DATE' );

Line 1076: ec_debug.pl ( 3, 'n_cum_period_pos: ',n_cum_period_pos );

1072:
1073: xProgress := 'SPSOB-10-1280';
1074: n_cum_period_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1075: 'CUM_PERIOD_START_DATE' );
1076: ec_debug.pl ( 3, 'n_cum_period_pos: ',n_cum_period_pos );
1077:
1078: xProgress := 'SPSOB-10-1290';
1079: n_item_st_org_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1080: 'ST_ORG_CODE' );

Line 1081: ec_debug.pl ( 3, 'n_item_st_org_pos: ',n_item_st_org_pos );

1077:
1078: xProgress := 'SPSOB-10-1290';
1079: n_item_st_org_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1080: 'ST_ORG_CODE' );
1081: ec_debug.pl ( 3, 'n_item_st_org_pos: ',n_item_st_org_pos );
1082:
1083: xProgress := 'SPSOB-10-1300';
1084: n_st_add_1_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1085: 'ST_ADDRESS_LINE1' );

Line 1086: ec_debug.pl ( 3, 'n_st_add_1_pos: ',n_st_add_1_pos );

1082:
1083: xProgress := 'SPSOB-10-1300';
1084: n_st_add_1_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1085: 'ST_ADDRESS_LINE1' );
1086: ec_debug.pl ( 3, 'n_st_add_1_pos: ',n_st_add_1_pos );
1087:
1088: xProgress := 'SPSOB-10-1310';
1089: n_st_add_2_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1090: 'ST_ADDRESS_LINE2' );

Line 1091: ec_debug.pl ( 3, 'n_st_add_2_pos: ',n_st_add_2_pos );

1087:
1088: xProgress := 'SPSOB-10-1310';
1089: n_st_add_2_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1090: 'ST_ADDRESS_LINE2' );
1091: ec_debug.pl ( 3, 'n_st_add_2_pos: ',n_st_add_2_pos );
1092:
1093: xProgress := 'SPSOB-10-1320';
1094: n_st_add_3_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1095: 'ST_ADDRESS_LINE3' );

Line 1096: ec_debug.pl ( 3, 'n_st_add_3_pos: ',n_st_add_3_pos );

1092:
1093: xProgress := 'SPSOB-10-1320';
1094: n_st_add_3_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1095: 'ST_ADDRESS_LINE3' );
1096: ec_debug.pl ( 3, 'n_st_add_3_pos: ',n_st_add_3_pos );
1097:
1098: xProgress := 'SPSOB-10-1330';
1099: n_st_city_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1100: 'ST_CITY' );

Line 1101: ec_debug.pl ( 3, 'n_st_city_pos: ',n_st_city_pos );

1097:
1098: xProgress := 'SPSOB-10-1330';
1099: n_st_city_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1100: 'ST_CITY' );
1101: ec_debug.pl ( 3, 'n_st_city_pos: ',n_st_city_pos );
1102:
1103: xProgress := 'SPSOB-10-1340';
1104: n_st_county_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1105: 'ST_COUNTY' );

Line 1106: ec_debug.pl ( 3, 'n_st_county_pos: ',n_st_county_pos );

1102:
1103: xProgress := 'SPSOB-10-1340';
1104: n_st_county_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1105: 'ST_COUNTY' );
1106: ec_debug.pl ( 3, 'n_st_county_pos: ',n_st_county_pos );
1107:
1108: xProgress := 'SPSOB-10-1350';
1109: n_st_state_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1110: 'ST_STATE' );

Line 1111: ec_debug.pl ( 3, 'n_st_state_pos: ',n_st_state_pos );

1107:
1108: xProgress := 'SPSOB-10-1350';
1109: n_st_state_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1110: 'ST_STATE' );
1111: ec_debug.pl ( 3, 'n_st_state_pos: ',n_st_state_pos );
1112:
1113: xProgress := 'SPSOB-10-1360';
1114: n_st_country_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1115: 'ST_COUNTRY' );

Line 1116: ec_debug.pl ( 3, 'n_st_country_pos: ',n_st_country_pos );

1112:
1113: xProgress := 'SPSOB-10-1360';
1114: n_st_country_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1115: 'ST_COUNTRY' );
1116: ec_debug.pl ( 3, 'n_st_country_pos: ',n_st_country_pos );
1117:
1118: xProgress := 'SPSOB-10-1370';
1119: n_st_postal_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1120: 'ST_POSTAL_CODE' );

Line 1121: ec_debug.pl ( 3, 'n_st_postal_pos: ',n_st_postal_pos );

1117:
1118: xProgress := 'SPSOB-10-1370';
1119: n_st_postal_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1120: 'ST_POSTAL_CODE' );
1121: ec_debug.pl ( 3, 'n_st_postal_pos: ',n_st_postal_pos );
1122:
1123: xProgress := 'SPSOB-10-1371';
1124: dbms_sql.bind_variable(Header_sel_c,'l_cCommunication_Method',cCommunication_Method);
1125:

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

1177: -- ***************************************************
1178:
1179: xProgress := 'SPSOB-10-1410';
1180: l_header_tbl(n_trx_date_pos).value := TO_CHAR(dTransaction_date,'YYYYMMDD HH24MISS');
1181: ec_debug.pl ( 3, 'l_header_tbl(n_trx_date_pos).value: ',l_header_tbl(n_trx_date_pos).value );
1182:
1183: -- pass the pl/sql table in for xref
1184:
1185: xProgress := 'SPSOB-10-1420';

Line 1234: ec_debug.pl ( 0,

1230: INTO l_header_fkey
1231: FROM sys.dual;
1232: EXCEPTION
1233: WHEN NO_DATA_FOUND THEN
1234: ec_debug.pl ( 0,
1235: 'EC',
1236: 'ECE_GET_NEXT_SEQ_FAILED',
1237: 'PROGRESS_LEVEL',
1238: xProgress,

Line 1402: ec_debug.pl ( 1,

1398: ppf.employee_number (+),
1399: ppf.applicant_number (+) ))= 'TRUE';
1400: EXCEPTION
1401: WHEN NO_DATA_FOUND THEN
1402: ec_debug.pl ( 1,
1403: 'EC',
1404: 'ECE_NO_ROW_SELECTED',
1405: 'PROGRESS_LEVEL',
1406: xProgress,

Line 1413: ec_debug.pl ( 3, 'x_asl_id: ',x_asl_id );

1409: 'TABLE_NAME',
1410: 'PO_ASL_ATTRIBUTES' );
1411: END;
1412:
1413: ec_debug.pl ( 3, 'x_asl_id: ',x_asl_id );
1414: ec_debug.pl ( 3, 'x_enable_authorizations_flag: ',x_enable_authorizations_flag );
1415: ec_debug.pl ( 3, 'x_scheduler_id: ',x_scheduler_id );
1416: ec_debug.pl ( 3, 'x_scheduler_first_name: ',x_scheduler_first_name );
1417: ec_debug.pl ( 3, 'x_scheduler_last_name: ',x_scheduler_last_name );

Line 1414: ec_debug.pl ( 3, 'x_enable_authorizations_flag: ',x_enable_authorizations_flag );

1410: 'PO_ASL_ATTRIBUTES' );
1411: END;
1412:
1413: ec_debug.pl ( 3, 'x_asl_id: ',x_asl_id );
1414: ec_debug.pl ( 3, 'x_enable_authorizations_flag: ',x_enable_authorizations_flag );
1415: ec_debug.pl ( 3, 'x_scheduler_id: ',x_scheduler_id );
1416: ec_debug.pl ( 3, 'x_scheduler_first_name: ',x_scheduler_first_name );
1417: ec_debug.pl ( 3, 'x_scheduler_last_name: ',x_scheduler_last_name );
1418: ec_debug.pl ( 3, 'x_scheduler_work_telephone: ',x_scheduler_work_telephone );

Line 1415: ec_debug.pl ( 3, 'x_scheduler_id: ',x_scheduler_id );

1411: END;
1412:
1413: ec_debug.pl ( 3, 'x_asl_id: ',x_asl_id );
1414: ec_debug.pl ( 3, 'x_enable_authorizations_flag: ',x_enable_authorizations_flag );
1415: ec_debug.pl ( 3, 'x_scheduler_id: ',x_scheduler_id );
1416: ec_debug.pl ( 3, 'x_scheduler_first_name: ',x_scheduler_first_name );
1417: ec_debug.pl ( 3, 'x_scheduler_last_name: ',x_scheduler_last_name );
1418: ec_debug.pl ( 3, 'x_scheduler_work_telephone: ',x_scheduler_work_telephone );
1419: ec_debug.pl ( 3, 'x_asl_attribute_category: ',x_asl_attribute_category );

Line 1416: ec_debug.pl ( 3, 'x_scheduler_first_name: ',x_scheduler_first_name );

1412:
1413: ec_debug.pl ( 3, 'x_asl_id: ',x_asl_id );
1414: ec_debug.pl ( 3, 'x_enable_authorizations_flag: ',x_enable_authorizations_flag );
1415: ec_debug.pl ( 3, 'x_scheduler_id: ',x_scheduler_id );
1416: ec_debug.pl ( 3, 'x_scheduler_first_name: ',x_scheduler_first_name );
1417: ec_debug.pl ( 3, 'x_scheduler_last_name: ',x_scheduler_last_name );
1418: ec_debug.pl ( 3, 'x_scheduler_work_telephone: ',x_scheduler_work_telephone );
1419: ec_debug.pl ( 3, 'x_asl_attribute_category: ',x_asl_attribute_category );
1420: ec_debug.pl ( 3, 'x_asl_attribute1: ',x_asl_attribute1 );

Line 1417: ec_debug.pl ( 3, 'x_scheduler_last_name: ',x_scheduler_last_name );

1413: ec_debug.pl ( 3, 'x_asl_id: ',x_asl_id );
1414: ec_debug.pl ( 3, 'x_enable_authorizations_flag: ',x_enable_authorizations_flag );
1415: ec_debug.pl ( 3, 'x_scheduler_id: ',x_scheduler_id );
1416: ec_debug.pl ( 3, 'x_scheduler_first_name: ',x_scheduler_first_name );
1417: ec_debug.pl ( 3, 'x_scheduler_last_name: ',x_scheduler_last_name );
1418: ec_debug.pl ( 3, 'x_scheduler_work_telephone: ',x_scheduler_work_telephone );
1419: ec_debug.pl ( 3, 'x_asl_attribute_category: ',x_asl_attribute_category );
1420: ec_debug.pl ( 3, 'x_asl_attribute1: ',x_asl_attribute1 );
1421: ec_debug.pl ( 3, 'x_asl_attribute2: ',x_asl_attribute2 );

Line 1418: ec_debug.pl ( 3, 'x_scheduler_work_telephone: ',x_scheduler_work_telephone );

1414: ec_debug.pl ( 3, 'x_enable_authorizations_flag: ',x_enable_authorizations_flag );
1415: ec_debug.pl ( 3, 'x_scheduler_id: ',x_scheduler_id );
1416: ec_debug.pl ( 3, 'x_scheduler_first_name: ',x_scheduler_first_name );
1417: ec_debug.pl ( 3, 'x_scheduler_last_name: ',x_scheduler_last_name );
1418: ec_debug.pl ( 3, 'x_scheduler_work_telephone: ',x_scheduler_work_telephone );
1419: ec_debug.pl ( 3, 'x_asl_attribute_category: ',x_asl_attribute_category );
1420: ec_debug.pl ( 3, 'x_asl_attribute1: ',x_asl_attribute1 );
1421: ec_debug.pl ( 3, 'x_asl_attribute2: ',x_asl_attribute2 );
1422: ec_debug.pl ( 3, 'x_asl_attribute3: ',x_asl_attribute3 );

Line 1419: ec_debug.pl ( 3, 'x_asl_attribute_category: ',x_asl_attribute_category );

1415: ec_debug.pl ( 3, 'x_scheduler_id: ',x_scheduler_id );
1416: ec_debug.pl ( 3, 'x_scheduler_first_name: ',x_scheduler_first_name );
1417: ec_debug.pl ( 3, 'x_scheduler_last_name: ',x_scheduler_last_name );
1418: ec_debug.pl ( 3, 'x_scheduler_work_telephone: ',x_scheduler_work_telephone );
1419: ec_debug.pl ( 3, 'x_asl_attribute_category: ',x_asl_attribute_category );
1420: ec_debug.pl ( 3, 'x_asl_attribute1: ',x_asl_attribute1 );
1421: ec_debug.pl ( 3, 'x_asl_attribute2: ',x_asl_attribute2 );
1422: ec_debug.pl ( 3, 'x_asl_attribute3: ',x_asl_attribute3 );
1423: ec_debug.pl ( 3, 'x_asl_attribute4: ',x_asl_attribute4 );

Line 1420: ec_debug.pl ( 3, 'x_asl_attribute1: ',x_asl_attribute1 );

1416: ec_debug.pl ( 3, 'x_scheduler_first_name: ',x_scheduler_first_name );
1417: ec_debug.pl ( 3, 'x_scheduler_last_name: ',x_scheduler_last_name );
1418: ec_debug.pl ( 3, 'x_scheduler_work_telephone: ',x_scheduler_work_telephone );
1419: ec_debug.pl ( 3, 'x_asl_attribute_category: ',x_asl_attribute_category );
1420: ec_debug.pl ( 3, 'x_asl_attribute1: ',x_asl_attribute1 );
1421: ec_debug.pl ( 3, 'x_asl_attribute2: ',x_asl_attribute2 );
1422: ec_debug.pl ( 3, 'x_asl_attribute3: ',x_asl_attribute3 );
1423: ec_debug.pl ( 3, 'x_asl_attribute4: ',x_asl_attribute4 );
1424: ec_debug.pl ( 3, 'x_asl_attribute5: ',x_asl_attribute5 );

Line 1421: ec_debug.pl ( 3, 'x_asl_attribute2: ',x_asl_attribute2 );

1417: ec_debug.pl ( 3, 'x_scheduler_last_name: ',x_scheduler_last_name );
1418: ec_debug.pl ( 3, 'x_scheduler_work_telephone: ',x_scheduler_work_telephone );
1419: ec_debug.pl ( 3, 'x_asl_attribute_category: ',x_asl_attribute_category );
1420: ec_debug.pl ( 3, 'x_asl_attribute1: ',x_asl_attribute1 );
1421: ec_debug.pl ( 3, 'x_asl_attribute2: ',x_asl_attribute2 );
1422: ec_debug.pl ( 3, 'x_asl_attribute3: ',x_asl_attribute3 );
1423: ec_debug.pl ( 3, 'x_asl_attribute4: ',x_asl_attribute4 );
1424: ec_debug.pl ( 3, 'x_asl_attribute5: ',x_asl_attribute5 );
1425: ec_debug.pl ( 3, 'x_asl_attribute6: ',x_asl_attribute6 );

Line 1422: ec_debug.pl ( 3, 'x_asl_attribute3: ',x_asl_attribute3 );

1418: ec_debug.pl ( 3, 'x_scheduler_work_telephone: ',x_scheduler_work_telephone );
1419: ec_debug.pl ( 3, 'x_asl_attribute_category: ',x_asl_attribute_category );
1420: ec_debug.pl ( 3, 'x_asl_attribute1: ',x_asl_attribute1 );
1421: ec_debug.pl ( 3, 'x_asl_attribute2: ',x_asl_attribute2 );
1422: ec_debug.pl ( 3, 'x_asl_attribute3: ',x_asl_attribute3 );
1423: ec_debug.pl ( 3, 'x_asl_attribute4: ',x_asl_attribute4 );
1424: ec_debug.pl ( 3, 'x_asl_attribute5: ',x_asl_attribute5 );
1425: ec_debug.pl ( 3, 'x_asl_attribute6: ',x_asl_attribute6 );
1426: ec_debug.pl ( 3, 'x_asl_attribute7: ',x_asl_attribute7 );

Line 1423: ec_debug.pl ( 3, 'x_asl_attribute4: ',x_asl_attribute4 );

1419: ec_debug.pl ( 3, 'x_asl_attribute_category: ',x_asl_attribute_category );
1420: ec_debug.pl ( 3, 'x_asl_attribute1: ',x_asl_attribute1 );
1421: ec_debug.pl ( 3, 'x_asl_attribute2: ',x_asl_attribute2 );
1422: ec_debug.pl ( 3, 'x_asl_attribute3: ',x_asl_attribute3 );
1423: ec_debug.pl ( 3, 'x_asl_attribute4: ',x_asl_attribute4 );
1424: ec_debug.pl ( 3, 'x_asl_attribute5: ',x_asl_attribute5 );
1425: ec_debug.pl ( 3, 'x_asl_attribute6: ',x_asl_attribute6 );
1426: ec_debug.pl ( 3, 'x_asl_attribute7: ',x_asl_attribute7 );
1427: ec_debug.pl ( 3, 'x_asl_attribute8: ',x_asl_attribute8 );

Line 1424: ec_debug.pl ( 3, 'x_asl_attribute5: ',x_asl_attribute5 );

1420: ec_debug.pl ( 3, 'x_asl_attribute1: ',x_asl_attribute1 );
1421: ec_debug.pl ( 3, 'x_asl_attribute2: ',x_asl_attribute2 );
1422: ec_debug.pl ( 3, 'x_asl_attribute3: ',x_asl_attribute3 );
1423: ec_debug.pl ( 3, 'x_asl_attribute4: ',x_asl_attribute4 );
1424: ec_debug.pl ( 3, 'x_asl_attribute5: ',x_asl_attribute5 );
1425: ec_debug.pl ( 3, 'x_asl_attribute6: ',x_asl_attribute6 );
1426: ec_debug.pl ( 3, 'x_asl_attribute7: ',x_asl_attribute7 );
1427: ec_debug.pl ( 3, 'x_asl_attribute8: ',x_asl_attribute8 );
1428: ec_debug.pl ( 3, 'x_asl_attribute9: ',x_asl_attribute9 );

Line 1425: ec_debug.pl ( 3, 'x_asl_attribute6: ',x_asl_attribute6 );

1421: ec_debug.pl ( 3, 'x_asl_attribute2: ',x_asl_attribute2 );
1422: ec_debug.pl ( 3, 'x_asl_attribute3: ',x_asl_attribute3 );
1423: ec_debug.pl ( 3, 'x_asl_attribute4: ',x_asl_attribute4 );
1424: ec_debug.pl ( 3, 'x_asl_attribute5: ',x_asl_attribute5 );
1425: ec_debug.pl ( 3, 'x_asl_attribute6: ',x_asl_attribute6 );
1426: ec_debug.pl ( 3, 'x_asl_attribute7: ',x_asl_attribute7 );
1427: ec_debug.pl ( 3, 'x_asl_attribute8: ',x_asl_attribute8 );
1428: ec_debug.pl ( 3, 'x_asl_attribute9: ',x_asl_attribute9 );
1429: ec_debug.pl ( 3, 'x_asl_attribute10: ',x_asl_attribute10 );

Line 1426: ec_debug.pl ( 3, 'x_asl_attribute7: ',x_asl_attribute7 );

1422: ec_debug.pl ( 3, 'x_asl_attribute3: ',x_asl_attribute3 );
1423: ec_debug.pl ( 3, 'x_asl_attribute4: ',x_asl_attribute4 );
1424: ec_debug.pl ( 3, 'x_asl_attribute5: ',x_asl_attribute5 );
1425: ec_debug.pl ( 3, 'x_asl_attribute6: ',x_asl_attribute6 );
1426: ec_debug.pl ( 3, 'x_asl_attribute7: ',x_asl_attribute7 );
1427: ec_debug.pl ( 3, 'x_asl_attribute8: ',x_asl_attribute8 );
1428: ec_debug.pl ( 3, 'x_asl_attribute9: ',x_asl_attribute9 );
1429: ec_debug.pl ( 3, 'x_asl_attribute10: ',x_asl_attribute10 );
1430: ec_debug.pl ( 3, 'x_asl_attribute11: ',x_asl_attribute11 );

Line 1427: ec_debug.pl ( 3, 'x_asl_attribute8: ',x_asl_attribute8 );

1423: ec_debug.pl ( 3, 'x_asl_attribute4: ',x_asl_attribute4 );
1424: ec_debug.pl ( 3, 'x_asl_attribute5: ',x_asl_attribute5 );
1425: ec_debug.pl ( 3, 'x_asl_attribute6: ',x_asl_attribute6 );
1426: ec_debug.pl ( 3, 'x_asl_attribute7: ',x_asl_attribute7 );
1427: ec_debug.pl ( 3, 'x_asl_attribute8: ',x_asl_attribute8 );
1428: ec_debug.pl ( 3, 'x_asl_attribute9: ',x_asl_attribute9 );
1429: ec_debug.pl ( 3, 'x_asl_attribute10: ',x_asl_attribute10 );
1430: ec_debug.pl ( 3, 'x_asl_attribute11: ',x_asl_attribute11 );
1431: ec_debug.pl ( 3, 'x_asl_attribute12: ',x_asl_attribute12 );

Line 1428: ec_debug.pl ( 3, 'x_asl_attribute9: ',x_asl_attribute9 );

1424: ec_debug.pl ( 3, 'x_asl_attribute5: ',x_asl_attribute5 );
1425: ec_debug.pl ( 3, 'x_asl_attribute6: ',x_asl_attribute6 );
1426: ec_debug.pl ( 3, 'x_asl_attribute7: ',x_asl_attribute7 );
1427: ec_debug.pl ( 3, 'x_asl_attribute8: ',x_asl_attribute8 );
1428: ec_debug.pl ( 3, 'x_asl_attribute9: ',x_asl_attribute9 );
1429: ec_debug.pl ( 3, 'x_asl_attribute10: ',x_asl_attribute10 );
1430: ec_debug.pl ( 3, 'x_asl_attribute11: ',x_asl_attribute11 );
1431: ec_debug.pl ( 3, 'x_asl_attribute12: ',x_asl_attribute12 );
1432: ec_debug.pl ( 3, 'x_asl_attribute13: ',x_asl_attribute13 );

Line 1429: ec_debug.pl ( 3, 'x_asl_attribute10: ',x_asl_attribute10 );

1425: ec_debug.pl ( 3, 'x_asl_attribute6: ',x_asl_attribute6 );
1426: ec_debug.pl ( 3, 'x_asl_attribute7: ',x_asl_attribute7 );
1427: ec_debug.pl ( 3, 'x_asl_attribute8: ',x_asl_attribute8 );
1428: ec_debug.pl ( 3, 'x_asl_attribute9: ',x_asl_attribute9 );
1429: ec_debug.pl ( 3, 'x_asl_attribute10: ',x_asl_attribute10 );
1430: ec_debug.pl ( 3, 'x_asl_attribute11: ',x_asl_attribute11 );
1431: ec_debug.pl ( 3, 'x_asl_attribute12: ',x_asl_attribute12 );
1432: ec_debug.pl ( 3, 'x_asl_attribute13: ',x_asl_attribute13 );
1433: ec_debug.pl ( 3, 'x_asl_attribute14: ',x_asl_attribute14 );

Line 1430: ec_debug.pl ( 3, 'x_asl_attribute11: ',x_asl_attribute11 );

1426: ec_debug.pl ( 3, 'x_asl_attribute7: ',x_asl_attribute7 );
1427: ec_debug.pl ( 3, 'x_asl_attribute8: ',x_asl_attribute8 );
1428: ec_debug.pl ( 3, 'x_asl_attribute9: ',x_asl_attribute9 );
1429: ec_debug.pl ( 3, 'x_asl_attribute10: ',x_asl_attribute10 );
1430: ec_debug.pl ( 3, 'x_asl_attribute11: ',x_asl_attribute11 );
1431: ec_debug.pl ( 3, 'x_asl_attribute12: ',x_asl_attribute12 );
1432: ec_debug.pl ( 3, 'x_asl_attribute13: ',x_asl_attribute13 );
1433: ec_debug.pl ( 3, 'x_asl_attribute14: ',x_asl_attribute14 );
1434: ec_debug.pl ( 3, 'x_asl_attribute15: ',x_asl_attribute15 );

Line 1431: ec_debug.pl ( 3, 'x_asl_attribute12: ',x_asl_attribute12 );

1427: ec_debug.pl ( 3, 'x_asl_attribute8: ',x_asl_attribute8 );
1428: ec_debug.pl ( 3, 'x_asl_attribute9: ',x_asl_attribute9 );
1429: ec_debug.pl ( 3, 'x_asl_attribute10: ',x_asl_attribute10 );
1430: ec_debug.pl ( 3, 'x_asl_attribute11: ',x_asl_attribute11 );
1431: ec_debug.pl ( 3, 'x_asl_attribute12: ',x_asl_attribute12 );
1432: ec_debug.pl ( 3, 'x_asl_attribute13: ',x_asl_attribute13 );
1433: ec_debug.pl ( 3, 'x_asl_attribute14: ',x_asl_attribute14 );
1434: ec_debug.pl ( 3, 'x_asl_attribute15: ',x_asl_attribute15 );
1435:

Line 1432: ec_debug.pl ( 3, 'x_asl_attribute13: ',x_asl_attribute13 );

1428: ec_debug.pl ( 3, 'x_asl_attribute9: ',x_asl_attribute9 );
1429: ec_debug.pl ( 3, 'x_asl_attribute10: ',x_asl_attribute10 );
1430: ec_debug.pl ( 3, 'x_asl_attribute11: ',x_asl_attribute11 );
1431: ec_debug.pl ( 3, 'x_asl_attribute12: ',x_asl_attribute12 );
1432: ec_debug.pl ( 3, 'x_asl_attribute13: ',x_asl_attribute13 );
1433: ec_debug.pl ( 3, 'x_asl_attribute14: ',x_asl_attribute14 );
1434: ec_debug.pl ( 3, 'x_asl_attribute15: ',x_asl_attribute15 );
1435:
1436: BEGIN

Line 1433: ec_debug.pl ( 3, 'x_asl_attribute14: ',x_asl_attribute14 );

1429: ec_debug.pl ( 3, 'x_asl_attribute10: ',x_asl_attribute10 );
1430: ec_debug.pl ( 3, 'x_asl_attribute11: ',x_asl_attribute11 );
1431: ec_debug.pl ( 3, 'x_asl_attribute12: ',x_asl_attribute12 );
1432: ec_debug.pl ( 3, 'x_asl_attribute13: ',x_asl_attribute13 );
1433: ec_debug.pl ( 3, 'x_asl_attribute14: ',x_asl_attribute14 );
1434: ec_debug.pl ( 3, 'x_asl_attribute15: ',x_asl_attribute15 );
1435:
1436: BEGIN
1437: xProgress := 'SPSOB-10-1510';

Line 1434: ec_debug.pl ( 3, 'x_asl_attribute15: ',x_asl_attribute15 );

1430: ec_debug.pl ( 3, 'x_asl_attribute11: ',x_asl_attribute11 );
1431: ec_debug.pl ( 3, 'x_asl_attribute12: ',x_asl_attribute12 );
1432: ec_debug.pl ( 3, 'x_asl_attribute13: ',x_asl_attribute13 );
1433: ec_debug.pl ( 3, 'x_asl_attribute14: ',x_asl_attribute14 );
1434: ec_debug.pl ( 3, 'x_asl_attribute15: ',x_asl_attribute15 );
1435:
1436: BEGIN
1437: xProgress := 'SPSOB-10-1510';
1438: SELECT primary_vendor_item

Line 1444: ec_debug.pl ( 1,

1440: FROM po_approved_supplier_list
1441: WHERE asl_id = x_asl_id;
1442: EXCEPTION
1443: WHEN NO_DATA_FOUND THEN
1444: ec_debug.pl ( 1,
1445: 'EC',
1446: 'ECE_NO_ROW_SELECTED',
1447: 'PROGRESS_LEVEL',
1448: xProgress,

Line 1455: ec_debug.pl ( 3, 'x_supplier_product_num: ',x_supplier_product_num );

1451: 'TABLE_NAME',
1452: 'PO_APPROVED_SUPPLIER_LIST' );
1453: END;
1454:
1455: ec_debug.pl ( 3, 'x_supplier_product_num: ',x_supplier_product_num );
1456:
1457:
1458: BEGIN -- Planner information
1459: xProgress := 'SPSOB-10-1520';

Line 1483: ec_debug.pl ( 1,

1479: ppf.employee_number (+),
1480: ppf.applicant_number (+) ))= 'TRUE';
1481: EXCEPTION
1482: WHEN NO_DATA_FOUND THEN
1483: ec_debug.pl ( 1,
1484: 'EC',
1485: 'ECE_NO_ROW_SELECTED',
1486: 'PROGRESS_LEVEL',
1487: xProgress,

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

1490: 'TABLE_NAME',
1491: 'MTL_SYSTEM_ITEMS' );
1492: END;
1493:
1494: ec_debug.pl ( 3, 'x_planner_last_name: ',x_planner_last_name );
1495: ec_debug.pl ( 3, 'x_planner_first_name: ',x_planner_first_name );
1496: ec_debug.pl ( 3, 'x_planner_work_telephone: ',x_planner_work_telephone );
1497:
1498: -- pass the pl/sql table in for xref

Line 1495: ec_debug.pl ( 3, 'x_planner_first_name: ',x_planner_first_name );

1491: 'MTL_SYSTEM_ITEMS' );
1492: END;
1493:
1494: ec_debug.pl ( 3, 'x_planner_last_name: ',x_planner_last_name );
1495: ec_debug.pl ( 3, 'x_planner_first_name: ',x_planner_first_name );
1496: ec_debug.pl ( 3, 'x_planner_work_telephone: ',x_planner_work_telephone );
1497:
1498: -- pass the pl/sql table in for xref
1499:

Line 1496: ec_debug.pl ( 3, 'x_planner_work_telephone: ',x_planner_work_telephone );

1492: END;
1493:
1494: ec_debug.pl ( 3, 'x_planner_last_name: ',x_planner_last_name );
1495: ec_debug.pl ( 3, 'x_planner_first_name: ',x_planner_first_name );
1496: ec_debug.pl ( 3, 'x_planner_work_telephone: ',x_planner_work_telephone );
1497:
1498: -- pass the pl/sql table in for xref
1499:
1500:

Line 1528: ec_debug.pl ( 0,

1524: INTO l_item_fkey
1525: FROM sys.dual;
1526: EXCEPTION
1527: WHEN NO_DATA_FOUND THEN
1528: ec_debug.pl ( 0,
1529: 'EC',
1530: 'ECE_GET_NEXT_SEQ_FAILED',
1531: 'PROGRESS_LEVEL',
1532: xProgress,

Line 1537: ec_debug.pl ( 3, 'l_item_fkey: ',l_item_fkey );

1533: 'SEQ',
1534: 'ECE_SPSO_ITEMS_S' );
1535: END;
1536:
1537: ec_debug.pl ( 3, 'l_item_fkey: ',l_item_fkey );
1538: xProgress := 'SPSOB-10-1551';
1539: Begin
1540: Select count(schedule_id)
1541: Into x_item_detail

Line 1637: ec_debug.pl ( 1,

1633: transaction_record_id = l_item_fkey;
1634:
1635: IF SQL%NOTFOUND
1636: THEN
1637: ec_debug.pl ( 1,
1638: 'EC',
1639: 'ECE_NO_ROW_UPDATED',
1640: 'PROGRESS_LEVEL',
1641: xProgress,

Line 1664: ec_debug.pl ( 1,

1660: xProgress := 'SPSOB-10-1583';
1661: IF ( dbms_sql.last_row_count = 0 )
1662: THEN
1663: v_LevelProcessed := 'ITEM';
1664: ec_debug.pl ( 1,
1665: 'EC',
1666: 'ECE_NO_DB_ROW_PROCESSED',
1667: 'PROGRESS_LEVEL',
1668: xProgress,

Line 1681: ec_debug.pl ( 0,

1677: xProgress := 'SPSOB-10-1586';
1678: IF ( dbms_sql.last_row_count = 0 )
1679: THEN
1680: v_LevelProcessed := 'HEADER';
1681: ec_debug.pl ( 0,
1682: 'EC',
1683: 'ECE_NO_DB_ROW_PROCESSED',
1684: 'PROGRESS_LEVEL',
1685: xProgress,

Line 1698: ec_debug.pop ( 'ECE_SPSO_TRANS1.populate_supplier_sched_api1' );

1694:
1695: xProgress := 'SPSOB-10-1600';
1696: dbms_sql.close_cursor ( Item_sel_c );
1697:
1698: ec_debug.pop ( 'ECE_SPSO_TRANS1.populate_supplier_sched_api1' );
1699:
1700: EXCEPTION
1701: WHEN fail_convert_to_ext THEN
1702:

Line 1703: ec_debug.pl ( 0,

1699:
1700: EXCEPTION
1701: WHEN fail_convert_to_ext THEN
1702:
1703: ec_debug.pl ( 0,
1704: 'EC',
1705: 'ECE_XREF_NOT_FOUND',
1706: NULL );
1707:

Line 1708: ec_debug.pl ( 0,

1704: 'EC',
1705: 'ECE_XREF_NOT_FOUND',
1706: NULL );
1707:
1708: ec_debug.pl ( 0,
1709: 'EC',
1710: 'ECE_ERROR_MESSAGE',
1711: 'ERROR_MESSAGE',
1712: SQLERRM );

Line 1718: ec_debug.pl ( 0,

1714: app_exception.raise_exception;
1715:
1716: WHEN OTHERS THEN
1717:
1718: ec_debug.pl ( 0,
1719: 'EC',
1720: 'ECE_PROGRAM_ERROR',
1721: 'PROGRESS_LEVEL',
1722: xProgress );

Line 1724: ec_debug.pl ( 0,

1720: 'ECE_PROGRAM_ERROR',
1721: 'PROGRESS_LEVEL',
1722: xProgress );
1723:
1724: ec_debug.pl ( 0,
1725: 'EC',
1726: 'ECE_ERROR_MESSAGE',
1727: 'ERROR_MESSAGE',
1728: SQLERRM );

Line 1818: ec_debug.push ( 'ECE_SPSO_TRANS1.populate_supplier_sched_api3' );

1814: FOR UPDATE;
1815:
1816: BEGIN -- begin header block
1817:
1818: ec_debug.push ( 'ECE_SPSO_TRANS1.populate_supplier_sched_api3' );
1819: ec_debug.pl ( 3, 'p_communication_method: ', p_communication_method );
1820: ec_debug.pl ( 3, 'p_transaction_type: ',p_transaction_type );
1821: ec_debug.pl ( 3, 'p_document_type: ',p_document_type );
1822: ec_debug.pl ( 3, 'p_run_id: ',p_run_id );

Line 1819: ec_debug.pl ( 3, 'p_communication_method: ', p_communication_method );

1815:
1816: BEGIN -- begin header block
1817:
1818: ec_debug.push ( 'ECE_SPSO_TRANS1.populate_supplier_sched_api3' );
1819: ec_debug.pl ( 3, 'p_communication_method: ', p_communication_method );
1820: ec_debug.pl ( 3, 'p_transaction_type: ',p_transaction_type );
1821: ec_debug.pl ( 3, 'p_document_type: ',p_document_type );
1822: ec_debug.pl ( 3, 'p_run_id: ',p_run_id );
1823: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );

Line 1820: ec_debug.pl ( 3, 'p_transaction_type: ',p_transaction_type );

1816: BEGIN -- begin header block
1817:
1818: ec_debug.push ( 'ECE_SPSO_TRANS1.populate_supplier_sched_api3' );
1819: ec_debug.pl ( 3, 'p_communication_method: ', p_communication_method );
1820: ec_debug.pl ( 3, 'p_transaction_type: ',p_transaction_type );
1821: ec_debug.pl ( 3, 'p_document_type: ',p_document_type );
1822: ec_debug.pl ( 3, 'p_run_id: ',p_run_id );
1823: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );
1824:

Line 1821: ec_debug.pl ( 3, 'p_document_type: ',p_document_type );

1817:
1818: ec_debug.push ( 'ECE_SPSO_TRANS1.populate_supplier_sched_api3' );
1819: ec_debug.pl ( 3, 'p_communication_method: ', p_communication_method );
1820: ec_debug.pl ( 3, 'p_transaction_type: ',p_transaction_type );
1821: ec_debug.pl ( 3, 'p_document_type: ',p_document_type );
1822: ec_debug.pl ( 3, 'p_run_id: ',p_run_id );
1823: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );
1824:
1825:

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

1818: ec_debug.push ( 'ECE_SPSO_TRANS1.populate_supplier_sched_api3' );
1819: ec_debug.pl ( 3, 'p_communication_method: ', p_communication_method );
1820: ec_debug.pl ( 3, 'p_transaction_type: ',p_transaction_type );
1821: ec_debug.pl ( 3, 'p_document_type: ',p_document_type );
1822: ec_debug.pl ( 3, 'p_run_id: ',p_run_id );
1823: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );
1824:
1825:
1826: -- Retreive the system profile option ECE_OUT_FILE_PATH. This will

Line 1823: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );

1819: ec_debug.pl ( 3, 'p_communication_method: ', p_communication_method );
1820: ec_debug.pl ( 3, 'p_transaction_type: ',p_transaction_type );
1821: ec_debug.pl ( 3, 'p_document_type: ',p_document_type );
1822: ec_debug.pl ( 3, 'p_run_id: ',p_run_id );
1823: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );
1824:
1825:
1826: -- Retreive the system profile option ECE_OUT_FILE_PATH. This will
1827: -- be the directory where the output file will be written.

Line 1835: ec_debug.pl ( 3, 'cOutput_path: ',cOutput_path );

1831:
1832: xProgress := 'SPSOB-30-0100';
1833: fnd_profile.get('ECE_OUT_FILE_PATH',
1834: cOutput_path);
1835: ec_debug.pl ( 3, 'cOutput_path: ',cOutput_path );
1836:
1837:
1838: <

>
1839:

Line 1934: ec_debug.pl ( 1,

1930: WHERE schedule_id = rec_item.schedule_id
1931: AND schedule_item_id = rec_item.schedule_item_id;
1932: EXCEPTION
1933: WHEN NO_DATA_FOUND THEN
1934: ec_debug.pl ( 1,
1935: 'EC',
1936: 'ECE_NO_ROW_SELECTED',
1937: 'PROGRESS_LEVEL',
1938: xProgress,

Line 1945: ec_debug.pl ( 3, 'x_item_detail_sequence: ',x_item_detail_sequence );

1941: 'TABLE_NAME',
1942: 'ECE_SPSO_ITEM_DET' );
1943: END;
1944:
1945: ec_debug.pl ( 3, 'x_item_detail_sequence: ',x_item_detail_sequence );
1946:
1947: BEGIN
1948: xProgress := 'SPSOB-30-1030';
1949: SELECT transaction_record_id

Line 1957: ec_debug.pl ( 1,

1953: AND schedule_item_id = rec_item.schedule_item_id
1954: AND run_id = p_run_id;
1955: EXCEPTION
1956: WHEN NO_DATA_FOUND THEN
1957: ec_debug.pl ( 1,
1958: 'EC',
1959: 'ECE_NO_ROW_SELECTED',
1960: 'PROGRESS_LEVEL',
1961: xProgress,

Line 1968: ec_debug.pl ( 3, 'x_transaction_record_id: ',x_transaction_record_id );

1964: 'TABLE_NAME',
1965: 'ECE_SPSO_ITEMS' );
1966: END;
1967:
1968: ec_debug.pl ( 3, 'x_transaction_record_id: ',x_transaction_record_id );
1969:
1970: /*************************************************
1971: ** SELECT ENABLE_AUTHORIZATION_FLAG **
1972: ** FROM APPROVED SUPPLIER LIST TABLE **

Line 1994: ec_debug.pl ( 1,

1990: rec_hdr.vendor_site_id,
1991: rec_item.item_id);
1992: EXCEPTION
1993: WHEN NO_DATA_FOUND THEN
1994: ec_debug.pl ( 1,
1995: 'EC',
1996: 'ECE_NO_ROW_SELECTED',
1997: 'PROGRESS_LEVEL',
1998: xProgress,

Line 2005: ec_debug.pl ( 3, 'x_enable_authorizations_flag: ',x_enable_authorizations_flag );

2001: 'TABLE_NAME',
2002: 'PO_ASL_ATTRIBUTES' );
2003: END;
2004:
2005: ec_debug.pl ( 3, 'x_enable_authorizations_flag: ',x_enable_authorizations_flag );
2006:
2007: /**************************************
2008: ** SELECT AND INSERT ITEM DETAIL **
2009: **************************************/

Line 2130: ec_debug.pl ( 3, 'x_start_date: ',x_start_date );

2126:
2127: x_start_date := rec_hdr.forecast_horizon_start_date;
2128:
2129: END IF;
2130: ec_debug.pl ( 3, 'x_start_date: ',x_start_date );
2131:
2132: xProgress := 'SPSOB-30-1110';
2133:
2134: <>

Line 2204: ec_debug.pl ( 3, 'x_item_detail_sequence: ',x_item_detail_sequence );

2200:
2201: -- increment detail record sequence counter
2202:
2203: x_item_detail_sequence := NVL(x_item_detail_sequence,0) + 1;
2204: ec_debug.pl ( 3, 'x_item_detail_sequence: ',x_item_detail_sequence );
2205:
2206: xProgress := 'SPSOB-30-1140';
2207:
2208: -- DEBUG Sri's proc package name may chg

Line 2223: ec_debug.pl ( 3, 'x_shipment_num: ',x_shipment_num );

2219: -- the following UPDATE is added for version 2.0
2220: -- ***************************
2221:
2222: xProgress := 'SPSOB-30-1150';
2223: ec_debug.pl ( 3, 'x_shipment_num: ',x_shipment_num );
2224: ec_debug.pl ( 3, 'x_transaction_date: ',x_transaction_date );
2225: ec_debug.pl ( 3, 'x_last_quantity: ',x_last_quantity );
2226:
2227: UPDATE ece_spso_items

Line 2224: ec_debug.pl ( 3, 'x_transaction_date: ',x_transaction_date );

2220: -- ***************************
2221:
2222: xProgress := 'SPSOB-30-1150';
2223: ec_debug.pl ( 3, 'x_shipment_num: ',x_shipment_num );
2224: ec_debug.pl ( 3, 'x_transaction_date: ',x_transaction_date );
2225: ec_debug.pl ( 3, 'x_last_quantity: ',x_last_quantity );
2226:
2227: UPDATE ece_spso_items
2228: SET last_receipt_shipment_code = x_shipment_num,

Line 2225: ec_debug.pl ( 3, 'x_last_quantity: ',x_last_quantity );

2221:
2222: xProgress := 'SPSOB-30-1150';
2223: ec_debug.pl ( 3, 'x_shipment_num: ',x_shipment_num );
2224: ec_debug.pl ( 3, 'x_transaction_date: ',x_transaction_date );
2225: ec_debug.pl ( 3, 'x_last_quantity: ',x_last_quantity );
2226:
2227: UPDATE ece_spso_items
2228: SET last_receipt_shipment_code = x_shipment_num,
2229: last_receipt_date = x_transaction_date,

Line 2293: ec_debug.pl ( 3, 'x_item_detail_sequence: ',x_item_detail_sequence );

2289:
2290: -- increment detail record sequence counter
2291:
2292: x_item_detail_sequence := NVL(x_item_detail_sequence,0) + 1;
2293: ec_debug.pl ( 3, 'x_item_detail_sequence: ',x_item_detail_sequence );
2294:
2295: xProgress := 'SPSOB-30-1180';
2296:
2297: INSERT INTO ece_spso_item_det

Line 2345: ec_debug.pl ( 3, 'rec_item.starting_cum_quantity: ',NVL(rec_item.starting_cum_quantity,0) );

2341: -- the following UPDATE is added for version 2.0
2342: -- ***************************
2343:
2344: xProgress := 'SPSOB-30-1190';
2345: ec_debug.pl ( 3, 'rec_item.starting_cum_quantity: ',NVL(rec_item.starting_cum_quantity,0) );
2346: UPDATE ece_spso_items
2347: SET last_receipt_cum_qty = NVL(rec_item.starting_cum_quantity,0)
2348: WHERE transaction_record_id = x_transaction_record_id;
2349: END IF;

Line 2354: ec_debug.pl ( 0,

2350:
2351: EXCEPTION
2352: WHEN OTHERS THEN
2353:
2354: ec_debug.pl ( 0,
2355: 'EC',
2356: 'ECE_PROGRAM_ERROR',
2357: 'PROGRESS_LEVEL',
2358: xProgress );

Line 2360: ec_debug.pl ( 0,

2356: 'ECE_PROGRAM_ERROR',
2357: 'PROGRESS_LEVEL',
2358: xProgress );
2359:
2360: ec_debug.pl ( 0,
2361: 'EC',
2362: 'ECE_ERROR_MESSAGE',
2363: 'ERROR_MESSAGE',
2364: SQLERRM );

Line 2377: ec_debug.pl ( 0,

2373:
2374: EXCEPTION
2375: WHEN OTHERS THEN
2376:
2377: ec_debug.pl ( 0,
2378: 'EC',
2379: 'ECE_PROGRAM_ERROR',
2380: 'PROGRESS_LEVEL',
2381: xProgress );

Line 2383: ec_debug.pl ( 0,

2379: 'ECE_PROGRAM_ERROR',
2380: 'PROGRESS_LEVEL',
2381: xProgress );
2382:
2383: ec_debug.pl ( 0,
2384: 'EC',
2385: 'ECE_ERROR_MESSAGE',
2386: 'ERROR_MESSAGE',
2387: SQLERRM );

Line 2395: ec_debug.pop ( 'ece_spso_trans1.Populate_Supplier_Sched_API3' );

2391: END; -- item block
2392:
2393: END LOOP header; -- header for loop
2394:
2395: ec_debug.pop ( 'ece_spso_trans1.Populate_Supplier_Sched_API3' );
2396:
2397: EXCEPTION
2398: WHEN OTHERS THEN
2399:

Line 2400: ec_debug.pl ( 0,

2396:
2397: EXCEPTION
2398: WHEN OTHERS THEN
2399:
2400: ec_debug.pl ( 0,
2401: 'EC',
2402: 'ECE_PROGRAM_ERROR',
2403: 'PROGRESS_LEVEL',
2404: xProgress );

Line 2406: ec_debug.pl ( 0,

2402: 'ECE_PROGRAM_ERROR',
2403: 'PROGRESS_LEVEL',
2404: xProgress );
2405:
2406: ec_debug.pl ( 0,
2407: 'EC',
2408: 'ECE_ERROR_MESSAGE',
2409: 'ERROR_MESSAGE',
2410: SQLERRM );

Line 2438: ec_debug.push ( 'ECE_SPSO_TRANS1.UPDATE_CHV_SCHEDULE_HEADERS' );

2434: cOutput_path varchar2(120);
2435:
2436: BEGIN
2437:
2438: ec_debug.push ( 'ECE_SPSO_TRANS1.UPDATE_CHV_SCHEDULE_HEADERS' );
2439: ec_debug.pl ( 3, 'p_transaction_type: ',p_transaction_type );
2440: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );
2441: ec_debug.pl ( 3, 'p_edi_count: ',p_edi_count );
2442:

Line 2439: ec_debug.pl ( 3, 'p_transaction_type: ',p_transaction_type );

2435:
2436: BEGIN
2437:
2438: ec_debug.push ( 'ECE_SPSO_TRANS1.UPDATE_CHV_SCHEDULE_HEADERS' );
2439: ec_debug.pl ( 3, 'p_transaction_type: ',p_transaction_type );
2440: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );
2441: ec_debug.pl ( 3, 'p_edi_count: ',p_edi_count );
2442:
2443: -- Retreive the system profile option ECE_OUT_FILE_PATH. This will

Line 2440: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );

2436: BEGIN
2437:
2438: ec_debug.push ( 'ECE_SPSO_TRANS1.UPDATE_CHV_SCHEDULE_HEADERS' );
2439: ec_debug.pl ( 3, 'p_transaction_type: ',p_transaction_type );
2440: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );
2441: ec_debug.pl ( 3, 'p_edi_count: ',p_edi_count );
2442:
2443: -- Retreive the system profile option ECE_OUT_FILE_PATH. This will
2444: -- be the directory where the output file will be written.

Line 2441: ec_debug.pl ( 3, 'p_edi_count: ',p_edi_count );

2437:
2438: ec_debug.push ( 'ECE_SPSO_TRANS1.UPDATE_CHV_SCHEDULE_HEADERS' );
2439: ec_debug.pl ( 3, 'p_transaction_type: ',p_transaction_type );
2440: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );
2441: ec_debug.pl ( 3, 'p_edi_count: ',p_edi_count );
2442:
2443: -- Retreive the system profile option ECE_OUT_FILE_PATH. This will
2444: -- be the directory where the output file will be written.
2445: -- NOTE: THIS DIRECTORY MUST BE SPECIFIED IN THE PARAMETER utl_file_dir IN

Line 2453: ec_debug.pl ( 3, 'cOutput_path: ',cOutput_path );

2449: xProgress := 'SPSOB-40-0100';
2450: fnd_profile.get ( 'ECE_OUT_FILE_PATH',
2451: cOutput_path );
2452:
2453: ec_debug.pl ( 3, 'cOutput_path: ',cOutput_path );
2454:
2455: xProgress := 'SPSOB-40-1000';
2456:
2457: UPDATE chv_schedule_headers

Line 2476: ec_debug.pop ( 'ECE_SPSO_TRANS1.UPDATE_CHV_SCHEDULE_HEADERS' );

2472: AND p_transaction_type = DECODE ( schedule_type,
2473: 'SHIP_SCHEDULE', 'SSSO',
2474: 'SPSO' )
2475: AND batch_id = decode(p_batch_id,0,batch_id,p_batch_id); -- Bug 2064311
2476: ec_debug.pop ( 'ECE_SPSO_TRANS1.UPDATE_CHV_SCHEDULE_HEADERS' );
2477:
2478: EXCEPTION
2479: WHEN OTHERS THEN
2480: ec_debug.pl ( 0,

Line 2480: ec_debug.pl ( 0,

2476: ec_debug.pop ( 'ECE_SPSO_TRANS1.UPDATE_CHV_SCHEDULE_HEADERS' );
2477:
2478: EXCEPTION
2479: WHEN OTHERS THEN
2480: ec_debug.pl ( 0,
2481: 'EC',
2482: 'ECE_PROGRAM_ERROR',
2483: 'PROGRESS_LEVEL',
2484: xProgress );

Line 2486: ec_debug.pl ( 0,

2482: 'ECE_PROGRAM_ERROR',
2483: 'PROGRESS_LEVEL',
2484: xProgress );
2485:
2486: ec_debug.pl ( 0,
2487: 'EC',
2488: 'ECE_ERROR_MESSAGE',
2489: 'ERROR_MESSAGE',
2490: SQLERRM );

Line 2620: ec_debug.push ( 'ECE_SPSO_TRANS1.PUT_DATA_TO_OUTPUT_TABLE' );

2616: c_header_select VARCHAR2(100);
2617:
2618: BEGIN
2619:
2620: ec_debug.push ( 'ECE_SPSO_TRANS1.PUT_DATA_TO_OUTPUT_TABLE' );
2621: ec_debug.pl ( 3, 'p_communication_method: ', p_communication_method );
2622: ec_debug.pl ( 3, 'p_transaction_type: ',p_transaction_type );
2623: ec_debug.pl ( 3, 'p_output_width: ',p_output_width );
2624: ec_debug.pl ( 3, 'p_run_id: ',p_run_id );

Line 2621: ec_debug.pl ( 3, 'p_communication_method: ', p_communication_method );

2617:
2618: BEGIN
2619:
2620: ec_debug.push ( 'ECE_SPSO_TRANS1.PUT_DATA_TO_OUTPUT_TABLE' );
2621: ec_debug.pl ( 3, 'p_communication_method: ', p_communication_method );
2622: ec_debug.pl ( 3, 'p_transaction_type: ',p_transaction_type );
2623: ec_debug.pl ( 3, 'p_output_width: ',p_output_width );
2624: ec_debug.pl ( 3, 'p_run_id: ',p_run_id );
2625: ec_debug.pl ( 3, 'p_header_interface: ',p_header_interface );

Line 2622: ec_debug.pl ( 3, 'p_transaction_type: ',p_transaction_type );

2618: BEGIN
2619:
2620: ec_debug.push ( 'ECE_SPSO_TRANS1.PUT_DATA_TO_OUTPUT_TABLE' );
2621: ec_debug.pl ( 3, 'p_communication_method: ', p_communication_method );
2622: ec_debug.pl ( 3, 'p_transaction_type: ',p_transaction_type );
2623: ec_debug.pl ( 3, 'p_output_width: ',p_output_width );
2624: ec_debug.pl ( 3, 'p_run_id: ',p_run_id );
2625: ec_debug.pl ( 3, 'p_header_interface: ',p_header_interface );
2626: ec_debug.pl ( 3, 'p_item_interface: ',p_item_interface );

Line 2623: ec_debug.pl ( 3, 'p_output_width: ',p_output_width );

2619:
2620: ec_debug.push ( 'ECE_SPSO_TRANS1.PUT_DATA_TO_OUTPUT_TABLE' );
2621: ec_debug.pl ( 3, 'p_communication_method: ', p_communication_method );
2622: ec_debug.pl ( 3, 'p_transaction_type: ',p_transaction_type );
2623: ec_debug.pl ( 3, 'p_output_width: ',p_output_width );
2624: ec_debug.pl ( 3, 'p_run_id: ',p_run_id );
2625: ec_debug.pl ( 3, 'p_header_interface: ',p_header_interface );
2626: ec_debug.pl ( 3, 'p_item_interface: ',p_item_interface );
2627: ec_debug.pl ( 3, 'p_item_d_interface: ',p_item_d_interface );

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

2620: ec_debug.push ( 'ECE_SPSO_TRANS1.PUT_DATA_TO_OUTPUT_TABLE' );
2621: ec_debug.pl ( 3, 'p_communication_method: ', p_communication_method );
2622: ec_debug.pl ( 3, 'p_transaction_type: ',p_transaction_type );
2623: ec_debug.pl ( 3, 'p_output_width: ',p_output_width );
2624: ec_debug.pl ( 3, 'p_run_id: ',p_run_id );
2625: ec_debug.pl ( 3, 'p_header_interface: ',p_header_interface );
2626: ec_debug.pl ( 3, 'p_item_interface: ',p_item_interface );
2627: ec_debug.pl ( 3, 'p_item_d_interface: ',p_item_d_interface );
2628: ec_debug.pl ( 3, 'p_ship_d_interface: ',p_ship_d_interface );

Line 2625: ec_debug.pl ( 3, 'p_header_interface: ',p_header_interface );

2621: ec_debug.pl ( 3, 'p_communication_method: ', p_communication_method );
2622: ec_debug.pl ( 3, 'p_transaction_type: ',p_transaction_type );
2623: ec_debug.pl ( 3, 'p_output_width: ',p_output_width );
2624: ec_debug.pl ( 3, 'p_run_id: ',p_run_id );
2625: ec_debug.pl ( 3, 'p_header_interface: ',p_header_interface );
2626: ec_debug.pl ( 3, 'p_item_interface: ',p_item_interface );
2627: ec_debug.pl ( 3, 'p_item_d_interface: ',p_item_d_interface );
2628: ec_debug.pl ( 3, 'p_ship_d_interface: ',p_ship_d_interface );
2629:

Line 2626: ec_debug.pl ( 3, 'p_item_interface: ',p_item_interface );

2622: ec_debug.pl ( 3, 'p_transaction_type: ',p_transaction_type );
2623: ec_debug.pl ( 3, 'p_output_width: ',p_output_width );
2624: ec_debug.pl ( 3, 'p_run_id: ',p_run_id );
2625: ec_debug.pl ( 3, 'p_header_interface: ',p_header_interface );
2626: ec_debug.pl ( 3, 'p_item_interface: ',p_item_interface );
2627: ec_debug.pl ( 3, 'p_item_d_interface: ',p_item_d_interface );
2628: ec_debug.pl ( 3, 'p_ship_d_interface: ',p_ship_d_interface );
2629:
2630: -- Retreive the system profile option ECE_OUT_FILE_PATH. This will

Line 2627: ec_debug.pl ( 3, 'p_item_d_interface: ',p_item_d_interface );

2623: ec_debug.pl ( 3, 'p_output_width: ',p_output_width );
2624: ec_debug.pl ( 3, 'p_run_id: ',p_run_id );
2625: ec_debug.pl ( 3, 'p_header_interface: ',p_header_interface );
2626: ec_debug.pl ( 3, 'p_item_interface: ',p_item_interface );
2627: ec_debug.pl ( 3, 'p_item_d_interface: ',p_item_d_interface );
2628: ec_debug.pl ( 3, 'p_ship_d_interface: ',p_ship_d_interface );
2629:
2630: -- Retreive the system profile option ECE_OUT_FILE_PATH. This will
2631: -- be the directory where the output file will be written.

Line 2628: ec_debug.pl ( 3, 'p_ship_d_interface: ',p_ship_d_interface );

2624: ec_debug.pl ( 3, 'p_run_id: ',p_run_id );
2625: ec_debug.pl ( 3, 'p_header_interface: ',p_header_interface );
2626: ec_debug.pl ( 3, 'p_item_interface: ',p_item_interface );
2627: ec_debug.pl ( 3, 'p_item_d_interface: ',p_item_d_interface );
2628: ec_debug.pl ( 3, 'p_ship_d_interface: ',p_ship_d_interface );
2629:
2630: -- Retreive the system profile option ECE_OUT_FILE_PATH. This will
2631: -- be the directory where the output file will be written.
2632: -- NOTE: THIS DIRECTORY MUST BE SPECIFIED IN THE PARAMETER utl_file_dir IN

Line 2639: ec_debug.pl ( 3, 'cOutput_path: ',cOutput_path );

2635:
2636: xProgress := 'SPSOB-50-0100';
2637: fnd_profile.get ( 'ECE_OUT_FILE_PATH',
2638: cOutput_path );
2639: ec_debug.pl ( 3, 'cOutput_path: ',cOutput_path );
2640:
2641: /* --------------------------------------------------------------------------
2642: -- Here, I am building the SELECT, FROM, and WHERE clauses for the dynamic
2643: -- SQL call

Line 2747: ec_debug.pl ( 3, 'x_header_where: ',x_header_where );

2743: p_header_interface ||
2744: '.RUN_ID =' ||
2745: ':l_p_run_id';
2746:
2747: ec_debug.pl ( 3, 'x_header_where: ',x_header_where );
2748:
2749: xProgress := 'SPSOB-50-1040';
2750: x_item_where := x_item_where ||
2751: ' AND ' ||

Line 2768: ec_debug.pl ( 3, 'x_item_where: ',x_item_where );

2764: '.ITEM_NUMBER, ' ||
2765: p_item_interface ||
2766: '.SHIP_TO_ORG_CODE';
2767:
2768: ec_debug.pl ( 3, 'x_item_where: ',x_item_where );
2769:
2770: xProgress := 'SPSOB-50-1050';
2771: x_item_d_where := x_item_d_where ||
2772: ' AND ' ||

Line 2788: ec_debug.pl ( 3, 'x_item_d_where: ',x_item_d_where );

2784: '.SCHEDULE_ID, ' ||
2785: p_item_d_interface ||
2786: '.SCHEDULE_ITEM_DETAIL_SEQUENCE';
2787:
2788: ec_debug.pl ( 3, 'x_item_d_where: ',x_item_d_where );
2789: xProgress := 'SPSOB-50-1055';
2790: if (p_transaction_type = 'SSSO') then
2791: x_ship_d_where := x_ship_d_where ||
2792: ' AND ' ||

Line 2813: ec_debug.pl ( 3, 'x_ship_d_where: ',x_ship_d_where );

2809: p_ship_d_interface ||
2810: '.SCHEDULE_SHIP_ID';
2811:
2812:
2813: ec_debug.pl ( 3, 'x_ship_d_where: ',x_ship_d_where );
2814:
2815: end if;
2816:
2817: xProgress := 'SPSOB-50-1060';

Line 2827: ec_debug.pl ( 3, 'x_header_select: ',x_header_select );

2823: '.ROWID,' ||
2824: p_header_interface ||
2825: '.SCHEDULE_ID' ;
2826:
2827: ec_debug.pl ( 3, 'x_header_select: ',x_header_select );
2828:
2829: xProgress := 'SPSOB-50-1070';
2830: x_item_select := x_item_select ||
2831: ',' ||

Line 2839: ec_debug.pl ( 3, 'x_item_select: ',x_item_select );

2835: '.ROWID,' ||
2836: p_item_interface ||
2837: '.SCHEDULE_ITEM_ID' ;
2838:
2839: ec_debug.pl ( 3, 'x_item_select: ',x_item_select );
2840:
2841: xProgress := 'SPSOB-50-1080';
2842: x_item_d_select := x_item_d_select ||
2843: ',' ||

Line 2851: ec_debug.pl ( 3, 'x_item_d_select: ',x_item_d_select );

2847: '.ROWID, ' ||
2848: p_item_d_interface ||
2849: '.SCHEDULE_ITEM_DETAIL_SEQUENCE';
2850:
2851: ec_debug.pl ( 3, 'x_item_d_select: ',x_item_d_select );
2852:
2853: xProgress := 'SPSOB-50-1085';
2854: if (p_transaction_type = 'SSSO') then
2855: x_ship_d_select := x_ship_d_select ||

Line 2862: ec_debug.pl ( 3, 'x_ship_d_select: ',x_ship_d_select );

2858: '.ROWID,' ||
2859: x_ship_d_x_interface ||
2860: '.ROWID';
2861:
2862: ec_debug.pl ( 3, 'x_ship_d_select: ',x_ship_d_select );
2863: end if;
2864:
2865: xProgress := 'SPSOB-50-1090';
2866: x_header_select := x_header_select ||

Line 2871: ec_debug.pl ( 3, 'x_header_select: ',x_header_select);

2867: x_header_from ||
2868: x_header_where ||
2869: ' FOR UPDATE';
2870:
2871: ec_debug.pl ( 3, 'x_header_select: ',x_header_select);
2872:
2873: xProgress := 'SPSOB-50-1100';
2874: x_item_select := x_item_select || x_item_from || x_item_where;
2875: ec_debug.pl ( 3, 'x_item_select: ',x_item_select);

Line 2875: ec_debug.pl ( 3, 'x_item_select: ',x_item_select);

2871: ec_debug.pl ( 3, 'x_header_select: ',x_header_select);
2872:
2873: xProgress := 'SPSOB-50-1100';
2874: x_item_select := x_item_select || x_item_from || x_item_where;
2875: ec_debug.pl ( 3, 'x_item_select: ',x_item_select);
2876:
2877: xProgress := 'SPSOB-50-1110';
2878: x_item_d_select := x_item_d_select ||
2879: x_item_d_from ||

Line 2882: ec_debug.pl ( 3, 'x_item_d_select: ',x_item_d_select );

2878: x_item_d_select := x_item_d_select ||
2879: x_item_d_from ||
2880: x_item_d_where ;
2881:
2882: ec_debug.pl ( 3, 'x_item_d_select: ',x_item_d_select );
2883:
2884: xProgress := 'SPSOB-50-1115';
2885: if (p_transaction_type = 'SSSO') then
2886: x_ship_d_select := x_ship_d_select ||

Line 2889: ec_debug.pl ( 3, 'x_ship_d_select: ',x_ship_d_select );

2885: if (p_transaction_type = 'SSSO') then
2886: x_ship_d_select := x_ship_d_select ||
2887: x_ship_d_from ||
2888: x_ship_d_where ;
2889: ec_debug.pl ( 3, 'x_ship_d_select: ',x_ship_d_select );
2890: end if;
2891:
2892: xProgress := 'SPSOB-50-1120';
2893: x_header_delete1 := 'DELETE FROM ' ||

Line 2897: ec_debug.pl ( 3, 'x_header_delete1: ',x_header_delete1 );

2893: x_header_delete1 := 'DELETE FROM ' ||
2894: p_header_interface ||
2895: ' WHERE ROWID = :col_rowid';
2896:
2897: ec_debug.pl ( 3, 'x_header_delete1: ',x_header_delete1 );
2898:
2899: xProgress := 'SPSOB-50-1130';
2900: x_item_delete1 := 'DELETE FROM ' ||
2901: p_item_interface ||

Line 2904: ec_debug.pl ( 3, 'x_item_delete1: ',x_item_delete1 );

2900: x_item_delete1 := 'DELETE FROM ' ||
2901: p_item_interface ||
2902: ' WHERE ROWID = :col_rowid';
2903:
2904: ec_debug.pl ( 3, 'x_item_delete1: ',x_item_delete1 );
2905:
2906: xProgress := 'SPSOB-50-1140';
2907: x_item_d_delete1 := 'DELETE FROM ' ||
2908: p_item_d_interface ||

Line 2911: ec_debug.pl ( 3, 'x_item_d_delete1: ',x_item_d_delete1 );

2907: x_item_d_delete1 := 'DELETE FROM ' ||
2908: p_item_d_interface ||
2909: ' WHERE ROWID = :col_rowid';
2910:
2911: ec_debug.pl ( 3, 'x_item_d_delete1: ',x_item_d_delete1 );
2912:
2913: xProgress := 'SPSOB-50-1145';
2914: if (p_transaction_type = 'SSSO') then
2915: x_ship_d_delete1 := 'DELETE FROM ' ||

Line 2918: ec_debug.pl ( 3, 'x_ship_d_delete1: ',x_ship_d_delete1 );

2914: if (p_transaction_type = 'SSSO') then
2915: x_ship_d_delete1 := 'DELETE FROM ' ||
2916: p_ship_d_interface ||
2917: ' WHERE ROWID = :col_rowid';
2918: ec_debug.pl ( 3, 'x_ship_d_delete1: ',x_ship_d_delete1 );
2919: end if;
2920:
2921: xProgress := 'SPSOB-50-1150';
2922: x_header_delete2 := 'DELETE FROM ' ||

Line 2926: ec_debug.pl ( 3, 'x_header_delete2: ',x_header_delete2 );

2922: x_header_delete2 := 'DELETE FROM ' ||
2923: x_header_x_interface ||
2924: ' WHERE ROWID = :col_rowid';
2925:
2926: ec_debug.pl ( 3, 'x_header_delete2: ',x_header_delete2 );
2927:
2928: xProgress := 'SPSOB-50-1160';
2929: x_item_delete2 := 'DELETE FROM ' ||
2930: x_item_x_interface ||

Line 2933: ec_debug.pl ( 3, 'x_item_delete2: ',x_item_delete2 );

2929: x_item_delete2 := 'DELETE FROM ' ||
2930: x_item_x_interface ||
2931: ' WHERE ROWID = :col_rowid';
2932:
2933: ec_debug.pl ( 3, 'x_item_delete2: ',x_item_delete2 );
2934:
2935: xProgress := 'SPSOB-50-1170';
2936: x_item_d_delete2 := 'DELETE FROM ' ||
2937: x_item_d_x_interface ||

Line 2941: ec_debug.pl ( 3, 'x_item_d_delete2: ',x_item_d_delete2 );

2937: x_item_d_x_interface ||
2938: ' WHERE ROWID = :col_rowid';
2939:
2940:
2941: ec_debug.pl ( 3, 'x_item_d_delete2: ',x_item_d_delete2 );
2942:
2943: xProgress := 'SPSOB-50-1175';
2944: if (p_transaction_type = 'SSSO') then
2945: x_ship_d_delete2 := 'DELETE FROM ' ||

Line 3155: ec_debug.pl ( 3, 'x_header_count: ',x_header_count );

3151: -- *************************************************
3152:
3153: xProgress := 'SPSOB-50-1360';
3154: x_header_count := l_header_tbl.count;
3155: ec_debug.pl ( 3, 'x_header_count: ',x_header_count );
3156:
3157: xProgress := 'SPSOB-50-1370';
3158: x_item_count := l_item_tbl.count;
3159: ec_debug.pl ( 3, 'x_item_count: ',x_item_count );

Line 3159: ec_debug.pl ( 3, 'x_item_count: ',x_item_count );

3155: ec_debug.pl ( 3, 'x_header_count: ',x_header_count );
3156:
3157: xProgress := 'SPSOB-50-1370';
3158: x_item_count := l_item_tbl.count;
3159: ec_debug.pl ( 3, 'x_item_count: ',x_item_count );
3160:
3161: xProgress := 'SPSOB-50-1380';
3162: x_item_d_count := l_item_d_tbl.count;
3163: ec_debug.pl ( 3, 'x_item_d_count: ',x_item_d_count );

Line 3163: ec_debug.pl ( 3, 'x_item_d_count: ',x_item_d_count );

3159: ec_debug.pl ( 3, 'x_item_count: ',x_item_count );
3160:
3161: xProgress := 'SPSOB-50-1380';
3162: x_item_d_count := l_item_d_tbl.count;
3163: ec_debug.pl ( 3, 'x_item_d_count: ',x_item_d_count );
3164:
3165: xProgress := 'SPSOB-50-1380';
3166: if (p_transaction_type = 'SSSO') then
3167: x_ship_d_count := l_ship_d_tbl.count;

Line 3168: ec_debug.pl ( 3, 'x_ship_d_count: ',x_ship_d_count );

3164:
3165: xProgress := 'SPSOB-50-1380';
3166: if (p_transaction_type = 'SSSO') then
3167: x_ship_d_count := l_ship_d_tbl.count;
3168: ec_debug.pl ( 3, 'x_ship_d_count: ',x_ship_d_count );
3169: end if;
3170: --******************************************************************
3171: --*** Define data TYPE for every columns in the SELECT statement **
3172: --******************************************************************

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

3303:
3304: xProgress := 'SPSOB-50-1510';
3305: nTrans_code_pos := ece_flatfile_pvt.POS_OF ( l_header_tbl,
3306: ece_flatfile_pvt.G_Translator_Code );
3307: ec_debug.pl ( 3, 'nTrans_code_pos: ',nTrans_code_pos );
3308:
3309: xProgress := 'SPSOB-50-1520';
3310: nHeader_key_pos := ece_flatfile_pvt.POS_OF ( l_header_tbl,
3311: c_header_common_key_name );

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

3308:
3309: xProgress := 'SPSOB-50-1520';
3310: nHeader_key_pos := ece_flatfile_pvt.POS_OF ( l_header_tbl,
3311: c_header_common_key_name );
3312: ec_debug.pl ( 3, 'nHeader_key_pos: ',nHeader_key_pos );
3313:
3314: xProgress := 'SPSOB-50-1530';
3315: nItem_key_pos := ece_flatfile_pvt.POS_OF ( l_item_tbl,
3316: c_item_common_key_name );

Line 3317: ec_debug.pl ( 3, 'nItem_key_pos: ',nItem_key_pos);

3313:
3314: xProgress := 'SPSOB-50-1530';
3315: nItem_key_pos := ece_flatfile_pvt.POS_OF ( l_item_tbl,
3316: c_item_common_key_name );
3317: ec_debug.pl ( 3, 'nItem_key_pos: ',nItem_key_pos);
3318:
3319: xProgress := 'SPSOB-50-1540';
3320: nItem_d_key_pos := ece_flatfile_pvt.POS_OF ( l_item_d_tbl,
3321: c_item_d_common_key_name );

Line 3322: ec_debug.pl ( 3, 'nItem_d_key_pos: ',nItem_d_key_pos );

3318:
3319: xProgress := 'SPSOB-50-1540';
3320: nItem_d_key_pos := ece_flatfile_pvt.POS_OF ( l_item_d_tbl,
3321: c_item_d_common_key_name );
3322: ec_debug.pl ( 3, 'nItem_d_key_pos: ',nItem_d_key_pos );
3323:
3324: xProgress := 'SPSOB-50-1545';
3325: if (p_transaction_type = 'SSSO') then
3326: nShip_d_key_pos := ece_flatfile_pvt.POS_OF( l_ship_d_tbl,

Line 3329: ec_debug.pl ( 3, 'nShip_d_key_pos: ',nShip_d_key_pos );

3325: if (p_transaction_type = 'SSSO') then
3326: nShip_d_key_pos := ece_flatfile_pvt.POS_OF( l_ship_d_tbl,
3327: c_ship_d_common_key_name );
3328:
3329: ec_debug.pl ( 3, 'nShip_d_key_pos: ',nShip_d_key_pos );
3330: end if;
3331:
3332: xProgress := 'SPSOB-50-1541';
3333: dbms_sql.bind_variable(v_header_sel_c,'l_p_run_id',p_run_id);

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

3403: 1, 22),
3404: 22) ||
3405: RPAD(' ',22) ||
3406: RPAD(' ',22);
3407: ec_debug.pl ( 3, 'c_file_common_key: ',c_file_common_key );
3408:
3409: xProgress := 'SPSOB-50-1630';
3410: ece_flatfile_pvt.write_to_ece_output ( p_transaction_type,
3411: p_communication_method,

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

3496: RPAD(SUBSTRB(NVL(l_item_tbl(nItem_key_pos).value,' '),
3497: 1, 22),
3498: 22) ||
3499: RPAD(' ',22);
3500: ec_debug.pl ( 3, 'c_file_common_key: ',c_file_common_key );
3501:
3502: xProgress := 'SPSOB-50-1730';
3503: ece_flatfile_pvt.write_to_ece_output ( p_transaction_type,
3504: p_communication_method,

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

3580: 22) ||
3581: RPAD(SUBSTRB(NVL(l_item_d_tbl(nItem_d_key_pos).value,' '),
3582: 1, 22),
3583: 22);
3584: ec_debug.pl ( 3, 'c_file_common_key: ',c_file_common_key );
3585:
3586: xProgress := 'SPSOB-50-1810';
3587: ece_flatfile_pvt.write_to_ece_output ( p_transaction_type,
3588: p_communication_method,

Line 3751: ec_debug.pop ( 'ece_spso_trans1.Put_Data_To_Output_Table' );

3747: if (p_transaction_type = 'SSSO') then
3748: dbms_sql.close_cursor ( v_ship_d_del_c1 );
3749: end if;
3750:
3751: ec_debug.pop ( 'ece_spso_trans1.Put_Data_To_Output_Table' );
3752:
3753: EXCEPTION
3754: WHEN OTHERS THEN
3755:

Line 3756: ec_debug.pl ( 0,

3752:
3753: EXCEPTION
3754: WHEN OTHERS THEN
3755:
3756: ec_debug.pl ( 0,
3757: 'EC',
3758: 'ECE_PROGRAM_ERROR',
3759: 'PROGRESS_LEVEL',
3760: xProgress );

Line 3762: ec_debug.pl ( 0,

3758: 'ECE_PROGRAM_ERROR',
3759: 'PROGRESS_LEVEL',
3760: xProgress );
3761:
3762: ec_debug.pl ( 0,
3763: 'EC',
3764: 'ECE_ERROR_MESSAGE',
3765: 'ERROR_MESSAGE',
3766: SQLERRM );