[Home] [Help]
120: For mo_line in get_qty LOOP
121:
122: IF ( mo_line.quantity > mo_line.quantity_detailed ) THEN
123:
124: gmi_reservation_util.println('HELLO from the loop');
125: gmi_reservation_util.println('Value of quantity in chk_ship_set is '||mo_line.quantity );
126: gmi_reservation_util.println('Value of l_qty_detailed is ' ||mo_line.quantity_detailed);
127:
128: IF ( p_manual_pick = 'Y' ) THEN
121:
122: IF ( mo_line.quantity > mo_line.quantity_detailed ) THEN
123:
124: gmi_reservation_util.println('HELLO from the loop');
125: gmi_reservation_util.println('Value of quantity in chk_ship_set is '||mo_line.quantity );
126: gmi_reservation_util.println('Value of l_qty_detailed is ' ||mo_line.quantity_detailed);
127:
128: IF ( p_manual_pick = 'Y' ) THEN
129: gmi_reservation_util.println('Raising manual warning');
122: IF ( mo_line.quantity > mo_line.quantity_detailed ) THEN
123:
124: gmi_reservation_util.println('HELLO from the loop');
125: gmi_reservation_util.println('Value of quantity in chk_ship_set is '||mo_line.quantity );
126: gmi_reservation_util.println('Value of l_qty_detailed is ' ||mo_line.quantity_detailed);
127:
128: IF ( p_manual_pick = 'Y' ) THEN
129: gmi_reservation_util.println('Raising manual warning');
130: RAISE l_manual_warning;
125: gmi_reservation_util.println('Value of quantity in chk_ship_set is '||mo_line.quantity );
126: gmi_reservation_util.println('Value of l_qty_detailed is ' ||mo_line.quantity_detailed);
127:
128: IF ( p_manual_pick = 'Y' ) THEN
129: gmi_reservation_util.println('Raising manual warning');
130: RAISE l_manual_warning;
131: ELSIF ( p_manual_pick ='N')THEN
132: gmi_reservation_util.println('Ship set is broken. Qty allocated less than requested');
133: RAISE l_warning;
128: IF ( p_manual_pick = 'Y' ) THEN
129: gmi_reservation_util.println('Raising manual warning');
130: RAISE l_manual_warning;
131: ELSIF ( p_manual_pick ='N')THEN
132: gmi_reservation_util.println('Ship set is broken. Qty allocated less than requested');
133: RAISE l_warning;
134: END IF; -- of manual or auto allocation
135:
136: END IF; -- if qty > qty_detaild
135:
136: END IF; -- if qty > qty_detaild
137:
138: END LOOP; -- end of loop */
139: gmi_reservation_util.println('HELLO from end of chk-set prc.');
140:
141:
142: EXCEPTION
143: WHEN FND_API.G_EXC_ERROR THEN
186: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
187: l_mo_line_rec GMI_MOVE_ORDER_GLOBAL.mo_line_rec;
188: l_mo_line_tbl GMI_MOVE_ORDER_GLOBAL.mo_line_tbl;
189: l_location IC_TRAN_PND.LOCATION%TYPE;
190: l_ic_item_mst_rec GMI_RESERVATION_UTIL.ic_item_mst_rec;
191: l_shipping_attr WSH_INTERFACE.ChangedAttributeTabType;
192: l_trans_qty NUMBER;
193: l_trans_qty2 NUMBER;
194: l_trans_qty_sts NUMBER;
518:
519: /* Initialize API return status to sucess */
520: x_return_status := FND_API.G_RET_STS_SUCCESS;
521:
522: GMI_Reservation_Util.PrintLn('PICK_WAVE_CONFIRM PVT COUNT=> '||p_mo_line_tbl.COUNT);
523:
524: /* Get System Constant For Default Location Value. */
525:
526: l_location:= FND_PROFILE.Value_Specific(
529: );
530:
531: FOR I in 1..p_mo_line_TBL.COUNT LOOP
532: l_mo_line_rec := p_mo_line_tbl(I);
533: GMI_RESERVATION_UTIL.PrintLn('Check Missing For Row > '|| I );
534: IF check_required( p_mo_line_rec => l_mo_line_rec) THEN
535: WSH_Util_Core.PrintLn('Check Missing Falied ');
536: FND_MESSAGE.SET_NAME('GMI','GMI_REQUIRED_MISSING');
537: FND_MSG_PUB.ADD;
540:
541: -- HW BUG#:2296620 call to check ship_sets
542: l_manual_pick := p_manual_pick;
543:
544: gmi_reservation_util.println('Value of p_manual_pick is '||l_manual_pick);
545:
546:
547: IF ( l_manual_pick = 'N') THEN
548: gmi_reservation_util.println('Value of count is '||p_mo_line_TBL.COUNT);
544: gmi_reservation_util.println('Value of p_manual_pick is '||l_manual_pick);
545:
546:
547: IF ( l_manual_pick = 'N') THEN
548: gmi_reservation_util.println('Value of count is '||p_mo_line_TBL.COUNT);
549:
550: gmi_reservation_util.println('Value of ship_Set id is '|| l_mo_line_rec.ship_set_id);
551: gmi_reservation_util.println('Value of l_mo_line_rec.quantity_detailed is '||l_mo_line_rec.quantity_Detailed);
552: IF (l_mo_line_rec.ship_set_id IS NOT NULL ) THEN
546:
547: IF ( l_manual_pick = 'N') THEN
548: gmi_reservation_util.println('Value of count is '||p_mo_line_TBL.COUNT);
549:
550: gmi_reservation_util.println('Value of ship_Set id is '|| l_mo_line_rec.ship_set_id);
551: gmi_reservation_util.println('Value of l_mo_line_rec.quantity_detailed is '||l_mo_line_rec.quantity_Detailed);
552: IF (l_mo_line_rec.ship_set_id IS NOT NULL ) THEN
553: check_ship_set
554: (
547: IF ( l_manual_pick = 'N') THEN
548: gmi_reservation_util.println('Value of count is '||p_mo_line_TBL.COUNT);
549:
550: gmi_reservation_util.println('Value of ship_Set id is '|| l_mo_line_rec.ship_set_id);
551: gmi_reservation_util.println('Value of l_mo_line_rec.quantity_detailed is '||l_mo_line_rec.quantity_Detailed);
552: IF (l_mo_line_rec.ship_set_id IS NOT NULL ) THEN
553: check_ship_set
554: (
555: p_ship_set_id => l_mo_line_rec.ship_set_id
576:
577: -- HW BUG#:2296620
578: IF ( l_no_error = '1' ) THEN
579:
580: gmi_reservation_util.println('Going to pick confirm');
581:
582:
583: /* Need To check The Value Of detailed_qty */
584: /* And quantity_delivered. */
592: raise FND_API.G_EXC_ERROR;
593: END IF; */
594:
595: /* Get Process Item details */
596: GMI_RESERVATION_UTIL.Get_OPM_item_from_Apps
597: (
598: p_organization_id => l_mo_line_rec.organization_id
599: , p_inventory_item_id => l_mo_line_rec.inventory_item_id
600: , x_ic_item_mst_rec => l_ic_item_mst_rec
604:
605: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
606: THEN
607: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
608: FND_MESSAGE.SET_TOKEN('BY_PROC','GMI_Reservation_Util.Get_OPM_item_from_Apps');
609: FND_MESSAGE.SET_TOKEN('WHERE',G_PKG_NAME||'.'||l_api_name);
610: RAISE FND_API.G_EXC_ERROR;
611: END IF;
612:
609: FND_MESSAGE.SET_TOKEN('WHERE',G_PKG_NAME||'.'||l_api_name);
610: RAISE FND_API.G_EXC_ERROR;
611: END IF;
612:
613: GMI_Reservation_Util.PrintLn('Item Found. Now Qty treatment');
614: /* Now Check Item Characteristics */
615: /* HAM Does this logic cover all cases */
616: /* What about loct_ctl=1 and lot_ctl=0 or visa versa. */
617: /* Set quantity Fields to 0; */
621: Open get_whse_code;
622: Fetch get_whse_code into l_whse_code, l_whse_ctl;
623: Close get_whse_code;
624:
625: GMI_Reservation_Util.PrintLn('Item : lot_ctl='||l_ic_item_mst_rec.lot_ctl||', loct_ctl='||l_ic_item_mst_rec.loct_ctl);
626: IF ( l_ic_item_mst_rec.lot_ctl <> 0 ) OR ( l_ic_item_mst_rec.loct_ctl * l_whse_ctl<> 0)
627: THEN
628: l_default_transaction :=0; /* Do not Transact default Lot. */
629: /* get status ctl */
639:
640: FETCH cur_txn_no_default INTO l_trans_qty, l_trans_qty2;
641: IF cur_txn_no_default%NOTFOUND THEN
642: CLOSE cur_txn_no_default;
643: GMI_Reservation_Util.PrintLn('txn_no_default : NOTFOUND ');
644: FND_MESSAGE.SET_NAME('GMI','GMI_REQUIRED_MISSING');
645: RAISE FND_API.G_EXC_ERROR;
646: END IF;
647: CLOSE cur_txn_no_default;
647: CLOSE cur_txn_no_default;
648: l_trans_qty_sts := l_trans_qty;
649: l_trans_qty2_sts := l_trans_qty2;
650: IF nvl(l_status_ctl, 0) <> 0 THEN -- status ctl
651: GMI_Reservation_Util.PrintLn('status controled');
652: OPEN cur_txn_no_dflt_sts
653: ( p_line_id => l_mo_line_rec.txn_source_line_id,
654: p_item_id => l_ic_item_mst_rec.item_id,
655: p_mo_line_id => l_mo_line_rec.line_id
657:
658: FETCH cur_txn_no_dflt_sts INTO l_trans_qty, l_trans_qty2; -- this portion would be transacted
659: IF cur_txn_no_dflt_sts%NOTFOUND THEN
660: CLOSE cur_txn_no_dflt_sts;
661: GMI_Reservation_Util.PrintLn('txn_no_default : NOTFOUND ');
662: FND_MESSAGE.SET_NAME('GMI','GMI_REQUIRED_MISSING');
663: END IF;
664: CLOSE cur_txn_no_dflt_sts;
665: GMI_Reservation_Util.PrintLn('trans_qty '||l_trans_qty ||' trans_qty2 '||l_trans_qty2 );
661: GMI_Reservation_Util.PrintLn('txn_no_default : NOTFOUND ');
662: FND_MESSAGE.SET_NAME('GMI','GMI_REQUIRED_MISSING');
663: END IF;
664: CLOSE cur_txn_no_dflt_sts;
665: GMI_Reservation_Util.PrintLn('trans_qty '||l_trans_qty ||' trans_qty2 '||l_trans_qty2 );
666: END IF;
667: ELSE /* not lot controled or location controled */
668: l_default_transaction :=1; /* Transact default Lot. */
669: /* Get TXN Quantities */
673: );
674: FETCH check_default_lot into l_msg_count;
675: CLOSE check_default_lot;
676: IF l_msg_count = 0 THEN
677: GMI_Reservation_Util.PrintLn('txn_with_default : NOTFOUND ');
678: /* if default is not found at this stage, user should still able to transact */
679: /* the so line with the full qty*/
680: /* this is also true for non inventory controled items*/
681: /* the move order qtys are already in item_um1 and item_um2*/
682: l_trans_qty := l_mo_line_rec.quantity;
683: l_trans_qty2 := l_mo_line_rec.secondary_quantity;
684: /*RAISE FND_API.G_EXC_ERROR; */
685: /* create a default lot to avoid troubles in shipping */
686: GMI_RESERVATION_UTIL.Create_dflt_lot_from_scratch
687: (
688: p_whse_code => l_whse_code
689: , p_line_id => l_mo_line_rec.txn_source_line_id
690: , p_item_id => l_ic_item_mst_rec.item_id
696: );
697: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
698: THEN
699: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
700: FND_MESSAGE.SET_TOKEN('BY_PROC','GMI_Reservation_Util.create_dflt_lot_from_scratch');
701: FND_MESSAGE.SET_TOKEN('WHERE',G_PKG_NAME||'.'||l_api_name);
702: RAISE FND_API.G_EXC_ERROR;
703: END IF;
704: ELSE
711: END IF;
712: END IF;
713:
714: /* Now Set delivered Quantities */
715: GMI_Reservation_Util.PrintLn('Now Set the delivered Quantities');
716: l_mo_line_rec.quantity_delivered := NVL(l_mo_line_rec.quantity_delivered,0)
717: + NVL(l_trans_qty,0);
718:
719: /* Ham May Need To Add Logic To Save As NULL not 0 */
731: /* If default Lot is really the actual lot */
732: /* Then unless you pick confirm everything */
733: /* Then throw an ERROR: */
734:
735: GMI_Reservation_Util.PrintLn('default_transaction='||l_default_transaction);
736: GMI_Reservation_Util.PrintLn('qty_delivered='||l_mo_line_rec.quantity_delivered||', qty_delivered2='||l_mo_line_rec.secondary_quantity_delivered);
737: GMI_Reservation_Util.PrintLn('qty='||l_mo_line_rec.quantity);
738:
739: /* Set Status Of Mo_line_rec To Closed if Fully delivered */
732: /* Then unless you pick confirm everything */
733: /* Then throw an ERROR: */
734:
735: GMI_Reservation_Util.PrintLn('default_transaction='||l_default_transaction);
736: GMI_Reservation_Util.PrintLn('qty_delivered='||l_mo_line_rec.quantity_delivered||', qty_delivered2='||l_mo_line_rec.secondary_quantity_delivered);
737: GMI_Reservation_Util.PrintLn('qty='||l_mo_line_rec.quantity);
738:
739: /* Set Status Of Mo_line_rec To Closed if Fully delivered */
740: /* requsted qty . */
733: /* Then throw an ERROR: */
734:
735: GMI_Reservation_Util.PrintLn('default_transaction='||l_default_transaction);
736: GMI_Reservation_Util.PrintLn('qty_delivered='||l_mo_line_rec.quantity_delivered||', qty_delivered2='||l_mo_line_rec.secondary_quantity_delivered);
737: GMI_Reservation_Util.PrintLn('qty='||l_mo_line_rec.quantity);
738:
739: /* Set Status Of Mo_line_rec To Closed if Fully delivered */
740: /* requsted qty . */
741:
760: fnd_message.set_name('INV', 'INV_CHECK_TOLERANCE_ERROR');
761: RAISE FND_API.G_EXC_ERROR;
762: ELSE
763: IF l_allowed = 'N' THEN
764: GMI_Reservation_Util.PrintLn('ATTENTION :');
765: GMI_Reservation_Util.PrintLn('MOVE ORDER line : line_id ='||l_mo_line_rec.line_id ||
766: ' can not be transacted because picked qty exceeds over shippment tolerance. '||
767: ' The allocated quantity is '|| l_trans_qty ||' but the max allowed quantity is'||
768: l_max_qty || ' Please reduce allocation quantity ');
761: RAISE FND_API.G_EXC_ERROR;
762: ELSE
763: IF l_allowed = 'N' THEN
764: GMI_Reservation_Util.PrintLn('ATTENTION :');
765: GMI_Reservation_Util.PrintLn('MOVE ORDER line : line_id ='||l_mo_line_rec.line_id ||
766: ' can not be transacted because picked qty exceeds over shippment tolerance. '||
767: ' The allocated quantity is '|| l_trans_qty ||' but the max allowed quantity is'||
768: l_max_qty || ' Please reduce allocation quantity ');
769:
787: l_mo_line_rec.line_status :=5;
788: END IF;
789:
790: /* Update Move Order Line record */
791: GMI_Reservation_Util.PrintLn('Now, update the MO row');
792: GMI_MOVE_ORDER_LINE_UTIL.Update_ROW(p_mo_line_rec => l_mo_line_rec);
793:
794:
795: /* Bug 2499153 */
799: OPEN check_wsh;
800: FETCH check_wsh INTO OM_G_installed;
801: IF (check_wsh%NOTFOUND) THEN
802: OM_G_installed := NULL;
803: GMI_Reservation_Util.PrintLn('OM_G_installed not found');
804: END IF;
805: GMI_Reservation_Util.PrintLn('OM_G_installed ' || OM_G_installed);
806: CLOSE check_wsh;
807:
801: IF (check_wsh%NOTFOUND) THEN
802: OM_G_installed := NULL;
803: GMI_Reservation_Util.PrintLn('OM_G_installed not found');
804: END IF;
805: GMI_Reservation_Util.PrintLn('OM_G_installed ' || OM_G_installed);
806: CLOSE check_wsh;
807:
808: /* Set Up status Flag */
809: if (l_mo_line_rec.quantity_delivered < l_mo_line_rec.quantity )
828: end if;
829: end if;
830: END IF;
831:
832: GMI_Reservation_Util.PrintLn('Action Flag is '||l_action_flag);
833: /* Save The SUM Of the transaction QTY's This May Be Used */
834: /* Further In The Code ...... */
835:
836: l_sum_trans_qty := l_trans_qty;
836: l_sum_trans_qty := l_trans_qty;
837: l_sum_trans_qty2 := l_trans_qty2;
838:
839: /* Now Let Build shipping API record */
840: GMI_Reservation_Util.PrintLn('Now, Let us Build shipping API record');
841: /* Maybe i should set context switch to get correct Org. */
842:
843: -- Bug 1805216, added NOT NULL in the cursor.
844: /*SELECT a.delivery_detail_id, a.oe_header_id, a.oe_line_id
869: --
870: -- Bug 3776538 - Transaction quantities should be truncated to 5 decimals upfront
871: --
872: l_ALLOW_OPM_TRUNCATE_TXN := nvl(fnd_profile.value ('ALLOW_OPM_TRUNCATE_TXN'),'N');
873: GMI_Reservation_Util.PrintLn('(GMIVPWCB)Profile: ALLOW_OPM_TRUNCATE_TXN '||l_ALLOW_OPM_TRUNCATE_TXN);
874: IF (l_ALLOW_OPM_TRUNCATE_TXN = 'Y') THEN
875: GMI_Reservation_Util.PrintLn('Truncating the transaction quantities before TRANSACT');
876: l_return_status := FND_API.G_RET_STS_SUCCESS;
877: truncate_trans_qty (p_line_id => l_mo_line_rec.txn_source_line_id,
871: --
872: l_ALLOW_OPM_TRUNCATE_TXN := nvl(fnd_profile.value ('ALLOW_OPM_TRUNCATE_TXN'),'N');
873: GMI_Reservation_Util.PrintLn('(GMIVPWCB)Profile: ALLOW_OPM_TRUNCATE_TXN '||l_ALLOW_OPM_TRUNCATE_TXN);
874: IF (l_ALLOW_OPM_TRUNCATE_TXN = 'Y') THEN
875: GMI_Reservation_Util.PrintLn('Truncating the transaction quantities before TRANSACT');
876: l_return_status := FND_API.G_RET_STS_SUCCESS;
877: truncate_trans_qty (p_line_id => l_mo_line_rec.txn_source_line_id,
878: p_delivery_detail_id => l_delivery_detail_id,
879: p_default_location => l_location,
883: -- Fail the pick confirm process if exception occured during truncation of transactions
884: --
885: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
886: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
887: FND_MESSAGE.SET_TOKEN('BY_PROC','GMI_Reservation_Util.truncate_trans_qty');
888: FND_MESSAGE.SET_TOKEN('WHERE',G_PKG_NAME||'.'||l_api_name);
889: RAISE FND_API.G_EXC_ERROR;
890: END IF;
891: END IF;
899: l_trans_qty := l_sum_trans_qty;
900: l_trans_qty2 := l_sum_trans_qty2;
901: l_trans_qty_sts := l_trans_qty;
902: l_trans_qty2_sts := l_trans_qty2;
903: gmi_reservation_util.println('qty_sum_for_del l_trans_qty '||l_trans_qty);
904: gmi_reservation_util.println('qty_sum_for_del l_trans_qty2 '||l_trans_qty2);
905:
906: l_backorder_del := 0;
907: IF nvl(l_status_ctl, 0) <> 0 THEN -- status ctl
900: l_trans_qty2 := l_sum_trans_qty2;
901: l_trans_qty_sts := l_trans_qty;
902: l_trans_qty2_sts := l_trans_qty2;
903: gmi_reservation_util.println('qty_sum_for_del l_trans_qty '||l_trans_qty);
904: gmi_reservation_util.println('qty_sum_for_del l_trans_qty2 '||l_trans_qty2);
905:
906: l_backorder_del := 0;
907: IF nvl(l_status_ctl, 0) <> 0 THEN -- status ctl
908: Open qty_sum_for_del_sts;
909: Fetch qty_sum_for_del_sts INTO l_sum_trans_qty, l_sum_trans_qty2;
910: Close qty_sum_for_del_sts ;
911: l_trans_qty := nvl(l_sum_trans_qty,0);
912: l_trans_qty2 := nvl(l_sum_trans_qty2,0);
913: gmi_reservation_util.println('qty_sum_for_del_sts l_trans_qty '||l_trans_qty);
914: gmi_reservation_util.println('qty_sum_for_del_sts l_trans_qty2 '||l_trans_qty2);
915: IF (l_trans_qty_sts > l_trans_qty ) THEN -- lots allocated, but may not be transactable
916: gmi_reservation_util.println('lots allocated, but may not be transactable ');
917: l_backorder_del := 1;
910: Close qty_sum_for_del_sts ;
911: l_trans_qty := nvl(l_sum_trans_qty,0);
912: l_trans_qty2 := nvl(l_sum_trans_qty2,0);
913: gmi_reservation_util.println('qty_sum_for_del_sts l_trans_qty '||l_trans_qty);
914: gmi_reservation_util.println('qty_sum_for_del_sts l_trans_qty2 '||l_trans_qty2);
915: IF (l_trans_qty_sts > l_trans_qty ) THEN -- lots allocated, but may not be transactable
916: gmi_reservation_util.println('lots allocated, but may not be transactable ');
917: l_backorder_del := 1;
918: END IF;
912: l_trans_qty2 := nvl(l_sum_trans_qty2,0);
913: gmi_reservation_util.println('qty_sum_for_del_sts l_trans_qty '||l_trans_qty);
914: gmi_reservation_util.println('qty_sum_for_del_sts l_trans_qty2 '||l_trans_qty2);
915: IF (l_trans_qty_sts > l_trans_qty ) THEN -- lots allocated, but may not be transactable
916: gmi_reservation_util.println('lots allocated, but may not be transactable ');
917: l_backorder_del := 1;
918: END IF;
919: END IF;
920: END IF;
924: l_shipping_attr(1).subinventory := l_mo_line_rec.to_subinventory_code;
925: l_shipping_attr(1).released_status := 'Y';
926: l_shipping_attr(1).delivery_detail_id := l_delivery_detail_id;
927:
928: GMI_Reservation_Util.PrintLn('Shipping Values : source_header_id='||l_shipping_attr(1).source_header_id);
929: GMI_Reservation_Util.PrintLn('Shipping Values : source_line_id='||l_shipping_attr(1).source_line_id);
930: GMI_Reservation_Util.PrintLn('Shipping Values : delivery_detail_id='||l_shipping_attr(1).delivery_detail_id);
931:
932: l_shipping_attr(1).preferred_grade := l_mo_line_rec.qc_grade;
925: l_shipping_attr(1).released_status := 'Y';
926: l_shipping_attr(1).delivery_detail_id := l_delivery_detail_id;
927:
928: GMI_Reservation_Util.PrintLn('Shipping Values : source_header_id='||l_shipping_attr(1).source_header_id);
929: GMI_Reservation_Util.PrintLn('Shipping Values : source_line_id='||l_shipping_attr(1).source_line_id);
930: GMI_Reservation_Util.PrintLn('Shipping Values : delivery_detail_id='||l_shipping_attr(1).delivery_detail_id);
931:
932: l_shipping_attr(1).preferred_grade := l_mo_line_rec.qc_grade;
933: l_shipping_attr(1).lot_number := NULL;
926: l_shipping_attr(1).delivery_detail_id := l_delivery_detail_id;
927:
928: GMI_Reservation_Util.PrintLn('Shipping Values : source_header_id='||l_shipping_attr(1).source_header_id);
929: GMI_Reservation_Util.PrintLn('Shipping Values : source_line_id='||l_shipping_attr(1).source_line_id);
930: GMI_Reservation_Util.PrintLn('Shipping Values : delivery_detail_id='||l_shipping_attr(1).delivery_detail_id);
931:
932: l_shipping_attr(1).preferred_grade := l_mo_line_rec.qc_grade;
933: l_shipping_attr(1).lot_number := NULL;
934: -- l_shipping_attr(1).sublot_number := NULL; /*Commented for R12. P1 Bug#4561095 */
936: l_shipping_attr(1).ship_from_org_id := l_mo_line_rec.organization_id;
937: l_shipping_attr(1).action_flag := l_action_flag;
938:
939: IF l_default_transaction = 0 THEN /* lot or loct controled */
940: GMI_Reservation_Util.PrintLn('before getting transaction, line_id='||l_mo_line_rec.txn_source_line_id
941: ||', location='||l_location||', item_id='||l_ic_item_mst_rec.item_id);
942: OPEN mo_line_txn_c ( p_line_id => l_mo_line_rec.txn_source_line_id,
943: p_location => l_location,
944: p_item_id => l_ic_item_mst_rec.item_id,
943: p_location => l_location,
944: p_item_id => l_ic_item_mst_rec.item_id,
945: p_delivery_detail_id =>l_delivery_detail_id
946: );
947: GMI_Reservation_Util.PrintLn('After Call to mo_line_txn_c');
948:
949:
950: /* Bug2621228 - Following assignments made */
951: l_sum_trans_qty := GREATEST (l_sum_trans_qty, l_requested_qty);
956: LOOP
957: FETCH mo_line_txn_c into l_mo_line_txn_rec;
958: EXIT when mo_line_txn_c%NOTFOUND;
959:
960: GMI_Reservation_Util.PrintLn('a transaction is found : trans_id='||l_mo_line_txn_rec.trans_id);
961:
962: GMI_Reservation_Util.PrintLn('Trans id = '||l_mo_line_txn_rec.trans_id);
963: GMI_Reservation_Util.PrintLn('lot_no = '||l_mo_line_txn_rec.lot_no);
964: GMI_Reservation_Util.PrintLn('lot_id = '||l_mo_line_txn_rec.lot_id);
958: EXIT when mo_line_txn_c%NOTFOUND;
959:
960: GMI_Reservation_Util.PrintLn('a transaction is found : trans_id='||l_mo_line_txn_rec.trans_id);
961:
962: GMI_Reservation_Util.PrintLn('Trans id = '||l_mo_line_txn_rec.trans_id);
963: GMI_Reservation_Util.PrintLn('lot_no = '||l_mo_line_txn_rec.lot_no);
964: GMI_Reservation_Util.PrintLn('lot_id = '||l_mo_line_txn_rec.lot_id);
965: GMI_Reservation_Util.PrintLn('sublot_no= '||l_mo_line_txn_rec.sublot_no);
966: GMI_Reservation_Util.PrintLn('Grade = '||l_mo_line_txn_rec.qc_grade);
959:
960: GMI_Reservation_Util.PrintLn('a transaction is found : trans_id='||l_mo_line_txn_rec.trans_id);
961:
962: GMI_Reservation_Util.PrintLn('Trans id = '||l_mo_line_txn_rec.trans_id);
963: GMI_Reservation_Util.PrintLn('lot_no = '||l_mo_line_txn_rec.lot_no);
964: GMI_Reservation_Util.PrintLn('lot_id = '||l_mo_line_txn_rec.lot_id);
965: GMI_Reservation_Util.PrintLn('sublot_no= '||l_mo_line_txn_rec.sublot_no);
966: GMI_Reservation_Util.PrintLn('Grade = '||l_mo_line_txn_rec.qc_grade);
967: GMI_Reservation_Util.PrintLn('trans_qty= '||l_mo_line_txn_rec.trans_qty);
960: GMI_Reservation_Util.PrintLn('a transaction is found : trans_id='||l_mo_line_txn_rec.trans_id);
961:
962: GMI_Reservation_Util.PrintLn('Trans id = '||l_mo_line_txn_rec.trans_id);
963: GMI_Reservation_Util.PrintLn('lot_no = '||l_mo_line_txn_rec.lot_no);
964: GMI_Reservation_Util.PrintLn('lot_id = '||l_mo_line_txn_rec.lot_id);
965: GMI_Reservation_Util.PrintLn('sublot_no= '||l_mo_line_txn_rec.sublot_no);
966: GMI_Reservation_Util.PrintLn('Grade = '||l_mo_line_txn_rec.qc_grade);
967: GMI_Reservation_Util.PrintLn('trans_qty= '||l_mo_line_txn_rec.trans_qty);
968: GMI_Reservation_Util.PrintLn('qty2 = '||l_mo_line_txn_rec.trans_qty2);
961:
962: GMI_Reservation_Util.PrintLn('Trans id = '||l_mo_line_txn_rec.trans_id);
963: GMI_Reservation_Util.PrintLn('lot_no = '||l_mo_line_txn_rec.lot_no);
964: GMI_Reservation_Util.PrintLn('lot_id = '||l_mo_line_txn_rec.lot_id);
965: GMI_Reservation_Util.PrintLn('sublot_no= '||l_mo_line_txn_rec.sublot_no);
966: GMI_Reservation_Util.PrintLn('Grade = '||l_mo_line_txn_rec.qc_grade);
967: GMI_Reservation_Util.PrintLn('trans_qty= '||l_mo_line_txn_rec.trans_qty);
968: GMI_Reservation_Util.PrintLn('qty2 = '||l_mo_line_txn_rec.trans_qty2);
969: GMI_Reservation_Util.PrintLn('locator = '||l_mo_line_txn_rec.locator_id);
962: GMI_Reservation_Util.PrintLn('Trans id = '||l_mo_line_txn_rec.trans_id);
963: GMI_Reservation_Util.PrintLn('lot_no = '||l_mo_line_txn_rec.lot_no);
964: GMI_Reservation_Util.PrintLn('lot_id = '||l_mo_line_txn_rec.lot_id);
965: GMI_Reservation_Util.PrintLn('sublot_no= '||l_mo_line_txn_rec.sublot_no);
966: GMI_Reservation_Util.PrintLn('Grade = '||l_mo_line_txn_rec.qc_grade);
967: GMI_Reservation_Util.PrintLn('trans_qty= '||l_mo_line_txn_rec.trans_qty);
968: GMI_Reservation_Util.PrintLn('qty2 = '||l_mo_line_txn_rec.trans_qty2);
969: GMI_Reservation_Util.PrintLn('locator = '||l_mo_line_txn_rec.locator_id);
970: /* check the status to see it is transactable */
963: GMI_Reservation_Util.PrintLn('lot_no = '||l_mo_line_txn_rec.lot_no);
964: GMI_Reservation_Util.PrintLn('lot_id = '||l_mo_line_txn_rec.lot_id);
965: GMI_Reservation_Util.PrintLn('sublot_no= '||l_mo_line_txn_rec.sublot_no);
966: GMI_Reservation_Util.PrintLn('Grade = '||l_mo_line_txn_rec.qc_grade);
967: GMI_Reservation_Util.PrintLn('trans_qty= '||l_mo_line_txn_rec.trans_qty);
968: GMI_Reservation_Util.PrintLn('qty2 = '||l_mo_line_txn_rec.trans_qty2);
969: GMI_Reservation_Util.PrintLn('locator = '||l_mo_line_txn_rec.locator_id);
970: /* check the status to see it is transactable */
971: GMI_Reservation_Util.PrintLn('check status = '||l_mo_line_txn_rec.locator_id);
964: GMI_Reservation_Util.PrintLn('lot_id = '||l_mo_line_txn_rec.lot_id);
965: GMI_Reservation_Util.PrintLn('sublot_no= '||l_mo_line_txn_rec.sublot_no);
966: GMI_Reservation_Util.PrintLn('Grade = '||l_mo_line_txn_rec.qc_grade);
967: GMI_Reservation_Util.PrintLn('trans_qty= '||l_mo_line_txn_rec.trans_qty);
968: GMI_Reservation_Util.PrintLn('qty2 = '||l_mo_line_txn_rec.trans_qty2);
969: GMI_Reservation_Util.PrintLn('locator = '||l_mo_line_txn_rec.locator_id);
970: /* check the status to see it is transactable */
971: GMI_Reservation_Util.PrintLn('check status = '||l_mo_line_txn_rec.locator_id);
972: /* for non status ctl item, no check */
965: GMI_Reservation_Util.PrintLn('sublot_no= '||l_mo_line_txn_rec.sublot_no);
966: GMI_Reservation_Util.PrintLn('Grade = '||l_mo_line_txn_rec.qc_grade);
967: GMI_Reservation_Util.PrintLn('trans_qty= '||l_mo_line_txn_rec.trans_qty);
968: GMI_Reservation_Util.PrintLn('qty2 = '||l_mo_line_txn_rec.trans_qty2);
969: GMI_Reservation_Util.PrintLn('locator = '||l_mo_line_txn_rec.locator_id);
970: /* check the status to see it is transactable */
971: GMI_Reservation_Util.PrintLn('check status = '||l_mo_line_txn_rec.locator_id);
972: /* for non status ctl item, no check */
973: l_orderable_ind := 1;
967: GMI_Reservation_Util.PrintLn('trans_qty= '||l_mo_line_txn_rec.trans_qty);
968: GMI_Reservation_Util.PrintLn('qty2 = '||l_mo_line_txn_rec.trans_qty2);
969: GMI_Reservation_Util.PrintLn('locator = '||l_mo_line_txn_rec.locator_id);
970: /* check the status to see it is transactable */
971: GMI_Reservation_Util.PrintLn('check status = '||l_mo_line_txn_rec.locator_id);
972: /* for non status ctl item, no check */
973: l_orderable_ind := 1;
974: l_shipable_ind := 1;
975: IF nvl(l_status_ctl,0) <> 0 THEN
982: Fetch check_lot_sts INTO l_orderable_ind, l_shipable_ind;
983: Close check_lot_sts;
984: END IF;
985:
986: GMI_Reservation_Util.PrintLn('orderable status ind : '||l_orderable_ind);
987: GMI_Reservation_Util.PrintLn('shipable status ind : '||l_shipable_ind);
988:
989: -- Begin Bug 3609713
990: GMI_Reservation_Util.PrintLn(' Lot_ctl '||l_ic_item_mst_rec.lot_ctl);
983: Close check_lot_sts;
984: END IF;
985:
986: GMI_Reservation_Util.PrintLn('orderable status ind : '||l_orderable_ind);
987: GMI_Reservation_Util.PrintLn('shipable status ind : '||l_shipable_ind);
988:
989: -- Begin Bug 3609713
990: GMI_Reservation_Util.PrintLn(' Lot_ctl '||l_ic_item_mst_rec.lot_ctl);
991: GMI_Reservation_Util.PrintLn(' Allow negative Inventory : '||l_allowneginv);
986: GMI_Reservation_Util.PrintLn('orderable status ind : '||l_orderable_ind);
987: GMI_Reservation_Util.PrintLn('shipable status ind : '||l_shipable_ind);
988:
989: -- Begin Bug 3609713
990: GMI_Reservation_Util.PrintLn(' Lot_ctl '||l_ic_item_mst_rec.lot_ctl);
991: GMI_Reservation_Util.PrintLn(' Allow negative Inventory : '||l_allowneginv);
992:
993: -- Bug 3859774
994: -- If inventory is not allowed to go -ve and the lots are shippable!
987: GMI_Reservation_Util.PrintLn('shipable status ind : '||l_shipable_ind);
988:
989: -- Begin Bug 3609713
990: GMI_Reservation_Util.PrintLn(' Lot_ctl '||l_ic_item_mst_rec.lot_ctl);
991: GMI_Reservation_Util.PrintLn(' Allow negative Inventory : '||l_allowneginv);
992:
993: -- Bug 3859774
994: -- If inventory is not allowed to go -ve and the lots are shippable!
995: --
1005: l_onhand1 := 0;
1006: l_onhand2 := 0;
1007: END IF;
1008: CLOSE check_onhand_qty;
1009: GMI_Reservation_Util.PrintLn('Onhand for lot : '||l_onhand1);
1010: GMI_Reservation_Util.PrintLn('Onhand2 for lot : '||l_onhand2);
1011:
1012: OPEN check_staged(
1013: p_item_id => l_ic_item_mst_rec.item_id,
1006: l_onhand2 := 0;
1007: END IF;
1008: CLOSE check_onhand_qty;
1009: GMI_Reservation_Util.PrintLn('Onhand for lot : '||l_onhand1);
1010: GMI_Reservation_Util.PrintLn('Onhand2 for lot : '||l_onhand2);
1011:
1012: OPEN check_staged(
1013: p_item_id => l_ic_item_mst_rec.item_id,
1014: p_whse_code => l_whse_code,
1016: p_location => l_mo_line_txn_rec.location
1017: );
1018: FETCH check_staged INTO l_alloc1, l_alloc2;
1019: CLOSE check_staged;
1020: GMI_Reservation_Util.PrintLn('allocated for lot : '||l_alloc1);
1021: GMI_Reservation_Util.PrintLn('allocated2 for lot : '||l_alloc2);
1022: -- Bug 3859774
1023: -- ONLY primary allocations should be compared with primary available.
1024: --
1017: );
1018: FETCH check_staged INTO l_alloc1, l_alloc2;
1019: CLOSE check_staged;
1020: GMI_Reservation_Util.PrintLn('allocated for lot : '||l_alloc1);
1021: GMI_Reservation_Util.PrintLn('allocated2 for lot : '||l_alloc2);
1022: -- Bug 3859774
1023: -- ONLY primary allocations should be compared with primary available.
1024: --
1025: IF ((l_onhand1 + l_alloc1) < ABS(l_mo_line_txn_rec.trans_qty)) THEN
1022: -- Bug 3859774
1023: -- ONLY primary allocations should be compared with primary available.
1024: --
1025: IF ((l_onhand1 + l_alloc1) < ABS(l_mo_line_txn_rec.trans_qty)) THEN
1026: GMI_Reservation_Util.PrintLn(' Inventory checked : Going negative !');
1027: l_inv_negative := 1;
1028: ELSE
1029: GMI_Reservation_Util.PrintLn(' Inventory checked : Not going negative ');
1030: l_inv_negative := 0;
1025: IF ((l_onhand1 + l_alloc1) < ABS(l_mo_line_txn_rec.trans_qty)) THEN
1026: GMI_Reservation_Util.PrintLn(' Inventory checked : Going negative !');
1027: l_inv_negative := 1;
1028: ELSE
1029: GMI_Reservation_Util.PrintLn(' Inventory checked : Not going negative ');
1030: l_inv_negative := 0;
1031: END IF;
1032: ELSE -- of (l_allowneginv <> 1 AND nvl(l_shipable_ind, 0) <> 0)
1033: GMI_Reservation_Util.PrintLn(' Item Not lot controlled or Negative inventory Allowed OR ... ');
1029: GMI_Reservation_Util.PrintLn(' Inventory checked : Not going negative ');
1030: l_inv_negative := 0;
1031: END IF;
1032: ELSE -- of (l_allowneginv <> 1 AND nvl(l_shipable_ind, 0) <> 0)
1033: GMI_Reservation_Util.PrintLn(' Item Not lot controlled or Negative inventory Allowed OR ... ');
1034: GMI_Reservation_Util.PrintLn(' ... Negative Inventory not checked since lot is not shipable ');
1035: l_inv_negative := 0;
1036: END IF;
1037:
1030: l_inv_negative := 0;
1031: END IF;
1032: ELSE -- of (l_allowneginv <> 1 AND nvl(l_shipable_ind, 0) <> 0)
1033: GMI_Reservation_Util.PrintLn(' Item Not lot controlled or Negative inventory Allowed OR ... ');
1034: GMI_Reservation_Util.PrintLn(' ... Negative Inventory not checked since lot is not shipable ');
1035: l_inv_negative := 0;
1036: END IF;
1037:
1038: IF (( nvl(l_shipable_ind, 0)) <> 0
1049: l_return_status := '';
1050: l_shipping_attr(1).ordered_quantity := l_mo_line_txn_rec.trans_qty;
1051: l_shipping_attr(1).ordered_quantity2 := l_mo_line_txn_rec.trans_qty2;
1052:
1053: GMI_Reservation_Util.PrintLn('total trans qty = '||l_trans_qty);
1054: GMI_Reservation_Util.PrintLn('total requested qty = '||l_requested_qty);
1055:
1056:
1057: /* overpicking changes */
1050: l_shipping_attr(1).ordered_quantity := l_mo_line_txn_rec.trans_qty;
1051: l_shipping_attr(1).ordered_quantity2 := l_mo_line_txn_rec.trans_qty2;
1052:
1053: GMI_Reservation_Util.PrintLn('total trans qty = '||l_trans_qty);
1054: GMI_Reservation_Util.PrintLn('total requested qty = '||l_requested_qty);
1055:
1056:
1057: /* overpicking changes */
1058: /* Bug 2621228 - Logic below is changed to populate picked/pending quantity in post G scenario */
1076:
1077: /* End bug 2621228 */
1078: /* end of over pick */
1079:
1080: GMI_Reservation_Util.PrintLn('Before Calling the Update_Shipping_Attributes trans_id='||l_mo_line_txn_rec.trans_id);
1081:
1082: -- Bug 3776538
1083: dump_shp_attrb_data(p_shipping_attr => l_shipping_attr);
1084:
1086: (p_source_code => 'INV',
1087: p_changed_attributes => l_shipping_attr,
1088: x_return_status => l_return_status
1089: );
1090: GMI_Reservation_Util.PrintLn('Return Status from [1] Update_Shipping_Attributes Call '||l_return_status);
1091:
1092: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1093: THEN
1094: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
1091:
1092: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1093: THEN
1094: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
1095: FND_MESSAGE.SET_TOKEN('BY_PROC','GMI_Reservation_Util.call_to_WSH_interface');
1096: FND_MESSAGE.SET_TOKEN('WHERE',G_PKG_NAME||'.'||l_api_name);
1097: RAISE FND_API.G_EXC_ERROR;
1098: END IF;
1099:
1113: /* Setting the pick slip number - Bug2455422 */
1114:
1115: GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip (l_mo_line_rec.organization_id , l_mo_line_rec.line_id,
1116: x_return_status, x_msg_count, x_msg_data, l_pick_slip_number);
1117: GMI_reservation_Util.PrintLn('pick slip number is '|| l_pick_slip_number);
1118:
1119: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1120: THEN
1121: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_lots: Error returned by GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip.', 'pick_lots.log');
1117: GMI_reservation_Util.PrintLn('pick slip number is '|| l_pick_slip_number);
1118:
1119: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1120: THEN
1121: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_lots: Error returned by GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip.', 'pick_lots.log');
1122: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
1123: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip');
1124: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
1125: FND_MSG_PUB.Add;
1132:
1133: /* End of Setting the pick slip number - Bug2455422 */
1134:
1135:
1136: GMI_Reservation_Util.PrintLn('Before Loop 1');
1137: -- Begin Bug 3609713
1138: ELSIF (nvl(l_shipable_ind, 0) = 0) THEN
1139: GMI_Reservation_Util.PrintLn('LOTs not transactable for Status ');
1140: l_mo_line_rec.line_status :=7;
1135:
1136: GMI_Reservation_Util.PrintLn('Before Loop 1');
1137: -- Begin Bug 3609713
1138: ELSIF (nvl(l_shipable_ind, 0) = 0) THEN
1139: GMI_Reservation_Util.PrintLn('LOTs not transactable for Status ');
1140: l_mo_line_rec.line_status :=7;
1141: GMI_Reservation_Util.PrintLn('Updating mo line status to OPEN- lot status');
1142: GMI_MOVE_ORDER_LINE_UTIL.Update_ROW(p_mo_line_rec => l_mo_line_rec);
1143: ELSE
1137: -- Begin Bug 3609713
1138: ELSIF (nvl(l_shipable_ind, 0) = 0) THEN
1139: GMI_Reservation_Util.PrintLn('LOTs not transactable for Status ');
1140: l_mo_line_rec.line_status :=7;
1141: GMI_Reservation_Util.PrintLn('Updating mo line status to OPEN- lot status');
1142: GMI_MOVE_ORDER_LINE_UTIL.Update_ROW(p_mo_line_rec => l_mo_line_rec);
1143: ELSE
1144: GMI_Reservation_Util.PrintLn('LOTs not transactable for Negative Inventory ');
1145: l_mo_line_rec.line_status :=7;
1140: l_mo_line_rec.line_status :=7;
1141: GMI_Reservation_Util.PrintLn('Updating mo line status to OPEN- lot status');
1142: GMI_MOVE_ORDER_LINE_UTIL.Update_ROW(p_mo_line_rec => l_mo_line_rec);
1143: ELSE
1144: GMI_Reservation_Util.PrintLn('LOTs not transactable for Negative Inventory ');
1145: l_mo_line_rec.line_status :=7;
1146: l_mo_line_rec.quantity_delivered := NVL(l_mo_line_rec.quantity_delivered,0)
1147: - l_mo_line_txn_rec.trans_qty;
1148: l_mo_line_rec.secondary_quantity_delivered := NVL(l_mo_line_rec.secondary_quantity_delivered, 0)
1147: - l_mo_line_txn_rec.trans_qty;
1148: l_mo_line_rec.secondary_quantity_delivered := NVL(l_mo_line_rec.secondary_quantity_delivered, 0)
1149: - NVL(l_mo_line_txn_rec.trans_qty2,0);
1150:
1151: GMI_Reservation_Util.PrintLn('Updating mo line status to OPEN- Negative Inventory');
1152: GMI_MOVE_ORDER_LINE_UTIL.Update_ROW(p_mo_line_rec => l_mo_line_rec);
1153: -- End Bug 3609713
1154: END IF;
1155: END LOOP;
1157:
1158: /* HW BUG#:1941429OPM cross docking -- find out backorder qtys */
1159: --IF (l_mo_line_rec.quantity_delivered < l_mo_line_rec.quantity ) THEN
1160: /* if picked less, back order */
1161: gmi_reservation_util.println('l_trans_qty '||l_trans_qty);
1162: gmi_reservation_util.println('l_requested_qty '||l_requested_qty);
1163:
1164: -- Bug 3776538
1165: gmi_reservation_util.println('Remaining qty '|| (l_requested_qty - l_trans_qty));
1158: /* HW BUG#:1941429OPM cross docking -- find out backorder qtys */
1159: --IF (l_mo_line_rec.quantity_delivered < l_mo_line_rec.quantity ) THEN
1160: /* if picked less, back order */
1161: gmi_reservation_util.println('l_trans_qty '||l_trans_qty);
1162: gmi_reservation_util.println('l_requested_qty '||l_requested_qty);
1163:
1164: -- Bug 3776538
1165: gmi_reservation_util.println('Remaining qty '|| (l_requested_qty - l_trans_qty));
1166: IF (l_trans_qty < l_requested_qty OR l_backorder_del = 1 ) THEN
1161: gmi_reservation_util.println('l_trans_qty '||l_trans_qty);
1162: gmi_reservation_util.println('l_requested_qty '||l_requested_qty);
1163:
1164: -- Bug 3776538
1165: gmi_reservation_util.println('Remaining qty '|| (l_requested_qty - l_trans_qty));
1166: IF (l_trans_qty < l_requested_qty OR l_backorder_del = 1 ) THEN
1167: gmi_reservation_util.println('Qtys are not same. so need to mark line as a backorder');
1168: gmi_reservation_util.println('Value of l_mo_line_rec.quantity_delivered is '||l_mo_line_rec.quantity_delivered);
1169: gmi_reservation_util.println('Value of l_mo_line_rec.quantity is '||l_mo_line_rec.quantity);
1163:
1164: -- Bug 3776538
1165: gmi_reservation_util.println('Remaining qty '|| (l_requested_qty - l_trans_qty));
1166: IF (l_trans_qty < l_requested_qty OR l_backorder_del = 1 ) THEN
1167: gmi_reservation_util.println('Qtys are not same. so need to mark line as a backorder');
1168: gmi_reservation_util.println('Value of l_mo_line_rec.quantity_delivered is '||l_mo_line_rec.quantity_delivered);
1169: gmi_reservation_util.println('Value of l_mo_line_rec.quantity is '||l_mo_line_rec.quantity);
1170: gmi_reservation_util.println('Value of l_mo_line_rec.status is '||l_mo_line_rec.line_status);
1171: /* find out the remaining delivery */
1164: -- Bug 3776538
1165: gmi_reservation_util.println('Remaining qty '|| (l_requested_qty - l_trans_qty));
1166: IF (l_trans_qty < l_requested_qty OR l_backorder_del = 1 ) THEN
1167: gmi_reservation_util.println('Qtys are not same. so need to mark line as a backorder');
1168: gmi_reservation_util.println('Value of l_mo_line_rec.quantity_delivered is '||l_mo_line_rec.quantity_delivered);
1169: gmi_reservation_util.println('Value of l_mo_line_rec.quantity is '||l_mo_line_rec.quantity);
1170: gmi_reservation_util.println('Value of l_mo_line_rec.status is '||l_mo_line_rec.line_status);
1171: /* find out the remaining delivery */
1172: /* Bug2621228 - l_sum_trans_qty replaced by l_trans_qty */
1165: gmi_reservation_util.println('Remaining qty '|| (l_requested_qty - l_trans_qty));
1166: IF (l_trans_qty < l_requested_qty OR l_backorder_del = 1 ) THEN
1167: gmi_reservation_util.println('Qtys are not same. so need to mark line as a backorder');
1168: gmi_reservation_util.println('Value of l_mo_line_rec.quantity_delivered is '||l_mo_line_rec.quantity_delivered);
1169: gmi_reservation_util.println('Value of l_mo_line_rec.quantity is '||l_mo_line_rec.quantity);
1170: gmi_reservation_util.println('Value of l_mo_line_rec.status is '||l_mo_line_rec.line_status);
1171: /* find out the remaining delivery */
1172: /* Bug2621228 - l_sum_trans_qty replaced by l_trans_qty */
1173: l_backorder_qty := l_requested_qty - l_trans_qty;
1166: IF (l_trans_qty < l_requested_qty OR l_backorder_del = 1 ) THEN
1167: gmi_reservation_util.println('Qtys are not same. so need to mark line as a backorder');
1168: gmi_reservation_util.println('Value of l_mo_line_rec.quantity_delivered is '||l_mo_line_rec.quantity_delivered);
1169: gmi_reservation_util.println('Value of l_mo_line_rec.quantity is '||l_mo_line_rec.quantity);
1170: gmi_reservation_util.println('Value of l_mo_line_rec.status is '||l_mo_line_rec.line_status);
1171: /* find out the remaining delivery */
1172: /* Bug2621228 - l_sum_trans_qty replaced by l_trans_qty */
1173: l_backorder_qty := l_requested_qty - l_trans_qty;
1174: l_backorder_qty2 := l_requested_qty2 - l_trans_qty2;
1171: /* find out the remaining delivery */
1172: /* Bug2621228 - l_sum_trans_qty replaced by l_trans_qty */
1173: l_backorder_qty := l_requested_qty - l_trans_qty;
1174: l_backorder_qty2 := l_requested_qty2 - l_trans_qty2;
1175: GMI_Reservation_Util.PrintLn('backordering in pickconfirm ');
1176: GMI_Reservation_Util.PrintLn('backorder qty = '|| l_backorder_qty);
1177: GMI_Reservation_Util.PrintLn('backorder qty2 = '|| l_backorder_qty2);
1178: l_shipping_attr(1).preferred_grade := NULL;
1179: l_shipping_attr(1).lot_number := NULL;
1172: /* Bug2621228 - l_sum_trans_qty replaced by l_trans_qty */
1173: l_backorder_qty := l_requested_qty - l_trans_qty;
1174: l_backorder_qty2 := l_requested_qty2 - l_trans_qty2;
1175: GMI_Reservation_Util.PrintLn('backordering in pickconfirm ');
1176: GMI_Reservation_Util.PrintLn('backorder qty = '|| l_backorder_qty);
1177: GMI_Reservation_Util.PrintLn('backorder qty2 = '|| l_backorder_qty2);
1178: l_shipping_attr(1).preferred_grade := NULL;
1179: l_shipping_attr(1).lot_number := NULL;
1180: --l_shipping_attr(1).sublot_number := NULL; /* R12 P1 Bug#4561095 */
1173: l_backorder_qty := l_requested_qty - l_trans_qty;
1174: l_backorder_qty2 := l_requested_qty2 - l_trans_qty2;
1175: GMI_Reservation_Util.PrintLn('backordering in pickconfirm ');
1176: GMI_Reservation_Util.PrintLn('backorder qty = '|| l_backorder_qty);
1177: GMI_Reservation_Util.PrintLn('backorder qty2 = '|| l_backorder_qty2);
1178: l_shipping_attr(1).preferred_grade := NULL;
1179: l_shipping_attr(1).lot_number := NULL;
1180: --l_shipping_attr(1).sublot_number := NULL; /* R12 P1 Bug#4561095 */
1181: l_shipping_attr(1).locator_id := NULL;
1184: l_shipping_attr(1).cycle_count_quantity := l_backorder_qty;
1185: l_shipping_attr(1).cycle_count_quantity2 := l_backorder_qty2;
1186: l_shipping_attr(1).released_status := '';
1187: l_shipping_attr(1).delivery_detail_id := l_delivery_detail_id;
1188: GMI_Reservation_Util.PrintLn('backordering Update_Shipping_Attributes delivery_detail_id= '
1189: ||l_delivery_detail_id);
1190:
1191: -- Bug 3776538
1192: dump_shp_attrb_data(p_shipping_attr => l_shipping_attr);
1195: (p_source_code => 'INV',
1196: p_changed_attributes => l_shipping_attr,
1197: x_return_status => l_return_status
1198: );
1199: GMI_Reservation_Util.PrintLn('Return Status from [2] Update_Shipping_Attributes Call '||l_return_status);
1200:
1201: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1202: THEN
1203: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
1200:
1201: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1202: THEN
1203: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
1204: FND_MESSAGE.SET_TOKEN('BY_PROC','GMI_Reservation_Util.call_to_WSH_interface');
1205: FND_MESSAGE.SET_TOKEN('WHERE',G_PKG_NAME||'.'||l_api_name);
1206: RAISE FND_API.G_EXC_ERROR;
1207: END IF;
1208: END IF;
1209: /* HW end of bug #:1941429 */
1210: ELSE /* non lot or loct controled */
1211:
1212: IF (OM_G_installed is NULL) THEN
1213: GMI_Reservation_Util.PrintLn('Working with Default lot - Pre G scenario');
1214: l_return_status := '';
1215:
1216: -- Bug 3776538
1217: dump_shp_attrb_data(p_shipping_attr => l_shipping_attr);
1220: (p_source_code => 'INV',
1221: p_changed_attributes => l_shipping_attr,
1222: x_return_status => l_return_status
1223: );
1224: GMI_Reservation_Util.PrintLn('Return Status from [3] Update_Shipping_Attributes Call '||l_return_status);
1225:
1226: ELSE
1227:
1228: GMI_Reservation_Util.PrintLn('Working with Default lot - Post G scenario');
1224: GMI_Reservation_Util.PrintLn('Return Status from [3] Update_Shipping_Attributes Call '||l_return_status);
1225:
1226: ELSE
1227:
1228: GMI_Reservation_Util.PrintLn('Working with Default lot - Post G scenario');
1229: /* Just Working with default lot */
1230: /* Begin Enhancement 2320442 - Lakshmi Swamy */
1231:
1232: /* Bug 2462993 */
1235: -- some code is now shared between non-inventory amd
1236: -- non-lot control items
1237:
1238: /* IF (l_ic_item_mst_rec.noninv_ind = 1) THEN
1239: GMI_Reservation_Util.PrintLn('Just Working with noninventory item');
1240: GMI_Reservation_Util.PrintLn('Delivery detail id '||l_shipping_attr(1).delivery_detail_id);
1241: l_return_status := '';
1242: */
1243:
1236: -- non-lot control items
1237:
1238: /* IF (l_ic_item_mst_rec.noninv_ind = 1) THEN
1239: GMI_Reservation_Util.PrintLn('Just Working with noninventory item');
1240: GMI_Reservation_Util.PrintLn('Delivery detail id '||l_shipping_attr(1).delivery_detail_id);
1241: l_return_status := '';
1242: */
1243:
1244: /* HAW 3387829 */
1249: -- and trans_id was never popualated which caused the issue reported in
1250: -- bug 3387829
1251:
1252: /* Bug 2901317 - Treating non-inventory as non-controlled item */
1253: gmi_reservation_util.println('Calling GMI_PICK_WAVE_CONFIRM_PVT.BALANCE_NONCTL_INV_TRAN');
1254: GMI_PICK_WAVE_CONFIRM_PVT.BALANCE_NONCTL_INV_TRAN
1255: (
1256: p_mo_line_rec => l_mo_line_rec ,
1257: p_commit => p_commit,
1304: l_shipping_attr(1).pending_quantity2 := 0;
1305: END IF;
1306: /* End Bug 2621228 */
1307:
1308: GMI_Reservation_Util.PrintLn('Shiping values Action flag '|| l_shipping_attr(1).action_flag);
1309: GMI_Reservation_Util.PrintLn('Shipping values Ordered qty '||l_shipping_attr(1).ordered_quantity);
1310: GMI_Reservation_Util.PrintLn('l_available_qty1 '|| l_available_qty);
1311: GMI_Reservation_Util.PrintLn('l_requested_qty '||l_requested_qty);
1312:
1305: END IF;
1306: /* End Bug 2621228 */
1307:
1308: GMI_Reservation_Util.PrintLn('Shiping values Action flag '|| l_shipping_attr(1).action_flag);
1309: GMI_Reservation_Util.PrintLn('Shipping values Ordered qty '||l_shipping_attr(1).ordered_quantity);
1310: GMI_Reservation_Util.PrintLn('l_available_qty1 '|| l_available_qty);
1311: GMI_Reservation_Util.PrintLn('l_requested_qty '||l_requested_qty);
1312:
1313: -- Bug 3776538
1306: /* End Bug 2621228 */
1307:
1308: GMI_Reservation_Util.PrintLn('Shiping values Action flag '|| l_shipping_attr(1).action_flag);
1309: GMI_Reservation_Util.PrintLn('Shipping values Ordered qty '||l_shipping_attr(1).ordered_quantity);
1310: GMI_Reservation_Util.PrintLn('l_available_qty1 '|| l_available_qty);
1311: GMI_Reservation_Util.PrintLn('l_requested_qty '||l_requested_qty);
1312:
1313: -- Bug 3776538
1314: dump_shp_attrb_data(p_shipping_attr => l_shipping_attr);
1307:
1308: GMI_Reservation_Util.PrintLn('Shiping values Action flag '|| l_shipping_attr(1).action_flag);
1309: GMI_Reservation_Util.PrintLn('Shipping values Ordered qty '||l_shipping_attr(1).ordered_quantity);
1310: GMI_Reservation_Util.PrintLn('l_available_qty1 '|| l_available_qty);
1311: GMI_Reservation_Util.PrintLn('l_requested_qty '||l_requested_qty);
1312:
1313: -- Bug 3776538
1314: dump_shp_attrb_data(p_shipping_attr => l_shipping_attr);
1315:
1318: p_changed_attributes => l_shipping_attr,
1319: x_return_status => l_return_status
1320: );
1321:
1322: GMI_Reservation_Util.PrintLn('Return Status from [4] Update_Shipping_Attributes Call '||l_return_status);
1323:
1324: /* Begin Bug2936797 - Nulling out pick slip number on default Lot */
1325:
1326: -- HAW 3387829. There is a difference between non-lot and non-inventory
1327: -- Let's keep the original call to find_default_lot for non-lot items
1328:
1329: /* HAW added the if condition to deal with non-lot control items*/
1330: IF (l_ic_item_mst_rec.noninv_ind <> 1)THEN
1331: GMI_Reservation_Util.PrintLn('Working with noncontrolled inventory item - Post G');
1332: GMI_Reservation_Util.PrintLn('Calling GMI_RESERVATION_UTIL.find_default_lot - Post G for l_mo_line_rec.txn_source_line_id'||l_mo_line_rec.txn_source_line_id);
1333: GMI_RESERVATION_UTIL.find_default_lot
1334: ( x_return_status => x_return_status,
1335: x_msg_count => x_msg_count,
1328:
1329: /* HAW added the if condition to deal with non-lot control items*/
1330: IF (l_ic_item_mst_rec.noninv_ind <> 1)THEN
1331: GMI_Reservation_Util.PrintLn('Working with noncontrolled inventory item - Post G');
1332: GMI_Reservation_Util.PrintLn('Calling GMI_RESERVATION_UTIL.find_default_lot - Post G for l_mo_line_rec.txn_source_line_id'||l_mo_line_rec.txn_source_line_id);
1333: GMI_RESERVATION_UTIL.find_default_lot
1334: ( x_return_status => x_return_status,
1335: x_msg_count => x_msg_count,
1336: x_msg_data => x_msg_data,
1329: /* HAW added the if condition to deal with non-lot control items*/
1330: IF (l_ic_item_mst_rec.noninv_ind <> 1)THEN
1331: GMI_Reservation_Util.PrintLn('Working with noncontrolled inventory item - Post G');
1332: GMI_Reservation_Util.PrintLn('Calling GMI_RESERVATION_UTIL.find_default_lot - Post G for l_mo_line_rec.txn_source_line_id'||l_mo_line_rec.txn_source_line_id);
1333: GMI_RESERVATION_UTIL.find_default_lot
1334: ( x_return_status => x_return_status,
1335: x_msg_count => x_msg_count,
1336: x_msg_data => x_msg_data,
1337: x_reservation_id => d_trans_id,
1337: x_reservation_id => d_trans_id,
1338: p_line_id => l_mo_line_rec.txn_source_line_id
1339: );
1340: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1341: GMI_RESERVATION_UTIL.println('Error returned by find default lot');
1342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1343: END IF;
1344:
1345: IF (d_trans_id is NOT NULL) THEN
1359: l_shipping_attr(1).cycle_count_quantity2 := l_requested_qty2 - l_available_qty2;
1360: l_shipping_attr(1).released_status := '';
1361: l_return_status := '';
1362:
1363: GMI_Reservation_Util.PrintLn('Shipping values cycle count quantity '||l_shipping_attr(1).cycle_count_quantity);
1364:
1365: -- Bug 3776538
1366: dump_shp_attrb_data(p_shipping_attr => l_shipping_attr);
1367:
1369: (p_source_code => 'INV',
1370: p_changed_attributes => l_shipping_attr,
1371: x_return_status => l_return_status
1372: );
1373: GMI_Reservation_Util.PrintLn('Return Status from [5] Update_Shipping_Attributes Call '||l_return_status);
1374:
1375:
1376:
1377: END IF; -- of l_available_qty < l_requested_qty
1395: And released_status = 'S';
1396: IF l_count = 0 THEN
1397: l_mo_line_rec.line_status :=5;
1398: l_mo_line_rec.quantity := l_mo_line_rec.quantity_detailed;
1399: GMI_Reservation_Util.PrintLn('Now, update the MO row');
1400: GMI_MOVE_ORDER_LINE_UTIL.Update_ROW(p_mo_line_rec => l_mo_line_rec);
1401: END IF;
1402: END IF;
1403:
1404: <
1405: l_mo_line_tbl(I) := l_mo_line_rec;
1406: x_return_status := l_return_status;
1407:
1408: GMI_Reservation_Util.PrintLn('Before Loop 2');
1409: null;
1410: END IF; -- HW of l_no_error =1 for BUG:2296620
1411: END LOOP; /* mo line tbl loop */
1412:
1584: /* Equaivalent UOM codes. */
1585:
1586: /* Lets Get OPM From UOM code from apps from uom code */
1587:
1588: GMI_Reservation_Util.Get_OPMUOM_from_AppsUOM
1589: (
1590: p_Apps_UOM => p_apps_from_uom,
1591: x_OPM_UOM => l_opm_from_uom,
1592: x_return_status => x_return_status,
1600: FND_MSG_PUB.Add;
1601: RAISE FND_API.G_EXC_ERROR;
1602: END IF;
1603:
1604: GMI_reservation_Util.PrintLn('Convert From OPM UOM => ' || l_opm_from_uom);
1605:
1606:
1607: /* Lets Get OPM to UOM code from apps to uom code */
1608:
1605:
1606:
1607: /* Lets Get OPM to UOM code from apps to uom code */
1608:
1609: GMI_Reservation_Util.Get_OPMUOM_from_AppsUOM
1610: (
1611: p_Apps_UOM => p_apps_to_uom,
1612: x_OPM_UOM => l_opm_to_uom,
1613: x_return_status => x_return_status,
1621: FND_MSG_PUB.Add;
1622: RAISE FND_API.G_EXC_ERROR;
1623: END IF;
1624:
1625: GMI_reservation_Util.PrintLn('Convert To OPM UOM => ' || l_opm_from_uom);
1626:
1627:
1628:
1629: IF ( p_opm_lot_id is NULL
1632: ELSE
1633: l_opm_lot_id := p_opm_lot_id;
1634: END IF;
1635:
1636: GMI_reservation_Util.PrintLn('Lot Id => ' || l_opm_lot_id);
1637: GMI_reservation_Util.PrintLn('Original Qty => ' || p_original_qty);
1638:
1639: /* OKay We have the values Lets Convert..... */
1640:
1633: l_opm_lot_id := p_opm_lot_id;
1634: END IF;
1635:
1636: GMI_reservation_Util.PrintLn('Lot Id => ' || l_opm_lot_id);
1637: GMI_reservation_Util.PrintLn('Original Qty => ' || p_original_qty);
1638:
1639: /* OKay We have the values Lets Convert..... */
1640:
1641: GMICUOM.icuomcv
1648: onew_qty => x_converted_qty
1649: );
1650:
1651:
1652: GMI_reservation_Util.PrintLn('converted Qty => ' || x_converted_qty);
1653:
1654:
1655: EXCEPTION
1656: WHEN FND_API.G_EXC_ERROR THEN
1908: l_apps_uom VARCHAR2(4);
1909: l_opm_uom VARCHAR2(4);
1910: l_apps_uom2 VARCHAR2(4);
1911: l_opm_uom2 VARCHAR2(4);
1912: l_ic_item_mst_rec GMI_RESERVATION_UTIL.ic_item_mst_rec;
1913:
1914:
1915: BEGIN
1916:
1913:
1914:
1915: BEGIN
1916:
1917: gmi_reservation_util.println('Inside GMI_PICK_WAVE_CONFIRM_PVT.check_quantity_to_pick');
1918: OPEN c_detail_info(p_order_line_id);
1919: FETCH c_detail_info INTO l_detail_info;
1920: l_found_flag := c_detail_info%FOUND;
1921: CLOSE c_detail_info;
1960: END IF;
1961:
1962: -- HW OPM for debugging puproses. Print values
1963: IF ( l_process_flag = FND_API.G_TRUE ) THEN
1964: gmi_reservation_util.println('Value of l_staged_info.net_requested_qty is '||l_staged_info.net_requested_qty);
1965: gmi_reservation_util.println('Value of l_staged_info.net_requested_qty2 is '||l_staged_info.net_requested_qty2);
1966: gmi_reservation_util.println('Value of l_staged_info.net_staged_qty is '||l_staged_info.net_staged_qty);
1967: gmi_reservation_util.println('Value of l_staged_info.net_satged_qty2 is '||l_staged_info.net_staged_qty2);
1968: END IF;
1961:
1962: -- HW OPM for debugging puproses. Print values
1963: IF ( l_process_flag = FND_API.G_TRUE ) THEN
1964: gmi_reservation_util.println('Value of l_staged_info.net_requested_qty is '||l_staged_info.net_requested_qty);
1965: gmi_reservation_util.println('Value of l_staged_info.net_requested_qty2 is '||l_staged_info.net_requested_qty2);
1966: gmi_reservation_util.println('Value of l_staged_info.net_staged_qty is '||l_staged_info.net_staged_qty);
1967: gmi_reservation_util.println('Value of l_staged_info.net_satged_qty2 is '||l_staged_info.net_staged_qty2);
1968: END IF;
1969:
1962: -- HW OPM for debugging puproses. Print values
1963: IF ( l_process_flag = FND_API.G_TRUE ) THEN
1964: gmi_reservation_util.println('Value of l_staged_info.net_requested_qty is '||l_staged_info.net_requested_qty);
1965: gmi_reservation_util.println('Value of l_staged_info.net_requested_qty2 is '||l_staged_info.net_requested_qty2);
1966: gmi_reservation_util.println('Value of l_staged_info.net_staged_qty is '||l_staged_info.net_staged_qty);
1967: gmi_reservation_util.println('Value of l_staged_info.net_satged_qty2 is '||l_staged_info.net_staged_qty2);
1968: END IF;
1969:
1970: -- HW OPM Need to branch
1963: IF ( l_process_flag = FND_API.G_TRUE ) THEN
1964: gmi_reservation_util.println('Value of l_staged_info.net_requested_qty is '||l_staged_info.net_requested_qty);
1965: gmi_reservation_util.println('Value of l_staged_info.net_requested_qty2 is '||l_staged_info.net_requested_qty2);
1966: gmi_reservation_util.println('Value of l_staged_info.net_staged_qty is '||l_staged_info.net_staged_qty);
1967: gmi_reservation_util.println('Value of l_staged_info.net_satged_qty2 is '||l_staged_info.net_staged_qty2);
1968: END IF;
1969:
1970: -- HW OPM Need to branch
1971: IF (l_process_flag = FND_API.G_FALSE ) THEN
1977: CLOSE c_ordered_quantity;
1978: ELSE
1979: OPEN c_ordered_quantity_opm(p_order_line_id);
1980: FETCH c_ordered_quantity_opm INTO l_order_line_opm;
1981: quantity := GMI_Reservation_Util.get_opm_converted_qty(
1982: p_apps_item_id => l_detail_info.inventory_item_id,
1983: p_organization_id => l_detail_info.organization_id,
1984: p_apps_from_uom => l_order_line_opm.order_quantity_uom,
1985: p_apps_to_uom => l_detail_info.requested_quantity_uom,
2019: END IF;
2020:
2021: -- HW added for debugging purposes
2022: IF ( l_process_flag = FND_API.G_TRUE ) THEN
2023: gmi_reservation_util.println('Value of l_min_quantity is '||l_min_quantity);
2024: gmi_reservation_util.println('Value of l_min_quantity2 is '||l_min_quantity2);
2025: gmi_reservation_util.println('Value of l_max_quantity is '||l_max_quantity);
2026: gmi_reservation_util.println('Value of l_max_quantity2 is '||l_max_quantity2);
2027: END IF;
2020:
2021: -- HW added for debugging purposes
2022: IF ( l_process_flag = FND_API.G_TRUE ) THEN
2023: gmi_reservation_util.println('Value of l_min_quantity is '||l_min_quantity);
2024: gmi_reservation_util.println('Value of l_min_quantity2 is '||l_min_quantity2);
2025: gmi_reservation_util.println('Value of l_max_quantity is '||l_max_quantity);
2026: gmi_reservation_util.println('Value of l_max_quantity2 is '||l_max_quantity2);
2027: END IF;
2028:
2021: -- HW added for debugging purposes
2022: IF ( l_process_flag = FND_API.G_TRUE ) THEN
2023: gmi_reservation_util.println('Value of l_min_quantity is '||l_min_quantity);
2024: gmi_reservation_util.println('Value of l_min_quantity2 is '||l_min_quantity2);
2025: gmi_reservation_util.println('Value of l_max_quantity is '||l_max_quantity);
2026: gmi_reservation_util.println('Value of l_max_quantity2 is '||l_max_quantity2);
2027: END IF;
2028:
2029:
2022: IF ( l_process_flag = FND_API.G_TRUE ) THEN
2023: gmi_reservation_util.println('Value of l_min_quantity is '||l_min_quantity);
2024: gmi_reservation_util.println('Value of l_min_quantity2 is '||l_min_quantity2);
2025: gmi_reservation_util.println('Value of l_max_quantity is '||l_max_quantity);
2026: gmi_reservation_util.println('Value of l_max_quantity2 is '||l_max_quantity2);
2027: END IF;
2028:
2029:
2030: -- HW Need to branch
2040: - l_staged_info.net_requested_qty)
2041: );
2042:
2043: ELSE
2044: l_max_quantity := GMI_Reservation_Util.get_opm_converted_qty(
2045: p_apps_item_id => l_detail_info.inventory_item_id,
2046: p_organization_id => l_detail_info.organization_id,
2047: p_apps_from_uom => l_order_line_opm.order_quantity_uom,
2048: p_apps_to_uom => l_detail_info.requested_quantity_uom,
2048: p_apps_to_uom => l_detail_info.requested_quantity_uom,
2049: p_original_qty => l_max_quantity)
2050: - l_staged_info.net_staged_qty;
2051:
2052: gmi_reservation_util.println('l_order_line_opm.ordered_quantity '||l_order_line_opm.ordered_quantity);
2053: gmi_reservation_util.println('l_order_line_opm.order_quantity_uom '||l_order_line_opm.order_quantity_uom);
2054: gmi_reservation_util.println('l_detail_info.requested_quantity_uom '||l_detail_info.requested_quantity_uom);
2055:
2056: -- BEGIN Bug 2900072 - If the order UOM is different than item's UOM convert Ordered quantity
2049: p_original_qty => l_max_quantity)
2050: - l_staged_info.net_staged_qty;
2051:
2052: gmi_reservation_util.println('l_order_line_opm.ordered_quantity '||l_order_line_opm.ordered_quantity);
2053: gmi_reservation_util.println('l_order_line_opm.order_quantity_uom '||l_order_line_opm.order_quantity_uom);
2054: gmi_reservation_util.println('l_detail_info.requested_quantity_uom '||l_detail_info.requested_quantity_uom);
2055:
2056: -- BEGIN Bug 2900072 - If the order UOM is different than item's UOM convert Ordered quantity
2057: IF (l_order_line_opm.order_quantity_uom <> l_detail_info.requested_quantity_uom) THEN
2050: - l_staged_info.net_staged_qty;
2051:
2052: gmi_reservation_util.println('l_order_line_opm.ordered_quantity '||l_order_line_opm.ordered_quantity);
2053: gmi_reservation_util.println('l_order_line_opm.order_quantity_uom '||l_order_line_opm.order_quantity_uom);
2054: gmi_reservation_util.println('l_detail_info.requested_quantity_uom '||l_detail_info.requested_quantity_uom);
2055:
2056: -- BEGIN Bug 2900072 - If the order UOM is different than item's UOM convert Ordered quantity
2057: IF (l_order_line_opm.order_quantity_uom <> l_detail_info.requested_quantity_uom) THEN
2058: l_apps_uom_ordered_quantity := GMI_Reservation_Util.get_opm_converted_qty(
2054: gmi_reservation_util.println('l_detail_info.requested_quantity_uom '||l_detail_info.requested_quantity_uom);
2055:
2056: -- BEGIN Bug 2900072 - If the order UOM is different than item's UOM convert Ordered quantity
2057: IF (l_order_line_opm.order_quantity_uom <> l_detail_info.requested_quantity_uom) THEN
2058: l_apps_uom_ordered_quantity := GMI_Reservation_Util.get_opm_converted_qty(
2059: p_apps_item_id => l_detail_info.inventory_item_id,
2060: p_organization_id => l_detail_info.organization_id,
2061: p_apps_from_uom => l_order_line_opm.order_quantity_uom,
2062: p_apps_to_uom => l_detail_info.requested_quantity_uom,
2064: ELSE
2065: l_apps_uom_ordered_quantity := l_order_line_opm.ordered_quantity;
2066: END IF;
2067:
2068: gmi_reservation_util.println('l_apps_uom_ordered_quantity '||l_apps_uom_ordered_quantity);
2069:
2070: l_req_qty_left := GREATEST(0,
2071: (l_apps_uom_ordered_quantity
2072: - l_staged_info.net_requested_qty)
2084:
2085:
2086: -- HW added for debugging purposes
2087: IF ( l_process_flag = FND_API.G_TRUE ) THEN
2088: gmi_reservation_util.println('Value of quantity is '||quantity);
2089: gmi_reservation_util.println('Value of l_order_line_opm.quantity2 is '||l_order_line_opm.ordered_quantity2);
2090: gmi_reservation_util.println('Value of l_req_qty_left is '|| l_req_qty_left);
2091: gmi_reservation_util.println('Value of l_req_qty2_left is '|| l_req_qty2_left);
2092: END IF;
2085:
2086: -- HW added for debugging purposes
2087: IF ( l_process_flag = FND_API.G_TRUE ) THEN
2088: gmi_reservation_util.println('Value of quantity is '||quantity);
2089: gmi_reservation_util.println('Value of l_order_line_opm.quantity2 is '||l_order_line_opm.ordered_quantity2);
2090: gmi_reservation_util.println('Value of l_req_qty_left is '|| l_req_qty_left);
2091: gmi_reservation_util.println('Value of l_req_qty2_left is '|| l_req_qty2_left);
2092: END IF;
2093:
2086: -- HW added for debugging purposes
2087: IF ( l_process_flag = FND_API.G_TRUE ) THEN
2088: gmi_reservation_util.println('Value of quantity is '||quantity);
2089: gmi_reservation_util.println('Value of l_order_line_opm.quantity2 is '||l_order_line_opm.ordered_quantity2);
2090: gmi_reservation_util.println('Value of l_req_qty_left is '|| l_req_qty_left);
2091: gmi_reservation_util.println('Value of l_req_qty2_left is '|| l_req_qty2_left);
2092: END IF;
2093:
2094:
2087: IF ( l_process_flag = FND_API.G_TRUE ) THEN
2088: gmi_reservation_util.println('Value of quantity is '||quantity);
2089: gmi_reservation_util.println('Value of l_order_line_opm.quantity2 is '||l_order_line_opm.ordered_quantity2);
2090: gmi_reservation_util.println('Value of l_req_qty_left is '|| l_req_qty_left);
2091: gmi_reservation_util.println('Value of l_req_qty2_left is '|| l_req_qty2_left);
2092: END IF;
2093:
2094:
2095: IF p_quantity_to_pick < 0 THEN
2112: x_avail_req_quantity2 := l_req_qty2_left;
2113:
2114: -- HW for debugging purposes, print values
2115: IF ( l_process_flag = FND_API.G_TRUE ) THEN
2116: gmi_reservation_util.println('Value of x_max_quantity_allowed is '||x_max_quantity_allowed);
2117: gmi_reservation_util.println('Value of x_max_quantity2_allowed is '||x_max_quantity2_allowed);
2118: gmi_reservation_util.println('Value of x_avail_req_quantity is '||x_avail_req_quantity);
2119: gmi_reservation_util.println('Value of x_avail_req_quantity2 is '||x_avail_req_quantity2);
2120: END IF;
2113:
2114: -- HW for debugging purposes, print values
2115: IF ( l_process_flag = FND_API.G_TRUE ) THEN
2116: gmi_reservation_util.println('Value of x_max_quantity_allowed is '||x_max_quantity_allowed);
2117: gmi_reservation_util.println('Value of x_max_quantity2_allowed is '||x_max_quantity2_allowed);
2118: gmi_reservation_util.println('Value of x_avail_req_quantity is '||x_avail_req_quantity);
2119: gmi_reservation_util.println('Value of x_avail_req_quantity2 is '||x_avail_req_quantity2);
2120: END IF;
2121:
2114: -- HW for debugging purposes, print values
2115: IF ( l_process_flag = FND_API.G_TRUE ) THEN
2116: gmi_reservation_util.println('Value of x_max_quantity_allowed is '||x_max_quantity_allowed);
2117: gmi_reservation_util.println('Value of x_max_quantity2_allowed is '||x_max_quantity2_allowed);
2118: gmi_reservation_util.println('Value of x_avail_req_quantity is '||x_avail_req_quantity);
2119: gmi_reservation_util.println('Value of x_avail_req_quantity2 is '||x_avail_req_quantity2);
2120: END IF;
2121:
2122: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2115: IF ( l_process_flag = FND_API.G_TRUE ) THEN
2116: gmi_reservation_util.println('Value of x_max_quantity_allowed is '||x_max_quantity_allowed);
2117: gmi_reservation_util.println('Value of x_max_quantity2_allowed is '||x_max_quantity2_allowed);
2118: gmi_reservation_util.println('Value of x_avail_req_quantity is '||x_avail_req_quantity);
2119: gmi_reservation_util.println('Value of x_avail_req_quantity2 is '||x_avail_req_quantity2);
2120: END IF;
2121:
2122: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2123:
2190: l_ato_line_id NUMBER;
2191:
2192: BEGIN
2193:
2194: gmi_reservation_util.println('Entering GMI_PICK_WAVE_CONFIRM_PVT.Get_Min_Max_Tolerance_Quantity');
2195:
2196: x_return_status := FND_API.G_RET_STS_SUCCESS;
2197: /*
2198: IF NOT FND_API.Compatible_API_Call
2229:
2230: IF nvl(l_top_model_line_id,-1) = nvl(l_ato_line_id,-1) AND
2231: l_top_model_line_id IS NOT NULL THEN
2232:
2233: gmi_reservation_util.println('It is a ATO MODEL ');
2234:
2235: SELECT line_set_id
2236: INTO l_line_set_id
2237: FROM OE_ORDER_LINES_ALL
2236: INTO l_line_set_id
2237: FROM OE_ORDER_LINES_ALL
2238: WHERE line_id = l_top_model_line_id;
2239:
2240: gmi_reservation_util.println('Line set id : '||l_line_set_id);
2241:
2242: END IF;
2243:
2244: IF l_line_set_id IS NOT NULL THEN
2242: END IF;
2243:
2244: IF l_line_set_id IS NOT NULL THEN
2245: -- HW Sum qty2 for OPM
2246: gmi_reservation_util.println('Line set id : '||l_line_set_id);
2247: SELECT SUM(ordered_quantity)
2248: , SUM(shipped_quantity)
2249: , SUM(shipping_quantity)
2250: , SUM(nvl(ordered_quantity2,0))
2260: WHERE line_set_id = l_line_set_id;
2261:
2262: END IF;
2263:
2264: gmi_reservation_util.println('Total ordered quantity : '||to_char(l_ordered_quantity));
2265: gmi_reservation_util.println('Total shipped quantity : '||to_char(l_shipped_quantity));
2266:
2267: l_tolerance_quantity_below := nvl(l_ordered_quantity,0)*nvl(l_ship_tolerance_below,0)/100;
2268: l_tolerance_quantity_above := nvl(l_ordered_quantity,0)*nvl(l_ship_tolerance_above,0)/100;
2261:
2262: END IF;
2263:
2264: gmi_reservation_util.println('Total ordered quantity : '||to_char(l_ordered_quantity));
2265: gmi_reservation_util.println('Total shipped quantity : '||to_char(l_shipped_quantity));
2266:
2267: l_tolerance_quantity_below := nvl(l_ordered_quantity,0)*nvl(l_ship_tolerance_below,0)/100;
2268: l_tolerance_quantity_above := nvl(l_ordered_quantity,0)*nvl(l_ship_tolerance_above,0)/100;
2269: l_tolerance_quantity2_below := nvl(l_ordered_quantity2,0)*nvl(l_ship_tolerance_below,0)/100;
2268: l_tolerance_quantity_above := nvl(l_ordered_quantity,0)*nvl(l_ship_tolerance_above,0)/100;
2269: l_tolerance_quantity2_below := nvl(l_ordered_quantity2,0)*nvl(l_ship_tolerance_below,0)/100;
2270: l_tolerance_quantity2_above := nvl(l_ordered_quantity2,0)*nvl(l_ship_tolerance_above,0)/100;
2271:
2272: gmi_reservation_util.println('Tolerance quantity below : '||l_tolerance_quantity_below);
2273: gmi_reservation_util.println('Tolerance quantity above : '||l_tolerance_quantity_above);
2274: gmi_reservation_util.println('Tolerance quantity2 below : '||l_tolerance_quantity2_below);
2275: gmi_reservation_util.println('Tolerance quantity2 above : '||l_tolerance_quantity2_above);
2276:
2269: l_tolerance_quantity2_below := nvl(l_ordered_quantity2,0)*nvl(l_ship_tolerance_below,0)/100;
2270: l_tolerance_quantity2_above := nvl(l_ordered_quantity2,0)*nvl(l_ship_tolerance_above,0)/100;
2271:
2272: gmi_reservation_util.println('Tolerance quantity below : '||l_tolerance_quantity_below);
2273: gmi_reservation_util.println('Tolerance quantity above : '||l_tolerance_quantity_above);
2274: gmi_reservation_util.println('Tolerance quantity2 below : '||l_tolerance_quantity2_below);
2275: gmi_reservation_util.println('Tolerance quantity2 above : '||l_tolerance_quantity2_above);
2276:
2277: l_min_quantity_remaining := l_ordered_quantity - nvl(l_shipped_quantity,0) - l_tolerance_quantity_below;
2270: l_tolerance_quantity2_above := nvl(l_ordered_quantity2,0)*nvl(l_ship_tolerance_above,0)/100;
2271:
2272: gmi_reservation_util.println('Tolerance quantity below : '||l_tolerance_quantity_below);
2273: gmi_reservation_util.println('Tolerance quantity above : '||l_tolerance_quantity_above);
2274: gmi_reservation_util.println('Tolerance quantity2 below : '||l_tolerance_quantity2_below);
2275: gmi_reservation_util.println('Tolerance quantity2 above : '||l_tolerance_quantity2_above);
2276:
2277: l_min_quantity_remaining := l_ordered_quantity - nvl(l_shipped_quantity,0) - l_tolerance_quantity_below;
2278: l_max_quantity_remaining := l_ordered_quantity - nvl(l_shipped_quantity,0) + l_tolerance_quantity_above;
2271:
2272: gmi_reservation_util.println('Tolerance quantity below : '||l_tolerance_quantity_below);
2273: gmi_reservation_util.println('Tolerance quantity above : '||l_tolerance_quantity_above);
2274: gmi_reservation_util.println('Tolerance quantity2 below : '||l_tolerance_quantity2_below);
2275: gmi_reservation_util.println('Tolerance quantity2 above : '||l_tolerance_quantity2_above);
2276:
2277: l_min_quantity_remaining := l_ordered_quantity - nvl(l_shipped_quantity,0) - l_tolerance_quantity_below;
2278: l_max_quantity_remaining := l_ordered_quantity - nvl(l_shipped_quantity,0) + l_tolerance_quantity_above;
2279:
2280: -- HW Get min and max qty2 for OPM
2281: l_min_quantity_remaining2 := nvl(l_ordered_quantity2,0) - nvl(l_shipped_quantity2,0) - l_tolerance_quantity2_below;
2282: l_max_quantity_remaining2 := nvl(l_ordered_quantity2,0) - nvl(l_shipped_quantity2,0) + l_tolerance_quantity2_above;
2283:
2284: gmi_reservation_util.println('Min remaining quantity : '||l_min_quantity_remaining);
2285: gmi_reservation_util.println('Max remaining quantity : '||l_max_quantity_remaining);
2286:
2287: -- HW Print Qty2 for OPM
2288: gmi_reservation_util.println('Min remaining quantity2 : '||l_min_quantity_remaining2);
2281: l_min_quantity_remaining2 := nvl(l_ordered_quantity2,0) - nvl(l_shipped_quantity2,0) - l_tolerance_quantity2_below;
2282: l_max_quantity_remaining2 := nvl(l_ordered_quantity2,0) - nvl(l_shipped_quantity2,0) + l_tolerance_quantity2_above;
2283:
2284: gmi_reservation_util.println('Min remaining quantity : '||l_min_quantity_remaining);
2285: gmi_reservation_util.println('Max remaining quantity : '||l_max_quantity_remaining);
2286:
2287: -- HW Print Qty2 for OPM
2288: gmi_reservation_util.println('Min remaining quantity2 : '||l_min_quantity_remaining2);
2289: gmi_reservation_util.println('Max remaining quantity2 : '||l_max_quantity_remaining2);
2284: gmi_reservation_util.println('Min remaining quantity : '||l_min_quantity_remaining);
2285: gmi_reservation_util.println('Max remaining quantity : '||l_max_quantity_remaining);
2286:
2287: -- HW Print Qty2 for OPM
2288: gmi_reservation_util.println('Min remaining quantity2 : '||l_min_quantity_remaining2);
2289: gmi_reservation_util.println('Max remaining quantity2 : '||l_max_quantity_remaining2);
2290:
2291: IF l_min_quantity_remaining < 0 THEN
2292:
2285: gmi_reservation_util.println('Max remaining quantity : '||l_max_quantity_remaining);
2286:
2287: -- HW Print Qty2 for OPM
2288: gmi_reservation_util.println('Min remaining quantity2 : '||l_min_quantity_remaining2);
2289: gmi_reservation_util.println('Max remaining quantity2 : '||l_max_quantity_remaining2);
2290:
2291: IF l_min_quantity_remaining < 0 THEN
2292:
2293: l_min_quantity_remaining := 0;
2317: -- HW added qty2 for OPM
2318: x_min_remaining_quantity2 := nvl(l_min_quantity_remaining2,0);
2319: x_max_remaining_quantity2 := nvl(l_max_quantity_remaining2,0);
2320:
2321: gmi_reservation_util.println('Return Min remaining quantity : '||x_min_remaining_quantity);
2322: gmi_reservation_util.println('Return Max remaining quantity : '||x_max_remaining_quantity);
2323:
2324: -- HW print qty2 for OPM
2325: gmi_reservation_util.println('Return Min remaining quantity2 : '||x_min_remaining_quantity2);
2318: x_min_remaining_quantity2 := nvl(l_min_quantity_remaining2,0);
2319: x_max_remaining_quantity2 := nvl(l_max_quantity_remaining2,0);
2320:
2321: gmi_reservation_util.println('Return Min remaining quantity : '||x_min_remaining_quantity);
2322: gmi_reservation_util.println('Return Max remaining quantity : '||x_max_remaining_quantity);
2323:
2324: -- HW print qty2 for OPM
2325: gmi_reservation_util.println('Return Min remaining quantity2 : '||x_min_remaining_quantity2);
2326: gmi_reservation_util.println('Return Max remaining quantity2 : '||x_max_remaining_quantity2);
2321: gmi_reservation_util.println('Return Min remaining quantity : '||x_min_remaining_quantity);
2322: gmi_reservation_util.println('Return Max remaining quantity : '||x_max_remaining_quantity);
2323:
2324: -- HW print qty2 for OPM
2325: gmi_reservation_util.println('Return Min remaining quantity2 : '||x_min_remaining_quantity2);
2326: gmi_reservation_util.println('Return Max remaining quantity2 : '||x_max_remaining_quantity2);
2327:
2328: gmi_reservation_util.println('Exiting GMI_PICK_WAVE_CONFIRM_PVT.Get_Min_Max_Tolerance_Quantity '||x_return_status);
2329:
2322: gmi_reservation_util.println('Return Max remaining quantity : '||x_max_remaining_quantity);
2323:
2324: -- HW print qty2 for OPM
2325: gmi_reservation_util.println('Return Min remaining quantity2 : '||x_min_remaining_quantity2);
2326: gmi_reservation_util.println('Return Max remaining quantity2 : '||x_max_remaining_quantity2);
2327:
2328: gmi_reservation_util.println('Exiting GMI_PICK_WAVE_CONFIRM_PVT.Get_Min_Max_Tolerance_Quantity '||x_return_status);
2329:
2330: EXCEPTION
2324: -- HW print qty2 for OPM
2325: gmi_reservation_util.println('Return Min remaining quantity2 : '||x_min_remaining_quantity2);
2326: gmi_reservation_util.println('Return Max remaining quantity2 : '||x_max_remaining_quantity2);
2327:
2328: gmi_reservation_util.println('Exiting GMI_PICK_WAVE_CONFIRM_PVT.Get_Min_Max_Tolerance_Quantity '||x_return_status);
2329:
2330: EXCEPTION
2331:
2332: WHEN NO_DATA_FOUND THEN
2344: END IF;
2345:
2346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2347:
2348: gmi_reservation_util.println('Unexpected Error : '||sqlerrm);
2349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2350:
2351: -- Get message count and data
2352:
2356: );
2357:
2358: WHEN OTHERS THEN
2359:
2360: gmi_reservation_util.println('Unexpected Error : '||sqlerrm);
2361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2362:
2363: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2364: THEN
2404:
2405: l_dflt_nonctl_tran_rec.trans_qty := (-1) *(ABS(l_dflt_nonctl_tran_rec.trans_qty) - p_requested_qty);
2406: l_dflt_nonctl_tran_rec.trans_qty2 := (-1) *(ABS(l_dflt_nonctl_tran_rec.trans_qty2) - p_requested_qty2);
2407:
2408: GMI_Reservation_Util.PrintLn('Updating pending txn with qty '||l_dflt_nonctl_tran_rec.trans_qty );
2409:
2410: l_dflt_nonctl_tran_rec.staged_ind := 0;
2411: l_dflt_nonctl_tran_rec.line_detail_id := null;
2412:
2423: ,x_msg_count => x_msg_count
2424: ,x_msg_data => x_msg_data);
2425:
2426: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2427: GMI_reservation_Util.PrintLn('(opm_dbg) in PICK_CONFIRM:
2428: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.' );
2429: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2430: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2431: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
2425:
2426: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2427: GMI_reservation_Util.PrintLn('(opm_dbg) in PICK_CONFIRM:
2428: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.' );
2429: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2430: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2431: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
2432: FND_MESSAGE.Set_Token('WHERE', 'PICK_CONFIRM');
2433: FND_MSG_PUB.Add;
2440: l_dflt_nonctl_tran_rec.trans_qty := -1 * p_requested_qty;
2441: l_dflt_nonctl_tran_rec.trans_qty2 := -1 * p_requested_qty2;
2442:
2443:
2444: GMI_Reservation_Util.PrintLn('Creating new pending txn with req qty '||l_dflt_nonctl_tran_rec.trans_qty );
2445:
2446: /* Creating a new transaction with the staged quantity */
2447: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
2448: ( p_api_version => 1.0
2456: , x_msg_data => x_msg_data
2457: );
2458:
2459: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2460: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
2461: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
2462: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2463: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
2464: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
2458:
2459: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2460: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
2461: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
2462: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2463: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
2464: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
2465: FND_MESSAGE.Set_Token('WHERE','PICK_CONFIRM');
2466: FND_MSG_PUB.Add;
2513: FROM ic_loct_inv
2514: WHERE whse_code = p_whse_code
2515: AND item_id = p_item_id
2516: AND lot_id = 0
2517: AND location = GMI_RESERVATION_UTIL.G_DEFAULT_LOCT
2518: AND delete_mark = 0;
2519:
2520:
2521: CURSOR staged_qty_CUR IS
2561:
2562:
2563: BEGIN
2564:
2565: GMI_Reservation_Util.PrintLn('Handling Noninventory/Non-controlled Items');
2566:
2567: GMI_RESERVATION_UTIL.find_default_lot
2568: ( x_return_status => x_return_status,
2569: x_msg_count => x_msg_count,
2563: BEGIN
2564:
2565: GMI_Reservation_Util.PrintLn('Handling Noninventory/Non-controlled Items');
2566:
2567: GMI_RESERVATION_UTIL.find_default_lot
2568: ( x_return_status => x_return_status,
2569: x_msg_count => x_msg_count,
2570: x_msg_data => x_msg_data,
2571: x_reservation_id => l_trans_id,
2581: Fetch item_mst_dtl INTO l_noninv_ind;
2582: Close item_mst_dtl;
2583:
2584: IF (l_noninv_ind = 1) THEN
2585: GMI_Reservation_Util.PrintLn('Non Inventory Item');
2586: IF (p_requested_qty < ABS(l_dflt_nonctl_tran_rec.trans_qty)) THEN
2587:
2588: GMI_PICK_WAVE_CONFIRM_PVT.BALANCE_NONINV_TRAN
2589: (
2610: IF (l_noninv_ind = 1) OR (l_allow_negative_inv = 1) THEN
2611:
2612: l_dflt_nonctl_tran_rec.trans_qty := (-1) * p_requested_qty;
2613: l_dflt_nonctl_tran_rec.trans_qty2 := (-1) * p_requested_qty2;
2614: GMI_Reservation_Util.PrintLn('Irrespective of available quantity, transacting all the requested quantity');
2615:
2616: l_dflt_nonctl_tran_rec.line_detail_id := p_delivery_detail_id;
2617: l_dflt_nonctl_tran_rec.staged_ind := 1;
2618:
2649: , x_msg_data => x_msg_data
2650: , x_pick_slip_number => l_pick_slip_number
2651: );
2652:
2653: GMI_reservation_Util.PrintLn('pick slip number is '|| l_pick_slip_number);
2654:
2655: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
2656: THEN
2657: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_lots: Error returned by GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip.', 'pick_lots.log');
2653: GMI_reservation_Util.PrintLn('pick slip number is '|| l_pick_slip_number);
2654:
2655: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
2656: THEN
2657: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_lots: Error returned by GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip.', 'pick_lots.log');
2658: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2659: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip');
2660: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2661: FND_MSG_PUB.Add;
2678: OPEN staged_qty_CUR;
2679: FETCH staged_qty_CUR INTO l_commit_qty,l_commit_qty2;
2680: CLOSE staged_qty_CUR;
2681:
2682: GMI_Reservation_Util.PrintLn('l_commit_qty is '||l_commit_qty);
2683: GMI_Reservation_Util.PrintLn('l_onhand_qty is '||l_onhand_qty);
2684:
2685: IF (ABS(l_commit_qty) < l_onhand_qty ) THEN
2686: x_available_qty := l_onhand_qty - (-1 * l_commit_qty);
2679: FETCH staged_qty_CUR INTO l_commit_qty,l_commit_qty2;
2680: CLOSE staged_qty_CUR;
2681:
2682: GMI_Reservation_Util.PrintLn('l_commit_qty is '||l_commit_qty);
2683: GMI_Reservation_Util.PrintLn('l_onhand_qty is '||l_onhand_qty);
2684:
2685: IF (ABS(l_commit_qty) < l_onhand_qty ) THEN
2686: x_available_qty := l_onhand_qty - (-1 * l_commit_qty);
2687: x_available_qty2 := l_onhand_qty2 - (-1 * l_commit_qty2);
2689: x_available_qty := 0;
2690: x_available_qty2 := 0;
2691: END IF;
2692:
2693: GMI_Reservation_Util.PrintLn('x available qty '||x_available_qty);
2694: GMI_Reservation_Util.PrintLn('p_requested_qty '||p_requested_qty);
2695:
2696: IF (x_available_qty <> 0) THEN
2697: IF (x_available_qty < p_requested_qty) THEN
2690: x_available_qty2 := 0;
2691: END IF;
2692:
2693: GMI_Reservation_Util.PrintLn('x available qty '||x_available_qty);
2694: GMI_Reservation_Util.PrintLn('p_requested_qty '||p_requested_qty);
2695:
2696: IF (x_available_qty <> 0) THEN
2697: IF (x_available_qty < p_requested_qty) THEN
2698: /* Split ic_tran_pnd to have remaining quantity backordered.
2702: l_backorder_qty2 := p_requested_qty2 - x_available_qty2;
2703: l_dflt_nonctl_tran_rec.trans_qty := -1 * ((-1 * l_dflt_nonctl_tran_rec.trans_qty) - p_requested_qty + l_backorder_qty);
2704: l_dflt_nonctl_tran_rec.trans_qty2 := -1 * ((-1 * l_dflt_nonctl_tran_rec.trans_qty2) - p_requested_qty2 + l_backorder_qty2);
2705:
2706: GMI_Reservation_Util.PrintLn('1. Updating pending txn with qty '||l_dflt_nonctl_tran_rec.trans_qty );
2707: l_dflt_nonctl_tran_rec.staged_ind := 0;
2708: l_dflt_nonctl_tran_rec.line_detail_id := null;
2709:
2710: /* Updating the default transaction with backordered quantity */
2724: l_dflt_nonctl_tran_rec.staged_ind := 1;
2725: l_dflt_nonctl_tran_rec.trans_qty := -1 * x_available_qty;
2726: l_dflt_nonctl_tran_rec.trans_qty2 := -1 * x_available_qty2;
2727:
2728: GMI_Reservation_Util.PrintLn('1. creating new pending txn with avail qty '||l_dflt_nonctl_tran_rec.trans_qty );
2729:
2730: /* Creating a new transaction with the staged quantity */
2731: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
2732: ( p_api_version => 1.0
2740: , x_msg_data => x_msg_data
2741: );
2742:
2743: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2744: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
2745: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
2746: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2747: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
2748: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
2742:
2743: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2744: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
2745: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
2746: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2747: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
2748: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
2749: FND_MESSAGE.Set_Token('WHERE','Create_Default_Lot');
2750: FND_MSG_PUB.Add;
2757:
2758: l_dflt_nonctl_tran_rec.trans_qty := (-1) *(ABS(l_dflt_nonctl_tran_rec.trans_qty) - p_requested_qty);
2759: l_dflt_nonctl_tran_rec.trans_qty2 := (-1) *(ABS(l_dflt_nonctl_tran_rec.trans_qty2) - p_requested_qty2);
2760:
2761: GMI_Reservation_Util.PrintLn('2. Updating pending txn with qty '||l_dflt_nonctl_tran_rec.trans_qty );
2762:
2763: l_dflt_nonctl_tran_rec.staged_ind := 0;
2764: l_dflt_nonctl_tran_rec.line_detail_id := null;
2765:
2775: ,x_msg_count => x_msg_count
2776: ,x_msg_data => x_msg_data);
2777:
2778: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2779: GMI_reservation_Util.PrintLn('(opm_dbg) in PICK_CONFIRM:
2780: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.' );
2781: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2782: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2783: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
2777:
2778: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2779: GMI_reservation_Util.PrintLn('(opm_dbg) in PICK_CONFIRM:
2780: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.' );
2781: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2782: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2783: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
2784: FND_MESSAGE.Set_Token('WHERE', 'PICK_CONFIRM');
2785: FND_MSG_PUB.Add;
2791: l_dflt_nonctl_tran_rec.staged_ind := 1;
2792: l_dflt_nonctl_tran_rec.trans_qty := -1 * p_requested_qty;
2793: l_dflt_nonctl_tran_rec.trans_qty2 := -1 * p_requested_qty2;
2794:
2795: GMI_Reservation_Util.PrintLn('2. creating new pending txn with req qty '||l_dflt_nonctl_tran_rec.trans_qty );
2796:
2797: /* Creating a new transaction with the staged quantity */
2798: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
2799: ( p_api_version => 1.0
2807: , x_msg_data => x_msg_data
2808: );
2809:
2810: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2811: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
2812: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
2813: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2814: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
2815: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
2809:
2810: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2811: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
2812: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
2813: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2814: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
2815: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
2816: FND_MESSAGE.Set_Token('WHERE','PICK_CONFIRM');
2817: FND_MSG_PUB.Add;
2822:
2823: l_dflt_nonctl_tran_rec.line_detail_id := p_delivery_detail_id;
2824: l_dflt_nonctl_tran_rec.staged_ind := 1;
2825:
2826: GMI_Reservation_Util.PrintLn('3. Updating pending txn with staged ind/delivery id');
2827:
2828: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION(
2829: p_api_version => 1.0
2830: ,p_init_msg_list => FND_API.G_FALSE
2836: ,x_msg_count => x_msg_count
2837: ,x_msg_data => x_msg_data);
2838:
2839: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2840: GMI_reservation_Util.PrintLn('(opm_dbg) in PICK_CONFIRM:
2841: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.' );
2842: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2843: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2844: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
2838:
2839: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2840: GMI_reservation_Util.PrintLn('(opm_dbg) in PICK_CONFIRM:
2841: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.' );
2842: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2843: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2844: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
2845: FND_MESSAGE.Set_Token('WHERE', 'PICK_CONFIRM');
2846: FND_MSG_PUB.Add;
2860: , x_msg_data => x_msg_data
2861: , x_pick_slip_number => l_pick_slip_number
2862: );
2863:
2864: GMI_reservation_Util.PrintLn('pick slip number is '|| l_pick_slip_number);
2865:
2866: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
2867: THEN
2868: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_lots: Error returned by GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip.', 'pick_lots.log');
2864: GMI_reservation_Util.PrintLn('pick slip number is '|| l_pick_slip_number);
2865:
2866: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
2867: THEN
2868: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_lots: Error returned by GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip.', 'pick_lots.log');
2869: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2870: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip');
2871: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2872: FND_MSG_PUB.Add;
2872: FND_MSG_PUB.Add;
2873: RAISE FND_API.G_EXC_ERROR;
2874: END IF;
2875:
2876: GMI_reservation_Util.PrintLn('l_tran_row.trans_id '||l_tran_row.trans_id );
2877: UPDATE ic_tran_pnd
2878: SET pick_slip_number = l_pick_slip_number
2879: WHERE trans_id = l_tran_row.trans_id;
2880:
2968: l_TRUNCATE_TO_LENGTH CONSTANT INTEGER := 5;
2969:
2970: BEGIN
2971: x_return_status := FND_API.G_RET_STS_SUCCESS;
2972: GMI_Reservation_Util.PrintLn('Inside truncate_trans_qty');
2973: GMI_Reservation_Util.PrintLn('Parameters- p_line_id:'||p_line_id||', p_delivery_detail_id:'||p_delivery_detail_id||', p_default_location:'||p_default_location);
2974: IF (is_lot_loct_ctl = TRUE) THEN
2975: FOR lot_loct_ctl_trans_rec in lot_loct_ctl_trans
2976: LOOP
2969:
2970: BEGIN
2971: x_return_status := FND_API.G_RET_STS_SUCCESS;
2972: GMI_Reservation_Util.PrintLn('Inside truncate_trans_qty');
2973: GMI_Reservation_Util.PrintLn('Parameters- p_line_id:'||p_line_id||', p_delivery_detail_id:'||p_delivery_detail_id||', p_default_location:'||p_default_location);
2974: IF (is_lot_loct_ctl = TRUE) THEN
2975: FOR lot_loct_ctl_trans_rec in lot_loct_ctl_trans
2976: LOOP
2977: update ic_tran_pnd
2977: update ic_tran_pnd
2978: set trans_qty = trunc (trans_qty, l_TRUNCATE_TO_LENGTH),
2979: trans_qty2= trunc (trans_qty2, l_TRUNCATE_TO_LENGTH)
2980: where current of lot_loct_ctl_trans;
2981: GMI_Reservation_Util.PrintLn('Truncated transaction with trans_id: '||lot_loct_ctl_trans_rec.trans_id||' to '||l_TRUNCATE_TO_LENGTH||'th decimal');
2982: END LOOP;
2983: END IF;
2984:
2985: EXCEPTION
2983: END IF;
2984:
2985: EXCEPTION
2986: WHEN OTHERS THEN
2987: gmi_reservation_util.println(SQLERRM);
2988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2989: END truncate_trans_qty;
2990:
2991: PROCEDURE dump_shp_attrb_data (p_shipping_attr IN WSH_INTERFACE.ChangedAttributeTabType) IS
2989: END truncate_trans_qty;
2990:
2991: PROCEDURE dump_shp_attrb_data (p_shipping_attr IN WSH_INTERFACE.ChangedAttributeTabType) IS
2992: BEGIN
2993: gmi_reservation_util.println('Writing Data from dump_shp_attrb_data');
2994: GMI_Reservation_Util.PrintLn('Delivery Detail ID - '||p_shipping_attr(1).delivery_detail_id);
2995: GMI_Reservation_Util.PrintLn('Line ID - '||p_shipping_attr(1).source_line_id);
2996: GMI_Reservation_Util.PrintLn('Action Flag - '||p_shipping_attr(1).action_flag);
2997: GMI_Reservation_Util.PrintLn('ordered_quantity1 - '||p_shipping_attr(1).ordered_quantity);
2990:
2991: PROCEDURE dump_shp_attrb_data (p_shipping_attr IN WSH_INTERFACE.ChangedAttributeTabType) IS
2992: BEGIN
2993: gmi_reservation_util.println('Writing Data from dump_shp_attrb_data');
2994: GMI_Reservation_Util.PrintLn('Delivery Detail ID - '||p_shipping_attr(1).delivery_detail_id);
2995: GMI_Reservation_Util.PrintLn('Line ID - '||p_shipping_attr(1).source_line_id);
2996: GMI_Reservation_Util.PrintLn('Action Flag - '||p_shipping_attr(1).action_flag);
2997: GMI_Reservation_Util.PrintLn('ordered_quantity1 - '||p_shipping_attr(1).ordered_quantity);
2998: GMI_Reservation_Util.PrintLn('ordered_quantity2 - '||p_shipping_attr(1).ordered_quantity2);
2991: PROCEDURE dump_shp_attrb_data (p_shipping_attr IN WSH_INTERFACE.ChangedAttributeTabType) IS
2992: BEGIN
2993: gmi_reservation_util.println('Writing Data from dump_shp_attrb_data');
2994: GMI_Reservation_Util.PrintLn('Delivery Detail ID - '||p_shipping_attr(1).delivery_detail_id);
2995: GMI_Reservation_Util.PrintLn('Line ID - '||p_shipping_attr(1).source_line_id);
2996: GMI_Reservation_Util.PrintLn('Action Flag - '||p_shipping_attr(1).action_flag);
2997: GMI_Reservation_Util.PrintLn('ordered_quantity1 - '||p_shipping_attr(1).ordered_quantity);
2998: GMI_Reservation_Util.PrintLn('ordered_quantity2 - '||p_shipping_attr(1).ordered_quantity2);
2999: GMI_Reservation_Util.PrintLn('Backorder quantity1 - '||p_shipping_attr(1).cycle_count_quantity);
2992: BEGIN
2993: gmi_reservation_util.println('Writing Data from dump_shp_attrb_data');
2994: GMI_Reservation_Util.PrintLn('Delivery Detail ID - '||p_shipping_attr(1).delivery_detail_id);
2995: GMI_Reservation_Util.PrintLn('Line ID - '||p_shipping_attr(1).source_line_id);
2996: GMI_Reservation_Util.PrintLn('Action Flag - '||p_shipping_attr(1).action_flag);
2997: GMI_Reservation_Util.PrintLn('ordered_quantity1 - '||p_shipping_attr(1).ordered_quantity);
2998: GMI_Reservation_Util.PrintLn('ordered_quantity2 - '||p_shipping_attr(1).ordered_quantity2);
2999: GMI_Reservation_Util.PrintLn('Backorder quantity1 - '||p_shipping_attr(1).cycle_count_quantity);
3000: GMI_Reservation_Util.PrintLn('Backorder quantity2 - '||p_shipping_attr(1).cycle_count_quantity2);
2993: gmi_reservation_util.println('Writing Data from dump_shp_attrb_data');
2994: GMI_Reservation_Util.PrintLn('Delivery Detail ID - '||p_shipping_attr(1).delivery_detail_id);
2995: GMI_Reservation_Util.PrintLn('Line ID - '||p_shipping_attr(1).source_line_id);
2996: GMI_Reservation_Util.PrintLn('Action Flag - '||p_shipping_attr(1).action_flag);
2997: GMI_Reservation_Util.PrintLn('ordered_quantity1 - '||p_shipping_attr(1).ordered_quantity);
2998: GMI_Reservation_Util.PrintLn('ordered_quantity2 - '||p_shipping_attr(1).ordered_quantity2);
2999: GMI_Reservation_Util.PrintLn('Backorder quantity1 - '||p_shipping_attr(1).cycle_count_quantity);
3000: GMI_Reservation_Util.PrintLn('Backorder quantity2 - '||p_shipping_attr(1).cycle_count_quantity2);
3001: GMI_Reservation_Util.PrintLn('Released Status - '||p_shipping_attr(1).released_status);
2994: GMI_Reservation_Util.PrintLn('Delivery Detail ID - '||p_shipping_attr(1).delivery_detail_id);
2995: GMI_Reservation_Util.PrintLn('Line ID - '||p_shipping_attr(1).source_line_id);
2996: GMI_Reservation_Util.PrintLn('Action Flag - '||p_shipping_attr(1).action_flag);
2997: GMI_Reservation_Util.PrintLn('ordered_quantity1 - '||p_shipping_attr(1).ordered_quantity);
2998: GMI_Reservation_Util.PrintLn('ordered_quantity2 - '||p_shipping_attr(1).ordered_quantity2);
2999: GMI_Reservation_Util.PrintLn('Backorder quantity1 - '||p_shipping_attr(1).cycle_count_quantity);
3000: GMI_Reservation_Util.PrintLn('Backorder quantity2 - '||p_shipping_attr(1).cycle_count_quantity2);
3001: GMI_Reservation_Util.PrintLn('Released Status - '||p_shipping_attr(1).released_status);
3002: GMI_Reservation_Util.PrintLn('picked_quantity1 - '||p_shipping_attr(1).picked_quantity);
2995: GMI_Reservation_Util.PrintLn('Line ID - '||p_shipping_attr(1).source_line_id);
2996: GMI_Reservation_Util.PrintLn('Action Flag - '||p_shipping_attr(1).action_flag);
2997: GMI_Reservation_Util.PrintLn('ordered_quantity1 - '||p_shipping_attr(1).ordered_quantity);
2998: GMI_Reservation_Util.PrintLn('ordered_quantity2 - '||p_shipping_attr(1).ordered_quantity2);
2999: GMI_Reservation_Util.PrintLn('Backorder quantity1 - '||p_shipping_attr(1).cycle_count_quantity);
3000: GMI_Reservation_Util.PrintLn('Backorder quantity2 - '||p_shipping_attr(1).cycle_count_quantity2);
3001: GMI_Reservation_Util.PrintLn('Released Status - '||p_shipping_attr(1).released_status);
3002: GMI_Reservation_Util.PrintLn('picked_quantity1 - '||p_shipping_attr(1).picked_quantity);
3003: GMI_Reservation_Util.PrintLn('picked_quantity2 - '||p_shipping_attr(1).picked_quantity2);
2996: GMI_Reservation_Util.PrintLn('Action Flag - '||p_shipping_attr(1).action_flag);
2997: GMI_Reservation_Util.PrintLn('ordered_quantity1 - '||p_shipping_attr(1).ordered_quantity);
2998: GMI_Reservation_Util.PrintLn('ordered_quantity2 - '||p_shipping_attr(1).ordered_quantity2);
2999: GMI_Reservation_Util.PrintLn('Backorder quantity1 - '||p_shipping_attr(1).cycle_count_quantity);
3000: GMI_Reservation_Util.PrintLn('Backorder quantity2 - '||p_shipping_attr(1).cycle_count_quantity2);
3001: GMI_Reservation_Util.PrintLn('Released Status - '||p_shipping_attr(1).released_status);
3002: GMI_Reservation_Util.PrintLn('picked_quantity1 - '||p_shipping_attr(1).picked_quantity);
3003: GMI_Reservation_Util.PrintLn('picked_quantity2 - '||p_shipping_attr(1).picked_quantity2);
3004: GMI_Reservation_Util.PrintLn('pending_quantity1 - '||p_shipping_attr(1).pending_quantity);
2997: GMI_Reservation_Util.PrintLn('ordered_quantity1 - '||p_shipping_attr(1).ordered_quantity);
2998: GMI_Reservation_Util.PrintLn('ordered_quantity2 - '||p_shipping_attr(1).ordered_quantity2);
2999: GMI_Reservation_Util.PrintLn('Backorder quantity1 - '||p_shipping_attr(1).cycle_count_quantity);
3000: GMI_Reservation_Util.PrintLn('Backorder quantity2 - '||p_shipping_attr(1).cycle_count_quantity2);
3001: GMI_Reservation_Util.PrintLn('Released Status - '||p_shipping_attr(1).released_status);
3002: GMI_Reservation_Util.PrintLn('picked_quantity1 - '||p_shipping_attr(1).picked_quantity);
3003: GMI_Reservation_Util.PrintLn('picked_quantity2 - '||p_shipping_attr(1).picked_quantity2);
3004: GMI_Reservation_Util.PrintLn('pending_quantity1 - '||p_shipping_attr(1).pending_quantity);
3005: GMI_Reservation_Util.PrintLn('pending_quantity2 - '||p_shipping_attr(1).pending_quantity2);
2998: GMI_Reservation_Util.PrintLn('ordered_quantity2 - '||p_shipping_attr(1).ordered_quantity2);
2999: GMI_Reservation_Util.PrintLn('Backorder quantity1 - '||p_shipping_attr(1).cycle_count_quantity);
3000: GMI_Reservation_Util.PrintLn('Backorder quantity2 - '||p_shipping_attr(1).cycle_count_quantity2);
3001: GMI_Reservation_Util.PrintLn('Released Status - '||p_shipping_attr(1).released_status);
3002: GMI_Reservation_Util.PrintLn('picked_quantity1 - '||p_shipping_attr(1).picked_quantity);
3003: GMI_Reservation_Util.PrintLn('picked_quantity2 - '||p_shipping_attr(1).picked_quantity2);
3004: GMI_Reservation_Util.PrintLn('pending_quantity1 - '||p_shipping_attr(1).pending_quantity);
3005: GMI_Reservation_Util.PrintLn('pending_quantity2 - '||p_shipping_attr(1).pending_quantity2);
3006: END dump_shp_attrb_data;
2999: GMI_Reservation_Util.PrintLn('Backorder quantity1 - '||p_shipping_attr(1).cycle_count_quantity);
3000: GMI_Reservation_Util.PrintLn('Backorder quantity2 - '||p_shipping_attr(1).cycle_count_quantity2);
3001: GMI_Reservation_Util.PrintLn('Released Status - '||p_shipping_attr(1).released_status);
3002: GMI_Reservation_Util.PrintLn('picked_quantity1 - '||p_shipping_attr(1).picked_quantity);
3003: GMI_Reservation_Util.PrintLn('picked_quantity2 - '||p_shipping_attr(1).picked_quantity2);
3004: GMI_Reservation_Util.PrintLn('pending_quantity1 - '||p_shipping_attr(1).pending_quantity);
3005: GMI_Reservation_Util.PrintLn('pending_quantity2 - '||p_shipping_attr(1).pending_quantity2);
3006: END dump_shp_attrb_data;
3007:
3000: GMI_Reservation_Util.PrintLn('Backorder quantity2 - '||p_shipping_attr(1).cycle_count_quantity2);
3001: GMI_Reservation_Util.PrintLn('Released Status - '||p_shipping_attr(1).released_status);
3002: GMI_Reservation_Util.PrintLn('picked_quantity1 - '||p_shipping_attr(1).picked_quantity);
3003: GMI_Reservation_Util.PrintLn('picked_quantity2 - '||p_shipping_attr(1).picked_quantity2);
3004: GMI_Reservation_Util.PrintLn('pending_quantity1 - '||p_shipping_attr(1).pending_quantity);
3005: GMI_Reservation_Util.PrintLn('pending_quantity2 - '||p_shipping_attr(1).pending_quantity2);
3006: END dump_shp_attrb_data;
3007:
3008:
3001: GMI_Reservation_Util.PrintLn('Released Status - '||p_shipping_attr(1).released_status);
3002: GMI_Reservation_Util.PrintLn('picked_quantity1 - '||p_shipping_attr(1).picked_quantity);
3003: GMI_Reservation_Util.PrintLn('picked_quantity2 - '||p_shipping_attr(1).picked_quantity2);
3004: GMI_Reservation_Util.PrintLn('pending_quantity1 - '||p_shipping_attr(1).pending_quantity);
3005: GMI_Reservation_Util.PrintLn('pending_quantity2 - '||p_shipping_attr(1).pending_quantity2);
3006: END dump_shp_attrb_data;
3007:
3008:
3009: END GMI_PICK_WAVE_CONFIRM_PVT;