APPS.ECE_AR_TRANSACTION dependencies on UTL_FILE

Line 52: uFile_type utl_file.file_type;

48: cAlw_chg_Interface VARCHAR2(120) := 'ECE_AR_TRX_ALLOWANCE_CHARGES';
49: cLine_Interface VARCHAR2(120) := 'ECE_AR_TRX_LINES';
50: cLine_t_Interface VARCHAR2(120) := 'ECE_AR_TRX_LINE_TAX';
51: l_line_text VARCHAR2(2000);
52: uFile_type utl_file.file_type;
53: cCreate_Date_From DATE := TO_DATE(cCDate_From,'YYYY/MM/DD HH24:MI:SS');
54: cCreate_Date_To DATE := TO_DATE(cCDate_To,'YYYY/MM/DD HH24:MI:SS') + 1;
55: cExport_Type VARCHAR2(30) := 'INVOICE';
56: cEnabled VARCHAR2(1) := 'Y';

Line 200: if (NOT utl_file.is_open(uFile_type)) then

196: LOOP
197: FETCH c_output INTO l_line_text;
198: ec_debug.pl(3,'l_line_text: ',l_line_text);
199: if (c_output%ROWCOUNT > 0) then
200: if (NOT utl_file.is_open(uFile_type)) then
201: uFile_type := utl_file.fopen(cOutputPath,
202: cFilename,
203: 'W');
204: end if;

Line 201: uFile_type := utl_file.fopen(cOutputPath,

197: FETCH c_output INTO l_line_text;
198: ec_debug.pl(3,'l_line_text: ',l_line_text);
199: if (c_output%ROWCOUNT > 0) then
200: if (NOT utl_file.is_open(uFile_type)) then
201: uFile_type := utl_file.fopen(cOutputPath,
202: cFilename,
203: 'W');
204: end if;
205: end if;

Line 210: utl_file.put_line(uFile_type,

206: EXIT WHEN c_output%NOTFOUND;
207:
208: -- Write the data from ece_output to the output file.
209: xProgress := 'INO-10-1080';
210: utl_file.put_line(uFile_type,
211: l_line_text);
212:
213: END LOOP;
214:

Line 219: if (utl_file.is_open(uFile_type)) then

215: CLOSE c_output;
216:
217: -- Close the output file.
218: xProgress := 'INO-10-1090';
219: if (utl_file.is_open(uFile_type)) then
220: utl_file.fclose(uFile_type);
221: end if;
222:
223: -- Assume everything went ok so delete the records from ece_output.

Line 220: utl_file.fclose(uFile_type);

216:
217: -- Close the output file.
218: xProgress := 'INO-10-1090';
219: if (utl_file.is_open(uFile_type)) then
220: utl_file.fclose(uFile_type);
221: end if;
222:
223: -- Assume everything went ok so delete the records from ece_output.
224: xProgress := 'INO-10-1100';

Line 277: WHEN utl_file.write_error THEN

273: retcode := '1';
274: ec_debug.disable_debug;
275: ROLLBACK;
276:
277: WHEN utl_file.write_error THEN
278: ec_debug.pl(0,'EC','ECE_UTL_WRITE_ERROR',NULL);
279: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
280:
281: retcode := 2;

Line 285: WHEN utl_file.invalid_path THEN

281: retcode := 2;
282: ec_debug.disable_debug;
283: ROLLBACK;
284:
285: WHEN utl_file.invalid_path THEN
286: ec_debug.pl(0,'EC','ECE_UTIL_INVALID_PATH',NULL);
287: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
288:
289: retcode := 2;

Line 293: WHEN utl_file.invalid_operation THEN

289: retcode := 2;
290: ec_debug.disable_debug;
291: ROLLBACK;
292:
293: WHEN utl_file.invalid_operation THEN
294: ec_debug.pl(0,'EC','ECE_UTIL_INVALID_OPERATION',NULL);
295: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
296:
297: retcode := 2;