APPS.CSM_ACCESS_PURGE_PKG dependencies on CSM_UTIL_PKG

Line 136: CSM_UTIL_PKG.LOG('Entering CSM_COUNTER_EVENT_PKG.COUNTER_PURGE_DATA', 'CSM_COUNTER_EVENT_PKG.COUNTER_PURGE_DATA',FND_LOG.LEVEL_EVENT);

132: --Purge records for CSM
133: OPEN c_csm_acc_list;
134: FETCH c_csm_acc_list BULK COLLECT INTO acc_tab_list;
135: CLOSE c_csm_acc_list;
136: CSM_UTIL_PKG.LOG('Entering CSM_COUNTER_EVENT_PKG.COUNTER_PURGE_DATA', 'CSM_COUNTER_EVENT_PKG.COUNTER_PURGE_DATA',FND_LOG.LEVEL_EVENT);
137: FOR I IN 1..acc_tab_list.COUNT
138: LOOP
139: l_sql_stmt:= 'SELECT DISTINCT USER_ID FROM '||acc_tab_list(I).ACCESS_NAME ||
140: ' ACC WHERE USER_ID IS NOT NULL

Line 148: CSM_UTIL_PKG.LOG('Processing Access list', 'CSM_COUNTER_EVENT_PKG.COUNTER_PURGE_DATA',FND_LOG.LEVEL_EVENT);

144: EXCEPTION
145: WHEN OTHERS THEN
146: NULL;
147: END;
148: CSM_UTIL_PKG.LOG('Processing Access list', 'CSM_COUNTER_EVENT_PKG.COUNTER_PURGE_DATA',FND_LOG.LEVEL_EVENT);
149: IF l_user_list.COUNT >0 THEN
150: FOR J IN 1..l_user_list.COUNT
151: LOOP
152: DELETE_ACC_FOR_USER(acc_tab_list(I).ACCESS_NAME,l_user_list(J));

Line 159: CSM_UTIL_PKG.LOG('Completed processing Access list', 'CSM_COUNTER_EVENT_PKG.COUNTER_PURGE_DATA',FND_LOG.LEVEL_EVENT);

155: l_user_list.DELETE;
156: END IF;
157: END LOOP; --Access list loop
158:
159: CSM_UTIL_PKG.LOG('Completed processing Access list', 'CSM_COUNTER_EVENT_PKG.COUNTER_PURGE_DATA',FND_LOG.LEVEL_EVENT);
160: IF acc_tab_list.COUNT > 0 THEN
161: acc_tab_list.DELETE;
162: END IF;
163:

Line 169: CSM_UTIL_PKG.LOG('Entering CSM_COUNTER_EVENT_PKG.COUNTER_PURGE_DATA', 'CSM_COUNTER_EVENT_PKG.COUNTER_PURGE_DATA',FND_LOG.LEVEL_EVENT);

165: --Purge records for CSL
166: OPEN c_csl_acc_list;
167: FETCH c_csl_acc_list BULK COLLECT INTO acc_tab_list;
168: CLOSE c_csl_acc_list;
169: CSM_UTIL_PKG.LOG('Entering CSM_COUNTER_EVENT_PKG.COUNTER_PURGE_DATA', 'CSM_COUNTER_EVENT_PKG.COUNTER_PURGE_DATA',FND_LOG.LEVEL_EVENT);
170:
171: FOR I IN 1..acc_tab_list.COUNT
172: LOOP
173: l_sql_stmt:= 'SELECT DISTINCT RESOURCE_ID FROM '||acc_tab_list(I).ACCESS_NAME ||

Line 182: CSM_UTIL_PKG.LOG('Processing Access list', 'CSM_COUNTER_EVENT_PKG.COUNTER_PURGE_DATA',FND_LOG.LEVEL_EVENT);

178: EXCEPTION
179: WHEN OTHERS THEN
180: NULL;
181: END;
182: CSM_UTIL_PKG.LOG('Processing Access list', 'CSM_COUNTER_EVENT_PKG.COUNTER_PURGE_DATA',FND_LOG.LEVEL_EVENT);
183:
184: IF l_user_list.COUNT >0 THEN
185: FOR J IN 1..l_user_list.COUNT
186: LOOP

Line 194: CSM_UTIL_PKG.LOG('Completed processing Access list', 'CSM_COUNTER_EVENT_PKG.COUNTER_PURGE_DATA',FND_LOG.LEVEL_EVENT);

190: l_user_list.DELETE;
191: END IF;
192: END LOOP; --Access list loop
193:
194: CSM_UTIL_PKG.LOG('Completed processing Access list', 'CSM_COUNTER_EVENT_PKG.COUNTER_PURGE_DATA',FND_LOG.LEVEL_EVENT);
195: IF acc_tab_list.COUNT > 0 THEN
196: acc_tab_list.DELETE;
197: END IF;
198: --call to delete non acc mfs tables

Line 216: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_ACCESS_PURGE_PKG.PURGE_INVALID_ACC_DATA',FND_LOG.LEVEL_EVENT);

212: l_error_msg := ' Exception in PURGE_INVALID_ACC_DATA'
213: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
214: p_status := 'ERROR';
215: p_message := 'Error in CSM_ACCESS_PURGE_PKG.PURGE_INVALID_ACC_DATA: ' || l_error_msg;
216: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_ACCESS_PURGE_PKG.PURGE_INVALID_ACC_DATA',FND_LOG.LEVEL_EVENT);
217:
218: END PURGE_INVALID_ACC_DATA;
219:
220: END CSM_ACCESS_PURGE_PKG; -- of package csm_counter_event_pkg