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_POST_PRO dependencies on FND_PROFILE

Line 7: PG_DEBUG VARCHAR2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');

3: AS
4:
5: MAXVALUE CONSTANT NUMBER := 999999;
6:
7: PG_DEBUG VARCHAR2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');
8:
9: -- for summary enhancement
10: G_ALLOC_ATP VARCHAR2(1);
11: G_CLASS_HRCHY NUMBER;

Line 126: l_inv_ctp := NVL(FND_PROFILE.value('INV_CTP'), 5);

122: BEGIN
123: -- Bug 3304390 Disable Trace
124: -- Deleted Related code.
125:
126: l_inv_ctp := NVL(FND_PROFILE.value('INV_CTP'), 5);
127: msc_util.msc_log('inv_ctp := ' || l_inv_ctp);
128:
129: l_enable_summary_mode := NVL(FND_PROFILE.value('MSC_ENABLE_ATP_SUMMARY'), 'N');
130: msc_util.msc_log(' l_enable_summary_mode := ' || l_enable_summary_mode);

Line 129: l_enable_summary_mode := NVL(FND_PROFILE.value('MSC_ENABLE_ATP_SUMMARY'), 'N');

125:
126: l_inv_ctp := NVL(FND_PROFILE.value('INV_CTP'), 5);
127: msc_util.msc_log('inv_ctp := ' || l_inv_ctp);
128:
129: l_enable_summary_mode := NVL(FND_PROFILE.value('MSC_ENABLE_ATP_SUMMARY'), 'N');
130: msc_util.msc_log(' l_enable_summary_mode := ' || l_enable_summary_mode);
131: IF l_enable_summary_mode <> 'Y' THEN
132: msc_util.msc_log('Summary Mode is not enabled. Please enable Summary mode to run this program');
133: RETCODE := G_WARNING;

Line 719: l_inv_ctp := NVL(FND_PROFILE.value('INV_CTP'), 5);

715:
716: -- For summary enhancement - initiallizing retcode with success
717: RETCODE := G_SUCCESS;
718:
719: l_inv_ctp := NVL(FND_PROFILE.value('INV_CTP'), 5);
720: msc_util.msc_log('LOAD_PLAN_SD: ' || 'inv_ctp := ' || l_inv_ctp);
721: IF l_inv_ctp <> 4 THEN
722: -- we are not doing PDS ATP so we wont continue
723: msc_util.msc_log('LOAD_PLAN_SD: ' || 'Not Doing PDS ATP. Please check profile - INV: Capable to Promise". Will Exit ');

Line 996: G_ALLOC_ATP := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');

992: msc_util.msc_log('LOAD_PLAN_SD: DRP Plan, Hence Post Plan Pegging not called');
993: msc_sch_wb.atp_debug('----- ATP4drp Specific Debug Messages -----');
994: END IF;
995: ELSE -- Carry out processing for non-DRP plan.
996: G_ALLOC_ATP := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');
997: G_CLASS_HRCHY := NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);
998: G_ALLOC_METHOD := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'), 2);
999:
1000: msc_util.msc_log('G_ALLOC_ATP := ' || G_ALLOC_ATP);

Line 997: G_CLASS_HRCHY := NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);

993: msc_sch_wb.atp_debug('----- ATP4drp Specific Debug Messages -----');
994: END IF;
995: ELSE -- Carry out processing for non-DRP plan.
996: G_ALLOC_ATP := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');
997: G_CLASS_HRCHY := NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);
998: G_ALLOC_METHOD := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'), 2);
999:
1000: msc_util.msc_log('G_ALLOC_ATP := ' || G_ALLOC_ATP);
1001: msc_util.msc_log('G_CLASS_HRCHY := ' || G_CLASS_HRCHY);

Line 998: G_ALLOC_METHOD := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'), 2);

994: END IF;
995: ELSE -- Carry out processing for non-DRP plan.
996: G_ALLOC_ATP := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');
997: G_CLASS_HRCHY := NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);
998: G_ALLOC_METHOD := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'), 2);
999:
1000: msc_util.msc_log('G_ALLOC_ATP := ' || G_ALLOC_ATP);
1001: msc_util.msc_log('G_CLASS_HRCHY := ' || G_CLASS_HRCHY);
1002: msc_util.msc_log('G_ALLOC_METHOD := ' || G_ALLOC_METHOD);

Line 1115: IF ((NVL(FND_PROFILE.value('MSC_ENABLE_ATP_SUMMARY'), 'N') = 'Y')

1111: -- ATP4drp End
1112:
1113: END IF;
1114:
1115: IF ((NVL(FND_PROFILE.value('MSC_ENABLE_ATP_SUMMARY'), 'N') = 'Y')
1116: AND (G_ALLOC_ATP = 'N' -- After summary ehancement summary will be
1117: OR (G_CLASS_HRCHY = 1 AND G_ALLOC_METHOD = 1) -- supported fot demand priority based
1118: ) -- allocated ATP
1119: ) THEN

Line 1122: share_partition := fnd_profile.value('MSC_SHARE_PARTITIONS');

1118: ) -- allocated ATP
1119: ) THEN
1120: msc_util.msc_log('begin Loading data for plan ' || l_plan_to_use);
1121:
1122: share_partition := fnd_profile.value('MSC_SHARE_PARTITIONS');
1123: msc_util.msc_log('share_partition := ' || share_partition);
1124:
1125: -- for summary enhancement - backlog workbench will be supported with summary
1126: /*

Line 1285: END IF; --IF NVL(FND_PROFILE.value('MSC_ENABLE_ATP_SUMMARY'), 'N') = 'Y' THEN

1281: where plan_id = l_plan_to_use;
1282: END IF;
1283: commit;
1284: END;
1285: END IF; --IF NVL(FND_PROFILE.value('MSC_ENABLE_ATP_SUMMARY'), 'N') = 'Y' THEN
1286:
1287: -- 24x7 Hooks
1288: if (l_24_plan > 0) then
1289: -- Bug 3478888 Reset ATP_SYNCHRONIZATION_FLAG only if ATP Post Plan Processing

Line 1361: l_inv_ctp := NVL(FND_PROFILE.value('INV_CTP'), 5);

1357: l_sysdate := sysdate;
1358:
1359: msc_util.msc_log ('Load_Net_Plan: ' || 'Plan ID : ' || p_plan_id);
1360:
1361: l_inv_ctp := NVL(FND_PROFILE.value('INV_CTP'), 5);
1362: msc_util.msc_log('Load_Net_Plan: ' || 'inv_ctp := ' || l_inv_ctp);
1363: IF l_inv_ctp <> 4 THEN
1364: -- we are not doing PDS ATP so we wont continue
1365: msc_util.msc_log('Load_Net_Plan: ' || 'Not Doing PDS ATP. Please check profile - INV: Capable to Promise". Will Exit ');

Line 1370: l_enable_summary_mode := NVL(FND_PROFILE.value('MSC_ENABLE_ATP_SUMMARY'), 'N');

1366: RETCODE := G_WARNING;
1367: RETURN;
1368: END IF;
1369:
1370: l_enable_summary_mode := NVL(FND_PROFILE.value('MSC_ENABLE_ATP_SUMMARY'), 'N');
1371: msc_util.msc_log('Load_Net_Plan: ' || 'l_enable_summary_mode := ' || l_enable_summary_mode);
1372: IF l_enable_summary_mode = 'N' THEN
1373: -- summary is not enabled so we wont continue
1374: msc_util.msc_log('Load_Net_Plan: ' || 'Not Doing Summary ATP. Please check profile - MSC: Enable ATP Summary Mode. Will Exit ');

Line 1427: G_ALLOC_ATP := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');

1423: msc_util.msc_log('G_CLASS_HRCHY := ' || G_CLASS_HRCHY);
1424: msc_util.msc_log('G_ALLOC_METHOD := ' || G_ALLOC_METHOD);
1425: END IF;
1426: ELSE -- ATP4drp Execute rest for only for non-DRP plans
1427: G_ALLOC_ATP := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');
1428: G_CLASS_HRCHY := NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);
1429: G_ALLOC_METHOD := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'), 2);
1430:
1431: msc_util.msc_log('G_ALLOC_ATP := ' || G_ALLOC_ATP);

Line 1428: G_CLASS_HRCHY := NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);

1424: msc_util.msc_log('G_ALLOC_METHOD := ' || G_ALLOC_METHOD);
1425: END IF;
1426: ELSE -- ATP4drp Execute rest for only for non-DRP plans
1427: G_ALLOC_ATP := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');
1428: G_CLASS_HRCHY := NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);
1429: G_ALLOC_METHOD := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'), 2);
1430:
1431: msc_util.msc_log('G_ALLOC_ATP := ' || G_ALLOC_ATP);
1432: msc_util.msc_log('G_CLASS_HRCHY := ' || G_CLASS_HRCHY);

Line 1429: G_ALLOC_METHOD := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'), 2);

1425: END IF;
1426: ELSE -- ATP4drp Execute rest for only for non-DRP plans
1427: G_ALLOC_ATP := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');
1428: G_CLASS_HRCHY := NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);
1429: G_ALLOC_METHOD := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'), 2);
1430:
1431: msc_util.msc_log('G_ALLOC_ATP := ' || G_ALLOC_ATP);
1432: msc_util.msc_log('G_CLASS_HRCHY := ' || G_CLASS_HRCHY);
1433: msc_util.msc_log('G_ALLOC_METHOD := ' || G_ALLOC_METHOD);

Line 1562: l_share_partition := fnd_profile.value('MSC_SHARE_PARTITIONS');

1558: where plan_id = p_plan_id;
1559: END;
1560:
1561: -- All stats should be gathered in one go as that also causes imlpicit commit - for summary enhancement
1562: l_share_partition := fnd_profile.value('MSC_SHARE_PARTITIONS');
1563: msc_util.msc_log('Load_Net_Plan: ' || 'l_share_partition := ' || l_share_partition);
1564: Gather_Summ_Plan_Stats(p_plan_id, l_share_partition);
1565:
1566: RETCODE := G_SUCCESS;

Line 1673: MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE := NVL(FND_PROFILE.VALUE('MSC_PO_DOCK_DATE_CALC_PREF'), 2);

1669: l_sysdate := sysdate;
1670: l_user_id := FND_GLOBAL.USER_ID;
1671:
1672: ---profile option for including purchase order
1673: MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE := NVL(FND_PROFILE.VALUE('MSC_PO_DOCK_DATE_CALC_PREF'), 2);
1674:
1675: IF p_full_refresh = 1 THEN -- Full refresh - for summary enhancement
1676:
1677: -- Data for share_partition='N' has already been deleted

Line 1753: l_MSO_Batch_flag := NVL(fnd_profile.value('MSO_BATCHABLE_FLAG'),'N');

1749: l_sysdate date;
1750: l_user_id number;
1751: BEGIN
1752:
1753: l_MSO_Batch_flag := NVL(fnd_profile.value('MSO_BATCHABLE_FLAG'),'N');
1754: msc_util.msc_log('LOAD_RESOURCES: ' || 'mso batchable flag := ' || l_MSO_Batch_flag );
1755: Begin
1756: SELECT decode(designator_type, 2, 1, 0),
1757: DECODE(plans.plan_type, 4, 2,

Line 2339: l_inv_ctp := NVL(FND_PROFILE.value('INV_CTP'), 5);

2335:
2336: l_instance_id := p_instance_id;
2337: l_sysdate := sysdate;
2338: l_user_id := FND_GLOBAL.USER_ID;
2339: l_inv_ctp := NVL(FND_PROFILE.value('INV_CTP'), 5);
2340: l_enable_summary_mode := NVL(FND_PROFILE.value('MSC_ENABLE_ATP_SUMMARY'), 'N');
2341:
2342: msc_util.msc_log('inv_ctp := ' || l_inv_ctp);
2343: msc_util.msc_log(' l_enable_summary_mode := ' || l_enable_summary_mode);

Line 2340: l_enable_summary_mode := NVL(FND_PROFILE.value('MSC_ENABLE_ATP_SUMMARY'), 'N');

2336: l_instance_id := p_instance_id;
2337: l_sysdate := sysdate;
2338: l_user_id := FND_GLOBAL.USER_ID;
2339: l_inv_ctp := NVL(FND_PROFILE.value('INV_CTP'), 5);
2340: l_enable_summary_mode := NVL(FND_PROFILE.value('MSC_ENABLE_ATP_SUMMARY'), 'N');
2341:
2342: msc_util.msc_log('inv_ctp := ' || l_inv_ctp);
2343: msc_util.msc_log(' l_enable_summary_mode := ' || l_enable_summary_mode);
2344:

Line 3214: l_inv_ctp := NVL(FND_PROFILE.value('INV_CTP'), 5);

3210: -- Deleted Related Code.
3211:
3212: ---- select org ids for the instance as we are going to do the summary per organization
3213:
3214: l_inv_ctp := NVL(FND_PROFILE.value('INV_CTP'), 5);
3215: l_sysdate := sysdate;
3216: l_user_id := FND_GLOBAL.USER_ID;
3217: l_enable_summary_mode := NVL(FND_PROFILE.value('MSC_ENABLE_ATP_SUMMARY'), 'N');
3218:

Line 3217: l_enable_summary_mode := NVL(FND_PROFILE.value('MSC_ENABLE_ATP_SUMMARY'), 'N');

3213:
3214: l_inv_ctp := NVL(FND_PROFILE.value('INV_CTP'), 5);
3215: l_sysdate := sysdate;
3216: l_user_id := FND_GLOBAL.USER_ID;
3217: l_enable_summary_mode := NVL(FND_PROFILE.value('MSC_ENABLE_ATP_SUMMARY'), 'N');
3218:
3219: msc_util.msc_log('inv_ctp := ' || l_inv_ctp);
3220: msc_util.msc_log('l_enable_summary_mode := ' || l_enable_summary_mode);
3221:

Line 3774: l_share_partition := fnd_profile.value('MSC_SHARE_PARTITIONS');

3770:
3771: END LOOP;
3772: END LOOP;
3773:
3774: l_share_partition := fnd_profile.value('MSC_SHARE_PARTITIONS');
3775: msc_util.msc_log('l_share_partition := ' || l_share_partition);
3776:
3777: IF l_share_partition = 'Y' then
3778: msc_util.msc_log('Share partition is on');

Line 4120: l_inv_ctp := FND_PROFILE.value('INV_CTP');

4116:
4117: BEGIN
4118: msc_util.msc_log('Begin procedure post_plan_allocation');
4119:
4120: l_inv_ctp := FND_PROFILE.value('INV_CTP');
4121: msc_util.msc_log('inv_ctp := ' || l_inv_ctp);
4122:
4123: IF l_inv_ctp <> 4 THEN
4124: -- we are not doing PDS ATP so we wont continue

Line 4130: l_alloc_atp := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');

4126: RETCODE := G_ERROR;
4127: RETURN;
4128: END IF;
4129:
4130: l_alloc_atp := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');
4131: msc_util.msc_log('l_alloc_atp := ' || l_alloc_atp);
4132:
4133: IF l_alloc_atp <> 'Y' THEN
4134: -- we are not doing Allocated ATP so we wont continue

Line 4140: l_class_hrchy := NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);

4136: RETCODE := G_ERROR;
4137: RETURN;
4138: END IF;
4139:
4140: l_class_hrchy := NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);
4141: msc_util.msc_log('l_class_hrchy := ' || l_class_hrchy);
4142:
4143: IF l_class_hrchy <> 1 THEN
4144: -- we are not doing Demand Class based AATP so we wont continue

Line 4150: l_alloc_method := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'), 2);

4146: RETCODE := G_ERROR;
4147: RETURN;
4148: END IF;
4149:
4150: l_alloc_method := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'), 2);
4151: msc_util.msc_log('l_alloc_method := ' || l_alloc_method);
4152:
4153: IF l_alloc_method <> 1 THEN
4154: -- we are not doing Demand Class based AATP using pegging from planning so we wont continue

Line 4161: l_excess_supply_by_dc := NVL(FND_PROFILE.VALUE('MSC_EXCESS_SUPPLY_BY_DC'), 'N');

4157: RETURN;
4158: END IF;
4159:
4160: -- rajjain project atp changes 07/24/2003 begin
4161: l_excess_supply_by_dc := NVL(FND_PROFILE.VALUE('MSC_EXCESS_SUPPLY_BY_DC'), 'N');
4162: msc_util.msc_log('l_excess_supply_by_dc := ' || l_excess_supply_by_dc);
4163:
4164: BEGIN
4165: msc_util.msc_log('Calling custom procedure MSC_ATP_CUSTOM.Custom_Pre_Allocation...');

Line 4178: l_share_partition := fnd_profile.value('MSC_SHARE_PARTITIONS');

4174:
4175: msc_util.msc_log('begin Loading pre-allocation demand/supply data for plan: ' || p_plan_id);
4176: RETCODE := G_SUCCESS;
4177:
4178: l_share_partition := fnd_profile.value('MSC_SHARE_PARTITIONS');
4179:
4180: msc_util.msc_log('l_share_partition := ' || l_share_partition);
4181:
4182: -- Bug 2516506 - select plan name also

Line 6301: l_inv_ctp := NVL(FND_PROFILE.value('INV_CTP'), 5);

6297: msc_util.msc_log('Summary Mode : ' || p_summary_mode);
6298:
6299: x_retcode := G_SUCCESS;
6300:
6301: l_inv_ctp := NVL(FND_PROFILE.value('INV_CTP'), 5);
6302:
6303: msc_util.msc_log('inv_ctp := ' || l_inv_ctp);
6304:
6305: /* time_phased_atp changes begin