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_AE_SI_REPORTS dependencies on HR_UTILITY

Line 448: hr_utility.set_location('Entering FORM1 ',10);

444: -- To clear the PL/SQL Table values.
445: t_store_def_bal.DELETE;
446: vXMLTable.DELETE;
447: vCtr := 1;
448: hr_utility.set_location('Entering FORM1 ',10);
449:
450: /* Fetch local nationality */
451: OPEN csr_get_loc_nat;
452: FETCH csr_get_loc_nat into l_nat_cd;

Line 1174: hr_utility.set_location('Finished creating xml data for Procedure FORM1 ',20);

1170: EXIT;
1171: END IF;
1172: END LOOP;
1173:
1174: hr_utility.set_location('Finished creating xml data for Procedure FORM1 ',20);
1175: WritetoCLOB ( l_xfdf_blob );
1176:
1177: EXCEPTION
1178: WHEN utl_file.invalid_path then

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

1175: WritetoCLOB ( l_xfdf_blob );
1176:
1177: EXCEPTION
1178: WHEN utl_file.invalid_path then
1179: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
1180: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1181: hr_utility.raise_error;
1182: --
1183: WHEN utl_file.invalid_mode then

Line 1180: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

1176:
1177: EXCEPTION
1178: WHEN utl_file.invalid_path then
1179: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
1180: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1181: hr_utility.raise_error;
1182: --
1183: WHEN utl_file.invalid_mode then
1184: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

Line 1181: hr_utility.raise_error;

1177: EXCEPTION
1178: WHEN utl_file.invalid_path then
1179: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
1180: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1181: hr_utility.raise_error;
1182: --
1183: WHEN utl_file.invalid_mode then
1184: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
1185: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 1184: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

1180: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1181: hr_utility.raise_error;
1182: --
1183: WHEN utl_file.invalid_mode then
1184: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
1185: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1186: hr_utility.raise_error;
1187: --
1188: WHEN utl_file.invalid_filehandle then

Line 1185: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

1181: hr_utility.raise_error;
1182: --
1183: WHEN utl_file.invalid_mode then
1184: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
1185: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1186: hr_utility.raise_error;
1187: --
1188: WHEN utl_file.invalid_filehandle then
1189: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

Line 1186: hr_utility.raise_error;

1182: --
1183: WHEN utl_file.invalid_mode then
1184: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
1185: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1186: hr_utility.raise_error;
1187: --
1188: WHEN utl_file.invalid_filehandle then
1189: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
1190: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 1189: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

1185: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1186: hr_utility.raise_error;
1187: --
1188: WHEN utl_file.invalid_filehandle then
1189: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
1190: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1191: hr_utility.raise_error;
1192: --
1193: WHEN utl_file.invalid_operation then

Line 1190: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

1186: hr_utility.raise_error;
1187: --
1188: WHEN utl_file.invalid_filehandle then
1189: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
1190: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1191: hr_utility.raise_error;
1192: --
1193: WHEN utl_file.invalid_operation then
1194: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

Line 1191: hr_utility.raise_error;

1187: --
1188: WHEN utl_file.invalid_filehandle then
1189: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
1190: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1191: hr_utility.raise_error;
1192: --
1193: WHEN utl_file.invalid_operation then
1194: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
1195: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 1194: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

1190: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1191: hr_utility.raise_error;
1192: --
1193: WHEN utl_file.invalid_operation then
1194: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
1195: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1196: hr_utility.raise_error;
1197: --
1198: WHEN utl_file.read_error then

Line 1195: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

1191: hr_utility.raise_error;
1192: --
1193: WHEN utl_file.invalid_operation then
1194: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
1195: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1196: hr_utility.raise_error;
1197: --
1198: WHEN utl_file.read_error then
1199: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

Line 1196: hr_utility.raise_error;

1192: --
1193: WHEN utl_file.invalid_operation then
1194: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
1195: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1196: hr_utility.raise_error;
1197: --
1198: WHEN utl_file.read_error then
1199: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
1200: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 1199: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

1195: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1196: hr_utility.raise_error;
1197: --
1198: WHEN utl_file.read_error then
1199: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
1200: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1201: hr_utility.raise_error;
1202: --
1203: WHEN others THEN

Line 1200: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

1196: hr_utility.raise_error;
1197: --
1198: WHEN utl_file.read_error then
1199: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
1200: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1201: hr_utility.raise_error;
1202: --
1203: WHEN others THEN
1204: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

Line 1201: hr_utility.raise_error;

1197: --
1198: WHEN utl_file.read_error then
1199: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
1200: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1201: hr_utility.raise_error;
1202: --
1203: WHEN others THEN
1204: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1205: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

Line 1204: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

1200: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1201: hr_utility.raise_error;
1202: --
1203: WHEN others THEN
1204: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1205: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
1206: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1207: hr_utility.raise_error;
1208: END FORM1;

Line 1205: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

1201: hr_utility.raise_error;
1202: --
1203: WHEN others THEN
1204: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1205: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
1206: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1207: hr_utility.raise_error;
1208: END FORM1;
1209: -------------------------------------------------------------------------------------------

Line 1206: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

1202: --
1203: WHEN others THEN
1204: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1205: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
1206: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1207: hr_utility.raise_error;
1208: END FORM1;
1209: -------------------------------------------------------------------------------------------
1210: PROCEDURE FORM2

Line 1207: hr_utility.raise_error;

1203: WHEN others THEN
1204: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1205: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
1206: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1207: hr_utility.raise_error;
1208: END FORM1;
1209: -------------------------------------------------------------------------------------------
1210: PROCEDURE FORM2
1211: (p_request_id NUMBER

Line 1495: hr_utility.set_location('Entering FORM1 ',10);

1491:
1492: -- To clear the PL/SQL Table values.
1493: vXMLTable.DELETE;
1494: vCtr := 1;
1495: hr_utility.set_location('Entering FORM1 ',10);
1496:
1497: /* Fetch local nationality */
1498: OPEN csr_get_loc_nat;
1499: FETCH csr_get_loc_nat into l_nat_cd;

Line 2034: hr_utility.set_location('Finished creating xml data for Procedure FORM1 ',20);

2030: l_new_processed := 1;
2031: EXIT;
2032: END IF;
2033: END LOOP;
2034: hr_utility.set_location('Finished creating xml data for Procedure FORM1 ',20);
2035: WritetoCLOB ( l_xfdf_blob );
2036: EXCEPTION
2037: WHEN utl_file.invalid_path then
2038: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');

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

2034: hr_utility.set_location('Finished creating xml data for Procedure FORM1 ',20);
2035: WritetoCLOB ( l_xfdf_blob );
2036: EXCEPTION
2037: WHEN utl_file.invalid_path then
2038: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
2039: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2040: hr_utility.raise_error;
2041: --
2042: WHEN utl_file.invalid_mode then

Line 2039: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

2035: WritetoCLOB ( l_xfdf_blob );
2036: EXCEPTION
2037: WHEN utl_file.invalid_path then
2038: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
2039: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2040: hr_utility.raise_error;
2041: --
2042: WHEN utl_file.invalid_mode then
2043: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

Line 2040: hr_utility.raise_error;

2036: EXCEPTION
2037: WHEN utl_file.invalid_path then
2038: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
2039: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2040: hr_utility.raise_error;
2041: --
2042: WHEN utl_file.invalid_mode then
2043: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
2044: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 2043: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

2039: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2040: hr_utility.raise_error;
2041: --
2042: WHEN utl_file.invalid_mode then
2043: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
2044: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2045: hr_utility.raise_error;
2046: --
2047: WHEN utl_file.invalid_filehandle then

Line 2044: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

2040: hr_utility.raise_error;
2041: --
2042: WHEN utl_file.invalid_mode then
2043: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
2044: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2045: hr_utility.raise_error;
2046: --
2047: WHEN utl_file.invalid_filehandle then
2048: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

Line 2045: hr_utility.raise_error;

2041: --
2042: WHEN utl_file.invalid_mode then
2043: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
2044: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2045: hr_utility.raise_error;
2046: --
2047: WHEN utl_file.invalid_filehandle then
2048: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
2049: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 2048: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

2044: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2045: hr_utility.raise_error;
2046: --
2047: WHEN utl_file.invalid_filehandle then
2048: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
2049: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2050: hr_utility.raise_error;
2051: --
2052: WHEN utl_file.invalid_operation then

Line 2049: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

2045: hr_utility.raise_error;
2046: --
2047: WHEN utl_file.invalid_filehandle then
2048: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
2049: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2050: hr_utility.raise_error;
2051: --
2052: WHEN utl_file.invalid_operation then
2053: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

Line 2050: hr_utility.raise_error;

2046: --
2047: WHEN utl_file.invalid_filehandle then
2048: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
2049: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2050: hr_utility.raise_error;
2051: --
2052: WHEN utl_file.invalid_operation then
2053: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
2054: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 2053: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

2049: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2050: hr_utility.raise_error;
2051: --
2052: WHEN utl_file.invalid_operation then
2053: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
2054: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2055: hr_utility.raise_error;
2056: --
2057: WHEN utl_file.read_error then

Line 2054: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

2050: hr_utility.raise_error;
2051: --
2052: WHEN utl_file.invalid_operation then
2053: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
2054: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2055: hr_utility.raise_error;
2056: --
2057: WHEN utl_file.read_error then
2058: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

Line 2055: hr_utility.raise_error;

2051: --
2052: WHEN utl_file.invalid_operation then
2053: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
2054: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2055: hr_utility.raise_error;
2056: --
2057: WHEN utl_file.read_error then
2058: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
2059: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 2058: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

2054: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2055: hr_utility.raise_error;
2056: --
2057: WHEN utl_file.read_error then
2058: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
2059: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2060: hr_utility.raise_error;
2061: --
2062: WHEN others THEN

Line 2059: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

2055: hr_utility.raise_error;
2056: --
2057: WHEN utl_file.read_error then
2058: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
2059: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2060: hr_utility.raise_error;
2061: --
2062: WHEN others THEN
2063: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

Line 2060: hr_utility.raise_error;

2056: --
2057: WHEN utl_file.read_error then
2058: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
2059: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2060: hr_utility.raise_error;
2061: --
2062: WHEN others THEN
2063: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2064: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

Line 2063: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

2059: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2060: hr_utility.raise_error;
2061: --
2062: WHEN others THEN
2063: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2064: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
2065: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2066: hr_utility.raise_error;
2067: END FORM2;

Line 2064: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

2060: hr_utility.raise_error;
2061: --
2062: WHEN others THEN
2063: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2064: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
2065: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2066: hr_utility.raise_error;
2067: END FORM2;
2068: -------------------------------------------------------------------------------------------

Line 2065: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

2061: --
2062: WHEN others THEN
2063: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2064: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
2065: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2066: hr_utility.raise_error;
2067: END FORM2;
2068: -------------------------------------------------------------------------------------------
2069: PROCEDURE FORM6

Line 2066: hr_utility.raise_error;

2062: WHEN others THEN
2063: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2064: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
2065: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2066: hr_utility.raise_error;
2067: END FORM2;
2068: -------------------------------------------------------------------------------------------
2069: PROCEDURE FORM6
2070: (p_request_id NUMBER

Line 2246: hr_utility.set_location('Entering FORM6 ',10);

2242: l_input_date := '01-'||p_effective_month||'-'||p_effective_year;
2243: l_effective_date := last_day(to_date(l_input_date,'DD-MM-YYYY'));
2244: INSERT INTO fnd_sessions (session_id, effective_date)
2245: VALUES (userenv('sessionid'), l_effective_date);
2246: hr_utility.set_location('Entering FORM6 ',10);
2247:
2248: /* Fetch Local Nationality */
2249: OPEN csr_get_loc_nat;
2250: FETCH csr_get_loc_nat INTO l_nat_cd;

Line 2559: hr_utility.set_location('Finished creating xml data for Procedure FORM6 ',20);

2555: END LOOP;
2556: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
2557: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
2558: clob_to_blob(l_xfdf_string,l_xfdf_blob);
2559: hr_utility.set_location('Finished creating xml data for Procedure FORM6 ',20);
2560: EXCEPTION
2561: WHEN utl_file.invalid_path then
2562: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
2563: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

2558: clob_to_blob(l_xfdf_string,l_xfdf_blob);
2559: hr_utility.set_location('Finished creating xml data for Procedure FORM6 ',20);
2560: EXCEPTION
2561: WHEN utl_file.invalid_path then
2562: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
2563: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2564: hr_utility.raise_error;
2565: --
2566: WHEN utl_file.invalid_mode then

Line 2563: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

2559: hr_utility.set_location('Finished creating xml data for Procedure FORM6 ',20);
2560: EXCEPTION
2561: WHEN utl_file.invalid_path then
2562: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
2563: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2564: hr_utility.raise_error;
2565: --
2566: WHEN utl_file.invalid_mode then
2567: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

Line 2564: hr_utility.raise_error;

2560: EXCEPTION
2561: WHEN utl_file.invalid_path then
2562: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
2563: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2564: hr_utility.raise_error;
2565: --
2566: WHEN utl_file.invalid_mode then
2567: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
2568: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 2567: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

2563: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2564: hr_utility.raise_error;
2565: --
2566: WHEN utl_file.invalid_mode then
2567: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
2568: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2569: hr_utility.raise_error;
2570: --
2571: WHEN utl_file.invalid_filehandle then

Line 2568: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

2564: hr_utility.raise_error;
2565: --
2566: WHEN utl_file.invalid_mode then
2567: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
2568: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2569: hr_utility.raise_error;
2570: --
2571: WHEN utl_file.invalid_filehandle then
2572: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

Line 2569: hr_utility.raise_error;

2565: --
2566: WHEN utl_file.invalid_mode then
2567: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
2568: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2569: hr_utility.raise_error;
2570: --
2571: WHEN utl_file.invalid_filehandle then
2572: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
2573: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 2572: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

2568: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2569: hr_utility.raise_error;
2570: --
2571: WHEN utl_file.invalid_filehandle then
2572: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
2573: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2574: hr_utility.raise_error;
2575: --
2576: WHEN utl_file.invalid_operation then

Line 2573: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

2569: hr_utility.raise_error;
2570: --
2571: WHEN utl_file.invalid_filehandle then
2572: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
2573: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2574: hr_utility.raise_error;
2575: --
2576: WHEN utl_file.invalid_operation then
2577: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

Line 2574: hr_utility.raise_error;

2570: --
2571: WHEN utl_file.invalid_filehandle then
2572: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
2573: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2574: hr_utility.raise_error;
2575: --
2576: WHEN utl_file.invalid_operation then
2577: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
2578: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 2577: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

2573: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2574: hr_utility.raise_error;
2575: --
2576: WHEN utl_file.invalid_operation then
2577: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
2578: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2579: hr_utility.raise_error;
2580: --
2581: WHEN utl_file.read_error then

Line 2578: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

2574: hr_utility.raise_error;
2575: --
2576: WHEN utl_file.invalid_operation then
2577: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
2578: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2579: hr_utility.raise_error;
2580: --
2581: WHEN utl_file.read_error then
2582: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

Line 2579: hr_utility.raise_error;

2575: --
2576: WHEN utl_file.invalid_operation then
2577: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
2578: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2579: hr_utility.raise_error;
2580: --
2581: WHEN utl_file.read_error then
2582: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
2583: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 2582: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

2578: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2579: hr_utility.raise_error;
2580: --
2581: WHEN utl_file.read_error then
2582: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
2583: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2584: hr_utility.raise_error;
2585: --
2586: WHEN others THEN

Line 2583: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

2579: hr_utility.raise_error;
2580: --
2581: WHEN utl_file.read_error then
2582: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
2583: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2584: hr_utility.raise_error;
2585: --
2586: WHEN others THEN
2587: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

Line 2584: hr_utility.raise_error;

2580: --
2581: WHEN utl_file.read_error then
2582: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
2583: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2584: hr_utility.raise_error;
2585: --
2586: WHEN others THEN
2587: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2588: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

Line 2587: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

2583: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2584: hr_utility.raise_error;
2585: --
2586: WHEN others THEN
2587: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2588: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
2589: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2590: hr_utility.raise_error;
2591: END FORM6;

Line 2588: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

2584: hr_utility.raise_error;
2585: --
2586: WHEN others THEN
2587: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2588: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
2589: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2590: hr_utility.raise_error;
2591: END FORM6;
2592: -------------------------------------------------------------------------------------------

Line 2589: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

2585: --
2586: WHEN others THEN
2587: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2588: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
2589: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2590: hr_utility.raise_error;
2591: END FORM6;
2592: -------------------------------------------------------------------------------------------
2593: -------------------------------------------------------------------------------------------

Line 2590: hr_utility.raise_error;

2586: WHEN others THEN
2587: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2588: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
2589: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2590: hr_utility.raise_error;
2591: END FORM6;
2592: -------------------------------------------------------------------------------------------
2593: -------------------------------------------------------------------------------------------
2594: PROCEDURE FORM7

Line 2916: hr_utility.set_location('Entering FORM6 ',10);

2912: l_input_date := '01-'||p_effective_month||'-'||p_effective_year;
2913: l_effective_date := last_day(to_date(l_input_date,'DD-MM-YYYY'));
2914: INSERT INTO fnd_sessions (session_id, effective_date)
2915: VALUES (userenv('sessionid'), l_effective_date);
2916: hr_utility.set_location('Entering FORM6 ',10);
2917:
2918: /* Fetch Local Nationality */
2919: OPEN csr_get_loc_nat;
2920: FETCH csr_get_loc_nat INTO l_nat_cd;

Line 3745: hr_utility.set_location('Finished creating xml data for Procedure FORM6 ',20);

3741: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
3742: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
3743: clob_to_blob(l_xfdf_string,l_xfdf_blob);
3744:
3745: hr_utility.set_location('Finished creating xml data for Procedure FORM6 ',20);
3746: EXCEPTION
3747: WHEN utl_file.invalid_path then
3748: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
3749: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

3744:
3745: hr_utility.set_location('Finished creating xml data for Procedure FORM6 ',20);
3746: EXCEPTION
3747: WHEN utl_file.invalid_path then
3748: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
3749: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3750: hr_utility.raise_error;
3751: --
3752: WHEN utl_file.invalid_mode then

Line 3749: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

3745: hr_utility.set_location('Finished creating xml data for Procedure FORM6 ',20);
3746: EXCEPTION
3747: WHEN utl_file.invalid_path then
3748: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
3749: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3750: hr_utility.raise_error;
3751: --
3752: WHEN utl_file.invalid_mode then
3753: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

Line 3750: hr_utility.raise_error;

3746: EXCEPTION
3747: WHEN utl_file.invalid_path then
3748: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
3749: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3750: hr_utility.raise_error;
3751: --
3752: WHEN utl_file.invalid_mode then
3753: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
3754: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 3753: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

3749: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3750: hr_utility.raise_error;
3751: --
3752: WHEN utl_file.invalid_mode then
3753: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
3754: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3755: hr_utility.raise_error;
3756: --
3757: WHEN utl_file.invalid_filehandle then

Line 3754: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

3750: hr_utility.raise_error;
3751: --
3752: WHEN utl_file.invalid_mode then
3753: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
3754: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3755: hr_utility.raise_error;
3756: --
3757: WHEN utl_file.invalid_filehandle then
3758: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

Line 3755: hr_utility.raise_error;

3751: --
3752: WHEN utl_file.invalid_mode then
3753: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
3754: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3755: hr_utility.raise_error;
3756: --
3757: WHEN utl_file.invalid_filehandle then
3758: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
3759: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 3758: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

3754: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3755: hr_utility.raise_error;
3756: --
3757: WHEN utl_file.invalid_filehandle then
3758: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
3759: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3760: hr_utility.raise_error;
3761: --
3762: WHEN utl_file.invalid_operation then

Line 3759: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

3755: hr_utility.raise_error;
3756: --
3757: WHEN utl_file.invalid_filehandle then
3758: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
3759: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3760: hr_utility.raise_error;
3761: --
3762: WHEN utl_file.invalid_operation then
3763: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

Line 3760: hr_utility.raise_error;

3756: --
3757: WHEN utl_file.invalid_filehandle then
3758: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
3759: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3760: hr_utility.raise_error;
3761: --
3762: WHEN utl_file.invalid_operation then
3763: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
3764: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 3763: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

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

Line 3764: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

3760: hr_utility.raise_error;
3761: --
3762: WHEN utl_file.invalid_operation then
3763: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
3764: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3765: hr_utility.raise_error;
3766: --
3767: WHEN utl_file.read_error then
3768: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

Line 3765: hr_utility.raise_error;

3761: --
3762: WHEN utl_file.invalid_operation then
3763: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
3764: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3765: hr_utility.raise_error;
3766: --
3767: WHEN utl_file.read_error then
3768: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
3769: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 3768: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

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

Line 3769: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

3765: hr_utility.raise_error;
3766: --
3767: WHEN utl_file.read_error then
3768: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
3769: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3770: hr_utility.raise_error;
3771: --
3772: WHEN others THEN
3773: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

Line 3770: hr_utility.raise_error;

3766: --
3767: WHEN utl_file.read_error then
3768: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
3769: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3770: hr_utility.raise_error;
3771: --
3772: WHEN others THEN
3773: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
3774: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

Line 3773: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

3769: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3770: hr_utility.raise_error;
3771: --
3772: WHEN others THEN
3773: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
3774: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
3775: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3776: hr_utility.raise_error;
3777: END FORM7;

Line 3774: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

3770: hr_utility.raise_error;
3771: --
3772: WHEN others THEN
3773: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
3774: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
3775: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3776: hr_utility.raise_error;
3777: END FORM7;
3778: -------------------------------------------------------------------------------------------

Line 3775: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

3771: --
3772: WHEN others THEN
3773: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
3774: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
3775: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3776: hr_utility.raise_error;
3777: END FORM7;
3778: -------------------------------------------------------------------------------------------
3779: PROCEDURE MCP

Line 3776: hr_utility.raise_error;

3772: WHEN others THEN
3773: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
3774: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
3775: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3776: hr_utility.raise_error;
3777: END FORM7;
3778: -------------------------------------------------------------------------------------------
3779: PROCEDURE MCP
3780: (p_request_id NUMBER

Line 3985: hr_utility.set_location('Entering FORM6 ',10);

3981: l_input_date := '01-'||p_effective_month||'-'||p_effective_year;
3982: l_effective_date := last_day(to_date(l_input_date,'DD-MM-YYYY'));
3983: INSERT INTO fnd_sessions (session_id, effective_date)
3984: VALUES (userenv('sessionid'), l_effective_date);
3985: hr_utility.set_location('Entering FORM6 ',10);
3986:
3987: /* Fetch Local Nationality */
3988: OPEN csr_get_loc_nat;
3989: FETCH csr_get_loc_nat into l_nat_cd;

Line 4515: hr_utility.set_location('Finished creating xml data for Procedure FORM6 ',20);

4511: END LOOP;
4512: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
4513: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
4514: clob_to_blob(l_xfdf_string,l_xfdf_blob);
4515: hr_utility.set_location('Finished creating xml data for Procedure FORM6 ',20);
4516: /*EXCEPTION
4517: WHEN utl_file.invalid_path then
4518: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
4519: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

4514: clob_to_blob(l_xfdf_string,l_xfdf_blob);
4515: hr_utility.set_location('Finished creating xml data for Procedure FORM6 ',20);
4516: /*EXCEPTION
4517: WHEN utl_file.invalid_path then
4518: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
4519: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
4520: hr_utility.raise_error;
4521: --
4522: WHEN utl_file.invalid_mode then

Line 4519: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

4515: hr_utility.set_location('Finished creating xml data for Procedure FORM6 ',20);
4516: /*EXCEPTION
4517: WHEN utl_file.invalid_path then
4518: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
4519: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
4520: hr_utility.raise_error;
4521: --
4522: WHEN utl_file.invalid_mode then
4523: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

Line 4520: hr_utility.raise_error;

4516: /*EXCEPTION
4517: WHEN utl_file.invalid_path then
4518: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
4519: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
4520: hr_utility.raise_error;
4521: --
4522: WHEN utl_file.invalid_mode then
4523: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
4524: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 4523: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

4519: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
4520: hr_utility.raise_error;
4521: --
4522: WHEN utl_file.invalid_mode then
4523: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
4524: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
4525: hr_utility.raise_error;
4526: --
4527: WHEN utl_file.invalid_filehandle then

Line 4524: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

4520: hr_utility.raise_error;
4521: --
4522: WHEN utl_file.invalid_mode then
4523: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
4524: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
4525: hr_utility.raise_error;
4526: --
4527: WHEN utl_file.invalid_filehandle then
4528: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

Line 4525: hr_utility.raise_error;

4521: --
4522: WHEN utl_file.invalid_mode then
4523: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
4524: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
4525: hr_utility.raise_error;
4526: --
4527: WHEN utl_file.invalid_filehandle then
4528: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
4529: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 4528: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

4524: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
4525: hr_utility.raise_error;
4526: --
4527: WHEN utl_file.invalid_filehandle then
4528: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
4529: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
4530: hr_utility.raise_error;
4531: --
4532: WHEN utl_file.invalid_operation then

Line 4529: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

4525: hr_utility.raise_error;
4526: --
4527: WHEN utl_file.invalid_filehandle then
4528: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
4529: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
4530: hr_utility.raise_error;
4531: --
4532: WHEN utl_file.invalid_operation then
4533: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

Line 4530: hr_utility.raise_error;

4526: --
4527: WHEN utl_file.invalid_filehandle then
4528: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
4529: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
4530: hr_utility.raise_error;
4531: --
4532: WHEN utl_file.invalid_operation then
4533: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
4534: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 4533: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

4529: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
4530: hr_utility.raise_error;
4531: --
4532: WHEN utl_file.invalid_operation then
4533: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
4534: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
4535: hr_utility.raise_error;
4536: --
4537: WHEN utl_file.read_error then

Line 4534: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

4530: hr_utility.raise_error;
4531: --
4532: WHEN utl_file.invalid_operation then
4533: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
4534: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
4535: hr_utility.raise_error;
4536: --
4537: WHEN utl_file.read_error then
4538: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

Line 4535: hr_utility.raise_error;

4531: --
4532: WHEN utl_file.invalid_operation then
4533: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
4534: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
4535: hr_utility.raise_error;
4536: --
4537: WHEN utl_file.read_error then
4538: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
4539: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 4538: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

4534: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
4535: hr_utility.raise_error;
4536: --
4537: WHEN utl_file.read_error then
4538: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
4539: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
4540: hr_utility.raise_error;
4541: --
4542: WHEN others THEN

Line 4539: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

4535: hr_utility.raise_error;
4536: --
4537: WHEN utl_file.read_error then
4538: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
4539: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
4540: hr_utility.raise_error;
4541: --
4542: WHEN others THEN
4543: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

Line 4540: hr_utility.raise_error;

4536: --
4537: WHEN utl_file.read_error then
4538: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
4539: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
4540: hr_utility.raise_error;
4541: --
4542: WHEN others THEN
4543: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
4544: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

Line 4543: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

4539: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
4540: hr_utility.raise_error;
4541: --
4542: WHEN others THEN
4543: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
4544: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
4545: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
4546: hr_utility.raise_error;*/
4547: END MCP;

Line 4544: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

4540: hr_utility.raise_error;
4541: --
4542: WHEN others THEN
4543: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
4544: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
4545: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
4546: hr_utility.raise_error;*/
4547: END MCP;
4548: -------------------------------------------------------------------------------------------

Line 4545: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

4541: --
4542: WHEN others THEN
4543: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
4544: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
4545: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
4546: hr_utility.raise_error;*/
4547: END MCP;
4548: -------------------------------------------------------------------------------------------
4549: PROCEDURE MCF

Line 4546: hr_utility.raise_error;*/

4542: WHEN others THEN
4543: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
4544: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
4545: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
4546: hr_utility.raise_error;*/
4547: END MCP;
4548: -------------------------------------------------------------------------------------------
4549: PROCEDURE MCF
4550: (p_request_id NUMBER

Line 4766: hr_utility.set_location('Entering Monthly Contribution Federal',10);

4762: l_input_date := '01-'||p_effective_month||'-'||p_effective_year;
4763: l_effective_date := last_day(to_date(l_input_date,'DD-MM-YYYY'));
4764: INSERT INTO fnd_sessions (session_id, effective_date)
4765: VALUES (userenv('sessionid'), l_effective_date);
4766: hr_utility.set_location('Entering Monthly Contribution Federal',10);
4767:
4768: /* Fetch Local Nationality */
4769: OPEN csr_get_loc_nat;
4770: FETCH csr_get_loc_nat into l_nat_cd;

Line 5214: hr_utility.set_location('Finished creating xml data for Procedure Monthly Contribution Federal ',20);

5210: END LOOP;
5211: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
5212: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
5213: clob_to_blob(l_xfdf_string,l_xfdf_blob);
5214: hr_utility.set_location('Finished creating xml data for Procedure Monthly Contribution Federal ',20);
5215: EXCEPTION
5216: WHEN utl_file.invalid_path then
5217: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
5218: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

5213: clob_to_blob(l_xfdf_string,l_xfdf_blob);
5214: hr_utility.set_location('Finished creating xml data for Procedure Monthly Contribution Federal ',20);
5215: EXCEPTION
5216: WHEN utl_file.invalid_path then
5217: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
5218: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
5219: hr_utility.raise_error;
5220: --
5221: WHEN utl_file.invalid_mode then

Line 5218: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

5214: hr_utility.set_location('Finished creating xml data for Procedure Monthly Contribution Federal ',20);
5215: EXCEPTION
5216: WHEN utl_file.invalid_path then
5217: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
5218: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
5219: hr_utility.raise_error;
5220: --
5221: WHEN utl_file.invalid_mode then
5222: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

Line 5219: hr_utility.raise_error;

5215: EXCEPTION
5216: WHEN utl_file.invalid_path then
5217: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
5218: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
5219: hr_utility.raise_error;
5220: --
5221: WHEN utl_file.invalid_mode then
5222: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
5223: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 5222: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

5218: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
5219: hr_utility.raise_error;
5220: --
5221: WHEN utl_file.invalid_mode then
5222: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
5223: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
5224: hr_utility.raise_error;
5225: --
5226: WHEN utl_file.invalid_filehandle then

Line 5223: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

5219: hr_utility.raise_error;
5220: --
5221: WHEN utl_file.invalid_mode then
5222: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
5223: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
5224: hr_utility.raise_error;
5225: --
5226: WHEN utl_file.invalid_filehandle then
5227: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

Line 5224: hr_utility.raise_error;

5220: --
5221: WHEN utl_file.invalid_mode then
5222: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
5223: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
5224: hr_utility.raise_error;
5225: --
5226: WHEN utl_file.invalid_filehandle then
5227: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
5228: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 5227: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

5223: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
5224: hr_utility.raise_error;
5225: --
5226: WHEN utl_file.invalid_filehandle then
5227: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
5228: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
5229: hr_utility.raise_error;
5230: --
5231: WHEN utl_file.invalid_operation then

Line 5228: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

5224: hr_utility.raise_error;
5225: --
5226: WHEN utl_file.invalid_filehandle then
5227: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
5228: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
5229: hr_utility.raise_error;
5230: --
5231: WHEN utl_file.invalid_operation then
5232: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

Line 5229: hr_utility.raise_error;

5225: --
5226: WHEN utl_file.invalid_filehandle then
5227: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
5228: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
5229: hr_utility.raise_error;
5230: --
5231: WHEN utl_file.invalid_operation then
5232: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
5233: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 5232: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

5228: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
5229: hr_utility.raise_error;
5230: --
5231: WHEN utl_file.invalid_operation then
5232: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
5233: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
5234: hr_utility.raise_error;
5235: --
5236: WHEN utl_file.read_error then

Line 5233: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

5229: hr_utility.raise_error;
5230: --
5231: WHEN utl_file.invalid_operation then
5232: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
5233: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
5234: hr_utility.raise_error;
5235: --
5236: WHEN utl_file.read_error then
5237: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

Line 5234: hr_utility.raise_error;

5230: --
5231: WHEN utl_file.invalid_operation then
5232: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
5233: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
5234: hr_utility.raise_error;
5235: --
5236: WHEN utl_file.read_error then
5237: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
5238: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 5237: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

5233: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
5234: hr_utility.raise_error;
5235: --
5236: WHEN utl_file.read_error then
5237: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
5238: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
5239: hr_utility.raise_error;
5240: --
5241: WHEN others THEN

Line 5238: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

5234: hr_utility.raise_error;
5235: --
5236: WHEN utl_file.read_error then
5237: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
5238: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
5239: hr_utility.raise_error;
5240: --
5241: WHEN others THEN
5242: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

Line 5239: hr_utility.raise_error;

5235: --
5236: WHEN utl_file.read_error then
5237: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
5238: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
5239: hr_utility.raise_error;
5240: --
5241: WHEN others THEN
5242: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
5243: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

Line 5242: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

5238: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
5239: hr_utility.raise_error;
5240: --
5241: WHEN others THEN
5242: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
5243: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
5244: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
5245: hr_utility.raise_error;
5246: END MCF;

Line 5243: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

5239: hr_utility.raise_error;
5240: --
5241: WHEN others THEN
5242: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
5243: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
5244: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
5245: hr_utility.raise_error;
5246: END MCF;
5247: ---------------------------------------------------------------------------------------------------------

Line 5244: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

5240: --
5241: WHEN others THEN
5242: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
5243: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
5244: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
5245: hr_utility.raise_error;
5246: END MCF;
5247: ---------------------------------------------------------------------------------------------------------
5248: PROCEDURE WritetoCLOB

Line 5245: hr_utility.raise_error;

5241: WHEN others THEN
5242: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
5243: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
5244: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
5245: hr_utility.raise_error;
5246: END MCF;
5247: ---------------------------------------------------------------------------------------------------------
5248: PROCEDURE WritetoCLOB
5249: (p_xfdf_blob out nocopy blob)

Line 5262: hr_utility.set_location('Entered Procedure Write to clob ',100);

5258: l_str7 varchar2(1000);
5259: l_str8 varchar2(240);
5260: l_str9 varchar2(240);
5261: BEGIN
5262: hr_utility.set_location('Entered Procedure Write to clob ',100);
5263: l_str1 := '
5264:
5265: ' ;
5266: l_str2 := '