eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_PRICING_ATTR_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_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
13: , p_old_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type :=
14: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_REC
15: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Rec_Type

Line 32: IF p_attr_id = FND_API.G_MISS_NUM THEN

28:
29: -- If attr_id is missing compare old and new records and for
30: -- every changed attribute clear its dependent fields.
31:
32: IF p_attr_id = FND_API.G_MISS_NUM THEN
33:
34: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.accumulate_flag,p_old_PRICING_ATTR_rec.accumulate_flag)
35: THEN
36: l_index := l_index + 1;

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

436: x_attribute_flag VARCHAR2(1);
437: x_value_flag VARCHAR2(1);
438: x_precedence NUMBER;
439: x_error_code NUMBER := 0;
440: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
441: --Bug 4706180
442: l_rltd_modifier_grp_type VARCHAR2(30);
443:
444: BEGIN

Line 644: p_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM THEN

640: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_header_id,p_old_PRICING_ATTR_rec.list_header_id)
641: THEN
642: /* commented this part as it is not reqd- spgopal
643: IF p_PRICING_ATTR_rec.list_header_id IS NULL OR
644: p_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM THEN
645:
646: BEGIN
647:
648: oe_debug_pub.add('list_line_id in apply gsp'||to_char(p_PRICING_ATTR_rec.list_line_id));

Line 669: p_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN

665: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_phase_id,p_old_PRICING_ATTR_rec.pricing_phase_id)
666: THEN
667: /* commented this part as it is not reqd - spgopal
668: IF p_PRICING_ATTR_rec.pricing_phase_id IS NULL OR
669: p_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN
670:
671: BEGIN
672: oe_debug_pub.add('list_line_id in apply gsp'||to_char(p_PRICING_ATTR_rec.list_line_id));
673: select pricing_phase_id into x_PRICING_ATTR_rec.pricing_phase_id

Line 874: IF l_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR THEN

870: BEGIN
871:
872: oe_debug_pub.add('BEGIN Complete_Record in QPXUPRAB');
873:
874: IF l_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR THEN
875: l_PRICING_ATTR_rec.accumulate_flag := p_old_PRICING_ATTR_rec.accumulate_flag;
876: END IF;
877:
878: IF l_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 878: IF l_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR THEN

874: IF l_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR THEN
875: l_PRICING_ATTR_rec.accumulate_flag := p_old_PRICING_ATTR_rec.accumulate_flag;
876: END IF;
877:
878: IF l_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR THEN
879: l_PRICING_ATTR_rec.attribute1 := p_old_PRICING_ATTR_rec.attribute1;
880: END IF;
881:
882: IF l_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 882: IF l_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR THEN

878: IF l_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR THEN
879: l_PRICING_ATTR_rec.attribute1 := p_old_PRICING_ATTR_rec.attribute1;
880: END IF;
881:
882: IF l_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR THEN
883: l_PRICING_ATTR_rec.attribute10 := p_old_PRICING_ATTR_rec.attribute10;
884: END IF;
885:
886: IF l_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 886: IF l_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR THEN

882: IF l_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR THEN
883: l_PRICING_ATTR_rec.attribute10 := p_old_PRICING_ATTR_rec.attribute10;
884: END IF;
885:
886: IF l_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR THEN
887: l_PRICING_ATTR_rec.attribute11 := p_old_PRICING_ATTR_rec.attribute11;
888: END IF;
889:
890: IF l_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 890: IF l_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR THEN

886: IF l_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR THEN
887: l_PRICING_ATTR_rec.attribute11 := p_old_PRICING_ATTR_rec.attribute11;
888: END IF;
889:
890: IF l_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR THEN
891: l_PRICING_ATTR_rec.attribute12 := p_old_PRICING_ATTR_rec.attribute12;
892: END IF;
893:
894: IF l_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 894: IF l_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR THEN

890: IF l_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR THEN
891: l_PRICING_ATTR_rec.attribute12 := p_old_PRICING_ATTR_rec.attribute12;
892: END IF;
893:
894: IF l_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR THEN
895: l_PRICING_ATTR_rec.attribute13 := p_old_PRICING_ATTR_rec.attribute13;
896: END IF;
897:
898: IF l_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 898: IF l_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR THEN

894: IF l_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR THEN
895: l_PRICING_ATTR_rec.attribute13 := p_old_PRICING_ATTR_rec.attribute13;
896: END IF;
897:
898: IF l_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR THEN
899: l_PRICING_ATTR_rec.attribute14 := p_old_PRICING_ATTR_rec.attribute14;
900: END IF;
901:
902: IF l_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 902: IF l_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR THEN

898: IF l_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR THEN
899: l_PRICING_ATTR_rec.attribute14 := p_old_PRICING_ATTR_rec.attribute14;
900: END IF;
901:
902: IF l_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR THEN
903: l_PRICING_ATTR_rec.attribute15 := p_old_PRICING_ATTR_rec.attribute15;
904: END IF;
905:
906: IF l_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 906: IF l_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR THEN

902: IF l_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR THEN
903: l_PRICING_ATTR_rec.attribute15 := p_old_PRICING_ATTR_rec.attribute15;
904: END IF;
905:
906: IF l_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR THEN
907: l_PRICING_ATTR_rec.attribute2 := p_old_PRICING_ATTR_rec.attribute2;
908: END IF;
909:
910: IF l_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 910: IF l_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR THEN

906: IF l_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR THEN
907: l_PRICING_ATTR_rec.attribute2 := p_old_PRICING_ATTR_rec.attribute2;
908: END IF;
909:
910: IF l_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR THEN
911: l_PRICING_ATTR_rec.attribute3 := p_old_PRICING_ATTR_rec.attribute3;
912: END IF;
913:
914: IF l_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 914: IF l_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR THEN

910: IF l_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR THEN
911: l_PRICING_ATTR_rec.attribute3 := p_old_PRICING_ATTR_rec.attribute3;
912: END IF;
913:
914: IF l_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR THEN
915: l_PRICING_ATTR_rec.attribute4 := p_old_PRICING_ATTR_rec.attribute4;
916: END IF;
917:
918: IF l_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 918: IF l_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR THEN

914: IF l_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR THEN
915: l_PRICING_ATTR_rec.attribute4 := p_old_PRICING_ATTR_rec.attribute4;
916: END IF;
917:
918: IF l_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR THEN
919: l_PRICING_ATTR_rec.attribute5 := p_old_PRICING_ATTR_rec.attribute5;
920: END IF;
921:
922: IF l_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 922: IF l_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR THEN

918: IF l_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR THEN
919: l_PRICING_ATTR_rec.attribute5 := p_old_PRICING_ATTR_rec.attribute5;
920: END IF;
921:
922: IF l_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR THEN
923: l_PRICING_ATTR_rec.attribute6 := p_old_PRICING_ATTR_rec.attribute6;
924: END IF;
925:
926: IF l_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 926: IF l_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR THEN

922: IF l_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR THEN
923: l_PRICING_ATTR_rec.attribute6 := p_old_PRICING_ATTR_rec.attribute6;
924: END IF;
925:
926: IF l_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR THEN
927: l_PRICING_ATTR_rec.attribute7 := p_old_PRICING_ATTR_rec.attribute7;
928: END IF;
929:
930: IF l_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 930: IF l_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR THEN

926: IF l_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR THEN
927: l_PRICING_ATTR_rec.attribute7 := p_old_PRICING_ATTR_rec.attribute7;
928: END IF;
929:
930: IF l_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR THEN
931: l_PRICING_ATTR_rec.attribute8 := p_old_PRICING_ATTR_rec.attribute8;
932: END IF;
933:
934: IF l_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 934: IF l_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR THEN

930: IF l_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR THEN
931: l_PRICING_ATTR_rec.attribute8 := p_old_PRICING_ATTR_rec.attribute8;
932: END IF;
933:
934: IF l_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR THEN
935: l_PRICING_ATTR_rec.attribute9 := p_old_PRICING_ATTR_rec.attribute9;
936: END IF;
937:
938: IF l_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM THEN

Line 938: IF l_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM THEN

934: IF l_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR THEN
935: l_PRICING_ATTR_rec.attribute9 := p_old_PRICING_ATTR_rec.attribute9;
936: END IF;
937:
938: IF l_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM THEN
939: l_PRICING_ATTR_rec.attribute_grouping_no := p_old_PRICING_ATTR_rec.attribute_grouping_no;
940: END IF;
941:
942: IF l_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR THEN

Line 942: IF l_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR THEN

938: IF l_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM THEN
939: l_PRICING_ATTR_rec.attribute_grouping_no := p_old_PRICING_ATTR_rec.attribute_grouping_no;
940: END IF;
941:
942: IF l_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR THEN
943: l_PRICING_ATTR_rec.context := p_old_PRICING_ATTR_rec.context;
944: END IF;
945:
946: IF l_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM THEN

Line 946: IF l_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM THEN

942: IF l_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR THEN
943: l_PRICING_ATTR_rec.context := p_old_PRICING_ATTR_rec.context;
944: END IF;
945:
946: IF l_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM THEN
947: l_PRICING_ATTR_rec.created_by := p_old_PRICING_ATTR_rec.created_by;
948: END IF;
949:
950: IF l_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 950: IF l_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE THEN

946: IF l_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM THEN
947: l_PRICING_ATTR_rec.created_by := p_old_PRICING_ATTR_rec.created_by;
948: END IF;
949:
950: IF l_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE THEN
951: l_PRICING_ATTR_rec.creation_date := p_old_PRICING_ATTR_rec.creation_date;
952: END IF;
953:
954: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN

Line 954: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN

950: IF l_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE THEN
951: l_PRICING_ATTR_rec.creation_date := p_old_PRICING_ATTR_rec.creation_date;
952: END IF;
953:
954: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
955: l_PRICING_ATTR_rec.excluder_flag := p_old_PRICING_ATTR_rec.excluder_flag;
956: END IF;
957:
958: IF l_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 958: IF l_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM THEN

954: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
955: l_PRICING_ATTR_rec.excluder_flag := p_old_PRICING_ATTR_rec.excluder_flag;
956: END IF;
957:
958: IF l_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM THEN
959: l_PRICING_ATTR_rec.last_updated_by := p_old_PRICING_ATTR_rec.last_updated_by;
960: END IF;
961:
962: IF l_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 962: IF l_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE THEN

958: IF l_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM THEN
959: l_PRICING_ATTR_rec.last_updated_by := p_old_PRICING_ATTR_rec.last_updated_by;
960: END IF;
961:
962: IF l_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE THEN
963: l_PRICING_ATTR_rec.last_update_date := p_old_PRICING_ATTR_rec.last_update_date;
964: END IF;
965:
966: IF l_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 966: IF l_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM THEN

962: IF l_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE THEN
963: l_PRICING_ATTR_rec.last_update_date := p_old_PRICING_ATTR_rec.last_update_date;
964: END IF;
965:
966: IF l_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM THEN
967: l_PRICING_ATTR_rec.last_update_login := p_old_PRICING_ATTR_rec.last_update_login;
968: END IF;
969:
970: /*included by spgopal to include list_header_id in pricing attr for performance problems*/

Line 971: IF l_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM THEN

967: l_PRICING_ATTR_rec.last_update_login := p_old_PRICING_ATTR_rec.last_update_login;
968: END IF;
969:
970: /*included by spgopal to include list_header_id in pricing attr for performance problems*/
971: IF l_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM THEN
972: l_PRICING_ATTR_rec.list_header_id := p_old_PRICING_ATTR_rec.list_header_id;
973: END IF;
974:
975: /*included by spgopal to include pricing_phase_id in pricing attr for performance problems*/

Line 976: IF l_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN

972: l_PRICING_ATTR_rec.list_header_id := p_old_PRICING_ATTR_rec.list_header_id;
973: END IF;
974:
975: /*included by spgopal to include pricing_phase_id in pricing attr for performance problems*/
976: IF l_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN
977: l_PRICING_ATTR_rec.pricing_phase_id := p_old_PRICING_ATTR_rec.pricing_phase_id;
978: END IF;
979:
980: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN

Line 980: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN

976: IF l_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN
977: l_PRICING_ATTR_rec.pricing_phase_id := p_old_PRICING_ATTR_rec.pricing_phase_id;
978: END IF;
979:
980: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN
981: l_PRICING_ATTR_rec.list_line_id := p_old_PRICING_ATTR_rec.list_line_id;
982: END IF;
983:
984: IF l_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN

Line 984: IF l_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN

980: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN
981: l_PRICING_ATTR_rec.list_line_id := p_old_PRICING_ATTR_rec.list_line_id;
982: END IF;
983:
984: IF l_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN
985: l_PRICING_ATTR_rec.pricing_attribute := p_old_PRICING_ATTR_rec.pricing_attribute;
986: END IF;
987:
988: IF l_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN

Line 988: IF l_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN

984: IF l_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN
985: l_PRICING_ATTR_rec.pricing_attribute := p_old_PRICING_ATTR_rec.pricing_attribute;
986: END IF;
987:
988: IF l_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN
989: l_PRICING_ATTR_rec.pricing_attribute_context := p_old_PRICING_ATTR_rec.pricing_attribute_context;
990: END IF;
991:
992: IF l_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN

Line 992: IF l_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN

988: IF l_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN
989: l_PRICING_ATTR_rec.pricing_attribute_context := p_old_PRICING_ATTR_rec.pricing_attribute_context;
990: END IF;
991:
992: IF l_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN
993: l_PRICING_ATTR_rec.pricing_attribute_id := p_old_PRICING_ATTR_rec.pricing_attribute_id;
994: END IF;
995:
996: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN

Line 996: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN

992: IF l_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN
993: l_PRICING_ATTR_rec.pricing_attribute_id := p_old_PRICING_ATTR_rec.pricing_attribute_id;
994: END IF;
995:
996: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN
997: l_PRICING_ATTR_rec.pricing_attr_value_from := p_old_PRICING_ATTR_rec.pricing_attr_value_from;
998: END IF;
999:
1000: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN

Line 1000: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN

996: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN
997: l_PRICING_ATTR_rec.pricing_attr_value_from := p_old_PRICING_ATTR_rec.pricing_attr_value_from;
998: END IF;
999:
1000: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN
1001: l_PRICING_ATTR_rec.pricing_attr_value_to := p_old_PRICING_ATTR_rec.pricing_attr_value_to;
1002: END IF;
1003:
1004: IF l_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR THEN

Line 1004: IF l_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR THEN

1000: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN
1001: l_PRICING_ATTR_rec.pricing_attr_value_to := p_old_PRICING_ATTR_rec.pricing_attr_value_to;
1002: END IF;
1003:
1004: IF l_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR THEN
1005: l_PRICING_ATTR_rec.product_attribute := p_old_PRICING_ATTR_rec.product_attribute;
1006: END IF;
1007:
1008: IF l_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR THEN

Line 1008: IF l_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR THEN

1004: IF l_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR THEN
1005: l_PRICING_ATTR_rec.product_attribute := p_old_PRICING_ATTR_rec.product_attribute;
1006: END IF;
1007:
1008: IF l_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR THEN
1009: l_PRICING_ATTR_rec.product_attribute_context := p_old_PRICING_ATTR_rec.product_attribute_context;
1010: END IF;
1011:
1012: IF l_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR THEN

Line 1012: IF l_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR THEN

1008: IF l_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR THEN
1009: l_PRICING_ATTR_rec.product_attribute_context := p_old_PRICING_ATTR_rec.product_attribute_context;
1010: END IF;
1011:
1012: IF l_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR THEN
1013: l_PRICING_ATTR_rec.product_attr_value := p_old_PRICING_ATTR_rec.product_attr_value;
1014: END IF;
1015:
1016: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN

Line 1016: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN

1012: IF l_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR THEN
1013: l_PRICING_ATTR_rec.product_attr_value := p_old_PRICING_ATTR_rec.product_attr_value;
1014: END IF;
1015:
1016: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN
1017: l_PRICING_ATTR_rec.product_uom_code := p_old_PRICING_ATTR_rec.product_uom_code;
1018: END IF;
1019:
1020: IF l_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 1020: IF l_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM THEN

1016: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN
1017: l_PRICING_ATTR_rec.product_uom_code := p_old_PRICING_ATTR_rec.product_uom_code;
1018: END IF;
1019:
1020: IF l_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM THEN
1021: l_PRICING_ATTR_rec.program_application_id := p_old_PRICING_ATTR_rec.program_application_id;
1022: END IF;
1023:
1024: IF l_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM THEN

Line 1024: IF l_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM THEN

1020: IF l_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM THEN
1021: l_PRICING_ATTR_rec.program_application_id := p_old_PRICING_ATTR_rec.program_application_id;
1022: END IF;
1023:
1024: IF l_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM THEN
1025: l_PRICING_ATTR_rec.program_id := p_old_PRICING_ATTR_rec.program_id;
1026: END IF;
1027:
1028: IF l_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 1028: IF l_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE THEN

1024: IF l_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM THEN
1025: l_PRICING_ATTR_rec.program_id := p_old_PRICING_ATTR_rec.program_id;
1026: END IF;
1027:
1028: IF l_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE THEN
1029: l_PRICING_ATTR_rec.program_update_date := p_old_PRICING_ATTR_rec.program_update_date;
1030: END IF;
1031:
1032: IF l_PRICING_ATTR_rec.request_id = FND_API.G_MISS_NUM THEN

Line 1032: IF l_PRICING_ATTR_rec.request_id = FND_API.G_MISS_NUM THEN

1028: IF l_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE THEN
1029: l_PRICING_ATTR_rec.program_update_date := p_old_PRICING_ATTR_rec.program_update_date;
1030: END IF;
1031:
1032: IF l_PRICING_ATTR_rec.request_id = FND_API.G_MISS_NUM THEN
1033: l_PRICING_ATTR_rec.request_id := p_old_PRICING_ATTR_rec.request_id;
1034: END IF;
1035:
1036: IF l_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR THEN

Line 1036: IF l_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR THEN

1032: IF l_PRICING_ATTR_rec.request_id = FND_API.G_MISS_NUM THEN
1033: l_PRICING_ATTR_rec.request_id := p_old_PRICING_ATTR_rec.request_id;
1034: END IF;
1035:
1036: IF l_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR THEN
1037: l_PRICING_ATTR_rec.product_attribute_datatype := p_old_PRICING_ATTR_rec.product_attribute_datatype;
1038: END IF;
1039:
1040: IF l_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR THEN

Line 1040: IF l_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR THEN

1036: IF l_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR THEN
1037: l_PRICING_ATTR_rec.product_attribute_datatype := p_old_PRICING_ATTR_rec.product_attribute_datatype;
1038: END IF;
1039:
1040: IF l_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR THEN
1041: l_PRICING_ATTR_rec.pricing_attribute_datatype := p_old_PRICING_ATTR_rec.pricing_attribute_datatype;
1042: END IF;
1043:
1044: IF l_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN

Line 1044: IF l_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN

1040: IF l_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR THEN
1041: l_PRICING_ATTR_rec.pricing_attribute_datatype := p_old_PRICING_ATTR_rec.pricing_attribute_datatype;
1042: END IF;
1043:
1044: IF l_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN
1045: l_PRICING_ATTR_rec.comparison_operator_code := p_old_PRICING_ATTR_rec.comparison_operator_code;
1046: END IF;
1047:
1048: oe_debug_pub.add('END Complete_Record in QPXUPRAB');

Line 1065: IF l_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR THEN

1061: BEGIN
1062:
1063: oe_debug_pub.add('BEGIN Convert_Miss_To_Null in QPXUPRAB');
1064:
1065: IF l_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR THEN
1066: l_PRICING_ATTR_rec.accumulate_flag := NULL;
1067: END IF;
1068:
1069: IF l_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 1069: IF l_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR THEN

1065: IF l_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR THEN
1066: l_PRICING_ATTR_rec.accumulate_flag := NULL;
1067: END IF;
1068:
1069: IF l_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1070: l_PRICING_ATTR_rec.attribute1 := NULL;
1071: END IF;
1072:
1073: IF l_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 1073: IF l_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR THEN

1069: IF l_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1070: l_PRICING_ATTR_rec.attribute1 := NULL;
1071: END IF;
1072:
1073: IF l_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1074: l_PRICING_ATTR_rec.attribute10 := NULL;
1075: END IF;
1076:
1077: IF l_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 1077: IF l_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR THEN

1073: IF l_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1074: l_PRICING_ATTR_rec.attribute10 := NULL;
1075: END IF;
1076:
1077: IF l_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1078: l_PRICING_ATTR_rec.attribute11 := NULL;
1079: END IF;
1080:
1081: IF l_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 1081: IF l_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR THEN

1077: IF l_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1078: l_PRICING_ATTR_rec.attribute11 := NULL;
1079: END IF;
1080:
1081: IF l_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1082: l_PRICING_ATTR_rec.attribute12 := NULL;
1083: END IF;
1084:
1085: IF l_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 1085: IF l_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR THEN

1081: IF l_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1082: l_PRICING_ATTR_rec.attribute12 := NULL;
1083: END IF;
1084:
1085: IF l_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1086: l_PRICING_ATTR_rec.attribute13 := NULL;
1087: END IF;
1088:
1089: IF l_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 1089: IF l_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR THEN

1085: IF l_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1086: l_PRICING_ATTR_rec.attribute13 := NULL;
1087: END IF;
1088:
1089: IF l_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1090: l_PRICING_ATTR_rec.attribute14 := NULL;
1091: END IF;
1092:
1093: IF l_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 1093: IF l_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR THEN

1089: IF l_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1090: l_PRICING_ATTR_rec.attribute14 := NULL;
1091: END IF;
1092:
1093: IF l_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1094: l_PRICING_ATTR_rec.attribute15 := NULL;
1095: END IF;
1096:
1097: IF l_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 1097: IF l_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR THEN

1093: IF l_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1094: l_PRICING_ATTR_rec.attribute15 := NULL;
1095: END IF;
1096:
1097: IF l_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1098: l_PRICING_ATTR_rec.attribute2 := NULL;
1099: END IF;
1100:
1101: IF l_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 1101: IF l_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR THEN

1097: IF l_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1098: l_PRICING_ATTR_rec.attribute2 := NULL;
1099: END IF;
1100:
1101: IF l_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1102: l_PRICING_ATTR_rec.attribute3 := NULL;
1103: END IF;
1104:
1105: IF l_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 1105: IF l_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR THEN

1101: IF l_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1102: l_PRICING_ATTR_rec.attribute3 := NULL;
1103: END IF;
1104:
1105: IF l_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1106: l_PRICING_ATTR_rec.attribute4 := NULL;
1107: END IF;
1108:
1109: IF l_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 1109: IF l_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR THEN

1105: IF l_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1106: l_PRICING_ATTR_rec.attribute4 := NULL;
1107: END IF;
1108:
1109: IF l_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1110: l_PRICING_ATTR_rec.attribute5 := NULL;
1111: END IF;
1112:
1113: IF l_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 1113: IF l_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR THEN

1109: IF l_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1110: l_PRICING_ATTR_rec.attribute5 := NULL;
1111: END IF;
1112:
1113: IF l_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1114: l_PRICING_ATTR_rec.attribute6 := NULL;
1115: END IF;
1116:
1117: IF l_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 1117: IF l_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR THEN

1113: IF l_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1114: l_PRICING_ATTR_rec.attribute6 := NULL;
1115: END IF;
1116:
1117: IF l_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1118: l_PRICING_ATTR_rec.attribute7 := NULL;
1119: END IF;
1120:
1121: IF l_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 1121: IF l_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR THEN

1117: IF l_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1118: l_PRICING_ATTR_rec.attribute7 := NULL;
1119: END IF;
1120:
1121: IF l_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1122: l_PRICING_ATTR_rec.attribute8 := NULL;
1123: END IF;
1124:
1125: IF l_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 1125: IF l_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR THEN

1121: IF l_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1122: l_PRICING_ATTR_rec.attribute8 := NULL;
1123: END IF;
1124:
1125: IF l_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1126: l_PRICING_ATTR_rec.attribute9 := NULL;
1127: END IF;
1128:
1129: IF l_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM THEN

Line 1129: IF l_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM THEN

1125: IF l_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1126: l_PRICING_ATTR_rec.attribute9 := NULL;
1127: END IF;
1128:
1129: IF l_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM THEN
1130: l_PRICING_ATTR_rec.attribute_grouping_no := NULL;
1131: END IF;
1132:
1133: IF l_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR THEN

Line 1133: IF l_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR THEN

1129: IF l_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM THEN
1130: l_PRICING_ATTR_rec.attribute_grouping_no := NULL;
1131: END IF;
1132:
1133: IF l_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR THEN
1134: l_PRICING_ATTR_rec.context := NULL;
1135: END IF;
1136:
1137: IF l_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM THEN

Line 1137: IF l_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM THEN

1133: IF l_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR THEN
1134: l_PRICING_ATTR_rec.context := NULL;
1135: END IF;
1136:
1137: IF l_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM THEN
1138: l_PRICING_ATTR_rec.created_by := NULL;
1139: END IF;
1140:
1141: IF l_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 1141: IF l_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE THEN

1137: IF l_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM THEN
1138: l_PRICING_ATTR_rec.created_by := NULL;
1139: END IF;
1140:
1141: IF l_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE THEN
1142: l_PRICING_ATTR_rec.creation_date := NULL;
1143: END IF;
1144:
1145: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN

Line 1145: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN

1141: IF l_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE THEN
1142: l_PRICING_ATTR_rec.creation_date := NULL;
1143: END IF;
1144:
1145: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
1146: l_PRICING_ATTR_rec.excluder_flag := NULL;
1147: END IF;
1148:
1149: IF l_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 1149: IF l_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM THEN

1145: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
1146: l_PRICING_ATTR_rec.excluder_flag := NULL;
1147: END IF;
1148:
1149: IF l_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1150: l_PRICING_ATTR_rec.last_updated_by := NULL;
1151: END IF;
1152:
1153: IF l_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 1153: IF l_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE THEN

1149: IF l_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1150: l_PRICING_ATTR_rec.last_updated_by := NULL;
1151: END IF;
1152:
1153: IF l_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE THEN
1154: l_PRICING_ATTR_rec.last_update_date := NULL;
1155: END IF;
1156:
1157: IF l_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 1157: IF l_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM THEN

1153: IF l_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE THEN
1154: l_PRICING_ATTR_rec.last_update_date := NULL;
1155: END IF;
1156:
1157: IF l_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM THEN
1158: l_PRICING_ATTR_rec.last_update_login := NULL;
1159: END IF;
1160:
1161: /*included by spgopal to include list_header_id in pricing attr for performance problems*/

Line 1162: IF l_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM THEN

1158: l_PRICING_ATTR_rec.last_update_login := NULL;
1159: END IF;
1160:
1161: /*included by spgopal to include list_header_id in pricing attr for performance problems*/
1162: IF l_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM THEN
1163: l_PRICING_ATTR_rec.list_header_id := NULL;
1164: END IF;
1165:
1166: /*included by spgopal to include pricing_phase_id in pricing attr for performance problems*/

Line 1167: IF l_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN

1163: l_PRICING_ATTR_rec.list_header_id := NULL;
1164: END IF;
1165:
1166: /*included by spgopal to include pricing_phase_id in pricing attr for performance problems*/
1167: IF l_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN
1168: l_PRICING_ATTR_rec.pricing_phase_id := NULL;
1169: END IF;
1170:
1171: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN

Line 1171: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN

1167: IF l_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN
1168: l_PRICING_ATTR_rec.pricing_phase_id := NULL;
1169: END IF;
1170:
1171: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN
1172: l_PRICING_ATTR_rec.list_line_id := NULL;
1173: END IF;
1174:
1175: IF l_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN

Line 1175: IF l_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN

1171: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN
1172: l_PRICING_ATTR_rec.list_line_id := NULL;
1173: END IF;
1174:
1175: IF l_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN
1176: l_PRICING_ATTR_rec.pricing_attribute := NULL;
1177: END IF;
1178:
1179: IF l_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN

Line 1179: IF l_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN

1175: IF l_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN
1176: l_PRICING_ATTR_rec.pricing_attribute := NULL;
1177: END IF;
1178:
1179: IF l_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN
1180: l_PRICING_ATTR_rec.pricing_attribute_context := NULL;
1181: END IF;
1182:
1183: IF l_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN

Line 1183: IF l_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN

1179: IF l_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN
1180: l_PRICING_ATTR_rec.pricing_attribute_context := NULL;
1181: END IF;
1182:
1183: IF l_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN
1184: l_PRICING_ATTR_rec.pricing_attribute_id := NULL;
1185: END IF;
1186:
1187: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN

Line 1187: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN

1183: IF l_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN
1184: l_PRICING_ATTR_rec.pricing_attribute_id := NULL;
1185: END IF;
1186:
1187: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN
1188: l_PRICING_ATTR_rec.pricing_attr_value_from := NULL;
1189: END IF;
1190:
1191: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN

Line 1191: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN

1187: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN
1188: l_PRICING_ATTR_rec.pricing_attr_value_from := NULL;
1189: END IF;
1190:
1191: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN
1192: l_PRICING_ATTR_rec.pricing_attr_value_to := NULL;
1193: END IF;
1194:
1195: IF l_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR THEN

Line 1195: IF l_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR THEN

1191: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN
1192: l_PRICING_ATTR_rec.pricing_attr_value_to := NULL;
1193: END IF;
1194:
1195: IF l_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR THEN
1196: l_PRICING_ATTR_rec.product_attribute := NULL;
1197: END IF;
1198:
1199: IF l_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR THEN

Line 1199: IF l_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR THEN

1195: IF l_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR THEN
1196: l_PRICING_ATTR_rec.product_attribute := NULL;
1197: END IF;
1198:
1199: IF l_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR THEN
1200: l_PRICING_ATTR_rec.product_attribute_context := NULL;
1201: END IF;
1202:
1203: IF l_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR THEN

Line 1203: IF l_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR THEN

1199: IF l_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR THEN
1200: l_PRICING_ATTR_rec.product_attribute_context := NULL;
1201: END IF;
1202:
1203: IF l_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR THEN
1204: l_PRICING_ATTR_rec.product_attr_value := NULL;
1205: END IF;
1206:
1207: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN

Line 1207: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN

1203: IF l_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR THEN
1204: l_PRICING_ATTR_rec.product_attr_value := NULL;
1205: END IF;
1206:
1207: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN
1208: l_PRICING_ATTR_rec.product_uom_code := NULL;
1209: END IF;
1210:
1211: IF l_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 1211: IF l_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM THEN

1207: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN
1208: l_PRICING_ATTR_rec.product_uom_code := NULL;
1209: END IF;
1210:
1211: IF l_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM THEN
1212: l_PRICING_ATTR_rec.program_application_id := NULL;
1213: END IF;
1214:
1215: IF l_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM THEN

Line 1215: IF l_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM THEN

1211: IF l_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM THEN
1212: l_PRICING_ATTR_rec.program_application_id := NULL;
1213: END IF;
1214:
1215: IF l_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM THEN
1216: l_PRICING_ATTR_rec.program_id := NULL;
1217: END IF;
1218:
1219: IF l_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 1219: IF l_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE THEN

1215: IF l_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM THEN
1216: l_PRICING_ATTR_rec.program_id := NULL;
1217: END IF;
1218:
1219: IF l_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE THEN
1220: l_PRICING_ATTR_rec.program_update_date := NULL;
1221: END IF;
1222:
1223: IF l_PRICING_ATTR_rec.request_id = FND_API.G_MISS_NUM THEN

Line 1223: IF l_PRICING_ATTR_rec.request_id = FND_API.G_MISS_NUM THEN

1219: IF l_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE THEN
1220: l_PRICING_ATTR_rec.program_update_date := NULL;
1221: END IF;
1222:
1223: IF l_PRICING_ATTR_rec.request_id = FND_API.G_MISS_NUM THEN
1224: l_PRICING_ATTR_rec.request_id := NULL;
1225: END IF;
1226:
1227: IF l_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR THEN

Line 1227: IF l_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR THEN

1223: IF l_PRICING_ATTR_rec.request_id = FND_API.G_MISS_NUM THEN
1224: l_PRICING_ATTR_rec.request_id := NULL;
1225: END IF;
1226:
1227: IF l_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR THEN
1228: l_PRICING_ATTR_rec.product_attribute_datatype := NULL;
1229: END IF;
1230:
1231: IF l_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR THEN

Line 1231: IF l_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR THEN

1227: IF l_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR THEN
1228: l_PRICING_ATTR_rec.product_attribute_datatype := NULL;
1229: END IF;
1230:
1231: IF l_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR THEN
1232: l_PRICING_ATTR_rec.pricing_attribute_datatype := NULL;
1233: END IF;
1234:
1235: IF l_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN

Line 1235: IF l_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN

1231: IF l_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR THEN
1232: l_PRICING_ATTR_rec.pricing_attribute_datatype := NULL;
1233: END IF;
1234:
1235: IF l_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN
1236: l_PRICING_ATTR_rec.comparison_operator_code := NULL;
1237: END IF;
1238:
1239: oe_debug_pub.add('END Convert_Miss_To_Null in QPXUPRAB');

Line 1370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1366: , 'Update_Child_Pricing_Attr'
1367: );
1368: END IF;
1369:
1370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1371:
1372:
1373:
1374:

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

1400:
1401: l_list_line_type_code VARCHAR2(30);
1402: l_pric_attr_value_from_number NUMBER := NULL;
1403: l_pric_attr_value_to_number NUMBER := NULL;
1404: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1405: l_check_active_flag VARCHAR2(1);
1406: l_active_flag VARCHAR2(1);
1407: l_rltd_modifier_grp_type VARCHAR2(30);
1408: l_pricing_attr_value_to p_Pricing_Attr_rec.pricing_attr_value_to%TYPE;

Line 1586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1582: , 'Update_Row'
1583: );
1584: END IF;
1585:
1586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1587:
1588: END Update_Row;
1589:
1590: -- Procedure Insert_Row

Line 1857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1853: , 'Insert_Row'
1854: );
1855: END IF;
1856:
1857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1858:
1859: END Insert_Row;
1860:
1861: -- Procedure Delete_Row

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

1864: ( p_pricing_attribute_id IN NUMBER
1865: )
1866: IS
1867: l_list_line_id NUMBER;
1868: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1869: BEGIN
1870: oe_debug_pub.add('BEGIN Delete_Row in QPXUPRAB');
1871:
1872:

Line 1899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1895: , 'Delete_Row'
1896: );
1897: END IF;
1898:
1899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1900:
1901: END Delete_Row;
1902:
1903: -- Function Query_Row

Line 1923: FND_API.G_MISS_NUM

1919: --
1920:
1921: FUNCTION Query_Rows
1922: ( p_pricing_attribute_id IN NUMBER :=
1923: FND_API.G_MISS_NUM
1924: , p_list_line_id IN NUMBER :=
1925: FND_API.G_MISS_NUM
1926: ) RETURN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
1927: IS

Line 1925: FND_API.G_MISS_NUM

1921: FUNCTION Query_Rows
1922: ( p_pricing_attribute_id IN NUMBER :=
1923: FND_API.G_MISS_NUM
1924: , p_list_line_id IN NUMBER :=
1925: FND_API.G_MISS_NUM
1926: ) RETURN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
1927: IS
1928: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1929: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 1991: p_pricing_attribute_id <> FND_API.G_MISS_NUM)

1987:
1988: IF
1989: (p_pricing_attribute_id IS NOT NULL
1990: AND
1991: p_pricing_attribute_id <> FND_API.G_MISS_NUM)
1992: AND
1993: (p_list_line_id IS NOT NULL
1994: AND
1995: p_list_line_id <> FND_API.G_MISS_NUM)

Line 1995: p_list_line_id <> FND_API.G_MISS_NUM)

1991: p_pricing_attribute_id <> FND_API.G_MISS_NUM)
1992: AND
1993: (p_list_line_id IS NOT NULL
1994: AND
1995: p_list_line_id <> FND_API.G_MISS_NUM)
1996: THEN
1997: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1998: THEN
1999: OE_MSG_PUB.Add_Exc_Msg

Line 2006: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2002: , 'Keys are mutually exclusive: pricing_attribute_id = '|| p_pricing_attribute_id || ', list_line_id = '|| p_list_line_id
2003: );
2004: END IF;
2005:
2006: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2007:
2008: END IF;
2009:
2010:

Line 2072: p_pricing_attribute_id <> FND_API.G_MISS_NUM)

2068:
2069: IF
2070: (p_pricing_attribute_id IS NOT NULL
2071: AND
2072: p_pricing_attribute_id <> FND_API.G_MISS_NUM)
2073: AND
2074: (l_PRICING_ATTR_tbl.COUNT = 0)
2075: THEN
2076: RAISE NO_DATA_FOUND;

Line 2091: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2087:
2088: WHEN NO_DATA_FOUND THEN
2089: NULL;
2090:
2091: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2092:
2093: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2094:
2095: WHEN OTHERS THEN

Line 2093: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2089: NULL;
2090:
2091: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2092:
2093: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2094:
2095: WHEN OTHERS THEN
2096:
2097: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2105: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2101: , 'Query_Rows'
2102: );
2103: END IF;
2104:
2105: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2106:
2107: END Query_Rows;
2108:
2109: -- Procedure lock_Row

Line 2320: x_return_status := FND_API.G_RET_STS_SUCCESS;

2316: x_PRICING_ATTR_rec := l_PRICING_ATTR_rec;
2317:
2318: -- Set return status
2319:
2320: x_return_status := FND_API.G_RET_STS_SUCCESS;
2321: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2322:
2323: ELSE
2324:

Line 2321: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_SUCCESS;

2317:
2318: -- Set return status
2319:
2320: x_return_status := FND_API.G_RET_STS_SUCCESS;
2321: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2322:
2323: ELSE
2324:
2325: -- Row has changed by another user.

Line 2327: x_return_status := FND_API.G_RET_STS_ERROR;

2323: ELSE
2324:
2325: -- Row has changed by another user.
2326:
2327: x_return_status := FND_API.G_RET_STS_ERROR;
2328: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2329:
2330: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2331: THEN

Line 2328: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;

2324:
2325: -- Row has changed by another user.
2326:
2327: x_return_status := FND_API.G_RET_STS_ERROR;
2328: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2329:
2330: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2331: THEN
2332:

Line 2346: x_return_status := FND_API.G_RET_STS_ERROR;

2342: EXCEPTION
2343:
2344: WHEN NO_DATA_FOUND THEN
2345:
2346: x_return_status := FND_API.G_RET_STS_ERROR;
2347: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2348:
2349: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2350: THEN

Line 2347: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;

2343:
2344: WHEN NO_DATA_FOUND THEN
2345:
2346: x_return_status := FND_API.G_RET_STS_ERROR;
2347: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2348:
2349: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2350: THEN
2351:

Line 2358: x_return_status := FND_API.G_RET_STS_ERROR;

2354:
2355: END IF;
2356: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2357:
2358: x_return_status := FND_API.G_RET_STS_ERROR;
2359: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2360:
2361: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2362: THEN

Line 2359: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;

2355: END IF;
2356: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2357:
2358: x_return_status := FND_API.G_RET_STS_ERROR;
2359: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2360:
2361: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2362: THEN
2363:

Line 2370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2366:
2367: END IF;
2368: WHEN OTHERS THEN
2369:
2370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2371: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2372:
2373: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2374: THEN

Line 2371: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2367: END IF;
2368: WHEN OTHERS THEN
2369:
2370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2371: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2372:
2373: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2374: THEN
2375: OE_MSG_PUB.Add_Exc_Msg

Line 2397: p_PRICING_ATTR_rec.accumulate_flag <> FND_API.G_MISS_CHAR AND

2393:
2394: oe_debug_pub.add('BEGIN Get_Values in QPXUPRAB');
2395:
2396: IF p_PRICING_ATTR_rec.accumulate_flag IS NOT NULL AND
2397: p_PRICING_ATTR_rec.accumulate_flag <> FND_API.G_MISS_CHAR AND
2398: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.accumulate_flag,
2399: p_old_PRICING_ATTR_rec.accumulate_flag)
2400: THEN
2401: l_PRICING_ATTR_val_rec.accumulate := QP_Id_To_Value.Accumulate

Line 2407: p_PRICING_ATTR_rec.excluder_flag <> FND_API.G_MISS_CHAR AND

2403: );
2404: END IF;
2405:
2406: IF p_PRICING_ATTR_rec.excluder_flag IS NOT NULL AND
2407: p_PRICING_ATTR_rec.excluder_flag <> FND_API.G_MISS_CHAR AND
2408: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.excluder_flag,
2409: p_old_PRICING_ATTR_rec.excluder_flag)
2410: THEN
2411: l_PRICING_ATTR_val_rec.excluder := QP_Id_To_Value.Excluder

Line 2418: p_PRICING_ATTR_rec.list_header_id <> FND_API.G_MISS_NUM AND

2414: END IF;
2415:
2416: /*changes made by spgopal to include list_header_id and pricing_phase_id in pricing attr for performance problem*/
2417: IF p_PRICING_ATTR_rec.list_header_id IS NOT NULL AND
2418: p_PRICING_ATTR_rec.list_header_id <> FND_API.G_MISS_NUM AND
2419: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_header_id,
2420: p_old_PRICING_ATTR_rec.list_header_id)
2421: THEN
2422: -- l_PRICING_ATTR_val_rec.list_Header := QP_Id_To_Value.List_Header( p_list_header_id => p_PRICING_ATTR_rec.list_header_id);

Line 2427: p_PRICING_ATTR_rec.pricing_phase_id <> FND_API.G_MISS_NUM AND

2423: null;
2424: END IF;
2425:
2426: IF p_PRICING_ATTR_rec.pricing_phase_id IS NOT NULL AND
2427: p_PRICING_ATTR_rec.pricing_phase_id <> FND_API.G_MISS_NUM AND
2428: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_phase_id,
2429: p_old_PRICING_ATTR_rec.pricing_phase_id)
2430: THEN
2431: -- l_PRICING_ATTR_val_rec.pricing_phase := QP_Id_To_Value.pricing_phase( p_pricing_phase_id => p_PRICING_ATTR_rec.pricing_phase_id);

Line 2436: p_PRICING_ATTR_rec.list_line_id <> FND_API.G_MISS_NUM AND

2432: null;
2433: END IF;
2434:
2435: IF p_PRICING_ATTR_rec.list_line_id IS NOT NULL AND
2436: p_PRICING_ATTR_rec.list_line_id <> FND_API.G_MISS_NUM AND
2437: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_line_id,
2438: p_old_PRICING_ATTR_rec.list_line_id)
2439: THEN
2440: l_PRICING_ATTR_val_rec.list_line := QP_Id_To_Value.List_Line

Line 2446: p_PRICING_ATTR_rec.pricing_attribute_id <> FND_API.G_MISS_NUM AND

2442: );
2443: END IF;
2444:
2445: /* IF p_PRICING_ATTR_rec.pricing_attribute_id IS NOT NULL AND
2446: p_PRICING_ATTR_rec.pricing_attribute_id <> FND_API.G_MISS_NUM AND
2447: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_id,
2448: p_old_PRICING_ATTR_rec.pricing_attribute_id)
2449: THEN
2450: l_PRICING_ATTR_val_rec.pricing_attribute := QP_Id_To_Value.Pricing_Attribute

Line 2456: p_PRICING_ATTR_rec.product_uom_code <> FND_API.G_MISS_CHAR AND

2452: );
2453: END IF;
2454: */
2455: IF p_PRICING_ATTR_rec.product_uom_code IS NOT NULL AND
2456: p_PRICING_ATTR_rec.product_uom_code <> FND_API.G_MISS_CHAR AND
2457: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_uom_code,
2458: p_old_PRICING_ATTR_rec.product_uom_code)
2459: THEN
2460: l_PRICING_ATTR_val_rec.product_uom := QP_Id_To_Value.Product_Uom

Line 2485: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_SUCCESS;

2481: oe_debug_pub.add('BEGIN Get_Ids in QPXUPRAB');
2482:
2483: -- initialize return_status.
2484:
2485: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2486:
2487: -- initialize l_PRICING_ATTR_rec.
2488:
2489: l_PRICING_ATTR_rec := p_PRICING_ATTR_rec;

Line 2491: IF p_PRICING_ATTR_val_rec.accumulate <> FND_API.G_MISS_CHAR

2487: -- initialize l_PRICING_ATTR_rec.
2488:
2489: l_PRICING_ATTR_rec := p_PRICING_ATTR_rec;
2490:
2491: IF p_PRICING_ATTR_val_rec.accumulate <> FND_API.G_MISS_CHAR
2492: THEN
2493:
2494: IF p_PRICING_ATTR_rec.accumulate_flag <> FND_API.G_MISS_CHAR THEN
2495:

Line 2494: IF p_PRICING_ATTR_rec.accumulate_flag <> FND_API.G_MISS_CHAR THEN

2490:
2491: IF p_PRICING_ATTR_val_rec.accumulate <> FND_API.G_MISS_CHAR
2492: THEN
2493:
2494: IF p_PRICING_ATTR_rec.accumulate_flag <> FND_API.G_MISS_CHAR THEN
2495:
2496: l_PRICING_ATTR_rec.accumulate_flag := p_PRICING_ATTR_rec.accumulate_flag;
2497:
2498: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2513: IF l_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR THEN

2509: l_PRICING_ATTR_rec.accumulate_flag := QP_Value_To_Id.accumulate
2510: ( p_accumulate => p_PRICING_ATTR_val_rec.accumulate
2511: );
2512:
2513: IF l_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR THEN
2514: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2515: END IF;
2516:
2517: END IF;

Line 2514: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;

2510: ( p_accumulate => p_PRICING_ATTR_val_rec.accumulate
2511: );
2512:
2513: IF l_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR THEN
2514: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2515: END IF;
2516:
2517: END IF;
2518:

Line 2521: IF p_PRICING_ATTR_val_rec.excluder <> FND_API.G_MISS_CHAR

2517: END IF;
2518:
2519: END IF;
2520:
2521: IF p_PRICING_ATTR_val_rec.excluder <> FND_API.G_MISS_CHAR
2522: THEN
2523:
2524: IF p_PRICING_ATTR_rec.excluder_flag <> FND_API.G_MISS_CHAR THEN
2525:

Line 2524: IF p_PRICING_ATTR_rec.excluder_flag <> FND_API.G_MISS_CHAR THEN

2520:
2521: IF p_PRICING_ATTR_val_rec.excluder <> FND_API.G_MISS_CHAR
2522: THEN
2523:
2524: IF p_PRICING_ATTR_rec.excluder_flag <> FND_API.G_MISS_CHAR THEN
2525:
2526: l_PRICING_ATTR_rec.excluder_flag := p_PRICING_ATTR_rec.excluder_flag;
2527:
2528: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2543: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN

2539: l_PRICING_ATTR_rec.excluder_flag := QP_Value_To_Id.excluder
2540: ( p_excluder => p_PRICING_ATTR_val_rec.excluder
2541: );
2542:
2543: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
2544: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2545: END IF;
2546:
2547: END IF;

Line 2544: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;

2540: ( p_excluder => p_PRICING_ATTR_val_rec.excluder
2541: );
2542:
2543: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
2544: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2545: END IF;
2546:
2547: END IF;
2548:

Line 2552: IF p_PRICING_ATTR_val_rec.list_header <> FND_API.G_MISS_CHAR

2548:
2549: END IF;
2550:
2551: /*changes made by spgopal included pricing_phase_id and list_header_id to fix performance problem*/
2552: IF p_PRICING_ATTR_val_rec.list_header <> FND_API.G_MISS_CHAR
2553: THEN
2554:
2555: IF p_PRICING_ATTR_rec.list_header_id <> FND_API.G_MISS_NUM THEN
2556:

Line 2555: IF p_PRICING_ATTR_rec.list_header_id <> FND_API.G_MISS_NUM THEN

2551: /*changes made by spgopal included pricing_phase_id and list_header_id to fix performance problem*/
2552: IF p_PRICING_ATTR_val_rec.list_header <> FND_API.G_MISS_CHAR
2553: THEN
2554:
2555: IF p_PRICING_ATTR_rec.list_header_id <> FND_API.G_MISS_NUM THEN
2556:
2557: l_PRICING_ATTR_rec.list_header_id := p_PRICING_ATTR_rec.list_header_id;
2558:
2559: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2572: IF l_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM THEN

2568: ELSE
2569:
2570: l_PRICING_ATTR_rec.list_header_id := QP_Value_To_Id.list_header( p_list_header => p_PRICING_ATTR_val_rec.list_header);
2571:
2572: IF l_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM THEN
2573: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2574: END IF;
2575:
2576: END IF;

Line 2573: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;

2569:
2570: l_PRICING_ATTR_rec.list_header_id := QP_Value_To_Id.list_header( p_list_header => p_PRICING_ATTR_val_rec.list_header);
2571:
2572: IF l_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM THEN
2573: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2574: END IF;
2575:
2576: END IF;
2577:

Line 2580: IF p_PRICING_ATTR_val_rec.pricing_phase <> FND_API.G_MISS_CHAR

2576: END IF;
2577:
2578: END IF;
2579:
2580: IF p_PRICING_ATTR_val_rec.pricing_phase <> FND_API.G_MISS_CHAR
2581: THEN
2582:
2583: IF p_PRICING_ATTR_rec.pricing_phase_id <> FND_API.G_MISS_NUM THEN
2584:

Line 2583: IF p_PRICING_ATTR_rec.pricing_phase_id <> FND_API.G_MISS_NUM THEN

2579:
2580: IF p_PRICING_ATTR_val_rec.pricing_phase <> FND_API.G_MISS_CHAR
2581: THEN
2582:
2583: IF p_PRICING_ATTR_rec.pricing_phase_id <> FND_API.G_MISS_NUM THEN
2584:
2585: l_PRICING_ATTR_rec.pricing_phase_id := p_PRICING_ATTR_rec.pricing_phase_id;
2586:
2587: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2601: IF l_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN

2597:
2598: -- l_PRICING_ATTR_rec.pricing_phase_id := QP_Value_To_Id.pricing_phase( p_list_line => p_PRICING_ATTR_val_rec.pricing_phase);
2599: null;
2600:
2601: IF l_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN
2602: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2603: END IF;
2604:
2605: END IF;

Line 2602: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;

2598: -- l_PRICING_ATTR_rec.pricing_phase_id := QP_Value_To_Id.pricing_phase( p_list_line => p_PRICING_ATTR_val_rec.pricing_phase);
2599: null;
2600:
2601: IF l_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN
2602: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2603: END IF;
2604:
2605: END IF;
2606:

Line 2610: IF p_PRICING_ATTR_val_rec.list_line <> FND_API.G_MISS_CHAR

2606:
2607: END IF;
2608:
2609: -----
2610: IF p_PRICING_ATTR_val_rec.list_line <> FND_API.G_MISS_CHAR
2611: THEN
2612:
2613: IF p_PRICING_ATTR_rec.list_line_id <> FND_API.G_MISS_NUM THEN
2614:

Line 2613: IF p_PRICING_ATTR_rec.list_line_id <> FND_API.G_MISS_NUM THEN

2609: -----
2610: IF p_PRICING_ATTR_val_rec.list_line <> FND_API.G_MISS_CHAR
2611: THEN
2612:
2613: IF p_PRICING_ATTR_rec.list_line_id <> FND_API.G_MISS_NUM THEN
2614:
2615: l_PRICING_ATTR_rec.list_line_id := p_PRICING_ATTR_rec.list_line_id;
2616:
2617: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2632: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN

2628: l_PRICING_ATTR_rec.list_line_id := QP_Value_To_Id.list_line
2629: ( p_list_line => p_PRICING_ATTR_val_rec.list_line
2630: );
2631:
2632: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN
2633: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2634: END IF;
2635:
2636: END IF;

Line 2633: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;

2629: ( p_list_line => p_PRICING_ATTR_val_rec.list_line
2630: );
2631:
2632: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN
2633: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2634: END IF;
2635:
2636: END IF;
2637:

Line 2645: IF p_PRICING_ATTR_val_rec.pricing_attribute_desc <> FND_API.G_MISS_CHAR

2641: Added code to perform value_to_id conversion for pricing_Attribute,
2642: pricing_Attr_value_from and pricing_attr_value_to columns.
2643: ****************************************************************************/
2644:
2645: IF p_PRICING_ATTR_val_rec.pricing_attribute_desc <> FND_API.G_MISS_CHAR
2646: THEN
2647:
2648: IF p_PRICING_ATTR_rec.pricing_attribute <> FND_API.G_MISS_CHAR THEN
2649:

Line 2648: IF p_PRICING_ATTR_rec.pricing_attribute <> FND_API.G_MISS_CHAR THEN

2644:
2645: IF p_PRICING_ATTR_val_rec.pricing_attribute_desc <> FND_API.G_MISS_CHAR
2646: THEN
2647:
2648: IF p_PRICING_ATTR_rec.pricing_attribute <> FND_API.G_MISS_CHAR THEN
2649:
2650: l_PRICING_ATTR_rec.pricing_attribute := p_PRICING_ATTR_rec.pricing_attribute;
2651:
2652: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 2668: IF l_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN

2664: ( p_pricing_attribute_desc => p_PRICING_ATTR_val_rec.pricing_attribute_desc,
2665: p_context => l_PRICING_ATTR_rec.pricing_attribute_context
2666: );
2667:
2668: IF l_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN
2669: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2670: END IF;
2671:
2672: END IF;

Line 2669: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;

2665: p_context => l_PRICING_ATTR_rec.pricing_attribute_context
2666: );
2667:
2668: IF l_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN
2669: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2670: END IF;
2671:
2672: END IF;
2673:

Line 2676: IF p_PRICING_ATTR_val_rec.pricing_attr_value_from_desc <> FND_API.G_MISS_CHAR

2672: END IF;
2673:
2674: END IF;
2675:
2676: IF p_PRICING_ATTR_val_rec.pricing_attr_value_from_desc <> FND_API.G_MISS_CHAR
2677: THEN
2678:
2679: IF p_PRICING_ATTR_rec.pricing_attr_value_from <> FND_API.G_MISS_CHAR THEN
2680:

Line 2679: IF p_PRICING_ATTR_rec.pricing_attr_value_from <> FND_API.G_MISS_CHAR THEN

2675:
2676: IF p_PRICING_ATTR_val_rec.pricing_attr_value_from_desc <> FND_API.G_MISS_CHAR
2677: THEN
2678:
2679: IF p_PRICING_ATTR_rec.pricing_attr_value_from <> FND_API.G_MISS_CHAR THEN
2680:
2681: l_PRICING_ATTR_rec.pricing_attr_value_from := p_PRICING_ATTR_rec.pricing_attr_value_from;
2682:
2683: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 2700: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN

2696: p_context => l_PRICING_ATTR_rec.pricing_attribute_context,
2697: p_attribute => l_PRICING_ATTR_rec.pricing_attribute
2698: );
2699:
2700: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN
2701: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2702: END IF;
2703:
2704: END IF;

Line 2701: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;

2697: p_attribute => l_PRICING_ATTR_rec.pricing_attribute
2698: );
2699:
2700: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN
2701: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2702: END IF;
2703:
2704: END IF;
2705:

Line 2708: IF p_PRICING_ATTR_val_rec.pricing_attr_value_to_desc <> FND_API.G_MISS_CHAR

2704: END IF;
2705:
2706: END IF;
2707:
2708: IF p_PRICING_ATTR_val_rec.pricing_attr_value_to_desc <> FND_API.G_MISS_CHAR
2709: THEN
2710:
2711: IF p_PRICING_ATTR_rec.pricing_attr_value_to <> FND_API.G_MISS_CHAR THEN
2712:

Line 2711: IF p_PRICING_ATTR_rec.pricing_attr_value_to <> FND_API.G_MISS_CHAR THEN

2707:
2708: IF p_PRICING_ATTR_val_rec.pricing_attr_value_to_desc <> FND_API.G_MISS_CHAR
2709: THEN
2710:
2711: IF p_PRICING_ATTR_rec.pricing_attr_value_to <> FND_API.G_MISS_CHAR THEN
2712:
2713: l_PRICING_ATTR_rec.pricing_attr_value_to := p_PRICING_ATTR_rec.pricing_attr_value_to;
2714:
2715: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 2732: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN

2728: p_context => l_PRICING_ATTR_rec.pricing_attribute_context,
2729: p_attribute => l_PRICING_ATTR_rec.pricing_attribute
2730: );
2731:
2732: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN
2733: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2734: END IF;
2735:
2736: END IF;

Line 2733: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;

2729: p_attribute => l_PRICING_ATTR_rec.pricing_attribute
2730: );
2731:
2732: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN
2733: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2734: END IF;
2735:
2736: END IF;
2737:

Line 2740: IF p_PRICING_ATTR_val_rec.product_uom <> FND_API.G_MISS_CHAR

2736: END IF;
2737:
2738: END IF;
2739:
2740: IF p_PRICING_ATTR_val_rec.product_uom <> FND_API.G_MISS_CHAR
2741: THEN
2742:
2743: IF p_PRICING_ATTR_rec.product_uom_code <> FND_API.G_MISS_CHAR THEN
2744:

Line 2743: IF p_PRICING_ATTR_rec.product_uom_code <> FND_API.G_MISS_CHAR THEN

2739:
2740: IF p_PRICING_ATTR_val_rec.product_uom <> FND_API.G_MISS_CHAR
2741: THEN
2742:
2743: IF p_PRICING_ATTR_rec.product_uom_code <> FND_API.G_MISS_CHAR THEN
2744:
2745: l_PRICING_ATTR_rec.product_uom_code := p_PRICING_ATTR_rec.product_uom_code;
2746:
2747: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2762: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN

2758: l_PRICING_ATTR_rec.product_uom_code := QP_Value_To_Id.product_uom
2759: ( p_product_uom => p_PRICING_ATTR_val_rec.product_uom
2760: );
2761:
2762: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN
2763: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2764: END IF;
2765:
2766: END IF;

Line 2763: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;

2759: ( p_product_uom => p_PRICING_ATTR_val_rec.product_uom
2760: );
2761:
2762: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN
2763: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2764: END IF;
2765:
2766: END IF;
2767:

Line 2890: WHEN FND_API.G_EXC_ERROR THEN

2886: END IF; --Java Engine Installed
2887: -- pattern
2888:
2889: EXCEPTION
2890: WHEN FND_API.G_EXC_ERROR THEN
2891: RAISE;
2892: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2893: RAISE;
2894: WHEN OTHERS THEN

Line 2892: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2888:
2889: EXCEPTION
2890: WHEN FND_API.G_EXC_ERROR THEN
2891: RAISE;
2892: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2893: RAISE;
2894: WHEN OTHERS THEN
2895: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2896: THEN

Line 2902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2898: ( G_PKG_NAME
2899: , 'Pre_Write_Process'
2900: );
2901: END IF;
2902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2903: END Pre_Write_Process;
2904:
2905: END QP_Pricing_Attr_Util;