APPS.CSM_MTL_ITEM_LOC_EVENT_PKG dependencies on CSM_MTL_ITEM_LOC_EVENT_PKG

Line 1: PACKAGE BODY CSM_MTL_ITEM_LOC_EVENT_PKG AS

1: PACKAGE BODY CSM_MTL_ITEM_LOC_EVENT_PKG AS
2: /* $Header: csmemilb.pls 120.1 2005/07/25 00:11:28 trajasek noship $*/
3: --
4: -- To modify this template, edit file PKGBODY.TXT in TEMPLATE
5: -- directory of SQL Navigator

Line 47: WHERE package_name = 'CSM_MTL_ITEM_LOC_EVENT_PKG'

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

Line 151: WHERE package_name = 'CSM_MTL_ITEM_LOC_EVENT_PKG'

147:
148: -- set the program update date in jtm_con_request_data to sysdate
149: UPDATE jtm_con_request_data
150: SET last_run_date = l_run_date
151: WHERE package_name = 'CSM_MTL_ITEM_LOC_EVENT_PKG'
152: AND procedure_name = 'REFRESH_ACC';
153:
154: COMMIT;
155:

Line 157: p_message := 'CSM_MTL_ITEM_LOC_EVENT_PKG.Refresh_Acc Executed successfully';

153:
154: COMMIT;
155:
156: p_status := 'FINE';
157: p_message := 'CSM_MTL_ITEM_LOC_EVENT_PKG.Refresh_Acc Executed successfully';
158:
159: EXCEPTION
160: WHEN others THEN
161: l_sqlerrno := to_char(SQLCODE);

Line 164: p_message := 'Error in CSM_MTL_ITEM_LOC_EVENT_PKG.Refresh_Acc: '|| l_sqlerrno || ':' || l_sqlerrmsg;

160: WHEN others THEN
161: l_sqlerrno := to_char(SQLCODE);
162: l_sqlerrmsg := substr(SQLERRM, 1,2000);
163: p_status := 'ERROR';
164: p_message := 'Error in CSM_MTL_ITEM_LOC_EVENT_PKG.Refresh_Acc: '|| l_sqlerrno || ':' || l_sqlerrmsg;
165: ROLLBACK;
166: CSM_UTIL_PKG.LOG('CSM_MTL_ITEM_LOC_EVENT_PKG ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg, 'CSM_MTL_ITEM_LOC_EVENT_PKG.Refresh_acc',FND_LOG.LEVEL_EXCEPTION);
167: END Refresh_Acc;
168:

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

162: l_sqlerrmsg := substr(SQLERRM, 1,2000);
163: p_status := 'ERROR';
164: p_message := 'Error in CSM_MTL_ITEM_LOC_EVENT_PKG.Refresh_Acc: '|| l_sqlerrno || ':' || l_sqlerrmsg;
165: ROLLBACK;
166: CSM_UTIL_PKG.LOG('CSM_MTL_ITEM_LOC_EVENT_PKG ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg, 'CSM_MTL_ITEM_LOC_EVENT_PKG.Refresh_acc',FND_LOG.LEVEL_EXCEPTION);
167: END Refresh_Acc;
168:
169: END CSM_MTL_ITEM_LOC_EVENT_PKG;

Line 169: END CSM_MTL_ITEM_LOC_EVENT_PKG;

165: ROLLBACK;
166: CSM_UTIL_PKG.LOG('CSM_MTL_ITEM_LOC_EVENT_PKG ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg, 'CSM_MTL_ITEM_LOC_EVENT_PKG.Refresh_acc',FND_LOG.LEVEL_EXCEPTION);
167: END Refresh_Acc;
168:
169: END CSM_MTL_ITEM_LOC_EVENT_PKG;