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

Line 304: hr_utility.set_location('Entering report55 ',10);

300:
301: -- To clear the PL/SQL Table values.
302: vXMLTable.DELETE;
303: vCtr := 1;
304: hr_utility.set_location('Entering report55 ',10);
305:
306: l_effective_month := hr_general.decode_lookup('KW_GREGORIAN_MONTH', p_effective_month);
307:
308: l_user_format := NVL(FND_PROFILE.VALUE('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),'G');

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

641: EXIT;
642: END IF;
643: END LOOP;
644:
645: hr_utility.set_location('Finished creating xml data for Procedure report166 ',20);
646:
647: WritetoCLOB ( l_xfdf_blob );
648:
649: /*EXCEPTION

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

647: WritetoCLOB ( l_xfdf_blob );
648:
649: /*EXCEPTION
650: WHEN utl_file.invalid_path then
651: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
652: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
653: hr_utility.raise_error;
654: --
655: WHEN utl_file.invalid_mode then

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

648:
649: /*EXCEPTION
650: WHEN utl_file.invalid_path then
651: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
652: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
653: hr_utility.raise_error;
654: --
655: WHEN utl_file.invalid_mode then
656: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

Line 653: hr_utility.raise_error;

649: /*EXCEPTION
650: WHEN utl_file.invalid_path then
651: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
652: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
653: hr_utility.raise_error;
654: --
655: WHEN utl_file.invalid_mode then
656: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
657: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

652: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
653: hr_utility.raise_error;
654: --
655: WHEN utl_file.invalid_mode then
656: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
657: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
658: hr_utility.raise_error;
659: --
660: WHEN utl_file.invalid_filehandle then

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

653: hr_utility.raise_error;
654: --
655: WHEN utl_file.invalid_mode then
656: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
657: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
658: hr_utility.raise_error;
659: --
660: WHEN utl_file.invalid_filehandle then
661: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

Line 658: hr_utility.raise_error;

654: --
655: WHEN utl_file.invalid_mode then
656: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
657: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
658: hr_utility.raise_error;
659: --
660: WHEN utl_file.invalid_filehandle then
661: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
662: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

657: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
658: hr_utility.raise_error;
659: --
660: WHEN utl_file.invalid_filehandle then
661: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
662: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
663: hr_utility.raise_error;
664: --
665: WHEN utl_file.invalid_operation then

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

658: hr_utility.raise_error;
659: --
660: WHEN utl_file.invalid_filehandle then
661: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
662: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
663: hr_utility.raise_error;
664: --
665: WHEN utl_file.invalid_operation then
666: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

Line 663: hr_utility.raise_error;

659: --
660: WHEN utl_file.invalid_filehandle then
661: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
662: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
663: hr_utility.raise_error;
664: --
665: WHEN utl_file.invalid_operation then
666: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
667: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

662: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
663: hr_utility.raise_error;
664: --
665: WHEN utl_file.invalid_operation then
666: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
667: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
668: hr_utility.raise_error;
669: --
670: WHEN utl_file.read_error then

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

663: hr_utility.raise_error;
664: --
665: WHEN utl_file.invalid_operation then
666: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
667: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
668: hr_utility.raise_error;
669: --
670: WHEN utl_file.read_error then
671: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

Line 668: hr_utility.raise_error;

664: --
665: WHEN utl_file.invalid_operation then
666: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
667: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
668: hr_utility.raise_error;
669: --
670: WHEN utl_file.read_error then
671: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
672: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

667: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
668: hr_utility.raise_error;
669: --
670: WHEN utl_file.read_error then
671: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
672: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
673: hr_utility.raise_error;
674: --
675: WHEN others THEN

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

668: hr_utility.raise_error;
669: --
670: WHEN utl_file.read_error then
671: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
672: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
673: hr_utility.raise_error;
674: --
675: WHEN others THEN
676: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

Line 673: hr_utility.raise_error;

669: --
670: WHEN utl_file.read_error then
671: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
672: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
673: hr_utility.raise_error;
674: --
675: WHEN others THEN
676: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
677: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

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

672: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
673: hr_utility.raise_error;
674: --
675: WHEN others THEN
676: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
677: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
678: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
679: hr_utility.raise_error;*/
680:

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

673: hr_utility.raise_error;
674: --
675: WHEN others THEN
676: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
677: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
678: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
679: hr_utility.raise_error;*/
680:
681: END report55;

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

674: --
675: WHEN others THEN
676: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
677: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
678: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
679: hr_utility.raise_error;*/
680:
681: END report55;
682: ------------------------------------------------------------------------------------

Line 679: hr_utility.raise_error;*/

675: WHEN others THEN
676: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
677: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
678: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
679: hr_utility.raise_error;*/
680:
681: END report55;
682: ------------------------------------------------------------------------------------
683:

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

917:
918: -- To clear the PL/SQL Table values.
919: vXMLTable.DELETE;
920: vCtr := 1;
921: hr_utility.set_location('Entering FORM1 ',10);
922:
923: l_user_format := null;
924: l_user_format := FND_PROFILE.VALUE('HR_LOCAL_OR_GLOBAL_NAME_FORMAT');
925:

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

1289: EXIT;
1290: END IF;
1291: END LOOP;
1292:
1293: hr_utility.set_location('Finished creating xml data for Procedure REPORT56 ',20);
1294:
1295: If l_df_flag <> 'Y' then
1296: fnd_file.put_line(fnd_file.log,get_lookup_meaning('KW_FORM_LABELS','NDF'));
1297: End If;

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

1300:
1301:
1302: /*EXCEPTION
1303: WHEN utl_file.invalid_path then
1304: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
1305: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1306: hr_utility.raise_error;
1307: --
1308: WHEN utl_file.invalid_mode then

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

1301:
1302: /*EXCEPTION
1303: WHEN utl_file.invalid_path then
1304: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
1305: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1306: hr_utility.raise_error;
1307: --
1308: WHEN utl_file.invalid_mode then
1309: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

Line 1306: hr_utility.raise_error;

1302: /*EXCEPTION
1303: WHEN utl_file.invalid_path then
1304: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
1305: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1306: hr_utility.raise_error;
1307: --
1308: WHEN utl_file.invalid_mode then
1309: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
1310: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

1305: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1306: hr_utility.raise_error;
1307: --
1308: WHEN utl_file.invalid_mode then
1309: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
1310: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1311: hr_utility.raise_error;
1312: --
1313: WHEN utl_file.invalid_filehandle then

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

1306: hr_utility.raise_error;
1307: --
1308: WHEN utl_file.invalid_mode then
1309: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
1310: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1311: hr_utility.raise_error;
1312: --
1313: WHEN utl_file.invalid_filehandle then
1314: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

Line 1311: hr_utility.raise_error;

1307: --
1308: WHEN utl_file.invalid_mode then
1309: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
1310: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1311: hr_utility.raise_error;
1312: --
1313: WHEN utl_file.invalid_filehandle then
1314: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
1315: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

1310: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1311: hr_utility.raise_error;
1312: --
1313: WHEN utl_file.invalid_filehandle then
1314: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
1315: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1316: hr_utility.raise_error;
1317: --
1318: WHEN utl_file.invalid_operation then

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

1311: hr_utility.raise_error;
1312: --
1313: WHEN utl_file.invalid_filehandle then
1314: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
1315: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1316: hr_utility.raise_error;
1317: --
1318: WHEN utl_file.invalid_operation then
1319: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

Line 1316: hr_utility.raise_error;

1312: --
1313: WHEN utl_file.invalid_filehandle then
1314: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
1315: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1316: hr_utility.raise_error;
1317: --
1318: WHEN utl_file.invalid_operation then
1319: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
1320: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

1315: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1316: hr_utility.raise_error;
1317: --
1318: WHEN utl_file.invalid_operation then
1319: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
1320: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1321: hr_utility.raise_error;
1322: --
1323: WHEN utl_file.read_error then

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

1316: hr_utility.raise_error;
1317: --
1318: WHEN utl_file.invalid_operation then
1319: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
1320: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1321: hr_utility.raise_error;
1322: --
1323: WHEN utl_file.read_error then
1324: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

Line 1321: hr_utility.raise_error;

1317: --
1318: WHEN utl_file.invalid_operation then
1319: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
1320: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1321: hr_utility.raise_error;
1322: --
1323: WHEN utl_file.read_error then
1324: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
1325: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

1320: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1321: hr_utility.raise_error;
1322: --
1323: WHEN utl_file.read_error then
1324: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
1325: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1326: hr_utility.raise_error;
1327: --
1328: WHEN others THEN

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

1321: hr_utility.raise_error;
1322: --
1323: WHEN utl_file.read_error then
1324: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
1325: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1326: hr_utility.raise_error;
1327: --
1328: WHEN others THEN
1329: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

Line 1326: hr_utility.raise_error;

1322: --
1323: WHEN utl_file.read_error then
1324: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
1325: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1326: hr_utility.raise_error;
1327: --
1328: WHEN others THEN
1329: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1330: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

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

1325: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1326: hr_utility.raise_error;
1327: --
1328: WHEN others THEN
1329: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1330: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
1331: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1332: hr_utility.raise_error;*/
1333:

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

1326: hr_utility.raise_error;
1327: --
1328: WHEN others THEN
1329: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1330: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
1331: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1332: hr_utility.raise_error;*/
1333:
1334: END report56;

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

1327: --
1328: WHEN others THEN
1329: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1330: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
1331: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1332: hr_utility.raise_error;*/
1333:
1334: END report56;
1335: -------------------------------------------------------------------------------------------

Line 1332: hr_utility.raise_error;*/

1328: WHEN others THEN
1329: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1330: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
1331: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1332: hr_utility.raise_error;*/
1333:
1334: END report56;
1335: -------------------------------------------------------------------------------------------
1336:

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

1760:
1761: -- To clear the PL/SQL Table values.
1762: vXMLTable.DELETE;
1763: vCtr := 1;
1764: hr_utility.set_location('Entering FORM1 ',10);
1765:
1766: l_user_format := null;
1767: l_user_format := FND_PROFILE.VALUE('HR_LOCAL_OR_GLOBAL_NAME_FORMAT');
1768:

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

2542: EXIT;
2543: END IF;
2544: END LOOP;
2545:
2546: hr_utility.set_location('Finished creating xml data for Procedure REPORT103 ',20);
2547:
2548: If l_df_flag <> 'Y' then
2549: fnd_file.put_line(fnd_file.log,get_lookup_meaning('KW_FORM_LABELS','NDF'));
2550: End If;

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

2552: WritetoCLOB ( l_xfdf_blob );
2553:
2554: /*EXCEPTION
2555: WHEN utl_file.invalid_path then
2556: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
2557: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2558: hr_utility.raise_error;
2559: --
2560: WHEN utl_file.invalid_mode then

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

2553:
2554: /*EXCEPTION
2555: WHEN utl_file.invalid_path then
2556: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
2557: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2558: hr_utility.raise_error;
2559: --
2560: WHEN utl_file.invalid_mode then
2561: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

Line 2558: hr_utility.raise_error;

2554: /*EXCEPTION
2555: WHEN utl_file.invalid_path then
2556: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
2557: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2558: hr_utility.raise_error;
2559: --
2560: WHEN utl_file.invalid_mode then
2561: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
2562: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

2557: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2558: hr_utility.raise_error;
2559: --
2560: WHEN utl_file.invalid_mode then
2561: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
2562: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2563: hr_utility.raise_error;
2564: --
2565: WHEN utl_file.invalid_filehandle then

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

2558: hr_utility.raise_error;
2559: --
2560: WHEN utl_file.invalid_mode then
2561: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
2562: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2563: hr_utility.raise_error;
2564: --
2565: WHEN utl_file.invalid_filehandle then
2566: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

Line 2563: hr_utility.raise_error;

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

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

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

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

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

Line 2568: hr_utility.raise_error;

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

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

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

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

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

Line 2573: hr_utility.raise_error;

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

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

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

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

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

Line 2578: hr_utility.raise_error;

2574: --
2575: WHEN utl_file.read_error then
2576: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
2577: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2578: hr_utility.raise_error;
2579: --
2580: WHEN others THEN
2581: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2582: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

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

2577: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2578: hr_utility.raise_error;
2579: --
2580: WHEN others THEN
2581: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2582: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
2583: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2584: hr_utility.raise_error;*/
2585:

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

2578: hr_utility.raise_error;
2579: --
2580: WHEN others THEN
2581: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2582: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
2583: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2584: hr_utility.raise_error;*/
2585:
2586: END report103;

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

2579: --
2580: WHEN others THEN
2581: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2582: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
2583: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2584: hr_utility.raise_error;*/
2585:
2586: END report103;
2587: -------------------------------------------------------------------------------------------

Line 2584: hr_utility.raise_error;*/

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

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

2599: l_str7 varchar2(1000);
2600: l_str8 varchar2(240);
2601: l_str9 varchar2(240);
2602: BEGIN
2603: hr_utility.set_location('Entered Procedure Write to clob ',100);
2604: l_str1 := '
2605:
2606: ' ;
2607: l_str2 := '