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 2005/07/25 00:13:47 trajasek noship $*/
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 159: WHERE package_name = 'CSM_MTL_SEC_LOCATORS_EVENT_PKG'

155:
156: -- set the program update date in jtm_con_request_data to sysdate
157: UPDATE jtm_con_request_data
158: SET last_run_date = l_run_date
159: WHERE package_name = 'CSM_MTL_SEC_LOCATORS_EVENT_PKG'
160: AND procedure_name = 'REFRESH_ACC';
161:
162: COMMIT;
163:

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

161:
162: COMMIT;
163:
164: p_status := 'FINE';
165: p_message := 'CSM_MTL_SEC_LOCATORS_EVENT_PKG.Refresh_Acc Executed successfully';
166:
167: EXCEPTION
168: WHEN others THEN
169: l_sqlerrno := to_char(SQLCODE);

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

168: WHEN others THEN
169: l_sqlerrno := to_char(SQLCODE);
170: l_sqlerrmsg := substr(SQLERRM, 1,2000);
171: p_status := 'ERROR';
172: p_message := 'Error in CSM_MTL_SEC_LOCATORS_EVENT_PKG.Refresh_Acc:' || l_sqlerrno || ':' || l_sqlerrmsg;
173: ROLLBACK;
174: 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);
175: END Refresh_Acc;
176:

Line 174: 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);

170: l_sqlerrmsg := substr(SQLERRM, 1,2000);
171: p_status := 'ERROR';
172: p_message := 'Error in CSM_MTL_SEC_LOCATORS_EVENT_PKG.Refresh_Acc:' || l_sqlerrno || ':' || l_sqlerrmsg;
173: ROLLBACK;
174: 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);
175: END Refresh_Acc;
176:
177: END CSM_MTL_SEC_LOCATORS_EVENT_PKG;

Line 177: END CSM_MTL_SEC_LOCATORS_EVENT_PKG;

173: ROLLBACK;
174: 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);
175: END Refresh_Acc;
176:
177: END CSM_MTL_SEC_LOCATORS_EVENT_PKG;