APPS.QP_LIMITS_UTIL dependencies on FND_API

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

125:
126: -- Procedure Clear_Dependent_Attr
127:
128: PROCEDURE Clear_Dependent_Attr
129: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
130: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
131: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type := QP_Limits_PUB.G_MISS_LIMITS_REC
132: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
133: )

Line 147: IF p_attr_id = FND_API.G_MISS_NUM THEN

143:
144: -- If attr_id is missing compare old and new records and for
145: -- every changed attribute clear its dependent fields.
146:
147: IF p_attr_id = FND_API.G_MISS_NUM THEN
148:
149: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.amount, p_old_LIMITS_rec.amount)
150: THEN
151: l_index := l_index + 1;

Line 783: IF l_LIMITS_rec.amount = FND_API.G_MISS_NUM THEN

779: IS
780: l_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type := p_LIMITS_rec;
781: BEGIN
782:
783: IF l_LIMITS_rec.amount = FND_API.G_MISS_NUM THEN
784: l_LIMITS_rec.amount := p_old_LIMITS_rec.amount;
785: END IF;
786:
787: IF l_LIMITS_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 787: IF l_LIMITS_rec.attribute1 = FND_API.G_MISS_CHAR THEN

783: IF l_LIMITS_rec.amount = FND_API.G_MISS_NUM THEN
784: l_LIMITS_rec.amount := p_old_LIMITS_rec.amount;
785: END IF;
786:
787: IF l_LIMITS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
788: l_LIMITS_rec.attribute1 := p_old_LIMITS_rec.attribute1;
789: END IF;
790:
791: IF l_LIMITS_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 791: IF l_LIMITS_rec.attribute10 = FND_API.G_MISS_CHAR THEN

787: IF l_LIMITS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
788: l_LIMITS_rec.attribute1 := p_old_LIMITS_rec.attribute1;
789: END IF;
790:
791: IF l_LIMITS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
792: l_LIMITS_rec.attribute10 := p_old_LIMITS_rec.attribute10;
793: END IF;
794:
795: IF l_LIMITS_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 795: IF l_LIMITS_rec.attribute11 = FND_API.G_MISS_CHAR THEN

791: IF l_LIMITS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
792: l_LIMITS_rec.attribute10 := p_old_LIMITS_rec.attribute10;
793: END IF;
794:
795: IF l_LIMITS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
796: l_LIMITS_rec.attribute11 := p_old_LIMITS_rec.attribute11;
797: END IF;
798:
799: IF l_LIMITS_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 799: IF l_LIMITS_rec.attribute12 = FND_API.G_MISS_CHAR THEN

795: IF l_LIMITS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
796: l_LIMITS_rec.attribute11 := p_old_LIMITS_rec.attribute11;
797: END IF;
798:
799: IF l_LIMITS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
800: l_LIMITS_rec.attribute12 := p_old_LIMITS_rec.attribute12;
801: END IF;
802:
803: IF l_LIMITS_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 803: IF l_LIMITS_rec.attribute13 = FND_API.G_MISS_CHAR THEN

799: IF l_LIMITS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
800: l_LIMITS_rec.attribute12 := p_old_LIMITS_rec.attribute12;
801: END IF;
802:
803: IF l_LIMITS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
804: l_LIMITS_rec.attribute13 := p_old_LIMITS_rec.attribute13;
805: END IF;
806:
807: IF l_LIMITS_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 807: IF l_LIMITS_rec.attribute14 = FND_API.G_MISS_CHAR THEN

803: IF l_LIMITS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
804: l_LIMITS_rec.attribute13 := p_old_LIMITS_rec.attribute13;
805: END IF;
806:
807: IF l_LIMITS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
808: l_LIMITS_rec.attribute14 := p_old_LIMITS_rec.attribute14;
809: END IF;
810:
811: IF l_LIMITS_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 811: IF l_LIMITS_rec.attribute15 = FND_API.G_MISS_CHAR THEN

807: IF l_LIMITS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
808: l_LIMITS_rec.attribute14 := p_old_LIMITS_rec.attribute14;
809: END IF;
810:
811: IF l_LIMITS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
812: l_LIMITS_rec.attribute15 := p_old_LIMITS_rec.attribute15;
813: END IF;
814:
815: IF l_LIMITS_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 815: IF l_LIMITS_rec.attribute2 = FND_API.G_MISS_CHAR THEN

811: IF l_LIMITS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
812: l_LIMITS_rec.attribute15 := p_old_LIMITS_rec.attribute15;
813: END IF;
814:
815: IF l_LIMITS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
816: l_LIMITS_rec.attribute2 := p_old_LIMITS_rec.attribute2;
817: END IF;
818:
819: IF l_LIMITS_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 819: IF l_LIMITS_rec.attribute3 = FND_API.G_MISS_CHAR THEN

815: IF l_LIMITS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
816: l_LIMITS_rec.attribute2 := p_old_LIMITS_rec.attribute2;
817: END IF;
818:
819: IF l_LIMITS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
820: l_LIMITS_rec.attribute3 := p_old_LIMITS_rec.attribute3;
821: END IF;
822:
823: IF l_LIMITS_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 823: IF l_LIMITS_rec.attribute4 = FND_API.G_MISS_CHAR THEN

819: IF l_LIMITS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
820: l_LIMITS_rec.attribute3 := p_old_LIMITS_rec.attribute3;
821: END IF;
822:
823: IF l_LIMITS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
824: l_LIMITS_rec.attribute4 := p_old_LIMITS_rec.attribute4;
825: END IF;
826:
827: IF l_LIMITS_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 827: IF l_LIMITS_rec.attribute5 = FND_API.G_MISS_CHAR THEN

823: IF l_LIMITS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
824: l_LIMITS_rec.attribute4 := p_old_LIMITS_rec.attribute4;
825: END IF;
826:
827: IF l_LIMITS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
828: l_LIMITS_rec.attribute5 := p_old_LIMITS_rec.attribute5;
829: END IF;
830:
831: IF l_LIMITS_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 831: IF l_LIMITS_rec.attribute6 = FND_API.G_MISS_CHAR THEN

827: IF l_LIMITS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
828: l_LIMITS_rec.attribute5 := p_old_LIMITS_rec.attribute5;
829: END IF;
830:
831: IF l_LIMITS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
832: l_LIMITS_rec.attribute6 := p_old_LIMITS_rec.attribute6;
833: END IF;
834:
835: IF l_LIMITS_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 835: IF l_LIMITS_rec.attribute7 = FND_API.G_MISS_CHAR THEN

831: IF l_LIMITS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
832: l_LIMITS_rec.attribute6 := p_old_LIMITS_rec.attribute6;
833: END IF;
834:
835: IF l_LIMITS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
836: l_LIMITS_rec.attribute7 := p_old_LIMITS_rec.attribute7;
837: END IF;
838:
839: IF l_LIMITS_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 839: IF l_LIMITS_rec.attribute8 = FND_API.G_MISS_CHAR THEN

835: IF l_LIMITS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
836: l_LIMITS_rec.attribute7 := p_old_LIMITS_rec.attribute7;
837: END IF;
838:
839: IF l_LIMITS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
840: l_LIMITS_rec.attribute8 := p_old_LIMITS_rec.attribute8;
841: END IF;
842:
843: IF l_LIMITS_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 843: IF l_LIMITS_rec.attribute9 = FND_API.G_MISS_CHAR THEN

839: IF l_LIMITS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
840: l_LIMITS_rec.attribute8 := p_old_LIMITS_rec.attribute8;
841: END IF;
842:
843: IF l_LIMITS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
844: l_LIMITS_rec.attribute9 := p_old_LIMITS_rec.attribute9;
845: END IF;
846:
847: IF l_LIMITS_rec.basis = FND_API.G_MISS_CHAR THEN

Line 847: IF l_LIMITS_rec.basis = FND_API.G_MISS_CHAR THEN

843: IF l_LIMITS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
844: l_LIMITS_rec.attribute9 := p_old_LIMITS_rec.attribute9;
845: END IF;
846:
847: IF l_LIMITS_rec.basis = FND_API.G_MISS_CHAR THEN
848: l_LIMITS_rec.basis := p_old_LIMITS_rec.basis;
849: END IF;
850:
851: IF l_LIMITS_rec.context = FND_API.G_MISS_CHAR THEN

Line 851: IF l_LIMITS_rec.context = FND_API.G_MISS_CHAR THEN

847: IF l_LIMITS_rec.basis = FND_API.G_MISS_CHAR THEN
848: l_LIMITS_rec.basis := p_old_LIMITS_rec.basis;
849: END IF;
850:
851: IF l_LIMITS_rec.context = FND_API.G_MISS_CHAR THEN
852: l_LIMITS_rec.context := p_old_LIMITS_rec.context;
853: END IF;
854:
855: IF l_LIMITS_rec.created_by = FND_API.G_MISS_NUM THEN

Line 855: IF l_LIMITS_rec.created_by = FND_API.G_MISS_NUM THEN

851: IF l_LIMITS_rec.context = FND_API.G_MISS_CHAR THEN
852: l_LIMITS_rec.context := p_old_LIMITS_rec.context;
853: END IF;
854:
855: IF l_LIMITS_rec.created_by = FND_API.G_MISS_NUM THEN
856: l_LIMITS_rec.created_by := p_old_LIMITS_rec.created_by;
857: END IF;
858:
859: IF l_LIMITS_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 859: IF l_LIMITS_rec.creation_date = FND_API.G_MISS_DATE THEN

855: IF l_LIMITS_rec.created_by = FND_API.G_MISS_NUM THEN
856: l_LIMITS_rec.created_by := p_old_LIMITS_rec.created_by;
857: END IF;
858:
859: IF l_LIMITS_rec.creation_date = FND_API.G_MISS_DATE THEN
860: l_LIMITS_rec.creation_date := p_old_LIMITS_rec.creation_date;
861: END IF;
862:
863: IF l_LIMITS_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 863: IF l_LIMITS_rec.last_updated_by = FND_API.G_MISS_NUM THEN

859: IF l_LIMITS_rec.creation_date = FND_API.G_MISS_DATE THEN
860: l_LIMITS_rec.creation_date := p_old_LIMITS_rec.creation_date;
861: END IF;
862:
863: IF l_LIMITS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
864: l_LIMITS_rec.last_updated_by := p_old_LIMITS_rec.last_updated_by;
865: END IF;
866:
867: IF l_LIMITS_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 867: IF l_LIMITS_rec.last_update_date = FND_API.G_MISS_DATE THEN

863: IF l_LIMITS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
864: l_LIMITS_rec.last_updated_by := p_old_LIMITS_rec.last_updated_by;
865: END IF;
866:
867: IF l_LIMITS_rec.last_update_date = FND_API.G_MISS_DATE THEN
868: l_LIMITS_rec.last_update_date := p_old_LIMITS_rec.last_update_date;
869: END IF;
870:
871: IF l_LIMITS_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 871: IF l_LIMITS_rec.last_update_login = FND_API.G_MISS_NUM THEN

867: IF l_LIMITS_rec.last_update_date = FND_API.G_MISS_DATE THEN
868: l_LIMITS_rec.last_update_date := p_old_LIMITS_rec.last_update_date;
869: END IF;
870:
871: IF l_LIMITS_rec.last_update_login = FND_API.G_MISS_NUM THEN
872: l_LIMITS_rec.last_update_login := p_old_LIMITS_rec.last_update_login;
873: END IF;
874:
875: IF l_LIMITS_rec.limit_exceed_action_code = FND_API.G_MISS_CHAR THEN

Line 875: IF l_LIMITS_rec.limit_exceed_action_code = FND_API.G_MISS_CHAR THEN

871: IF l_LIMITS_rec.last_update_login = FND_API.G_MISS_NUM THEN
872: l_LIMITS_rec.last_update_login := p_old_LIMITS_rec.last_update_login;
873: END IF;
874:
875: IF l_LIMITS_rec.limit_exceed_action_code = FND_API.G_MISS_CHAR THEN
876: l_LIMITS_rec.limit_exceed_action_code := p_old_LIMITS_rec.limit_exceed_action_code;
877: END IF;
878:
879: IF l_LIMITS_rec.limit_id = FND_API.G_MISS_NUM THEN

Line 879: IF l_LIMITS_rec.limit_id = FND_API.G_MISS_NUM THEN

875: IF l_LIMITS_rec.limit_exceed_action_code = FND_API.G_MISS_CHAR THEN
876: l_LIMITS_rec.limit_exceed_action_code := p_old_LIMITS_rec.limit_exceed_action_code;
877: END IF;
878:
879: IF l_LIMITS_rec.limit_id = FND_API.G_MISS_NUM THEN
880: l_LIMITS_rec.limit_id := p_old_LIMITS_rec.limit_id;
881: END IF;
882:
883: IF l_LIMITS_rec.limit_level_code = FND_API.G_MISS_CHAR THEN

Line 883: IF l_LIMITS_rec.limit_level_code = FND_API.G_MISS_CHAR THEN

879: IF l_LIMITS_rec.limit_id = FND_API.G_MISS_NUM THEN
880: l_LIMITS_rec.limit_id := p_old_LIMITS_rec.limit_id;
881: END IF;
882:
883: IF l_LIMITS_rec.limit_level_code = FND_API.G_MISS_CHAR THEN
884: l_LIMITS_rec.limit_level_code := p_old_LIMITS_rec.limit_level_code;
885: END IF;
886:
887: IF l_LIMITS_rec.limit_number = FND_API.G_MISS_NUM THEN

Line 887: IF l_LIMITS_rec.limit_number = FND_API.G_MISS_NUM THEN

883: IF l_LIMITS_rec.limit_level_code = FND_API.G_MISS_CHAR THEN
884: l_LIMITS_rec.limit_level_code := p_old_LIMITS_rec.limit_level_code;
885: END IF;
886:
887: IF l_LIMITS_rec.limit_number = FND_API.G_MISS_NUM THEN
888: l_LIMITS_rec.limit_number := p_old_LIMITS_rec.limit_number;
889: END IF;
890:
891: IF l_LIMITS_rec.list_header_id = FND_API.G_MISS_NUM THEN

Line 891: IF l_LIMITS_rec.list_header_id = FND_API.G_MISS_NUM THEN

887: IF l_LIMITS_rec.limit_number = FND_API.G_MISS_NUM THEN
888: l_LIMITS_rec.limit_number := p_old_LIMITS_rec.limit_number;
889: END IF;
890:
891: IF l_LIMITS_rec.list_header_id = FND_API.G_MISS_NUM THEN
892: l_LIMITS_rec.list_header_id := p_old_LIMITS_rec.list_header_id;
893: END IF;
894:
895: IF l_LIMITS_rec.list_line_id = FND_API.G_MISS_NUM THEN

Line 895: IF l_LIMITS_rec.list_line_id = FND_API.G_MISS_NUM THEN

891: IF l_LIMITS_rec.list_header_id = FND_API.G_MISS_NUM THEN
892: l_LIMITS_rec.list_header_id := p_old_LIMITS_rec.list_header_id;
893: END IF;
894:
895: IF l_LIMITS_rec.list_line_id = FND_API.G_MISS_NUM THEN
896: l_LIMITS_rec.list_line_id := p_old_LIMITS_rec.list_line_id;
897: END IF;
898:
899: IF l_LIMITS_rec.organization_flag = FND_API.G_MISS_CHAR THEN

Line 899: IF l_LIMITS_rec.organization_flag = FND_API.G_MISS_CHAR THEN

895: IF l_LIMITS_rec.list_line_id = FND_API.G_MISS_NUM THEN
896: l_LIMITS_rec.list_line_id := p_old_LIMITS_rec.list_line_id;
897: END IF;
898:
899: IF l_LIMITS_rec.organization_flag = FND_API.G_MISS_CHAR THEN
900: l_LIMITS_rec.organization_flag := p_old_LIMITS_rec.organization_flag;
901: END IF;
902:
903: IF l_LIMITS_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 903: IF l_LIMITS_rec.program_application_id = FND_API.G_MISS_NUM THEN

899: IF l_LIMITS_rec.organization_flag = FND_API.G_MISS_CHAR THEN
900: l_LIMITS_rec.organization_flag := p_old_LIMITS_rec.organization_flag;
901: END IF;
902:
903: IF l_LIMITS_rec.program_application_id = FND_API.G_MISS_NUM THEN
904: l_LIMITS_rec.program_application_id := p_old_LIMITS_rec.program_application_id;
905: END IF;
906:
907: IF l_LIMITS_rec.program_id = FND_API.G_MISS_NUM THEN

Line 907: IF l_LIMITS_rec.program_id = FND_API.G_MISS_NUM THEN

903: IF l_LIMITS_rec.program_application_id = FND_API.G_MISS_NUM THEN
904: l_LIMITS_rec.program_application_id := p_old_LIMITS_rec.program_application_id;
905: END IF;
906:
907: IF l_LIMITS_rec.program_id = FND_API.G_MISS_NUM THEN
908: l_LIMITS_rec.program_id := p_old_LIMITS_rec.program_id;
909: END IF;
910:
911: IF l_LIMITS_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 911: IF l_LIMITS_rec.program_update_date = FND_API.G_MISS_DATE THEN

907: IF l_LIMITS_rec.program_id = FND_API.G_MISS_NUM THEN
908: l_LIMITS_rec.program_id := p_old_LIMITS_rec.program_id;
909: END IF;
910:
911: IF l_LIMITS_rec.program_update_date = FND_API.G_MISS_DATE THEN
912: l_LIMITS_rec.program_update_date := p_old_LIMITS_rec.program_update_date;
913: END IF;
914:
915: IF l_LIMITS_rec.request_id = FND_API.G_MISS_NUM THEN

Line 915: IF l_LIMITS_rec.request_id = FND_API.G_MISS_NUM THEN

911: IF l_LIMITS_rec.program_update_date = FND_API.G_MISS_DATE THEN
912: l_LIMITS_rec.program_update_date := p_old_LIMITS_rec.program_update_date;
913: END IF;
914:
915: IF l_LIMITS_rec.request_id = FND_API.G_MISS_NUM THEN
916: l_LIMITS_rec.request_id := p_old_LIMITS_rec.request_id;
917: END IF;
918:
919: IF l_LIMITS_rec.limit_hold_flag = FND_API.G_MISS_CHAR THEN

Line 919: IF l_LIMITS_rec.limit_hold_flag = FND_API.G_MISS_CHAR THEN

915: IF l_LIMITS_rec.request_id = FND_API.G_MISS_NUM THEN
916: l_LIMITS_rec.request_id := p_old_LIMITS_rec.request_id;
917: END IF;
918:
919: IF l_LIMITS_rec.limit_hold_flag = FND_API.G_MISS_CHAR THEN
920: l_LIMITS_rec.limit_hold_flag := p_old_LIMITS_rec.limit_hold_flag;
921: END IF;
922:
923: IF l_LIMITS_rec.multival_attr1_type = FND_API.G_MISS_CHAR THEN

Line 923: IF l_LIMITS_rec.multival_attr1_type = FND_API.G_MISS_CHAR THEN

919: IF l_LIMITS_rec.limit_hold_flag = FND_API.G_MISS_CHAR THEN
920: l_LIMITS_rec.limit_hold_flag := p_old_LIMITS_rec.limit_hold_flag;
921: END IF;
922:
923: IF l_LIMITS_rec.multival_attr1_type = FND_API.G_MISS_CHAR THEN
924: l_LIMITS_rec.multival_attr1_type := p_old_LIMITS_rec.multival_attr1_type;
925: END IF;
926:
927: IF l_LIMITS_rec.multival_attr1_context = FND_API.G_MISS_CHAR THEN

Line 927: IF l_LIMITS_rec.multival_attr1_context = FND_API.G_MISS_CHAR THEN

923: IF l_LIMITS_rec.multival_attr1_type = FND_API.G_MISS_CHAR THEN
924: l_LIMITS_rec.multival_attr1_type := p_old_LIMITS_rec.multival_attr1_type;
925: END IF;
926:
927: IF l_LIMITS_rec.multival_attr1_context = FND_API.G_MISS_CHAR THEN
928: l_LIMITS_rec.multival_attr1_context := p_old_LIMITS_rec.multival_attr1_context;
929: END IF;
930:
931: IF l_LIMITS_rec.multival_attribute1 = FND_API.G_MISS_CHAR THEN

Line 931: IF l_LIMITS_rec.multival_attribute1 = FND_API.G_MISS_CHAR THEN

927: IF l_LIMITS_rec.multival_attr1_context = FND_API.G_MISS_CHAR THEN
928: l_LIMITS_rec.multival_attr1_context := p_old_LIMITS_rec.multival_attr1_context;
929: END IF;
930:
931: IF l_LIMITS_rec.multival_attribute1 = FND_API.G_MISS_CHAR THEN
932: l_LIMITS_rec.multival_attribute1 := p_old_LIMITS_rec.multival_attribute1;
933: END IF;
934:
935: IF l_LIMITS_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR THEN

Line 935: IF l_LIMITS_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR THEN

931: IF l_LIMITS_rec.multival_attribute1 = FND_API.G_MISS_CHAR THEN
932: l_LIMITS_rec.multival_attribute1 := p_old_LIMITS_rec.multival_attribute1;
933: END IF;
934:
935: IF l_LIMITS_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR THEN
936: l_LIMITS_rec.multival_attr1_datatype := p_old_LIMITS_rec.multival_attr1_datatype;
937: END IF;
938:
939: IF l_LIMITS_rec.multival_attr2_type = FND_API.G_MISS_CHAR THEN

Line 939: IF l_LIMITS_rec.multival_attr2_type = FND_API.G_MISS_CHAR THEN

935: IF l_LIMITS_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR THEN
936: l_LIMITS_rec.multival_attr1_datatype := p_old_LIMITS_rec.multival_attr1_datatype;
937: END IF;
938:
939: IF l_LIMITS_rec.multival_attr2_type = FND_API.G_MISS_CHAR THEN
940: l_LIMITS_rec.multival_attr2_type := p_old_LIMITS_rec.multival_attr2_type;
941: END IF;
942:
943: IF l_LIMITS_rec.multival_attr2_context = FND_API.G_MISS_CHAR THEN

Line 943: IF l_LIMITS_rec.multival_attr2_context = FND_API.G_MISS_CHAR THEN

939: IF l_LIMITS_rec.multival_attr2_type = FND_API.G_MISS_CHAR THEN
940: l_LIMITS_rec.multival_attr2_type := p_old_LIMITS_rec.multival_attr2_type;
941: END IF;
942:
943: IF l_LIMITS_rec.multival_attr2_context = FND_API.G_MISS_CHAR THEN
944: l_LIMITS_rec.multival_attr2_context := p_old_LIMITS_rec.multival_attr2_context;
945: END IF;
946:
947: IF l_LIMITS_rec.multival_attribute2 = FND_API.G_MISS_CHAR THEN

Line 947: IF l_LIMITS_rec.multival_attribute2 = FND_API.G_MISS_CHAR THEN

943: IF l_LIMITS_rec.multival_attr2_context = FND_API.G_MISS_CHAR THEN
944: l_LIMITS_rec.multival_attr2_context := p_old_LIMITS_rec.multival_attr2_context;
945: END IF;
946:
947: IF l_LIMITS_rec.multival_attribute2 = FND_API.G_MISS_CHAR THEN
948: l_LIMITS_rec.multival_attribute2 := p_old_LIMITS_rec.multival_attribute2;
949: END IF;
950:
951: IF l_LIMITS_rec.multival_attr2_datatype = FND_API.G_MISS_CHAR THEN

Line 951: IF l_LIMITS_rec.multival_attr2_datatype = FND_API.G_MISS_CHAR THEN

947: IF l_LIMITS_rec.multival_attribute2 = FND_API.G_MISS_CHAR THEN
948: l_LIMITS_rec.multival_attribute2 := p_old_LIMITS_rec.multival_attribute2;
949: END IF;
950:
951: IF l_LIMITS_rec.multival_attr2_datatype = FND_API.G_MISS_CHAR THEN
952: l_LIMITS_rec.multival_attr2_datatype := p_old_LIMITS_rec.multival_attr2_datatype;
953: END IF;
954:
955: RETURN l_LIMITS_rec;

Line 968: IF l_LIMITS_rec.amount = FND_API.G_MISS_NUM THEN

964: IS
965: l_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type := p_LIMITS_rec;
966: BEGIN
967:
968: IF l_LIMITS_rec.amount = FND_API.G_MISS_NUM THEN
969: l_LIMITS_rec.amount := NULL;
970: END IF;
971:
972: IF l_LIMITS_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 972: IF l_LIMITS_rec.attribute1 = FND_API.G_MISS_CHAR THEN

968: IF l_LIMITS_rec.amount = FND_API.G_MISS_NUM THEN
969: l_LIMITS_rec.amount := NULL;
970: END IF;
971:
972: IF l_LIMITS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
973: l_LIMITS_rec.attribute1 := NULL;
974: END IF;
975:
976: IF l_LIMITS_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 976: IF l_LIMITS_rec.attribute10 = FND_API.G_MISS_CHAR THEN

972: IF l_LIMITS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
973: l_LIMITS_rec.attribute1 := NULL;
974: END IF;
975:
976: IF l_LIMITS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
977: l_LIMITS_rec.attribute10 := NULL;
978: END IF;
979:
980: IF l_LIMITS_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 980: IF l_LIMITS_rec.attribute11 = FND_API.G_MISS_CHAR THEN

976: IF l_LIMITS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
977: l_LIMITS_rec.attribute10 := NULL;
978: END IF;
979:
980: IF l_LIMITS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
981: l_LIMITS_rec.attribute11 := NULL;
982: END IF;
983:
984: IF l_LIMITS_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 984: IF l_LIMITS_rec.attribute12 = FND_API.G_MISS_CHAR THEN

980: IF l_LIMITS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
981: l_LIMITS_rec.attribute11 := NULL;
982: END IF;
983:
984: IF l_LIMITS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
985: l_LIMITS_rec.attribute12 := NULL;
986: END IF;
987:
988: IF l_LIMITS_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 988: IF l_LIMITS_rec.attribute13 = FND_API.G_MISS_CHAR THEN

984: IF l_LIMITS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
985: l_LIMITS_rec.attribute12 := NULL;
986: END IF;
987:
988: IF l_LIMITS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
989: l_LIMITS_rec.attribute13 := NULL;
990: END IF;
991:
992: IF l_LIMITS_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 992: IF l_LIMITS_rec.attribute14 = FND_API.G_MISS_CHAR THEN

988: IF l_LIMITS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
989: l_LIMITS_rec.attribute13 := NULL;
990: END IF;
991:
992: IF l_LIMITS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
993: l_LIMITS_rec.attribute14 := NULL;
994: END IF;
995:
996: IF l_LIMITS_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 996: IF l_LIMITS_rec.attribute15 = FND_API.G_MISS_CHAR THEN

992: IF l_LIMITS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
993: l_LIMITS_rec.attribute14 := NULL;
994: END IF;
995:
996: IF l_LIMITS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
997: l_LIMITS_rec.attribute15 := NULL;
998: END IF;
999:
1000: IF l_LIMITS_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 1000: IF l_LIMITS_rec.attribute2 = FND_API.G_MISS_CHAR THEN

996: IF l_LIMITS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
997: l_LIMITS_rec.attribute15 := NULL;
998: END IF;
999:
1000: IF l_LIMITS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1001: l_LIMITS_rec.attribute2 := NULL;
1002: END IF;
1003:
1004: IF l_LIMITS_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 1004: IF l_LIMITS_rec.attribute3 = FND_API.G_MISS_CHAR THEN

1000: IF l_LIMITS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1001: l_LIMITS_rec.attribute2 := NULL;
1002: END IF;
1003:
1004: IF l_LIMITS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1005: l_LIMITS_rec.attribute3 := NULL;
1006: END IF;
1007:
1008: IF l_LIMITS_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 1008: IF l_LIMITS_rec.attribute4 = FND_API.G_MISS_CHAR THEN

1004: IF l_LIMITS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1005: l_LIMITS_rec.attribute3 := NULL;
1006: END IF;
1007:
1008: IF l_LIMITS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1009: l_LIMITS_rec.attribute4 := NULL;
1010: END IF;
1011:
1012: IF l_LIMITS_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 1012: IF l_LIMITS_rec.attribute5 = FND_API.G_MISS_CHAR THEN

1008: IF l_LIMITS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1009: l_LIMITS_rec.attribute4 := NULL;
1010: END IF;
1011:
1012: IF l_LIMITS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1013: l_LIMITS_rec.attribute5 := NULL;
1014: END IF;
1015:
1016: IF l_LIMITS_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 1016: IF l_LIMITS_rec.attribute6 = FND_API.G_MISS_CHAR THEN

1012: IF l_LIMITS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1013: l_LIMITS_rec.attribute5 := NULL;
1014: END IF;
1015:
1016: IF l_LIMITS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1017: l_LIMITS_rec.attribute6 := NULL;
1018: END IF;
1019:
1020: IF l_LIMITS_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 1020: IF l_LIMITS_rec.attribute7 = FND_API.G_MISS_CHAR THEN

1016: IF l_LIMITS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1017: l_LIMITS_rec.attribute6 := NULL;
1018: END IF;
1019:
1020: IF l_LIMITS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1021: l_LIMITS_rec.attribute7 := NULL;
1022: END IF;
1023:
1024: IF l_LIMITS_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 1024: IF l_LIMITS_rec.attribute8 = FND_API.G_MISS_CHAR THEN

1020: IF l_LIMITS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1021: l_LIMITS_rec.attribute7 := NULL;
1022: END IF;
1023:
1024: IF l_LIMITS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1025: l_LIMITS_rec.attribute8 := NULL;
1026: END IF;
1027:
1028: IF l_LIMITS_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 1028: IF l_LIMITS_rec.attribute9 = FND_API.G_MISS_CHAR THEN

1024: IF l_LIMITS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1025: l_LIMITS_rec.attribute8 := NULL;
1026: END IF;
1027:
1028: IF l_LIMITS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1029: l_LIMITS_rec.attribute9 := NULL;
1030: END IF;
1031:
1032: IF l_LIMITS_rec.basis = FND_API.G_MISS_CHAR THEN

Line 1032: IF l_LIMITS_rec.basis = FND_API.G_MISS_CHAR THEN

1028: IF l_LIMITS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1029: l_LIMITS_rec.attribute9 := NULL;
1030: END IF;
1031:
1032: IF l_LIMITS_rec.basis = FND_API.G_MISS_CHAR THEN
1033: l_LIMITS_rec.basis := NULL;
1034: END IF;
1035:
1036: IF l_LIMITS_rec.context = FND_API.G_MISS_CHAR THEN

Line 1036: IF l_LIMITS_rec.context = FND_API.G_MISS_CHAR THEN

1032: IF l_LIMITS_rec.basis = FND_API.G_MISS_CHAR THEN
1033: l_LIMITS_rec.basis := NULL;
1034: END IF;
1035:
1036: IF l_LIMITS_rec.context = FND_API.G_MISS_CHAR THEN
1037: l_LIMITS_rec.context := NULL;
1038: END IF;
1039:
1040: IF l_LIMITS_rec.created_by = FND_API.G_MISS_NUM THEN

Line 1040: IF l_LIMITS_rec.created_by = FND_API.G_MISS_NUM THEN

1036: IF l_LIMITS_rec.context = FND_API.G_MISS_CHAR THEN
1037: l_LIMITS_rec.context := NULL;
1038: END IF;
1039:
1040: IF l_LIMITS_rec.created_by = FND_API.G_MISS_NUM THEN
1041: l_LIMITS_rec.created_by := NULL;
1042: END IF;
1043:
1044: IF l_LIMITS_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 1044: IF l_LIMITS_rec.creation_date = FND_API.G_MISS_DATE THEN

1040: IF l_LIMITS_rec.created_by = FND_API.G_MISS_NUM THEN
1041: l_LIMITS_rec.created_by := NULL;
1042: END IF;
1043:
1044: IF l_LIMITS_rec.creation_date = FND_API.G_MISS_DATE THEN
1045: l_LIMITS_rec.creation_date := NULL;
1046: END IF;
1047:
1048: IF l_LIMITS_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 1048: IF l_LIMITS_rec.last_updated_by = FND_API.G_MISS_NUM THEN

1044: IF l_LIMITS_rec.creation_date = FND_API.G_MISS_DATE THEN
1045: l_LIMITS_rec.creation_date := NULL;
1046: END IF;
1047:
1048: IF l_LIMITS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1049: l_LIMITS_rec.last_updated_by := NULL;
1050: END IF;
1051:
1052: IF l_LIMITS_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 1052: IF l_LIMITS_rec.last_update_date = FND_API.G_MISS_DATE THEN

1048: IF l_LIMITS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1049: l_LIMITS_rec.last_updated_by := NULL;
1050: END IF;
1051:
1052: IF l_LIMITS_rec.last_update_date = FND_API.G_MISS_DATE THEN
1053: l_LIMITS_rec.last_update_date := NULL;
1054: END IF;
1055:
1056: IF l_LIMITS_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 1056: IF l_LIMITS_rec.last_update_login = FND_API.G_MISS_NUM THEN

1052: IF l_LIMITS_rec.last_update_date = FND_API.G_MISS_DATE THEN
1053: l_LIMITS_rec.last_update_date := NULL;
1054: END IF;
1055:
1056: IF l_LIMITS_rec.last_update_login = FND_API.G_MISS_NUM THEN
1057: l_LIMITS_rec.last_update_login := NULL;
1058: END IF;
1059:
1060: IF l_LIMITS_rec.limit_exceed_action_code = FND_API.G_MISS_CHAR THEN

Line 1060: IF l_LIMITS_rec.limit_exceed_action_code = FND_API.G_MISS_CHAR THEN

1056: IF l_LIMITS_rec.last_update_login = FND_API.G_MISS_NUM THEN
1057: l_LIMITS_rec.last_update_login := NULL;
1058: END IF;
1059:
1060: IF l_LIMITS_rec.limit_exceed_action_code = FND_API.G_MISS_CHAR THEN
1061: l_LIMITS_rec.limit_exceed_action_code := NULL;
1062: END IF;
1063:
1064: IF l_LIMITS_rec.limit_id = FND_API.G_MISS_NUM THEN

Line 1064: IF l_LIMITS_rec.limit_id = FND_API.G_MISS_NUM THEN

1060: IF l_LIMITS_rec.limit_exceed_action_code = FND_API.G_MISS_CHAR THEN
1061: l_LIMITS_rec.limit_exceed_action_code := NULL;
1062: END IF;
1063:
1064: IF l_LIMITS_rec.limit_id = FND_API.G_MISS_NUM THEN
1065: l_LIMITS_rec.limit_id := NULL;
1066: END IF;
1067:
1068: IF l_LIMITS_rec.limit_level_code = FND_API.G_MISS_CHAR THEN

Line 1068: IF l_LIMITS_rec.limit_level_code = FND_API.G_MISS_CHAR THEN

1064: IF l_LIMITS_rec.limit_id = FND_API.G_MISS_NUM THEN
1065: l_LIMITS_rec.limit_id := NULL;
1066: END IF;
1067:
1068: IF l_LIMITS_rec.limit_level_code = FND_API.G_MISS_CHAR THEN
1069: l_LIMITS_rec.limit_level_code := NULL;
1070: END IF;
1071:
1072: IF l_LIMITS_rec.limit_number = FND_API.G_MISS_NUM THEN

Line 1072: IF l_LIMITS_rec.limit_number = FND_API.G_MISS_NUM THEN

1068: IF l_LIMITS_rec.limit_level_code = FND_API.G_MISS_CHAR THEN
1069: l_LIMITS_rec.limit_level_code := NULL;
1070: END IF;
1071:
1072: IF l_LIMITS_rec.limit_number = FND_API.G_MISS_NUM THEN
1073: l_LIMITS_rec.limit_number := NULL;
1074: END IF;
1075:
1076: IF l_LIMITS_rec.list_header_id = FND_API.G_MISS_NUM THEN

Line 1076: IF l_LIMITS_rec.list_header_id = FND_API.G_MISS_NUM THEN

1072: IF l_LIMITS_rec.limit_number = FND_API.G_MISS_NUM THEN
1073: l_LIMITS_rec.limit_number := NULL;
1074: END IF;
1075:
1076: IF l_LIMITS_rec.list_header_id = FND_API.G_MISS_NUM THEN
1077: l_LIMITS_rec.list_header_id := NULL;
1078: END IF;
1079:
1080: IF l_LIMITS_rec.list_line_id = FND_API.G_MISS_NUM THEN

Line 1080: IF l_LIMITS_rec.list_line_id = FND_API.G_MISS_NUM THEN

1076: IF l_LIMITS_rec.list_header_id = FND_API.G_MISS_NUM THEN
1077: l_LIMITS_rec.list_header_id := NULL;
1078: END IF;
1079:
1080: IF l_LIMITS_rec.list_line_id = FND_API.G_MISS_NUM THEN
1081: l_LIMITS_rec.list_line_id := NULL;
1082: END IF;
1083:
1084: IF l_LIMITS_rec.organization_flag = FND_API.G_MISS_CHAR THEN

Line 1084: IF l_LIMITS_rec.organization_flag = FND_API.G_MISS_CHAR THEN

1080: IF l_LIMITS_rec.list_line_id = FND_API.G_MISS_NUM THEN
1081: l_LIMITS_rec.list_line_id := NULL;
1082: END IF;
1083:
1084: IF l_LIMITS_rec.organization_flag = FND_API.G_MISS_CHAR THEN
1085: l_LIMITS_rec.organization_flag := NULL;
1086: END IF;
1087:
1088: IF l_LIMITS_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 1088: IF l_LIMITS_rec.program_application_id = FND_API.G_MISS_NUM THEN

1084: IF l_LIMITS_rec.organization_flag = FND_API.G_MISS_CHAR THEN
1085: l_LIMITS_rec.organization_flag := NULL;
1086: END IF;
1087:
1088: IF l_LIMITS_rec.program_application_id = FND_API.G_MISS_NUM THEN
1089: l_LIMITS_rec.program_application_id := NULL;
1090: END IF;
1091:
1092: IF l_LIMITS_rec.program_id = FND_API.G_MISS_NUM THEN

Line 1092: IF l_LIMITS_rec.program_id = FND_API.G_MISS_NUM THEN

1088: IF l_LIMITS_rec.program_application_id = FND_API.G_MISS_NUM THEN
1089: l_LIMITS_rec.program_application_id := NULL;
1090: END IF;
1091:
1092: IF l_LIMITS_rec.program_id = FND_API.G_MISS_NUM THEN
1093: l_LIMITS_rec.program_id := NULL;
1094: END IF;
1095:
1096: IF l_LIMITS_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 1096: IF l_LIMITS_rec.program_update_date = FND_API.G_MISS_DATE THEN

1092: IF l_LIMITS_rec.program_id = FND_API.G_MISS_NUM THEN
1093: l_LIMITS_rec.program_id := NULL;
1094: END IF;
1095:
1096: IF l_LIMITS_rec.program_update_date = FND_API.G_MISS_DATE THEN
1097: l_LIMITS_rec.program_update_date := NULL;
1098: END IF;
1099:
1100: IF l_LIMITS_rec.request_id = FND_API.G_MISS_NUM THEN

Line 1100: IF l_LIMITS_rec.request_id = FND_API.G_MISS_NUM THEN

1096: IF l_LIMITS_rec.program_update_date = FND_API.G_MISS_DATE THEN
1097: l_LIMITS_rec.program_update_date := NULL;
1098: END IF;
1099:
1100: IF l_LIMITS_rec.request_id = FND_API.G_MISS_NUM THEN
1101: l_LIMITS_rec.request_id := NULL;
1102: END IF;
1103:
1104: IF l_LIMITS_rec.limit_hold_flag = FND_API.G_MISS_CHAR THEN

Line 1104: IF l_LIMITS_rec.limit_hold_flag = FND_API.G_MISS_CHAR THEN

1100: IF l_LIMITS_rec.request_id = FND_API.G_MISS_NUM THEN
1101: l_LIMITS_rec.request_id := NULL;
1102: END IF;
1103:
1104: IF l_LIMITS_rec.limit_hold_flag = FND_API.G_MISS_CHAR THEN
1105: l_LIMITS_rec.limit_hold_flag := NULL;
1106: END IF;
1107:
1108: IF l_LIMITS_rec.multival_attr1_type = FND_API.G_MISS_CHAR THEN

Line 1108: IF l_LIMITS_rec.multival_attr1_type = FND_API.G_MISS_CHAR THEN

1104: IF l_LIMITS_rec.limit_hold_flag = FND_API.G_MISS_CHAR THEN
1105: l_LIMITS_rec.limit_hold_flag := NULL;
1106: END IF;
1107:
1108: IF l_LIMITS_rec.multival_attr1_type = FND_API.G_MISS_CHAR THEN
1109: l_LIMITS_rec.multival_attr1_type := NULL;
1110: END IF;
1111:
1112: IF l_LIMITS_rec.multival_attr1_context = FND_API.G_MISS_CHAR THEN

Line 1112: IF l_LIMITS_rec.multival_attr1_context = FND_API.G_MISS_CHAR THEN

1108: IF l_LIMITS_rec.multival_attr1_type = FND_API.G_MISS_CHAR THEN
1109: l_LIMITS_rec.multival_attr1_type := NULL;
1110: END IF;
1111:
1112: IF l_LIMITS_rec.multival_attr1_context = FND_API.G_MISS_CHAR THEN
1113: l_LIMITS_rec.multival_attr1_context := NULL;
1114: END IF;
1115:
1116: IF l_LIMITS_rec.multival_attribute1 = FND_API.G_MISS_CHAR THEN

Line 1116: IF l_LIMITS_rec.multival_attribute1 = FND_API.G_MISS_CHAR THEN

1112: IF l_LIMITS_rec.multival_attr1_context = FND_API.G_MISS_CHAR THEN
1113: l_LIMITS_rec.multival_attr1_context := NULL;
1114: END IF;
1115:
1116: IF l_LIMITS_rec.multival_attribute1 = FND_API.G_MISS_CHAR THEN
1117: l_LIMITS_rec.multival_attribute1 := NULL;
1118: END IF;
1119:
1120: IF l_LIMITS_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR THEN

Line 1120: IF l_LIMITS_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR THEN

1116: IF l_LIMITS_rec.multival_attribute1 = FND_API.G_MISS_CHAR THEN
1117: l_LIMITS_rec.multival_attribute1 := NULL;
1118: END IF;
1119:
1120: IF l_LIMITS_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR THEN
1121: l_LIMITS_rec.multival_attr1_datatype := NULL;
1122: END IF;
1123:
1124: IF l_LIMITS_rec.multival_attr2_type = FND_API.G_MISS_CHAR THEN

Line 1124: IF l_LIMITS_rec.multival_attr2_type = FND_API.G_MISS_CHAR THEN

1120: IF l_LIMITS_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR THEN
1121: l_LIMITS_rec.multival_attr1_datatype := NULL;
1122: END IF;
1123:
1124: IF l_LIMITS_rec.multival_attr2_type = FND_API.G_MISS_CHAR THEN
1125: l_LIMITS_rec.multival_attr2_type := NULL;
1126: END IF;
1127:
1128: IF l_LIMITS_rec.multival_attr2_context = FND_API.G_MISS_CHAR THEN

Line 1128: IF l_LIMITS_rec.multival_attr2_context = FND_API.G_MISS_CHAR THEN

1124: IF l_LIMITS_rec.multival_attr2_type = FND_API.G_MISS_CHAR THEN
1125: l_LIMITS_rec.multival_attr2_type := NULL;
1126: END IF;
1127:
1128: IF l_LIMITS_rec.multival_attr2_context = FND_API.G_MISS_CHAR THEN
1129: l_LIMITS_rec.multival_attr2_context := NULL;
1130: END IF;
1131:
1132: IF l_LIMITS_rec.multival_attribute2 = FND_API.G_MISS_CHAR THEN

Line 1132: IF l_LIMITS_rec.multival_attribute2 = FND_API.G_MISS_CHAR THEN

1128: IF l_LIMITS_rec.multival_attr2_context = FND_API.G_MISS_CHAR THEN
1129: l_LIMITS_rec.multival_attr2_context := NULL;
1130: END IF;
1131:
1132: IF l_LIMITS_rec.multival_attribute2 = FND_API.G_MISS_CHAR THEN
1133: l_LIMITS_rec.multival_attribute2 := NULL;
1134: END IF;
1135:
1136: IF l_LIMITS_rec.multival_attr2_datatype = FND_API.G_MISS_CHAR THEN

Line 1136: IF l_LIMITS_rec.multival_attr2_datatype = FND_API.G_MISS_CHAR THEN

1132: IF l_LIMITS_rec.multival_attribute2 = FND_API.G_MISS_CHAR THEN
1133: l_LIMITS_rec.multival_attribute2 := NULL;
1134: END IF;
1135:
1136: IF l_LIMITS_rec.multival_attr2_datatype = FND_API.G_MISS_CHAR THEN
1137: l_LIMITS_rec.multival_attr2_datatype := NULL;
1138: END IF;
1139:
1140: RETURN l_LIMITS_rec;

Line 1262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1258: OE_MSG_PUB.Add_Exc_Msg
1259: ( G_PKG_NAME
1260: , 'UPDATE_BALANCES'
1261: );
1262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1263: END IF;
1264: END IF;
1265:
1266:

Line 1281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1277: , 'Update_Row'
1278: );
1279: END IF;
1280:
1281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1282:
1283: END Update_Row;
1284:
1285: -- Procedure Insert_Row

Line 1438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1434: , 'Insert_Row'
1435: );
1436: END IF;
1437:
1438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1439:
1440: END Insert_Row;
1441:
1442: -- Procedure Delete_Row

Line 1476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1472: , 'Delete_Row'
1473: );
1474: END IF;
1475:
1476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1477:
1478: END Delete_Row;
1479:
1480: -- Function Query_Row

Line 1596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1592: , 'Query_Row'
1593: );
1594: END IF;
1595:
1596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1597:
1598: END Query_Row;
1599:
1600: -- Procedure lock_Row

Line 1798: x_return_status := FND_API.G_RET_STS_SUCCESS;

1794: x_LIMITS_rec := l_LIMITS_rec;
1795:
1796: -- Set return status
1797:
1798: x_return_status := FND_API.G_RET_STS_SUCCESS;
1799: x_LIMITS_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1800:
1801: ELSE
1802:

Line 1799: x_LIMITS_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1795:
1796: -- Set return status
1797:
1798: x_return_status := FND_API.G_RET_STS_SUCCESS;
1799: x_LIMITS_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1800:
1801: ELSE
1802:
1803: -- Row has changed by another user.

Line 1805: x_return_status := FND_API.G_RET_STS_ERROR;

1801: ELSE
1802:
1803: -- Row has changed by another user.
1804:
1805: x_return_status := FND_API.G_RET_STS_ERROR;
1806: x_LIMITS_rec.return_status := FND_API.G_RET_STS_ERROR;
1807:
1808: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1809: THEN

Line 1806: x_LIMITS_rec.return_status := FND_API.G_RET_STS_ERROR;

1802:
1803: -- Row has changed by another user.
1804:
1805: x_return_status := FND_API.G_RET_STS_ERROR;
1806: x_LIMITS_rec.return_status := FND_API.G_RET_STS_ERROR;
1807:
1808: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1809: THEN
1810:

Line 1822: x_return_status := FND_API.G_RET_STS_ERROR;

1818: EXCEPTION
1819:
1820: WHEN NO_DATA_FOUND THEN
1821:
1822: x_return_status := FND_API.G_RET_STS_ERROR;
1823: x_LIMITS_rec.return_status := FND_API.G_RET_STS_ERROR;
1824:
1825: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1826: THEN

Line 1823: x_LIMITS_rec.return_status := FND_API.G_RET_STS_ERROR;

1819:
1820: WHEN NO_DATA_FOUND THEN
1821:
1822: x_return_status := FND_API.G_RET_STS_ERROR;
1823: x_LIMITS_rec.return_status := FND_API.G_RET_STS_ERROR;
1824:
1825: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1826: THEN
1827:

Line 1834: x_return_status := FND_API.G_RET_STS_ERROR;

1830:
1831: END IF;
1832: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1833:
1834: x_return_status := FND_API.G_RET_STS_ERROR;
1835: x_LIMITS_rec.return_status := FND_API.G_RET_STS_ERROR;
1836:
1837: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1838: THEN

Line 1835: x_LIMITS_rec.return_status := FND_API.G_RET_STS_ERROR;

1831: END IF;
1832: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1833:
1834: x_return_status := FND_API.G_RET_STS_ERROR;
1835: x_LIMITS_rec.return_status := FND_API.G_RET_STS_ERROR;
1836:
1837: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1838: THEN
1839:

Line 1846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1842:
1843: END IF;
1844: WHEN OTHERS THEN
1845:
1846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1847: x_LIMITS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1848:
1849: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1850: THEN

Line 1847: x_LIMITS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1843: END IF;
1844: WHEN OTHERS THEN
1845:
1846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1847: x_LIMITS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1848:
1849: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1850: THEN
1851: OE_MSG_PUB.Add_Exc_Msg

Line 1871: p_LIMITS_rec.limit_exceed_action_code <> FND_API.G_MISS_CHAR AND

1867: l_LIMITS_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
1868: BEGIN
1869:
1870: IF p_LIMITS_rec.limit_exceed_action_code IS NOT NULL AND
1871: p_LIMITS_rec.limit_exceed_action_code <> FND_API.G_MISS_CHAR AND
1872: NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_exceed_action_code,
1873: p_old_LIMITS_rec.limit_exceed_action_code)
1874: THEN
1875: l_LIMITS_val_rec.limit_exceed_action := QP_Id_To_Value.Limit_Exceed_Action

Line 1881: p_LIMITS_rec.limit_id <> FND_API.G_MISS_NUM AND

1877: );
1878: END IF;
1879:
1880: IF p_LIMITS_rec.limit_id IS NOT NULL AND
1881: p_LIMITS_rec.limit_id <> FND_API.G_MISS_NUM AND
1882: NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_id,
1883: p_old_LIMITS_rec.limit_id)
1884: THEN
1885: l_LIMITS_val_rec.limit := QP_Id_To_Value.Limit

Line 1891: p_LIMITS_rec.limit_level_code <> FND_API.G_MISS_CHAR AND

1887: );
1888: END IF;
1889:
1890: IF p_LIMITS_rec.limit_level_code IS NOT NULL AND
1891: p_LIMITS_rec.limit_level_code <> FND_API.G_MISS_CHAR AND
1892: NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_level_code,
1893: p_old_LIMITS_rec.limit_level_code)
1894: THEN
1895: l_LIMITS_val_rec.limit_level := QP_Id_To_Value.Limit_Level

Line 1901: p_LIMITS_rec.list_header_id <> FND_API.G_MISS_NUM AND

1897: );
1898: END IF;
1899:
1900: IF p_LIMITS_rec.list_header_id IS NOT NULL AND
1901: p_LIMITS_rec.list_header_id <> FND_API.G_MISS_NUM AND
1902: NOT QP_GLOBALS.Equal(p_LIMITS_rec.list_header_id,
1903: p_old_LIMITS_rec.list_header_id)
1904: THEN
1905: l_LIMITS_val_rec.list_header := QP_Id_To_Value.List_Header

Line 1911: p_LIMITS_rec.list_line_id <> FND_API.G_MISS_NUM AND

1907: );
1908: END IF;
1909:
1910: IF p_LIMITS_rec.list_line_id IS NOT NULL AND
1911: p_LIMITS_rec.list_line_id <> FND_API.G_MISS_NUM AND
1912: NOT QP_GLOBALS.Equal(p_LIMITS_rec.list_line_id,
1913: p_old_LIMITS_rec.list_line_id)
1914: THEN
1915: l_LIMITS_val_rec.list_line := QP_Id_To_Value.List_Line

Line 1921: p_LIMITS_rec.organization_flag <> FND_API.G_MISS_CHAR AND

1917: );
1918: END IF;
1919:
1920: IF p_LIMITS_rec.organization_flag IS NOT NULL AND
1921: p_LIMITS_rec.organization_flag <> FND_API.G_MISS_CHAR AND
1922: NOT QP_GLOBALS.Equal(p_LIMITS_rec.organization_flag,
1923: p_old_LIMITS_rec.organization_flag)
1924: THEN
1925: l_LIMITS_val_rec.organization := QP_Id_To_Value.Organization

Line 1948: l_LIMITS_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1944: BEGIN
1945:
1946: -- initialize return_status.
1947:
1948: l_LIMITS_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1949:
1950: -- initialize l_LIMITS_rec.
1951:
1952: l_LIMITS_rec := p_LIMITS_rec;

Line 1954: IF p_LIMITS_val_rec.limit_exceed_action <> FND_API.G_MISS_CHAR

1950: -- initialize l_LIMITS_rec.
1951:
1952: l_LIMITS_rec := p_LIMITS_rec;
1953:
1954: IF p_LIMITS_val_rec.limit_exceed_action <> FND_API.G_MISS_CHAR
1955: THEN
1956:
1957: IF p_LIMITS_rec.limit_exceed_action_code <> FND_API.G_MISS_CHAR THEN
1958:

Line 1957: IF p_LIMITS_rec.limit_exceed_action_code <> FND_API.G_MISS_CHAR THEN

1953:
1954: IF p_LIMITS_val_rec.limit_exceed_action <> FND_API.G_MISS_CHAR
1955: THEN
1956:
1957: IF p_LIMITS_rec.limit_exceed_action_code <> FND_API.G_MISS_CHAR THEN
1958:
1959: l_LIMITS_rec.limit_exceed_action_code := p_LIMITS_rec.limit_exceed_action_code;
1960:
1961: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1976: IF l_LIMITS_rec.limit_exceed_action_code = FND_API.G_MISS_CHAR THEN

1972: l_LIMITS_rec.limit_exceed_action_code := QP_Value_To_Id.limit_exceed_action
1973: ( p_limit_exceed_action => p_LIMITS_val_rec.limit_exceed_action
1974: );
1975:
1976: IF l_LIMITS_rec.limit_exceed_action_code = FND_API.G_MISS_CHAR THEN
1977: l_LIMITS_rec.return_status := FND_API.G_RET_STS_ERROR;
1978: END IF;
1979:
1980: END IF;

Line 1977: l_LIMITS_rec.return_status := FND_API.G_RET_STS_ERROR;

1973: ( p_limit_exceed_action => p_LIMITS_val_rec.limit_exceed_action
1974: );
1975:
1976: IF l_LIMITS_rec.limit_exceed_action_code = FND_API.G_MISS_CHAR THEN
1977: l_LIMITS_rec.return_status := FND_API.G_RET_STS_ERROR;
1978: END IF;
1979:
1980: END IF;
1981:

Line 1984: IF p_LIMITS_val_rec.limit <> FND_API.G_MISS_CHAR

1980: END IF;
1981:
1982: END IF;
1983:
1984: IF p_LIMITS_val_rec.limit <> FND_API.G_MISS_CHAR
1985: THEN
1986:
1987: IF p_LIMITS_rec.limit_id <> FND_API.G_MISS_NUM THEN
1988:

Line 1987: IF p_LIMITS_rec.limit_id <> FND_API.G_MISS_NUM THEN

1983:
1984: IF p_LIMITS_val_rec.limit <> FND_API.G_MISS_CHAR
1985: THEN
1986:
1987: IF p_LIMITS_rec.limit_id <> FND_API.G_MISS_NUM THEN
1988:
1989: l_LIMITS_rec.limit_id := p_LIMITS_rec.limit_id;
1990:
1991: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2006: IF l_LIMITS_rec.limit_id = FND_API.G_MISS_NUM THEN

2002: l_LIMITS_rec.limit_id := QP_Value_To_Id.limit
2003: ( p_limit => p_LIMITS_val_rec.limit
2004: );
2005:
2006: IF l_LIMITS_rec.limit_id = FND_API.G_MISS_NUM THEN
2007: l_LIMITS_rec.return_status := FND_API.G_RET_STS_ERROR;
2008: END IF;
2009:
2010: END IF;

Line 2007: l_LIMITS_rec.return_status := FND_API.G_RET_STS_ERROR;

2003: ( p_limit => p_LIMITS_val_rec.limit
2004: );
2005:
2006: IF l_LIMITS_rec.limit_id = FND_API.G_MISS_NUM THEN
2007: l_LIMITS_rec.return_status := FND_API.G_RET_STS_ERROR;
2008: END IF;
2009:
2010: END IF;
2011:

Line 2014: IF p_LIMITS_val_rec.limit_level <> FND_API.G_MISS_CHAR

2010: END IF;
2011:
2012: END IF;
2013:
2014: IF p_LIMITS_val_rec.limit_level <> FND_API.G_MISS_CHAR
2015: THEN
2016:
2017: IF p_LIMITS_rec.limit_level_code <> FND_API.G_MISS_CHAR THEN
2018:

Line 2017: IF p_LIMITS_rec.limit_level_code <> FND_API.G_MISS_CHAR THEN

2013:
2014: IF p_LIMITS_val_rec.limit_level <> FND_API.G_MISS_CHAR
2015: THEN
2016:
2017: IF p_LIMITS_rec.limit_level_code <> FND_API.G_MISS_CHAR THEN
2018:
2019: l_LIMITS_rec.limit_level_code := p_LIMITS_rec.limit_level_code;
2020:
2021: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2036: IF l_LIMITS_rec.limit_level_code = FND_API.G_MISS_CHAR THEN

2032: l_LIMITS_rec.limit_level_code := QP_Value_To_Id.limit_level
2033: ( p_limit_level => p_LIMITS_val_rec.limit_level
2034: );
2035:
2036: IF l_LIMITS_rec.limit_level_code = FND_API.G_MISS_CHAR THEN
2037: l_LIMITS_rec.return_status := FND_API.G_RET_STS_ERROR;
2038: END IF;
2039:
2040: END IF;

Line 2037: l_LIMITS_rec.return_status := FND_API.G_RET_STS_ERROR;

2033: ( p_limit_level => p_LIMITS_val_rec.limit_level
2034: );
2035:
2036: IF l_LIMITS_rec.limit_level_code = FND_API.G_MISS_CHAR THEN
2037: l_LIMITS_rec.return_status := FND_API.G_RET_STS_ERROR;
2038: END IF;
2039:
2040: END IF;
2041:

Line 2044: IF p_LIMITS_val_rec.list_header <> FND_API.G_MISS_CHAR

2040: END IF;
2041:
2042: END IF;
2043:
2044: IF p_LIMITS_val_rec.list_header <> FND_API.G_MISS_CHAR
2045: THEN
2046:
2047: IF p_LIMITS_rec.list_header_id <> FND_API.G_MISS_NUM THEN
2048:

Line 2047: IF p_LIMITS_rec.list_header_id <> FND_API.G_MISS_NUM THEN

2043:
2044: IF p_LIMITS_val_rec.list_header <> FND_API.G_MISS_CHAR
2045: THEN
2046:
2047: IF p_LIMITS_rec.list_header_id <> FND_API.G_MISS_NUM THEN
2048:
2049: l_LIMITS_rec.list_header_id := p_LIMITS_rec.list_header_id;
2050:
2051: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2066: IF l_LIMITS_rec.list_header_id = FND_API.G_MISS_NUM THEN

2062: l_LIMITS_rec.list_header_id := QP_Value_To_Id.list_header
2063: ( p_list_header => p_LIMITS_val_rec.list_header
2064: );
2065:
2066: IF l_LIMITS_rec.list_header_id = FND_API.G_MISS_NUM THEN
2067: l_LIMITS_rec.return_status := FND_API.G_RET_STS_ERROR;
2068: END IF;
2069:
2070: END IF;

Line 2067: l_LIMITS_rec.return_status := FND_API.G_RET_STS_ERROR;

2063: ( p_list_header => p_LIMITS_val_rec.list_header
2064: );
2065:
2066: IF l_LIMITS_rec.list_header_id = FND_API.G_MISS_NUM THEN
2067: l_LIMITS_rec.return_status := FND_API.G_RET_STS_ERROR;
2068: END IF;
2069:
2070: END IF;
2071:

Line 2074: IF p_LIMITS_val_rec.list_line <> FND_API.G_MISS_CHAR

2070: END IF;
2071:
2072: END IF;
2073:
2074: IF p_LIMITS_val_rec.list_line <> FND_API.G_MISS_CHAR
2075: THEN
2076:
2077: IF p_LIMITS_rec.list_line_id <> FND_API.G_MISS_NUM THEN
2078:

Line 2077: IF p_LIMITS_rec.list_line_id <> FND_API.G_MISS_NUM THEN

2073:
2074: IF p_LIMITS_val_rec.list_line <> FND_API.G_MISS_CHAR
2075: THEN
2076:
2077: IF p_LIMITS_rec.list_line_id <> FND_API.G_MISS_NUM THEN
2078:
2079: l_LIMITS_rec.list_line_id := p_LIMITS_rec.list_line_id;
2080:
2081: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2096: IF l_LIMITS_rec.list_line_id = FND_API.G_MISS_NUM THEN

2092: l_LIMITS_rec.list_line_id := QP_Value_To_Id.list_line
2093: ( p_list_line => p_LIMITS_val_rec.list_line
2094: );
2095:
2096: IF l_LIMITS_rec.list_line_id = FND_API.G_MISS_NUM THEN
2097: l_LIMITS_rec.return_status := FND_API.G_RET_STS_ERROR;
2098: END IF;
2099:
2100: END IF;

Line 2097: l_LIMITS_rec.return_status := FND_API.G_RET_STS_ERROR;

2093: ( p_list_line => p_LIMITS_val_rec.list_line
2094: );
2095:
2096: IF l_LIMITS_rec.list_line_id = FND_API.G_MISS_NUM THEN
2097: l_LIMITS_rec.return_status := FND_API.G_RET_STS_ERROR;
2098: END IF;
2099:
2100: END IF;
2101:

Line 2104: IF p_LIMITS_val_rec.organization <> FND_API.G_MISS_CHAR

2100: END IF;
2101:
2102: END IF;
2103:
2104: IF p_LIMITS_val_rec.organization <> FND_API.G_MISS_CHAR
2105: THEN
2106:
2107: IF p_LIMITS_rec.organization_flag <> FND_API.G_MISS_CHAR THEN
2108:

Line 2107: IF p_LIMITS_rec.organization_flag <> FND_API.G_MISS_CHAR THEN

2103:
2104: IF p_LIMITS_val_rec.organization <> FND_API.G_MISS_CHAR
2105: THEN
2106:
2107: IF p_LIMITS_rec.organization_flag <> FND_API.G_MISS_CHAR THEN
2108:
2109: l_LIMITS_rec.organization_flag := p_LIMITS_rec.organization_flag;
2110:
2111: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2126: IF l_LIMITS_rec.organization_flag = FND_API.G_MISS_CHAR THEN

2122: l_LIMITS_rec.organization_flag := QP_Value_To_Id.organization
2123: ( p_organization => p_LIMITS_val_rec.organization
2124: );
2125:
2126: IF l_LIMITS_rec.organization_flag = FND_API.G_MISS_CHAR THEN
2127: l_LIMITS_rec.return_status := FND_API.G_RET_STS_ERROR;
2128: END IF;
2129:
2130: END IF;

Line 2127: l_LIMITS_rec.return_status := FND_API.G_RET_STS_ERROR;

2123: ( p_organization => p_LIMITS_val_rec.organization
2124: );
2125:
2126: IF l_LIMITS_rec.organization_flag = FND_API.G_MISS_CHAR THEN
2127: l_LIMITS_rec.return_status := FND_API.G_RET_STS_ERROR;
2128: END IF;
2129:
2130: END IF;
2131:

Line 2166: WHEN FND_API.G_EXC_ERROR THEN

2162: null;
2163: x_LIMITS_rec := l_LIMITS_rec;
2164:
2165: EXCEPTION
2166: WHEN FND_API.G_EXC_ERROR THEN
2167: RAISE;
2168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2169: RAISE;
2170: WHEN OTHERS THEN

Line 2168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2164:
2165: EXCEPTION
2166: WHEN FND_API.G_EXC_ERROR THEN
2167: RAISE;
2168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2169: RAISE;
2170: WHEN OTHERS THEN
2171: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2172: THEN

Line 2178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2174: ( G_PKG_NAME
2175: , 'Pre_Write_Process'
2176: );
2177: END IF;
2178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2179:
2180: END Pre_Write_Process;
2181:
2182: