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.QP_QUALIFIERS_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_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
13: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
14: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
15: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

Line 47: IF p_attr_id = FND_API.G_MISS_NUM THEN

43: -- If attr_id is missing compare old and new records and for
44: -- every changed attribute clear its dependent fields.
45:
46:
47: IF p_attr_id = FND_API.G_MISS_NUM THEN
48:
49: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute1,p_old_QUALIFIERS_rec.attribute1)
50: THEN
51: l_index := l_index + 1;

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

460: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
461: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
462: )
463: IS
464: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
465: BEGIN
466:
467:
468: oe_debug_pub.add('in apply attribute changes');

Line 707: IF l_QUALIFIERS_rec.attribute1 = FND_API.G_MISS_CHAR THEN

703: IS
704: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type := p_QUALIFIERS_rec;
705: BEGIN
706:
707: IF l_QUALIFIERS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
708: l_QUALIFIERS_rec.attribute1 := p_old_QUALIFIERS_rec.attribute1;
709: END IF;
710:
711: IF l_QUALIFIERS_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 711: IF l_QUALIFIERS_rec.attribute10 = FND_API.G_MISS_CHAR THEN

707: IF l_QUALIFIERS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
708: l_QUALIFIERS_rec.attribute1 := p_old_QUALIFIERS_rec.attribute1;
709: END IF;
710:
711: IF l_QUALIFIERS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
712: l_QUALIFIERS_rec.attribute10 := p_old_QUALIFIERS_rec.attribute10;
713: END IF;
714:
715: IF l_QUALIFIERS_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 715: IF l_QUALIFIERS_rec.attribute11 = FND_API.G_MISS_CHAR THEN

711: IF l_QUALIFIERS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
712: l_QUALIFIERS_rec.attribute10 := p_old_QUALIFIERS_rec.attribute10;
713: END IF;
714:
715: IF l_QUALIFIERS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
716: l_QUALIFIERS_rec.attribute11 := p_old_QUALIFIERS_rec.attribute11;
717: END IF;
718:
719: IF l_QUALIFIERS_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 719: IF l_QUALIFIERS_rec.attribute12 = FND_API.G_MISS_CHAR THEN

715: IF l_QUALIFIERS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
716: l_QUALIFIERS_rec.attribute11 := p_old_QUALIFIERS_rec.attribute11;
717: END IF;
718:
719: IF l_QUALIFIERS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
720: l_QUALIFIERS_rec.attribute12 := p_old_QUALIFIERS_rec.attribute12;
721: END IF;
722:
723: IF l_QUALIFIERS_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 723: IF l_QUALIFIERS_rec.attribute13 = FND_API.G_MISS_CHAR THEN

719: IF l_QUALIFIERS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
720: l_QUALIFIERS_rec.attribute12 := p_old_QUALIFIERS_rec.attribute12;
721: END IF;
722:
723: IF l_QUALIFIERS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
724: l_QUALIFIERS_rec.attribute13 := p_old_QUALIFIERS_rec.attribute13;
725: END IF;
726:
727: IF l_QUALIFIERS_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 727: IF l_QUALIFIERS_rec.attribute14 = FND_API.G_MISS_CHAR THEN

723: IF l_QUALIFIERS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
724: l_QUALIFIERS_rec.attribute13 := p_old_QUALIFIERS_rec.attribute13;
725: END IF;
726:
727: IF l_QUALIFIERS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
728: l_QUALIFIERS_rec.attribute14 := p_old_QUALIFIERS_rec.attribute14;
729: END IF;
730:
731: IF l_QUALIFIERS_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 731: IF l_QUALIFIERS_rec.attribute15 = FND_API.G_MISS_CHAR THEN

727: IF l_QUALIFIERS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
728: l_QUALIFIERS_rec.attribute14 := p_old_QUALIFIERS_rec.attribute14;
729: END IF;
730:
731: IF l_QUALIFIERS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
732: l_QUALIFIERS_rec.attribute15 := p_old_QUALIFIERS_rec.attribute15;
733: END IF;
734:
735: IF l_QUALIFIERS_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 735: IF l_QUALIFIERS_rec.attribute2 = FND_API.G_MISS_CHAR THEN

731: IF l_QUALIFIERS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
732: l_QUALIFIERS_rec.attribute15 := p_old_QUALIFIERS_rec.attribute15;
733: END IF;
734:
735: IF l_QUALIFIERS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
736: l_QUALIFIERS_rec.attribute2 := p_old_QUALIFIERS_rec.attribute2;
737: END IF;
738:
739: IF l_QUALIFIERS_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 739: IF l_QUALIFIERS_rec.attribute3 = FND_API.G_MISS_CHAR THEN

735: IF l_QUALIFIERS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
736: l_QUALIFIERS_rec.attribute2 := p_old_QUALIFIERS_rec.attribute2;
737: END IF;
738:
739: IF l_QUALIFIERS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
740: l_QUALIFIERS_rec.attribute3 := p_old_QUALIFIERS_rec.attribute3;
741: END IF;
742:
743: IF l_QUALIFIERS_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 743: IF l_QUALIFIERS_rec.attribute4 = FND_API.G_MISS_CHAR THEN

739: IF l_QUALIFIERS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
740: l_QUALIFIERS_rec.attribute3 := p_old_QUALIFIERS_rec.attribute3;
741: END IF;
742:
743: IF l_QUALIFIERS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
744: l_QUALIFIERS_rec.attribute4 := p_old_QUALIFIERS_rec.attribute4;
745: END IF;
746:
747: IF l_QUALIFIERS_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 747: IF l_QUALIFIERS_rec.attribute5 = FND_API.G_MISS_CHAR THEN

743: IF l_QUALIFIERS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
744: l_QUALIFIERS_rec.attribute4 := p_old_QUALIFIERS_rec.attribute4;
745: END IF;
746:
747: IF l_QUALIFIERS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
748: l_QUALIFIERS_rec.attribute5 := p_old_QUALIFIERS_rec.attribute5;
749: END IF;
750:
751: IF l_QUALIFIERS_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 751: IF l_QUALIFIERS_rec.attribute6 = FND_API.G_MISS_CHAR THEN

747: IF l_QUALIFIERS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
748: l_QUALIFIERS_rec.attribute5 := p_old_QUALIFIERS_rec.attribute5;
749: END IF;
750:
751: IF l_QUALIFIERS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
752: l_QUALIFIERS_rec.attribute6 := p_old_QUALIFIERS_rec.attribute6;
753: END IF;
754:
755: IF l_QUALIFIERS_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 755: IF l_QUALIFIERS_rec.attribute7 = FND_API.G_MISS_CHAR THEN

751: IF l_QUALIFIERS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
752: l_QUALIFIERS_rec.attribute6 := p_old_QUALIFIERS_rec.attribute6;
753: END IF;
754:
755: IF l_QUALIFIERS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
756: l_QUALIFIERS_rec.attribute7 := p_old_QUALIFIERS_rec.attribute7;
757: END IF;
758:
759: IF l_QUALIFIERS_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 759: IF l_QUALIFIERS_rec.attribute8 = FND_API.G_MISS_CHAR THEN

755: IF l_QUALIFIERS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
756: l_QUALIFIERS_rec.attribute7 := p_old_QUALIFIERS_rec.attribute7;
757: END IF;
758:
759: IF l_QUALIFIERS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
760: l_QUALIFIERS_rec.attribute8 := p_old_QUALIFIERS_rec.attribute8;
761: END IF;
762:
763: IF l_QUALIFIERS_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 763: IF l_QUALIFIERS_rec.attribute9 = FND_API.G_MISS_CHAR THEN

759: IF l_QUALIFIERS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
760: l_QUALIFIERS_rec.attribute8 := p_old_QUALIFIERS_rec.attribute8;
761: END IF;
762:
763: IF l_QUALIFIERS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
764: l_QUALIFIERS_rec.attribute9 := p_old_QUALIFIERS_rec.attribute9;
765: END IF;
766:
767: IF l_QUALIFIERS_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN

Line 767: IF l_QUALIFIERS_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN

763: IF l_QUALIFIERS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
764: l_QUALIFIERS_rec.attribute9 := p_old_QUALIFIERS_rec.attribute9;
765: END IF;
766:
767: IF l_QUALIFIERS_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN
768: l_QUALIFIERS_rec.comparison_operator_code := p_old_QUALIFIERS_rec.comparison_operator_code;
769: END IF;
770:
771: IF l_QUALIFIERS_rec.context = FND_API.G_MISS_CHAR THEN

Line 771: IF l_QUALIFIERS_rec.context = FND_API.G_MISS_CHAR THEN

767: IF l_QUALIFIERS_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN
768: l_QUALIFIERS_rec.comparison_operator_code := p_old_QUALIFIERS_rec.comparison_operator_code;
769: END IF;
770:
771: IF l_QUALIFIERS_rec.context = FND_API.G_MISS_CHAR THEN
772: l_QUALIFIERS_rec.context := p_old_QUALIFIERS_rec.context;
773: END IF;
774:
775: IF l_QUALIFIERS_rec.created_by = FND_API.G_MISS_NUM THEN

Line 775: IF l_QUALIFIERS_rec.created_by = FND_API.G_MISS_NUM THEN

771: IF l_QUALIFIERS_rec.context = FND_API.G_MISS_CHAR THEN
772: l_QUALIFIERS_rec.context := p_old_QUALIFIERS_rec.context;
773: END IF;
774:
775: IF l_QUALIFIERS_rec.created_by = FND_API.G_MISS_NUM THEN
776: l_QUALIFIERS_rec.created_by := p_old_QUALIFIERS_rec.created_by;
777: END IF;
778:
779: IF l_QUALIFIERS_rec.created_from_rule_id = FND_API.G_MISS_NUM THEN

Line 779: IF l_QUALIFIERS_rec.created_from_rule_id = FND_API.G_MISS_NUM THEN

775: IF l_QUALIFIERS_rec.created_by = FND_API.G_MISS_NUM THEN
776: l_QUALIFIERS_rec.created_by := p_old_QUALIFIERS_rec.created_by;
777: END IF;
778:
779: IF l_QUALIFIERS_rec.created_from_rule_id = FND_API.G_MISS_NUM THEN
780: l_QUALIFIERS_rec.created_from_rule_id := p_old_QUALIFIERS_rec.created_from_rule_id;
781: END IF;
782:
783: IF l_QUALIFIERS_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 783: IF l_QUALIFIERS_rec.creation_date = FND_API.G_MISS_DATE THEN

779: IF l_QUALIFIERS_rec.created_from_rule_id = FND_API.G_MISS_NUM THEN
780: l_QUALIFIERS_rec.created_from_rule_id := p_old_QUALIFIERS_rec.created_from_rule_id;
781: END IF;
782:
783: IF l_QUALIFIERS_rec.creation_date = FND_API.G_MISS_DATE THEN
784: l_QUALIFIERS_rec.creation_date := p_old_QUALIFIERS_rec.creation_date;
785: END IF;
786:
787: IF l_QUALIFIERS_rec.end_date_active = FND_API.G_MISS_DATE THEN

Line 787: IF l_QUALIFIERS_rec.end_date_active = FND_API.G_MISS_DATE THEN

783: IF l_QUALIFIERS_rec.creation_date = FND_API.G_MISS_DATE THEN
784: l_QUALIFIERS_rec.creation_date := p_old_QUALIFIERS_rec.creation_date;
785: END IF;
786:
787: IF l_QUALIFIERS_rec.end_date_active = FND_API.G_MISS_DATE THEN
788: l_QUALIFIERS_rec.end_date_active := p_old_QUALIFIERS_rec.end_date_active;
789: END IF;
790:
791: IF l_QUALIFIERS_rec.excluder_flag = FND_API.G_MISS_CHAR THEN

Line 791: IF l_QUALIFIERS_rec.excluder_flag = FND_API.G_MISS_CHAR THEN

787: IF l_QUALIFIERS_rec.end_date_active = FND_API.G_MISS_DATE THEN
788: l_QUALIFIERS_rec.end_date_active := p_old_QUALIFIERS_rec.end_date_active;
789: END IF;
790:
791: IF l_QUALIFIERS_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
792: l_QUALIFIERS_rec.excluder_flag := p_old_QUALIFIERS_rec.excluder_flag;
793: END IF;
794:
795: IF l_QUALIFIERS_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 795: IF l_QUALIFIERS_rec.last_updated_by = FND_API.G_MISS_NUM THEN

791: IF l_QUALIFIERS_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
792: l_QUALIFIERS_rec.excluder_flag := p_old_QUALIFIERS_rec.excluder_flag;
793: END IF;
794:
795: IF l_QUALIFIERS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
796: l_QUALIFIERS_rec.last_updated_by := p_old_QUALIFIERS_rec.last_updated_by;
797: END IF;
798:
799: IF l_QUALIFIERS_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 799: IF l_QUALIFIERS_rec.last_update_date = FND_API.G_MISS_DATE THEN

795: IF l_QUALIFIERS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
796: l_QUALIFIERS_rec.last_updated_by := p_old_QUALIFIERS_rec.last_updated_by;
797: END IF;
798:
799: IF l_QUALIFIERS_rec.last_update_date = FND_API.G_MISS_DATE THEN
800: l_QUALIFIERS_rec.last_update_date := p_old_QUALIFIERS_rec.last_update_date;
801: END IF;
802:
803: IF l_QUALIFIERS_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 803: IF l_QUALIFIERS_rec.last_update_login = FND_API.G_MISS_NUM THEN

799: IF l_QUALIFIERS_rec.last_update_date = FND_API.G_MISS_DATE THEN
800: l_QUALIFIERS_rec.last_update_date := p_old_QUALIFIERS_rec.last_update_date;
801: END IF;
802:
803: IF l_QUALIFIERS_rec.last_update_login = FND_API.G_MISS_NUM THEN
804: l_QUALIFIERS_rec.last_update_login := p_old_QUALIFIERS_rec.last_update_login;
805: END IF;
806:
807: IF l_QUALIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN

Line 807: IF l_QUALIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN

803: IF l_QUALIFIERS_rec.last_update_login = FND_API.G_MISS_NUM THEN
804: l_QUALIFIERS_rec.last_update_login := p_old_QUALIFIERS_rec.last_update_login;
805: END IF;
806:
807: IF l_QUALIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN
808: l_QUALIFIERS_rec.list_header_id := p_old_QUALIFIERS_rec.list_header_id;
809: END IF;
810:
811: IF l_QUALIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN

Line 811: IF l_QUALIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN

807: IF l_QUALIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN
808: l_QUALIFIERS_rec.list_header_id := p_old_QUALIFIERS_rec.list_header_id;
809: END IF;
810:
811: IF l_QUALIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN
812: l_QUALIFIERS_rec.list_line_id := p_old_QUALIFIERS_rec.list_line_id;
813: END IF;
814:
815: IF l_QUALIFIERS_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 815: IF l_QUALIFIERS_rec.program_application_id = FND_API.G_MISS_NUM THEN

811: IF l_QUALIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN
812: l_QUALIFIERS_rec.list_line_id := p_old_QUALIFIERS_rec.list_line_id;
813: END IF;
814:
815: IF l_QUALIFIERS_rec.program_application_id = FND_API.G_MISS_NUM THEN
816: l_QUALIFIERS_rec.program_application_id := p_old_QUALIFIERS_rec.program_application_id;
817: END IF;
818:
819: IF l_QUALIFIERS_rec.program_id = FND_API.G_MISS_NUM THEN

Line 819: IF l_QUALIFIERS_rec.program_id = FND_API.G_MISS_NUM THEN

815: IF l_QUALIFIERS_rec.program_application_id = FND_API.G_MISS_NUM THEN
816: l_QUALIFIERS_rec.program_application_id := p_old_QUALIFIERS_rec.program_application_id;
817: END IF;
818:
819: IF l_QUALIFIERS_rec.program_id = FND_API.G_MISS_NUM THEN
820: l_QUALIFIERS_rec.program_id := p_old_QUALIFIERS_rec.program_id;
821: END IF;
822:
823: IF l_QUALIFIERS_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 823: IF l_QUALIFIERS_rec.program_update_date = FND_API.G_MISS_DATE THEN

819: IF l_QUALIFIERS_rec.program_id = FND_API.G_MISS_NUM THEN
820: l_QUALIFIERS_rec.program_id := p_old_QUALIFIERS_rec.program_id;
821: END IF;
822:
823: IF l_QUALIFIERS_rec.program_update_date = FND_API.G_MISS_DATE THEN
824: l_QUALIFIERS_rec.program_update_date := p_old_QUALIFIERS_rec.program_update_date;
825: END IF;
826:
827: IF l_QUALIFIERS_rec.qualifier_attribute = FND_API.G_MISS_CHAR THEN

Line 827: IF l_QUALIFIERS_rec.qualifier_attribute = FND_API.G_MISS_CHAR THEN

823: IF l_QUALIFIERS_rec.program_update_date = FND_API.G_MISS_DATE THEN
824: l_QUALIFIERS_rec.program_update_date := p_old_QUALIFIERS_rec.program_update_date;
825: END IF;
826:
827: IF l_QUALIFIERS_rec.qualifier_attribute = FND_API.G_MISS_CHAR THEN
828: l_QUALIFIERS_rec.qualifier_attribute := p_old_QUALIFIERS_rec.qualifier_attribute;
829: END IF;
830:
831: IF l_QUALIFIERS_rec.qualifier_attr_value = FND_API.G_MISS_CHAR THEN

Line 831: IF l_QUALIFIERS_rec.qualifier_attr_value = FND_API.G_MISS_CHAR THEN

827: IF l_QUALIFIERS_rec.qualifier_attribute = FND_API.G_MISS_CHAR THEN
828: l_QUALIFIERS_rec.qualifier_attribute := p_old_QUALIFIERS_rec.qualifier_attribute;
829: END IF;
830:
831: IF l_QUALIFIERS_rec.qualifier_attr_value = FND_API.G_MISS_CHAR THEN
832: l_QUALIFIERS_rec.qualifier_attr_value := p_old_QUALIFIERS_rec.qualifier_attr_value;
833: END IF;
834: IF l_QUALIFIERS_rec.qualifier_attr_value_to = FND_API.G_MISS_CHAR THEN
835: l_QUALIFIERS_rec.qualifier_attr_value_to := p_old_QUALIFIERS_rec.qualifier_attr_value_to;

Line 834: IF l_QUALIFIERS_rec.qualifier_attr_value_to = FND_API.G_MISS_CHAR THEN

830:
831: IF l_QUALIFIERS_rec.qualifier_attr_value = FND_API.G_MISS_CHAR THEN
832: l_QUALIFIERS_rec.qualifier_attr_value := p_old_QUALIFIERS_rec.qualifier_attr_value;
833: END IF;
834: IF l_QUALIFIERS_rec.qualifier_attr_value_to = FND_API.G_MISS_CHAR THEN
835: l_QUALIFIERS_rec.qualifier_attr_value_to := p_old_QUALIFIERS_rec.qualifier_attr_value_to;
836: END IF;
837:
838: IF l_QUALIFIERS_rec.qualifier_context = FND_API.G_MISS_CHAR THEN

Line 838: IF l_QUALIFIERS_rec.qualifier_context = FND_API.G_MISS_CHAR THEN

834: IF l_QUALIFIERS_rec.qualifier_attr_value_to = FND_API.G_MISS_CHAR THEN
835: l_QUALIFIERS_rec.qualifier_attr_value_to := p_old_QUALIFIERS_rec.qualifier_attr_value_to;
836: END IF;
837:
838: IF l_QUALIFIERS_rec.qualifier_context = FND_API.G_MISS_CHAR THEN
839: l_QUALIFIERS_rec.qualifier_context := p_old_QUALIFIERS_rec.qualifier_context;
840: END IF;
841:
842: IF l_QUALIFIERS_rec.qualifier_datatype = FND_API.G_MISS_CHAR THEN

Line 842: IF l_QUALIFIERS_rec.qualifier_datatype = FND_API.G_MISS_CHAR THEN

838: IF l_QUALIFIERS_rec.qualifier_context = FND_API.G_MISS_CHAR THEN
839: l_QUALIFIERS_rec.qualifier_context := p_old_QUALIFIERS_rec.qualifier_context;
840: END IF;
841:
842: IF l_QUALIFIERS_rec.qualifier_datatype = FND_API.G_MISS_CHAR THEN
843: l_QUALIFIERS_rec.qualifier_datatype := p_old_QUALIFIERS_rec.qualifier_datatype;
844: END IF;
845:
846: /*IF l_QUALIFIERS_rec.qualifier_date_format = FND_API.G_MISS_CHAR THEN

Line 846: /*IF l_QUALIFIERS_rec.qualifier_date_format = FND_API.G_MISS_CHAR THEN

842: IF l_QUALIFIERS_rec.qualifier_datatype = FND_API.G_MISS_CHAR THEN
843: l_QUALIFIERS_rec.qualifier_datatype := p_old_QUALIFIERS_rec.qualifier_datatype;
844: END IF;
845:
846: /*IF l_QUALIFIERS_rec.qualifier_date_format = FND_API.G_MISS_CHAR THEN
847: l_QUALIFIERS_rec.qualifier_date_format := p_old_QUALIFIERS_rec.qualifier_date_format;
848: END IF;*/
849:
850: IF l_QUALIFIERS_rec.qualifier_grouping_no = FND_API.G_MISS_NUM THEN

Line 850: IF l_QUALIFIERS_rec.qualifier_grouping_no = FND_API.G_MISS_NUM THEN

846: /*IF l_QUALIFIERS_rec.qualifier_date_format = FND_API.G_MISS_CHAR THEN
847: l_QUALIFIERS_rec.qualifier_date_format := p_old_QUALIFIERS_rec.qualifier_date_format;
848: END IF;*/
849:
850: IF l_QUALIFIERS_rec.qualifier_grouping_no = FND_API.G_MISS_NUM THEN
851: l_QUALIFIERS_rec.qualifier_grouping_no := p_old_QUALIFIERS_rec.qualifier_grouping_no;
852: END IF;
853:
854: IF l_QUALIFIERS_rec.qualifier_id = FND_API.G_MISS_NUM THEN

Line 854: IF l_QUALIFIERS_rec.qualifier_id = FND_API.G_MISS_NUM THEN

850: IF l_QUALIFIERS_rec.qualifier_grouping_no = FND_API.G_MISS_NUM THEN
851: l_QUALIFIERS_rec.qualifier_grouping_no := p_old_QUALIFIERS_rec.qualifier_grouping_no;
852: END IF;
853:
854: IF l_QUALIFIERS_rec.qualifier_id = FND_API.G_MISS_NUM THEN
855: l_QUALIFIERS_rec.qualifier_id := p_old_QUALIFIERS_rec.qualifier_id;
856: END IF;
857:
858: /*IF l_QUALIFIERS_rec.qualifier_number_format = FND_API.G_MISS_CHAR THEN

Line 858: /*IF l_QUALIFIERS_rec.qualifier_number_format = FND_API.G_MISS_CHAR THEN

854: IF l_QUALIFIERS_rec.qualifier_id = FND_API.G_MISS_NUM THEN
855: l_QUALIFIERS_rec.qualifier_id := p_old_QUALIFIERS_rec.qualifier_id;
856: END IF;
857:
858: /*IF l_QUALIFIERS_rec.qualifier_number_format = FND_API.G_MISS_CHAR THEN
859: l_QUALIFIERS_rec.qualifier_number_format := p_old_QUALIFIERS_rec.qualifier_number_format;
860: END IF;*/
861:
862: IF l_QUALIFIERS_rec.qualifier_precedence = FND_API.G_MISS_NUM THEN

Line 862: IF l_QUALIFIERS_rec.qualifier_precedence = FND_API.G_MISS_NUM THEN

858: /*IF l_QUALIFIERS_rec.qualifier_number_format = FND_API.G_MISS_CHAR THEN
859: l_QUALIFIERS_rec.qualifier_number_format := p_old_QUALIFIERS_rec.qualifier_number_format;
860: END IF;*/
861:
862: IF l_QUALIFIERS_rec.qualifier_precedence = FND_API.G_MISS_NUM THEN
863: l_QUALIFIERS_rec.qualifier_precedence := p_old_QUALIFIERS_rec.qualifier_precedence;
864: END IF;
865:
866: IF l_QUALIFIERS_rec.qualifier_rule_id = FND_API.G_MISS_NUM THEN

Line 866: IF l_QUALIFIERS_rec.qualifier_rule_id = FND_API.G_MISS_NUM THEN

862: IF l_QUALIFIERS_rec.qualifier_precedence = FND_API.G_MISS_NUM THEN
863: l_QUALIFIERS_rec.qualifier_precedence := p_old_QUALIFIERS_rec.qualifier_precedence;
864: END IF;
865:
866: IF l_QUALIFIERS_rec.qualifier_rule_id = FND_API.G_MISS_NUM THEN
867: l_QUALIFIERS_rec.qualifier_rule_id := p_old_QUALIFIERS_rec.qualifier_rule_id;
868: END IF;
869:
870: IF l_QUALIFIERS_rec.request_id = FND_API.G_MISS_NUM THEN

Line 870: IF l_QUALIFIERS_rec.request_id = FND_API.G_MISS_NUM THEN

866: IF l_QUALIFIERS_rec.qualifier_rule_id = FND_API.G_MISS_NUM THEN
867: l_QUALIFIERS_rec.qualifier_rule_id := p_old_QUALIFIERS_rec.qualifier_rule_id;
868: END IF;
869:
870: IF l_QUALIFIERS_rec.request_id = FND_API.G_MISS_NUM THEN
871: l_QUALIFIERS_rec.request_id := p_old_QUALIFIERS_rec.request_id;
872: END IF;
873:
874: IF l_QUALIFIERS_rec.start_date_active = FND_API.G_MISS_DATE THEN

Line 874: IF l_QUALIFIERS_rec.start_date_active = FND_API.G_MISS_DATE THEN

870: IF l_QUALIFIERS_rec.request_id = FND_API.G_MISS_NUM THEN
871: l_QUALIFIERS_rec.request_id := p_old_QUALIFIERS_rec.request_id;
872: END IF;
873:
874: IF l_QUALIFIERS_rec.start_date_active = FND_API.G_MISS_DATE THEN
875: l_QUALIFIERS_rec.start_date_active := p_old_QUALIFIERS_rec.start_date_active;
876: END IF;
877: -- Added for TCA
878: IF l_QUALIFIERS_rec.qualify_hier_descendent_flag = FND_API.G_MISS_CHAR THEN

Line 878: IF l_QUALIFIERS_rec.qualify_hier_descendent_flag = FND_API.G_MISS_CHAR THEN

874: IF l_QUALIFIERS_rec.start_date_active = FND_API.G_MISS_DATE THEN
875: l_QUALIFIERS_rec.start_date_active := p_old_QUALIFIERS_rec.start_date_active;
876: END IF;
877: -- Added for TCA
878: IF l_QUALIFIERS_rec.qualify_hier_descendent_flag = FND_API.G_MISS_CHAR THEN
879: l_QUALIFIERS_rec.qualify_hier_descendent_flag := p_old_QUALIFIERS_rec.qualify_hier_descendent_flag;
880: END IF;
881:
882: RETURN l_QUALIFIERS_rec;

Line 895: IF l_QUALIFIERS_rec.attribute1 = FND_API.G_MISS_CHAR THEN

891: IS
892: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type := p_QUALIFIERS_rec;
893: BEGIN
894:
895: IF l_QUALIFIERS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
896: l_QUALIFIERS_rec.attribute1 := NULL;
897: END IF;
898:
899: IF l_QUALIFIERS_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 899: IF l_QUALIFIERS_rec.attribute10 = FND_API.G_MISS_CHAR THEN

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

Line 903: IF l_QUALIFIERS_rec.attribute11 = FND_API.G_MISS_CHAR THEN

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

Line 907: IF l_QUALIFIERS_rec.attribute12 = FND_API.G_MISS_CHAR THEN

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

Line 911: IF l_QUALIFIERS_rec.attribute13 = FND_API.G_MISS_CHAR THEN

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

Line 915: IF l_QUALIFIERS_rec.attribute14 = FND_API.G_MISS_CHAR THEN

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

Line 919: IF l_QUALIFIERS_rec.attribute15 = FND_API.G_MISS_CHAR THEN

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

Line 923: IF l_QUALIFIERS_rec.attribute2 = FND_API.G_MISS_CHAR THEN

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

Line 927: IF l_QUALIFIERS_rec.attribute3 = FND_API.G_MISS_CHAR THEN

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

Line 931: IF l_QUALIFIERS_rec.attribute4 = FND_API.G_MISS_CHAR THEN

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

Line 935: IF l_QUALIFIERS_rec.attribute5 = FND_API.G_MISS_CHAR THEN

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

Line 939: IF l_QUALIFIERS_rec.attribute6 = FND_API.G_MISS_CHAR THEN

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

Line 943: IF l_QUALIFIERS_rec.attribute7 = FND_API.G_MISS_CHAR THEN

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

Line 947: IF l_QUALIFIERS_rec.attribute8 = FND_API.G_MISS_CHAR THEN

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

Line 951: IF l_QUALIFIERS_rec.attribute9 = FND_API.G_MISS_CHAR THEN

947: IF l_QUALIFIERS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
948: l_QUALIFIERS_rec.attribute8 := NULL;
949: END IF;
950:
951: IF l_QUALIFIERS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
952: l_QUALIFIERS_rec.attribute9 := NULL;
953: END IF;
954:
955: IF l_QUALIFIERS_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN

Line 955: IF l_QUALIFIERS_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN

951: IF l_QUALIFIERS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
952: l_QUALIFIERS_rec.attribute9 := NULL;
953: END IF;
954:
955: IF l_QUALIFIERS_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN
956: l_QUALIFIERS_rec.comparison_operator_code := NULL;
957: END IF;
958:
959: IF l_QUALIFIERS_rec.context = FND_API.G_MISS_CHAR THEN

Line 959: IF l_QUALIFIERS_rec.context = FND_API.G_MISS_CHAR THEN

955: IF l_QUALIFIERS_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN
956: l_QUALIFIERS_rec.comparison_operator_code := NULL;
957: END IF;
958:
959: IF l_QUALIFIERS_rec.context = FND_API.G_MISS_CHAR THEN
960: l_QUALIFIERS_rec.context := NULL;
961: END IF;
962:
963: IF l_QUALIFIERS_rec.created_by = FND_API.G_MISS_NUM THEN

Line 963: IF l_QUALIFIERS_rec.created_by = FND_API.G_MISS_NUM THEN

959: IF l_QUALIFIERS_rec.context = FND_API.G_MISS_CHAR THEN
960: l_QUALIFIERS_rec.context := NULL;
961: END IF;
962:
963: IF l_QUALIFIERS_rec.created_by = FND_API.G_MISS_NUM THEN
964: l_QUALIFIERS_rec.created_by := NULL;
965: END IF;
966:
967: IF l_QUALIFIERS_rec.created_from_rule_id = FND_API.G_MISS_NUM THEN

Line 967: IF l_QUALIFIERS_rec.created_from_rule_id = FND_API.G_MISS_NUM THEN

963: IF l_QUALIFIERS_rec.created_by = FND_API.G_MISS_NUM THEN
964: l_QUALIFIERS_rec.created_by := NULL;
965: END IF;
966:
967: IF l_QUALIFIERS_rec.created_from_rule_id = FND_API.G_MISS_NUM THEN
968: l_QUALIFIERS_rec.created_from_rule_id := NULL;
969: END IF;
970:
971: IF l_QUALIFIERS_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 971: IF l_QUALIFIERS_rec.creation_date = FND_API.G_MISS_DATE THEN

967: IF l_QUALIFIERS_rec.created_from_rule_id = FND_API.G_MISS_NUM THEN
968: l_QUALIFIERS_rec.created_from_rule_id := NULL;
969: END IF;
970:
971: IF l_QUALIFIERS_rec.creation_date = FND_API.G_MISS_DATE THEN
972: l_QUALIFIERS_rec.creation_date := NULL;
973: END IF;
974:
975: IF l_QUALIFIERS_rec.end_date_active = FND_API.G_MISS_DATE THEN

Line 975: IF l_QUALIFIERS_rec.end_date_active = FND_API.G_MISS_DATE THEN

971: IF l_QUALIFIERS_rec.creation_date = FND_API.G_MISS_DATE THEN
972: l_QUALIFIERS_rec.creation_date := NULL;
973: END IF;
974:
975: IF l_QUALIFIERS_rec.end_date_active = FND_API.G_MISS_DATE THEN
976: l_QUALIFIERS_rec.end_date_active := NULL;
977: END IF;
978:
979: IF l_QUALIFIERS_rec.excluder_flag = FND_API.G_MISS_CHAR THEN

Line 979: IF l_QUALIFIERS_rec.excluder_flag = FND_API.G_MISS_CHAR THEN

975: IF l_QUALIFIERS_rec.end_date_active = FND_API.G_MISS_DATE THEN
976: l_QUALIFIERS_rec.end_date_active := NULL;
977: END IF;
978:
979: IF l_QUALIFIERS_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
980: l_QUALIFIERS_rec.excluder_flag := NULL;
981: END IF;
982:
983: IF l_QUALIFIERS_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 983: IF l_QUALIFIERS_rec.last_updated_by = FND_API.G_MISS_NUM THEN

979: IF l_QUALIFIERS_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
980: l_QUALIFIERS_rec.excluder_flag := NULL;
981: END IF;
982:
983: IF l_QUALIFIERS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
984: l_QUALIFIERS_rec.last_updated_by := NULL;
985: END IF;
986:
987: IF l_QUALIFIERS_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 987: IF l_QUALIFIERS_rec.last_update_date = FND_API.G_MISS_DATE THEN

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

Line 991: IF l_QUALIFIERS_rec.last_update_login = FND_API.G_MISS_NUM THEN

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

Line 995: IF l_QUALIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN

991: IF l_QUALIFIERS_rec.last_update_login = FND_API.G_MISS_NUM THEN
992: l_QUALIFIERS_rec.last_update_login := NULL;
993: END IF;
994:
995: IF l_QUALIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN
996: l_QUALIFIERS_rec.list_header_id := NULL;
997: END IF;
998:
999: IF l_QUALIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN

Line 999: IF l_QUALIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN

995: IF l_QUALIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN
996: l_QUALIFIERS_rec.list_header_id := NULL;
997: END IF;
998:
999: IF l_QUALIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN
1000: l_QUALIFIERS_rec.list_line_id := NULL;
1001: END IF;
1002:
1003: IF l_QUALIFIERS_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 1003: IF l_QUALIFIERS_rec.program_application_id = FND_API.G_MISS_NUM THEN

999: IF l_QUALIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN
1000: l_QUALIFIERS_rec.list_line_id := NULL;
1001: END IF;
1002:
1003: IF l_QUALIFIERS_rec.program_application_id = FND_API.G_MISS_NUM THEN
1004: l_QUALIFIERS_rec.program_application_id := NULL;
1005: END IF;
1006:
1007: IF l_QUALIFIERS_rec.program_id = FND_API.G_MISS_NUM THEN

Line 1007: IF l_QUALIFIERS_rec.program_id = FND_API.G_MISS_NUM THEN

1003: IF l_QUALIFIERS_rec.program_application_id = FND_API.G_MISS_NUM THEN
1004: l_QUALIFIERS_rec.program_application_id := NULL;
1005: END IF;
1006:
1007: IF l_QUALIFIERS_rec.program_id = FND_API.G_MISS_NUM THEN
1008: l_QUALIFIERS_rec.program_id := NULL;
1009: END IF;
1010:
1011: IF l_QUALIFIERS_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 1011: IF l_QUALIFIERS_rec.program_update_date = FND_API.G_MISS_DATE THEN

1007: IF l_QUALIFIERS_rec.program_id = FND_API.G_MISS_NUM THEN
1008: l_QUALIFIERS_rec.program_id := NULL;
1009: END IF;
1010:
1011: IF l_QUALIFIERS_rec.program_update_date = FND_API.G_MISS_DATE THEN
1012: l_QUALIFIERS_rec.program_update_date := NULL;
1013: END IF;
1014:
1015: IF l_QUALIFIERS_rec.qualifier_attribute = FND_API.G_MISS_CHAR THEN

Line 1015: IF l_QUALIFIERS_rec.qualifier_attribute = FND_API.G_MISS_CHAR THEN

1011: IF l_QUALIFIERS_rec.program_update_date = FND_API.G_MISS_DATE THEN
1012: l_QUALIFIERS_rec.program_update_date := NULL;
1013: END IF;
1014:
1015: IF l_QUALIFIERS_rec.qualifier_attribute = FND_API.G_MISS_CHAR THEN
1016: l_QUALIFIERS_rec.qualifier_attribute := NULL;
1017: END IF;
1018:
1019: IF l_QUALIFIERS_rec.qualifier_attr_value = FND_API.G_MISS_CHAR THEN

Line 1019: IF l_QUALIFIERS_rec.qualifier_attr_value = FND_API.G_MISS_CHAR THEN

1015: IF l_QUALIFIERS_rec.qualifier_attribute = FND_API.G_MISS_CHAR THEN
1016: l_QUALIFIERS_rec.qualifier_attribute := NULL;
1017: END IF;
1018:
1019: IF l_QUALIFIERS_rec.qualifier_attr_value = FND_API.G_MISS_CHAR THEN
1020: l_QUALIFIERS_rec.qualifier_attr_value := NULL;
1021: END IF;
1022:
1023: IF l_QUALIFIERS_rec.qualifier_attr_value_to = FND_API.G_MISS_CHAR THEN

Line 1023: IF l_QUALIFIERS_rec.qualifier_attr_value_to = FND_API.G_MISS_CHAR THEN

1019: IF l_QUALIFIERS_rec.qualifier_attr_value = FND_API.G_MISS_CHAR THEN
1020: l_QUALIFIERS_rec.qualifier_attr_value := NULL;
1021: END IF;
1022:
1023: IF l_QUALIFIERS_rec.qualifier_attr_value_to = FND_API.G_MISS_CHAR THEN
1024: l_QUALIFIERS_rec.qualifier_attr_value_to := NULL;
1025: END IF;
1026:
1027: IF l_QUALIFIERS_rec.qualifier_context = FND_API.G_MISS_CHAR THEN

Line 1027: IF l_QUALIFIERS_rec.qualifier_context = FND_API.G_MISS_CHAR THEN

1023: IF l_QUALIFIERS_rec.qualifier_attr_value_to = FND_API.G_MISS_CHAR THEN
1024: l_QUALIFIERS_rec.qualifier_attr_value_to := NULL;
1025: END IF;
1026:
1027: IF l_QUALIFIERS_rec.qualifier_context = FND_API.G_MISS_CHAR THEN
1028: l_QUALIFIERS_rec.qualifier_context := NULL;
1029: END IF;
1030:
1031: IF l_QUALIFIERS_rec.qualifier_datatype = FND_API.G_MISS_CHAR THEN

Line 1031: IF l_QUALIFIERS_rec.qualifier_datatype = FND_API.G_MISS_CHAR THEN

1027: IF l_QUALIFIERS_rec.qualifier_context = FND_API.G_MISS_CHAR THEN
1028: l_QUALIFIERS_rec.qualifier_context := NULL;
1029: END IF;
1030:
1031: IF l_QUALIFIERS_rec.qualifier_datatype = FND_API.G_MISS_CHAR THEN
1032: l_QUALIFIERS_rec.qualifier_datatype := NULL;
1033: END IF;
1034:
1035: /*IF l_QUALIFIERS_rec.qualifier_date_format = FND_API.G_MISS_CHAR THEN

Line 1035: /*IF l_QUALIFIERS_rec.qualifier_date_format = FND_API.G_MISS_CHAR THEN

1031: IF l_QUALIFIERS_rec.qualifier_datatype = FND_API.G_MISS_CHAR THEN
1032: l_QUALIFIERS_rec.qualifier_datatype := NULL;
1033: END IF;
1034:
1035: /*IF l_QUALIFIERS_rec.qualifier_date_format = FND_API.G_MISS_CHAR THEN
1036: l_QUALIFIERS_rec.qualifier_date_format := NULL;
1037: END IF;*/
1038:
1039: IF l_QUALIFIERS_rec.qualifier_grouping_no = FND_API.G_MISS_NUM THEN

Line 1039: IF l_QUALIFIERS_rec.qualifier_grouping_no = FND_API.G_MISS_NUM THEN

1035: /*IF l_QUALIFIERS_rec.qualifier_date_format = FND_API.G_MISS_CHAR THEN
1036: l_QUALIFIERS_rec.qualifier_date_format := NULL;
1037: END IF;*/
1038:
1039: IF l_QUALIFIERS_rec.qualifier_grouping_no = FND_API.G_MISS_NUM THEN
1040: l_QUALIFIERS_rec.qualifier_grouping_no := NULL;
1041: END IF;
1042:
1043: IF l_QUALIFIERS_rec.qualifier_id = FND_API.G_MISS_NUM THEN

Line 1043: IF l_QUALIFIERS_rec.qualifier_id = FND_API.G_MISS_NUM THEN

1039: IF l_QUALIFIERS_rec.qualifier_grouping_no = FND_API.G_MISS_NUM THEN
1040: l_QUALIFIERS_rec.qualifier_grouping_no := NULL;
1041: END IF;
1042:
1043: IF l_QUALIFIERS_rec.qualifier_id = FND_API.G_MISS_NUM THEN
1044: l_QUALIFIERS_rec.qualifier_id := NULL;
1045: END IF;
1046:
1047: /*IF l_QUALIFIERS_rec.qualifier_number_format = FND_API.G_MISS_CHAR THEN

Line 1047: /*IF l_QUALIFIERS_rec.qualifier_number_format = FND_API.G_MISS_CHAR THEN

1043: IF l_QUALIFIERS_rec.qualifier_id = FND_API.G_MISS_NUM THEN
1044: l_QUALIFIERS_rec.qualifier_id := NULL;
1045: END IF;
1046:
1047: /*IF l_QUALIFIERS_rec.qualifier_number_format = FND_API.G_MISS_CHAR THEN
1048: l_QUALIFIERS_rec.qualifier_number_format := NULL;
1049: END IF;*/
1050:
1051: IF l_QUALIFIERS_rec.qualifier_precedence = FND_API.G_MISS_NUM THEN

Line 1051: IF l_QUALIFIERS_rec.qualifier_precedence = FND_API.G_MISS_NUM THEN

1047: /*IF l_QUALIFIERS_rec.qualifier_number_format = FND_API.G_MISS_CHAR THEN
1048: l_QUALIFIERS_rec.qualifier_number_format := NULL;
1049: END IF;*/
1050:
1051: IF l_QUALIFIERS_rec.qualifier_precedence = FND_API.G_MISS_NUM THEN
1052: l_QUALIFIERS_rec.qualifier_precedence := NULL;
1053: END IF;
1054:
1055: IF l_QUALIFIERS_rec.qualifier_rule_id = FND_API.G_MISS_NUM THEN

Line 1055: IF l_QUALIFIERS_rec.qualifier_rule_id = FND_API.G_MISS_NUM THEN

1051: IF l_QUALIFIERS_rec.qualifier_precedence = FND_API.G_MISS_NUM THEN
1052: l_QUALIFIERS_rec.qualifier_precedence := NULL;
1053: END IF;
1054:
1055: IF l_QUALIFIERS_rec.qualifier_rule_id = FND_API.G_MISS_NUM THEN
1056: l_QUALIFIERS_rec.qualifier_rule_id := NULL;
1057: END IF;
1058:
1059: IF l_QUALIFIERS_rec.request_id = FND_API.G_MISS_NUM THEN

Line 1059: IF l_QUALIFIERS_rec.request_id = FND_API.G_MISS_NUM THEN

1055: IF l_QUALIFIERS_rec.qualifier_rule_id = FND_API.G_MISS_NUM THEN
1056: l_QUALIFIERS_rec.qualifier_rule_id := NULL;
1057: END IF;
1058:
1059: IF l_QUALIFIERS_rec.request_id = FND_API.G_MISS_NUM THEN
1060: l_QUALIFIERS_rec.request_id := NULL;
1061: END IF;
1062:
1063: IF l_QUALIFIERS_rec.start_date_active = FND_API.G_MISS_DATE THEN

Line 1063: IF l_QUALIFIERS_rec.start_date_active = FND_API.G_MISS_DATE THEN

1059: IF l_QUALIFIERS_rec.request_id = FND_API.G_MISS_NUM THEN
1060: l_QUALIFIERS_rec.request_id := NULL;
1061: END IF;
1062:
1063: IF l_QUALIFIERS_rec.start_date_active = FND_API.G_MISS_DATE THEN
1064: l_QUALIFIERS_rec.start_date_active := NULL;
1065: END IF;
1066: -- Added for TCA
1067: IF l_QUALIFIERS_rec.qualify_hier_descendent_flag = FND_API.G_MISS_CHAR THEN

Line 1067: IF l_QUALIFIERS_rec.qualify_hier_descendent_flag = FND_API.G_MISS_CHAR THEN

1063: IF l_QUALIFIERS_rec.start_date_active = FND_API.G_MISS_DATE THEN
1064: l_QUALIFIERS_rec.start_date_active := NULL;
1065: END IF;
1066: -- Added for TCA
1067: IF l_QUALIFIERS_rec.qualify_hier_descendent_flag = FND_API.G_MISS_CHAR THEN
1068: l_QUALIFIERS_rec.qualify_hier_descendent_flag := NULL;
1069: END IF;
1070:
1071: RETURN l_QUALIFIERS_rec;

Line 1198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1194: , 'Update_Row'
1195: );
1196: END IF;
1197:
1198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1199:
1200: END Update_Row;
1201:
1202: -- Procedure Update_coupon_Row Added for bug 7316016

Line 1228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1224: , 'Update_Coupon_Row'
1225: );
1226: END IF;
1227:
1228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1229: END Update_Coupon_Row;
1230:
1231: -- Procedure Insert_Row
1232:

Line 1481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1477: , 'Insert_Row'
1478: );
1479: END IF;
1480:
1481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1482:
1483: END Insert_Row;
1484:
1485: --This procedure will be used by HTML Qualifier UI

Line 1969: ( p_qualifier_id IN NUMBER := FND_API.G_MISS_NUM,

1965:
1966: -- Procedure Delete_Row
1967:
1968: PROCEDURE Delete_Row
1969: ( p_qualifier_id IN NUMBER := FND_API.G_MISS_NUM,
1970: p_qualifier_rule_id IN NUMBER := FND_API.G_MISS_NUM
1971: )
1972: IS
1973: --l_check_active_flag VARCHAR2(1);

Line 1970: p_qualifier_rule_id IN NUMBER := FND_API.G_MISS_NUM

1966: -- Procedure Delete_Row
1967:
1968: PROCEDURE Delete_Row
1969: ( p_qualifier_id IN NUMBER := FND_API.G_MISS_NUM,
1970: p_qualifier_rule_id IN NUMBER := FND_API.G_MISS_NUM
1971: )
1972: IS
1973: --l_check_active_flag VARCHAR2(1);
1974: --l_status VARCHAR2(1);

Line 1978: IF p_qualifier_rule_id <> FND_API.G_MISS_NUM

1974: --l_status VARCHAR2(1);
1975: --l_qualifiers_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1976: BEGIN
1977: -- l_qualifiers_rec:=Query_Row(p_qualifier_id);
1978: IF p_qualifier_rule_id <> FND_API.G_MISS_NUM
1979: THEN
1980:
1981: DELETE FROM QP_QUALIFIERS
1982: WHERE QUALIFIER_RULE_ID = p_qualifier_rule_id ;

Line 2025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2021: , 'Delete_Row'
2022: );
2023: END IF;
2024:
2025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2026:
2027: END Delete_Row;
2028:
2029: PROCEDURE Delete_Row(p_qual_grp_no IN NUMBER,

Line 2071: FND_API.G_MISS_NUM

2067: --
2068:
2069: FUNCTION Query_Rows
2070: ( p_qualifier_id IN NUMBER :=
2071: FND_API.G_MISS_NUM
2072: , p_qualifier_rule_id IN NUMBER :=
2073: FND_API.G_MISS_NUM
2074: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
2075: IS

Line 2073: FND_API.G_MISS_NUM

2069: FUNCTION Query_Rows
2070: ( p_qualifier_id IN NUMBER :=
2071: FND_API.G_MISS_NUM
2072: , p_qualifier_rule_id IN NUMBER :=
2073: FND_API.G_MISS_NUM
2074: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
2075: IS
2076: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2077: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 2143: p_qualifier_id <> FND_API.G_MISS_NUM)

2139:
2140: IF
2141: (p_qualifier_id IS NOT NULL
2142: AND
2143: p_qualifier_id <> FND_API.G_MISS_NUM)
2144: AND
2145: (p_qualifier_rule_id IS NOT NULL
2146: AND
2147: p_qualifier_rule_id <> FND_API.G_MISS_NUM)

Line 2147: p_qualifier_rule_id <> FND_API.G_MISS_NUM)

2143: p_qualifier_id <> FND_API.G_MISS_NUM)
2144: AND
2145: (p_qualifier_rule_id IS NOT NULL
2146: AND
2147: p_qualifier_rule_id <> FND_API.G_MISS_NUM)
2148: THEN
2149: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2150: THEN
2151: OE_MSG_PUB.Add_Exc_Msg

Line 2158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2154: , 'Keys are mutually exclusive: qualifier_id = '|| p_qualifier_id || ', qualifier_rule_id = '|| p_qualifier_rule_id
2155: );
2156: END IF;
2157:
2158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2159:
2160: END IF;
2161:
2162:

Line 2230: p_qualifier_id <> FND_API.G_MISS_NUM)

2226:
2227: IF
2228: (p_qualifier_id IS NOT NULL
2229: AND
2230: p_qualifier_id <> FND_API.G_MISS_NUM)
2231: AND
2232: (l_QUALIFIERS_tbl.COUNT = 0)
2233: THEN
2234: RAISE NO_DATA_FOUND;

Line 2244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2240: RETURN l_QUALIFIERS_tbl;
2241:
2242: EXCEPTION
2243:
2244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2245:
2246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2247:
2248: WHEN OTHERS THEN

Line 2246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2242: EXCEPTION
2243:
2244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2245:
2246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2247:
2248: WHEN OTHERS THEN
2249:
2250: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2254: , 'Query_Rows'
2255: );
2256: END IF;
2257:
2258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2259:
2260: END Query_Rows;
2261:
2262: -- Procedure lock_Row

Line 2551: OR (p_QUALIFIERS_rec.qualify_hier_descendent_flag = FND_API.G_MISS_CHAR

2547: l_QUALIFIERS_rec.start_date_active)
2548: -- Added for TCA
2549: AND (QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualify_hier_descendent_flag,
2550: l_QUALIFIERS_rec.qualify_hier_descendent_flag)
2551: OR (p_QUALIFIERS_rec.qualify_hier_descendent_flag = FND_API.G_MISS_CHAR
2552: and l_QUALIFIERS_rec.qualify_hier_descendent_flag is null))
2553: THEN
2554:
2555: -- Row has not changed. Set out parameter.

Line 2562: x_return_status := FND_API.G_RET_STS_SUCCESS;

2558: x_QUALIFIERS_rec := l_QUALIFIERS_rec;
2559:
2560: -- Set return status
2561:
2562: x_return_status := FND_API.G_RET_STS_SUCCESS;
2563: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2564:
2565: ELSE
2566:

Line 2563: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_SUCCESS;

2559:
2560: -- Set return status
2561:
2562: x_return_status := FND_API.G_RET_STS_SUCCESS;
2563: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2564:
2565: ELSE
2566:
2567: -- Row has changed by another user.

Line 2570: x_return_status := FND_API.G_RET_STS_ERROR;

2566:
2567: -- Row has changed by another user.
2568: oe_debug_pub.add('row changed');
2569:
2570: x_return_status := FND_API.G_RET_STS_ERROR;
2571: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2572:
2573: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2574: THEN

Line 2571: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;

2567: -- Row has changed by another user.
2568: oe_debug_pub.add('row changed');
2569:
2570: x_return_status := FND_API.G_RET_STS_ERROR;
2571: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2572:
2573: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2574: THEN
2575:

Line 2587: x_return_status := FND_API.G_RET_STS_ERROR;

2583: EXCEPTION
2584:
2585: WHEN NO_DATA_FOUND THEN
2586:
2587: x_return_status := FND_API.G_RET_STS_ERROR;
2588: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2589:
2590: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2591: THEN

Line 2588: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;

2584:
2585: WHEN NO_DATA_FOUND THEN
2586:
2587: x_return_status := FND_API.G_RET_STS_ERROR;
2588: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2589:
2590: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2591: THEN
2592:

Line 2600: x_return_status := FND_API.G_RET_STS_ERROR;

2596:
2597: END IF;
2598: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2599:
2600: x_return_status := FND_API.G_RET_STS_ERROR;
2601: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2602:
2603: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2604: THEN

Line 2601: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;

2597: END IF;
2598: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2599:
2600: x_return_status := FND_API.G_RET_STS_ERROR;
2601: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2602:
2603: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2604: THEN
2605:

Line 2612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2608:
2609: END IF;
2610: WHEN OTHERS THEN
2611:
2612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2613: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2614:
2615: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2616: THEN

Line 2613: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2609: END IF;
2610: WHEN OTHERS THEN
2611:
2612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2613: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2614:
2615: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2616: THEN
2617: OE_MSG_PUB.Add_Exc_Msg

Line 2637: p_QUALIFIERS_rec.comparison_operator_code <> FND_API.G_MISS_CHAR AND

2633: l_QUALIFIERS_val_rec QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type;
2634: BEGIN
2635:
2636: /*IF p_QUALIFIERS_rec.comparison_operator_code IS NOT NULL AND
2637: p_QUALIFIERS_rec.comparison_operator_code <> FND_API.G_MISS_CHAR AND
2638: NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.comparison_operator_code,
2639: p_old_QUALIFIERS_rec.comparison_operator_code)
2640: THEN
2641: l_QUALIFIERS_val_rec.comparison_operator := QP_Id_To_Value.Comparison_Operator

Line 2647: p_QUALIFIERS_rec.created_from_rule_id <> FND_API.G_MISS_NUM AND

2643: );
2644: END IF;*/
2645:
2646: IF p_QUALIFIERS_rec.created_from_rule_id IS NOT NULL AND
2647: p_QUALIFIERS_rec.created_from_rule_id <> FND_API.G_MISS_NUM AND
2648: NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_from_rule_id,
2649: p_old_QUALIFIERS_rec.created_from_rule_id)
2650: THEN
2651: l_QUALIFIERS_val_rec.created_from_rule := QP_Id_To_Value.Created_From_Rule

Line 2657: p_QUALIFIERS_rec.excluder_flag <> FND_API.G_MISS_CHAR AND

2653: );
2654: END IF;
2655:
2656: /* IF p_QUALIFIERS_rec.excluder_flag IS NOT NULL AND
2657: p_QUALIFIERS_rec.excluder_flag <> FND_API.G_MISS_CHAR AND
2658: NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.excluder_flag,
2659: p_old_QUALIFIERS_rec.excluder_flag)
2660: THEN
2661: l_QUALIFIERS_val_rec.excluder := QP_Id_To_Value.Excluder

Line 2667: p_QUALIFIERS_rec.list_header_id <> FND_API.G_MISS_NUM AND

2663: );
2664: END IF;*/
2665:
2666: IF p_QUALIFIERS_rec.list_header_id IS NOT NULL AND
2667: p_QUALIFIERS_rec.list_header_id <> FND_API.G_MISS_NUM AND
2668: NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_header_id,
2669: p_old_QUALIFIERS_rec.list_header_id)
2670: THEN
2671: l_QUALIFIERS_val_rec.list_header := QP_Id_To_Value.List_Header

Line 2677: p_QUALIFIERS_rec.list_line_id <> FND_API.G_MISS_NUM AND

2673: );
2674: END IF;
2675:
2676: IF p_QUALIFIERS_rec.list_line_id IS NOT NULL AND
2677: p_QUALIFIERS_rec.list_line_id <> FND_API.G_MISS_NUM AND
2678: NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_line_id,
2679: p_old_QUALIFIERS_rec.list_line_id)
2680: THEN
2681: l_QUALIFIERS_val_rec.list_line := QP_Id_To_Value.List_Line

Line 2687: p_QUALIFIERS_rec.qualifier_id <> FND_API.G_MISS_NUM AND

2683: );
2684: END IF;
2685:
2686: /*IF p_QUALIFIERS_rec.qualifier_id IS NOT NULL AND
2687: p_QUALIFIERS_rec.qualifier_id <> FND_API.G_MISS_NUM AND
2688: NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_id,
2689: p_old_QUALIFIERS_rec.qualifier_id)
2690: THEN
2691: l_QUALIFIERS_val_rec.qualifier := QP_Id_To_Value.Qualifier

Line 2697: p_QUALIFIERS_rec.qualifier_rule_id <> FND_API.G_MISS_NUM AND

2693: );
2694: END IF;*/
2695:
2696: IF p_QUALIFIERS_rec.qualifier_rule_id IS NOT NULL AND
2697: p_QUALIFIERS_rec.qualifier_rule_id <> FND_API.G_MISS_NUM AND
2698: NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_rule_id,
2699: p_old_QUALIFIERS_rec.qualifier_rule_id)
2700: THEN
2701: l_QUALIFIERS_val_rec.qualifier_rule := QP_Id_To_Value.Qualifier_Rule

Line 2722: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_SUCCESS;

2718: BEGIN
2719:
2720: -- initialize return_status.
2721:
2722: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2723:
2724: -- initialize l_QUALIFIERS_rec.
2725:
2726: l_QUALIFIERS_rec := p_QUALIFIERS_rec;

Line 2728: /* IF p_QUALIFIERS_val_rec.comparison_operator <> FND_API.G_MISS_CHAR

2724: -- initialize l_QUALIFIERS_rec.
2725:
2726: l_QUALIFIERS_rec := p_QUALIFIERS_rec;
2727:
2728: /* IF p_QUALIFIERS_val_rec.comparison_operator <> FND_API.G_MISS_CHAR
2729: THEN
2730:
2731: IF p_QUALIFIERS_rec.comparison_operator_code <> FND_API.G_MISS_CHAR THEN
2732:

Line 2731: IF p_QUALIFIERS_rec.comparison_operator_code <> FND_API.G_MISS_CHAR THEN

2727:
2728: /* IF p_QUALIFIERS_val_rec.comparison_operator <> FND_API.G_MISS_CHAR
2729: THEN
2730:
2731: IF p_QUALIFIERS_rec.comparison_operator_code <> FND_API.G_MISS_CHAR THEN
2732:
2733: l_QUALIFIERS_rec.comparison_operator_code := p_QUALIFIERS_rec.comparison_operator_code;
2734:
2735: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2750: IF l_QUALIFIERS_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN

2746: l_QUALIFIERS_rec.comparison_operator_code := QP_Value_To_Id.comparison_operator
2747: ( p_comparison_operator => p_QUALIFIERS_val_rec.comparison_operator
2748: );
2749:
2750: IF l_QUALIFIERS_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN
2751: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2752: END IF;
2753:
2754: END IF;

Line 2751: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;

2747: ( p_comparison_operator => p_QUALIFIERS_val_rec.comparison_operator
2748: );
2749:
2750: IF l_QUALIFIERS_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN
2751: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2752: END IF;
2753:
2754: END IF;
2755:

Line 2758: IF p_QUALIFIERS_val_rec.created_from_rule <> FND_API.G_MISS_CHAR

2754: END IF;
2755:
2756: END IF;*/
2757:
2758: IF p_QUALIFIERS_val_rec.created_from_rule <> FND_API.G_MISS_CHAR
2759: THEN
2760:
2761: IF p_QUALIFIERS_rec.created_from_rule_id <> FND_API.G_MISS_NUM THEN
2762:

Line 2761: IF p_QUALIFIERS_rec.created_from_rule_id <> FND_API.G_MISS_NUM THEN

2757:
2758: IF p_QUALIFIERS_val_rec.created_from_rule <> FND_API.G_MISS_CHAR
2759: THEN
2760:
2761: IF p_QUALIFIERS_rec.created_from_rule_id <> FND_API.G_MISS_NUM THEN
2762:
2763: l_QUALIFIERS_rec.created_from_rule_id := p_QUALIFIERS_rec.created_from_rule_id;
2764:
2765: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2780: IF l_QUALIFIERS_rec.created_from_rule_id = FND_API.G_MISS_NUM THEN

2776: l_QUALIFIERS_rec.created_from_rule_id := QP_Value_To_Id.created_from_rule
2777: ( p_created_from_rule => p_QUALIFIERS_val_rec.created_from_rule
2778: );
2779:
2780: IF l_QUALIFIERS_rec.created_from_rule_id = FND_API.G_MISS_NUM THEN
2781: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2782: END IF;
2783:
2784: END IF;

Line 2781: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;

2777: ( p_created_from_rule => p_QUALIFIERS_val_rec.created_from_rule
2778: );
2779:
2780: IF l_QUALIFIERS_rec.created_from_rule_id = FND_API.G_MISS_NUM THEN
2781: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2782: END IF;
2783:
2784: END IF;
2785:

Line 2788: /* IF p_QUALIFIERS_val_rec.excluder <> FND_API.G_MISS_CHAR

2784: END IF;
2785:
2786: END IF;
2787:
2788: /* IF p_QUALIFIERS_val_rec.excluder <> FND_API.G_MISS_CHAR
2789: THEN
2790:
2791: IF p_QUALIFIERS_rec.excluder_flag <> FND_API.G_MISS_CHAR THEN
2792:

Line 2791: IF p_QUALIFIERS_rec.excluder_flag <> FND_API.G_MISS_CHAR THEN

2787:
2788: /* IF p_QUALIFIERS_val_rec.excluder <> FND_API.G_MISS_CHAR
2789: THEN
2790:
2791: IF p_QUALIFIERS_rec.excluder_flag <> FND_API.G_MISS_CHAR THEN
2792:
2793: l_QUALIFIERS_rec.excluder_flag := p_QUALIFIERS_rec.excluder_flag;
2794:
2795: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2810: IF l_QUALIFIERS_rec.excluder_flag = FND_API.G_MISS_CHAR THEN

2806: l_QUALIFIERS_rec.excluder_flag := QP_Value_To_Id.excluder
2807: ( p_excluder => p_QUALIFIERS_val_rec.excluder
2808: );
2809:
2810: IF l_QUALIFIERS_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
2811: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2812: END IF;
2813:
2814: END IF;

Line 2811: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;

2807: ( p_excluder => p_QUALIFIERS_val_rec.excluder
2808: );
2809:
2810: IF l_QUALIFIERS_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
2811: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2812: END IF;
2813:
2814: END IF;
2815:

Line 2818: IF p_QUALIFIERS_val_rec.list_header <> FND_API.G_MISS_CHAR

2814: END IF;
2815:
2816: END IF;*/
2817:
2818: IF p_QUALIFIERS_val_rec.list_header <> FND_API.G_MISS_CHAR
2819: THEN
2820:
2821: IF p_QUALIFIERS_rec.list_header_id <> FND_API.G_MISS_NUM THEN
2822:

Line 2821: IF p_QUALIFIERS_rec.list_header_id <> FND_API.G_MISS_NUM THEN

2817:
2818: IF p_QUALIFIERS_val_rec.list_header <> FND_API.G_MISS_CHAR
2819: THEN
2820:
2821: IF p_QUALIFIERS_rec.list_header_id <> FND_API.G_MISS_NUM THEN
2822:
2823: l_QUALIFIERS_rec.list_header_id := p_QUALIFIERS_rec.list_header_id;
2824:
2825: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2840: IF l_QUALIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN

2836: l_QUALIFIERS_rec.list_header_id := QP_Value_To_Id.list_header
2837: ( p_list_header => p_QUALIFIERS_val_rec.list_header
2838: );
2839:
2840: IF l_QUALIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN
2841: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2842: END IF;
2843:
2844: END IF;

Line 2841: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;

2837: ( p_list_header => p_QUALIFIERS_val_rec.list_header
2838: );
2839:
2840: IF l_QUALIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN
2841: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2842: END IF;
2843:
2844: END IF;
2845:

Line 2848: IF p_QUALIFIERS_val_rec.list_line <> FND_API.G_MISS_CHAR

2844: END IF;
2845:
2846: END IF;
2847:
2848: IF p_QUALIFIERS_val_rec.list_line <> FND_API.G_MISS_CHAR
2849: THEN
2850:
2851: IF p_QUALIFIERS_rec.list_line_id <> FND_API.G_MISS_NUM THEN
2852:

Line 2851: IF p_QUALIFIERS_rec.list_line_id <> FND_API.G_MISS_NUM THEN

2847:
2848: IF p_QUALIFIERS_val_rec.list_line <> FND_API.G_MISS_CHAR
2849: THEN
2850:
2851: IF p_QUALIFIERS_rec.list_line_id <> FND_API.G_MISS_NUM THEN
2852:
2853: l_QUALIFIERS_rec.list_line_id := p_QUALIFIERS_rec.list_line_id;
2854:
2855: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2870: IF l_QUALIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN

2866: l_QUALIFIERS_rec.list_line_id := QP_Value_To_Id.list_line
2867: ( p_list_line => p_QUALIFIERS_val_rec.list_line
2868: );
2869:
2870: IF l_QUALIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN
2871: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2872: END IF;
2873:
2874: END IF;

Line 2871: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;

2867: ( p_list_line => p_QUALIFIERS_val_rec.list_line
2868: );
2869:
2870: IF l_QUALIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN
2871: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2872: END IF;
2873:
2874: END IF;
2875:

Line 2878: /* IF p_QUALIFIERS_val_rec.qualifier <> FND_API.G_MISS_CHAR

2874: END IF;
2875:
2876: END IF;
2877:
2878: /* IF p_QUALIFIERS_val_rec.qualifier <> FND_API.G_MISS_CHAR
2879: THEN
2880:
2881: IF p_QUALIFIERS_rec.qualifier_id <> FND_API.G_MISS_NUM THEN
2882:

Line 2881: IF p_QUALIFIERS_rec.qualifier_id <> FND_API.G_MISS_NUM THEN

2877:
2878: /* IF p_QUALIFIERS_val_rec.qualifier <> FND_API.G_MISS_CHAR
2879: THEN
2880:
2881: IF p_QUALIFIERS_rec.qualifier_id <> FND_API.G_MISS_NUM THEN
2882:
2883: l_QUALIFIERS_rec.qualifier_id := p_QUALIFIERS_rec.qualifier_id;
2884:
2885: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2900: IF l_QUALIFIERS_rec.qualifier_id = FND_API.G_MISS_NUM THEN

2896: l_QUALIFIERS_rec.qualifier_id := QP_Value_To_Id.qualifier
2897: ( p_qualifier => p_QUALIFIERS_val_rec.qualifier
2898: );
2899:
2900: IF l_QUALIFIERS_rec.qualifier_id = FND_API.G_MISS_NUM THEN
2901: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2902: END IF;
2903:
2904: END IF;

Line 2901: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;

2897: ( p_qualifier => p_QUALIFIERS_val_rec.qualifier
2898: );
2899:
2900: IF l_QUALIFIERS_rec.qualifier_id = FND_API.G_MISS_NUM THEN
2901: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2902: END IF;
2903:
2904: END IF;
2905:

Line 2908: IF p_QUALIFIERS_val_rec.qualifier_rule <> FND_API.G_MISS_CHAR

2904: END IF;
2905:
2906: END IF;*/
2907:
2908: IF p_QUALIFIERS_val_rec.qualifier_rule <> FND_API.G_MISS_CHAR
2909: THEN
2910:
2911: IF p_QUALIFIERS_rec.qualifier_rule_id <> FND_API.G_MISS_NUM THEN
2912:

Line 2911: IF p_QUALIFIERS_rec.qualifier_rule_id <> FND_API.G_MISS_NUM THEN

2907:
2908: IF p_QUALIFIERS_val_rec.qualifier_rule <> FND_API.G_MISS_CHAR
2909: THEN
2910:
2911: IF p_QUALIFIERS_rec.qualifier_rule_id <> FND_API.G_MISS_NUM THEN
2912:
2913: l_QUALIFIERS_rec.qualifier_rule_id := p_QUALIFIERS_rec.qualifier_rule_id;
2914:
2915: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2930: IF l_QUALIFIERS_rec.qualifier_rule_id = FND_API.G_MISS_NUM THEN

2926: l_QUALIFIERS_rec.qualifier_rule_id := QP_Value_To_Id.qualifier_rule
2927: ( p_qualifier_rule => p_QUALIFIERS_val_rec.qualifier_rule
2928: );
2929:
2930: IF l_QUALIFIERS_rec.qualifier_rule_id = FND_API.G_MISS_NUM THEN
2931: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2932: END IF;
2933:
2934: END IF;

Line 2931: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;

2927: ( p_qualifier_rule => p_QUALIFIERS_val_rec.qualifier_rule
2928: );
2929:
2930: IF l_QUALIFIERS_rec.qualifier_rule_id = FND_API.G_MISS_NUM THEN
2931: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2932: END IF;
2933:
2934: END IF;
2935:

Line 2943: IF p_QUALIFIERS_val_rec.qualifier_attribute_desc <> FND_API.G_MISS_CHAR

2939: Added code for value_to_id conversion for qualifier_attribute,
2940: qualifier_attr_value and qualifier_attr_value_to
2941: ***************************************************************************/
2942:
2943: IF p_QUALIFIERS_val_rec.qualifier_attribute_desc <> FND_API.G_MISS_CHAR
2944: THEN
2945:
2946: IF p_QUALIFIERS_rec.qualifier_attribute <> FND_API.G_MISS_CHAR THEN
2947:

Line 2946: IF p_QUALIFIERS_rec.qualifier_attribute <> FND_API.G_MISS_CHAR THEN

2942:
2943: IF p_QUALIFIERS_val_rec.qualifier_attribute_desc <> FND_API.G_MISS_CHAR
2944: THEN
2945:
2946: IF p_QUALIFIERS_rec.qualifier_attribute <> FND_API.G_MISS_CHAR THEN
2947:
2948: l_QUALIFIERS_rec.qualifier_attribute := p_QUALIFIERS_rec.qualifier_attribute;
2949:
2950: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2966: IF l_QUALIFIERS_rec.qualifier_attribute = FND_API.G_MISS_CHAR THEN

2962: ( p_qualifier_attribute_desc => p_QUALIFIERS_val_rec.qualifier_attribute_desc,
2963: p_context => l_QUALIFIERS_rec.qualifier_context
2964: );
2965:
2966: IF l_QUALIFIERS_rec.qualifier_attribute = FND_API.G_MISS_CHAR THEN
2967: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2968: END IF;
2969:
2970: END IF;

Line 2967: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;

2963: p_context => l_QUALIFIERS_rec.qualifier_context
2964: );
2965:
2966: IF l_QUALIFIERS_rec.qualifier_attribute = FND_API.G_MISS_CHAR THEN
2967: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2968: END IF;
2969:
2970: END IF;
2971:

Line 2974: IF p_QUALIFIERS_val_rec.qualifier_attr_value_desc <> FND_API.G_MISS_CHAR

2970: END IF;
2971:
2972: END IF;
2973:
2974: IF p_QUALIFIERS_val_rec.qualifier_attr_value_desc <> FND_API.G_MISS_CHAR
2975: THEN
2976:
2977: IF p_QUALIFIERS_rec.qualifier_attr_value <> FND_API.G_MISS_CHAR THEN
2978:

Line 2977: IF p_QUALIFIERS_rec.qualifier_attr_value <> FND_API.G_MISS_CHAR THEN

2973:
2974: IF p_QUALIFIERS_val_rec.qualifier_attr_value_desc <> FND_API.G_MISS_CHAR
2975: THEN
2976:
2977: IF p_QUALIFIERS_rec.qualifier_attr_value <> FND_API.G_MISS_CHAR THEN
2978:
2979: l_QUALIFIERS_rec.qualifier_attr_value := p_QUALIFIERS_rec.qualifier_attr_value;
2980:
2981: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2998: IF l_QUALIFIERS_rec.qualifier_attr_value = FND_API.G_MISS_CHAR THEN

2994: p_context => l_QUALIFIERS_rec.qualifier_context,
2995: p_attribute => l_QUALIFIERS_rec.qualifier_attribute
2996: );
2997:
2998: IF l_QUALIFIERS_rec.qualifier_attr_value = FND_API.G_MISS_CHAR THEN
2999: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
3000: END IF;
3001:
3002: END IF;

Line 2999: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;

2995: p_attribute => l_QUALIFIERS_rec.qualifier_attribute
2996: );
2997:
2998: IF l_QUALIFIERS_rec.qualifier_attr_value = FND_API.G_MISS_CHAR THEN
2999: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
3000: END IF;
3001:
3002: END IF;
3003:

Line 3006: IF p_QUALIFIERS_val_rec.qualifier_attr_value_to_desc <> FND_API.G_MISS_CHAR

3002: END IF;
3003:
3004: END IF;
3005:
3006: IF p_QUALIFIERS_val_rec.qualifier_attr_value_to_desc <> FND_API.G_MISS_CHAR
3007: THEN
3008:
3009: IF p_QUALIFIERS_rec.qualifier_attr_value_to <> FND_API.G_MISS_CHAR THEN
3010:

Line 3009: IF p_QUALIFIERS_rec.qualifier_attr_value_to <> FND_API.G_MISS_CHAR THEN

3005:
3006: IF p_QUALIFIERS_val_rec.qualifier_attr_value_to_desc <> FND_API.G_MISS_CHAR
3007: THEN
3008:
3009: IF p_QUALIFIERS_rec.qualifier_attr_value_to <> FND_API.G_MISS_CHAR THEN
3010:
3011: l_QUALIFIERS_rec.qualifier_attr_value_to := p_QUALIFIERS_rec.qualifier_attr_value_to;
3012:
3013: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 3030: IF l_QUALIFIERS_rec.qualifier_attr_value_to = FND_API.G_MISS_CHAR THEN

3026: p_context => l_QUALIFIERS_rec.qualifier_context,
3027: p_attribute => l_QUALIFIERS_rec.qualifier_attribute
3028: );
3029:
3030: IF l_QUALIFIERS_rec.qualifier_attr_value_to = FND_API.G_MISS_CHAR THEN
3031: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
3032: END IF;
3033:
3034: END IF;

Line 3031: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;

3027: p_attribute => l_QUALIFIERS_rec.qualifier_attribute
3028: );
3029:
3030: IF l_QUALIFIERS_rec.qualifier_attr_value_to = FND_API.G_MISS_CHAR THEN
3031: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
3032: END IF;
3033:
3034: END IF;
3035:

Line 3619: WHEN FND_API.G_EXC_ERROR THEN

3615: END IF; --Java Engine Installed
3616: --pattern
3617:
3618: EXCEPTION
3619: WHEN FND_API.G_EXC_ERROR THEN
3620: RAISE;
3621: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3622: RAISE;
3623: WHEN OTHERS THEN

Line 3621: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3617:
3618: EXCEPTION
3619: WHEN FND_API.G_EXC_ERROR THEN
3620: RAISE;
3621: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3622: RAISE;
3623: WHEN OTHERS THEN
3624: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
3625: THEN

Line 3631: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3627: ( G_PKG_NAME
3628: , 'Pre_Write_Process'
3629: );
3630: END IF;
3631: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3632: END Pre_Write_Process;
3633:
3634: END QP_Qualifiers_Util;