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 UTL_FILE

Line 592: WHEN utl_file.invalid_path then

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

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 597: WHEN utl_file.invalid_mode 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);
600: hr_utility.raise_error;
601: --

Line 602: WHEN utl_file.invalid_filehandle 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);
605: hr_utility.raise_error;
606: --

Line 607: WHEN utl_file.invalid_operation 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);
610: hr_utility.raise_error;
611: --

Line 612: WHEN utl_file.read_error 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);
615: hr_utility.raise_error;
616: --

Line 1245: WHEN utl_file.invalid_path then

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

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 1250: WHEN utl_file.invalid_mode 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);
1253: hr_utility.raise_error;
1254: --

Line 1255: WHEN utl_file.invalid_filehandle 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);
1258: hr_utility.raise_error;
1259: --

Line 1260: WHEN utl_file.invalid_operation 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);
1263: hr_utility.raise_error;
1264: --

Line 1265: WHEN utl_file.read_error 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);
1268: hr_utility.raise_error;
1269: --

Line 2402: WHEN utl_file.invalid_path then

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

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 2407: WHEN utl_file.invalid_mode 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);
2410: hr_utility.raise_error;
2411: --

Line 2412: WHEN utl_file.invalid_filehandle 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);
2415: hr_utility.raise_error;
2416: --

Line 2417: WHEN utl_file.invalid_operation 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);
2420: hr_utility.raise_error;
2421: --

Line 2422: WHEN utl_file.read_error 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);
2425: hr_utility.raise_error;
2426: --

Line 2583: p_l_fp UTL_FILE.FILE_TYPE;

2579: p_request_id in number,
2580: p_report in varchar2,
2581: p_output_fname out nocopy varchar2)
2582: IS
2583: p_l_fp UTL_FILE.FILE_TYPE;
2584: l_audit_log_dir varchar2(500);
2585: l_file_name varchar2(50);
2586: l_check_flag number;
2587: BEGIN

Line 2601: WHERE LOWER(name) = 'utl_file_dir';

2597: BEGIN
2598: SELECT value
2599: INTO l_audit_log_dir
2600: FROM v$parameter
2601: WHERE LOWER(name) = 'utl_file_dir';
2602: -- Check whether more than one util file directory is found
2603: IF INSTR(l_audit_log_dir,',') > 0 THEN
2604: l_audit_log_dir := substr(l_audit_log_dir,1,instr(l_audit_log_dir,',')-1);
2605: END IF;

Line 2618: p_l_fp := utl_file.fopen(l_audit_log_dir,l_file_name,'A');

2614: ELSE
2615: p_output_fname := l_audit_log_dir || '\' || l_file_name;
2616: END IF;
2617: -- getting Agency name
2618: p_l_fp := utl_file.fopen(l_audit_log_dir,l_file_name,'A');
2619: utl_file.put_line(p_l_fp,'');
2620: utl_file.put_line(p_l_fp,'');
2621: -- Writing from and to dates
2622: utl_file.put_line(p_l_fp,'');

Line 2619: utl_file.put_line(p_l_fp,'');

2615: p_output_fname := l_audit_log_dir || '\' || l_file_name;
2616: END IF;
2617: -- getting Agency name
2618: p_l_fp := utl_file.fopen(l_audit_log_dir,l_file_name,'A');
2619: utl_file.put_line(p_l_fp,'');
2620: utl_file.put_line(p_l_fp,'');
2621: -- Writing from and to dates
2622: utl_file.put_line(p_l_fp,'');
2623: -- Write the header fields to XML File.

Line 2620: utl_file.put_line(p_l_fp,'');

2616: END IF;
2617: -- getting Agency name
2618: p_l_fp := utl_file.fopen(l_audit_log_dir,l_file_name,'A');
2619: utl_file.put_line(p_l_fp,'');
2620: utl_file.put_line(p_l_fp,'');
2621: -- Writing from and to dates
2622: utl_file.put_line(p_l_fp,'');
2623: -- Write the header fields to XML File.
2624: --WriteXMLvalues(p_l_fp,'P0_from_date',to_char(p_from_date,'dd') || ' ' || trim(to_char(p_from_date,'Month')) || ' ' || to_char(p_from_date,'yyyy') );

Line 2622: utl_file.put_line(p_l_fp,'');

2618: p_l_fp := utl_file.fopen(l_audit_log_dir,l_file_name,'A');
2619: utl_file.put_line(p_l_fp,'');
2620: utl_file.put_line(p_l_fp,'');
2621: -- Writing from and to dates
2622: utl_file.put_line(p_l_fp,'');
2623: -- Write the header fields to XML File.
2624: --WriteXMLvalues(p_l_fp,'P0_from_date',to_char(p_from_date,'dd') || ' ' || trim(to_char(p_from_date,'Month')) || ' ' || to_char(p_from_date,'yyyy') );
2625: --WriteXMLvalues(p_l_fp,'P0_to_date',to_char(p_to_date,'dd') || ' ' ||to_char(p_to_date,'Month') || ' ' || to_char(p_to_date,'yyyy') );
2626: -- Loop through PL/SQL Table and write the values into the XML File.

Line 2635: utl_file.put_line(p_l_fp,'');

2631: WriteXMLvalues(p_l_fp,vXMLTable(ctr_table).TagName ,vXMLTable(ctr_table).TagValue);
2632: END LOOP;
2633: END IF;
2634: -- Write the end tag and close the XML File.
2635: utl_file.put_line(p_l_fp,'');
2636: utl_file.put_line(p_l_fp,'');
2637: utl_file.fclose(p_l_fp);
2638: /*Msg in the temorary table*/
2639: --insert into tstmsg values('Leaving the procedure WritetoXML.');

Line 2636: utl_file.put_line(p_l_fp,'');

2632: END LOOP;
2633: END IF;
2634: -- Write the end tag and close the XML File.
2635: utl_file.put_line(p_l_fp,'');
2636: utl_file.put_line(p_l_fp,'');
2637: utl_file.fclose(p_l_fp);
2638: /*Msg in the temorary table*/
2639: --insert into tstmsg values('Leaving the procedure WritetoXML.');
2640: END WritetoXML;

Line 2637: utl_file.fclose(p_l_fp);

2633: END IF;
2634: -- Write the end tag and close the XML File.
2635: utl_file.put_line(p_l_fp,'');
2636: utl_file.put_line(p_l_fp,'');
2637: utl_file.fclose(p_l_fp);
2638: /*Msg in the temorary table*/
2639: --insert into tstmsg values('Leaving the procedure WritetoXML.');
2640: END WritetoXML;
2641: ---------------------------------------------------------------------

Line 2642: PROCEDURE WriteXMLvalues( p_l_fp utl_file.file_type,p_tagname IN VARCHAR2, p_value IN VARCHAR2) IS

2638: /*Msg in the temorary table*/
2639: --insert into tstmsg values('Leaving the procedure WritetoXML.');
2640: END WritetoXML;
2641: ---------------------------------------------------------------------
2642: PROCEDURE WriteXMLvalues( p_l_fp utl_file.file_type,p_tagname IN VARCHAR2, p_value IN VARCHAR2) IS
2643: BEGIN
2644: -- Writing XML Tag and values to XML File
2645: -- utl_file.put_line(p_l_fp,'<' || p_tagname || '>' || p_value || '' );
2646: -- New Format XFDF

Line 2645: -- utl_file.put_line(p_l_fp,'<' || p_tagname || '>' || p_value || '' );

2641: ---------------------------------------------------------------------
2642: PROCEDURE WriteXMLvalues( p_l_fp utl_file.file_type,p_tagname IN VARCHAR2, p_value IN VARCHAR2) IS
2643: BEGIN
2644: -- Writing XML Tag and values to XML File
2645: -- utl_file.put_line(p_l_fp,'<' || p_tagname || '>' || p_value || '' );
2646: -- New Format XFDF
2647: utl_file.put_line(p_l_fp,'');
2648: utl_file.put_line(p_l_fp,'' || p_value || '' );
2649: utl_file.put_line(p_l_fp,'');

Line 2647: utl_file.put_line(p_l_fp,'');

2643: BEGIN
2644: -- Writing XML Tag and values to XML File
2645: -- utl_file.put_line(p_l_fp,'<' || p_tagname || '>' || p_value || '' );
2646: -- New Format XFDF
2647: utl_file.put_line(p_l_fp,'');
2648: utl_file.put_line(p_l_fp,'' || p_value || '' );
2649: utl_file.put_line(p_l_fp,'');
2650: END WriteXMLvalues;
2651:

Line 2648: utl_file.put_line(p_l_fp,'' || p_value || '' );

2644: -- Writing XML Tag and values to XML File
2645: -- utl_file.put_line(p_l_fp,'<' || p_tagname || '>' || p_value || '' );
2646: -- New Format XFDF
2647: utl_file.put_line(p_l_fp,'');
2648: utl_file.put_line(p_l_fp,'' || p_value || '' );
2649: utl_file.put_line(p_l_fp,'');
2650: END WriteXMLvalues;
2651:
2652:

Line 2649: utl_file.put_line(p_l_fp,'');

2645: -- utl_file.put_line(p_l_fp,'<' || p_tagname || '>' || p_value || '' );
2646: -- New Format XFDF
2647: utl_file.put_line(p_l_fp,'');
2648: utl_file.put_line(p_l_fp,'' || p_value || '' );
2649: utl_file.put_line(p_l_fp,'');
2650: END WriteXMLvalues;
2651:
2652:
2653: