[Home] [Help]
654: x_return_status := OKC_API.G_RET_STS_SUCCESS;
655:
656: -- check from domain values using the generic
657: -- l_return_status := OKL_UTIL.check_domain_yn(p_fmav_rec.sfwt_flag);
658: l_return_status := OKL_ACCOUNTING_UTIL.validate_lookup_code('YES_NO',p_fmav_rec.sfwt_flag,0,0);
659: IF (l_return_status = OKC_API.G_FALSE) THEN
660: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
661: p_msg_name => g_invalid_value,
662: p_token1 => g_col_name_token,
708: x_return_status := OKC_API.G_RET_STS_SUCCESS;
709:
710: -- check from domain values using the generic
711: -- l_return_status := OKL_UTIL.check_domain_yn(p_fmav_rec.there_can_be_only_one_yn);
712: l_return_status := OKL_ACCOUNTING_UTIL.validate_lookup_code('YES_NO',p_fmav_rec.there_can_be_only_one_yn,0,0);
713: IF (l_return_status = OKC_API.G_FALSE) THEN
714: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
715: p_msg_name => g_invalid_value,
716: p_token1 => g_col_name_token,
859: l_row_not_found := okl_fndv_pk_csr%NOTFOUND;
860: CLOSE okl_fndv_pk_csr;
861: */
862:
863: l_row_found := OKL_ACCOUNTING_UTIL.validate_lookup_code('OKL_FORMULA_TYPE', p_fmav_rec.fyp_code);
864:
865: IF (l_row_found = OKL_API.G_FALSE) then
866: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'fyp_code');
867: x_return_status := OKC_API.G_RET_STS_ERROR;
924: p_token1_value => 'name' );
925: x_return_status := OKC_API.G_RET_STS_ERROR;
926: RAISE G_EXCEPTION_HALT_VALIDATION;
927: END IF;
928: p_fmav_rec.name := Okl_Accounting_Util.okl_upper(p_fmav_rec.name);
929:
930:
931: EXCEPTION
932: WHEN G_EXCEPTION_HALT_VALIDATION THEN