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 3667: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3663: IF p_scenario_id <> -1 THEN
3664: MSC_AATP_PVT.Get_DC_Info(p_instance_id, l_item_to_use, p_organization_id, null, null,
3665: p_demand_class, p_request_date, l_level_id, l_priority, l_allocation_percent, l_return_status);
3666:
3667: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3668: IF PG_DEBUG in ('Y', 'C') THEN
3669: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error retrieving Priority and Demand Class');
3670: END IF;
3671: END IF;

Line 4141: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4137: l_current_atp.atp_qty,
4138: l_unallocated_atp.atp_qty,
4139: l_return_status
4140: );
4141: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4142: IF PG_DEBUG in ('Y', 'C') THEN
4143: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error occured in procedure Item_Alloc_Avail_Pf_Unalloc');
4144: END IF;
4145: RAISE FND_API.G_EXC_ERROR;

Line 4145: RAISE FND_API.G_EXC_ERROR;

4141: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4142: IF PG_DEBUG in ('Y', 'C') THEN
4143: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error occured in procedure Item_Alloc_Avail_Pf_Unalloc');
4144: END IF;
4145: RAISE FND_API.G_EXC_ERROR;
4146: END IF;
4147: END IF;
4148:
4149: IF PG_DEBUG in ('Y', 'C') THEN

Line 4168: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4164: l_return_status,
4165: l_current_atp.atp_period,
4166: MSC_ATP_PF.Bw_Fw_Cum, --b/w, f/w consumption and accumulation
4167: p_atf_date);
4168: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4169: IF PG_DEBUG in ('Y', 'C') THEN
4170: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error occured in procedure Pf_Atp_Consume');
4171: END IF;
4172: RAISE FND_API.G_EXC_ERROR;

Line 4172: RAISE FND_API.G_EXC_ERROR;

4168: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4169: IF PG_DEBUG in ('Y', 'C') THEN
4170: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error occured in procedure Pf_Atp_Consume');
4171: END IF;
4172: RAISE FND_API.G_EXC_ERROR;
4173: END IF;
4174: ELSE
4175: MSC_ATP_PROC.Atp_Consume(l_unallocated_atp.atp_qty, l_unallocated_atp.atp_qty.COUNT);
4176: END IF;

Line 4226: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4222: l_current_atp.atp_period,
4223: l_current_atp.atp_qty,
4224: l_return_status
4225: );
4226: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4227: IF PG_DEBUG in ('Y', 'C') THEN
4228: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error occured in procedure Item_Alloc_Avail_Pf');
4229: END IF;
4230: RAISE FND_API.G_EXC_ERROR;

Line 4230: RAISE FND_API.G_EXC_ERROR;

4226: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4227: IF PG_DEBUG in ('Y', 'C') THEN
4228: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error occured in procedure Item_Alloc_Avail_Pf');
4229: END IF;
4230: RAISE FND_API.G_EXC_ERROR;
4231: END IF;
4232: END IF;
4233: END IF;
4234:

Line 4289: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4285: p_get_mat_in_rec.sys_next_osc_date, --bug3099066 bug3333114
4286: p_atf_date,
4287: l_return_status
4288: );
4289: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4290: IF PG_DEBUG in ('Y', 'C') THEN
4291: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error occured in procedure Item_Alloc_Avail_Pf_Dtls');
4292: END IF;
4293: RAISE FND_API.G_EXC_ERROR;

Line 4293: RAISE FND_API.G_EXC_ERROR;

4289: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4290: IF PG_DEBUG in ('Y', 'C') THEN
4291: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error occured in procedure Item_Alloc_Avail_Pf_Dtls');
4292: END IF;
4293: RAISE FND_API.G_EXC_ERROR;
4294: END IF;
4295: END IF;
4296:
4297: -- for period ATP

Line 4315: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

4311: ELSE
4312: MSC_AATP_PROC.get_unalloc_data_from_SD_temp(x_atp_period, l_unallocated_atp, l_return_status);
4313: END IF;
4314:
4315: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4316: IF PG_DEBUG in ('Y', 'C') THEN
4317: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error in call to get_unalloc_data_from_SD_temp');
4318: END IF;
4319: END IF;

Line 4342: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4338: l_return_status,
4339: x_atp_period.Period_Start_Date,
4340: MSC_ATP_PF.Bw_Fw_Cum, --b/w, f/w consumption and accumulation
4341: p_atf_date);
4342: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4343: IF PG_DEBUG in ('Y', 'C') THEN
4344: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error occured in procedure Pf_Atp_Consume');
4345: END IF;
4346: RAISE FND_API.G_EXC_ERROR;

Line 4346: RAISE FND_API.G_EXC_ERROR;

4342: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4343: IF PG_DEBUG in ('Y', 'C') THEN
4344: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error occured in procedure Pf_Atp_Consume');
4345: END IF;
4346: RAISE FND_API.G_EXC_ERROR;
4347: END IF;
4348: ELSE
4349: MSC_ATP_PROC.Atp_Consume(l_unallocated_atp.atp_qty, l_unallocated_atp.atp_qty.COUNT);
4350: END IF;

Line 4366: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4362: ELSE
4363: -- time_phased_atp
4364: IF l_time_phased_atp='Y' THEN
4365: MSC_ATP_PF.Get_Period_Data_From_Sd_Temp(x_atp_period, l_return_status);
4366: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4367: IF PG_DEBUG in ('Y', 'C') THEN
4368: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error occured in procedure Get_Period_Data_From_Sd_Temp');
4369: END IF;
4370: RAISE FND_API.G_EXC_ERROR;

Line 4370: RAISE FND_API.G_EXC_ERROR;

4366: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4367: IF PG_DEBUG in ('Y', 'C') THEN
4368: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error occured in procedure Get_Period_Data_From_Sd_Temp');
4369: END IF;
4370: RAISE FND_API.G_EXC_ERROR;
4371: END IF;
4372: ELSE
4373: /* time_phased_atp
4374: call new procedure to fix the issue of not displaying correct quantities in ATP SD Window when

Line 4377: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4373: /* time_phased_atp
4374: call new procedure to fix the issue of not displaying correct quantities in ATP SD Window when
4375: user opens ATP SD window from ATP pegging in allocated scenarios*/
4376: MSC_ATP_PROC.Get_Alloc_Data_From_Sd_Temp(x_atp_period, l_return_status);
4377: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4378: IF PG_DEBUG in ('Y', 'C') THEN
4379: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error occured in procedure get_alloc_data_from_SD_temp');
4380: END IF;
4381: RAISE FND_API.G_EXC_ERROR;

Line 4381: RAISE FND_API.G_EXC_ERROR;

4377: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4378: IF PG_DEBUG in ('Y', 'C') THEN
4379: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error occured in procedure get_alloc_data_from_SD_temp');
4380: END IF;
4381: RAISE FND_API.G_EXC_ERROR;
4382: END IF;
4383: END IF;
4384:
4385: IF PG_DEBUG in ('Y', 'C') THEN

Line 4420: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4416: l_return_status,
4417: l_current_atp.atp_period,
4418: MSC_ATP_PF.Backward, --b/w consumption
4419: p_atf_date);
4420: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4421: IF PG_DEBUG in ('Y', 'C') THEN
4422: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error occured in procedure Pf_Atp_Consume');
4423: END IF;
4424: RAISE FND_API.G_EXC_ERROR;

Line 4424: RAISE FND_API.G_EXC_ERROR;

4420: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4421: IF PG_DEBUG in ('Y', 'C') THEN
4422: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error occured in procedure Pf_Atp_Consume');
4423: END IF;
4424: RAISE FND_API.G_EXC_ERROR;
4425: END IF;
4426: ELSE
4427: MSC_ATP_PROC.Atp_Backward_Consume(l_current_atp.atp_qty);
4428: END IF;

Line 4812: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

4808: l_current_steal_atp);
4809: END IF;
4810:
4811: MSC_AATP_PROC.Add_to_Current_Atp(l_current_steal_atp, l_current_atp, l_return_status);
4812: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4813: IF PG_DEBUG in ('Y', 'C') THEN
4814: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error in call to Add_to_Current_Atp');
4815: END IF;
4816: END IF;

Line 4824: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

4820: l_current_atp);
4821: END IF;
4822:
4823: MSC_AATP_PROC.Atp_Forward_Consume(l_current_atp.atp_period, p_atf_date, l_current_atp.atp_qty, l_return_status);
4824: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4825: IF PG_DEBUG in ('Y', 'C') THEN
4826: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error in call to Atp_Forward_Consume');
4827: END IF;
4828: END IF;

Line 4841: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

4837: after forward consumption. we will not show these negatives in atp_inquiry for
4838: Allocated ATP with User Defined %.*/
4839:
4840: MSC_AATP_PROC.Atp_Remove_Negatives(l_current_atp.atp_qty, l_return_status);
4841: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4842: IF PG_DEBUG in ('Y', 'C') THEN
4843: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error in call to Atp_Remove_Negatives');
4844: END IF;
4845: END IF;

Line 4858: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

4854: IF PG_DEBUG in ('Y', 'C') THEN
4855: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Method 2');
4856: END IF;
4857: MSC_AATP_PROC.Atp_remove_negatives(l_current_atp.atp_qty, l_return_status);
4858: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4859: IF PG_DEBUG in ('Y', 'C') THEN
4860: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error in call to Atp_remove_negatives');
4861: END IF;
4862: END IF;

Line 4932: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

4928: l_current_atp);
4929: END IF;
4930:
4931: MSC_AATP_PROC.Atp_Forward_Consume(l_current_atp.atp_period, p_atf_date, l_current_atp.atp_qty, l_return_status);
4932: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4933: IF PG_DEBUG in ('Y', 'C') THEN
4934: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error in call to Atp_Forward_Consume');
4935: END IF;
4936: END IF;

Line 4949: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

4945: after forward consumption. we will not show these negatives in atp_inquiry for
4946: Allocated ATP with User Defined %.*/
4947:
4948: MSC_AATP_PROC.Atp_Remove_Negatives(l_current_atp.atp_qty, l_return_status);
4949: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4950: IF PG_DEBUG in ('Y', 'C') THEN
4951: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error in call to Atp_Remove_Negatives');
4952: END IF;
4953: END IF;

Line 4999: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

4995: Print_Period_Qty('l_class_next_steal_atp.atp_period:atp_qty = ',
4996: l_class_next_steal_atp);
4997: END IF;
4998: MSC_AATP_PROC.Add_to_Current_Atp(l_class_next_steal_atp, l_current_atp, l_return_status);
4999: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5000: IF PG_DEBUG in ('Y', 'C') THEN
5001: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error in call to Add_to_Current_Atp');
5002: END IF;
5003: END IF;

Line 5014: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5010: Print_Period_Qty('l_class_next_steal_atp.atp_period:atp_qty = ',
5011: l_class_next_steal_atp);
5012: END IF;
5013: MSC_AATP_PROC.Atp_Forward_Consume(l_current_atp.atp_period, p_atf_date, l_current_atp.atp_qty, l_return_status);
5014: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5015: IF PG_DEBUG in ('Y', 'C') THEN
5016: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error in call to Atp_Forward_Consume');
5017: END IF;
5018: END IF;

Line 5031: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5027: after forward consumption. we will not show these negatives in atp_inquiry for
5028: Allocated ATP with User Defined %.*/
5029:
5030: MSC_AATP_PROC.Atp_Remove_Negatives(l_current_atp.atp_qty, l_return_status);
5031: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5032: IF PG_DEBUG in ('Y', 'C') THEN
5033: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error in call to Atp_Remove_Negatives');
5034: END IF;
5035: END IF;

Line 5049: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5045: IF PG_DEBUG in ('Y', 'C') THEN
5046: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Method 2');
5047: END IF;
5048: MSC_AATP_PROC.Atp_remove_negatives(l_current_atp.atp_qty, l_return_status);
5049: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5050: IF PG_DEBUG in ('Y', 'C') THEN
5051: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error in call to Atp_remove_negatives');
5052: END IF;
5053: END IF;

Line 5257: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5253: Print_Period_Qty('l_next_steal_atp.atp_period:atp_qty = ',
5254: l_next_steal_atp);
5255: END IF;
5256: MSC_AATP_PROC.Add_to_Current_Atp(l_next_steal_atp, l_current_atp, l_return_status);
5257: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5258: IF PG_DEBUG in ('Y', 'C') THEN
5259: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error in call to Add_to_Current_Atp');
5260: END IF;
5261: END IF;

Line 5284: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5280: Print_Period_Qty('l_partner_next_steal_atp.atp_period:atp_qty = ',
5281: l_partner_next_steal_atp);
5282: END IF;
5283: MSC_AATP_PROC.Add_to_Current_Atp(l_partner_next_steal_atp, l_current_atp, l_return_status);
5284: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5285: IF PG_DEBUG in ('Y', 'C') THEN
5286: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error in call to Add_to_Current_Atp');
5287: END IF;
5288: END IF;

Line 5304: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5300: Print_Period_Qty('l_current_atp.atp_period:atp_qty = ',
5301: l_current_atp);
5302: END IF;
5303: MSC_AATP_PROC.Atp_Forward_Consume(l_current_atp.atp_period, p_atf_date, l_current_atp.atp_qty, l_return_status);
5304: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5305: IF PG_DEBUG in ('Y', 'C') THEN
5306: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error in call to Atp_Forward_Consume');
5307: END IF;
5308: END IF;

Line 5320: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5316: after forward consumption. we will not show these negatives in atp_inquiry for
5317: Allocated ATP with User Defined %.*/
5318:
5319: MSC_AATP_PROC.Atp_Remove_Negatives(l_current_atp.atp_qty, l_return_status);
5320: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5321: IF PG_DEBUG in ('Y', 'C') THEN
5322: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error in call to Atp_Remove_Negatives');
5323: END IF;
5324: END IF;

Line 5353: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5349: l_current_atp);
5350: END IF;
5351:
5352: MSC_AATP_PROC.Atp_Adjusted_Cum(l_current_atp, l_unallocated_atp, l_return_status);
5353: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5354: IF PG_DEBUG in ('Y', 'C') THEN
5355: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'Error in call to Atp_Forward_Consume');
5356: END IF;
5357: END IF;

Line 5648: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5644: MSC_AATP_PVT.Get_DC_Info(p_instance_id, null, p_organization_id,
5645: p_department_id, p_resource_id, p_demand_class,
5646: p_request_date, l_level_id, l_priority, l_allocation_percent, l_return_status);
5647:
5648: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5649: IF PG_DEBUG in ('Y', 'C') THEN
5650: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'Error retrieving Priority and Demand Class');
5651: END IF;
5652: END IF;

Line 5833: RAISE FND_API.G_EXC_ERROR;

5829:
5830: IF (l_sys_next_date is NULL) THEN
5831: msc_sch_wb.atp_debug('Sys Next Date is null');
5832: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.NO_MATCHING_CAL_DATE;
5833: RAISE FND_API.G_EXC_ERROR;
5834: END IF;
5835: --bug3333114 end
5836:
5837: IF PG_DEBUG in ('Y', 'C') THEN

Line 8718: RAISE FND_API.G_EXC_ERROR;

8714:
8715: IF (l_sys_next_date is NULL) THEN
8716: msc_sch_wb.atp_debug('Sys Next Date is null');
8717: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.NO_MATCHING_CAL_DATE;
8718: RAISE FND_API.G_EXC_ERROR;
8719: END IF;
8720: --bug3333114 end
8721:
8722: IF PG_DEBUG in ('Y', 'C') THEN

Line 10074: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

10070: x_atp_info := l_current_atp;
10071:
10072: --4055719 , calling remove -ves
10073: MSC_AATP_PROC.Atp_Remove_Negatives(x_atp_period.Cumulative_Quantity, l_return_status);
10074: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10075: IF PG_DEBUG in ('Y', 'C') THEN
10076: msc_sch_wb.atp_debug('Supplier_Alloc_Cum_Atp: ' || 'Error occured in procedure Atp_Remove_Negatives');
10077: END IF;
10078: RAISE FND_API.G_EXC_ERROR;

Line 10078: RAISE FND_API.G_EXC_ERROR;

10074: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10075: IF PG_DEBUG in ('Y', 'C') THEN
10076: msc_sch_wb.atp_debug('Supplier_Alloc_Cum_Atp: ' || 'Error occured in procedure Atp_Remove_Negatives');
10077: END IF;
10078: RAISE FND_API.G_EXC_ERROR;
10079: END IF;
10080:
10081: --4055719 , moved this code to MSC_ATP_REQ.get_supplier_atp_info
10082: -- get the infinite time fence date if it exists

Line 10165: x_return_status := FND_API.G_RET_STS_SUCCESS;

10161: msc_sch_wb.atp_debug('Get_DC_Info: ' || 'p_request_date =' || p_request_date );
10162: END IF;
10163:
10164: -- initialize API return status to success
10165: x_return_status := FND_API.G_RET_STS_SUCCESS;
10166:
10167: IF p_inv_item_id is not null THEN
10168: -- Get the allocation percent for the item/demand class. If no rule found,
10169: -- check if a rule on the specified date exists for any demand class

Line 10319: x_return_status := FND_API.G_RET_STS_ERROR;

10315: msc_sch_wb.atp_debug('Get_DC_Info: ' || 'Error code:' || to_char(sqlcode));
10316: END IF;
10317: x_priority := -1;
10318: x_alloc_percent := 0;
10319: x_return_status := FND_API.G_RET_STS_ERROR;
10320: END Get_DC_Info;
10321:
10322: PROCEDURE View_Allocation(
10323: p_session_id IN NUMBER,

Line 10410: RAISE FND_API.G_EXC_ERROR;

10406: IF PG_DEBUG in ('Y', 'C') THEN
10407: msc_sch_wb.atp_debug('View_Allocation: ' || 'Request date is null');
10408: END IF;
10409: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.NO_MATCHING_CAL_DATE;
10410: RAISE FND_API.G_EXC_ERROR;
10411: END IF;
10412:
10413: --Check if the request is for Item or Department-Resource.
10414: IF p_inventory_item_id IS NOT NULL THEN

Line 10447: RAISE FND_API.G_EXC_ERROR;

10443: IF PG_DEBUG in ('Y', 'C') THEN
10444: msc_sch_wb.atp_debug ('View_Allocation: ' || 'Plan_ID is null or -1');
10445: END IF;
10446: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.PLAN_NOT_FOUND;
10447: RAISE FND_API.G_EXC_ERROR;
10448: END IF;
10449:
10450: IF (l_plan_id = -100) THEN
10451: IF PG_DEBUG in ('Y', 'C') THEN

Line 10455: RAISE FND_API.G_EXC_ERROR;

10451: IF PG_DEBUG in ('Y', 'C') THEN
10452: msc_sch_wb.atp_debug ('View_Allocation: ' || 'Plan_ID is -100 : Summary Running');
10453: END IF;
10454: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.SUMM_CONC_PROG_RUNNING;
10455: RAISE FND_API.G_EXC_ERROR;
10456: END IF;
10457:
10458: IF (l_plan_id = -200) THEN
10459: IF PG_DEBUG in ('Y', 'C') THEN

Line 10463: RAISE FND_API.G_EXC_ERROR;

10459: IF PG_DEBUG in ('Y', 'C') THEN
10460: msc_sch_wb.atp_debug ('View_Allocation: ' || 'Plan_ID is -200 : Summary Running');
10461: END IF;
10462: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.RUN_POST_PLAN_ALLOC;
10463: RAISE FND_API.G_EXC_ERROR;
10464: END IF;
10465:
10466:
10467:

Line 10666: RAISE FND_API.G_EXC_ERROR;

10662: IF PG_DEBUG in ('Y', 'C') THEN
10663: msc_sch_wb.atp_debug('View_Allocation: ' || 'Plan not found ');
10664: END IF;
10665: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.PLAN_NOT_FOUND;
10666: RAISE FND_API.G_EXC_ERROR;
10667: WHEN others THEN
10668: IF PG_DEBUG in ('Y', 'C') THEN
10669: msc_sch_wb.atp_debug('View_Allocation: ' || 'Error getting plan id :'||sqlcode);
10670: END IF;

Line 10672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

10668: IF PG_DEBUG in ('Y', 'C') THEN
10669: msc_sch_wb.atp_debug('View_Allocation: ' || 'Error getting plan id :'||sqlcode);
10670: END IF;
10671: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.ATP_PROCESSING_ERROR;
10672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10673: END;
10674:
10675: IF PG_DEBUG in ('Y', 'C') THEN
10676: msc_sch_wb.atp_debug('View_Allocation: ' || 'Plan Id : '||to_char(l_plan_id));

Line 10808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

10804: IF PG_DEBUG in ('Y', 'C') THEN
10805: msc_sch_wb.atp_debug ('View_Allocation: ' || 'l_atp_period is NULL');
10806: msc_sch_wb.atp_debug ('View_Allocation: ' || 'Error Code: ' || MSC_SCH_WB.G_ATP_ERROR_CODE);
10807: END IF;
10808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10809: END IF;
10810:
10811: IF PG_DEBUG in ('Y', 'C') THEN
10812: mm := l_atp_period.Period_Quantity.FIRST;

Line 10840: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

10836: x_return_status,
10837: l_msg_data,
10838: l_msg_count);
10839:
10840: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10841: IF PG_DEBUG in ('Y', 'C') THEN
10842: msc_sch_wb.atp_debug ('View_Allocation: ' || 'Something wrong in call to PUT_INTO_TEMP_TABLE');
10843: END IF;
10844: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.ATP_PROCESSING_ERROR;

Line 10845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

10841: IF PG_DEBUG in ('Y', 'C') THEN
10842: msc_sch_wb.atp_debug ('View_Allocation: ' || 'Something wrong in call to PUT_INTO_TEMP_TABLE');
10843: END IF;
10844: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.ATP_PROCESSING_ERROR;
10845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10846: END IF;*/
10847:
10848: -- rajjain 01/29/2003 begin Bug 2737596
10849: IF PG_DEBUG in ('Y', 'C') THEN

Line 10873: WHEN FND_API.G_EXC_ERROR THEN

10869:
10870: -- krajan : 2400614
10871: EXCEPTION
10872:
10873: WHEN FND_API.G_EXC_ERROR THEN
10874: -- ATP ERROR CODE WILL BE SET before this exception is raised
10875: IF PG_DEBUG in ('Y', 'C') THEN
10876: msc_sch_wb.atp_debug ('Error in View_Allocation: Expected Error Raised');
10877: END IF;

Line 10878: x_return_status := FND_API.G_RET_STS_ERROR;

10874: -- ATP ERROR CODE WILL BE SET before this exception is raised
10875: IF PG_DEBUG in ('Y', 'C') THEN
10876: msc_sch_wb.atp_debug ('Error in View_Allocation: Expected Error Raised');
10877: END IF;
10878: x_return_status := FND_API.G_RET_STS_ERROR;
10879: IF (MSC_SCH_WB.G_ATP_ERROR_CODE = 0) THEN
10880: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.ATP_PROCESSING_ERROR;
10881: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10882: END IF;

Line 10881: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

10877: END IF;
10878: x_return_status := FND_API.G_RET_STS_ERROR;
10879: IF (MSC_SCH_WB.G_ATP_ERROR_CODE = 0) THEN
10880: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.ATP_PROCESSING_ERROR;
10881: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10882: END IF;
10883:
10884: WHEN MSC_ATP_PUB.ATP_INVALID_OBJECTS_FOUND THEN
10885: IF PG_DEBUG in ('Y', 'C') THEN

Line 10889: x_return_status := FND_API.G_RET_STS_ERROR;

10885: IF PG_DEBUG in ('Y', 'C') THEN
10886: msc_sch_wb.atp_debug ('Error in View_Allocation: Invalid Objects Found');
10887: END IF;
10888: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.ATP_INVALID_OBJECTS;
10889: x_return_status := FND_API.G_RET_STS_ERROR;
10890:
10891: WHEN OTHERS THEN
10892: IF PG_DEBUG in ('Y', 'C') THEN
10893: msc_sch_wb.atp_debug ('Error in View_Allocation');

Line 10895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

10891: WHEN OTHERS THEN
10892: IF PG_DEBUG in ('Y', 'C') THEN
10893: msc_sch_wb.atp_debug ('Error in View_Allocation');
10894: END IF;
10895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10896: IF (MSC_SCH_WB.G_ATP_ERROR_CODE = 0) THEN
10897: MSC_SCH_WB.G_ATP_ERROR_CODE := MSC_ATP_PVT.ATP_PROCESSING_ERROR;
10898: END IF;
10899:

Line 11352: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

11348: p_atp_record.demand_source_type,--cmro
11349: --bug3684383
11350: p_atp_record.order_number,
11351: l_return_status);
11352: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11353: IF PG_DEBUG in ('Y', 'C') THEN
11354: msc_sch_wb.atp_debug('Stealing: ' || 'Error occured in procedure Add_PF_Stealing_Supply_Details');
11355: END IF;
11356: RAISE FND_API.G_EXC_ERROR;

Line 11356: RAISE FND_API.G_EXC_ERROR;

11352: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11353: IF PG_DEBUG in ('Y', 'C') THEN
11354: msc_sch_wb.atp_debug('Stealing: ' || 'Error occured in procedure Add_PF_Stealing_Supply_Details');
11355: END IF;
11356: RAISE FND_API.G_EXC_ERROR;
11357: END IF;
11358: END IF;
11359: -- time_phased_atp changes end
11360: