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_UTIL_PKG

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

597: FETCH c_purge BULK COLLECT INTO l_tab;
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

Line 612: l_markdirty := CSM_UTIL_PKG.MakeDirtyForUser(g_pub_item,l_acc_tab(J) ,l_user_tab(J), 'D', sysdate );

608: CLOSE c_get_accessID;
609:
610: FOR J IN 1..l_user_tab.COUNT
611: LOOP
612: l_markdirty := CSM_UTIL_PKG.MakeDirtyForUser(g_pub_item,l_acc_tab(J) ,l_user_tab(J), 'D', sysdate );
613: END LOOP;
614:
615: FORALL J IN 1..l_acc_tab.COUNT
616: DELETE FROM csm_profile_option_values_acc WHERE ACCESS_ID=l_acc_tab(J);

Line 632: l_markdirty := CSM_UTIL_PKG.MakeDirtyForUser(g_pub_item,

628: 0, NULL,
629: NULL,l_run_date);
630:
631: --mark dirty the SDQ for the user
632: l_markdirty := CSM_UTIL_PKG.MakeDirtyForUser(g_pub_item,
633: r_profiles_ins_rec.access_id, r_profiles_ins_rec.user_id, ASG_DOWNLOAD.INS, SYSDATE);
634:
635: END LOOP; -- process profile wovalue inserts
636:

Line 671: IF csm_util_pkg.is_palm_user(l_user_id) THEN

667: OPEN c_csm_resp(l_user_id);
668: FETCH c_csm_resp INTO l_csm_resp_id;
669: CLOSE c_csm_resp;
670:
671: IF csm_util_pkg.is_palm_user(l_user_id) THEN
672: OPEN c_profiles_csr(r_profiles_del_rec.profile_option_name, l_user_id, l_csm_resp_id, l_csm_appl_id);
673: FETCH c_profiles_csr INTO r_profiles_rec;
674: IF c_profiles_csr%FOUND THEN
675: IF r_profiles_rec.profile_option_value IS NULL THEN

Line 691: l_markdirty := CSM_UTIL_PKG.MakeDirtyForUser(g_pub_item,

687: last_update_date = l_run_date
688: WHERE CURRENT OF l_profiles_del_csr;
689:
690: --mark dirty the SDQ for the user
691: l_markdirty := CSM_UTIL_PKG.MakeDirtyForUser(g_pub_item,
692: r_profiles_del_rec.access_id, l_user_id, ASG_DOWNLOAD.UPD, SYSDATE);
693: ELSE
694: --No value set for this profile at any level and hence set back to site level with value null
695: UPDATE csm_profile_option_values_acc

Line 703: l_markdirty := CSM_UTIL_PKG.MakeDirtyForUser(g_pub_item,

699: level_value_application_id = NULL,
700: last_update_date = l_run_date
701: WHERE CURRENT OF l_profiles_del_csr;
702: --mark dirty the SDQ for the user
703: l_markdirty := CSM_UTIL_PKG.MakeDirtyForUser(g_pub_item,
704: r_profiles_del_rec.access_id, l_user_id, ASG_DOWNLOAD.UPD, SYSDATE);
705:
706: END IF;
707: CLOSE c_profiles_csr;

Line 730: l_markdirty := CSM_UTIL_PKG.MakeDirtyForUser(g_pub_item,

726: AND level_id = r_profiles_upd_rec.level_id
727: AND level_value = r_profiles_upd_rec.level_value;
728:
729: --mark dirty the SDQ for the user
730: l_markdirty := CSM_UTIL_PKG.MakeDirtyForUser(g_pub_item,
731: r_profiles_upd_rec.access_id, r_profiles_upd_rec.user_id, ASG_DOWNLOAD.UPD, SYSDATE);
732: END LOOP;
733: COMMIT;
734: --process updates ENDS

Line 751: l_all_omfs_palm_user_list := csm_util_pkg.get_all_omfs_palm_user_list;

747:
748: l_all_omfs_palm_user_list := get_all_omfs_resp_palm_users(r_profiles_ins_rec.level_value);
749: ELSE
750: -- get all the omfs palm users
751: l_all_omfs_palm_user_list := csm_util_pkg.get_all_omfs_palm_user_list;
752:
753: END IF;
754:
755: -- loop for all the valid omfs palm users based on profile level_id

Line 760: AND csm_util_pkg.is_palm_user(l_user_id))) THEN

756: FOR i IN 1..l_all_omfs_palm_user_list.COUNT LOOP
757: l_user_id := l_all_omfs_palm_user_list(i);
758:
759: IF (r_profiles_ins_rec.level_id <> 10004 OR (r_profiles_ins_rec.level_id = 10004
760: AND csm_util_pkg.is_palm_user(l_user_id))) THEN
761:
762: -- delete any lower levels that exist for this profile for the user
763: OPEN l_get_old_profile_csr(r_profiles_ins_rec.profile_option_id, l_user_id);
764: FETCH l_get_old_profile_csr INTO l_access_id, l_old_profile_option_value, l_old_level_id;

Line 779: l_markdirty := CSM_UTIL_PKG.MakeDirtyForUser(g_pub_item,

775: WHERE CURRENT OF l_get_old_profile_csr;
776:
777: IF is_mfs_profile(p_profile_option_name=>r_profiles_ins_rec.profile_option_name) THEN
778: --mark dirty the SDQ for the user
779: l_markdirty := CSM_UTIL_PKG.MakeDirtyForUser(g_pub_item,
780: l_access_id, l_user_id, ASG_DOWNLOAD.UPD, SYSDATE);
781: END IF;
782: END IF;
783:

Line 801: l_markdirty := CSM_UTIL_PKG.MakeDirtyForUser(g_pub_item,

797: r_profiles_ins_rec.level_value, r_profiles_ins_rec.level_value_application_id,
798: r_profiles_ins_rec.profile_option_value,l_run_date);
799:
800: --mark dirty the SDQ for the user
801: l_markdirty := CSM_UTIL_PKG.MakeDirtyForUser(g_pub_item,
802: l_access_id, l_user_id, ASG_DOWNLOAD.INS, SYSDATE);
803:
804: END IF;
805: END IF;

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 1015: l_markdirty := CSM_UTIL_PKG.MakeDirtyForUser(g_pub_item,

1011: WHERE CURRENT OF l_get_old_profile_csr;
1012:
1013: IF is_mfs_profile(p_profile_option_name=>r_profiles_ins_rec.profile_option_name) THEN
1014: --mark dirty the SDQ for the user
1015: l_markdirty := CSM_UTIL_PKG.MakeDirtyForUser(g_pub_item,
1016: l_access_id, p_user_id, ASG_DOWNLOAD.UPD, SYSDATE);
1017: END IF;
1018:
1019: -- start the profile_option_value_upd WF

Line 1040: l_markdirty := CSM_UTIL_PKG.MakeDirtyForUser(g_pub_item,

1036: r_profiles_ins_rec.profile_option_value,l_run_date);
1037:
1038: IF is_mfs_profile(p_profile_option_name=>r_profiles_ins_rec.profile_option_name) THEN
1039: --mark dirty the SDQ for the user
1040: l_markdirty := CSM_UTIL_PKG.MakeDirtyForUser(g_pub_item,
1041: l_access_id, p_user_id, ASG_DOWNLOAD.INS, SYSDATE);
1042: END IF;
1043:
1044: -- start the profile_option_value_upd WF using null for the old profle option value

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;