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.INV_VALIDATE_TROLIN dependencies on INV_VALIDATE

Line 1: PACKAGE BODY INV_Validate_Trolin AS

1: PACKAGE BODY INV_Validate_Trolin AS
2: /* $Header: INVLTRLB.pls 120.12.12020000.2 2012/11/27 06:52:00 ppulloor ship $ */
3: -- Global constant holding the package name
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_Validate_Trolin';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_Validate_Trolin';

1: PACKAGE BODY INV_Validate_Trolin AS
2: /* $Header: INVLTRLB.pls 120.12.12020000.2 2012/11/27 06:52:00 ppulloor ship $ */
3: -- Global constant holding the package name
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_Validate_Trolin';
6:
7: g_organization_id NUMBER;
8: g_wms_org_flag BOOLEAN;
9:

Line 32: p_org IN inv_validate_trohdr.ORG ) RETURN NUMBER

28:
29: -- ---------------------------------------------------------------------
30: FUNCTION Line_Number ( p_line_number IN NUMBER,
31: p_header_id IN NUMBER,
32: p_org IN inv_validate_trohdr.ORG ) RETURN NUMBER
33: IS
34: l_dummy VARCHAR2(10);
35: l_return_value BOOLEAN;
36: l_request_number VARCHAR2(30);

Line 592: IF INV_Validate.Transaction_Type(g_transaction_l) = inv_validate.F THEN

588: ( p_trolin_rec.transaction_type_id <> p_old_trolin_rec.transaction_type_id OR
589: p_old_trolin_rec.transaction_type_id IS NULL )
590: THEN
591: g_transaction_l.transaction_type_id := p_trolin_rec.transaction_type_id;
592: IF INV_Validate.Transaction_Type(g_transaction_l) = inv_validate.F THEN
593: x_return_status := FND_API.G_RET_STS_ERROR;
594: END IF;
595: END IF;
596:

Line 605: inv_validate_trohdr.g_org.organization_id := p_trolin_rec.organization_id;

601: p_old_trolin_rec.inventory_item_id OR
602: p_old_trolin_rec.inventory_item_id IS NULL )
603: THEN
604: g_item.inventory_item_id := p_trolin_rec.inventory_item_id;
605: inv_validate_trohdr.g_org.organization_id := p_trolin_rec.organization_id;
606: /* bug9267446 */
607: IF g_transaction_l.transaction_type_id IS NOT NULL THEN
608: IF INV_Validate.Inventory_Item(g_item,inv_validate_trohdr.g_org,g_transaction_l.transaction_type_id) =
609: INV_Validate.F

Line 608: IF INV_Validate.Inventory_Item(g_item,inv_validate_trohdr.g_org,g_transaction_l.transaction_type_id) =

604: g_item.inventory_item_id := p_trolin_rec.inventory_item_id;
605: inv_validate_trohdr.g_org.organization_id := p_trolin_rec.organization_id;
606: /* bug9267446 */
607: IF g_transaction_l.transaction_type_id IS NOT NULL THEN
608: IF INV_Validate.Inventory_Item(g_item,inv_validate_trohdr.g_org,g_transaction_l.transaction_type_id) =
609: INV_Validate.F
610: THEN
611: x_return_status := FND_API.G_RET_STS_ERROR;
612: return;

Line 609: INV_Validate.F

605: inv_validate_trohdr.g_org.organization_id := p_trolin_rec.organization_id;
606: /* bug9267446 */
607: IF g_transaction_l.transaction_type_id IS NOT NULL THEN
608: IF INV_Validate.Inventory_Item(g_item,inv_validate_trohdr.g_org,g_transaction_l.transaction_type_id) =
609: INV_Validate.F
610: THEN
611: x_return_status := FND_API.G_RET_STS_ERROR;
612: return;
613: END IF;

Line 616: IF INV_Validate.Inventory_Item(g_item,inv_validate_trohdr.g_org) =

612: return;
613: END IF;
614: ELSE
615: /* bug9267446 */
616: IF INV_Validate.Inventory_Item(g_item,inv_validate_trohdr.g_org) =
617: --IF INV_Validate.Inventory_Item(g_item,inv_validate_trohdr.g_org) =
618: INV_Validate.F
619: THEN
620: x_return_status := FND_API.G_RET_STS_ERROR;

Line 617: --IF INV_Validate.Inventory_Item(g_item,inv_validate_trohdr.g_org) =

613: END IF;
614: ELSE
615: /* bug9267446 */
616: IF INV_Validate.Inventory_Item(g_item,inv_validate_trohdr.g_org) =
617: --IF INV_Validate.Inventory_Item(g_item,inv_validate_trohdr.g_org) =
618: INV_Validate.F
619: THEN
620: x_return_status := FND_API.G_RET_STS_ERROR;
621: return;

Line 618: INV_Validate.F

614: ELSE
615: /* bug9267446 */
616: IF INV_Validate.Inventory_Item(g_item,inv_validate_trohdr.g_org) =
617: --IF INV_Validate.Inventory_Item(g_item,inv_validate_trohdr.g_org) =
618: INV_Validate.F
619: THEN
620: x_return_status := FND_API.G_RET_STS_ERROR;
621: return;
622: END IF;

Line 627: IF p_trolin_rec.organization_id <> INV_Validate_Trohdr.g_org.organization_id

623: END IF;
624: END IF;
625: --inv_debug.message('ssia', 'TRO: item: ' || x_return_status);
626: -- Bug 15841667 Org validation added after item validation
627: IF p_trolin_rec.organization_id <> INV_Validate_Trohdr.g_org.organization_id
628: THEN
629: x_return_status := FND_API.G_RET_STS_ERROR;
630: return;
631: END IF;

Line 639: IF INV_Validate.Created_By(p_trolin_rec.created_by) = inv_validate.F

635: ( p_trolin_rec.created_by <>
636: p_old_trolin_rec.created_by OR
637: p_old_trolin_rec.created_by IS NULL )
638: THEN
639: IF INV_Validate.Created_By(p_trolin_rec.created_by) = inv_validate.F
640: THEN
641: x_return_status := FND_API.G_RET_STS_ERROR;
642: return;
643: END IF;

Line 655: IF INV_Validate.Creation_Date(p_trolin_rec.creation_date) =

651: ( p_trolin_rec.creation_date <>
652: p_old_trolin_rec.creation_date OR
653: p_old_trolin_rec.creation_date IS NULL )
654: THEN
655: IF INV_Validate.Creation_Date(p_trolin_rec.creation_date) =
656: INV_Validate.F
657: THEN
658: x_return_status := FND_API.G_RET_STS_ERROR;
659: return;

Line 656: INV_Validate.F

652: p_old_trolin_rec.creation_date OR
653: p_old_trolin_rec.creation_date IS NULL )
654: THEN
655: IF INV_Validate.Creation_Date(p_trolin_rec.creation_date) =
656: INV_Validate.F
657: THEN
658: x_return_status := FND_API.G_RET_STS_ERROR;
659: return;
660: END IF;

Line 669: IF INV_Validate_Trohdr.Date_Required(p_trolin_rec.date_required) =

665: ( p_trolin_rec.date_required <>
666: p_old_trolin_rec.date_required OR
667: p_old_trolin_rec.date_required IS NULL )
668: THEN
669: IF INV_Validate_Trohdr.Date_Required(p_trolin_rec.date_required) =
670: INV_Validate.F
671: THEN
672: x_return_status := FND_API.G_RET_STS_ERROR;
673: return;

Line 670: INV_Validate.F

666: p_old_trolin_rec.date_required OR
667: p_old_trolin_rec.date_required IS NULL )
668: THEN
669: IF INV_Validate_Trohdr.Date_Required(p_trolin_rec.date_required) =
670: INV_Validate.F
671: THEN
672: x_return_status := FND_API.G_RET_STS_ERROR;
673: return;
674: END IF;

Line 686: IF inv_validate_trolin.g_transaction_l.transaction_action_id = 2 THEN

682: p_old_trolin_rec.from_subinventory_code IS NULL )
683: THEN
684: g_from_sub.secondary_inventory_name :=
685: p_trolin_rec.from_subinventory_code;
686: IF inv_validate_trolin.g_transaction_l.transaction_action_id = 2 THEN
687: l_acct_txn := 0;
688: ELSE
689: l_acct_txn := 1;
690: END IF;

Line 691: IF INV_Validate.From_Subinventory(g_from_sub,

687: l_acct_txn := 0;
688: ELSE
689: l_acct_txn := 1;
690: END IF;
691: IF INV_Validate.From_Subinventory(g_from_sub,
692: inv_validate_trohdr.g_org,
693: g_item,l_acct_txn ) = INV_Validate.F
694: THEN
695: --inv_Debug.message('ssia', 'error from inv_validate.from_subinventory');

Line 692: inv_validate_trohdr.g_org,

688: ELSE
689: l_acct_txn := 1;
690: END IF;
691: IF INV_Validate.From_Subinventory(g_from_sub,
692: inv_validate_trohdr.g_org,
693: g_item,l_acct_txn ) = INV_Validate.F
694: THEN
695: --inv_Debug.message('ssia', 'error from inv_validate.from_subinventory');
696: x_return_status := FND_API.G_RET_STS_ERROR;

Line 693: g_item,l_acct_txn ) = INV_Validate.F

689: l_acct_txn := 1;
690: END IF;
691: IF INV_Validate.From_Subinventory(g_from_sub,
692: inv_validate_trohdr.g_org,
693: g_item,l_acct_txn ) = INV_Validate.F
694: THEN
695: --inv_Debug.message('ssia', 'error from inv_validate.from_subinventory');
696: x_return_status := FND_API.G_RET_STS_ERROR;
697: return;

Line 695: --inv_Debug.message('ssia', 'error from inv_validate.from_subinventory');

691: IF INV_Validate.From_Subinventory(g_from_sub,
692: inv_validate_trohdr.g_org,
693: g_item,l_acct_txn ) = INV_Validate.F
694: THEN
695: --inv_Debug.message('ssia', 'error from inv_validate.from_subinventory');
696: x_return_status := FND_API.G_RET_STS_ERROR;
697: return;
698: END IF;
699:

Line 741: IF INV_Validate.Project(p_trolin_rec.project_id) = inv_validate.F THEN

737: ( p_trolin_rec.project_id <>
738: p_old_trolin_rec.project_id OR
739: p_old_trolin_rec.project_id IS NULL )
740: THEN
741: IF INV_Validate.Project(p_trolin_rec.project_id) = inv_validate.F THEN
742: x_return_status := FND_API.G_RET_STS_ERROR;
743: return;
744: END IF;
745: END IF;

Line 754: IF INV_Validate.Task(p_trolin_rec.task_id, p_trolin_rec.project_id)

750: ( p_trolin_rec.task_id <>
751: p_old_trolin_rec.task_id OR
752: p_old_trolin_rec.task_id IS NULL )
753: THEN
754: IF INV_Validate.Task(p_trolin_rec.task_id, p_trolin_rec.project_id)
755: = INV_Validate.F THEN
756: x_return_status := FND_API.G_RET_STS_ERROR;
757: return;
758: END IF;

Line 755: = INV_Validate.F THEN

751: p_old_trolin_rec.task_id OR
752: p_old_trolin_rec.task_id IS NULL )
753: THEN
754: IF INV_Validate.Task(p_trolin_rec.task_id, p_trolin_rec.project_id)
755: = INV_Validate.F THEN
756: x_return_status := FND_API.G_RET_STS_ERROR;
757: return;
758: END IF;
759: END IF;

Line 777: passed to 'INV_VALIDATE.FROM_LOCATOR' should be null when the org is non-PJM

773: p_old_trolin_rec.from_locator_id IS NULL )
774: THEN
775: g_from_locator.inventory_location_id := p_trolin_rec.from_locator_id;
776: /*Bug#5036174. If the org is non-PJM enbled, then the 'from locator' should not be specific to any project. So the values of both project_id and task_id
777: passed to 'INV_VALIDATE.FROM_LOCATOR' should be null when the org is non-PJM
778: enabled.*/
779:
780: IF (inv_cache.set_org_rec(p_trolin_rec.organization_id)) THEN
781: l_pjm := inv_cache.org_rec.project_reference_enabled;

Line 784: IF INV_Validate.From_Locator(

780: IF (inv_cache.set_org_rec(p_trolin_rec.organization_id)) THEN
781: l_pjm := inv_cache.org_rec.project_reference_enabled;
782: END IF;
783: IF (l_pjm = 2) THEN
784: IF INV_Validate.From_Locator(
785: g_from_locator
786: ,inv_validate_trohdr.g_org
787: ,g_item
788: ,g_from_sub

Line 786: ,inv_validate_trohdr.g_org

782: END IF;
783: IF (l_pjm = 2) THEN
784: IF INV_Validate.From_Locator(
785: g_from_locator
786: ,inv_validate_trohdr.g_org
787: ,g_item
788: ,g_from_sub
789: ,NULL
790: ,NULL

Line 791: ,inv_validate_trolin.g_transaction_l.transaction_action_id) = INV_Validate.F

787: ,g_item
788: ,g_from_sub
789: ,NULL
790: ,NULL
791: ,inv_validate_trolin.g_transaction_l.transaction_action_id) = INV_Validate.F
792: THEN
793: x_return_status := FND_API.G_RET_STS_ERROR;
794: return;
795: END IF;

Line 797: IF INV_Validate.From_Locator(g_from_locator,

793: x_return_status := FND_API.G_RET_STS_ERROR;
794: return;
795: END IF;
796: ELSE
797: IF INV_Validate.From_Locator(g_from_locator,
798: inv_validate_trohdr.g_org,
799: g_item, g_from_sub,
800: p_trolin_rec.project_id,
801: p_trolin_rec.task_id,

Line 798: inv_validate_trohdr.g_org,

794: return;
795: END IF;
796: ELSE
797: IF INV_Validate.From_Locator(g_from_locator,
798: inv_validate_trohdr.g_org,
799: g_item, g_from_sub,
800: p_trolin_rec.project_id,
801: p_trolin_rec.task_id,
802: inv_validate_trolin.g_transaction_l.transaction_action_id) =

Line 802: inv_validate_trolin.g_transaction_l.transaction_action_id) =

798: inv_validate_trohdr.g_org,
799: g_item, g_from_sub,
800: p_trolin_rec.project_id,
801: p_trolin_rec.task_id,
802: inv_validate_trolin.g_transaction_l.transaction_action_id) =
803: INV_Validate.F
804: THEN
805: x_return_status := FND_API.G_RET_STS_ERROR;
806: return;

Line 803: INV_Validate.F

799: g_item, g_from_sub,
800: p_trolin_rec.project_id,
801: p_trolin_rec.task_id,
802: inv_validate_trolin.g_transaction_l.transaction_action_id) =
803: INV_Validate.F
804: THEN
805: x_return_status := FND_API.G_RET_STS_ERROR;
806: return;
807: END IF;

Line 819: IF INV_Validate_Trohdr.Header(p_trolin_rec.header_id) =

815: ( p_trolin_rec.header_id <>
816: p_old_trolin_rec.header_id OR
817: p_old_trolin_rec.header_id IS NULL )
818: THEN
819: IF INV_Validate_Trohdr.Header(p_trolin_rec.header_id) =
820: INV_Validate.F THEN
821: x_return_status := FND_API.G_RET_STS_ERROR;
822: return;
823: END IF;

Line 820: INV_Validate.F THEN

816: p_old_trolin_rec.header_id OR
817: p_old_trolin_rec.header_id IS NULL )
818: THEN
819: IF INV_Validate_Trohdr.Header(p_trolin_rec.header_id) =
820: INV_Validate.F THEN
821: x_return_status := FND_API.G_RET_STS_ERROR;
822: return;
823: END IF;
824: END IF;

Line 833: IF INV_Validate.Last_Updated_By(p_trolin_rec.last_updated_by) =

829: ( p_trolin_rec.last_updated_by <>
830: p_old_trolin_rec.last_updated_by OR
831: p_old_trolin_rec.last_updated_by IS NULL )
832: THEN
833: IF INV_Validate.Last_Updated_By(p_trolin_rec.last_updated_by) =
834: INV_Validate.F
835: THEN
836: x_return_status := FND_API.G_RET_STS_ERROR;
837: return;

Line 834: INV_Validate.F

830: p_old_trolin_rec.last_updated_by OR
831: p_old_trolin_rec.last_updated_by IS NULL )
832: THEN
833: IF INV_Validate.Last_Updated_By(p_trolin_rec.last_updated_by) =
834: INV_Validate.F
835: THEN
836: x_return_status := FND_API.G_RET_STS_ERROR;
837: return;
838: END IF;

Line 851: IF INV_Validate.Last_Update_Date(p_trolin_rec.last_update_date) =

847: ( p_trolin_rec.last_update_date <>
848: p_old_trolin_rec.last_update_date OR
849: p_old_trolin_rec.last_update_date IS NULL )
850: THEN
851: IF INV_Validate.Last_Update_Date(p_trolin_rec.last_update_date) =
852: inv_validate.f
853: THEN
854: x_return_status := FND_API.G_RET_STS_ERROR;
855: return;

Line 852: inv_validate.f

848: p_old_trolin_rec.last_update_date OR
849: p_old_trolin_rec.last_update_date IS NULL )
850: THEN
851: IF INV_Validate.Last_Update_Date(p_trolin_rec.last_update_date) =
852: inv_validate.f
853: THEN
854: x_return_status := FND_API.G_RET_STS_ERROR;
855: return;
856: END IF;

Line 866: IF INV_Validate.Last_Update_Login(p_trolin_rec.last_update_login) =

862: ( p_trolin_rec.last_update_login <>
863: p_old_trolin_rec.last_update_login OR
864: p_old_trolin_rec.last_update_login IS NULL )
865: THEN
866: IF INV_Validate.Last_Update_Login(p_trolin_rec.last_update_login) =
867: INV_Validate.f
868: THEN
869: x_return_status := FND_API.G_RET_STS_ERROR;
870: return;

Line 867: INV_Validate.f

863: p_old_trolin_rec.last_update_login OR
864: p_old_trolin_rec.last_update_login IS NULL )
865: THEN
866: IF INV_Validate.Last_Update_Login(p_trolin_rec.last_update_login) =
867: INV_Validate.f
868: THEN
869: x_return_status := FND_API.G_RET_STS_ERROR;
870: return;
871: END IF;

Line 896: inv_validate_trohdr.g_org) = F

892: p_old_trolin_rec.line_number OR
893: p_old_trolin_rec.line_number IS NULL )
894: THEN
895: IF Line_Number(p_trolin_rec.line_number,p_trolin_rec.header_id,
896: inv_validate_trohdr.g_org) = F
897: THEN
898: x_return_status := FND_API.G_RET_STS_ERROR;
899: RETURN;
900: END IF;

Line 926: INV_Validate.Program_Application(p_trolin_rec.program_application_id)

922: p_old_trolin_rec.program_application_id OR
923: p_old_trolin_rec.program_application_id IS NULL )
924: THEN
925: IF
926: INV_Validate.Program_Application(p_trolin_rec.program_application_id)
927: = INV_Validate.F
928: THEN
929: x_return_status := FND_API.G_RET_STS_ERROR;
930: return;

Line 927: = INV_Validate.F

923: p_old_trolin_rec.program_application_id IS NULL )
924: THEN
925: IF
926: INV_Validate.Program_Application(p_trolin_rec.program_application_id)
927: = INV_Validate.F
928: THEN
929: x_return_status := FND_API.G_RET_STS_ERROR;
930: return;
931: END IF;

Line 941: IF INV_Validate.Program(p_trolin_rec.program_id) = inv_validate.F THEN

937: ( p_trolin_rec.program_id <>
938: p_old_trolin_rec.program_id OR
939: p_old_trolin_rec.program_id IS NULL )
940: THEN
941: IF INV_Validate.Program(p_trolin_rec.program_id) = inv_validate.F THEN
942: x_return_status := FND_API.G_RET_STS_ERROR;
943: return;
944: END IF;
945: END IF;

Line 955: INV_Validate.Program_Update_Date(p_trolin_rec.program_update_date)

951: p_old_trolin_rec.program_update_date OR
952: p_old_trolin_rec.program_update_date IS NULL )
953: THEN
954: IF
955: INV_Validate.Program_Update_Date(p_trolin_rec.program_update_date)
956: = inv_validate.F THEN
957: x_return_status := FND_API.G_RET_STS_ERROR;
958: return;
959: END IF;

Line 956: = inv_validate.F THEN

952: p_old_trolin_rec.program_update_date IS NULL )
953: THEN
954: IF
955: INV_Validate.Program_Update_Date(p_trolin_rec.program_update_date)
956: = inv_validate.F THEN
957: x_return_status := FND_API.G_RET_STS_ERROR;
958: return;
959: END IF;
960: END IF;

Line 969: IF INV_Validate.Quantity(p_trolin_rec.quantity) = inv_validate.F THEN

965: ( p_trolin_rec.quantity <>
966: p_old_trolin_rec.quantity OR
967: p_old_trolin_rec.quantity IS NULL )
968: THEN
969: IF INV_Validate.Quantity(p_trolin_rec.quantity) = inv_validate.F THEN
970: x_return_status := FND_API.G_RET_STS_ERROR;
971: return;
972: END IF;
973: END IF;

Line 1010: IF INV_Validate.Secondary_Quantity(p_trolin_rec.secondary_quantity) = inv_validate.F THEN

1006: ( p_trolin_rec.secondary_quantity <>
1007: p_old_trolin_rec.secondary_quantity OR
1008: p_old_trolin_rec.secondary_quantity IS NULL )
1009: THEN
1010: IF INV_Validate.Secondary_Quantity(p_trolin_rec.secondary_quantity) = inv_validate.F THEN
1011: x_return_status := FND_API.G_RET_STS_ERROR;
1012: return;
1013: END IF;
1014: END IF;

Line 1049: IF INV_Validate.Reason(p_trolin_rec.reason_id) = inv_validate.F THEN

1045: ( p_trolin_rec.reason_id <>
1046: p_old_trolin_rec.reason_id OR
1047: p_old_trolin_rec.reason_id IS NULL )
1048: THEN
1049: IF INV_Validate.Reason(p_trolin_rec.reason_id) = inv_validate.F THEN
1050: x_return_status := FND_API.G_RET_STS_ERROR;
1051: return;
1052: END IF;
1053: END IF;

Line 1061: IF INV_Validate.Reference(p_trolin_rec.reference) = inv_validate.F THEN

1057: ( p_trolin_rec.reference <>
1058: p_old_trolin_rec.reference OR
1059: p_old_trolin_rec.reference IS NULL )
1060: THEN
1061: IF INV_Validate.Reference(p_trolin_rec.reference) = inv_validate.F THEN
1062: x_return_status := FND_API.G_RET_STS_ERROR;
1063: return;
1064: END IF;
1065: END IF;

Line 1073: IF INV_Validate.Reference_Type(p_trolin_rec.reference_type_code) =

1069: ( p_trolin_rec.reference_type_code <>
1070: p_old_trolin_rec.reference_type_code OR
1071: p_old_trolin_rec.reference_type_code IS NULL )
1072: THEN
1073: IF INV_Validate.Reference_Type(p_trolin_rec.reference_type_code) =
1074: inv_validate.F THEN
1075: x_return_status := FND_API.G_RET_STS_ERROR;
1076: return;
1077: END IF;

Line 1074: inv_validate.F THEN

1070: p_old_trolin_rec.reference_type_code OR
1071: p_old_trolin_rec.reference_type_code IS NULL )
1072: THEN
1073: IF INV_Validate.Reference_Type(p_trolin_rec.reference_type_code) =
1074: inv_validate.F THEN
1075: x_return_status := FND_API.G_RET_STS_ERROR;
1076: return;
1077: END IF;
1078: END IF;

Line 1087: IF INV_Validate.Reference(p_trolin_rec.reference_id,

1083: ( p_trolin_rec.reference_id <>
1084: p_old_trolin_rec.reference_id OR
1085: p_old_trolin_rec.reference_id IS NULL )
1086: THEN
1087: IF INV_Validate.Reference(p_trolin_rec.reference_id,
1088: p_trolin_rec.reference_type_code) =
1089: inv_validate.F THEN
1090: x_return_status := FND_API.G_RET_STS_ERROR;
1091: return;

Line 1089: inv_validate.F THEN

1085: p_old_trolin_rec.reference_id IS NULL )
1086: THEN
1087: IF INV_Validate.Reference(p_trolin_rec.reference_id,
1088: p_trolin_rec.reference_type_code) =
1089: inv_validate.F THEN
1090: x_return_status := FND_API.G_RET_STS_ERROR;
1091: return;
1092: END IF;
1093: END IF;

Line 1101: IF INV_Validate_Trohdr.Request(p_trolin_rec.request_id) =

1097: ( p_trolin_rec.request_id <>
1098: p_old_trolin_rec.request_id OR
1099: p_old_trolin_rec.request_id IS NULL )
1100: THEN
1101: IF INV_Validate_Trohdr.Request(p_trolin_rec.request_id) =
1102: inv_validate.F THEN
1103: x_return_status := FND_API.G_RET_STS_ERROR;
1104: return;
1105: END IF;

Line 1102: inv_validate.F THEN

1098: p_old_trolin_rec.request_id OR
1099: p_old_trolin_rec.request_id IS NULL )
1100: THEN
1101: IF INV_Validate_Trohdr.Request(p_trolin_rec.request_id) =
1102: inv_validate.F THEN
1103: x_return_status := FND_API.G_RET_STS_ERROR;
1104: return;
1105: END IF;
1106: END IF;

Line 1114: IF INV_Validate.Revision(p_trolin_rec.revision,

1110: ( p_trolin_rec.revision <>
1111: p_old_trolin_rec.revision OR
1112: p_old_trolin_rec.revision IS NULL )
1113: THEN
1114: IF INV_Validate.Revision(p_trolin_rec.revision,
1115: inv_validate_trohdr.g_org,
1116: g_item) = inv_validate.F THEN
1117: x_return_status := FND_API.G_RET_STS_ERROR;
1118: return;

Line 1115: inv_validate_trohdr.g_org,

1111: p_old_trolin_rec.revision OR
1112: p_old_trolin_rec.revision IS NULL )
1113: THEN
1114: IF INV_Validate.Revision(p_trolin_rec.revision,
1115: inv_validate_trohdr.g_org,
1116: g_item) = inv_validate.F THEN
1117: x_return_status := FND_API.G_RET_STS_ERROR;
1118: return;
1119: END IF;

Line 1116: g_item) = inv_validate.F THEN

1112: p_old_trolin_rec.revision IS NULL )
1113: THEN
1114: IF INV_Validate.Revision(p_trolin_rec.revision,
1115: inv_validate_trohdr.g_org,
1116: g_item) = inv_validate.F THEN
1117: x_return_status := FND_API.G_RET_STS_ERROR;
1118: return;
1119: END IF;
1120: END IF;

Line 1145: IF INV_Validate.Lot_Number(g_lot, inv_validate_trohdr.g_org, g_item) = inv_validate.F THEN

1141:
1142: IF l_mov_order_type=INV_GLOBALS.g_move_order_put_away
1143: THEN
1144:
1145: IF INV_Validate.Lot_Number(g_lot, inv_validate_trohdr.g_org, g_item) = inv_validate.F THEN
1146: x_return_status := FND_API.G_RET_STS_ERROR;
1147: return;
1148: END IF;
1149:

Line 1152: IF INV_Validate.Lot_Number(g_lot, inv_validate_trohdr.g_org, g_item,

1148: END IF;
1149:
1150: ELSE
1151:
1152: IF INV_Validate.Lot_Number(g_lot, inv_validate_trohdr.g_org, g_item,
1153: g_from_sub, g_from_locator,
1154: p_trolin_rec.revision) = inv_validate.F THEN
1155: x_return_status := FND_API.G_RET_STS_ERROR;
1156: return;

Line 1154: p_trolin_rec.revision) = inv_validate.F THEN

1150: ELSE
1151:
1152: IF INV_Validate.Lot_Number(g_lot, inv_validate_trohdr.g_org, g_item,
1153: g_from_sub, g_from_locator,
1154: p_trolin_rec.revision) = inv_validate.F THEN
1155: x_return_status := FND_API.G_RET_STS_ERROR;
1156: return;
1157: END IF;
1158:

Line 1163: IF INV_Validate.Lot_Number(g_lot, inv_validate_trohdr.g_org, g_item,

1159: END IF;
1160:
1161:
1162: /*
1163: IF INV_Validate.Lot_Number(g_lot, inv_validate_trohdr.g_org, g_item,
1164: g_from_sub, g_from_locator,
1165: p_trolin_rec.revision) = inv_validate.F THEN
1166: x_return_status := FND_API.G_RET_STS_ERROR;
1167: return;

Line 1165: p_trolin_rec.revision) = inv_validate.F THEN

1161:
1162: /*
1163: IF INV_Validate.Lot_Number(g_lot, inv_validate_trohdr.g_org, g_item,
1164: g_from_sub, g_from_locator,
1165: p_trolin_rec.revision) = inv_validate.F THEN
1166: x_return_status := FND_API.G_RET_STS_ERROR;
1167: return;
1168: END IF;
1169: */

Line 1179: IF INV_Validate.Serial_Number_Start(g_serial,

1175: p_old_trolin_rec.serial_number_start OR
1176: p_old_trolin_rec.serial_number_start IS NULL )
1177: THEN
1178: g_serial.serial_number := p_trolin_rec.serial_number_start;
1179: IF INV_Validate.Serial_Number_Start(g_serial,
1180: inv_validate_trohdr.g_org,
1181: g_item, g_from_sub, g_lot,
1182: g_from_locator,
1183: p_trolin_rec.revision) =

Line 1180: inv_validate_trohdr.g_org,

1176: p_old_trolin_rec.serial_number_start IS NULL )
1177: THEN
1178: g_serial.serial_number := p_trolin_rec.serial_number_start;
1179: IF INV_Validate.Serial_Number_Start(g_serial,
1180: inv_validate_trohdr.g_org,
1181: g_item, g_from_sub, g_lot,
1182: g_from_locator,
1183: p_trolin_rec.revision) =
1184: inv_validate.F THEN

Line 1184: inv_validate.F THEN

1180: inv_validate_trohdr.g_org,
1181: g_item, g_from_sub, g_lot,
1182: g_from_locator,
1183: p_trolin_rec.revision) =
1184: inv_validate.F THEN
1185: x_return_status := FND_API.G_RET_STS_ERROR;
1186: return;
1187: END IF;
1188: END IF;

Line 1197: IF INV_Validate.Serial_Number_End(g_serial,

1193: p_old_trolin_rec.serial_number_end OR
1194: p_old_trolin_rec.serial_number_end IS NULL )
1195: THEN
1196: g_serial.serial_number := p_trolin_rec.serial_number_end;
1197: IF INV_Validate.Serial_Number_End(g_serial,
1198: inv_validate_trohdr.g_org,
1199: g_item, g_from_sub, g_lot,
1200: g_from_locator,
1201: p_trolin_rec.revision) =

Line 1198: inv_validate_trohdr.g_org,

1194: p_old_trolin_rec.serial_number_end IS NULL )
1195: THEN
1196: g_serial.serial_number := p_trolin_rec.serial_number_end;
1197: IF INV_Validate.Serial_Number_End(g_serial,
1198: inv_validate_trohdr.g_org,
1199: g_item, g_from_sub, g_lot,
1200: g_from_locator,
1201: p_trolin_rec.revision) =
1202: inv_validate.F THEN

Line 1202: inv_validate.F THEN

1198: inv_validate_trohdr.g_org,
1199: g_item, g_from_sub, g_lot,
1200: g_from_locator,
1201: p_trolin_rec.revision) =
1202: inv_validate.F THEN
1203: x_return_status := FND_API.G_RET_STS_ERROR;
1204: return;
1205: END IF;
1206: END IF;

Line 1215: IF INV_Validate_Trohdr.Status_Date(p_trolin_rec.status_date) =

1211: ( p_trolin_rec.status_date <>
1212: p_old_trolin_rec.status_date OR
1213: p_old_trolin_rec.status_date IS NULL )
1214: THEN
1215: IF INV_Validate_Trohdr.Status_Date(p_trolin_rec.status_date) =
1216: inv_validate.F THEN
1217: x_return_status := FND_API.G_RET_STS_ERROR;
1218: return;
1219: END IF;

Line 1216: inv_validate.F THEN

1212: p_old_trolin_rec.status_date OR
1213: p_old_trolin_rec.status_date IS NULL )
1214: THEN
1215: IF INV_Validate_Trohdr.Status_Date(p_trolin_rec.status_date) =
1216: inv_validate.F THEN
1217: x_return_status := FND_API.G_RET_STS_ERROR;
1218: return;
1219: END IF;
1220: END IF;

Line 1232: WHERE ORG.ORGANIZATION_ID = inv_validate_trohdr.g_org.organization_id;

1228:
1229: SELECT ORG.CHART_OF_ACCOUNTS_ID
1230: INTO l_chart_of_accounts_id
1231: FROM ORG_ORGANIZATION_DEFINITIONS ORG
1232: WHERE ORG.ORGANIZATION_ID = inv_validate_trohdr.g_org.organization_id;
1233:
1234: l_keystat_val := FND_FLEX_KEYVAL.Validate_Segs(
1235: OPERATION => 'CREATE_COMBINATION',
1236: APPL_SHORT_NAME => 'SQLGL',

Line 1241: -- DATA_SET => INV_Validate.g_TRO_VAttributes.organization_id);

1237: key_flex_code => 'GL#',
1238: STRUCTURE_NUMBER => l_chart_of_accounts_id,
1239: CONCAT_SEGMENTS => p_trolin_val_rec.to_account,
1240: VALUES_OR_IDS => 'V');
1241: -- DATA_SET => INV_Validate.g_TRO_VAttributes.organization_id);
1242: if l_keystat_val then
1243: l_combination_id := FND_FLEX_KEYVAL.combination_id;
1244: p_trolin_rec.to_account_id := l_combination_id;
1245: else

Line 1256: IF INV_Validate.To_Account(p_trolin_rec.to_account_id) =

1252: ( p_trolin_rec.to_account_id <>
1253: p_old_trolin_rec.to_account_id OR
1254: p_old_trolin_rec.to_account_id IS NULL )
1255: THEN
1256: IF INV_Validate.To_Account(p_trolin_rec.to_account_id) =
1257: inv_validate.f THEN
1258: x_return_status := FND_API.G_RET_STS_ERROR;
1259: END IF;
1260: END IF;

Line 1257: inv_validate.f THEN

1253: p_old_trolin_rec.to_account_id OR
1254: p_old_trolin_rec.to_account_id IS NULL )
1255: THEN
1256: IF INV_Validate.To_Account(p_trolin_rec.to_account_id) =
1257: inv_validate.f THEN
1258: x_return_status := FND_API.G_RET_STS_ERROR;
1259: END IF;
1260: END IF;
1261: -- inv_debug.message('TRO: to_account_id: ' || x_return_status);

Line 1272: IF INV_Validate.To_Subinventory(g_to_sub, inv_validate_trohdr.g_org,

1268: p_old_trolin_rec.to_subinventory_code IS NULL )
1269: THEN
1270: --inv_debug.message('ssia', 'check to_subinventory_code');
1271: g_to_sub.secondary_inventory_name := p_trolin_rec.to_subinventory_code;
1272: IF INV_Validate.To_Subinventory(g_to_sub, inv_validate_trohdr.g_org,
1273: g_item, g_from_sub, 0) =
1274: inv_validate.F THEN
1275: --inv_debug.message('ssia', 'error to_subinventory_code');
1276: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1274: inv_validate.F THEN

1270: --inv_debug.message('ssia', 'check to_subinventory_code');
1271: g_to_sub.secondary_inventory_name := p_trolin_rec.to_subinventory_code;
1272: IF INV_Validate.To_Subinventory(g_to_sub, inv_validate_trohdr.g_org,
1273: g_item, g_from_sub, 0) =
1274: inv_validate.F THEN
1275: --inv_debug.message('ssia', 'error to_subinventory_code');
1276: x_return_status := FND_API.G_RET_STS_ERROR;
1277: return;
1278: END IF;

Line 1330: inv_validate_trohdr.g_org.stock_locator_control_code,

1326: INV_Globals.Locator_control(
1327: l_return_status,
1328: l_msg_count,
1329: l_msg_data,
1330: inv_validate_trohdr.g_org.stock_locator_control_code,
1331: nvl(g_to_sub.locator_type,1),
1332: g_item.location_control_code,
1333: g_item.restrict_locators_code,
1334: inv_validate_trohdr.g_org.negative_inv_receipt_code,

Line 1334: inv_validate_trohdr.g_org.negative_inv_receipt_code,

1330: inv_validate_trohdr.g_org.stock_locator_control_code,
1331: nvl(g_to_sub.locator_type,1),
1332: g_item.location_control_code,
1333: g_item.restrict_locators_code,
1334: inv_validate_trohdr.g_org.negative_inv_receipt_code,
1335: inv_validate_trolin.g_transaction_l.transaction_action_id);
1336: if (NVL(v_locator_control,1) = 3) then
1337: l_keystat_val := FND_FLEX_KEYVAL.Validate_Segs(
1338: OPERATION => 'CREATE_COMB_NO_AT',

Line 1335: inv_validate_trolin.g_transaction_l.transaction_action_id);

1331: nvl(g_to_sub.locator_type,1),
1332: g_item.location_control_code,
1333: g_item.restrict_locators_code,
1334: inv_validate_trohdr.g_org.negative_inv_receipt_code,
1335: inv_validate_trolin.g_transaction_l.transaction_action_id);
1336: if (NVL(v_locator_control,1) = 3) then
1337: l_keystat_val := FND_FLEX_KEYVAL.Validate_Segs(
1338: OPERATION => 'CREATE_COMB_NO_AT',
1339: APPL_SHORT_NAME => 'INV',

Line 1344: DATA_SET => inv_validate_trohdr.g_org.organization_id);

1340: KEY_FLEX_CODE => 'MTLL',
1341: STRUCTURE_NUMBER => 101,
1342: CONCAT_SEGMENTS => p_trolin_val_rec.to_locator,
1343: VALUES_OR_IDS => 'V',
1344: DATA_SET => inv_validate_trohdr.g_org.organization_id);
1345:
1346: if l_keystat_val then
1347: l_combination_id := FND_FLEX_KEYVAL.combination_id;
1348: BEGIN

Line 1353: AND ORGANIZATION_ID = inv_validate_trohdr.g_org.organization_id

1349: SELECT 'EXISTS'
1350: INTO l_temp
1351: FROM MTL_ITEM_LOCATIONS
1352: WHERE INVENTORY_LOCATION_ID = l_combination_id
1353: AND ORGANIZATION_ID = inv_validate_trohdr.g_org.organization_id
1354: AND SUBINVENTORY_CODE = g_to_sub.secondary_inventory_name;
1355:
1356: EXCEPTION
1357: WHEN NO_DATA_FOUND THEN

Line 1361: AND ORGANIZATION_ID = inv_validate_trohdr.g_org.organization_id

1357: WHEN NO_DATA_FOUND THEN
1358: UPDATE mtl_item_locations
1359: SET SUBINVENTORY_CODE = g_to_sub.secondary_inventory_name
1360: WHERE INVENTORY_LOCATION_ID = l_combination_id
1361: AND ORGANIZATION_ID = inv_validate_trohdr.g_org.organization_id
1362: AND SUBINVENTORY_CODE = NULL;
1363:
1364: if SQL%NOTFOUND then
1365: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1372: AND ORGANIZATION_ID =inv_validate_trohdr.g_org.organization_id;

1368: SELECT PROJECT_ID,TASK_ID
1369: INTO l_project_id, l_task_id
1370: FROM MTL_ITEM_LOCATIONS
1371: WHERE INVENTORY_LOCATION_ID = l_combination_id
1372: AND ORGANIZATION_ID =inv_validate_trohdr.g_org.organization_id;
1373:
1374: if NOT INV_ProjectLocator_PUB.Check_Project_References(
1375: inv_validate_trohdr.g_org.organization_id,
1376: p_trolin_rec.to_locator_id,

Line 1375: inv_validate_trohdr.g_org.organization_id,

1371: WHERE INVENTORY_LOCATION_ID = l_combination_id
1372: AND ORGANIZATION_ID =inv_validate_trohdr.g_org.organization_id;
1373:
1374: if NOT INV_ProjectLocator_PUB.Check_Project_References(
1375: inv_validate_trohdr.g_org.organization_id,
1376: p_trolin_rec.to_locator_id,
1377: 'ANY',
1378: 'N',
1379: l_project_id,

Line 1420: IF INV_Validate.To_Locator(g_to_locator,

1416:
1417: IF l_project_id_mil is NOT NULL THEN
1418:
1419:
1420: IF INV_Validate.To_Locator(g_to_locator,
1421: inv_validate_trohdr.g_org, g_item,
1422: g_to_sub, p_trolin_rec.project_id,
1423: p_trolin_rec.task_id,
1424: inv_validate_trolin.g_transaction_l.transaction_action_id) = inv_validate.F THEN

Line 1421: inv_validate_trohdr.g_org, g_item,

1417: IF l_project_id_mil is NOT NULL THEN
1418:
1419:
1420: IF INV_Validate.To_Locator(g_to_locator,
1421: inv_validate_trohdr.g_org, g_item,
1422: g_to_sub, p_trolin_rec.project_id,
1423: p_trolin_rec.task_id,
1424: inv_validate_trolin.g_transaction_l.transaction_action_id) = inv_validate.F THEN
1425: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1424: inv_validate_trolin.g_transaction_l.transaction_action_id) = inv_validate.F THEN

1420: IF INV_Validate.To_Locator(g_to_locator,
1421: inv_validate_trohdr.g_org, g_item,
1422: g_to_sub, p_trolin_rec.project_id,
1423: p_trolin_rec.task_id,
1424: inv_validate_trolin.g_transaction_l.transaction_action_id) = inv_validate.F THEN
1425: x_return_status := FND_API.G_RET_STS_ERROR;
1426: return;
1427: END IF;
1428:

Line 1431: IF INV_Validate.To_Locator(g_to_locator,

1427: END IF;
1428:
1429: ELSE
1430:
1431: IF INV_Validate.To_Locator(g_to_locator,
1432: inv_validate_trohdr.g_org, g_item,
1433: g_to_sub, null, null,
1434: inv_validate_trolin.g_transaction_l.transaction_action_id) = inv_validate.F THEN
1435: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1432: inv_validate_trohdr.g_org, g_item,

1428:
1429: ELSE
1430:
1431: IF INV_Validate.To_Locator(g_to_locator,
1432: inv_validate_trohdr.g_org, g_item,
1433: g_to_sub, null, null,
1434: inv_validate_trolin.g_transaction_l.transaction_action_id) = inv_validate.F THEN
1435: x_return_status := FND_API.G_RET_STS_ERROR;
1436: return;

Line 1434: inv_validate_trolin.g_transaction_l.transaction_action_id) = inv_validate.F THEN

1430:
1431: IF INV_Validate.To_Locator(g_to_locator,
1432: inv_validate_trohdr.g_org, g_item,
1433: g_to_sub, null, null,
1434: inv_validate_trolin.g_transaction_l.transaction_action_id) = inv_validate.F THEN
1435: x_return_status := FND_API.G_RET_STS_ERROR;
1436: return;
1437: END IF;
1438: END IF;

Line 1450: INV_Validate.Transaction_Header(p_trolin_rec.transaction_header_id) =

1446: p_old_trolin_rec.transaction_header_id OR
1447: p_old_trolin_rec.transaction_header_id IS NULL )
1448: THEN
1449: IF
1450: INV_Validate.Transaction_Header(p_trolin_rec.transaction_header_id) =
1451: inv_validate.f THEN
1452: x_return_status := FND_API.G_RET_STS_ERROR;
1453: END IF;
1454: END IF;

Line 1451: inv_validate.f THEN

1447: p_old_trolin_rec.transaction_header_id IS NULL )
1448: THEN
1449: IF
1450: INV_Validate.Transaction_Header(p_trolin_rec.transaction_header_id) =
1451: inv_validate.f THEN
1452: x_return_status := FND_API.G_RET_STS_ERROR;
1453: END IF;
1454: END IF;
1455: -- inv_debug.message('TRO: transaction_header_id: ' || x_return_status);

Line 1462: IF INV_Validate.HR_Location(p_trolin_rec.ship_to_location_id) =

1458: ( p_trolin_rec.ship_to_location_id <>
1459: p_old_trolin_rec.transaction_header_id OR
1460: p_old_trolin_rec.transaction_header_id IS NULL)
1461: THEN
1462: IF INV_Validate.HR_Location(p_trolin_rec.ship_to_location_id) =
1463: INV_Validate.F
1464: THEN
1465: x_return_status := FND_API.G_RET_STS_ERROR;
1466: END IF;

Line 1463: INV_Validate.F

1459: p_old_trolin_rec.transaction_header_id OR
1460: p_old_trolin_rec.transaction_header_id IS NULL)
1461: THEN
1462: IF INV_Validate.HR_Location(p_trolin_rec.ship_to_location_id) =
1463: INV_Validate.F
1464: THEN
1465: x_return_status := FND_API.G_RET_STS_ERROR;
1466: END IF;
1467: END IF;

Line 1474: IF INV_Validate.Uom(p_trolin_rec.uom_code,

1470: ( p_trolin_rec.uom_code <>
1471: p_old_trolin_rec.uom_code OR
1472: p_old_trolin_rec.uom_code IS NULL )
1473: THEN
1474: IF INV_Validate.Uom(p_trolin_rec.uom_code,
1475: inv_validate_trohdr.g_org, g_item) = inv_validate.F THEN
1476: x_return_status := FND_API.G_RET_STS_ERROR;
1477: END IF;
1478: END IF;

Line 1475: inv_validate_trohdr.g_org, g_item) = inv_validate.F THEN

1471: p_old_trolin_rec.uom_code OR
1472: p_old_trolin_rec.uom_code IS NULL )
1473: THEN
1474: IF INV_Validate.Uom(p_trolin_rec.uom_code,
1475: inv_validate_trohdr.g_org, g_item) = inv_validate.F THEN
1476: x_return_status := FND_API.G_RET_STS_ERROR;
1477: END IF;
1478: END IF;
1479:

Line 1483: if INV_Validate.Cost_Group(p_trolin_rec.from_cost_group_id,

1479:
1480: IF p_trolin_rec.from_cost_group_id IS NOT NULL AND
1481: (p_trolin_rec.from_cost_group_id <> p_old_trolin_rec.from_cost_group_id OR
1482: p_old_trolin_rec.from_cost_group_id IS NULL) then
1483: if INV_Validate.Cost_Group(p_trolin_rec.from_cost_group_id,
1484: p_trolin_rec.organization_id) = inv_validate.F then
1485: x_return_status := FND_API.G_RET_STS_ERROR;
1486: END IF;
1487: END IF;

Line 1484: p_trolin_rec.organization_id) = inv_validate.F then

1480: IF p_trolin_rec.from_cost_group_id IS NOT NULL AND
1481: (p_trolin_rec.from_cost_group_id <> p_old_trolin_rec.from_cost_group_id OR
1482: p_old_trolin_rec.from_cost_group_id IS NULL) then
1483: if INV_Validate.Cost_Group(p_trolin_rec.from_cost_group_id,
1484: p_trolin_rec.organization_id) = inv_validate.F then
1485: x_return_status := FND_API.G_RET_STS_ERROR;
1486: END IF;
1487: END IF;
1488:

Line 1492: if INV_Validate.Cost_Group(p_trolin_rec.to_cost_group_id,

1488:
1489: IF p_trolin_rec.to_cost_group_id IS NOT NULL AND
1490: (p_trolin_rec.to_cost_group_id <> p_old_trolin_rec.to_cost_group_id OR
1491: p_old_trolin_rec.to_cost_group_id IS NULL) then
1492: if INV_Validate.Cost_Group(p_trolin_rec.to_cost_group_id,
1493: p_trolin_rec.organization_id) = inv_validate.F then
1494: x_return_status := FND_API.G_RET_STS_ERROR;
1495: END IF;
1496: END IF;

Line 1493: p_trolin_rec.organization_id) = inv_validate.F then

1489: IF p_trolin_rec.to_cost_group_id IS NOT NULL AND
1490: (p_trolin_rec.to_cost_group_id <> p_old_trolin_rec.to_cost_group_id OR
1491: p_old_trolin_rec.to_cost_group_id IS NULL) then
1492: if INV_Validate.Cost_Group(p_trolin_rec.to_cost_group_id,
1493: p_trolin_rec.organization_id) = inv_validate.F then
1494: x_return_status := FND_API.G_RET_STS_ERROR;
1495: END IF;
1496: END IF;
1497:

Line 1501: if INV_Validate.LPN(p_trolin_rec.lpn_id) = inv_validate.F then

1497:
1498: IF p_trolin_rec.lpn_id IS NOT NULL AND
1499: (p_trolin_rec.lpn_id <> p_old_trolin_rec.lpn_id OR
1500: p_old_trolin_rec.lpn_id IS NULL) then
1501: if INV_Validate.LPN(p_trolin_rec.lpn_id) = inv_validate.F then
1502: x_return_status := FND_API.G_RET_STS_ERROR;
1503: END IF;
1504: END IF;
1505:

Line 1509: if INV_Validate.LPN(p_trolin_rec.to_lpn_id) = inv_validate.F then

1505:
1506: IF p_trolin_rec.to_lpn_id IS NOT NULL AND
1507: (p_trolin_rec.to_lpn_id <> p_old_trolin_rec.to_lpn_id OR
1508: p_old_trolin_rec.to_lpn_id IS NULL) then
1509: if INV_Validate.LPN(p_trolin_rec.to_lpn_id) = inv_validate.F then
1510: x_return_status := FND_API.G_RET_STS_ERROR;
1511: END IF;
1512: END IF;
1513:

Line 1587: IF INV_Validate.Desc_Flex( 'TROLIN' ) = inv_validate.F THEN

1583:
1584:
1585: -- Validate descriptive flexfield.
1586:
1587: IF INV_Validate.Desc_Flex( 'TROLIN' ) = inv_validate.F THEN
1588: x_return_status := FND_API.G_RET_STS_ERROR;
1589: END IF;
1590:
1591: END IF;

Line 1664: END INV_Validate_Trolin;

1660: g_from_locator := Null;
1661: g_to_locator := Null;
1662: END;
1663:
1664: END INV_Validate_Trolin;