APPS.CSM_MTL_PARAMETERS_EVENT_PKG dependencies on CSM_MTL_PARAMETERS_EVENT_PKG

Line 1: PACKAGE BODY CSM_MTL_PARAMETERS_EVENT_PKG AS

1: PACKAGE BODY CSM_MTL_PARAMETERS_EVENT_PKG AS
2: /* $Header: csmemtpb.pls 120.1 2005/07/25 00:14:32 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_MTL_PARAMETERS_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_MTL_PARAMETERS_EVENT_PKG'
47: AND procedure_name = 'REFRESH_ACC';
48:
49: -- inserts cur
50: CURSOR l_mtl_parameters_ins_csr

Line 187: WHERE package_name = 'CSM_MTL_PARAMETERS_EVENT_PKG'

183:
184: -- set the program update date in jtm_con_request_data to sysdate
185: UPDATE jtm_con_request_data
186: SET last_run_date = l_run_date
187: WHERE package_name = 'CSM_MTL_PARAMETERS_EVENT_PKG'
188: AND procedure_name = 'REFRESH_ACC';
189:
190: COMMIT;
191:

Line 193: p_message := 'CSM_MTL_PARAMETERS_EVENT_PKG.Refresh_Acc Executed successfully';

189:
190: COMMIT;
191:
192: p_status := 'FINE';
193: p_message := 'CSM_MTL_PARAMETERS_EVENT_PKG.Refresh_Acc Executed successfully';
194:
195: EXCEPTION
196: WHEN others THEN
197: l_sqlerrno := to_char(SQLCODE);

Line 200: p_message := 'Error in CSM_MTL_PARAMETERS_EVENT_PKG.Refresh_Acc: ' || l_sqlerrno || ':' || l_sqlerrmsg;

196: WHEN others THEN
197: l_sqlerrno := to_char(SQLCODE);
198: l_sqlerrmsg := substr(SQLERRM, 1,2000);
199: p_status := 'ERROR';
200: p_message := 'Error in CSM_MTL_PARAMETERS_EVENT_PKG.Refresh_Acc: ' || l_sqlerrno || ':' || l_sqlerrmsg;
201: ROLLBACK;
202: fnd_file.put_line(fnd_file.log, 'CSM_MTL_PARAMETERS_EVENT_PKG ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
203: END Refresh_Acc;
204:

Line 202: fnd_file.put_line(fnd_file.log, 'CSM_MTL_PARAMETERS_EVENT_PKG ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);

198: l_sqlerrmsg := substr(SQLERRM, 1,2000);
199: p_status := 'ERROR';
200: p_message := 'Error in CSM_MTL_PARAMETERS_EVENT_PKG.Refresh_Acc: ' || l_sqlerrno || ':' || l_sqlerrmsg;
201: ROLLBACK;
202: fnd_file.put_line(fnd_file.log, 'CSM_MTL_PARAMETERS_EVENT_PKG ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
203: END Refresh_Acc;
204:
205: END CSM_MTL_PARAMETERS_EVENT_PKG;

Line 205: END CSM_MTL_PARAMETERS_EVENT_PKG;

201: ROLLBACK;
202: fnd_file.put_line(fnd_file.log, 'CSM_MTL_PARAMETERS_EVENT_PKG ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
203: END Refresh_Acc;
204:
205: END CSM_MTL_PARAMETERS_EVENT_PKG;