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_UTIL_PKG

Line 104: l_all_omfs_palm_resource_list := csm_util_pkg.get_all_omfs_palm_res_list;

100: FOR r_mtl_parameters_del_rec IN l_mtl_parameters_del_csr LOOP
101:
102: --get the users with this language
103: l_all_omfs_palm_resource_list := l_null_resource_list;
104: l_all_omfs_palm_resource_list := csm_util_pkg.get_all_omfs_palm_res_list;
105:
106: l_access_id := r_mtl_parameters_del_rec.access_id;
107:
108: --nullify the access list

Line 116: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSM_MTL_PARAMETERS',

112: END LOOP;
113:
114: --mark dirty the SDQ for all users
115: IF l_single_access_id_list.count > 0 THEN
116: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSM_MTL_PARAMETERS',
117: l_single_access_id_list, l_all_omfs_palm_resource_list,
118: ASG_DOWNLOAD.DEL, sysdate);
119: END IF;
120:

Line 130: l_all_omfs_palm_resource_list := csm_util_pkg.get_all_omfs_palm_res_list;

126: FOR r_mtl_parameters_upd_rec IN l_mtl_parameters_upd_csr(l_prog_update_date) LOOP
127:
128: --get the users with this language
129: l_all_omfs_palm_resource_list := l_null_resource_list;
130: l_all_omfs_palm_resource_list := csm_util_pkg.get_all_omfs_palm_res_list;
131:
132: l_access_id := r_mtl_parameters_upd_rec.access_id;
133:
134: --nullify the access list

Line 142: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSM_MTL_PARAMETERS',

138: END LOOP;
139:
140: --mark dirty the SDQ for all users
141: IF l_single_access_id_list.count > 0 THEN
142: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSM_MTL_PARAMETERS',
143: l_single_access_id_list, l_all_omfs_palm_resource_list,
144: ASG_DOWNLOAD.UPD, sysdate);
145: END IF;
146:

Line 154: l_all_omfs_palm_resource_list := csm_util_pkg.get_all_omfs_palm_res_list;

150: FOR r_mtl_parameters_ins_rec IN l_mtl_parameters_ins_csr LOOP
151:
152: --get the users with this language
153: l_all_omfs_palm_resource_list := l_null_resource_list;
154: l_all_omfs_palm_resource_list := csm_util_pkg.get_all_omfs_palm_res_list;
155:
156: SELECT csm_mtl_parameters_acc_s.nextval
157: INTO l_access_id
158: FROM dual;

Line 168: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSM_MTL_PARAMETERS',

164: END LOOP;
165:
166: --mark dirty the SDQ for all users
167: IF l_single_access_id_list.count > 0 THEN
168: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSM_MTL_PARAMETERS',
169: l_single_access_id_list, l_all_omfs_palm_resource_list,
170: ASG_DOWNLOAD.INS, sysdate);
171: END IF;
172:

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 297: CSM_UTIL_PKG.LOG('Bulk deleted ' || l_tab_access_id.count || ' records from CSM_INTERORG_PARAMETERS_ACC' ,

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

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 327: CSM_UTIL_PKG.LOG('Bulk updated ' || l_tab_access_id.count || ' records in CSM_INTERORG_PARAMETERS_ACC' ,

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

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 357: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count || ' records into CSM_INTERORG_PARAMETERS_ACC for user:'||rec.USER_ID ,

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

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 515: CSM_UTIL_PKG.LOG('Bulk deleted ' || l_tab_access_id.count || ' records from CSM_INTERORG_FREIGHTS_ACC' ,

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

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 544: CSM_UTIL_PKG.LOG('Bulk updated ' || l_tab_access_id.count || ' records in CSM_INTERORG_FREIGHTS_ACC' ,

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

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 573: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count || ' records into CSM_INTERORG_FREIGHTS_ACC' ,

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

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: