APPS.PNP_DEBUG_PKG dependencies on UTL_FILE

Line 8: pg_fp utl_file.file_type;

4: --
5: --
6: pg_file_name VARCHAR2(100) := NULL;
7: pg_path_name VARCHAR2(100) := NULL;
8: pg_fp utl_file.file_type;
9:
10: PROCEDURE enable_file_debug (
11: path_name in varchar2,
12: file_name in varchar2

Line 18: pg_fp := utl_file.fopen(path_name, file_name, 'w');

14: BEGIN
15:
16: if (pg_file_name is null) THEN
17:
18: pg_fp := utl_file.fopen(path_name, file_name, 'w');
19: pg_file_name := file_name;
20: pg_path_name := path_name;
21:
22: end if;

Line 26: when utl_file.invalid_path then

22: end if;
23:
24: EXCEPTION
25:
26: when utl_file.invalid_path then
27: app_exception.raise_exception;
28: when utl_file.invalid_mode then
29: app_exception.raise_exception;
30:

Line 28: when utl_file.invalid_mode then

24: EXCEPTION
25:
26: when utl_file.invalid_path then
27: app_exception.raise_exception;
28: when utl_file.invalid_mode then
29: app_exception.raise_exception;
30:
31: END ;
32: --

Line 40: utl_file.fclose(pg_fp);

36:
37: if (pg_file_name is not null) THEN
38: pg_file_name := NULL;
39: pg_path_name := NULL;
40: utl_file.fclose(pg_fp);
41: end if;
42:
43: END;
44: --

Line 56: utl_file.put_line(pg_fp, line);

52: BEGIN
53:
54: IF (pg_file_name IS NOT NULL) THEN
55:
56: utl_file.put_line(pg_fp, line);
57: utl_file.fflush(pg_fp);
58:
59: END IF;
60:

Line 57: utl_file.fflush(pg_fp);

53:
54: IF (pg_file_name IS NOT NULL) THEN
55:
56: utl_file.put_line(pg_fp, line);
57: utl_file.fflush(pg_fp);
58:
59: END IF;
60:
61: EXCEPTION