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

Line 297: x_return_status := Okl_Util.check_domain_amount(p_iptv_rec.factor_min);

293: p_token1_value => 'Factor Minimum');
294: -- Notify caller of an error
295: x_return_status := Okc_Api.G_RET_STS_ERROR;
296: ELSE
297: x_return_status := Okl_Util.check_domain_amount(p_iptv_rec.factor_min);
298: IF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
299: Okc_Api.set_message(p_app_name => G_APP_NAME,
300: p_msg_name => 'OKL_POSITIVE_NUMBER',
301: p_token1 => G_COL_NAME_TOKEN,

Line 346: x_return_status := Okl_Util.check_domain_amount(p_iptv_rec.factor_max);

342: p_token1_value => 'Factor Maximum');
343: -- Notify caller of an error
344: x_return_status := Okc_Api.G_RET_STS_ERROR;
345: ELSE
346: x_return_status := Okl_Util.check_domain_amount(p_iptv_rec.factor_max);
347: IF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
348: Okc_Api.set_message(p_app_name => G_APP_NAME,
349: p_msg_name => 'OKL_POSITIVE_NUMBER',
350: p_token1 => G_COL_NAME_TOKEN,

Line 396: x_return_status := Okl_Util.check_domain_amount(p_iptv_rec.coverage_min);

392: x_return_status := Okc_Api.G_RET_STS_ERROR;
393: RAISE G_EXCEPTION_HALT_VALIDATION;
394: ELSE
395: IF (p_iptv_rec.coverage_min IS NOT NULL) THEN
396: x_return_status := Okl_Util.check_domain_amount(p_iptv_rec.coverage_min);
397: IF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
398: Okc_Api.set_message(p_app_name => G_APP_NAME,
399: p_msg_name => 'OKL_POSITIVE_NUMBER',
400: p_token1 => G_COL_NAME_TOKEN,

Line 449: x_return_status := Okl_Util.check_domain_amount(p_iptv_rec.coverage_max);

445: x_return_status := Okc_Api.G_RET_STS_ERROR;
446: RAISE G_EXCEPTION_HALT_VALIDATION;
447: ELSE
448: IF (p_iptv_rec.coverage_max IS NOT NULL) THEN
449: x_return_status := Okl_Util.check_domain_amount(p_iptv_rec.coverage_max);
450: IF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
451: Okc_Api.set_message(p_app_name => G_APP_NAME,
452: p_msg_name => 'OKL_POSITIVE_NUMBER',
453: p_token1 => G_COL_NAME_TOKEN,

Line 503: x_return_status := Okl_Util.check_domain_amount(p_iptv_rec.deal_months_min);

499: x_return_status := Okc_Api.G_RET_STS_ERROR;
500: RAISE G_EXCEPTION_HALT_VALIDATION;
501: ELSE
502: IF (p_iptv_rec.deal_months_min IS NOT NULL) THEN
503: x_return_status := Okl_Util.check_domain_amount(p_iptv_rec.deal_months_min);
504: IF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
505: Okc_Api.set_message(p_app_name => G_APP_NAME,
506: p_msg_name => 'OKL_POSITIVE_NUMBER',
507: p_token1 => G_COL_NAME_TOKEN,

Line 556: x_return_status := Okl_Util.check_domain_amount(p_iptv_rec.deal_months_max);

552: x_return_status := Okc_Api.G_RET_STS_ERROR;
553: RAISE G_EXCEPTION_HALT_VALIDATION;
554: ELSE
555: IF (p_iptv_rec.deal_months_min IS NOT NULL) THEN
556: x_return_status := Okl_Util.check_domain_amount(p_iptv_rec.deal_months_max);
557: IF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
558: Okc_Api.set_message(p_app_name => G_APP_NAME,
559: p_msg_name => 'OKL_POSITIVE_NUMBER',
560: p_token1 => G_COL_NAME_TOKEN,

Line 1874: l_return_status:= OKL_UTIL.check_from_to_date_range(p_from_date => p_iptv_rec.date_from

1870: -- is not null
1871:
1872: -- IF (l_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
1873: IF (p_iptv_rec.date_to IS NOT NULL)THEN
1874: l_return_status:= OKL_UTIL.check_from_to_date_range(p_from_date => p_iptv_rec.date_from
1875: ,p_to_date => p_iptv_rec.date_to );
1876: IF (l_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1877: Okc_Api.set_message(
1878: p_app_name => g_app_name,

Line 1900: l_return_status:= OKL_UTIL.check_from_to_date_range(p_from_date =>trunc(SYSDATE) -- Fix for bug 3924176.

1896: -- is not null
1897:
1898: -- IF (l_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
1899: IF (p_iptv_rec.date_to IS NOT NULL OR p_iptv_rec.date_to <> OKC_API.G_MISS_DATE)THEN
1900: l_return_status:= OKL_UTIL.check_from_to_date_range(p_from_date =>trunc(SYSDATE) -- Fix for bug 3924176.
1901: ,p_to_date => p_iptv_rec.date_to );
1902: IF (l_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1903: Okc_Api.set_message(
1904: p_app_name => g_app_name,

Line 1923: l_return_status:= OKL_UTIL.check_from_to_number_range( p_iptv_rec.factor_min

1919: -- validate whether factor_min is less than factor_max
1920: -- IF (l_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
1921: IF (p_iptv_rec.factor_min IS NOT NULL OR p_iptv_rec.factor_min <> OKC_API.G_MISS_NUM )THEN
1922: IF (p_iptv_rec.factor_max IS NOT NULL OR p_iptv_rec.factor_max <> OKC_API.G_MISS_NUM )THEN
1923: l_return_status:= OKL_UTIL.check_from_to_number_range( p_iptv_rec.factor_min
1924: ,p_iptv_rec.factor_max);
1925:
1926: IF (l_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1927: Okc_Api.set_message(

Line 1950: l_return_status:= OKL_UTIL.check_from_to_number_range( p_iptv_rec.coverage_min

1946: -- validate whether coverage_min is less than coverage_max
1947: -- IF (l_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
1948: IF (p_iptv_rec.coverage_min IS NOT NULL OR p_iptv_rec.coverage_min <> OKC_API.G_MISS_NUM )THEN
1949: IF (p_iptv_rec.coverage_max IS NOT NULL OR p_iptv_rec.coverage_max <> OKC_API.G_MISS_NUM )THEN
1950: l_return_status:= OKL_UTIL.check_from_to_number_range( p_iptv_rec.coverage_min
1951: , p_iptv_rec.coverage_max);
1952: IF (l_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1953: Okc_Api.set_message(
1954: p_app_name => g_app_name,

Line 1975: l_return_status:= OKL_UTIL.check_from_to_number_range( p_iptv_rec.deal_months_min

1971: -- validate whether deal_months_min is less than deal_max_months
1972: -- IF (l_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
1973: IF (p_iptv_rec.deal_months_min IS NOT NULL OR p_iptv_rec.deal_months_min <> OKC_API.G_MISS_NUM )THEN
1974: IF (p_iptv_rec.deal_months_max IS NOT NULL OR p_iptv_rec.deal_months_max <> OKC_API.G_MISS_NUM )THEN
1975: l_return_status:= OKL_UTIL.check_from_to_number_range( p_iptv_rec.deal_months_min
1976: , p_iptv_rec.deal_months_max);
1977: IF (l_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1978: Okc_Api.set_message(
1979: p_app_name => g_app_name,

Line 2085: l_return_status:= OKL_UTIL.check_from_to_date_range(p_from_date => p_iptv_rec.date_from

2081: l_dummy_var VARCHAR2(1) := '?';
2082: BEGIN
2083: --Validate whether start date is less than the end date
2084: IF (l_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
2085: l_return_status:= OKL_UTIL.check_from_to_date_range(p_from_date => p_iptv_rec.date_from
2086: ,p_to_date => p_iptv_rec.date_to );
2087: IF (l_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2088: Okc_Api.set_message(
2089: p_app_name => g_app_name,

Line 2110: l_return_status:= OKL_UTIL.check_from_to_date_range(p_from_date => trunc(SYSDATE) -- Fix for bug 3924176.

2106: -- is not null
2107:
2108: IF (l_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
2109: IF (p_iptv_rec.date_to IS NOT NULL OR p_iptv_rec.date_to <> OKC_API.G_MISS_DATE )THEN
2110: l_return_status:= OKL_UTIL.check_from_to_date_range(p_from_date => trunc(SYSDATE) -- Fix for bug 3924176.
2111: ,p_to_date => p_iptv_rec.date_to );
2112: IF (l_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2113: Okc_Api.set_message(
2114: p_app_name => g_app_name,