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.PAY_GB_P6EDI_PKG dependencies on UTL_FILE

Line 36: l_file_handle utl_file.file_type;

32: l_present_line VARCHAR2(250) := null;
33: l_processing BOOLEAN := true;
34: l_line_number NUMBER := 0;
35: l_start_of_employer BOOLEAN := false;
36: l_file_handle utl_file.file_type;
37: l_qualifier VARCHAR2(3);
38: l_filename VARCHAR2(100);
39: l_location VARCHAR2(2000);
40: e_fatal_error exception;

Line 73: l_file_handle := utl_file.fopen(l_Location,l_filename,'r');

69: end if;
70: --
71: -- Open flat file
72: --
73: l_file_handle := utl_file.fopen(l_Location,l_filename,'r');
74: --
75: utl_file.get_line(l_file_handle,l_present_line);
76: --
77: hr_utility.set_location('PAY_GB_P6EDI.upload_p6',10);

Line 75: utl_file.get_line(l_file_handle,l_present_line);

71: -- Open flat file
72: --
73: l_file_handle := utl_file.fopen(l_Location,l_filename,'r');
74: --
75: utl_file.get_line(l_file_handle,l_present_line);
76: --
77: hr_utility.set_location('PAY_GB_P6EDI.upload_p6',10);
78: hr_utility.trace('line: '|| l_present_line);
79: --

Line 245: utl_file.get_line(l_file_handle,l_present_line);

241: -- read next line
242: --
243: --
244: begin
245: utl_file.get_line(l_file_handle,l_present_line);
246: --
247: hr_utility.set_location('PAY_GB_P6EDI.upload_p6',50);
248: hr_utility.trace('line: '|| l_present_line);
249: --

Line 265: utl_file.fclose(l_file_handle);

261: hr_utility.trace('PAY_GB_P6EDI.upload_p6 - committing...');
262: commit;
263: --
264: --
265: utl_file.fclose(l_file_handle);
266: --
267: -- Call PYUDET mode 4
268: --
269: l_pyudet_id := fnd_request.submit_request(application => 'PAY',

Line 292: UTL_FILE.FCLOSE(l_file_handle);

288: --
289: --
290: exception
291: when e_fatal_error then
292: UTL_FILE.FCLOSE(l_file_handle);
293: hr_utility.set_location('PAY_GB_P6EDI.upload_p6',100);
294: rollback;
295: when UTL_FILE.INVALID_OPERATION then
296: UTL_FILE.FCLOSE(l_file_handle);

Line 295: when UTL_FILE.INVALID_OPERATION then

291: when e_fatal_error then
292: UTL_FILE.FCLOSE(l_file_handle);
293: hr_utility.set_location('PAY_GB_P6EDI.upload_p6',100);
294: rollback;
295: when UTL_FILE.INVALID_OPERATION then
296: UTL_FILE.FCLOSE(l_file_handle);
297: hr_utility.set_location('PAY_GB_P6EDI.upload_p6',110);
298: retcode:=2;
299: errbuf := 'Reading P6 File - Invalid Operation (file not found).';

Line 296: UTL_FILE.FCLOSE(l_file_handle);

292: UTL_FILE.FCLOSE(l_file_handle);
293: hr_utility.set_location('PAY_GB_P6EDI.upload_p6',100);
294: rollback;
295: when UTL_FILE.INVALID_OPERATION then
296: UTL_FILE.FCLOSE(l_file_handle);
297: hr_utility.set_location('PAY_GB_P6EDI.upload_p6',110);
298: retcode:=2;
299: errbuf := 'Reading P6 File - Invalid Operation (file not found).';
300: when UTL_FILE.INTERNAL_ERROR then

Line 300: when UTL_FILE.INTERNAL_ERROR then

296: UTL_FILE.FCLOSE(l_file_handle);
297: hr_utility.set_location('PAY_GB_P6EDI.upload_p6',110);
298: retcode:=2;
299: errbuf := 'Reading P6 File - Invalid Operation (file not found).';
300: when UTL_FILE.INTERNAL_ERROR then
301: UTL_FILE.FCLOSE(l_file_handle);
302: hr_utility.set_location('PAY_GB_P6EDI.upload_p6',120);
303: retcode:=2;
304: errbuf := 'Reading P6 File - Internal Error.';

Line 301: UTL_FILE.FCLOSE(l_file_handle);

297: hr_utility.set_location('PAY_GB_P6EDI.upload_p6',110);
298: retcode:=2;
299: errbuf := 'Reading P6 File - Invalid Operation (file not found).';
300: when UTL_FILE.INTERNAL_ERROR then
301: UTL_FILE.FCLOSE(l_file_handle);
302: hr_utility.set_location('PAY_GB_P6EDI.upload_p6',120);
303: retcode:=2;
304: errbuf := 'Reading P6 File - Internal Error.';
305: when UTL_FILE.INVALID_MODE then

Line 305: when UTL_FILE.INVALID_MODE then

301: UTL_FILE.FCLOSE(l_file_handle);
302: hr_utility.set_location('PAY_GB_P6EDI.upload_p6',120);
303: retcode:=2;
304: errbuf := 'Reading P6 File - Internal Error.';
305: when UTL_FILE.INVALID_MODE then
306: UTL_FILE.FCLOSE(l_file_handle);
307: hr_utility.set_location('PAY_GB_P6EDI.upload_p6',130);
308: retcode:=2;
309: errbuf := 'Reading P6 File - Invalid Mode.';

Line 306: UTL_FILE.FCLOSE(l_file_handle);

302: hr_utility.set_location('PAY_GB_P6EDI.upload_p6',120);
303: retcode:=2;
304: errbuf := 'Reading P6 File - Internal Error.';
305: when UTL_FILE.INVALID_MODE then
306: UTL_FILE.FCLOSE(l_file_handle);
307: hr_utility.set_location('PAY_GB_P6EDI.upload_p6',130);
308: retcode:=2;
309: errbuf := 'Reading P6 File - Invalid Mode.';
310: when UTL_FILE.INVALID_PATH then

Line 310: when UTL_FILE.INVALID_PATH then

306: UTL_FILE.FCLOSE(l_file_handle);
307: hr_utility.set_location('PAY_GB_P6EDI.upload_p6',130);
308: retcode:=2;
309: errbuf := 'Reading P6 File - Invalid Mode.';
310: when UTL_FILE.INVALID_PATH then
311: UTL_FILE.FCLOSE(l_file_handle);
312: hr_utility.set_location('PAY_GB_P6EDI.upload_p6',140);
313: retcode:=2;
314: errbuf := 'Reading P6 File - Invalid Path.';

Line 311: UTL_FILE.FCLOSE(l_file_handle);

307: hr_utility.set_location('PAY_GB_P6EDI.upload_p6',130);
308: retcode:=2;
309: errbuf := 'Reading P6 File - Invalid Mode.';
310: when UTL_FILE.INVALID_PATH then
311: UTL_FILE.FCLOSE(l_file_handle);
312: hr_utility.set_location('PAY_GB_P6EDI.upload_p6',140);
313: retcode:=2;
314: errbuf := 'Reading P6 File - Invalid Path.';
315: when UTL_FILE.INVALID_FILEHANDLE then

Line 315: when UTL_FILE.INVALID_FILEHANDLE then

311: UTL_FILE.FCLOSE(l_file_handle);
312: hr_utility.set_location('PAY_GB_P6EDI.upload_p6',140);
313: retcode:=2;
314: errbuf := 'Reading P6 File - Invalid Path.';
315: when UTL_FILE.INVALID_FILEHANDLE then
316: UTL_FILE.FCLOSE(l_file_handle);
317: hr_utility.set_location('PAY_GB_P6EDI.upload_p6',150);
318: retcode:=2;
319: errbuf := 'Reading P6 File - Invalid File Handle.';

Line 316: UTL_FILE.FCLOSE(l_file_handle);

312: hr_utility.set_location('PAY_GB_P6EDI.upload_p6',140);
313: retcode:=2;
314: errbuf := 'Reading P6 File - Invalid Path.';
315: when UTL_FILE.INVALID_FILEHANDLE then
316: UTL_FILE.FCLOSE(l_file_handle);
317: hr_utility.set_location('PAY_GB_P6EDI.upload_p6',150);
318: retcode:=2;
319: errbuf := 'Reading P6 File - Invalid File Handle.';
320: when UTL_FILE.READ_ERROR then

Line 320: when UTL_FILE.READ_ERROR then

316: UTL_FILE.FCLOSE(l_file_handle);
317: hr_utility.set_location('PAY_GB_P6EDI.upload_p6',150);
318: retcode:=2;
319: errbuf := 'Reading P6 File - Invalid File Handle.';
320: when UTL_FILE.READ_ERROR then
321: UTL_FILE.FCLOSE(l_file_handle);
322: hr_utility.set_location('PAY_GB_P6EDI.upload_p6',160);
323: retcode:=2;
324: errbuf := 'Reading P6 File - Read Error.';

Line 321: UTL_FILE.FCLOSE(l_file_handle);

317: hr_utility.set_location('PAY_GB_P6EDI.upload_p6',150);
318: retcode:=2;
319: errbuf := 'Reading P6 File - Invalid File Handle.';
320: when UTL_FILE.READ_ERROR then
321: UTL_FILE.FCLOSE(l_file_handle);
322: hr_utility.set_location('PAY_GB_P6EDI.upload_p6',160);
323: retcode:=2;
324: errbuf := 'Reading P6 File - Read Error.';
325: when NO_DATA_FOUND then

Line 326: UTL_FILE.FCLOSE(l_file_handle);

322: hr_utility.set_location('PAY_GB_P6EDI.upload_p6',160);
323: retcode:=2;
324: errbuf := 'Reading P6 File - Read Error.';
325: when NO_DATA_FOUND then
326: UTL_FILE.FCLOSE(l_file_handle);
327: hr_utility.set_location('PAY_GB_P6EDI.upload_p6',170);
328: retcode:=2;
329: errbuf := 'No Data Found.';
330: end;