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 650: WHEN utl_file.invalid_path then

646:
647: WritetoCLOB ( l_xfdf_blob );
648:
649: /*EXCEPTION
650: WHEN utl_file.invalid_path then
651: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
652: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
653: hr_utility.raise_error;
654: --

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

647: WritetoCLOB ( l_xfdf_blob );
648:
649: /*EXCEPTION
650: WHEN utl_file.invalid_path then
651: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
652: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
653: hr_utility.raise_error;
654: --
655: WHEN utl_file.invalid_mode then

Line 655: WHEN utl_file.invalid_mode then

651: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
652: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
653: hr_utility.raise_error;
654: --
655: WHEN utl_file.invalid_mode then
656: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
657: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
658: hr_utility.raise_error;
659: --

Line 660: WHEN utl_file.invalid_filehandle then

656: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
657: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
658: hr_utility.raise_error;
659: --
660: WHEN utl_file.invalid_filehandle then
661: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
662: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
663: hr_utility.raise_error;
664: --

Line 665: WHEN utl_file.invalid_operation then

661: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
662: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
663: hr_utility.raise_error;
664: --
665: WHEN utl_file.invalid_operation then
666: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
667: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
668: hr_utility.raise_error;
669: --

Line 670: WHEN utl_file.read_error then

666: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
667: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
668: hr_utility.raise_error;
669: --
670: WHEN utl_file.read_error then
671: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
672: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
673: hr_utility.raise_error;
674: --

Line 1303: WHEN utl_file.invalid_path then

1299: WritetoCLOB ( l_xfdf_blob );
1300:
1301:
1302: /*EXCEPTION
1303: WHEN utl_file.invalid_path then
1304: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
1305: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1306: hr_utility.raise_error;
1307: --

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

1300:
1301:
1302: /*EXCEPTION
1303: WHEN utl_file.invalid_path then
1304: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
1305: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1306: hr_utility.raise_error;
1307: --
1308: WHEN utl_file.invalid_mode then

Line 1308: WHEN utl_file.invalid_mode then

1304: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
1305: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1306: hr_utility.raise_error;
1307: --
1308: WHEN utl_file.invalid_mode then
1309: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
1310: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1311: hr_utility.raise_error;
1312: --

Line 1313: WHEN utl_file.invalid_filehandle then

1309: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
1310: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1311: hr_utility.raise_error;
1312: --
1313: WHEN utl_file.invalid_filehandle then
1314: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
1315: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1316: hr_utility.raise_error;
1317: --

Line 1318: WHEN utl_file.invalid_operation then

1314: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
1315: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1316: hr_utility.raise_error;
1317: --
1318: WHEN utl_file.invalid_operation then
1319: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
1320: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1321: hr_utility.raise_error;
1322: --

Line 1323: WHEN utl_file.read_error then

1319: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
1320: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1321: hr_utility.raise_error;
1322: --
1323: WHEN utl_file.read_error then
1324: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
1325: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1326: hr_utility.raise_error;
1327: --

Line 2555: WHEN utl_file.invalid_path then

2551:
2552: WritetoCLOB ( l_xfdf_blob );
2553:
2554: /*EXCEPTION
2555: WHEN utl_file.invalid_path then
2556: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
2557: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2558: hr_utility.raise_error;
2559: --

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

2552: WritetoCLOB ( l_xfdf_blob );
2553:
2554: /*EXCEPTION
2555: WHEN utl_file.invalid_path then
2556: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
2557: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2558: hr_utility.raise_error;
2559: --
2560: WHEN utl_file.invalid_mode then

Line 2560: WHEN utl_file.invalid_mode then

2556: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
2557: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2558: hr_utility.raise_error;
2559: --
2560: WHEN utl_file.invalid_mode then
2561: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
2562: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2563: hr_utility.raise_error;
2564: --

Line 2565: WHEN utl_file.invalid_filehandle then

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

Line 2570: WHEN utl_file.invalid_operation then

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

Line 2575: WHEN utl_file.read_error then

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

Line 2759: p_l_fp UTL_FILE.FILE_TYPE;

2755: p_request_id in number,
2756: p_report in varchar2,
2757: p_output_fname out nocopy varchar2)
2758: IS
2759: p_l_fp UTL_FILE.FILE_TYPE;
2760: l_audit_log_dir varchar2(500);
2761: l_file_name varchar2(50);
2762: l_check_flag number;
2763: BEGIN

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

2773: BEGIN
2774: SELECT value
2775: INTO l_audit_log_dir
2776: FROM v$parameter
2777: WHERE LOWER(name) = 'utl_file_dir';
2778: -- Check whether more than one util file directory is found
2779: IF INSTR(l_audit_log_dir,',') > 0 THEN
2780: l_audit_log_dir := substr(l_audit_log_dir,1,instr(l_audit_log_dir,',')-1);
2781: END IF;

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

2790: ELSE
2791: p_output_fname := l_audit_log_dir || '\' || l_file_name;
2792: END IF;
2793: -- getting Agency name
2794: p_l_fp := utl_file.fopen(l_audit_log_dir,l_file_name,'A');
2795: utl_file.put_line(p_l_fp,'');
2796: utl_file.put_line(p_l_fp,'');
2797: -- Writing from and to dates
2798: utl_file.put_line(p_l_fp,'');

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

2791: p_output_fname := l_audit_log_dir || '\' || l_file_name;
2792: END IF;
2793: -- getting Agency name
2794: p_l_fp := utl_file.fopen(l_audit_log_dir,l_file_name,'A');
2795: utl_file.put_line(p_l_fp,'');
2796: utl_file.put_line(p_l_fp,'');
2797: -- Writing from and to dates
2798: utl_file.put_line(p_l_fp,'');
2799: -- Write the header fields to XML File.

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

2792: END IF;
2793: -- getting Agency name
2794: p_l_fp := utl_file.fopen(l_audit_log_dir,l_file_name,'A');
2795: utl_file.put_line(p_l_fp,'');
2796: utl_file.put_line(p_l_fp,'');
2797: -- Writing from and to dates
2798: utl_file.put_line(p_l_fp,'');
2799: -- Write the header fields to XML File.
2800: --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 2798: utl_file.put_line(p_l_fp,'');

2794: p_l_fp := utl_file.fopen(l_audit_log_dir,l_file_name,'A');
2795: utl_file.put_line(p_l_fp,'');
2796: utl_file.put_line(p_l_fp,'');
2797: -- Writing from and to dates
2798: utl_file.put_line(p_l_fp,'');
2799: -- Write the header fields to XML File.
2800: --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') );
2801: --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') );
2802: -- Loop through PL/SQL Table and write the values into the XML File.

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

2807: WriteXMLvalues(p_l_fp,vXMLTable(ctr_table).TagName ,vXMLTable(ctr_table).TagValue);
2808: END LOOP;
2809: END IF;
2810: -- Write the end tag and close the XML File.
2811: utl_file.put_line(p_l_fp,'');
2812: utl_file.put_line(p_l_fp,'');
2813: utl_file.fclose(p_l_fp);
2814: /*Msg in the temorary table*/
2815: --insert into tstmsg values('Leaving the procedure WritetoXML.');

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

2808: END LOOP;
2809: END IF;
2810: -- Write the end tag and close the XML File.
2811: utl_file.put_line(p_l_fp,'');
2812: utl_file.put_line(p_l_fp,'');
2813: utl_file.fclose(p_l_fp);
2814: /*Msg in the temorary table*/
2815: --insert into tstmsg values('Leaving the procedure WritetoXML.');
2816: END WritetoXML;

Line 2813: utl_file.fclose(p_l_fp);

2809: END IF;
2810: -- Write the end tag and close the XML File.
2811: utl_file.put_line(p_l_fp,'');
2812: utl_file.put_line(p_l_fp,'');
2813: utl_file.fclose(p_l_fp);
2814: /*Msg in the temorary table*/
2815: --insert into tstmsg values('Leaving the procedure WritetoXML.');
2816: END WritetoXML;
2817: ---------------------------------------------------------------------

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

2814: /*Msg in the temorary table*/
2815: --insert into tstmsg values('Leaving the procedure WritetoXML.');
2816: END WritetoXML;
2817: ---------------------------------------------------------------------
2818: PROCEDURE WriteXMLvalues( p_l_fp utl_file.file_type,p_tagname IN VARCHAR2, p_value IN VARCHAR2) IS
2819: BEGIN
2820: -- Writing XML Tag and values to XML File
2821: -- utl_file.put_line(p_l_fp,'<' || p_tagname || '>' || p_value || '' );
2822: -- New Format XFDF

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

2817: ---------------------------------------------------------------------
2818: PROCEDURE WriteXMLvalues( p_l_fp utl_file.file_type,p_tagname IN VARCHAR2, p_value IN VARCHAR2) IS
2819: BEGIN
2820: -- Writing XML Tag and values to XML File
2821: -- utl_file.put_line(p_l_fp,'<' || p_tagname || '>' || p_value || '' );
2822: -- New Format XFDF
2823: utl_file.put_line(p_l_fp,'');
2824: utl_file.put_line(p_l_fp,'' || p_value || '' );
2825: utl_file.put_line(p_l_fp,'');

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

2819: BEGIN
2820: -- Writing XML Tag and values to XML File
2821: -- utl_file.put_line(p_l_fp,'<' || p_tagname || '>' || p_value || '' );
2822: -- New Format XFDF
2823: utl_file.put_line(p_l_fp,'');
2824: utl_file.put_line(p_l_fp,'' || p_value || '' );
2825: utl_file.put_line(p_l_fp,'');
2826: END WriteXMLvalues;
2827:

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

2820: -- Writing XML Tag and values to XML File
2821: -- utl_file.put_line(p_l_fp,'<' || p_tagname || '>' || p_value || '' );
2822: -- New Format XFDF
2823: utl_file.put_line(p_l_fp,'');
2824: utl_file.put_line(p_l_fp,'' || p_value || '' );
2825: utl_file.put_line(p_l_fp,'');
2826: END WriteXMLvalues;
2827:
2828: END pay_kw_annual_reports;

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

2821: -- utl_file.put_line(p_l_fp,'<' || p_tagname || '>' || p_value || '' );
2822: -- New Format XFDF
2823: utl_file.put_line(p_l_fp,'');
2824: utl_file.put_line(p_l_fp,'' || p_value || '' );
2825: utl_file.put_line(p_l_fp,'');
2826: END WriteXMLvalues;
2827:
2828: END pay_kw_annual_reports;