2231: oe_debug_pub.add('Blanket In validate CAT');
2232: end if;
2233: SELECT 'VALID'
2234: INTO l_dummy
2235: FROM MTL_CATEGORIES_VL
2236: WHERE CATEGORY_ID = p_inventory_item_id
2237: AND ENABLED_FLAG = 'Y';
2238:
2239: ELSE
2297: --bug5220335 moved the query under BEGIN-EXCEPTION-END
2298: BEGIN
2299: SELECT 'VALID'
2300: INTO l_dummy
2301: FROM MTL_CATEGORIES_VL
2302: WHERE CATEGORY_ID = p_inventory_item_id
2303: AND ENABLED_FLAG = 'Y';
2304: EXCEPTION
2305: WHEN OTHERS THEN