APPS.CSM_RESCODE_MAPPING_EVENT_PKG dependencies on FND_LOG

Line 74: 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC', FND_LOG.LEVEL_PROCEDURE);

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;
78: FETCH l_last_run_date_csr INTO l_prog_update_date;

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 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 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 194: 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

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
198: l_sqlerrno := to_char(SQLCODE);

Line 204: 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_EXCEPTION);

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;