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.FND_OAM_KBF dependencies on FND_LOG_UNIQUE_EXCEPTIONS

Line 13: -- acknowledged states by querying the fnd_log_unique_exceptions table

9: -- get_sysalcnt
10: --
11: -- Purpose
12: -- Returns the count of System Alerts across various severities and
13: -- acknowledged states by querying the fnd_log_unique_exceptions table
14: --
15: -- Input Arguments
16: -- p_category - category for which to return the counts. Null by
17: -- by default.

Line 44: select count(*) into critical_n from fnd_log_unique_exceptions where

40: IS
41:
42: BEGIN
43: if p_category is null then
44: select count(*) into critical_n from fnd_log_unique_exceptions where
45: severity='CRITICAL' and status='N';
46: select count(*) into error_n from fnd_log_unique_exceptions where
47: severity='ERROR' and status='N';
48: select count(*) into warning_n from fnd_log_unique_exceptions where

Line 46: select count(*) into error_n from fnd_log_unique_exceptions where

42: BEGIN
43: if p_category is null then
44: select count(*) into critical_n from fnd_log_unique_exceptions where
45: severity='CRITICAL' and status='N';
46: select count(*) into error_n from fnd_log_unique_exceptions where
47: severity='ERROR' and status='N';
48: select count(*) into warning_n from fnd_log_unique_exceptions where
49: severity='WARNING' and status='N';
50: select count(*) into critical_o from fnd_log_unique_exceptions where

Line 48: select count(*) into warning_n from fnd_log_unique_exceptions where

44: select count(*) into critical_n from fnd_log_unique_exceptions where
45: severity='CRITICAL' and status='N';
46: select count(*) into error_n from fnd_log_unique_exceptions where
47: severity='ERROR' and status='N';
48: select count(*) into warning_n from fnd_log_unique_exceptions where
49: severity='WARNING' and status='N';
50: select count(*) into critical_o from fnd_log_unique_exceptions where
51: severity='CRITICAL' and status='O';
52: select count(*) into error_o from fnd_log_unique_exceptions where

Line 50: select count(*) into critical_o from fnd_log_unique_exceptions where

46: select count(*) into error_n from fnd_log_unique_exceptions where
47: severity='ERROR' and status='N';
48: select count(*) into warning_n from fnd_log_unique_exceptions where
49: severity='WARNING' and status='N';
50: select count(*) into critical_o from fnd_log_unique_exceptions where
51: severity='CRITICAL' and status='O';
52: select count(*) into error_o from fnd_log_unique_exceptions where
53: severity='ERROR' and status='O';
54: select count(*) into warning_o from fnd_log_unique_exceptions where

Line 52: select count(*) into error_o from fnd_log_unique_exceptions where

48: select count(*) into warning_n from fnd_log_unique_exceptions where
49: severity='WARNING' and status='N';
50: select count(*) into critical_o from fnd_log_unique_exceptions where
51: severity='CRITICAL' and status='O';
52: select count(*) into error_o from fnd_log_unique_exceptions where
53: severity='ERROR' and status='O';
54: select count(*) into warning_o from fnd_log_unique_exceptions where
55: severity='WARNING' and status='O';
56: /*

Line 54: select count(*) into warning_o from fnd_log_unique_exceptions where

50: select count(*) into critical_o from fnd_log_unique_exceptions where
51: severity='CRITICAL' and status='O';
52: select count(*) into error_o from fnd_log_unique_exceptions where
53: severity='ERROR' and status='O';
54: select count(*) into warning_o from fnd_log_unique_exceptions where
55: severity='WARNING' and status='O';
56: /*
57: select count(*) into critical_c from fnd_log_unique_exceptions where
58: severity='CRITICAL' and status='C';

Line 57: select count(*) into critical_c from fnd_log_unique_exceptions where

53: severity='ERROR' and status='O';
54: select count(*) into warning_o from fnd_log_unique_exceptions where
55: severity='WARNING' and status='O';
56: /*
57: select count(*) into critical_c from fnd_log_unique_exceptions where
58: severity='CRITICAL' and status='C';
59: select count(*) into error_c from fnd_log_unique_exceptions where
60: severity='ERROR' and status='C';
61: select count(*) into warning_c from fnd_log_unique_exceptions where

Line 59: select count(*) into error_c from fnd_log_unique_exceptions where

55: severity='WARNING' and status='O';
56: /*
57: select count(*) into critical_c from fnd_log_unique_exceptions where
58: severity='CRITICAL' and status='C';
59: select count(*) into error_c from fnd_log_unique_exceptions where
60: severity='ERROR' and status='C';
61: select count(*) into warning_c from fnd_log_unique_exceptions where
62: severity='WARNING' and status='C';
63: */

Line 61: select count(*) into warning_c from fnd_log_unique_exceptions where

57: select count(*) into critical_c from fnd_log_unique_exceptions where
58: severity='CRITICAL' and status='C';
59: select count(*) into error_c from fnd_log_unique_exceptions where
60: severity='ERROR' and status='C';
61: select count(*) into warning_c from fnd_log_unique_exceptions where
62: severity='WARNING' and status='C';
63: */
64: else
65: select count(*) into critical_n from fnd_log_unique_exceptions where

Line 65: select count(*) into critical_n from fnd_log_unique_exceptions where

61: select count(*) into warning_c from fnd_log_unique_exceptions where
62: severity='WARNING' and status='C';
63: */
64: else
65: select count(*) into critical_n from fnd_log_unique_exceptions where
66: severity='CRITICAL' and status='N' and category=p_category;
67: select count(*) into error_n from fnd_log_unique_exceptions where
68: severity='ERROR' and status='N' and category=p_category;
69: select count(*) into warning_n from fnd_log_unique_exceptions where

Line 67: select count(*) into error_n from fnd_log_unique_exceptions where

63: */
64: else
65: select count(*) into critical_n from fnd_log_unique_exceptions where
66: severity='CRITICAL' and status='N' and category=p_category;
67: select count(*) into error_n from fnd_log_unique_exceptions where
68: severity='ERROR' and status='N' and category=p_category;
69: select count(*) into warning_n from fnd_log_unique_exceptions where
70: severity='WARNING' and status='N' and category=p_category;
71: select count(*) into critical_o from fnd_log_unique_exceptions where

Line 69: select count(*) into warning_n from fnd_log_unique_exceptions where

65: select count(*) into critical_n from fnd_log_unique_exceptions where
66: severity='CRITICAL' and status='N' and category=p_category;
67: select count(*) into error_n from fnd_log_unique_exceptions where
68: severity='ERROR' and status='N' and category=p_category;
69: select count(*) into warning_n from fnd_log_unique_exceptions where
70: severity='WARNING' and status='N' and category=p_category;
71: select count(*) into critical_o from fnd_log_unique_exceptions where
72: severity='CRITICAL' and status='O' and category=p_category;
73: select count(*) into error_o from fnd_log_unique_exceptions where

Line 71: select count(*) into critical_o from fnd_log_unique_exceptions where

67: select count(*) into error_n from fnd_log_unique_exceptions where
68: severity='ERROR' and status='N' and category=p_category;
69: select count(*) into warning_n from fnd_log_unique_exceptions where
70: severity='WARNING' and status='N' and category=p_category;
71: select count(*) into critical_o from fnd_log_unique_exceptions where
72: severity='CRITICAL' and status='O' and category=p_category;
73: select count(*) into error_o from fnd_log_unique_exceptions where
74: severity='ERROR' and status='O' and category=p_category;
75: select count(*) into warning_o from fnd_log_unique_exceptions where

Line 73: select count(*) into error_o from fnd_log_unique_exceptions where

69: select count(*) into warning_n from fnd_log_unique_exceptions where
70: severity='WARNING' and status='N' and category=p_category;
71: select count(*) into critical_o from fnd_log_unique_exceptions where
72: severity='CRITICAL' and status='O' and category=p_category;
73: select count(*) into error_o from fnd_log_unique_exceptions where
74: severity='ERROR' and status='O' and category=p_category;
75: select count(*) into warning_o from fnd_log_unique_exceptions where
76: severity='WARNING' and status='O' and category=p_category;
77: /*

Line 75: select count(*) into warning_o from fnd_log_unique_exceptions where

71: select count(*) into critical_o from fnd_log_unique_exceptions where
72: severity='CRITICAL' and status='O' and category=p_category;
73: select count(*) into error_o from fnd_log_unique_exceptions where
74: severity='ERROR' and status='O' and category=p_category;
75: select count(*) into warning_o from fnd_log_unique_exceptions where
76: severity='WARNING' and status='O' and category=p_category;
77: /*
78: select count(*) into critical_c from fnd_log_unique_exceptions where
79: severity='CRITICAL' and status='C' and category=p_category;

Line 78: select count(*) into critical_c from fnd_log_unique_exceptions where

74: severity='ERROR' and status='O' and category=p_category;
75: select count(*) into warning_o from fnd_log_unique_exceptions where
76: severity='WARNING' and status='O' and category=p_category;
77: /*
78: select count(*) into critical_c from fnd_log_unique_exceptions where
79: severity='CRITICAL' and status='C' and category=p_category;
80: select count(*) into error_c from fnd_log_unique_exceptions where
81: severity='ERROR' and status='C' and category=p_category;
82: select count(*) into warning_c from fnd_log_unique_exceptions where

Line 80: select count(*) into error_c from fnd_log_unique_exceptions where

76: severity='WARNING' and status='O' and category=p_category;
77: /*
78: select count(*) into critical_c from fnd_log_unique_exceptions where
79: severity='CRITICAL' and status='C' and category=p_category;
80: select count(*) into error_c from fnd_log_unique_exceptions where
81: severity='ERROR' and status='C' and category=p_category;
82: select count(*) into warning_c from fnd_log_unique_exceptions where
83: severity='WARNING' and status='C' and category=p_category;
84: */

Line 82: select count(*) into warning_c from fnd_log_unique_exceptions where

78: select count(*) into critical_c from fnd_log_unique_exceptions where
79: severity='CRITICAL' and status='C' and category=p_category;
80: select count(*) into error_c from fnd_log_unique_exceptions where
81: severity='ERROR' and status='C' and category=p_category;
82: select count(*) into warning_c from fnd_log_unique_exceptions where
83: severity='WARNING' and status='C' and category=p_category;
84: */
85: end if;
86: END get_sysal_cnt;

Line 131: from fnd_log_unique_exceptions flue

127: -- count columns instead of joining with fnd_log_exceptions for
128: -- bug 4653173
129: if p_category is null then
130: select sum(count) into critical_n
131: from fnd_log_unique_exceptions flue
132: where flue.severity = 'CRITICAL' and flue.status='N';
133: select sum(count) into error_n
134: from fnd_log_unique_exceptions flue
135: where flue.severity = 'ERROR' and flue.status='N';

Line 134: from fnd_log_unique_exceptions flue

130: select sum(count) into critical_n
131: from fnd_log_unique_exceptions flue
132: where flue.severity = 'CRITICAL' and flue.status='N';
133: select sum(count) into error_n
134: from fnd_log_unique_exceptions flue
135: where flue.severity = 'ERROR' and flue.status='N';
136: select sum(count) into warning_n
137: from fnd_log_unique_exceptions flue
138: where flue.severity = 'WARNING' and flue.status='N';

Line 137: from fnd_log_unique_exceptions flue

133: select sum(count) into error_n
134: from fnd_log_unique_exceptions flue
135: where flue.severity = 'ERROR' and flue.status='N';
136: select sum(count) into warning_n
137: from fnd_log_unique_exceptions flue
138: where flue.severity = 'WARNING' and flue.status='N';
139: select sum(count) into critical_o
140: from fnd_log_unique_exceptions flue
141: where flue.severity = 'CRITICAL' and flue.status='O';

Line 140: from fnd_log_unique_exceptions flue

136: select sum(count) into warning_n
137: from fnd_log_unique_exceptions flue
138: where flue.severity = 'WARNING' and flue.status='N';
139: select sum(count) into critical_o
140: from fnd_log_unique_exceptions flue
141: where flue.severity = 'CRITICAL' and flue.status='O';
142: select sum(count) into error_o
143: from fnd_log_unique_exceptions flue
144: where flue.severity = 'ERROR' and flue.status='O';

Line 143: from fnd_log_unique_exceptions flue

139: select sum(count) into critical_o
140: from fnd_log_unique_exceptions flue
141: where flue.severity = 'CRITICAL' and flue.status='O';
142: select sum(count) into error_o
143: from fnd_log_unique_exceptions flue
144: where flue.severity = 'ERROR' and flue.status='O';
145: select sum(count) into warning_o
146: from fnd_log_unique_exceptions flue
147: where flue.severity = 'WARNING' and flue.status='O';

Line 146: from fnd_log_unique_exceptions flue

142: select sum(count) into error_o
143: from fnd_log_unique_exceptions flue
144: where flue.severity = 'ERROR' and flue.status='O';
145: select sum(count) into warning_o
146: from fnd_log_unique_exceptions flue
147: where flue.severity = 'WARNING' and flue.status='O';
148: /*
149: select sum(count) into critical_c
150: from fnd_log_unique_exceptions flue

Line 150: from fnd_log_unique_exceptions flue

146: from fnd_log_unique_exceptions flue
147: where flue.severity = 'WARNING' and flue.status='O';
148: /*
149: select sum(count) into critical_c
150: from fnd_log_unique_exceptions flue
151: where flue.severity = 'CRITICAL' and flue.status='C';
152: select sum(count) into error_c
153: from fnd_log_unique_exceptions flue
154: where flue.severity = 'ERROR' and flue.status='C';

Line 153: from fnd_log_unique_exceptions flue

149: select sum(count) into critical_c
150: from fnd_log_unique_exceptions flue
151: where flue.severity = 'CRITICAL' and flue.status='C';
152: select sum(count) into error_c
153: from fnd_log_unique_exceptions flue
154: where flue.severity = 'ERROR' and flue.status='C';
155: select sum(count) into warning_c
156: from fnd_log_unique_exceptions flue
157: where flue.severity = 'WARNING' and flue.status='C';

Line 156: from fnd_log_unique_exceptions flue

152: select sum(count) into error_c
153: from fnd_log_unique_exceptions flue
154: where flue.severity = 'ERROR' and flue.status='C';
155: select sum(count) into warning_c
156: from fnd_log_unique_exceptions flue
157: where flue.severity = 'WARNING' and flue.status='C';
158: */
159: else
160: select sum(count) into critical_n

Line 161: from fnd_log_unique_exceptions flue

157: where flue.severity = 'WARNING' and flue.status='C';
158: */
159: else
160: select sum(count) into critical_n
161: from fnd_log_unique_exceptions flue
162: where flue.severity = 'CRITICAL' and flue.status='N'
163: and flue.category = p_category;
164: select sum(count) into error_n
165: from fnd_log_unique_exceptions flue

Line 165: from fnd_log_unique_exceptions flue

161: from fnd_log_unique_exceptions flue
162: where flue.severity = 'CRITICAL' and flue.status='N'
163: and flue.category = p_category;
164: select sum(count) into error_n
165: from fnd_log_unique_exceptions flue
166: where flue.severity = 'ERROR' and flue.status='N'
167: and flue.category = p_category;
168: select sum(count) into warning_n
169: from fnd_log_unique_exceptions flue

Line 169: from fnd_log_unique_exceptions flue

165: from fnd_log_unique_exceptions flue
166: where flue.severity = 'ERROR' and flue.status='N'
167: and flue.category = p_category;
168: select sum(count) into warning_n
169: from fnd_log_unique_exceptions flue
170: where flue.severity = 'WARNING' and flue.status='N'
171: and flue.category = p_category;
172: select sum(count) into critical_o
173: from fnd_log_unique_exceptions flue

Line 173: from fnd_log_unique_exceptions flue

169: from fnd_log_unique_exceptions flue
170: where flue.severity = 'WARNING' and flue.status='N'
171: and flue.category = p_category;
172: select sum(count) into critical_o
173: from fnd_log_unique_exceptions flue
174: where flue.severity = 'CRITICAL' and flue.status='O'
175: and flue.category = p_category;
176: select sum(count) into error_o
177: from fnd_log_unique_exceptions flue

Line 177: from fnd_log_unique_exceptions flue

173: from fnd_log_unique_exceptions flue
174: where flue.severity = 'CRITICAL' and flue.status='O'
175: and flue.category = p_category;
176: select sum(count) into error_o
177: from fnd_log_unique_exceptions flue
178: where flue.severity = 'ERROR' and flue.status='O'
179: and flue.category = p_category;
180: select sum(count) into warning_o
181: from fnd_log_unique_exceptions flue

Line 181: from fnd_log_unique_exceptions flue

177: from fnd_log_unique_exceptions flue
178: where flue.severity = 'ERROR' and flue.status='O'
179: and flue.category = p_category;
180: select sum(count) into warning_o
181: from fnd_log_unique_exceptions flue
182: where flue.severity = 'WARNING' and flue.status='O'
183: and flue.category = p_category;
184: /*
185: select sum(count) into critical_c

Line 186: from fnd_log_unique_exceptions flue

182: where flue.severity = 'WARNING' and flue.status='O'
183: and flue.category = p_category;
184: /*
185: select sum(count) into critical_c
186: from fnd_log_unique_exceptions flue
187: where flue.severity = 'CRITICAL' and flue.status='C'
188: and flue.category = p_category;
189: select sum(count) into error_c
190: from fnd_log_unique_exceptions flue

Line 190: from fnd_log_unique_exceptions flue

186: from fnd_log_unique_exceptions flue
187: where flue.severity = 'CRITICAL' and flue.status='C'
188: and flue.category = p_category;
189: select sum(count) into error_c
190: from fnd_log_unique_exceptions flue
191: where flue.severity = 'ERROR' and flue.status='C'
192: and flue.category = p_category;
193: select sum(count) into warning_c
194: from fnd_log_unique_exceptions flue

Line 194: from fnd_log_unique_exceptions flue

190: from fnd_log_unique_exceptions flue
191: where flue.severity = 'ERROR' and flue.status='C'
192: and flue.category = p_category;
193: select sum(count) into warning_c
194: from fnd_log_unique_exceptions flue
195: where flue.severity = 'WARNING' and flue.status='C'
196: and flue.category = p_category;
197: */
198: end if;

Line 279: update fnd_log_unique_exceptions

275: v_curr_id := substr(v_idset, v_curr_index,
276: instr(v_idset, delim, v_curr_index) - v_curr_index);
277:
278: -- Update the status
279: update fnd_log_unique_exceptions
280: set status = p_newstate,
281: last_updated_by = v_userid,
282: last_update_date = sysdate
283: where unique_exception_id = to_number(v_curr_id);