189: x_return_status := FND_API.G_RET_STS_SUCCESS;
190:
191: If p_atp_rec.inventory_item_id IS NOT NULL Then
192:
193: if aso_debug_pub.g_debug_flag = 'Y' then
194: aso_debug_pub.add('Populate_Output_Table: inside if for p_atp_rec.inventory_item_id',1,'N');
195: end if;
196:
197: For i in p_atp_rec.inventory_item_id.FIRST .. p_atp_rec.inventory_item_id.LAST Loop
190:
191: If p_atp_rec.inventory_item_id IS NOT NULL Then
192:
193: if aso_debug_pub.g_debug_flag = 'Y' then
194: aso_debug_pub.add('Populate_Output_Table: inside if for p_atp_rec.inventory_item_id',1,'N');
195: end if;
196:
197: For i in p_atp_rec.inventory_item_id.FIRST .. p_atp_rec.inventory_item_id.LAST Loop
198:
195: end if;
196:
197: For i in p_atp_rec.inventory_item_id.FIRST .. p_atp_rec.inventory_item_id.LAST Loop
198:
199: if aso_debug_pub.g_debug_flag = 'Y' then
200: aso_debug_pub.add('Populate_Output_Table: inside loop for p_atp_rec.inventory_item_id',1,'N');
201: end if;
202:
203: if p_atp_rec.inventory_item_id.EXISTS(i) then
196:
197: For i in p_atp_rec.inventory_item_id.FIRST .. p_atp_rec.inventory_item_id.LAST Loop
198:
199: if aso_debug_pub.g_debug_flag = 'Y' then
200: aso_debug_pub.add('Populate_Output_Table: inside loop for p_atp_rec.inventory_item_id',1,'N');
201: end if;
202:
203: if p_atp_rec.inventory_item_id.EXISTS(i) then
204:
286: open c_qty_on_hand(p_atp_rec.match_item_id(i), p_atp_rec.source_organization_id(i));
287: fetch c_qty_on_hand into x_aso_atp_tbl(i).quantity_on_hand;
288: close c_qty_on_hand;
289:
290: if aso_debug_pub.g_debug_flag = 'Y' then
291: aso_debug_pub.add('p_atp_rec.match_item_id: ' || p_atp_rec.match_item_id(i),1,'N');
292: aso_debug_pub.add('TAR6653580.994 x_aso_atp_tbl(i).quantity_on_hand: ' || x_aso_atp_tbl(i).quantity_on_hand,1,'N');
293: end if;
294:
287: fetch c_qty_on_hand into x_aso_atp_tbl(i).quantity_on_hand;
288: close c_qty_on_hand;
289:
290: if aso_debug_pub.g_debug_flag = 'Y' then
291: aso_debug_pub.add('p_atp_rec.match_item_id: ' || p_atp_rec.match_item_id(i),1,'N');
292: aso_debug_pub.add('TAR6653580.994 x_aso_atp_tbl(i).quantity_on_hand: ' || x_aso_atp_tbl(i).quantity_on_hand,1,'N');
293: end if;
294:
295: elsif nvl(p_atp_rec.top_model_line_id(i), 0) <> p_atp_rec.identifier(i) and p_atp_rec.ato_model_line_id(i) is null then
288: close c_qty_on_hand;
289:
290: if aso_debug_pub.g_debug_flag = 'Y' then
291: aso_debug_pub.add('p_atp_rec.match_item_id: ' || p_atp_rec.match_item_id(i),1,'N');
292: aso_debug_pub.add('TAR6653580.994 x_aso_atp_tbl(i).quantity_on_hand: ' || x_aso_atp_tbl(i).quantity_on_hand,1,'N');
293: end if;
294:
295: elsif nvl(p_atp_rec.top_model_line_id(i), 0) <> p_atp_rec.identifier(i) and p_atp_rec.ato_model_line_id(i) is null then
296:
297: open c_qty_on_hand(p_atp_rec.inventory_item_id(i), p_atp_rec.source_organization_id(i));
298: fetch c_qty_on_hand into x_aso_atp_tbl(i).quantity_on_hand;
299: close c_qty_on_hand;
300:
301: if aso_debug_pub.g_debug_flag = 'Y' then
302: aso_debug_pub.add('TAR6653580.994 x_aso_atp_tbl(i).quantity_on_hand: ' || x_aso_atp_tbl(i).quantity_on_hand,1,'N');
303: end if;
304:
305: end if;
298: fetch c_qty_on_hand into x_aso_atp_tbl(i).quantity_on_hand;
299: close c_qty_on_hand;
300:
301: if aso_debug_pub.g_debug_flag = 'Y' then
302: aso_debug_pub.add('TAR6653580.994 x_aso_atp_tbl(i).quantity_on_hand: ' || x_aso_atp_tbl(i).quantity_on_hand,1,'N');
303: end if;
304:
305: end if;
306:
307: open c_get_shipment_id(p_atp_rec.demand_source_header_id(i), p_atp_rec.identifier(i));
308: fetch c_get_shipment_id into x_aso_atp_tbl(i).shipment_id;
309: close c_get_shipment_id;
310:
311: if aso_debug_pub.g_debug_flag = 'Y' then
312: aso_debug_pub.add('p_atp_rec.inventory_item_id: ' || p_atp_rec.inventory_item_id(i),1,'N');
313: aso_debug_pub.add('p_atp_rec.inventory_item_name: ' || p_atp_rec.inventory_item_name(i),1,'N');
314: aso_debug_pub.add('p_atp_rec.source_organization_code: ' || p_atp_rec.source_organization_code(i),1,'N');
315: aso_debug_pub.add('p_atp_rec.source_organization_id: ' || p_atp_rec.source_organization_id(i),1,'N');
308: fetch c_get_shipment_id into x_aso_atp_tbl(i).shipment_id;
309: close c_get_shipment_id;
310:
311: if aso_debug_pub.g_debug_flag = 'Y' then
312: aso_debug_pub.add('p_atp_rec.inventory_item_id: ' || p_atp_rec.inventory_item_id(i),1,'N');
313: aso_debug_pub.add('p_atp_rec.inventory_item_name: ' || p_atp_rec.inventory_item_name(i),1,'N');
314: aso_debug_pub.add('p_atp_rec.source_organization_code: ' || p_atp_rec.source_organization_code(i),1,'N');
315: aso_debug_pub.add('p_atp_rec.source_organization_id: ' || p_atp_rec.source_organization_id(i),1,'N');
316: aso_debug_pub.add('p_atp_rec.identifier: ' || p_atp_rec.identifier(i),1,'N');
309: close c_get_shipment_id;
310:
311: if aso_debug_pub.g_debug_flag = 'Y' then
312: aso_debug_pub.add('p_atp_rec.inventory_item_id: ' || p_atp_rec.inventory_item_id(i),1,'N');
313: aso_debug_pub.add('p_atp_rec.inventory_item_name: ' || p_atp_rec.inventory_item_name(i),1,'N');
314: aso_debug_pub.add('p_atp_rec.source_organization_code: ' || p_atp_rec.source_organization_code(i),1,'N');
315: aso_debug_pub.add('p_atp_rec.source_organization_id: ' || p_atp_rec.source_organization_id(i),1,'N');
316: aso_debug_pub.add('p_atp_rec.identifier: ' || p_atp_rec.identifier(i),1,'N');
317: aso_debug_pub.add('p_atp_rec.customer_id: ' || p_atp_rec.customer_id(i),1,'N');
310:
311: if aso_debug_pub.g_debug_flag = 'Y' then
312: aso_debug_pub.add('p_atp_rec.inventory_item_id: ' || p_atp_rec.inventory_item_id(i),1,'N');
313: aso_debug_pub.add('p_atp_rec.inventory_item_name: ' || p_atp_rec.inventory_item_name(i),1,'N');
314: aso_debug_pub.add('p_atp_rec.source_organization_code: ' || p_atp_rec.source_organization_code(i),1,'N');
315: aso_debug_pub.add('p_atp_rec.source_organization_id: ' || p_atp_rec.source_organization_id(i),1,'N');
316: aso_debug_pub.add('p_atp_rec.identifier: ' || p_atp_rec.identifier(i),1,'N');
317: aso_debug_pub.add('p_atp_rec.customer_id: ' || p_atp_rec.customer_id(i),1,'N');
318: aso_debug_pub.add('p_atp_rec.customer_site_id: ' || p_atp_rec.customer_site_id(i),1,'N');
311: if aso_debug_pub.g_debug_flag = 'Y' then
312: aso_debug_pub.add('p_atp_rec.inventory_item_id: ' || p_atp_rec.inventory_item_id(i),1,'N');
313: aso_debug_pub.add('p_atp_rec.inventory_item_name: ' || p_atp_rec.inventory_item_name(i),1,'N');
314: aso_debug_pub.add('p_atp_rec.source_organization_code: ' || p_atp_rec.source_organization_code(i),1,'N');
315: aso_debug_pub.add('p_atp_rec.source_organization_id: ' || p_atp_rec.source_organization_id(i),1,'N');
316: aso_debug_pub.add('p_atp_rec.identifier: ' || p_atp_rec.identifier(i),1,'N');
317: aso_debug_pub.add('p_atp_rec.customer_id: ' || p_atp_rec.customer_id(i),1,'N');
318: aso_debug_pub.add('p_atp_rec.customer_site_id: ' || p_atp_rec.customer_site_id(i),1,'N');
319: aso_debug_pub.add('p_atp_rec.Quantity_Ordered: ' || p_atp_rec.Quantity_Ordered(i),1,'N');
312: aso_debug_pub.add('p_atp_rec.inventory_item_id: ' || p_atp_rec.inventory_item_id(i),1,'N');
313: aso_debug_pub.add('p_atp_rec.inventory_item_name: ' || p_atp_rec.inventory_item_name(i),1,'N');
314: aso_debug_pub.add('p_atp_rec.source_organization_code: ' || p_atp_rec.source_organization_code(i),1,'N');
315: aso_debug_pub.add('p_atp_rec.source_organization_id: ' || p_atp_rec.source_organization_id(i),1,'N');
316: aso_debug_pub.add('p_atp_rec.identifier: ' || p_atp_rec.identifier(i),1,'N');
317: aso_debug_pub.add('p_atp_rec.customer_id: ' || p_atp_rec.customer_id(i),1,'N');
318: aso_debug_pub.add('p_atp_rec.customer_site_id: ' || p_atp_rec.customer_site_id(i),1,'N');
319: aso_debug_pub.add('p_atp_rec.Quantity_Ordered: ' || p_atp_rec.Quantity_Ordered(i),1,'N');
320: aso_debug_pub.add('p_atp_rec.Quantity_UOM: ' || p_atp_rec.Quantity_UOM(i),1,'N');
313: aso_debug_pub.add('p_atp_rec.inventory_item_name: ' || p_atp_rec.inventory_item_name(i),1,'N');
314: aso_debug_pub.add('p_atp_rec.source_organization_code: ' || p_atp_rec.source_organization_code(i),1,'N');
315: aso_debug_pub.add('p_atp_rec.source_organization_id: ' || p_atp_rec.source_organization_id(i),1,'N');
316: aso_debug_pub.add('p_atp_rec.identifier: ' || p_atp_rec.identifier(i),1,'N');
317: aso_debug_pub.add('p_atp_rec.customer_id: ' || p_atp_rec.customer_id(i),1,'N');
318: aso_debug_pub.add('p_atp_rec.customer_site_id: ' || p_atp_rec.customer_site_id(i),1,'N');
319: aso_debug_pub.add('p_atp_rec.Quantity_Ordered: ' || p_atp_rec.Quantity_Ordered(i),1,'N');
320: aso_debug_pub.add('p_atp_rec.Quantity_UOM: ' || p_atp_rec.Quantity_UOM(i),1,'N');
321: aso_debug_pub.add('p_atp_rec.Requested_Ship_Date: ' || p_atp_rec.Requested_Ship_Date(i),1,'N');
314: aso_debug_pub.add('p_atp_rec.source_organization_code: ' || p_atp_rec.source_organization_code(i),1,'N');
315: aso_debug_pub.add('p_atp_rec.source_organization_id: ' || p_atp_rec.source_organization_id(i),1,'N');
316: aso_debug_pub.add('p_atp_rec.identifier: ' || p_atp_rec.identifier(i),1,'N');
317: aso_debug_pub.add('p_atp_rec.customer_id: ' || p_atp_rec.customer_id(i),1,'N');
318: aso_debug_pub.add('p_atp_rec.customer_site_id: ' || p_atp_rec.customer_site_id(i),1,'N');
319: aso_debug_pub.add('p_atp_rec.Quantity_Ordered: ' || p_atp_rec.Quantity_Ordered(i),1,'N');
320: aso_debug_pub.add('p_atp_rec.Quantity_UOM: ' || p_atp_rec.Quantity_UOM(i),1,'N');
321: aso_debug_pub.add('p_atp_rec.Requested_Ship_Date: ' || p_atp_rec.Requested_Ship_Date(i),1,'N');
322: aso_debug_pub.add('p_atp_rec.Ship_Date: ' || p_atp_rec.Ship_Date(i),1,'N');
315: aso_debug_pub.add('p_atp_rec.source_organization_id: ' || p_atp_rec.source_organization_id(i),1,'N');
316: aso_debug_pub.add('p_atp_rec.identifier: ' || p_atp_rec.identifier(i),1,'N');
317: aso_debug_pub.add('p_atp_rec.customer_id: ' || p_atp_rec.customer_id(i),1,'N');
318: aso_debug_pub.add('p_atp_rec.customer_site_id: ' || p_atp_rec.customer_site_id(i),1,'N');
319: aso_debug_pub.add('p_atp_rec.Quantity_Ordered: ' || p_atp_rec.Quantity_Ordered(i),1,'N');
320: aso_debug_pub.add('p_atp_rec.Quantity_UOM: ' || p_atp_rec.Quantity_UOM(i),1,'N');
321: aso_debug_pub.add('p_atp_rec.Requested_Ship_Date: ' || p_atp_rec.Requested_Ship_Date(i),1,'N');
322: aso_debug_pub.add('p_atp_rec.Ship_Date: ' || p_atp_rec.Ship_Date(i),1,'N');
323: aso_debug_pub.add('p_atp_rec.Available_Quantity: ' || p_atp_rec.Available_Quantity(i),1,'N');
316: aso_debug_pub.add('p_atp_rec.identifier: ' || p_atp_rec.identifier(i),1,'N');
317: aso_debug_pub.add('p_atp_rec.customer_id: ' || p_atp_rec.customer_id(i),1,'N');
318: aso_debug_pub.add('p_atp_rec.customer_site_id: ' || p_atp_rec.customer_site_id(i),1,'N');
319: aso_debug_pub.add('p_atp_rec.Quantity_Ordered: ' || p_atp_rec.Quantity_Ordered(i),1,'N');
320: aso_debug_pub.add('p_atp_rec.Quantity_UOM: ' || p_atp_rec.Quantity_UOM(i),1,'N');
321: aso_debug_pub.add('p_atp_rec.Requested_Ship_Date: ' || p_atp_rec.Requested_Ship_Date(i),1,'N');
322: aso_debug_pub.add('p_atp_rec.Ship_Date: ' || p_atp_rec.Ship_Date(i),1,'N');
323: aso_debug_pub.add('p_atp_rec.Available_Quantity: ' || p_atp_rec.Available_Quantity(i),1,'N');
324: aso_debug_pub.add('p_atp_rec.Requested_Date_Quantity: ' || p_atp_rec.Requested_Date_Quantity(i),1,'N');
317: aso_debug_pub.add('p_atp_rec.customer_id: ' || p_atp_rec.customer_id(i),1,'N');
318: aso_debug_pub.add('p_atp_rec.customer_site_id: ' || p_atp_rec.customer_site_id(i),1,'N');
319: aso_debug_pub.add('p_atp_rec.Quantity_Ordered: ' || p_atp_rec.Quantity_Ordered(i),1,'N');
320: aso_debug_pub.add('p_atp_rec.Quantity_UOM: ' || p_atp_rec.Quantity_UOM(i),1,'N');
321: aso_debug_pub.add('p_atp_rec.Requested_Ship_Date: ' || p_atp_rec.Requested_Ship_Date(i),1,'N');
322: aso_debug_pub.add('p_atp_rec.Ship_Date: ' || p_atp_rec.Ship_Date(i),1,'N');
323: aso_debug_pub.add('p_atp_rec.Available_Quantity: ' || p_atp_rec.Available_Quantity(i),1,'N');
324: aso_debug_pub.add('p_atp_rec.Requested_Date_Quantity: ' || p_atp_rec.Requested_Date_Quantity(i),1,'N');
325: aso_debug_pub.add('p_atp_rec.Error_Code: ' || p_atp_rec.Error_Code(i),1,'N');
318: aso_debug_pub.add('p_atp_rec.customer_site_id: ' || p_atp_rec.customer_site_id(i),1,'N');
319: aso_debug_pub.add('p_atp_rec.Quantity_Ordered: ' || p_atp_rec.Quantity_Ordered(i),1,'N');
320: aso_debug_pub.add('p_atp_rec.Quantity_UOM: ' || p_atp_rec.Quantity_UOM(i),1,'N');
321: aso_debug_pub.add('p_atp_rec.Requested_Ship_Date: ' || p_atp_rec.Requested_Ship_Date(i),1,'N');
322: aso_debug_pub.add('p_atp_rec.Ship_Date: ' || p_atp_rec.Ship_Date(i),1,'N');
323: aso_debug_pub.add('p_atp_rec.Available_Quantity: ' || p_atp_rec.Available_Quantity(i),1,'N');
324: aso_debug_pub.add('p_atp_rec.Requested_Date_Quantity: ' || p_atp_rec.Requested_Date_Quantity(i),1,'N');
325: aso_debug_pub.add('p_atp_rec.Error_Code: ' || p_atp_rec.Error_Code(i),1,'N');
326: aso_debug_pub.add('p_atp_rec.Message: ' || p_atp_rec.Message(i),1,'N');
319: aso_debug_pub.add('p_atp_rec.Quantity_Ordered: ' || p_atp_rec.Quantity_Ordered(i),1,'N');
320: aso_debug_pub.add('p_atp_rec.Quantity_UOM: ' || p_atp_rec.Quantity_UOM(i),1,'N');
321: aso_debug_pub.add('p_atp_rec.Requested_Ship_Date: ' || p_atp_rec.Requested_Ship_Date(i),1,'N');
322: aso_debug_pub.add('p_atp_rec.Ship_Date: ' || p_atp_rec.Ship_Date(i),1,'N');
323: aso_debug_pub.add('p_atp_rec.Available_Quantity: ' || p_atp_rec.Available_Quantity(i),1,'N');
324: aso_debug_pub.add('p_atp_rec.Requested_Date_Quantity: ' || p_atp_rec.Requested_Date_Quantity(i),1,'N');
325: aso_debug_pub.add('p_atp_rec.Error_Code: ' || p_atp_rec.Error_Code(i),1,'N');
326: aso_debug_pub.add('p_atp_rec.Message: ' || p_atp_rec.Message(i),1,'N');
327: --aso_debug_pub.add('p_atp_rec.request_date_type: ' || p_atp_rec.request_date_type(i),1,'N');
320: aso_debug_pub.add('p_atp_rec.Quantity_UOM: ' || p_atp_rec.Quantity_UOM(i),1,'N');
321: aso_debug_pub.add('p_atp_rec.Requested_Ship_Date: ' || p_atp_rec.Requested_Ship_Date(i),1,'N');
322: aso_debug_pub.add('p_atp_rec.Ship_Date: ' || p_atp_rec.Ship_Date(i),1,'N');
323: aso_debug_pub.add('p_atp_rec.Available_Quantity: ' || p_atp_rec.Available_Quantity(i),1,'N');
324: aso_debug_pub.add('p_atp_rec.Requested_Date_Quantity: ' || p_atp_rec.Requested_Date_Quantity(i),1,'N');
325: aso_debug_pub.add('p_atp_rec.Error_Code: ' || p_atp_rec.Error_Code(i),1,'N');
326: aso_debug_pub.add('p_atp_rec.Message: ' || p_atp_rec.Message(i),1,'N');
327: --aso_debug_pub.add('p_atp_rec.request_date_type: ' || p_atp_rec.request_date_type(i),1,'N');
328: aso_debug_pub.add('p_atp_rec.demand_class: ' || p_atp_rec.demand_class(i),1,'N');
321: aso_debug_pub.add('p_atp_rec.Requested_Ship_Date: ' || p_atp_rec.Requested_Ship_Date(i),1,'N');
322: aso_debug_pub.add('p_atp_rec.Ship_Date: ' || p_atp_rec.Ship_Date(i),1,'N');
323: aso_debug_pub.add('p_atp_rec.Available_Quantity: ' || p_atp_rec.Available_Quantity(i),1,'N');
324: aso_debug_pub.add('p_atp_rec.Requested_Date_Quantity: ' || p_atp_rec.Requested_Date_Quantity(i),1,'N');
325: aso_debug_pub.add('p_atp_rec.Error_Code: ' || p_atp_rec.Error_Code(i),1,'N');
326: aso_debug_pub.add('p_atp_rec.Message: ' || p_atp_rec.Message(i),1,'N');
327: --aso_debug_pub.add('p_atp_rec.request_date_type: ' || p_atp_rec.request_date_type(i),1,'N');
328: aso_debug_pub.add('p_atp_rec.demand_class: ' || p_atp_rec.demand_class(i),1,'N');
329: aso_debug_pub.add('p_atp_rec.ship_set_name: ' || p_atp_rec.ship_set_name(i),1,'N');
322: aso_debug_pub.add('p_atp_rec.Ship_Date: ' || p_atp_rec.Ship_Date(i),1,'N');
323: aso_debug_pub.add('p_atp_rec.Available_Quantity: ' || p_atp_rec.Available_Quantity(i),1,'N');
324: aso_debug_pub.add('p_atp_rec.Requested_Date_Quantity: ' || p_atp_rec.Requested_Date_Quantity(i),1,'N');
325: aso_debug_pub.add('p_atp_rec.Error_Code: ' || p_atp_rec.Error_Code(i),1,'N');
326: aso_debug_pub.add('p_atp_rec.Message: ' || p_atp_rec.Message(i),1,'N');
327: --aso_debug_pub.add('p_atp_rec.request_date_type: ' || p_atp_rec.request_date_type(i),1,'N');
328: aso_debug_pub.add('p_atp_rec.demand_class: ' || p_atp_rec.demand_class(i),1,'N');
329: aso_debug_pub.add('p_atp_rec.ship_set_name: ' || p_atp_rec.ship_set_name(i),1,'N');
330: aso_debug_pub.add('p_atp_rec.arrival_set_name: ' || p_atp_rec.arrival_set_name(i),1,'N');
323: aso_debug_pub.add('p_atp_rec.Available_Quantity: ' || p_atp_rec.Available_Quantity(i),1,'N');
324: aso_debug_pub.add('p_atp_rec.Requested_Date_Quantity: ' || p_atp_rec.Requested_Date_Quantity(i),1,'N');
325: aso_debug_pub.add('p_atp_rec.Error_Code: ' || p_atp_rec.Error_Code(i),1,'N');
326: aso_debug_pub.add('p_atp_rec.Message: ' || p_atp_rec.Message(i),1,'N');
327: --aso_debug_pub.add('p_atp_rec.request_date_type: ' || p_atp_rec.request_date_type(i),1,'N');
328: aso_debug_pub.add('p_atp_rec.demand_class: ' || p_atp_rec.demand_class(i),1,'N');
329: aso_debug_pub.add('p_atp_rec.ship_set_name: ' || p_atp_rec.ship_set_name(i),1,'N');
330: aso_debug_pub.add('p_atp_rec.arrival_set_name: ' || p_atp_rec.arrival_set_name(i),1,'N');
331: aso_debug_pub.add('p_atp_rec.line_number: ' || p_atp_rec.line_number(i),1,'N');
324: aso_debug_pub.add('p_atp_rec.Requested_Date_Quantity: ' || p_atp_rec.Requested_Date_Quantity(i),1,'N');
325: aso_debug_pub.add('p_atp_rec.Error_Code: ' || p_atp_rec.Error_Code(i),1,'N');
326: aso_debug_pub.add('p_atp_rec.Message: ' || p_atp_rec.Message(i),1,'N');
327: --aso_debug_pub.add('p_atp_rec.request_date_type: ' || p_atp_rec.request_date_type(i),1,'N');
328: aso_debug_pub.add('p_atp_rec.demand_class: ' || p_atp_rec.demand_class(i),1,'N');
329: aso_debug_pub.add('p_atp_rec.ship_set_name: ' || p_atp_rec.ship_set_name(i),1,'N');
330: aso_debug_pub.add('p_atp_rec.arrival_set_name: ' || p_atp_rec.arrival_set_name(i),1,'N');
331: aso_debug_pub.add('p_atp_rec.line_number: ' || p_atp_rec.line_number(i),1,'N');
332: aso_debug_pub.add('p_atp_rec.group_ship_date: ' || p_atp_rec.group_ship_date(i),1,'N');
325: aso_debug_pub.add('p_atp_rec.Error_Code: ' || p_atp_rec.Error_Code(i),1,'N');
326: aso_debug_pub.add('p_atp_rec.Message: ' || p_atp_rec.Message(i),1,'N');
327: --aso_debug_pub.add('p_atp_rec.request_date_type: ' || p_atp_rec.request_date_type(i),1,'N');
328: aso_debug_pub.add('p_atp_rec.demand_class: ' || p_atp_rec.demand_class(i),1,'N');
329: aso_debug_pub.add('p_atp_rec.ship_set_name: ' || p_atp_rec.ship_set_name(i),1,'N');
330: aso_debug_pub.add('p_atp_rec.arrival_set_name: ' || p_atp_rec.arrival_set_name(i),1,'N');
331: aso_debug_pub.add('p_atp_rec.line_number: ' || p_atp_rec.line_number(i),1,'N');
332: aso_debug_pub.add('p_atp_rec.group_ship_date: ' || p_atp_rec.group_ship_date(i),1,'N');
333: aso_debug_pub.add('p_atp_rec.requested_arrival_date: ' || p_atp_rec.requested_arrival_date(i),1,'N');
326: aso_debug_pub.add('p_atp_rec.Message: ' || p_atp_rec.Message(i),1,'N');
327: --aso_debug_pub.add('p_atp_rec.request_date_type: ' || p_atp_rec.request_date_type(i),1,'N');
328: aso_debug_pub.add('p_atp_rec.demand_class: ' || p_atp_rec.demand_class(i),1,'N');
329: aso_debug_pub.add('p_atp_rec.ship_set_name: ' || p_atp_rec.ship_set_name(i),1,'N');
330: aso_debug_pub.add('p_atp_rec.arrival_set_name: ' || p_atp_rec.arrival_set_name(i),1,'N');
331: aso_debug_pub.add('p_atp_rec.line_number: ' || p_atp_rec.line_number(i),1,'N');
332: aso_debug_pub.add('p_atp_rec.group_ship_date: ' || p_atp_rec.group_ship_date(i),1,'N');
333: aso_debug_pub.add('p_atp_rec.requested_arrival_date: ' || p_atp_rec.requested_arrival_date(i),1,'N');
334: aso_debug_pub.add('p_atp_rec.ship_method: ' || p_atp_rec.ship_method(i),1,'N');
327: --aso_debug_pub.add('p_atp_rec.request_date_type: ' || p_atp_rec.request_date_type(i),1,'N');
328: aso_debug_pub.add('p_atp_rec.demand_class: ' || p_atp_rec.demand_class(i),1,'N');
329: aso_debug_pub.add('p_atp_rec.ship_set_name: ' || p_atp_rec.ship_set_name(i),1,'N');
330: aso_debug_pub.add('p_atp_rec.arrival_set_name: ' || p_atp_rec.arrival_set_name(i),1,'N');
331: aso_debug_pub.add('p_atp_rec.line_number: ' || p_atp_rec.line_number(i),1,'N');
332: aso_debug_pub.add('p_atp_rec.group_ship_date: ' || p_atp_rec.group_ship_date(i),1,'N');
333: aso_debug_pub.add('p_atp_rec.requested_arrival_date: ' || p_atp_rec.requested_arrival_date(i),1,'N');
334: aso_debug_pub.add('p_atp_rec.ship_method: ' || p_atp_rec.ship_method(i),1,'N');
335: aso_debug_pub.add('p_atp_rec.demand_source_header_id: ' || p_atp_rec.demand_source_header_id(i),1,'N');
328: aso_debug_pub.add('p_atp_rec.demand_class: ' || p_atp_rec.demand_class(i),1,'N');
329: aso_debug_pub.add('p_atp_rec.ship_set_name: ' || p_atp_rec.ship_set_name(i),1,'N');
330: aso_debug_pub.add('p_atp_rec.arrival_set_name: ' || p_atp_rec.arrival_set_name(i),1,'N');
331: aso_debug_pub.add('p_atp_rec.line_number: ' || p_atp_rec.line_number(i),1,'N');
332: aso_debug_pub.add('p_atp_rec.group_ship_date: ' || p_atp_rec.group_ship_date(i),1,'N');
333: aso_debug_pub.add('p_atp_rec.requested_arrival_date: ' || p_atp_rec.requested_arrival_date(i),1,'N');
334: aso_debug_pub.add('p_atp_rec.ship_method: ' || p_atp_rec.ship_method(i),1,'N');
335: aso_debug_pub.add('p_atp_rec.demand_source_header_id: ' || p_atp_rec.demand_source_header_id(i),1,'N');
336: aso_debug_pub.add('p_atp_rec.calling_module: ' || p_atp_rec.calling_module(i),1,'N');
329: aso_debug_pub.add('p_atp_rec.ship_set_name: ' || p_atp_rec.ship_set_name(i),1,'N');
330: aso_debug_pub.add('p_atp_rec.arrival_set_name: ' || p_atp_rec.arrival_set_name(i),1,'N');
331: aso_debug_pub.add('p_atp_rec.line_number: ' || p_atp_rec.line_number(i),1,'N');
332: aso_debug_pub.add('p_atp_rec.group_ship_date: ' || p_atp_rec.group_ship_date(i),1,'N');
333: aso_debug_pub.add('p_atp_rec.requested_arrival_date: ' || p_atp_rec.requested_arrival_date(i),1,'N');
334: aso_debug_pub.add('p_atp_rec.ship_method: ' || p_atp_rec.ship_method(i),1,'N');
335: aso_debug_pub.add('p_atp_rec.demand_source_header_id: ' || p_atp_rec.demand_source_header_id(i),1,'N');
336: aso_debug_pub.add('p_atp_rec.calling_module: ' || p_atp_rec.calling_module(i),1,'N');
337: aso_debug_pub.add('p_atp_rec.order_number: ' || p_atp_rec.order_number(i),1,'N');
330: aso_debug_pub.add('p_atp_rec.arrival_set_name: ' || p_atp_rec.arrival_set_name(i),1,'N');
331: aso_debug_pub.add('p_atp_rec.line_number: ' || p_atp_rec.line_number(i),1,'N');
332: aso_debug_pub.add('p_atp_rec.group_ship_date: ' || p_atp_rec.group_ship_date(i),1,'N');
333: aso_debug_pub.add('p_atp_rec.requested_arrival_date: ' || p_atp_rec.requested_arrival_date(i),1,'N');
334: aso_debug_pub.add('p_atp_rec.ship_method: ' || p_atp_rec.ship_method(i),1,'N');
335: aso_debug_pub.add('p_atp_rec.demand_source_header_id: ' || p_atp_rec.demand_source_header_id(i),1,'N');
336: aso_debug_pub.add('p_atp_rec.calling_module: ' || p_atp_rec.calling_module(i),1,'N');
337: aso_debug_pub.add('p_atp_rec.order_number: ' || p_atp_rec.order_number(i),1,'N');
338: aso_debug_pub.add('p_atp_rec.ato_model_line_id: ' || p_atp_rec.ato_model_line_id(i),1,'N');
331: aso_debug_pub.add('p_atp_rec.line_number: ' || p_atp_rec.line_number(i),1,'N');
332: aso_debug_pub.add('p_atp_rec.group_ship_date: ' || p_atp_rec.group_ship_date(i),1,'N');
333: aso_debug_pub.add('p_atp_rec.requested_arrival_date: ' || p_atp_rec.requested_arrival_date(i),1,'N');
334: aso_debug_pub.add('p_atp_rec.ship_method: ' || p_atp_rec.ship_method(i),1,'N');
335: aso_debug_pub.add('p_atp_rec.demand_source_header_id: ' || p_atp_rec.demand_source_header_id(i),1,'N');
336: aso_debug_pub.add('p_atp_rec.calling_module: ' || p_atp_rec.calling_module(i),1,'N');
337: aso_debug_pub.add('p_atp_rec.order_number: ' || p_atp_rec.order_number(i),1,'N');
338: aso_debug_pub.add('p_atp_rec.ato_model_line_id: ' || p_atp_rec.ato_model_line_id(i),1,'N');
339: aso_debug_pub.add('p_atp_rec.parent_line_id: ' || p_atp_rec.parent_line_id(i),1,'N');
332: aso_debug_pub.add('p_atp_rec.group_ship_date: ' || p_atp_rec.group_ship_date(i),1,'N');
333: aso_debug_pub.add('p_atp_rec.requested_arrival_date: ' || p_atp_rec.requested_arrival_date(i),1,'N');
334: aso_debug_pub.add('p_atp_rec.ship_method: ' || p_atp_rec.ship_method(i),1,'N');
335: aso_debug_pub.add('p_atp_rec.demand_source_header_id: ' || p_atp_rec.demand_source_header_id(i),1,'N');
336: aso_debug_pub.add('p_atp_rec.calling_module: ' || p_atp_rec.calling_module(i),1,'N');
337: aso_debug_pub.add('p_atp_rec.order_number: ' || p_atp_rec.order_number(i),1,'N');
338: aso_debug_pub.add('p_atp_rec.ato_model_line_id: ' || p_atp_rec.ato_model_line_id(i),1,'N');
339: aso_debug_pub.add('p_atp_rec.parent_line_id: ' || p_atp_rec.parent_line_id(i),1,'N');
340: aso_debug_pub.add('p_atp_rec.top_model_line_id: ' || p_atp_rec.top_model_line_id(i),1,'N');
333: aso_debug_pub.add('p_atp_rec.requested_arrival_date: ' || p_atp_rec.requested_arrival_date(i),1,'N');
334: aso_debug_pub.add('p_atp_rec.ship_method: ' || p_atp_rec.ship_method(i),1,'N');
335: aso_debug_pub.add('p_atp_rec.demand_source_header_id: ' || p_atp_rec.demand_source_header_id(i),1,'N');
336: aso_debug_pub.add('p_atp_rec.calling_module: ' || p_atp_rec.calling_module(i),1,'N');
337: aso_debug_pub.add('p_atp_rec.order_number: ' || p_atp_rec.order_number(i),1,'N');
338: aso_debug_pub.add('p_atp_rec.ato_model_line_id: ' || p_atp_rec.ato_model_line_id(i),1,'N');
339: aso_debug_pub.add('p_atp_rec.parent_line_id: ' || p_atp_rec.parent_line_id(i),1,'N');
340: aso_debug_pub.add('p_atp_rec.top_model_line_id: ' || p_atp_rec.top_model_line_id(i),1,'N');
341: aso_debug_pub.add('p_atp_rec.match_item_id: ' || p_atp_rec.match_item_id(i),1,'N');
334: aso_debug_pub.add('p_atp_rec.ship_method: ' || p_atp_rec.ship_method(i),1,'N');
335: aso_debug_pub.add('p_atp_rec.demand_source_header_id: ' || p_atp_rec.demand_source_header_id(i),1,'N');
336: aso_debug_pub.add('p_atp_rec.calling_module: ' || p_atp_rec.calling_module(i),1,'N');
337: aso_debug_pub.add('p_atp_rec.order_number: ' || p_atp_rec.order_number(i),1,'N');
338: aso_debug_pub.add('p_atp_rec.ato_model_line_id: ' || p_atp_rec.ato_model_line_id(i),1,'N');
339: aso_debug_pub.add('p_atp_rec.parent_line_id: ' || p_atp_rec.parent_line_id(i),1,'N');
340: aso_debug_pub.add('p_atp_rec.top_model_line_id: ' || p_atp_rec.top_model_line_id(i),1,'N');
341: aso_debug_pub.add('p_atp_rec.match_item_id: ' || p_atp_rec.match_item_id(i),1,'N');
342: aso_debug_pub.add('p_atp_rec.action: ' || p_atp_rec.action(i),1,'N');
335: aso_debug_pub.add('p_atp_rec.demand_source_header_id: ' || p_atp_rec.demand_source_header_id(i),1,'N');
336: aso_debug_pub.add('p_atp_rec.calling_module: ' || p_atp_rec.calling_module(i),1,'N');
337: aso_debug_pub.add('p_atp_rec.order_number: ' || p_atp_rec.order_number(i),1,'N');
338: aso_debug_pub.add('p_atp_rec.ato_model_line_id: ' || p_atp_rec.ato_model_line_id(i),1,'N');
339: aso_debug_pub.add('p_atp_rec.parent_line_id: ' || p_atp_rec.parent_line_id(i),1,'N');
340: aso_debug_pub.add('p_atp_rec.top_model_line_id: ' || p_atp_rec.top_model_line_id(i),1,'N');
341: aso_debug_pub.add('p_atp_rec.match_item_id: ' || p_atp_rec.match_item_id(i),1,'N');
342: aso_debug_pub.add('p_atp_rec.action: ' || p_atp_rec.action(i),1,'N');
343: aso_debug_pub.add('p_atp_rec.arrival_date: ' || p_atp_rec.arrival_date(i),1,'N');
336: aso_debug_pub.add('p_atp_rec.calling_module: ' || p_atp_rec.calling_module(i),1,'N');
337: aso_debug_pub.add('p_atp_rec.order_number: ' || p_atp_rec.order_number(i),1,'N');
338: aso_debug_pub.add('p_atp_rec.ato_model_line_id: ' || p_atp_rec.ato_model_line_id(i),1,'N');
339: aso_debug_pub.add('p_atp_rec.parent_line_id: ' || p_atp_rec.parent_line_id(i),1,'N');
340: aso_debug_pub.add('p_atp_rec.top_model_line_id: ' || p_atp_rec.top_model_line_id(i),1,'N');
341: aso_debug_pub.add('p_atp_rec.match_item_id: ' || p_atp_rec.match_item_id(i),1,'N');
342: aso_debug_pub.add('p_atp_rec.action: ' || p_atp_rec.action(i),1,'N');
343: aso_debug_pub.add('p_atp_rec.arrival_date: ' || p_atp_rec.arrival_date(i),1,'N');
344: aso_debug_pub.add('p_atp_rec.validation_org: ' || p_atp_rec.validation_org(i),1,'N');
337: aso_debug_pub.add('p_atp_rec.order_number: ' || p_atp_rec.order_number(i),1,'N');
338: aso_debug_pub.add('p_atp_rec.ato_model_line_id: ' || p_atp_rec.ato_model_line_id(i),1,'N');
339: aso_debug_pub.add('p_atp_rec.parent_line_id: ' || p_atp_rec.parent_line_id(i),1,'N');
340: aso_debug_pub.add('p_atp_rec.top_model_line_id: ' || p_atp_rec.top_model_line_id(i),1,'N');
341: aso_debug_pub.add('p_atp_rec.match_item_id: ' || p_atp_rec.match_item_id(i),1,'N');
342: aso_debug_pub.add('p_atp_rec.action: ' || p_atp_rec.action(i),1,'N');
343: aso_debug_pub.add('p_atp_rec.arrival_date: ' || p_atp_rec.arrival_date(i),1,'N');
344: aso_debug_pub.add('p_atp_rec.validation_org: ' || p_atp_rec.validation_org(i),1,'N');
345: aso_debug_pub.add('p_atp_rec.component_code: ' || p_atp_rec.component_code(i),1,'N');
338: aso_debug_pub.add('p_atp_rec.ato_model_line_id: ' || p_atp_rec.ato_model_line_id(i),1,'N');
339: aso_debug_pub.add('p_atp_rec.parent_line_id: ' || p_atp_rec.parent_line_id(i),1,'N');
340: aso_debug_pub.add('p_atp_rec.top_model_line_id: ' || p_atp_rec.top_model_line_id(i),1,'N');
341: aso_debug_pub.add('p_atp_rec.match_item_id: ' || p_atp_rec.match_item_id(i),1,'N');
342: aso_debug_pub.add('p_atp_rec.action: ' || p_atp_rec.action(i),1,'N');
343: aso_debug_pub.add('p_atp_rec.arrival_date: ' || p_atp_rec.arrival_date(i),1,'N');
344: aso_debug_pub.add('p_atp_rec.validation_org: ' || p_atp_rec.validation_org(i),1,'N');
345: aso_debug_pub.add('p_atp_rec.component_code: ' || p_atp_rec.component_code(i),1,'N');
346: aso_debug_pub.add('p_atp_rec.component_sequence_id: ' || p_atp_rec.component_sequence_id(i),1,'N');
339: aso_debug_pub.add('p_atp_rec.parent_line_id: ' || p_atp_rec.parent_line_id(i),1,'N');
340: aso_debug_pub.add('p_atp_rec.top_model_line_id: ' || p_atp_rec.top_model_line_id(i),1,'N');
341: aso_debug_pub.add('p_atp_rec.match_item_id: ' || p_atp_rec.match_item_id(i),1,'N');
342: aso_debug_pub.add('p_atp_rec.action: ' || p_atp_rec.action(i),1,'N');
343: aso_debug_pub.add('p_atp_rec.arrival_date: ' || p_atp_rec.arrival_date(i),1,'N');
344: aso_debug_pub.add('p_atp_rec.validation_org: ' || p_atp_rec.validation_org(i),1,'N');
345: aso_debug_pub.add('p_atp_rec.component_code: ' || p_atp_rec.component_code(i),1,'N');
346: aso_debug_pub.add('p_atp_rec.component_sequence_id: ' || p_atp_rec.component_sequence_id(i),1,'N');
347: aso_debug_pub.add('p_atp_rec.included_item_flag: ' || p_atp_rec.included_item_flag(i),1,'N');
340: aso_debug_pub.add('p_atp_rec.top_model_line_id: ' || p_atp_rec.top_model_line_id(i),1,'N');
341: aso_debug_pub.add('p_atp_rec.match_item_id: ' || p_atp_rec.match_item_id(i),1,'N');
342: aso_debug_pub.add('p_atp_rec.action: ' || p_atp_rec.action(i),1,'N');
343: aso_debug_pub.add('p_atp_rec.arrival_date: ' || p_atp_rec.arrival_date(i),1,'N');
344: aso_debug_pub.add('p_atp_rec.validation_org: ' || p_atp_rec.validation_org(i),1,'N');
345: aso_debug_pub.add('p_atp_rec.component_code: ' || p_atp_rec.component_code(i),1,'N');
346: aso_debug_pub.add('p_atp_rec.component_sequence_id: ' || p_atp_rec.component_sequence_id(i),1,'N');
347: aso_debug_pub.add('p_atp_rec.included_item_flag: ' || p_atp_rec.included_item_flag(i),1,'N');
348: aso_debug_pub.add('p_atp_rec.cascade_model_info_to_comp: ' || p_atp_rec.cascade_model_info_to_comp(i),1,'N');
341: aso_debug_pub.add('p_atp_rec.match_item_id: ' || p_atp_rec.match_item_id(i),1,'N');
342: aso_debug_pub.add('p_atp_rec.action: ' || p_atp_rec.action(i),1,'N');
343: aso_debug_pub.add('p_atp_rec.arrival_date: ' || p_atp_rec.arrival_date(i),1,'N');
344: aso_debug_pub.add('p_atp_rec.validation_org: ' || p_atp_rec.validation_org(i),1,'N');
345: aso_debug_pub.add('p_atp_rec.component_code: ' || p_atp_rec.component_code(i),1,'N');
346: aso_debug_pub.add('p_atp_rec.component_sequence_id: ' || p_atp_rec.component_sequence_id(i),1,'N');
347: aso_debug_pub.add('p_atp_rec.included_item_flag: ' || p_atp_rec.included_item_flag(i),1,'N');
348: aso_debug_pub.add('p_atp_rec.cascade_model_info_to_comp: ' || p_atp_rec.cascade_model_info_to_comp(i),1,'N');
349: --aso_debug_pub.add('p_atp_rec.ship_to_party_site_id: ' || p_atp_rec.ship_to_party_site_id(i),1,'N');
342: aso_debug_pub.add('p_atp_rec.action: ' || p_atp_rec.action(i),1,'N');
343: aso_debug_pub.add('p_atp_rec.arrival_date: ' || p_atp_rec.arrival_date(i),1,'N');
344: aso_debug_pub.add('p_atp_rec.validation_org: ' || p_atp_rec.validation_org(i),1,'N');
345: aso_debug_pub.add('p_atp_rec.component_code: ' || p_atp_rec.component_code(i),1,'N');
346: aso_debug_pub.add('p_atp_rec.component_sequence_id: ' || p_atp_rec.component_sequence_id(i),1,'N');
347: aso_debug_pub.add('p_atp_rec.included_item_flag: ' || p_atp_rec.included_item_flag(i),1,'N');
348: aso_debug_pub.add('p_atp_rec.cascade_model_info_to_comp: ' || p_atp_rec.cascade_model_info_to_comp(i),1,'N');
349: --aso_debug_pub.add('p_atp_rec.ship_to_party_site_id: ' || p_atp_rec.ship_to_party_site_id(i),1,'N');
350: aso_debug_pub.add('p_atp_rec.customer_country: ' || p_atp_rec.customer_country(i),1,'N');
343: aso_debug_pub.add('p_atp_rec.arrival_date: ' || p_atp_rec.arrival_date(i),1,'N');
344: aso_debug_pub.add('p_atp_rec.validation_org: ' || p_atp_rec.validation_org(i),1,'N');
345: aso_debug_pub.add('p_atp_rec.component_code: ' || p_atp_rec.component_code(i),1,'N');
346: aso_debug_pub.add('p_atp_rec.component_sequence_id: ' || p_atp_rec.component_sequence_id(i),1,'N');
347: aso_debug_pub.add('p_atp_rec.included_item_flag: ' || p_atp_rec.included_item_flag(i),1,'N');
348: aso_debug_pub.add('p_atp_rec.cascade_model_info_to_comp: ' || p_atp_rec.cascade_model_info_to_comp(i),1,'N');
349: --aso_debug_pub.add('p_atp_rec.ship_to_party_site_id: ' || p_atp_rec.ship_to_party_site_id(i),1,'N');
350: aso_debug_pub.add('p_atp_rec.customer_country: ' || p_atp_rec.customer_country(i),1,'N');
351: aso_debug_pub.add('p_atp_rec.customer_state: ' || p_atp_rec.customer_state(i),1,'N');
344: aso_debug_pub.add('p_atp_rec.validation_org: ' || p_atp_rec.validation_org(i),1,'N');
345: aso_debug_pub.add('p_atp_rec.component_code: ' || p_atp_rec.component_code(i),1,'N');
346: aso_debug_pub.add('p_atp_rec.component_sequence_id: ' || p_atp_rec.component_sequence_id(i),1,'N');
347: aso_debug_pub.add('p_atp_rec.included_item_flag: ' || p_atp_rec.included_item_flag(i),1,'N');
348: aso_debug_pub.add('p_atp_rec.cascade_model_info_to_comp: ' || p_atp_rec.cascade_model_info_to_comp(i),1,'N');
349: --aso_debug_pub.add('p_atp_rec.ship_to_party_site_id: ' || p_atp_rec.ship_to_party_site_id(i),1,'N');
350: aso_debug_pub.add('p_atp_rec.customer_country: ' || p_atp_rec.customer_country(i),1,'N');
351: aso_debug_pub.add('p_atp_rec.customer_state: ' || p_atp_rec.customer_state(i),1,'N');
352: aso_debug_pub.add('p_atp_rec.customer_city: ' || p_atp_rec.customer_city(i),1,'N');
345: aso_debug_pub.add('p_atp_rec.component_code: ' || p_atp_rec.component_code(i),1,'N');
346: aso_debug_pub.add('p_atp_rec.component_sequence_id: ' || p_atp_rec.component_sequence_id(i),1,'N');
347: aso_debug_pub.add('p_atp_rec.included_item_flag: ' || p_atp_rec.included_item_flag(i),1,'N');
348: aso_debug_pub.add('p_atp_rec.cascade_model_info_to_comp: ' || p_atp_rec.cascade_model_info_to_comp(i),1,'N');
349: --aso_debug_pub.add('p_atp_rec.ship_to_party_site_id: ' || p_atp_rec.ship_to_party_site_id(i),1,'N');
350: aso_debug_pub.add('p_atp_rec.customer_country: ' || p_atp_rec.customer_country(i),1,'N');
351: aso_debug_pub.add('p_atp_rec.customer_state: ' || p_atp_rec.customer_state(i),1,'N');
352: aso_debug_pub.add('p_atp_rec.customer_city: ' || p_atp_rec.customer_city(i),1,'N');
353: aso_debug_pub.add('p_atp_rec.customer_postal_code: ' || p_atp_rec.customer_postal_code(i),1,'N');
346: aso_debug_pub.add('p_atp_rec.component_sequence_id: ' || p_atp_rec.component_sequence_id(i),1,'N');
347: aso_debug_pub.add('p_atp_rec.included_item_flag: ' || p_atp_rec.included_item_flag(i),1,'N');
348: aso_debug_pub.add('p_atp_rec.cascade_model_info_to_comp: ' || p_atp_rec.cascade_model_info_to_comp(i),1,'N');
349: --aso_debug_pub.add('p_atp_rec.ship_to_party_site_id: ' || p_atp_rec.ship_to_party_site_id(i),1,'N');
350: aso_debug_pub.add('p_atp_rec.customer_country: ' || p_atp_rec.customer_country(i),1,'N');
351: aso_debug_pub.add('p_atp_rec.customer_state: ' || p_atp_rec.customer_state(i),1,'N');
352: aso_debug_pub.add('p_atp_rec.customer_city: ' || p_atp_rec.customer_city(i),1,'N');
353: aso_debug_pub.add('p_atp_rec.customer_postal_code: ' || p_atp_rec.customer_postal_code(i),1,'N');
354: end if;
347: aso_debug_pub.add('p_atp_rec.included_item_flag: ' || p_atp_rec.included_item_flag(i),1,'N');
348: aso_debug_pub.add('p_atp_rec.cascade_model_info_to_comp: ' || p_atp_rec.cascade_model_info_to_comp(i),1,'N');
349: --aso_debug_pub.add('p_atp_rec.ship_to_party_site_id: ' || p_atp_rec.ship_to_party_site_id(i),1,'N');
350: aso_debug_pub.add('p_atp_rec.customer_country: ' || p_atp_rec.customer_country(i),1,'N');
351: aso_debug_pub.add('p_atp_rec.customer_state: ' || p_atp_rec.customer_state(i),1,'N');
352: aso_debug_pub.add('p_atp_rec.customer_city: ' || p_atp_rec.customer_city(i),1,'N');
353: aso_debug_pub.add('p_atp_rec.customer_postal_code: ' || p_atp_rec.customer_postal_code(i),1,'N');
354: end if;
355:
348: aso_debug_pub.add('p_atp_rec.cascade_model_info_to_comp: ' || p_atp_rec.cascade_model_info_to_comp(i),1,'N');
349: --aso_debug_pub.add('p_atp_rec.ship_to_party_site_id: ' || p_atp_rec.ship_to_party_site_id(i),1,'N');
350: aso_debug_pub.add('p_atp_rec.customer_country: ' || p_atp_rec.customer_country(i),1,'N');
351: aso_debug_pub.add('p_atp_rec.customer_state: ' || p_atp_rec.customer_state(i),1,'N');
352: aso_debug_pub.add('p_atp_rec.customer_city: ' || p_atp_rec.customer_city(i),1,'N');
353: aso_debug_pub.add('p_atp_rec.customer_postal_code: ' || p_atp_rec.customer_postal_code(i),1,'N');
354: end if;
355:
356: end if;
349: --aso_debug_pub.add('p_atp_rec.ship_to_party_site_id: ' || p_atp_rec.ship_to_party_site_id(i),1,'N');
350: aso_debug_pub.add('p_atp_rec.customer_country: ' || p_atp_rec.customer_country(i),1,'N');
351: aso_debug_pub.add('p_atp_rec.customer_state: ' || p_atp_rec.customer_state(i),1,'N');
352: aso_debug_pub.add('p_atp_rec.customer_city: ' || p_atp_rec.customer_city(i),1,'N');
353: aso_debug_pub.add('p_atp_rec.customer_postal_code: ' || p_atp_rec.customer_postal_code(i),1,'N');
354: end if;
355:
356: end if;
357:
356: end if;
357:
358: End Loop;
359:
360: if aso_debug_pub.g_debug_flag = 'Y' then
361:
362: for i in 1 .. x_aso_atp_tbl.count loop
363:
364: aso_debug_pub.add('x_aso_atp_tbl('||i||').source_organization_name: '|| x_aso_atp_tbl(i).source_organization_name, 1, 'N');
360: if aso_debug_pub.g_debug_flag = 'Y' then
361:
362: for i in 1 .. x_aso_atp_tbl.count loop
363:
364: aso_debug_pub.add('x_aso_atp_tbl('||i||').source_organization_name: '|| x_aso_atp_tbl(i).source_organization_name, 1, 'N');
365: aso_debug_pub.add('x_aso_atp_tbl('||i||').padded_concatenated_segments: '|| x_aso_atp_tbl(i).padded_concatenated_segments, 1, 'N');
366: aso_debug_pub.add('x_aso_atp_tbl('||i||').inventory_item_description: '|| x_aso_atp_tbl(i).inventory_item_description, 1, 'N');
367: aso_debug_pub.add('x_aso_atp_tbl('||i||').uom_meaning: '|| x_aso_atp_tbl(i).uom_meaning, 1, 'N');
368: aso_debug_pub.add('x_aso_atp_tbl('||i||').quantity_on_hand: '|| x_aso_atp_tbl(i).quantity_on_hand, 1, 'N');
361:
362: for i in 1 .. x_aso_atp_tbl.count loop
363:
364: aso_debug_pub.add('x_aso_atp_tbl('||i||').source_organization_name: '|| x_aso_atp_tbl(i).source_organization_name, 1, 'N');
365: aso_debug_pub.add('x_aso_atp_tbl('||i||').padded_concatenated_segments: '|| x_aso_atp_tbl(i).padded_concatenated_segments, 1, 'N');
366: aso_debug_pub.add('x_aso_atp_tbl('||i||').inventory_item_description: '|| x_aso_atp_tbl(i).inventory_item_description, 1, 'N');
367: aso_debug_pub.add('x_aso_atp_tbl('||i||').uom_meaning: '|| x_aso_atp_tbl(i).uom_meaning, 1, 'N');
368: aso_debug_pub.add('x_aso_atp_tbl('||i||').quantity_on_hand: '|| x_aso_atp_tbl(i).quantity_on_hand, 1, 'N');
369: aso_debug_pub.add('x_aso_atp_tbl('||i||').ship_method_meaning: '|| x_aso_atp_tbl(i).ship_method_meaning, 1, 'N');
362: for i in 1 .. x_aso_atp_tbl.count loop
363:
364: aso_debug_pub.add('x_aso_atp_tbl('||i||').source_organization_name: '|| x_aso_atp_tbl(i).source_organization_name, 1, 'N');
365: aso_debug_pub.add('x_aso_atp_tbl('||i||').padded_concatenated_segments: '|| x_aso_atp_tbl(i).padded_concatenated_segments, 1, 'N');
366: aso_debug_pub.add('x_aso_atp_tbl('||i||').inventory_item_description: '|| x_aso_atp_tbl(i).inventory_item_description, 1, 'N');
367: aso_debug_pub.add('x_aso_atp_tbl('||i||').uom_meaning: '|| x_aso_atp_tbl(i).uom_meaning, 1, 'N');
368: aso_debug_pub.add('x_aso_atp_tbl('||i||').quantity_on_hand: '|| x_aso_atp_tbl(i).quantity_on_hand, 1, 'N');
369: aso_debug_pub.add('x_aso_atp_tbl('||i||').ship_method_meaning: '|| x_aso_atp_tbl(i).ship_method_meaning, 1, 'N');
370: aso_debug_pub.add('x_aso_atp_tbl('||i||').demand_class_meaning: '|| x_aso_atp_tbl(i).demand_class_meaning, 1, 'N');
363:
364: aso_debug_pub.add('x_aso_atp_tbl('||i||').source_organization_name: '|| x_aso_atp_tbl(i).source_organization_name, 1, 'N');
365: aso_debug_pub.add('x_aso_atp_tbl('||i||').padded_concatenated_segments: '|| x_aso_atp_tbl(i).padded_concatenated_segments, 1, 'N');
366: aso_debug_pub.add('x_aso_atp_tbl('||i||').inventory_item_description: '|| x_aso_atp_tbl(i).inventory_item_description, 1, 'N');
367: aso_debug_pub.add('x_aso_atp_tbl('||i||').uom_meaning: '|| x_aso_atp_tbl(i).uom_meaning, 1, 'N');
368: aso_debug_pub.add('x_aso_atp_tbl('||i||').quantity_on_hand: '|| x_aso_atp_tbl(i).quantity_on_hand, 1, 'N');
369: aso_debug_pub.add('x_aso_atp_tbl('||i||').ship_method_meaning: '|| x_aso_atp_tbl(i).ship_method_meaning, 1, 'N');
370: aso_debug_pub.add('x_aso_atp_tbl('||i||').demand_class_meaning: '|| x_aso_atp_tbl(i).demand_class_meaning, 1, 'N');
371: aso_debug_pub.add('x_aso_atp_tbl('||i||').organization_id: '|| x_aso_atp_tbl(i).organization_id, 1, 'N');
364: aso_debug_pub.add('x_aso_atp_tbl('||i||').source_organization_name: '|| x_aso_atp_tbl(i).source_organization_name, 1, 'N');
365: aso_debug_pub.add('x_aso_atp_tbl('||i||').padded_concatenated_segments: '|| x_aso_atp_tbl(i).padded_concatenated_segments, 1, 'N');
366: aso_debug_pub.add('x_aso_atp_tbl('||i||').inventory_item_description: '|| x_aso_atp_tbl(i).inventory_item_description, 1, 'N');
367: aso_debug_pub.add('x_aso_atp_tbl('||i||').uom_meaning: '|| x_aso_atp_tbl(i).uom_meaning, 1, 'N');
368: aso_debug_pub.add('x_aso_atp_tbl('||i||').quantity_on_hand: '|| x_aso_atp_tbl(i).quantity_on_hand, 1, 'N');
369: aso_debug_pub.add('x_aso_atp_tbl('||i||').ship_method_meaning: '|| x_aso_atp_tbl(i).ship_method_meaning, 1, 'N');
370: aso_debug_pub.add('x_aso_atp_tbl('||i||').demand_class_meaning: '|| x_aso_atp_tbl(i).demand_class_meaning, 1, 'N');
371: aso_debug_pub.add('x_aso_atp_tbl('||i||').organization_id: '|| x_aso_atp_tbl(i).organization_id, 1, 'N');
372: aso_debug_pub.add('x_aso_atp_tbl('||i||').shipment_id: '|| x_aso_atp_tbl(i).shipment_id, 1, 'N');
365: aso_debug_pub.add('x_aso_atp_tbl('||i||').padded_concatenated_segments: '|| x_aso_atp_tbl(i).padded_concatenated_segments, 1, 'N');
366: aso_debug_pub.add('x_aso_atp_tbl('||i||').inventory_item_description: '|| x_aso_atp_tbl(i).inventory_item_description, 1, 'N');
367: aso_debug_pub.add('x_aso_atp_tbl('||i||').uom_meaning: '|| x_aso_atp_tbl(i).uom_meaning, 1, 'N');
368: aso_debug_pub.add('x_aso_atp_tbl('||i||').quantity_on_hand: '|| x_aso_atp_tbl(i).quantity_on_hand, 1, 'N');
369: aso_debug_pub.add('x_aso_atp_tbl('||i||').ship_method_meaning: '|| x_aso_atp_tbl(i).ship_method_meaning, 1, 'N');
370: aso_debug_pub.add('x_aso_atp_tbl('||i||').demand_class_meaning: '|| x_aso_atp_tbl(i).demand_class_meaning, 1, 'N');
371: aso_debug_pub.add('x_aso_atp_tbl('||i||').organization_id: '|| x_aso_atp_tbl(i).organization_id, 1, 'N');
372: aso_debug_pub.add('x_aso_atp_tbl('||i||').shipment_id: '|| x_aso_atp_tbl(i).shipment_id, 1, 'N');
373: end loop;
366: aso_debug_pub.add('x_aso_atp_tbl('||i||').inventory_item_description: '|| x_aso_atp_tbl(i).inventory_item_description, 1, 'N');
367: aso_debug_pub.add('x_aso_atp_tbl('||i||').uom_meaning: '|| x_aso_atp_tbl(i).uom_meaning, 1, 'N');
368: aso_debug_pub.add('x_aso_atp_tbl('||i||').quantity_on_hand: '|| x_aso_atp_tbl(i).quantity_on_hand, 1, 'N');
369: aso_debug_pub.add('x_aso_atp_tbl('||i||').ship_method_meaning: '|| x_aso_atp_tbl(i).ship_method_meaning, 1, 'N');
370: aso_debug_pub.add('x_aso_atp_tbl('||i||').demand_class_meaning: '|| x_aso_atp_tbl(i).demand_class_meaning, 1, 'N');
371: aso_debug_pub.add('x_aso_atp_tbl('||i||').organization_id: '|| x_aso_atp_tbl(i).organization_id, 1, 'N');
372: aso_debug_pub.add('x_aso_atp_tbl('||i||').shipment_id: '|| x_aso_atp_tbl(i).shipment_id, 1, 'N');
373: end loop;
374:
367: aso_debug_pub.add('x_aso_atp_tbl('||i||').uom_meaning: '|| x_aso_atp_tbl(i).uom_meaning, 1, 'N');
368: aso_debug_pub.add('x_aso_atp_tbl('||i||').quantity_on_hand: '|| x_aso_atp_tbl(i).quantity_on_hand, 1, 'N');
369: aso_debug_pub.add('x_aso_atp_tbl('||i||').ship_method_meaning: '|| x_aso_atp_tbl(i).ship_method_meaning, 1, 'N');
370: aso_debug_pub.add('x_aso_atp_tbl('||i||').demand_class_meaning: '|| x_aso_atp_tbl(i).demand_class_meaning, 1, 'N');
371: aso_debug_pub.add('x_aso_atp_tbl('||i||').organization_id: '|| x_aso_atp_tbl(i).organization_id, 1, 'N');
372: aso_debug_pub.add('x_aso_atp_tbl('||i||').shipment_id: '|| x_aso_atp_tbl(i).shipment_id, 1, 'N');
373: end loop;
374:
375: end if;
368: aso_debug_pub.add('x_aso_atp_tbl('||i||').quantity_on_hand: '|| x_aso_atp_tbl(i).quantity_on_hand, 1, 'N');
369: aso_debug_pub.add('x_aso_atp_tbl('||i||').ship_method_meaning: '|| x_aso_atp_tbl(i).ship_method_meaning, 1, 'N');
370: aso_debug_pub.add('x_aso_atp_tbl('||i||').demand_class_meaning: '|| x_aso_atp_tbl(i).demand_class_meaning, 1, 'N');
371: aso_debug_pub.add('x_aso_atp_tbl('||i||').organization_id: '|| x_aso_atp_tbl(i).organization_id, 1, 'N');
372: aso_debug_pub.add('x_aso_atp_tbl('||i||').shipment_id: '|| x_aso_atp_tbl(i).shipment_id, 1, 'N');
373: end loop;
374:
375: end if;
376:
579: BEGIN
580: -- Standard Start of API savepoint
581: SAVEPOINT DO_CHECK_ATP_INT;
582:
583: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
584:
585: IF aso_debug_pub.g_debug_flag = 'Y' THEN
586: aso_debug_pub.add('do_check_atp: Begin');
587: END IF;
581: SAVEPOINT DO_CHECK_ATP_INT;
582:
583: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
584:
585: IF aso_debug_pub.g_debug_flag = 'Y' THEN
586: aso_debug_pub.add('do_check_atp: Begin');
587: END IF;
588:
589: -- Standard call to check for call compatibility.
582:
583: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
584:
585: IF aso_debug_pub.g_debug_flag = 'Y' THEN
586: aso_debug_pub.add('do_check_atp: Begin');
587: END IF;
588:
589: -- Standard call to check for call compatibility.
590: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
600: END IF;
601:
602: x_return_status := fnd_api.g_ret_sts_success;
603:
604: if aso_debug_pub.g_debug_flag = 'Y' then
605: aso_debug_pub.add('do_check_atp: ********Printing the Input to Check ATP API *************', 1, 'Y');
606: aso_debug_pub.add('do_check_atp: p_qte_header_rec.quote_header_id: '|| p_qte_header_rec.quote_header_id, 1, 'Y');
607: aso_debug_pub.add('do_check_atp: p_entire_quote_flag: '|| p_entire_quote_flag, 1, 'Y');
608: aso_debug_pub.add('do_check_atp: p_qte_line_tbl.count: '|| p_qte_line_tbl.count, 1, 'Y');
601:
602: x_return_status := fnd_api.g_ret_sts_success;
603:
604: if aso_debug_pub.g_debug_flag = 'Y' then
605: aso_debug_pub.add('do_check_atp: ********Printing the Input to Check ATP API *************', 1, 'Y');
606: aso_debug_pub.add('do_check_atp: p_qte_header_rec.quote_header_id: '|| p_qte_header_rec.quote_header_id, 1, 'Y');
607: aso_debug_pub.add('do_check_atp: p_entire_quote_flag: '|| p_entire_quote_flag, 1, 'Y');
608: aso_debug_pub.add('do_check_atp: p_qte_line_tbl.count: '|| p_qte_line_tbl.count, 1, 'Y');
609: for i in 1..p_qte_line_tbl.count loop
602: x_return_status := fnd_api.g_ret_sts_success;
603:
604: if aso_debug_pub.g_debug_flag = 'Y' then
605: aso_debug_pub.add('do_check_atp: ********Printing the Input to Check ATP API *************', 1, 'Y');
606: aso_debug_pub.add('do_check_atp: p_qte_header_rec.quote_header_id: '|| p_qte_header_rec.quote_header_id, 1, 'Y');
607: aso_debug_pub.add('do_check_atp: p_entire_quote_flag: '|| p_entire_quote_flag, 1, 'Y');
608: aso_debug_pub.add('do_check_atp: p_qte_line_tbl.count: '|| p_qte_line_tbl.count, 1, 'Y');
609: for i in 1..p_qte_line_tbl.count loop
610: aso_debug_pub.add('do_check_atp: p_qte_line_tbl('||i||').quote_line_id: '|| p_qte_line_tbl(i).quote_line_id, 1, 'Y');
603:
604: if aso_debug_pub.g_debug_flag = 'Y' then
605: aso_debug_pub.add('do_check_atp: ********Printing the Input to Check ATP API *************', 1, 'Y');
606: aso_debug_pub.add('do_check_atp: p_qte_header_rec.quote_header_id: '|| p_qte_header_rec.quote_header_id, 1, 'Y');
607: aso_debug_pub.add('do_check_atp: p_entire_quote_flag: '|| p_entire_quote_flag, 1, 'Y');
608: aso_debug_pub.add('do_check_atp: p_qte_line_tbl.count: '|| p_qte_line_tbl.count, 1, 'Y');
609: for i in 1..p_qte_line_tbl.count loop
610: aso_debug_pub.add('do_check_atp: p_qte_line_tbl('||i||').quote_line_id: '|| p_qte_line_tbl(i).quote_line_id, 1, 'Y');
611: aso_debug_pub.add('do_check_atp: p_qte_line_tbl('||i||').quote_header_id: '|| p_qte_line_tbl(i).quote_header_id, 1, 'Y');
604: if aso_debug_pub.g_debug_flag = 'Y' then
605: aso_debug_pub.add('do_check_atp: ********Printing the Input to Check ATP API *************', 1, 'Y');
606: aso_debug_pub.add('do_check_atp: p_qte_header_rec.quote_header_id: '|| p_qte_header_rec.quote_header_id, 1, 'Y');
607: aso_debug_pub.add('do_check_atp: p_entire_quote_flag: '|| p_entire_quote_flag, 1, 'Y');
608: aso_debug_pub.add('do_check_atp: p_qte_line_tbl.count: '|| p_qte_line_tbl.count, 1, 'Y');
609: for i in 1..p_qte_line_tbl.count loop
610: aso_debug_pub.add('do_check_atp: p_qte_line_tbl('||i||').quote_line_id: '|| p_qte_line_tbl(i).quote_line_id, 1, 'Y');
611: aso_debug_pub.add('do_check_atp: p_qte_line_tbl('||i||').quote_header_id: '|| p_qte_line_tbl(i).quote_header_id, 1, 'Y');
612: end loop;
606: aso_debug_pub.add('do_check_atp: p_qte_header_rec.quote_header_id: '|| p_qte_header_rec.quote_header_id, 1, 'Y');
607: aso_debug_pub.add('do_check_atp: p_entire_quote_flag: '|| p_entire_quote_flag, 1, 'Y');
608: aso_debug_pub.add('do_check_atp: p_qte_line_tbl.count: '|| p_qte_line_tbl.count, 1, 'Y');
609: for i in 1..p_qte_line_tbl.count loop
610: aso_debug_pub.add('do_check_atp: p_qte_line_tbl('||i||').quote_line_id: '|| p_qte_line_tbl(i).quote_line_id, 1, 'Y');
611: aso_debug_pub.add('do_check_atp: p_qte_line_tbl('||i||').quote_header_id: '|| p_qte_line_tbl(i).quote_header_id, 1, 'Y');
612: end loop;
613: aso_debug_pub.add('do_check_atp: p_shipment_tbl.count: '|| p_shipment_tbl.count, 1, 'Y');
614: for i in 1..p_shipment_tbl.count loop
607: aso_debug_pub.add('do_check_atp: p_entire_quote_flag: '|| p_entire_quote_flag, 1, 'Y');
608: aso_debug_pub.add('do_check_atp: p_qte_line_tbl.count: '|| p_qte_line_tbl.count, 1, 'Y');
609: for i in 1..p_qte_line_tbl.count loop
610: aso_debug_pub.add('do_check_atp: p_qte_line_tbl('||i||').quote_line_id: '|| p_qte_line_tbl(i).quote_line_id, 1, 'Y');
611: aso_debug_pub.add('do_check_atp: p_qte_line_tbl('||i||').quote_header_id: '|| p_qte_line_tbl(i).quote_header_id, 1, 'Y');
612: end loop;
613: aso_debug_pub.add('do_check_atp: p_shipment_tbl.count: '|| p_shipment_tbl.count, 1, 'Y');
614: for i in 1..p_shipment_tbl.count loop
615: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').ship_method_code: '|| p_shipment_tbl(i).ship_method_code, 1, 'Y');
609: for i in 1..p_qte_line_tbl.count loop
610: aso_debug_pub.add('do_check_atp: p_qte_line_tbl('||i||').quote_line_id: '|| p_qte_line_tbl(i).quote_line_id, 1, 'Y');
611: aso_debug_pub.add('do_check_atp: p_qte_line_tbl('||i||').quote_header_id: '|| p_qte_line_tbl(i).quote_header_id, 1, 'Y');
612: end loop;
613: aso_debug_pub.add('do_check_atp: p_shipment_tbl.count: '|| p_shipment_tbl.count, 1, 'Y');
614: for i in 1..p_shipment_tbl.count loop
615: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').ship_method_code: '|| p_shipment_tbl(i).ship_method_code, 1, 'Y');
616: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').ship_from_org_id: '|| p_shipment_tbl(i).ship_from_org_id, 1, 'Y');
617: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').demand_class_code: '|| p_shipment_tbl(i).demand_class_code, 1, 'Y');
611: aso_debug_pub.add('do_check_atp: p_qte_line_tbl('||i||').quote_header_id: '|| p_qte_line_tbl(i).quote_header_id, 1, 'Y');
612: end loop;
613: aso_debug_pub.add('do_check_atp: p_shipment_tbl.count: '|| p_shipment_tbl.count, 1, 'Y');
614: for i in 1..p_shipment_tbl.count loop
615: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').ship_method_code: '|| p_shipment_tbl(i).ship_method_code, 1, 'Y');
616: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').ship_from_org_id: '|| p_shipment_tbl(i).ship_from_org_id, 1, 'Y');
617: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').demand_class_code: '|| p_shipment_tbl(i).demand_class_code, 1, 'Y');
618: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').request_date: '|| p_shipment_tbl(i).request_date, 1, 'Y');
619: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').shipment_id: '|| p_shipment_tbl(i).shipment_id, 1, 'Y');
612: end loop;
613: aso_debug_pub.add('do_check_atp: p_shipment_tbl.count: '|| p_shipment_tbl.count, 1, 'Y');
614: for i in 1..p_shipment_tbl.count loop
615: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').ship_method_code: '|| p_shipment_tbl(i).ship_method_code, 1, 'Y');
616: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').ship_from_org_id: '|| p_shipment_tbl(i).ship_from_org_id, 1, 'Y');
617: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').demand_class_code: '|| p_shipment_tbl(i).demand_class_code, 1, 'Y');
618: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').request_date: '|| p_shipment_tbl(i).request_date, 1, 'Y');
619: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').shipment_id: '|| p_shipment_tbl(i).shipment_id, 1, 'Y');
620: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').quote_line_id: '|| p_shipment_tbl(i).quote_line_id, 1, 'Y');
613: aso_debug_pub.add('do_check_atp: p_shipment_tbl.count: '|| p_shipment_tbl.count, 1, 'Y');
614: for i in 1..p_shipment_tbl.count loop
615: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').ship_method_code: '|| p_shipment_tbl(i).ship_method_code, 1, 'Y');
616: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').ship_from_org_id: '|| p_shipment_tbl(i).ship_from_org_id, 1, 'Y');
617: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').demand_class_code: '|| p_shipment_tbl(i).demand_class_code, 1, 'Y');
618: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').request_date: '|| p_shipment_tbl(i).request_date, 1, 'Y');
619: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').shipment_id: '|| p_shipment_tbl(i).shipment_id, 1, 'Y');
620: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').quote_line_id: '|| p_shipment_tbl(i).quote_line_id, 1, 'Y');
621: end loop;
614: for i in 1..p_shipment_tbl.count loop
615: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').ship_method_code: '|| p_shipment_tbl(i).ship_method_code, 1, 'Y');
616: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').ship_from_org_id: '|| p_shipment_tbl(i).ship_from_org_id, 1, 'Y');
617: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').demand_class_code: '|| p_shipment_tbl(i).demand_class_code, 1, 'Y');
618: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').request_date: '|| p_shipment_tbl(i).request_date, 1, 'Y');
619: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').shipment_id: '|| p_shipment_tbl(i).shipment_id, 1, 'Y');
620: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').quote_line_id: '|| p_shipment_tbl(i).quote_line_id, 1, 'Y');
621: end loop;
622: aso_debug_pub.add('do_check_atp: **************************************************************', 1, 'Y');
615: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').ship_method_code: '|| p_shipment_tbl(i).ship_method_code, 1, 'Y');
616: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').ship_from_org_id: '|| p_shipment_tbl(i).ship_from_org_id, 1, 'Y');
617: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').demand_class_code: '|| p_shipment_tbl(i).demand_class_code, 1, 'Y');
618: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').request_date: '|| p_shipment_tbl(i).request_date, 1, 'Y');
619: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').shipment_id: '|| p_shipment_tbl(i).shipment_id, 1, 'Y');
620: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').quote_line_id: '|| p_shipment_tbl(i).quote_line_id, 1, 'Y');
621: end loop;
622: aso_debug_pub.add('do_check_atp: **************************************************************', 1, 'Y');
623: end if;
616: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').ship_from_org_id: '|| p_shipment_tbl(i).ship_from_org_id, 1, 'Y');
617: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').demand_class_code: '|| p_shipment_tbl(i).demand_class_code, 1, 'Y');
618: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').request_date: '|| p_shipment_tbl(i).request_date, 1, 'Y');
619: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').shipment_id: '|| p_shipment_tbl(i).shipment_id, 1, 'Y');
620: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').quote_line_id: '|| p_shipment_tbl(i).quote_line_id, 1, 'Y');
621: end loop;
622: aso_debug_pub.add('do_check_atp: **************************************************************', 1, 'Y');
623: end if;
624:
618: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').request_date: '|| p_shipment_tbl(i).request_date, 1, 'Y');
619: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').shipment_id: '|| p_shipment_tbl(i).shipment_id, 1, 'Y');
620: aso_debug_pub.add('do_check_atp: p_shipment_tbl('||i||').quote_line_id: '|| p_shipment_tbl(i).quote_line_id, 1, 'Y');
621: end loop;
622: aso_debug_pub.add('do_check_atp: **************************************************************', 1, 'Y');
623: end if;
624:
625:
626:
627: if p_qte_line_tbl.count = 0 and p_shipment_tbl.count = 0 then
628:
629: if p_qte_header_rec.quote_header_id is null or p_qte_header_rec.quote_header_id = fnd_api.g_miss_num then
630:
631: if aso_debug_pub.g_debug_flag = 'Y' THEN
632: aso_debug_pub.add('do_check_atp: p_qte_line_tbl and p_shipment_tbl is null. Also p_qte_header_rec.quote_header_id is null');
633: end if;
634:
635: if fnd_msg_pub.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
628:
629: if p_qte_header_rec.quote_header_id is null or p_qte_header_rec.quote_header_id = fnd_api.g_miss_num then
630:
631: if aso_debug_pub.g_debug_flag = 'Y' THEN
632: aso_debug_pub.add('do_check_atp: p_qte_line_tbl and p_shipment_tbl is null. Also p_qte_header_rec.quote_header_id is null');
633: end if;
634:
635: if fnd_msg_pub.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
636: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ALL_MISSING_PARAM');
662: close get_no_of_lines;
663:
664: if p_qte_line_tbl.count = l_no_of_lines then
665:
666: if aso_debug_pub.g_debug_flag = 'Y' then
667: aso_debug_pub.add('do_check_atp: No of lines passed is equal to no lines in db, hence whole qte is true', 1, 'Y');
668: end if;
669: l_check_atp_for_whole_quote := fnd_api.g_true;
670: end if;
663:
664: if p_qte_line_tbl.count = l_no_of_lines then
665:
666: if aso_debug_pub.g_debug_flag = 'Y' then
667: aso_debug_pub.add('do_check_atp: No of lines passed is equal to no lines in db, hence whole qte is true', 1, 'Y');
668: end if;
669: l_check_atp_for_whole_quote := fnd_api.g_true;
670: end if;
671:
672: end if;
673:
674: if ((p_entire_quote_flag = 'Y') or (l_check_atp_for_whole_quote = fnd_api.g_true)) then
675:
676: if aso_debug_pub.g_debug_flag = 'Y' then
677: aso_debug_pub.add('do_check_atp: Getting the quote lines and shipment from db', 1, 'Y');
678: end if;
679: l_qte_line_tbl := aso_utility_pvt.query_qte_line_rows_atp(p_qte_header_rec.quote_header_id);
680: for i in 1..l_qte_line_tbl.count loop
673:
674: if ((p_entire_quote_flag = 'Y') or (l_check_atp_for_whole_quote = fnd_api.g_true)) then
675:
676: if aso_debug_pub.g_debug_flag = 'Y' then
677: aso_debug_pub.add('do_check_atp: Getting the quote lines and shipment from db', 1, 'Y');
678: end if;
679: l_qte_line_tbl := aso_utility_pvt.query_qte_line_rows_atp(p_qte_header_rec.quote_header_id);
680: for i in 1..l_qte_line_tbl.count loop
681: l_shipment_rec := aso_utility_pvt.query_line_shipment_row_atp(p_qte_header_rec.quote_header_id,
684: end loop;
685: l_check_atp_for_whole_quote := fnd_api.g_true;
686: end if;
687:
688: if aso_debug_pub.g_debug_flag = 'Y' then
689: aso_debug_pub.add('do_check_atp: Before creating the search tables', 1, 'Y');
690: end if;
691:
692:
685: l_check_atp_for_whole_quote := fnd_api.g_true;
686: end if;
687:
688: if aso_debug_pub.g_debug_flag = 'Y' then
689: aso_debug_pub.add('do_check_atp: Before creating the search tables', 1, 'Y');
690: end if;
691:
692:
693: --create quote line search table
694: for i in 1..p_qte_line_tbl.count loop
695:
696: if p_qte_line_tbl(i).quote_line_id is not null and p_qte_line_tbl(i).quote_line_id <> fnd_api.g_miss_num then
697:
698: if aso_debug_pub.g_debug_flag = 'Y' then
699: aso_debug_pub.add('do_check_atp: p_qte_line_tbl(i).quote_line_id: ' || p_qte_line_tbl(i).quote_line_id,1,'Y');
700: end if;
701:
702: l_qte_line_search_tbl(p_qte_line_tbl(i).quote_line_id) := i;
695:
696: if p_qte_line_tbl(i).quote_line_id is not null and p_qte_line_tbl(i).quote_line_id <> fnd_api.g_miss_num then
697:
698: if aso_debug_pub.g_debug_flag = 'Y' then
699: aso_debug_pub.add('do_check_atp: p_qte_line_tbl(i).quote_line_id: ' || p_qte_line_tbl(i).quote_line_id,1,'Y');
700: end if;
701:
702: l_qte_line_search_tbl(p_qte_line_tbl(i).quote_line_id) := i;
703:
701:
702: l_qte_line_search_tbl(p_qte_line_tbl(i).quote_line_id) := i;
703:
704: else
705: if aso_debug_pub.g_debug_flag = 'Y' then
706: aso_debug_pub.add('do_check_atp: p_qte_line_tbl(i).quote_line_id: ' || p_qte_line_tbl(i).quote_line_id,1,'Y');
707: aso_debug_pub.add('do_check_atp: Quote_line_id is passed as nulll or g_miss_num in line record' ,1,'Y');
708: end if;
709:
702: l_qte_line_search_tbl(p_qte_line_tbl(i).quote_line_id) := i;
703:
704: else
705: if aso_debug_pub.g_debug_flag = 'Y' then
706: aso_debug_pub.add('do_check_atp: p_qte_line_tbl(i).quote_line_id: ' || p_qte_line_tbl(i).quote_line_id,1,'Y');
707: aso_debug_pub.add('do_check_atp: Quote_line_id is passed as nulll or g_miss_num in line record' ,1,'Y');
708: end if;
709:
710: if fnd_msg_pub.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
703:
704: else
705: if aso_debug_pub.g_debug_flag = 'Y' then
706: aso_debug_pub.add('do_check_atp: p_qte_line_tbl(i).quote_line_id: ' || p_qte_line_tbl(i).quote_line_id,1,'Y');
707: aso_debug_pub.add('do_check_atp: Quote_line_id is passed as nulll or g_miss_num in line record' ,1,'Y');
708: end if;
709:
710: if fnd_msg_pub.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
711: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_INFO');
726: for i in 1..p_shipment_tbl.count loop
727:
728: if p_shipment_tbl(i).shipment_id is not null and p_shipment_tbl(i).shipment_id <> fnd_api.g_miss_num then
729:
730: if aso_debug_pub.g_debug_flag = 'Y' then
731: aso_debug_pub.add('do_check_atp: p_shipment_tbl(i).shipment_id: ' || p_shipment_tbl(i).shipment_id,1,'Y');
732: end if;
733:
734: l_shipment_search_tbl(p_shipment_tbl(i).shipment_id) := i;
727:
728: if p_shipment_tbl(i).shipment_id is not null and p_shipment_tbl(i).shipment_id <> fnd_api.g_miss_num then
729:
730: if aso_debug_pub.g_debug_flag = 'Y' then
731: aso_debug_pub.add('do_check_atp: p_shipment_tbl(i).shipment_id: ' || p_shipment_tbl(i).shipment_id,1,'Y');
732: end if;
733:
734: l_shipment_search_tbl(p_shipment_tbl(i).shipment_id) := i;
735:
734: l_shipment_search_tbl(p_shipment_tbl(i).shipment_id) := i;
735:
736: else
737:
738: if aso_debug_pub.g_debug_flag = 'Y' then
739: aso_debug_pub.add('do_check_atp: p_shipment_tbl(i).shipment_id: ' || p_shipment_tbl(i).shipment_id,1,'Y');
740: aso_debug_pub.add('do_check_atp: shipment_id is passed as nulll or g_miss_num in shipment record' ,1,'Y');
741: end if;
742:
735:
736: else
737:
738: if aso_debug_pub.g_debug_flag = 'Y' then
739: aso_debug_pub.add('do_check_atp: p_shipment_tbl(i).shipment_id: ' || p_shipment_tbl(i).shipment_id,1,'Y');
740: aso_debug_pub.add('do_check_atp: shipment_id is passed as nulll or g_miss_num in shipment record' ,1,'Y');
741: end if;
742:
743: open c_shipment_id(p_qte_line_tbl(i).quote_line_id);
736: else
737:
738: if aso_debug_pub.g_debug_flag = 'Y' then
739: aso_debug_pub.add('do_check_atp: p_shipment_tbl(i).shipment_id: ' || p_shipment_tbl(i).shipment_id,1,'Y');
740: aso_debug_pub.add('do_check_atp: shipment_id is passed as nulll or g_miss_num in shipment record' ,1,'Y');
741: end if;
742:
743: open c_shipment_id(p_qte_line_tbl(i).quote_line_id);
744: fetch c_shipment_id into l_shipment_tbl(i).shipment_id;
758: end if;
759:
760: end loop;
761:
762: if aso_debug_pub.g_debug_flag = 'Y' then
763: aso_debug_pub.add('do_check_atp: After Creating the search tables ' ,1,'Y');
764: aso_debug_pub.add('do_check_atp: l_shipment_search_tbl.count : '||l_shipment_search_tbl.count ,1,'Y');
765: aso_debug_pub.add('do_check_atp: l_qte_line_search_tbl.count : '||l_qte_line_search_tbl.count ,1,'Y');
766: end if;
759:
760: end loop;
761:
762: if aso_debug_pub.g_debug_flag = 'Y' then
763: aso_debug_pub.add('do_check_atp: After Creating the search tables ' ,1,'Y');
764: aso_debug_pub.add('do_check_atp: l_shipment_search_tbl.count : '||l_shipment_search_tbl.count ,1,'Y');
765: aso_debug_pub.add('do_check_atp: l_qte_line_search_tbl.count : '||l_qte_line_search_tbl.count ,1,'Y');
766: end if;
767:
760: end loop;
761:
762: if aso_debug_pub.g_debug_flag = 'Y' then
763: aso_debug_pub.add('do_check_atp: After Creating the search tables ' ,1,'Y');
764: aso_debug_pub.add('do_check_atp: l_shipment_search_tbl.count : '||l_shipment_search_tbl.count ,1,'Y');
765: aso_debug_pub.add('do_check_atp: l_qte_line_search_tbl.count : '||l_qte_line_search_tbl.count ,1,'Y');
766: end if;
767:
768: -- now honor the values that have been passed
761:
762: if aso_debug_pub.g_debug_flag = 'Y' then
763: aso_debug_pub.add('do_check_atp: After Creating the search tables ' ,1,'Y');
764: aso_debug_pub.add('do_check_atp: l_shipment_search_tbl.count : '||l_shipment_search_tbl.count ,1,'Y');
765: aso_debug_pub.add('do_check_atp: l_qte_line_search_tbl.count : '||l_qte_line_search_tbl.count ,1,'Y');
766: end if;
767:
768: -- now honor the values that have been passed
769: /* for i in 1..p_qte_line_tbl.count loop
800: exit;
801: end if;
802: end loop;
803:
804: if aso_debug_pub.g_debug_flag = 'Y' then
805: aso_debug_pub.add('do_check_atp: Record found in shipment search tbl ' ,1,'Y');
806: aso_debug_pub.add('do_check_atp: l_shipment_tbl.count : '||l_shipment_tbl.count ,1,'Y');
807: aso_debug_pub.add('do_check_atp: index is : '|| l_index ,1,'Y');
808: end if;
801: end if;
802: end loop;
803:
804: if aso_debug_pub.g_debug_flag = 'Y' then
805: aso_debug_pub.add('do_check_atp: Record found in shipment search tbl ' ,1,'Y');
806: aso_debug_pub.add('do_check_atp: l_shipment_tbl.count : '||l_shipment_tbl.count ,1,'Y');
807: aso_debug_pub.add('do_check_atp: index is : '|| l_index ,1,'Y');
808: end if;
809:
802: end loop;
803:
804: if aso_debug_pub.g_debug_flag = 'Y' then
805: aso_debug_pub.add('do_check_atp: Record found in shipment search tbl ' ,1,'Y');
806: aso_debug_pub.add('do_check_atp: l_shipment_tbl.count : '||l_shipment_tbl.count ,1,'Y');
807: aso_debug_pub.add('do_check_atp: index is : '|| l_index ,1,'Y');
808: end if;
809:
810: if p_shipment_tbl(i).ship_method_code <> fnd_api.g_miss_char then
803:
804: if aso_debug_pub.g_debug_flag = 'Y' then
805: aso_debug_pub.add('do_check_atp: Record found in shipment search tbl ' ,1,'Y');
806: aso_debug_pub.add('do_check_atp: l_shipment_tbl.count : '||l_shipment_tbl.count ,1,'Y');
807: aso_debug_pub.add('do_check_atp: index is : '|| l_index ,1,'Y');
808: end if;
809:
810: if p_shipment_tbl(i).ship_method_code <> fnd_api.g_miss_char then
811: l_shipment_tbl(l_index).ship_method_code := p_shipment_tbl(i).ship_method_code;
830:
831: -- make sure variable gets reset
832: l_shipment_id := null;
833:
834: if aso_debug_pub.g_debug_flag = 'Y' then
835: aso_debug_pub.add('do_check_atp:After honoring input and creating seacrh tbl l_qte_line_tbl.count: ' || l_qte_line_tbl.count,1,'Y');
836: aso_debug_pub.add('do_check_atp:After honoring input and creating seacrh tbl l_shipment_tbl.count: ' || l_shipment_tbl.count,1,'Y');
837: aso_debug_pub.add('do_check_atp: p_qte_line_tbl.count: ' || p_qte_line_tbl.count,1,'Y');
838: aso_debug_pub.add('do_check_atp: l_qte_line_search_tbl.count: ' || l_qte_line_search_tbl.count,1,'Y');
831: -- make sure variable gets reset
832: l_shipment_id := null;
833:
834: if aso_debug_pub.g_debug_flag = 'Y' then
835: aso_debug_pub.add('do_check_atp:After honoring input and creating seacrh tbl l_qte_line_tbl.count: ' || l_qte_line_tbl.count,1,'Y');
836: aso_debug_pub.add('do_check_atp:After honoring input and creating seacrh tbl l_shipment_tbl.count: ' || l_shipment_tbl.count,1,'Y');
837: aso_debug_pub.add('do_check_atp: p_qte_line_tbl.count: ' || p_qte_line_tbl.count,1,'Y');
838: aso_debug_pub.add('do_check_atp: l_qte_line_search_tbl.count: ' || l_qte_line_search_tbl.count,1,'Y');
839: aso_debug_pub.add('do_check_atp: l_check_atp_for_whole_quote: '|| l_check_atp_for_whole_quote, 1, 'Y');
832: l_shipment_id := null;
833:
834: if aso_debug_pub.g_debug_flag = 'Y' then
835: aso_debug_pub.add('do_check_atp:After honoring input and creating seacrh tbl l_qte_line_tbl.count: ' || l_qte_line_tbl.count,1,'Y');
836: aso_debug_pub.add('do_check_atp:After honoring input and creating seacrh tbl l_shipment_tbl.count: ' || l_shipment_tbl.count,1,'Y');
837: aso_debug_pub.add('do_check_atp: p_qte_line_tbl.count: ' || p_qte_line_tbl.count,1,'Y');
838: aso_debug_pub.add('do_check_atp: l_qte_line_search_tbl.count: ' || l_qte_line_search_tbl.count,1,'Y');
839: aso_debug_pub.add('do_check_atp: l_check_atp_for_whole_quote: '|| l_check_atp_for_whole_quote, 1, 'Y');
840: end if;
833:
834: if aso_debug_pub.g_debug_flag = 'Y' then
835: aso_debug_pub.add('do_check_atp:After honoring input and creating seacrh tbl l_qte_line_tbl.count: ' || l_qte_line_tbl.count,1,'Y');
836: aso_debug_pub.add('do_check_atp:After honoring input and creating seacrh tbl l_shipment_tbl.count: ' || l_shipment_tbl.count,1,'Y');
837: aso_debug_pub.add('do_check_atp: p_qte_line_tbl.count: ' || p_qte_line_tbl.count,1,'Y');
838: aso_debug_pub.add('do_check_atp: l_qte_line_search_tbl.count: ' || l_qte_line_search_tbl.count,1,'Y');
839: aso_debug_pub.add('do_check_atp: l_check_atp_for_whole_quote: '|| l_check_atp_for_whole_quote, 1, 'Y');
840: end if;
841:
834: if aso_debug_pub.g_debug_flag = 'Y' then
835: aso_debug_pub.add('do_check_atp:After honoring input and creating seacrh tbl l_qte_line_tbl.count: ' || l_qte_line_tbl.count,1,'Y');
836: aso_debug_pub.add('do_check_atp:After honoring input and creating seacrh tbl l_shipment_tbl.count: ' || l_shipment_tbl.count,1,'Y');
837: aso_debug_pub.add('do_check_atp: p_qte_line_tbl.count: ' || p_qte_line_tbl.count,1,'Y');
838: aso_debug_pub.add('do_check_atp: l_qte_line_search_tbl.count: ' || l_qte_line_search_tbl.count,1,'Y');
839: aso_debug_pub.add('do_check_atp: l_check_atp_for_whole_quote: '|| l_check_atp_for_whole_quote, 1, 'Y');
840: end if;
841:
842: if l_check_atp_for_whole_quote = fnd_api.g_false then
835: aso_debug_pub.add('do_check_atp:After honoring input and creating seacrh tbl l_qte_line_tbl.count: ' || l_qte_line_tbl.count,1,'Y');
836: aso_debug_pub.add('do_check_atp:After honoring input and creating seacrh tbl l_shipment_tbl.count: ' || l_shipment_tbl.count,1,'Y');
837: aso_debug_pub.add('do_check_atp: p_qte_line_tbl.count: ' || p_qte_line_tbl.count,1,'Y');
838: aso_debug_pub.add('do_check_atp: l_qte_line_search_tbl.count: ' || l_qte_line_search_tbl.count,1,'Y');
839: aso_debug_pub.add('do_check_atp: l_check_atp_for_whole_quote: '|| l_check_atp_for_whole_quote, 1, 'Y');
840: end if;
841:
842: if l_check_atp_for_whole_quote = fnd_api.g_false then
843:
843:
844: --Add configured lines to input table if it is not passed
845: for i in 1..p_qte_line_tbl.count loop
846:
847: if aso_debug_pub.g_debug_flag = 'Y' then
848: aso_debug_pub.add('do_check_atp: p_qte_line_tbl('||i||').quote_line_id: ' || p_qte_line_tbl(i).quote_line_id,1,'Y');
849: end if;
850:
851: for row in c_config_dtl(p_qte_line_tbl(i).quote_line_id) loop
844: --Add configured lines to input table if it is not passed
845: for i in 1..p_qte_line_tbl.count loop
846:
847: if aso_debug_pub.g_debug_flag = 'Y' then
848: aso_debug_pub.add('do_check_atp: p_qte_line_tbl('||i||').quote_line_id: ' || p_qte_line_tbl(i).quote_line_id,1,'Y');
849: end if;
850:
851: for row in c_config_dtl(p_qte_line_tbl(i).quote_line_id) loop
852:
849: end if;
850:
851: for row in c_config_dtl(p_qte_line_tbl(i).quote_line_id) loop
852:
853: if aso_debug_pub.g_debug_flag = 'Y' then
854: aso_debug_pub.add('do_check_atp: row.quote_line_id: '||row.quote_line_id);
855: aso_debug_pub.add('do_check_atp: row.item_type_code: '||row.item_type_code);
856: aso_debug_pub.add('do_check_atp: row.config_header_id: '||row.config_header_id);
857: aso_debug_pub.add('do_check_atp: row.config_revision_num: '||row.config_revision_num);
850:
851: for row in c_config_dtl(p_qte_line_tbl(i).quote_line_id) loop
852:
853: if aso_debug_pub.g_debug_flag = 'Y' then
854: aso_debug_pub.add('do_check_atp: row.quote_line_id: '||row.quote_line_id);
855: aso_debug_pub.add('do_check_atp: row.item_type_code: '||row.item_type_code);
856: aso_debug_pub.add('do_check_atp: row.config_header_id: '||row.config_header_id);
857: aso_debug_pub.add('do_check_atp: row.config_revision_num: '||row.config_revision_num);
858: aso_debug_pub.add('do_check_atp: row.component_code: '||row.component_code);
851: for row in c_config_dtl(p_qte_line_tbl(i).quote_line_id) loop
852:
853: if aso_debug_pub.g_debug_flag = 'Y' then
854: aso_debug_pub.add('do_check_atp: row.quote_line_id: '||row.quote_line_id);
855: aso_debug_pub.add('do_check_atp: row.item_type_code: '||row.item_type_code);
856: aso_debug_pub.add('do_check_atp: row.config_header_id: '||row.config_header_id);
857: aso_debug_pub.add('do_check_atp: row.config_revision_num: '||row.config_revision_num);
858: aso_debug_pub.add('do_check_atp: row.component_code: '||row.component_code);
859: aso_debug_pub.add('do_check_atp: row.config_item_id: '||row.config_item_id);
852:
853: if aso_debug_pub.g_debug_flag = 'Y' then
854: aso_debug_pub.add('do_check_atp: row.quote_line_id: '||row.quote_line_id);
855: aso_debug_pub.add('do_check_atp: row.item_type_code: '||row.item_type_code);
856: aso_debug_pub.add('do_check_atp: row.config_header_id: '||row.config_header_id);
857: aso_debug_pub.add('do_check_atp: row.config_revision_num: '||row.config_revision_num);
858: aso_debug_pub.add('do_check_atp: row.component_code: '||row.component_code);
859: aso_debug_pub.add('do_check_atp: row.config_item_id: '||row.config_item_id);
860: aso_debug_pub.add('do_check_atp: row.ref_line_id: '||row.ref_line_id);
853: if aso_debug_pub.g_debug_flag = 'Y' then
854: aso_debug_pub.add('do_check_atp: row.quote_line_id: '||row.quote_line_id);
855: aso_debug_pub.add('do_check_atp: row.item_type_code: '||row.item_type_code);
856: aso_debug_pub.add('do_check_atp: row.config_header_id: '||row.config_header_id);
857: aso_debug_pub.add('do_check_atp: row.config_revision_num: '||row.config_revision_num);
858: aso_debug_pub.add('do_check_atp: row.component_code: '||row.component_code);
859: aso_debug_pub.add('do_check_atp: row.config_item_id: '||row.config_item_id);
860: aso_debug_pub.add('do_check_atp: row.ref_line_id: '||row.ref_line_id);
861: aso_debug_pub.add('do_check_atp: row.top_model_line_id: '||row.top_model_line_id);
854: aso_debug_pub.add('do_check_atp: row.quote_line_id: '||row.quote_line_id);
855: aso_debug_pub.add('do_check_atp: row.item_type_code: '||row.item_type_code);
856: aso_debug_pub.add('do_check_atp: row.config_header_id: '||row.config_header_id);
857: aso_debug_pub.add('do_check_atp: row.config_revision_num: '||row.config_revision_num);
858: aso_debug_pub.add('do_check_atp: row.component_code: '||row.component_code);
859: aso_debug_pub.add('do_check_atp: row.config_item_id: '||row.config_item_id);
860: aso_debug_pub.add('do_check_atp: row.ref_line_id: '||row.ref_line_id);
861: aso_debug_pub.add('do_check_atp: row.top_model_line_id: '||row.top_model_line_id);
862: aso_debug_pub.add('do_check_atp: row.ato_line_id: '||row.ato_line_id);
855: aso_debug_pub.add('do_check_atp: row.item_type_code: '||row.item_type_code);
856: aso_debug_pub.add('do_check_atp: row.config_header_id: '||row.config_header_id);
857: aso_debug_pub.add('do_check_atp: row.config_revision_num: '||row.config_revision_num);
858: aso_debug_pub.add('do_check_atp: row.component_code: '||row.component_code);
859: aso_debug_pub.add('do_check_atp: row.config_item_id: '||row.config_item_id);
860: aso_debug_pub.add('do_check_atp: row.ref_line_id: '||row.ref_line_id);
861: aso_debug_pub.add('do_check_atp: row.top_model_line_id: '||row.top_model_line_id);
862: aso_debug_pub.add('do_check_atp: row.ato_line_id: '||row.ato_line_id);
863: aso_debug_pub.add('do_check_atp: row.component_sequence_id: '||row.component_sequence_id);
856: aso_debug_pub.add('do_check_atp: row.config_header_id: '||row.config_header_id);
857: aso_debug_pub.add('do_check_atp: row.config_revision_num: '||row.config_revision_num);
858: aso_debug_pub.add('do_check_atp: row.component_code: '||row.component_code);
859: aso_debug_pub.add('do_check_atp: row.config_item_id: '||row.config_item_id);
860: aso_debug_pub.add('do_check_atp: row.ref_line_id: '||row.ref_line_id);
861: aso_debug_pub.add('do_check_atp: row.top_model_line_id: '||row.top_model_line_id);
862: aso_debug_pub.add('do_check_atp: row.ato_line_id: '||row.ato_line_id);
863: aso_debug_pub.add('do_check_atp: row.component_sequence_id: '||row.component_sequence_id);
864: aso_debug_pub.add('do_check_atp: row.ship_model_complete_flag: '||row.ship_model_complete_flag);
857: aso_debug_pub.add('do_check_atp: row.config_revision_num: '||row.config_revision_num);
858: aso_debug_pub.add('do_check_atp: row.component_code: '||row.component_code);
859: aso_debug_pub.add('do_check_atp: row.config_item_id: '||row.config_item_id);
860: aso_debug_pub.add('do_check_atp: row.ref_line_id: '||row.ref_line_id);
861: aso_debug_pub.add('do_check_atp: row.top_model_line_id: '||row.top_model_line_id);
862: aso_debug_pub.add('do_check_atp: row.ato_line_id: '||row.ato_line_id);
863: aso_debug_pub.add('do_check_atp: row.component_sequence_id: '||row.component_sequence_id);
864: aso_debug_pub.add('do_check_atp: row.ship_model_complete_flag: '||row.ship_model_complete_flag);
865: end if;
858: aso_debug_pub.add('do_check_atp: row.component_code: '||row.component_code);
859: aso_debug_pub.add('do_check_atp: row.config_item_id: '||row.config_item_id);
860: aso_debug_pub.add('do_check_atp: row.ref_line_id: '||row.ref_line_id);
861: aso_debug_pub.add('do_check_atp: row.top_model_line_id: '||row.top_model_line_id);
862: aso_debug_pub.add('do_check_atp: row.ato_line_id: '||row.ato_line_id);
863: aso_debug_pub.add('do_check_atp: row.component_sequence_id: '||row.component_sequence_id);
864: aso_debug_pub.add('do_check_atp: row.ship_model_complete_flag: '||row.ship_model_complete_flag);
865: end if;
866:
859: aso_debug_pub.add('do_check_atp: row.config_item_id: '||row.config_item_id);
860: aso_debug_pub.add('do_check_atp: row.ref_line_id: '||row.ref_line_id);
861: aso_debug_pub.add('do_check_atp: row.top_model_line_id: '||row.top_model_line_id);
862: aso_debug_pub.add('do_check_atp: row.ato_line_id: '||row.ato_line_id);
863: aso_debug_pub.add('do_check_atp: row.component_sequence_id: '||row.component_sequence_id);
864: aso_debug_pub.add('do_check_atp: row.ship_model_complete_flag: '||row.ship_model_complete_flag);
865: end if;
866:
867: if row.item_type_code in('MDL', 'CFG') and row.config_header_id is not null then
860: aso_debug_pub.add('do_check_atp: row.ref_line_id: '||row.ref_line_id);
861: aso_debug_pub.add('do_check_atp: row.top_model_line_id: '||row.top_model_line_id);
862: aso_debug_pub.add('do_check_atp: row.ato_line_id: '||row.ato_line_id);
863: aso_debug_pub.add('do_check_atp: row.component_sequence_id: '||row.component_sequence_id);
864: aso_debug_pub.add('do_check_atp: row.ship_model_complete_flag: '||row.ship_model_complete_flag);
865: end if;
866:
867: if row.item_type_code in('MDL', 'CFG') and row.config_header_id is not null then
868:
867: if row.item_type_code in('MDL', 'CFG') and row.config_header_id is not null then
868:
869: if not l_config_hdr_search_tbl.exists(row.config_header_id) then
870:
871: if aso_debug_pub.g_debug_flag = 'Y' then
872: aso_debug_pub.add('do_check_atp: Inside not l_config_hdr_search_tbl.exists(row.config_header_id) cond.');
873: end if;
874:
875: --If it is a non SMC PTO then do not add all the configuration lines from database if calling application is not passing
868:
869: if not l_config_hdr_search_tbl.exists(row.config_header_id) then
870:
871: if aso_debug_pub.g_debug_flag = 'Y' then
872: aso_debug_pub.add('do_check_atp: Inside not l_config_hdr_search_tbl.exists(row.config_header_id) cond.');
873: end if;
874:
875: --If it is a non SMC PTO then do not add all the configuration lines from database if calling application is not passing
876:
875: --If it is a non SMC PTO then do not add all the configuration lines from database if calling application is not passing
876:
877: if nvl(row.ship_model_complete_flag, 'N') = 'Y' then
878:
879: if aso_debug_pub.g_debug_flag = 'Y' then
880: aso_debug_pub.add('do_check_atp: Inside row.ship_model_complete_flag = Y cond: ');
881: end if;
882:
883: --Add it to search table
876:
877: if nvl(row.ship_model_complete_flag, 'N') = 'Y' then
878:
879: if aso_debug_pub.g_debug_flag = 'Y' then
880: aso_debug_pub.add('do_check_atp: Inside row.ship_model_complete_flag = Y cond: ');
881: end if;
882:
883: --Add it to search table
884: --l_smc_search_tbl(row.top_model_line_id) := l_ship_model_complete_flag;
883: --Add it to search table
884: --l_smc_search_tbl(row.top_model_line_id) := l_ship_model_complete_flag;
885: l_config_hdr_search_tbl(row.config_header_id) := row.top_model_line_id;
886:
887: if aso_debug_pub.g_debug_flag = 'Y' then
888: aso_debug_pub.add('do_check_atp: After adding to l_config_hdr_search_tbl.');
889: end if;
890:
891: for k in c_configuration_rows(row.config_header_id, row.config_revision_num) loop
884: --l_smc_search_tbl(row.top_model_line_id) := l_ship_model_complete_flag;
885: l_config_hdr_search_tbl(row.config_header_id) := row.top_model_line_id;
886:
887: if aso_debug_pub.g_debug_flag = 'Y' then
888: aso_debug_pub.add('do_check_atp: After adding to l_config_hdr_search_tbl.');
889: end if;
890:
891: for k in c_configuration_rows(row.config_header_id, row.config_revision_num) loop
892:
889: end if;
890:
891: for k in c_configuration_rows(row.config_header_id, row.config_revision_num) loop
892:
893: if aso_debug_pub.g_debug_flag = 'Y' then
894: aso_debug_pub.add('do_check_atp: k.quote_line_id: ' || k.quote_line_id,1,'Y');
895: aso_debug_pub.add('do_check_atp: k.shipment_id: ' || k.shipment_id,1,'Y');
896: end if;
897:
890:
891: for k in c_configuration_rows(row.config_header_id, row.config_revision_num) loop
892:
893: if aso_debug_pub.g_debug_flag = 'Y' then
894: aso_debug_pub.add('do_check_atp: k.quote_line_id: ' || k.quote_line_id,1,'Y');
895: aso_debug_pub.add('do_check_atp: k.shipment_id: ' || k.shipment_id,1,'Y');
896: end if;
897:
898: if not l_qte_line_search_tbl.exists(k.quote_line_id) then
891: for k in c_configuration_rows(row.config_header_id, row.config_revision_num) loop
892:
893: if aso_debug_pub.g_debug_flag = 'Y' then
894: aso_debug_pub.add('do_check_atp: k.quote_line_id: ' || k.quote_line_id,1,'Y');
895: aso_debug_pub.add('do_check_atp: k.shipment_id: ' || k.shipment_id,1,'Y');
896: end if;
897:
898: if not l_qte_line_search_tbl.exists(k.quote_line_id) then
899:
896: end if;
897:
898: if not l_qte_line_search_tbl.exists(k.quote_line_id) then
899:
900: if aso_debug_pub.g_debug_flag = 'Y' then
901: aso_debug_pub.add('Quote line id does not exist in l_qte_line_search_tbl, so add it to l_qte_line_tbl from database');
902: end if;
903:
904: l_qte_line_rec := aso_utility_pvt.query_qte_line_row(k.quote_line_id);
897:
898: if not l_qte_line_search_tbl.exists(k.quote_line_id) then
899:
900: if aso_debug_pub.g_debug_flag = 'Y' then
901: aso_debug_pub.add('Quote line id does not exist in l_qte_line_search_tbl, so add it to l_qte_line_tbl from database');
902: end if;
903:
904: l_qte_line_rec := aso_utility_pvt.query_qte_line_row(k.quote_line_id);
905: l_qte_line_tbl(l_qte_line_tbl.count + 1) := l_qte_line_rec;
907: end if;
908:
909: if not l_shipment_search_tbl.exists(k.shipment_id) then
910:
911: if aso_debug_pub.g_debug_flag = 'Y' then
912: aso_debug_pub.add('shipment id does not exist in l_shipment_search_tbl, so add it to l_shipment_tbl from database');
913: end if;
914:
915: l_shipment_rec := aso_utility_pvt.query_shipment_row(k.shipment_id);
908:
909: if not l_shipment_search_tbl.exists(k.shipment_id) then
910:
911: if aso_debug_pub.g_debug_flag = 'Y' then
912: aso_debug_pub.add('shipment id does not exist in l_shipment_search_tbl, so add it to l_shipment_tbl from database');
913: end if;
914:
915: l_shipment_rec := aso_utility_pvt.query_shipment_row(k.shipment_id);
916: l_shipment_rec.qte_line_index := l_qte_line_tbl.count;
925: --This is a Non SMC PTO Model Line, so pass all the lines of this configuration to ATP
926:
927: l_config_hdr_search_tbl(row.config_header_id) := row.top_model_line_id;
928:
929: if aso_debug_pub.g_debug_flag = 'Y' then
930: aso_debug_pub.add('do_check_atp: After adding to l_config_hdr_search_tbl: ');
931: end if;
932:
933: for k in c_configuration_rows(row.config_header_id, row.config_revision_num) loop
926:
927: l_config_hdr_search_tbl(row.config_header_id) := row.top_model_line_id;
928:
929: if aso_debug_pub.g_debug_flag = 'Y' then
930: aso_debug_pub.add('do_check_atp: After adding to l_config_hdr_search_tbl: ');
931: end if;
932:
933: for k in c_configuration_rows(row.config_header_id, row.config_revision_num) loop
934:
931: end if;
932:
933: for k in c_configuration_rows(row.config_header_id, row.config_revision_num) loop
934:
935: if aso_debug_pub.g_debug_flag = 'Y' then
936: aso_debug_pub.add('do_check_atp: k.quote_line_id: ' || k.quote_line_id,1,'Y');
937: aso_debug_pub.add('do_check_atp: k.shipment_id: ' || k.shipment_id,1,'Y');
938: end if;
939:
932:
933: for k in c_configuration_rows(row.config_header_id, row.config_revision_num) loop
934:
935: if aso_debug_pub.g_debug_flag = 'Y' then
936: aso_debug_pub.add('do_check_atp: k.quote_line_id: ' || k.quote_line_id,1,'Y');
937: aso_debug_pub.add('do_check_atp: k.shipment_id: ' || k.shipment_id,1,'Y');
938: end if;
939:
940: if not l_qte_line_search_tbl.exists(k.quote_line_id) then
933: for k in c_configuration_rows(row.config_header_id, row.config_revision_num) loop
934:
935: if aso_debug_pub.g_debug_flag = 'Y' then
936: aso_debug_pub.add('do_check_atp: k.quote_line_id: ' || k.quote_line_id,1,'Y');
937: aso_debug_pub.add('do_check_atp: k.shipment_id: ' || k.shipment_id,1,'Y');
938: end if;
939:
940: if not l_qte_line_search_tbl.exists(k.quote_line_id) then
941:
938: end if;
939:
940: if not l_qte_line_search_tbl.exists(k.quote_line_id) then
941:
942: if aso_debug_pub.g_debug_flag = 'Y' then
943: aso_debug_pub.add('Quote line id does not exist in l_qte_line_search_tbl, so add it to l_qte_line_tbl from database');
944: end if;
945:
946: l_qte_line_rec := aso_utility_pvt.query_qte_line_row(k.quote_line_id);
939:
940: if not l_qte_line_search_tbl.exists(k.quote_line_id) then
941:
942: if aso_debug_pub.g_debug_flag = 'Y' then
943: aso_debug_pub.add('Quote line id does not exist in l_qte_line_search_tbl, so add it to l_qte_line_tbl from database');
944: end if;
945:
946: l_qte_line_rec := aso_utility_pvt.query_qte_line_row(k.quote_line_id);
947: l_qte_line_tbl(l_qte_line_tbl.count + 1) := l_qte_line_rec;
949: end if;
950:
951: if not l_shipment_search_tbl.exists(k.shipment_id) then
952:
953: if aso_debug_pub.g_debug_flag = 'Y' then
954: aso_debug_pub.add('shipment id does not exist in l_shipment_search_tbl, so add it to l_shipment_tbl from database');
955: end if;
956:
957: l_shipment_rec := aso_utility_pvt.query_shipment_row(k.shipment_id);
950:
951: if not l_shipment_search_tbl.exists(k.shipment_id) then
952:
953: if aso_debug_pub.g_debug_flag = 'Y' then
954: aso_debug_pub.add('shipment id does not exist in l_shipment_search_tbl, so add it to l_shipment_tbl from database');
955: end if;
956:
957: l_shipment_rec := aso_utility_pvt.query_shipment_row(k.shipment_id);
958: l_shipment_rec.qte_line_index := l_qte_line_tbl.count;
963: end loop;
964:
965: elsif row.ato_line_id is not null then
966:
967: if aso_debug_pub.g_debug_flag = 'Y' then
968: aso_debug_pub.add('do_check_atp: Inside row.ato_line_id is not null condition.');
969: aso_debug_pub.add('do_check_atp: row.ato_line_id: ' || row.ato_line_id);
970: end if;
971:
964:
965: elsif row.ato_line_id is not null then
966:
967: if aso_debug_pub.g_debug_flag = 'Y' then
968: aso_debug_pub.add('do_check_atp: Inside row.ato_line_id is not null condition.');
969: aso_debug_pub.add('do_check_atp: row.ato_line_id: ' || row.ato_line_id);
970: end if;
971:
972: --This line is a Model or component of a ATO configuration under the non smc PTO model
965: elsif row.ato_line_id is not null then
966:
967: if aso_debug_pub.g_debug_flag = 'Y' then
968: aso_debug_pub.add('do_check_atp: Inside row.ato_line_id is not null condition.');
969: aso_debug_pub.add('do_check_atp: row.ato_line_id: ' || row.ato_line_id);
970: end if;
971:
972: --This line is a Model or component of a ATO configuration under the non smc PTO model
973: --OR the root ATO model line
974: --Add complete ATO configuration to input quote line and shipment table
975:
976: if not l_ato_line_id_tbl.exists(row.ato_line_id) then
977:
978: if aso_debug_pub.g_debug_flag = 'Y' then
979: aso_debug_pub.add('do_check_atp: Inside row.ato_line_id does not exist in search tbl.');
980: end if;
981:
982: if row.item_type_code = 'MDL' then
975:
976: if not l_ato_line_id_tbl.exists(row.ato_line_id) then
977:
978: if aso_debug_pub.g_debug_flag = 'Y' then
979: aso_debug_pub.add('do_check_atp: Inside row.ato_line_id does not exist in search tbl.');
980: end if;
981:
982: if row.item_type_code = 'MDL' then
983: l_config_hdr_search_tbl(row.config_header_id) := row.top_model_line_id;
984: end if;
985:
986: for k in c_ato_rows(row.config_header_id, row.config_revision_num, row.ato_line_id) loop
987:
988: if aso_debug_pub.g_debug_flag = 'Y' then
989: aso_debug_pub.add('do_check_atp: k.quote_line_id: ' || k.quote_line_id,1,'Y');
990: aso_debug_pub.add('do_check_atp: k.shipment_id: ' || k.shipment_id,1,'Y');
991: end if;
992:
985:
986: for k in c_ato_rows(row.config_header_id, row.config_revision_num, row.ato_line_id) loop
987:
988: if aso_debug_pub.g_debug_flag = 'Y' then
989: aso_debug_pub.add('do_check_atp: k.quote_line_id: ' || k.quote_line_id,1,'Y');
990: aso_debug_pub.add('do_check_atp: k.shipment_id: ' || k.shipment_id,1,'Y');
991: end if;
992:
993: if not l_qte_line_search_tbl.exists(k.quote_line_id) then
986: for k in c_ato_rows(row.config_header_id, row.config_revision_num, row.ato_line_id) loop
987:
988: if aso_debug_pub.g_debug_flag = 'Y' then
989: aso_debug_pub.add('do_check_atp: k.quote_line_id: ' || k.quote_line_id,1,'Y');
990: aso_debug_pub.add('do_check_atp: k.shipment_id: ' || k.shipment_id,1,'Y');
991: end if;
992:
993: if not l_qte_line_search_tbl.exists(k.quote_line_id) then
994:
991: end if;
992:
993: if not l_qte_line_search_tbl.exists(k.quote_line_id) then
994:
995: if aso_debug_pub.g_debug_flag = 'Y' then
996: aso_debug_pub.add('Quote line id does not exist in l_qte_line_search_tbl, so add it to l_qte_line_tbl from database');
997: end if;
998:
999: l_qte_line_rec := aso_utility_pvt.query_qte_line_row(k.quote_line_id);
992:
993: if not l_qte_line_search_tbl.exists(k.quote_line_id) then
994:
995: if aso_debug_pub.g_debug_flag = 'Y' then
996: aso_debug_pub.add('Quote line id does not exist in l_qte_line_search_tbl, so add it to l_qte_line_tbl from database');
997: end if;
998:
999: l_qte_line_rec := aso_utility_pvt.query_qte_line_row(k.quote_line_id);
1000: l_qte_line_tbl(l_qte_line_tbl.count + 1) := l_qte_line_rec;
1002: end if;
1003:
1004: if not l_shipment_search_tbl.exists(k.shipment_id) then
1005:
1006: if aso_debug_pub.g_debug_flag = 'Y' then
1007: aso_debug_pub.add('shipment id does not exist in l_shipment_search_tbl, so add it to l_shipment_tbl from database');
1008: end if;
1009:
1010: l_shipment_rec := aso_utility_pvt.query_shipment_row(k.shipment_id);
1003:
1004: if not l_shipment_search_tbl.exists(k.shipment_id) then
1005:
1006: if aso_debug_pub.g_debug_flag = 'Y' then
1007: aso_debug_pub.add('shipment id does not exist in l_shipment_search_tbl, so add it to l_shipment_tbl from database');
1008: end if;
1009:
1010: l_shipment_rec := aso_utility_pvt.query_shipment_row(k.shipment_id);
1011: l_shipment_rec.qte_line_index := l_qte_line_tbl.count;
1038: */
1039:
1040: l_use_sourcing_rule := fnd_profile.value(name => 'ASO_ATP_USE_SOURCING_RULE');
1041:
1042: if aso_debug_pub.g_debug_flag = 'Y' then
1043: aso_debug_pub.add('do_check_atp: ASO: Use Sourcing Rule profile value is: '||l_use_sourcing_rule,1,'Y');
1044: end if;
1045:
1046: if l_use_sourcing_rule IS NULL OR l_use_sourcing_rule = 'N' then
1039:
1040: l_use_sourcing_rule := fnd_profile.value(name => 'ASO_ATP_USE_SOURCING_RULE');
1041:
1042: if aso_debug_pub.g_debug_flag = 'Y' then
1043: aso_debug_pub.add('do_check_atp: ASO: Use Sourcing Rule profile value is: '||l_use_sourcing_rule,1,'Y');
1044: end if;
1045:
1046: if l_use_sourcing_rule IS NULL OR l_use_sourcing_rule = 'N' then
1047:
1047:
1048: -- Get the value for Ship from org Id.
1049: l_ship_from_org_id := fnd_profile.value(name => 'ASO_SHIP_FROM_ORG_ID');
1050:
1051: if aso_debug_pub.g_debug_flag = 'Y' then
1052: aso_debug_pub.add('do_check_atp: ASO: Default Ship From Org profile value is: '||l_ship_from_org_id, 1, 'Y');
1053: end if;
1054:
1055: end if;
1048: -- Get the value for Ship from org Id.
1049: l_ship_from_org_id := fnd_profile.value(name => 'ASO_SHIP_FROM_ORG_ID');
1050:
1051: if aso_debug_pub.g_debug_flag = 'Y' then
1052: aso_debug_pub.add('do_check_atp: ASO: Default Ship From Org profile value is: '||l_ship_from_org_id, 1, 'Y');
1053: end if;
1054:
1055: end if;
1056:
1055: end if;
1056:
1057: if l_qte_line_tbl.count > 0 then
1058:
1059: if aso_debug_pub.g_debug_flag = 'Y' then
1060: aso_debug_pub.add('do_check_atp: Before call to aso_line_num_int.reset_line_num procedure', 1, 'Y');
1061: end if;
1062:
1063: aso_line_num_int.reset_line_num;
1056:
1057: if l_qte_line_tbl.count > 0 then
1058:
1059: if aso_debug_pub.g_debug_flag = 'Y' then
1060: aso_debug_pub.add('do_check_atp: Before call to aso_line_num_int.reset_line_num procedure', 1, 'Y');
1061: end if;
1062:
1063: aso_line_num_int.reset_line_num;
1064: l_in_qte_line_number_tbl(1).quote_line_id := l_qte_line_tbl(1).quote_line_id;
1062:
1063: aso_line_num_int.reset_line_num;
1064: l_in_qte_line_number_tbl(1).quote_line_id := l_qte_line_tbl(1).quote_line_id;
1065:
1066: if aso_debug_pub.g_debug_flag = 'Y' then
1067: aso_debug_pub.add('do_check_atp: Before call to aso_line_num_int.aso_ui_line_number procedure', 1, 'Y');
1068: end if;
1069:
1070: aso_line_num_int.aso_ui_line_number( p_in_Line_number_tbl => l_in_qte_line_number_tbl,
1063: aso_line_num_int.reset_line_num;
1064: l_in_qte_line_number_tbl(1).quote_line_id := l_qte_line_tbl(1).quote_line_id;
1065:
1066: if aso_debug_pub.g_debug_flag = 'Y' then
1067: aso_debug_pub.add('do_check_atp: Before call to aso_line_num_int.aso_ui_line_number procedure', 1, 'Y');
1068: end if;
1069:
1070: aso_line_num_int.aso_ui_line_number( p_in_Line_number_tbl => l_in_qte_line_number_tbl,
1071: x_out_line_number_tbl => l_out_qte_line_number_tbl);
1070: aso_line_num_int.aso_ui_line_number( p_in_Line_number_tbl => l_in_qte_line_number_tbl,
1071: x_out_line_number_tbl => l_out_qte_line_number_tbl);
1072:
1073:
1074: if aso_debug_pub.g_debug_flag = 'Y' then
1075: aso_debug_pub.add('do_check_atp: After call to aso_line_num_int.aso_ui_line_number procedure', 1, 'Y');
1076: end if;
1077:
1078: end if;
1071: x_out_line_number_tbl => l_out_qte_line_number_tbl);
1072:
1073:
1074: if aso_debug_pub.g_debug_flag = 'Y' then
1075: aso_debug_pub.add('do_check_atp: After call to aso_line_num_int.aso_ui_line_number procedure', 1, 'Y');
1076: end if;
1077:
1078: end if;
1079:
1105: x_return_status := fnd_api.g_ret_sts_success;
1106: return;
1107: end if;
1108:
1109: if aso_debug_pub.g_debug_flag = 'Y' then
1110: aso_debug_pub.add('do_check_atp: ********************************************************', 1, 'Y');
1111: aso_debug_pub.add('do_check_atp: Printing the data in l_qte_line_tbl and l_shipment_tbl', 1, 'Y');
1112: for i in 1..l_qte_line_tbl.count loop
1113: aso_debug_pub.add('do_check_atp: l_qte_line_tbl('||i||').quote_line_id: '|| l_qte_line_tbl(i).quote_line_id, 1, 'Y');
1106: return;
1107: end if;
1108:
1109: if aso_debug_pub.g_debug_flag = 'Y' then
1110: aso_debug_pub.add('do_check_atp: ********************************************************', 1, 'Y');
1111: aso_debug_pub.add('do_check_atp: Printing the data in l_qte_line_tbl and l_shipment_tbl', 1, 'Y');
1112: for i in 1..l_qte_line_tbl.count loop
1113: aso_debug_pub.add('do_check_atp: l_qte_line_tbl('||i||').quote_line_id: '|| l_qte_line_tbl(i).quote_line_id, 1, 'Y');
1114: end loop;
1107: end if;
1108:
1109: if aso_debug_pub.g_debug_flag = 'Y' then
1110: aso_debug_pub.add('do_check_atp: ********************************************************', 1, 'Y');
1111: aso_debug_pub.add('do_check_atp: Printing the data in l_qte_line_tbl and l_shipment_tbl', 1, 'Y');
1112: for i in 1..l_qte_line_tbl.count loop
1113: aso_debug_pub.add('do_check_atp: l_qte_line_tbl('||i||').quote_line_id: '|| l_qte_line_tbl(i).quote_line_id, 1, 'Y');
1114: end loop;
1115: for i in 1..l_shipment_tbl.count loop
1109: if aso_debug_pub.g_debug_flag = 'Y' then
1110: aso_debug_pub.add('do_check_atp: ********************************************************', 1, 'Y');
1111: aso_debug_pub.add('do_check_atp: Printing the data in l_qte_line_tbl and l_shipment_tbl', 1, 'Y');
1112: for i in 1..l_qte_line_tbl.count loop
1113: aso_debug_pub.add('do_check_atp: l_qte_line_tbl('||i||').quote_line_id: '|| l_qte_line_tbl(i).quote_line_id, 1, 'Y');
1114: end loop;
1115: for i in 1..l_shipment_tbl.count loop
1116: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').ship_method_code: '|| l_shipment_tbl(i).ship_method_code, 1, 'Y');
1117: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').ship_from_org_id: '|| l_shipment_tbl(i).ship_from_org_id, 1, 'Y');
1112: for i in 1..l_qte_line_tbl.count loop
1113: aso_debug_pub.add('do_check_atp: l_qte_line_tbl('||i||').quote_line_id: '|| l_qte_line_tbl(i).quote_line_id, 1, 'Y');
1114: end loop;
1115: for i in 1..l_shipment_tbl.count loop
1116: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').ship_method_code: '|| l_shipment_tbl(i).ship_method_code, 1, 'Y');
1117: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').ship_from_org_id: '|| l_shipment_tbl(i).ship_from_org_id, 1, 'Y');
1118: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').demand_class_code: '|| l_shipment_tbl(i).demand_class_code, 1, 'Y');
1119: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').request_date: '|| l_shipment_tbl(i).request_date, 1, 'Y');
1120: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').quote_line_id: '|| l_shipment_tbl(i).quote_line_id, 1, 'Y');
1113: aso_debug_pub.add('do_check_atp: l_qte_line_tbl('||i||').quote_line_id: '|| l_qte_line_tbl(i).quote_line_id, 1, 'Y');
1114: end loop;
1115: for i in 1..l_shipment_tbl.count loop
1116: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').ship_method_code: '|| l_shipment_tbl(i).ship_method_code, 1, 'Y');
1117: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').ship_from_org_id: '|| l_shipment_tbl(i).ship_from_org_id, 1, 'Y');
1118: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').demand_class_code: '|| l_shipment_tbl(i).demand_class_code, 1, 'Y');
1119: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').request_date: '|| l_shipment_tbl(i).request_date, 1, 'Y');
1120: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').quote_line_id: '|| l_shipment_tbl(i).quote_line_id, 1, 'Y');
1121: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').shipment_id: '|| l_shipment_tbl(i).shipment_id, 1, 'Y');
1114: end loop;
1115: for i in 1..l_shipment_tbl.count loop
1116: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').ship_method_code: '|| l_shipment_tbl(i).ship_method_code, 1, 'Y');
1117: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').ship_from_org_id: '|| l_shipment_tbl(i).ship_from_org_id, 1, 'Y');
1118: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').demand_class_code: '|| l_shipment_tbl(i).demand_class_code, 1, 'Y');
1119: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').request_date: '|| l_shipment_tbl(i).request_date, 1, 'Y');
1120: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').quote_line_id: '|| l_shipment_tbl(i).quote_line_id, 1, 'Y');
1121: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').shipment_id: '|| l_shipment_tbl(i).shipment_id, 1, 'Y');
1122: end loop;
1115: for i in 1..l_shipment_tbl.count loop
1116: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').ship_method_code: '|| l_shipment_tbl(i).ship_method_code, 1, 'Y');
1117: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').ship_from_org_id: '|| l_shipment_tbl(i).ship_from_org_id, 1, 'Y');
1118: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').demand_class_code: '|| l_shipment_tbl(i).demand_class_code, 1, 'Y');
1119: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').request_date: '|| l_shipment_tbl(i).request_date, 1, 'Y');
1120: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').quote_line_id: '|| l_shipment_tbl(i).quote_line_id, 1, 'Y');
1121: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').shipment_id: '|| l_shipment_tbl(i).shipment_id, 1, 'Y');
1122: end loop;
1123: aso_debug_pub.add('do_check_atp: ********************************************************', 1, 'Y');
1116: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').ship_method_code: '|| l_shipment_tbl(i).ship_method_code, 1, 'Y');
1117: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').ship_from_org_id: '|| l_shipment_tbl(i).ship_from_org_id, 1, 'Y');
1118: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').demand_class_code: '|| l_shipment_tbl(i).demand_class_code, 1, 'Y');
1119: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').request_date: '|| l_shipment_tbl(i).request_date, 1, 'Y');
1120: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').quote_line_id: '|| l_shipment_tbl(i).quote_line_id, 1, 'Y');
1121: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').shipment_id: '|| l_shipment_tbl(i).shipment_id, 1, 'Y');
1122: end loop;
1123: aso_debug_pub.add('do_check_atp: ********************************************************', 1, 'Y');
1124: end if;
1117: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').ship_from_org_id: '|| l_shipment_tbl(i).ship_from_org_id, 1, 'Y');
1118: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').demand_class_code: '|| l_shipment_tbl(i).demand_class_code, 1, 'Y');
1119: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').request_date: '|| l_shipment_tbl(i).request_date, 1, 'Y');
1120: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').quote_line_id: '|| l_shipment_tbl(i).quote_line_id, 1, 'Y');
1121: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').shipment_id: '|| l_shipment_tbl(i).shipment_id, 1, 'Y');
1122: end loop;
1123: aso_debug_pub.add('do_check_atp: ********************************************************', 1, 'Y');
1124: end if;
1125:
1119: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').request_date: '|| l_shipment_tbl(i).request_date, 1, 'Y');
1120: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').quote_line_id: '|| l_shipment_tbl(i).quote_line_id, 1, 'Y');
1121: aso_debug_pub.add('do_check_atp: l_shipment_tbl('||i||').shipment_id: '|| l_shipment_tbl(i).shipment_id, 1, 'Y');
1122: end loop;
1123: aso_debug_pub.add('do_check_atp: ********************************************************', 1, 'Y');
1124: end if;
1125:
1126: for i in 1 .. l_qte_line_tbl.count loop
1127:
1124: end if;
1125:
1126: for i in 1 .. l_qte_line_tbl.count loop
1127:
1128: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1129: aso_debug_pub.add('do_check_atp: Before call to MSC_GLOBAL_ATP.EXTEND_ATP', 1, 'Y');
1130: END IF;
1131:
1132: MSC_ATP_GLOBAL.EXTEND_ATP(l_atp_rec, x_return_status, 1);
1125:
1126: for i in 1 .. l_qte_line_tbl.count loop
1127:
1128: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1129: aso_debug_pub.add('do_check_atp: Before call to MSC_GLOBAL_ATP.EXTEND_ATP', 1, 'Y');
1130: END IF;
1131:
1132: MSC_ATP_GLOBAL.EXTEND_ATP(l_atp_rec, x_return_status, 1);
1133:
1130: END IF;
1131:
1132: MSC_ATP_GLOBAL.EXTEND_ATP(l_atp_rec, x_return_status, 1);
1133:
1134: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1135: aso_debug_pub.add('do_check_atp: After call to MSC_GLOBAL_ATP.EXTEND_ATP: x_return_status: '||x_return_status);
1136: END IF;
1137:
1138: If x_return_status <> FND_API.G_RET_STS_SUCCESS Then
1131:
1132: MSC_ATP_GLOBAL.EXTEND_ATP(l_atp_rec, x_return_status, 1);
1133:
1134: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1135: aso_debug_pub.add('do_check_atp: After call to MSC_GLOBAL_ATP.EXTEND_ATP: x_return_status: '||x_return_status);
1136: END IF;
1137:
1138: If x_return_status <> FND_API.G_RET_STS_SUCCESS Then
1139:
1144: END IF;
1145:
1146: End if;
1147:
1148: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1149: aso_debug_pub.add('do_check_atp: l_db_qte_line_rec.quote_line_i: '|| ASO_ATP_INT.ATPQUERY);
1150: aso_debug_pub.add('l_qte_line_tbl('||i||').quote_line_id: '|| l_qte_line_tbl(i).quote_line_id);
1151: END IF;
1152:
1145:
1146: End if;
1147:
1148: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1149: aso_debug_pub.add('do_check_atp: l_db_qte_line_rec.quote_line_i: '|| ASO_ATP_INT.ATPQUERY);
1150: aso_debug_pub.add('l_qte_line_tbl('||i||').quote_line_id: '|| l_qte_line_tbl(i).quote_line_id);
1151: END IF;
1152:
1153: if l_check_atp_for_whole_quote = fnd_api.g_false then
1146: End if;
1147:
1148: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1149: aso_debug_pub.add('do_check_atp: l_db_qte_line_rec.quote_line_i: '|| ASO_ATP_INT.ATPQUERY);
1150: aso_debug_pub.add('l_qte_line_tbl('||i||').quote_line_id: '|| l_qte_line_tbl(i).quote_line_id);
1151: END IF;
1152:
1153: if l_check_atp_for_whole_quote = fnd_api.g_false then
1154: l_db_qte_line_rec := aso_utility_pvt.query_qte_line_row(l_qte_line_tbl(i).quote_line_id);
1155: else
1156: l_db_qte_line_rec := l_qte_line_tbl(i);
1157: end if;
1158:
1159: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1160: aso_debug_pub.add('do_check_atp: ASO_ATP_INT.ATPQUERY: '|| ASO_ATP_INT.ATPQUERY);
1161: aso_debug_pub.add('do_check_atp: fnd_global.prog_appl_id: '|| fnd_global.prog_appl_id);
1162: aso_debug_pub.add('l_db_qte_line_rec.inventory_item_id: '|| l_db_qte_line_rec.inventory_item_id);
1163: aso_debug_pub.add('l_db_qte_line_rec.quantity: '|| l_db_qte_line_rec.quantity);
1156: l_db_qte_line_rec := l_qte_line_tbl(i);
1157: end if;
1158:
1159: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1160: aso_debug_pub.add('do_check_atp: ASO_ATP_INT.ATPQUERY: '|| ASO_ATP_INT.ATPQUERY);
1161: aso_debug_pub.add('do_check_atp: fnd_global.prog_appl_id: '|| fnd_global.prog_appl_id);
1162: aso_debug_pub.add('l_db_qte_line_rec.inventory_item_id: '|| l_db_qte_line_rec.inventory_item_id);
1163: aso_debug_pub.add('l_db_qte_line_rec.quantity: '|| l_db_qte_line_rec.quantity);
1164: aso_debug_pub.add('l_db_qte_line_rec.uom_code: '|| l_db_qte_line_rec.uom_code);
1157: end if;
1158:
1159: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1160: aso_debug_pub.add('do_check_atp: ASO_ATP_INT.ATPQUERY: '|| ASO_ATP_INT.ATPQUERY);
1161: aso_debug_pub.add('do_check_atp: fnd_global.prog_appl_id: '|| fnd_global.prog_appl_id);
1162: aso_debug_pub.add('l_db_qte_line_rec.inventory_item_id: '|| l_db_qte_line_rec.inventory_item_id);
1163: aso_debug_pub.add('l_db_qte_line_rec.quantity: '|| l_db_qte_line_rec.quantity);
1164: aso_debug_pub.add('l_db_qte_line_rec.uom_code: '|| l_db_qte_line_rec.uom_code);
1165: aso_debug_pub.add('l_db_qte_line_rec.organization_id: '|| l_db_qte_line_rec.organization_id);
1158:
1159: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1160: aso_debug_pub.add('do_check_atp: ASO_ATP_INT.ATPQUERY: '|| ASO_ATP_INT.ATPQUERY);
1161: aso_debug_pub.add('do_check_atp: fnd_global.prog_appl_id: '|| fnd_global.prog_appl_id);
1162: aso_debug_pub.add('l_db_qte_line_rec.inventory_item_id: '|| l_db_qte_line_rec.inventory_item_id);
1163: aso_debug_pub.add('l_db_qte_line_rec.quantity: '|| l_db_qte_line_rec.quantity);
1164: aso_debug_pub.add('l_db_qte_line_rec.uom_code: '|| l_db_qte_line_rec.uom_code);
1165: aso_debug_pub.add('l_db_qte_line_rec.organization_id: '|| l_db_qte_line_rec.organization_id);
1166: aso_debug_pub.add('l_db_qte_line_rec.quote_header_id: '|| l_db_qte_line_rec.quote_header_id);
1159: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1160: aso_debug_pub.add('do_check_atp: ASO_ATP_INT.ATPQUERY: '|| ASO_ATP_INT.ATPQUERY);
1161: aso_debug_pub.add('do_check_atp: fnd_global.prog_appl_id: '|| fnd_global.prog_appl_id);
1162: aso_debug_pub.add('l_db_qte_line_rec.inventory_item_id: '|| l_db_qte_line_rec.inventory_item_id);
1163: aso_debug_pub.add('l_db_qte_line_rec.quantity: '|| l_db_qte_line_rec.quantity);
1164: aso_debug_pub.add('l_db_qte_line_rec.uom_code: '|| l_db_qte_line_rec.uom_code);
1165: aso_debug_pub.add('l_db_qte_line_rec.organization_id: '|| l_db_qte_line_rec.organization_id);
1166: aso_debug_pub.add('l_db_qte_line_rec.quote_header_id: '|| l_db_qte_line_rec.quote_header_id);
1167: END IF;
1160: aso_debug_pub.add('do_check_atp: ASO_ATP_INT.ATPQUERY: '|| ASO_ATP_INT.ATPQUERY);
1161: aso_debug_pub.add('do_check_atp: fnd_global.prog_appl_id: '|| fnd_global.prog_appl_id);
1162: aso_debug_pub.add('l_db_qte_line_rec.inventory_item_id: '|| l_db_qte_line_rec.inventory_item_id);
1163: aso_debug_pub.add('l_db_qte_line_rec.quantity: '|| l_db_qte_line_rec.quantity);
1164: aso_debug_pub.add('l_db_qte_line_rec.uom_code: '|| l_db_qte_line_rec.uom_code);
1165: aso_debug_pub.add('l_db_qte_line_rec.organization_id: '|| l_db_qte_line_rec.organization_id);
1166: aso_debug_pub.add('l_db_qte_line_rec.quote_header_id: '|| l_db_qte_line_rec.quote_header_id);
1167: END IF;
1168:
1161: aso_debug_pub.add('do_check_atp: fnd_global.prog_appl_id: '|| fnd_global.prog_appl_id);
1162: aso_debug_pub.add('l_db_qte_line_rec.inventory_item_id: '|| l_db_qte_line_rec.inventory_item_id);
1163: aso_debug_pub.add('l_db_qte_line_rec.quantity: '|| l_db_qte_line_rec.quantity);
1164: aso_debug_pub.add('l_db_qte_line_rec.uom_code: '|| l_db_qte_line_rec.uom_code);
1165: aso_debug_pub.add('l_db_qte_line_rec.organization_id: '|| l_db_qte_line_rec.organization_id);
1166: aso_debug_pub.add('l_db_qte_line_rec.quote_header_id: '|| l_db_qte_line_rec.quote_header_id);
1167: END IF;
1168:
1169: l_atp_rec.action(i) := ASO_ATP_INT.ATPQUERY;
1162: aso_debug_pub.add('l_db_qte_line_rec.inventory_item_id: '|| l_db_qte_line_rec.inventory_item_id);
1163: aso_debug_pub.add('l_db_qte_line_rec.quantity: '|| l_db_qte_line_rec.quantity);
1164: aso_debug_pub.add('l_db_qte_line_rec.uom_code: '|| l_db_qte_line_rec.uom_code);
1165: aso_debug_pub.add('l_db_qte_line_rec.organization_id: '|| l_db_qte_line_rec.organization_id);
1166: aso_debug_pub.add('l_db_qte_line_rec.quote_header_id: '|| l_db_qte_line_rec.quote_header_id);
1167: END IF;
1168:
1169: l_atp_rec.action(i) := ASO_ATP_INT.ATPQUERY;
1170: l_atp_rec.calling_module(i) := fnd_global.prog_appl_id;
1185: open c_quote_number(l_db_qte_line_rec.quote_header_id);
1186: fetch c_quote_number into l_atp_rec.order_number(i), l_atp_rec.customer_id(i);
1187: close c_quote_number;
1188:
1189: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1190: aso_debug_pub.add('l_atp_rec.order_number('||i||'): '|| l_atp_rec.order_number(i));
1191: aso_debug_pub.add('l_atp_rec.customer_id('||i||'): '|| l_atp_rec.customer_id(i));
1192: END IF;
1193:
1186: fetch c_quote_number into l_atp_rec.order_number(i), l_atp_rec.customer_id(i);
1187: close c_quote_number;
1188:
1189: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1190: aso_debug_pub.add('l_atp_rec.order_number('||i||'): '|| l_atp_rec.order_number(i));
1191: aso_debug_pub.add('l_atp_rec.customer_id('||i||'): '|| l_atp_rec.customer_id(i));
1192: END IF;
1193:
1194:
1187: close c_quote_number;
1188:
1189: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1190: aso_debug_pub.add('l_atp_rec.order_number('||i||'): '|| l_atp_rec.order_number(i));
1191: aso_debug_pub.add('l_atp_rec.customer_id('||i||'): '|| l_atp_rec.customer_id(i));
1192: END IF;
1193:
1194:
1195: If l_shipment_tbl.EXISTS(i) Then
1198: l_hdr_shipment_tbl := aso_utility_pvt.query_shipment_rows(p_qte_header_rec.quote_header_id,null);
1199:
1200: if l_hdr_shipment_tbl.count > 0 then
1201: l_hdr_shipment_rec := l_hdr_shipment_tbl(1);
1202: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1203: aso_debug_pub.add('Header Shipment Request_date_type: '|| l_hdr_shipment_rec.request_date_type );
1204: END IF;
1205: end if;
1206:
1199:
1200: if l_hdr_shipment_tbl.count > 0 then
1201: l_hdr_shipment_rec := l_hdr_shipment_tbl(1);
1202: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1203: aso_debug_pub.add('Header Shipment Request_date_type: '|| l_hdr_shipment_rec.request_date_type );
1204: END IF;
1205: end if;
1206:
1207:
1210: else
1211: l_db_shipment_rec := l_shipment_tbl(i);
1212: end if;
1213:
1214: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1215: aso_debug_pub.add('do_check_atp: ****** Database shipment record has following data ******', 1, 'Y');
1216: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.ship_method_code: '|| l_shipment_tbl(i).ship_method_code, 1, 'Y');
1217: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.ship_from_org_id: '|| l_shipment_tbl(i).ship_from_org_id, 1, 'Y');
1218: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.demand_class_code: '|| l_shipment_tbl(i).demand_class_code, 1, 'Y');
1211: l_db_shipment_rec := l_shipment_tbl(i);
1212: end if;
1213:
1214: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1215: aso_debug_pub.add('do_check_atp: ****** Database shipment record has following data ******', 1, 'Y');
1216: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.ship_method_code: '|| l_shipment_tbl(i).ship_method_code, 1, 'Y');
1217: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.ship_from_org_id: '|| l_shipment_tbl(i).ship_from_org_id, 1, 'Y');
1218: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.demand_class_code: '|| l_shipment_tbl(i).demand_class_code, 1, 'Y');
1219: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.request_date: '|| l_shipment_tbl(i).request_date, 1, 'Y');
1212: end if;
1213:
1214: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1215: aso_debug_pub.add('do_check_atp: ****** Database shipment record has following data ******', 1, 'Y');
1216: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.ship_method_code: '|| l_shipment_tbl(i).ship_method_code, 1, 'Y');
1217: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.ship_from_org_id: '|| l_shipment_tbl(i).ship_from_org_id, 1, 'Y');
1218: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.demand_class_code: '|| l_shipment_tbl(i).demand_class_code, 1, 'Y');
1219: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.request_date: '|| l_shipment_tbl(i).request_date, 1, 'Y');
1220: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.request_date_type: '|| l_shipment_tbl(i).request_date_type, 1, 'Y');
1213:
1214: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1215: aso_debug_pub.add('do_check_atp: ****** Database shipment record has following data ******', 1, 'Y');
1216: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.ship_method_code: '|| l_shipment_tbl(i).ship_method_code, 1, 'Y');
1217: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.ship_from_org_id: '|| l_shipment_tbl(i).ship_from_org_id, 1, 'Y');
1218: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.demand_class_code: '|| l_shipment_tbl(i).demand_class_code, 1, 'Y');
1219: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.request_date: '|| l_shipment_tbl(i).request_date, 1, 'Y');
1220: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.request_date_type: '|| l_shipment_tbl(i).request_date_type, 1, 'Y');
1221: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.quote_line_id: '|| l_shipment_tbl(i).quote_line_id, 1, 'Y');
1214: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1215: aso_debug_pub.add('do_check_atp: ****** Database shipment record has following data ******', 1, 'Y');
1216: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.ship_method_code: '|| l_shipment_tbl(i).ship_method_code, 1, 'Y');
1217: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.ship_from_org_id: '|| l_shipment_tbl(i).ship_from_org_id, 1, 'Y');
1218: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.demand_class_code: '|| l_shipment_tbl(i).demand_class_code, 1, 'Y');
1219: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.request_date: '|| l_shipment_tbl(i).request_date, 1, 'Y');
1220: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.request_date_type: '|| l_shipment_tbl(i).request_date_type, 1, 'Y');
1221: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.quote_line_id: '|| l_shipment_tbl(i).quote_line_id, 1, 'Y');
1222: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.shipment_id: '|| l_shipment_tbl(i).shipment_id, 1, 'Y');
1215: aso_debug_pub.add('do_check_atp: ****** Database shipment record has following data ******', 1, 'Y');
1216: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.ship_method_code: '|| l_shipment_tbl(i).ship_method_code, 1, 'Y');
1217: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.ship_from_org_id: '|| l_shipment_tbl(i).ship_from_org_id, 1, 'Y');
1218: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.demand_class_code: '|| l_shipment_tbl(i).demand_class_code, 1, 'Y');
1219: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.request_date: '|| l_shipment_tbl(i).request_date, 1, 'Y');
1220: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.request_date_type: '|| l_shipment_tbl(i).request_date_type, 1, 'Y');
1221: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.quote_line_id: '|| l_shipment_tbl(i).quote_line_id, 1, 'Y');
1222: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.shipment_id: '|| l_shipment_tbl(i).shipment_id, 1, 'Y');
1223: aso_debug_pub.add('do_check_atp: ****** End of Database shipment record data ******', 1, 'Y');
1216: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.ship_method_code: '|| l_shipment_tbl(i).ship_method_code, 1, 'Y');
1217: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.ship_from_org_id: '|| l_shipment_tbl(i).ship_from_org_id, 1, 'Y');
1218: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.demand_class_code: '|| l_shipment_tbl(i).demand_class_code, 1, 'Y');
1219: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.request_date: '|| l_shipment_tbl(i).request_date, 1, 'Y');
1220: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.request_date_type: '|| l_shipment_tbl(i).request_date_type, 1, 'Y');
1221: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.quote_line_id: '|| l_shipment_tbl(i).quote_line_id, 1, 'Y');
1222: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.shipment_id: '|| l_shipment_tbl(i).shipment_id, 1, 'Y');
1223: aso_debug_pub.add('do_check_atp: ****** End of Database shipment record data ******', 1, 'Y');
1224: END IF;
1217: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.ship_from_org_id: '|| l_shipment_tbl(i).ship_from_org_id, 1, 'Y');
1218: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.demand_class_code: '|| l_shipment_tbl(i).demand_class_code, 1, 'Y');
1219: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.request_date: '|| l_shipment_tbl(i).request_date, 1, 'Y');
1220: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.request_date_type: '|| l_shipment_tbl(i).request_date_type, 1, 'Y');
1221: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.quote_line_id: '|| l_shipment_tbl(i).quote_line_id, 1, 'Y');
1222: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.shipment_id: '|| l_shipment_tbl(i).shipment_id, 1, 'Y');
1223: aso_debug_pub.add('do_check_atp: ****** End of Database shipment record data ******', 1, 'Y');
1224: END IF;
1225: -- fix for bug 4724470, over-riding the line req date type with the hdr record req date type
1218: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.demand_class_code: '|| l_shipment_tbl(i).demand_class_code, 1, 'Y');
1219: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.request_date: '|| l_shipment_tbl(i).request_date, 1, 'Y');
1220: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.request_date_type: '|| l_shipment_tbl(i).request_date_type, 1, 'Y');
1221: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.quote_line_id: '|| l_shipment_tbl(i).quote_line_id, 1, 'Y');
1222: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.shipment_id: '|| l_shipment_tbl(i).shipment_id, 1, 'Y');
1223: aso_debug_pub.add('do_check_atp: ****** End of Database shipment record data ******', 1, 'Y');
1224: END IF;
1225: -- fix for bug 4724470, over-riding the line req date type with the hdr record req date type
1226: -- this is becoz req date type at line level is not supported and hence over-written
1219: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.request_date: '|| l_shipment_tbl(i).request_date, 1, 'Y');
1220: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.request_date_type: '|| l_shipment_tbl(i).request_date_type, 1, 'Y');
1221: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.quote_line_id: '|| l_shipment_tbl(i).quote_line_id, 1, 'Y');
1222: aso_debug_pub.add('do_check_atp: l_db_shipment_rec.shipment_id: '|| l_shipment_tbl(i).shipment_id, 1, 'Y');
1223: aso_debug_pub.add('do_check_atp: ****** End of Database shipment record data ******', 1, 'Y');
1224: END IF;
1225: -- fix for bug 4724470, over-riding the line req date type with the hdr record req date type
1226: -- this is becoz req date type at line level is not supported and hence over-written
1227: -- with the hdr value
1311: end if;
1312: end if;
1313:
1314:
1315: if aso_debug_pub.g_debug_flag = 'Y' then
1316: aso_debug_pub.add('l_atp_rec.source_organization_id('||i||'): '|| l_atp_rec.source_organization_id(i));
1317: aso_debug_pub.add('l_db_shipment_rec.request_date_type: '|| l_db_shipment_rec.request_date_type);
1318: aso_debug_pub.add('l_shipment_tbl('||i||').request_date: '|| l_shipment_tbl(i).request_date);
1319: end if;
1312: end if;
1313:
1314:
1315: if aso_debug_pub.g_debug_flag = 'Y' then
1316: aso_debug_pub.add('l_atp_rec.source_organization_id('||i||'): '|| l_atp_rec.source_organization_id(i));
1317: aso_debug_pub.add('l_db_shipment_rec.request_date_type: '|| l_db_shipment_rec.request_date_type);
1318: aso_debug_pub.add('l_shipment_tbl('||i||').request_date: '|| l_shipment_tbl(i).request_date);
1319: end if;
1320:
1313:
1314:
1315: if aso_debug_pub.g_debug_flag = 'Y' then
1316: aso_debug_pub.add('l_atp_rec.source_organization_id('||i||'): '|| l_atp_rec.source_organization_id(i));
1317: aso_debug_pub.add('l_db_shipment_rec.request_date_type: '|| l_db_shipment_rec.request_date_type);
1318: aso_debug_pub.add('l_shipment_tbl('||i||').request_date: '|| l_shipment_tbl(i).request_date);
1319: end if;
1320:
1321: if (l_db_shipment_rec.request_date_type is null or l_db_shipment_rec.request_date_type = 'SHIP'
1314:
1315: if aso_debug_pub.g_debug_flag = 'Y' then
1316: aso_debug_pub.add('l_atp_rec.source_organization_id('||i||'): '|| l_atp_rec.source_organization_id(i));
1317: aso_debug_pub.add('l_db_shipment_rec.request_date_type: '|| l_db_shipment_rec.request_date_type);
1318: aso_debug_pub.add('l_shipment_tbl('||i||').request_date: '|| l_shipment_tbl(i).request_date);
1319: end if;
1320:
1321: if (l_db_shipment_rec.request_date_type is null or l_db_shipment_rec.request_date_type = 'SHIP'
1322: or l_db_shipment_rec.request_date_type = fnd_api.g_miss_char) then
1326: else
1327: open c_get_ids( l_qte_line_tbl(i).quote_line_id );
1328: fetch c_get_ids into l_ato_line_id,l_top_model_line_id;
1329: close c_get_ids;
1330: if aso_debug_pub.g_debug_flag = 'Y' then
1331: aso_debug_pub.add('l_ato_line_id: '|| l_ato_line_id);
1332: aso_debug_pub.add('l_top_model_line_id: '|| l_top_model_line_id);
1333: end if;
1334: -- if the line is an option under ATO
1327: open c_get_ids( l_qte_line_tbl(i).quote_line_id );
1328: fetch c_get_ids into l_ato_line_id,l_top_model_line_id;
1329: close c_get_ids;
1330: if aso_debug_pub.g_debug_flag = 'Y' then
1331: aso_debug_pub.add('l_ato_line_id: '|| l_ato_line_id);
1332: aso_debug_pub.add('l_top_model_line_id: '|| l_top_model_line_id);
1333: end if;
1334: -- if the line is an option under ATO
1335: if (l_ato_line_id is not null and l_top_model_line_id is not null )then
1328: fetch c_get_ids into l_ato_line_id,l_top_model_line_id;
1329: close c_get_ids;
1330: if aso_debug_pub.g_debug_flag = 'Y' then
1331: aso_debug_pub.add('l_ato_line_id: '|| l_ato_line_id);
1332: aso_debug_pub.add('l_top_model_line_id: '|| l_top_model_line_id);
1333: end if;
1334: -- if the line is an option under ATO
1335: if (l_ato_line_id is not null and l_top_model_line_id is not null )then
1336: -- check if record has been passed in , then honor that
1339: close c_shipment_id;
1340: if (l_shipment_search_tbl.exists(l_shipment_id) and
1341: ((p_shipment_tbl( l_shipment_search_tbl(l_shipment_id)).request_date is not null) and
1342: (p_shipment_tbl( l_shipment_search_tbl(l_shipment_id)).request_date<> fnd_api.g_miss_date))) then
1343: if aso_debug_pub.g_debug_flag = 'Y' then
1344: aso_debug_pub.add('getting the request date from input ');
1345: end if;
1346: l_atp_rec.requested_ship_date(i) := p_shipment_tbl( l_shipment_search_tbl(l_shipment_id)).request_date;
1347: else
1340: if (l_shipment_search_tbl.exists(l_shipment_id) and
1341: ((p_shipment_tbl( l_shipment_search_tbl(l_shipment_id)).request_date is not null) and
1342: (p_shipment_tbl( l_shipment_search_tbl(l_shipment_id)).request_date<> fnd_api.g_miss_date))) then
1343: if aso_debug_pub.g_debug_flag = 'Y' then
1344: aso_debug_pub.add('getting the request date from input ');
1345: end if;
1346: l_atp_rec.requested_ship_date(i) := p_shipment_tbl( l_shipment_search_tbl(l_shipment_id)).request_date;
1347: else
1348: -- try to cascade database info from ATO Model
1348: -- try to cascade database info from ATO Model
1349: open c_get_request_date(l_ato_line_id, l_qte_line_tbl(i).quote_header_id,'SHIP');
1350: fetch c_get_request_date into l_cascade_request_date;
1351: close c_get_request_date;
1352: if aso_debug_pub.g_debug_flag = 'Y' then
1353: aso_debug_pub.add('l_cascade_request_date: '|| l_cascade_request_date );
1354: end if;
1355: if l_cascade_request_date is not null and l_cascade_request_date <> fnd_api.g_miss_date then
1356: l_atp_rec.requested_ship_date(i) := l_cascade_request_date;
1349: open c_get_request_date(l_ato_line_id, l_qte_line_tbl(i).quote_header_id,'SHIP');
1350: fetch c_get_request_date into l_cascade_request_date;
1351: close c_get_request_date;
1352: if aso_debug_pub.g_debug_flag = 'Y' then
1353: aso_debug_pub.add('l_cascade_request_date: '|| l_cascade_request_date );
1354: end if;
1355: if l_cascade_request_date is not null and l_cascade_request_date <> fnd_api.g_miss_date then
1356: l_atp_rec.requested_ship_date(i) := l_cascade_request_date;
1357: else
1405: -- fix for bug 4724374 if db value is null get the value from the hdr record
1406: if ( l_hdr_shipment_rec.request_date is not null and l_hdr_shipment_rec.request_date <> fnd_api.g_miss_date ) then
1407: l_atp_rec.requested_ship_date(i) := l_hdr_shipment_rec.request_date;
1408: else
1409: if aso_debug_pub.g_debug_flag = 'Y' then
1410: aso_debug_pub.add('Setting the request date to sysdate' );
1411: end if;
1412: l_atp_rec.requested_ship_date(i) := sysdate;
1413: end if; -- end if for the hdr rec check
1406: if ( l_hdr_shipment_rec.request_date is not null and l_hdr_shipment_rec.request_date <> fnd_api.g_miss_date ) then
1407: l_atp_rec.requested_ship_date(i) := l_hdr_shipment_rec.request_date;
1408: else
1409: if aso_debug_pub.g_debug_flag = 'Y' then
1410: aso_debug_pub.add('Setting the request date to sysdate' );
1411: end if;
1412: l_atp_rec.requested_ship_date(i) := sysdate;
1413: end if; -- end if for the hdr rec check
1414: end if;
1496:
1497:
1498: end if;
1499:
1500: if aso_debug_pub.g_debug_flag = 'Y' then
1501: aso_debug_pub.add('l_shipment_tbl('||i||').ship_method_code: '|| l_shipment_tbl(i).ship_method_code);
1502: end if;
1503:
1504: if (l_shipment_tbl(i).ship_method_code <> fnd_api.g_miss_char and l_shipment_tbl(i).ship_method_code is not null) then
1497:
1498: end if;
1499:
1500: if aso_debug_pub.g_debug_flag = 'Y' then
1501: aso_debug_pub.add('l_shipment_tbl('||i||').ship_method_code: '|| l_shipment_tbl(i).ship_method_code);
1502: end if;
1503:
1504: if (l_shipment_tbl(i).ship_method_code <> fnd_api.g_miss_char and l_shipment_tbl(i).ship_method_code is not null) then
1505: l_atp_rec.ship_method(i) := l_shipment_tbl(i).ship_method_code;
1576: p_qte_line_id => l_shipment_tbl(i).quote_line_id);
1577: end if;
1578: end if;
1579:
1580: if aso_debug_pub.g_debug_flag = 'Y' then
1581: aso_debug_pub.add('l_shipment_tbl('||i||').demand_class_code: '|| l_shipment_tbl(i).demand_class_code);
1582: end if;
1583:
1584:
1577: end if;
1578: end if;
1579:
1580: if aso_debug_pub.g_debug_flag = 'Y' then
1581: aso_debug_pub.add('l_shipment_tbl('||i||').demand_class_code: '|| l_shipment_tbl(i).demand_class_code);
1582: end if;
1583:
1584:
1585:
1659: end if;
1660: end if;
1661:
1662:
1663: if aso_debug_pub.g_debug_flag = 'Y' then
1664: aso_debug_pub.add('l_db_shipment_rec.ship_to_party_site_id: '|| l_db_shipment_rec.ship_to_party_site_id);
1665: aso_debug_pub.add('l_db_shipment_rec.ship_to_cust_account_id: '|| l_db_shipment_rec.ship_to_cust_account_id);
1666: end if;
1667:
1660: end if;
1661:
1662:
1663: if aso_debug_pub.g_debug_flag = 'Y' then
1664: aso_debug_pub.add('l_db_shipment_rec.ship_to_party_site_id: '|| l_db_shipment_rec.ship_to_party_site_id);
1665: aso_debug_pub.add('l_db_shipment_rec.ship_to_cust_account_id: '|| l_db_shipment_rec.ship_to_cust_account_id);
1666: end if;
1667:
1668:
1661:
1662:
1663: if aso_debug_pub.g_debug_flag = 'Y' then
1664: aso_debug_pub.add('l_db_shipment_rec.ship_to_party_site_id: '|| l_db_shipment_rec.ship_to_party_site_id);
1665: aso_debug_pub.add('l_db_shipment_rec.ship_to_cust_account_id: '|| l_db_shipment_rec.ship_to_cust_account_id);
1666: end if;
1667:
1668:
1669: if l_db_shipment_rec.ship_to_party_site_id is not null then
1690: p_cust_account_id => l_ship_to_cust_account_id,
1691: x_return_status => x_return_status,
1692: x_site_use_id => lx_cust_acct_site_use_id );
1693:
1694: if aso_debug_pub.g_debug_flag = 'Y' then
1695: aso_debug_pub.add('After call to ASO_MAP_QUOTE_ORDER_INT.get_acct_site_uses: x_return_status '|| x_return_status);
1696: aso_debug_pub.add('lx_cust_acct_site_use_id: '|| lx_cust_acct_site_use_id);
1697: end if;
1698:
1691: x_return_status => x_return_status,
1692: x_site_use_id => lx_cust_acct_site_use_id );
1693:
1694: if aso_debug_pub.g_debug_flag = 'Y' then
1695: aso_debug_pub.add('After call to ASO_MAP_QUOTE_ORDER_INT.get_acct_site_uses: x_return_status '|| x_return_status);
1696: aso_debug_pub.add('lx_cust_acct_site_use_id: '|| lx_cust_acct_site_use_id);
1697: end if;
1698:
1699: l_atp_rec.customer_site_id(i) := lx_cust_acct_site_use_id;
1692: x_site_use_id => lx_cust_acct_site_use_id );
1693:
1694: if aso_debug_pub.g_debug_flag = 'Y' then
1695: aso_debug_pub.add('After call to ASO_MAP_QUOTE_ORDER_INT.get_acct_site_uses: x_return_status '|| x_return_status);
1696: aso_debug_pub.add('lx_cust_acct_site_use_id: '|| lx_cust_acct_site_use_id);
1697: end if;
1698:
1699: l_atp_rec.customer_site_id(i) := lx_cust_acct_site_use_id;
1700:
1715:
1716: End If; --if shipment record exists
1717:
1718:
1719: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1720: aso_debug_pub.add('After End if for shipment record exists');
1721: END IF;
1722:
1723: for j in c_config_dtl(l_qte_line_tbl(i).quote_line_id) loop
1716: End If; --if shipment record exists
1717:
1718:
1719: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1720: aso_debug_pub.add('After End if for shipment record exists');
1721: END IF;
1722:
1723: for j in c_config_dtl(l_qte_line_tbl(i).quote_line_id) loop
1724:
1721: END IF;
1722:
1723: for j in c_config_dtl(l_qte_line_tbl(i).quote_line_id) loop
1724:
1725: if aso_debug_pub.g_debug_flag = 'Y' then
1726: aso_debug_pub.add('do_check_atp: l_qte_line_tbl('||i||').quote_line_id: '||l_qte_line_tbl(i).quote_line_id);
1727: aso_debug_pub.add('do_check_atp: quote_line_id: '||j.quote_line_id);
1728: aso_debug_pub.add('do_check_atp: item_type_code: '||j.item_type_code);
1729: aso_debug_pub.add('do_check_atp: config_header_id: '||j.config_header_id);
1722:
1723: for j in c_config_dtl(l_qte_line_tbl(i).quote_line_id) loop
1724:
1725: if aso_debug_pub.g_debug_flag = 'Y' then
1726: aso_debug_pub.add('do_check_atp: l_qte_line_tbl('||i||').quote_line_id: '||l_qte_line_tbl(i).quote_line_id);
1727: aso_debug_pub.add('do_check_atp: quote_line_id: '||j.quote_line_id);
1728: aso_debug_pub.add('do_check_atp: item_type_code: '||j.item_type_code);
1729: aso_debug_pub.add('do_check_atp: config_header_id: '||j.config_header_id);
1730: aso_debug_pub.add('do_check_atp: config_revision_num: '||j.config_revision_num);
1723: for j in c_config_dtl(l_qte_line_tbl(i).quote_line_id) loop
1724:
1725: if aso_debug_pub.g_debug_flag = 'Y' then
1726: aso_debug_pub.add('do_check_atp: l_qte_line_tbl('||i||').quote_line_id: '||l_qte_line_tbl(i).quote_line_id);
1727: aso_debug_pub.add('do_check_atp: quote_line_id: '||j.quote_line_id);
1728: aso_debug_pub.add('do_check_atp: item_type_code: '||j.item_type_code);
1729: aso_debug_pub.add('do_check_atp: config_header_id: '||j.config_header_id);
1730: aso_debug_pub.add('do_check_atp: config_revision_num: '||j.config_revision_num);
1731: aso_debug_pub.add('do_check_atp: component_code: '||j.component_code);
1724:
1725: if aso_debug_pub.g_debug_flag = 'Y' then
1726: aso_debug_pub.add('do_check_atp: l_qte_line_tbl('||i||').quote_line_id: '||l_qte_line_tbl(i).quote_line_id);
1727: aso_debug_pub.add('do_check_atp: quote_line_id: '||j.quote_line_id);
1728: aso_debug_pub.add('do_check_atp: item_type_code: '||j.item_type_code);
1729: aso_debug_pub.add('do_check_atp: config_header_id: '||j.config_header_id);
1730: aso_debug_pub.add('do_check_atp: config_revision_num: '||j.config_revision_num);
1731: aso_debug_pub.add('do_check_atp: component_code: '||j.component_code);
1732: aso_debug_pub.add('do_check_atp: config_item_id: '||j.config_item_id);
1725: if aso_debug_pub.g_debug_flag = 'Y' then
1726: aso_debug_pub.add('do_check_atp: l_qte_line_tbl('||i||').quote_line_id: '||l_qte_line_tbl(i).quote_line_id);
1727: aso_debug_pub.add('do_check_atp: quote_line_id: '||j.quote_line_id);
1728: aso_debug_pub.add('do_check_atp: item_type_code: '||j.item_type_code);
1729: aso_debug_pub.add('do_check_atp: config_header_id: '||j.config_header_id);
1730: aso_debug_pub.add('do_check_atp: config_revision_num: '||j.config_revision_num);
1731: aso_debug_pub.add('do_check_atp: component_code: '||j.component_code);
1732: aso_debug_pub.add('do_check_atp: config_item_id: '||j.config_item_id);
1733: aso_debug_pub.add('do_check_atp: ref_line_id: '||j.ref_line_id);
1726: aso_debug_pub.add('do_check_atp: l_qte_line_tbl('||i||').quote_line_id: '||l_qte_line_tbl(i).quote_line_id);
1727: aso_debug_pub.add('do_check_atp: quote_line_id: '||j.quote_line_id);
1728: aso_debug_pub.add('do_check_atp: item_type_code: '||j.item_type_code);
1729: aso_debug_pub.add('do_check_atp: config_header_id: '||j.config_header_id);
1730: aso_debug_pub.add('do_check_atp: config_revision_num: '||j.config_revision_num);
1731: aso_debug_pub.add('do_check_atp: component_code: '||j.component_code);
1732: aso_debug_pub.add('do_check_atp: config_item_id: '||j.config_item_id);
1733: aso_debug_pub.add('do_check_atp: ref_line_id: '||j.ref_line_id);
1734: aso_debug_pub.add('do_check_atp: ato_line_id: '||j.ato_line_id);
1727: aso_debug_pub.add('do_check_atp: quote_line_id: '||j.quote_line_id);
1728: aso_debug_pub.add('do_check_atp: item_type_code: '||j.item_type_code);
1729: aso_debug_pub.add('do_check_atp: config_header_id: '||j.config_header_id);
1730: aso_debug_pub.add('do_check_atp: config_revision_num: '||j.config_revision_num);
1731: aso_debug_pub.add('do_check_atp: component_code: '||j.component_code);
1732: aso_debug_pub.add('do_check_atp: config_item_id: '||j.config_item_id);
1733: aso_debug_pub.add('do_check_atp: ref_line_id: '||j.ref_line_id);
1734: aso_debug_pub.add('do_check_atp: ato_line_id: '||j.ato_line_id);
1735: aso_debug_pub.add('do_check_atp: top_model_line_id: '||j.top_model_line_id);
1728: aso_debug_pub.add('do_check_atp: item_type_code: '||j.item_type_code);
1729: aso_debug_pub.add('do_check_atp: config_header_id: '||j.config_header_id);
1730: aso_debug_pub.add('do_check_atp: config_revision_num: '||j.config_revision_num);
1731: aso_debug_pub.add('do_check_atp: component_code: '||j.component_code);
1732: aso_debug_pub.add('do_check_atp: config_item_id: '||j.config_item_id);
1733: aso_debug_pub.add('do_check_atp: ref_line_id: '||j.ref_line_id);
1734: aso_debug_pub.add('do_check_atp: ato_line_id: '||j.ato_line_id);
1735: aso_debug_pub.add('do_check_atp: top_model_line_id: '||j.top_model_line_id);
1736: aso_debug_pub.add('do_check_atp: component_sequence_id: '||j.component_sequence_id);
1729: aso_debug_pub.add('do_check_atp: config_header_id: '||j.config_header_id);
1730: aso_debug_pub.add('do_check_atp: config_revision_num: '||j.config_revision_num);
1731: aso_debug_pub.add('do_check_atp: component_code: '||j.component_code);
1732: aso_debug_pub.add('do_check_atp: config_item_id: '||j.config_item_id);
1733: aso_debug_pub.add('do_check_atp: ref_line_id: '||j.ref_line_id);
1734: aso_debug_pub.add('do_check_atp: ato_line_id: '||j.ato_line_id);
1735: aso_debug_pub.add('do_check_atp: top_model_line_id: '||j.top_model_line_id);
1736: aso_debug_pub.add('do_check_atp: component_sequence_id: '||j.component_sequence_id);
1737: aso_debug_pub.add('do_check_atp: ship_model_complete_flag: '||j.ship_model_complete_flag);
1730: aso_debug_pub.add('do_check_atp: config_revision_num: '||j.config_revision_num);
1731: aso_debug_pub.add('do_check_atp: component_code: '||j.component_code);
1732: aso_debug_pub.add('do_check_atp: config_item_id: '||j.config_item_id);
1733: aso_debug_pub.add('do_check_atp: ref_line_id: '||j.ref_line_id);
1734: aso_debug_pub.add('do_check_atp: ato_line_id: '||j.ato_line_id);
1735: aso_debug_pub.add('do_check_atp: top_model_line_id: '||j.top_model_line_id);
1736: aso_debug_pub.add('do_check_atp: component_sequence_id: '||j.component_sequence_id);
1737: aso_debug_pub.add('do_check_atp: ship_model_complete_flag: '||j.ship_model_complete_flag);
1738: end if;
1731: aso_debug_pub.add('do_check_atp: component_code: '||j.component_code);
1732: aso_debug_pub.add('do_check_atp: config_item_id: '||j.config_item_id);
1733: aso_debug_pub.add('do_check_atp: ref_line_id: '||j.ref_line_id);
1734: aso_debug_pub.add('do_check_atp: ato_line_id: '||j.ato_line_id);
1735: aso_debug_pub.add('do_check_atp: top_model_line_id: '||j.top_model_line_id);
1736: aso_debug_pub.add('do_check_atp: component_sequence_id: '||j.component_sequence_id);
1737: aso_debug_pub.add('do_check_atp: ship_model_complete_flag: '||j.ship_model_complete_flag);
1738: end if;
1739:
1732: aso_debug_pub.add('do_check_atp: config_item_id: '||j.config_item_id);
1733: aso_debug_pub.add('do_check_atp: ref_line_id: '||j.ref_line_id);
1734: aso_debug_pub.add('do_check_atp: ato_line_id: '||j.ato_line_id);
1735: aso_debug_pub.add('do_check_atp: top_model_line_id: '||j.top_model_line_id);
1736: aso_debug_pub.add('do_check_atp: component_sequence_id: '||j.component_sequence_id);
1737: aso_debug_pub.add('do_check_atp: ship_model_complete_flag: '||j.ship_model_complete_flag);
1738: end if;
1739:
1740: if j.config_header_id is not null then
1733: aso_debug_pub.add('do_check_atp: ref_line_id: '||j.ref_line_id);
1734: aso_debug_pub.add('do_check_atp: ato_line_id: '||j.ato_line_id);
1735: aso_debug_pub.add('do_check_atp: top_model_line_id: '||j.top_model_line_id);
1736: aso_debug_pub.add('do_check_atp: component_sequence_id: '||j.component_sequence_id);
1737: aso_debug_pub.add('do_check_atp: ship_model_complete_flag: '||j.ship_model_complete_flag);
1738: end if;
1739:
1740: if j.config_header_id is not null then
1741:
1738: end if;
1739:
1740: if j.config_header_id is not null then
1741:
1742: if aso_debug_pub.g_debug_flag = 'Y' then
1743: aso_debug_pub.add('j.config_header_id is not null. This is a configuration line.');
1744: end if;
1745:
1746: if nvl(j.ship_model_complete_flag, 'N') = 'Y' then
1739:
1740: if j.config_header_id is not null then
1741:
1742: if aso_debug_pub.g_debug_flag = 'Y' then
1743: aso_debug_pub.add('j.config_header_id is not null. This is a configuration line.');
1744: end if;
1745:
1746: if nvl(j.ship_model_complete_flag, 'N') = 'Y' then
1747: l_atp_rec.ship_set_name(i) := j.top_model_line_id;
1761:
1762:
1763: --Print the input parameters to MRP call_atp procedure
1764:
1765: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1766:
1767: aso_debug_pub.add('After the qte line tbl loop ');
1768:
1769: if l_atp_rec.identifier IS NOT NULL then
1763: --Print the input parameters to MRP call_atp procedure
1764:
1765: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1766:
1767: aso_debug_pub.add('After the qte line tbl loop ');
1768:
1769: if l_atp_rec.identifier IS NOT NULL then
1770:
1771: for i in l_atp_rec.identifier.FIRST .. l_atp_rec.identifier.LAST loop
1771: for i in l_atp_rec.identifier.FIRST .. l_atp_rec.identifier.LAST loop
1772:
1773: if l_atp_rec.identifier.EXISTS(i) then
1774:
1775: aso_debug_pub.add('do_check_atp: l_atp_rec.identifier('||i||'): '|| l_atp_rec.identifier(i));
1776: aso_debug_pub.add('do_check_atp: l_atp_rec.parent_line_id('||i||'): '|| l_atp_rec.parent_line_id(i));
1777: aso_debug_pub.add('do_check_atp: l_atp_rec.top_model_line_id('||i||'): '|| l_atp_rec.top_model_line_id(i));
1778: aso_debug_pub.add('do_check_atp: l_atp_rec.ato_model_line_id('||i||'): '|| l_atp_rec.ato_model_line_id(i));
1779: aso_debug_pub.add('do_check_atp: l_atp_rec.component_code('||i||'): '|| l_atp_rec.component_code(i));
1772:
1773: if l_atp_rec.identifier.EXISTS(i) then
1774:
1775: aso_debug_pub.add('do_check_atp: l_atp_rec.identifier('||i||'): '|| l_atp_rec.identifier(i));
1776: aso_debug_pub.add('do_check_atp: l_atp_rec.parent_line_id('||i||'): '|| l_atp_rec.parent_line_id(i));
1777: aso_debug_pub.add('do_check_atp: l_atp_rec.top_model_line_id('||i||'): '|| l_atp_rec.top_model_line_id(i));
1778: aso_debug_pub.add('do_check_atp: l_atp_rec.ato_model_line_id('||i||'): '|| l_atp_rec.ato_model_line_id(i));
1779: aso_debug_pub.add('do_check_atp: l_atp_rec.component_code('||i||'): '|| l_atp_rec.component_code(i));
1780: aso_debug_pub.add('do_check_atp: l_atp_rec.component_sequence_id('||i||'): '|| l_atp_rec.component_sequence_id(i));
1773: if l_atp_rec.identifier.EXISTS(i) then
1774:
1775: aso_debug_pub.add('do_check_atp: l_atp_rec.identifier('||i||'): '|| l_atp_rec.identifier(i));
1776: aso_debug_pub.add('do_check_atp: l_atp_rec.parent_line_id('||i||'): '|| l_atp_rec.parent_line_id(i));
1777: aso_debug_pub.add('do_check_atp: l_atp_rec.top_model_line_id('||i||'): '|| l_atp_rec.top_model_line_id(i));
1778: aso_debug_pub.add('do_check_atp: l_atp_rec.ato_model_line_id('||i||'): '|| l_atp_rec.ato_model_line_id(i));
1779: aso_debug_pub.add('do_check_atp: l_atp_rec.component_code('||i||'): '|| l_atp_rec.component_code(i));
1780: aso_debug_pub.add('do_check_atp: l_atp_rec.component_sequence_id('||i||'): '|| l_atp_rec.component_sequence_id(i));
1781: aso_debug_pub.add('do_check_atp: l_atp_rec.ship_set_name('||i||'): '|| l_atp_rec.ship_set_name(i));
1774:
1775: aso_debug_pub.add('do_check_atp: l_atp_rec.identifier('||i||'): '|| l_atp_rec.identifier(i));
1776: aso_debug_pub.add('do_check_atp: l_atp_rec.parent_line_id('||i||'): '|| l_atp_rec.parent_line_id(i));
1777: aso_debug_pub.add('do_check_atp: l_atp_rec.top_model_line_id('||i||'): '|| l_atp_rec.top_model_line_id(i));
1778: aso_debug_pub.add('do_check_atp: l_atp_rec.ato_model_line_id('||i||'): '|| l_atp_rec.ato_model_line_id(i));
1779: aso_debug_pub.add('do_check_atp: l_atp_rec.component_code('||i||'): '|| l_atp_rec.component_code(i));
1780: aso_debug_pub.add('do_check_atp: l_atp_rec.component_sequence_id('||i||'): '|| l_atp_rec.component_sequence_id(i));
1781: aso_debug_pub.add('do_check_atp: l_atp_rec.ship_set_name('||i||'): '|| l_atp_rec.ship_set_name(i));
1782: aso_debug_pub.add('do_check_atp: l_atp_rec.action('||i||'): '|| l_atp_rec.action(i));
1775: aso_debug_pub.add('do_check_atp: l_atp_rec.identifier('||i||'): '|| l_atp_rec.identifier(i));
1776: aso_debug_pub.add('do_check_atp: l_atp_rec.parent_line_id('||i||'): '|| l_atp_rec.parent_line_id(i));
1777: aso_debug_pub.add('do_check_atp: l_atp_rec.top_model_line_id('||i||'): '|| l_atp_rec.top_model_line_id(i));
1778: aso_debug_pub.add('do_check_atp: l_atp_rec.ato_model_line_id('||i||'): '|| l_atp_rec.ato_model_line_id(i));
1779: aso_debug_pub.add('do_check_atp: l_atp_rec.component_code('||i||'): '|| l_atp_rec.component_code(i));
1780: aso_debug_pub.add('do_check_atp: l_atp_rec.component_sequence_id('||i||'): '|| l_atp_rec.component_sequence_id(i));
1781: aso_debug_pub.add('do_check_atp: l_atp_rec.ship_set_name('||i||'): '|| l_atp_rec.ship_set_name(i));
1782: aso_debug_pub.add('do_check_atp: l_atp_rec.action('||i||'): '|| l_atp_rec.action(i));
1783: aso_debug_pub.add('do_check_atp: l_atp_rec.calling_module('||i||'): '|| l_atp_rec.calling_module(i));
1776: aso_debug_pub.add('do_check_atp: l_atp_rec.parent_line_id('||i||'): '|| l_atp_rec.parent_line_id(i));
1777: aso_debug_pub.add('do_check_atp: l_atp_rec.top_model_line_id('||i||'): '|| l_atp_rec.top_model_line_id(i));
1778: aso_debug_pub.add('do_check_atp: l_atp_rec.ato_model_line_id('||i||'): '|| l_atp_rec.ato_model_line_id(i));
1779: aso_debug_pub.add('do_check_atp: l_atp_rec.component_code('||i||'): '|| l_atp_rec.component_code(i));
1780: aso_debug_pub.add('do_check_atp: l_atp_rec.component_sequence_id('||i||'): '|| l_atp_rec.component_sequence_id(i));
1781: aso_debug_pub.add('do_check_atp: l_atp_rec.ship_set_name('||i||'): '|| l_atp_rec.ship_set_name(i));
1782: aso_debug_pub.add('do_check_atp: l_atp_rec.action('||i||'): '|| l_atp_rec.action(i));
1783: aso_debug_pub.add('do_check_atp: l_atp_rec.calling_module('||i||'): '|| l_atp_rec.calling_module(i));
1784: aso_debug_pub.add('do_check_atp: l_atp_rec.inventory_item_id('||i||'): '|| l_atp_rec.inventory_item_id(i));
1777: aso_debug_pub.add('do_check_atp: l_atp_rec.top_model_line_id('||i||'): '|| l_atp_rec.top_model_line_id(i));
1778: aso_debug_pub.add('do_check_atp: l_atp_rec.ato_model_line_id('||i||'): '|| l_atp_rec.ato_model_line_id(i));
1779: aso_debug_pub.add('do_check_atp: l_atp_rec.component_code('||i||'): '|| l_atp_rec.component_code(i));
1780: aso_debug_pub.add('do_check_atp: l_atp_rec.component_sequence_id('||i||'): '|| l_atp_rec.component_sequence_id(i));
1781: aso_debug_pub.add('do_check_atp: l_atp_rec.ship_set_name('||i||'): '|| l_atp_rec.ship_set_name(i));
1782: aso_debug_pub.add('do_check_atp: l_atp_rec.action('||i||'): '|| l_atp_rec.action(i));
1783: aso_debug_pub.add('do_check_atp: l_atp_rec.calling_module('||i||'): '|| l_atp_rec.calling_module(i));
1784: aso_debug_pub.add('do_check_atp: l_atp_rec.inventory_item_id('||i||'): '|| l_atp_rec.inventory_item_id(i));
1785: aso_debug_pub.add('do_check_atp: l_atp_rec.validation_org('||i||'): '|| l_atp_rec.validation_org(i));
1778: aso_debug_pub.add('do_check_atp: l_atp_rec.ato_model_line_id('||i||'): '|| l_atp_rec.ato_model_line_id(i));
1779: aso_debug_pub.add('do_check_atp: l_atp_rec.component_code('||i||'): '|| l_atp_rec.component_code(i));
1780: aso_debug_pub.add('do_check_atp: l_atp_rec.component_sequence_id('||i||'): '|| l_atp_rec.component_sequence_id(i));
1781: aso_debug_pub.add('do_check_atp: l_atp_rec.ship_set_name('||i||'): '|| l_atp_rec.ship_set_name(i));
1782: aso_debug_pub.add('do_check_atp: l_atp_rec.action('||i||'): '|| l_atp_rec.action(i));
1783: aso_debug_pub.add('do_check_atp: l_atp_rec.calling_module('||i||'): '|| l_atp_rec.calling_module(i));
1784: aso_debug_pub.add('do_check_atp: l_atp_rec.inventory_item_id('||i||'): '|| l_atp_rec.inventory_item_id(i));
1785: aso_debug_pub.add('do_check_atp: l_atp_rec.validation_org('||i||'): '|| l_atp_rec.validation_org(i));
1786: aso_debug_pub.add('do_check_atp: l_atp_rec.quantity_ordered('||i||'): '|| l_atp_rec.quantity_ordered(i));
1779: aso_debug_pub.add('do_check_atp: l_atp_rec.component_code('||i||'): '|| l_atp_rec.component_code(i));
1780: aso_debug_pub.add('do_check_atp: l_atp_rec.component_sequence_id('||i||'): '|| l_atp_rec.component_sequence_id(i));
1781: aso_debug_pub.add('do_check_atp: l_atp_rec.ship_set_name('||i||'): '|| l_atp_rec.ship_set_name(i));
1782: aso_debug_pub.add('do_check_atp: l_atp_rec.action('||i||'): '|| l_atp_rec.action(i));
1783: aso_debug_pub.add('do_check_atp: l_atp_rec.calling_module('||i||'): '|| l_atp_rec.calling_module(i));
1784: aso_debug_pub.add('do_check_atp: l_atp_rec.inventory_item_id('||i||'): '|| l_atp_rec.inventory_item_id(i));
1785: aso_debug_pub.add('do_check_atp: l_atp_rec.validation_org('||i||'): '|| l_atp_rec.validation_org(i));
1786: aso_debug_pub.add('do_check_atp: l_atp_rec.quantity_ordered('||i||'): '|| l_atp_rec.quantity_ordered(i));
1787: aso_debug_pub.add('do_check_atp: l_atp_rec.quantity_uom('||i||'): '|| l_atp_rec.quantity_uom(i));
1780: aso_debug_pub.add('do_check_atp: l_atp_rec.component_sequence_id('||i||'): '|| l_atp_rec.component_sequence_id(i));
1781: aso_debug_pub.add('do_check_atp: l_atp_rec.ship_set_name('||i||'): '|| l_atp_rec.ship_set_name(i));
1782: aso_debug_pub.add('do_check_atp: l_atp_rec.action('||i||'): '|| l_atp_rec.action(i));
1783: aso_debug_pub.add('do_check_atp: l_atp_rec.calling_module('||i||'): '|| l_atp_rec.calling_module(i));
1784: aso_debug_pub.add('do_check_atp: l_atp_rec.inventory_item_id('||i||'): '|| l_atp_rec.inventory_item_id(i));
1785: aso_debug_pub.add('do_check_atp: l_atp_rec.validation_org('||i||'): '|| l_atp_rec.validation_org(i));
1786: aso_debug_pub.add('do_check_atp: l_atp_rec.quantity_ordered('||i||'): '|| l_atp_rec.quantity_ordered(i));
1787: aso_debug_pub.add('do_check_atp: l_atp_rec.quantity_uom('||i||'): '|| l_atp_rec.quantity_uom(i));
1788: aso_debug_pub.add('do_check_atp: l_atp_rec.demand_source_header_id('||i||'): '|| l_atp_rec.demand_source_header_id(i));
1781: aso_debug_pub.add('do_check_atp: l_atp_rec.ship_set_name('||i||'): '|| l_atp_rec.ship_set_name(i));
1782: aso_debug_pub.add('do_check_atp: l_atp_rec.action('||i||'): '|| l_atp_rec.action(i));
1783: aso_debug_pub.add('do_check_atp: l_atp_rec.calling_module('||i||'): '|| l_atp_rec.calling_module(i));
1784: aso_debug_pub.add('do_check_atp: l_atp_rec.inventory_item_id('||i||'): '|| l_atp_rec.inventory_item_id(i));
1785: aso_debug_pub.add('do_check_atp: l_atp_rec.validation_org('||i||'): '|| l_atp_rec.validation_org(i));
1786: aso_debug_pub.add('do_check_atp: l_atp_rec.quantity_ordered('||i||'): '|| l_atp_rec.quantity_ordered(i));
1787: aso_debug_pub.add('do_check_atp: l_atp_rec.quantity_uom('||i||'): '|| l_atp_rec.quantity_uom(i));
1788: aso_debug_pub.add('do_check_atp: l_atp_rec.demand_source_header_id('||i||'): '|| l_atp_rec.demand_source_header_id(i));
1789: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_id('||i||'): '|| l_atp_rec.customer_id(i));
1782: aso_debug_pub.add('do_check_atp: l_atp_rec.action('||i||'): '|| l_atp_rec.action(i));
1783: aso_debug_pub.add('do_check_atp: l_atp_rec.calling_module('||i||'): '|| l_atp_rec.calling_module(i));
1784: aso_debug_pub.add('do_check_atp: l_atp_rec.inventory_item_id('||i||'): '|| l_atp_rec.inventory_item_id(i));
1785: aso_debug_pub.add('do_check_atp: l_atp_rec.validation_org('||i||'): '|| l_atp_rec.validation_org(i));
1786: aso_debug_pub.add('do_check_atp: l_atp_rec.quantity_ordered('||i||'): '|| l_atp_rec.quantity_ordered(i));
1787: aso_debug_pub.add('do_check_atp: l_atp_rec.quantity_uom('||i||'): '|| l_atp_rec.quantity_uom(i));
1788: aso_debug_pub.add('do_check_atp: l_atp_rec.demand_source_header_id('||i||'): '|| l_atp_rec.demand_source_header_id(i));
1789: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_id('||i||'): '|| l_atp_rec.customer_id(i));
1790: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_site_id('||i||'): '|| l_atp_rec.customer_site_id(i));
1783: aso_debug_pub.add('do_check_atp: l_atp_rec.calling_module('||i||'): '|| l_atp_rec.calling_module(i));
1784: aso_debug_pub.add('do_check_atp: l_atp_rec.inventory_item_id('||i||'): '|| l_atp_rec.inventory_item_id(i));
1785: aso_debug_pub.add('do_check_atp: l_atp_rec.validation_org('||i||'): '|| l_atp_rec.validation_org(i));
1786: aso_debug_pub.add('do_check_atp: l_atp_rec.quantity_ordered('||i||'): '|| l_atp_rec.quantity_ordered(i));
1787: aso_debug_pub.add('do_check_atp: l_atp_rec.quantity_uom('||i||'): '|| l_atp_rec.quantity_uom(i));
1788: aso_debug_pub.add('do_check_atp: l_atp_rec.demand_source_header_id('||i||'): '|| l_atp_rec.demand_source_header_id(i));
1789: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_id('||i||'): '|| l_atp_rec.customer_id(i));
1790: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_site_id('||i||'): '|| l_atp_rec.customer_site_id(i));
1791: aso_debug_pub.add('do_check_atp: l_atp_rec.ship_method('||i||'): '|| l_atp_rec.ship_method(i));
1784: aso_debug_pub.add('do_check_atp: l_atp_rec.inventory_item_id('||i||'): '|| l_atp_rec.inventory_item_id(i));
1785: aso_debug_pub.add('do_check_atp: l_atp_rec.validation_org('||i||'): '|| l_atp_rec.validation_org(i));
1786: aso_debug_pub.add('do_check_atp: l_atp_rec.quantity_ordered('||i||'): '|| l_atp_rec.quantity_ordered(i));
1787: aso_debug_pub.add('do_check_atp: l_atp_rec.quantity_uom('||i||'): '|| l_atp_rec.quantity_uom(i));
1788: aso_debug_pub.add('do_check_atp: l_atp_rec.demand_source_header_id('||i||'): '|| l_atp_rec.demand_source_header_id(i));
1789: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_id('||i||'): '|| l_atp_rec.customer_id(i));
1790: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_site_id('||i||'): '|| l_atp_rec.customer_site_id(i));
1791: aso_debug_pub.add('do_check_atp: l_atp_rec.ship_method('||i||'): '|| l_atp_rec.ship_method(i));
1792: aso_debug_pub.add('do_check_atp: l_atp_rec.order_number('||i||'): '|| l_atp_rec.order_number(i));
1785: aso_debug_pub.add('do_check_atp: l_atp_rec.validation_org('||i||'): '|| l_atp_rec.validation_org(i));
1786: aso_debug_pub.add('do_check_atp: l_atp_rec.quantity_ordered('||i||'): '|| l_atp_rec.quantity_ordered(i));
1787: aso_debug_pub.add('do_check_atp: l_atp_rec.quantity_uom('||i||'): '|| l_atp_rec.quantity_uom(i));
1788: aso_debug_pub.add('do_check_atp: l_atp_rec.demand_source_header_id('||i||'): '|| l_atp_rec.demand_source_header_id(i));
1789: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_id('||i||'): '|| l_atp_rec.customer_id(i));
1790: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_site_id('||i||'): '|| l_atp_rec.customer_site_id(i));
1791: aso_debug_pub.add('do_check_atp: l_atp_rec.ship_method('||i||'): '|| l_atp_rec.ship_method(i));
1792: aso_debug_pub.add('do_check_atp: l_atp_rec.order_number('||i||'): '|| l_atp_rec.order_number(i));
1793: aso_debug_pub.add('do_check_atp: l_atp_rec.source_organization_id('||i||'): '|| l_atp_rec.source_organization_id(i));
1786: aso_debug_pub.add('do_check_atp: l_atp_rec.quantity_ordered('||i||'): '|| l_atp_rec.quantity_ordered(i));
1787: aso_debug_pub.add('do_check_atp: l_atp_rec.quantity_uom('||i||'): '|| l_atp_rec.quantity_uom(i));
1788: aso_debug_pub.add('do_check_atp: l_atp_rec.demand_source_header_id('||i||'): '|| l_atp_rec.demand_source_header_id(i));
1789: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_id('||i||'): '|| l_atp_rec.customer_id(i));
1790: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_site_id('||i||'): '|| l_atp_rec.customer_site_id(i));
1791: aso_debug_pub.add('do_check_atp: l_atp_rec.ship_method('||i||'): '|| l_atp_rec.ship_method(i));
1792: aso_debug_pub.add('do_check_atp: l_atp_rec.order_number('||i||'): '|| l_atp_rec.order_number(i));
1793: aso_debug_pub.add('do_check_atp: l_atp_rec.source_organization_id('||i||'): '|| l_atp_rec.source_organization_id(i));
1794: aso_debug_pub.add('do_check_atp: l_atp_rec.demand_class('||i||'): '|| l_atp_rec.demand_class(i));
1787: aso_debug_pub.add('do_check_atp: l_atp_rec.quantity_uom('||i||'): '|| l_atp_rec.quantity_uom(i));
1788: aso_debug_pub.add('do_check_atp: l_atp_rec.demand_source_header_id('||i||'): '|| l_atp_rec.demand_source_header_id(i));
1789: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_id('||i||'): '|| l_atp_rec.customer_id(i));
1790: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_site_id('||i||'): '|| l_atp_rec.customer_site_id(i));
1791: aso_debug_pub.add('do_check_atp: l_atp_rec.ship_method('||i||'): '|| l_atp_rec.ship_method(i));
1792: aso_debug_pub.add('do_check_atp: l_atp_rec.order_number('||i||'): '|| l_atp_rec.order_number(i));
1793: aso_debug_pub.add('do_check_atp: l_atp_rec.source_organization_id('||i||'): '|| l_atp_rec.source_organization_id(i));
1794: aso_debug_pub.add('do_check_atp: l_atp_rec.demand_class('||i||'): '|| l_atp_rec.demand_class(i));
1795: aso_debug_pub.add('do_check_atp: l_atp_rec.requested_arrival_date('||i||'): '|| l_atp_rec.requested_arrival_date(i));
1788: aso_debug_pub.add('do_check_atp: l_atp_rec.demand_source_header_id('||i||'): '|| l_atp_rec.demand_source_header_id(i));
1789: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_id('||i||'): '|| l_atp_rec.customer_id(i));
1790: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_site_id('||i||'): '|| l_atp_rec.customer_site_id(i));
1791: aso_debug_pub.add('do_check_atp: l_atp_rec.ship_method('||i||'): '|| l_atp_rec.ship_method(i));
1792: aso_debug_pub.add('do_check_atp: l_atp_rec.order_number('||i||'): '|| l_atp_rec.order_number(i));
1793: aso_debug_pub.add('do_check_atp: l_atp_rec.source_organization_id('||i||'): '|| l_atp_rec.source_organization_id(i));
1794: aso_debug_pub.add('do_check_atp: l_atp_rec.demand_class('||i||'): '|| l_atp_rec.demand_class(i));
1795: aso_debug_pub.add('do_check_atp: l_atp_rec.requested_arrival_date('||i||'): '|| l_atp_rec.requested_arrival_date(i));
1796: aso_debug_pub.add('do_check_atp: l_atp_rec.requested_ship_date('||i||'): '|| l_atp_rec.requested_ship_date(i));
1789: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_id('||i||'): '|| l_atp_rec.customer_id(i));
1790: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_site_id('||i||'): '|| l_atp_rec.customer_site_id(i));
1791: aso_debug_pub.add('do_check_atp: l_atp_rec.ship_method('||i||'): '|| l_atp_rec.ship_method(i));
1792: aso_debug_pub.add('do_check_atp: l_atp_rec.order_number('||i||'): '|| l_atp_rec.order_number(i));
1793: aso_debug_pub.add('do_check_atp: l_atp_rec.source_organization_id('||i||'): '|| l_atp_rec.source_organization_id(i));
1794: aso_debug_pub.add('do_check_atp: l_atp_rec.demand_class('||i||'): '|| l_atp_rec.demand_class(i));
1795: aso_debug_pub.add('do_check_atp: l_atp_rec.requested_arrival_date('||i||'): '|| l_atp_rec.requested_arrival_date(i));
1796: aso_debug_pub.add('do_check_atp: l_atp_rec.requested_ship_date('||i||'): '|| l_atp_rec.requested_ship_date(i));
1797: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_country('||i||'): '|| l_atp_rec.customer_country(i));
1790: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_site_id('||i||'): '|| l_atp_rec.customer_site_id(i));
1791: aso_debug_pub.add('do_check_atp: l_atp_rec.ship_method('||i||'): '|| l_atp_rec.ship_method(i));
1792: aso_debug_pub.add('do_check_atp: l_atp_rec.order_number('||i||'): '|| l_atp_rec.order_number(i));
1793: aso_debug_pub.add('do_check_atp: l_atp_rec.source_organization_id('||i||'): '|| l_atp_rec.source_organization_id(i));
1794: aso_debug_pub.add('do_check_atp: l_atp_rec.demand_class('||i||'): '|| l_atp_rec.demand_class(i));
1795: aso_debug_pub.add('do_check_atp: l_atp_rec.requested_arrival_date('||i||'): '|| l_atp_rec.requested_arrival_date(i));
1796: aso_debug_pub.add('do_check_atp: l_atp_rec.requested_ship_date('||i||'): '|| l_atp_rec.requested_ship_date(i));
1797: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_country('||i||'): '|| l_atp_rec.customer_country(i));
1798: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_state('||i||'): '|| l_atp_rec.customer_state(i));
1791: aso_debug_pub.add('do_check_atp: l_atp_rec.ship_method('||i||'): '|| l_atp_rec.ship_method(i));
1792: aso_debug_pub.add('do_check_atp: l_atp_rec.order_number('||i||'): '|| l_atp_rec.order_number(i));
1793: aso_debug_pub.add('do_check_atp: l_atp_rec.source_organization_id('||i||'): '|| l_atp_rec.source_organization_id(i));
1794: aso_debug_pub.add('do_check_atp: l_atp_rec.demand_class('||i||'): '|| l_atp_rec.demand_class(i));
1795: aso_debug_pub.add('do_check_atp: l_atp_rec.requested_arrival_date('||i||'): '|| l_atp_rec.requested_arrival_date(i));
1796: aso_debug_pub.add('do_check_atp: l_atp_rec.requested_ship_date('||i||'): '|| l_atp_rec.requested_ship_date(i));
1797: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_country('||i||'): '|| l_atp_rec.customer_country(i));
1798: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_state('||i||'): '|| l_atp_rec.customer_state(i));
1799: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_city('||i||'): '|| l_atp_rec.customer_city(i));
1792: aso_debug_pub.add('do_check_atp: l_atp_rec.order_number('||i||'): '|| l_atp_rec.order_number(i));
1793: aso_debug_pub.add('do_check_atp: l_atp_rec.source_organization_id('||i||'): '|| l_atp_rec.source_organization_id(i));
1794: aso_debug_pub.add('do_check_atp: l_atp_rec.demand_class('||i||'): '|| l_atp_rec.demand_class(i));
1795: aso_debug_pub.add('do_check_atp: l_atp_rec.requested_arrival_date('||i||'): '|| l_atp_rec.requested_arrival_date(i));
1796: aso_debug_pub.add('do_check_atp: l_atp_rec.requested_ship_date('||i||'): '|| l_atp_rec.requested_ship_date(i));
1797: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_country('||i||'): '|| l_atp_rec.customer_country(i));
1798: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_state('||i||'): '|| l_atp_rec.customer_state(i));
1799: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_city('||i||'): '|| l_atp_rec.customer_city(i));
1800: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_postal_code('||i||'): '|| l_atp_rec.customer_postal_code(i));
1793: aso_debug_pub.add('do_check_atp: l_atp_rec.source_organization_id('||i||'): '|| l_atp_rec.source_organization_id(i));
1794: aso_debug_pub.add('do_check_atp: l_atp_rec.demand_class('||i||'): '|| l_atp_rec.demand_class(i));
1795: aso_debug_pub.add('do_check_atp: l_atp_rec.requested_arrival_date('||i||'): '|| l_atp_rec.requested_arrival_date(i));
1796: aso_debug_pub.add('do_check_atp: l_atp_rec.requested_ship_date('||i||'): '|| l_atp_rec.requested_ship_date(i));
1797: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_country('||i||'): '|| l_atp_rec.customer_country(i));
1798: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_state('||i||'): '|| l_atp_rec.customer_state(i));
1799: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_city('||i||'): '|| l_atp_rec.customer_city(i));
1800: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_postal_code('||i||'): '|| l_atp_rec.customer_postal_code(i));
1801: end if;
1794: aso_debug_pub.add('do_check_atp: l_atp_rec.demand_class('||i||'): '|| l_atp_rec.demand_class(i));
1795: aso_debug_pub.add('do_check_atp: l_atp_rec.requested_arrival_date('||i||'): '|| l_atp_rec.requested_arrival_date(i));
1796: aso_debug_pub.add('do_check_atp: l_atp_rec.requested_ship_date('||i||'): '|| l_atp_rec.requested_ship_date(i));
1797: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_country('||i||'): '|| l_atp_rec.customer_country(i));
1798: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_state('||i||'): '|| l_atp_rec.customer_state(i));
1799: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_city('||i||'): '|| l_atp_rec.customer_city(i));
1800: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_postal_code('||i||'): '|| l_atp_rec.customer_postal_code(i));
1801: end if;
1802:
1795: aso_debug_pub.add('do_check_atp: l_atp_rec.requested_arrival_date('||i||'): '|| l_atp_rec.requested_arrival_date(i));
1796: aso_debug_pub.add('do_check_atp: l_atp_rec.requested_ship_date('||i||'): '|| l_atp_rec.requested_ship_date(i));
1797: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_country('||i||'): '|| l_atp_rec.customer_country(i));
1798: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_state('||i||'): '|| l_atp_rec.customer_state(i));
1799: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_city('||i||'): '|| l_atp_rec.customer_city(i));
1800: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_postal_code('||i||'): '|| l_atp_rec.customer_postal_code(i));
1801: end if;
1802:
1803: end loop;
1796: aso_debug_pub.add('do_check_atp: l_atp_rec.requested_ship_date('||i||'): '|| l_atp_rec.requested_ship_date(i));
1797: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_country('||i||'): '|| l_atp_rec.customer_country(i));
1798: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_state('||i||'): '|| l_atp_rec.customer_state(i));
1799: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_city('||i||'): '|| l_atp_rec.customer_city(i));
1800: aso_debug_pub.add('do_check_atp: l_atp_rec.customer_postal_code('||i||'): '|| l_atp_rec.customer_postal_code(i));
1801: end if;
1802:
1803: end loop;
1804:
1806:
1807: END IF; -- end if for debug
1808:
1809:
1810: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1811: aso_debug_pub.add('do_check_atp: Before call to msc_atp_global.get_atp_session_id procedure',1,'Y');
1812: END IF;
1813:
1814: MSC_ATP_GLOBAL.Get_ATP_Session_Id(l_session_id, x_return_status);
1807: END IF; -- end if for debug
1808:
1809:
1810: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1811: aso_debug_pub.add('do_check_atp: Before call to msc_atp_global.get_atp_session_id procedure',1,'Y');
1812: END IF;
1813:
1814: MSC_ATP_GLOBAL.Get_ATP_Session_Id(l_session_id, x_return_status);
1815:
1816: if x_return_status <> fnd_api.g_ret_sts_success then
1817: raise fnd_api.g_exc_unexpected_error;
1818: end if;
1819:
1820: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1821: aso_debug_pub.add('do_check_atp: After call to msc_atp_global.get_atp_session_id procedure',1,'Y');
1822: aso_debug_pub.add('do_check_atp: Before call to mrp_atp_pub.call_atp procedure',1,'Y');
1823: END IF;
1824:
1817: raise fnd_api.g_exc_unexpected_error;
1818: end if;
1819:
1820: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1821: aso_debug_pub.add('do_check_atp: After call to msc_atp_global.get_atp_session_id procedure',1,'Y');
1822: aso_debug_pub.add('do_check_atp: Before call to mrp_atp_pub.call_atp procedure',1,'Y');
1823: END IF;
1824:
1825: MRP_ATP_PUB.CALL_ATP(l_session_id,
1818: end if;
1819:
1820: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1821: aso_debug_pub.add('do_check_atp: After call to msc_atp_global.get_atp_session_id procedure',1,'Y');
1822: aso_debug_pub.add('do_check_atp: Before call to mrp_atp_pub.call_atp procedure',1,'Y');
1823: END IF;
1824:
1825: MRP_ATP_PUB.CALL_ATP(l_session_id,
1826: l_atp_rec,
1831: x_return_status,
1832: x_new_msg_data,
1833: x_msg_count);
1834:
1835: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1836: aso_debug_pub.add('do_check_atp: After call to mrp_atp_pub.call_atp procedure',1,'Y');
1837: aso_debug_pub.add('do_check_atp: x_return_status: '|| x_return_status ,1,'Y');
1838: aso_debug_pub.add('Error msg: '||x_new_msg_data,1,'Y');
1839: END IF;
1832: x_new_msg_data,
1833: x_msg_count);
1834:
1835: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1836: aso_debug_pub.add('do_check_atp: After call to mrp_atp_pub.call_atp procedure',1,'Y');
1837: aso_debug_pub.add('do_check_atp: x_return_status: '|| x_return_status ,1,'Y');
1838: aso_debug_pub.add('Error msg: '||x_new_msg_data,1,'Y');
1839: END IF;
1840:
1833: x_msg_count);
1834:
1835: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1836: aso_debug_pub.add('do_check_atp: After call to mrp_atp_pub.call_atp procedure',1,'Y');
1837: aso_debug_pub.add('do_check_atp: x_return_status: '|| x_return_status ,1,'Y');
1838: aso_debug_pub.add('Error msg: '||x_new_msg_data,1,'Y');
1839: END IF;
1840:
1841: if x_return_status <> fnd_api.g_ret_sts_success then
1834:
1835: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1836: aso_debug_pub.add('do_check_atp: After call to mrp_atp_pub.call_atp procedure',1,'Y');
1837: aso_debug_pub.add('do_check_atp: x_return_status: '|| x_return_status ,1,'Y');
1838: aso_debug_pub.add('Error msg: '||x_new_msg_data,1,'Y');
1839: END IF;
1840:
1841: if x_return_status <> fnd_api.g_ret_sts_success then
1842: raise fnd_api.g_exc_unexpected_error;
1845:
1846:
1847: /* added new debug messages */
1848:
1849: if aso_debug_pub.g_debug_flag = 'Y' then
1850:
1851: aso_debug_pub.add('do_check_atp: Printing the atp_rec_out ',1,'Y');
1852:
1853: if l_atp_rec_out.inventory_item_id IS NOT NULL then
1847: /* added new debug messages */
1848:
1849: if aso_debug_pub.g_debug_flag = 'Y' then
1850:
1851: aso_debug_pub.add('do_check_atp: Printing the atp_rec_out ',1,'Y');
1852:
1853: if l_atp_rec_out.inventory_item_id IS NOT NULL then
1854:
1855: for i in l_atp_rec_out.inventory_item_id.FIRST .. l_atp_rec_out.inventory_item_id.LAST loop
1854:
1855: for i in l_atp_rec_out.inventory_item_id.FIRST .. l_atp_rec_out.inventory_item_id.LAST loop
1856:
1857: if l_atp_rec_out.inventory_item_id.EXISTS(i) then
1858: aso_debug_pub.add('do_check_atp: l_atp_rec_out.inventory_item_id '|| l_atp_rec_out.inventory_item_id(i),1,'Y');
1859: end if;
1860:
1861: if l_atp_rec_out.identifier.EXISTS(i) then
1862: aso_debug_pub.add('do_check_atp: l_atp_rec_out.identifier '|| l_atp_rec_out.identifier(i),1,'Y');
1858: aso_debug_pub.add('do_check_atp: l_atp_rec_out.inventory_item_id '|| l_atp_rec_out.inventory_item_id(i),1,'Y');
1859: end if;
1860:
1861: if l_atp_rec_out.identifier.EXISTS(i) then
1862: aso_debug_pub.add('do_check_atp: l_atp_rec_out.identifier '|| l_atp_rec_out.identifier(i),1,'Y');
1863: end if;
1864:
1865: if l_atp_rec_out.Error_Code.EXISTS(i) then
1866: aso_debug_pub.add('do_check_atp: l_atp_rec_out.Error_Code '|| l_atp_rec_out.Error_Code(i),1,'Y');
1862: aso_debug_pub.add('do_check_atp: l_atp_rec_out.identifier '|| l_atp_rec_out.identifier(i),1,'Y');
1863: end if;
1864:
1865: if l_atp_rec_out.Error_Code.EXISTS(i) then
1866: aso_debug_pub.add('do_check_atp: l_atp_rec_out.Error_Code '|| l_atp_rec_out.Error_Code(i),1,'Y');
1867: end if;
1868:
1869: end loop;
1870:
1873: end if; -- checking the debug flag if
1874:
1875: /* end of new debug messages */
1876:
1877: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1878: aso_debug_pub.add('do_check_atp:Before calling populate_output_table' );
1879: END IF;
1880:
1881: populate_output_table(l_atp_rec_out,x_atp_tbl,x_return_status);
1874:
1875: /* end of new debug messages */
1876:
1877: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1878: aso_debug_pub.add('do_check_atp:Before calling populate_output_table' );
1879: END IF;
1880:
1881: populate_output_table(l_atp_rec_out,x_atp_tbl,x_return_status);
1882:
1879: END IF;
1880:
1881: populate_output_table(l_atp_rec_out,x_atp_tbl,x_return_status);
1882:
1883: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1884: aso_debug_pub.add('do_check_atp:After calling populate_output_table: x_return_status: '|| x_return_status );
1885: END IF;
1886:
1887: -- Logic for ordering the output by UI Line Number
1880:
1881: populate_output_table(l_atp_rec_out,x_atp_tbl,x_return_status);
1882:
1883: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1884: aso_debug_pub.add('do_check_atp:After calling populate_output_table: x_return_status: '|| x_return_status );
1885: END IF;
1886:
1887: -- Logic for ordering the output by UI Line Number
1888: /* for i in 1..x_atp_tbl.count loop
1917: end if;
1918: */
1919:
1920:
1921: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1922: aso_debug_pub.add('do_check_atp: END' );
1923: END IF;
1924:
1925: EXCEPTION
1918: */
1919:
1920:
1921: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1922: aso_debug_pub.add('do_check_atp: END' );
1923: END IF;
1924:
1925: EXCEPTION
1926:
2011: BEGIN
2012: -- Standard Start of API savepoint
2013: SAVEPOINT CHECK_ATP_INT;
2014:
2015: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
2016:
2017: -- Standard call to check for call compatibility.
2018: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2019: p_api_version_number,
2036: */
2037:
2038: l_aps_version := MSC_ATP_GLOBAL.Get_APS_Version;
2039:
2040: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2041: aso_debug_pub.add('Check_atp : l_aps_version: '|| l_aps_version,1,'Y');
2042: aso_debug_pub.add('Check_atp : use sourcing rule is '||l_use_sourcing_rule,1,'Y');
2043: END IF;
2044:
2037:
2038: l_aps_version := MSC_ATP_GLOBAL.Get_APS_Version;
2039:
2040: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2041: aso_debug_pub.add('Check_atp : l_aps_version: '|| l_aps_version,1,'Y');
2042: aso_debug_pub.add('Check_atp : use sourcing rule is '||l_use_sourcing_rule,1,'Y');
2043: END IF;
2044:
2045: if l_aps_version = 10 then
2038: l_aps_version := MSC_ATP_GLOBAL.Get_APS_Version;
2039:
2040: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2041: aso_debug_pub.add('Check_atp : l_aps_version: '|| l_aps_version,1,'Y');
2042: aso_debug_pub.add('Check_atp : use sourcing rule is '||l_use_sourcing_rule,1,'Y');
2043: END IF;
2044:
2045: if l_aps_version = 10 then
2046:
2055: x_msg_count => x_msg_count,
2056: x_msg_data => x_msg_data,
2057: x_atp_tbl => x_atp_tbl);
2058:
2059: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2060: aso_debug_pub.add('Check_atp :After calling do_check_atp',1,'Y');
2061: aso_debug_pub.add('Check_atp :x_return_status: '|| x_return_status ,1,'Y');
2062: END IF;
2063:
2056: x_msg_data => x_msg_data,
2057: x_atp_tbl => x_atp_tbl);
2058:
2059: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2060: aso_debug_pub.add('Check_atp :After calling do_check_atp',1,'Y');
2061: aso_debug_pub.add('Check_atp :x_return_status: '|| x_return_status ,1,'Y');
2062: END IF;
2063:
2064:
2057: x_atp_tbl => x_atp_tbl);
2058:
2059: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2060: aso_debug_pub.add('Check_atp :After calling do_check_atp',1,'Y');
2061: aso_debug_pub.add('Check_atp :x_return_status: '|| x_return_status ,1,'Y');
2062: END IF;
2063:
2064:
2065: if x_return_status = FND_API.G_RET_STS_ERROR then
2082: n of customer and site id so that mrp api can use sourcing rules */
2083:
2084: l_use_sourcing_rule := fnd_profile.value(name => 'ASO_ATP_USE_SOURCING_RULE');
2085:
2086: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2087: aso_debug_pub.add('Check_atp : use sourcing rule is '||l_use_sourcing_rule,1,'Y');
2088: END IF;
2089:
2090: IF l_use_sourcing_rule IS NULL OR l_use_sourcing_rule = 'N' THEN
2083:
2084: l_use_sourcing_rule := fnd_profile.value(name => 'ASO_ATP_USE_SOURCING_RULE');
2085:
2086: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2087: aso_debug_pub.add('Check_atp : use sourcing rule is '||l_use_sourcing_rule,1,'Y');
2088: END IF;
2089:
2090: IF l_use_sourcing_rule IS NULL OR l_use_sourcing_rule = 'N' THEN
2091:
2110:
2111: -- To get the Default Customer Id from profile ASO: Atp Default Customer
2112: l_customer_id := fnd_profile.value(name => 'ASO_ATP_DEFAULT_CUSTOMER_ID');
2113:
2114: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2115: aso_debug_pub.add('Check_atp: Default Customer Id from profile'||l_customer_id,1,'Y');
2116: END IF;
2117:
2118: IF l_customer_id IS NULL Then
2111: -- To get the Default Customer Id from profile ASO: Atp Default Customer
2112: l_customer_id := fnd_profile.value(name => 'ASO_ATP_DEFAULT_CUSTOMER_ID');
2113:
2114: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2115: aso_debug_pub.add('Check_atp: Default Customer Id from profile'||l_customer_id,1,'Y');
2116: END IF;
2117:
2118: IF l_customer_id IS NULL Then
2119: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2133: -- To get the Default Customer Ship to site Id from profile ASO: Atp Default SHip to Site id.
2134:
2135: l_cust_ship_site_id:= fnd_profile.value(name => 'ASO_ATP_SHIP_TO_SITE_ID');
2136:
2137: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2138: aso_debug_pub.add('Check_atp : Default Customer Site Id from profile'||l_cust_ship_site_id);
2139: END IF;
2140:
2141: IF l_cust_ship_site_id IS NULL Then
2134:
2135: l_cust_ship_site_id:= fnd_profile.value(name => 'ASO_ATP_SHIP_TO_SITE_ID');
2136:
2137: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2138: aso_debug_pub.add('Check_atp : Default Customer Site Id from profile'||l_cust_ship_site_id);
2139: END IF;
2140:
2141: IF l_cust_ship_site_id IS NULL Then
2142: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2157: For curr_index IN p_qte_line_tbl.FIRST .. p_qte_line_tbl.LAST Loop
2158: If p_qte_line_tbl.EXISTS(curr_index) Then
2159: Extend_ATP(l_atp_rec, x_return_status);
2160:
2161: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2162: aso_debug_pub.add('Check_Atp : Inventory Id for Atp is '||p_qte_line_tbl(curr_index).inventory_item_id);
2163: END IF;
2164:
2165: l_atp_rec.inventory_item_id(curr_index) := p_qte_line_tbl(curr_index).inventory_item_id;
2158: If p_qte_line_tbl.EXISTS(curr_index) Then
2159: Extend_ATP(l_atp_rec, x_return_status);
2160:
2161: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2162: aso_debug_pub.add('Check_Atp : Inventory Id for Atp is '||p_qte_line_tbl(curr_index).inventory_item_id);
2163: END IF;
2164:
2165: l_atp_rec.inventory_item_id(curr_index) := p_qte_line_tbl(curr_index).inventory_item_id;
2166:
2172: -- multi-org ATP
2173: l_atp_rec.source_organization_id(curr_index) := null;
2174: END IF;
2175:
2176: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2177: aso_debug_pub.add('Check_atp : Source Organization ID is '||l_atp_rec.source_organization_id(curr_index),1,'Y');
2178: aso_debug_pub.add('Check_atp : Organization ID is '||p_qte_line_tbl(curr_index).organization_id,1,'Y');
2179: END IF;
2180:
2173: l_atp_rec.source_organization_id(curr_index) := null;
2174: END IF;
2175:
2176: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2177: aso_debug_pub.add('Check_atp : Source Organization ID is '||l_atp_rec.source_organization_id(curr_index),1,'Y');
2178: aso_debug_pub.add('Check_atp : Organization ID is '||p_qte_line_tbl(curr_index).organization_id,1,'Y');
2179: END IF;
2180:
2181: l_atp_rec.organization_id(curr_index) :=
2174: END IF;
2175:
2176: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2177: aso_debug_pub.add('Check_atp : Source Organization ID is '||l_atp_rec.source_organization_id(curr_index),1,'Y');
2178: aso_debug_pub.add('Check_atp : Organization ID is '||p_qte_line_tbl(curr_index).organization_id,1,'Y');
2179: END IF;
2180:
2181: l_atp_rec.organization_id(curr_index) :=
2182: p_qte_line_tbl(curr_index).organization_id;
2194: if p_shipment_tbl( curr_index ).ship_from_org_id is null
2195: or p_shipment_tbl( curr_index ).ship_from_org_id = FND_API.G_MISS_NUM then
2196: /* Changes for the Save Warehouse */
2197:
2198: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2199: aso_debug_pub.add('Check_atp: Source Organization ID is '||l_atp_rec.source_organization_id(curr_index));
2200: END IF;
2201:
2202: /* Need to pass customer id, ship to site id and ship method id only if
2195: or p_shipment_tbl( curr_index ).ship_from_org_id = FND_API.G_MISS_NUM then
2196: /* Changes for the Save Warehouse */
2197:
2198: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2199: aso_debug_pub.add('Check_atp: Source Organization ID is '||l_atp_rec.source_organization_id(curr_index));
2200: END IF;
2201:
2202: /* Need to pass customer id, ship to site id and ship method id only if
2203: the use sourcing level profile is 'Yes' */
2207: AND p_shipment_tbl(curr_index).ship_to_party_site_id is NOT NULL
2208: THEN
2209: -- Check whether Customer and site id exists in MRP Collection.
2210:
2211: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2212: aso_debug_pub.add('Check_atp :Before checking for customer in mrp collection',1,'Y');
2213: END IF;
2214:
2215: open mrp_cust(p_shipment_tbl(curr_index).ship_to_cust_account_id);
2208: THEN
2209: -- Check whether Customer and site id exists in MRP Collection.
2210:
2211: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2212: aso_debug_pub.add('Check_atp :Before checking for customer in mrp collection',1,'Y');
2213: END IF;
2214:
2215: open mrp_cust(p_shipment_tbl(curr_index).ship_to_cust_account_id);
2216: fetch mrp_cust into l_mrp_customer_id;
2215: open mrp_cust(p_shipment_tbl(curr_index).ship_to_cust_account_id);
2216: fetch mrp_cust into l_mrp_customer_id;
2217: close mrp_cust;
2218:
2219: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2220: aso_debug_pub.add('Check_atp :After checking for customer in mrp collection',1,'Y');
2221: END IF;
2222:
2223: IF l_mrp_customer_id IS NOT NULL THEN
2216: fetch mrp_cust into l_mrp_customer_id;
2217: close mrp_cust;
2218:
2219: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2220: aso_debug_pub.add('Check_atp :After checking for customer in mrp collection',1,'Y');
2221: END IF;
2222:
2223: IF l_mrp_customer_id IS NOT NULL THEN
2224:
2225: open mrp_ship_site(p_shipment_tbl(curr_index).ship_to_party_site_id);
2226: fetch mrp_ship_site into l_mrp_ship_site_id;
2227: close mrp_ship_site;
2228:
2229: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2230: aso_debug_pub.add('Check_atp :After checking for cust site in mrp collection');
2231: END IF;
2232:
2233: IF l_mrp_ship_site_id IS NOT NULL THEN
2226: fetch mrp_ship_site into l_mrp_ship_site_id;
2227: close mrp_ship_site;
2228:
2229: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2230: aso_debug_pub.add('Check_atp :After checking for cust site in mrp collection');
2231: END IF;
2232:
2233: IF l_mrp_ship_site_id IS NOT NULL THEN
2234:
2231: END IF;
2232:
2233: IF l_mrp_ship_site_id IS NOT NULL THEN
2234:
2235: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2236:
2237: aso_debug_pub.add('Check_atp :Real Customer id'||
2238: p_shipment_tbl(curr_index).ship_to_cust_account_id||'
2239: and site id'||p_shipment_tbl(curr_index).ship_to_party_site_id,1,'Y');
2233: IF l_mrp_ship_site_id IS NOT NULL THEN
2234:
2235: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2236:
2237: aso_debug_pub.add('Check_atp :Real Customer id'||
2238: p_shipment_tbl(curr_index).ship_to_cust_account_id||'
2239: and site id'||p_shipment_tbl(curr_index).ship_to_party_site_id,1,'Y');
2240:
2241: END IF;
2244: l_atp_rec.customer_site_id(curr_index) := p_shipment_tbl(curr_index).ship_to_party_site_id;
2245: ELSE
2246: -- Pass the default customer and site id from profiles.
2247:
2248: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2249: aso_debug_pub.add('Check_atp :no data in MRP, use the default cust id '||l_customer_id ||' and ship site '||l_cust_ship_site_id,1,'Y');
2250: END IF;
2251:
2252: l_atp_rec.customer_id(curr_index) := l_customer_id;
2245: ELSE
2246: -- Pass the default customer and site id from profiles.
2247:
2248: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2249: aso_debug_pub.add('Check_atp :no data in MRP, use the default cust id '||l_customer_id ||' and ship site '||l_cust_ship_site_id,1,'Y');
2250: END IF;
2251:
2252: l_atp_rec.customer_id(curr_index) := l_customer_id;
2253: l_atp_rec.customer_site_id(curr_index) := l_cust_ship_site_id;
2257: END IF;
2258:
2259: ELSE
2260: -- Pass the default customer and site id from profiles.
2261: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2262: aso_debug_pub.add('Check_atp :cust and site id are null, use the default cust id '||l_customer_id ||' and ship site '||l_cust_ship_site_id,1,'Y');
2263: END IF;
2264:
2265: l_atp_rec.customer_id(curr_index) := l_customer_id;
2258:
2259: ELSE
2260: -- Pass the default customer and site id from profiles.
2261: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2262: aso_debug_pub.add('Check_atp :cust and site id are null, use the default cust id '||l_customer_id ||' and ship site '||l_cust_ship_site_id,1,'Y');
2263: END IF;
2264:
2265: l_atp_rec.customer_id(curr_index) := l_customer_id;
2266: l_atp_rec.customer_site_id(curr_index) := l_cust_ship_site_id;
2292:
2293: End If;
2294: End Loop;
2295:
2296: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2297: aso_debug_pub.add('Check_atp: Source Organization ID is '||l_atp_rec.source_organization_id(1));
2298: aso_debug_pub.add('Check_atp :Before calling mrp api ',1,'Y');
2299: END IF;
2300:
2293: End If;
2294: End Loop;
2295:
2296: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2297: aso_debug_pub.add('Check_atp: Source Organization ID is '||l_atp_rec.source_organization_id(1));
2298: aso_debug_pub.add('Check_atp :Before calling mrp api ',1,'Y');
2299: END IF;
2300:
2301: MRP_ATP_PUB.CALL_ATP(l_session_id,
2294: End Loop;
2295:
2296: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2297: aso_debug_pub.add('Check_atp: Source Organization ID is '||l_atp_rec.source_organization_id(1));
2298: aso_debug_pub.add('Check_atp :Before calling mrp api ',1,'Y');
2299: END IF;
2300:
2301: MRP_ATP_PUB.CALL_ATP(l_session_id,
2302: l_atp_rec,
2307: x_return_status,
2308: x_msg_data,
2309: x_msg_count);
2310:
2311: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2312: aso_debug_pub.add('Check_atp :After calling mrp api',1,'Y');
2313: aso_debug_pub.add('Check_atp :x_return_status === '|| x_return_status ,1,'Y');
2314: END IF;
2315:
2308: x_msg_data,
2309: x_msg_count);
2310:
2311: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2312: aso_debug_pub.add('Check_atp :After calling mrp api',1,'Y');
2313: aso_debug_pub.add('Check_atp :x_return_status === '|| x_return_status ,1,'Y');
2314: END IF;
2315:
2316: If x_return_status <> FND_API.G_RET_STS_SUCCESS Then
2309: x_msg_count);
2310:
2311: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2312: aso_debug_pub.add('Check_atp :After calling mrp api',1,'Y');
2313: aso_debug_pub.add('Check_atp :x_return_status === '|| x_return_status ,1,'Y');
2314: END IF;
2315:
2316: If x_return_status <> FND_API.G_RET_STS_SUCCESS Then
2317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2371: l_qte_header_rec aso_quote_pub.qte_header_rec_type;
2372:
2373: Begin
2374: x_return_status := fnd_api.g_ret_sts_success;
2375: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
2376:
2377: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2378: aso_debug_pub.add('ASO_ATP_INT: Check_Atp Begin', 1, 'Y');
2379: END IF;
2373: Begin
2374: x_return_status := fnd_api.g_ret_sts_success;
2375: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
2376:
2377: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2378: aso_debug_pub.add('ASO_ATP_INT: Check_Atp Begin', 1, 'Y');
2379: END IF;
2380:
2381: -- Initialize message list if p_init_msg_list is set to TRUE.
2374: x_return_status := fnd_api.g_ret_sts_success;
2375: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
2376:
2377: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2378: aso_debug_pub.add('ASO_ATP_INT: Check_Atp Begin', 1, 'Y');
2379: END IF;
2380:
2381: -- Initialize message list if p_init_msg_list is set to TRUE.
2382: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2396: x_msg_count => x_msg_count,
2397: x_msg_data => x_msg_data,
2398: x_atp_tbl => x_atp_tbl);
2399:
2400: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2401: aso_debug_pub.add('Check_atp :After calling check_atp overloaded procedure',1,'Y');
2402: aso_debug_pub.add('Check_atp :x_return_status: '|| x_return_status ,1,'Y');
2403: END IF;
2404:
2397: x_msg_data => x_msg_data,
2398: x_atp_tbl => x_atp_tbl);
2399:
2400: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2401: aso_debug_pub.add('Check_atp :After calling check_atp overloaded procedure',1,'Y');
2402: aso_debug_pub.add('Check_atp :x_return_status: '|| x_return_status ,1,'Y');
2403: END IF;
2404:
2405: EXCEPTION
2398: x_atp_tbl => x_atp_tbl);
2399:
2400: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2401: aso_debug_pub.add('Check_atp :After calling check_atp overloaded procedure',1,'Y');
2402: aso_debug_pub.add('Check_atp :x_return_status: '|| x_return_status ,1,'Y');
2403: END IF;
2404:
2405: EXCEPTION
2406:
2405: EXCEPTION
2406:
2407: WHEN OTHERS THEN
2408:
2409: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2410: aso_debug_pub.add('Check_Atp (not overloaded): Inside when others exception', 1, 'N');
2411: END IF;
2412:
2413: End Check_ATP;
2406:
2407: WHEN OTHERS THEN
2408:
2409: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2410: aso_debug_pub.add('Check_Atp (not overloaded): Inside when others exception', 1, 'N');
2411: END IF;
2412:
2413: End Check_ATP;
2414:
2483:
2484: -- Standard Start of API savepoint
2485: SAVEPOINT UPDATE_CONFIGURATION_INT;
2486:
2487: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
2488:
2489: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2490: aso_debug_pub.add('update_configuration: Begin');
2491: END IF;
2485: SAVEPOINT UPDATE_CONFIGURATION_INT;
2486:
2487: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
2488:
2489: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2490: aso_debug_pub.add('update_configuration: Begin');
2491: END IF;
2492:
2493: -- Standard call to check for call compatibility.
2486:
2487: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
2488:
2489: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2490: aso_debug_pub.add('update_configuration: Begin');
2491: END IF;
2492:
2493: -- Standard call to check for call compatibility.
2494: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2506: x_return_status := fnd_api.g_ret_sts_success;
2507: -- check to see if the quote header info is missing
2508: if p_qte_header_rec.quote_header_id is null or p_qte_header_rec.quote_header_id = fnd_api.g_miss_num then
2509:
2510: if aso_debug_pub.g_debug_flag = 'Y' THEN
2511: aso_debug_pub.add('p_qte_header_rec.quote_header_id is null');
2512: end if;
2513:
2514: if fnd_msg_pub.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2507: -- check to see if the quote header info is missing
2508: if p_qte_header_rec.quote_header_id is null or p_qte_header_rec.quote_header_id = fnd_api.g_miss_num then
2509:
2510: if aso_debug_pub.g_debug_flag = 'Y' THEN
2511: aso_debug_pub.add('p_qte_header_rec.quote_header_id is null');
2512: end if;
2513:
2514: if fnd_msg_pub.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2515: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ALL_MISSING_PARAM');
2521: raise fnd_api.g_exc_error;
2522: end if;
2523:
2524:
2525: if aso_debug_pub.g_debug_flag = 'Y' then
2526: aso_debug_pub.add('update_configuration: p_qte_line_dtl_tbl.count: '|| p_qte_line_dtl_tbl.count, 1, 'Y');
2527: end if;
2528:
2529: if p_qte_line_dtl_tbl.count = 0 then
2522: end if;
2523:
2524:
2525: if aso_debug_pub.g_debug_flag = 'Y' then
2526: aso_debug_pub.add('update_configuration: p_qte_line_dtl_tbl.count: '|| p_qte_line_dtl_tbl.count, 1, 'Y');
2527: end if;
2528:
2529: if p_qte_line_dtl_tbl.count = 0 then
2530:
2556: end if;
2557:
2558: end if;
2559:
2560: if aso_debug_pub.g_debug_flag = 'Y' then
2561: aso_debug_pub.add('update_configuration: l_qte_line_dtl_tbl.count: '|| l_qte_line_dtl_tbl.count, 1, 'Y');
2562: end if;
2563:
2564: for i in 1..l_qte_line_dtl_tbl.count loop
2557:
2558: end if;
2559:
2560: if aso_debug_pub.g_debug_flag = 'Y' then
2561: aso_debug_pub.add('update_configuration: l_qte_line_dtl_tbl.count: '|| l_qte_line_dtl_tbl.count, 1, 'Y');
2562: end if;
2563:
2564: for i in 1..l_qte_line_dtl_tbl.count loop
2565:
2600: end loop;
2601:
2602:
2603: IF fnd_api.to_boolean (p_commit) THEN
2604: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2605: aso_debug_pub.ADD ('Commiting the work',1,'N');
2606: END IF;
2607: COMMIT WORK;
2608: END IF;
2601:
2602:
2603: IF fnd_api.to_boolean (p_commit) THEN
2604: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2605: aso_debug_pub.ADD ('Commiting the work',1,'N');
2606: END IF;
2607: COMMIT WORK;
2608: END IF;
2609:
2614: x_msg_data := fnd_msg_pub.get(p_msg_index => k,
2615: p_encoded => 'F');
2616: end loop;
2617:
2618: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2619: aso_debug_pub.add('update_configuration: END' );
2620: END IF;
2621:
2622:
2615: p_encoded => 'F');
2616: end loop;
2617:
2618: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2619: aso_debug_pub.add('update_configuration: END' );
2620: END IF;
2621:
2622:
2623: EXCEPTION