DBA Data[Home] [Help]

APPS.CSM_PAGE_PERZ_DELTA_EVENT_PKG dependencies on FND_LOG

Line 180: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);

176:
177: BEGIN
178:
179: CSM_UTIL_PKG.LOG('Entering REFRESH_PAGE_PERZ_DELTA: ',
180: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);
181:
182: OPEN c_lastrundate;
183: FETCH c_lastrundate INTO l_lastrundate;
184: CLOSE c_lastrundate;

Line 187: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);

183: FETCH c_lastrundate INTO l_lastrundate;
184: CLOSE c_lastrundate;
185:
186: CSM_UTIL_PKG.LOG('Got LASTRUNDATE ',
187: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);
188: --delete--
189: OPEN c_delete;
190: FETCH c_delete BULK COLLECT INTO l_tab;
191: CLOSE c_delete;

Line 194: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);

190: FETCH c_delete BULK COLLECT INTO l_tab;
191: CLOSE c_delete;
192:
193: CSM_UTIL_PKG.LOG('Entering DELETE to remove ' || l_tab.count||' records',
194: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);
195:
196: FOR I IN 1..l_tab.COUNT
197: LOOP
198: l_dummy := asg_download.mark_dirty(g_page_perz_delta_pubi_name,l_tab(I).ACCESS_ID , l_tab(I).USER_ID, 'D', sysdate );

Line 206: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);

202:
203: COMMIT;
204:
205: CSM_UTIL_PKG.LOG('DELETION successful',
206: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);
207:
208: l_tab.DELETE;
209:
210:

Line 217: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);

213: FETCH c_update BULK COLLECT INTO l_tab;
214: CLOSE c_update;
215:
216: CSM_UTIL_PKG.LOG('Entering UPDATE to update ' || l_tab.count||' records',
217: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);
218:
219: FOR I IN 1..l_tab.COUNT
220: LOOP
221: l_dummy := asg_download.mark_dirty(g_page_perz_delta_pubi_name,l_tab(I).ACCESS_ID,l_tab(I).USER_ID, 'U', sysdate );

Line 239: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);

235:
236: COMMIT;
237:
238: CSM_UTIL_PKG.LOG('UPDATE Successful ',
239: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);
240: l_tab.DELETE;
241:
242: --insert--
243: OPEN c_insert;

Line 248: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);

244: FETCH c_insert BULK COLLECT INTO l_tab;
245: CLOSE c_insert;
246:
247: CSM_UTIL_PKG.LOG('Entering INSERT to add ' || l_tab.count||' records',
248: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);
249:
250: FOR I IN 1..l_tab.COUNT
251: LOOP
252: OPEN C_GET_ACCESS_ID;

Line 300: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);

296:
297: COMMIT;
298:
299: CSM_UTIL_PKG.LOG('INSERTION Successful ',
300: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);
301:
302: UPDATE JTM_CON_REQUEST_DATA
303: SET LAST_RUN_DATE = SYSDATE
304: WHERE package_name = g_page_perz_delta_pkg_name

Line 313: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);

309: p_status := 'FINE';
310: p_message := 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA executed successfully';
311:
312: CSM_UTIL_PKG.LOG('Leaving REFRESH_PAGE_PERZ_DELTA: ',
313: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);
314:
315: EXCEPTION
316: WHEN OTHERS THEN
317: l_sqlerrno := TO_CHAR(SQLCODE);

Line 401: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_USER',FND_LOG.LEVEL_PROCEDURE);

397:
398: BEGIN
399:
400: CSM_UTIL_PKG.LOG('Entering api REFRESH_USER with user id- '||p_user_id,
401: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_USER',FND_LOG.LEVEL_PROCEDURE);
402:
403: DELETE FROM CSM_PAGE_PERZ_DELTA_ACC WHERE USER_ID=p_user_id;
404:
405: --insert--

Line 411: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_USER',FND_LOG.LEVEL_PROCEDURE);

407: FETCH c_insert BULK COLLECT INTO l_tab;
408: CLOSE c_insert;
409:
410: CSM_UTIL_PKG.LOG('Entering INSERT to add ' || l_tab.count||' records for user',
411: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_USER',FND_LOG.LEVEL_PROCEDURE);
412:
413: FOR I IN 1..l_tab.COUNT
414: LOOP
415: OPEN C_GET_ACCESS_ID;

Line 461: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_USER',FND_LOG.LEVEL_PROCEDURE);

457:
458: END LOOP;
459:
460: CSM_UTIL_PKG.LOG('INSERTION Successful ',
461: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_USER',FND_LOG.LEVEL_PROCEDURE);
462:
463: END REFRESH_USER;
464:
465: END CSM_PAGE_PERZ_DELTA_EVENT_PKG;