APPS.PER_CAGR_UTILITY_PKG dependencies on UTL_FILE

Line 946: WHERE name = 'utl_file_dir';

942: CURSOR csr_filepath IS
943: SELECT decode(substr(value,1,INSTR(value,',')-1),
944: NULL, value, substr(value,1,INSTR(value,',')-1)) "filepath"
945: FROM v$parameter
946: WHERE name = 'utl_file_dir';
947:
948: CURSOR csr_log(l_level in NUMBER) IS
949: SELECT text
950: FROM per_cagr_log

Line 964: l_fileh utl_file.file_type;

960: l_cagr_log_table logTab;
961: l_filepath varchar2(255);
962: l_name varchar2(20);
963: l_log_detail varchar2(30);
964: l_fileh utl_file.file_type;
965:
966: BEGIN
967: --
968: hr_utility.set_location('Entering:'||l_proc, 10);

Line 995: l_fileh := utl_file.fopen(l_filepath,l_name,'w');

991: end if;
992: --
993: -- check if the file alrteady exists, else
994: -- attempt to open a file for write
995: l_fileh := utl_file.fopen(l_filepath,l_name,'w');
996: hr_utility.set_location(l_proc, 20);
997:
998: -- get log entries restricted to certain levels
999: l_log_detail := fnd_profile.value('PER_CAGR_LOG_DETAIL');

Line 1011: utl_file.put_line(l_fileh,l_cagr_log_table(i));

1007: fetch csr_log BULK COLLECT into l_cagr_log_table;
1008: close csr_log;
1009: If l_cagr_log_table.count > 0 then
1010: for i in l_cagr_log_table.first .. l_cagr_log_table.last loop
1011: utl_file.put_line(l_fileh,l_cagr_log_table(i));
1012: end loop;
1013: end if;
1014:
1015: -- close file

Line 1016: utl_file.fclose(l_fileh);

1012: end loop;
1013: end if;
1014:
1015: -- close file
1016: utl_file.fclose(l_fileh);
1017:
1018: exception
1019: when UTL_FILE.INVALID_PATH then
1020: fnd_message.set_name('PER', 'HR_289832_CAGR_NO_FILEPATH');

Line 1019: when UTL_FILE.INVALID_PATH then

1015: -- close file
1016: utl_file.fclose(l_fileh);
1017:
1018: exception
1019: when UTL_FILE.INVALID_PATH then
1020: fnd_message.set_name('PER', 'HR_289832_CAGR_NO_FILEPATH');
1021: fnd_message.raise_error;
1022: when UTL_FILE.WRITE_ERROR then
1023: fnd_message.set_name('PER', 'HR_289833_CAGR_FILE_WRITE_ERR');

Line 1022: when UTL_FILE.WRITE_ERROR then

1018: exception
1019: when UTL_FILE.INVALID_PATH then
1020: fnd_message.set_name('PER', 'HR_289832_CAGR_NO_FILEPATH');
1021: fnd_message.raise_error;
1022: when UTL_FILE.WRITE_ERROR then
1023: fnd_message.set_name('PER', 'HR_289833_CAGR_FILE_WRITE_ERR');
1024: fnd_message.raise_error;
1025: end;
1026: