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_NEW_MESSAGES_EVENT_PKG

Line 1: PACKAGE BODY CSM_NEW_MESSAGES_EVENT_PKG AS

1: PACKAGE BODY CSM_NEW_MESSAGES_EVENT_PKG AS
2: /* $Header: csmenmgb.pls 120.13.12010000.2 2008/10/22 12:43:56 trajasek ship $ */
3: /*** Globals ***/
4: g_new_msg_acc_tab_name CONSTANT VARCHAR2(30) := 'CSM_NEW_MESSAGES_ACC';
5: g_new_msg_tl_tab_name CONSTANT VARCHAR2(30) := 'CSM_NEW_MESSAGES_TL';

Line 10: g_new_msg_pkg_name CONSTANT VARCHAR2(30) := 'CSM_NEW_MESSAGES_EVENT_PKG';

6: g_new_msg_perz_tab_name CONSTANT VARCHAR2(30) := 'CSM_NEW_MESSAGES_PERZ';
7: g_new_msg_table_name CONSTANT VARCHAR2(30) := 'CSM_NEW_MESSAGES';
8: g_new_msg_pubi_name CONSTANT VARCHAR2(30) := 'CSM_NEW_MESSAGES';
9:
10: g_new_msg_pkg_name CONSTANT VARCHAR2(30) := 'CSM_NEW_MESSAGES_EVENT_PKG';
11: g_new_msg_api_name CONSTANT VARCHAR2(30) := 'REFRESH_ACC';
12:
13: --Bug 5409433
14: PROCEDURE HANDLE_DELETE(p_status OUT NOCOPY VARCHAR2 ,p_message OUT NOCOPY VARCHAR2)

Line 154: 'CSM_NEW_MESSAGES_EVENT_PKG.HANDLE_DELETE',FND_LOG.LEVEL_PROCEDURE);

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
158: OPEN c_get_access(l_tab(I).MESSAGE_ID,l_tab(I).USER_ID);

Line 177: 'CSM_NEW_MESSAGES_EVENT_PKG.HANDLE_DELETE',FND_LOG.LEVEL_PROCEDURE);

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
181: OPEN c_get_access(l_tab(I).MESSAGE_ID,l_tab(I).USER_ID);

Line 191: 'CSM_NEW_MESSAGES_EVENT_PKG.HANDLE_DELETE',FND_LOG.LEVEL_PROCEDURE);

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:
195: EXCEPTION

Line 193: p_message :='DELETION in CSM_NEW_MESSAGES_EVENT_PKG.HANDLE_DELETE successful';

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:
195: EXCEPTION
196: WHEN OTHERS THEN
197: l_sqlerrno := TO_CHAR(SQLCODE);

Line 200: p_message := 'Error in CSM_NEW_MESSAGES_EVENT_PKG.HANDLE_DELETE: ' || l_sqlerrno || ':' || l_sqlerrmsg;

196: WHEN OTHERS THEN
197: l_sqlerrno := TO_CHAR(SQLCODE);
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:

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 366: 'CSM_NEW_MESSAGES_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

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;
370: CLOSE c_lastrundate;

Line 373: 'CSM_NEW_MESSAGES_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

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--
377: HANDLE_DELETE(p_status,p_message);

Line 403: 'CSM_NEW_MESSAGES_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

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 ,
407: l_tab(I).USER_ID, 'U', sysdate );

Line 422: 'CSM_NEW_MESSAGES_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

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:
426: --insert--

Line 432: 'CSM_NEW_MESSAGES_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

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
436: OPEN C_GET_ACCESS_ID;

Line 480: 'CSM_NEW_MESSAGES_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

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
484: WHERE package_name = g_new_msg_pkg_name

Line 490: p_message := 'CSM_NEW_MESSAGES_EVENT_PKG.REFRESH_ACC executed successfully';

486:
487: COMMIT;
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:

Line 493: 'CSM_NEW_MESSAGES_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

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
497: l_sqlerrno := TO_CHAR(SQLCODE);

Line 500: p_message := p_message||': Error in CSM_NEW_MESSAGES_EVENT_PKG.REFRESH_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg;

496: WHEN OTHERS THEN
497: l_sqlerrno := TO_CHAR(SQLCODE);
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;

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 604: 'CSM_NEW_MESSAGES_EVENT_PKG.REFRESH_USER',FND_LOG.LEVEL_PROCEDURE);

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:
608: --insert--

Line 614: 'CSM_NEW_MESSAGES_EVENT_PKG.REFRESH_USER',FND_LOG.LEVEL_PROCEDURE);

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
618: OPEN C_GET_ACCESS_ID;

Line 660: 'CSM_NEW_MESSAGES_EVENT_PKG.REFRESH_USER',FND_LOG.LEVEL_PROCEDURE);

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:
664: END CSM_NEW_MESSAGES_EVENT_PKG;

Line 664: END CSM_NEW_MESSAGES_EVENT_PKG;

660: 'CSM_NEW_MESSAGES_EVENT_PKG.REFRESH_USER',FND_LOG.LEVEL_PROCEDURE);
661:
662: END REFRESH_USER;
663:
664: END CSM_NEW_MESSAGES_EVENT_PKG;