APPS.OKL_ACN_PVT dependencies on OKL_UTIL

Line 140: -- check from currency values using the generic okl_util.validate_currency_code

136:
137: -- halt further validation of this column
138: RAISE G_EXCEPTION_HALT_VALIDATION;
139: END IF;
140: -- check from currency values using the generic okl_util.validate_currency_code
141: l_return_status := OKL_ACCOUNTING_UTIL.validate_currency_code(p_acnv_rec.currency_code);
142: IF (l_return_status <> OKC_API.G_TRUE) THEN
143:
144: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

Line 193: -- check from currency values using the generic okl_util.validate_currency_code

189: ,p_token1_value => 'currency_conversion_code');
190: -- halt further validation of this column
191: RAISE G_EXCEPTION_HALT_VALIDATION;
192: END IF;
193: -- check from currency values using the generic okl_util.validate_currency_code
194: l_return_status := OKL_ACCOUNTING_UTIL.validate_currency_code(p_acnv_rec.currency_conversion_code);
195: IF (l_return_status <> OKC_API.G_TRUE) THEN
196: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
197: p_msg_name => g_invalid_value,

Line 237: -- check from currency values using the generic okl_util.validate_currency_code

233: -- initialize return status
234: x_return_status := OKC_API.G_RET_STS_SUCCESS;
235: IF (p_acnv_rec.currency_conversion_type <> OKL_API.G_MISS_CHAR AND
236: p_acnv_rec.currency_conversion_type IS NOT NULL) THEN
237: -- check from currency values using the generic okl_util.validate_currency_code
238: l_return_status := OKL_ACCOUNTING_UTIL.validate_currency_con_type(p_acnv_rec.currency_conversion_type);
239: IF (l_return_status <> OKC_API.G_TRUE) THEN
240: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
241: p_msg_name => g_invalid_value,

Line 444: l_return_status := OKL_UTIL.check_lookup_code(

440: -- If value passed
441: IF p_acnv_rec.dty_code IS NOT NULL
442: AND p_acnv_rec.dty_code <> OKC_API.G_MISS_CHAR THEN
443:
444: l_return_status := OKL_UTIL.check_lookup_code(
445: p_lookup_type => 'OKL_DAMAGE_TYPE'
446: ,p_lookup_code => p_acnv_rec.dty_code);
447:
448: IF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 523: l_return_status := OKL_UTIL.check_lookup_code(

519: end if;
520:
521:
522: -- Foreign Key Validation
523: l_return_status := OKL_UTIL.check_lookup_code(
524: p_lookup_type => 'OKL_ASSET_CONDITION'
525: ,p_lookup_code => p_acnv_rec.cdn_code);
526:
527: IF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 598: l_return_status := OKL_UTIL.check_lookup_code(

594: raise G_EXCEPTION_HALT_VALIDATION;
595: end if;
596:
597: -- Foreign Key Validation
598: l_return_status := OKL_UTIL.check_lookup_code(
599: p_lookup_type => 'OKL_ASSET_CNDN_LINE_STATUS'
600: ,p_lookup_code => p_acnv_rec.acs_code);
601:
602: IF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 840: -- check org id validity using the generic function okl_util.check_org_id()

836: BEGIN
837: -- initialize return status
838: x_return_status := OKC_API.G_RET_STS_SUCCESS;
839:
840: -- check org id validity using the generic function okl_util.check_org_id()
841: l_return_status := OKL_UTIL.check_org_id (p_acnv_rec.org_id);
842:
843: IF ( l_return_status = OKC_API.G_RET_STS_ERROR) THEN
844: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

Line 841: l_return_status := OKL_UTIL.check_org_id (p_acnv_rec.org_id);

837: -- initialize return status
838: x_return_status := OKC_API.G_RET_STS_SUCCESS;
839:
840: -- check org id validity using the generic function okl_util.check_org_id()
841: l_return_status := OKL_UTIL.check_org_id (p_acnv_rec.org_id);
842:
843: IF ( l_return_status = OKC_API.G_RET_STS_ERROR) THEN
844: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
845: p_msg_name => g_invalid_value,

Line 971: l_return_status := OKL_UTIL.check_lookup_code(

967: IF p_acnv_rec.ctp_code IS NOT NULL
968: AND p_acnv_rec.ctp_code <> OKC_API.G_MISS_CHAR THEN
969:
970: -- Foreign Key Validation
971: l_return_status := OKL_UTIL.check_lookup_code(
972: p_lookup_type => 'OKL_CLAIM_TYPE'
973: ,p_lookup_code => p_acnv_rec.ctp_code);
974:
975: IF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1171: l_return_status := OKL_UTIL.check_domain_yn(

1167: -- initialize return status
1168: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1169:
1170:
1171: l_return_status := OKL_UTIL.check_domain_yn(
1172: p_col_value => p_acnv_rec.approved_yn);
1173:
1174: IF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1175: OKC_API.SET_MESSAGE(p_app_name => g_app_name,