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_PRICE_LIST_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_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
13: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
14: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
15: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type

Line 30: IF p_attr_id = FND_API.G_MISS_NUM THEN

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

Line 581: IF l_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN

577: IS
578: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
579: BEGIN
580:
581: IF l_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN
582: l_PRICE_LIST_rec.attribute1 := p_old_PRICE_LIST_rec.attribute1;
583: END IF;
584:
585: IF l_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 585: IF l_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN

581: IF l_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN
582: l_PRICE_LIST_rec.attribute1 := p_old_PRICE_LIST_rec.attribute1;
583: END IF;
584:
585: IF l_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN
586: l_PRICE_LIST_rec.attribute10 := p_old_PRICE_LIST_rec.attribute10;
587: END IF;
588:
589: IF l_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 589: IF l_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN

585: IF l_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN
586: l_PRICE_LIST_rec.attribute10 := p_old_PRICE_LIST_rec.attribute10;
587: END IF;
588:
589: IF l_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN
590: l_PRICE_LIST_rec.attribute11 := p_old_PRICE_LIST_rec.attribute11;
591: END IF;
592:
593: IF l_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 593: IF l_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN

589: IF l_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN
590: l_PRICE_LIST_rec.attribute11 := p_old_PRICE_LIST_rec.attribute11;
591: END IF;
592:
593: IF l_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN
594: l_PRICE_LIST_rec.attribute12 := p_old_PRICE_LIST_rec.attribute12;
595: END IF;
596:
597: IF l_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 597: IF l_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN

593: IF l_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN
594: l_PRICE_LIST_rec.attribute12 := p_old_PRICE_LIST_rec.attribute12;
595: END IF;
596:
597: IF l_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN
598: l_PRICE_LIST_rec.attribute13 := p_old_PRICE_LIST_rec.attribute13;
599: END IF;
600:
601: IF l_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 601: IF l_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN

597: IF l_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN
598: l_PRICE_LIST_rec.attribute13 := p_old_PRICE_LIST_rec.attribute13;
599: END IF;
600:
601: IF l_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN
602: l_PRICE_LIST_rec.attribute14 := p_old_PRICE_LIST_rec.attribute14;
603: END IF;
604:
605: IF l_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 605: IF l_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN

601: IF l_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN
602: l_PRICE_LIST_rec.attribute14 := p_old_PRICE_LIST_rec.attribute14;
603: END IF;
604:
605: IF l_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN
606: l_PRICE_LIST_rec.attribute15 := p_old_PRICE_LIST_rec.attribute15;
607: END IF;
608:
609: IF l_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 609: IF l_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN

605: IF l_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN
606: l_PRICE_LIST_rec.attribute15 := p_old_PRICE_LIST_rec.attribute15;
607: END IF;
608:
609: IF l_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN
610: l_PRICE_LIST_rec.attribute2 := p_old_PRICE_LIST_rec.attribute2;
611: END IF;
612:
613: IF l_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 613: IF l_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN

609: IF l_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN
610: l_PRICE_LIST_rec.attribute2 := p_old_PRICE_LIST_rec.attribute2;
611: END IF;
612:
613: IF l_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN
614: l_PRICE_LIST_rec.attribute3 := p_old_PRICE_LIST_rec.attribute3;
615: END IF;
616:
617: IF l_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 617: IF l_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN

613: IF l_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN
614: l_PRICE_LIST_rec.attribute3 := p_old_PRICE_LIST_rec.attribute3;
615: END IF;
616:
617: IF l_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN
618: l_PRICE_LIST_rec.attribute4 := p_old_PRICE_LIST_rec.attribute4;
619: END IF;
620:
621: IF l_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 621: IF l_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN

617: IF l_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN
618: l_PRICE_LIST_rec.attribute4 := p_old_PRICE_LIST_rec.attribute4;
619: END IF;
620:
621: IF l_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN
622: l_PRICE_LIST_rec.attribute5 := p_old_PRICE_LIST_rec.attribute5;
623: END IF;
624:
625: IF l_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 625: IF l_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN

621: IF l_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN
622: l_PRICE_LIST_rec.attribute5 := p_old_PRICE_LIST_rec.attribute5;
623: END IF;
624:
625: IF l_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN
626: l_PRICE_LIST_rec.attribute6 := p_old_PRICE_LIST_rec.attribute6;
627: END IF;
628:
629: IF l_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 629: IF l_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN

625: IF l_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN
626: l_PRICE_LIST_rec.attribute6 := p_old_PRICE_LIST_rec.attribute6;
627: END IF;
628:
629: IF l_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN
630: l_PRICE_LIST_rec.attribute7 := p_old_PRICE_LIST_rec.attribute7;
631: END IF;
632:
633: IF l_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 633: IF l_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN

629: IF l_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN
630: l_PRICE_LIST_rec.attribute7 := p_old_PRICE_LIST_rec.attribute7;
631: END IF;
632:
633: IF l_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN
634: l_PRICE_LIST_rec.attribute8 := p_old_PRICE_LIST_rec.attribute8;
635: END IF;
636:
637: IF l_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 637: IF l_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN

633: IF l_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN
634: l_PRICE_LIST_rec.attribute8 := p_old_PRICE_LIST_rec.attribute8;
635: END IF;
636:
637: IF l_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN
638: l_PRICE_LIST_rec.attribute9 := p_old_PRICE_LIST_rec.attribute9;
639: END IF;
640:
641: IF l_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR THEN

Line 641: IF l_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR THEN

637: IF l_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN
638: l_PRICE_LIST_rec.attribute9 := p_old_PRICE_LIST_rec.attribute9;
639: END IF;
640:
641: IF l_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR THEN
642: l_PRICE_LIST_rec.comments := p_old_PRICE_LIST_rec.comments;
643: END IF;
644:
645: IF l_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR THEN

Line 645: IF l_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR THEN

641: IF l_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR THEN
642: l_PRICE_LIST_rec.comments := p_old_PRICE_LIST_rec.comments;
643: END IF;
644:
645: IF l_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR THEN
646: l_PRICE_LIST_rec.context := p_old_PRICE_LIST_rec.context;
647: END IF;
648:
649: IF l_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM THEN

Line 649: IF l_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM THEN

645: IF l_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR THEN
646: l_PRICE_LIST_rec.context := p_old_PRICE_LIST_rec.context;
647: END IF;
648:
649: IF l_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM THEN
650: l_PRICE_LIST_rec.created_by := p_old_PRICE_LIST_rec.created_by;
651: END IF;
652:
653: IF l_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 653: IF l_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN

649: IF l_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM THEN
650: l_PRICE_LIST_rec.created_by := p_old_PRICE_LIST_rec.created_by;
651: END IF;
652:
653: IF l_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN
654: l_PRICE_LIST_rec.creation_date := p_old_PRICE_LIST_rec.creation_date;
655: END IF;
656:
657: IF l_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN

Line 657: IF l_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN

653: IF l_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN
654: l_PRICE_LIST_rec.creation_date := p_old_PRICE_LIST_rec.creation_date;
655: END IF;
656:
657: IF l_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN
658: l_PRICE_LIST_rec.currency_code := p_old_PRICE_LIST_rec.currency_code;
659: END IF;
660:
661: IF l_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR THEN

Line 661: IF l_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR THEN

657: IF l_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN
658: l_PRICE_LIST_rec.currency_code := p_old_PRICE_LIST_rec.currency_code;
659: END IF;
660:
661: IF l_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR THEN
662: l_PRICE_LIST_rec.description := p_old_PRICE_LIST_rec.description;
663: END IF;
664:
665: IF l_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN

Line 665: IF l_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN

661: IF l_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR THEN
662: l_PRICE_LIST_rec.description := p_old_PRICE_LIST_rec.description;
663: END IF;
664:
665: IF l_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN
666: l_PRICE_LIST_rec.end_date_active := p_old_PRICE_LIST_rec.end_date_active;
667: END IF;
668:
669: IF l_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN

Line 669: IF l_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN

665: IF l_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN
666: l_PRICE_LIST_rec.end_date_active := p_old_PRICE_LIST_rec.end_date_active;
667: END IF;
668:
669: IF l_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
670: l_PRICE_LIST_rec.freight_terms_code := p_old_PRICE_LIST_rec.freight_terms_code;
671: END IF;
672:
673: IF l_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 673: IF l_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN

669: IF l_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
670: l_PRICE_LIST_rec.freight_terms_code := p_old_PRICE_LIST_rec.freight_terms_code;
671: END IF;
672:
673: IF l_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN
674: l_PRICE_LIST_rec.last_updated_by := p_old_PRICE_LIST_rec.last_updated_by;
675: END IF;
676:
677: IF l_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 677: IF l_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN

673: IF l_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN
674: l_PRICE_LIST_rec.last_updated_by := p_old_PRICE_LIST_rec.last_updated_by;
675: END IF;
676:
677: IF l_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN
678: l_PRICE_LIST_rec.last_update_date := p_old_PRICE_LIST_rec.last_update_date;
679: END IF;
680:
681: IF l_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 681: IF l_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN

677: IF l_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN
678: l_PRICE_LIST_rec.last_update_date := p_old_PRICE_LIST_rec.last_update_date;
679: END IF;
680:
681: IF l_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN
682: l_PRICE_LIST_rec.last_update_login := p_old_PRICE_LIST_rec.last_update_login;
683: END IF;
684:
685: IF l_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR THEN

Line 685: IF l_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR THEN

681: IF l_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN
682: l_PRICE_LIST_rec.last_update_login := p_old_PRICE_LIST_rec.last_update_login;
683: END IF;
684:
685: IF l_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR THEN
686: l_PRICE_LIST_rec.name := p_old_PRICE_LIST_rec.name;
687: END IF;
688:
689: IF l_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM THEN

Line 689: IF l_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM THEN

685: IF l_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR THEN
686: l_PRICE_LIST_rec.name := p_old_PRICE_LIST_rec.name;
687: END IF;
688:
689: IF l_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM THEN
690: l_PRICE_LIST_rec.price_list_id := p_old_PRICE_LIST_rec.price_list_id;
691: END IF;
692:
693: IF l_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 693: IF l_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN

689: IF l_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM THEN
690: l_PRICE_LIST_rec.price_list_id := p_old_PRICE_LIST_rec.price_list_id;
691: END IF;
692:
693: IF l_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN
694: l_PRICE_LIST_rec.program_application_id := p_old_PRICE_LIST_rec.program_application_id;
695: END IF;
696:
697: IF l_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM THEN

Line 697: IF l_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM THEN

693: IF l_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN
694: l_PRICE_LIST_rec.program_application_id := p_old_PRICE_LIST_rec.program_application_id;
695: END IF;
696:
697: IF l_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM THEN
698: l_PRICE_LIST_rec.program_id := p_old_PRICE_LIST_rec.program_id;
699: END IF;
700:
701: IF l_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 701: IF l_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN

697: IF l_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM THEN
698: l_PRICE_LIST_rec.program_id := p_old_PRICE_LIST_rec.program_id;
699: END IF;
700:
701: IF l_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN
702: l_PRICE_LIST_rec.program_update_date := p_old_PRICE_LIST_rec.program_update_date;
703: END IF;
704:
705: IF l_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM THEN

Line 705: IF l_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM THEN

701: IF l_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN
702: l_PRICE_LIST_rec.program_update_date := p_old_PRICE_LIST_rec.program_update_date;
703: END IF;
704:
705: IF l_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM THEN
706: l_PRICE_LIST_rec.request_id := p_old_PRICE_LIST_rec.request_id;
707: END IF;
708:
709: IF l_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN

Line 709: IF l_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN

705: IF l_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM THEN
706: l_PRICE_LIST_rec.request_id := p_old_PRICE_LIST_rec.request_id;
707: END IF;
708:
709: IF l_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN
710: l_PRICE_LIST_rec.rounding_factor := p_old_PRICE_LIST_rec.rounding_factor;
711: END IF;
712:
713: IF l_PRICE_LIST_rec.secondary_price_list_id = FND_API.G_MISS_NUM THEN

Line 713: IF l_PRICE_LIST_rec.secondary_price_list_id = FND_API.G_MISS_NUM THEN

709: IF l_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN
710: l_PRICE_LIST_rec.rounding_factor := p_old_PRICE_LIST_rec.rounding_factor;
711: END IF;
712:
713: IF l_PRICE_LIST_rec.secondary_price_list_id = FND_API.G_MISS_NUM THEN
714: l_PRICE_LIST_rec.secondary_price_list_id := p_old_PRICE_LIST_rec.secondary_price_list_id;
715: END IF;
716:
717: IF l_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN

Line 717: IF l_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN

713: IF l_PRICE_LIST_rec.secondary_price_list_id = FND_API.G_MISS_NUM THEN
714: l_PRICE_LIST_rec.secondary_price_list_id := p_old_PRICE_LIST_rec.secondary_price_list_id;
715: END IF;
716:
717: IF l_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
718: l_PRICE_LIST_rec.ship_method_code := p_old_PRICE_LIST_rec.ship_method_code;
719: END IF;
720:
721: IF l_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN

Line 721: IF l_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN

717: IF l_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
718: l_PRICE_LIST_rec.ship_method_code := p_old_PRICE_LIST_rec.ship_method_code;
719: END IF;
720:
721: IF l_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN
722: l_PRICE_LIST_rec.start_date_active := p_old_PRICE_LIST_rec.start_date_active;
723: END IF;
724:
725: IF l_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN

Line 725: IF l_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN

721: IF l_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN
722: l_PRICE_LIST_rec.start_date_active := p_old_PRICE_LIST_rec.start_date_active;
723: END IF;
724:
725: IF l_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN
726: l_PRICE_LIST_rec.terms_id := p_old_PRICE_LIST_rec.terms_id;
727: END IF;
728:
729: RETURN l_PRICE_LIST_rec;

Line 742: IF l_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN

738: IS
739: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
740: BEGIN
741:
742: IF l_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN
743: l_PRICE_LIST_rec.attribute1 := NULL;
744: END IF;
745:
746: IF l_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 746: IF l_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN

742: IF l_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN
743: l_PRICE_LIST_rec.attribute1 := NULL;
744: END IF;
745:
746: IF l_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN
747: l_PRICE_LIST_rec.attribute10 := NULL;
748: END IF;
749:
750: IF l_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 750: IF l_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN

746: IF l_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN
747: l_PRICE_LIST_rec.attribute10 := NULL;
748: END IF;
749:
750: IF l_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN
751: l_PRICE_LIST_rec.attribute11 := NULL;
752: END IF;
753:
754: IF l_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 754: IF l_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN

750: IF l_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN
751: l_PRICE_LIST_rec.attribute11 := NULL;
752: END IF;
753:
754: IF l_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN
755: l_PRICE_LIST_rec.attribute12 := NULL;
756: END IF;
757:
758: IF l_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 758: IF l_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN

754: IF l_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN
755: l_PRICE_LIST_rec.attribute12 := NULL;
756: END IF;
757:
758: IF l_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN
759: l_PRICE_LIST_rec.attribute13 := NULL;
760: END IF;
761:
762: IF l_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 762: IF l_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN

758: IF l_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN
759: l_PRICE_LIST_rec.attribute13 := NULL;
760: END IF;
761:
762: IF l_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN
763: l_PRICE_LIST_rec.attribute14 := NULL;
764: END IF;
765:
766: IF l_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 766: IF l_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN

762: IF l_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN
763: l_PRICE_LIST_rec.attribute14 := NULL;
764: END IF;
765:
766: IF l_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN
767: l_PRICE_LIST_rec.attribute15 := NULL;
768: END IF;
769:
770: IF l_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 770: IF l_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN

766: IF l_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN
767: l_PRICE_LIST_rec.attribute15 := NULL;
768: END IF;
769:
770: IF l_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN
771: l_PRICE_LIST_rec.attribute2 := NULL;
772: END IF;
773:
774: IF l_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 774: IF l_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN

770: IF l_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN
771: l_PRICE_LIST_rec.attribute2 := NULL;
772: END IF;
773:
774: IF l_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN
775: l_PRICE_LIST_rec.attribute3 := NULL;
776: END IF;
777:
778: IF l_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 778: IF l_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN

774: IF l_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN
775: l_PRICE_LIST_rec.attribute3 := NULL;
776: END IF;
777:
778: IF l_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN
779: l_PRICE_LIST_rec.attribute4 := NULL;
780: END IF;
781:
782: IF l_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 782: IF l_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN

778: IF l_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN
779: l_PRICE_LIST_rec.attribute4 := NULL;
780: END IF;
781:
782: IF l_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN
783: l_PRICE_LIST_rec.attribute5 := NULL;
784: END IF;
785:
786: IF l_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 786: IF l_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN

782: IF l_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN
783: l_PRICE_LIST_rec.attribute5 := NULL;
784: END IF;
785:
786: IF l_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN
787: l_PRICE_LIST_rec.attribute6 := NULL;
788: END IF;
789:
790: IF l_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 790: IF l_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN

786: IF l_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN
787: l_PRICE_LIST_rec.attribute6 := NULL;
788: END IF;
789:
790: IF l_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN
791: l_PRICE_LIST_rec.attribute7 := NULL;
792: END IF;
793:
794: IF l_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 794: IF l_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN

790: IF l_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN
791: l_PRICE_LIST_rec.attribute7 := NULL;
792: END IF;
793:
794: IF l_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN
795: l_PRICE_LIST_rec.attribute8 := NULL;
796: END IF;
797:
798: IF l_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 798: IF l_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN

794: IF l_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN
795: l_PRICE_LIST_rec.attribute8 := NULL;
796: END IF;
797:
798: IF l_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN
799: l_PRICE_LIST_rec.attribute9 := NULL;
800: END IF;
801:
802: IF l_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR THEN

Line 802: IF l_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR THEN

798: IF l_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN
799: l_PRICE_LIST_rec.attribute9 := NULL;
800: END IF;
801:
802: IF l_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR THEN
803: l_PRICE_LIST_rec.comments := NULL;
804: END IF;
805:
806: IF l_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR THEN

Line 806: IF l_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR THEN

802: IF l_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR THEN
803: l_PRICE_LIST_rec.comments := NULL;
804: END IF;
805:
806: IF l_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR THEN
807: l_PRICE_LIST_rec.context := NULL;
808: END IF;
809:
810: IF l_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM THEN

Line 810: IF l_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM THEN

806: IF l_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR THEN
807: l_PRICE_LIST_rec.context := NULL;
808: END IF;
809:
810: IF l_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM THEN
811: l_PRICE_LIST_rec.created_by := NULL;
812: END IF;
813:
814: IF l_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 814: IF l_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN

810: IF l_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM THEN
811: l_PRICE_LIST_rec.created_by := NULL;
812: END IF;
813:
814: IF l_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN
815: l_PRICE_LIST_rec.creation_date := NULL;
816: END IF;
817:
818: IF l_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN

Line 818: IF l_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN

814: IF l_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN
815: l_PRICE_LIST_rec.creation_date := NULL;
816: END IF;
817:
818: IF l_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN
819: l_PRICE_LIST_rec.currency_code := NULL;
820: END IF;
821:
822: IF l_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR THEN

Line 822: IF l_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR THEN

818: IF l_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN
819: l_PRICE_LIST_rec.currency_code := NULL;
820: END IF;
821:
822: IF l_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR THEN
823: l_PRICE_LIST_rec.description := NULL;
824: END IF;
825:
826: IF l_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN

Line 826: IF l_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN

822: IF l_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR THEN
823: l_PRICE_LIST_rec.description := NULL;
824: END IF;
825:
826: IF l_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN
827: l_PRICE_LIST_rec.end_date_active := NULL;
828: END IF;
829:
830: IF l_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN

Line 830: IF l_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN

826: IF l_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN
827: l_PRICE_LIST_rec.end_date_active := NULL;
828: END IF;
829:
830: IF l_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
831: l_PRICE_LIST_rec.freight_terms_code := NULL;
832: END IF;
833:
834: IF l_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 834: IF l_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN

830: IF l_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
831: l_PRICE_LIST_rec.freight_terms_code := NULL;
832: END IF;
833:
834: IF l_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN
835: l_PRICE_LIST_rec.last_updated_by := NULL;
836: END IF;
837:
838: IF l_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 838: IF l_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN

834: IF l_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN
835: l_PRICE_LIST_rec.last_updated_by := NULL;
836: END IF;
837:
838: IF l_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN
839: l_PRICE_LIST_rec.last_update_date := NULL;
840: END IF;
841:
842: IF l_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 842: IF l_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN

838: IF l_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN
839: l_PRICE_LIST_rec.last_update_date := NULL;
840: END IF;
841:
842: IF l_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN
843: l_PRICE_LIST_rec.last_update_login := NULL;
844: END IF;
845:
846: IF l_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR THEN

Line 846: IF l_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR THEN

842: IF l_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN
843: l_PRICE_LIST_rec.last_update_login := NULL;
844: END IF;
845:
846: IF l_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR THEN
847: l_PRICE_LIST_rec.name := NULL;
848: END IF;
849:
850: IF l_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM THEN

Line 850: IF l_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM THEN

846: IF l_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR THEN
847: l_PRICE_LIST_rec.name := NULL;
848: END IF;
849:
850: IF l_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM THEN
851: l_PRICE_LIST_rec.price_list_id := NULL;
852: END IF;
853:
854: IF l_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 854: IF l_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN

850: IF l_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM THEN
851: l_PRICE_LIST_rec.price_list_id := NULL;
852: END IF;
853:
854: IF l_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN
855: l_PRICE_LIST_rec.program_application_id := NULL;
856: END IF;
857:
858: IF l_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM THEN

Line 858: IF l_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM THEN

854: IF l_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN
855: l_PRICE_LIST_rec.program_application_id := NULL;
856: END IF;
857:
858: IF l_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM THEN
859: l_PRICE_LIST_rec.program_id := NULL;
860: END IF;
861:
862: IF l_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 862: IF l_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN

858: IF l_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM THEN
859: l_PRICE_LIST_rec.program_id := NULL;
860: END IF;
861:
862: IF l_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN
863: l_PRICE_LIST_rec.program_update_date := NULL;
864: END IF;
865:
866: IF l_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM THEN

Line 866: IF l_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM THEN

862: IF l_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN
863: l_PRICE_LIST_rec.program_update_date := NULL;
864: END IF;
865:
866: IF l_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM THEN
867: l_PRICE_LIST_rec.request_id := NULL;
868: END IF;
869:
870: IF l_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN

Line 870: IF l_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN

866: IF l_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM THEN
867: l_PRICE_LIST_rec.request_id := NULL;
868: END IF;
869:
870: IF l_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN
871: l_PRICE_LIST_rec.rounding_factor := NULL;
872: END IF;
873:
874: IF l_PRICE_LIST_rec.secondary_price_list_id = FND_API.G_MISS_NUM THEN

Line 874: IF l_PRICE_LIST_rec.secondary_price_list_id = FND_API.G_MISS_NUM THEN

870: IF l_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN
871: l_PRICE_LIST_rec.rounding_factor := NULL;
872: END IF;
873:
874: IF l_PRICE_LIST_rec.secondary_price_list_id = FND_API.G_MISS_NUM THEN
875: l_PRICE_LIST_rec.secondary_price_list_id := NULL;
876: END IF;
877:
878: IF l_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN

Line 878: IF l_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN

874: IF l_PRICE_LIST_rec.secondary_price_list_id = FND_API.G_MISS_NUM THEN
875: l_PRICE_LIST_rec.secondary_price_list_id := NULL;
876: END IF;
877:
878: IF l_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
879: l_PRICE_LIST_rec.ship_method_code := NULL;
880: END IF;
881:
882: IF l_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN

Line 882: IF l_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN

878: IF l_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
879: l_PRICE_LIST_rec.ship_method_code := NULL;
880: END IF;
881:
882: IF l_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN
883: l_PRICE_LIST_rec.start_date_active := NULL;
884: END IF;
885:
886: IF l_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN

Line 886: IF l_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN

882: IF l_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN
883: l_PRICE_LIST_rec.start_date_active := NULL;
884: END IF;
885:
886: IF l_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN
887: l_PRICE_LIST_rec.terms_id := NULL;
888: END IF;
889:
890: RETURN l_PRICE_LIST_rec;

Line 1010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1006: , 'Update_Row'
1007: );
1008: END IF;
1009:
1010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1011:
1012: END Update_Row;
1013:
1014: -- Procedure Insert_Row

Line 1318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1314: , 'Insert_Row'
1315: );
1316: END IF;
1317:
1318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1319:
1320: END Insert_Row;
1321:
1322: -- Procedure Delete_Row

Line 1365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1361: , 'Delete_Row'
1362: );
1363: END IF;
1364:
1365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1366:
1367: END Delete_Row;
1368:
1369: -- Function Query_Row

Line 1472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1468: , 'Query_Row'
1469: );
1470: END IF;
1471:
1472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1473:
1474: END Query_Row;
1475:
1476: -- Procedure lock_Row

Line 1525: x_return_status := FND_API.G_RET_STS_ERROR;

1521: EXCEPTION
1522:
1523: WHEN NO_DATA_FOUND THEN
1524:
1525: x_return_status := FND_API.G_RET_STS_ERROR;
1526: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
1527:
1528: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1529: THEN

Line 1526: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

1522:
1523: WHEN NO_DATA_FOUND THEN
1524:
1525: x_return_status := FND_API.G_RET_STS_ERROR;
1526: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
1527:
1528: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1529: THEN
1530:

Line 1537: x_return_status := FND_API.G_RET_STS_ERROR;

1533:
1534: END IF;
1535: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1536:
1537: x_return_status := FND_API.G_RET_STS_ERROR;
1538: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
1539:
1540: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1541: THEN

Line 1538: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

1534: END IF;
1535: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1536:
1537: x_return_status := FND_API.G_RET_STS_ERROR;
1538: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
1539:
1540: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1541: THEN
1542:

Line 1549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1545:
1546: END IF;
1547: WHEN OTHERS THEN
1548:
1549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1550: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1551:
1552: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1553: THEN

Line 1550: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1546: END IF;
1547: WHEN OTHERS THEN
1548:
1549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1550: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1551:
1552: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1553: THEN
1554: OE_MSG_PUB.Add_Exc_Msg

Line 1574: p_PRICE_LIST_rec.currency_code <> FND_API.G_MISS_CHAR AND

1570: l_PRICE_LIST_val_rec OE_Price_List_PUB.Price_List_Val_Rec_Type;
1571: BEGIN
1572:
1573: IF p_PRICE_LIST_rec.currency_code IS NOT NULL AND
1574: p_PRICE_LIST_rec.currency_code <> FND_API.G_MISS_CHAR AND
1575: NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.currency_code,
1576: p_old_PRICE_LIST_rec.currency_code)
1577: THEN
1578: l_PRICE_LIST_val_rec.currency := OE_Id_To_Value.Currency

Line 1584: p_PRICE_LIST_rec.freight_terms_code <> FND_API.G_MISS_CHAR AND

1580: );
1581: END IF;
1582:
1583: IF p_PRICE_LIST_rec.freight_terms_code IS NOT NULL AND
1584: p_PRICE_LIST_rec.freight_terms_code <> FND_API.G_MISS_CHAR AND
1585: NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.freight_terms_code,
1586: p_old_PRICE_LIST_rec.freight_terms_code)
1587: THEN
1588: l_PRICE_LIST_val_rec.freight_terms := OE_Id_To_Value.Freight_Terms

Line 1597: p_PRICE_LIST_rec.price_list_id <> FND_API.G_MISS_NUM AND

1593: /* may be commented after validation in program */
1594: /* no need to do this validation :: OEXLPLHB.pls
1595:
1596: IF p_PRICE_LIST_rec.price_list_id IS NOT NULL AND
1597: p_PRICE_LIST_rec.price_list_id <> FND_API.G_MISS_NUM AND
1598: NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.price_list_id,
1599: p_old_PRICE_LIST_rec.price_list_id)
1600: THEN
1601: l_PRICE_LIST_val_rec.price_list := OE_Id_To_Value.Price_List

Line 1610: p_PRICE_LIST_rec.secondary_price_list_id <> FND_API.G_MISS_NUM AND

1606: END IF;
1607: */
1608:
1609: IF p_PRICE_LIST_rec.secondary_price_list_id IS NOT NULL AND
1610: p_PRICE_LIST_rec.secondary_price_list_id <> FND_API.G_MISS_NUM AND
1611: NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.secondary_price_list_id,
1612: p_old_PRICE_LIST_rec.secondary_price_list_id)
1613: THEN
1614: l_PRICE_LIST_val_rec.secondary_price_list := OE_Id_To_Value.Secondary_Price_List

Line 1620: p_PRICE_LIST_rec.ship_method_code <> FND_API.G_MISS_CHAR AND

1616: );
1617: END IF;
1618:
1619: IF p_PRICE_LIST_rec.ship_method_code IS NOT NULL AND
1620: p_PRICE_LIST_rec.ship_method_code <> FND_API.G_MISS_CHAR AND
1621: NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.ship_method_code,
1622: p_old_PRICE_LIST_rec.ship_method_code)
1623: THEN
1624: l_PRICE_LIST_val_rec.ship_method := OE_Id_To_Value.Ship_Method

Line 1630: p_PRICE_LIST_rec.terms_id <> FND_API.G_MISS_NUM AND

1626: );
1627: END IF;
1628:
1629: IF p_PRICE_LIST_rec.terms_id IS NOT NULL AND
1630: p_PRICE_LIST_rec.terms_id <> FND_API.G_MISS_NUM AND
1631: NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.terms_id,
1632: p_old_PRICE_LIST_rec.terms_id)
1633: THEN
1634: l_PRICE_LIST_val_rec.terms := OE_Id_To_Value.Terms

Line 1655: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1651: BEGIN
1652:
1653: -- initialize return_status.
1654:
1655: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1656:
1657: -- initialize l_PRICE_LIST_rec.
1658:
1659: l_PRICE_LIST_rec := p_PRICE_LIST_rec;

Line 1661: IF p_PRICE_LIST_val_rec.currency <> FND_API.G_MISS_CHAR

1657: -- initialize l_PRICE_LIST_rec.
1658:
1659: l_PRICE_LIST_rec := p_PRICE_LIST_rec;
1660:
1661: IF p_PRICE_LIST_val_rec.currency <> FND_API.G_MISS_CHAR
1662: THEN
1663:
1664: IF p_PRICE_LIST_rec.currency_code <> FND_API.G_MISS_CHAR THEN
1665:

Line 1664: IF p_PRICE_LIST_rec.currency_code <> FND_API.G_MISS_CHAR THEN

1660:
1661: IF p_PRICE_LIST_val_rec.currency <> FND_API.G_MISS_CHAR
1662: THEN
1663:
1664: IF p_PRICE_LIST_rec.currency_code <> FND_API.G_MISS_CHAR THEN
1665:
1666: l_PRICE_LIST_rec.currency_code := p_PRICE_LIST_rec.currency_code;
1667:
1668: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1683: IF l_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN

1679: l_PRICE_LIST_rec.currency_code := OE_Value_To_Id.currency
1680: ( p_currency => p_PRICE_LIST_val_rec.currency
1681: );
1682:
1683: IF l_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN
1684: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
1685: END IF;
1686:
1687: END IF;

Line 1684: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

1680: ( p_currency => p_PRICE_LIST_val_rec.currency
1681: );
1682:
1683: IF l_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN
1684: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
1685: END IF;
1686:
1687: END IF;
1688:

Line 1691: IF p_PRICE_LIST_val_rec.freight_terms <> FND_API.G_MISS_CHAR

1687: END IF;
1688:
1689: END IF;
1690:
1691: IF p_PRICE_LIST_val_rec.freight_terms <> FND_API.G_MISS_CHAR
1692: THEN
1693:
1694: IF p_PRICE_LIST_rec.freight_terms_code <> FND_API.G_MISS_CHAR THEN
1695:

Line 1694: IF p_PRICE_LIST_rec.freight_terms_code <> FND_API.G_MISS_CHAR THEN

1690:
1691: IF p_PRICE_LIST_val_rec.freight_terms <> FND_API.G_MISS_CHAR
1692: THEN
1693:
1694: IF p_PRICE_LIST_rec.freight_terms_code <> FND_API.G_MISS_CHAR THEN
1695:
1696: l_PRICE_LIST_rec.freight_terms_code := p_PRICE_LIST_rec.freight_terms_code;
1697:
1698: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1713: IF l_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN

1709: l_PRICE_LIST_rec.freight_terms_code := OE_Value_To_Id.freight_terms
1710: ( p_freight_terms => p_PRICE_LIST_val_rec.freight_terms
1711: );
1712:
1713: IF l_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
1714: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
1715: END IF;
1716:
1717: END IF;

Line 1714: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

1710: ( p_freight_terms => p_PRICE_LIST_val_rec.freight_terms
1711: );
1712:
1713: IF l_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
1714: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
1715: END IF;
1716:
1717: END IF;
1718:

Line 1721: IF p_PRICE_LIST_val_rec.price_list <> FND_API.G_MISS_CHAR

1717: END IF;
1718:
1719: END IF;
1720:
1721: IF p_PRICE_LIST_val_rec.price_list <> FND_API.G_MISS_CHAR
1722: THEN
1723:
1724: IF p_PRICE_LIST_rec.price_list_id <> FND_API.G_MISS_NUM THEN
1725:

Line 1724: IF p_PRICE_LIST_rec.price_list_id <> FND_API.G_MISS_NUM THEN

1720:
1721: IF p_PRICE_LIST_val_rec.price_list <> FND_API.G_MISS_CHAR
1722: THEN
1723:
1724: IF p_PRICE_LIST_rec.price_list_id <> FND_API.G_MISS_NUM THEN
1725:
1726: l_PRICE_LIST_rec.price_list_id := p_PRICE_LIST_rec.price_list_id;
1727:
1728: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1743: IF l_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM THEN

1739: l_PRICE_LIST_rec.price_list_id := OE_Value_To_Id.price_list
1740: ( p_price_list => p_PRICE_LIST_val_rec.price_list
1741: );
1742:
1743: IF l_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM THEN
1744: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
1745: END IF;
1746:
1747: END IF;

Line 1744: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

1740: ( p_price_list => p_PRICE_LIST_val_rec.price_list
1741: );
1742:
1743: IF l_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM THEN
1744: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
1745: END IF;
1746:
1747: END IF;
1748:

Line 1751: IF p_PRICE_LIST_val_rec.secondary_price_list <> FND_API.G_MISS_CHAR

1747: END IF;
1748:
1749: END IF;
1750:
1751: IF p_PRICE_LIST_val_rec.secondary_price_list <> FND_API.G_MISS_CHAR
1752: THEN
1753:
1754: IF p_PRICE_LIST_rec.secondary_price_list_id <> FND_API.G_MISS_NUM THEN
1755:

Line 1754: IF p_PRICE_LIST_rec.secondary_price_list_id <> FND_API.G_MISS_NUM THEN

1750:
1751: IF p_PRICE_LIST_val_rec.secondary_price_list <> FND_API.G_MISS_CHAR
1752: THEN
1753:
1754: IF p_PRICE_LIST_rec.secondary_price_list_id <> FND_API.G_MISS_NUM THEN
1755:
1756: l_PRICE_LIST_rec.secondary_price_list_id := p_PRICE_LIST_rec.secondary_price_list_id;
1757:
1758: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1773: IF l_PRICE_LIST_rec.secondary_price_list_id = FND_API.G_MISS_NUM THEN

1769: l_PRICE_LIST_rec.secondary_price_list_id := OE_Value_To_Id.secondary_price_list
1770: ( p_secondary_price_list => p_PRICE_LIST_val_rec.secondary_price_list
1771: );
1772:
1773: IF l_PRICE_LIST_rec.secondary_price_list_id = FND_API.G_MISS_NUM THEN
1774: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
1775: END IF;
1776:
1777: END IF;

Line 1774: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

1770: ( p_secondary_price_list => p_PRICE_LIST_val_rec.secondary_price_list
1771: );
1772:
1773: IF l_PRICE_LIST_rec.secondary_price_list_id = FND_API.G_MISS_NUM THEN
1774: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
1775: END IF;
1776:
1777: END IF;
1778:

Line 1781: IF p_PRICE_LIST_val_rec.ship_method <> FND_API.G_MISS_CHAR

1777: END IF;
1778:
1779: END IF;
1780:
1781: IF p_PRICE_LIST_val_rec.ship_method <> FND_API.G_MISS_CHAR
1782: THEN
1783:
1784: IF p_PRICE_LIST_rec.ship_method_code <> FND_API.G_MISS_CHAR THEN
1785:

Line 1784: IF p_PRICE_LIST_rec.ship_method_code <> FND_API.G_MISS_CHAR THEN

1780:
1781: IF p_PRICE_LIST_val_rec.ship_method <> FND_API.G_MISS_CHAR
1782: THEN
1783:
1784: IF p_PRICE_LIST_rec.ship_method_code <> FND_API.G_MISS_CHAR THEN
1785:
1786: l_PRICE_LIST_rec.ship_method_code := p_PRICE_LIST_rec.ship_method_code;
1787:
1788: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1803: IF l_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN

1799: l_PRICE_LIST_rec.ship_method_code := OE_Value_To_Id.ship_method
1800: ( p_ship_method => p_PRICE_LIST_val_rec.ship_method
1801: );
1802:
1803: IF l_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
1804: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
1805: END IF;
1806:
1807: END IF;

Line 1804: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

1800: ( p_ship_method => p_PRICE_LIST_val_rec.ship_method
1801: );
1802:
1803: IF l_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
1804: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
1805: END IF;
1806:
1807: END IF;
1808:

Line 1811: IF p_PRICE_LIST_val_rec.terms <> FND_API.G_MISS_CHAR

1807: END IF;
1808:
1809: END IF;
1810:
1811: IF p_PRICE_LIST_val_rec.terms <> FND_API.G_MISS_CHAR
1812: THEN
1813:
1814: IF p_PRICE_LIST_rec.terms_id <> FND_API.G_MISS_NUM THEN
1815:

Line 1814: IF p_PRICE_LIST_rec.terms_id <> FND_API.G_MISS_NUM THEN

1810:
1811: IF p_PRICE_LIST_val_rec.terms <> FND_API.G_MISS_CHAR
1812: THEN
1813:
1814: IF p_PRICE_LIST_rec.terms_id <> FND_API.G_MISS_NUM THEN
1815:
1816: l_PRICE_LIST_rec.terms_id := p_PRICE_LIST_rec.terms_id;
1817:
1818: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1833: IF l_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN

1829: l_PRICE_LIST_rec.terms_id := OE_Value_To_Id.terms
1830: ( p_terms => p_PRICE_LIST_val_rec.terms
1831: );
1832:
1833: IF l_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN
1834: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
1835: END IF;
1836:
1837: END IF;

Line 1834: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

1830: ( p_terms => p_PRICE_LIST_val_rec.terms
1831: );
1832:
1833: IF l_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN
1834: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
1835: END IF;
1836:
1837: END IF;
1838: