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.5 2010/11/18 08:55:29 kbavadek ship $ */
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.5 2010/11/18 08:55:29 kbavadek ship $ */
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 131: oe_debug_pub.add( 'ENTERING OE_VALIDATE_LOT_SERIAL.ENTITY' , 1 ) ;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

370: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_serial_number_control_code = ' || l_serial_number_control_code, 1 ) ;
371: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_secondary_default_ind = ' || l_secondary_default_ind, 1 ) ;
372: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_lot_ctl = ' || l_lot_ctl, 1 ) ;
373: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_ship_from_org_id = ' || l_ship_from_org_id, 1 ) ;
374: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_inventory_item_id = ' || l_inventory_item_id, 1 ) ;
375: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - p_Lot_Serial_rec.lot_number, = ' || p_Lot_Serial_rec.lot_number, 1 ) ;
376: END IF;
377:
378:

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

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

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

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

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

553: l_return_status := FND_API.G_RET_STS_ERROR;
554: END IF;
555:
556: IF l_debug_level > 0 THEN
557: oe_debug_pub.add( 'OE_VALIDATE_LOT_SERIAL.ENTITY - validating QUANTITY2 negative ...' ) ;
558: END IF;
559: /* If quantity2 is present and negative, then error */
560:
561: IF nvl(p_lot_serial_rec.quantity2, 0) < 0 then

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

576: IF l_secondary_default_ind = 'N' then
577: --IF l_dualum_ind = 3 then
578:
579: IF l_debug_level > 0 THEN
580: oe_debug_pub.add( 'OE_Validate_Lot_Serial.entity - validating No default dual QUANTITYs...' ) ;
581: END IF;
582: IF (NVL(p_Lot_Serial_rec.quantity2,0) = 0 )
583: OR (NVL(p_Lot_Serial_rec.quantity,0 ) = 0 ) THEN
584: FND_MESSAGE.SET_NAME('ONT','OE_BULK_OPM_NULL_QTY');

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

605: l_lot_number := p_Lot_Serial_rec.LOT_NUMBER; -- 4260166 INVCONV
606:
607:
608: IF l_debug_level > 0 THEN
609: oe_debug_pub.add( 'OE_Validate_Lot_Serial.entity - tolerance check for type Default and No Default ..' ) ;
610: END IF;
611:
612: /* IF l_lot_ctl = 2 -- INVCONV PAL bug fix for lot number -- 4260166
613: and ( p_Lot_Serial_rec.lot_number <> FND_API.G_MISS_CHAR

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

682:
683: IF l_return = 0
684: then
685: IF l_debug_level > 0 THEN
686: oe_debug_pub.add('OE_Validate_Lot_Serial.entity - tolerance error 1' ,1);
687: END IF;
688:
689: l_buffer := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, -- INVCONV
690: p_encoded => 'F');

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

695: RAISE TOLERANCE_ERROR ;
696:
697: else
698: IF l_debug_level > 0 THEN
699: oe_debug_pub.add('OE_Validate_Lot_Serial.entity - No tolerance error so return ',1);
700: END IF;
701: x_return_status := 0;
702: -- RETURN; INVCONV bug 4099604
703: END IF; -- IF l_return = 0

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

729:
730: END IF; */
731:
732: IF l_debug_level > 0 THEN
733: oe_debug_pub.add( 'OE_Validate_Lot_Serial.entity - after tolerance check for type Default and No default. l_return = ' || l_return ) ;
734: END IF;
735:
736:
737: END IF; -- IF l_secondary_default_ind in ('N','D') invconv IF l_dualum_ind in (2,3) then

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

744: -- Done validating entity
745:
746: x_return_status := l_return_status;
747: IF l_debug_level > 0 THEN
748: oe_debug_pub.add( 'EXITING OE_VALIDATE_LOT_SERIAL.ENTITY return status = ' || x_return_status , 1 ) ;
749: END IF;
750:
751: EXCEPTION
752:

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

758:
759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
760:
761: WHEN TOLERANCE_ERROR THEN -- INVCONV
762: oe_debug_pub.add('Exception handling: TOLERANCE_ERROR in OE_VALIDATE_LOT_SERIAL.ENTITY', 1);
763: x_return_status := -1;
764:
765: WHEN OTHERS THEN
766:

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

773: , 'Entity'
774: );
775: END IF;
776: IF l_debug_level > 0 THEN
777: oe_debug_pub.add( 'EXITING OE_VALIDATE_LOT_SERIAL.ENTITY return status = ' || x_return_status , 1 ) ;
778: END IF;
779: END Entity;
780:
781: -- Procedure Attributes

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

793: --
794: BEGIN
795:
796: IF l_debug_level > 0 THEN
797: oe_debug_pub.add( 'ENTERING OE_VALIDATE_LOT_SERIAL.ATTRIBUTES' , 1 ) ;
798: END IF;
799: x_return_status := FND_API.G_RET_STS_SUCCESS;
800:
801: -- Validate Lot_Serial attributes

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

804: ( p_Lot_Serial_rec.created_by <>
805: p_old_Lot_Serial_rec.created_by OR
806: p_old_Lot_Serial_rec.created_by IS NULL )
807: THEN
808: IF NOT OE_Validate.Created_By(p_Lot_Serial_rec.created_by) THEN
809: x_return_status := FND_API.G_RET_STS_ERROR;
810: END IF;
811: END IF;
812:

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

814: ( p_Lot_Serial_rec.creation_date <>
815: p_old_Lot_Serial_rec.creation_date OR
816: p_old_Lot_Serial_rec.creation_date IS NULL )
817: THEN
818: IF NOT OE_Validate.Creation_Date(p_Lot_Serial_rec.creation_date) THEN
819: x_return_status := FND_API.G_RET_STS_ERROR;
820: END IF;
821: END IF;
822:

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

824: ( p_Lot_Serial_rec.from_serial_number <>
825: p_old_Lot_Serial_rec.from_serial_number OR
826: p_old_Lot_Serial_rec.from_serial_number IS NULL )
827: THEN
828: IF NOT OE_Validate.From_Serial_Number(p_Lot_Serial_rec.from_serial_number) THEN
829: x_return_status := FND_API.G_RET_STS_ERROR;
830: END IF;
831: END IF;
832:

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

834: ( p_Lot_Serial_rec.last_updated_by <>
835: p_old_Lot_Serial_rec.last_updated_by OR
836: p_old_Lot_Serial_rec.last_updated_by IS NULL )
837: THEN
838: IF NOT OE_Validate.Last_Updated_By(p_Lot_Serial_rec.last_updated_by) THEN
839: x_return_status := FND_API.G_RET_STS_ERROR;
840: END IF;
841: END IF;
842:

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

844: ( p_Lot_Serial_rec.last_update_date <>
845: p_old_Lot_Serial_rec.last_update_date OR
846: p_old_Lot_Serial_rec.last_update_date IS NULL )
847: THEN
848: IF NOT OE_Validate.Last_Update_Date(p_Lot_Serial_rec.last_update_date) THEN
849: x_return_status := FND_API.G_RET_STS_ERROR;
850: END IF;
851: END IF;
852:

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

854: ( p_Lot_Serial_rec.last_update_login <>
855: p_old_Lot_Serial_rec.last_update_login OR
856: p_old_Lot_Serial_rec.last_update_login IS NULL )
857: THEN
858: IF NOT OE_Validate.Last_Update_Login(p_Lot_Serial_rec.last_update_login) THEN
859: x_return_status := FND_API.G_RET_STS_ERROR;
860: END IF;
861: END IF;
862:

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

864: ( p_Lot_Serial_rec.line_id <>
865: p_old_Lot_Serial_rec.line_id OR
866: p_old_Lot_Serial_rec.line_id IS NULL )
867: THEN
868: IF NOT OE_Validate.Line(p_Lot_Serial_rec.line_id) THEN
869: x_return_status := FND_API.G_RET_STS_ERROR;
870: END IF;
871: END IF;
872:

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

874: ( p_Lot_Serial_rec.line_set_id <>
875: p_old_Lot_Serial_rec.line_set_id OR
876: p_old_Lot_Serial_rec.line_set_id IS NULL )
877: THEN
878: IF NOT OE_Validate.Line_Set(p_Lot_Serial_rec.line_set_id) THEN
879: x_return_status := FND_API.G_RET_STS_ERROR;
880: END IF;
881: END IF;
882:

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

884: ( p_Lot_Serial_rec.lot_number <>
885: p_old_Lot_Serial_rec.lot_number OR
886: p_old_Lot_Serial_rec.lot_number IS NULL )
887: THEN
888: IF NOT OE_Validate.Lot_Number(p_Lot_Serial_rec.lot_number) THEN
889: x_return_status := FND_API.G_RET_STS_ERROR;
890: END IF;
891: END IF;
892:

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

897: ( p_Lot_Serial_rec.sublot_number <>
898: p_old_Lot_Serial_rec.sublot_number OR
899: p_old_Lot_Serial_rec.sublot_number IS NULL )
900: THEN
901: IF NOT OE_Validate.Sublot_Number(p_Lot_Serial_rec.sublot_number) THEN
902: x_return_status := FND_API.G_RET_STS_ERROR;
903: END IF;
904: END IF;
905:

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

909: ( p_Lot_Serial_rec.lot_serial_id <>
910: p_old_Lot_Serial_rec.lot_serial_id OR
911: p_old_Lot_Serial_rec.lot_serial_id IS NULL )
912: THEN
913: IF NOT OE_Validate.Lot_Serial(p_Lot_Serial_rec.lot_serial_id) THEN
914: x_return_status := FND_API.G_RET_STS_ERROR;
915: END IF;
916: END IF;
917:

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

919: ( p_Lot_Serial_rec.quantity <>
920: p_old_Lot_Serial_rec.quantity OR
921: p_old_Lot_Serial_rec.quantity IS NULL )
922: THEN
923: IF NOT OE_Validate.Quantity(p_Lot_Serial_rec.quantity) THEN
924: x_return_status := FND_API.G_RET_STS_ERROR;
925: END IF;
926: END IF;
927:

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

932: p_old_Lot_Serial_rec.quantity2 OR
933: p_old_Lot_Serial_rec.quantity2 IS NULL )
934: THEN
935:
936: IF NOT OE_Validate.Quantity2(p_Lot_Serial_rec.quantity2) THEN
937: x_return_status := FND_API.G_RET_STS_ERROR;
938: END IF;
939: END IF;
940:

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

944: ( p_Lot_Serial_rec.to_serial_number <>
945: p_old_Lot_Serial_rec.to_serial_number OR
946: p_old_Lot_Serial_rec.to_serial_number IS NULL )
947: THEN
948: IF NOT OE_Validate.To_Serial_Number(p_Lot_Serial_rec.to_serial_number) THEN
949: x_return_status := FND_API.G_RET_STS_ERROR;
950: END IF;
951: END IF;
952:

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

1086:
1087:
1088: -- Validate descriptive flexfield.
1089:
1090: IF NOT OE_Validate.Desc_Flex( 'LOT_SERIAL' ) THEN
1091: x_return_status := FND_API.G_RET_STS_ERROR;
1092: END IF;
1093: */
1094: NULL;

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

1095: END IF;
1096:
1097: -- Done validating attributes
1098: IF l_debug_level > 0 THEN
1099: oe_debug_pub.add( 'EXITING OE_VALIDATE_LOT_SERIAL.ATTRIBUTES' , 1 ) ;
1100: END IF;
1101:
1102: EXCEPTION
1103:

Line 1208: END OE_Validate_Lot_Serial;

1204:
1205: END Validate_Lock_Serial_Quantity;
1206:
1207:
1208: END OE_Validate_Lot_Serial;