APPS.ENG_RELATED_ENTITY_PKG dependencies on UTL_FILE

Line 8: g_debug_file UTL_FILE.FILE_TYPE ;

4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) :=
6: 'ENG_RELATED_ENTITY_PKG' ;
7: -- For Debug
8: g_debug_file UTL_FILE.FILE_TYPE ;
9: g_debug_flag BOOLEAN := FALSE ; -- For TEST : FALSE ;
10: g_output_dir VARCHAR2(80) := NULL ;
11: g_debug_filename VARCHAR2(30) := 'eng.chgmt.relationship.log' ;
12: 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 65: g_debug_file := utl_file.fopen( g_output_dir

61: THEN
62: RETURN;
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