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.GHR_462 dependencies on UTL_FILE

Line 98: WHEN utl_file.invalid_path then

94: fnd_file.put_line(fnd_file.log,'-------------------------------------------');
95:
96: -- COMMIT;
97: EXCEPTION
98: WHEN utl_file.invalid_path then
99: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
100: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
101: hr_utility.raise_error;
102: --

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

95:
96: -- COMMIT;
97: EXCEPTION
98: WHEN utl_file.invalid_path then
99: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
100: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
101: hr_utility.raise_error;
102: --
103: WHEN utl_file.invalid_mode then

Line 103: WHEN utl_file.invalid_mode then

99: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
100: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
101: hr_utility.raise_error;
102: --
103: WHEN utl_file.invalid_mode then
104: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
105: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
106: hr_utility.raise_error;
107: --

Line 108: WHEN utl_file.invalid_filehandle then

104: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
105: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
106: hr_utility.raise_error;
107: --
108: WHEN utl_file.invalid_filehandle then
109: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
110: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
111: hr_utility.raise_error;
112: --

Line 113: WHEN utl_file.invalid_operation then

109: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
110: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
111: hr_utility.raise_error;
112: --
113: WHEN utl_file.invalid_operation then
114: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
115: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
116: hr_utility.raise_error;
117: --

Line 118: WHEN utl_file.read_error then

114: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
115: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
116: hr_utility.raise_error;
117: --
118: WHEN utl_file.read_error then
119: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
120: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
121: hr_utility.raise_error;
122: --

Line 7499: p_l_fp UTL_FILE.FILE_TYPE;

7495: p_from_date in date,
7496: p_to_date in date,
7497: p_output_fname out nocopy varchar2)
7498: IS
7499: p_l_fp UTL_FILE.FILE_TYPE;
7500: l_audit_log_dir varchar2(500) := '/sqlcom/outbound';
7501: l_file_name varchar2(50);
7502: l_agency_name varchar2(500);
7503: l_check_flag number;

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

7511: BEGIN
7512: SELECT value
7513: INTO l_audit_log_dir
7514: FROM v$parameter
7515: WHERE LOWER(name) = 'utl_file_dir';
7516: -- Check whether more than one util file directory is found
7517: IF INSTR(l_audit_log_dir,',') > 0 THEN
7518: l_audit_log_dir := substr(l_audit_log_dir,1,instr(l_audit_log_dir,',')-1);
7519: END IF;

Line 7543: p_l_fp := utl_file.fopen(l_audit_log_dir,l_file_name,'w');

7539: EXCEPTION
7540: WHEN NO_DATA_FOUND THEN
7541: l_agency_name := NULL;
7542: END;
7543: p_l_fp := utl_file.fopen(l_audit_log_dir,l_file_name,'w');
7544: utl_file.put_line(p_l_fp,'');
7545: utl_file.put_line(p_l_fp,'');
7546: -- Writing from and to dates
7547: utl_file.put_line(p_l_fp,'');

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

7540: WHEN NO_DATA_FOUND THEN
7541: l_agency_name := NULL;
7542: END;
7543: p_l_fp := utl_file.fopen(l_audit_log_dir,l_file_name,'w');
7544: utl_file.put_line(p_l_fp,'');
7545: utl_file.put_line(p_l_fp,'');
7546: -- Writing from and to dates
7547: utl_file.put_line(p_l_fp,'');
7548: -- Write the header fields to XML File.

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

7541: l_agency_name := NULL;
7542: END;
7543: p_l_fp := utl_file.fopen(l_audit_log_dir,l_file_name,'w');
7544: utl_file.put_line(p_l_fp,'');
7545: utl_file.put_line(p_l_fp,'');
7546: -- Writing from and to dates
7547: utl_file.put_line(p_l_fp,'');
7548: -- Write the header fields to XML File.
7549: 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 7547: utl_file.put_line(p_l_fp,'');

7543: p_l_fp := utl_file.fopen(l_audit_log_dir,l_file_name,'w');
7544: utl_file.put_line(p_l_fp,'');
7545: utl_file.put_line(p_l_fp,'');
7546: -- Writing from and to dates
7547: utl_file.put_line(p_l_fp,'');
7548: -- Write the header fields to XML File.
7549: 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') );
7550: 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') );
7551: WriteXMLvalues(p_l_fp,'P0_agency',l_agency_name);

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

7555: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
7556: WriteXMLvalues(p_l_fp,vXMLTable(ctr_table).TagName ,vXMLTable(ctr_table).TagValue);
7557: END LOOP;
7558: -- Write the end tag and close the XML File.
7559: utl_file.put_line(p_l_fp,'');
7560: utl_file.put_line(p_l_fp,'');
7561: utl_file.fclose(p_l_fp);
7562:
7563: END WritetoXML;

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

7556: WriteXMLvalues(p_l_fp,vXMLTable(ctr_table).TagName ,vXMLTable(ctr_table).TagValue);
7557: END LOOP;
7558: -- Write the end tag and close the XML File.
7559: utl_file.put_line(p_l_fp,'');
7560: utl_file.put_line(p_l_fp,'');
7561: utl_file.fclose(p_l_fp);
7562:
7563: END WritetoXML;
7564:

Line 7561: utl_file.fclose(p_l_fp);

7557: END LOOP;
7558: -- Write the end tag and close the XML File.
7559: utl_file.put_line(p_l_fp,'');
7560: utl_file.put_line(p_l_fp,'');
7561: utl_file.fclose(p_l_fp);
7562:
7563: END WritetoXML;
7564:
7565: PROCEDURE WriteXMLvalues(p_l_fp utl_file.file_type,p_tagname IN VARCHAR2, p_value IN VARCHAR2) IS

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

7561: utl_file.fclose(p_l_fp);
7562:
7563: END WritetoXML;
7564:
7565: PROCEDURE WriteXMLvalues(p_l_fp utl_file.file_type,p_tagname IN VARCHAR2, p_value IN VARCHAR2) IS
7566: BEGIN
7567: -- Writing XML Tag and values to XML File
7568: -- utl_file.put_line(p_l_fp,'<' || p_tagname || '>' || p_value || '' );
7569: -- New Format XFDF

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

7564:
7565: PROCEDURE WriteXMLvalues(p_l_fp utl_file.file_type,p_tagname IN VARCHAR2, p_value IN VARCHAR2) IS
7566: BEGIN
7567: -- Writing XML Tag and values to XML File
7568: -- utl_file.put_line(p_l_fp,'<' || p_tagname || '>' || p_value || '' );
7569: -- New Format XFDF
7570: utl_file.put_line(p_l_fp,'');
7571: utl_file.put_line(p_l_fp,'' || p_value || '' );
7572: utl_file.put_line(p_l_fp,'');

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

7566: BEGIN
7567: -- Writing XML Tag and values to XML File
7568: -- utl_file.put_line(p_l_fp,'<' || p_tagname || '>' || p_value || '' );
7569: -- New Format XFDF
7570: utl_file.put_line(p_l_fp,'');
7571: utl_file.put_line(p_l_fp,'' || p_value || '' );
7572: utl_file.put_line(p_l_fp,'');
7573: END WriteXMLvalues;
7574:

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

7567: -- Writing XML Tag and values to XML File
7568: -- utl_file.put_line(p_l_fp,'<' || p_tagname || '>' || p_value || '' );
7569: -- New Format XFDF
7570: utl_file.put_line(p_l_fp,'');
7571: utl_file.put_line(p_l_fp,'' || p_value || '' );
7572: utl_file.put_line(p_l_fp,'');
7573: END WriteXMLvalues;
7574:
7575:

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

7568: -- utl_file.put_line(p_l_fp,'<' || p_tagname || '>' || p_value || '' );
7569: -- New Format XFDF
7570: utl_file.put_line(p_l_fp,'');
7571: utl_file.put_line(p_l_fp,'' || p_value || '' );
7572: utl_file.put_line(p_l_fp,'');
7573: END WriteXMLvalues;
7574:
7575:
7576: