DBA Data[Home] [Help]

APPS.PAY_KW_MONTHLY_REPORTS dependencies on FND_FILE

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 2796: fnd_file.put_line(fnd_file.log, l_varchar_buffer);

2792: --l_raw_buffer := utl_raw.cast_to_raw(l_varchar_buffer);
2793: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
2794: l_raw_buffer_len := utl_raw.length(utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char));
2795:
2796: fnd_file.put_line(fnd_file.log, l_varchar_buffer);
2797:
2798: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
2799: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);
2800: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);