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_MVSTO_TRANSACTION dependencies on EC_DEBUG

Line 44: ec_debug.enable_debug(v_debug_mode);

40: ORDER BY line_id;
41:
42: BEGIN
43: xProgress := 'MVSTO-10-1000';
44: ec_debug.enable_debug(v_debug_mode);
45: ec_debug.push ('ECE_MVSTO_TRANSACTION.Extract_MVSTO_Outbound');
46: ec_debug.pl(3,'cOutput_Path: ',cOutput_Path);
47: ec_debug.pl(3,'cOutput_Filename: ',cOutput_Filename);
48: ec_debug.pl(3,'cLegal_Entity: ',cLegal_Entity);

Line 45: ec_debug.push ('ECE_MVSTO_TRANSACTION.Extract_MVSTO_Outbound');

41:
42: BEGIN
43: xProgress := 'MVSTO-10-1000';
44: ec_debug.enable_debug(v_debug_mode);
45: ec_debug.push ('ECE_MVSTO_TRANSACTION.Extract_MVSTO_Outbound');
46: ec_debug.pl(3,'cOutput_Path: ',cOutput_Path);
47: ec_debug.pl(3,'cOutput_Filename: ',cOutput_Filename);
48: ec_debug.pl(3,'cLegal_Entity: ',cLegal_Entity);
49: ec_debug.pl(3,'cZone_Code: ',cZone_Code);

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

42: BEGIN
43: xProgress := 'MVSTO-10-1000';
44: ec_debug.enable_debug(v_debug_mode);
45: ec_debug.push ('ECE_MVSTO_TRANSACTION.Extract_MVSTO_Outbound');
46: ec_debug.pl(3,'cOutput_Path: ',cOutput_Path);
47: ec_debug.pl(3,'cOutput_Filename: ',cOutput_Filename);
48: ec_debug.pl(3,'cLegal_Entity: ',cLegal_Entity);
49: ec_debug.pl(3,'cZone_Code: ',cZone_Code);
50: ec_debug.pl(3,'cStat_Type: ',cStat_Type);

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

43: xProgress := 'MVSTO-10-1000';
44: ec_debug.enable_debug(v_debug_mode);
45: ec_debug.push ('ECE_MVSTO_TRANSACTION.Extract_MVSTO_Outbound');
46: ec_debug.pl(3,'cOutput_Path: ',cOutput_Path);
47: ec_debug.pl(3,'cOutput_Filename: ',cOutput_Filename);
48: ec_debug.pl(3,'cLegal_Entity: ',cLegal_Entity);
49: ec_debug.pl(3,'cZone_Code: ',cZone_Code);
50: ec_debug.pl(3,'cStat_Type: ',cStat_Type);
51: ec_debug.pl(3,'cPeriod_Name: ',cPeriod_Name);

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

44: ec_debug.enable_debug(v_debug_mode);
45: ec_debug.push ('ECE_MVSTO_TRANSACTION.Extract_MVSTO_Outbound');
46: ec_debug.pl(3,'cOutput_Path: ',cOutput_Path);
47: ec_debug.pl(3,'cOutput_Filename: ',cOutput_Filename);
48: ec_debug.pl(3,'cLegal_Entity: ',cLegal_Entity);
49: ec_debug.pl(3,'cZone_Code: ',cZone_Code);
50: ec_debug.pl(3,'cStat_Type: ',cStat_Type);
51: ec_debug.pl(3,'cPeriod_Name: ',cPeriod_Name);
52: ec_debug.pl(3,'cMovement_Type: ',cMovement_Type);

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

45: ec_debug.push ('ECE_MVSTO_TRANSACTION.Extract_MVSTO_Outbound');
46: ec_debug.pl(3,'cOutput_Path: ',cOutput_Path);
47: ec_debug.pl(3,'cOutput_Filename: ',cOutput_Filename);
48: ec_debug.pl(3,'cLegal_Entity: ',cLegal_Entity);
49: ec_debug.pl(3,'cZone_Code: ',cZone_Code);
50: ec_debug.pl(3,'cStat_Type: ',cStat_Type);
51: ec_debug.pl(3,'cPeriod_Name: ',cPeriod_Name);
52: ec_debug.pl(3,'cMovement_Type: ',cMovement_Type);
53: ec_debug.pl(3,'cInclude_Address: ',cInclude_Address);

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

46: ec_debug.pl(3,'cOutput_Path: ',cOutput_Path);
47: ec_debug.pl(3,'cOutput_Filename: ',cOutput_Filename);
48: ec_debug.pl(3,'cLegal_Entity: ',cLegal_Entity);
49: ec_debug.pl(3,'cZone_Code: ',cZone_Code);
50: ec_debug.pl(3,'cStat_Type: ',cStat_Type);
51: ec_debug.pl(3,'cPeriod_Name: ',cPeriod_Name);
52: ec_debug.pl(3,'cMovement_Type: ',cMovement_Type);
53: ec_debug.pl(3,'cInclude_Address: ',cInclude_Address);
54: ec_debug.pl(3,'v_debug_mode: ',v_debug_mode);

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

47: ec_debug.pl(3,'cOutput_Filename: ',cOutput_Filename);
48: ec_debug.pl(3,'cLegal_Entity: ',cLegal_Entity);
49: ec_debug.pl(3,'cZone_Code: ',cZone_Code);
50: ec_debug.pl(3,'cStat_Type: ',cStat_Type);
51: ec_debug.pl(3,'cPeriod_Name: ',cPeriod_Name);
52: ec_debug.pl(3,'cMovement_Type: ',cMovement_Type);
53: ec_debug.pl(3,'cInclude_Address: ',cInclude_Address);
54: ec_debug.pl(3,'v_debug_mode: ',v_debug_mode);
55:

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

48: ec_debug.pl(3,'cLegal_Entity: ',cLegal_Entity);
49: ec_debug.pl(3,'cZone_Code: ',cZone_Code);
50: ec_debug.pl(3,'cStat_Type: ',cStat_Type);
51: ec_debug.pl(3,'cPeriod_Name: ',cPeriod_Name);
52: ec_debug.pl(3,'cMovement_Type: ',cMovement_Type);
53: ec_debug.pl(3,'cInclude_Address: ',cInclude_Address);
54: ec_debug.pl(3,'v_debug_mode: ',v_debug_mode);
55:
56: xProgress := 'MVSTO-10-1001';

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

49: ec_debug.pl(3,'cZone_Code: ',cZone_Code);
50: ec_debug.pl(3,'cStat_Type: ',cStat_Type);
51: ec_debug.pl(3,'cPeriod_Name: ',cPeriod_Name);
52: ec_debug.pl(3,'cMovement_Type: ',cMovement_Type);
53: ec_debug.pl(3,'cInclude_Address: ',cInclude_Address);
54: ec_debug.pl(3,'v_debug_mode: ',v_debug_mode);
55:
56: xProgress := 'MVSTO-10-1001';
57: fnd_profile.get('ECE_' || cTransaction_Type || '_ENABLED',cEnabled);

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

50: ec_debug.pl(3,'cStat_Type: ',cStat_Type);
51: ec_debug.pl(3,'cPeriod_Name: ',cPeriod_Name);
52: ec_debug.pl(3,'cMovement_Type: ',cMovement_Type);
53: ec_debug.pl(3,'cInclude_Address: ',cInclude_Address);
54: ec_debug.pl(3,'v_debug_mode: ',v_debug_mode);
55:
56: xProgress := 'MVSTO-10-1001';
57: fnd_profile.get('ECE_' || cTransaction_Type || '_ENABLED',cEnabled);
58:

Line 73: ec_debug.pl(0,

69: FROM dual;
70:
71: EXCEPTION
72: WHEN NO_DATA_FOUND THEN
73: ec_debug.pl(0,
74: 'EC',
75: 'ECE_GET_NEXT_SEQ_FAILED',
76: 'PROGRESS_LEVEL',
77: xProgress,

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

78: 'SEQ',
79: 'ECE_OUTPUT_RUNS_S');
80: END;
81:
82: ec_debug.pl(3, 'iRun_id: ',iRun_id);
83:
84: xProgress := 'MVSTO-10-1005';
85: ec_debug.pl(0,'EC','ECE_MVSTO_START',NULL);
86:

Line 85: ec_debug.pl(0,'EC','ECE_MVSTO_START',NULL);

81:
82: ec_debug.pl(3, 'iRun_id: ',iRun_id);
83:
84: xProgress := 'MVSTO-10-1005';
85: ec_debug.pl(0,'EC','ECE_MVSTO_START',NULL);
86:
87: xProgress := 'MVSTO-10-1010';
88: ec_debug.pl(0, 'EC', 'ECE_RUN_ID', 'RUN_ID', iRun_id);
89:

Line 88: ec_debug.pl(0, 'EC', 'ECE_RUN_ID', 'RUN_ID', iRun_id);

84: xProgress := 'MVSTO-10-1005';
85: ec_debug.pl(0,'EC','ECE_MVSTO_START',NULL);
86:
87: xProgress := 'MVSTO-10-1010';
88: ec_debug.pl(0, 'EC', 'ECE_RUN_ID', 'RUN_ID', iRun_id);
89:
90: xProgress := 'MVSTO-10-1020';
91: ece_mvsto_transaction.populate_mvsto_trx(cCommunication_Method,
92: cTransaction_Type,

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

140: 'W');
141: end if;
142: end if;
143: EXIT WHEN c_output%NOTFOUND;
144: ec_debug.pl(3, 'l_line_text: ',l_line_text);
145:
146: -- Write the data from ece_output to the output file.
147:
148: xProgress := 'MVSTO-10-1070';

Line 172: ec_debug.pl(0,

168: WHERE run_id = iRun_id;
169:
170: IF SQL%NOTFOUND
171: THEN
172: ec_debug.pl(0,
173: 'EC',
174: 'ECE_NO_ROW_DELETED',
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(cTransaction_Type) = 'U' THEN
182: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);
183: retcode := 1;
184: END IF;
185:
186: ec_debug.pl(0,'EC','ECE_MVSTO_END',NULL);

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

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

Line 187: ec_debug.pop('ECE_MVSTO_TRANSACTION.Extract_MVSTO_Outbound');

183: retcode := 1;
184: END IF;
185:
186: ec_debug.pl(0,'EC','ECE_MVSTO_END',NULL);
187: ec_debug.pop('ECE_MVSTO_TRANSACTION.Extract_MVSTO_Outbound');
188: ec_debug.disable_debug;
189: COMMIT;
190:
191: EXCEPTION

Line 188: ec_debug.disable_debug;

184: END IF;
185:
186: ec_debug.pl(0,'EC','ECE_MVSTO_END',NULL);
187: ec_debug.pop('ECE_MVSTO_TRANSACTION.Extract_MVSTO_Outbound');
188: ec_debug.disable_debug;
189: COMMIT;
190:
191: EXCEPTION
192: WHEN ece_transaction_disabled THEN

Line 193: ec_debug.pl(0,'EC','ECE_TRANSACTION_DISABLED','TRANSACTION',cTransaction_type);

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

Line 195: ec_debug.disable_debug;

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

Line 200: ec_debug.pl(0,

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

Line 205: ec_debug.pl(0,

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

Line 212: ec_debug.disable_debug;

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

Line 218: ec_debug.pl(0,

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

Line 223: ec_debug.pl(0,

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

Line 230: ec_debug.disable_debug;

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

Line 236: ec_debug.pl(0,

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

Line 241: ec_debug.pl(0,

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

Line 248: ec_debug.disable_debug;

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

Line 253: ec_debug.pl(0,

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

Line 258: ec_debug.pl(0,

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

Line 265: ec_debug.disable_debug;

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

Line 358: ec_debug.push('ECE_MVSTO_TRANSACTION.POPULATE_MVSTO_TRX');

354: msg_data VARCHAR2(20);
355:
356: BEGIN
357:
358: ec_debug.push('ECE_MVSTO_TRANSACTION.POPULATE_MVSTO_TRX');
359: ec_debug.pl(3, 'cCommunication_Method: ', cCommunication_Method);
360: ec_debug.pl(3, 'cTransaction_Type: ',cTransaction_Type);
361: ec_debug.pl(3, 'iOutput_width: ',iOutput_width);
362: ec_debug.pl(3, 'dTransaction_date: ',dTransaction_date);

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

355:
356: BEGIN
357:
358: ec_debug.push('ECE_MVSTO_TRANSACTION.POPULATE_MVSTO_TRX');
359: ec_debug.pl(3, 'cCommunication_Method: ', cCommunication_Method);
360: ec_debug.pl(3, 'cTransaction_Type: ',cTransaction_Type);
361: ec_debug.pl(3, 'iOutput_width: ',iOutput_width);
362: ec_debug.pl(3, 'dTransaction_date: ',dTransaction_date);
363: ec_debug.pl(3, 'iRun_id: ',iRun_id);

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

356: BEGIN
357:
358: ec_debug.push('ECE_MVSTO_TRANSACTION.POPULATE_MVSTO_TRX');
359: ec_debug.pl(3, 'cCommunication_Method: ', cCommunication_Method);
360: ec_debug.pl(3, 'cTransaction_Type: ',cTransaction_Type);
361: ec_debug.pl(3, 'iOutput_width: ',iOutput_width);
362: ec_debug.pl(3, 'dTransaction_date: ',dTransaction_date);
363: ec_debug.pl(3, 'iRun_id: ',iRun_id);
364: ec_debug.pl(3, 'cHeader_Interface: ',cHeader_Interface);

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

357:
358: ec_debug.push('ECE_MVSTO_TRANSACTION.POPULATE_MVSTO_TRX');
359: ec_debug.pl(3, 'cCommunication_Method: ', cCommunication_Method);
360: ec_debug.pl(3, 'cTransaction_Type: ',cTransaction_Type);
361: ec_debug.pl(3, 'iOutput_width: ',iOutput_width);
362: ec_debug.pl(3, 'dTransaction_date: ',dTransaction_date);
363: ec_debug.pl(3, 'iRun_id: ',iRun_id);
364: ec_debug.pl(3, 'cHeader_Interface: ',cHeader_Interface);
365: ec_debug.pl(3, 'cLine_Interface: ',cLine_Interface);

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

358: ec_debug.push('ECE_MVSTO_TRANSACTION.POPULATE_MVSTO_TRX');
359: ec_debug.pl(3, 'cCommunication_Method: ', cCommunication_Method);
360: ec_debug.pl(3, 'cTransaction_Type: ',cTransaction_Type);
361: ec_debug.pl(3, 'iOutput_width: ',iOutput_width);
362: ec_debug.pl(3, 'dTransaction_date: ',dTransaction_date);
363: ec_debug.pl(3, 'iRun_id: ',iRun_id);
364: ec_debug.pl(3, 'cHeader_Interface: ',cHeader_Interface);
365: ec_debug.pl(3, 'cLine_Interface: ',cLine_Interface);
366: ec_debug.pl(3, 'cLocation_Interface: ',cLocation_Interface);

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

359: ec_debug.pl(3, 'cCommunication_Method: ', cCommunication_Method);
360: ec_debug.pl(3, 'cTransaction_Type: ',cTransaction_Type);
361: ec_debug.pl(3, 'iOutput_width: ',iOutput_width);
362: ec_debug.pl(3, 'dTransaction_date: ',dTransaction_date);
363: ec_debug.pl(3, 'iRun_id: ',iRun_id);
364: ec_debug.pl(3, 'cHeader_Interface: ',cHeader_Interface);
365: ec_debug.pl(3, 'cLine_Interface: ',cLine_Interface);
366: ec_debug.pl(3, 'cLocation_Interface: ',cLocation_Interface);
367: ec_debug.pl(3,'cLegal_Entity: ',cLegal_Entity);

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

360: ec_debug.pl(3, 'cTransaction_Type: ',cTransaction_Type);
361: ec_debug.pl(3, 'iOutput_width: ',iOutput_width);
362: ec_debug.pl(3, 'dTransaction_date: ',dTransaction_date);
363: ec_debug.pl(3, 'iRun_id: ',iRun_id);
364: ec_debug.pl(3, 'cHeader_Interface: ',cHeader_Interface);
365: ec_debug.pl(3, 'cLine_Interface: ',cLine_Interface);
366: ec_debug.pl(3, 'cLocation_Interface: ',cLocation_Interface);
367: ec_debug.pl(3,'cLegal_Entity: ',cLegal_Entity);
368: ec_debug.pl(3,'cZone_Code: ',cZone_Code);

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

361: ec_debug.pl(3, 'iOutput_width: ',iOutput_width);
362: ec_debug.pl(3, 'dTransaction_date: ',dTransaction_date);
363: ec_debug.pl(3, 'iRun_id: ',iRun_id);
364: ec_debug.pl(3, 'cHeader_Interface: ',cHeader_Interface);
365: ec_debug.pl(3, 'cLine_Interface: ',cLine_Interface);
366: ec_debug.pl(3, 'cLocation_Interface: ',cLocation_Interface);
367: ec_debug.pl(3,'cLegal_Entity: ',cLegal_Entity);
368: ec_debug.pl(3,'cZone_Code: ',cZone_Code);
369: ec_debug.pl(3,'cStat_Type: ',cStat_Type);

Line 366: ec_debug.pl(3, 'cLocation_Interface: ',cLocation_Interface);

362: ec_debug.pl(3, 'dTransaction_date: ',dTransaction_date);
363: ec_debug.pl(3, 'iRun_id: ',iRun_id);
364: ec_debug.pl(3, 'cHeader_Interface: ',cHeader_Interface);
365: ec_debug.pl(3, 'cLine_Interface: ',cLine_Interface);
366: ec_debug.pl(3, 'cLocation_Interface: ',cLocation_Interface);
367: ec_debug.pl(3,'cLegal_Entity: ',cLegal_Entity);
368: ec_debug.pl(3,'cZone_Code: ',cZone_Code);
369: ec_debug.pl(3,'cStat_Type: ',cStat_Type);
370: ec_debug.pl(3,'cPeriod_Name: ',cPeriod_Name);

Line 367: ec_debug.pl(3,'cLegal_Entity: ',cLegal_Entity);

363: ec_debug.pl(3, 'iRun_id: ',iRun_id);
364: ec_debug.pl(3, 'cHeader_Interface: ',cHeader_Interface);
365: ec_debug.pl(3, 'cLine_Interface: ',cLine_Interface);
366: ec_debug.pl(3, 'cLocation_Interface: ',cLocation_Interface);
367: ec_debug.pl(3,'cLegal_Entity: ',cLegal_Entity);
368: ec_debug.pl(3,'cZone_Code: ',cZone_Code);
369: ec_debug.pl(3,'cStat_Type: ',cStat_Type);
370: ec_debug.pl(3,'cPeriod_Name: ',cPeriod_Name);
371: ec_debug.pl(3,'cMovement_Type: ',cMovement_Type);

Line 368: ec_debug.pl(3,'cZone_Code: ',cZone_Code);

364: ec_debug.pl(3, 'cHeader_Interface: ',cHeader_Interface);
365: ec_debug.pl(3, 'cLine_Interface: ',cLine_Interface);
366: ec_debug.pl(3, 'cLocation_Interface: ',cLocation_Interface);
367: ec_debug.pl(3,'cLegal_Entity: ',cLegal_Entity);
368: ec_debug.pl(3,'cZone_Code: ',cZone_Code);
369: ec_debug.pl(3,'cStat_Type: ',cStat_Type);
370: ec_debug.pl(3,'cPeriod_Name: ',cPeriod_Name);
371: ec_debug.pl(3,'cMovement_Type: ',cMovement_Type);
372: ec_debug.pl(3,'cInclude_Address: ',cInclude_Address);

Line 369: ec_debug.pl(3,'cStat_Type: ',cStat_Type);

365: ec_debug.pl(3, 'cLine_Interface: ',cLine_Interface);
366: ec_debug.pl(3, 'cLocation_Interface: ',cLocation_Interface);
367: ec_debug.pl(3,'cLegal_Entity: ',cLegal_Entity);
368: ec_debug.pl(3,'cZone_Code: ',cZone_Code);
369: ec_debug.pl(3,'cStat_Type: ',cStat_Type);
370: ec_debug.pl(3,'cPeriod_Name: ',cPeriod_Name);
371: ec_debug.pl(3,'cMovement_Type: ',cMovement_Type);
372: ec_debug.pl(3,'cInclude_Address: ',cInclude_Address);
373:

Line 370: ec_debug.pl(3,'cPeriod_Name: ',cPeriod_Name);

366: ec_debug.pl(3, 'cLocation_Interface: ',cLocation_Interface);
367: ec_debug.pl(3,'cLegal_Entity: ',cLegal_Entity);
368: ec_debug.pl(3,'cZone_Code: ',cZone_Code);
369: ec_debug.pl(3,'cStat_Type: ',cStat_Type);
370: ec_debug.pl(3,'cPeriod_Name: ',cPeriod_Name);
371: ec_debug.pl(3,'cMovement_Type: ',cMovement_Type);
372: ec_debug.pl(3,'cInclude_Address: ',cInclude_Address);
373:
374: /* build the EDI Transaction Reference value */

Line 371: ec_debug.pl(3,'cMovement_Type: ',cMovement_Type);

367: ec_debug.pl(3,'cLegal_Entity: ',cLegal_Entity);
368: ec_debug.pl(3,'cZone_Code: ',cZone_Code);
369: ec_debug.pl(3,'cStat_Type: ',cStat_Type);
370: ec_debug.pl(3,'cPeriod_Name: ',cPeriod_Name);
371: ec_debug.pl(3,'cMovement_Type: ',cMovement_Type);
372: ec_debug.pl(3,'cInclude_Address: ',cInclude_Address);
373:
374: /* build the EDI Transaction Reference value */
375: v_EdiTransactionRef := substrb(cLegal_Entity,1,14) || '-' ||

Line 372: ec_debug.pl(3,'cInclude_Address: ',cInclude_Address);

368: ec_debug.pl(3,'cZone_Code: ',cZone_Code);
369: ec_debug.pl(3,'cStat_Type: ',cStat_Type);
370: ec_debug.pl(3,'cPeriod_Name: ',cPeriod_Name);
371: ec_debug.pl(3,'cMovement_Type: ',cMovement_Type);
372: ec_debug.pl(3,'cInclude_Address: ',cInclude_Address);
373:
374: /* build the EDI Transaction Reference value */
375: v_EdiTransactionRef := substrb(cLegal_Entity,1,14) || '-' ||
376: substrb(cZone_Code,1,1) || '-' ||

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

551: xProgress := 'MVSTOB-20-1190';
552: cHeader_select := cHeader_select ||
553: cHeader_from ||
554: cHeader_where;
555: ec_debug.pl(3, 'cHeader_select: ',cHeader_select);
556:
557: cLine_select := cLine_select ||
558: cLine_from ||
559: cLine_where;

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

556:
557: cLine_select := cLine_select ||
558: cLine_from ||
559: cLine_where;
560: ec_debug.pl(3, 'cLine_select: ',cLine_select);
561:
562: cLocation_select := cLocation_select ||
563: cLocation_from ||
564: cLocation_where;

Line 565: ec_debug.pl(3, 'cLocation_select: ',cLocation_select);

561:
562: cLocation_select := cLocation_select ||
563: cLocation_from ||
564: cLocation_where;
565: ec_debug.pl(3, 'cLocation_select: ',cLocation_select);
566:
567: -- ***************************************************
568: -- *** Get data setup for the dynamic SQL call.
569: -- *** Open a cursor for each of the SELECT call

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

674: xProgress := 'MVSTOB-20-1320';
675: ece_extract_utils_pub.Find_pos(l_header_tbl,
676: ece_extract_utils_pub.G_Transaction_date,
677: n_trx_date_pos);
678: ec_debug.pl(3, 'n_trx_date_pos: ', n_trx_date_pos);
679:
680: -- Bind the Variables
681: xProgress := 'MVSTOB-20-1320';
682: IF cLegal_Entity IS NOT NULL THEN

Line 811: ec_debug.pl(0,

807: INTO l_header_fkey
808: FROM DUAL;
809: EXCEPTION
810: WHEN NO_DATA_FOUND THEN
811: ec_debug.pl(0,
812: 'EC',
813: 'ECE_GET_NEXT_SEQ_FAILED',
814: 'PROGRESS_LEVEL',
815: xProgress,

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

815: xProgress,
816: 'SEQ',
817: 'ECE_MVSTO_HEADER_S');
818: END;
819: ec_debug.pl(3, 'l_header_fkey: ',l_header_fkey);
820:
821: xProgress := 'MVSTOB-20-1490';
822: ece_Extract_Utils_PUB.insert_into_interface_tbl(iRun_id,
823: cTransaction_Type,

Line 865: ec_debug.pl(3, 'nBill_To_Site_pos: ',nBill_To_Site_pos);

861: xProgress := 'MVSTOB-20-1551';
862: ece_extract_utils_pub.Find_pos(l_line_tbl,
863: 'BILL_TO_SITE_USE_ID',
864: nBill_To_Site_pos);
865: ec_debug.pl(3, 'nBill_To_Site_pos: ',nBill_To_Site_pos);
866:
867: xProgress := 'MVSTOB-20-1552';
868: ece_extract_utils_pub.Find_pos(l_line_tbl,
869: 'SHIP_TO_SITE_USE_ID',

Line 871: ec_debug.pl(3, 'nShip_To_Site_pos: ',nShip_To_Site_pos);

867: xProgress := 'MVSTOB-20-1552';
868: ece_extract_utils_pub.Find_pos(l_line_tbl,
869: 'SHIP_TO_SITE_USE_ID',
870: nShip_To_Site_pos);
871: ec_debug.pl(3, 'nShip_To_Site_pos: ',nShip_To_Site_pos);
872:
873: xProgress := 'MVSTOB-20-1554';
874: ece_extract_utils_pub.Find_pos(l_line_tbl,
875: 'VENDOR_SITE_ID',

Line 877: ec_debug.pl(3, 'nVendor_To_Site_pos: ',nVendor_Site_pos);

873: xProgress := 'MVSTOB-20-1554';
874: ece_extract_utils_pub.Find_pos(l_line_tbl,
875: 'VENDOR_SITE_ID',
876: nVendor_Site_pos);
877: ec_debug.pl(3, 'nVendor_To_Site_pos: ',nVendor_Site_pos);
878:
879: xProgress := 'MVSTOB-20-1555';
880: ece_extract_utils_pub.Find_pos(l_line_tbl,
881: 'MOVEMENT_ID',

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

879: xProgress := 'MVSTOB-20-1555';
880: ece_extract_utils_pub.Find_pos(l_line_tbl,
881: 'MOVEMENT_ID',
882: nLine_key_pos);
883: ec_debug.pl(3, 'nLine_key_pos: ',nLine_key_pos);
884:
885: n_movement_id := l_line_tbl(nLine_key_pos).value;
886: ec_debug.pl(3, 'n_movement_id: ',n_movement_id);
887:

Line 886: ec_debug.pl(3, 'n_movement_id: ',n_movement_id);

882: nLine_key_pos);
883: ec_debug.pl(3, 'nLine_key_pos: ',nLine_key_pos);
884:
885: n_movement_id := l_line_tbl(nLine_key_pos).value;
886: ec_debug.pl(3, 'n_movement_id: ',n_movement_id);
887:
888: xProgress := 'MVSTOB-20-1555';
889: ece_extract_utils_pub.Find_pos(l_line_tbl,
890: 'TRANSACTION_HEADER_ID',

Line 892: ec_debug.pl(3, 'nLine_head_pos: ',nLine_head_pos);

888: xProgress := 'MVSTOB-20-1555';
889: ece_extract_utils_pub.Find_pos(l_line_tbl,
890: 'TRANSACTION_HEADER_ID',
891: nLine_head_pos);
892: ec_debug.pl(3, 'nLine_head_pos: ',nLine_head_pos);
893:
894: l_line_tbl(nLine_head_pos).value := l_header_fkey;
895: ec_debug.pl(3, 'l_line_tbl(nLine_head_pos).value: ',l_line_tbl(nLine_head_pos).value);
896:

Line 895: ec_debug.pl(3, 'l_line_tbl(nLine_head_pos).value: ',l_line_tbl(nLine_head_pos).value);

891: nLine_head_pos);
892: ec_debug.pl(3, 'nLine_head_pos: ',nLine_head_pos);
893:
894: l_line_tbl(nLine_head_pos).value := l_header_fkey;
895: ec_debug.pl(3, 'l_line_tbl(nLine_head_pos).value: ',l_line_tbl(nLine_head_pos).value);
896:
897: xProgress := 'MVSTOB-20-1560';
898: ece_extract_utils_pub.Find_pos(l_line_tbl,
899: 'EDI_TRANSACTION_REFERENCE',

Line 901: ec_debug.pl(3, 'nEdi_TransRef_pos: ',nEdi_TransRef_pos);

897: xProgress := 'MVSTOB-20-1560';
898: ece_extract_utils_pub.Find_pos(l_line_tbl,
899: 'EDI_TRANSACTION_REFERENCE',
900: nEdi_TransRef_pos);
901: ec_debug.pl(3, 'nEdi_TransRef_pos: ',nEdi_TransRef_pos);
902:
903: l_line_tbl(nEdi_TransRef_pos).value := v_EdiTransactionRef;
904: ec_debug.pl(3, 'l_line_tbl(nEdi_TransRef_pos).value: ',l_line_tbl(nEdi_TransRef_pos).value);
905:

Line 904: ec_debug.pl(3, 'l_line_tbl(nEdi_TransRef_pos).value: ',l_line_tbl(nEdi_TransRef_pos).value);

900: nEdi_TransRef_pos);
901: ec_debug.pl(3, 'nEdi_TransRef_pos: ',nEdi_TransRef_pos);
902:
903: l_line_tbl(nEdi_TransRef_pos).value := v_EdiTransactionRef;
904: ec_debug.pl(3, 'l_line_tbl(nEdi_TransRef_pos).value: ',l_line_tbl(nEdi_TransRef_pos).value);
905:
906:
907: xProgress := 'MVSTOB-20-1570';
908: ec_code_Conversion_pvt.populate_plsql_tbl_with_extval(p_api_version_number => 1.0,

Line 926: ec_debug.pl(0,

922: INTO l_line_fkey
923: FROM DUAL;
924: EXCEPTION
925: WHEN NO_DATA_FOUND THEN
926: ec_debug.pl(0,
927: 'EC',
928: 'ECE_GET_NEXT_SEQ_FAILED',
929: 'PROGRESS_LEVEL',
930: xProgress,

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

930: xProgress,
931: 'SEQ',
932: 'ECE_MVSTO_LINE_S');
933: END;
934: ec_debug.pl(3, 'l_line_fkey: ',l_line_fkey);
935:
936: xProgress := 'MVSTOB-20-1600';
937: ece_Extract_Utils_PUB.insert_into_interface_tbl(iRun_id,
938: cTransaction_Type,

Line 1014: ec_debug.pl(3, 'nLoc_head_pos: ',nLoc_head_pos);

1010:
1011: ece_extract_utils_pub.Find_pos(l_location_tbl,
1012: 'TRANSACTION_HEADER_ID',
1013: nLoc_head_pos);
1014: ec_debug.pl(3, 'nLoc_head_pos: ',nLoc_head_pos);
1015:
1016: l_location_tbl(nLoc_head_pos).value := l_header_fkey;
1017: ec_debug.pl(3, 'l_location_tbl(nLoc_head_pos).value: ',l_location_tbl(nLoc_head_pos).value);
1018:

Line 1017: ec_debug.pl(3, 'l_location_tbl(nLoc_head_pos).value: ',l_location_tbl(nLoc_head_pos).value);

1013: nLoc_head_pos);
1014: ec_debug.pl(3, 'nLoc_head_pos: ',nLoc_head_pos);
1015:
1016: l_location_tbl(nLoc_head_pos).value := l_header_fkey;
1017: ec_debug.pl(3, 'l_location_tbl(nLoc_head_pos).value: ',l_location_tbl(nLoc_head_pos).value);
1018:
1019: xProgress := 'MVSTOB-20-1555';
1020: ece_extract_utils_pub.Find_pos(l_location_tbl,
1021: 'TRANSACTION_LINE_ID',

Line 1023: ec_debug.pl(3, 'nLoc_line_pos: ',nLoc_line_pos);

1019: xProgress := 'MVSTOB-20-1555';
1020: ece_extract_utils_pub.Find_pos(l_location_tbl,
1021: 'TRANSACTION_LINE_ID',
1022: nLoc_line_pos);
1023: ec_debug.pl(3, 'nLoc_line_pos: ',nLoc_line_pos);
1024:
1025: l_line_tbl(nLoc_line_pos).value := l_line_fkey;
1026: ec_debug.pl(3, 'l_location_tbl(nLoc_line_pos).value: ',l_location_tbl(nLoc_line_pos).value);
1027:

Line 1026: ec_debug.pl(3, 'l_location_tbl(nLoc_line_pos).value: ',l_location_tbl(nLoc_line_pos).value);

1022: nLoc_line_pos);
1023: ec_debug.pl(3, 'nLoc_line_pos: ',nLoc_line_pos);
1024:
1025: l_line_tbl(nLoc_line_pos).value := l_line_fkey;
1026: ec_debug.pl(3, 'l_location_tbl(nLoc_line_pos).value: ',l_location_tbl(nLoc_line_pos).value);
1027:
1028: xProgress := 'MVSTOB-20-1680';
1029: BEGIN
1030: SELECT ece_MVSTO_locations_s.NEXTVAL

Line 1035: ec_debug.pl(0,

1031: INTO l_location_fkey
1032: FROM DUAL;
1033: EXCEPTION
1034: WHEN NO_DATA_FOUND THEN
1035: ec_debug.pl(0,
1036: 'EC',
1037: 'ECE_GET_NEXT_SEQ_FAILED',
1038: 'PROGRESS_LEVEL',
1039: xProgress,

Line 1043: ec_debug.pl(3, 'l_location_fkey: ',l_location_fkey);

1039: xProgress,
1040: 'SEQ',
1041: 'ECE_MVSTO_LOCATION_S');
1042: END;
1043: ec_debug.pl(3, 'l_location_fkey: ',l_location_fkey);
1044:
1045: xProgress := 'MVSTOB-20-1690';
1046: ece_Extract_Utils_PUB.insert_into_interface_tbl(iRun_id,
1047: cTransaction_Type,

Line 1072: ec_debug.pl ( 0,

1068: EDI_SENT_FLAG = 'Y'
1069: WHERE movement_id = n_movement_id;
1070:
1071: IF SQL%NOTFOUND THEN
1072: ec_debug.pl ( 0,
1073: 'EC',
1074: 'ECE_NO_ROW_UPDATED',
1075: 'PROGRESS_LEVEL',
1076: xProgress,

Line 1088: ec_debug.pl(1,

1084:
1085: xProgress := 'MVSTOB-20-1714';
1086: IF(dbms_sql.last_row_count = 0) THEN
1087: v_LevelProcessed := 'LINE';
1088: ec_debug.pl(1,
1089: 'EC',
1090: 'ECE_NO_DB_ROW_PROCESSED',
1091: 'PROGRESS_LEVEL',
1092: xProgress,

Line 1104: ec_debug.pl(0,

1100:
1101: xProgress := 'MVSTOB-20-1716';
1102: IF(dbms_sql.last_row_count = 0) THEN
1103: v_LevelProcessed := 'HEADER';
1104: ec_debug.pl(0,
1105: 'EC',
1106: 'ECE_NO_DB_ROW_PROCESSED',
1107: 'LEVEL_PROCESSED',
1108: v_LevelProcessed,

Line 1121: ec_debug.pop('ECE_MVSTO_TRANSACTION.POPULATE_MVSTO_TRX');

1117: DBMS_SQL.CLOSE_CURSOR(Line_sel_c);
1118:
1119: xProgress := 'MVSTOB-20-1740';
1120: DBMS_SQL.CLOSE_CURSOR(Header_sel_c);
1121: ec_debug.pop('ECE_MVSTO_TRANSACTION.POPULATE_MVSTO_TRX');
1122:
1123: EXCEPTION
1124: WHEN OTHERS THEN
1125:

Line 1126: ec_debug.pl(0,

1122:
1123: EXCEPTION
1124: WHEN OTHERS THEN
1125:
1126: ec_debug.pl(0,
1127: 'EC',
1128: 'ECE_PROGRAM_ERROR',
1129: 'PROGRESS_LEVEL',
1130: xProgress);

Line 1132: ec_debug.pl(0,

1128: 'ECE_PROGRAM_ERROR',
1129: 'PROGRESS_LEVEL',
1130: xProgress);
1131:
1132: ec_debug.pl(0,
1133: 'EC',
1134: 'ECE_ERROR_MESSAGE',
1135: 'ERROR_MESSAGE',
1136: SQLERRM);

Line 1227: ec_debug.push('ECE_MVSTO_TRANSACTION.PUT_DATA_TO_OUTPUT_TABLE');

1223: ntransaction_line_id NUMBER;
1224:
1225: BEGIN
1226:
1227: ec_debug.push('ECE_MVSTO_TRANSACTION.PUT_DATA_TO_OUTPUT_TABLE');
1228: ec_debug.pl(3, 'cCommunication_Method: ', cCommunication_Method);
1229: ec_debug.pl(3, 'cTransaction_Type: ',cTransaction_Type);
1230: ec_debug.pl(3, 'iOutput_width: ',iOutput_width);
1231: ec_debug.pl(3, 'iRun_id: ',iRun_id);

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

1224:
1225: BEGIN
1226:
1227: ec_debug.push('ECE_MVSTO_TRANSACTION.PUT_DATA_TO_OUTPUT_TABLE');
1228: ec_debug.pl(3, 'cCommunication_Method: ', cCommunication_Method);
1229: ec_debug.pl(3, 'cTransaction_Type: ',cTransaction_Type);
1230: ec_debug.pl(3, 'iOutput_width: ',iOutput_width);
1231: ec_debug.pl(3, 'iRun_id: ',iRun_id);
1232: ec_debug.pl(3, 'cHeader_Interface: ',cHeader_Interface);

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

1225: BEGIN
1226:
1227: ec_debug.push('ECE_MVSTO_TRANSACTION.PUT_DATA_TO_OUTPUT_TABLE');
1228: ec_debug.pl(3, 'cCommunication_Method: ', cCommunication_Method);
1229: ec_debug.pl(3, 'cTransaction_Type: ',cTransaction_Type);
1230: ec_debug.pl(3, 'iOutput_width: ',iOutput_width);
1231: ec_debug.pl(3, 'iRun_id: ',iRun_id);
1232: ec_debug.pl(3, 'cHeader_Interface: ',cHeader_Interface);
1233: ec_debug.pl(3, 'cLine_Interface: ',cLine_Interface);

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

1226:
1227: ec_debug.push('ECE_MVSTO_TRANSACTION.PUT_DATA_TO_OUTPUT_TABLE');
1228: ec_debug.pl(3, 'cCommunication_Method: ', cCommunication_Method);
1229: ec_debug.pl(3, 'cTransaction_Type: ',cTransaction_Type);
1230: ec_debug.pl(3, 'iOutput_width: ',iOutput_width);
1231: ec_debug.pl(3, 'iRun_id: ',iRun_id);
1232: ec_debug.pl(3, 'cHeader_Interface: ',cHeader_Interface);
1233: ec_debug.pl(3, 'cLine_Interface: ',cLine_Interface);
1234: ec_debug.pl(3, 'cLocation_Interface: ',cLocation_Interface);

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

1227: ec_debug.push('ECE_MVSTO_TRANSACTION.PUT_DATA_TO_OUTPUT_TABLE');
1228: ec_debug.pl(3, 'cCommunication_Method: ', cCommunication_Method);
1229: ec_debug.pl(3, 'cTransaction_Type: ',cTransaction_Type);
1230: ec_debug.pl(3, 'iOutput_width: ',iOutput_width);
1231: ec_debug.pl(3, 'iRun_id: ',iRun_id);
1232: ec_debug.pl(3, 'cHeader_Interface: ',cHeader_Interface);
1233: ec_debug.pl(3, 'cLine_Interface: ',cLine_Interface);
1234: ec_debug.pl(3, 'cLocation_Interface: ',cLocation_Interface);
1235:

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

1228: ec_debug.pl(3, 'cCommunication_Method: ', cCommunication_Method);
1229: ec_debug.pl(3, 'cTransaction_Type: ',cTransaction_Type);
1230: ec_debug.pl(3, 'iOutput_width: ',iOutput_width);
1231: ec_debug.pl(3, 'iRun_id: ',iRun_id);
1232: ec_debug.pl(3, 'cHeader_Interface: ',cHeader_Interface);
1233: ec_debug.pl(3, 'cLine_Interface: ',cLine_Interface);
1234: ec_debug.pl(3, 'cLocation_Interface: ',cLocation_Interface);
1235:
1236: -- Here, I am building the SELECT, FROM, and WHERE clauses for the dynamic

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

1229: ec_debug.pl(3, 'cTransaction_Type: ',cTransaction_Type);
1230: ec_debug.pl(3, 'iOutput_width: ',iOutput_width);
1231: ec_debug.pl(3, 'iRun_id: ',iRun_id);
1232: ec_debug.pl(3, 'cHeader_Interface: ',cHeader_Interface);
1233: ec_debug.pl(3, 'cLine_Interface: ',cLine_Interface);
1234: ec_debug.pl(3, 'cLocation_Interface: ',cLocation_Interface);
1235:
1236: -- Here, I am building the SELECT, FROM, and WHERE clauses for the dynamic
1237: -- SQL call.

Line 1234: ec_debug.pl(3, 'cLocation_Interface: ',cLocation_Interface);

1230: ec_debug.pl(3, 'iOutput_width: ',iOutput_width);
1231: ec_debug.pl(3, 'iRun_id: ',iRun_id);
1232: ec_debug.pl(3, 'cHeader_Interface: ',cHeader_Interface);
1233: ec_debug.pl(3, 'cLine_Interface: ',cLine_Interface);
1234: ec_debug.pl(3, 'cLocation_Interface: ',cLocation_Interface);
1235:
1236: -- Here, I am building the SELECT, FROM, and WHERE clauses for the dynamic
1237: -- SQL call.
1238: -- The ece_flatfile.select_clause uses the db data dictionary for the build.

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

1330: cHeader_select := cHeader_select ||
1331: cHeader_from ||
1332: cHeader_where;
1333:
1334: ec_debug.pl(3, 'cHeader_select: ',cHeader_select);
1335:
1336: cLine_select := cLine_select ||
1337: cLine_from ||
1338: cLine_where ||

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

1338: cLine_where ||
1339: ' ORDER BY ' ||
1340: cLine_Interface ||
1341: '.MOVEMENT_ID ';
1342: ec_debug.pl(3, 'cLine_select: ',cLine_select);
1343:
1344: cLocation_select := cLocation_select ||
1345: cLocation_from ||
1346: cLocation_where;

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

1344: cLocation_select := cLocation_select ||
1345: cLocation_from ||
1346: cLocation_where;
1347:
1348: ec_debug.pl(3, 'cLocation_select: ',cLocation_select);
1349:
1350:
1351: xProgress := 'MVSTOB-10-1060';
1352: cHeader_delete1 := 'DELETE FROM ' ||

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

1351: xProgress := 'MVSTOB-10-1060';
1352: cHeader_delete1 := 'DELETE FROM ' ||
1353: cHeader_Interface ||
1354: ' WHERE ROWID = :col_rowid';
1355: ec_debug.pl(3, 'cHeader_delete1: ',cHeader_delete1);
1356:
1357: cLine_delete1 := 'DELETE FROM ' ||
1358: cLine_Interface ||
1359: ' WHERE ROWID = :col_rowid';

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

1356:
1357: cLine_delete1 := 'DELETE FROM ' ||
1358: cLine_Interface ||
1359: ' WHERE ROWID = :col_rowid';
1360: ec_debug.pl(3, 'cLine_delete1: ',cLine_delete1);
1361:
1362: cLocation_delete1 := 'DELETE FROM ' ||
1363: cLocation_Interface ||
1364: ' WHERE ROWID = :col_rowid';

Line 1365: ec_debug.pl(3, 'cLocation_delete1: ',cLocation_delete1);

1361:
1362: cLocation_delete1 := 'DELETE FROM ' ||
1363: cLocation_Interface ||
1364: ' WHERE ROWID = :col_rowid';
1365: ec_debug.pl(3, 'cLocation_delete1: ',cLocation_delete1);
1366:
1367:
1368: xProgress := 'MVSTOB-10-1070';
1369: cHeader_delete2 := 'DELETE FROM ' ||

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

1368: xProgress := 'MVSTOB-10-1070';
1369: cHeader_delete2 := 'DELETE FROM ' ||
1370: cHeader_X_Interface ||
1371: ' WHERE ROWID = :col_rowid';
1372: ec_debug.pl(3, 'cHeader_delete2: ',cHeader_delete2);
1373:
1374: cLine_delete2 := 'DELETE FROM ' ||
1375: cLine_X_Interface ||
1376: ' WHERE ROWID = :col_rowid';

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

1373:
1374: cLine_delete2 := 'DELETE FROM ' ||
1375: cLine_X_Interface ||
1376: ' WHERE ROWID = :col_rowid';
1377: ec_debug.pl(3, 'cLine_delete2: ',cLine_delete2);
1378:
1379: cLocation_delete2 := 'DELETE FROM ' ||
1380: cLocation_X_Interface ||
1381: ' WHERE ROWID = :col_rowid';

Line 1382: ec_debug.pl(3, 'cLocation_delete2: ',cLocation_delete2);

1378:
1379: cLocation_delete2 := 'DELETE FROM ' ||
1380: cLocation_X_Interface ||
1381: ' WHERE ROWID = :col_rowid';
1382: ec_debug.pl(3, 'cLocation_delete2: ',cLocation_delete2);
1383:
1384:
1385: -- ***************************************************
1386: -- *** Get data setup for the dynamic SQL call.

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

1690: 1,
1691: 22),22) || RPAD(' ',22) ||
1692: RPAD(' ',22);
1693:
1694: ec_debug.pl(3, 'c_file_common_key: ',c_file_common_key);
1695:
1696: xProgress := 'MVSTOB-10-1480';
1697: ece_flatfile_pvt.write_to_ece_output(cTransaction_Type,
1698: cCommunication_Method,

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

1763: (l_line_tbl(nLine_key_pos).value,' '),
1764: 1,
1765: 22),22) ||
1766: RPAD(' ',22);
1767: ec_debug.pl(3, 'c_file_common_key: ',c_file_common_key);
1768:
1769: xProgress := 'MVSTOB-10-1560';
1770: ece_flatfile_pvt.write_to_ece_output(cTransaction_Type,
1771: cCommunication_Method,

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

1813: c_file_common_key := RPAD(NVL(SUBSTRB(l_header_tbl(nTrans_code_pos).value,1,25),' '),25);
1814: xProgress := 'MVSTOB-10-1620';
1815: c_file_common_key := c_file_common_key || RPAD(SUBSTRB(NVL (l_header_tbl(nHeader_key_pos).value,' '), 1, 22),22) || RPAD(SUBSTRB(NVL (l_line_tbl(nLine_key_pos).value,' '), 1, 22),22);
1816:
1817: ec_debug.pl(3, 'c_file_common_key: ',c_file_common_key);
1818:
1819: xProgress := 'MVSTOB-10-1630';
1820: ece_flatfile_pvt.write_to_ece_output(cTransaction_Type,
1821: cCommunication_Method,

Line 1849: ec_debug.pl(1,

1845:
1846: xProgress := 'MVSTOB-10-1674';
1847: IF(dbms_sql.last_row_count = 0) THEN
1848: v_LevelProcessed := 'LOCATION';
1849: ec_debug.pl(1,
1850: 'EC',
1851: 'ECE_NO_DB_ROW_PROCESSED',
1852: 'PROGRESS_LEVEL',
1853: xProgress,

Line 1885: ec_debug.pl(1,

1881:
1882: xProgress := 'MVSTOB-10-1714';
1883: IF(dbms_sql.last_row_count = 0) THEN
1884: v_LevelProcessed := 'LINE';
1885: ec_debug.pl(1,
1886: 'EC',
1887: 'ECE_NO_DB_ROW_PROCESSED',
1888: 'PROGRESS_LEVEL',
1889: xProgress,

Line 1917: ec_debug.pl(1,

1913:
1914: xProgress := 'MVSTOB-10-1754';
1915: IF(dbms_sql.last_row_count = 0) THEN
1916: v_LevelProcessed := 'HEADER';
1917: ec_debug.pl(1,
1918: 'EC',
1919: 'ECE_NO_DB_ROW_PROCESSED',
1920: 'PROGRESS_LEVEL',
1921: xProgress,

Line 1956: ec_debug.pop('ECE_MVSTO_TRANSACTION.PUT_DATA_TO_OUTPUT_TABLE');

1952: xProgress := 'MVSTOB-10-1818';
1953: DBMS_SQL.CLOSE_CURSOR(Location_del_c2);
1954:
1955: xProgress := 'MVSTOB-10-1820';
1956: ec_debug.pop('ECE_MVSTO_TRANSACTION.PUT_DATA_TO_OUTPUT_TABLE');
1957:
1958: EXCEPTION
1959: WHEN OTHERS THEN
1960:

Line 1961: ec_debug.pl(0,

1957:
1958: EXCEPTION
1959: WHEN OTHERS THEN
1960:
1961: ec_debug.pl(0,
1962: 'EC',
1963: 'ECE_PROGRAM_ERROR',
1964: 'PROGRESS_LEVEL',
1965: xProgress);

Line 1967: ec_debug.pl(0,

1963: 'ECE_PROGRAM_ERROR',
1964: 'PROGRESS_LEVEL',
1965: xProgress);
1966:
1967: ec_debug.pl(0,
1968: 'EC',
1969: 'ECE_ERROR_MESSAGE',
1970: 'ERROR_MESSAGE',
1971: SQLERRM);