APPS.FND_SEARCH_EVENT dependencies on FND_LOG

Line 7: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

3:
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

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 16: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

12: set CRAWL_STATUS='Y'
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';

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 22: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

18: 'Change Log is empty for this object');
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';

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 33: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

29:
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

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 55: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

51: AND CRAWL_STATUS='Y';
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';

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 61: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

57: 'Change log is empty for this object');
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:

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 74: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

70:
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

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 99: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

95: AND CRAWL_STATUS='Y';
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';

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 105: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

101: 'Change log is empty for this object');
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:

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 138: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

134: status varchar2(1);
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');

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 203: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

199: Sysdate,
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';

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