[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;
1951: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1952: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Update_Row');
1953: END IF;
1954:
1955: RAISE fnd_api.g_exc_unexpected_error;
1956: END update_row;
1957:
1958: -- Procedure Update_Row_Status
1959:
1972: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1973: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Update_Row_Status');
1974: END IF;
1975:
1976: RAISE fnd_api.g_exc_unexpected_error;
1977: END update_row_status;
1978:
1979: -- Procedure Insert_Row
1980:
2168: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2169: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Insert_Row');
2170: END IF;
2171:
2172: RAISE fnd_api.g_exc_unexpected_error;
2173: END insert_row;
2174:
2175: -- Procedure Delete_Row
2176:
2183: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2184: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Delete_Row');
2185: END IF;
2186:
2187: RAISE fnd_api.g_exc_unexpected_error;
2188: END delete_row;
2189:
2190: -- Function Get_Lines
2191:
2207: -- Function Query_Rows
2208:
2209: --
2210:
2211: FUNCTION query_rows(p_line_id IN NUMBER := fnd_api.g_miss_num, p_header_id IN NUMBER := fnd_api.g_miss_num)
2212: RETURN inv_move_order_pub.trolin_tbl_type IS
2213: l_trolin_rec inv_move_order_pub.trolin_rec_type;
2214: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
2215:
2402: BEGIN
2403: /*inv_debug.message('TRO: line_id '||to_char(p_line_id)||' header_id '||to_char(p_header_id)); */
2404:
2405: IF (p_line_id IS NOT NULL
2406: AND p_line_id <> fnd_api.g_miss_num
2407: )
2408: AND (p_header_id IS NOT NULL
2409: AND p_header_id <> fnd_api.g_miss_num
2410: ) THEN
2405: IF (p_line_id IS NOT NULL
2406: AND p_line_id <> fnd_api.g_miss_num
2407: )
2408: AND (p_header_id IS NOT NULL
2409: AND p_header_id <> fnd_api.g_miss_num
2410: ) THEN
2411: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2412: 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);
2413: END IF;
2411: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2412: 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);
2413: END IF;
2414:
2415: RAISE fnd_api.g_exc_unexpected_error;
2416: END IF;
2417:
2418: IF (p_line_id IS NOT NULL
2419: AND p_line_id <> fnd_api.g_miss_num
2415: RAISE fnd_api.g_exc_unexpected_error;
2416: END IF;
2417:
2418: IF (p_line_id IS NOT NULL
2419: AND p_line_id <> fnd_api.g_miss_num
2420: ) THEN
2421: -- Loop over fetched records
2422:
2423: FOR l_implicit_rec IN l_trolin_csr LOOP
2610:
2611: -- PK sent and no rows found
2612:
2613: IF (p_line_id IS NOT NULL
2614: AND p_line_id <> fnd_api.g_miss_num
2615: )
2616: AND (l_trolin_tbl.COUNT = 0) THEN
2617: RAISE NO_DATA_FOUND;
2618: END IF;
2620: -- Return fetched table
2621:
2622: RETURN l_trolin_tbl;
2623: EXCEPTION
2624: WHEN fnd_api.g_exc_unexpected_error THEN
2625: RAISE fnd_api.g_exc_unexpected_error;
2626: WHEN OTHERS THEN
2627: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2628: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Query_Rows');
2621:
2622: RETURN l_trolin_tbl;
2623: EXCEPTION
2624: WHEN fnd_api.g_exc_unexpected_error THEN
2625: RAISE fnd_api.g_exc_unexpected_error;
2626: WHEN OTHERS THEN
2627: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2628: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Query_Rows');
2629: END IF;
2627: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2628: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Query_Rows');
2629: END IF;
2630:
2631: RAISE fnd_api.g_exc_unexpected_error;
2632: END query_rows;
2633:
2634: -- Procedure lock_Row
2635: --
2837: AND inv_globals.equal(p_trolin_rec.attribute8, l_trolin_rec.attribute8)
2838: AND inv_globals.equal(p_trolin_rec.attribute9, l_trolin_rec.attribute9)
2839: AND inv_globals.equal(p_trolin_rec.attribute_category, l_trolin_rec.attribute_category)
2840: AND (inv_globals.equal(p_trolin_rec.created_by, l_trolin_rec.created_by)
2841: OR (p_trolin_rec.created_by = fnd_api.g_miss_num
2842: AND l_trolin_rec.created_by IS NULL
2843: )
2844: )
2845: AND (inv_globals.equal(p_trolin_rec.creation_date, l_trolin_rec.creation_date)
2842: AND l_trolin_rec.created_by IS NULL
2843: )
2844: )
2845: AND (inv_globals.equal(p_trolin_rec.creation_date, l_trolin_rec.creation_date)
2846: OR (p_trolin_rec.creation_date = fnd_api.g_miss_date
2847: AND l_trolin_rec.creation_date IS NULL
2848: )
2849: )
2850: AND (inv_globals.equal(p_trolin_rec.date_required, l_trolin_rec.date_required)
2847: AND l_trolin_rec.creation_date IS NULL
2848: )
2849: )
2850: AND (inv_globals.equal(p_trolin_rec.date_required, l_trolin_rec.date_required)
2851: OR (p_trolin_rec.date_required = fnd_api.g_miss_date
2852: AND l_trolin_rec.date_required IS NULL
2853: )
2854: )
2855: AND (inv_globals.equal(p_trolin_rec.from_locator_id, l_trolin_rec.from_locator_id)
2852: AND l_trolin_rec.date_required IS NULL
2853: )
2854: )
2855: AND (inv_globals.equal(p_trolin_rec.from_locator_id, l_trolin_rec.from_locator_id)
2856: OR (p_trolin_rec.from_locator_id = fnd_api.g_miss_num
2857: AND l_trolin_rec.from_locator_id IS NULL
2858: )
2859: )
2860: AND (inv_globals.equal(p_trolin_rec.from_subinventory_code, l_trolin_rec.from_subinventory_code)
2857: AND l_trolin_rec.from_locator_id IS NULL
2858: )
2859: )
2860: AND (inv_globals.equal(p_trolin_rec.from_subinventory_code, l_trolin_rec.from_subinventory_code)
2861: OR (p_trolin_rec.from_subinventory_code = fnd_api.g_miss_char
2862: AND l_trolin_rec.from_subinventory_code IS NULL
2863: )
2864: )
2865: AND (inv_globals.equal(p_trolin_rec.from_subinventory_id, l_trolin_rec.from_subinventory_id)
2862: AND l_trolin_rec.from_subinventory_code IS NULL
2863: )
2864: )
2865: AND (inv_globals.equal(p_trolin_rec.from_subinventory_id, l_trolin_rec.from_subinventory_id)
2866: OR (p_trolin_rec.from_subinventory_id = fnd_api.g_miss_num
2867: AND l_trolin_rec.from_subinventory_id IS NULL
2868: )
2869: )
2870: AND (inv_globals.equal(p_trolin_rec.header_id, l_trolin_rec.header_id)
2867: AND l_trolin_rec.from_subinventory_id IS NULL
2868: )
2869: )
2870: AND (inv_globals.equal(p_trolin_rec.header_id, l_trolin_rec.header_id)
2871: OR (p_trolin_rec.header_id = fnd_api.g_miss_num
2872: AND l_trolin_rec.header_id IS NULL
2873: )
2874: )
2875: AND (inv_globals.equal(p_trolin_rec.inventory_item_id, l_trolin_rec.inventory_item_id)
2872: AND l_trolin_rec.header_id IS NULL
2873: )
2874: )
2875: AND (inv_globals.equal(p_trolin_rec.inventory_item_id, l_trolin_rec.inventory_item_id)
2876: OR (p_trolin_rec.inventory_item_id = fnd_api.g_miss_num
2877: AND l_trolin_rec.inventory_item_id IS NULL
2878: )
2879: )
2880: AND (inv_globals.equal(p_trolin_rec.last_updated_by, l_trolin_rec.last_updated_by)
2877: AND l_trolin_rec.inventory_item_id IS NULL
2878: )
2879: )
2880: AND (inv_globals.equal(p_trolin_rec.last_updated_by, l_trolin_rec.last_updated_by)
2881: OR (p_trolin_rec.last_updated_by = fnd_api.g_miss_num
2882: AND l_trolin_rec.last_updated_by IS NULL
2883: )
2884: )
2885: AND (inv_globals.equal(p_trolin_rec.last_update_date, l_trolin_rec.last_update_date)
2882: AND l_trolin_rec.last_updated_by IS NULL
2883: )
2884: )
2885: AND (inv_globals.equal(p_trolin_rec.last_update_date, l_trolin_rec.last_update_date)
2886: OR (p_trolin_rec.last_update_date = fnd_api.g_miss_date
2887: AND l_trolin_rec.last_update_date IS NULL
2888: )
2889: )
2890: AND (inv_globals.equal(p_trolin_rec.last_update_login, l_trolin_rec.last_update_login)
2887: AND l_trolin_rec.last_update_date IS NULL
2888: )
2889: )
2890: AND (inv_globals.equal(p_trolin_rec.last_update_login, l_trolin_rec.last_update_login)
2891: OR (p_trolin_rec.last_update_login = fnd_api.g_miss_num
2892: AND l_trolin_rec.last_update_login IS NULL
2893: )
2894: )
2895: AND (inv_globals.equal(p_trolin_rec.line_id, l_trolin_rec.line_id)
2892: AND l_trolin_rec.last_update_login IS NULL
2893: )
2894: )
2895: AND (inv_globals.equal(p_trolin_rec.line_id, l_trolin_rec.line_id)
2896: OR (p_trolin_rec.line_id = fnd_api.g_miss_num
2897: AND l_trolin_rec.line_id IS NULL
2898: )
2899: )
2900: AND (inv_globals.equal(p_trolin_rec.line_number, l_trolin_rec.line_number)
2897: AND l_trolin_rec.line_id IS NULL
2898: )
2899: )
2900: AND (inv_globals.equal(p_trolin_rec.line_number, l_trolin_rec.line_number)
2901: OR (p_trolin_rec.line_number = fnd_api.g_miss_num
2902: AND l_trolin_rec.line_number IS NULL
2903: )
2904: )
2905: AND (inv_globals.equal(p_trolin_rec.line_status, l_trolin_rec.line_status)
2902: AND l_trolin_rec.line_number IS NULL
2903: )
2904: )
2905: AND (inv_globals.equal(p_trolin_rec.line_status, l_trolin_rec.line_status)
2906: OR (p_trolin_rec.line_status = fnd_api.g_miss_num
2907: AND l_trolin_rec.line_status IS NULL
2908: )
2909: )
2910: AND (inv_globals.equal(p_trolin_rec.lot_number, l_trolin_rec.lot_number)
2907: AND l_trolin_rec.line_status IS NULL
2908: )
2909: )
2910: AND (inv_globals.equal(p_trolin_rec.lot_number, l_trolin_rec.lot_number)
2911: OR (p_trolin_rec.lot_number = fnd_api.g_miss_char
2912: AND l_trolin_rec.lot_number IS NULL
2913: )
2914: )
2915: AND (inv_globals.equal(p_trolin_rec.organization_id, l_trolin_rec.organization_id)
2912: AND l_trolin_rec.lot_number IS NULL
2913: )
2914: )
2915: AND (inv_globals.equal(p_trolin_rec.organization_id, l_trolin_rec.organization_id)
2916: OR (p_trolin_rec.organization_id = fnd_api.g_miss_num
2917: AND l_trolin_rec.organization_id IS NULL
2918: )
2919: )
2920: AND (inv_globals.equal(p_trolin_rec.program_application_id, l_trolin_rec.program_application_id)
2917: AND l_trolin_rec.organization_id IS NULL
2918: )
2919: )
2920: AND (inv_globals.equal(p_trolin_rec.program_application_id, l_trolin_rec.program_application_id)
2921: OR (p_trolin_rec.program_application_id = fnd_api.g_miss_num
2922: AND l_trolin_rec.program_application_id IS NULL
2923: )
2924: )
2925: AND (inv_globals.equal(p_trolin_rec.program_id, l_trolin_rec.program_id)
2922: AND l_trolin_rec.program_application_id IS NULL
2923: )
2924: )
2925: AND (inv_globals.equal(p_trolin_rec.program_id, l_trolin_rec.program_id)
2926: OR (p_trolin_rec.program_id = fnd_api.g_miss_num
2927: AND l_trolin_rec.program_id IS NULL
2928: )
2929: )
2930: AND (inv_globals.equal(p_trolin_rec.program_update_date, l_trolin_rec.program_update_date)
2927: AND l_trolin_rec.program_id IS NULL
2928: )
2929: )
2930: AND (inv_globals.equal(p_trolin_rec.program_update_date, l_trolin_rec.program_update_date)
2931: OR (p_trolin_rec.program_update_date = fnd_api.g_miss_date
2932: AND l_trolin_rec.program_update_date IS NOT NULL
2933: )
2934: )
2935: AND (inv_globals.equal(p_trolin_rec.project_id, l_trolin_rec.project_id)
2932: AND l_trolin_rec.program_update_date IS NOT NULL
2933: )
2934: )
2935: AND (inv_globals.equal(p_trolin_rec.project_id, l_trolin_rec.project_id)
2936: OR (p_trolin_rec.project_id = fnd_api.g_miss_num
2937: AND l_trolin_rec.project_id IS NULL
2938: )
2939: )
2940: AND (inv_globals.equal(p_trolin_rec.quantity, l_trolin_rec.quantity)
2937: AND l_trolin_rec.project_id IS NULL
2938: )
2939: )
2940: AND (inv_globals.equal(p_trolin_rec.quantity, l_trolin_rec.quantity)
2941: OR (p_trolin_rec.quantity = fnd_api.g_miss_num
2942: AND l_trolin_rec.quantity IS NULL
2943: )
2944: )
2945: AND (inv_globals.equal(p_trolin_rec.quantity_delivered, l_trolin_rec.quantity_delivered)
2942: AND l_trolin_rec.quantity IS NULL
2943: )
2944: )
2945: AND (inv_globals.equal(p_trolin_rec.quantity_delivered, l_trolin_rec.quantity_delivered)
2946: OR (p_trolin_rec.quantity_delivered = fnd_api.g_miss_num
2947: AND l_trolin_rec.quantity_delivered IS NULL
2948: )
2949: )
2950: AND (inv_globals.equal(p_trolin_rec.quantity_detailed, l_trolin_rec.quantity_detailed)
2947: AND l_trolin_rec.quantity_delivered IS NULL
2948: )
2949: )
2950: AND (inv_globals.equal(p_trolin_rec.quantity_detailed, l_trolin_rec.quantity_detailed)
2951: OR (p_trolin_rec.quantity_detailed = fnd_api.g_miss_num
2952: AND l_trolin_rec.quantity_detailed IS NULL
2953: )
2954: )
2955: AND (inv_globals.equal(p_trolin_rec.reason_id, l_trolin_rec.reason_id)
2952: AND l_trolin_rec.quantity_detailed IS NULL
2953: )
2954: )
2955: AND (inv_globals.equal(p_trolin_rec.reason_id, l_trolin_rec.reason_id)
2956: OR (p_trolin_rec.reason_id = fnd_api.g_miss_num
2957: AND l_trolin_rec.reason_id IS NULL
2958: )
2959: )
2960: AND (inv_globals.equal(p_trolin_rec.REFERENCE, l_trolin_rec.REFERENCE)
2957: AND l_trolin_rec.reason_id IS NULL
2958: )
2959: )
2960: AND (inv_globals.equal(p_trolin_rec.REFERENCE, l_trolin_rec.REFERENCE)
2961: OR (p_trolin_rec.REFERENCE = fnd_api.g_miss_char
2962: AND l_trolin_rec.REFERENCE IS NULL
2963: )
2964: )
2965: AND (inv_globals.equal(p_trolin_rec.reference_id, l_trolin_rec.reference_id)
2962: AND l_trolin_rec.REFERENCE IS NULL
2963: )
2964: )
2965: AND (inv_globals.equal(p_trolin_rec.reference_id, l_trolin_rec.reference_id)
2966: OR (p_trolin_rec.reference_id = fnd_api.g_miss_num
2967: AND l_trolin_rec.reference_id IS NULL
2968: )
2969: )
2970: AND (inv_globals.equal(p_trolin_rec.reference_type_code, l_trolin_rec.reference_type_code)
2967: AND l_trolin_rec.reference_id IS NULL
2968: )
2969: )
2970: AND (inv_globals.equal(p_trolin_rec.reference_type_code, l_trolin_rec.reference_type_code)
2971: OR (l_trolin_rec.reference_type_code = fnd_api.g_miss_num
2972: AND l_trolin_rec.reference_type_code IS NULL
2973: )
2974: )
2975: AND (inv_globals.equal(p_trolin_rec.request_id, l_trolin_rec.request_id)
2972: AND l_trolin_rec.reference_type_code IS NULL
2973: )
2974: )
2975: AND (inv_globals.equal(p_trolin_rec.request_id, l_trolin_rec.request_id)
2976: OR (p_trolin_rec.request_id = fnd_api.g_miss_num
2977: AND l_trolin_rec.request_id IS NULL
2978: )
2979: )
2980: AND (inv_globals.equal(p_trolin_rec.revision, l_trolin_rec.revision)
2977: AND l_trolin_rec.request_id IS NULL
2978: )
2979: )
2980: AND (inv_globals.equal(p_trolin_rec.revision, l_trolin_rec.revision)
2981: OR (p_trolin_rec.revision = fnd_api.g_miss_char
2982: AND l_trolin_rec.revision IS NULL
2983: )
2984: )
2985: AND (inv_globals.equal(p_trolin_rec.serial_number_end, l_trolin_rec.serial_number_end)
2982: AND l_trolin_rec.revision IS NULL
2983: )
2984: )
2985: AND (inv_globals.equal(p_trolin_rec.serial_number_end, l_trolin_rec.serial_number_end)
2986: OR (p_trolin_rec.serial_number_end = fnd_api.g_miss_char
2987: AND l_trolin_rec.serial_number_end IS NULL
2988: )
2989: )
2990: AND (inv_globals.equal(p_trolin_rec.serial_number_start, l_trolin_rec.serial_number_start)
2987: AND l_trolin_rec.serial_number_end IS NULL
2988: )
2989: )
2990: AND (inv_globals.equal(p_trolin_rec.serial_number_start, l_trolin_rec.serial_number_start)
2991: OR (p_trolin_rec.serial_number_start = fnd_api.g_miss_char
2992: AND l_trolin_rec.serial_number_start IS NULL
2993: )
2994: )
2995: AND (inv_globals.equal(p_trolin_rec.status_date, l_trolin_rec.status_date)
2992: AND l_trolin_rec.serial_number_start IS NULL
2993: )
2994: )
2995: AND (inv_globals.equal(p_trolin_rec.status_date, l_trolin_rec.status_date)
2996: OR (p_trolin_rec.status_date = fnd_api.g_miss_date
2997: AND l_trolin_rec.status_date IS NULL
2998: )
2999: )
3000: AND (inv_globals.equal(p_trolin_rec.task_id, l_trolin_rec.task_id)
2997: AND l_trolin_rec.status_date IS NULL
2998: )
2999: )
3000: AND (inv_globals.equal(p_trolin_rec.task_id, l_trolin_rec.task_id)
3001: OR (p_trolin_rec.task_id = fnd_api.g_miss_num
3002: AND l_trolin_rec.task_id IS NULL
3003: )
3004: )
3005: AND (inv_globals.equal(p_trolin_rec.to_account_id, l_trolin_rec.to_account_id)
3002: AND l_trolin_rec.task_id IS NULL
3003: )
3004: )
3005: AND (inv_globals.equal(p_trolin_rec.to_account_id, l_trolin_rec.to_account_id)
3006: OR (p_trolin_rec.to_account_id = fnd_api.g_miss_num
3007: AND l_trolin_rec.to_account_id IS NULL
3008: )
3009: )
3010: AND (inv_globals.equal(p_trolin_rec.to_locator_id, l_trolin_rec.to_locator_id)
3007: AND l_trolin_rec.to_account_id IS NULL
3008: )
3009: )
3010: AND (inv_globals.equal(p_trolin_rec.to_locator_id, l_trolin_rec.to_locator_id)
3011: OR (p_trolin_rec.to_locator_id = fnd_api.g_miss_num
3012: AND l_trolin_rec.to_locator_id IS NULL
3013: )
3014: )
3015: AND (inv_globals.equal(p_trolin_rec.to_subinventory_code, l_trolin_rec.to_subinventory_code)
3012: AND l_trolin_rec.to_locator_id IS NULL
3013: )
3014: )
3015: AND (inv_globals.equal(p_trolin_rec.to_subinventory_code, l_trolin_rec.to_subinventory_code)
3016: OR (p_trolin_rec.to_subinventory_code = fnd_api.g_miss_char
3017: AND l_trolin_rec.to_subinventory_code IS NULL
3018: )
3019: )
3020: AND (inv_globals.equal(p_trolin_rec.to_subinventory_id, l_trolin_rec.to_subinventory_id)
3017: AND l_trolin_rec.to_subinventory_code IS NULL
3018: )
3019: )
3020: AND (inv_globals.equal(p_trolin_rec.to_subinventory_id, l_trolin_rec.to_subinventory_id)
3021: OR (p_trolin_rec.to_subinventory_id = fnd_api.g_miss_num
3022: AND l_trolin_rec.to_subinventory_id IS NULL
3023: )
3024: )
3025: AND (inv_globals.equal(p_trolin_rec.transaction_header_id, l_trolin_rec.transaction_header_id)
3022: AND l_trolin_rec.to_subinventory_id IS NULL
3023: )
3024: )
3025: AND (inv_globals.equal(p_trolin_rec.transaction_header_id, l_trolin_rec.transaction_header_id)
3026: OR (p_trolin_rec.transaction_header_id = fnd_api.g_miss_num
3027: AND l_trolin_rec.transaction_header_id IS NULL
3028: )
3029: )
3030: AND (inv_globals.equal(p_trolin_rec.uom_code, l_trolin_rec.uom_code)
3027: AND l_trolin_rec.transaction_header_id IS NULL
3028: )
3029: )
3030: AND (inv_globals.equal(p_trolin_rec.uom_code, l_trolin_rec.uom_code)
3031: OR (p_trolin_rec.uom_code = fnd_api.g_miss_char
3032: AND p_trolin_rec.uom_code IS NULL
3033: )
3034: )
3035: AND (inv_globals.equal(p_trolin_rec.transaction_type_id, l_trolin_rec.transaction_type_id)
3032: AND p_trolin_rec.uom_code IS NULL
3033: )
3034: )
3035: AND (inv_globals.equal(p_trolin_rec.transaction_type_id, l_trolin_rec.transaction_type_id)
3036: OR (p_trolin_rec.transaction_type_id = fnd_api.g_miss_num
3037: AND l_trolin_rec.transaction_type_id IS NULL
3038: )
3039: )
3040: AND (inv_globals.equal(p_trolin_rec.transaction_source_type_id, l_trolin_rec.transaction_source_type_id)
3037: AND l_trolin_rec.transaction_type_id IS NULL
3038: )
3039: )
3040: AND (inv_globals.equal(p_trolin_rec.transaction_source_type_id, l_trolin_rec.transaction_source_type_id)
3041: OR (p_trolin_rec.transaction_source_type_id = fnd_api.g_miss_num
3042: AND l_trolin_rec.transaction_source_type_id IS NULL
3043: )
3044: )
3045: AND (inv_globals.equal(p_trolin_rec.txn_source_id, l_trolin_rec.txn_source_id)
3042: AND l_trolin_rec.transaction_source_type_id IS NULL
3043: )
3044: )
3045: AND (inv_globals.equal(p_trolin_rec.txn_source_id, l_trolin_rec.txn_source_id)
3046: OR (p_trolin_rec.txn_source_id = fnd_api.g_miss_num
3047: AND l_trolin_rec.txn_source_id IS NULL
3048: )
3049: )
3050: AND inv_globals.equal(p_trolin_rec.txn_source_line_id, l_trolin_rec.txn_source_line_id)
3048: )
3049: )
3050: AND inv_globals.equal(p_trolin_rec.txn_source_line_id, l_trolin_rec.txn_source_line_id)
3051: AND (inv_globals.equal(p_trolin_rec.txn_source_line_detail_id, l_trolin_rec.txn_source_line_detail_id)
3052: OR (p_trolin_rec.txn_source_line_detail_id = fnd_api.g_miss_num
3053: AND l_trolin_rec.txn_source_line_detail_id IS NULL
3054: )
3055: )
3056: AND (inv_globals.equal(p_trolin_rec.primary_quantity, l_trolin_rec.primary_quantity)
3053: AND l_trolin_rec.txn_source_line_detail_id IS NULL
3054: )
3055: )
3056: AND (inv_globals.equal(p_trolin_rec.primary_quantity, l_trolin_rec.primary_quantity)
3057: OR (p_trolin_rec.primary_quantity = fnd_api.g_miss_num
3058: AND l_trolin_rec.primary_quantity IS NULL
3059: )
3060: )
3061: AND (inv_globals.equal(p_trolin_rec.to_organization_id, l_trolin_rec.to_organization_id)
3058: AND l_trolin_rec.primary_quantity IS NULL
3059: )
3060: )
3061: AND (inv_globals.equal(p_trolin_rec.to_organization_id, l_trolin_rec.to_organization_id)
3062: OR (p_trolin_rec.to_organization_id = fnd_api.g_miss_num
3063: AND l_trolin_rec.to_organization_id IS NULL
3064: )
3065: )
3066: AND (inv_globals.equal(p_trolin_rec.pick_strategy_id, l_trolin_rec.pick_strategy_id)
3063: AND l_trolin_rec.to_organization_id IS NULL
3064: )
3065: )
3066: AND (inv_globals.equal(p_trolin_rec.pick_strategy_id, l_trolin_rec.pick_strategy_id)
3067: OR (p_trolin_rec.pick_strategy_id = fnd_api.g_miss_num
3068: AND l_trolin_rec.pick_strategy_id IS NULL
3069: )
3070: )
3071: AND (inv_globals.equal(p_trolin_rec.put_away_strategy_id, l_trolin_rec.put_away_strategy_id)
3068: AND l_trolin_rec.pick_strategy_id IS NULL
3069: )
3070: )
3071: AND (inv_globals.equal(p_trolin_rec.put_away_strategy_id, l_trolin_rec.put_away_strategy_id)
3072: OR (p_trolin_rec.put_away_strategy_id = fnd_api.g_miss_num
3073: AND l_trolin_rec.put_away_strategy_id IS NULL
3074: )
3075: )
3076: AND (inv_globals.equal(p_trolin_rec.unit_number, l_trolin_rec.unit_number)
3073: AND l_trolin_rec.put_away_strategy_id IS NULL
3074: )
3075: )
3076: AND (inv_globals.equal(p_trolin_rec.unit_number, l_trolin_rec.unit_number)
3077: OR (p_trolin_rec.unit_number = fnd_api.g_miss_char
3078: AND l_trolin_rec.unit_number IS NULL
3079: )
3080: )
3081: AND (inv_globals.equal(p_trolin_rec.ship_to_location_id, l_trolin_rec.ship_to_location_id)
3078: AND l_trolin_rec.unit_number IS NULL
3079: )
3080: )
3081: AND (inv_globals.equal(p_trolin_rec.ship_to_location_id, l_trolin_rec.ship_to_location_id)
3082: OR (p_trolin_rec.ship_to_location_id = fnd_api.g_miss_num
3083: AND l_trolin_rec.ship_to_location_id IS NULL
3084: )
3085: )
3086: AND (inv_globals.equal(p_trolin_rec.from_cost_group_id, l_trolin_rec.from_cost_group_id)
3083: AND l_trolin_rec.ship_to_location_id IS NULL
3084: )
3085: )
3086: AND (inv_globals.equal(p_trolin_rec.from_cost_group_id, l_trolin_rec.from_cost_group_id)
3087: OR (p_trolin_rec.from_cost_group_id = fnd_api.g_miss_num
3088: AND l_trolin_rec.to_cost_group_id IS NULL
3089: )
3090: )
3091: AND (inv_globals.equal(p_trolin_rec.to_cost_group_id, l_trolin_rec.to_cost_group_id)
3088: AND l_trolin_rec.to_cost_group_id IS NULL
3089: )
3090: )
3091: AND (inv_globals.equal(p_trolin_rec.to_cost_group_id, l_trolin_rec.to_cost_group_id)
3092: OR (p_trolin_rec.to_cost_group_id = fnd_api.g_miss_num
3093: AND l_trolin_rec.to_cost_group_id IS NULL
3094: )
3095: )
3096: AND (inv_globals.equal(p_trolin_rec.lpn_id, l_trolin_rec.lpn_id)
3093: AND l_trolin_rec.to_cost_group_id IS NULL
3094: )
3095: )
3096: AND (inv_globals.equal(p_trolin_rec.lpn_id, l_trolin_rec.lpn_id)
3097: OR (p_trolin_rec.lpn_id = fnd_api.g_miss_num
3098: AND l_trolin_rec.lpn_id IS NULL
3099: )
3100: )
3101: AND (inv_globals.equal(p_trolin_rec.to_lpn_id, l_trolin_rec.to_lpn_id)
3098: AND l_trolin_rec.lpn_id IS NULL
3099: )
3100: )
3101: AND (inv_globals.equal(p_trolin_rec.to_lpn_id, l_trolin_rec.to_lpn_id)
3102: OR (p_trolin_rec.to_lpn_id = fnd_api.g_miss_num
3103: AND l_trolin_rec.to_lpn_id IS NULL
3104: )
3105: )
3106: AND inv_globals.equal(p_trolin_rec.inspection_status, l_trolin_rec.inspection_status)
3104: )
3105: )
3106: AND inv_globals.equal(p_trolin_rec.inspection_status, l_trolin_rec.inspection_status)
3107: AND (inv_globals.equal(p_trolin_rec.pick_methodology_id, l_trolin_rec.pick_methodology_id)
3108: OR (p_trolin_rec.pick_methodology_id = fnd_api.g_miss_num
3109: AND l_trolin_rec.pick_methodology_id IS NULL
3110: )
3111: )
3112: AND (inv_globals.equal(p_trolin_rec.container_item_id, l_trolin_rec.container_item_id)
3109: AND l_trolin_rec.pick_methodology_id IS NULL
3110: )
3111: )
3112: AND (inv_globals.equal(p_trolin_rec.container_item_id, l_trolin_rec.container_item_id)
3113: OR (p_trolin_rec.container_item_id = fnd_api.g_miss_num
3114: AND l_trolin_rec.container_item_id IS NULL
3115: )
3116: )
3117: AND (inv_globals.equal(p_trolin_rec.carton_grouping_id, l_trolin_rec.carton_grouping_id)
3114: AND l_trolin_rec.container_item_id IS NULL
3115: )
3116: )
3117: AND (inv_globals.equal(p_trolin_rec.carton_grouping_id, l_trolin_rec.carton_grouping_id)
3118: OR (p_trolin_rec.carton_grouping_id = fnd_api.g_miss_num
3119: AND l_trolin_rec.carton_grouping_id IS NULL
3120: )
3121: )
3122: AND (inv_globals.equal(p_trolin_rec.wms_process_flag, l_trolin_rec.wms_process_flag)
3119: AND l_trolin_rec.carton_grouping_id IS NULL
3120: )
3121: )
3122: AND (inv_globals.equal(p_trolin_rec.wms_process_flag, l_trolin_rec.wms_process_flag)
3123: OR (p_trolin_rec.wms_process_flag = fnd_api.g_miss_char
3124: AND l_trolin_rec.wms_process_flag IS NULL
3125: )
3126: )
3127: AND (inv_globals.equal(p_trolin_rec.pick_slip_number, l_trolin_rec.pick_slip_number)
3124: AND l_trolin_rec.wms_process_flag IS NULL
3125: )
3126: )
3127: AND (inv_globals.equal(p_trolin_rec.pick_slip_number, l_trolin_rec.pick_slip_number)
3128: OR (p_trolin_rec.pick_slip_number = fnd_api.g_miss_num
3129: AND l_trolin_rec.pick_slip_number IS NULL
3130: )
3131: )
3132: AND (inv_globals.equal(p_trolin_rec.pick_slip_date, l_trolin_rec.pick_slip_date)
3129: AND l_trolin_rec.pick_slip_number IS NULL
3130: )
3131: )
3132: AND (inv_globals.equal(p_trolin_rec.pick_slip_date, l_trolin_rec.pick_slip_date)
3133: OR (p_trolin_rec.pick_slip_date = fnd_api.g_miss_date
3134: AND l_trolin_rec.pick_slip_date IS NULL
3135: )
3136: )
3137: AND (inv_globals.equal(p_trolin_rec.ship_set_id, l_trolin_rec.ship_set_id)
3134: AND l_trolin_rec.pick_slip_date IS NULL
3135: )
3136: )
3137: AND (inv_globals.equal(p_trolin_rec.ship_set_id, l_trolin_rec.ship_set_id)
3138: OR (p_trolin_rec.ship_set_id = fnd_api.g_miss_num
3139: AND l_trolin_rec.ship_set_id IS NULL
3140: )
3141: )
3142: AND (inv_globals.equal(p_trolin_rec.ship_model_id, l_trolin_rec.ship_model_id)
3139: AND l_trolin_rec.ship_set_id IS NULL
3140: )
3141: )
3142: AND (inv_globals.equal(p_trolin_rec.ship_model_id, l_trolin_rec.ship_model_id)
3143: OR (p_trolin_rec.ship_model_id = fnd_api.g_miss_num
3144: AND l_trolin_rec.ship_model_id IS NULL
3145: )
3146: )
3147: AND (inv_globals.equal(p_trolin_rec.model_quantity, l_trolin_rec.model_quantity)
3144: AND l_trolin_rec.ship_model_id IS NULL
3145: )
3146: )
3147: AND (inv_globals.equal(p_trolin_rec.model_quantity, l_trolin_rec.model_quantity)
3148: OR (p_trolin_rec.model_quantity = fnd_api.g_miss_num
3149: AND l_trolin_rec.model_quantity IS NULL
3150: )
3151: ) THEN
3152: -- Row has not changed. Set out parameter.
3153:
3154: x_trolin_rec := l_trolin_rec;
3155: -- Set return status
3156:
3157: x_return_status := fnd_api.g_ret_sts_success;
3158: x_trolin_rec.return_status := fnd_api.g_ret_sts_success;
3159: ELSE
3160: -- Row has changed by another user.
3161:
3154: x_trolin_rec := l_trolin_rec;
3155: -- Set return status
3156:
3157: x_return_status := fnd_api.g_ret_sts_success;
3158: x_trolin_rec.return_status := fnd_api.g_ret_sts_success;
3159: ELSE
3160: -- Row has changed by another user.
3161:
3162: x_return_status := fnd_api.g_ret_sts_error;
3158: x_trolin_rec.return_status := fnd_api.g_ret_sts_success;
3159: ELSE
3160: -- Row has changed by another user.
3161:
3162: x_return_status := fnd_api.g_ret_sts_error;
3163: x_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3164:
3165: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3166: fnd_message.set_name('INV', 'OE_LOCK_ROW_CHANGED');
3159: ELSE
3160: -- Row has changed by another user.
3161:
3162: x_return_status := fnd_api.g_ret_sts_error;
3163: x_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3164:
3165: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3166: fnd_message.set_name('INV', 'OE_LOCK_ROW_CHANGED');
3167: fnd_msg_pub.ADD;
3169: END IF;
3170: --Line2086
3171: EXCEPTION
3172: WHEN NO_DATA_FOUND THEN
3173: x_return_status := fnd_api.g_ret_sts_error;
3174: x_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3175:
3176: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3177: fnd_message.set_name('INV', 'OE_LOCK_ROW_DELETED');
3170: --Line2086
3171: EXCEPTION
3172: WHEN NO_DATA_FOUND THEN
3173: x_return_status := fnd_api.g_ret_sts_error;
3174: x_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3175:
3176: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3177: fnd_message.set_name('INV', 'OE_LOCK_ROW_DELETED');
3178: fnd_msg_pub.ADD;
3177: fnd_message.set_name('INV', 'OE_LOCK_ROW_DELETED');
3178: fnd_msg_pub.ADD;
3179: END IF;
3180: WHEN app_exceptions.record_lock_exception THEN
3181: x_return_status := fnd_api.g_ret_sts_error;
3182: x_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3183:
3184: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3185: fnd_message.set_name('INV', 'OE_LOCK_ROW_ALREADY_LOCKED');
3178: fnd_msg_pub.ADD;
3179: END IF;
3180: WHEN app_exceptions.record_lock_exception THEN
3181: x_return_status := fnd_api.g_ret_sts_error;
3182: x_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3183:
3184: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3185: fnd_message.set_name('INV', 'OE_LOCK_ROW_ALREADY_LOCKED');
3186: fnd_msg_pub.ADD;
3185: fnd_message.set_name('INV', 'OE_LOCK_ROW_ALREADY_LOCKED');
3186: fnd_msg_pub.ADD;
3187: END IF;
3188: WHEN OTHERS THEN
3189: x_return_status := fnd_api.g_ret_sts_unexp_error;
3190: x_trolin_rec.return_status := fnd_api.g_ret_sts_unexp_error;
3191:
3192: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3193: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Lock_Row');
3186: fnd_msg_pub.ADD;
3187: END IF;
3188: WHEN OTHERS THEN
3189: x_return_status := fnd_api.g_ret_sts_unexp_error;
3190: x_trolin_rec.return_status := fnd_api.g_ret_sts_unexp_error;
3191:
3192: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3193: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Lock_Row');
3194: END IF;
3201: l_trolin_val_rec inv_move_order_pub.trolin_val_rec_type;
3202: BEGIN
3203: -- Line2147
3204: IF p_trolin_rec.from_locator_id IS NOT NULL
3205: AND p_trolin_rec.from_locator_id <> fnd_api.g_miss_num
3206: AND NOT inv_globals.equal(p_trolin_rec.from_locator_id, p_old_trolin_rec.from_locator_id) THEN
3207: l_trolin_val_rec.from_locator := inv_id_to_value.from_locator(p_from_locator_id => p_trolin_rec.from_locator_id);
3208: END IF;
3209:
3207: l_trolin_val_rec.from_locator := inv_id_to_value.from_locator(p_from_locator_id => p_trolin_rec.from_locator_id);
3208: END IF;
3209:
3210: -- IF p_trolin_rec.from_subinventory_code IS NOT NULL AND
3211: -- p_trolin_rec.from_subinventory_code <> FND_API.G_MISS_CHAR AND
3212: -- NOT INV_GLOBALS.Equal(p_trolin_rec.from_subinventory_code,
3213: -- p_old_trolin_rec.from_subinventory_code)
3214: -- THEN
3215: -- l_trolin_val_rec.from_subinventory := INV_Id_To_Value.From_Subinventory
3217: -- );
3218: -- END IF; -- Generated
3219: -- Line 2167
3220: IF p_trolin_rec.from_subinventory_id IS NOT NULL
3221: AND p_trolin_rec.from_subinventory_id <> fnd_api.g_miss_num
3222: AND NOT inv_globals.equal(p_trolin_rec.from_subinventory_id, p_old_trolin_rec.from_subinventory_id) THEN
3223: l_trolin_val_rec.from_subinventory := inv_id_to_value.from_subinventory(p_from_subinventory_id => p_trolin_rec.from_subinventory_id);
3224: -- ( p_from_subinventory_id => p_trolin_rec.from_subinventory_id
3225: -- );
3225: -- );
3226: END IF;
3227:
3228: IF p_trolin_rec.header_id IS NOT NULL
3229: AND p_trolin_rec.header_id <> fnd_api.g_miss_num
3230: AND NOT inv_globals.equal(p_trolin_rec.header_id, p_old_trolin_rec.header_id) THEN
3231: l_trolin_val_rec.header := inv_id_to_value.header(p_header_id => p_trolin_rec.header_id);
3232: END IF;
3233:
3231: l_trolin_val_rec.header := inv_id_to_value.header(p_header_id => p_trolin_rec.header_id);
3232: END IF;
3233:
3234: IF p_trolin_rec.inventory_item_id IS NOT NULL
3235: AND p_trolin_rec.inventory_item_id <> fnd_api.g_miss_num
3236: AND NOT inv_globals.equal(p_trolin_rec.inventory_item_id, p_old_trolin_rec.inventory_item_id) THEN
3237: l_trolin_val_rec.inventory_item := inv_id_to_value.inventory_item(p_inventory_item_id => p_trolin_rec.inventory_item_id);
3238: END IF;
3239:
3237: l_trolin_val_rec.inventory_item := inv_id_to_value.inventory_item(p_inventory_item_id => p_trolin_rec.inventory_item_id);
3238: END IF;
3239:
3240: IF p_trolin_rec.line_id IS NOT NULL
3241: AND p_trolin_rec.line_id <> fnd_api.g_miss_num
3242: AND NOT inv_globals.equal(p_trolin_rec.line_id, p_old_trolin_rec.line_id) THEN
3243: l_trolin_val_rec.line := inv_id_to_value.line(p_line_id => p_trolin_rec.line_id);
3244: END IF;
3245:
3243: l_trolin_val_rec.line := inv_id_to_value.line(p_line_id => p_trolin_rec.line_id);
3244: END IF;
3245:
3246: IF p_trolin_rec.organization_id IS NOT NULL
3247: AND p_trolin_rec.organization_id <> fnd_api.g_miss_num
3248: AND NOT inv_globals.equal(p_trolin_rec.organization_id, p_old_trolin_rec.organization_id) THEN
3249: l_trolin_val_rec.ORGANIZATION := inv_id_to_value.ORGANIZATION(p_organization_id => p_trolin_rec.organization_id);
3250: END IF;
3251:
3249: l_trolin_val_rec.ORGANIZATION := inv_id_to_value.ORGANIZATION(p_organization_id => p_trolin_rec.organization_id);
3250: END IF;
3251:
3252: IF p_trolin_rec.to_organization_id IS NOT NULL
3253: AND p_trolin_rec.to_organization_id <> fnd_api.g_miss_num
3254: AND NOT inv_globals.equal(p_trolin_rec.to_organization_id, p_old_trolin_rec.to_organization_id) THEN
3255: l_trolin_val_rec.to_organization := inv_id_to_value.to_organization(p_to_organization_id => p_trolin_rec.to_organization_id);
3256: END IF;
3257:
3255: l_trolin_val_rec.to_organization := inv_id_to_value.to_organization(p_to_organization_id => p_trolin_rec.to_organization_id);
3256: END IF;
3257:
3258: IF p_trolin_rec.project_id IS NOT NULL
3259: AND p_trolin_rec.project_id <> fnd_api.g_miss_num
3260: AND NOT inv_globals.equal(p_trolin_rec.project_id, p_old_trolin_rec.project_id) THEN
3261: l_trolin_val_rec.project := inv_id_to_value.project(p_project_id => p_trolin_rec.project_id);
3262: END IF;
3263:
3261: l_trolin_val_rec.project := inv_id_to_value.project(p_project_id => p_trolin_rec.project_id);
3262: END IF;
3263:
3264: IF p_trolin_rec.reason_id IS NOT NULL
3265: AND p_trolin_rec.reason_id <> fnd_api.g_miss_num
3266: AND NOT inv_globals.equal(p_trolin_rec.reason_id, p_old_trolin_rec.reason_id) THEN
3267: l_trolin_val_rec.reason := inv_id_to_value.reason(p_reason_id => p_trolin_rec.reason_id);
3268: END IF;
3269:
3267: l_trolin_val_rec.reason := inv_id_to_value.reason(p_reason_id => p_trolin_rec.reason_id);
3268: END IF;
3269:
3270: IF p_trolin_rec.reference_id IS NOT NULL
3271: AND p_trolin_rec.reference_id <> fnd_api.g_miss_num
3272: AND NOT inv_globals.equal(p_trolin_rec.reference_id, p_old_trolin_rec.reference_id) THEN
3273: l_trolin_val_rec.REFERENCE := inv_id_to_value.REFERENCE(p_reference_id => p_trolin_rec.reference_id);
3274: END IF;
3275:
3273: l_trolin_val_rec.REFERENCE := inv_id_to_value.REFERENCE(p_reference_id => p_trolin_rec.reference_id);
3274: END IF;
3275:
3276: IF p_trolin_rec.reference_type_code IS NOT NULL
3277: AND p_trolin_rec.reference_type_code <> fnd_api.g_miss_num
3278: AND NOT inv_globals.equal(p_trolin_rec.reference_type_code, p_old_trolin_rec.reference_type_code) THEN
3279: l_trolin_val_rec.reference_type := inv_id_to_value.reference_type(p_reference_type_code => p_trolin_rec.reference_type_code);
3280: END IF;
3281:
3279: l_trolin_val_rec.reference_type := inv_id_to_value.reference_type(p_reference_type_code => p_trolin_rec.reference_type_code);
3280: END IF;
3281:
3282: IF p_trolin_rec.task_id IS NOT NULL
3283: AND p_trolin_rec.task_id <> fnd_api.g_miss_num
3284: AND NOT inv_globals.equal(p_trolin_rec.task_id, p_old_trolin_rec.task_id) THEN
3285: l_trolin_val_rec.task := inv_id_to_value.task(p_task_id => p_trolin_rec.task_id);
3286: END IF;
3287:
3285: l_trolin_val_rec.task := inv_id_to_value.task(p_task_id => p_trolin_rec.task_id);
3286: END IF;
3287:
3288: IF p_trolin_rec.to_account_id IS NOT NULL
3289: AND p_trolin_rec.to_account_id <> fnd_api.g_miss_num
3290: AND NOT inv_globals.equal(p_trolin_rec.to_account_id, p_old_trolin_rec.to_account_id) THEN
3291: l_trolin_val_rec.to_account := inv_id_to_value.to_account(p_to_account_id => p_trolin_rec.to_account_id);
3292: END IF;
3293:
3291: l_trolin_val_rec.to_account := inv_id_to_value.to_account(p_to_account_id => p_trolin_rec.to_account_id);
3292: END IF;
3293:
3294: IF p_trolin_rec.to_locator_id IS NOT NULL
3295: AND p_trolin_rec.to_locator_id <> fnd_api.g_miss_num
3296: AND NOT inv_globals.equal(p_trolin_rec.to_locator_id, p_old_trolin_rec.to_locator_id) THEN
3297: l_trolin_val_rec.to_locator := inv_id_to_value.to_locator(p_to_locator_id => p_trolin_rec.to_locator_id);
3298: END IF;
3299:
3297: l_trolin_val_rec.to_locator := inv_id_to_value.to_locator(p_to_locator_id => p_trolin_rec.to_locator_id);
3298: END IF;
3299:
3300: -- IF p_trolin_rec.to_subinventory_code IS NOT NULL AND
3301: -- p_trolin_rec.to_subinventory_code <> FND_API.G_MISS_CHAR AND
3302: -- NOT INV_GLOBALS.Equal(p_trolin_rec.to_subinventory_code,
3303: -- p_old_trolin_rec.to_subinventory_code)
3304: -- THEN
3305: -- l_trolin_val_rec.to_subinventory := INV_Id_To_Value.To_Subinventory
3307: -- );
3308: -- END IF; -- Generated
3309:
3310: IF p_trolin_rec.to_subinventory_id IS NOT NULL
3311: AND p_trolin_rec.to_subinventory_id <> fnd_api.g_miss_num
3312: AND NOT inv_globals.equal(p_trolin_rec.to_subinventory_id, p_old_trolin_rec.to_subinventory_id) THEN
3313: l_trolin_val_rec.to_subinventory := inv_id_to_value.to_subinventory(p_to_subinventory_id => p_trolin_rec.to_subinventory_id);
3314: END IF;
3315:
3313: l_trolin_val_rec.to_subinventory := inv_id_to_value.to_subinventory(p_to_subinventory_id => p_trolin_rec.to_subinventory_id);
3314: END IF;
3315:
3316: IF p_trolin_rec.transaction_header_id IS NOT NULL
3317: AND p_trolin_rec.transaction_header_id <> fnd_api.g_miss_num
3318: AND NOT inv_globals.equal(p_trolin_rec.transaction_header_id, p_old_trolin_rec.transaction_header_id) THEN
3319: l_trolin_val_rec.transaction_header := inv_id_to_value.transaction_header(p_transaction_header_id => p_trolin_rec.transaction_header_id);
3320: END IF;
3321:
3319: l_trolin_val_rec.transaction_header := inv_id_to_value.transaction_header(p_transaction_header_id => p_trolin_rec.transaction_header_id);
3320: END IF;
3321:
3322: IF p_trolin_rec.transaction_type_id IS NOT NULL
3323: AND p_trolin_rec.transaction_type_id <> fnd_api.g_miss_num
3324: AND NOT inv_globals.equal(p_trolin_rec.transaction_type_id, p_old_trolin_rec.transaction_type_id) THEN
3325: l_trolin_val_rec.transaction_type := inv_id_to_value.transaction_type(p_transaction_type_id => p_trolin_rec.transaction_type_id);
3326: END IF;
3327:
3325: l_trolin_val_rec.transaction_type := inv_id_to_value.transaction_type(p_transaction_type_id => p_trolin_rec.transaction_type_id);
3326: END IF;
3327:
3328: IF p_trolin_rec.uom_code IS NOT NULL
3329: AND p_trolin_rec.uom_code <> fnd_api.g_miss_char
3330: AND NOT inv_globals.equal(p_trolin_rec.uom_code, p_old_trolin_rec.uom_code) THEN
3331: l_trolin_val_rec.uom := inv_id_to_value.uom(p_uom_code => p_trolin_rec.uom_code);
3332: END IF;
3333:
3341: l_trolin_rec inv_move_order_pub.trolin_rec_type;
3342: BEGIN
3343: -- initialize return_status.
3344:
3345: l_trolin_rec.return_status := fnd_api.g_ret_sts_success;
3346: -- initialize l_trolin_rec.
3347:
3348: l_trolin_rec := p_trolin_rec;
3349:
3347:
3348: l_trolin_rec := p_trolin_rec;
3349:
3350: /*
3351: IF p_trolin_val_rec.from_locator <> FND_API.G_MISS_CHAR
3352: THEN
3353:
3354: IF p_trolin_rec.from_locator_id <> FND_API.G_MISS_NUM THEN
3355:
3350: /*
3351: IF p_trolin_val_rec.from_locator <> FND_API.G_MISS_CHAR
3352: THEN
3353:
3354: IF p_trolin_rec.from_locator_id <> FND_API.G_MISS_NUM THEN
3355:
3356: l_trolin_rec.from_locator_id := p_trolin_rec.from_locator_id;
3357:
3358: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3370: ( p_organizatoin_id => p_trolin_rec.organization_id,
3371: p_from_locator => p_trolin_val_rec.from_locator
3372: );
3373:
3374: IF l_trolin_rec.from_locator_id = FND_API.G_MISS_NUM THEN
3375: l_trolin_rec.return_status := FND_API.G_RET_STS_ERROR;
3376: END IF;
3377:
3378: END IF;
3371: p_from_locator => p_trolin_val_rec.from_locator
3372: );
3373:
3374: IF l_trolin_rec.from_locator_id = FND_API.G_MISS_NUM THEN
3375: l_trolin_rec.return_status := FND_API.G_RET_STS_ERROR;
3376: END IF;
3377:
3378: END IF;
3379:
3379:
3380: END IF;
3381: */
3382:
3383: IF p_trolin_val_rec.from_subinventory <> fnd_api.g_miss_char THEN
3384: IF p_trolin_rec.from_subinventory_id <> fnd_api.g_miss_num THEN
3385: l_trolin_rec.from_subinventory_id := p_trolin_rec.from_subinventory_id;
3386:
3387: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3380: END IF;
3381: */
3382:
3383: IF p_trolin_val_rec.from_subinventory <> fnd_api.g_miss_char THEN
3384: IF p_trolin_rec.from_subinventory_id <> fnd_api.g_miss_num THEN
3385: l_trolin_rec.from_subinventory_id := p_trolin_rec.from_subinventory_id;
3386:
3387: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3388: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3391: END IF;
3392: ELSE
3393: 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);
3394:
3395: IF l_trolin_rec.from_subinventory_id = fnd_api.g_miss_num THEN
3396: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3397: END IF;
3398: END IF;
3399: END IF;
3392: ELSE
3393: 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);
3394:
3395: IF l_trolin_rec.from_subinventory_id = fnd_api.g_miss_num THEN
3396: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3397: END IF;
3398: END IF;
3399: END IF;
3400:
3397: END IF;
3398: END IF;
3399: END IF;
3400:
3401: IF p_trolin_val_rec.header <> fnd_api.g_miss_char THEN
3402: IF p_trolin_rec.header_id <> fnd_api.g_miss_num THEN
3403: l_trolin_rec.header_id := p_trolin_rec.header_id;
3404:
3405: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3398: END IF;
3399: END IF;
3400:
3401: IF p_trolin_val_rec.header <> fnd_api.g_miss_char THEN
3402: IF p_trolin_rec.header_id <> fnd_api.g_miss_num THEN
3403: l_trolin_rec.header_id := p_trolin_rec.header_id;
3404:
3405: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3406: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3409: END IF;
3410: ELSE
3411: l_trolin_rec.header_id := inv_value_to_id.header(p_header => p_trolin_val_rec.header);
3412:
3413: IF l_trolin_rec.header_id = fnd_api.g_miss_num THEN
3414: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3415: END IF;
3416: END IF;
3417: END IF;
3410: ELSE
3411: l_trolin_rec.header_id := inv_value_to_id.header(p_header => p_trolin_val_rec.header);
3412:
3413: IF l_trolin_rec.header_id = fnd_api.g_miss_num THEN
3414: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3415: END IF;
3416: END IF;
3417: END IF;
3418:
3415: END IF;
3416: END IF;
3417: END IF;
3418:
3419: IF p_trolin_val_rec.inventory_item <> fnd_api.g_miss_char THEN
3420: IF p_trolin_rec.inventory_item_id <> fnd_api.g_miss_num THEN
3421: l_trolin_rec.inventory_item_id := p_trolin_rec.inventory_item_id;
3422:
3423: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3416: END IF;
3417: END IF;
3418:
3419: IF p_trolin_val_rec.inventory_item <> fnd_api.g_miss_char THEN
3420: IF p_trolin_rec.inventory_item_id <> fnd_api.g_miss_num THEN
3421: l_trolin_rec.inventory_item_id := p_trolin_rec.inventory_item_id;
3422:
3423: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3424: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3427: END IF;
3428: ELSE
3429: 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);
3430:
3431: IF l_trolin_rec.inventory_item_id = fnd_api.g_miss_num THEN
3432: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3433: END IF;
3434: END IF;
3435: END IF;
3428: ELSE
3429: 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);
3430:
3431: IF l_trolin_rec.inventory_item_id = fnd_api.g_miss_num THEN
3432: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3433: END IF;
3434: END IF;
3435: END IF;
3436:
3433: END IF;
3434: END IF;
3435: END IF;
3436:
3437: IF p_trolin_val_rec.line <> fnd_api.g_miss_char THEN
3438: IF p_trolin_rec.line_id <> fnd_api.g_miss_num THEN
3439: l_trolin_rec.line_id := p_trolin_rec.line_id;
3440:
3441: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3434: END IF;
3435: END IF;
3436:
3437: IF p_trolin_val_rec.line <> fnd_api.g_miss_char THEN
3438: IF p_trolin_rec.line_id <> fnd_api.g_miss_num THEN
3439: l_trolin_rec.line_id := p_trolin_rec.line_id;
3440:
3441: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3442: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3445: END IF;
3446: ELSE
3447: l_trolin_rec.line_id := inv_value_to_id.line(p_line => p_trolin_val_rec.line);
3448:
3449: IF l_trolin_rec.line_id = fnd_api.g_miss_num THEN
3450: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3451: END IF;
3452: END IF;
3453: END IF;
3446: ELSE
3447: l_trolin_rec.line_id := inv_value_to_id.line(p_line => p_trolin_val_rec.line);
3448:
3449: IF l_trolin_rec.line_id = fnd_api.g_miss_num THEN
3450: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3451: END IF;
3452: END IF;
3453: END IF;
3454:
3451: END IF;
3452: END IF;
3453: END IF;
3454:
3455: IF p_trolin_val_rec.ORGANIZATION <> fnd_api.g_miss_char THEN
3456: IF p_trolin_rec.organization_id <> fnd_api.g_miss_num THEN
3457: l_trolin_rec.organization_id := p_trolin_rec.organization_id;
3458:
3459: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3452: END IF;
3453: END IF;
3454:
3455: IF p_trolin_val_rec.ORGANIZATION <> fnd_api.g_miss_char THEN
3456: IF p_trolin_rec.organization_id <> fnd_api.g_miss_num THEN
3457: l_trolin_rec.organization_id := p_trolin_rec.organization_id;
3458:
3459: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3460: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3463: END IF;
3464: ELSE
3465: l_trolin_rec.organization_id := inv_value_to_id.ORGANIZATION(p_organization => p_trolin_val_rec.ORGANIZATION);
3466:
3467: IF l_trolin_rec.organization_id = fnd_api.g_miss_num THEN
3468: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3469: END IF;
3470: END IF;
3471: END IF;
3464: ELSE
3465: l_trolin_rec.organization_id := inv_value_to_id.ORGANIZATION(p_organization => p_trolin_val_rec.ORGANIZATION);
3466:
3467: IF l_trolin_rec.organization_id = fnd_api.g_miss_num THEN
3468: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3469: END IF;
3470: END IF;
3471: END IF;
3472:
3469: END IF;
3470: END IF;
3471: END IF;
3472:
3473: IF p_trolin_val_rec.to_organization <> fnd_api.g_miss_char THEN
3474: IF p_trolin_rec.to_organization_id <> fnd_api.g_miss_num THEN
3475: l_trolin_rec.to_organization_id := p_trolin_rec.to_organization_id;
3476:
3477: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3470: END IF;
3471: END IF;
3472:
3473: IF p_trolin_val_rec.to_organization <> fnd_api.g_miss_char THEN
3474: IF p_trolin_rec.to_organization_id <> fnd_api.g_miss_num THEN
3475: l_trolin_rec.to_organization_id := p_trolin_rec.to_organization_id;
3476:
3477: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3478: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3481: END IF;
3482: ELSE
3483: l_trolin_rec.to_organization_id := inv_value_to_id.to_organization(p_to_organization => p_trolin_val_rec.to_organization);
3484:
3485: IF l_trolin_rec.to_organization_id = fnd_api.g_miss_num THEN
3486: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3487: END IF;
3488: END IF;
3489: END IF;
3482: ELSE
3483: l_trolin_rec.to_organization_id := inv_value_to_id.to_organization(p_to_organization => p_trolin_val_rec.to_organization);
3484:
3485: IF l_trolin_rec.to_organization_id = fnd_api.g_miss_num THEN
3486: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3487: END IF;
3488: END IF;
3489: END IF;
3490:
3487: END IF;
3488: END IF;
3489: END IF;
3490:
3491: IF p_trolin_val_rec.project <> fnd_api.g_miss_char THEN
3492: IF p_trolin_rec.project_id <> fnd_api.g_miss_num THEN
3493: l_trolin_rec.project_id := p_trolin_rec.project_id;
3494:
3495: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3488: END IF;
3489: END IF;
3490:
3491: IF p_trolin_val_rec.project <> fnd_api.g_miss_char THEN
3492: IF p_trolin_rec.project_id <> fnd_api.g_miss_num THEN
3493: l_trolin_rec.project_id := p_trolin_rec.project_id;
3494:
3495: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3496: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3499: END IF;
3500: ELSE
3501: l_trolin_rec.project_id := inv_value_to_id.project(p_project => p_trolin_val_rec.project);
3502:
3503: IF l_trolin_rec.project_id = fnd_api.g_miss_num THEN
3504: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3505: END IF;
3506: END IF;
3507: END IF;
3500: ELSE
3501: l_trolin_rec.project_id := inv_value_to_id.project(p_project => p_trolin_val_rec.project);
3502:
3503: IF l_trolin_rec.project_id = fnd_api.g_miss_num THEN
3504: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3505: END IF;
3506: END IF;
3507: END IF;
3508:
3505: END IF;
3506: END IF;
3507: END IF;
3508:
3509: IF p_trolin_val_rec.reason <> fnd_api.g_miss_char THEN
3510: IF p_trolin_rec.reason_id <> fnd_api.g_miss_num THEN
3511: l_trolin_rec.reason_id := p_trolin_rec.reason_id;
3512:
3513: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3506: END IF;
3507: END IF;
3508:
3509: IF p_trolin_val_rec.reason <> fnd_api.g_miss_char THEN
3510: IF p_trolin_rec.reason_id <> fnd_api.g_miss_num THEN
3511: l_trolin_rec.reason_id := p_trolin_rec.reason_id;
3512:
3513: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3514: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3517: END IF;
3518: ELSE
3519: l_trolin_rec.reason_id := inv_value_to_id.reason(p_reason => p_trolin_val_rec.reason);
3520:
3521: IF l_trolin_rec.reason_id = fnd_api.g_miss_num THEN
3522: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3523: END IF;
3524: END IF;
3525: END IF;
3518: ELSE
3519: l_trolin_rec.reason_id := inv_value_to_id.reason(p_reason => p_trolin_val_rec.reason);
3520:
3521: IF l_trolin_rec.reason_id = fnd_api.g_miss_num THEN
3522: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3523: END IF;
3524: END IF;
3525: END IF;
3526:
3523: END IF;
3524: END IF;
3525: END IF;
3526:
3527: IF p_trolin_val_rec.REFERENCE <> fnd_api.g_miss_char THEN
3528: IF p_trolin_rec.reference_id <> fnd_api.g_miss_num THEN
3529: l_trolin_rec.reference_id := p_trolin_rec.reference_id;
3530:
3531: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3524: END IF;
3525: END IF;
3526:
3527: IF p_trolin_val_rec.REFERENCE <> fnd_api.g_miss_char THEN
3528: IF p_trolin_rec.reference_id <> fnd_api.g_miss_num THEN
3529: l_trolin_rec.reference_id := p_trolin_rec.reference_id;
3530:
3531: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3532: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3535: END IF;
3536: ELSE
3537: l_trolin_rec.reference_id := inv_value_to_id.REFERENCE(p_reference => p_trolin_val_rec.REFERENCE);
3538:
3539: IF l_trolin_rec.reference_id = fnd_api.g_miss_num THEN
3540: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3541: END IF;
3542: END IF;
3543: END IF;
3536: ELSE
3537: l_trolin_rec.reference_id := inv_value_to_id.REFERENCE(p_reference => p_trolin_val_rec.REFERENCE);
3538:
3539: IF l_trolin_rec.reference_id = fnd_api.g_miss_num THEN
3540: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3541: END IF;
3542: END IF;
3543: END IF;
3544:
3541: END IF;
3542: END IF;
3543: END IF;
3544:
3545: IF p_trolin_val_rec.reference_type <> fnd_api.g_miss_char THEN
3546: IF p_trolin_rec.reference_type_code <> fnd_api.g_miss_num THEN
3547: l_trolin_rec.reference_type_code := p_trolin_rec.reference_type_code;
3548:
3549: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3542: END IF;
3543: END IF;
3544:
3545: IF p_trolin_val_rec.reference_type <> fnd_api.g_miss_char THEN
3546: IF p_trolin_rec.reference_type_code <> fnd_api.g_miss_num THEN
3547: l_trolin_rec.reference_type_code := p_trolin_rec.reference_type_code;
3548:
3549: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3550: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3553: END IF;
3554: ELSE
3555: l_trolin_rec.reference_type_code := inv_value_to_id.reference_type(p_reference_type => p_trolin_val_rec.reference_type);
3556:
3557: IF l_trolin_rec.reference_type_code = fnd_api.g_miss_num THEN
3558: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3559: END IF;
3560: END IF;
3561: END IF;
3554: ELSE
3555: l_trolin_rec.reference_type_code := inv_value_to_id.reference_type(p_reference_type => p_trolin_val_rec.reference_type);
3556:
3557: IF l_trolin_rec.reference_type_code = fnd_api.g_miss_num THEN
3558: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3559: END IF;
3560: END IF;
3561: END IF;
3562:
3559: END IF;
3560: END IF;
3561: END IF;
3562:
3563: IF p_trolin_val_rec.task <> fnd_api.g_miss_char THEN
3564: IF p_trolin_rec.task_id <> fnd_api.g_miss_num THEN
3565: l_trolin_rec.task_id := p_trolin_rec.task_id;
3566:
3567: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3560: END IF;
3561: END IF;
3562:
3563: IF p_trolin_val_rec.task <> fnd_api.g_miss_char THEN
3564: IF p_trolin_rec.task_id <> fnd_api.g_miss_num THEN
3565: l_trolin_rec.task_id := p_trolin_rec.task_id;
3566:
3567: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3568: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3571: END IF;
3572: ELSE
3573: l_trolin_rec.task_id := inv_value_to_id.task(p_task => p_trolin_val_rec.task);
3574:
3575: IF l_trolin_rec.task_id = fnd_api.g_miss_num THEN
3576: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3577: END IF;
3578: END IF;
3579: END IF;
3572: ELSE
3573: l_trolin_rec.task_id := inv_value_to_id.task(p_task => p_trolin_val_rec.task);
3574:
3575: IF l_trolin_rec.task_id = fnd_api.g_miss_num THEN
3576: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3577: END IF;
3578: END IF;
3579: END IF;
3580:
3577: END IF;
3578: END IF;
3579: END IF;
3580:
3581: IF p_trolin_val_rec.to_account <> fnd_api.g_miss_char THEN
3582: IF p_trolin_rec.to_account_id <> fnd_api.g_miss_num THEN
3583: l_trolin_rec.to_account_id := p_trolin_rec.to_account_id;
3584:
3585: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3578: END IF;
3579: END IF;
3580:
3581: IF p_trolin_val_rec.to_account <> fnd_api.g_miss_char THEN
3582: IF p_trolin_rec.to_account_id <> fnd_api.g_miss_num THEN
3583: l_trolin_rec.to_account_id := p_trolin_rec.to_account_id;
3584:
3585: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3586: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3589: END IF;
3590: ELSE
3591: 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);
3592:
3593: IF l_trolin_rec.to_account_id = fnd_api.g_miss_num THEN
3594: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3595: END IF;
3596: END IF;
3597: END IF;
3590: ELSE
3591: 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);
3592:
3593: IF l_trolin_rec.to_account_id = fnd_api.g_miss_num THEN
3594: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3595: END IF;
3596: END IF;
3597: END IF;
3598:
3596: END IF;
3597: END IF;
3598:
3599: /*
3600: IF p_trolin_val_rec.to_locator <> FND_API.G_MISS_CHAR
3601: THEN
3602:
3603: IF p_trolin_rec.to_locator_id <> FND_API.G_MISS_NUM THEN
3604:
3599: /*
3600: IF p_trolin_val_rec.to_locator <> FND_API.G_MISS_CHAR
3601: THEN
3602:
3603: IF p_trolin_rec.to_locator_id <> FND_API.G_MISS_NUM THEN
3604:
3605: l_trolin_rec.to_locator_id := p_trolin_rec.to_locator_id;
3606:
3607: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3618: l_trolin_rec.to_locator_id := INV_Value_To_Id.to_locator
3619: ( p_to_locator => p_trolin_val_rec.to_locator
3620: );
3621:
3622: IF l_trolin_rec.to_locator_id = FND_API.G_MISS_NUM THEN
3623: l_trolin_rec.return_status := FND_API.G_RET_STS_ERROR;
3624: END IF;
3625:
3626: END IF;
3619: ( p_to_locator => p_trolin_val_rec.to_locator
3620: );
3621:
3622: IF l_trolin_rec.to_locator_id = FND_API.G_MISS_NUM THEN
3623: l_trolin_rec.return_status := FND_API.G_RET_STS_ERROR;
3624: END IF;
3625:
3626: END IF;
3627:
3627:
3628: END IF;
3629: */
3630:
3631: IF p_trolin_val_rec.to_subinventory <> fnd_api.g_miss_char THEN
3632: IF p_trolin_rec.to_subinventory_code <> fnd_api.g_miss_char THEN
3633: l_trolin_rec.to_subinventory_code := p_trolin_rec.to_subinventory_code;
3634:
3635: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3628: END IF;
3629: */
3630:
3631: IF p_trolin_val_rec.to_subinventory <> fnd_api.g_miss_char THEN
3632: IF p_trolin_rec.to_subinventory_code <> fnd_api.g_miss_char THEN
3633: l_trolin_rec.to_subinventory_code := p_trolin_rec.to_subinventory_code;
3634:
3635: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3636: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3639: END IF;
3640: ELSE
3641: 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);
3642:
3643: IF l_trolin_rec.to_subinventory_code = fnd_api.g_miss_char THEN
3644: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3645: END IF;
3646: END IF;
3647: END IF;
3640: ELSE
3641: 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);
3642:
3643: IF l_trolin_rec.to_subinventory_code = fnd_api.g_miss_char THEN
3644: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3645: END IF;
3646: END IF;
3647: END IF;
3648:
3646: END IF;
3647: END IF;
3648:
3649: -- Line2839
3650: IF p_trolin_val_rec.to_subinventory <> fnd_api.g_miss_char THEN
3651: IF p_trolin_rec.to_subinventory_id <> fnd_api.g_miss_num THEN
3652: l_trolin_rec.to_subinventory_id := p_trolin_rec.to_subinventory_id;
3653:
3654: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3647: END IF;
3648:
3649: -- Line2839
3650: IF p_trolin_val_rec.to_subinventory <> fnd_api.g_miss_char THEN
3651: IF p_trolin_rec.to_subinventory_id <> fnd_api.g_miss_num THEN
3652: l_trolin_rec.to_subinventory_id := p_trolin_rec.to_subinventory_id;
3653:
3654: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3655: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3658: END IF;
3659: ELSE
3660: 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);
3661:
3662: IF l_trolin_rec.to_subinventory_id = fnd_api.g_miss_num THEN
3663: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3664: END IF;
3665: END IF;
3666: END IF;
3659: ELSE
3660: 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);
3661:
3662: IF l_trolin_rec.to_subinventory_id = fnd_api.g_miss_num THEN
3663: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3664: END IF;
3665: END IF;
3666: END IF;
3667:
3664: END IF;
3665: END IF;
3666: END IF;
3667:
3668: IF p_trolin_val_rec.transaction_header <> fnd_api.g_miss_char THEN
3669: IF p_trolin_rec.transaction_header_id <> fnd_api.g_miss_num THEN
3670: l_trolin_rec.transaction_header_id := p_trolin_rec.transaction_header_id;
3671:
3672: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3665: END IF;
3666: END IF;
3667:
3668: IF p_trolin_val_rec.transaction_header <> fnd_api.g_miss_char THEN
3669: IF p_trolin_rec.transaction_header_id <> fnd_api.g_miss_num THEN
3670: l_trolin_rec.transaction_header_id := p_trolin_rec.transaction_header_id;
3671:
3672: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3673: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3676: END IF;
3677: ELSE
3678: l_trolin_rec.transaction_header_id := inv_value_to_id.transaction_header(p_transaction_header => p_trolin_val_rec.transaction_header);
3679:
3680: IF l_trolin_rec.transaction_header_id = fnd_api.g_miss_num THEN
3681: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3682: END IF;
3683: END IF;
3684: END IF;
3677: ELSE
3678: l_trolin_rec.transaction_header_id := inv_value_to_id.transaction_header(p_transaction_header => p_trolin_val_rec.transaction_header);
3679:
3680: IF l_trolin_rec.transaction_header_id = fnd_api.g_miss_num THEN
3681: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3682: END IF;
3683: END IF;
3684: END IF;
3685:
3682: END IF;
3683: END IF;
3684: END IF;
3685:
3686: IF p_trolin_val_rec.transaction_type <> fnd_api.g_miss_char THEN
3687: IF p_trolin_rec.transaction_type_id <> fnd_api.g_miss_num THEN
3688: l_trolin_rec.transaction_type_id := p_trolin_rec.transaction_type_id;
3689:
3690: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3683: END IF;
3684: END IF;
3685:
3686: IF p_trolin_val_rec.transaction_type <> fnd_api.g_miss_char THEN
3687: IF p_trolin_rec.transaction_type_id <> fnd_api.g_miss_num THEN
3688: l_trolin_rec.transaction_type_id := p_trolin_rec.transaction_type_id;
3689:
3690: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3691: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3694: END IF;
3695: ELSE
3696: l_trolin_rec.transaction_type_id := inv_value_to_id.transaction_type(p_transaction_type => p_trolin_val_rec.transaction_type);
3697:
3698: IF l_trolin_rec.transaction_type_id = fnd_api.g_miss_num THEN
3699: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3700: END IF;
3701: END IF;
3702: END IF;
3695: ELSE
3696: l_trolin_rec.transaction_type_id := inv_value_to_id.transaction_type(p_transaction_type => p_trolin_val_rec.transaction_type);
3697:
3698: IF l_trolin_rec.transaction_type_id = fnd_api.g_miss_num THEN
3699: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3700: END IF;
3701: END IF;
3702: END IF;
3703:
3701: END IF;
3702: END IF;
3703:
3704: -- Line2899
3705: IF p_trolin_val_rec.uom <> fnd_api.g_miss_char THEN
3706: IF p_trolin_rec.uom_code <> fnd_api.g_miss_char THEN
3707: l_trolin_rec.uom_code := p_trolin_rec.uom_code;
3708:
3709: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3702: END IF;
3703:
3704: -- Line2899
3705: IF p_trolin_val_rec.uom <> fnd_api.g_miss_char THEN
3706: IF p_trolin_rec.uom_code <> fnd_api.g_miss_char THEN
3707: l_trolin_rec.uom_code := p_trolin_rec.uom_code;
3708:
3709: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3710: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3714: ELSE
3715: -- Line2917
3716: l_trolin_rec.uom_code := inv_value_to_id.uom(p_uom => p_trolin_val_rec.uom);
3717:
3718: IF l_trolin_rec.uom_code = fnd_api.g_miss_char THEN
3719: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3720: END IF;
3721: END IF;
3722: END IF;
3715: -- Line2917
3716: l_trolin_rec.uom_code := inv_value_to_id.uom(p_uom => p_trolin_val_rec.uom);
3717:
3718: IF l_trolin_rec.uom_code = fnd_api.g_miss_char THEN
3719: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3720: END IF;
3721: END IF;
3722: END IF;
3723:
3733: FORALL i IN 1 .. p_new_trolin_tbl.COUNT
3734: insert into mtl_txn_request_lines
3735: values p_new_trolin_tbl(i);
3736:
3737: x_return_status := fnd_api.g_ret_sts_success;
3738: EXCEPTION
3739: WHEN OTHERS THEN
3740: x_return_status := fnd_api.g_ret_sts_error;
3741: RAISE fnd_api.g_exc_unexpected_error;
3736:
3737: x_return_status := fnd_api.g_ret_sts_success;
3738: EXCEPTION
3739: WHEN OTHERS THEN
3740: x_return_status := fnd_api.g_ret_sts_error;
3741: RAISE fnd_api.g_exc_unexpected_error;
3742: END insert_mo_lines_bulk;
3743:
3744: END inv_trolin_util;
3737: x_return_status := fnd_api.g_ret_sts_success;
3738: EXCEPTION
3739: WHEN OTHERS THEN
3740: x_return_status := fnd_api.g_ret_sts_error;
3741: RAISE fnd_api.g_exc_unexpected_error;
3742: END insert_mo_lines_bulk;
3743:
3744: END inv_trolin_util;