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_FI_TC_DP_UPLOAD dependencies on UTL_FILE

Line 48: l_file_type UTL_FILE.file_type;

44: l_legislation_code per_business_groups.legislation_code%TYPE;
45: l_bg_name per_business_groups.name%TYPE;
46:
47: -- File Handling variables
48: l_file_type UTL_FILE.file_type;
49: l_filename VARCHAR2 (240);
50: l_location VARCHAR2 (4000);
51: l_line_read VARCHAR2 (4000) := NULL;
52:

Line 279: UTL_FILE.fopen (l_location, l_filename, c_read_file, c_max_linesize);

275: END IF;
276:
277: -- Open flat file
278: l_file_type :=
279: UTL_FILE.fopen (l_location, l_filename, c_read_file, c_max_linesize);
280:
281: -- Create the Batch header
282: l_batch_id := hr_pump_utils.create_batch_header
283: (p_batch_name => p_batch_name,

Line 296: UTL_FILE.get_line (l_file_type, l_line_read);

292:
293: <>
294: LOOP
295: BEGIN
296: UTL_FILE.get_line (l_file_type, l_line_read);
297: l_batch_seq := l_batch_seq + 1;
298: EXCEPTION
299: WHEN VALUE_ERROR THEN
300: -- Input line too large for buffer specified in UTL_FILE.fopen

Line 300: -- Input line too large for buffer specified in UTL_FILE.fopen

296: UTL_FILE.get_line (l_file_type, l_line_read);
297: l_batch_seq := l_batch_seq + 1;
298: EXCEPTION
299: WHEN VALUE_ERROR THEN
300: -- Input line too large for buffer specified in UTL_FILE.fopen
301:
302: IF UTL_FILE.is_open (l_file_type) THEN
303: UTL_FILE.fclose (l_file_type);
304: END IF;

Line 302: IF UTL_FILE.is_open (l_file_type) THEN

298: EXCEPTION
299: WHEN VALUE_ERROR THEN
300: -- Input line too large for buffer specified in UTL_FILE.fopen
301:
302: IF UTL_FILE.is_open (l_file_type) THEN
303: UTL_FILE.fclose (l_file_type);
304: END IF;
305:
306: hr_utility.set_location (l_proc, 50);

Line 303: UTL_FILE.fclose (l_file_type);

299: WHEN VALUE_ERROR THEN
300: -- Input line too large for buffer specified in UTL_FILE.fopen
301:
302: IF UTL_FILE.is_open (l_file_type) THEN
303: UTL_FILE.fclose (l_file_type);
304: END IF;
305:
306: hr_utility.set_location (l_proc, 50);
307: retcode := c_error;

Line 853: UTL_FILE.fclose (l_file_type);

849:
850: -- Commit the outstanding records
851: COMMIT;
852:
853: UTL_FILE.fclose (l_file_type);
854: hr_utility.set_location ( 'Leaving:'|| l_proc, 320);
855:
856: -- Most of these exceptions are not translated as they should not happen normally
857: -- If they do happen, something is seriously wrong and SysAdmin interference will be necessary.

Line 863: IF UTL_FILE.is_open (l_file_type) THEN

859: EXCEPTION
860: WHEN e_fatal_error THEN
861: -- No directory specified
862: -- Close the file in case of error
863: IF UTL_FILE.is_open (l_file_type) THEN
864: UTL_FILE.fclose (l_file_type);
865: END IF;
866:
867: hr_utility.set_location (l_proc, 330);

Line 864: UTL_FILE.fclose (l_file_type);

860: WHEN e_fatal_error THEN
861: -- No directory specified
862: -- Close the file in case of error
863: IF UTL_FILE.is_open (l_file_type) THEN
864: UTL_FILE.fclose (l_file_type);
865: END IF;
866:
867: hr_utility.set_location (l_proc, 330);
868:

Line 878: WHEN UTL_FILE.invalid_operation THEN

874:
875: -- Return the message to the ConcMgr (This msg will appear in the log file)
876: errbuf := hr_utility.get_message;
877:
878: WHEN UTL_FILE.invalid_operation THEN
879: -- File could not be opened as requested, perhaps because of operating system permissions
880: -- Also raised when attempting a write operation on a file opened for read, or a read operation
881: -- on a file opened for write.
882:

Line 884: IF UTL_FILE.is_open (l_file_type) THEN

880: -- Also raised when attempting a write operation on a file opened for read, or a read operation
881: -- on a file opened for write.
882:
883:
884: IF UTL_FILE.is_open (l_file_type) THEN
885: UTL_FILE.fclose (l_file_type);
886: END IF;
887:
888: hr_utility.set_location (l_proc, 340);

Line 885: UTL_FILE.fclose (l_file_type);

881: -- on a file opened for write.
882:
883:
884: IF UTL_FILE.is_open (l_file_type) THEN
885: UTL_FILE.fclose (l_file_type);
886: END IF;
887:
888: hr_utility.set_location (l_proc, 340);
889: retcode := c_error;

Line 893: WHEN UTL_FILE.internal_error THEN

889: retcode := c_error;
890: errbuf := 'Reading File ('||l_location ||' -> '
891: || l_filename
892: || ') - Invalid Operation.';
893: WHEN UTL_FILE.internal_error THEN
894: -- Unspecified internal error
895: IF UTL_FILE.is_open (l_file_type) THEN
896: UTL_FILE.fclose (l_file_type);
897: END IF;

Line 895: IF UTL_FILE.is_open (l_file_type) THEN

891: || l_filename
892: || ') - Invalid Operation.';
893: WHEN UTL_FILE.internal_error THEN
894: -- Unspecified internal error
895: IF UTL_FILE.is_open (l_file_type) THEN
896: UTL_FILE.fclose (l_file_type);
897: END IF;
898:
899: hr_utility.set_location (l_proc, 350);

Line 896: UTL_FILE.fclose (l_file_type);

892: || ') - Invalid Operation.';
893: WHEN UTL_FILE.internal_error THEN
894: -- Unspecified internal error
895: IF UTL_FILE.is_open (l_file_type) THEN
896: UTL_FILE.fclose (l_file_type);
897: END IF;
898:
899: hr_utility.set_location (l_proc, 350);
900: retcode := c_error;

Line 907: WHEN UTL_FILE.invalid_mode THEN

903: || ' -> '
904: || l_filename
905: || ') - Internal Error.';
906:
907: WHEN UTL_FILE.invalid_mode THEN
908: -- Invalid string specified for file mode
909:
910: IF UTL_FILE.is_open (l_file_type)
911: THEN

Line 910: IF UTL_FILE.is_open (l_file_type)

906:
907: WHEN UTL_FILE.invalid_mode THEN
908: -- Invalid string specified for file mode
909:
910: IF UTL_FILE.is_open (l_file_type)
911: THEN
912: UTL_FILE.fclose (l_file_type);
913: END IF;
914:

Line 912: UTL_FILE.fclose (l_file_type);

908: -- Invalid string specified for file mode
909:
910: IF UTL_FILE.is_open (l_file_type)
911: THEN
912: UTL_FILE.fclose (l_file_type);
913: END IF;
914:
915: hr_utility.set_location (l_proc, 360);
916: retcode := c_error;

Line 923: WHEN UTL_FILE.invalid_path THEN

919: || ' -> '
920: || l_filename
921: || ') - Invalid Mode.';
922:
923: WHEN UTL_FILE.invalid_path THEN
924: -- Directory or filename is invalid or not accessible
925:
926: IF UTL_FILE.is_open (l_file_type) THEN
927: UTL_FILE.fclose (l_file_type);

Line 926: IF UTL_FILE.is_open (l_file_type) THEN

922:
923: WHEN UTL_FILE.invalid_path THEN
924: -- Directory or filename is invalid or not accessible
925:
926: IF UTL_FILE.is_open (l_file_type) THEN
927: UTL_FILE.fclose (l_file_type);
928: END IF;
929:
930: retcode := c_error;

Line 927: UTL_FILE.fclose (l_file_type);

923: WHEN UTL_FILE.invalid_path THEN
924: -- Directory or filename is invalid or not accessible
925:
926: IF UTL_FILE.is_open (l_file_type) THEN
927: UTL_FILE.fclose (l_file_type);
928: END IF;
929:
930: retcode := c_error;
931: errbuf := 'Reading File ('

Line 938: WHEN UTL_FILE.invalid_filehandle THEN

934: || l_filename
935: || ') - Invalid Path or Filename.';
936: hr_utility.set_location (l_proc, 370);
937:
938: WHEN UTL_FILE.invalid_filehandle THEN
939: -- File type does not specify an open file
940:
941: IF UTL_FILE.is_open (l_file_type) THEN
942: UTL_FILE.fclose (l_file_type);

Line 941: IF UTL_FILE.is_open (l_file_type) THEN

937:
938: WHEN UTL_FILE.invalid_filehandle THEN
939: -- File type does not specify an open file
940:
941: IF UTL_FILE.is_open (l_file_type) THEN
942: UTL_FILE.fclose (l_file_type);
943: END IF;
944:
945: hr_utility.set_location (l_proc, 380);

Line 942: UTL_FILE.fclose (l_file_type);

938: WHEN UTL_FILE.invalid_filehandle THEN
939: -- File type does not specify an open file
940:
941: IF UTL_FILE.is_open (l_file_type) THEN
942: UTL_FILE.fclose (l_file_type);
943: END IF;
944:
945: hr_utility.set_location (l_proc, 380);
946: retcode := c_error;

Line 953: WHEN UTL_FILE.read_error THEN

949: || ' -> '
950: || l_filename
951: || ') - Invalid File Type.';
952:
953: WHEN UTL_FILE.read_error THEN
954: -- Operating system error occurred during a read operation
955:
956: IF UTL_FILE.is_open (l_file_type) THEN
957: UTL_FILE.fclose (l_file_type);

Line 956: IF UTL_FILE.is_open (l_file_type) THEN

952:
953: WHEN UTL_FILE.read_error THEN
954: -- Operating system error occurred during a read operation
955:
956: IF UTL_FILE.is_open (l_file_type) THEN
957: UTL_FILE.fclose (l_file_type);
958: END IF;
959:
960: hr_utility.set_location (l_proc, 390);

Line 957: UTL_FILE.fclose (l_file_type);

953: WHEN UTL_FILE.read_error THEN
954: -- Operating system error occurred during a read operation
955:
956: IF UTL_FILE.is_open (l_file_type) THEN
957: UTL_FILE.fclose (l_file_type);
958: END IF;
959:
960: hr_utility.set_location (l_proc, 390);
961: retcode := c_error;