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

Line 1: package body fnd_log_admin as

1: package body fnd_log_admin as
2: /* $Header: AFUTLGAB.pls 120.2.12010000.2 2009/07/17 15:48:13 tshort ship $ */
3:
4: C_PKG_NAME CONSTANT VARCHAR2(30) := 'FND_FUNCTION';
5: C_LOG_HEAD CONSTANT VARCHAR2(30) := 'fnd.plsql.FND_LOG_ADMIN.';

Line 5: C_LOG_HEAD CONSTANT VARCHAR2(30) := 'fnd.plsql.FND_LOG_ADMIN.';

1: package body fnd_log_admin as
2: /* $Header: AFUTLGAB.pls 120.2.12010000.2 2009/07/17 15:48:13 tshort ship $ */
3:
4: C_PKG_NAME CONSTANT VARCHAR2(30) := 'FND_FUNCTION';
5: C_LOG_HEAD CONSTANT VARCHAR2(30) := 'fnd.plsql.FND_LOG_ADMIN.';
6:
7:
8: /******************************************************************************/
9: /***Constants for Changes due to system Log ***********************************/

Line 11: TYPE TransxCurTyp IS REF CURSOR RETURN FND_LOG_TRANSACTION_CONTEXT%ROWTYPE;

7:
8: /******************************************************************************/
9: /***Constants for Changes due to system Log ***********************************/
10: TYPE GenCursor IS REF CURSOR;
11: TYPE TransxCurTyp IS REF CURSOR RETURN FND_LOG_TRANSACTION_CONTEXT%ROWTYPE;
12: TYPE UExcIdListTyp IS TABLE OF FND_LOG_UNIQUE_EXCEPTIONS.UNIQUE_EXCEPTION_ID%TYPE INDEX BY BINARY_INTEGER;
13: TYPE LogSeqListTyp IS TABLE OF FND_LOG_EXCEPTIONS.LOG_SEQUENCE%TYPE INDEX BY BINARY_INTEGER;
14: TYPE TrnCtxIdListTyp IS TABLE OF FND_LOG_TRANSACTION_CONTEXT.TRANSACTION_CONTEXT_ID%TYPE INDEX BY BINARY_INTEGER;
15: TYPE VARCAHRListTyp IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;

Line 12: TYPE UExcIdListTyp IS TABLE OF FND_LOG_UNIQUE_EXCEPTIONS.UNIQUE_EXCEPTION_ID%TYPE INDEX BY BINARY_INTEGER;

8: /******************************************************************************/
9: /***Constants for Changes due to system Log ***********************************/
10: TYPE GenCursor IS REF CURSOR;
11: TYPE TransxCurTyp IS REF CURSOR RETURN FND_LOG_TRANSACTION_CONTEXT%ROWTYPE;
12: TYPE UExcIdListTyp IS TABLE OF FND_LOG_UNIQUE_EXCEPTIONS.UNIQUE_EXCEPTION_ID%TYPE INDEX BY BINARY_INTEGER;
13: TYPE LogSeqListTyp IS TABLE OF FND_LOG_EXCEPTIONS.LOG_SEQUENCE%TYPE INDEX BY BINARY_INTEGER;
14: TYPE TrnCtxIdListTyp IS TABLE OF FND_LOG_TRANSACTION_CONTEXT.TRANSACTION_CONTEXT_ID%TYPE INDEX BY BINARY_INTEGER;
15: TYPE VARCAHRListTyp IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
16: TYPE VARCAHRSmallListTyp IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;

Line 13: TYPE LogSeqListTyp IS TABLE OF FND_LOG_EXCEPTIONS.LOG_SEQUENCE%TYPE INDEX BY BINARY_INTEGER;

9: /***Constants for Changes due to system Log ***********************************/
10: TYPE GenCursor IS REF CURSOR;
11: TYPE TransxCurTyp IS REF CURSOR RETURN FND_LOG_TRANSACTION_CONTEXT%ROWTYPE;
12: TYPE UExcIdListTyp IS TABLE OF FND_LOG_UNIQUE_EXCEPTIONS.UNIQUE_EXCEPTION_ID%TYPE INDEX BY BINARY_INTEGER;
13: TYPE LogSeqListTyp IS TABLE OF FND_LOG_EXCEPTIONS.LOG_SEQUENCE%TYPE INDEX BY BINARY_INTEGER;
14: TYPE TrnCtxIdListTyp IS TABLE OF FND_LOG_TRANSACTION_CONTEXT.TRANSACTION_CONTEXT_ID%TYPE INDEX BY BINARY_INTEGER;
15: TYPE VARCAHRListTyp IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
16: TYPE VARCAHRSmallListTyp IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;
17:

Line 14: TYPE TrnCtxIdListTyp IS TABLE OF FND_LOG_TRANSACTION_CONTEXT.TRANSACTION_CONTEXT_ID%TYPE INDEX BY BINARY_INTEGER;

10: TYPE GenCursor IS REF CURSOR;
11: TYPE TransxCurTyp IS REF CURSOR RETURN FND_LOG_TRANSACTION_CONTEXT%ROWTYPE;
12: TYPE UExcIdListTyp IS TABLE OF FND_LOG_UNIQUE_EXCEPTIONS.UNIQUE_EXCEPTION_ID%TYPE INDEX BY BINARY_INTEGER;
13: TYPE LogSeqListTyp IS TABLE OF FND_LOG_EXCEPTIONS.LOG_SEQUENCE%TYPE INDEX BY BINARY_INTEGER;
14: TYPE TrnCtxIdListTyp IS TABLE OF FND_LOG_TRANSACTION_CONTEXT.TRANSACTION_CONTEXT_ID%TYPE INDEX BY BINARY_INTEGER;
15: TYPE VARCAHRListTyp IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
16: TYPE VARCAHRSmallListTyp IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;
17:
18:

Line 28: s_rows_deleted_flm NUMBER := 0; --FND_LOG_MESSAGES;

24: COUNT_COMMIT CONSTANT NUMBER := 500;
25: DELETE_BLOCK CONSTANT NUMBER := 1000;
26: MAX_LIST_COUNT CONSTANT NUMBER := 1000;
27:
28: s_rows_deleted_flm NUMBER := 0; --FND_LOG_MESSAGES;
29: s_rows_deleted_fen NUMBER := 0; --FND_EXCEPTION_NOTES
30: s_rows_deleted_fle NUMBER := 0; --FND_LOG_EXCEPTIONS
31: s_rows_deleted_flmt NUMBER := 0; --FND_LOG_METRICS
32: s_rows_deleted_flue NUMBER := 0; --FND_LOG_UNIQUE_EXCEPTIONS

Line 30: s_rows_deleted_fle NUMBER := 0; --FND_LOG_EXCEPTIONS

26: MAX_LIST_COUNT CONSTANT NUMBER := 1000;
27:
28: s_rows_deleted_flm NUMBER := 0; --FND_LOG_MESSAGES;
29: s_rows_deleted_fen NUMBER := 0; --FND_EXCEPTION_NOTES
30: s_rows_deleted_fle NUMBER := 0; --FND_LOG_EXCEPTIONS
31: s_rows_deleted_flmt NUMBER := 0; --FND_LOG_METRICS
32: s_rows_deleted_flue NUMBER := 0; --FND_LOG_UNIQUE_EXCEPTIONS
33: s_rows_deleted_fobsn NUMBER := 0; --FND_OAM_BIZEX_SENT_NOTIF
34: s_rows_deleted_fltc NUMBER := 0; --FND_LOG_TRANSACTION_CONTEXT

Line 31: s_rows_deleted_flmt NUMBER := 0; --FND_LOG_METRICS

27:
28: s_rows_deleted_flm NUMBER := 0; --FND_LOG_MESSAGES;
29: s_rows_deleted_fen NUMBER := 0; --FND_EXCEPTION_NOTES
30: s_rows_deleted_fle NUMBER := 0; --FND_LOG_EXCEPTIONS
31: s_rows_deleted_flmt NUMBER := 0; --FND_LOG_METRICS
32: s_rows_deleted_flue NUMBER := 0; --FND_LOG_UNIQUE_EXCEPTIONS
33: s_rows_deleted_fobsn NUMBER := 0; --FND_OAM_BIZEX_SENT_NOTIF
34: s_rows_deleted_fltc NUMBER := 0; --FND_LOG_TRANSACTION_CONTEXT
35:

Line 32: s_rows_deleted_flue NUMBER := 0; --FND_LOG_UNIQUE_EXCEPTIONS

28: s_rows_deleted_flm NUMBER := 0; --FND_LOG_MESSAGES;
29: s_rows_deleted_fen NUMBER := 0; --FND_EXCEPTION_NOTES
30: s_rows_deleted_fle NUMBER := 0; --FND_LOG_EXCEPTIONS
31: s_rows_deleted_flmt NUMBER := 0; --FND_LOG_METRICS
32: s_rows_deleted_flue NUMBER := 0; --FND_LOG_UNIQUE_EXCEPTIONS
33: s_rows_deleted_fobsn NUMBER := 0; --FND_OAM_BIZEX_SENT_NOTIF
34: s_rows_deleted_fltc NUMBER := 0; --FND_LOG_TRANSACTION_CONTEXT
35:
36:

Line 34: s_rows_deleted_fltc NUMBER := 0; --FND_LOG_TRANSACTION_CONTEXT

30: s_rows_deleted_fle NUMBER := 0; --FND_LOG_EXCEPTIONS
31: s_rows_deleted_flmt NUMBER := 0; --FND_LOG_METRICS
32: s_rows_deleted_flue NUMBER := 0; --FND_LOG_UNIQUE_EXCEPTIONS
33: s_rows_deleted_fobsn NUMBER := 0; --FND_OAM_BIZEX_SENT_NOTIF
34: s_rows_deleted_fltc NUMBER := 0; --FND_LOG_TRANSACTION_CONTEXT
35:
36:
37: ---Constants used for dynamic SQL
38: --List

Line 80: delete from fnd_log_messages

76: temp_rowcount number := 0;
77: begin
78: loop
79: begin
80: delete from fnd_log_messages
81: where rownum <= 1000
82: and USER_ID = X_USER_ID
83: and TRANSACTION_CONTEXT_ID is null;
84: temp_rowcount := sql%rowcount;

Line 112: delete from fnd_log_messages

108: temp_rowcount number := 0;
109: begin
110: loop
111: begin
112: delete from fnd_log_messages
113: where rownum <= 1000
114: and SESSION_ID = X_SESSION_ID
115: and TRANSACTION_CONTEXT_ID is null;
116: temp_rowcount := sql%rowcount;

Line 144: delete from fnd_log_messages

140: temp_rowcount number := 0;
141: begin
142: loop
143: begin
144: delete from fnd_log_messages
145: where rownum <= 1000
146: and USER_ID = X_USER_ID
147: and SESSION_ID = X_SESSION_ID
148: and TRANSACTION_CONTEXT_ID is null;

Line 177: delete from fnd_log_messages

173: temp_rowcount number := 0;
174: begin
175: loop
176: begin
177: delete from fnd_log_messages
178: where rownum <= 1000
179: and module like X_MODULE
180: and TRANSACTION_CONTEXT_ID is null;
181: temp_rowcount := sql%rowcount;

Line 214: delete from fnd_log_messages

210: end if;
211: loop
212: begin
213: if (X_START_DATE is NULL) then
214: delete from fnd_log_messages
215: where rownum <= 1000
216: and timestamp <= X_END_DATE
217: and TRANSACTION_CONTEXT_ID is null;
218: elsif (X_END_DATE is NULL) then

Line 219: delete from fnd_log_messages

215: where rownum <= 1000
216: and timestamp <= X_END_DATE
217: and TRANSACTION_CONTEXT_ID is null;
218: elsif (X_END_DATE is NULL) then
219: delete from fnd_log_messages
220: where rownum <= 1000
221: and timestamp >= X_START_DATE
222: and TRANSACTION_CONTEXT_ID is null;
223: elsif ((X_START_DATE is NOT NULL) and (X_END_DATE is NOT NULL)) then

Line 224: delete from fnd_log_messages

220: where rownum <= 1000
221: and timestamp >= X_START_DATE
222: and TRANSACTION_CONTEXT_ID is null;
223: elsif ((X_START_DATE is NOT NULL) and (X_END_DATE is NOT NULL)) then
224: delete from fnd_log_messages
225: where rownum <= 1000
226: and timestamp >= X_START_DATE
227: and timestamp <= X_END_DATE
228: and TRANSACTION_CONTEXT_ID is null;

Line 249: 'Deleted rows from fnd_log_messages ' || rowcount);

245: end if;
246: end;
247: end loop;
248: fnd_file.put_line(fnd_file.log, dbms_utility.get_time || ' delete_by_date_range_pre1159: ' ||
249: 'Deleted rows from fnd_log_messages ' || rowcount);
250: return rowcount;
251: end;
252:
253:

Line 267: delete from fnd_log_messages

263: return delete_all;
264: end if;
265: loop
266: begin
267: delete from fnd_log_messages
268: where rownum <= 1000
269: and level <= X_LEVEL
270: and TRANSACTION_CONTEXT_ID is null;
271: temp_rowcount := sql%rowcount;

Line 298: delete from fnd_log_messages

294: temp_rowcount number := 0;
295: begin
296: loop
297: begin
298: delete from fnd_log_messages
299: where rownum <= 1000
300: and TRANSACTION_CONTEXT_ID is null;
301: temp_rowcount := sql%rowcount;
302: commit;

Line 349: s_rows_deleted_flm := 0; --FND_LOG_MESSAGES;

345:
346: procedure init
347: IS
348: BEGIN
349: s_rows_deleted_flm := 0; --FND_LOG_MESSAGES;
350: s_rows_deleted_fen := 0; --FND_EXCEPTION_NOTES
351: s_rows_deleted_fle := 0; --FND_LOG_EXCEPTIONS
352: s_rows_deleted_flmt := 0; --FND_LOG_METRICS
353: s_rows_deleted_flue := 0; --FND_LOG_UNIQUE_EXCEPTIONS

Line 351: s_rows_deleted_fle := 0; --FND_LOG_EXCEPTIONS

347: IS
348: BEGIN
349: s_rows_deleted_flm := 0; --FND_LOG_MESSAGES;
350: s_rows_deleted_fen := 0; --FND_EXCEPTION_NOTES
351: s_rows_deleted_fle := 0; --FND_LOG_EXCEPTIONS
352: s_rows_deleted_flmt := 0; --FND_LOG_METRICS
353: s_rows_deleted_flue := 0; --FND_LOG_UNIQUE_EXCEPTIONS
354: s_rows_deleted_fobsn := 0; --FND_OAM_BIZEX_SENT_NOTIF
355: s_rows_deleted_fltc := 0; --FND_LOG_TRANSACTION_CONTEXT

Line 352: s_rows_deleted_flmt := 0; --FND_LOG_METRICS

348: BEGIN
349: s_rows_deleted_flm := 0; --FND_LOG_MESSAGES;
350: s_rows_deleted_fen := 0; --FND_EXCEPTION_NOTES
351: s_rows_deleted_fle := 0; --FND_LOG_EXCEPTIONS
352: s_rows_deleted_flmt := 0; --FND_LOG_METRICS
353: s_rows_deleted_flue := 0; --FND_LOG_UNIQUE_EXCEPTIONS
354: s_rows_deleted_fobsn := 0; --FND_OAM_BIZEX_SENT_NOTIF
355: s_rows_deleted_fltc := 0; --FND_LOG_TRANSACTION_CONTEXT
356: END init;

Line 353: s_rows_deleted_flue := 0; --FND_LOG_UNIQUE_EXCEPTIONS

349: s_rows_deleted_flm := 0; --FND_LOG_MESSAGES;
350: s_rows_deleted_fen := 0; --FND_EXCEPTION_NOTES
351: s_rows_deleted_fle := 0; --FND_LOG_EXCEPTIONS
352: s_rows_deleted_flmt := 0; --FND_LOG_METRICS
353: s_rows_deleted_flue := 0; --FND_LOG_UNIQUE_EXCEPTIONS
354: s_rows_deleted_fobsn := 0; --FND_OAM_BIZEX_SENT_NOTIF
355: s_rows_deleted_fltc := 0; --FND_LOG_TRANSACTION_CONTEXT
356: END init;
357:

Line 355: s_rows_deleted_fltc := 0; --FND_LOG_TRANSACTION_CONTEXT

351: s_rows_deleted_fle := 0; --FND_LOG_EXCEPTIONS
352: s_rows_deleted_flmt := 0; --FND_LOG_METRICS
353: s_rows_deleted_flue := 0; --FND_LOG_UNIQUE_EXCEPTIONS
354: s_rows_deleted_fobsn := 0; --FND_OAM_BIZEX_SENT_NOTIF
355: s_rows_deleted_fltc := 0; --FND_LOG_TRANSACTION_CONTEXT
356: END init;
357:
358: procedure printCount
359: is

Line 365: select count(*) into l_count from FND_LOG_MESSAGES;

361: begin
362: l_count := 0;
363:
364: /*
365: select count(*) into l_count from FND_LOG_MESSAGES;
366: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_MESSAGES=' || l_count);
367: select count(*) into l_count from FND_EXCEPTION_NOTES;
368: fnd_file.put_line( fnd_file.log,'Rows in FND_EXCEPTION_NOTES=' || l_count);
369: select count(*) into l_count from FND_LOG_EXCEPTIONS;

Line 366: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_MESSAGES=' || l_count);

362: l_count := 0;
363:
364: /*
365: select count(*) into l_count from FND_LOG_MESSAGES;
366: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_MESSAGES=' || l_count);
367: select count(*) into l_count from FND_EXCEPTION_NOTES;
368: fnd_file.put_line( fnd_file.log,'Rows in FND_EXCEPTION_NOTES=' || l_count);
369: select count(*) into l_count from FND_LOG_EXCEPTIONS;
370: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_EXCEPTIONS=' || l_count);

Line 369: select count(*) into l_count from FND_LOG_EXCEPTIONS;

365: select count(*) into l_count from FND_LOG_MESSAGES;
366: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_MESSAGES=' || l_count);
367: select count(*) into l_count from FND_EXCEPTION_NOTES;
368: fnd_file.put_line( fnd_file.log,'Rows in FND_EXCEPTION_NOTES=' || l_count);
369: select count(*) into l_count from FND_LOG_EXCEPTIONS;
370: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_EXCEPTIONS=' || l_count);
371: select count(*) into l_count from FND_LOG_METRICS;
372: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_METRICS=' || l_count);
373: select count(*) into l_count from FND_LOG_UNIQUE_EXCEPTIONS;

Line 370: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_EXCEPTIONS=' || l_count);

366: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_MESSAGES=' || l_count);
367: select count(*) into l_count from FND_EXCEPTION_NOTES;
368: fnd_file.put_line( fnd_file.log,'Rows in FND_EXCEPTION_NOTES=' || l_count);
369: select count(*) into l_count from FND_LOG_EXCEPTIONS;
370: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_EXCEPTIONS=' || l_count);
371: select count(*) into l_count from FND_LOG_METRICS;
372: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_METRICS=' || l_count);
373: select count(*) into l_count from FND_LOG_UNIQUE_EXCEPTIONS;
374: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_UNIQUE_EXCEPTIONS=' || l_count);

Line 371: select count(*) into l_count from FND_LOG_METRICS;

367: select count(*) into l_count from FND_EXCEPTION_NOTES;
368: fnd_file.put_line( fnd_file.log,'Rows in FND_EXCEPTION_NOTES=' || l_count);
369: select count(*) into l_count from FND_LOG_EXCEPTIONS;
370: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_EXCEPTIONS=' || l_count);
371: select count(*) into l_count from FND_LOG_METRICS;
372: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_METRICS=' || l_count);
373: select count(*) into l_count from FND_LOG_UNIQUE_EXCEPTIONS;
374: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_UNIQUE_EXCEPTIONS=' || l_count);
375: select count(*) into l_count from FND_OAM_BIZEX_SENT_NOTIF;

Line 372: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_METRICS=' || l_count);

368: fnd_file.put_line( fnd_file.log,'Rows in FND_EXCEPTION_NOTES=' || l_count);
369: select count(*) into l_count from FND_LOG_EXCEPTIONS;
370: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_EXCEPTIONS=' || l_count);
371: select count(*) into l_count from FND_LOG_METRICS;
372: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_METRICS=' || l_count);
373: select count(*) into l_count from FND_LOG_UNIQUE_EXCEPTIONS;
374: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_UNIQUE_EXCEPTIONS=' || l_count);
375: select count(*) into l_count from FND_OAM_BIZEX_SENT_NOTIF;
376: fnd_file.put_line( fnd_file.log,'Rows in FND_OAM_BIZEX_SENT_NOTIF=' || l_count);

Line 373: select count(*) into l_count from FND_LOG_UNIQUE_EXCEPTIONS;

369: select count(*) into l_count from FND_LOG_EXCEPTIONS;
370: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_EXCEPTIONS=' || l_count);
371: select count(*) into l_count from FND_LOG_METRICS;
372: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_METRICS=' || l_count);
373: select count(*) into l_count from FND_LOG_UNIQUE_EXCEPTIONS;
374: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_UNIQUE_EXCEPTIONS=' || l_count);
375: select count(*) into l_count from FND_OAM_BIZEX_SENT_NOTIF;
376: fnd_file.put_line( fnd_file.log,'Rows in FND_OAM_BIZEX_SENT_NOTIF=' || l_count);
377: select count(*) into l_count from FND_LOG_TRANSACTION_CONTEXT;

Line 374: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_UNIQUE_EXCEPTIONS=' || l_count);

370: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_EXCEPTIONS=' || l_count);
371: select count(*) into l_count from FND_LOG_METRICS;
372: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_METRICS=' || l_count);
373: select count(*) into l_count from FND_LOG_UNIQUE_EXCEPTIONS;
374: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_UNIQUE_EXCEPTIONS=' || l_count);
375: select count(*) into l_count from FND_OAM_BIZEX_SENT_NOTIF;
376: fnd_file.put_line( fnd_file.log,'Rows in FND_OAM_BIZEX_SENT_NOTIF=' || l_count);
377: select count(*) into l_count from FND_LOG_TRANSACTION_CONTEXT;
378: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_TRANSACTION_CONTEXT=' || l_count);

Line 377: select count(*) into l_count from FND_LOG_TRANSACTION_CONTEXT;

373: select count(*) into l_count from FND_LOG_UNIQUE_EXCEPTIONS;
374: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_UNIQUE_EXCEPTIONS=' || l_count);
375: select count(*) into l_count from FND_OAM_BIZEX_SENT_NOTIF;
376: fnd_file.put_line( fnd_file.log,'Rows in FND_OAM_BIZEX_SENT_NOTIF=' || l_count);
377: select count(*) into l_count from FND_LOG_TRANSACTION_CONTEXT;
378: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_TRANSACTION_CONTEXT=' || l_count);
379: select count(*) into l_count from FND_LOG_ATTACHMENTS;
380: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_ATTACHMENTS=' || l_count);
381: */

Line 378: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_TRANSACTION_CONTEXT=' || l_count);

374: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_UNIQUE_EXCEPTIONS=' || l_count);
375: select count(*) into l_count from FND_OAM_BIZEX_SENT_NOTIF;
376: fnd_file.put_line( fnd_file.log,'Rows in FND_OAM_BIZEX_SENT_NOTIF=' || l_count);
377: select count(*) into l_count from FND_LOG_TRANSACTION_CONTEXT;
378: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_TRANSACTION_CONTEXT=' || l_count);
379: select count(*) into l_count from FND_LOG_ATTACHMENTS;
380: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_ATTACHMENTS=' || l_count);
381: */
382: end printCount;

Line 379: select count(*) into l_count from FND_LOG_ATTACHMENTS;

375: select count(*) into l_count from FND_OAM_BIZEX_SENT_NOTIF;
376: fnd_file.put_line( fnd_file.log,'Rows in FND_OAM_BIZEX_SENT_NOTIF=' || l_count);
377: select count(*) into l_count from FND_LOG_TRANSACTION_CONTEXT;
378: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_TRANSACTION_CONTEXT=' || l_count);
379: select count(*) into l_count from FND_LOG_ATTACHMENTS;
380: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_ATTACHMENTS=' || l_count);
381: */
382: end printCount;
383:

Line 380: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_ATTACHMENTS=' || l_count);

376: fnd_file.put_line( fnd_file.log,'Rows in FND_OAM_BIZEX_SENT_NOTIF=' || l_count);
377: select count(*) into l_count from FND_LOG_TRANSACTION_CONTEXT;
378: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_TRANSACTION_CONTEXT=' || l_count);
379: select count(*) into l_count from FND_LOG_ATTACHMENTS;
380: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_ATTACHMENTS=' || l_count);
381: */
382: end printCount;
383:
384:

Line 552: || ' from FND_LOG_TRANSACTION_CONTEXT fltc ';

548: l_part3 :='';
549: l_part4 :='';
550:
551: l_retu := 'select distinct fltc.TRANSACTION_CONTEXT_ID '
552: || ' from FND_LOG_TRANSACTION_CONTEXT fltc ';
553:
554:
555: if (pTrType = C_TR_REQUEST_TYPE) then
556: l_part1 := ' where fltc.TRANSACTION_TYPE = ''REQUEST'' ';

Line 664: fdebug('Start Del FND_LOG_EXCEPTIONS');

660: exit when l_start > p_logSeqList.count;
661:
662: begin
663:
664: fdebug('Start Del FND_LOG_EXCEPTIONS');
665: fdebug('l_start = ' || l_start || ' l_end = ' || l_end);
666:
667: l_table := 'FND_LOG_EXCEPTIONS';
668: FORALL ii IN l_start..l_end

Line 667: l_table := 'FND_LOG_EXCEPTIONS';

663:
664: fdebug('Start Del FND_LOG_EXCEPTIONS');
665: fdebug('l_start = ' || l_start || ' l_end = ' || l_end);
666:
667: l_table := 'FND_LOG_EXCEPTIONS';
668: FORALL ii IN l_start..l_end
669: delete from FND_LOG_EXCEPTIONS flem where flem.LOG_SEQUENCE=p_logSeqList(ii)
670: and NOT EXISTS
671: (select null from FND_LOG_EXCEPTIONS fle, FND_LOG_UNIQUE_EXCEPTIONS flue where

Line 669: delete from FND_LOG_EXCEPTIONS flem where flem.LOG_SEQUENCE=p_logSeqList(ii)

665: fdebug('l_start = ' || l_start || ' l_end = ' || l_end);
666:
667: l_table := 'FND_LOG_EXCEPTIONS';
668: FORALL ii IN l_start..l_end
669: delete from FND_LOG_EXCEPTIONS flem where flem.LOG_SEQUENCE=p_logSeqList(ii)
670: and NOT EXISTS
671: (select null from FND_LOG_EXCEPTIONS fle, FND_LOG_UNIQUE_EXCEPTIONS flue where
672: fle.LOG_SEQUENCE = flem.LOG_SEQUENCE
673: and flue.UNIQUE_EXCEPTION_ID = fle.UNIQUE_EXCEPTION_ID

Line 671: (select null from FND_LOG_EXCEPTIONS fle, FND_LOG_UNIQUE_EXCEPTIONS flue where

667: l_table := 'FND_LOG_EXCEPTIONS';
668: FORALL ii IN l_start..l_end
669: delete from FND_LOG_EXCEPTIONS flem where flem.LOG_SEQUENCE=p_logSeqList(ii)
670: and NOT EXISTS
671: (select null from FND_LOG_EXCEPTIONS fle, FND_LOG_UNIQUE_EXCEPTIONS flue where
672: fle.LOG_SEQUENCE = flem.LOG_SEQUENCE
673: and flue.UNIQUE_EXCEPTION_ID = fle.UNIQUE_EXCEPTION_ID
674: and flue.STATUS <> 'C');
675:

Line 676: s_rows_deleted_fle := s_rows_deleted_fle + sql%rowcount; --FND_LOG_EXCEPTIONS

672: fle.LOG_SEQUENCE = flem.LOG_SEQUENCE
673: and flue.UNIQUE_EXCEPTION_ID = fle.UNIQUE_EXCEPTION_ID
674: and flue.STATUS <> 'C');
675:
676: s_rows_deleted_fle := s_rows_deleted_fle + sql%rowcount; --FND_LOG_EXCEPTIONS
677: doCommit;
678:
679: fdebug('Start Del FND_LOG_MESSAGES');
680: l_table := 'FND_LOG_MESSAGES';

Line 679: fdebug('Start Del FND_LOG_MESSAGES');

675:
676: s_rows_deleted_fle := s_rows_deleted_fle + sql%rowcount; --FND_LOG_EXCEPTIONS
677: doCommit;
678:
679: fdebug('Start Del FND_LOG_MESSAGES');
680: l_table := 'FND_LOG_MESSAGES';
681:
682: FORALL ii IN l_start..l_end
683: delete from FND_LOG_MESSAGES flm where flm.LOG_SEQUENCE=p_logSeqList(ii)

Line 680: l_table := 'FND_LOG_MESSAGES';

676: s_rows_deleted_fle := s_rows_deleted_fle + sql%rowcount; --FND_LOG_EXCEPTIONS
677: doCommit;
678:
679: fdebug('Start Del FND_LOG_MESSAGES');
680: l_table := 'FND_LOG_MESSAGES';
681:
682: FORALL ii IN l_start..l_end
683: delete from FND_LOG_MESSAGES flm where flm.LOG_SEQUENCE=p_logSeqList(ii)
684: and NOT EXISTS

Line 683: delete from FND_LOG_MESSAGES flm where flm.LOG_SEQUENCE=p_logSeqList(ii)

679: fdebug('Start Del FND_LOG_MESSAGES');
680: l_table := 'FND_LOG_MESSAGES';
681:
682: FORALL ii IN l_start..l_end
683: delete from FND_LOG_MESSAGES flm where flm.LOG_SEQUENCE=p_logSeqList(ii)
684: and NOT EXISTS
685: (select null from FND_LOG_EXCEPTIONS fle where
686: fle.LOG_SEQUENCE = flm.LOG_SEQUENCE
687: );

Line 685: (select null from FND_LOG_EXCEPTIONS fle where

681:
682: FORALL ii IN l_start..l_end
683: delete from FND_LOG_MESSAGES flm where flm.LOG_SEQUENCE=p_logSeqList(ii)
684: and NOT EXISTS
685: (select null from FND_LOG_EXCEPTIONS fle where
686: fle.LOG_SEQUENCE = flm.LOG_SEQUENCE
687: );
688:
689: s_rows_deleted_flm := s_rows_deleted_flm + sql%rowcount; --FND_LOG_MESSAGES;

Line 689: s_rows_deleted_flm := s_rows_deleted_flm + sql%rowcount; --FND_LOG_MESSAGES;

685: (select null from FND_LOG_EXCEPTIONS fle where
686: fle.LOG_SEQUENCE = flm.LOG_SEQUENCE
687: );
688:
689: s_rows_deleted_flm := s_rows_deleted_flm + sql%rowcount; --FND_LOG_MESSAGES;
690: doCommit;
691:
692:
693: l_table := 'FND_LOG_ATTACHMENTS';

Line 693: l_table := 'FND_LOG_ATTACHMENTS';

689: s_rows_deleted_flm := s_rows_deleted_flm + sql%rowcount; --FND_LOG_MESSAGES;
690: doCommit;
691:
692:
693: l_table := 'FND_LOG_ATTACHMENTS';
694: FORALL ii IN l_start..l_end
695: delete from FND_LOG_ATTACHMENTS fla where fla.LOG_SEQUENCE=p_logSeqList(ii)
696: and NOT EXISTS
697: (select null from FND_LOG_EXCEPTIONS fle where fle.LOG_SEQUENCE = p_logSeqList(ii))

Line 695: delete from FND_LOG_ATTACHMENTS fla where fla.LOG_SEQUENCE=p_logSeqList(ii)

691:
692:
693: l_table := 'FND_LOG_ATTACHMENTS';
694: FORALL ii IN l_start..l_end
695: delete from FND_LOG_ATTACHMENTS fla where fla.LOG_SEQUENCE=p_logSeqList(ii)
696: and NOT EXISTS
697: (select null from FND_LOG_EXCEPTIONS fle where fle.LOG_SEQUENCE = p_logSeqList(ii))
698: and NOT EXISTS
699: (select null from FND_LOG_MESSAGES flm where flm.LOG_SEQUENCE = p_logSeqList(ii));

Line 697: (select null from FND_LOG_EXCEPTIONS fle where fle.LOG_SEQUENCE = p_logSeqList(ii))

693: l_table := 'FND_LOG_ATTACHMENTS';
694: FORALL ii IN l_start..l_end
695: delete from FND_LOG_ATTACHMENTS fla where fla.LOG_SEQUENCE=p_logSeqList(ii)
696: and NOT EXISTS
697: (select null from FND_LOG_EXCEPTIONS fle where fle.LOG_SEQUENCE = p_logSeqList(ii))
698: and NOT EXISTS
699: (select null from FND_LOG_MESSAGES flm where flm.LOG_SEQUENCE = p_logSeqList(ii));
700:
701:

Line 699: (select null from FND_LOG_MESSAGES flm where flm.LOG_SEQUENCE = p_logSeqList(ii));

695: delete from FND_LOG_ATTACHMENTS fla where fla.LOG_SEQUENCE=p_logSeqList(ii)
696: and NOT EXISTS
697: (select null from FND_LOG_EXCEPTIONS fle where fle.LOG_SEQUENCE = p_logSeqList(ii))
698: and NOT EXISTS
699: (select null from FND_LOG_MESSAGES flm where flm.LOG_SEQUENCE = p_logSeqList(ii));
700:
701:
702:
703: EXCEPTION

Line 745: l_table := 'FND_LOG_MESSAGES';

741: exit when l_start > p_UEXList.count;
742:
743: begin
744: fdebug('Start Del FND_EXCEPTION_NOTES');
745: l_table := 'FND_LOG_MESSAGES';
746:
747: FORALL ii IN l_start..l_end
748: DELETE FROM FND_EXCEPTION_NOTES fen
749: WHERE fen.UNIQUE_EXCEPTION_ID = p_UEXList(ii)

Line 751: (SELECT null from FND_LOG_EXCEPTIONS fle

747: FORALL ii IN l_start..l_end
748: DELETE FROM FND_EXCEPTION_NOTES fen
749: WHERE fen.UNIQUE_EXCEPTION_ID = p_UEXList(ii)
750: and NOT EXISTS
751: (SELECT null from FND_LOG_EXCEPTIONS fle
752: where fle.UNIQUE_EXCEPTION_ID = fen.UNIQUE_EXCEPTION_ID
753: );
754: s_rows_deleted_fen := s_rows_deleted_fen + sql%rowcount; --FND_EXCEPTION_NOTES
755: doCommit;

Line 763: (SELECT null from FND_LOG_EXCEPTIONS fle

759: FORALL ii IN l_start..l_end
760: DELETE FROM FND_OAM_BIZEX_SENT_NOTIF fobsf
761: WHERE fobsf.UNIQUE_EXCEPTION_ID = p_UEXList(ii)
762: and NOT EXISTS
763: (SELECT null from FND_LOG_EXCEPTIONS fle
764: where fle.UNIQUE_EXCEPTION_ID = fobsf.UNIQUE_EXCEPTION_ID
765: );
766: s_rows_deleted_fobsn := s_rows_deleted_fobsn + sql%rowcount; --FND_OAM_BIZEX_SENT_NOTIF
767: doCommit;

Line 769: fdebug('Start Del FND_LOG_UNIQUE_EXCEPTIONS');

765: );
766: s_rows_deleted_fobsn := s_rows_deleted_fobsn + sql%rowcount; --FND_OAM_BIZEX_SENT_NOTIF
767: doCommit;
768:
769: fdebug('Start Del FND_LOG_UNIQUE_EXCEPTIONS');
770: l_table := 'FND_LOG_UNIQUE_EXCEPTIONS';
771: FORALL ii IN l_start..l_end
772: DELETE FROM FND_LOG_UNIQUE_EXCEPTIONS flue
773: WHERE flue.UNIQUE_EXCEPTION_ID = p_UEXList(ii)

Line 770: l_table := 'FND_LOG_UNIQUE_EXCEPTIONS';

766: s_rows_deleted_fobsn := s_rows_deleted_fobsn + sql%rowcount; --FND_OAM_BIZEX_SENT_NOTIF
767: doCommit;
768:
769: fdebug('Start Del FND_LOG_UNIQUE_EXCEPTIONS');
770: l_table := 'FND_LOG_UNIQUE_EXCEPTIONS';
771: FORALL ii IN l_start..l_end
772: DELETE FROM FND_LOG_UNIQUE_EXCEPTIONS flue
773: WHERE flue.UNIQUE_EXCEPTION_ID = p_UEXList(ii)
774: and NOT EXISTS

Line 772: DELETE FROM FND_LOG_UNIQUE_EXCEPTIONS flue

768:
769: fdebug('Start Del FND_LOG_UNIQUE_EXCEPTIONS');
770: l_table := 'FND_LOG_UNIQUE_EXCEPTIONS';
771: FORALL ii IN l_start..l_end
772: DELETE FROM FND_LOG_UNIQUE_EXCEPTIONS flue
773: WHERE flue.UNIQUE_EXCEPTION_ID = p_UEXList(ii)
774: and NOT EXISTS
775: (SELECT null from FND_LOG_EXCEPTIONS fle
776: where fle.UNIQUE_EXCEPTION_ID = flue.UNIQUE_EXCEPTION_ID

Line 775: (SELECT null from FND_LOG_EXCEPTIONS fle

771: FORALL ii IN l_start..l_end
772: DELETE FROM FND_LOG_UNIQUE_EXCEPTIONS flue
773: WHERE flue.UNIQUE_EXCEPTION_ID = p_UEXList(ii)
774: and NOT EXISTS
775: (SELECT null from FND_LOG_EXCEPTIONS fle
776: where fle.UNIQUE_EXCEPTION_ID = flue.UNIQUE_EXCEPTION_ID
777: );
778: s_rows_deleted_flue := s_rows_deleted_flue + sql%rowcount; --FND_LOG_UNIQUE_EXCEPTIONS
779: doCommit;

Line 778: s_rows_deleted_flue := s_rows_deleted_flue + sql%rowcount; --FND_LOG_UNIQUE_EXCEPTIONS

774: and NOT EXISTS
775: (SELECT null from FND_LOG_EXCEPTIONS fle
776: where fle.UNIQUE_EXCEPTION_ID = flue.UNIQUE_EXCEPTION_ID
777: );
778: s_rows_deleted_flue := s_rows_deleted_flue + sql%rowcount; --FND_LOG_UNIQUE_EXCEPTIONS
779: doCommit;
780:
781: EXCEPTION
782: when others then

Line 798: -- in fnd_log_exceptions

794: END DELETE_UNIQUE_EXCEPTIONS_INFO;
795:
796: --------------------------------------------------------------------------------
797: --This function deletes those unique exceptions for which there is no infor
798: -- in fnd_log_exceptions
799:
800: procedure DELETE_UNIQUEA_EXCEPTIONS_INFO(pRetCode out NOCOPY number)
801: IS
802: l_table VARCHAR2(25);

Line 813: FND_LOG_UNIQUE_EXCEPTIONS flue

809:
810: --Check input parameters
811: select flue.UNIQUE_EXCEPTION_ID BULK COLLECT into l_UEXList
812: from
813: FND_LOG_UNIQUE_EXCEPTIONS flue
814: where
815: NOT EXISTS
816: (SELECT null from FND_LOG_EXCEPTIONS fle
817: where fle.UNIQUE_EXCEPTION_ID = flue.UNIQUE_EXCEPTION_ID

Line 816: (SELECT null from FND_LOG_EXCEPTIONS fle

812: from
813: FND_LOG_UNIQUE_EXCEPTIONS flue
814: where
815: NOT EXISTS
816: (SELECT null from FND_LOG_EXCEPTIONS fle
817: where fle.UNIQUE_EXCEPTION_ID = flue.UNIQUE_EXCEPTION_ID
818: );
819:
820: DELETE_UNIQUE_EXCEPTIONS_INFO(l_UEXList,pRetCode);

Line 841: FND_LOG_EXCEPTIONS fle

837:
838: --Check input parameters
839: select fle.LOG_SEQUENCE BULK COLLECT into l_EXList
840: from
841: FND_LOG_EXCEPTIONS fle
842: ,FND_LOG_UNIQUE_EXCEPTIONS flue
843: where
844: fle.UNIQUE_EXCEPTION_ID = flue.UNIQUE_EXCEPTION_ID
845: and fle.TRANSACTION_CONTEXT_ID is null

Line 842: ,FND_LOG_UNIQUE_EXCEPTIONS flue

838: --Check input parameters
839: select fle.LOG_SEQUENCE BULK COLLECT into l_EXList
840: from
841: FND_LOG_EXCEPTIONS fle
842: ,FND_LOG_UNIQUE_EXCEPTIONS flue
843: where
844: fle.UNIQUE_EXCEPTION_ID = flue.UNIQUE_EXCEPTION_ID
845: and fle.TRANSACTION_CONTEXT_ID is null
846: and flue.STATUS = 'C'

Line 865: fdebug('In:FND_LOG_ADMIN.DELETE_MESSAGES_INFO rec=' || p_logSeqList.count);

861: l_start NUMBER;
862: l_end NUMBER :=0;
863:
864: BEGIN
865: fdebug('In:FND_LOG_ADMIN.DELETE_MESSAGES_INFO rec=' || p_logSeqList.count);
866: pRetCode := C_SUCCESS;
867:
868: --Check input parameters
869: if (p_logSeqList is null) or (p_logSeqList.count < 1) then

Line 880: fdebug('Start Del FND_LOG_MESSAGES');

876: exit when l_start > p_logSeqList.count;
877:
878: begin
879:
880: fdebug('Start Del FND_LOG_MESSAGES');
881: --still need date because transaction_context_id's aren't unique
882: FORALL ii IN l_start..l_end
883: delete from FND_LOG_MESSAGES flm where
884: flm.TRANSACTION_CONTEXT_ID=p_logSeqList(ii)

Line 883: delete from FND_LOG_MESSAGES flm where

879:
880: fdebug('Start Del FND_LOG_MESSAGES');
881: --still need date because transaction_context_id's aren't unique
882: FORALL ii IN l_start..l_end
883: delete from FND_LOG_MESSAGES flm where
884: flm.TRANSACTION_CONTEXT_ID=p_logSeqList(ii)
885: and (X_START_DATE is null or flm.TIMESTAMP >= X_START_DATE)
886: and (X_END_DATE is null or flm.TIMESTAMP <= X_END_DATE);
887:

Line 901: fdebug('OUT:FND_LOG_ADMIN.DELETE_MESSAGES_INFO');

897:
898: end loop;
899:
900:
901: fdebug('OUT:FND_LOG_ADMIN.DELETE_MESSAGES_INFO');
902:
903: END DELETE_MESSAGES_INFO;
904:
905: --------------------------------------------------------------------------------

Line 907: --doesn't exist in fnd_log_transaction_context but meets the input date range.

903: END DELETE_MESSAGES_INFO;
904:
905: --------------------------------------------------------------------------------
906: --This function deletes those log messages whose transaction Context Id is
907: --doesn't exist in fnd_log_transaction_context but meets the input date range.
908:
909: procedure DELETE_MESSAGES_INVALID_TRID(pRetCode out NOCOPY number
910: ,X_START_DATE IN DATE, X_END_DATE IN DATE )
911: IS

Line 918: fdebug('In:FND_LOG_ADMIN.DELETE_MESSAGES_INVALID_TRID');

914: l_start NUMBER;
915: l_end NUMBER :=0;
916:
917: BEGIN
918: fdebug('In:FND_LOG_ADMIN.DELETE_MESSAGES_INVALID_TRID');
919:
920: pRetCode := C_SUCCESS;
921:
922: --Check input parameters

Line 925: FND_LOG_MESSAGES flm

921:
922: --Check input parameters
923: select flm.TRANSACTION_CONTEXT_ID BULK COLLECT into l_EXList
924: from
925: FND_LOG_MESSAGES flm
926: where
927: not exists (select null from FND_LOG_TRANSACTION_CONTEXT fltc
928: where flm.TRANSACTION_CONTEXT_ID = fltc.TRANSACTION_CONTEXT_ID)
929: and (X_START_DATE is null or flm.TIMESTAMP >= X_START_DATE)

Line 927: not exists (select null from FND_LOG_TRANSACTION_CONTEXT fltc

923: select flm.TRANSACTION_CONTEXT_ID BULK COLLECT into l_EXList
924: from
925: FND_LOG_MESSAGES flm
926: where
927: not exists (select null from FND_LOG_TRANSACTION_CONTEXT fltc
928: where flm.TRANSACTION_CONTEXT_ID = fltc.TRANSACTION_CONTEXT_ID)
929: and (X_START_DATE is null or flm.TIMESTAMP >= X_START_DATE)
930: and (X_END_DATE is null or flm.TIMESTAMP <= X_END_DATE);
931:

Line 962: fdebug('Start Del FND_LOG_METRICS');

958: l_end := getDeleteBlock(l_end, p_TrList.count);
959: exit when l_start > p_TrList.count;
960:
961: begin
962: fdebug('Start Del FND_LOG_METRICS');
963: l_table := 'FND_LOG_METRICS';
964:
965: FORALL ii IN l_start..l_end
966: delete from FND_LOG_METRICS flm where flm.TRANSACTION_CONTEXT_ID=p_TrList(ii)

Line 963: l_table := 'FND_LOG_METRICS';

959: exit when l_start > p_TrList.count;
960:
961: begin
962: fdebug('Start Del FND_LOG_METRICS');
963: l_table := 'FND_LOG_METRICS';
964:
965: FORALL ii IN l_start..l_end
966: delete from FND_LOG_METRICS flm where flm.TRANSACTION_CONTEXT_ID=p_TrList(ii)
967: and NOT EXISTS

Line 966: delete from FND_LOG_METRICS flm where flm.TRANSACTION_CONTEXT_ID=p_TrList(ii)

962: fdebug('Start Del FND_LOG_METRICS');
963: l_table := 'FND_LOG_METRICS';
964:
965: FORALL ii IN l_start..l_end
966: delete from FND_LOG_METRICS flm where flm.TRANSACTION_CONTEXT_ID=p_TrList(ii)
967: and NOT EXISTS
968: (select null from FND_LOG_EXCEPTIONS fle WHERE fle.TRANSACTION_CONTEXT_ID=flm.TRANSACTION_CONTEXT_ID);
969: s_rows_deleted_flmt := s_rows_deleted_flmt + sql%rowcount; --FND_LOG_METRICS
970: doCommit;

Line 968: (select null from FND_LOG_EXCEPTIONS fle WHERE fle.TRANSACTION_CONTEXT_ID=flm.TRANSACTION_CONTEXT_ID);

964:
965: FORALL ii IN l_start..l_end
966: delete from FND_LOG_METRICS flm where flm.TRANSACTION_CONTEXT_ID=p_TrList(ii)
967: and NOT EXISTS
968: (select null from FND_LOG_EXCEPTIONS fle WHERE fle.TRANSACTION_CONTEXT_ID=flm.TRANSACTION_CONTEXT_ID);
969: s_rows_deleted_flmt := s_rows_deleted_flmt + sql%rowcount; --FND_LOG_METRICS
970: doCommit;
971:
972:

Line 969: s_rows_deleted_flmt := s_rows_deleted_flmt + sql%rowcount; --FND_LOG_METRICS

965: FORALL ii IN l_start..l_end
966: delete from FND_LOG_METRICS flm where flm.TRANSACTION_CONTEXT_ID=p_TrList(ii)
967: and NOT EXISTS
968: (select null from FND_LOG_EXCEPTIONS fle WHERE fle.TRANSACTION_CONTEXT_ID=flm.TRANSACTION_CONTEXT_ID);
969: s_rows_deleted_flmt := s_rows_deleted_flmt + sql%rowcount; --FND_LOG_METRICS
970: doCommit;
971:
972:
973: fdebug('Start Del FND_LOG_TRANSACTION_CONTEXT');

Line 973: fdebug('Start Del FND_LOG_TRANSACTION_CONTEXT');

969: s_rows_deleted_flmt := s_rows_deleted_flmt + sql%rowcount; --FND_LOG_METRICS
970: doCommit;
971:
972:
973: fdebug('Start Del FND_LOG_TRANSACTION_CONTEXT');
974: l_table := 'FND_LOG_TRANSACTION_CONTEXT';
975: FORALL ii IN l_start..l_end
976: delete from FND_LOG_TRANSACTION_CONTEXT where TRANSACTION_CONTEXT_ID=p_TrList(ii)
977: and NOT EXISTS

Line 974: l_table := 'FND_LOG_TRANSACTION_CONTEXT';

970: doCommit;
971:
972:
973: fdebug('Start Del FND_LOG_TRANSACTION_CONTEXT');
974: l_table := 'FND_LOG_TRANSACTION_CONTEXT';
975: FORALL ii IN l_start..l_end
976: delete from FND_LOG_TRANSACTION_CONTEXT where TRANSACTION_CONTEXT_ID=p_TrList(ii)
977: and NOT EXISTS
978: (select null from FND_LOG_EXCEPTIONS fle WHERE fle.TRANSACTION_CONTEXT_ID=p_TrList(ii))

Line 976: delete from FND_LOG_TRANSACTION_CONTEXT where TRANSACTION_CONTEXT_ID=p_TrList(ii)

972:
973: fdebug('Start Del FND_LOG_TRANSACTION_CONTEXT');
974: l_table := 'FND_LOG_TRANSACTION_CONTEXT';
975: FORALL ii IN l_start..l_end
976: delete from FND_LOG_TRANSACTION_CONTEXT where TRANSACTION_CONTEXT_ID=p_TrList(ii)
977: and NOT EXISTS
978: (select null from FND_LOG_EXCEPTIONS fle WHERE fle.TRANSACTION_CONTEXT_ID=p_TrList(ii))
979: and NOT EXISTS
980: (select null from FND_LOG_MESSAGES flm WHERE flm.TRANSACTION_CONTEXT_ID=p_TrList(ii));

Line 978: (select null from FND_LOG_EXCEPTIONS fle WHERE fle.TRANSACTION_CONTEXT_ID=p_TrList(ii))

974: l_table := 'FND_LOG_TRANSACTION_CONTEXT';
975: FORALL ii IN l_start..l_end
976: delete from FND_LOG_TRANSACTION_CONTEXT where TRANSACTION_CONTEXT_ID=p_TrList(ii)
977: and NOT EXISTS
978: (select null from FND_LOG_EXCEPTIONS fle WHERE fle.TRANSACTION_CONTEXT_ID=p_TrList(ii))
979: and NOT EXISTS
980: (select null from FND_LOG_MESSAGES flm WHERE flm.TRANSACTION_CONTEXT_ID=p_TrList(ii));
981:
982: l_retu := sql%rowcount;

Line 980: (select null from FND_LOG_MESSAGES flm WHERE flm.TRANSACTION_CONTEXT_ID=p_TrList(ii));

976: delete from FND_LOG_TRANSACTION_CONTEXT where TRANSACTION_CONTEXT_ID=p_TrList(ii)
977: and NOT EXISTS
978: (select null from FND_LOG_EXCEPTIONS fle WHERE fle.TRANSACTION_CONTEXT_ID=p_TrList(ii))
979: and NOT EXISTS
980: (select null from FND_LOG_MESSAGES flm WHERE flm.TRANSACTION_CONTEXT_ID=p_TrList(ii));
981:
982: l_retu := sql%rowcount;
983: s_rows_deleted_fltc := s_rows_deleted_fltc + sql%rowcount; --FND_LOG_TRANSACTION_CONTEXT
984: doCommit;

Line 983: s_rows_deleted_fltc := s_rows_deleted_fltc + sql%rowcount; --FND_LOG_TRANSACTION_CONTEXT

979: and NOT EXISTS
980: (select null from FND_LOG_MESSAGES flm WHERE flm.TRANSACTION_CONTEXT_ID=p_TrList(ii));
981:
982: l_retu := sql%rowcount;
983: s_rows_deleted_fltc := s_rows_deleted_fltc + sql%rowcount; --FND_LOG_TRANSACTION_CONTEXT
984: doCommit;
985: return l_retu;
986: fdebug('End Del FND_LOG_TRANSACTION_CONTEXT');
987:

Line 986: fdebug('End Del FND_LOG_TRANSACTION_CONTEXT');

982: l_retu := sql%rowcount;
983: s_rows_deleted_fltc := s_rows_deleted_fltc + sql%rowcount; --FND_LOG_TRANSACTION_CONTEXT
984: doCommit;
985: return l_retu;
986: fdebug('End Del FND_LOG_TRANSACTION_CONTEXT');
987:
988: EXCEPTION
989: when others then
990: fdebug('Failed in DEL_METR_TRANS_INFO');

Line 1066: FND_LOG_EXCEPTIONS fle

1062: --Collect l_UEXList
1063: l_UEXList1 := l_UEXListNull;
1064: select distinct flue.UNIQUE_EXCEPTION_ID BULK COLLECT into l_UEXList1
1065: from
1066: FND_LOG_EXCEPTIONS fle
1067: , FND_LOG_UNIQUE_EXCEPTIONS flue
1068: where
1069: fle.TRANSACTION_CONTEXT_ID = l_TrnCtxIdList(ii)
1070: and flue.UNIQUE_EXCEPTION_ID = fle.UNIQUE_EXCEPTION_ID ---

Line 1067: , FND_LOG_UNIQUE_EXCEPTIONS flue

1063: l_UEXList1 := l_UEXListNull;
1064: select distinct flue.UNIQUE_EXCEPTION_ID BULK COLLECT into l_UEXList1
1065: from
1066: FND_LOG_EXCEPTIONS fle
1067: , FND_LOG_UNIQUE_EXCEPTIONS flue
1068: where
1069: fle.TRANSACTION_CONTEXT_ID = l_TrnCtxIdList(ii)
1070: and flue.UNIQUE_EXCEPTION_ID = fle.UNIQUE_EXCEPTION_ID ---
1071: and flue.STATUS = 'C';

Line 1082: select LOG_SEQUENCE from FND_LOG_MESSAGES flm

1078: l_LogSeqList1 := l_LogSeqListNull;
1079: select LOG_SEQUENCE BULK COLLECT into l_LogSeqList1
1080: from
1081: (
1082: select LOG_SEQUENCE from FND_LOG_MESSAGES flm
1083: where flm.TRANSACTION_CONTEXT_ID = l_TrnCtxIdList(ii)
1084: union
1085: select LOG_SEQUENCE from FND_LOG_EXCEPTIONS fle
1086: where fle.TRANSACTION_CONTEXT_ID = l_TrnCtxIdList(ii)

Line 1085: select LOG_SEQUENCE from FND_LOG_EXCEPTIONS fle

1081: (
1082: select LOG_SEQUENCE from FND_LOG_MESSAGES flm
1083: where flm.TRANSACTION_CONTEXT_ID = l_TrnCtxIdList(ii)
1084: union
1085: select LOG_SEQUENCE from FND_LOG_EXCEPTIONS fle
1086: where fle.TRANSACTION_CONTEXT_ID = l_TrnCtxIdList(ii)
1087: and NOT EXISTS(select null from FND_LOG_MESSAGES flm1 where flm1.LOG_SEQUENCE=fle.LOG_SEQUENCE)
1088: );
1089: ---fdebug('l_LogSeqList1.count=' || l_LogSeqList1.count);

Line 1087: and NOT EXISTS(select null from FND_LOG_MESSAGES flm1 where flm1.LOG_SEQUENCE=fle.LOG_SEQUENCE)

1083: where flm.TRANSACTION_CONTEXT_ID = l_TrnCtxIdList(ii)
1084: union
1085: select LOG_SEQUENCE from FND_LOG_EXCEPTIONS fle
1086: where fle.TRANSACTION_CONTEXT_ID = l_TrnCtxIdList(ii)
1087: and NOT EXISTS(select null from FND_LOG_MESSAGES flm1 where flm1.LOG_SEQUENCE=fle.LOG_SEQUENCE)
1088: );
1089: ---fdebug('l_LogSeqList1.count=' || l_LogSeqList1.count);
1090: mergelist(l_LogSeqList, l_LogSeqList1);
1091:

Line 1192: delete from FND_LOG_ATTACHMENTS fla where NOT EXISTS

1188: DELETE_EXCEPTIONS_NULL_TRID(l_retCode, X_START_DATE, X_END_DATE);
1189: commit;
1190:
1191: --Delete abondoned attachements
1192: delete from FND_LOG_ATTACHMENTS fla where NOT EXISTS
1193: (select null from FND_LOG_EXCEPTIONS fle where fle.LOG_SEQUENCE = fla.LOG_SEQUENCE)
1194: and NOT EXISTS (select null from FND_LOG_MESSAGES flm where flm.LOG_SEQUENCE = fla.LOG_SEQUENCE );
1195: commit;
1196:

Line 1193: (select null from FND_LOG_EXCEPTIONS fle where fle.LOG_SEQUENCE = fla.LOG_SEQUENCE)

1189: commit;
1190:
1191: --Delete abondoned attachements
1192: delete from FND_LOG_ATTACHMENTS fla where NOT EXISTS
1193: (select null from FND_LOG_EXCEPTIONS fle where fle.LOG_SEQUENCE = fla.LOG_SEQUENCE)
1194: and NOT EXISTS (select null from FND_LOG_MESSAGES flm where flm.LOG_SEQUENCE = fla.LOG_SEQUENCE );
1195: commit;
1196:
1197: --delete the abondoned unique exceptions;

Line 1194: and NOT EXISTS (select null from FND_LOG_MESSAGES flm where flm.LOG_SEQUENCE = fla.LOG_SEQUENCE );

1190:
1191: --Delete abondoned attachements
1192: delete from FND_LOG_ATTACHMENTS fla where NOT EXISTS
1193: (select null from FND_LOG_EXCEPTIONS fle where fle.LOG_SEQUENCE = fla.LOG_SEQUENCE)
1194: and NOT EXISTS (select null from FND_LOG_MESSAGES flm where flm.LOG_SEQUENCE = fla.LOG_SEQUENCE );
1195: commit;
1196:
1197: --delete the abondoned unique exceptions;
1198: DELETE_UNIQUEA_EXCEPTIONS_INFO(l_retCode);

Line 1202: --fnd_log_transaction_context.

1198: DELETE_UNIQUEA_EXCEPTIONS_INFO(l_retCode);
1199: commit;
1200:
1201: --Delete the messages whose transaction context id doesn't exist in
1202: --fnd_log_transaction_context.
1203: DELETE_MESSAGES_INVALID_TRID(l_retCode, X_START_DATE, X_END_DATE);
1204: commit;
1205:
1206: printCount;

Line 1421: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1417: msgbuf varchar2(2000);
1418: last_dt DATE;
1419: begin
1420:
1421: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1422: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1423: c_log_head || l_api_name || '.begin',
1424: c_pkg_name || '.' ||l_api_name ||'(' ||
1425: 'last_date=>'|| last_date||');');

Line 1422: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1418: last_dt DATE;
1419: begin
1420:
1421: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1422: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1423: c_log_head || l_api_name || '.begin',
1424: c_pkg_name || '.' ||l_api_name ||'(' ||
1425: 'last_date=>'|| last_date||');');
1426: end if;

Line 1438: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1434: errbuf := 'Unexpected error converting character string to date:'
1435: ||last_date;
1436: retcode := '2';
1437: FND_FILE.put_line(FND_FILE.log,errbuf);
1438: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1439: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1440: c_log_head || l_api_name || '.end_exception',
1441: 'returning from delete_by_date with date exception. last_date='
1442: ||last_date);

Line 1439: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1435: ||last_date;
1436: retcode := '2';
1437: FND_FILE.put_line(FND_FILE.log,errbuf);
1438: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1439: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1440: c_log_head || l_api_name || '.end_exception',
1441: 'returning from delete_by_date with date exception. last_date='
1442: ||last_date);
1443: end if;

Line 1449: fnd_message.set_token('ENTITY', 'FND_LOG_MESSAGES');

1445: end if;
1446: end if;
1447:
1448: fnd_message.set_name('FND', 'PURGING_UP_TO_DATE');
1449: fnd_message.set_token('ENTITY', 'FND_LOG_MESSAGES');
1450: if (last_date is NULL) then
1451: fnd_message.set_token('DATE', 'WF_ALL', TRUE);
1452: else
1453: fnd_message.set_token('DATE', last_date);

Line 1466: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1462: fnd_message.set_token('ROWS', numrows);
1463: msgbuf := fnd_message.get;
1464: FND_FILE.put_line(FND_FILE.log, msgbuf);
1465:
1466: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1467: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1468: c_log_head || l_api_name || '.end',
1469: 'returning from delete_by_date_i. numrows='||numrows);
1470: end if;

Line 1467: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1463: msgbuf := fnd_message.get;
1464: FND_FILE.put_line(FND_FILE.log, msgbuf);
1465:
1466: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1467: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1468: c_log_head || l_api_name || '.end',
1469: 'returning from delete_by_date_i. numrows='||numrows);
1470: end if;
1471: exception

Line 1476: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1472: when others then
1473: errbuf := sqlerrm;
1474: retcode := '2';
1475: FND_FILE.put_line(FND_FILE.log,errbuf);
1476: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1477: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1478: c_log_head || l_api_name || '.end_exception',
1479: 'returning from delete_by_date with exception. numrows='||numrows);
1480: end if;

Line 1477: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1473: errbuf := sqlerrm;
1474: retcode := '2';
1475: FND_FILE.put_line(FND_FILE.log,errbuf);
1476: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1477: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1478: c_log_head || l_api_name || '.end_exception',
1479: 'returning from delete_by_date with exception. numrows='||numrows);
1480: end if;
1481: raise;

Line 1487: /* Delete data from fnd_log_messages only - Used by Java UI */

1483:
1484:
1485:
1486:
1487: /* Delete data from fnd_log_messages only - Used by Java UI */
1488:
1489: function delete_by_sequence(
1490: pLogSeqList IN VARCHAR2) return NUMBER is
1491: begin

Line 1498: delete from FND_LOG_MESSAGES flm

1494: if ( pLogSeqList is null ) then
1495: return 0;
1496: end if;
1497:
1498: delete from FND_LOG_MESSAGES flm
1499: where
1500: flm.LOG_SEQUENCE = pLogSeqList;
1501: fdebug ('Out - delete_by_Sequence');
1502: commit;

Line 1507: /* Delet data from fnd_log_messages only - Used by Java UI */

1503: return 1;
1504: end delete_by_sequence;
1505:
1506: ------------------------------------------------------------------------------------------------
1507: /* Delet data from fnd_log_messages only - Used by Java UI */
1508: function delete_by_seqarray(numArrayList IN FND_ARRAY_OF_NUMBER_25) return NUMBER is
1509: ii number := 0;
1510: begin
1511: fdebug ('In - delete_by_seqarray');

Line 1514: FND_LOG_MESSAGES flm where flm.LOG_SEQUENCE = numArrayList(ii);

1510: begin
1511: fdebug ('In - delete_by_seqarray');
1512: for ii in numArrayList.FIRST..numArrayList.LAST loop
1513: delete from
1514: FND_LOG_MESSAGES flm where flm.LOG_SEQUENCE = numArrayList(ii);
1515: END LOOP;
1516: commit;
1517: fdebug ('Out - delete_by_seqarray, deleted ' || numArrayList.COUNT || ' rows');
1518: return numArrayList.COUNT;

Line 1615: delete from fnd_log_messages where user_id = 62202999;

1611: begin
1612: result := result
1613: || 'If successful, the following will be a string of all 1s:';
1614:
1615: delete from fnd_log_messages where user_id = 62202999;
1616:
1617: insert into fnd_log_messages
1618: (module, log_level, message_text, session_id, user_id,
1619: timestamp, log_sequence)

Line 1617: insert into fnd_log_messages

1613: || 'If successful, the following will be a string of all 1s:';
1614:
1615: delete from fnd_log_messages where user_id = 62202999;
1616:
1617: insert into fnd_log_messages
1618: (module, log_level, message_text, session_id, user_id,
1619: timestamp, log_sequence)
1620: values
1621: ('fnd.src.dict.afdict.afdwarn.tom_test_module', 5,

Line 1625: rows := fnd_log_admin.delete_by_user(62202999);

1621: ('fnd.src.dict.afdict.afdwarn.tom_test_module', 5,
1622: 'This is a test log message', 62202999, 62202999,
1623: to_date(test_date, test_mask), 62202999);
1624:
1625: rows := fnd_log_admin.delete_by_user(62202999);
1626: result := result || rows ;
1627:
1628:
1629:

Line 1630: delete from fnd_log_messages where user_id = 62202999;

1626: result := result || rows ;
1627:
1628:
1629:
1630: delete from fnd_log_messages where user_id = 62202999;
1631:
1632: insert into fnd_log_messages
1633: (module, log_level, message_text, session_id, user_id,
1634: timestamp, log_sequence)

Line 1632: insert into fnd_log_messages

1628:
1629:
1630: delete from fnd_log_messages where user_id = 62202999;
1631:
1632: insert into fnd_log_messages
1633: (module, log_level, message_text, session_id, user_id,
1634: timestamp, log_sequence)
1635: values
1636: ('fnd.src.dict.afdict.afdwarn.tom_test_module', 5,

Line 1640: rows := fnd_log_admin.delete_by_session(62202999);

1636: ('fnd.src.dict.afdict.afdwarn.tom_test_module', 5,
1637: 'This is a test log message', 62202999, 62202999,
1638: to_date(test_date, test_mask), 62202999);
1639:
1640: rows := fnd_log_admin.delete_by_session(62202999);
1641: result := result || rows ;
1642:
1643:
1644:

Line 1646: delete from fnd_log_messages where user_id = 62202999;

1642:
1643:
1644:
1645:
1646: delete from fnd_log_messages where user_id = 62202999;
1647:
1648: insert into fnd_log_messages
1649: (module, log_level, message_text, session_id, user_id,
1650: timestamp, log_sequence)

Line 1648: insert into fnd_log_messages

1644:
1645:
1646: delete from fnd_log_messages where user_id = 62202999;
1647:
1648: insert into fnd_log_messages
1649: (module, log_level, message_text, session_id, user_id,
1650: timestamp, log_sequence)
1651: values
1652: ('fnd.src.dict.afdict.afdwarn.tom_test_module', 5,

Line 1657: -- rows := fnd_log_admin.delete_by_date_range(SYSDATE+499,NULL);

1653: 'This is a test log message', 62202999, 62202999,
1654: to_date(SYSDATE+500, test_mask), 62202999);
1655:
1656: /* Dangerous so not doing this test */
1657: -- rows := fnd_log_admin.delete_by_date_range(SYSDATE+499,NULL);
1658: -- result := result || rows ;
1659:
1660:
1661:

Line 1663: delete from fnd_log_messages where user_id = 62202999;

1659:
1660:
1661:
1662:
1663: delete from fnd_log_messages where user_id = 62202999;
1664:
1665: insert into fnd_log_messages
1666: (module, log_level, message_text, session_id, user_id,
1667: timestamp, log_sequence)

Line 1665: insert into fnd_log_messages

1661:
1662:
1663: delete from fnd_log_messages where user_id = 62202999;
1664:
1665: insert into fnd_log_messages
1666: (module, log_level, message_text, session_id, user_id,
1667: timestamp, log_sequence)
1668: values
1669: ('fnd.src.dict.afdict.afdwarn.tom_test_module', 5,

Line 1673: rows := fnd_log_admin.delete_by_date_range(SYSDATE+499, SYSDATE+501);

1669: ('fnd.src.dict.afdict.afdwarn.tom_test_module', 5,
1670: 'This is a test log message', 62202999, 62202999,
1671: to_date(SYSDATE+500, test_mask), 62202999);
1672:
1673: rows := fnd_log_admin.delete_by_date_range(SYSDATE+499, SYSDATE+501);
1674: result := result || rows ;
1675:
1676:
1677:

Line 1679: delete from fnd_log_messages where user_id = 62202999;

1675:
1676:
1677:
1678:
1679: delete from fnd_log_messages where user_id = 62202999;
1680:
1681: insert into fnd_log_messages
1682: (module, log_level, message_text, session_id, user_id,
1683: timestamp, log_sequence)

Line 1681: insert into fnd_log_messages

1677:
1678:
1679: delete from fnd_log_messages where user_id = 62202999;
1680:
1681: insert into fnd_log_messages
1682: (module, log_level, message_text, session_id, user_id,
1683: timestamp, log_sequence)
1684: values
1685: ('fnd.src.dict.afdict.afdwarn.tom_test_module', 5,

Line 1690: -- rows := fnd_log_admin.delete_by_date_range(NULL,SYSDATE+501);

1686: 'This is a test log message', 62202999, 62202999,
1687: to_date(SYSDATE+500, test_mask), 62202999);
1688:
1689: /* Not doing this test because it's destructive */
1690: -- rows := fnd_log_admin.delete_by_date_range(NULL,SYSDATE+501);
1691: -- result := result || rows ;
1692:
1693:
1694:

Line 1696: delete from fnd_log_messages where user_id = 62202999;

1692:
1693:
1694:
1695:
1696: delete from fnd_log_messages where user_id = 62202999;
1697:
1698: insert into fnd_log_messages
1699: (module, log_level, message_text, session_id, user_id,
1700: timestamp, log_sequence)

Line 1698: insert into fnd_log_messages

1694:
1695:
1696: delete from fnd_log_messages where user_id = 62202999;
1697:
1698: insert into fnd_log_messages
1699: (module, log_level, message_text, session_id, user_id,
1700: timestamp, log_sequence)
1701: values
1702: ('fnd.src.dict.afdict.afdwarn.tom_test_module', 1,

Line 1707: -- rows := fnd_log_admin.delete_by_max_level(1);

1703: 'This is a test log message', 62202999, 62202999,
1704: to_date(test_date, test_mask), 62202999);
1705:
1706: /* Not doing this test because it's destructive */
1707: -- rows := fnd_log_admin.delete_by_max_level(1);
1708: -- result := result || rows ;
1709:
1710:
1711:

Line 1713: delete from fnd_log_messages where user_id = 62202999;

1709:
1710:
1711:
1712:
1713: delete from fnd_log_messages where user_id = 62202999;
1714:
1715: insert into fnd_log_messages
1716: (module, log_level, message_text, session_id, user_id,
1717: timestamp, log_sequence)

Line 1715: insert into fnd_log_messages

1711:
1712:
1713: delete from fnd_log_messages where user_id = 62202999;
1714:
1715: insert into fnd_log_messages
1716: (module, log_level, message_text, session_id, user_id,
1717: timestamp, log_sequence)
1718: values
1719: ('fnd.src.dict.afdict.afdwarn.tom_test_module', 5,

Line 1723: rows := fnd_log_admin.delete_by_user_session(62202999, 62202999);

1719: ('fnd.src.dict.afdict.afdwarn.tom_test_module', 5,
1720: 'This is a test log message', 62202999, 62202999,
1721: to_date(test_date, test_mask), 62202999);
1722:
1723: rows := fnd_log_admin.delete_by_user_session(62202999, 62202999);
1724: result := result || rows ;
1725:
1726:
1727:

Line 1729: insert into fnd_log_messages

1725:
1726:
1727:
1728:
1729: insert into fnd_log_messages
1730: (module, log_level, message_text, session_id, user_id,
1731: timestamp, log_sequence)
1732: values
1733: ('fnd.src.dict.afdict.afdwarn.tom_test_module', 5,

Line 1737: rows := fnd_log_admin.delete_by_module(

1733: ('fnd.src.dict.afdict.afdwarn.tom_test_module', 5,
1734: 'This is a test log message', 62202999, 62202999,
1735: to_date(test_date, test_mask), 62202999);
1736:
1737: rows := fnd_log_admin.delete_by_module(
1738: 'fnd.src.dict.afdict.afdwarn.tom_test_module');
1739: result := result || rows;
1740:
1741:

Line 1746: end FND_LOG_ADMIN;

1742:
1743: return result;
1744: end SELF_TEST;
1745:
1746: end FND_LOG_ADMIN;