APPS.CSM_MTL_SEC_LOCATORS_EVENT_PKG dependencies on CSM_MTL_SEC_LOCATORS_EVENT_PKG

Line 1: PACKAGE BODY CSM_MTL_SEC_LOCATORS_EVENT_PKG AS

1: PACKAGE BODY CSM_MTL_SEC_LOCATORS_EVENT_PKG AS
2: /* $Header: csmemslb.pls 120.1.12020000.2 2013/04/09 10:56:47 saradhak ship $*/
3: --
4: -- To modify this template, edit file PKGBODY.TXT in TEMPLATE
5: -- directory of SQL Navigator

Line 48: WHERE package_name = 'CSM_MTL_SEC_LOCATORS_EVENT_PKG'

44: CURSOR l_last_run_date_csr
45: IS
46: SELECT nvl(last_run_date, (sysdate - 365*50))
47: FROM jtm_con_request_data
48: WHERE package_name = 'CSM_MTL_SEC_LOCATORS_EVENT_PKG'
49: AND procedure_name = 'REFRESH_ACC';
50:
51: -- process inserts
52: CURSOR l_mtl_sec_loc_ins_csr

Line 198: WHERE package_name = 'CSM_MTL_SEC_LOCATORS_EVENT_PKG'

194:
195: -- set the program update date in jtm_con_request_data to sysdate
196: UPDATE jtm_con_request_data
197: SET last_run_date = l_run_date
198: WHERE package_name = 'CSM_MTL_SEC_LOCATORS_EVENT_PKG'
199: AND procedure_name = 'REFRESH_ACC';
200:
201: COMMIT;
202:

Line 204: p_message := 'CSM_MTL_SEC_LOCATORS_EVENT_PKG.Refresh_Acc Executed successfully';

200:
201: COMMIT;
202:
203: p_status := 'FINE';
204: p_message := 'CSM_MTL_SEC_LOCATORS_EVENT_PKG.Refresh_Acc Executed successfully';
205:
206: EXCEPTION
207: WHEN others THEN
208: l_sqlerrno := to_char(SQLCODE);

Line 211: p_message := 'Error in CSM_MTL_SEC_LOCATORS_EVENT_PKG.Refresh_Acc:' || l_sqlerrno || ':' || l_sqlerrmsg;

207: WHEN others THEN
208: l_sqlerrno := to_char(SQLCODE);
209: l_sqlerrmsg := substr(SQLERRM, 1,2000);
210: p_status := 'ERROR';
211: p_message := 'Error in CSM_MTL_SEC_LOCATORS_EVENT_PKG.Refresh_Acc:' || l_sqlerrno || ':' || l_sqlerrmsg;
212: ROLLBACK;
213: CSM_UTIL_PKG.LOG('CSM_MTL_SEC_LOCATORS_EVENT_PKG ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg, 'CSM_MTL_SEC_LOCATORS_EVENT_PKG.Refresh_acc',FND_LOG.LEVEL_EXCEPTION);
214: END Refresh_Acc;
215:

Line 213: CSM_UTIL_PKG.LOG('CSM_MTL_SEC_LOCATORS_EVENT_PKG ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg, 'CSM_MTL_SEC_LOCATORS_EVENT_PKG.Refresh_acc',FND_LOG.LEVEL_EXCEPTION);

209: l_sqlerrmsg := substr(SQLERRM, 1,2000);
210: p_status := 'ERROR';
211: p_message := 'Error in CSM_MTL_SEC_LOCATORS_EVENT_PKG.Refresh_Acc:' || l_sqlerrno || ':' || l_sqlerrmsg;
212: ROLLBACK;
213: CSM_UTIL_PKG.LOG('CSM_MTL_SEC_LOCATORS_EVENT_PKG ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg, 'CSM_MTL_SEC_LOCATORS_EVENT_PKG.Refresh_acc',FND_LOG.LEVEL_EXCEPTION);
214: END Refresh_Acc;
215:
216: END CSM_MTL_SEC_LOCATORS_EVENT_PKG;

Line 216: END CSM_MTL_SEC_LOCATORS_EVENT_PKG;

212: ROLLBACK;
213: CSM_UTIL_PKG.LOG('CSM_MTL_SEC_LOCATORS_EVENT_PKG ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg, 'CSM_MTL_SEC_LOCATORS_EVENT_PKG.Refresh_acc',FND_LOG.LEVEL_EXCEPTION);
214: END Refresh_Acc;
215:
216: END CSM_MTL_SEC_LOCATORS_EVENT_PKG;