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_AATP_PVT dependencies on FND_API

Line 3891: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3887: IF p_scenario_id <> -1 THEN
3888: MSC_AATP_PVT.Get_DC_Info(p_instance_id, l_item_to_use, p_organization_id, null, null,
3889: p_demand_class, p_request_date, l_level_id, l_priority, l_allocation_percent, l_return_status);
3890:
3891: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3892: IF PG_DEBUG in ('Y', 'C') THEN
3893: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error retrieving Priority and Demand Class');
3894: END IF;
3895: END IF;

Line 4367: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4363: l_current_atp.atp_qty,
4364: l_unallocated_atp.atp_qty,
4365: l_return_status
4366: );
4367: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4368: IF PG_DEBUG in ('Y', 'C') THEN
4369: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error occured in procedure Item_Alloc_Avail_Pf_Unalloc');
4370: END IF;
4371: RAISE FND_API.G_EXC_ERROR;

Line 4371: RAISE FND_API.G_EXC_ERROR;

4367: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4368: IF PG_DEBUG in ('Y', 'C') THEN
4369: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error occured in procedure Item_Alloc_Avail_Pf_Unalloc');
4370: END IF;
4371: RAISE FND_API.G_EXC_ERROR;
4372: END IF;
4373: END IF;
4374:
4375: IF PG_DEBUG in ('Y', 'C') THEN

Line 4394: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4390: l_return_status,
4391: l_current_atp.atp_period,
4392: MSC_ATP_PF.Bw_Fw_Cum, --b/w, f/w consumption and accumulation
4393: p_atf_date);
4394: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4395: IF PG_DEBUG in ('Y', 'C') THEN
4396: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error occured in procedure Pf_Atp_Consume');
4397: END IF;
4398: RAISE FND_API.G_EXC_ERROR;

Line 4398: RAISE FND_API.G_EXC_ERROR;

4394: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4395: IF PG_DEBUG in ('Y', 'C') THEN
4396: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error occured in procedure Pf_Atp_Consume');
4397: END IF;
4398: RAISE FND_API.G_EXC_ERROR;
4399: END IF;
4400: ELSE
4401: MSC_ATP_PROC.Atp_Consume(l_unallocated_atp.atp_qty, l_unallocated_atp.atp_qty.COUNT);
4402: END IF;

Line 4454: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4450: l_current_atp.atp_period,
4451: l_current_atp.atp_qty,
4452: l_return_status
4453: );
4454: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4455: IF PG_DEBUG in ('Y', 'C') THEN
4456: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error occured in procedure Item_Alloc_Avail_Pf');
4457: END IF;
4458: RAISE FND_API.G_EXC_ERROR;

Line 4458: RAISE FND_API.G_EXC_ERROR;

4454: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4455: IF PG_DEBUG in ('Y', 'C') THEN
4456: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error occured in procedure Item_Alloc_Avail_Pf');
4457: END IF;
4458: RAISE FND_API.G_EXC_ERROR;
4459: END IF;
4460: END IF;
4461: END IF;
4462:

Line 4519: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4515: p_get_mat_in_rec.sys_next_osc_date, --bug3099066 bug3333114
4516: p_atf_date,
4517: l_return_status
4518: );
4519: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4520: IF PG_DEBUG in ('Y', 'C') THEN
4521: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error occured in procedure Item_Alloc_Avail_Pf_Dtls');
4522: END IF;
4523: RAISE FND_API.G_EXC_ERROR;

Line 4523: RAISE FND_API.G_EXC_ERROR;

4519: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4520: IF PG_DEBUG in ('Y', 'C') THEN
4521: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error occured in procedure Item_Alloc_Avail_Pf_Dtls');
4522: END IF;
4523: RAISE FND_API.G_EXC_ERROR;
4524: END IF;
4525: END IF;
4526:
4527: -- for period ATP

Line 4545: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

4541: ELSE
4542: MSC_AATP_PROC.get_unalloc_data_from_SD_temp(x_atp_period, l_unallocated_atp, l_return_status);
4543: END IF;
4544:
4545: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4546: IF PG_DEBUG in ('Y', 'C') THEN
4547: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error in call to get_unalloc_data_from_SD_temp');
4548: END IF;
4549: END IF;

Line 4572: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4568: l_return_status,
4569: x_atp_period.Period_Start_Date,
4570: MSC_ATP_PF.Bw_Fw_Cum, --b/w, f/w consumption and accumulation
4571: p_atf_date);
4572: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4573: IF PG_DEBUG in ('Y', 'C') THEN
4574: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error occured in procedure Pf_Atp_Consume');
4575: END IF;
4576: RAISE FND_API.G_EXC_ERROR;

Line 4576: RAISE FND_API.G_EXC_ERROR;

4572: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4573: IF PG_DEBUG in ('Y', 'C') THEN
4574: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error occured in procedure Pf_Atp_Consume');
4575: END IF;
4576: RAISE FND_API.G_EXC_ERROR;
4577: END IF;
4578: ELSE
4579: MSC_ATP_PROC.Atp_Consume(l_unallocated_atp.atp_qty, l_unallocated_atp.atp_qty.COUNT);
4580: END IF;

Line 4596: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4592: ELSE
4593: -- time_phased_atp
4594: IF l_time_phased_atp='Y' THEN
4595: MSC_ATP_PF.Get_Period_Data_From_Sd_Temp(x_atp_period, l_return_status);
4596: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4597: IF PG_DEBUG in ('Y', 'C') THEN
4598: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error occured in procedure Get_Period_Data_From_Sd_Temp');
4599: END IF;
4600: RAISE FND_API.G_EXC_ERROR;

Line 4600: RAISE FND_API.G_EXC_ERROR;

4596: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4597: IF PG_DEBUG in ('Y', 'C') THEN
4598: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error occured in procedure Get_Period_Data_From_Sd_Temp');
4599: END IF;
4600: RAISE FND_API.G_EXC_ERROR;
4601: END IF;
4602: ELSE
4603: /* time_phased_atp
4604: call new procedure to fix the issue of not displaying correct quantities in ATP SD Window when

Line 4607: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4603: /* time_phased_atp
4604: call new procedure to fix the issue of not displaying correct quantities in ATP SD Window when
4605: user opens ATP SD window from ATP pegging in allocated scenarios*/
4606: MSC_ATP_PROC.Get_Alloc_Data_From_Sd_Temp(x_atp_period, l_return_status);
4607: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4608: IF PG_DEBUG in ('Y', 'C') THEN
4609: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error occured in procedure get_alloc_data_from_SD_temp');
4610: END IF;
4611: RAISE FND_API.G_EXC_ERROR;

Line 4611: RAISE FND_API.G_EXC_ERROR;

4607: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4608: IF PG_DEBUG in ('Y', 'C') THEN
4609: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error occured in procedure get_alloc_data_from_SD_temp');
4610: END IF;
4611: RAISE FND_API.G_EXC_ERROR;
4612: END IF;
4613: END IF;
4614:
4615: IF PG_DEBUG in ('Y', 'C') THEN

Line 4650: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4646: l_return_status,
4647: l_current_atp.atp_period,
4648: MSC_ATP_PF.Backward, --b/w consumption
4649: p_atf_date);
4650: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4651: IF PG_DEBUG in ('Y', 'C') THEN
4652: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error occured in procedure Pf_Atp_Consume');
4653: END IF;
4654: RAISE FND_API.G_EXC_ERROR;

Line 4654: RAISE FND_API.G_EXC_ERROR;

4650: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4651: IF PG_DEBUG in ('Y', 'C') THEN
4652: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error occured in procedure Pf_Atp_Consume');
4653: END IF;
4654: RAISE FND_API.G_EXC_ERROR;
4655: END IF;
4656: ELSE
4657: MSC_ATP_PROC.Atp_Backward_Consume(l_current_atp.atp_qty);
4658: END IF;

Line 5042: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5038: l_current_steal_atp);
5039: END IF;
5040:
5041: MSC_AATP_PROC.Add_to_Current_Atp(l_current_steal_atp, l_current_atp, l_return_status);
5042: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5043: IF PG_DEBUG in ('Y', 'C') THEN
5044: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error in call to Add_to_Current_Atp');
5045: END IF;
5046: END IF;

Line 5054: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5050: l_current_atp);
5051: END IF;
5052:
5053: MSC_AATP_PROC.Atp_Forward_Consume(l_current_atp.atp_period, p_atf_date, l_current_atp.atp_qty, l_return_status);
5054: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5055: IF PG_DEBUG in ('Y', 'C') THEN
5056: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error in call to Atp_Forward_Consume');
5057: END IF;
5058: END IF;

Line 5071: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5067: after forward consumption. we will not show these negatives in atp_inquiry for
5068: Allocated ATP with User Defined %.*/
5069:
5070: MSC_AATP_PROC.Atp_Remove_Negatives(l_current_atp.atp_qty, l_return_status);
5071: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5072: IF PG_DEBUG in ('Y', 'C') THEN
5073: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error in call to Atp_Remove_Negatives');
5074: END IF;
5075: END IF;

Line 5088: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5084: IF PG_DEBUG in ('Y', 'C') THEN
5085: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Method 2');
5086: END IF;
5087: MSC_AATP_PROC.Atp_remove_negatives(l_current_atp.atp_qty, l_return_status);
5088: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5089: IF PG_DEBUG in ('Y', 'C') THEN
5090: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error in call to Atp_remove_negatives');
5091: END IF;
5092: END IF;

Line 5162: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5158: l_current_atp);
5159: END IF;
5160:
5161: MSC_AATP_PROC.Atp_Forward_Consume(l_current_atp.atp_period, p_atf_date, l_current_atp.atp_qty, l_return_status);
5162: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5163: IF PG_DEBUG in ('Y', 'C') THEN
5164: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error in call to Atp_Forward_Consume');
5165: END IF;
5166: END IF;

Line 5179: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5175: after forward consumption. we will not show these negatives in atp_inquiry for
5176: Allocated ATP with User Defined %.*/
5177:
5178: MSC_AATP_PROC.Atp_Remove_Negatives(l_current_atp.atp_qty, l_return_status);
5179: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5180: IF PG_DEBUG in ('Y', 'C') THEN
5181: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error in call to Atp_Remove_Negatives');
5182: END IF;
5183: END IF;

Line 5229: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5225: Print_Period_Qty('l_class_next_steal_atp.atp_period:atp_qty = ',
5226: l_class_next_steal_atp);
5227: END IF;
5228: MSC_AATP_PROC.Add_to_Current_Atp(l_class_next_steal_atp, l_current_atp, l_return_status);
5229: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5230: IF PG_DEBUG in ('Y', 'C') THEN
5231: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error in call to Add_to_Current_Atp');
5232: END IF;
5233: END IF;

Line 5244: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5240: Print_Period_Qty('l_class_next_steal_atp.atp_period:atp_qty = ',
5241: l_class_next_steal_atp);
5242: END IF;
5243: MSC_AATP_PROC.Atp_Forward_Consume(l_current_atp.atp_period, p_atf_date, l_current_atp.atp_qty, l_return_status);
5244: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5245: IF PG_DEBUG in ('Y', 'C') THEN
5246: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error in call to Atp_Forward_Consume');
5247: END IF;
5248: END IF;

Line 5261: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5257: after forward consumption. we will not show these negatives in atp_inquiry for
5258: Allocated ATP with User Defined %.*/
5259:
5260: MSC_AATP_PROC.Atp_Remove_Negatives(l_current_atp.atp_qty, l_return_status);
5261: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5262: IF PG_DEBUG in ('Y', 'C') THEN
5263: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error in call to Atp_Remove_Negatives');
5264: END IF;
5265: END IF;

Line 5279: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5275: IF PG_DEBUG in ('Y', 'C') THEN
5276: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Method 2');
5277: END IF;
5278: MSC_AATP_PROC.Atp_remove_negatives(l_current_atp.atp_qty, l_return_status);
5279: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5280: IF PG_DEBUG in ('Y', 'C') THEN
5281: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error in call to Atp_remove_negatives');
5282: END IF;
5283: END IF;

Line 5487: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5483: Print_Period_Qty('l_next_steal_atp.atp_period:atp_qty = ',
5484: l_next_steal_atp);
5485: END IF;
5486: MSC_AATP_PROC.Add_to_Current_Atp(l_next_steal_atp, l_current_atp, l_return_status);
5487: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5488: IF PG_DEBUG in ('Y', 'C') THEN
5489: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error in call to Add_to_Current_Atp');
5490: END IF;
5491: END IF;

Line 5514: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5510: Print_Period_Qty('l_partner_next_steal_atp.atp_period:atp_qty = ',
5511: l_partner_next_steal_atp);
5512: END IF;
5513: MSC_AATP_PROC.Add_to_Current_Atp(l_partner_next_steal_atp, l_current_atp, l_return_status);
5514: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5515: IF PG_DEBUG in ('Y', 'C') THEN
5516: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error in call to Add_to_Current_Atp');
5517: END IF;
5518: END IF;

Line 5534: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5530: Print_Period_Qty('l_current_atp.atp_period:atp_qty = ',
5531: l_current_atp);
5532: END IF;
5533: MSC_AATP_PROC.Atp_Forward_Consume(l_current_atp.atp_period, p_atf_date, l_current_atp.atp_qty, l_return_status);
5534: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5535: IF PG_DEBUG in ('Y', 'C') THEN
5536: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error in call to Atp_Forward_Consume');
5537: END IF;
5538: END IF;

Line 5550: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5546: after forward consumption. we will not show these negatives in atp_inquiry for
5547: Allocated ATP with User Defined %.*/
5548:
5549: MSC_AATP_PROC.Atp_Remove_Negatives(l_current_atp.atp_qty, l_return_status);
5550: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5551: IF PG_DEBUG in ('Y', 'C') THEN
5552: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error in call to Atp_Remove_Negatives');
5553: END IF;
5554: END IF;

Line 5583: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5579: l_current_atp);
5580: END IF;
5581:
5582: MSC_AATP_PROC.Atp_Adjusted_Cum(l_current_atp, l_unallocated_atp, l_return_status);
5583: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5584: IF PG_DEBUG in ('Y', 'C') THEN
5585: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error in call to Atp_Forward_Consume');
5586: END IF;
5587: END IF;

Line 5878: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5874: MSC_AATP_PVT.Get_DC_Info(p_instance_id, null, p_organization_id,
5875: p_department_id, p_resource_id, p_demand_class,
5876: p_request_date, l_level_id, l_priority, l_allocation_percent, l_return_status);
5877:
5878: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5879: IF PG_DEBUG in ('Y', 'C') THEN
5880: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'Error retrieving Priority and Demand Class');
5881: END IF;
5882: END IF;

Line 6063: RAISE FND_API.G_EXC_ERROR;

6059:
6060: IF (l_sys_next_date is NULL) THEN
6061: msc_sch_wb.atp_debug('Sys Next Date is null');
6062: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.NO_MATCHING_CAL_DATE;
6063: RAISE FND_API.G_EXC_ERROR;
6064: END IF;
6065: --bug3333114 end
6066:
6067: IF PG_DEBUG in ('Y', 'C') THEN

Line 8949: RAISE FND_API.G_EXC_ERROR;

8945:
8946: IF (l_sys_next_date is NULL) THEN
8947: msc_sch_wb.atp_debug('Sys Next Date is null');
8948: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.NO_MATCHING_CAL_DATE;
8949: RAISE FND_API.G_EXC_ERROR;
8950: END IF;
8951: --bug3333114 end
8952:
8953: IF PG_DEBUG in ('Y', 'C') THEN

Line 10305: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

10301: x_atp_info := l_current_atp;
10302:
10303: --4055719 , calling remove -ves
10304: MSC_AATP_PROC.Atp_Remove_Negatives(x_atp_period.Cumulative_Quantity, l_return_status);
10305: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10306: IF PG_DEBUG in ('Y', 'C') THEN
10307: msc_sch_wb.atp_debug('Supplier_Alloc_Cum_Atp: ' || 'Error occured in procedure Atp_Remove_Negatives');
10308: END IF;
10309: RAISE FND_API.G_EXC_ERROR;

Line 10309: RAISE FND_API.G_EXC_ERROR;

10305: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10306: IF PG_DEBUG in ('Y', 'C') THEN
10307: msc_sch_wb.atp_debug('Supplier_Alloc_Cum_Atp: ' || 'Error occured in procedure Atp_Remove_Negatives');
10308: END IF;
10309: RAISE FND_API.G_EXC_ERROR;
10310: END IF;
10311:
10312: --4055719 , moved this code to MSC_ATP_REQ.get_supplier_atp_info
10313: -- get the infinite time fence date if it exists

Line 10396: x_return_status := FND_API.G_RET_STS_SUCCESS;

10392: msc_sch_wb.atp_debug('Get_DC_Info: ' || 'p_request_date =' || p_request_date );
10393: END IF;
10394:
10395: -- initialize API return status to success
10396: x_return_status := FND_API.G_RET_STS_SUCCESS;
10397:
10398: IF p_inv_item_id is not null THEN
10399: -- Get the allocation percent for the item/demand class. If no rule found,
10400: -- check if a rule on the specified date exists for any demand class

Line 10550: x_return_status := FND_API.G_RET_STS_ERROR;

10546: msc_sch_wb.atp_debug('Get_DC_Info: ' || 'Error code:' || to_char(sqlcode));
10547: END IF;
10548: x_priority := -1;
10549: x_alloc_percent := 0;
10550: x_return_status := FND_API.G_RET_STS_ERROR;
10551: END Get_DC_Info;
10552:
10553: PROCEDURE View_Allocation(
10554: p_session_id IN NUMBER,

Line 10641: RAISE FND_API.G_EXC_ERROR;

10637: IF PG_DEBUG in ('Y', 'C') THEN
10638: msc_sch_wb.atp_debug('View_Allocation: ' || 'Request date is null');
10639: END IF;
10640: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.NO_MATCHING_CAL_DATE;
10641: RAISE FND_API.G_EXC_ERROR;
10642: END IF;
10643:
10644: --Check if the request is for Item or Department-Resource.
10645: IF p_inventory_item_id IS NOT NULL THEN

Line 10678: RAISE FND_API.G_EXC_ERROR;

10674: IF PG_DEBUG in ('Y', 'C') THEN
10675: msc_sch_wb.atp_debug ('View_Allocation: ' || 'Plan_ID is null or -1');
10676: END IF;
10677: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.PLAN_NOT_FOUND;
10678: RAISE FND_API.G_EXC_ERROR;
10679: END IF;
10680:
10681: IF (l_plan_id = -100) THEN
10682: IF PG_DEBUG in ('Y', 'C') THEN

Line 10686: RAISE FND_API.G_EXC_ERROR;

10682: IF PG_DEBUG in ('Y', 'C') THEN
10683: msc_sch_wb.atp_debug ('View_Allocation: ' || 'Plan_ID is -100 : Summary Running');
10684: END IF;
10685: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.SUMM_CONC_PROG_RUNNING;
10686: RAISE FND_API.G_EXC_ERROR;
10687: END IF;
10688:
10689: IF (l_plan_id = -200) THEN
10690: IF PG_DEBUG in ('Y', 'C') THEN

Line 10694: RAISE FND_API.G_EXC_ERROR;

10690: IF PG_DEBUG in ('Y', 'C') THEN
10691: msc_sch_wb.atp_debug ('View_Allocation: ' || 'Plan_ID is -200 : Summary Running');
10692: END IF;
10693: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.RUN_POST_PLAN_ALLOC;
10694: RAISE FND_API.G_EXC_ERROR;
10695: END IF;
10696:
10697:
10698:

Line 10897: RAISE FND_API.G_EXC_ERROR;

10893: IF PG_DEBUG in ('Y', 'C') THEN
10894: msc_sch_wb.atp_debug('View_Allocation: ' || 'Plan not found ');
10895: END IF;
10896: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.PLAN_NOT_FOUND;
10897: RAISE FND_API.G_EXC_ERROR;
10898: WHEN others THEN
10899: IF PG_DEBUG in ('Y', 'C') THEN
10900: msc_sch_wb.atp_debug('View_Allocation: ' || 'Error getting plan id :'||sqlcode);
10901: END IF;

Line 10903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

10899: IF PG_DEBUG in ('Y', 'C') THEN
10900: msc_sch_wb.atp_debug('View_Allocation: ' || 'Error getting plan id :'||sqlcode);
10901: END IF;
10902: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.ATP_PROCESSING_ERROR;
10903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10904: END;
10905:
10906: IF PG_DEBUG in ('Y', 'C') THEN
10907: msc_sch_wb.atp_debug('View_Allocation: ' || 'Plan Id : '||to_char(l_plan_id));

Line 11039: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

11035: IF PG_DEBUG in ('Y', 'C') THEN
11036: msc_sch_wb.atp_debug ('View_Allocation: ' || 'l_atp_period is NULL');
11037: msc_sch_wb.atp_debug ('View_Allocation: ' || 'Error Code: ' || MSC_SCH_WB.G_ATP_ERROR_CODE);
11038: END IF;
11039: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11040: END IF;
11041:
11042: IF PG_DEBUG in ('Y', 'C') THEN
11043: mm := l_atp_period.Period_Quantity.FIRST;

Line 11071: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

11067: x_return_status,
11068: l_msg_data,
11069: l_msg_count);
11070:
11071: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11072: IF PG_DEBUG in ('Y', 'C') THEN
11073: msc_sch_wb.atp_debug ('View_Allocation: ' || 'Something wrong in call to PUT_INTO_TEMP_TABLE');
11074: END IF;
11075: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.ATP_PROCESSING_ERROR;

Line 11076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

11072: IF PG_DEBUG in ('Y', 'C') THEN
11073: msc_sch_wb.atp_debug ('View_Allocation: ' || 'Something wrong in call to PUT_INTO_TEMP_TABLE');
11074: END IF;
11075: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.ATP_PROCESSING_ERROR;
11076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11077: END IF;*/
11078:
11079: -- rajjain 01/29/2003 begin Bug 2737596
11080: IF PG_DEBUG in ('Y', 'C') THEN

Line 11104: WHEN FND_API.G_EXC_ERROR THEN

11100:
11101: -- krajan : 2400614
11102: EXCEPTION
11103:
11104: WHEN FND_API.G_EXC_ERROR THEN
11105: -- ATP ERROR CODE WILL BE SET before this exception is raised
11106: IF PG_DEBUG in ('Y', 'C') THEN
11107: msc_sch_wb.atp_debug ('Error in View_Allocation: Expected Error Raised');
11108: END IF;

Line 11109: x_return_status := FND_API.G_RET_STS_ERROR;

11105: -- ATP ERROR CODE WILL BE SET before this exception is raised
11106: IF PG_DEBUG in ('Y', 'C') THEN
11107: msc_sch_wb.atp_debug ('Error in View_Allocation: Expected Error Raised');
11108: END IF;
11109: x_return_status := FND_API.G_RET_STS_ERROR;
11110: IF (MSC_SCH_WB.G_ATP_ERROR_CODE = 0) THEN
11111: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.ATP_PROCESSING_ERROR;
11112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11113: END IF;

Line 11112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

11108: END IF;
11109: x_return_status := FND_API.G_RET_STS_ERROR;
11110: IF (MSC_SCH_WB.G_ATP_ERROR_CODE = 0) THEN
11111: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.ATP_PROCESSING_ERROR;
11112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11113: END IF;
11114:
11115: WHEN MSC_ATP_PUB.ATP_INVALID_OBJECTS_FOUND THEN
11116: IF PG_DEBUG in ('Y', 'C') THEN

Line 11120: x_return_status := FND_API.G_RET_STS_ERROR;

11116: IF PG_DEBUG in ('Y', 'C') THEN
11117: msc_sch_wb.atp_debug ('Error in View_Allocation: Invalid Objects Found');
11118: END IF;
11119: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.ATP_INVALID_OBJECTS;
11120: x_return_status := FND_API.G_RET_STS_ERROR;
11121:
11122: WHEN OTHERS THEN
11123: IF PG_DEBUG in ('Y', 'C') THEN
11124: msc_sch_wb.atp_debug ('Error in View_Allocation');

Line 11126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

11122: WHEN OTHERS THEN
11123: IF PG_DEBUG in ('Y', 'C') THEN
11124: msc_sch_wb.atp_debug ('Error in View_Allocation');
11125: END IF;
11126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11127: IF (MSC_SCH_WB.G_ATP_ERROR_CODE = 0) THEN
11128: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.ATP_PROCESSING_ERROR;
11129: END IF;
11130:

Line 11583: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

11579: p_atp_record.demand_source_type,--cmro
11580: --bug3684383
11581: p_atp_record.order_number,
11582: l_return_status);
11583: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11584: IF PG_DEBUG in ('Y', 'C') THEN
11585: msc_sch_wb.atp_debug('Stealing: ' || 'Error occured in procedure Add_PF_Stealing_Supply_Details');
11586: END IF;
11587: RAISE FND_API.G_EXC_ERROR;

Line 11587: RAISE FND_API.G_EXC_ERROR;

11583: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11584: IF PG_DEBUG in ('Y', 'C') THEN
11585: msc_sch_wb.atp_debug('Stealing: ' || 'Error occured in procedure Add_PF_Stealing_Supply_Details');
11586: END IF;
11587: RAISE FND_API.G_EXC_ERROR;
11588: END IF;
11589: END IF;
11590: -- time_phased_atp changes end
11591: