APPS.GML_GASNO dependencies on UTL_FILE

Line 61: v_OutputFilePtr utl_file.file_type;

57: p_DTL_Interface VARCHAR2(120) := 'GML_GASNO_DETAILS';
58: p_DAC_Interface VARCHAR2(120) := 'GML_GASNO_DETAIL_CHARGES';
59: p_DTX_Interface VARCHAR2(120) := 'GML_GASNO_DETAIL_TEXT';
60: p_ALL_Interface VARCHAR2(120) := 'GML_GASNO_DETAIL_ALLOCATIONS';
61: v_OutputFilePtr utl_file.file_type;
62: v_OutputLine VARCHAR2(2000);
63: v_OutputRecordCount NUMBER;
64: v_industry VARCHAR2(240);
65: v_oracle_schema VARCHAR2(240);

Line 174: v_OutputFilePtr := utl_file.fopen ( p_OutputPath,

170: xProgress := 'GASNO-10-1060';
171: IF v_OutputRecordCount > 0
172: THEN
173: xProgress := 'GASNO-10-1070';
174: v_OutputFilePtr := utl_file.fopen ( p_OutputPath,
175: p_FileName,
176: 'W' );
177:
178: xProgress := 'GASNO-10-1080';

Line 191: utl_file.put_line ( v_OutputFilePtr,

187: xProgress := 'GASNO-10-1100';
188: EXIT WHEN c_OutputSource%NOTFOUND;
189:
190: xProgress := 'GASNO-10-1200';
191: utl_file.put_line ( v_OutputFilePtr,
192: v_OutputLine );
193: END LOOP;
194:
195: xProgress := 'GASNO-10-1300';

Line 199: utl_file.fclose ( v_OutputFilePtr );

195: xProgress := 'GASNO-10-1300';
196: CLOSE c_OutputSource;
197:
198: xProgress := 'GASNO-10-1400';
199: utl_file.fclose ( v_OutputFilePtr );
200:
201: END IF;
202:
203: xProgress := 'GASNO-10-1170';

Line 226: WHEN utl_file.write_error THEN

222: ec_debug.disable_debug;
223: COMMIT;
224:
225: EXCEPTION
226: WHEN utl_file.write_error THEN
227:
228: ec_debug.pl ( 0,
229: 'EC',
230: 'ECE_UTL_WRITE_ERROR',

Line 244: WHEN utl_file.invalid_path THEN

240: ec_debug.disable_debug;
241: ROLLBACK;
242: RAISE;
243:
244: WHEN utl_file.invalid_path THEN
245:
246: ec_debug.pl ( 0,
247: 'EC',
248: 'ECE_UTIL_INVALID_PATH',

Line 262: WHEN utl_file.invalid_operation THEN

258: ec_debug.disable_debug;
259: ROLLBACK;
260: RAISE;
261:
262: WHEN utl_file.invalid_operation THEN
263:
264: ec_debug.pl ( 0,
265: 'EC',
266: 'ECE_UTIL_INVALID_OPERATION',