APPS.FND_OAM_DEBUG dependencies on UTL_FILE

Line 15: b_fd UTL_FILE.FILE_TYPE;

11: b_log_level NUMBER := NULL; --defaulting to NULL allows fnd_log's level to be used by default
12: b_include_timestamp BOOLEAN := FALSE;
13: b_use_indentation BOOLEAN := FALSE;
14: b_indent_level NUMBER := 0;
15: b_fd UTL_FILE.FILE_TYPE;
16:
17: --store what styles are enabled
18: b_style_screen BOOLEAN := FALSE;
19: b_style_file BOOLEAN := FALSE;

Line 27: IF UTL_FILE.IS_OPEN(b_fd) THEN

23: FUNCTION CLOSE_LOG_FILE
24: RETURN BOOLEAN
25: IS
26: BEGIN
27: IF UTL_FILE.IS_OPEN(b_fd) THEN
28: UTL_FILE.FCLOSE(b_fd);
29: END IF;
30: b_style_file := FALSE;
31: b_fd := NULL;

Line 28: UTL_FILE.FCLOSE(b_fd);

24: RETURN BOOLEAN
25: IS
26: BEGIN
27: IF UTL_FILE.IS_OPEN(b_fd) THEN
28: UTL_FILE.FCLOSE(b_fd);
29: END IF;
30: b_style_file := FALSE;
31: b_fd := NULL;
32: RETURN TRUE;

Line 71: UTL_FILE.FFLUSH(b_fd);

67: IS
68: BEGIN
69: -- we can only flush a file
70: IF b_style_file THEN
71: UTL_FILE.FFLUSH(b_fd);
72: END IF;
73: RETURN TRUE;
74: EXCEPTION
75: WHEN OTHERS THEN

Line 118: UTL_FILE.PUT_LINE(b_fd, s);

114: PROCEDURE LOG_FILE_WRITE(s IN VARCHAR2,
115: p_flush IN BOOLEAN)
116: IS
117: BEGIN
118: UTL_FILE.PUT_LINE(b_fd, s);
119: IF (p_flush) THEN
120: UTL_FILE.FFLUSH(b_fd);
121: END IF;
122: EXCEPTION

Line 120: UTL_FILE.FFLUSH(b_fd);

116: IS
117: BEGIN
118: UTL_FILE.PUT_LINE(b_fd, s);
119: IF (p_flush) THEN
120: UTL_FILE.FFLUSH(b_fd);
121: END IF;
122: EXCEPTION
123: WHEN OTHERS THEN
124: null;

Line 148: WHERE name = 'utl_file_dir';

144: --get the directory where we can write
145: SELECT value
146: INTO l_tmp_dir
147: FROM V$PARAMETER
148: WHERE name = 'utl_file_dir';
149:
150: IF l_tmp_dir IS NULL THEN
151: RETURN FALSE;
152: END IF;

Line 173: b_fd := UTL_FILE.FOPEN(l_tmp_dir,

169: END IF;
170: l_name := l_prefix||l_suffix||'.txt';
171:
172: --issue the file open API
173: b_fd := UTL_FILE.FOPEN(l_tmp_dir,
174: l_name,
175: 'w');
176:
177: --Yields GSCC warning, ignore