APPS.ECE_ADVO_ADVICE_PKG dependencies on UTL_FILE

Line 32: uFile_type utl_file.file_type;

28: p_communication_method VARCHAR2(120) := 'EDI';
29: p_transaction_type VARCHAR2(120) := 'ADVO';
30: p_document_type VARCHAR2(120) := 'ADV';
31: l_line_text VARCHAR2(2000);
32: uFile_type utl_file.file_type;
33: p_Date_From DATE := TO_DATE(cDate_From,'YYYY/MM/DD HH24:MI:SS');
34: p_Date_To DATE := TO_DATE(cDate_To,'YYYY/MM/DD HH24:MI:SS') + 1;
35: p_output_width INTEGER := 4000;
36: p_run_id NUMBER;

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

140: LOOP
141: FETCH c_output
142: INTO l_line_text;
143: if (c_output%ROWCOUNT > 0) then
144: if (NOT utl_file.is_open(uFile_type)) then
145: uFile_type := utl_file.fopen ( cOutput_Path,
146: cOutput_Filename,
147: 'W' );
148: end if;

Line 145: uFile_type := utl_file.fopen ( cOutput_Path,

141: FETCH c_output
142: INTO l_line_text;
143: if (c_output%ROWCOUNT > 0) then
144: if (NOT utl_file.is_open(uFile_type)) then
145: uFile_type := utl_file.fopen ( cOutput_Path,
146: cOutput_Filename,
147: 'W' );
148: end if;
149: end if;

Line 162: utl_file.put_line ( uFile_type,

158: **
159: */
160:
161: xProgress := 'ADVO-10-1070';
162: utl_file.put_line ( uFile_type,
163: l_line_text );
164: END LOOP;
165:
166: CLOSE c_output;

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

171: **
172: */
173:
174: xProgress := 'ADVO-10-1080';
175: if (utl_file.is_open( uFile_type)) then
176: utl_file.fclose ( uFile_type );
177: end if;
178:
179: /*

Line 176: utl_file.fclose ( uFile_type );

172: */
173:
174: xProgress := 'ADVO-10-1080';
175: if (utl_file.is_open( uFile_type)) then
176: utl_file.fclose ( uFile_type );
177: end if;
178:
179: /*
180: **

Line 222: WHEN utl_file.write_error THEN

218: retcode := 1;
219: ec_debug.disable_debug;
220: ROLLBACK;
221:
222: WHEN utl_file.write_error THEN
223:
224: ec_debug.pl ( 0,
225: 'EC',
226: 'ECE_UTL_WRITE_ERROR',

Line 240: WHEN utl_file.invalid_path THEN

236: ec_debug.disable_debug;
237: ROLLBACK;
238: RAISE;
239:
240: WHEN utl_file.invalid_path THEN
241:
242: ec_debug.pl ( 0,
243: 'EC',
244: 'ECE_UTIL_INVALID_PATH',

Line 258: WHEN utl_file.invalid_operation THEN

254: ec_debug.disable_debug;
255: ROLLBACK;
256: RAISE;
257:
258: WHEN utl_file.invalid_operation THEN
259:
260: ec_debug.pl ( 0,
261: 'EC',
262: 'ECE_UTIL_INVALID_OPERATION',