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_PROFILE_EVENT_PKG dependencies on CSM_PROFILE_EVENT_PKG

Line 1: PACKAGE BODY CSM_PROFILE_EVENT_PKG AS

1: PACKAGE BODY CSM_PROFILE_EVENT_PKG AS
2: /* $Header: csmeprfb.pls 120.22.12010000.2 2008/11/17 11:34:21 trajasek ship $ */
3:
4: g_pub_item VARCHAR2(30) := 'CSF_M_PROFILES';
5:

Line 103: WHERE package_name = 'CSM_PROFILE_EVENT_PKG'

99: CURSOR l_last_run_date_csr(p_pub_item IN varchar2)
100: IS
101: SELECT nvl(last_run_date, (sysdate - 365*50))
102: FROM jtm_con_request_data
103: WHERE package_name = 'CSM_PROFILE_EVENT_PKG'
104: AND procedure_name = 'REFRESH_ACC';
105:
106: --Bug 5257429
107: /*WHENEVER A NEW PROFILE IS ADDED TO INSERT CURSOR, PLEASE DON'T FORGET TO ADD

Line 602: 'CSM_PROFILE_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

598: CLOSE c_purge;
599:
600:
601: CSM_UTIL_PKG.LOG('Entering DELETE to remove ' || l_tab.count||' records',
602: 'CSM_PROFILE_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
603:
604: FOR I IN 1..l_tab.COUNT
605: LOOP
606: OPEN c_get_accessID(l_tab(I).APPLICATION_ID,l_tab(I).PROFILE_OPTION_ID);

Line 816: WHERE package_name = 'CSM_PROFILE_EVENT_PKG'

812: -- set the program update date in jtm_con_request_data to sysdate
813: UPDATE jtm_con_request_data
814: SET last_run_date = l_run_date,
815: last_update_date = SYSDATE
816: WHERE package_name = 'CSM_PROFILE_EVENT_PKG'
817: AND procedure_name = 'REFRESH_ACC';
818:
819: p_status := 'FINE';
820: p_message := 'CSM_PROFILE_EVENT_PKG.Refresh_Acc Executed successfully';

Line 820: p_message := 'CSM_PROFILE_EVENT_PKG.Refresh_Acc Executed successfully';

816: WHERE package_name = 'CSM_PROFILE_EVENT_PKG'
817: AND procedure_name = 'REFRESH_ACC';
818:
819: p_status := 'FINE';
820: p_message := 'CSM_PROFILE_EVENT_PKG.Refresh_Acc Executed successfully';
821:
822: COMMIT;
823:
824: EXCEPTION

Line 830: p_message := 'Error in CSM_PROFILE_EVENT_PKG.Refresh_Acc: ' || l_sqlerrno || ':' || l_sqlerrmsg;

826: l_sqlerrno := to_char(SQLCODE);
827: l_sqlerrmsg := substr(SQLERRM, 1,200);
828: ROLLBACK;
829: p_status := 'ERROR';
830: p_message := 'Error in CSM_PROFILE_EVENT_PKG.Refresh_Acc: ' || l_sqlerrno || ':' || l_sqlerrmsg;
831: csm_util_pkg.log('CSM_PROFILE_EVENT_PKG ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg, 'CSM_PROFILE_EVENT_PKG.REFRESH_ACC', FND_LOG.LEVEL_EXCEPTION);
832: fnd_file.put_line(fnd_file.log, 'CSM_PROFILE_EVENT_PKG ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
833:
834: END Refresh_Acc;

Line 831: csm_util_pkg.log('CSM_PROFILE_EVENT_PKG ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg, 'CSM_PROFILE_EVENT_PKG.REFRESH_ACC', FND_LOG.LEVEL_EXCEPTION);

827: l_sqlerrmsg := substr(SQLERRM, 1,200);
828: ROLLBACK;
829: p_status := 'ERROR';
830: p_message := 'Error in CSM_PROFILE_EVENT_PKG.Refresh_Acc: ' || l_sqlerrno || ':' || l_sqlerrmsg;
831: csm_util_pkg.log('CSM_PROFILE_EVENT_PKG ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg, 'CSM_PROFILE_EVENT_PKG.REFRESH_ACC', FND_LOG.LEVEL_EXCEPTION);
832: fnd_file.put_line(fnd_file.log, 'CSM_PROFILE_EVENT_PKG ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
833:
834: END Refresh_Acc;
835:

Line 832: fnd_file.put_line(fnd_file.log, 'CSM_PROFILE_EVENT_PKG ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);

828: ROLLBACK;
829: p_status := 'ERROR';
830: p_message := 'Error in CSM_PROFILE_EVENT_PKG.Refresh_Acc: ' || l_sqlerrno || ':' || l_sqlerrmsg;
831: csm_util_pkg.log('CSM_PROFILE_EVENT_PKG ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg, 'CSM_PROFILE_EVENT_PKG.REFRESH_ACC', FND_LOG.LEVEL_EXCEPTION);
832: fnd_file.put_line(fnd_file.log, 'CSM_PROFILE_EVENT_PKG ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
833:
834: END Refresh_Acc;
835:
836: /***

Line 1060: CSM_UTIL_PKG.LOG(l_error_msg, 'csm_profile_event_pkg.refresh_user_acc',FND_LOG.LEVEL_EXCEPTION);

1056: l_sqlerrno := to_char(SQLCODE);
1057: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1058: l_error_msg := ' Exception in refresh_user_acc for user_id:'
1059: || to_char(p_user_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1060: CSM_UTIL_PKG.LOG(l_error_msg, 'csm_profile_event_pkg.refresh_user_acc',FND_LOG.LEVEL_EXCEPTION);
1061: RAISE;
1062: END refresh_user_acc;
1063:
1064: FUNCTION IS_MFS_PROFILE(p_profile_option_name IN VARCHAR2) RETURN BOOLEAN

Line 1145: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_PROFILE_EVENT_PKG.IS_MFS_PROFILE',FND_LOG.LEVEL_EXCEPTION);

1141: l_sqlerrno := TO_CHAR(SQLCODE);
1142: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
1143: l_error_msg := ' Exception in IS_MFS_PROFILE for profile_option_name:' || l_profile_option_name
1144: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1145: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_PROFILE_EVENT_PKG.IS_MFS_PROFILE',FND_LOG.LEVEL_EXCEPTION);
1146: RETURN FALSE;
1147: END IS_MFS_PROFILE;
1148:
1149: END CSM_PROFILE_EVENT_PKG;

Line 1149: END CSM_PROFILE_EVENT_PKG;

1145: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_PROFILE_EVENT_PKG.IS_MFS_PROFILE',FND_LOG.LEVEL_EXCEPTION);
1146: RETURN FALSE;
1147: END IS_MFS_PROFILE;
1148:
1149: END CSM_PROFILE_EVENT_PKG;