APPS.CSM_MESSAGES_EVENT_PKG dependencies on CSM_MESSAGES_EVENT_PKG

Line 1: PACKAGE BODY CSM_MESSAGES_EVENT_PKG AS

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

Line 38: WHERE package_name = 'CSM_MESSAGES_EVENT_PKG'

34: CURSOR l_last_run_date_csr(p_pub_item IN varchar2)
35: IS
36: SELECT nvl(last_run_date, (sysdate - 365*50))
37: FROM jtm_con_request_data
38: WHERE package_name = 'CSM_MESSAGES_EVENT_PKG'
39: AND procedure_name = 'REFRESH_ACC';
40:
41: -- inserts cur
42: CURSOR l_messages_ins_csr(p_last_upd_date date)

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

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

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

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

Line 215: END CSM_MESSAGES_EVENT_PKG;

211: p_message := 'Error in CSM_MESSAGES_EVENT_PKG.Refresh_Acc : ' || l_sqlerrno || ':' || l_sqlerrmsg;
212: fnd_file.put_line(fnd_file.log, p_message);
213: ROLLBACK;
214: END Refresh_Acc;
215: END CSM_MESSAGES_EVENT_PKG;