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

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

2: /* $Header: MSCEATPB.pls 120.19 2011/08/30 06:53:33 aksaxena ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MSC_ATP_PUB';
4: NO_APS_INSTANCE CONSTANT INTEGER := 140;
5: PROF_TBL_NOT_IN_SYNC CONSTANT INTEGER := 170;
6: G_INV_CTP NUMBER := FND_PROFILE.value('INV_CTP');
7: G_CTO_FLAG NUMBER := 0;
8: G_CALL_ATP number :=2; --4421391, the flag will track whether debug/session is set or not.
9: --G_ATP_CHECK VARCHAR2(1) := 'N'; /* Bug 2249504 */
10: G_ATP_BOM_REC MRP_ATP_PUB.ATP_BOM_Rec_Typ;

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

18: -- easier, Call_ATP actually calls the Call_ATP_No_Commit and then do a commit
19:
20:
21:
22: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');
23:
24: PROCEDURE Check_CTO(
25: p_atp_rec IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
26: p_session_id IN NUMBER,

Line 376: --l_db_profile := FND_PROFILE.value('MRP_ATP_DATABASE_LINK');

372: i := -1;
373:
374: -- Bug 1822005, modified Call_ATP to close DB Link after ATP Transaction is
375: -- finished by commit or rollback.
376: --l_db_profile := FND_PROFILE.value('MRP_ATP_DATABASE_LINK');
377: IF l_a2m_dblink IS NOT NULL THEN --bug3049003 changed from G_DB_PROFILE to l_a2m_dblink
378: IF PG_DEBUG in ('Y', 'C') THEN
379: msc_sch_wb.atp_debug('Call_ATP_Commit: ' || 'after commit, before closing DB Link');
380: END IF;

Line 435: --l_db_profile := FND_PROFILE.value('MRP_ATP_DATABASE_LINK');

431: END IF;
432: -- Close the DB Link in case it is open
433: -- Bug 1822005, modified Call_ATP to close DB Link after ATP Transaction is
434: -- finished by commit or rollback.
435: --l_db_profile := FND_PROFILE.value('MRP_ATP_DATABASE_LINK');
436: IF l_a2m_dblink IS NOT NULL THEN --bug3049003 changed from G_DB_PROFILE to l_a2m_dblink
437:
438: cursor_name := dbms_sql.open_cursor;
439: DBMS_SQL.PARSE(cursor_name, 'alter session close database link ' ||l_a2m_dblink, --bug3049003 changed from G_DB_PROFILE to l_a2m_dblink

Line 534: NVL(FND_PROFILE.value('MSC_OM_IMPORT_PRESCHEDULED'), 'N') = 'Y' THEN

530:
531: -- Check if this is a demand modify from OM and profile option
532: -- is set to allow prescheduled order import without ATP, return ATP success.
533: IF NVL(p_atp_rec.Calling_Module(i), -99) = 660 AND
534: NVL(FND_PROFILE.value('MSC_OM_IMPORT_PRESCHEDULED'), 'N') = 'Y' THEN
535:
536: IF PG_DEBUG in ('Y', 'C') THEN
537: msc_sch_wb.atp_debug('Call_ATP: ' || 'Inside Prescheduled order import support for OM');
538: END IF;

Line 1077: l_assign_set_id := FND_PROFILE.value('MSC_ATP_ASSIGN_SET');

1073: NVL(p_atp_rec.attribute_03(i), -1) <> -1
1074: THEN
1075: l_assign_set_id := p_atp_rec.attribute_03(i);
1076: ELSE
1077: l_assign_set_id := FND_PROFILE.value('MSC_ATP_ASSIGN_SET');
1078: END IF;
1079:
1080: IF PG_DEBUG in ('Y', 'C') THEN
1081: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'l_assign_set_id = '||l_assign_set_id);

Line 1092: -- G_DB_PROFILE := FND_PROFILE.value('MRP_ATP_DATABASE_LINK'); bug3049003 changed from G_DB_PROFILE to l_a2m_dblink

1088: WHERE instance_id = l_instance_id;
1089: END IF;
1090:
1091: ELSE
1092: -- G_DB_PROFILE := FND_PROFILE.value('MRP_ATP_DATABASE_LINK'); bug3049003 changed from G_DB_PROFILE to l_a2m_dblink
1093: --l_db_profile := FND_PROFILE.value('MRP_ATP_DATABASE_LINK');
1094: -- this request is from the sourcce instance
1095: -- get the assignment set from profile in mrp
1096:

Line 1093: --l_db_profile := FND_PROFILE.value('MRP_ATP_DATABASE_LINK');

1089: END IF;
1090:
1091: ELSE
1092: -- G_DB_PROFILE := FND_PROFILE.value('MRP_ATP_DATABASE_LINK'); bug3049003 changed from G_DB_PROFILE to l_a2m_dblink
1093: --l_db_profile := FND_PROFILE.value('MRP_ATP_DATABASE_LINK');
1094: -- this request is from the sourcce instance
1095: -- get the assignment set from profile in mrp
1096:
1097: --diag_atp

Line 1105: l_assign_set_id := FND_PROFILE.value('MRP_ATP_ASSIGN_SET');

1101: NVL(p_atp_rec.attribute_03(i), -1) <> -1
1102: THEN
1103: l_assign_set_id := p_atp_rec.attribute_03(i);
1104: ELSE
1105: l_assign_set_id := FND_PROFILE.value('MRP_ATP_ASSIGN_SET');
1106: END IF;
1107:
1108: IF PG_DEBUG in ('Y', 'C') THEN
1109: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'l_assign_set_id = '||l_assign_set_id);

Line 1119: l_assign_set_id := FND_PROFILE.value('MRP_ATP_ASSIGN_SET');

1115: ELSE
1116: -- this request is from the sourcce instance
1117: -- get the assignment set from profile in mrp
1118:
1119: l_assign_set_id := FND_PROFILE.value('MRP_ATP_ASSIGN_SET');
1120:
1121: -- get instance id from mrp_ap_apps_instances.
1122: BEGIN
1123: SELECT instance_id

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

1904: ELSE
1905: x_atp_rec.requested_date_quantity(j) := x_atp_rec.quantity_ordered(j);
1906: END IF;
1907: */
1908: L_MOVE_PAST_DUE_TO_SYSDATE := NVL(FND_PROFILE.value('MSC_MOVE_PAST_DUE_TO_SYSDATE'), 'Y'); -- Bug 5584634/5618929
1909: IF PG_DEBUG in ('Y', 'C') THEN
1910: msc_sch_wb.atp_debug('Schedule: ' || 'MOVE_PAST_DUE_TO_SYS_DATE :'|| L_MOVE_PAST_DUE_TO_SYSDATE);
1911: END IF;
1912: if L_MOVE_PAST_DUE_TO_SYSDATE = 'Y' THEN -- Bug 5584634/5618929

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

1960: msc_sch_wb.atp_debug('l_past_due_ship_date := ' || l_past_due_ship_date); --bug4291375
1961: END IF;
1962: -- ship_rec_cal project changes end
1963: --s_cto_rearch: bug 3169831 : Honor lead time only when profile option is turned on
1964: l_enforce_model_lt := NVL(FND_PROFILE.VALUE('MSC_ENFORCE_MODEL_LT'), 'Y');
1965:
1966: IF PG_DEBUG in ('Y', 'C') THEN
1967: msc_sch_wb.atp_debug('l_enforce_model_lt := ' || l_enforce_model_lt);
1968: msc_sch_wb.atp_debug('atp lead time := ' || x_atp_rec.atp_lead_time(j));

Line 2463: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'MSC_ATP_DEBUG ' || FND_PROFILE.value('MSC_ATP_DEBUG'));

2459: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'l_instance_id ' || l_instance_id);
2460: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'l_assign_set_id ' || l_assign_set_id);
2461: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'l_refresh_number ' || l_refresh_number);
2462: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'l_def_assign_set_id ' || l_def_assign_set_id);
2463: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'MSC_ATP_DEBUG ' || FND_PROFILE.value('MSC_ATP_DEBUG'));
2464: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'l_node_id ' || l_node_id);
2465: END IF;
2466:
2467: EXECUTE IMMEDIATE plsql_block USING

Line 2473: FND_PROFILE.value('MSC_ATP_DEBUG'),

2469: l_instance_id,
2470: l_assign_set_id,
2471: l_refresh_number,
2472: l_def_assign_set_id,
2473: FND_PROFILE.value('MSC_ATP_DEBUG'),
2474: OUT l_session_loc_des, --ATP Debug Workflow --added OUT, 4727103
2475: OUT l_spid_des, --ATP Debug Workflow
2476: OUT l_trace_loc_des, --ATP Debug Workflow
2477: l_node_id; --Bug3593394

Line 2549: l_wf_profile := NVL(fnd_profile.value('MSC_ALLOCATED_ATP_WORKFLOW'), 'N');

2545:
2546: IF G_INV_CTP = 4 THEN
2547: --call substitution workflow
2548: IF x_atp_rec.action(1) <> 100 and x_atp_rec.calling_module(i) = 660 THEN
2549: l_wf_profile := NVL(fnd_profile.value('MSC_ALLOCATED_ATP_WORKFLOW'), 'N');
2550: IF PG_DEBUG in ('Y', 'C') THEN
2551: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'WF Profile:' || l_wf_profile);
2552: END IF;
2553: IF l_wf_profile = 'Y' THEN

Line 2591: IF NVL( FND_PROFILE.VALUE('MSC_ENABLE_ATP_SUMMARY'), 'N') = 'Y' THEN

2587: END IF;
2588: -- check if summary is enabled
2589: -- Bug 3762695: Use source side profile value for 'MSC: Enable ATP Summary mode'
2590: l_summary_flag := 'N';
2591: IF NVL( FND_PROFILE.VALUE('MSC_ENABLE_ATP_SUMMARY'), 'N') = 'Y' THEN
2592: BEGIN
2593: select summary_flag
2594: into l_summary_flag
2595: from mrp_atp_details_temp