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_SEARCH_EVENT dependencies on FND_SEARCH_EVENT

Line 1: package body FND_SEARCH_EVENT as

1: package body FND_SEARCH_EVENT as
2: -- $Header: FNDCLGEHB.pls 120.1.12010000.1 2008/07/25 14:24:28 appldev ship $
3:
4: FUNCTION Start_Crawl(obj_name in varchar2) return VARCHAR2
5: IS

Line 8: fnd_log.string(FND_LOG.LEVEL_STATEMENT, 'FND_SEARCH_EVENT.START_CRAWL',

4: FUNCTION Start_Crawl(obj_name in varchar2) return VARCHAR2
5: IS
6: BEGIN
7: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
8: fnd_log.string(FND_LOG.LEVEL_STATEMENT, 'FND_SEARCH_EVENT.START_CRAWL',
9: 'Begin Start_Crawl to initialize crawl status in change log');
10: end if;
11: UPDATE FND_SEARCHABLE_CHANGE_LOG
12: set CRAWL_STATUS='Y'

Line 17: fnd_log.string(FND_LOG.LEVEL_STATEMENT, 'FND_SEARCH_EVENT.START_CRAWL',

13: where object_name=obj_name;
14:
15: if (sql%rowcount=0) then
16: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
17: fnd_log.string(FND_LOG.LEVEL_STATEMENT, 'FND_SEARCH_EVENT.START_CRAWL',
18: 'Change Log is empty for this object');
19: end if;
20: return 'ERROR';
21: else

Line 23: fnd_log.string(FND_LOG.LEVEL_STATEMENT, 'FND_SEARCH_EVENT.START_CRAWL',

19: end if;
20: return 'ERROR';
21: else
22: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
23: fnd_log.string(FND_LOG.LEVEL_STATEMENT, 'FND_SEARCH_EVENT.START_CRAWL',
24: 'End Start_Crawl');
25: end if;
26: return 'SUCCESS';
27: end if;

Line 34: fnd_log.string(FND_LOG.LEVEL_STATEMENT, 'FND_SEARCH_EVENT.END_CRAWL',

30: FUNCTION End_Crawl(obj_name in varchar2,change_type in varchar2) return VARCHAR2
31: IS
32: BEGIN
33: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
34: fnd_log.string(FND_LOG.LEVEL_STATEMENT, 'FND_SEARCH_EVENT.END_CRAWL',
35: 'Begin End_Crawl to remove crawled entries from the change log');
36: end if;
37: if (change_type='EVENT') then
38: DELETE FROM FND_SEARCHABLE_CHANGE_LOG

Line 56: fnd_log.string(FND_LOG.LEVEL_STATEMENT, 'FND_SEARCH_EVENT.END_CRAWL',

52: end if;
53:
54: if (sql%rowcount=0) then
55: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
56: fnd_log.string(FND_LOG.LEVEL_STATEMENT, 'FND_SEARCH_EVENT.END_CRAWL',
57: 'Change log is empty for this object');
58: end if;
59: return 'ERROR';
60: else

Line 62: fnd_log.string(FND_LOG.LEVEL_STATEMENT, 'FND_SEARCH_EVENT.END_CRAWL',

58: end if;
59: return 'ERROR';
60: else
61: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
62: fnd_log.string(FND_LOG.LEVEL_STATEMENT, 'FND_SEARCH_EVENT.END_CRAWL',
63: 'End End_Crawl ');
64: end if;
65:
66: return 'SUCCESS';

Line 75: fnd_log.string(FND_LOG.LEVEL_STATEMENT, 'FND_SEARCH_EVENT.END_CRAWL',

71: FUNCTION Reset_Crawl(obj_name in varchar2,change_type in varchar2) return VARCHAR2
72: IS
73: BEGIN
74: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
75: fnd_log.string(FND_LOG.LEVEL_STATEMENT, 'FND_SEARCH_EVENT.END_CRAWL',
76: 'Begin Reset_Crawl to reset entries that errored out during crawl');
77: end if;
78: if (change_type='EVENT') then
79: UPDATE FND_SEARCHABLE_CHANGE_LOG

Line 100: fnd_log.string(FND_LOG.LEVEL_STATEMENT, 'FND_SEARCH_EVENT.RESET_CRAWL',

96: end if;
97:
98: if (sql%rowcount=0) then
99: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
100: fnd_log.string(FND_LOG.LEVEL_STATEMENT, 'FND_SEARCH_EVENT.RESET_CRAWL',
101: 'Change log is empty for this object');
102: end if;
103: return 'ERROR';
104: else

Line 106: fnd_log.string(FND_LOG.LEVEL_STATEMENT, 'FND_SEARCH_EVENT.RESET_CRAWL',

102: end if;
103: return 'ERROR';
104: else
105: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
106: fnd_log.string(FND_LOG.LEVEL_STATEMENT, 'FND_SEARCH_EVENT.RESET_CRAWL',
107: 'End Reset_Crawl ');
108: end if;
109:
110: return 'SUCCESS';

Line 139: fnd_log.string(FND_LOG.LEVEL_STATEMENT, 'FND_SEARCH_EVENT.ON_OBJECT_CHANGE',

135: feed_url varchar2(4000);
136:
137: BEGIN
138: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
139: fnd_log.string(FND_LOG.LEVEL_STATEMENT, 'FND_SEARCH_EVENT.ON_OBJECT_CHANGE',
140: 'Begin On_Object_Change');
141: end if;
142: object_name := p_event.GetValueForParameter('OBJECT_NAME');
143: change_type := p_event.GetValueForParameter('CHANGE_TYPE');

Line 183: FND_SEARCH_EVENTS_SEQ.nextVal,

179: CRAWL_STATUS,
180: DATA_FEED_URL
181: )values
182: (
183: FND_SEARCH_EVENTS_SEQ.nextVal,
184: object_name,
185: change_type ,
186: id_type,
187: row_id_from,

Line 204: fnd_log.string(FND_LOG.LEVEL_STATEMENT, 'FND_SEARCH_EVENT.ON_OBJECT_CHANGE',

200: status,
201: feed_url
202: );
203: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
204: fnd_log.string(FND_LOG.LEVEL_STATEMENT, 'FND_SEARCH_EVENT.ON_OBJECT_CHANGE',
205: 'End On_Object_Change');
206: end if;
207: return 'SUCCESS';
208: exception

Line 210: WF_CORE.CONTEXT('FND_SEARCH_EVENTS', 'On_Object_Change',

206: end if;
207: return 'SUCCESS';
208: exception
209: when others then
210: WF_CORE.CONTEXT('FND_SEARCH_EVENTS', 'On_Object_Change',
211: p_event.getEventName( ), p_subscription_guid);
212: WF_EVENT.setErrorInfo(p_event, 'ERROR');
213: return 'ERROR';
214: END On_Object_Change;

Line 217: end FND_SEARCH_EVENT;

213: return 'ERROR';
214: END On_Object_Change;
215:
216:
217: end FND_SEARCH_EVENT;