APPS.BEN_RECN_REP dependencies on UTL_FILE

Line 45: f_out utl_file.file_type ;

41: */
42: --
43: -- Package Variables
44: --
45: f_out utl_file.file_type ;
46:
47: --
48: -- ============================================================================
49: -- <>

Line 71: -- Get utl file dir from v$parameters change this query for only one dir

67: else
68: g_log_file_name := p_log_file_name;
69: end if;
70: --
71: -- Get utl file dir from v$parameters change this query for only one dir
72: -- in utl_file_dir
73: --
74: select decode(instr(value,','),0,value,
75: substrb(translate(ltrim(value),',',' '),

Line 72: -- in utl_file_dir

68: g_log_file_name := p_log_file_name;
69: end if;
70: --
71: -- Get utl file dir from v$parameters change this query for only one dir
72: -- in utl_file_dir
73: --
74: select decode(instr(value,','),0,value,
75: substrb(translate(ltrim(value),',',' '),
76: 1,

Line 80: where name = 'utl_file_dir';

76: 1,
77: instr(translate(ltrim(value),',',' '),' ') - 1))
78: into l_audit_log_dir
79: from v$parameter
80: where name = 'utl_file_dir';
81:
82: -- Open the log File using FND routines
83: f_out := utl_file.fopen(l_audit_log_dir,g_log_file_name,'w',32767);
84: --

Line 83: f_out := utl_file.fopen(l_audit_log_dir,g_log_file_name,'w',32767);

79: from v$parameter
80: where name = 'utl_file_dir';
81:
82: -- Open the log File using FND routines
83: f_out := utl_file.fopen(l_audit_log_dir,g_log_file_name,'w',32767);
84: --
85:
86: -- Form the Audit Log File Name
87: -- Get the file separator for the platform

Line 120: utl_file.put_line(f_out,p_message);

116: -- greater than current level
117: /*fnd_file.put_line(
118: WHICH =>FND_FILE.LOG ,
119: BUFF =>p_message );*/
120: utl_file.put_line(f_out,p_message);
121: utl_file.fflush(f_out);
122: end put_line ;
123: --
124: -- ============================================================================

Line 121: utl_file.fflush(f_out);

117: /*fnd_file.put_line(
118: WHICH =>FND_FILE.LOG ,
119: BUFF =>p_message );*/
120: utl_file.put_line(f_out,p_message);
121: utl_file.fflush(f_out);
122: end put_line ;
123: --
124: -- ============================================================================
125: -- <>

Line 130: utl_file.fclose(f_out) ;

126: -- ============================================================================
127: --
128: procedure close_log_file as
129: begin
130: utl_file.fclose(f_out) ;
131: g_log_file_name := null;
132: end close_log_file;
133: --
134: -- ============================================================================