DBA Data[Home] [Help]

APPS.PAY_KW_MONTHLY_REPORTS dependencies on FND_FILE

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

2294: --l_raw_buffer := utl_raw.cast_to_raw(l_varchar_buffer);
2295: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
2296: 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));
2297:
2298: fnd_file.put_line(fnd_file.log, l_varchar_buffer);
2299:
2300: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
2301: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);
2302: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);