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

[Home] [Help]

APPS.QP_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 882: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

878: THEN
879: IF NOT QP_Validate.Price_List_Name(p_PRICE_LIST_rec.name,
880: p_PRICE_LIST_rec.list_header_id,
881: p_PRICE_LIST_rec.version_no) THEN
882: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
883: END IF;
884: END IF;
885:
886: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.description,p_old_PRICE_LIST_rec.description)

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

964: /*
965: IF NOT QP_Validate.Rounding_Factor(p_PRICE_LIST_rec.rounding_factor,
966: p_PRICE_LIST_rec.currency_code)
967: THEN
968: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
969: END IF;
970: */
971: null;
972: END IF;

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

1083: IS
1084: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
1085: BEGIN
1086:
1087: IF l_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1088: l_PRICE_LIST_rec.attribute1 := p_old_PRICE_LIST_rec.attribute1;
1089: END IF;
1090:
1091: IF l_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN

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

1087: IF l_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1088: l_PRICE_LIST_rec.attribute1 := p_old_PRICE_LIST_rec.attribute1;
1089: END IF;
1090:
1091: IF l_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1092: l_PRICE_LIST_rec.attribute10 := p_old_PRICE_LIST_rec.attribute10;
1093: END IF;
1094:
1095: IF l_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN

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

1091: IF l_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1092: l_PRICE_LIST_rec.attribute10 := p_old_PRICE_LIST_rec.attribute10;
1093: END IF;
1094:
1095: IF l_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1096: l_PRICE_LIST_rec.attribute11 := p_old_PRICE_LIST_rec.attribute11;
1097: END IF;
1098:
1099: IF l_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN

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

1095: IF l_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1096: l_PRICE_LIST_rec.attribute11 := p_old_PRICE_LIST_rec.attribute11;
1097: END IF;
1098:
1099: IF l_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1100: l_PRICE_LIST_rec.attribute12 := p_old_PRICE_LIST_rec.attribute12;
1101: END IF;
1102:
1103: IF l_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN

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

1099: IF l_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1100: l_PRICE_LIST_rec.attribute12 := p_old_PRICE_LIST_rec.attribute12;
1101: END IF;
1102:
1103: IF l_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1104: l_PRICE_LIST_rec.attribute13 := p_old_PRICE_LIST_rec.attribute13;
1105: END IF;
1106:
1107: IF l_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN

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

1103: IF l_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1104: l_PRICE_LIST_rec.attribute13 := p_old_PRICE_LIST_rec.attribute13;
1105: END IF;
1106:
1107: IF l_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1108: l_PRICE_LIST_rec.attribute14 := p_old_PRICE_LIST_rec.attribute14;
1109: END IF;
1110:
1111: IF l_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN

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

1107: IF l_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1108: l_PRICE_LIST_rec.attribute14 := p_old_PRICE_LIST_rec.attribute14;
1109: END IF;
1110:
1111: IF l_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1112: l_PRICE_LIST_rec.attribute15 := p_old_PRICE_LIST_rec.attribute15;
1113: END IF;
1114:
1115: IF l_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN

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

1111: IF l_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1112: l_PRICE_LIST_rec.attribute15 := p_old_PRICE_LIST_rec.attribute15;
1113: END IF;
1114:
1115: IF l_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1116: l_PRICE_LIST_rec.attribute2 := p_old_PRICE_LIST_rec.attribute2;
1117: END IF;
1118:
1119: IF l_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN

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

1115: IF l_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1116: l_PRICE_LIST_rec.attribute2 := p_old_PRICE_LIST_rec.attribute2;
1117: END IF;
1118:
1119: IF l_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1120: l_PRICE_LIST_rec.attribute3 := p_old_PRICE_LIST_rec.attribute3;
1121: END IF;
1122:
1123: IF l_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN

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

1119: IF l_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1120: l_PRICE_LIST_rec.attribute3 := p_old_PRICE_LIST_rec.attribute3;
1121: END IF;
1122:
1123: IF l_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1124: l_PRICE_LIST_rec.attribute4 := p_old_PRICE_LIST_rec.attribute4;
1125: END IF;
1126:
1127: IF l_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN

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

1123: IF l_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1124: l_PRICE_LIST_rec.attribute4 := p_old_PRICE_LIST_rec.attribute4;
1125: END IF;
1126:
1127: IF l_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1128: l_PRICE_LIST_rec.attribute5 := p_old_PRICE_LIST_rec.attribute5;
1129: END IF;
1130:
1131: IF l_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN

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

1127: IF l_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1128: l_PRICE_LIST_rec.attribute5 := p_old_PRICE_LIST_rec.attribute5;
1129: END IF;
1130:
1131: IF l_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1132: l_PRICE_LIST_rec.attribute6 := p_old_PRICE_LIST_rec.attribute6;
1133: END IF;
1134:
1135: IF l_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN

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

1131: IF l_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1132: l_PRICE_LIST_rec.attribute6 := p_old_PRICE_LIST_rec.attribute6;
1133: END IF;
1134:
1135: IF l_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1136: l_PRICE_LIST_rec.attribute7 := p_old_PRICE_LIST_rec.attribute7;
1137: END IF;
1138:
1139: IF l_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN

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

1135: IF l_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1136: l_PRICE_LIST_rec.attribute7 := p_old_PRICE_LIST_rec.attribute7;
1137: END IF;
1138:
1139: IF l_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1140: l_PRICE_LIST_rec.attribute8 := p_old_PRICE_LIST_rec.attribute8;
1141: END IF;
1142:
1143: IF l_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN

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

1139: IF l_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1140: l_PRICE_LIST_rec.attribute8 := p_old_PRICE_LIST_rec.attribute8;
1141: END IF;
1142:
1143: IF l_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1144: l_PRICE_LIST_rec.attribute9 := p_old_PRICE_LIST_rec.attribute9;
1145: END IF;
1146:
1147: IF l_PRICE_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN

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

1143: IF l_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1144: l_PRICE_LIST_rec.attribute9 := p_old_PRICE_LIST_rec.attribute9;
1145: END IF;
1146:
1147: IF l_PRICE_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1148: l_PRICE_LIST_rec.automatic_flag := p_old_PRICE_LIST_rec.automatic_flag;
1149: END IF;
1150:
1151: IF l_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR THEN

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

1147: IF l_PRICE_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1148: l_PRICE_LIST_rec.automatic_flag := p_old_PRICE_LIST_rec.automatic_flag;
1149: END IF;
1150:
1151: IF l_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR THEN
1152: l_PRICE_LIST_rec.comments := p_old_PRICE_LIST_rec.comments;
1153: END IF;
1154:
1155: IF l_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR THEN

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

1151: IF l_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR THEN
1152: l_PRICE_LIST_rec.comments := p_old_PRICE_LIST_rec.comments;
1153: END IF;
1154:
1155: IF l_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR THEN
1156: l_PRICE_LIST_rec.context := p_old_PRICE_LIST_rec.context;
1157: END IF;
1158:
1159: IF l_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM THEN

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

1155: IF l_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR THEN
1156: l_PRICE_LIST_rec.context := p_old_PRICE_LIST_rec.context;
1157: END IF;
1158:
1159: IF l_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM THEN
1160: l_PRICE_LIST_rec.created_by := p_old_PRICE_LIST_rec.created_by;
1161: END IF;
1162:
1163: IF l_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN

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

1159: IF l_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM THEN
1160: l_PRICE_LIST_rec.created_by := p_old_PRICE_LIST_rec.created_by;
1161: END IF;
1162:
1163: IF l_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN
1164: l_PRICE_LIST_rec.creation_date := p_old_PRICE_LIST_rec.creation_date;
1165: END IF;
1166:
1167: IF l_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN

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

1163: IF l_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN
1164: l_PRICE_LIST_rec.creation_date := p_old_PRICE_LIST_rec.creation_date;
1165: END IF;
1166:
1167: IF l_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN
1168: l_PRICE_LIST_rec.currency_code := p_old_PRICE_LIST_rec.currency_code;
1169: END IF;
1170:
1171: IF l_PRICE_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN

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

1167: IF l_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN
1168: l_PRICE_LIST_rec.currency_code := p_old_PRICE_LIST_rec.currency_code;
1169: END IF;
1170:
1171: IF l_PRICE_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN
1172: l_PRICE_LIST_rec.discount_lines_flag := p_old_PRICE_LIST_rec.discount_lines_flag;
1173: END IF;
1174:
1175: IF l_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN

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

1171: IF l_PRICE_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN
1172: l_PRICE_LIST_rec.discount_lines_flag := p_old_PRICE_LIST_rec.discount_lines_flag;
1173: END IF;
1174:
1175: IF l_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN
1176: l_PRICE_LIST_rec.end_date_active := p_old_PRICE_LIST_rec.end_date_active;
1177: END IF;
1178:
1179: IF l_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN

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

1175: IF l_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN
1176: l_PRICE_LIST_rec.end_date_active := p_old_PRICE_LIST_rec.end_date_active;
1177: END IF;
1178:
1179: IF l_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
1180: l_PRICE_LIST_rec.freight_terms_code := p_old_PRICE_LIST_rec.freight_terms_code;
1181: END IF;
1182:
1183: IF l_PRICE_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR THEN

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

1179: IF l_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
1180: l_PRICE_LIST_rec.freight_terms_code := p_old_PRICE_LIST_rec.freight_terms_code;
1181: END IF;
1182:
1183: IF l_PRICE_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR THEN
1184: l_PRICE_LIST_rec.gsa_indicator := p_old_PRICE_LIST_rec.gsa_indicator;
1185: END IF;
1186:
1187: IF l_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN

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

1183: IF l_PRICE_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR THEN
1184: l_PRICE_LIST_rec.gsa_indicator := p_old_PRICE_LIST_rec.gsa_indicator;
1185: END IF;
1186:
1187: IF l_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1188: l_PRICE_LIST_rec.last_updated_by := p_old_PRICE_LIST_rec.last_updated_by;
1189: END IF;
1190:
1191: IF l_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN

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

1187: IF l_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1188: l_PRICE_LIST_rec.last_updated_by := p_old_PRICE_LIST_rec.last_updated_by;
1189: END IF;
1190:
1191: IF l_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN
1192: l_PRICE_LIST_rec.last_update_date := p_old_PRICE_LIST_rec.last_update_date;
1193: END IF;
1194:
1195: IF l_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN

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

1191: IF l_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN
1192: l_PRICE_LIST_rec.last_update_date := p_old_PRICE_LIST_rec.last_update_date;
1193: END IF;
1194:
1195: IF l_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN
1196: l_PRICE_LIST_rec.last_update_login := p_old_PRICE_LIST_rec.last_update_login;
1197: END IF;
1198:
1199: IF l_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR THEN

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

1195: IF l_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN
1196: l_PRICE_LIST_rec.last_update_login := p_old_PRICE_LIST_rec.last_update_login;
1197: END IF;
1198:
1199: IF l_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR THEN
1200: l_PRICE_LIST_rec.name := p_old_PRICE_LIST_rec.name;
1201: END IF;
1202:
1203:

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

1200: l_PRICE_LIST_rec.name := p_old_PRICE_LIST_rec.name;
1201: END IF;
1202:
1203:
1204: IF l_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR THEN
1205: l_PRICE_LIST_rec.description := p_old_PRICE_LIST_rec.description;
1206: END IF;
1207:
1208: IF l_PRICE_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN

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

1204: IF l_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR THEN
1205: l_PRICE_LIST_rec.description := p_old_PRICE_LIST_rec.description;
1206: END IF;
1207:
1208: IF l_PRICE_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN
1209: l_PRICE_LIST_rec.list_header_id := p_old_PRICE_LIST_rec.list_header_id;
1210: END IF;
1211:
1212: IF l_PRICE_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN

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

1208: IF l_PRICE_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN
1209: l_PRICE_LIST_rec.list_header_id := p_old_PRICE_LIST_rec.list_header_id;
1210: END IF;
1211:
1212: IF l_PRICE_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN
1213: l_PRICE_LIST_rec.list_type_code := p_old_PRICE_LIST_rec.list_type_code;
1214: END IF;
1215:
1216: IF l_PRICE_LIST_rec.version_no = FND_API.G_MISS_CHAR THEN

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

1212: IF l_PRICE_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN
1213: l_PRICE_LIST_rec.list_type_code := p_old_PRICE_LIST_rec.list_type_code;
1214: END IF;
1215:
1216: IF l_PRICE_LIST_rec.version_no = FND_API.G_MISS_CHAR THEN
1217: l_PRICE_LIST_rec.version_no := p_old_PRICE_LIST_rec.version_no;
1218: END IF;
1219:
1220: IF l_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN

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

1216: IF l_PRICE_LIST_rec.version_no = FND_API.G_MISS_CHAR THEN
1217: l_PRICE_LIST_rec.version_no := p_old_PRICE_LIST_rec.version_no;
1218: END IF;
1219:
1220: IF l_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN
1221: l_PRICE_LIST_rec.program_application_id := p_old_PRICE_LIST_rec.program_application_id;
1222: END IF;
1223:
1224: IF l_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM THEN

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

1220: IF l_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN
1221: l_PRICE_LIST_rec.program_application_id := p_old_PRICE_LIST_rec.program_application_id;
1222: END IF;
1223:
1224: IF l_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM THEN
1225: l_PRICE_LIST_rec.program_id := p_old_PRICE_LIST_rec.program_id;
1226: END IF;
1227:
1228: IF l_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN

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

1224: IF l_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM THEN
1225: l_PRICE_LIST_rec.program_id := p_old_PRICE_LIST_rec.program_id;
1226: END IF;
1227:
1228: IF l_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN
1229: l_PRICE_LIST_rec.program_update_date := p_old_PRICE_LIST_rec.program_update_date;
1230: END IF;
1231:
1232: IF l_PRICE_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN

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

1228: IF l_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN
1229: l_PRICE_LIST_rec.program_update_date := p_old_PRICE_LIST_rec.program_update_date;
1230: END IF;
1231:
1232: IF l_PRICE_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN
1233: l_PRICE_LIST_rec.prorate_flag := p_old_PRICE_LIST_rec.prorate_flag;
1234: END IF;
1235:
1236: IF l_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM THEN

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

1232: IF l_PRICE_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN
1233: l_PRICE_LIST_rec.prorate_flag := p_old_PRICE_LIST_rec.prorate_flag;
1234: END IF;
1235:
1236: IF l_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM THEN
1237: l_PRICE_LIST_rec.request_id := p_old_PRICE_LIST_rec.request_id;
1238: END IF;
1239:
1240: IF l_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN

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

1236: IF l_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM THEN
1237: l_PRICE_LIST_rec.request_id := p_old_PRICE_LIST_rec.request_id;
1238: END IF;
1239:
1240: IF l_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN
1241: l_PRICE_LIST_rec.rounding_factor := p_old_PRICE_LIST_rec.rounding_factor;
1242: END IF;
1243:
1244: IF l_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN

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

1240: IF l_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN
1241: l_PRICE_LIST_rec.rounding_factor := p_old_PRICE_LIST_rec.rounding_factor;
1242: END IF;
1243:
1244: IF l_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
1245: l_PRICE_LIST_rec.ship_method_code := p_old_PRICE_LIST_rec.ship_method_code;
1246: END IF;
1247:
1248: IF l_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN

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

1244: IF l_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
1245: l_PRICE_LIST_rec.ship_method_code := p_old_PRICE_LIST_rec.ship_method_code;
1246: END IF;
1247:
1248: IF l_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN
1249: l_PRICE_LIST_rec.start_date_active := p_old_PRICE_LIST_rec.start_date_active;
1250: END IF;
1251:
1252: IF l_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN

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

1248: IF l_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN
1249: l_PRICE_LIST_rec.start_date_active := p_old_PRICE_LIST_rec.start_date_active;
1250: END IF;
1251:
1252: IF l_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN
1253: l_PRICE_LIST_rec.terms_id := p_old_PRICE_LIST_rec.terms_id;
1254: END IF;
1255:
1256: -- Blanket Agreement Pricing bug#3684285

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

1253: l_PRICE_LIST_rec.terms_id := p_old_PRICE_LIST_rec.terms_id;
1254: END IF;
1255:
1256: -- Blanket Agreement Pricing bug#3684285
1257: IF l_PRICE_LIST_rec.list_source_code = FND_API.G_MISS_CHAR THEN
1258: l_PRICE_LIST_rec.list_source_code := p_old_PRICE_LIST_rec.list_source_code;
1259: END IF;
1260:
1261: IF l_PRICE_LIST_rec.orig_system_header_ref = FND_API.G_MISS_CHAR THEN

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

1257: IF l_PRICE_LIST_rec.list_source_code = FND_API.G_MISS_CHAR THEN
1258: l_PRICE_LIST_rec.list_source_code := p_old_PRICE_LIST_rec.list_source_code;
1259: END IF;
1260:
1261: IF l_PRICE_LIST_rec.orig_system_header_ref = FND_API.G_MISS_CHAR THEN
1262: l_PRICE_LIST_rec.orig_system_header_ref := p_old_PRICE_LIST_rec.orig_system_header_ref;
1263: END IF;
1264:
1265: IF l_PRICE_LIST_rec.source_system_code = FND_API.G_MISS_CHAR THEN

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

1261: IF l_PRICE_LIST_rec.orig_system_header_ref = FND_API.G_MISS_CHAR THEN
1262: l_PRICE_LIST_rec.orig_system_header_ref := p_old_PRICE_LIST_rec.orig_system_header_ref;
1263: END IF;
1264:
1265: IF l_PRICE_LIST_rec.source_system_code = FND_API.G_MISS_CHAR THEN
1266: l_PRICE_LIST_rec.source_system_code := p_old_PRICE_LIST_rec.source_system_code;
1267: END IF;
1268:
1269: --bug#13110812

Line 1270: IF l_PRICE_LIST_rec.currency_header_id = FND_API.G_MISS_NUM THEN

1266: l_PRICE_LIST_rec.source_system_code := p_old_PRICE_LIST_rec.source_system_code;
1267: END IF;
1268:
1269: --bug#13110812
1270: IF l_PRICE_LIST_rec.currency_header_id = FND_API.G_MISS_NUM THEN
1271: l_PRICE_LIST_rec.currency_header_id := p_old_PRICE_LIST_rec.currency_header_id;
1272: END IF;
1273: --bug#13110812
1274:

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

1271: l_PRICE_LIST_rec.currency_header_id := p_old_PRICE_LIST_rec.currency_header_id;
1272: END IF;
1273: --bug#13110812
1274:
1275: IF l_PRICE_LIST_rec.pte_code = FND_API.G_MISS_CHAR THEN
1276: l_PRICE_LIST_rec.pte_code := p_old_PRICE_LIST_rec.pte_code;
1277: END IF;
1278:
1279: IF l_PRICE_LIST_rec.shareable_flag = FND_API.G_MISS_CHAR THEN

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

1275: IF l_PRICE_LIST_rec.pte_code = FND_API.G_MISS_CHAR THEN
1276: l_PRICE_LIST_rec.pte_code := p_old_PRICE_LIST_rec.pte_code;
1277: END IF;
1278:
1279: IF l_PRICE_LIST_rec.shareable_flag = FND_API.G_MISS_CHAR THEN
1280: l_PRICE_LIST_rec.shareable_flag := p_old_PRICE_LIST_rec.shareable_flag;
1281: END IF;
1282:
1283: IF l_PRICE_LIST_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN

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

1279: IF l_PRICE_LIST_rec.shareable_flag = FND_API.G_MISS_CHAR THEN
1280: l_PRICE_LIST_rec.shareable_flag := p_old_PRICE_LIST_rec.shareable_flag;
1281: END IF;
1282:
1283: IF l_PRICE_LIST_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN
1284: l_PRICE_LIST_rec.sold_to_org_id := p_old_PRICE_LIST_rec.sold_to_org_id;
1285: END IF;
1286:
1287: /* Added code for active_flag and mobile_download by dhgupta for bug 2052900 */

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

1285: END IF;
1286:
1287: /* Added code for active_flag and mobile_download by dhgupta for bug 2052900 */
1288:
1289: IF l_PRICE_LIST_rec.active_flag = FND_API.G_MISS_CHAR THEN
1290: l_PRICE_LIST_rec.active_flag := p_old_PRICE_LIST_rec.active_flag;
1291: END IF;
1292:
1293: IF l_PRICE_LIST_rec.mobile_download = FND_API.G_MISS_CHAR THEN

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

1289: IF l_PRICE_LIST_rec.active_flag = FND_API.G_MISS_CHAR THEN
1290: l_PRICE_LIST_rec.active_flag := p_old_PRICE_LIST_rec.active_flag;
1291: END IF;
1292:
1293: IF l_PRICE_LIST_rec.mobile_download = FND_API.G_MISS_CHAR THEN
1294: l_PRICE_LIST_rec.mobile_download := p_old_PRICE_LIST_rec.mobile_download;
1295: END IF;
1296:
1297: -- Pricing Security gtippire

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

1294: l_PRICE_LIST_rec.mobile_download := p_old_PRICE_LIST_rec.mobile_download;
1295: END IF;
1296:
1297: -- Pricing Security gtippire
1298: IF l_PRICE_LIST_rec.global_flag = FND_API.G_MISS_CHAR THEN
1299: l_PRICE_LIST_rec.global_flag := p_old_PRICE_LIST_rec.global_flag;
1300: END IF;
1301:
1302: IF l_PRICE_LIST_rec.locked_from_list_header_id = FND_API.G_MISS_NUM THEN

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

1298: IF l_PRICE_LIST_rec.global_flag = FND_API.G_MISS_CHAR THEN
1299: l_PRICE_LIST_rec.global_flag := p_old_PRICE_LIST_rec.global_flag;
1300: END IF;
1301:
1302: IF l_PRICE_LIST_rec.locked_from_list_header_id = FND_API.G_MISS_NUM THEN
1303: l_PRICE_LIST_rec.locked_from_list_header_id := p_old_PRICE_LIST_rec.locked_from_list_header_id;
1304: END IF;
1305:
1306: --added for MOAC

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

1303: l_PRICE_LIST_rec.locked_from_list_header_id := p_old_PRICE_LIST_rec.locked_from_list_header_id;
1304: END IF;
1305:
1306: --added for MOAC
1307: IF l_PRICE_LIST_rec.org_id = FND_API.G_MISS_NUM THEN
1308: l_PRICE_LIST_rec.org_id := p_old_PRICE_LIST_rec.org_id;
1309: END IF;
1310:
1311: RETURN l_PRICE_LIST_rec;

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

1320: IS
1321: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
1322: BEGIN
1323:
1324: IF l_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1325: l_PRICE_LIST_rec.attribute1 := NULL;
1326: END IF;
1327:
1328: IF l_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN

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

1324: IF l_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1325: l_PRICE_LIST_rec.attribute1 := NULL;
1326: END IF;
1327:
1328: IF l_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1329: l_PRICE_LIST_rec.attribute10 := NULL;
1330: END IF;
1331:
1332: IF l_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN

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

1328: IF l_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1329: l_PRICE_LIST_rec.attribute10 := NULL;
1330: END IF;
1331:
1332: IF l_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1333: l_PRICE_LIST_rec.attribute11 := NULL;
1334: END IF;
1335:
1336: IF l_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN

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

1332: IF l_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1333: l_PRICE_LIST_rec.attribute11 := NULL;
1334: END IF;
1335:
1336: IF l_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1337: l_PRICE_LIST_rec.attribute12 := NULL;
1338: END IF;
1339:
1340: IF l_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN

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

1336: IF l_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1337: l_PRICE_LIST_rec.attribute12 := NULL;
1338: END IF;
1339:
1340: IF l_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1341: l_PRICE_LIST_rec.attribute13 := NULL;
1342: END IF;
1343:
1344: IF l_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN

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

1340: IF l_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1341: l_PRICE_LIST_rec.attribute13 := NULL;
1342: END IF;
1343:
1344: IF l_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1345: l_PRICE_LIST_rec.attribute14 := NULL;
1346: END IF;
1347:
1348: IF l_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN

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

1344: IF l_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1345: l_PRICE_LIST_rec.attribute14 := NULL;
1346: END IF;
1347:
1348: IF l_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1349: l_PRICE_LIST_rec.attribute15 := NULL;
1350: END IF;
1351:
1352: IF l_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN

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

1348: IF l_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1349: l_PRICE_LIST_rec.attribute15 := NULL;
1350: END IF;
1351:
1352: IF l_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1353: l_PRICE_LIST_rec.attribute2 := NULL;
1354: END IF;
1355:
1356: IF l_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN

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

1352: IF l_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1353: l_PRICE_LIST_rec.attribute2 := NULL;
1354: END IF;
1355:
1356: IF l_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1357: l_PRICE_LIST_rec.attribute3 := NULL;
1358: END IF;
1359:
1360: IF l_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN

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

1356: IF l_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1357: l_PRICE_LIST_rec.attribute3 := NULL;
1358: END IF;
1359:
1360: IF l_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1361: l_PRICE_LIST_rec.attribute4 := NULL;
1362: END IF;
1363:
1364: IF l_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN

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

1360: IF l_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1361: l_PRICE_LIST_rec.attribute4 := NULL;
1362: END IF;
1363:
1364: IF l_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1365: l_PRICE_LIST_rec.attribute5 := NULL;
1366: END IF;
1367:
1368: IF l_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN

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

1364: IF l_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1365: l_PRICE_LIST_rec.attribute5 := NULL;
1366: END IF;
1367:
1368: IF l_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1369: l_PRICE_LIST_rec.attribute6 := NULL;
1370: END IF;
1371:
1372: IF l_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN

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

1368: IF l_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1369: l_PRICE_LIST_rec.attribute6 := NULL;
1370: END IF;
1371:
1372: IF l_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1373: l_PRICE_LIST_rec.attribute7 := NULL;
1374: END IF;
1375:
1376: IF l_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN

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

1372: IF l_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1373: l_PRICE_LIST_rec.attribute7 := NULL;
1374: END IF;
1375:
1376: IF l_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1377: l_PRICE_LIST_rec.attribute8 := NULL;
1378: END IF;
1379:
1380: IF l_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN

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

1376: IF l_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1377: l_PRICE_LIST_rec.attribute8 := NULL;
1378: END IF;
1379:
1380: IF l_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1381: l_PRICE_LIST_rec.attribute9 := NULL;
1382: END IF;
1383:
1384: IF l_PRICE_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN

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

1380: IF l_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1381: l_PRICE_LIST_rec.attribute9 := NULL;
1382: END IF;
1383:
1384: IF l_PRICE_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1385: l_PRICE_LIST_rec.automatic_flag := NULL;
1386: END IF;
1387:
1388: IF l_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR THEN

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

1384: IF l_PRICE_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1385: l_PRICE_LIST_rec.automatic_flag := NULL;
1386: END IF;
1387:
1388: IF l_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR THEN
1389: l_PRICE_LIST_rec.comments := NULL;
1390: END IF;
1391:
1392: IF l_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR THEN

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

1388: IF l_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR THEN
1389: l_PRICE_LIST_rec.comments := NULL;
1390: END IF;
1391:
1392: IF l_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR THEN
1393: l_PRICE_LIST_rec.context := NULL;
1394: END IF;
1395:
1396: IF l_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM THEN

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

1392: IF l_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR THEN
1393: l_PRICE_LIST_rec.context := NULL;
1394: END IF;
1395:
1396: IF l_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM THEN
1397: l_PRICE_LIST_rec.created_by := NULL;
1398: END IF;
1399:
1400: IF l_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN

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

1396: IF l_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM THEN
1397: l_PRICE_LIST_rec.created_by := NULL;
1398: END IF;
1399:
1400: IF l_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN
1401: l_PRICE_LIST_rec.creation_date := NULL;
1402: END IF;
1403:
1404: IF l_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN

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

1400: IF l_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN
1401: l_PRICE_LIST_rec.creation_date := NULL;
1402: END IF;
1403:
1404: IF l_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN
1405: l_PRICE_LIST_rec.currency_code := NULL;
1406: END IF;
1407:
1408: IF l_PRICE_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN

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

1404: IF l_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN
1405: l_PRICE_LIST_rec.currency_code := NULL;
1406: END IF;
1407:
1408: IF l_PRICE_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN
1409: l_PRICE_LIST_rec.discount_lines_flag := NULL;
1410: END IF;
1411:
1412: IF l_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN

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

1408: IF l_PRICE_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN
1409: l_PRICE_LIST_rec.discount_lines_flag := NULL;
1410: END IF;
1411:
1412: IF l_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN
1413: l_PRICE_LIST_rec.end_date_active := NULL;
1414: END IF;
1415:
1416: IF l_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN

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

1412: IF l_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN
1413: l_PRICE_LIST_rec.end_date_active := NULL;
1414: END IF;
1415:
1416: IF l_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
1417: l_PRICE_LIST_rec.freight_terms_code := NULL;
1418: END IF;
1419:
1420: IF l_PRICE_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR THEN

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

1416: IF l_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
1417: l_PRICE_LIST_rec.freight_terms_code := NULL;
1418: END IF;
1419:
1420: IF l_PRICE_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR THEN
1421: l_PRICE_LIST_rec.gsa_indicator := NULL;
1422: END IF;
1423:
1424: IF l_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN

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

1420: IF l_PRICE_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR THEN
1421: l_PRICE_LIST_rec.gsa_indicator := NULL;
1422: END IF;
1423:
1424: IF l_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1425: l_PRICE_LIST_rec.last_updated_by := NULL;
1426: END IF;
1427:
1428: IF l_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN

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

1424: IF l_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1425: l_PRICE_LIST_rec.last_updated_by := NULL;
1426: END IF;
1427:
1428: IF l_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN
1429: l_PRICE_LIST_rec.last_update_date := NULL;
1430: END IF;
1431:
1432: IF l_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN

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

1428: IF l_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN
1429: l_PRICE_LIST_rec.last_update_date := NULL;
1430: END IF;
1431:
1432: IF l_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN
1433: l_PRICE_LIST_rec.last_update_login := NULL;
1434: END IF;
1435:
1436: IF l_PRICE_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN

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

1432: IF l_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN
1433: l_PRICE_LIST_rec.last_update_login := NULL;
1434: END IF;
1435:
1436: IF l_PRICE_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN
1437: l_PRICE_LIST_rec.list_header_id := NULL;
1438: END IF;
1439:
1440: IF l_PRICE_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN

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

1436: IF l_PRICE_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN
1437: l_PRICE_LIST_rec.list_header_id := NULL;
1438: END IF;
1439:
1440: IF l_PRICE_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN
1441: l_PRICE_LIST_rec.list_type_code := NULL;
1442: END IF;
1443:
1444: IF l_PRICE_LIST_rec.version_no = FND_API.G_MISS_CHAR THEN

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

1440: IF l_PRICE_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN
1441: l_PRICE_LIST_rec.list_type_code := NULL;
1442: END IF;
1443:
1444: IF l_PRICE_LIST_rec.version_no = FND_API.G_MISS_CHAR THEN
1445: l_PRICE_LIST_rec.version_no := NULL;
1446: END IF;
1447:
1448: IF l_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN

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

1444: IF l_PRICE_LIST_rec.version_no = FND_API.G_MISS_CHAR THEN
1445: l_PRICE_LIST_rec.version_no := NULL;
1446: END IF;
1447:
1448: IF l_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN
1449: l_PRICE_LIST_rec.program_application_id := NULL;
1450: END IF;
1451:
1452: IF l_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM THEN

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

1448: IF l_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN
1449: l_PRICE_LIST_rec.program_application_id := NULL;
1450: END IF;
1451:
1452: IF l_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM THEN
1453: l_PRICE_LIST_rec.program_id := NULL;
1454: END IF;
1455:
1456: IF l_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN

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

1452: IF l_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM THEN
1453: l_PRICE_LIST_rec.program_id := NULL;
1454: END IF;
1455:
1456: IF l_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN
1457: l_PRICE_LIST_rec.program_update_date := NULL;
1458: END IF;
1459:
1460: IF l_PRICE_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN

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

1456: IF l_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN
1457: l_PRICE_LIST_rec.program_update_date := NULL;
1458: END IF;
1459:
1460: IF l_PRICE_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN
1461: l_PRICE_LIST_rec.prorate_flag := NULL;
1462: END IF;
1463:
1464: IF l_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM THEN

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

1460: IF l_PRICE_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN
1461: l_PRICE_LIST_rec.prorate_flag := NULL;
1462: END IF;
1463:
1464: IF l_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM THEN
1465: l_PRICE_LIST_rec.request_id := NULL;
1466: END IF;
1467:
1468: IF l_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN

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

1464: IF l_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM THEN
1465: l_PRICE_LIST_rec.request_id := NULL;
1466: END IF;
1467:
1468: IF l_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN
1469: l_PRICE_LIST_rec.rounding_factor := NULL;
1470: END IF;
1471:
1472: IF l_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN

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

1468: IF l_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN
1469: l_PRICE_LIST_rec.rounding_factor := NULL;
1470: END IF;
1471:
1472: IF l_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
1473: l_PRICE_LIST_rec.ship_method_code := NULL;
1474: END IF;
1475:
1476: IF l_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN

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

1472: IF l_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
1473: l_PRICE_LIST_rec.ship_method_code := NULL;
1474: END IF;
1475:
1476: IF l_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN
1477: l_PRICE_LIST_rec.start_date_active := NULL;
1478: END IF;
1479:
1480: IF l_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN

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

1476: IF l_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN
1477: l_PRICE_LIST_rec.start_date_active := NULL;
1478: END IF;
1479:
1480: IF l_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN
1481: l_PRICE_LIST_rec.terms_id := NULL;
1482: END IF;
1483:
1484: IF l_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR THEN

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

1480: IF l_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN
1481: l_PRICE_LIST_rec.terms_id := NULL;
1482: END IF;
1483:
1484: IF l_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR THEN
1485: l_PRICE_LIST_rec.name := NULL;
1486: END IF;
1487:
1488: IF l_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR THEN

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

1484: IF l_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR THEN
1485: l_PRICE_LIST_rec.name := NULL;
1486: END IF;
1487:
1488: IF l_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR THEN
1489: l_PRICE_LIST_rec.description := NULL;
1490: END IF;
1491:
1492: IF l_PRICE_LIST_rec.locked_from_list_header_id = FND_API.G_MISS_NUM THEN

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

1488: IF l_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR THEN
1489: l_PRICE_LIST_rec.description := NULL;
1490: END IF;
1491:
1492: IF l_PRICE_LIST_rec.locked_from_list_header_id = FND_API.G_MISS_NUM THEN
1493: l_PRICE_LIST_rec.locked_from_list_header_id := NULL;
1494: END IF;
1495:
1496: RETURN l_PRICE_LIST_rec;

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

1553: , START_DATE_ACTIVE = trunc(p_PRICE_LIST_rec.start_date_active)
1554: , TERMS_ID = p_PRICE_LIST_rec.terms_id
1555: , ASK_FOR_FLAG = 'N'
1556: , ACTIVE_FLAG =
1557: decode(p_PRICE_LIST_rec.active_flag, FND_API.G_MISS_CHAR, ACTIVE_FLAG, --dhgupta for 2052900
1558: p_PRICE_LIST_rec.active_flag)
1559: , MOBILE_DOWNLOAD =
1560: decode(p_PRICE_LIST_rec.mobile_download, FND_API.G_MISS_CHAR, MOBILE_DOWNLOAD,--dhgupta for 2052900
1561: p_PRICE_LIST_rec.mobile_download) -- mkarya for bug 1944882

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

1556: , ACTIVE_FLAG =
1557: decode(p_PRICE_LIST_rec.active_flag, FND_API.G_MISS_CHAR, ACTIVE_FLAG, --dhgupta for 2052900
1558: p_PRICE_LIST_rec.active_flag)
1559: , MOBILE_DOWNLOAD =
1560: decode(p_PRICE_LIST_rec.mobile_download, FND_API.G_MISS_CHAR, MOBILE_DOWNLOAD,--dhgupta for 2052900
1561: p_PRICE_LIST_rec.mobile_download) -- mkarya for bug 1944882
1562: , CURRENCY_HEADER_ID = p_PRICE_LIST_rec.currency_header_id
1563: , PTE_CODE = p_PRICE_LIST_rec.pte_code -- Giri for Attributes Manager
1564: , LIST_SOURCE_CODE = p_PRICE_LIST_rec.list_source_code --Blanket Sales Order

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

1563: , PTE_CODE = p_PRICE_LIST_rec.pte_code -- Giri for Attributes Manager
1564: , LIST_SOURCE_CODE = p_PRICE_LIST_rec.list_source_code --Blanket Sales Order
1565: , ORIG_SYSTEM_HEADER_REF = p_PRICE_LIST_rec.orig_system_header_ref --Blanket Sales Order
1566: , GLOBAL_FLAG =
1567: decode(p_PRICE_LIST_rec.global_flag, FND_API.G_MISS_CHAR, GLOBAL_FLAG,
1568: p_PRICE_LIST_rec.global_flag) -- Pricing Security gtippire
1569: , SOURCE_SYSTEM_CODE = p_PRICE_LIST_rec.source_system_code
1570: , SHAREABLE_FLAG = p_PRICE_LIST_rec.shareable_flag
1571: , SOLD_TO_ORG_ID = p_PRICE_LIST_rec.sold_to_org_id

Line 1608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1604: , 'Update_Row'
1605: );
1606: END IF;
1607:
1608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1609:
1610: END Update_Row;
1611:
1612: -- Procedure Insert_Row

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

1726: , p_PRICE_LIST_rec.terms_id
1727: , 'N' /* ask_for_flag */
1728: -- , l_source_system_code
1729: , p_PRICE_LIST_rec.source_system_code
1730: , decode(p_PRICE_LIST_rec.active_flag, FND_API.G_MISS_CHAR, 'Y',
1731: p_PRICE_LIST_rec.active_flag)
1732: , decode(p_PRICE_LIST_rec.mobile_download, FND_API.G_MISS_CHAR, 'N',
1733: p_PRICE_LIST_rec.mobile_download) -- mkarya for bug 1944882
1734: , p_PRICE_LIST_rec.currency_header_id

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

1728: -- , l_source_system_code
1729: , p_PRICE_LIST_rec.source_system_code
1730: , decode(p_PRICE_LIST_rec.active_flag, FND_API.G_MISS_CHAR, 'Y',
1731: p_PRICE_LIST_rec.active_flag)
1732: , decode(p_PRICE_LIST_rec.mobile_download, FND_API.G_MISS_CHAR, 'N',
1733: p_PRICE_LIST_rec.mobile_download) -- mkarya for bug 1944882
1734: , p_PRICE_LIST_rec.currency_header_id
1735: , p_PRICE_LIST_rec.pte_code -- Giri for Attributes Manager
1736: , p_PRICE_LIST_rec.list_source_code -- Blanket Sales Order

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

1735: , p_PRICE_LIST_rec.pte_code -- Giri for Attributes Manager
1736: , p_PRICE_LIST_rec.list_source_code -- Blanket Sales Order
1737: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1738: , 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
1739: , decode(p_PRICE_LIST_rec.global_flag, FND_API.G_MISS_CHAR, 'N',
1740: p_PRICE_LIST_rec.global_flag) -- Pricing Security gtippire
1741: --added for MOAC
1742: , p_PRICE_LIST_rec.org_id
1743: , p_PRICE_LIST_rec.shareable_flag

Line 1802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1798: , 'Insert_Row'
1799: );
1800: END IF;
1801:
1802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1803:
1804: END Insert_Row;
1805:
1806: -- Procedure Delete_Row

Line 1860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1856: , 'Delete_Row'
1857: );
1858: END IF;
1859:
1860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1861:
1862: END Delete_Row;
1863:
1864: -- Function Query_Row

Line 2006: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2002: , 'Query_Row'
2003: );
2004: END IF;
2005:
2006: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2007:
2008: END Query_Row;
2009:
2010: -- Procedure lock_Row

Line 2257: x_return_status := FND_API.G_RET_STS_SUCCESS;

2253: x_PRICE_LIST_rec := l_PRICE_LIST_rec;
2254:
2255: -- Set return status
2256:
2257: x_return_status := FND_API.G_RET_STS_SUCCESS;
2258: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2259:
2260: oe_debug_pub.add('success 1');
2261:

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

2254:
2255: -- Set return status
2256:
2257: x_return_status := FND_API.G_RET_STS_SUCCESS;
2258: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2259:
2260: oe_debug_pub.add('success 1');
2261:
2262: ELSE

Line 2330: x_return_status := FND_API.G_RET_STS_ERROR;

2326: oe_debug_pub.add('DB Value: OSHR'||l_PRICE_LIST_rec.orig_system_header_ref);
2327: end if;
2328: oe_debug_pub.add('failed 1');
2329:
2330: x_return_status := FND_API.G_RET_STS_ERROR;
2331: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2332:
2333: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2334: THEN

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

2327: end if;
2328: oe_debug_pub.add('failed 1');
2329:
2330: x_return_status := FND_API.G_RET_STS_ERROR;
2331: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2332:
2333: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2334: THEN
2335:

Line 2378: x_return_status := FND_API.G_RET_STS_ERROR;

2374: EXCEPTION
2375:
2376: WHEN NO_DATA_FOUND THEN
2377:
2378: x_return_status := FND_API.G_RET_STS_ERROR;
2379: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2380:
2381: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2382: THEN

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

2375:
2376: WHEN NO_DATA_FOUND THEN
2377:
2378: x_return_status := FND_API.G_RET_STS_ERROR;
2379: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2380:
2381: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2382: THEN
2383:

Line 2390: x_return_status := FND_API.G_RET_STS_ERROR;

2386:
2387: END IF;
2388: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2389:
2390: x_return_status := FND_API.G_RET_STS_ERROR;
2391: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2392:
2393: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2394: THEN

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

2387: END IF;
2388: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2389:
2390: x_return_status := FND_API.G_RET_STS_ERROR;
2391: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2392:
2393: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2394: THEN
2395:

Line 2402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2398:
2399: END IF;
2400: WHEN OTHERS THEN
2401:
2402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2403: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2404:
2405: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2406: THEN

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

2399: END IF;
2400: WHEN OTHERS THEN
2401:
2402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2403: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2404:
2405: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2406: THEN
2407: oe_msg_pub.Add_Exc_Msg

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

2423: l_PRICE_LIST_val_rec QP_Price_List_PUB.Price_List_Val_Rec_Type;
2424: BEGIN
2425:
2426: IF p_PRICE_LIST_rec.automatic_flag IS NOT NULL AND
2427: p_PRICE_LIST_rec.automatic_flag <> FND_API.G_MISS_CHAR AND
2428: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.automatic_flag,
2429: p_old_PRICE_LIST_rec.automatic_flag)
2430: THEN
2431: l_PRICE_LIST_val_rec.automatic := QP_Id_To_Value.Automatic

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

2433: );
2434: END IF;
2435:
2436: IF p_PRICE_LIST_rec.currency_code IS NOT NULL AND
2437: p_PRICE_LIST_rec.currency_code <> FND_API.G_MISS_CHAR AND
2438: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_code,
2439: p_old_PRICE_LIST_rec.currency_code)
2440: THEN
2441: l_PRICE_LIST_val_rec.currency := QP_Id_To_Value.Currency

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

2443: );
2444: END IF;
2445:
2446: IF p_PRICE_LIST_rec.discount_lines_flag IS NOT NULL AND
2447: p_PRICE_LIST_rec.discount_lines_flag <> FND_API.G_MISS_CHAR AND
2448: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.discount_lines_flag,
2449: p_old_PRICE_LIST_rec.discount_lines_flag)
2450: THEN
2451: l_PRICE_LIST_val_rec.discount_lines := QP_Id_To_Value.Discount_Lines

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

2453: );
2454: END IF;
2455:
2456: IF p_PRICE_LIST_rec.freight_terms_code IS NOT NULL AND
2457: p_PRICE_LIST_rec.freight_terms_code <> FND_API.G_MISS_CHAR AND
2458: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.freight_terms_code,
2459: p_old_PRICE_LIST_rec.freight_terms_code)
2460: THEN
2461: l_PRICE_LIST_val_rec.freight_terms := QP_Id_To_Value.Freight_Terms

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

2463: );
2464: END IF;
2465:
2466: IF p_PRICE_LIST_rec.list_header_id IS NOT NULL AND
2467: p_PRICE_LIST_rec.list_header_id <> FND_API.G_MISS_NUM AND
2468: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_header_id,
2469: p_old_PRICE_LIST_rec.list_header_id)
2470: THEN
2471: l_PRICE_LIST_val_rec.list_header := QP_Id_To_Value.List_Header

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

2473: );
2474: END IF;
2475:
2476: IF p_PRICE_LIST_rec.list_type_code IS NOT NULL AND
2477: p_PRICE_LIST_rec.list_type_code <> FND_API.G_MISS_CHAR AND
2478: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_type_code,
2479: p_old_PRICE_LIST_rec.list_type_code)
2480: THEN
2481: l_PRICE_LIST_val_rec.list_type := QP_Id_To_Value.List_Type

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

2483: );
2484: END IF;
2485:
2486: IF p_PRICE_LIST_rec.prorate_flag IS NOT NULL AND
2487: p_PRICE_LIST_rec.prorate_flag <> FND_API.G_MISS_CHAR AND
2488: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.prorate_flag,
2489: p_old_PRICE_LIST_rec.prorate_flag)
2490: THEN
2491: l_PRICE_LIST_val_rec.prorate := QP_Id_To_Value.Prorate

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

2493: );
2494: END IF;
2495:
2496: IF p_PRICE_LIST_rec.ship_method_code IS NOT NULL AND
2497: p_PRICE_LIST_rec.ship_method_code <> FND_API.G_MISS_CHAR AND
2498: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.ship_method_code,
2499: p_old_PRICE_LIST_rec.ship_method_code)
2500: THEN
2501: l_PRICE_LIST_val_rec.ship_method := QP_Id_To_Value.Ship_Method

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

2503: );
2504: END IF;
2505:
2506: IF p_PRICE_LIST_rec.terms_id IS NOT NULL AND
2507: p_PRICE_LIST_rec.terms_id <> FND_API.G_MISS_NUM AND
2508: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.terms_id,
2509: p_old_PRICE_LIST_rec.terms_id)
2510: THEN
2511: l_PRICE_LIST_val_rec.terms := QP_Id_To_Value.Terms

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

2528: BEGIN
2529:
2530: -- initialize return_status.
2531:
2532: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2533:
2534: -- initialize l_PRICE_LIST_rec.
2535:
2536: l_PRICE_LIST_rec := p_PRICE_LIST_rec;

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

2534: -- initialize l_PRICE_LIST_rec.
2535:
2536: l_PRICE_LIST_rec := p_PRICE_LIST_rec;
2537:
2538: IF p_PRICE_LIST_val_rec.automatic <> FND_API.G_MISS_CHAR
2539: THEN
2540:
2541: IF p_PRICE_LIST_rec.automatic_flag <> FND_API.G_MISS_CHAR THEN
2542:

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

2537:
2538: IF p_PRICE_LIST_val_rec.automatic <> FND_API.G_MISS_CHAR
2539: THEN
2540:
2541: IF p_PRICE_LIST_rec.automatic_flag <> FND_API.G_MISS_CHAR THEN
2542:
2543: l_PRICE_LIST_rec.automatic_flag := p_PRICE_LIST_rec.automatic_flag;
2544:
2545: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

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

2556: l_PRICE_LIST_rec.automatic_flag := QP_Value_To_Id.automatic
2557: ( p_automatic => p_PRICE_LIST_val_rec.automatic
2558: );
2559:
2560: IF l_PRICE_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
2561: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2562: END IF;
2563:
2564: END IF;

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

2557: ( p_automatic => p_PRICE_LIST_val_rec.automatic
2558: );
2559:
2560: IF l_PRICE_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
2561: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2562: END IF;
2563:
2564: END IF;
2565:

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

2564: END IF;
2565:
2566: END IF;
2567:
2568: IF p_PRICE_LIST_val_rec.currency <> FND_API.G_MISS_CHAR
2569: THEN
2570:
2571: IF p_PRICE_LIST_rec.currency_code <> FND_API.G_MISS_CHAR THEN
2572:

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

2567:
2568: IF p_PRICE_LIST_val_rec.currency <> FND_API.G_MISS_CHAR
2569: THEN
2570:
2571: IF p_PRICE_LIST_rec.currency_code <> FND_API.G_MISS_CHAR THEN
2572:
2573: l_PRICE_LIST_rec.currency_code := p_PRICE_LIST_rec.currency_code;
2574:
2575: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

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

2586: l_PRICE_LIST_rec.currency_code := QP_Value_To_Id.currency
2587: ( p_currency => p_PRICE_LIST_val_rec.currency
2588: );
2589:
2590: IF l_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN
2591: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2592: END IF;
2593:
2594: END IF;

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

2587: ( p_currency => p_PRICE_LIST_val_rec.currency
2588: );
2589:
2590: IF l_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN
2591: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2592: END IF;
2593:
2594: END IF;
2595:

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

2594: END IF;
2595:
2596: END IF;
2597:
2598: IF p_PRICE_LIST_val_rec.discount_lines <> FND_API.G_MISS_CHAR
2599: THEN
2600:
2601: IF p_PRICE_LIST_rec.discount_lines_flag <> FND_API.G_MISS_CHAR THEN
2602:

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

2597:
2598: IF p_PRICE_LIST_val_rec.discount_lines <> FND_API.G_MISS_CHAR
2599: THEN
2600:
2601: IF p_PRICE_LIST_rec.discount_lines_flag <> FND_API.G_MISS_CHAR THEN
2602:
2603: l_PRICE_LIST_rec.discount_lines_flag := p_PRICE_LIST_rec.discount_lines_flag;
2604:
2605: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

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

2616: l_PRICE_LIST_rec.discount_lines_flag := QP_Value_To_Id.discount_lines
2617: ( p_discount_lines => p_PRICE_LIST_val_rec.discount_lines
2618: );
2619:
2620: IF l_PRICE_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN
2621: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2622: END IF;
2623:
2624: END IF;

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

2617: ( p_discount_lines => p_PRICE_LIST_val_rec.discount_lines
2618: );
2619:
2620: IF l_PRICE_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN
2621: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2622: END IF;
2623:
2624: END IF;
2625:

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

2624: END IF;
2625:
2626: END IF;
2627:
2628: IF p_PRICE_LIST_val_rec.freight_terms <> FND_API.G_MISS_CHAR
2629: THEN
2630:
2631: IF p_PRICE_LIST_rec.freight_terms_code <> FND_API.G_MISS_CHAR THEN
2632:

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

2627:
2628: IF p_PRICE_LIST_val_rec.freight_terms <> FND_API.G_MISS_CHAR
2629: THEN
2630:
2631: IF p_PRICE_LIST_rec.freight_terms_code <> FND_API.G_MISS_CHAR THEN
2632:
2633: l_PRICE_LIST_rec.freight_terms_code := p_PRICE_LIST_rec.freight_terms_code;
2634:
2635: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

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

2646: l_PRICE_LIST_rec.freight_terms_code := QP_Value_To_Id.freight_terms
2647: ( p_freight_terms => p_PRICE_LIST_val_rec.freight_terms
2648: );
2649:
2650: IF l_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
2651: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2652: END IF;
2653:
2654: END IF;

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

2647: ( p_freight_terms => p_PRICE_LIST_val_rec.freight_terms
2648: );
2649:
2650: IF l_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
2651: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2652: END IF;
2653:
2654: END IF;
2655:

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

2654: END IF;
2655:
2656: END IF;
2657:
2658: IF p_PRICE_LIST_val_rec.list_header <> FND_API.G_MISS_CHAR
2659: THEN
2660:
2661: IF p_PRICE_LIST_rec.list_header_id <> FND_API.G_MISS_NUM THEN
2662:

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

2657:
2658: IF p_PRICE_LIST_val_rec.list_header <> FND_API.G_MISS_CHAR
2659: THEN
2660:
2661: IF p_PRICE_LIST_rec.list_header_id <> FND_API.G_MISS_NUM THEN
2662:
2663: l_PRICE_LIST_rec.list_header_id := p_PRICE_LIST_rec.list_header_id;
2664:
2665: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

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

2676: l_PRICE_LIST_rec.list_header_id := QP_Value_To_Id.list_header
2677: ( p_list_header => p_PRICE_LIST_val_rec.list_header
2678: );
2679:
2680: IF l_PRICE_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN
2681: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2682: END IF;
2683:
2684: END IF;

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

2677: ( p_list_header => p_PRICE_LIST_val_rec.list_header
2678: );
2679:
2680: IF l_PRICE_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN
2681: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2682: END IF;
2683:
2684: END IF;
2685:

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

2684: END IF;
2685:
2686: END IF;
2687:
2688: IF p_PRICE_LIST_val_rec.list_type <> FND_API.G_MISS_CHAR
2689: THEN
2690:
2691: IF p_PRICE_LIST_rec.list_type_code <> FND_API.G_MISS_CHAR THEN
2692:

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

2687:
2688: IF p_PRICE_LIST_val_rec.list_type <> FND_API.G_MISS_CHAR
2689: THEN
2690:
2691: IF p_PRICE_LIST_rec.list_type_code <> FND_API.G_MISS_CHAR THEN
2692:
2693: l_PRICE_LIST_rec.list_type_code := p_PRICE_LIST_rec.list_type_code;
2694:
2695: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

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

2706: l_PRICE_LIST_rec.list_type_code := QP_Value_To_Id.list_type
2707: ( p_list_type => p_PRICE_LIST_val_rec.list_type
2708: );
2709:
2710: IF l_PRICE_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN
2711: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2712: END IF;
2713:
2714: END IF;

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

2707: ( p_list_type => p_PRICE_LIST_val_rec.list_type
2708: );
2709:
2710: IF l_PRICE_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN
2711: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2712: END IF;
2713:
2714: END IF;
2715:

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

2714: END IF;
2715:
2716: END IF;
2717:
2718: IF p_PRICE_LIST_val_rec.prorate <> FND_API.G_MISS_CHAR
2719: THEN
2720:
2721: IF p_PRICE_LIST_rec.prorate_flag <> FND_API.G_MISS_CHAR THEN
2722:

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

2717:
2718: IF p_PRICE_LIST_val_rec.prorate <> FND_API.G_MISS_CHAR
2719: THEN
2720:
2721: IF p_PRICE_LIST_rec.prorate_flag <> FND_API.G_MISS_CHAR THEN
2722:
2723: l_PRICE_LIST_rec.prorate_flag := p_PRICE_LIST_rec.prorate_flag;
2724:
2725: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

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

2736: l_PRICE_LIST_rec.prorate_flag := QP_Value_To_Id.prorate
2737: ( p_prorate => p_PRICE_LIST_val_rec.prorate
2738: );
2739:
2740: IF l_PRICE_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN
2741: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2742: END IF;
2743:
2744: END IF;

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

2737: ( p_prorate => p_PRICE_LIST_val_rec.prorate
2738: );
2739:
2740: IF l_PRICE_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN
2741: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2742: END IF;
2743:
2744: END IF;
2745:

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

2744: END IF;
2745:
2746: END IF;
2747:
2748: IF p_PRICE_LIST_val_rec.ship_method <> FND_API.G_MISS_CHAR
2749: THEN
2750:
2751: IF p_PRICE_LIST_rec.ship_method_code <> FND_API.G_MISS_CHAR THEN
2752:

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

2747:
2748: IF p_PRICE_LIST_val_rec.ship_method <> FND_API.G_MISS_CHAR
2749: THEN
2750:
2751: IF p_PRICE_LIST_rec.ship_method_code <> FND_API.G_MISS_CHAR THEN
2752:
2753: l_PRICE_LIST_rec.ship_method_code := p_PRICE_LIST_rec.ship_method_code;
2754:
2755: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

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

2766: l_PRICE_LIST_rec.ship_method_code := QP_Value_To_Id.ship_method
2767: ( p_ship_method => p_PRICE_LIST_val_rec.ship_method
2768: );
2769:
2770: IF l_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
2771: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2772: END IF;
2773:
2774: END IF;

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

2767: ( p_ship_method => p_PRICE_LIST_val_rec.ship_method
2768: );
2769:
2770: IF l_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
2771: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2772: END IF;
2773:
2774: END IF;
2775:

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

2774: END IF;
2775:
2776: END IF;
2777:
2778: IF p_PRICE_LIST_val_rec.terms <> FND_API.G_MISS_CHAR
2779: THEN
2780:
2781: IF p_PRICE_LIST_rec.terms_id <> FND_API.G_MISS_NUM THEN
2782:

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

2777:
2778: IF p_PRICE_LIST_val_rec.terms <> FND_API.G_MISS_CHAR
2779: THEN
2780:
2781: IF p_PRICE_LIST_rec.terms_id <> FND_API.G_MISS_NUM THEN
2782:
2783: l_PRICE_LIST_rec.terms_id := p_PRICE_LIST_rec.terms_id;
2784:
2785: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

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

2796: l_PRICE_LIST_rec.terms_id := QP_Value_To_Id.terms
2797: ( p_terms => p_PRICE_LIST_val_rec.terms
2798: );
2799:
2800: IF l_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN
2801: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2802: END IF;
2803:
2804: END IF;

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

2797: ( p_terms => p_PRICE_LIST_val_rec.terms
2798: );
2799:
2800: IF l_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN
2801: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2802: END IF;
2803:
2804: END IF;
2805: