APPS.INV_LOC_WMS_PUB dependencies on MTL_UNITS_OF_MEASURE

Line 749: FROM mtl_units_of_measure

745: IF (p_location_weight_uom_code IS NOT NULL) THEN
746: BEGIN
747: SELECT 1
748: INTO l_chkflg
749: FROM mtl_units_of_measure
750: WHERE uom_code = p_location_weight_uom_code;
751: EXCEPTION
752: WHEN NO_DATA_FOUND THEN
753: fnd_message.set_name('INV', 'INV_IOI_WEIGHT_UOM_CODE');

Line 766: FROM mtl_units_of_measure

762: IF (p_volume_uom_code IS NOT NULL) THEN
763: BEGIN
764: SELECT 1
765: INTO l_chkflg
766: FROM mtl_units_of_measure
767: WHERE uom_code = p_volume_uom_code;
768: EXCEPTION
769: WHEN NO_DATA_FOUND THEN
770: fnd_message.set_name('INV', 'INV_IOI_VOLUME_UOM_CODE');

Line 781: FROM mtl_units_of_measure

777: IF (p_pick_uom_code IS NOT NULL) THEN
778: BEGIN
779: SELECT 1
780: INTO l_chkflg
781: FROM mtl_units_of_measure
782: WHERE uom_code = p_pick_uom_code;
783: EXCEPTION
784: WHEN NO_DATA_FOUND THEN
785: fnd_message.set_name('INV', 'INV_IOI_PICK_UOM_CODE');

Line 798: FROM mtl_units_of_measure

794: IF (p_dimension_uom_code IS NOT NULL) THEN
795: BEGIN
796: SELECT 1
797: INTO l_chkflg
798: FROM mtl_units_of_measure
799: WHERE uom_code = p_dimension_uom_code;
800: EXCEPTION
801: WHEN NO_DATA_FOUND THEN
802: fnd_message.set_name('INV', 'INV_IOI_DIMENSION_UOM_CODE');

Line 1567: FROM mtl_units_of_measure

1563: AND p_location_weight_uom_code IS NOT NULL) THEN
1564: BEGIN
1565: SELECT 1
1566: INTO l_chkflg
1567: FROM mtl_units_of_measure
1568: WHERE uom_code = p_location_weight_uom_code;
1569: EXCEPTION
1570: WHEN NO_DATA_FOUND THEN
1571: fnd_message.set_name('INV', 'INV_IOI_WEIGHT_UOM_CODE');

Line 1585: FROM mtl_units_of_measure

1581: AND p_volume_uom_code IS NOT NULL) THEN
1582: BEGIN
1583: SELECT 1
1584: INTO l_chkflg
1585: FROM mtl_units_of_measure
1586: WHERE uom_code = p_volume_uom_code;
1587: EXCEPTION
1588: WHEN NO_DATA_FOUND THEN
1589: fnd_message.set_name('INV', 'INV_IOI_WEIGHT_UOM_CODE');

Line 1602: FROM mtl_units_of_measure

1598: AND p_pick_uom_code IS NOT NULL) THEN
1599: BEGIN
1600: SELECT 1
1601: INTO l_chkflg
1602: FROM mtl_units_of_measure
1603: WHERE uom_code = p_pick_uom_code;
1604: EXCEPTION
1605: WHEN NO_DATA_FOUND THEN
1606: fnd_message.set_name('INV', 'INV_IOI_PICK_UOM_CODE ');

Line 1620: FROM mtl_units_of_measure

1616: AND p_dimension_uom_code IS NOT NULL) THEN
1617: BEGIN
1618: SELECT 1
1619: INTO l_chkflg
1620: FROM mtl_units_of_measure
1621: WHERE uom_code = p_dimension_uom_code;
1622: EXCEPTION
1623: WHEN NO_DATA_FOUND THEN
1624: fnd_message.set_name('INV', 'INV_IOI_DIMENSION_UOM_CODE');