eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_WF_MSG_MAPPING_PVT dependencies on UTL_FILE

Line 7: g_fd utl_file.file_type; -- Log file descriptor

3:
4: --debug_mode boolean DEFAULT TRUE;
5: debug_mode boolean DEFAULT FALSE;
6: /** Globals to hold Logging attributs **/
7: g_fd utl_file.file_type; -- Log file descriptor
8: procedure debug(p_msg IN VARCHAR2) IS
9: l_debug VARCHAR2(1);
10:
11: begin

Line 34: where name = 'utl_file_dir';

30: begin
31: select value
32: into l_dbgdir
33: from v$PARAMETER
34: where name = 'utl_file_dir';
35:
36: if( instr(l_dbgdir, ',') > 0 ) then
37: l_dbgdir := substr(l_dbgdir, 1, instr(l_dbgdir, ',')-1);
38: end if;

Line 41: g_fd := utl_file.fopen(l_dbgdir, l_dbgfile, 'a');

37: l_dbgdir := substr(l_dbgdir, 1, instr(l_dbgdir, ',')-1);
38: end if;
39:
40: -- open the log file
41: g_fd := utl_file.fopen(l_dbgdir, l_dbgfile, 'a');
42: utl_file.put_line(g_fd, '');
43: select to_char(sysdate, 'DD-MON-YY:HH.MI.SS') into l_err_msg from dual;
44: utl_file.put_line(g_fd, 'IBEVRUTB: ******** New Session. : '||l_err_msg||' **********');
45: utl_file.put_line(g_fd, module||': ' || err_msg);

Line 42: utl_file.put_line(g_fd, '');

38: end if;
39:
40: -- open the log file
41: g_fd := utl_file.fopen(l_dbgdir, l_dbgfile, 'a');
42: utl_file.put_line(g_fd, '');
43: select to_char(sysdate, 'DD-MON-YY:HH.MI.SS') into l_err_msg from dual;
44: utl_file.put_line(g_fd, 'IBEVRUTB: ******** New Session. : '||l_err_msg||' **********');
45: utl_file.put_line(g_fd, module||': ' || err_msg);
46: utl_file.fflush(g_fd);

Line 44: utl_file.put_line(g_fd, 'IBEVRUTB: New Session. : '||l_err_msg||' **');

40: -- open the log file
41: g_fd := utl_file.fopen(l_dbgdir, l_dbgfile, 'a');
42: utl_file.put_line(g_fd, '');
43: select to_char(sysdate, 'DD-MON-YY:HH.MI.SS') into l_err_msg from dual;
44: utl_file.put_line(g_fd, 'IBEVRUTB: ******** New Session. : '||l_err_msg||' **********');
45: utl_file.put_line(g_fd, module||': ' || err_msg);
46: utl_file.fflush(g_fd);
47: EXCEPTION
48: when utl_file.INVALID_PATH then

Line 45: utl_file.put_line(g_fd, module||': ' || err_msg);

41: g_fd := utl_file.fopen(l_dbgdir, l_dbgfile, 'a');
42: utl_file.put_line(g_fd, '');
43: select to_char(sysdate, 'DD-MON-YY:HH.MI.SS') into l_err_msg from dual;
44: utl_file.put_line(g_fd, 'IBEVRUTB: ******** New Session. : '||l_err_msg||' **********');
45: utl_file.put_line(g_fd, module||': ' || err_msg);
46: utl_file.fflush(g_fd);
47: EXCEPTION
48: when utl_file.INVALID_PATH then
49: --dbms_output.put_line('*********Error: Invalid Path ');

Line 46: utl_file.fflush(g_fd);

42: utl_file.put_line(g_fd, '');
43: select to_char(sysdate, 'DD-MON-YY:HH.MI.SS') into l_err_msg from dual;
44: utl_file.put_line(g_fd, 'IBEVRUTB: ******** New Session. : '||l_err_msg||' **********');
45: utl_file.put_line(g_fd, module||': ' || err_msg);
46: utl_file.fflush(g_fd);
47: EXCEPTION
48: when utl_file.INVALID_PATH then
49: --dbms_output.put_line('*********Error: Invalid Path ');
50: null;

Line 48: when utl_file.INVALID_PATH then

44: utl_file.put_line(g_fd, 'IBEVRUTB: ******** New Session. : '||l_err_msg||' **********');
45: utl_file.put_line(g_fd, module||': ' || err_msg);
46: utl_file.fflush(g_fd);
47: EXCEPTION
48: when utl_file.INVALID_PATH then
49: --dbms_output.put_line('*********Error: Invalid Path ');
50: null;
51: when others then
52: l_err_msg := substr(sqlerrm, 1, 240);