APPS.EGO_REPORT_WF_UTIL dependencies on UTL_FILE

Line 7: g_debug_file UTL_FILE.FILE_TYPE ;

3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'EGO_REPORT_WF_UTIL' ;
5:
6: -- For Debug
7: g_debug_file UTL_FILE.FILE_TYPE ;
8: g_debug_flag BOOLEAN := FALSE ; -- For Debug, set TRUE
9: g_output_dir VARCHAR2(80) := NULL ;
10: g_debug_filename VARCHAR2(30) := 'EgoReportWorkflow.log' ;
11: g_debug_errmesg VARCHAR2(240);

Line 31: l_utl_file_dir VARCHAR2(2000);

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

Line 52: INTO l_utl_file_dir

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

Line 54: WHERE name = 'utl_file_dir';

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

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

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

Line 63: g_debug_file := utl_file.fopen( g_output_dir

59: THEN
60: RETURN;
61: END IF;
62:
63: g_debug_file := utl_file.fopen( g_output_dir
64: , g_debug_filename
65: , 'w');
66: g_debug_flag := TRUE ;
67:

Line 79: IF utl_file.is_open(g_debug_file)

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

Line 81: utl_file.fclose(g_debug_file);

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

Line 97: IF utl_file.is_open(g_debug_file)

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

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

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