237: l_debug_level6);
238: END IF;
239:
240:
241: --Validate all PA_LOOKUPS values
242:
243: IF (x_return_status <> 'E') THEN
244: PA_CONTROL_ITEMS_PKG.INSERT_ROW (
245: p_ci_type_id
1908: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1909: RAISE;
1910: END ci_number_exists;
1911:
1912: -- Validates pa_lookups which has p_lookup_type and p_lookup_code
1913: --
1914: FUNCTION is_lookup_valid (p_lookup_type IN VARCHAR2
1915: ,p_lookup_code IN VARCHAR2)
1916: RETURN BOOLEAN
1919: BEGIN
1920:
1921: SELECT meaning
1922: INTO l_meaning
1923: FROM pa_lookups
1924: WHERE lookup_type = p_lookup_type
1925: AND lookup_code = p_lookup_code;
1926:
1927: return TRUE;