[Home] [Help]
207: AND OD.LINE_LOCATION_ID = RT.PO_LINE_LOCATION_ID
208: AND RT.TRANSACTION_ID = l_transaction_id
209: ORDER BY 1 desc;
210: --
211: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
212: --
213: -- MOAC
214: l_access_mode VARCHAR2(1);
215: l_current_org_id NUMBER;
216: l_reset_policy BOOLEAN;
217: BEGIN
218:
219: IF l_debug_level > 0 THEN
220: oe_debug_pub.add('*** Entering Dropshipreceive() in OE_DS_PVT *** ' , 1 ) ;
221: oe_debug_pub.add('Proces Online Mode:'||p_mode , 1 ) ;
222: oe_debug_pub.add('Transaction ID :' || P_RCV_TRANSACTION_ID , 1 ) ;
223: oe_debug_pub.add('Application Short Name :' || P_APPLICATION_SHORT_NAME , 1 ) ;
224: END IF;
217: BEGIN
218:
219: IF l_debug_level > 0 THEN
220: oe_debug_pub.add('*** Entering Dropshipreceive() in OE_DS_PVT *** ' , 1 ) ;
221: oe_debug_pub.add('Proces Online Mode:'||p_mode , 1 ) ;
222: oe_debug_pub.add('Transaction ID :' || P_RCV_TRANSACTION_ID , 1 ) ;
223: oe_debug_pub.add('Application Short Name :' || P_APPLICATION_SHORT_NAME , 1 ) ;
224: END IF;
225:
218:
219: IF l_debug_level > 0 THEN
220: oe_debug_pub.add('*** Entering Dropshipreceive() in OE_DS_PVT *** ' , 1 ) ;
221: oe_debug_pub.add('Proces Online Mode:'||p_mode , 1 ) ;
222: oe_debug_pub.add('Transaction ID :' || P_RCV_TRANSACTION_ID , 1 ) ;
223: oe_debug_pub.add('Application Short Name :' || P_APPLICATION_SHORT_NAME , 1 ) ;
224: END IF;
225:
226: l_access_mode := mo_global.Get_access_mode(); -- MOAC
219: IF l_debug_level > 0 THEN
220: oe_debug_pub.add('*** Entering Dropshipreceive() in OE_DS_PVT *** ' , 1 ) ;
221: oe_debug_pub.add('Proces Online Mode:'||p_mode , 1 ) ;
222: oe_debug_pub.add('Transaction ID :' || P_RCV_TRANSACTION_ID , 1 ) ;
223: oe_debug_pub.add('Application Short Name :' || P_APPLICATION_SHORT_NAME , 1 ) ;
224: END IF;
225:
226: l_access_mode := mo_global.Get_access_mode(); -- MOAC
227: l_current_org_id := mo_global.get_current_org_id();
242: END LOOP;
243:
244: IF l_line_id IS NULL THEN
245: IF l_debug_level > 0 THEN
246: oe_debug_pub.add( 'Unable to find the sales order identifier for this transaction '||sqlerrm , 1 ) ;
247: END IF;
248: IF l_debug_level > 0 THEN
249: oe_debug_pub.add( 'Dropshipreceive(), This may not be a dropship transaction ' , 1 ) ;
250: END IF;
245: IF l_debug_level > 0 THEN
246: oe_debug_pub.add( 'Unable to find the sales order identifier for this transaction '||sqlerrm , 1 ) ;
247: END IF;
248: IF l_debug_level > 0 THEN
249: oe_debug_pub.add( 'Dropshipreceive(), This may not be a dropship transaction ' , 1 ) ;
250: END IF;
251: RETURN TRUE;
252: END IF;
253: -- Bug 2407918}
273: WHEN OTHERS THEN
274: FND_MESSAGE.SET_NAME('OE','OE_VAL_ORDER_CREDIT');
275: OE_MSG_PUB.Add;
276: IF l_debug_level > 0 THEN
277: oe_debug_pub.add( 'Unable to find the sales order identifier in dropshipreceive()'||sqlerrm , 1 ) ;
278: END IF;
279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
280: END;
281:
305: FROM po_headers_all poh
306: WHERE poh.po_header_id = l_po_header_id;
307:
308: IF l_debug_level > 0 THEN
309: oe_debug_pub.add('SO Org Id: ' ||l_so_ou_id , 1 ) ;
310: oe_debug_pub.add('PO Org Id: ' ||l_po_ou_id , 1 ) ;
311: END IF;
312:
313: IF l_po_ou_id <> l_so_ou_id THEN
306: WHERE poh.po_header_id = l_po_header_id;
307:
308: IF l_debug_level > 0 THEN
309: oe_debug_pub.add('SO Org Id: ' ||l_so_ou_id , 1 ) ;
310: oe_debug_pub.add('PO Org Id: ' ||l_po_ou_id , 1 ) ;
311: END IF;
312:
313: IF l_po_ou_id <> l_so_ou_id THEN
314: -- MOAC
334: END IF;
335:
336:
337: IF l_debug_level > 0 THEN
338: oe_debug_pub.add('Transaction date : ' ||l_transaction_date , 1 ) ;
339: oe_debug_pub.add('Line ID : '||l_line_id||' already received qty => '||TO_CHAR ( l_orig_shipped) , 1 ) ;
340: END IF;
341:
342: l_order_uom := l_line_rec.order_quantity_uom;
335:
336:
337: IF l_debug_level > 0 THEN
338: oe_debug_pub.add('Transaction date : ' ||l_transaction_date , 1 ) ;
339: oe_debug_pub.add('Line ID : '||l_line_id||' already received qty => '||TO_CHAR ( l_orig_shipped) , 1 ) ;
340: END IF;
341:
342: l_order_uom := l_line_rec.order_quantity_uom;
343: l_orig_short_quantity := nvl(l_line_rec.ordered_quantity,0) - nvl(l_line_rec.shipped_quantity,0);
347: l_orig_short_quantity2 := nvl(l_line_rec.ordered_quantity2,0)
348: - nvl(l_line_rec.shipped_quantity2,0);
349:
350: IF l_debug_level > 0 THEN
351: oe_debug_pub.add( 'Open quantity in the sales order => ' || L_ORIG_SHORT_QUANTITY , 1 ) ;
352: END IF;
353: l_short_quantity := l_orig_short_quantity;
354: l_short_quantity2 := l_orig_short_quantity2;
355:
404: AND msinv.organization_id(+) = rt.organization_id
405: AND msinv.secondary_inventory_name(+) = rt.subinventory;
406:
407: IF l_debug_level > 0 THEN
408: oe_debug_pub.add( 'l_revision - '||L_REVISION ) ;
409: END IF;
410:
411:
412: EXCEPTION
411:
412: EXCEPTION
413: WHEN NO_DATA_FOUND THEN
414: IF l_debug_level > 0 THEN
415: oe_debug_pub.add( 'SQL: Fail to retrieve the receiving information '||sqlerrm , 1 ) ;
416: END IF;
417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
418: WHEN OTHERS THEN
419: IF l_debug_level > 0 THEN
416: END IF;
417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
418: WHEN OTHERS THEN
419: IF l_debug_level > 0 THEN
420: oe_debug_pub.add( 'Error while retrieving receiving information '||sqlerrm , 1 ) ;
421: END IF;
422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
423: END;
424:
422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
423: END;
424:
425: IF l_debug_level > 0 THEN
426: oe_debug_pub.add( 'Ordered uom code => '||L_ORDER_UOM , 5 ) ;
427: END IF;
428: IF l_debug_level > 0 THEN
429: oe_debug_pub.add( 'Received uom code => '||L_RCV_UOM , 5 ) ;
430: END IF;
425: IF l_debug_level > 0 THEN
426: oe_debug_pub.add( 'Ordered uom code => '||L_ORDER_UOM , 5 ) ;
427: END IF;
428: IF l_debug_level > 0 THEN
429: oe_debug_pub.add( 'Received uom code => '||L_RCV_UOM , 5 ) ;
430: END IF;
431:
432: IF l_debug_level > 0 THEN
433: oe_debug_pub.add( 'Receiving the items in the subinventory => '||L_SUBINVENTORY , 1 ) ;
429: oe_debug_pub.add( 'Received uom code => '||L_RCV_UOM , 5 ) ;
430: END IF;
431:
432: IF l_debug_level > 0 THEN
433: oe_debug_pub.add( 'Receiving the items in the subinventory => '||L_SUBINVENTORY , 1 ) ;
434: END IF;
435:
436: l_line_rec.subinventory := l_subinventory;
437:
469: END IF;
470:
471:
472: IF l_debug_level > 0 THEN
473: oe_debug_pub.add('Open qty available for receipt => ' || L_SHORT_QUANTITY , 1 ) ;
474: END IF;
475:
476: LOOP
477:
485: FROM dual;
486:
487: IF l_lot_quantity <> -1 THEN
488: IF l_debug_level > 0 THEN
489: oe_debug_pub.add(' Lot number => ' || l_lot , 5 ) ;
490: END IF;
491: IF l_debug_level > 0 THEN
492: oe_debug_pub.add(' Lot quantity => ' || l_lot_quantity , 5 ) ;
493: oe_debug_pub.add(' Lot quantity2 => ' || l_lot_quantity2 , 5 ) ; -- INVCONV
488: IF l_debug_level > 0 THEN
489: oe_debug_pub.add(' Lot number => ' || l_lot , 5 ) ;
490: END IF;
491: IF l_debug_level > 0 THEN
492: oe_debug_pub.add(' Lot quantity => ' || l_lot_quantity , 5 ) ;
493: oe_debug_pub.add(' Lot quantity2 => ' || l_lot_quantity2 , 5 ) ; -- INVCONV
494: END IF;
495: END IF;
496:
489: oe_debug_pub.add(' Lot number => ' || l_lot , 5 ) ;
490: END IF;
491: IF l_debug_level > 0 THEN
492: oe_debug_pub.add(' Lot quantity => ' || l_lot_quantity , 5 ) ;
493: oe_debug_pub.add(' Lot quantity2 => ' || l_lot_quantity2 , 5 ) ; -- INVCONV
494: END IF;
495: END IF;
496:
497: IF (l_lot_quantity <= 0) THEN
505: /* Reserve the quantities in this lot */
506:
507: IF l_order_uom <> l_rcv_uom THEN
508: IF l_debug_level > 0 THEN
509: oe_debug_pub.add( 'Converting the unit of measurement ' , 5 ) ;
510: END IF;
511: l_converted_qty := OE_ORDER_MISC_UTIL.CONVERT_UOM (l_item_id,l_rcv_uom,l_order_uom,l_lot_quantity);
512:
513: /* -- need forking for OPM UOM conv INVCONV
550: l_short_quantity2 := l_short_quantity2 - nvl(l_lot_quantity2,0);
551: l_add_to_shipped2 := l_add_to_shipped2 + nvl(l_lot_quantity2,0);
552: l_qty2_to_be_reserved := l_lot_quantity2; -- INVCONV
553: IF l_debug_level > 0 THEN
554: oe_debug_pub.add( 'Is subinventory reservable ? '||l_sub_reservable , 1 ) ;
555: END IF;
556:
557: BEGIN
558: SELECT NVL(reservable_type,2)
561: WHERE inventory_item_id = l_line_rec.inventory_item_id
562: AND organization_id = l_line_rec.ship_from_org_id;
563:
564: IF l_debug_level > 0 THEN
565: oe_debug_pub.add( 'Is item reservable ? '||l_item_reservable , 1 ) ;
566: END IF;
567:
568: EXCEPTION WHEN OTHERS THEN
569: IF l_debug_level > 0 THEN
566: END IF;
567:
568: EXCEPTION WHEN OTHERS THEN
569: IF l_debug_level > 0 THEN
570: oe_debug_pub.add( 'Error while checking item reservable ? '||sqlerrm , 1 ) ;
571: END IF;
572: l_item_reservable := 2;
573: END;
574:
592: -- bug 3544019
593:
594: IF l_return_status = FND_API.G_RET_STS_ERROR then
595: IF l_debug_level > 0 THEN
596: oe_debug_pub.add('Call to Create Reservation returned expected error '||sqlerrm,1) ;
597: END IF;
598: RAISE FND_API.G_EXC_ERROR;
599: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
600: IF l_debug_level > 0 THEN
597: END IF;
598: RAISE FND_API.G_EXC_ERROR;
599: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
600: IF l_debug_level > 0 THEN
601: oe_debug_pub.add('Call to Create Reservation returned unexpected error '||sqlerrm , 1 ) ;
602: END IF;
603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
604: END IF;
605:
604: END IF;
605:
606: ELSE
607: IF l_debug_level > 0 THEN
608: oe_debug_pub.add('Item OR Subinventory Non-reservable ' , 1 ) ;
609: END IF;
610: l_quantity_reserved := l_qty_to_be_reserved;
611: l_quantity2_reserved := l_qty2_to_be_reserved; -- INVCONV
612: END IF;
613:
614: END IF;
615:
616: IF l_debug_level > 0 THEN
617: oe_debug_pub.add( 'After reservation check' , 1 ) ;
618: END IF;
619:
620:
621: -- Decrement Inventory
627: /* forking code for OPM INVCONV NOT NEEDED NOW
628: IF (INV_GMI_RSV_BRANCH.Process_Branch(l_line_rec.ship_from_org_id))
629: THEN
630: IF l_debug_level > 0 THEN
631: oe_debug_pub.add( 'Calling decrement inventory for opm' , 1 ) ;
632: END IF;
633: Decrement_Inventory_for_OPM(
634: p_detail_id => l_rsv_id,
635: p_line_rec => l_line_rec,
649: p_as_alpha_prefix => l_as_alpha_prefix,
650: p_transaction_header_id => l_lot_set_id,
651: x_return_status => l_return_status);
652: IF l_debug_level > 0 THEN
653: oe_debug_pub.add('After calling decrement inventory for opm: ' || l_return_status,1) ;
654: END IF;
655: IF l_return_status = FND_API.G_RET_STS_ERROR then
656: RAISE FND_API.G_EXC_ERROR;
657: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
659: END IF;
660: ElSE */
661: IF l_debug_level > 0 THEN
662: oe_debug_pub.add( 'Calling decrement inventory()' , 1 ) ;
663: END IF;
664: Decrement_Inventory(
665: p_detail_id => l_rsv_id,
666: p_line_rec => l_line_rec,
682: p_transfer_lpn_id => l_transfer_lpn_id, --3544019
683: x_return_status => l_return_status);
684:
685: IF l_debug_level > 0 THEN
686: oe_debug_pub.add( 'After calling decrement inventory : ' || l_return_status,1) ;
687: END IF;
688:
689: IF l_return_status = FND_API.G_RET_STS_ERROR then
690: IF l_debug_level > 0 THEN
687: END IF;
688:
689: IF l_return_status = FND_API.G_RET_STS_ERROR then
690: IF l_debug_level > 0 THEN
691: oe_debug_pub.add( 'Call to decrementinventory() returned expected error '||sqlerrm,1) ;
692: END IF;
693: RAISE FND_API.G_EXC_ERROR;
694: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
695: IF l_debug_level > 0 THEN
692: END IF;
693: RAISE FND_API.G_EXC_ERROR;
694: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
695: IF l_debug_level > 0 THEN
696: oe_debug_pub.add( 'Call to decrementinventory() returned unexpected error '||sqlerrm , 1 ) ;
697: END IF;
698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
699: END IF; -- IF l_return_status = FND_API.G_RET_STS_ERROR then -- INVCONV
700: --END IF; -- INVCONV
711: << end_loop >>
712: CLOSE transaction_info;
713:
714: IF l_debug_level > 0 THEN
715: oe_debug_pub.add( 'Final open quantity in the sales order => '||l_short_quantity,1) ;
716: END IF;
717:
718: END;
719:
730: );
731:
732: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
733: IF l_debug_level > 0 THEN
734: oe_debug_pub.add('Call to process order returned unexpected error '||sqlerrm , 1 ) ;
735: END IF;
736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
737: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
738: IF l_debug_level > 0 THEN
735: END IF;
736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
737: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
738: IF l_debug_level > 0 THEN
739: oe_debug_pub.add('Call to process order returned expected error '||sqlerrm , 1 ) ;
740: END IF;
741: RAISE FND_API.G_EXC_ERROR;
742: END IF;
743:
756: END IF;
757:
758:
759: IF l_debug_level > 0 THEN
760: oe_debug_pub.add('Exiting dropshipreceive() successfully ' , 1 ) ;
761: END IF;
762:
763: OE_DEBUG_PUB.dumpdebug;
764: OE_DEBUG_PUB.Debug_Off;
759: IF l_debug_level > 0 THEN
760: oe_debug_pub.add('Exiting dropshipreceive() successfully ' , 1 ) ;
761: END IF;
762:
763: OE_DEBUG_PUB.dumpdebug;
764: OE_DEBUG_PUB.Debug_Off;
765:
766: RETURN TRUE;
767:
760: oe_debug_pub.add('Exiting dropshipreceive() successfully ' , 1 ) ;
761: END IF;
762:
763: OE_DEBUG_PUB.dumpdebug;
764: OE_DEBUG_PUB.Debug_Off;
765:
766: RETURN TRUE;
767:
768: EXCEPTION
767:
768: EXCEPTION
769: WHEN FND_API.G_EXC_ERROR THEN
770: IF l_debug_level > 0 THEN
771: oe_debug_pub.add( 'Exiting dropshipreceive with exp. error => '||sqlerrm , 1 ) ;
772: END IF;
773: OE_MSG_PUB.Save_API_Messages(); -- bug 4393738
774: OE_DEBUG_PUB.dumpdebug;
775: OE_DEBUG_PUB.Debug_Off;
770: IF l_debug_level > 0 THEN
771: oe_debug_pub.add( 'Exiting dropshipreceive with exp. error => '||sqlerrm , 1 ) ;
772: END IF;
773: OE_MSG_PUB.Save_API_Messages(); -- bug 4393738
774: OE_DEBUG_PUB.dumpdebug;
775: OE_DEBUG_PUB.Debug_Off;
776: RETURN FALSE;
777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
778: IF l_debug_level > 0 THEN
771: oe_debug_pub.add( 'Exiting dropshipreceive with exp. error => '||sqlerrm , 1 ) ;
772: END IF;
773: OE_MSG_PUB.Save_API_Messages(); -- bug 4393738
774: OE_DEBUG_PUB.dumpdebug;
775: OE_DEBUG_PUB.Debug_Off;
776: RETURN FALSE;
777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
778: IF l_debug_level > 0 THEN
779: oe_debug_pub.add( 'Exiting dropshipreceive with unexp. error => '||sqlerrm , 1 ) ;
775: OE_DEBUG_PUB.Debug_Off;
776: RETURN FALSE;
777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
778: IF l_debug_level > 0 THEN
779: oe_debug_pub.add( 'Exiting dropshipreceive with unexp. error => '||sqlerrm , 1 ) ;
780: END IF;
781: OE_MSG_PUB.Save_API_Messages(); -- bug 4393738
782: OE_DEBUG_PUB.dumpdebug;
783: OE_DEBUG_PUB.Debug_Off;
778: IF l_debug_level > 0 THEN
779: oe_debug_pub.add( 'Exiting dropshipreceive with unexp. error => '||sqlerrm , 1 ) ;
780: END IF;
781: OE_MSG_PUB.Save_API_Messages(); -- bug 4393738
782: OE_DEBUG_PUB.dumpdebug;
783: OE_DEBUG_PUB.Debug_Off;
784: RETURN FALSE;
785: WHEN OTHERS THEN
786: IF l_debug_level > 0 THEN
779: oe_debug_pub.add( 'Exiting dropshipreceive with unexp. error => '||sqlerrm , 1 ) ;
780: END IF;
781: OE_MSG_PUB.Save_API_Messages(); -- bug 4393738
782: OE_DEBUG_PUB.dumpdebug;
783: OE_DEBUG_PUB.Debug_Off;
784: RETURN FALSE;
785: WHEN OTHERS THEN
786: IF l_debug_level > 0 THEN
787: oe_debug_pub.add( 'Exiting dropshipreceive with others error => '||sqlerrm , 1 ) ;
783: OE_DEBUG_PUB.Debug_Off;
784: RETURN FALSE;
785: WHEN OTHERS THEN
786: IF l_debug_level > 0 THEN
787: oe_debug_pub.add( 'Exiting dropshipreceive with others error => '||sqlerrm , 1 ) ;
788: END IF;
789: OE_MSG_PUB.Save_API_Messages(); -- bug 4393738
790: OE_DEBUG_PUB.dumpdebug;
791: OE_DEBUG_PUB.Debug_Off;
786: IF l_debug_level > 0 THEN
787: oe_debug_pub.add( 'Exiting dropshipreceive with others error => '||sqlerrm , 1 ) ;
788: END IF;
789: OE_MSG_PUB.Save_API_Messages(); -- bug 4393738
790: OE_DEBUG_PUB.dumpdebug;
791: OE_DEBUG_PUB.Debug_Off;
792: RETURN FALSE;
793: END DropShipReceive;
794:
787: oe_debug_pub.add( 'Exiting dropshipreceive with others error => '||sqlerrm , 1 ) ;
788: END IF;
789: OE_MSG_PUB.Save_API_Messages(); -- bug 4393738
790: OE_DEBUG_PUB.dumpdebug;
791: OE_DEBUG_PUB.Debug_Off;
792: RETURN FALSE;
793: END DropShipReceive;
794:
795: /* --------------------------------------------------------------------
885: l_transaction_header_id NUMBER := p_transaction_header_id;
886: l_transaction_source_id NUMBER ; /* sales_order_id */
887: l_converted_qty NUMBER; -- Bug-2311061
888: l_primary_uom VARCHAR2(3); -- Bug-2908567
889: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
890: BEGIN
891:
892: IF l_debug_level > 0 THEN
893: oe_debug_pub.add(' Entering decrement inventory() ' ) ;
889: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
890: BEGIN
891:
892: IF l_debug_level > 0 THEN
893: oe_debug_pub.add(' Entering decrement inventory() ' ) ;
894: oe_debug_pub.add(' p_lot_number : ' || p_lot_number , 1 ) ;
895: oe_debug_pub.add(' p_revision : ' || p_revision , 1 ) ;
896: oe_debug_pub.add(' p_secondary_inventory : ' || p_secondary_inventory , 1 ) ;
897: oe_debug_pub.add(' p_inventory_item_id : ' || p_inventory_item_id , 1 ) ;
890: BEGIN
891:
892: IF l_debug_level > 0 THEN
893: oe_debug_pub.add(' Entering decrement inventory() ' ) ;
894: oe_debug_pub.add(' p_lot_number : ' || p_lot_number , 1 ) ;
895: oe_debug_pub.add(' p_revision : ' || p_revision , 1 ) ;
896: oe_debug_pub.add(' p_secondary_inventory : ' || p_secondary_inventory , 1 ) ;
897: oe_debug_pub.add(' p_inventory_item_id : ' || p_inventory_item_id , 1 ) ;
898: oe_debug_pub.add(' p_trx_uom : ' || p_trx_uom , 1 ) ;
891:
892: IF l_debug_level > 0 THEN
893: oe_debug_pub.add(' Entering decrement inventory() ' ) ;
894: oe_debug_pub.add(' p_lot_number : ' || p_lot_number , 1 ) ;
895: oe_debug_pub.add(' p_revision : ' || p_revision , 1 ) ;
896: oe_debug_pub.add(' p_secondary_inventory : ' || p_secondary_inventory , 1 ) ;
897: oe_debug_pub.add(' p_inventory_item_id : ' || p_inventory_item_id , 1 ) ;
898: oe_debug_pub.add(' p_trx_uom : ' || p_trx_uom , 1 ) ;
899: oe_debug_pub.add(' p_chart_of_accts : ' || p_chart_of_accts , 1 ) ;
892: IF l_debug_level > 0 THEN
893: oe_debug_pub.add(' Entering decrement inventory() ' ) ;
894: oe_debug_pub.add(' p_lot_number : ' || p_lot_number , 1 ) ;
895: oe_debug_pub.add(' p_revision : ' || p_revision , 1 ) ;
896: oe_debug_pub.add(' p_secondary_inventory : ' || p_secondary_inventory , 1 ) ;
897: oe_debug_pub.add(' p_inventory_item_id : ' || p_inventory_item_id , 1 ) ;
898: oe_debug_pub.add(' p_trx_uom : ' || p_trx_uom , 1 ) ;
899: oe_debug_pub.add(' p_chart_of_accts : ' || p_chart_of_accts , 1 ) ;
900: oe_debug_pub.add(' p_warehouse_id : ' || p_warehouse_id , 1 ) ;
893: oe_debug_pub.add(' Entering decrement inventory() ' ) ;
894: oe_debug_pub.add(' p_lot_number : ' || p_lot_number , 1 ) ;
895: oe_debug_pub.add(' p_revision : ' || p_revision , 1 ) ;
896: oe_debug_pub.add(' p_secondary_inventory : ' || p_secondary_inventory , 1 ) ;
897: oe_debug_pub.add(' p_inventory_item_id : ' || p_inventory_item_id , 1 ) ;
898: oe_debug_pub.add(' p_trx_uom : ' || p_trx_uom , 1 ) ;
899: oe_debug_pub.add(' p_chart_of_accts : ' || p_chart_of_accts , 1 ) ;
900: oe_debug_pub.add(' p_warehouse_id : ' || p_warehouse_id , 1 ) ;
901: oe_debug_pub.add(' p_as_alpha_prefix : ' || p_as_alpha_prefix , 1 ) ;
894: oe_debug_pub.add(' p_lot_number : ' || p_lot_number , 1 ) ;
895: oe_debug_pub.add(' p_revision : ' || p_revision , 1 ) ;
896: oe_debug_pub.add(' p_secondary_inventory : ' || p_secondary_inventory , 1 ) ;
897: oe_debug_pub.add(' p_inventory_item_id : ' || p_inventory_item_id , 1 ) ;
898: oe_debug_pub.add(' p_trx_uom : ' || p_trx_uom , 1 ) ;
899: oe_debug_pub.add(' p_chart_of_accts : ' || p_chart_of_accts , 1 ) ;
900: oe_debug_pub.add(' p_warehouse_id : ' || p_warehouse_id , 1 ) ;
901: oe_debug_pub.add(' p_as_alpha_prefix : ' || p_as_alpha_prefix , 1 ) ;
902: oe_debug_pub.add(' p_sn_control_code : ' || p_sn_control_code , 1 ) ;
895: oe_debug_pub.add(' p_revision : ' || p_revision , 1 ) ;
896: oe_debug_pub.add(' p_secondary_inventory : ' || p_secondary_inventory , 1 ) ;
897: oe_debug_pub.add(' p_inventory_item_id : ' || p_inventory_item_id , 1 ) ;
898: oe_debug_pub.add(' p_trx_uom : ' || p_trx_uom , 1 ) ;
899: oe_debug_pub.add(' p_chart_of_accts : ' || p_chart_of_accts , 1 ) ;
900: oe_debug_pub.add(' p_warehouse_id : ' || p_warehouse_id , 1 ) ;
901: oe_debug_pub.add(' p_as_alpha_prefix : ' || p_as_alpha_prefix , 1 ) ;
902: oe_debug_pub.add(' p_sn_control_code : ' || p_sn_control_code , 1 ) ;
903: oe_debug_pub.add(' p_transaction_id : ' || p_transaction_id , 1 ) ;
896: oe_debug_pub.add(' p_secondary_inventory : ' || p_secondary_inventory , 1 ) ;
897: oe_debug_pub.add(' p_inventory_item_id : ' || p_inventory_item_id , 1 ) ;
898: oe_debug_pub.add(' p_trx_uom : ' || p_trx_uom , 1 ) ;
899: oe_debug_pub.add(' p_chart_of_accts : ' || p_chart_of_accts , 1 ) ;
900: oe_debug_pub.add(' p_warehouse_id : ' || p_warehouse_id , 1 ) ;
901: oe_debug_pub.add(' p_as_alpha_prefix : ' || p_as_alpha_prefix , 1 ) ;
902: oe_debug_pub.add(' p_sn_control_code : ' || p_sn_control_code , 1 ) ;
903: oe_debug_pub.add(' p_transaction_id : ' || p_transaction_id , 1 ) ;
904: END IF;
897: oe_debug_pub.add(' p_inventory_item_id : ' || p_inventory_item_id , 1 ) ;
898: oe_debug_pub.add(' p_trx_uom : ' || p_trx_uom , 1 ) ;
899: oe_debug_pub.add(' p_chart_of_accts : ' || p_chart_of_accts , 1 ) ;
900: oe_debug_pub.add(' p_warehouse_id : ' || p_warehouse_id , 1 ) ;
901: oe_debug_pub.add(' p_as_alpha_prefix : ' || p_as_alpha_prefix , 1 ) ;
902: oe_debug_pub.add(' p_sn_control_code : ' || p_sn_control_code , 1 ) ;
903: oe_debug_pub.add(' p_transaction_id : ' || p_transaction_id , 1 ) ;
904: END IF;
905:
898: oe_debug_pub.add(' p_trx_uom : ' || p_trx_uom , 1 ) ;
899: oe_debug_pub.add(' p_chart_of_accts : ' || p_chart_of_accts , 1 ) ;
900: oe_debug_pub.add(' p_warehouse_id : ' || p_warehouse_id , 1 ) ;
901: oe_debug_pub.add(' p_as_alpha_prefix : ' || p_as_alpha_prefix , 1 ) ;
902: oe_debug_pub.add(' p_sn_control_code : ' || p_sn_control_code , 1 ) ;
903: oe_debug_pub.add(' p_transaction_id : ' || p_transaction_id , 1 ) ;
904: END IF;
905:
906: -- bug 5357879
899: oe_debug_pub.add(' p_chart_of_accts : ' || p_chart_of_accts , 1 ) ;
900: oe_debug_pub.add(' p_warehouse_id : ' || p_warehouse_id , 1 ) ;
901: oe_debug_pub.add(' p_as_alpha_prefix : ' || p_as_alpha_prefix , 1 ) ;
902: oe_debug_pub.add(' p_sn_control_code : ' || p_sn_control_code , 1 ) ;
903: oe_debug_pub.add(' p_transaction_id : ' || p_transaction_id , 1 ) ;
904: END IF;
905:
906: -- bug 5357879
907: SAVEPOINT DECREMENT_INV;
947: END IF;
948:
949:
950: IF l_debug_level > 0 THEN
951: oe_debug_pub.add( 'Transaction account id : ' ||l_trans_acc,1 ) ;
952: END IF;
953:
954:
955:
963: -- Change for #2736818
964: l_source_line_id := p_line_rec.line_id; -- Sales Order Line ID
965: l_lot_set_id := p_transaction_header_id;
966: IF l_debug_level > 0 THEN
967: oe_debug_pub.add( 'Source line id => ' || l_source_line_id , 1 ) ;
968: oe_debug_pub.add( 'Selecting unique id for this transaction' , 1 ) ;
969: oe_debug_pub.add( 'Transaction header ID :' || l_lot_set_id, 1 ) ;
970: END IF;
971:
964: l_source_line_id := p_line_rec.line_id; -- Sales Order Line ID
965: l_lot_set_id := p_transaction_header_id;
966: IF l_debug_level > 0 THEN
967: oe_debug_pub.add( 'Source line id => ' || l_source_line_id , 1 ) ;
968: oe_debug_pub.add( 'Selecting unique id for this transaction' , 1 ) ;
969: oe_debug_pub.add( 'Transaction header ID :' || l_lot_set_id, 1 ) ;
970: END IF;
971:
972: IF (p_lot_number is not null) THEN
965: l_lot_set_id := p_transaction_header_id;
966: IF l_debug_level > 0 THEN
967: oe_debug_pub.add( 'Source line id => ' || l_source_line_id , 1 ) ;
968: oe_debug_pub.add( 'Selecting unique id for this transaction' , 1 ) ;
969: oe_debug_pub.add( 'Transaction header ID :' || l_lot_set_id, 1 ) ;
970: END IF;
971:
972: IF (p_lot_number is not null) THEN
973:
973:
974: /* Insert lot transaction interface table */
975:
976: IF l_debug_level > 0 THEN
977: oe_debug_pub.add( 'Inserting lots' ) ;
978: END IF;
979: INSERT INTO MTL_TRANSACTION_LOTS_INTERFACE
980: (
981: SOURCE_CODE,
1050: and rt.transaction_id = p_transaction_id
1051: and rt.transaction_id = mmt.rcv_transaction_id
1052: and msn.last_txn_source_id = rt.po_header_id);
1053:
1054: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1055: BEGIN
1056:
1057: IF l_debug_level > 0 THEN
1058: oe_debug_pub.add( 'Inserting serial numbers after serial numbers fix' , 1 ) ;
1054: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1055: BEGIN
1056:
1057: IF l_debug_level > 0 THEN
1058: oe_debug_pub.add( 'Inserting serial numbers after serial numbers fix' , 1 ) ;
1059: END IF;
1060:
1061: IF (p_sn_control_code = 2 OR p_sn_control_code = 5) THEN
1062: IF l_debug_level > 0 THEN
1059: END IF;
1060:
1061: IF (p_sn_control_code = 2 OR p_sn_control_code = 5) THEN
1062: IF l_debug_level > 0 THEN
1063: oe_debug_pub.add( 'Serial control code = 2 or 5' , 1 ) ;
1064: END IF;
1065: OPEN get_received_serial_number;
1066: ELSIF (p_sn_control_code = 6) THEN
1067: IF l_debug_level > 0 THEN
1064: END IF;
1065: OPEN get_received_serial_number;
1066: ELSIF (p_sn_control_code = 6) THEN
1067: IF l_debug_level > 0 THEN
1068: oe_debug_pub.add( 'Serial control code = 6' , 1 ) ;
1069: END IF;
1070: END IF;
1071:
1072: serial_counter := 0;
1088: END ;
1089:
1090: IF l_primary_uom <> p_trx_uom THEN
1091: IF l_debug_level > 0 THEN
1092: oe_debug_pub.add('Converting the unit of measurement ' , 1 ) ;
1093: oe_debug_pub.add('Primary UOM:'||l_primary_uom , 1 ) ;
1094: oe_debug_pub.add('Transaction UOM:'||p_trx_uom , 1 ) ;
1095: END IF;
1096: l_converted_qty := OE_ORDER_MISC_UTIL.CONVERT_UOM (
1089:
1090: IF l_primary_uom <> p_trx_uom THEN
1091: IF l_debug_level > 0 THEN
1092: oe_debug_pub.add('Converting the unit of measurement ' , 1 ) ;
1093: oe_debug_pub.add('Primary UOM:'||l_primary_uom , 1 ) ;
1094: oe_debug_pub.add('Transaction UOM:'||p_trx_uom , 1 ) ;
1095: END IF;
1096: l_converted_qty := OE_ORDER_MISC_UTIL.CONVERT_UOM (
1097: p_line_rec.inventory_item_id,
1090: IF l_primary_uom <> p_trx_uom THEN
1091: IF l_debug_level > 0 THEN
1092: oe_debug_pub.add('Converting the unit of measurement ' , 1 ) ;
1093: oe_debug_pub.add('Primary UOM:'||l_primary_uom , 1 ) ;
1094: oe_debug_pub.add('Transaction UOM:'||p_trx_uom , 1 ) ;
1095: END IF;
1096: l_converted_qty := OE_ORDER_MISC_UTIL.CONVERT_UOM (
1097: p_line_rec.inventory_item_id,
1098: p_trx_uom,
1105: while serial_counter < l_converted_qty LOOP
1106:
1107: IF (p_sn_control_code = 6) THEN
1108: IF l_debug_level > 0 THEN
1109: oe_debug_pub.add( 'in for loop s.n control code = 6' , 1 ) ;
1110: END IF;
1111: SELECT to_char(oe_mtl_sn_interface_s.nextval)
1112: INTO v_serial_number_temp
1113: FROM dual ;
1116: ELSE
1117: v_serial_number := v_serial_number_temp;
1118: END IF;
1119: IF l_debug_level > 0 THEN
1120: oe_debug_pub.add( 'Final serial number is ' || V_SERIAL_NUMBER , 1 ) ;
1121: END IF;
1122: ELSIF (p_sn_control_code = 2 OR p_sn_control_code = 5) THEN
1123: IF l_debug_level > 0 THEN
1124: oe_debug_pub.add( 'Logic for s.n control code = 2 or 5 ' , 1 ) ;
1120: oe_debug_pub.add( 'Final serial number is ' || V_SERIAL_NUMBER , 1 ) ;
1121: END IF;
1122: ELSIF (p_sn_control_code = 2 OR p_sn_control_code = 5) THEN
1123: IF l_debug_level > 0 THEN
1124: oe_debug_pub.add( 'Logic for s.n control code = 2 or 5 ' , 1 ) ;
1125: END IF;
1126: FETCH get_received_serial_number INTO v_serial_number;
1127: IF l_debug_level > 0 THEN
1128: oe_debug_pub.add( 'Serial number fetched is => ' || v_serial_number , 1 ) ;
1124: oe_debug_pub.add( 'Logic for s.n control code = 2 or 5 ' , 1 ) ;
1125: END IF;
1126: FETCH get_received_serial_number INTO v_serial_number;
1127: IF l_debug_level > 0 THEN
1128: oe_debug_pub.add( 'Serial number fetched is => ' || v_serial_number , 1 ) ;
1129: END IF;
1130: END IF;
1131:
1132: BEGIN
1131:
1132: BEGIN
1133:
1134: IF l_debug_level > 0 THEN
1135: oe_debug_pub.add( 'Inserting into mtl_serial_numbers_interface table ' , 1 ) ;
1136: END IF;
1137:
1138: insert into mtl_serial_numbers_interface
1139: (transaction_interface_id,
1179:
1180: EXCEPTION
1181: WHEN OTHERS THEN
1182: IF l_debug_level > 0 THEN
1183: oe_debug_pub.add( 'Failed inserting into mtl_serial_numbers_interface' , 1 ) ;
1184: END IF;
1185: -- bug 5357879
1186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1187: ROLLBACK TO DECREMENT_INV;
1205: and nvl(current_locator_id,0) = nvl(p_locator_id,0)
1206: and serial_number = v_serial_number;
1207:
1208: IF l_debug_level > 0 THEN
1209: oe_debug_pub.add( 'Serial number updated is :' || v_serial_number , 1 ) ;
1210: END IF;
1211: EXCEPTION
1212: WHEN OTHERS THEN
1213: IF l_debug_level > 0 THEN
1210: END IF;
1211: EXCEPTION
1212: WHEN OTHERS THEN
1213: IF l_debug_level > 0 THEN
1214: oe_debug_pub.add( 'Updating serial numbers failed '||sqlerrm , 1 ) ;
1215: END IF;
1216:
1217: -- bug 5357879
1218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1232: p_sn_control_code = 5 OR
1233: p_sn_control_code = 6)
1234: THEN
1235: IF l_debug_level > 0 THEN
1236: oe_debug_pub.add( 'This is serial+lot controlled item' , 1 ) ;
1237: END IF;
1238:
1239: BEGIN
1240:
1244:
1245: EXCEPTION
1246: WHEN OTHERS THEN
1247: IF l_debug_level > 0 THEN
1248: oe_debug_pub.add( 'Updating serial_transaction_temp_id failed '||sqlerrm , 1 ) ;
1249: END IF;
1250:
1251: -- bug 5357879
1252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1265: l_transaction_interface_id := l_lot_set_id;
1266: end if;
1267:
1268: IF l_debug_level > 0 THEN
1269: oe_debug_pub.add( 'Populating transaction_interface_id in mti as '||L_TRANSACTION_INTERFACE_ID , 1 ) ;
1270: END IF;
1271:
1272: BEGIN
1273: SELECT RT.TRANSACTION_DATE
1297: l_transaction_date := sysdate;
1298: END; */
1299:
1300: IF l_debug_level > 0 THEN
1301: oe_debug_pub.add('Inserting header record' ) ;
1302: oe_debug_pub.add('Source_code : ' || fnd_profile.value ( 'ont_source_code' ) , 1 ) ;
1303: oe_debug_pub.add('Source_line_id : ' || l_source_line_id , 1 ) ;
1304: oe_debug_pub.add('Source_header_id : ' || l_transaction_reference , 1 ) ;
1305: oe_debug_pub.add('Process_flag : ' || 1 , 1 ) ;
1298: END; */
1299:
1300: IF l_debug_level > 0 THEN
1301: oe_debug_pub.add('Inserting header record' ) ;
1302: oe_debug_pub.add('Source_code : ' || fnd_profile.value ( 'ont_source_code' ) , 1 ) ;
1303: oe_debug_pub.add('Source_line_id : ' || l_source_line_id , 1 ) ;
1304: oe_debug_pub.add('Source_header_id : ' || l_transaction_reference , 1 ) ;
1305: oe_debug_pub.add('Process_flag : ' || 1 , 1 ) ;
1306: oe_debug_pub.add('Transaction_mode : ' || 1 , 1 ) ;
1299:
1300: IF l_debug_level > 0 THEN
1301: oe_debug_pub.add('Inserting header record' ) ;
1302: oe_debug_pub.add('Source_code : ' || fnd_profile.value ( 'ont_source_code' ) , 1 ) ;
1303: oe_debug_pub.add('Source_line_id : ' || l_source_line_id , 1 ) ;
1304: oe_debug_pub.add('Source_header_id : ' || l_transaction_reference , 1 ) ;
1305: oe_debug_pub.add('Process_flag : ' || 1 , 1 ) ;
1306: oe_debug_pub.add('Transaction_mode : ' || 1 , 1 ) ;
1307: oe_debug_pub.add('Lock_flag : ' || 2 , 1 ) ;
1300: IF l_debug_level > 0 THEN
1301: oe_debug_pub.add('Inserting header record' ) ;
1302: oe_debug_pub.add('Source_code : ' || fnd_profile.value ( 'ont_source_code' ) , 1 ) ;
1303: oe_debug_pub.add('Source_line_id : ' || l_source_line_id , 1 ) ;
1304: oe_debug_pub.add('Source_header_id : ' || l_transaction_reference , 1 ) ;
1305: oe_debug_pub.add('Process_flag : ' || 1 , 1 ) ;
1306: oe_debug_pub.add('Transaction_mode : ' || 1 , 1 ) ;
1307: oe_debug_pub.add('Lock_flag : ' || 2 , 1 ) ;
1308: oe_debug_pub.add('Transaction_header_id : ' || l_transaction_header_id , 1 ) ;
1301: oe_debug_pub.add('Inserting header record' ) ;
1302: oe_debug_pub.add('Source_code : ' || fnd_profile.value ( 'ont_source_code' ) , 1 ) ;
1303: oe_debug_pub.add('Source_line_id : ' || l_source_line_id , 1 ) ;
1304: oe_debug_pub.add('Source_header_id : ' || l_transaction_reference , 1 ) ;
1305: oe_debug_pub.add('Process_flag : ' || 1 , 1 ) ;
1306: oe_debug_pub.add('Transaction_mode : ' || 1 , 1 ) ;
1307: oe_debug_pub.add('Lock_flag : ' || 2 , 1 ) ;
1308: oe_debug_pub.add('Transaction_header_id : ' || l_transaction_header_id , 1 ) ;
1309: oe_debug_pub.add('Inventory_item_id : ' || p_inventory_item_id , 1 ) ;
1302: oe_debug_pub.add('Source_code : ' || fnd_profile.value ( 'ont_source_code' ) , 1 ) ;
1303: oe_debug_pub.add('Source_line_id : ' || l_source_line_id , 1 ) ;
1304: oe_debug_pub.add('Source_header_id : ' || l_transaction_reference , 1 ) ;
1305: oe_debug_pub.add('Process_flag : ' || 1 , 1 ) ;
1306: oe_debug_pub.add('Transaction_mode : ' || 1 , 1 ) ;
1307: oe_debug_pub.add('Lock_flag : ' || 2 , 1 ) ;
1308: oe_debug_pub.add('Transaction_header_id : ' || l_transaction_header_id , 1 ) ;
1309: oe_debug_pub.add('Inventory_item_id : ' || p_inventory_item_id , 1 ) ;
1310: oe_debug_pub.add('Subinventory_code : ' || p_secondary_inventory , 1 ) ;
1303: oe_debug_pub.add('Source_line_id : ' || l_source_line_id , 1 ) ;
1304: oe_debug_pub.add('Source_header_id : ' || l_transaction_reference , 1 ) ;
1305: oe_debug_pub.add('Process_flag : ' || 1 , 1 ) ;
1306: oe_debug_pub.add('Transaction_mode : ' || 1 , 1 ) ;
1307: oe_debug_pub.add('Lock_flag : ' || 2 , 1 ) ;
1308: oe_debug_pub.add('Transaction_header_id : ' || l_transaction_header_id , 1 ) ;
1309: oe_debug_pub.add('Inventory_item_id : ' || p_inventory_item_id , 1 ) ;
1310: oe_debug_pub.add('Subinventory_code : ' || p_secondary_inventory , 1 ) ;
1311: oe_debug_pub.add('Transaction_quantity : ' || ( -1 * p_transaction_detail_qty ) , 1 ) ;
1304: oe_debug_pub.add('Source_header_id : ' || l_transaction_reference , 1 ) ;
1305: oe_debug_pub.add('Process_flag : ' || 1 , 1 ) ;
1306: oe_debug_pub.add('Transaction_mode : ' || 1 , 1 ) ;
1307: oe_debug_pub.add('Lock_flag : ' || 2 , 1 ) ;
1308: oe_debug_pub.add('Transaction_header_id : ' || l_transaction_header_id , 1 ) ;
1309: oe_debug_pub.add('Inventory_item_id : ' || p_inventory_item_id , 1 ) ;
1310: oe_debug_pub.add('Subinventory_code : ' || p_secondary_inventory , 1 ) ;
1311: oe_debug_pub.add('Transaction_quantity : ' || ( -1 * p_transaction_detail_qty ) , 1 ) ;
1312: oe_debug_pub.add('Transaction_quantity2 : ' || ( -1 * p_trans_qty2 ) , 1 ) ; -- INVCONV
1305: oe_debug_pub.add('Process_flag : ' || 1 , 1 ) ;
1306: oe_debug_pub.add('Transaction_mode : ' || 1 , 1 ) ;
1307: oe_debug_pub.add('Lock_flag : ' || 2 , 1 ) ;
1308: oe_debug_pub.add('Transaction_header_id : ' || l_transaction_header_id , 1 ) ;
1309: oe_debug_pub.add('Inventory_item_id : ' || p_inventory_item_id , 1 ) ;
1310: oe_debug_pub.add('Subinventory_code : ' || p_secondary_inventory , 1 ) ;
1311: oe_debug_pub.add('Transaction_quantity : ' || ( -1 * p_transaction_detail_qty ) , 1 ) ;
1312: oe_debug_pub.add('Transaction_quantity2 : ' || ( -1 * p_trans_qty2 ) , 1 ) ; -- INVCONV
1313: oe_debug_pub.add('Transaction_date : ' || l_transaction_date , 1 ) ;
1306: oe_debug_pub.add('Transaction_mode : ' || 1 , 1 ) ;
1307: oe_debug_pub.add('Lock_flag : ' || 2 , 1 ) ;
1308: oe_debug_pub.add('Transaction_header_id : ' || l_transaction_header_id , 1 ) ;
1309: oe_debug_pub.add('Inventory_item_id : ' || p_inventory_item_id , 1 ) ;
1310: oe_debug_pub.add('Subinventory_code : ' || p_secondary_inventory , 1 ) ;
1311: oe_debug_pub.add('Transaction_quantity : ' || ( -1 * p_transaction_detail_qty ) , 1 ) ;
1312: oe_debug_pub.add('Transaction_quantity2 : ' || ( -1 * p_trans_qty2 ) , 1 ) ; -- INVCONV
1313: oe_debug_pub.add('Transaction_date : ' || l_transaction_date , 1 ) ;
1314: oe_debug_pub.add('Organization_id : ' || p_warehouse_id , 1 ) ;
1307: oe_debug_pub.add('Lock_flag : ' || 2 , 1 ) ;
1308: oe_debug_pub.add('Transaction_header_id : ' || l_transaction_header_id , 1 ) ;
1309: oe_debug_pub.add('Inventory_item_id : ' || p_inventory_item_id , 1 ) ;
1310: oe_debug_pub.add('Subinventory_code : ' || p_secondary_inventory , 1 ) ;
1311: oe_debug_pub.add('Transaction_quantity : ' || ( -1 * p_transaction_detail_qty ) , 1 ) ;
1312: oe_debug_pub.add('Transaction_quantity2 : ' || ( -1 * p_trans_qty2 ) , 1 ) ; -- INVCONV
1313: oe_debug_pub.add('Transaction_date : ' || l_transaction_date , 1 ) ;
1314: oe_debug_pub.add('Organization_id : ' || p_warehouse_id , 1 ) ;
1315: oe_debug_pub.add('Transfer_lpn_id : ' || p_transfer_lpn_id,1) ; -- 3544019
1308: oe_debug_pub.add('Transaction_header_id : ' || l_transaction_header_id , 1 ) ;
1309: oe_debug_pub.add('Inventory_item_id : ' || p_inventory_item_id , 1 ) ;
1310: oe_debug_pub.add('Subinventory_code : ' || p_secondary_inventory , 1 ) ;
1311: oe_debug_pub.add('Transaction_quantity : ' || ( -1 * p_transaction_detail_qty ) , 1 ) ;
1312: oe_debug_pub.add('Transaction_quantity2 : ' || ( -1 * p_trans_qty2 ) , 1 ) ; -- INVCONV
1313: oe_debug_pub.add('Transaction_date : ' || l_transaction_date , 1 ) ;
1314: oe_debug_pub.add('Organization_id : ' || p_warehouse_id , 1 ) ;
1315: oe_debug_pub.add('Transfer_lpn_id : ' || p_transfer_lpn_id,1) ; -- 3544019
1316: oe_debug_pub.add('Acct_period_id : ' || null , 1 ) ;
1309: oe_debug_pub.add('Inventory_item_id : ' || p_inventory_item_id , 1 ) ;
1310: oe_debug_pub.add('Subinventory_code : ' || p_secondary_inventory , 1 ) ;
1311: oe_debug_pub.add('Transaction_quantity : ' || ( -1 * p_transaction_detail_qty ) , 1 ) ;
1312: oe_debug_pub.add('Transaction_quantity2 : ' || ( -1 * p_trans_qty2 ) , 1 ) ; -- INVCONV
1313: oe_debug_pub.add('Transaction_date : ' || l_transaction_date , 1 ) ;
1314: oe_debug_pub.add('Organization_id : ' || p_warehouse_id , 1 ) ;
1315: oe_debug_pub.add('Transfer_lpn_id : ' || p_transfer_lpn_id,1) ; -- 3544019
1316: oe_debug_pub.add('Acct_period_id : ' || null , 1 ) ;
1317: oe_debug_pub.add('Last_update_date : ' || sysdate , 1 ) ;
1310: oe_debug_pub.add('Subinventory_code : ' || p_secondary_inventory , 1 ) ;
1311: oe_debug_pub.add('Transaction_quantity : ' || ( -1 * p_transaction_detail_qty ) , 1 ) ;
1312: oe_debug_pub.add('Transaction_quantity2 : ' || ( -1 * p_trans_qty2 ) , 1 ) ; -- INVCONV
1313: oe_debug_pub.add('Transaction_date : ' || l_transaction_date , 1 ) ;
1314: oe_debug_pub.add('Organization_id : ' || p_warehouse_id , 1 ) ;
1315: oe_debug_pub.add('Transfer_lpn_id : ' || p_transfer_lpn_id,1) ; -- 3544019
1316: oe_debug_pub.add('Acct_period_id : ' || null , 1 ) ;
1317: oe_debug_pub.add('Last_update_date : ' || sysdate , 1 ) ;
1318: oe_debug_pub.add('Last_updated_by : ' || fnd_global.user_id , 1 ) ;
1311: oe_debug_pub.add('Transaction_quantity : ' || ( -1 * p_transaction_detail_qty ) , 1 ) ;
1312: oe_debug_pub.add('Transaction_quantity2 : ' || ( -1 * p_trans_qty2 ) , 1 ) ; -- INVCONV
1313: oe_debug_pub.add('Transaction_date : ' || l_transaction_date , 1 ) ;
1314: oe_debug_pub.add('Organization_id : ' || p_warehouse_id , 1 ) ;
1315: oe_debug_pub.add('Transfer_lpn_id : ' || p_transfer_lpn_id,1) ; -- 3544019
1316: oe_debug_pub.add('Acct_period_id : ' || null , 1 ) ;
1317: oe_debug_pub.add('Last_update_date : ' || sysdate , 1 ) ;
1318: oe_debug_pub.add('Last_updated_by : ' || fnd_global.user_id , 1 ) ;
1319: oe_debug_pub.add('Creation_date : ' || sysdate , 1 ) ;
1312: oe_debug_pub.add('Transaction_quantity2 : ' || ( -1 * p_trans_qty2 ) , 1 ) ; -- INVCONV
1313: oe_debug_pub.add('Transaction_date : ' || l_transaction_date , 1 ) ;
1314: oe_debug_pub.add('Organization_id : ' || p_warehouse_id , 1 ) ;
1315: oe_debug_pub.add('Transfer_lpn_id : ' || p_transfer_lpn_id,1) ; -- 3544019
1316: oe_debug_pub.add('Acct_period_id : ' || null , 1 ) ;
1317: oe_debug_pub.add('Last_update_date : ' || sysdate , 1 ) ;
1318: oe_debug_pub.add('Last_updated_by : ' || fnd_global.user_id , 1 ) ;
1319: oe_debug_pub.add('Creation_date : ' || sysdate , 1 ) ;
1320: oe_debug_pub.add('Created_by : ' || fnd_global.user_id , 1 ) ;
1313: oe_debug_pub.add('Transaction_date : ' || l_transaction_date , 1 ) ;
1314: oe_debug_pub.add('Organization_id : ' || p_warehouse_id , 1 ) ;
1315: oe_debug_pub.add('Transfer_lpn_id : ' || p_transfer_lpn_id,1) ; -- 3544019
1316: oe_debug_pub.add('Acct_period_id : ' || null , 1 ) ;
1317: oe_debug_pub.add('Last_update_date : ' || sysdate , 1 ) ;
1318: oe_debug_pub.add('Last_updated_by : ' || fnd_global.user_id , 1 ) ;
1319: oe_debug_pub.add('Creation_date : ' || sysdate , 1 ) ;
1320: oe_debug_pub.add('Created_by : ' || fnd_global.user_id , 1 ) ;
1321: oe_debug_pub.add('Transaction_source_id : ' || l_transaction_source_id , 1 ) ;
1314: oe_debug_pub.add('Organization_id : ' || p_warehouse_id , 1 ) ;
1315: oe_debug_pub.add('Transfer_lpn_id : ' || p_transfer_lpn_id,1) ; -- 3544019
1316: oe_debug_pub.add('Acct_period_id : ' || null , 1 ) ;
1317: oe_debug_pub.add('Last_update_date : ' || sysdate , 1 ) ;
1318: oe_debug_pub.add('Last_updated_by : ' || fnd_global.user_id , 1 ) ;
1319: oe_debug_pub.add('Creation_date : ' || sysdate , 1 ) ;
1320: oe_debug_pub.add('Created_by : ' || fnd_global.user_id , 1 ) ;
1321: oe_debug_pub.add('Transaction_source_id : ' || l_transaction_source_id , 1 ) ;
1322: -- oe_debug_pub.add('Dsp_segment1 : ' || l_order_number , 1 ) ; bug 4456817
1315: oe_debug_pub.add('Transfer_lpn_id : ' || p_transfer_lpn_id,1) ; -- 3544019
1316: oe_debug_pub.add('Acct_period_id : ' || null , 1 ) ;
1317: oe_debug_pub.add('Last_update_date : ' || sysdate , 1 ) ;
1318: oe_debug_pub.add('Last_updated_by : ' || fnd_global.user_id , 1 ) ;
1319: oe_debug_pub.add('Creation_date : ' || sysdate , 1 ) ;
1320: oe_debug_pub.add('Created_by : ' || fnd_global.user_id , 1 ) ;
1321: oe_debug_pub.add('Transaction_source_id : ' || l_transaction_source_id , 1 ) ;
1322: -- oe_debug_pub.add('Dsp_segment1 : ' || l_order_number , 1 ) ; bug 4456817
1323: -- oe_debug_pub.add('Dsp_segment2 : ' || l_order_type_name , 1 ) ;
1316: oe_debug_pub.add('Acct_period_id : ' || null , 1 ) ;
1317: oe_debug_pub.add('Last_update_date : ' || sysdate , 1 ) ;
1318: oe_debug_pub.add('Last_updated_by : ' || fnd_global.user_id , 1 ) ;
1319: oe_debug_pub.add('Creation_date : ' || sysdate , 1 ) ;
1320: oe_debug_pub.add('Created_by : ' || fnd_global.user_id , 1 ) ;
1321: oe_debug_pub.add('Transaction_source_id : ' || l_transaction_source_id , 1 ) ;
1322: -- oe_debug_pub.add('Dsp_segment1 : ' || l_order_number , 1 ) ; bug 4456817
1323: -- oe_debug_pub.add('Dsp_segment2 : ' || l_order_type_name , 1 ) ;
1324: -- oe_debug_pub.add('Dsp_segment3 : ' || fnd_profile.value ( 'ont_source_code' ) , 1 ) ;
1317: oe_debug_pub.add('Last_update_date : ' || sysdate , 1 ) ;
1318: oe_debug_pub.add('Last_updated_by : ' || fnd_global.user_id , 1 ) ;
1319: oe_debug_pub.add('Creation_date : ' || sysdate , 1 ) ;
1320: oe_debug_pub.add('Created_by : ' || fnd_global.user_id , 1 ) ;
1321: oe_debug_pub.add('Transaction_source_id : ' || l_transaction_source_id , 1 ) ;
1322: -- oe_debug_pub.add('Dsp_segment1 : ' || l_order_number , 1 ) ; bug 4456817
1323: -- oe_debug_pub.add('Dsp_segment2 : ' || l_order_type_name , 1 ) ;
1324: -- oe_debug_pub.add('Dsp_segment3 : ' || fnd_profile.value ( 'ont_source_code' ) , 1 ) ;
1325: oe_debug_pub.add('Transaction_source_type_id : ' || l_trx_source_type_id , 1 ) ;
1318: oe_debug_pub.add('Last_updated_by : ' || fnd_global.user_id , 1 ) ;
1319: oe_debug_pub.add('Creation_date : ' || sysdate , 1 ) ;
1320: oe_debug_pub.add('Created_by : ' || fnd_global.user_id , 1 ) ;
1321: oe_debug_pub.add('Transaction_source_id : ' || l_transaction_source_id , 1 ) ;
1322: -- oe_debug_pub.add('Dsp_segment1 : ' || l_order_number , 1 ) ; bug 4456817
1323: -- oe_debug_pub.add('Dsp_segment2 : ' || l_order_type_name , 1 ) ;
1324: -- oe_debug_pub.add('Dsp_segment3 : ' || fnd_profile.value ( 'ont_source_code' ) , 1 ) ;
1325: oe_debug_pub.add('Transaction_source_type_id : ' || l_trx_source_type_id , 1 ) ;
1326: oe_debug_pub.add('Transaction_action_id : ' || l_trx_action_id , 1 ) ;
1319: oe_debug_pub.add('Creation_date : ' || sysdate , 1 ) ;
1320: oe_debug_pub.add('Created_by : ' || fnd_global.user_id , 1 ) ;
1321: oe_debug_pub.add('Transaction_source_id : ' || l_transaction_source_id , 1 ) ;
1322: -- oe_debug_pub.add('Dsp_segment1 : ' || l_order_number , 1 ) ; bug 4456817
1323: -- oe_debug_pub.add('Dsp_segment2 : ' || l_order_type_name , 1 ) ;
1324: -- oe_debug_pub.add('Dsp_segment3 : ' || fnd_profile.value ( 'ont_source_code' ) , 1 ) ;
1325: oe_debug_pub.add('Transaction_source_type_id : ' || l_trx_source_type_id , 1 ) ;
1326: oe_debug_pub.add('Transaction_action_id : ' || l_trx_action_id , 1 ) ;
1327: oe_debug_pub.add('Transaction_type_id : ' || l_trx_type_code , 1 ) ;
1320: oe_debug_pub.add('Created_by : ' || fnd_global.user_id , 1 ) ;
1321: oe_debug_pub.add('Transaction_source_id : ' || l_transaction_source_id , 1 ) ;
1322: -- oe_debug_pub.add('Dsp_segment1 : ' || l_order_number , 1 ) ; bug 4456817
1323: -- oe_debug_pub.add('Dsp_segment2 : ' || l_order_type_name , 1 ) ;
1324: -- oe_debug_pub.add('Dsp_segment3 : ' || fnd_profile.value ( 'ont_source_code' ) , 1 ) ;
1325: oe_debug_pub.add('Transaction_source_type_id : ' || l_trx_source_type_id , 1 ) ;
1326: oe_debug_pub.add('Transaction_action_id : ' || l_trx_action_id , 1 ) ;
1327: oe_debug_pub.add('Transaction_type_id : ' || l_trx_type_code , 1 ) ;
1328: oe_debug_pub.add('Distribution_account_id : ' || l_trans_acc , 1 ) ;
1321: oe_debug_pub.add('Transaction_source_id : ' || l_transaction_source_id , 1 ) ;
1322: -- oe_debug_pub.add('Dsp_segment1 : ' || l_order_number , 1 ) ; bug 4456817
1323: -- oe_debug_pub.add('Dsp_segment2 : ' || l_order_type_name , 1 ) ;
1324: -- oe_debug_pub.add('Dsp_segment3 : ' || fnd_profile.value ( 'ont_source_code' ) , 1 ) ;
1325: oe_debug_pub.add('Transaction_source_type_id : ' || l_trx_source_type_id , 1 ) ;
1326: oe_debug_pub.add('Transaction_action_id : ' || l_trx_action_id , 1 ) ;
1327: oe_debug_pub.add('Transaction_type_id : ' || l_trx_type_code , 1 ) ;
1328: oe_debug_pub.add('Distribution_account_id : ' || l_trans_acc , 1 ) ;
1329: oe_debug_pub.add('Transaction_reference : ' || l_transaction_reference , 1 ) ;
1322: -- oe_debug_pub.add('Dsp_segment1 : ' || l_order_number , 1 ) ; bug 4456817
1323: -- oe_debug_pub.add('Dsp_segment2 : ' || l_order_type_name , 1 ) ;
1324: -- oe_debug_pub.add('Dsp_segment3 : ' || fnd_profile.value ( 'ont_source_code' ) , 1 ) ;
1325: oe_debug_pub.add('Transaction_source_type_id : ' || l_trx_source_type_id , 1 ) ;
1326: oe_debug_pub.add('Transaction_action_id : ' || l_trx_action_id , 1 ) ;
1327: oe_debug_pub.add('Transaction_type_id : ' || l_trx_type_code , 1 ) ;
1328: oe_debug_pub.add('Distribution_account_id : ' || l_trans_acc , 1 ) ;
1329: oe_debug_pub.add('Transaction_reference : ' || l_transaction_reference , 1 ) ;
1330: oe_debug_pub.add('Trx_source_line_id : ' || l_line_id , 1 ) ;
1323: -- oe_debug_pub.add('Dsp_segment2 : ' || l_order_type_name , 1 ) ;
1324: -- oe_debug_pub.add('Dsp_segment3 : ' || fnd_profile.value ( 'ont_source_code' ) , 1 ) ;
1325: oe_debug_pub.add('Transaction_source_type_id : ' || l_trx_source_type_id , 1 ) ;
1326: oe_debug_pub.add('Transaction_action_id : ' || l_trx_action_id , 1 ) ;
1327: oe_debug_pub.add('Transaction_type_id : ' || l_trx_type_code , 1 ) ;
1328: oe_debug_pub.add('Distribution_account_id : ' || l_trans_acc , 1 ) ;
1329: oe_debug_pub.add('Transaction_reference : ' || l_transaction_reference , 1 ) ;
1330: oe_debug_pub.add('Trx_source_line_id : ' || l_line_id , 1 ) ;
1331: oe_debug_pub.add('Trx_source_delivery_id : ' || l_delivery , 1 ) ;
1324: -- oe_debug_pub.add('Dsp_segment3 : ' || fnd_profile.value ( 'ont_source_code' ) , 1 ) ;
1325: oe_debug_pub.add('Transaction_source_type_id : ' || l_trx_source_type_id , 1 ) ;
1326: oe_debug_pub.add('Transaction_action_id : ' || l_trx_action_id , 1 ) ;
1327: oe_debug_pub.add('Transaction_type_id : ' || l_trx_type_code , 1 ) ;
1328: oe_debug_pub.add('Distribution_account_id : ' || l_trans_acc , 1 ) ;
1329: oe_debug_pub.add('Transaction_reference : ' || l_transaction_reference , 1 ) ;
1330: oe_debug_pub.add('Trx_source_line_id : ' || l_line_id , 1 ) ;
1331: oe_debug_pub.add('Trx_source_delivery_id : ' || l_delivery , 1 ) ;
1332: oe_debug_pub.add('Revision : ' || p_revision , 1 ) ;
1325: oe_debug_pub.add('Transaction_source_type_id : ' || l_trx_source_type_id , 1 ) ;
1326: oe_debug_pub.add('Transaction_action_id : ' || l_trx_action_id , 1 ) ;
1327: oe_debug_pub.add('Transaction_type_id : ' || l_trx_type_code , 1 ) ;
1328: oe_debug_pub.add('Distribution_account_id : ' || l_trans_acc , 1 ) ;
1329: oe_debug_pub.add('Transaction_reference : ' || l_transaction_reference , 1 ) ;
1330: oe_debug_pub.add('Trx_source_line_id : ' || l_line_id , 1 ) ;
1331: oe_debug_pub.add('Trx_source_delivery_id : ' || l_delivery , 1 ) ;
1332: oe_debug_pub.add('Revision : ' || p_revision , 1 ) ;
1333: oe_debug_pub.add('Locator_id : ' || p_locator_id , 1 ) ;
1326: oe_debug_pub.add('Transaction_action_id : ' || l_trx_action_id , 1 ) ;
1327: oe_debug_pub.add('Transaction_type_id : ' || l_trx_type_code , 1 ) ;
1328: oe_debug_pub.add('Distribution_account_id : ' || l_trans_acc , 1 ) ;
1329: oe_debug_pub.add('Transaction_reference : ' || l_transaction_reference , 1 ) ;
1330: oe_debug_pub.add('Trx_source_line_id : ' || l_line_id , 1 ) ;
1331: oe_debug_pub.add('Trx_source_delivery_id : ' || l_delivery , 1 ) ;
1332: oe_debug_pub.add('Revision : ' || p_revision , 1 ) ;
1333: oe_debug_pub.add('Locator_id : ' || p_locator_id , 1 ) ;
1334: oe_debug_pub.add('Loc_segment1 : ' || null , 1 ) ;
1327: oe_debug_pub.add('Transaction_type_id : ' || l_trx_type_code , 1 ) ;
1328: oe_debug_pub.add('Distribution_account_id : ' || l_trans_acc , 1 ) ;
1329: oe_debug_pub.add('Transaction_reference : ' || l_transaction_reference , 1 ) ;
1330: oe_debug_pub.add('Trx_source_line_id : ' || l_line_id , 1 ) ;
1331: oe_debug_pub.add('Trx_source_delivery_id : ' || l_delivery , 1 ) ;
1332: oe_debug_pub.add('Revision : ' || p_revision , 1 ) ;
1333: oe_debug_pub.add('Locator_id : ' || p_locator_id , 1 ) ;
1334: oe_debug_pub.add('Loc_segment1 : ' || null , 1 ) ;
1335: oe_debug_pub.add('Loc_segment2 : ' || null , 1 ) ;
1328: oe_debug_pub.add('Distribution_account_id : ' || l_trans_acc , 1 ) ;
1329: oe_debug_pub.add('Transaction_reference : ' || l_transaction_reference , 1 ) ;
1330: oe_debug_pub.add('Trx_source_line_id : ' || l_line_id , 1 ) ;
1331: oe_debug_pub.add('Trx_source_delivery_id : ' || l_delivery , 1 ) ;
1332: oe_debug_pub.add('Revision : ' || p_revision , 1 ) ;
1333: oe_debug_pub.add('Locator_id : ' || p_locator_id , 1 ) ;
1334: oe_debug_pub.add('Loc_segment1 : ' || null , 1 ) ;
1335: oe_debug_pub.add('Loc_segment2 : ' || null , 1 ) ;
1336: oe_debug_pub.add('Loc_segment3 : ' || null , 1 ) ;
1329: oe_debug_pub.add('Transaction_reference : ' || l_transaction_reference , 1 ) ;
1330: oe_debug_pub.add('Trx_source_line_id : ' || l_line_id , 1 ) ;
1331: oe_debug_pub.add('Trx_source_delivery_id : ' || l_delivery , 1 ) ;
1332: oe_debug_pub.add('Revision : ' || p_revision , 1 ) ;
1333: oe_debug_pub.add('Locator_id : ' || p_locator_id , 1 ) ;
1334: oe_debug_pub.add('Loc_segment1 : ' || null , 1 ) ;
1335: oe_debug_pub.add('Loc_segment2 : ' || null , 1 ) ;
1336: oe_debug_pub.add('Loc_segment3 : ' || null , 1 ) ;
1337: oe_debug_pub.add('Loc_segment4 : ' || null , 1 ) ;
1330: oe_debug_pub.add('Trx_source_line_id : ' || l_line_id , 1 ) ;
1331: oe_debug_pub.add('Trx_source_delivery_id : ' || l_delivery , 1 ) ;
1332: oe_debug_pub.add('Revision : ' || p_revision , 1 ) ;
1333: oe_debug_pub.add('Locator_id : ' || p_locator_id , 1 ) ;
1334: oe_debug_pub.add('Loc_segment1 : ' || null , 1 ) ;
1335: oe_debug_pub.add('Loc_segment2 : ' || null , 1 ) ;
1336: oe_debug_pub.add('Loc_segment3 : ' || null , 1 ) ;
1337: oe_debug_pub.add('Loc_segment4 : ' || null , 1 ) ;
1338: oe_debug_pub.add('Required_flag : ' || null , 1 ) ;
1331: oe_debug_pub.add('Trx_source_delivery_id : ' || l_delivery , 1 ) ;
1332: oe_debug_pub.add('Revision : ' || p_revision , 1 ) ;
1333: oe_debug_pub.add('Locator_id : ' || p_locator_id , 1 ) ;
1334: oe_debug_pub.add('Loc_segment1 : ' || null , 1 ) ;
1335: oe_debug_pub.add('Loc_segment2 : ' || null , 1 ) ;
1336: oe_debug_pub.add('Loc_segment3 : ' || null , 1 ) ;
1337: oe_debug_pub.add('Loc_segment4 : ' || null , 1 ) ;
1338: oe_debug_pub.add('Required_flag : ' || null , 1 ) ;
1339: oe_debug_pub.add('Picking_line_id : ' || l_shipment_line_id , 1 ) ;
1332: oe_debug_pub.add('Revision : ' || p_revision , 1 ) ;
1333: oe_debug_pub.add('Locator_id : ' || p_locator_id , 1 ) ;
1334: oe_debug_pub.add('Loc_segment1 : ' || null , 1 ) ;
1335: oe_debug_pub.add('Loc_segment2 : ' || null , 1 ) ;
1336: oe_debug_pub.add('Loc_segment3 : ' || null , 1 ) ;
1337: oe_debug_pub.add('Loc_segment4 : ' || null , 1 ) ;
1338: oe_debug_pub.add('Required_flag : ' || null , 1 ) ;
1339: oe_debug_pub.add('Picking_line_id : ' || l_shipment_line_id , 1 ) ;
1340: oe_debug_pub.add('Transfer_subinventory : ' || l_dest_subinv , 1 ) ;
1333: oe_debug_pub.add('Locator_id : ' || p_locator_id , 1 ) ;
1334: oe_debug_pub.add('Loc_segment1 : ' || null , 1 ) ;
1335: oe_debug_pub.add('Loc_segment2 : ' || null , 1 ) ;
1336: oe_debug_pub.add('Loc_segment3 : ' || null , 1 ) ;
1337: oe_debug_pub.add('Loc_segment4 : ' || null , 1 ) ;
1338: oe_debug_pub.add('Required_flag : ' || null , 1 ) ;
1339: oe_debug_pub.add('Picking_line_id : ' || l_shipment_line_id , 1 ) ;
1340: oe_debug_pub.add('Transfer_subinventory : ' || l_dest_subinv , 1 ) ;
1341: oe_debug_pub.add('Transfer_organization : ' || l_to_org_id , 1 ) ;
1334: oe_debug_pub.add('Loc_segment1 : ' || null , 1 ) ;
1335: oe_debug_pub.add('Loc_segment2 : ' || null , 1 ) ;
1336: oe_debug_pub.add('Loc_segment3 : ' || null , 1 ) ;
1337: oe_debug_pub.add('Loc_segment4 : ' || null , 1 ) ;
1338: oe_debug_pub.add('Required_flag : ' || null , 1 ) ;
1339: oe_debug_pub.add('Picking_line_id : ' || l_shipment_line_id , 1 ) ;
1340: oe_debug_pub.add('Transfer_subinventory : ' || l_dest_subinv , 1 ) ;
1341: oe_debug_pub.add('Transfer_organization : ' || l_to_org_id , 1 ) ;
1342: oe_debug_pub.add('Ship_to_location_id : ' || l_location_id , 1 ) ;
1335: oe_debug_pub.add('Loc_segment2 : ' || null , 1 ) ;
1336: oe_debug_pub.add('Loc_segment3 : ' || null , 1 ) ;
1337: oe_debug_pub.add('Loc_segment4 : ' || null , 1 ) ;
1338: oe_debug_pub.add('Required_flag : ' || null , 1 ) ;
1339: oe_debug_pub.add('Picking_line_id : ' || l_shipment_line_id , 1 ) ;
1340: oe_debug_pub.add('Transfer_subinventory : ' || l_dest_subinv , 1 ) ;
1341: oe_debug_pub.add('Transfer_organization : ' || l_to_org_id , 1 ) ;
1342: oe_debug_pub.add('Ship_to_location_id : ' || l_location_id , 1 ) ;
1343: oe_debug_pub.add('Requisition_line_id : ' || l_req_line_id , 1 ) ;
1336: oe_debug_pub.add('Loc_segment3 : ' || null , 1 ) ;
1337: oe_debug_pub.add('Loc_segment4 : ' || null , 1 ) ;
1338: oe_debug_pub.add('Required_flag : ' || null , 1 ) ;
1339: oe_debug_pub.add('Picking_line_id : ' || l_shipment_line_id , 1 ) ;
1340: oe_debug_pub.add('Transfer_subinventory : ' || l_dest_subinv , 1 ) ;
1341: oe_debug_pub.add('Transfer_organization : ' || l_to_org_id , 1 ) ;
1342: oe_debug_pub.add('Ship_to_location_id : ' || l_location_id , 1 ) ;
1343: oe_debug_pub.add('Requisition_line_id : ' || l_req_line_id , 1 ) ;
1344: oe_debug_pub.add('Transaction_uom : ' || p_trx_uom , 1 ) ;
1337: oe_debug_pub.add('Loc_segment4 : ' || null , 1 ) ;
1338: oe_debug_pub.add('Required_flag : ' || null , 1 ) ;
1339: oe_debug_pub.add('Picking_line_id : ' || l_shipment_line_id , 1 ) ;
1340: oe_debug_pub.add('Transfer_subinventory : ' || l_dest_subinv , 1 ) ;
1341: oe_debug_pub.add('Transfer_organization : ' || l_to_org_id , 1 ) ;
1342: oe_debug_pub.add('Ship_to_location_id : ' || l_location_id , 1 ) ;
1343: oe_debug_pub.add('Requisition_line_id : ' || l_req_line_id , 1 ) ;
1344: oe_debug_pub.add('Transaction_uom : ' || p_trx_uom , 1 ) ;
1345: oe_debug_pub.add('Transaction interface_id : ' || l_transaction_interface_id , 1 ) ;
1338: oe_debug_pub.add('Required_flag : ' || null , 1 ) ;
1339: oe_debug_pub.add('Picking_line_id : ' || l_shipment_line_id , 1 ) ;
1340: oe_debug_pub.add('Transfer_subinventory : ' || l_dest_subinv , 1 ) ;
1341: oe_debug_pub.add('Transfer_organization : ' || l_to_org_id , 1 ) ;
1342: oe_debug_pub.add('Ship_to_location_id : ' || l_location_id , 1 ) ;
1343: oe_debug_pub.add('Requisition_line_id : ' || l_req_line_id , 1 ) ;
1344: oe_debug_pub.add('Transaction_uom : ' || p_trx_uom , 1 ) ;
1345: oe_debug_pub.add('Transaction interface_id : ' || l_transaction_interface_id , 1 ) ;
1346: oe_debug_pub.add('Demand_id : ' || null , 1 ) ;
1339: oe_debug_pub.add('Picking_line_id : ' || l_shipment_line_id , 1 ) ;
1340: oe_debug_pub.add('Transfer_subinventory : ' || l_dest_subinv , 1 ) ;
1341: oe_debug_pub.add('Transfer_organization : ' || l_to_org_id , 1 ) ;
1342: oe_debug_pub.add('Ship_to_location_id : ' || l_location_id , 1 ) ;
1343: oe_debug_pub.add('Requisition_line_id : ' || l_req_line_id , 1 ) ;
1344: oe_debug_pub.add('Transaction_uom : ' || p_trx_uom , 1 ) ;
1345: oe_debug_pub.add('Transaction interface_id : ' || l_transaction_interface_id , 1 ) ;
1346: oe_debug_pub.add('Demand_id : ' || null , 1 ) ;
1347: oe_debug_pub.add('Shipment_number : ' || null , 1 ) ;
1340: oe_debug_pub.add('Transfer_subinventory : ' || l_dest_subinv , 1 ) ;
1341: oe_debug_pub.add('Transfer_organization : ' || l_to_org_id , 1 ) ;
1342: oe_debug_pub.add('Ship_to_location_id : ' || l_location_id , 1 ) ;
1343: oe_debug_pub.add('Requisition_line_id : ' || l_req_line_id , 1 ) ;
1344: oe_debug_pub.add('Transaction_uom : ' || p_trx_uom , 1 ) ;
1345: oe_debug_pub.add('Transaction interface_id : ' || l_transaction_interface_id , 1 ) ;
1346: oe_debug_pub.add('Demand_id : ' || null , 1 ) ;
1347: oe_debug_pub.add('Shipment_number : ' || null , 1 ) ;
1348: oe_debug_pub.add('Currency_code : ' || null , 1 ) ;
1341: oe_debug_pub.add('Transfer_organization : ' || l_to_org_id , 1 ) ;
1342: oe_debug_pub.add('Ship_to_location_id : ' || l_location_id , 1 ) ;
1343: oe_debug_pub.add('Requisition_line_id : ' || l_req_line_id , 1 ) ;
1344: oe_debug_pub.add('Transaction_uom : ' || p_trx_uom , 1 ) ;
1345: oe_debug_pub.add('Transaction interface_id : ' || l_transaction_interface_id , 1 ) ;
1346: oe_debug_pub.add('Demand_id : ' || null , 1 ) ;
1347: oe_debug_pub.add('Shipment_number : ' || null , 1 ) ;
1348: oe_debug_pub.add('Currency_code : ' || null , 1 ) ;
1349: oe_debug_pub.add('Currency_conversion_type : ' || null , 1 ) ;
1342: oe_debug_pub.add('Ship_to_location_id : ' || l_location_id , 1 ) ;
1343: oe_debug_pub.add('Requisition_line_id : ' || l_req_line_id , 1 ) ;
1344: oe_debug_pub.add('Transaction_uom : ' || p_trx_uom , 1 ) ;
1345: oe_debug_pub.add('Transaction interface_id : ' || l_transaction_interface_id , 1 ) ;
1346: oe_debug_pub.add('Demand_id : ' || null , 1 ) ;
1347: oe_debug_pub.add('Shipment_number : ' || null , 1 ) ;
1348: oe_debug_pub.add('Currency_code : ' || null , 1 ) ;
1349: oe_debug_pub.add('Currency_conversion_type : ' || null , 1 ) ;
1350: oe_debug_pub.add('Currency_conversion_date : ' || null , 1 ) ;
1343: oe_debug_pub.add('Requisition_line_id : ' || l_req_line_id , 1 ) ;
1344: oe_debug_pub.add('Transaction_uom : ' || p_trx_uom , 1 ) ;
1345: oe_debug_pub.add('Transaction interface_id : ' || l_transaction_interface_id , 1 ) ;
1346: oe_debug_pub.add('Demand_id : ' || null , 1 ) ;
1347: oe_debug_pub.add('Shipment_number : ' || null , 1 ) ;
1348: oe_debug_pub.add('Currency_code : ' || null , 1 ) ;
1349: oe_debug_pub.add('Currency_conversion_type : ' || null , 1 ) ;
1350: oe_debug_pub.add('Currency_conversion_date : ' || null , 1 ) ;
1351: oe_debug_pub.add('Currency_conversion_rate : ' || null , 1 ) ;
1344: oe_debug_pub.add('Transaction_uom : ' || p_trx_uom , 1 ) ;
1345: oe_debug_pub.add('Transaction interface_id : ' || l_transaction_interface_id , 1 ) ;
1346: oe_debug_pub.add('Demand_id : ' || null , 1 ) ;
1347: oe_debug_pub.add('Shipment_number : ' || null , 1 ) ;
1348: oe_debug_pub.add('Currency_code : ' || null , 1 ) ;
1349: oe_debug_pub.add('Currency_conversion_type : ' || null , 1 ) ;
1350: oe_debug_pub.add('Currency_conversion_date : ' || null , 1 ) ;
1351: oe_debug_pub.add('Currency_conversion_rate : ' || null , 1 ) ;
1352: oe_debug_pub.add('Encumbrance_account : ' || l_budget_acct_id , 1 ) ;
1345: oe_debug_pub.add('Transaction interface_id : ' || l_transaction_interface_id , 1 ) ;
1346: oe_debug_pub.add('Demand_id : ' || null , 1 ) ;
1347: oe_debug_pub.add('Shipment_number : ' || null , 1 ) ;
1348: oe_debug_pub.add('Currency_code : ' || null , 1 ) ;
1349: oe_debug_pub.add('Currency_conversion_type : ' || null , 1 ) ;
1350: oe_debug_pub.add('Currency_conversion_date : ' || null , 1 ) ;
1351: oe_debug_pub.add('Currency_conversion_rate : ' || null , 1 ) ;
1352: oe_debug_pub.add('Encumbrance_account : ' || l_budget_acct_id , 1 ) ;
1353: oe_debug_pub.add('Encumbrance_amount : ' || l_unit_price * p_transaction_detail_qty , 1 ) ;
1346: oe_debug_pub.add('Demand_id : ' || null , 1 ) ;
1347: oe_debug_pub.add('Shipment_number : ' || null , 1 ) ;
1348: oe_debug_pub.add('Currency_code : ' || null , 1 ) ;
1349: oe_debug_pub.add('Currency_conversion_type : ' || null , 1 ) ;
1350: oe_debug_pub.add('Currency_conversion_date : ' || null , 1 ) ;
1351: oe_debug_pub.add('Currency_conversion_rate : ' || null , 1 ) ;
1352: oe_debug_pub.add('Encumbrance_account : ' || l_budget_acct_id , 1 ) ;
1353: oe_debug_pub.add('Encumbrance_amount : ' || l_unit_price * p_transaction_detail_qty , 1 ) ;
1354: oe_debug_pub.add('Project_id : ' || l_project_id , 1 ) ;
1347: oe_debug_pub.add('Shipment_number : ' || null , 1 ) ;
1348: oe_debug_pub.add('Currency_code : ' || null , 1 ) ;
1349: oe_debug_pub.add('Currency_conversion_type : ' || null , 1 ) ;
1350: oe_debug_pub.add('Currency_conversion_date : ' || null , 1 ) ;
1351: oe_debug_pub.add('Currency_conversion_rate : ' || null , 1 ) ;
1352: oe_debug_pub.add('Encumbrance_account : ' || l_budget_acct_id , 1 ) ;
1353: oe_debug_pub.add('Encumbrance_amount : ' || l_unit_price * p_transaction_detail_qty , 1 ) ;
1354: oe_debug_pub.add('Project_id : ' || l_project_id , 1 ) ;
1355: oe_debug_pub.add('Task_id : ' || l_task_id , 1 ) ;
1348: oe_debug_pub.add('Currency_code : ' || null , 1 ) ;
1349: oe_debug_pub.add('Currency_conversion_type : ' || null , 1 ) ;
1350: oe_debug_pub.add('Currency_conversion_date : ' || null , 1 ) ;
1351: oe_debug_pub.add('Currency_conversion_rate : ' || null , 1 ) ;
1352: oe_debug_pub.add('Encumbrance_account : ' || l_budget_acct_id , 1 ) ;
1353: oe_debug_pub.add('Encumbrance_amount : ' || l_unit_price * p_transaction_detail_qty , 1 ) ;
1354: oe_debug_pub.add('Project_id : ' || l_project_id , 1 ) ;
1355: oe_debug_pub.add('Task_id : ' || l_task_id , 1 ) ;
1356: oe_debug_pub.add('Before inserting records into mtl interface table..' , 1 ) ;
1349: oe_debug_pub.add('Currency_conversion_type : ' || null , 1 ) ;
1350: oe_debug_pub.add('Currency_conversion_date : ' || null , 1 ) ;
1351: oe_debug_pub.add('Currency_conversion_rate : ' || null , 1 ) ;
1352: oe_debug_pub.add('Encumbrance_account : ' || l_budget_acct_id , 1 ) ;
1353: oe_debug_pub.add('Encumbrance_amount : ' || l_unit_price * p_transaction_detail_qty , 1 ) ;
1354: oe_debug_pub.add('Project_id : ' || l_project_id , 1 ) ;
1355: oe_debug_pub.add('Task_id : ' || l_task_id , 1 ) ;
1356: oe_debug_pub.add('Before inserting records into mtl interface table..' , 1 ) ;
1357: END IF;
1350: oe_debug_pub.add('Currency_conversion_date : ' || null , 1 ) ;
1351: oe_debug_pub.add('Currency_conversion_rate : ' || null , 1 ) ;
1352: oe_debug_pub.add('Encumbrance_account : ' || l_budget_acct_id , 1 ) ;
1353: oe_debug_pub.add('Encumbrance_amount : ' || l_unit_price * p_transaction_detail_qty , 1 ) ;
1354: oe_debug_pub.add('Project_id : ' || l_project_id , 1 ) ;
1355: oe_debug_pub.add('Task_id : ' || l_task_id , 1 ) ;
1356: oe_debug_pub.add('Before inserting records into mtl interface table..' , 1 ) ;
1357: END IF;
1358:
1351: oe_debug_pub.add('Currency_conversion_rate : ' || null , 1 ) ;
1352: oe_debug_pub.add('Encumbrance_account : ' || l_budget_acct_id , 1 ) ;
1353: oe_debug_pub.add('Encumbrance_amount : ' || l_unit_price * p_transaction_detail_qty , 1 ) ;
1354: oe_debug_pub.add('Project_id : ' || l_project_id , 1 ) ;
1355: oe_debug_pub.add('Task_id : ' || l_task_id , 1 ) ;
1356: oe_debug_pub.add('Before inserting records into mtl interface table..' , 1 ) ;
1357: END IF;
1358:
1359: -- 1517431 populate distribution account
1352: oe_debug_pub.add('Encumbrance_account : ' || l_budget_acct_id , 1 ) ;
1353: oe_debug_pub.add('Encumbrance_amount : ' || l_unit_price * p_transaction_detail_qty , 1 ) ;
1354: oe_debug_pub.add('Project_id : ' || l_project_id , 1 ) ;
1355: oe_debug_pub.add('Task_id : ' || l_task_id , 1 ) ;
1356: oe_debug_pub.add('Before inserting records into mtl interface table..' , 1 ) ;
1357: END IF;
1358:
1359: -- 1517431 populate distribution account
1360:
1630: decode(l_task_id, 0, null, l_task_id),
1631: p_transfer_lpn_id); -- 3544019
1632:
1633: IF l_debug_level > 0 THEN
1634: oe_debug_pub.add( 'Successfully inserted records in mtl interface table ' , 5 ) ;
1635: x_return_status := FND_API.G_RET_STS_SUCCESS; -- bug 5357879
1636: END IF;
1637: EXCEPTION WHEN OTHERS THEN
1638: IF l_debug_level > 0 THEN
1635: x_return_status := FND_API.G_RET_STS_SUCCESS; -- bug 5357879
1636: END IF;
1637: EXCEPTION WHEN OTHERS THEN
1638: IF l_debug_level > 0 THEN
1639: oe_debug_pub.add( 'Failed while inserting records in mtl_transactions_interface '||sqlerrm , 1 ) ;
1640: oe_debug_pub.add( 'Sales order issue transaction will not occur ' , 1 ) ;
1641: END IF;
1642:
1643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 5357879
1636: END IF;
1637: EXCEPTION WHEN OTHERS THEN
1638: IF l_debug_level > 0 THEN
1639: oe_debug_pub.add( 'Failed while inserting records in mtl_transactions_interface '||sqlerrm , 1 ) ;
1640: oe_debug_pub.add( 'Sales order issue transaction will not occur ' , 1 ) ;
1641: END IF;
1642:
1643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 5357879
1644: ROLLBACK TO DECREMENT_INV;
1647:
1648: -- Calling this API for immediate decrement of inventory
1649:
1650: IF l_debug_level > 0 THEN
1651: oe_debug_pub.add( 'Return from decrementinventory()',5 ) ;
1652: END IF;
1653:
1654: END Decrement_Inventory;
1655:
1661: RETURN NUMBER
1662: IS
1663: l_chart_of_accs NUMBER;
1664: --
1665: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1666: --
1667: BEGIN
1668: -- SQL Performance ID 14882944, replacing org_organization_definitions with relevant base tables
1669: /*
1705: l_sales_order_id NUMBER := 0;
1706: l_order_type_name VARCHAR2(80);
1707: l_order_type_id NUMBER;
1708: --
1709: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1710: --
1711: BEGIN
1712:
1713: IF l_debug_level > 0 THEN
1710: --
1711: BEGIN
1712:
1713: IF l_debug_level > 0 THEN
1714: oe_debug_pub.add( 'ENTERING GET_MTL_SALES_ORDER_ID IN DROPSHIPRECECEIVE ( ) ' , 3 ) ;
1715: END IF;
1716:
1717: BEGIN
1718: SELECT order_type_id
1724: RAISE;
1725: END;
1726:
1727: IF l_debug_level > 0 THEN
1728: oe_debug_pub.add( 'ORDER TYPE ID :' || L_ORDER_TYPE_ID , 3 ) ;
1729: END IF;
1730:
1731: BEGIN
1732: SELECT NAME
1738: where installed_flag = 'B');
1739: EXCEPTION
1740: WHEN NO_DATA_FOUND THEN
1741: IF l_debug_level > 0 THEN
1742: oe_debug_pub.add( 'UNABLE TO LOCATE ORDER TYPE ID IN DROPSHIPRECEIVE ( ) '||sqlerrm , 1 ) ;
1743: END IF;
1744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1745: END;
1746:
1744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1745: END;
1746:
1747: IF l_debug_level > 0 THEN
1748: oe_debug_pub.add( 'ORDER TYPE: ' || L_ORDER_TYPE_NAME , 2 ) ;
1749: oe_debug_pub.add( 'SOURCE CODE: ' || L_SOURCE_CODE , 2 ) ;
1750: END IF;
1751:
1752: SELECT S.SALES_ORDER_ID
1745: END;
1746:
1747: IF l_debug_level > 0 THEN
1748: oe_debug_pub.add( 'ORDER TYPE: ' || L_ORDER_TYPE_NAME , 2 ) ;
1749: oe_debug_pub.add( 'SOURCE CODE: ' || L_SOURCE_CODE , 2 ) ;
1750: END IF;
1751:
1752: SELECT S.SALES_ORDER_ID
1753: INTO l_sales_order_id
1758: AND S.SEGMENT3 = l_source_code
1759: AND H.HEADER_ID = p_header_id;
1760:
1761: IF l_debug_level > 0 THEN
1762: oe_debug_pub.add( 'EXISTING GET_MTL_SALES_ORDER_ID ( ) WITH SALES ORDER ID => ' || L_SALES_ORDER_ID , 1 ) ;
1763: END IF;
1764:
1765: RETURN l_sales_order_id;
1766:
1766:
1767: EXCEPTION
1768: WHEN NO_DATA_FOUND THEN
1769: IF l_debug_level > 0 THEN
1770: oe_debug_pub.add( '2. L_SALES_ORDER_ID IS 0' , 5 ) ;
1771: END IF;
1772: RETURN 0;
1773: WHEN OTHERS THEN
1774: IF l_debug_level > 0 THEN
1771: END IF;
1772: RETURN 0;
1773: WHEN OTHERS THEN
1774: IF l_debug_level > 0 THEN
1775: oe_debug_pub.add( '2. L_SALES_ORDER_ID IS 0' , 5 ) ;
1776: END IF;
1777: RETURN 0;
1778: END Get_mtl_sales_order_id;
1779:
1809: WHERE line_id = l_new_line_id
1810: AND line_location_id = G_LINE_LOCATION_ID; -- bug 4402566
1811:
1812: --
1813: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1814: --
1815: BEGIN
1816:
1817: OPEN old_drop_ship_line;
1993: And delete_mark = 0
1994: And completed_ind = 0;
1995:
1996: --
1997: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1998: --
1999: BEGIN
2000:
2001: IF l_debug_level > 0 THEN
1998: --
1999: BEGIN
2000:
2001: IF l_debug_level > 0 THEN
2002: oe_debug_pub.add( 'ENTERING DECREMENT INVENTORY FOR OPM' ) ;
2003: oe_debug_pub.add( ' P_LOT_NUMBER : ' || P_LOT_NUMBER , 1 ) ;
2004: oe_debug_pub.add( ' P_INVENTORY_ITEM_ID : ' || P_INVENTORY_ITEM_ID , 1 ) ;
2005: oe_debug_pub.add( ' P_ORGANIZATION_ID : ' || P_WAREHOUSE_ID , 1 ) ;
2006: oe_debug_pub.add( ' P_TRX_UOM : ' || P_TRX_UOM , 1 ) ;
1999: BEGIN
2000:
2001: IF l_debug_level > 0 THEN
2002: oe_debug_pub.add( 'ENTERING DECREMENT INVENTORY FOR OPM' ) ;
2003: oe_debug_pub.add( ' P_LOT_NUMBER : ' || P_LOT_NUMBER , 1 ) ;
2004: oe_debug_pub.add( ' P_INVENTORY_ITEM_ID : ' || P_INVENTORY_ITEM_ID , 1 ) ;
2005: oe_debug_pub.add( ' P_ORGANIZATION_ID : ' || P_WAREHOUSE_ID , 1 ) ;
2006: oe_debug_pub.add( ' P_TRX_UOM : ' || P_TRX_UOM , 1 ) ;
2007: oe_debug_pub.add( ' P_CHART_OF_ACCTS : ' || P_CHART_OF_ACCTS , 1 ) ;
2000:
2001: IF l_debug_level > 0 THEN
2002: oe_debug_pub.add( 'ENTERING DECREMENT INVENTORY FOR OPM' ) ;
2003: oe_debug_pub.add( ' P_LOT_NUMBER : ' || P_LOT_NUMBER , 1 ) ;
2004: oe_debug_pub.add( ' P_INVENTORY_ITEM_ID : ' || P_INVENTORY_ITEM_ID , 1 ) ;
2005: oe_debug_pub.add( ' P_ORGANIZATION_ID : ' || P_WAREHOUSE_ID , 1 ) ;
2006: oe_debug_pub.add( ' P_TRX_UOM : ' || P_TRX_UOM , 1 ) ;
2007: oe_debug_pub.add( ' P_CHART_OF_ACCTS : ' || P_CHART_OF_ACCTS , 1 ) ;
2008: oe_debug_pub.add( ' P_AS_ALPHA_PREFIX : ' || P_AS_ALPHA_PREFIX , 1 ) ;
2001: IF l_debug_level > 0 THEN
2002: oe_debug_pub.add( 'ENTERING DECREMENT INVENTORY FOR OPM' ) ;
2003: oe_debug_pub.add( ' P_LOT_NUMBER : ' || P_LOT_NUMBER , 1 ) ;
2004: oe_debug_pub.add( ' P_INVENTORY_ITEM_ID : ' || P_INVENTORY_ITEM_ID , 1 ) ;
2005: oe_debug_pub.add( ' P_ORGANIZATION_ID : ' || P_WAREHOUSE_ID , 1 ) ;
2006: oe_debug_pub.add( ' P_TRX_UOM : ' || P_TRX_UOM , 1 ) ;
2007: oe_debug_pub.add( ' P_CHART_OF_ACCTS : ' || P_CHART_OF_ACCTS , 1 ) ;
2008: oe_debug_pub.add( ' P_AS_ALPHA_PREFIX : ' || P_AS_ALPHA_PREFIX , 1 ) ;
2009: oe_debug_pub.add( ' P_SN_CONTROL_CODE : ' || P_SN_CONTROL_CODE , 1 ) ;
2002: oe_debug_pub.add( 'ENTERING DECREMENT INVENTORY FOR OPM' ) ;
2003: oe_debug_pub.add( ' P_LOT_NUMBER : ' || P_LOT_NUMBER , 1 ) ;
2004: oe_debug_pub.add( ' P_INVENTORY_ITEM_ID : ' || P_INVENTORY_ITEM_ID , 1 ) ;
2005: oe_debug_pub.add( ' P_ORGANIZATION_ID : ' || P_WAREHOUSE_ID , 1 ) ;
2006: oe_debug_pub.add( ' P_TRX_UOM : ' || P_TRX_UOM , 1 ) ;
2007: oe_debug_pub.add( ' P_CHART_OF_ACCTS : ' || P_CHART_OF_ACCTS , 1 ) ;
2008: oe_debug_pub.add( ' P_AS_ALPHA_PREFIX : ' || P_AS_ALPHA_PREFIX , 1 ) ;
2009: oe_debug_pub.add( ' P_SN_CONTROL_CODE : ' || P_SN_CONTROL_CODE , 1 ) ;
2010: oe_debug_pub.add( ' P_TRANSACTION_ID : ' || P_TRANSACTION_ID , 1 ) ;
2003: oe_debug_pub.add( ' P_LOT_NUMBER : ' || P_LOT_NUMBER , 1 ) ;
2004: oe_debug_pub.add( ' P_INVENTORY_ITEM_ID : ' || P_INVENTORY_ITEM_ID , 1 ) ;
2005: oe_debug_pub.add( ' P_ORGANIZATION_ID : ' || P_WAREHOUSE_ID , 1 ) ;
2006: oe_debug_pub.add( ' P_TRX_UOM : ' || P_TRX_UOM , 1 ) ;
2007: oe_debug_pub.add( ' P_CHART_OF_ACCTS : ' || P_CHART_OF_ACCTS , 1 ) ;
2008: oe_debug_pub.add( ' P_AS_ALPHA_PREFIX : ' || P_AS_ALPHA_PREFIX , 1 ) ;
2009: oe_debug_pub.add( ' P_SN_CONTROL_CODE : ' || P_SN_CONTROL_CODE , 1 ) ;
2010: oe_debug_pub.add( ' P_TRANSACTION_ID : ' || P_TRANSACTION_ID , 1 ) ;
2011: END IF;
2004: oe_debug_pub.add( ' P_INVENTORY_ITEM_ID : ' || P_INVENTORY_ITEM_ID , 1 ) ;
2005: oe_debug_pub.add( ' P_ORGANIZATION_ID : ' || P_WAREHOUSE_ID , 1 ) ;
2006: oe_debug_pub.add( ' P_TRX_UOM : ' || P_TRX_UOM , 1 ) ;
2007: oe_debug_pub.add( ' P_CHART_OF_ACCTS : ' || P_CHART_OF_ACCTS , 1 ) ;
2008: oe_debug_pub.add( ' P_AS_ALPHA_PREFIX : ' || P_AS_ALPHA_PREFIX , 1 ) ;
2009: oe_debug_pub.add( ' P_SN_CONTROL_CODE : ' || P_SN_CONTROL_CODE , 1 ) ;
2010: oe_debug_pub.add( ' P_TRANSACTION_ID : ' || P_TRANSACTION_ID , 1 ) ;
2011: END IF;
2012:
2005: oe_debug_pub.add( ' P_ORGANIZATION_ID : ' || P_WAREHOUSE_ID , 1 ) ;
2006: oe_debug_pub.add( ' P_TRX_UOM : ' || P_TRX_UOM , 1 ) ;
2007: oe_debug_pub.add( ' P_CHART_OF_ACCTS : ' || P_CHART_OF_ACCTS , 1 ) ;
2008: oe_debug_pub.add( ' P_AS_ALPHA_PREFIX : ' || P_AS_ALPHA_PREFIX , 1 ) ;
2009: oe_debug_pub.add( ' P_SN_CONTROL_CODE : ' || P_SN_CONTROL_CODE , 1 ) ;
2010: oe_debug_pub.add( ' P_TRANSACTION_ID : ' || P_TRANSACTION_ID , 1 ) ;
2011: END IF;
2012:
2013: profile_values.oe_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
2006: oe_debug_pub.add( ' P_TRX_UOM : ' || P_TRX_UOM , 1 ) ;
2007: oe_debug_pub.add( ' P_CHART_OF_ACCTS : ' || P_CHART_OF_ACCTS , 1 ) ;
2008: oe_debug_pub.add( ' P_AS_ALPHA_PREFIX : ' || P_AS_ALPHA_PREFIX , 1 ) ;
2009: oe_debug_pub.add( ' P_SN_CONTROL_CODE : ' || P_SN_CONTROL_CODE , 1 ) ;
2010: oe_debug_pub.add( ' P_TRANSACTION_ID : ' || P_TRANSACTION_ID , 1 ) ;
2011: END IF;
2012:
2013: profile_values.oe_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
2014:
2032: /* l_trans_acc := NULL;
2033: END IF;
2034:
2035: IF l_debug_level > 0 THEN
2036: oe_debug_pub.add( 'TRANSACTION ACCOUNT ID ID : ' || L_TRANS_ACC , 1 ) ;
2037: END IF;
2038:
2039: l_trans_qty := p_trans_qty;
2040: /*OPM transactions in ic_tran_pnd
2042: Open get_opm_item_no;
2043: Fetch get_opm_item_no INTO l_opm_item_no;
2044: Close get_opm_item_no;
2045: IF l_debug_level > 0 THEN
2046: oe_debug_pub.add( ' P_OPM_ITEM_NO : ' || L_OPM_ITEM_NO , 1 ) ;
2047: END IF;
2048:
2049: Open get_opm_item_id;
2050: Fetch get_opm_item_id INTO l_opm_item_id, l_opm_item_um;
2049: Open get_opm_item_id;
2050: Fetch get_opm_item_id INTO l_opm_item_id, l_opm_item_um;
2051: Close get_opm_item_id;
2052: IF l_debug_level > 0 THEN
2053: oe_debug_pub.add( ' P_OPM_ITEM_ID : ' || L_OPM_ITEM_ID , 1 ) ;
2054: END IF;
2055: IF l_debug_level > 0 THEN
2056: oe_debug_pub.add( ' P_OPM_ITEM_UM : ' || L_OPM_ITEM_UM , 1 ) ;
2057: END IF;
2052: IF l_debug_level > 0 THEN
2053: oe_debug_pub.add( ' P_OPM_ITEM_ID : ' || L_OPM_ITEM_ID , 1 ) ;
2054: END IF;
2055: IF l_debug_level > 0 THEN
2056: oe_debug_pub.add( ' P_OPM_ITEM_UM : ' || L_OPM_ITEM_UM , 1 ) ;
2057: END IF;
2058:
2059: Open get_opm_whse;
2060: Fetch get_opm_whse INTO l_opm_whse;
2059: Open get_opm_whse;
2060: Fetch get_opm_whse INTO l_opm_whse;
2061: Close get_opm_whse;
2062: IF l_debug_level > 0 THEN
2063: oe_debug_pub.add( ' P_WAREHOUSE_ID : ' || L_OPM_WHSE , 1 ) ;
2064: END IF;
2065:
2066: l_opm_location := null;
2067: IF NVL(p_locator_id,0) <>0 THEN
2069: Fetch get_opm_location INTO l_opm_location;
2070: Close get_opm_location;
2071: END IF;
2072: IF l_debug_level > 0 THEN
2073: oe_debug_pub.add( ' OPM_LOCATION : ' || L_OPM_LOCATION , 1 ) ;
2074: END IF;
2075: l_opm_lot_id := 0;
2076: IF (p_lot_number is not null) AND (p_sublot_no is not null) THEN
2077: Open get_opm_lot_id_sublot;
2082: Fetch get_opm_lot_id_no_sublot INTO l_opm_lot_id;
2083: Close get_opm_lot_id_no_sublot;
2084: END IF;
2085: IF l_debug_level > 0 THEN
2086: oe_debug_pub.add( ' OPM_LOT_ID : ' || L_OPM_LOT_ID , 1 ) ;
2087: END IF;
2088:
2089: IF (p_lot_number is not null) THEN
2090: OPEN check_opm_inv ;
2095: Fetch check_opm_inv_default INTO l_exist;
2096: CLOSE check_opm_inv_default;
2097: END IF;
2098: IF l_debug_level > 0 THEN
2099: oe_debug_pub.add( ' L_EXIST : ' || L_EXIST , 1 ) ;
2100: END IF;
2101:
2102: GMI_RESERVATION_UTIL.Get_OPMUOM_from_AppsUOM(
2103: p_Apps_UOM => p_trx_uom
2112: FND_MSG_PUB.Add;
2113: RAISE FND_API.G_EXC_ERROR;
2114: ELSE
2115: IF l_debug_level > 0 THEN
2116: oe_debug_pub.add( ' OPM TRX UOM='||L_OPM_TRX_UOM||'.' , 1 ) ;
2117: END IF;
2118: END IF;
2119: IF l_opm_trx_uom <> l_opm_item_um THEN
2120: GMICUOM.icuomcv(pitem_id => l_opm_item_id,
2152: raise FND_API.G_EXC_ERROR;
2153: END IF;
2154:
2155: IF l_debug_level > 0 THEN
2156: oe_debug_pub.add( 'EXITING DECREMENT INVENTORY' ) ;
2157: END IF;
2158:
2159: END Decrement_Inventory_for_OPM; */
2160:
2192:
2193: l_msg_count NUMBER;
2194: l_msg_data VARCHAR2(20000);
2195:
2196: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2197: l_return_status VARCHAR2(1);
2198:
2199: BEGIN
2200:
2198:
2199: BEGIN
2200:
2201: IF l_debug_level > 0 THEN
2202: oe_debug_pub.add( 'Populating inventory record before calling reservation ' , 1 ) ;
2203: END IF;
2204:
2205: -- Populate inventory record structure before calling reservation
2206:
2215:
2216: l_sales_order_id := Get_mtl_sales_order_id(p_line_rec.header_id);
2217:
2218: IF l_debug_level > 0 THEN
2219: oe_debug_pub.add( 'Sales Order ID '||l_sales_order_id, 1 ) ;
2220: END IF;
2221: IF p_qty2_to_be_reserved = 0 then -- INVCONV
2222: l_qty2_to_be_reserved := NULL;
2223: else
2273:
2274: -- Call INV with action = RESERVE
2275:
2276: IF l_debug_level > 0 THEN
2277: oe_debug_pub.add( 'Calling clear cache' , 1 ) ;
2278: END IF;
2279:
2280: -- Inv_quantity_tree_grp.clear_quantity_cache;
2281: Inv_quantity_tree_pvt.mark_all_for_refresh
2290: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
2291: for I in 1..l_msg_count loop
2292: l_msg_data := OE_MSG_PUB.Get(I,'F');
2293: IF l_debug_level > 0 THEN
2294: oe_debug_pub.add( L_MSG_DATA , 1 ) ;
2295: END IF;
2296: end loop;
2297: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2298: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2300: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
2301: for I in 1..l_msg_count loop
2302: l_msg_data := OE_MSG_PUB.Get(I,'F');
2303: IF l_debug_level > 0 THEN
2304: oe_debug_pub.add( L_MSG_DATA , 1 ) ;
2305: END IF;
2306: end loop;
2307: RAISE FND_API.G_EXC_ERROR;
2308: END IF;
2307: RAISE FND_API.G_EXC_ERROR;
2308: END IF;
2309:
2310: IF l_debug_level > 0 THEN
2311: oe_debug_pub.add( 'Calling inv to reserve quantity : ' || p_qty_to_be_reserved , 1 ) ;
2312: oe_debug_pub.add( 'Calling inv to reserve quantity2 : ' || p_qty2_to_be_reserved , 1 ) ;
2313: END IF;
2314:
2315: Inv_reservation_pub.create_reservation
2308: END IF;
2309:
2310: IF l_debug_level > 0 THEN
2311: oe_debug_pub.add( 'Calling inv to reserve quantity : ' || p_qty_to_be_reserved , 1 ) ;
2312: oe_debug_pub.add( 'Calling inv to reserve quantity2 : ' || p_qty2_to_be_reserved , 1 ) ;
2313: END IF;
2314:
2315: Inv_reservation_pub.create_reservation
2316: ( p_api_version_number => 1.0
2330: , x_reservation_id => l_rsv_id
2331: );
2332:
2333: IF l_debug_level > 0 THEN
2334: oe_debug_pub.add( 'Create reservation returns : ' || l_return_status , 1 ) ;
2335: oe_debug_pub.add( l_msg_data , 1 ) ;
2336: END IF;
2337:
2338: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2331: );
2332:
2333: IF l_debug_level > 0 THEN
2334: oe_debug_pub.add( 'Create reservation returns : ' || l_return_status , 1 ) ;
2335: oe_debug_pub.add( l_msg_data , 1 ) ;
2336: END IF;
2337:
2338: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2339: IF l_debug_level > 0 THEN
2336: END IF;
2337:
2338: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2339: IF l_debug_level > 0 THEN
2340: oe_debug_pub.add( 'Reservation fails with unexpected error in dropshipreceive() : '||sqlerrm , 1 ) ;
2341: oe_debug_pub.add( 'Try receipt after setting sub/item non reservable' , 1 ) ;
2342: END IF;
2343:
2344: oe_msg_pub.transfer_msg_stack;
2337:
2338: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2339: IF l_debug_level > 0 THEN
2340: oe_debug_pub.add( 'Reservation fails with unexpected error in dropshipreceive() : '||sqlerrm , 1 ) ;
2341: oe_debug_pub.add( 'Try receipt after setting sub/item non reservable' , 1 ) ;
2342: END IF;
2343:
2344: oe_msg_pub.transfer_msg_stack;
2345: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
2345: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
2346: for I in 1..l_msg_count loop
2347: l_msg_data := OE_MSG_PUB.Get(I,'F');
2348: IF l_debug_level > 0 THEN
2349: oe_debug_pub.add(l_msg_data,1) ;
2350: END IF;
2351: end loop;
2352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2353:
2352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2353:
2354: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2355: IF l_debug_level > 0 THEN
2356: oe_debug_pub.add('reservation fails with expected error in dropshipreceive() : '||sqlerrm,1) ;
2357: oe_debug_pub.add( 'Try receipt after setting sub/item non reservable' , 1 ) ;
2358: END IF;
2359: oe_msg_pub.transfer_msg_stack;
2360: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
2353:
2354: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2355: IF l_debug_level > 0 THEN
2356: oe_debug_pub.add('reservation fails with expected error in dropshipreceive() : '||sqlerrm,1) ;
2357: oe_debug_pub.add( 'Try receipt after setting sub/item non reservable' , 1 ) ;
2358: END IF;
2359: oe_msg_pub.transfer_msg_stack;
2360: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
2361: for I in 1..l_msg_count loop
2360: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
2361: for I in 1..l_msg_count loop
2362: l_msg_data := OE_MSG_PUB.Get(I,'F');
2363: IF l_debug_level > 0 THEN
2364: oe_debug_pub.add(l_msg_data,1) ;
2365: END IF;
2366: end loop;
2367: RAISE FND_API.G_EXC_ERROR;
2368: END IF;
2367: RAISE FND_API.G_EXC_ERROR;
2368: END IF;
2369:
2370: IF l_debug_level > 0 THEN
2371: oe_debug_pub.add( 'Successfully reserved quantity => '||l_quantity_reserved,1) ;
2372: oe_debug_pub.add( 'Successfully reserved quantity2 => '||l_quantity2_reserved,1) ; -- INVCONV
2373:
2374: END IF;
2375:
2368: END IF;
2369:
2370: IF l_debug_level > 0 THEN
2371: oe_debug_pub.add( 'Successfully reserved quantity => '||l_quantity_reserved,1) ;
2372: oe_debug_pub.add( 'Successfully reserved quantity2 => '||l_quantity2_reserved,1) ; -- INVCONV
2373:
2374: END IF;
2375:
2376: x_qty_reserved := l_quantity_reserved;
2377: x_qty2_reserved := l_quantity2_reserved; -- INVCONV
2378: x_rsv_id := l_rsv_id;
2379:
2380: IF l_debug_level > 0 THEN
2381: OE_DEBUG_PUB.Add('Exiting Create_Reservation ...',4);
2382: END IF;
2383: EXCEPTION
2384:
2385: WHEN FND_API.G_EXC_ERROR THEN
2383: EXCEPTION
2384:
2385: WHEN FND_API.G_EXC_ERROR THEN
2386: IF l_debug_level > 0 THEN
2387: OE_DEBUG_PUB.Add('Expected Error in Create Reservation...',4);
2388: END IF;
2389:
2390: x_return_status := FND_API.G_RET_STS_ERROR;
2391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2389:
2390: x_return_status := FND_API.G_RET_STS_ERROR;
2391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2392: IF l_debug_level > 0 THEN
2393: OE_DEBUG_PUB.Add('UnExpected Error in Create Reservation...'||sqlerrm,4);
2394: END IF;
2395:
2396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2397: WHEN OTHERS THEN
2395:
2396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2397: WHEN OTHERS THEN
2398: IF l_debug_level > 0 THEN
2399: OE_DEBUG_PUB.Add('When Others in Create Reservation...'||sqlerrm,4);
2400: END IF;
2401:
2402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2403:
2432: l_proportion_broken_flag varchar2(1);
2433: l_cal_tolr_return_status varchar2(1);
2434: l_msg_count number;
2435: l_msg_data VARCHAR2(20000);
2436: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2437: l_return_status VARCHAR2(1);
2438: BEGIN
2439: IF l_debug_level > 0 THEN
2440: oe_debug_pub.add('OEXVDSRB.pls: Inside Call_Ship_Confirm_New API',3);
2436: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2437: l_return_status VARCHAR2(1);
2438: BEGIN
2439: IF l_debug_level > 0 THEN
2440: oe_debug_pub.add('OEXVDSRB.pls: Inside Call_Ship_Confirm_New API',3);
2441: END IF;
2442: -- Extending the l_non_bulk_ship_line
2443: l_non_bulk_ship_line.fulfilled_flag.extend;
2444: l_non_bulk_ship_line.actual_shipment_date.extend;
2479: l_cal_tolerance_tbl(1).line_id := p_line_rec.line_id;
2480: l_cal_tolerance_tbl(1).quantity_to_be_shipped := p_add_to_shipped;
2481: l_cal_tolerance_tbl(1).shipping_uom := p_line_rec.order_quantity_uom;
2482: IF l_debug_level > 0 THEN
2483: oe_debug_pub.add('Calling OE_Shipping_Integration_PUB.Get_Tolerance to check the tolerances' ,3);
2484: END IF;
2485:
2486: OE_Shipping_Integration_PUB.Get_Tolerance(
2487: p_api_version_number => 1.0,
2496: x_msg_data => l_msg_data);
2497:
2498: IF l_cal_tolr_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2499: IF l_debug_level > 0 THEN
2500: oe_debug_pub.add('OE_Shipping_Integration_PUB.Get_Tolerance returned Error', 1 ) ;
2501: END IF;
2502: x_return_status := FND_API.G_RET_STS_ERROR;
2503: return;
2504: END IF;
2561: x_msg_data => l_msg_data,
2562: x_return_status => l_return_status);
2563:
2564: IF l_debug_level > 0 THEN
2565: oe_debug_pub.add('OEXVDSRB.pls: OE_Ship_Confirmation_Pub.Ship_Confirm_New return_status='||l_return_status,3);
2566: END IF;
2567:
2568: x_return_status := l_return_status;
2569: x_msg_data := l_msg_data;
2624: l_req_qty_tbl OE_Ship_Confirmation_Pub.Req_Quantity_Tbl_Type;
2625:
2626: l_new_line_id NUMBER;
2627: l_return_status VARCHAR2(1);
2628: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2629: --serla begin
2630: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2631: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2632: --serla end
2640:
2641: IF (p_orig_shipped <> 0) --one receipt already exists
2642: THEN
2643: IF l_debug_level > 0 THEN
2644: oe_debug_pub.add('Receiving has already been done once. no processing in om' ) ;
2645: END IF;
2646: ELSE --first receipt against this line
2647:
2648: IF l_debug_level > 0 THEN
2645: END IF;
2646: ELSE --first receipt against this line
2647:
2648: IF l_debug_level > 0 THEN
2649: oe_debug_pub.add('Calling Call_Ship_Confirm_New API' , 1 ) ;
2650: END IF;
2651:
2652: -- Calling this new API, bug 4393738
2653: Call_Ship_Confirm_New
2661: ,x_msg_data => l_msg_data);
2662:
2663: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2664: IF l_debug_level > 0 THEN
2665: oe_debug_pub.add('OEXVDSRB.pls: Call_Ship_Confirm_New returned unexpected error '||sqlerrm , 1 ) ;
2666: END IF;
2667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2668: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2669: IF l_debug_level > 0 THEN
2666: END IF;
2667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2668: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2669: IF l_debug_level > 0 THEN
2670: oe_debug_pub.add('OEXVDSRB.pls: Call_Ship_Confirm_New returned expected error '||sqlerrm , 1 ) ;
2671: END IF;
2672: RAISE FND_API.G_EXC_ERROR;
2673: END IF;
2674:
2672: RAISE FND_API.G_EXC_ERROR;
2673: END IF;
2674:
2675: IF l_debug_level > 0 THEN
2676: oe_debug_pub.add('OEXVDSRB.pls: After Call_Ship_Confirm_New, return_status='|| l_return_status,1) ;
2677: END IF;
2678:
2679: IF l_debug_level > 0 THEN
2680: oe_debug_pub.add('OEXVDSRB.pls: Calling OE_CONFIG_TSO_PVT.Is_Part_Of_Container_Model...' , 5 ) ;
2676: oe_debug_pub.add('OEXVDSRB.pls: After Call_Ship_Confirm_New, return_status='|| l_return_status,1) ;
2677: END IF;
2678:
2679: IF l_debug_level > 0 THEN
2680: oe_debug_pub.add('OEXVDSRB.pls: Calling OE_CONFIG_TSO_PVT.Is_Part_Of_Container_Model...' , 5 ) ;
2681: END IF;
2682:
2683: -- TSO with Equipment, the non-shippable lines should have NULL shipped_quantity
2684: OE_CONFIG_TSO_PVT.Is_Part_Of_Container_Model
2698: AND shipped_quantity is not NULL;
2699:
2700: IF l_debug_level > 0 AND
2701: SQL%FOUND THEN
2702: oe_debug_pub.add('Updated non-shippable lines of TSO ...',5);
2703: END IF;
2704: END IF;
2705: -- TSO with equipment ends
2706:
2705: -- TSO with equipment ends
2706:
2707: IF ( p_short_quantity > 0 ) THEN
2708: IF l_debug_level > 0 THEN
2709: oe_debug_pub.add('After call from process order api check if split has happened ' , 5 ) ;
2710: END IF;
2711: BEGIN
2712: SELECT max(line_id)
2713: INTO l_new_line_id
2717: AND split_by = 'SYSTEM'; -- Bug-2437391
2718: EXCEPTION
2719: WHEN NO_DATA_FOUND THEN
2720: IF l_debug_level > 0 THEN
2721: oe_debug_pub.add( 'Split line not found '||sqlerrm , 1 ) ;
2722: END IF;
2723: WHEN OTHERS THEN
2724: IF l_debug_level > 0 THEN
2725: oe_debug_pub.add( 'Unexpected: line not found '||sqlerrm , 1 ) ;
2721: oe_debug_pub.add( 'Split line not found '||sqlerrm , 1 ) ;
2722: END IF;
2723: WHEN OTHERS THEN
2724: IF l_debug_level > 0 THEN
2725: oe_debug_pub.add( 'Unexpected: line not found '||sqlerrm , 1 ) ;
2726: END IF;
2727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2728: END;
2729: -- Bug2344242 added following if condition
2728: END;
2729: -- Bug2344242 added following if condition
2730: IF l_new_line_id is NOT NULL THEN
2731: IF l_debug_level > 0 THEN
2732: oe_debug_pub.add( 'Updating existing dropship record with new line '||l_new_line_id , 1 ) ;
2733: END IF;
2734:
2735: update oe_drop_ship_sources
2736: set line_id = l_new_line_id
2738:
2739: insert_oe_drop_ship_source(p_line_rec.line_id, l_new_line_id);
2740:
2741: IF l_debug_level > 0 THEN
2742: oe_debug_pub.add( 'After inserting drop ship source record ' , 5 ) ;
2743: END IF;
2744: END IF;
2745: END IF;
2746:
2746:
2747: END IF; --one receipt already exists
2748:
2749: IF l_debug_level > 0 THEN
2750: OE_DEBUG_PUB.Add('Exiting Call Process Order...',4);
2751: END IF;
2752: EXCEPTION
2753: WHEN FND_API.G_EXC_ERROR THEN
2754: IF l_debug_level > 0 THEN
2751: END IF;
2752: EXCEPTION
2753: WHEN FND_API.G_EXC_ERROR THEN
2754: IF l_debug_level > 0 THEN
2755: OE_DEBUG_PUB.Add('Expected Error in Call Process Order...',4);
2756: END IF;
2757:
2758: x_return_status := FND_API.G_RET_STS_ERROR;
2759: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2757:
2758: x_return_status := FND_API.G_RET_STS_ERROR;
2759: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2760: IF l_debug_level > 0 THEN
2761: OE_DEBUG_PUB.Add('UnExpected Error in Call Process Order...'||sqlerrm,4);
2762: END IF;
2763:
2764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2765: WHEN OTHERS THEN
2763:
2764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2765: WHEN OTHERS THEN
2766: IF l_debug_level > 0 THEN
2767: OE_DEBUG_PUB.Add('When Others in Call Process Order...'||sqlerrm,4);
2768: END IF;
2769:
2770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2771:
2802: l_po_status_rec PO_STATUS_REC_TYPE;
2803: l_return_status VARCHAR2(1);
2804: l_cancel_flag VARCHAR2(1);
2805: l_closed_code VARCHAR2(30);
2806: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2807: l_po_release_id NUMBER; -- bug 5328526
2808:
2809: BEGIN
2810:
2808:
2809: BEGIN
2810:
2811: IF l_debug_level > 0 THEN
2812: OE_DEBUG_PUB.Add('Entering Check_Req_PO_Cancelled.. ',1);
2813: END IF;
2814:
2815: SELECT requisition_header_id, po_header_id, po_release_id
2816: INTO l_req_header_id,l_po_header_id, l_po_release_id --bug 5328526
2818: WHERE line_id = p_line_id
2819: AND header_id = p_header_id;
2820:
2821: IF l_debug_level > 0 THEN
2822: OE_DEBUG_PUB.Add('Requisition:'||l_req_header_id||
2823: ' PO:'||l_po_header_id||
2824: ' PO Release:'||l_po_release_id,1);
2825: END IF;
2826:
2829: l_req_status := PO_RELEASES_SV2.Get_Release_Status
2830: ( x_po_release_id => l_req_header_id
2831: );
2832: IF l_debug_level > 0 THEN
2833: OE_DEBUG_PUB.Add('Requisition Status - '|| l_req_status, 3);
2834: END IF;
2835:
2836: IF l_req_status is null THEN
2837: PO_REQS_SV2.Get_Reqs_Auth_Status
2844: l_req_status := UPPER(l_req_status);
2845: END IF;
2846:
2847: IF l_debug_level > 0 THEN
2848: OE_DEBUG_PUB.Add('After Requisition Auth Status - '|| l_req_status, 3);
2849: END IF;
2850:
2851: END IF;
2852:
2858: (x_po_header_id => l_po_header_id
2859: ));
2860:
2861: IF l_debug_level > 0 THEN
2862: OE_DEBUG_PUB.Add('PO Status : '|| l_po_status, 2);
2863: END IF;
2864: */
2865: PO_DOCUMENT_CHECKS_GRP.po_status_check
2866: (p_api_version => 1.0
2872: IF(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2873: l_cancel_flag := l_po_status_rec.cancel_flag(1);
2874: l_closed_code := l_po_status_rec.closed_code(1);
2875: IF l_debug_level > 0 THEN
2876: OE_DEBUG_PUB.Add('Sucess call from PO_DOCUMENT_CHECKS_GRP.po_status_check',2);
2877: OE_DEBUG_PUB.Add('Cancel_flag : '|| l_cancel_flag, 2);
2878: OE_DEBUG_PUB.Add('Closed_code : '|| l_closed_code,2);
2879: END IF;
2880: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2873: l_cancel_flag := l_po_status_rec.cancel_flag(1);
2874: l_closed_code := l_po_status_rec.closed_code(1);
2875: IF l_debug_level > 0 THEN
2876: OE_DEBUG_PUB.Add('Sucess call from PO_DOCUMENT_CHECKS_GRP.po_status_check',2);
2877: OE_DEBUG_PUB.Add('Cancel_flag : '|| l_cancel_flag, 2);
2878: OE_DEBUG_PUB.Add('Closed_code : '|| l_closed_code,2);
2879: END IF;
2880: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2874: l_closed_code := l_po_status_rec.closed_code(1);
2875: IF l_debug_level > 0 THEN
2876: OE_DEBUG_PUB.Add('Sucess call from PO_DOCUMENT_CHECKS_GRP.po_status_check',2);
2877: OE_DEBUG_PUB.Add('Cancel_flag : '|| l_cancel_flag, 2);
2878: OE_DEBUG_PUB.Add('Closed_code : '|| l_closed_code,2);
2879: END IF;
2880: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2882: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2895: (nvl(l_cancel_flag,'z')='Y' AND
2896: nvl(l_closed_code, 'z')= 'FINALLY CLOSED' ) THEN
2897:
2898: IF l_debug_level > 0 THEN
2899: OE_DEBUG_PUB.Add('Requisition or PO is cancelled',1);
2900: END IF;
2901:
2902: RETURN TRUE;
2903: ELSE
2910:
2911: EXCEPTION
2912: WHEN NO_DATA_FOUND THEN
2913: IF l_debug_level > 0 THEN
2914: OE_DEBUG_PUB.Add('No Data Found in Check_Req_PO_Cancelled', 4);
2915: END IF;
2916: RETURN FALSE;
2917: WHEN OTHERS THEN
2918: IF l_debug_level > 0 THEN
2915: END IF;
2916: RETURN FALSE;
2917: WHEN OTHERS THEN
2918: IF l_debug_level > 0 THEN
2919: OE_DEBUG_PUB.Add('When Others in Check_Req_PO_Cancelled'|| sqlerrm, 3);
2920: END IF;
2921: RETURN FALSE;
2922: END Check_Req_PO_Cancelled;
2923:
2949: l_item_type_code VARCHAR2(30) := oe_line_security.g_record.item_type_code;
2950: l_source_type_code VARCHAR2(30) := oe_line_security.g_record.source_type_code;
2951: l_operation VARCHAR2(30) := oe_line_security.g_record.operation;
2952:
2953: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2954:
2955: l_po_header_id NUMBER;
2956: --bug 4411054
2957: --l_po_status VARCHAR2(4100);
2978: NOT (l_item_type_code in('OPTION','STANDARD') AND
2979: l_ato_line_id = l_line_id ) THEN
2980:
2981: IF l_debug_level > 0 THEN
2982: OE_DEBUG_PUB.Add('Line part of a ATO Model: '||l_ato_line_id, 2);
2983: END IF;
2984:
2985: SELECT po_header_id, po_release_id
2986: INTO l_po_header_id, l_po_release_id --bug 5328526
3012: (x_po_header_id => l_po_header_id
3013: ));
3014:
3015: IF l_debug_level > 0 THEN
3016: OE_DEBUG_PUB.Add('Check PO Status : '|| l_po_status, 2);
3017: END IF;
3018: */
3019:
3020: PO_DOCUMENT_CHECKS_GRP.po_status_check
3028: IF(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3029: l_autorization_status := l_po_status_rec.authorization_status(1);
3030:
3031: IF l_debug_level > 0 THEN
3032: OE_DEBUG_PUB.Add('Sucess call from PO_DOCUMENT_CHECKS_GRP.po_status_check',2);
3033: OE_DEBUG_PUB.Add('Check PO Status : '|| l_autorization_status, 2);
3034: END IF;
3035: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3029: l_autorization_status := l_po_status_rec.authorization_status(1);
3030:
3031: IF l_debug_level > 0 THEN
3032: OE_DEBUG_PUB.Add('Sucess call from PO_DOCUMENT_CHECKS_GRP.po_status_check',2);
3033: OE_DEBUG_PUB.Add('Check PO Status : '|| l_autorization_status, 2);
3034: END IF;
3035: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3037: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3054: WHEN NO_DATA_FOUND THEN
3055: p_result := 0;
3056:
3057: IF l_debug_level > 0 THEN
3058: OE_DEBUG_PUB.Add('No Data Found in Check_PO_Approved', 4);
3059: END IF;
3060: WHEN OTHERS THEN
3061: p_result := 1;
3062:
3060: WHEN OTHERS THEN
3061: p_result := 1;
3062:
3063: IF l_debug_level > 0 THEN
3064: OE_DEBUG_PUB.Add('When Others in Check_PO_Approved', 4);
3065: END IF;
3066:
3067: End Check_PO_Approved;
3068:
3088: l_header_id NUMBER := oe_line_security.g_record.header_id;
3089: l_drop_ship_flag VARCHAR2(1);
3090: l_source_type_code VARCHAR2(10) := oe_line_security.g_record.source_type_code;
3091:
3092: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3093:
3094: BEGIN
3095:
3096: p_result := 0;
3116:
3117: p_result := 0;
3118:
3119: IF l_debug_level > 0 THEN
3120: OE_DEBUG_PUB.Add('OM PO Discrepancy Exists', 4);
3121: END IF;
3122: ELSE
3123: p_result := 1;
3124:
3122: ELSE
3123: p_result := 1;
3124:
3125: IF l_debug_level > 0 THEN
3126: OE_DEBUG_PUB.Add('No Discrepancy Exisits', 4);
3127: END IF;
3128: END IF;
3129:
3130: EXCEPTION
3131: WHEN NO_DATA_FOUND THEN
3132: p_result := 0;
3133:
3134: IF l_debug_level > 0 THEN
3135: OE_DEBUG_PUB.Add('No Data Found in OM_PO_Discrepancy_Exists', 4);
3136: END IF;
3137: WHEN OTHERS THEN
3138: p_result := 1;
3139:
3137: WHEN OTHERS THEN
3138: p_result := 1;
3139:
3140: IF l_debug_level > 0 THEN
3141: OE_DEBUG_PUB.Add('When Others in OM_PO_Discrepancy_Exists', 4);
3142: END IF;
3143: END OM_PO_Discrepancy_Exists;
3144:
3145: END OE_DS_PVT;