APPS.AP_ACCTG_DATA_FIX_PKG dependencies on UTL_FILE

Line 18: The file location is the environment's 'utl_file_dir' parameter. */

14:
15: /* Procedure to open the log files on the instance where the datafix
16: script is being run. The log file contains the log messages
17: and the report outputs written by the data fix scripts.
18: The file location is the environment's 'utl_file_dir' parameter. */
19:
20: PROCEDURE Open_Log_Out_Files
21: (P_Bug_Number IN varchar2,
22: P_File_Location OUT NOCOPY VARCHAR2) IS

Line 43: WHERE name = 'utl_file_dir';

39: SELECT decode(instr(value,','),0,value,
40: SUBSTR (value,1,instr(value,',') - 1))
41: INTO l_file_location
42: FROM v$parameter
43: WHERE name = 'utl_file_dir';
44:
45: IF l_file_location IS NULL THEN
46: RAISE No_Utl_Dir;
47: END IF;

Line 6382: vInHandle_read UTL_FILE.FILE_TYPE;

6378: v_recipient VARCHAR2,
6379: v_file_location VARCHAR2)
6380: RETURN BOOLEAN IS
6381:
6382: vInHandle_read UTL_FILE.FILE_TYPE;
6383: v_dir_name VARCHAR2(255); -- variable to hold directory name
6384: v_file_name VARCHAR2(255); -- variable to hold file name
6385: vNewLine VARCHAR2(32767);
6386: vMessage VARCHAR2(32767);

Line 6411: utl_file.fcopy(v_dir_name,v_file_name,v_dir_name, 'gdftemp.html');

6407: v_dir_name := substr(v_file_location,1,(instr(v_file_location,'/',-1)-1));
6408: v_file_name := substr(v_file_location,(instr(v_file_location,'/',-1)+1));
6409: v_subject := 'GDF Log File'||' '||v_file_name;
6410: v_body := 'Please find attached the log file';
6411: utl_file.fcopy(v_dir_name,v_file_name,v_dir_name, 'gdftemp.html');
6412: vInHandle_read := utl_file.fopen(v_dir_name,'gdftemp.html', 'r',32767);
6413: BEGIN
6414: LOOP
6415: utl_file.get_line(vInHandle_read,vNewLine);

Line 6412: vInHandle_read := utl_file.fopen(v_dir_name,'gdftemp.html', 'r',32767);

6408: v_file_name := substr(v_file_location,(instr(v_file_location,'/',-1)+1));
6409: v_subject := 'GDF Log File'||' '||v_file_name;
6410: v_body := 'Please find attached the log file';
6411: utl_file.fcopy(v_dir_name,v_file_name,v_dir_name, 'gdftemp.html');
6412: vInHandle_read := utl_file.fopen(v_dir_name,'gdftemp.html', 'r',32767);
6413: BEGIN
6414: LOOP
6415: utl_file.get_line(vInHandle_read,vNewLine);
6416: vNewLine := vNewLine||fnd_global.local_chr(10);

Line 6415: utl_file.get_line(vInHandle_read,vNewLine);

6411: utl_file.fcopy(v_dir_name,v_file_name,v_dir_name, 'gdftemp.html');
6412: vInHandle_read := utl_file.fopen(v_dir_name,'gdftemp.html', 'r',32767);
6413: BEGIN
6414: LOOP
6415: utl_file.get_line(vInHandle_read,vNewLine);
6416: vNewLine := vNewLine||fnd_global.local_chr(10);
6417: v_attachment := v_attachment||vNewLine;
6418: END LOOP;
6419: EXCEPTION

Line 6421: utl_file.fclose(vInHandle_read);

6417: v_attachment := v_attachment||vNewLine;
6418: END LOOP;
6419: EXCEPTION
6420: WHEN NO_DATA_FOUND THEN
6421: utl_file.fclose(vInHandle_read);
6422: WHEN OTHERS THEN
6423: Dbms_Output.put_line(SQLERRM);
6424: END;
6425: -- establish the connection to the smtp server