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_AGREEMENT_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_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
13: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
14: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
15: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type

Line 29: IF p_attr_id = FND_API.G_MISS_NUM THEN

25:
26: -- If attr_id is missing compare old and new records and for
27: -- every changed attribute clear its dependent fields.
28:
29: IF p_attr_id = FND_API.G_MISS_NUM THEN
30:
31: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.accounting_rule_id,p_old_Agreement_rec.accounting_rule_id)
32: THEN
33: NULL;

Line 397: p_Agreement_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN

393: x_Agreement_rec := p_Agreement_rec;
394:
395: -- Performance-related change
396: IF p_Agreement_rec.sold_to_org_id IS NULL OR
397: p_Agreement_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN
398: x_Agreement_rec.sold_to_org_id := -1;
399: END IF;
400:
401: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.accounting_rule_id,p_old_Agreement_rec.accounting_rule_id)

Line 659: IF l_Agreement_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN

655: BEGIN
656:
657: oe_debug_pub.add('Entering OE_Agreement_Util.Complete_Record');
658:
659: IF l_Agreement_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN
660: l_Agreement_rec.accounting_rule_id := p_old_Agreement_rec.accounting_rule_id;
661: END IF;
662:
663: IF l_Agreement_rec.agreement_contact_id = FND_API.G_MISS_NUM THEN

Line 663: IF l_Agreement_rec.agreement_contact_id = FND_API.G_MISS_NUM THEN

659: IF l_Agreement_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN
660: l_Agreement_rec.accounting_rule_id := p_old_Agreement_rec.accounting_rule_id;
661: END IF;
662:
663: IF l_Agreement_rec.agreement_contact_id = FND_API.G_MISS_NUM THEN
664: l_Agreement_rec.agreement_contact_id := p_old_Agreement_rec.agreement_contact_id;
665: END IF;
666:
667: IF l_Agreement_rec.agreement_id = FND_API.G_MISS_NUM THEN

Line 667: IF l_Agreement_rec.agreement_id = FND_API.G_MISS_NUM THEN

663: IF l_Agreement_rec.agreement_contact_id = FND_API.G_MISS_NUM THEN
664: l_Agreement_rec.agreement_contact_id := p_old_Agreement_rec.agreement_contact_id;
665: END IF;
666:
667: IF l_Agreement_rec.agreement_id = FND_API.G_MISS_NUM THEN
668: l_Agreement_rec.agreement_id := p_old_Agreement_rec.agreement_id;
669: END IF;
670:
671: IF l_Agreement_rec.agreement_num = FND_API.G_MISS_CHAR THEN

Line 671: IF l_Agreement_rec.agreement_num = FND_API.G_MISS_CHAR THEN

667: IF l_Agreement_rec.agreement_id = FND_API.G_MISS_NUM THEN
668: l_Agreement_rec.agreement_id := p_old_Agreement_rec.agreement_id;
669: END IF;
670:
671: IF l_Agreement_rec.agreement_num = FND_API.G_MISS_CHAR THEN
672: l_Agreement_rec.agreement_num := p_old_Agreement_rec.agreement_num;
673: END IF;
674:
675: IF l_Agreement_rec.agreement_type_code = FND_API.G_MISS_CHAR THEN

Line 675: IF l_Agreement_rec.agreement_type_code = FND_API.G_MISS_CHAR THEN

671: IF l_Agreement_rec.agreement_num = FND_API.G_MISS_CHAR THEN
672: l_Agreement_rec.agreement_num := p_old_Agreement_rec.agreement_num;
673: END IF;
674:
675: IF l_Agreement_rec.agreement_type_code = FND_API.G_MISS_CHAR THEN
676: l_Agreement_rec.agreement_type_code := p_old_Agreement_rec.agreement_type_code;
677: END IF;
678:
679: IF l_Agreement_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 679: IF l_Agreement_rec.attribute1 = FND_API.G_MISS_CHAR THEN

675: IF l_Agreement_rec.agreement_type_code = FND_API.G_MISS_CHAR THEN
676: l_Agreement_rec.agreement_type_code := p_old_Agreement_rec.agreement_type_code;
677: END IF;
678:
679: IF l_Agreement_rec.attribute1 = FND_API.G_MISS_CHAR THEN
680: l_Agreement_rec.attribute1 := p_old_Agreement_rec.attribute1;
681: END IF;
682:
683: IF l_Agreement_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 683: IF l_Agreement_rec.attribute10 = FND_API.G_MISS_CHAR THEN

679: IF l_Agreement_rec.attribute1 = FND_API.G_MISS_CHAR THEN
680: l_Agreement_rec.attribute1 := p_old_Agreement_rec.attribute1;
681: END IF;
682:
683: IF l_Agreement_rec.attribute10 = FND_API.G_MISS_CHAR THEN
684: l_Agreement_rec.attribute10 := p_old_Agreement_rec.attribute10;
685: END IF;
686:
687: IF l_Agreement_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 687: IF l_Agreement_rec.attribute11 = FND_API.G_MISS_CHAR THEN

683: IF l_Agreement_rec.attribute10 = FND_API.G_MISS_CHAR THEN
684: l_Agreement_rec.attribute10 := p_old_Agreement_rec.attribute10;
685: END IF;
686:
687: IF l_Agreement_rec.attribute11 = FND_API.G_MISS_CHAR THEN
688: l_Agreement_rec.attribute11 := p_old_Agreement_rec.attribute11;
689: END IF;
690:
691: IF l_Agreement_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 691: IF l_Agreement_rec.attribute12 = FND_API.G_MISS_CHAR THEN

687: IF l_Agreement_rec.attribute11 = FND_API.G_MISS_CHAR THEN
688: l_Agreement_rec.attribute11 := p_old_Agreement_rec.attribute11;
689: END IF;
690:
691: IF l_Agreement_rec.attribute12 = FND_API.G_MISS_CHAR THEN
692: l_Agreement_rec.attribute12 := p_old_Agreement_rec.attribute12;
693: END IF;
694:
695: IF l_Agreement_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 695: IF l_Agreement_rec.attribute13 = FND_API.G_MISS_CHAR THEN

691: IF l_Agreement_rec.attribute12 = FND_API.G_MISS_CHAR THEN
692: l_Agreement_rec.attribute12 := p_old_Agreement_rec.attribute12;
693: END IF;
694:
695: IF l_Agreement_rec.attribute13 = FND_API.G_MISS_CHAR THEN
696: l_Agreement_rec.attribute13 := p_old_Agreement_rec.attribute13;
697: END IF;
698:
699: IF l_Agreement_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 699: IF l_Agreement_rec.attribute14 = FND_API.G_MISS_CHAR THEN

695: IF l_Agreement_rec.attribute13 = FND_API.G_MISS_CHAR THEN
696: l_Agreement_rec.attribute13 := p_old_Agreement_rec.attribute13;
697: END IF;
698:
699: IF l_Agreement_rec.attribute14 = FND_API.G_MISS_CHAR THEN
700: l_Agreement_rec.attribute14 := p_old_Agreement_rec.attribute14;
701: END IF;
702:
703: IF l_Agreement_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 703: IF l_Agreement_rec.attribute15 = FND_API.G_MISS_CHAR THEN

699: IF l_Agreement_rec.attribute14 = FND_API.G_MISS_CHAR THEN
700: l_Agreement_rec.attribute14 := p_old_Agreement_rec.attribute14;
701: END IF;
702:
703: IF l_Agreement_rec.attribute15 = FND_API.G_MISS_CHAR THEN
704: l_Agreement_rec.attribute15 := p_old_Agreement_rec.attribute15;
705: END IF;
706:
707: IF l_Agreement_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 707: IF l_Agreement_rec.attribute2 = FND_API.G_MISS_CHAR THEN

703: IF l_Agreement_rec.attribute15 = FND_API.G_MISS_CHAR THEN
704: l_Agreement_rec.attribute15 := p_old_Agreement_rec.attribute15;
705: END IF;
706:
707: IF l_Agreement_rec.attribute2 = FND_API.G_MISS_CHAR THEN
708: l_Agreement_rec.attribute2 := p_old_Agreement_rec.attribute2;
709: END IF;
710:
711: IF l_Agreement_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 711: IF l_Agreement_rec.attribute3 = FND_API.G_MISS_CHAR THEN

707: IF l_Agreement_rec.attribute2 = FND_API.G_MISS_CHAR THEN
708: l_Agreement_rec.attribute2 := p_old_Agreement_rec.attribute2;
709: END IF;
710:
711: IF l_Agreement_rec.attribute3 = FND_API.G_MISS_CHAR THEN
712: l_Agreement_rec.attribute3 := p_old_Agreement_rec.attribute3;
713: END IF;
714:
715: IF l_Agreement_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 715: IF l_Agreement_rec.attribute4 = FND_API.G_MISS_CHAR THEN

711: IF l_Agreement_rec.attribute3 = FND_API.G_MISS_CHAR THEN
712: l_Agreement_rec.attribute3 := p_old_Agreement_rec.attribute3;
713: END IF;
714:
715: IF l_Agreement_rec.attribute4 = FND_API.G_MISS_CHAR THEN
716: l_Agreement_rec.attribute4 := p_old_Agreement_rec.attribute4;
717: END IF;
718:
719: IF l_Agreement_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 719: IF l_Agreement_rec.attribute5 = FND_API.G_MISS_CHAR THEN

715: IF l_Agreement_rec.attribute4 = FND_API.G_MISS_CHAR THEN
716: l_Agreement_rec.attribute4 := p_old_Agreement_rec.attribute4;
717: END IF;
718:
719: IF l_Agreement_rec.attribute5 = FND_API.G_MISS_CHAR THEN
720: l_Agreement_rec.attribute5 := p_old_Agreement_rec.attribute5;
721: END IF;
722:
723: IF l_Agreement_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 723: IF l_Agreement_rec.attribute6 = FND_API.G_MISS_CHAR THEN

719: IF l_Agreement_rec.attribute5 = FND_API.G_MISS_CHAR THEN
720: l_Agreement_rec.attribute5 := p_old_Agreement_rec.attribute5;
721: END IF;
722:
723: IF l_Agreement_rec.attribute6 = FND_API.G_MISS_CHAR THEN
724: l_Agreement_rec.attribute6 := p_old_Agreement_rec.attribute6;
725: END IF;
726:
727: IF l_Agreement_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 727: IF l_Agreement_rec.attribute7 = FND_API.G_MISS_CHAR THEN

723: IF l_Agreement_rec.attribute6 = FND_API.G_MISS_CHAR THEN
724: l_Agreement_rec.attribute6 := p_old_Agreement_rec.attribute6;
725: END IF;
726:
727: IF l_Agreement_rec.attribute7 = FND_API.G_MISS_CHAR THEN
728: l_Agreement_rec.attribute7 := p_old_Agreement_rec.attribute7;
729: END IF;
730:
731: IF l_Agreement_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 731: IF l_Agreement_rec.attribute8 = FND_API.G_MISS_CHAR THEN

727: IF l_Agreement_rec.attribute7 = FND_API.G_MISS_CHAR THEN
728: l_Agreement_rec.attribute7 := p_old_Agreement_rec.attribute7;
729: END IF;
730:
731: IF l_Agreement_rec.attribute8 = FND_API.G_MISS_CHAR THEN
732: l_Agreement_rec.attribute8 := p_old_Agreement_rec.attribute8;
733: END IF;
734:
735: IF l_Agreement_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 735: IF l_Agreement_rec.attribute9 = FND_API.G_MISS_CHAR THEN

731: IF l_Agreement_rec.attribute8 = FND_API.G_MISS_CHAR THEN
732: l_Agreement_rec.attribute8 := p_old_Agreement_rec.attribute8;
733: END IF;
734:
735: IF l_Agreement_rec.attribute9 = FND_API.G_MISS_CHAR THEN
736: l_Agreement_rec.attribute9 := p_old_Agreement_rec.attribute9;
737: END IF;
738:
739: IF l_Agreement_rec.context = FND_API.G_MISS_CHAR THEN

Line 739: IF l_Agreement_rec.context = FND_API.G_MISS_CHAR THEN

735: IF l_Agreement_rec.attribute9 = FND_API.G_MISS_CHAR THEN
736: l_Agreement_rec.attribute9 := p_old_Agreement_rec.attribute9;
737: END IF;
738:
739: IF l_Agreement_rec.context = FND_API.G_MISS_CHAR THEN
740: l_Agreement_rec.context := p_old_Agreement_rec.context;
741: END IF;
742:
743: IF l_Agreement_rec.created_by = FND_API.G_MISS_NUM THEN

Line 743: IF l_Agreement_rec.created_by = FND_API.G_MISS_NUM THEN

739: IF l_Agreement_rec.context = FND_API.G_MISS_CHAR THEN
740: l_Agreement_rec.context := p_old_Agreement_rec.context;
741: END IF;
742:
743: IF l_Agreement_rec.created_by = FND_API.G_MISS_NUM THEN
744: l_Agreement_rec.created_by := p_old_Agreement_rec.created_by;
745: END IF;
746:
747: IF l_Agreement_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 747: IF l_Agreement_rec.creation_date = FND_API.G_MISS_DATE THEN

743: IF l_Agreement_rec.created_by = FND_API.G_MISS_NUM THEN
744: l_Agreement_rec.created_by := p_old_Agreement_rec.created_by;
745: END IF;
746:
747: IF l_Agreement_rec.creation_date = FND_API.G_MISS_DATE THEN
748: l_Agreement_rec.creation_date := p_old_Agreement_rec.creation_date;
749: END IF;
750:
751: IF l_Agreement_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN

Line 751: IF l_Agreement_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN

747: IF l_Agreement_rec.creation_date = FND_API.G_MISS_DATE THEN
748: l_Agreement_rec.creation_date := p_old_Agreement_rec.creation_date;
749: END IF;
750:
751: IF l_Agreement_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN
752: l_Agreement_rec.sold_to_org_id := p_old_Agreement_rec.sold_to_org_id;
753: END IF;
754:
755: IF l_Agreement_rec.end_date_active = FND_API.G_MISS_DATE THEN

Line 755: IF l_Agreement_rec.end_date_active = FND_API.G_MISS_DATE THEN

751: IF l_Agreement_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN
752: l_Agreement_rec.sold_to_org_id := p_old_Agreement_rec.sold_to_org_id;
753: END IF;
754:
755: IF l_Agreement_rec.end_date_active = FND_API.G_MISS_DATE THEN
756: l_Agreement_rec.end_date_active := p_old_Agreement_rec.end_date_active;
757: END IF;
758:
759: IF l_Agreement_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN

Line 759: IF l_Agreement_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN

755: IF l_Agreement_rec.end_date_active = FND_API.G_MISS_DATE THEN
756: l_Agreement_rec.end_date_active := p_old_Agreement_rec.end_date_active;
757: END IF;
758:
759: IF l_Agreement_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
760: l_Agreement_rec.freight_terms_code := p_old_Agreement_rec.freight_terms_code;
761: END IF;
762:
763: IF l_Agreement_rec.invoice_contact_id = FND_API.G_MISS_NUM THEN

Line 763: IF l_Agreement_rec.invoice_contact_id = FND_API.G_MISS_NUM THEN

759: IF l_Agreement_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
760: l_Agreement_rec.freight_terms_code := p_old_Agreement_rec.freight_terms_code;
761: END IF;
762:
763: IF l_Agreement_rec.invoice_contact_id = FND_API.G_MISS_NUM THEN
764: l_Agreement_rec.invoice_contact_id := p_old_Agreement_rec.invoice_contact_id;
765: END IF;
766:
767: IF l_Agreement_rec.invoice_to_org_id = FND_API.G_MISS_NUM THEN

Line 767: IF l_Agreement_rec.invoice_to_org_id = FND_API.G_MISS_NUM THEN

763: IF l_Agreement_rec.invoice_contact_id = FND_API.G_MISS_NUM THEN
764: l_Agreement_rec.invoice_contact_id := p_old_Agreement_rec.invoice_contact_id;
765: END IF;
766:
767: IF l_Agreement_rec.invoice_to_org_id = FND_API.G_MISS_NUM THEN
768: l_Agreement_rec.invoice_to_org_id := p_old_Agreement_rec.invoice_to_org_id;
769: END IF;
770:
771: IF l_Agreement_rec.invoicing_rule_id = FND_API.G_MISS_NUM THEN

Line 771: IF l_Agreement_rec.invoicing_rule_id = FND_API.G_MISS_NUM THEN

767: IF l_Agreement_rec.invoice_to_org_id = FND_API.G_MISS_NUM THEN
768: l_Agreement_rec.invoice_to_org_id := p_old_Agreement_rec.invoice_to_org_id;
769: END IF;
770:
771: IF l_Agreement_rec.invoicing_rule_id = FND_API.G_MISS_NUM THEN
772: l_Agreement_rec.invoicing_rule_id := p_old_Agreement_rec.invoicing_rule_id;
773: END IF;
774:
775: IF l_Agreement_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 775: IF l_Agreement_rec.last_updated_by = FND_API.G_MISS_NUM THEN

771: IF l_Agreement_rec.invoicing_rule_id = FND_API.G_MISS_NUM THEN
772: l_Agreement_rec.invoicing_rule_id := p_old_Agreement_rec.invoicing_rule_id;
773: END IF;
774:
775: IF l_Agreement_rec.last_updated_by = FND_API.G_MISS_NUM THEN
776: l_Agreement_rec.last_updated_by := p_old_Agreement_rec.last_updated_by;
777: END IF;
778:
779: IF l_Agreement_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 779: IF l_Agreement_rec.last_update_date = FND_API.G_MISS_DATE THEN

775: IF l_Agreement_rec.last_updated_by = FND_API.G_MISS_NUM THEN
776: l_Agreement_rec.last_updated_by := p_old_Agreement_rec.last_updated_by;
777: END IF;
778:
779: IF l_Agreement_rec.last_update_date = FND_API.G_MISS_DATE THEN
780: l_Agreement_rec.last_update_date := p_old_Agreement_rec.last_update_date;
781: END IF;
782:
783: IF l_Agreement_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 783: IF l_Agreement_rec.last_update_login = FND_API.G_MISS_NUM THEN

779: IF l_Agreement_rec.last_update_date = FND_API.G_MISS_DATE THEN
780: l_Agreement_rec.last_update_date := p_old_Agreement_rec.last_update_date;
781: END IF;
782:
783: IF l_Agreement_rec.last_update_login = FND_API.G_MISS_NUM THEN
784: l_Agreement_rec.last_update_login := p_old_Agreement_rec.last_update_login;
785: END IF;
786:
787: IF l_Agreement_rec.name = FND_API.G_MISS_CHAR THEN

Line 787: IF l_Agreement_rec.name = FND_API.G_MISS_CHAR THEN

783: IF l_Agreement_rec.last_update_login = FND_API.G_MISS_NUM THEN
784: l_Agreement_rec.last_update_login := p_old_Agreement_rec.last_update_login;
785: END IF;
786:
787: IF l_Agreement_rec.name = FND_API.G_MISS_CHAR THEN
788: l_Agreement_rec.name := p_old_Agreement_rec.name;
789: END IF;
790:
791: IF l_Agreement_rec.override_arule_flag = FND_API.G_MISS_CHAR THEN

Line 791: IF l_Agreement_rec.override_arule_flag = FND_API.G_MISS_CHAR THEN

787: IF l_Agreement_rec.name = FND_API.G_MISS_CHAR THEN
788: l_Agreement_rec.name := p_old_Agreement_rec.name;
789: END IF;
790:
791: IF l_Agreement_rec.override_arule_flag = FND_API.G_MISS_CHAR THEN
792: l_Agreement_rec.override_arule_flag := p_old_Agreement_rec.override_arule_flag;
793: END IF;
794:
795: IF l_Agreement_rec.override_irule_flag = FND_API.G_MISS_CHAR THEN

Line 795: IF l_Agreement_rec.override_irule_flag = FND_API.G_MISS_CHAR THEN

791: IF l_Agreement_rec.override_arule_flag = FND_API.G_MISS_CHAR THEN
792: l_Agreement_rec.override_arule_flag := p_old_Agreement_rec.override_arule_flag;
793: END IF;
794:
795: IF l_Agreement_rec.override_irule_flag = FND_API.G_MISS_CHAR THEN
796: l_Agreement_rec.override_irule_flag := p_old_Agreement_rec.override_irule_flag;
797: END IF;
798:
799: IF l_Agreement_rec.price_list_id = FND_API.G_MISS_NUM THEN

Line 799: IF l_Agreement_rec.price_list_id = FND_API.G_MISS_NUM THEN

795: IF l_Agreement_rec.override_irule_flag = FND_API.G_MISS_CHAR THEN
796: l_Agreement_rec.override_irule_flag := p_old_Agreement_rec.override_irule_flag;
797: END IF;
798:
799: IF l_Agreement_rec.price_list_id = FND_API.G_MISS_NUM THEN
800: l_Agreement_rec.price_list_id := p_old_Agreement_rec.price_list_id;
801: END IF;
802:
803: IF l_Agreement_rec.purchase_order_num = FND_API.G_MISS_CHAR THEN

Line 803: IF l_Agreement_rec.purchase_order_num = FND_API.G_MISS_CHAR THEN

799: IF l_Agreement_rec.price_list_id = FND_API.G_MISS_NUM THEN
800: l_Agreement_rec.price_list_id := p_old_Agreement_rec.price_list_id;
801: END IF;
802:
803: IF l_Agreement_rec.purchase_order_num = FND_API.G_MISS_CHAR THEN
804: l_Agreement_rec.purchase_order_num := p_old_Agreement_rec.purchase_order_num;
805: END IF;
806:
807: IF l_Agreement_rec.revision = FND_API.G_MISS_CHAR THEN

Line 807: IF l_Agreement_rec.revision = FND_API.G_MISS_CHAR THEN

803: IF l_Agreement_rec.purchase_order_num = FND_API.G_MISS_CHAR THEN
804: l_Agreement_rec.purchase_order_num := p_old_Agreement_rec.purchase_order_num;
805: END IF;
806:
807: IF l_Agreement_rec.revision = FND_API.G_MISS_CHAR THEN
808: l_Agreement_rec.revision := p_old_Agreement_rec.revision;
809: END IF;
810:
811: IF l_Agreement_rec.revision_date = FND_API.G_MISS_DATE THEN

Line 811: IF l_Agreement_rec.revision_date = FND_API.G_MISS_DATE THEN

807: IF l_Agreement_rec.revision = FND_API.G_MISS_CHAR THEN
808: l_Agreement_rec.revision := p_old_Agreement_rec.revision;
809: END IF;
810:
811: IF l_Agreement_rec.revision_date = FND_API.G_MISS_DATE THEN
812: l_Agreement_rec.revision_date := p_old_Agreement_rec.revision_date;
813: END IF;
814:
815: IF l_Agreement_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN

Line 815: IF l_Agreement_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN

811: IF l_Agreement_rec.revision_date = FND_API.G_MISS_DATE THEN
812: l_Agreement_rec.revision_date := p_old_Agreement_rec.revision_date;
813: END IF;
814:
815: IF l_Agreement_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
816: l_Agreement_rec.revision_reason_code := p_old_Agreement_rec.revision_reason_code;
817: END IF;
818:
819: IF l_Agreement_rec.salesrep_id = FND_API.G_MISS_NUM THEN

Line 819: IF l_Agreement_rec.salesrep_id = FND_API.G_MISS_NUM THEN

815: IF l_Agreement_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
816: l_Agreement_rec.revision_reason_code := p_old_Agreement_rec.revision_reason_code;
817: END IF;
818:
819: IF l_Agreement_rec.salesrep_id = FND_API.G_MISS_NUM THEN
820: l_Agreement_rec.salesrep_id := p_old_Agreement_rec.salesrep_id;
821: END IF;
822:
823: IF l_Agreement_rec.ship_method_code = FND_API.G_MISS_CHAR THEN

Line 823: IF l_Agreement_rec.ship_method_code = FND_API.G_MISS_CHAR THEN

819: IF l_Agreement_rec.salesrep_id = FND_API.G_MISS_NUM THEN
820: l_Agreement_rec.salesrep_id := p_old_Agreement_rec.salesrep_id;
821: END IF;
822:
823: IF l_Agreement_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
824: l_Agreement_rec.ship_method_code := p_old_Agreement_rec.ship_method_code;
825: END IF;
826:
827: IF l_Agreement_rec.signature_date = FND_API.G_MISS_DATE THEN

Line 827: IF l_Agreement_rec.signature_date = FND_API.G_MISS_DATE THEN

823: IF l_Agreement_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
824: l_Agreement_rec.ship_method_code := p_old_Agreement_rec.ship_method_code;
825: END IF;
826:
827: IF l_Agreement_rec.signature_date = FND_API.G_MISS_DATE THEN
828: l_Agreement_rec.signature_date := p_old_Agreement_rec.signature_date;
829: END IF;
830:
831: IF l_Agreement_rec.start_date_active = FND_API.G_MISS_DATE THEN

Line 831: IF l_Agreement_rec.start_date_active = FND_API.G_MISS_DATE THEN

827: IF l_Agreement_rec.signature_date = FND_API.G_MISS_DATE THEN
828: l_Agreement_rec.signature_date := p_old_Agreement_rec.signature_date;
829: END IF;
830:
831: IF l_Agreement_rec.start_date_active = FND_API.G_MISS_DATE THEN
832: l_Agreement_rec.start_date_active := p_old_Agreement_rec.start_date_active;
833: END IF;
834:
835: IF l_Agreement_rec.term_id = FND_API.G_MISS_NUM THEN

Line 835: IF l_Agreement_rec.term_id = FND_API.G_MISS_NUM THEN

831: IF l_Agreement_rec.start_date_active = FND_API.G_MISS_DATE THEN
832: l_Agreement_rec.start_date_active := p_old_Agreement_rec.start_date_active;
833: END IF;
834:
835: IF l_Agreement_rec.term_id = FND_API.G_MISS_NUM THEN
836: l_Agreement_rec.term_id := p_old_Agreement_rec.term_id;
837: END IF;
838:
839: --Begin code added by rchellam for OKC

Line 840: IF l_Agreement_rec.agreement_source_code = FND_API.G_MISS_CHAR THEN

836: l_Agreement_rec.term_id := p_old_Agreement_rec.term_id;
837: END IF;
838:
839: --Begin code added by rchellam for OKC
840: IF l_Agreement_rec.agreement_source_code = FND_API.G_MISS_CHAR THEN
841: l_Agreement_rec.agreement_source_code := p_old_Agreement_rec.agreement_source_code;
842: END IF;
843:
844: IF l_Agreement_rec.orig_system_agr_id = FND_API.G_MISS_NUM THEN

Line 844: IF l_Agreement_rec.orig_system_agr_id = FND_API.G_MISS_NUM THEN

840: IF l_Agreement_rec.agreement_source_code = FND_API.G_MISS_CHAR THEN
841: l_Agreement_rec.agreement_source_code := p_old_Agreement_rec.agreement_source_code;
842: END IF;
843:
844: IF l_Agreement_rec.orig_system_agr_id = FND_API.G_MISS_NUM THEN
845: l_Agreement_rec.orig_system_agr_id := p_old_Agreement_rec.orig_system_agr_id;
846: END IF;
847: --End code added by rchellam for OKC
848:

Line 850: IF l_Agreement_rec.invoice_to_customer_id = FND_API.G_MISS_NUM THEN

846: END IF;
847: --End code added by rchellam for OKC
848:
849: -- Added for bug#4029589
850: IF l_Agreement_rec.invoice_to_customer_id = FND_API.G_MISS_NUM THEN
851: l_Agreement_rec.invoice_to_customer_id := p_old_Agreement_rec.invoice_to_customer_id;
852: END IF;
853:
854: oe_debug_pub.add('Exiting OE_Agreement_Util.Complete_Record');

Line 871: IF l_Agreement_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN

867: BEGIN
868:
869: oe_debug_pub.add('Entering OE_Agreement_Util.Convert_Miss_To_Null');
870:
871: IF l_Agreement_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN
872: l_Agreement_rec.accounting_rule_id := NULL;
873: END IF;
874:
875: IF l_Agreement_rec.agreement_contact_id = FND_API.G_MISS_NUM THEN

Line 875: IF l_Agreement_rec.agreement_contact_id = FND_API.G_MISS_NUM THEN

871: IF l_Agreement_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN
872: l_Agreement_rec.accounting_rule_id := NULL;
873: END IF;
874:
875: IF l_Agreement_rec.agreement_contact_id = FND_API.G_MISS_NUM THEN
876: l_Agreement_rec.agreement_contact_id := NULL;
877: END IF;
878:
879: IF l_Agreement_rec.agreement_id = FND_API.G_MISS_NUM THEN

Line 879: IF l_Agreement_rec.agreement_id = FND_API.G_MISS_NUM THEN

875: IF l_Agreement_rec.agreement_contact_id = FND_API.G_MISS_NUM THEN
876: l_Agreement_rec.agreement_contact_id := NULL;
877: END IF;
878:
879: IF l_Agreement_rec.agreement_id = FND_API.G_MISS_NUM THEN
880: l_Agreement_rec.agreement_id := NULL;
881: END IF;
882:
883: IF l_Agreement_rec.agreement_num = FND_API.G_MISS_CHAR THEN

Line 883: IF l_Agreement_rec.agreement_num = FND_API.G_MISS_CHAR THEN

879: IF l_Agreement_rec.agreement_id = FND_API.G_MISS_NUM THEN
880: l_Agreement_rec.agreement_id := NULL;
881: END IF;
882:
883: IF l_Agreement_rec.agreement_num = FND_API.G_MISS_CHAR THEN
884: l_Agreement_rec.agreement_num := NULL;
885: END IF;
886:
887: IF l_Agreement_rec.agreement_type_code = FND_API.G_MISS_CHAR THEN

Line 887: IF l_Agreement_rec.agreement_type_code = FND_API.G_MISS_CHAR THEN

883: IF l_Agreement_rec.agreement_num = FND_API.G_MISS_CHAR THEN
884: l_Agreement_rec.agreement_num := NULL;
885: END IF;
886:
887: IF l_Agreement_rec.agreement_type_code = FND_API.G_MISS_CHAR THEN
888: l_Agreement_rec.agreement_type_code := NULL;
889: END IF;
890:
891: IF l_Agreement_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 891: IF l_Agreement_rec.attribute1 = FND_API.G_MISS_CHAR THEN

887: IF l_Agreement_rec.agreement_type_code = FND_API.G_MISS_CHAR THEN
888: l_Agreement_rec.agreement_type_code := NULL;
889: END IF;
890:
891: IF l_Agreement_rec.attribute1 = FND_API.G_MISS_CHAR THEN
892: l_Agreement_rec.attribute1 := NULL;
893: END IF;
894:
895: IF l_Agreement_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 895: IF l_Agreement_rec.attribute10 = FND_API.G_MISS_CHAR THEN

891: IF l_Agreement_rec.attribute1 = FND_API.G_MISS_CHAR THEN
892: l_Agreement_rec.attribute1 := NULL;
893: END IF;
894:
895: IF l_Agreement_rec.attribute10 = FND_API.G_MISS_CHAR THEN
896: l_Agreement_rec.attribute10 := NULL;
897: END IF;
898:
899: IF l_Agreement_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 899: IF l_Agreement_rec.attribute11 = FND_API.G_MISS_CHAR THEN

895: IF l_Agreement_rec.attribute10 = FND_API.G_MISS_CHAR THEN
896: l_Agreement_rec.attribute10 := NULL;
897: END IF;
898:
899: IF l_Agreement_rec.attribute11 = FND_API.G_MISS_CHAR THEN
900: l_Agreement_rec.attribute11 := NULL;
901: END IF;
902:
903: IF l_Agreement_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 903: IF l_Agreement_rec.attribute12 = FND_API.G_MISS_CHAR THEN

899: IF l_Agreement_rec.attribute11 = FND_API.G_MISS_CHAR THEN
900: l_Agreement_rec.attribute11 := NULL;
901: END IF;
902:
903: IF l_Agreement_rec.attribute12 = FND_API.G_MISS_CHAR THEN
904: l_Agreement_rec.attribute12 := NULL;
905: END IF;
906:
907: IF l_Agreement_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 907: IF l_Agreement_rec.attribute13 = FND_API.G_MISS_CHAR THEN

903: IF l_Agreement_rec.attribute12 = FND_API.G_MISS_CHAR THEN
904: l_Agreement_rec.attribute12 := NULL;
905: END IF;
906:
907: IF l_Agreement_rec.attribute13 = FND_API.G_MISS_CHAR THEN
908: l_Agreement_rec.attribute13 := NULL;
909: END IF;
910:
911: IF l_Agreement_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 911: IF l_Agreement_rec.attribute14 = FND_API.G_MISS_CHAR THEN

907: IF l_Agreement_rec.attribute13 = FND_API.G_MISS_CHAR THEN
908: l_Agreement_rec.attribute13 := NULL;
909: END IF;
910:
911: IF l_Agreement_rec.attribute14 = FND_API.G_MISS_CHAR THEN
912: l_Agreement_rec.attribute14 := NULL;
913: END IF;
914:
915: IF l_Agreement_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 915: IF l_Agreement_rec.attribute15 = FND_API.G_MISS_CHAR THEN

911: IF l_Agreement_rec.attribute14 = FND_API.G_MISS_CHAR THEN
912: l_Agreement_rec.attribute14 := NULL;
913: END IF;
914:
915: IF l_Agreement_rec.attribute15 = FND_API.G_MISS_CHAR THEN
916: l_Agreement_rec.attribute15 := NULL;
917: END IF;
918:
919: IF l_Agreement_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 919: IF l_Agreement_rec.attribute2 = FND_API.G_MISS_CHAR THEN

915: IF l_Agreement_rec.attribute15 = FND_API.G_MISS_CHAR THEN
916: l_Agreement_rec.attribute15 := NULL;
917: END IF;
918:
919: IF l_Agreement_rec.attribute2 = FND_API.G_MISS_CHAR THEN
920: l_Agreement_rec.attribute2 := NULL;
921: END IF;
922:
923: IF l_Agreement_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 923: IF l_Agreement_rec.attribute3 = FND_API.G_MISS_CHAR THEN

919: IF l_Agreement_rec.attribute2 = FND_API.G_MISS_CHAR THEN
920: l_Agreement_rec.attribute2 := NULL;
921: END IF;
922:
923: IF l_Agreement_rec.attribute3 = FND_API.G_MISS_CHAR THEN
924: l_Agreement_rec.attribute3 := NULL;
925: END IF;
926:
927: IF l_Agreement_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 927: IF l_Agreement_rec.attribute4 = FND_API.G_MISS_CHAR THEN

923: IF l_Agreement_rec.attribute3 = FND_API.G_MISS_CHAR THEN
924: l_Agreement_rec.attribute3 := NULL;
925: END IF;
926:
927: IF l_Agreement_rec.attribute4 = FND_API.G_MISS_CHAR THEN
928: l_Agreement_rec.attribute4 := NULL;
929: END IF;
930:
931: IF l_Agreement_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 931: IF l_Agreement_rec.attribute5 = FND_API.G_MISS_CHAR THEN

927: IF l_Agreement_rec.attribute4 = FND_API.G_MISS_CHAR THEN
928: l_Agreement_rec.attribute4 := NULL;
929: END IF;
930:
931: IF l_Agreement_rec.attribute5 = FND_API.G_MISS_CHAR THEN
932: l_Agreement_rec.attribute5 := NULL;
933: END IF;
934:
935: IF l_Agreement_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 935: IF l_Agreement_rec.attribute6 = FND_API.G_MISS_CHAR THEN

931: IF l_Agreement_rec.attribute5 = FND_API.G_MISS_CHAR THEN
932: l_Agreement_rec.attribute5 := NULL;
933: END IF;
934:
935: IF l_Agreement_rec.attribute6 = FND_API.G_MISS_CHAR THEN
936: l_Agreement_rec.attribute6 := NULL;
937: END IF;
938:
939: IF l_Agreement_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 939: IF l_Agreement_rec.attribute7 = FND_API.G_MISS_CHAR THEN

935: IF l_Agreement_rec.attribute6 = FND_API.G_MISS_CHAR THEN
936: l_Agreement_rec.attribute6 := NULL;
937: END IF;
938:
939: IF l_Agreement_rec.attribute7 = FND_API.G_MISS_CHAR THEN
940: l_Agreement_rec.attribute7 := NULL;
941: END IF;
942:
943: IF l_Agreement_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 943: IF l_Agreement_rec.attribute8 = FND_API.G_MISS_CHAR THEN

939: IF l_Agreement_rec.attribute7 = FND_API.G_MISS_CHAR THEN
940: l_Agreement_rec.attribute7 := NULL;
941: END IF;
942:
943: IF l_Agreement_rec.attribute8 = FND_API.G_MISS_CHAR THEN
944: l_Agreement_rec.attribute8 := NULL;
945: END IF;
946:
947: IF l_Agreement_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 947: IF l_Agreement_rec.attribute9 = FND_API.G_MISS_CHAR THEN

943: IF l_Agreement_rec.attribute8 = FND_API.G_MISS_CHAR THEN
944: l_Agreement_rec.attribute8 := NULL;
945: END IF;
946:
947: IF l_Agreement_rec.attribute9 = FND_API.G_MISS_CHAR THEN
948: l_Agreement_rec.attribute9 := NULL;
949: END IF;
950:
951: IF l_Agreement_rec.context = FND_API.G_MISS_CHAR THEN

Line 951: IF l_Agreement_rec.context = FND_API.G_MISS_CHAR THEN

947: IF l_Agreement_rec.attribute9 = FND_API.G_MISS_CHAR THEN
948: l_Agreement_rec.attribute9 := NULL;
949: END IF;
950:
951: IF l_Agreement_rec.context = FND_API.G_MISS_CHAR THEN
952: l_Agreement_rec.context := NULL;
953: END IF;
954:
955: IF l_Agreement_rec.created_by = FND_API.G_MISS_NUM THEN

Line 955: IF l_Agreement_rec.created_by = FND_API.G_MISS_NUM THEN

951: IF l_Agreement_rec.context = FND_API.G_MISS_CHAR THEN
952: l_Agreement_rec.context := NULL;
953: END IF;
954:
955: IF l_Agreement_rec.created_by = FND_API.G_MISS_NUM THEN
956: l_Agreement_rec.created_by := NULL;
957: END IF;
958:
959: IF l_Agreement_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 959: IF l_Agreement_rec.creation_date = FND_API.G_MISS_DATE THEN

955: IF l_Agreement_rec.created_by = FND_API.G_MISS_NUM THEN
956: l_Agreement_rec.created_by := NULL;
957: END IF;
958:
959: IF l_Agreement_rec.creation_date = FND_API.G_MISS_DATE THEN
960: l_Agreement_rec.creation_date := NULL;
961: END IF;
962:
963: IF l_Agreement_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN

Line 963: IF l_Agreement_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN

959: IF l_Agreement_rec.creation_date = FND_API.G_MISS_DATE THEN
960: l_Agreement_rec.creation_date := NULL;
961: END IF;
962:
963: IF l_Agreement_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN
964: l_Agreement_rec.sold_to_org_id := NULL;
965: END IF;
966:
967: IF l_Agreement_rec.end_date_active = FND_API.G_MISS_DATE THEN

Line 967: IF l_Agreement_rec.end_date_active = FND_API.G_MISS_DATE THEN

963: IF l_Agreement_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN
964: l_Agreement_rec.sold_to_org_id := NULL;
965: END IF;
966:
967: IF l_Agreement_rec.end_date_active = FND_API.G_MISS_DATE THEN
968: l_Agreement_rec.end_date_active := NULL;
969: END IF;
970:
971: IF l_Agreement_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN

Line 971: IF l_Agreement_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN

967: IF l_Agreement_rec.end_date_active = FND_API.G_MISS_DATE THEN
968: l_Agreement_rec.end_date_active := NULL;
969: END IF;
970:
971: IF l_Agreement_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
972: l_Agreement_rec.freight_terms_code := NULL;
973: END IF;
974:
975: IF l_Agreement_rec.invoice_contact_id = FND_API.G_MISS_NUM THEN

Line 975: IF l_Agreement_rec.invoice_contact_id = FND_API.G_MISS_NUM THEN

971: IF l_Agreement_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
972: l_Agreement_rec.freight_terms_code := NULL;
973: END IF;
974:
975: IF l_Agreement_rec.invoice_contact_id = FND_API.G_MISS_NUM THEN
976: l_Agreement_rec.invoice_contact_id := NULL;
977: END IF;
978:
979: IF l_Agreement_rec.invoice_to_org_id = FND_API.G_MISS_NUM THEN

Line 979: IF l_Agreement_rec.invoice_to_org_id = FND_API.G_MISS_NUM THEN

975: IF l_Agreement_rec.invoice_contact_id = FND_API.G_MISS_NUM THEN
976: l_Agreement_rec.invoice_contact_id := NULL;
977: END IF;
978:
979: IF l_Agreement_rec.invoice_to_org_id = FND_API.G_MISS_NUM THEN
980: l_Agreement_rec.invoice_to_org_id := NULL;
981: END IF;
982:
983: IF l_Agreement_rec.invoicing_rule_id = FND_API.G_MISS_NUM THEN

Line 983: IF l_Agreement_rec.invoicing_rule_id = FND_API.G_MISS_NUM THEN

979: IF l_Agreement_rec.invoice_to_org_id = FND_API.G_MISS_NUM THEN
980: l_Agreement_rec.invoice_to_org_id := NULL;
981: END IF;
982:
983: IF l_Agreement_rec.invoicing_rule_id = FND_API.G_MISS_NUM THEN
984: l_Agreement_rec.invoicing_rule_id := NULL;
985: END IF;
986:
987: IF l_Agreement_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 987: IF l_Agreement_rec.last_updated_by = FND_API.G_MISS_NUM THEN

983: IF l_Agreement_rec.invoicing_rule_id = FND_API.G_MISS_NUM THEN
984: l_Agreement_rec.invoicing_rule_id := NULL;
985: END IF;
986:
987: IF l_Agreement_rec.last_updated_by = FND_API.G_MISS_NUM THEN
988: l_Agreement_rec.last_updated_by := NULL;
989: END IF;
990:
991: IF l_Agreement_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 991: IF l_Agreement_rec.last_update_date = FND_API.G_MISS_DATE THEN

987: IF l_Agreement_rec.last_updated_by = FND_API.G_MISS_NUM THEN
988: l_Agreement_rec.last_updated_by := NULL;
989: END IF;
990:
991: IF l_Agreement_rec.last_update_date = FND_API.G_MISS_DATE THEN
992: l_Agreement_rec.last_update_date := NULL;
993: END IF;
994:
995: IF l_Agreement_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 995: IF l_Agreement_rec.last_update_login = FND_API.G_MISS_NUM THEN

991: IF l_Agreement_rec.last_update_date = FND_API.G_MISS_DATE THEN
992: l_Agreement_rec.last_update_date := NULL;
993: END IF;
994:
995: IF l_Agreement_rec.last_update_login = FND_API.G_MISS_NUM THEN
996: l_Agreement_rec.last_update_login := NULL;
997: END IF;
998:
999: IF l_Agreement_rec.name = FND_API.G_MISS_CHAR THEN

Line 999: IF l_Agreement_rec.name = FND_API.G_MISS_CHAR THEN

995: IF l_Agreement_rec.last_update_login = FND_API.G_MISS_NUM THEN
996: l_Agreement_rec.last_update_login := NULL;
997: END IF;
998:
999: IF l_Agreement_rec.name = FND_API.G_MISS_CHAR THEN
1000: l_Agreement_rec.name := NULL;
1001: END IF;
1002:
1003: IF l_Agreement_rec.override_arule_flag = FND_API.G_MISS_CHAR THEN

Line 1003: IF l_Agreement_rec.override_arule_flag = FND_API.G_MISS_CHAR THEN

999: IF l_Agreement_rec.name = FND_API.G_MISS_CHAR THEN
1000: l_Agreement_rec.name := NULL;
1001: END IF;
1002:
1003: IF l_Agreement_rec.override_arule_flag = FND_API.G_MISS_CHAR THEN
1004: l_Agreement_rec.override_arule_flag := NULL;
1005: END IF;
1006:
1007: IF l_Agreement_rec.override_irule_flag = FND_API.G_MISS_CHAR THEN

Line 1007: IF l_Agreement_rec.override_irule_flag = FND_API.G_MISS_CHAR THEN

1003: IF l_Agreement_rec.override_arule_flag = FND_API.G_MISS_CHAR THEN
1004: l_Agreement_rec.override_arule_flag := NULL;
1005: END IF;
1006:
1007: IF l_Agreement_rec.override_irule_flag = FND_API.G_MISS_CHAR THEN
1008: l_Agreement_rec.override_irule_flag := NULL;
1009: END IF;
1010:
1011: IF l_Agreement_rec.price_list_id = FND_API.G_MISS_NUM THEN

Line 1011: IF l_Agreement_rec.price_list_id = FND_API.G_MISS_NUM THEN

1007: IF l_Agreement_rec.override_irule_flag = FND_API.G_MISS_CHAR THEN
1008: l_Agreement_rec.override_irule_flag := NULL;
1009: END IF;
1010:
1011: IF l_Agreement_rec.price_list_id = FND_API.G_MISS_NUM THEN
1012: l_Agreement_rec.price_list_id := NULL;
1013: END IF;
1014:
1015: IF l_Agreement_rec.purchase_order_num = FND_API.G_MISS_CHAR THEN

Line 1015: IF l_Agreement_rec.purchase_order_num = FND_API.G_MISS_CHAR THEN

1011: IF l_Agreement_rec.price_list_id = FND_API.G_MISS_NUM THEN
1012: l_Agreement_rec.price_list_id := NULL;
1013: END IF;
1014:
1015: IF l_Agreement_rec.purchase_order_num = FND_API.G_MISS_CHAR THEN
1016: l_Agreement_rec.purchase_order_num := NULL;
1017: END IF;
1018:
1019: IF l_Agreement_rec.revision = FND_API.G_MISS_CHAR THEN

Line 1019: IF l_Agreement_rec.revision = FND_API.G_MISS_CHAR THEN

1015: IF l_Agreement_rec.purchase_order_num = FND_API.G_MISS_CHAR THEN
1016: l_Agreement_rec.purchase_order_num := NULL;
1017: END IF;
1018:
1019: IF l_Agreement_rec.revision = FND_API.G_MISS_CHAR THEN
1020: l_Agreement_rec.revision := NULL;
1021: END IF;
1022:
1023: IF l_Agreement_rec.revision_date = FND_API.G_MISS_DATE THEN

Line 1023: IF l_Agreement_rec.revision_date = FND_API.G_MISS_DATE THEN

1019: IF l_Agreement_rec.revision = FND_API.G_MISS_CHAR THEN
1020: l_Agreement_rec.revision := NULL;
1021: END IF;
1022:
1023: IF l_Agreement_rec.revision_date = FND_API.G_MISS_DATE THEN
1024: l_Agreement_rec.revision_date := NULL;
1025: END IF;
1026:
1027: IF l_Agreement_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN

Line 1027: IF l_Agreement_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN

1023: IF l_Agreement_rec.revision_date = FND_API.G_MISS_DATE THEN
1024: l_Agreement_rec.revision_date := NULL;
1025: END IF;
1026:
1027: IF l_Agreement_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
1028: l_Agreement_rec.revision_reason_code := NULL;
1029: END IF;
1030:
1031: IF l_Agreement_rec.salesrep_id = FND_API.G_MISS_NUM THEN

Line 1031: IF l_Agreement_rec.salesrep_id = FND_API.G_MISS_NUM THEN

1027: IF l_Agreement_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
1028: l_Agreement_rec.revision_reason_code := NULL;
1029: END IF;
1030:
1031: IF l_Agreement_rec.salesrep_id = FND_API.G_MISS_NUM THEN
1032: l_Agreement_rec.salesrep_id := NULL;
1033: END IF;
1034:
1035: IF l_Agreement_rec.ship_method_code = FND_API.G_MISS_CHAR THEN

Line 1035: IF l_Agreement_rec.ship_method_code = FND_API.G_MISS_CHAR THEN

1031: IF l_Agreement_rec.salesrep_id = FND_API.G_MISS_NUM THEN
1032: l_Agreement_rec.salesrep_id := NULL;
1033: END IF;
1034:
1035: IF l_Agreement_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
1036: l_Agreement_rec.ship_method_code := NULL;
1037: END IF;
1038:
1039: IF l_Agreement_rec.signature_date = FND_API.G_MISS_DATE THEN

Line 1039: IF l_Agreement_rec.signature_date = FND_API.G_MISS_DATE THEN

1035: IF l_Agreement_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
1036: l_Agreement_rec.ship_method_code := NULL;
1037: END IF;
1038:
1039: IF l_Agreement_rec.signature_date = FND_API.G_MISS_DATE THEN
1040: l_Agreement_rec.signature_date := NULL;
1041: END IF;
1042:
1043: IF l_Agreement_rec.start_date_active = FND_API.G_MISS_DATE THEN

Line 1043: IF l_Agreement_rec.start_date_active = FND_API.G_MISS_DATE THEN

1039: IF l_Agreement_rec.signature_date = FND_API.G_MISS_DATE THEN
1040: l_Agreement_rec.signature_date := NULL;
1041: END IF;
1042:
1043: IF l_Agreement_rec.start_date_active = FND_API.G_MISS_DATE THEN
1044: l_Agreement_rec.start_date_active := NULL;
1045: END IF;
1046:
1047: IF l_Agreement_rec.term_id = FND_API.G_MISS_NUM THEN

Line 1047: IF l_Agreement_rec.term_id = FND_API.G_MISS_NUM THEN

1043: IF l_Agreement_rec.start_date_active = FND_API.G_MISS_DATE THEN
1044: l_Agreement_rec.start_date_active := NULL;
1045: END IF;
1046:
1047: IF l_Agreement_rec.term_id = FND_API.G_MISS_NUM THEN
1048: l_Agreement_rec.term_id := NULL;
1049: END IF;
1050:
1051: --Begin code added by rchellam for OKC

Line 1052: IF l_Agreement_rec.agreement_source_code = FND_API.G_MISS_CHAR THEN

1048: l_Agreement_rec.term_id := NULL;
1049: END IF;
1050:
1051: --Begin code added by rchellam for OKC
1052: IF l_Agreement_rec.agreement_source_code = FND_API.G_MISS_CHAR THEN
1053: l_Agreement_rec.agreement_source_code := NULL;
1054: END IF;
1055:
1056: IF l_Agreement_rec.orig_system_agr_id = FND_API.G_MISS_NUM THEN

Line 1056: IF l_Agreement_rec.orig_system_agr_id = FND_API.G_MISS_NUM THEN

1052: IF l_Agreement_rec.agreement_source_code = FND_API.G_MISS_CHAR THEN
1053: l_Agreement_rec.agreement_source_code := NULL;
1054: END IF;
1055:
1056: IF l_Agreement_rec.orig_system_agr_id = FND_API.G_MISS_NUM THEN
1057: l_Agreement_rec.orig_system_agr_id := NULL;
1058: END IF;
1059: --End code added by rchellam for OKC
1060:

Line 1062: IF l_Agreement_rec.invoice_to_customer_id = FND_API.G_MISS_NUM THEN

1058: END IF;
1059: --End code added by rchellam for OKC
1060:
1061: -- Added for bug#4029589
1062: IF l_Agreement_rec.invoice_to_customer_id = FND_API.G_MISS_NUM THEN
1063: l_Agreement_rec.invoice_to_customer_id := NULL;
1064: END IF;
1065:
1066: RETURN l_Agreement_rec;

Line 1225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1221: , 'Update_Row'
1222: );
1223: END IF;
1224:
1225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1226:
1227: END Update_Row;
1228:
1229: -- Procedure Insert_Row

Line 1423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1419: , 'Insert_Row'
1420: );
1421: END IF;
1422:
1423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1424:
1425: END Insert_Row;
1426:
1427: -- Procedure Delete_Row

Line 1528: x_return_status := FND_API.G_RET_STS_SUCCESS;

1524:
1525: oe_dEbug_pub.add('Deleting Agreement because agreement is not associated with an order or order line');
1526:
1527: OE_AGREEMENTS_PKG.DELETE_ROW( p_agreement_id );
1528: x_return_status := FND_API.G_RET_STS_SUCCESS;
1529: else
1530: oe_debug_pub.add('Did not delete agreement');
1531: x_return_status := FND_API.G_RET_STS_ERROR;
1532: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 1531: x_return_status := FND_API.G_RET_STS_ERROR;

1527: OE_AGREEMENTS_PKG.DELETE_ROW( p_agreement_id );
1528: x_return_status := FND_API.G_RET_STS_SUCCESS;
1529: else
1530: oe_debug_pub.add('Did not delete agreement');
1531: x_return_status := FND_API.G_RET_STS_ERROR;
1532: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1533: FND_MESSAGE.SET_NAME('QP','QP_AGREEMENT_DELETE');
1534: oe_msg_pub.Add;
1535: -- x_return_status := FND_API.G_RET_STS_ERROR;

Line 1535: -- x_return_status := FND_API.G_RET_STS_ERROR;

1531: x_return_status := FND_API.G_RET_STS_ERROR;
1532: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1533: FND_MESSAGE.SET_NAME('QP','QP_AGREEMENT_DELETE');
1534: oe_msg_pub.Add;
1535: -- x_return_status := FND_API.G_RET_STS_ERROR;
1536: -- RAISE FND_API.G_EXC_ERROR;
1537: /* Bug 2321498 */
1538: END IF;
1539:

Line 1536: -- RAISE FND_API.G_EXC_ERROR;

1532: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1533: FND_MESSAGE.SET_NAME('QP','QP_AGREEMENT_DELETE');
1534: oe_msg_pub.Add;
1535: -- x_return_status := FND_API.G_RET_STS_ERROR;
1536: -- RAISE FND_API.G_EXC_ERROR;
1537: /* Bug 2321498 */
1538: END IF;
1539:
1540: end if;

Line 1546: WHEN FND_API.G_EXC_ERROR THEN

1542:
1543: oe_debug_pub.add('Exiting OE_Agreement_Util.Delete_Row');
1544:
1545: EXCEPTION
1546: WHEN FND_API.G_EXC_ERROR THEN
1547: RAISE FND_API.G_EXC_ERROR;
1548: WHEN no_data_found then
1549: NULL;
1550: WHEN OTHERS THEN

Line 1547: RAISE FND_API.G_EXC_ERROR;

1543: oe_debug_pub.add('Exiting OE_Agreement_Util.Delete_Row');
1544:
1545: EXCEPTION
1546: WHEN FND_API.G_EXC_ERROR THEN
1547: RAISE FND_API.G_EXC_ERROR;
1548: WHEN no_data_found then
1549: NULL;
1550: WHEN OTHERS THEN
1551:

Line 1560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1556: , 'Delete_Row'
1557: );
1558: END IF;
1559:
1560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1561:
1562: END Delete_Row;
1563:
1564: -- Function Query_Row

Line 1588: FND_API.G_MISS_NUM

1584: --
1585:
1586: FUNCTION Query_Rows
1587: ( p_agreement_id IN NUMBER :=
1588: FND_API.G_MISS_NUM
1589: , p_pricing_contract_id IN NUMBER :=
1590: FND_API.G_MISS_NUM
1591: ) RETURN OE_Pricing_Cont_PUB.Agreement_Tbl_Type
1592: IS

Line 1590: FND_API.G_MISS_NUM

1586: FUNCTION Query_Rows
1587: ( p_agreement_id IN NUMBER :=
1588: FND_API.G_MISS_NUM
1589: , p_pricing_contract_id IN NUMBER :=
1590: FND_API.G_MISS_NUM
1591: ) RETURN OE_Pricing_Cont_PUB.Agreement_Tbl_Type
1592: IS
1593: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1594: l_Agreement_tbl OE_Pricing_Cont_PUB.Agreement_Tbl_Type;

Line 1655: p_agreement_id <> FND_API.G_MISS_NUM)

1651:
1652: IF
1653: (p_agreement_id IS NOT NULL
1654: AND
1655: p_agreement_id <> FND_API.G_MISS_NUM)
1656: AND
1657: (p_pricing_contract_id IS NOT NULL
1658: AND
1659: p_pricing_contract_id <> FND_API.G_MISS_NUM)

Line 1659: p_pricing_contract_id <> FND_API.G_MISS_NUM)

1655: p_agreement_id <> FND_API.G_MISS_NUM)
1656: AND
1657: (p_pricing_contract_id IS NOT NULL
1658: AND
1659: p_pricing_contract_id <> FND_API.G_MISS_NUM)
1660: THEN
1661: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1662: THEN
1663: OE_MSG_PUB.Add_Exc_Msg

Line 1670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1666: , 'Keys are mutually exclusive: agreement_id = '|| p_agreement_id || ', pricing_contract_id = '|| p_pricing_contract_id
1667: );
1668: END IF;
1669:
1670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1671:
1672: END IF;
1673:
1674:

Line 1742: p_agreement_id <> FND_API.G_MISS_NUM)

1738:
1739: IF
1740: (p_agreement_id IS NOT NULL
1741: AND
1742: p_agreement_id <> FND_API.G_MISS_NUM)
1743: AND
1744: (l_Agreement_tbl.COUNT = 0)
1745: THEN
1746: RAISE NO_DATA_FOUND;

Line 1756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1752: RETURN l_Agreement_tbl;
1753:
1754: EXCEPTION
1755:
1756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1757:
1758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1759:
1760: WHEN OTHERS THEN

Line 1758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1754: EXCEPTION
1755:
1756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1757:
1758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1759:
1760: WHEN OTHERS THEN
1761:
1762: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1766: , 'Query_Rows'
1767: );
1768: END IF;
1769:
1770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1771:
1772: END Query_Rows;
1773:
1774: -- Procedure lock_Row

Line 1954: ((p_Agreement_rec.accounting_rule_id = FND_API.G_MISS_NUM) OR

1950: -- Row locked. Compare IN attributes to DB attributes.
1951:
1952: IF ( (l_Agreement_rec.accounting_rule_id =
1953: p_Agreement_rec.accounting_rule_id) OR
1954: ((p_Agreement_rec.accounting_rule_id = FND_API.G_MISS_NUM) OR
1955: ( (l_Agreement_rec.accounting_rule_id IS NULL) AND
1956: (p_Agreement_rec.accounting_rule_id IS NULL))))
1957: AND ( (l_Agreement_rec.agreement_contact_id =
1958: p_Agreement_rec.agreement_contact_id) OR

Line 1959: ((p_Agreement_rec.agreement_contact_id = FND_API.G_MISS_NUM) OR

1955: ( (l_Agreement_rec.accounting_rule_id IS NULL) AND
1956: (p_Agreement_rec.accounting_rule_id IS NULL))))
1957: AND ( (l_Agreement_rec.agreement_contact_id =
1958: p_Agreement_rec.agreement_contact_id) OR
1959: ((p_Agreement_rec.agreement_contact_id = FND_API.G_MISS_NUM) OR
1960: ( (l_Agreement_rec.agreement_contact_id IS NULL) AND
1961: (p_Agreement_rec.agreement_contact_id IS NULL))))
1962: AND ( (l_Agreement_rec.agreement_id =
1963: p_Agreement_rec.agreement_id) OR

Line 1964: ((p_Agreement_rec.agreement_id = FND_API.G_MISS_NUM) OR

1960: ( (l_Agreement_rec.agreement_contact_id IS NULL) AND
1961: (p_Agreement_rec.agreement_contact_id IS NULL))))
1962: AND ( (l_Agreement_rec.agreement_id =
1963: p_Agreement_rec.agreement_id) OR
1964: ((p_Agreement_rec.agreement_id = FND_API.G_MISS_NUM) OR
1965: ( (l_Agreement_rec.agreement_id IS NULL) AND
1966: (p_Agreement_rec.agreement_id IS NULL))))
1967: AND ( (l_Agreement_rec.agreement_num =
1968: p_Agreement_rec.agreement_num) OR

Line 1969: ((p_Agreement_rec.agreement_num = FND_API.G_MISS_CHAR) OR

1965: ( (l_Agreement_rec.agreement_id IS NULL) AND
1966: (p_Agreement_rec.agreement_id IS NULL))))
1967: AND ( (l_Agreement_rec.agreement_num =
1968: p_Agreement_rec.agreement_num) OR
1969: ((p_Agreement_rec.agreement_num = FND_API.G_MISS_CHAR) OR
1970: ( (l_Agreement_rec.agreement_num IS NULL) AND
1971: (p_Agreement_rec.agreement_num IS NULL))))
1972: AND ( (l_Agreement_rec.agreement_type_code =
1973: p_Agreement_rec.agreement_type_code) OR

Line 1974: ((p_Agreement_rec.agreement_type_code = FND_API.G_MISS_CHAR) OR

1970: ( (l_Agreement_rec.agreement_num IS NULL) AND
1971: (p_Agreement_rec.agreement_num IS NULL))))
1972: AND ( (l_Agreement_rec.agreement_type_code =
1973: p_Agreement_rec.agreement_type_code) OR
1974: ((p_Agreement_rec.agreement_type_code = FND_API.G_MISS_CHAR) OR
1975: ( (l_Agreement_rec.agreement_type_code IS NULL) AND
1976: (p_Agreement_rec.agreement_type_code IS NULL))))
1977: AND ( (l_Agreement_rec.attribute1 =
1978: p_Agreement_rec.attribute1) OR

Line 1979: ((p_Agreement_rec.attribute1 = FND_API.G_MISS_CHAR) OR

1975: ( (l_Agreement_rec.agreement_type_code IS NULL) AND
1976: (p_Agreement_rec.agreement_type_code IS NULL))))
1977: AND ( (l_Agreement_rec.attribute1 =
1978: p_Agreement_rec.attribute1) OR
1979: ((p_Agreement_rec.attribute1 = FND_API.G_MISS_CHAR) OR
1980: ( (l_Agreement_rec.attribute1 IS NULL) AND
1981: (p_Agreement_rec.attribute1 IS NULL))))
1982: AND ( (l_Agreement_rec.attribute10 =
1983: p_Agreement_rec.attribute10) OR

Line 1984: ((p_Agreement_rec.attribute10 = FND_API.G_MISS_CHAR) OR

1980: ( (l_Agreement_rec.attribute1 IS NULL) AND
1981: (p_Agreement_rec.attribute1 IS NULL))))
1982: AND ( (l_Agreement_rec.attribute10 =
1983: p_Agreement_rec.attribute10) OR
1984: ((p_Agreement_rec.attribute10 = FND_API.G_MISS_CHAR) OR
1985: ( (l_Agreement_rec.attribute10 IS NULL) AND
1986: (p_Agreement_rec.attribute10 IS NULL))))
1987: AND ( (l_Agreement_rec.attribute11 =
1988: p_Agreement_rec.attribute11) OR

Line 1989: ((p_Agreement_rec.attribute11 = FND_API.G_MISS_CHAR) OR

1985: ( (l_Agreement_rec.attribute10 IS NULL) AND
1986: (p_Agreement_rec.attribute10 IS NULL))))
1987: AND ( (l_Agreement_rec.attribute11 =
1988: p_Agreement_rec.attribute11) OR
1989: ((p_Agreement_rec.attribute11 = FND_API.G_MISS_CHAR) OR
1990: ( (l_Agreement_rec.attribute11 IS NULL) AND
1991: (p_Agreement_rec.attribute11 IS NULL))))
1992: AND ( (l_Agreement_rec.attribute12 =
1993: p_Agreement_rec.attribute12) OR

Line 1994: ((p_Agreement_rec.attribute12 = FND_API.G_MISS_CHAR) OR

1990: ( (l_Agreement_rec.attribute11 IS NULL) AND
1991: (p_Agreement_rec.attribute11 IS NULL))))
1992: AND ( (l_Agreement_rec.attribute12 =
1993: p_Agreement_rec.attribute12) OR
1994: ((p_Agreement_rec.attribute12 = FND_API.G_MISS_CHAR) OR
1995: ( (l_Agreement_rec.attribute12 IS NULL) AND
1996: (p_Agreement_rec.attribute12 IS NULL))))
1997: AND ( (l_Agreement_rec.attribute13 =
1998: p_Agreement_rec.attribute13) OR

Line 1999: ((p_Agreement_rec.attribute13 = FND_API.G_MISS_CHAR) OR

1995: ( (l_Agreement_rec.attribute12 IS NULL) AND
1996: (p_Agreement_rec.attribute12 IS NULL))))
1997: AND ( (l_Agreement_rec.attribute13 =
1998: p_Agreement_rec.attribute13) OR
1999: ((p_Agreement_rec.attribute13 = FND_API.G_MISS_CHAR) OR
2000: ( (l_Agreement_rec.attribute13 IS NULL) AND
2001: (p_Agreement_rec.attribute13 IS NULL))))
2002: AND ( (l_Agreement_rec.attribute14 =
2003: p_Agreement_rec.attribute14) OR

Line 2004: ((p_Agreement_rec.attribute14 = FND_API.G_MISS_CHAR) OR

2000: ( (l_Agreement_rec.attribute13 IS NULL) AND
2001: (p_Agreement_rec.attribute13 IS NULL))))
2002: AND ( (l_Agreement_rec.attribute14 =
2003: p_Agreement_rec.attribute14) OR
2004: ((p_Agreement_rec.attribute14 = FND_API.G_MISS_CHAR) OR
2005: ( (l_Agreement_rec.attribute14 IS NULL) AND
2006: (p_Agreement_rec.attribute14 IS NULL))))
2007: AND ( (l_Agreement_rec.attribute15 =
2008: p_Agreement_rec.attribute15) OR

Line 2009: ((p_Agreement_rec.attribute15 = FND_API.G_MISS_CHAR) OR

2005: ( (l_Agreement_rec.attribute14 IS NULL) AND
2006: (p_Agreement_rec.attribute14 IS NULL))))
2007: AND ( (l_Agreement_rec.attribute15 =
2008: p_Agreement_rec.attribute15) OR
2009: ((p_Agreement_rec.attribute15 = FND_API.G_MISS_CHAR) OR
2010: ( (l_Agreement_rec.attribute15 IS NULL) AND
2011: (p_Agreement_rec.attribute15 IS NULL))))
2012: AND ( (l_Agreement_rec.attribute2 =
2013: p_Agreement_rec.attribute2) OR

Line 2014: ((p_Agreement_rec.attribute2 = FND_API.G_MISS_CHAR) OR

2010: ( (l_Agreement_rec.attribute15 IS NULL) AND
2011: (p_Agreement_rec.attribute15 IS NULL))))
2012: AND ( (l_Agreement_rec.attribute2 =
2013: p_Agreement_rec.attribute2) OR
2014: ((p_Agreement_rec.attribute2 = FND_API.G_MISS_CHAR) OR
2015: ( (l_Agreement_rec.attribute2 IS NULL) AND
2016: (p_Agreement_rec.attribute2 IS NULL))))
2017: AND ( (l_Agreement_rec.attribute3 =
2018: p_Agreement_rec.attribute3) OR

Line 2019: ((p_Agreement_rec.attribute3 = FND_API.G_MISS_CHAR) OR

2015: ( (l_Agreement_rec.attribute2 IS NULL) AND
2016: (p_Agreement_rec.attribute2 IS NULL))))
2017: AND ( (l_Agreement_rec.attribute3 =
2018: p_Agreement_rec.attribute3) OR
2019: ((p_Agreement_rec.attribute3 = FND_API.G_MISS_CHAR) OR
2020: ( (l_Agreement_rec.attribute3 IS NULL) AND
2021: (p_Agreement_rec.attribute3 IS NULL))))
2022: AND ( (l_Agreement_rec.attribute4 =
2023: p_Agreement_rec.attribute4) OR

Line 2024: ((p_Agreement_rec.attribute4 = FND_API.G_MISS_CHAR) OR

2020: ( (l_Agreement_rec.attribute3 IS NULL) AND
2021: (p_Agreement_rec.attribute3 IS NULL))))
2022: AND ( (l_Agreement_rec.attribute4 =
2023: p_Agreement_rec.attribute4) OR
2024: ((p_Agreement_rec.attribute4 = FND_API.G_MISS_CHAR) OR
2025: ( (l_Agreement_rec.attribute4 IS NULL) AND
2026: (p_Agreement_rec.attribute4 IS NULL))))
2027: AND ( (l_Agreement_rec.attribute5 =
2028: p_Agreement_rec.attribute5) OR

Line 2029: ((p_Agreement_rec.attribute5 = FND_API.G_MISS_CHAR) OR

2025: ( (l_Agreement_rec.attribute4 IS NULL) AND
2026: (p_Agreement_rec.attribute4 IS NULL))))
2027: AND ( (l_Agreement_rec.attribute5 =
2028: p_Agreement_rec.attribute5) OR
2029: ((p_Agreement_rec.attribute5 = FND_API.G_MISS_CHAR) OR
2030: ( (l_Agreement_rec.attribute5 IS NULL) AND
2031: (p_Agreement_rec.attribute5 IS NULL))))
2032: AND ( (l_Agreement_rec.attribute6 =
2033: p_Agreement_rec.attribute6) OR

Line 2034: ((p_Agreement_rec.attribute6 = FND_API.G_MISS_CHAR) OR

2030: ( (l_Agreement_rec.attribute5 IS NULL) AND
2031: (p_Agreement_rec.attribute5 IS NULL))))
2032: AND ( (l_Agreement_rec.attribute6 =
2033: p_Agreement_rec.attribute6) OR
2034: ((p_Agreement_rec.attribute6 = FND_API.G_MISS_CHAR) OR
2035: ( (l_Agreement_rec.attribute6 IS NULL) AND
2036: (p_Agreement_rec.attribute6 IS NULL))))
2037: AND ( (l_Agreement_rec.attribute7 =
2038: p_Agreement_rec.attribute7) OR

Line 2039: ((p_Agreement_rec.attribute7 = FND_API.G_MISS_CHAR) OR

2035: ( (l_Agreement_rec.attribute6 IS NULL) AND
2036: (p_Agreement_rec.attribute6 IS NULL))))
2037: AND ( (l_Agreement_rec.attribute7 =
2038: p_Agreement_rec.attribute7) OR
2039: ((p_Agreement_rec.attribute7 = FND_API.G_MISS_CHAR) OR
2040: ( (l_Agreement_rec.attribute7 IS NULL) AND
2041: (p_Agreement_rec.attribute7 IS NULL))))
2042: AND ( (l_Agreement_rec.attribute8 =
2043: p_Agreement_rec.attribute8) OR

Line 2044: ((p_Agreement_rec.attribute8 = FND_API.G_MISS_CHAR) OR

2040: ( (l_Agreement_rec.attribute7 IS NULL) AND
2041: (p_Agreement_rec.attribute7 IS NULL))))
2042: AND ( (l_Agreement_rec.attribute8 =
2043: p_Agreement_rec.attribute8) OR
2044: ((p_Agreement_rec.attribute8 = FND_API.G_MISS_CHAR) OR
2045: ( (l_Agreement_rec.attribute8 IS NULL) AND
2046: (p_Agreement_rec.attribute8 IS NULL))))
2047: AND ( (l_Agreement_rec.attribute9 =
2048: p_Agreement_rec.attribute9) OR

Line 2049: ((p_Agreement_rec.attribute9 = FND_API.G_MISS_CHAR) OR

2045: ( (l_Agreement_rec.attribute8 IS NULL) AND
2046: (p_Agreement_rec.attribute8 IS NULL))))
2047: AND ( (l_Agreement_rec.attribute9 =
2048: p_Agreement_rec.attribute9) OR
2049: ((p_Agreement_rec.attribute9 = FND_API.G_MISS_CHAR) OR
2050: ( (l_Agreement_rec.attribute9 IS NULL) AND
2051: (p_Agreement_rec.attribute9 IS NULL))))
2052: AND ( (l_Agreement_rec.context =
2053: p_Agreement_rec.context) OR

Line 2054: ((p_Agreement_rec.context = FND_API.G_MISS_CHAR) OR

2050: ( (l_Agreement_rec.attribute9 IS NULL) AND
2051: (p_Agreement_rec.attribute9 IS NULL))))
2052: AND ( (l_Agreement_rec.context =
2053: p_Agreement_rec.context) OR
2054: ((p_Agreement_rec.context = FND_API.G_MISS_CHAR) OR
2055: ( (l_Agreement_rec.context IS NULL) AND
2056: (p_Agreement_rec.context IS NULL))))
2057: AND ( (l_Agreement_rec.created_by =
2058: p_Agreement_rec.created_by) OR

Line 2059: ((p_Agreement_rec.created_by = FND_API.G_MISS_NUM) OR

2055: ( (l_Agreement_rec.context IS NULL) AND
2056: (p_Agreement_rec.context IS NULL))))
2057: AND ( (l_Agreement_rec.created_by =
2058: p_Agreement_rec.created_by) OR
2059: ((p_Agreement_rec.created_by = FND_API.G_MISS_NUM) OR
2060: ( (l_Agreement_rec.created_by IS NULL) AND
2061: (p_Agreement_rec.created_by IS NULL))))
2062: AND ( (l_Agreement_rec.creation_date =
2063: p_Agreement_rec.creation_date) OR

Line 2064: ((p_Agreement_rec.creation_date = FND_API.G_MISS_DATE) OR

2060: ( (l_Agreement_rec.created_by IS NULL) AND
2061: (p_Agreement_rec.created_by IS NULL))))
2062: AND ( (l_Agreement_rec.creation_date =
2063: p_Agreement_rec.creation_date) OR
2064: ((p_Agreement_rec.creation_date = FND_API.G_MISS_DATE) OR
2065: ( (l_Agreement_rec.creation_date IS NULL) AND
2066: (p_Agreement_rec.creation_date IS NULL))))
2067: AND ( (l_Agreement_rec.sold_to_org_id =
2068: p_Agreement_rec.sold_to_org_id) OR

Line 2069: ((p_Agreement_rec.sold_to_org_id = FND_API.G_MISS_NUM) OR

2065: ( (l_Agreement_rec.creation_date IS NULL) AND
2066: (p_Agreement_rec.creation_date IS NULL))))
2067: AND ( (l_Agreement_rec.sold_to_org_id =
2068: p_Agreement_rec.sold_to_org_id) OR
2069: ((p_Agreement_rec.sold_to_org_id = FND_API.G_MISS_NUM) OR
2070: ( (l_Agreement_rec.sold_to_org_id IS NULL) AND
2071: (p_Agreement_rec.sold_to_org_id IS NULL))))
2072: AND ( (l_Agreement_rec.end_date_active =
2073: p_Agreement_rec.end_date_active) OR

Line 2074: ((p_Agreement_rec.end_date_active = FND_API.G_MISS_DATE) OR

2070: ( (l_Agreement_rec.sold_to_org_id IS NULL) AND
2071: (p_Agreement_rec.sold_to_org_id IS NULL))))
2072: AND ( (l_Agreement_rec.end_date_active =
2073: p_Agreement_rec.end_date_active) OR
2074: ((p_Agreement_rec.end_date_active = FND_API.G_MISS_DATE) OR
2075: ( (l_Agreement_rec.end_date_active IS NULL) AND
2076: (p_Agreement_rec.end_date_active IS NULL))))
2077: AND ( (l_Agreement_rec.freight_terms_code =
2078: p_Agreement_rec.freight_terms_code) OR

Line 2079: ((p_Agreement_rec.freight_terms_code = FND_API.G_MISS_CHAR) OR

2075: ( (l_Agreement_rec.end_date_active IS NULL) AND
2076: (p_Agreement_rec.end_date_active IS NULL))))
2077: AND ( (l_Agreement_rec.freight_terms_code =
2078: p_Agreement_rec.freight_terms_code) OR
2079: ((p_Agreement_rec.freight_terms_code = FND_API.G_MISS_CHAR) OR
2080: ( (l_Agreement_rec.freight_terms_code IS NULL) AND
2081: (p_Agreement_rec.freight_terms_code IS NULL))))
2082: AND ( (l_Agreement_rec.invoice_contact_id =
2083: p_Agreement_rec.invoice_contact_id) OR

Line 2084: ((p_Agreement_rec.invoice_contact_id = FND_API.G_MISS_NUM) OR

2080: ( (l_Agreement_rec.freight_terms_code IS NULL) AND
2081: (p_Agreement_rec.freight_terms_code IS NULL))))
2082: AND ( (l_Agreement_rec.invoice_contact_id =
2083: p_Agreement_rec.invoice_contact_id) OR
2084: ((p_Agreement_rec.invoice_contact_id = FND_API.G_MISS_NUM) OR
2085: ( (l_Agreement_rec.invoice_contact_id IS NULL) AND
2086: (p_Agreement_rec.invoice_contact_id IS NULL))))
2087: AND ( (l_Agreement_rec.invoice_to_org_id =
2088: p_Agreement_rec.invoice_to_org_id) OR

Line 2089: ((p_Agreement_rec.invoice_to_org_id = FND_API.G_MISS_NUM) OR

2085: ( (l_Agreement_rec.invoice_contact_id IS NULL) AND
2086: (p_Agreement_rec.invoice_contact_id IS NULL))))
2087: AND ( (l_Agreement_rec.invoice_to_org_id =
2088: p_Agreement_rec.invoice_to_org_id) OR
2089: ((p_Agreement_rec.invoice_to_org_id = FND_API.G_MISS_NUM) OR
2090: ( (l_Agreement_rec.invoice_to_org_id IS NULL) AND
2091: (p_Agreement_rec.invoice_to_org_id IS NULL))))
2092: AND ( (l_Agreement_rec.invoicing_rule_id =
2093: p_Agreement_rec.invoicing_rule_id) OR

Line 2094: ((p_Agreement_rec.invoicing_rule_id = FND_API.G_MISS_NUM) OR

2090: ( (l_Agreement_rec.invoice_to_org_id IS NULL) AND
2091: (p_Agreement_rec.invoice_to_org_id IS NULL))))
2092: AND ( (l_Agreement_rec.invoicing_rule_id =
2093: p_Agreement_rec.invoicing_rule_id) OR
2094: ((p_Agreement_rec.invoicing_rule_id = FND_API.G_MISS_NUM) OR
2095: ( (l_Agreement_rec.invoicing_rule_id IS NULL) AND
2096: (p_Agreement_rec.invoicing_rule_id IS NULL))))
2097: AND ( (l_Agreement_rec.last_updated_by =
2098: p_Agreement_rec.last_updated_by) OR

Line 2099: ((p_Agreement_rec.last_updated_by = FND_API.G_MISS_NUM) OR

2095: ( (l_Agreement_rec.invoicing_rule_id IS NULL) AND
2096: (p_Agreement_rec.invoicing_rule_id IS NULL))))
2097: AND ( (l_Agreement_rec.last_updated_by =
2098: p_Agreement_rec.last_updated_by) OR
2099: ((p_Agreement_rec.last_updated_by = FND_API.G_MISS_NUM) OR
2100: ( (l_Agreement_rec.last_updated_by IS NULL) AND
2101: (p_Agreement_rec.last_updated_by IS NULL))))
2102: AND ( (l_Agreement_rec.last_update_date =
2103: p_Agreement_rec.last_update_date) OR

Line 2104: ((p_Agreement_rec.last_update_date = FND_API.G_MISS_DATE) OR

2100: ( (l_Agreement_rec.last_updated_by IS NULL) AND
2101: (p_Agreement_rec.last_updated_by IS NULL))))
2102: AND ( (l_Agreement_rec.last_update_date =
2103: p_Agreement_rec.last_update_date) OR
2104: ((p_Agreement_rec.last_update_date = FND_API.G_MISS_DATE) OR
2105: ( (l_Agreement_rec.last_update_date IS NULL) AND
2106: (p_Agreement_rec.last_update_date IS NULL))))
2107: AND ( (l_Agreement_rec.last_update_login =
2108: p_Agreement_rec.last_update_login) OR

Line 2109: ((p_Agreement_rec.last_update_login = FND_API.G_MISS_NUM) OR

2105: ( (l_Agreement_rec.last_update_date IS NULL) AND
2106: (p_Agreement_rec.last_update_date IS NULL))))
2107: AND ( (l_Agreement_rec.last_update_login =
2108: p_Agreement_rec.last_update_login) OR
2109: ((p_Agreement_rec.last_update_login = FND_API.G_MISS_NUM) OR
2110: ( (l_Agreement_rec.last_update_login IS NULL) AND
2111: (p_Agreement_rec.last_update_login IS NULL))))
2112: AND ( (l_Agreement_rec.name =
2113: p_Agreement_rec.name) OR

Line 2114: ((p_Agreement_rec.name = FND_API.G_MISS_CHAR) OR

2110: ( (l_Agreement_rec.last_update_login IS NULL) AND
2111: (p_Agreement_rec.last_update_login IS NULL))))
2112: AND ( (l_Agreement_rec.name =
2113: p_Agreement_rec.name) OR
2114: ((p_Agreement_rec.name = FND_API.G_MISS_CHAR) OR
2115: ( (l_Agreement_rec.name IS NULL) AND
2116: (p_Agreement_rec.name IS NULL))))
2117: AND ( (l_Agreement_rec.override_arule_flag =
2118: p_Agreement_rec.override_arule_flag) OR

Line 2119: ((p_Agreement_rec.override_arule_flag = FND_API.G_MISS_CHAR) OR

2115: ( (l_Agreement_rec.name IS NULL) AND
2116: (p_Agreement_rec.name IS NULL))))
2117: AND ( (l_Agreement_rec.override_arule_flag =
2118: p_Agreement_rec.override_arule_flag) OR
2119: ((p_Agreement_rec.override_arule_flag = FND_API.G_MISS_CHAR) OR
2120: ( (l_Agreement_rec.override_arule_flag IS NULL) AND
2121: (p_Agreement_rec.override_arule_flag IS NULL))))
2122: AND ( (l_Agreement_rec.override_irule_flag =
2123: p_Agreement_rec.override_irule_flag) OR

Line 2124: ((p_Agreement_rec.override_irule_flag = FND_API.G_MISS_CHAR) OR

2120: ( (l_Agreement_rec.override_arule_flag IS NULL) AND
2121: (p_Agreement_rec.override_arule_flag IS NULL))))
2122: AND ( (l_Agreement_rec.override_irule_flag =
2123: p_Agreement_rec.override_irule_flag) OR
2124: ((p_Agreement_rec.override_irule_flag = FND_API.G_MISS_CHAR) OR
2125: ( (l_Agreement_rec.override_irule_flag IS NULL) AND
2126: (p_Agreement_rec.override_irule_flag IS NULL))))
2127: AND ( (l_Agreement_rec.price_list_id =
2128: p_Agreement_rec.price_list_id) OR

Line 2129: ((p_Agreement_rec.price_list_id = FND_API.G_MISS_NUM) OR

2125: ( (l_Agreement_rec.override_irule_flag IS NULL) AND
2126: (p_Agreement_rec.override_irule_flag IS NULL))))
2127: AND ( (l_Agreement_rec.price_list_id =
2128: p_Agreement_rec.price_list_id) OR
2129: ((p_Agreement_rec.price_list_id = FND_API.G_MISS_NUM) OR
2130: ( (l_Agreement_rec.price_list_id IS NULL) AND
2131: (p_Agreement_rec.price_list_id IS NULL))))
2132: AND ( (l_Agreement_rec.purchase_order_num =
2133: p_Agreement_rec.purchase_order_num) OR

Line 2134: ((p_Agreement_rec.purchase_order_num = FND_API.G_MISS_CHAR) OR

2130: ( (l_Agreement_rec.price_list_id IS NULL) AND
2131: (p_Agreement_rec.price_list_id IS NULL))))
2132: AND ( (l_Agreement_rec.purchase_order_num =
2133: p_Agreement_rec.purchase_order_num) OR
2134: ((p_Agreement_rec.purchase_order_num = FND_API.G_MISS_CHAR) OR
2135: ( (l_Agreement_rec.purchase_order_num IS NULL) AND
2136: (p_Agreement_rec.purchase_order_num IS NULL))))
2137: AND ( (l_Agreement_rec.revision =
2138: p_Agreement_rec.revision) OR

Line 2139: ((p_Agreement_rec.revision = FND_API.G_MISS_CHAR) OR

2135: ( (l_Agreement_rec.purchase_order_num IS NULL) AND
2136: (p_Agreement_rec.purchase_order_num IS NULL))))
2137: AND ( (l_Agreement_rec.revision =
2138: p_Agreement_rec.revision) OR
2139: ((p_Agreement_rec.revision = FND_API.G_MISS_CHAR) OR
2140: ( (l_Agreement_rec.revision IS NULL) AND
2141: (p_Agreement_rec.revision IS NULL))))
2142: AND ( (l_Agreement_rec.revision_date =
2143: p_Agreement_rec.revision_date) OR

Line 2144: ((p_Agreement_rec.revision_date = FND_API.G_MISS_DATE) OR

2140: ( (l_Agreement_rec.revision IS NULL) AND
2141: (p_Agreement_rec.revision IS NULL))))
2142: AND ( (l_Agreement_rec.revision_date =
2143: p_Agreement_rec.revision_date) OR
2144: ((p_Agreement_rec.revision_date = FND_API.G_MISS_DATE) OR
2145: ( (l_Agreement_rec.revision_date IS NULL) AND
2146: (p_Agreement_rec.revision_date IS NULL))))
2147: AND ( (l_Agreement_rec.revision_reason_code =
2148: p_Agreement_rec.revision_reason_code) OR

Line 2149: ((p_Agreement_rec.revision_reason_code = FND_API.G_MISS_CHAR) OR

2145: ( (l_Agreement_rec.revision_date IS NULL) AND
2146: (p_Agreement_rec.revision_date IS NULL))))
2147: AND ( (l_Agreement_rec.revision_reason_code =
2148: p_Agreement_rec.revision_reason_code) OR
2149: ((p_Agreement_rec.revision_reason_code = FND_API.G_MISS_CHAR) OR
2150: ( (l_Agreement_rec.revision_reason_code IS NULL) AND
2151: (p_Agreement_rec.revision_reason_code IS NULL))))
2152: AND ( (l_Agreement_rec.salesrep_id =
2153: p_Agreement_rec.salesrep_id) OR

Line 2154: ((p_Agreement_rec.salesrep_id = FND_API.G_MISS_NUM) OR

2150: ( (l_Agreement_rec.revision_reason_code IS NULL) AND
2151: (p_Agreement_rec.revision_reason_code IS NULL))))
2152: AND ( (l_Agreement_rec.salesrep_id =
2153: p_Agreement_rec.salesrep_id) OR
2154: ((p_Agreement_rec.salesrep_id = FND_API.G_MISS_NUM) OR
2155: ( (l_Agreement_rec.salesrep_id IS NULL) AND
2156: (p_Agreement_rec.salesrep_id IS NULL))))
2157: AND ( (l_Agreement_rec.ship_method_code =
2158: p_Agreement_rec.ship_method_code) OR

Line 2159: ((p_Agreement_rec.ship_method_code = FND_API.G_MISS_CHAR) OR

2155: ( (l_Agreement_rec.salesrep_id IS NULL) AND
2156: (p_Agreement_rec.salesrep_id IS NULL))))
2157: AND ( (l_Agreement_rec.ship_method_code =
2158: p_Agreement_rec.ship_method_code) OR
2159: ((p_Agreement_rec.ship_method_code = FND_API.G_MISS_CHAR) OR
2160: ( (l_Agreement_rec.ship_method_code IS NULL) AND
2161: (p_Agreement_rec.ship_method_code IS NULL))))
2162: AND ( (l_Agreement_rec.signature_date =
2163: p_Agreement_rec.signature_date) OR

Line 2164: ((p_Agreement_rec.signature_date = FND_API.G_MISS_DATE) OR

2160: ( (l_Agreement_rec.ship_method_code IS NULL) AND
2161: (p_Agreement_rec.ship_method_code IS NULL))))
2162: AND ( (l_Agreement_rec.signature_date =
2163: p_Agreement_rec.signature_date) OR
2164: ((p_Agreement_rec.signature_date = FND_API.G_MISS_DATE) OR
2165: ( (l_Agreement_rec.signature_date IS NULL) AND
2166: (p_Agreement_rec.signature_date IS NULL))))
2167: AND ( (l_Agreement_rec.start_date_active =
2168: p_Agreement_rec.start_date_active) OR

Line 2169: ((p_Agreement_rec.start_date_active = FND_API.G_MISS_DATE) OR

2165: ( (l_Agreement_rec.signature_date IS NULL) AND
2166: (p_Agreement_rec.signature_date IS NULL))))
2167: AND ( (l_Agreement_rec.start_date_active =
2168: p_Agreement_rec.start_date_active) OR
2169: ((p_Agreement_rec.start_date_active = FND_API.G_MISS_DATE) OR
2170: ( (l_Agreement_rec.start_date_active IS NULL) AND
2171: (p_Agreement_rec.start_date_active IS NULL))))
2172: AND ( (l_Agreement_rec.term_id =
2173: p_Agreement_rec.term_id) OR

Line 2174: ((p_Agreement_rec.term_id = FND_API.G_MISS_NUM) OR

2170: ( (l_Agreement_rec.start_date_active IS NULL) AND
2171: (p_Agreement_rec.start_date_active IS NULL))))
2172: AND ( (l_Agreement_rec.term_id =
2173: p_Agreement_rec.term_id) OR
2174: ((p_Agreement_rec.term_id = FND_API.G_MISS_NUM) OR
2175: ( (l_Agreement_rec.term_id IS NULL) AND
2176: (p_Agreement_rec.term_id IS NULL))))
2177: --Begin code added by rchellam for OKC
2178: AND ( (l_Agreement_rec.agreement_source_code =

Line 2180: ((p_Agreement_rec.agreement_source_code = FND_API.G_MISS_CHAR) OR

2176: (p_Agreement_rec.term_id IS NULL))))
2177: --Begin code added by rchellam for OKC
2178: AND ( (l_Agreement_rec.agreement_source_code =
2179: p_Agreement_rec.agreement_source_code) OR
2180: ((p_Agreement_rec.agreement_source_code = FND_API.G_MISS_CHAR) OR
2181: ( (l_Agreement_rec.agreement_source_code IS NULL) AND
2182: (p_Agreement_rec.agreement_source_code IS NULL))))
2183: AND ( (l_Agreement_rec.orig_system_agr_id =
2184: p_Agreement_rec.orig_system_agr_id) OR

Line 2185: ((p_Agreement_rec.orig_system_agr_id = FND_API.G_MISS_NUM) OR

2181: ( (l_Agreement_rec.agreement_source_code IS NULL) AND
2182: (p_Agreement_rec.agreement_source_code IS NULL))))
2183: AND ( (l_Agreement_rec.orig_system_agr_id =
2184: p_Agreement_rec.orig_system_agr_id) OR
2185: ((p_Agreement_rec.orig_system_agr_id = FND_API.G_MISS_NUM) OR
2186: ( (l_Agreement_rec.orig_system_agr_id IS NULL) AND
2187: (p_Agreement_rec.orig_system_agr_id IS NULL))))
2188: --End code added by rchellam for OKC
2189: -- Added for bug#4029589

Line 2192: ((p_Agreement_rec.invoice_to_customer_id = FND_API.G_MISS_NUM) OR

2188: --End code added by rchellam for OKC
2189: -- Added for bug#4029589
2190: AND ( (l_Agreement_rec.invoice_to_customer_id =
2191: p_Agreement_rec.invoice_to_customer_id) OR
2192: ((p_Agreement_rec.invoice_to_customer_id = FND_API.G_MISS_NUM) OR
2193: ( (l_Agreement_rec.invoice_to_customer_id IS NULL) AND
2194: (p_Agreement_rec.invoice_to_customer_id IS NULL))))
2195: THEN
2196:

Line 2203: x_return_status := FND_API.G_RET_STS_SUCCESS;

2199: x_Agreement_rec := l_Agreement_rec;
2200:
2201: -- Set return status
2202:
2203: x_return_status := FND_API.G_RET_STS_SUCCESS;
2204: x_Agreement_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2205:
2206: ELSE
2207:

Line 2204: x_Agreement_rec.return_status := FND_API.G_RET_STS_SUCCESS;

2200:
2201: -- Set return status
2202:
2203: x_return_status := FND_API.G_RET_STS_SUCCESS;
2204: x_Agreement_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2205:
2206: ELSE
2207:
2208: -- Row has changed by another user.

Line 2210: x_return_status := FND_API.G_RET_STS_ERROR;

2206: ELSE
2207:
2208: -- Row has changed by another user.
2209:
2210: x_return_status := FND_API.G_RET_STS_ERROR;
2211: x_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2212:
2213: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2214: THEN

Line 2211: x_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;

2207:
2208: -- Row has changed by another user.
2209:
2210: x_return_status := FND_API.G_RET_STS_ERROR;
2211: x_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2212:
2213: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2214: THEN
2215:

Line 2229: x_return_status := FND_API.G_RET_STS_ERROR;

2225: EXCEPTION
2226:
2227: WHEN NO_DATA_FOUND THEN
2228:
2229: x_return_status := FND_API.G_RET_STS_ERROR;
2230: x_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2231:
2232: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2233: THEN

Line 2230: x_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;

2226:
2227: WHEN NO_DATA_FOUND THEN
2228:
2229: x_return_status := FND_API.G_RET_STS_ERROR;
2230: x_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2231:
2232: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2233: THEN
2234:

Line 2241: x_return_status := FND_API.G_RET_STS_ERROR;

2237:
2238: END IF;
2239: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2240:
2241: x_return_status := FND_API.G_RET_STS_ERROR;
2242: x_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2243:
2244: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2245: THEN

Line 2242: x_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;

2238: END IF;
2239: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2240:
2241: x_return_status := FND_API.G_RET_STS_ERROR;
2242: x_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2243:
2244: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2245: THEN
2246:

Line 2253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2249:
2250: END IF;
2251: WHEN OTHERS THEN
2252:
2253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2254: x_Agreement_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2255:
2256: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2257: THEN

Line 2254: x_Agreement_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2250: END IF;
2251: WHEN OTHERS THEN
2252:
2253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2254: x_Agreement_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2255:
2256: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2257: THEN
2258: OE_MSG_PUB.Add_Exc_Msg

Line 2280: p_Agreement_rec.accounting_rule_id <> FND_API.G_MISS_NUM AND

2276:
2277: oe_debug_pub.add('Entering OE_Agreement_Util.Get_Values');
2278:
2279: IF p_Agreement_rec.accounting_rule_id IS NOT NULL AND
2280: p_Agreement_rec.accounting_rule_id <> FND_API.G_MISS_NUM AND
2281: NOT OE_GLOBALS.Equal(p_Agreement_rec.accounting_rule_id,
2282: p_old_Agreement_rec.accounting_rule_id)
2283: THEN
2284: l_Agreement_val_rec.accounting_rule := QP_Id_To_Value.Accounting_Rule

Line 2290: p_Agreement_rec.agreement_contact_id <> FND_API.G_MISS_NUM AND

2286: );
2287: END IF;
2288:
2289: IF p_Agreement_rec.agreement_contact_id IS NOT NULL AND
2290: p_Agreement_rec.agreement_contact_id <> FND_API.G_MISS_NUM AND
2291: NOT OE_GLOBALS.Equal(p_Agreement_rec.agreement_contact_id,
2292: p_old_Agreement_rec.agreement_contact_id)
2293: THEN
2294: l_Agreement_val_rec.agreement_contact := QP_Id_To_Value.Agreement_Contact

Line 2302: p_Agreement_rec.agreement_id <> FND_API.G_MISS_NUM AND

2298:
2299: /*changes made by spgopal for 'AGR' fix 08/10/00*/
2300: /*
2301: IF p_Agreement_rec.agreement_id IS NOT NULL AND
2302: p_Agreement_rec.agreement_id <> FND_API.G_MISS_NUM AND
2303: NOT OE_GLOBALS.Equal(p_Agreement_rec.agreement_id,
2304: p_old_Agreement_rec.agreement_id)
2305: THEN
2306: l_Agreement_val_rec.agreement := QP_Id_To_Value.Agreement

Line 2313: p_Agreement_rec.agreement_type_code <> FND_API.G_MISS_CHAR AND

2309: END IF;
2310: */
2311:
2312: IF p_Agreement_rec.agreement_type_code IS NOT NULL AND
2313: p_Agreement_rec.agreement_type_code <> FND_API.G_MISS_CHAR AND
2314: NOT OE_GLOBALS.Equal(p_Agreement_rec.agreement_type_code,
2315: p_old_Agreement_rec.agreement_type_code)
2316: THEN
2317: l_Agreement_val_rec.agreement_type := QP_Id_To_Value.Agreement_Type

Line 2323: p_Agreement_rec.sold_to_org_id <> FND_API.G_MISS_NUM AND

2319: );
2320: END IF;
2321:
2322: IF p_Agreement_rec.sold_to_org_id IS NOT NULL AND
2323: p_Agreement_rec.sold_to_org_id <> FND_API.G_MISS_NUM AND
2324: NOT OE_GLOBALS.Equal(p_Agreement_rec.sold_to_org_id,
2325: p_old_Agreement_rec.sold_to_org_id)
2326: THEN
2327: l_Agreement_val_rec.customer := QP_Id_To_Value.Customer

Line 2333: p_Agreement_rec.freight_terms_code <> FND_API.G_MISS_CHAR AND

2329: );
2330: END IF;
2331:
2332: IF p_Agreement_rec.freight_terms_code IS NOT NULL AND
2333: p_Agreement_rec.freight_terms_code <> FND_API.G_MISS_CHAR AND
2334: NOT OE_GLOBALS.Equal(p_Agreement_rec.freight_terms_code,
2335: p_old_Agreement_rec.freight_terms_code)
2336: THEN
2337: l_Agreement_val_rec.freight_terms := QP_Id_To_Value.Freight_Terms

Line 2343: p_Agreement_rec.invoice_contact_id <> FND_API.G_MISS_NUM AND

2339: );
2340: END IF;
2341:
2342: IF p_Agreement_rec.invoice_contact_id IS NOT NULL AND
2343: p_Agreement_rec.invoice_contact_id <> FND_API.G_MISS_NUM AND
2344: NOT OE_GLOBALS.Equal(p_Agreement_rec.invoice_contact_id,
2345: p_old_Agreement_rec.invoice_contact_id)
2346: THEN
2347: l_Agreement_val_rec.invoice_contact := QP_Id_To_Value.Invoice_Contact

Line 2353: p_Agreement_rec.invoice_to_org_id <> FND_API.G_MISS_NUM AND

2349: );
2350: END IF;
2351:
2352: IF p_Agreement_rec.invoice_to_org_id IS NOT NULL AND
2353: p_Agreement_rec.invoice_to_org_id <> FND_API.G_MISS_NUM AND
2354: NOT OE_GLOBALS.Equal(p_Agreement_rec.invoice_to_org_id,
2355: p_old_Agreement_rec.invoice_to_org_id)
2356: THEN
2357: l_Agreement_val_rec.invoice_to_site_use := QP_Id_To_Value.Invoice_To_Site_Use

Line 2363: p_Agreement_rec.invoicing_rule_id <> FND_API.G_MISS_NUM AND

2359: );
2360: END IF;
2361:
2362: IF p_Agreement_rec.invoicing_rule_id IS NOT NULL AND
2363: p_Agreement_rec.invoicing_rule_id <> FND_API.G_MISS_NUM AND
2364: NOT OE_GLOBALS.Equal(p_Agreement_rec.invoicing_rule_id,
2365: p_old_Agreement_rec.invoicing_rule_id)
2366: THEN
2367: l_Agreement_val_rec.invoicing_rule := QP_Id_To_Value.Invoicing_Rule

Line 2373: p_Agreement_rec.override_arule_flag <> FND_API.G_MISS_CHAR AND

2369: );
2370: END IF;
2371:
2372: IF p_Agreement_rec.override_arule_flag IS NOT NULL AND
2373: p_Agreement_rec.override_arule_flag <> FND_API.G_MISS_CHAR AND
2374: NOT OE_GLOBALS.Equal(p_Agreement_rec.override_arule_flag,
2375: p_old_Agreement_rec.override_arule_flag)
2376: THEN
2377: l_Agreement_val_rec.override_arule := QP_Id_To_Value.Override_Arule

Line 2383: p_Agreement_rec.override_irule_flag <> FND_API.G_MISS_CHAR AND

2379: );
2380: END IF;
2381:
2382: IF p_Agreement_rec.override_irule_flag IS NOT NULL AND
2383: p_Agreement_rec.override_irule_flag <> FND_API.G_MISS_CHAR AND
2384: NOT OE_GLOBALS.Equal(p_Agreement_rec.override_irule_flag,
2385: p_old_Agreement_rec.override_irule_flag)
2386: THEN
2387: l_Agreement_val_rec.override_irule := QP_Id_To_Value.Override_Irule

Line 2393: p_Agreement_rec.price_list_id <> FND_API.G_MISS_NUM AND

2389: );
2390: END IF;
2391:
2392: IF p_Agreement_rec.price_list_id IS NOT NULL AND
2393: p_Agreement_rec.price_list_id <> FND_API.G_MISS_NUM AND
2394: NOT OE_GLOBALS.Equal(p_Agreement_rec.price_list_id,
2395: p_old_Agreement_rec.price_list_id)
2396: THEN
2397: l_Agreement_val_rec.price_list := QP_Id_To_Value.Price_List

Line 2403: p_Agreement_rec.revision_reason_code <> FND_API.G_MISS_CHAR AND

2399: );
2400: END IF;
2401:
2402: IF p_Agreement_rec.revision_reason_code IS NOT NULL AND
2403: p_Agreement_rec.revision_reason_code <> FND_API.G_MISS_CHAR AND
2404: NOT OE_GLOBALS.Equal(p_Agreement_rec.revision_reason_code,
2405: p_old_Agreement_rec.revision_reason_code)
2406: THEN
2407: l_Agreement_val_rec.revision_reason := QP_Id_To_Value.Revision_Reason

Line 2413: p_Agreement_rec.salesrep_id <> FND_API.G_MISS_NUM AND

2409: );
2410: END IF;
2411:
2412: IF p_Agreement_rec.salesrep_id IS NOT NULL AND
2413: p_Agreement_rec.salesrep_id <> FND_API.G_MISS_NUM AND
2414: NOT OE_GLOBALS.Equal(p_Agreement_rec.salesrep_id,
2415: p_old_Agreement_rec.salesrep_id)
2416: THEN
2417: l_Agreement_val_rec.salesrep := QP_Id_To_Value.Salesrep

Line 2423: p_Agreement_rec.ship_method_code <> FND_API.G_MISS_CHAR AND

2419: );
2420: END IF;
2421:
2422: IF p_Agreement_rec.ship_method_code IS NOT NULL AND
2423: p_Agreement_rec.ship_method_code <> FND_API.G_MISS_CHAR AND
2424: NOT OE_GLOBALS.Equal(p_Agreement_rec.ship_method_code,
2425: p_old_Agreement_rec.ship_method_code)
2426: THEN
2427: l_Agreement_val_rec.ship_method := QP_Id_To_Value.Ship_Method

Line 2433: p_Agreement_rec.term_id <> FND_API.G_MISS_NUM AND

2429: );
2430: END IF;
2431:
2432: IF p_Agreement_rec.term_id IS NOT NULL AND
2433: p_Agreement_rec.term_id <> FND_API.G_MISS_NUM AND
2434: NOT OE_GLOBALS.Equal(p_Agreement_rec.term_id,
2435: p_old_Agreement_rec.term_id)
2436: THEN
2437: l_Agreement_val_rec.term := QP_Id_To_Value.Term

Line 2444: p_Agreement_rec.agreement_source_code <> FND_API.G_MISS_CHAR AND

2440: END IF;
2441:
2442: --Begin code added by rchellam for OKC
2443: IF p_Agreement_rec.agreement_source_code IS NOT NULL AND
2444: p_Agreement_rec.agreement_source_code <> FND_API.G_MISS_CHAR AND
2445: NOT OE_GLOBALS.Equal(p_Agreement_rec.agreement_source_code,
2446: p_old_Agreement_rec.agreement_source_code)
2447: THEN
2448: l_Agreement_val_rec.agreement_source := QP_Id_To_Value.Agreement_Source

Line 2474: l_Agreement_rec.return_status := FND_API.G_RET_STS_SUCCESS;

2470: oe_debug_pub.add('Entering OE_Agreement_Util.Get_Ids');
2471:
2472: -- initialize return_status.
2473:
2474: l_Agreement_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2475:
2476: -- initialize l_Agreement_rec.
2477:
2478: l_Agreement_rec := p_Agreement_rec;

Line 2480: IF p_Agreement_val_rec.accounting_rule <> FND_API.G_MISS_CHAR

2476: -- initialize l_Agreement_rec.
2477:
2478: l_Agreement_rec := p_Agreement_rec;
2479:
2480: IF p_Agreement_val_rec.accounting_rule <> FND_API.G_MISS_CHAR
2481: THEN
2482:
2483: IF p_Agreement_rec.accounting_rule_id <> FND_API.G_MISS_NUM THEN
2484:

Line 2483: IF p_Agreement_rec.accounting_rule_id <> FND_API.G_MISS_NUM THEN

2479:
2480: IF p_Agreement_val_rec.accounting_rule <> FND_API.G_MISS_CHAR
2481: THEN
2482:
2483: IF p_Agreement_rec.accounting_rule_id <> FND_API.G_MISS_NUM THEN
2484:
2485: l_Agreement_rec.accounting_rule_id := p_Agreement_rec.accounting_rule_id;
2486:
2487: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2502: IF l_Agreement_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN

2498: l_Agreement_rec.accounting_rule_id := QP_Value_To_Id.accounting_rule
2499: ( p_accounting_rule => p_Agreement_val_rec.accounting_rule
2500: );
2501:
2502: IF l_Agreement_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN
2503: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2504: END IF;
2505:
2506: END IF;

Line 2503: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;

2499: ( p_accounting_rule => p_Agreement_val_rec.accounting_rule
2500: );
2501:
2502: IF l_Agreement_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN
2503: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2504: END IF;
2505:
2506: END IF;
2507:

Line 2510: IF p_Agreement_val_rec.agreement_contact <> FND_API.G_MISS_CHAR

2506: END IF;
2507:
2508: END IF;
2509:
2510: IF p_Agreement_val_rec.agreement_contact <> FND_API.G_MISS_CHAR
2511: THEN
2512:
2513: IF p_Agreement_rec.agreement_contact_id <> FND_API.G_MISS_NUM THEN
2514:

Line 2513: IF p_Agreement_rec.agreement_contact_id <> FND_API.G_MISS_NUM THEN

2509:
2510: IF p_Agreement_val_rec.agreement_contact <> FND_API.G_MISS_CHAR
2511: THEN
2512:
2513: IF p_Agreement_rec.agreement_contact_id <> FND_API.G_MISS_NUM THEN
2514:
2515: l_Agreement_rec.agreement_contact_id := p_Agreement_rec.agreement_contact_id;
2516:
2517: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2532: IF l_Agreement_rec.agreement_contact_id = FND_API.G_MISS_NUM THEN

2528: l_Agreement_rec.agreement_contact_id := QP_Value_To_Id.agreement_contact
2529: ( p_agreement_contact => p_Agreement_val_rec.agreement_contact
2530: );
2531:
2532: IF l_Agreement_rec.agreement_contact_id = FND_API.G_MISS_NUM THEN
2533: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2534: END IF;
2535:
2536: END IF;

Line 2533: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;

2529: ( p_agreement_contact => p_Agreement_val_rec.agreement_contact
2530: );
2531:
2532: IF l_Agreement_rec.agreement_contact_id = FND_API.G_MISS_NUM THEN
2533: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2534: END IF;
2535:
2536: END IF;
2537:

Line 2540: IF p_Agreement_val_rec.agreement <> FND_API.G_MISS_CHAR

2536: END IF;
2537:
2538: END IF;
2539:
2540: IF p_Agreement_val_rec.agreement <> FND_API.G_MISS_CHAR
2541: THEN
2542:
2543: IF p_Agreement_rec.agreement_id <> FND_API.G_MISS_NUM THEN
2544:

Line 2543: IF p_Agreement_rec.agreement_id <> FND_API.G_MISS_NUM THEN

2539:
2540: IF p_Agreement_val_rec.agreement <> FND_API.G_MISS_CHAR
2541: THEN
2542:
2543: IF p_Agreement_rec.agreement_id <> FND_API.G_MISS_NUM THEN
2544:
2545: l_Agreement_rec.agreement_id := p_Agreement_rec.agreement_id;
2546:
2547: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2562: IF l_Agreement_rec.agreement_id = FND_API.G_MISS_NUM THEN

2558: l_Agreement_rec.agreement_id := QP_Value_To_Id.agreement
2559: ( p_agreement => p_Agreement_val_rec.agreement
2560: );
2561:
2562: IF l_Agreement_rec.agreement_id = FND_API.G_MISS_NUM THEN
2563: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2564: END IF;
2565:
2566: END IF;

Line 2563: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;

2559: ( p_agreement => p_Agreement_val_rec.agreement
2560: );
2561:
2562: IF l_Agreement_rec.agreement_id = FND_API.G_MISS_NUM THEN
2563: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2564: END IF;
2565:
2566: END IF;
2567:

Line 2570: IF p_Agreement_val_rec.agreement_type <> FND_API.G_MISS_CHAR

2566: END IF;
2567:
2568: END IF;
2569:
2570: IF p_Agreement_val_rec.agreement_type <> FND_API.G_MISS_CHAR
2571: THEN
2572:
2573: IF p_Agreement_rec.agreement_type_code <> FND_API.G_MISS_CHAR THEN
2574:

Line 2573: IF p_Agreement_rec.agreement_type_code <> FND_API.G_MISS_CHAR THEN

2569:
2570: IF p_Agreement_val_rec.agreement_type <> FND_API.G_MISS_CHAR
2571: THEN
2572:
2573: IF p_Agreement_rec.agreement_type_code <> FND_API.G_MISS_CHAR THEN
2574:
2575: l_Agreement_rec.agreement_type_code := p_Agreement_rec.agreement_type_code;
2576:
2577: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2592: IF l_Agreement_rec.agreement_type_code = FND_API.G_MISS_CHAR THEN

2588: l_Agreement_rec.agreement_type_code := QP_Value_To_Id.agreement_type
2589: ( p_agreement_type => p_Agreement_val_rec.agreement_type
2590: );
2591:
2592: IF l_Agreement_rec.agreement_type_code = FND_API.G_MISS_CHAR THEN
2593: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2594: END IF;
2595:
2596: END IF;

Line 2593: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;

2589: ( p_agreement_type => p_Agreement_val_rec.agreement_type
2590: );
2591:
2592: IF l_Agreement_rec.agreement_type_code = FND_API.G_MISS_CHAR THEN
2593: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2594: END IF;
2595:
2596: END IF;
2597:

Line 2600: IF p_Agreement_val_rec.customer <> FND_API.G_MISS_CHAR

2596: END IF;
2597:
2598: END IF;
2599:
2600: IF p_Agreement_val_rec.customer <> FND_API.G_MISS_CHAR
2601: THEN
2602:
2603: IF p_Agreement_rec.sold_to_org_id <> FND_API.G_MISS_NUM THEN
2604:

Line 2603: IF p_Agreement_rec.sold_to_org_id <> FND_API.G_MISS_NUM THEN

2599:
2600: IF p_Agreement_val_rec.customer <> FND_API.G_MISS_CHAR
2601: THEN
2602:
2603: IF p_Agreement_rec.sold_to_org_id <> FND_API.G_MISS_NUM THEN
2604:
2605: l_Agreement_rec.sold_to_org_id := p_Agreement_rec.sold_to_org_id;
2606:
2607: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2622: IF l_Agreement_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN

2618: l_Agreement_rec.sold_to_org_id := QP_Value_To_Id.customer
2619: ( p_customer => p_Agreement_val_rec.customer
2620: );
2621:
2622: IF l_Agreement_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN
2623: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2624: END IF;
2625:
2626: END IF;

Line 2623: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;

2619: ( p_customer => p_Agreement_val_rec.customer
2620: );
2621:
2622: IF l_Agreement_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN
2623: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2624: END IF;
2625:
2626: END IF;
2627:

Line 2630: IF p_Agreement_val_rec.freight_terms <> FND_API.G_MISS_CHAR

2626: END IF;
2627:
2628: END IF;
2629:
2630: IF p_Agreement_val_rec.freight_terms <> FND_API.G_MISS_CHAR
2631: THEN
2632:
2633: IF p_Agreement_rec.freight_terms_code <> FND_API.G_MISS_CHAR THEN
2634:

Line 2633: IF p_Agreement_rec.freight_terms_code <> FND_API.G_MISS_CHAR THEN

2629:
2630: IF p_Agreement_val_rec.freight_terms <> FND_API.G_MISS_CHAR
2631: THEN
2632:
2633: IF p_Agreement_rec.freight_terms_code <> FND_API.G_MISS_CHAR THEN
2634:
2635: l_Agreement_rec.freight_terms_code := p_Agreement_rec.freight_terms_code;
2636:
2637: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2652: IF l_Agreement_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN

2648: l_Agreement_rec.freight_terms_code := QP_Value_To_Id.freight_terms
2649: ( p_freight_terms => p_Agreement_val_rec.freight_terms
2650: );
2651:
2652: IF l_Agreement_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
2653: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2654: END IF;
2655:
2656: END IF;

Line 2653: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;

2649: ( p_freight_terms => p_Agreement_val_rec.freight_terms
2650: );
2651:
2652: IF l_Agreement_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
2653: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2654: END IF;
2655:
2656: END IF;
2657:

Line 2660: IF p_Agreement_val_rec.invoice_contact <> FND_API.G_MISS_CHAR

2656: END IF;
2657:
2658: END IF;
2659:
2660: IF p_Agreement_val_rec.invoice_contact <> FND_API.G_MISS_CHAR
2661: THEN
2662:
2663: IF p_Agreement_rec.invoice_contact_id <> FND_API.G_MISS_NUM THEN
2664:

Line 2663: IF p_Agreement_rec.invoice_contact_id <> FND_API.G_MISS_NUM THEN

2659:
2660: IF p_Agreement_val_rec.invoice_contact <> FND_API.G_MISS_CHAR
2661: THEN
2662:
2663: IF p_Agreement_rec.invoice_contact_id <> FND_API.G_MISS_NUM THEN
2664:
2665: l_Agreement_rec.invoice_contact_id := p_Agreement_rec.invoice_contact_id;
2666:
2667: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2682: IF l_Agreement_rec.invoice_contact_id = FND_API.G_MISS_NUM THEN

2678: l_Agreement_rec.invoice_contact_id := QP_Value_To_Id.invoice_contact
2679: ( p_invoice_contact => p_Agreement_val_rec.invoice_contact
2680: );
2681:
2682: IF l_Agreement_rec.invoice_contact_id = FND_API.G_MISS_NUM THEN
2683: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2684: END IF;
2685:
2686: END IF;

Line 2683: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;

2679: ( p_invoice_contact => p_Agreement_val_rec.invoice_contact
2680: );
2681:
2682: IF l_Agreement_rec.invoice_contact_id = FND_API.G_MISS_NUM THEN
2683: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2684: END IF;
2685:
2686: END IF;
2687:

Line 2690: IF p_Agreement_val_rec.invoice_to_site_use <> FND_API.G_MISS_CHAR

2686: END IF;
2687:
2688: END IF;
2689:
2690: IF p_Agreement_val_rec.invoice_to_site_use <> FND_API.G_MISS_CHAR
2691: THEN
2692:
2693: IF p_Agreement_rec.invoice_to_org_id <> FND_API.G_MISS_NUM THEN
2694:

Line 2693: IF p_Agreement_rec.invoice_to_org_id <> FND_API.G_MISS_NUM THEN

2689:
2690: IF p_Agreement_val_rec.invoice_to_site_use <> FND_API.G_MISS_CHAR
2691: THEN
2692:
2693: IF p_Agreement_rec.invoice_to_org_id <> FND_API.G_MISS_NUM THEN
2694:
2695: l_Agreement_rec.invoice_to_org_id := p_Agreement_rec.invoice_to_org_id;
2696:
2697: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2712: IF l_Agreement_rec.invoice_to_org_id = FND_API.G_MISS_NUM THEN

2708: l_Agreement_rec.invoice_to_org_id := QP_Value_To_Id.invoice_to_site_use
2709: ( p_invoice_to_site_use => p_Agreement_val_rec.invoice_to_site_use
2710: );
2711:
2712: IF l_Agreement_rec.invoice_to_org_id = FND_API.G_MISS_NUM THEN
2713: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2714: END IF;
2715:
2716: END IF;

Line 2713: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;

2709: ( p_invoice_to_site_use => p_Agreement_val_rec.invoice_to_site_use
2710: );
2711:
2712: IF l_Agreement_rec.invoice_to_org_id = FND_API.G_MISS_NUM THEN
2713: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2714: END IF;
2715:
2716: END IF;
2717:

Line 2720: IF p_Agreement_val_rec.invoicing_rule <> FND_API.G_MISS_CHAR

2716: END IF;
2717:
2718: END IF;
2719:
2720: IF p_Agreement_val_rec.invoicing_rule <> FND_API.G_MISS_CHAR
2721: THEN
2722:
2723: IF p_Agreement_rec.invoicing_rule_id <> FND_API.G_MISS_NUM THEN
2724:

Line 2723: IF p_Agreement_rec.invoicing_rule_id <> FND_API.G_MISS_NUM THEN

2719:
2720: IF p_Agreement_val_rec.invoicing_rule <> FND_API.G_MISS_CHAR
2721: THEN
2722:
2723: IF p_Agreement_rec.invoicing_rule_id <> FND_API.G_MISS_NUM THEN
2724:
2725: l_Agreement_rec.invoicing_rule_id := p_Agreement_rec.invoicing_rule_id;
2726:
2727: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2742: IF l_Agreement_rec.invoicing_rule_id = FND_API.G_MISS_NUM THEN

2738: l_Agreement_rec.invoicing_rule_id := QP_Value_To_Id.invoicing_rule
2739: ( p_invoicing_rule => p_Agreement_val_rec.invoicing_rule
2740: );
2741:
2742: IF l_Agreement_rec.invoicing_rule_id = FND_API.G_MISS_NUM THEN
2743: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2744: END IF;
2745:
2746: END IF;

Line 2743: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;

2739: ( p_invoicing_rule => p_Agreement_val_rec.invoicing_rule
2740: );
2741:
2742: IF l_Agreement_rec.invoicing_rule_id = FND_API.G_MISS_NUM THEN
2743: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2744: END IF;
2745:
2746: END IF;
2747:

Line 2750: IF p_Agreement_val_rec.override_arule <> FND_API.G_MISS_CHAR

2746: END IF;
2747:
2748: END IF;
2749:
2750: IF p_Agreement_val_rec.override_arule <> FND_API.G_MISS_CHAR
2751: THEN
2752:
2753: IF p_Agreement_rec.override_arule_flag <> FND_API.G_MISS_CHAR THEN
2754:

Line 2753: IF p_Agreement_rec.override_arule_flag <> FND_API.G_MISS_CHAR THEN

2749:
2750: IF p_Agreement_val_rec.override_arule <> FND_API.G_MISS_CHAR
2751: THEN
2752:
2753: IF p_Agreement_rec.override_arule_flag <> FND_API.G_MISS_CHAR THEN
2754:
2755: l_Agreement_rec.override_arule_flag := p_Agreement_rec.override_arule_flag;
2756:
2757: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2772: IF l_Agreement_rec.override_arule_flag = FND_API.G_MISS_CHAR THEN

2768: l_Agreement_rec.override_arule_flag := QP_Value_To_Id.override_arule
2769: ( p_override_arule => p_Agreement_val_rec.override_arule
2770: );
2771:
2772: IF l_Agreement_rec.override_arule_flag = FND_API.G_MISS_CHAR THEN
2773: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2774: END IF;
2775:
2776: END IF;

Line 2773: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;

2769: ( p_override_arule => p_Agreement_val_rec.override_arule
2770: );
2771:
2772: IF l_Agreement_rec.override_arule_flag = FND_API.G_MISS_CHAR THEN
2773: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2774: END IF;
2775:
2776: END IF;
2777:

Line 2780: IF p_Agreement_val_rec.override_irule <> FND_API.G_MISS_CHAR

2776: END IF;
2777:
2778: END IF;
2779:
2780: IF p_Agreement_val_rec.override_irule <> FND_API.G_MISS_CHAR
2781: THEN
2782:
2783: IF p_Agreement_rec.override_irule_flag <> FND_API.G_MISS_CHAR THEN
2784:

Line 2783: IF p_Agreement_rec.override_irule_flag <> FND_API.G_MISS_CHAR THEN

2779:
2780: IF p_Agreement_val_rec.override_irule <> FND_API.G_MISS_CHAR
2781: THEN
2782:
2783: IF p_Agreement_rec.override_irule_flag <> FND_API.G_MISS_CHAR THEN
2784:
2785: l_Agreement_rec.override_irule_flag := p_Agreement_rec.override_irule_flag;
2786:
2787: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2802: IF l_Agreement_rec.override_irule_flag = FND_API.G_MISS_CHAR THEN

2798: l_Agreement_rec.override_irule_flag := QP_Value_To_Id.override_irule
2799: ( p_override_irule => p_Agreement_val_rec.override_irule
2800: );
2801:
2802: IF l_Agreement_rec.override_irule_flag = FND_API.G_MISS_CHAR THEN
2803: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2804: END IF;
2805:
2806: END IF;

Line 2803: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;

2799: ( p_override_irule => p_Agreement_val_rec.override_irule
2800: );
2801:
2802: IF l_Agreement_rec.override_irule_flag = FND_API.G_MISS_CHAR THEN
2803: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2804: END IF;
2805:
2806: END IF;
2807:

Line 2810: IF p_Agreement_val_rec.price_list <> FND_API.G_MISS_CHAR

2806: END IF;
2807:
2808: END IF;
2809:
2810: IF p_Agreement_val_rec.price_list <> FND_API.G_MISS_CHAR
2811: THEN
2812:
2813: IF p_Agreement_rec.price_list_id <> FND_API.G_MISS_NUM THEN
2814:

Line 2813: IF p_Agreement_rec.price_list_id <> FND_API.G_MISS_NUM THEN

2809:
2810: IF p_Agreement_val_rec.price_list <> FND_API.G_MISS_CHAR
2811: THEN
2812:
2813: IF p_Agreement_rec.price_list_id <> FND_API.G_MISS_NUM THEN
2814:
2815: l_Agreement_rec.price_list_id := p_Agreement_rec.price_list_id;
2816:
2817: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2832: IF l_Agreement_rec.price_list_id = FND_API.G_MISS_NUM THEN

2828: l_Agreement_rec.price_list_id := QP_Value_To_Id.price_list
2829: ( p_price_list => p_Agreement_val_rec.price_list
2830: );
2831:
2832: IF l_Agreement_rec.price_list_id = FND_API.G_MISS_NUM THEN
2833: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2834: END IF;
2835:
2836: END IF;

Line 2833: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;

2829: ( p_price_list => p_Agreement_val_rec.price_list
2830: );
2831:
2832: IF l_Agreement_rec.price_list_id = FND_API.G_MISS_NUM THEN
2833: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2834: END IF;
2835:
2836: END IF;
2837:

Line 2840: IF p_Agreement_val_rec.revision_reason <> FND_API.G_MISS_CHAR

2836: END IF;
2837:
2838: END IF;
2839:
2840: IF p_Agreement_val_rec.revision_reason <> FND_API.G_MISS_CHAR
2841: THEN
2842:
2843: IF p_Agreement_rec.revision_reason_code <> FND_API.G_MISS_CHAR THEN
2844:

Line 2843: IF p_Agreement_rec.revision_reason_code <> FND_API.G_MISS_CHAR THEN

2839:
2840: IF p_Agreement_val_rec.revision_reason <> FND_API.G_MISS_CHAR
2841: THEN
2842:
2843: IF p_Agreement_rec.revision_reason_code <> FND_API.G_MISS_CHAR THEN
2844:
2845: l_Agreement_rec.revision_reason_code := p_Agreement_rec.revision_reason_code;
2846:
2847: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2862: IF l_Agreement_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN

2858: l_Agreement_rec.revision_reason_code := QP_Value_To_Id.revision_reason
2859: ( p_revision_reason => p_Agreement_val_rec.revision_reason
2860: );
2861:
2862: IF l_Agreement_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
2863: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2864: END IF;
2865:
2866: END IF;

Line 2863: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;

2859: ( p_revision_reason => p_Agreement_val_rec.revision_reason
2860: );
2861:
2862: IF l_Agreement_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
2863: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2864: END IF;
2865:
2866: END IF;
2867:

Line 2870: IF p_Agreement_val_rec.salesrep <> FND_API.G_MISS_CHAR

2866: END IF;
2867:
2868: END IF;
2869:
2870: IF p_Agreement_val_rec.salesrep <> FND_API.G_MISS_CHAR
2871: THEN
2872:
2873: IF p_Agreement_rec.salesrep_id <> FND_API.G_MISS_NUM THEN
2874:

Line 2873: IF p_Agreement_rec.salesrep_id <> FND_API.G_MISS_NUM THEN

2869:
2870: IF p_Agreement_val_rec.salesrep <> FND_API.G_MISS_CHAR
2871: THEN
2872:
2873: IF p_Agreement_rec.salesrep_id <> FND_API.G_MISS_NUM THEN
2874:
2875: l_Agreement_rec.salesrep_id := p_Agreement_rec.salesrep_id;
2876:
2877: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2892: IF l_Agreement_rec.salesrep_id = FND_API.G_MISS_NUM THEN

2888: l_Agreement_rec.salesrep_id := QP_Value_To_Id.salesrep
2889: ( p_salesrep => p_Agreement_val_rec.salesrep
2890: );
2891:
2892: IF l_Agreement_rec.salesrep_id = FND_API.G_MISS_NUM THEN
2893: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2894: END IF;
2895:
2896: END IF;

Line 2893: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;

2889: ( p_salesrep => p_Agreement_val_rec.salesrep
2890: );
2891:
2892: IF l_Agreement_rec.salesrep_id = FND_API.G_MISS_NUM THEN
2893: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2894: END IF;
2895:
2896: END IF;
2897:

Line 2900: IF p_Agreement_val_rec.ship_method <> FND_API.G_MISS_CHAR

2896: END IF;
2897:
2898: END IF;
2899:
2900: IF p_Agreement_val_rec.ship_method <> FND_API.G_MISS_CHAR
2901: THEN
2902:
2903: IF p_Agreement_rec.ship_method_code <> FND_API.G_MISS_CHAR THEN
2904:

Line 2903: IF p_Agreement_rec.ship_method_code <> FND_API.G_MISS_CHAR THEN

2899:
2900: IF p_Agreement_val_rec.ship_method <> FND_API.G_MISS_CHAR
2901: THEN
2902:
2903: IF p_Agreement_rec.ship_method_code <> FND_API.G_MISS_CHAR THEN
2904:
2905: l_Agreement_rec.ship_method_code := p_Agreement_rec.ship_method_code;
2906:
2907: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2922: IF l_Agreement_rec.ship_method_code = FND_API.G_MISS_CHAR THEN

2918: l_Agreement_rec.ship_method_code := QP_Value_To_Id.ship_method
2919: ( p_ship_method => p_Agreement_val_rec.ship_method
2920: );
2921:
2922: IF l_Agreement_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
2923: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2924: END IF;
2925:
2926: END IF;

Line 2923: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;

2919: ( p_ship_method => p_Agreement_val_rec.ship_method
2920: );
2921:
2922: IF l_Agreement_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
2923: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2924: END IF;
2925:
2926: END IF;
2927:

Line 2930: IF p_Agreement_val_rec.term <> FND_API.G_MISS_CHAR

2926: END IF;
2927:
2928: END IF;
2929:
2930: IF p_Agreement_val_rec.term <> FND_API.G_MISS_CHAR
2931: THEN
2932:
2933: IF p_Agreement_rec.term_id <> FND_API.G_MISS_NUM THEN
2934:

Line 2933: IF p_Agreement_rec.term_id <> FND_API.G_MISS_NUM THEN

2929:
2930: IF p_Agreement_val_rec.term <> FND_API.G_MISS_CHAR
2931: THEN
2932:
2933: IF p_Agreement_rec.term_id <> FND_API.G_MISS_NUM THEN
2934:
2935: l_Agreement_rec.term_id := p_Agreement_rec.term_id;
2936:
2937: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2952: IF l_Agreement_rec.term_id = FND_API.G_MISS_NUM THEN

2948: l_Agreement_rec.term_id := QP_Value_To_Id.term
2949: ( p_term => p_Agreement_val_rec.term
2950: );
2951:
2952: IF l_Agreement_rec.term_id = FND_API.G_MISS_NUM THEN
2953: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2954: END IF;
2955:
2956: END IF;

Line 2953: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;

2949: ( p_term => p_Agreement_val_rec.term
2950: );
2951:
2952: IF l_Agreement_rec.term_id = FND_API.G_MISS_NUM THEN
2953: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2954: END IF;
2955:
2956: END IF;
2957:

Line 2961: IF p_Agreement_val_rec.agreement_source <> FND_API.G_MISS_CHAR

2957:
2958: END IF;
2959:
2960: --Begin code added by rchellam for OKC
2961: IF p_Agreement_val_rec.agreement_source <> FND_API.G_MISS_CHAR
2962: THEN
2963:
2964: IF p_Agreement_rec.agreement_source_code <> FND_API.G_MISS_CHAR THEN
2965:

Line 2964: IF p_Agreement_rec.agreement_source_code <> FND_API.G_MISS_CHAR THEN

2960: --Begin code added by rchellam for OKC
2961: IF p_Agreement_val_rec.agreement_source <> FND_API.G_MISS_CHAR
2962: THEN
2963:
2964: IF p_Agreement_rec.agreement_source_code <> FND_API.G_MISS_CHAR THEN
2965:
2966: l_Agreement_rec.agreement_source_code := p_Agreement_rec.agreement_source_code;
2967:
2968: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2983: IF l_Agreement_rec.agreement_source_code = FND_API.G_MISS_CHAR THEN

2979: l_Agreement_rec.agreement_source_code := QP_Value_To_Id.agreement_source
2980: ( p_agreement_source => p_Agreement_val_rec.agreement_source
2981: );
2982:
2983: IF l_Agreement_rec.agreement_source_code = FND_API.G_MISS_CHAR THEN
2984: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2985: END IF;
2986:
2987: END IF;

Line 2984: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;

2980: ( p_agreement_source => p_Agreement_val_rec.agreement_source
2981: );
2982:
2983: IF l_Agreement_rec.agreement_source_code = FND_API.G_MISS_CHAR THEN
2984: l_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2985: END IF;
2986:
2987: END IF;
2988: