DBA Data[Home] [Help]

APPS.WMS_CONTAINER2_PUB dependencies on INV_VALIDATE

Line 101: IF (l_result = INV_Validate.F) THEN

97: /* Validate LPN */
98: l_lpn.lpn_id := p_lpn_id;
99: l_lpn.license_plate_number := NULL;
100: l_result := WMS_CONTAINER_PUB.Validate_LPN(l_lpn);
101: IF (l_result = INV_Validate.F) THEN
102: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_LPN');
103: FND_MSG_PUB.ADD;
104: RAISE FND_API.G_EXC_ERROR;
105: END IF;

Line 292: IF (l_result = INV_Validate.F) THEN

288: /* Validate LPN */
289: l_lpn.lpn_id := p_lpn_id;
290: l_lpn.license_plate_number := NULL;
291: l_result := WMS_CONTAINER_PUB.Validate_LPN(l_lpn);
292: IF (l_result = INV_Validate.F) THEN
293: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_LPN');
294: FND_MSG_PUB.ADD;
295: RAISE FND_API.G_EXC_ERROR;
296: END IF;

Line 547: IF (l_result = INV_Validate.F) THEN

543: /* Validate source LPN */
544: l_lpn_source.lpn_id := p_lpn_id_source;
545: l_lpn_source.license_plate_number := NULL;
546: l_result := WMS_CONTAINER_PUB.Validate_LPN(l_lpn_source);
547: IF (l_result = INV_Validate.F) THEN
548: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_LPN');
549: FND_MSG_PUB.ADD;
550: RAISE FND_API.G_EXC_ERROR;
551: END IF;

Line 557: IF (l_result = INV_Validate.F) THEN

553: /* Validate destination LPN */
554: l_lpn_dest.lpn_id := p_lpn_id_dest;
555: l_lpn_dest.license_plate_number := NULL;
556: l_result := WMS_CONTAINER_PUB.Validate_LPN(l_lpn_dest);
557: IF (l_result = INV_Validate.F) THEN
558: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_LPN');
559: FND_MSG_PUB.ADD;
560: RAISE FND_API.G_EXC_ERROR;
561: END IF;

Line 643: l_source_item INV_Validate.ITEM;

639: )
640: IS
641: l_api_name CONSTANT VARCHAR2(30) := 'Container_Required_Qty';
642: l_api_version CONSTANT NUMBER := 1.0;
643: l_source_item INV_Validate.ITEM;
644: l_dest_cont_item INV_Validate.ITEM;
645: l_cont_item INV_Validate.ITEM;
646: l_org INV_Validate.ORG;
647: l_result NUMBER;

Line 644: l_dest_cont_item INV_Validate.ITEM;

640: IS
641: l_api_name CONSTANT VARCHAR2(30) := 'Container_Required_Qty';
642: l_api_version CONSTANT NUMBER := 1.0;
643: l_source_item INV_Validate.ITEM;
644: l_dest_cont_item INV_Validate.ITEM;
645: l_cont_item INV_Validate.ITEM;
646: l_org INV_Validate.ORG;
647: l_result NUMBER;
648: l_max_load_quantity NUMBER;

Line 645: l_cont_item INV_Validate.ITEM;

641: l_api_name CONSTANT VARCHAR2(30) := 'Container_Required_Qty';
642: l_api_version CONSTANT NUMBER := 1.0;
643: l_source_item INV_Validate.ITEM;
644: l_dest_cont_item INV_Validate.ITEM;
645: l_cont_item INV_Validate.ITEM;
646: l_org INV_Validate.ORG;
647: l_result NUMBER;
648: l_max_load_quantity NUMBER;
649: l_qty_per_cont NUMBER;

Line 646: l_org INV_Validate.ORG;

642: l_api_version CONSTANT NUMBER := 1.0;
643: l_source_item INV_Validate.ITEM;
644: l_dest_cont_item INV_Validate.ITEM;
645: l_cont_item INV_Validate.ITEM;
646: l_org INV_Validate.ORG;
647: l_result NUMBER;
648: l_max_load_quantity NUMBER;
649: l_qty_per_cont NUMBER;
650: l_curr_min_container NUMBER;

Line 701: l_result := INV_Validate.Organization(l_org);

697: /* Validate all inputs */
698:
699: /* Validate Organization ID */
700: l_org.organization_id := p_organization_id;
701: l_result := INV_Validate.Organization(l_org);
702: IF (l_result = INV_Validate.F) THEN
703: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_ORG');
704: FND_MSG_PUB.ADD;
705: RAISE FND_API.G_EXC_ERROR;

Line 702: IF (l_result = INV_Validate.F) THEN

698:
699: /* Validate Organization ID */
700: l_org.organization_id := p_organization_id;
701: l_result := INV_Validate.Organization(l_org);
702: IF (l_result = INV_Validate.F) THEN
703: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_ORG');
704: FND_MSG_PUB.ADD;
705: RAISE FND_API.G_EXC_ERROR;
706: END IF;

Line 710: l_result := INV_Validate.inventory_item(l_source_item, l_org);

706: END IF;
707:
708: /* Validate Source item */
709: l_source_item.inventory_item_id := p_source_item_id;
710: l_result := INV_Validate.inventory_item(l_source_item, l_org);
711: IF (l_result = INV_Validate.F) THEN
712: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_ITEM');
713: FND_MSG_PUB.ADD;
714: RAISE FND_API.G_EXC_ERROR;

Line 711: IF (l_result = INV_Validate.F) THEN

707:
708: /* Validate Source item */
709: l_source_item.inventory_item_id := p_source_item_id;
710: l_result := INV_Validate.inventory_item(l_source_item, l_org);
711: IF (l_result = INV_Validate.F) THEN
712: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_ITEM');
713: FND_MSG_PUB.ADD;
714: RAISE FND_API.G_EXC_ERROR;
715: END IF;

Line 725: l_result := INV_Validate.Uom(p_source_qty_uom, l_org, l_source_item);

721: RAISE FND_API.G_EXC_ERROR;
722: END IF;
723:
724: /* Validate Source UOM */
725: l_result := INV_Validate.Uom(p_source_qty_uom, l_org, l_source_item);
726: IF (l_result = INV_Validate.F) THEN
727: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_SRC_UOM');
728: FND_MSG_PUB.ADD;
729: RAISE FND_API.G_EXC_ERROR;

Line 726: IF (l_result = INV_Validate.F) THEN

722: END IF;
723:
724: /* Validate Source UOM */
725: l_result := INV_Validate.Uom(p_source_qty_uom, l_org, l_source_item);
726: IF (l_result = INV_Validate.F) THEN
727: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_SRC_UOM');
728: FND_MSG_PUB.ADD;
729: RAISE FND_API.G_EXC_ERROR;
730: END IF;

Line 743: l_result := INV_Validate.Uom(p_qty_per_cont_uom, l_org, l_source_item);

739: END IF;
740:
741: /* Validate Quantity Per Container UOM */
742: IF (p_qty_per_cont IS NOT NULL) THEN
743: l_result := INV_Validate.Uom(p_qty_per_cont_uom, l_org, l_source_item);
744: IF (l_result = INV_Validate.F) THEN
745: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVLD_QTY_PER_UOM');
746: FND_MSG_PUB.ADD;
747: RAISE FND_API.G_EXC_ERROR;

Line 744: IF (l_result = INV_Validate.F) THEN

740:
741: /* Validate Quantity Per Container UOM */
742: IF (p_qty_per_cont IS NOT NULL) THEN
743: l_result := INV_Validate.Uom(p_qty_per_cont_uom, l_org, l_source_item);
744: IF (l_result = INV_Validate.F) THEN
745: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVLD_QTY_PER_UOM');
746: FND_MSG_PUB.ADD;
747: RAISE FND_API.G_EXC_ERROR;
748: END IF;

Line 754: l_result := INV_Validate.inventory_item(l_dest_cont_item, l_org);

750:
751: /* Validate Destination container item */
752: IF (p_dest_cont_item_id IS NOT NULL) THEN
753: l_dest_cont_item.inventory_item_id := p_dest_cont_item_id;
754: l_result := INV_Validate.inventory_item(l_dest_cont_item, l_org);
755: IF (l_result = INV_Validate.F) THEN
756: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_CONT_ITEM');
757: FND_MSG_PUB.ADD;
758: RAISE FND_API.G_EXC_ERROR;

Line 755: IF (l_result = INV_Validate.F) THEN

751: /* Validate Destination container item */
752: IF (p_dest_cont_item_id IS NOT NULL) THEN
753: l_dest_cont_item.inventory_item_id := p_dest_cont_item_id;
754: l_result := INV_Validate.inventory_item(l_dest_cont_item, l_org);
755: IF (l_result = INV_Validate.F) THEN
756: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_CONT_ITEM');
757: FND_MSG_PUB.ADD;
758: RAISE FND_API.G_EXC_ERROR;
759: ELSIF (l_dest_cont_item.container_item_flag = 'N') THEN

Line 889: l_result := INV_Validate.inventory_item(l_cont_item, l_org);

885: -- the given load_item_id
886: FOR v_container_item IN container_items_cursor LOOP
887: /* Get the item information for the current container item being considered */
888: l_cont_item.inventory_item_id := v_container_item.container_item_id;
889: l_result := INV_Validate.inventory_item(l_cont_item, l_org);
890: IF (l_result = INV_Validate.F) THEN
891: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_CONT_ITEM');
892: FND_MSG_PUB.ADD;
893: RAISE FND_API.G_EXC_ERROR;

Line 890: IF (l_result = INV_Validate.F) THEN

886: FOR v_container_item IN container_items_cursor LOOP
887: /* Get the item information for the current container item being considered */
888: l_cont_item.inventory_item_id := v_container_item.container_item_id;
889: l_result := INV_Validate.inventory_item(l_cont_item, l_org);
890: IF (l_result = INV_Validate.F) THEN
891: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_CONT_ITEM');
892: FND_MSG_PUB.ADD;
893: RAISE FND_API.G_EXC_ERROR;
894: END IF;

Line 1067: IF (l_result = INV_Validate.F) THEN

1063: IF (p_lpn_id IS NOT NULL) THEN
1064: l_lpn.lpn_id := p_lpn_id;
1065: l_lpn.license_plate_number := NULL;
1066: l_result := WMS_CONTAINER_PUB.Validate_LPN(l_lpn);
1067: IF (l_result = INV_Validate.F) THEN
1068: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_LPN');
1069: FND_MSG_PUB.ADD;
1070: RAISE FND_API.G_EXC_ERROR;
1071: END IF;

Line 1274: l_org INV_Validate.ORG;

1270: l_temp_record WMS_LICENSE_PLATE_NUMBERS%ROWTYPE;
1271: l_index BINARY_INTEGER := 1;
1272: l_list_index BINARY_INTEGER := 1;
1273: l_temp_lpn NUMBER;
1274: l_org INV_Validate.ORG;
1275: l_result NUMBER;
1276: l_single_item_flag INTEGER;
1277: l_dummy_lpn NUMBER;
1278: CURSOR item_cursor IS

Line 1314: l_result := INV_Validate.Organization(l_org);

1310: /* Validate all inputs */
1311:
1312: /* Validate Organization ID */
1313: l_org.organization_id := p_organization_id;
1314: l_result := INV_Validate.Organization(l_org);
1315: IF (l_result = INV_Validate.F) THEN
1316: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_ORG');
1317: FND_MSG_PUB.ADD;
1318: RAISE FND_API.G_EXC_ERROR;

Line 1315: IF (l_result = INV_Validate.F) THEN

1311:
1312: /* Validate Organization ID */
1313: l_org.organization_id := p_organization_id;
1314: l_result := INV_Validate.Organization(l_org);
1315: IF (l_result = INV_Validate.F) THEN
1316: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_ORG');
1317: FND_MSG_PUB.ADD;
1318: RAISE FND_API.G_EXC_ERROR;
1319: END IF;