APPS.ENG_CHANGE_ROUTE_ASSOCS_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_Assocs_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(35) ;
11: g_debug_errmesg VARCHAR2(240);

Line 29: l_utl_file_dir VARCHAR2(2000);

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

Line 50: INTO l_utl_file_dir

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

Line 52: WHERE name = 'utl_file_dir';

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

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

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

Line 66: g_debug_file := utl_file.fopen( g_output_dir

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

Line 82: IF utl_file.is_open(g_debug_file)

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

Line 84: utl_file.fclose(g_debug_file);

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

Line 100: IF utl_file.is_open(g_debug_file)

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

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

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