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.

[Home] [Help]

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: -- Procedure Update_coupon_Row Added for bug 7316016
1202:

Line 1227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 1969: p_qualifier_rule_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 1977: IF p_qualifier_rule_id <> FND_API.G_MISS_NUM

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

Line 2024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2070: FND_API.G_MISS_NUM

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

Line 2072: FND_API.G_MISS_NUM

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

Line 2142: p_qualifier_id <> FND_API.G_MISS_NUM)

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

Line 2146: p_qualifier_rule_id <> FND_API.G_MISS_NUM)

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

Line 2157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2229: p_qualifier_id <> FND_API.G_MISS_NUM)

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

Line 2243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 2561: x_return_status := FND_API.G_RET_STS_SUCCESS;

2557: x_QUALIFIERS_rec := l_QUALIFIERS_rec;
2558:
2559: -- Set return status
2560:
2561: x_return_status := FND_API.G_RET_STS_SUCCESS;
2562: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2563:
2564: ELSE
2565: --8594682 - Add debug messages for OE_LOCK error

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

2558:
2559: -- Set return status
2560:
2561: x_return_status := FND_API.G_RET_STS_SUCCESS;
2562: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2563:
2564: ELSE
2565: --8594682 - Add debug messages for OE_LOCK error
2566: oe_debug_pub.ADD('-------------------Data compare in Price list line Qualifier(database vs record)------------------');

Line 2616: x_return_status := FND_API.G_RET_STS_ERROR;

2612:
2613: -- Row has changed by another user.
2614: oe_debug_pub.add('row changed');
2615:
2616: x_return_status := FND_API.G_RET_STS_ERROR;
2617: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2618:
2619: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2620: THEN

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

2613: -- Row has changed by another user.
2614: oe_debug_pub.add('row changed');
2615:
2616: x_return_status := FND_API.G_RET_STS_ERROR;
2617: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2618:
2619: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2620: THEN
2621:

Line 2633: x_return_status := FND_API.G_RET_STS_ERROR;

2629: EXCEPTION
2630:
2631: WHEN NO_DATA_FOUND THEN
2632:
2633: x_return_status := FND_API.G_RET_STS_ERROR;
2634: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2635:
2636: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2637: THEN

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

2630:
2631: WHEN NO_DATA_FOUND THEN
2632:
2633: x_return_status := FND_API.G_RET_STS_ERROR;
2634: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2635:
2636: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2637: THEN
2638:

Line 2646: x_return_status := FND_API.G_RET_STS_ERROR;

2642:
2643: END IF;
2644: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2645:
2646: x_return_status := FND_API.G_RET_STS_ERROR;
2647: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2648:
2649: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2650: THEN

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

2643: END IF;
2644: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2645:
2646: x_return_status := FND_API.G_RET_STS_ERROR;
2647: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2648:
2649: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2650: THEN
2651:

Line 2658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2654:
2655: END IF;
2656: WHEN OTHERS THEN
2657:
2658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2659: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2660:
2661: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2662: THEN

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

2655: END IF;
2656: WHEN OTHERS THEN
2657:
2658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2659: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2660:
2661: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2662: THEN
2663: OE_MSG_PUB.Add_Exc_Msg

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

2679: l_QUALIFIERS_val_rec QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type;
2680: BEGIN
2681:
2682: /*IF p_QUALIFIERS_rec.comparison_operator_code IS NOT NULL AND
2683: p_QUALIFIERS_rec.comparison_operator_code <> FND_API.G_MISS_CHAR AND
2684: NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.comparison_operator_code,
2685: p_old_QUALIFIERS_rec.comparison_operator_code)
2686: THEN
2687: l_QUALIFIERS_val_rec.comparison_operator := QP_Id_To_Value.Comparison_Operator

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

2689: );
2690: END IF;*/
2691:
2692: IF p_QUALIFIERS_rec.created_from_rule_id IS NOT NULL AND
2693: p_QUALIFIERS_rec.created_from_rule_id <> FND_API.G_MISS_NUM AND
2694: NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_from_rule_id,
2695: p_old_QUALIFIERS_rec.created_from_rule_id)
2696: THEN
2697: l_QUALIFIERS_val_rec.created_from_rule := QP_Id_To_Value.Created_From_Rule

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

2699: );
2700: END IF;
2701:
2702: /* IF p_QUALIFIERS_rec.excluder_flag IS NOT NULL AND
2703: p_QUALIFIERS_rec.excluder_flag <> FND_API.G_MISS_CHAR AND
2704: NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.excluder_flag,
2705: p_old_QUALIFIERS_rec.excluder_flag)
2706: THEN
2707: l_QUALIFIERS_val_rec.excluder := QP_Id_To_Value.Excluder

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

2709: );
2710: END IF;*/
2711:
2712: IF p_QUALIFIERS_rec.list_header_id IS NOT NULL AND
2713: p_QUALIFIERS_rec.list_header_id <> FND_API.G_MISS_NUM AND
2714: NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_header_id,
2715: p_old_QUALIFIERS_rec.list_header_id)
2716: THEN
2717: l_QUALIFIERS_val_rec.list_header := QP_Id_To_Value.List_Header

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

2719: );
2720: END IF;
2721:
2722: IF p_QUALIFIERS_rec.list_line_id IS NOT NULL AND
2723: p_QUALIFIERS_rec.list_line_id <> FND_API.G_MISS_NUM AND
2724: NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_line_id,
2725: p_old_QUALIFIERS_rec.list_line_id)
2726: THEN
2727: l_QUALIFIERS_val_rec.list_line := QP_Id_To_Value.List_Line

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

2729: );
2730: END IF;
2731:
2732: /*IF p_QUALIFIERS_rec.qualifier_id IS NOT NULL AND
2733: p_QUALIFIERS_rec.qualifier_id <> FND_API.G_MISS_NUM AND
2734: NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_id,
2735: p_old_QUALIFIERS_rec.qualifier_id)
2736: THEN
2737: l_QUALIFIERS_val_rec.qualifier := QP_Id_To_Value.Qualifier

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

2739: );
2740: END IF;*/
2741:
2742: IF p_QUALIFIERS_rec.qualifier_rule_id IS NOT NULL AND
2743: p_QUALIFIERS_rec.qualifier_rule_id <> FND_API.G_MISS_NUM AND
2744: NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_rule_id,
2745: p_old_QUALIFIERS_rec.qualifier_rule_id)
2746: THEN
2747: l_QUALIFIERS_val_rec.qualifier_rule := QP_Id_To_Value.Qualifier_Rule

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

2764: BEGIN
2765:
2766: -- initialize return_status.
2767:
2768: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2769:
2770: -- initialize l_QUALIFIERS_rec.
2771:
2772: l_QUALIFIERS_rec := p_QUALIFIERS_rec;

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

2770: -- initialize l_QUALIFIERS_rec.
2771:
2772: l_QUALIFIERS_rec := p_QUALIFIERS_rec;
2773:
2774: /* IF p_QUALIFIERS_val_rec.comparison_operator <> FND_API.G_MISS_CHAR
2775: THEN
2776:
2777: IF p_QUALIFIERS_rec.comparison_operator_code <> FND_API.G_MISS_CHAR THEN
2778:

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

2773:
2774: /* IF p_QUALIFIERS_val_rec.comparison_operator <> FND_API.G_MISS_CHAR
2775: THEN
2776:
2777: IF p_QUALIFIERS_rec.comparison_operator_code <> FND_API.G_MISS_CHAR THEN
2778:
2779: l_QUALIFIERS_rec.comparison_operator_code := p_QUALIFIERS_rec.comparison_operator_code;
2780:
2781: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

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

2792: l_QUALIFIERS_rec.comparison_operator_code := QP_Value_To_Id.comparison_operator
2793: ( p_comparison_operator => p_QUALIFIERS_val_rec.comparison_operator
2794: );
2795:
2796: IF l_QUALIFIERS_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN
2797: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2798: END IF;
2799:
2800: END IF;

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

2793: ( p_comparison_operator => p_QUALIFIERS_val_rec.comparison_operator
2794: );
2795:
2796: IF l_QUALIFIERS_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN
2797: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2798: END IF;
2799:
2800: END IF;
2801:

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

2800: END IF;
2801:
2802: END IF;*/
2803:
2804: IF p_QUALIFIERS_val_rec.created_from_rule <> FND_API.G_MISS_CHAR
2805: THEN
2806:
2807: IF p_QUALIFIERS_rec.created_from_rule_id <> FND_API.G_MISS_NUM THEN
2808:

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

2803:
2804: IF p_QUALIFIERS_val_rec.created_from_rule <> FND_API.G_MISS_CHAR
2805: THEN
2806:
2807: IF p_QUALIFIERS_rec.created_from_rule_id <> FND_API.G_MISS_NUM THEN
2808:
2809: l_QUALIFIERS_rec.created_from_rule_id := p_QUALIFIERS_rec.created_from_rule_id;
2810:
2811: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

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

2822: l_QUALIFIERS_rec.created_from_rule_id := QP_Value_To_Id.created_from_rule
2823: ( p_created_from_rule => p_QUALIFIERS_val_rec.created_from_rule
2824: );
2825:
2826: IF l_QUALIFIERS_rec.created_from_rule_id = FND_API.G_MISS_NUM THEN
2827: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2828: END IF;
2829:
2830: END IF;

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

2823: ( p_created_from_rule => p_QUALIFIERS_val_rec.created_from_rule
2824: );
2825:
2826: IF l_QUALIFIERS_rec.created_from_rule_id = FND_API.G_MISS_NUM THEN
2827: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2828: END IF;
2829:
2830: END IF;
2831:

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

2830: END IF;
2831:
2832: END IF;
2833:
2834: /* IF p_QUALIFIERS_val_rec.excluder <> FND_API.G_MISS_CHAR
2835: THEN
2836:
2837: IF p_QUALIFIERS_rec.excluder_flag <> FND_API.G_MISS_CHAR THEN
2838:

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

2833:
2834: /* IF p_QUALIFIERS_val_rec.excluder <> FND_API.G_MISS_CHAR
2835: THEN
2836:
2837: IF p_QUALIFIERS_rec.excluder_flag <> FND_API.G_MISS_CHAR THEN
2838:
2839: l_QUALIFIERS_rec.excluder_flag := p_QUALIFIERS_rec.excluder_flag;
2840:
2841: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

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

2852: l_QUALIFIERS_rec.excluder_flag := QP_Value_To_Id.excluder
2853: ( p_excluder => p_QUALIFIERS_val_rec.excluder
2854: );
2855:
2856: IF l_QUALIFIERS_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
2857: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2858: END IF;
2859:
2860: END IF;

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

2853: ( p_excluder => p_QUALIFIERS_val_rec.excluder
2854: );
2855:
2856: IF l_QUALIFIERS_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
2857: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2858: END IF;
2859:
2860: END IF;
2861:

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

2860: END IF;
2861:
2862: END IF;*/
2863:
2864: IF p_QUALIFIERS_val_rec.list_header <> FND_API.G_MISS_CHAR
2865: THEN
2866:
2867: IF p_QUALIFIERS_rec.list_header_id <> FND_API.G_MISS_NUM THEN
2868:

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

2863:
2864: IF p_QUALIFIERS_val_rec.list_header <> FND_API.G_MISS_CHAR
2865: THEN
2866:
2867: IF p_QUALIFIERS_rec.list_header_id <> FND_API.G_MISS_NUM THEN
2868:
2869: l_QUALIFIERS_rec.list_header_id := p_QUALIFIERS_rec.list_header_id;
2870:
2871: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

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

2882: l_QUALIFIERS_rec.list_header_id := QP_Value_To_Id.list_header
2883: ( p_list_header => p_QUALIFIERS_val_rec.list_header
2884: );
2885:
2886: IF l_QUALIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN
2887: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2888: END IF;
2889:
2890: END IF;

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

2883: ( p_list_header => p_QUALIFIERS_val_rec.list_header
2884: );
2885:
2886: IF l_QUALIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN
2887: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2888: END IF;
2889:
2890: END IF;
2891:

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

2890: END IF;
2891:
2892: END IF;
2893:
2894: IF p_QUALIFIERS_val_rec.list_line <> FND_API.G_MISS_CHAR
2895: THEN
2896:
2897: IF p_QUALIFIERS_rec.list_line_id <> FND_API.G_MISS_NUM THEN
2898:

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

2893:
2894: IF p_QUALIFIERS_val_rec.list_line <> FND_API.G_MISS_CHAR
2895: THEN
2896:
2897: IF p_QUALIFIERS_rec.list_line_id <> FND_API.G_MISS_NUM THEN
2898:
2899: l_QUALIFIERS_rec.list_line_id := p_QUALIFIERS_rec.list_line_id;
2900:
2901: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

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

2912: l_QUALIFIERS_rec.list_line_id := QP_Value_To_Id.list_line
2913: ( p_list_line => p_QUALIFIERS_val_rec.list_line
2914: );
2915:
2916: IF l_QUALIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN
2917: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2918: END IF;
2919:
2920: END IF;

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

2913: ( p_list_line => p_QUALIFIERS_val_rec.list_line
2914: );
2915:
2916: IF l_QUALIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN
2917: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2918: END IF;
2919:
2920: END IF;
2921:

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

2920: END IF;
2921:
2922: END IF;
2923:
2924: /* IF p_QUALIFIERS_val_rec.qualifier <> FND_API.G_MISS_CHAR
2925: THEN
2926:
2927: IF p_QUALIFIERS_rec.qualifier_id <> FND_API.G_MISS_NUM THEN
2928:

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

2923:
2924: /* IF p_QUALIFIERS_val_rec.qualifier <> FND_API.G_MISS_CHAR
2925: THEN
2926:
2927: IF p_QUALIFIERS_rec.qualifier_id <> FND_API.G_MISS_NUM THEN
2928:
2929: l_QUALIFIERS_rec.qualifier_id := p_QUALIFIERS_rec.qualifier_id;
2930:
2931: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

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

2942: l_QUALIFIERS_rec.qualifier_id := QP_Value_To_Id.qualifier
2943: ( p_qualifier => p_QUALIFIERS_val_rec.qualifier
2944: );
2945:
2946: IF l_QUALIFIERS_rec.qualifier_id = FND_API.G_MISS_NUM THEN
2947: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2948: END IF;
2949:
2950: END IF;

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

2943: ( p_qualifier => p_QUALIFIERS_val_rec.qualifier
2944: );
2945:
2946: IF l_QUALIFIERS_rec.qualifier_id = FND_API.G_MISS_NUM THEN
2947: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2948: END IF;
2949:
2950: END IF;
2951:

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

2950: END IF;
2951:
2952: END IF;*/
2953:
2954: IF p_QUALIFIERS_val_rec.qualifier_rule <> FND_API.G_MISS_CHAR
2955: THEN
2956:
2957: IF p_QUALIFIERS_rec.qualifier_rule_id <> FND_API.G_MISS_NUM THEN
2958:

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

2953:
2954: IF p_QUALIFIERS_val_rec.qualifier_rule <> FND_API.G_MISS_CHAR
2955: THEN
2956:
2957: IF p_QUALIFIERS_rec.qualifier_rule_id <> FND_API.G_MISS_NUM THEN
2958:
2959: l_QUALIFIERS_rec.qualifier_rule_id := p_QUALIFIERS_rec.qualifier_rule_id;
2960:
2961: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

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

2972: l_QUALIFIERS_rec.qualifier_rule_id := QP_Value_To_Id.qualifier_rule
2973: ( p_qualifier_rule => p_QUALIFIERS_val_rec.qualifier_rule
2974: );
2975:
2976: IF l_QUALIFIERS_rec.qualifier_rule_id = FND_API.G_MISS_NUM THEN
2977: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2978: END IF;
2979:
2980: END IF;

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

2973: ( p_qualifier_rule => p_QUALIFIERS_val_rec.qualifier_rule
2974: );
2975:
2976: IF l_QUALIFIERS_rec.qualifier_rule_id = FND_API.G_MISS_NUM THEN
2977: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2978: END IF;
2979:
2980: END IF;
2981:

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

2985: Added code for value_to_id conversion for qualifier_attribute,
2986: qualifier_attr_value and qualifier_attr_value_to
2987: ***************************************************************************/
2988:
2989: IF p_QUALIFIERS_val_rec.qualifier_attribute_desc <> FND_API.G_MISS_CHAR
2990: THEN
2991:
2992: IF p_QUALIFIERS_rec.qualifier_attribute <> FND_API.G_MISS_CHAR THEN
2993:

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

2988:
2989: IF p_QUALIFIERS_val_rec.qualifier_attribute_desc <> FND_API.G_MISS_CHAR
2990: THEN
2991:
2992: IF p_QUALIFIERS_rec.qualifier_attribute <> FND_API.G_MISS_CHAR THEN
2993:
2994: l_QUALIFIERS_rec.qualifier_attribute := p_QUALIFIERS_rec.qualifier_attribute;
2995:
2996: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

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

3008: ( p_qualifier_attribute_desc => p_QUALIFIERS_val_rec.qualifier_attribute_desc,
3009: p_context => l_QUALIFIERS_rec.qualifier_context
3010: );
3011:
3012: IF l_QUALIFIERS_rec.qualifier_attribute = FND_API.G_MISS_CHAR THEN
3013: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
3014: END IF;
3015:
3016: END IF;

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

3009: p_context => l_QUALIFIERS_rec.qualifier_context
3010: );
3011:
3012: IF l_QUALIFIERS_rec.qualifier_attribute = FND_API.G_MISS_CHAR THEN
3013: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
3014: END IF;
3015:
3016: END IF;
3017:

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

3016: END IF;
3017:
3018: END IF;
3019:
3020: IF p_QUALIFIERS_val_rec.qualifier_attr_value_desc <> FND_API.G_MISS_CHAR
3021: THEN
3022:
3023: IF p_QUALIFIERS_rec.qualifier_attr_value <> FND_API.G_MISS_CHAR THEN
3024:

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

3019:
3020: IF p_QUALIFIERS_val_rec.qualifier_attr_value_desc <> FND_API.G_MISS_CHAR
3021: THEN
3022:
3023: IF p_QUALIFIERS_rec.qualifier_attr_value <> FND_API.G_MISS_CHAR THEN
3024:
3025: l_QUALIFIERS_rec.qualifier_attr_value := p_QUALIFIERS_rec.qualifier_attr_value;
3026:
3027: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

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

3040: p_context => l_QUALIFIERS_rec.qualifier_context,
3041: p_attribute => l_QUALIFIERS_rec.qualifier_attribute
3042: );
3043:
3044: IF l_QUALIFIERS_rec.qualifier_attr_value = FND_API.G_MISS_CHAR THEN
3045: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
3046: END IF;
3047:
3048: END IF;

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

3041: p_attribute => l_QUALIFIERS_rec.qualifier_attribute
3042: );
3043:
3044: IF l_QUALIFIERS_rec.qualifier_attr_value = FND_API.G_MISS_CHAR THEN
3045: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
3046: END IF;
3047:
3048: END IF;
3049:

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

3048: END IF;
3049:
3050: END IF;
3051:
3052: IF p_QUALIFIERS_val_rec.qualifier_attr_value_to_desc <> FND_API.G_MISS_CHAR
3053: THEN
3054:
3055: IF p_QUALIFIERS_rec.qualifier_attr_value_to <> FND_API.G_MISS_CHAR THEN
3056:

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

3051:
3052: IF p_QUALIFIERS_val_rec.qualifier_attr_value_to_desc <> FND_API.G_MISS_CHAR
3053: THEN
3054:
3055: IF p_QUALIFIERS_rec.qualifier_attr_value_to <> FND_API.G_MISS_CHAR THEN
3056:
3057: l_QUALIFIERS_rec.qualifier_attr_value_to := p_QUALIFIERS_rec.qualifier_attr_value_to;
3058:
3059: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

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

3072: p_context => l_QUALIFIERS_rec.qualifier_context,
3073: p_attribute => l_QUALIFIERS_rec.qualifier_attribute
3074: );
3075:
3076: IF l_QUALIFIERS_rec.qualifier_attr_value_to = FND_API.G_MISS_CHAR THEN
3077: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
3078: END IF;
3079:
3080: END IF;

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

3073: p_attribute => l_QUALIFIERS_rec.qualifier_attribute
3074: );
3075:
3076: IF l_QUALIFIERS_rec.qualifier_attr_value_to = FND_API.G_MISS_CHAR THEN
3077: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
3078: END IF;
3079:
3080: END IF;
3081:

Line 3904: WHEN FND_API.G_EXC_ERROR THEN

3900: END IF; --Java Engine Installed
3901: END IF; -- PL/SQL pattern search enabled
3902:
3903: EXCEPTION
3904: WHEN FND_API.G_EXC_ERROR THEN
3905: RAISE;
3906: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3907: RAISE;
3908: WHEN OTHERS THEN

Line 3906: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3902:
3903: EXCEPTION
3904: WHEN FND_API.G_EXC_ERROR THEN
3905: RAISE;
3906: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3907: RAISE;
3908: WHEN OTHERS THEN
3909: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
3910: THEN

Line 3916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3912: ( G_PKG_NAME
3913: , 'Pre_Write_Process'
3914: );
3915: END IF;
3916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3917: END Pre_Write_Process;
3918:
3919: END QP_Qualifiers_Util;