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_IPY_PVT dependencies on OKL_UTIL

Line 1860: -- x_return_status := OKL_UTIL.check_domain_yn(p_ipyv_rec.quote_yn);

1856: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1857: BEGIN
1858: -- initialize return status
1859: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1860: -- x_return_status := OKL_UTIL.check_domain_yn(p_ipyv_rec.quote_yn);
1861: -- data is required
1862: IF ( ( p_ipyv_rec.quote_yn IS NOT NULL) OR (p_ipyv_rec.quote_yn = OKC_API.G_MISS_CHAR)) THEN
1863: IF UPPER(p_ipyv_rec.quote_yn) NOT IN ('Y','N') THEN
1864: x_return_status:=OKC_API.G_RET_STS_ERROR;

Line 1889: -- x_return_status := OKL_UTIL.check_domain_yn(p_ipyv_rec.quote_yn);

1885: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1886: BEGIN
1887: -- initialize return status
1888: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1889: -- x_return_status := OKL_UTIL.check_domain_yn(p_ipyv_rec.quote_yn);
1890: -- data is required
1891: IF (p_ipyv_rec.quote_yn = OKC_API.G_MISS_CHAR)THEN
1892: IF UPPER(p_ipyv_rec.quote_yn) NOT IN ('NO') THEN
1893: x_return_status:=OKC_API.G_RET_STS_ERROR;

Line 1918: --x_return_status := OKL_UTIL.check_domain_yn(p_ipyv_rec.on_file_yn);

1914: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1915: BEGIN
1916: -- initialize return status
1917: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1918: --x_return_status := OKL_UTIL.check_domain_yn(p_ipyv_rec.on_file_yn);
1919: -- data is required
1920: IF UPPER(p_ipyv_rec.private_label_yn) NOT IN ('Y','N') THEN
1921: x_return_status:=OKC_API.G_RET_STS_ERROR;
1922: --set error message in message stack

Line 1962: x_return_status := Okl_Util.check_domain_amount(p_ipyv_rec.covered_amount);

1958: p_token1_value => 'Covered Amount');
1959: -- Notify caller of an error
1960: x_return_status := Okc_Api.G_RET_STS_ERROR;
1961: ELSE
1962: x_return_status := Okl_Util.check_domain_amount(p_ipyv_rec.covered_amount);
1963: IF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1964: Okc_Api.set_message(p_app_name => G_APP_NAME,
1965: p_msg_name => 'OKL_POSITIVE_NUMBER',
1966: p_token1 => G_COL_NAME_TOKEN,

Line 2010: x_return_status := Okl_Util.check_domain_amount(p_ipyv_rec.deductible);

2006: p_token1_value => 'Deductible');
2007: -- Notify caller of an error
2008: x_return_status := Okc_Api.G_RET_STS_ERROR;
2009: ELSE
2010: x_return_status := Okl_Util.check_domain_amount(p_ipyv_rec.deductible);
2011: IF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2012: Okc_Api.set_message(p_app_name => G_APP_NAME,
2013: p_msg_name => 'OKL_POSITIVE_NUMBER',
2014: p_token1 => G_COL_NAME_TOKEN,

Line 2064: --x_return_status := OKL_UTIL.check_domain_yn(p_ipyv_rec.private_label_yn );

2060: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2061: BEGIN
2062: -- initialize return status
2063: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2064: --x_return_status := OKL_UTIL.check_domain_yn(p_ipyv_rec.private_label_yn );
2065: -- data is required
2066: IF ( ( p_ipyv_rec.private_label_yn IS NULL) OR (p_ipyv_rec.private_label_yn = OKC_API.G_MISS_CHAR)) THEN
2067: OKC_API.set_message(G_APP_NAME, 'OKL_REQUIRED_VALUE',G_COL_NAME_TOKEN,
2068: 'Private Label Flag');

Line 2179: --x_return_status := OKL_UTIL.check_domain_yn(p_ipyv_rec.agent_yn );

2175: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2176: BEGIN
2177: -- initialize return status
2178: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2179: --x_return_status := OKL_UTIL.check_domain_yn(p_ipyv_rec.agent_yn );
2180: -- data is required
2181: IF ( p_ipyv_rec.agent_yn = OKC_API.G_MISS_CHAR) THEN
2182: OKC_API.set_message(G_APP_NAME, 'OKL_REQUIRED_VALUE',G_COL_NAME_TOKEN,
2183: 'Agent Flag');

Line 2971: l_return_status:= OKL_UTIL.check_from_to_date_range(p_from_date => p_ipyv_rec.date_from

2967: END IF;
2968: END IF;
2969: --Validate whether start date is less than the end date
2970: IF (l_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
2971: l_return_status:= OKL_UTIL.check_from_to_date_range(p_from_date => p_ipyv_rec.date_from
2972: ,p_to_date => p_ipyv_rec.date_to );
2973: IF (l_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2974: Okc_Api.set_message(
2975: p_app_name => g_app_name,