DBA Data[Home] [Help]

APPS.PAY_AE_SI_REPORTS dependencies on FND_FILE

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

1176:
1177: EXCEPTION
1178: WHEN utl_file.invalid_path then
1179: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
1180: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1181: hr_utility.raise_error;
1182: --
1183: WHEN utl_file.invalid_mode then
1184: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

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

1181: hr_utility.raise_error;
1182: --
1183: WHEN utl_file.invalid_mode then
1184: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
1185: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1186: hr_utility.raise_error;
1187: --
1188: WHEN utl_file.invalid_filehandle then
1189: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

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

1186: hr_utility.raise_error;
1187: --
1188: WHEN utl_file.invalid_filehandle then
1189: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
1190: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1191: hr_utility.raise_error;
1192: --
1193: WHEN utl_file.invalid_operation then
1194: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

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

1191: hr_utility.raise_error;
1192: --
1193: WHEN utl_file.invalid_operation then
1194: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
1195: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1196: hr_utility.raise_error;
1197: --
1198: WHEN utl_file.read_error then
1199: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

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

1196: hr_utility.raise_error;
1197: --
1198: WHEN utl_file.read_error then
1199: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
1200: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1201: hr_utility.raise_error;
1202: --
1203: WHEN others THEN
1204: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

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

1202: --
1203: WHEN others THEN
1204: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1205: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
1206: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1207: hr_utility.raise_error;
1208: END FORM1;
1209: -------------------------------------------------------------------------------------------
1210: PROCEDURE FORM2

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

2035: WritetoCLOB ( l_xfdf_blob );
2036: EXCEPTION
2037: WHEN utl_file.invalid_path then
2038: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
2039: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2040: hr_utility.raise_error;
2041: --
2042: WHEN utl_file.invalid_mode then
2043: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

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

2040: hr_utility.raise_error;
2041: --
2042: WHEN utl_file.invalid_mode then
2043: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
2044: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2045: hr_utility.raise_error;
2046: --
2047: WHEN utl_file.invalid_filehandle then
2048: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

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

2045: hr_utility.raise_error;
2046: --
2047: WHEN utl_file.invalid_filehandle then
2048: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
2049: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2050: hr_utility.raise_error;
2051: --
2052: WHEN utl_file.invalid_operation then
2053: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

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

2050: hr_utility.raise_error;
2051: --
2052: WHEN utl_file.invalid_operation then
2053: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
2054: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2055: hr_utility.raise_error;
2056: --
2057: WHEN utl_file.read_error then
2058: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

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

2055: hr_utility.raise_error;
2056: --
2057: WHEN utl_file.read_error then
2058: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
2059: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2060: hr_utility.raise_error;
2061: --
2062: WHEN others THEN
2063: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

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

2061: --
2062: WHEN others THEN
2063: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2064: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
2065: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2066: hr_utility.raise_error;
2067: END FORM2;
2068: -------------------------------------------------------------------------------------------
2069: PROCEDURE FORM6

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

2559: hr_utility.set_location('Finished creating xml data for Procedure FORM6 ',20);
2560: EXCEPTION
2561: WHEN utl_file.invalid_path then
2562: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
2563: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2564: hr_utility.raise_error;
2565: --
2566: WHEN utl_file.invalid_mode then
2567: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

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

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

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

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

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

2574: hr_utility.raise_error;
2575: --
2576: WHEN utl_file.invalid_operation then
2577: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
2578: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2579: hr_utility.raise_error;
2580: --
2581: WHEN utl_file.read_error then
2582: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

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

2579: hr_utility.raise_error;
2580: --
2581: WHEN utl_file.read_error then
2582: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
2583: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2584: hr_utility.raise_error;
2585: --
2586: WHEN others THEN
2587: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

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

2585: --
2586: WHEN others THEN
2587: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2588: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
2589: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2590: hr_utility.raise_error;
2591: END FORM6;
2592: -------------------------------------------------------------------------------------------
2593: -------------------------------------------------------------------------------------------

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

3745: hr_utility.set_location('Finished creating xml data for Procedure FORM6 ',20);
3746: EXCEPTION
3747: WHEN utl_file.invalid_path then
3748: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
3749: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3750: hr_utility.raise_error;
3751: --
3752: WHEN utl_file.invalid_mode then
3753: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

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

3750: hr_utility.raise_error;
3751: --
3752: WHEN utl_file.invalid_mode then
3753: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
3754: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3755: hr_utility.raise_error;
3756: --
3757: WHEN utl_file.invalid_filehandle then
3758: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

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

3755: hr_utility.raise_error;
3756: --
3757: WHEN utl_file.invalid_filehandle then
3758: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
3759: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3760: hr_utility.raise_error;
3761: --
3762: WHEN utl_file.invalid_operation then
3763: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

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

3760: hr_utility.raise_error;
3761: --
3762: WHEN utl_file.invalid_operation then
3763: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
3764: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3765: hr_utility.raise_error;
3766: --
3767: WHEN utl_file.read_error then
3768: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

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

3765: hr_utility.raise_error;
3766: --
3767: WHEN utl_file.read_error then
3768: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
3769: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3770: hr_utility.raise_error;
3771: --
3772: WHEN others THEN
3773: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

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

3771: --
3772: WHEN others THEN
3773: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
3774: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
3775: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3776: hr_utility.raise_error;
3777: END FORM7;
3778: -------------------------------------------------------------------------------------------
3779: PROCEDURE MCP

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

4515: hr_utility.set_location('Finished creating xml data for Procedure FORM6 ',20);
4516: /*EXCEPTION
4517: WHEN utl_file.invalid_path then
4518: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
4519: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
4520: hr_utility.raise_error;
4521: --
4522: WHEN utl_file.invalid_mode then
4523: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

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

4520: hr_utility.raise_error;
4521: --
4522: WHEN utl_file.invalid_mode then
4523: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
4524: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
4525: hr_utility.raise_error;
4526: --
4527: WHEN utl_file.invalid_filehandle then
4528: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

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

4525: hr_utility.raise_error;
4526: --
4527: WHEN utl_file.invalid_filehandle then
4528: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
4529: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
4530: hr_utility.raise_error;
4531: --
4532: WHEN utl_file.invalid_operation then
4533: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

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

4530: hr_utility.raise_error;
4531: --
4532: WHEN utl_file.invalid_operation then
4533: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
4534: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
4535: hr_utility.raise_error;
4536: --
4537: WHEN utl_file.read_error then
4538: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

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

4535: hr_utility.raise_error;
4536: --
4537: WHEN utl_file.read_error then
4538: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
4539: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
4540: hr_utility.raise_error;
4541: --
4542: WHEN others THEN
4543: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

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

4541: --
4542: WHEN others THEN
4543: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
4544: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
4545: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
4546: hr_utility.raise_error;*/
4547: END MCP;
4548: -------------------------------------------------------------------------------------------
4549: PROCEDURE MCF

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

5214: hr_utility.set_location('Finished creating xml data for Procedure Monthly Contribution Federal ',20);
5215: EXCEPTION
5216: WHEN utl_file.invalid_path then
5217: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
5218: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
5219: hr_utility.raise_error;
5220: --
5221: WHEN utl_file.invalid_mode then
5222: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

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

5219: hr_utility.raise_error;
5220: --
5221: WHEN utl_file.invalid_mode then
5222: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
5223: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
5224: hr_utility.raise_error;
5225: --
5226: WHEN utl_file.invalid_filehandle then
5227: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

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

5224: hr_utility.raise_error;
5225: --
5226: WHEN utl_file.invalid_filehandle then
5227: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
5228: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
5229: hr_utility.raise_error;
5230: --
5231: WHEN utl_file.invalid_operation then
5232: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

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

5229: hr_utility.raise_error;
5230: --
5231: WHEN utl_file.invalid_operation then
5232: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
5233: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
5234: hr_utility.raise_error;
5235: --
5236: WHEN utl_file.read_error then
5237: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

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

5234: hr_utility.raise_error;
5235: --
5236: WHEN utl_file.read_error then
5237: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
5238: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
5239: hr_utility.raise_error;
5240: --
5241: WHEN others THEN
5242: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

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

5240: --
5241: WHEN others THEN
5242: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
5243: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
5244: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
5245: hr_utility.raise_error;
5246: END MCF;
5247: ---------------------------------------------------------------------------------------------------------
5248: PROCEDURE WritetoCLOB

Line 5341: fnd_file.put_line(fnd_file.log,l_varchar_buffer);

5337: else
5338: l_chunk_len := l_buffer_len;
5339: end if;
5340: DBMS_LOB.READ(p_clob,l_chunk_len,l_offset,l_varchar_buffer);
5341: fnd_file.put_line(fnd_file.log,l_varchar_buffer);
5342: --l_raw_buffer := utl_raw.cast_to_raw(l_varchar_buffer);
5343: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
5344: 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));
5345: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);