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.CSM_NEW_MESSAGES_EVENT_PKG dependencies on CSM_UTIL_PKG

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

149: FETCH c_delete BULK COLLECT INTO l_tab;
150: CLOSE c_delete;
151:
152:
153: CSM_UTIL_PKG.LOG('Entering DELETE to remove ' || l_tab.count||' records',
154: 'CSM_NEW_MESSAGES_EVENT_PKG.HANDLE_DELETE',FND_LOG.LEVEL_PROCEDURE);
155:
156: FOR I IN 1..l_tab.COUNT
157: LOOP

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

172: FETCH c_delete_fragment BULK COLLECT INTO l_tab;
173: CLOSE c_delete_fragment;
174:
175:
176: CSM_UTIL_PKG.LOG('Entering DELETE FRAGMENT to remove ' || l_tab.count||' records',
177: 'CSM_NEW_MESSAGES_EVENT_PKG.HANDLE_DELETE',FND_LOG.LEVEL_PROCEDURE);
178:
179: FOR I IN 1..l_tab.COUNT
180: LOOP

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

186:
187: DELETE FROM CSM_NEW_MESSAGES_ACC WHERE ACCESS_ID=l_ACCESS_ID;
188: END LOOP;
189:
190: CSM_UTIL_PKG.LOG('DELETION successful',
191: 'CSM_NEW_MESSAGES_EVENT_PKG.HANDLE_DELETE',FND_LOG.LEVEL_PROCEDURE);
192: p_status :='SUCCESS';
193: p_message :='DELETION in CSM_NEW_MESSAGES_EVENT_PKG.HANDLE_DELETE successful';
194:

Line 202: csm_util_pkg.log('CSM_NEW_MESSAGES_EVENT_PKG.HANDLE_DELETE ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);

198: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
199: p_status := 'ERROR';
200: p_message := 'Error in CSM_NEW_MESSAGES_EVENT_PKG.HANDLE_DELETE: ' || l_sqlerrno || ':' || l_sqlerrmsg;
201: RAISE;
202: csm_util_pkg.log('CSM_NEW_MESSAGES_EVENT_PKG.HANDLE_DELETE ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
203: END HANDLE_DELETE;
204:
205: PROCEDURE REFRESH_ACC(p_status OUT NOCOPY VARCHAR2,
206: p_message OUT NOCOPY VARCHAR2) IS

Line 365: CSM_UTIL_PKG.LOG('Entering REFRESH_ACC: ',

361: l_max_update_date DATE;
362: l_checkupdates VARCHAR2(1) := 'N';
363: BEGIN
364:
365: CSM_UTIL_PKG.LOG('Entering REFRESH_ACC: ',
366: 'CSM_NEW_MESSAGES_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
367:
368: OPEN c_lastrundate;
369: FETCH c_lastrundate INTO l_lastrundate;

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

368: OPEN c_lastrundate;
369: FETCH c_lastrundate INTO l_lastrundate;
370: CLOSE c_lastrundate;
371:
372: CSM_UTIL_PKG.LOG('Got LASTRUNDATE ',
373: 'CSM_NEW_MESSAGES_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
374:
375: --Bug 5409433
376: --DELETE--

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

398: OPEN c_update(l_lastrundate.LAST_RUN_DATE);
399: FETCH c_update BULK COLLECT INTO l_tab;
400: CLOSE c_update;
401:
402: CSM_UTIL_PKG.LOG('Entering UPDATE to update ' || l_tab.count||' records',
403: 'CSM_NEW_MESSAGES_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
404:
405: FOR I IN 1..l_tab.COUNT LOOP
406: l_dummy := asg_download.mark_dirty(g_new_msg_pubi_name,l_tab(I).ACCESS_ID ,

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

417: END LOOP;
418:
419: COMMIT;
420:
421: CSM_UTIL_PKG.LOG('UPDATE Successful ',
422: 'CSM_NEW_MESSAGES_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
423: l_tab.DELETE;
424: END IF;
425:

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

427: OPEN c_insert;
428: FETCH c_insert BULK COLLECT INTO l_tab;
429: CLOSE c_insert;
430:
431: CSM_UTIL_PKG.LOG('Entering INSERT to add ' || l_tab.count||' records',
432: 'CSM_NEW_MESSAGES_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
433:
434: FOR I IN 1..l_tab.COUNT
435: LOOP

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

475: END LOOP;
476:
477: COMMIT;
478:
479: CSM_UTIL_PKG.LOG('INSERTION Successful ',
480: 'CSM_NEW_MESSAGES_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
481:
482: UPDATE JTM_CON_REQUEST_DATA
483: SET LAST_RUN_DATE = SYSDATE

Line 492: CSM_UTIL_PKG.LOG('Leaving REFRESH_ACC: ',

488:
489: p_status := 'FINE';
490: p_message := 'CSM_NEW_MESSAGES_EVENT_PKG.REFRESH_ACC executed successfully';
491:
492: CSM_UTIL_PKG.LOG('Leaving REFRESH_ACC: ',
493: 'CSM_NEW_MESSAGES_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
494:
495: EXCEPTION
496: WHEN OTHERS THEN

Line 502: csm_util_pkg.log('CSM_NEW_MESSAGES_EVENT_PKG.REFRESH_ACC ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);

498: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
499: p_status := 'ERROR';
500: p_message := p_message||': Error in CSM_NEW_MESSAGES_EVENT_PKG.REFRESH_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg;
501: ROLLBACK;
502: csm_util_pkg.log('CSM_NEW_MESSAGES_EVENT_PKG.REFRESH_ACC ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
503:
504: END REFRESH_ACC;
505:
506: --Bug 7239431

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

599: l_access_id NUMBER;
600:
601: BEGIN
602:
603: CSM_UTIL_PKG.LOG('Entering api REFRESH_USER with user id- '||p_user_id,
604: 'CSM_NEW_MESSAGES_EVENT_PKG.REFRESH_USER',FND_LOG.LEVEL_PROCEDURE);
605:
606: DELETE FROM CSM_NEW_MESSAGES_ACC WHERE USER_ID=p_user_id;
607:

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

609: OPEN c_insert(p_user_id);
610: FETCH c_insert BULK COLLECT INTO l_tab;
611: CLOSE c_insert;
612:
613: CSM_UTIL_PKG.LOG('Entering INSERT to add ' || l_tab.count||' records for user',
614: 'CSM_NEW_MESSAGES_EVENT_PKG.REFRESH_USER',FND_LOG.LEVEL_PROCEDURE);
615:
616: FOR I IN 1..l_tab.COUNT
617: LOOP

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

655: l_dummy := asg_download.mark_dirty(g_new_msg_pubi_name,l_access_id , l_tab(I).USER_ID, 'I', sysdate );
656:
657: END LOOP;
658:
659: CSM_UTIL_PKG.LOG('INSERTION Successful ',
660: 'CSM_NEW_MESSAGES_EVENT_PKG.REFRESH_USER',FND_LOG.LEVEL_PROCEDURE);
661:
662: END REFRESH_USER;
663: