DBA Data[Home] [Help]

APPS.WMS_CONTAINER_PVT dependencies on INV_VALIDATE

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

4370: l_lpn.lpn_id := p_lpn_id;
4371: l_lpn.license_plate_number := NULL;
4372: l_result := WMS_CONTAINER_PVT.validate_lpn(l_lpn, 1);
4373:
4374: IF (l_result = inv_validate.f) THEN
4375: IF (l_debug = 1) THEN
4376: mdebug(p_lpn_id || 'is an invalid lpn_id', G_ERROR);
4377: END IF;
4378: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');

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

4409: l_progress := 'Validate Content LPN';
4410: l_content_lpn.lpn_id := p_content_lpn_id;
4411: l_result := WMS_CONTAINER_PVT.validate_lpn(l_content_lpn);
4412:
4413: IF (l_result = inv_validate.f) THEN
4414: IF (l_debug = 1) THEN
4415: mdebug(p_lpn_id || 'is an invalid lpn_id', G_ERROR);
4416: END IF;
4417: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_CONTENT_LPN');

Line 6114: l_source_item INV_Validate.ITEM;

6110: , p_qty_required OUT NOCOPY NUMBER
6111: ) IS
6112: l_api_name CONSTANT VARCHAR2(30) := 'Container_Required_Qty';
6113: l_api_version CONSTANT NUMBER := 1.0;
6114: l_source_item INV_Validate.ITEM;
6115: l_dest_cont_item INV_Validate.ITEM;
6116: l_cont_item INV_Validate.ITEM;
6117: l_org INV_Validate.ORG;
6118: l_result NUMBER;

Line 6115: l_dest_cont_item INV_Validate.ITEM;

6111: ) IS
6112: l_api_name CONSTANT VARCHAR2(30) := 'Container_Required_Qty';
6113: l_api_version CONSTANT NUMBER := 1.0;
6114: l_source_item INV_Validate.ITEM;
6115: l_dest_cont_item INV_Validate.ITEM;
6116: l_cont_item INV_Validate.ITEM;
6117: l_org INV_Validate.ORG;
6118: l_result NUMBER;
6119: l_max_load_quantity NUMBER;

Line 6116: l_cont_item INV_Validate.ITEM;

6112: l_api_name CONSTANT VARCHAR2(30) := 'Container_Required_Qty';
6113: l_api_version CONSTANT NUMBER := 1.0;
6114: l_source_item INV_Validate.ITEM;
6115: l_dest_cont_item INV_Validate.ITEM;
6116: l_cont_item INV_Validate.ITEM;
6117: l_org INV_Validate.ORG;
6118: l_result NUMBER;
6119: l_max_load_quantity NUMBER;
6120: l_qty_per_cont NUMBER;

Line 6117: l_org INV_Validate.ORG;

6113: l_api_version CONSTANT NUMBER := 1.0;
6114: l_source_item INV_Validate.ITEM;
6115: l_dest_cont_item INV_Validate.ITEM;
6116: l_cont_item INV_Validate.ITEM;
6117: l_org INV_Validate.ORG;
6118: l_result NUMBER;
6119: l_max_load_quantity NUMBER;
6120: l_qty_per_cont NUMBER;
6121: l_curr_min_container NUMBER;

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

6167: -- API body
6168:
6169: /* Validate Organization ID */
6170: l_org.organization_id := p_organization_id;
6171: l_result := INV_Validate.Organization(l_org);
6172: IF (l_result = INV_Validate.F) THEN
6173: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_ORG');
6174: FND_MSG_PUB.ADD;
6175: RAISE FND_API.G_EXC_ERROR;

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

6168:
6169: /* Validate Organization ID */
6170: l_org.organization_id := p_organization_id;
6171: l_result := INV_Validate.Organization(l_org);
6172: IF (l_result = INV_Validate.F) THEN
6173: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_ORG');
6174: FND_MSG_PUB.ADD;
6175: RAISE FND_API.G_EXC_ERROR;
6176: END IF;

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

6176: END IF;
6177:
6178: /* Validate Source item */
6179: l_source_item.inventory_item_id := p_source_item_id;
6180: l_result := INV_Validate.inventory_item(l_source_item, l_org);
6181: IF (l_result = INV_Validate.F) THEN
6182: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_ITEM');
6183: FND_MSG_PUB.ADD;
6184: RAISE FND_API.G_EXC_ERROR;

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

6177:
6178: /* Validate Source item */
6179: l_source_item.inventory_item_id := p_source_item_id;
6180: l_result := INV_Validate.inventory_item(l_source_item, l_org);
6181: IF (l_result = INV_Validate.F) THEN
6182: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_ITEM');
6183: FND_MSG_PUB.ADD;
6184: RAISE FND_API.G_EXC_ERROR;
6185: END IF;

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

6191: RAISE FND_API.G_EXC_ERROR;
6192: END IF;
6193:
6194: /* Validate Source UOM */
6195: l_result := INV_Validate.Uom(p_source_qty_uom, l_org, l_source_item);
6196: IF (l_result = INV_Validate.F) THEN
6197: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_SRC_UOM');
6198: FND_MSG_PUB.ADD;
6199: RAISE FND_API.G_EXC_ERROR;

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

6192: END IF;
6193:
6194: /* Validate Source UOM */
6195: l_result := INV_Validate.Uom(p_source_qty_uom, l_org, l_source_item);
6196: IF (l_result = INV_Validate.F) THEN
6197: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_SRC_UOM');
6198: FND_MSG_PUB.ADD;
6199: RAISE FND_API.G_EXC_ERROR;
6200: END IF;

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

6209: END IF;
6210:
6211: /* Validate Quantity Per Container UOM */
6212: IF (p_qty_per_cont IS NOT NULL) THEN
6213: l_result := INV_Validate.Uom(p_qty_per_cont_uom, l_org, l_source_item);
6214: IF (l_result = INV_Validate.F) THEN
6215: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVLD_QTY_PER_UOM');
6216: FND_MSG_PUB.ADD;
6217: RAISE FND_API.G_EXC_ERROR;

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

6210:
6211: /* Validate Quantity Per Container UOM */
6212: IF (p_qty_per_cont IS NOT NULL) THEN
6213: l_result := INV_Validate.Uom(p_qty_per_cont_uom, l_org, l_source_item);
6214: IF (l_result = INV_Validate.F) THEN
6215: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVLD_QTY_PER_UOM');
6216: FND_MSG_PUB.ADD;
6217: RAISE FND_API.G_EXC_ERROR;
6218: END IF;

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

6220:
6221: /* Validate Destination container item */
6222: IF (p_dest_cont_item_id IS NOT NULL) THEN
6223: l_dest_cont_item.inventory_item_id := p_dest_cont_item_id;
6224: l_result := INV_Validate.inventory_item(l_dest_cont_item, l_org);
6225: IF (l_result = INV_Validate.F) THEN
6226: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_CONT_ITEM');
6227: FND_MSG_PUB.ADD;
6228: RAISE FND_API.G_EXC_ERROR;

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

6221: /* Validate Destination container item */
6222: IF (p_dest_cont_item_id IS NOT NULL) THEN
6223: l_dest_cont_item.inventory_item_id := p_dest_cont_item_id;
6224: l_result := INV_Validate.inventory_item(l_dest_cont_item, l_org);
6225: IF (l_result = INV_Validate.F) THEN
6226: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_CONT_ITEM');
6227: FND_MSG_PUB.ADD;
6228: RAISE FND_API.G_EXC_ERROR;
6229: ELSIF (l_dest_cont_item.container_item_flag = 'N') THEN

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

6335: -- the given load_item_id
6336: FOR v_container_item IN container_items_cursor LOOP
6337: /* Get the item information for the current container item being considered */
6338: l_cont_item.inventory_item_id := v_container_item.container_item_id;
6339: l_result := INV_Validate.inventory_item(l_cont_item, l_org);
6340: IF (l_result = INV_Validate.F) THEN
6341: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_CONT_ITEM');
6342: FND_MSG_PUB.ADD;
6343: RAISE FND_API.G_EXC_ERROR;

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

6336: FOR v_container_item IN container_items_cursor LOOP
6337: /* Get the item information for the current container item being considered */
6338: l_cont_item.inventory_item_id := v_container_item.container_item_id;
6339: l_result := INV_Validate.inventory_item(l_cont_item, l_org);
6340: IF (l_result = INV_Validate.F) THEN
6341: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_CONT_ITEM');
6342: FND_MSG_PUB.ADD;
6343: RAISE FND_API.G_EXC_ERROR;
6344: END IF;