[Home] [Help]
67: ELSE
68: BEGIN
69: SELECT lookup_code
70: INTO l_usage_code
71: FROM ar_lookups
72: WHERE lookup_type = 'HZ_GEOGRAPHY_USAGE'
73: AND lookup_code = p_address_usages_rec.usage_code;
74: EXCEPTION WHEN NO_DATA_FOUND THEN
75: x_return_status := FND_API.G_RET_STS_ERROR;