APPS.CSM_PROBCODE_MAPPING_EVENT_PKG dependencies on CSM_UTIL_PKG

Line 75: CSM_UTIL_PKG.LOG('Entering CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc ',

71: AND procedure_name = 'REFRESH_PROBCODE_MAPPING_ACC';
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;

Line 92: l_all_omfs_resource_list := csm_util_pkg.get_all_omfs_palm_res_list;

88: END IF;
89:
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

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 104: l_mark_dirty := csm_util_pkg.MakeDirtyForResource(g_pub_item,

100:
101: IF l_map_access_list.count > 0 THEN
102: FOR i IN 1..l_map_access_list.count LOOP
103: FOR j IN 1..l_all_omfs_resource_list.count LOOP
104: l_mark_dirty := csm_util_pkg.MakeDirtyForResource(g_pub_item,
105: l_map_access_list(i),
106: l_all_omfs_resource_list(j),
107: asg_download.del,
108: l_run_date);

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 130: l_mark_dirty := csm_util_pkg.MakeDirtyForResource(g_pub_item,

126:
127: IF l_map_access_list.count > 0 THEN
128: FOR i IN 1..l_map_access_list.count LOOP
129: FOR j IN 1..l_all_omfs_resource_list.count LOOP
130: l_mark_dirty := csm_util_pkg.MakeDirtyForResource(g_pub_item,
131: l_map_access_list(i),
132: l_all_omfs_resource_list(j),
133: asg_download.upd,
134: l_run_date);

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 156: l_mark_dirty := csm_util_pkg.MakeDirtyForResource(g_pub_item,

152:
153: IF l_map_access_list.count > 0 THEN
154: FOR i IN 1..l_map_access_list.count LOOP
155: FOR j IN 1..l_all_omfs_resource_list.count LOOP
156: l_mark_dirty := csm_util_pkg.MakeDirtyForResource(g_pub_item,
157: l_map_access_list(i),
158: l_all_omfs_resource_list(j),
159: asg_download.ins,
160: l_run_date);

Line 196: CSM_UTIL_PKG.LOG('Leaving CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc ',

192:
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

Line 206: CSM_UTIL_PKG.LOG('Exception in CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc: ' || l_sqlerrno || ':' || l_sqlerrmsg,

202: l_sqlerrmsg := substr(SQLERRM, 1,2000);
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;