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_CTO dependencies on MSC_ATP_PVT

Line 47: --IF MSC_ATP_PVT.G_INV_CTP = 4 then -- call matching API for both ODS and PDS

43: IF PG_DEBUG in ('Y', 'C') THEN
44: msc_sch_wb.atp_debug('***** After putting the data into temp table *****');
45: END IF;
46: ----now call CTO for matching and option dependent sourcing
47: --IF MSC_ATP_PVT.G_INV_CTP = 4 then -- call matching API for both ODS and PDS
48: IF NOT( MSC_ATP_PVT.G_CALLING_MODULE = 724) AND (nvl(p_atp_rec.attribute_02(1), -1) <> 3) THEN
49: IF PG_DEBUG in ('Y', 'C') THEN
50: msc_sch_wb.atp_debug('***** Call Matching *****');
51: END IF;

Line 48: IF NOT( MSC_ATP_PVT.G_CALLING_MODULE = 724) AND (nvl(p_atp_rec.attribute_02(1), -1) <> 3) THEN

44: msc_sch_wb.atp_debug('***** After putting the data into temp table *****');
45: END IF;
46: ----now call CTO for matching and option dependent sourcing
47: --IF MSC_ATP_PVT.G_INV_CTP = 4 then -- call matching API for both ODS and PDS
48: IF NOT( MSC_ATP_PVT.G_CALLING_MODULE = 724) AND (nvl(p_atp_rec.attribute_02(1), -1) <> 3) THEN
49: IF PG_DEBUG in ('Y', 'C') THEN
50: msc_sch_wb.atp_debug('***** Call Matching *****');
51: END IF;
52:

Line 64: l_error_code := MSC_ATP_PVT.ERROR_WHILE_MATCHING;

60: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
61: IF PG_DEBUG in ('Y', 'C') THEN
62: msc_sch_wb.atp_debug('***** Error Occured While Matching *****');
63: END IF;
64: l_error_code := MSC_ATP_PVT.ERROR_WHILE_MATCHING;
65: p_atp_rec.error_code(1) := MSC_ATP_PVT.ATP_PROCESSING_ERROR;
66: RAISE FND_API.G_EXC_ERROR ;
67:
68: END IF;

Line 65: p_atp_rec.error_code(1) := MSC_ATP_PVT.ATP_PROCESSING_ERROR;

61: IF PG_DEBUG in ('Y', 'C') THEN
62: msc_sch_wb.atp_debug('***** Error Occured While Matching *****');
63: END IF;
64: l_error_code := MSC_ATP_PVT.ERROR_WHILE_MATCHING;
65: p_atp_rec.error_code(1) := MSC_ATP_PVT.ATP_PROCESSING_ERROR;
66: RAISE FND_API.G_EXC_ERROR ;
67:
68: END IF;
69:

Line 115: IF (p_dblink is null and MSC_ATP_PVT.G_CALLING_MODULE <> 724) or MSC_ATP_PUB.G_ATP_CHECK = 'N' THEN

111: --- now we need to populte the data back into atp_rec_type if
112: --- 1. single database setup
113: --- 2. distributed setup and no items are atpable
114:
115: IF (p_dblink is null and MSC_ATP_PVT.G_CALLING_MODULE <> 724) or MSC_ATP_PUB.G_ATP_CHECK = 'N' THEN
116: IF PG_DEBUG in ('Y', 'C') THEN
117: msc_sch_wb.atp_debug('***** db link is null or no itmes are atpable, get the data');
118: END IF;
119:

Line 144: p_atp_rec.error_code(1) := MSC_ATP_PVT.ATP_PROCESSING_ERROR;

140: IF PG_DEBUG in ('Y', 'C') THEN
141: msc_sch_wb.atp_debug('***** Errror Occured in Check_Lines_For_CTO_ATP');
142: msc_sch_wb.atp_debug('Sql Error := ' || SQLERRM);
143: END IF;
144: p_atp_rec.error_code(1) := MSC_ATP_PVT.ATP_PROCESSING_ERROR;
145: x_return_status := FND_API.G_RET_STS_ERROR;
146:
147: END Check_Lines_For_CTO_ATP;
148:

Line 451: MSC_ATP_PVT.G_REFRESH_NUMBER,

447: l_user_id,
448: l_sysdate,
449: l_user_id,
450: l_sysdate,
451: MSC_ATP_PVT.G_REFRESH_NUMBER,
452: p_session_id);
453: --END LOOP;
454:
455: IF PG_DEBUG in ('Y', 'C') THEN

Line 526: msc_sch_wb.atp_debug('MSC_ATP_PVT.G_PTF_DATE := '|| MSC_ATP_PVT.G_PTF_DATE); --4137608

522: msc_sch_wb.atp_debug('Get_Mandatory_Components: p_plan_id := ' || p_plan_id);
523: msc_sch_wb.atp_debug('p_instance_id := ' || p_instance_id);
524: msc_sch_wb.atp_debug('p_quantity := '|| p_quantity);
525: msc_sch_wb.atp_debug('p_request_date := ' || p_request_date);
526: msc_sch_wb.atp_debug('MSC_ATP_PVT.G_PTF_DATE := '|| MSC_ATP_PVT.G_PTF_DATE); --4137608
527: --l_sysdate := trunc(sysdate); --4137608 --bug 8585385, remove this statement from the debug block
528: END IF;
529: l_sysdate := trunc(sysdate); --4137608, 8585385
530: ----first get the destination inventory_item_id

Line 568: ROUND ((decode (NVL (MSC_ATP_PVT.G_ORG_INFO_REC.org_type,1), MSC_ATP_PVT.DISCRETE_ORG, decode ( nvl(mbc.scaling_type, 1), 1, (MBC.USAGE_QUANTITY*p_quantity),

564: BEGIN
565: SELECT msi.sr_inventory_item_id,
566: --4570421
567: --round(mbc.usage_quantity * p_quantity, 6),
568: ROUND ((decode (NVL (MSC_ATP_PVT.G_ORG_INFO_REC.org_type,1), MSC_ATP_PVT.DISCRETE_ORG, decode ( nvl(mbc.scaling_type, 1), 1, (MBC.USAGE_QUANTITY*p_quantity),
569: 2, MBC.USAGE_QUANTITY),
570: MSC_ATP_PVT.OPM_ORG, decode (nvl (mbc.scaling_type, 1), 0, MBC.USAGE_QUANTITY,
571: 1, (MBC.USAGE_QUANTITY*p_quantity),
572: 2, MBC.USAGE_QUANTITY,

Line 570: MSC_ATP_PVT.OPM_ORG, decode (nvl (mbc.scaling_type, 1), 0, MBC.USAGE_QUANTITY,

566: --4570421
567: --round(mbc.usage_quantity * p_quantity, 6),
568: ROUND ((decode (NVL (MSC_ATP_PVT.G_ORG_INFO_REC.org_type,1), MSC_ATP_PVT.DISCRETE_ORG, decode ( nvl(mbc.scaling_type, 1), 1, (MBC.USAGE_QUANTITY*p_quantity),
569: 2, MBC.USAGE_QUANTITY),
570: MSC_ATP_PVT.OPM_ORG, decode (nvl (mbc.scaling_type, 1), 0, MBC.USAGE_QUANTITY,
571: 1, (MBC.USAGE_QUANTITY*p_quantity),
572: 2, MBC.USAGE_QUANTITY,
573: 3, (MBC.USAGE_QUANTITY*p_quantity),
574: 4, (MBC.USAGE_QUANTITY*p_quantity),

Line 593: NVL (MSC_ATP_PVT.G_ORG_INFO_REC.org_type,1) --4775920

589: mbc.scale_rounding_variance,
590: mbc.rounding_direction,
591: mbc.component_yield_factor, --4570421
592: MBC.USAGE_QUANTITY*mbc.component_yield_factor, --4775920
593: NVL (MSC_ATP_PVT.G_ORG_INFO_REC.org_type,1) --4775920
594: BULK COLLECT INTO
595: x_mand_comp_info_rec.sr_inventory_item_id,
596: x_mand_comp_info_rec.quantity,
597: x_mand_comp_info_rec.atp_flag,

Line 634: AND TRUNC(NVL(MBC.DISABLE_DATE, GREATEST(p_request_date, l_sysdate, MSC_ATP_PVT.G_PTF_DATE)+1)) >=

630: AND (msi.atp_flag <> 'N' or msi.atp_components_flag <> 'N')
631: --4137608
632: -- effective date should be greater than or equal to greatest of PTF date, sysdate and request date
633: -- disable date should be less than or equal to greatest of PTF date, sysdate and request date
634: AND TRUNC(NVL(MBC.DISABLE_DATE, GREATEST(p_request_date, l_sysdate, MSC_ATP_PVT.G_PTF_DATE)+1)) >=
635: TRUNC(GREATEST(p_request_date, l_sysdate, MSC_ATP_PVT.G_PTF_DATE))
636: AND TRUNC(MBC.EFFECTIVITY_DATE) <=
637: TRUNC(GREATEST(p_request_date, l_sysdate, MSC_ATP_PVT.G_PTF_DATE));
638: --4137608

Line 635: TRUNC(GREATEST(p_request_date, l_sysdate, MSC_ATP_PVT.G_PTF_DATE))

631: --4137608
632: -- effective date should be greater than or equal to greatest of PTF date, sysdate and request date
633: -- disable date should be less than or equal to greatest of PTF date, sysdate and request date
634: AND TRUNC(NVL(MBC.DISABLE_DATE, GREATEST(p_request_date, l_sysdate, MSC_ATP_PVT.G_PTF_DATE)+1)) >=
635: TRUNC(GREATEST(p_request_date, l_sysdate, MSC_ATP_PVT.G_PTF_DATE))
636: AND TRUNC(MBC.EFFECTIVITY_DATE) <=
637: TRUNC(GREATEST(p_request_date, l_sysdate, MSC_ATP_PVT.G_PTF_DATE));
638: --4137608
639: /*AND trunc(mbc.effectivity_date) <= trunc(p_request_date)

Line 637: TRUNC(GREATEST(p_request_date, l_sysdate, MSC_ATP_PVT.G_PTF_DATE));

633: -- disable date should be less than or equal to greatest of PTF date, sysdate and request date
634: AND TRUNC(NVL(MBC.DISABLE_DATE, GREATEST(p_request_date, l_sysdate, MSC_ATP_PVT.G_PTF_DATE)+1)) >=
635: TRUNC(GREATEST(p_request_date, l_sysdate, MSC_ATP_PVT.G_PTF_DATE))
636: AND TRUNC(MBC.EFFECTIVITY_DATE) <=
637: TRUNC(GREATEST(p_request_date, l_sysdate, MSC_ATP_PVT.G_PTF_DATE));
638: --4137608
639: /*AND trunc(mbc.effectivity_date) <= trunc(p_request_date)
640: AND nvl(trunc(mbc.disable_date), trunc(p_request_date))
641: >= trunc(p_request_date);*/

Line 883: x_return_status := MSC_ATP_PVT.CTO_OSS_ERROR;

879: msc_sch_wb.atp_debug('Ship set, but no common OSS sources');
880: END IF;
881: --null out output table
882: P_SOURCE_LIST := l_match_source_list;
883: x_return_status := MSC_ATP_PVT.CTO_OSS_ERROR;
884:
885: ELSIF l_cto_source_list.organization_id.count > 0 THEN
886: FOR l_parent_src_cntr in 1..p_source_list.organization_id.count LOOP
887: IF PG_DEBUG in ('Y', 'C') THEN

Line 905: IF p_source_list.Source_Type(l_parent_src_cntr) = MSC_ATP_PVT.MAKE AND

901: p_source_list.supplier_site_id(l_parent_src_cntr) =
902: l_cto_source_list.supplier_site_id(l_cto_source_cntr))) AND
903: p_source_list.instance_id(l_parent_src_cntr) = p_instance_id THEN
904:
905: IF p_source_list.Source_Type(l_parent_src_cntr) = MSC_ATP_PVT.MAKE AND
906: NVL(l_cto_source_list.make_flag(l_cto_source_cntr), 'Y') = 'N' THEN
907:
908: IF PG_DEBUG in ('Y', 'C') THEN
909: msc_sch_wb.atp_debug('Source Type := ' || p_source_list.Source_Type(l_parent_src_cntr));

Line 960: x_return_status := MSC_ATP_PVT.CTO_OSS_ERROR;

956: || P_SOURCE_LIST.organization_id.count);
957: END IF;
958: IF l_match_source_list.organization_id.count = 0 THEN
959:
960: x_return_status := MSC_ATP_PVT.CTO_OSS_ERROR;
961: END IF;
962:
963: END IF; -- IF l_cto_source_list.organization_id.count >
964:

Line 1029: MSC_ATP_PVT.G_INSTANCE_ID,

1025: mast.session_id,
1026: mast.BOM_ITEM_TYPE,
1027: mast.QUANTITY_ORDERED,
1028: mast.parent_line_id,
1029: MSC_ATP_PVT.G_INSTANCE_ID,
1030: p_refresh_number
1031: FROM mrp_atp_schedule_temp mast,
1032: msc_item_id_lid mil
1033: where session_id = p_session_id

Line 1143: l_mso_lead_time_factor := MSC_ATP_PVT.G_MSO_LEAD_TIME_FACTOR;

1139: l_op_seq_id, --4570421
1140: l_return_status);
1141:
1142:
1143: l_mso_lead_time_factor := MSC_ATP_PVT.G_MSO_LEAD_TIME_FACTOR;
1144:
1145: l_lead_time := CEIL((NVL(p_fixed_lt,0) + NVL(p_variable_lt, 0)* p_request_quantity)*
1146: (1 + l_mso_lead_time_factor));
1147:

Line 1150: msc_sch_wb.atp_debug('Get_CTO_BOM: G_INSTANCE_ID := ' || MSC_ATP_PVT.G_INSTANCE_ID);

1146: (1 + l_mso_lead_time_factor));
1147:
1148: IF PG_DEBUG in ('Y', 'C') THEN
1149: msc_sch_wb.atp_debug('Get_CTO_BOM: l_lead_time := ' || l_lead_time);
1150: msc_sch_wb.atp_debug('Get_CTO_BOM: G_INSTANCE_ID := ' || MSC_ATP_PVT.G_INSTANCE_ID);
1151: END IF;
1152:
1153: SELECT mcb.sr_INVENTORY_ITEM_ID,
1154: (mcb.quantity / p_parent_so_quantity) * p_request_quantity ,

Line 1175: NVL (MSC_ATP_PVT.G_ORG_INFO_REC.org_type,1) --4775920

1171: msi.aggregate_time_fence_date, -- For time_phased_atp
1172: msi.inventory_item_id,
1173: msi.uom_code, --bug3110023
1174: mbc.usage_quantity*mbc.component_yield_factor, --4775920
1175: NVL (MSC_ATP_PVT.G_ORG_INFO_REC.org_type,1) --4775920
1176: BULK COLLECT INTO
1177: p_comp_rec.inventory_item_id,
1178: p_comp_rec.comp_usage,
1179: p_comp_rec.requested_date,

Line 1208: AND mcb.sr_instance_id = MSC_ATP_PVT.G_INSTANCE_ID -- this is the instance id of the calling module

1204: msc_system_items msi,
1205: msc_bom_components mbc,
1206: MSC_OPERATION_COMPONENTS MOC
1207: WHERE mcb.session_id = p_session_id
1208: AND mcb.sr_instance_id = MSC_ATP_PVT.G_INSTANCE_ID -- this is the instance id of the calling module
1209: AND mcb.PARENT_LINE_ID = p_line_id
1210: AND mcb.sr_inventory_item_id = msi.sr_inventory_item_id (+)
1211: AND p_organization_id = msi.organization_id (+)
1212: AND p_instance_id = msi.sr_instance_id (+)