1997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1998: END IF;
1999: SELECT model_usage_id
2000: INTO v_usage_id
2001: FROM CZ_MODEL_USAGES
2002: WHERE LTRIM(RTRIM(UPPER(CZ_MODEL_USAGES.name))) = LTRIM(RTRIM(UPPER(p_usage_name)))
2003: AND cz_model_usages.in_use = '1';
2004:
2005: x_return_status := FND_API.G_RET_STS_SUCCESS;
1998: END IF;
1999: SELECT model_usage_id
2000: INTO v_usage_id
2001: FROM CZ_MODEL_USAGES
2002: WHERE LTRIM(RTRIM(UPPER(CZ_MODEL_USAGES.name))) = LTRIM(RTRIM(UPPER(p_usage_name)))
2003: AND cz_model_usages.in_use = '1';
2004:
2005: x_return_status := FND_API.G_RET_STS_SUCCESS;
2006: RETURN v_usage_id;
1999: SELECT model_usage_id
2000: INTO v_usage_id
2001: FROM CZ_MODEL_USAGES
2002: WHERE LTRIM(RTRIM(UPPER(CZ_MODEL_USAGES.name))) = LTRIM(RTRIM(UPPER(p_usage_name)))
2003: AND cz_model_usages.in_use = '1';
2004:
2005: x_return_status := FND_API.G_RET_STS_SUCCESS;
2006: RETURN v_usage_id;
2007: EXCEPTION