APPS.CSM_SR_TYPE_MAP_EVENT_PKG dependencies on FND_LOG

Line 88: 'CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC', FND_LOG.LEVEL_PROCEDURE);

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

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

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

Line 222: 'CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_EXCEPTION);

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;