APPS.CSM_SR_TYPE_MAP_EVENT_PKG dependencies on CSM_UTIL_PKG

Line 87: CSM_UTIL_PKG.LOG('Entering CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC ',

83: AND procedure_name = 'REFRESH_ACC';
84:
85: BEGIN
86:
87: CSM_UTIL_PKG.LOG('Entering CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC ',
88: 'CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC', FND_LOG.LEVEL_PROCEDURE);
89:
90: -- get last conc program update date
91: OPEN l_last_run_date_csr;

Line 102: CSM_UTIL_PKG.LOG('Entering delete ', 'CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_STATEMENT);

98:
99: -- get resource list of all omfs users R12 change
100: l_user_list := l_null_omfs_resource_list;
101:
102: CSM_UTIL_PKG.LOG('Entering delete ', 'CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_STATEMENT);
103:
104: -- process all deletes
105: OPEN csr_sr_type_map_del;
106: FETCH csr_sr_type_map_del BULK COLLECT INTO l_map_access_list,l_user_list;

Line 112: l_mark_dirty := csm_util_pkg.MakeDirtyForUser (l_pub_item,

108:
109: --mark dirty for delete
110: IF l_map_access_list.count > 0 THEN
111: FOR i IN 1..l_map_access_list.count LOOP
112: l_mark_dirty := csm_util_pkg.MakeDirtyForUser (l_pub_item,
113: l_map_access_list(i),
114: l_user_list(i),
115: asg_download.del,
116: sysdate);

Line 128: CSM_UTIL_PKG.LOG('Leaving deletes and entering updates', 'CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

124: l_map_access_list.delete;
125: l_user_list.delete;
126: END IF; -- end of process deletes
127:
128: CSM_UTIL_PKG.LOG('Leaving deletes and entering updates', 'CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
129:
130:
131: -- process all updates
132: OPEN csr_sr_type_map_upd(l_prog_update_date);

Line 138: l_mark_dirty := csm_util_pkg.MakeDirtyForUser(l_pub_item,

134: CLOSE csr_sr_type_map_upd;
135:
136: IF l_map_access_list.count > 0 THEN
137: FOR i IN 1..l_map_access_list.count LOOP
138: l_mark_dirty := csm_util_pkg.MakeDirtyForUser(l_pub_item,
139: l_map_access_list(i),
140: l_user_list(i),
141: asg_download.upd,
142: sysdate);

Line 158: CSM_UTIL_PKG.LOG('Leaving updates and entering inserts', 'CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

154: IF l_responsibility_id_tbl.count > 0 THEN
155: l_responsibility_id_tbl.delete;
156: END IF;
157:
158: CSM_UTIL_PKG.LOG('Leaving updates and entering inserts', 'CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
159:
160: --process all inserts
161: OPEN csr_sr_type_map_ins;
162: FETCH csr_sr_type_map_ins BULK COLLECT INTO l_map_access_list,l_user_list, l_sr_type_id_tbl, l_responsibility_id_tbl;

Line 167: l_mark_dirty := csm_util_pkg.MakeDirtyForUser(l_pub_item,

163: CLOSE csr_sr_type_map_ins;
164:
165: IF l_map_access_list.count > 0 THEN
166: FOR i IN 1..l_map_access_list.count LOOP
167: l_mark_dirty := csm_util_pkg.MakeDirtyForUser(l_pub_item,
168: l_map_access_list(i),
169: l_user_list(i),
170: asg_download.ins,
171: sysdate);

Line 211: CSM_UTIL_PKG.LOG('Leaving CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC ',

207:
208: p_status := 'FINE';
209: p_message := 'CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC Executed successfully';
210:
211: CSM_UTIL_PKG.LOG('Leaving CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC ',
212: 'CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
213:
214: EXCEPTION
215: WHEN others THEN

Line 221: CSM_UTIL_PKG.LOG('Exception in CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg,

217: l_sqlerrmsg := substr(SQLERRM, 1,2000);
218: p_status := 'Error';
219: p_message := 'Error in CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC :' || l_sqlerrno || ':' || l_sqlerrmsg;
220: ROLLBACK;
221: CSM_UTIL_PKG.LOG('Exception in CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg,
222: 'CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_EXCEPTION);
223: END REFRESH_ACC;
224:
225: END CSM_SR_TYPE_MAP_EVENT_PKG;