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.

[Home] [Help]

APPS.PAY_KW_MONTHLY_REPORTS dependencies on HR_UTILITY

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

150:
151: -- To clear the PL/SQL Table values.
152: vXMLTable.DELETE;
153: vCtr := 1;
154: hr_utility.set_location('Entering report166 ',10);
155:
156: l_effective_month := hr_general.decode_lookup('KW_GREGORIAN_MONTH', p_effective_month);
157:
158: vXMLTable(vCtr).TagName := 'R166-MONTH';

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

509: vXMLTable(vCtr).TagValue := substr(l_fm_total_amount,length(l_fm_total_amount)-2);
510: vctr := vctr + 1;
511:
512:
513: hr_utility.set_location('Finished creating xml data for Procedure report166 ',20);
514:
515: WritetoCLOB ( l_xfdf_blob );
516:
517: EXCEPTION

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

515: WritetoCLOB ( l_xfdf_blob );
516:
517: EXCEPTION
518: WHEN utl_file.invalid_path then
519: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
520: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
521: hr_utility.raise_error;
522: --
523: WHEN utl_file.invalid_mode then

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

516:
517: EXCEPTION
518: WHEN utl_file.invalid_path then
519: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
520: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
521: hr_utility.raise_error;
522: --
523: WHEN utl_file.invalid_mode then
524: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

Line 521: hr_utility.raise_error;

517: EXCEPTION
518: WHEN utl_file.invalid_path then
519: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
520: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
521: hr_utility.raise_error;
522: --
523: WHEN utl_file.invalid_mode then
524: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
525: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

520: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
521: hr_utility.raise_error;
522: --
523: WHEN utl_file.invalid_mode then
524: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
525: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
526: hr_utility.raise_error;
527: --
528: WHEN utl_file.invalid_filehandle then

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

521: hr_utility.raise_error;
522: --
523: WHEN utl_file.invalid_mode then
524: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
525: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
526: hr_utility.raise_error;
527: --
528: WHEN utl_file.invalid_filehandle then
529: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

Line 526: hr_utility.raise_error;

522: --
523: WHEN utl_file.invalid_mode then
524: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
525: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
526: hr_utility.raise_error;
527: --
528: WHEN utl_file.invalid_filehandle then
529: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
530: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

525: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
526: hr_utility.raise_error;
527: --
528: WHEN utl_file.invalid_filehandle then
529: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
530: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
531: hr_utility.raise_error;
532: --
533: WHEN utl_file.invalid_operation then

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

526: hr_utility.raise_error;
527: --
528: WHEN utl_file.invalid_filehandle then
529: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
530: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
531: hr_utility.raise_error;
532: --
533: WHEN utl_file.invalid_operation then
534: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

Line 531: hr_utility.raise_error;

527: --
528: WHEN utl_file.invalid_filehandle then
529: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
530: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
531: hr_utility.raise_error;
532: --
533: WHEN utl_file.invalid_operation then
534: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
535: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

530: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
531: hr_utility.raise_error;
532: --
533: WHEN utl_file.invalid_operation then
534: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
535: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
536: hr_utility.raise_error;
537: --
538: WHEN utl_file.read_error then

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

531: hr_utility.raise_error;
532: --
533: WHEN utl_file.invalid_operation then
534: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
535: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
536: hr_utility.raise_error;
537: --
538: WHEN utl_file.read_error then
539: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

Line 536: hr_utility.raise_error;

532: --
533: WHEN utl_file.invalid_operation then
534: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
535: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
536: hr_utility.raise_error;
537: --
538: WHEN utl_file.read_error then
539: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
540: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

535: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
536: hr_utility.raise_error;
537: --
538: WHEN utl_file.read_error then
539: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
540: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
541: hr_utility.raise_error;
542: --
543: WHEN others THEN

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

536: hr_utility.raise_error;
537: --
538: WHEN utl_file.read_error then
539: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
540: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
541: hr_utility.raise_error;
542: --
543: WHEN others THEN
544: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

Line 541: hr_utility.raise_error;

537: --
538: WHEN utl_file.read_error then
539: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
540: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
541: hr_utility.raise_error;
542: --
543: WHEN others THEN
544: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
545: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

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

540: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
541: hr_utility.raise_error;
542: --
543: WHEN others THEN
544: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
545: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
546: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
547: hr_utility.raise_error;
548:

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

541: hr_utility.raise_error;
542: --
543: WHEN others THEN
544: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
545: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
546: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
547: hr_utility.raise_error;
548:
549: END report166;

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

542: --
543: WHEN others THEN
544: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
545: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
546: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
547: hr_utility.raise_error;
548:
549: END report166;
550: ------------------------------------------------------------------------------------

Line 547: hr_utility.raise_error;

543: WHEN others THEN
544: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
545: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
546: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
547: hr_utility.raise_error;
548:
549: END report166;
550: ------------------------------------------------------------------------------------
551:

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

711: l_local_nationality := NULL;
712: END;
713:
714: -- To clear the PL/SQL Table values.
715: hr_utility.set_location('Entering report167_old ',10);
716:
717: /*Fetch Employer SSN*/
718: OPEN csr_employer_ssn;
719: FETCH csr_employer_ssn INTO l_employer_ssn;

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

919:
920: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
921: clob_to_blob(l_xfdf_string,l_xfdf_blob);
922:
923: hr_utility.set_location('Finished creating xml data for Procedure report167 ',20);
924:
925: EXCEPTION
926: WHEN utl_file.invalid_path then
927: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');

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

923: hr_utility.set_location('Finished creating xml data for Procedure report167 ',20);
924:
925: EXCEPTION
926: WHEN utl_file.invalid_path then
927: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
928: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
929: hr_utility.raise_error;
930: --
931: WHEN utl_file.invalid_mode then

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

924:
925: EXCEPTION
926: WHEN utl_file.invalid_path then
927: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
928: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
929: hr_utility.raise_error;
930: --
931: WHEN utl_file.invalid_mode then
932: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

Line 929: hr_utility.raise_error;

925: EXCEPTION
926: WHEN utl_file.invalid_path then
927: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
928: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
929: hr_utility.raise_error;
930: --
931: WHEN utl_file.invalid_mode then
932: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
933: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

928: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
929: hr_utility.raise_error;
930: --
931: WHEN utl_file.invalid_mode then
932: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
933: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
934: hr_utility.raise_error;
935: --
936: WHEN utl_file.invalid_filehandle then

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

929: hr_utility.raise_error;
930: --
931: WHEN utl_file.invalid_mode then
932: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
933: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
934: hr_utility.raise_error;
935: --
936: WHEN utl_file.invalid_filehandle then
937: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

Line 934: hr_utility.raise_error;

930: --
931: WHEN utl_file.invalid_mode then
932: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
933: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
934: hr_utility.raise_error;
935: --
936: WHEN utl_file.invalid_filehandle then
937: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
938: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

933: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
934: hr_utility.raise_error;
935: --
936: WHEN utl_file.invalid_filehandle then
937: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
938: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
939: hr_utility.raise_error;
940: --
941: WHEN utl_file.invalid_operation then

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

934: hr_utility.raise_error;
935: --
936: WHEN utl_file.invalid_filehandle then
937: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
938: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
939: hr_utility.raise_error;
940: --
941: WHEN utl_file.invalid_operation then
942: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

Line 939: hr_utility.raise_error;

935: --
936: WHEN utl_file.invalid_filehandle then
937: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
938: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
939: hr_utility.raise_error;
940: --
941: WHEN utl_file.invalid_operation then
942: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
943: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

938: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
939: hr_utility.raise_error;
940: --
941: WHEN utl_file.invalid_operation then
942: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
943: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
944: hr_utility.raise_error;
945: --
946: WHEN utl_file.read_error then

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

939: hr_utility.raise_error;
940: --
941: WHEN utl_file.invalid_operation then
942: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
943: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
944: hr_utility.raise_error;
945: --
946: WHEN utl_file.read_error then
947: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

Line 944: hr_utility.raise_error;

940: --
941: WHEN utl_file.invalid_operation then
942: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
943: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
944: hr_utility.raise_error;
945: --
946: WHEN utl_file.read_error then
947: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
948: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

943: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
944: hr_utility.raise_error;
945: --
946: WHEN utl_file.read_error then
947: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
948: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
949: hr_utility.raise_error;
950: --
951: WHEN others THEN

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

944: hr_utility.raise_error;
945: --
946: WHEN utl_file.read_error then
947: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
948: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
949: hr_utility.raise_error;
950: --
951: WHEN others THEN
952: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

Line 949: hr_utility.raise_error;

945: --
946: WHEN utl_file.read_error then
947: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
948: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
949: hr_utility.raise_error;
950: --
951: WHEN others THEN
952: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
953: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

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

948: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
949: hr_utility.raise_error;
950: --
951: WHEN others THEN
952: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
953: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
954: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
955: hr_utility.raise_error;
956:

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

949: hr_utility.raise_error;
950: --
951: WHEN others THEN
952: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
953: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
954: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
955: hr_utility.raise_error;
956:
957: END report167;

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

950: --
951: WHEN others THEN
952: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
953: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
954: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
955: hr_utility.raise_error;
956:
957: END report167;
958:

Line 955: hr_utility.raise_error;

951: WHEN others THEN
952: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
953: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
954: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
955: hr_utility.raise_error;
956:
957: END report167;
958:
959: -------------------------------------------------------------------------------------------

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

1216: l_local_nationality := NULL;
1217: END;
1218:
1219: -- To clear the PL/SQL Table values.
1220: hr_utility.set_location('Entering report167 ',10);
1221:
1222: /*Fetch Employer SSN*/
1223: OPEN csr_employer_ssn;
1224: FETCH csr_employer_ssn INTO l_employer_ssn;

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

1533:
1534: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
1535: clob_to_blob(l_xfdf_string,l_xfdf_blob);
1536:
1537: hr_utility.set_location('Finished creating xml data for Procedure report167 ',20);
1538:
1539: EXCEPTION
1540: WHEN utl_file.invalid_path then
1541: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');

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

1537: hr_utility.set_location('Finished creating xml data for Procedure report167 ',20);
1538:
1539: EXCEPTION
1540: WHEN utl_file.invalid_path then
1541: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
1542: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1543: hr_utility.raise_error;
1544: --
1545: WHEN utl_file.invalid_mode then

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

1538:
1539: EXCEPTION
1540: WHEN utl_file.invalid_path then
1541: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
1542: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1543: hr_utility.raise_error;
1544: --
1545: WHEN utl_file.invalid_mode then
1546: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

Line 1543: hr_utility.raise_error;

1539: EXCEPTION
1540: WHEN utl_file.invalid_path then
1541: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
1542: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1543: hr_utility.raise_error;
1544: --
1545: WHEN utl_file.invalid_mode then
1546: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
1547: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

1542: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1543: hr_utility.raise_error;
1544: --
1545: WHEN utl_file.invalid_mode then
1546: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
1547: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1548: hr_utility.raise_error;
1549: --
1550: WHEN utl_file.invalid_filehandle then

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

1543: hr_utility.raise_error;
1544: --
1545: WHEN utl_file.invalid_mode then
1546: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
1547: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1548: hr_utility.raise_error;
1549: --
1550: WHEN utl_file.invalid_filehandle then
1551: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

Line 1548: hr_utility.raise_error;

1544: --
1545: WHEN utl_file.invalid_mode then
1546: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
1547: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1548: hr_utility.raise_error;
1549: --
1550: WHEN utl_file.invalid_filehandle then
1551: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
1552: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

1547: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1548: hr_utility.raise_error;
1549: --
1550: WHEN utl_file.invalid_filehandle then
1551: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
1552: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1553: hr_utility.raise_error;
1554: --
1555: WHEN utl_file.invalid_operation then

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

1548: hr_utility.raise_error;
1549: --
1550: WHEN utl_file.invalid_filehandle then
1551: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
1552: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1553: hr_utility.raise_error;
1554: --
1555: WHEN utl_file.invalid_operation then
1556: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

Line 1553: hr_utility.raise_error;

1549: --
1550: WHEN utl_file.invalid_filehandle then
1551: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
1552: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1553: hr_utility.raise_error;
1554: --
1555: WHEN utl_file.invalid_operation then
1556: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
1557: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

1552: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1553: hr_utility.raise_error;
1554: --
1555: WHEN utl_file.invalid_operation then
1556: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
1557: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1558: hr_utility.raise_error;
1559: --
1560: WHEN utl_file.read_error then

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

1553: hr_utility.raise_error;
1554: --
1555: WHEN utl_file.invalid_operation then
1556: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
1557: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1558: hr_utility.raise_error;
1559: --
1560: WHEN utl_file.read_error then
1561: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

Line 1558: hr_utility.raise_error;

1554: --
1555: WHEN utl_file.invalid_operation then
1556: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
1557: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1558: hr_utility.raise_error;
1559: --
1560: WHEN utl_file.read_error then
1561: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
1562: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

1557: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1558: hr_utility.raise_error;
1559: --
1560: WHEN utl_file.read_error then
1561: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
1562: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1563: hr_utility.raise_error;
1564: --
1565: WHEN others THEN

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

1558: hr_utility.raise_error;
1559: --
1560: WHEN utl_file.read_error then
1561: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
1562: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1563: hr_utility.raise_error;
1564: --
1565: WHEN others THEN
1566: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

Line 1563: hr_utility.raise_error;

1559: --
1560: WHEN utl_file.read_error then
1561: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
1562: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1563: hr_utility.raise_error;
1564: --
1565: WHEN others THEN
1566: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1567: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

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

1562: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1563: hr_utility.raise_error;
1564: --
1565: WHEN others THEN
1566: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1567: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
1568: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1569: hr_utility.raise_error;
1570:

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

1563: hr_utility.raise_error;
1564: --
1565: WHEN others THEN
1566: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1567: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
1568: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1569: hr_utility.raise_error;
1570:
1571: END report167_2006;

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

1564: --
1565: WHEN others THEN
1566: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1567: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
1568: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1569: hr_utility.raise_error;
1570:
1571: END report167_2006;
1572: -------------------------------------------------------------------------------------------

Line 1569: hr_utility.raise_error;

1565: WHEN others THEN
1566: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1567: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
1568: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1569: hr_utility.raise_error;
1570:
1571: END report167_2006;
1572: -------------------------------------------------------------------------------------------
1573:

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

1808:
1809: -- To clear the PL/SQL Table values.
1810: vXMLTable.DELETE;
1811: vCtr := 1;
1812: hr_utility.set_location('Entering report168 ',10);
1813:
1814: l_effective_month := hr_general.decode_lookup('KW_GREGORIAN_MONTH', p_effective_month);
1815:
1816: vXMLTable(vCtr).TagName := 'R168-MONTH';

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

2152: END IF;
2153:
2154: END LOOP;
2155:
2156: hr_utility.set_location('Finished creating xml data for Procedure report166 ',20);
2157:
2158: WritetoCLOB ( l_xfdf_blob );
2159:
2160: EXCEPTION

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

2158: WritetoCLOB ( l_xfdf_blob );
2159:
2160: EXCEPTION
2161: WHEN utl_file.invalid_path then
2162: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
2163: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2164: hr_utility.raise_error;
2165: --
2166: WHEN utl_file.invalid_mode then

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

2159:
2160: EXCEPTION
2161: WHEN utl_file.invalid_path then
2162: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
2163: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2164: hr_utility.raise_error;
2165: --
2166: WHEN utl_file.invalid_mode then
2167: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

Line 2164: hr_utility.raise_error;

2160: EXCEPTION
2161: WHEN utl_file.invalid_path then
2162: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
2163: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2164: hr_utility.raise_error;
2165: --
2166: WHEN utl_file.invalid_mode then
2167: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
2168: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

2163: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2164: hr_utility.raise_error;
2165: --
2166: WHEN utl_file.invalid_mode then
2167: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
2168: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2169: hr_utility.raise_error;
2170: --
2171: WHEN utl_file.invalid_filehandle then

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

2164: hr_utility.raise_error;
2165: --
2166: WHEN utl_file.invalid_mode then
2167: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
2168: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2169: hr_utility.raise_error;
2170: --
2171: WHEN utl_file.invalid_filehandle then
2172: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

Line 2169: hr_utility.raise_error;

2165: --
2166: WHEN utl_file.invalid_mode then
2167: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
2168: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2169: hr_utility.raise_error;
2170: --
2171: WHEN utl_file.invalid_filehandle then
2172: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
2173: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

2168: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2169: hr_utility.raise_error;
2170: --
2171: WHEN utl_file.invalid_filehandle then
2172: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
2173: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2174: hr_utility.raise_error;
2175: --
2176: WHEN utl_file.invalid_operation then

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

2169: hr_utility.raise_error;
2170: --
2171: WHEN utl_file.invalid_filehandle then
2172: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
2173: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2174: hr_utility.raise_error;
2175: --
2176: WHEN utl_file.invalid_operation then
2177: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

Line 2174: hr_utility.raise_error;

2170: --
2171: WHEN utl_file.invalid_filehandle then
2172: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
2173: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2174: hr_utility.raise_error;
2175: --
2176: WHEN utl_file.invalid_operation then
2177: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
2178: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

2173: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2174: hr_utility.raise_error;
2175: --
2176: WHEN utl_file.invalid_operation then
2177: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
2178: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2179: hr_utility.raise_error;
2180: --
2181: WHEN utl_file.read_error then

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

2174: hr_utility.raise_error;
2175: --
2176: WHEN utl_file.invalid_operation then
2177: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
2178: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2179: hr_utility.raise_error;
2180: --
2181: WHEN utl_file.read_error then
2182: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

Line 2179: hr_utility.raise_error;

2175: --
2176: WHEN utl_file.invalid_operation then
2177: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
2178: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2179: hr_utility.raise_error;
2180: --
2181: WHEN utl_file.read_error then
2182: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
2183: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

2178: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2179: hr_utility.raise_error;
2180: --
2181: WHEN utl_file.read_error then
2182: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
2183: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2184: hr_utility.raise_error;
2185: --
2186: WHEN others THEN

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

2179: hr_utility.raise_error;
2180: --
2181: WHEN utl_file.read_error then
2182: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
2183: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2184: hr_utility.raise_error;
2185: --
2186: WHEN others THEN
2187: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

Line 2184: hr_utility.raise_error;

2180: --
2181: WHEN utl_file.read_error then
2182: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
2183: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2184: hr_utility.raise_error;
2185: --
2186: WHEN others THEN
2187: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2188: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

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

2183: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2184: hr_utility.raise_error;
2185: --
2186: WHEN others THEN
2187: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2188: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
2189: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2190: hr_utility.raise_error;
2191:

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

2184: hr_utility.raise_error;
2185: --
2186: WHEN others THEN
2187: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2188: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
2189: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2190: hr_utility.raise_error;
2191:
2192: END report168;

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

2185: --
2186: WHEN others THEN
2187: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2188: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
2189: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2190: hr_utility.raise_error;
2191:
2192: END report168;
2193: -------------------------------------------------------------------------------------------

Line 2190: hr_utility.raise_error;

2186: WHEN others THEN
2187: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2188: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
2189: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2190: hr_utility.raise_error;
2191:
2192: END report168;
2193: -------------------------------------------------------------------------------------------
2194:

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

2209: l_str7 varchar2(1000);
2210: l_str8 varchar2(240);
2211: l_str9 varchar2(240);
2212: BEGIN
2213: hr_utility.set_location('Entered Procedure Write to clob ',100);
2214: l_str1 := '
2215:
2216: ' ;
2217: l_str2 := '