APPS.CSM_STATE_TRANSITION_EVENT_PKG dependencies on CSM_STATE_TRANSITION_EVENT_PKG

Line 1: PACKAGE BODY CSM_STATE_TRANSITION_EVENT_PKG AS

1: PACKAGE BODY CSM_STATE_TRANSITION_EVENT_PKG AS
2: /* $Header: csmestrb.pls 120.7 2008/02/07 06:52:55 anaraman ship $ */
3:
4: l_no_status_transition_resp EXCEPTION;
5:

Line 340: WHERE package_name = 'CSM_STATE_TRANSITION_EVENT_PKG'

336: -- END IF;
337:
338: UPDATE jtm_con_request_data
339: SET last_run_date = l_run_date
340: WHERE package_name = 'CSM_STATE_TRANSITION_EVENT_PKG'
341: AND procedure_name = 'REFRESH_ACC';
342:
343: COMMIT;
344:

Line 346: p_message := 'CSM_STATE_TRANSITION_EVENT_PKG.Refresh_Acc Executed successfully';

342:
343: COMMIT;
344:
345: p_status := 'FINE';
346: p_message := 'CSM_STATE_TRANSITION_EVENT_PKG.Refresh_Acc Executed successfully';
347:
348: EXCEPTION
349: WHEN l_no_status_transition_resp THEN
350: csm_util_pkg.log('No Status Transition responsibility defined for user: ' || l_user_id);

Line 352: p_message := 'Error in CSM_STATE_TRANSITION_EVENT_PKG.Refresh_Acc';

348: EXCEPTION
349: WHEN l_no_status_transition_resp THEN
350: csm_util_pkg.log('No Status Transition responsibility defined for user: ' || l_user_id);
351: p_status := 'ERROR';
352: p_message := 'Error in CSM_STATE_TRANSITION_EVENT_PKG.Refresh_Acc';
353:
354: WHEN others THEN
355: l_sqlerrno := to_char(SQLCODE);
356: l_sqlerrmsg := substr(SQLERRM, 1,300);

Line 359: p_message := 'Error in CSM_STATE_TRANSITION_EVENT_PKG.Refresh_Acc :' ||l_sqlerrno || ':' || l_sqlerrmsg;

355: l_sqlerrno := to_char(SQLCODE);
356: l_sqlerrmsg := substr(SQLERRM, 1,300);
357: csm_util_pkg.log('State Tansition Error:' || l_sqlerrno || ':' || l_sqlerrmsg, 'CSM_STATE_TRANISITION_EVENT_PKG.Refresh_Acc');
358: p_status := 'ERROR';
359: p_message := 'Error in CSM_STATE_TRANSITION_EVENT_PKG.Refresh_Acc :' ||l_sqlerrno || ':' || l_sqlerrmsg;
360: ROLLBACK;
361: -- logm('State Transition Error:' || l_sqlerrno || ':' || substr(l_sqlerrmsg,1,200));
362: -- fnd_file.put_line(fnd_file.log, 'CSM_STATE_TRANSITION_EVENT_PKG ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
363:

Line 362: -- fnd_file.put_line(fnd_file.log, 'CSM_STATE_TRANSITION_EVENT_PKG ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);

358: p_status := 'ERROR';
359: p_message := 'Error in CSM_STATE_TRANSITION_EVENT_PKG.Refresh_Acc :' ||l_sqlerrno || ':' || l_sqlerrmsg;
360: ROLLBACK;
361: -- logm('State Transition Error:' || l_sqlerrno || ':' || substr(l_sqlerrmsg,1,200));
362: -- fnd_file.put_line(fnd_file.log, 'CSM_STATE_TRANSITION_EVENT_PKG ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
363:
364: END Refresh_ACC;
365: END CSM_STATE_TRANSITION_EVENT_PKG;

Line 365: END CSM_STATE_TRANSITION_EVENT_PKG;

361: -- logm('State Transition Error:' || l_sqlerrno || ':' || substr(l_sqlerrmsg,1,200));
362: -- fnd_file.put_line(fnd_file.log, 'CSM_STATE_TRANSITION_EVENT_PKG ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
363:
364: END Refresh_ACC;
365: END CSM_STATE_TRANSITION_EVENT_PKG;