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.MSC_SCH_WB dependencies on UTL_FILE

Line 1002: fname utl_file.file_type ;

998: END atp_debug;
999:
1000: PROCEDURE MRP_TIMING(buf IN VARCHAR2)
1001: IS
1002: fname utl_file.file_type ;
1003: BEGIN
1004: IF (utl_file.is_open(fname)) THEN
1005: utl_file.put(fname, 'atp_session: '||order_sch_wb.debug_session_id||' '||buf);
1006: utl_file.fflush(fname);

Line 1004: IF (utl_file.is_open(fname)) THEN

1000: PROCEDURE MRP_TIMING(buf IN VARCHAR2)
1001: IS
1002: fname utl_file.file_type ;
1003: BEGIN
1004: IF (utl_file.is_open(fname)) THEN
1005: utl_file.put(fname, 'atp_session: '||order_sch_wb.debug_session_id||' '||buf);
1006: utl_file.fflush(fname);
1007: utl_file.fclose(fname);
1008: ELSE

Line 1005: utl_file.put(fname, 'atp_session: '||order_sch_wb.debug_session_id||' '||buf);

1001: IS
1002: fname utl_file.file_type ;
1003: BEGIN
1004: IF (utl_file.is_open(fname)) THEN
1005: utl_file.put(fname, 'atp_session: '||order_sch_wb.debug_session_id||' '||buf);
1006: utl_file.fflush(fname);
1007: utl_file.fclose(fname);
1008: ELSE
1009: if order_sch_wb.file_dir is null then

Line 1006: utl_file.fflush(fname);

1002: fname utl_file.file_type ;
1003: BEGIN
1004: IF (utl_file.is_open(fname)) THEN
1005: utl_file.put(fname, 'atp_session: '||order_sch_wb.debug_session_id||' '||buf);
1006: utl_file.fflush(fname);
1007: utl_file.fclose(fname);
1008: ELSE
1009: if order_sch_wb.file_dir is null then
1010: --select ltrim(rtrim(substr(value, instr(value,',',-1,1)+1)))

Line 1007: utl_file.fclose(fname);

1003: BEGIN
1004: IF (utl_file.is_open(fname)) THEN
1005: utl_file.put(fname, 'atp_session: '||order_sch_wb.debug_session_id||' '||buf);
1006: utl_file.fflush(fname);
1007: utl_file.fclose(fname);
1008: ELSE
1009: if order_sch_wb.file_dir is null then
1010: --select ltrim(rtrim(substr(value, instr(value,',',-1,1)+1)))
1011: -- into order_sch_wb.file_dir from v$parameter where name= 'utl_file_dir';

Line 1011: -- into order_sch_wb.file_dir from v$parameter where name= 'utl_file_dir';

1007: utl_file.fclose(fname);
1008: ELSE
1009: if order_sch_wb.file_dir is null then
1010: --select ltrim(rtrim(substr(value, instr(value,',',-1,1)+1)))
1011: -- into order_sch_wb.file_dir from v$parameter where name= 'utl_file_dir';
1012: /*bug 3374136 changes start*/
1013: select ltrim(rtrim(value)) into order_sch_wb.file_dir from
1014: (select value from v$parameter2 where name='utl_file_dir' order by rownum desc)
1015: where rownum <2;

Line 1014: (select value from v$parameter2 where name='utl_file_dir' order by rownum desc)

1010: --select ltrim(rtrim(substr(value, instr(value,',',-1,1)+1)))
1011: -- into order_sch_wb.file_dir from v$parameter where name= 'utl_file_dir';
1012: /*bug 3374136 changes start*/
1013: select ltrim(rtrim(value)) into order_sch_wb.file_dir from
1014: (select value from v$parameter2 where name='utl_file_dir' order by rownum desc)
1015: where rownum <2;
1016: /*bug 3374136 changes end*/
1017: end if;
1018: -- dbms_output.put_line('dir '||order_sch_wb.file_dir||order_sch_wb.debug_session_id);

Line 1020: fname := utl_file.fopen(order_sch_wb.file_dir,'session-'||order_sch_wb.debug_session_id,'a');

1016: /*bug 3374136 changes end*/
1017: end if;
1018: -- dbms_output.put_line('dir '||order_sch_wb.file_dir||order_sch_wb.debug_session_id);
1019:
1020: fname := utl_file.fopen(order_sch_wb.file_dir,'session-'||order_sch_wb.debug_session_id,'a');
1021: utl_file.put(fname, buf);
1022: utl_file.fflush(fname);
1023: utl_file.fclose(fname);
1024: END IF;

Line 1021: utl_file.put(fname, buf);

1017: end if;
1018: -- dbms_output.put_line('dir '||order_sch_wb.file_dir||order_sch_wb.debug_session_id);
1019:
1020: fname := utl_file.fopen(order_sch_wb.file_dir,'session-'||order_sch_wb.debug_session_id,'a');
1021: utl_file.put(fname, buf);
1022: utl_file.fflush(fname);
1023: utl_file.fclose(fname);
1024: END IF;
1025: return;

Line 1022: utl_file.fflush(fname);

1018: -- dbms_output.put_line('dir '||order_sch_wb.file_dir||order_sch_wb.debug_session_id);
1019:
1020: fname := utl_file.fopen(order_sch_wb.file_dir,'session-'||order_sch_wb.debug_session_id,'a');
1021: utl_file.put(fname, buf);
1022: utl_file.fflush(fname);
1023: utl_file.fclose(fname);
1024: END IF;
1025: return;
1026: EXCEPTION

Line 1023: utl_file.fclose(fname);

1019:
1020: fname := utl_file.fopen(order_sch_wb.file_dir,'session-'||order_sch_wb.debug_session_id,'a');
1021: utl_file.put(fname, buf);
1022: utl_file.fflush(fname);
1023: utl_file.fclose(fname);
1024: END IF;
1025: return;
1026: EXCEPTION
1027: WHEN OTHERS THEN