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

Line 237: x_return_status := FND_API.G_RET_STS_SUCCESS;

233: msc_sch_wb.atp_debug('Add_PF_Bucketed_Demands: ' || 'demand_source_type = ' ||p_atp_rec.demand_source_type);--cmro
234: END IF;
235:
236: -- Initializing API return code
237: x_return_status := FND_API.G_RET_STS_SUCCESS;
238:
239: l_req_date := p_atp_rec.requested_ship_date;
240: l_atf_date := p_atp_rec.atf_date;
241: l_req_qty := nvl(p_atp_rec.quantity_ordered, 0);

Line 265: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

261: l_bucketed_demands_rec,
262: l_return_status
263: );
264:
265: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
266: IF PG_DEBUG in ('Y', 'C') THEN
267: msc_sch_wb.atp_debug('Add_PF_Bucketed_Demands: ' || 'Error occured in procedure Calc_Bucketed_Demands_Info');
268: END IF;
269: x_return_status := FND_API.G_RET_STS_ERROR;

Line 269: x_return_status := FND_API.G_RET_STS_ERROR;

265: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
266: IF PG_DEBUG in ('Y', 'C') THEN
267: msc_sch_wb.atp_debug('Add_PF_Bucketed_Demands: ' || 'Error occured in procedure Calc_Bucketed_Demands_Info');
268: END IF;
269: x_return_status := FND_API.G_RET_STS_ERROR;
270: return;
271: END IF;
272:
273: IF l_bucketed_demands_rec.insert_mem_bd = 'Y' and l_bucketed_demands_rec.mem_bd_qty > 0 THEN

Line 285: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

281: member, -- member item bd
282: p_refresh_number,
283: l_return_status
284: );
285: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
286: IF PG_DEBUG in ('Y', 'C') THEN
287: msc_sch_wb.atp_debug('Add_PF_Bucketed_Demands: ' || 'Error occured in procedure Insert_Bucketed_Demand');
288: END IF;
289: x_return_status := FND_API.G_RET_STS_ERROR;

Line 289: x_return_status := FND_API.G_RET_STS_ERROR;

285: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
286: IF PG_DEBUG in ('Y', 'C') THEN
287: msc_sch_wb.atp_debug('Add_PF_Bucketed_Demands: ' || 'Error occured in procedure Insert_Bucketed_Demand');
288: END IF;
289: x_return_status := FND_API.G_RET_STS_ERROR;
290: return;
291: END IF;
292: END IF;
293:

Line 306: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

302: family, -- family item bd
303: p_refresh_number,
304: l_return_status
305: );
306: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
307: IF PG_DEBUG in ('Y', 'C') THEN
308: msc_sch_wb.atp_debug('Add_PF_Bucketed_Demands: ' || 'Error occured in procedure Insert_Bucketed_Demand');
309: END IF;
310: x_return_status := FND_API.G_RET_STS_ERROR;

Line 310: x_return_status := FND_API.G_RET_STS_ERROR;

306: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
307: IF PG_DEBUG in ('Y', 'C') THEN
308: msc_sch_wb.atp_debug('Add_PF_Bucketed_Demands: ' || 'Error occured in procedure Insert_Bucketed_Demand');
309: END IF;
310: x_return_status := FND_API.G_RET_STS_ERROR;
311: return;
312: END IF;
313: END IF;
314:

Line 324: x_return_status := FND_API.G_RET_STS_ERROR;

320: WHEN OTHERS THEN
321: IF PG_DEBUG in ('Y', 'C') THEN
322: msc_sch_wb.atp_debug('Add_PF_Bucketed_Demands: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
323: END IF;
324: x_return_status := FND_API.G_RET_STS_ERROR;
325:
326: END Add_PF_Bucketed_Demands;
327:
328: /*--Calc_Bucketed_Demands_Info----------------------------------------------

Line 353: x_return_status := FND_API.G_RET_STS_SUCCESS;

349: msc_sch_wb.atp_debug('Calc_Bucketed_Demands_Info: ' || 'ATF Date Qty = ' ||to_char(p_atf_date_qty));
350: END IF;
351:
352: -- Initializing API return code
353: x_return_status := FND_API.G_RET_STS_SUCCESS;
354:
355: IF p_req_date <= p_atf_date THEN
356: IF (p_req_date_qty >= p_req_qty) OR (p_atf_date_qty >= p_req_qty) THEN
357: /* Request is satisfied using member item's supply within ATF.

Line 451: x_return_status := FND_API.G_RET_STS_ERROR;

447: WHEN OTHERS THEN
448: IF PG_DEBUG in ('Y', 'C') THEN
449: msc_sch_wb.atp_debug('Calc_Bucketed_Demands_Info: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
450: END IF;
451: x_return_status := FND_API.G_RET_STS_ERROR;
452:
453: END Calc_Bucketed_Demands_Info;
454:
455: /*--Update_PF_Bucketed_Demands----------------------------------------------

Line 486: x_return_status := FND_API.G_RET_STS_SUCCESS;

482: msc_sch_wb.atp_debug('Update_PF_Bucketed_Demands: ' || 'p_new_demand_date_qty = ' ||to_char(p_new_demand_date_qty));
483: END IF;
484:
485: -- Initializing API return code
486: x_return_status := FND_API.G_RET_STS_SUCCESS;
487:
488: IF p_demand_date <= p_atf_date THEN
489: l_update_mem_bd := 'Y';
490: l_mem_bd_qty := p_new_demand_date_qty;

Line 550: x_return_status := FND_API.G_RET_STS_ERROR;

546: WHEN OTHERS THEN
547: IF PG_DEBUG in ('Y', 'C') THEN
548: msc_sch_wb.atp_debug('Update_PF_Bucketed_Demands: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
549: END IF;
550: x_return_status := FND_API.G_RET_STS_ERROR;
551:
552: END Update_PF_Bucketed_Demands;
553:
554: /*--Increment_Bucketed_Demands_Qty------------------------------------------

Line 586: x_return_status := FND_API.G_RET_STS_SUCCESS;

582: msc_sch_wb.atp_debug('Increment_Bucketed_Demands_Qty: ' || 'p_parent_demand_id = ' ||to_char(p_parent_demand_id));
583: END IF;
584:
585: -- Initializing API return code
586: x_return_status := FND_API.G_RET_STS_SUCCESS;
587:
588: l_req_date := p_atp_rec.requested_ship_date;
589: l_atf_date := p_atp_rec.atf_date;
590: l_req_qty := nvl(p_atp_rec.quantity_ordered, 0);

Line 614: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

610: l_bucketed_demands_rec,
611: l_return_status
612: );
613:
614: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
615: IF PG_DEBUG in ('Y', 'C') THEN
616: msc_sch_wb.atp_debug('Increment_Bucketed_Demands_Qty: ' || 'Error occured in procedure Calc_Bucketed_Demands_Info');
617: END IF;
618: x_return_status := FND_API.G_RET_STS_ERROR;

Line 618: x_return_status := FND_API.G_RET_STS_ERROR;

614: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
615: IF PG_DEBUG in ('Y', 'C') THEN
616: msc_sch_wb.atp_debug('Increment_Bucketed_Demands_Qty: ' || 'Error occured in procedure Calc_Bucketed_Demands_Info');
617: END IF;
618: x_return_status := FND_API.G_RET_STS_ERROR;
619: return;
620: END IF;
621:
622: IF nvl(l_bucketed_demands_rec.mem_bd_qty, 0) = 0 THEN

Line 657: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

653: member, -- member item bd
654: p_atp_rec.refresh_number,
655: l_return_status
656: );
657: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
658: IF PG_DEBUG in ('Y', 'C') THEN
659: msc_sch_wb.atp_debug('Increment_Bucketed_Demands_Qty: ' || 'Error occured in procedure Insert_Bucketed_Demand');
660: END IF;
661: x_return_status := FND_API.G_RET_STS_ERROR;

Line 661: x_return_status := FND_API.G_RET_STS_ERROR;

657: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
658: IF PG_DEBUG in ('Y', 'C') THEN
659: msc_sch_wb.atp_debug('Increment_Bucketed_Demands_Qty: ' || 'Error occured in procedure Insert_Bucketed_Demand');
660: END IF;
661: x_return_status := FND_API.G_RET_STS_ERROR;
662: return;
663: END IF;
664: END IF;
665: END IF;

Line 702: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

698: family, -- family item bd
699: p_atp_rec.refresh_number,
700: l_return_status
701: );
702: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
703: IF PG_DEBUG in ('Y', 'C') THEN
704: msc_sch_wb.atp_debug('Increment_Bucketed_Demands_Qty: ' || 'Error occured in procedure Insert_Bucketed_Demand');
705: END IF;
706: x_return_status := FND_API.G_RET_STS_ERROR;

Line 706: x_return_status := FND_API.G_RET_STS_ERROR;

702: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
703: IF PG_DEBUG in ('Y', 'C') THEN
704: msc_sch_wb.atp_debug('Increment_Bucketed_Demands_Qty: ' || 'Error occured in procedure Insert_Bucketed_Demand');
705: END IF;
706: x_return_status := FND_API.G_RET_STS_ERROR;
707: return;
708: END IF;
709: END IF;
710: END IF;

Line 721: x_return_status := FND_API.G_RET_STS_ERROR;

717: WHEN OTHERS THEN
718: IF PG_DEBUG in ('Y', 'C') THEN
719: msc_sch_wb.atp_debug('Increment_Bucketed_Demands_Qty: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
720: END IF;
721: x_return_status := FND_API.G_RET_STS_ERROR;
722:
723: END Increment_Bucketed_Demands_Qty;
724:
725: /*--Move_PF_Bucketed_Demands------------------------------------------------

Line 771: x_return_status := FND_API.G_RET_STS_SUCCESS;

767: msc_sch_wb.atp_debug('Move_PF_Bucketed_Demands: ' || 'p_atf_date_qty = ' ||to_char(p_atf_date_qty));
768: END IF;
769:
770: -- Initializing API return code
771: x_return_status := FND_API.G_RET_STS_SUCCESS;
772:
773: --bug3555084 start
774: IF p_parent_demand_id is not null THEN
775: IF upper(p_atp_rec.override_flag) = 'Y' THEN

Line 921: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

917: member, -- member item bd
918: l_atp_rec.refresh_number,
919: l_return_status
920: );
921: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
922: IF PG_DEBUG in ('Y', 'C') THEN
923: msc_sch_wb.atp_debug('Move_PF_Bucketed_Demands: ' || 'Error occured in procedure Insert_Bucketed_Demand');
924: END IF;
925: x_return_status := FND_API.G_RET_STS_ERROR;

Line 925: x_return_status := FND_API.G_RET_STS_ERROR;

921: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
922: IF PG_DEBUG in ('Y', 'C') THEN
923: msc_sch_wb.atp_debug('Move_PF_Bucketed_Demands: ' || 'Error occured in procedure Insert_Bucketed_Demand');
924: END IF;
925: x_return_status := FND_API.G_RET_STS_ERROR;
926: return;
927: END IF;
928: END IF;
929: END IF;

Line 962: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

958: family, -- family item bd
959: l_atp_rec.refresh_number,
960: l_return_status
961: );
962: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
963: IF PG_DEBUG in ('Y', 'C') THEN
964: msc_sch_wb.atp_debug('Move_PF_Bucketed_Demands: ' || 'Error occured in procedure Insert_Bucketed_Demand');
965: END IF;
966: x_return_status := FND_API.G_RET_STS_ERROR;

Line 966: x_return_status := FND_API.G_RET_STS_ERROR;

962: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
963: IF PG_DEBUG in ('Y', 'C') THEN
964: msc_sch_wb.atp_debug('Move_PF_Bucketed_Demands: ' || 'Error occured in procedure Insert_Bucketed_Demand');
965: END IF;
966: x_return_status := FND_API.G_RET_STS_ERROR;
967: return;
968: END IF;
969: END IF;
970: END IF;

Line 981: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

977: p_new_demand_date,
978: p_atf_date,
979: l_return_status
980: );
981: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
982: IF PG_DEBUG in ('Y', 'C') THEN
983: msc_sch_wb.atp_debug('Move_PF_Bucketed_Demands: ' || 'Error occured in procedure Move_PF_Bd_Dates');
984: END IF;
985: x_return_status := FND_API.G_RET_STS_ERROR;

Line 985: x_return_status := FND_API.G_RET_STS_ERROR;

981: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
982: IF PG_DEBUG in ('Y', 'C') THEN
983: msc_sch_wb.atp_debug('Move_PF_Bucketed_Demands: ' || 'Error occured in procedure Move_PF_Bd_Dates');
984: END IF;
985: x_return_status := FND_API.G_RET_STS_ERROR;
986: return;
987: END IF;
988: ELSE
989: l_demand_qty := p_demand_qty - nvl(p_bkwd_pass_atf_date_qty,0); --bug3397904

Line 1084: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1080: member, -- member item bd
1081: l_atp_rec.refresh_number,
1082: l_return_status
1083: );
1084: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1085: IF PG_DEBUG in ('Y', 'C') THEN
1086: msc_sch_wb.atp_debug('Move_PF_Bucketed_Demands: ' || 'Error occured in procedure Insert_Bucketed_Demand');
1087: END IF;
1088: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1088: x_return_status := FND_API.G_RET_STS_ERROR;

1084: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1085: IF PG_DEBUG in ('Y', 'C') THEN
1086: msc_sch_wb.atp_debug('Move_PF_Bucketed_Demands: ' || 'Error occured in procedure Insert_Bucketed_Demand');
1087: END IF;
1088: x_return_status := FND_API.G_RET_STS_ERROR;
1089: return;
1090: END IF;
1091: END IF;
1092: ELSIF l_update_mem_bd = 'D' THEN

Line 1131: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1127: family, -- family item bd
1128: l_atp_rec.refresh_number,
1129: l_return_status
1130: );
1131: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1132: IF PG_DEBUG in ('Y', 'C') THEN
1133: msc_sch_wb.atp_debug('Move_PF_Bucketed_Demands: ' || 'Error occured in procedure Insert_Bucketed_Demand');
1134: END IF;
1135: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1135: x_return_status := FND_API.G_RET_STS_ERROR;

1131: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1132: IF PG_DEBUG in ('Y', 'C') THEN
1133: msc_sch_wb.atp_debug('Move_PF_Bucketed_Demands: ' || 'Error occured in procedure Insert_Bucketed_Demand');
1134: END IF;
1135: x_return_status := FND_API.G_RET_STS_ERROR;
1136: return;
1137: END IF;
1138: END IF;
1139: END IF;

Line 1151: x_return_status := FND_API.G_RET_STS_ERROR;

1147: WHEN OTHERS THEN
1148: IF PG_DEBUG in ('Y', 'C') THEN
1149: msc_sch_wb.atp_debug('Move_PF_Bucketed_Demands: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
1150: END IF;
1151: x_return_status := FND_API.G_RET_STS_ERROR;
1152:
1153: END Move_PF_Bucketed_Demands;
1154:
1155: /*--Move_PF_Bd_Dates--------------------------------------------------------

Line 1174: x_return_status := FND_API.G_RET_STS_SUCCESS;

1170: msc_sch_wb.atp_debug('*********Begin procedure Move_PF_Bd_Dates ********');
1171: END IF;
1172:
1173: -- Initializing API return code
1174: x_return_status := FND_API.G_RET_STS_SUCCESS;
1175:
1176: IF (p_old_demand_date < p_atf_date) and (p_new_demand_date <= p_atf_date) THEN
1177: update msc_alloc_demands
1178: --bug3697365 added timestamp also

Line 1225: x_return_status := FND_API.G_RET_STS_ERROR;

1221: WHEN OTHERS THEN
1222: IF PG_DEBUG in ('Y', 'C') THEN
1223: msc_sch_wb.atp_debug('Move_PF_Bd_Dates: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
1224: END IF;
1225: x_return_status := FND_API.G_RET_STS_ERROR;
1226:
1227: END Move_PF_Bd_Dates;
1228:
1229: /*--Insert_Bucketed_Demand--------------------------------------------------

Line 1253: x_return_status := FND_API.G_RET_STS_SUCCESS;

1249: msc_sch_wb.atp_debug('*********Begin procedure Insert_Bucketed_Demand ********');
1250: END IF;
1251:
1252: -- Initializing API return code
1253: x_return_status := FND_API.G_RET_STS_SUCCESS;
1254:
1255: INSERT INTO MSC_ALLOC_DEMANDS(
1256: PLAN_ID,
1257: INVENTORY_ITEM_ID,

Line 1322: x_return_status := FND_API.G_RET_STS_ERROR;

1318: WHEN OTHERS THEN
1319: IF PG_DEBUG in ('Y', 'C') THEN
1320: msc_sch_wb.atp_debug('Insert_Bucketed_Demand: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
1321: END IF;
1322: x_return_status := FND_API.G_RET_STS_ERROR;
1323:
1324: END Insert_Bucketed_Demand;
1325:
1326: /*--Find_PF_Bucketed_Demands--------------------------------------------------

Line 1346: x_return_status := FND_API.G_RET_STS_SUCCESS;

1342: msc_sch_wb.atp_debug('Find_PF_Bucketed_Demands: ' || 'p_parent_demand_id = ' ||to_char(p_parent_demand_id));
1343: END IF;
1344:
1345: -- Initializing API return code
1346: x_return_status := FND_API.G_RET_STS_SUCCESS;
1347:
1348: BEGIN
1349: SELECT allocated_quantity,
1350: demand_date

Line 1395: x_return_status := FND_API.G_RET_STS_ERROR;

1391: WHEN OTHERS THEN
1392: IF PG_DEBUG in ('Y', 'C') THEN
1393: msc_sch_wb.atp_debug('Find_PF_Bucketed_Demands: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
1394: END IF;
1395: x_return_status := FND_API.G_RET_STS_ERROR;
1396:
1397: END Find_PF_Bucketed_Demands;
1398:
1399: /*--Add_PF_Rollup_Supplies--------------------------------------------------

Line 1428: x_return_status := FND_API.G_RET_STS_SUCCESS;

1424: msc_sch_wb.atp_debug('*********Begin procedure Add_PF_Rollup_Supplies ********');
1425: END IF;
1426:
1427: -- Initializing API return code
1428: x_return_status := FND_API.G_RET_STS_SUCCESS;
1429:
1430: IF p_schedule_date <= p_atf_date THEN
1431: INSERT INTO MSC_ALLOC_SUPPLIES(
1432: PLAN_ID,

Line 1543: x_return_status := FND_API.G_RET_STS_ERROR;

1539: WHEN OTHERS THEN
1540: IF PG_DEBUG in ('Y', 'C') THEN
1541: msc_sch_wb.atp_debug('Add_PF_Rollup_Supplies: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
1542: END IF;
1543: x_return_status := FND_API.G_RET_STS_ERROR;
1544:
1545: END Add_PF_Rollup_Supplies;
1546:
1547: /*--Update_PF_Rollup_Supplies----------------------------------------------

Line 1578: x_return_status := FND_API.G_RET_STS_SUCCESS;

1574: msc_sch_wb.atp_debug('Update_PF_Rollup_Supplies: ' || 'p_atf_date ='||to_char(p_atf_date));
1575: END IF;
1576:
1577: -- Initializing API return code
1578: x_return_status := FND_API.G_RET_STS_SUCCESS;
1579:
1580: IF p_date is NULL THEN
1581: UPDATE msc_alloc_supplies
1582: SET old_supply_date = supply_date, -- why do we populate old_supply_date and qty??

Line 1625: x_return_status := FND_API.G_RET_STS_ERROR;

1621: WHEN OTHERS THEN
1622: IF PG_DEBUG in ('Y', 'C') THEN
1623: msc_sch_wb.atp_debug('Update_PF_Rollup_Supplies: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
1624: END IF;
1625: x_return_status := FND_API.G_RET_STS_ERROR;
1626:
1627: END Update_PF_Rollup_Supplies;
1628:
1629: /*--Add_PF_Stealing_Supply_Details------------------------------------------

Line 1678: x_return_status := FND_API.G_RET_STS_SUCCESS;

1674: msc_sch_wb.atp_debug('Add_PF_Stealing_Supply_Details: ' || 'p_atf_date = ' ||to_char(p_atf_date));
1675: END IF;
1676:
1677: -- Initializing API return code
1678: x_return_status := FND_API.G_RET_STS_SUCCESS;
1679:
1680: IF (p_ship_date > p_atf_date) THEN
1681: l_mem_stealing_rec_date := p_atf_date;
1682: l_pf_stealing_rec_date := p_ship_date;

Line 1826: x_return_status := FND_API.G_RET_STS_ERROR;

1822: WHEN OTHERS THEN
1823: IF PG_DEBUG in ('Y', 'C') THEN
1824: msc_sch_wb.atp_debug('Add_PF_Stealing_Supply_Details: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
1825: END IF;
1826: x_return_status := FND_API.G_RET_STS_ERROR;
1827:
1828: END Add_PF_Stealing_Supply_Details;
1829:
1830: /*--Get_Mat_Avail_Pf--------------------------------------------------------

Line 1866: x_return_status := FND_API.G_RET_STS_SUCCESS;

1862: msc_sch_wb.atp_debug('Begin Get_Mat_Avail_Pf');
1863: END IF;
1864:
1865: -- Initializing API return code
1866: x_return_status := FND_API.G_RET_STS_SUCCESS;
1867:
1868: IF MSC_ATP_PVT.G_INV_CTP = 5 THEN
1869: -- ODS atp
1870: IF p_summary_flag = 'Y' THEN

Line 1885: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1881: x_atp_dates,
1882: x_atp_qtys,
1883: l_return_status
1884: );
1885: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1886: IF PG_DEBUG in ('Y', 'C') THEN
1887: msc_sch_wb.atp_debug('Get_Mat_Avail_Pf: ' || 'Error occured in procedure Get_Mat_Avail_Pf_Ods_Summ');
1888: END IF;
1889: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1889: x_return_status := FND_API.G_RET_STS_ERROR;

1885: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1886: IF PG_DEBUG in ('Y', 'C') THEN
1887: msc_sch_wb.atp_debug('Get_Mat_Avail_Pf: ' || 'Error occured in procedure Get_Mat_Avail_Pf_Ods_Summ');
1888: END IF;
1889: x_return_status := FND_API.G_RET_STS_ERROR;
1890: return;
1891: END IF;
1892: ELSE
1893: -- ODS atp

Line 1910: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1906: x_atp_dates,
1907: x_atp_qtys,
1908: l_return_status
1909: );
1910: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1911: IF PG_DEBUG in ('Y', 'C') THEN
1912: msc_sch_wb.atp_debug('Get_Mat_Avail_Pf: ' || 'Error occured in procedure Get_Mat_Avail_Pf_Ods');
1913: END IF;
1914: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1914: x_return_status := FND_API.G_RET_STS_ERROR;

1910: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1911: IF PG_DEBUG in ('Y', 'C') THEN
1912: msc_sch_wb.atp_debug('Get_Mat_Avail_Pf: ' || 'Error occured in procedure Get_Mat_Avail_Pf_Ods');
1913: END IF;
1914: x_return_status := FND_API.G_RET_STS_ERROR;
1915: return;
1916: END IF;
1917: END IF;
1918: ELSE

Line 1933: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1929: x_atp_dates,
1930: x_atp_qtys,
1931: l_return_status
1932: );
1933: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1934: IF PG_DEBUG in ('Y', 'C') THEN
1935: msc_sch_wb.atp_debug('Get_Mat_Avail_Pf: ' || 'Error occured in procedure Get_Mat_Avail_Pf_Pds_Summ');
1936: END IF;
1937: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1937: x_return_status := FND_API.G_RET_STS_ERROR;

1933: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1934: IF PG_DEBUG in ('Y', 'C') THEN
1935: msc_sch_wb.atp_debug('Get_Mat_Avail_Pf: ' || 'Error occured in procedure Get_Mat_Avail_Pf_Pds_Summ');
1936: END IF;
1937: x_return_status := FND_API.G_RET_STS_ERROR;
1938: return;
1939: END IF;
1940: ELSE
1941: Get_Mat_Avail_Pf_Pds(

Line 1952: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1948: x_atp_dates,
1949: x_atp_qtys,
1950: l_return_status
1951: );
1952: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1953: IF PG_DEBUG in ('Y', 'C') THEN
1954: msc_sch_wb.atp_debug('Get_Mat_Avail_Pf: ' || 'Error occured in procedure Get_Mat_Avail_Pf_Pds');
1955: END IF;
1956: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1956: x_return_status := FND_API.G_RET_STS_ERROR;

1952: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1953: IF PG_DEBUG in ('Y', 'C') THEN
1954: msc_sch_wb.atp_debug('Get_Mat_Avail_Pf: ' || 'Error occured in procedure Get_Mat_Avail_Pf_Pds');
1955: END IF;
1956: x_return_status := FND_API.G_RET_STS_ERROR;
1957: return;
1958: END IF;
1959: END IF; -- summary atp
1960: END IF; -- ODS/PDS

Line 1966: x_return_status := FND_API.G_RET_STS_ERROR;

1962: WHEN OTHERS THEN
1963: IF PG_DEBUG in ('Y', 'C') THEN
1964: msc_sch_wb.atp_debug('Get_Mat_Avail_Pf: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
1965: END IF;
1966: x_return_status := FND_API.G_RET_STS_ERROR;
1967:
1968: END Get_Mat_Avail_Pf;
1969:
1970: /*--Get_Mat_Avail_Pf_Dtls---------------------------------------------------

Line 2001: x_return_status := FND_API.G_RET_STS_SUCCESS;

1997: msc_sch_wb.atp_debug('Begin Get_Mat_Avail_Pf_Dtls');
1998: END IF;
1999:
2000: -- Initializing API return code
2001: x_return_status := FND_API.G_RET_STS_SUCCESS;
2002:
2003: IF MSC_ATP_PVT.G_INV_CTP = 5 THEN
2004: -- ODS atp
2005: Get_Mat_Avail_Pf_Ods_Dtls(

Line 2023: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2019: p_scenario_id,
2020: p_identifier,
2021: l_return_status
2022: );
2023: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2024: IF PG_DEBUG in ('Y', 'C') THEN
2025: msc_sch_wb.atp_debug('Get_Mat_Avail_Pf_Dtls: ' || 'Error occured in procedure Get_Mat_Avail_Pf_Ods_Dtls');
2026: END IF;
2027: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2027: x_return_status := FND_API.G_RET_STS_ERROR;

2023: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2024: IF PG_DEBUG in ('Y', 'C') THEN
2025: msc_sch_wb.atp_debug('Get_Mat_Avail_Pf_Dtls: ' || 'Error occured in procedure Get_Mat_Avail_Pf_Ods_Dtls');
2026: END IF;
2027: x_return_status := FND_API.G_RET_STS_ERROR;
2028: return;
2029: END IF;
2030: ELSE
2031: Get_Mat_Avail_Pf_Pds_Dtls(

Line 2043: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2039: p_scenario_id,
2040: p_identifier,
2041: l_return_status
2042: );
2043: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2044: IF PG_DEBUG in ('Y', 'C') THEN
2045: msc_sch_wb.atp_debug('Get_Mat_Avail_Pf_Dtls: ' || 'Error occured in procedure Get_Mat_Avail_Pf_Pds_Dtls');
2046: END IF;
2047: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2047: x_return_status := FND_API.G_RET_STS_ERROR;

2043: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2044: IF PG_DEBUG in ('Y', 'C') THEN
2045: msc_sch_wb.atp_debug('Get_Mat_Avail_Pf_Dtls: ' || 'Error occured in procedure Get_Mat_Avail_Pf_Pds_Dtls');
2046: END IF;
2047: x_return_status := FND_API.G_RET_STS_ERROR;
2048: return;
2049: END IF;
2050: END IF; -- ODS/PDS
2051: EXCEPTION

Line 2056: x_return_status := FND_API.G_RET_STS_ERROR;

2052: WHEN OTHERS THEN
2053: IF PG_DEBUG in ('Y', 'C') THEN
2054: msc_sch_wb.atp_debug('Get_Mat_Avail_Pf_Dtls: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
2055: END IF;
2056: x_return_status := FND_API.G_RET_STS_ERROR;
2057:
2058: END Get_Mat_Avail_Pf_Dtls;
2059:
2060: /*--Get_Mat_Avail_Pf_Ods_Summ-----------------------------------------------

Line 2083: x_return_status := FND_API.G_RET_STS_SUCCESS;

2079: msc_sch_wb.atp_debug('Begin Get_Mat_Avail_Pf_Ods_Summ');
2080: END IF;
2081:
2082: -- Initializing API return code
2083: x_return_status := FND_API.G_RET_STS_SUCCESS;
2084:
2085: -- in summary approach we store sales ordrers for requested item while
2086: -- demands and supplies are stored on PF level
2087: SELECT SD_DATE, sum(SD_QTY)

Line 2150: x_return_status := FND_API.G_RET_STS_ERROR;

2146: WHEN OTHERS THEN
2147: IF PG_DEBUG in ('Y', 'C') THEN
2148: msc_sch_wb.atp_debug('Get_Mat_Avail_Pf_Ods_Summ: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
2149: END IF;
2150: x_return_status := FND_API.G_RET_STS_ERROR;
2151:
2152: END Get_Mat_Avail_Pf_Ods_Summ;
2153:
2154: /*--Get_Mat_Avail_Pf_Ods----------------------------------------------------

Line 2182: x_return_status := FND_API.G_RET_STS_SUCCESS;

2178: msc_sch_wb.atp_debug('Begin Get_Mat_Avail_Pf_Ods');
2179: END IF;
2180:
2181: -- Initializing API return code
2182: x_return_status := FND_API.G_RET_STS_SUCCESS;
2183:
2184: -- SQL Query changes Begin 2640489
2185: SELECT SD_DATE, SUM(SD_QTY)
2186: BULK COLLECT INTO x_atp_dates, x_atp_qtys

Line 2409: x_return_status := FND_API.G_RET_STS_ERROR;

2405: WHEN OTHERS THEN
2406: IF PG_DEBUG in ('Y', 'C') THEN
2407: msc_sch_wb.atp_debug('Get_Mat_Avail_Pf_Ods: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
2408: END IF;
2409: x_return_status := FND_API.G_RET_STS_ERROR;
2410:
2411: END Get_Mat_Avail_Pf_Ods;
2412:
2413: /*--Get_Mat_Avail_Pf_Pds_Summ----------------------------------------------------

Line 2443: x_return_status := FND_API.G_RET_STS_SUCCESS;

2439: msc_sch_wb.atp_debug('Begin Get_Mat_Avail_Pf_Pds_Summ');
2440: END IF;
2441:
2442: -- Initializing API return code
2443: x_return_status := FND_API.G_RET_STS_SUCCESS;
2444:
2445: SELECT SD_DATE, SUM(SD_QTY)
2446: BULK COLLECT INTO x_atp_dates, x_atp_qtys
2447: FROM (

Line 2515: x_return_status := FND_API.G_RET_STS_ERROR;

2511: WHEN OTHERS THEN
2512: IF PG_DEBUG in ('Y', 'C') THEN
2513: msc_sch_wb.atp_debug('Get_Mat_Avail_Pf_Pds_Summ: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
2514: END IF;
2515: x_return_status := FND_API.G_RET_STS_ERROR;
2516:
2517: END Get_Mat_Avail_Pf_Pds_Summ;
2518:
2519: /*--Get_Mat_Avail_Pf_Pds---------------------------------------------------------

Line 2547: x_return_status := FND_API.G_RET_STS_SUCCESS;

2543: msc_sch_wb.atp_debug('Begin Get_Mat_Avail_Pf_Pds');
2544: END IF;
2545:
2546: -- Initializing API return code
2547: x_return_status := FND_API.G_RET_STS_SUCCESS;
2548:
2549: SELECT SD_DATE, SUM(SD_QTY)
2550: BULK COLLECT INTO x_atp_dates, x_atp_qtys
2551: FROM (

Line 2599: x_return_status := FND_API.G_RET_STS_ERROR;

2595: WHEN OTHERS THEN
2596: IF PG_DEBUG in ('Y', 'C') THEN
2597: msc_sch_wb.atp_debug('Get_Mat_Avail_Pf_Pds: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
2598: END IF;
2599: x_return_status := FND_API.G_RET_STS_ERROR;
2600:
2601: END Get_Mat_Avail_Pf_Pds;
2602:
2603: /*--Get_Mat_Avail_Pf_Ods_Dtls-----------------------------------------------

Line 2635: x_return_status := FND_API.G_RET_STS_SUCCESS;

2631: msc_sch_wb.atp_debug('Begin Get_Mat_Avail_Pf_Ods_Dtls');
2632: END IF;
2633:
2634: -- Initializing API return code
2635: x_return_status := FND_API.G_RET_STS_SUCCESS;
2636:
2637: INSERT INTO msc_atp_sd_details_temp (
2638: ATP_Level,
2639: Order_line_id,

Line 3039: x_return_status := FND_API.G_RET_STS_ERROR;

3035: WHEN OTHERS THEN
3036: IF PG_DEBUG in ('Y', 'C') THEN
3037: msc_sch_wb.atp_debug('Get_Mat_Avail_Pf_Ods_Dtls: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
3038: END IF;
3039: x_return_status := FND_API.G_RET_STS_ERROR;
3040:
3041: END Get_Mat_Avail_Pf_Ods_Dtls;
3042:
3043: /*--Get_Mat_Avail_Pf_Pds_Dtls-----------------------------------------------------------

Line 3081: x_return_status := FND_API.G_RET_STS_SUCCESS;

3077: msc_sch_wb.atp_debug('Begin Get_Mat_Avail_Pf_Pds_Dtls');
3078: END IF;
3079:
3080: -- Initializing API return code
3081: x_return_status := FND_API.G_RET_STS_SUCCESS;
3082:
3083: INSERT INTO msc_atp_sd_details_temp (
3084: ATP_Level,
3085: Order_line_id,

Line 3281: x_return_status := FND_API.G_RET_STS_ERROR;

3277: WHEN OTHERS THEN
3278: IF PG_DEBUG in ('Y', 'C') THEN
3279: msc_sch_wb.atp_debug('Get_Mat_Avail_Pf_Pds_Dtls: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
3280: END IF;
3281: x_return_status := FND_API.G_RET_STS_ERROR;
3282:
3283: END Get_Mat_Avail_Pf_Pds_Dtls;
3284:
3285: /*--Set_Alloc_Rule_Variables------------------------------------------------------

Line 3315: x_return_status := FND_API.G_RET_STS_SUCCESS;

3311: msc_sch_wb.atp_debug('Set_Alloc_Rule_Variables: G_HIERARCHY_PROFILE: ' || MSC_AATP_PVT.G_HIERARCHY_PROFILE);
3312: END IF;
3313:
3314: -- Initializing API return code
3315: x_return_status := FND_API.G_RET_STS_SUCCESS;
3316:
3317: IF MSC_ATP_PVT.G_ALLOCATION_METHOD = 1 THEN
3318: /* Demand priority allocated ATP
3319: Here we always use allocation rule from family inside/outside ATF

Line 3407: x_return_status := FND_API.G_RET_STS_ERROR;

3403: WHEN OTHERS THEN
3404: IF PG_DEBUG in ('Y', 'C') THEN
3405: msc_sch_wb.atp_debug('Set_Alloc_Rule_Variables: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
3406: END IF;
3407: x_return_status := FND_API.G_RET_STS_ERROR;
3408:
3409: END Set_Alloc_Rule_Variables;
3410:
3411: /*--Item_Alloc_Avail_Pf-----------------------------------------------------------

Line 3452: x_return_status := FND_API.G_RET_STS_SUCCESS;

3448: msc_sch_wb.atp_debug('Item_Alloc_Avail_Pf: p_level_id: ' || p_level_id);
3449: END IF;
3450:
3451: -- Initializing API return code
3452: x_return_status := FND_API.G_RET_STS_SUCCESS;
3453:
3454: SELECT SD_DATE,
3455: SUM(SD_QTY)
3456: BULK COLLECT INTO

Line 3877: x_return_status := FND_API.G_RET_STS_ERROR;

3873: WHEN OTHERS THEN
3874: IF PG_DEBUG in ('Y', 'C') THEN
3875: msc_sch_wb.atp_debug('Item_Alloc_Avail_Pf: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
3876: END IF;
3877: x_return_status := FND_API.G_RET_STS_ERROR;
3878:
3879: END Item_Alloc_Avail_Pf;
3880:
3881: /*--Item_Alloc_Avail_Pf_Unalloc------------------------------------------------

Line 3916: x_return_status := FND_API.G_RET_STS_SUCCESS;

3912: msc_sch_wb.atp_debug('Item_Alloc_Avail_Pf_Unalloc: p_level_id: ' || p_level_id);
3913: END IF;
3914:
3915: -- Initializing API return code
3916: x_return_status := FND_API.G_RET_STS_SUCCESS;
3917:
3918: SELECT SD_DATE,
3919: SUM(UNALLOC_SD_QTY),
3920: SUM(SD_QTY)

Line 4345: x_return_status := FND_API.G_RET_STS_ERROR;

4341: WHEN OTHERS THEN
4342: IF PG_DEBUG in ('Y', 'C') THEN
4343: msc_sch_wb.atp_debug('Item_Alloc_Avail_Pf_Unalloc: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
4344: END IF;
4345: x_return_status := FND_API.G_RET_STS_ERROR;
4346:
4347: END Item_Alloc_Avail_Pf_Unalloc;
4348:
4349: /*--Item_Alloc_Avail_Pf_Dtls-------------------------------------------------------------

Line 4406: x_return_status := FND_API.G_RET_STS_SUCCESS;

4402: msc_sch_wb.atp_debug('Item_Alloc_Avail_Pf_Dtls: p_uom_code: ' || p_uom_code);
4403: END IF;
4404:
4405: -- Initializing API return code
4406: x_return_status := FND_API.G_RET_STS_SUCCESS;
4407:
4408: INSERT INTO msc_atp_sd_details_temp (
4409: ATP_Level,
4410: Order_line_id,

Line 5316: x_return_status := FND_API.G_RET_STS_ERROR;

5312: WHEN OTHERS THEN
5313: IF PG_DEBUG in ('Y', 'C') THEN
5314: msc_sch_wb.atp_debug('Item_Alloc_Avail_Pf_Dtls: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
5315: END IF;
5316: x_return_status := FND_API.G_RET_STS_ERROR;
5317:
5318: END Item_Alloc_Avail_Pf_Dtls;
5319:
5320: /*--Item_Prealloc_Avail_Pf--------------------------------------------------------

Line 5348: x_return_status := FND_API.G_RET_STS_SUCCESS;

5344: msc_sch_wb.atp_debug('Item_Prealloc_Avail_Pf p_demand_class: ' || p_demand_class);
5345: END IF;
5346:
5347: -- Initializing API return code
5348: x_return_status := FND_API.G_RET_STS_SUCCESS;
5349:
5350: SELECT SD_DATE,
5351: SUM(SD_QTY)
5352: BULK COLLECT INTO

Line 5391: x_return_status := FND_API.G_RET_STS_ERROR;

5387: WHEN OTHERS THEN
5388: IF PG_DEBUG in ('Y', 'C') THEN
5389: msc_sch_wb.atp_debug('Item_Prealloc_Avail_Pf: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
5390: END IF;
5391: x_return_status := FND_API.G_RET_STS_ERROR;
5392:
5393: END Item_Prealloc_Avail_Pf;
5394:
5395: /*--Item_Prealloc_Avail_Pf_Summ---------------------------------------------------

Line 5424: x_return_status := FND_API.G_RET_STS_SUCCESS;

5420: msc_sch_wb.atp_debug('Item_Prealloc_Avail_Pf_Summ p_demand_class: ' || p_demand_class);
5421: END IF;
5422:
5423: -- Initializing API return code
5424: x_return_status := FND_API.G_RET_STS_SUCCESS;
5425:
5426: -- SQL changed for summary enhancement
5427: SELECT SD_DATE,
5428: SUM(SD_QTY)

Line 5494: x_return_status := FND_API.G_RET_STS_ERROR;

5490: WHEN OTHERS THEN
5491: IF PG_DEBUG in ('Y', 'C') THEN
5492: msc_sch_wb.atp_debug('Item_Prealloc_Avail_Pf_Summ: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
5493: END IF;
5494: x_return_status := FND_API.G_RET_STS_ERROR;
5495:
5496: END Item_Prealloc_Avail_Pf_Summ;
5497:
5498: /*--Item_Prealloc_Avail_Pf_Dtls---------------------------------------------------

Line 5535: x_return_status := FND_API.G_RET_STS_SUCCESS;

5531: msc_sch_wb.atp_debug('Item_Prealloc_Avail_Pf_Dtls p_demand_class: ' || p_demand_class);
5532: END IF;
5533:
5534: -- Initializing API return code
5535: x_return_status := FND_API.G_RET_STS_SUCCESS;
5536:
5537: INSERT INTO msc_atp_sd_details_temp (
5538: ATP_Level,
5539: Order_line_id,

Line 5741: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5737: p_demand_class,
5738: l_return_status
5739: );
5740:
5741: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5742: IF PG_DEBUG in ('Y', 'C') THEN
5743: msc_sch_wb.atp_debug('Item_Prealloc_Avail_Pf_Dtls: ' || 'Error occured in procedure Populate_Original_Demand_Qty');
5744: END IF;
5745: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5745: x_return_status := FND_API.G_RET_STS_ERROR;

5741: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5742: IF PG_DEBUG in ('Y', 'C') THEN
5743: msc_sch_wb.atp_debug('Item_Prealloc_Avail_Pf_Dtls: ' || 'Error occured in procedure Populate_Original_Demand_Qty');
5744: END IF;
5745: x_return_status := FND_API.G_RET_STS_ERROR;
5746: return;
5747: END IF;
5748:
5749: EXCEPTION

Line 5754: x_return_status := FND_API.G_RET_STS_ERROR;

5750: WHEN OTHERS THEN
5751: IF PG_DEBUG in ('Y', 'C') THEN
5752: msc_sch_wb.atp_debug('Item_Prealloc_Avail_Pf_Dtls: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
5753: END IF;
5754: x_return_status := FND_API.G_RET_STS_ERROR;
5755:
5756: END Item_Prealloc_Avail_Pf_Dtls;
5757:
5758: /*--Get_Forward_Mat_Pf------------------------------------------------------------

Line 5785: x_return_status := FND_API.G_RET_STS_SUCCESS;

5781: msc_sch_wb.atp_debug('Get_Forward_Mat_Pf: p_plan_id: ' || p_plan_id);
5782: END IF;
5783:
5784: -- Initializing API return code
5785: x_return_status := FND_API.G_RET_STS_SUCCESS;
5786:
5787: SELECT SD_DATE,
5788: SUM(SD_QTY),
5789: DEMAND_CLASS

Line 5844: x_return_status := FND_API.G_RET_STS_ERROR;

5840: WHEN OTHERS THEN
5841: IF PG_DEBUG in ('Y', 'C') THEN
5842: msc_sch_wb.atp_debug('Get_Forward_Mat_Pf: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
5843: END IF;
5844: x_return_status := FND_API.G_RET_STS_ERROR;
5845:
5846: END Get_Forward_Mat_Pf;
5847:
5848: /*--Get_Forward_Mat_Pf_Summ---------------------------------------------------

Line 5876: x_return_status := FND_API.G_RET_STS_SUCCESS;

5872: msc_sch_wb.atp_debug('Get_Forward_Mat_Pf_Summ: p_plan_id: ' || p_plan_id);
5873: END IF;
5874:
5875: -- Initializing API return code
5876: x_return_status := FND_API.G_RET_STS_SUCCESS;
5877:
5878: -- Summary SQL can be used
5879: SELECT SD_DATE,
5880: SUM(SD_QTY),

Line 5955: x_return_status := FND_API.G_RET_STS_ERROR;

5951: WHEN OTHERS THEN
5952: IF PG_DEBUG in ('Y', 'C') THEN
5953: msc_sch_wb.atp_debug('Get_Forward_Mat_Pf_Summ: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
5954: END IF;
5955: x_return_status := FND_API.G_RET_STS_ERROR;
5956:
5957: END Get_Forward_Mat_Pf_Summ;
5958:
5959: /*--Insert_SD_Into_Details_Temp-----------------------------------------------

Line 6012: x_return_status := FND_API.G_RET_STS_SUCCESS;

6008: msc_sch_wb.atp_debug('Insert_SD_Into_Details_Temp: p_uom_code: ' || p_uom_code);
6009: END IF;
6010:
6011: -- initialize API return status to success
6012: x_return_status := FND_API.G_RET_STS_SUCCESS;
6013:
6014: IF p_type = Demand_Priority THEN
6015: INSERT INTO MRP_ATP_DETAILS_TEMP
6016: (session_id, atp_level, inventory_item_id, organization_id, identifier1, identifier3,

Line 7276: x_return_status := FND_API.G_RET_STS_ERROR;

7272: WHEN OTHERS THEN
7273: IF PG_DEBUG in ('Y', 'C') THEN
7274: msc_sch_wb.atp_debug('Insert_SD_Into_Details_Temp: ' || 'Error code:' || to_char(sqlcode));
7275: END IF;
7276: x_return_status := FND_API.G_RET_STS_ERROR;
7277:
7278: END Insert_SD_Into_Details_Temp;
7279:
7280: /*--Populate_Original_Demand_Qty--------------------------------------------

Line 7302: x_return_status := FND_API.G_RET_STS_SUCCESS;

7298: msc_sch_wb.atp_debug('Populate_Original_Demand_Qty: ' || 'p_session_id: '|| to_char(p_session_id));
7299: END IF;
7300:
7301: -- Initializing API return code
7302: x_return_status := FND_API.G_RET_STS_SUCCESS;
7303:
7304: /* Clear msc_alloc_temp before use */
7305: DELETE msc_alloc_temp;
7306:

Line 7381: x_return_status := FND_API.G_RET_STS_ERROR;

7377: WHEN OTHERS THEN
7378: IF PG_DEBUG in ('Y', 'C') THEN
7379: msc_sch_wb.atp_debug('Populate_Original_Demand_Qty: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
7380: END IF;
7381: x_return_status := FND_API.G_RET_STS_ERROR;
7382:
7383: END Populate_Original_Demand_Qty;
7384:
7385: /*--PF_Atp_Consume----------------------------------------------------------

Line 7425: x_return_status := FND_API.G_RET_STS_SUCCESS;

7421: msc_sch_wb.atp_debug('PF_Atp_Consume: ' || 'p_atf_date: '|| to_char(p_atf_date));
7422: END IF;
7423:
7424: -- Initializing API return code
7425: x_return_status := FND_API.G_RET_STS_SUCCESS;
7426:
7427: /* p_consumption_type
7428: * 1 = b/w consumption
7429: * 2 = f/w consumption

Line 7578: x_return_status := FND_API.G_RET_STS_ERROR;

7574: WHEN OTHERS THEN
7575: IF PG_DEBUG in ('Y', 'C') THEN
7576: msc_sch_wb.atp_debug('PF_Atp_Consume: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
7577: END IF;
7578: x_return_status := FND_API.G_RET_STS_ERROR;
7579:
7580: END PF_Atp_Consume;
7581:
7582: /*--PF_Atp_Alloc_Consume-------------------------------------------------------

Line 7612: x_return_status := FND_API.G_RET_STS_SUCCESS;

7608: msc_sch_wb.atp_debug('**********Begin PF_Atp_Alloc_Consume Procedure************');
7609: END IF;
7610:
7611: -- Initializing API return code
7612: x_return_status := FND_API.G_RET_STS_SUCCESS;
7613:
7614: x_dc_list_tab := MRP_ATP_PUB.Char80_Arr();
7615: x_dc_start_index := MRP_ATP_PUB.Number_Arr();
7616: x_dc_end_index := MRP_ATP_PUB.Number_Arr();

Line 7769: x_return_status := FND_API.G_RET_STS_ERROR;

7765: WHEN OTHERS THEN
7766: IF PG_DEBUG in ('Y', 'C') THEN
7767: msc_sch_wb.atp_debug('PF_Atp_Alloc_Consume: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
7768: END IF;
7769: x_return_status := FND_API.G_RET_STS_ERROR;
7770:
7771: END PF_Atp_Alloc_Consume;
7772:
7773: /*--Get_Period_Data_From_Sd_Temp--------------------------------------------

Line 7797: x_return_status := FND_API.G_RET_STS_SUCCESS;

7793: msc_sch_wb.atp_debug('PROCEDURE Get_Period_Data_From_Sd_Temp');
7794: END IF;
7795:
7796: -- Initializing API return code
7797: x_return_status := FND_API.G_RET_STS_SUCCESS;
7798:
7799: SELECT SD_View.ATP_level
7800: ,SD_View.scenario_id
7801: ,SD_View.inventory_item_id

Line 7926: x_return_status := FND_API.G_RET_STS_ERROR;

7922: WHEN OTHERS THEN
7923: IF PG_DEBUG in ('Y', 'C') THEN
7924: msc_sch_wb.atp_debug('Get_Period_Data_From_Sd_Temp: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
7925: END IF;
7926: x_return_status := FND_API.G_RET_STS_ERROR;
7927:
7928: END Get_Period_Data_From_Sd_Temp;
7929:
7930: /*--Get_Unalloc_Data_From_Sd_Temp-------------------------------------------

Line 7951: x_return_status := FND_API.G_RET_STS_SUCCESS;

7947: msc_sch_wb.atp_debug('PROCEDURE Get_Unalloc_Data_From_Sd_Temp');
7948: END IF;
7949:
7950: -- initialize API return status to success
7951: x_return_status := FND_API.G_RET_STS_SUCCESS;
7952:
7953: -- do netting for unallocated qty also
7954: SELECT SD_View.ATP_level
7955: ,SD_View.scenario_id

Line 8086: x_return_status := FND_API.G_RET_STS_ERROR;

8082: WHEN OTHERS THEN
8083: IF PG_DEBUG in ('Y', 'C') THEN
8084: msc_sch_wb.atp_debug('Get_Unalloc_Data_From_Sd_Temp: ' || 'Error code:' || to_char(sqlcode));
8085: END IF;
8086: x_return_status := FND_API.G_RET_STS_ERROR;
8087:
8088: END Get_Unalloc_Data_From_Sd_Temp;
8089:
8090: /*--Get_Period_From_Details_Temp--------------------------------------------

Line 8114: x_return_status := FND_API.G_RET_STS_SUCCESS;

8110: msc_sch_wb.atp_debug('PROCEDURE Get_Period_From_Details_Temp');
8111: END IF;
8112:
8113: -- initialize API return status to success
8114: x_return_status := FND_API.G_RET_STS_SUCCESS;
8115:
8116: IF p_type = Demand_Priority THEN
8117: SELECT
8118: final.col1,

Line 8461: x_return_status := FND_API.G_RET_STS_ERROR;

8457: WHEN OTHERS THEN
8458: IF PG_DEBUG in ('Y', 'C') THEN
8459: msc_sch_wb.atp_debug('Get_Period_From_Details_Temp: ' || 'Error code:' || to_char(sqlcode));
8460: END IF;
8461: x_return_status := FND_API.G_RET_STS_ERROR;
8462:
8463: END Get_Period_From_Details_Temp;
8464:
8465: /*--Get_Pf_Atp_Item_Id------------------------------------------------------

Line 8658: x_return_status := FND_API.G_RET_STS_SUCCESS;

8654: msc_sch_wb.atp_debug('Get_Family_Item_Info: ' || 'p_organization_id = ' ||to_char(p_organization_id));
8655: END IF;
8656:
8657: -- Initializing API return code
8658: x_return_status := FND_API.G_RET_STS_SUCCESS;
8659:
8660: SELECT DECODE(i2.bom_item_type,
8661: 5, DECODE(i2.atp_flag,
8662: 'N', i1.inventory_item_id,

Line 8724: x_return_status := FND_API.G_RET_STS_ERROR;

8720: WHEN OTHERS THEN
8721: IF PG_DEBUG in ('Y', 'C') THEN
8722: msc_sch_wb.atp_debug('Get_Family_Item_Info: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
8723: END IF;
8724: x_return_status := FND_API.G_RET_STS_ERROR;
8725:
8726: END Get_Family_Item_Info;
8727:
8728: /*--Get_PF_Plan_Info----------------------------------------------------------

Line 8759: x_return_status := FND_API.G_RET_STS_SUCCESS;

8755:
8756: END IF;
8757:
8758: -- initialize API return status to success
8759: x_return_status := FND_API.G_RET_STS_SUCCESS;
8760:
8761: /* First get member item's plan*/
8762: MSC_ATP_PROC.get_global_plan_info(
8763: p_instance_id,

Line 8775: x_return_status := FND_API.G_RET_STS_ERROR;

8771: IF PG_DEBUG in ('Y', 'C') THEN
8772: msc_sch_wb.atp_debug('Get_PF_Plan_Info: ' || 'ATP Downtime');
8773: END IF;
8774:
8775: x_return_status := FND_API.G_RET_STS_ERROR;
8776: MSC_ATP_PVT.G_DOWNTIME_HIT := 'Y';
8777: p_error_code := MSC_ATP_PVT.PLAN_DOWN_TIME;
8778: RAISE NO_DATA_FOUND;
8779: END IF;

Line 8833: x_return_status := FND_API.G_RET_STS_ERROR;

8829: IF PG_DEBUG in ('Y', 'C') THEN
8830: msc_sch_wb.atp_debug('Get_PF_Plan_Info: ' || 'ATP Downtime');
8831: END IF;
8832:
8833: x_return_status := FND_API.G_RET_STS_ERROR;
8834: MSC_ATP_PVT.G_DOWNTIME_HIT := 'Y';
8835: p_error_code := MSC_ATP_PVT.PLAN_DOWN_TIME;
8836: RAISE NO_DATA_FOUND;
8837: END IF;

Line 8855: x_return_status := FND_API.G_RET_STS_ERROR;

8851: IF PG_DEBUG in ('Y', 'C') THEN
8852: msc_sch_wb.atp_debug('Get_PF_Plan_Info: ' || 'Exception: ' || sqlerrm);
8853: msc_sch_wb.atp_debug('Get_PF_Plan_Info: ' || 'Error code:' || to_char(sqlcode));
8854: END IF;
8855: x_return_status := FND_API.G_RET_STS_ERROR;
8856:
8857: END Get_PF_Plan_Info;
8858:
8859: /*--Populate_ATF_Dates--------------------------------------------------------

Line 8887: x_return_status := FND_API.G_RET_STS_SUCCESS;

8883: msc_util.msc_log('Populate_ATF_Dates: ' || 'p_plan_id = ' ||to_char(p_plan_id));
8884: END IF;
8885:
8886: -- initialize API return status to success
8887: x_return_status := FND_API.G_RET_STS_SUCCESS;
8888:
8889: --bug3663487 start SQL ID 9426916 and 9426907
8890: SELECT c2.calendar_date,i2.organization_id,i2.sr_instance_id,i2.inventory_item_id
8891: BULK COLLECT INTO l_atf_date,l_organization_id,l_sr_instance_id,l_inventory_item_id

Line 9033: x_return_status := FND_API.G_RET_STS_ERROR;

9029: IF PG_DEBUG in ('Y', 'C') THEN
9030: msc_util.msc_log('Populate_ATF_Dates: ' || 'Exception: ' || sqlerrm);
9031: msc_util.msc_log('Populate_ATF_Dates: ' || 'Error code:' || to_char(sqlcode));
9032: END IF;
9033: x_return_status := FND_API.G_RET_STS_ERROR;
9034:
9035: END Populate_ATF_Dates;
9036:
9037: /*--Calculate_Alloc_Percentages-----------------------------------------------

Line 9086: x_return_status := FND_API.G_RET_STS_SUCCESS;

9082: msc_util.msc_log('Calculate_Alloc_Percentages: ' || 'p_plan_id = ' ||to_char(p_plan_id));
9083: END IF;
9084:
9085: -- initialize API return status to success
9086: x_return_status := FND_API.G_RET_STS_SUCCESS;
9087:
9088: /* populate allocated quantity for planned order at product family that are blown down as production forecasts*/
9089: insert into msc_alloc_temp(
9090: transaction_id,

Line 9154: x_return_status := FND_API.G_RET_STS_ERROR;

9150: IF PG_DEBUG in ('Y', 'C') THEN
9151: msc_util.msc_log('Calculate_Alloc_Percentages: ' || 'Exception: ' || sqlerrm);
9152: msc_util.msc_log('Calculate_Alloc_Percentages: ' || 'Error code:' || to_char(sqlcode));
9153: END IF;
9154: x_return_status := FND_API.G_RET_STS_ERROR;
9155:
9156: END Calculate_Alloc_Percentages;
9157:
9158: /*--Pf_Post_Plan_Proc-----------------------------------------------------------------

Line 9429: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

9425: END;
9426:
9427: Calculate_Alloc_Percentages(p_plan_id, l_return_status);
9428:
9429: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9430: IF PG_DEBUG in ('Y', 'C') THEN
9431: msc_util.msc_log('Pf_Post_Plan_Proc: ' || 'Error occured in procedure Calculate_Alloc_Percentages');
9432: END IF;
9433: RAISE FND_API.G_EXC_ERROR;

Line 9433: RAISE FND_API.G_EXC_ERROR;

9429: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9430: IF PG_DEBUG in ('Y', 'C') THEN
9431: msc_util.msc_log('Pf_Post_Plan_Proc: ' || 'Error occured in procedure Calculate_Alloc_Percentages');
9432: END IF;
9433: RAISE FND_API.G_EXC_ERROR;
9434: END IF;
9435:
9436: msc_util.msc_log('Before generating the SQL');
9437:

Line 9535: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

9531:
9532: /* forecast at PF changes begin*/
9533: Prepare_Demands_Stmt(l_share_partition, p_demand_priority, l_excess_supply_by_dc,
9534: NULL, l_alloc_temp_table, l_parallel_degree, l_sql_stmt_1, l_return_status);
9535: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9536: IF PG_DEBUG in ('Y', 'C') THEN
9537: msc_util.msc_log('Pf_Post_Plan_Proc: ' || 'Error occured in procedure Prepare_Demands_Stmt');
9538: END IF;
9539: RAISE FND_API.G_EXC_ERROR;

Line 9539: RAISE FND_API.G_EXC_ERROR;

9535: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9536: IF PG_DEBUG in ('Y', 'C') THEN
9537: msc_util.msc_log('Pf_Post_Plan_Proc: ' || 'Error occured in procedure Prepare_Demands_Stmt');
9538: END IF;
9539: RAISE FND_API.G_EXC_ERROR;
9540: END IF;
9541:
9542: msc_util.msc_log('After generating Demands SQL1');
9543: msc_util.msc_log(l_sql_stmt_1);

Line 9577: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

9573:
9574: Prepare_Supplies_Stmt(l_share_partition, p_demand_priority,
9575: l_excess_supply_by_dc, NULL, l_alloc_temp_table, l_parallel_degree, l_sql_stmt_1, l_return_status);
9576:
9577: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9578: IF PG_DEBUG in ('Y', 'C') THEN
9579: msc_util.msc_log('Pf_Post_Plan_Proc: ' || 'Error occured in procedure Prepare_Supplies_Stmt');
9580: END IF;
9581: RAISE FND_API.G_EXC_ERROR;

Line 9581: RAISE FND_API.G_EXC_ERROR;

9577: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9578: IF PG_DEBUG in ('Y', 'C') THEN
9579: msc_util.msc_log('Pf_Post_Plan_Proc: ' || 'Error occured in procedure Prepare_Supplies_Stmt');
9580: END IF;
9581: RAISE FND_API.G_EXC_ERROR;
9582: END IF;
9583:
9584: msc_util.msc_log(l_sql_stmt_1);
9585: msc_util.msc_log('After Generating Supplies SQL1');

Line 9730: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

9726: /* forecast at PF changes begin*/
9727: Prepare_Demands_Stmt(l_share_partition, p_demand_priority, l_excess_supply_by_dc,
9728: l_temp_table, l_alloc_temp_table, l_parallel_degree, l_sql_stmt_1, l_return_status);
9729:
9730: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9731: IF PG_DEBUG in ('Y', 'C') THEN
9732: msc_util.msc_log('Pf_Post_Plan_Proc: ' || 'Error occured in procedure Prepare_Demands_Stmt');
9733: END IF;
9734: RAISE FND_API.G_EXC_ERROR;

Line 9734: RAISE FND_API.G_EXC_ERROR;

9730: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9731: IF PG_DEBUG in ('Y', 'C') THEN
9732: msc_util.msc_log('Pf_Post_Plan_Proc: ' || 'Error occured in procedure Prepare_Demands_Stmt');
9733: END IF;
9734: RAISE FND_API.G_EXC_ERROR;
9735: END IF;
9736:
9737: msc_util.msc_log(l_sql_stmt_1);
9738: msc_util.msc_log('After generating Demands SQL1');

Line 9915: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

9911: /* forecast at PF changes begin*/
9912: Prepare_Supplies_Stmt(l_share_partition, p_demand_priority, l_excess_supply_by_dc,
9913: l_temp_table, l_alloc_temp_table, l_parallel_degree, l_sql_stmt_1, l_return_status);
9914:
9915: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9916: IF PG_DEBUG in ('Y', 'C') THEN
9917: msc_util.msc_log('Pf_Post_Plan_Proc: ' || 'Error occured in procedure Prepare_Supplies_Stmt');
9918: END IF;
9919: RAISE FND_API.G_EXC_ERROR;

Line 9919: RAISE FND_API.G_EXC_ERROR;

9915: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9916: IF PG_DEBUG in ('Y', 'C') THEN
9917: msc_util.msc_log('Pf_Post_Plan_Proc: ' || 'Error occured in procedure Prepare_Supplies_Stmt');
9918: END IF;
9919: RAISE FND_API.G_EXC_ERROR;
9920: END IF;
9921:
9922: msc_util.msc_log(l_sql_stmt_1);
9923: msc_util.msc_log('After Generating Supplies SQL1');

Line 10057: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

10053:
10054: /* Call Update_Pf_Display_Flags to update Pf_Display_Flag in msc_alloc_demands*/
10055: Update_Pf_Display_Flag(p_plan_id, l_return_status);
10056:
10057: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10058: IF PG_DEBUG in ('Y', 'C') THEN
10059: msc_util.msc_log('Pf_Post_Plan_Proc: ' || 'Error occured in procedure Update_Pf_Display_Flag');
10060: END IF;
10061: RAISE FND_API.G_EXC_ERROR;

Line 10061: RAISE FND_API.G_EXC_ERROR;

10057: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10058: IF PG_DEBUG in ('Y', 'C') THEN
10059: msc_util.msc_log('Pf_Post_Plan_Proc: ' || 'Error occured in procedure Update_Pf_Display_Flag');
10060: END IF;
10061: RAISE FND_API.G_EXC_ERROR;
10062: END IF;
10063:
10064: BEGIN
10065: update msc_plans

Line 10137: x_return_status := FND_API.G_RET_STS_SUCCESS;

10133: msc_util.msc_log('Prepare_Demands_Stmt: ' || 'MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF : ' || MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF);
10134: END IF;
10135:
10136: -- Initializing API return code
10137: x_return_status := FND_API.G_RET_STS_SUCCESS;
10138:
10139: IF p_share_partition = 'Y' THEN
10140: x_sql_stmt := '
10141: INSERT INTO MSC_ALLOC_DEMANDS(';

Line 10536: x_return_status := FND_API.G_RET_STS_ERROR;

10532: WHEN OTHERS THEN
10533: IF PG_DEBUG in ('Y', 'C') THEN
10534: msc_util.msc_log('Prepare_Demands_Stmt: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
10535: END IF;
10536: x_return_status := FND_API.G_RET_STS_ERROR;
10537:
10538: END Prepare_Demands_Stmt;
10539:
10540: -- New private procedure added for forecast at PF

Line 10575: x_return_status := FND_API.G_RET_STS_SUCCESS;

10571: msc_util.msc_log('Prepare_Supplies_Stmt: ' || 'p_parallel_degree : ' || p_parallel_degree);
10572: END IF;
10573:
10574: -- Initializing API return code
10575: x_return_status := FND_API.G_RET_STS_SUCCESS;
10576:
10577: IF p_share_partition = 'Y' THEN
10578: x_sql_stmt := '
10579: INSERT INTO MSC_ALLOC_SUPPLIES(';

Line 10768: x_return_status := FND_API.G_RET_STS_ERROR;

10764: WHEN OTHERS THEN
10765: IF PG_DEBUG in ('Y', 'C') THEN
10766: msc_util.msc_log('Prepare_Supplies_Stmt: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
10767: END IF;
10768: x_return_status := FND_API.G_RET_STS_ERROR;
10769:
10770: END Prepare_Supplies_Stmt;
10771:
10772: /*Private procedures removed for forecast at PF **Will be deleted after code review

Line 10805: x_return_status := FND_API.G_RET_STS_SUCCESS;

10801: msc_util.msc_log('Prepare_Demands_Stmt1: ' || 'p_parallel_degree : ' || p_parallel_degree);
10802: END IF;
10803:
10804: -- Initializing API return code
10805: x_return_status := FND_API.G_RET_STS_SUCCESS;
10806:
10807: IF p_share_partition = 'Y' THEN
10808: x_sql_stmt := '
10809: INSERT INTO MSC_ALLOC_DEMANDS(';

Line 11406: x_return_status := FND_API.G_RET_STS_ERROR;

11402: WHEN OTHERS THEN
11403: IF PG_DEBUG in ('Y', 'C') THEN
11404: msc_util.msc_log('Prepare_Demands_Stmt1: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
11405: END IF;
11406: x_return_status := FND_API.G_RET_STS_ERROR;
11407:
11408: END Prepare_Demands_Stmt1;
11409:
11410: /*--Prepare_Demands_Stmt2---------------------------------------------------

Line 11427: x_return_status := FND_API.G_RET_STS_SUCCESS;

11423: IS
11424:
11425: BEGIN
11426: -- Initializing API return code
11427: x_return_status := FND_API.G_RET_STS_SUCCESS;
11428:
11429: IF p_share_partition = 'Y' THEN
11430: x_sql_stmt := '
11431: INSERT INTO MSC_ALLOC_DEMANDS(';

Line 11634: x_return_status := FND_API.G_RET_STS_ERROR;

11630: WHEN OTHERS THEN
11631: IF PG_DEBUG in ('Y', 'C') THEN
11632: msc_util.msc_log('Prepare_Demands_Stmt2: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
11633: END IF;
11634: x_return_status := FND_API.G_RET_STS_ERROR;
11635:
11636: END Prepare_Demands_Stmt2;
11637:
11638: /*--Prepare_Supplies_Stmt1--------------------------------------------------

Line 11661: x_return_status := FND_API.G_RET_STS_SUCCESS;

11657: IS
11658:
11659: BEGIN
11660: -- Initializing API return code
11661: x_return_status := FND_API.G_RET_STS_SUCCESS;
11662:
11663: IF p_share_partition = 'Y' THEN
11664: x_sql_stmt := '
11665: INSERT INTO MSC_ALLOC_SUPPLIES(';

Line 11962: x_return_status := FND_API.G_RET_STS_ERROR;

11958: WHEN OTHERS THEN
11959: IF PG_DEBUG in ('Y', 'C') THEN
11960: msc_util.msc_log('Prepare_Supplies_Stmt1: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
11961: END IF;
11962: x_return_status := FND_API.G_RET_STS_ERROR;
11963:
11964: END Prepare_Supplies_Stmt1;
11965:
11966: /*--Prepare_Supplies_Stmt2-----------------------------------------------------

Line 11983: x_return_status := FND_API.G_RET_STS_SUCCESS;

11979: IS
11980:
11981: BEGIN
11982: -- Initializing API return code
11983: x_return_status := FND_API.G_RET_STS_SUCCESS;
11984:
11985: IF p_share_partition = 'Y' THEN
11986: x_sql_stmt := '
11987: INSERT INTO MSC_ALLOC_SUPPLIES(';

Line 12125: x_return_status := FND_API.G_RET_STS_ERROR;

12121: WHEN OTHERS THEN
12122: IF PG_DEBUG in ('Y', 'C') THEN
12123: msc_util.msc_log('Prepare_Supplies_Stmt2: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
12124: END IF;
12125: x_return_status := FND_API.G_RET_STS_ERROR;
12126:
12127: END Prepare_Supplies_Stmt2;
12128:
12129: /*--Update_Pf_Display_Flag-----------------------------------------------------

Line 12147: x_return_status := FND_API.G_RET_STS_SUCCESS;

12143: msc_util.msc_log('Update_Pf_Display_Flag: ' || 'p_plan_id: ' || p_plan_id);
12144: END IF;
12145:
12146: -- Initializing API return code
12147: x_return_status := FND_API.G_RET_STS_SUCCESS;
12148:
12149: -- Performance tuning pending
12150: /*
12151: UPDATE MSC_ALLOC_DEMANDS AD

Line 12194: x_return_status := FND_API.G_RET_STS_ERROR;

12190: WHEN OTHERS THEN
12191: IF PG_DEBUG in ('Y', 'C') THEN
12192: msc_util.msc_log('Update_Pf_Display_Flag: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
12193: END IF;
12194: x_return_status := FND_API.G_RET_STS_ERROR;
12195:
12196: END Update_Pf_Display_Flag;
12197:
12198: -- CTO-PF start

Line 12229: x_return_status := FND_API.G_RET_STS_SUCCESS;

12225: msc_sch_wb.atp_debug(' User Id Paramenter : ' || p_user_id );
12226: msc_sch_wb.atp_debug(' Date Parameter : ' || p_sysdate );
12227: END IF;
12228:
12229: x_return_status := FND_API.G_RET_STS_SUCCESS;
12230:
12231: IF PG_DEBUG in ('Y', 'C') THEN
12232: msc_sch_wb.atp_debug(' Inserting Demands');
12233: END IF;

Line 12480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

12476: IF PG_DEBUG in ('Y', 'C') THEN
12477: msc_sch_wb.atp_debug('Inside main exception of Create_PF_DP_Alloc_Reliefs');
12478: msc_sch_wb.atp_debug ('Create_PF_DP_Alloc_Reliefs. Error : ' || sqlcode || ': '|| sqlerrm);
12479: END IF;
12480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12481:
12482: END Create_PF_DP_Alloc_Reliefs;
12483:
12484: /*--Create_PF_Allocation_Reliefs-----------------------------------------------------

Line 12509: x_return_status := FND_API.G_RET_STS_SUCCESS;

12505: msc_sch_wb.atp_debug(' User Id Paramenter : ' || p_user_id );
12506: msc_sch_wb.atp_debug(' Date Parameter : ' || p_sysdate );
12507: END IF;
12508:
12509: x_return_status := FND_API.G_RET_STS_SUCCESS;
12510:
12511: IF PG_DEBUG in ('Y', 'C') THEN
12512: msc_sch_wb.atp_debug(' Inserting Demands');
12513: END IF;

Line 12617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

12613: IF PG_DEBUG in ('Y', 'C') THEN
12614: msc_sch_wb.atp_debug('Inside main exception of Create_PF_Allocation_Reliefs');
12615: msc_sch_wb.atp_debug ('Create_PF_Allocation_Reliefs. Error : ' || sqlcode || ': '|| sqlerrm);
12616: END IF;
12617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12618:
12619: END Create_PF_Allocation_Reliefs;
12620: -- CTO-PF end
12621: END MSC_ATP_PF;