343:
344: -- received quantity should be within tolerance
345: IF (l_updated_quantity >
346: l_line_tbl(1).ordered_quantity + l_tolerance_above) THEN
347: FND_MESSAGE.Set_Name('ONT', 'OE_RETURN_INVALID_RCVD_QTY');
348: OE_MSG_PUB.Add;
349: x_return_status := FND_API.G_RET_STS_ERROR ;
350: RAISE FND_API.G_EXC_ERROR;
351: END IF;
448: END IF;
449:
450: -- over quantity being passed
451: IF (l_line_tbl(1).shipped_quantity < l_updated_quantity ) THEN
452: FND_MESSAGE.Set_Name('ONT', 'OE_RETURN_INVALID_DLVR_QTY');
453: OE_MSG_PUB.Add;
454: x_return_status := FND_API.G_RET_STS_ERROR ;
455: RAISE FND_API.G_EXC_ERROR;
456: END IF;
559: END IF;
560: IF l_open_line_id is NOT NULL THEN
561: l_line_number := l_temp_open_line_rec.line_number||'.'||
562: l_temp_open_line_rec.shipment_number;
563: FND_MESSAGE.Set_Name('ONT', 'OE_RECEIVE_ON_OPEN_LINE');
564: FND_MESSAGE.Set_Token('LINENUMBER', l_line_number);
565: ELSE
566: IF l_max_qty_to_adjust > 0 THEN
567: FND_MESSAGE.Set_Name('ONT', 'OE_MAX_CORRECTION_QTY');
560: IF l_open_line_id is NOT NULL THEN
561: l_line_number := l_temp_open_line_rec.line_number||'.'||
562: l_temp_open_line_rec.shipment_number;
563: FND_MESSAGE.Set_Name('ONT', 'OE_RECEIVE_ON_OPEN_LINE');
564: FND_MESSAGE.Set_Token('LINENUMBER', l_line_number);
565: ELSE
566: IF l_max_qty_to_adjust > 0 THEN
567: FND_MESSAGE.Set_Name('ONT', 'OE_MAX_CORRECTION_QTY');
568: FND_MESSAGE.Set_Token('CORRECTIONQTY',
563: FND_MESSAGE.Set_Name('ONT', 'OE_RECEIVE_ON_OPEN_LINE');
564: FND_MESSAGE.Set_Token('LINENUMBER', l_line_number);
565: ELSE
566: IF l_max_qty_to_adjust > 0 THEN
567: FND_MESSAGE.Set_Name('ONT', 'OE_MAX_CORRECTION_QTY');
568: FND_MESSAGE.Set_Token('CORRECTIONQTY',
569: to_char(l_max_qty_to_adjust)||' '||
570: l_line_tbl(1).ORDER_QUANTITY_UOM);
571: ELSE
564: FND_MESSAGE.Set_Token('LINENUMBER', l_line_number);
565: ELSE
566: IF l_max_qty_to_adjust > 0 THEN
567: FND_MESSAGE.Set_Name('ONT', 'OE_MAX_CORRECTION_QTY');
568: FND_MESSAGE.Set_Token('CORRECTIONQTY',
569: to_char(l_max_qty_to_adjust)||' '||
570: l_line_tbl(1).ORDER_QUANTITY_UOM);
571: ELSE
572: FND_MESSAGE.Set_Name('ONT', 'OE_RETURN_INVALID_RCVD_QTY');
568: FND_MESSAGE.Set_Token('CORRECTIONQTY',
569: to_char(l_max_qty_to_adjust)||' '||
570: l_line_tbl(1).ORDER_QUANTITY_UOM);
571: ELSE
572: FND_MESSAGE.Set_Name('ONT', 'OE_RETURN_INVALID_RCVD_QTY');
573: END IF;
574: END IF;
575: OE_MSG_PUB.Add;
576: x_return_status := FND_API.G_RET_STS_ERROR ;
642: l_line_tbl(1).shipped_quantity2 := NULL; -- 04/20/2001 OPM
643: END IF;
644: l_line_tbl(1).flow_status_code := 'AWAITING_RETURN';
645: ELSE
646: FND_MESSAGE.Set_Name('ONT', 'OE_RETURN_INVALID_RCVD_QTY');
647: OE_MSG_PUB.Add;
648: x_return_status := FND_API.G_RET_STS_ERROR ;
649: RAISE FND_API.G_EXC_ERROR;
650: END IF;
703: END IF;
704: l_line_tbl(1).flow_status_code := 'AWAITING_RETURN';
705: ELSE
706: -- Give error that it is a wrong correction
707: FND_MESSAGE.Set_Name('ONT', 'OE_RETURN_INVALID_RCVD_QTY');
708: OE_MSG_PUB.Add;
709: x_return_status := FND_API.G_RET_STS_ERROR ;
710: RAISE FND_API.G_EXC_ERROR;
711: END IF;
738: END IF;
739:
740: -- over quantity being passed
741: IF (l_line_tbl(1).shipped_quantity < l_updated_quantity ) THEN
742: FND_MESSAGE.Set_Name('ONT', 'OE_RETURN_INVALID_DLVR_QTY');
743: OE_MSG_PUB.Add;
744: x_return_status := FND_API.G_RET_STS_ERROR ;
745: RAISE FND_API.G_EXC_ERROR;
746: END IF;
994:
995: -- received quantity should be within tolerance
996: IF (l_updated_quantity >
997: l_line_tbl(1).ordered_quantity + l_tolerance_above) THEN
998: FND_MESSAGE.Set_Name('ONT', 'OE_RETURN_INVALID_RCVD_QTY');
999: OE_MSG_PUB.Add;
1000: x_return_status := FND_API.G_RET_STS_ERROR ;
1001: RAISE FND_API.G_EXC_ERROR;
1002: END IF;