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 378: msc_util.msc_log(' LOAD_SD_FULL_DRP Begin ');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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