DBA Data[Home] [Help]

APPS.PAY_AE_SI_REPORTS dependencies on UTL_FILE

Line 1178: WHEN utl_file.invalid_path then

1174: hr_utility.set_location('Finished creating xml data for Procedure FORM1 ',20);
1175: WritetoCLOB ( l_xfdf_blob );
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: --

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

1175: WritetoCLOB ( l_xfdf_blob );
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

Line 1183: WHEN utl_file.invalid_mode 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');
1185: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1186: hr_utility.raise_error;
1187: --

Line 1188: WHEN utl_file.invalid_filehandle 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');
1190: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1191: hr_utility.raise_error;
1192: --

Line 1193: WHEN utl_file.invalid_operation 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');
1195: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1196: hr_utility.raise_error;
1197: --

Line 1198: WHEN utl_file.read_error 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');
1200: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1201: hr_utility.raise_error;
1202: --

Line 2037: WHEN utl_file.invalid_path then

2033: END LOOP;
2034: hr_utility.set_location('Finished creating xml data for Procedure FORM1 ',20);
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: --

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

2034: hr_utility.set_location('Finished creating xml data for Procedure FORM1 ',20);
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

Line 2042: WHEN utl_file.invalid_mode 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');
2044: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2045: hr_utility.raise_error;
2046: --

Line 2047: WHEN utl_file.invalid_filehandle 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');
2049: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2050: hr_utility.raise_error;
2051: --

Line 2052: WHEN utl_file.invalid_operation 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');
2054: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2055: hr_utility.raise_error;
2056: --

Line 2057: WHEN utl_file.read_error 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');
2059: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2060: hr_utility.raise_error;
2061: --

Line 2561: WHEN utl_file.invalid_path then

2557: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
2558: clob_to_blob(l_xfdf_string,l_xfdf_blob);
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: --

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

2558: clob_to_blob(l_xfdf_string,l_xfdf_blob);
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

Line 2566: WHEN utl_file.invalid_mode 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');
2568: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2569: hr_utility.raise_error;
2570: --

Line 2571: WHEN utl_file.invalid_filehandle 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');
2573: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2574: hr_utility.raise_error;
2575: --

Line 2576: WHEN utl_file.invalid_operation 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');
2578: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2579: hr_utility.raise_error;
2580: --

Line 2581: WHEN utl_file.read_error 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');
2583: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2584: hr_utility.raise_error;
2585: --

Line 3747: WHEN utl_file.invalid_path then

3743: clob_to_blob(l_xfdf_string,l_xfdf_blob);
3744:
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: --

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

3744:
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

Line 3752: WHEN utl_file.invalid_mode 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');
3754: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3755: hr_utility.raise_error;
3756: --

Line 3757: WHEN utl_file.invalid_filehandle 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');
3759: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3760: hr_utility.raise_error;
3761: --

Line 3762: WHEN utl_file.invalid_operation 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');
3764: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3765: hr_utility.raise_error;
3766: --

Line 3767: WHEN utl_file.read_error 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');
3769: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3770: hr_utility.raise_error;
3771: --

Line 4517: WHEN utl_file.invalid_path then

4513: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
4514: clob_to_blob(l_xfdf_string,l_xfdf_blob);
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: --

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

4514: clob_to_blob(l_xfdf_string,l_xfdf_blob);
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

Line 4522: WHEN utl_file.invalid_mode 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');
4524: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
4525: hr_utility.raise_error;
4526: --

Line 4527: WHEN utl_file.invalid_filehandle 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');
4529: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
4530: hr_utility.raise_error;
4531: --

Line 4532: WHEN utl_file.invalid_operation 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');
4534: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
4535: hr_utility.raise_error;
4536: --

Line 4537: WHEN utl_file.read_error 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');
4539: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
4540: hr_utility.raise_error;
4541: --

Line 5216: WHEN utl_file.invalid_path then

5212: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
5213: clob_to_blob(l_xfdf_string,l_xfdf_blob);
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: --

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

5213: clob_to_blob(l_xfdf_string,l_xfdf_blob);
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

Line 5221: WHEN utl_file.invalid_mode 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');
5223: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
5224: hr_utility.raise_error;
5225: --

Line 5226: WHEN utl_file.invalid_filehandle 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');
5228: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
5229: hr_utility.raise_error;
5230: --

Line 5231: WHEN utl_file.invalid_operation 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');
5233: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
5234: hr_utility.raise_error;
5235: --

Line 5236: WHEN utl_file.read_error 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');
5238: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
5239: hr_utility.raise_error;
5240: --