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

Line 29: h_log_file_handle UTL_FILE.FILE_TYPE;

25: e_unexpected_error EXCEPTION;
26: e_no_log_file_dir EXCEPTION;
27:
28: h_log_file_dir VARCHAR2(60);
29: h_log_file_handle UTL_FILE.FILE_TYPE;
30:
31: TYPE t_cursor IS REF CURSOR;
32:
33: c_utl_file_dir t_cursor; -- h_utlfiledir

Line 33: c_utl_file_dir t_cursor; -- h_utlfiledir

29: h_log_file_handle UTL_FILE.FILE_TYPE;
30:
31: TYPE t_cursor IS REF CURSOR;
32:
33: c_utl_file_dir t_cursor; -- h_utlfiledir
34: c_utl_file_dir_sql VARCHAR2(2000) := 'SELECT VP.value'||
35: ' FROM v$parameter VP'||
36: ' WHERE UPPER(VP.name) = :1';
37:

Line 34: c_utl_file_dir_sql VARCHAR2(2000) := 'SELECT VP.value'||

30:
31: TYPE t_cursor IS REF CURSOR;
32:
33: c_utl_file_dir t_cursor; -- h_utlfiledir
34: c_utl_file_dir_sql VARCHAR2(2000) := 'SELECT VP.value'||
35: ' FROM v$parameter VP'||
36: ' WHERE UPPER(VP.name) = :1';
37:
38: h_utlfiledir VARCHAR2(30) := 'UTL_FILE_DIR';

Line 38: h_utlfiledir VARCHAR2(30) := 'UTL_FILE_DIR';

34: c_utl_file_dir_sql VARCHAR2(2000) := 'SELECT VP.value'||
35: ' FROM v$parameter VP'||
36: ' WHERE UPPER(VP.name) = :1';
37:
38: h_utlfiledir VARCHAR2(30) := 'UTL_FILE_DIR';
39: h_utl_file_dir VARCHAR2(2000);
40:
41: BEGIN
42: OPEN c_utl_file_dir FOR c_utl_file_dir_sql USING h_utlfiledir;

Line 39: h_utl_file_dir VARCHAR2(2000);

35: ' FROM v$parameter VP'||
36: ' WHERE UPPER(VP.name) = :1';
37:
38: h_utlfiledir VARCHAR2(30) := 'UTL_FILE_DIR';
39: h_utl_file_dir VARCHAR2(2000);
40:
41: BEGIN
42: OPEN c_utl_file_dir FOR c_utl_file_dir_sql USING h_utlfiledir;
43: FETCH c_utl_file_dir INTO h_utl_file_dir;

Line 42: OPEN c_utl_file_dir FOR c_utl_file_dir_sql USING h_utlfiledir;

38: h_utlfiledir VARCHAR2(30) := 'UTL_FILE_DIR';
39: h_utl_file_dir VARCHAR2(2000);
40:
41: BEGIN
42: OPEN c_utl_file_dir FOR c_utl_file_dir_sql USING h_utlfiledir;
43: FETCH c_utl_file_dir INTO h_utl_file_dir;
44: IF c_utl_file_dir%NOTFOUND THEN
45: h_log_file_dir := NULL;
46: ELSE

Line 43: FETCH c_utl_file_dir INTO h_utl_file_dir;

39: h_utl_file_dir VARCHAR2(2000);
40:
41: BEGIN
42: OPEN c_utl_file_dir FOR c_utl_file_dir_sql USING h_utlfiledir;
43: FETCH c_utl_file_dir INTO h_utl_file_dir;
44: IF c_utl_file_dir%NOTFOUND THEN
45: h_log_file_dir := NULL;
46: ELSE
47: IF h_utl_file_dir IS NULL THEN

Line 44: IF c_utl_file_dir%NOTFOUND THEN

40:
41: BEGIN
42: OPEN c_utl_file_dir FOR c_utl_file_dir_sql USING h_utlfiledir;
43: FETCH c_utl_file_dir INTO h_utl_file_dir;
44: IF c_utl_file_dir%NOTFOUND THEN
45: h_log_file_dir := NULL;
46: ELSE
47: IF h_utl_file_dir IS NULL THEN
48: h_log_file_dir := NULL;

Line 47: IF h_utl_file_dir IS NULL THEN

43: FETCH c_utl_file_dir INTO h_utl_file_dir;
44: IF c_utl_file_dir%NOTFOUND THEN
45: h_log_file_dir := NULL;
46: ELSE
47: IF h_utl_file_dir IS NULL THEN
48: h_log_file_dir := NULL;
49: ELSE
50: IF INSTR(h_utl_file_dir, ',') > 0 THEN
51: h_log_file_dir := SUBSTR(h_utl_file_dir, 1, INSTR(h_utl_file_dir, ',') - 1);

Line 50: IF INSTR(h_utl_file_dir, ',') > 0 THEN

46: ELSE
47: IF h_utl_file_dir IS NULL THEN
48: h_log_file_dir := NULL;
49: ELSE
50: IF INSTR(h_utl_file_dir, ',') > 0 THEN
51: h_log_file_dir := SUBSTR(h_utl_file_dir, 1, INSTR(h_utl_file_dir, ',') - 1);
52: ELSE
53: h_log_file_dir := h_utl_file_dir;
54: END IF;

Line 51: h_log_file_dir := SUBSTR(h_utl_file_dir, 1, INSTR(h_utl_file_dir, ',') - 1);

47: IF h_utl_file_dir IS NULL THEN
48: h_log_file_dir := NULL;
49: ELSE
50: IF INSTR(h_utl_file_dir, ',') > 0 THEN
51: h_log_file_dir := SUBSTR(h_utl_file_dir, 1, INSTR(h_utl_file_dir, ',') - 1);
52: ELSE
53: h_log_file_dir := h_utl_file_dir;
54: END IF;
55: END IF;

Line 53: h_log_file_dir := h_utl_file_dir;

49: ELSE
50: IF INSTR(h_utl_file_dir, ',') > 0 THEN
51: h_log_file_dir := SUBSTR(h_utl_file_dir, 1, INSTR(h_utl_file_dir, ',') - 1);
52: ELSE
53: h_log_file_dir := h_utl_file_dir;
54: END IF;
55: END IF;
56: END IF;
57: CLOSE c_utl_file_dir;

Line 57: CLOSE c_utl_file_dir;

53: h_log_file_dir := h_utl_file_dir;
54: END IF;
55: END IF;
56: END IF;
57: CLOSE c_utl_file_dir;
58:
59: IF h_log_file_dir IS NULL THEN
60: RAISE e_no_log_file_dir;
61: END IF;

Line 63: h_log_file_handle := UTL_FILE.FOPEN(h_log_file_dir, x_log_file_name, 'w');

59: IF h_log_file_dir IS NULL THEN
60: RAISE e_no_log_file_dir;
61: END IF;
62:
63: h_log_file_handle := UTL_FILE.FOPEN(h_log_file_dir, x_log_file_name, 'w');
64: UTL_FILE.PUT_LINE(h_log_file_handle, '+---------------------------------------------------------------------------+');
65: UTL_FILE.PUT_LINE(h_log_file_handle,'Oracle Balanced Scorecard: Version : '||c_version);
66: UTL_FILE.PUT_LINE(h_log_file_handle, '');
67: UTL_FILE.PUT_LINE(h_log_file_handle, 'Copyright (c) Oracle Corporation 1999. All rights reserved.');

Line 64: UTL_FILE.PUT_LINE(h_log_file_handle, '+---------------------------------------------------------------------------+');

60: RAISE e_no_log_file_dir;
61: END IF;
62:
63: h_log_file_handle := UTL_FILE.FOPEN(h_log_file_dir, x_log_file_name, 'w');
64: UTL_FILE.PUT_LINE(h_log_file_handle, '+---------------------------------------------------------------------------+');
65: UTL_FILE.PUT_LINE(h_log_file_handle,'Oracle Balanced Scorecard: Version : '||c_version);
66: UTL_FILE.PUT_LINE(h_log_file_handle, '');
67: UTL_FILE.PUT_LINE(h_log_file_handle, 'Copyright (c) Oracle Corporation 1999. All rights reserved.');
68: UTL_FILE.PUT_LINE(h_log_file_handle, '');

Line 65: UTL_FILE.PUT_LINE(h_log_file_handle,'Oracle Balanced Scorecard: Version : '||c_version);

61: END IF;
62:
63: h_log_file_handle := UTL_FILE.FOPEN(h_log_file_dir, x_log_file_name, 'w');
64: UTL_FILE.PUT_LINE(h_log_file_handle, '+---------------------------------------------------------------------------+');
65: UTL_FILE.PUT_LINE(h_log_file_handle,'Oracle Balanced Scorecard: Version : '||c_version);
66: UTL_FILE.PUT_LINE(h_log_file_handle, '');
67: UTL_FILE.PUT_LINE(h_log_file_handle, 'Copyright (c) Oracle Corporation 1999. All rights reserved.');
68: UTL_FILE.PUT_LINE(h_log_file_handle, '');
69: UTL_FILE.PUT_LINE(h_log_file_handle, 'Module: BSC Loader');

Line 66: UTL_FILE.PUT_LINE(h_log_file_handle, '');

62:
63: h_log_file_handle := UTL_FILE.FOPEN(h_log_file_dir, x_log_file_name, 'w');
64: UTL_FILE.PUT_LINE(h_log_file_handle, '+---------------------------------------------------------------------------+');
65: UTL_FILE.PUT_LINE(h_log_file_handle,'Oracle Balanced Scorecard: Version : '||c_version);
66: UTL_FILE.PUT_LINE(h_log_file_handle, '');
67: UTL_FILE.PUT_LINE(h_log_file_handle, 'Copyright (c) Oracle Corporation 1999. All rights reserved.');
68: UTL_FILE.PUT_LINE(h_log_file_handle, '');
69: UTL_FILE.PUT_LINE(h_log_file_handle, 'Module: BSC Loader');
70: UTL_FILE.PUT_LINE(h_log_file_handle, '+---------------------------------------------------------------------------+');

Line 67: UTL_FILE.PUT_LINE(h_log_file_handle, 'Copyright (c) Oracle Corporation 1999. All rights reserved.');

63: h_log_file_handle := UTL_FILE.FOPEN(h_log_file_dir, x_log_file_name, 'w');
64: UTL_FILE.PUT_LINE(h_log_file_handle, '+---------------------------------------------------------------------------+');
65: UTL_FILE.PUT_LINE(h_log_file_handle,'Oracle Balanced Scorecard: Version : '||c_version);
66: UTL_FILE.PUT_LINE(h_log_file_handle, '');
67: UTL_FILE.PUT_LINE(h_log_file_handle, 'Copyright (c) Oracle Corporation 1999. All rights reserved.');
68: UTL_FILE.PUT_LINE(h_log_file_handle, '');
69: UTL_FILE.PUT_LINE(h_log_file_handle, 'Module: BSC Loader');
70: UTL_FILE.PUT_LINE(h_log_file_handle, '+---------------------------------------------------------------------------+');
71: UTL_FILE.PUT_LINE(h_log_file_handle, 'Time: '||TO_CHAR(SYSDATE, c_fto_long_date_time));

Line 68: UTL_FILE.PUT_LINE(h_log_file_handle, '');

64: UTL_FILE.PUT_LINE(h_log_file_handle, '+---------------------------------------------------------------------------+');
65: UTL_FILE.PUT_LINE(h_log_file_handle,'Oracle Balanced Scorecard: Version : '||c_version);
66: UTL_FILE.PUT_LINE(h_log_file_handle, '');
67: UTL_FILE.PUT_LINE(h_log_file_handle, 'Copyright (c) Oracle Corporation 1999. All rights reserved.');
68: UTL_FILE.PUT_LINE(h_log_file_handle, '');
69: UTL_FILE.PUT_LINE(h_log_file_handle, 'Module: BSC Loader');
70: UTL_FILE.PUT_LINE(h_log_file_handle, '+---------------------------------------------------------------------------+');
71: UTL_FILE.PUT_LINE(h_log_file_handle, 'Time: '||TO_CHAR(SYSDATE, c_fto_long_date_time));
72: UTL_FILE.FCLOSE(h_log_file_handle);

Line 69: UTL_FILE.PUT_LINE(h_log_file_handle, 'Module: BSC Loader');

65: UTL_FILE.PUT_LINE(h_log_file_handle,'Oracle Balanced Scorecard: Version : '||c_version);
66: UTL_FILE.PUT_LINE(h_log_file_handle, '');
67: UTL_FILE.PUT_LINE(h_log_file_handle, 'Copyright (c) Oracle Corporation 1999. All rights reserved.');
68: UTL_FILE.PUT_LINE(h_log_file_handle, '');
69: UTL_FILE.PUT_LINE(h_log_file_handle, 'Module: BSC Loader');
70: UTL_FILE.PUT_LINE(h_log_file_handle, '+---------------------------------------------------------------------------+');
71: UTL_FILE.PUT_LINE(h_log_file_handle, 'Time: '||TO_CHAR(SYSDATE, c_fto_long_date_time));
72: UTL_FILE.FCLOSE(h_log_file_handle);
73:

Line 70: UTL_FILE.PUT_LINE(h_log_file_handle, '+---------------------------------------------------------------------------+');

66: UTL_FILE.PUT_LINE(h_log_file_handle, '');
67: UTL_FILE.PUT_LINE(h_log_file_handle, 'Copyright (c) Oracle Corporation 1999. All rights reserved.');
68: UTL_FILE.PUT_LINE(h_log_file_handle, '');
69: UTL_FILE.PUT_LINE(h_log_file_handle, 'Module: BSC Loader');
70: UTL_FILE.PUT_LINE(h_log_file_handle, '+---------------------------------------------------------------------------+');
71: UTL_FILE.PUT_LINE(h_log_file_handle, 'Time: '||TO_CHAR(SYSDATE, c_fto_long_date_time));
72: UTL_FILE.FCLOSE(h_log_file_handle);
73:
74: g_log_file_name := x_log_file_name;

Line 71: UTL_FILE.PUT_LINE(h_log_file_handle, 'Time: '||TO_CHAR(SYSDATE, c_fto_long_date_time));

67: UTL_FILE.PUT_LINE(h_log_file_handle, 'Copyright (c) Oracle Corporation 1999. All rights reserved.');
68: UTL_FILE.PUT_LINE(h_log_file_handle, '');
69: UTL_FILE.PUT_LINE(h_log_file_handle, 'Module: BSC Loader');
70: UTL_FILE.PUT_LINE(h_log_file_handle, '+---------------------------------------------------------------------------+');
71: UTL_FILE.PUT_LINE(h_log_file_handle, 'Time: '||TO_CHAR(SYSDATE, c_fto_long_date_time));
72: UTL_FILE.FCLOSE(h_log_file_handle);
73:
74: g_log_file_name := x_log_file_name;
75: g_log_file_dir := h_log_file_dir;

Line 72: UTL_FILE.FCLOSE(h_log_file_handle);

68: UTL_FILE.PUT_LINE(h_log_file_handle, '');
69: UTL_FILE.PUT_LINE(h_log_file_handle, 'Module: BSC Loader');
70: UTL_FILE.PUT_LINE(h_log_file_handle, '+---------------------------------------------------------------------------+');
71: UTL_FILE.PUT_LINE(h_log_file_handle, 'Time: '||TO_CHAR(SYSDATE, c_fto_long_date_time));
72: UTL_FILE.FCLOSE(h_log_file_handle);
73:
74: g_log_file_name := x_log_file_name;
75: g_log_file_dir := h_log_file_dir;
76:

Line 90: WHEN UTL_FILE.INVALID_PATH THEN

86: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_LOGFILE_DIR_NOT_SPECIFIED'),
87: x_source => 'BSC_UPDATE_LOG.Init_Log_File');
88: RETURN FALSE;
89:
90: WHEN UTL_FILE.INVALID_PATH THEN
91: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_LOGFILE_PATH_FAILED'),
92: x_source => 'BSC_UPDATE_LOG.Init_Log_File');
93: RETURN FALSE;
94:

Line 95: WHEN UTL_FILE.INVALID_MODE THEN

91: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_LOGFILE_PATH_FAILED'),
92: x_source => 'BSC_UPDATE_LOG.Init_Log_File');
93: RETURN FALSE;
94:
95: WHEN UTL_FILE.INVALID_MODE THEN
96: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_LOGFILE_MODE_FAILED'),
97: x_source => 'BSC_UPDATE_LOG.Init_Log_File');
98: RETURN FALSE;
99:

Line 100: WHEN UTL_FILE.INVALID_OPERATION THEN

96: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_LOGFILE_MODE_FAILED'),
97: x_source => 'BSC_UPDATE_LOG.Init_Log_File');
98: RETURN FALSE;
99:
100: WHEN UTL_FILE.INVALID_OPERATION THEN
101: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_LOGFILE_OPERATION_FAILED'),
102: x_source => 'BSC_UPDATE_LOG.Init_Log_File');
103: RETURN FALSE;
104:

Line 105: WHEN UTL_FILE.INVALID_FILEHANDLE THEN

101: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_LOGFILE_OPERATION_FAILED'),
102: x_source => 'BSC_UPDATE_LOG.Init_Log_File');
103: RETURN FALSE;
104:
105: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
106: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_LOGFILE_HANDLE_FAILED'),
107: x_source => 'BSC_UPDATE_LOG.Init_Log_File');
108: RETURN FALSE;
109:

Line 110: WHEN UTL_FILE.WRITE_ERROR THEN

106: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_LOGFILE_HANDLE_FAILED'),
107: x_source => 'BSC_UPDATE_LOG.Init_Log_File');
108: RETURN FALSE;
109:
110: WHEN UTL_FILE.WRITE_ERROR THEN
111: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_WRITE_LOGFILE_FAILED'),
112: x_source => 'BSC_UPDATE_LOG.Init_Log_File');
113: RETURN FALSE;
114:

Line 151: h_log_file_handle UTL_FILE.FILE_TYPE;

147: x_line IN VARCHAR2,
148: x_which IN NUMBER
149: ) IS
150:
151: h_log_file_handle UTL_FILE.FILE_TYPE;
152: h_which NUMBER;
153:
154: h_line VARCHAR2(32700);
155:

Line 176: h_log_file_handle := UTL_FILE.FOPEN(g_log_file_dir, g_log_file_name, 'a');

172:
173: ELSE
174: -- Personal environment
175: IF g_log_file_name IS NOT NULL THEN
176: h_log_file_handle := UTL_FILE.FOPEN(g_log_file_dir, g_log_file_name, 'a');
177:
178: UTL_FILE.PUT_LINE(h_log_file_handle, h_line);
179: UTL_FILE.FCLOSE(h_log_file_handle);
180: END IF;

Line 178: UTL_FILE.PUT_LINE(h_log_file_handle, h_line);

174: -- Personal environment
175: IF g_log_file_name IS NOT NULL THEN
176: h_log_file_handle := UTL_FILE.FOPEN(g_log_file_dir, g_log_file_name, 'a');
177:
178: UTL_FILE.PUT_LINE(h_log_file_handle, h_line);
179: UTL_FILE.FCLOSE(h_log_file_handle);
180: END IF;
181: END IF;
182:

Line 179: UTL_FILE.FCLOSE(h_log_file_handle);

175: IF g_log_file_name IS NOT NULL THEN
176: h_log_file_handle := UTL_FILE.FOPEN(g_log_file_dir, g_log_file_name, 'a');
177:
178: UTL_FILE.PUT_LINE(h_log_file_handle, h_line);
179: UTL_FILE.FCLOSE(h_log_file_handle);
180: END IF;
181: END IF;
182:
183: END Write_Line_Log;