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_MONTHLY_REPORTS dependencies on UTL_FILE

Line 518: WHEN utl_file.invalid_path then

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

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

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

Line 523: WHEN utl_file.invalid_mode 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');
525: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
526: hr_utility.raise_error;
527: --

Line 528: WHEN utl_file.invalid_filehandle 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');
530: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
531: hr_utility.raise_error;
532: --

Line 533: WHEN utl_file.invalid_operation 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');
535: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
536: hr_utility.raise_error;
537: --

Line 538: WHEN utl_file.read_error 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');
540: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
541: hr_utility.raise_error;
542: --

Line 926: WHEN utl_file.invalid_path then

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

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

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

Line 931: WHEN utl_file.invalid_mode 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');
933: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
934: hr_utility.raise_error;
935: --

Line 936: WHEN utl_file.invalid_filehandle 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');
938: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
939: hr_utility.raise_error;
940: --

Line 941: WHEN utl_file.invalid_operation 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');
943: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
944: hr_utility.raise_error;
945: --

Line 946: WHEN utl_file.read_error 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');
948: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
949: hr_utility.raise_error;
950: --

Line 1540: WHEN utl_file.invalid_path then

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

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

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

Line 1545: WHEN utl_file.invalid_mode 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');
1547: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1548: hr_utility.raise_error;
1549: --

Line 1550: WHEN utl_file.invalid_filehandle 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');
1552: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1553: hr_utility.raise_error;
1554: --

Line 1555: WHEN utl_file.invalid_operation 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');
1557: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1558: hr_utility.raise_error;
1559: --

Line 1560: WHEN utl_file.read_error 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');
1562: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1563: hr_utility.raise_error;
1564: --

Line 2161: WHEN utl_file.invalid_path then

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

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

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

Line 2166: WHEN utl_file.invalid_mode 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');
2168: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2169: hr_utility.raise_error;
2170: --

Line 2171: WHEN utl_file.invalid_filehandle 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');
2173: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2174: hr_utility.raise_error;
2175: --

Line 2176: WHEN utl_file.invalid_operation 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');
2178: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2179: hr_utility.raise_error;
2180: --

Line 2181: WHEN utl_file.read_error 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');
2183: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2184: hr_utility.raise_error;
2185: --

Line 2359: p_l_fp UTL_FILE.FILE_TYPE;

2355: p_request_id in number,
2356: p_report in varchar2,
2357: p_output_fname out nocopy varchar2)
2358: IS
2359: p_l_fp UTL_FILE.FILE_TYPE;
2360: l_audit_log_dir varchar2(500);
2361: l_file_name varchar2(50);
2362: l_check_flag number;
2363: BEGIN

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

2373: BEGIN
2374: SELECT value
2375: INTO l_audit_log_dir
2376: FROM v$parameter
2377: WHERE LOWER(name) = 'utl_file_dir';
2378: -- Check whether more than one util file directory is found
2379: IF INSTR(l_audit_log_dir,',') > 0 THEN
2380: l_audit_log_dir := substr(l_audit_log_dir,1,instr(l_audit_log_dir,',')-1);
2381: END IF;

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

2390: ELSE
2391: p_output_fname := l_audit_log_dir || '\' || l_file_name;
2392: END IF;
2393: -- getting Agency name
2394: p_l_fp := utl_file.fopen(l_audit_log_dir,l_file_name,'A');
2395: utl_file.put_line(p_l_fp,'');
2396: utl_file.put_line(p_l_fp,'');
2397: -- Writing from and to dates
2398: utl_file.put_line(p_l_fp,'');

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

2391: p_output_fname := l_audit_log_dir || '\' || l_file_name;
2392: END IF;
2393: -- getting Agency name
2394: p_l_fp := utl_file.fopen(l_audit_log_dir,l_file_name,'A');
2395: utl_file.put_line(p_l_fp,'');
2396: utl_file.put_line(p_l_fp,'');
2397: -- Writing from and to dates
2398: utl_file.put_line(p_l_fp,'');
2399: -- Write the header fields to XML File.

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

2392: END IF;
2393: -- getting Agency name
2394: p_l_fp := utl_file.fopen(l_audit_log_dir,l_file_name,'A');
2395: utl_file.put_line(p_l_fp,'');
2396: utl_file.put_line(p_l_fp,'');
2397: -- Writing from and to dates
2398: utl_file.put_line(p_l_fp,'');
2399: -- Write the header fields to XML File.
2400: --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 2398: utl_file.put_line(p_l_fp,'');

2394: p_l_fp := utl_file.fopen(l_audit_log_dir,l_file_name,'A');
2395: utl_file.put_line(p_l_fp,'');
2396: utl_file.put_line(p_l_fp,'');
2397: -- Writing from and to dates
2398: utl_file.put_line(p_l_fp,'');
2399: -- Write the header fields to XML File.
2400: --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') );
2401: --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') );
2402: -- Loop through PL/SQL Table and write the values into the XML File.

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

2407: WriteXMLvalues(p_l_fp,vXMLTable(ctr_table).TagName ,vXMLTable(ctr_table).TagValue);
2408: END LOOP;
2409: END IF;
2410: -- Write the end tag and close the XML File.
2411: utl_file.put_line(p_l_fp,'');
2412: utl_file.put_line(p_l_fp,'');
2413: utl_file.fclose(p_l_fp);
2414: /*Msg in the temorary table*/
2415: --insert into tstmsg values('Leaving the procedure WritetoXML.');

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

2408: END LOOP;
2409: END IF;
2410: -- Write the end tag and close the XML File.
2411: utl_file.put_line(p_l_fp,'');
2412: utl_file.put_line(p_l_fp,'');
2413: utl_file.fclose(p_l_fp);
2414: /*Msg in the temorary table*/
2415: --insert into tstmsg values('Leaving the procedure WritetoXML.');
2416: END WritetoXML;

Line 2413: utl_file.fclose(p_l_fp);

2409: END IF;
2410: -- Write the end tag and close the XML File.
2411: utl_file.put_line(p_l_fp,'');
2412: utl_file.put_line(p_l_fp,'');
2413: utl_file.fclose(p_l_fp);
2414: /*Msg in the temorary table*/
2415: --insert into tstmsg values('Leaving the procedure WritetoXML.');
2416: END WritetoXML;
2417: PROCEDURE WriteXMLvalues( p_l_fp utl_file.file_type,p_tagname IN VARCHAR2, p_value IN VARCHAR2) IS

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

2413: utl_file.fclose(p_l_fp);
2414: /*Msg in the temorary table*/
2415: --insert into tstmsg values('Leaving the procedure WritetoXML.');
2416: END WritetoXML;
2417: PROCEDURE WriteXMLvalues( p_l_fp utl_file.file_type,p_tagname IN VARCHAR2, p_value IN VARCHAR2) IS
2418: BEGIN
2419: -- Writing XML Tag and values to XML File
2420: -- utl_file.put_line(p_l_fp,'<' || p_tagname || '>' || p_value || '' );
2421: -- New Format XFDF

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

2416: END WritetoXML;
2417: PROCEDURE WriteXMLvalues( p_l_fp utl_file.file_type,p_tagname IN VARCHAR2, p_value IN VARCHAR2) IS
2418: BEGIN
2419: -- Writing XML Tag and values to XML File
2420: -- utl_file.put_line(p_l_fp,'<' || p_tagname || '>' || p_value || '' );
2421: -- New Format XFDF
2422: utl_file.put_line(p_l_fp,'');
2423: utl_file.put_line(p_l_fp,'' || p_value || '' );
2424: utl_file.put_line(p_l_fp,'');

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

2418: BEGIN
2419: -- Writing XML Tag and values to XML File
2420: -- utl_file.put_line(p_l_fp,'<' || p_tagname || '>' || p_value || '' );
2421: -- New Format XFDF
2422: utl_file.put_line(p_l_fp,'');
2423: utl_file.put_line(p_l_fp,'' || p_value || '' );
2424: utl_file.put_line(p_l_fp,'');
2425: END WriteXMLvalues;
2426:

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

2419: -- Writing XML Tag and values to XML File
2420: -- utl_file.put_line(p_l_fp,'<' || p_tagname || '>' || p_value || '' );
2421: -- New Format XFDF
2422: utl_file.put_line(p_l_fp,'');
2423: utl_file.put_line(p_l_fp,'' || p_value || '' );
2424: utl_file.put_line(p_l_fp,'');
2425: END WriteXMLvalues;
2426:
2427:

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

2420: -- utl_file.put_line(p_l_fp,'<' || p_tagname || '>' || p_value || '' );
2421: -- New Format XFDF
2422: utl_file.put_line(p_l_fp,'');
2423: utl_file.put_line(p_l_fp,'' || p_value || '' );
2424: utl_file.put_line(p_l_fp,'');
2425: END WriteXMLvalues;
2426:
2427:
2428: