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 285: hr_utility.set_location('Entering report166 ',10);

281:
282: -- To clear the PL/SQL Table values.
283: vXMLTable.DELETE;
284: vCtr := 1;
285: hr_utility.set_location('Entering report166 ',10);
286:
287: l_effective_month := hr_general.decode_lookup('KW_GREGORIAN_MONTH', p_effective_month);
288:
289: l_user_format := NVL(FND_PROFILE.VALUE('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),'G');

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

583: EXIT;
584: END IF;
585: END LOOP;
586:
587: hr_utility.set_location('Finished creating xml data for Procedure report166 ',20);
588:
589: WritetoCLOB ( l_xfdf_blob );
590:
591: /*EXCEPTION

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

589: WritetoCLOB ( l_xfdf_blob );
590:
591: /*EXCEPTION
592: WHEN utl_file.invalid_path then
593: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
594: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
595: hr_utility.raise_error;
596: --
597: WHEN utl_file.invalid_mode then

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

590:
591: /*EXCEPTION
592: WHEN utl_file.invalid_path then
593: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
594: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
595: hr_utility.raise_error;
596: --
597: WHEN utl_file.invalid_mode then
598: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

Line 595: hr_utility.raise_error;

591: /*EXCEPTION
592: WHEN utl_file.invalid_path then
593: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
594: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
595: hr_utility.raise_error;
596: --
597: WHEN utl_file.invalid_mode then
598: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
599: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

594: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
595: hr_utility.raise_error;
596: --
597: WHEN utl_file.invalid_mode then
598: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
599: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
600: hr_utility.raise_error;
601: --
602: WHEN utl_file.invalid_filehandle then

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

595: hr_utility.raise_error;
596: --
597: WHEN utl_file.invalid_mode then
598: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
599: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
600: hr_utility.raise_error;
601: --
602: WHEN utl_file.invalid_filehandle then
603: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

Line 600: hr_utility.raise_error;

596: --
597: WHEN utl_file.invalid_mode then
598: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
599: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
600: hr_utility.raise_error;
601: --
602: WHEN utl_file.invalid_filehandle then
603: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
604: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

599: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
600: hr_utility.raise_error;
601: --
602: WHEN utl_file.invalid_filehandle then
603: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
604: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
605: hr_utility.raise_error;
606: --
607: WHEN utl_file.invalid_operation then

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

600: hr_utility.raise_error;
601: --
602: WHEN utl_file.invalid_filehandle then
603: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
604: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
605: hr_utility.raise_error;
606: --
607: WHEN utl_file.invalid_operation then
608: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

Line 605: hr_utility.raise_error;

601: --
602: WHEN utl_file.invalid_filehandle then
603: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
604: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
605: hr_utility.raise_error;
606: --
607: WHEN utl_file.invalid_operation then
608: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
609: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

604: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
605: hr_utility.raise_error;
606: --
607: WHEN utl_file.invalid_operation then
608: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
609: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
610: hr_utility.raise_error;
611: --
612: WHEN utl_file.read_error then

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

605: hr_utility.raise_error;
606: --
607: WHEN utl_file.invalid_operation then
608: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
609: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
610: hr_utility.raise_error;
611: --
612: WHEN utl_file.read_error then
613: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

Line 610: hr_utility.raise_error;

606: --
607: WHEN utl_file.invalid_operation then
608: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
609: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
610: hr_utility.raise_error;
611: --
612: WHEN utl_file.read_error then
613: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
614: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

609: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
610: hr_utility.raise_error;
611: --
612: WHEN utl_file.read_error then
613: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
614: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
615: hr_utility.raise_error;
616: --
617: WHEN others THEN

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

610: hr_utility.raise_error;
611: --
612: WHEN utl_file.read_error then
613: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
614: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
615: hr_utility.raise_error;
616: --
617: WHEN others THEN
618: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

Line 615: hr_utility.raise_error;

611: --
612: WHEN utl_file.read_error then
613: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
614: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
615: hr_utility.raise_error;
616: --
617: WHEN others THEN
618: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
619: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

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

614: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
615: hr_utility.raise_error;
616: --
617: WHEN others THEN
618: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
619: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
620: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
621: hr_utility.raise_error;*/
622:

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

615: hr_utility.raise_error;
616: --
617: WHEN others THEN
618: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
619: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
620: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
621: hr_utility.raise_error;*/
622:
623: END report55;

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

616: --
617: WHEN others THEN
618: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
619: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
620: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
621: hr_utility.raise_error;*/
622:
623: END report55;
624: ------------------------------------------------------------------------------------

Line 621: hr_utility.raise_error;*/

617: WHEN others THEN
618: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
619: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
620: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
621: hr_utility.raise_error;*/
622:
623: END report55;
624: ------------------------------------------------------------------------------------
625:

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

859:
860: -- To clear the PL/SQL Table values.
861: vXMLTable.DELETE;
862: vCtr := 1;
863: hr_utility.set_location('Entering FORM1 ',10);
864:
865: l_user_format := null;
866: l_user_format := FND_PROFILE.VALUE('HR_LOCAL_OR_GLOBAL_NAME_FORMAT');
867:

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

1231: EXIT;
1232: END IF;
1233: END LOOP;
1234:
1235: hr_utility.set_location('Finished creating xml data for Procedure REPORT56 ',20);
1236:
1237: If l_df_flag <> 'Y' then
1238: fnd_file.put_line(fnd_file.log,get_lookup_meaning('KW_FORM_LABELS','NDF'));
1239: End If;

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

1242:
1243:
1244: /*EXCEPTION
1245: WHEN utl_file.invalid_path then
1246: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
1247: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1248: hr_utility.raise_error;
1249: --
1250: WHEN utl_file.invalid_mode then

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

1243:
1244: /*EXCEPTION
1245: WHEN utl_file.invalid_path then
1246: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
1247: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1248: hr_utility.raise_error;
1249: --
1250: WHEN utl_file.invalid_mode then
1251: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

Line 1248: hr_utility.raise_error;

1244: /*EXCEPTION
1245: WHEN utl_file.invalid_path then
1246: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
1247: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1248: hr_utility.raise_error;
1249: --
1250: WHEN utl_file.invalid_mode then
1251: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
1252: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

1247: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1248: hr_utility.raise_error;
1249: --
1250: WHEN utl_file.invalid_mode then
1251: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
1252: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1253: hr_utility.raise_error;
1254: --
1255: WHEN utl_file.invalid_filehandle then

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

1248: hr_utility.raise_error;
1249: --
1250: WHEN utl_file.invalid_mode then
1251: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
1252: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1253: hr_utility.raise_error;
1254: --
1255: WHEN utl_file.invalid_filehandle then
1256: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

Line 1253: hr_utility.raise_error;

1249: --
1250: WHEN utl_file.invalid_mode then
1251: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
1252: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1253: hr_utility.raise_error;
1254: --
1255: WHEN utl_file.invalid_filehandle then
1256: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
1257: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

1252: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1253: hr_utility.raise_error;
1254: --
1255: WHEN utl_file.invalid_filehandle then
1256: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
1257: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1258: hr_utility.raise_error;
1259: --
1260: WHEN utl_file.invalid_operation then

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

1253: hr_utility.raise_error;
1254: --
1255: WHEN utl_file.invalid_filehandle then
1256: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
1257: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1258: hr_utility.raise_error;
1259: --
1260: WHEN utl_file.invalid_operation then
1261: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

Line 1258: hr_utility.raise_error;

1254: --
1255: WHEN utl_file.invalid_filehandle then
1256: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
1257: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1258: hr_utility.raise_error;
1259: --
1260: WHEN utl_file.invalid_operation then
1261: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
1262: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

1257: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1258: hr_utility.raise_error;
1259: --
1260: WHEN utl_file.invalid_operation then
1261: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
1262: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1263: hr_utility.raise_error;
1264: --
1265: WHEN utl_file.read_error then

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

1258: hr_utility.raise_error;
1259: --
1260: WHEN utl_file.invalid_operation then
1261: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
1262: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1263: hr_utility.raise_error;
1264: --
1265: WHEN utl_file.read_error then
1266: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

Line 1263: hr_utility.raise_error;

1259: --
1260: WHEN utl_file.invalid_operation then
1261: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
1262: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1263: hr_utility.raise_error;
1264: --
1265: WHEN utl_file.read_error then
1266: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
1267: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

1262: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1263: hr_utility.raise_error;
1264: --
1265: WHEN utl_file.read_error then
1266: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
1267: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1268: hr_utility.raise_error;
1269: --
1270: WHEN others THEN

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

1263: hr_utility.raise_error;
1264: --
1265: WHEN utl_file.read_error then
1266: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
1267: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1268: hr_utility.raise_error;
1269: --
1270: WHEN others THEN
1271: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

Line 1268: hr_utility.raise_error;

1264: --
1265: WHEN utl_file.read_error then
1266: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
1267: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1268: hr_utility.raise_error;
1269: --
1270: WHEN others THEN
1271: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1272: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

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

1267: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1268: hr_utility.raise_error;
1269: --
1270: WHEN others THEN
1271: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1272: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
1273: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1274: hr_utility.raise_error;*/
1275:

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

1268: hr_utility.raise_error;
1269: --
1270: WHEN others THEN
1271: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1272: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
1273: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1274: hr_utility.raise_error;*/
1275:
1276: END report56;

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

1269: --
1270: WHEN others THEN
1271: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1272: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
1273: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1274: hr_utility.raise_error;*/
1275:
1276: END report56;
1277: -------------------------------------------------------------------------------------------

Line 1274: hr_utility.raise_error;*/

1270: WHEN others THEN
1271: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1272: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
1273: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1274: hr_utility.raise_error;*/
1275:
1276: END report56;
1277: -------------------------------------------------------------------------------------------
1278:

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

1679:
1680: -- To clear the PL/SQL Table values.
1681: vXMLTable.DELETE;
1682: vCtr := 1;
1683: hr_utility.set_location('Entering FORM1 ',10);
1684:
1685: l_user_format := null;
1686: l_user_format := FND_PROFILE.VALUE('HR_LOCAL_OR_GLOBAL_NAME_FORMAT');
1687:

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

2389: EXIT;
2390: END IF;
2391: END LOOP;
2392:
2393: hr_utility.set_location('Finished creating xml data for Procedure REPORT103 ',20);
2394:
2395: If l_df_flag <> 'Y' then
2396: fnd_file.put_line(fnd_file.log,get_lookup_meaning('KW_FORM_LABELS','NDF'));
2397: End If;

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

2399: WritetoCLOB ( l_xfdf_blob );
2400:
2401: /*EXCEPTION
2402: WHEN utl_file.invalid_path then
2403: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
2404: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2405: hr_utility.raise_error;
2406: --
2407: WHEN utl_file.invalid_mode then

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

2400:
2401: /*EXCEPTION
2402: WHEN utl_file.invalid_path then
2403: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
2404: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2405: hr_utility.raise_error;
2406: --
2407: WHEN utl_file.invalid_mode then
2408: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

Line 2405: hr_utility.raise_error;

2401: /*EXCEPTION
2402: WHEN utl_file.invalid_path then
2403: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
2404: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2405: hr_utility.raise_error;
2406: --
2407: WHEN utl_file.invalid_mode then
2408: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
2409: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

2404: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2405: hr_utility.raise_error;
2406: --
2407: WHEN utl_file.invalid_mode then
2408: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
2409: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2410: hr_utility.raise_error;
2411: --
2412: WHEN utl_file.invalid_filehandle then

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

2405: hr_utility.raise_error;
2406: --
2407: WHEN utl_file.invalid_mode then
2408: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
2409: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2410: hr_utility.raise_error;
2411: --
2412: WHEN utl_file.invalid_filehandle then
2413: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

Line 2410: hr_utility.raise_error;

2406: --
2407: WHEN utl_file.invalid_mode then
2408: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
2409: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2410: hr_utility.raise_error;
2411: --
2412: WHEN utl_file.invalid_filehandle then
2413: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
2414: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

2409: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2410: hr_utility.raise_error;
2411: --
2412: WHEN utl_file.invalid_filehandle then
2413: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
2414: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2415: hr_utility.raise_error;
2416: --
2417: WHEN utl_file.invalid_operation then

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

2410: hr_utility.raise_error;
2411: --
2412: WHEN utl_file.invalid_filehandle then
2413: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
2414: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2415: hr_utility.raise_error;
2416: --
2417: WHEN utl_file.invalid_operation then
2418: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

Line 2415: hr_utility.raise_error;

2411: --
2412: WHEN utl_file.invalid_filehandle then
2413: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
2414: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2415: hr_utility.raise_error;
2416: --
2417: WHEN utl_file.invalid_operation then
2418: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
2419: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

2414: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2415: hr_utility.raise_error;
2416: --
2417: WHEN utl_file.invalid_operation then
2418: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
2419: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2420: hr_utility.raise_error;
2421: --
2422: WHEN utl_file.read_error then

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

2415: hr_utility.raise_error;
2416: --
2417: WHEN utl_file.invalid_operation then
2418: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
2419: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2420: hr_utility.raise_error;
2421: --
2422: WHEN utl_file.read_error then
2423: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

Line 2420: hr_utility.raise_error;

2416: --
2417: WHEN utl_file.invalid_operation then
2418: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
2419: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2420: hr_utility.raise_error;
2421: --
2422: WHEN utl_file.read_error then
2423: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
2424: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

2419: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2420: hr_utility.raise_error;
2421: --
2422: WHEN utl_file.read_error then
2423: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
2424: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2425: hr_utility.raise_error;
2426: --
2427: WHEN others THEN

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

2420: hr_utility.raise_error;
2421: --
2422: WHEN utl_file.read_error then
2423: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
2424: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2425: hr_utility.raise_error;
2426: --
2427: WHEN others THEN
2428: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

Line 2425: hr_utility.raise_error;

2421: --
2422: WHEN utl_file.read_error then
2423: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
2424: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2425: hr_utility.raise_error;
2426: --
2427: WHEN others THEN
2428: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2429: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

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

2424: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2425: hr_utility.raise_error;
2426: --
2427: WHEN others THEN
2428: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2429: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
2430: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2431: hr_utility.raise_error;*/
2432:

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

2425: hr_utility.raise_error;
2426: --
2427: WHEN others THEN
2428: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2429: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
2430: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2431: hr_utility.raise_error;*/
2432:
2433: END report103;

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

2426: --
2427: WHEN others THEN
2428: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2429: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
2430: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2431: hr_utility.raise_error;*/
2432:
2433: END report103;
2434: -------------------------------------------------------------------------------------------

Line 2431: hr_utility.raise_error;*/

2427: WHEN others THEN
2428: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2429: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
2430: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2431: hr_utility.raise_error;*/
2432:
2433: END report103;
2434: -------------------------------------------------------------------------------------------
2435:

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

2446: l_str7 varchar2(1000);
2447: l_str8 varchar2(240);
2448: l_str9 varchar2(240);
2449: BEGIN
2450: hr_utility.set_location('Entered Procedure Write to clob ',100);
2451: l_str1 := '
2452:
2453: ' ;
2454: l_str2 := '