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_MODIFIER_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_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
13: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
14: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
15: , x_MODIFIER_LIST_rec OUT NOCOPY QP_Modifiers_PUB.Modifier_List_Rec_Type

Line 33: IF p_attr_id = FND_API.G_MISS_NUM THEN

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

Line 1097: IF l_MODIFIER_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN

1093: BEGIN
1094:
1095: oe_debug_pub.add('BEGIN complete_record in QPXUMLHB');
1096:
1097: IF l_MODIFIER_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1098: l_MODIFIER_LIST_rec.attribute1 := p_old_MODIFIER_LIST_rec.attribute1;
1099: END IF;
1100:
1101: IF l_MODIFIER_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 1101: IF l_MODIFIER_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN

1097: IF l_MODIFIER_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1098: l_MODIFIER_LIST_rec.attribute1 := p_old_MODIFIER_LIST_rec.attribute1;
1099: END IF;
1100:
1101: IF l_MODIFIER_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1102: l_MODIFIER_LIST_rec.attribute10 := p_old_MODIFIER_LIST_rec.attribute10;
1103: END IF;
1104:
1105: IF l_MODIFIER_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 1105: IF l_MODIFIER_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN

1101: IF l_MODIFIER_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1102: l_MODIFIER_LIST_rec.attribute10 := p_old_MODIFIER_LIST_rec.attribute10;
1103: END IF;
1104:
1105: IF l_MODIFIER_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1106: l_MODIFIER_LIST_rec.attribute11 := p_old_MODIFIER_LIST_rec.attribute11;
1107: END IF;
1108:
1109: IF l_MODIFIER_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 1109: IF l_MODIFIER_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN

1105: IF l_MODIFIER_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1106: l_MODIFIER_LIST_rec.attribute11 := p_old_MODIFIER_LIST_rec.attribute11;
1107: END IF;
1108:
1109: IF l_MODIFIER_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1110: l_MODIFIER_LIST_rec.attribute12 := p_old_MODIFIER_LIST_rec.attribute12;
1111: END IF;
1112:
1113: IF l_MODIFIER_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 1113: IF l_MODIFIER_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN

1109: IF l_MODIFIER_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1110: l_MODIFIER_LIST_rec.attribute12 := p_old_MODIFIER_LIST_rec.attribute12;
1111: END IF;
1112:
1113: IF l_MODIFIER_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1114: l_MODIFIER_LIST_rec.attribute13 := p_old_MODIFIER_LIST_rec.attribute13;
1115: END IF;
1116:
1117: IF l_MODIFIER_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 1117: IF l_MODIFIER_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN

1113: IF l_MODIFIER_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1114: l_MODIFIER_LIST_rec.attribute13 := p_old_MODIFIER_LIST_rec.attribute13;
1115: END IF;
1116:
1117: IF l_MODIFIER_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1118: l_MODIFIER_LIST_rec.attribute14 := p_old_MODIFIER_LIST_rec.attribute14;
1119: END IF;
1120:
1121: IF l_MODIFIER_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 1121: IF l_MODIFIER_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN

1117: IF l_MODIFIER_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1118: l_MODIFIER_LIST_rec.attribute14 := p_old_MODIFIER_LIST_rec.attribute14;
1119: END IF;
1120:
1121: IF l_MODIFIER_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1122: l_MODIFIER_LIST_rec.attribute15 := p_old_MODIFIER_LIST_rec.attribute15;
1123: END IF;
1124:
1125: IF l_MODIFIER_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 1125: IF l_MODIFIER_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN

1121: IF l_MODIFIER_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1122: l_MODIFIER_LIST_rec.attribute15 := p_old_MODIFIER_LIST_rec.attribute15;
1123: END IF;
1124:
1125: IF l_MODIFIER_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1126: l_MODIFIER_LIST_rec.attribute2 := p_old_MODIFIER_LIST_rec.attribute2;
1127: END IF;
1128:
1129: IF l_MODIFIER_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 1129: IF l_MODIFIER_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN

1125: IF l_MODIFIER_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1126: l_MODIFIER_LIST_rec.attribute2 := p_old_MODIFIER_LIST_rec.attribute2;
1127: END IF;
1128:
1129: IF l_MODIFIER_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1130: l_MODIFIER_LIST_rec.attribute3 := p_old_MODIFIER_LIST_rec.attribute3;
1131: END IF;
1132:
1133: IF l_MODIFIER_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 1133: IF l_MODIFIER_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN

1129: IF l_MODIFIER_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1130: l_MODIFIER_LIST_rec.attribute3 := p_old_MODIFIER_LIST_rec.attribute3;
1131: END IF;
1132:
1133: IF l_MODIFIER_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1134: l_MODIFIER_LIST_rec.attribute4 := p_old_MODIFIER_LIST_rec.attribute4;
1135: END IF;
1136:
1137: IF l_MODIFIER_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 1137: IF l_MODIFIER_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN

1133: IF l_MODIFIER_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1134: l_MODIFIER_LIST_rec.attribute4 := p_old_MODIFIER_LIST_rec.attribute4;
1135: END IF;
1136:
1137: IF l_MODIFIER_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1138: l_MODIFIER_LIST_rec.attribute5 := p_old_MODIFIER_LIST_rec.attribute5;
1139: END IF;
1140:
1141: IF l_MODIFIER_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 1141: IF l_MODIFIER_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN

1137: IF l_MODIFIER_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1138: l_MODIFIER_LIST_rec.attribute5 := p_old_MODIFIER_LIST_rec.attribute5;
1139: END IF;
1140:
1141: IF l_MODIFIER_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1142: l_MODIFIER_LIST_rec.attribute6 := p_old_MODIFIER_LIST_rec.attribute6;
1143: END IF;
1144:
1145: IF l_MODIFIER_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 1145: IF l_MODIFIER_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN

1141: IF l_MODIFIER_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1142: l_MODIFIER_LIST_rec.attribute6 := p_old_MODIFIER_LIST_rec.attribute6;
1143: END IF;
1144:
1145: IF l_MODIFIER_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1146: l_MODIFIER_LIST_rec.attribute7 := p_old_MODIFIER_LIST_rec.attribute7;
1147: END IF;
1148:
1149: IF l_MODIFIER_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 1149: IF l_MODIFIER_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN

1145: IF l_MODIFIER_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1146: l_MODIFIER_LIST_rec.attribute7 := p_old_MODIFIER_LIST_rec.attribute7;
1147: END IF;
1148:
1149: IF l_MODIFIER_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1150: l_MODIFIER_LIST_rec.attribute8 := p_old_MODIFIER_LIST_rec.attribute8;
1151: END IF;
1152:
1153: IF l_MODIFIER_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 1153: IF l_MODIFIER_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN

1149: IF l_MODIFIER_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1150: l_MODIFIER_LIST_rec.attribute8 := p_old_MODIFIER_LIST_rec.attribute8;
1151: END IF;
1152:
1153: IF l_MODIFIER_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1154: l_MODIFIER_LIST_rec.attribute9 := p_old_MODIFIER_LIST_rec.attribute9;
1155: END IF;
1156:
1157: IF l_MODIFIER_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN

Line 1157: IF l_MODIFIER_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN

1153: IF l_MODIFIER_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1154: l_MODIFIER_LIST_rec.attribute9 := p_old_MODIFIER_LIST_rec.attribute9;
1155: END IF;
1156:
1157: IF l_MODIFIER_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1158: l_MODIFIER_LIST_rec.automatic_flag := p_old_MODIFIER_LIST_rec.automatic_flag;
1159: END IF;
1160:
1161: IF l_MODIFIER_LIST_rec.comments = FND_API.G_MISS_CHAR THEN

Line 1161: IF l_MODIFIER_LIST_rec.comments = FND_API.G_MISS_CHAR THEN

1157: IF l_MODIFIER_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1158: l_MODIFIER_LIST_rec.automatic_flag := p_old_MODIFIER_LIST_rec.automatic_flag;
1159: END IF;
1160:
1161: IF l_MODIFIER_LIST_rec.comments = FND_API.G_MISS_CHAR THEN
1162: l_MODIFIER_LIST_rec.comments := p_old_MODIFIER_LIST_rec.comments;
1163: END IF;
1164:
1165: IF l_MODIFIER_LIST_rec.context = FND_API.G_MISS_CHAR THEN

Line 1165: IF l_MODIFIER_LIST_rec.context = FND_API.G_MISS_CHAR THEN

1161: IF l_MODIFIER_LIST_rec.comments = FND_API.G_MISS_CHAR THEN
1162: l_MODIFIER_LIST_rec.comments := p_old_MODIFIER_LIST_rec.comments;
1163: END IF;
1164:
1165: IF l_MODIFIER_LIST_rec.context = FND_API.G_MISS_CHAR THEN
1166: l_MODIFIER_LIST_rec.context := p_old_MODIFIER_LIST_rec.context;
1167: END IF;
1168:
1169: IF l_MODIFIER_LIST_rec.created_by = FND_API.G_MISS_NUM THEN

Line 1169: IF l_MODIFIER_LIST_rec.created_by = FND_API.G_MISS_NUM THEN

1165: IF l_MODIFIER_LIST_rec.context = FND_API.G_MISS_CHAR THEN
1166: l_MODIFIER_LIST_rec.context := p_old_MODIFIER_LIST_rec.context;
1167: END IF;
1168:
1169: IF l_MODIFIER_LIST_rec.created_by = FND_API.G_MISS_NUM THEN
1170: l_MODIFIER_LIST_rec.created_by := p_old_MODIFIER_LIST_rec.created_by;
1171: END IF;
1172:
1173: IF l_MODIFIER_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 1173: IF l_MODIFIER_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN

1169: IF l_MODIFIER_LIST_rec.created_by = FND_API.G_MISS_NUM THEN
1170: l_MODIFIER_LIST_rec.created_by := p_old_MODIFIER_LIST_rec.created_by;
1171: END IF;
1172:
1173: IF l_MODIFIER_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN
1174: l_MODIFIER_LIST_rec.creation_date := p_old_MODIFIER_LIST_rec.creation_date;
1175: END IF;
1176:
1177: IF l_MODIFIER_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN

Line 1177: IF l_MODIFIER_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN

1173: IF l_MODIFIER_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN
1174: l_MODIFIER_LIST_rec.creation_date := p_old_MODIFIER_LIST_rec.creation_date;
1175: END IF;
1176:
1177: IF l_MODIFIER_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN
1178: l_MODIFIER_LIST_rec.currency_code := p_old_MODIFIER_LIST_rec.currency_code;
1179: END IF;
1180:
1181: IF l_MODIFIER_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN

Line 1181: IF l_MODIFIER_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN

1177: IF l_MODIFIER_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN
1178: l_MODIFIER_LIST_rec.currency_code := p_old_MODIFIER_LIST_rec.currency_code;
1179: END IF;
1180:
1181: IF l_MODIFIER_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN
1182: l_MODIFIER_LIST_rec.discount_lines_flag := p_old_MODIFIER_LIST_rec.discount_lines_flag;
1183: END IF;
1184:
1185: IF l_MODIFIER_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN

Line 1185: IF l_MODIFIER_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN

1181: IF l_MODIFIER_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN
1182: l_MODIFIER_LIST_rec.discount_lines_flag := p_old_MODIFIER_LIST_rec.discount_lines_flag;
1183: END IF;
1184:
1185: IF l_MODIFIER_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN
1186: l_MODIFIER_LIST_rec.end_date_active := p_old_MODIFIER_LIST_rec.end_date_active;
1187: END IF;
1188:
1189: IF l_MODIFIER_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN

Line 1189: IF l_MODIFIER_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN

1185: IF l_MODIFIER_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN
1186: l_MODIFIER_LIST_rec.end_date_active := p_old_MODIFIER_LIST_rec.end_date_active;
1187: END IF;
1188:
1189: IF l_MODIFIER_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
1190: l_MODIFIER_LIST_rec.freight_terms_code := p_old_MODIFIER_LIST_rec.freight_terms_code;
1191: END IF;
1192:
1193: IF l_MODIFIER_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR THEN

Line 1193: IF l_MODIFIER_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR THEN

1189: IF l_MODIFIER_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
1190: l_MODIFIER_LIST_rec.freight_terms_code := p_old_MODIFIER_LIST_rec.freight_terms_code;
1191: END IF;
1192:
1193: IF l_MODIFIER_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR THEN
1194: l_MODIFIER_LIST_rec.gsa_indicator := p_old_MODIFIER_LIST_rec.gsa_indicator;
1195: END IF;
1196:
1197: IF l_MODIFIER_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 1197: IF l_MODIFIER_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN

1193: IF l_MODIFIER_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR THEN
1194: l_MODIFIER_LIST_rec.gsa_indicator := p_old_MODIFIER_LIST_rec.gsa_indicator;
1195: END IF;
1196:
1197: IF l_MODIFIER_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1198: l_MODIFIER_LIST_rec.last_updated_by := p_old_MODIFIER_LIST_rec.last_updated_by;
1199: END IF;
1200:
1201: IF l_MODIFIER_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 1201: IF l_MODIFIER_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN

1197: IF l_MODIFIER_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1198: l_MODIFIER_LIST_rec.last_updated_by := p_old_MODIFIER_LIST_rec.last_updated_by;
1199: END IF;
1200:
1201: IF l_MODIFIER_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN
1202: l_MODIFIER_LIST_rec.last_update_date := p_old_MODIFIER_LIST_rec.last_update_date;
1203: END IF;
1204:
1205: IF l_MODIFIER_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 1205: IF l_MODIFIER_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN

1201: IF l_MODIFIER_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN
1202: l_MODIFIER_LIST_rec.last_update_date := p_old_MODIFIER_LIST_rec.last_update_date;
1203: END IF;
1204:
1205: IF l_MODIFIER_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN
1206: l_MODIFIER_LIST_rec.last_update_login := p_old_MODIFIER_LIST_rec.last_update_login;
1207: END IF;
1208:
1209: IF l_MODIFIER_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN

Line 1209: IF l_MODIFIER_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN

1205: IF l_MODIFIER_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN
1206: l_MODIFIER_LIST_rec.last_update_login := p_old_MODIFIER_LIST_rec.last_update_login;
1207: END IF;
1208:
1209: IF l_MODIFIER_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN
1210: l_MODIFIER_LIST_rec.list_header_id := p_old_MODIFIER_LIST_rec.list_header_id;
1211: END IF;
1212:
1213: IF l_MODIFIER_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN

Line 1213: IF l_MODIFIER_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN

1209: IF l_MODIFIER_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN
1210: l_MODIFIER_LIST_rec.list_header_id := p_old_MODIFIER_LIST_rec.list_header_id;
1211: END IF;
1212:
1213: IF l_MODIFIER_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN
1214: l_MODIFIER_LIST_rec.list_type_code := p_old_MODIFIER_LIST_rec.list_type_code;
1215: END IF;
1216:
1217: IF l_MODIFIER_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 1217: IF l_MODIFIER_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN

1213: IF l_MODIFIER_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN
1214: l_MODIFIER_LIST_rec.list_type_code := p_old_MODIFIER_LIST_rec.list_type_code;
1215: END IF;
1216:
1217: IF l_MODIFIER_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN
1218: l_MODIFIER_LIST_rec.program_application_id := p_old_MODIFIER_LIST_rec.program_application_id;
1219: END IF;
1220:
1221: IF l_MODIFIER_LIST_rec.program_id = FND_API.G_MISS_NUM THEN

Line 1221: IF l_MODIFIER_LIST_rec.program_id = FND_API.G_MISS_NUM THEN

1217: IF l_MODIFIER_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN
1218: l_MODIFIER_LIST_rec.program_application_id := p_old_MODIFIER_LIST_rec.program_application_id;
1219: END IF;
1220:
1221: IF l_MODIFIER_LIST_rec.program_id = FND_API.G_MISS_NUM THEN
1222: l_MODIFIER_LIST_rec.program_id := p_old_MODIFIER_LIST_rec.program_id;
1223: END IF;
1224:
1225: IF l_MODIFIER_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 1225: IF l_MODIFIER_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN

1221: IF l_MODIFIER_LIST_rec.program_id = FND_API.G_MISS_NUM THEN
1222: l_MODIFIER_LIST_rec.program_id := p_old_MODIFIER_LIST_rec.program_id;
1223: END IF;
1224:
1225: IF l_MODIFIER_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN
1226: l_MODIFIER_LIST_rec.program_update_date := p_old_MODIFIER_LIST_rec.program_update_date;
1227: END IF;
1228:
1229: IF l_MODIFIER_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN

Line 1229: IF l_MODIFIER_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN

1225: IF l_MODIFIER_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN
1226: l_MODIFIER_LIST_rec.program_update_date := p_old_MODIFIER_LIST_rec.program_update_date;
1227: END IF;
1228:
1229: IF l_MODIFIER_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN
1230: l_MODIFIER_LIST_rec.prorate_flag := p_old_MODIFIER_LIST_rec.prorate_flag;
1231: END IF;
1232:
1233: IF l_MODIFIER_LIST_rec.request_id = FND_API.G_MISS_NUM THEN

Line 1233: IF l_MODIFIER_LIST_rec.request_id = FND_API.G_MISS_NUM THEN

1229: IF l_MODIFIER_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN
1230: l_MODIFIER_LIST_rec.prorate_flag := p_old_MODIFIER_LIST_rec.prorate_flag;
1231: END IF;
1232:
1233: IF l_MODIFIER_LIST_rec.request_id = FND_API.G_MISS_NUM THEN
1234: l_MODIFIER_LIST_rec.request_id := p_old_MODIFIER_LIST_rec.request_id;
1235: END IF;
1236:
1237: IF l_MODIFIER_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN

Line 1237: IF l_MODIFIER_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN

1233: IF l_MODIFIER_LIST_rec.request_id = FND_API.G_MISS_NUM THEN
1234: l_MODIFIER_LIST_rec.request_id := p_old_MODIFIER_LIST_rec.request_id;
1235: END IF;
1236:
1237: IF l_MODIFIER_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN
1238: l_MODIFIER_LIST_rec.rounding_factor := p_old_MODIFIER_LIST_rec.rounding_factor;
1239: END IF;
1240:
1241: IF l_MODIFIER_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN

Line 1241: IF l_MODIFIER_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN

1237: IF l_MODIFIER_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN
1238: l_MODIFIER_LIST_rec.rounding_factor := p_old_MODIFIER_LIST_rec.rounding_factor;
1239: END IF;
1240:
1241: IF l_MODIFIER_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
1242: l_MODIFIER_LIST_rec.ship_method_code := p_old_MODIFIER_LIST_rec.ship_method_code;
1243: END IF;
1244:
1245: IF l_MODIFIER_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN

Line 1245: IF l_MODIFIER_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN

1241: IF l_MODIFIER_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
1242: l_MODIFIER_LIST_rec.ship_method_code := p_old_MODIFIER_LIST_rec.ship_method_code;
1243: END IF;
1244:
1245: IF l_MODIFIER_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN
1246: l_MODIFIER_LIST_rec.start_date_active := p_old_MODIFIER_LIST_rec.start_date_active;
1247: END IF;
1248:
1249: IF l_MODIFIER_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN

Line 1249: IF l_MODIFIER_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN

1245: IF l_MODIFIER_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN
1246: l_MODIFIER_LIST_rec.start_date_active := p_old_MODIFIER_LIST_rec.start_date_active;
1247: END IF;
1248:
1249: IF l_MODIFIER_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN
1250: l_MODIFIER_LIST_rec.terms_id := p_old_MODIFIER_LIST_rec.terms_id;
1251: END IF;
1252:
1253: IF l_MODIFIER_LIST_rec.source_system_code = FND_API.G_MISS_CHAR THEN

Line 1253: IF l_MODIFIER_LIST_rec.source_system_code = FND_API.G_MISS_CHAR THEN

1249: IF l_MODIFIER_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN
1250: l_MODIFIER_LIST_rec.terms_id := p_old_MODIFIER_LIST_rec.terms_id;
1251: END IF;
1252:
1253: IF l_MODIFIER_LIST_rec.source_system_code = FND_API.G_MISS_CHAR THEN
1254: l_MODIFIER_LIST_rec.source_system_code := p_old_MODIFIER_LIST_rec.source_system_code;
1255: END IF;
1256:
1257: IF l_MODIFIER_LIST_rec.pte_code = FND_API.G_MISS_CHAR THEN

Line 1257: IF l_MODIFIER_LIST_rec.pte_code = FND_API.G_MISS_CHAR THEN

1253: IF l_MODIFIER_LIST_rec.source_system_code = FND_API.G_MISS_CHAR THEN
1254: l_MODIFIER_LIST_rec.source_system_code := p_old_MODIFIER_LIST_rec.source_system_code;
1255: END IF;
1256:
1257: IF l_MODIFIER_LIST_rec.pte_code = FND_API.G_MISS_CHAR THEN
1258: l_MODIFIER_LIST_rec.pte_code := p_old_MODIFIER_LIST_rec.pte_code;
1259: END IF;
1260:
1261: IF l_MODIFIER_LIST_rec.active_flag = FND_API.G_MISS_CHAR THEN

Line 1261: IF l_MODIFIER_LIST_rec.active_flag = FND_API.G_MISS_CHAR THEN

1257: IF l_MODIFIER_LIST_rec.pte_code = FND_API.G_MISS_CHAR THEN
1258: l_MODIFIER_LIST_rec.pte_code := p_old_MODIFIER_LIST_rec.pte_code;
1259: END IF;
1260:
1261: IF l_MODIFIER_LIST_rec.active_flag = FND_API.G_MISS_CHAR THEN
1262: l_MODIFIER_LIST_rec.active_flag := p_old_MODIFIER_LIST_rec.active_flag;
1263: END IF;
1264:
1265: IF l_MODIFIER_LIST_rec.parent_list_header_id = FND_API.G_MISS_NUM THEN

Line 1265: IF l_MODIFIER_LIST_rec.parent_list_header_id = FND_API.G_MISS_NUM THEN

1261: IF l_MODIFIER_LIST_rec.active_flag = FND_API.G_MISS_CHAR THEN
1262: l_MODIFIER_LIST_rec.active_flag := p_old_MODIFIER_LIST_rec.active_flag;
1263: END IF;
1264:
1265: IF l_MODIFIER_LIST_rec.parent_list_header_id = FND_API.G_MISS_NUM THEN
1266: l_MODIFIER_LIST_rec.parent_list_header_id := p_old_MODIFIER_LIST_rec.parent_list_header_id;
1267: END IF;
1268:
1269: IF l_MODIFIER_LIST_rec.start_date_active_first = FND_API.G_MISS_DATE THEN

Line 1269: IF l_MODIFIER_LIST_rec.start_date_active_first = FND_API.G_MISS_DATE THEN

1265: IF l_MODIFIER_LIST_rec.parent_list_header_id = FND_API.G_MISS_NUM THEN
1266: l_MODIFIER_LIST_rec.parent_list_header_id := p_old_MODIFIER_LIST_rec.parent_list_header_id;
1267: END IF;
1268:
1269: IF l_MODIFIER_LIST_rec.start_date_active_first = FND_API.G_MISS_DATE THEN
1270: l_MODIFIER_LIST_rec.start_date_active_first := p_old_MODIFIER_LIST_rec.start_date_active_first;
1271: END IF;
1272:
1273: IF l_MODIFIER_LIST_rec.end_date_active_first = FND_API.G_MISS_DATE THEN

Line 1273: IF l_MODIFIER_LIST_rec.end_date_active_first = FND_API.G_MISS_DATE THEN

1269: IF l_MODIFIER_LIST_rec.start_date_active_first = FND_API.G_MISS_DATE THEN
1270: l_MODIFIER_LIST_rec.start_date_active_first := p_old_MODIFIER_LIST_rec.start_date_active_first;
1271: END IF;
1272:
1273: IF l_MODIFIER_LIST_rec.end_date_active_first = FND_API.G_MISS_DATE THEN
1274: l_MODIFIER_LIST_rec.end_date_active_first := p_old_MODIFIER_LIST_rec.end_date_active_first;
1275: END IF;
1276:
1277: IF l_MODIFIER_LIST_rec.active_date_first_type = FND_API.G_MISS_CHAR THEN

Line 1277: IF l_MODIFIER_LIST_rec.active_date_first_type = FND_API.G_MISS_CHAR THEN

1273: IF l_MODIFIER_LIST_rec.end_date_active_first = FND_API.G_MISS_DATE THEN
1274: l_MODIFIER_LIST_rec.end_date_active_first := p_old_MODIFIER_LIST_rec.end_date_active_first;
1275: END IF;
1276:
1277: IF l_MODIFIER_LIST_rec.active_date_first_type = FND_API.G_MISS_CHAR THEN
1278: l_MODIFIER_LIST_rec.active_date_first_type := p_old_MODIFIER_LIST_rec.active_date_first_type;
1279: END IF;
1280:
1281: IF l_MODIFIER_LIST_rec.start_date_active_second = FND_API.G_MISS_DATE THEN

Line 1281: IF l_MODIFIER_LIST_rec.start_date_active_second = FND_API.G_MISS_DATE THEN

1277: IF l_MODIFIER_LIST_rec.active_date_first_type = FND_API.G_MISS_CHAR THEN
1278: l_MODIFIER_LIST_rec.active_date_first_type := p_old_MODIFIER_LIST_rec.active_date_first_type;
1279: END IF;
1280:
1281: IF l_MODIFIER_LIST_rec.start_date_active_second = FND_API.G_MISS_DATE THEN
1282: l_MODIFIER_LIST_rec.start_date_active_second := p_old_MODIFIER_LIST_rec.start_date_active_second;
1283: END IF;
1284:
1285: IF l_MODIFIER_LIST_rec.global_flag = FND_API.G_MISS_CHAR THEN

Line 1285: IF l_MODIFIER_LIST_rec.global_flag = FND_API.G_MISS_CHAR THEN

1281: IF l_MODIFIER_LIST_rec.start_date_active_second = FND_API.G_MISS_DATE THEN
1282: l_MODIFIER_LIST_rec.start_date_active_second := p_old_MODIFIER_LIST_rec.start_date_active_second;
1283: END IF;
1284:
1285: IF l_MODIFIER_LIST_rec.global_flag = FND_API.G_MISS_CHAR THEN
1286: l_MODIFIER_LIST_rec.global_flag := p_old_MODIFIER_LIST_rec.global_flag;
1287: END IF;
1288:
1289:

Line 1290: IF l_MODIFIER_LIST_rec.end_date_active_second = FND_API.G_MISS_DATE THEN

1286: l_MODIFIER_LIST_rec.global_flag := p_old_MODIFIER_LIST_rec.global_flag;
1287: END IF;
1288:
1289:
1290: IF l_MODIFIER_LIST_rec.end_date_active_second = FND_API.G_MISS_DATE THEN
1291: l_MODIFIER_LIST_rec.end_date_active_second := p_old_MODIFIER_LIST_rec.end_date_active_second;
1292: END IF;
1293:
1294: IF l_MODIFIER_LIST_rec.active_date_second_type = FND_API.G_MISS_CHAR THEN

Line 1294: IF l_MODIFIER_LIST_rec.active_date_second_type = FND_API.G_MISS_CHAR THEN

1290: IF l_MODIFIER_LIST_rec.end_date_active_second = FND_API.G_MISS_DATE THEN
1291: l_MODIFIER_LIST_rec.end_date_active_second := p_old_MODIFIER_LIST_rec.end_date_active_second;
1292: END IF;
1293:
1294: IF l_MODIFIER_LIST_rec.active_date_second_type = FND_API.G_MISS_CHAR THEN
1295: l_MODIFIER_LIST_rec.active_date_second_type := p_old_MODIFIER_LIST_rec.active_date_second_type;
1296: END IF;
1297:
1298: IF l_MODIFIER_LIST_rec.ask_for_flag = FND_API.G_MISS_CHAR THEN

Line 1298: IF l_MODIFIER_LIST_rec.ask_for_flag = FND_API.G_MISS_CHAR THEN

1294: IF l_MODIFIER_LIST_rec.active_date_second_type = FND_API.G_MISS_CHAR THEN
1295: l_MODIFIER_LIST_rec.active_date_second_type := p_old_MODIFIER_LIST_rec.active_date_second_type;
1296: END IF;
1297:
1298: IF l_MODIFIER_LIST_rec.ask_for_flag = FND_API.G_MISS_CHAR THEN
1299: l_MODIFIER_LIST_rec.ask_for_flag := p_old_MODIFIER_LIST_rec.ask_for_flag;
1300: END IF;
1301:
1302: IF l_MODIFIER_LIST_rec.name = FND_API.G_MISS_CHAR THEN

Line 1302: IF l_MODIFIER_LIST_rec.name = FND_API.G_MISS_CHAR THEN

1298: IF l_MODIFIER_LIST_rec.ask_for_flag = FND_API.G_MISS_CHAR THEN
1299: l_MODIFIER_LIST_rec.ask_for_flag := p_old_MODIFIER_LIST_rec.ask_for_flag;
1300: END IF;
1301:
1302: IF l_MODIFIER_LIST_rec.name = FND_API.G_MISS_CHAR THEN
1303: l_MODIFIER_LIST_rec.name := p_old_MODIFIER_LIST_rec.name;
1304: END IF;
1305:
1306: IF l_MODIFIER_LIST_rec.version_no = FND_API.G_MISS_CHAR THEN

Line 1306: IF l_MODIFIER_LIST_rec.version_no = FND_API.G_MISS_CHAR THEN

1302: IF l_MODIFIER_LIST_rec.name = FND_API.G_MISS_CHAR THEN
1303: l_MODIFIER_LIST_rec.name := p_old_MODIFIER_LIST_rec.name;
1304: END IF;
1305:
1306: IF l_MODIFIER_LIST_rec.version_no = FND_API.G_MISS_CHAR THEN
1307: l_MODIFIER_LIST_rec.version_no := p_old_MODIFIER_LIST_rec.version_no;
1308: END IF;
1309:
1310: IF l_MODIFIER_LIST_rec.description = FND_API.G_MISS_CHAR THEN

Line 1310: IF l_MODIFIER_LIST_rec.description = FND_API.G_MISS_CHAR THEN

1306: IF l_MODIFIER_LIST_rec.version_no = FND_API.G_MISS_CHAR THEN
1307: l_MODIFIER_LIST_rec.version_no := p_old_MODIFIER_LIST_rec.version_no;
1308: END IF;
1309:
1310: IF l_MODIFIER_LIST_rec.description = FND_API.G_MISS_CHAR THEN
1311: l_MODIFIER_LIST_rec.description := p_old_MODIFIER_LIST_rec.description;
1312: END IF;
1313:
1314: -- Blanket Agreement Pricing bug#3871577

Line 1315: IF l_MODIFIER_LIST_rec.list_source_code = FND_API.G_MISS_CHAR THEN

1311: l_MODIFIER_LIST_rec.description := p_old_MODIFIER_LIST_rec.description;
1312: END IF;
1313:
1314: -- Blanket Agreement Pricing bug#3871577
1315: IF l_MODIFIER_LIST_rec.list_source_code = FND_API.G_MISS_CHAR THEN
1316: l_MODIFIER_LIST_rec.list_source_code := p_old_MODIFIER_LIST_rec.list_source_code;
1317: END IF;
1318:
1319: IF l_MODIFIER_LIST_rec.orig_system_header_ref = FND_API.G_MISS_CHAR THEN

Line 1319: IF l_MODIFIER_LIST_rec.orig_system_header_ref = FND_API.G_MISS_CHAR THEN

1315: IF l_MODIFIER_LIST_rec.list_source_code = FND_API.G_MISS_CHAR THEN
1316: l_MODIFIER_LIST_rec.list_source_code := p_old_MODIFIER_LIST_rec.list_source_code;
1317: END IF;
1318:
1319: IF l_MODIFIER_LIST_rec.orig_system_header_ref = FND_API.G_MISS_CHAR THEN
1320: l_MODIFIER_LIST_rec.orig_system_header_ref := p_old_MODIFIER_LIST_rec.orig_system_header_ref;
1321: END IF;
1322:
1323: IF l_MODIFIER_LIST_rec.shareable_flag = FND_API.G_MISS_CHAR THEN

Line 1323: IF l_MODIFIER_LIST_rec.shareable_flag = FND_API.G_MISS_CHAR THEN

1319: IF l_MODIFIER_LIST_rec.orig_system_header_ref = FND_API.G_MISS_CHAR THEN
1320: l_MODIFIER_LIST_rec.orig_system_header_ref := p_old_MODIFIER_LIST_rec.orig_system_header_ref;
1321: END IF;
1322:
1323: IF l_MODIFIER_LIST_rec.shareable_flag = FND_API.G_MISS_CHAR THEN
1324: l_MODIFIER_LIST_rec.shareable_flag := p_old_MODIFIER_LIST_rec.shareable_flag;
1325: END IF;
1326:
1327: --added for MOAC

Line 1328: IF l_MODIFIER_LIST_rec.org_id = FND_API.G_MISS_NUM THEN

1324: l_MODIFIER_LIST_rec.shareable_flag := p_old_MODIFIER_LIST_rec.shareable_flag;
1325: END IF;
1326:
1327: --added for MOAC
1328: IF l_MODIFIER_LIST_rec.org_id = FND_API.G_MISS_NUM THEN
1329: l_MODIFIER_LIST_rec.org_id := p_old_MODIFIER_LIST_rec.org_id;
1330: END IF;
1331:
1332: oe_debug_pub.add('version QPXUMLHB'||l_MODIFIER_LIST_rec.version_no);

Line 1349: IF l_MODIFIER_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN

1345: BEGIN
1346:
1347: oe_debug_pub.add('BEGIN convert_miss_to_null in QPXUMLHB');
1348:
1349: IF l_MODIFIER_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1350: l_MODIFIER_LIST_rec.attribute1 := NULL;
1351: END IF;
1352:
1353: IF l_MODIFIER_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 1353: IF l_MODIFIER_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN

1349: IF l_MODIFIER_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1350: l_MODIFIER_LIST_rec.attribute1 := NULL;
1351: END IF;
1352:
1353: IF l_MODIFIER_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1354: l_MODIFIER_LIST_rec.attribute10 := NULL;
1355: END IF;
1356:
1357: IF l_MODIFIER_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 1357: IF l_MODIFIER_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN

1353: IF l_MODIFIER_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1354: l_MODIFIER_LIST_rec.attribute10 := NULL;
1355: END IF;
1356:
1357: IF l_MODIFIER_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1358: l_MODIFIER_LIST_rec.attribute11 := NULL;
1359: END IF;
1360:
1361: IF l_MODIFIER_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 1361: IF l_MODIFIER_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN

1357: IF l_MODIFIER_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1358: l_MODIFIER_LIST_rec.attribute11 := NULL;
1359: END IF;
1360:
1361: IF l_MODIFIER_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1362: l_MODIFIER_LIST_rec.attribute12 := NULL;
1363: END IF;
1364:
1365: IF l_MODIFIER_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 1365: IF l_MODIFIER_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN

1361: IF l_MODIFIER_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1362: l_MODIFIER_LIST_rec.attribute12 := NULL;
1363: END IF;
1364:
1365: IF l_MODIFIER_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1366: l_MODIFIER_LIST_rec.attribute13 := NULL;
1367: END IF;
1368:
1369: IF l_MODIFIER_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 1369: IF l_MODIFIER_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN

1365: IF l_MODIFIER_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1366: l_MODIFIER_LIST_rec.attribute13 := NULL;
1367: END IF;
1368:
1369: IF l_MODIFIER_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1370: l_MODIFIER_LIST_rec.attribute14 := NULL;
1371: END IF;
1372:
1373: IF l_MODIFIER_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 1373: IF l_MODIFIER_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN

1369: IF l_MODIFIER_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1370: l_MODIFIER_LIST_rec.attribute14 := NULL;
1371: END IF;
1372:
1373: IF l_MODIFIER_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1374: l_MODIFIER_LIST_rec.attribute15 := NULL;
1375: END IF;
1376:
1377: IF l_MODIFIER_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 1377: IF l_MODIFIER_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN

1373: IF l_MODIFIER_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1374: l_MODIFIER_LIST_rec.attribute15 := NULL;
1375: END IF;
1376:
1377: IF l_MODIFIER_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1378: l_MODIFIER_LIST_rec.attribute2 := NULL;
1379: END IF;
1380:
1381: IF l_MODIFIER_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 1381: IF l_MODIFIER_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN

1377: IF l_MODIFIER_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1378: l_MODIFIER_LIST_rec.attribute2 := NULL;
1379: END IF;
1380:
1381: IF l_MODIFIER_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1382: l_MODIFIER_LIST_rec.attribute3 := NULL;
1383: END IF;
1384:
1385: IF l_MODIFIER_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 1385: IF l_MODIFIER_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN

1381: IF l_MODIFIER_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1382: l_MODIFIER_LIST_rec.attribute3 := NULL;
1383: END IF;
1384:
1385: IF l_MODIFIER_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1386: l_MODIFIER_LIST_rec.attribute4 := NULL;
1387: END IF;
1388:
1389: IF l_MODIFIER_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 1389: IF l_MODIFIER_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN

1385: IF l_MODIFIER_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1386: l_MODIFIER_LIST_rec.attribute4 := NULL;
1387: END IF;
1388:
1389: IF l_MODIFIER_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1390: l_MODIFIER_LIST_rec.attribute5 := NULL;
1391: END IF;
1392:
1393: IF l_MODIFIER_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 1393: IF l_MODIFIER_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN

1389: IF l_MODIFIER_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1390: l_MODIFIER_LIST_rec.attribute5 := NULL;
1391: END IF;
1392:
1393: IF l_MODIFIER_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1394: l_MODIFIER_LIST_rec.attribute6 := NULL;
1395: END IF;
1396:
1397: IF l_MODIFIER_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 1397: IF l_MODIFIER_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN

1393: IF l_MODIFIER_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1394: l_MODIFIER_LIST_rec.attribute6 := NULL;
1395: END IF;
1396:
1397: IF l_MODIFIER_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1398: l_MODIFIER_LIST_rec.attribute7 := NULL;
1399: END IF;
1400:
1401: IF l_MODIFIER_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 1401: IF l_MODIFIER_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN

1397: IF l_MODIFIER_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1398: l_MODIFIER_LIST_rec.attribute7 := NULL;
1399: END IF;
1400:
1401: IF l_MODIFIER_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1402: l_MODIFIER_LIST_rec.attribute8 := NULL;
1403: END IF;
1404:
1405: IF l_MODIFIER_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 1405: IF l_MODIFIER_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN

1401: IF l_MODIFIER_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1402: l_MODIFIER_LIST_rec.attribute8 := NULL;
1403: END IF;
1404:
1405: IF l_MODIFIER_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1406: l_MODIFIER_LIST_rec.attribute9 := NULL;
1407: END IF;
1408:
1409: IF l_MODIFIER_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN

Line 1409: IF l_MODIFIER_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN

1405: IF l_MODIFIER_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1406: l_MODIFIER_LIST_rec.attribute9 := NULL;
1407: END IF;
1408:
1409: IF l_MODIFIER_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1410: l_MODIFIER_LIST_rec.automatic_flag := NULL;
1411: END IF;
1412:
1413: IF l_MODIFIER_LIST_rec.comments = FND_API.G_MISS_CHAR THEN

Line 1413: IF l_MODIFIER_LIST_rec.comments = FND_API.G_MISS_CHAR THEN

1409: IF l_MODIFIER_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1410: l_MODIFIER_LIST_rec.automatic_flag := NULL;
1411: END IF;
1412:
1413: IF l_MODIFIER_LIST_rec.comments = FND_API.G_MISS_CHAR THEN
1414: l_MODIFIER_LIST_rec.comments := NULL;
1415: END IF;
1416:
1417: IF l_MODIFIER_LIST_rec.context = FND_API.G_MISS_CHAR THEN

Line 1417: IF l_MODIFIER_LIST_rec.context = FND_API.G_MISS_CHAR THEN

1413: IF l_MODIFIER_LIST_rec.comments = FND_API.G_MISS_CHAR THEN
1414: l_MODIFIER_LIST_rec.comments := NULL;
1415: END IF;
1416:
1417: IF l_MODIFIER_LIST_rec.context = FND_API.G_MISS_CHAR THEN
1418: l_MODIFIER_LIST_rec.context := NULL;
1419: END IF;
1420:
1421: IF l_MODIFIER_LIST_rec.created_by = FND_API.G_MISS_NUM THEN

Line 1421: IF l_MODIFIER_LIST_rec.created_by = FND_API.G_MISS_NUM THEN

1417: IF l_MODIFIER_LIST_rec.context = FND_API.G_MISS_CHAR THEN
1418: l_MODIFIER_LIST_rec.context := NULL;
1419: END IF;
1420:
1421: IF l_MODIFIER_LIST_rec.created_by = FND_API.G_MISS_NUM THEN
1422: l_MODIFIER_LIST_rec.created_by := NULL;
1423: END IF;
1424:
1425: IF l_MODIFIER_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 1425: IF l_MODIFIER_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN

1421: IF l_MODIFIER_LIST_rec.created_by = FND_API.G_MISS_NUM THEN
1422: l_MODIFIER_LIST_rec.created_by := NULL;
1423: END IF;
1424:
1425: IF l_MODIFIER_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN
1426: l_MODIFIER_LIST_rec.creation_date := NULL;
1427: END IF;
1428:
1429: IF l_MODIFIER_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN

Line 1429: IF l_MODIFIER_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN

1425: IF l_MODIFIER_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN
1426: l_MODIFIER_LIST_rec.creation_date := NULL;
1427: END IF;
1428:
1429: IF l_MODIFIER_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN
1430: l_MODIFIER_LIST_rec.currency_code := NULL;
1431: END IF;
1432:
1433: IF l_MODIFIER_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN

Line 1433: IF l_MODIFIER_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN

1429: IF l_MODIFIER_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN
1430: l_MODIFIER_LIST_rec.currency_code := NULL;
1431: END IF;
1432:
1433: IF l_MODIFIER_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN
1434: l_MODIFIER_LIST_rec.discount_lines_flag := NULL;
1435: END IF;
1436:
1437: IF l_MODIFIER_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN

Line 1437: IF l_MODIFIER_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN

1433: IF l_MODIFIER_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN
1434: l_MODIFIER_LIST_rec.discount_lines_flag := NULL;
1435: END IF;
1436:
1437: IF l_MODIFIER_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN
1438: l_MODIFIER_LIST_rec.end_date_active := NULL;
1439: END IF;
1440:
1441: IF l_MODIFIER_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN

Line 1441: IF l_MODIFIER_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN

1437: IF l_MODIFIER_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN
1438: l_MODIFIER_LIST_rec.end_date_active := NULL;
1439: END IF;
1440:
1441: IF l_MODIFIER_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
1442: l_MODIFIER_LIST_rec.freight_terms_code := NULL;
1443: END IF;
1444:
1445: IF l_MODIFIER_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR THEN

Line 1445: IF l_MODIFIER_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR THEN

1441: IF l_MODIFIER_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
1442: l_MODIFIER_LIST_rec.freight_terms_code := NULL;
1443: END IF;
1444:
1445: IF l_MODIFIER_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR THEN
1446: l_MODIFIER_LIST_rec.gsa_indicator := NULL;
1447: END IF;
1448:
1449: IF l_MODIFIER_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 1449: IF l_MODIFIER_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN

1445: IF l_MODIFIER_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR THEN
1446: l_MODIFIER_LIST_rec.gsa_indicator := NULL;
1447: END IF;
1448:
1449: IF l_MODIFIER_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1450: l_MODIFIER_LIST_rec.last_updated_by := NULL;
1451: END IF;
1452:
1453: IF l_MODIFIER_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 1453: IF l_MODIFIER_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN

1449: IF l_MODIFIER_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1450: l_MODIFIER_LIST_rec.last_updated_by := NULL;
1451: END IF;
1452:
1453: IF l_MODIFIER_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN
1454: l_MODIFIER_LIST_rec.last_update_date := NULL;
1455: END IF;
1456:
1457: IF l_MODIFIER_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 1457: IF l_MODIFIER_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN

1453: IF l_MODIFIER_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN
1454: l_MODIFIER_LIST_rec.last_update_date := NULL;
1455: END IF;
1456:
1457: IF l_MODIFIER_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN
1458: l_MODIFIER_LIST_rec.last_update_login := NULL;
1459: END IF;
1460:
1461: IF l_MODIFIER_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN

Line 1461: IF l_MODIFIER_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN

1457: IF l_MODIFIER_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN
1458: l_MODIFIER_LIST_rec.last_update_login := NULL;
1459: END IF;
1460:
1461: IF l_MODIFIER_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN
1462: l_MODIFIER_LIST_rec.list_header_id := NULL;
1463: END IF;
1464:
1465: IF l_MODIFIER_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN

Line 1465: IF l_MODIFIER_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN

1461: IF l_MODIFIER_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN
1462: l_MODIFIER_LIST_rec.list_header_id := NULL;
1463: END IF;
1464:
1465: IF l_MODIFIER_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN
1466: l_MODIFIER_LIST_rec.list_type_code := NULL;
1467: END IF;
1468:
1469: IF l_MODIFIER_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 1469: IF l_MODIFIER_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN

1465: IF l_MODIFIER_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN
1466: l_MODIFIER_LIST_rec.list_type_code := NULL;
1467: END IF;
1468:
1469: IF l_MODIFIER_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN
1470: l_MODIFIER_LIST_rec.program_application_id := NULL;
1471: END IF;
1472:
1473: IF l_MODIFIER_LIST_rec.program_id = FND_API.G_MISS_NUM THEN

Line 1473: IF l_MODIFIER_LIST_rec.program_id = FND_API.G_MISS_NUM THEN

1469: IF l_MODIFIER_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN
1470: l_MODIFIER_LIST_rec.program_application_id := NULL;
1471: END IF;
1472:
1473: IF l_MODIFIER_LIST_rec.program_id = FND_API.G_MISS_NUM THEN
1474: l_MODIFIER_LIST_rec.program_id := NULL;
1475: END IF;
1476:
1477: IF l_MODIFIER_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 1477: IF l_MODIFIER_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN

1473: IF l_MODIFIER_LIST_rec.program_id = FND_API.G_MISS_NUM THEN
1474: l_MODIFIER_LIST_rec.program_id := NULL;
1475: END IF;
1476:
1477: IF l_MODIFIER_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN
1478: l_MODIFIER_LIST_rec.program_update_date := NULL;
1479: END IF;
1480:
1481: IF l_MODIFIER_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN

Line 1481: IF l_MODIFIER_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN

1477: IF l_MODIFIER_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN
1478: l_MODIFIER_LIST_rec.program_update_date := NULL;
1479: END IF;
1480:
1481: IF l_MODIFIER_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN
1482: l_MODIFIER_LIST_rec.prorate_flag := NULL;
1483: END IF;
1484:
1485: IF l_MODIFIER_LIST_rec.request_id = FND_API.G_MISS_NUM THEN

Line 1485: IF l_MODIFIER_LIST_rec.request_id = FND_API.G_MISS_NUM THEN

1481: IF l_MODIFIER_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN
1482: l_MODIFIER_LIST_rec.prorate_flag := NULL;
1483: END IF;
1484:
1485: IF l_MODIFIER_LIST_rec.request_id = FND_API.G_MISS_NUM THEN
1486: l_MODIFIER_LIST_rec.request_id := NULL;
1487: END IF;
1488:
1489: IF l_MODIFIER_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN

Line 1489: IF l_MODIFIER_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN

1485: IF l_MODIFIER_LIST_rec.request_id = FND_API.G_MISS_NUM THEN
1486: l_MODIFIER_LIST_rec.request_id := NULL;
1487: END IF;
1488:
1489: IF l_MODIFIER_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN
1490: l_MODIFIER_LIST_rec.rounding_factor := NULL;
1491: END IF;
1492:
1493: IF l_MODIFIER_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN

Line 1493: IF l_MODIFIER_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN

1489: IF l_MODIFIER_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN
1490: l_MODIFIER_LIST_rec.rounding_factor := NULL;
1491: END IF;
1492:
1493: IF l_MODIFIER_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
1494: l_MODIFIER_LIST_rec.ship_method_code := NULL;
1495: END IF;
1496:
1497: IF l_MODIFIER_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN

Line 1497: IF l_MODIFIER_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN

1493: IF l_MODIFIER_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
1494: l_MODIFIER_LIST_rec.ship_method_code := NULL;
1495: END IF;
1496:
1497: IF l_MODIFIER_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN
1498: l_MODIFIER_LIST_rec.start_date_active := NULL;
1499: END IF;
1500:
1501: IF l_MODIFIER_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN

Line 1501: IF l_MODIFIER_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN

1497: IF l_MODIFIER_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN
1498: l_MODIFIER_LIST_rec.start_date_active := NULL;
1499: END IF;
1500:
1501: IF l_MODIFIER_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN
1502: l_MODIFIER_LIST_rec.terms_id := NULL;
1503: END IF;
1504:
1505: IF l_MODIFIER_LIST_rec.source_system_code = FND_API.G_MISS_CHAR THEN

Line 1505: IF l_MODIFIER_LIST_rec.source_system_code = FND_API.G_MISS_CHAR THEN

1501: IF l_MODIFIER_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN
1502: l_MODIFIER_LIST_rec.terms_id := NULL;
1503: END IF;
1504:
1505: IF l_MODIFIER_LIST_rec.source_system_code = FND_API.G_MISS_CHAR THEN
1506: l_MODIFIER_LIST_rec.source_system_code := NULL;
1507: END IF;
1508:
1509: IF l_MODIFIER_LIST_rec.pte_code = FND_API.G_MISS_CHAR THEN

Line 1509: IF l_MODIFIER_LIST_rec.pte_code = FND_API.G_MISS_CHAR THEN

1505: IF l_MODIFIER_LIST_rec.source_system_code = FND_API.G_MISS_CHAR THEN
1506: l_MODIFIER_LIST_rec.source_system_code := NULL;
1507: END IF;
1508:
1509: IF l_MODIFIER_LIST_rec.pte_code = FND_API.G_MISS_CHAR THEN
1510: l_MODIFIER_LIST_rec.pte_code := NULL;
1511: END IF;
1512:
1513: IF l_MODIFIER_LIST_rec.active_flag = FND_API.G_MISS_CHAR THEN

Line 1513: IF l_MODIFIER_LIST_rec.active_flag = FND_API.G_MISS_CHAR THEN

1509: IF l_MODIFIER_LIST_rec.pte_code = FND_API.G_MISS_CHAR THEN
1510: l_MODIFIER_LIST_rec.pte_code := NULL;
1511: END IF;
1512:
1513: IF l_MODIFIER_LIST_rec.active_flag = FND_API.G_MISS_CHAR THEN
1514: l_MODIFIER_LIST_rec.active_flag := NULL;
1515: END IF;
1516:
1517: IF l_MODIFIER_LIST_rec.parent_list_header_id = FND_API.G_MISS_NUM THEN

Line 1517: IF l_MODIFIER_LIST_rec.parent_list_header_id = FND_API.G_MISS_NUM THEN

1513: IF l_MODIFIER_LIST_rec.active_flag = FND_API.G_MISS_CHAR THEN
1514: l_MODIFIER_LIST_rec.active_flag := NULL;
1515: END IF;
1516:
1517: IF l_MODIFIER_LIST_rec.parent_list_header_id = FND_API.G_MISS_NUM THEN
1518: l_MODIFIER_LIST_rec.parent_list_header_id := NULL;
1519: END IF;
1520:
1521: IF l_MODIFIER_LIST_rec.start_date_active_first = FND_API.G_MISS_DATE THEN

Line 1521: IF l_MODIFIER_LIST_rec.start_date_active_first = FND_API.G_MISS_DATE THEN

1517: IF l_MODIFIER_LIST_rec.parent_list_header_id = FND_API.G_MISS_NUM THEN
1518: l_MODIFIER_LIST_rec.parent_list_header_id := NULL;
1519: END IF;
1520:
1521: IF l_MODIFIER_LIST_rec.start_date_active_first = FND_API.G_MISS_DATE THEN
1522: l_MODIFIER_LIST_rec.start_date_active_first := NULL;
1523: END IF;
1524:
1525: IF l_MODIFIER_LIST_rec.end_date_active_first = FND_API.G_MISS_DATE THEN

Line 1525: IF l_MODIFIER_LIST_rec.end_date_active_first = FND_API.G_MISS_DATE THEN

1521: IF l_MODIFIER_LIST_rec.start_date_active_first = FND_API.G_MISS_DATE THEN
1522: l_MODIFIER_LIST_rec.start_date_active_first := NULL;
1523: END IF;
1524:
1525: IF l_MODIFIER_LIST_rec.end_date_active_first = FND_API.G_MISS_DATE THEN
1526: l_MODIFIER_LIST_rec.end_date_active_first := NULL;
1527: END IF;
1528:
1529: IF l_MODIFIER_LIST_rec.active_date_first_type = FND_API.G_MISS_CHAR THEN

Line 1529: IF l_MODIFIER_LIST_rec.active_date_first_type = FND_API.G_MISS_CHAR THEN

1525: IF l_MODIFIER_LIST_rec.end_date_active_first = FND_API.G_MISS_DATE THEN
1526: l_MODIFIER_LIST_rec.end_date_active_first := NULL;
1527: END IF;
1528:
1529: IF l_MODIFIER_LIST_rec.active_date_first_type = FND_API.G_MISS_CHAR THEN
1530: l_MODIFIER_LIST_rec.active_date_first_type := NULL;
1531: END IF;
1532:
1533: IF l_MODIFIER_LIST_rec.start_date_active_second = FND_API.G_MISS_DATE THEN

Line 1533: IF l_MODIFIER_LIST_rec.start_date_active_second = FND_API.G_MISS_DATE THEN

1529: IF l_MODIFIER_LIST_rec.active_date_first_type = FND_API.G_MISS_CHAR THEN
1530: l_MODIFIER_LIST_rec.active_date_first_type := NULL;
1531: END IF;
1532:
1533: IF l_MODIFIER_LIST_rec.start_date_active_second = FND_API.G_MISS_DATE THEN
1534: l_MODIFIER_LIST_rec.start_date_active_second := NULL;
1535: END IF;
1536:
1537: IF l_MODIFIER_LIST_rec.global_flag = FND_API.G_MISS_CHAR THEN

Line 1537: IF l_MODIFIER_LIST_rec.global_flag = FND_API.G_MISS_CHAR THEN

1533: IF l_MODIFIER_LIST_rec.start_date_active_second = FND_API.G_MISS_DATE THEN
1534: l_MODIFIER_LIST_rec.start_date_active_second := NULL;
1535: END IF;
1536:
1537: IF l_MODIFIER_LIST_rec.global_flag = FND_API.G_MISS_CHAR THEN
1538: l_MODIFIER_LIST_rec.global_flag := NULL;
1539: END IF;
1540:
1541:

Line 1542: IF l_MODIFIER_LIST_rec.end_date_active_second = FND_API.G_MISS_DATE THEN

1538: l_MODIFIER_LIST_rec.global_flag := NULL;
1539: END IF;
1540:
1541:
1542: IF l_MODIFIER_LIST_rec.end_date_active_second = FND_API.G_MISS_DATE THEN
1543: l_MODIFIER_LIST_rec.end_date_active_second := NULL;
1544: END IF;
1545:
1546: IF l_MODIFIER_LIST_rec.active_date_second_type = FND_API.G_MISS_CHAR THEN

Line 1546: IF l_MODIFIER_LIST_rec.active_date_second_type = FND_API.G_MISS_CHAR THEN

1542: IF l_MODIFIER_LIST_rec.end_date_active_second = FND_API.G_MISS_DATE THEN
1543: l_MODIFIER_LIST_rec.end_date_active_second := NULL;
1544: END IF;
1545:
1546: IF l_MODIFIER_LIST_rec.active_date_second_type = FND_API.G_MISS_CHAR THEN
1547: l_MODIFIER_LIST_rec.active_date_second_type := NULL;
1548: END IF;
1549:
1550: IF l_MODIFIER_LIST_rec.ask_for_flag = FND_API.G_MISS_CHAR THEN

Line 1550: IF l_MODIFIER_LIST_rec.ask_for_flag = FND_API.G_MISS_CHAR THEN

1546: IF l_MODIFIER_LIST_rec.active_date_second_type = FND_API.G_MISS_CHAR THEN
1547: l_MODIFIER_LIST_rec.active_date_second_type := NULL;
1548: END IF;
1549:
1550: IF l_MODIFIER_LIST_rec.ask_for_flag = FND_API.G_MISS_CHAR THEN
1551: l_MODIFIER_LIST_rec.ask_for_flag := NULL;
1552: END IF;
1553:
1554: IF l_MODIFIER_LIST_rec.name = FND_API.G_MISS_CHAR THEN

Line 1554: IF l_MODIFIER_LIST_rec.name = FND_API.G_MISS_CHAR THEN

1550: IF l_MODIFIER_LIST_rec.ask_for_flag = FND_API.G_MISS_CHAR THEN
1551: l_MODIFIER_LIST_rec.ask_for_flag := NULL;
1552: END IF;
1553:
1554: IF l_MODIFIER_LIST_rec.name = FND_API.G_MISS_CHAR THEN
1555: l_MODIFIER_LIST_rec.name := NULL;
1556: END IF;
1557:
1558: IF l_MODIFIER_LIST_rec.description = FND_API.G_MISS_CHAR THEN

Line 1558: IF l_MODIFIER_LIST_rec.description = FND_API.G_MISS_CHAR THEN

1554: IF l_MODIFIER_LIST_rec.name = FND_API.G_MISS_CHAR THEN
1555: l_MODIFIER_LIST_rec.name := NULL;
1556: END IF;
1557:
1558: IF l_MODIFIER_LIST_rec.description = FND_API.G_MISS_CHAR THEN
1559: l_MODIFIER_LIST_rec.description := NULL;
1560: END IF;
1561:
1562: oe_debug_pub.add('END convert_miss_to_null in QPXUMLHB');

Line 1686: RAISE FND_API.G_EXC_ERROR;

1682: WHEN DUP_VAL_ON_INDEX THEN
1683:
1684: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_MODIFIER');
1685: OE_MSG_PUB.Add;
1686: RAISE FND_API.G_EXC_ERROR;
1687:
1688: WHEN OTHERS THEN
1689:
1690: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1694: , 'Update_Row'
1695: );
1696: END IF;
1697:
1698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1699:
1700: End;
1701: end if;
1702:

Line 1705: WHEN FND_API.G_EXC_ERROR THEN

1701: end if;
1702:
1703: EXCEPTION
1704:
1705: WHEN FND_API.G_EXC_ERROR THEN
1706: RAISE;
1707:
1708: WHEN OTHERS THEN
1709:

Line 1718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1714: , 'Update_Row'
1715: );
1716: END IF;
1717:
1718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1719:
1720: END Update_Row;
1721:
1722: -- Procedure Insert_Row

Line 1777: RAISE FND_API.G_EXC_ERROR;

1773: WHEN DUP_VAL_ON_INDEX THEN
1774:
1775: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_MODIFIER');
1776: OE_MSG_PUB.Add;
1777: RAISE FND_API.G_EXC_ERROR;
1778:
1779: WHEN OTHERS THEN
1780:
1781: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1785: , 'Insert_Row'
1786: );
1787: END IF;
1788:
1789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1790:
1791: End;
1792:
1793: oe_debug_pub.add('BEGIN insert_row in QPXUMLHB');

Line 1941: FND_API.G_MISS_NUM,

1937: IF p_MODIFIER_LIST_rec.gsa_indicator = 'Y'
1938: THEN
1939:
1940: QP_QP_Form_Modifier_List.Create_GSA_Qual(p_MODIFIER_LIST_rec.LIST_HEADER_ID ,
1941: FND_API.G_MISS_NUM,
1942: --NULL, for bug2420752
1943: 'GSA',
1944: l_return_status );
1945: END IF;

Line 1950: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1946:
1947: oe_debug_pub.add('l_ret_sts'||l_return_status);
1948: /*added this code to raise exception if qualifier does not get created-spgopal*/
1949:
1950: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1951: oe_debug_pub.add('l_ret_sts if'||l_return_status);
1952: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');
1953: OE_MSG_PUB.Add;
1954:

Line 1955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1951: oe_debug_pub.add('l_ret_sts if'||l_return_status);
1952: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');
1953: OE_MSG_PUB.Add;
1954:
1955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1956: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1957: oe_debug_pub.add('l_ret_sts else '||l_return_status);
1958: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');
1959: OE_MSG_PUB.Add;

Line 1956: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1952: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');
1953: OE_MSG_PUB.Add;
1954:
1955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1956: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1957: oe_debug_pub.add('l_ret_sts else '||l_return_status);
1958: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');
1959: OE_MSG_PUB.Add;
1960: RAISE FND_API.G_EXC_ERROR;

Line 1960: RAISE FND_API.G_EXC_ERROR;

1956: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1957: oe_debug_pub.add('l_ret_sts else '||l_return_status);
1958: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');
1959: OE_MSG_PUB.Add;
1960: RAISE FND_API.G_EXC_ERROR;
1961: END IF;
1962:
1963:
1964:

Line 1969: WHEN FND_API.G_EXC_ERROR THEN

1965: oe_debug_pub.add('insert after QPXUMLHB'||p_MODIFIER_LIST_rec.VERSION_NO||to_char(p_modifier_list_rec.list_header_id));
1966: oe_debug_pub.add('END insert_row in QPXUMLHB');
1967: EXCEPTION
1968:
1969: WHEN FND_API.G_EXC_ERROR THEN
1970:
1971:
1972: --x_return_status := FND_API.G_RET_STS_ERROR;
1973:

Line 1972: --x_return_status := FND_API.G_RET_STS_ERROR;

1968:
1969: WHEN FND_API.G_EXC_ERROR THEN
1970:
1971:
1972: --x_return_status := FND_API.G_RET_STS_ERROR;
1973:
1974: /*
1975: -- Get message count and data
1976:

Line 1991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1987: , 'Insert_Row'
1988: );
1989: END IF;
1990:
1991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1992: */
1993: RAISE; -- Bug 2101393
1994:
1995: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1995: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1992: */
1993: RAISE; -- Bug 2101393
1994:
1995: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1996:
1997:
1998: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1999:

Line 1998: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1994:
1995: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1996:
1997:
1998: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1999:
2000: /*
2001: -- Get message count and data
2002:

Line 2017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2013: , 'Insert_Row'
2014: );
2015: END IF;
2016:
2017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2018:
2019:
2020: WHEN OTHERS THEN
2021:

Line 2030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2026: , 'Insert_Row'
2027: );
2028: END IF;
2029:
2030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2031:
2032: END Insert_Row;
2033:
2034: -- Procedure Delete_Row

Line 2086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2082: , 'Delete_Row'
2083: );
2084: END IF;
2085:
2086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2087:
2088: END Delete_Row;
2089:
2090: -- Function Query_Row

Line 2246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2242: , 'Query_Row'
2243: );
2244: END IF;
2245:
2246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2247:
2248: END Query_Row;
2249:
2250: -- Procedure lock_Row

Line 2509: x_return_status := FND_API.G_RET_STS_SUCCESS;

2505: x_MODIFIER_LIST_rec := l_MODIFIER_LIST_rec;
2506:
2507: -- Set return status
2508:
2509: x_return_status := FND_API.G_RET_STS_SUCCESS;
2510: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2511:
2512: ELSE
2513:

Line 2510: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_SUCCESS;

2506:
2507: -- Set return status
2508:
2509: x_return_status := FND_API.G_RET_STS_SUCCESS;
2510: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2511:
2512: ELSE
2513:
2514: -- Row has changed by another user.

Line 2516: x_return_status := FND_API.G_RET_STS_ERROR;

2512: ELSE
2513:
2514: -- Row has changed by another user.
2515:
2516: x_return_status := FND_API.G_RET_STS_ERROR;
2517: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2518:
2519: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2520: THEN

Line 2517: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

2513:
2514: -- Row has changed by another user.
2515:
2516: x_return_status := FND_API.G_RET_STS_ERROR;
2517: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2518:
2519: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2520: THEN
2521:

Line 2534: x_return_status := FND_API.G_RET_STS_ERROR;

2530: EXCEPTION
2531:
2532: WHEN NO_DATA_FOUND THEN
2533:
2534: x_return_status := FND_API.G_RET_STS_ERROR;
2535: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2536:
2537: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2538: THEN

Line 2535: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

2531:
2532: WHEN NO_DATA_FOUND THEN
2533:
2534: x_return_status := FND_API.G_RET_STS_ERROR;
2535: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2536:
2537: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2538: THEN
2539:

Line 2546: x_return_status := FND_API.G_RET_STS_ERROR;

2542:
2543: END IF;
2544: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2545:
2546: x_return_status := FND_API.G_RET_STS_ERROR;
2547: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2548:
2549: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2550: THEN

Line 2547: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

2543: END IF;
2544: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2545:
2546: x_return_status := FND_API.G_RET_STS_ERROR;
2547: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2548:
2549: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2550: THEN
2551:

Line 2558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2554:
2555: END IF;
2556: WHEN OTHERS THEN
2557:
2558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2559: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2560:
2561: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2562: THEN

Line 2559: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2555: END IF;
2556: WHEN OTHERS THEN
2557:
2558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2559: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2560:
2561: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2562: THEN
2563: OE_MSG_PUB.Add_Exc_Msg

Line 2584: p_MODIFIER_LIST_rec.automatic_flag <> FND_API.G_MISS_CHAR AND

2580: BEGIN
2581:
2582: oe_debug_pub.add('BEGIN get_values in QPXUMLHB');
2583: IF p_MODIFIER_LIST_rec.automatic_flag IS NOT NULL AND
2584: p_MODIFIER_LIST_rec.automatic_flag <> FND_API.G_MISS_CHAR AND
2585: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.automatic_flag,
2586: p_old_MODIFIER_LIST_rec.automatic_flag)
2587: THEN
2588: l_MODIFIER_LIST_val_rec.automatic := QP_Id_To_Value.Automatic

Line 2594: p_MODIFIER_LIST_rec.currency_code <> FND_API.G_MISS_CHAR AND

2590: );
2591: END IF;
2592:
2593: IF p_MODIFIER_LIST_rec.currency_code IS NOT NULL AND
2594: p_MODIFIER_LIST_rec.currency_code <> FND_API.G_MISS_CHAR AND
2595: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.currency_code,
2596: p_old_MODIFIER_LIST_rec.currency_code)
2597: THEN
2598: l_MODIFIER_LIST_val_rec.currency := QP_Id_To_Value.Currency

Line 2604: p_MODIFIER_LIST_rec.discount_lines_flag <> FND_API.G_MISS_CHAR AND

2600: );
2601: END IF;
2602:
2603: IF p_MODIFIER_LIST_rec.discount_lines_flag IS NOT NULL AND
2604: p_MODIFIER_LIST_rec.discount_lines_flag <> FND_API.G_MISS_CHAR AND
2605: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.discount_lines_flag,
2606: p_old_MODIFIER_LIST_rec.discount_lines_flag)
2607: THEN
2608: l_MODIFIER_LIST_val_rec.discount_lines := QP_Id_To_Value.Discount_Lines

Line 2614: p_MODIFIER_LIST_rec.freight_terms_code <> FND_API.G_MISS_CHAR AND

2610: );
2611: END IF;
2612:
2613: IF p_MODIFIER_LIST_rec.freight_terms_code IS NOT NULL AND
2614: p_MODIFIER_LIST_rec.freight_terms_code <> FND_API.G_MISS_CHAR AND
2615: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.freight_terms_code,
2616: p_old_MODIFIER_LIST_rec.freight_terms_code)
2617: THEN
2618: l_MODIFIER_LIST_val_rec.freight_terms := QP_Id_To_Value.Freight_Terms

Line 2624: p_MODIFIER_LIST_rec.list_header_id <> FND_API.G_MISS_NUM AND

2620: );
2621: END IF;
2622:
2623: IF p_MODIFIER_LIST_rec.list_header_id IS NOT NULL AND
2624: p_MODIFIER_LIST_rec.list_header_id <> FND_API.G_MISS_NUM AND
2625: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_header_id,
2626: p_old_MODIFIER_LIST_rec.list_header_id)
2627: THEN
2628: l_MODIFIER_LIST_val_rec.list_header := QP_Id_To_Value.List_Header

Line 2634: p_MODIFIER_LIST_rec.list_type_code <> FND_API.G_MISS_CHAR AND

2630: );
2631: END IF;
2632:
2633: IF p_MODIFIER_LIST_rec.list_type_code IS NOT NULL AND
2634: p_MODIFIER_LIST_rec.list_type_code <> FND_API.G_MISS_CHAR AND
2635: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_type_code,
2636: p_old_MODIFIER_LIST_rec.list_type_code)
2637: THEN
2638: l_MODIFIER_LIST_val_rec.list_type := QP_Id_To_Value.List_Type

Line 2644: p_MODIFIER_LIST_rec.prorate_flag <> FND_API.G_MISS_CHAR AND

2640: );
2641: END IF;
2642:
2643: IF p_MODIFIER_LIST_rec.prorate_flag IS NOT NULL AND
2644: p_MODIFIER_LIST_rec.prorate_flag <> FND_API.G_MISS_CHAR AND
2645: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.prorate_flag,
2646: p_old_MODIFIER_LIST_rec.prorate_flag)
2647: THEN
2648: l_MODIFIER_LIST_val_rec.prorate := QP_Id_To_Value.Prorate

Line 2654: p_MODIFIER_LIST_rec.ship_method_code <> FND_API.G_MISS_CHAR AND

2650: );
2651: END IF;
2652:
2653: IF p_MODIFIER_LIST_rec.ship_method_code IS NOT NULL AND
2654: p_MODIFIER_LIST_rec.ship_method_code <> FND_API.G_MISS_CHAR AND
2655: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ship_method_code,
2656: p_old_MODIFIER_LIST_rec.ship_method_code)
2657: THEN
2658: l_MODIFIER_LIST_val_rec.ship_method := QP_Id_To_Value.Ship_Method

Line 2664: p_MODIFIER_LIST_rec.terms_id <> FND_API.G_MISS_NUM AND

2660: );
2661: END IF;
2662:
2663: IF p_MODIFIER_LIST_rec.terms_id IS NOT NULL AND
2664: p_MODIFIER_LIST_rec.terms_id <> FND_API.G_MISS_NUM AND
2665: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.terms_id,
2666: p_old_MODIFIER_LIST_rec.terms_id)
2667: THEN
2668: l_MODIFIER_LIST_val_rec.terms := QP_Id_To_Value.Terms

Line 2691: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_SUCCESS;

2687:
2688: oe_debug_pub.add('BEGIN get_ids in QPXUMLHB');
2689: -- initialize return_status.
2690:
2691: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2692:
2693: -- initialize l_MODIFIER_LIST_rec.
2694:
2695: l_MODIFIER_LIST_rec := p_MODIFIER_LIST_rec;

Line 2697: IF p_MODIFIER_LIST_val_rec.automatic <> FND_API.G_MISS_CHAR

2693: -- initialize l_MODIFIER_LIST_rec.
2694:
2695: l_MODIFIER_LIST_rec := p_MODIFIER_LIST_rec;
2696:
2697: IF p_MODIFIER_LIST_val_rec.automatic <> FND_API.G_MISS_CHAR
2698: THEN
2699:
2700: IF p_MODIFIER_LIST_rec.automatic_flag <> FND_API.G_MISS_CHAR THEN
2701:

Line 2700: IF p_MODIFIER_LIST_rec.automatic_flag <> FND_API.G_MISS_CHAR THEN

2696:
2697: IF p_MODIFIER_LIST_val_rec.automatic <> FND_API.G_MISS_CHAR
2698: THEN
2699:
2700: IF p_MODIFIER_LIST_rec.automatic_flag <> FND_API.G_MISS_CHAR THEN
2701:
2702: l_MODIFIER_LIST_rec.automatic_flag := p_MODIFIER_LIST_rec.automatic_flag;
2703:
2704: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2719: IF l_MODIFIER_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN

2715: l_MODIFIER_LIST_rec.automatic_flag := QP_Value_To_Id.automatic
2716: ( p_automatic => p_MODIFIER_LIST_val_rec.automatic
2717: );
2718:
2719: IF l_MODIFIER_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
2720: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2721: END IF;
2722:
2723: END IF;

Line 2720: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

2716: ( p_automatic => p_MODIFIER_LIST_val_rec.automatic
2717: );
2718:
2719: IF l_MODIFIER_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
2720: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2721: END IF;
2722:
2723: END IF;
2724:

Line 2727: IF p_MODIFIER_LIST_val_rec.currency <> FND_API.G_MISS_CHAR

2723: END IF;
2724:
2725: END IF;
2726:
2727: IF p_MODIFIER_LIST_val_rec.currency <> FND_API.G_MISS_CHAR
2728: THEN
2729:
2730: IF p_MODIFIER_LIST_rec.currency_code <> FND_API.G_MISS_CHAR THEN
2731:

Line 2730: IF p_MODIFIER_LIST_rec.currency_code <> FND_API.G_MISS_CHAR THEN

2726:
2727: IF p_MODIFIER_LIST_val_rec.currency <> FND_API.G_MISS_CHAR
2728: THEN
2729:
2730: IF p_MODIFIER_LIST_rec.currency_code <> FND_API.G_MISS_CHAR THEN
2731:
2732: l_MODIFIER_LIST_rec.currency_code := p_MODIFIER_LIST_rec.currency_code;
2733:
2734: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2749: IF l_MODIFIER_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN

2745: l_MODIFIER_LIST_rec.currency_code := QP_Value_To_Id.currency
2746: ( p_currency => p_MODIFIER_LIST_val_rec.currency
2747: );
2748:
2749: IF l_MODIFIER_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN
2750: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2751: END IF;
2752:
2753: END IF;

Line 2750: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

2746: ( p_currency => p_MODIFIER_LIST_val_rec.currency
2747: );
2748:
2749: IF l_MODIFIER_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN
2750: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2751: END IF;
2752:
2753: END IF;
2754:

Line 2757: IF p_MODIFIER_LIST_val_rec.discount_lines <> FND_API.G_MISS_CHAR

2753: END IF;
2754:
2755: END IF;
2756:
2757: IF p_MODIFIER_LIST_val_rec.discount_lines <> FND_API.G_MISS_CHAR
2758: THEN
2759:
2760: IF p_MODIFIER_LIST_rec.discount_lines_flag <> FND_API.G_MISS_CHAR THEN
2761:

Line 2760: IF p_MODIFIER_LIST_rec.discount_lines_flag <> FND_API.G_MISS_CHAR THEN

2756:
2757: IF p_MODIFIER_LIST_val_rec.discount_lines <> FND_API.G_MISS_CHAR
2758: THEN
2759:
2760: IF p_MODIFIER_LIST_rec.discount_lines_flag <> FND_API.G_MISS_CHAR THEN
2761:
2762: l_MODIFIER_LIST_rec.discount_lines_flag := p_MODIFIER_LIST_rec.discount_lines_flag;
2763:
2764: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2779: IF l_MODIFIER_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN

2775: l_MODIFIER_LIST_rec.discount_lines_flag := QP_Value_To_Id.discount_lines
2776: ( p_discount_lines => p_MODIFIER_LIST_val_rec.discount_lines
2777: );
2778:
2779: IF l_MODIFIER_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN
2780: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2781: END IF;
2782:
2783: END IF;

Line 2780: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

2776: ( p_discount_lines => p_MODIFIER_LIST_val_rec.discount_lines
2777: );
2778:
2779: IF l_MODIFIER_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN
2780: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2781: END IF;
2782:
2783: END IF;
2784:

Line 2787: IF p_MODIFIER_LIST_val_rec.freight_terms <> FND_API.G_MISS_CHAR

2783: END IF;
2784:
2785: END IF;
2786:
2787: IF p_MODIFIER_LIST_val_rec.freight_terms <> FND_API.G_MISS_CHAR
2788: THEN
2789:
2790: IF p_MODIFIER_LIST_rec.freight_terms_code <> FND_API.G_MISS_CHAR THEN
2791:

Line 2790: IF p_MODIFIER_LIST_rec.freight_terms_code <> FND_API.G_MISS_CHAR THEN

2786:
2787: IF p_MODIFIER_LIST_val_rec.freight_terms <> FND_API.G_MISS_CHAR
2788: THEN
2789:
2790: IF p_MODIFIER_LIST_rec.freight_terms_code <> FND_API.G_MISS_CHAR THEN
2791:
2792: l_MODIFIER_LIST_rec.freight_terms_code := p_MODIFIER_LIST_rec.freight_terms_code;
2793:
2794: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2809: IF l_MODIFIER_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN

2805: l_MODIFIER_LIST_rec.freight_terms_code := QP_Value_To_Id.freight_terms
2806: ( p_freight_terms => p_MODIFIER_LIST_val_rec.freight_terms
2807: );
2808:
2809: IF l_MODIFIER_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
2810: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2811: END IF;
2812:
2813: END IF;

Line 2810: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

2806: ( p_freight_terms => p_MODIFIER_LIST_val_rec.freight_terms
2807: );
2808:
2809: IF l_MODIFIER_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
2810: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2811: END IF;
2812:
2813: END IF;
2814:

Line 2817: IF p_MODIFIER_LIST_val_rec.list_header <> FND_API.G_MISS_CHAR

2813: END IF;
2814:
2815: END IF;
2816:
2817: IF p_MODIFIER_LIST_val_rec.list_header <> FND_API.G_MISS_CHAR
2818: THEN
2819:
2820: IF p_MODIFIER_LIST_rec.list_header_id <> FND_API.G_MISS_NUM THEN
2821:

Line 2820: IF p_MODIFIER_LIST_rec.list_header_id <> FND_API.G_MISS_NUM THEN

2816:
2817: IF p_MODIFIER_LIST_val_rec.list_header <> FND_API.G_MISS_CHAR
2818: THEN
2819:
2820: IF p_MODIFIER_LIST_rec.list_header_id <> FND_API.G_MISS_NUM THEN
2821:
2822: l_MODIFIER_LIST_rec.list_header_id := p_MODIFIER_LIST_rec.list_header_id;
2823:
2824: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2839: IF l_MODIFIER_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN

2835: l_MODIFIER_LIST_rec.list_header_id := QP_Value_To_Id.list_header
2836: ( p_list_header => p_MODIFIER_LIST_val_rec.list_header
2837: );
2838:
2839: IF l_MODIFIER_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN
2840: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2841: END IF;
2842:
2843: END IF;

Line 2840: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

2836: ( p_list_header => p_MODIFIER_LIST_val_rec.list_header
2837: );
2838:
2839: IF l_MODIFIER_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN
2840: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2841: END IF;
2842:
2843: END IF;
2844:

Line 2847: IF p_MODIFIER_LIST_val_rec.list_type <> FND_API.G_MISS_CHAR

2843: END IF;
2844:
2845: END IF;
2846:
2847: IF p_MODIFIER_LIST_val_rec.list_type <> FND_API.G_MISS_CHAR
2848: THEN
2849:
2850: IF p_MODIFIER_LIST_rec.list_type_code <> FND_API.G_MISS_CHAR THEN
2851:

Line 2850: IF p_MODIFIER_LIST_rec.list_type_code <> FND_API.G_MISS_CHAR THEN

2846:
2847: IF p_MODIFIER_LIST_val_rec.list_type <> FND_API.G_MISS_CHAR
2848: THEN
2849:
2850: IF p_MODIFIER_LIST_rec.list_type_code <> FND_API.G_MISS_CHAR THEN
2851:
2852: l_MODIFIER_LIST_rec.list_type_code := p_MODIFIER_LIST_rec.list_type_code;
2853:
2854: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2869: IF l_MODIFIER_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN

2865: l_MODIFIER_LIST_rec.list_type_code := QP_Value_To_Id.list_type
2866: ( p_list_type => p_MODIFIER_LIST_val_rec.list_type
2867: );
2868:
2869: IF l_MODIFIER_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN
2870: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2871: END IF;
2872:
2873: END IF;

Line 2870: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

2866: ( p_list_type => p_MODIFIER_LIST_val_rec.list_type
2867: );
2868:
2869: IF l_MODIFIER_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN
2870: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2871: END IF;
2872:
2873: END IF;
2874:

Line 2877: IF p_MODIFIER_LIST_val_rec.prorate <> FND_API.G_MISS_CHAR

2873: END IF;
2874:
2875: END IF;
2876:
2877: IF p_MODIFIER_LIST_val_rec.prorate <> FND_API.G_MISS_CHAR
2878: THEN
2879:
2880: IF p_MODIFIER_LIST_rec.prorate_flag <> FND_API.G_MISS_CHAR THEN
2881:

Line 2880: IF p_MODIFIER_LIST_rec.prorate_flag <> FND_API.G_MISS_CHAR THEN

2876:
2877: IF p_MODIFIER_LIST_val_rec.prorate <> FND_API.G_MISS_CHAR
2878: THEN
2879:
2880: IF p_MODIFIER_LIST_rec.prorate_flag <> FND_API.G_MISS_CHAR THEN
2881:
2882: l_MODIFIER_LIST_rec.prorate_flag := p_MODIFIER_LIST_rec.prorate_flag;
2883:
2884: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2899: IF l_MODIFIER_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN

2895: l_MODIFIER_LIST_rec.prorate_flag := QP_Value_To_Id.prorate
2896: ( p_prorate => p_MODIFIER_LIST_val_rec.prorate
2897: );
2898:
2899: IF l_MODIFIER_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN
2900: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2901: END IF;
2902:
2903: END IF;

Line 2900: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

2896: ( p_prorate => p_MODIFIER_LIST_val_rec.prorate
2897: );
2898:
2899: IF l_MODIFIER_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN
2900: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2901: END IF;
2902:
2903: END IF;
2904:

Line 2907: IF p_MODIFIER_LIST_val_rec.ship_method <> FND_API.G_MISS_CHAR

2903: END IF;
2904:
2905: END IF;
2906:
2907: IF p_MODIFIER_LIST_val_rec.ship_method <> FND_API.G_MISS_CHAR
2908: THEN
2909:
2910: IF p_MODIFIER_LIST_rec.ship_method_code <> FND_API.G_MISS_CHAR THEN
2911:

Line 2910: IF p_MODIFIER_LIST_rec.ship_method_code <> FND_API.G_MISS_CHAR THEN

2906:
2907: IF p_MODIFIER_LIST_val_rec.ship_method <> FND_API.G_MISS_CHAR
2908: THEN
2909:
2910: IF p_MODIFIER_LIST_rec.ship_method_code <> FND_API.G_MISS_CHAR THEN
2911:
2912: l_MODIFIER_LIST_rec.ship_method_code := p_MODIFIER_LIST_rec.ship_method_code;
2913:
2914: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2929: IF l_MODIFIER_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN

2925: l_MODIFIER_LIST_rec.ship_method_code := QP_Value_To_Id.ship_method
2926: ( p_ship_method => p_MODIFIER_LIST_val_rec.ship_method
2927: );
2928:
2929: IF l_MODIFIER_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
2930: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2931: END IF;
2932:
2933: END IF;

Line 2930: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

2926: ( p_ship_method => p_MODIFIER_LIST_val_rec.ship_method
2927: );
2928:
2929: IF l_MODIFIER_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
2930: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2931: END IF;
2932:
2933: END IF;
2934:

Line 2937: IF p_MODIFIER_LIST_val_rec.terms <> FND_API.G_MISS_CHAR

2933: END IF;
2934:
2935: END IF;
2936:
2937: IF p_MODIFIER_LIST_val_rec.terms <> FND_API.G_MISS_CHAR
2938: THEN
2939:
2940: IF p_MODIFIER_LIST_rec.terms_id <> FND_API.G_MISS_NUM THEN
2941:

Line 2940: IF p_MODIFIER_LIST_rec.terms_id <> FND_API.G_MISS_NUM THEN

2936:
2937: IF p_MODIFIER_LIST_val_rec.terms <> FND_API.G_MISS_CHAR
2938: THEN
2939:
2940: IF p_MODIFIER_LIST_rec.terms_id <> FND_API.G_MISS_NUM THEN
2941:
2942: l_MODIFIER_LIST_rec.terms_id := p_MODIFIER_LIST_rec.terms_id;
2943:
2944: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2959: IF l_MODIFIER_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN

2955: l_MODIFIER_LIST_rec.terms_id := QP_Value_To_Id.terms
2956: ( p_terms => p_MODIFIER_LIST_val_rec.terms
2957: );
2958:
2959: IF l_MODIFIER_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN
2960: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2961: END IF;
2962:
2963: END IF;

Line 2960: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

2956: ( p_terms => p_MODIFIER_LIST_val_rec.terms
2957: );
2958:
2959: IF l_MODIFIER_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN
2960: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2961: END IF;
2962:
2963: END IF;
2964:

Line 3012: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3008: elsif l_current_segment_level = 'BOTH' then
3009: l_final_segment_level := 'LINE_BOTH';
3010: elsif l_current_segment_level = 'ORDER' then
3011: -- Unexpected Condition
3012: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3013: end if;
3014:
3015: elsif l_final_segment_level = 'ORDER' then
3016: if l_current_segment_level = 'ORDER' then

Line 3022: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3018: elsif l_current_segment_level = 'BOTH' then
3019: l_final_segment_level := 'ORDER_BOTH';
3020: elsif l_current_segment_level = 'LINE' then
3021: -- Unexpected Condition
3022: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3023: end if;
3024:
3025: elsif l_final_segment_level = 'BOTH' then
3026: if l_current_segment_level = 'LINE' then

Line 3039: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3035: if l_current_segment_level in ('LINE', 'BOTH') then
3036: l_final_segment_level := 'LINE_BOTH';
3037: elsif l_current_segment_level = 'ORDER' then
3038: -- Unexpected Condition
3039: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3040: end if;
3041:
3042: elsif l_final_segment_level = 'ORDER_BOTH' then
3043: if l_current_segment_level in ('ORDER', 'BOTH') then

Line 3047: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3043: if l_current_segment_level in ('ORDER', 'BOTH') then
3044: l_final_segment_level := 'ORDER_BOTH';
3045: elsif l_current_segment_level = 'LINE' then
3046: -- Unexpected Condition
3047: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3048: end if;
3049:
3050: end if; -- l_final_segment_level = 'LINE'
3051: end if; -- l_final_segment_level is NULL

Line 3059: WHEN FND_API.G_EXC_ERROR THEN

3055: return(l_final_segment_level);
3056:
3057: oe_debug_pub.add('End Get_Segment_Level_for_Group');
3058: EXCEPTION
3059: WHEN FND_API.G_EXC_ERROR THEN
3060: return(null);
3061:
3062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3063: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 3062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3058: EXCEPTION
3059: WHEN FND_API.G_EXC_ERROR THEN
3060: return(null);
3061:
3062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3063: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3064: OE_MSG_PUB.Add_Exc_Msg
3065: (G_PKG_NAME
3066: ,'Get_Segment_Level_for_Group');