DBA Data[Home] [Help]

APPS.WMS_CONTAINER_PVT dependencies on INV_VALIDATE

Line 4825: IF (l_result = inv_validate.f) THEN

4821: l_lpn.lpn_id := p_lpn_id;
4822: l_lpn.license_plate_number := NULL;
4823: l_result := WMS_CONTAINER_PVT.validate_lpn(l_lpn, 1);
4824:
4825: IF (l_result = inv_validate.f) THEN
4826: IF (l_debug = 1) THEN
4827: mdebug(p_lpn_id || 'is an invalid lpn_id', G_ERROR);
4828: END IF;
4829: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');

Line 4864: IF (l_result = inv_validate.f) THEN

4860: l_progress := 'Validate Content LPN';
4861: l_content_lpn.lpn_id := p_content_lpn_id;
4862: l_result := WMS_CONTAINER_PVT.validate_lpn(l_content_lpn);
4863:
4864: IF (l_result = inv_validate.f) THEN
4865: IF (l_debug = 1) THEN
4866: mdebug(p_lpn_id || 'is an invalid lpn_id', G_ERROR);
4867: END IF;
4868: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_CONTENT_LPN');

Line 6674: l_source_item INV_Validate.ITEM;

6670: , p_qty_required OUT NOCOPY NUMBER
6671: ) IS
6672: l_api_name CONSTANT VARCHAR2(30) := 'Container_Required_Qty';
6673: l_api_version CONSTANT NUMBER := 1.0;
6674: l_source_item INV_Validate.ITEM;
6675: l_dest_cont_item INV_Validate.ITEM;
6676: l_cont_item INV_Validate.ITEM;
6677: l_org INV_Validate.ORG;
6678: l_result NUMBER;

Line 6675: l_dest_cont_item INV_Validate.ITEM;

6671: ) IS
6672: l_api_name CONSTANT VARCHAR2(30) := 'Container_Required_Qty';
6673: l_api_version CONSTANT NUMBER := 1.0;
6674: l_source_item INV_Validate.ITEM;
6675: l_dest_cont_item INV_Validate.ITEM;
6676: l_cont_item INV_Validate.ITEM;
6677: l_org INV_Validate.ORG;
6678: l_result NUMBER;
6679: l_max_load_quantity NUMBER;

Line 6676: l_cont_item INV_Validate.ITEM;

6672: l_api_name CONSTANT VARCHAR2(30) := 'Container_Required_Qty';
6673: l_api_version CONSTANT NUMBER := 1.0;
6674: l_source_item INV_Validate.ITEM;
6675: l_dest_cont_item INV_Validate.ITEM;
6676: l_cont_item INV_Validate.ITEM;
6677: l_org INV_Validate.ORG;
6678: l_result NUMBER;
6679: l_max_load_quantity NUMBER;
6680: l_qty_per_cont NUMBER;

Line 6677: l_org INV_Validate.ORG;

6673: l_api_version CONSTANT NUMBER := 1.0;
6674: l_source_item INV_Validate.ITEM;
6675: l_dest_cont_item INV_Validate.ITEM;
6676: l_cont_item INV_Validate.ITEM;
6677: l_org INV_Validate.ORG;
6678: l_result NUMBER;
6679: l_max_load_quantity NUMBER;
6680: l_qty_per_cont NUMBER;
6681: l_curr_min_container NUMBER;

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

6727: -- API body
6728:
6729: /* Validate Organization ID */
6730: l_org.organization_id := p_organization_id;
6731: l_result := INV_Validate.Organization(l_org);
6732: IF (l_result = INV_Validate.F) THEN
6733: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_ORG');
6734: FND_MSG_PUB.ADD;
6735: RAISE FND_API.G_EXC_ERROR;

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

6728:
6729: /* Validate Organization ID */
6730: l_org.organization_id := p_organization_id;
6731: l_result := INV_Validate.Organization(l_org);
6732: IF (l_result = INV_Validate.F) THEN
6733: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_ORG');
6734: FND_MSG_PUB.ADD;
6735: RAISE FND_API.G_EXC_ERROR;
6736: END IF;

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

6736: END IF;
6737:
6738: /* Validate Source item */
6739: l_source_item.inventory_item_id := p_source_item_id;
6740: l_result := INV_Validate.inventory_item(l_source_item, l_org);
6741: IF (l_result = INV_Validate.F) THEN
6742: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_ITEM');
6743: FND_MSG_PUB.ADD;
6744: RAISE FND_API.G_EXC_ERROR;

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

6737:
6738: /* Validate Source item */
6739: l_source_item.inventory_item_id := p_source_item_id;
6740: l_result := INV_Validate.inventory_item(l_source_item, l_org);
6741: IF (l_result = INV_Validate.F) THEN
6742: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_ITEM');
6743: FND_MSG_PUB.ADD;
6744: RAISE FND_API.G_EXC_ERROR;
6745: END IF;

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

6751: RAISE FND_API.G_EXC_ERROR;
6752: END IF;
6753:
6754: /* Validate Source UOM */
6755: l_result := INV_Validate.Uom(p_source_qty_uom, l_org, l_source_item);
6756: IF (l_result = INV_Validate.F) THEN
6757: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_SRC_UOM');
6758: FND_MSG_PUB.ADD;
6759: RAISE FND_API.G_EXC_ERROR;

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

6752: END IF;
6753:
6754: /* Validate Source UOM */
6755: l_result := INV_Validate.Uom(p_source_qty_uom, l_org, l_source_item);
6756: IF (l_result = INV_Validate.F) THEN
6757: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_SRC_UOM');
6758: FND_MSG_PUB.ADD;
6759: RAISE FND_API.G_EXC_ERROR;
6760: END IF;

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

6769: END IF;
6770:
6771: /* Validate Quantity Per Container UOM */
6772: IF (p_qty_per_cont IS NOT NULL) THEN
6773: l_result := INV_Validate.Uom(p_qty_per_cont_uom, l_org, l_source_item);
6774: IF (l_result = INV_Validate.F) THEN
6775: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVLD_QTY_PER_UOM');
6776: FND_MSG_PUB.ADD;
6777: RAISE FND_API.G_EXC_ERROR;

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

6770:
6771: /* Validate Quantity Per Container UOM */
6772: IF (p_qty_per_cont IS NOT NULL) THEN
6773: l_result := INV_Validate.Uom(p_qty_per_cont_uom, l_org, l_source_item);
6774: IF (l_result = INV_Validate.F) THEN
6775: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVLD_QTY_PER_UOM');
6776: FND_MSG_PUB.ADD;
6777: RAISE FND_API.G_EXC_ERROR;
6778: END IF;

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

6780:
6781: /* Validate Destination container item */
6782: IF (p_dest_cont_item_id IS NOT NULL) THEN
6783: l_dest_cont_item.inventory_item_id := p_dest_cont_item_id;
6784: l_result := INV_Validate.inventory_item(l_dest_cont_item, l_org);
6785: IF (l_result = INV_Validate.F) THEN
6786: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_CONT_ITEM');
6787: FND_MSG_PUB.ADD;
6788: RAISE FND_API.G_EXC_ERROR;

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

6781: /* Validate Destination container item */
6782: IF (p_dest_cont_item_id IS NOT NULL) THEN
6783: l_dest_cont_item.inventory_item_id := p_dest_cont_item_id;
6784: l_result := INV_Validate.inventory_item(l_dest_cont_item, l_org);
6785: IF (l_result = INV_Validate.F) THEN
6786: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_CONT_ITEM');
6787: FND_MSG_PUB.ADD;
6788: RAISE FND_API.G_EXC_ERROR;
6789: ELSIF (l_dest_cont_item.container_item_flag = 'N') THEN

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

6895: -- the given load_item_id
6896: FOR v_container_item IN container_items_cursor LOOP
6897: /* Get the item information for the current container item being considered */
6898: l_cont_item.inventory_item_id := v_container_item.container_item_id;
6899: l_result := INV_Validate.inventory_item(l_cont_item, l_org);
6900: IF (l_result = INV_Validate.F) THEN
6901: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_CONT_ITEM');
6902: FND_MSG_PUB.ADD;
6903: RAISE FND_API.G_EXC_ERROR;

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

6896: FOR v_container_item IN container_items_cursor LOOP
6897: /* Get the item information for the current container item being considered */
6898: l_cont_item.inventory_item_id := v_container_item.container_item_id;
6899: l_result := INV_Validate.inventory_item(l_cont_item, l_org);
6900: IF (l_result = INV_Validate.F) THEN
6901: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_CONT_ITEM');
6902: FND_MSG_PUB.ADD;
6903: RAISE FND_API.G_EXC_ERROR;
6904: END IF;