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_PEG dependencies on MSC_SCH_WB

Line 4749: msc_sch_wb.atp_debug('* Begin Add_Offset_Demands *');

4745: l_sup_offset_type NUMBER;
4746: BEGIN
4747:
4748: IF PG_DEBUG in ('Y', 'C') THEN
4749: msc_sch_wb.atp_debug('***** Begin Add_Offset_Demands *****');
4750: END IF;
4751:
4752: IF PG_DEBUG in ('Y', 'C') THEN
4753: msc_sch_wb.atp_debug('Add_Offset_Demands: ' ||

Line 4753: msc_sch_wb.atp_debug('Add_Offset_Demands: ' ||

4749: msc_sch_wb.atp_debug('***** Begin Add_Offset_Demands *****');
4750: END IF;
4751:
4752: IF PG_DEBUG in ('Y', 'C') THEN
4753: msc_sch_wb.atp_debug('Add_Offset_Demands: ' ||
4754: 'Offsetting msc_demands for identifier = '
4755: || p_identifier ||' : plan id = '||p_plan_id);
4756: msc_sch_wb.atp_debug('Add_Offset_Demands: ' || 'Config Line Id = ' || p_config_line_id );
4757: END IF;

Line 4756: msc_sch_wb.atp_debug('Add_Offset_Demands: ' || 'Config Line Id = ' || p_config_line_id );

4752: IF PG_DEBUG in ('Y', 'C') THEN
4753: msc_sch_wb.atp_debug('Add_Offset_Demands: ' ||
4754: 'Offsetting msc_demands for identifier = '
4755: || p_identifier ||' : plan id = '||p_plan_id);
4756: msc_sch_wb.atp_debug('Add_Offset_Demands: ' || 'Config Line Id = ' || p_config_line_id );
4757: END IF;
4758:
4759: x_return_status := FND_API.G_RET_STS_SUCCESS;
4760:

Line 4781: msc_sch_wb.atp_debug('Add_Offset_Demands: Dmd. Offset Type Set to '|| l_offset_type);

4777: END IF;
4778: -- CTO_PF_PRJ_2 Impacts
4779:
4780: IF PG_DEBUG in ('Y', 'C') THEN
4781: msc_sch_wb.atp_debug('Add_Offset_Demands: Dmd. Offset Type Set to '|| l_offset_type);
4782: -- Bug 3717618 Set value of supply relief type.
4783: msc_sch_wb.atp_debug('Add_Offset_Demands: Sup. Offset Type Set to '|| l_sup_offset_type);
4784: END IF;
4785:

Line 4783: msc_sch_wb.atp_debug('Add_Offset_Demands: Sup. Offset Type Set to '|| l_sup_offset_type);

4779:
4780: IF PG_DEBUG in ('Y', 'C') THEN
4781: msc_sch_wb.atp_debug('Add_Offset_Demands: Dmd. Offset Type Set to '|| l_offset_type);
4782: -- Bug 3717618 Set value of supply relief type.
4783: msc_sch_wb.atp_debug('Add_Offset_Demands: Sup. Offset Type Set to '|| l_sup_offset_type);
4784: END IF;
4785:
4786: -- CTO_PF_PRJ_2 Impacts
4787: SELECT msc_demands_s.nextval ,

Line 4949: msc_sch_wb.atp_debug('Add_Offset_Demands: Number of rows inserted '||

4945: -- ,l_offset_demand_id(i)
4946: );
4947:
4948: IF PG_DEBUG in ('Y', 'C') THEN
4949: msc_sch_wb.atp_debug('Add_Offset_Demands: Number of rows inserted '||
4950: SQL%ROWCOUNT);
4951: END IF;
4952:
4953: -- Allocated ATP Based on Planning Details

Line 4961: msc_sch_wb.atp_debug('Add_Offset_Demands: before insert into'||

4957: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
4958: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
4959:
4960: IF PG_DEBUG in ('Y', 'C') THEN
4961: msc_sch_wb.atp_debug('Add_Offset_Demands: before insert into'||
4962: ' msc_alloc_demands');
4963: END IF;
4964:
4965: -- CTO_PF_PRJ2 relief_type already set above.

Line 5054: msc_sch_wb.atp_debug('Demand to be offset ' || l_offset_demand_id(i));

5050: -- End Bug 3890723
5051: AND map.demand_id = l_offset_demand_id(i);
5052:
5053: FOR i in 1..x_demand_id.COUNT LOOP
5054: msc_sch_wb.atp_debug('Demand to be offset ' || l_offset_demand_id(i));
5055: msc_sch_wb.atp_debug('Original Item ' || l_original_item_id(i));
5056: msc_sch_wb.atp_debug('Actual Item ' || x_inv_item_id(i));
5057: msc_sch_wb.atp_debug('Original Date ' || l_original_demand_date(i));
5058: msc_sch_wb.atp_debug('Supply ID ' || l_supply_id(i));

Line 5055: msc_sch_wb.atp_debug('Original Item ' || l_original_item_id(i));

5051: AND map.demand_id = l_offset_demand_id(i);
5052:
5053: FOR i in 1..x_demand_id.COUNT LOOP
5054: msc_sch_wb.atp_debug('Demand to be offset ' || l_offset_demand_id(i));
5055: msc_sch_wb.atp_debug('Original Item ' || l_original_item_id(i));
5056: msc_sch_wb.atp_debug('Actual Item ' || x_inv_item_id(i));
5057: msc_sch_wb.atp_debug('Original Date ' || l_original_demand_date(i));
5058: msc_sch_wb.atp_debug('Supply ID ' || l_supply_id(i));
5059: msc_sch_wb.atp_debug('New Demand ' || x_demand_id(i));

Line 5056: msc_sch_wb.atp_debug('Actual Item ' || x_inv_item_id(i));

5052:
5053: FOR i in 1..x_demand_id.COUNT LOOP
5054: msc_sch_wb.atp_debug('Demand to be offset ' || l_offset_demand_id(i));
5055: msc_sch_wb.atp_debug('Original Item ' || l_original_item_id(i));
5056: msc_sch_wb.atp_debug('Actual Item ' || x_inv_item_id(i));
5057: msc_sch_wb.atp_debug('Original Date ' || l_original_demand_date(i));
5058: msc_sch_wb.atp_debug('Supply ID ' || l_supply_id(i));
5059: msc_sch_wb.atp_debug('New Demand ' || x_demand_id(i));
5060: msc_sch_wb.atp_debug('Add_Offset_Demands: Number of Family rows inserted '||

Line 5057: msc_sch_wb.atp_debug('Original Date ' || l_original_demand_date(i));

5053: FOR i in 1..x_demand_id.COUNT LOOP
5054: msc_sch_wb.atp_debug('Demand to be offset ' || l_offset_demand_id(i));
5055: msc_sch_wb.atp_debug('Original Item ' || l_original_item_id(i));
5056: msc_sch_wb.atp_debug('Actual Item ' || x_inv_item_id(i));
5057: msc_sch_wb.atp_debug('Original Date ' || l_original_demand_date(i));
5058: msc_sch_wb.atp_debug('Supply ID ' || l_supply_id(i));
5059: msc_sch_wb.atp_debug('New Demand ' || x_demand_id(i));
5060: msc_sch_wb.atp_debug('Add_Offset_Demands: Number of Family rows inserted '||
5061: 'For Demand id '|| l_offset_demand_id(i) ||

Line 5058: msc_sch_wb.atp_debug('Supply ID ' || l_supply_id(i));

5054: msc_sch_wb.atp_debug('Demand to be offset ' || l_offset_demand_id(i));
5055: msc_sch_wb.atp_debug('Original Item ' || l_original_item_id(i));
5056: msc_sch_wb.atp_debug('Actual Item ' || x_inv_item_id(i));
5057: msc_sch_wb.atp_debug('Original Date ' || l_original_demand_date(i));
5058: msc_sch_wb.atp_debug('Supply ID ' || l_supply_id(i));
5059: msc_sch_wb.atp_debug('New Demand ' || x_demand_id(i));
5060: msc_sch_wb.atp_debug('Add_Offset_Demands: Number of Family rows inserted '||
5061: 'For Demand id '|| l_offset_demand_id(i) ||
5062: ' with offset/relief_type 5 or 7 is ' || SQL%BULK_ROWCOUNT(i));

Line 5059: msc_sch_wb.atp_debug('New Demand ' || x_demand_id(i));

5055: msc_sch_wb.atp_debug('Original Item ' || l_original_item_id(i));
5056: msc_sch_wb.atp_debug('Actual Item ' || x_inv_item_id(i));
5057: msc_sch_wb.atp_debug('Original Date ' || l_original_demand_date(i));
5058: msc_sch_wb.atp_debug('Supply ID ' || l_supply_id(i));
5059: msc_sch_wb.atp_debug('New Demand ' || x_demand_id(i));
5060: msc_sch_wb.atp_debug('Add_Offset_Demands: Number of Family rows inserted '||
5061: 'For Demand id '|| l_offset_demand_id(i) ||
5062: ' with offset/relief_type 5 or 7 is ' || SQL%BULK_ROWCOUNT(i));
5063: END LOOP;

Line 5060: msc_sch_wb.atp_debug('Add_Offset_Demands: Number of Family rows inserted '||

5056: msc_sch_wb.atp_debug('Actual Item ' || x_inv_item_id(i));
5057: msc_sch_wb.atp_debug('Original Date ' || l_original_demand_date(i));
5058: msc_sch_wb.atp_debug('Supply ID ' || l_supply_id(i));
5059: msc_sch_wb.atp_debug('New Demand ' || x_demand_id(i));
5060: msc_sch_wb.atp_debug('Add_Offset_Demands: Number of Family rows inserted '||
5061: 'For Demand id '|| l_offset_demand_id(i) ||
5062: ' with offset/relief_type 5 or 7 is ' || SQL%BULK_ROWCOUNT(i));
5063: END LOOP;
5064: IF PG_DEBUG in ('Y', 'C') THEN

Line 5065: msc_sch_wb.atp_debug('Add_Offset_Demands: Number of Family and Alloc rows inserted '||

5061: 'For Demand id '|| l_offset_demand_id(i) ||
5062: ' with offset/relief_type 5 or 7 is ' || SQL%BULK_ROWCOUNT(i));
5063: END LOOP;
5064: IF PG_DEBUG in ('Y', 'C') THEN
5065: msc_sch_wb.atp_debug('Add_Offset_Demands: Number of Family and Alloc rows inserted '||
5066: 'with offset/relief_type = 7 or ' ||l_offset_type || 'is ' || SQL%ROWCOUNT);
5067: END IF;
5068:
5069: -- CTO_PF_PRJ_2

Line 5081: msc_sch_wb.atp_debug('Add_Offset_Demands: adjust stealing supplies');

5077: -- End Bug 3344102
5078: -- END CTO_PF_PRJ_2
5079:
5080: IF PG_DEBUG in ('Y', 'C') THEN
5081: msc_sch_wb.atp_debug('Add_Offset_Demands: adjust stealing supplies');
5082: msc_sch_wb.atp_debug(' Number of SO lines to be adjusted := ' || l_so_line_ids.count);
5083: For i in 1..l_so_line_ids.count LOOP
5084: msc_sch_wb.atp_debug('Line id # ' || i || ' := ' || l_so_line_ids(i));
5085: END LOOP;

Line 5082: msc_sch_wb.atp_debug(' Number of SO lines to be adjusted := ' || l_so_line_ids.count);

5078: -- END CTO_PF_PRJ_2
5079:
5080: IF PG_DEBUG in ('Y', 'C') THEN
5081: msc_sch_wb.atp_debug('Add_Offset_Demands: adjust stealing supplies');
5082: msc_sch_wb.atp_debug(' Number of SO lines to be adjusted := ' || l_so_line_ids.count);
5083: For i in 1..l_so_line_ids.count LOOP
5084: msc_sch_wb.atp_debug('Line id # ' || i || ' := ' || l_so_line_ids(i));
5085: END LOOP;
5086:

Line 5084: msc_sch_wb.atp_debug('Line id # ' || i || ' := ' || l_so_line_ids(i));

5080: IF PG_DEBUG in ('Y', 'C') THEN
5081: msc_sch_wb.atp_debug('Add_Offset_Demands: adjust stealing supplies');
5082: msc_sch_wb.atp_debug(' Number of SO lines to be adjusted := ' || l_so_line_ids.count);
5083: For i in 1..l_so_line_ids.count LOOP
5084: msc_sch_wb.atp_debug('Line id # ' || i || ' := ' || l_so_line_ids(i));
5085: END LOOP;
5086:
5087: END IF;
5088:

Line 5104: msc_sch_wb.atp_debug('Add_Offset_Demands: Number of stealing rows updated '||

5100: -1) --CMRO;
5101: and order_type in (46, 47);
5102: END IF;
5103: IF PG_DEBUG in ('Y', 'C') THEN
5104: msc_sch_wb.atp_debug('Add_Offset_Demands: Number of stealing rows updated '||
5105: SQL%ROWCOUNT);
5106: END IF;
5107:
5108: -- Offset Product Family Demands if any

Line 5190: msc_sch_wb.atp_debug('Demand to be offset ' || l_offset_demand_id(i));

5186: AND map.demand_id = l_offset_demand_id(i);
5187:
5188: IF PG_DEBUG in ('Y', 'C') THEN
5189: FOR i in 1..x_demand_id.COUNT LOOP
5190: msc_sch_wb.atp_debug('Demand to be offset ' || l_offset_demand_id(i));
5191: msc_sch_wb.atp_debug('Original Item ' || l_original_item_id(i));
5192: msc_sch_wb.atp_debug('Original Date ' || l_original_demand_date(i));
5193: msc_sch_wb.atp_debug('Supply ID ' || l_supply_id(i));
5194: msc_sch_wb.atp_debug('New Demand ' || x_demand_id(i));

Line 5191: msc_sch_wb.atp_debug('Original Item ' || l_original_item_id(i));

5187:
5188: IF PG_DEBUG in ('Y', 'C') THEN
5189: FOR i in 1..x_demand_id.COUNT LOOP
5190: msc_sch_wb.atp_debug('Demand to be offset ' || l_offset_demand_id(i));
5191: msc_sch_wb.atp_debug('Original Item ' || l_original_item_id(i));
5192: msc_sch_wb.atp_debug('Original Date ' || l_original_demand_date(i));
5193: msc_sch_wb.atp_debug('Supply ID ' || l_supply_id(i));
5194: msc_sch_wb.atp_debug('New Demand ' || x_demand_id(i));
5195: msc_sch_wb.atp_debug('Add_Offset_Demands: Number of Family rows inserted '||

Line 5192: msc_sch_wb.atp_debug('Original Date ' || l_original_demand_date(i));

5188: IF PG_DEBUG in ('Y', 'C') THEN
5189: FOR i in 1..x_demand_id.COUNT LOOP
5190: msc_sch_wb.atp_debug('Demand to be offset ' || l_offset_demand_id(i));
5191: msc_sch_wb.atp_debug('Original Item ' || l_original_item_id(i));
5192: msc_sch_wb.atp_debug('Original Date ' || l_original_demand_date(i));
5193: msc_sch_wb.atp_debug('Supply ID ' || l_supply_id(i));
5194: msc_sch_wb.atp_debug('New Demand ' || x_demand_id(i));
5195: msc_sch_wb.atp_debug('Add_Offset_Demands: Number of Family rows inserted '||
5196: 'For Demand id '|| l_offset_demand_id(i) ||

Line 5193: msc_sch_wb.atp_debug('Supply ID ' || l_supply_id(i));

5189: FOR i in 1..x_demand_id.COUNT LOOP
5190: msc_sch_wb.atp_debug('Demand to be offset ' || l_offset_demand_id(i));
5191: msc_sch_wb.atp_debug('Original Item ' || l_original_item_id(i));
5192: msc_sch_wb.atp_debug('Original Date ' || l_original_demand_date(i));
5193: msc_sch_wb.atp_debug('Supply ID ' || l_supply_id(i));
5194: msc_sch_wb.atp_debug('New Demand ' || x_demand_id(i));
5195: msc_sch_wb.atp_debug('Add_Offset_Demands: Number of Family rows inserted '||
5196: 'For Demand id '|| l_offset_demand_id(i) ||
5197: ' with offset/relief_type = 7 is ' || SQL%BULK_ROWCOUNT(i));

Line 5194: msc_sch_wb.atp_debug('New Demand ' || x_demand_id(i));

5190: msc_sch_wb.atp_debug('Demand to be offset ' || l_offset_demand_id(i));
5191: msc_sch_wb.atp_debug('Original Item ' || l_original_item_id(i));
5192: msc_sch_wb.atp_debug('Original Date ' || l_original_demand_date(i));
5193: msc_sch_wb.atp_debug('Supply ID ' || l_supply_id(i));
5194: msc_sch_wb.atp_debug('New Demand ' || x_demand_id(i));
5195: msc_sch_wb.atp_debug('Add_Offset_Demands: Number of Family rows inserted '||
5196: 'For Demand id '|| l_offset_demand_id(i) ||
5197: ' with offset/relief_type = 7 is ' || SQL%BULK_ROWCOUNT(i));
5198: END LOOP;

Line 5195: msc_sch_wb.atp_debug('Add_Offset_Demands: Number of Family rows inserted '||

5191: msc_sch_wb.atp_debug('Original Item ' || l_original_item_id(i));
5192: msc_sch_wb.atp_debug('Original Date ' || l_original_demand_date(i));
5193: msc_sch_wb.atp_debug('Supply ID ' || l_supply_id(i));
5194: msc_sch_wb.atp_debug('New Demand ' || x_demand_id(i));
5195: msc_sch_wb.atp_debug('Add_Offset_Demands: Number of Family rows inserted '||
5196: 'For Demand id '|| l_offset_demand_id(i) ||
5197: ' with offset/relief_type = 7 is ' || SQL%BULK_ROWCOUNT(i));
5198: END LOOP;
5199: msc_sch_wb.atp_debug('Add_Offset_Demands: Number of Family rows inserted '||

Line 5199: msc_sch_wb.atp_debug('Add_Offset_Demands: Number of Family rows inserted '||

5195: msc_sch_wb.atp_debug('Add_Offset_Demands: Number of Family rows inserted '||
5196: 'For Demand id '|| l_offset_demand_id(i) ||
5197: ' with offset/relief_type = 7 is ' || SQL%BULK_ROWCOUNT(i));
5198: END LOOP;
5199: msc_sch_wb.atp_debug('Add_Offset_Demands: Number of Family rows inserted '||
5200: 'with offset/relief_type = 7 is ' || SQL%ROWCOUNT);
5201: END IF;
5202: END IF; --IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND basically, IF ALLOC
5203:

Line 5205: msc_sch_wb.atp_debug('* End Add_Offset_Demands *');

5201: END IF;
5202: END IF; --IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND basically, IF ALLOC
5203:
5204: IF PG_DEBUG in ('Y', 'C') THEN
5205: msc_sch_wb.atp_debug('***** End Add_Offset_Demands *****');
5206: END IF;
5207:
5208: EXCEPTION
5209: WHEN OTHERS THEN

Line 5212: msc_sch_wb.atp_debug('Add_Offset_Demands: ' ||

5208: EXCEPTION
5209: WHEN OTHERS THEN
5210: my_sqlcode := SQLCODE;
5211: IF PG_DEBUG in ('Y', 'C') THEN
5212: msc_sch_wb.atp_debug('Add_Offset_Demands: ' ||
5213: 'error in insert row: sqlcode = '|| to_char(my_sqlcode));
5214: msc_sch_wb.atp_debug('Add_Offset_Demands: ERROR- ' || sqlerrm );
5215: END IF;
5216:

Line 5214: msc_sch_wb.atp_debug('Add_Offset_Demands: ERROR- ' || sqlerrm );

5210: my_sqlcode := SQLCODE;
5211: IF PG_DEBUG in ('Y', 'C') THEN
5212: msc_sch_wb.atp_debug('Add_Offset_Demands: ' ||
5213: 'error in insert row: sqlcode = '|| to_char(my_sqlcode));
5214: msc_sch_wb.atp_debug('Add_Offset_Demands: ERROR- ' || sqlerrm );
5215: END IF;
5216:
5217: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5218: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME , 'Add_Offset_Demands');

Line 5279: msc_sch_wb.atp_debug('* Begin Add_Offset_Supplies *');

5275:
5276: BEGIN
5277:
5278: IF PG_DEBUG in ('Y', 'C') THEN
5279: msc_sch_wb.atp_debug('***** Begin Add_Offset_Supplies *****');
5280: END IF;
5281: IF PG_DEBUG in ('Y', 'C') THEN
5282: msc_sch_wb.atp_debug('Add_Offset_Supplies: ' ||
5283: 'Offsetting msc_supplies for identifier = '

Line 5282: msc_sch_wb.atp_debug('Add_Offset_Supplies: ' ||

5278: IF PG_DEBUG in ('Y', 'C') THEN
5279: msc_sch_wb.atp_debug('***** Begin Add_Offset_Supplies *****');
5280: END IF;
5281: IF PG_DEBUG in ('Y', 'C') THEN
5282: msc_sch_wb.atp_debug('Add_Offset_Supplies: ' ||
5283: 'Offsetting msc_supplies for identifier = '
5284: || p_identifier ||' : plan id = '||p_plan_id);
5285: msc_sch_wb.atp_debug('Add_Offset_Supplies: ' || 'Config Line Id = ' || p_config_line_id );
5286: END IF;

Line 5285: msc_sch_wb.atp_debug('Add_Offset_Supplies: ' || 'Config Line Id = ' || p_config_line_id );

5281: IF PG_DEBUG in ('Y', 'C') THEN
5282: msc_sch_wb.atp_debug('Add_Offset_Supplies: ' ||
5283: 'Offsetting msc_supplies for identifier = '
5284: || p_identifier ||' : plan id = '||p_plan_id);
5285: msc_sch_wb.atp_debug('Add_Offset_Supplies: ' || 'Config Line Id = ' || p_config_line_id );
5286: END IF;
5287:
5288: x_return_status := FND_API.G_RET_STS_SUCCESS;
5289:

Line 5306: msc_sch_wb.atp_debug('Add_Offset_Supplies: Offset Type Set to '|| l_offset_type);

5302: END IF;
5303: -- End CTO_PF_PRJ_2 Changes
5304:
5305: IF PG_DEBUG in ('Y', 'C') THEN
5306: msc_sch_wb.atp_debug('Add_Offset_Supplies: Offset Type Set to '|| l_offset_type);
5307: END IF;
5308:
5309: -- Insert relief quantities as a Offsets in msc_supplies
5310:

Line 5500: msc_sch_wb.atp_debug('Add_Offset_Supplies: Number of rows inserted '||

5496: -- ,l_offset_supply_id
5497: );
5498:
5499: IF PG_DEBUG in ('Y', 'C') THEN
5500: msc_sch_wb.atp_debug('Add_Offset_Supplies: Number of rows inserted '||
5501: SQL%ROWCOUNT);
5502: END IF;
5503:
5504: -- Bug 3381464 Update offset_supply_id in msc_atp_pegging.

Line 5523: msc_sch_wb.atp_debug('Add_Offset_Supplies: Number of rows Updated '|| SQL%ROWCOUNT);

5519: AND map1.pegging_id = l_pegging_id(i)
5520: AND map1.supply_id = l_orig_supply_id(i);
5521:
5522: IF PG_DEBUG in ('Y', 'C') THEN
5523: msc_sch_wb.atp_debug('Add_Offset_Supplies: Number of rows Updated '|| SQL%ROWCOUNT);
5524: FOR i in 1..l_del_rows LOOP
5525: msc_sch_wb.atp_debug('Add_Offset_Supplies: Supply Id '|| l_orig_supply_id(i) ||
5526: ' Offset Supply Id ' || x_supply_id(i));
5527: END LOOP;

Line 5525: msc_sch_wb.atp_debug('Add_Offset_Supplies: Supply Id '|| l_orig_supply_id(i) ||

5521:
5522: IF PG_DEBUG in ('Y', 'C') THEN
5523: msc_sch_wb.atp_debug('Add_Offset_Supplies: Number of rows Updated '|| SQL%ROWCOUNT);
5524: FOR i in 1..l_del_rows LOOP
5525: msc_sch_wb.atp_debug('Add_Offset_Supplies: Supply Id '|| l_orig_supply_id(i) ||
5526: ' Offset Supply Id ' || x_supply_id(i));
5527: END LOOP;
5528: END IF;
5529: -- End Bug 3381464.

Line 5538: msc_sch_wb.atp_debug('Add_Offset_Supplies: ' ||

5534: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
5535: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
5536:
5537: IF PG_DEBUG in ('Y', 'C') THEN
5538: msc_sch_wb.atp_debug('Add_Offset_Supplies: ' ||
5539: ' before insert into' || ' msc_alloc_supplies');
5540: END IF;
5541:
5542: -- CTO_PF_PRJ_2 relief_type already set above.

Line 5602: msc_sch_wb.atp_debug('Supply to be offset ' || l_offset_supply_id(i));

5598: AND map.supply_id = l_offset_supply_id(i); -- Original Supply
5599:
5600: IF PG_DEBUG in ('Y', 'C') THEN
5601: FOR i in 1..x_supply_id.COUNT LOOP
5602: msc_sch_wb.atp_debug('Supply to be offset ' || l_offset_supply_id(i));
5603: msc_sch_wb.atp_debug('Actual Item ' || x_inv_item_id(i));
5604: msc_sch_wb.atp_debug('Relief Qty' || l_supply_qty(i));
5605: msc_sch_wb.atp_debug('New Supply ' || x_supply_id(i));
5606: msc_sch_wb.atp_debug('Add_Offset_Demands: Number of rows inserted '||

Line 5603: msc_sch_wb.atp_debug('Actual Item ' || x_inv_item_id(i));

5599:
5600: IF PG_DEBUG in ('Y', 'C') THEN
5601: FOR i in 1..x_supply_id.COUNT LOOP
5602: msc_sch_wb.atp_debug('Supply to be offset ' || l_offset_supply_id(i));
5603: msc_sch_wb.atp_debug('Actual Item ' || x_inv_item_id(i));
5604: msc_sch_wb.atp_debug('Relief Qty' || l_supply_qty(i));
5605: msc_sch_wb.atp_debug('New Supply ' || x_supply_id(i));
5606: msc_sch_wb.atp_debug('Add_Offset_Demands: Number of rows inserted '||
5607: 'For Supply id '|| l_offset_supply_id(i) ||

Line 5604: msc_sch_wb.atp_debug('Relief Qty' || l_supply_qty(i));

5600: IF PG_DEBUG in ('Y', 'C') THEN
5601: FOR i in 1..x_supply_id.COUNT LOOP
5602: msc_sch_wb.atp_debug('Supply to be offset ' || l_offset_supply_id(i));
5603: msc_sch_wb.atp_debug('Actual Item ' || x_inv_item_id(i));
5604: msc_sch_wb.atp_debug('Relief Qty' || l_supply_qty(i));
5605: msc_sch_wb.atp_debug('New Supply ' || x_supply_id(i));
5606: msc_sch_wb.atp_debug('Add_Offset_Demands: Number of rows inserted '||
5607: 'For Supply id '|| l_offset_supply_id(i) ||
5608: ' with offset/relief_type = 6 is ' || SQL%BULK_ROWCOUNT(i));

Line 5605: msc_sch_wb.atp_debug('New Supply ' || x_supply_id(i));

5601: FOR i in 1..x_supply_id.COUNT LOOP
5602: msc_sch_wb.atp_debug('Supply to be offset ' || l_offset_supply_id(i));
5603: msc_sch_wb.atp_debug('Actual Item ' || x_inv_item_id(i));
5604: msc_sch_wb.atp_debug('Relief Qty' || l_supply_qty(i));
5605: msc_sch_wb.atp_debug('New Supply ' || x_supply_id(i));
5606: msc_sch_wb.atp_debug('Add_Offset_Demands: Number of rows inserted '||
5607: 'For Supply id '|| l_offset_supply_id(i) ||
5608: ' with offset/relief_type = 6 is ' || SQL%BULK_ROWCOUNT(i));
5609: END LOOP;

Line 5606: msc_sch_wb.atp_debug('Add_Offset_Demands: Number of rows inserted '||

5602: msc_sch_wb.atp_debug('Supply to be offset ' || l_offset_supply_id(i));
5603: msc_sch_wb.atp_debug('Actual Item ' || x_inv_item_id(i));
5604: msc_sch_wb.atp_debug('Relief Qty' || l_supply_qty(i));
5605: msc_sch_wb.atp_debug('New Supply ' || x_supply_id(i));
5606: msc_sch_wb.atp_debug('Add_Offset_Demands: Number of rows inserted '||
5607: 'For Supply id '|| l_offset_supply_id(i) ||
5608: ' with offset/relief_type = 6 is ' || SQL%BULK_ROWCOUNT(i));
5609: END LOOP;
5610: msc_sch_wb.atp_debug('Add_Offset_Supplies: Number of Alloc rows inserted '||

Line 5610: msc_sch_wb.atp_debug('Add_Offset_Supplies: Number of Alloc rows inserted '||

5606: msc_sch_wb.atp_debug('Add_Offset_Demands: Number of rows inserted '||
5607: 'For Supply id '|| l_offset_supply_id(i) ||
5608: ' with offset/relief_type = 6 is ' || SQL%BULK_ROWCOUNT(i));
5609: END LOOP;
5610: msc_sch_wb.atp_debug('Add_Offset_Supplies: Number of Alloc rows inserted '||
5611: 'with offset/relief_type = ' ||l_offset_type || 'is ' || SQL%ROWCOUNT);
5612: END IF;
5613:
5614: -- CTO_PF_PRJ_2

Line 5629: msc_sch_wb.atp_debug('* End Add_Offset_Supplies *');

5625: END IF;
5626:
5627:
5628: IF PG_DEBUG in ('Y', 'C') THEN
5629: msc_sch_wb.atp_debug('***** End Add_Offset_Supplies *****');
5630: END IF;
5631:
5632: EXCEPTION
5633: WHEN OTHERS THEN

Line 5650: msc_sch_wb.atp_debug('Add_Offset_Supplies: Number of rows Updated '||

5646: AND map1.relief_type = NVL(l_offset_type, 2) -- PO
5647: AND map1.inventory_item_id = x_inv_item_id(i)
5648: AND map1.supply_id = l_orig_supply_id(i);
5649: IF PG_DEBUG in ('Y', 'C') THEN
5650: msc_sch_wb.atp_debug('Add_Offset_Supplies: Number of rows Updated '||
5651: SQL%ROWCOUNT);
5652: END IF;
5653:
5654: EXCEPTION

Line 5657: msc_sch_wb.atp_debug('Add_Offset_Supplies: ' ||

5653:
5654: EXCEPTION
5655: WHEN OTHERS THEN
5656: IF PG_DEBUG in ('Y', 'C') THEN
5657: msc_sch_wb.atp_debug('Add_Offset_Supplies: ' ||
5658: 'error in updating offset supplies = '|| sqlerrm );
5659: END IF;
5660: END;
5661: -- End Bug 3381464.

Line 5665: msc_sch_wb.atp_debug('Add_Offset_Supplies: ' ||

5661: -- End Bug 3381464.
5662:
5663: my_sqlcode := SQLCODE;
5664: IF PG_DEBUG in ('Y', 'C') THEN
5665: msc_sch_wb.atp_debug('Add_Offset_Supplies: ' ||
5666: 'error in insert row: sqlcode = '|| to_char(my_sqlcode));
5667: msc_sch_wb.atp_debug('Add_Offset_Supplies: ERROR- ' || sqlerrm );
5668: END IF;
5669:

Line 5667: msc_sch_wb.atp_debug('Add_Offset_Supplies: ERROR- ' || sqlerrm );

5663: my_sqlcode := SQLCODE;
5664: IF PG_DEBUG in ('Y', 'C') THEN
5665: msc_sch_wb.atp_debug('Add_Offset_Supplies: ' ||
5666: 'error in insert row: sqlcode = '|| to_char(my_sqlcode));
5667: msc_sch_wb.atp_debug('Add_Offset_Supplies: ERROR- ' || sqlerrm );
5668: END IF;
5669:
5670: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5671: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME , 'Add_Offset_Supplies');

Line 5722: msc_sch_wb.atp_debug('* Begin Add_Offset_Resource_Reqs *');

5718: l_offset_type NUMBER;
5719: BEGIN
5720:
5721: IF PG_DEBUG in ('Y', 'C') THEN
5722: msc_sch_wb.atp_debug('***** Begin Add_Offset_Resource_Reqs *****');
5723: END IF;
5724: IF PG_DEBUG in ('Y', 'C') THEN
5725: msc_sch_wb.atp_debug('Add_Offset_Resource_Reqs: ' ||
5726: 'Offsetting msc_resource_requirements for identifier = '

Line 5725: msc_sch_wb.atp_debug('Add_Offset_Resource_Reqs: ' ||

5721: IF PG_DEBUG in ('Y', 'C') THEN
5722: msc_sch_wb.atp_debug('***** Begin Add_Offset_Resource_Reqs *****');
5723: END IF;
5724: IF PG_DEBUG in ('Y', 'C') THEN
5725: msc_sch_wb.atp_debug('Add_Offset_Resource_Reqs: ' ||
5726: 'Offsetting msc_resource_requirements for identifier = '
5727: || p_identifier ||' : plan id = '||p_plan_id);
5728: msc_sch_wb.atp_debug('Add_Offset_Resource_Reqs: Config Line Id = ' || p_config_line_id );
5729: END IF ;

Line 5728: msc_sch_wb.atp_debug('Add_Offset_Resource_Reqs: Config Line Id = ' || p_config_line_id );

5724: IF PG_DEBUG in ('Y', 'C') THEN
5725: msc_sch_wb.atp_debug('Add_Offset_Resource_Reqs: ' ||
5726: 'Offsetting msc_resource_requirements for identifier = '
5727: || p_identifier ||' : plan id = '||p_plan_id);
5728: msc_sch_wb.atp_debug('Add_Offset_Resource_Reqs: Config Line Id = ' || p_config_line_id );
5729: END IF ;
5730:
5731: x_return_status := FND_API.G_RET_STS_SUCCESS;
5732:

Line 5864: msc_sch_wb.atp_debug('Add_Offset_Resource_Reqs: ' ||

5860:
5861: l_del_rows := x_res_transactions.COUNT;
5862:
5863: IF PG_DEBUG in ('Y', 'C') THEN
5864: msc_sch_wb.atp_debug('Add_Offset_Resource_Reqs: ' ||
5865: 'Total Rows to add = ' || l_del_rows );
5866: END IF;
5867: FORALL i in 1..l_del_rows
5868: INSERT into msc_resource_requirements

Line 5923: msc_sch_wb.atp_debug('Add_Offset_Resource_Reqs: Number of rows inserted '||

5919: l_sysdate,
5920: l_user_id ) ;
5921:
5922: IF PG_DEBUG in ('Y', 'C') THEN
5923: msc_sch_wb.atp_debug('Add_Offset_Resource_Reqs: Number of rows inserted '||
5924: SQL%ROWCOUNT);
5925: END IF;
5926:
5927:

Line 5929: msc_sch_wb.atp_debug('* End Add_Offset_Resource_Reqs *');

5925: END IF;
5926:
5927:
5928: IF PG_DEBUG in ('Y', 'C') THEN
5929: msc_sch_wb.atp_debug('***** End Add_Offset_Resource_Reqs *****');
5930: END IF;
5931: EXCEPTION
5932: WHEN OTHERS THEN
5933: my_sqlcode := SQLCODE;

Line 5935: msc_sch_wb.atp_debug('Add_Offset_Resource_Reqs: ' ||

5931: EXCEPTION
5932: WHEN OTHERS THEN
5933: my_sqlcode := SQLCODE;
5934: IF PG_DEBUG in ('Y', 'C') THEN
5935: msc_sch_wb.atp_debug('Add_Offset_Resource_Reqs: ' ||
5936: 'error in processing: sqlcode = '|| to_char(my_sqlcode));
5937: msc_sch_wb.atp_debug('Add_Offset_Resource_Reqs: ' ||
5938: 'error in processing: errmsg = '|| sqlerrm );
5939: END IF;

Line 5937: msc_sch_wb.atp_debug('Add_Offset_Resource_Reqs: ' ||

5933: my_sqlcode := SQLCODE;
5934: IF PG_DEBUG in ('Y', 'C') THEN
5935: msc_sch_wb.atp_debug('Add_Offset_Resource_Reqs: ' ||
5936: 'error in processing: sqlcode = '|| to_char(my_sqlcode));
5937: msc_sch_wb.atp_debug('Add_Offset_Resource_Reqs: ' ||
5938: 'error in processing: errmsg = '|| sqlerrm );
5939: END IF;
5940:
5941: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 5977: msc_sch_wb.atp_debug('Begin Add_Offset_Data Procedure**');

5973: l_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5974: BEGIN
5975:
5976: IF PG_DEBUG in ('Y', 'C') THEN
5977: msc_sch_wb.atp_debug('**********Begin Add_Offset_Data Procedure************');
5978: msc_sch_wb.atp_debug('Add_Offset_Data p_identifier :' || p_identifier);
5979: msc_sch_wb.atp_debug('Add_Offset_Data p_config_line_id :' || p_config_line_id);
5980: msc_sch_wb.atp_debug('Add_Offset_Data p_plan_id :' || p_plan_id);
5981: msc_sch_wb.atp_debug('Add_Offset_Data p_refresh_number :' || p_refresh_number);

Line 5978: msc_sch_wb.atp_debug('Add_Offset_Data p_identifier :' || p_identifier);

5974: BEGIN
5975:
5976: IF PG_DEBUG in ('Y', 'C') THEN
5977: msc_sch_wb.atp_debug('**********Begin Add_Offset_Data Procedure************');
5978: msc_sch_wb.atp_debug('Add_Offset_Data p_identifier :' || p_identifier);
5979: msc_sch_wb.atp_debug('Add_Offset_Data p_config_line_id :' || p_config_line_id);
5980: msc_sch_wb.atp_debug('Add_Offset_Data p_plan_id :' || p_plan_id);
5981: msc_sch_wb.atp_debug('Add_Offset_Data p_refresh_number :' || p_refresh_number);
5982: msc_sch_wb.atp_debug('Add_Offset_Data p_order_number :' || p_order_number);

Line 5979: msc_sch_wb.atp_debug('Add_Offset_Data p_config_line_id :' || p_config_line_id);

5975:
5976: IF PG_DEBUG in ('Y', 'C') THEN
5977: msc_sch_wb.atp_debug('**********Begin Add_Offset_Data Procedure************');
5978: msc_sch_wb.atp_debug('Add_Offset_Data p_identifier :' || p_identifier);
5979: msc_sch_wb.atp_debug('Add_Offset_Data p_config_line_id :' || p_config_line_id);
5980: msc_sch_wb.atp_debug('Add_Offset_Data p_plan_id :' || p_plan_id);
5981: msc_sch_wb.atp_debug('Add_Offset_Data p_refresh_number :' || p_refresh_number);
5982: msc_sch_wb.atp_debug('Add_Offset_Data p_order_number :' || p_order_number);
5983: END IF;

Line 5980: msc_sch_wb.atp_debug('Add_Offset_Data p_plan_id :' || p_plan_id);

5976: IF PG_DEBUG in ('Y', 'C') THEN
5977: msc_sch_wb.atp_debug('**********Begin Add_Offset_Data Procedure************');
5978: msc_sch_wb.atp_debug('Add_Offset_Data p_identifier :' || p_identifier);
5979: msc_sch_wb.atp_debug('Add_Offset_Data p_config_line_id :' || p_config_line_id);
5980: msc_sch_wb.atp_debug('Add_Offset_Data p_plan_id :' || p_plan_id);
5981: msc_sch_wb.atp_debug('Add_Offset_Data p_refresh_number :' || p_refresh_number);
5982: msc_sch_wb.atp_debug('Add_Offset_Data p_order_number :' || p_order_number);
5983: END IF;
5984:

Line 5981: msc_sch_wb.atp_debug('Add_Offset_Data p_refresh_number :' || p_refresh_number);

5977: msc_sch_wb.atp_debug('**********Begin Add_Offset_Data Procedure************');
5978: msc_sch_wb.atp_debug('Add_Offset_Data p_identifier :' || p_identifier);
5979: msc_sch_wb.atp_debug('Add_Offset_Data p_config_line_id :' || p_config_line_id);
5980: msc_sch_wb.atp_debug('Add_Offset_Data p_plan_id :' || p_plan_id);
5981: msc_sch_wb.atp_debug('Add_Offset_Data p_refresh_number :' || p_refresh_number);
5982: msc_sch_wb.atp_debug('Add_Offset_Data p_order_number :' || p_order_number);
5983: END IF;
5984:
5985: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5982: msc_sch_wb.atp_debug('Add_Offset_Data p_order_number :' || p_order_number);

5978: msc_sch_wb.atp_debug('Add_Offset_Data p_identifier :' || p_identifier);
5979: msc_sch_wb.atp_debug('Add_Offset_Data p_config_line_id :' || p_config_line_id);
5980: msc_sch_wb.atp_debug('Add_Offset_Data p_plan_id :' || p_plan_id);
5981: msc_sch_wb.atp_debug('Add_Offset_Data p_refresh_number :' || p_refresh_number);
5982: msc_sch_wb.atp_debug('Add_Offset_Data p_order_number :' || p_order_number);
5983: END IF;
5984:
5985: x_return_status := FND_API.G_RET_STS_SUCCESS;
5986:

Line 5996: msc_sch_wb.atp_debug('Status After Call to Add_Offset_Supplies :' || x_return_status);

5992: p_refresh_number, p_order_number,p_demand_source_type,--cmro
5993: l_inv_supply_items, x_supply_id, x_supply_instance_id, x_return_status); --Bug 3629191
5994:
5995: IF PG_DEBUG in ('Y', 'C') THEN
5996: msc_sch_wb.atp_debug('Status After Call to Add_Offset_Supplies :' || x_return_status);
5997: END IF;
5998:
5999: -- and then call Offset Demands
6000: -- so that only those demands tied to offset supplies are relieved.

Line 6006: msc_sch_wb.atp_debug('Status After Call to Add_Offset_Demands :' || x_return_status);

6002: p_refresh_number, p_order_number,p_demand_source_type,--cmro
6003: l_inv_demand_items, x_demand_id, x_demand_instance_id, x_return_status); --Bug 3629191
6004:
6005: IF PG_DEBUG in ('Y', 'C') THEN
6006: msc_sch_wb.atp_debug('Status After Call to Add_Offset_Demands :' || x_return_status);
6007: END IF;
6008: -- End Bug 3717618 Flip the order of calls ...
6009:
6010: FOR j in 1..l_inv_supply_items.COUNT LOOP

Line 6034: msc_sch_wb.atp_debug('Status After Call to Add_Offset_Resource_Reqs :'

6030: p_refresh_number, p_order_number,p_demand_source_type,--cmro
6031: l_inv_supply_items, x_res_transactions, x_res_instance_id, x_return_status); --Bug 3629191
6032:
6033: IF PG_DEBUG in ('Y', 'C') THEN
6034: msc_sch_wb.atp_debug('Status After Call to Add_Offset_Resource_Reqs :'
6035: || x_return_status);
6036: END IF;
6037:
6038:

Line 6043: msc_sch_wb.atp_debug('End Add_Offset_Data Procedure**');

6039: -- Finally assign to output list
6040: x_inv_item_id := l_inv_demand_items;
6041:
6042: IF PG_DEBUG in ('Y', 'C') THEN
6043: msc_sch_wb.atp_debug('**********End Add_Offset_Data Procedure************');
6044: END IF;
6045:
6046: EXCEPTION
6047: WHEN OTHERS THEN

Line 6053: msc_sch_wb.atp_debug('Add_Offset_Data: ERROR' || sqlerrm );

6049: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Add_Offset_Data');
6050: END IF;
6051:
6052: IF PG_DEBUG in ('Y', 'C') THEN
6053: msc_sch_wb.atp_debug('Add_Offset_Data: ERROR' || sqlerrm );
6054: END IF;
6055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6056: -- Bug 3319810 Enable exception generation.
6057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6080: msc_sch_wb.atp_debug('Begin Remove_Offset_Demands Procedure**');

6076: -- End CTO_PF_PRJ_2 Impacts
6077:
6078: BEGIN
6079: IF PG_DEBUG in ('Y', 'C') THEN
6080: msc_sch_wb.atp_debug('**********Begin Remove_Offset_Demands Procedure************');
6081: END IF;
6082: IF PG_DEBUG in ('Y', 'C') THEN
6083: FOR i in 1..p_del_demand_ids.COUNT LOOP
6084: msc_sch_wb.atp_debug('Remove_Offset_Demands: ' ||

Line 6084: msc_sch_wb.atp_debug('Remove_Offset_Demands: ' ||

6080: msc_sch_wb.atp_debug('**********Begin Remove_Offset_Demands Procedure************');
6081: END IF;
6082: IF PG_DEBUG in ('Y', 'C') THEN
6083: FOR i in 1..p_del_demand_ids.COUNT LOOP
6084: msc_sch_wb.atp_debug('Remove_Offset_Demands: ' ||
6085: 'p_del_demand_ids('||i||') = '|| p_del_demand_ids(i)||
6086: --'p_inv_item_ids('||i||') = '|| p_inv_item_ids(i)||
6087: 'p_atp_peg_demands_plan_ids('||i||') = '|| p_atp_peg_demands_plan_ids(i)
6088: --'p_plan_ids('||i||') = '|| p_plan_ids(i)||

Line 6136: msc_sch_wb.atp_debug('For Demand id '|| p_del_demand_ids(m)||': updated '||

6132:
6133: -- Count how many rows were updated for each demand id
6134: IF PG_DEBUG in ('Y', 'C') THEN
6135: FOR m IN 1..p_del_demand_ids.COUNT LOOP
6136: msc_sch_wb.atp_debug('For Demand id '|| p_del_demand_ids(m)||': updated '||
6137: SQL%BULK_ROWCOUNT(m)||' records');
6138: END LOOP;
6139: END IF;
6140:

Line 6147: msc_sch_wb.atp_debug('Remove_Offset_Demands: before delete from ' ||

6143: -- with the introduction of CTO_PF_PRJ_2 impacts.
6144: -- Relief_Type 7 can get created irrespective of allocation profiles.
6145:
6146: IF PG_DEBUG in ('Y', 'C') THEN
6147: msc_sch_wb.atp_debug('Remove_Offset_Demands: before delete from ' ||
6148: ' msc_alloc_demands');
6149: END IF;
6150:
6151: --Bug 3629191

Line 6180: msc_sch_wb.atp_debug('For Demand id '|| p_del_demand_ids(m)||': updated '||

6176:
6177: -- Count how many rows were updated for each demand id
6178: IF PG_DEBUG in ('Y', 'C') THEN
6179: FOR m IN 1..p_del_demand_ids.COUNT LOOP
6180: msc_sch_wb.atp_debug('For Demand id '|| p_del_demand_ids(m)||': updated '||
6181: SQL%BULK_ROWCOUNT(m)||' records');
6182: END LOOP;
6183: END IF;
6184:

Line 6186: msc_sch_wb.atp_debug('End Remove_Offset_Demands Procedure**');

6182: END LOOP;
6183: END IF;
6184:
6185: IF PG_DEBUG in ('Y', 'C') THEN
6186: msc_sch_wb.atp_debug('**********End Remove_Offset_Demands Procedure************');
6187: END IF;
6188:
6189: EXCEPTION
6190: WHEN OTHERS THEN

Line 6196: msc_sch_wb.atp_debug('Remove_Offset_Demands: ERROR' || sqlerrm );

6192: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Remove_Offset_Demands');
6193: END IF;
6194:
6195: IF PG_DEBUG in ('Y', 'C') THEN
6196: msc_sch_wb.atp_debug('Remove_Offset_Demands: ERROR' || sqlerrm );
6197: END IF;
6198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6199: -- Bug 3319810 Enable exception generation.
6200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6224: msc_sch_wb.atp_debug('Begin Remove_Offset_Supplies Procedure**');

6220: -- End CTO_PF_PRJ_2 Impacts
6221:
6222: BEGIN
6223: IF PG_DEBUG in ('Y', 'C') THEN
6224: msc_sch_wb.atp_debug('**********Begin Remove_Offset_Supplies Procedure************');
6225: END IF;
6226: IF PG_DEBUG in ('Y', 'C') THEN
6227: FOR i in 1..p_del_supply_ids.COUNT LOOP
6228: msc_sch_wb.atp_debug('Remove_Offset_Supplies: ' ||

Line 6228: msc_sch_wb.atp_debug('Remove_Offset_Supplies: ' ||

6224: msc_sch_wb.atp_debug('**********Begin Remove_Offset_Supplies Procedure************');
6225: END IF;
6226: IF PG_DEBUG in ('Y', 'C') THEN
6227: FOR i in 1..p_del_supply_ids.COUNT LOOP
6228: msc_sch_wb.atp_debug('Remove_Offset_Supplies: ' ||
6229: 'p_del_supply_ids('||i||') = '|| p_del_supply_ids(i)||
6230: --'p_inv_item_ids('||i||') = '|| p_inv_item_ids(i)||
6231: --'p_plan_ids('||i||') = '|| p_plan_ids(i)||
6232: 'p_atp_peg_supplies_plan_ids('||i||') = '|| p_atp_peg_supplies_plan_ids(i)

Line 6272: msc_sch_wb.atp_debug('Remove_Offset_Supplies: Number of rows Updated '||

6268: --AND map1.inventory_item_id = p_inv_item_ids(m) -- Bug 3629191
6269: AND map1.offset_supply_id = p_del_supply_ids(m);
6270:
6271: IF PG_DEBUG in ('Y', 'C') THEN
6272: msc_sch_wb.atp_debug('Remove_Offset_Supplies: Number of rows Updated '||
6273: SQL%ROWCOUNT);
6274: END IF;
6275: -- End Bug 3381464.
6276:

Line 6317: msc_sch_wb.atp_debug('For Supply id '|| p_del_supply_ids(m)||': updated '||

6313:
6314: -- Count how many rows were updated for each supply id
6315: IF PG_DEBUG in ('Y', 'C') THEN
6316: FOR m IN 1..p_del_supply_ids.COUNT LOOP
6317: msc_sch_wb.atp_debug('For Supply id '|| p_del_supply_ids(m)||': updated '||
6318: SQL%BULK_ROWCOUNT(m)||' records');
6319: END LOOP;
6320: END IF;
6321:

Line 6328: msc_sch_wb.atp_debug('Remove_Offset_Supplies: before delete from ' ||

6324: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6325: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6326:
6327: IF PG_DEBUG in ('Y', 'C') THEN
6328: msc_sch_wb.atp_debug('Remove_Offset_Supplies: before delete from ' ||
6329: ' msc_alloc_supplies');
6330: END IF;
6331:
6332: --Bug 3629191

Line 6361: msc_sch_wb.atp_debug('For Supply id '|| p_del_supply_ids(m)||': updated '||

6357:
6358: -- Count how many rows were updated for each supply id
6359: IF PG_DEBUG in ('Y', 'C') THEN
6360: FOR m IN 1..p_del_supply_ids.COUNT LOOP
6361: msc_sch_wb.atp_debug('For Supply id '|| p_del_supply_ids(m)||': updated '||
6362: SQL%BULK_ROWCOUNT(m)||' records');
6363: END LOOP;
6364: END IF;
6365: END IF;

Line 6368: msc_sch_wb.atp_debug('End Remove_Offset_Supplies Procedure**');

6364: END IF;
6365: END IF;
6366:
6367: IF PG_DEBUG in ('Y', 'C') THEN
6368: msc_sch_wb.atp_debug('**********End Remove_Offset_Supplies Procedure************');
6369: END IF;
6370:
6371: EXCEPTION
6372: WHEN OTHERS THEN

Line 6378: msc_sch_wb.atp_debug('Remove_Offset_Supplies: ERROR' || sqlerrm );

6374: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Remove_Offset_Supplies');
6375: END IF;
6376:
6377: IF PG_DEBUG in ('Y', 'C') THEN
6378: msc_sch_wb.atp_debug('Remove_Offset_Supplies: ERROR' || sqlerrm );
6379: END IF;
6380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6381: -- Bug 3319810 Enable exception generation.
6382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6402: msc_sch_wb.atp_debug('Begin Remove_Offset_Resource_Reqs Procedure**');

6398: i NUMBER;
6399: m PLS_INTEGER := 1;
6400: BEGIN
6401: IF PG_DEBUG in ('Y', 'C') THEN
6402: msc_sch_wb.atp_debug('**********Begin Remove_Offset_Resource_Reqs Procedure************');
6403: END IF;
6404: IF PG_DEBUG in ('Y', 'C') THEN
6405: FOR i in 1..p_del_resrc_reqs.COUNT LOOP
6406: msc_sch_wb.atp_debug('Remove_Offset_Resource_Reqs: ' ||

Line 6406: msc_sch_wb.atp_debug('Remove_Offset_Resource_Reqs: ' ||

6402: msc_sch_wb.atp_debug('**********Begin Remove_Offset_Resource_Reqs Procedure************');
6403: END IF;
6404: IF PG_DEBUG in ('Y', 'C') THEN
6405: FOR i in 1..p_del_resrc_reqs.COUNT LOOP
6406: msc_sch_wb.atp_debug('Remove_Offset_Resource_Reqs: ' ||
6407: 'p_del_resrc_reqs('||i||') = '|| p_del_resrc_reqs(i)||
6408: --'p_inv_item_ids('||i||') = '|| p_inv_item_ids(i)||
6409: --'p_plan_ids('||i||') = '|| p_plan_ids(i)||
6410: --'p_identifiers('||i||') = '|| p_identifiers(i)

Line 6444: msc_sch_wb.atp_debug('For Transaction id '|| p_del_resrc_reqs(m)||': updated '||

6440:
6441: -- Count how many rows were updated for each resource transaction id
6442: IF PG_DEBUG in ('Y', 'C') THEN
6443: FOR m IN 1..p_del_resrc_reqs.COUNT LOOP
6444: msc_sch_wb.atp_debug('For Transaction id '|| p_del_resrc_reqs(m)||': updated '||
6445: SQL%BULK_ROWCOUNT(m)||' records');
6446: END LOOP;
6447: END IF;
6448:

Line 6450: msc_sch_wb.atp_debug('End Remove_Offset_Resource_Reqs Procedure**');

6446: END LOOP;
6447: END IF;
6448:
6449: IF PG_DEBUG in ('Y', 'C') THEN
6450: msc_sch_wb.atp_debug('**********End Remove_Offset_Resource_Reqs Procedure************');
6451: END IF;
6452:
6453: EXCEPTION
6454: WHEN OTHERS THEN

Line 6460: msc_sch_wb.atp_debug('Remove_Offset_Supplies: ERROR' || sqlerrm );

6456: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Remove_Offset_Resource_Reqs');
6457: END IF;
6458:
6459: IF PG_DEBUG in ('Y', 'C') THEN
6460: msc_sch_wb.atp_debug('Remove_Offset_Supplies: ERROR' || sqlerrm );
6461: END IF;
6462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6463: -- Bug 3319810 Enable exception generation.
6464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6485: msc_sch_wb.atp_debug('Begin Remove_Offset_Data Procedure**');

6481: IS
6482: BEGIN
6483:
6484: IF PG_DEBUG in ('Y', 'C') THEN
6485: msc_sch_wb.atp_debug('**********Begin Remove_Offset_Data Procedure************');
6486: END IF;
6487:
6488: x_return_status := FND_API.G_RET_STS_SUCCESS;
6489:

Line 6495: msc_sch_wb.atp_debug('Status After Call to Remove_Offset_Demands :'

6491: p_atp_peg_demands_plan_ids, --Bug 3629191
6492: p_inv_item_ids, p_del_demand_ids,p_demand_source_type, x_return_status);--cmro
6493:
6494: IF PG_DEBUG in ('Y', 'C') THEN
6495: msc_sch_wb.atp_debug('Status After Call to Remove_Offset_Demands :'
6496: || x_return_status);
6497: END IF;
6498:
6499: Remove_Offset_Supplies ( --p_identifiers, p_plan_ids,

Line 6504: msc_sch_wb.atp_debug('Status After Call to Remove_Offset_Supplies :'

6500: p_atp_peg_supplies_plan_ids, --Bug 3629191
6501: p_inv_item_ids, p_del_supply_ids,p_demand_source_type,x_return_status);--cmro
6502:
6503: IF PG_DEBUG in ('Y', 'C') THEN
6504: msc_sch_wb.atp_debug('Status After Call to Remove_Offset_Supplies :'
6505: || x_return_status);
6506: END IF;
6507:
6508: Remove_Offset_Resource_Reqs ( --p_identifiers, p_plan_ids,

Line 6513: msc_sch_wb.atp_debug('Status After Call to Remove_Offset_Resource_Reqs :'

6509: p_atp_peg_res_reqs_plan_ids, --Bug 3629191
6510: p_inv_item_ids, p_del_resrc_reqs,p_demand_source_type,x_return_status);--cmro
6511:
6512: IF PG_DEBUG in ('Y', 'C') THEN
6513: msc_sch_wb.atp_debug('Status After Call to Remove_Offset_Resource_Reqs :'
6514: || x_return_status);
6515: END IF;
6516:
6517: EXCEPTION

Line 6524: msc_sch_wb.atp_debug('Remove_Offset_Data: ERROR' || sqlerrm );

6520: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Remove_Offset_Data');
6521: END IF;
6522:
6523: IF PG_DEBUG in ('Y', 'C') THEN
6524: msc_sch_wb.atp_debug('Remove_Offset_Data: ERROR' || sqlerrm );
6525: END IF;
6526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6527: -- Bug 3319810 Enable exception generation.
6528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6550: msc_sch_wb.atp_debug('* Begin Create_PF_Atp_Pegging Procedure *');

6546:
6547: BEGIN
6548:
6549: IF PG_DEBUG in ('Y', 'C') THEN
6550: msc_sch_wb.atp_debug('***** Begin Create_PF_Atp_Pegging Procedure *****');
6551: msc_sch_wb.atp_debug('Reference Item Id : ' || p_reference_item_id);
6552: msc_sch_wb.atp_debug('Model Line Id p_model_order_line_id : ' || p_model_order_line_id);
6553: msc_sch_wb.atp_debug('Config. Line Id p_config_order_line_id : ' || p_config_order_line_id);
6554: msc_sch_wb.atp_debug('Demand Source Type : ' || p_demand_source_type);

Line 6551: msc_sch_wb.atp_debug('Reference Item Id : ' || p_reference_item_id);

6547: BEGIN
6548:
6549: IF PG_DEBUG in ('Y', 'C') THEN
6550: msc_sch_wb.atp_debug('***** Begin Create_PF_Atp_Pegging Procedure *****');
6551: msc_sch_wb.atp_debug('Reference Item Id : ' || p_reference_item_id);
6552: msc_sch_wb.atp_debug('Model Line Id p_model_order_line_id : ' || p_model_order_line_id);
6553: msc_sch_wb.atp_debug('Config. Line Id p_config_order_line_id : ' || p_config_order_line_id);
6554: msc_sch_wb.atp_debug('Demand Source Type : ' || p_demand_source_type);
6555: msc_sch_wb.atp_debug('SO End Demand Id : ' || p_end_demand_id);

Line 6552: msc_sch_wb.atp_debug('Model Line Id p_model_order_line_id : ' || p_model_order_line_id);

6548:
6549: IF PG_DEBUG in ('Y', 'C') THEN
6550: msc_sch_wb.atp_debug('***** Begin Create_PF_Atp_Pegging Procedure *****');
6551: msc_sch_wb.atp_debug('Reference Item Id : ' || p_reference_item_id);
6552: msc_sch_wb.atp_debug('Model Line Id p_model_order_line_id : ' || p_model_order_line_id);
6553: msc_sch_wb.atp_debug('Config. Line Id p_config_order_line_id : ' || p_config_order_line_id);
6554: msc_sch_wb.atp_debug('Demand Source Type : ' || p_demand_source_type);
6555: msc_sch_wb.atp_debug('SO End Demand Id : ' || p_end_demand_id);
6556: msc_sch_wb.atp_debug('Plan Id : ' || p_plan_id);

Line 6553: msc_sch_wb.atp_debug('Config. Line Id p_config_order_line_id : ' || p_config_order_line_id);

6549: IF PG_DEBUG in ('Y', 'C') THEN
6550: msc_sch_wb.atp_debug('***** Begin Create_PF_Atp_Pegging Procedure *****');
6551: msc_sch_wb.atp_debug('Reference Item Id : ' || p_reference_item_id);
6552: msc_sch_wb.atp_debug('Model Line Id p_model_order_line_id : ' || p_model_order_line_id);
6553: msc_sch_wb.atp_debug('Config. Line Id p_config_order_line_id : ' || p_config_order_line_id);
6554: msc_sch_wb.atp_debug('Demand Source Type : ' || p_demand_source_type);
6555: msc_sch_wb.atp_debug('SO End Demand Id : ' || p_end_demand_id);
6556: msc_sch_wb.atp_debug('Plan Id : ' || p_plan_id);
6557: END IF;

Line 6554: msc_sch_wb.atp_debug('Demand Source Type : ' || p_demand_source_type);

6550: msc_sch_wb.atp_debug('***** Begin Create_PF_Atp_Pegging Procedure *****');
6551: msc_sch_wb.atp_debug('Reference Item Id : ' || p_reference_item_id);
6552: msc_sch_wb.atp_debug('Model Line Id p_model_order_line_id : ' || p_model_order_line_id);
6553: msc_sch_wb.atp_debug('Config. Line Id p_config_order_line_id : ' || p_config_order_line_id);
6554: msc_sch_wb.atp_debug('Demand Source Type : ' || p_demand_source_type);
6555: msc_sch_wb.atp_debug('SO End Demand Id : ' || p_end_demand_id);
6556: msc_sch_wb.atp_debug('Plan Id : ' || p_plan_id);
6557: END IF;
6558:

Line 6555: msc_sch_wb.atp_debug('SO End Demand Id : ' || p_end_demand_id);

6551: msc_sch_wb.atp_debug('Reference Item Id : ' || p_reference_item_id);
6552: msc_sch_wb.atp_debug('Model Line Id p_model_order_line_id : ' || p_model_order_line_id);
6553: msc_sch_wb.atp_debug('Config. Line Id p_config_order_line_id : ' || p_config_order_line_id);
6554: msc_sch_wb.atp_debug('Demand Source Type : ' || p_demand_source_type);
6555: msc_sch_wb.atp_debug('SO End Demand Id : ' || p_end_demand_id);
6556: msc_sch_wb.atp_debug('Plan Id : ' || p_plan_id);
6557: END IF;
6558:
6559: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6556: msc_sch_wb.atp_debug('Plan Id : ' || p_plan_id);

6552: msc_sch_wb.atp_debug('Model Line Id p_model_order_line_id : ' || p_model_order_line_id);
6553: msc_sch_wb.atp_debug('Config. Line Id p_config_order_line_id : ' || p_config_order_line_id);
6554: msc_sch_wb.atp_debug('Demand Source Type : ' || p_demand_source_type);
6555: msc_sch_wb.atp_debug('SO End Demand Id : ' || p_end_demand_id);
6556: msc_sch_wb.atp_debug('Plan Id : ' || p_plan_id);
6557: END IF;
6558:
6559: x_return_status := FND_API.G_RET_STS_SUCCESS;
6560:

Line 6616: msc_sch_wb.atp_debug('Create_PF_Atp_Pegging: Number of rows inserted Stage-1 '||

6612: AND msi.organization_id = alocd.organization_id
6613: AND msi.inventory_item_id = alocd.inventory_item_id;
6614:
6615: IF PG_DEBUG in ('Y', 'C') THEN
6616: msc_sch_wb.atp_debug('Create_PF_Atp_Pegging: Number of rows inserted Stage-1 '||
6617: SQL%ROWCOUNT);
6618: END IF;
6619:
6620: -- Now Create Rest of the Records.

Line 6661: msc_sch_wb.atp_debug('Create_PF_Atp_Pegging: Number of rows inserted Stage-2 '||

6657: AND relief_type = 7
6658: );
6659:
6660: IF PG_DEBUG in ('Y', 'C') THEN
6661: msc_sch_wb.atp_debug('Create_PF_Atp_Pegging: Number of rows inserted Stage-2 '||
6662: SQL%ROWCOUNT);
6663: END IF;
6664:
6665: IF PG_DEBUG in ('Y', 'C') THEN

Line 6666: msc_sch_wb.atp_debug('* End Create_PF_Atp_Pegging Procedure *');

6662: SQL%ROWCOUNT);
6663: END IF;
6664:
6665: IF PG_DEBUG in ('Y', 'C') THEN
6666: msc_sch_wb.atp_debug('***** End Create_PF_Atp_Pegging Procedure *****');
6667: END IF;
6668:
6669: EXCEPTION
6670: WHEN OTHERS THEN

Line 6673: msc_sch_wb.atp_debug('Create_PF_Atp_Pegging: ' || my_sqlcode ||

6669: EXCEPTION
6670: WHEN OTHERS THEN
6671: my_sqlcode := SQLCODE;
6672: IF PG_DEBUG in ('Y', 'C') THEN
6673: msc_sch_wb.atp_debug('Create_PF_Atp_Pegging: ' || my_sqlcode ||
6674: ' error encountered while creating ATP Pegging : ERROR = '|| sqlerrm);
6675: END IF;
6676:
6677: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 6720: msc_sch_wb.atp_debug('* Begin Create_Atp_Pegging Procedure *');

6716:
6717: BEGIN
6718:
6719: IF PG_DEBUG in ('Y', 'C') THEN
6720: msc_sch_wb.atp_debug('***** Begin Create_Atp_Pegging Procedure *****');
6721: msc_sch_wb.atp_debug('End Pegging Id p_identifier : ' || p_identifier);
6722: msc_sch_wb.atp_debug('Instance Id p_instance_id : ' || p_instance_id);
6723: msc_sch_wb.atp_debug('Old Plan Id : ' || p_old_plan_id);
6724: msc_sch_wb.atp_debug('Model Line Id p_model_order_line_id : ' || p_model_order_line_id);

Line 6721: msc_sch_wb.atp_debug('End Pegging Id p_identifier : ' || p_identifier);

6717: BEGIN
6718:
6719: IF PG_DEBUG in ('Y', 'C') THEN
6720: msc_sch_wb.atp_debug('***** Begin Create_Atp_Pegging Procedure *****');
6721: msc_sch_wb.atp_debug('End Pegging Id p_identifier : ' || p_identifier);
6722: msc_sch_wb.atp_debug('Instance Id p_instance_id : ' || p_instance_id);
6723: msc_sch_wb.atp_debug('Old Plan Id : ' || p_old_plan_id);
6724: msc_sch_wb.atp_debug('Model Line Id p_model_order_line_id : ' || p_model_order_line_id);
6725: msc_sch_wb.atp_debug('Config. Line Id p_config_order_line_id : ' || p_config_order_line_id);

Line 6722: msc_sch_wb.atp_debug('Instance Id p_instance_id : ' || p_instance_id);

6718:
6719: IF PG_DEBUG in ('Y', 'C') THEN
6720: msc_sch_wb.atp_debug('***** Begin Create_Atp_Pegging Procedure *****');
6721: msc_sch_wb.atp_debug('End Pegging Id p_identifier : ' || p_identifier);
6722: msc_sch_wb.atp_debug('Instance Id p_instance_id : ' || p_instance_id);
6723: msc_sch_wb.atp_debug('Old Plan Id : ' || p_old_plan_id);
6724: msc_sch_wb.atp_debug('Model Line Id p_model_order_line_id : ' || p_model_order_line_id);
6725: msc_sch_wb.atp_debug('Config. Line Id p_config_order_line_id : ' || p_config_order_line_id);
6726: msc_sch_wb.atp_debug('Demand. Source Type p_demand_source_type : ' || p_demand_source_type);

Line 6723: msc_sch_wb.atp_debug('Old Plan Id : ' || p_old_plan_id);

6719: IF PG_DEBUG in ('Y', 'C') THEN
6720: msc_sch_wb.atp_debug('***** Begin Create_Atp_Pegging Procedure *****');
6721: msc_sch_wb.atp_debug('End Pegging Id p_identifier : ' || p_identifier);
6722: msc_sch_wb.atp_debug('Instance Id p_instance_id : ' || p_instance_id);
6723: msc_sch_wb.atp_debug('Old Plan Id : ' || p_old_plan_id);
6724: msc_sch_wb.atp_debug('Model Line Id p_model_order_line_id : ' || p_model_order_line_id);
6725: msc_sch_wb.atp_debug('Config. Line Id p_config_order_line_id : ' || p_config_order_line_id);
6726: msc_sch_wb.atp_debug('Demand. Source Type p_demand_source_type : ' || p_demand_source_type);
6727: END IF;

Line 6724: msc_sch_wb.atp_debug('Model Line Id p_model_order_line_id : ' || p_model_order_line_id);

6720: msc_sch_wb.atp_debug('***** Begin Create_Atp_Pegging Procedure *****');
6721: msc_sch_wb.atp_debug('End Pegging Id p_identifier : ' || p_identifier);
6722: msc_sch_wb.atp_debug('Instance Id p_instance_id : ' || p_instance_id);
6723: msc_sch_wb.atp_debug('Old Plan Id : ' || p_old_plan_id);
6724: msc_sch_wb.atp_debug('Model Line Id p_model_order_line_id : ' || p_model_order_line_id);
6725: msc_sch_wb.atp_debug('Config. Line Id p_config_order_line_id : ' || p_config_order_line_id);
6726: msc_sch_wb.atp_debug('Demand. Source Type p_demand_source_type : ' || p_demand_source_type);
6727: END IF;
6728:

Line 6725: msc_sch_wb.atp_debug('Config. Line Id p_config_order_line_id : ' || p_config_order_line_id);

6721: msc_sch_wb.atp_debug('End Pegging Id p_identifier : ' || p_identifier);
6722: msc_sch_wb.atp_debug('Instance Id p_instance_id : ' || p_instance_id);
6723: msc_sch_wb.atp_debug('Old Plan Id : ' || p_old_plan_id);
6724: msc_sch_wb.atp_debug('Model Line Id p_model_order_line_id : ' || p_model_order_line_id);
6725: msc_sch_wb.atp_debug('Config. Line Id p_config_order_line_id : ' || p_config_order_line_id);
6726: msc_sch_wb.atp_debug('Demand. Source Type p_demand_source_type : ' || p_demand_source_type);
6727: END IF;
6728:
6729: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6726: msc_sch_wb.atp_debug('Demand. Source Type p_demand_source_type : ' || p_demand_source_type);

6722: msc_sch_wb.atp_debug('Instance Id p_instance_id : ' || p_instance_id);
6723: msc_sch_wb.atp_debug('Old Plan Id : ' || p_old_plan_id);
6724: msc_sch_wb.atp_debug('Model Line Id p_model_order_line_id : ' || p_model_order_line_id);
6725: msc_sch_wb.atp_debug('Config. Line Id p_config_order_line_id : ' || p_config_order_line_id);
6726: msc_sch_wb.atp_debug('Demand. Source Type p_demand_source_type : ' || p_demand_source_type);
6727: END IF;
6728:
6729: x_return_status := FND_API.G_RET_STS_SUCCESS;
6730:

Line 6764: msc_sch_wb.atp_debug('Create_Atp_Pegging: Number of rows deleted '||

6760: 100,
6761: p_demand_source_type,
6762: -1); --CMRO
6763: IF PG_DEBUG in ('Y', 'C') THEN
6764: msc_sch_wb.atp_debug('Create_Atp_Pegging: Number of rows deleted '||
6765: SQL%ROWCOUNT);
6766: END IF;
6767: EXCEPTION
6768: WHEN OTHERS THEN

Line 6770: msc_sch_wb.atp_debug('Create_Atp_Pegging: Error '|| sqlerrm);

6766: END IF;
6767: EXCEPTION
6768: WHEN OTHERS THEN
6769: IF PG_DEBUG in ('Y', 'C') THEN
6770: msc_sch_wb.atp_debug('Create_Atp_Pegging: Error '|| sqlerrm);
6771: END IF;
6772:
6773: END;
6774:

Line 6857: msc_sch_wb.atp_debug('Create_Atp_Pegging: Insert SQL Statement '||

6853: and model_sd_flag = 1' -- ensure that we only obtain pegging for things in the order.
6854: ;
6855:
6856: IF PG_DEBUG in ('Y', 'C') THEN
6857: msc_sch_wb.atp_debug('Create_Atp_Pegging: Insert SQL Statement '||
6858: l_sql_stmt_1);
6859: END IF;
6860:
6861: EXECUTE IMMEDIATE l_sql_stmt_1 USING

Line 6893: msc_sch_wb.atp_debug('Create_Atp_Pegging: Number of rows inserted-1 '||

6889: MSC_ATP_PVT.G_SESSION_ID;
6890: -- End CTO_PF_PRJ_2 Impacts SQL are changed to Dynamic Ones
6891:
6892: IF PG_DEBUG in ('Y', 'C') THEN
6893: msc_sch_wb.atp_debug('Create_Atp_Pegging: Number of rows inserted-1 '||
6894: SQL%ROWCOUNT);
6895: END IF;
6896:
6897: SELECT DEST_INV_ITEM_ID, identifier2,

Line 6913: msc_sch_wb.atp_debug('Create_Atp_Pegging: l_reference_item_id ' ||

6909: AND model_sd_flag = 1
6910: AND session_id = MSC_ATP_PVT.G_SESSION_ID;
6911:
6912: IF PG_DEBUG in ('Y', 'C') THEN
6913: msc_sch_wb.atp_debug('Create_Atp_Pegging: l_reference_item_id ' ||
6914: l_reference_item_id);
6915: -- Bug 3334643 Track the plan_id
6916: msc_sch_wb.atp_debug('Create_Atp_Pegging: l_plan_id ' ||
6917: l_plan_id);

Line 6916: msc_sch_wb.atp_debug('Create_Atp_Pegging: l_plan_id ' ||

6912: IF PG_DEBUG in ('Y', 'C') THEN
6913: msc_sch_wb.atp_debug('Create_Atp_Pegging: l_reference_item_id ' ||
6914: l_reference_item_id);
6915: -- Bug 3334643 Track the plan_id
6916: msc_sch_wb.atp_debug('Create_Atp_Pegging: l_plan_id ' ||
6917: l_plan_id);
6918: -- CTO_PF_PRJ Get End Demand Id
6919: msc_sch_wb.atp_debug('Create_Atp_Pegging: End Demand Id ' ||
6920: l_end_demand_id);

Line 6919: msc_sch_wb.atp_debug('Create_Atp_Pegging: End Demand Id ' ||

6915: -- Bug 3334643 Track the plan_id
6916: msc_sch_wb.atp_debug('Create_Atp_Pegging: l_plan_id ' ||
6917: l_plan_id);
6918: -- CTO_PF_PRJ Get End Demand Id
6919: msc_sch_wb.atp_debug('Create_Atp_Pegging: End Demand Id ' ||
6920: l_end_demand_id);
6921: -- End CTO_PF_PRJ Get End Demand Id
6922: END IF;
6923:

Line 7021: msc_sch_wb.atp_debug('Create_Atp_Pegging: Insert SQL Statement '||

7017: AND session_id = prior session_id
7018: AND record_type in (3,4)';
7019:
7020: IF PG_DEBUG in ('Y', 'C') THEN
7021: msc_sch_wb.atp_debug('Create_Atp_Pegging: Insert SQL Statement '||
7022: l_sql_stmt_1);
7023: END IF;
7024:
7025: EXECUTE IMMEDIATE l_sql_stmt_1 USING

Line 7060: msc_sch_wb.atp_debug('Create_Atp_Pegging: Number of rows inserted '||

7056: MSC_ATP_PVT.G_SESSION_ID;
7057: -- End CTO_PF_PRJ_2 Impacts SQL are changed to Dynamic Ones
7058:
7059: IF PG_DEBUG in ('Y', 'C') THEN
7060: msc_sch_wb.atp_debug('Create_Atp_Pegging: Number of rows inserted '||
7061: SQL%ROWCOUNT);
7062: END IF;
7063:
7064: -- CTO_PF_PRJ Impacts

Line 7079: msc_sch_wb.atp_debug('* End Create_Atp_Pegging Procedure *');

7075: END IF;
7076: -- CTO_PF_PRJ Impacts
7077:
7078: IF PG_DEBUG in ('Y', 'C') THEN
7079: msc_sch_wb.atp_debug('***** End Create_Atp_Pegging Procedure *****');
7080: END IF;
7081:
7082: EXCEPTION
7083: WHEN OTHERS THEN

Line 7086: msc_sch_wb.atp_debug('Create_Atp_Pegging: ' || my_sqlcode ||

7082: EXCEPTION
7083: WHEN OTHERS THEN
7084: my_sqlcode := SQLCODE;
7085: IF PG_DEBUG in ('Y', 'C') THEN
7086: msc_sch_wb.atp_debug('Create_Atp_Pegging: ' || my_sqlcode ||
7087: ' error encountered while creating ATP Pegging : ERROR = '|| sqlerrm);
7088: END IF;
7089:
7090: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN