APPS.CSM_PAGE_PERZ_DELTA_EVENT_PKG dependencies on CSM_UTIL_PKG

Line 179: CSM_UTIL_PKG.LOG('Entering REFRESH_PAGE_PERZ_DELTA: ',

175: l_dummy BOOLEAN;
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;

Line 186: CSM_UTIL_PKG.LOG('Got LASTRUNDATE ',

182: OPEN c_lastrundate;
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;

Line 193: CSM_UTIL_PKG.LOG('Entering DELETE to remove ' || l_tab.count||' records',

189: OPEN c_delete;
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

Line 205: CSM_UTIL_PKG.LOG('DELETION successful',

201: END LOOP;
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:

Line 216: CSM_UTIL_PKG.LOG('Entering UPDATE to update ' || l_tab.count||' records',

212: OPEN c_update(l_lastrundate.LAST_RUN_DATE);
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

Line 238: CSM_UTIL_PKG.LOG('UPDATE Successful ',

234: END LOOP;
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--

Line 247: CSM_UTIL_PKG.LOG('Entering INSERT to add ' || l_tab.count||' records',

243: OPEN c_insert;
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

Line 299: CSM_UTIL_PKG.LOG('INSERTION Successful ',

295: END LOOP;
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

Line 312: CSM_UTIL_PKG.LOG('Leaving REFRESH_PAGE_PERZ_DELTA: ',

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

Line 322: csm_util_pkg.log('CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);

318: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
319: p_status := 'ERROR';
320: p_message := 'Error in CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA: ' || l_sqlerrno || ':' || l_sqlerrmsg;
321: ROLLBACK;
322: csm_util_pkg.log('CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
323:
324: END REFRESH_PAGE_PERZ_DELTA;
325:
326: --7239431

Line 400: CSM_UTIL_PKG.LOG('Entering api REFRESH_USER with user id- '||p_user_id,

396: l_dummy BOOLEAN;
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:

Line 410: CSM_UTIL_PKG.LOG('Entering INSERT to add ' || l_tab.count||' records for user',

406: OPEN c_insert(p_user_id);
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

Line 460: CSM_UTIL_PKG.LOG('INSERTION Successful ',

456: l_dummy := asg_download.mark_dirty(g_page_perz_delta_pubi_name,l_access_id , l_tab(I).USER_ID, 'I', sysdate );
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: