APPS.PQP_GB_SWF_EXTRACT dependencies on UTL_FILE

Line 46: g_file_handle utl_file.file_type;

42: g_estab_number varchar2(10);
43: g_exclude_absence varchar2(3);
44: g_exclude_qual varchar2(3);
45: g_iana_char_set varchar2(30);
46: g_file_handle utl_file.file_type;
47:
48: -- LA Educational Psychologists Count
49: g_edu_psy_ft varchar2(100);
50: g_edu_psy_pt varchar2(100);

Line 82: utl_file.put_line(g_file_handle, l_data);

78:
79: hr_utility.set_location('Writing : '||l_data,5);
80: END IF;
81:
82: utl_file.put_line(g_file_handle, l_data);
83:
84: hr_utility.trace('Leaving: '||l_proc);
85: END WRITE_LINE;
86:

Line 105: g_file_handle := utl_file.fopen (g_output_dir ,l_file_name,'w');

101:
102: ELSE
103: l_file_name := 'EST_'||p_lea_or_est_num||'.'||g_request_id;
104: END IF;
105: g_file_handle := utl_file.fopen (g_output_dir ,l_file_name,'w');
106: FND_FILE.PUT_LINE(fnd_file.log,'');
107: FND_FILE.PUT_LINE(fnd_file.log,'Writing File:'||l_file_name);
108: utl_file.put_line(g_file_handle, '');
109: WRITE_LINE('O','Message',null);

Line 108: utl_file.put_line(g_file_handle, '');

104: END IF;
105: g_file_handle := utl_file.fopen (g_output_dir ,l_file_name,'w');
106: FND_FILE.PUT_LINE(fnd_file.log,'');
107: FND_FILE.PUT_LINE(fnd_file.log,'Writing File:'||l_file_name);
108: utl_file.put_line(g_file_handle, '');
109: WRITE_LINE('O','Message',null);
110:
111: hr_utility.trace('Leaving: '||l_proc);
112: END PREPARE_FILE;

Line 119: utl_file.fclose (g_file_handle);

115: l_proc constant varchar2(100):= g_package||'CLOSE_FILE';
116: BEGIN
117: hr_utility.trace('Entering: '||l_proc);
118: WRITE_LINE('C','Message',null);
119: utl_file.fclose (g_file_handle);
120: hr_utility.trace('Leaving: '||l_proc);
121: END CLOSE_FILE;
122:
123: PROCEDURE WRITE_HEADER(p_est_number number) AS

Line 823: WHEN utl_file.invalid_path THEN

819: END IF;
820: hr_utility.trace('Leaving: '||l_proc);
821:
822: EXCEPTION
823: WHEN utl_file.invalid_path THEN
824: errbuf:='Output Directory specified is invalid. Please Verify.';
825: retcode:=2;
826:
827: WHEN utl_file.invalid_operation THEN

Line 827: WHEN utl_file.invalid_operation THEN

823: WHEN utl_file.invalid_path THEN
824: errbuf:='Output Directory specified is invalid. Please Verify.';
825: retcode:=2;
826:
827: WHEN utl_file.invalid_operation THEN
828: errbuf:='Unable to open the file in the directory specified';
829: retcode:=2;
830:
831: WHEN utl_file.write_error THEN

Line 831: WHEN utl_file.write_error THEN

827: WHEN utl_file.invalid_operation THEN
828: errbuf:='Unable to open the file in the directory specified';
829: retcode:=2;
830:
831: WHEN utl_file.write_error THEN
832: errbuf:='Unable to write to the file';
833: retcode:=2;
834:
835: WHEN OTHERS THEN