APPS.ENG_CHANGE_ACTIONS_UTIL dependencies on UTL_FILE

Line 12: g_debug_file UTL_FILE.FILE_TYPE ;

8: -- Global cursors
9: -- ---------------------------------------------------------------------------
10:
11: -- For Debug
12: g_debug_file UTL_FILE.FILE_TYPE ;
13: g_debug_flag BOOLEAN := FALSE ; -- For TEST : FALSE ;
14: g_output_dir VARCHAR2(80) := NULL ;
15: g_debug_filename VARCHAR2(30) := 'eng.chgmt.action.log' ;
16: g_debug_errmesg VARCHAR2(240);

Line 32: l_utl_file_dir VARCHAR2(2000);

28: , p_file_name IN VARCHAR2 := NULL
29: )
30: IS
31: l_found NUMBER := 0;
32: l_utl_file_dir VARCHAR2(2000);
33:
34: BEGIN
35:
36: IF p_output_dir IS NOT NULL THEN

Line 53: INTO l_utl_file_dir

49:
50: END IF;
51:
52: select value
53: INTO l_utl_file_dir
54: FROM v$parameter
55: WHERE name = 'utl_file_dir';
56:
57: l_found := INSTR(l_utl_file_dir, g_output_dir);

Line 55: WHERE name = 'utl_file_dir';

51:
52: select value
53: INTO l_utl_file_dir
54: FROM v$parameter
55: WHERE name = 'utl_file_dir';
56:
57: l_found := INSTR(l_utl_file_dir, g_output_dir);
58:
59: IF l_found = 0

Line 57: l_found := INSTR(l_utl_file_dir, g_output_dir);

53: INTO l_utl_file_dir
54: FROM v$parameter
55: WHERE name = 'utl_file_dir';
56:
57: l_found := INSTR(l_utl_file_dir, g_output_dir);
58:
59: IF l_found = 0
60: THEN
61: RETURN;

Line 64: g_debug_file := utl_file.fopen( g_output_dir

60: THEN
61: RETURN;
62: END IF;
63:
64: g_debug_file := utl_file.fopen( g_output_dir
65: , g_debug_filename
66: , 'w');
67: g_debug_flag := TRUE ;
68:

Line 80: IF utl_file.is_open(g_debug_file)

76: -- Close Debug_Session
77: PROCEDURE Close_Debug_Session
78: IS
79: BEGIN
80: IF utl_file.is_open(g_debug_file)
81: THEN
82: utl_file.fclose(g_debug_file);
83: END IF ;
84:

Line 82: utl_file.fclose(g_debug_file);

78: IS
79: BEGIN
80: IF utl_file.is_open(g_debug_file)
81: THEN
82: utl_file.fclose(g_debug_file);
83: END IF ;
84:
85: EXCEPTION
86: WHEN OTHERS THEN

Line 98: IF utl_file.is_open(g_debug_file)

94: ( p_debug_message IN VARCHAR2 )
95: IS
96: BEGIN
97:
98: IF utl_file.is_open(g_debug_file)
99: THEN
100: utl_file.put_line(g_debug_file, p_debug_message);
101: END IF ;
102:

Line 100: utl_file.put_line(g_debug_file, p_debug_message);

96: BEGIN
97:
98: IF utl_file.is_open(g_debug_file)
99: THEN
100: utl_file.put_line(g_debug_file, p_debug_message);
101: END IF ;
102:
103: EXCEPTION
104: WHEN OTHERS THEN