eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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.12020000.2 2013/04/09 10:56:58 saradhak ship $*/
3: --
4: -- To modify this template, edit file PKGBODY.TXT in TEMPLATE
5: -- directory of SQL Navigator

Line 58: WHERE package_name = 'CSM_MTL_PARAMETERS_EVENT_PKG'

54: CURSOR l_last_run_date_csr
55: IS
56: SELECT nvl(last_run_date, (sysdate - 365*50))
57: FROM jtm_con_request_data
58: WHERE package_name = 'CSM_MTL_PARAMETERS_EVENT_PKG'
59: AND procedure_name = 'REFRESH_ACC';
60:
61: -- inserts cur
62: CURSOR l_mtl_parameters_ins_csr

Line 197: WHERE package_name = 'CSM_MTL_PARAMETERS_EVENT_PKG'

193:
194: -- set the program update date in jtm_con_request_data to sysdate
195: UPDATE jtm_con_request_data
196: SET last_run_date = sysdate
197: WHERE package_name = 'CSM_MTL_PARAMETERS_EVENT_PKG'
198: AND procedure_name = 'REFRESH_ACC';
199:
200: COMMIT;
201:

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

199:
200: COMMIT;
201:
202: p_status := 'FINE';
203: p_message := 'CSM_MTL_PARAMETERS_EVENT_PKG.Refresh_Acc Executed successfully';
204:
205: EXCEPTION
206: WHEN others THEN
207: l_sqlerrno := to_char(SQLCODE);

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

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

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

208: l_sqlerrmsg := substr(SQLERRM, 1,3000);
209: p_status := 'ERROR';
210: p_message := 'Error in CSM_MTL_PARAMETERS_EVENT_PKG.Refresh_Acc: ' || l_sqlerrno || ':' || l_sqlerrmsg;
211: ROLLBACK;
212: fnd_file.put_line(fnd_file.log, 'CSM_MTL_PARAMETERS_EVENT_PKG ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
213: END Refresh_Acc;
214:
215: PROCEDURE Refresh_InterOrg_Acc (p_status OUT NOCOPY VARCHAR2,p_message OUT NOCOPY VARCHAR2)
216: IS

Line 235: WHERE package_name = 'CSM_MTL_PARAMETERS_EVENT_PKG'

231: CURSOR l_last_run_date_csr
232: IS
233: SELECT nvl(last_run_date, (sysdate - 365*50))
234: FROM jtm_con_request_data
235: WHERE package_name = 'CSM_MTL_PARAMETERS_EVENT_PKG'
236: AND procedure_name = 'REFRESH_INTERORG_ACC';
237:
238: -- inserts cur
239: CURSOR c_mtl_parameters_ins_csr(b_user_id NUMBER,b_res_id NUMBER)

Line 278: CSM_UTIL_PKG.LOG('Entered Refresh InterOrg Acc', 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_INTERORG_ACC', FND_LOG.LEVEL_PROCEDURE);

274: WHERE au.resource_id =inv.resource_id AND au.user_id=acc.user_id AND inv.organization_id in (acc.from_organization_id,acc.to_organization_id));
275:
276: BEGIN
277:
278: CSM_UTIL_PKG.LOG('Entered Refresh InterOrg Acc', 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_INTERORG_ACC', FND_LOG.LEVEL_PROCEDURE);
279:
280: -- get last conc program update date
281: OPEN l_last_run_date_csr;
282: FETCH l_last_run_date_csr INTO l_prog_update_date;

Line 286: CSM_UTIL_PKG.LOG('Processing deletes', 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_INTERORG_ACC', FND_LOG.LEVEL_PROCEDURE);

282: FETCH l_last_run_date_csr INTO l_prog_update_date;
283: CLOSE l_last_run_date_csr;
284:
285:
286: CSM_UTIL_PKG.LOG('Processing deletes', 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_INTERORG_ACC', FND_LOG.LEVEL_PROCEDURE);
287: -- process all deletes
288:
289: OPEN c_mtl_parameters_del_csr;
290: LOOP

Line 298: 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_INTERORG_ACC',FND_LOG.LEVEL_EVENT);

294: FETCH c_mtl_parameters_del_csr BULK COLLECT INTO l_tab_access_id,l_tab_user_id LIMIT 1000;
295: EXIT WHEN l_tab_access_id.COUNT = 0;
296:
297: CSM_UTIL_PKG.LOG('Bulk deleted ' || l_tab_access_id.count || ' records from CSM_INTERORG_PARAMETERS_ACC' ,
298: 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_INTERORG_ACC',FND_LOG.LEVEL_EVENT);
299:
300: l_markdirty := asg_download.mark_dirty(
301: P_PUB_ITEM => 'CSM_MTL_INTERORG_PARAMS'
302: , p_accessList => l_tab_access_id

Line 316: CSM_UTIL_PKG.LOG('Processing Updates', 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_INTERORG_ACC', FND_LOG.LEVEL_PROCEDURE);

312: END LOOP;
313: CLOSE c_mtl_parameters_del_csr;
314:
315:
316: CSM_UTIL_PKG.LOG('Processing Updates', 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_INTERORG_ACC', FND_LOG.LEVEL_PROCEDURE);
317: -- process all updates
318:
319: OPEN c_mtl_parameters_upd_csr(l_prog_update_date);
320: LOOP

Line 328: 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_INTERORG_ACC',FND_LOG.LEVEL_EVENT);

324: FETCH c_mtl_parameters_upd_csr BULK COLLECT INTO l_tab_access_id,l_tab_user_id LIMIT 1000;
325: EXIT WHEN l_tab_access_id.COUNT = 0;
326:
327: CSM_UTIL_PKG.LOG('Bulk updated ' || l_tab_access_id.count || ' records in CSM_INTERORG_PARAMETERS_ACC' ,
328: 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_INTERORG_ACC',FND_LOG.LEVEL_EVENT);
329:
330: l_markdirty := asg_download.mark_dirty(
331: P_PUB_ITEM => 'CSM_MTL_INTERORG_PARAMS'
332: , p_accessList => l_tab_access_id

Line 341: CSM_UTIL_PKG.LOG('Processing inserts', 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_INTERORG_ACC', FND_LOG.LEVEL_PROCEDURE);

337: COMMIT;
338: END LOOP;
339: CLOSE c_mtl_parameters_upd_csr;
340:
341: CSM_UTIL_PKG.LOG('Processing inserts', 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_INTERORG_ACC', FND_LOG.LEVEL_PROCEDURE);
342: -- process all inserts
343:
344:
345: FOR rec IN (SELECT user_id,resource_id from asg_user where MULTI_PLATFORM='Y' and enabled='Y')

Line 358: 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_INTERORG_ACC',FND_LOG.LEVEL_EVENT);

354: FETCH c_mtl_parameters_ins_csr BULK COLLECT INTO l_tab_access_id, l_tab_user_id,l_tab_from_org,l_tab_to_org LIMIT 1000;
355: EXIT WHEN l_tab_access_id.COUNT = 0;
356:
357: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count || ' records into CSM_INTERORG_PARAMETERS_ACC for user:'||rec.USER_ID ,
358: 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_INTERORG_ACC',FND_LOG.LEVEL_EVENT);
359:
360: FORALL i IN 1..l_tab_access_id.COUNT
361: INSERT INTO CSM_INTERORG_PARAMETERS_ACC (access_id, user_id,from_organization_id, to_organization_id,
362: counter, created_by, creation_date, last_updated_by, last_update_date )

Line 384: WHERE package_name = 'CSM_MTL_PARAMETERS_EVENT_PKG'

380:
381: -- set the program update date in jtm_con_request_data to sysdate
382: UPDATE jtm_con_request_data
383: SET last_run_date = sysdate
384: WHERE package_name = 'CSM_MTL_PARAMETERS_EVENT_PKG'
385: AND procedure_name = 'REFRESH_INTERORG_ACC';
386:
387: COMMIT;
388:

Line 390: p_message := 'CSM_MTL_PARAMETERS_EVENT_PKG.Refresh_InterOrg_Acc Executed successfully';

386:
387: COMMIT;
388:
389: p_status := 'FINE';
390: p_message := 'CSM_MTL_PARAMETERS_EVENT_PKG.Refresh_InterOrg_Acc Executed successfully';
391: CSM_UTIL_PKG.LOG('Leaving InterOrg refresh acc', 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_INTERORG_ACC', FND_LOG.LEVEL_PROCEDURE);
392:
393: EXCEPTION
394: WHEN others THEN

Line 391: CSM_UTIL_PKG.LOG('Leaving InterOrg refresh acc', 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_INTERORG_ACC', FND_LOG.LEVEL_PROCEDURE);

387: COMMIT;
388:
389: p_status := 'FINE';
390: p_message := 'CSM_MTL_PARAMETERS_EVENT_PKG.Refresh_InterOrg_Acc Executed successfully';
391: CSM_UTIL_PKG.LOG('Leaving InterOrg refresh acc', 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_INTERORG_ACC', FND_LOG.LEVEL_PROCEDURE);
392:
393: EXCEPTION
394: WHEN others THEN
395: l_sqlerrno := to_char(SQLCODE);

Line 398: p_message := 'Error in CSM_MTL_PARAMETERS_EVENT_PKG.Refresh_InterOrg_Acc: ' || l_sqlerrno || ':' || l_sqlerrmsg;

394: WHEN others THEN
395: l_sqlerrno := to_char(SQLCODE);
396: l_sqlerrmsg := substr(SQLERRM, 1,3000);
397: p_status := 'ERROR';
398: p_message := 'Error in CSM_MTL_PARAMETERS_EVENT_PKG.Refresh_InterOrg_Acc: ' || l_sqlerrno || ':' || l_sqlerrmsg;
399: CSM_UTIL_PKG.LOG('Exception: '||p_message, 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_INTERORG_ACC', FND_LOG.LEVEL_PROCEDURE);
400: ROLLBACK;
401: fnd_file.put_line(fnd_file.log, 'CSM_MTL_PARAMETERS_EVENT_PKG Refresh_InterOrg_Acc ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
402: END Refresh_InterOrg_Acc;

Line 399: CSM_UTIL_PKG.LOG('Exception: '||p_message, 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_INTERORG_ACC', FND_LOG.LEVEL_PROCEDURE);

395: l_sqlerrno := to_char(SQLCODE);
396: l_sqlerrmsg := substr(SQLERRM, 1,3000);
397: p_status := 'ERROR';
398: p_message := 'Error in CSM_MTL_PARAMETERS_EVENT_PKG.Refresh_InterOrg_Acc: ' || l_sqlerrno || ':' || l_sqlerrmsg;
399: CSM_UTIL_PKG.LOG('Exception: '||p_message, 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_INTERORG_ACC', FND_LOG.LEVEL_PROCEDURE);
400: ROLLBACK;
401: fnd_file.put_line(fnd_file.log, 'CSM_MTL_PARAMETERS_EVENT_PKG Refresh_InterOrg_Acc ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
402: END Refresh_InterOrg_Acc;
403:

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

397: p_status := 'ERROR';
398: p_message := 'Error in CSM_MTL_PARAMETERS_EVENT_PKG.Refresh_InterOrg_Acc: ' || l_sqlerrno || ':' || l_sqlerrmsg;
399: CSM_UTIL_PKG.LOG('Exception: '||p_message, 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_INTERORG_ACC', FND_LOG.LEVEL_PROCEDURE);
400: ROLLBACK;
401: fnd_file.put_line(fnd_file.log, 'CSM_MTL_PARAMETERS_EVENT_PKG Refresh_InterOrg_Acc ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
402: END Refresh_InterOrg_Acc;
403:
404: PROCEDURE REFRESH_FREIGHTS_ACC (p_status OUT NOCOPY VARCHAR2,p_message OUT NOCOPY VARCHAR2)
405: IS

Line 415: WHERE package_name = 'CSM_MTL_PARAMETERS_EVENT_PKG'

411: CURSOR l_last_run_date_csr
412: IS
413: SELECT nvl(last_run_date, (sysdate - 365*50))
414: FROM jtm_con_request_data
415: WHERE package_name = 'CSM_MTL_PARAMETERS_EVENT_PKG'
416: AND procedure_name = 'REFRESH_FREIGHTS_ACC';
417:
418: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
419: l_tab_user_id ASG_DOWNLOAD.USER_LIST;

Line 497: CSM_UTIL_PKG.LOG('Entered Refresh Inventory Org Freights Acc', 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_FREIGHTS_ACC', FND_LOG.LEVEL_PROCEDURE);

493: AND SM.ENABLED_FLAG='Y'
494: AND sysdate between sm.start_date_active AND nvl(sm.end_date_active, sysdate+1)));
495:
496: BEGIN
497: CSM_UTIL_PKG.LOG('Entered Refresh Inventory Org Freights Acc', 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_FREIGHTS_ACC', FND_LOG.LEVEL_PROCEDURE);
498:
499: -- get last conc program update date
500: OPEN l_last_run_date_csr;
501: FETCH l_last_run_date_csr INTO l_prog_update_date;

Line 504: CSM_UTIL_PKG.LOG('Processing deletes', 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_FREIGHTS_ACC', FND_LOG.LEVEL_PROCEDURE);

500: OPEN l_last_run_date_csr;
501: FETCH l_last_run_date_csr INTO l_prog_update_date;
502: CLOSE l_last_run_date_csr;
503:
504: CSM_UTIL_PKG.LOG('Processing deletes', 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_FREIGHTS_ACC', FND_LOG.LEVEL_PROCEDURE);
505: -- process all deletes
506:
507: OPEN c_inv_org_freights_del_csr;
508: LOOP

Line 516: 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_FREIGHTS_ACC',FND_LOG.LEVEL_EVENT);

512: FETCH c_inv_org_freights_del_csr BULK COLLECT INTO l_tab_access_id,l_tab_user_id LIMIT 1000;
513: EXIT WHEN l_tab_access_id.COUNT = 0;
514:
515: CSM_UTIL_PKG.LOG('Bulk deleted ' || l_tab_access_id.count || ' records from CSM_INTERORG_FREIGHTS_ACC' ,
516: 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_FREIGHTS_ACC',FND_LOG.LEVEL_EVENT);
517:
518: l_markdirty := asg_download.mark_dirty(
519: P_PUB_ITEM => 'CSM_INV_ORG_FREIGHTS'
520: , p_accessList => l_tab_access_id

Line 533: CSM_UTIL_PKG.LOG('Processing Updates', 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_FREIGHTS_ACC', FND_LOG.LEVEL_PROCEDURE);

529: COMMIT;
530: END LOOP;
531: CLOSE c_inv_org_freights_del_csr;
532:
533: CSM_UTIL_PKG.LOG('Processing Updates', 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_FREIGHTS_ACC', FND_LOG.LEVEL_PROCEDURE);
534: -- process all updates
535:
536: OPEN c_inv_org_freights_upd_csr(l_prog_update_date);
537: LOOP

Line 545: 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_FREIGHTS_ACC',FND_LOG.LEVEL_EVENT);

541: FETCH c_inv_org_freights_upd_csr BULK COLLECT INTO l_tab_access_id,l_tab_user_id LIMIT 1000;
542: EXIT WHEN l_tab_access_id.COUNT = 0;
543:
544: CSM_UTIL_PKG.LOG('Bulk updated ' || l_tab_access_id.count || ' records in CSM_INTERORG_FREIGHTS_ACC' ,
545: 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_FREIGHTS_ACC',FND_LOG.LEVEL_EVENT);
546:
547: l_markdirty := asg_download.mark_dirty(
548: P_PUB_ITEM => 'CSM_INV_ORG_FREIGHTS'
549: , p_accessList => l_tab_access_id

Line 558: CSM_UTIL_PKG.LOG('Processing inserts', 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_FREIGHTS_ACC', FND_LOG.LEVEL_PROCEDURE);

554: COMMIT;
555: END LOOP;
556: CLOSE c_inv_org_freights_upd_csr;
557:
558: CSM_UTIL_PKG.LOG('Processing inserts', 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_FREIGHTS_ACC', FND_LOG.LEVEL_PROCEDURE);
559: -- process all inserts
560:
561: OPEN c_inv_org_freights_ins_csr;
562: LOOP

Line 574: 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_FREIGHTS_ACC',FND_LOG.LEVEL_EVENT);

570: FETCH c_inv_org_freights_ins_csr BULK COLLECT INTO l_tab_access_id, l_tab_user_id,l_tab_org,l_tab_freight,l_tab_shipM LIMIT 1000;
571: EXIT WHEN l_tab_access_id.COUNT = 0;
572:
573: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count || ' records into CSM_INTERORG_FREIGHTS_ACC' ,
574: 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_FREIGHTS_ACC',FND_LOG.LEVEL_EVENT);
575:
576: FORALL i IN 1..l_tab_access_id.COUNT
577: INSERT INTO CSM_INV_ORG_FREIGHTS_ACC (access_id, user_id,organization_id, freight_code,ship_method_code,
578: created_by, creation_date, last_updated_by, last_update_date )

Line 599: WHERE package_name = 'CSM_MTL_PARAMETERS_EVENT_PKG'

595:
596: -- set the program update date in jtm_con_request_data to sysdate
597: UPDATE jtm_con_request_data
598: SET last_run_date = sysdate
599: WHERE package_name = 'CSM_MTL_PARAMETERS_EVENT_PKG'
600: AND procedure_name = 'REFRESH_FREIGHTS_ACC';
601:
602: COMMIT;
603:

Line 605: p_message := 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_FREIGHTS_ACC Executed successfully';

601:
602: COMMIT;
603:
604: p_status := 'FINE';
605: p_message := 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_FREIGHTS_ACC Executed successfully';
606: CSM_UTIL_PKG.LOG('Leaving InterOrg Freights refresh acc', 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_FREIGHTS_ACC', FND_LOG.LEVEL_PROCEDURE);
607:
608: EXCEPTION
609: WHEN others THEN

Line 606: CSM_UTIL_PKG.LOG('Leaving InterOrg Freights refresh acc', 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_FREIGHTS_ACC', FND_LOG.LEVEL_PROCEDURE);

602: COMMIT;
603:
604: p_status := 'FINE';
605: p_message := 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_FREIGHTS_ACC Executed successfully';
606: CSM_UTIL_PKG.LOG('Leaving InterOrg Freights refresh acc', 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_FREIGHTS_ACC', FND_LOG.LEVEL_PROCEDURE);
607:
608: EXCEPTION
609: WHEN others THEN
610: l_sqlerrno := to_char(SQLCODE);

Line 613: p_message := 'Error in CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_FREIGHTS_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg;

609: WHEN others THEN
610: l_sqlerrno := to_char(SQLCODE);
611: l_sqlerrmsg := substr(SQLERRM, 1,3000);
612: p_status := 'ERROR';
613: p_message := 'Error in CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_FREIGHTS_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg;
614: CSM_UTIL_PKG.LOG('Exception: '||p_message, 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_FREIGHTS_ACC', FND_LOG.LEVEL_PROCEDURE);
615: ROLLBACK;
616: fnd_file.put_line(fnd_file.log, 'CSM_MTL_PARAMETERS_EVENT_PKG REFRESH_FREIGHTS_ACC ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
617: END REFRESH_FREIGHTS_ACC;

Line 614: CSM_UTIL_PKG.LOG('Exception: '||p_message, 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_FREIGHTS_ACC', FND_LOG.LEVEL_PROCEDURE);

610: l_sqlerrno := to_char(SQLCODE);
611: l_sqlerrmsg := substr(SQLERRM, 1,3000);
612: p_status := 'ERROR';
613: p_message := 'Error in CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_FREIGHTS_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg;
614: CSM_UTIL_PKG.LOG('Exception: '||p_message, 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_FREIGHTS_ACC', FND_LOG.LEVEL_PROCEDURE);
615: ROLLBACK;
616: fnd_file.put_line(fnd_file.log, 'CSM_MTL_PARAMETERS_EVENT_PKG REFRESH_FREIGHTS_ACC ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
617: END REFRESH_FREIGHTS_ACC;
618:

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

612: p_status := 'ERROR';
613: p_message := 'Error in CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_FREIGHTS_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg;
614: CSM_UTIL_PKG.LOG('Exception: '||p_message, 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_FREIGHTS_ACC', FND_LOG.LEVEL_PROCEDURE);
615: ROLLBACK;
616: fnd_file.put_line(fnd_file.log, 'CSM_MTL_PARAMETERS_EVENT_PKG REFRESH_FREIGHTS_ACC ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
617: END REFRESH_FREIGHTS_ACC;
618:
619: END CSM_MTL_PARAMETERS_EVENT_PKG;

Line 619: END CSM_MTL_PARAMETERS_EVENT_PKG;

615: ROLLBACK;
616: fnd_file.put_line(fnd_file.log, 'CSM_MTL_PARAMETERS_EVENT_PKG REFRESH_FREIGHTS_ACC ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
617: END REFRESH_FREIGHTS_ACC;
618:
619: END CSM_MTL_PARAMETERS_EVENT_PKG;