eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_LOT_SERIAL_UTIL dependencies on FND_API

Line 11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM

7:
8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_x_Lot_Serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type
13: , p_old_Lot_Serial_rec IN OE_Order_PUB.Lot_Serial_Rec_Type :=
14: OE_Order_PUB.G_MISS_LOT_SERIAL_REC
15: )

Line 31: IF p_attr_id = FND_API.G_MISS_NUM THEN

27:
28: -- If attr_id is missing compare old and new records and for
29: -- every changed attribute clear its dependent fields.
30:
31: IF p_attr_id = FND_API.G_MISS_NUM THEN
32:
33: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute1,p_old_Lot_Serial_rec.attribute1)
34: THEN
35: l_index := l_index + 1;

Line 482: p_x_Lot_Serial_rec.from_serial_number <> FND_API.G_MISS_CHAR AND

478:
479: IF l_serial_validation_flag = 'Y' THEN
480:
481: IF p_x_Lot_Serial_rec.from_serial_number IS NOT NULL AND
482: p_x_Lot_Serial_rec.from_serial_number <> FND_API.G_MISS_CHAR AND
483: p_x_Lot_Serial_rec.to_serial_number <> FND_API.G_MISS_CHAR
484: THEN
485: IF NOT MTL_SERIAL_CHECK.INV_SERIAL_INFO(
486: p_x_Lot_Serial_rec.from_serial_number,

Line 483: p_x_Lot_Serial_rec.to_serial_number <> FND_API.G_MISS_CHAR

479: IF l_serial_validation_flag = 'Y' THEN
480:
481: IF p_x_Lot_Serial_rec.from_serial_number IS NOT NULL AND
482: p_x_Lot_Serial_rec.from_serial_number <> FND_API.G_MISS_CHAR AND
483: p_x_Lot_Serial_rec.to_serial_number <> FND_API.G_MISS_CHAR
484: THEN
485: IF NOT MTL_SERIAL_CHECK.INV_SERIAL_INFO(
486: p_x_Lot_Serial_rec.from_serial_number,
487: p_x_Lot_Serial_rec.to_serial_number,

Line 496: raise FND_API.G_EXC_ERROR;

492: x_error_code)
493: THEN
494: fnd_message.set_name('ONT','OE_QUANTITY_MISMATCH');
495: oe_msg_pub.ADD;
496: raise FND_API.G_EXC_ERROR;
497: ELSE
498: IF p_x_Lot_Serial_rec.quantity <> x_quantity THEN
499: fnd_message.set_name('ONT','OE_QUANTITY_MISMATCH');
500: oe_msg_pub.ADD;

Line 501: raise FND_API.G_EXC_ERROR;

497: ELSE
498: IF p_x_Lot_Serial_rec.quantity <> x_quantity THEN
499: fnd_message.set_name('ONT','OE_QUANTITY_MISMATCH');
500: oe_msg_pub.ADD;
501: raise FND_API.G_EXC_ERROR;
502: END IF;
503: END IF;
504:
505: END IF;

Line 525: IF p_x_Lot_Serial_rec.attribute1 = FND_API.G_MISS_CHAR THEN

521: BEGIN
522:
523: OE_DEBUG_PUB.ADD('Inside complete record',1);
524: OE_DEBUG_PUB.ADD('The quantity is '||to_char(p_x_Lot_Serial_rec.quantity),1);
525: IF p_x_Lot_Serial_rec.attribute1 = FND_API.G_MISS_CHAR THEN
526: p_x_Lot_Serial_rec.attribute1 := p_old_Lot_Serial_rec.attribute1;
527: END IF;
528:
529: IF p_x_Lot_Serial_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 529: IF p_x_Lot_Serial_rec.attribute10 = FND_API.G_MISS_CHAR THEN

525: IF p_x_Lot_Serial_rec.attribute1 = FND_API.G_MISS_CHAR THEN
526: p_x_Lot_Serial_rec.attribute1 := p_old_Lot_Serial_rec.attribute1;
527: END IF;
528:
529: IF p_x_Lot_Serial_rec.attribute10 = FND_API.G_MISS_CHAR THEN
530: p_x_Lot_Serial_rec.attribute10 := p_old_Lot_Serial_rec.attribute10;
531: END IF;
532:
533: IF p_x_Lot_Serial_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 533: IF p_x_Lot_Serial_rec.attribute11 = FND_API.G_MISS_CHAR THEN

529: IF p_x_Lot_Serial_rec.attribute10 = FND_API.G_MISS_CHAR THEN
530: p_x_Lot_Serial_rec.attribute10 := p_old_Lot_Serial_rec.attribute10;
531: END IF;
532:
533: IF p_x_Lot_Serial_rec.attribute11 = FND_API.G_MISS_CHAR THEN
534: p_x_Lot_Serial_rec.attribute11 := p_old_Lot_Serial_rec.attribute11;
535: END IF;
536:
537: IF p_x_Lot_Serial_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 537: IF p_x_Lot_Serial_rec.attribute12 = FND_API.G_MISS_CHAR THEN

533: IF p_x_Lot_Serial_rec.attribute11 = FND_API.G_MISS_CHAR THEN
534: p_x_Lot_Serial_rec.attribute11 := p_old_Lot_Serial_rec.attribute11;
535: END IF;
536:
537: IF p_x_Lot_Serial_rec.attribute12 = FND_API.G_MISS_CHAR THEN
538: p_x_Lot_Serial_rec.attribute12 := p_old_Lot_Serial_rec.attribute12;
539: END IF;
540:
541: IF p_x_Lot_Serial_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 541: IF p_x_Lot_Serial_rec.attribute13 = FND_API.G_MISS_CHAR THEN

537: IF p_x_Lot_Serial_rec.attribute12 = FND_API.G_MISS_CHAR THEN
538: p_x_Lot_Serial_rec.attribute12 := p_old_Lot_Serial_rec.attribute12;
539: END IF;
540:
541: IF p_x_Lot_Serial_rec.attribute13 = FND_API.G_MISS_CHAR THEN
542: p_x_Lot_Serial_rec.attribute13 := p_old_Lot_Serial_rec.attribute13;
543: END IF;
544:
545: IF p_x_Lot_Serial_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 545: IF p_x_Lot_Serial_rec.attribute14 = FND_API.G_MISS_CHAR THEN

541: IF p_x_Lot_Serial_rec.attribute13 = FND_API.G_MISS_CHAR THEN
542: p_x_Lot_Serial_rec.attribute13 := p_old_Lot_Serial_rec.attribute13;
543: END IF;
544:
545: IF p_x_Lot_Serial_rec.attribute14 = FND_API.G_MISS_CHAR THEN
546: p_x_Lot_Serial_rec.attribute14 := p_old_Lot_Serial_rec.attribute14;
547: END IF;
548:
549: IF p_x_Lot_Serial_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 549: IF p_x_Lot_Serial_rec.attribute15 = FND_API.G_MISS_CHAR THEN

545: IF p_x_Lot_Serial_rec.attribute14 = FND_API.G_MISS_CHAR THEN
546: p_x_Lot_Serial_rec.attribute14 := p_old_Lot_Serial_rec.attribute14;
547: END IF;
548:
549: IF p_x_Lot_Serial_rec.attribute15 = FND_API.G_MISS_CHAR THEN
550: p_x_Lot_Serial_rec.attribute15 := p_old_Lot_Serial_rec.attribute15;
551: END IF;
552:
553: IF p_x_Lot_Serial_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 553: IF p_x_Lot_Serial_rec.attribute2 = FND_API.G_MISS_CHAR THEN

549: IF p_x_Lot_Serial_rec.attribute15 = FND_API.G_MISS_CHAR THEN
550: p_x_Lot_Serial_rec.attribute15 := p_old_Lot_Serial_rec.attribute15;
551: END IF;
552:
553: IF p_x_Lot_Serial_rec.attribute2 = FND_API.G_MISS_CHAR THEN
554: p_x_Lot_Serial_rec.attribute2 := p_old_Lot_Serial_rec.attribute2;
555: END IF;
556:
557: IF p_x_Lot_Serial_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 557: IF p_x_Lot_Serial_rec.attribute3 = FND_API.G_MISS_CHAR THEN

553: IF p_x_Lot_Serial_rec.attribute2 = FND_API.G_MISS_CHAR THEN
554: p_x_Lot_Serial_rec.attribute2 := p_old_Lot_Serial_rec.attribute2;
555: END IF;
556:
557: IF p_x_Lot_Serial_rec.attribute3 = FND_API.G_MISS_CHAR THEN
558: p_x_Lot_Serial_rec.attribute3 := p_old_Lot_Serial_rec.attribute3;
559: END IF;
560:
561: IF p_x_Lot_Serial_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 561: IF p_x_Lot_Serial_rec.attribute4 = FND_API.G_MISS_CHAR THEN

557: IF p_x_Lot_Serial_rec.attribute3 = FND_API.G_MISS_CHAR THEN
558: p_x_Lot_Serial_rec.attribute3 := p_old_Lot_Serial_rec.attribute3;
559: END IF;
560:
561: IF p_x_Lot_Serial_rec.attribute4 = FND_API.G_MISS_CHAR THEN
562: p_x_Lot_Serial_rec.attribute4 := p_old_Lot_Serial_rec.attribute4;
563: END IF;
564:
565: IF p_x_Lot_Serial_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 565: IF p_x_Lot_Serial_rec.attribute5 = FND_API.G_MISS_CHAR THEN

561: IF p_x_Lot_Serial_rec.attribute4 = FND_API.G_MISS_CHAR THEN
562: p_x_Lot_Serial_rec.attribute4 := p_old_Lot_Serial_rec.attribute4;
563: END IF;
564:
565: IF p_x_Lot_Serial_rec.attribute5 = FND_API.G_MISS_CHAR THEN
566: p_x_Lot_Serial_rec.attribute5 := p_old_Lot_Serial_rec.attribute5;
567: END IF;
568:
569: IF p_x_Lot_Serial_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 569: IF p_x_Lot_Serial_rec.attribute6 = FND_API.G_MISS_CHAR THEN

565: IF p_x_Lot_Serial_rec.attribute5 = FND_API.G_MISS_CHAR THEN
566: p_x_Lot_Serial_rec.attribute5 := p_old_Lot_Serial_rec.attribute5;
567: END IF;
568:
569: IF p_x_Lot_Serial_rec.attribute6 = FND_API.G_MISS_CHAR THEN
570: p_x_Lot_Serial_rec.attribute6 := p_old_Lot_Serial_rec.attribute6;
571: END IF;
572:
573: IF p_x_Lot_Serial_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 573: IF p_x_Lot_Serial_rec.attribute7 = FND_API.G_MISS_CHAR THEN

569: IF p_x_Lot_Serial_rec.attribute6 = FND_API.G_MISS_CHAR THEN
570: p_x_Lot_Serial_rec.attribute6 := p_old_Lot_Serial_rec.attribute6;
571: END IF;
572:
573: IF p_x_Lot_Serial_rec.attribute7 = FND_API.G_MISS_CHAR THEN
574: p_x_Lot_Serial_rec.attribute7 := p_old_Lot_Serial_rec.attribute7;
575: END IF;
576:
577: IF p_x_Lot_Serial_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 577: IF p_x_Lot_Serial_rec.attribute8 = FND_API.G_MISS_CHAR THEN

573: IF p_x_Lot_Serial_rec.attribute7 = FND_API.G_MISS_CHAR THEN
574: p_x_Lot_Serial_rec.attribute7 := p_old_Lot_Serial_rec.attribute7;
575: END IF;
576:
577: IF p_x_Lot_Serial_rec.attribute8 = FND_API.G_MISS_CHAR THEN
578: p_x_Lot_Serial_rec.attribute8 := p_old_Lot_Serial_rec.attribute8;
579: END IF;
580:
581: IF p_x_Lot_Serial_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 581: IF p_x_Lot_Serial_rec.attribute9 = FND_API.G_MISS_CHAR THEN

577: IF p_x_Lot_Serial_rec.attribute8 = FND_API.G_MISS_CHAR THEN
578: p_x_Lot_Serial_rec.attribute8 := p_old_Lot_Serial_rec.attribute8;
579: END IF;
580:
581: IF p_x_Lot_Serial_rec.attribute9 = FND_API.G_MISS_CHAR THEN
582: p_x_Lot_Serial_rec.attribute9 := p_old_Lot_Serial_rec.attribute9;
583: END IF;
584:
585: IF p_x_Lot_Serial_rec.context = FND_API.G_MISS_CHAR THEN

Line 585: IF p_x_Lot_Serial_rec.context = FND_API.G_MISS_CHAR THEN

581: IF p_x_Lot_Serial_rec.attribute9 = FND_API.G_MISS_CHAR THEN
582: p_x_Lot_Serial_rec.attribute9 := p_old_Lot_Serial_rec.attribute9;
583: END IF;
584:
585: IF p_x_Lot_Serial_rec.context = FND_API.G_MISS_CHAR THEN
586: p_x_Lot_Serial_rec.context := p_old_Lot_Serial_rec.context;
587: END IF;
588:
589: IF p_x_Lot_Serial_rec.created_by = FND_API.G_MISS_NUM THEN

Line 589: IF p_x_Lot_Serial_rec.created_by = FND_API.G_MISS_NUM THEN

585: IF p_x_Lot_Serial_rec.context = FND_API.G_MISS_CHAR THEN
586: p_x_Lot_Serial_rec.context := p_old_Lot_Serial_rec.context;
587: END IF;
588:
589: IF p_x_Lot_Serial_rec.created_by = FND_API.G_MISS_NUM THEN
590: p_x_Lot_Serial_rec.created_by := p_old_Lot_Serial_rec.created_by;
591: END IF;
592:
593: IF p_x_Lot_Serial_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 593: IF p_x_Lot_Serial_rec.creation_date = FND_API.G_MISS_DATE THEN

589: IF p_x_Lot_Serial_rec.created_by = FND_API.G_MISS_NUM THEN
590: p_x_Lot_Serial_rec.created_by := p_old_Lot_Serial_rec.created_by;
591: END IF;
592:
593: IF p_x_Lot_Serial_rec.creation_date = FND_API.G_MISS_DATE THEN
594: p_x_Lot_Serial_rec.creation_date := p_old_Lot_Serial_rec.creation_date;
595: END IF;
596:
597: IF p_x_Lot_Serial_rec.from_serial_number = FND_API.G_MISS_CHAR THEN

Line 597: IF p_x_Lot_Serial_rec.from_serial_number = FND_API.G_MISS_CHAR THEN

593: IF p_x_Lot_Serial_rec.creation_date = FND_API.G_MISS_DATE THEN
594: p_x_Lot_Serial_rec.creation_date := p_old_Lot_Serial_rec.creation_date;
595: END IF;
596:
597: IF p_x_Lot_Serial_rec.from_serial_number = FND_API.G_MISS_CHAR THEN
598: p_x_Lot_Serial_rec.from_serial_number := p_old_Lot_Serial_rec.from_serial_number;
599: END IF;
600:
601: IF p_x_Lot_Serial_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 601: IF p_x_Lot_Serial_rec.last_updated_by = FND_API.G_MISS_NUM THEN

597: IF p_x_Lot_Serial_rec.from_serial_number = FND_API.G_MISS_CHAR THEN
598: p_x_Lot_Serial_rec.from_serial_number := p_old_Lot_Serial_rec.from_serial_number;
599: END IF;
600:
601: IF p_x_Lot_Serial_rec.last_updated_by = FND_API.G_MISS_NUM THEN
602: p_x_Lot_Serial_rec.last_updated_by := p_old_Lot_Serial_rec.last_updated_by;
603: END IF;
604:
605: IF p_x_Lot_Serial_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 605: IF p_x_Lot_Serial_rec.last_update_date = FND_API.G_MISS_DATE THEN

601: IF p_x_Lot_Serial_rec.last_updated_by = FND_API.G_MISS_NUM THEN
602: p_x_Lot_Serial_rec.last_updated_by := p_old_Lot_Serial_rec.last_updated_by;
603: END IF;
604:
605: IF p_x_Lot_Serial_rec.last_update_date = FND_API.G_MISS_DATE THEN
606: p_x_Lot_Serial_rec.last_update_date := p_old_Lot_Serial_rec.last_update_date;
607: END IF;
608:
609: IF p_x_Lot_Serial_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 609: IF p_x_Lot_Serial_rec.last_update_login = FND_API.G_MISS_NUM THEN

605: IF p_x_Lot_Serial_rec.last_update_date = FND_API.G_MISS_DATE THEN
606: p_x_Lot_Serial_rec.last_update_date := p_old_Lot_Serial_rec.last_update_date;
607: END IF;
608:
609: IF p_x_Lot_Serial_rec.last_update_login = FND_API.G_MISS_NUM THEN
610: p_x_Lot_Serial_rec.last_update_login := p_old_Lot_Serial_rec.last_update_login;
611: END IF;
612:
613: IF p_x_Lot_Serial_rec.line_id = FND_API.G_MISS_NUM THEN

Line 613: IF p_x_Lot_Serial_rec.line_id = FND_API.G_MISS_NUM THEN

609: IF p_x_Lot_Serial_rec.last_update_login = FND_API.G_MISS_NUM THEN
610: p_x_Lot_Serial_rec.last_update_login := p_old_Lot_Serial_rec.last_update_login;
611: END IF;
612:
613: IF p_x_Lot_Serial_rec.line_id = FND_API.G_MISS_NUM THEN
614: p_x_Lot_Serial_rec.line_id := p_old_Lot_Serial_rec.line_id;
615: END IF;
616:
617: IF p_x_Lot_Serial_rec.line_set_id = FND_API.G_MISS_NUM THEN

Line 617: IF p_x_Lot_Serial_rec.line_set_id = FND_API.G_MISS_NUM THEN

613: IF p_x_Lot_Serial_rec.line_id = FND_API.G_MISS_NUM THEN
614: p_x_Lot_Serial_rec.line_id := p_old_Lot_Serial_rec.line_id;
615: END IF;
616:
617: IF p_x_Lot_Serial_rec.line_set_id = FND_API.G_MISS_NUM THEN
618: p_x_Lot_Serial_rec.line_set_id := p_old_Lot_Serial_rec.line_set_id;
619: END IF;
620:
621: IF p_x_Lot_Serial_rec.lot_number = FND_API.G_MISS_CHAR THEN

Line 621: IF p_x_Lot_Serial_rec.lot_number = FND_API.G_MISS_CHAR THEN

617: IF p_x_Lot_Serial_rec.line_set_id = FND_API.G_MISS_NUM THEN
618: p_x_Lot_Serial_rec.line_set_id := p_old_Lot_Serial_rec.line_set_id;
619: END IF;
620:
621: IF p_x_Lot_Serial_rec.lot_number = FND_API.G_MISS_CHAR THEN
622: p_x_Lot_Serial_rec.lot_number := p_old_Lot_Serial_rec.lot_number;
623: END IF;
624:
625: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510'

Line 627: /*IF p_x_Lot_Serial_rec.sublot_number = FND_API.G_MISS_CHAR THEN

623: END IF;
624:
625: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510'
626: THEN
627: /*IF p_x_Lot_Serial_rec.sublot_number = FND_API.G_MISS_CHAR THEN
628: p_x_Lot_Serial_rec.sublot_number := p_old_Lot_Serial_rec.sublot_number;
629: END IF; --OPM 2380194 */ -- INVCONV
630:
631: IF p_x_Lot_Serial_rec.quantity2 = FND_API.G_MISS_NUM THEN --OPM 2380194

Line 631: IF p_x_Lot_Serial_rec.quantity2 = FND_API.G_MISS_NUM THEN --OPM 2380194

627: /*IF p_x_Lot_Serial_rec.sublot_number = FND_API.G_MISS_CHAR THEN
628: p_x_Lot_Serial_rec.sublot_number := p_old_Lot_Serial_rec.sublot_number;
629: END IF; --OPM 2380194 */ -- INVCONV
630:
631: IF p_x_Lot_Serial_rec.quantity2 = FND_API.G_MISS_NUM THEN --OPM 2380194
632: p_x_Lot_Serial_rec.quantity2 := p_old_Lot_Serial_rec.quantity2;
633: END IF;
634: END IF;
635:

Line 636: IF p_x_Lot_Serial_rec.lot_serial_id = FND_API.G_MISS_NUM THEN

632: p_x_Lot_Serial_rec.quantity2 := p_old_Lot_Serial_rec.quantity2;
633: END IF;
634: END IF;
635:
636: IF p_x_Lot_Serial_rec.lot_serial_id = FND_API.G_MISS_NUM THEN
637: p_x_Lot_Serial_rec.lot_serial_id := p_old_Lot_Serial_rec.lot_serial_id;
638: END IF;
639:
640: IF p_x_Lot_Serial_rec.quantity = FND_API.G_MISS_NUM THEN

Line 640: IF p_x_Lot_Serial_rec.quantity = FND_API.G_MISS_NUM THEN

636: IF p_x_Lot_Serial_rec.lot_serial_id = FND_API.G_MISS_NUM THEN
637: p_x_Lot_Serial_rec.lot_serial_id := p_old_Lot_Serial_rec.lot_serial_id;
638: END IF;
639:
640: IF p_x_Lot_Serial_rec.quantity = FND_API.G_MISS_NUM THEN
641: p_x_Lot_Serial_rec.quantity := p_old_Lot_Serial_rec.quantity;
642: END IF;
643:
644: IF p_x_Lot_Serial_rec.to_serial_number = FND_API.G_MISS_CHAR THEN

Line 644: IF p_x_Lot_Serial_rec.to_serial_number = FND_API.G_MISS_CHAR THEN

640: IF p_x_Lot_Serial_rec.quantity = FND_API.G_MISS_NUM THEN
641: p_x_Lot_Serial_rec.quantity := p_old_Lot_Serial_rec.quantity;
642: END IF;
643:
644: IF p_x_Lot_Serial_rec.to_serial_number = FND_API.G_MISS_CHAR THEN
645: p_x_Lot_Serial_rec.to_serial_number := p_old_Lot_Serial_rec.to_serial_number;
646: END IF;
647:
648: OE_DEBUG_PUB.ADD('The quantity is '||to_char(p_x_Lot_Serial_rec.quantity),1);

Line 659: IF p_x_Lot_Serial_rec.attribute1 = FND_API.G_MISS_CHAR THEN

655: )
656: IS
657: BEGIN
658:
659: IF p_x_Lot_Serial_rec.attribute1 = FND_API.G_MISS_CHAR THEN
660: p_x_Lot_Serial_rec.attribute1 := NULL;
661: END IF;
662:
663: IF p_x_Lot_Serial_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 663: IF p_x_Lot_Serial_rec.attribute10 = FND_API.G_MISS_CHAR THEN

659: IF p_x_Lot_Serial_rec.attribute1 = FND_API.G_MISS_CHAR THEN
660: p_x_Lot_Serial_rec.attribute1 := NULL;
661: END IF;
662:
663: IF p_x_Lot_Serial_rec.attribute10 = FND_API.G_MISS_CHAR THEN
664: p_x_Lot_Serial_rec.attribute10 := NULL;
665: END IF;
666:
667: IF p_x_Lot_Serial_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 667: IF p_x_Lot_Serial_rec.attribute11 = FND_API.G_MISS_CHAR THEN

663: IF p_x_Lot_Serial_rec.attribute10 = FND_API.G_MISS_CHAR THEN
664: p_x_Lot_Serial_rec.attribute10 := NULL;
665: END IF;
666:
667: IF p_x_Lot_Serial_rec.attribute11 = FND_API.G_MISS_CHAR THEN
668: p_x_Lot_Serial_rec.attribute11 := NULL;
669: END IF;
670:
671: IF p_x_Lot_Serial_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 671: IF p_x_Lot_Serial_rec.attribute12 = FND_API.G_MISS_CHAR THEN

667: IF p_x_Lot_Serial_rec.attribute11 = FND_API.G_MISS_CHAR THEN
668: p_x_Lot_Serial_rec.attribute11 := NULL;
669: END IF;
670:
671: IF p_x_Lot_Serial_rec.attribute12 = FND_API.G_MISS_CHAR THEN
672: p_x_Lot_Serial_rec.attribute12 := NULL;
673: END IF;
674:
675: IF p_x_Lot_Serial_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 675: IF p_x_Lot_Serial_rec.attribute13 = FND_API.G_MISS_CHAR THEN

671: IF p_x_Lot_Serial_rec.attribute12 = FND_API.G_MISS_CHAR THEN
672: p_x_Lot_Serial_rec.attribute12 := NULL;
673: END IF;
674:
675: IF p_x_Lot_Serial_rec.attribute13 = FND_API.G_MISS_CHAR THEN
676: p_x_Lot_Serial_rec.attribute13 := NULL;
677: END IF;
678:
679: IF p_x_Lot_Serial_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 679: IF p_x_Lot_Serial_rec.attribute14 = FND_API.G_MISS_CHAR THEN

675: IF p_x_Lot_Serial_rec.attribute13 = FND_API.G_MISS_CHAR THEN
676: p_x_Lot_Serial_rec.attribute13 := NULL;
677: END IF;
678:
679: IF p_x_Lot_Serial_rec.attribute14 = FND_API.G_MISS_CHAR THEN
680: p_x_Lot_Serial_rec.attribute14 := NULL;
681: END IF;
682:
683: IF p_x_Lot_Serial_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 683: IF p_x_Lot_Serial_rec.attribute15 = FND_API.G_MISS_CHAR THEN

679: IF p_x_Lot_Serial_rec.attribute14 = FND_API.G_MISS_CHAR THEN
680: p_x_Lot_Serial_rec.attribute14 := NULL;
681: END IF;
682:
683: IF p_x_Lot_Serial_rec.attribute15 = FND_API.G_MISS_CHAR THEN
684: p_x_Lot_Serial_rec.attribute15 := NULL;
685: END IF;
686:
687: IF p_x_Lot_Serial_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 687: IF p_x_Lot_Serial_rec.attribute2 = FND_API.G_MISS_CHAR THEN

683: IF p_x_Lot_Serial_rec.attribute15 = FND_API.G_MISS_CHAR THEN
684: p_x_Lot_Serial_rec.attribute15 := NULL;
685: END IF;
686:
687: IF p_x_Lot_Serial_rec.attribute2 = FND_API.G_MISS_CHAR THEN
688: p_x_Lot_Serial_rec.attribute2 := NULL;
689: END IF;
690:
691: IF p_x_Lot_Serial_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 691: IF p_x_Lot_Serial_rec.attribute3 = FND_API.G_MISS_CHAR THEN

687: IF p_x_Lot_Serial_rec.attribute2 = FND_API.G_MISS_CHAR THEN
688: p_x_Lot_Serial_rec.attribute2 := NULL;
689: END IF;
690:
691: IF p_x_Lot_Serial_rec.attribute3 = FND_API.G_MISS_CHAR THEN
692: p_x_Lot_Serial_rec.attribute3 := NULL;
693: END IF;
694:
695: IF p_x_Lot_Serial_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 695: IF p_x_Lot_Serial_rec.attribute4 = FND_API.G_MISS_CHAR THEN

691: IF p_x_Lot_Serial_rec.attribute3 = FND_API.G_MISS_CHAR THEN
692: p_x_Lot_Serial_rec.attribute3 := NULL;
693: END IF;
694:
695: IF p_x_Lot_Serial_rec.attribute4 = FND_API.G_MISS_CHAR THEN
696: p_x_Lot_Serial_rec.attribute4 := NULL;
697: END IF;
698:
699: IF p_x_Lot_Serial_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 699: IF p_x_Lot_Serial_rec.attribute5 = FND_API.G_MISS_CHAR THEN

695: IF p_x_Lot_Serial_rec.attribute4 = FND_API.G_MISS_CHAR THEN
696: p_x_Lot_Serial_rec.attribute4 := NULL;
697: END IF;
698:
699: IF p_x_Lot_Serial_rec.attribute5 = FND_API.G_MISS_CHAR THEN
700: p_x_Lot_Serial_rec.attribute5 := NULL;
701: END IF;
702:
703: IF p_x_Lot_Serial_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 703: IF p_x_Lot_Serial_rec.attribute6 = FND_API.G_MISS_CHAR THEN

699: IF p_x_Lot_Serial_rec.attribute5 = FND_API.G_MISS_CHAR THEN
700: p_x_Lot_Serial_rec.attribute5 := NULL;
701: END IF;
702:
703: IF p_x_Lot_Serial_rec.attribute6 = FND_API.G_MISS_CHAR THEN
704: p_x_Lot_Serial_rec.attribute6 := NULL;
705: END IF;
706:
707: IF p_x_Lot_Serial_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 707: IF p_x_Lot_Serial_rec.attribute7 = FND_API.G_MISS_CHAR THEN

703: IF p_x_Lot_Serial_rec.attribute6 = FND_API.G_MISS_CHAR THEN
704: p_x_Lot_Serial_rec.attribute6 := NULL;
705: END IF;
706:
707: IF p_x_Lot_Serial_rec.attribute7 = FND_API.G_MISS_CHAR THEN
708: p_x_Lot_Serial_rec.attribute7 := NULL;
709: END IF;
710:
711: IF p_x_Lot_Serial_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 711: IF p_x_Lot_Serial_rec.attribute8 = FND_API.G_MISS_CHAR THEN

707: IF p_x_Lot_Serial_rec.attribute7 = FND_API.G_MISS_CHAR THEN
708: p_x_Lot_Serial_rec.attribute7 := NULL;
709: END IF;
710:
711: IF p_x_Lot_Serial_rec.attribute8 = FND_API.G_MISS_CHAR THEN
712: p_x_Lot_Serial_rec.attribute8 := NULL;
713: END IF;
714:
715: IF p_x_Lot_Serial_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 715: IF p_x_Lot_Serial_rec.attribute9 = FND_API.G_MISS_CHAR THEN

711: IF p_x_Lot_Serial_rec.attribute8 = FND_API.G_MISS_CHAR THEN
712: p_x_Lot_Serial_rec.attribute8 := NULL;
713: END IF;
714:
715: IF p_x_Lot_Serial_rec.attribute9 = FND_API.G_MISS_CHAR THEN
716: p_x_Lot_Serial_rec.attribute9 := NULL;
717: END IF;
718:
719: IF p_x_Lot_Serial_rec.context = FND_API.G_MISS_CHAR THEN

Line 719: IF p_x_Lot_Serial_rec.context = FND_API.G_MISS_CHAR THEN

715: IF p_x_Lot_Serial_rec.attribute9 = FND_API.G_MISS_CHAR THEN
716: p_x_Lot_Serial_rec.attribute9 := NULL;
717: END IF;
718:
719: IF p_x_Lot_Serial_rec.context = FND_API.G_MISS_CHAR THEN
720: p_x_Lot_Serial_rec.context := NULL;
721: END IF;
722:
723: IF p_x_Lot_Serial_rec.created_by = FND_API.G_MISS_NUM THEN

Line 723: IF p_x_Lot_Serial_rec.created_by = FND_API.G_MISS_NUM THEN

719: IF p_x_Lot_Serial_rec.context = FND_API.G_MISS_CHAR THEN
720: p_x_Lot_Serial_rec.context := NULL;
721: END IF;
722:
723: IF p_x_Lot_Serial_rec.created_by = FND_API.G_MISS_NUM THEN
724: p_x_Lot_Serial_rec.created_by := NULL;
725: END IF;
726:
727: IF p_x_Lot_Serial_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 727: IF p_x_Lot_Serial_rec.creation_date = FND_API.G_MISS_DATE THEN

723: IF p_x_Lot_Serial_rec.created_by = FND_API.G_MISS_NUM THEN
724: p_x_Lot_Serial_rec.created_by := NULL;
725: END IF;
726:
727: IF p_x_Lot_Serial_rec.creation_date = FND_API.G_MISS_DATE THEN
728: p_x_Lot_Serial_rec.creation_date := NULL;
729: END IF;
730:
731: IF p_x_Lot_Serial_rec.from_serial_number = FND_API.G_MISS_CHAR THEN

Line 731: IF p_x_Lot_Serial_rec.from_serial_number = FND_API.G_MISS_CHAR THEN

727: IF p_x_Lot_Serial_rec.creation_date = FND_API.G_MISS_DATE THEN
728: p_x_Lot_Serial_rec.creation_date := NULL;
729: END IF;
730:
731: IF p_x_Lot_Serial_rec.from_serial_number = FND_API.G_MISS_CHAR THEN
732: p_x_Lot_Serial_rec.from_serial_number := NULL;
733: END IF;
734:
735: IF p_x_Lot_Serial_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 735: IF p_x_Lot_Serial_rec.last_updated_by = FND_API.G_MISS_NUM THEN

731: IF p_x_Lot_Serial_rec.from_serial_number = FND_API.G_MISS_CHAR THEN
732: p_x_Lot_Serial_rec.from_serial_number := NULL;
733: END IF;
734:
735: IF p_x_Lot_Serial_rec.last_updated_by = FND_API.G_MISS_NUM THEN
736: p_x_Lot_Serial_rec.last_updated_by := NULL;
737: END IF;
738:
739: IF p_x_Lot_Serial_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 739: IF p_x_Lot_Serial_rec.last_update_date = FND_API.G_MISS_DATE THEN

735: IF p_x_Lot_Serial_rec.last_updated_by = FND_API.G_MISS_NUM THEN
736: p_x_Lot_Serial_rec.last_updated_by := NULL;
737: END IF;
738:
739: IF p_x_Lot_Serial_rec.last_update_date = FND_API.G_MISS_DATE THEN
740: p_x_Lot_Serial_rec.last_update_date := NULL;
741: END IF;
742:
743: IF p_x_Lot_Serial_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 743: IF p_x_Lot_Serial_rec.last_update_login = FND_API.G_MISS_NUM THEN

739: IF p_x_Lot_Serial_rec.last_update_date = FND_API.G_MISS_DATE THEN
740: p_x_Lot_Serial_rec.last_update_date := NULL;
741: END IF;
742:
743: IF p_x_Lot_Serial_rec.last_update_login = FND_API.G_MISS_NUM THEN
744: p_x_Lot_Serial_rec.last_update_login := NULL;
745: END IF;
746:
747: IF p_x_Lot_Serial_rec.line_id = FND_API.G_MISS_NUM THEN

Line 747: IF p_x_Lot_Serial_rec.line_id = FND_API.G_MISS_NUM THEN

743: IF p_x_Lot_Serial_rec.last_update_login = FND_API.G_MISS_NUM THEN
744: p_x_Lot_Serial_rec.last_update_login := NULL;
745: END IF;
746:
747: IF p_x_Lot_Serial_rec.line_id = FND_API.G_MISS_NUM THEN
748: p_x_Lot_Serial_rec.line_id := NULL;
749: END IF;
750:
751: IF p_x_Lot_Serial_rec.line_set_id = FND_API.G_MISS_NUM THEN

Line 751: IF p_x_Lot_Serial_rec.line_set_id = FND_API.G_MISS_NUM THEN

747: IF p_x_Lot_Serial_rec.line_id = FND_API.G_MISS_NUM THEN
748: p_x_Lot_Serial_rec.line_id := NULL;
749: END IF;
750:
751: IF p_x_Lot_Serial_rec.line_set_id = FND_API.G_MISS_NUM THEN
752: p_x_Lot_Serial_rec.line_set_id := NULL;
753: END IF;
754:
755: IF p_x_Lot_Serial_rec.lot_number = FND_API.G_MISS_CHAR THEN

Line 755: IF p_x_Lot_Serial_rec.lot_number = FND_API.G_MISS_CHAR THEN

751: IF p_x_Lot_Serial_rec.line_set_id = FND_API.G_MISS_NUM THEN
752: p_x_Lot_Serial_rec.line_set_id := NULL;
753: END IF;
754:
755: IF p_x_Lot_Serial_rec.lot_number = FND_API.G_MISS_CHAR THEN
756: p_x_Lot_Serial_rec.lot_number := NULL;
757: END IF;
758:
759: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510'

Line 762: /*IF p_x_Lot_Serial_rec.sublot_number = FND_API.G_MISS_CHAR THENINVCONV

758:
759: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510'
760: THEN
761:
762: /*IF p_x_Lot_Serial_rec.sublot_number = FND_API.G_MISS_CHAR THENINVCONV
763: p_x_Lot_Serial_rec.sublot_number := NULL;
764: END IF; --OPM 2380194 */
765:
766: IF p_x_Lot_Serial_rec.quantity2 = FND_API.G_MISS_NUM THEN --OPM 2380194

Line 766: IF p_x_Lot_Serial_rec.quantity2 = FND_API.G_MISS_NUM THEN --OPM 2380194

762: /*IF p_x_Lot_Serial_rec.sublot_number = FND_API.G_MISS_CHAR THENINVCONV
763: p_x_Lot_Serial_rec.sublot_number := NULL;
764: END IF; --OPM 2380194 */
765:
766: IF p_x_Lot_Serial_rec.quantity2 = FND_API.G_MISS_NUM THEN --OPM 2380194
767: p_x_Lot_Serial_rec.quantity2 := NULL;
768: END IF;
769: END IF;
770:

Line 771: IF p_x_Lot_Serial_rec.lot_serial_id = FND_API.G_MISS_NUM THEN

767: p_x_Lot_Serial_rec.quantity2 := NULL;
768: END IF;
769: END IF;
770:
771: IF p_x_Lot_Serial_rec.lot_serial_id = FND_API.G_MISS_NUM THEN
772: p_x_Lot_Serial_rec.lot_serial_id := NULL;
773: END IF;
774:
775: IF p_x_Lot_Serial_rec.quantity = FND_API.G_MISS_NUM THEN

Line 775: IF p_x_Lot_Serial_rec.quantity = FND_API.G_MISS_NUM THEN

771: IF p_x_Lot_Serial_rec.lot_serial_id = FND_API.G_MISS_NUM THEN
772: p_x_Lot_Serial_rec.lot_serial_id := NULL;
773: END IF;
774:
775: IF p_x_Lot_Serial_rec.quantity = FND_API.G_MISS_NUM THEN
776: p_x_Lot_Serial_rec.quantity := NULL;
777: END IF;
778:
779: IF p_x_Lot_Serial_rec.to_serial_number = FND_API.G_MISS_CHAR THEN

Line 779: IF p_x_Lot_Serial_rec.to_serial_number = FND_API.G_MISS_CHAR THEN

775: IF p_x_Lot_Serial_rec.quantity = FND_API.G_MISS_NUM THEN
776: p_x_Lot_Serial_rec.quantity := NULL;
777: END IF;
778:
779: IF p_x_Lot_Serial_rec.to_serial_number = FND_API.G_MISS_CHAR THEN
780: p_x_Lot_Serial_rec.to_serial_number := NULL;
781: END IF;
782:
783: END Convert_Miss_To_Null;

Line 816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

812: , 'Set_Line_Set_ID'
813: );
814: END IF;
815:
816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
817:
818: END Set_Line_Set_ID;
819:
820: -- Procedure Update_Row

Line 907: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

903: x_return_status => l_return_status);
904:
905: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LOT_SERIAL_UTIL.update_row is: ' || l_return_status);
906:
907: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
908: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
909: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.Update_ROW', 1);
910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
911: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

906:
907: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
908: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
909: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.Update_ROW', 1);
910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
911: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
912: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Update_row');
913: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.Update_ROW', 1);
914: RAISE FND_API.G_EXC_ERROR;

Line 911: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

907: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
908: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
909: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.Update_ROW', 1);
910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
911: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
912: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Update_row');
913: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.Update_ROW', 1);
914: RAISE FND_API.G_EXC_ERROR;
915: END IF;

Line 914: RAISE FND_API.G_EXC_ERROR;

910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
911: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
912: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Update_row');
913: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.Update_ROW', 1);
914: RAISE FND_API.G_EXC_ERROR;
915: END IF;
916:
917: -- notification framework end
918: END IF; /* code set is pack H or higher */

Line 933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

929: , 'Update_Row'
930: );
931: END IF;
932:
933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
934:
935: END Update_Row;
936:
937: -- Procedure Insert_Row

Line 1035: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1031: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LOT_SERIAL_UTIL.insert_row is: ' || l_return_status);
1032: OE_DEBUG_PUB.ADD('returned index is: ' || l_index ,1);
1033:
1034:
1035: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1036: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
1037: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.INSERT_ROW', 1);
1038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1039: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1034:
1035: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1036: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
1037: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.INSERT_ROW', 1);
1038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1039: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1040: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Insert_row');
1041: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.INSERT_ROW', 1);
1042: RAISE FND_API.G_EXC_ERROR;

Line 1039: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1035: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1036: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
1037: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.INSERT_ROW', 1);
1038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1039: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1040: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Insert_row');
1041: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.INSERT_ROW', 1);
1042: RAISE FND_API.G_EXC_ERROR;
1043: END IF;

Line 1042: RAISE FND_API.G_EXC_ERROR;

1038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1039: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1040: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Insert_row');
1041: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.INSERT_ROW', 1);
1042: RAISE FND_API.G_EXC_ERROR;
1043: END IF;
1044:
1045: -- notification framework end
1046: END IF; /* code set is pack H or higher */

Line 1061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1057: , 'Insert_Row'
1058: );
1059: END IF;
1060:
1061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1062:
1063: END Insert_Row;
1064:
1065: /* Function Is_Last_In_Line_Set: to check if there is any other line that is in the same

Line 1082: l_line_rec.line_set_id <> fnd_api.g_miss_num)

1078:
1079: l_line_set_id := l_line_rec.line_set_id;
1080:
1081: IF (l_line_rec.line_set_id IS NOT NULL AND
1082: l_line_rec.line_set_id <> fnd_api.g_miss_num)
1083: THEN
1084:
1085: BEGIN
1086: SELECT 1 INTO dummy

Line 1096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1092: RETURN TRUE;
1093: END;
1094: RETURN FALSE;
1095: ELSE
1096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1097: END IF;
1098:
1099: END Is_Last_In_Line_Set;
1100:

Line 1104: ( p_lot_serial_id IN NUMBER := fnd_api.g_miss_num

1100:
1101: -- Procedure Delete_Row
1102:
1103: PROCEDURE Delete_Row
1104: ( p_lot_serial_id IN NUMBER := fnd_api.g_miss_num
1105: , p_line_id IN NUMBER := fnd_api.g_miss_num
1106:
1107: )
1108: IS

Line 1105: , p_line_id IN NUMBER := fnd_api.g_miss_num

1101: -- Procedure Delete_Row
1102:
1103: PROCEDURE Delete_Row
1104: ( p_lot_serial_id IN NUMBER := fnd_api.g_miss_num
1105: , p_line_id IN NUMBER := fnd_api.g_miss_num
1106:
1107: )
1108: IS
1109: l_line_rec OE_ORDER_PUB.line_rec_type;

Line 1133: IF (p_line_id <> FND_API.G_MISS_NUM)

1129:
1130: BEGIN
1131:
1132: oe_debug_pub.add('Entering OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1133: IF (p_line_id <> FND_API.G_MISS_NUM)
1134: THEN
1135:
1136: OE_LINE_UTIL.Query_Row(p_line_id=>p_line_id,x_line_rec=>l_line_rec);
1137:

Line 1141: l_line_rec.line_set_id = FND_API.G_MISS_NUM)

1137:
1138: IF (l_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE)
1139: THEN
1140: IF (l_line_rec.line_set_id IS NULL OR
1141: l_line_rec.line_set_id = FND_API.G_MISS_NUM)
1142: THEN
1143: /* jolin start*/
1144: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
1145: --added for notification framework to update global picture for lot serials for this line_id

Line 1172: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1168:
1169: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LOT_SERIAL_UTIL.delete_row' ||
1170: ' for deleting line set lot_serial line is: ' || l_return_status);
1171:
1172: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1173: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
1174: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1176: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1171:
1172: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1173: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
1174: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1176: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1177: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Delete_row');
1178: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1179: RAISE FND_API.G_EXC_ERROR;

Line 1176: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1172: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1173: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
1174: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1176: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1177: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Delete_row');
1178: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1179: RAISE FND_API.G_EXC_ERROR;
1180: END IF;

Line 1179: RAISE FND_API.G_EXC_ERROR;

1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1176: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1177: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Delete_row');
1178: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1179: RAISE FND_API.G_EXC_ERROR;
1180: END IF;
1181:
1182: END LOOP;
1183: -- notification framework end

Line 1221: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1217:
1218: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LOT_SERIAL_UTIL.delete_row' ||
1219: ' for deleting line set lot_serial line is: ' || l_return_status);
1220:
1221: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1222: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
1223: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1225: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1220:
1221: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1222: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
1223: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1225: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1226: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Delete_row');
1227: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1228: RAISE FND_API.G_EXC_ERROR;

Line 1225: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1221: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1222: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
1223: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1225: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1226: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Delete_row');
1227: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1228: RAISE FND_API.G_EXC_ERROR;
1229: END IF;

Line 1228: RAISE FND_API.G_EXC_ERROR;

1224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1225: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1226: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Delete_row');
1227: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1228: RAISE FND_API.G_EXC_ERROR;
1229: END IF;
1230:
1231: END LOOP;
1232: -- notification framework end

Line 1264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1260: , 'Delete_Row'
1261: );
1262: END IF;
1263:
1264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1265:
1266: END Delete_Row;
1267:
1268: -- Procedure Query_Row

Line 1292: FND_API.G_MISS_NUM

1288: --
1289:
1290: PROCEDURE Query_Rows
1291: ( p_lot_serial_id IN NUMBER :=
1292: FND_API.G_MISS_NUM
1293: , p_line_id IN NUMBER :=
1294: FND_API.G_MISS_NUM
1295: , p_line_set_id IN NUMBER :=
1296: FND_API.G_MISS_NUM

Line 1294: FND_API.G_MISS_NUM

1290: PROCEDURE Query_Rows
1291: ( p_lot_serial_id IN NUMBER :=
1292: FND_API.G_MISS_NUM
1293: , p_line_id IN NUMBER :=
1294: FND_API.G_MISS_NUM
1295: , p_line_set_id IN NUMBER :=
1296: FND_API.G_MISS_NUM
1297: , x_lot_serial_tbl IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Tbl_Type
1298: )

Line 1296: FND_API.G_MISS_NUM

1292: FND_API.G_MISS_NUM
1293: , p_line_id IN NUMBER :=
1294: FND_API.G_MISS_NUM
1295: , p_line_set_id IN NUMBER :=
1296: FND_API.G_MISS_NUM
1297: , x_lot_serial_tbl IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Tbl_Type
1298: )
1299: IS
1300: l_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

Line 1350: p_lot_serial_id <> FND_API.G_MISS_NUM)

1346:
1347: IF
1348: (p_lot_serial_id IS NOT NULL
1349: AND
1350: p_lot_serial_id <> FND_API.G_MISS_NUM)
1351: AND
1352: (p_line_id IS NOT NULL
1353: AND
1354: p_line_id <> FND_API.G_MISS_NUM)

Line 1354: p_line_id <> FND_API.G_MISS_NUM)

1350: p_lot_serial_id <> FND_API.G_MISS_NUM)
1351: AND
1352: (p_line_id IS NOT NULL
1353: AND
1354: p_line_id <> FND_API.G_MISS_NUM)
1355: THEN
1356: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1357: THEN
1358: OE_MSG_PUB.Add_Exc_Msg

Line 1365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1361: , 'Keys are mutually exclusive: lot_serial_id = '|| p_lot_serial_id || ', line_id = '|| p_line_id
1362: );
1363: END IF;
1364:
1365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1366:
1367: END IF;
1368:
1369: IF

Line 1372: p_lot_serial_id <> FND_API.G_MISS_NUM)

1368:
1369: IF
1370: (p_lot_serial_id IS NOT NULL
1371: AND
1372: p_lot_serial_id <> FND_API.G_MISS_NUM)
1373: AND
1374: (p_line_set_id IS NOT NULL
1375: AND
1376: p_line_set_id <> FND_API.G_MISS_NUM)

Line 1376: p_line_set_id <> FND_API.G_MISS_NUM)

1372: p_lot_serial_id <> FND_API.G_MISS_NUM)
1373: AND
1374: (p_line_set_id IS NOT NULL
1375: AND
1376: p_line_set_id <> FND_API.G_MISS_NUM)
1377: THEN
1378: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1379: THEN
1380: OE_MSG_PUB.Add_Exc_Msg

Line 1387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1383: , 'Keys are mutually exclusive: lot_serial_id = '|| p_lot_serial_id || ', line_set_id = '|| p_line_set_id
1384: );
1385: END IF;
1386:
1387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1388:
1389: END IF;
1390:
1391: IF

Line 1394: p_line_set_id <> FND_API.G_MISS_NUM)

1390:
1391: IF
1392: (p_line_set_id IS NOT NULL
1393: AND
1394: p_line_set_id <> FND_API.G_MISS_NUM)
1395: AND
1396: (p_line_id IS NOT NULL
1397: AND
1398: p_line_id <> FND_API.G_MISS_NUM)

Line 1398: p_line_id <> FND_API.G_MISS_NUM)

1394: p_line_set_id <> FND_API.G_MISS_NUM)
1395: AND
1396: (p_line_id IS NOT NULL
1397: AND
1398: p_line_id <> FND_API.G_MISS_NUM)
1399: THEN
1400: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1401: THEN
1402: OE_MSG_PUB.Add_Exc_Msg

Line 1409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1405: , 'Keys are mutually exclusive: line_set_id = '|| p_line_set_id ||', line_id = '|| p_line_id
1406: );
1407: END IF;
1408:
1409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1410:
1411: END IF;
1412:
1413: /* After a return line is split, lot serial numbers attach to the

Line 1419: p_line_id <> FND_API.G_MISS_NUM)

1415: and if yes, query by line set */
1416: IF
1417: (p_line_id IS NOT NULL
1418: AND
1419: p_line_id <> FND_API.G_MISS_NUM)
1420: THEN
1421:
1422: -- find line set id and query by line set id
1423: OE_LINE_UTIL.QUERY_ROW(p_line_id=>p_line_id,x_line_rec=>l_line_rec);

Line 1428: l_line_rec.line_set_id <> FND_API.G_MISS_NUM)

1424:
1425: IF
1426: (l_line_rec.line_set_id IS NOT NULL
1427: AND
1428: l_line_rec.line_set_id <> FND_API.G_MISS_NUM)
1429: THEN
1430: l_line_set_id := l_line_rec.line_set_id;
1431: l_line_id := FND_API.G_MISS_NUM;
1432: END IF;

Line 1431: l_line_id := FND_API.G_MISS_NUM;

1427: AND
1428: l_line_rec.line_set_id <> FND_API.G_MISS_NUM)
1429: THEN
1430: l_line_set_id := l_line_rec.line_set_id;
1431: l_line_id := FND_API.G_MISS_NUM;
1432: END IF;
1433:
1434: END IF;
1435:

Line 1521: p_lot_serial_id <> FND_API.G_MISS_NUM)

1517:
1518: IF
1519: (p_lot_serial_id IS NOT NULL
1520: AND
1521: p_lot_serial_id <> FND_API.G_MISS_NUM)
1522: AND
1523: (x_Lot_Serial_tbl.COUNT = 0)
1524: THEN
1525: RAISE NO_DATA_FOUND;

Line 1531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1527:
1528:
1529: EXCEPTION
1530:
1531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1532:
1533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1534:
1535: WHEN OTHERS THEN

Line 1533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1529: EXCEPTION
1530:
1531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1532:
1533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1534:
1535: WHEN OTHERS THEN
1536:
1537: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1541: , 'Query_Rows'
1542: );
1543: END IF;
1544:
1545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1546:
1547: END Query_Rows;
1548:
1549: -- Procedure lock_Row

Line 1554: , p_lot_serial_id IN NUMBER := FND_API.G_MISS_NUM

1550: --
1551:
1552: PROCEDURE Lock_Row
1553: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1554: , p_lot_serial_id IN NUMBER := FND_API.G_MISS_NUM
1555: , p_x_Lot_Serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type
1556: )
1557: IS
1558:

Line 1570: IF p_lot_serial_id <> FND_API.G_MISS_NUM THEN

1566:
1567: l_lock_control := NULL;
1568:
1569: -- Retrieve the primary key.
1570: IF p_lot_serial_id <> FND_API.G_MISS_NUM THEN
1571: l_lot_serial_id := p_lot_serial_id;
1572: ELSE
1573: l_lot_serial_id := p_x_Lot_Serial_rec.lot_serial_id;
1574: l_lock_control := p_x_Lot_Serial_rec.lock_control;

Line 1592: l_lock_control <> FND_API.G_MISS_NUM THEN

1588:
1589:
1590: -- If lock_control is passed, then return the locked record.
1591: IF l_lock_control is NULL OR
1592: l_lock_control <> FND_API.G_MISS_NUM THEN
1593:
1594: -- Set return status
1595: x_return_status := FND_API.G_RET_STS_SUCCESS;
1596: p_x_lot_serial_rec.return_status := FND_API.G_RET_STS_SUCCESS;

Line 1595: x_return_status := FND_API.G_RET_STS_SUCCESS;

1591: IF l_lock_control is NULL OR
1592: l_lock_control <> FND_API.G_MISS_NUM THEN
1593:
1594: -- Set return status
1595: x_return_status := FND_API.G_RET_STS_SUCCESS;
1596: p_x_lot_serial_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1597:
1598: RETURN;
1599:

Line 1596: p_x_lot_serial_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1592: l_lock_control <> FND_API.G_MISS_NUM THEN
1593:
1594: -- Set return status
1595: x_return_status := FND_API.G_RET_STS_SUCCESS;
1596: p_x_lot_serial_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1597:
1598: RETURN;
1599:
1600: END IF;

Line 1611: x_return_status := FND_API.G_RET_STS_SUCCESS;

1607: THEN
1608:
1609: -- Set return status
1610:
1611: x_return_status := FND_API.G_RET_STS_SUCCESS;
1612: p_x_lot_serial_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1613:
1614: ELSE
1615:

Line 1612: p_x_lot_serial_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1608:
1609: -- Set return status
1610:
1611: x_return_status := FND_API.G_RET_STS_SUCCESS;
1612: p_x_lot_serial_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1613:
1614: ELSE
1615:
1616: -- Row has changed by another user.

Line 1618: x_return_status := FND_API.G_RET_STS_ERROR;

1614: ELSE
1615:
1616: -- Row has changed by another user.
1617:
1618: x_return_status := FND_API.G_RET_STS_ERROR;
1619: p_x_lot_serial_rec.return_status := FND_API.G_RET_STS_ERROR;
1620:
1621: IF oe_msg_pub.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1622: THEN

Line 1619: p_x_lot_serial_rec.return_status := FND_API.G_RET_STS_ERROR;

1615:
1616: -- Row has changed by another user.
1617:
1618: x_return_status := FND_API.G_RET_STS_ERROR;
1619: p_x_lot_serial_rec.return_status := FND_API.G_RET_STS_ERROR;
1620:
1621: IF oe_msg_pub.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1622: THEN
1623:

Line 1640: x_return_status := FND_API.G_RET_STS_ERROR;

1636: EXCEPTION
1637:
1638: WHEN NO_DATA_FOUND THEN
1639:
1640: x_return_status := FND_API.G_RET_STS_ERROR;
1641: p_x_Lot_Serial_rec.return_status := FND_API.G_RET_STS_ERROR;
1642:
1643: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1644: THEN

Line 1641: p_x_Lot_Serial_rec.return_status := FND_API.G_RET_STS_ERROR;

1637:
1638: WHEN NO_DATA_FOUND THEN
1639:
1640: x_return_status := FND_API.G_RET_STS_ERROR;
1641: p_x_Lot_Serial_rec.return_status := FND_API.G_RET_STS_ERROR;
1642:
1643: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1644: THEN
1645:

Line 1652: x_return_status := FND_API.G_RET_STS_ERROR;

1648:
1649: END IF;
1650: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1651:
1652: x_return_status := FND_API.G_RET_STS_ERROR;
1653: p_x_Lot_Serial_rec.return_status := FND_API.G_RET_STS_ERROR;
1654:
1655: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1656: THEN

Line 1653: p_x_Lot_Serial_rec.return_status := FND_API.G_RET_STS_ERROR;

1649: END IF;
1650: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1651:
1652: x_return_status := FND_API.G_RET_STS_ERROR;
1653: p_x_Lot_Serial_rec.return_status := FND_API.G_RET_STS_ERROR;
1654:
1655: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1656: THEN
1657:

Line 1664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1660:
1661: END IF;
1662: WHEN OTHERS THEN
1663:
1664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1665: p_x_Lot_Serial_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1666:
1667: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1668: THEN

Line 1665: p_x_Lot_Serial_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1661: END IF;
1662: WHEN OTHERS THEN
1663:
1664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1665: p_x_Lot_Serial_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1666:
1667: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1668: THEN
1669: OE_MSG_PUB.Add_Exc_Msg

Line 1680: FND_API.G_MISS_NUM

1676:
1677:
1678: PROCEDURE Lock_Rows
1679: ( p_lot_serial_id IN NUMBER :=
1680: FND_API.G_MISS_NUM
1681: , p_line_id IN NUMBER :=
1682: FND_API.G_MISS_NUM
1683: , x_lot_serial_tbl OUT NOCOPY OE_Order_PUB.Lot_serial_Tbl_Type
1684: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1682: FND_API.G_MISS_NUM

1678: PROCEDURE Lock_Rows
1679: ( p_lot_serial_id IN NUMBER :=
1680: FND_API.G_MISS_NUM
1681: , p_line_id IN NUMBER :=
1682: FND_API.G_MISS_NUM
1683: , x_lot_serial_tbl OUT NOCOPY OE_Order_PUB.Lot_serial_Tbl_Type
1684: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1685: )
1686: IS

Line 1699: p_lot_serial_id <> FND_API.G_MISS_NUM) AND

1695:
1696: oe_debug_pub.add('entering oe_lot_serial_util.lock_rows', 1);
1697:
1698: IF (p_lot_serial_id IS NOT NULL AND
1699: p_lot_serial_id <> FND_API.G_MISS_NUM) AND
1700: (p_line_id IS NOT NULL AND
1701: p_line_id <> FND_API.G_MISS_NUM)
1702: THEN
1703: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1701: p_line_id <> FND_API.G_MISS_NUM)

1697:
1698: IF (p_lot_serial_id IS NOT NULL AND
1699: p_lot_serial_id <> FND_API.G_MISS_NUM) AND
1700: (p_line_id IS NOT NULL AND
1701: p_line_id <> FND_API.G_MISS_NUM)
1702: THEN
1703: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1704: THEN
1705: OE_MSG_PUB.Add_Exc_Msg

Line 1712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1708: , 'Keys are mutually exclusive: lot_serial_id = '||
1709: p_lot_serial_id || ', line_id = '|| p_line_id );
1710: END IF;
1711:
1712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1713:
1714: END IF;
1715:
1716: IF p_lot_serial_id <> FND_API.G_MISS_NUM THEN

Line 1716: IF p_lot_serial_id <> FND_API.G_MISS_NUM THEN

1712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1713:
1714: END IF;
1715:
1716: IF p_lot_serial_id <> FND_API.G_MISS_NUM THEN
1717:
1718: SELECT lot_serial_id
1719: INTO l_lot_serial_id
1720: FROM OE_LOT_SERIAL_NUMBERS

Line 1731: IF p_line_id <> FND_API.G_MISS_NUM THEN

1727: -- if they already passed in lot_serial_id.
1728:
1729: BEGIN
1730:
1731: IF p_line_id <> FND_API.G_MISS_NUM THEN
1732:
1733: SAVEPOINT LOCK_ROWS;
1734: OPEN lock_lot_serial(p_line_id);
1735:

Line 1764: x_return_status := FND_API.G_RET_STS_SUCCESS;

1760: ,p_line_id => p_line_id
1761: ,x_lot_serial_tbl => x_lot_serial_tbl
1762: );
1763:
1764: x_return_status := FND_API.G_RET_STS_SUCCESS;
1765:
1766: oe_debug_pub.add('exiting oe_lot_serial_util.lock_rows', 1);
1767:
1768: EXCEPTION

Line 1771: x_return_status := FND_API.G_RET_STS_ERROR;

1767:
1768: EXCEPTION
1769: WHEN NO_DATA_FOUND THEN
1770:
1771: x_return_status := FND_API.G_RET_STS_ERROR;
1772:
1773: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1774: THEN
1775: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');

Line 1781: x_return_status := FND_API.G_RET_STS_ERROR;

1777: END IF;
1778:
1779: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1780:
1781: x_return_status := FND_API.G_RET_STS_ERROR;
1782: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1783: THEN
1784: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
1785: OE_MSG_PUB.Add;

Line 1790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1786: END IF;
1787:
1788: WHEN OTHERS THEN
1789:
1790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1791:
1792: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1793: THEN
1794: OE_MSG_PUB.Add_Exc_Msg

Line 1831: p_x_Lot_Serial_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1827: BEGIN
1828:
1829: -- initialize return_status.
1830:
1831: p_x_Lot_Serial_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1832:
1833: END Get_Ids;
1834:
1835: END OE_Lot_Serial_Util;