APPS.ENG_CHANGE_ROUTE_PEOPLE_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_People_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 33: l_utl_file_dir VARCHAR2(2000);

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

Line 54: INTO l_utl_file_dir

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

Line 56: WHERE name = 'utl_file_dir';

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

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

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

Line 70: g_debug_file := utl_file.fopen( g_output_dir

66: IF g_debug_filename IS NULL THEN
67: g_debug_filename := 'Eng_Change_Route_People_Util.log' ;
68: END IF ;
69:
70: g_debug_file := utl_file.fopen( g_output_dir
71: , g_debug_filename
72: , 'w');
73: g_debug_flag := TRUE ;
74:

Line 86: IF utl_file.is_open(g_debug_file)

82: -- Close Debug_Session
83: PROCEDURE Close_Debug_Session
84: IS
85: BEGIN
86: IF utl_file.is_open(g_debug_file)
87: THEN
88: utl_file.fclose(g_debug_file);
89: END IF ;
90:

Line 88: utl_file.fclose(g_debug_file);

84: IS
85: BEGIN
86: IF utl_file.is_open(g_debug_file)
87: THEN
88: utl_file.fclose(g_debug_file);
89: END IF ;
90:
91: EXCEPTION
92: WHEN OTHERS THEN

Line 104: IF utl_file.is_open(g_debug_file)

100: ( p_debug_message IN VARCHAR2 )
101: IS
102: BEGIN
103:
104: IF utl_file.is_open(g_debug_file)
105: THEN
106: utl_file.put_line(g_debug_file, p_debug_message);
107: END IF ;
108:

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

102: BEGIN
103:
104: IF utl_file.is_open(g_debug_file)
105: THEN
106: utl_file.put_line(g_debug_file, p_debug_message);
107: END IF ;
108:
109: EXCEPTION
110: WHEN OTHERS THEN