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.MSC_ATP_DRP dependencies on MSC_UTIL

Line 379: msc_util.msc_log(' LOAD_SD_FULL_DRP Begin ');

375: IS
376: l_user_id NUMBER := FND_GLOBAL.USER_ID; -- Declare and Define value.
377: BEGIN
378:
379: msc_util.msc_log('******** LOAD_SD_FULL_DRP Begin ********');
380: msc_util.msc_log('LOAD_SD_FULL_DRP p_plan_id ' || p_plan_id);
381: msc_util.msc_log('LOAD_SD_FULL_DRP p_sys_date ' || p_sys_date);
382:
383: INSERT INTO MSC_ATP_SUMMARY_SD (

Line 380: msc_util.msc_log('LOAD_SD_FULL_DRP p_plan_id ' || p_plan_id);

376: l_user_id NUMBER := FND_GLOBAL.USER_ID; -- Declare and Define value.
377: BEGIN
378:
379: msc_util.msc_log('******** LOAD_SD_FULL_DRP Begin ********');
380: msc_util.msc_log('LOAD_SD_FULL_DRP p_plan_id ' || p_plan_id);
381: msc_util.msc_log('LOAD_SD_FULL_DRP p_sys_date ' || p_sys_date);
382:
383: INSERT INTO MSC_ATP_SUMMARY_SD (
384: plan_id,

Line 381: msc_util.msc_log('LOAD_SD_FULL_DRP p_sys_date ' || p_sys_date);

377: BEGIN
378:
379: msc_util.msc_log('******** LOAD_SD_FULL_DRP Begin ********');
380: msc_util.msc_log('LOAD_SD_FULL_DRP p_plan_id ' || p_plan_id);
381: msc_util.msc_log('LOAD_SD_FULL_DRP p_sys_date ' || p_sys_date);
382:
383: INSERT INTO MSC_ATP_SUMMARY_SD (
384: plan_id,
385: sr_instance_id,

Line 490: msc_util.msc_log('LOAD_SD_FULL_DRP: ' || 'Total Records inserted : ' || SQL%ROWCOUNT);

486: )
487: GROUP BY inventory_item_id,organization_id, sr_instance_id, demand_class, sd_date
488: );
489:
490: msc_util.msc_log('LOAD_SD_FULL_DRP: ' || 'Total Records inserted : ' || SQL%ROWCOUNT);
491: msc_util.msc_log('******** LOAD_SD_FULL_DRP End ********');
492:
493:
494: END LOAD_SD_FULL_DRP;

Line 491: msc_util.msc_log(' LOAD_SD_FULL_DRP End ');

487: GROUP BY inventory_item_id,organization_id, sr_instance_id, demand_class, sd_date
488: );
489:
490: msc_util.msc_log('LOAD_SD_FULL_DRP: ' || 'Total Records inserted : ' || SQL%ROWCOUNT);
491: msc_util.msc_log('******** LOAD_SD_FULL_DRP End ********');
492:
493:
494: END LOAD_SD_FULL_DRP;
495:

Line 519: msc_util.msc_log(' LOAD_SD_NET_DRP Begin ');

515:
516: l_user_id NUMBER := FND_GLOBAL.USER_ID; -- Declare and Define value.
517: BEGIN
518:
519: msc_util.msc_log('******** LOAD_SD_NET_DRP Begin ********');
520: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'p_last_refresh_number - ' || p_last_refresh_number);
521: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'p_new_refresh_number - ' || p_new_refresh_number);
522: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'p_plan_id - ' || p_plan_id);
523: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'p_sys_date - ' || p_sys_date);

Line 520: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'p_last_refresh_number - ' || p_last_refresh_number);

516: l_user_id NUMBER := FND_GLOBAL.USER_ID; -- Declare and Define value.
517: BEGIN
518:
519: msc_util.msc_log('******** LOAD_SD_NET_DRP Begin ********');
520: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'p_last_refresh_number - ' || p_last_refresh_number);
521: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'p_new_refresh_number - ' || p_new_refresh_number);
522: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'p_plan_id - ' || p_plan_id);
523: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'p_sys_date - ' || p_sys_date);
524:

Line 521: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'p_new_refresh_number - ' || p_new_refresh_number);

517: BEGIN
518:
519: msc_util.msc_log('******** LOAD_SD_NET_DRP Begin ********');
520: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'p_last_refresh_number - ' || p_last_refresh_number);
521: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'p_new_refresh_number - ' || p_new_refresh_number);
522: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'p_plan_id - ' || p_plan_id);
523: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'p_sys_date - ' || p_sys_date);
524:
525:

Line 522: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'p_plan_id - ' || p_plan_id);

518:
519: msc_util.msc_log('******** LOAD_SD_NET_DRP Begin ********');
520: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'p_last_refresh_number - ' || p_last_refresh_number);
521: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'p_new_refresh_number - ' || p_new_refresh_number);
522: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'p_plan_id - ' || p_plan_id);
523: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'p_sys_date - ' || p_sys_date);
524:
525:
526: SELECT sr_instance_id,

Line 523: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'p_sys_date - ' || p_sys_date);

519: msc_util.msc_log('******** LOAD_SD_NET_DRP Begin ********');
520: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'p_last_refresh_number - ' || p_last_refresh_number);
521: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'p_new_refresh_number - ' || p_new_refresh_number);
522: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'p_plan_id - ' || p_plan_id);
523: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'p_sys_date - ' || p_sys_date);
524:
525:
526: SELECT sr_instance_id,
527: organization_id,

Line 616: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'Total Row COUNT := ' || l_inventory_item_id_tab.COUNT);

612: AND S.REFRESH_NUMBER BETWEEN (p_last_refresh_number + 1) and p_new_refresh_number
613: )
614: GROUP BY inventory_item_id, organization_id, sr_instance_id, sd_date;
615:
616: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'Total Row COUNT := ' || l_inventory_item_id_tab.COUNT);
617:
618: IF l_inventory_item_id_tab.COUNT > 0 THEN
619:
620: forall j IN l_inventory_item_id_tab.first.. l_inventory_item_id_tab.last

Line 631: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'After FORALL UPDATE');

627: AND inventory_item_id = l_inventory_item_id_tab(j)
628: AND organization_id = l_organization_id_tab(j)
629: AND sd_date = l_sd_date_tab(j);
630:
631: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'After FORALL UPDATE');
632:
633: FOR j IN l_inventory_item_id_tab.first.. l_inventory_item_id_tab.last LOOP
634: -- Count how many rows were updated for each item.
635: msc_util.msc_log('LOAD_SD_NET_DRP: For Item id '|| l_inventory_item_id_tab(j)||': updated '||

Line 635: msc_util.msc_log('LOAD_SD_NET_DRP: For Item id '|| l_inventory_item_id_tab(j)||': updated '||

631: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'After FORALL UPDATE');
632:
633: FOR j IN l_inventory_item_id_tab.first.. l_inventory_item_id_tab.last LOOP
634: -- Count how many rows were updated for each item.
635: msc_util.msc_log('LOAD_SD_NET_DRP: For Item id '|| l_inventory_item_id_tab(j)||': updated '||
636: SQL%BULK_ROWCOUNT(j)||' records');
637: IF SQL%BULK_ROWCOUNT(j) = 0 THEN
638: l_ins_sr_instance_id_tab.EXTEND;
639: l_ins_organization_id_tab.EXTEND;

Line 652: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'l_ins_inventory_item_id_tab.COUNT := ' || l_ins_inventory_item_id_tab.COUNT);

648: l_ins_sd_quantity_tab(l_ins_sd_quantity_tab.LAST) := l_sd_quantity_tab(j);
649: END IF;
650: END LOOP;
651:
652: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'l_ins_inventory_item_id_tab.COUNT := ' || l_ins_inventory_item_id_tab.COUNT);
653:
654: IF l_ins_inventory_item_id_tab.COUNT > 0 THEN
655:
656:

Line 682: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'After FORALL INSERT');

678: l_user_id,
679: p_sys_date,
680: l_user_id);
681:
682: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'After FORALL INSERT');
683: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'Total Records inserted : ' || SQL%ROWCOUNT);
684:
685: ELSE
686: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'No records to be inserted');

Line 683: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'Total Records inserted : ' || SQL%ROWCOUNT);

679: p_sys_date,
680: l_user_id);
681:
682: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'After FORALL INSERT');
683: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'Total Records inserted : ' || SQL%ROWCOUNT);
684:
685: ELSE
686: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'No records to be inserted');
687: END IF;

Line 686: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'No records to be inserted');

682: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'After FORALL INSERT');
683: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'Total Records inserted : ' || SQL%ROWCOUNT);
684:
685: ELSE
686: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'No records to be inserted');
687: END IF;
688: ELSE
689: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'No records fetched in the net cursor');
690: END IF;

Line 689: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'No records fetched in the net cursor');

685: ELSE
686: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'No records to be inserted');
687: END IF;
688: ELSE
689: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'No records fetched in the net cursor');
690: END IF;
691:
692: msc_util.msc_log('******** LOAD_SD_NET_DRP End ********');
693:

Line 692: msc_util.msc_log(' LOAD_SD_NET_DRP End ');

688: ELSE
689: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'No records fetched in the net cursor');
690: END IF;
691:
692: msc_util.msc_log('******** LOAD_SD_NET_DRP End ********');
693:
694: -- Exception included here since Array processing happens in this procedure
695: EXCEPTION
696: WHEN OTHERS THEN

Line 697: msc_util.msc_log ('LOAD_SD_NET_DRP: ' || 'ERROR , sqlcode= '|| sqlcode);

693:
694: -- Exception included here since Array processing happens in this procedure
695: EXCEPTION
696: WHEN OTHERS THEN
697: msc_util.msc_log ('LOAD_SD_NET_DRP: ' || 'ERROR , sqlcode= '|| sqlcode);
698: msc_util.msc_log ('LOAD_SD_NET_DRP: IN Exception Block in others');
699: msc_util.msc_log ('ERROR := ' || SQLERRM);
700:
701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 698: msc_util.msc_log ('LOAD_SD_NET_DRP: IN Exception Block in others');

694: -- Exception included here since Array processing happens in this procedure
695: EXCEPTION
696: WHEN OTHERS THEN
697: msc_util.msc_log ('LOAD_SD_NET_DRP: ' || 'ERROR , sqlcode= '|| sqlcode);
698: msc_util.msc_log ('LOAD_SD_NET_DRP: IN Exception Block in others');
699: msc_util.msc_log ('ERROR := ' || SQLERRM);
700:
701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
702:

Line 699: msc_util.msc_log ('ERROR := ' || SQLERRM);

695: EXCEPTION
696: WHEN OTHERS THEN
697: msc_util.msc_log ('LOAD_SD_NET_DRP: ' || 'ERROR , sqlcode= '|| sqlcode);
698: msc_util.msc_log ('LOAD_SD_NET_DRP: IN Exception Block in others');
699: msc_util.msc_log ('ERROR := ' || SQLERRM);
700:
701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
702:
703: END LOAD_SD_NET_DRP;