APPS.OE_DEFAULT_LOT_SERIAL dependencies on FND_API

Line 150: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

146: l_return NUMBER;
147: l_quantity NUMBER;
148: l_quantity2 NUMBER;
149: l_item_rec OE_ORDER_CACHE.item_rec_type; -- INVCONV
150: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
151: -- OPM 3494420
152: UOM_CONVERSION_FAILED EXCEPTION; -- INVCONV
153:
154:

Line 232: and ( g_Lot_Serial_rec.lot_number <> FND_API.G_MISS_CHAR

228: l_quantity2 := g_Lot_Serial_rec.quantity2;
229:
230: /* --IF l_lot_ctl = 1
231: IF l_item_rec.lot_control_code = 2
232: and ( g_Lot_Serial_rec.lot_number <> FND_API.G_MISS_CHAR
233: and g_Lot_Serial_rec.lot_number IS NOT NULL )
234: then
235: begin
236: -- OPEN c_opm_lot1( l_item_rec.opm_item_id , -- INVCONV TO REVISIT

Line 255: and ( g_Lot_Serial_rec.sublot_number <> FND_API.G_MISS_CHAR

251:
252: end if; */
253:
254: /* IF l_sublot_ctl = 1 INVCONV
255: and ( g_Lot_Serial_rec.sublot_number <> FND_API.G_MISS_CHAR
256: and g_Lot_Serial_rec.sublot_number IS NOT NULL )
257: then
258: begin
259: --OPEN c_opm_lot2( l_item_rec.opm_item_id , -- INVCONV TO REVISIT

Line 331: l_return_status := FND_API.G_RET_STS_ERROR;

327: WHEN UOM_CONVERSION_FAILED THEN -- INVCONV
328:
329: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR'); -- INVCONV
330: OE_MSG_PUB.Add;
331: l_return_status := FND_API.G_RET_STS_ERROR;
332:
333: --RAISE FND_API.G_EXC_ERROR; INVCONV
334:
335:

Line 333: --RAISE FND_API.G_EXC_ERROR; INVCONV

329: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR'); -- INVCONV
330: OE_MSG_PUB.Add;
331: l_return_status := FND_API.G_RET_STS_ERROR;
332:
333: --RAISE FND_API.G_EXC_ERROR; INVCONV
334:
335:
336: WHEN FND_API.G_EXC_ERROR THEN
337:

Line 336: WHEN FND_API.G_EXC_ERROR THEN

332:
333: --RAISE FND_API.G_EXC_ERROR; INVCONV
334:
335:
336: WHEN FND_API.G_EXC_ERROR THEN
337:
338: l_return_status := FND_API.G_RET_STS_ERROR;
339:
340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 338: l_return_status := FND_API.G_RET_STS_ERROR;

334:
335:
336: WHEN FND_API.G_EXC_ERROR THEN
337:
338: l_return_status := FND_API.G_RET_STS_ERROR;
339:
340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
341:
342: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

336: WHEN FND_API.G_EXC_ERROR THEN
337:
338: l_return_status := FND_API.G_RET_STS_ERROR;
339:
340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
341:
342: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
343:
344: WHEN OTHERS THEN

Line 342: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

338: l_return_status := FND_API.G_RET_STS_ERROR;
339:
340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
341:
342: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
343:
344: WHEN OTHERS THEN
345:
346: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 346: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

342: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
343:
344: WHEN OTHERS THEN
345:
346: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
347:
348: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
349: THEN
350: OE_MSG_PUB.Add_Exc_Msg

Line 356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

352: , 'OE_Default_Lot_Serial'
353: );
354: END IF;
355:
356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
357:
358: IF l_debug_level > 0 THEN
359: oe_debug_pub.add( 'RMA exiting OE_Default_Lot_Serial.Get_Quantity' , 1 ) ;
360: END IF;

Line 419: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

415: l_return NUMBER;
416: l_quantity NUMBER;
417: l_quantity2 NUMBER;
418: l_item_rec OE_ORDER_CACHE.item_rec_type;
419: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
420: -- OPM 3494420
421: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
422: UOM_CONVERSION_FAILED EXCEPTION; -- INVCONV
423:

Line 492: and ( g_Lot_Serial_rec.lot_number <> FND_API.G_MISS_CHAR

488: l_quantity := g_Lot_Serial_rec.quantity;
489: l_quantity2 := g_Lot_Serial_rec.quantity2;
490:
491: /* IF l_lot_ctl = 1
492: and ( g_Lot_Serial_rec.lot_number <> FND_API.G_MISS_CHAR
493: and g_Lot_Serial_rec.lot_number IS NOT NULL )
494: then
495: begin
496: --OPEN c_opm_lot1( l_item_rec.opm_item_id , -- invconv to revisit

Line 516: and ( g_Lot_Serial_rec.sublot_number <> FND_API.G_MISS_CHAR

512:
513: end if; */
514:
515: /* IF l_sublot_ctl = 1 -- INVCONV
516: and ( g_Lot_Serial_rec.sublot_number <> FND_API.G_MISS_CHAR
517: and g_Lot_Serial_rec.sublot_number IS NOT NULL )
518: then
519: begin
520: -- OPEN c_opm_lot2( l_item_rec.opm_item_id , -- INVCONV TO REVISIT

Line 589: l_return_status := FND_API.G_RET_STS_ERROR;

585: WHEN UOM_CONVERSION_FAILED THEN -- INVCONV
586:
587: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR'); -- INVCONV
588: OE_MSG_PUB.Add;
589: l_return_status := FND_API.G_RET_STS_ERROR;
590:
591: --RAISE FND_API.G_EXC_ERROR; INVCONV
592:
593: WHEN FND_API.G_EXC_ERROR THEN

Line 591: --RAISE FND_API.G_EXC_ERROR; INVCONV

587: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR'); -- INVCONV
588: OE_MSG_PUB.Add;
589: l_return_status := FND_API.G_RET_STS_ERROR;
590:
591: --RAISE FND_API.G_EXC_ERROR; INVCONV
592:
593: WHEN FND_API.G_EXC_ERROR THEN
594:
595: l_return_status := FND_API.G_RET_STS_ERROR;

Line 593: WHEN FND_API.G_EXC_ERROR THEN

589: l_return_status := FND_API.G_RET_STS_ERROR;
590:
591: --RAISE FND_API.G_EXC_ERROR; INVCONV
592:
593: WHEN FND_API.G_EXC_ERROR THEN
594:
595: l_return_status := FND_API.G_RET_STS_ERROR;
596:
597:

Line 595: l_return_status := FND_API.G_RET_STS_ERROR;

591: --RAISE FND_API.G_EXC_ERROR; INVCONV
592:
593: WHEN FND_API.G_EXC_ERROR THEN
594:
595: l_return_status := FND_API.G_RET_STS_ERROR;
596:
597:
598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
599:

Line 598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

594:
595: l_return_status := FND_API.G_RET_STS_ERROR;
596:
597:
598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
599:
600: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
601:
602: WHEN OTHERS THEN

Line 600: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

596:
597:
598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
599:
600: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
601:
602: WHEN OTHERS THEN
603:
604: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 604: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

600: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
601:
602: WHEN OTHERS THEN
603:
604: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
605:
606: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
607: THEN
608: OE_MSG_PUB.Add_Exc_Msg

Line 614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

610: , 'OE_Default_Lot_Serial'
611: );
612: END IF;
613:
614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
615:
616: IF l_debug_level > 0 THEN
617: oe_debug_pub.add( 'OPM RMA exiting OE_Default_Lot_Serial.Get_Quantity2' , 1 ) ;
618: END IF;

Line 644: IF g_Lot_Serial_rec.attribute1 = FND_API.G_MISS_CHAR THEN

640: BEGIN
641:
642: -- In the future call Flex APIs for defaults
643:
644: IF g_Lot_Serial_rec.attribute1 = FND_API.G_MISS_CHAR THEN
645: g_Lot_Serial_rec.attribute1 := NULL;
646: END IF;
647:
648: IF g_Lot_Serial_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 648: IF g_Lot_Serial_rec.attribute10 = FND_API.G_MISS_CHAR THEN

644: IF g_Lot_Serial_rec.attribute1 = FND_API.G_MISS_CHAR THEN
645: g_Lot_Serial_rec.attribute1 := NULL;
646: END IF;
647:
648: IF g_Lot_Serial_rec.attribute10 = FND_API.G_MISS_CHAR THEN
649: g_Lot_Serial_rec.attribute10 := NULL;
650: END IF;
651:
652: IF g_Lot_Serial_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 652: IF g_Lot_Serial_rec.attribute11 = FND_API.G_MISS_CHAR THEN

648: IF g_Lot_Serial_rec.attribute10 = FND_API.G_MISS_CHAR THEN
649: g_Lot_Serial_rec.attribute10 := NULL;
650: END IF;
651:
652: IF g_Lot_Serial_rec.attribute11 = FND_API.G_MISS_CHAR THEN
653: g_Lot_Serial_rec.attribute11 := NULL;
654: END IF;
655:
656: IF g_Lot_Serial_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 656: IF g_Lot_Serial_rec.attribute12 = FND_API.G_MISS_CHAR THEN

652: IF g_Lot_Serial_rec.attribute11 = FND_API.G_MISS_CHAR THEN
653: g_Lot_Serial_rec.attribute11 := NULL;
654: END IF;
655:
656: IF g_Lot_Serial_rec.attribute12 = FND_API.G_MISS_CHAR THEN
657: g_Lot_Serial_rec.attribute12 := NULL;
658: END IF;
659:
660: IF g_Lot_Serial_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 660: IF g_Lot_Serial_rec.attribute13 = FND_API.G_MISS_CHAR THEN

656: IF g_Lot_Serial_rec.attribute12 = FND_API.G_MISS_CHAR THEN
657: g_Lot_Serial_rec.attribute12 := NULL;
658: END IF;
659:
660: IF g_Lot_Serial_rec.attribute13 = FND_API.G_MISS_CHAR THEN
661: g_Lot_Serial_rec.attribute13 := NULL;
662: END IF;
663:
664: IF g_Lot_Serial_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 664: IF g_Lot_Serial_rec.attribute14 = FND_API.G_MISS_CHAR THEN

660: IF g_Lot_Serial_rec.attribute13 = FND_API.G_MISS_CHAR THEN
661: g_Lot_Serial_rec.attribute13 := NULL;
662: END IF;
663:
664: IF g_Lot_Serial_rec.attribute14 = FND_API.G_MISS_CHAR THEN
665: g_Lot_Serial_rec.attribute14 := NULL;
666: END IF;
667:
668: IF g_Lot_Serial_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 668: IF g_Lot_Serial_rec.attribute15 = FND_API.G_MISS_CHAR THEN

664: IF g_Lot_Serial_rec.attribute14 = FND_API.G_MISS_CHAR THEN
665: g_Lot_Serial_rec.attribute14 := NULL;
666: END IF;
667:
668: IF g_Lot_Serial_rec.attribute15 = FND_API.G_MISS_CHAR THEN
669: g_Lot_Serial_rec.attribute15 := NULL;
670: END IF;
671:
672: IF g_Lot_Serial_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 672: IF g_Lot_Serial_rec.attribute2 = FND_API.G_MISS_CHAR THEN

668: IF g_Lot_Serial_rec.attribute15 = FND_API.G_MISS_CHAR THEN
669: g_Lot_Serial_rec.attribute15 := NULL;
670: END IF;
671:
672: IF g_Lot_Serial_rec.attribute2 = FND_API.G_MISS_CHAR THEN
673: g_Lot_Serial_rec.attribute2 := NULL;
674: END IF;
675:
676: IF g_Lot_Serial_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 676: IF g_Lot_Serial_rec.attribute3 = FND_API.G_MISS_CHAR THEN

672: IF g_Lot_Serial_rec.attribute2 = FND_API.G_MISS_CHAR THEN
673: g_Lot_Serial_rec.attribute2 := NULL;
674: END IF;
675:
676: IF g_Lot_Serial_rec.attribute3 = FND_API.G_MISS_CHAR THEN
677: g_Lot_Serial_rec.attribute3 := NULL;
678: END IF;
679:
680: IF g_Lot_Serial_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 680: IF g_Lot_Serial_rec.attribute4 = FND_API.G_MISS_CHAR THEN

676: IF g_Lot_Serial_rec.attribute3 = FND_API.G_MISS_CHAR THEN
677: g_Lot_Serial_rec.attribute3 := NULL;
678: END IF;
679:
680: IF g_Lot_Serial_rec.attribute4 = FND_API.G_MISS_CHAR THEN
681: g_Lot_Serial_rec.attribute4 := NULL;
682: END IF;
683:
684: IF g_Lot_Serial_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 684: IF g_Lot_Serial_rec.attribute5 = FND_API.G_MISS_CHAR THEN

680: IF g_Lot_Serial_rec.attribute4 = FND_API.G_MISS_CHAR THEN
681: g_Lot_Serial_rec.attribute4 := NULL;
682: END IF;
683:
684: IF g_Lot_Serial_rec.attribute5 = FND_API.G_MISS_CHAR THEN
685: g_Lot_Serial_rec.attribute5 := NULL;
686: END IF;
687:
688: IF g_Lot_Serial_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 688: IF g_Lot_Serial_rec.attribute6 = FND_API.G_MISS_CHAR THEN

684: IF g_Lot_Serial_rec.attribute5 = FND_API.G_MISS_CHAR THEN
685: g_Lot_Serial_rec.attribute5 := NULL;
686: END IF;
687:
688: IF g_Lot_Serial_rec.attribute6 = FND_API.G_MISS_CHAR THEN
689: g_Lot_Serial_rec.attribute6 := NULL;
690: END IF;
691:
692: IF g_Lot_Serial_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 692: IF g_Lot_Serial_rec.attribute7 = FND_API.G_MISS_CHAR THEN

688: IF g_Lot_Serial_rec.attribute6 = FND_API.G_MISS_CHAR THEN
689: g_Lot_Serial_rec.attribute6 := NULL;
690: END IF;
691:
692: IF g_Lot_Serial_rec.attribute7 = FND_API.G_MISS_CHAR THEN
693: g_Lot_Serial_rec.attribute7 := NULL;
694: END IF;
695:
696: IF g_Lot_Serial_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 696: IF g_Lot_Serial_rec.attribute8 = FND_API.G_MISS_CHAR THEN

692: IF g_Lot_Serial_rec.attribute7 = FND_API.G_MISS_CHAR THEN
693: g_Lot_Serial_rec.attribute7 := NULL;
694: END IF;
695:
696: IF g_Lot_Serial_rec.attribute8 = FND_API.G_MISS_CHAR THEN
697: g_Lot_Serial_rec.attribute8 := NULL;
698: END IF;
699:
700: IF g_Lot_Serial_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 700: IF g_Lot_Serial_rec.attribute9 = FND_API.G_MISS_CHAR THEN

696: IF g_Lot_Serial_rec.attribute8 = FND_API.G_MISS_CHAR THEN
697: g_Lot_Serial_rec.attribute8 := NULL;
698: END IF;
699:
700: IF g_Lot_Serial_rec.attribute9 = FND_API.G_MISS_CHAR THEN
701: g_Lot_Serial_rec.attribute9 := NULL;
702: END IF;
703:
704: IF g_Lot_Serial_rec.context = FND_API.G_MISS_CHAR THEN

Line 704: IF g_Lot_Serial_rec.context = FND_API.G_MISS_CHAR THEN

700: IF g_Lot_Serial_rec.attribute9 = FND_API.G_MISS_CHAR THEN
701: g_Lot_Serial_rec.attribute9 := NULL;
702: END IF;
703:
704: IF g_Lot_Serial_rec.context = FND_API.G_MISS_CHAR THEN
705: g_Lot_Serial_rec.context := NULL;
706: END IF;
707:
708: END Get_Flex_Lot_Serial;

Line 738: RAISE FND_API.G_EXC_ERROR;

734: FND_MSG_PUB.Add;
735:
736: END IF;
737:
738: RAISE FND_API.G_EXC_ERROR;
739:
740: END IF;
741:
742: -- Initialize g_Lot_Serial_rec

Line 749: IF g_Lot_Serial_rec.from_serial_number = FND_API.G_MISS_CHAR THEN

745:
746:
747: -- Default missing attributes.
748:
749: IF g_Lot_Serial_rec.from_serial_number = FND_API.G_MISS_CHAR THEN
750:
751: g_Lot_Serial_rec.from_serial_number := Get_From_Serial_Number;
752:
753: IF g_Lot_Serial_rec.from_serial_number IS NOT NULL THEN

Line 769: IF g_Lot_Serial_rec.line_id = FND_API.G_MISS_NUM THEN

765: END IF;
766:
767: END IF;
768:
769: IF g_Lot_Serial_rec.line_id = FND_API.G_MISS_NUM THEN
770:
771: g_Lot_Serial_rec.line_id := Get_Line;
772:
773: IF g_Lot_Serial_rec.line_id IS NOT NULL THEN

Line 790: IF g_Lot_Serial_rec.line_set_id = FND_API.G_MISS_NUM THEN

786:
787: END IF;
788:
789:
790: IF g_Lot_Serial_rec.line_set_id = FND_API.G_MISS_NUM THEN
791:
792: g_Lot_Serial_rec.line_set_id := Get_Line_Set;
793:
794: IF g_Lot_Serial_rec.line_set_id IS NOT NULL THEN

Line 818: IF g_Lot_Serial_rec.lot_number = FND_API.G_MISS_CHAR THEN

814:
815: END IF;
816:
817:
818: IF g_Lot_Serial_rec.lot_number = FND_API.G_MISS_CHAR THEN
819:
820: g_Lot_Serial_rec.lot_number := Get_Lot_Number;
821:
822: IF g_Lot_Serial_rec.lot_number IS NOT NULL THEN

Line 838: IF g_Lot_Serial_rec.lot_serial_id = FND_API.G_MISS_NUM THEN

834: END IF;
835:
836: END IF;
837:
838: IF g_Lot_Serial_rec.lot_serial_id = FND_API.G_MISS_NUM THEN
839:
840: g_Lot_Serial_rec.lot_serial_id := Get_Lot_Serial;
841:
842: IF g_Lot_Serial_rec.lot_serial_id IS NOT NULL THEN

Line 862: /*IF g_Lot_Serial_rec.sublot_number = FND_API.G_MISS_CHAR THEN --OPM 2380194 INVCONV

858:
859: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
860:
861: THEN
862: /*IF g_Lot_Serial_rec.sublot_number = FND_API.G_MISS_CHAR THEN --OPM 2380194 INVCONV
863:
864: g_Lot_Serial_rec.sublot_number := Get_SubLot_Number;
865:
866: IF g_Lot_Serial_rec.sublot_number IS NOT NULL THEN

Line 882: END IF; -- IF g_Lot_Serial_rec.sublot_number = FND_API.G_MISS_CHAR */

878: END IF; -- IF OE_Validate.SubLot_Number(g_Lot_Serial_rec.sublot_number)
879:
880: END IF; -- IF g_Lot_Serial_rec.sublot_number IS NOT NULL THEN
881:
882: END IF; -- IF g_Lot_Serial_rec.sublot_number = FND_API.G_MISS_CHAR */
883:
884:
885: IF g_Lot_Serial_rec.quantity2 = FND_API.G_MISS_NUM
886: or g_Lot_Serial_rec.quantity2 is NULL

Line 885: IF g_Lot_Serial_rec.quantity2 = FND_API.G_MISS_NUM

881:
882: END IF; -- IF g_Lot_Serial_rec.sublot_number = FND_API.G_MISS_CHAR */
883:
884:
885: IF g_Lot_Serial_rec.quantity2 = FND_API.G_MISS_NUM
886: or g_Lot_Serial_rec.quantity2 is NULL
887:
888: THEN --OPM 2380194
889:

Line 891: oe_debug_pub.add( 'OE_DEFAULT_LOT_SERIAL.ATTRIBUTES g_Lot_Serial_rec.quantity2 = FND_API.G_MISS_NUM' ) ;

887:
888: THEN --OPM 2380194
889:
890: IF l_debug_level > 0 THEN
891: oe_debug_pub.add( 'OE_DEFAULT_LOT_SERIAL.ATTRIBUTES g_Lot_Serial_rec.quantity2 = FND_API.G_MISS_NUM' ) ;
892: END IF;
893: g_Lot_Serial_rec.quantity2 := Get_Quantity2;
894:
895: IF g_Lot_Serial_rec.quantity2 IS NOT NULL THEN

Line 914: END IF; -- IF g_Lot_Serial_rec.quantity2 = FND_API.G_MISS_NUM THEN --OPM 2380194

910: END IF; -- IF OE_Validate.Quantity2(g_Lot_Serial_rec.quantity2)
911:
912: END IF; -- IF g_Lot_Serial_rec.quantity2 IS NOT NULL THEN
913:
914: END IF; -- IF g_Lot_Serial_rec.quantity2 = FND_API.G_MISS_NUM THEN --OPM 2380194
915:
916:
917:
918: END IF; -- IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'

Line 921: IF g_Lot_Serial_rec.quantity = FND_API.G_MISS_NUM THEN

917:
918: END IF; -- IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
919:
920:
921: IF g_Lot_Serial_rec.quantity = FND_API.G_MISS_NUM THEN
922:
923: g_Lot_Serial_rec.quantity := Get_Quantity;
924:
925: IF g_Lot_Serial_rec.quantity IS NOT NULL THEN

Line 941: IF g_Lot_Serial_rec.to_serial_number = FND_API.G_MISS_CHAR THEN

937: END IF;
938:
939: END IF;
940:
941: IF g_Lot_Serial_rec.to_serial_number = FND_API.G_MISS_CHAR THEN
942:
943: g_Lot_Serial_rec.to_serial_number := Get_To_Serial_Number;
944:
945: IF g_Lot_Serial_rec.to_serial_number IS NOT NULL THEN

Line 961: IF g_Lot_Serial_rec.attribute1 = FND_API.G_MISS_CHAR

957: END IF;
958:
959: END IF;
960:
961: IF g_Lot_Serial_rec.attribute1 = FND_API.G_MISS_CHAR
962: OR g_Lot_Serial_rec.attribute10 = FND_API.G_MISS_CHAR
963: OR g_Lot_Serial_rec.attribute11 = FND_API.G_MISS_CHAR
964: OR g_Lot_Serial_rec.attribute12 = FND_API.G_MISS_CHAR
965: OR g_Lot_Serial_rec.attribute13 = FND_API.G_MISS_CHAR

Line 962: OR g_Lot_Serial_rec.attribute10 = FND_API.G_MISS_CHAR

958:
959: END IF;
960:
961: IF g_Lot_Serial_rec.attribute1 = FND_API.G_MISS_CHAR
962: OR g_Lot_Serial_rec.attribute10 = FND_API.G_MISS_CHAR
963: OR g_Lot_Serial_rec.attribute11 = FND_API.G_MISS_CHAR
964: OR g_Lot_Serial_rec.attribute12 = FND_API.G_MISS_CHAR
965: OR g_Lot_Serial_rec.attribute13 = FND_API.G_MISS_CHAR
966: OR g_Lot_Serial_rec.attribute14 = FND_API.G_MISS_CHAR

Line 963: OR g_Lot_Serial_rec.attribute11 = FND_API.G_MISS_CHAR

959: END IF;
960:
961: IF g_Lot_Serial_rec.attribute1 = FND_API.G_MISS_CHAR
962: OR g_Lot_Serial_rec.attribute10 = FND_API.G_MISS_CHAR
963: OR g_Lot_Serial_rec.attribute11 = FND_API.G_MISS_CHAR
964: OR g_Lot_Serial_rec.attribute12 = FND_API.G_MISS_CHAR
965: OR g_Lot_Serial_rec.attribute13 = FND_API.G_MISS_CHAR
966: OR g_Lot_Serial_rec.attribute14 = FND_API.G_MISS_CHAR
967: OR g_Lot_Serial_rec.attribute15 = FND_API.G_MISS_CHAR

Line 964: OR g_Lot_Serial_rec.attribute12 = FND_API.G_MISS_CHAR

960:
961: IF g_Lot_Serial_rec.attribute1 = FND_API.G_MISS_CHAR
962: OR g_Lot_Serial_rec.attribute10 = FND_API.G_MISS_CHAR
963: OR g_Lot_Serial_rec.attribute11 = FND_API.G_MISS_CHAR
964: OR g_Lot_Serial_rec.attribute12 = FND_API.G_MISS_CHAR
965: OR g_Lot_Serial_rec.attribute13 = FND_API.G_MISS_CHAR
966: OR g_Lot_Serial_rec.attribute14 = FND_API.G_MISS_CHAR
967: OR g_Lot_Serial_rec.attribute15 = FND_API.G_MISS_CHAR
968: OR g_Lot_Serial_rec.attribute2 = FND_API.G_MISS_CHAR

Line 965: OR g_Lot_Serial_rec.attribute13 = FND_API.G_MISS_CHAR

961: IF g_Lot_Serial_rec.attribute1 = FND_API.G_MISS_CHAR
962: OR g_Lot_Serial_rec.attribute10 = FND_API.G_MISS_CHAR
963: OR g_Lot_Serial_rec.attribute11 = FND_API.G_MISS_CHAR
964: OR g_Lot_Serial_rec.attribute12 = FND_API.G_MISS_CHAR
965: OR g_Lot_Serial_rec.attribute13 = FND_API.G_MISS_CHAR
966: OR g_Lot_Serial_rec.attribute14 = FND_API.G_MISS_CHAR
967: OR g_Lot_Serial_rec.attribute15 = FND_API.G_MISS_CHAR
968: OR g_Lot_Serial_rec.attribute2 = FND_API.G_MISS_CHAR
969: OR g_Lot_Serial_rec.attribute3 = FND_API.G_MISS_CHAR

Line 966: OR g_Lot_Serial_rec.attribute14 = FND_API.G_MISS_CHAR

962: OR g_Lot_Serial_rec.attribute10 = FND_API.G_MISS_CHAR
963: OR g_Lot_Serial_rec.attribute11 = FND_API.G_MISS_CHAR
964: OR g_Lot_Serial_rec.attribute12 = FND_API.G_MISS_CHAR
965: OR g_Lot_Serial_rec.attribute13 = FND_API.G_MISS_CHAR
966: OR g_Lot_Serial_rec.attribute14 = FND_API.G_MISS_CHAR
967: OR g_Lot_Serial_rec.attribute15 = FND_API.G_MISS_CHAR
968: OR g_Lot_Serial_rec.attribute2 = FND_API.G_MISS_CHAR
969: OR g_Lot_Serial_rec.attribute3 = FND_API.G_MISS_CHAR
970: OR g_Lot_Serial_rec.attribute4 = FND_API.G_MISS_CHAR

Line 967: OR g_Lot_Serial_rec.attribute15 = FND_API.G_MISS_CHAR

963: OR g_Lot_Serial_rec.attribute11 = FND_API.G_MISS_CHAR
964: OR g_Lot_Serial_rec.attribute12 = FND_API.G_MISS_CHAR
965: OR g_Lot_Serial_rec.attribute13 = FND_API.G_MISS_CHAR
966: OR g_Lot_Serial_rec.attribute14 = FND_API.G_MISS_CHAR
967: OR g_Lot_Serial_rec.attribute15 = FND_API.G_MISS_CHAR
968: OR g_Lot_Serial_rec.attribute2 = FND_API.G_MISS_CHAR
969: OR g_Lot_Serial_rec.attribute3 = FND_API.G_MISS_CHAR
970: OR g_Lot_Serial_rec.attribute4 = FND_API.G_MISS_CHAR
971: OR g_Lot_Serial_rec.attribute5 = FND_API.G_MISS_CHAR

Line 968: OR g_Lot_Serial_rec.attribute2 = FND_API.G_MISS_CHAR

964: OR g_Lot_Serial_rec.attribute12 = FND_API.G_MISS_CHAR
965: OR g_Lot_Serial_rec.attribute13 = FND_API.G_MISS_CHAR
966: OR g_Lot_Serial_rec.attribute14 = FND_API.G_MISS_CHAR
967: OR g_Lot_Serial_rec.attribute15 = FND_API.G_MISS_CHAR
968: OR g_Lot_Serial_rec.attribute2 = FND_API.G_MISS_CHAR
969: OR g_Lot_Serial_rec.attribute3 = FND_API.G_MISS_CHAR
970: OR g_Lot_Serial_rec.attribute4 = FND_API.G_MISS_CHAR
971: OR g_Lot_Serial_rec.attribute5 = FND_API.G_MISS_CHAR
972: OR g_Lot_Serial_rec.attribute6 = FND_API.G_MISS_CHAR

Line 969: OR g_Lot_Serial_rec.attribute3 = FND_API.G_MISS_CHAR

965: OR g_Lot_Serial_rec.attribute13 = FND_API.G_MISS_CHAR
966: OR g_Lot_Serial_rec.attribute14 = FND_API.G_MISS_CHAR
967: OR g_Lot_Serial_rec.attribute15 = FND_API.G_MISS_CHAR
968: OR g_Lot_Serial_rec.attribute2 = FND_API.G_MISS_CHAR
969: OR g_Lot_Serial_rec.attribute3 = FND_API.G_MISS_CHAR
970: OR g_Lot_Serial_rec.attribute4 = FND_API.G_MISS_CHAR
971: OR g_Lot_Serial_rec.attribute5 = FND_API.G_MISS_CHAR
972: OR g_Lot_Serial_rec.attribute6 = FND_API.G_MISS_CHAR
973: OR g_Lot_Serial_rec.attribute7 = FND_API.G_MISS_CHAR

Line 970: OR g_Lot_Serial_rec.attribute4 = FND_API.G_MISS_CHAR

966: OR g_Lot_Serial_rec.attribute14 = FND_API.G_MISS_CHAR
967: OR g_Lot_Serial_rec.attribute15 = FND_API.G_MISS_CHAR
968: OR g_Lot_Serial_rec.attribute2 = FND_API.G_MISS_CHAR
969: OR g_Lot_Serial_rec.attribute3 = FND_API.G_MISS_CHAR
970: OR g_Lot_Serial_rec.attribute4 = FND_API.G_MISS_CHAR
971: OR g_Lot_Serial_rec.attribute5 = FND_API.G_MISS_CHAR
972: OR g_Lot_Serial_rec.attribute6 = FND_API.G_MISS_CHAR
973: OR g_Lot_Serial_rec.attribute7 = FND_API.G_MISS_CHAR
974: OR g_Lot_Serial_rec.attribute8 = FND_API.G_MISS_CHAR

Line 971: OR g_Lot_Serial_rec.attribute5 = FND_API.G_MISS_CHAR

967: OR g_Lot_Serial_rec.attribute15 = FND_API.G_MISS_CHAR
968: OR g_Lot_Serial_rec.attribute2 = FND_API.G_MISS_CHAR
969: OR g_Lot_Serial_rec.attribute3 = FND_API.G_MISS_CHAR
970: OR g_Lot_Serial_rec.attribute4 = FND_API.G_MISS_CHAR
971: OR g_Lot_Serial_rec.attribute5 = FND_API.G_MISS_CHAR
972: OR g_Lot_Serial_rec.attribute6 = FND_API.G_MISS_CHAR
973: OR g_Lot_Serial_rec.attribute7 = FND_API.G_MISS_CHAR
974: OR g_Lot_Serial_rec.attribute8 = FND_API.G_MISS_CHAR
975: OR g_Lot_Serial_rec.attribute9 = FND_API.G_MISS_CHAR

Line 972: OR g_Lot_Serial_rec.attribute6 = FND_API.G_MISS_CHAR

968: OR g_Lot_Serial_rec.attribute2 = FND_API.G_MISS_CHAR
969: OR g_Lot_Serial_rec.attribute3 = FND_API.G_MISS_CHAR
970: OR g_Lot_Serial_rec.attribute4 = FND_API.G_MISS_CHAR
971: OR g_Lot_Serial_rec.attribute5 = FND_API.G_MISS_CHAR
972: OR g_Lot_Serial_rec.attribute6 = FND_API.G_MISS_CHAR
973: OR g_Lot_Serial_rec.attribute7 = FND_API.G_MISS_CHAR
974: OR g_Lot_Serial_rec.attribute8 = FND_API.G_MISS_CHAR
975: OR g_Lot_Serial_rec.attribute9 = FND_API.G_MISS_CHAR
976: OR g_Lot_Serial_rec.context = FND_API.G_MISS_CHAR

Line 973: OR g_Lot_Serial_rec.attribute7 = FND_API.G_MISS_CHAR

969: OR g_Lot_Serial_rec.attribute3 = FND_API.G_MISS_CHAR
970: OR g_Lot_Serial_rec.attribute4 = FND_API.G_MISS_CHAR
971: OR g_Lot_Serial_rec.attribute5 = FND_API.G_MISS_CHAR
972: OR g_Lot_Serial_rec.attribute6 = FND_API.G_MISS_CHAR
973: OR g_Lot_Serial_rec.attribute7 = FND_API.G_MISS_CHAR
974: OR g_Lot_Serial_rec.attribute8 = FND_API.G_MISS_CHAR
975: OR g_Lot_Serial_rec.attribute9 = FND_API.G_MISS_CHAR
976: OR g_Lot_Serial_rec.context = FND_API.G_MISS_CHAR
977: THEN

Line 974: OR g_Lot_Serial_rec.attribute8 = FND_API.G_MISS_CHAR

970: OR g_Lot_Serial_rec.attribute4 = FND_API.G_MISS_CHAR
971: OR g_Lot_Serial_rec.attribute5 = FND_API.G_MISS_CHAR
972: OR g_Lot_Serial_rec.attribute6 = FND_API.G_MISS_CHAR
973: OR g_Lot_Serial_rec.attribute7 = FND_API.G_MISS_CHAR
974: OR g_Lot_Serial_rec.attribute8 = FND_API.G_MISS_CHAR
975: OR g_Lot_Serial_rec.attribute9 = FND_API.G_MISS_CHAR
976: OR g_Lot_Serial_rec.context = FND_API.G_MISS_CHAR
977: THEN
978:

Line 975: OR g_Lot_Serial_rec.attribute9 = FND_API.G_MISS_CHAR

971: OR g_Lot_Serial_rec.attribute5 = FND_API.G_MISS_CHAR
972: OR g_Lot_Serial_rec.attribute6 = FND_API.G_MISS_CHAR
973: OR g_Lot_Serial_rec.attribute7 = FND_API.G_MISS_CHAR
974: OR g_Lot_Serial_rec.attribute8 = FND_API.G_MISS_CHAR
975: OR g_Lot_Serial_rec.attribute9 = FND_API.G_MISS_CHAR
976: OR g_Lot_Serial_rec.context = FND_API.G_MISS_CHAR
977: THEN
978:
979: Get_Flex_Lot_Serial;

Line 976: OR g_Lot_Serial_rec.context = FND_API.G_MISS_CHAR

972: OR g_Lot_Serial_rec.attribute6 = FND_API.G_MISS_CHAR
973: OR g_Lot_Serial_rec.attribute7 = FND_API.G_MISS_CHAR
974: OR g_Lot_Serial_rec.attribute8 = FND_API.G_MISS_CHAR
975: OR g_Lot_Serial_rec.attribute9 = FND_API.G_MISS_CHAR
976: OR g_Lot_Serial_rec.context = FND_API.G_MISS_CHAR
977: THEN
978:
979: Get_Flex_Lot_Serial;
980:

Line 983: IF g_Lot_Serial_rec.created_by = FND_API.G_MISS_NUM THEN

979: Get_Flex_Lot_Serial;
980:
981: END IF;
982:
983: IF g_Lot_Serial_rec.created_by = FND_API.G_MISS_NUM THEN
984:
985: g_Lot_Serial_rec.created_by := NULL;
986:
987: END IF;

Line 989: IF g_Lot_Serial_rec.creation_date = FND_API.G_MISS_DATE THEN

985: g_Lot_Serial_rec.created_by := NULL;
986:
987: END IF;
988:
989: IF g_Lot_Serial_rec.creation_date = FND_API.G_MISS_DATE THEN
990:
991: g_Lot_Serial_rec.creation_date := NULL;
992:
993: END IF;

Line 995: IF g_Lot_Serial_rec.last_updated_by = FND_API.G_MISS_NUM THEN

991: g_Lot_Serial_rec.creation_date := NULL;
992:
993: END IF;
994:
995: IF g_Lot_Serial_rec.last_updated_by = FND_API.G_MISS_NUM THEN
996:
997: g_Lot_Serial_rec.last_updated_by := NULL;
998:
999: END IF;

Line 1001: IF g_Lot_Serial_rec.last_update_date = FND_API.G_MISS_DATE THEN

997: g_Lot_Serial_rec.last_updated_by := NULL;
998:
999: END IF;
1000:
1001: IF g_Lot_Serial_rec.last_update_date = FND_API.G_MISS_DATE THEN
1002:
1003: g_Lot_Serial_rec.last_update_date := NULL;
1004:
1005: END IF;

Line 1007: IF g_Lot_Serial_rec.last_update_login = FND_API.G_MISS_NUM THEN

1003: g_Lot_Serial_rec.last_update_date := NULL;
1004:
1005: END IF;
1006:
1007: IF g_Lot_Serial_rec.last_update_login = FND_API.G_MISS_NUM THEN
1008:
1009: g_Lot_Serial_rec.last_update_login := NULL;
1010:
1011: END IF;

Line 1015: IF g_Lot_Serial_rec.attribute1 = FND_API.G_MISS_CHAR

1011: END IF;
1012:
1013: -- Redefault if there are any missing attributes.
1014:
1015: IF g_Lot_Serial_rec.attribute1 = FND_API.G_MISS_CHAR
1016: OR g_Lot_Serial_rec.attribute10 = FND_API.G_MISS_CHAR
1017: OR g_Lot_Serial_rec.attribute11 = FND_API.G_MISS_CHAR
1018: OR g_Lot_Serial_rec.attribute12 = FND_API.G_MISS_CHAR
1019: OR g_Lot_Serial_rec.attribute13 = FND_API.G_MISS_CHAR

Line 1016: OR g_Lot_Serial_rec.attribute10 = FND_API.G_MISS_CHAR

1012:
1013: -- Redefault if there are any missing attributes.
1014:
1015: IF g_Lot_Serial_rec.attribute1 = FND_API.G_MISS_CHAR
1016: OR g_Lot_Serial_rec.attribute10 = FND_API.G_MISS_CHAR
1017: OR g_Lot_Serial_rec.attribute11 = FND_API.G_MISS_CHAR
1018: OR g_Lot_Serial_rec.attribute12 = FND_API.G_MISS_CHAR
1019: OR g_Lot_Serial_rec.attribute13 = FND_API.G_MISS_CHAR
1020: OR g_Lot_Serial_rec.attribute14 = FND_API.G_MISS_CHAR

Line 1017: OR g_Lot_Serial_rec.attribute11 = FND_API.G_MISS_CHAR

1013: -- Redefault if there are any missing attributes.
1014:
1015: IF g_Lot_Serial_rec.attribute1 = FND_API.G_MISS_CHAR
1016: OR g_Lot_Serial_rec.attribute10 = FND_API.G_MISS_CHAR
1017: OR g_Lot_Serial_rec.attribute11 = FND_API.G_MISS_CHAR
1018: OR g_Lot_Serial_rec.attribute12 = FND_API.G_MISS_CHAR
1019: OR g_Lot_Serial_rec.attribute13 = FND_API.G_MISS_CHAR
1020: OR g_Lot_Serial_rec.attribute14 = FND_API.G_MISS_CHAR
1021: OR g_Lot_Serial_rec.attribute15 = FND_API.G_MISS_CHAR

Line 1018: OR g_Lot_Serial_rec.attribute12 = FND_API.G_MISS_CHAR

1014:
1015: IF g_Lot_Serial_rec.attribute1 = FND_API.G_MISS_CHAR
1016: OR g_Lot_Serial_rec.attribute10 = FND_API.G_MISS_CHAR
1017: OR g_Lot_Serial_rec.attribute11 = FND_API.G_MISS_CHAR
1018: OR g_Lot_Serial_rec.attribute12 = FND_API.G_MISS_CHAR
1019: OR g_Lot_Serial_rec.attribute13 = FND_API.G_MISS_CHAR
1020: OR g_Lot_Serial_rec.attribute14 = FND_API.G_MISS_CHAR
1021: OR g_Lot_Serial_rec.attribute15 = FND_API.G_MISS_CHAR
1022: OR g_Lot_Serial_rec.attribute2 = FND_API.G_MISS_CHAR

Line 1019: OR g_Lot_Serial_rec.attribute13 = FND_API.G_MISS_CHAR

1015: IF g_Lot_Serial_rec.attribute1 = FND_API.G_MISS_CHAR
1016: OR g_Lot_Serial_rec.attribute10 = FND_API.G_MISS_CHAR
1017: OR g_Lot_Serial_rec.attribute11 = FND_API.G_MISS_CHAR
1018: OR g_Lot_Serial_rec.attribute12 = FND_API.G_MISS_CHAR
1019: OR g_Lot_Serial_rec.attribute13 = FND_API.G_MISS_CHAR
1020: OR g_Lot_Serial_rec.attribute14 = FND_API.G_MISS_CHAR
1021: OR g_Lot_Serial_rec.attribute15 = FND_API.G_MISS_CHAR
1022: OR g_Lot_Serial_rec.attribute2 = FND_API.G_MISS_CHAR
1023: OR g_Lot_Serial_rec.attribute3 = FND_API.G_MISS_CHAR

Line 1020: OR g_Lot_Serial_rec.attribute14 = FND_API.G_MISS_CHAR

1016: OR g_Lot_Serial_rec.attribute10 = FND_API.G_MISS_CHAR
1017: OR g_Lot_Serial_rec.attribute11 = FND_API.G_MISS_CHAR
1018: OR g_Lot_Serial_rec.attribute12 = FND_API.G_MISS_CHAR
1019: OR g_Lot_Serial_rec.attribute13 = FND_API.G_MISS_CHAR
1020: OR g_Lot_Serial_rec.attribute14 = FND_API.G_MISS_CHAR
1021: OR g_Lot_Serial_rec.attribute15 = FND_API.G_MISS_CHAR
1022: OR g_Lot_Serial_rec.attribute2 = FND_API.G_MISS_CHAR
1023: OR g_Lot_Serial_rec.attribute3 = FND_API.G_MISS_CHAR
1024: OR g_Lot_Serial_rec.attribute4 = FND_API.G_MISS_CHAR

Line 1021: OR g_Lot_Serial_rec.attribute15 = FND_API.G_MISS_CHAR

1017: OR g_Lot_Serial_rec.attribute11 = FND_API.G_MISS_CHAR
1018: OR g_Lot_Serial_rec.attribute12 = FND_API.G_MISS_CHAR
1019: OR g_Lot_Serial_rec.attribute13 = FND_API.G_MISS_CHAR
1020: OR g_Lot_Serial_rec.attribute14 = FND_API.G_MISS_CHAR
1021: OR g_Lot_Serial_rec.attribute15 = FND_API.G_MISS_CHAR
1022: OR g_Lot_Serial_rec.attribute2 = FND_API.G_MISS_CHAR
1023: OR g_Lot_Serial_rec.attribute3 = FND_API.G_MISS_CHAR
1024: OR g_Lot_Serial_rec.attribute4 = FND_API.G_MISS_CHAR
1025: OR g_Lot_Serial_rec.attribute5 = FND_API.G_MISS_CHAR

Line 1022: OR g_Lot_Serial_rec.attribute2 = FND_API.G_MISS_CHAR

1018: OR g_Lot_Serial_rec.attribute12 = FND_API.G_MISS_CHAR
1019: OR g_Lot_Serial_rec.attribute13 = FND_API.G_MISS_CHAR
1020: OR g_Lot_Serial_rec.attribute14 = FND_API.G_MISS_CHAR
1021: OR g_Lot_Serial_rec.attribute15 = FND_API.G_MISS_CHAR
1022: OR g_Lot_Serial_rec.attribute2 = FND_API.G_MISS_CHAR
1023: OR g_Lot_Serial_rec.attribute3 = FND_API.G_MISS_CHAR
1024: OR g_Lot_Serial_rec.attribute4 = FND_API.G_MISS_CHAR
1025: OR g_Lot_Serial_rec.attribute5 = FND_API.G_MISS_CHAR
1026: OR g_Lot_Serial_rec.attribute6 = FND_API.G_MISS_CHAR

Line 1023: OR g_Lot_Serial_rec.attribute3 = FND_API.G_MISS_CHAR

1019: OR g_Lot_Serial_rec.attribute13 = FND_API.G_MISS_CHAR
1020: OR g_Lot_Serial_rec.attribute14 = FND_API.G_MISS_CHAR
1021: OR g_Lot_Serial_rec.attribute15 = FND_API.G_MISS_CHAR
1022: OR g_Lot_Serial_rec.attribute2 = FND_API.G_MISS_CHAR
1023: OR g_Lot_Serial_rec.attribute3 = FND_API.G_MISS_CHAR
1024: OR g_Lot_Serial_rec.attribute4 = FND_API.G_MISS_CHAR
1025: OR g_Lot_Serial_rec.attribute5 = FND_API.G_MISS_CHAR
1026: OR g_Lot_Serial_rec.attribute6 = FND_API.G_MISS_CHAR
1027: OR g_Lot_Serial_rec.attribute7 = FND_API.G_MISS_CHAR

Line 1024: OR g_Lot_Serial_rec.attribute4 = FND_API.G_MISS_CHAR

1020: OR g_Lot_Serial_rec.attribute14 = FND_API.G_MISS_CHAR
1021: OR g_Lot_Serial_rec.attribute15 = FND_API.G_MISS_CHAR
1022: OR g_Lot_Serial_rec.attribute2 = FND_API.G_MISS_CHAR
1023: OR g_Lot_Serial_rec.attribute3 = FND_API.G_MISS_CHAR
1024: OR g_Lot_Serial_rec.attribute4 = FND_API.G_MISS_CHAR
1025: OR g_Lot_Serial_rec.attribute5 = FND_API.G_MISS_CHAR
1026: OR g_Lot_Serial_rec.attribute6 = FND_API.G_MISS_CHAR
1027: OR g_Lot_Serial_rec.attribute7 = FND_API.G_MISS_CHAR
1028: OR g_Lot_Serial_rec.attribute8 = FND_API.G_MISS_CHAR

Line 1025: OR g_Lot_Serial_rec.attribute5 = FND_API.G_MISS_CHAR

1021: OR g_Lot_Serial_rec.attribute15 = FND_API.G_MISS_CHAR
1022: OR g_Lot_Serial_rec.attribute2 = FND_API.G_MISS_CHAR
1023: OR g_Lot_Serial_rec.attribute3 = FND_API.G_MISS_CHAR
1024: OR g_Lot_Serial_rec.attribute4 = FND_API.G_MISS_CHAR
1025: OR g_Lot_Serial_rec.attribute5 = FND_API.G_MISS_CHAR
1026: OR g_Lot_Serial_rec.attribute6 = FND_API.G_MISS_CHAR
1027: OR g_Lot_Serial_rec.attribute7 = FND_API.G_MISS_CHAR
1028: OR g_Lot_Serial_rec.attribute8 = FND_API.G_MISS_CHAR
1029: OR g_Lot_Serial_rec.attribute9 = FND_API.G_MISS_CHAR

Line 1026: OR g_Lot_Serial_rec.attribute6 = FND_API.G_MISS_CHAR

1022: OR g_Lot_Serial_rec.attribute2 = FND_API.G_MISS_CHAR
1023: OR g_Lot_Serial_rec.attribute3 = FND_API.G_MISS_CHAR
1024: OR g_Lot_Serial_rec.attribute4 = FND_API.G_MISS_CHAR
1025: OR g_Lot_Serial_rec.attribute5 = FND_API.G_MISS_CHAR
1026: OR g_Lot_Serial_rec.attribute6 = FND_API.G_MISS_CHAR
1027: OR g_Lot_Serial_rec.attribute7 = FND_API.G_MISS_CHAR
1028: OR g_Lot_Serial_rec.attribute8 = FND_API.G_MISS_CHAR
1029: OR g_Lot_Serial_rec.attribute9 = FND_API.G_MISS_CHAR
1030: OR g_Lot_Serial_rec.context = FND_API.G_MISS_CHAR

Line 1027: OR g_Lot_Serial_rec.attribute7 = FND_API.G_MISS_CHAR

1023: OR g_Lot_Serial_rec.attribute3 = FND_API.G_MISS_CHAR
1024: OR g_Lot_Serial_rec.attribute4 = FND_API.G_MISS_CHAR
1025: OR g_Lot_Serial_rec.attribute5 = FND_API.G_MISS_CHAR
1026: OR g_Lot_Serial_rec.attribute6 = FND_API.G_MISS_CHAR
1027: OR g_Lot_Serial_rec.attribute7 = FND_API.G_MISS_CHAR
1028: OR g_Lot_Serial_rec.attribute8 = FND_API.G_MISS_CHAR
1029: OR g_Lot_Serial_rec.attribute9 = FND_API.G_MISS_CHAR
1030: OR g_Lot_Serial_rec.context = FND_API.G_MISS_CHAR
1031: OR g_Lot_Serial_rec.created_by = FND_API.G_MISS_NUM

Line 1028: OR g_Lot_Serial_rec.attribute8 = FND_API.G_MISS_CHAR

1024: OR g_Lot_Serial_rec.attribute4 = FND_API.G_MISS_CHAR
1025: OR g_Lot_Serial_rec.attribute5 = FND_API.G_MISS_CHAR
1026: OR g_Lot_Serial_rec.attribute6 = FND_API.G_MISS_CHAR
1027: OR g_Lot_Serial_rec.attribute7 = FND_API.G_MISS_CHAR
1028: OR g_Lot_Serial_rec.attribute8 = FND_API.G_MISS_CHAR
1029: OR g_Lot_Serial_rec.attribute9 = FND_API.G_MISS_CHAR
1030: OR g_Lot_Serial_rec.context = FND_API.G_MISS_CHAR
1031: OR g_Lot_Serial_rec.created_by = FND_API.G_MISS_NUM
1032: OR g_Lot_Serial_rec.creation_date = FND_API.G_MISS_DATE

Line 1029: OR g_Lot_Serial_rec.attribute9 = FND_API.G_MISS_CHAR

1025: OR g_Lot_Serial_rec.attribute5 = FND_API.G_MISS_CHAR
1026: OR g_Lot_Serial_rec.attribute6 = FND_API.G_MISS_CHAR
1027: OR g_Lot_Serial_rec.attribute7 = FND_API.G_MISS_CHAR
1028: OR g_Lot_Serial_rec.attribute8 = FND_API.G_MISS_CHAR
1029: OR g_Lot_Serial_rec.attribute9 = FND_API.G_MISS_CHAR
1030: OR g_Lot_Serial_rec.context = FND_API.G_MISS_CHAR
1031: OR g_Lot_Serial_rec.created_by = FND_API.G_MISS_NUM
1032: OR g_Lot_Serial_rec.creation_date = FND_API.G_MISS_DATE
1033: OR g_Lot_Serial_rec.from_serial_number = FND_API.G_MISS_CHAR

Line 1030: OR g_Lot_Serial_rec.context = FND_API.G_MISS_CHAR

1026: OR g_Lot_Serial_rec.attribute6 = FND_API.G_MISS_CHAR
1027: OR g_Lot_Serial_rec.attribute7 = FND_API.G_MISS_CHAR
1028: OR g_Lot_Serial_rec.attribute8 = FND_API.G_MISS_CHAR
1029: OR g_Lot_Serial_rec.attribute9 = FND_API.G_MISS_CHAR
1030: OR g_Lot_Serial_rec.context = FND_API.G_MISS_CHAR
1031: OR g_Lot_Serial_rec.created_by = FND_API.G_MISS_NUM
1032: OR g_Lot_Serial_rec.creation_date = FND_API.G_MISS_DATE
1033: OR g_Lot_Serial_rec.from_serial_number = FND_API.G_MISS_CHAR
1034: OR g_Lot_Serial_rec.last_updated_by = FND_API.G_MISS_NUM

Line 1031: OR g_Lot_Serial_rec.created_by = FND_API.G_MISS_NUM

1027: OR g_Lot_Serial_rec.attribute7 = FND_API.G_MISS_CHAR
1028: OR g_Lot_Serial_rec.attribute8 = FND_API.G_MISS_CHAR
1029: OR g_Lot_Serial_rec.attribute9 = FND_API.G_MISS_CHAR
1030: OR g_Lot_Serial_rec.context = FND_API.G_MISS_CHAR
1031: OR g_Lot_Serial_rec.created_by = FND_API.G_MISS_NUM
1032: OR g_Lot_Serial_rec.creation_date = FND_API.G_MISS_DATE
1033: OR g_Lot_Serial_rec.from_serial_number = FND_API.G_MISS_CHAR
1034: OR g_Lot_Serial_rec.last_updated_by = FND_API.G_MISS_NUM
1035: OR g_Lot_Serial_rec.last_update_date = FND_API.G_MISS_DATE

Line 1032: OR g_Lot_Serial_rec.creation_date = FND_API.G_MISS_DATE

1028: OR g_Lot_Serial_rec.attribute8 = FND_API.G_MISS_CHAR
1029: OR g_Lot_Serial_rec.attribute9 = FND_API.G_MISS_CHAR
1030: OR g_Lot_Serial_rec.context = FND_API.G_MISS_CHAR
1031: OR g_Lot_Serial_rec.created_by = FND_API.G_MISS_NUM
1032: OR g_Lot_Serial_rec.creation_date = FND_API.G_MISS_DATE
1033: OR g_Lot_Serial_rec.from_serial_number = FND_API.G_MISS_CHAR
1034: OR g_Lot_Serial_rec.last_updated_by = FND_API.G_MISS_NUM
1035: OR g_Lot_Serial_rec.last_update_date = FND_API.G_MISS_DATE
1036: OR g_Lot_Serial_rec.last_update_login = FND_API.G_MISS_NUM

Line 1033: OR g_Lot_Serial_rec.from_serial_number = FND_API.G_MISS_CHAR

1029: OR g_Lot_Serial_rec.attribute9 = FND_API.G_MISS_CHAR
1030: OR g_Lot_Serial_rec.context = FND_API.G_MISS_CHAR
1031: OR g_Lot_Serial_rec.created_by = FND_API.G_MISS_NUM
1032: OR g_Lot_Serial_rec.creation_date = FND_API.G_MISS_DATE
1033: OR g_Lot_Serial_rec.from_serial_number = FND_API.G_MISS_CHAR
1034: OR g_Lot_Serial_rec.last_updated_by = FND_API.G_MISS_NUM
1035: OR g_Lot_Serial_rec.last_update_date = FND_API.G_MISS_DATE
1036: OR g_Lot_Serial_rec.last_update_login = FND_API.G_MISS_NUM
1037: OR g_Lot_Serial_rec.line_id = FND_API.G_MISS_NUM

Line 1034: OR g_Lot_Serial_rec.last_updated_by = FND_API.G_MISS_NUM

1030: OR g_Lot_Serial_rec.context = FND_API.G_MISS_CHAR
1031: OR g_Lot_Serial_rec.created_by = FND_API.G_MISS_NUM
1032: OR g_Lot_Serial_rec.creation_date = FND_API.G_MISS_DATE
1033: OR g_Lot_Serial_rec.from_serial_number = FND_API.G_MISS_CHAR
1034: OR g_Lot_Serial_rec.last_updated_by = FND_API.G_MISS_NUM
1035: OR g_Lot_Serial_rec.last_update_date = FND_API.G_MISS_DATE
1036: OR g_Lot_Serial_rec.last_update_login = FND_API.G_MISS_NUM
1037: OR g_Lot_Serial_rec.line_id = FND_API.G_MISS_NUM
1038: OR g_Lot_Serial_rec.lot_number = FND_API.G_MISS_CHAR

Line 1035: OR g_Lot_Serial_rec.last_update_date = FND_API.G_MISS_DATE

1031: OR g_Lot_Serial_rec.created_by = FND_API.G_MISS_NUM
1032: OR g_Lot_Serial_rec.creation_date = FND_API.G_MISS_DATE
1033: OR g_Lot_Serial_rec.from_serial_number = FND_API.G_MISS_CHAR
1034: OR g_Lot_Serial_rec.last_updated_by = FND_API.G_MISS_NUM
1035: OR g_Lot_Serial_rec.last_update_date = FND_API.G_MISS_DATE
1036: OR g_Lot_Serial_rec.last_update_login = FND_API.G_MISS_NUM
1037: OR g_Lot_Serial_rec.line_id = FND_API.G_MISS_NUM
1038: OR g_Lot_Serial_rec.lot_number = FND_API.G_MISS_CHAR
1039: --OR ( g_Lot_Serial_rec.sublot_number = FND_API.G_MISS_CHAR and OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510') --OPM 2380194 INVCONV

Line 1036: OR g_Lot_Serial_rec.last_update_login = FND_API.G_MISS_NUM

1032: OR g_Lot_Serial_rec.creation_date = FND_API.G_MISS_DATE
1033: OR g_Lot_Serial_rec.from_serial_number = FND_API.G_MISS_CHAR
1034: OR g_Lot_Serial_rec.last_updated_by = FND_API.G_MISS_NUM
1035: OR g_Lot_Serial_rec.last_update_date = FND_API.G_MISS_DATE
1036: OR g_Lot_Serial_rec.last_update_login = FND_API.G_MISS_NUM
1037: OR g_Lot_Serial_rec.line_id = FND_API.G_MISS_NUM
1038: OR g_Lot_Serial_rec.lot_number = FND_API.G_MISS_CHAR
1039: --OR ( g_Lot_Serial_rec.sublot_number = FND_API.G_MISS_CHAR and OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510') --OPM 2380194 INVCONV
1040: OR g_Lot_Serial_rec.lot_serial_id = FND_API.G_MISS_NUM

Line 1037: OR g_Lot_Serial_rec.line_id = FND_API.G_MISS_NUM

1033: OR g_Lot_Serial_rec.from_serial_number = FND_API.G_MISS_CHAR
1034: OR g_Lot_Serial_rec.last_updated_by = FND_API.G_MISS_NUM
1035: OR g_Lot_Serial_rec.last_update_date = FND_API.G_MISS_DATE
1036: OR g_Lot_Serial_rec.last_update_login = FND_API.G_MISS_NUM
1037: OR g_Lot_Serial_rec.line_id = FND_API.G_MISS_NUM
1038: OR g_Lot_Serial_rec.lot_number = FND_API.G_MISS_CHAR
1039: --OR ( g_Lot_Serial_rec.sublot_number = FND_API.G_MISS_CHAR and OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510') --OPM 2380194 INVCONV
1040: OR g_Lot_Serial_rec.lot_serial_id = FND_API.G_MISS_NUM
1041: OR g_Lot_Serial_rec.quantity = FND_API.G_MISS_NUM

Line 1038: OR g_Lot_Serial_rec.lot_number = FND_API.G_MISS_CHAR

1034: OR g_Lot_Serial_rec.last_updated_by = FND_API.G_MISS_NUM
1035: OR g_Lot_Serial_rec.last_update_date = FND_API.G_MISS_DATE
1036: OR g_Lot_Serial_rec.last_update_login = FND_API.G_MISS_NUM
1037: OR g_Lot_Serial_rec.line_id = FND_API.G_MISS_NUM
1038: OR g_Lot_Serial_rec.lot_number = FND_API.G_MISS_CHAR
1039: --OR ( g_Lot_Serial_rec.sublot_number = FND_API.G_MISS_CHAR and OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510') --OPM 2380194 INVCONV
1040: OR g_Lot_Serial_rec.lot_serial_id = FND_API.G_MISS_NUM
1041: OR g_Lot_Serial_rec.quantity = FND_API.G_MISS_NUM
1042: OR ( g_Lot_Serial_rec.quantity2 = FND_API.G_MISS_NUM and OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510') --OPM 2380194

Line 1039: --OR ( g_Lot_Serial_rec.sublot_number = FND_API.G_MISS_CHAR and OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510') --OPM 2380194 INVCONV

1035: OR g_Lot_Serial_rec.last_update_date = FND_API.G_MISS_DATE
1036: OR g_Lot_Serial_rec.last_update_login = FND_API.G_MISS_NUM
1037: OR g_Lot_Serial_rec.line_id = FND_API.G_MISS_NUM
1038: OR g_Lot_Serial_rec.lot_number = FND_API.G_MISS_CHAR
1039: --OR ( g_Lot_Serial_rec.sublot_number = FND_API.G_MISS_CHAR and OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510') --OPM 2380194 INVCONV
1040: OR g_Lot_Serial_rec.lot_serial_id = FND_API.G_MISS_NUM
1041: OR g_Lot_Serial_rec.quantity = FND_API.G_MISS_NUM
1042: OR ( g_Lot_Serial_rec.quantity2 = FND_API.G_MISS_NUM and OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510') --OPM 2380194
1043: OR g_Lot_Serial_rec.to_serial_number = FND_API.G_MISS_CHAR

Line 1040: OR g_Lot_Serial_rec.lot_serial_id = FND_API.G_MISS_NUM

1036: OR g_Lot_Serial_rec.last_update_login = FND_API.G_MISS_NUM
1037: OR g_Lot_Serial_rec.line_id = FND_API.G_MISS_NUM
1038: OR g_Lot_Serial_rec.lot_number = FND_API.G_MISS_CHAR
1039: --OR ( g_Lot_Serial_rec.sublot_number = FND_API.G_MISS_CHAR and OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510') --OPM 2380194 INVCONV
1040: OR g_Lot_Serial_rec.lot_serial_id = FND_API.G_MISS_NUM
1041: OR g_Lot_Serial_rec.quantity = FND_API.G_MISS_NUM
1042: OR ( g_Lot_Serial_rec.quantity2 = FND_API.G_MISS_NUM and OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510') --OPM 2380194
1043: OR g_Lot_Serial_rec.to_serial_number = FND_API.G_MISS_CHAR
1044: OR g_Lot_Serial_rec.line_set_id = FND_API.G_MISS_NUM

Line 1041: OR g_Lot_Serial_rec.quantity = FND_API.G_MISS_NUM

1037: OR g_Lot_Serial_rec.line_id = FND_API.G_MISS_NUM
1038: OR g_Lot_Serial_rec.lot_number = FND_API.G_MISS_CHAR
1039: --OR ( g_Lot_Serial_rec.sublot_number = FND_API.G_MISS_CHAR and OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510') --OPM 2380194 INVCONV
1040: OR g_Lot_Serial_rec.lot_serial_id = FND_API.G_MISS_NUM
1041: OR g_Lot_Serial_rec.quantity = FND_API.G_MISS_NUM
1042: OR ( g_Lot_Serial_rec.quantity2 = FND_API.G_MISS_NUM and OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510') --OPM 2380194
1043: OR g_Lot_Serial_rec.to_serial_number = FND_API.G_MISS_CHAR
1044: OR g_Lot_Serial_rec.line_set_id = FND_API.G_MISS_NUM
1045: THEN

Line 1042: OR ( g_Lot_Serial_rec.quantity2 = FND_API.G_MISS_NUM and OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510') --OPM 2380194

1038: OR g_Lot_Serial_rec.lot_number = FND_API.G_MISS_CHAR
1039: --OR ( g_Lot_Serial_rec.sublot_number = FND_API.G_MISS_CHAR and OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510') --OPM 2380194 INVCONV
1040: OR g_Lot_Serial_rec.lot_serial_id = FND_API.G_MISS_NUM
1041: OR g_Lot_Serial_rec.quantity = FND_API.G_MISS_NUM
1042: OR ( g_Lot_Serial_rec.quantity2 = FND_API.G_MISS_NUM and OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510') --OPM 2380194
1043: OR g_Lot_Serial_rec.to_serial_number = FND_API.G_MISS_CHAR
1044: OR g_Lot_Serial_rec.line_set_id = FND_API.G_MISS_NUM
1045: THEN
1046:

Line 1043: OR g_Lot_Serial_rec.to_serial_number = FND_API.G_MISS_CHAR

1039: --OR ( g_Lot_Serial_rec.sublot_number = FND_API.G_MISS_CHAR and OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510') --OPM 2380194 INVCONV
1040: OR g_Lot_Serial_rec.lot_serial_id = FND_API.G_MISS_NUM
1041: OR g_Lot_Serial_rec.quantity = FND_API.G_MISS_NUM
1042: OR ( g_Lot_Serial_rec.quantity2 = FND_API.G_MISS_NUM and OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510') --OPM 2380194
1043: OR g_Lot_Serial_rec.to_serial_number = FND_API.G_MISS_CHAR
1044: OR g_Lot_Serial_rec.line_set_id = FND_API.G_MISS_NUM
1045: THEN
1046:
1047: OE_Default_Lot_Serial.Attributes

Line 1044: OR g_Lot_Serial_rec.line_set_id = FND_API.G_MISS_NUM

1040: OR g_Lot_Serial_rec.lot_serial_id = FND_API.G_MISS_NUM
1041: OR g_Lot_Serial_rec.quantity = FND_API.G_MISS_NUM
1042: OR ( g_Lot_Serial_rec.quantity2 = FND_API.G_MISS_NUM and OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510') --OPM 2380194
1043: OR g_Lot_Serial_rec.to_serial_number = FND_API.G_MISS_CHAR
1044: OR g_Lot_Serial_rec.line_set_id = FND_API.G_MISS_NUM
1045: THEN
1046:
1047: OE_Default_Lot_Serial.Attributes
1048: ( p_x_Lot_Serial_rec => g_Lot_Serial_rec

Line 1062: IF p_x_Lot_Serial_rec.orig_sys_lotserial_ref = FND_API.G_MISS_CHAR THEN

1058: END IF;
1059:
1060: /* 1581620 start */
1061:
1062: IF p_x_Lot_Serial_rec.orig_sys_lotserial_ref = FND_API.G_MISS_CHAR THEN
1063: p_x_Lot_Serial_rec.orig_sys_lotserial_ref := NULL;
1064: END IF;
1065:
1066: IF p_x_Lot_Serial_rec.lock_control = FND_API.G_MISS_NUM THEN

Line 1066: IF p_x_Lot_Serial_rec.lock_control = FND_API.G_MISS_NUM THEN

1062: IF p_x_Lot_Serial_rec.orig_sys_lotserial_ref = FND_API.G_MISS_CHAR THEN
1063: p_x_Lot_Serial_rec.orig_sys_lotserial_ref := NULL;
1064: END IF;
1065:
1066: IF p_x_Lot_Serial_rec.lock_control = FND_API.G_MISS_NUM THEN
1067: p_x_Lot_Serial_rec.lock_control := NULL;
1068: END IF;
1069:
1070: /* 1581620 end */