APPS.CSM_RESCODE_MAPPING_EVENT_PKG dependencies on CSM_UTIL_PKG

Line 73: CSM_UTIL_PKG.LOG('Entering CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC ',

69: AND procedure_name = 'REFRESH_ACC';
70:
71: BEGIN
72:
73: CSM_UTIL_PKG.LOG('Entering CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC ',
74: 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC', FND_LOG.LEVEL_PROCEDURE);
75:
76: -- get last conc program update date
77: OPEN l_last_run_date_csr;

Line 87: l_all_omfs_resource_list := csm_util_pkg.get_all_omfs_palm_res_list;

83: END IF;
84:
85: -- get resource list of all omfs users
86: l_all_omfs_resource_list := l_null_omfs_resource_list;
87: l_all_omfs_resource_list := csm_util_pkg.get_all_omfs_palm_res_list;
88:
89: CSM_UTIL_PKG.LOG('Entering delete ', 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_STATEMENT);
90:
91: -- process all deletes

Line 89: CSM_UTIL_PKG.LOG('Entering delete ', 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_STATEMENT);

85: -- get resource list of all omfs users
86: l_all_omfs_resource_list := l_null_omfs_resource_list;
87: l_all_omfs_resource_list := csm_util_pkg.get_all_omfs_palm_res_list;
88:
89: CSM_UTIL_PKG.LOG('Entering delete ', 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_STATEMENT);
90:
91: -- process all deletes
92: OPEN csr_rescode_map_del;
93: FETCH csr_rescode_map_del BULK COLLECT INTO l_map_access_list;

Line 100: l_mark_dirty := csm_util_pkg.MakeDirtyForResource(l_pub_item,

96: --mark dirty for delete
97: IF l_map_access_list.count > 0 THEN
98: FOR i IN 1..l_map_access_list.count LOOP
99: FOR j IN 1..l_all_omfs_resource_list.count LOOP
100: l_mark_dirty := csm_util_pkg.MakeDirtyForResource(l_pub_item,
101: l_map_access_list(i),
102: l_all_omfs_resource_list(j),
103: asg_download.del,
104: sysdate);

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

112:
113: l_map_access_list.delete;
114: END IF; -- end of process deletes
115:
116: CSM_UTIL_PKG.LOG('Leaving deletes and entering updates', 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
117:
118:
119: -- process all updates
120: OPEN csr_rescode_map_upd(l_prog_update_date);

Line 127: l_mark_dirty := csm_util_pkg.MakeDirtyForResource(l_pub_item,

123:
124: IF l_map_access_list.count > 0 THEN
125: FOR i IN 1..l_map_access_list.count LOOP
126: FOR j IN 1..l_all_omfs_resource_list.count LOOP
127: l_mark_dirty := csm_util_pkg.MakeDirtyForResource(l_pub_item,
128: l_map_access_list(i),
129: l_all_omfs_resource_list(j),
130: asg_download.upd,
131: sysdate);

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

139: IF l_resol_map_id_tbl.count > 0 THEN
140: l_resol_map_id_tbl.delete;
141: END IF;
142:
143: CSM_UTIL_PKG.LOG('Leaving updates and entering inserts', 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
144:
145: --process all inserts
146: OPEN csr_rescode_map_ins;
147: FETCH csr_rescode_map_ins BULK COLLECT INTO l_map_access_list, l_resol_map_id_tbl;

Line 153: l_mark_dirty := csm_util_pkg.MakeDirtyForResource(l_pub_item,

149:
150: IF l_map_access_list.count > 0 THEN
151: FOR i IN 1..l_map_access_list.count LOOP
152: FOR j IN 1..l_all_omfs_resource_list.count LOOP
153: l_mark_dirty := csm_util_pkg.MakeDirtyForResource(l_pub_item,
154: l_map_access_list(i),
155: l_all_omfs_resource_list(j),
156: asg_download.ins,
157: sysdate);

Line 193: CSM_UTIL_PKG.LOG('Leaving CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC ',

189:
190: p_status := 'FINE';
191: p_message := 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC Executed successfully';
192:
193: CSM_UTIL_PKG.LOG('Leaving CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC ',
194: 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
195:
196: EXCEPTION
197: WHEN others THEN

Line 203: CSM_UTIL_PKG.LOG('Exception in CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg,

199: l_sqlerrmsg := substr(SQLERRM, 1,2000);
200: p_status := 'Error';
201: p_message := 'Error in CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC :' || l_sqlerrno || ':' || l_sqlerrmsg;
202: ROLLBACK;
203: CSM_UTIL_PKG.LOG('Exception in CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg,
204: 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_EXCEPTION);
205: END REFRESH_ACC;
206:
207: END CSM_RESCODE_MAPPING_EVENT_PKG;