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.

[Home] [Help]

APPS.MSC_ATP_REQ dependencies on FND_API

Line 3553: x_return_status := FND_API.G_RET_STS_SUCCESS;

3549: msc_sch_wb.atp_debug('Calculate_Atp_Dates_Qtys: ' || 'p_round_flag: '|| to_char(p_round_flag));
3550: END IF;
3551:
3552: -- initialize API return status to success
3553: x_return_status := FND_API.G_RET_STS_SUCCESS;
3554:
3555: -- if requested date is eariler than sysdate, we have an issue here.
3556: -- this is possible since we have the offset from requested arrival
3557: -- date. if requested date is eariler than sysdate, we should set

Line 3844: x_return_status := FND_API.G_RET_STS_ERROR;

3840: IF PG_DEBUG in ('Y', 'C') THEN
3841: msc_sch_wb.atp_debug('Calculate_Atp_Dates_Qtys: ' || 'Encountered error = ' || sqlerrm);
3842: msc_sch_wb.atp_debug('Calculate_Atp_Dates_Qtys: ' || 'Error Code = ' || sqlcode);
3843: END IF;
3844: x_return_status := FND_API.G_RET_STS_ERROR;
3845:
3846: END Calculate_Atp_Dates_Qtys;
3847:
3848: PROCEDURE Check_Substitutes(

Line 4278: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4274: l_return_status,
4275: p_plan_id --bug3510475
4276: );
4277:
4278: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4279: IF PG_DEBUG in ('Y', 'C') THEN
4280: msc_sch_wb.atp_debug('Check_Substitutes: ' || 'Error encountered in call to Get_PF_Plan_Info');
4281: END IF;
4282: END IF;

Line 4674: l_return_status := FND_API.G_RET_STS_ERROR;

4670: msc_sch_wb.atp_debug ('Check Substitutes : Plan Downtime encountered');
4671: END IF;
4672: MSC_ATP_PVT.G_DOWNTIME_HIT := 'Y';
4673: MSC_ATP_PVT.G_SUMMARY_FLAG := l_summary_flag;
4674: l_return_status := FND_API.G_RET_STS_ERROR;
4675: CLOSE substitute;
4676: RAISE MSC_ATP_PVT.EXC_NO_PLAN_FOUND;
4677:
4678: WHEN MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL THEN --bug3583705

Line 4683: l_return_status := FND_API.G_RET_STS_ERROR;

4679: IF PG_DEBUG in ('Y', 'C') THEN
4680: msc_sch_wb.atp_debug ('Check Substitutes : NO_MATCHING_DATE_IN_CAL');
4681: END IF;
4682: MSC_ATP_PVT.G_SUMMARY_FLAG := l_summary_flag;
4683: l_return_status := FND_API.G_RET_STS_ERROR;
4684: CLOSE substitute;
4685: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;
4686:
4687: WHEN OTHERS THEN

Line 4689: l_return_status := FND_API.G_RET_STS_ERROR;

4685: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;
4686:
4687: WHEN OTHERS THEN
4688: MSC_ATP_PVT.G_SUMMARY_FLAG := l_summary_flag;
4689: l_return_status := FND_API.G_RET_STS_ERROR;
4690: CLOSE substitute;
4691: return;
4692: END Check_Substitutes;
4693:

Line 4755: x_return_status := FND_API.G_RET_STS_SUCCESS;

4751: msc_sch_wb.atp_debug('**********Begin Get_Material_Atp_Info Procedure************');
4752: END IF;
4753:
4754: -- initialize API return status to success
4755: x_return_status := FND_API.G_RET_STS_SUCCESS;
4756:
4757: IF PG_DEBUG in ('Y', 'C') THEN
4758: msc_sch_wb.atp_debug('********** INPUT DATA:Get_Material_Atp_Info **********');
4759: msc_sch_wb.atp_debug('Get_Material_Atp_Info: ' || 'p_mat_atp_info_rec.inventory_item_id: '|| to_char(p_mat_atp_info_rec.inventory_item_id));

Line 4990: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4986: l_atp_period_tab,
4987: l_atp_qty_tab,
4988: l_return_status
4989: );
4990: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4991: IF PG_DEBUG in ('Y', 'C') THEN
4992: msc_sch_wb.atp_debug('Get_Material_Atp_Info: ' || 'Error occured in procedure Get_Mat_Avail_Pf');
4993: END IF;
4994: RAISE FND_API.G_EXC_ERROR;

Line 4994: RAISE FND_API.G_EXC_ERROR;

4990: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4991: IF PG_DEBUG in ('Y', 'C') THEN
4992: msc_sch_wb.atp_debug('Get_Material_Atp_Info: ' || 'Error occured in procedure Get_Mat_Avail_Pf');
4993: END IF;
4994: RAISE FND_API.G_EXC_ERROR;
4995: END IF;
4996: END IF;
4997:
4998: IF PG_DEBUG in ('Y', 'C') THEN

Line 5010: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5006: l_return_status,
5007: l_atp_period_tab,
5008: MSC_ATP_PF.Bw_Fw_Cum, --b/w, f/w consumption and accumulation
5009: p_mat_atp_info_rec.atf_date);
5010: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5011: IF PG_DEBUG in ('Y', 'C') THEN
5012: msc_sch_wb.atp_debug('Get_Material_Atp_Info: ' || 'Error occured in procedure Pf_Atp_Consume');
5013: END IF;
5014: RAISE FND_API.G_EXC_ERROR;

Line 5014: RAISE FND_API.G_EXC_ERROR;

5010: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5011: IF PG_DEBUG in ('Y', 'C') THEN
5012: msc_sch_wb.atp_debug('Get_Material_Atp_Info: ' || 'Error occured in procedure Pf_Atp_Consume');
5013: END IF;
5014: RAISE FND_API.G_EXC_ERROR;
5015: END IF;
5016: ELSE
5017: MSC_ATP_PROC.atp_consume(l_atp_qty_tab, l_atp_qty_tab.count);
5018: END IF;

Line 5025: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5021: END IF;
5022:
5023: /* Cum drop issue changes begin*/
5024: MSC_AATP_PROC.Atp_Remove_Negatives(l_atp_qty_tab, l_return_status);
5025: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5026: IF PG_DEBUG in ('Y', 'C') THEN
5027: msc_sch_wb.atp_debug('Get_Material_Atp_Info: ' || 'Error occured in procedure Atp_Remove_Negatives');
5028: END IF;
5029: RAISE FND_API.G_EXC_ERROR;

Line 5029: RAISE FND_API.G_EXC_ERROR;

5025: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5026: IF PG_DEBUG in ('Y', 'C') THEN
5027: msc_sch_wb.atp_debug('Get_Material_Atp_Info: ' || 'Error occured in procedure Atp_Remove_Negatives');
5028: END IF;
5029: RAISE FND_API.G_EXC_ERROR;
5030: END IF;
5031: /* Cum drop issue changes end*/
5032:
5033: IF l_infinite_time_fence_date IS NOT NULL THEN

Line 5210: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5206: p_mat_atp_info_rec.atp_date_quantity_this_level,
5207: x_return_status
5208: );
5209:
5210: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5211: x_return_status := FND_API.G_RET_STS_ERROR;
5212: return;
5213: END IF;
5214: END IF; --end if l_requested_date > l_infinite_time_fence_date

Line 5211: x_return_status := FND_API.G_RET_STS_ERROR;

5207: x_return_status
5208: );
5209:
5210: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5211: x_return_status := FND_API.G_RET_STS_ERROR;
5212: return;
5213: END IF;
5214: END IF; --end if l_requested_date > l_infinite_time_fence_date
5215: --- subst

Line 5263: -- x_return_status := FND_API.G_RET_STS_ERROR;

5259:
5260: EXCEPTION
5261:
5262: WHEN NO_DATA_FOUND THEN
5263: -- x_return_status := FND_API.G_RET_STS_ERROR;
5264: p_mat_atp_info_rec.requested_date_quantity := 0.0;
5265:
5266: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5267:

Line 5266: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5262: WHEN NO_DATA_FOUND THEN
5263: -- x_return_status := FND_API.G_RET_STS_ERROR;
5264: p_mat_atp_info_rec.requested_date_quantity := 0.0;
5265:
5266: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5267:
5268:
5269: --- Bug 1819638: This exception is added too handel error
5270: --- when no next_date corresponding to sys date is found in

Line 5301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5297: RAISE MSC_ATP_PVT.ALLOC_ATP_INVALID_PROFILE;
5298:
5299: WHEN OTHERS THEN
5300: temp := SQLCODE;
5301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5302: IF PG_DEBUG in ('Y', 'C') THEN
5303: msc_sch_wb.atp_debug('Get_Material_Atp_Info: ' || 'Get_Mater, sqlcode= '||temp);
5304: msc_sch_wb.atp_debug ('Get_Material_Atp_Info: IN Exception Block in others');
5305: msc_sch_wb.atp_debug ('error := ' || SQLERRM);

Line 5312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5308: /*IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5309: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Get_Material_Atp_Info');
5310: END IF;*/
5311:
5312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5313:
5314:
5315: END Get_Material_Atp_Info;
5316:

Line 5371: x_return_status := FND_API.G_RET_STS_SUCCESS;

5367: IF PG_DEBUG in ('Y', 'C') THEN
5368: msc_sch_wb.atp_debug('***** Begin Insert_Details Procedure *****');
5369: END IF;
5370:
5371: x_return_status := FND_API.G_RET_STS_SUCCESS;
5372:
5373: IF p_insert_flag >0 THEN
5374:
5375: /* time_phased_atp changes begin*/

Line 5492: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5488: p_scenario_id,
5489: p_identifier,
5490: l_return_status
5491: );
5492: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5493: IF PG_DEBUG in ('Y', 'C') THEN
5494: msc_sch_wb.atp_debug('Insert_Details: ' || 'Error occured in procedure Get_Mat_Avail_Pf_Dtls');
5495: END IF;
5496: RAISE FND_API.G_EXC_ERROR;

Line 5496: RAISE FND_API.G_EXC_ERROR;

5492: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5493: IF PG_DEBUG in ('Y', 'C') THEN
5494: msc_sch_wb.atp_debug('Insert_Details: ' || 'Error occured in procedure Get_Mat_Avail_Pf_Dtls');
5495: END IF;
5496: RAISE FND_API.G_EXC_ERROR;
5497: END IF;
5498: END IF;
5499:
5500: IF PG_DEBUG in ('Y', 'C') THEN

Line 5508: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5504:
5505: -- time_phased_atp
5506: IF l_time_phased_atp = 'Y' THEN
5507: MSC_ATP_PF.get_period_data_from_SD_temp(x_atp_period, l_return_status);
5508: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5509: IF PG_DEBUG in ('Y', 'C') THEN
5510: msc_sch_wb.atp_debug('Insert_Details: ' || 'Error occured in procedure Get_Period_Data_From_Sd_Temp');
5511: END IF;
5512: RAISE FND_API.G_EXC_ERROR;

Line 5512: RAISE FND_API.G_EXC_ERROR;

5508: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5509: IF PG_DEBUG in ('Y', 'C') THEN
5510: msc_sch_wb.atp_debug('Insert_Details: ' || 'Error occured in procedure Get_Period_Data_From_Sd_Temp');
5511: END IF;
5512: RAISE FND_API.G_EXC_ERROR;
5513: END IF;
5514: ELSE
5515: MSC_ATP_PROC.get_period_data_from_SD_temp(x_atp_period);
5516: END IF;

Line 5534: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5530: l_return_status,
5531: x_atp_period.Period_Start_Date,
5532: MSC_ATP_PF.Bw_Fw_Cum, --b/w, f/w consumption and accumulation
5533: p_atf_date);
5534: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5535: IF PG_DEBUG in ('Y', 'C') THEN
5536: msc_sch_wb.atp_debug('Insert_Details: ' || 'Error occured in procedure pf_atp_consume');
5537: END IF;
5538: RAISE FND_API.G_EXC_ERROR;

Line 5538: RAISE FND_API.G_EXC_ERROR;

5534: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5535: IF PG_DEBUG in ('Y', 'C') THEN
5536: msc_sch_wb.atp_debug('Insert_Details: ' || 'Error occured in procedure pf_atp_consume');
5537: END IF;
5538: RAISE FND_API.G_EXC_ERROR;
5539: END IF;
5540: -- time_phased_atp changes end
5541: ELSE
5542: MSC_ATP_PROC.atp_consume(x_atp_period.Cumulative_Quantity,

Line 5552: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5548: END IF;
5549:
5550: /* Cum drop issue changes begin*/
5551: MSC_AATP_PROC.Atp_Remove_Negatives(x_atp_period.Cumulative_Quantity, l_return_status);
5552: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5553: IF PG_DEBUG in ('Y', 'C') THEN
5554: msc_sch_wb.atp_debug('Get_Material_Atp_Info: ' || 'Error occured in procedure Atp_Remove_Negatives');
5555: END IF;
5556: RAISE FND_API.G_EXC_ERROR;

Line 5556: RAISE FND_API.G_EXC_ERROR;

5552: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5553: IF PG_DEBUG in ('Y', 'C') THEN
5554: msc_sch_wb.atp_debug('Get_Material_Atp_Info: ' || 'Error occured in procedure Atp_Remove_Negatives');
5555: END IF;
5556: RAISE FND_API.G_EXC_ERROR;
5557: END IF;
5558: /* Cum drop issue changes end*/
5559:
5560: IF l_infinite_time_fence_date IS NOT NULL THEN

Line 5735: x_return_status := FND_API.G_RET_STS_SUCCESS;

5731: IF PG_DEBUG in ('Y', 'C') THEN
5732: msc_sch_wb.atp_debug('***** Begin Get_Res_Requirements Procedure *****');
5733: END IF;
5734: -- initialize API return status to success
5735: x_return_status := FND_API.G_RET_STS_SUCCESS;
5736: l_uom_code := NVL(fnd_profile.value('MSC:HOUR_UOM_CODE'),
5737: fnd_profile.value('BOM:HOUR_UOM_CODE'));
5738: l_MSO_Batch_flag := NVL(fnd_profile.value('MSO_BATCHABLE_FLAG'),'N');
5739: IF PG_DEBUG in ('Y', 'C') THEN

Line 9083: x_return_status := FND_API.G_RET_STS_ERROR;

9079: msc_sch_wb.atp_debug('Get_Res_Requirements ' || 'No match for sysdate in cal');
9080: END IF;
9081: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;
9082: WHEN OTHERS THEN
9083: x_return_status := FND_API.G_RET_STS_ERROR;
9084: IF PG_DEBUG in ('Y', 'C') THEN --bug3583705
9085: msc_sch_wb.atp_debug('Get_Res_Requirements ' || 'inside when others');
9086: msc_sch_wb.atp_debug ('error := ' || SQLERRM);
9087: END IF;

Line 9088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9084: IF PG_DEBUG in ('Y', 'C') THEN --bug3583705
9085: msc_sch_wb.atp_debug('Get_Res_Requirements ' || 'inside when others');
9086: msc_sch_wb.atp_debug ('error := ' || SQLERRM);
9087: END IF;
9088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9089: END Get_Res_Requirements;
9090:
9091:
9092: PROCEDURE Get_Comp_Requirements (

Line 9609: x_return_status := FND_API.G_RET_STS_SUCCESS;

9605: AND c2.exception_set_id = tp.calendar_exception_set_id;
9606:
9607: BEGIN
9608: -- initialize API return status to success
9609: x_return_status := FND_API.G_RET_STS_SUCCESS;
9610:
9611: IF PG_DEBUG in ('Y', 'C') THEN
9612: msc_sch_wb.atp_debug('***** Begin Get_Comp_Requirements *****');
9613: END IF;

Line 9960: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

9956: l_routing_seq_id,
9957: l_bill_seq_id,
9958: l_op_seq_id, --4570421
9959: x_return_status);
9960: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9962: END IF;
9963: END IF;
9964:

Line 9961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9957: l_bill_seq_id,
9958: l_op_seq_id, --4570421
9959: x_return_status);
9960: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9962: END IF;
9963: END IF;
9964:
9965: -- 3027711

Line 10642: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

10638: l_return_status,
10639: p_plan_id --bug3510475 pass component's plan id as parent
10640: );
10641:
10642: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10643: IF PG_DEBUG in ('Y', 'C') THEN
10644: msc_sch_wb.atp_debug('Get_Comp_Requirements: ' || 'Error encountered in Get_PF_Plan_Info');
10645: END IF;
10646: END IF;

Line 10696: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

10692: l_return_status,
10693: p_plan_id --bug3510475 pass component's plan id as parent
10694: );
10695:
10696: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10697: IF PG_DEBUG in ('Y', 'C') THEN
10698: msc_sch_wb.atp_debug('Get_Comp_Requirements: ' || 'Error encountered in Get_PF_Plan_Info');
10699: END IF;
10700: END IF;

Line 10928: ELSIF MSC_ATP_PVT.G_INV_CTP = 5 and x_return_status <> FND_API.G_RET_STS_SUCCESS

10924: END IF;
10925: RAISE MSC_ATP_PVT.G_ATO_SOURCING_MISMATCH;
10926:
10927: --bug 3308206: IF ATP rule is not defined on the item then error out with message
10928: ELSIF MSC_ATP_PVT.G_INV_CTP = 5 and x_return_status <> FND_API.G_RET_STS_SUCCESS
10929: and l_atp_rec.error_code = MSC_ATP_PVT.ATP_BAD_RULE THEN
10930: IF PG_DEBUG in ('Y', 'C') THEN
10931: msc_sch_wb.atp_debug('Get_Comp_Requirements: ' || 'No ATP rule on Component');
10932: END IF;

Line 10954: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

10950: END IF;
10951: RAISE MSC_ATP_PVT.G_EXC_UNCOLLECTED_ITEM;
10952: END IF;
10953:
10954: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10956: END IF;
10957:
10958: MSC_ATP_PROC.Details_Output(l_atp_period,

Line 10955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

10951: RAISE MSC_ATP_PVT.G_EXC_UNCOLLECTED_ITEM;
10952: END IF;
10953:
10954: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10956: END IF;
10957:
10958: MSC_ATP_PROC.Details_Output(l_atp_period,
10959: l_atp_supply_demand,

Line 11096: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);

11092: WHEN MSC_ATP_PVT.G_ATO_SOURCING_MISMATCH THEN
11093: IF PG_DEBUG in ('Y', 'C') THEN
11094: msc_sch_wb.atp_debug ('Get_Comp_Reqs: IN Exception Block for G_ATO_SOURCE');
11095: END IF;
11096: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);
11097: RAISE MSC_ATP_PVT.G_ATO_SOURCING_MISMATCH;
11098:
11099: -- dsting 2764213
11100: WHEN MSC_ATP_PVT.EXC_NO_PLAN_FOUND THEN

Line 11104: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);

11100: WHEN MSC_ATP_PVT.EXC_NO_PLAN_FOUND THEN
11101: IF PG_DEBUG in ('Y', 'C') THEN
11102: msc_sch_wb.atp_debug ('Get_Comp_Reqs: IN Exception Block for EXC_NO_PLAN_FOUND');
11103: END IF;
11104: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);
11105: RAISE MSC_ATP_PVT.EXC_NO_PLAN_FOUND;
11106:
11107: -- krajan 2752705
11108: WHEN MSC_ATP_PVT.G_EXC_UNCOLLECTED_ITEM THEN

Line 11112: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);

11108: WHEN MSC_ATP_PVT.G_EXC_UNCOLLECTED_ITEM THEN
11109: IF PG_DEBUG in ('Y', 'C') THEN
11110: msc_sch_wb.atp_debug ('Get_Comp_Reqs: IN Exception Block for G_EXC_UNCOLLECTED_ITEM');
11111: END IF;
11112: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);
11113: RAISE MSC_ATP_PVT.G_EXC_UNCOLLECTED_ITEM;
11114:
11115: ---bug 3308206: Add exception so that it could be propogated to ATP_check
11116: WHEN MSC_ATP_PVT.EXC_NO_ATP_RULE THEN

Line 11133: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);

11129: IF PG_DEBUG in ('Y', 'C') THEN
11130: msc_sch_wb.atp_debug ('Get_Comp_Reqs: IN Exception Block in others');
11131: msc_sch_wb.atp_debug ('error := ' || SQLERRM);
11132: END IF;
11133: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);
11134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11135:
11136: END Get_Comp_Requirements;
11137:

Line 11134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

11130: msc_sch_wb.atp_debug ('Get_Comp_Reqs: IN Exception Block in others');
11131: msc_sch_wb.atp_debug ('error := ' || SQLERRM);
11132: END IF;
11133: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);
11134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11135:
11136: END Get_Comp_Requirements;
11137:
11138: /* Spec changes as part of ship_rec_cal changes

Line 11231: x_return_status := FND_API.G_RET_STS_SUCCESS;

11227: END IF;
11228:
11229:
11230: -- initialize API return status to success
11231: x_return_status := FND_API.G_RET_STS_SUCCESS;
11232:
11233: l_requested_date := trunc(p_sup_atp_info_rec.requested_date);
11234:
11235: ---profile option for including purchase order

Line 11642: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

11638: MSC_ATP_PROC.atp_consume(l_atp_qty_tab, l_atp_qty_tab.COUNT);
11639:
11640: /* Cum drop issue changes begin*/
11641: MSC_AATP_PROC.Atp_Remove_Negatives(l_atp_qty_tab, l_return_status);
11642: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11643: IF PG_DEBUG in ('Y', 'C') THEN
11644: msc_sch_wb.atp_debug('Get_Supplier_Atp_Info: ' || 'Error occured in procedure Atp_Remove_Negatives');
11645: END IF;
11646: RAISE FND_API.G_EXC_ERROR;

Line 11646: RAISE FND_API.G_EXC_ERROR;

11642: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11643: IF PG_DEBUG in ('Y', 'C') THEN
11644: msc_sch_wb.atp_debug('Get_Supplier_Atp_Info: ' || 'Error occured in procedure Atp_Remove_Negatives');
11645: END IF;
11646: RAISE FND_API.G_EXC_ERROR;
11647: END IF;
11648: /* Cum drop issue changes end*/
11649:
11650: ELSE -- IF l_summary_sql = 'Y' THEN

Line 11731: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

11727: MSC_ATP_PROC.atp_consume(l_atp_qty_tab, l_atp_qty_tab.COUNT);
11728:
11729: /* Cum drop issue changes begin*/
11730: MSC_AATP_PROC.Atp_Remove_Negatives(l_atp_qty_tab, l_return_status);
11731: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11732: IF PG_DEBUG in ('Y', 'C') THEN
11733: msc_sch_wb.atp_debug('Get_Supplier_Atp_Info: ' || 'Error occured in procedure Atp_Remove_Negatives');
11734: END IF;
11735: RAISE FND_API.G_EXC_ERROR;

Line 11735: RAISE FND_API.G_EXC_ERROR;

11731: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11732: IF PG_DEBUG in ('Y', 'C') THEN
11733: msc_sch_wb.atp_debug('Get_Supplier_Atp_Info: ' || 'Error occured in procedure Atp_Remove_Negatives');
11734: END IF;
11735: RAISE FND_API.G_EXC_ERROR;
11736: END IF;
11737: /* Cum drop issue changes end*/
11738:
11739: ELSE

Line 11808: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

11804: MSC_ATP_PROC.atp_consume(l_atp_qty_tab, l_atp_qty_tab.COUNT);
11805:
11806: /* Cum drop issue changes begin*/
11807: MSC_AATP_PROC.Atp_Remove_Negatives(l_atp_qty_tab, l_return_status);
11808: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11809: IF PG_DEBUG in ('Y', 'C') THEN
11810: msc_sch_wb.atp_debug('Get_Supplier_Atp_Info: ' || 'Error occured in procedure Atp_Remove_Negatives');
11811: END IF;
11812: RAISE FND_API.G_EXC_ERROR;

Line 11812: RAISE FND_API.G_EXC_ERROR;

11808: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11809: IF PG_DEBUG in ('Y', 'C') THEN
11810: msc_sch_wb.atp_debug('Get_Supplier_Atp_Info: ' || 'Error occured in procedure Atp_Remove_Negatives');
11811: END IF;
11812: RAISE FND_API.G_EXC_ERROR;
11813: END IF;
11814: /* Cum drop issue changes end*/
11815:
11816: END IF; --IF l_check_cap_model_flag = 1 THEN

Line 12184: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

12180: END IF;
12181:
12182: /* Cum drop issue changes begin*/
12183: MSC_AATP_PROC.Atp_Remove_Negatives(x_atp_period.Cumulative_Quantity, l_return_status);
12184: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
12185: IF PG_DEBUG in ('Y', 'C') THEN
12186: msc_sch_wb.atp_debug('Get_Supplier_Atp_Info: ' || 'Error occured in procedure Atp_Remove_Negatives');
12187: END IF;
12188: RAISE FND_API.G_EXC_ERROR;

Line 12188: RAISE FND_API.G_EXC_ERROR;

12184: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
12185: IF PG_DEBUG in ('Y', 'C') THEN
12186: msc_sch_wb.atp_debug('Get_Supplier_Atp_Info: ' || 'Error occured in procedure Atp_Remove_Negatives');
12187: END IF;
12188: RAISE FND_API.G_EXC_ERROR;
12189: END IF;
12190: /* Cum drop issue changes end*/
12191:
12192: l_atp_period_tab := x_atp_period.Period_Start_Date;

Line 12539: x_return_status := FND_API.G_RET_STS_ERROR;

12535: EXCEPTION
12536:
12537: WHEN NO_DATA_FOUND THEN
12538: p_sup_atp_info_rec.requested_date_quantity := 0.0;
12539: x_return_status := FND_API.G_RET_STS_ERROR;
12540: END Get_Supplier_Atp_Info;
12541:
12542:
12543: PROCEDURE Get_Transport_Cap_Atp_Info (

Line 12607: x_return_status := FND_API.G_RET_STS_SUCCESS;

12603: msc_sch_wb.atp_debug('Get_Transport_Cap_Atp_Info: ' || 'p_insert_flag = '||p_insert_flag);
12604: END IF;
12605:
12606: -- initialize API return status to success
12607: x_return_status := FND_API.G_RET_STS_SUCCESS;
12608:
12609: l_requested_date := trunc(p_requested_date);
12610:
12611: -- Initialize the record with null

Line 13503: x_return_status := FND_API.G_RET_STS_ERROR;

13499:
13500: EXCEPTION
13501:
13502: WHEN NO_DATA_FOUND THEN
13503: x_return_status := FND_API.G_RET_STS_ERROR;
13504: END Get_Transport_Cap_Atp_Info;
13505:
13506:
13507: --s_cto_rearch