APPS.CSM_AD_SRCH_TITLE_EVENT_PKG dependencies on FND_LOG

Line 98: 'CSM_AD_SRCH_TITLE_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

94:
95: BEGIN
96:
97: CSM_UTIL_PKG.LOG('Entering REFRESH_ACC: ',
98: 'CSM_AD_SRCH_TITLE_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
99:
100: OPEN c_lastrundate;
101: FETCH c_lastrundate INTO l_lastrundate;
102: CLOSE c_lastrundate;

Line 105: 'CSM_AD_SRCH_TITLE_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

101: FETCH c_lastrundate INTO l_lastrundate;
102: CLOSE c_lastrundate;
103:
104: CSM_UTIL_PKG.LOG('Got LASTRUNDATE ',
105: 'CSM_AD_SRCH_TITLE_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
106:
107: OPEN c_get_user_list;
108: FETCH c_get_user_list BULK COLLECT INTO l_user_list;
109: CLOSE c_get_user_list;

Line 112: 'CSM_AD_SRCH_TITLE_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

108: FETCH c_get_user_list BULK COLLECT INTO l_user_list;
109: CLOSE c_get_user_list;
110:
111: CSM_UTIL_PKG.LOG('Got USER list : ',
112: 'CSM_AD_SRCH_TITLE_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
113:
114: --delete--
115: OPEN c_delete;
116: FETCH c_delete BULK COLLECT INTO l_tab;

Line 120: 'CSM_AD_SRCH_TITLE_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

116: FETCH c_delete BULK COLLECT INTO l_tab;
117: CLOSE c_delete;
118:
119: CSM_UTIL_PKG.LOG('Entering DELETE to remove ' || l_tab.count||' records',
120: 'CSM_AD_SRCH_TITLE_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
121:
122: FOR I IN 1..l_tab.COUNT
123: LOOP
124: IF l_user_list.COUNT > 0 THEN --Do Mark dirty only if there are valid users

Line 134: 'CSM_AD_SRCH_TITLE_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

130:
131: COMMIT;
132:
133: CSM_UTIL_PKG.LOG('DELETION successful',
134: 'CSM_AD_SRCH_TITLE_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
135:
136: IF l_tab.COUNT > 0 THEN
137: l_tab.DELETE;
138: END IF;

Line 146: 'CSM_AD_SRCH_TITLE_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

142: FETCH c_update BULK COLLECT INTO l_tab;
143: CLOSE c_update;
144:
145: CSM_UTIL_PKG.LOG('Entering UPDATE to update ' || l_tab.count||' records',
146: 'CSM_AD_SRCH_TITLE_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
147:
148: FOR I IN 1..l_tab.COUNT
149: LOOP
150: IF l_user_list.COUNT > 0 THEN --Do Mark dirty only if there are valid users

Line 166: 'CSM_AD_SRCH_TITLE_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

162:
163: COMMIT;
164:
165: CSM_UTIL_PKG.LOG('UPDATE Successful ',
166: 'CSM_AD_SRCH_TITLE_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
167: IF l_tab.COUNT > 0 THEN
168: l_tab.DELETE;
169: END IF;
170:

Line 177: 'CSM_AD_SRCH_TITLE_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

173: FETCH c_insert BULK COLLECT INTO l_tab;
174: CLOSE c_insert;
175:
176: CSM_UTIL_PKG.LOG('Entering INSERT to add ' || l_tab.count||' records',
177: 'CSM_AD_SRCH_TITLE_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
178:
179: FOR I IN 1..l_tab.COUNT
180: LOOP
181: OPEN C_GET_ACCESS_ID;

Line 222: 'CSM_AD_SRCH_TITLE_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

218: l_tab.DELETE;
219: END IF;
220:
221: CSM_UTIL_PKG.LOG('INSERTION Successful ',
222: 'CSM_AD_SRCH_TITLE_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
223:
224: UPDATE JTM_CON_REQUEST_DATA
225: SET LAST_RUN_DATE = SYSDATE
226: WHERE package_name = g_ad_sch_title_pkg_name

Line 235: 'CSM_AD_SRCH_TITLE_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

231: p_status := 'FINE';
232: p_message := 'CSM_AD_SRCH_TITLE_EVENT_PKG.REFRESH_ACC executed successfully';
233:
234: CSM_UTIL_PKG.LOG('Leaving REFRESH_ACC: ',
235: 'CSM_AD_SRCH_TITLE_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
236:
237: EXCEPTION
238: WHEN OTHERS THEN
239: l_sqlerrno := TO_CHAR(SQLCODE);