DBA Data[Home] [Help]

APPS.ARP_UPGRADE_COMMON_UTIL dependencies on UTL_FILE

Line 12: pg_fp utl_file.file_type;

8: | |
9: +-------------------------------------------------------------------------*/
10: pg_file_name VARCHAR2(100) := NULL;
11: pg_path_name VARCHAR2(100) := NULL;
12: pg_fp utl_file.file_type;
13:
14: debug_flag boolean := false;
15:
16: /*===========================================================================+

Line 164: utl_file.put_line(pg_fp, p_line);

160: BEGIN
161:
162: IF (pg_file_name IS NOT NULL) THEN
163:
164: utl_file.put_line(pg_fp, p_line);
165: utl_file.fflush(pg_fp);
166:
167: END IF;
168:

Line 165: utl_file.fflush(pg_fp);

161:
162: IF (pg_file_name IS NOT NULL) THEN
163:
164: utl_file.put_line(pg_fp, p_line);
165: utl_file.fflush(pg_fp);
166:
167: END IF;
168:
169: EXCEPTION --we only write using the io file so theres not much that can be done other than exception

Line 209: pg_fp := utl_file.fopen(p_path_name, p_file_name, 'w');

205: BEGIN
206:
207: IF (pg_file_name is null) THEN
208:
209: pg_fp := utl_file.fopen(p_path_name, p_file_name, 'w');
210: pg_file_name := p_file_name;
211: pg_path_name := p_path_name;
212:
213: END IF;

Line 224: utl_file.fclose(pg_fp);

220: PROCEDURE disable_file_debug IS
221: BEGIN
222:
223: IF (pg_file_name IS NOT NULL) THEN
224: utl_file.fclose(pg_fp);
225: END IF;
226:
227: EXCEPTION -- always raise exception as cannot write to file
228: WHEN OTHERS THEN