[Home] [Help]
55: RETURN NUMBER
56: IS
57: BEGIN
58: -- -------------------------------------------------------
59: RETURN INV_Validate.g_TRO_GlobalAttributes.header_id;
60: END Get_Header;
61: */
62:
63: FUNCTION Get_Inventory_Item
672: , p_iteration IN NUMBER := 1
673: , x_trolin_rec OUT NOCOPY INV_Move_Order_PUB.Trolin_Rec_Type
674: )
675: IS
676: l_org inv_validate.org;
677: l_item inv_validate.item;
678: l_fsub inv_validate.sub;
679: l_tsub inv_validate.sub;
680: l_floc inv_validate.locator;
673: , x_trolin_rec OUT NOCOPY INV_Move_Order_PUB.Trolin_Rec_Type
674: )
675: IS
676: l_org inv_validate.org;
677: l_item inv_validate.item;
678: l_fsub inv_validate.sub;
679: l_tsub inv_validate.sub;
680: l_floc inv_validate.locator;
681: l_tloc inv_validate.locator;
674: )
675: IS
676: l_org inv_validate.org;
677: l_item inv_validate.item;
678: l_fsub inv_validate.sub;
679: l_tsub inv_validate.sub;
680: l_floc inv_validate.locator;
681: l_tloc inv_validate.locator;
682: l_lot inv_validate.lot;
675: IS
676: l_org inv_validate.org;
677: l_item inv_validate.item;
678: l_fsub inv_validate.sub;
679: l_tsub inv_validate.sub;
680: l_floc inv_validate.locator;
681: l_tloc inv_validate.locator;
682: l_lot inv_validate.lot;
683: l_serial inv_validate.serial;
676: l_org inv_validate.org;
677: l_item inv_validate.item;
678: l_fsub inv_validate.sub;
679: l_tsub inv_validate.sub;
680: l_floc inv_validate.locator;
681: l_tloc inv_validate.locator;
682: l_lot inv_validate.lot;
683: l_serial inv_validate.serial;
684: l_trans inv_validate.transaction;
677: l_item inv_validate.item;
678: l_fsub inv_validate.sub;
679: l_tsub inv_validate.sub;
680: l_floc inv_validate.locator;
681: l_tloc inv_validate.locator;
682: l_lot inv_validate.lot;
683: l_serial inv_validate.serial;
684: l_trans inv_validate.transaction;
685: l_acct_txn NUMBER;
678: l_fsub inv_validate.sub;
679: l_tsub inv_validate.sub;
680: l_floc inv_validate.locator;
681: l_tloc inv_validate.locator;
682: l_lot inv_validate.lot;
683: l_serial inv_validate.serial;
684: l_trans inv_validate.transaction;
685: l_acct_txn NUMBER;
686:
679: l_tsub inv_validate.sub;
680: l_floc inv_validate.locator;
681: l_tloc inv_validate.locator;
682: l_lot inv_validate.lot;
683: l_serial inv_validate.serial;
684: l_trans inv_validate.transaction;
685: l_acct_txn NUMBER;
686:
687: l_mov_order_type NUMBER;
680: l_floc inv_validate.locator;
681: l_tloc inv_validate.locator;
682: l_lot inv_validate.lot;
683: l_serial inv_validate.serial;
684: l_trans inv_validate.transaction;
685: l_acct_txn NUMBER;
686:
687: l_mov_order_type NUMBER;
688: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
733:
734: IF g_trolin_rec.organization_id IS NOT NULL THEN
735:
736: l_org.organization_id := g_trolin_rec.organization_id;
737: IF INV_Validate.Organization(l_org) = inv_validate.T
738: THEN
739: INV_Trolin_Util.Clear_Dependent_Attr
740: ( p_attr_id => INV_Trolin_Util.G_ORGANIZATION
741: , p_trolin_rec => g_trolin_rec
755:
756: IF g_trolin_rec.inventory_item_id IS NOT NULL THEN
757:
758: l_item.inventory_item_id := g_trolin_rec.inventory_item_id;
759: IF INV_Validate.Inventory_Item(l_item, l_org)
760: = inv_validate.T
761: THEN
762: INV_Trolin_Util.Clear_Dependent_Attr
763: ( p_attr_id => INV_Trolin_Util.G_INVENTORY_ITEM
756: IF g_trolin_rec.inventory_item_id IS NOT NULL THEN
757:
758: l_item.inventory_item_id := g_trolin_rec.inventory_item_id;
759: IF INV_Validate.Inventory_Item(l_item, l_org)
760: = inv_validate.T
761: THEN
762: INV_Trolin_Util.Clear_Dependent_Attr
763: ( p_attr_id => INV_Trolin_Util.G_INVENTORY_ITEM
764: , p_trolin_rec => g_trolin_rec
776: g_trolin_rec.transaction_type_id := Get_Transaction_Type_Id;
777: END IF;
778: IF g_trolin_rec.transaction_type_id IS NOT NULL THEN
779: l_trans.transaction_type_id := g_trolin_rec.transaction_type_id;
780: IF INV_Validate.Transaction_Type(l_trans) = inv_validate.T
781: THEN
782: INV_Trolin_Util.Clear_Dependent_Attr
783: ( p_attr_id => INV_Trolin_Util.G_TRANSACTION_TYPE_ID
784: , p_trolin_rec => g_trolin_rec
786: );
787: ELSE
788: g_trolin_rec.transaction_type_id := NULL;
789: END IF;
790: INV_Validate_Trolin.g_transaction_l := l_trans;
791: END IF;
792:
793: IF l_trans.transaction_action_id = 1 THEN
794: l_acct_txn := 1;
801: g_trolin_rec.date_required := Get_Date_Required;
802:
803: IF g_trolin_rec.date_required IS NOT NULL THEN
804:
805: IF INV_Validate_Trohdr.Date_Required(g_trolin_rec.date_required) = INV_Validate_Trohdr.T
806: THEN
807: INV_Trolin_Util.Clear_Dependent_Attr
808: ( p_attr_id => INV_Trolin_Util.G_DATE_REQUIRED
809: , p_trolin_rec => g_trolin_rec
824:
825: IF g_trolin_rec.from_subinventory_code IS NOT NULL THEN
826: l_fsub.secondary_inventory_name := g_trolin_rec.from_subinventory_code;
827: IF
828: INV_Validate.From_Subinventory(l_fsub,l_org,l_item,l_acct_txn) = inv_validate.T
829: THEN
830: INV_Trolin_Util.Clear_Dependent_Attr
831: ( p_attr_id => INV_Trolin_Util.G_FROM_SUBINVENTORY
832: , p_trolin_rec => g_trolin_rec
848:
849: IF g_trolin_rec.from_subinventory_id IS NOT NULL THEN
850: l_fsub.secondary_inventory_name := g_trolin_rec.from_subinventory_code;
851: IF
852: INV_Validate.From_Subinventory(l_fsub,l_org,l_item,l_acct_txn) = inv_validate.T
853:
854: THEN
855: INV_Trolin_Util.Clear_Dependent_Attr
856: ( p_attr_id => INV_Trolin_Util.G_FROM_SUBINVENTORY
872:
873: IF g_trolin_rec.from_locator_id IS NOT NULL THEN
874:
875: l_floc.inventory_location_id := g_trolin_rec.from_locator_id;
876: IF INV_Validate.From_Locator(l_floc,l_org,l_item,l_fsub,g_trolin_rec.project_id,g_trolin_rec.task_id,l_trans.transaction_action_id) =
877: inv_validate.T
878: THEN
879: INV_Trolin_Util.Clear_Dependent_Attr
880: ( p_attr_id => INV_Trolin_Util.G_FROM_LOCATOR
873: IF g_trolin_rec.from_locator_id IS NOT NULL THEN
874:
875: l_floc.inventory_location_id := g_trolin_rec.from_locator_id;
876: IF INV_Validate.From_Locator(l_floc,l_org,l_item,l_fsub,g_trolin_rec.project_id,g_trolin_rec.task_id,l_trans.transaction_action_id) =
877: inv_validate.T
878: THEN
879: INV_Trolin_Util.Clear_Dependent_Attr
880: ( p_attr_id => INV_Trolin_Util.G_FROM_LOCATOR
881: , p_trolin_rec => g_trolin_rec
895: g_trolin_rec.line_id := Get_Line;
896:
897: IF g_trolin_rec.line_id IS NOT NULL THEN
898:
899: IF INV_Validate_trolin.Line(g_trolin_rec.line_id) = inv_validate_trolin.T
900: THEN
901: INV_Trolin_Util.Clear_Dependent_Attr
902: ( p_attr_id => INV_Trolin_Util.G_LINE
903: , p_trolin_rec => g_trolin_rec
916: g_trolin_rec.line_number := Get_Line_Number;
917:
918: IF g_trolin_rec.line_number IS NOT NULL THEN
919:
920: IF INV_Validate_trolin.Line_Number(g_trolin_rec.line_number,
921: g_trolin_rec.header_id,
922: l_org) = inv_validate_trolin.T
923: THEN
924: INV_Trolin_Util.Clear_Dependent_Attr
918: IF g_trolin_rec.line_number IS NOT NULL THEN
919:
920: IF INV_Validate_trolin.Line_Number(g_trolin_rec.line_number,
921: g_trolin_rec.header_id,
922: l_org) = inv_validate_trolin.T
923: THEN
924: INV_Trolin_Util.Clear_Dependent_Attr
925: ( p_attr_id => INV_Trolin_Util.G_LINE_NUMBER
926: , p_trolin_rec => g_trolin_rec
939: g_trolin_rec.line_status := Get_Line_Status;
940:
941: IF g_trolin_rec.line_status IS NOT NULL THEN
942:
943: IF INV_Validate_trolin.Line_Status(g_trolin_rec.line_status) = inv_validate_trolin.T
944: THEN
945: INV_Trolin_Util.Clear_Dependent_Attr
946: ( p_attr_id => INV_Trolin_Util.G_LINE_STATUS
947: , p_trolin_rec => g_trolin_rec
973:
974: IF l_mov_order_type=INV_GLOBALS.g_move_order_put_away
975: THEN
976:
977: IF INV_Validate.Lot_Number(l_lot, l_org, l_item) = inv_validate.T THEN
978: INV_Trolin_Util.Clear_Dependent_Attr
979: ( p_attr_id => INV_Trolin_Util.G_LOT_NUMBER
980: , p_trolin_rec => g_trolin_rec
981: , x_trolin_rec => g_trolin_rec
985: END IF;
986:
987: ELSE
988:
989: IF INV_Validate.Lot_Number(l_lot,l_org,l_item,l_fsub,l_floc,g_trolin_rec.revision) = inv_validate.T
990: THEN
991: INV_Trolin_Util.Clear_Dependent_Attr
992: ( p_attr_id => INV_Trolin_Util.G_LOT_NUMBER
993: , p_trolin_rec => g_trolin_rec
1006: g_trolin_rec.project_id := Get_Project;
1007:
1008: IF g_trolin_rec.project_id IS NOT NULL THEN
1009:
1010: IF INV_Validate.Project(g_trolin_rec.project_id) = inv_validate.T
1011: THEN
1012: INV_Trolin_Util.Clear_Dependent_Attr
1013: ( p_attr_id => INV_Trolin_Util.G_PROJECT
1014: , p_trolin_rec => g_trolin_rec
1027: g_trolin_rec.quantity := Get_Quantity;
1028:
1029: IF g_trolin_rec.quantity IS NOT NULL THEN
1030:
1031: IF INV_Validate.Quantity(g_trolin_rec.quantity) = inv_validate.T
1032: THEN
1033: INV_Trolin_Util.Clear_Dependent_Attr
1034: ( p_attr_id => INV_Trolin_Util.G_QUANTITY
1035: , p_trolin_rec => g_trolin_rec
1049:
1050: IF g_trolin_rec.quantity_delivered IS NOT NULL THEN
1051:
1052: IF
1053: INV_Validate_trolin.Quantity_Delivered(g_trolin_rec.quantity_delivered) = inv_validate_trolin.T
1054: THEN
1055: INV_Trolin_Util.Clear_Dependent_Attr
1056: ( p_attr_id => INV_Trolin_Util.G_QUANTITY_DELIVERED
1057: , p_trolin_rec => g_trolin_rec
1071:
1072: IF g_trolin_rec.quantity_detailed IS NOT NULL THEN
1073:
1074: IF
1075: INV_Validate_trolin.Quantity_Detailed(g_trolin_rec.quantity_detailed) = inv_validate_trolin.T
1076: THEN
1077: INV_Trolin_Util.Clear_Dependent_Attr
1078: ( p_attr_id => INV_Trolin_Util.G_QUANTITY_DETAILED
1079: , p_trolin_rec => g_trolin_rec
1092: g_trolin_rec.reason_id := Get_Reason;
1093:
1094: IF g_trolin_rec.reason_id IS NOT NULL THEN
1095:
1096: IF INV_Validate.Reason(g_trolin_rec.reason_id) = inv_validate.T
1097: THEN
1098: INV_Trolin_Util.Clear_Dependent_Attr
1099: ( p_attr_id => INV_Trolin_Util.G_REASON
1100: , p_trolin_rec => g_trolin_rec
1113: g_trolin_rec.reference := Get_Reference;
1114:
1115: IF g_trolin_rec.reference IS NOT NULL THEN
1116:
1117: IF INV_Validate.Reference(g_trolin_rec.reference) = inv_validate.T
1118: THEN
1119: INV_Trolin_Util.Clear_Dependent_Attr
1120: ( p_attr_id => INV_Trolin_Util.G_REFERENCE
1121: , p_trolin_rec => g_trolin_rec
1135: g_trolin_rec.reference_id := Get_Reference;
1136:
1137: IF g_trolin_rec.reference_id IS NOT NULL THEN
1138:
1139: IF INV_Validate.Reference(g_trolin_rec.reference_id,g_trolin_rec.reference_type_code) = inv_validate.T
1140: THEN
1141: INV_Trolin_Util.Clear_Dependent_Attr
1142: ( p_attr_id => INV_Trolin_Util.G_REFERENCE
1143: , p_trolin_rec => g_trolin_rec
1157:
1158: IF g_trolin_rec.reference_type_code IS NOT NULL THEN
1159:
1160: IF
1161: INV_Validate.Reference_Type(g_trolin_rec.reference_type_code)
1162: = inv_validate.T
1163: THEN
1164: INV_Trolin_Util.Clear_Dependent_Attr
1165: ( p_attr_id => INV_Trolin_Util.G_REFERENCE_TYPE
1158: IF g_trolin_rec.reference_type_code IS NOT NULL THEN
1159:
1160: IF
1161: INV_Validate.Reference_Type(g_trolin_rec.reference_type_code)
1162: = inv_validate.T
1163: THEN
1164: INV_Trolin_Util.Clear_Dependent_Attr
1165: ( p_attr_id => INV_Trolin_Util.G_REFERENCE_TYPE
1166: , p_trolin_rec => g_trolin_rec
1179: g_trolin_rec.revision := Get_Revision;
1180:
1181: IF g_trolin_rec.revision IS NOT NULL THEN
1182:
1183: IF INV_Validate.Revision(g_trolin_rec.revision,l_org,l_item) = inv_validate.T
1184: THEN
1185: INV_Trolin_Util.Clear_Dependent_Attr
1186: ( p_attr_id => INV_Trolin_Util.G_REVISION
1187: , p_trolin_rec => g_trolin_rec
1203: IF g_trolin_rec.serial_number_end IS NOT NULL THEN
1204:
1205: l_serial.serial_number := g_trolin_rec.serial_number_end;
1206: IF
1207: INV_Validate.Serial_Number_End(l_serial,l_org,l_item,l_fsub,l_lot,l_floc,g_trolin_rec.revision) = inv_validate.T
1208: THEN
1209: INV_Trolin_Util.Clear_Dependent_Attr
1210: ( p_attr_id => INV_Trolin_Util.G_SERIAL_NUMBER_END
1211: , p_trolin_rec => g_trolin_rec
1227: IF g_trolin_rec.serial_number_start IS NOT NULL THEN
1228:
1229: l_serial.serial_number := g_trolin_rec.serial_number_start;
1230: IF
1231: INV_Validate.Serial_Number_Start(l_serial,l_org,l_item,l_fsub,l_lot,l_floc,g_trolin_rec.revision) = inv_validate.T
1232: THEN
1233: INV_Trolin_Util.Clear_Dependent_Attr
1234: ( p_attr_id => INV_Trolin_Util.G_SERIAL_NUMBER_START
1235: , p_trolin_rec => g_trolin_rec
1248: g_trolin_rec.status_date := Get_Status_Date;
1249:
1250: IF g_trolin_rec.status_date IS NOT NULL THEN
1251:
1252: IF INV_Validate_Trohdr.Status_Date(g_trolin_rec.status_date) = inv_validate_trohdr.T
1253: THEN
1254: INV_Trolin_Util.Clear_Dependent_Attr
1255: ( p_attr_id => INV_Trolin_Util.G_STATUS_DATE
1256: , p_trolin_rec => g_trolin_rec
1270: g_trolin_rec.task_id := Get_Task;
1271:
1272: IF g_trolin_rec.task_id IS NOT NULL THEN
1273:
1274: IF INV_Validate.Task(g_trolin_rec.task_id,g_trolin_rec.project_id) = inv_validate.T
1275: THEN
1276: INV_Trolin_Util.Clear_Dependent_Attr
1277: ( p_attr_id => INV_Trolin_Util.G_TASK
1278: , p_trolin_rec => g_trolin_rec
1292: g_trolin_rec.to_account_id := Get_To_Account;
1293:
1294: IF g_trolin_rec.to_account_id IS NOT NULL THEN
1295:
1296: IF INV_Validate.To_Account(g_trolin_rec.to_account_id) = inv_validate.T
1297: THEN
1298: INV_Trolin_Util.Clear_Dependent_Attr
1299: ( p_attr_id => INV_Trolin_Util.G_TO_ACCOUNT
1300: , p_trolin_rec => g_trolin_rec
1315:
1316: IF g_trolin_rec.to_locator_id IS NOT NULL THEN
1317: l_tloc.inventory_location_id := g_trolin_rec.to_locator_id;
1318: IF
1319: INV_Validate.To_Locator(l_tloc,l_org,l_item,l_tsub,g_trolin_rec.project_id, g_trolin_rec.task_id,l_trans.transaction_action_id) = inv_validate.T
1320: THEN
1321: INV_Trolin_Util.Clear_Dependent_Attr
1322: ( p_attr_id => INV_Trolin_Util.G_TO_LOCATOR
1323: , p_trolin_rec => g_trolin_rec
1339: IF g_trolin_rec.to_subinventory_code IS NOT NULL THEN
1340:
1341: l_tsub.secondary_inventory_name := g_trolin_rec.to_subinventory_code;
1342: IF
1343: INV_Validate.To_Subinventory(l_tsub,l_org,l_item,l_fsub,l_acct_txn) = inv_validate.T
1344: THEN
1345: INV_Trolin_Util.Clear_Dependent_Attr
1346: ( p_attr_id => INV_Trolin_Util.G_TO_SUBINVENTORY
1347: , p_trolin_rec => g_trolin_rec
1362:
1363: IF g_trolin_rec.to_subinventory_id IS NOT NULL THEN
1364: l_tsub.secondary_inventory_name := g_trolin_rec.to_subinventory_code;
1365: IF
1366: INV_Validate.To_Subinventory(l_tsub,l_org,l_item,l_fsub,l_acct_txn) = inv_validate.T
1367:
1368: THEN
1369: INV_Trolin_Util.Clear_Dependent_Attr
1370: ( p_attr_id => INV_Trolin_Util.G_TO_SUBINVENTORY
1386:
1387: IF g_trolin_rec.transaction_header_id IS NOT NULL THEN
1388:
1389: IF
1390: INV_Validate.Transaction_Header(g_trolin_rec.transaction_header_id) = inv_validate.T
1391: THEN
1392: INV_Trolin_Util.Clear_Dependent_Attr
1393: ( p_attr_id => INV_Trolin_Util.G_TRANSACTION_HEADER
1394: , p_trolin_rec => g_trolin_rec
1407: g_trolin_rec.uom_code := Get_Uom;
1408:
1409: IF g_trolin_rec.uom_code IS NOT NULL THEN
1410:
1411: IF INV_Validate.Uom(g_trolin_rec.uom_code, l_org, l_item) = inv_validate.T
1412: THEN
1413: INV_Trolin_Util.Clear_Dependent_Attr
1414: ( p_attr_id => INV_Trolin_Util.G_UOM
1415: , p_trolin_rec => g_trolin_rec
1429:
1430: IF g_trolin_rec.transaction_source_type_id = FND_API.G_MISS_NUM THEN
1431: g_trolin_rec.transaction_source_type_id := Get_Transaction_Source_Type_ID(g_trolin_rec.transaction_Type_id);
1432: IF g_trolin_rec.transaction_source_type_id IS NOT NULL THEN
1433: --IF INV_Validate.Transaction_Source_Type(g_trolin_rec.transaction_source_type_id)
1434: --THEN
1435: INV_Trolin_Util.Clear_Dependent_Attr
1436: ( p_attr_id => INV_Trolin_Util.G_TRANSACTION_SOURCE_TYPE_ID
1437: , p_trolin_rec => g_trolin_rec
1445:
1446: IF g_trolin_rec.txn_source_id = FND_API.G_MISS_NUM THEN
1447: g_trolin_rec.txn_source_id := Get_Txn_Source_ID;
1448: IF g_trolin_rec.txn_source_id IS NOT NULL THEN
1449: --IF INV_Validate.Txn_Source(g_trolin_rec.txn_source_id)
1450: --THEN
1451: INV_Trolin_Util.Clear_Dependent_Attr
1452: ( p_attr_id => INV_Trolin_Util.G_TXN_SOURCE_ID
1453: , p_trolin_rec => g_trolin_rec
1461:
1462: IF g_trolin_rec.txn_source_line_id = FND_API.G_MISS_NUM THEN
1463: g_trolin_rec.txn_source_line_id := Get_Txn_Source_Line_ID;
1464: IF g_trolin_rec.txn_source_line_id IS NOT NULL THEN
1465: --IF INV_Validate.Txn_Source_Line(g_trolin_rec.txn_source_line_id)
1466: --THEN
1467: INV_Trolin_Util.Clear_Dependent_Attr
1468: ( p_attr_id => INV_Trolin_Util.G_TXN_SOURCE_LINE_ID
1469: , p_trolin_rec => g_trolin_rec
1477:
1478: IF g_trolin_rec.txn_source_line_detail_id = FND_API.G_MISS_NUM THEN
1479: g_trolin_rec.txn_source_line_detail_id := Get_Txn_Source_Line_Detail_ID;
1480: IF g_trolin_rec.txn_source_line_detail_id IS NOT NULL THEN
1481: --IF INV_Validate.Txn_Source_Line_Detail(g_trolin_rec.txn_source_line_detail_id)
1482: --THEN
1483: INV_Trolin_Util.Clear_Dependent_Attr
1484: ( p_attr_id => INV_Trolin_Util.G_TXN_SOURCE_LINE_DETAIL_ID
1485: , p_trolin_rec => g_trolin_rec
1493:
1494: IF g_trolin_rec.primary_quantity = FND_API.G_MISS_NUM THEN
1495: g_trolin_rec.primary_quantity := Get_Primary_Quantity;
1496: IF g_trolin_rec.primary_quantity IS NOT NULL THEN
1497: --IF INV_Validate.Primary_Quantity(g_trolin_rec.primary_quantity)
1498: --THEN
1499: INV_Trolin_Util.Clear_Dependent_Attr
1500: ( p_attr_id => INV_Trolin_Util.G_PRIMARY_QUANTITY
1501: , p_trolin_rec => g_trolin_rec
1509:
1510: IF g_trolin_rec.to_organization_id = FND_API.G_MISS_NUM THEN
1511: g_trolin_rec.to_organization_id := Get_To_Organization_Id;
1512: IF g_trolin_rec.to_organization_id IS NOT NULL THEN
1513: --IF INV_Validate.To_Organization(g_trolin_rec.to_organization_id)
1514: --THEN
1515: INV_Trolin_Util.Clear_Dependent_Attr
1516: ( p_attr_id => INV_Trolin_Util.G_TO_ORGANIZATION_ID
1517: , p_trolin_rec => g_trolin_rec
1525:
1526: IF g_trolin_rec.pick_strategy_id = FND_API.G_MISS_NUM THEN
1527: g_trolin_rec.pick_strategy_id := Get_Pick_Strategy_Id;
1528: IF g_trolin_rec.pick_strategy_id IS NOT NULL THEN
1529: --IF INV_Validate.Pick_Strategy(g_trolin_rec.pick_strategy_id)
1530: --THEN
1531: INV_Trolin_Util.Clear_Dependent_Attr
1532: ( p_attr_id => INV_Trolin_Util.G_PICK_STRATEGY_ID
1533: , p_trolin_rec => g_trolin_rec
1541:
1542: IF g_trolin_rec.put_away_strategy_id = FND_API.G_MISS_NUM THEN
1543: g_trolin_rec.put_away_strategy_id := Get_Put_Away_Strategy_ID;
1544: IF g_trolin_rec.put_away_strategy_id IS NOT NULL THEN
1545: --IF INV_Validate.Put_Away_Strategy(g_trolin_rec.put_away_strategy_id)
1546: --THEN
1547: INV_Trolin_Util.Clear_Dependent_Attr
1548: ( p_attr_id => INV_Trolin_Util.G_PUT_AWAY_STRATEGY_ID
1549: , p_trolin_rec => g_trolin_rec
1560: g_trolin_rec.secondary_quantity := Get_Quantity;
1561:
1562: IF g_trolin_rec.secondary_quantity IS NOT NULL THEN
1563:
1564: IF INV_Validate.Secondary_Quantity(g_trolin_rec.quantity) = inv_validate.T
1565: THEN
1566: INV_Trolin_Util.Clear_Dependent_Attr
1567: ( p_attr_id => INV_Trolin_Util.G_SECONDARY_QUANTITY
1568: , p_trolin_rec => g_trolin_rec
1581:
1582: IF g_trolin_rec.secondary_quantity_delivered IS NOT NULL THEN
1583:
1584: IF
1585: INV_Validate_trolin.Secondary_Quantity_Delivered(g_trolin_rec.secondary_quantity_delivered) = inv_validate_trolin.T
1586: THEN
1587: INV_Trolin_Util.Clear_Dependent_Attr
1588: ( p_attr_id => INV_Trolin_Util.G_SECONDARY_QUANTITY_DELIVERED
1589: , p_trolin_rec => g_trolin_rec
1603:
1604: IF g_trolin_rec.secondary_quantity_detailed IS NOT NULL THEN
1605:
1606: IF
1607: INV_Validate_trolin.Secondary_Quantity_Detailed(g_trolin_rec.secondary_quantity_detailed) = inv_validate_trolin.T
1608: THEN
1609: INV_Trolin_Util.Clear_Dependent_Attr
1610: ( p_attr_id => INV_Trolin_Util.G_SECONDARY_QUANTITY_DETAILED
1611: , p_trolin_rec => g_trolin_rec
1624: g_trolin_rec.secondary_uom := Get_Secondary_Uom;
1625: /*
1626: IF g_trolin_rec.secondary_uom IS NOT NULL THEN
1627:
1628: IF INV_Validate.Secondary_Uom(g_trolin_rec.secondary_uom, l_org, l_item) = inv_validate.T
1629: THEN
1630: INV_Trolin_Util.Clear_Dependent_Attr
1631: ( p_attr_id => INV_Trolin_Util.G_SECONDARY_UOM
1632: , p_trolin_rec => g_trolin_rec
1650: g_trolin_rec.grade_code := Get_Grade_Code;
1651: /*
1652: IF g_trolin_rec.grade_code IS NOT NULL THEN
1653:
1654: IF INV_Validate.Grade_Code(g_trolin_rec.grade_code, l_org, l_item) = inv_validate.T
1655: THEN
1656: INV_Trolin_Util.Clear_Dependent_Attr
1657: ( p_attr_id => INV_Trolin_Util.G_GRADE_CODE
1658: , p_trolin_rec => g_trolin_rec