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.12020000.2 2013/04/09 06:24:22 saradhak ship $ */
3:
4: procedure Refresh_Acc_upd_Del (p_user_id NUMBER, p_resp_id NUMBER,p_lrd DATE)
5: IS

Line 133: WHERE package_name = 'CSM_STATE_TRANSITION_EVENT_PKG'

129: CURSOR l_last_run_date_csr
130: IS
131: SELECT nvl(last_run_date, (sysdate - 365*50))
132: FROM jtm_con_request_data
133: WHERE package_name = 'CSM_STATE_TRANSITION_EVENT_PKG'
134: AND procedure_name = 'REFRESH_ACC';
135:
136: BEGIN
137:

Line 151: WHERE package_name = 'CSM_STATE_TRANSITION_EVENT_PKG'

147:
148:
149: UPDATE jtm_con_request_data
150: SET last_run_date = sysdate
151: WHERE package_name = 'CSM_STATE_TRANSITION_EVENT_PKG'
152: AND procedure_name = 'REFRESH_ACC';
153:
154: p_status := 'FINE';
155: p_message := 'CSM_STATE_TRANSITION_EVENT_PKG.Refresh_Acc Executed successfully';

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

151: WHERE package_name = 'CSM_STATE_TRANSITION_EVENT_PKG'
152: AND procedure_name = 'REFRESH_ACC';
153:
154: p_status := 'FINE';
155: p_message := 'CSM_STATE_TRANSITION_EVENT_PKG.Refresh_Acc Executed successfully';
156:
157: COMMIT;
158:
159: EXCEPTION

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

161: l_sqlerrno := to_char(SQLCODE);
162: l_sqlerrmsg := substr(SQLERRM, 1,300);
163: csm_util_pkg.log('State Tansition Error:' || l_sqlerrno || ':' || l_sqlerrmsg, 'CSM_STATE_TRANISITION_EVENT_PKG.Refresh_Acc');
164: p_status := 'ERROR';
165: p_message := 'Error in CSM_STATE_TRANSITION_EVENT_PKG.Refresh_Acc :' ||l_sqlerrno || ':' || l_sqlerrmsg;
166: ROLLBACK;
167: END Refresh_ACC;
168: END CSM_STATE_TRANSITION_EVENT_PKG;

Line 168: END CSM_STATE_TRANSITION_EVENT_PKG;

164: p_status := 'ERROR';
165: p_message := 'Error in CSM_STATE_TRANSITION_EVENT_PKG.Refresh_Acc :' ||l_sqlerrno || ':' || l_sqlerrmsg;
166: ROLLBACK;
167: END Refresh_ACC;
168: END CSM_STATE_TRANSITION_EVENT_PKG;