APPS.INV_LOC_WMS_PUB dependencies on MTL_UNITS_OF_MEASURE

Line 807: FROM mtl_units_of_measure

803: IF (p_location_weight_uom_code IS NOT NULL) THEN
804: BEGIN
805: SELECT 1
806: INTO l_chkflg
807: FROM mtl_units_of_measure
808: WHERE uom_code = p_location_weight_uom_code;
809: EXCEPTION
810: WHEN NO_DATA_FOUND THEN
811: fnd_message.set_name('INV', 'INV_IOI_WEIGHT_UOM_CODE');

Line 824: FROM mtl_units_of_measure

820: IF (p_volume_uom_code IS NOT NULL) THEN
821: BEGIN
822: SELECT 1
823: INTO l_chkflg
824: FROM mtl_units_of_measure
825: WHERE uom_code = p_volume_uom_code;
826: EXCEPTION
827: WHEN NO_DATA_FOUND THEN
828: fnd_message.set_name('INV', 'INV_IOI_VOLUME_UOM_CODE');

Line 839: FROM mtl_units_of_measure

835: IF (p_pick_uom_code IS NOT NULL) THEN
836: BEGIN
837: SELECT 1
838: INTO l_chkflg
839: FROM mtl_units_of_measure
840: WHERE uom_code = p_pick_uom_code;
841: EXCEPTION
842: WHEN NO_DATA_FOUND THEN
843: fnd_message.set_name('INV', 'INV_IOI_PICK_UOM_CODE');

Line 856: FROM mtl_units_of_measure

852: IF (p_dimension_uom_code IS NOT NULL) THEN
853: BEGIN
854: SELECT 1
855: INTO l_chkflg
856: FROM mtl_units_of_measure
857: WHERE uom_code = p_dimension_uom_code;
858: EXCEPTION
859: WHEN NO_DATA_FOUND THEN
860: fnd_message.set_name('INV', 'INV_IOI_DIMENSION_UOM_CODE');

Line 1650: FROM mtl_units_of_measure

1646: AND p_location_weight_uom_code IS NOT NULL) THEN
1647: BEGIN
1648: SELECT 1
1649: INTO l_chkflg
1650: FROM mtl_units_of_measure
1651: WHERE uom_code = p_location_weight_uom_code;
1652: EXCEPTION
1653: WHEN NO_DATA_FOUND THEN
1654: fnd_message.set_name('INV', 'INV_IOI_WEIGHT_UOM_CODE');

Line 1668: FROM mtl_units_of_measure

1664: AND p_volume_uom_code IS NOT NULL) THEN
1665: BEGIN
1666: SELECT 1
1667: INTO l_chkflg
1668: FROM mtl_units_of_measure
1669: WHERE uom_code = p_volume_uom_code;
1670: EXCEPTION
1671: WHEN NO_DATA_FOUND THEN
1672: fnd_message.set_name('INV', 'INV_IOI_WEIGHT_UOM_CODE');

Line 1685: FROM mtl_units_of_measure

1681: AND p_pick_uom_code IS NOT NULL) THEN
1682: BEGIN
1683: SELECT 1
1684: INTO l_chkflg
1685: FROM mtl_units_of_measure
1686: WHERE uom_code = p_pick_uom_code;
1687: EXCEPTION
1688: WHEN NO_DATA_FOUND THEN
1689: fnd_message.set_name('INV', 'INV_IOI_PICK_UOM_CODE ');

Line 1703: FROM mtl_units_of_measure

1699: AND p_dimension_uom_code IS NOT NULL) THEN
1700: BEGIN
1701: SELECT 1
1702: INTO l_chkflg
1703: FROM mtl_units_of_measure
1704: WHERE uom_code = p_dimension_uom_code;
1705: EXCEPTION
1706: WHEN NO_DATA_FOUND THEN
1707: fnd_message.set_name('INV', 'INV_IOI_DIMENSION_UOM_CODE');