APPS.CSM_TXN_BILL_TYPES_EVENT_PKG dependencies on CSM_TXN_BILL_TYPES_EVENT_PKG

Line 1: PACKAGE BODY CSM_TXN_BILL_TYPES_EVENT_PKG AS

1: PACKAGE BODY CSM_TXN_BILL_TYPES_EVENT_PKG AS
2: /* $Header: csmetbtb.pls 120.1 2005/07/25 00:26:50 trajasek noship $ */
3: g_all_palm_res_list asg_download.user_list;
4:
5: /**

Line 44: WHERE package_name = 'CSM_TXN_BILL_TYPES_EVENT_PKG'

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

Line 266: WHERE package_name = 'CSM_TXN_BILL_TYPES_EVENT_PKG'

262:
263: -- set the program update date in jtm_con_request_data to sysdate
264: UPDATE jtm_con_request_data
265: SET last_run_date = l_run_date
266: WHERE package_name = 'CSM_TXN_BILL_TYPES_EVENT_PKG'
267: AND procedure_name = 'REFRESH_ACC';
268:
269: COMMIT;
270:

Line 272: p_message := 'CSM_TXN_BILL_TYPES_EVENT_PKG.Refresh_Acc Executed successfully';

268:
269: COMMIT;
270:
271: p_status := 'FINE';
272: p_message := 'CSM_TXN_BILL_TYPES_EVENT_PKG.Refresh_Acc Executed successfully';
273:
274: EXCEPTION
275: WHEN others THEN
276: if record_exists_csr%isopen then

Line 282: p_message := 'Error in CSM_TXN_BILL_TYPES_EVENT_PKG.Refresh_Acc :' || l_sqlerrno || ':' || l_sqlerrmsg;

278: end if;
279: l_sqlerrno := to_char(SQLCODE);
280: l_sqlerrmsg := substr(SQLERRM, 1,2000);
281: p_status := 'ERROR';
282: p_message := 'Error in CSM_TXN_BILL_TYPES_EVENT_PKG.Refresh_Acc :' || l_sqlerrno || ':' || l_sqlerrmsg;
283: ROLLBACK;
284: fnd_file.put_line(fnd_file.log, p_message);
285: END Refresh_Acc;
286: END CSM_TXN_BILL_TYPES_EVENT_PKG;

Line 286: END CSM_TXN_BILL_TYPES_EVENT_PKG;

282: p_message := 'Error in CSM_TXN_BILL_TYPES_EVENT_PKG.Refresh_Acc :' || l_sqlerrno || ':' || l_sqlerrmsg;
283: ROLLBACK;
284: fnd_file.put_line(fnd_file.log, p_message);
285: END Refresh_Acc;
286: END CSM_TXN_BILL_TYPES_EVENT_PKG;