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

Line 29: ,x_file_handle OUT NOCOPY UTL_FILE.FILE_TYPE

25: G_PKG_NAME VARCHAR2(200) := 'BIS_PMF_GET_DIMLEVELS_PVT';
26: --Copied from JK's utilities blindly almost
27: PROCEDURE FILE_OPEN
28: (p_file_name IN VARCHAR2
29: ,x_file_handle OUT NOCOPY UTL_FILE.FILE_TYPE
30: )
31: IS
32: l_dir VARCHAR2(32000);
33:

Line 37: WHERE vp.name = 'utl_file_dir';

33:
34: CURSOR c_file IS
35: SELECT vp.value
36: FROM v$parameter vp
37: WHERE vp.name = 'utl_file_dir';
38:
39: l_file_name VARCHAR2(32000);
40:
41: BEGIN

Line 53: IF UTL_FILE.IS_OPEN(x_file_handle) THEN

49: CLOSE c_file;
50: IF instr(l_dir,',') > 0 THEN
51: l_dir := substr(l_dir,1,instr(l_dir,',')-1);
52: END IF;
53: IF UTL_FILE.IS_OPEN(x_file_handle) THEN
54: UTL_FILE.FCLOSE(x_file_handle);
55: END IF;
56: x_file_handle := UTL_FILE.FOPEN(l_dir, l_file_name, 'w');
57: EXCEPTION

Line 54: UTL_FILE.FCLOSE(x_file_handle);

50: IF instr(l_dir,',') > 0 THEN
51: l_dir := substr(l_dir,1,instr(l_dir,',')-1);
52: END IF;
53: IF UTL_FILE.IS_OPEN(x_file_handle) THEN
54: UTL_FILE.FCLOSE(x_file_handle);
55: END IF;
56: x_file_handle := UTL_FILE.FOPEN(l_dir, l_file_name, 'w');
57: EXCEPTION
58: WHEN UTL_FILE.INVALID_PATH THEN

Line 56: x_file_handle := UTL_FILE.FOPEN(l_dir, l_file_name, 'w');

52: END IF;
53: IF UTL_FILE.IS_OPEN(x_file_handle) THEN
54: UTL_FILE.FCLOSE(x_file_handle);
55: END IF;
56: x_file_handle := UTL_FILE.FOPEN(l_dir, l_file_name, 'w');
57: EXCEPTION
58: WHEN UTL_FILE.INVALID_PATH THEN
59: RAISE_APPLICATION_ERROR(-20100, 'Invalid PAth');
60: WHEN UTL_FILE.INVALID_MODE THEN

Line 58: WHEN UTL_FILE.INVALID_PATH THEN

54: UTL_FILE.FCLOSE(x_file_handle);
55: END IF;
56: x_file_handle := UTL_FILE.FOPEN(l_dir, l_file_name, 'w');
57: EXCEPTION
58: WHEN UTL_FILE.INVALID_PATH THEN
59: RAISE_APPLICATION_ERROR(-20100, 'Invalid PAth');
60: WHEN UTL_FILE.INVALID_MODE THEN
61: RAISE_APPLICATION_ERROR(-20101,'Invalid Mode');
62: WHEN UTL_FILE.INVALID_OPERATION THEN

Line 60: WHEN UTL_FILE.INVALID_MODE THEN

56: x_file_handle := UTL_FILE.FOPEN(l_dir, l_file_name, 'w');
57: EXCEPTION
58: WHEN UTL_FILE.INVALID_PATH THEN
59: RAISE_APPLICATION_ERROR(-20100, 'Invalid PAth');
60: WHEN UTL_FILE.INVALID_MODE THEN
61: RAISE_APPLICATION_ERROR(-20101,'Invalid Mode');
62: WHEN UTL_FILE.INVALID_OPERATION THEN
63: RAISE_APPLICATION_ERROR(-20101,' Invalid operation');
64: END;

Line 62: WHEN UTL_FILE.INVALID_OPERATION THEN

58: WHEN UTL_FILE.INVALID_PATH THEN
59: RAISE_APPLICATION_ERROR(-20100, 'Invalid PAth');
60: WHEN UTL_FILE.INVALID_MODE THEN
61: RAISE_APPLICATION_ERROR(-20101,'Invalid Mode');
62: WHEN UTL_FILE.INVALID_OPERATION THEN
63: RAISE_APPLICATION_ERROR(-20101,' Invalid operation');
64: END;
65: --Copied from JK's utilities blindly almost
66: PROCEDURE WRITE_TO_FILE

Line 68: ,p_file_handle IN UTL_FILE.FILE_TYPE

64: END;
65: --Copied from JK's utilities blindly almost
66: PROCEDURE WRITE_TO_FILE
67: (p_text IN VARCHAR2
68: ,p_file_handle IN UTL_FILE.FILE_TYPE
69: )
70: IS
71: BEGIN
72: UTL_FILE.putf(p_file_handle, '%s \n', p_text);

Line 72: UTL_FILE.putf(p_file_handle, '%s \n', p_text);

68: ,p_file_handle IN UTL_FILE.FILE_TYPE
69: )
70: IS
71: BEGIN
72: UTL_FILE.putf(p_file_handle, '%s \n', p_text);
73: UTL_FILE.fflush(p_file_handle);
74: EXCEPTION
75: WHEN UTL_FILE.INVALID_OPERATION THEN
76: RAISE_APPLICATION_ERROR(-20101, 'Invalid Operation');

Line 73: UTL_FILE.fflush(p_file_handle);

69: )
70: IS
71: BEGIN
72: UTL_FILE.putf(p_file_handle, '%s \n', p_text);
73: UTL_FILE.fflush(p_file_handle);
74: EXCEPTION
75: WHEN UTL_FILE.INVALID_OPERATION THEN
76: RAISE_APPLICATION_ERROR(-20101, 'Invalid Operation');
77: WHEN UTL_FILE.INVALID_FILEHANDLE THEN

Line 75: WHEN UTL_FILE.INVALID_OPERATION THEN

71: BEGIN
72: UTL_FILE.putf(p_file_handle, '%s \n', p_text);
73: UTL_FILE.fflush(p_file_handle);
74: EXCEPTION
75: WHEN UTL_FILE.INVALID_OPERATION THEN
76: RAISE_APPLICATION_ERROR(-20101, 'Invalid Operation');
77: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
78: RAISE_APPLICATION_ERROR(-20103,
79: 'Debug: Invalid File Handle');

Line 77: WHEN UTL_FILE.INVALID_FILEHANDLE THEN

73: UTL_FILE.fflush(p_file_handle);
74: EXCEPTION
75: WHEN UTL_FILE.INVALID_OPERATION THEN
76: RAISE_APPLICATION_ERROR(-20101, 'Invalid Operation');
77: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
78: RAISE_APPLICATION_ERROR(-20103,
79: 'Debug: Invalid File Handle');
80: WHEN UTL_FILE.WRITE_ERROR THEN
81: RAISE_APPLICATION_ERROR(-20104,

Line 80: WHEN UTL_FILE.WRITE_ERROR THEN

76: RAISE_APPLICATION_ERROR(-20101, 'Invalid Operation');
77: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
78: RAISE_APPLICATION_ERROR(-20103,
79: 'Debug: Invalid File Handle');
80: WHEN UTL_FILE.WRITE_ERROR THEN
81: RAISE_APPLICATION_ERROR(-20104,
82: 'Debug: Write Error');
83: END;
84: PROCEDURE REPORT_ERRORS

Line 133: l_err_file_handle UTL_FILE.FILE_TYPE;

129: upper(level_Table_name) = upper(l_lvlshortname||'_LTC') AND
130: level_table_col_name like '%PK_KEY%';
131: i*/
132: l_time_columns VARCHAR2(2000);
133: l_err_file_handle UTL_FILE.FILE_TYPE;
134: l_success_file_handle UTL_FILE.FILE_TYPE;
135: l_error_text VARCHAR2(32000);
136: l_success_text VARCHAR2(32000);
137: l_dimshortname VARCHAR2(32000);

Line 134: l_success_file_handle UTL_FILE.FILE_TYPE;

130: level_table_col_name like '%PK_KEY%';
131: i*/
132: l_time_columns VARCHAR2(2000);
133: l_err_file_handle UTL_FILE.FILE_TYPE;
134: l_success_file_handle UTL_FILE.FILE_TYPE;
135: l_error_text VARCHAR2(32000);
136: l_success_text VARCHAR2(32000);
137: l_dimshortname VARCHAR2(32000);
138: l_success_file VARCHAR2(32000) := 'DIMLEVELSUCCESS.log';

Line 342: utl_file.fclose(l_success_file_handle);

338: l_success_text := l_lvlshortname || ' ' || FND_MESSAGE.GET;
339: WRITE_TO_FILE(l_success_text , l_success_file_handle);
340: END IF;
341: END LOOP;
342: utl_file.fclose(l_success_file_handle);
343: utl_file.fclose(l_err_file_handle);
344: /*
345: EXCEPTION
346: WHEN OTHERS THEN

Line 343: utl_file.fclose(l_err_file_handle);

339: WRITE_TO_FILE(l_success_text , l_success_file_handle);
340: END IF;
341: END LOOP;
342: utl_file.fclose(l_success_file_handle);
343: utl_file.fclose(l_err_file_handle);
344: /*
345: EXCEPTION
346: WHEN OTHERS THEN
347: utl_file.fclose(l_err_file_handle);

Line 347: utl_file.fclose(l_err_file_handle);

343: utl_file.fclose(l_err_file_handle);
344: /*
345: EXCEPTION
346: WHEN OTHERS THEN
347: utl_file.fclose(l_err_file_handle);
348: utl_file.fclose(l_success_file_handle);
349: */
350: END;
351:

Line 348: utl_file.fclose(l_success_file_handle);

344: /*
345: EXCEPTION
346: WHEN OTHERS THEN
347: utl_file.fclose(l_err_file_handle);
348: utl_file.fclose(l_success_file_handle);
349: */
350: END;
351:
352: END BIS_DIMLEVEL_ERRS_PVT;