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 FND_LOG

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 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 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 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 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 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: