APPS.CSM_IB_TXN_SUB_TYPES_EVENT_PKG dependencies on CSM_IB_TXN_SUB_TYPES_EVENT_PKG

Line 1: PACKAGE BODY CSM_IB_TXN_SUB_TYPES_EVENT_PKG AS

1: PACKAGE BODY CSM_IB_TXN_SUB_TYPES_EVENT_PKG AS
2: /* $Header: csmeibtb.pls 120.3 2006/09/05 07:02:36 trajasek noship $*/
3: --
4: -- To modify this template, edit file PKGBODY.TXT in TEMPLATE
5: -- directory of SQL Navigator

Line 43: WHERE package_name = 'CSM_IB_TXN_SUB_TYPES_EVENT_PKG'

39: CURSOR l_last_run_date_csr
40: IS
41: SELECT nvl(last_run_date, (sysdate - 365*50))
42: FROM jtm_con_request_data
43: WHERE package_name = 'CSM_IB_TXN_SUB_TYPES_EVENT_PKG'
44: AND procedure_name = 'REFRESH_ACC';
45:
46: CURSOR l_deletes_cur
47: IS

Line 329: WHERE package_name = 'CSM_IB_TXN_SUB_TYPES_EVENT_PKG'

325:
326: -- set the program update date in jtm_con_request_data to sysdate
327: UPDATE jtm_con_request_data
328: SET last_run_date = l_run_date
329: WHERE package_name = 'CSM_IB_TXN_SUB_TYPES_EVENT_PKG'
330: AND procedure_name = 'REFRESH_ACC';
331:
332: COMMIT;
333:

Line 335: p_message := 'CSM_IB_TXN_SUB_TYPES_EVENT_PKG.Refresh_Acc Executed successfully';

331:
332: COMMIT;
333:
334: p_status := 'FINE';
335: p_message := 'CSM_IB_TXN_SUB_TYPES_EVENT_PKG.Refresh_Acc Executed successfully';
336:
337: EXCEPTION
338: WHEN others THEN
339: if record_exists_csr%isopen then

Line 345: p_message := 'Error in CSM_IB_TXN_SUB_TYPES_EVENT_PKG.Refresh_Acc: '|| l_sqlerrno || ':' || l_sqlerrmsg;

341: end if;
342: l_sqlerrno := to_char(SQLCODE);
343: l_sqlerrmsg := substr(SQLERRM, 1,2000);
344: p_status := 'ERROR';
345: p_message := 'Error in CSM_IB_TXN_SUB_TYPES_EVENT_PKG.Refresh_Acc: '|| l_sqlerrno || ':' || l_sqlerrmsg;
346: ROLLBACK;
347: fnd_file.put_line(fnd_file.log, 'CSM_IB_TXN_SUB_TYPES_EVENT_PKG.REFRESH_ACC ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
348: END Refresh_Acc;
349:

Line 347: fnd_file.put_line(fnd_file.log, 'CSM_IB_TXN_SUB_TYPES_EVENT_PKG.REFRESH_ACC ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);

343: l_sqlerrmsg := substr(SQLERRM, 1,2000);
344: p_status := 'ERROR';
345: p_message := 'Error in CSM_IB_TXN_SUB_TYPES_EVENT_PKG.Refresh_Acc: '|| l_sqlerrno || ':' || l_sqlerrmsg;
346: ROLLBACK;
347: fnd_file.put_line(fnd_file.log, 'CSM_IB_TXN_SUB_TYPES_EVENT_PKG.REFRESH_ACC ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
348: END Refresh_Acc;
349:
350: END CSM_IB_TXN_SUB_TYPES_EVENT_PKG;

Line 350: END CSM_IB_TXN_SUB_TYPES_EVENT_PKG;

346: ROLLBACK;
347: fnd_file.put_line(fnd_file.log, 'CSM_IB_TXN_SUB_TYPES_EVENT_PKG.REFRESH_ACC ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
348: END Refresh_Acc;
349:
350: END CSM_IB_TXN_SUB_TYPES_EVENT_PKG;