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_PRICE_LIST_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_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
13: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
14: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
15: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type

Line 30: IF p_attr_id = FND_API.G_MISS_NUM THEN

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

Line 798: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

794: THEN
795: IF NOT QP_Validate.Price_List_Name(p_PRICE_LIST_rec.name,
796: p_PRICE_LIST_rec.list_header_id,
797: p_PRICE_LIST_rec.version_no) THEN
798: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
799: END IF;
800: END IF;
801:
802: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.description,p_old_PRICE_LIST_rec.description)

Line 868: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

864: /*
865: IF NOT QP_Validate.Rounding_Factor(p_PRICE_LIST_rec.rounding_factor,
866: p_PRICE_LIST_rec.currency_code)
867: THEN
868: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
869: END IF;
870: */
871: null;
872: END IF;

Line 954: IF l_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN

950: IS
951: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
952: BEGIN
953:
954: IF l_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN
955: l_PRICE_LIST_rec.attribute1 := p_old_PRICE_LIST_rec.attribute1;
956: END IF;
957:
958: IF l_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 958: IF l_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN

954: IF l_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN
955: l_PRICE_LIST_rec.attribute1 := p_old_PRICE_LIST_rec.attribute1;
956: END IF;
957:
958: IF l_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN
959: l_PRICE_LIST_rec.attribute10 := p_old_PRICE_LIST_rec.attribute10;
960: END IF;
961:
962: IF l_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 962: IF l_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN

958: IF l_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN
959: l_PRICE_LIST_rec.attribute10 := p_old_PRICE_LIST_rec.attribute10;
960: END IF;
961:
962: IF l_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN
963: l_PRICE_LIST_rec.attribute11 := p_old_PRICE_LIST_rec.attribute11;
964: END IF;
965:
966: IF l_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 966: IF l_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN

962: IF l_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN
963: l_PRICE_LIST_rec.attribute11 := p_old_PRICE_LIST_rec.attribute11;
964: END IF;
965:
966: IF l_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN
967: l_PRICE_LIST_rec.attribute12 := p_old_PRICE_LIST_rec.attribute12;
968: END IF;
969:
970: IF l_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 970: IF l_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN

966: IF l_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN
967: l_PRICE_LIST_rec.attribute12 := p_old_PRICE_LIST_rec.attribute12;
968: END IF;
969:
970: IF l_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN
971: l_PRICE_LIST_rec.attribute13 := p_old_PRICE_LIST_rec.attribute13;
972: END IF;
973:
974: IF l_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 974: IF l_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN

970: IF l_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN
971: l_PRICE_LIST_rec.attribute13 := p_old_PRICE_LIST_rec.attribute13;
972: END IF;
973:
974: IF l_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN
975: l_PRICE_LIST_rec.attribute14 := p_old_PRICE_LIST_rec.attribute14;
976: END IF;
977:
978: IF l_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 978: IF l_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN

974: IF l_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN
975: l_PRICE_LIST_rec.attribute14 := p_old_PRICE_LIST_rec.attribute14;
976: END IF;
977:
978: IF l_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN
979: l_PRICE_LIST_rec.attribute15 := p_old_PRICE_LIST_rec.attribute15;
980: END IF;
981:
982: IF l_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 982: IF l_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN

978: IF l_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN
979: l_PRICE_LIST_rec.attribute15 := p_old_PRICE_LIST_rec.attribute15;
980: END IF;
981:
982: IF l_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN
983: l_PRICE_LIST_rec.attribute2 := p_old_PRICE_LIST_rec.attribute2;
984: END IF;
985:
986: IF l_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 986: IF l_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN

982: IF l_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN
983: l_PRICE_LIST_rec.attribute2 := p_old_PRICE_LIST_rec.attribute2;
984: END IF;
985:
986: IF l_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN
987: l_PRICE_LIST_rec.attribute3 := p_old_PRICE_LIST_rec.attribute3;
988: END IF;
989:
990: IF l_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 990: IF l_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN

986: IF l_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN
987: l_PRICE_LIST_rec.attribute3 := p_old_PRICE_LIST_rec.attribute3;
988: END IF;
989:
990: IF l_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN
991: l_PRICE_LIST_rec.attribute4 := p_old_PRICE_LIST_rec.attribute4;
992: END IF;
993:
994: IF l_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 994: IF l_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN

990: IF l_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN
991: l_PRICE_LIST_rec.attribute4 := p_old_PRICE_LIST_rec.attribute4;
992: END IF;
993:
994: IF l_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN
995: l_PRICE_LIST_rec.attribute5 := p_old_PRICE_LIST_rec.attribute5;
996: END IF;
997:
998: IF l_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 998: IF l_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN

994: IF l_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN
995: l_PRICE_LIST_rec.attribute5 := p_old_PRICE_LIST_rec.attribute5;
996: END IF;
997:
998: IF l_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN
999: l_PRICE_LIST_rec.attribute6 := p_old_PRICE_LIST_rec.attribute6;
1000: END IF;
1001:
1002: IF l_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 1002: IF l_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN

998: IF l_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN
999: l_PRICE_LIST_rec.attribute6 := p_old_PRICE_LIST_rec.attribute6;
1000: END IF;
1001:
1002: IF l_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1003: l_PRICE_LIST_rec.attribute7 := p_old_PRICE_LIST_rec.attribute7;
1004: END IF;
1005:
1006: IF l_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 1006: IF l_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN

1002: IF l_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1003: l_PRICE_LIST_rec.attribute7 := p_old_PRICE_LIST_rec.attribute7;
1004: END IF;
1005:
1006: IF l_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1007: l_PRICE_LIST_rec.attribute8 := p_old_PRICE_LIST_rec.attribute8;
1008: END IF;
1009:
1010: IF l_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 1010: IF l_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN

1006: IF l_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1007: l_PRICE_LIST_rec.attribute8 := p_old_PRICE_LIST_rec.attribute8;
1008: END IF;
1009:
1010: IF l_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1011: l_PRICE_LIST_rec.attribute9 := p_old_PRICE_LIST_rec.attribute9;
1012: END IF;
1013:
1014: IF l_PRICE_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN

Line 1014: IF l_PRICE_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN

1010: IF l_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1011: l_PRICE_LIST_rec.attribute9 := p_old_PRICE_LIST_rec.attribute9;
1012: END IF;
1013:
1014: IF l_PRICE_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1015: l_PRICE_LIST_rec.automatic_flag := p_old_PRICE_LIST_rec.automatic_flag;
1016: END IF;
1017:
1018: IF l_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR THEN

Line 1018: IF l_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR THEN

1014: IF l_PRICE_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1015: l_PRICE_LIST_rec.automatic_flag := p_old_PRICE_LIST_rec.automatic_flag;
1016: END IF;
1017:
1018: IF l_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR THEN
1019: l_PRICE_LIST_rec.comments := p_old_PRICE_LIST_rec.comments;
1020: END IF;
1021:
1022: IF l_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR THEN

Line 1022: IF l_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR THEN

1018: IF l_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR THEN
1019: l_PRICE_LIST_rec.comments := p_old_PRICE_LIST_rec.comments;
1020: END IF;
1021:
1022: IF l_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR THEN
1023: l_PRICE_LIST_rec.context := p_old_PRICE_LIST_rec.context;
1024: END IF;
1025:
1026: IF l_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM THEN

Line 1026: IF l_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM THEN

1022: IF l_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR THEN
1023: l_PRICE_LIST_rec.context := p_old_PRICE_LIST_rec.context;
1024: END IF;
1025:
1026: IF l_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM THEN
1027: l_PRICE_LIST_rec.created_by := p_old_PRICE_LIST_rec.created_by;
1028: END IF;
1029:
1030: IF l_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 1030: IF l_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN

1026: IF l_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM THEN
1027: l_PRICE_LIST_rec.created_by := p_old_PRICE_LIST_rec.created_by;
1028: END IF;
1029:
1030: IF l_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN
1031: l_PRICE_LIST_rec.creation_date := p_old_PRICE_LIST_rec.creation_date;
1032: END IF;
1033:
1034: IF l_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN

Line 1034: IF l_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN

1030: IF l_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN
1031: l_PRICE_LIST_rec.creation_date := p_old_PRICE_LIST_rec.creation_date;
1032: END IF;
1033:
1034: IF l_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN
1035: l_PRICE_LIST_rec.currency_code := p_old_PRICE_LIST_rec.currency_code;
1036: END IF;
1037:
1038: IF l_PRICE_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN

Line 1038: IF l_PRICE_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN

1034: IF l_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN
1035: l_PRICE_LIST_rec.currency_code := p_old_PRICE_LIST_rec.currency_code;
1036: END IF;
1037:
1038: IF l_PRICE_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN
1039: l_PRICE_LIST_rec.discount_lines_flag := p_old_PRICE_LIST_rec.discount_lines_flag;
1040: END IF;
1041:
1042: IF l_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN

Line 1042: IF l_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN

1038: IF l_PRICE_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN
1039: l_PRICE_LIST_rec.discount_lines_flag := p_old_PRICE_LIST_rec.discount_lines_flag;
1040: END IF;
1041:
1042: IF l_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN
1043: l_PRICE_LIST_rec.end_date_active := p_old_PRICE_LIST_rec.end_date_active;
1044: END IF;
1045:
1046: IF l_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN

Line 1046: IF l_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN

1042: IF l_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN
1043: l_PRICE_LIST_rec.end_date_active := p_old_PRICE_LIST_rec.end_date_active;
1044: END IF;
1045:
1046: IF l_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
1047: l_PRICE_LIST_rec.freight_terms_code := p_old_PRICE_LIST_rec.freight_terms_code;
1048: END IF;
1049:
1050: IF l_PRICE_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR THEN

Line 1050: IF l_PRICE_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR THEN

1046: IF l_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
1047: l_PRICE_LIST_rec.freight_terms_code := p_old_PRICE_LIST_rec.freight_terms_code;
1048: END IF;
1049:
1050: IF l_PRICE_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR THEN
1051: l_PRICE_LIST_rec.gsa_indicator := p_old_PRICE_LIST_rec.gsa_indicator;
1052: END IF;
1053:
1054: IF l_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 1054: IF l_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN

1050: IF l_PRICE_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR THEN
1051: l_PRICE_LIST_rec.gsa_indicator := p_old_PRICE_LIST_rec.gsa_indicator;
1052: END IF;
1053:
1054: IF l_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1055: l_PRICE_LIST_rec.last_updated_by := p_old_PRICE_LIST_rec.last_updated_by;
1056: END IF;
1057:
1058: IF l_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 1058: IF l_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN

1054: IF l_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1055: l_PRICE_LIST_rec.last_updated_by := p_old_PRICE_LIST_rec.last_updated_by;
1056: END IF;
1057:
1058: IF l_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN
1059: l_PRICE_LIST_rec.last_update_date := p_old_PRICE_LIST_rec.last_update_date;
1060: END IF;
1061:
1062: IF l_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 1062: IF l_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN

1058: IF l_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN
1059: l_PRICE_LIST_rec.last_update_date := p_old_PRICE_LIST_rec.last_update_date;
1060: END IF;
1061:
1062: IF l_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN
1063: l_PRICE_LIST_rec.last_update_login := p_old_PRICE_LIST_rec.last_update_login;
1064: END IF;
1065:
1066: IF l_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR THEN

Line 1066: IF l_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR THEN

1062: IF l_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN
1063: l_PRICE_LIST_rec.last_update_login := p_old_PRICE_LIST_rec.last_update_login;
1064: END IF;
1065:
1066: IF l_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR THEN
1067: l_PRICE_LIST_rec.name := p_old_PRICE_LIST_rec.name;
1068: END IF;
1069:
1070:

Line 1071: IF l_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR THEN

1067: l_PRICE_LIST_rec.name := p_old_PRICE_LIST_rec.name;
1068: END IF;
1069:
1070:
1071: IF l_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR THEN
1072: l_PRICE_LIST_rec.description := p_old_PRICE_LIST_rec.description;
1073: END IF;
1074:
1075: IF l_PRICE_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN

Line 1075: IF l_PRICE_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN

1071: IF l_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR THEN
1072: l_PRICE_LIST_rec.description := p_old_PRICE_LIST_rec.description;
1073: END IF;
1074:
1075: IF l_PRICE_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN
1076: l_PRICE_LIST_rec.list_header_id := p_old_PRICE_LIST_rec.list_header_id;
1077: END IF;
1078:
1079: IF l_PRICE_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN

Line 1079: IF l_PRICE_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN

1075: IF l_PRICE_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN
1076: l_PRICE_LIST_rec.list_header_id := p_old_PRICE_LIST_rec.list_header_id;
1077: END IF;
1078:
1079: IF l_PRICE_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN
1080: l_PRICE_LIST_rec.list_type_code := p_old_PRICE_LIST_rec.list_type_code;
1081: END IF;
1082:
1083: IF l_PRICE_LIST_rec.version_no = FND_API.G_MISS_CHAR THEN

Line 1083: IF l_PRICE_LIST_rec.version_no = FND_API.G_MISS_CHAR THEN

1079: IF l_PRICE_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN
1080: l_PRICE_LIST_rec.list_type_code := p_old_PRICE_LIST_rec.list_type_code;
1081: END IF;
1082:
1083: IF l_PRICE_LIST_rec.version_no = FND_API.G_MISS_CHAR THEN
1084: l_PRICE_LIST_rec.version_no := p_old_PRICE_LIST_rec.version_no;
1085: END IF;
1086:
1087: IF l_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 1087: IF l_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN

1083: IF l_PRICE_LIST_rec.version_no = FND_API.G_MISS_CHAR THEN
1084: l_PRICE_LIST_rec.version_no := p_old_PRICE_LIST_rec.version_no;
1085: END IF;
1086:
1087: IF l_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN
1088: l_PRICE_LIST_rec.program_application_id := p_old_PRICE_LIST_rec.program_application_id;
1089: END IF;
1090:
1091: IF l_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM THEN

Line 1091: IF l_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM THEN

1087: IF l_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN
1088: l_PRICE_LIST_rec.program_application_id := p_old_PRICE_LIST_rec.program_application_id;
1089: END IF;
1090:
1091: IF l_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM THEN
1092: l_PRICE_LIST_rec.program_id := p_old_PRICE_LIST_rec.program_id;
1093: END IF;
1094:
1095: IF l_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 1095: IF l_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN

1091: IF l_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM THEN
1092: l_PRICE_LIST_rec.program_id := p_old_PRICE_LIST_rec.program_id;
1093: END IF;
1094:
1095: IF l_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN
1096: l_PRICE_LIST_rec.program_update_date := p_old_PRICE_LIST_rec.program_update_date;
1097: END IF;
1098:
1099: IF l_PRICE_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN

Line 1099: IF l_PRICE_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN

1095: IF l_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN
1096: l_PRICE_LIST_rec.program_update_date := p_old_PRICE_LIST_rec.program_update_date;
1097: END IF;
1098:
1099: IF l_PRICE_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN
1100: l_PRICE_LIST_rec.prorate_flag := p_old_PRICE_LIST_rec.prorate_flag;
1101: END IF;
1102:
1103: IF l_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM THEN

Line 1103: IF l_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM THEN

1099: IF l_PRICE_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN
1100: l_PRICE_LIST_rec.prorate_flag := p_old_PRICE_LIST_rec.prorate_flag;
1101: END IF;
1102:
1103: IF l_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM THEN
1104: l_PRICE_LIST_rec.request_id := p_old_PRICE_LIST_rec.request_id;
1105: END IF;
1106:
1107: IF l_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN

Line 1107: IF l_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN

1103: IF l_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM THEN
1104: l_PRICE_LIST_rec.request_id := p_old_PRICE_LIST_rec.request_id;
1105: END IF;
1106:
1107: IF l_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN
1108: l_PRICE_LIST_rec.rounding_factor := p_old_PRICE_LIST_rec.rounding_factor;
1109: END IF;
1110:
1111: IF l_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN

Line 1111: IF l_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN

1107: IF l_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN
1108: l_PRICE_LIST_rec.rounding_factor := p_old_PRICE_LIST_rec.rounding_factor;
1109: END IF;
1110:
1111: IF l_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
1112: l_PRICE_LIST_rec.ship_method_code := p_old_PRICE_LIST_rec.ship_method_code;
1113: END IF;
1114:
1115: IF l_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN

Line 1115: IF l_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN

1111: IF l_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
1112: l_PRICE_LIST_rec.ship_method_code := p_old_PRICE_LIST_rec.ship_method_code;
1113: END IF;
1114:
1115: IF l_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN
1116: l_PRICE_LIST_rec.start_date_active := p_old_PRICE_LIST_rec.start_date_active;
1117: END IF;
1118:
1119: IF l_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN

Line 1119: IF l_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN

1115: IF l_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN
1116: l_PRICE_LIST_rec.start_date_active := p_old_PRICE_LIST_rec.start_date_active;
1117: END IF;
1118:
1119: IF l_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN
1120: l_PRICE_LIST_rec.terms_id := p_old_PRICE_LIST_rec.terms_id;
1121: END IF;
1122:
1123: -- Blanket Agreement Pricing bug#3684285

Line 1124: IF l_PRICE_LIST_rec.list_source_code = FND_API.G_MISS_CHAR THEN

1120: l_PRICE_LIST_rec.terms_id := p_old_PRICE_LIST_rec.terms_id;
1121: END IF;
1122:
1123: -- Blanket Agreement Pricing bug#3684285
1124: IF l_PRICE_LIST_rec.list_source_code = FND_API.G_MISS_CHAR THEN
1125: l_PRICE_LIST_rec.list_source_code := p_old_PRICE_LIST_rec.list_source_code;
1126: END IF;
1127:
1128: IF l_PRICE_LIST_rec.orig_system_header_ref = FND_API.G_MISS_CHAR THEN

Line 1128: IF l_PRICE_LIST_rec.orig_system_header_ref = FND_API.G_MISS_CHAR THEN

1124: IF l_PRICE_LIST_rec.list_source_code = FND_API.G_MISS_CHAR THEN
1125: l_PRICE_LIST_rec.list_source_code := p_old_PRICE_LIST_rec.list_source_code;
1126: END IF;
1127:
1128: IF l_PRICE_LIST_rec.orig_system_header_ref = FND_API.G_MISS_CHAR THEN
1129: l_PRICE_LIST_rec.orig_system_header_ref := p_old_PRICE_LIST_rec.orig_system_header_ref;
1130: END IF;
1131:
1132: IF l_PRICE_LIST_rec.source_system_code = FND_API.G_MISS_CHAR THEN

Line 1132: IF l_PRICE_LIST_rec.source_system_code = FND_API.G_MISS_CHAR THEN

1128: IF l_PRICE_LIST_rec.orig_system_header_ref = FND_API.G_MISS_CHAR THEN
1129: l_PRICE_LIST_rec.orig_system_header_ref := p_old_PRICE_LIST_rec.orig_system_header_ref;
1130: END IF;
1131:
1132: IF l_PRICE_LIST_rec.source_system_code = FND_API.G_MISS_CHAR THEN
1133: l_PRICE_LIST_rec.source_system_code := p_old_PRICE_LIST_rec.source_system_code;
1134: END IF;
1135:
1136: IF l_PRICE_LIST_rec.pte_code = FND_API.G_MISS_CHAR THEN

Line 1136: IF l_PRICE_LIST_rec.pte_code = FND_API.G_MISS_CHAR THEN

1132: IF l_PRICE_LIST_rec.source_system_code = FND_API.G_MISS_CHAR THEN
1133: l_PRICE_LIST_rec.source_system_code := p_old_PRICE_LIST_rec.source_system_code;
1134: END IF;
1135:
1136: IF l_PRICE_LIST_rec.pte_code = FND_API.G_MISS_CHAR THEN
1137: l_PRICE_LIST_rec.pte_code := p_old_PRICE_LIST_rec.pte_code;
1138: END IF;
1139:
1140: IF l_PRICE_LIST_rec.shareable_flag = FND_API.G_MISS_CHAR THEN

Line 1140: IF l_PRICE_LIST_rec.shareable_flag = FND_API.G_MISS_CHAR THEN

1136: IF l_PRICE_LIST_rec.pte_code = FND_API.G_MISS_CHAR THEN
1137: l_PRICE_LIST_rec.pte_code := p_old_PRICE_LIST_rec.pte_code;
1138: END IF;
1139:
1140: IF l_PRICE_LIST_rec.shareable_flag = FND_API.G_MISS_CHAR THEN
1141: l_PRICE_LIST_rec.shareable_flag := p_old_PRICE_LIST_rec.shareable_flag;
1142: END IF;
1143:
1144: IF l_PRICE_LIST_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN

Line 1144: IF l_PRICE_LIST_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN

1140: IF l_PRICE_LIST_rec.shareable_flag = FND_API.G_MISS_CHAR THEN
1141: l_PRICE_LIST_rec.shareable_flag := p_old_PRICE_LIST_rec.shareable_flag;
1142: END IF;
1143:
1144: IF l_PRICE_LIST_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN
1145: l_PRICE_LIST_rec.sold_to_org_id := p_old_PRICE_LIST_rec.sold_to_org_id;
1146: END IF;
1147:
1148: /* Added code for active_flag and mobile_download by dhgupta for bug 2052900 */

Line 1150: IF l_PRICE_LIST_rec.active_flag = FND_API.G_MISS_CHAR THEN

1146: END IF;
1147:
1148: /* Added code for active_flag and mobile_download by dhgupta for bug 2052900 */
1149:
1150: IF l_PRICE_LIST_rec.active_flag = FND_API.G_MISS_CHAR THEN
1151: l_PRICE_LIST_rec.active_flag := p_old_PRICE_LIST_rec.active_flag;
1152: END IF;
1153:
1154: IF l_PRICE_LIST_rec.mobile_download = FND_API.G_MISS_CHAR THEN

Line 1154: IF l_PRICE_LIST_rec.mobile_download = FND_API.G_MISS_CHAR THEN

1150: IF l_PRICE_LIST_rec.active_flag = FND_API.G_MISS_CHAR THEN
1151: l_PRICE_LIST_rec.active_flag := p_old_PRICE_LIST_rec.active_flag;
1152: END IF;
1153:
1154: IF l_PRICE_LIST_rec.mobile_download = FND_API.G_MISS_CHAR THEN
1155: l_PRICE_LIST_rec.mobile_download := p_old_PRICE_LIST_rec.mobile_download;
1156: END IF;
1157:
1158: -- Pricing Security gtippire

Line 1159: IF l_PRICE_LIST_rec.global_flag = FND_API.G_MISS_CHAR THEN

1155: l_PRICE_LIST_rec.mobile_download := p_old_PRICE_LIST_rec.mobile_download;
1156: END IF;
1157:
1158: -- Pricing Security gtippire
1159: IF l_PRICE_LIST_rec.global_flag = FND_API.G_MISS_CHAR THEN
1160: l_PRICE_LIST_rec.global_flag := p_old_PRICE_LIST_rec.global_flag;
1161: END IF;
1162:
1163: IF l_PRICE_LIST_rec.locked_from_list_header_id = FND_API.G_MISS_NUM THEN

Line 1163: IF l_PRICE_LIST_rec.locked_from_list_header_id = FND_API.G_MISS_NUM THEN

1159: IF l_PRICE_LIST_rec.global_flag = FND_API.G_MISS_CHAR THEN
1160: l_PRICE_LIST_rec.global_flag := p_old_PRICE_LIST_rec.global_flag;
1161: END IF;
1162:
1163: IF l_PRICE_LIST_rec.locked_from_list_header_id = FND_API.G_MISS_NUM THEN
1164: l_PRICE_LIST_rec.locked_from_list_header_id := p_old_PRICE_LIST_rec.locked_from_list_header_id;
1165: END IF;
1166:
1167: --added for MOAC

Line 1168: IF l_PRICE_LIST_rec.org_id = FND_API.G_MISS_NUM THEN

1164: l_PRICE_LIST_rec.locked_from_list_header_id := p_old_PRICE_LIST_rec.locked_from_list_header_id;
1165: END IF;
1166:
1167: --added for MOAC
1168: IF l_PRICE_LIST_rec.org_id = FND_API.G_MISS_NUM THEN
1169: l_PRICE_LIST_rec.org_id := p_old_PRICE_LIST_rec.org_id;
1170: END IF;
1171:
1172: RETURN l_PRICE_LIST_rec;

Line 1185: IF l_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN

1181: IS
1182: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
1183: BEGIN
1184:
1185: IF l_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1186: l_PRICE_LIST_rec.attribute1 := NULL;
1187: END IF;
1188:
1189: IF l_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 1189: IF l_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN

1185: IF l_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1186: l_PRICE_LIST_rec.attribute1 := NULL;
1187: END IF;
1188:
1189: IF l_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1190: l_PRICE_LIST_rec.attribute10 := NULL;
1191: END IF;
1192:
1193: IF l_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 1193: IF l_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN

1189: IF l_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1190: l_PRICE_LIST_rec.attribute10 := NULL;
1191: END IF;
1192:
1193: IF l_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1194: l_PRICE_LIST_rec.attribute11 := NULL;
1195: END IF;
1196:
1197: IF l_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 1197: IF l_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN

1193: IF l_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1194: l_PRICE_LIST_rec.attribute11 := NULL;
1195: END IF;
1196:
1197: IF l_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1198: l_PRICE_LIST_rec.attribute12 := NULL;
1199: END IF;
1200:
1201: IF l_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 1201: IF l_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN

1197: IF l_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1198: l_PRICE_LIST_rec.attribute12 := NULL;
1199: END IF;
1200:
1201: IF l_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1202: l_PRICE_LIST_rec.attribute13 := NULL;
1203: END IF;
1204:
1205: IF l_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 1205: IF l_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN

1201: IF l_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1202: l_PRICE_LIST_rec.attribute13 := NULL;
1203: END IF;
1204:
1205: IF l_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1206: l_PRICE_LIST_rec.attribute14 := NULL;
1207: END IF;
1208:
1209: IF l_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 1209: IF l_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN

1205: IF l_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1206: l_PRICE_LIST_rec.attribute14 := NULL;
1207: END IF;
1208:
1209: IF l_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1210: l_PRICE_LIST_rec.attribute15 := NULL;
1211: END IF;
1212:
1213: IF l_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 1213: IF l_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN

1209: IF l_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1210: l_PRICE_LIST_rec.attribute15 := NULL;
1211: END IF;
1212:
1213: IF l_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1214: l_PRICE_LIST_rec.attribute2 := NULL;
1215: END IF;
1216:
1217: IF l_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 1217: IF l_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN

1213: IF l_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1214: l_PRICE_LIST_rec.attribute2 := NULL;
1215: END IF;
1216:
1217: IF l_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1218: l_PRICE_LIST_rec.attribute3 := NULL;
1219: END IF;
1220:
1221: IF l_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 1221: IF l_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN

1217: IF l_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1218: l_PRICE_LIST_rec.attribute3 := NULL;
1219: END IF;
1220:
1221: IF l_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1222: l_PRICE_LIST_rec.attribute4 := NULL;
1223: END IF;
1224:
1225: IF l_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 1225: IF l_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN

1221: IF l_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1222: l_PRICE_LIST_rec.attribute4 := NULL;
1223: END IF;
1224:
1225: IF l_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1226: l_PRICE_LIST_rec.attribute5 := NULL;
1227: END IF;
1228:
1229: IF l_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 1229: IF l_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN

1225: IF l_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1226: l_PRICE_LIST_rec.attribute5 := NULL;
1227: END IF;
1228:
1229: IF l_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1230: l_PRICE_LIST_rec.attribute6 := NULL;
1231: END IF;
1232:
1233: IF l_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 1233: IF l_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN

1229: IF l_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1230: l_PRICE_LIST_rec.attribute6 := NULL;
1231: END IF;
1232:
1233: IF l_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1234: l_PRICE_LIST_rec.attribute7 := NULL;
1235: END IF;
1236:
1237: IF l_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 1237: IF l_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN

1233: IF l_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1234: l_PRICE_LIST_rec.attribute7 := NULL;
1235: END IF;
1236:
1237: IF l_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1238: l_PRICE_LIST_rec.attribute8 := NULL;
1239: END IF;
1240:
1241: IF l_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 1241: IF l_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN

1237: IF l_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1238: l_PRICE_LIST_rec.attribute8 := NULL;
1239: END IF;
1240:
1241: IF l_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1242: l_PRICE_LIST_rec.attribute9 := NULL;
1243: END IF;
1244:
1245: IF l_PRICE_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN

Line 1245: IF l_PRICE_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN

1241: IF l_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1242: l_PRICE_LIST_rec.attribute9 := NULL;
1243: END IF;
1244:
1245: IF l_PRICE_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1246: l_PRICE_LIST_rec.automatic_flag := NULL;
1247: END IF;
1248:
1249: IF l_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR THEN

Line 1249: IF l_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR THEN

1245: IF l_PRICE_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1246: l_PRICE_LIST_rec.automatic_flag := NULL;
1247: END IF;
1248:
1249: IF l_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR THEN
1250: l_PRICE_LIST_rec.comments := NULL;
1251: END IF;
1252:
1253: IF l_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR THEN

Line 1253: IF l_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR THEN

1249: IF l_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR THEN
1250: l_PRICE_LIST_rec.comments := NULL;
1251: END IF;
1252:
1253: IF l_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR THEN
1254: l_PRICE_LIST_rec.context := NULL;
1255: END IF;
1256:
1257: IF l_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM THEN

Line 1257: IF l_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM THEN

1253: IF l_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR THEN
1254: l_PRICE_LIST_rec.context := NULL;
1255: END IF;
1256:
1257: IF l_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM THEN
1258: l_PRICE_LIST_rec.created_by := NULL;
1259: END IF;
1260:
1261: IF l_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 1261: IF l_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN

1257: IF l_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM THEN
1258: l_PRICE_LIST_rec.created_by := NULL;
1259: END IF;
1260:
1261: IF l_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN
1262: l_PRICE_LIST_rec.creation_date := NULL;
1263: END IF;
1264:
1265: IF l_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN

Line 1265: IF l_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN

1261: IF l_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN
1262: l_PRICE_LIST_rec.creation_date := NULL;
1263: END IF;
1264:
1265: IF l_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN
1266: l_PRICE_LIST_rec.currency_code := NULL;
1267: END IF;
1268:
1269: IF l_PRICE_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN

Line 1269: IF l_PRICE_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN

1265: IF l_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN
1266: l_PRICE_LIST_rec.currency_code := NULL;
1267: END IF;
1268:
1269: IF l_PRICE_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN
1270: l_PRICE_LIST_rec.discount_lines_flag := NULL;
1271: END IF;
1272:
1273: IF l_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN

Line 1273: IF l_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN

1269: IF l_PRICE_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN
1270: l_PRICE_LIST_rec.discount_lines_flag := NULL;
1271: END IF;
1272:
1273: IF l_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN
1274: l_PRICE_LIST_rec.end_date_active := NULL;
1275: END IF;
1276:
1277: IF l_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN

Line 1277: IF l_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN

1273: IF l_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN
1274: l_PRICE_LIST_rec.end_date_active := NULL;
1275: END IF;
1276:
1277: IF l_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
1278: l_PRICE_LIST_rec.freight_terms_code := NULL;
1279: END IF;
1280:
1281: IF l_PRICE_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR THEN

Line 1281: IF l_PRICE_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR THEN

1277: IF l_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
1278: l_PRICE_LIST_rec.freight_terms_code := NULL;
1279: END IF;
1280:
1281: IF l_PRICE_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR THEN
1282: l_PRICE_LIST_rec.gsa_indicator := NULL;
1283: END IF;
1284:
1285: IF l_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 1285: IF l_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN

1281: IF l_PRICE_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR THEN
1282: l_PRICE_LIST_rec.gsa_indicator := NULL;
1283: END IF;
1284:
1285: IF l_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1286: l_PRICE_LIST_rec.last_updated_by := NULL;
1287: END IF;
1288:
1289: IF l_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 1289: IF l_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN

1285: IF l_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1286: l_PRICE_LIST_rec.last_updated_by := NULL;
1287: END IF;
1288:
1289: IF l_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN
1290: l_PRICE_LIST_rec.last_update_date := NULL;
1291: END IF;
1292:
1293: IF l_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 1293: IF l_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN

1289: IF l_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN
1290: l_PRICE_LIST_rec.last_update_date := NULL;
1291: END IF;
1292:
1293: IF l_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN
1294: l_PRICE_LIST_rec.last_update_login := NULL;
1295: END IF;
1296:
1297: IF l_PRICE_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN

Line 1297: IF l_PRICE_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN

1293: IF l_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN
1294: l_PRICE_LIST_rec.last_update_login := NULL;
1295: END IF;
1296:
1297: IF l_PRICE_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN
1298: l_PRICE_LIST_rec.list_header_id := NULL;
1299: END IF;
1300:
1301: IF l_PRICE_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN

Line 1301: IF l_PRICE_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN

1297: IF l_PRICE_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN
1298: l_PRICE_LIST_rec.list_header_id := NULL;
1299: END IF;
1300:
1301: IF l_PRICE_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN
1302: l_PRICE_LIST_rec.list_type_code := NULL;
1303: END IF;
1304:
1305: IF l_PRICE_LIST_rec.version_no = FND_API.G_MISS_CHAR THEN

Line 1305: IF l_PRICE_LIST_rec.version_no = FND_API.G_MISS_CHAR THEN

1301: IF l_PRICE_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN
1302: l_PRICE_LIST_rec.list_type_code := NULL;
1303: END IF;
1304:
1305: IF l_PRICE_LIST_rec.version_no = FND_API.G_MISS_CHAR THEN
1306: l_PRICE_LIST_rec.version_no := NULL;
1307: END IF;
1308:
1309: IF l_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 1309: IF l_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN

1305: IF l_PRICE_LIST_rec.version_no = FND_API.G_MISS_CHAR THEN
1306: l_PRICE_LIST_rec.version_no := NULL;
1307: END IF;
1308:
1309: IF l_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN
1310: l_PRICE_LIST_rec.program_application_id := NULL;
1311: END IF;
1312:
1313: IF l_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM THEN

Line 1313: IF l_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM THEN

1309: IF l_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN
1310: l_PRICE_LIST_rec.program_application_id := NULL;
1311: END IF;
1312:
1313: IF l_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM THEN
1314: l_PRICE_LIST_rec.program_id := NULL;
1315: END IF;
1316:
1317: IF l_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 1317: IF l_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN

1313: IF l_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM THEN
1314: l_PRICE_LIST_rec.program_id := NULL;
1315: END IF;
1316:
1317: IF l_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN
1318: l_PRICE_LIST_rec.program_update_date := NULL;
1319: END IF;
1320:
1321: IF l_PRICE_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN

Line 1321: IF l_PRICE_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN

1317: IF l_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN
1318: l_PRICE_LIST_rec.program_update_date := NULL;
1319: END IF;
1320:
1321: IF l_PRICE_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN
1322: l_PRICE_LIST_rec.prorate_flag := NULL;
1323: END IF;
1324:
1325: IF l_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM THEN

Line 1325: IF l_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM THEN

1321: IF l_PRICE_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN
1322: l_PRICE_LIST_rec.prorate_flag := NULL;
1323: END IF;
1324:
1325: IF l_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM THEN
1326: l_PRICE_LIST_rec.request_id := NULL;
1327: END IF;
1328:
1329: IF l_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN

Line 1329: IF l_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN

1325: IF l_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM THEN
1326: l_PRICE_LIST_rec.request_id := NULL;
1327: END IF;
1328:
1329: IF l_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN
1330: l_PRICE_LIST_rec.rounding_factor := NULL;
1331: END IF;
1332:
1333: IF l_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN

Line 1333: IF l_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN

1329: IF l_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN
1330: l_PRICE_LIST_rec.rounding_factor := NULL;
1331: END IF;
1332:
1333: IF l_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
1334: l_PRICE_LIST_rec.ship_method_code := NULL;
1335: END IF;
1336:
1337: IF l_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN

Line 1337: IF l_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN

1333: IF l_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
1334: l_PRICE_LIST_rec.ship_method_code := NULL;
1335: END IF;
1336:
1337: IF l_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN
1338: l_PRICE_LIST_rec.start_date_active := NULL;
1339: END IF;
1340:
1341: IF l_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN

Line 1341: IF l_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN

1337: IF l_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN
1338: l_PRICE_LIST_rec.start_date_active := NULL;
1339: END IF;
1340:
1341: IF l_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN
1342: l_PRICE_LIST_rec.terms_id := NULL;
1343: END IF;
1344:
1345: IF l_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR THEN

Line 1345: IF l_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR THEN

1341: IF l_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN
1342: l_PRICE_LIST_rec.terms_id := NULL;
1343: END IF;
1344:
1345: IF l_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR THEN
1346: l_PRICE_LIST_rec.name := NULL;
1347: END IF;
1348:
1349: IF l_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR THEN

Line 1349: IF l_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR THEN

1345: IF l_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR THEN
1346: l_PRICE_LIST_rec.name := NULL;
1347: END IF;
1348:
1349: IF l_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR THEN
1350: l_PRICE_LIST_rec.description := NULL;
1351: END IF;
1352:
1353: IF l_PRICE_LIST_rec.locked_from_list_header_id = FND_API.G_MISS_NUM THEN

Line 1353: IF l_PRICE_LIST_rec.locked_from_list_header_id = FND_API.G_MISS_NUM THEN

1349: IF l_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR THEN
1350: l_PRICE_LIST_rec.description := NULL;
1351: END IF;
1352:
1353: IF l_PRICE_LIST_rec.locked_from_list_header_id = FND_API.G_MISS_NUM THEN
1354: l_PRICE_LIST_rec.locked_from_list_header_id := NULL;
1355: END IF;
1356:
1357: RETURN l_PRICE_LIST_rec;

Line 1418: decode(p_PRICE_LIST_rec.active_flag, FND_API.G_MISS_CHAR, ACTIVE_FLAG, --dhgupta for 2052900

1414: , START_DATE_ACTIVE = trunc(p_PRICE_LIST_rec.start_date_active)
1415: , TERMS_ID = p_PRICE_LIST_rec.terms_id
1416: , ASK_FOR_FLAG = 'N'
1417: , ACTIVE_FLAG =
1418: decode(p_PRICE_LIST_rec.active_flag, FND_API.G_MISS_CHAR, ACTIVE_FLAG, --dhgupta for 2052900
1419: p_PRICE_LIST_rec.active_flag)
1420: , MOBILE_DOWNLOAD =
1421: decode(p_PRICE_LIST_rec.mobile_download, FND_API.G_MISS_CHAR, MOBILE_DOWNLOAD,--dhgupta for 2052900
1422: p_PRICE_LIST_rec.mobile_download) -- mkarya for bug 1944882

Line 1421: decode(p_PRICE_LIST_rec.mobile_download, FND_API.G_MISS_CHAR, MOBILE_DOWNLOAD,--dhgupta for 2052900

1417: , ACTIVE_FLAG =
1418: decode(p_PRICE_LIST_rec.active_flag, FND_API.G_MISS_CHAR, ACTIVE_FLAG, --dhgupta for 2052900
1419: p_PRICE_LIST_rec.active_flag)
1420: , MOBILE_DOWNLOAD =
1421: decode(p_PRICE_LIST_rec.mobile_download, FND_API.G_MISS_CHAR, MOBILE_DOWNLOAD,--dhgupta for 2052900
1422: p_PRICE_LIST_rec.mobile_download) -- mkarya for bug 1944882
1423: , CURRENCY_HEADER_ID = p_PRICE_LIST_rec.currency_header_id
1424: , PTE_CODE = p_PRICE_LIST_rec.pte_code -- Giri for Attributes Manager
1425: , LIST_SOURCE_CODE = p_PRICE_LIST_rec.list_source_code --Blanket Sales Order

Line 1428: decode(p_PRICE_LIST_rec.global_flag, FND_API.G_MISS_CHAR, GLOBAL_FLAG,

1424: , PTE_CODE = p_PRICE_LIST_rec.pte_code -- Giri for Attributes Manager
1425: , LIST_SOURCE_CODE = p_PRICE_LIST_rec.list_source_code --Blanket Sales Order
1426: , ORIG_SYSTEM_HEADER_REF = p_PRICE_LIST_rec.orig_system_header_ref --Blanket Sales Order
1427: , GLOBAL_FLAG =
1428: decode(p_PRICE_LIST_rec.global_flag, FND_API.G_MISS_CHAR, GLOBAL_FLAG,
1429: p_PRICE_LIST_rec.global_flag) -- Pricing Security gtippire
1430: , SOURCE_SYSTEM_CODE = p_PRICE_LIST_rec.source_system_code
1431: , SHAREABLE_FLAG = p_PRICE_LIST_rec.shareable_flag
1432: , SOLD_TO_ORG_ID = p_PRICE_LIST_rec.sold_to_org_id

Line 1469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1465: , 'Update_Row'
1466: );
1467: END IF;
1468:
1469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1470:
1471: END Update_Row;
1472:
1473: -- Procedure Insert_Row

Line 1591: , decode(p_PRICE_LIST_rec.active_flag, FND_API.G_MISS_CHAR, 'Y',

1587: , p_PRICE_LIST_rec.terms_id
1588: , 'N' /* ask_for_flag */
1589: -- , l_source_system_code
1590: , p_PRICE_LIST_rec.source_system_code
1591: , decode(p_PRICE_LIST_rec.active_flag, FND_API.G_MISS_CHAR, 'Y',
1592: p_PRICE_LIST_rec.active_flag)
1593: , decode(p_PRICE_LIST_rec.mobile_download, FND_API.G_MISS_CHAR, 'N',
1594: p_PRICE_LIST_rec.mobile_download) -- mkarya for bug 1944882
1595: , p_PRICE_LIST_rec.currency_header_id

Line 1593: , decode(p_PRICE_LIST_rec.mobile_download, FND_API.G_MISS_CHAR, 'N',

1589: -- , l_source_system_code
1590: , p_PRICE_LIST_rec.source_system_code
1591: , decode(p_PRICE_LIST_rec.active_flag, FND_API.G_MISS_CHAR, 'Y',
1592: p_PRICE_LIST_rec.active_flag)
1593: , decode(p_PRICE_LIST_rec.mobile_download, FND_API.G_MISS_CHAR, 'N',
1594: p_PRICE_LIST_rec.mobile_download) -- mkarya for bug 1944882
1595: , p_PRICE_LIST_rec.currency_header_id
1596: , p_PRICE_LIST_rec.pte_code -- Giri for Attributes Manager
1597: , p_PRICE_LIST_rec.list_source_code -- Blanket Sales Order

Line 1600: , decode(p_PRICE_LIST_rec.global_flag, FND_API.G_MISS_CHAR, 'N',

1596: , p_PRICE_LIST_rec.pte_code -- Giri for Attributes Manager
1597: , p_PRICE_LIST_rec.list_source_code -- Blanket Sales Order
1598: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1599: , nvl(p_PRICE_LIST_rec.orig_system_header_ref,QP_PRICE_LIST_UTIL.Get_Orig_Sys_Hdr(p_PRICE_LIST_rec.list_header_id)) -- Blanket Sales Order
1600: , decode(p_PRICE_LIST_rec.global_flag, FND_API.G_MISS_CHAR, 'N',
1601: p_PRICE_LIST_rec.global_flag) -- Pricing Security gtippire
1602: --added for MOAC
1603: , p_PRICE_LIST_rec.org_id
1604: , p_PRICE_LIST_rec.shareable_flag

Line 1663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1659: , 'Insert_Row'
1660: );
1661: END IF;
1662:
1663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1664:
1665: END Insert_Row;
1666:
1667: -- Procedure Delete_Row

Line 1721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1717: , 'Delete_Row'
1718: );
1719: END IF;
1720:
1721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1722:
1723: END Delete_Row;
1724:
1725: -- Function Query_Row

Line 1867: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1863: , 'Query_Row'
1864: );
1865: END IF;
1866:
1867: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1868:
1869: END Query_Row;
1870:
1871: -- Procedure lock_Row

Line 2118: x_return_status := FND_API.G_RET_STS_SUCCESS;

2114: x_PRICE_LIST_rec := l_PRICE_LIST_rec;
2115:
2116: -- Set return status
2117:
2118: x_return_status := FND_API.G_RET_STS_SUCCESS;
2119: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2120:
2121: oe_debug_pub.add('success 1');
2122:

Line 2119: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_SUCCESS;

2115:
2116: -- Set return status
2117:
2118: x_return_status := FND_API.G_RET_STS_SUCCESS;
2119: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2120:
2121: oe_debug_pub.add('success 1');
2122:
2123: ELSE

Line 2140: x_return_status := FND_API.G_RET_STS_ERROR;

2136: oe_debug_pub.add('DB Value: OSHR'||l_PRICE_LIST_rec.orig_system_header_ref);
2137: end if;
2138: oe_debug_pub.add('failed 1');
2139:
2140: x_return_status := FND_API.G_RET_STS_ERROR;
2141: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2142:
2143: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2144: THEN

Line 2141: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

2137: end if;
2138: oe_debug_pub.add('failed 1');
2139:
2140: x_return_status := FND_API.G_RET_STS_ERROR;
2141: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2142:
2143: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2144: THEN
2145:

Line 2188: x_return_status := FND_API.G_RET_STS_ERROR;

2184: EXCEPTION
2185:
2186: WHEN NO_DATA_FOUND THEN
2187:
2188: x_return_status := FND_API.G_RET_STS_ERROR;
2189: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2190:
2191: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2192: THEN

Line 2189: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

2185:
2186: WHEN NO_DATA_FOUND THEN
2187:
2188: x_return_status := FND_API.G_RET_STS_ERROR;
2189: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2190:
2191: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2192: THEN
2193:

Line 2200: x_return_status := FND_API.G_RET_STS_ERROR;

2196:
2197: END IF;
2198: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2199:
2200: x_return_status := FND_API.G_RET_STS_ERROR;
2201: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2202:
2203: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2204: THEN

Line 2201: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

2197: END IF;
2198: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2199:
2200: x_return_status := FND_API.G_RET_STS_ERROR;
2201: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2202:
2203: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2204: THEN
2205:

Line 2212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2208:
2209: END IF;
2210: WHEN OTHERS THEN
2211:
2212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2213: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2214:
2215: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2216: THEN

Line 2213: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2209: END IF;
2210: WHEN OTHERS THEN
2211:
2212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2213: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2214:
2215: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2216: THEN
2217: oe_msg_pub.Add_Exc_Msg

Line 2237: p_PRICE_LIST_rec.automatic_flag <> FND_API.G_MISS_CHAR AND

2233: l_PRICE_LIST_val_rec QP_Price_List_PUB.Price_List_Val_Rec_Type;
2234: BEGIN
2235:
2236: IF p_PRICE_LIST_rec.automatic_flag IS NOT NULL AND
2237: p_PRICE_LIST_rec.automatic_flag <> FND_API.G_MISS_CHAR AND
2238: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.automatic_flag,
2239: p_old_PRICE_LIST_rec.automatic_flag)
2240: THEN
2241: l_PRICE_LIST_val_rec.automatic := QP_Id_To_Value.Automatic

Line 2247: p_PRICE_LIST_rec.currency_code <> FND_API.G_MISS_CHAR AND

2243: );
2244: END IF;
2245:
2246: IF p_PRICE_LIST_rec.currency_code IS NOT NULL AND
2247: p_PRICE_LIST_rec.currency_code <> FND_API.G_MISS_CHAR AND
2248: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_code,
2249: p_old_PRICE_LIST_rec.currency_code)
2250: THEN
2251: l_PRICE_LIST_val_rec.currency := QP_Id_To_Value.Currency

Line 2257: p_PRICE_LIST_rec.discount_lines_flag <> FND_API.G_MISS_CHAR AND

2253: );
2254: END IF;
2255:
2256: IF p_PRICE_LIST_rec.discount_lines_flag IS NOT NULL AND
2257: p_PRICE_LIST_rec.discount_lines_flag <> FND_API.G_MISS_CHAR AND
2258: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.discount_lines_flag,
2259: p_old_PRICE_LIST_rec.discount_lines_flag)
2260: THEN
2261: l_PRICE_LIST_val_rec.discount_lines := QP_Id_To_Value.Discount_Lines

Line 2267: p_PRICE_LIST_rec.freight_terms_code <> FND_API.G_MISS_CHAR AND

2263: );
2264: END IF;
2265:
2266: IF p_PRICE_LIST_rec.freight_terms_code IS NOT NULL AND
2267: p_PRICE_LIST_rec.freight_terms_code <> FND_API.G_MISS_CHAR AND
2268: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.freight_terms_code,
2269: p_old_PRICE_LIST_rec.freight_terms_code)
2270: THEN
2271: l_PRICE_LIST_val_rec.freight_terms := QP_Id_To_Value.Freight_Terms

Line 2277: p_PRICE_LIST_rec.list_header_id <> FND_API.G_MISS_NUM AND

2273: );
2274: END IF;
2275:
2276: IF p_PRICE_LIST_rec.list_header_id IS NOT NULL AND
2277: p_PRICE_LIST_rec.list_header_id <> FND_API.G_MISS_NUM AND
2278: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_header_id,
2279: p_old_PRICE_LIST_rec.list_header_id)
2280: THEN
2281: l_PRICE_LIST_val_rec.list_header := QP_Id_To_Value.List_Header

Line 2287: p_PRICE_LIST_rec.list_type_code <> FND_API.G_MISS_CHAR AND

2283: );
2284: END IF;
2285:
2286: IF p_PRICE_LIST_rec.list_type_code IS NOT NULL AND
2287: p_PRICE_LIST_rec.list_type_code <> FND_API.G_MISS_CHAR AND
2288: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_type_code,
2289: p_old_PRICE_LIST_rec.list_type_code)
2290: THEN
2291: l_PRICE_LIST_val_rec.list_type := QP_Id_To_Value.List_Type

Line 2297: p_PRICE_LIST_rec.prorate_flag <> FND_API.G_MISS_CHAR AND

2293: );
2294: END IF;
2295:
2296: IF p_PRICE_LIST_rec.prorate_flag IS NOT NULL AND
2297: p_PRICE_LIST_rec.prorate_flag <> FND_API.G_MISS_CHAR AND
2298: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.prorate_flag,
2299: p_old_PRICE_LIST_rec.prorate_flag)
2300: THEN
2301: l_PRICE_LIST_val_rec.prorate := QP_Id_To_Value.Prorate

Line 2307: p_PRICE_LIST_rec.ship_method_code <> FND_API.G_MISS_CHAR AND

2303: );
2304: END IF;
2305:
2306: IF p_PRICE_LIST_rec.ship_method_code IS NOT NULL AND
2307: p_PRICE_LIST_rec.ship_method_code <> FND_API.G_MISS_CHAR AND
2308: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.ship_method_code,
2309: p_old_PRICE_LIST_rec.ship_method_code)
2310: THEN
2311: l_PRICE_LIST_val_rec.ship_method := QP_Id_To_Value.Ship_Method

Line 2317: p_PRICE_LIST_rec.terms_id <> FND_API.G_MISS_NUM AND

2313: );
2314: END IF;
2315:
2316: IF p_PRICE_LIST_rec.terms_id IS NOT NULL AND
2317: p_PRICE_LIST_rec.terms_id <> FND_API.G_MISS_NUM AND
2318: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.terms_id,
2319: p_old_PRICE_LIST_rec.terms_id)
2320: THEN
2321: l_PRICE_LIST_val_rec.terms := QP_Id_To_Value.Terms

Line 2342: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_SUCCESS;

2338: BEGIN
2339:
2340: -- initialize return_status.
2341:
2342: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2343:
2344: -- initialize l_PRICE_LIST_rec.
2345:
2346: l_PRICE_LIST_rec := p_PRICE_LIST_rec;

Line 2348: IF p_PRICE_LIST_val_rec.automatic <> FND_API.G_MISS_CHAR

2344: -- initialize l_PRICE_LIST_rec.
2345:
2346: l_PRICE_LIST_rec := p_PRICE_LIST_rec;
2347:
2348: IF p_PRICE_LIST_val_rec.automatic <> FND_API.G_MISS_CHAR
2349: THEN
2350:
2351: IF p_PRICE_LIST_rec.automatic_flag <> FND_API.G_MISS_CHAR THEN
2352:

Line 2351: IF p_PRICE_LIST_rec.automatic_flag <> FND_API.G_MISS_CHAR THEN

2347:
2348: IF p_PRICE_LIST_val_rec.automatic <> FND_API.G_MISS_CHAR
2349: THEN
2350:
2351: IF p_PRICE_LIST_rec.automatic_flag <> FND_API.G_MISS_CHAR THEN
2352:
2353: l_PRICE_LIST_rec.automatic_flag := p_PRICE_LIST_rec.automatic_flag;
2354:
2355: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 2370: IF l_PRICE_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN

2366: l_PRICE_LIST_rec.automatic_flag := QP_Value_To_Id.automatic
2367: ( p_automatic => p_PRICE_LIST_val_rec.automatic
2368: );
2369:
2370: IF l_PRICE_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
2371: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2372: END IF;
2373:
2374: END IF;

Line 2371: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

2367: ( p_automatic => p_PRICE_LIST_val_rec.automatic
2368: );
2369:
2370: IF l_PRICE_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
2371: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2372: END IF;
2373:
2374: END IF;
2375:

Line 2378: IF p_PRICE_LIST_val_rec.currency <> FND_API.G_MISS_CHAR

2374: END IF;
2375:
2376: END IF;
2377:
2378: IF p_PRICE_LIST_val_rec.currency <> FND_API.G_MISS_CHAR
2379: THEN
2380:
2381: IF p_PRICE_LIST_rec.currency_code <> FND_API.G_MISS_CHAR THEN
2382:

Line 2381: IF p_PRICE_LIST_rec.currency_code <> FND_API.G_MISS_CHAR THEN

2377:
2378: IF p_PRICE_LIST_val_rec.currency <> FND_API.G_MISS_CHAR
2379: THEN
2380:
2381: IF p_PRICE_LIST_rec.currency_code <> FND_API.G_MISS_CHAR THEN
2382:
2383: l_PRICE_LIST_rec.currency_code := p_PRICE_LIST_rec.currency_code;
2384:
2385: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 2400: IF l_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN

2396: l_PRICE_LIST_rec.currency_code := QP_Value_To_Id.currency
2397: ( p_currency => p_PRICE_LIST_val_rec.currency
2398: );
2399:
2400: IF l_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN
2401: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2402: END IF;
2403:
2404: END IF;

Line 2401: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

2397: ( p_currency => p_PRICE_LIST_val_rec.currency
2398: );
2399:
2400: IF l_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN
2401: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2402: END IF;
2403:
2404: END IF;
2405:

Line 2408: IF p_PRICE_LIST_val_rec.discount_lines <> FND_API.G_MISS_CHAR

2404: END IF;
2405:
2406: END IF;
2407:
2408: IF p_PRICE_LIST_val_rec.discount_lines <> FND_API.G_MISS_CHAR
2409: THEN
2410:
2411: IF p_PRICE_LIST_rec.discount_lines_flag <> FND_API.G_MISS_CHAR THEN
2412:

Line 2411: IF p_PRICE_LIST_rec.discount_lines_flag <> FND_API.G_MISS_CHAR THEN

2407:
2408: IF p_PRICE_LIST_val_rec.discount_lines <> FND_API.G_MISS_CHAR
2409: THEN
2410:
2411: IF p_PRICE_LIST_rec.discount_lines_flag <> FND_API.G_MISS_CHAR THEN
2412:
2413: l_PRICE_LIST_rec.discount_lines_flag := p_PRICE_LIST_rec.discount_lines_flag;
2414:
2415: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 2430: IF l_PRICE_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN

2426: l_PRICE_LIST_rec.discount_lines_flag := QP_Value_To_Id.discount_lines
2427: ( p_discount_lines => p_PRICE_LIST_val_rec.discount_lines
2428: );
2429:
2430: IF l_PRICE_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN
2431: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2432: END IF;
2433:
2434: END IF;

Line 2431: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

2427: ( p_discount_lines => p_PRICE_LIST_val_rec.discount_lines
2428: );
2429:
2430: IF l_PRICE_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN
2431: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2432: END IF;
2433:
2434: END IF;
2435:

Line 2438: IF p_PRICE_LIST_val_rec.freight_terms <> FND_API.G_MISS_CHAR

2434: END IF;
2435:
2436: END IF;
2437:
2438: IF p_PRICE_LIST_val_rec.freight_terms <> FND_API.G_MISS_CHAR
2439: THEN
2440:
2441: IF p_PRICE_LIST_rec.freight_terms_code <> FND_API.G_MISS_CHAR THEN
2442:

Line 2441: IF p_PRICE_LIST_rec.freight_terms_code <> FND_API.G_MISS_CHAR THEN

2437:
2438: IF p_PRICE_LIST_val_rec.freight_terms <> FND_API.G_MISS_CHAR
2439: THEN
2440:
2441: IF p_PRICE_LIST_rec.freight_terms_code <> FND_API.G_MISS_CHAR THEN
2442:
2443: l_PRICE_LIST_rec.freight_terms_code := p_PRICE_LIST_rec.freight_terms_code;
2444:
2445: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 2460: IF l_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN

2456: l_PRICE_LIST_rec.freight_terms_code := QP_Value_To_Id.freight_terms
2457: ( p_freight_terms => p_PRICE_LIST_val_rec.freight_terms
2458: );
2459:
2460: IF l_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
2461: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2462: END IF;
2463:
2464: END IF;

Line 2461: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

2457: ( p_freight_terms => p_PRICE_LIST_val_rec.freight_terms
2458: );
2459:
2460: IF l_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
2461: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2462: END IF;
2463:
2464: END IF;
2465:

Line 2468: IF p_PRICE_LIST_val_rec.list_header <> FND_API.G_MISS_CHAR

2464: END IF;
2465:
2466: END IF;
2467:
2468: IF p_PRICE_LIST_val_rec.list_header <> FND_API.G_MISS_CHAR
2469: THEN
2470:
2471: IF p_PRICE_LIST_rec.list_header_id <> FND_API.G_MISS_NUM THEN
2472:

Line 2471: IF p_PRICE_LIST_rec.list_header_id <> FND_API.G_MISS_NUM THEN

2467:
2468: IF p_PRICE_LIST_val_rec.list_header <> FND_API.G_MISS_CHAR
2469: THEN
2470:
2471: IF p_PRICE_LIST_rec.list_header_id <> FND_API.G_MISS_NUM THEN
2472:
2473: l_PRICE_LIST_rec.list_header_id := p_PRICE_LIST_rec.list_header_id;
2474:
2475: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 2490: IF l_PRICE_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN

2486: l_PRICE_LIST_rec.list_header_id := QP_Value_To_Id.list_header
2487: ( p_list_header => p_PRICE_LIST_val_rec.list_header
2488: );
2489:
2490: IF l_PRICE_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN
2491: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2492: END IF;
2493:
2494: END IF;

Line 2491: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

2487: ( p_list_header => p_PRICE_LIST_val_rec.list_header
2488: );
2489:
2490: IF l_PRICE_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN
2491: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2492: END IF;
2493:
2494: END IF;
2495:

Line 2498: IF p_PRICE_LIST_val_rec.list_type <> FND_API.G_MISS_CHAR

2494: END IF;
2495:
2496: END IF;
2497:
2498: IF p_PRICE_LIST_val_rec.list_type <> FND_API.G_MISS_CHAR
2499: THEN
2500:
2501: IF p_PRICE_LIST_rec.list_type_code <> FND_API.G_MISS_CHAR THEN
2502:

Line 2501: IF p_PRICE_LIST_rec.list_type_code <> FND_API.G_MISS_CHAR THEN

2497:
2498: IF p_PRICE_LIST_val_rec.list_type <> FND_API.G_MISS_CHAR
2499: THEN
2500:
2501: IF p_PRICE_LIST_rec.list_type_code <> FND_API.G_MISS_CHAR THEN
2502:
2503: l_PRICE_LIST_rec.list_type_code := p_PRICE_LIST_rec.list_type_code;
2504:
2505: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 2520: IF l_PRICE_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN

2516: l_PRICE_LIST_rec.list_type_code := QP_Value_To_Id.list_type
2517: ( p_list_type => p_PRICE_LIST_val_rec.list_type
2518: );
2519:
2520: IF l_PRICE_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN
2521: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2522: END IF;
2523:
2524: END IF;

Line 2521: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

2517: ( p_list_type => p_PRICE_LIST_val_rec.list_type
2518: );
2519:
2520: IF l_PRICE_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN
2521: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2522: END IF;
2523:
2524: END IF;
2525:

Line 2528: IF p_PRICE_LIST_val_rec.prorate <> FND_API.G_MISS_CHAR

2524: END IF;
2525:
2526: END IF;
2527:
2528: IF p_PRICE_LIST_val_rec.prorate <> FND_API.G_MISS_CHAR
2529: THEN
2530:
2531: IF p_PRICE_LIST_rec.prorate_flag <> FND_API.G_MISS_CHAR THEN
2532:

Line 2531: IF p_PRICE_LIST_rec.prorate_flag <> FND_API.G_MISS_CHAR THEN

2527:
2528: IF p_PRICE_LIST_val_rec.prorate <> FND_API.G_MISS_CHAR
2529: THEN
2530:
2531: IF p_PRICE_LIST_rec.prorate_flag <> FND_API.G_MISS_CHAR THEN
2532:
2533: l_PRICE_LIST_rec.prorate_flag := p_PRICE_LIST_rec.prorate_flag;
2534:
2535: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 2550: IF l_PRICE_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN

2546: l_PRICE_LIST_rec.prorate_flag := QP_Value_To_Id.prorate
2547: ( p_prorate => p_PRICE_LIST_val_rec.prorate
2548: );
2549:
2550: IF l_PRICE_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN
2551: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2552: END IF;
2553:
2554: END IF;

Line 2551: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

2547: ( p_prorate => p_PRICE_LIST_val_rec.prorate
2548: );
2549:
2550: IF l_PRICE_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN
2551: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2552: END IF;
2553:
2554: END IF;
2555:

Line 2558: IF p_PRICE_LIST_val_rec.ship_method <> FND_API.G_MISS_CHAR

2554: END IF;
2555:
2556: END IF;
2557:
2558: IF p_PRICE_LIST_val_rec.ship_method <> FND_API.G_MISS_CHAR
2559: THEN
2560:
2561: IF p_PRICE_LIST_rec.ship_method_code <> FND_API.G_MISS_CHAR THEN
2562:

Line 2561: IF p_PRICE_LIST_rec.ship_method_code <> FND_API.G_MISS_CHAR THEN

2557:
2558: IF p_PRICE_LIST_val_rec.ship_method <> FND_API.G_MISS_CHAR
2559: THEN
2560:
2561: IF p_PRICE_LIST_rec.ship_method_code <> FND_API.G_MISS_CHAR THEN
2562:
2563: l_PRICE_LIST_rec.ship_method_code := p_PRICE_LIST_rec.ship_method_code;
2564:
2565: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 2580: IF l_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN

2576: l_PRICE_LIST_rec.ship_method_code := QP_Value_To_Id.ship_method
2577: ( p_ship_method => p_PRICE_LIST_val_rec.ship_method
2578: );
2579:
2580: IF l_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
2581: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2582: END IF;
2583:
2584: END IF;

Line 2581: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

2577: ( p_ship_method => p_PRICE_LIST_val_rec.ship_method
2578: );
2579:
2580: IF l_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
2581: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2582: END IF;
2583:
2584: END IF;
2585:

Line 2588: IF p_PRICE_LIST_val_rec.terms <> FND_API.G_MISS_CHAR

2584: END IF;
2585:
2586: END IF;
2587:
2588: IF p_PRICE_LIST_val_rec.terms <> FND_API.G_MISS_CHAR
2589: THEN
2590:
2591: IF p_PRICE_LIST_rec.terms_id <> FND_API.G_MISS_NUM THEN
2592:

Line 2591: IF p_PRICE_LIST_rec.terms_id <> FND_API.G_MISS_NUM THEN

2587:
2588: IF p_PRICE_LIST_val_rec.terms <> FND_API.G_MISS_CHAR
2589: THEN
2590:
2591: IF p_PRICE_LIST_rec.terms_id <> FND_API.G_MISS_NUM THEN
2592:
2593: l_PRICE_LIST_rec.terms_id := p_PRICE_LIST_rec.terms_id;
2594:
2595: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 2610: IF l_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN

2606: l_PRICE_LIST_rec.terms_id := QP_Value_To_Id.terms
2607: ( p_terms => p_PRICE_LIST_val_rec.terms
2608: );
2609:
2610: IF l_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN
2611: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2612: END IF;
2613:
2614: END IF;

Line 2611: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

2607: ( p_terms => p_PRICE_LIST_val_rec.terms
2608: );
2609:
2610: IF l_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN
2611: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2612: END IF;
2613:
2614: END IF;
2615: