APPS.ENG_CHANGE_ROUTE_UTIL dependencies on UTL_FILE

Line 7: g_debug_file UTL_FILE.FILE_TYPE ;

3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'Eng_Change_Route_Util' ;
5:
6: -- For Debug
7: g_debug_file UTL_FILE.FILE_TYPE ;
8: g_debug_flag BOOLEAN := FALSE ; -- For TEST : FALSE ;
9: g_output_dir VARCHAR2(80) ;
10: g_debug_filename VARCHAR2(30) ;
11: g_debug_errmesg VARCHAR2(240);

Line 28: l_utl_file_dir VARCHAR2(2000);

24: , p_file_name IN VARCHAR2 := NULL
25: )
26: IS
27: l_found NUMBER := 0;
28: l_utl_file_dir VARCHAR2(2000);
29:
30: BEGIN
31:
32: IF p_output_dir IS NOT NULL THEN

Line 49: INTO l_utl_file_dir

45:
46: END IF;
47:
48: select value
49: INTO l_utl_file_dir
50: FROM v$parameter
51: WHERE name = 'utl_file_dir';
52:
53: l_found := INSTR(l_utl_file_dir, g_output_dir);

Line 51: WHERE name = 'utl_file_dir';

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

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

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

Line 65: g_debug_file := utl_file.fopen( g_output_dir

61: IF g_debug_filename IS NULL THEN
62: g_debug_filename := 'Eng_Change_Route_Util.log' ;
63: END IF ;
64:
65: g_debug_file := utl_file.fopen( g_output_dir
66: , g_debug_filename
67: , 'w');
68: g_debug_flag := TRUE ;
69:

Line 81: IF utl_file.is_open(g_debug_file)

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

Line 83: utl_file.fclose(g_debug_file);

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

Line 99: IF utl_file.is_open(g_debug_file)

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

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

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