[Home] [Help]
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_trolin_rec IN inv_move_order_pub.trolin_rec_type
13: , p_old_trolin_rec IN inv_move_order_pub.trolin_rec_type := inv_move_order_pub.g_miss_trolin_rec
14: , x_trolin_rec IN OUT NOCOPY inv_move_order_pub.trolin_rec_type
15: ) IS
23:
24: -- If attr_id is missing compare old and new records and for
25: -- every changed attribute clear its dependent fields.
26:
27: IF p_attr_id = fnd_api.g_miss_num THEN
28: IF NOT inv_globals.equal(p_trolin_rec.attribute1, p_old_trolin_rec.attribute1) THEN
29: l_index := l_index + 1;
30: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute1;
31: END IF;
1067: FUNCTION complete_record(p_trolin_rec IN inv_move_order_pub.trolin_rec_type, p_old_trolin_rec IN inv_move_order_pub.trolin_rec_type)
1068: RETURN inv_move_order_pub.trolin_rec_type IS
1069: l_trolin_rec inv_move_order_pub.trolin_rec_type := p_trolin_rec;
1070: BEGIN
1071: IF l_trolin_rec.attribute1 = fnd_api.g_miss_char THEN
1072: l_trolin_rec.attribute1 := p_old_trolin_rec.attribute1;
1073: END IF;
1074:
1075: IF l_trolin_rec.attribute10 = fnd_api.g_miss_char THEN
1071: IF l_trolin_rec.attribute1 = fnd_api.g_miss_char THEN
1072: l_trolin_rec.attribute1 := p_old_trolin_rec.attribute1;
1073: END IF;
1074:
1075: IF l_trolin_rec.attribute10 = fnd_api.g_miss_char THEN
1076: l_trolin_rec.attribute10 := p_old_trolin_rec.attribute10;
1077: END IF;
1078:
1079: IF l_trolin_rec.attribute11 = fnd_api.g_miss_char THEN
1075: IF l_trolin_rec.attribute10 = fnd_api.g_miss_char THEN
1076: l_trolin_rec.attribute10 := p_old_trolin_rec.attribute10;
1077: END IF;
1078:
1079: IF l_trolin_rec.attribute11 = fnd_api.g_miss_char THEN
1080: l_trolin_rec.attribute11 := p_old_trolin_rec.attribute11;
1081: END IF;
1082:
1083: IF l_trolin_rec.attribute12 = fnd_api.g_miss_char THEN
1079: IF l_trolin_rec.attribute11 = fnd_api.g_miss_char THEN
1080: l_trolin_rec.attribute11 := p_old_trolin_rec.attribute11;
1081: END IF;
1082:
1083: IF l_trolin_rec.attribute12 = fnd_api.g_miss_char THEN
1084: l_trolin_rec.attribute12 := p_old_trolin_rec.attribute12;
1085: END IF;
1086:
1087: IF l_trolin_rec.attribute13 = fnd_api.g_miss_char THEN
1083: IF l_trolin_rec.attribute12 = fnd_api.g_miss_char THEN
1084: l_trolin_rec.attribute12 := p_old_trolin_rec.attribute12;
1085: END IF;
1086:
1087: IF l_trolin_rec.attribute13 = fnd_api.g_miss_char THEN
1088: l_trolin_rec.attribute13 := p_old_trolin_rec.attribute13;
1089: END IF;
1090:
1091: IF l_trolin_rec.attribute14 = fnd_api.g_miss_char THEN
1087: IF l_trolin_rec.attribute13 = fnd_api.g_miss_char THEN
1088: l_trolin_rec.attribute13 := p_old_trolin_rec.attribute13;
1089: END IF;
1090:
1091: IF l_trolin_rec.attribute14 = fnd_api.g_miss_char THEN
1092: l_trolin_rec.attribute14 := p_old_trolin_rec.attribute14;
1093: END IF;
1094:
1095: IF l_trolin_rec.attribute15 = fnd_api.g_miss_char THEN
1091: IF l_trolin_rec.attribute14 = fnd_api.g_miss_char THEN
1092: l_trolin_rec.attribute14 := p_old_trolin_rec.attribute14;
1093: END IF;
1094:
1095: IF l_trolin_rec.attribute15 = fnd_api.g_miss_char THEN
1096: l_trolin_rec.attribute15 := p_old_trolin_rec.attribute15;
1097: END IF;
1098:
1099: IF l_trolin_rec.attribute2 = fnd_api.g_miss_char THEN
1095: IF l_trolin_rec.attribute15 = fnd_api.g_miss_char THEN
1096: l_trolin_rec.attribute15 := p_old_trolin_rec.attribute15;
1097: END IF;
1098:
1099: IF l_trolin_rec.attribute2 = fnd_api.g_miss_char THEN
1100: l_trolin_rec.attribute2 := p_old_trolin_rec.attribute2;
1101: END IF;
1102:
1103: IF l_trolin_rec.attribute3 = fnd_api.g_miss_char THEN
1099: IF l_trolin_rec.attribute2 = fnd_api.g_miss_char THEN
1100: l_trolin_rec.attribute2 := p_old_trolin_rec.attribute2;
1101: END IF;
1102:
1103: IF l_trolin_rec.attribute3 = fnd_api.g_miss_char THEN
1104: l_trolin_rec.attribute3 := p_old_trolin_rec.attribute3;
1105: END IF;
1106:
1107: IF l_trolin_rec.attribute4 = fnd_api.g_miss_char THEN
1103: IF l_trolin_rec.attribute3 = fnd_api.g_miss_char THEN
1104: l_trolin_rec.attribute3 := p_old_trolin_rec.attribute3;
1105: END IF;
1106:
1107: IF l_trolin_rec.attribute4 = fnd_api.g_miss_char THEN
1108: l_trolin_rec.attribute4 := p_old_trolin_rec.attribute4;
1109: END IF;
1110:
1111: IF l_trolin_rec.attribute5 = fnd_api.g_miss_char THEN
1107: IF l_trolin_rec.attribute4 = fnd_api.g_miss_char THEN
1108: l_trolin_rec.attribute4 := p_old_trolin_rec.attribute4;
1109: END IF;
1110:
1111: IF l_trolin_rec.attribute5 = fnd_api.g_miss_char THEN
1112: l_trolin_rec.attribute5 := p_old_trolin_rec.attribute5;
1113: END IF;
1114:
1115: IF l_trolin_rec.attribute6 = fnd_api.g_miss_char THEN
1111: IF l_trolin_rec.attribute5 = fnd_api.g_miss_char THEN
1112: l_trolin_rec.attribute5 := p_old_trolin_rec.attribute5;
1113: END IF;
1114:
1115: IF l_trolin_rec.attribute6 = fnd_api.g_miss_char THEN
1116: l_trolin_rec.attribute6 := p_old_trolin_rec.attribute6;
1117: END IF;
1118:
1119: IF l_trolin_rec.attribute7 = fnd_api.g_miss_char THEN
1115: IF l_trolin_rec.attribute6 = fnd_api.g_miss_char THEN
1116: l_trolin_rec.attribute6 := p_old_trolin_rec.attribute6;
1117: END IF;
1118:
1119: IF l_trolin_rec.attribute7 = fnd_api.g_miss_char THEN
1120: l_trolin_rec.attribute7 := p_old_trolin_rec.attribute7;
1121: END IF;
1122:
1123: IF l_trolin_rec.attribute8 = fnd_api.g_miss_char THEN
1119: IF l_trolin_rec.attribute7 = fnd_api.g_miss_char THEN
1120: l_trolin_rec.attribute7 := p_old_trolin_rec.attribute7;
1121: END IF;
1122:
1123: IF l_trolin_rec.attribute8 = fnd_api.g_miss_char THEN
1124: l_trolin_rec.attribute8 := p_old_trolin_rec.attribute8;
1125: END IF;
1126:
1127: IF l_trolin_rec.attribute9 = fnd_api.g_miss_char THEN
1123: IF l_trolin_rec.attribute8 = fnd_api.g_miss_char THEN
1124: l_trolin_rec.attribute8 := p_old_trolin_rec.attribute8;
1125: END IF;
1126:
1127: IF l_trolin_rec.attribute9 = fnd_api.g_miss_char THEN
1128: l_trolin_rec.attribute9 := p_old_trolin_rec.attribute9;
1129: END IF;
1130:
1131: IF l_trolin_rec.attribute_category = fnd_api.g_miss_char THEN
1127: IF l_trolin_rec.attribute9 = fnd_api.g_miss_char THEN
1128: l_trolin_rec.attribute9 := p_old_trolin_rec.attribute9;
1129: END IF;
1130:
1131: IF l_trolin_rec.attribute_category = fnd_api.g_miss_char THEN
1132: l_trolin_rec.attribute_category := p_old_trolin_rec.attribute_category;
1133: END IF;
1134:
1135: IF l_trolin_rec.created_by = fnd_api.g_miss_num THEN
1131: IF l_trolin_rec.attribute_category = fnd_api.g_miss_char THEN
1132: l_trolin_rec.attribute_category := p_old_trolin_rec.attribute_category;
1133: END IF;
1134:
1135: IF l_trolin_rec.created_by = fnd_api.g_miss_num THEN
1136: l_trolin_rec.created_by := p_old_trolin_rec.created_by;
1137: END IF;
1138:
1139: IF l_trolin_rec.creation_date = fnd_api.g_miss_date THEN
1135: IF l_trolin_rec.created_by = fnd_api.g_miss_num THEN
1136: l_trolin_rec.created_by := p_old_trolin_rec.created_by;
1137: END IF;
1138:
1139: IF l_trolin_rec.creation_date = fnd_api.g_miss_date THEN
1140: l_trolin_rec.creation_date := p_old_trolin_rec.creation_date;
1141: END IF;
1142:
1143: IF l_trolin_rec.date_required = fnd_api.g_miss_date THEN
1139: IF l_trolin_rec.creation_date = fnd_api.g_miss_date THEN
1140: l_trolin_rec.creation_date := p_old_trolin_rec.creation_date;
1141: END IF;
1142:
1143: IF l_trolin_rec.date_required = fnd_api.g_miss_date THEN
1144: l_trolin_rec.date_required := p_old_trolin_rec.date_required;
1145: END IF;
1146:
1147: IF l_trolin_rec.from_locator_id = fnd_api.g_miss_num THEN
1143: IF l_trolin_rec.date_required = fnd_api.g_miss_date THEN
1144: l_trolin_rec.date_required := p_old_trolin_rec.date_required;
1145: END IF;
1146:
1147: IF l_trolin_rec.from_locator_id = fnd_api.g_miss_num THEN
1148: l_trolin_rec.from_locator_id := p_old_trolin_rec.from_locator_id;
1149: END IF;
1150:
1151: IF l_trolin_rec.from_subinventory_code = fnd_api.g_miss_char THEN
1147: IF l_trolin_rec.from_locator_id = fnd_api.g_miss_num THEN
1148: l_trolin_rec.from_locator_id := p_old_trolin_rec.from_locator_id;
1149: END IF;
1150:
1151: IF l_trolin_rec.from_subinventory_code = fnd_api.g_miss_char THEN
1152: l_trolin_rec.from_subinventory_code := p_old_trolin_rec.from_subinventory_code;
1153: END IF;
1154:
1155: IF l_trolin_rec.from_subinventory_id = fnd_api.g_miss_num THEN
1151: IF l_trolin_rec.from_subinventory_code = fnd_api.g_miss_char THEN
1152: l_trolin_rec.from_subinventory_code := p_old_trolin_rec.from_subinventory_code;
1153: END IF;
1154:
1155: IF l_trolin_rec.from_subinventory_id = fnd_api.g_miss_num THEN
1156: l_trolin_rec.from_subinventory_id := p_old_trolin_rec.from_subinventory_id;
1157: END IF;
1158:
1159: IF l_trolin_rec.header_id = fnd_api.g_miss_num THEN
1155: IF l_trolin_rec.from_subinventory_id = fnd_api.g_miss_num THEN
1156: l_trolin_rec.from_subinventory_id := p_old_trolin_rec.from_subinventory_id;
1157: END IF;
1158:
1159: IF l_trolin_rec.header_id = fnd_api.g_miss_num THEN
1160: l_trolin_rec.header_id := p_old_trolin_rec.header_id;
1161: END IF;
1162:
1163: IF l_trolin_rec.inventory_item_id = fnd_api.g_miss_num THEN
1159: IF l_trolin_rec.header_id = fnd_api.g_miss_num THEN
1160: l_trolin_rec.header_id := p_old_trolin_rec.header_id;
1161: END IF;
1162:
1163: IF l_trolin_rec.inventory_item_id = fnd_api.g_miss_num THEN
1164: l_trolin_rec.inventory_item_id := p_old_trolin_rec.inventory_item_id;
1165: END IF;
1166:
1167: IF l_trolin_rec.last_updated_by = fnd_api.g_miss_num THEN
1163: IF l_trolin_rec.inventory_item_id = fnd_api.g_miss_num THEN
1164: l_trolin_rec.inventory_item_id := p_old_trolin_rec.inventory_item_id;
1165: END IF;
1166:
1167: IF l_trolin_rec.last_updated_by = fnd_api.g_miss_num THEN
1168: l_trolin_rec.last_updated_by := p_old_trolin_rec.last_updated_by;
1169: END IF;
1170:
1171: IF l_trolin_rec.last_update_date = fnd_api.g_miss_date THEN
1167: IF l_trolin_rec.last_updated_by = fnd_api.g_miss_num THEN
1168: l_trolin_rec.last_updated_by := p_old_trolin_rec.last_updated_by;
1169: END IF;
1170:
1171: IF l_trolin_rec.last_update_date = fnd_api.g_miss_date THEN
1172: l_trolin_rec.last_update_date := p_old_trolin_rec.last_update_date;
1173: END IF;
1174:
1175: IF l_trolin_rec.last_update_login = fnd_api.g_miss_num THEN
1171: IF l_trolin_rec.last_update_date = fnd_api.g_miss_date THEN
1172: l_trolin_rec.last_update_date := p_old_trolin_rec.last_update_date;
1173: END IF;
1174:
1175: IF l_trolin_rec.last_update_login = fnd_api.g_miss_num THEN
1176: l_trolin_rec.last_update_login := p_old_trolin_rec.last_update_login;
1177: END IF;
1178:
1179: IF l_trolin_rec.line_id = fnd_api.g_miss_num THEN
1175: IF l_trolin_rec.last_update_login = fnd_api.g_miss_num THEN
1176: l_trolin_rec.last_update_login := p_old_trolin_rec.last_update_login;
1177: END IF;
1178:
1179: IF l_trolin_rec.line_id = fnd_api.g_miss_num THEN
1180: l_trolin_rec.line_id := p_old_trolin_rec.line_id;
1181: END IF;
1182:
1183: IF l_trolin_rec.line_number = fnd_api.g_miss_num THEN
1179: IF l_trolin_rec.line_id = fnd_api.g_miss_num THEN
1180: l_trolin_rec.line_id := p_old_trolin_rec.line_id;
1181: END IF;
1182:
1183: IF l_trolin_rec.line_number = fnd_api.g_miss_num THEN
1184: l_trolin_rec.line_number := p_old_trolin_rec.line_number;
1185: END IF;
1186:
1187: IF l_trolin_rec.line_status = fnd_api.g_miss_num THEN
1183: IF l_trolin_rec.line_number = fnd_api.g_miss_num THEN
1184: l_trolin_rec.line_number := p_old_trolin_rec.line_number;
1185: END IF;
1186:
1187: IF l_trolin_rec.line_status = fnd_api.g_miss_num THEN
1188: l_trolin_rec.line_status := p_old_trolin_rec.line_status;
1189: END IF;
1190:
1191: IF l_trolin_rec.lot_number = fnd_api.g_miss_char THEN
1187: IF l_trolin_rec.line_status = fnd_api.g_miss_num THEN
1188: l_trolin_rec.line_status := p_old_trolin_rec.line_status;
1189: END IF;
1190:
1191: IF l_trolin_rec.lot_number = fnd_api.g_miss_char THEN
1192: l_trolin_rec.lot_number := p_old_trolin_rec.lot_number;
1193: END IF;
1194:
1195: IF l_trolin_rec.organization_id = fnd_api.g_miss_num THEN
1191: IF l_trolin_rec.lot_number = fnd_api.g_miss_char THEN
1192: l_trolin_rec.lot_number := p_old_trolin_rec.lot_number;
1193: END IF;
1194:
1195: IF l_trolin_rec.organization_id = fnd_api.g_miss_num THEN
1196: l_trolin_rec.organization_id := p_old_trolin_rec.organization_id;
1197: END IF;
1198:
1199: IF l_trolin_rec.program_application_id = fnd_api.g_miss_num THEN
1195: IF l_trolin_rec.organization_id = fnd_api.g_miss_num THEN
1196: l_trolin_rec.organization_id := p_old_trolin_rec.organization_id;
1197: END IF;
1198:
1199: IF l_trolin_rec.program_application_id = fnd_api.g_miss_num THEN
1200: l_trolin_rec.program_application_id := p_old_trolin_rec.program_application_id;
1201: END IF;
1202:
1203: IF l_trolin_rec.program_id = fnd_api.g_miss_num THEN
1199: IF l_trolin_rec.program_application_id = fnd_api.g_miss_num THEN
1200: l_trolin_rec.program_application_id := p_old_trolin_rec.program_application_id;
1201: END IF;
1202:
1203: IF l_trolin_rec.program_id = fnd_api.g_miss_num THEN
1204: l_trolin_rec.program_id := p_old_trolin_rec.program_id;
1205: END IF;
1206:
1207: IF l_trolin_rec.program_update_date = fnd_api.g_miss_date THEN
1203: IF l_trolin_rec.program_id = fnd_api.g_miss_num THEN
1204: l_trolin_rec.program_id := p_old_trolin_rec.program_id;
1205: END IF;
1206:
1207: IF l_trolin_rec.program_update_date = fnd_api.g_miss_date THEN
1208: l_trolin_rec.program_update_date := p_old_trolin_rec.program_update_date;
1209: END IF;
1210:
1211: IF l_trolin_rec.project_id = fnd_api.g_miss_num THEN
1207: IF l_trolin_rec.program_update_date = fnd_api.g_miss_date THEN
1208: l_trolin_rec.program_update_date := p_old_trolin_rec.program_update_date;
1209: END IF;
1210:
1211: IF l_trolin_rec.project_id = fnd_api.g_miss_num THEN
1212: l_trolin_rec.project_id := p_old_trolin_rec.project_id;
1213: END IF;
1214:
1215: IF l_trolin_rec.quantity = fnd_api.g_miss_num THEN
1211: IF l_trolin_rec.project_id = fnd_api.g_miss_num THEN
1212: l_trolin_rec.project_id := p_old_trolin_rec.project_id;
1213: END IF;
1214:
1215: IF l_trolin_rec.quantity = fnd_api.g_miss_num THEN
1216: l_trolin_rec.quantity := p_old_trolin_rec.quantity;
1217: END IF;
1218:
1219: IF l_trolin_rec.quantity_delivered = fnd_api.g_miss_num THEN
1215: IF l_trolin_rec.quantity = fnd_api.g_miss_num THEN
1216: l_trolin_rec.quantity := p_old_trolin_rec.quantity;
1217: END IF;
1218:
1219: IF l_trolin_rec.quantity_delivered = fnd_api.g_miss_num THEN
1220: l_trolin_rec.quantity_delivered := p_old_trolin_rec.quantity_delivered;
1221: END IF;
1222:
1223: IF l_trolin_rec.quantity_detailed = fnd_api.g_miss_num THEN
1219: IF l_trolin_rec.quantity_delivered = fnd_api.g_miss_num THEN
1220: l_trolin_rec.quantity_delivered := p_old_trolin_rec.quantity_delivered;
1221: END IF;
1222:
1223: IF l_trolin_rec.quantity_detailed = fnd_api.g_miss_num THEN
1224: l_trolin_rec.quantity_detailed := p_old_trolin_rec.quantity_detailed;
1225: END IF;
1226:
1227: IF l_trolin_rec.reason_id = fnd_api.g_miss_num THEN
1223: IF l_trolin_rec.quantity_detailed = fnd_api.g_miss_num THEN
1224: l_trolin_rec.quantity_detailed := p_old_trolin_rec.quantity_detailed;
1225: END IF;
1226:
1227: IF l_trolin_rec.reason_id = fnd_api.g_miss_num THEN
1228: l_trolin_rec.reason_id := p_old_trolin_rec.reason_id;
1229: END IF;
1230:
1231: IF l_trolin_rec.REFERENCE = fnd_api.g_miss_char THEN
1227: IF l_trolin_rec.reason_id = fnd_api.g_miss_num THEN
1228: l_trolin_rec.reason_id := p_old_trolin_rec.reason_id;
1229: END IF;
1230:
1231: IF l_trolin_rec.REFERENCE = fnd_api.g_miss_char THEN
1232: l_trolin_rec.REFERENCE := p_old_trolin_rec.REFERENCE;
1233: END IF;
1234:
1235: IF l_trolin_rec.reference_id = fnd_api.g_miss_num THEN
1231: IF l_trolin_rec.REFERENCE = fnd_api.g_miss_char THEN
1232: l_trolin_rec.REFERENCE := p_old_trolin_rec.REFERENCE;
1233: END IF;
1234:
1235: IF l_trolin_rec.reference_id = fnd_api.g_miss_num THEN
1236: l_trolin_rec.reference_id := p_old_trolin_rec.reference_id;
1237: END IF;
1238:
1239: IF l_trolin_rec.reference_type_code = fnd_api.g_miss_num THEN
1235: IF l_trolin_rec.reference_id = fnd_api.g_miss_num THEN
1236: l_trolin_rec.reference_id := p_old_trolin_rec.reference_id;
1237: END IF;
1238:
1239: IF l_trolin_rec.reference_type_code = fnd_api.g_miss_num THEN
1240: l_trolin_rec.reference_type_code := p_old_trolin_rec.reference_type_code;
1241: END IF;
1242:
1243: IF l_trolin_rec.request_id = fnd_api.g_miss_num THEN
1239: IF l_trolin_rec.reference_type_code = fnd_api.g_miss_num THEN
1240: l_trolin_rec.reference_type_code := p_old_trolin_rec.reference_type_code;
1241: END IF;
1242:
1243: IF l_trolin_rec.request_id = fnd_api.g_miss_num THEN
1244: l_trolin_rec.request_id := p_old_trolin_rec.request_id;
1245: END IF;
1246:
1247: IF l_trolin_rec.revision = fnd_api.g_miss_char THEN
1243: IF l_trolin_rec.request_id = fnd_api.g_miss_num THEN
1244: l_trolin_rec.request_id := p_old_trolin_rec.request_id;
1245: END IF;
1246:
1247: IF l_trolin_rec.revision = fnd_api.g_miss_char THEN
1248: l_trolin_rec.revision := p_old_trolin_rec.revision;
1249: END IF;
1250:
1251: IF l_trolin_rec.serial_number_end = fnd_api.g_miss_char THEN
1247: IF l_trolin_rec.revision = fnd_api.g_miss_char THEN
1248: l_trolin_rec.revision := p_old_trolin_rec.revision;
1249: END IF;
1250:
1251: IF l_trolin_rec.serial_number_end = fnd_api.g_miss_char THEN
1252: l_trolin_rec.serial_number_end := p_old_trolin_rec.serial_number_end;
1253: END IF;
1254:
1255: IF l_trolin_rec.serial_number_start = fnd_api.g_miss_char THEN
1251: IF l_trolin_rec.serial_number_end = fnd_api.g_miss_char THEN
1252: l_trolin_rec.serial_number_end := p_old_trolin_rec.serial_number_end;
1253: END IF;
1254:
1255: IF l_trolin_rec.serial_number_start = fnd_api.g_miss_char THEN
1256: l_trolin_rec.serial_number_start := p_old_trolin_rec.serial_number_start;
1257: END IF;
1258:
1259: IF l_trolin_rec.status_date = fnd_api.g_miss_date THEN
1255: IF l_trolin_rec.serial_number_start = fnd_api.g_miss_char THEN
1256: l_trolin_rec.serial_number_start := p_old_trolin_rec.serial_number_start;
1257: END IF;
1258:
1259: IF l_trolin_rec.status_date = fnd_api.g_miss_date THEN
1260: l_trolin_rec.status_date := p_old_trolin_rec.status_date;
1261: END IF;
1262:
1263: IF l_trolin_rec.task_id = fnd_api.g_miss_num THEN
1259: IF l_trolin_rec.status_date = fnd_api.g_miss_date THEN
1260: l_trolin_rec.status_date := p_old_trolin_rec.status_date;
1261: END IF;
1262:
1263: IF l_trolin_rec.task_id = fnd_api.g_miss_num THEN
1264: l_trolin_rec.task_id := p_old_trolin_rec.task_id;
1265: END IF;
1266:
1267: IF l_trolin_rec.to_account_id = fnd_api.g_miss_num THEN
1263: IF l_trolin_rec.task_id = fnd_api.g_miss_num THEN
1264: l_trolin_rec.task_id := p_old_trolin_rec.task_id;
1265: END IF;
1266:
1267: IF l_trolin_rec.to_account_id = fnd_api.g_miss_num THEN
1268: l_trolin_rec.to_account_id := p_old_trolin_rec.to_account_id;
1269: END IF;
1270:
1271: IF l_trolin_rec.to_locator_id = fnd_api.g_miss_num THEN
1267: IF l_trolin_rec.to_account_id = fnd_api.g_miss_num THEN
1268: l_trolin_rec.to_account_id := p_old_trolin_rec.to_account_id;
1269: END IF;
1270:
1271: IF l_trolin_rec.to_locator_id = fnd_api.g_miss_num THEN
1272: l_trolin_rec.to_locator_id := p_old_trolin_rec.to_locator_id;
1273: END IF;
1274:
1275: IF l_trolin_rec.to_subinventory_code = fnd_api.g_miss_char THEN
1271: IF l_trolin_rec.to_locator_id = fnd_api.g_miss_num THEN
1272: l_trolin_rec.to_locator_id := p_old_trolin_rec.to_locator_id;
1273: END IF;
1274:
1275: IF l_trolin_rec.to_subinventory_code = fnd_api.g_miss_char THEN
1276: l_trolin_rec.to_subinventory_code := p_old_trolin_rec.to_subinventory_code;
1277: END IF;
1278:
1279: IF l_trolin_rec.to_subinventory_id = fnd_api.g_miss_num THEN
1275: IF l_trolin_rec.to_subinventory_code = fnd_api.g_miss_char THEN
1276: l_trolin_rec.to_subinventory_code := p_old_trolin_rec.to_subinventory_code;
1277: END IF;
1278:
1279: IF l_trolin_rec.to_subinventory_id = fnd_api.g_miss_num THEN
1280: l_trolin_rec.to_subinventory_id := p_old_trolin_rec.to_subinventory_id;
1281: END IF;
1282:
1283: IF l_trolin_rec.transaction_header_id = fnd_api.g_miss_num THEN
1279: IF l_trolin_rec.to_subinventory_id = fnd_api.g_miss_num THEN
1280: l_trolin_rec.to_subinventory_id := p_old_trolin_rec.to_subinventory_id;
1281: END IF;
1282:
1283: IF l_trolin_rec.transaction_header_id = fnd_api.g_miss_num THEN
1284: l_trolin_rec.transaction_header_id := p_old_trolin_rec.transaction_header_id;
1285: END IF;
1286:
1287: IF l_trolin_rec.uom_code = fnd_api.g_miss_char THEN
1283: IF l_trolin_rec.transaction_header_id = fnd_api.g_miss_num THEN
1284: l_trolin_rec.transaction_header_id := p_old_trolin_rec.transaction_header_id;
1285: END IF;
1286:
1287: IF l_trolin_rec.uom_code = fnd_api.g_miss_char THEN
1288: l_trolin_rec.uom_code := p_old_trolin_rec.uom_code;
1289: END IF;
1290:
1291: IF l_trolin_rec.transaction_type_id = fnd_api.g_miss_num THEN
1287: IF l_trolin_rec.uom_code = fnd_api.g_miss_char THEN
1288: l_trolin_rec.uom_code := p_old_trolin_rec.uom_code;
1289: END IF;
1290:
1291: IF l_trolin_rec.transaction_type_id = fnd_api.g_miss_num THEN
1292: l_trolin_rec.transaction_type_id := p_old_trolin_rec.transaction_type_id;
1293: END IF;
1294:
1295: IF l_trolin_rec.transaction_source_type_id = fnd_api.g_miss_num THEN
1291: IF l_trolin_rec.transaction_type_id = fnd_api.g_miss_num THEN
1292: l_trolin_rec.transaction_type_id := p_old_trolin_rec.transaction_type_id;
1293: END IF;
1294:
1295: IF l_trolin_rec.transaction_source_type_id = fnd_api.g_miss_num THEN
1296: l_trolin_rec.transaction_source_type_id := p_old_trolin_rec.transaction_source_type_id;
1297: END IF;
1298:
1299: IF l_trolin_rec.txn_source_id = fnd_api.g_miss_num THEN
1295: IF l_trolin_rec.transaction_source_type_id = fnd_api.g_miss_num THEN
1296: l_trolin_rec.transaction_source_type_id := p_old_trolin_rec.transaction_source_type_id;
1297: END IF;
1298:
1299: IF l_trolin_rec.txn_source_id = fnd_api.g_miss_num THEN
1300: l_trolin_rec.txn_source_id := p_old_trolin_rec.txn_source_id;
1301: END IF;
1302:
1303: IF l_trolin_rec.txn_source_line_id = fnd_api.g_miss_num THEN
1299: IF l_trolin_rec.txn_source_id = fnd_api.g_miss_num THEN
1300: l_trolin_rec.txn_source_id := p_old_trolin_rec.txn_source_id;
1301: END IF;
1302:
1303: IF l_trolin_rec.txn_source_line_id = fnd_api.g_miss_num THEN
1304: l_trolin_rec.txn_source_line_id := p_old_trolin_rec.txn_source_line_id;
1305: END IF;
1306:
1307: IF l_trolin_rec.txn_source_line_detail_id = fnd_api.g_miss_num THEN
1303: IF l_trolin_rec.txn_source_line_id = fnd_api.g_miss_num THEN
1304: l_trolin_rec.txn_source_line_id := p_old_trolin_rec.txn_source_line_id;
1305: END IF;
1306:
1307: IF l_trolin_rec.txn_source_line_detail_id = fnd_api.g_miss_num THEN
1308: l_trolin_rec.txn_source_line_detail_id := p_old_trolin_rec.txn_source_line_detail_id;
1309: END IF;
1310:
1311: IF l_trolin_rec.primary_quantity = fnd_api.g_miss_num THEN
1307: IF l_trolin_rec.txn_source_line_detail_id = fnd_api.g_miss_num THEN
1308: l_trolin_rec.txn_source_line_detail_id := p_old_trolin_rec.txn_source_line_detail_id;
1309: END IF;
1310:
1311: IF l_trolin_rec.primary_quantity = fnd_api.g_miss_num THEN
1312: l_trolin_rec.primary_quantity := p_old_trolin_rec.primary_quantity;
1313: END IF;
1314:
1315: IF l_trolin_rec.to_organization_id = fnd_api.g_miss_num THEN
1311: IF l_trolin_rec.primary_quantity = fnd_api.g_miss_num THEN
1312: l_trolin_rec.primary_quantity := p_old_trolin_rec.primary_quantity;
1313: END IF;
1314:
1315: IF l_trolin_rec.to_organization_id = fnd_api.g_miss_num THEN
1316: l_trolin_rec.to_organization_id := p_old_trolin_rec.to_organization_id;
1317: END IF;
1318:
1319: IF l_trolin_rec.pick_strategy_id = fnd_api.g_miss_num THEN
1315: IF l_trolin_rec.to_organization_id = fnd_api.g_miss_num THEN
1316: l_trolin_rec.to_organization_id := p_old_trolin_rec.to_organization_id;
1317: END IF;
1318:
1319: IF l_trolin_rec.pick_strategy_id = fnd_api.g_miss_num THEN
1320: l_trolin_rec.pick_strategy_id := p_old_trolin_rec.pick_strategy_id;
1321: END IF;
1322:
1323: IF l_trolin_rec.put_away_strategy_id = fnd_api.g_miss_num THEN
1319: IF l_trolin_rec.pick_strategy_id = fnd_api.g_miss_num THEN
1320: l_trolin_rec.pick_strategy_id := p_old_trolin_rec.pick_strategy_id;
1321: END IF;
1322:
1323: IF l_trolin_rec.put_away_strategy_id = fnd_api.g_miss_num THEN
1324: l_trolin_rec.put_away_strategy_id := p_old_trolin_rec.put_away_strategy_id;
1325: END IF;
1326:
1327: IF l_trolin_rec.unit_number = fnd_api.g_miss_char THEN
1323: IF l_trolin_rec.put_away_strategy_id = fnd_api.g_miss_num THEN
1324: l_trolin_rec.put_away_strategy_id := p_old_trolin_rec.put_away_strategy_id;
1325: END IF;
1326:
1327: IF l_trolin_rec.unit_number = fnd_api.g_miss_char THEN
1328: l_trolin_rec.unit_number := p_old_trolin_rec.unit_number;
1329: END IF;
1330:
1331: IF l_trolin_rec.ship_to_location_id = fnd_api.g_miss_num THEN
1327: IF l_trolin_rec.unit_number = fnd_api.g_miss_char THEN
1328: l_trolin_rec.unit_number := p_old_trolin_rec.unit_number;
1329: END IF;
1330:
1331: IF l_trolin_rec.ship_to_location_id = fnd_api.g_miss_num THEN
1332: l_trolin_rec.ship_to_location_id := p_old_trolin_rec.ship_to_location_id;
1333: END IF;
1334:
1335: IF l_trolin_rec.from_cost_group_id = fnd_api.g_miss_num THEN
1331: IF l_trolin_rec.ship_to_location_id = fnd_api.g_miss_num THEN
1332: l_trolin_rec.ship_to_location_id := p_old_trolin_rec.ship_to_location_id;
1333: END IF;
1334:
1335: IF l_trolin_rec.from_cost_group_id = fnd_api.g_miss_num THEN
1336: l_trolin_rec.from_cost_group_id := p_old_trolin_rec.from_cost_group_id;
1337: END IF;
1338:
1339: IF l_trolin_rec.to_cost_group_id = fnd_api.g_miss_num THEN
1335: IF l_trolin_rec.from_cost_group_id = fnd_api.g_miss_num THEN
1336: l_trolin_rec.from_cost_group_id := p_old_trolin_rec.from_cost_group_id;
1337: END IF;
1338:
1339: IF l_trolin_rec.to_cost_group_id = fnd_api.g_miss_num THEN
1340: l_trolin_rec.to_cost_group_id := p_old_trolin_rec.to_cost_group_id;
1341: END IF;
1342:
1343: IF l_trolin_rec.lpn_id = fnd_api.g_miss_num THEN
1339: IF l_trolin_rec.to_cost_group_id = fnd_api.g_miss_num THEN
1340: l_trolin_rec.to_cost_group_id := p_old_trolin_rec.to_cost_group_id;
1341: END IF;
1342:
1343: IF l_trolin_rec.lpn_id = fnd_api.g_miss_num THEN
1344: l_trolin_rec.lpn_id := p_old_trolin_rec.lpn_id;
1345: END IF;
1346:
1347: IF l_trolin_rec.to_lpn_id = fnd_api.g_miss_num THEN
1343: IF l_trolin_rec.lpn_id = fnd_api.g_miss_num THEN
1344: l_trolin_rec.lpn_id := p_old_trolin_rec.lpn_id;
1345: END IF;
1346:
1347: IF l_trolin_rec.to_lpn_id = fnd_api.g_miss_num THEN
1348: l_trolin_rec.to_lpn_id := p_old_trolin_rec.to_lpn_id;
1349: END IF;
1350:
1351: IF l_trolin_rec.pick_methodology_id = fnd_api.g_miss_num THEN
1347: IF l_trolin_rec.to_lpn_id = fnd_api.g_miss_num THEN
1348: l_trolin_rec.to_lpn_id := p_old_trolin_rec.to_lpn_id;
1349: END IF;
1350:
1351: IF l_trolin_rec.pick_methodology_id = fnd_api.g_miss_num THEN
1352: l_trolin_rec.pick_methodology_id := p_old_trolin_rec.pick_methodology_id;
1353: END IF;
1354:
1355: IF l_trolin_rec.container_item_id = fnd_api.g_miss_num THEN
1351: IF l_trolin_rec.pick_methodology_id = fnd_api.g_miss_num THEN
1352: l_trolin_rec.pick_methodology_id := p_old_trolin_rec.pick_methodology_id;
1353: END IF;
1354:
1355: IF l_trolin_rec.container_item_id = fnd_api.g_miss_num THEN
1356: l_trolin_rec.container_item_id := p_old_trolin_rec.container_item_id;
1357: END IF;
1358:
1359: IF l_trolin_rec.carton_grouping_id = fnd_api.g_miss_num THEN
1355: IF l_trolin_rec.container_item_id = fnd_api.g_miss_num THEN
1356: l_trolin_rec.container_item_id := p_old_trolin_rec.container_item_id;
1357: END IF;
1358:
1359: IF l_trolin_rec.carton_grouping_id = fnd_api.g_miss_num THEN
1360: l_trolin_rec.carton_grouping_id := p_old_trolin_rec.carton_grouping_id;
1361: END IF;
1362:
1363: --INVCONV BEGIN
1360: l_trolin_rec.carton_grouping_id := p_old_trolin_rec.carton_grouping_id;
1361: END IF;
1362:
1363: --INVCONV BEGIN
1364: IF l_trolin_rec.secondary_quantity = fnd_api.g_miss_num THEN
1365: l_trolin_rec.secondary_quantity := p_old_trolin_rec.secondary_quantity;
1366: END IF;
1367:
1368: --Bug #4565509 - Should update secondary quantities from old records
1365: l_trolin_rec.secondary_quantity := p_old_trolin_rec.secondary_quantity;
1366: END IF;
1367:
1368: --Bug #4565509 - Should update secondary quantities from old records
1369: IF l_trolin_rec.secondary_quantity_delivered = fnd_api.g_miss_num THEN
1370: l_trolin_rec.secondary_quantity_delivered := p_old_trolin_rec.secondary_quantity_delivered;
1371: END IF;
1372:
1373: IF l_trolin_rec.secondary_quantity_detailed = fnd_api.g_miss_num THEN
1369: IF l_trolin_rec.secondary_quantity_delivered = fnd_api.g_miss_num THEN
1370: l_trolin_rec.secondary_quantity_delivered := p_old_trolin_rec.secondary_quantity_delivered;
1371: END IF;
1372:
1373: IF l_trolin_rec.secondary_quantity_detailed = fnd_api.g_miss_num THEN
1374: l_trolin_rec.secondary_quantity_detailed := p_old_trolin_rec.secondary_quantity_detailed;
1375: END IF;
1376:
1377: IF l_trolin_rec.secondary_uom = fnd_api.g_miss_char THEN
1373: IF l_trolin_rec.secondary_quantity_detailed = fnd_api.g_miss_num THEN
1374: l_trolin_rec.secondary_quantity_detailed := p_old_trolin_rec.secondary_quantity_detailed;
1375: END IF;
1376:
1377: IF l_trolin_rec.secondary_uom = fnd_api.g_miss_char THEN
1378: l_trolin_rec.secondary_uom := p_old_trolin_rec.secondary_uom;
1379: END IF;
1380:
1381: IF l_trolin_rec.grade_code = fnd_api.g_miss_char THEN
1377: IF l_trolin_rec.secondary_uom = fnd_api.g_miss_char THEN
1378: l_trolin_rec.secondary_uom := p_old_trolin_rec.secondary_uom;
1379: END IF;
1380:
1381: IF l_trolin_rec.grade_code = fnd_api.g_miss_char THEN
1382: l_trolin_rec.grade_code := p_old_trolin_rec.grade_code;
1383: END IF;
1384:
1385: -- INVCONV END;
1393: RETURN inv_move_order_pub.trolin_rec_type IS
1394: l_trolin_rec inv_move_order_pub.trolin_rec_type := p_trolin_rec;
1395: BEGIN
1396: /*inv_debug.message('in convert');*/
1397: IF l_trolin_rec.attribute1 = fnd_api.g_miss_char THEN
1398: l_trolin_rec.attribute1 := NULL;
1399: END IF;
1400:
1401: IF l_trolin_rec.attribute10 = fnd_api.g_miss_char THEN
1397: IF l_trolin_rec.attribute1 = fnd_api.g_miss_char THEN
1398: l_trolin_rec.attribute1 := NULL;
1399: END IF;
1400:
1401: IF l_trolin_rec.attribute10 = fnd_api.g_miss_char THEN
1402: l_trolin_rec.attribute10 := NULL;
1403: END IF;
1404:
1405: IF l_trolin_rec.attribute11 = fnd_api.g_miss_char THEN
1401: IF l_trolin_rec.attribute10 = fnd_api.g_miss_char THEN
1402: l_trolin_rec.attribute10 := NULL;
1403: END IF;
1404:
1405: IF l_trolin_rec.attribute11 = fnd_api.g_miss_char THEN
1406: l_trolin_rec.attribute11 := NULL;
1407: END IF;
1408:
1409: IF l_trolin_rec.attribute12 = fnd_api.g_miss_char THEN
1405: IF l_trolin_rec.attribute11 = fnd_api.g_miss_char THEN
1406: l_trolin_rec.attribute11 := NULL;
1407: END IF;
1408:
1409: IF l_trolin_rec.attribute12 = fnd_api.g_miss_char THEN
1410: l_trolin_rec.attribute12 := NULL;
1411: END IF;
1412:
1413: IF l_trolin_rec.attribute13 = fnd_api.g_miss_char THEN
1409: IF l_trolin_rec.attribute12 = fnd_api.g_miss_char THEN
1410: l_trolin_rec.attribute12 := NULL;
1411: END IF;
1412:
1413: IF l_trolin_rec.attribute13 = fnd_api.g_miss_char THEN
1414: l_trolin_rec.attribute13 := NULL;
1415: END IF;
1416:
1417: IF l_trolin_rec.attribute14 = fnd_api.g_miss_char THEN
1413: IF l_trolin_rec.attribute13 = fnd_api.g_miss_char THEN
1414: l_trolin_rec.attribute13 := NULL;
1415: END IF;
1416:
1417: IF l_trolin_rec.attribute14 = fnd_api.g_miss_char THEN
1418: l_trolin_rec.attribute14 := NULL;
1419: END IF;
1420:
1421: IF l_trolin_rec.attribute15 = fnd_api.g_miss_char THEN
1417: IF l_trolin_rec.attribute14 = fnd_api.g_miss_char THEN
1418: l_trolin_rec.attribute14 := NULL;
1419: END IF;
1420:
1421: IF l_trolin_rec.attribute15 = fnd_api.g_miss_char THEN
1422: l_trolin_rec.attribute15 := NULL;
1423: END IF;
1424:
1425: IF l_trolin_rec.attribute2 = fnd_api.g_miss_char THEN
1421: IF l_trolin_rec.attribute15 = fnd_api.g_miss_char THEN
1422: l_trolin_rec.attribute15 := NULL;
1423: END IF;
1424:
1425: IF l_trolin_rec.attribute2 = fnd_api.g_miss_char THEN
1426: l_trolin_rec.attribute2 := NULL;
1427: END IF;
1428:
1429: IF l_trolin_rec.attribute3 = fnd_api.g_miss_char THEN
1425: IF l_trolin_rec.attribute2 = fnd_api.g_miss_char THEN
1426: l_trolin_rec.attribute2 := NULL;
1427: END IF;
1428:
1429: IF l_trolin_rec.attribute3 = fnd_api.g_miss_char THEN
1430: l_trolin_rec.attribute3 := NULL;
1431: END IF;
1432:
1433: IF l_trolin_rec.attribute4 = fnd_api.g_miss_char THEN
1429: IF l_trolin_rec.attribute3 = fnd_api.g_miss_char THEN
1430: l_trolin_rec.attribute3 := NULL;
1431: END IF;
1432:
1433: IF l_trolin_rec.attribute4 = fnd_api.g_miss_char THEN
1434: l_trolin_rec.attribute4 := NULL;
1435: END IF;
1436:
1437: IF l_trolin_rec.attribute5 = fnd_api.g_miss_char THEN
1433: IF l_trolin_rec.attribute4 = fnd_api.g_miss_char THEN
1434: l_trolin_rec.attribute4 := NULL;
1435: END IF;
1436:
1437: IF l_trolin_rec.attribute5 = fnd_api.g_miss_char THEN
1438: l_trolin_rec.attribute5 := NULL;
1439: END IF;
1440:
1441: IF l_trolin_rec.attribute6 = fnd_api.g_miss_char THEN
1437: IF l_trolin_rec.attribute5 = fnd_api.g_miss_char THEN
1438: l_trolin_rec.attribute5 := NULL;
1439: END IF;
1440:
1441: IF l_trolin_rec.attribute6 = fnd_api.g_miss_char THEN
1442: l_trolin_rec.attribute6 := NULL;
1443: END IF;
1444:
1445: IF l_trolin_rec.attribute7 = fnd_api.g_miss_char THEN
1441: IF l_trolin_rec.attribute6 = fnd_api.g_miss_char THEN
1442: l_trolin_rec.attribute6 := NULL;
1443: END IF;
1444:
1445: IF l_trolin_rec.attribute7 = fnd_api.g_miss_char THEN
1446: l_trolin_rec.attribute7 := NULL;
1447: END IF;
1448:
1449: IF l_trolin_rec.attribute8 = fnd_api.g_miss_char THEN
1445: IF l_trolin_rec.attribute7 = fnd_api.g_miss_char THEN
1446: l_trolin_rec.attribute7 := NULL;
1447: END IF;
1448:
1449: IF l_trolin_rec.attribute8 = fnd_api.g_miss_char THEN
1450: l_trolin_rec.attribute8 := NULL;
1451: END IF;
1452:
1453: IF l_trolin_rec.attribute9 = fnd_api.g_miss_char THEN
1449: IF l_trolin_rec.attribute8 = fnd_api.g_miss_char THEN
1450: l_trolin_rec.attribute8 := NULL;
1451: END IF;
1452:
1453: IF l_trolin_rec.attribute9 = fnd_api.g_miss_char THEN
1454: l_trolin_rec.attribute9 := NULL;
1455: END IF;
1456:
1457: IF l_trolin_rec.attribute_category = fnd_api.g_miss_char THEN
1453: IF l_trolin_rec.attribute9 = fnd_api.g_miss_char THEN
1454: l_trolin_rec.attribute9 := NULL;
1455: END IF;
1456:
1457: IF l_trolin_rec.attribute_category = fnd_api.g_miss_char THEN
1458: l_trolin_rec.attribute_category := NULL;
1459: END IF;
1460:
1461: IF l_trolin_rec.created_by = fnd_api.g_miss_num THEN
1457: IF l_trolin_rec.attribute_category = fnd_api.g_miss_char THEN
1458: l_trolin_rec.attribute_category := NULL;
1459: END IF;
1460:
1461: IF l_trolin_rec.created_by = fnd_api.g_miss_num THEN
1462: l_trolin_rec.created_by := NULL;
1463: END IF;
1464:
1465: IF l_trolin_rec.creation_date = fnd_api.g_miss_date THEN
1461: IF l_trolin_rec.created_by = fnd_api.g_miss_num THEN
1462: l_trolin_rec.created_by := NULL;
1463: END IF;
1464:
1465: IF l_trolin_rec.creation_date = fnd_api.g_miss_date THEN
1466: l_trolin_rec.creation_date := NULL;
1467: END IF;
1468:
1469: IF l_trolin_rec.date_required = fnd_api.g_miss_date THEN
1465: IF l_trolin_rec.creation_date = fnd_api.g_miss_date THEN
1466: l_trolin_rec.creation_date := NULL;
1467: END IF;
1468:
1469: IF l_trolin_rec.date_required = fnd_api.g_miss_date THEN
1470: l_trolin_rec.date_required := NULL;
1471: END IF;
1472:
1473: IF l_trolin_rec.from_locator_id = fnd_api.g_miss_num THEN
1469: IF l_trolin_rec.date_required = fnd_api.g_miss_date THEN
1470: l_trolin_rec.date_required := NULL;
1471: END IF;
1472:
1473: IF l_trolin_rec.from_locator_id = fnd_api.g_miss_num THEN
1474: l_trolin_rec.from_locator_id := NULL;
1475: END IF;
1476:
1477: IF l_trolin_rec.from_subinventory_code = fnd_api.g_miss_char THEN
1473: IF l_trolin_rec.from_locator_id = fnd_api.g_miss_num THEN
1474: l_trolin_rec.from_locator_id := NULL;
1475: END IF;
1476:
1477: IF l_trolin_rec.from_subinventory_code = fnd_api.g_miss_char THEN
1478: l_trolin_rec.from_subinventory_code := NULL;
1479: END IF;
1480:
1481: IF l_trolin_rec.from_subinventory_id = fnd_api.g_miss_num THEN
1477: IF l_trolin_rec.from_subinventory_code = fnd_api.g_miss_char THEN
1478: l_trolin_rec.from_subinventory_code := NULL;
1479: END IF;
1480:
1481: IF l_trolin_rec.from_subinventory_id = fnd_api.g_miss_num THEN
1482: l_trolin_rec.from_subinventory_id := NULL;
1483: END IF;
1484:
1485: IF l_trolin_rec.header_id = fnd_api.g_miss_num THEN
1481: IF l_trolin_rec.from_subinventory_id = fnd_api.g_miss_num THEN
1482: l_trolin_rec.from_subinventory_id := NULL;
1483: END IF;
1484:
1485: IF l_trolin_rec.header_id = fnd_api.g_miss_num THEN
1486: l_trolin_rec.header_id := NULL;
1487: END IF;
1488:
1489: IF l_trolin_rec.inventory_item_id = fnd_api.g_miss_num THEN
1485: IF l_trolin_rec.header_id = fnd_api.g_miss_num THEN
1486: l_trolin_rec.header_id := NULL;
1487: END IF;
1488:
1489: IF l_trolin_rec.inventory_item_id = fnd_api.g_miss_num THEN
1490: l_trolin_rec.inventory_item_id := NULL;
1491: END IF;
1492:
1493: IF l_trolin_rec.last_updated_by = fnd_api.g_miss_num THEN
1489: IF l_trolin_rec.inventory_item_id = fnd_api.g_miss_num THEN
1490: l_trolin_rec.inventory_item_id := NULL;
1491: END IF;
1492:
1493: IF l_trolin_rec.last_updated_by = fnd_api.g_miss_num THEN
1494: l_trolin_rec.last_updated_by := NULL;
1495: END IF;
1496:
1497: IF l_trolin_rec.last_update_date = fnd_api.g_miss_date THEN
1493: IF l_trolin_rec.last_updated_by = fnd_api.g_miss_num THEN
1494: l_trolin_rec.last_updated_by := NULL;
1495: END IF;
1496:
1497: IF l_trolin_rec.last_update_date = fnd_api.g_miss_date THEN
1498: l_trolin_rec.last_update_date := NULL;
1499: END IF;
1500:
1501: IF l_trolin_rec.last_update_login = fnd_api.g_miss_num THEN
1497: IF l_trolin_rec.last_update_date = fnd_api.g_miss_date THEN
1498: l_trolin_rec.last_update_date := NULL;
1499: END IF;
1500:
1501: IF l_trolin_rec.last_update_login = fnd_api.g_miss_num THEN
1502: l_trolin_rec.last_update_login := NULL;
1503: END IF;
1504:
1505: IF l_trolin_rec.line_id = fnd_api.g_miss_num THEN
1501: IF l_trolin_rec.last_update_login = fnd_api.g_miss_num THEN
1502: l_trolin_rec.last_update_login := NULL;
1503: END IF;
1504:
1505: IF l_trolin_rec.line_id = fnd_api.g_miss_num THEN
1506: l_trolin_rec.line_id := NULL;
1507: END IF;
1508:
1509: IF l_trolin_rec.line_number = fnd_api.g_miss_num THEN
1505: IF l_trolin_rec.line_id = fnd_api.g_miss_num THEN
1506: l_trolin_rec.line_id := NULL;
1507: END IF;
1508:
1509: IF l_trolin_rec.line_number = fnd_api.g_miss_num THEN
1510: l_trolin_rec.line_number := NULL;
1511: END IF;
1512:
1513: IF l_trolin_rec.line_status = fnd_api.g_miss_num THEN
1509: IF l_trolin_rec.line_number = fnd_api.g_miss_num THEN
1510: l_trolin_rec.line_number := NULL;
1511: END IF;
1512:
1513: IF l_trolin_rec.line_status = fnd_api.g_miss_num THEN
1514: l_trolin_rec.line_status := NULL;
1515: END IF;
1516:
1517: IF l_trolin_rec.lot_number = fnd_api.g_miss_char THEN
1513: IF l_trolin_rec.line_status = fnd_api.g_miss_num THEN
1514: l_trolin_rec.line_status := NULL;
1515: END IF;
1516:
1517: IF l_trolin_rec.lot_number = fnd_api.g_miss_char THEN
1518: l_trolin_rec.lot_number := NULL;
1519: END IF;
1520:
1521: IF l_trolin_rec.organization_id = fnd_api.g_miss_num THEN
1517: IF l_trolin_rec.lot_number = fnd_api.g_miss_char THEN
1518: l_trolin_rec.lot_number := NULL;
1519: END IF;
1520:
1521: IF l_trolin_rec.organization_id = fnd_api.g_miss_num THEN
1522: l_trolin_rec.organization_id := NULL;
1523: END IF;
1524:
1525: IF l_trolin_rec.program_application_id = fnd_api.g_miss_num THEN
1521: IF l_trolin_rec.organization_id = fnd_api.g_miss_num THEN
1522: l_trolin_rec.organization_id := NULL;
1523: END IF;
1524:
1525: IF l_trolin_rec.program_application_id = fnd_api.g_miss_num THEN
1526: l_trolin_rec.program_application_id := NULL;
1527: END IF;
1528:
1529: IF l_trolin_rec.program_id = fnd_api.g_miss_num THEN
1525: IF l_trolin_rec.program_application_id = fnd_api.g_miss_num THEN
1526: l_trolin_rec.program_application_id := NULL;
1527: END IF;
1528:
1529: IF l_trolin_rec.program_id = fnd_api.g_miss_num THEN
1530: l_trolin_rec.program_id := NULL;
1531: END IF;
1532:
1533: IF l_trolin_rec.program_update_date = fnd_api.g_miss_date THEN
1529: IF l_trolin_rec.program_id = fnd_api.g_miss_num THEN
1530: l_trolin_rec.program_id := NULL;
1531: END IF;
1532:
1533: IF l_trolin_rec.program_update_date = fnd_api.g_miss_date THEN
1534: l_trolin_rec.program_update_date := NULL;
1535: END IF;
1536:
1537: IF l_trolin_rec.project_id = fnd_api.g_miss_num THEN
1533: IF l_trolin_rec.program_update_date = fnd_api.g_miss_date THEN
1534: l_trolin_rec.program_update_date := NULL;
1535: END IF;
1536:
1537: IF l_trolin_rec.project_id = fnd_api.g_miss_num THEN
1538: l_trolin_rec.project_id := NULL;
1539: END IF;
1540:
1541: IF l_trolin_rec.quantity = fnd_api.g_miss_num THEN
1537: IF l_trolin_rec.project_id = fnd_api.g_miss_num THEN
1538: l_trolin_rec.project_id := NULL;
1539: END IF;
1540:
1541: IF l_trolin_rec.quantity = fnd_api.g_miss_num THEN
1542: l_trolin_rec.quantity := NULL;
1543: END IF;
1544:
1545: IF l_trolin_rec.quantity_delivered = fnd_api.g_miss_num THEN
1541: IF l_trolin_rec.quantity = fnd_api.g_miss_num THEN
1542: l_trolin_rec.quantity := NULL;
1543: END IF;
1544:
1545: IF l_trolin_rec.quantity_delivered = fnd_api.g_miss_num THEN
1546: l_trolin_rec.quantity_delivered := NULL;
1547: END IF;
1548:
1549: IF l_trolin_rec.quantity_detailed = fnd_api.g_miss_num THEN
1545: IF l_trolin_rec.quantity_delivered = fnd_api.g_miss_num THEN
1546: l_trolin_rec.quantity_delivered := NULL;
1547: END IF;
1548:
1549: IF l_trolin_rec.quantity_detailed = fnd_api.g_miss_num THEN
1550: l_trolin_rec.quantity_detailed := NULL;
1551: END IF;
1552:
1553: IF l_trolin_rec.reason_id = fnd_api.g_miss_num THEN
1549: IF l_trolin_rec.quantity_detailed = fnd_api.g_miss_num THEN
1550: l_trolin_rec.quantity_detailed := NULL;
1551: END IF;
1552:
1553: IF l_trolin_rec.reason_id = fnd_api.g_miss_num THEN
1554: l_trolin_rec.reason_id := NULL;
1555: END IF;
1556:
1557: IF l_trolin_rec.REFERENCE = fnd_api.g_miss_char THEN
1553: IF l_trolin_rec.reason_id = fnd_api.g_miss_num THEN
1554: l_trolin_rec.reason_id := NULL;
1555: END IF;
1556:
1557: IF l_trolin_rec.REFERENCE = fnd_api.g_miss_char THEN
1558: l_trolin_rec.REFERENCE := NULL;
1559: END IF;
1560:
1561: IF l_trolin_rec.reference_id = fnd_api.g_miss_num THEN
1557: IF l_trolin_rec.REFERENCE = fnd_api.g_miss_char THEN
1558: l_trolin_rec.REFERENCE := NULL;
1559: END IF;
1560:
1561: IF l_trolin_rec.reference_id = fnd_api.g_miss_num THEN
1562: l_trolin_rec.reference_id := NULL;
1563: END IF;
1564:
1565: IF l_trolin_rec.reference_type_code = fnd_api.g_miss_num THEN
1561: IF l_trolin_rec.reference_id = fnd_api.g_miss_num THEN
1562: l_trolin_rec.reference_id := NULL;
1563: END IF;
1564:
1565: IF l_trolin_rec.reference_type_code = fnd_api.g_miss_num THEN
1566: l_trolin_rec.reference_type_code := NULL;
1567: END IF;
1568:
1569: IF l_trolin_rec.request_id = fnd_api.g_miss_num THEN
1565: IF l_trolin_rec.reference_type_code = fnd_api.g_miss_num THEN
1566: l_trolin_rec.reference_type_code := NULL;
1567: END IF;
1568:
1569: IF l_trolin_rec.request_id = fnd_api.g_miss_num THEN
1570: l_trolin_rec.request_id := NULL;
1571: END IF;
1572:
1573: IF l_trolin_rec.revision = fnd_api.g_miss_char THEN
1569: IF l_trolin_rec.request_id = fnd_api.g_miss_num THEN
1570: l_trolin_rec.request_id := NULL;
1571: END IF;
1572:
1573: IF l_trolin_rec.revision = fnd_api.g_miss_char THEN
1574: l_trolin_rec.revision := NULL;
1575: END IF;
1576:
1577: IF l_trolin_rec.serial_number_end = fnd_api.g_miss_char THEN
1573: IF l_trolin_rec.revision = fnd_api.g_miss_char THEN
1574: l_trolin_rec.revision := NULL;
1575: END IF;
1576:
1577: IF l_trolin_rec.serial_number_end = fnd_api.g_miss_char THEN
1578: l_trolin_rec.serial_number_end := NULL;
1579: END IF;
1580:
1581: IF l_trolin_rec.serial_number_start = fnd_api.g_miss_char THEN
1577: IF l_trolin_rec.serial_number_end = fnd_api.g_miss_char THEN
1578: l_trolin_rec.serial_number_end := NULL;
1579: END IF;
1580:
1581: IF l_trolin_rec.serial_number_start = fnd_api.g_miss_char THEN
1582: l_trolin_rec.serial_number_start := NULL;
1583: END IF;
1584:
1585: IF l_trolin_rec.status_date = fnd_api.g_miss_date THEN
1581: IF l_trolin_rec.serial_number_start = fnd_api.g_miss_char THEN
1582: l_trolin_rec.serial_number_start := NULL;
1583: END IF;
1584:
1585: IF l_trolin_rec.status_date = fnd_api.g_miss_date THEN
1586: l_trolin_rec.status_date := NULL;
1587: END IF;
1588:
1589: IF l_trolin_rec.task_id = fnd_api.g_miss_num THEN
1585: IF l_trolin_rec.status_date = fnd_api.g_miss_date THEN
1586: l_trolin_rec.status_date := NULL;
1587: END IF;
1588:
1589: IF l_trolin_rec.task_id = fnd_api.g_miss_num THEN
1590: l_trolin_rec.task_id := NULL;
1591: END IF;
1592:
1593: IF l_trolin_rec.to_account_id = fnd_api.g_miss_num THEN
1589: IF l_trolin_rec.task_id = fnd_api.g_miss_num THEN
1590: l_trolin_rec.task_id := NULL;
1591: END IF;
1592:
1593: IF l_trolin_rec.to_account_id = fnd_api.g_miss_num THEN
1594: l_trolin_rec.to_account_id := NULL;
1595: END IF;
1596:
1597: IF l_trolin_rec.to_locator_id = fnd_api.g_miss_num THEN
1593: IF l_trolin_rec.to_account_id = fnd_api.g_miss_num THEN
1594: l_trolin_rec.to_account_id := NULL;
1595: END IF;
1596:
1597: IF l_trolin_rec.to_locator_id = fnd_api.g_miss_num THEN
1598: l_trolin_rec.to_locator_id := NULL;
1599: END IF;
1600:
1601: IF l_trolin_rec.to_subinventory_code = fnd_api.g_miss_char THEN
1597: IF l_trolin_rec.to_locator_id = fnd_api.g_miss_num THEN
1598: l_trolin_rec.to_locator_id := NULL;
1599: END IF;
1600:
1601: IF l_trolin_rec.to_subinventory_code = fnd_api.g_miss_char THEN
1602: l_trolin_rec.to_subinventory_code := NULL;
1603: END IF;
1604:
1605: IF l_trolin_rec.to_subinventory_id = fnd_api.g_miss_num THEN
1601: IF l_trolin_rec.to_subinventory_code = fnd_api.g_miss_char THEN
1602: l_trolin_rec.to_subinventory_code := NULL;
1603: END IF;
1604:
1605: IF l_trolin_rec.to_subinventory_id = fnd_api.g_miss_num THEN
1606: l_trolin_rec.to_subinventory_id := NULL;
1607: END IF;
1608:
1609: IF l_trolin_rec.transaction_header_id = fnd_api.g_miss_num THEN
1605: IF l_trolin_rec.to_subinventory_id = fnd_api.g_miss_num THEN
1606: l_trolin_rec.to_subinventory_id := NULL;
1607: END IF;
1608:
1609: IF l_trolin_rec.transaction_header_id = fnd_api.g_miss_num THEN
1610: l_trolin_rec.transaction_header_id := NULL;
1611: END IF;
1612:
1613: IF l_trolin_rec.uom_code = fnd_api.g_miss_char THEN
1609: IF l_trolin_rec.transaction_header_id = fnd_api.g_miss_num THEN
1610: l_trolin_rec.transaction_header_id := NULL;
1611: END IF;
1612:
1613: IF l_trolin_rec.uom_code = fnd_api.g_miss_char THEN
1614: l_trolin_rec.uom_code := NULL;
1615: END IF;
1616:
1617: --INVCONV BEGIN
1614: l_trolin_rec.uom_code := NULL;
1615: END IF;
1616:
1617: --INVCONV BEGIN
1618: IF l_trolin_rec.secondary_quantity = fnd_api.g_miss_num THEN
1619: l_trolin_rec.secondary_quantity := NULL;
1620: END IF;
1621:
1622: --Bug #4565509 - Should set secondary quantities
1619: l_trolin_rec.secondary_quantity := NULL;
1620: END IF;
1621:
1622: --Bug #4565509 - Should set secondary quantities
1623: IF l_trolin_rec.secondary_quantity_delivered = fnd_api.g_miss_num THEN
1624: l_trolin_rec.secondary_quantity_delivered := NULL;
1625: END IF;
1626:
1627: IF l_trolin_rec.secondary_quantity_detailed = fnd_api.g_miss_num THEN
1623: IF l_trolin_rec.secondary_quantity_delivered = fnd_api.g_miss_num THEN
1624: l_trolin_rec.secondary_quantity_delivered := NULL;
1625: END IF;
1626:
1627: IF l_trolin_rec.secondary_quantity_detailed = fnd_api.g_miss_num THEN
1628: l_trolin_rec.secondary_quantity_detailed := NULL;
1629: END IF;
1630:
1631: IF l_trolin_rec.secondary_uom = fnd_api.g_miss_char THEN
1627: IF l_trolin_rec.secondary_quantity_detailed = fnd_api.g_miss_num THEN
1628: l_trolin_rec.secondary_quantity_detailed := NULL;
1629: END IF;
1630:
1631: IF l_trolin_rec.secondary_uom = fnd_api.g_miss_char THEN
1632: l_trolin_rec.secondary_uom := NULL;
1633: END IF;
1634:
1635: IF l_trolin_rec.grade_code = fnd_api.g_miss_char THEN
1631: IF l_trolin_rec.secondary_uom = fnd_api.g_miss_char THEN
1632: l_trolin_rec.secondary_uom := NULL;
1633: END IF;
1634:
1635: IF l_trolin_rec.grade_code = fnd_api.g_miss_char THEN
1636: l_trolin_rec.grade_code := NULL;
1637: END IF;
1638: /*Bug#5764123. Added the below code to NULL out 'pick_methodology_id',
1639: 'container_item_id' and 'carton_grouping_id', if their value is MISS_NUM.*/
1636: l_trolin_rec.grade_code := NULL;
1637: END IF;
1638: /*Bug#5764123. Added the below code to NULL out 'pick_methodology_id',
1639: 'container_item_id' and 'carton_grouping_id', if their value is MISS_NUM.*/
1640: IF (l_trolin_rec.pick_methodology_id = fnd_api.g_miss_num) THEN
1641: l_trolin_rec.pick_methodology_id := NULL;
1642: END IF;
1643: IF (l_trolin_rec.container_item_id = fnd_api.g_miss_num) THEN
1644: l_trolin_rec.container_item_id := NULL;
1639: 'container_item_id' and 'carton_grouping_id', if their value is MISS_NUM.*/
1640: IF (l_trolin_rec.pick_methodology_id = fnd_api.g_miss_num) THEN
1641: l_trolin_rec.pick_methodology_id := NULL;
1642: END IF;
1643: IF (l_trolin_rec.container_item_id = fnd_api.g_miss_num) THEN
1644: l_trolin_rec.container_item_id := NULL;
1645: END IF;
1646: IF (l_trolin_rec.carton_grouping_id = fnd_api.g_miss_num) THEN
1647: l_trolin_rec.carton_grouping_id := NULL;
1642: END IF;
1643: IF (l_trolin_rec.container_item_id = fnd_api.g_miss_num) THEN
1644: l_trolin_rec.container_item_id := NULL;
1645: END IF;
1646: IF (l_trolin_rec.carton_grouping_id = fnd_api.g_miss_num) THEN
1647: l_trolin_rec.carton_grouping_id := NULL;
1648: END IF;
1649:
1650: -- INVCONV END;
1647: l_trolin_rec.carton_grouping_id := NULL;
1648: END IF;
1649:
1650: -- INVCONV END;
1651: /* IF l_trolin_rec.transaction_type_id = FND_API.G_MISS_NUM THEN
1652: l_trolin_rec.transaction_type_id := NULL;
1653: END IF;
1654:
1655: IF l_trolin_rec.transaction_source_type_id = FND_API.G_MISS_NUM THEN
1651: /* IF l_trolin_rec.transaction_type_id = FND_API.G_MISS_NUM THEN
1652: l_trolin_rec.transaction_type_id := NULL;
1653: END IF;
1654:
1655: IF l_trolin_rec.transaction_source_type_id = FND_API.G_MISS_NUM THEN
1656: l_trolin_rec.transaction_source_type_id := NULL;
1657: END IF;
1658:
1659: IF l_trolin_rec.txn_source_id = FND_API.G_MISS_NUM THEN
1655: IF l_trolin_rec.transaction_source_type_id = FND_API.G_MISS_NUM THEN
1656: l_trolin_rec.transaction_source_type_id := NULL;
1657: END IF;
1658:
1659: IF l_trolin_rec.txn_source_id = FND_API.G_MISS_NUM THEN
1660: l_trolin_rec.txn_source_id := NULL;
1661: END IF;
1662:
1663: IF l_trolin_rec.txn_source_line_id = FND_API.G_MISS_NUM THEN
1659: IF l_trolin_rec.txn_source_id = FND_API.G_MISS_NUM THEN
1660: l_trolin_rec.txn_source_id := NULL;
1661: END IF;
1662:
1663: IF l_trolin_rec.txn_source_line_id = FND_API.G_MISS_NUM THEN
1664: l_trolin_rec.txn_source_line_id := NULL;
1665: END IF;
1666:
1667: IF l_trolin_rec.txn_source_line_detail_id = FND_API.G_MISS_NUM THEN
1663: IF l_trolin_rec.txn_source_line_id = FND_API.G_MISS_NUM THEN
1664: l_trolin_rec.txn_source_line_id := NULL;
1665: END IF;
1666:
1667: IF l_trolin_rec.txn_source_line_detail_id = FND_API.G_MISS_NUM THEN
1668: l_trolin_rec.txn_source_line_detail_id := NULL;
1669: END IF;
1670:
1671: IF l_trolin_rec.to_organization_id = FND_API.G_MISS_NUM THEN
1667: IF l_trolin_rec.txn_source_line_detail_id = FND_API.G_MISS_NUM THEN
1668: l_trolin_rec.txn_source_line_detail_id := NULL;
1669: END IF;
1670:
1671: IF l_trolin_rec.to_organization_id = FND_API.G_MISS_NUM THEN
1672: l_trolin_rec.to_organization_id := NULL;
1673: END IF;
1674:
1675: IF l_trolin_rec.primary_quantity = FND_API.G_MISS_NUM THEN
1671: IF l_trolin_rec.to_organization_id = FND_API.G_MISS_NUM THEN
1672: l_trolin_rec.to_organization_id := NULL;
1673: END IF;
1674:
1675: IF l_trolin_rec.primary_quantity = FND_API.G_MISS_NUM THEN
1676: l_trolin_rec.primary_quantity := NULL;
1677: END IF;
1678:
1679: IF l_trolin_rec.pick_strategy_id = FND_API.G_MISS_NUM THEN
1675: IF l_trolin_rec.primary_quantity = FND_API.G_MISS_NUM THEN
1676: l_trolin_rec.primary_quantity := NULL;
1677: END IF;
1678:
1679: IF l_trolin_rec.pick_strategy_id = FND_API.G_MISS_NUM THEN
1680: l_trolin_rec.pick_strategy_id := NULL;
1681: END IF;
1682:
1683: IF l_trolin_rec.put_away_strategy_id = FND_API.G_MISS_NUM THEN
1679: IF l_trolin_rec.pick_strategy_id = FND_API.G_MISS_NUM THEN
1680: l_trolin_rec.pick_strategy_id := NULL;
1681: END IF;
1682:
1683: IF l_trolin_rec.put_away_strategy_id = FND_API.G_MISS_NUM THEN
1684: l_trolin_rec.put_away_strategy_id := NULL;
1685: END IF;
1686: */
1687: RETURN l_trolin_rec;
1695:
1696: BEGIN
1697: l_trolin_rec := inv_trolin_util.convert_miss_to_null(p_trolin_rec => l_trolin_rec);
1698:
1699: IF l_trolin_rec.transaction_type_id = FND_API.G_MISS_NUM THEN
1700: l_trolin_rec.transaction_type_id := NULL;
1701: END IF;
1702:
1703: IF l_trolin_rec.transaction_source_type_id = FND_API.G_MISS_NUM THEN
1699: IF l_trolin_rec.transaction_type_id = FND_API.G_MISS_NUM THEN
1700: l_trolin_rec.transaction_type_id := NULL;
1701: END IF;
1702:
1703: IF l_trolin_rec.transaction_source_type_id = FND_API.G_MISS_NUM THEN
1704: l_trolin_rec.transaction_source_type_id := NULL;
1705: END IF;
1706:
1707: IF l_trolin_rec.txn_source_id = FND_API.G_MISS_NUM THEN
1703: IF l_trolin_rec.transaction_source_type_id = FND_API.G_MISS_NUM THEN
1704: l_trolin_rec.transaction_source_type_id := NULL;
1705: END IF;
1706:
1707: IF l_trolin_rec.txn_source_id = FND_API.G_MISS_NUM THEN
1708: l_trolin_rec.txn_source_id := NULL;
1709: END IF;
1710:
1711: IF l_trolin_rec.txn_source_line_id = FND_API.G_MISS_NUM THEN
1707: IF l_trolin_rec.txn_source_id = FND_API.G_MISS_NUM THEN
1708: l_trolin_rec.txn_source_id := NULL;
1709: END IF;
1710:
1711: IF l_trolin_rec.txn_source_line_id = FND_API.G_MISS_NUM THEN
1712: l_trolin_rec.txn_source_line_id := NULL;
1713: END IF;
1714:
1715: IF l_trolin_rec.txn_source_line_detail_id = FND_API.G_MISS_NUM THEN
1711: IF l_trolin_rec.txn_source_line_id = FND_API.G_MISS_NUM THEN
1712: l_trolin_rec.txn_source_line_id := NULL;
1713: END IF;
1714:
1715: IF l_trolin_rec.txn_source_line_detail_id = FND_API.G_MISS_NUM THEN
1716: l_trolin_rec.txn_source_line_detail_id := NULL;
1717: END IF;
1718:
1719: IF l_trolin_rec.to_organization_id = FND_API.G_MISS_NUM THEN
1715: IF l_trolin_rec.txn_source_line_detail_id = FND_API.G_MISS_NUM THEN
1716: l_trolin_rec.txn_source_line_detail_id := NULL;
1717: END IF;
1718:
1719: IF l_trolin_rec.to_organization_id = FND_API.G_MISS_NUM THEN
1720: l_trolin_rec.to_organization_id := NULL;
1721: END IF;
1722:
1723: IF l_trolin_rec.primary_quantity = FND_API.G_MISS_NUM THEN
1719: IF l_trolin_rec.to_organization_id = FND_API.G_MISS_NUM THEN
1720: l_trolin_rec.to_organization_id := NULL;
1721: END IF;
1722:
1723: IF l_trolin_rec.primary_quantity = FND_API.G_MISS_NUM THEN
1724: l_trolin_rec.primary_quantity := NULL;
1725: END IF;
1726:
1727: IF l_trolin_rec.pick_strategy_id = FND_API.G_MISS_NUM THEN
1723: IF l_trolin_rec.primary_quantity = FND_API.G_MISS_NUM THEN
1724: l_trolin_rec.primary_quantity := NULL;
1725: END IF;
1726:
1727: IF l_trolin_rec.pick_strategy_id = FND_API.G_MISS_NUM THEN
1728: l_trolin_rec.pick_strategy_id := NULL;
1729: END IF;
1730:
1731: IF l_trolin_rec.put_away_strategy_id = FND_API.G_MISS_NUM THEN
1727: IF l_trolin_rec.pick_strategy_id = FND_API.G_MISS_NUM THEN
1728: l_trolin_rec.pick_strategy_id := NULL;
1729: END IF;
1730:
1731: IF l_trolin_rec.put_away_strategy_id = FND_API.G_MISS_NUM THEN
1732: l_trolin_rec.put_away_strategy_id := NULL;
1733: END IF;
1734:
1735: IF l_trolin_rec.ship_to_location_id = FND_API.G_MISS_NUM THEN
1731: IF l_trolin_rec.put_away_strategy_id = FND_API.G_MISS_NUM THEN
1732: l_trolin_rec.put_away_strategy_id := NULL;
1733: END IF;
1734:
1735: IF l_trolin_rec.ship_to_location_id = FND_API.G_MISS_NUM THEN
1736: l_trolin_rec.ship_to_location_id := NULL;
1737: END IF;
1738:
1739: IF l_trolin_rec.from_cost_group_id = FND_API.G_MISS_NUM THEN
1735: IF l_trolin_rec.ship_to_location_id = FND_API.G_MISS_NUM THEN
1736: l_trolin_rec.ship_to_location_id := NULL;
1737: END IF;
1738:
1739: IF l_trolin_rec.from_cost_group_id = FND_API.G_MISS_NUM THEN
1740: l_trolin_rec.from_cost_group_id := NULL;
1741: END IF;
1742:
1743: IF l_trolin_rec.to_cost_group_id = FND_API.G_MISS_NUM THEN
1739: IF l_trolin_rec.from_cost_group_id = FND_API.G_MISS_NUM THEN
1740: l_trolin_rec.from_cost_group_id := NULL;
1741: END IF;
1742:
1743: IF l_trolin_rec.to_cost_group_id = FND_API.G_MISS_NUM THEN
1744: l_trolin_rec.to_cost_group_id := NULL;
1745: END IF;
1746:
1747: IF l_trolin_rec.lpn_id = FND_API.G_MISS_NUM THEN
1743: IF l_trolin_rec.to_cost_group_id = FND_API.G_MISS_NUM THEN
1744: l_trolin_rec.to_cost_group_id := NULL;
1745: END IF;
1746:
1747: IF l_trolin_rec.lpn_id = FND_API.G_MISS_NUM THEN
1748: l_trolin_rec.lpn_id := NULL;
1749: END IF;
1750:
1751: IF l_trolin_rec.to_lpn_id = FND_API.G_MISS_NUM THEN
1747: IF l_trolin_rec.lpn_id = FND_API.G_MISS_NUM THEN
1748: l_trolin_rec.lpn_id := NULL;
1749: END IF;
1750:
1751: IF l_trolin_rec.to_lpn_id = FND_API.G_MISS_NUM THEN
1752: l_trolin_rec.to_lpn_id := NULL;
1753: END IF;
1754:
1755: IF l_trolin_rec.pick_methodology_id = FND_API.G_MISS_NUM THEN
1751: IF l_trolin_rec.to_lpn_id = FND_API.G_MISS_NUM THEN
1752: l_trolin_rec.to_lpn_id := NULL;
1753: END IF;
1754:
1755: IF l_trolin_rec.pick_methodology_id = FND_API.G_MISS_NUM THEN
1756: l_trolin_rec.pick_methodology_id := NULL;
1757: END IF;
1758:
1759: IF l_trolin_rec.container_item_id = FND_API.G_MISS_NUM THEN
1755: IF l_trolin_rec.pick_methodology_id = FND_API.G_MISS_NUM THEN
1756: l_trolin_rec.pick_methodology_id := NULL;
1757: END IF;
1758:
1759: IF l_trolin_rec.container_item_id = FND_API.G_MISS_NUM THEN
1760: l_trolin_rec.container_item_id := NULL;
1761: END IF;
1762:
1763: IF l_trolin_rec.carton_grouping_id = FND_API.G_MISS_NUM THEN
1759: IF l_trolin_rec.container_item_id = FND_API.G_MISS_NUM THEN
1760: l_trolin_rec.container_item_id := NULL;
1761: END IF;
1762:
1763: IF l_trolin_rec.carton_grouping_id = FND_API.G_MISS_NUM THEN
1764: l_trolin_rec.carton_grouping_id := NULL;
1765: END IF;
1766:
1767: return l_trolin_rec;
1775: FUNCTION convert_miss_to_null (p_trolin_val_rec INV_MOVE_ORDER_PUB.TROLIN_VAL_REC_TYPE)
1776: RETURN INV_MOVE_ORDER_PUB.TROLIN_VAL_REC_TYPE IS
1777: l_trolin_val_rec INV_MOVE_ORDER_PUB.trolin_val_rec_type := p_trolin_val_rec;
1778: BEGIN
1779: IF l_trolin_val_rec.from_locator = FND_API.G_MISS_CHAR THEN
1780: l_trolin_val_rec.from_locator := NULL;
1781: END IF;
1782:
1783: IF l_trolin_val_rec.header = FND_API.G_MISS_CHAR THEN
1779: IF l_trolin_val_rec.from_locator = FND_API.G_MISS_CHAR THEN
1780: l_trolin_val_rec.from_locator := NULL;
1781: END IF;
1782:
1783: IF l_trolin_val_rec.header = FND_API.G_MISS_CHAR THEN
1784: l_trolin_val_rec.header := NULL;
1785: END IF;
1786:
1787: IF l_trolin_val_rec.from_subinventory = FND_API.G_MISS_CHAR THEN
1783: IF l_trolin_val_rec.header = FND_API.G_MISS_CHAR THEN
1784: l_trolin_val_rec.header := NULL;
1785: END IF;
1786:
1787: IF l_trolin_val_rec.from_subinventory = FND_API.G_MISS_CHAR THEN
1788: l_trolin_val_rec.from_subinventory := NULL;
1789: END IF;
1790:
1791: IF l_trolin_val_rec.inventory_item = FND_API.G_MISS_CHAR THEN
1787: IF l_trolin_val_rec.from_subinventory = FND_API.G_MISS_CHAR THEN
1788: l_trolin_val_rec.from_subinventory := NULL;
1789: END IF;
1790:
1791: IF l_trolin_val_rec.inventory_item = FND_API.G_MISS_CHAR THEN
1792: l_trolin_val_rec.inventory_item := NULL;
1793: END IF;
1794:
1795: IF l_trolin_val_rec.line = FND_API.G_MISS_CHAR THEN
1791: IF l_trolin_val_rec.inventory_item = FND_API.G_MISS_CHAR THEN
1792: l_trolin_val_rec.inventory_item := NULL;
1793: END IF;
1794:
1795: IF l_trolin_val_rec.line = FND_API.G_MISS_CHAR THEN
1796: l_trolin_val_rec.line := NULL;
1797: END IF;
1798:
1799: IF l_trolin_val_rec.organization = FND_API.G_MISS_CHAR THEN
1795: IF l_trolin_val_rec.line = FND_API.G_MISS_CHAR THEN
1796: l_trolin_val_rec.line := NULL;
1797: END IF;
1798:
1799: IF l_trolin_val_rec.organization = FND_API.G_MISS_CHAR THEN
1800: l_trolin_val_rec.organization := NULL;
1801: END IF;
1802:
1803: IF l_trolin_val_rec.project = FND_API.G_MISS_CHAR THEN
1799: IF l_trolin_val_rec.organization = FND_API.G_MISS_CHAR THEN
1800: l_trolin_val_rec.organization := NULL;
1801: END IF;
1802:
1803: IF l_trolin_val_rec.project = FND_API.G_MISS_CHAR THEN
1804: l_trolin_val_rec.project := NULL;
1805: END IF;
1806:
1807: IF l_trolin_val_rec.reason = FND_API.G_MISS_CHAR THEN
1803: IF l_trolin_val_rec.project = FND_API.G_MISS_CHAR THEN
1804: l_trolin_val_rec.project := NULL;
1805: END IF;
1806:
1807: IF l_trolin_val_rec.reason = FND_API.G_MISS_CHAR THEN
1808: l_trolin_val_rec.reason := NULL;
1809: END IF;
1810:
1811: IF l_trolin_val_rec.reference = FND_API.G_MISS_CHAR THEN
1807: IF l_trolin_val_rec.reason = FND_API.G_MISS_CHAR THEN
1808: l_trolin_val_rec.reason := NULL;
1809: END IF;
1810:
1811: IF l_trolin_val_rec.reference = FND_API.G_MISS_CHAR THEN
1812: l_trolin_val_rec.reference := NULL;
1813: END IF;
1814:
1815: IF l_trolin_val_rec.reference_type = FND_API.G_MISS_CHAR THEN
1811: IF l_trolin_val_rec.reference = FND_API.G_MISS_CHAR THEN
1812: l_trolin_val_rec.reference := NULL;
1813: END IF;
1814:
1815: IF l_trolin_val_rec.reference_type = FND_API.G_MISS_CHAR THEN
1816: l_trolin_val_rec.reference_type := NULL;
1817: END IF;
1818:
1819: IF l_trolin_val_rec.task = FND_API.G_MISS_CHAR THEN
1815: IF l_trolin_val_rec.reference_type = FND_API.G_MISS_CHAR THEN
1816: l_trolin_val_rec.reference_type := NULL;
1817: END IF;
1818:
1819: IF l_trolin_val_rec.task = FND_API.G_MISS_CHAR THEN
1820: l_trolin_val_rec.task := NULL;
1821: END IF;
1822:
1823: IF l_trolin_val_rec.to_account = FND_API.G_MISS_CHAR THEN
1819: IF l_trolin_val_rec.task = FND_API.G_MISS_CHAR THEN
1820: l_trolin_val_rec.task := NULL;
1821: END IF;
1822:
1823: IF l_trolin_val_rec.to_account = FND_API.G_MISS_CHAR THEN
1824: l_trolin_val_rec.to_account := NULL;
1825: END IF;
1826:
1827: IF l_trolin_val_rec.to_locator = FND_API.G_MISS_CHAR THEN
1823: IF l_trolin_val_rec.to_account = FND_API.G_MISS_CHAR THEN
1824: l_trolin_val_rec.to_account := NULL;
1825: END IF;
1826:
1827: IF l_trolin_val_rec.to_locator = FND_API.G_MISS_CHAR THEN
1828: l_trolin_val_rec.to_locator := NULL;
1829: END IF;
1830:
1831: IF l_trolin_val_rec.to_subinventory = FND_API.G_MISS_CHAR THEN
1827: IF l_trolin_val_rec.to_locator = FND_API.G_MISS_CHAR THEN
1828: l_trolin_val_rec.to_locator := NULL;
1829: END IF;
1830:
1831: IF l_trolin_val_rec.to_subinventory = FND_API.G_MISS_CHAR THEN
1832: l_trolin_val_rec.to_subinventory := NULL;
1833: END IF;
1834:
1835: IF l_trolin_val_rec.transaction_header = FND_API.G_MISS_CHAR THEN
1831: IF l_trolin_val_rec.to_subinventory = FND_API.G_MISS_CHAR THEN
1832: l_trolin_val_rec.to_subinventory := NULL;
1833: END IF;
1834:
1835: IF l_trolin_val_rec.transaction_header = FND_API.G_MISS_CHAR THEN
1836: l_trolin_val_rec.transaction_header := NULL;
1837: END IF;
1838:
1839: IF l_trolin_val_rec.uom = FND_API.G_MISS_CHAR THEN
1835: IF l_trolin_val_rec.transaction_header = FND_API.G_MISS_CHAR THEN
1836: l_trolin_val_rec.transaction_header := NULL;
1837: END IF;
1838:
1839: IF l_trolin_val_rec.uom = FND_API.G_MISS_CHAR THEN
1840: l_trolin_val_rec.uom := NULL;
1841: END IF;
1842:
1843: IF l_trolin_val_rec.transaction_type = FND_API.G_MISS_CHAR THEN
1839: IF l_trolin_val_rec.uom = FND_API.G_MISS_CHAR THEN
1840: l_trolin_val_rec.uom := NULL;
1841: END IF;
1842:
1843: IF l_trolin_val_rec.transaction_type = FND_API.G_MISS_CHAR THEN
1844: l_trolin_val_rec.transaction_type := NULL;
1845: END IF;
1846:
1847: IF l_trolin_val_rec.to_organization = FND_API.G_MISS_CHAR THEN
1843: IF l_trolin_val_rec.transaction_type = FND_API.G_MISS_CHAR THEN
1844: l_trolin_val_rec.transaction_type := NULL;
1845: END IF;
1846:
1847: IF l_trolin_val_rec.to_organization = FND_API.G_MISS_CHAR THEN
1848: l_trolin_val_rec.to_organization := NULL;
1849: END IF;
1850:
1851: RETURN l_trolin_val_rec;
1986: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1987: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Update_Row');
1988: END IF;
1989:
1990: RAISE fnd_api.g_exc_unexpected_error;
1991: END update_row;
1992:
1993: -- Procedure Update_Row_Status
1994:
2007: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2008: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Update_Row_Status');
2009: END IF;
2010:
2011: RAISE fnd_api.g_exc_unexpected_error;
2012: END update_row_status;
2013:
2014: -- Procedure Insert_Row
2015:
2203: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2204: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Insert_Row');
2205: END IF;
2206:
2207: RAISE fnd_api.g_exc_unexpected_error;
2208: END insert_row;
2209:
2210: -- Procedure Delete_Row
2211:
2218: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2219: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Delete_Row');
2220: END IF;
2221:
2222: RAISE fnd_api.g_exc_unexpected_error;
2223: END delete_row;
2224:
2225: -- Function Get_Lines
2226:
2242: -- Function Query_Rows
2243:
2244: --
2245:
2246: FUNCTION query_rows(p_line_id IN NUMBER := fnd_api.g_miss_num, p_header_id IN NUMBER := fnd_api.g_miss_num)
2247: RETURN inv_move_order_pub.trolin_tbl_type IS
2248: l_trolin_rec inv_move_order_pub.trolin_rec_type;
2249: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
2250:
2437: BEGIN
2438: /*inv_debug.message('TRO: line_id '||to_char(p_line_id)||' header_id '||to_char(p_header_id)); */
2439:
2440: IF (p_line_id IS NOT NULL
2441: AND p_line_id <> fnd_api.g_miss_num
2442: )
2443: AND (p_header_id IS NOT NULL
2444: AND p_header_id <> fnd_api.g_miss_num
2445: ) THEN
2440: IF (p_line_id IS NOT NULL
2441: AND p_line_id <> fnd_api.g_miss_num
2442: )
2443: AND (p_header_id IS NOT NULL
2444: AND p_header_id <> fnd_api.g_miss_num
2445: ) THEN
2446: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2447: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Query Rows', 'Keys are mutually exclusive: line_id = ' || p_line_id || ', header_id = ' || p_header_id);
2448: END IF;
2446: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2447: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Query Rows', 'Keys are mutually exclusive: line_id = ' || p_line_id || ', header_id = ' || p_header_id);
2448: END IF;
2449:
2450: RAISE fnd_api.g_exc_unexpected_error;
2451: END IF;
2452:
2453: IF (p_line_id IS NOT NULL
2454: AND p_line_id <> fnd_api.g_miss_num
2450: RAISE fnd_api.g_exc_unexpected_error;
2451: END IF;
2452:
2453: IF (p_line_id IS NOT NULL
2454: AND p_line_id <> fnd_api.g_miss_num
2455: ) THEN
2456: -- Loop over fetched records
2457:
2458: FOR l_implicit_rec IN l_trolin_csr LOOP
2645:
2646: -- PK sent and no rows found
2647:
2648: IF (p_line_id IS NOT NULL
2649: AND p_line_id <> fnd_api.g_miss_num
2650: )
2651: AND (l_trolin_tbl.COUNT = 0) THEN
2652: RAISE NO_DATA_FOUND;
2653: END IF;
2655: -- Return fetched table
2656:
2657: RETURN l_trolin_tbl;
2658: EXCEPTION
2659: WHEN fnd_api.g_exc_unexpected_error THEN
2660: RAISE fnd_api.g_exc_unexpected_error;
2661: WHEN OTHERS THEN
2662: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2663: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Query_Rows');
2656:
2657: RETURN l_trolin_tbl;
2658: EXCEPTION
2659: WHEN fnd_api.g_exc_unexpected_error THEN
2660: RAISE fnd_api.g_exc_unexpected_error;
2661: WHEN OTHERS THEN
2662: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2663: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Query_Rows');
2664: END IF;
2662: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2663: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Query_Rows');
2664: END IF;
2665:
2666: RAISE fnd_api.g_exc_unexpected_error;
2667: END query_rows;
2668:
2669: -- Procedure lock_Row
2670: --
2872: AND inv_globals.equal(p_trolin_rec.attribute8, l_trolin_rec.attribute8)
2873: AND inv_globals.equal(p_trolin_rec.attribute9, l_trolin_rec.attribute9)
2874: AND inv_globals.equal(p_trolin_rec.attribute_category, l_trolin_rec.attribute_category)
2875: AND (inv_globals.equal(p_trolin_rec.created_by, l_trolin_rec.created_by)
2876: OR (p_trolin_rec.created_by = fnd_api.g_miss_num
2877: AND l_trolin_rec.created_by IS NULL
2878: )
2879: )
2880: AND (inv_globals.equal(p_trolin_rec.creation_date, l_trolin_rec.creation_date)
2877: AND l_trolin_rec.created_by IS NULL
2878: )
2879: )
2880: AND (inv_globals.equal(p_trolin_rec.creation_date, l_trolin_rec.creation_date)
2881: OR (p_trolin_rec.creation_date = fnd_api.g_miss_date
2882: AND l_trolin_rec.creation_date IS NULL
2883: )
2884: )
2885: AND (inv_globals.equal(p_trolin_rec.date_required, l_trolin_rec.date_required)
2882: AND l_trolin_rec.creation_date IS NULL
2883: )
2884: )
2885: AND (inv_globals.equal(p_trolin_rec.date_required, l_trolin_rec.date_required)
2886: OR (p_trolin_rec.date_required = fnd_api.g_miss_date
2887: AND l_trolin_rec.date_required IS NULL
2888: )
2889: )
2890: AND (inv_globals.equal(p_trolin_rec.from_locator_id, l_trolin_rec.from_locator_id)
2887: AND l_trolin_rec.date_required IS NULL
2888: )
2889: )
2890: AND (inv_globals.equal(p_trolin_rec.from_locator_id, l_trolin_rec.from_locator_id)
2891: OR (p_trolin_rec.from_locator_id = fnd_api.g_miss_num
2892: AND l_trolin_rec.from_locator_id IS NULL
2893: )
2894: )
2895: AND (inv_globals.equal(p_trolin_rec.from_subinventory_code, l_trolin_rec.from_subinventory_code)
2892: AND l_trolin_rec.from_locator_id IS NULL
2893: )
2894: )
2895: AND (inv_globals.equal(p_trolin_rec.from_subinventory_code, l_trolin_rec.from_subinventory_code)
2896: OR (p_trolin_rec.from_subinventory_code = fnd_api.g_miss_char
2897: AND l_trolin_rec.from_subinventory_code IS NULL
2898: )
2899: )
2900: AND (inv_globals.equal(p_trolin_rec.from_subinventory_id, l_trolin_rec.from_subinventory_id)
2897: AND l_trolin_rec.from_subinventory_code IS NULL
2898: )
2899: )
2900: AND (inv_globals.equal(p_trolin_rec.from_subinventory_id, l_trolin_rec.from_subinventory_id)
2901: OR (p_trolin_rec.from_subinventory_id = fnd_api.g_miss_num
2902: AND l_trolin_rec.from_subinventory_id IS NULL
2903: )
2904: )
2905: AND (inv_globals.equal(p_trolin_rec.header_id, l_trolin_rec.header_id)
2902: AND l_trolin_rec.from_subinventory_id IS NULL
2903: )
2904: )
2905: AND (inv_globals.equal(p_trolin_rec.header_id, l_trolin_rec.header_id)
2906: OR (p_trolin_rec.header_id = fnd_api.g_miss_num
2907: AND l_trolin_rec.header_id IS NULL
2908: )
2909: )
2910: AND (inv_globals.equal(p_trolin_rec.inventory_item_id, l_trolin_rec.inventory_item_id)
2907: AND l_trolin_rec.header_id IS NULL
2908: )
2909: )
2910: AND (inv_globals.equal(p_trolin_rec.inventory_item_id, l_trolin_rec.inventory_item_id)
2911: OR (p_trolin_rec.inventory_item_id = fnd_api.g_miss_num
2912: AND l_trolin_rec.inventory_item_id IS NULL
2913: )
2914: )
2915: AND (inv_globals.equal(p_trolin_rec.last_updated_by, l_trolin_rec.last_updated_by)
2912: AND l_trolin_rec.inventory_item_id IS NULL
2913: )
2914: )
2915: AND (inv_globals.equal(p_trolin_rec.last_updated_by, l_trolin_rec.last_updated_by)
2916: OR (p_trolin_rec.last_updated_by = fnd_api.g_miss_num
2917: AND l_trolin_rec.last_updated_by IS NULL
2918: )
2919: )
2920: AND (inv_globals.equal(p_trolin_rec.last_update_date, l_trolin_rec.last_update_date)
2917: AND l_trolin_rec.last_updated_by IS NULL
2918: )
2919: )
2920: AND (inv_globals.equal(p_trolin_rec.last_update_date, l_trolin_rec.last_update_date)
2921: OR (p_trolin_rec.last_update_date = fnd_api.g_miss_date
2922: AND l_trolin_rec.last_update_date IS NULL
2923: )
2924: )
2925: AND (inv_globals.equal(p_trolin_rec.last_update_login, l_trolin_rec.last_update_login)
2922: AND l_trolin_rec.last_update_date IS NULL
2923: )
2924: )
2925: AND (inv_globals.equal(p_trolin_rec.last_update_login, l_trolin_rec.last_update_login)
2926: OR (p_trolin_rec.last_update_login = fnd_api.g_miss_num
2927: AND l_trolin_rec.last_update_login IS NULL
2928: )
2929: )
2930: AND (inv_globals.equal(p_trolin_rec.line_id, l_trolin_rec.line_id)
2927: AND l_trolin_rec.last_update_login IS NULL
2928: )
2929: )
2930: AND (inv_globals.equal(p_trolin_rec.line_id, l_trolin_rec.line_id)
2931: OR (p_trolin_rec.line_id = fnd_api.g_miss_num
2932: AND l_trolin_rec.line_id IS NULL
2933: )
2934: )
2935: AND (inv_globals.equal(p_trolin_rec.line_number, l_trolin_rec.line_number)
2932: AND l_trolin_rec.line_id IS NULL
2933: )
2934: )
2935: AND (inv_globals.equal(p_trolin_rec.line_number, l_trolin_rec.line_number)
2936: OR (p_trolin_rec.line_number = fnd_api.g_miss_num
2937: AND l_trolin_rec.line_number IS NULL
2938: )
2939: )
2940: AND (inv_globals.equal(p_trolin_rec.line_status, l_trolin_rec.line_status)
2937: AND l_trolin_rec.line_number IS NULL
2938: )
2939: )
2940: AND (inv_globals.equal(p_trolin_rec.line_status, l_trolin_rec.line_status)
2941: OR (p_trolin_rec.line_status = fnd_api.g_miss_num
2942: AND l_trolin_rec.line_status IS NULL
2943: )
2944: )
2945: AND (inv_globals.equal(p_trolin_rec.lot_number, l_trolin_rec.lot_number)
2942: AND l_trolin_rec.line_status IS NULL
2943: )
2944: )
2945: AND (inv_globals.equal(p_trolin_rec.lot_number, l_trolin_rec.lot_number)
2946: OR (p_trolin_rec.lot_number = fnd_api.g_miss_char
2947: AND l_trolin_rec.lot_number IS NULL
2948: )
2949: )
2950: AND (inv_globals.equal(p_trolin_rec.organization_id, l_trolin_rec.organization_id)
2947: AND l_trolin_rec.lot_number IS NULL
2948: )
2949: )
2950: AND (inv_globals.equal(p_trolin_rec.organization_id, l_trolin_rec.organization_id)
2951: OR (p_trolin_rec.organization_id = fnd_api.g_miss_num
2952: AND l_trolin_rec.organization_id IS NULL
2953: )
2954: )
2955: AND (inv_globals.equal(p_trolin_rec.program_application_id, l_trolin_rec.program_application_id)
2952: AND l_trolin_rec.organization_id IS NULL
2953: )
2954: )
2955: AND (inv_globals.equal(p_trolin_rec.program_application_id, l_trolin_rec.program_application_id)
2956: OR (p_trolin_rec.program_application_id = fnd_api.g_miss_num
2957: AND l_trolin_rec.program_application_id IS NULL
2958: )
2959: )
2960: AND (inv_globals.equal(p_trolin_rec.program_id, l_trolin_rec.program_id)
2957: AND l_trolin_rec.program_application_id IS NULL
2958: )
2959: )
2960: AND (inv_globals.equal(p_trolin_rec.program_id, l_trolin_rec.program_id)
2961: OR (p_trolin_rec.program_id = fnd_api.g_miss_num
2962: AND l_trolin_rec.program_id IS NULL
2963: )
2964: )
2965: AND (inv_globals.equal(p_trolin_rec.program_update_date, l_trolin_rec.program_update_date)
2962: AND l_trolin_rec.program_id IS NULL
2963: )
2964: )
2965: AND (inv_globals.equal(p_trolin_rec.program_update_date, l_trolin_rec.program_update_date)
2966: OR (p_trolin_rec.program_update_date = fnd_api.g_miss_date
2967: AND l_trolin_rec.program_update_date IS NOT NULL
2968: )
2969: )
2970: AND (inv_globals.equal(p_trolin_rec.project_id, l_trolin_rec.project_id)
2967: AND l_trolin_rec.program_update_date IS NOT NULL
2968: )
2969: )
2970: AND (inv_globals.equal(p_trolin_rec.project_id, l_trolin_rec.project_id)
2971: OR (p_trolin_rec.project_id = fnd_api.g_miss_num
2972: AND l_trolin_rec.project_id IS NULL
2973: )
2974: )
2975: AND (inv_globals.equal(p_trolin_rec.quantity, l_trolin_rec.quantity)
2972: AND l_trolin_rec.project_id IS NULL
2973: )
2974: )
2975: AND (inv_globals.equal(p_trolin_rec.quantity, l_trolin_rec.quantity)
2976: OR (p_trolin_rec.quantity = fnd_api.g_miss_num
2977: AND l_trolin_rec.quantity IS NULL
2978: )
2979: )
2980: AND (inv_globals.equal(p_trolin_rec.quantity_delivered, l_trolin_rec.quantity_delivered)
2977: AND l_trolin_rec.quantity IS NULL
2978: )
2979: )
2980: AND (inv_globals.equal(p_trolin_rec.quantity_delivered, l_trolin_rec.quantity_delivered)
2981: OR (p_trolin_rec.quantity_delivered = fnd_api.g_miss_num
2982: AND l_trolin_rec.quantity_delivered IS NULL
2983: )
2984: )
2985: AND (inv_globals.equal(p_trolin_rec.quantity_detailed, l_trolin_rec.quantity_detailed)
2982: AND l_trolin_rec.quantity_delivered IS NULL
2983: )
2984: )
2985: AND (inv_globals.equal(p_trolin_rec.quantity_detailed, l_trolin_rec.quantity_detailed)
2986: OR (p_trolin_rec.quantity_detailed = fnd_api.g_miss_num
2987: AND l_trolin_rec.quantity_detailed IS NULL
2988: )
2989: )
2990: AND (inv_globals.equal(p_trolin_rec.reason_id, l_trolin_rec.reason_id)
2987: AND l_trolin_rec.quantity_detailed IS NULL
2988: )
2989: )
2990: AND (inv_globals.equal(p_trolin_rec.reason_id, l_trolin_rec.reason_id)
2991: OR (p_trolin_rec.reason_id = fnd_api.g_miss_num
2992: AND l_trolin_rec.reason_id IS NULL
2993: )
2994: )
2995: AND (inv_globals.equal(p_trolin_rec.REFERENCE, l_trolin_rec.REFERENCE)
2992: AND l_trolin_rec.reason_id IS NULL
2993: )
2994: )
2995: AND (inv_globals.equal(p_trolin_rec.REFERENCE, l_trolin_rec.REFERENCE)
2996: OR (p_trolin_rec.REFERENCE = fnd_api.g_miss_char
2997: AND l_trolin_rec.REFERENCE IS NULL
2998: )
2999: )
3000: AND (inv_globals.equal(p_trolin_rec.reference_id, l_trolin_rec.reference_id)
2997: AND l_trolin_rec.REFERENCE IS NULL
2998: )
2999: )
3000: AND (inv_globals.equal(p_trolin_rec.reference_id, l_trolin_rec.reference_id)
3001: OR (p_trolin_rec.reference_id = fnd_api.g_miss_num
3002: AND l_trolin_rec.reference_id IS NULL
3003: )
3004: )
3005: AND (inv_globals.equal(p_trolin_rec.reference_type_code, l_trolin_rec.reference_type_code)
3002: AND l_trolin_rec.reference_id IS NULL
3003: )
3004: )
3005: AND (inv_globals.equal(p_trolin_rec.reference_type_code, l_trolin_rec.reference_type_code)
3006: OR (l_trolin_rec.reference_type_code = fnd_api.g_miss_num
3007: AND l_trolin_rec.reference_type_code IS NULL
3008: )
3009: )
3010: AND (inv_globals.equal(p_trolin_rec.request_id, l_trolin_rec.request_id)
3007: AND l_trolin_rec.reference_type_code IS NULL
3008: )
3009: )
3010: AND (inv_globals.equal(p_trolin_rec.request_id, l_trolin_rec.request_id)
3011: OR (p_trolin_rec.request_id = fnd_api.g_miss_num
3012: AND l_trolin_rec.request_id IS NULL
3013: )
3014: )
3015: AND (inv_globals.equal(p_trolin_rec.revision, l_trolin_rec.revision)
3012: AND l_trolin_rec.request_id IS NULL
3013: )
3014: )
3015: AND (inv_globals.equal(p_trolin_rec.revision, l_trolin_rec.revision)
3016: OR (p_trolin_rec.revision = fnd_api.g_miss_char
3017: AND l_trolin_rec.revision IS NULL
3018: )
3019: )
3020: AND (inv_globals.equal(p_trolin_rec.serial_number_end, l_trolin_rec.serial_number_end)
3017: AND l_trolin_rec.revision IS NULL
3018: )
3019: )
3020: AND (inv_globals.equal(p_trolin_rec.serial_number_end, l_trolin_rec.serial_number_end)
3021: OR (p_trolin_rec.serial_number_end = fnd_api.g_miss_char
3022: AND l_trolin_rec.serial_number_end IS NULL
3023: )
3024: )
3025: AND (inv_globals.equal(p_trolin_rec.serial_number_start, l_trolin_rec.serial_number_start)
3022: AND l_trolin_rec.serial_number_end IS NULL
3023: )
3024: )
3025: AND (inv_globals.equal(p_trolin_rec.serial_number_start, l_trolin_rec.serial_number_start)
3026: OR (p_trolin_rec.serial_number_start = fnd_api.g_miss_char
3027: AND l_trolin_rec.serial_number_start IS NULL
3028: )
3029: )
3030: AND (inv_globals.equal(p_trolin_rec.status_date, l_trolin_rec.status_date)
3027: AND l_trolin_rec.serial_number_start IS NULL
3028: )
3029: )
3030: AND (inv_globals.equal(p_trolin_rec.status_date, l_trolin_rec.status_date)
3031: OR (p_trolin_rec.status_date = fnd_api.g_miss_date
3032: AND l_trolin_rec.status_date IS NULL
3033: )
3034: )
3035: AND (inv_globals.equal(p_trolin_rec.task_id, l_trolin_rec.task_id)
3032: AND l_trolin_rec.status_date IS NULL
3033: )
3034: )
3035: AND (inv_globals.equal(p_trolin_rec.task_id, l_trolin_rec.task_id)
3036: OR (p_trolin_rec.task_id = fnd_api.g_miss_num
3037: AND l_trolin_rec.task_id IS NULL
3038: )
3039: )
3040: AND (inv_globals.equal(p_trolin_rec.to_account_id, l_trolin_rec.to_account_id)
3037: AND l_trolin_rec.task_id IS NULL
3038: )
3039: )
3040: AND (inv_globals.equal(p_trolin_rec.to_account_id, l_trolin_rec.to_account_id)
3041: OR (p_trolin_rec.to_account_id = fnd_api.g_miss_num
3042: AND l_trolin_rec.to_account_id IS NULL
3043: )
3044: )
3045: AND (inv_globals.equal(p_trolin_rec.to_locator_id, l_trolin_rec.to_locator_id)
3042: AND l_trolin_rec.to_account_id IS NULL
3043: )
3044: )
3045: AND (inv_globals.equal(p_trolin_rec.to_locator_id, l_trolin_rec.to_locator_id)
3046: OR (p_trolin_rec.to_locator_id = fnd_api.g_miss_num
3047: AND l_trolin_rec.to_locator_id IS NULL
3048: )
3049: )
3050: AND (inv_globals.equal(p_trolin_rec.to_subinventory_code, l_trolin_rec.to_subinventory_code)
3047: AND l_trolin_rec.to_locator_id IS NULL
3048: )
3049: )
3050: AND (inv_globals.equal(p_trolin_rec.to_subinventory_code, l_trolin_rec.to_subinventory_code)
3051: OR (p_trolin_rec.to_subinventory_code = fnd_api.g_miss_char
3052: AND l_trolin_rec.to_subinventory_code IS NULL
3053: )
3054: )
3055: AND (inv_globals.equal(p_trolin_rec.to_subinventory_id, l_trolin_rec.to_subinventory_id)
3052: AND l_trolin_rec.to_subinventory_code IS NULL
3053: )
3054: )
3055: AND (inv_globals.equal(p_trolin_rec.to_subinventory_id, l_trolin_rec.to_subinventory_id)
3056: OR (p_trolin_rec.to_subinventory_id = fnd_api.g_miss_num
3057: AND l_trolin_rec.to_subinventory_id IS NULL
3058: )
3059: )
3060: AND (inv_globals.equal(p_trolin_rec.transaction_header_id, l_trolin_rec.transaction_header_id)
3057: AND l_trolin_rec.to_subinventory_id IS NULL
3058: )
3059: )
3060: AND (inv_globals.equal(p_trolin_rec.transaction_header_id, l_trolin_rec.transaction_header_id)
3061: OR (p_trolin_rec.transaction_header_id = fnd_api.g_miss_num
3062: AND l_trolin_rec.transaction_header_id IS NULL
3063: )
3064: )
3065: AND (inv_globals.equal(p_trolin_rec.uom_code, l_trolin_rec.uom_code)
3062: AND l_trolin_rec.transaction_header_id IS NULL
3063: )
3064: )
3065: AND (inv_globals.equal(p_trolin_rec.uom_code, l_trolin_rec.uom_code)
3066: OR (p_trolin_rec.uom_code = fnd_api.g_miss_char
3067: AND p_trolin_rec.uom_code IS NULL
3068: )
3069: )
3070: AND (inv_globals.equal(p_trolin_rec.transaction_type_id, l_trolin_rec.transaction_type_id)
3067: AND p_trolin_rec.uom_code IS NULL
3068: )
3069: )
3070: AND (inv_globals.equal(p_trolin_rec.transaction_type_id, l_trolin_rec.transaction_type_id)
3071: OR (p_trolin_rec.transaction_type_id = fnd_api.g_miss_num
3072: AND l_trolin_rec.transaction_type_id IS NULL
3073: )
3074: )
3075: AND (inv_globals.equal(p_trolin_rec.transaction_source_type_id, l_trolin_rec.transaction_source_type_id)
3072: AND l_trolin_rec.transaction_type_id IS NULL
3073: )
3074: )
3075: AND (inv_globals.equal(p_trolin_rec.transaction_source_type_id, l_trolin_rec.transaction_source_type_id)
3076: OR (p_trolin_rec.transaction_source_type_id = fnd_api.g_miss_num
3077: AND l_trolin_rec.transaction_source_type_id IS NULL
3078: )
3079: )
3080: AND (inv_globals.equal(p_trolin_rec.txn_source_id, l_trolin_rec.txn_source_id)
3077: AND l_trolin_rec.transaction_source_type_id IS NULL
3078: )
3079: )
3080: AND (inv_globals.equal(p_trolin_rec.txn_source_id, l_trolin_rec.txn_source_id)
3081: OR (p_trolin_rec.txn_source_id = fnd_api.g_miss_num
3082: AND l_trolin_rec.txn_source_id IS NULL
3083: )
3084: )
3085: AND inv_globals.equal(p_trolin_rec.txn_source_line_id, l_trolin_rec.txn_source_line_id)
3083: )
3084: )
3085: AND inv_globals.equal(p_trolin_rec.txn_source_line_id, l_trolin_rec.txn_source_line_id)
3086: AND (inv_globals.equal(p_trolin_rec.txn_source_line_detail_id, l_trolin_rec.txn_source_line_detail_id)
3087: OR (p_trolin_rec.txn_source_line_detail_id = fnd_api.g_miss_num
3088: AND l_trolin_rec.txn_source_line_detail_id IS NULL
3089: )
3090: )
3091: AND (inv_globals.equal(p_trolin_rec.primary_quantity, l_trolin_rec.primary_quantity)
3088: AND l_trolin_rec.txn_source_line_detail_id IS NULL
3089: )
3090: )
3091: AND (inv_globals.equal(p_trolin_rec.primary_quantity, l_trolin_rec.primary_quantity)
3092: OR (p_trolin_rec.primary_quantity = fnd_api.g_miss_num
3093: AND l_trolin_rec.primary_quantity IS NULL
3094: )
3095: )
3096: AND (inv_globals.equal(p_trolin_rec.to_organization_id, l_trolin_rec.to_organization_id)
3093: AND l_trolin_rec.primary_quantity IS NULL
3094: )
3095: )
3096: AND (inv_globals.equal(p_trolin_rec.to_organization_id, l_trolin_rec.to_organization_id)
3097: OR (p_trolin_rec.to_organization_id = fnd_api.g_miss_num
3098: AND l_trolin_rec.to_organization_id IS NULL
3099: )
3100: )
3101: AND (inv_globals.equal(p_trolin_rec.pick_strategy_id, l_trolin_rec.pick_strategy_id)
3098: AND l_trolin_rec.to_organization_id IS NULL
3099: )
3100: )
3101: AND (inv_globals.equal(p_trolin_rec.pick_strategy_id, l_trolin_rec.pick_strategy_id)
3102: OR (p_trolin_rec.pick_strategy_id = fnd_api.g_miss_num
3103: AND l_trolin_rec.pick_strategy_id IS NULL
3104: )
3105: )
3106: AND (inv_globals.equal(p_trolin_rec.put_away_strategy_id, l_trolin_rec.put_away_strategy_id)
3103: AND l_trolin_rec.pick_strategy_id IS NULL
3104: )
3105: )
3106: AND (inv_globals.equal(p_trolin_rec.put_away_strategy_id, l_trolin_rec.put_away_strategy_id)
3107: OR (p_trolin_rec.put_away_strategy_id = fnd_api.g_miss_num
3108: AND l_trolin_rec.put_away_strategy_id IS NULL
3109: )
3110: )
3111: AND (inv_globals.equal(p_trolin_rec.unit_number, l_trolin_rec.unit_number)
3108: AND l_trolin_rec.put_away_strategy_id IS NULL
3109: )
3110: )
3111: AND (inv_globals.equal(p_trolin_rec.unit_number, l_trolin_rec.unit_number)
3112: OR (p_trolin_rec.unit_number = fnd_api.g_miss_char
3113: AND l_trolin_rec.unit_number IS NULL
3114: )
3115: )
3116: AND (inv_globals.equal(p_trolin_rec.ship_to_location_id, l_trolin_rec.ship_to_location_id)
3113: AND l_trolin_rec.unit_number IS NULL
3114: )
3115: )
3116: AND (inv_globals.equal(p_trolin_rec.ship_to_location_id, l_trolin_rec.ship_to_location_id)
3117: OR (p_trolin_rec.ship_to_location_id = fnd_api.g_miss_num
3118: AND l_trolin_rec.ship_to_location_id IS NULL
3119: )
3120: )
3121: AND (inv_globals.equal(p_trolin_rec.from_cost_group_id, l_trolin_rec.from_cost_group_id)
3118: AND l_trolin_rec.ship_to_location_id IS NULL
3119: )
3120: )
3121: AND (inv_globals.equal(p_trolin_rec.from_cost_group_id, l_trolin_rec.from_cost_group_id)
3122: OR (p_trolin_rec.from_cost_group_id = fnd_api.g_miss_num
3123: AND l_trolin_rec.to_cost_group_id IS NULL
3124: )
3125: )
3126: AND (inv_globals.equal(p_trolin_rec.to_cost_group_id, l_trolin_rec.to_cost_group_id)
3123: AND l_trolin_rec.to_cost_group_id IS NULL
3124: )
3125: )
3126: AND (inv_globals.equal(p_trolin_rec.to_cost_group_id, l_trolin_rec.to_cost_group_id)
3127: OR (p_trolin_rec.to_cost_group_id = fnd_api.g_miss_num
3128: AND l_trolin_rec.to_cost_group_id IS NULL
3129: )
3130: )
3131: AND (inv_globals.equal(p_trolin_rec.lpn_id, l_trolin_rec.lpn_id)
3128: AND l_trolin_rec.to_cost_group_id IS NULL
3129: )
3130: )
3131: AND (inv_globals.equal(p_trolin_rec.lpn_id, l_trolin_rec.lpn_id)
3132: OR (p_trolin_rec.lpn_id = fnd_api.g_miss_num
3133: AND l_trolin_rec.lpn_id IS NULL
3134: )
3135: )
3136: AND (inv_globals.equal(p_trolin_rec.to_lpn_id, l_trolin_rec.to_lpn_id)
3133: AND l_trolin_rec.lpn_id IS NULL
3134: )
3135: )
3136: AND (inv_globals.equal(p_trolin_rec.to_lpn_id, l_trolin_rec.to_lpn_id)
3137: OR (p_trolin_rec.to_lpn_id = fnd_api.g_miss_num
3138: AND l_trolin_rec.to_lpn_id IS NULL
3139: )
3140: )
3141: AND inv_globals.equal(p_trolin_rec.inspection_status, l_trolin_rec.inspection_status)
3139: )
3140: )
3141: AND inv_globals.equal(p_trolin_rec.inspection_status, l_trolin_rec.inspection_status)
3142: AND (inv_globals.equal(p_trolin_rec.pick_methodology_id, l_trolin_rec.pick_methodology_id)
3143: OR (p_trolin_rec.pick_methodology_id = fnd_api.g_miss_num
3144: AND l_trolin_rec.pick_methodology_id IS NULL
3145: )
3146: )
3147: AND (inv_globals.equal(p_trolin_rec.container_item_id, l_trolin_rec.container_item_id)
3144: AND l_trolin_rec.pick_methodology_id IS NULL
3145: )
3146: )
3147: AND (inv_globals.equal(p_trolin_rec.container_item_id, l_trolin_rec.container_item_id)
3148: OR (p_trolin_rec.container_item_id = fnd_api.g_miss_num
3149: AND l_trolin_rec.container_item_id IS NULL
3150: )
3151: )
3152: AND (inv_globals.equal(p_trolin_rec.carton_grouping_id, l_trolin_rec.carton_grouping_id)
3149: AND l_trolin_rec.container_item_id IS NULL
3150: )
3151: )
3152: AND (inv_globals.equal(p_trolin_rec.carton_grouping_id, l_trolin_rec.carton_grouping_id)
3153: OR (p_trolin_rec.carton_grouping_id = fnd_api.g_miss_num
3154: AND l_trolin_rec.carton_grouping_id IS NULL
3155: )
3156: )
3157: AND (inv_globals.equal(p_trolin_rec.wms_process_flag, l_trolin_rec.wms_process_flag)
3154: AND l_trolin_rec.carton_grouping_id IS NULL
3155: )
3156: )
3157: AND (inv_globals.equal(p_trolin_rec.wms_process_flag, l_trolin_rec.wms_process_flag)
3158: OR (p_trolin_rec.wms_process_flag = fnd_api.g_miss_char
3159: AND l_trolin_rec.wms_process_flag IS NULL
3160: )
3161: )
3162: AND (inv_globals.equal(p_trolin_rec.pick_slip_number, l_trolin_rec.pick_slip_number)
3159: AND l_trolin_rec.wms_process_flag IS NULL
3160: )
3161: )
3162: AND (inv_globals.equal(p_trolin_rec.pick_slip_number, l_trolin_rec.pick_slip_number)
3163: OR (p_trolin_rec.pick_slip_number = fnd_api.g_miss_num
3164: AND l_trolin_rec.pick_slip_number IS NULL
3165: )
3166: )
3167: AND (inv_globals.equal(p_trolin_rec.pick_slip_date, l_trolin_rec.pick_slip_date)
3164: AND l_trolin_rec.pick_slip_number IS NULL
3165: )
3166: )
3167: AND (inv_globals.equal(p_trolin_rec.pick_slip_date, l_trolin_rec.pick_slip_date)
3168: OR (p_trolin_rec.pick_slip_date = fnd_api.g_miss_date
3169: AND l_trolin_rec.pick_slip_date IS NULL
3170: )
3171: )
3172: AND (inv_globals.equal(p_trolin_rec.ship_set_id, l_trolin_rec.ship_set_id)
3169: AND l_trolin_rec.pick_slip_date IS NULL
3170: )
3171: )
3172: AND (inv_globals.equal(p_trolin_rec.ship_set_id, l_trolin_rec.ship_set_id)
3173: OR (p_trolin_rec.ship_set_id = fnd_api.g_miss_num
3174: AND l_trolin_rec.ship_set_id IS NULL
3175: )
3176: )
3177: AND (inv_globals.equal(p_trolin_rec.ship_model_id, l_trolin_rec.ship_model_id)
3174: AND l_trolin_rec.ship_set_id IS NULL
3175: )
3176: )
3177: AND (inv_globals.equal(p_trolin_rec.ship_model_id, l_trolin_rec.ship_model_id)
3178: OR (p_trolin_rec.ship_model_id = fnd_api.g_miss_num
3179: AND l_trolin_rec.ship_model_id IS NULL
3180: )
3181: )
3182: AND (inv_globals.equal(p_trolin_rec.model_quantity, l_trolin_rec.model_quantity)
3179: AND l_trolin_rec.ship_model_id IS NULL
3180: )
3181: )
3182: AND (inv_globals.equal(p_trolin_rec.model_quantity, l_trolin_rec.model_quantity)
3183: OR (p_trolin_rec.model_quantity = fnd_api.g_miss_num
3184: AND l_trolin_rec.model_quantity IS NULL
3185: )
3186: ) THEN
3187: -- Row has not changed. Set out parameter.
3188:
3189: x_trolin_rec := l_trolin_rec;
3190: -- Set return status
3191:
3192: x_return_status := fnd_api.g_ret_sts_success;
3193: x_trolin_rec.return_status := fnd_api.g_ret_sts_success;
3194: ELSE
3195: -- Row has changed by another user.
3196:
3189: x_trolin_rec := l_trolin_rec;
3190: -- Set return status
3191:
3192: x_return_status := fnd_api.g_ret_sts_success;
3193: x_trolin_rec.return_status := fnd_api.g_ret_sts_success;
3194: ELSE
3195: -- Row has changed by another user.
3196:
3197: x_return_status := fnd_api.g_ret_sts_error;
3193: x_trolin_rec.return_status := fnd_api.g_ret_sts_success;
3194: ELSE
3195: -- Row has changed by another user.
3196:
3197: x_return_status := fnd_api.g_ret_sts_error;
3198: x_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3199:
3200: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3201: fnd_message.set_name('INV', 'OE_LOCK_ROW_CHANGED');
3194: ELSE
3195: -- Row has changed by another user.
3196:
3197: x_return_status := fnd_api.g_ret_sts_error;
3198: x_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3199:
3200: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3201: fnd_message.set_name('INV', 'OE_LOCK_ROW_CHANGED');
3202: fnd_msg_pub.ADD;
3204: END IF;
3205: --Line2086
3206: EXCEPTION
3207: WHEN NO_DATA_FOUND THEN
3208: x_return_status := fnd_api.g_ret_sts_error;
3209: x_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3210:
3211: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3212: fnd_message.set_name('INV', 'OE_LOCK_ROW_DELETED');
3205: --Line2086
3206: EXCEPTION
3207: WHEN NO_DATA_FOUND THEN
3208: x_return_status := fnd_api.g_ret_sts_error;
3209: x_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3210:
3211: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3212: fnd_message.set_name('INV', 'OE_LOCK_ROW_DELETED');
3213: fnd_msg_pub.ADD;
3212: fnd_message.set_name('INV', 'OE_LOCK_ROW_DELETED');
3213: fnd_msg_pub.ADD;
3214: END IF;
3215: WHEN app_exceptions.record_lock_exception THEN
3216: x_return_status := fnd_api.g_ret_sts_error;
3217: x_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3218:
3219: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3220: fnd_message.set_name('INV', 'OE_LOCK_ROW_ALREADY_LOCKED');
3213: fnd_msg_pub.ADD;
3214: END IF;
3215: WHEN app_exceptions.record_lock_exception THEN
3216: x_return_status := fnd_api.g_ret_sts_error;
3217: x_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3218:
3219: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3220: fnd_message.set_name('INV', 'OE_LOCK_ROW_ALREADY_LOCKED');
3221: fnd_msg_pub.ADD;
3220: fnd_message.set_name('INV', 'OE_LOCK_ROW_ALREADY_LOCKED');
3221: fnd_msg_pub.ADD;
3222: END IF;
3223: WHEN OTHERS THEN
3224: x_return_status := fnd_api.g_ret_sts_unexp_error;
3225: x_trolin_rec.return_status := fnd_api.g_ret_sts_unexp_error;
3226:
3227: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3228: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Lock_Row');
3221: fnd_msg_pub.ADD;
3222: END IF;
3223: WHEN OTHERS THEN
3224: x_return_status := fnd_api.g_ret_sts_unexp_error;
3225: x_trolin_rec.return_status := fnd_api.g_ret_sts_unexp_error;
3226:
3227: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3228: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Lock_Row');
3229: END IF;
3236: l_trolin_val_rec inv_move_order_pub.trolin_val_rec_type;
3237: BEGIN
3238: -- Line2147
3239: IF p_trolin_rec.from_locator_id IS NOT NULL
3240: AND p_trolin_rec.from_locator_id <> fnd_api.g_miss_num
3241: AND NOT inv_globals.equal(p_trolin_rec.from_locator_id, p_old_trolin_rec.from_locator_id) THEN
3242: l_trolin_val_rec.from_locator := inv_id_to_value.from_locator(p_from_locator_id => p_trolin_rec.from_locator_id);
3243: END IF;
3244:
3242: l_trolin_val_rec.from_locator := inv_id_to_value.from_locator(p_from_locator_id => p_trolin_rec.from_locator_id);
3243: END IF;
3244:
3245: -- IF p_trolin_rec.from_subinventory_code IS NOT NULL AND
3246: -- p_trolin_rec.from_subinventory_code <> FND_API.G_MISS_CHAR AND
3247: -- NOT INV_GLOBALS.Equal(p_trolin_rec.from_subinventory_code,
3248: -- p_old_trolin_rec.from_subinventory_code)
3249: -- THEN
3250: -- l_trolin_val_rec.from_subinventory := INV_Id_To_Value.From_Subinventory
3252: -- );
3253: -- END IF; -- Generated
3254: -- Line 2167
3255: IF p_trolin_rec.from_subinventory_id IS NOT NULL
3256: AND p_trolin_rec.from_subinventory_id <> fnd_api.g_miss_num
3257: AND NOT inv_globals.equal(p_trolin_rec.from_subinventory_id, p_old_trolin_rec.from_subinventory_id) THEN
3258: l_trolin_val_rec.from_subinventory := inv_id_to_value.from_subinventory(p_from_subinventory_id => p_trolin_rec.from_subinventory_id);
3259: -- ( p_from_subinventory_id => p_trolin_rec.from_subinventory_id
3260: -- );
3260: -- );
3261: END IF;
3262:
3263: IF p_trolin_rec.header_id IS NOT NULL
3264: AND p_trolin_rec.header_id <> fnd_api.g_miss_num
3265: AND NOT inv_globals.equal(p_trolin_rec.header_id, p_old_trolin_rec.header_id) THEN
3266: l_trolin_val_rec.header := inv_id_to_value.header(p_header_id => p_trolin_rec.header_id);
3267: END IF;
3268:
3266: l_trolin_val_rec.header := inv_id_to_value.header(p_header_id => p_trolin_rec.header_id);
3267: END IF;
3268:
3269: IF p_trolin_rec.inventory_item_id IS NOT NULL
3270: AND p_trolin_rec.inventory_item_id <> fnd_api.g_miss_num
3271: AND NOT inv_globals.equal(p_trolin_rec.inventory_item_id, p_old_trolin_rec.inventory_item_id) THEN
3272: l_trolin_val_rec.inventory_item := inv_id_to_value.inventory_item(p_inventory_item_id => p_trolin_rec.inventory_item_id);
3273: END IF;
3274:
3272: l_trolin_val_rec.inventory_item := inv_id_to_value.inventory_item(p_inventory_item_id => p_trolin_rec.inventory_item_id);
3273: END IF;
3274:
3275: IF p_trolin_rec.line_id IS NOT NULL
3276: AND p_trolin_rec.line_id <> fnd_api.g_miss_num
3277: AND NOT inv_globals.equal(p_trolin_rec.line_id, p_old_trolin_rec.line_id) THEN
3278: l_trolin_val_rec.line := inv_id_to_value.line(p_line_id => p_trolin_rec.line_id);
3279: END IF;
3280:
3278: l_trolin_val_rec.line := inv_id_to_value.line(p_line_id => p_trolin_rec.line_id);
3279: END IF;
3280:
3281: IF p_trolin_rec.organization_id IS NOT NULL
3282: AND p_trolin_rec.organization_id <> fnd_api.g_miss_num
3283: AND NOT inv_globals.equal(p_trolin_rec.organization_id, p_old_trolin_rec.organization_id) THEN
3284: l_trolin_val_rec.ORGANIZATION := inv_id_to_value.ORGANIZATION(p_organization_id => p_trolin_rec.organization_id);
3285: END IF;
3286:
3284: l_trolin_val_rec.ORGANIZATION := inv_id_to_value.ORGANIZATION(p_organization_id => p_trolin_rec.organization_id);
3285: END IF;
3286:
3287: IF p_trolin_rec.to_organization_id IS NOT NULL
3288: AND p_trolin_rec.to_organization_id <> fnd_api.g_miss_num
3289: AND NOT inv_globals.equal(p_trolin_rec.to_organization_id, p_old_trolin_rec.to_organization_id) THEN
3290: l_trolin_val_rec.to_organization := inv_id_to_value.to_organization(p_to_organization_id => p_trolin_rec.to_organization_id);
3291: END IF;
3292:
3290: l_trolin_val_rec.to_organization := inv_id_to_value.to_organization(p_to_organization_id => p_trolin_rec.to_organization_id);
3291: END IF;
3292:
3293: IF p_trolin_rec.project_id IS NOT NULL
3294: AND p_trolin_rec.project_id <> fnd_api.g_miss_num
3295: AND NOT inv_globals.equal(p_trolin_rec.project_id, p_old_trolin_rec.project_id) THEN
3296: l_trolin_val_rec.project := inv_id_to_value.project(p_project_id => p_trolin_rec.project_id);
3297: END IF;
3298:
3296: l_trolin_val_rec.project := inv_id_to_value.project(p_project_id => p_trolin_rec.project_id);
3297: END IF;
3298:
3299: IF p_trolin_rec.reason_id IS NOT NULL
3300: AND p_trolin_rec.reason_id <> fnd_api.g_miss_num
3301: AND NOT inv_globals.equal(p_trolin_rec.reason_id, p_old_trolin_rec.reason_id) THEN
3302: l_trolin_val_rec.reason := inv_id_to_value.reason(p_reason_id => p_trolin_rec.reason_id);
3303: END IF;
3304:
3302: l_trolin_val_rec.reason := inv_id_to_value.reason(p_reason_id => p_trolin_rec.reason_id);
3303: END IF;
3304:
3305: IF p_trolin_rec.reference_id IS NOT NULL
3306: AND p_trolin_rec.reference_id <> fnd_api.g_miss_num
3307: AND NOT inv_globals.equal(p_trolin_rec.reference_id, p_old_trolin_rec.reference_id) THEN
3308: l_trolin_val_rec.REFERENCE := inv_id_to_value.REFERENCE(p_reference_id => p_trolin_rec.reference_id);
3309: END IF;
3310:
3308: l_trolin_val_rec.REFERENCE := inv_id_to_value.REFERENCE(p_reference_id => p_trolin_rec.reference_id);
3309: END IF;
3310:
3311: IF p_trolin_rec.reference_type_code IS NOT NULL
3312: AND p_trolin_rec.reference_type_code <> fnd_api.g_miss_num
3313: AND NOT inv_globals.equal(p_trolin_rec.reference_type_code, p_old_trolin_rec.reference_type_code) THEN
3314: l_trolin_val_rec.reference_type := inv_id_to_value.reference_type(p_reference_type_code => p_trolin_rec.reference_type_code);
3315: END IF;
3316:
3314: l_trolin_val_rec.reference_type := inv_id_to_value.reference_type(p_reference_type_code => p_trolin_rec.reference_type_code);
3315: END IF;
3316:
3317: IF p_trolin_rec.task_id IS NOT NULL
3318: AND p_trolin_rec.task_id <> fnd_api.g_miss_num
3319: AND NOT inv_globals.equal(p_trolin_rec.task_id, p_old_trolin_rec.task_id) THEN
3320: l_trolin_val_rec.task := inv_id_to_value.task(p_task_id => p_trolin_rec.task_id);
3321: END IF;
3322:
3320: l_trolin_val_rec.task := inv_id_to_value.task(p_task_id => p_trolin_rec.task_id);
3321: END IF;
3322:
3323: IF p_trolin_rec.to_account_id IS NOT NULL
3324: AND p_trolin_rec.to_account_id <> fnd_api.g_miss_num
3325: AND NOT inv_globals.equal(p_trolin_rec.to_account_id, p_old_trolin_rec.to_account_id) THEN
3326: l_trolin_val_rec.to_account := inv_id_to_value.to_account(p_to_account_id => p_trolin_rec.to_account_id);
3327: END IF;
3328:
3326: l_trolin_val_rec.to_account := inv_id_to_value.to_account(p_to_account_id => p_trolin_rec.to_account_id);
3327: END IF;
3328:
3329: IF p_trolin_rec.to_locator_id IS NOT NULL
3330: AND p_trolin_rec.to_locator_id <> fnd_api.g_miss_num
3331: AND NOT inv_globals.equal(p_trolin_rec.to_locator_id, p_old_trolin_rec.to_locator_id) THEN
3332: l_trolin_val_rec.to_locator := inv_id_to_value.to_locator(p_to_locator_id => p_trolin_rec.to_locator_id);
3333: END IF;
3334:
3332: l_trolin_val_rec.to_locator := inv_id_to_value.to_locator(p_to_locator_id => p_trolin_rec.to_locator_id);
3333: END IF;
3334:
3335: -- IF p_trolin_rec.to_subinventory_code IS NOT NULL AND
3336: -- p_trolin_rec.to_subinventory_code <> FND_API.G_MISS_CHAR AND
3337: -- NOT INV_GLOBALS.Equal(p_trolin_rec.to_subinventory_code,
3338: -- p_old_trolin_rec.to_subinventory_code)
3339: -- THEN
3340: -- l_trolin_val_rec.to_subinventory := INV_Id_To_Value.To_Subinventory
3342: -- );
3343: -- END IF; -- Generated
3344:
3345: IF p_trolin_rec.to_subinventory_id IS NOT NULL
3346: AND p_trolin_rec.to_subinventory_id <> fnd_api.g_miss_num
3347: AND NOT inv_globals.equal(p_trolin_rec.to_subinventory_id, p_old_trolin_rec.to_subinventory_id) THEN
3348: l_trolin_val_rec.to_subinventory := inv_id_to_value.to_subinventory(p_to_subinventory_id => p_trolin_rec.to_subinventory_id);
3349: END IF;
3350:
3348: l_trolin_val_rec.to_subinventory := inv_id_to_value.to_subinventory(p_to_subinventory_id => p_trolin_rec.to_subinventory_id);
3349: END IF;
3350:
3351: IF p_trolin_rec.transaction_header_id IS NOT NULL
3352: AND p_trolin_rec.transaction_header_id <> fnd_api.g_miss_num
3353: AND NOT inv_globals.equal(p_trolin_rec.transaction_header_id, p_old_trolin_rec.transaction_header_id) THEN
3354: l_trolin_val_rec.transaction_header := inv_id_to_value.transaction_header(p_transaction_header_id => p_trolin_rec.transaction_header_id);
3355: END IF;
3356:
3354: l_trolin_val_rec.transaction_header := inv_id_to_value.transaction_header(p_transaction_header_id => p_trolin_rec.transaction_header_id);
3355: END IF;
3356:
3357: IF p_trolin_rec.transaction_type_id IS NOT NULL
3358: AND p_trolin_rec.transaction_type_id <> fnd_api.g_miss_num
3359: AND NOT inv_globals.equal(p_trolin_rec.transaction_type_id, p_old_trolin_rec.transaction_type_id) THEN
3360: l_trolin_val_rec.transaction_type := inv_id_to_value.transaction_type(p_transaction_type_id => p_trolin_rec.transaction_type_id);
3361: END IF;
3362:
3360: l_trolin_val_rec.transaction_type := inv_id_to_value.transaction_type(p_transaction_type_id => p_trolin_rec.transaction_type_id);
3361: END IF;
3362:
3363: IF p_trolin_rec.uom_code IS NOT NULL
3364: AND p_trolin_rec.uom_code <> fnd_api.g_miss_char
3365: AND NOT inv_globals.equal(p_trolin_rec.uom_code, p_old_trolin_rec.uom_code) THEN
3366: l_trolin_val_rec.uom := inv_id_to_value.uom(p_uom_code => p_trolin_rec.uom_code);
3367: END IF;
3368:
3376: l_trolin_rec inv_move_order_pub.trolin_rec_type;
3377: BEGIN
3378: -- initialize return_status.
3379:
3380: l_trolin_rec.return_status := fnd_api.g_ret_sts_success;
3381: -- initialize l_trolin_rec.
3382:
3383: l_trolin_rec := p_trolin_rec;
3384:
3382:
3383: l_trolin_rec := p_trolin_rec;
3384:
3385: /*
3386: IF p_trolin_val_rec.from_locator <> FND_API.G_MISS_CHAR
3387: THEN
3388:
3389: IF p_trolin_rec.from_locator_id <> FND_API.G_MISS_NUM THEN
3390:
3385: /*
3386: IF p_trolin_val_rec.from_locator <> FND_API.G_MISS_CHAR
3387: THEN
3388:
3389: IF p_trolin_rec.from_locator_id <> FND_API.G_MISS_NUM THEN
3390:
3391: l_trolin_rec.from_locator_id := p_trolin_rec.from_locator_id;
3392:
3393: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3405: ( p_organizatoin_id => p_trolin_rec.organization_id,
3406: p_from_locator => p_trolin_val_rec.from_locator
3407: );
3408:
3409: IF l_trolin_rec.from_locator_id = FND_API.G_MISS_NUM THEN
3410: l_trolin_rec.return_status := FND_API.G_RET_STS_ERROR;
3411: END IF;
3412:
3413: END IF;
3406: p_from_locator => p_trolin_val_rec.from_locator
3407: );
3408:
3409: IF l_trolin_rec.from_locator_id = FND_API.G_MISS_NUM THEN
3410: l_trolin_rec.return_status := FND_API.G_RET_STS_ERROR;
3411: END IF;
3412:
3413: END IF;
3414:
3414:
3415: END IF;
3416: */
3417:
3418: IF p_trolin_val_rec.from_subinventory <> fnd_api.g_miss_char THEN
3419: IF p_trolin_rec.from_subinventory_id <> fnd_api.g_miss_num THEN
3420: l_trolin_rec.from_subinventory_id := p_trolin_rec.from_subinventory_id;
3421:
3422: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3415: END IF;
3416: */
3417:
3418: IF p_trolin_val_rec.from_subinventory <> fnd_api.g_miss_char THEN
3419: IF p_trolin_rec.from_subinventory_id <> fnd_api.g_miss_num THEN
3420: l_trolin_rec.from_subinventory_id := p_trolin_rec.from_subinventory_id;
3421:
3422: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3423: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3426: END IF;
3427: ELSE
3428: l_trolin_rec.from_subinventory_id := inv_value_to_id.from_subinventory(p_organization_id => p_trolin_rec.organization_id, p_from_subinventory => p_trolin_val_rec.from_subinventory);
3429:
3430: IF l_trolin_rec.from_subinventory_id = fnd_api.g_miss_num THEN
3431: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3432: END IF;
3433: END IF;
3434: END IF;
3427: ELSE
3428: l_trolin_rec.from_subinventory_id := inv_value_to_id.from_subinventory(p_organization_id => p_trolin_rec.organization_id, p_from_subinventory => p_trolin_val_rec.from_subinventory);
3429:
3430: IF l_trolin_rec.from_subinventory_id = fnd_api.g_miss_num THEN
3431: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3432: END IF;
3433: END IF;
3434: END IF;
3435:
3432: END IF;
3433: END IF;
3434: END IF;
3435:
3436: IF p_trolin_val_rec.header <> fnd_api.g_miss_char THEN
3437: IF p_trolin_rec.header_id <> fnd_api.g_miss_num THEN
3438: l_trolin_rec.header_id := p_trolin_rec.header_id;
3439:
3440: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3433: END IF;
3434: END IF;
3435:
3436: IF p_trolin_val_rec.header <> fnd_api.g_miss_char THEN
3437: IF p_trolin_rec.header_id <> fnd_api.g_miss_num THEN
3438: l_trolin_rec.header_id := p_trolin_rec.header_id;
3439:
3440: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3441: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3444: END IF;
3445: ELSE
3446: l_trolin_rec.header_id := inv_value_to_id.header(p_header => p_trolin_val_rec.header);
3447:
3448: IF l_trolin_rec.header_id = fnd_api.g_miss_num THEN
3449: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3450: END IF;
3451: END IF;
3452: END IF;
3445: ELSE
3446: l_trolin_rec.header_id := inv_value_to_id.header(p_header => p_trolin_val_rec.header);
3447:
3448: IF l_trolin_rec.header_id = fnd_api.g_miss_num THEN
3449: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3450: END IF;
3451: END IF;
3452: END IF;
3453:
3450: END IF;
3451: END IF;
3452: END IF;
3453:
3454: IF p_trolin_val_rec.inventory_item <> fnd_api.g_miss_char THEN
3455: IF p_trolin_rec.inventory_item_id <> fnd_api.g_miss_num THEN
3456: l_trolin_rec.inventory_item_id := p_trolin_rec.inventory_item_id;
3457:
3458: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3451: END IF;
3452: END IF;
3453:
3454: IF p_trolin_val_rec.inventory_item <> fnd_api.g_miss_char THEN
3455: IF p_trolin_rec.inventory_item_id <> fnd_api.g_miss_num THEN
3456: l_trolin_rec.inventory_item_id := p_trolin_rec.inventory_item_id;
3457:
3458: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3459: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3462: END IF;
3463: ELSE
3464: l_trolin_rec.inventory_item_id := inv_value_to_id.inventory_item(p_organization_id => p_trolin_rec.organization_id, p_inventory_item => p_trolin_val_rec.inventory_item);
3465:
3466: IF l_trolin_rec.inventory_item_id = fnd_api.g_miss_num THEN
3467: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3468: END IF;
3469: END IF;
3470: END IF;
3463: ELSE
3464: l_trolin_rec.inventory_item_id := inv_value_to_id.inventory_item(p_organization_id => p_trolin_rec.organization_id, p_inventory_item => p_trolin_val_rec.inventory_item);
3465:
3466: IF l_trolin_rec.inventory_item_id = fnd_api.g_miss_num THEN
3467: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3468: END IF;
3469: END IF;
3470: END IF;
3471:
3468: END IF;
3469: END IF;
3470: END IF;
3471:
3472: IF p_trolin_val_rec.line <> fnd_api.g_miss_char THEN
3473: IF p_trolin_rec.line_id <> fnd_api.g_miss_num THEN
3474: l_trolin_rec.line_id := p_trolin_rec.line_id;
3475:
3476: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3469: END IF;
3470: END IF;
3471:
3472: IF p_trolin_val_rec.line <> fnd_api.g_miss_char THEN
3473: IF p_trolin_rec.line_id <> fnd_api.g_miss_num THEN
3474: l_trolin_rec.line_id := p_trolin_rec.line_id;
3475:
3476: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3477: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3480: END IF;
3481: ELSE
3482: l_trolin_rec.line_id := inv_value_to_id.line(p_line => p_trolin_val_rec.line);
3483:
3484: IF l_trolin_rec.line_id = fnd_api.g_miss_num THEN
3485: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3486: END IF;
3487: END IF;
3488: END IF;
3481: ELSE
3482: l_trolin_rec.line_id := inv_value_to_id.line(p_line => p_trolin_val_rec.line);
3483:
3484: IF l_trolin_rec.line_id = fnd_api.g_miss_num THEN
3485: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3486: END IF;
3487: END IF;
3488: END IF;
3489:
3486: END IF;
3487: END IF;
3488: END IF;
3489:
3490: IF p_trolin_val_rec.ORGANIZATION <> fnd_api.g_miss_char THEN
3491: IF p_trolin_rec.organization_id <> fnd_api.g_miss_num THEN
3492: l_trolin_rec.organization_id := p_trolin_rec.organization_id;
3493:
3494: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3487: END IF;
3488: END IF;
3489:
3490: IF p_trolin_val_rec.ORGANIZATION <> fnd_api.g_miss_char THEN
3491: IF p_trolin_rec.organization_id <> fnd_api.g_miss_num THEN
3492: l_trolin_rec.organization_id := p_trolin_rec.organization_id;
3493:
3494: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3495: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3498: END IF;
3499: ELSE
3500: l_trolin_rec.organization_id := inv_value_to_id.ORGANIZATION(p_organization => p_trolin_val_rec.ORGANIZATION);
3501:
3502: IF l_trolin_rec.organization_id = fnd_api.g_miss_num THEN
3503: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3504: END IF;
3505: END IF;
3506: END IF;
3499: ELSE
3500: l_trolin_rec.organization_id := inv_value_to_id.ORGANIZATION(p_organization => p_trolin_val_rec.ORGANIZATION);
3501:
3502: IF l_trolin_rec.organization_id = fnd_api.g_miss_num THEN
3503: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3504: END IF;
3505: END IF;
3506: END IF;
3507:
3504: END IF;
3505: END IF;
3506: END IF;
3507:
3508: IF p_trolin_val_rec.to_organization <> fnd_api.g_miss_char THEN
3509: IF p_trolin_rec.to_organization_id <> fnd_api.g_miss_num THEN
3510: l_trolin_rec.to_organization_id := p_trolin_rec.to_organization_id;
3511:
3512: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3505: END IF;
3506: END IF;
3507:
3508: IF p_trolin_val_rec.to_organization <> fnd_api.g_miss_char THEN
3509: IF p_trolin_rec.to_organization_id <> fnd_api.g_miss_num THEN
3510: l_trolin_rec.to_organization_id := p_trolin_rec.to_organization_id;
3511:
3512: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3513: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3516: END IF;
3517: ELSE
3518: l_trolin_rec.to_organization_id := inv_value_to_id.to_organization(p_to_organization => p_trolin_val_rec.to_organization);
3519:
3520: IF l_trolin_rec.to_organization_id = fnd_api.g_miss_num THEN
3521: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3522: END IF;
3523: END IF;
3524: END IF;
3517: ELSE
3518: l_trolin_rec.to_organization_id := inv_value_to_id.to_organization(p_to_organization => p_trolin_val_rec.to_organization);
3519:
3520: IF l_trolin_rec.to_organization_id = fnd_api.g_miss_num THEN
3521: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3522: END IF;
3523: END IF;
3524: END IF;
3525:
3522: END IF;
3523: END IF;
3524: END IF;
3525:
3526: IF p_trolin_val_rec.project <> fnd_api.g_miss_char THEN
3527: IF p_trolin_rec.project_id <> fnd_api.g_miss_num THEN
3528: l_trolin_rec.project_id := p_trolin_rec.project_id;
3529:
3530: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3523: END IF;
3524: END IF;
3525:
3526: IF p_trolin_val_rec.project <> fnd_api.g_miss_char THEN
3527: IF p_trolin_rec.project_id <> fnd_api.g_miss_num THEN
3528: l_trolin_rec.project_id := p_trolin_rec.project_id;
3529:
3530: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3531: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3534: END IF;
3535: ELSE
3536: l_trolin_rec.project_id := inv_value_to_id.project(p_project => p_trolin_val_rec.project);
3537:
3538: IF l_trolin_rec.project_id = fnd_api.g_miss_num THEN
3539: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3540: END IF;
3541: END IF;
3542: END IF;
3535: ELSE
3536: l_trolin_rec.project_id := inv_value_to_id.project(p_project => p_trolin_val_rec.project);
3537:
3538: IF l_trolin_rec.project_id = fnd_api.g_miss_num THEN
3539: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3540: END IF;
3541: END IF;
3542: END IF;
3543:
3540: END IF;
3541: END IF;
3542: END IF;
3543:
3544: IF p_trolin_val_rec.reason <> fnd_api.g_miss_char THEN
3545: IF p_trolin_rec.reason_id <> fnd_api.g_miss_num THEN
3546: l_trolin_rec.reason_id := p_trolin_rec.reason_id;
3547:
3548: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3541: END IF;
3542: END IF;
3543:
3544: IF p_trolin_val_rec.reason <> fnd_api.g_miss_char THEN
3545: IF p_trolin_rec.reason_id <> fnd_api.g_miss_num THEN
3546: l_trolin_rec.reason_id := p_trolin_rec.reason_id;
3547:
3548: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3549: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3552: END IF;
3553: ELSE
3554: l_trolin_rec.reason_id := inv_value_to_id.reason(p_reason => p_trolin_val_rec.reason);
3555:
3556: IF l_trolin_rec.reason_id = fnd_api.g_miss_num THEN
3557: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3558: END IF;
3559: END IF;
3560: END IF;
3553: ELSE
3554: l_trolin_rec.reason_id := inv_value_to_id.reason(p_reason => p_trolin_val_rec.reason);
3555:
3556: IF l_trolin_rec.reason_id = fnd_api.g_miss_num THEN
3557: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3558: END IF;
3559: END IF;
3560: END IF;
3561:
3558: END IF;
3559: END IF;
3560: END IF;
3561:
3562: IF p_trolin_val_rec.REFERENCE <> fnd_api.g_miss_char THEN
3563: IF p_trolin_rec.reference_id <> fnd_api.g_miss_num THEN
3564: l_trolin_rec.reference_id := p_trolin_rec.reference_id;
3565:
3566: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3559: END IF;
3560: END IF;
3561:
3562: IF p_trolin_val_rec.REFERENCE <> fnd_api.g_miss_char THEN
3563: IF p_trolin_rec.reference_id <> fnd_api.g_miss_num THEN
3564: l_trolin_rec.reference_id := p_trolin_rec.reference_id;
3565:
3566: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3567: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3570: END IF;
3571: ELSE
3572: l_trolin_rec.reference_id := inv_value_to_id.REFERENCE(p_reference => p_trolin_val_rec.REFERENCE);
3573:
3574: IF l_trolin_rec.reference_id = fnd_api.g_miss_num THEN
3575: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3576: END IF;
3577: END IF;
3578: END IF;
3571: ELSE
3572: l_trolin_rec.reference_id := inv_value_to_id.REFERENCE(p_reference => p_trolin_val_rec.REFERENCE);
3573:
3574: IF l_trolin_rec.reference_id = fnd_api.g_miss_num THEN
3575: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3576: END IF;
3577: END IF;
3578: END IF;
3579:
3576: END IF;
3577: END IF;
3578: END IF;
3579:
3580: IF p_trolin_val_rec.reference_type <> fnd_api.g_miss_char THEN
3581: IF p_trolin_rec.reference_type_code <> fnd_api.g_miss_num THEN
3582: l_trolin_rec.reference_type_code := p_trolin_rec.reference_type_code;
3583:
3584: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3577: END IF;
3578: END IF;
3579:
3580: IF p_trolin_val_rec.reference_type <> fnd_api.g_miss_char THEN
3581: IF p_trolin_rec.reference_type_code <> fnd_api.g_miss_num THEN
3582: l_trolin_rec.reference_type_code := p_trolin_rec.reference_type_code;
3583:
3584: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3585: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3588: END IF;
3589: ELSE
3590: l_trolin_rec.reference_type_code := inv_value_to_id.reference_type(p_reference_type => p_trolin_val_rec.reference_type);
3591:
3592: IF l_trolin_rec.reference_type_code = fnd_api.g_miss_num THEN
3593: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3594: END IF;
3595: END IF;
3596: END IF;
3589: ELSE
3590: l_trolin_rec.reference_type_code := inv_value_to_id.reference_type(p_reference_type => p_trolin_val_rec.reference_type);
3591:
3592: IF l_trolin_rec.reference_type_code = fnd_api.g_miss_num THEN
3593: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3594: END IF;
3595: END IF;
3596: END IF;
3597:
3594: END IF;
3595: END IF;
3596: END IF;
3597:
3598: IF p_trolin_val_rec.task <> fnd_api.g_miss_char THEN
3599: IF p_trolin_rec.task_id <> fnd_api.g_miss_num THEN
3600: l_trolin_rec.task_id := p_trolin_rec.task_id;
3601:
3602: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3595: END IF;
3596: END IF;
3597:
3598: IF p_trolin_val_rec.task <> fnd_api.g_miss_char THEN
3599: IF p_trolin_rec.task_id <> fnd_api.g_miss_num THEN
3600: l_trolin_rec.task_id := p_trolin_rec.task_id;
3601:
3602: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3603: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3606: END IF;
3607: ELSE
3608: l_trolin_rec.task_id := inv_value_to_id.task(p_task => p_trolin_val_rec.task);
3609:
3610: IF l_trolin_rec.task_id = fnd_api.g_miss_num THEN
3611: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3612: END IF;
3613: END IF;
3614: END IF;
3607: ELSE
3608: l_trolin_rec.task_id := inv_value_to_id.task(p_task => p_trolin_val_rec.task);
3609:
3610: IF l_trolin_rec.task_id = fnd_api.g_miss_num THEN
3611: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3612: END IF;
3613: END IF;
3614: END IF;
3615:
3612: END IF;
3613: END IF;
3614: END IF;
3615:
3616: IF p_trolin_val_rec.to_account <> fnd_api.g_miss_char THEN
3617: IF p_trolin_rec.to_account_id <> fnd_api.g_miss_num THEN
3618: l_trolin_rec.to_account_id := p_trolin_rec.to_account_id;
3619:
3620: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3613: END IF;
3614: END IF;
3615:
3616: IF p_trolin_val_rec.to_account <> fnd_api.g_miss_char THEN
3617: IF p_trolin_rec.to_account_id <> fnd_api.g_miss_num THEN
3618: l_trolin_rec.to_account_id := p_trolin_rec.to_account_id;
3619:
3620: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3621: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3624: END IF;
3625: ELSE
3626: l_trolin_rec.to_account_id := inv_value_to_id.to_account(p_organization_id => p_trolin_rec.organization_id, p_to_account => p_trolin_val_rec.to_account);
3627:
3628: IF l_trolin_rec.to_account_id = fnd_api.g_miss_num THEN
3629: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3630: END IF;
3631: END IF;
3632: END IF;
3625: ELSE
3626: l_trolin_rec.to_account_id := inv_value_to_id.to_account(p_organization_id => p_trolin_rec.organization_id, p_to_account => p_trolin_val_rec.to_account);
3627:
3628: IF l_trolin_rec.to_account_id = fnd_api.g_miss_num THEN
3629: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3630: END IF;
3631: END IF;
3632: END IF;
3633:
3631: END IF;
3632: END IF;
3633:
3634: /*
3635: IF p_trolin_val_rec.to_locator <> FND_API.G_MISS_CHAR
3636: THEN
3637:
3638: IF p_trolin_rec.to_locator_id <> FND_API.G_MISS_NUM THEN
3639:
3634: /*
3635: IF p_trolin_val_rec.to_locator <> FND_API.G_MISS_CHAR
3636: THEN
3637:
3638: IF p_trolin_rec.to_locator_id <> FND_API.G_MISS_NUM THEN
3639:
3640: l_trolin_rec.to_locator_id := p_trolin_rec.to_locator_id;
3641:
3642: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3653: l_trolin_rec.to_locator_id := INV_Value_To_Id.to_locator
3654: ( p_to_locator => p_trolin_val_rec.to_locator
3655: );
3656:
3657: IF l_trolin_rec.to_locator_id = FND_API.G_MISS_NUM THEN
3658: l_trolin_rec.return_status := FND_API.G_RET_STS_ERROR;
3659: END IF;
3660:
3661: END IF;
3654: ( p_to_locator => p_trolin_val_rec.to_locator
3655: );
3656:
3657: IF l_trolin_rec.to_locator_id = FND_API.G_MISS_NUM THEN
3658: l_trolin_rec.return_status := FND_API.G_RET_STS_ERROR;
3659: END IF;
3660:
3661: END IF;
3662:
3662:
3663: END IF;
3664: */
3665:
3666: IF p_trolin_val_rec.to_subinventory <> fnd_api.g_miss_char THEN
3667: IF p_trolin_rec.to_subinventory_code <> fnd_api.g_miss_char THEN
3668: l_trolin_rec.to_subinventory_code := p_trolin_rec.to_subinventory_code;
3669:
3670: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3663: END IF;
3664: */
3665:
3666: IF p_trolin_val_rec.to_subinventory <> fnd_api.g_miss_char THEN
3667: IF p_trolin_rec.to_subinventory_code <> fnd_api.g_miss_char THEN
3668: l_trolin_rec.to_subinventory_code := p_trolin_rec.to_subinventory_code;
3669:
3670: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3671: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3674: END IF;
3675: ELSE
3676: l_trolin_rec.to_subinventory_code := inv_value_to_id.to_subinventory(p_organization_id => p_trolin_rec.organization_id, p_to_subinventory => p_trolin_val_rec.to_subinventory);
3677:
3678: IF l_trolin_rec.to_subinventory_code = fnd_api.g_miss_char THEN
3679: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3680: END IF;
3681: END IF;
3682: END IF;
3675: ELSE
3676: l_trolin_rec.to_subinventory_code := inv_value_to_id.to_subinventory(p_organization_id => p_trolin_rec.organization_id, p_to_subinventory => p_trolin_val_rec.to_subinventory);
3677:
3678: IF l_trolin_rec.to_subinventory_code = fnd_api.g_miss_char THEN
3679: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3680: END IF;
3681: END IF;
3682: END IF;
3683:
3681: END IF;
3682: END IF;
3683:
3684: -- Line2839
3685: IF p_trolin_val_rec.to_subinventory <> fnd_api.g_miss_char THEN
3686: IF p_trolin_rec.to_subinventory_id <> fnd_api.g_miss_num THEN
3687: l_trolin_rec.to_subinventory_id := p_trolin_rec.to_subinventory_id;
3688:
3689: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3682: END IF;
3683:
3684: -- Line2839
3685: IF p_trolin_val_rec.to_subinventory <> fnd_api.g_miss_char THEN
3686: IF p_trolin_rec.to_subinventory_id <> fnd_api.g_miss_num THEN
3687: l_trolin_rec.to_subinventory_id := p_trolin_rec.to_subinventory_id;
3688:
3689: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3690: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3693: END IF;
3694: ELSE
3695: l_trolin_rec.to_subinventory_id := inv_value_to_id.to_subinventory(p_organization_id => p_trolin_rec.organization_id, p_to_subinventory => p_trolin_val_rec.to_subinventory);
3696:
3697: IF l_trolin_rec.to_subinventory_id = fnd_api.g_miss_num THEN
3698: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3699: END IF;
3700: END IF;
3701: END IF;
3694: ELSE
3695: l_trolin_rec.to_subinventory_id := inv_value_to_id.to_subinventory(p_organization_id => p_trolin_rec.organization_id, p_to_subinventory => p_trolin_val_rec.to_subinventory);
3696:
3697: IF l_trolin_rec.to_subinventory_id = fnd_api.g_miss_num THEN
3698: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3699: END IF;
3700: END IF;
3701: END IF;
3702:
3699: END IF;
3700: END IF;
3701: END IF;
3702:
3703: IF p_trolin_val_rec.transaction_header <> fnd_api.g_miss_char THEN
3704: IF p_trolin_rec.transaction_header_id <> fnd_api.g_miss_num THEN
3705: l_trolin_rec.transaction_header_id := p_trolin_rec.transaction_header_id;
3706:
3707: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3700: END IF;
3701: END IF;
3702:
3703: IF p_trolin_val_rec.transaction_header <> fnd_api.g_miss_char THEN
3704: IF p_trolin_rec.transaction_header_id <> fnd_api.g_miss_num THEN
3705: l_trolin_rec.transaction_header_id := p_trolin_rec.transaction_header_id;
3706:
3707: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3708: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3711: END IF;
3712: ELSE
3713: l_trolin_rec.transaction_header_id := inv_value_to_id.transaction_header(p_transaction_header => p_trolin_val_rec.transaction_header);
3714:
3715: IF l_trolin_rec.transaction_header_id = fnd_api.g_miss_num THEN
3716: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3717: END IF;
3718: END IF;
3719: END IF;
3712: ELSE
3713: l_trolin_rec.transaction_header_id := inv_value_to_id.transaction_header(p_transaction_header => p_trolin_val_rec.transaction_header);
3714:
3715: IF l_trolin_rec.transaction_header_id = fnd_api.g_miss_num THEN
3716: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3717: END IF;
3718: END IF;
3719: END IF;
3720:
3717: END IF;
3718: END IF;
3719: END IF;
3720:
3721: IF p_trolin_val_rec.transaction_type <> fnd_api.g_miss_char THEN
3722: IF p_trolin_rec.transaction_type_id <> fnd_api.g_miss_num THEN
3723: l_trolin_rec.transaction_type_id := p_trolin_rec.transaction_type_id;
3724:
3725: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3718: END IF;
3719: END IF;
3720:
3721: IF p_trolin_val_rec.transaction_type <> fnd_api.g_miss_char THEN
3722: IF p_trolin_rec.transaction_type_id <> fnd_api.g_miss_num THEN
3723: l_trolin_rec.transaction_type_id := p_trolin_rec.transaction_type_id;
3724:
3725: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3726: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3729: END IF;
3730: ELSE
3731: l_trolin_rec.transaction_type_id := inv_value_to_id.transaction_type(p_transaction_type => p_trolin_val_rec.transaction_type);
3732:
3733: IF l_trolin_rec.transaction_type_id = fnd_api.g_miss_num THEN
3734: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3735: END IF;
3736: END IF;
3737: END IF;
3730: ELSE
3731: l_trolin_rec.transaction_type_id := inv_value_to_id.transaction_type(p_transaction_type => p_trolin_val_rec.transaction_type);
3732:
3733: IF l_trolin_rec.transaction_type_id = fnd_api.g_miss_num THEN
3734: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3735: END IF;
3736: END IF;
3737: END IF;
3738:
3736: END IF;
3737: END IF;
3738:
3739: -- Line2899
3740: IF p_trolin_val_rec.uom <> fnd_api.g_miss_char THEN
3741: IF p_trolin_rec.uom_code <> fnd_api.g_miss_char THEN
3742: l_trolin_rec.uom_code := p_trolin_rec.uom_code;
3743:
3744: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3737: END IF;
3738:
3739: -- Line2899
3740: IF p_trolin_val_rec.uom <> fnd_api.g_miss_char THEN
3741: IF p_trolin_rec.uom_code <> fnd_api.g_miss_char THEN
3742: l_trolin_rec.uom_code := p_trolin_rec.uom_code;
3743:
3744: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3745: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3749: ELSE
3750: -- Line2917
3751: l_trolin_rec.uom_code := inv_value_to_id.uom(p_uom => p_trolin_val_rec.uom);
3752:
3753: IF l_trolin_rec.uom_code = fnd_api.g_miss_char THEN
3754: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3755: END IF;
3756: END IF;
3757: END IF;
3750: -- Line2917
3751: l_trolin_rec.uom_code := inv_value_to_id.uom(p_uom => p_trolin_val_rec.uom);
3752:
3753: IF l_trolin_rec.uom_code = fnd_api.g_miss_char THEN
3754: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3755: END IF;
3756: END IF;
3757: END IF;
3758:
3768: FORALL i IN 1 .. p_new_trolin_tbl.COUNT
3769: insert into mtl_txn_request_lines
3770: values p_new_trolin_tbl(i);
3771:
3772: x_return_status := fnd_api.g_ret_sts_success;
3773: EXCEPTION
3774: WHEN OTHERS THEN
3775: x_return_status := fnd_api.g_ret_sts_error;
3776: RAISE fnd_api.g_exc_unexpected_error;
3771:
3772: x_return_status := fnd_api.g_ret_sts_success;
3773: EXCEPTION
3774: WHEN OTHERS THEN
3775: x_return_status := fnd_api.g_ret_sts_error;
3776: RAISE fnd_api.g_exc_unexpected_error;
3777: END insert_mo_lines_bulk;
3778:
3779: END inv_trolin_util;
3772: x_return_status := fnd_api.g_ret_sts_success;
3773: EXCEPTION
3774: WHEN OTHERS THEN
3775: x_return_status := fnd_api.g_ret_sts_error;
3776: RAISE fnd_api.g_exc_unexpected_error;
3777: END insert_mo_lines_bulk;
3778:
3779: END inv_trolin_util;