APPS.OKC_SAC_PVT dependencies on OKC_UTIL

Line 294: x_return_status:=OKC_UTIL.check_lookup_code('OKC_ARTICLE_SET',p_sacv_rec.sat_code);

290: End If;
291:
292:
293: -- Check if the value is valid code from lookup table for Article Set
294: x_return_status:=OKC_UTIL.check_lookup_code('OKC_ARTICLE_SET',p_sacv_rec.sat_code);
295: If (x_return_status=OKC_API.G_RET_STS_ERROR) Then
296: --set error message in message stack
297: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
298: p_msg_name => G_INVALID_VALUE,

Line 352: x_return_status:=OKC_UTIL.check_lookup_code('OKC_PRICE_TYPE',p_sacv_rec.price_type);

348: RAISE G_EXCEPTION_HALT_VALIDATION;
349: End If;
350:
351: -- Check if the value is valid code from lookup table for price type
352: x_return_status:=OKC_UTIL.check_lookup_code('OKC_PRICE_TYPE',p_sacv_rec.price_type);
353: If (x_return_status=OKC_API.G_RET_STS_ERROR) Then
354: --set error message in message stack
355: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
356: p_msg_name => G_INVALID_VALUE,

Line 465: OKC_UTIL.ADD_VIEW(G_VIEW,x_return_status);

461: ) RETURN VARCHAR2 IS
462: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
463: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
464: BEGIN
465: OKC_UTIL.ADD_VIEW(G_VIEW,x_return_status);
466: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
467: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
468: l_return_status := x_return_status;
469: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 624: -- OKC_UTIL.check_comp_unique call earlier was not using

620: AND p_sacv_rec.price_type <> OKC_API.G_MISS_CHAR)
621: THEN
622: -- ---------------------------------------------------------------------
623: -- Bug 1636056 related changes - Shyam
624: -- OKC_UTIL.check_comp_unique call earlier was not using
625: -- the bind variables and parses everytime, replaced with
626: -- the explicit cursors above, for identical function to
627: -- check uniqueness for SAT_CODE + PRICE_TYPE in OKC_STD_ART_CLASSINGS_V
628: -- scs_code and price_type are mutually exclusive (in actual values)

Line 649: -- OKC_UTIL.check_comp_unique call is replaced with

645: ELSIF ( p_sacv_rec.scs_code IS NOT NULL
646: AND p_sacv_rec.scs_code <> OKC_API.G_MISS_CHAR)
647: THEN
648: -- ---------------------------------------------------------------------
649: -- OKC_UTIL.check_comp_unique call is replaced with
650: -- the explicit cursors above, for identical function to
651: -- check uniqueness for SAT_CODE + SCS_CODE in OKC_STD_ART_CLASSINGS_V
652: -- scs_code and price_type are mutually exclusive (in actual values)
653: -- ---------------------------------------------------------------------