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_MESSAGES

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 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 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 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 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 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 901: (select null from FND_LOG_MESSAGES flm WHERE flm.TRANSACTION_CONTEXT_ID=p_TrList(ii));

897: delete from FND_LOG_TRANSACTION_CONTEXT where TRANSACTION_CONTEXT_ID=p_TrList(ii)
898: and NOT EXISTS
899: (select null from FND_LOG_EXCEPTIONS fle WHERE fle.TRANSACTION_CONTEXT_ID=p_TrList(ii))
900: and NOT EXISTS
901: (select null from FND_LOG_MESSAGES flm WHERE flm.TRANSACTION_CONTEXT_ID=p_TrList(ii));
902:
903: l_retu := sql%rowcount;
904: s_rows_deleted_fltc := s_rows_deleted_fltc + sql%rowcount; --FND_LOG_TRANSACTION_CONTEXT
905: doCommit;

Line 1003: select LOG_SEQUENCE from FND_LOG_MESSAGES flm

999: l_LogSeqList1 := l_LogSeqListNull;
1000: select LOG_SEQUENCE BULK COLLECT into l_LogSeqList1
1001: from
1002: (
1003: select LOG_SEQUENCE from FND_LOG_MESSAGES flm
1004: where flm.TRANSACTION_CONTEXT_ID = l_TrnCtxIdList(ii)
1005: union
1006: select LOG_SEQUENCE from FND_LOG_EXCEPTIONS fle
1007: where fle.TRANSACTION_CONTEXT_ID = l_TrnCtxIdList(ii)

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

1004: where flm.TRANSACTION_CONTEXT_ID = l_TrnCtxIdList(ii)
1005: union
1006: select LOG_SEQUENCE from FND_LOG_EXCEPTIONS fle
1007: where fle.TRANSACTION_CONTEXT_ID = l_TrnCtxIdList(ii)
1008: and NOT EXISTS(select null from FND_LOG_MESSAGES flm1 where flm1.LOG_SEQUENCE=fle.LOG_SEQUENCE)
1009: );
1010: ---fdebug('l_LogSeqList1.count=' || l_LogSeqList1.count);
1011: mergelist(l_LogSeqList, l_LogSeqList1);
1012:

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

1111:
1112: --Delete abondoned attachements
1113: delete from FND_LOG_ATTACHMENTS fla where NOT EXISTS
1114: (select null from FND_LOG_EXCEPTIONS fle where fle.LOG_SEQUENCE = fla.LOG_SEQUENCE)
1115: and NOT EXISTS (select null from FND_LOG_MESSAGES flm where flm.LOG_SEQUENCE = fla.LOG_SEQUENCE );
1116: commit;
1117:
1118: --delete the abondoned unque exceptions;
1119: DELETE_UNIQUEA_EXCEPTIONS_INFO(l_retCode);

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

1361: end if;
1362: end if;
1363:
1364: fnd_message.set_name('FND', 'PURGING_UP_TO_DATE');
1365: fnd_message.set_token('ENTITY', 'FND_LOG_MESSAGES');
1366: if (last_date is NULL) then
1367: fnd_message.set_token('DATE', 'WF_ALL', TRUE);
1368: else
1369: fnd_message.set_token('DATE', last_date);

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

1399:
1400:
1401:
1402:
1403: /* Delete data from fnd_log_messages only - Used by Java UI */
1404:
1405: function delete_by_sequence(
1406: pLogSeqList IN VARCHAR2) return NUMBER is
1407: begin

Line 1414: delete from FND_LOG_MESSAGES flm

1410: if ( pLogSeqList is null ) then
1411: return 0;
1412: end if;
1413:
1414: delete from FND_LOG_MESSAGES flm
1415: where
1416: flm.LOG_SEQUENCE = pLogSeqList;
1417: fdebug ('Out - delete_by_Sequence');
1418: commit;

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

1419: return 1;
1420: end delete_by_sequence;
1421:
1422: ------------------------------------------------------------------------------------------------
1423: /* Delet data from fnd_log_messages only - Used by Java UI */
1424: function delete_by_seqarray(numArrayList IN FND_ARRAY_OF_NUMBER_25) return NUMBER is
1425: ii number := 0;
1426: begin
1427: fdebug ('In - delete_by_seqarray');

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

1426: begin
1427: fdebug ('In - delete_by_seqarray');
1428: for ii in numArrayList.FIRST..numArrayList.LAST loop
1429: delete from
1430: FND_LOG_MESSAGES flm where flm.LOG_SEQUENCE = numArrayList(ii);
1431: END LOOP;
1432: commit;
1433: fdebug ('Out - delete_by_seqarray, deleted ' || numArrayList.COUNT || ' rows');
1434: return numArrayList.COUNT;

Line 1531: delete from fnd_log_messages where user_id = 62202999;

1527: begin
1528: result := result
1529: || 'If successful, the following will be a string of all 1s:';
1530:
1531: delete from fnd_log_messages where user_id = 62202999;
1532:
1533: insert into fnd_log_messages
1534: (module, log_level, message_text, session_id, user_id,
1535: timestamp, log_sequence)

Line 1533: insert into fnd_log_messages

1529: || 'If successful, the following will be a string of all 1s:';
1530:
1531: delete from fnd_log_messages where user_id = 62202999;
1532:
1533: insert into fnd_log_messages
1534: (module, log_level, message_text, session_id, user_id,
1535: timestamp, log_sequence)
1536: values
1537: ('fnd.src.dict.afdict.afdwarn.tom_test_module', 5,

Line 1546: delete from fnd_log_messages where user_id = 62202999;

1542: result := result || rows ;
1543:
1544:
1545:
1546: delete from fnd_log_messages where user_id = 62202999;
1547:
1548: insert into fnd_log_messages
1549: (module, log_level, message_text, session_id, user_id,
1550: timestamp, log_sequence)

Line 1548: insert into fnd_log_messages

1544:
1545:
1546: delete from fnd_log_messages where user_id = 62202999;
1547:
1548: insert into fnd_log_messages
1549: (module, log_level, message_text, session_id, user_id,
1550: timestamp, log_sequence)
1551: values
1552: ('fnd.src.dict.afdict.afdwarn.tom_test_module', 5,

Line 1562: delete from fnd_log_messages where user_id = 62202999;

1558:
1559:
1560:
1561:
1562: delete from fnd_log_messages where user_id = 62202999;
1563:
1564: insert into fnd_log_messages
1565: (module, log_level, message_text, session_id, user_id,
1566: timestamp, log_sequence)

Line 1564: insert into fnd_log_messages

1560:
1561:
1562: delete from fnd_log_messages where user_id = 62202999;
1563:
1564: insert into fnd_log_messages
1565: (module, log_level, message_text, session_id, user_id,
1566: timestamp, log_sequence)
1567: values
1568: ('fnd.src.dict.afdict.afdwarn.tom_test_module', 5,

Line 1579: delete from fnd_log_messages where user_id = 62202999;

1575:
1576:
1577:
1578:
1579: delete from fnd_log_messages where user_id = 62202999;
1580:
1581: insert into fnd_log_messages
1582: (module, log_level, message_text, session_id, user_id,
1583: timestamp, log_sequence)

Line 1581: insert into fnd_log_messages

1577:
1578:
1579: delete from fnd_log_messages where user_id = 62202999;
1580:
1581: insert into fnd_log_messages
1582: (module, log_level, message_text, session_id, user_id,
1583: timestamp, log_sequence)
1584: values
1585: ('fnd.src.dict.afdict.afdwarn.tom_test_module', 5,

Line 1595: delete from fnd_log_messages where user_id = 62202999;

1591:
1592:
1593:
1594:
1595: delete from fnd_log_messages where user_id = 62202999;
1596:
1597: insert into fnd_log_messages
1598: (module, log_level, message_text, session_id, user_id,
1599: timestamp, log_sequence)

Line 1597: insert into fnd_log_messages

1593:
1594:
1595: delete from fnd_log_messages where user_id = 62202999;
1596:
1597: insert into fnd_log_messages
1598: (module, log_level, message_text, session_id, user_id,
1599: timestamp, log_sequence)
1600: values
1601: ('fnd.src.dict.afdict.afdwarn.tom_test_module', 5,

Line 1612: delete from fnd_log_messages where user_id = 62202999;

1608:
1609:
1610:
1611:
1612: delete from fnd_log_messages where user_id = 62202999;
1613:
1614: insert into fnd_log_messages
1615: (module, log_level, message_text, session_id, user_id,
1616: timestamp, log_sequence)

Line 1614: insert into fnd_log_messages

1610:
1611:
1612: delete from fnd_log_messages where user_id = 62202999;
1613:
1614: insert into fnd_log_messages
1615: (module, log_level, message_text, session_id, user_id,
1616: timestamp, log_sequence)
1617: values
1618: ('fnd.src.dict.afdict.afdwarn.tom_test_module', 1,

Line 1629: delete from fnd_log_messages where user_id = 62202999;

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

Line 1631: insert into fnd_log_messages

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

Line 1645: insert into fnd_log_messages

1641:
1642:
1643:
1644:
1645: insert into fnd_log_messages
1646: (module, log_level, message_text, session_id, user_id,
1647: timestamp, log_sequence)
1648: values
1649: ('fnd.src.dict.afdict.afdwarn.tom_test_module', 5,