DBA Data[Home] [Help]

APPS.CSM_PROFILE_EVENT_PKG dependencies on FND_LOG

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 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 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;