APPS.CSM_UOM_EVENT_PKG dependencies on CSM_UOM_EVENT_PKG

Line 1: PACKAGE BODY CSM_UOM_EVENT_PKG AS

1: PACKAGE BODY CSM_UOM_EVENT_PKG AS
2: /* $Header: csmeuomb.pls 120.2 2006/04/06 05:19:34 trajasek noship $ */
3:
4: PROCEDURE INSERT_CSM_UOM_TL_ACC (p_access_id IN number,
5: p_uom_code mtl_units_of_measure_tl.uom_code%TYPE,

Line 49: WHERE package_name = 'CSM_UOM_EVENT_PKG'

45: CURSOR l_last_run_date_csr(p_pub_item IN varchar2)
46: IS
47: SELECT nvl(last_run_date, (sysdate - 365*50))
48: FROM jtm_con_request_data
49: WHERE package_name = 'CSM_UOM_EVENT_PKG'
50: AND procedure_name = 'REFRESH_ACC';
51:
52: -- inserts cursor
53: CURSOR l_uom_ins_csr

Line 198: WHERE package_name = 'CSM_UOM_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_UOM_EVENT_PKG'
199: AND procedure_name = 'REFRESH_ACC';
200:
201: COMMIT;
202:

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

200:
201: COMMIT;
202:
203: p_status := 'FINE';
204: p_message := 'CSM_UOM_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_UOM_EVENT_PKG.Refresh_Acc :' || l_sqlerrno || ':' || l_sqlerrmsg;

207: WHEN others THEN
208: l_sqlerrno := to_char(SQLCODE);
209: l_sqlerrmsg := substr(SQLERRM, 1,1000);
210: p_status := 'ERROR';
211: p_message := 'Error in CSM_UOM_EVENT_PKG.Refresh_Acc :' || l_sqlerrno || ':' || l_sqlerrmsg;
212: ROLLBACK TO pre_refresh;
213: fnd_file.put_line(fnd_file.log, 'CSM_UOM_EVENT_PKG ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
214: END Refresh_acc;
215:

Line 213: fnd_file.put_line(fnd_file.log, 'CSM_UOM_EVENT_PKG ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);

209: l_sqlerrmsg := substr(SQLERRM, 1,1000);
210: p_status := 'ERROR';
211: p_message := 'Error in CSM_UOM_EVENT_PKG.Refresh_Acc :' || l_sqlerrno || ':' || l_sqlerrmsg;
212: ROLLBACK TO pre_refresh;
213: fnd_file.put_line(fnd_file.log, 'CSM_UOM_EVENT_PKG ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
214: END Refresh_acc;
215:
216: END CSM_UOM_EVENT_PKG;

Line 216: END CSM_UOM_EVENT_PKG;

212: ROLLBACK TO pre_refresh;
213: fnd_file.put_line(fnd_file.log, 'CSM_UOM_EVENT_PKG ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
214: END Refresh_acc;
215:
216: END CSM_UOM_EVENT_PKG;