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.GML_GPOAO dependencies on EC_DEBUG

Line 102: ec_debug.enable_debug ( v_debug_mode );

98: ORDER BY line_id;
99:
100: BEGIN
101:
102: ec_debug.enable_debug ( v_debug_mode );
103: ec_debug.push ( 'GML_GPOAO.Extract_GPOAO_Outbound' );
104: ec_debug.pl ( 3, 'v_Filename: ',v_Filename);
105: ec_debug.pl ( 3, 'v_OutputPath: ',v_OutputPath );
106: ec_debug.pl ( 3, 'v_Orgn_Code: ',v_Orgn_Code);

Line 103: ec_debug.push ( 'GML_GPOAO.Extract_GPOAO_Outbound' );

99:
100: BEGIN
101:
102: ec_debug.enable_debug ( v_debug_mode );
103: ec_debug.push ( 'GML_GPOAO.Extract_GPOAO_Outbound' );
104: ec_debug.pl ( 3, 'v_Filename: ',v_Filename);
105: ec_debug.pl ( 3, 'v_OutputPath: ',v_OutputPath );
106: ec_debug.pl ( 3, 'v_Orgn_Code: ',v_Orgn_Code);
107: ec_debug.pl ( 3, 'v_Order_No_From: ',v_Order_No_From);

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

100: BEGIN
101:
102: ec_debug.enable_debug ( v_debug_mode );
103: ec_debug.push ( 'GML_GPOAO.Extract_GPOAO_Outbound' );
104: ec_debug.pl ( 3, 'v_Filename: ',v_Filename);
105: ec_debug.pl ( 3, 'v_OutputPath: ',v_OutputPath );
106: ec_debug.pl ( 3, 'v_Orgn_Code: ',v_Orgn_Code);
107: ec_debug.pl ( 3, 'v_Order_No_From: ',v_Order_No_From);
108: ec_debug.pl ( 3, 'v_Order_No_To: ',v_Order_No_To);

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

101:
102: ec_debug.enable_debug ( v_debug_mode );
103: ec_debug.push ( 'GML_GPOAO.Extract_GPOAO_Outbound' );
104: ec_debug.pl ( 3, 'v_Filename: ',v_Filename);
105: ec_debug.pl ( 3, 'v_OutputPath: ',v_OutputPath );
106: ec_debug.pl ( 3, 'v_Orgn_Code: ',v_Orgn_Code);
107: ec_debug.pl ( 3, 'v_Order_No_From: ',v_Order_No_From);
108: ec_debug.pl ( 3, 'v_Order_No_To: ',v_Order_No_To);
109: ec_debug.pl ( 3, 'v_Creation_Date_From: ',v_Creation_Date_From);

Line 106: ec_debug.pl ( 3, 'v_Orgn_Code: ',v_Orgn_Code);

102: ec_debug.enable_debug ( v_debug_mode );
103: ec_debug.push ( 'GML_GPOAO.Extract_GPOAO_Outbound' );
104: ec_debug.pl ( 3, 'v_Filename: ',v_Filename);
105: ec_debug.pl ( 3, 'v_OutputPath: ',v_OutputPath );
106: ec_debug.pl ( 3, 'v_Orgn_Code: ',v_Orgn_Code);
107: ec_debug.pl ( 3, 'v_Order_No_From: ',v_Order_No_From);
108: ec_debug.pl ( 3, 'v_Order_No_To: ',v_Order_No_To);
109: ec_debug.pl ( 3, 'v_Creation_Date_From: ',v_Creation_Date_From);
110: ec_debug.pl ( 3, 'v_Creation_Date_To: ',v_Creation_Date_To);

Line 107: ec_debug.pl ( 3, 'v_Order_No_From: ',v_Order_No_From);

103: ec_debug.push ( 'GML_GPOAO.Extract_GPOAO_Outbound' );
104: ec_debug.pl ( 3, 'v_Filename: ',v_Filename);
105: ec_debug.pl ( 3, 'v_OutputPath: ',v_OutputPath );
106: ec_debug.pl ( 3, 'v_Orgn_Code: ',v_Orgn_Code);
107: ec_debug.pl ( 3, 'v_Order_No_From: ',v_Order_No_From);
108: ec_debug.pl ( 3, 'v_Order_No_To: ',v_Order_No_To);
109: ec_debug.pl ( 3, 'v_Creation_Date_From: ',v_Creation_Date_From);
110: ec_debug.pl ( 3, 'v_Creation_Date_To: ',v_Creation_Date_To);
111: ec_debug.pl ( 3, 'v_Customer_Name: ',v_Customer_Name);

Line 108: ec_debug.pl ( 3, 'v_Order_No_To: ',v_Order_No_To);

104: ec_debug.pl ( 3, 'v_Filename: ',v_Filename);
105: ec_debug.pl ( 3, 'v_OutputPath: ',v_OutputPath );
106: ec_debug.pl ( 3, 'v_Orgn_Code: ',v_Orgn_Code);
107: ec_debug.pl ( 3, 'v_Order_No_From: ',v_Order_No_From);
108: ec_debug.pl ( 3, 'v_Order_No_To: ',v_Order_No_To);
109: ec_debug.pl ( 3, 'v_Creation_Date_From: ',v_Creation_Date_From);
110: ec_debug.pl ( 3, 'v_Creation_Date_To: ',v_Creation_Date_To);
111: ec_debug.pl ( 3, 'v_Customer_Name: ',v_Customer_Name);
112: ec_debug.pl ( 3, 'v_debug_mode: ',v_debug_mode );

Line 109: ec_debug.pl ( 3, 'v_Creation_Date_From: ',v_Creation_Date_From);

105: ec_debug.pl ( 3, 'v_OutputPath: ',v_OutputPath );
106: ec_debug.pl ( 3, 'v_Orgn_Code: ',v_Orgn_Code);
107: ec_debug.pl ( 3, 'v_Order_No_From: ',v_Order_No_From);
108: ec_debug.pl ( 3, 'v_Order_No_To: ',v_Order_No_To);
109: ec_debug.pl ( 3, 'v_Creation_Date_From: ',v_Creation_Date_From);
110: ec_debug.pl ( 3, 'v_Creation_Date_To: ',v_Creation_Date_To);
111: ec_debug.pl ( 3, 'v_Customer_Name: ',v_Customer_Name);
112: ec_debug.pl ( 3, 'v_debug_mode: ',v_debug_mode );
113:

Line 110: ec_debug.pl ( 3, 'v_Creation_Date_To: ',v_Creation_Date_To);

106: ec_debug.pl ( 3, 'v_Orgn_Code: ',v_Orgn_Code);
107: ec_debug.pl ( 3, 'v_Order_No_From: ',v_Order_No_From);
108: ec_debug.pl ( 3, 'v_Order_No_To: ',v_Order_No_To);
109: ec_debug.pl ( 3, 'v_Creation_Date_From: ',v_Creation_Date_From);
110: ec_debug.pl ( 3, 'v_Creation_Date_To: ',v_Creation_Date_To);
111: ec_debug.pl ( 3, 'v_Customer_Name: ',v_Customer_Name);
112: ec_debug.pl ( 3, 'v_debug_mode: ',v_debug_mode );
113:
114:

Line 111: ec_debug.pl ( 3, 'v_Customer_Name: ',v_Customer_Name);

107: ec_debug.pl ( 3, 'v_Order_No_From: ',v_Order_No_From);
108: ec_debug.pl ( 3, 'v_Order_No_To: ',v_Order_No_To);
109: ec_debug.pl ( 3, 'v_Creation_Date_From: ',v_Creation_Date_From);
110: ec_debug.pl ( 3, 'v_Creation_Date_To: ',v_Creation_Date_To);
111: ec_debug.pl ( 3, 'v_Customer_Name: ',v_Customer_Name);
112: ec_debug.pl ( 3, 'v_debug_mode: ',v_debug_mode );
113:
114:
115: /* Get a unique ID for the run of this script. This ID is used to group the */

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

108: ec_debug.pl ( 3, 'v_Order_No_To: ',v_Order_No_To);
109: ec_debug.pl ( 3, 'v_Creation_Date_From: ',v_Creation_Date_From);
110: ec_debug.pl ( 3, 'v_Creation_Date_To: ',v_Creation_Date_To);
111: ec_debug.pl ( 3, 'v_Customer_Name: ',v_Customer_Name);
112: ec_debug.pl ( 3, 'v_debug_mode: ',v_debug_mode );
113:
114:
115: /* Get a unique ID for the run of this script. This ID is used to group the */
116: /* records in the output table (ECE_OUTPUT) so that multiple processes may use */

Line 125: ec_debug.pl ( 0,

121: INTO v_RunID
122: FROM sys.dual;
123: EXCEPTION
124: WHEN NO_DATA_FOUND THEN
125: ec_debug.pl ( 0,
126: 'EC',
127: 'ECE_GET_NEXT_SEQ_FAILED',
128: 'PROGRESS_LEVEL',
129: xProgress,

Line 133: ec_debug.pl(3, 'v_RunID: ',v_RunID);

129: xProgress,
130: 'SEQ',
131: 'ECE_OUTPUT_RUNS_S' );
132: END;
133: ec_debug.pl(3, 'v_RunID: ',v_RunID);
134:
135: xProgress := 'GPOAO-10-1015';
136: ec_debug.pl ( 0, 'EC', 'GML_GPOAO_START', NULL );
137:

Line 136: ec_debug.pl ( 0, 'EC', 'GML_GPOAO_START', NULL );

132: END;
133: ec_debug.pl(3, 'v_RunID: ',v_RunID);
134:
135: xProgress := 'GPOAO-10-1015';
136: ec_debug.pl ( 0, 'EC', 'GML_GPOAO_START', NULL );
137:
138: xProgress := 'GPOAO-10-1020';
139: ec_debug.pl ( 0, 'EC', 'ECE_RUN_ID', 'RUN_ID', v_RunID );
140:

Line 139: ec_debug.pl ( 0, 'EC', 'ECE_RUN_ID', 'RUN_ID', v_RunID );

135: xProgress := 'GPOAO-10-1015';
136: ec_debug.pl ( 0, 'EC', 'GML_GPOAO_START', NULL );
137:
138: xProgress := 'GPOAO-10-1020';
139: ec_debug.pl ( 0, 'EC', 'ECE_RUN_ID', 'RUN_ID', v_RunID );
140:
141: xProgress := 'GPOAO-10-1030';
142:
143: GML_GPOAO.populate_interface_tables(

Line 193: ec_debug.pl ( 0,

189: FROM ece_output
190: WHERE run_id = v_RunID;
191: EXCEPTION
192: WHEN NO_DATA_FOUND THEN
193: ec_debug.pl ( 0,
194: 'EC',
195: 'ECE_GET_COUNT_FAILED',
196: 'PROGRESS_LEVEL',
197: xProgress,

Line 201: ec_debug.pl ( 3, 'v_OutputRecordCount: ',v_OutputRecordCount );

197: xProgress,
198: 'TABLE_NAME',
199: 'ECE_OUTPUT' );
200: END;
201: ec_debug.pl ( 3, 'v_OutputRecordCount: ',v_OutputRecordCount );
202:
203: xProgress := 'GPOAO-10-1060';
204: IF v_OutputRecordCount > 0 THEN
205: xProgress := 'GPOAO-10-1070';

Line 214: ec_debug.pl ( 3, 'v_OutputLine: ',v_OutputLine );

210: xProgress := 'GPOAO-10-1090';
211: LOOP
212: xProgress := 'GPOAO-10-1100';
213: FETCH c_OutputSource INTO v_OutputLine;
214: ec_debug.pl ( 3, 'v_OutputLine: ',v_OutputLine );
215:
216: xProgress := 'GPOAO-10-1110';
217: EXIT WHEN c_OutputSource%NOTFOUND;
218:

Line 231: ec_debug.pl ( 0, 'EC', 'GML_GPOAO_COMPLETE' ,NULL );

227: utl_file.fclose(v_OutputFilePtr);
228: END IF;
229:
230: xProgress := 'GPOAO-10-1170';
231: ec_debug.pl ( 0, 'EC', 'GML_GPOAO_COMPLETE' ,NULL );
232:
233: xProgress := 'GPOAO-10-1180';
234: DELETE FROM ece_output
235: WHERE run_id = v_RunID;

Line 239: ec_debug.pl ( 0,

235: WHERE run_id = v_RunID;
236:
237: IF SQL%NOTFOUND
238: THEN
239: ec_debug.pl ( 0,
240: 'EC',
241: 'ECE_NO_ROW_DELETED',
242: 'PROGRESS_LEVEL',
243: xProgress,

Line 248: ec_debug.pop ( 'GML_GPOAO.Extract_GPOAO_Outbound' );

244: 'TABLE_NAME',
245: 'ECE_OUTPUT' );
246: END IF;
247:
248: ec_debug.pop ( 'GML_GPOAO.Extract_GPOAO_Outbound' );
249: ec_debug.disable_debug;
250: COMMIT;
251:
252: EXCEPTION

Line 249: ec_debug.disable_debug;

245: 'ECE_OUTPUT' );
246: END IF;
247:
248: ec_debug.pop ( 'GML_GPOAO.Extract_GPOAO_Outbound' );
249: ec_debug.disable_debug;
250: COMMIT;
251:
252: EXCEPTION
253: WHEN utl_file.write_error THEN

Line 254: ec_debug.pl ( 0, 'EC', 'ECE_UTL_WRITE_ERROR', NULL );

250: COMMIT;
251:
252: EXCEPTION
253: WHEN utl_file.write_error THEN
254: ec_debug.pl ( 0, 'EC', 'ECE_UTL_WRITE_ERROR', NULL );
255:
256: ec_debug.pl ( 0, 'EC', 'ECE_ERROR_MESSAGE', 'ERROR_MESSAGE', SQLERRM );
257:
258: retcode := 2;

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

252: EXCEPTION
253: WHEN utl_file.write_error THEN
254: ec_debug.pl ( 0, 'EC', 'ECE_UTL_WRITE_ERROR', NULL );
255:
256: ec_debug.pl ( 0, 'EC', 'ECE_ERROR_MESSAGE', 'ERROR_MESSAGE', SQLERRM );
257:
258: retcode := 2;
259: ec_debug.disable_debug;
260: ROLLBACK;

Line 259: ec_debug.disable_debug;

255:
256: ec_debug.pl ( 0, 'EC', 'ECE_ERROR_MESSAGE', 'ERROR_MESSAGE', SQLERRM );
257:
258: retcode := 2;
259: ec_debug.disable_debug;
260: ROLLBACK;
261: RAISE;
262:
263: WHEN utl_file.invalid_path THEN

Line 264: ec_debug.pl ( 0, 'EC', 'ECE_UTL_INVALID_PATH', NULL );

260: ROLLBACK;
261: RAISE;
262:
263: WHEN utl_file.invalid_path THEN
264: ec_debug.pl ( 0, 'EC', 'ECE_UTL_INVALID_PATH', NULL );
265:
266: ec_debug.pl ( 0, 'EC', 'ECE_ERROR_MESSAGE', 'ERROR_MESSAGE', SQLERRM );
267:
268: retcode := 2;

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

262:
263: WHEN utl_file.invalid_path THEN
264: ec_debug.pl ( 0, 'EC', 'ECE_UTL_INVALID_PATH', NULL );
265:
266: ec_debug.pl ( 0, 'EC', 'ECE_ERROR_MESSAGE', 'ERROR_MESSAGE', SQLERRM );
267:
268: retcode := 2;
269: ec_debug.disable_debug;
270: ROLLBACK;

Line 269: ec_debug.disable_debug;

265:
266: ec_debug.pl ( 0, 'EC', 'ECE_ERROR_MESSAGE', 'ERROR_MESSAGE', SQLERRM );
267:
268: retcode := 2;
269: ec_debug.disable_debug;
270: ROLLBACK;
271: RAISE;
272:
273: WHEN utl_file.invalid_operation THEN

Line 274: ec_debug.pl ( 0,

270: ROLLBACK;
271: RAISE;
272:
273: WHEN utl_file.invalid_operation THEN
274: ec_debug.pl ( 0,
275: 'EC',
276: 'ECE_UTL_INVALID_OPERATION',
277: NULL );
278:

Line 279: ec_debug.pl ( 0,

275: 'EC',
276: 'ECE_UTL_INVALID_OPERATION',
277: NULL );
278:
279: ec_debug.pl ( 0,
280: 'EC',
281: 'ECE_ERROR_MESSAGE',
282: 'ERROR_MESSAGE',
283: SQLERRM );

Line 286: ec_debug.disable_debug;

282: 'ERROR_MESSAGE',
283: SQLERRM );
284:
285: retcode := 2;
286: ec_debug.disable_debug;
287: ROLLBACK;
288: RAISE;
289:
290:

Line 292: ec_debug.pl ( 0,

288: RAISE;
289:
290:
291: WHEN others then
292: ec_debug.pl ( 0,
293: 'EC',
294: 'ECE_PROGRAM_ERROR',
295: 'PROGRESS_LEVEL',
296: xProgress );

Line 298: ec_debug.pl ( 0,

294: 'ECE_PROGRAM_ERROR',
295: 'PROGRESS_LEVEL',
296: xProgress );
297:
298: ec_debug.pl ( 0,
299: 'EC',
300: 'ECE_ERROR_MESSAGE',
301: 'ERROR_MESSAGE',
302: SQLERRM );

Line 305: ec_debug.disable_debug;

301: 'ERROR_MESSAGE',
302: SQLERRM );
303:
304: retcode := 2;
305: ec_debug.disable_debug;
306: ROLLBACK;
307: RAISE;
308:
309: END Extract_GPOAO_Outbound;

Line 464: ec_debug.push ( 'GML_GPOAO.Populate_Interface_Tables' );

460: /* */
461: /* Load each PL/SQL table. The FOR loop implicitly handles all */
462: /* cursor processing. */
463: /* */
464: ec_debug.push ( 'GML_GPOAO.Populate_Interface_Tables' );
465: ec_debug.pl ( 3, 'p_Orgn_Code : ',p_Orgn_Code );
466: ec_debug.pl ( 3, 'p_Order_No_From : ',p_Order_No_From );
467:
468: v_Orgn_Code := p_Orgn_Code;

Line 465: ec_debug.pl ( 3, 'p_Orgn_Code : ',p_Orgn_Code );

461: /* Load each PL/SQL table. The FOR loop implicitly handles all */
462: /* cursor processing. */
463: /* */
464: ec_debug.push ( 'GML_GPOAO.Populate_Interface_Tables' );
465: ec_debug.pl ( 3, 'p_Orgn_Code : ',p_Orgn_Code );
466: ec_debug.pl ( 3, 'p_Order_No_From : ',p_Order_No_From );
467:
468: v_Orgn_Code := p_Orgn_Code;
469: v_Order_No_From := p_Order_No_From;

Line 466: ec_debug.pl ( 3, 'p_Order_No_From : ',p_Order_No_From );

462: /* cursor processing. */
463: /* */
464: ec_debug.push ( 'GML_GPOAO.Populate_Interface_Tables' );
465: ec_debug.pl ( 3, 'p_Orgn_Code : ',p_Orgn_Code );
466: ec_debug.pl ( 3, 'p_Order_No_From : ',p_Order_No_From );
467:
468: v_Orgn_Code := p_Orgn_Code;
469: v_Order_No_From := p_Order_No_From;
470: v_Order_No_To := p_Order_No_To;

Line 476: ec_debug.pl ( 3, 'v_Order_No_From : ',v_Order_No_From );

472: v_Creation_Date_To := p_Creation_Date_To;
473: v_Customer_Name := p_Customer_Name;
474:
475: xProgress := 'GPOAOB-10-0010';
476: ec_debug.pl ( 3, 'v_Order_No_From : ',v_Order_No_From );
477: /* Get doc numbering info to properlly format doc numbers entered */
478: SELECT
479: assignment_type,
480: format_size,

Line 493: ec_debug.pl ( 3, 'v_assignment_type: ',v_assignment_type);

489: orgn_code=v_Orgn_Code AND
490: doc_type='OPSO'
491: ;
492:
493: ec_debug.pl ( 3, 'v_assignment_type: ',v_assignment_type);
494: If ( v_assignment_type = 2 ) Then /* If automatic document numbering */
495: If ( p_Order_No_From is NOT NULL ) Then
496: v_Order_No_From := lpad(p_Order_No_From, v_format_size, v_pad_char);
497: ec_debug.pl ( 3, 'v_Order_No_From : ',v_Order_No_From );

Line 497: ec_debug.pl ( 3, 'v_Order_No_From : ',v_Order_No_From );

493: ec_debug.pl ( 3, 'v_assignment_type: ',v_assignment_type);
494: If ( v_assignment_type = 2 ) Then /* If automatic document numbering */
495: If ( p_Order_No_From is NOT NULL ) Then
496: v_Order_No_From := lpad(p_Order_No_From, v_format_size, v_pad_char);
497: ec_debug.pl ( 3, 'v_Order_No_From : ',v_Order_No_From );
498: SELECT
499: lpad(p_Order_No_From, v_format_size, v_pad_char)
500: INTO
501: v_Order_No_From

Line 508: ec_debug.pl ( 3, 'v_Order_No_To : ',v_Order_No_To );

504: ;
505: End If;
506: If ( p_Order_No_To is NOT NULL ) Then
507: v_Order_No_To := lpad(p_Order_No_To, v_format_size, v_pad_char);
508: ec_debug.pl ( 3, 'v_Order_No_To : ',v_Order_No_To );
509: SELECT
510: lpad(p_Order_No_To, v_format_size, v_pad_char)
511: INTO
512: v_Order_No_To

Line 520: ec_debug.pl ( 3, 'v_Order_No_From : ',v_Order_No_From );

516: End If;
517: End If;
518:
519:
520: ec_debug.pl ( 3, 'v_Order_No_From : ',v_Order_No_From );
521: ec_debug.pl ( 3, 'v_Order_No_To : ',v_Order_No_To );
522:
523: /* */
524: /* Initialize the Cross Reference PL/SQL table. This table is a */

Line 521: ec_debug.pl ( 3, 'v_Order_No_To : ',v_Order_No_To );

517: End If;
518:
519:
520: ec_debug.pl ( 3, 'v_Order_No_From : ',v_Order_No_From );
521: ec_debug.pl ( 3, 'v_Order_No_To : ',v_Order_No_To );
522:
523: /* */
524: /* Initialize the Cross Reference PL/SQL table. This table is a */
525: /* concatenation of all the interface PL/SQL tables. */

Line 701: ec_debug.pl ( 3, 'v_ORD_Where: ',v_ORD_Where);

697: v_ORD_Where := v_ORD_Where || ' AND ' ||
698: p_ORD_Interface || '_V.SHIPTO_CUST_NAME = :Customer_Name';
699: End If;
700:
701: ec_debug.pl ( 3, 'v_ORD_Where: ',v_ORD_Where);
702:
703: /* ********************************************************* */
704: /* ** Order Charges Level Where Clause ** */
705: /* ********************************************************* */

Line 755: ec_debug.pl (3, 'v_ORD_Select:', v_ORD_Select);

751: xProgress := 'GPOAOB-10-1400';
752: v_ORD_Select := v_ORD_Select ||
753: v_ORD_From ||
754: v_ORD_Where;
755: ec_debug.pl (3, 'v_ORD_Select:', v_ORD_Select);
756:
757:
758: v_OAC_Select := v_OAC_Select ||
759: v_OAC_From ||

Line 769: ec_debug.pl (3, 'v_DTL_Select:', v_DTL_Select);

765:
766: v_DTL_Select := v_DTL_Select ||
767: v_DTL_From ||
768: v_DTL_Where;
769: ec_debug.pl (3, 'v_DTL_Select:', v_DTL_Select);
770:
771: v_DAC_Select := v_DAC_Select ||
772: v_DAC_From ||
773: v_DAC_Where;

Line 774: ec_debug.pl (3, 'v_DAC_Select:', v_DAC_Select);

770:
771: v_DAC_Select := v_DAC_Select ||
772: v_DAC_From ||
773: v_DAC_Where;
774: ec_debug.pl (3, 'v_DAC_Select:', v_DAC_Select);
775:
776: v_DTX_Select := v_DTX_Select ||
777: v_DTX_From ||
778: v_DTX_Where;

Line 815: ec_debug.pl (3, 'v_ORD_Select:', v_ORD_Select);

811: xProgress := 'GPOAOB-10-1500';
812: dbms_sql.parse ( v_ORD_Cursor,
813: v_ORD_Select,
814: dbms_sql.native );
815: ec_debug.pl (3, 'v_ORD_Select:', v_ORD_Select);
816:
817: xProgress := 'GPOAOB-10-1510';
818: dbms_sql.parse ( v_OAC_Cursor,
819: v_OAC_Select,

Line 853: ec_debug.pl ( 3, 'v_ORD_Count: ',v_ORD_Count);

849: /* */
850:
851: xProgress := 'GPOAOB-10-1561';
852: v_ORD_Count := v_ORD_Table.COUNT;
853: ec_debug.pl ( 3, 'v_ORD_Count: ',v_ORD_Count);
854:
855: xProgress := 'GPOAOB-10-1562';
856: v_OAC_Count := v_OAC_Table.COUNT;
857: ec_debug.pl ( 3, 'v_OAC_Count: ',v_OAC_Count);

Line 857: ec_debug.pl ( 3, 'v_OAC_Count: ',v_OAC_Count);

853: ec_debug.pl ( 3, 'v_ORD_Count: ',v_ORD_Count);
854:
855: xProgress := 'GPOAOB-10-1562';
856: v_OAC_Count := v_OAC_Table.COUNT;
857: ec_debug.pl ( 3, 'v_OAC_Count: ',v_OAC_Count);
858:
859: xProgress := 'GPOAOB-10-1563';
860: v_OTX_Count := v_OTX_Table.COUNT;
861: ec_debug.pl ( 3, 'v_OTX_Count: ',v_OTX_Count);

Line 861: ec_debug.pl ( 3, 'v_OTX_Count: ',v_OTX_Count);

857: ec_debug.pl ( 3, 'v_OAC_Count: ',v_OAC_Count);
858:
859: xProgress := 'GPOAOB-10-1563';
860: v_OTX_Count := v_OTX_Table.COUNT;
861: ec_debug.pl ( 3, 'v_OTX_Count: ',v_OTX_Count);
862:
863: xProgress := 'GPOAOB-10-1564';
864: v_DTL_Count := v_DTL_Table.COUNT;
865: ec_debug.pl ( 3, 'v_DTL_Count: ',v_DTL_Count);

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

861: ec_debug.pl ( 3, 'v_OTX_Count: ',v_OTX_Count);
862:
863: xProgress := 'GPOAOB-10-1564';
864: v_DTL_Count := v_DTL_Table.COUNT;
865: ec_debug.pl ( 3, 'v_DTL_Count: ',v_DTL_Count);
866:
867: xProgress := 'GPOAOB-10-1565';
868: v_DAC_Count := v_DAC_Table.COUNT;
869: ec_debug.pl ( 3, 'v_DAC_Count: ',v_DAC_Count);

Line 869: ec_debug.pl ( 3, 'v_DAC_Count: ',v_DAC_Count);

865: ec_debug.pl ( 3, 'v_DTL_Count: ',v_DTL_Count);
866:
867: xProgress := 'GPOAOB-10-1565';
868: v_DAC_Count := v_DAC_Table.COUNT;
869: ec_debug.pl ( 3, 'v_DAC_Count: ',v_DAC_Count);
870:
871: xProgress := 'GPOAOB-10-1566';
872: v_DTX_Count := v_DTX_Table.COUNT;
873: ec_debug.pl ( 3, 'v_DTX_Count: ',v_DTX_Count);

Line 873: ec_debug.pl ( 3, 'v_DTX_Count: ',v_DTX_Count);

869: ec_debug.pl ( 3, 'v_DAC_Count: ',v_DAC_Count);
870:
871: xProgress := 'GPOAOB-10-1566';
872: v_DTX_Count := v_DTX_Table.COUNT;
873: ec_debug.pl ( 3, 'v_DTX_Count: ',v_DTX_Count);
874:
875: xProgress := 'GPOAOB-10-1567';
876: v_ALL_Count := v_ALL_Table.COUNT;
877: ec_debug.pl ( 3, 'v_ALL_Count: ',v_ALL_Count);

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

873: ec_debug.pl ( 3, 'v_DTX_Count: ',v_DTX_Count);
874:
875: xProgress := 'GPOAOB-10-1567';
876: v_ALL_Count := v_ALL_Table.COUNT;
877: ec_debug.pl ( 3, 'v_ALL_Count: ',v_ALL_Count);
878:
879: /* */
880: /* Define the data type for every column in each SELECT statement */
881: /* so the database understands how to populate it. Using the */

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

1042: */
1043:
1044: xProgress := 'GPOAOB-10-1752';
1045: v_Order_Id := TO_NUMBER ( v_ORD_Table(v_Order_Id_Position).value );
1046: ec_debug.pl( 3, 'v_Order_Id:', v_Order_Id);
1047:
1048: /* */
1049: /* Cross-reference all necessary columns in the PL/SQL table. */
1050: /* */

Line 1283: ec_debug.pl( 3, 'v_Line_Id:', v_Line_Id);

1279: */
1280:
1281: xProgress := 'GPOAOB-10-2030';
1282: v_Line_Id := TO_NUMBER ( v_DTL_Table(v_Line_Id_Position).value );
1283: ec_debug.pl( 3, 'v_Line_Id:', v_Line_Id);
1284:
1285: /* */
1286: /* Cross-reference all necessary columns in the PL/SQL table. */
1287: /* */

Line 1306: ec_debug.pl( 3, 'V_DTL_Key:', v_DTL_Key);

1302: xProgress := 'GPOAOB-10-2070';
1303: SELECT GML_GPOAO_DETAILS_S.nextval
1304: INTO v_DTL_Key
1305: FROM sys.dual;
1306: ec_debug.pl( 3, 'V_DTL_Key:', v_DTL_Key);
1307:
1308: xProgress := 'GPOAOB-10-2080';
1309: ece_extract_utils_pub.insert_into_interface_tbl ( p_RunID,
1310: p_TransactionType,

Line 1536: ec_debug.pl(3, 'Exported order_id: ' , v_order_id);

1532: END LOOP; /* while all */
1533:
1534: END LOOP; /* while dtl */
1535: /* */
1536: ec_debug.pl(3, 'Exported order_id: ' , v_order_id);
1537: /* */
1538: /* update edi count in the op_ordr_hdr table */
1539: /* */
1540: xProgress := 'GPOAOB-10-2160';

Line 1558: ec_debug.pop ( 'GML_GPOAO.Populate_Interface_Tables' );

1554: /* */
1555:
1556:
1557: xProgress := 'GASNOB-10-2300';
1558: ec_debug.pop ( 'GML_GPOAO.Populate_Interface_Tables' );
1559:
1560: COMMIT;
1561:
1562: /* */

Line 1583: ec_debug.pl ( 0,

1579: dbms_sql.close_cursor ( v_ALL_Cursor );
1580:
1581: EXCEPTION
1582: WHEN OTHERS THEN
1583: ec_debug.pl ( 0,
1584: 'EC',
1585: 'ECE_PROGRAM_ERROR',
1586: 'PROGRESS_LEVEL',
1587: xProgress );

Line 1589: ec_debug.pl ( 0,

1585: 'ECE_PROGRAM_ERROR',
1586: 'PROGRESS_LEVEL',
1587: xProgress );
1588:
1589: ec_debug.pl ( 0,
1590: 'EC',
1591: 'ECE_ERROR_MESSAGE',
1592: 'ERROR_MESSAGE',
1593: SQLERRM );

Line 1823: ec_debug.push ( 'GML_GPOAO.Put_Data_To_Output_Table' );

1819: ** Debug statements for the parameter values.
1820: **
1821: */
1822:
1823: ec_debug.push ( 'GML_GPOAO.Put_Data_To_Output_Table' );
1824: ec_debug.pl ( 3, 'p_CommunicationMethod: ', p_CommunicationMethod );
1825: ec_debug.pl ( 3, 'p_TransactionType: ', p_TransactionType );
1826: ec_debug.pl ( 3, 'p_Orgn_Code: ', p_Orgn_Code );
1827: ec_debug.pl ( 3, 'p_Order_No_From: ', p_Order_No_From );

Line 1824: ec_debug.pl ( 3, 'p_CommunicationMethod: ', p_CommunicationMethod );

1820: **
1821: */
1822:
1823: ec_debug.push ( 'GML_GPOAO.Put_Data_To_Output_Table' );
1824: ec_debug.pl ( 3, 'p_CommunicationMethod: ', p_CommunicationMethod );
1825: ec_debug.pl ( 3, 'p_TransactionType: ', p_TransactionType );
1826: ec_debug.pl ( 3, 'p_Orgn_Code: ', p_Orgn_Code );
1827: ec_debug.pl ( 3, 'p_Order_No_From: ', p_Order_No_From );
1828: ec_debug.pl ( 3, 'p_Order_No_To: ', p_Order_No_To );

Line 1825: ec_debug.pl ( 3, 'p_TransactionType: ', p_TransactionType );

1821: */
1822:
1823: ec_debug.push ( 'GML_GPOAO.Put_Data_To_Output_Table' );
1824: ec_debug.pl ( 3, 'p_CommunicationMethod: ', p_CommunicationMethod );
1825: ec_debug.pl ( 3, 'p_TransactionType: ', p_TransactionType );
1826: ec_debug.pl ( 3, 'p_Orgn_Code: ', p_Orgn_Code );
1827: ec_debug.pl ( 3, 'p_Order_No_From: ', p_Order_No_From );
1828: ec_debug.pl ( 3, 'p_Order_No_To: ', p_Order_No_To );
1829: ec_debug.pl ( 3, 'p_Creation_Date_From: ', p_Creation_Date_From );

Line 1826: ec_debug.pl ( 3, 'p_Orgn_Code: ', p_Orgn_Code );

1822:
1823: ec_debug.push ( 'GML_GPOAO.Put_Data_To_Output_Table' );
1824: ec_debug.pl ( 3, 'p_CommunicationMethod: ', p_CommunicationMethod );
1825: ec_debug.pl ( 3, 'p_TransactionType: ', p_TransactionType );
1826: ec_debug.pl ( 3, 'p_Orgn_Code: ', p_Orgn_Code );
1827: ec_debug.pl ( 3, 'p_Order_No_From: ', p_Order_No_From );
1828: ec_debug.pl ( 3, 'p_Order_No_To: ', p_Order_No_To );
1829: ec_debug.pl ( 3, 'p_Creation_Date_From: ', p_Creation_Date_From );
1830: ec_debug.pl ( 3, 'p_Creation_Date_To: ', p_Creation_Date_To );

Line 1827: ec_debug.pl ( 3, 'p_Order_No_From: ', p_Order_No_From );

1823: ec_debug.push ( 'GML_GPOAO.Put_Data_To_Output_Table' );
1824: ec_debug.pl ( 3, 'p_CommunicationMethod: ', p_CommunicationMethod );
1825: ec_debug.pl ( 3, 'p_TransactionType: ', p_TransactionType );
1826: ec_debug.pl ( 3, 'p_Orgn_Code: ', p_Orgn_Code );
1827: ec_debug.pl ( 3, 'p_Order_No_From: ', p_Order_No_From );
1828: ec_debug.pl ( 3, 'p_Order_No_To: ', p_Order_No_To );
1829: ec_debug.pl ( 3, 'p_Creation_Date_From: ', p_Creation_Date_From );
1830: ec_debug.pl ( 3, 'p_Creation_Date_To: ', p_Creation_Date_To );
1831: ec_debug.pl ( 3, 'p_Customer_Name: ', p_Customer_Name );

Line 1828: ec_debug.pl ( 3, 'p_Order_No_To: ', p_Order_No_To );

1824: ec_debug.pl ( 3, 'p_CommunicationMethod: ', p_CommunicationMethod );
1825: ec_debug.pl ( 3, 'p_TransactionType: ', p_TransactionType );
1826: ec_debug.pl ( 3, 'p_Orgn_Code: ', p_Orgn_Code );
1827: ec_debug.pl ( 3, 'p_Order_No_From: ', p_Order_No_From );
1828: ec_debug.pl ( 3, 'p_Order_No_To: ', p_Order_No_To );
1829: ec_debug.pl ( 3, 'p_Creation_Date_From: ', p_Creation_Date_From );
1830: ec_debug.pl ( 3, 'p_Creation_Date_To: ', p_Creation_Date_To );
1831: ec_debug.pl ( 3, 'p_Customer_Name: ', p_Customer_Name );
1832: ec_debug.pl ( 3, 'p_RunID: ', p_RunID );

Line 1829: ec_debug.pl ( 3, 'p_Creation_Date_From: ', p_Creation_Date_From );

1825: ec_debug.pl ( 3, 'p_TransactionType: ', p_TransactionType );
1826: ec_debug.pl ( 3, 'p_Orgn_Code: ', p_Orgn_Code );
1827: ec_debug.pl ( 3, 'p_Order_No_From: ', p_Order_No_From );
1828: ec_debug.pl ( 3, 'p_Order_No_To: ', p_Order_No_To );
1829: ec_debug.pl ( 3, 'p_Creation_Date_From: ', p_Creation_Date_From );
1830: ec_debug.pl ( 3, 'p_Creation_Date_To: ', p_Creation_Date_To );
1831: ec_debug.pl ( 3, 'p_Customer_Name: ', p_Customer_Name );
1832: ec_debug.pl ( 3, 'p_RunID: ', p_RunID );
1833: ec_debug.pl ( 3, 'p_OutputWidth: ', p_OutputWidth );

Line 1830: ec_debug.pl ( 3, 'p_Creation_Date_To: ', p_Creation_Date_To );

1826: ec_debug.pl ( 3, 'p_Orgn_Code: ', p_Orgn_Code );
1827: ec_debug.pl ( 3, 'p_Order_No_From: ', p_Order_No_From );
1828: ec_debug.pl ( 3, 'p_Order_No_To: ', p_Order_No_To );
1829: ec_debug.pl ( 3, 'p_Creation_Date_From: ', p_Creation_Date_From );
1830: ec_debug.pl ( 3, 'p_Creation_Date_To: ', p_Creation_Date_To );
1831: ec_debug.pl ( 3, 'p_Customer_Name: ', p_Customer_Name );
1832: ec_debug.pl ( 3, 'p_RunID: ', p_RunID );
1833: ec_debug.pl ( 3, 'p_OutputWidth: ', p_OutputWidth );
1834: ec_debug.pl ( 3, 'p_ORD_Interface: ', p_ORD_Interface );

Line 1831: ec_debug.pl ( 3, 'p_Customer_Name: ', p_Customer_Name );

1827: ec_debug.pl ( 3, 'p_Order_No_From: ', p_Order_No_From );
1828: ec_debug.pl ( 3, 'p_Order_No_To: ', p_Order_No_To );
1829: ec_debug.pl ( 3, 'p_Creation_Date_From: ', p_Creation_Date_From );
1830: ec_debug.pl ( 3, 'p_Creation_Date_To: ', p_Creation_Date_To );
1831: ec_debug.pl ( 3, 'p_Customer_Name: ', p_Customer_Name );
1832: ec_debug.pl ( 3, 'p_RunID: ', p_RunID );
1833: ec_debug.pl ( 3, 'p_OutputWidth: ', p_OutputWidth );
1834: ec_debug.pl ( 3, 'p_ORD_Interface: ', p_ORD_Interface );
1835: ec_debug.pl ( 3, 'p_OAC_Interface: ', p_OAC_Interface );

Line 1832: ec_debug.pl ( 3, 'p_RunID: ', p_RunID );

1828: ec_debug.pl ( 3, 'p_Order_No_To: ', p_Order_No_To );
1829: ec_debug.pl ( 3, 'p_Creation_Date_From: ', p_Creation_Date_From );
1830: ec_debug.pl ( 3, 'p_Creation_Date_To: ', p_Creation_Date_To );
1831: ec_debug.pl ( 3, 'p_Customer_Name: ', p_Customer_Name );
1832: ec_debug.pl ( 3, 'p_RunID: ', p_RunID );
1833: ec_debug.pl ( 3, 'p_OutputWidth: ', p_OutputWidth );
1834: ec_debug.pl ( 3, 'p_ORD_Interface: ', p_ORD_Interface );
1835: ec_debug.pl ( 3, 'p_OAC_Interface: ', p_OAC_Interface );
1836: ec_debug.pl ( 3, 'p_OTX_Interface: ', p_OTX_Interface );

Line 1833: ec_debug.pl ( 3, 'p_OutputWidth: ', p_OutputWidth );

1829: ec_debug.pl ( 3, 'p_Creation_Date_From: ', p_Creation_Date_From );
1830: ec_debug.pl ( 3, 'p_Creation_Date_To: ', p_Creation_Date_To );
1831: ec_debug.pl ( 3, 'p_Customer_Name: ', p_Customer_Name );
1832: ec_debug.pl ( 3, 'p_RunID: ', p_RunID );
1833: ec_debug.pl ( 3, 'p_OutputWidth: ', p_OutputWidth );
1834: ec_debug.pl ( 3, 'p_ORD_Interface: ', p_ORD_Interface );
1835: ec_debug.pl ( 3, 'p_OAC_Interface: ', p_OAC_Interface );
1836: ec_debug.pl ( 3, 'p_OTX_Interface: ', p_OTX_Interface );
1837: ec_debug.pl ( 3, 'p_DTL_Interface: ', p_DTL_Interface );

Line 1834: ec_debug.pl ( 3, 'p_ORD_Interface: ', p_ORD_Interface );

1830: ec_debug.pl ( 3, 'p_Creation_Date_To: ', p_Creation_Date_To );
1831: ec_debug.pl ( 3, 'p_Customer_Name: ', p_Customer_Name );
1832: ec_debug.pl ( 3, 'p_RunID: ', p_RunID );
1833: ec_debug.pl ( 3, 'p_OutputWidth: ', p_OutputWidth );
1834: ec_debug.pl ( 3, 'p_ORD_Interface: ', p_ORD_Interface );
1835: ec_debug.pl ( 3, 'p_OAC_Interface: ', p_OAC_Interface );
1836: ec_debug.pl ( 3, 'p_OTX_Interface: ', p_OTX_Interface );
1837: ec_debug.pl ( 3, 'p_DTL_Interface: ', p_DTL_Interface );
1838: ec_debug.pl ( 3, 'p_DAC_Interface: ', p_DAC_Interface );

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

1831: ec_debug.pl ( 3, 'p_Customer_Name: ', p_Customer_Name );
1832: ec_debug.pl ( 3, 'p_RunID: ', p_RunID );
1833: ec_debug.pl ( 3, 'p_OutputWidth: ', p_OutputWidth );
1834: ec_debug.pl ( 3, 'p_ORD_Interface: ', p_ORD_Interface );
1835: ec_debug.pl ( 3, 'p_OAC_Interface: ', p_OAC_Interface );
1836: ec_debug.pl ( 3, 'p_OTX_Interface: ', p_OTX_Interface );
1837: ec_debug.pl ( 3, 'p_DTL_Interface: ', p_DTL_Interface );
1838: ec_debug.pl ( 3, 'p_DAC_Interface: ', p_DAC_Interface );
1839: ec_debug.pl ( 3, 'p_DTX_Interface: ', p_DTX_Interface );

Line 1836: ec_debug.pl ( 3, 'p_OTX_Interface: ', p_OTX_Interface );

1832: ec_debug.pl ( 3, 'p_RunID: ', p_RunID );
1833: ec_debug.pl ( 3, 'p_OutputWidth: ', p_OutputWidth );
1834: ec_debug.pl ( 3, 'p_ORD_Interface: ', p_ORD_Interface );
1835: ec_debug.pl ( 3, 'p_OAC_Interface: ', p_OAC_Interface );
1836: ec_debug.pl ( 3, 'p_OTX_Interface: ', p_OTX_Interface );
1837: ec_debug.pl ( 3, 'p_DTL_Interface: ', p_DTL_Interface );
1838: ec_debug.pl ( 3, 'p_DAC_Interface: ', p_DAC_Interface );
1839: ec_debug.pl ( 3, 'p_DTX_Interface: ', p_DTX_Interface );
1840: ec_debug.pl ( 3, 'p_ALL_Interface: ', p_ALL_Interface );

Line 1837: ec_debug.pl ( 3, 'p_DTL_Interface: ', p_DTL_Interface );

1833: ec_debug.pl ( 3, 'p_OutputWidth: ', p_OutputWidth );
1834: ec_debug.pl ( 3, 'p_ORD_Interface: ', p_ORD_Interface );
1835: ec_debug.pl ( 3, 'p_OAC_Interface: ', p_OAC_Interface );
1836: ec_debug.pl ( 3, 'p_OTX_Interface: ', p_OTX_Interface );
1837: ec_debug.pl ( 3, 'p_DTL_Interface: ', p_DTL_Interface );
1838: ec_debug.pl ( 3, 'p_DAC_Interface: ', p_DAC_Interface );
1839: ec_debug.pl ( 3, 'p_DTX_Interface: ', p_DTX_Interface );
1840: ec_debug.pl ( 3, 'p_ALL_Interface: ', p_ALL_Interface );
1841:

Line 1838: ec_debug.pl ( 3, 'p_DAC_Interface: ', p_DAC_Interface );

1834: ec_debug.pl ( 3, 'p_ORD_Interface: ', p_ORD_Interface );
1835: ec_debug.pl ( 3, 'p_OAC_Interface: ', p_OAC_Interface );
1836: ec_debug.pl ( 3, 'p_OTX_Interface: ', p_OTX_Interface );
1837: ec_debug.pl ( 3, 'p_DTL_Interface: ', p_DTL_Interface );
1838: ec_debug.pl ( 3, 'p_DAC_Interface: ', p_DAC_Interface );
1839: ec_debug.pl ( 3, 'p_DTX_Interface: ', p_DTX_Interface );
1840: ec_debug.pl ( 3, 'p_ALL_Interface: ', p_ALL_Interface );
1841:
1842: /* */

Line 1839: ec_debug.pl ( 3, 'p_DTX_Interface: ', p_DTX_Interface );

1835: ec_debug.pl ( 3, 'p_OAC_Interface: ', p_OAC_Interface );
1836: ec_debug.pl ( 3, 'p_OTX_Interface: ', p_OTX_Interface );
1837: ec_debug.pl ( 3, 'p_DTL_Interface: ', p_DTL_Interface );
1838: ec_debug.pl ( 3, 'p_DAC_Interface: ', p_DAC_Interface );
1839: ec_debug.pl ( 3, 'p_DTX_Interface: ', p_DTX_Interface );
1840: ec_debug.pl ( 3, 'p_ALL_Interface: ', p_ALL_Interface );
1841:
1842: /* */
1843: /* */

Line 1840: ec_debug.pl ( 3, 'p_ALL_Interface: ', p_ALL_Interface );

1836: ec_debug.pl ( 3, 'p_OTX_Interface: ', p_OTX_Interface );
1837: ec_debug.pl ( 3, 'p_DTL_Interface: ', p_DTL_Interface );
1838: ec_debug.pl ( 3, 'p_DAC_Interface: ', p_DAC_Interface );
1839: ec_debug.pl ( 3, 'p_DTX_Interface: ', p_DTX_Interface );
1840: ec_debug.pl ( 3, 'p_ALL_Interface: ', p_ALL_Interface );
1841:
1842: /* */
1843: /* */
1844: /* The 'select_clause' procedure will build the SELECT, FROM and WHERE */

Line 3334: ec_debug.pop ( 'GML_GPOAO.Put_Data_To_Output_Table' );

3330: /* Commit the interface table DELETEs. */
3331: /* */
3332:
3333: xProgress := 'GASNOB-40-3070';
3334: ec_debug.pop ( 'GML_GPOAO.Put_Data_To_Output_Table' );
3335: COMMIT;
3336:
3337: /* */
3338: /* Close all open cursors. */

Line 3389: ec_debug.pl ( 0,

3385:
3386: EXCEPTION
3387: WHEN OTHERS THEN
3388:
3389: ec_debug.pl ( 0,
3390: 'EC',
3391: 'ECE_PROGRAM_ERROR',
3392: 'PROGRESS_LEVEL',
3393: xProgress );

Line 3395: ec_debug.pl ( 0,

3391: 'ECE_PROGRAM_ERROR',
3392: 'PROGRESS_LEVEL',
3393: xProgress );
3394:
3395: ec_debug.pl ( 0,
3396: 'EC',
3397: 'ECE_ERROR_MESSAGE',
3398: 'ERROR_MESSAGE',
3399: SQLERRM );