DBA Data[Home] [Help]

APPS.OKL_ART_PVT dependencies on OKL_UTIL

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

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

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

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

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

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

Line 571: l_return_status := OKL_UTIL.check_lookup_code(

567:
568: -- halt further validation of this column
569: raise G_EXCEPTION_HALT_VALIDATION;
570: end if;
571: l_return_status := OKL_UTIL.check_lookup_code(
572: p_lookup_type => 'OKL_ASSET_RETURN_STATUS'
573: ,p_lookup_code => p_artv_rec.ars_code);
574:
575: IF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 646: l_return_status := OKL_UTIL.check_lookup_code(

642: -- halt further validation of this column
643: raise G_EXCEPTION_HALT_VALIDATION;
644: end if;
645:
646: l_return_status := OKL_UTIL.check_lookup_code(
647: p_lookup_type => 'OKL_ASSET_RETURN_TYPE'
648: ,p_lookup_code => p_artv_rec.art1_code);
649:
650: IF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

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

704: BEGIN
705: -- intialize return status
706: x_return_status := OKC_API.G_RET_STS_SUCCESS;
707:
708: -- check from domain values using the generic okl_util.check_domain_yn
709: l_return_status := OKL_UTIL.check_domain_yn(p_artv_rec.relocate_asset_yn);
710:
711: IF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
712: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

Line 709: l_return_status := OKL_UTIL.check_domain_yn(p_artv_rec.relocate_asset_yn);

705: -- intialize return status
706: x_return_status := OKC_API.G_RET_STS_SUCCESS;
707:
708: -- check from domain values using the generic okl_util.check_domain_yn
709: l_return_status := OKL_UTIL.check_domain_yn(p_artv_rec.relocate_asset_yn);
710:
711: IF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
712: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
713: p_msg_name => g_invalid_value,

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

756: BEGIN
757: -- initialize return status
758: x_return_status := OKC_API.G_RET_STS_SUCCESS;
759:
760: -- check org id validity using the generic function okl_util.check_org_id()
761: l_return_status := OKL_UTIL.check_org_id (p_artv_rec.org_id);
762:
763: IF ( l_return_status = OKC_API.G_RET_STS_ERROR) THEN
764: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

Line 761: l_return_status := OKL_UTIL.check_org_id (p_artv_rec.org_id);

757: -- initialize return status
758: x_return_status := OKC_API.G_RET_STS_SUCCESS;
759:
760: -- check org id validity using the generic function okl_util.check_org_id()
761: l_return_status := OKL_UTIL.check_org_id (p_artv_rec.org_id);
762:
763: IF ( l_return_status = OKC_API.G_RET_STS_ERROR) THEN
764: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
765: p_msg_name => g_invalid_value,

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

1154: BEGIN
1155: -- initialize return status
1156: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1157:
1158: -- check from domain values using the generic okl_util.check_domain_yn
1159: l_return_status := OKL_UTIL.check_domain_yn(p_artv_rec.asset_relocated_yn);
1160:
1161: IF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1162: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

Line 1159: l_return_status := OKL_UTIL.check_domain_yn(p_artv_rec.asset_relocated_yn);

1155: -- initialize return status
1156: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1157:
1158: -- check from domain values using the generic okl_util.check_domain_yn
1159: l_return_status := OKL_UTIL.check_domain_yn(p_artv_rec.asset_relocated_yn);
1160:
1161: IF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1162: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1163: p_msg_name => g_invalid_value,

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

1213: BEGIN
1214: -- intialize return status
1215: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1216:
1217: -- check from domain values using the generic okl_util.check_domain_yn
1218: l_return_status := OKL_UTIL.check_domain_yn(p_artv_rec.commmercially_reas_sale_yn);
1219:
1220: IF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1221: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

Line 1218: l_return_status := OKL_UTIL.check_domain_yn(p_artv_rec.commmercially_reas_sale_yn);

1214: -- intialize return status
1215: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1216:
1217: -- check from domain values using the generic okl_util.check_domain_yn
1218: l_return_status := OKL_UTIL.check_domain_yn(p_artv_rec.commmercially_reas_sale_yn);
1219:
1220: IF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1221: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1222: p_msg_name => g_invalid_value,

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

1272: BEGIN
1273: -- intialize return status
1274: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1275:
1276: -- check from domain values using the generic okl_util.check_domain_yn
1277: l_return_status := OKL_UTIL.check_domain_yn(p_artv_rec.voluntary_yn);
1278:
1279: IF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1280: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

Line 1277: l_return_status := OKL_UTIL.check_domain_yn(p_artv_rec.voluntary_yn);

1273: -- intialize return status
1274: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1275:
1276: -- check from domain values using the generic okl_util.check_domain_yn
1277: l_return_status := OKL_UTIL.check_domain_yn(p_artv_rec.voluntary_yn);
1278:
1279: IF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1280: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1281: p_msg_name => g_invalid_value,

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

1332: BEGIN
1333: -- intialize return status
1334: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1335:
1336: -- check from domain values using the generic okl_util.check_domain_yn
1337: l_return_status := OKL_UTIL.check_domain_yn(p_artv_rec.repurchase_agmt_yn);
1338:
1339: IF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1340: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

Line 1337: l_return_status := OKL_UTIL.check_domain_yn(p_artv_rec.repurchase_agmt_yn);

1333: -- intialize return status
1334: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1335:
1336: -- check from domain values using the generic okl_util.check_domain_yn
1337: l_return_status := OKL_UTIL.check_domain_yn(p_artv_rec.repurchase_agmt_yn);
1338:
1339: IF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1340: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1341: p_msg_name => g_invalid_value,

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

1391: BEGIN
1392: -- intialize return status
1393: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1394:
1395: -- check from domain values using the generic okl_util.check_domain_yn
1396: l_return_status := OKL_UTIL.check_domain_yn(p_artv_rec.like_kind_yn);
1397:
1398: IF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1399: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

Line 1396: l_return_status := OKL_UTIL.check_domain_yn(p_artv_rec.like_kind_yn);

1392: -- intialize return status
1393: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1394:
1395: -- check from domain values using the generic okl_util.check_domain_yn
1396: l_return_status := OKL_UTIL.check_domain_yn(p_artv_rec.like_kind_yn);
1397:
1398: IF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1399: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1400: p_msg_name => g_invalid_value,