DBA Data[Home] [Help]

APPS.OKL_TQL_PVT dependencies on OKL_UTIL

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

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

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

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

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

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

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

342: BEGIN
343: -- initialize return status
344: x_return_status := OKC_API.G_RET_STS_SUCCESS;
345:
346: -- check org id validity using the generic function okl_util.check_org_id()
347: l_return_status := OKL_UTIL.check_org_id (p_tqlv_rec.org_id);
348:
349: IF ( l_return_status = OKC_API.G_RET_STS_ERROR) THEN
350: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

Line 347: l_return_status := OKL_UTIL.check_org_id (p_tqlv_rec.org_id);

343: -- initialize return status
344: x_return_status := OKC_API.G_RET_STS_SUCCESS;
345:
346: -- check org id validity using the generic function okl_util.check_org_id()
347: l_return_status := OKL_UTIL.check_org_id (p_tqlv_rec.org_id);
348:
349: IF ( l_return_status = OKC_API.G_RET_STS_ERROR) THEN
350: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
351: p_msg_name => g_invalid_value,

Line 460: l_return_status := okl_util.check_lookup_code

456:
457: BEGIN
458: IF (p_tqlv_rec.QTE_ID IS NOT NULL) THEN
459:
460: l_return_status := okl_util.check_lookup_code
461: ( p_lookup_type=>'OKL_QUOTE_LINE_TYPE'
462: , p_lookup_code=>p_tqlv_rec.qlt_code
463: );
464:

Line 580: -- check from domain values using the generic okl_util.check_domain_yn

576: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
577: BEGIN
578: x_return_status := OKC_API.G_RET_STS_SUCCESS;
579:
580: -- check from domain values using the generic okl_util.check_domain_yn
581: l_return_status := OKL_UTIL.check_domain_yn(p_tqlv_rec.modified_yn);
582:
583: IF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
584: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

Line 581: l_return_status := OKL_UTIL.check_domain_yn(p_tqlv_rec.modified_yn);

577: BEGIN
578: x_return_status := OKC_API.G_RET_STS_SUCCESS;
579:
580: -- check from domain values using the generic okl_util.check_domain_yn
581: l_return_status := OKL_UTIL.check_domain_yn(p_tqlv_rec.modified_yn);
582:
583: IF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
584: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
585: p_msg_name => g_invalid_value,

Line 632: -- check from domain values using the generic okl_util.check_domain_yn

628: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
629: BEGIN
630: x_return_status := OKC_API.G_RET_STS_SUCCESS;
631:
632: -- check from domain values using the generic okl_util.check_domain_yn
633: l_return_status := OKL_UTIL.check_domain_yn(p_tqlv_rec.taxed_yn);
634:
635: IF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
636: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

Line 633: l_return_status := OKL_UTIL.check_domain_yn(p_tqlv_rec.taxed_yn);

629: BEGIN
630: x_return_status := OKC_API.G_RET_STS_SUCCESS;
631:
632: -- check from domain values using the generic okl_util.check_domain_yn
633: l_return_status := OKL_UTIL.check_domain_yn(p_tqlv_rec.taxed_yn);
634:
635: IF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
636: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
637: p_msg_name => g_invalid_value,

Line 684: -- check from domain values using the generic okl_util.check_domain_yn

680: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
681: BEGIN
682: x_return_status := OKC_API.G_RET_STS_SUCCESS;
683:
684: -- check from domain values using the generic okl_util.check_domain_yn
685: l_return_status := OKL_UTIL.check_domain_yn(p_tqlv_rec.defaulted_yn);
686:
687: IF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
688: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

Line 685: l_return_status := OKL_UTIL.check_domain_yn(p_tqlv_rec.defaulted_yn);

681: BEGIN
682: x_return_status := OKC_API.G_RET_STS_SUCCESS;
683:
684: -- check from domain values using the generic okl_util.check_domain_yn
685: l_return_status := OKL_UTIL.check_domain_yn(p_tqlv_rec.defaulted_yn);
686:
687: IF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
688: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
689: p_msg_name => g_invalid_value,