APPS.CSM_PROBCODE_MAPPING_EVENT_PKG dependencies on FND_LOG

Line 76: 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc', FND_LOG.LEVEL_PROCEDURE);

72:
73: BEGIN
74:
75: CSM_UTIL_PKG.LOG('Entering CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc ',
76: 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc', FND_LOG.LEVEL_PROCEDURE);
77:
78: -- data program is run
79: l_run_date := SYSDATE;
80:

Line 94: CSM_UTIL_PKG.LOG('Entering deletes ', 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc',FND_LOG.LEVEL_STATEMENT);

90: -- get resource list of all omfs palm users
91: l_all_omfs_resource_list := l_null_omfs_resource_list;
92: l_all_omfs_resource_list := csm_util_pkg.get_all_omfs_palm_res_list;
93:
94: CSM_UTIL_PKG.LOG('Entering deletes ', 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc',FND_LOG.LEVEL_STATEMENT);
95:
96: -- process all deletes
97: OPEN csr_probcode_map_del;
98: FETCH csr_probcode_map_del BULK COLLECT INTO l_map_access_list;

Line 120: CSM_UTIL_PKG.LOG('Leaving deletes and entering updates', 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc',FND_LOG.LEVEL_PROCEDURE);

116:
117: l_map_access_list.delete;
118: END IF; -- end of process deletes
119:
120: CSM_UTIL_PKG.LOG('Leaving deletes and entering updates', 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc',FND_LOG.LEVEL_PROCEDURE);
121:
122: -- process all updates
123: OPEN csr_probcode_map_upd(l_prog_update_date);
124: FETCH csr_probcode_map_upd BULK COLLECT INTO l_map_access_list;

Line 146: CSM_UTIL_PKG.LOG('Leaving updates and entering inserts', 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc',FND_LOG.LEVEL_PROCEDURE);

142: IF l_problem_map_detail_id_tbl.count > 0 THEN
143: l_problem_map_detail_id_tbl.delete;
144: END IF;
145:
146: CSM_UTIL_PKG.LOG('Leaving updates and entering inserts', 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc',FND_LOG.LEVEL_PROCEDURE);
147:
148: --process all inserts
149: OPEN csr_probcode_map_ins;
150: FETCH csr_probcode_map_ins BULK COLLECT INTO l_map_access_list, l_problem_map_detail_id_tbl;

Line 197: 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc',FND_LOG.LEVEL_PROCEDURE);

193: p_status := 'FINE';
194: p_message := 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc Executed successfully';
195:
196: CSM_UTIL_PKG.LOG('Leaving CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc ',
197: 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc',FND_LOG.LEVEL_PROCEDURE);
198:
199: EXCEPTION
200: WHEN others THEN
201: l_sqlerrno := to_char(SQLCODE);

Line 207: 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc',FND_LOG.LEVEL_EXCEPTION);

203: p_status := 'Error';
204: p_message := 'Error in CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc :' || l_sqlerrno || ':' || l_sqlerrmsg;
205: ROLLBACK;
206: CSM_UTIL_PKG.LOG('Exception in CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc: ' || l_sqlerrno || ':' || l_sqlerrmsg,
207: 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc',FND_LOG.LEVEL_EXCEPTION);
208: END Refresh_probcode_mapping_acc;
209:
210: END CSM_PROBCODE_MAPPING_EVENT_PKG;