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_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 9079: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 9084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 9603: x_return_status := FND_API.G_RET_STS_SUCCESS;

9599: AND c2.exception_set_id = tp.calendar_exception_set_id;
9600:
9601: BEGIN
9602: -- initialize API return status to success
9603: x_return_status := FND_API.G_RET_STS_SUCCESS;
9604:
9605: IF PG_DEBUG in ('Y', 'C') THEN
9606: msc_sch_wb.atp_debug('***** Begin Get_Comp_Requirements *****');
9607: END IF;

Line 9954: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

9950: l_routing_seq_id,
9951: l_bill_seq_id,
9952: l_op_seq_id, --4570421
9953: x_return_status);
9954: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9956: END IF;
9957: END IF;
9958:

Line 9955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9951: l_bill_seq_id,
9952: l_op_seq_id, --4570421
9953: x_return_status);
9954: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9956: END IF;
9957: END IF;
9958:
9959: -- 3027711

Line 10627: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

10623: l_return_status,
10624: p_plan_id --bug3510475 pass component's plan id as parent
10625: );
10626:
10627: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10628: IF PG_DEBUG in ('Y', 'C') THEN
10629: msc_sch_wb.atp_debug('Get_Comp_Requirements: ' || 'Error encountered in Get_PF_Plan_Info');
10630: END IF;
10631: END IF;

Line 10681: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

10677: l_return_status,
10678: p_plan_id --bug3510475 pass component's plan id as parent
10679: );
10680:
10681: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10682: IF PG_DEBUG in ('Y', 'C') THEN
10683: msc_sch_wb.atp_debug('Get_Comp_Requirements: ' || 'Error encountered in Get_PF_Plan_Info');
10684: END IF;
10685: END IF;

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

10899: END IF;
10900: RAISE MSC_ATP_PVT.G_ATO_SOURCING_MISMATCH;
10901:
10902: --bug 3308206: IF ATP rule is not defined on the item then error out with message
10903: ELSIF MSC_ATP_PVT.G_INV_CTP = 5 and x_return_status <> FND_API.G_RET_STS_SUCCESS
10904: and l_atp_rec.error_code = MSC_ATP_PVT.ATP_BAD_RULE THEN
10905: IF PG_DEBUG in ('Y', 'C') THEN
10906: msc_sch_wb.atp_debug('Get_Comp_Requirements: ' || 'No ATP rule on Component');
10907: END IF;

Line 10929: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

10925: END IF;
10926: RAISE MSC_ATP_PVT.G_EXC_UNCOLLECTED_ITEM;
10927: END IF;
10928:
10929: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10931: END IF;
10932:
10933: MSC_ATP_PROC.Details_Output(l_atp_period,

Line 10930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

10926: RAISE MSC_ATP_PVT.G_EXC_UNCOLLECTED_ITEM;
10927: END IF;
10928:
10929: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10931: END IF;
10932:
10933: MSC_ATP_PROC.Details_Output(l_atp_period,
10934: l_atp_supply_demand,

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

11067: WHEN MSC_ATP_PVT.G_ATO_SOURCING_MISMATCH THEN
11068: IF PG_DEBUG in ('Y', 'C') THEN
11069: msc_sch_wb.atp_debug ('Get_Comp_Reqs: IN Exception Block for G_ATO_SOURCE');
11070: END IF;
11071: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);
11072: RAISE MSC_ATP_PVT.G_ATO_SOURCING_MISMATCH;
11073:
11074: -- dsting 2764213
11075: WHEN MSC_ATP_PVT.EXC_NO_PLAN_FOUND THEN

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

11075: WHEN MSC_ATP_PVT.EXC_NO_PLAN_FOUND THEN
11076: IF PG_DEBUG in ('Y', 'C') THEN
11077: msc_sch_wb.atp_debug ('Get_Comp_Reqs: IN Exception Block for EXC_NO_PLAN_FOUND');
11078: END IF;
11079: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);
11080: RAISE MSC_ATP_PVT.EXC_NO_PLAN_FOUND;
11081:
11082: -- krajan 2752705
11083: WHEN MSC_ATP_PVT.G_EXC_UNCOLLECTED_ITEM THEN

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

11083: WHEN MSC_ATP_PVT.G_EXC_UNCOLLECTED_ITEM THEN
11084: IF PG_DEBUG in ('Y', 'C') THEN
11085: msc_sch_wb.atp_debug ('Get_Comp_Reqs: IN Exception Block for G_EXC_UNCOLLECTED_ITEM');
11086: END IF;
11087: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);
11088: RAISE MSC_ATP_PVT.G_EXC_UNCOLLECTED_ITEM;
11089:
11090: ---bug 3308206: Add exception so that it could be propogated to ATP_check
11091: WHEN MSC_ATP_PVT.EXC_NO_ATP_RULE THEN

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

11104: IF PG_DEBUG in ('Y', 'C') THEN
11105: msc_sch_wb.atp_debug ('Get_Comp_Reqs: IN Exception Block in others');
11106: msc_sch_wb.atp_debug ('error := ' || SQLERRM);
11107: END IF;
11108: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);
11109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11110:
11111: END Get_Comp_Requirements;
11112:

Line 11109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

11105: msc_sch_wb.atp_debug ('Get_Comp_Reqs: IN Exception Block in others');
11106: msc_sch_wb.atp_debug ('error := ' || SQLERRM);
11107: END IF;
11108: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);
11109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11110:
11111: END Get_Comp_Requirements;
11112:
11113: /* Spec changes as part of ship_rec_cal changes

Line 11206: x_return_status := FND_API.G_RET_STS_SUCCESS;

11202: END IF;
11203:
11204:
11205: -- initialize API return status to success
11206: x_return_status := FND_API.G_RET_STS_SUCCESS;
11207:
11208: l_requested_date := trunc(p_sup_atp_info_rec.requested_date);
11209:
11210: ---profile option for including purchase order

Line 11609: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

11605: MSC_ATP_PROC.atp_consume(l_atp_qty_tab, l_atp_qty_tab.COUNT);
11606:
11607: /* Cum drop issue changes begin*/
11608: MSC_AATP_PROC.Atp_Remove_Negatives(l_atp_qty_tab, l_return_status);
11609: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11610: IF PG_DEBUG in ('Y', 'C') THEN
11611: msc_sch_wb.atp_debug('Get_Supplier_Atp_Info: ' || 'Error occured in procedure Atp_Remove_Negatives');
11612: END IF;
11613: RAISE FND_API.G_EXC_ERROR;

Line 11613: RAISE FND_API.G_EXC_ERROR;

11609: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11610: IF PG_DEBUG in ('Y', 'C') THEN
11611: msc_sch_wb.atp_debug('Get_Supplier_Atp_Info: ' || 'Error occured in procedure Atp_Remove_Negatives');
11612: END IF;
11613: RAISE FND_API.G_EXC_ERROR;
11614: END IF;
11615: /* Cum drop issue changes end*/
11616:
11617: ELSE -- IF l_summary_sql = 'Y' THEN

Line 11698: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

11694: MSC_ATP_PROC.atp_consume(l_atp_qty_tab, l_atp_qty_tab.COUNT);
11695:
11696: /* Cum drop issue changes begin*/
11697: MSC_AATP_PROC.Atp_Remove_Negatives(l_atp_qty_tab, l_return_status);
11698: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11699: IF PG_DEBUG in ('Y', 'C') THEN
11700: msc_sch_wb.atp_debug('Get_Supplier_Atp_Info: ' || 'Error occured in procedure Atp_Remove_Negatives');
11701: END IF;
11702: RAISE FND_API.G_EXC_ERROR;

Line 11702: RAISE FND_API.G_EXC_ERROR;

11698: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11699: IF PG_DEBUG in ('Y', 'C') THEN
11700: msc_sch_wb.atp_debug('Get_Supplier_Atp_Info: ' || 'Error occured in procedure Atp_Remove_Negatives');
11701: END IF;
11702: RAISE FND_API.G_EXC_ERROR;
11703: END IF;
11704: /* Cum drop issue changes end*/
11705:
11706: ELSE

Line 11775: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

11771: MSC_ATP_PROC.atp_consume(l_atp_qty_tab, l_atp_qty_tab.COUNT);
11772:
11773: /* Cum drop issue changes begin*/
11774: MSC_AATP_PROC.Atp_Remove_Negatives(l_atp_qty_tab, l_return_status);
11775: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11776: IF PG_DEBUG in ('Y', 'C') THEN
11777: msc_sch_wb.atp_debug('Get_Supplier_Atp_Info: ' || 'Error occured in procedure Atp_Remove_Negatives');
11778: END IF;
11779: RAISE FND_API.G_EXC_ERROR;

Line 11779: RAISE FND_API.G_EXC_ERROR;

11775: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11776: IF PG_DEBUG in ('Y', 'C') THEN
11777: msc_sch_wb.atp_debug('Get_Supplier_Atp_Info: ' || 'Error occured in procedure Atp_Remove_Negatives');
11778: END IF;
11779: RAISE FND_API.G_EXC_ERROR;
11780: END IF;
11781: /* Cum drop issue changes end*/
11782:
11783: END IF; --IF l_check_cap_model_flag = 1 THEN

Line 12151: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

12147: END IF;
12148:
12149: /* Cum drop issue changes begin*/
12150: MSC_AATP_PROC.Atp_Remove_Negatives(x_atp_period.Cumulative_Quantity, l_return_status);
12151: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
12152: IF PG_DEBUG in ('Y', 'C') THEN
12153: msc_sch_wb.atp_debug('Get_Supplier_Atp_Info: ' || 'Error occured in procedure Atp_Remove_Negatives');
12154: END IF;
12155: RAISE FND_API.G_EXC_ERROR;

Line 12155: RAISE FND_API.G_EXC_ERROR;

12151: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
12152: IF PG_DEBUG in ('Y', 'C') THEN
12153: msc_sch_wb.atp_debug('Get_Supplier_Atp_Info: ' || 'Error occured in procedure Atp_Remove_Negatives');
12154: END IF;
12155: RAISE FND_API.G_EXC_ERROR;
12156: END IF;
12157: /* Cum drop issue changes end*/
12158:
12159: l_atp_period_tab := x_atp_period.Period_Start_Date;

Line 12506: x_return_status := FND_API.G_RET_STS_ERROR;

12502: EXCEPTION
12503:
12504: WHEN NO_DATA_FOUND THEN
12505: p_sup_atp_info_rec.requested_date_quantity := 0.0;
12506: x_return_status := FND_API.G_RET_STS_ERROR;
12507: END Get_Supplier_Atp_Info;
12508:
12509:
12510: PROCEDURE Get_Transport_Cap_Atp_Info (

Line 12574: x_return_status := FND_API.G_RET_STS_SUCCESS;

12570: msc_sch_wb.atp_debug('Get_Transport_Cap_Atp_Info: ' || 'p_insert_flag = '||p_insert_flag);
12571: END IF;
12572:
12573: -- initialize API return status to success
12574: x_return_status := FND_API.G_RET_STS_SUCCESS;
12575:
12576: l_requested_date := trunc(p_requested_date);
12577:
12578: -- Initialize the record with null

Line 13470: x_return_status := FND_API.G_RET_STS_ERROR;

13466:
13467: EXCEPTION
13468:
13469: WHEN NO_DATA_FOUND THEN
13470: x_return_status := FND_API.G_RET_STS_ERROR;
13471: END Get_Transport_Cap_Atp_Info;
13472:
13473:
13474: --s_cto_rearch