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

Line 58: WHEN utl_file.invalid_path then

54: fnd_file.put_line(fnd_file.log,'------------Output XML File----------------');
55: fnd_file.put_line(fnd_file.log,'File' || l_file_name );
56: fnd_file.put_line(fnd_file.log,'-------------------------------------------');
57: EXCEPTION
58: WHEN utl_file.invalid_path then
59: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
60: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
61: hr_utility.raise_error;
62: --

Line 59: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');

55: fnd_file.put_line(fnd_file.log,'File' || l_file_name );
56: fnd_file.put_line(fnd_file.log,'-------------------------------------------');
57: EXCEPTION
58: WHEN utl_file.invalid_path then
59: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
60: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
61: hr_utility.raise_error;
62: --
63: WHEN utl_file.invalid_mode then

Line 63: WHEN utl_file.invalid_mode then

59: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
60: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
61: hr_utility.raise_error;
62: --
63: WHEN utl_file.invalid_mode then
64: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
65: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
66: hr_utility.raise_error;
67: --

Line 68: WHEN utl_file.invalid_filehandle then

64: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
65: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
66: hr_utility.raise_error;
67: --
68: WHEN utl_file.invalid_filehandle then
69: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
70: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
71: hr_utility.raise_error;
72: --

Line 73: WHEN utl_file.invalid_operation then

69: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
70: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
71: hr_utility.raise_error;
72: --
73: WHEN utl_file.invalid_operation then
74: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
75: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
76: hr_utility.raise_error;
77: --

Line 78: WHEN utl_file.read_error then

74: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
75: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
76: hr_utility.raise_error;
77: --
78: WHEN utl_file.read_error then
79: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
80: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
81: hr_utility.raise_error;
82: --

Line 1051: WHEN utl_file.invalid_path then

1047: fnd_file.put_line(fnd_file.log,'File' || p_output_fname );
1048: fnd_file.put_line(fnd_file.log,'-------------------------------------------');*/
1049: /*
1050: EXCEPTION
1051: WHEN utl_file.invalid_path then
1052: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
1053: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1054: hr_utility.raise_error;
1055: --

Line 1052: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');

1048: fnd_file.put_line(fnd_file.log,'-------------------------------------------');*/
1049: /*
1050: EXCEPTION
1051: WHEN utl_file.invalid_path then
1052: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
1053: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1054: hr_utility.raise_error;
1055: --
1056: WHEN utl_file.invalid_mode then

Line 1056: WHEN utl_file.invalid_mode then

1052: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
1053: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1054: hr_utility.raise_error;
1055: --
1056: WHEN utl_file.invalid_mode then
1057: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
1058: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1059: hr_utility.raise_error;
1060: --

Line 1061: WHEN utl_file.invalid_filehandle then

1057: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
1058: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1059: hr_utility.raise_error;
1060: --
1061: WHEN utl_file.invalid_filehandle then
1062: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
1063: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1064: hr_utility.raise_error;
1065: --

Line 1066: WHEN utl_file.invalid_operation then

1062: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
1063: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1064: hr_utility.raise_error;
1065: --
1066: WHEN utl_file.invalid_operation then
1067: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
1068: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1069: hr_utility.raise_error;
1070: --

Line 1071: WHEN utl_file.read_error then

1067: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
1068: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1069: hr_utility.raise_error;
1070: --
1071: WHEN utl_file.read_error then
1072: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
1073: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1074: hr_utility.raise_error;
1075: --

Line 1259: /*p_l_fp1 UTL_FILE.FILE_TYPE;

1255: l_gosi_office_id number;
1256: l_gosi_office varchar2(260);
1257: l_gosi_office_code varchar2(30);
1258: l_employer_gosi_number varchar2(30);
1259: /*p_l_fp1 UTL_FILE.FILE_TYPE;
1260: l_audit_log_dir1 varchar2(500) := '/sqlcom/outbound';
1261: l_file_name1 varchar2(50);
1262: l_check_flag1 number;
1263: l_file_created number := 0;*/

Line 2470: WHERE LOWER(name) = 'utl_file_dir';

2466: BEGIN
2467: SELECT value
2468: INTO l_audit_log_dir1
2469: FROM v$parameter
2470: WHERE LOWER(name) = 'utl_file_dir';
2471: -- Check whether more than one util file directory is found
2472: IF INSTR(l_audit_log_dir1,',') > 0 THEN
2473: l_audit_log_dir1 := substr(l_audit_log_dir1,1,instr(l_audit_log_dir1,',')-1);
2474: END IF;

Line 2487: p_l_fp1 := utl_file.fopen(l_audit_log_dir1,l_file_name1,'A');

2483: ELSE
2484: p_output_fname := l_audit_log_dir1 || '\' || l_file_name1;
2485: END IF;
2486: -- getting Agency name
2487: p_l_fp1 := utl_file.fopen(l_audit_log_dir1,l_file_name1,'A');
2488: IF L_FILE_CREATED = 0 THEN
2489: utl_file.put_line(p_l_fp1,'');
2490: utl_file.put_line(p_l_fp1,'');
2491: END IF;

Line 2489: utl_file.put_line(p_l_fp1,'');

2485: END IF;
2486: -- getting Agency name
2487: p_l_fp1 := utl_file.fopen(l_audit_log_dir1,l_file_name1,'A');
2488: IF L_FILE_CREATED = 0 THEN
2489: utl_file.put_line(p_l_fp1,'');
2490: utl_file.put_line(p_l_fp1,'');
2491: END IF;
2492: -- Writing from and to dates
2493: utl_file.put_line(p_l_fp1,'');

Line 2490: utl_file.put_line(p_l_fp1,'');

2486: -- getting Agency name
2487: p_l_fp1 := utl_file.fopen(l_audit_log_dir1,l_file_name1,'A');
2488: IF L_FILE_CREATED = 0 THEN
2489: utl_file.put_line(p_l_fp1,'');
2490: utl_file.put_line(p_l_fp1,'');
2491: END IF;
2492: -- Writing from and to dates
2493: utl_file.put_line(p_l_fp1,'');
2494: -- Write the header fields to XML File.

Line 2493: utl_file.put_line(p_l_fp1,'');

2489: utl_file.put_line(p_l_fp1,'');
2490: utl_file.put_line(p_l_fp1,'');
2491: END IF;
2492: -- Writing from and to dates
2493: utl_file.put_line(p_l_fp1,'');
2494: -- Write the header fields to XML File.
2495: --WriteXMLvalues(p_l_fp,'P0_from_date',to_char(p_from_date,'dd') || ' ' || trim(to_char(p_from_date,'Month')) || ' ' || to_char(p_from_date,'yyyy') );
2496: --WriteXMLvalues(p_l_fp,'P0_to_date',to_char(p_to_date,'dd') || ' ' ||to_char(p_to_date,'Month') || ' ' || to_char(p_to_date,'yyyy') );
2497: -- Loop through PL/SQL Table and write the values into the XML File.

Line 2503: utl_file.put_line(p_l_fp1,'');

2499: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
2500: WriteXMLvalues(p_l_fp1,vXMLTable(ctr_table).TagName ,vXMLTable(ctr_table).TagValue);
2501: END LOOP;
2502: -- Write the end tag and close the XML File.
2503: utl_file.put_line(p_l_fp1,'');
2504: --utl_file.put_line(p_l_fp1,'');
2505: utl_file.fclose(p_l_fp1);
2506: l_file_created := 1; */
2507: END LOOP;

Line 2504: --utl_file.put_line(p_l_fp1,'');

2500: WriteXMLvalues(p_l_fp1,vXMLTable(ctr_table).TagName ,vXMLTable(ctr_table).TagValue);
2501: END LOOP;
2502: -- Write the end tag and close the XML File.
2503: utl_file.put_line(p_l_fp1,'');
2504: --utl_file.put_line(p_l_fp1,'');
2505: utl_file.fclose(p_l_fp1);
2506: l_file_created := 1; */
2507: END LOOP;
2508: /*End of call to report5*/

Line 2505: utl_file.fclose(p_l_fp1);

2501: END LOOP;
2502: -- Write the end tag and close the XML File.
2503: utl_file.put_line(p_l_fp1,'');
2504: --utl_file.put_line(p_l_fp1,'');
2505: utl_file.fclose(p_l_fp1);
2506: l_file_created := 1; */
2507: END LOOP;
2508: /*End of call to report5*/
2509: WritetoCLOB ( l_xfdf_blob );

Line 2523: WHEN utl_file.invalid_path then

2519: fnd_file.put_line(fnd_file.log,'-------------------------------------------');
2520: p_output_fname := l_file_name;*/
2521: /*
2522: EXCEPTION
2523: WHEN utl_file.invalid_path then
2524: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
2525: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2526: hr_utility.raise_error;
2527: --

Line 2524: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');

2520: p_output_fname := l_file_name;*/
2521: /*
2522: EXCEPTION
2523: WHEN utl_file.invalid_path then
2524: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
2525: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2526: hr_utility.raise_error;
2527: --
2528: WHEN utl_file.invalid_mode then

Line 2528: WHEN utl_file.invalid_mode then

2524: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
2525: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2526: hr_utility.raise_error;
2527: --
2528: WHEN utl_file.invalid_mode then
2529: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
2530: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2531: hr_utility.raise_error;
2532: --

Line 2533: WHEN utl_file.invalid_filehandle then

2529: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
2530: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2531: hr_utility.raise_error;
2532: --
2533: WHEN utl_file.invalid_filehandle then
2534: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
2535: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2536: hr_utility.raise_error;
2537: --

Line 2538: WHEN utl_file.invalid_operation then

2534: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
2535: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2536: hr_utility.raise_error;
2537: --
2538: WHEN utl_file.invalid_operation then
2539: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
2540: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2541: hr_utility.raise_error;
2542: --

Line 2543: WHEN utl_file.read_error then

2539: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
2540: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2541: hr_utility.raise_error;
2542: --
2543: WHEN utl_file.read_error then
2544: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
2545: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2546: hr_utility.raise_error;
2547: --

Line 3758: WHEN utl_file.invalid_path then

3754: hr_utility.set_location('Finished Procedure Workers movement Report ',90);
3755: /*Write the values to xml file*/
3756: /*
3757: EXCEPTION
3758: WHEN utl_file.invalid_path then
3759: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
3760: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3761: hr_utility.raise_error;
3762: --

Line 3759: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');

3755: /*Write the values to xml file*/
3756: /*
3757: EXCEPTION
3758: WHEN utl_file.invalid_path then
3759: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
3760: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3761: hr_utility.raise_error;
3762: --
3763: WHEN utl_file.invalid_mode then

Line 3763: WHEN utl_file.invalid_mode then

3759: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
3760: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3761: hr_utility.raise_error;
3762: --
3763: WHEN utl_file.invalid_mode then
3764: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
3765: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3766: hr_utility.raise_error;
3767: --

Line 3768: WHEN utl_file.invalid_filehandle then

3764: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
3765: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3766: hr_utility.raise_error;
3767: --
3768: WHEN utl_file.invalid_filehandle then
3769: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
3770: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3771: hr_utility.raise_error;
3772: --

Line 3773: WHEN utl_file.invalid_operation then

3769: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
3770: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3771: hr_utility.raise_error;
3772: --
3773: WHEN utl_file.invalid_operation then
3774: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
3775: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3776: hr_utility.raise_error;
3777: --

Line 3778: WHEN utl_file.read_error then

3774: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
3775: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3776: hr_utility.raise_error;
3777: --
3778: WHEN utl_file.read_error then
3779: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
3780: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3781: hr_utility.raise_error;
3782: --