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

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

21:
22: -- This is the main procedure called for Scheduling
23: -- Change name to Schedule
24:
25: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');
26:
27: -- dsting
28: -- For multilevel models, the override flag for the input record is reset to null
29: -- after the first level.

Line 321: MSC_ATP_PVT.G_RES_CONSUME := NVL(FND_PROFILE.value('MSC_ATP_RES_CONSUME'), 'Y');

317: MSC_ATP_PVT.G_ATP_ITEM_PRESENT_IN_SET := 'N';
318: -- initialize API return status to success
319: x_return_status := FND_API.G_RET_STS_SUCCESS;
320:
321: MSC_ATP_PVT.G_RES_CONSUME := NVL(FND_PROFILE.value('MSC_ATP_RES_CONSUME'), 'Y');
322: IF PG_DEBUG in ('Y', 'C') THEN
323: msc_sch_wb.atp_debug('Schedule: ' || 'G_RES_CONSUME = '||MSC_ATP_PVT.G_RES_CONSUME);
324: END IF;
325:

Line 455: lv_assign_set_id := FND_PROFILE.value('MSC_ATP_ASSIGN_SET');

451: -- This is done to support region level sourcing as
452: -- only assignment set on APS can be used.
453:
454: -- lv_assign_set_id := NULL; -- User new local variable
455: lv_assign_set_id := FND_PROFILE.value('MSC_ATP_ASSIGN_SET');
456: END IF;
457:
458: IF PG_DEBUG in ('Y', 'C') THEN
459: msc_sch_wb.atp_debug('Schedule: ' || 'after converting the assign set id');

Line 728: -- l_complete_scatp := NVL(FND_PROFILE.value('MRP_COMPLETE_SCATP'), 'N');

724: msc_sch_wb.atp_debug('Schedule: Stmt = '||l_stmt);
725: END IF;
726:
727: -- cchen: disable complete scatp for now
728: -- l_complete_scatp := NVL(FND_PROFILE.value('MRP_COMPLETE_SCATP'), 'N');
729: -- l_complete_scatp := 'Y';
730: -- msc_sch_wb.atp_debug('l_complete_scatp = '||l_complete_scatp);
731:
732: -- we may need to loop through every supply source until we succeed

Line 1351: MSC_ATP_PVT.G_SUMMARY_FLAG := NVL(FND_PROFILE.VALUE('MSC_ENABLE_ATP_SUMMARY'), 'N');

1347: END IF;
1348: MSC_ATP_PVT.G_SUMMARY_FLAG := 'N';
1349: ELSIF MSC_ATP_PVT.G_INV_CTP = 4 THEN
1350: --- we re-read this summary profile option because it might get changed with plan
1351: MSC_ATP_PVT.G_SUMMARY_FLAG := NVL(FND_PROFILE.VALUE('MSC_ENABLE_ATP_SUMMARY'), 'N');
1352: END IF;
1353: IF PG_DEBUG in ('Y', 'C') THEN
1354: msc_sch_wb.atp_debug('Schedule: ' || 'MSC_ATP_PVT.G_SUMMARY_FLAG := ' || MSC_ATP_PVT.G_SUMMARY_FLAG);
1355: END IF;

Line 2350: --L_MOVE_PAST_DUE_TO_SYSDATE := NVL(FND_PROFILE.value('MSC_MOVE_PAST_DUE_TO_SYSDATE'), 'Y'); -- Bug 5584634/5618929

2346: RAISE FND_API.G_EXC_ERROR;
2347: END IF;
2348:
2349: --bug 3322846: Move past due ship date to the first working day after sysdate
2350: --L_MOVE_PAST_DUE_TO_SYSDATE := NVL(FND_PROFILE.value('MSC_MOVE_PAST_DUE_TO_SYSDATE'), 'Y'); -- Bug 5584634/5618929
2351: L_MOVE_PAST_DUE_TO_SYSDATE := MSC_ATP_PVT.G_MOV_PAST_DUE_SYSDATE_PROF;--6316476
2352: IF PG_DEBUG in ('Y', 'C') THEN
2353: msc_sch_wb.atp_debug('Schedule: ' || 'MOVE_PAST_DUE_TO_SYS_DATE :'|| L_MOVE_PAST_DUE_TO_SYSDATE);
2354: END IF;

Line 3524: --L_MOVE_PAST_DUE_TO_SYSDATE := NVL(FND_PROFILE.value('MSC_MOVE_PAST_DUE_TO_SYSDATE'), 'Y'); -- Bug 5584634/5618929

3520: msc_sch_wb.atp_debug('ship_date: ' || l_atp_table.ship_date(i));
3521: msc_sch_wb.atp_debug('arrival_date: ' || l_atp_table.arrival_date(i));
3522: END IF;
3523: --bug3439591 start
3524: --L_MOVE_PAST_DUE_TO_SYSDATE := NVL(FND_PROFILE.value('MSC_MOVE_PAST_DUE_TO_SYSDATE'), 'Y'); -- Bug 5584634/5618929
3525: L_MOVE_PAST_DUE_TO_SYSDATE := MSC_ATP_PVT.G_MOV_PAST_DUE_SYSDATE_PROF;--6316476
3526: IF PG_DEBUG in ('Y', 'C') THEN
3527: msc_sch_wb.atp_debug('Schedule: ' || 'MOVE_PAST_DUE_TO_SYS_DATE :'|| L_MOVE_PAST_DUE_TO_SYSDATE);
3528: END IF;

Line 6853: l_enforce_model_lt := NVL(FND_PROFILE.VALUE('MSC_ENFORCE_MODEL_LT'), 'Y');

6849: msc_sch_wb.atp_debug('ATP_Check: ' || 'MSC_ATP_PVT.G_PTF_DATE := ' || MSC_ATP_PVT.G_PTF_DATE);
6850: END IF;
6851:
6852: --s_cto_rearch: bug 3169831 : Honor lead time only when profile option is turned on
6853: l_enforce_model_lt := NVL(FND_PROFILE.VALUE('MSC_ENFORCE_MODEL_LT'), 'Y');
6854:
6855: IF PG_DEBUG in ('Y', 'C') THEN
6856: msc_sch_wb.atp_debug('l_enforce_model_lt := ' || l_enforce_model_lt);
6857: END IF;

Line 14093: l_coproducts_flag := FND_Profile.value('MSC_PLAN_COPRODUCTS');

14089: IF PG_DEBUG in ('Y', 'C') THEN
14090: msc_sch_wb.atp_debug('ATP_Check: ' || 'OSFM Coproducts Backward');
14091: END IF;
14092: --- OSFM Changes: update coproduct supply
14093: l_coproducts_flag := FND_Profile.value('MSC_PLAN_COPRODUCTS');
14094: IF PG_DEBUG in ('Y', 'C') THEN
14095: msc_sch_wb.atp_debug('ATP_Check: ' || 'msc_plan_coproducts = ' || l_coproducts_flag);
14096: END IF;
14097: --- set the sumary flag back to summary flag for p_plan_id

Line 14650: l_coproducts_flag := FND_Profile.value('MSC_PLAN_COPRODUCTS');

14646: END IF;
14647: --- reset the sumamry flag back to summary flag corresponding to p_plan_id
14648: MSC_ATP_PVT.G_SUMMARY_FLAG := l_summary_flag;
14649: --- OSFM Changes: update coproduct supply
14650: l_coproducts_flag := FND_Profile.value('MSC_PLAN_COPRODUCTS');
14651: IF PG_DEBUG in ('Y', 'C') THEN
14652: msc_sch_wb.atp_debug('ATP_Check: ' || 'msc_plan_coproducts = ' || l_coproducts_flag);
14653: END IF;
14654: IF ((l_atp_comp_flag = 'C') OR

Line 16338: G_INV_CTP := FND_PROFILE.value('INV_CTP') ;

16334: msc_sch_wb.atp_debug('***** Begin Call_Schedule Procedure *****');
16335: END IF;
16336:
16337: -- Initialize global variables to work in a connection pooling env
16338: G_INV_CTP := FND_PROFILE.value('INV_CTP') ;
16339: G_SUB_COMP := NVL(FND_PROFILE.value('MRP_ATP_SUB_COMP'), 'N');
16340: G_ALLOCATED_ATP := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');
16341: G_HIERARCHY_PROFILE:= NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);
16342: G_INF_SUP_TF_PAD := GREATEST(CEIL(NVL(FND_PROFILE.VALUE('MSC_ATP_INFINITE_TF_PAD'),0)),0);

Line 16339: G_SUB_COMP := NVL(FND_PROFILE.value('MRP_ATP_SUB_COMP'), 'N');

16335: END IF;
16336:
16337: -- Initialize global variables to work in a connection pooling env
16338: G_INV_CTP := FND_PROFILE.value('INV_CTP') ;
16339: G_SUB_COMP := NVL(FND_PROFILE.value('MRP_ATP_SUB_COMP'), 'N');
16340: G_ALLOCATED_ATP := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');
16341: G_HIERARCHY_PROFILE:= NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);
16342: G_INF_SUP_TF_PAD := GREATEST(CEIL(NVL(FND_PROFILE.VALUE('MSC_ATP_INFINITE_TF_PAD'),0)),0);
16343:

Line 16340: G_ALLOCATED_ATP := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');

16336:
16337: -- Initialize global variables to work in a connection pooling env
16338: G_INV_CTP := FND_PROFILE.value('INV_CTP') ;
16339: G_SUB_COMP := NVL(FND_PROFILE.value('MRP_ATP_SUB_COMP'), 'N');
16340: G_ALLOCATED_ATP := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');
16341: G_HIERARCHY_PROFILE:= NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);
16342: G_INF_SUP_TF_PAD := GREATEST(CEIL(NVL(FND_PROFILE.VALUE('MSC_ATP_INFINITE_TF_PAD'),0)),0);
16343:
16344: --bug 3625348: reset global variable

Line 16341: G_HIERARCHY_PROFILE:= NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);

16337: -- Initialize global variables to work in a connection pooling env
16338: G_INV_CTP := FND_PROFILE.value('INV_CTP') ;
16339: G_SUB_COMP := NVL(FND_PROFILE.value('MRP_ATP_SUB_COMP'), 'N');
16340: G_ALLOCATED_ATP := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');
16341: G_HIERARCHY_PROFILE:= NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);
16342: G_INF_SUP_TF_PAD := GREATEST(CEIL(NVL(FND_PROFILE.VALUE('MSC_ATP_INFINITE_TF_PAD'),0)),0);
16343:
16344: --bug 3625348: reset global variable
16345: MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED := 2;

Line 16342: G_INF_SUP_TF_PAD := GREATEST(CEIL(NVL(FND_PROFILE.VALUE('MSC_ATP_INFINITE_TF_PAD'),0)),0);

16338: G_INV_CTP := FND_PROFILE.value('INV_CTP') ;
16339: G_SUB_COMP := NVL(FND_PROFILE.value('MRP_ATP_SUB_COMP'), 'N');
16340: G_ALLOCATED_ATP := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');
16341: G_HIERARCHY_PROFILE:= NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);
16342: G_INF_SUP_TF_PAD := GREATEST(CEIL(NVL(FND_PROFILE.VALUE('MSC_ATP_INFINITE_TF_PAD'),0)),0);
16343:
16344: --bug 3625348: reset global variable
16345: MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED := 2;
16346: MSC_ATP_CTO.G_MODEL_IS_PRESENT := 2;

Line 16422: MSC_ATP_PVT.G_ALLOCATION_METHOD := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'), 2);

16418: --alloc_pp
16419: IF MSC_ATP_PVT.G_INV_CTP = 4 AND MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y' AND
16420: MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1 THEN
16421:
16422: MSC_ATP_PVT.G_ALLOCATION_METHOD := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'), 2);
16423: IF PG_DEBUG in ('Y', 'C') THEN
16424: msc_sch_wb.atp_debug('Call_Schedule: ' || 'G_ALLOCATION_METHOD := ' || MSC_ATP_PVT.G_ALLOCATION_METHOD);
16425: END IF;
16426: END IF;

Line 16828: l_consume_so_profile_value := NVL(FND_PROFILE.VALUE('MSC_ATP_CHECK_INT_SALES_ORDERS'), NVL(FND_PROFILE.VALUE('MSC_CONSUME_INT_SALES_ORDERS'), NO)); --5564082

16824: msc_sch_wb.atp_debug('Call_Schedule: ' || 'OE Flag (Before ISO check) : '||l_atp_input_table.OE_flag(m));
16825: END IF;
16826: --Bug 4279623 4333596
16827: IF l_atp_input_table.oe_flag(m) = 'Y' and MSC_ATP_PVT.G_INV_CTP = 4 THEN
16828: l_consume_so_profile_value := NVL(FND_PROFILE.VALUE('MSC_ATP_CHECK_INT_SALES_ORDERS'), NVL(FND_PROFILE.VALUE('MSC_CONSUME_INT_SALES_ORDERS'), NO)); --5564082
16829: --l_consume_so_profile_value := NVL(FND_PROFILE.VALUE('MSC_CONSUME_INT_SALES_ORDERS'), NO);
16830: IF PG_DEBUG in ('Y', 'C') THEN
16831: msc_sch_wb.atp_debug('Before get_plan_info_call:l_consume_so_profile_value ' || l_consume_so_profile_value);
16832: msc_sch_wb.atp_debug('Before get_plan_info_call:MSC_CONSUME_INT_SALES_ORDERS ' || l_consume_so_profile_value);

Line 16829: --l_consume_so_profile_value := NVL(FND_PROFILE.VALUE('MSC_CONSUME_INT_SALES_ORDERS'), NO);

16825: END IF;
16826: --Bug 4279623 4333596
16827: IF l_atp_input_table.oe_flag(m) = 'Y' and MSC_ATP_PVT.G_INV_CTP = 4 THEN
16828: l_consume_so_profile_value := NVL(FND_PROFILE.VALUE('MSC_ATP_CHECK_INT_SALES_ORDERS'), NVL(FND_PROFILE.VALUE('MSC_CONSUME_INT_SALES_ORDERS'), NO)); --5564082
16829: --l_consume_so_profile_value := NVL(FND_PROFILE.VALUE('MSC_CONSUME_INT_SALES_ORDERS'), NO);
16830: IF PG_DEBUG in ('Y', 'C') THEN
16831: msc_sch_wb.atp_debug('Before get_plan_info_call:l_consume_so_profile_value ' || l_consume_so_profile_value);
16832: msc_sch_wb.atp_debug('Before get_plan_info_call:MSC_CONSUME_INT_SALES_ORDERS ' || l_consume_so_profile_value);
16833: msc_sch_wb.atp_debug('New profile: '||FND_PROFILE.VALUE('MSC_ATP_CHECK_INT_SALES_ORDERS')); --5564082

Line 16833: msc_sch_wb.atp_debug('New profile: '||FND_PROFILE.VALUE('MSC_ATP_CHECK_INT_SALES_ORDERS')); --5564082

16829: --l_consume_so_profile_value := NVL(FND_PROFILE.VALUE('MSC_CONSUME_INT_SALES_ORDERS'), NO);
16830: IF PG_DEBUG in ('Y', 'C') THEN
16831: msc_sch_wb.atp_debug('Before get_plan_info_call:l_consume_so_profile_value ' || l_consume_so_profile_value);
16832: msc_sch_wb.atp_debug('Before get_plan_info_call:MSC_CONSUME_INT_SALES_ORDERS ' || l_consume_so_profile_value);
16833: msc_sch_wb.atp_debug('New profile: '||FND_PROFILE.VALUE('MSC_ATP_CHECK_INT_SALES_ORDERS')); --5564082
16834: END IF;
16835: IF l_consume_so_profile_value = CHECK_ORG_IN_PLAN THEN
16836: MSC_ATP_PROC.get_plan_info(p_instance_id,
16837: l_atp_input_table.inventory_item_id(m),

Line 16917: END IF; -- nvl(fnd_profile.value('msc_consume_int_sales_orders'), '2') = 3

16913: IF PG_DEBUG in ('Y', 'C') THEN
16914: msc_sch_wb.atp_debug('Profile value is set to CHECK ATP. We need to do ATP always.');
16915: END IF;
16916:
16917: END IF; -- nvl(fnd_profile.value('msc_consume_int_sales_orders'), '2') = 3
16918: END IF; -- l_atp_input_table.oe_flag(1) = 'y' and msc_atp_pvt.g_inv_ctp = 4
16919: --Bug 4279623 4333596
16920: msc_sch_wb.atp_debug('l_atp_input_table.oe_flag(m) = '||l_atp_input_table.oe_flag(m)); --5564082
16921: IF l_atp_input_table.OE_flag(m) = 'Y' AND MSC_ATP_PVT.G_INV_CTP = 4 THEN

Line 17729: NVL(fnd_profile.value('MSC_ALLOCATED_ATP_WORKFLOW'), 'N'));

17725:
17726: /* rajjain 02/27/2003 Bug 2824700 Begin
17727: * Restructured Exception/WF Notification code */
17728: l_wf_profile := NVL(G_ATP_WORKFLOW,
17729: NVL(fnd_profile.value('MSC_ALLOCATED_ATP_WORKFLOW'), 'N'));
17730: IF PG_DEBUG in ('Y', 'C') THEN
17731: msc_sch_wb.atp_debug('Call_Schedule: ' || 'WF Profile:' || l_wf_profile);
17732: END IF;
17733:

Line 18108: FND_PROFILE.put('MSC_ATP_DEBUG', p_atp_debug_flag);

18104:
18105: x_return_status := FND_API.G_RET_STS_SUCCESS;
18106: --bug3940999 setting debug mode explicitly so the messages can be printed
18107: IF p_atp_debug_flag IS NOT NULL THEN
18108: FND_PROFILE.put('MSC_ATP_DEBUG', p_atp_debug_flag);
18109: PG_DEBUG := p_atp_debug_flag;
18110: END IF;
18111: IF PG_DEBUG in ('Y', 'C') THEN
18112: --ATP Debug Workflow

Line 18220: FND_PROFILE.put(l_profile_name(j) , NVL(l_profile_value(j), 2 ));

18216:
18217: IF l_profile_name(j) = 'MSC_ALLOCATION_METHOD' THEN
18218:
18219: MSC_ATP_PVT.G_ALLOCATION_METHOD := NVL(l_profile_value(j), 2 );
18220: FND_PROFILE.put(l_profile_name(j) , NVL(l_profile_value(j), 2 ));
18221:
18222: ELSIF l_profile_name(j) = 'MSC_ALLOCATED_ATP' THEN
18223:
18224: MSC_ATP_PVT.G_ALLOCATED_ATP := NVL(l_profile_value(j), 'N');

Line 18225: FND_PROFILE.put(l_profile_name(j) , NVL(l_profile_value(j), 'N'));

18221:
18222: ELSIF l_profile_name(j) = 'MSC_ALLOCATED_ATP' THEN
18223:
18224: MSC_ATP_PVT.G_ALLOCATED_ATP := NVL(l_profile_value(j), 'N');
18225: FND_PROFILE.put(l_profile_name(j) , NVL(l_profile_value(j), 'N'));
18226:
18227: ELSIF l_profile_name(j) = 'MSC_CLASS_HIERARCHY' THEN
18228:
18229: MSC_ATP_PVT.G_HIERARCHY_PROFILE := NVL(l_profile_value(j), 2 );

Line 18230: FND_PROFILE.put(l_profile_name(j) , NVL(l_profile_value(j), 2 ));

18226:
18227: ELSIF l_profile_name(j) = 'MSC_CLASS_HIERARCHY' THEN
18228:
18229: MSC_ATP_PVT.G_HIERARCHY_PROFILE := NVL(l_profile_value(j), 2 );
18230: FND_PROFILE.put(l_profile_name(j) , NVL(l_profile_value(j), 2 ));
18231:
18232: ELSIF l_profile_name(j) = 'MSC_ALLOCATED_ATP_WORKFLOW' THEN
18233:
18234: G_ATP_WORKFLOW := l_profile_value(j);

Line 18235: FND_PROFILE.put(l_profile_name(j) , l_profile_value(j));

18231:
18232: ELSIF l_profile_name(j) = 'MSC_ALLOCATED_ATP_WORKFLOW' THEN
18233:
18234: G_ATP_WORKFLOW := l_profile_value(j);
18235: FND_PROFILE.put(l_profile_name(j) , l_profile_value(j));
18236:
18237: ELSIF l_profile_name(j) = 'INV_CTP' THEN
18238:
18239: MSC_ATP_PVT.G_INV_CTP_SOURCE := NVL(l_profile_value(j), 0 );

Line 18265: FND_PROFILE.put('MSC_ATP_DEBUG', p_atp_debug_flag);

18261: --bug3940999 end honor profile options passed from the source
18262:
18263: /* --bug3940999 set above
18264: IF p_atp_debug_flag IS NOT NULL THEN
18265: FND_PROFILE.put('MSC_ATP_DEBUG', p_atp_debug_flag);
18266: PG_DEBUG := p_atp_debug_flag;
18267: END IF;
18268:
18269: msc_sch_wb.set_session_id(p_session_id);

Line 18276: FND_PROFILE.put('MSC_ALLOCATED_ATP_WORKFLOW', p_atp_workflow);

18272: END IF;
18273:
18274: -- Fixed as part of Fix for Bug 3444096, need to set profile value as it is queried again in msc_wf_alloc_atp.start_mscatp_wf
18275: IF p_atp_workflow IS NOT NULL THEN
18276: FND_PROFILE.put('MSC_ALLOCATED_ATP_WORKFLOW', p_atp_workflow);
18277: G_ATP_WORKFLOW := p_atp_workflow;
18278: END IF;
18279:
18280: -- Bug 2387242 : krajan