DBA Data[Home] [Help]

APPS.OKL_INR_PVT dependencies on OKL_UTIL

Line 574: x_return_status := Okl_Util.check_lookup_code('OKL_INSURANCE_ASSET_CLASS',p_inrv_rec.iac_code);

570: p_token1_value => 'Insurance Class');
571: --Notify caller of an error
572: x_return_status := Okc_Api.G_RET_STS_ERROR;
573: ELSE
574: x_return_status := Okl_Util.check_lookup_code('OKL_INSURANCE_ASSET_CLASS',p_inrv_rec.iac_code);
575: IF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
576: Okc_Api.set_message(p_app_name => G_APP_NAME,
577: p_msg_name => G_NO_PARENT_RECORD,
578: p_token1 => G_COL_NAME_TOKEN,

Line 627: x_return_status := Okl_Util.check_domain_amount(p_inrv_rec.coverage_max);

623: p_token1_value => 'Coverage');
624: -- Notify caller of an error
625: x_return_status := Okc_Api.G_RET_STS_ERROR;
626: ELSE
627: x_return_status := Okl_Util.check_domain_amount(p_inrv_rec.coverage_max);
628: IF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
629: Okc_Api.set_message(p_app_name => G_APP_NAME,
630: p_msg_name => G_POSITIVE_NUMBER,
631: p_token1 => G_COL_NAME_TOKEN,

Line 679: x_return_status := Okl_Util.check_domain_amount(p_inrv_rec.deductible);

675: p_token1_value => 'Deductible');
676: -- Notify caller of an error
677: x_return_status := Okc_Api.G_RET_STS_ERROR;
678: ELSE
679: x_return_status := Okl_Util.check_domain_amount(p_inrv_rec.deductible);
680: IF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
681: Okc_Api.set_message(p_app_name => G_APP_NAME,
682: p_msg_name => G_POSITIVE_NUMBER,
683: p_token1 => G_COL_NAME_TOKEN,

Line 730: x_return_status := Okl_Util.check_domain_amount(p_inrv_rec.factor_range_start);

726: p_token1_value => 'Factor Min');
727: -- Notify caller of an error
728: x_return_status := Okc_Api.G_RET_STS_ERROR;
729: ELSE
730: x_return_status := Okl_Util.check_domain_amount(p_inrv_rec.factor_range_start);
731: IF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
732: Okc_Api.set_message(p_app_name => G_APP_NAME,
733: p_msg_name => G_POSITIVE_NUMBER,
734: p_token1 => G_COL_NAME_TOKEN,

Line 779: x_return_status := Okl_Util.check_domain_amount(p_inrv_rec.factor_range_end);

775: p_token1_value => 'Factor Max');
776: -- Notify caller of an error
777: x_return_status := Okc_Api.G_RET_STS_ERROR;
778: ELSE
779: x_return_status := Okl_Util.check_domain_amount(p_inrv_rec.factor_range_end);
780: IF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
781: Okc_Api.set_message(p_app_name => G_APP_NAME,
782: p_msg_name => G_POSITIVE_NUMBER,
783: p_token1 => G_COL_NAME_TOKEN,

Line 828: x_return_status := Okl_Util.check_domain_amount(p_inrv_rec.insurer_rate);

824: p_token1_value => 'Insurer Rate');
825: -- Notify caller of an error
826: x_return_status := Okc_Api.G_RET_STS_ERROR;
827: ELSE
828: x_return_status := Okl_Util.check_domain_amount(p_inrv_rec.insurer_rate);
829: IF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
830: Okc_Api.set_message(p_app_name => G_APP_NAME,
831: p_msg_name => G_POSITIVE_NUMBER,
832: p_token1 => G_COL_NAME_TOKEN,

Line 877: x_return_status := Okl_Util.check_domain_amount(p_inrv_rec.insured_rate);

873: p_token1_value => 'Lessee Rate');
874: -- Notify caller of an error
875: x_return_status := Okc_Api.G_RET_STS_ERROR;
876: ELSE
877: x_return_status := Okl_Util.check_domain_amount(p_inrv_rec.insured_rate);
878: IF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
879: Okc_Api.set_message(p_app_name => G_APP_NAME,
880: p_msg_name => G_POSITIVE_NUMBER,
881: p_token1 => G_COL_NAME_TOKEN,

Line 1472: l_return_status := okl_util.check_from_to_number_range(p_from_number =>p_inrv_rec.factor_range_start ,

1468: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1469: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1470: BEGIN
1471: -- call inr factor Range column_level validation
1472: l_return_status := okl_util.check_from_to_number_range(p_from_number =>p_inrv_rec.factor_range_start ,
1473: p_to_number =>p_inrv_rec.factor_range_end );
1474: -- store the highest degree of error
1475: IF (l_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1476: Okc_Api.set_message(

Line 1536: l_return_status := Okl_Util.check_from_to_date_range(p_inrv_rec.date_from , p_inrv_rec.date_to);

1532: x_return_status := l_return_status; -- record that there was an error
1533: END IF;
1534: END IF;
1535: -- For Date Range
1536: l_return_status := Okl_Util.check_from_to_date_range(p_inrv_rec.date_from , p_inrv_rec.date_to);
1537: -- store the highest degree of error
1538: IF (l_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1539: Okc_Api.set_message(
1540: p_app_name => g_app_name,

Line 1558: l_return_status := Okl_Util.check_from_to_date_range(Trunc(sysdate), p_inrv_rec.date_to );--Fix for Bug 3924176

1554: -- For Date Range
1555: IF( p_inrv_rec.date_to = NULL OR p_inrv_rec.date_to = OKC_API.G_MISS_DATE ) THEN
1556: NULL;
1557: ELSE
1558: l_return_status := Okl_Util.check_from_to_date_range(Trunc(sysdate), p_inrv_rec.date_to );--Fix for Bug 3924176
1559: -- store the highest degree of error
1560: IF (l_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1561: Okc_Api.set_message(
1562: p_app_name => g_app_name,