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 890: IF l_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR THEN

886: BEGIN
887:
888: oe_debug_pub.add('BEGIN Complete_Record in QPXUPRAB');
889:
890: IF l_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR THEN
891: l_PRICING_ATTR_rec.accumulate_flag := p_old_PRICING_ATTR_rec.accumulate_flag;
892: END IF;
893:
894: IF l_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR THEN

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

890: IF l_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR THEN
891: l_PRICING_ATTR_rec.accumulate_flag := p_old_PRICING_ATTR_rec.accumulate_flag;
892: END IF;
893:
894: IF l_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR THEN
895: l_PRICING_ATTR_rec.attribute1 := p_old_PRICING_ATTR_rec.attribute1;
896: END IF;
897:
898: IF l_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR THEN

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

894: IF l_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR THEN
895: l_PRICING_ATTR_rec.attribute1 := p_old_PRICING_ATTR_rec.attribute1;
896: END IF;
897:
898: IF l_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR THEN
899: l_PRICING_ATTR_rec.attribute10 := p_old_PRICING_ATTR_rec.attribute10;
900: END IF;
901:
902: IF l_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR THEN

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

898: IF l_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR THEN
899: l_PRICING_ATTR_rec.attribute10 := p_old_PRICING_ATTR_rec.attribute10;
900: END IF;
901:
902: IF l_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR THEN
903: l_PRICING_ATTR_rec.attribute11 := p_old_PRICING_ATTR_rec.attribute11;
904: END IF;
905:
906: IF l_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR THEN

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

902: IF l_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR THEN
903: l_PRICING_ATTR_rec.attribute11 := p_old_PRICING_ATTR_rec.attribute11;
904: END IF;
905:
906: IF l_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR THEN
907: l_PRICING_ATTR_rec.attribute12 := p_old_PRICING_ATTR_rec.attribute12;
908: END IF;
909:
910: IF l_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR THEN

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

906: IF l_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR THEN
907: l_PRICING_ATTR_rec.attribute12 := p_old_PRICING_ATTR_rec.attribute12;
908: END IF;
909:
910: IF l_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR THEN
911: l_PRICING_ATTR_rec.attribute13 := p_old_PRICING_ATTR_rec.attribute13;
912: END IF;
913:
914: IF l_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR THEN

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

910: IF l_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR THEN
911: l_PRICING_ATTR_rec.attribute13 := p_old_PRICING_ATTR_rec.attribute13;
912: END IF;
913:
914: IF l_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR THEN
915: l_PRICING_ATTR_rec.attribute14 := p_old_PRICING_ATTR_rec.attribute14;
916: END IF;
917:
918: IF l_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR THEN

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

914: IF l_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR THEN
915: l_PRICING_ATTR_rec.attribute14 := p_old_PRICING_ATTR_rec.attribute14;
916: END IF;
917:
918: IF l_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR THEN
919: l_PRICING_ATTR_rec.attribute15 := p_old_PRICING_ATTR_rec.attribute15;
920: END IF;
921:
922: IF l_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR THEN

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

918: IF l_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR THEN
919: l_PRICING_ATTR_rec.attribute15 := p_old_PRICING_ATTR_rec.attribute15;
920: END IF;
921:
922: IF l_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR THEN
923: l_PRICING_ATTR_rec.attribute2 := p_old_PRICING_ATTR_rec.attribute2;
924: END IF;
925:
926: IF l_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR THEN

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

922: IF l_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR THEN
923: l_PRICING_ATTR_rec.attribute2 := p_old_PRICING_ATTR_rec.attribute2;
924: END IF;
925:
926: IF l_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR THEN
927: l_PRICING_ATTR_rec.attribute3 := p_old_PRICING_ATTR_rec.attribute3;
928: END IF;
929:
930: IF l_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR THEN

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

926: IF l_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR THEN
927: l_PRICING_ATTR_rec.attribute3 := p_old_PRICING_ATTR_rec.attribute3;
928: END IF;
929:
930: IF l_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR THEN
931: l_PRICING_ATTR_rec.attribute4 := p_old_PRICING_ATTR_rec.attribute4;
932: END IF;
933:
934: IF l_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR THEN

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

930: IF l_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR THEN
931: l_PRICING_ATTR_rec.attribute4 := p_old_PRICING_ATTR_rec.attribute4;
932: END IF;
933:
934: IF l_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR THEN
935: l_PRICING_ATTR_rec.attribute5 := p_old_PRICING_ATTR_rec.attribute5;
936: END IF;
937:
938: IF l_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR THEN

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

934: IF l_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR THEN
935: l_PRICING_ATTR_rec.attribute5 := p_old_PRICING_ATTR_rec.attribute5;
936: END IF;
937:
938: IF l_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR THEN
939: l_PRICING_ATTR_rec.attribute6 := p_old_PRICING_ATTR_rec.attribute6;
940: END IF;
941:
942: IF l_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR THEN

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

938: IF l_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR THEN
939: l_PRICING_ATTR_rec.attribute6 := p_old_PRICING_ATTR_rec.attribute6;
940: END IF;
941:
942: IF l_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR THEN
943: l_PRICING_ATTR_rec.attribute7 := p_old_PRICING_ATTR_rec.attribute7;
944: END IF;
945:
946: IF l_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR THEN

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

942: IF l_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR THEN
943: l_PRICING_ATTR_rec.attribute7 := p_old_PRICING_ATTR_rec.attribute7;
944: END IF;
945:
946: IF l_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR THEN
947: l_PRICING_ATTR_rec.attribute8 := p_old_PRICING_ATTR_rec.attribute8;
948: END IF;
949:
950: IF l_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR THEN

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

946: IF l_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR THEN
947: l_PRICING_ATTR_rec.attribute8 := p_old_PRICING_ATTR_rec.attribute8;
948: END IF;
949:
950: IF l_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR THEN
951: l_PRICING_ATTR_rec.attribute9 := p_old_PRICING_ATTR_rec.attribute9;
952: END IF;
953:
954: IF l_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM THEN

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

950: IF l_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR THEN
951: l_PRICING_ATTR_rec.attribute9 := p_old_PRICING_ATTR_rec.attribute9;
952: END IF;
953:
954: IF l_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM THEN
955: l_PRICING_ATTR_rec.attribute_grouping_no := p_old_PRICING_ATTR_rec.attribute_grouping_no;
956: END IF;
957:
958: IF l_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR THEN

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

954: IF l_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM THEN
955: l_PRICING_ATTR_rec.attribute_grouping_no := p_old_PRICING_ATTR_rec.attribute_grouping_no;
956: END IF;
957:
958: IF l_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR THEN
959: l_PRICING_ATTR_rec.context := p_old_PRICING_ATTR_rec.context;
960: END IF;
961:
962: IF l_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM THEN

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

958: IF l_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR THEN
959: l_PRICING_ATTR_rec.context := p_old_PRICING_ATTR_rec.context;
960: END IF;
961:
962: IF l_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM THEN
963: l_PRICING_ATTR_rec.created_by := p_old_PRICING_ATTR_rec.created_by;
964: END IF;
965:
966: IF l_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE THEN

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

962: IF l_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM THEN
963: l_PRICING_ATTR_rec.created_by := p_old_PRICING_ATTR_rec.created_by;
964: END IF;
965:
966: IF l_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE THEN
967: l_PRICING_ATTR_rec.creation_date := p_old_PRICING_ATTR_rec.creation_date;
968: END IF;
969:
970: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN

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

966: IF l_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE THEN
967: l_PRICING_ATTR_rec.creation_date := p_old_PRICING_ATTR_rec.creation_date;
968: END IF;
969:
970: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
971: l_PRICING_ATTR_rec.excluder_flag := p_old_PRICING_ATTR_rec.excluder_flag;
972: END IF;
973:
974: IF l_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM THEN

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

970: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
971: l_PRICING_ATTR_rec.excluder_flag := p_old_PRICING_ATTR_rec.excluder_flag;
972: END IF;
973:
974: IF l_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM THEN
975: l_PRICING_ATTR_rec.last_updated_by := p_old_PRICING_ATTR_rec.last_updated_by;
976: END IF;
977:
978: IF l_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE THEN

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

974: IF l_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM THEN
975: l_PRICING_ATTR_rec.last_updated_by := p_old_PRICING_ATTR_rec.last_updated_by;
976: END IF;
977:
978: IF l_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE THEN
979: l_PRICING_ATTR_rec.last_update_date := p_old_PRICING_ATTR_rec.last_update_date;
980: END IF;
981:
982: IF l_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM THEN

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

978: IF l_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE THEN
979: l_PRICING_ATTR_rec.last_update_date := p_old_PRICING_ATTR_rec.last_update_date;
980: END IF;
981:
982: IF l_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM THEN
983: l_PRICING_ATTR_rec.last_update_login := p_old_PRICING_ATTR_rec.last_update_login;
984: END IF;
985:
986: /*included by spgopal to include list_header_id in pricing attr for performance problems*/

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

983: l_PRICING_ATTR_rec.last_update_login := p_old_PRICING_ATTR_rec.last_update_login;
984: END IF;
985:
986: /*included by spgopal to include list_header_id in pricing attr for performance problems*/
987: IF l_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM THEN
988: l_PRICING_ATTR_rec.list_header_id := p_old_PRICING_ATTR_rec.list_header_id;
989: END IF;
990:
991: /*included by spgopal to include pricing_phase_id in pricing attr for performance problems*/

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

988: l_PRICING_ATTR_rec.list_header_id := p_old_PRICING_ATTR_rec.list_header_id;
989: END IF;
990:
991: /*included by spgopal to include pricing_phase_id in pricing attr for performance problems*/
992: IF l_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN
993: l_PRICING_ATTR_rec.pricing_phase_id := p_old_PRICING_ATTR_rec.pricing_phase_id;
994: END IF;
995:
996: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN

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

992: IF l_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN
993: l_PRICING_ATTR_rec.pricing_phase_id := p_old_PRICING_ATTR_rec.pricing_phase_id;
994: END IF;
995:
996: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN
997: l_PRICING_ATTR_rec.list_line_id := p_old_PRICING_ATTR_rec.list_line_id;
998: END IF;
999:
1000: IF l_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN

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

996: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN
997: l_PRICING_ATTR_rec.list_line_id := p_old_PRICING_ATTR_rec.list_line_id;
998: END IF;
999:
1000: IF l_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN
1001: l_PRICING_ATTR_rec.pricing_attribute := p_old_PRICING_ATTR_rec.pricing_attribute;
1002: END IF;
1003:
1004: IF l_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN

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

1000: IF l_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN
1001: l_PRICING_ATTR_rec.pricing_attribute := p_old_PRICING_ATTR_rec.pricing_attribute;
1002: END IF;
1003:
1004: IF l_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN
1005: l_PRICING_ATTR_rec.pricing_attribute_context := p_old_PRICING_ATTR_rec.pricing_attribute_context;
1006: END IF;
1007:
1008: IF l_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN

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

1004: IF l_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN
1005: l_PRICING_ATTR_rec.pricing_attribute_context := p_old_PRICING_ATTR_rec.pricing_attribute_context;
1006: END IF;
1007:
1008: IF l_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN
1009: l_PRICING_ATTR_rec.pricing_attribute_id := p_old_PRICING_ATTR_rec.pricing_attribute_id;
1010: END IF;
1011:
1012: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN

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

1008: IF l_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN
1009: l_PRICING_ATTR_rec.pricing_attribute_id := p_old_PRICING_ATTR_rec.pricing_attribute_id;
1010: END IF;
1011:
1012: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN
1013: l_PRICING_ATTR_rec.pricing_attr_value_from := p_old_PRICING_ATTR_rec.pricing_attr_value_from;
1014: END IF;
1015:
1016: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN

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

1012: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN
1013: l_PRICING_ATTR_rec.pricing_attr_value_from := p_old_PRICING_ATTR_rec.pricing_attr_value_from;
1014: END IF;
1015:
1016: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN
1017: l_PRICING_ATTR_rec.pricing_attr_value_to := p_old_PRICING_ATTR_rec.pricing_attr_value_to;
1018: END IF;
1019:
1020: IF l_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR THEN

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

1016: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN
1017: l_PRICING_ATTR_rec.pricing_attr_value_to := p_old_PRICING_ATTR_rec.pricing_attr_value_to;
1018: END IF;
1019:
1020: IF l_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR THEN
1021: l_PRICING_ATTR_rec.product_attribute := p_old_PRICING_ATTR_rec.product_attribute;
1022: END IF;
1023:
1024: IF l_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR THEN

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

1020: IF l_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR THEN
1021: l_PRICING_ATTR_rec.product_attribute := p_old_PRICING_ATTR_rec.product_attribute;
1022: END IF;
1023:
1024: IF l_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR THEN
1025: l_PRICING_ATTR_rec.product_attribute_context := p_old_PRICING_ATTR_rec.product_attribute_context;
1026: END IF;
1027:
1028: IF l_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR THEN

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

1024: IF l_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR THEN
1025: l_PRICING_ATTR_rec.product_attribute_context := p_old_PRICING_ATTR_rec.product_attribute_context;
1026: END IF;
1027:
1028: IF l_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR THEN
1029: l_PRICING_ATTR_rec.product_attr_value := p_old_PRICING_ATTR_rec.product_attr_value;
1030: END IF;
1031:
1032: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN

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

1028: IF l_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR THEN
1029: l_PRICING_ATTR_rec.product_attr_value := p_old_PRICING_ATTR_rec.product_attr_value;
1030: END IF;
1031:
1032: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN
1033: l_PRICING_ATTR_rec.product_uom_code := p_old_PRICING_ATTR_rec.product_uom_code;
1034: END IF;
1035:
1036: IF l_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM THEN

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

1032: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN
1033: l_PRICING_ATTR_rec.product_uom_code := p_old_PRICING_ATTR_rec.product_uom_code;
1034: END IF;
1035:
1036: IF l_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM THEN
1037: l_PRICING_ATTR_rec.program_application_id := p_old_PRICING_ATTR_rec.program_application_id;
1038: END IF;
1039:
1040: IF l_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM THEN

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

1036: IF l_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM THEN
1037: l_PRICING_ATTR_rec.program_application_id := p_old_PRICING_ATTR_rec.program_application_id;
1038: END IF;
1039:
1040: IF l_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM THEN
1041: l_PRICING_ATTR_rec.program_id := p_old_PRICING_ATTR_rec.program_id;
1042: END IF;
1043:
1044: IF l_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE THEN

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

1040: IF l_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM THEN
1041: l_PRICING_ATTR_rec.program_id := p_old_PRICING_ATTR_rec.program_id;
1042: END IF;
1043:
1044: IF l_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE THEN
1045: l_PRICING_ATTR_rec.program_update_date := p_old_PRICING_ATTR_rec.program_update_date;
1046: END IF;
1047:
1048: IF l_PRICING_ATTR_rec.request_id = FND_API.G_MISS_NUM THEN

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

1044: IF l_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE THEN
1045: l_PRICING_ATTR_rec.program_update_date := p_old_PRICING_ATTR_rec.program_update_date;
1046: END IF;
1047:
1048: IF l_PRICING_ATTR_rec.request_id = FND_API.G_MISS_NUM THEN
1049: l_PRICING_ATTR_rec.request_id := p_old_PRICING_ATTR_rec.request_id;
1050: END IF;
1051:
1052: IF l_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR THEN

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

1048: IF l_PRICING_ATTR_rec.request_id = FND_API.G_MISS_NUM THEN
1049: l_PRICING_ATTR_rec.request_id := p_old_PRICING_ATTR_rec.request_id;
1050: END IF;
1051:
1052: IF l_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR THEN
1053: l_PRICING_ATTR_rec.product_attribute_datatype := p_old_PRICING_ATTR_rec.product_attribute_datatype;
1054: END IF;
1055:
1056: IF l_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR THEN

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

1052: IF l_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR THEN
1053: l_PRICING_ATTR_rec.product_attribute_datatype := p_old_PRICING_ATTR_rec.product_attribute_datatype;
1054: END IF;
1055:
1056: IF l_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR THEN
1057: l_PRICING_ATTR_rec.pricing_attribute_datatype := p_old_PRICING_ATTR_rec.pricing_attribute_datatype;
1058: END IF;
1059:
1060: IF l_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN

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

1056: IF l_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR THEN
1057: l_PRICING_ATTR_rec.pricing_attribute_datatype := p_old_PRICING_ATTR_rec.pricing_attribute_datatype;
1058: END IF;
1059:
1060: IF l_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN
1061: l_PRICING_ATTR_rec.comparison_operator_code := p_old_PRICING_ATTR_rec.comparison_operator_code;
1062: END IF;
1063:
1064: oe_debug_pub.add('END Complete_Record in QPXUPRAB');

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

1077: BEGIN
1078:
1079: oe_debug_pub.add('BEGIN Convert_Miss_To_Null in QPXUPRAB');
1080:
1081: IF l_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR THEN
1082: l_PRICING_ATTR_rec.accumulate_flag := NULL;
1083: END IF;
1084:
1085: IF l_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR THEN

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

1081: IF l_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR THEN
1082: l_PRICING_ATTR_rec.accumulate_flag := NULL;
1083: END IF;
1084:
1085: IF l_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1086: l_PRICING_ATTR_rec.attribute1 := NULL;
1087: END IF;
1088:
1089: IF l_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR THEN

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

1085: IF l_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1086: l_PRICING_ATTR_rec.attribute1 := NULL;
1087: END IF;
1088:
1089: IF l_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1090: l_PRICING_ATTR_rec.attribute10 := NULL;
1091: END IF;
1092:
1093: IF l_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR THEN

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

1089: IF l_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1090: l_PRICING_ATTR_rec.attribute10 := NULL;
1091: END IF;
1092:
1093: IF l_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1094: l_PRICING_ATTR_rec.attribute11 := NULL;
1095: END IF;
1096:
1097: IF l_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR THEN

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

1093: IF l_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1094: l_PRICING_ATTR_rec.attribute11 := NULL;
1095: END IF;
1096:
1097: IF l_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1098: l_PRICING_ATTR_rec.attribute12 := NULL;
1099: END IF;
1100:
1101: IF l_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR THEN

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

1097: IF l_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1098: l_PRICING_ATTR_rec.attribute12 := NULL;
1099: END IF;
1100:
1101: IF l_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1102: l_PRICING_ATTR_rec.attribute13 := NULL;
1103: END IF;
1104:
1105: IF l_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR THEN

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

1101: IF l_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1102: l_PRICING_ATTR_rec.attribute13 := NULL;
1103: END IF;
1104:
1105: IF l_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1106: l_PRICING_ATTR_rec.attribute14 := NULL;
1107: END IF;
1108:
1109: IF l_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR THEN

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

1105: IF l_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1106: l_PRICING_ATTR_rec.attribute14 := NULL;
1107: END IF;
1108:
1109: IF l_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1110: l_PRICING_ATTR_rec.attribute15 := NULL;
1111: END IF;
1112:
1113: IF l_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR THEN

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

1109: IF l_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1110: l_PRICING_ATTR_rec.attribute15 := NULL;
1111: END IF;
1112:
1113: IF l_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1114: l_PRICING_ATTR_rec.attribute2 := NULL;
1115: END IF;
1116:
1117: IF l_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR THEN

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

1113: IF l_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1114: l_PRICING_ATTR_rec.attribute2 := NULL;
1115: END IF;
1116:
1117: IF l_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1118: l_PRICING_ATTR_rec.attribute3 := NULL;
1119: END IF;
1120:
1121: IF l_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR THEN

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

1117: IF l_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1118: l_PRICING_ATTR_rec.attribute3 := NULL;
1119: END IF;
1120:
1121: IF l_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1122: l_PRICING_ATTR_rec.attribute4 := NULL;
1123: END IF;
1124:
1125: IF l_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR THEN

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

1121: IF l_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1122: l_PRICING_ATTR_rec.attribute4 := NULL;
1123: END IF;
1124:
1125: IF l_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1126: l_PRICING_ATTR_rec.attribute5 := NULL;
1127: END IF;
1128:
1129: IF l_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR THEN

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

1125: IF l_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1126: l_PRICING_ATTR_rec.attribute5 := NULL;
1127: END IF;
1128:
1129: IF l_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1130: l_PRICING_ATTR_rec.attribute6 := NULL;
1131: END IF;
1132:
1133: IF l_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR THEN

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

1129: IF l_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1130: l_PRICING_ATTR_rec.attribute6 := NULL;
1131: END IF;
1132:
1133: IF l_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1134: l_PRICING_ATTR_rec.attribute7 := NULL;
1135: END IF;
1136:
1137: IF l_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR THEN

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

1133: IF l_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1134: l_PRICING_ATTR_rec.attribute7 := NULL;
1135: END IF;
1136:
1137: IF l_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1138: l_PRICING_ATTR_rec.attribute8 := NULL;
1139: END IF;
1140:
1141: IF l_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR THEN

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

1137: IF l_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1138: l_PRICING_ATTR_rec.attribute8 := NULL;
1139: END IF;
1140:
1141: IF l_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1142: l_PRICING_ATTR_rec.attribute9 := NULL;
1143: END IF;
1144:
1145: IF l_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM THEN

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

1141: IF l_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1142: l_PRICING_ATTR_rec.attribute9 := NULL;
1143: END IF;
1144:
1145: IF l_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM THEN
1146: l_PRICING_ATTR_rec.attribute_grouping_no := NULL;
1147: END IF;
1148:
1149: IF l_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR THEN

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

1145: IF l_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM THEN
1146: l_PRICING_ATTR_rec.attribute_grouping_no := NULL;
1147: END IF;
1148:
1149: IF l_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR THEN
1150: l_PRICING_ATTR_rec.context := NULL;
1151: END IF;
1152:
1153: IF l_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM THEN

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

1149: IF l_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR THEN
1150: l_PRICING_ATTR_rec.context := NULL;
1151: END IF;
1152:
1153: IF l_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM THEN
1154: l_PRICING_ATTR_rec.created_by := NULL;
1155: END IF;
1156:
1157: IF l_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE THEN

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

1153: IF l_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM THEN
1154: l_PRICING_ATTR_rec.created_by := NULL;
1155: END IF;
1156:
1157: IF l_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE THEN
1158: l_PRICING_ATTR_rec.creation_date := NULL;
1159: END IF;
1160:
1161: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN

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

1157: IF l_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE THEN
1158: l_PRICING_ATTR_rec.creation_date := NULL;
1159: END IF;
1160:
1161: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
1162: l_PRICING_ATTR_rec.excluder_flag := NULL;
1163: END IF;
1164:
1165: IF l_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM THEN

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

1161: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
1162: l_PRICING_ATTR_rec.excluder_flag := NULL;
1163: END IF;
1164:
1165: IF l_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1166: l_PRICING_ATTR_rec.last_updated_by := NULL;
1167: END IF;
1168:
1169: IF l_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE THEN

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

1165: IF l_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1166: l_PRICING_ATTR_rec.last_updated_by := NULL;
1167: END IF;
1168:
1169: IF l_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE THEN
1170: l_PRICING_ATTR_rec.last_update_date := NULL;
1171: END IF;
1172:
1173: IF l_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM THEN

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

1169: IF l_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE THEN
1170: l_PRICING_ATTR_rec.last_update_date := NULL;
1171: END IF;
1172:
1173: IF l_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM THEN
1174: l_PRICING_ATTR_rec.last_update_login := NULL;
1175: END IF;
1176:
1177: /*included by spgopal to include list_header_id in pricing attr for performance problems*/

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

1174: l_PRICING_ATTR_rec.last_update_login := NULL;
1175: END IF;
1176:
1177: /*included by spgopal to include list_header_id in pricing attr for performance problems*/
1178: IF l_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM THEN
1179: l_PRICING_ATTR_rec.list_header_id := NULL;
1180: END IF;
1181:
1182: /*included by spgopal to include pricing_phase_id in pricing attr for performance problems*/

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

1179: l_PRICING_ATTR_rec.list_header_id := NULL;
1180: END IF;
1181:
1182: /*included by spgopal to include pricing_phase_id in pricing attr for performance problems*/
1183: IF l_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN
1184: l_PRICING_ATTR_rec.pricing_phase_id := NULL;
1185: END IF;
1186:
1187: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN

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

1183: IF l_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN
1184: l_PRICING_ATTR_rec.pricing_phase_id := NULL;
1185: END IF;
1186:
1187: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN
1188: l_PRICING_ATTR_rec.list_line_id := NULL;
1189: END IF;
1190:
1191: IF l_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN

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

1187: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN
1188: l_PRICING_ATTR_rec.list_line_id := NULL;
1189: END IF;
1190:
1191: IF l_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN
1192: l_PRICING_ATTR_rec.pricing_attribute := NULL;
1193: END IF;
1194:
1195: IF l_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN

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

1191: IF l_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN
1192: l_PRICING_ATTR_rec.pricing_attribute := NULL;
1193: END IF;
1194:
1195: IF l_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN
1196: l_PRICING_ATTR_rec.pricing_attribute_context := NULL;
1197: END IF;
1198:
1199: IF l_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN

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

1195: IF l_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN
1196: l_PRICING_ATTR_rec.pricing_attribute_context := NULL;
1197: END IF;
1198:
1199: IF l_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN
1200: l_PRICING_ATTR_rec.pricing_attribute_id := NULL;
1201: END IF;
1202:
1203: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN

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

1199: IF l_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN
1200: l_PRICING_ATTR_rec.pricing_attribute_id := NULL;
1201: END IF;
1202:
1203: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN
1204: l_PRICING_ATTR_rec.pricing_attr_value_from := NULL;
1205: END IF;
1206:
1207: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN

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

1203: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN
1204: l_PRICING_ATTR_rec.pricing_attr_value_from := NULL;
1205: END IF;
1206:
1207: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN
1208: l_PRICING_ATTR_rec.pricing_attr_value_to := NULL;
1209: END IF;
1210:
1211: IF l_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR THEN

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

1207: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN
1208: l_PRICING_ATTR_rec.pricing_attr_value_to := NULL;
1209: END IF;
1210:
1211: IF l_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR THEN
1212: l_PRICING_ATTR_rec.product_attribute := NULL;
1213: END IF;
1214:
1215: IF l_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR THEN

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

1211: IF l_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR THEN
1212: l_PRICING_ATTR_rec.product_attribute := NULL;
1213: END IF;
1214:
1215: IF l_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR THEN
1216: l_PRICING_ATTR_rec.product_attribute_context := NULL;
1217: END IF;
1218:
1219: IF l_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR THEN

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

1215: IF l_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR THEN
1216: l_PRICING_ATTR_rec.product_attribute_context := NULL;
1217: END IF;
1218:
1219: IF l_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR THEN
1220: l_PRICING_ATTR_rec.product_attr_value := NULL;
1221: END IF;
1222:
1223: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN

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

1219: IF l_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR THEN
1220: l_PRICING_ATTR_rec.product_attr_value := NULL;
1221: END IF;
1222:
1223: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN
1224: l_PRICING_ATTR_rec.product_uom_code := NULL;
1225: END IF;
1226:
1227: IF l_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM THEN

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

1223: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN
1224: l_PRICING_ATTR_rec.product_uom_code := NULL;
1225: END IF;
1226:
1227: IF l_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM THEN
1228: l_PRICING_ATTR_rec.program_application_id := NULL;
1229: END IF;
1230:
1231: IF l_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM THEN

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

1227: IF l_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM THEN
1228: l_PRICING_ATTR_rec.program_application_id := NULL;
1229: END IF;
1230:
1231: IF l_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM THEN
1232: l_PRICING_ATTR_rec.program_id := NULL;
1233: END IF;
1234:
1235: IF l_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE THEN

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

1231: IF l_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM THEN
1232: l_PRICING_ATTR_rec.program_id := NULL;
1233: END IF;
1234:
1235: IF l_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE THEN
1236: l_PRICING_ATTR_rec.program_update_date := NULL;
1237: END IF;
1238:
1239: IF l_PRICING_ATTR_rec.request_id = FND_API.G_MISS_NUM THEN

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

1235: IF l_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE THEN
1236: l_PRICING_ATTR_rec.program_update_date := NULL;
1237: END IF;
1238:
1239: IF l_PRICING_ATTR_rec.request_id = FND_API.G_MISS_NUM THEN
1240: l_PRICING_ATTR_rec.request_id := NULL;
1241: END IF;
1242:
1243: IF l_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR THEN

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

1239: IF l_PRICING_ATTR_rec.request_id = FND_API.G_MISS_NUM THEN
1240: l_PRICING_ATTR_rec.request_id := NULL;
1241: END IF;
1242:
1243: IF l_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR THEN
1244: l_PRICING_ATTR_rec.product_attribute_datatype := NULL;
1245: END IF;
1246:
1247: IF l_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR THEN

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

1243: IF l_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR THEN
1244: l_PRICING_ATTR_rec.product_attribute_datatype := NULL;
1245: END IF;
1246:
1247: IF l_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR THEN
1248: l_PRICING_ATTR_rec.pricing_attribute_datatype := NULL;
1249: END IF;
1250:
1251: IF l_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN

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

1247: IF l_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR THEN
1248: l_PRICING_ATTR_rec.pricing_attribute_datatype := NULL;
1249: END IF;
1250:
1251: IF l_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN
1252: l_PRICING_ATTR_rec.comparison_operator_code := NULL;
1253: END IF;
1254:
1255: oe_debug_pub.add('END Convert_Miss_To_Null in QPXUPRAB');

Line 1386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1382: , 'Update_Child_Pricing_Attr'
1383: );
1384: END IF;
1385:
1386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1387:
1388:
1389:
1390:

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

1416:
1417: l_list_line_type_code VARCHAR2(30);
1418: l_pric_attr_value_from_number NUMBER := NULL;
1419: l_pric_attr_value_to_number NUMBER := NULL;
1420: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1421: l_check_active_flag VARCHAR2(1);
1422: l_active_flag VARCHAR2(1);
1423: l_rltd_modifier_grp_type VARCHAR2(30);
1424: l_pricing_attr_value_to p_Pricing_Attr_rec.pricing_attr_value_to%TYPE;

Line 1602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1598: , 'Update_Row'
1599: );
1600: END IF;
1601:
1602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1603:
1604: END Update_Row;
1605:
1606: -- Procedure Insert_Row

Line 1873: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1869: , 'Insert_Row'
1870: );
1871: END IF;
1872:
1873: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1874:
1875: END Insert_Row;
1876:
1877: -- Procedure Delete_Row

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

1880: ( p_pricing_attribute_id IN NUMBER
1881: )
1882: IS
1883: l_list_line_id NUMBER;
1884: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1885: BEGIN
1886: oe_debug_pub.add('BEGIN Delete_Row in QPXUPRAB');
1887:
1888:

Line 1915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1911: , 'Delete_Row'
1912: );
1913: END IF;
1914:
1915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1916:
1917: END Delete_Row;
1918:
1919: -- Function Query_Row

Line 1939: FND_API.G_MISS_NUM

1935: --
1936:
1937: FUNCTION Query_Rows
1938: ( p_pricing_attribute_id IN NUMBER :=
1939: FND_API.G_MISS_NUM
1940: , p_list_line_id IN NUMBER :=
1941: FND_API.G_MISS_NUM
1942: ) RETURN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
1943: IS

Line 1941: FND_API.G_MISS_NUM

1937: FUNCTION Query_Rows
1938: ( p_pricing_attribute_id IN NUMBER :=
1939: FND_API.G_MISS_NUM
1940: , p_list_line_id IN NUMBER :=
1941: FND_API.G_MISS_NUM
1942: ) RETURN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
1943: IS
1944: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1945: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 2007: p_pricing_attribute_id <> FND_API.G_MISS_NUM)

2003:
2004: IF
2005: (p_pricing_attribute_id IS NOT NULL
2006: AND
2007: p_pricing_attribute_id <> FND_API.G_MISS_NUM)
2008: AND
2009: (p_list_line_id IS NOT NULL
2010: AND
2011: p_list_line_id <> FND_API.G_MISS_NUM)

Line 2011: p_list_line_id <> FND_API.G_MISS_NUM)

2007: p_pricing_attribute_id <> FND_API.G_MISS_NUM)
2008: AND
2009: (p_list_line_id IS NOT NULL
2010: AND
2011: p_list_line_id <> FND_API.G_MISS_NUM)
2012: THEN
2013: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2014: THEN
2015: OE_MSG_PUB.Add_Exc_Msg

Line 2022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2018: , 'Keys are mutually exclusive: pricing_attribute_id = '|| p_pricing_attribute_id || ', list_line_id = '|| p_list_line_id
2019: );
2020: END IF;
2021:
2022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2023:
2024: END IF;
2025:
2026:

Line 2088: p_pricing_attribute_id <> FND_API.G_MISS_NUM)

2084:
2085: IF
2086: (p_pricing_attribute_id IS NOT NULL
2087: AND
2088: p_pricing_attribute_id <> FND_API.G_MISS_NUM)
2089: AND
2090: (l_PRICING_ATTR_tbl.COUNT = 0)
2091: THEN
2092: RAISE NO_DATA_FOUND;

Line 2107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2103:
2104: WHEN NO_DATA_FOUND THEN
2105: NULL;
2106:
2107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2108:
2109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2110:
2111: WHEN OTHERS THEN

Line 2109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2105: NULL;
2106:
2107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2108:
2109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2110:
2111: WHEN OTHERS THEN
2112:
2113: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2117: , 'Query_Rows'
2118: );
2119: END IF;
2120:
2121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2122:
2123: END Query_Rows;
2124:
2125: -- Procedure lock_Row

Line 2336: x_return_status := FND_API.G_RET_STS_SUCCESS;

2332: x_PRICING_ATTR_rec := l_PRICING_ATTR_rec;
2333:
2334: -- Set return status
2335:
2336: x_return_status := FND_API.G_RET_STS_SUCCESS;
2337: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2338:
2339: ELSE
2340:

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

2333:
2334: -- Set return status
2335:
2336: x_return_status := FND_API.G_RET_STS_SUCCESS;
2337: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2338:
2339: ELSE
2340:
2341: -- Row has changed by another user.

Line 2386: x_return_status := FND_API.G_RET_STS_ERROR;

2382: oe_debug_pub.add('PRICING_ATTR_rec.pricing_attribute_datatype :'||l_PRICING_ATTR_rec.pricing_attribute_datatype||':'||p_PRICING_ATTR_rec.pricing_attribute_datatype||':');
2383: oe_debug_pub.add('PRICING_ATTR_rec.comparison_operator_code :'||l_PRICING_ATTR_rec.comparison_operator_code||':'||p_PRICING_ATTR_rec.comparison_operator_code||':');
2384: oe_debug_pub.ADD('-------------------data compare in pricing attr line end------------------');
2385:
2386: x_return_status := FND_API.G_RET_STS_ERROR;
2387: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2388:
2389: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2390: THEN

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

2383: oe_debug_pub.add('PRICING_ATTR_rec.comparison_operator_code :'||l_PRICING_ATTR_rec.comparison_operator_code||':'||p_PRICING_ATTR_rec.comparison_operator_code||':');
2384: oe_debug_pub.ADD('-------------------data compare in pricing attr line end------------------');
2385:
2386: x_return_status := FND_API.G_RET_STS_ERROR;
2387: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2388:
2389: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2390: THEN
2391:

Line 2405: x_return_status := FND_API.G_RET_STS_ERROR;

2401: EXCEPTION
2402:
2403: WHEN NO_DATA_FOUND THEN
2404:
2405: x_return_status := FND_API.G_RET_STS_ERROR;
2406: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2407:
2408: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2409: THEN

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

2402:
2403: WHEN NO_DATA_FOUND THEN
2404:
2405: x_return_status := FND_API.G_RET_STS_ERROR;
2406: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2407:
2408: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2409: THEN
2410:

Line 2417: x_return_status := FND_API.G_RET_STS_ERROR;

2413:
2414: END IF;
2415: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2416:
2417: x_return_status := FND_API.G_RET_STS_ERROR;
2418: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2419:
2420: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2421: THEN

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

2414: END IF;
2415: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2416:
2417: x_return_status := FND_API.G_RET_STS_ERROR;
2418: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2419:
2420: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2421: THEN
2422:

Line 2429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2425:
2426: END IF;
2427: WHEN OTHERS THEN
2428:
2429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2430: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2431:
2432: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2433: THEN

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

2426: END IF;
2427: WHEN OTHERS THEN
2428:
2429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2430: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2431:
2432: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2433: THEN
2434: OE_MSG_PUB.Add_Exc_Msg

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

2452:
2453: oe_debug_pub.add('BEGIN Get_Values in QPXUPRAB');
2454:
2455: IF p_PRICING_ATTR_rec.accumulate_flag IS NOT NULL AND
2456: p_PRICING_ATTR_rec.accumulate_flag <> FND_API.G_MISS_CHAR AND
2457: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.accumulate_flag,
2458: p_old_PRICING_ATTR_rec.accumulate_flag)
2459: THEN
2460: l_PRICING_ATTR_val_rec.accumulate := QP_Id_To_Value.Accumulate

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

2462: );
2463: END IF;
2464:
2465: IF p_PRICING_ATTR_rec.excluder_flag IS NOT NULL AND
2466: p_PRICING_ATTR_rec.excluder_flag <> FND_API.G_MISS_CHAR AND
2467: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.excluder_flag,
2468: p_old_PRICING_ATTR_rec.excluder_flag)
2469: THEN
2470: l_PRICING_ATTR_val_rec.excluder := QP_Id_To_Value.Excluder

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

2473: END IF;
2474:
2475: /*changes made by spgopal to include list_header_id and pricing_phase_id in pricing attr for performance problem*/
2476: IF p_PRICING_ATTR_rec.list_header_id IS NOT NULL AND
2477: p_PRICING_ATTR_rec.list_header_id <> FND_API.G_MISS_NUM AND
2478: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_header_id,
2479: p_old_PRICING_ATTR_rec.list_header_id)
2480: THEN
2481: -- 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 2486: p_PRICING_ATTR_rec.pricing_phase_id <> FND_API.G_MISS_NUM AND

2482: null;
2483: END IF;
2484:
2485: IF p_PRICING_ATTR_rec.pricing_phase_id IS NOT NULL AND
2486: p_PRICING_ATTR_rec.pricing_phase_id <> FND_API.G_MISS_NUM AND
2487: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_phase_id,
2488: p_old_PRICING_ATTR_rec.pricing_phase_id)
2489: THEN
2490: -- 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 2495: p_PRICING_ATTR_rec.list_line_id <> FND_API.G_MISS_NUM AND

2491: null;
2492: END IF;
2493:
2494: IF p_PRICING_ATTR_rec.list_line_id IS NOT NULL AND
2495: p_PRICING_ATTR_rec.list_line_id <> FND_API.G_MISS_NUM AND
2496: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_line_id,
2497: p_old_PRICING_ATTR_rec.list_line_id)
2498: THEN
2499: l_PRICING_ATTR_val_rec.list_line := QP_Id_To_Value.List_Line

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

2501: );
2502: END IF;
2503:
2504: /* IF p_PRICING_ATTR_rec.pricing_attribute_id IS NOT NULL AND
2505: p_PRICING_ATTR_rec.pricing_attribute_id <> FND_API.G_MISS_NUM AND
2506: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_id,
2507: p_old_PRICING_ATTR_rec.pricing_attribute_id)
2508: THEN
2509: l_PRICING_ATTR_val_rec.pricing_attribute := QP_Id_To_Value.Pricing_Attribute

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

2511: );
2512: END IF;
2513: */
2514: IF p_PRICING_ATTR_rec.product_uom_code IS NOT NULL AND
2515: p_PRICING_ATTR_rec.product_uom_code <> FND_API.G_MISS_CHAR AND
2516: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_uom_code,
2517: p_old_PRICING_ATTR_rec.product_uom_code)
2518: THEN
2519: l_PRICING_ATTR_val_rec.product_uom := QP_Id_To_Value.Product_Uom

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

2540: oe_debug_pub.add('BEGIN Get_Ids in QPXUPRAB');
2541:
2542: -- initialize return_status.
2543:
2544: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2545:
2546: -- initialize l_PRICING_ATTR_rec.
2547:
2548: l_PRICING_ATTR_rec := p_PRICING_ATTR_rec;

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

2546: -- initialize l_PRICING_ATTR_rec.
2547:
2548: l_PRICING_ATTR_rec := p_PRICING_ATTR_rec;
2549:
2550: IF p_PRICING_ATTR_val_rec.accumulate <> FND_API.G_MISS_CHAR
2551: THEN
2552:
2553: IF p_PRICING_ATTR_rec.accumulate_flag <> FND_API.G_MISS_CHAR THEN
2554:

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

2549:
2550: IF p_PRICING_ATTR_val_rec.accumulate <> FND_API.G_MISS_CHAR
2551: THEN
2552:
2553: IF p_PRICING_ATTR_rec.accumulate_flag <> FND_API.G_MISS_CHAR THEN
2554:
2555: l_PRICING_ATTR_rec.accumulate_flag := p_PRICING_ATTR_rec.accumulate_flag;
2556:
2557: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

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

2568: l_PRICING_ATTR_rec.accumulate_flag := QP_Value_To_Id.accumulate
2569: ( p_accumulate => p_PRICING_ATTR_val_rec.accumulate
2570: );
2571:
2572: IF l_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR 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: ( p_accumulate => p_PRICING_ATTR_val_rec.accumulate
2570: );
2571:
2572: IF l_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR 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.excluder <> FND_API.G_MISS_CHAR

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

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

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

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

2598: l_PRICING_ATTR_rec.excluder_flag := QP_Value_To_Id.excluder
2599: ( p_excluder => p_PRICING_ATTR_val_rec.excluder
2600: );
2601:
2602: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
2603: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2604: END IF;
2605:
2606: END IF;

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

2599: ( p_excluder => p_PRICING_ATTR_val_rec.excluder
2600: );
2601:
2602: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
2603: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2604: END IF;
2605:
2606: END IF;
2607:

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

2607:
2608: END IF;
2609:
2610: /*changes made by spgopal included pricing_phase_id and list_header_id to fix performance problem*/
2611: IF p_PRICING_ATTR_val_rec.list_header <> FND_API.G_MISS_CHAR
2612: THEN
2613:
2614: IF p_PRICING_ATTR_rec.list_header_id <> FND_API.G_MISS_NUM THEN
2615:

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

2610: /*changes made by spgopal included pricing_phase_id and list_header_id to fix performance problem*/
2611: IF p_PRICING_ATTR_val_rec.list_header <> FND_API.G_MISS_CHAR
2612: THEN
2613:
2614: IF p_PRICING_ATTR_rec.list_header_id <> FND_API.G_MISS_NUM THEN
2615:
2616: l_PRICING_ATTR_rec.list_header_id := p_PRICING_ATTR_rec.list_header_id;
2617:
2618: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

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

2627: ELSE
2628:
2629: l_PRICING_ATTR_rec.list_header_id := QP_Value_To_Id.list_header( p_list_header => p_PRICING_ATTR_val_rec.list_header);
2630:
2631: IF l_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM THEN
2632: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2633: END IF;
2634:
2635: END IF;

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

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

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

2635: END IF;
2636:
2637: END IF;
2638:
2639: IF p_PRICING_ATTR_val_rec.pricing_phase <> FND_API.G_MISS_CHAR
2640: THEN
2641:
2642: IF p_PRICING_ATTR_rec.pricing_phase_id <> FND_API.G_MISS_NUM THEN
2643:

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

2638:
2639: IF p_PRICING_ATTR_val_rec.pricing_phase <> FND_API.G_MISS_CHAR
2640: THEN
2641:
2642: IF p_PRICING_ATTR_rec.pricing_phase_id <> FND_API.G_MISS_NUM THEN
2643:
2644: l_PRICING_ATTR_rec.pricing_phase_id := p_PRICING_ATTR_rec.pricing_phase_id;
2645:
2646: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

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

2656:
2657: -- l_PRICING_ATTR_rec.pricing_phase_id := QP_Value_To_Id.pricing_phase( p_list_line => p_PRICING_ATTR_val_rec.pricing_phase);
2658: null;
2659:
2660: IF l_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN
2661: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2662: END IF;
2663:
2664: END IF;

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

2657: -- l_PRICING_ATTR_rec.pricing_phase_id := QP_Value_To_Id.pricing_phase( p_list_line => p_PRICING_ATTR_val_rec.pricing_phase);
2658: null;
2659:
2660: IF l_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN
2661: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2662: END IF;
2663:
2664: END IF;
2665:

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

2665:
2666: END IF;
2667:
2668: -----
2669: IF p_PRICING_ATTR_val_rec.list_line <> FND_API.G_MISS_CHAR
2670: THEN
2671:
2672: IF p_PRICING_ATTR_rec.list_line_id <> FND_API.G_MISS_NUM THEN
2673:

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

2668: -----
2669: IF p_PRICING_ATTR_val_rec.list_line <> FND_API.G_MISS_CHAR
2670: THEN
2671:
2672: IF p_PRICING_ATTR_rec.list_line_id <> FND_API.G_MISS_NUM THEN
2673:
2674: l_PRICING_ATTR_rec.list_line_id := p_PRICING_ATTR_rec.list_line_id;
2675:
2676: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

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

2687: l_PRICING_ATTR_rec.list_line_id := QP_Value_To_Id.list_line
2688: ( p_list_line => p_PRICING_ATTR_val_rec.list_line
2689: );
2690:
2691: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN
2692: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2693: END IF;
2694:
2695: END IF;

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

2688: ( p_list_line => p_PRICING_ATTR_val_rec.list_line
2689: );
2690:
2691: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN
2692: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2693: END IF;
2694:
2695: END IF;
2696:

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

2700: Added code to perform value_to_id conversion for pricing_Attribute,
2701: pricing_Attr_value_from and pricing_attr_value_to columns.
2702: ****************************************************************************/
2703:
2704: IF p_PRICING_ATTR_val_rec.pricing_attribute_desc <> FND_API.G_MISS_CHAR
2705: THEN
2706:
2707: IF p_PRICING_ATTR_rec.pricing_attribute <> FND_API.G_MISS_CHAR THEN
2708:

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

2703:
2704: IF p_PRICING_ATTR_val_rec.pricing_attribute_desc <> FND_API.G_MISS_CHAR
2705: THEN
2706:
2707: IF p_PRICING_ATTR_rec.pricing_attribute <> FND_API.G_MISS_CHAR THEN
2708:
2709: l_PRICING_ATTR_rec.pricing_attribute := p_PRICING_ATTR_rec.pricing_attribute;
2710:
2711: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

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

2723: ( p_pricing_attribute_desc => p_PRICING_ATTR_val_rec.pricing_attribute_desc,
2724: p_context => l_PRICING_ATTR_rec.pricing_attribute_context
2725: );
2726:
2727: IF l_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN
2728: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2729: END IF;
2730:
2731: END IF;

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

2724: p_context => l_PRICING_ATTR_rec.pricing_attribute_context
2725: );
2726:
2727: IF l_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN
2728: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2729: END IF;
2730:
2731: END IF;
2732:

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

2731: END IF;
2732:
2733: END IF;
2734:
2735: IF p_PRICING_ATTR_val_rec.pricing_attr_value_from_desc <> FND_API.G_MISS_CHAR
2736: THEN
2737:
2738: IF p_PRICING_ATTR_rec.pricing_attr_value_from <> FND_API.G_MISS_CHAR THEN
2739:

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

2734:
2735: IF p_PRICING_ATTR_val_rec.pricing_attr_value_from_desc <> FND_API.G_MISS_CHAR
2736: THEN
2737:
2738: IF p_PRICING_ATTR_rec.pricing_attr_value_from <> FND_API.G_MISS_CHAR THEN
2739:
2740: l_PRICING_ATTR_rec.pricing_attr_value_from := p_PRICING_ATTR_rec.pricing_attr_value_from;
2741:
2742: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

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

2755: p_context => l_PRICING_ATTR_rec.pricing_attribute_context,
2756: p_attribute => l_PRICING_ATTR_rec.pricing_attribute
2757: );
2758:
2759: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN
2760: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2761: END IF;
2762:
2763: END IF;

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

2756: p_attribute => l_PRICING_ATTR_rec.pricing_attribute
2757: );
2758:
2759: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN
2760: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2761: END IF;
2762:
2763: END IF;
2764:

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

2763: END IF;
2764:
2765: END IF;
2766:
2767: IF p_PRICING_ATTR_val_rec.pricing_attr_value_to_desc <> FND_API.G_MISS_CHAR
2768: THEN
2769:
2770: IF p_PRICING_ATTR_rec.pricing_attr_value_to <> FND_API.G_MISS_CHAR THEN
2771:

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

2766:
2767: IF p_PRICING_ATTR_val_rec.pricing_attr_value_to_desc <> FND_API.G_MISS_CHAR
2768: THEN
2769:
2770: IF p_PRICING_ATTR_rec.pricing_attr_value_to <> FND_API.G_MISS_CHAR THEN
2771:
2772: l_PRICING_ATTR_rec.pricing_attr_value_to := p_PRICING_ATTR_rec.pricing_attr_value_to;
2773:
2774: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

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

2787: p_context => l_PRICING_ATTR_rec.pricing_attribute_context,
2788: p_attribute => l_PRICING_ATTR_rec.pricing_attribute
2789: );
2790:
2791: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN
2792: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2793: END IF;
2794:
2795: END IF;

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

2788: p_attribute => l_PRICING_ATTR_rec.pricing_attribute
2789: );
2790:
2791: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN
2792: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2793: END IF;
2794:
2795: END IF;
2796:

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

2795: END IF;
2796:
2797: END IF;
2798:
2799: IF p_PRICING_ATTR_val_rec.product_uom <> FND_API.G_MISS_CHAR
2800: THEN
2801:
2802: IF p_PRICING_ATTR_rec.product_uom_code <> FND_API.G_MISS_CHAR THEN
2803:

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

2798:
2799: IF p_PRICING_ATTR_val_rec.product_uom <> FND_API.G_MISS_CHAR
2800: THEN
2801:
2802: IF p_PRICING_ATTR_rec.product_uom_code <> FND_API.G_MISS_CHAR THEN
2803:
2804: l_PRICING_ATTR_rec.product_uom_code := p_PRICING_ATTR_rec.product_uom_code;
2805:
2806: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

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

2817: l_PRICING_ATTR_rec.product_uom_code := QP_Value_To_Id.product_uom
2818: ( p_product_uom => p_PRICING_ATTR_val_rec.product_uom
2819: );
2820:
2821: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN
2822: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2823: END IF;
2824:
2825: END IF;

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

2818: ( p_product_uom => p_PRICING_ATTR_val_rec.product_uom
2819: );
2820:
2821: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN
2822: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2823: END IF;
2824:
2825: END IF;
2826:

Line 3019: WHEN FND_API.G_EXC_ERROR THEN

3015: END IF; --PL/SQL pattern search
3016: END IF; -- Java Engine Installed
3017:
3018: EXCEPTION
3019: WHEN FND_API.G_EXC_ERROR THEN
3020: RAISE;
3021: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3022: RAISE;
3023: WHEN OTHERS THEN

Line 3021: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3017:
3018: EXCEPTION
3019: WHEN FND_API.G_EXC_ERROR THEN
3020: RAISE;
3021: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3022: RAISE;
3023: WHEN OTHERS THEN
3024: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
3025: THEN

Line 3031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3027: ( G_PKG_NAME
3028: , 'Pre_Write_Process'
3029: );
3030: END IF;
3031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3032: END Pre_Write_Process;
3033:
3034: END QP_Pricing_Attr_Util;