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

APPS.OE_VALIDATE_LOT_SERIAL dependencies on OE_VALIDATE

Line 1: PACKAGE BODY OE_Validate_Lot_Serial AS

1: PACKAGE BODY OE_Validate_Lot_Serial AS
2: /* $Header: OEXLSRLB.pls 120.2 2006/06/21 22:21:05 mchavan noship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Validate_Lot_Serial';

2: /* $Header: OEXLSRLB.pls 120.2 2006/06/21 22:21:05 mchavan noship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Validate_Lot_Serial';
7:
8: -- Procedure Entity
9:
10: PROCEDURE Entity

Line 128: oe_debug_pub.add( 'ENTERING OE_VALIDATE_LOT_SERIAL.ENTITY' , 1 ) ;

124: --
125: BEGIN
126:
127: IF l_debug_level > 0 THEN
128: oe_debug_pub.add( 'ENTERING OE_VALIDATE_LOT_SERIAL.ENTITY' , 1 ) ;
129: END IF;
130: -- Check required attributes.
131:
132: IF p_Lot_Serial_rec.lot_serial_id IS NULL

Line 287: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY 2' , 1 ) ;

283: l_return_status := FND_API.G_RET_STS_ERROR;
284: FND_MESSAGE.Set_Name('ONT','OE_NOT_KNOW_QUANTITY');
285: OE_MSG_PUB.Add;
286: IF l_debug_level > 0 THEN
287: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY 2' , 1 ) ;
288: END IF;
289: ELSE
290: IF p_Lot_Serial_rec.quantity <> x_quantity THEN
291: l_return_status := FND_API.G_RET_STS_ERROR;

Line 295: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY 3' , 1 ) ;

291: l_return_status := FND_API.G_RET_STS_ERROR;
292: FND_MESSAGE.Set_Name('ONT','OE_QUANTITY_MISMATCH');
293: OE_MSG_PUB.Add;
294: IF l_debug_level > 0 THEN
295: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY 3' , 1 ) ;
296: END IF;
297: END IF;
298: END IF;
299:

Line 363: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_secondary_uom_code = ' || l_secondary_uom_code, 1 ) ;

359:
360: Close c_item;
361:
362: IF l_debug_level > 0 THEN
363: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_secondary_uom_code = ' || l_secondary_uom_code, 1 ) ;
364: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_tracking_quantity_ind = ' || l_tracking_quantity_ind , 1 ) ;
365: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_RMA_LOT_RESTRICT = ' || l_RMA_LOT_RESTRICT, 1 ) ;
366: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_serial_number_control_code = ' || l_serial_number_control_code, 1 ) ;
367: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_secondary_default_ind = ' || l_secondary_default_ind, 1 ) ;

Line 364: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_tracking_quantity_ind = ' || l_tracking_quantity_ind , 1 ) ;

360: Close c_item;
361:
362: IF l_debug_level > 0 THEN
363: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_secondary_uom_code = ' || l_secondary_uom_code, 1 ) ;
364: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_tracking_quantity_ind = ' || l_tracking_quantity_ind , 1 ) ;
365: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_RMA_LOT_RESTRICT = ' || l_RMA_LOT_RESTRICT, 1 ) ;
366: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_serial_number_control_code = ' || l_serial_number_control_code, 1 ) ;
367: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_secondary_default_ind = ' || l_secondary_default_ind, 1 ) ;
368: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_lot_ctl = ' || l_lot_ctl, 1 ) ;

Line 365: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_RMA_LOT_RESTRICT = ' || l_RMA_LOT_RESTRICT, 1 ) ;

361:
362: IF l_debug_level > 0 THEN
363: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_secondary_uom_code = ' || l_secondary_uom_code, 1 ) ;
364: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_tracking_quantity_ind = ' || l_tracking_quantity_ind , 1 ) ;
365: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_RMA_LOT_RESTRICT = ' || l_RMA_LOT_RESTRICT, 1 ) ;
366: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_serial_number_control_code = ' || l_serial_number_control_code, 1 ) ;
367: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_secondary_default_ind = ' || l_secondary_default_ind, 1 ) ;
368: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_lot_ctl = ' || l_lot_ctl, 1 ) ;
369: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_ship_from_org_id = ' || l_ship_from_org_id, 1 ) ;

Line 366: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_serial_number_control_code = ' || l_serial_number_control_code, 1 ) ;

362: IF l_debug_level > 0 THEN
363: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_secondary_uom_code = ' || l_secondary_uom_code, 1 ) ;
364: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_tracking_quantity_ind = ' || l_tracking_quantity_ind , 1 ) ;
365: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_RMA_LOT_RESTRICT = ' || l_RMA_LOT_RESTRICT, 1 ) ;
366: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_serial_number_control_code = ' || l_serial_number_control_code, 1 ) ;
367: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_secondary_default_ind = ' || l_secondary_default_ind, 1 ) ;
368: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_lot_ctl = ' || l_lot_ctl, 1 ) ;
369: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_ship_from_org_id = ' || l_ship_from_org_id, 1 ) ;
370: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_inventory_item_id = ' || l_inventory_item_id, 1 ) ;

Line 367: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_secondary_default_ind = ' || l_secondary_default_ind, 1 ) ;

363: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_secondary_uom_code = ' || l_secondary_uom_code, 1 ) ;
364: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_tracking_quantity_ind = ' || l_tracking_quantity_ind , 1 ) ;
365: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_RMA_LOT_RESTRICT = ' || l_RMA_LOT_RESTRICT, 1 ) ;
366: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_serial_number_control_code = ' || l_serial_number_control_code, 1 ) ;
367: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_secondary_default_ind = ' || l_secondary_default_ind, 1 ) ;
368: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_lot_ctl = ' || l_lot_ctl, 1 ) ;
369: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_ship_from_org_id = ' || l_ship_from_org_id, 1 ) ;
370: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_inventory_item_id = ' || l_inventory_item_id, 1 ) ;
371: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - p_Lot_Serial_rec.lot_number, = ' || p_Lot_Serial_rec.lot_number, 1 ) ;

Line 368: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_lot_ctl = ' || l_lot_ctl, 1 ) ;

364: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_tracking_quantity_ind = ' || l_tracking_quantity_ind , 1 ) ;
365: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_RMA_LOT_RESTRICT = ' || l_RMA_LOT_RESTRICT, 1 ) ;
366: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_serial_number_control_code = ' || l_serial_number_control_code, 1 ) ;
367: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_secondary_default_ind = ' || l_secondary_default_ind, 1 ) ;
368: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_lot_ctl = ' || l_lot_ctl, 1 ) ;
369: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_ship_from_org_id = ' || l_ship_from_org_id, 1 ) ;
370: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_inventory_item_id = ' || l_inventory_item_id, 1 ) ;
371: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - p_Lot_Serial_rec.lot_number, = ' || p_Lot_Serial_rec.lot_number, 1 ) ;
372: END IF;

Line 369: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_ship_from_org_id = ' || l_ship_from_org_id, 1 ) ;

365: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_RMA_LOT_RESTRICT = ' || l_RMA_LOT_RESTRICT, 1 ) ;
366: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_serial_number_control_code = ' || l_serial_number_control_code, 1 ) ;
367: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_secondary_default_ind = ' || l_secondary_default_ind, 1 ) ;
368: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_lot_ctl = ' || l_lot_ctl, 1 ) ;
369: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_ship_from_org_id = ' || l_ship_from_org_id, 1 ) ;
370: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_inventory_item_id = ' || l_inventory_item_id, 1 ) ;
371: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - p_Lot_Serial_rec.lot_number, = ' || p_Lot_Serial_rec.lot_number, 1 ) ;
372: END IF;
373:

Line 370: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_inventory_item_id = ' || l_inventory_item_id, 1 ) ;

366: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_serial_number_control_code = ' || l_serial_number_control_code, 1 ) ;
367: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_secondary_default_ind = ' || l_secondary_default_ind, 1 ) ;
368: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_lot_ctl = ' || l_lot_ctl, 1 ) ;
369: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_ship_from_org_id = ' || l_ship_from_org_id, 1 ) ;
370: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_inventory_item_id = ' || l_inventory_item_id, 1 ) ;
371: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - p_Lot_Serial_rec.lot_number, = ' || p_Lot_Serial_rec.lot_number, 1 ) ;
372: END IF;
373:
374:

Line 371: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - p_Lot_Serial_rec.lot_number, = ' || p_Lot_Serial_rec.lot_number, 1 ) ;

367: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_secondary_default_ind = ' || l_secondary_default_ind, 1 ) ;
368: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_lot_ctl = ' || l_lot_ctl, 1 ) ;
369: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_ship_from_org_id = ' || l_ship_from_org_id, 1 ) ;
370: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_inventory_item_id = ' || l_inventory_item_id, 1 ) ;
371: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - p_Lot_Serial_rec.lot_number, = ' || p_Lot_Serial_rec.lot_number, 1 ) ;
372: END IF;
373:
374:
375: /*IF oe_line_util.Process_Characteristics INVCONV

Line 534: oe_debug_pub.add( 'OE_VALIDATE_LOT_SERIAL.ENTITY - validating QUANTITY2...' ) ;

530:
531: -- validate quantity2
532: -- added from pre process
533: IF l_debug_level > 0 THEN
534: oe_debug_pub.add( 'OE_VALIDATE_LOT_SERIAL.ENTITY - validating QUANTITY2...' ) ;
535: END IF;
536: IF l_tracking_quantity_ind = 'P' and -- INVCONV l_dualum_ind < 1 and
537: ( p_lot_serial_rec.quantity2 <> FND_API.G_MISS_NUM
538: and p_lot_serial_rec.quantity2 IS NOT NULL ) then

Line 551: oe_debug_pub.add( 'OE_VALIDATE_LOT_SERIAL.ENTITY - validating QUANTITY2 negative ...' ) ;

547: l_return_status := FND_API.G_RET_STS_ERROR;
548: END IF;
549:
550: IF l_debug_level > 0 THEN
551: oe_debug_pub.add( 'OE_VALIDATE_LOT_SERIAL.ENTITY - validating QUANTITY2 negative ...' ) ;
552: END IF;
553: /* If quantity2 is present and negative, then error */
554:
555: IF nvl(p_lot_serial_rec.quantity2, 0) < 0 then

Line 574: oe_debug_pub.add( 'OE_Validate_Lot_Serial.entity - validating No default dual QUANTITYs...' ) ;

570: IF l_secondary_default_ind = 'N' then
571: --IF l_dualum_ind = 3 then
572:
573: IF l_debug_level > 0 THEN
574: oe_debug_pub.add( 'OE_Validate_Lot_Serial.entity - validating No default dual QUANTITYs...' ) ;
575: END IF;
576: IF (NVL(p_Lot_Serial_rec.quantity2,0) = 0 )
577: OR (NVL(p_Lot_Serial_rec.quantity,0 ) = 0 ) THEN
578: FND_MESSAGE.SET_NAME('ONT','OE_BULK_OPM_NULL_QTY');

Line 603: oe_debug_pub.add( 'OE_Validate_Lot_Serial.entity - tolerance check for type Default and No Default ..' ) ;

599: l_lot_number := p_Lot_Serial_rec.LOT_NUMBER; -- 4260166 INVCONV
600:
601:
602: IF l_debug_level > 0 THEN
603: oe_debug_pub.add( 'OE_Validate_Lot_Serial.entity - tolerance check for type Default and No Default ..' ) ;
604: END IF;
605:
606: /* IF l_lot_ctl = 2 -- INVCONV PAL bug fix for lot number -- 4260166
607: and ( p_Lot_Serial_rec.lot_number <> FND_API.G_MISS_CHAR

Line 680: oe_debug_pub.add('OE_Validate_Lot_Serial.entity - tolerance error 1' ,1);

676:
677: IF l_return = 0
678: then
679: IF l_debug_level > 0 THEN
680: oe_debug_pub.add('OE_Validate_Lot_Serial.entity - tolerance error 1' ,1);
681: END IF;
682:
683: l_buffer := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, -- INVCONV
684: p_encoded => 'F');

Line 693: oe_debug_pub.add('OE_Validate_Lot_Serial.entity - No tolerance error so return ',1);

689: RAISE TOLERANCE_ERROR ;
690:
691: else
692: IF l_debug_level > 0 THEN
693: oe_debug_pub.add('OE_Validate_Lot_Serial.entity - No tolerance error so return ',1);
694: END IF;
695: x_return_status := 0;
696: -- RETURN; INVCONV bug 4099604
697: END IF; -- IF l_return = 0

Line 727: oe_debug_pub.add( 'OE_Validate_Lot_Serial.entity - after tolerance check for type Default and No default. l_return = ' || l_return ) ;

723:
724: END IF; */
725:
726: IF l_debug_level > 0 THEN
727: oe_debug_pub.add( 'OE_Validate_Lot_Serial.entity - after tolerance check for type Default and No default. l_return = ' || l_return ) ;
728: END IF;
729:
730:
731: END IF; -- IF l_secondary_default_ind in ('N','D') invconv IF l_dualum_ind in (2,3) then

Line 742: oe_debug_pub.add( 'EXITING OE_VALIDATE_LOT_SERIAL.ENTITY return status = ' || x_return_status , 1 ) ;

738: -- Done validating entity
739:
740: x_return_status := l_return_status;
741: IF l_debug_level > 0 THEN
742: oe_debug_pub.add( 'EXITING OE_VALIDATE_LOT_SERIAL.ENTITY return status = ' || x_return_status , 1 ) ;
743: END IF;
744:
745: EXCEPTION
746:

Line 756: oe_debug_pub.add('Exception handling: TOLERANCE_ERROR in OE_VALIDATE_LOT_SERIAL.ENTITY', 1);

752:
753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
754:
755: WHEN TOLERANCE_ERROR THEN -- INVCONV
756: oe_debug_pub.add('Exception handling: TOLERANCE_ERROR in OE_VALIDATE_LOT_SERIAL.ENTITY', 1);
757: x_return_status := -1;
758:
759: WHEN OTHERS THEN
760:

Line 771: oe_debug_pub.add( 'EXITING OE_VALIDATE_LOT_SERIAL.ENTITY return status = ' || x_return_status , 1 ) ;

767: , 'Entity'
768: );
769: END IF;
770: IF l_debug_level > 0 THEN
771: oe_debug_pub.add( 'EXITING OE_VALIDATE_LOT_SERIAL.ENTITY return status = ' || x_return_status , 1 ) ;
772: END IF;
773: END Entity;
774:
775: -- Procedure Attributes

Line 791: oe_debug_pub.add( 'ENTERING OE_VALIDATE_LOT_SERIAL.ATTRIBUTES' , 1 ) ;

787: --
788: BEGIN
789:
790: IF l_debug_level > 0 THEN
791: oe_debug_pub.add( 'ENTERING OE_VALIDATE_LOT_SERIAL.ATTRIBUTES' , 1 ) ;
792: END IF;
793: x_return_status := FND_API.G_RET_STS_SUCCESS;
794:
795: -- Validate Lot_Serial attributes

Line 802: IF NOT OE_Validate.Created_By(p_Lot_Serial_rec.created_by) THEN

798: ( p_Lot_Serial_rec.created_by <>
799: p_old_Lot_Serial_rec.created_by OR
800: p_old_Lot_Serial_rec.created_by IS NULL )
801: THEN
802: IF NOT OE_Validate.Created_By(p_Lot_Serial_rec.created_by) THEN
803: x_return_status := FND_API.G_RET_STS_ERROR;
804: END IF;
805: END IF;
806:

Line 812: IF NOT OE_Validate.Creation_Date(p_Lot_Serial_rec.creation_date) THEN

808: ( p_Lot_Serial_rec.creation_date <>
809: p_old_Lot_Serial_rec.creation_date OR
810: p_old_Lot_Serial_rec.creation_date IS NULL )
811: THEN
812: IF NOT OE_Validate.Creation_Date(p_Lot_Serial_rec.creation_date) THEN
813: x_return_status := FND_API.G_RET_STS_ERROR;
814: END IF;
815: END IF;
816:

Line 822: IF NOT OE_Validate.From_Serial_Number(p_Lot_Serial_rec.from_serial_number) THEN

818: ( p_Lot_Serial_rec.from_serial_number <>
819: p_old_Lot_Serial_rec.from_serial_number OR
820: p_old_Lot_Serial_rec.from_serial_number IS NULL )
821: THEN
822: IF NOT OE_Validate.From_Serial_Number(p_Lot_Serial_rec.from_serial_number) THEN
823: x_return_status := FND_API.G_RET_STS_ERROR;
824: END IF;
825: END IF;
826:

Line 832: IF NOT OE_Validate.Last_Updated_By(p_Lot_Serial_rec.last_updated_by) THEN

828: ( p_Lot_Serial_rec.last_updated_by <>
829: p_old_Lot_Serial_rec.last_updated_by OR
830: p_old_Lot_Serial_rec.last_updated_by IS NULL )
831: THEN
832: IF NOT OE_Validate.Last_Updated_By(p_Lot_Serial_rec.last_updated_by) THEN
833: x_return_status := FND_API.G_RET_STS_ERROR;
834: END IF;
835: END IF;
836:

Line 842: IF NOT OE_Validate.Last_Update_Date(p_Lot_Serial_rec.last_update_date) THEN

838: ( p_Lot_Serial_rec.last_update_date <>
839: p_old_Lot_Serial_rec.last_update_date OR
840: p_old_Lot_Serial_rec.last_update_date IS NULL )
841: THEN
842: IF NOT OE_Validate.Last_Update_Date(p_Lot_Serial_rec.last_update_date) THEN
843: x_return_status := FND_API.G_RET_STS_ERROR;
844: END IF;
845: END IF;
846:

Line 852: IF NOT OE_Validate.Last_Update_Login(p_Lot_Serial_rec.last_update_login) THEN

848: ( p_Lot_Serial_rec.last_update_login <>
849: p_old_Lot_Serial_rec.last_update_login OR
850: p_old_Lot_Serial_rec.last_update_login IS NULL )
851: THEN
852: IF NOT OE_Validate.Last_Update_Login(p_Lot_Serial_rec.last_update_login) THEN
853: x_return_status := FND_API.G_RET_STS_ERROR;
854: END IF;
855: END IF;
856:

Line 862: IF NOT OE_Validate.Line(p_Lot_Serial_rec.line_id) THEN

858: ( p_Lot_Serial_rec.line_id <>
859: p_old_Lot_Serial_rec.line_id OR
860: p_old_Lot_Serial_rec.line_id IS NULL )
861: THEN
862: IF NOT OE_Validate.Line(p_Lot_Serial_rec.line_id) THEN
863: x_return_status := FND_API.G_RET_STS_ERROR;
864: END IF;
865: END IF;
866:

Line 872: IF NOT OE_Validate.Line_Set(p_Lot_Serial_rec.line_set_id) THEN

868: ( p_Lot_Serial_rec.line_set_id <>
869: p_old_Lot_Serial_rec.line_set_id OR
870: p_old_Lot_Serial_rec.line_set_id IS NULL )
871: THEN
872: IF NOT OE_Validate.Line_Set(p_Lot_Serial_rec.line_set_id) THEN
873: x_return_status := FND_API.G_RET_STS_ERROR;
874: END IF;
875: END IF;
876:

Line 882: IF NOT OE_Validate.Lot_Number(p_Lot_Serial_rec.lot_number) THEN

878: ( p_Lot_Serial_rec.lot_number <>
879: p_old_Lot_Serial_rec.lot_number OR
880: p_old_Lot_Serial_rec.lot_number IS NULL )
881: THEN
882: IF NOT OE_Validate.Lot_Number(p_Lot_Serial_rec.lot_number) THEN
883: x_return_status := FND_API.G_RET_STS_ERROR;
884: END IF;
885: END IF;
886:

Line 895: IF NOT OE_Validate.Sublot_Number(p_Lot_Serial_rec.sublot_number) THEN

891: ( p_Lot_Serial_rec.sublot_number <>
892: p_old_Lot_Serial_rec.sublot_number OR
893: p_old_Lot_Serial_rec.sublot_number IS NULL )
894: THEN
895: IF NOT OE_Validate.Sublot_Number(p_Lot_Serial_rec.sublot_number) THEN
896: x_return_status := FND_API.G_RET_STS_ERROR;
897: END IF;
898: END IF;
899:

Line 907: IF NOT OE_Validate.Lot_Serial(p_Lot_Serial_rec.lot_serial_id) THEN

903: ( p_Lot_Serial_rec.lot_serial_id <>
904: p_old_Lot_Serial_rec.lot_serial_id OR
905: p_old_Lot_Serial_rec.lot_serial_id IS NULL )
906: THEN
907: IF NOT OE_Validate.Lot_Serial(p_Lot_Serial_rec.lot_serial_id) THEN
908: x_return_status := FND_API.G_RET_STS_ERROR;
909: END IF;
910: END IF;
911:

Line 917: IF NOT OE_Validate.Quantity(p_Lot_Serial_rec.quantity) THEN

913: ( p_Lot_Serial_rec.quantity <>
914: p_old_Lot_Serial_rec.quantity OR
915: p_old_Lot_Serial_rec.quantity IS NULL )
916: THEN
917: IF NOT OE_Validate.Quantity(p_Lot_Serial_rec.quantity) THEN
918: x_return_status := FND_API.G_RET_STS_ERROR;
919: END IF;
920: END IF;
921:

Line 930: IF NOT OE_Validate.Quantity2(p_Lot_Serial_rec.quantity2) THEN

926: p_old_Lot_Serial_rec.quantity2 OR
927: p_old_Lot_Serial_rec.quantity2 IS NULL )
928: THEN
929:
930: IF NOT OE_Validate.Quantity2(p_Lot_Serial_rec.quantity2) THEN
931: x_return_status := FND_API.G_RET_STS_ERROR;
932: END IF;
933: END IF;
934:

Line 942: IF NOT OE_Validate.To_Serial_Number(p_Lot_Serial_rec.to_serial_number) THEN

938: ( p_Lot_Serial_rec.to_serial_number <>
939: p_old_Lot_Serial_rec.to_serial_number OR
940: p_old_Lot_Serial_rec.to_serial_number IS NULL )
941: THEN
942: IF NOT OE_Validate.To_Serial_Number(p_Lot_Serial_rec.to_serial_number) THEN
943: x_return_status := FND_API.G_RET_STS_ERROR;
944: END IF;
945: END IF;
946:

Line 1084: IF NOT OE_Validate.Desc_Flex( 'LOT_SERIAL' ) THEN

1080:
1081:
1082: -- Validate descriptive flexfield.
1083:
1084: IF NOT OE_Validate.Desc_Flex( 'LOT_SERIAL' ) THEN
1085: x_return_status := FND_API.G_RET_STS_ERROR;
1086: END IF;
1087: */
1088: NULL;

Line 1093: oe_debug_pub.add( 'EXITING OE_VALIDATE_LOT_SERIAL.ATTRIBUTES' , 1 ) ;

1089: END IF;
1090:
1091: -- Done validating attributes
1092: IF l_debug_level > 0 THEN
1093: oe_debug_pub.add( 'EXITING OE_VALIDATE_LOT_SERIAL.ATTRIBUTES' , 1 ) ;
1094: END IF;
1095:
1096: EXCEPTION
1097:

Line 1202: END OE_Validate_Lot_Serial;

1198:
1199: END Validate_Lock_Serial_Quantity;
1200:
1201:
1202: END OE_Validate_Lot_Serial;