APPS.CSM_ACCESS_PURGE_PKG dependencies on CSM_ACCESS_PURGE_PKG

Line 1: PACKAGE BODY CSM_ACCESS_PURGE_PKG AS

1: PACKAGE BODY CSM_ACCESS_PURGE_PKG AS
2: /* $Header: csmeacpb.pls 120.0.12010000.1 2008/07/28 16:12:46 appldev ship $ */
3:
4: --
5: -- Purpose: Procedures to purge Invalid Acc Records

Line 204: p_message := 'CSM_ACCESS_PURGE_PKG.PURGE_INVALID_ACC_DATA Executed successfully';

200:
201: COMMIT;
202:
203: p_status := 'SUCCESS';
204: p_message := 'CSM_ACCESS_PURGE_PKG.PURGE_INVALID_ACC_DATA Executed successfully';
205:
206: EXCEPTION
207: --log the error
208: WHEN OTHERS THEN

Line 215: p_message := 'Error in CSM_ACCESS_PURGE_PKG.PURGE_INVALID_ACC_DATA: ' || l_error_msg;

211: ROLLBACK;
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:

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

Line 220: END CSM_ACCESS_PURGE_PKG; -- of package csm_counter_event_pkg

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