eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_INS_QUOTE_PVT dependencies on OKL_UTIL

Line 1937: x_return_status := Okl_Util.check_domain_amount(l_amount_due);

1933: p_token1_value => 'Premium');
1934: -- Notify caller of an error
1935: x_return_status := Okc_Api.G_RET_STS_ERROR;
1936: ELSE
1937: x_return_status := Okl_Util.check_domain_amount(l_amount_due);
1938: IF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1939: Okc_Api.set_message(p_app_name => G_APP_NAME,
1940: p_msg_name => 'OKL_POSITIVE_NUMBER',
1941: p_token1 => G_COL_NAME_TOKEN,

Line 2391: x_return_status:= OKL_UTIL.check_from_to_date_range( p_date_from ,p_date_to );

2387: l_ins_term NUMBER;
2388: BEGIN
2389: --first check the validity of dates from Policy
2390: --Validate whether start date is less than the end date
2391: x_return_status:= OKL_UTIL.check_from_to_date_range( p_date_from ,p_date_to );
2392: IF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2393: Okc_Api.set_message(
2394: p_app_name => g_app_name,
2395: p_msg_name => 'OKL_GREATER_THAN',

Line 2413: x_return_status:= OKL_UTIL.check_from_to_number_range( l_policy_term

2409: -- calculate the time period between start date and end date
2410: l_policy_term := MONTHS_BETWEEN(p_date_to,p_date_from);
2411: -- Check the contarct term is greater than policy term
2412: l_khr_term := MONTHS_BETWEEN(p_khr_date_to,p_khr_date_from);
2413: x_return_status:= OKL_UTIL.check_from_to_number_range( l_policy_term
2414: , l_khr_term);
2415: IF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2416: Okc_Api.set_message(
2417: p_app_name => g_app_name,

Line 4755: l_return_status := Okl_Util.check_lookup_code( G_FND_LOOKUP_PAYMENT_FREQ,px_ipyv_rec.ipf_code);

4751: x_return_status := OKC_API.G_RET_STS_ERROR;
4752: RAISE OKC_API.G_EXCEPTION_ERROR;
4753: -- Message --
4754: ELSE
4755: l_return_status := Okl_Util.check_lookup_code( G_FND_LOOKUP_PAYMENT_FREQ,px_ipyv_rec.ipf_code);
4756: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4757: x_return_status := l_return_status;
4758: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4759: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 4896: l_return_status:= Okl_Util.check_from_to_date_range( px_ipyv_rec.date_from

4892: x_return_status := OKC_API.G_RET_STS_ERROR;
4893: RAISE OKC_API.G_EXCEPTION_ERROR;
4894: END IF;
4895:
4896: l_return_status:= Okl_Util.check_from_to_date_range( px_ipyv_rec.date_from
4897: ,px_ipyv_rec.date_to );
4898: IF(l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
4899: -- store SQL error message on message stack for caller
4900: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,

Line 5424: l_return_status := Okl_Util.check_lookup_code( G_FND_LOOKUP_PAYMENT_FREQ,p_ipyv_rec.ipf_code);

5420: x_return_status := OKC_API.G_RET_STS_ERROR;
5421: RAISE OKC_API.G_EXCEPTION_ERROR;
5422: -- Message --
5423: ELSE
5424: l_return_status := Okl_Util.check_lookup_code( G_FND_LOOKUP_PAYMENT_FREQ,p_ipyv_rec.ipf_code);
5425: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5426: x_return_status := l_return_status;
5427: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5428: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 5472: l_return_status:= Okl_Util.check_from_to_date_range( p_ipyv_rec.date_from ,p_ipyv_rec.date_to );

5468: RAISE OKC_API.G_EXCEPTION_ERROR;
5469: END IF;
5470:
5471: --- From and To Date
5472: l_return_status:= Okl_Util.check_from_to_date_range( p_ipyv_rec.date_from ,p_ipyv_rec.date_to );
5473: IF(l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
5474: -- store SQL error message on message stack for caller
5475: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,
5476: SQLCODE, G_SQLERRM_TOKEN, SQLERRM);