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_LOG_UTIL dependencies on FND_LOG

Line 1: PACKAGE BODY FND_LOG_UTIL AS

1: PACKAGE BODY FND_LOG_UTIL AS
2: /* $Header: AFUTLBEB.pls 115.9 2004/04/05 23:06:31 rmohan noship $ */
3:
4: C_SUCCESS CONSTANT NUMBER := 0;
5: C_WARNING CONSTANT NUMBER := 1;

Line 103: FND_LOG.WORK_METRICS_EVENT(trCtxId);

99: IS
100: BEGIN
101: fdebug('In:FND_BE_UTIL.METRIC_EVENT_PNDG_MTRCS');
102: IF (IS_TRANSACTION_COMPLETED(trId, trType, sessId, true)= TRUE) THEN
103: FND_LOG.WORK_METRICS_EVENT(trCtxId);
104: END IF;
105: fdebug('Out:FND_BE_UTIL.METRIC_EVENT_PNDG_MTRCS');
106: EXCEPTION
107: WHEN OTHERS THEN

Line 139: FND_LOG_TRANSACTION_CONTEXT fltc,

135: select
136: distinct fltc.SESSION_ID, fltc.TRANSACTION_CONTEXT_ID, fltc.TRANSACTION_TYPE
137: , fltc.TRANSACTION_ID
138: from
139: FND_LOG_TRANSACTION_CONTEXT fltc,
140: FND_LOG_METRICS flm
141: where
142: fltc.TRANSACTION_CONTEXT_ID=flm.TRANSACTION_CONTEXT_ID
143: and flm.EVENT_KEY is null;

Line 140: FND_LOG_METRICS flm

136: distinct fltc.SESSION_ID, fltc.TRANSACTION_CONTEXT_ID, fltc.TRANSACTION_TYPE
137: , fltc.TRANSACTION_ID
138: from
139: FND_LOG_TRANSACTION_CONTEXT fltc,
140: FND_LOG_METRICS flm
141: where
142: fltc.TRANSACTION_CONTEXT_ID=flm.TRANSACTION_CONTEXT_ID
143: and flm.EVENT_KEY is null;
144:

Line 190: delete from FND_LOG_TRANSACTION_CONTEXT where

186: l_rows_start NUMBER;
187: l_rows_end NUMBER;
188: BEGIN
189: --Detelet Transaction Context infor if its relevent infor NA
190: delete from FND_LOG_TRANSACTION_CONTEXT where
191: TRANSACTION_TYPE = 'REQUEST' AND TRANSACTION_ID<>
192: ( SELECT REQUEST_ID from FND_CONCURRENT_REQUESTS where REQUEST_ID=TRANSACTION_ID);
193:
194: --Deletes data for which no transaction context info is available.

Line 196: select count(*) into l_rows_start from FND_LOG_MESSAGES;

192: ( SELECT REQUEST_ID from FND_CONCURRENT_REQUESTS where REQUEST_ID=TRANSACTION_ID);
193:
194: --Deletes data for which no transaction context info is available.
195: ---dbms_output.put_line('IN:SYNC_EXP_DATA');
196: select count(*) into l_rows_start from FND_LOG_MESSAGES;
197: delete from FND_LOG_MESSAGES where
198: TRANSACTION_CONTEXT_ID not in
199: (select distinct TRANSACTION_CONTEXT_ID from
200: FND_LOG_TRANSACTION_CONTEXT)

Line 197: delete from FND_LOG_MESSAGES where

193:
194: --Deletes data for which no transaction context info is available.
195: ---dbms_output.put_line('IN:SYNC_EXP_DATA');
196: select count(*) into l_rows_start from FND_LOG_MESSAGES;
197: delete from FND_LOG_MESSAGES where
198: TRANSACTION_CONTEXT_ID not in
199: (select distinct TRANSACTION_CONTEXT_ID from
200: FND_LOG_TRANSACTION_CONTEXT)
201: ;

Line 200: FND_LOG_TRANSACTION_CONTEXT)

196: select count(*) into l_rows_start from FND_LOG_MESSAGES;
197: delete from FND_LOG_MESSAGES where
198: TRANSACTION_CONTEXT_ID not in
199: (select distinct TRANSACTION_CONTEXT_ID from
200: FND_LOG_TRANSACTION_CONTEXT)
201: ;
202: select count(*) into l_rows_end from FND_LOG_MESSAGES;
203: ---dbms_output.put_line('FND_LOG_MESSAGES:dlt rows out of sync'||(l_rows_end-l_rows_start));
204: commit;

Line 202: select count(*) into l_rows_end from FND_LOG_MESSAGES;

198: TRANSACTION_CONTEXT_ID not in
199: (select distinct TRANSACTION_CONTEXT_ID from
200: FND_LOG_TRANSACTION_CONTEXT)
201: ;
202: select count(*) into l_rows_end from FND_LOG_MESSAGES;
203: ---dbms_output.put_line('FND_LOG_MESSAGES:dlt rows out of sync'||(l_rows_end-l_rows_start));
204: commit;
205:
206: select count(*) into l_rows_start from FND_LOG_METRICS;

Line 203: ---dbms_output.put_line('FND_LOG_MESSAGES:dlt rows out of sync'||(l_rows_end-l_rows_start));

199: (select distinct TRANSACTION_CONTEXT_ID from
200: FND_LOG_TRANSACTION_CONTEXT)
201: ;
202: select count(*) into l_rows_end from FND_LOG_MESSAGES;
203: ---dbms_output.put_line('FND_LOG_MESSAGES:dlt rows out of sync'||(l_rows_end-l_rows_start));
204: commit;
205:
206: select count(*) into l_rows_start from FND_LOG_METRICS;
207: delete from FND_LOG_METRICS where

Line 206: select count(*) into l_rows_start from FND_LOG_METRICS;

202: select count(*) into l_rows_end from FND_LOG_MESSAGES;
203: ---dbms_output.put_line('FND_LOG_MESSAGES:dlt rows out of sync'||(l_rows_end-l_rows_start));
204: commit;
205:
206: select count(*) into l_rows_start from FND_LOG_METRICS;
207: delete from FND_LOG_METRICS where
208: TRANSACTION_CONTEXT_ID not in
209: (select distinct TRANSACTION_CONTEXT_ID from
210: FND_LOG_TRANSACTION_CONTEXT)

Line 207: delete from FND_LOG_METRICS where

203: ---dbms_output.put_line('FND_LOG_MESSAGES:dlt rows out of sync'||(l_rows_end-l_rows_start));
204: commit;
205:
206: select count(*) into l_rows_start from FND_LOG_METRICS;
207: delete from FND_LOG_METRICS where
208: TRANSACTION_CONTEXT_ID not in
209: (select distinct TRANSACTION_CONTEXT_ID from
210: FND_LOG_TRANSACTION_CONTEXT)
211: ;

Line 210: FND_LOG_TRANSACTION_CONTEXT)

206: select count(*) into l_rows_start from FND_LOG_METRICS;
207: delete from FND_LOG_METRICS where
208: TRANSACTION_CONTEXT_ID not in
209: (select distinct TRANSACTION_CONTEXT_ID from
210: FND_LOG_TRANSACTION_CONTEXT)
211: ;
212: select count(*) into l_rows_end from FND_LOG_METRICS;
213: ---dbms_output.put_line('FND_LOG_METRICS:dlt rows out of sync'||(l_rows_end-l_rows_start));
214: commit;

Line 212: select count(*) into l_rows_end from FND_LOG_METRICS;

208: TRANSACTION_CONTEXT_ID not in
209: (select distinct TRANSACTION_CONTEXT_ID from
210: FND_LOG_TRANSACTION_CONTEXT)
211: ;
212: select count(*) into l_rows_end from FND_LOG_METRICS;
213: ---dbms_output.put_line('FND_LOG_METRICS:dlt rows out of sync'||(l_rows_end-l_rows_start));
214: commit;
215:
216: select count(*) into l_rows_start from FND_LOG_EXCEPTIONS;

Line 213: ---dbms_output.put_line('FND_LOG_METRICS:dlt rows out of sync'||(l_rows_end-l_rows_start));

209: (select distinct TRANSACTION_CONTEXT_ID from
210: FND_LOG_TRANSACTION_CONTEXT)
211: ;
212: select count(*) into l_rows_end from FND_LOG_METRICS;
213: ---dbms_output.put_line('FND_LOG_METRICS:dlt rows out of sync'||(l_rows_end-l_rows_start));
214: commit;
215:
216: select count(*) into l_rows_start from FND_LOG_EXCEPTIONS;
217: delete from FND_LOG_EXCEPTIONS where LOG_SEQUENCE not in

Line 216: select count(*) into l_rows_start from FND_LOG_EXCEPTIONS;

212: select count(*) into l_rows_end from FND_LOG_METRICS;
213: ---dbms_output.put_line('FND_LOG_METRICS:dlt rows out of sync'||(l_rows_end-l_rows_start));
214: commit;
215:
216: select count(*) into l_rows_start from FND_LOG_EXCEPTIONS;
217: delete from FND_LOG_EXCEPTIONS where LOG_SEQUENCE not in
218: (select distinct LOG_SEQUENCE from FND_LOG_MESSAGES );
219: select count(*) into l_rows_end from FND_LOG_EXCEPTIONS;
220: ---dbms_output.put_line('FND_LOG_EXCEPTIONS: dlt rows out of sync'||(l_rows_end-l_rows_start));

Line 217: delete from FND_LOG_EXCEPTIONS where LOG_SEQUENCE not in

213: ---dbms_output.put_line('FND_LOG_METRICS:dlt rows out of sync'||(l_rows_end-l_rows_start));
214: commit;
215:
216: select count(*) into l_rows_start from FND_LOG_EXCEPTIONS;
217: delete from FND_LOG_EXCEPTIONS where LOG_SEQUENCE not in
218: (select distinct LOG_SEQUENCE from FND_LOG_MESSAGES );
219: select count(*) into l_rows_end from FND_LOG_EXCEPTIONS;
220: ---dbms_output.put_line('FND_LOG_EXCEPTIONS: dlt rows out of sync'||(l_rows_end-l_rows_start));
221: commit;

Line 218: (select distinct LOG_SEQUENCE from FND_LOG_MESSAGES );

214: commit;
215:
216: select count(*) into l_rows_start from FND_LOG_EXCEPTIONS;
217: delete from FND_LOG_EXCEPTIONS where LOG_SEQUENCE not in
218: (select distinct LOG_SEQUENCE from FND_LOG_MESSAGES );
219: select count(*) into l_rows_end from FND_LOG_EXCEPTIONS;
220: ---dbms_output.put_line('FND_LOG_EXCEPTIONS: dlt rows out of sync'||(l_rows_end-l_rows_start));
221: commit;
222:

Line 219: select count(*) into l_rows_end from FND_LOG_EXCEPTIONS;

215:
216: select count(*) into l_rows_start from FND_LOG_EXCEPTIONS;
217: delete from FND_LOG_EXCEPTIONS where LOG_SEQUENCE not in
218: (select distinct LOG_SEQUENCE from FND_LOG_MESSAGES );
219: select count(*) into l_rows_end from FND_LOG_EXCEPTIONS;
220: ---dbms_output.put_line('FND_LOG_EXCEPTIONS: dlt rows out of sync'||(l_rows_end-l_rows_start));
221: commit;
222:
223:

Line 220: ---dbms_output.put_line('FND_LOG_EXCEPTIONS: dlt rows out of sync'||(l_rows_end-l_rows_start));

216: select count(*) into l_rows_start from FND_LOG_EXCEPTIONS;
217: delete from FND_LOG_EXCEPTIONS where LOG_SEQUENCE not in
218: (select distinct LOG_SEQUENCE from FND_LOG_MESSAGES );
219: select count(*) into l_rows_end from FND_LOG_EXCEPTIONS;
220: ---dbms_output.put_line('FND_LOG_EXCEPTIONS: dlt rows out of sync'||(l_rows_end-l_rows_start));
221: commit;
222:
223:
224: select count(*) into l_rows_start from FND_LOG_UNIQUE_EXCEPTIONS;

Line 224: select count(*) into l_rows_start from FND_LOG_UNIQUE_EXCEPTIONS;

220: ---dbms_output.put_line('FND_LOG_EXCEPTIONS: dlt rows out of sync'||(l_rows_end-l_rows_start));
221: commit;
222:
223:
224: select count(*) into l_rows_start from FND_LOG_UNIQUE_EXCEPTIONS;
225: delete from FND_LOG_UNIQUE_EXCEPTIONS where UNIQUE_EXCEPTION_ID not in
226: (select distinct UNIQUE_EXCEPTION_ID from FND_LOG_EXCEPTIONS );
227: select count(*) into l_rows_end from FND_LOG_UNIQUE_EXCEPTIONS;
228: ---dbms_output.put_line('FND_LOG_UNIQUE_EXCEPTIONS: dlt rows out of sync'||(l_rows_end-l_rows_start));

Line 225: delete from FND_LOG_UNIQUE_EXCEPTIONS where UNIQUE_EXCEPTION_ID not in

221: commit;
222:
223:
224: select count(*) into l_rows_start from FND_LOG_UNIQUE_EXCEPTIONS;
225: delete from FND_LOG_UNIQUE_EXCEPTIONS where UNIQUE_EXCEPTION_ID not in
226: (select distinct UNIQUE_EXCEPTION_ID from FND_LOG_EXCEPTIONS );
227: select count(*) into l_rows_end from FND_LOG_UNIQUE_EXCEPTIONS;
228: ---dbms_output.put_line('FND_LOG_UNIQUE_EXCEPTIONS: dlt rows out of sync'||(l_rows_end-l_rows_start));
229: commit;

Line 226: (select distinct UNIQUE_EXCEPTION_ID from FND_LOG_EXCEPTIONS );

222:
223:
224: select count(*) into l_rows_start from FND_LOG_UNIQUE_EXCEPTIONS;
225: delete from FND_LOG_UNIQUE_EXCEPTIONS where UNIQUE_EXCEPTION_ID not in
226: (select distinct UNIQUE_EXCEPTION_ID from FND_LOG_EXCEPTIONS );
227: select count(*) into l_rows_end from FND_LOG_UNIQUE_EXCEPTIONS;
228: ---dbms_output.put_line('FND_LOG_UNIQUE_EXCEPTIONS: dlt rows out of sync'||(l_rows_end-l_rows_start));
229: commit;
230:

Line 227: select count(*) into l_rows_end from FND_LOG_UNIQUE_EXCEPTIONS;

223:
224: select count(*) into l_rows_start from FND_LOG_UNIQUE_EXCEPTIONS;
225: delete from FND_LOG_UNIQUE_EXCEPTIONS where UNIQUE_EXCEPTION_ID not in
226: (select distinct UNIQUE_EXCEPTION_ID from FND_LOG_EXCEPTIONS );
227: select count(*) into l_rows_end from FND_LOG_UNIQUE_EXCEPTIONS;
228: ---dbms_output.put_line('FND_LOG_UNIQUE_EXCEPTIONS: dlt rows out of sync'||(l_rows_end-l_rows_start));
229: commit;
230:
231:

Line 228: ---dbms_output.put_line('FND_LOG_UNIQUE_EXCEPTIONS: dlt rows out of sync'||(l_rows_end-l_rows_start));

224: select count(*) into l_rows_start from FND_LOG_UNIQUE_EXCEPTIONS;
225: delete from FND_LOG_UNIQUE_EXCEPTIONS where UNIQUE_EXCEPTION_ID not in
226: (select distinct UNIQUE_EXCEPTION_ID from FND_LOG_EXCEPTIONS );
227: select count(*) into l_rows_end from FND_LOG_UNIQUE_EXCEPTIONS;
228: ---dbms_output.put_line('FND_LOG_UNIQUE_EXCEPTIONS: dlt rows out of sync'||(l_rows_end-l_rows_start));
229: commit;
230:
231:
232: select count(*) into l_rows_start from FND_EXCEPTION_NOTES;

Line 234: (select distinct UNIQUE_EXCEPTION_ID from FND_LOG_UNIQUE_EXCEPTIONS );

230:
231:
232: select count(*) into l_rows_start from FND_EXCEPTION_NOTES;
233: delete from FND_EXCEPTION_NOTES where UNIQUE_EXCEPTION_ID not in
234: (select distinct UNIQUE_EXCEPTION_ID from FND_LOG_UNIQUE_EXCEPTIONS );
235: select count(*) into l_rows_end from FND_EXCEPTION_NOTES;
236: ---dbms_output.put_line('FND_EXCEPTION_NOTES: dlt rows out of sync'||(l_rows_end-l_rows_start));
237: commit;
238:

Line 242: (select distinct UNIQUE_EXCEPTION_ID from FND_LOG_UNIQUE_EXCEPTIONS );

238:
239:
240: select count(*) into l_rows_start from FND_OAM_BIZEX_SENT_NOTIF;
241: delete from FND_OAM_BIZEX_SENT_NOTIF where UNIQUE_EXCEPTION_ID not in
242: (select distinct UNIQUE_EXCEPTION_ID from FND_LOG_UNIQUE_EXCEPTIONS );
243: select count(*) into l_rows_end from FND_OAM_BIZEX_SENT_NOTIF;
244: ---dbms_output.put_line('FND_OAM_BIZEX_SENT_NOTIF: dlt rows out of sync'||(l_rows_end-l_rows_start));
245: commit;
246:

Line 263: END FND_LOG_UTIL;

259:
260:
261:
262:
263: END FND_LOG_UTIL;