APPS.MTH_UTIL_PKG dependencies on UTL_FILE

Line 3920: where name='utl_file_dir'

3916:
3917: select value
3918: into mth_util_pkg.g_debug_file_dir
3919: from v$parameter2
3920: where name='utl_file_dir'
3921: and rownum = 1;
3922:
3923: end if;
3924: mth_util_pkg.log_msg('-----------------------------------------------------', 1);

Line 3949: fname utl_file.file_type;

3945: PROCEDURE Log_Msg(
3946: p_msg_txt IN VARCHAR2,
3947: p_msg_lvl IN NUMBER DEFAULT NULL
3948: ) IS
3949: fname utl_file.file_type;
3950: l_indent_level NUMBER;
3951: l_execution_id NUMBER;
3952: BEGIN
3953:

Line 3975: fname := utl_file.fopen(mth_util_pkg.g_debug_file_dir,'MOC-'||mth_util_pkg.g_execution_id,'a');

3971:
3972: if mth_util_pkg.g_execution_id = -1 then
3973: fnd_file.put_line(FND_FILE.LOG, LPad(' ',l_indent_level,' ') || p_msg_txt);
3974: else
3975: fname := utl_file.fopen(mth_util_pkg.g_debug_file_dir,'MOC-'||mth_util_pkg.g_execution_id,'a');
3976: utl_file.put(fname, LPad(' ',l_indent_level,' ') || p_msg_txt);
3977: -- dbms_output.put_line(LPad(' ',l_indent_level,' ') || p_msg_txt); --to be removed before checkin
3978: utl_file.fflush(fname);
3979: utl_file.fclose(fname);

Line 3976: utl_file.put(fname, LPad(' ',l_indent_level,' ') || p_msg_txt);

3972: if mth_util_pkg.g_execution_id = -1 then
3973: fnd_file.put_line(FND_FILE.LOG, LPad(' ',l_indent_level,' ') || p_msg_txt);
3974: else
3975: fname := utl_file.fopen(mth_util_pkg.g_debug_file_dir,'MOC-'||mth_util_pkg.g_execution_id,'a');
3976: utl_file.put(fname, LPad(' ',l_indent_level,' ') || p_msg_txt);
3977: -- dbms_output.put_line(LPad(' ',l_indent_level,' ') || p_msg_txt); --to be removed before checkin
3978: utl_file.fflush(fname);
3979: utl_file.fclose(fname);
3980: end if;

Line 3978: utl_file.fflush(fname);

3974: else
3975: fname := utl_file.fopen(mth_util_pkg.g_debug_file_dir,'MOC-'||mth_util_pkg.g_execution_id,'a');
3976: utl_file.put(fname, LPad(' ',l_indent_level,' ') || p_msg_txt);
3977: -- dbms_output.put_line(LPad(' ',l_indent_level,' ') || p_msg_txt); --to be removed before checkin
3978: utl_file.fflush(fname);
3979: utl_file.fclose(fname);
3980: end if;
3981:
3982: end if;

Line 3979: utl_file.fclose(fname);

3975: fname := utl_file.fopen(mth_util_pkg.g_debug_file_dir,'MOC-'||mth_util_pkg.g_execution_id,'a');
3976: utl_file.put(fname, LPad(' ',l_indent_level,' ') || p_msg_txt);
3977: -- dbms_output.put_line(LPad(' ',l_indent_level,' ') || p_msg_txt); --to be removed before checkin
3978: utl_file.fflush(fname);
3979: utl_file.fclose(fname);
3980: end if;
3981:
3982: end if;
3983: