APPS.ENG_CHANGE_ROUTE_STEP_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_Step_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 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 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_Step_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