APPS.CSM_CSI_ITEM_ATTR_EVENT_PKG dependencies on CSM_CSI_ITEM_ATTR_EVENT_PKG

Line 1: PACKAGE BODY CSM_CSI_ITEM_ATTR_EVENT_PKG AS

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

Line 46: WHERE package_name = 'CSM_CSI_ITEM_ATTR_EVENT_PKG'

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

Line 152: WHERE package_name = 'CSM_CSI_ITEM_ATTR_EVENT_PKG'

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

Line 158: p_message := 'CSM_CSI_ITEM_ATTR_EVENT_PKG.Refresh_Acc Executed successfully';

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

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

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

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

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

Line 170: END CSM_CSI_ITEM_ATTR_EVENT_PKG;

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