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

Line 181: hr_utility.set_location('Entering report166 ',10);

177:
178: -- To clear the PL/SQL Table values.
179: vXMLTable.DELETE;
180: vCtr := 1;
181: hr_utility.set_location('Entering report166 ',10);
182:
183: l_effective_month := hr_general.decode_lookup('KW_GREGORIAN_MONTH', p_effective_month);
184:
185: vXMLTable(vCtr).TagName := 'R166-MONTH';

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

660: vXMLTable(vCtr).TagValue := substr(l_fm_total_amount,length(l_fm_total_amount)-2);
661: vctr := vctr + 1;
662:
663:
664: hr_utility.set_location('Finished creating xml data for Procedure report166 ',20);
665:
666: WritetoCLOB ( l_xfdf_blob );
667:
668: EXCEPTION

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

666: WritetoCLOB ( l_xfdf_blob );
667:
668: EXCEPTION
669: WHEN utl_file.invalid_path then
670: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
671: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
672: hr_utility.raise_error;
673: --
674: WHEN utl_file.invalid_mode then

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

667:
668: EXCEPTION
669: WHEN utl_file.invalid_path then
670: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
671: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
672: hr_utility.raise_error;
673: --
674: WHEN utl_file.invalid_mode then
675: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

Line 672: hr_utility.raise_error;

668: EXCEPTION
669: WHEN utl_file.invalid_path then
670: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
671: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
672: hr_utility.raise_error;
673: --
674: WHEN utl_file.invalid_mode then
675: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
676: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

671: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
672: hr_utility.raise_error;
673: --
674: WHEN utl_file.invalid_mode then
675: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
676: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
677: hr_utility.raise_error;
678: --
679: WHEN utl_file.invalid_filehandle then

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

672: hr_utility.raise_error;
673: --
674: WHEN utl_file.invalid_mode then
675: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
676: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
677: hr_utility.raise_error;
678: --
679: WHEN utl_file.invalid_filehandle then
680: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

Line 677: hr_utility.raise_error;

673: --
674: WHEN utl_file.invalid_mode then
675: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
676: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
677: hr_utility.raise_error;
678: --
679: WHEN utl_file.invalid_filehandle then
680: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
681: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

676: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
677: hr_utility.raise_error;
678: --
679: WHEN utl_file.invalid_filehandle then
680: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
681: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
682: hr_utility.raise_error;
683: --
684: WHEN utl_file.invalid_operation then

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

677: hr_utility.raise_error;
678: --
679: WHEN utl_file.invalid_filehandle then
680: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
681: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
682: hr_utility.raise_error;
683: --
684: WHEN utl_file.invalid_operation then
685: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

Line 682: hr_utility.raise_error;

678: --
679: WHEN utl_file.invalid_filehandle then
680: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
681: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
682: hr_utility.raise_error;
683: --
684: WHEN utl_file.invalid_operation then
685: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
686: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

681: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
682: hr_utility.raise_error;
683: --
684: WHEN utl_file.invalid_operation then
685: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
686: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
687: hr_utility.raise_error;
688: --
689: WHEN utl_file.read_error then

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

682: hr_utility.raise_error;
683: --
684: WHEN utl_file.invalid_operation then
685: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
686: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
687: hr_utility.raise_error;
688: --
689: WHEN utl_file.read_error then
690: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

Line 687: hr_utility.raise_error;

683: --
684: WHEN utl_file.invalid_operation then
685: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
686: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
687: hr_utility.raise_error;
688: --
689: WHEN utl_file.read_error then
690: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
691: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

686: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
687: hr_utility.raise_error;
688: --
689: WHEN utl_file.read_error then
690: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
691: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
692: hr_utility.raise_error;
693: --
694: WHEN others THEN

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

687: hr_utility.raise_error;
688: --
689: WHEN utl_file.read_error then
690: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
691: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
692: hr_utility.raise_error;
693: --
694: WHEN others THEN
695: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

Line 692: hr_utility.raise_error;

688: --
689: WHEN utl_file.read_error then
690: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
691: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
692: hr_utility.raise_error;
693: --
694: WHEN others THEN
695: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
696: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

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

691: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
692: hr_utility.raise_error;
693: --
694: WHEN others THEN
695: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
696: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
697: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
698: hr_utility.raise_error;
699:

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

692: hr_utility.raise_error;
693: --
694: WHEN others THEN
695: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
696: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
697: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
698: hr_utility.raise_error;
699:
700: END report166;

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

693: --
694: WHEN others THEN
695: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
696: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
697: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
698: hr_utility.raise_error;
699:
700: END report166;
701: ------------------------------------------------------------------------------------

Line 698: hr_utility.raise_error;

694: WHEN others THEN
695: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
696: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
697: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
698: hr_utility.raise_error;
699:
700: END report166;
701: ------------------------------------------------------------------------------------
702:

Line 866: hr_utility.set_location('Entering report167_old ',10);

862: l_local_nationality := NULL;
863: END;
864:
865: -- To clear the PL/SQL Table values.
866: hr_utility.set_location('Entering report167_old ',10);
867:
868: /*Fetch Employer SSN*/
869: OPEN csr_employer_ssn;
870: FETCH csr_employer_ssn INTO l_employer_ssn;

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

1070:
1071: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
1072: clob_to_blob(l_xfdf_string,l_xfdf_blob);
1073:
1074: hr_utility.set_location('Finished creating xml data for Procedure report167 ',20);
1075:
1076: EXCEPTION
1077: WHEN utl_file.invalid_path then
1078: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');

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

1074: hr_utility.set_location('Finished creating xml data for Procedure report167 ',20);
1075:
1076: EXCEPTION
1077: WHEN utl_file.invalid_path then
1078: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
1079: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1080: hr_utility.raise_error;
1081: --
1082: WHEN utl_file.invalid_mode then

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

1075:
1076: EXCEPTION
1077: WHEN utl_file.invalid_path then
1078: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
1079: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1080: hr_utility.raise_error;
1081: --
1082: WHEN utl_file.invalid_mode then
1083: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

Line 1080: hr_utility.raise_error;

1076: EXCEPTION
1077: WHEN utl_file.invalid_path then
1078: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
1079: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1080: hr_utility.raise_error;
1081: --
1082: WHEN utl_file.invalid_mode then
1083: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
1084: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

1079: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1080: hr_utility.raise_error;
1081: --
1082: WHEN utl_file.invalid_mode then
1083: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
1084: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1085: hr_utility.raise_error;
1086: --
1087: WHEN utl_file.invalid_filehandle then

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

1080: hr_utility.raise_error;
1081: --
1082: WHEN utl_file.invalid_mode then
1083: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
1084: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1085: hr_utility.raise_error;
1086: --
1087: WHEN utl_file.invalid_filehandle then
1088: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

Line 1085: hr_utility.raise_error;

1081: --
1082: WHEN utl_file.invalid_mode then
1083: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
1084: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1085: hr_utility.raise_error;
1086: --
1087: WHEN utl_file.invalid_filehandle then
1088: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
1089: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

1084: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1085: hr_utility.raise_error;
1086: --
1087: WHEN utl_file.invalid_filehandle then
1088: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
1089: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1090: hr_utility.raise_error;
1091: --
1092: WHEN utl_file.invalid_operation then

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

1085: hr_utility.raise_error;
1086: --
1087: WHEN utl_file.invalid_filehandle then
1088: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
1089: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1090: hr_utility.raise_error;
1091: --
1092: WHEN utl_file.invalid_operation then
1093: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

Line 1090: hr_utility.raise_error;

1086: --
1087: WHEN utl_file.invalid_filehandle then
1088: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
1089: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1090: hr_utility.raise_error;
1091: --
1092: WHEN utl_file.invalid_operation then
1093: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
1094: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

1089: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1090: hr_utility.raise_error;
1091: --
1092: WHEN utl_file.invalid_operation then
1093: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
1094: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1095: hr_utility.raise_error;
1096: --
1097: WHEN utl_file.read_error then

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

1090: hr_utility.raise_error;
1091: --
1092: WHEN utl_file.invalid_operation then
1093: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
1094: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1095: hr_utility.raise_error;
1096: --
1097: WHEN utl_file.read_error then
1098: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

Line 1095: hr_utility.raise_error;

1091: --
1092: WHEN utl_file.invalid_operation then
1093: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
1094: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1095: hr_utility.raise_error;
1096: --
1097: WHEN utl_file.read_error then
1098: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
1099: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

1094: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1095: hr_utility.raise_error;
1096: --
1097: WHEN utl_file.read_error then
1098: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
1099: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1100: hr_utility.raise_error;
1101: --
1102: WHEN others THEN

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

1095: hr_utility.raise_error;
1096: --
1097: WHEN utl_file.read_error then
1098: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
1099: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1100: hr_utility.raise_error;
1101: --
1102: WHEN others THEN
1103: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

Line 1100: hr_utility.raise_error;

1096: --
1097: WHEN utl_file.read_error then
1098: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
1099: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1100: hr_utility.raise_error;
1101: --
1102: WHEN others THEN
1103: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1104: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

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

1099: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1100: hr_utility.raise_error;
1101: --
1102: WHEN others THEN
1103: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1104: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
1105: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1106: hr_utility.raise_error;
1107:

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

1100: hr_utility.raise_error;
1101: --
1102: WHEN others THEN
1103: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1104: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
1105: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1106: hr_utility.raise_error;
1107:
1108: END report167;

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

1101: --
1102: WHEN others THEN
1103: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1104: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
1105: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1106: hr_utility.raise_error;
1107:
1108: END report167;
1109:

Line 1106: hr_utility.raise_error;

1102: WHEN others THEN
1103: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1104: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
1105: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1106: hr_utility.raise_error;
1107:
1108: END report167;
1109:
1110: -------------------------------------------------------------------------------------------

Line 1371: hr_utility.set_location('Entering report167 ',10);

1367: l_local_nationality := NULL;
1368: END;
1369:
1370: -- To clear the PL/SQL Table values.
1371: hr_utility.set_location('Entering report167 ',10);
1372:
1373: /*Fetch Employer SSN*/
1374: OPEN csr_employer_ssn;
1375: FETCH csr_employer_ssn INTO l_employer_ssn;

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

1684:
1685: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
1686: clob_to_blob(l_xfdf_string,l_xfdf_blob);
1687:
1688: hr_utility.set_location('Finished creating xml data for Procedure report167 ',20);
1689:
1690: EXCEPTION
1691: WHEN utl_file.invalid_path then
1692: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');

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

1688: hr_utility.set_location('Finished creating xml data for Procedure report167 ',20);
1689:
1690: EXCEPTION
1691: WHEN utl_file.invalid_path then
1692: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
1693: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1694: hr_utility.raise_error;
1695: --
1696: WHEN utl_file.invalid_mode then

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

1689:
1690: EXCEPTION
1691: WHEN utl_file.invalid_path then
1692: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
1693: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1694: hr_utility.raise_error;
1695: --
1696: WHEN utl_file.invalid_mode then
1697: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

Line 1694: hr_utility.raise_error;

1690: EXCEPTION
1691: WHEN utl_file.invalid_path then
1692: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
1693: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1694: hr_utility.raise_error;
1695: --
1696: WHEN utl_file.invalid_mode then
1697: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
1698: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

1693: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1694: hr_utility.raise_error;
1695: --
1696: WHEN utl_file.invalid_mode then
1697: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
1698: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1699: hr_utility.raise_error;
1700: --
1701: WHEN utl_file.invalid_filehandle then

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

1694: hr_utility.raise_error;
1695: --
1696: WHEN utl_file.invalid_mode then
1697: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
1698: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1699: hr_utility.raise_error;
1700: --
1701: WHEN utl_file.invalid_filehandle then
1702: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

Line 1699: hr_utility.raise_error;

1695: --
1696: WHEN utl_file.invalid_mode then
1697: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
1698: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1699: hr_utility.raise_error;
1700: --
1701: WHEN utl_file.invalid_filehandle then
1702: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
1703: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

1698: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1699: hr_utility.raise_error;
1700: --
1701: WHEN utl_file.invalid_filehandle then
1702: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
1703: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1704: hr_utility.raise_error;
1705: --
1706: WHEN utl_file.invalid_operation then

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

1699: hr_utility.raise_error;
1700: --
1701: WHEN utl_file.invalid_filehandle then
1702: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
1703: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1704: hr_utility.raise_error;
1705: --
1706: WHEN utl_file.invalid_operation then
1707: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

Line 1704: hr_utility.raise_error;

1700: --
1701: WHEN utl_file.invalid_filehandle then
1702: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
1703: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1704: hr_utility.raise_error;
1705: --
1706: WHEN utl_file.invalid_operation then
1707: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
1708: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

1703: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1704: hr_utility.raise_error;
1705: --
1706: WHEN utl_file.invalid_operation then
1707: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
1708: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1709: hr_utility.raise_error;
1710: --
1711: WHEN utl_file.read_error then

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

1704: hr_utility.raise_error;
1705: --
1706: WHEN utl_file.invalid_operation then
1707: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
1708: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1709: hr_utility.raise_error;
1710: --
1711: WHEN utl_file.read_error then
1712: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

Line 1709: hr_utility.raise_error;

1705: --
1706: WHEN utl_file.invalid_operation then
1707: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
1708: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1709: hr_utility.raise_error;
1710: --
1711: WHEN utl_file.read_error then
1712: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
1713: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

1708: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1709: hr_utility.raise_error;
1710: --
1711: WHEN utl_file.read_error then
1712: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
1713: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1714: hr_utility.raise_error;
1715: --
1716: WHEN others THEN

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

1709: hr_utility.raise_error;
1710: --
1711: WHEN utl_file.read_error then
1712: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
1713: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1714: hr_utility.raise_error;
1715: --
1716: WHEN others THEN
1717: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

Line 1714: hr_utility.raise_error;

1710: --
1711: WHEN utl_file.read_error then
1712: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
1713: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1714: hr_utility.raise_error;
1715: --
1716: WHEN others THEN
1717: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1718: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

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

1713: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1714: hr_utility.raise_error;
1715: --
1716: WHEN others THEN
1717: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1718: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
1719: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1720: hr_utility.raise_error;
1721:

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

1714: hr_utility.raise_error;
1715: --
1716: WHEN others THEN
1717: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1718: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
1719: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1720: hr_utility.raise_error;
1721:
1722: END report167_2006;

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

1715: --
1716: WHEN others THEN
1717: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1718: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
1719: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1720: hr_utility.raise_error;
1721:
1722: END report167_2006;
1723: -------------------------------------------------------------------------------------------

Line 1720: hr_utility.raise_error;

1716: WHEN others THEN
1717: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1718: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
1719: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1720: hr_utility.raise_error;
1721:
1722: END report167_2006;
1723: -------------------------------------------------------------------------------------------
1724:

Line 2000: -- hr_utility.trace_on(null,'BPK');

1996: l_fm_l_first_social varchar2(100);
1997: l_changed_sal number;
1998:
1999: BEGIN
2000: -- hr_utility.trace_on(null,'BPK');
2001: -- hr_utility.set_location('entering 168',10);
2002:
2003: set_currency_mask(p_business_group_id);
2004: l_input_date := '01-'||p_effective_month||'-'||p_effective_year;

Line 2001: -- hr_utility.set_location('entering 168',10);

1997: l_changed_sal number;
1998:
1999: BEGIN
2000: -- hr_utility.trace_on(null,'BPK');
2001: -- hr_utility.set_location('entering 168',10);
2002:
2003: set_currency_mask(p_business_group_id);
2004: l_input_date := '01-'||p_effective_month||'-'||p_effective_year;
2005: l_effective_date := last_day(to_date(l_input_date,'DD-MM-YYYY'));

Line 2008: hr_utility.set_location('l_input_date '|| l_input_date,20);

2004: l_input_date := '01-'||p_effective_month||'-'||p_effective_year;
2005: l_effective_date := last_day(to_date(l_input_date,'DD-MM-YYYY'));
2006: /*l_eff_term_date := to_date('28-'||to_char(l_effective_date,'MM-YYYY'),'DD-MM-YYYY');*/
2007:
2008: hr_utility.set_location('l_input_date '|| l_input_date,20);
2009: hr_utility.set_location('l_effective_date'|| l_effective_date,30);
2010:
2011: INSERT INTO fnd_sessions (session_id, effective_date)
2012: VALUES (userenv('sessionid'), l_effective_date);

Line 2009: hr_utility.set_location('l_effective_date'|| l_effective_date,30);

2005: l_effective_date := last_day(to_date(l_input_date,'DD-MM-YYYY'));
2006: /*l_eff_term_date := to_date('28-'||to_char(l_effective_date,'MM-YYYY'),'DD-MM-YYYY');*/
2007:
2008: hr_utility.set_location('l_input_date '|| l_input_date,20);
2009: hr_utility.set_location('l_effective_date'|| l_effective_date,30);
2010:
2011: INSERT INTO fnd_sessions (session_id, effective_date)
2012: VALUES (userenv('sessionid'), l_effective_date);
2013:

Line 2030: hr_utility.set_location('Entering report168 ',10);

2026:
2027: -- To clear the PL/SQL Table values.
2028: vXMLTable.DELETE;
2029: vCtr := 1;
2030: hr_utility.set_location('Entering report168 ',10);
2031:
2032: l_effective_month := hr_general.decode_lookup('KW_GREGORIAN_MONTH', p_effective_month);
2033:
2034: vXMLTable(vCtr).TagName := 'R168-MONTH';

Line 2205: hr_utility.set_location('inside sep 2012 or less'|| l_effective_date,30);

2201: l_all_processed := 0;
2202: WHILE l_all_processed <> 1 LOOP
2203:
2204: if l_effective_date <= to_date('30-09-2012','DD-MM-YYYY') then
2205: hr_utility.set_location('inside sep 2012 or less'|| l_effective_date,30);
2206: --Writing data for new employees
2207: l_new_count := 0;
2208: WHILE j <= i LOOP
2209:

Line 2385: hr_utility.set_location('inside oct 2012 or more'|| l_effective_date,30);

2381:
2382: END LOOP;
2383:
2384: else
2385: hr_utility.set_location('inside oct 2012 or more'|| l_effective_date,30);
2386: l_new_count := 0;
2387: -- WHILE j <= i or l <= k LOOP /*loop for both new and terminated sicne now we report both in a single table */
2388: while j <= i loop
2389: l_subject_si_val := 0;

Line 2394: hr_utility.set_location('l_subject_si_val'|| l_subject_si_val,30);

2390: l_subject_si_val := pay_balance_pkg.get_value(l_subject_si_id,t_new_store_assact(j).assignment_action_id);
2391: l_civil_id := NULL;
2392: l_full_name := NULL;
2393:
2394: hr_utility.set_location('l_subject_si_val'|| l_subject_si_val,30);
2395:
2396: OPEN csr_get_emp_name(t_new_store_assact(j).person_id);
2397: FETCH csr_get_emp_name INTO /*l_full_name,*/ l_civil_id;
2398: CLOSE csr_get_emp_name;

Line 2400: hr_utility.set_location('l_civil_id'|| l_civil_id,30);

2396: OPEN csr_get_emp_name(t_new_store_assact(j).person_id);
2397: FETCH csr_get_emp_name INTO /*l_full_name,*/ l_civil_id;
2398: CLOSE csr_get_emp_name;
2399:
2400: hr_utility.set_location('l_civil_id'|| l_civil_id,30);
2401:
2402: l_full_name := hr_person_name.get_person_name
2403: (p_person_id => t_new_store_assact(j).person_id
2404: ,p_effective_date => l_effective_date

Line 2408: hr_utility.set_location('l_full_name'|| l_full_name,30);

2404: ,p_effective_date => l_effective_date
2405: ,p_format_name => 'FULL_NAME' --'DISPLAY_NAME'
2406: ,p_user_format_choice => l_user_format);
2407:
2408: hr_utility.set_location('l_full_name'|| l_full_name,30);
2409:
2410: l_new_count := l_new_count+1;
2411:
2412: l_fm_subject_si_val := to_char(l_subject_si_val,lg_format_mask);

Line 2414: hr_utility.set_location('l_fm_subject_si_val'|| l_fm_subject_si_val,30);

2410: l_new_count := l_new_count+1;
2411:
2412: l_fm_subject_si_val := to_char(l_subject_si_val,lg_format_mask);
2413:
2414: hr_utility.set_location('l_fm_subject_si_val'|| l_fm_subject_si_val,30);
2415:
2416: -- vXMLTable(vCtr).TagName := 'R168-N-SEQ-'||l_new_count;
2417: -- vXMLTable(vCtr).TagValue := j;
2418: -- vctr := vctr + 1;

Line 2438: hr_utility.set_location('j'|| j,30);

2434: -- vXMLTable(vCtr).TagValue := substr(l_fm_subject_si_val,length(l_fm_subject_si_val)-2);
2435: -- vctr := vctr + 1;
2436:
2437: j := j + 1;
2438: hr_utility.set_location('j'|| j,30);
2439:
2440: IF j > i THEN
2441: l_new_processed := 1;
2442: hr_utility.set_location('l_new_processed'|| l_new_processed,30);

Line 2442: hr_utility.set_location('l_new_processed'|| l_new_processed,30);

2438: hr_utility.set_location('j'|| j,30);
2439:
2440: IF j > i THEN
2441: l_new_processed := 1;
2442: hr_utility.set_location('l_new_processed'|| l_new_processed,30);
2443: END IF;
2444:
2445: IF l_new_count = 4 THEN /* changed from 8 to 4 for the new template */
2446: EXIT;

Line 2466: hr_utility.set_location('l_civil_id'|| l_civil_id,30);

2462: OPEN csr_get_emp_name(t_ter_store_assact(l).person_id);
2463: FETCH csr_get_emp_name INTO /*l_full_name,*/ l_civil_id;
2464: CLOSE csr_get_emp_name;
2465:
2466: hr_utility.set_location('l_civil_id'|| l_civil_id,30);
2467: l_full_name := hr_person_name.get_person_name
2468: (p_person_id => t_ter_store_assact(l).person_id
2469: ,p_effective_date => l_effective_date
2470: ,p_format_name => 'FULL_NAME' --'DISPLAY_NAME'

Line 2473: hr_utility.set_location('l_full_name'|| l_full_name,30);

2469: ,p_effective_date => l_effective_date
2470: ,p_format_name => 'FULL_NAME' --'DISPLAY_NAME'
2471: ,p_user_format_choice => l_user_format);
2472:
2473: hr_utility.set_location('l_full_name'|| l_full_name,30);
2474:
2475: l_new_count := l_new_count+1;
2476:
2477: l_fm_subject_si_val := to_char(l_subject_si_val,lg_format_mask);

Line 2480: hr_utility.set_location('l_subject_si_val'|| l_subject_si_val,30);

2476:
2477: l_fm_subject_si_val := to_char(l_subject_si_val,lg_format_mask);
2478:
2479:
2480: hr_utility.set_location('l_subject_si_val'|| l_subject_si_val,30);
2481:
2482: hr_utility.set_location('l_fm_subject_si_val'|| l_fm_subject_si_val,30);
2483:
2484: /* vXMLTable(vCtr).TagName := 'R168-T-SEQ-'||l_new_count;

Line 2482: hr_utility.set_location('l_fm_subject_si_val'|| l_fm_subject_si_val,30);

2478:
2479:
2480: hr_utility.set_location('l_subject_si_val'|| l_subject_si_val,30);
2481:
2482: hr_utility.set_location('l_fm_subject_si_val'|| l_fm_subject_si_val,30);
2483:
2484: /* vXMLTable(vCtr).TagName := 'R168-T-SEQ-'||l_new_count;
2485: vXMLTable(vCtr).TagValue := l;
2486: vctr := vctr + 1;

Line 2521: hr_utility.set_location('l_salary_effective_date'|| l_salary_effective_date,30);

2517: END LOOP;
2518: CLOSE csr_get_salary_date;
2519:
2520:
2521: hr_utility.set_location('l_salary_effective_date'|| l_salary_effective_date,30);
2522:
2523: vXMLTable(vCtr).TagName := 'R168-TEE-SAL-DATE-'||l_new_count;
2524: vXMLTable(vCtr).TagValue := TRUNC(l_salary_effective_date);
2525: vctr := vctr + 1;

Line 2543: hr_utility.set_location('BPK Writing data for employees with changed salary',30);

2539:
2540: --Writing data for employees with changed salary
2541: l_new_count := 0;
2542: WHILE n <= m LOOP
2543: hr_utility.set_location('BPK Writing data for employees with changed salary',30);
2544: l_subject_si_val := 0;
2545: l_subject_si_val := pay_balance_pkg.get_value(l_subject_si_id,t_cha_store_assact(n).assignment_action_id);
2546: l_civil_id := NULL;
2547: l_full_name := NULL;

Line 2550: hr_utility.set_location('l_subject_si_val'|| l_subject_si_val,30);

2546: l_civil_id := NULL;
2547: l_full_name := NULL;
2548: l_assact_one := null;
2549:
2550: hr_utility.set_location('l_subject_si_val'|| l_subject_si_val,30);
2551:
2552: OPEN csr_get_emp_name(t_cha_store_assact(n).person_id);
2553: FETCH csr_get_emp_name INTO /*l_full_name,*/ l_civil_id;
2554: CLOSE csr_get_emp_name;

Line 2560: hr_utility.set_location('l_full_name'|| l_full_name,30);

2556: (p_person_id => t_cha_store_assact(n).person_id
2557: ,p_effective_date => l_effective_date
2558: ,p_format_name => 'FULL_NAME' --'DISPLAY_NAME'
2559: ,p_user_format_choice => l_user_format);
2560: hr_utility.set_location('l_full_name'|| l_full_name,30);
2561:
2562: /* Get the assact id corresponding to the first_assact_date calculated above Oct 2012 for report 168*/
2563: OPEN csr_get_assact_one (t_cha_store_assact(n).assignment_id,t_cha_store_assact(n).date_earned);
2564: FETCH csr_get_assact_one into l_assact_one;

Line 2566: hr_utility.set_location('l_social_id'|| l_social_id ,30);

2562: /* Get the assact id corresponding to the first_assact_date calculated above Oct 2012 for report 168*/
2563: OPEN csr_get_assact_one (t_cha_store_assact(n).assignment_id,t_cha_store_assact(n).date_earned);
2564: FETCH csr_get_assact_one into l_assact_one;
2565: CLOSE csr_get_assact_one;
2566: hr_utility.set_location('l_social_id'|| l_social_id ,30);
2567: hr_utility.set_location('l_assact_one'|| l_assact_one ,30);
2568: If l_social_id is not null THEN
2569: If l_assact_one is not null then
2570: l_first_social := pay_balance_pkg.get_value(l_social_id,l_assact_one);

Line 2567: hr_utility.set_location('l_assact_one'|| l_assact_one ,30);

2563: OPEN csr_get_assact_one (t_cha_store_assact(n).assignment_id,t_cha_store_assact(n).date_earned);
2564: FETCH csr_get_assact_one into l_assact_one;
2565: CLOSE csr_get_assact_one;
2566: hr_utility.set_location('l_social_id'|| l_social_id ,30);
2567: hr_utility.set_location('l_assact_one'|| l_assact_one ,30);
2568: If l_social_id is not null THEN
2569: If l_assact_one is not null then
2570: l_first_social := pay_balance_pkg.get_value(l_social_id,l_assact_one);
2571: Else

Line 2577: hr_utility.set_location('l_first_social'|| l_first_social ,30);

2573: End If;
2574: Else
2575: l_first_social := 0;
2576: End If;
2577: hr_utility.set_location('l_first_social'|| l_first_social ,30);
2578: l_new_count := l_new_count+1;
2579: hr_utility.set_location('t_cha_store_assact(n).changed_salary'|| t_cha_store_assact(n).changed_salary ,30);
2580: l_changed_sal := t_cha_store_assact(n).changed_salary - l_first_social; /* salary = salary - Social Allowance */
2581:

Line 2579: hr_utility.set_location('t_cha_store_assact(n).changed_salary'|| t_cha_store_assact(n).changed_salary ,30);

2575: l_first_social := 0;
2576: End If;
2577: hr_utility.set_location('l_first_social'|| l_first_social ,30);
2578: l_new_count := l_new_count+1;
2579: hr_utility.set_location('t_cha_store_assact(n).changed_salary'|| t_cha_store_assact(n).changed_salary ,30);
2580: l_changed_sal := t_cha_store_assact(n).changed_salary - l_first_social; /* salary = salary - Social Allowance */
2581:
2582: -- l_changed_sal := l_subject_si_val - l_first_social;
2583:

Line 2584: hr_utility.set_location('l_changed_sal'|| l_changed_sal ,30);

2580: l_changed_sal := t_cha_store_assact(n).changed_salary - l_first_social; /* salary = salary - Social Allowance */
2581:
2582: -- l_changed_sal := l_subject_si_val - l_first_social;
2583:
2584: hr_utility.set_location('l_changed_sal'|| l_changed_sal ,30);
2585:
2586: l_fm_l_first_social := to_char(l_first_social,lg_format_mask); -- added for Oct 2012 report 168 change
2587:
2588: -- l_fm_changed_salary := to_char(t_cha_store_assact(n).changed_salary,lg_format_mask);

Line 2591: hr_utility.set_location('l_fm_l_first_social'|| l_fm_l_first_social ,30);

2587:
2588: -- l_fm_changed_salary := to_char(t_cha_store_assact(n).changed_salary,lg_format_mask);
2589: l_fm_changed_salary := to_char(l_changed_sal,lg_format_mask);
2590:
2591: hr_utility.set_location('l_fm_l_first_social'|| l_fm_l_first_social ,30);
2592:
2593: hr_utility.set_location('l_fm_changed_salary'|| l_fm_changed_salary ,30);
2594:
2595: /* vXMLTable(vCtr).TagName := 'R168-C-SEQ-'||l_new_count;

Line 2593: hr_utility.set_location('l_fm_changed_salary'|| l_fm_changed_salary ,30);

2589: l_fm_changed_salary := to_char(l_changed_sal,lg_format_mask);
2590:
2591: hr_utility.set_location('l_fm_l_first_social'|| l_fm_l_first_social ,30);
2592:
2593: hr_utility.set_location('l_fm_changed_salary'|| l_fm_changed_salary ,30);
2594:
2595: /* vXMLTable(vCtr).TagName := 'R168-C-SEQ-'||l_new_count;
2596: vXMLTable(vCtr).TagValue := n;
2597: vctr := vctr + 1;

Line 2639: hr_utility.set_location('out to page-break',30);

2635: END LOOP;
2636:
2637: end if;
2638:
2639: hr_utility.set_location('out to page-break',30);
2640:
2641: vXMLTable(vCtr).TagName := 'PAGE-BK';
2642: vXMLTable(vCtr).TagValue := ' ';
2643: vctr := vctr + 1;

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

2647: END IF;
2648:
2649: END LOOP;
2650:
2651: hr_utility.set_location('Finished creating xml data for Procedure report168 ',20);
2652:
2653: WritetoCLOB ( l_xfdf_blob );
2654:
2655: EXCEPTION

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

2653: WritetoCLOB ( l_xfdf_blob );
2654:
2655: EXCEPTION
2656: WHEN utl_file.invalid_path then
2657: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
2658: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2659: hr_utility.raise_error;
2660: --
2661: WHEN utl_file.invalid_mode then

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

2654:
2655: EXCEPTION
2656: WHEN utl_file.invalid_path then
2657: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
2658: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2659: hr_utility.raise_error;
2660: --
2661: WHEN utl_file.invalid_mode then
2662: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

Line 2659: hr_utility.raise_error;

2655: EXCEPTION
2656: WHEN utl_file.invalid_path then
2657: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
2658: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2659: hr_utility.raise_error;
2660: --
2661: WHEN utl_file.invalid_mode then
2662: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
2663: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

2658: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2659: hr_utility.raise_error;
2660: --
2661: WHEN utl_file.invalid_mode then
2662: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
2663: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2664: hr_utility.raise_error;
2665: --
2666: WHEN utl_file.invalid_filehandle then

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

2659: hr_utility.raise_error;
2660: --
2661: WHEN utl_file.invalid_mode then
2662: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
2663: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2664: hr_utility.raise_error;
2665: --
2666: WHEN utl_file.invalid_filehandle then
2667: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

Line 2664: hr_utility.raise_error;

2660: --
2661: WHEN utl_file.invalid_mode then
2662: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
2663: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2664: hr_utility.raise_error;
2665: --
2666: WHEN utl_file.invalid_filehandle then
2667: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
2668: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

2663: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2664: hr_utility.raise_error;
2665: --
2666: WHEN utl_file.invalid_filehandle then
2667: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
2668: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2669: hr_utility.raise_error;
2670: --
2671: WHEN utl_file.invalid_operation then

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

2664: hr_utility.raise_error;
2665: --
2666: WHEN utl_file.invalid_filehandle then
2667: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
2668: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2669: hr_utility.raise_error;
2670: --
2671: WHEN utl_file.invalid_operation then
2672: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

Line 2669: hr_utility.raise_error;

2665: --
2666: WHEN utl_file.invalid_filehandle then
2667: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
2668: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2669: hr_utility.raise_error;
2670: --
2671: WHEN utl_file.invalid_operation then
2672: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
2673: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

2668: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2669: hr_utility.raise_error;
2670: --
2671: WHEN utl_file.invalid_operation then
2672: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
2673: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2674: hr_utility.raise_error;
2675: --
2676: WHEN utl_file.read_error then

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

2669: hr_utility.raise_error;
2670: --
2671: WHEN utl_file.invalid_operation then
2672: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
2673: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2674: hr_utility.raise_error;
2675: --
2676: WHEN utl_file.read_error then
2677: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

Line 2674: hr_utility.raise_error;

2670: --
2671: WHEN utl_file.invalid_operation then
2672: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
2673: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2674: hr_utility.raise_error;
2675: --
2676: WHEN utl_file.read_error then
2677: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
2678: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

2673: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2674: hr_utility.raise_error;
2675: --
2676: WHEN utl_file.read_error then
2677: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
2678: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2679: hr_utility.raise_error;
2680: --
2681: WHEN others THEN

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

2674: hr_utility.raise_error;
2675: --
2676: WHEN utl_file.read_error then
2677: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
2678: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2679: hr_utility.raise_error;
2680: --
2681: WHEN others THEN
2682: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

Line 2679: hr_utility.raise_error;

2675: --
2676: WHEN utl_file.read_error then
2677: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
2678: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2679: hr_utility.raise_error;
2680: --
2681: WHEN others THEN
2682: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2683: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

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

2678: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2679: hr_utility.raise_error;
2680: --
2681: WHEN others THEN
2682: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2683: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
2684: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2685: hr_utility.raise_error;
2686:

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

2679: hr_utility.raise_error;
2680: --
2681: WHEN others THEN
2682: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2683: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
2684: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2685: hr_utility.raise_error;
2686:
2687: END report168;

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

2680: --
2681: WHEN others THEN
2682: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2683: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
2684: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2685: hr_utility.raise_error;
2686:
2687: END report168;
2688:

Line 2685: hr_utility.raise_error;

2681: WHEN others THEN
2682: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2683: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
2684: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2685: hr_utility.raise_error;
2686:
2687: END report168;
2688:
2689: -------------------------------------------------------------------------------------------

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

2705: l_str7 varchar2(1000);
2706: l_str8 varchar2(240);
2707: l_str9 varchar2(240);
2708: BEGIN
2709: hr_utility.set_location('Entered Procedure Write to clob ',100);
2710: l_str1 := '
2711:
2712: ' ;
2713: l_str2 := '