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_CONTRACT_TOP_LINE_PVT dependencies on OKL_API

Line 1091: If ( (NVL(l_clev_rec.start_date,OKL_API.G_MISS_DATE) <> OKL_API.G_MISS_DATE AND

1087: -- added below for bug 7323444 -- start
1088: For service_subline_rec In service_subline_csr(p_cle_id => l_clev_rec.id,
1089: p_chr_id => l_clev_rec.dnz_chr_id) Loop
1090:
1091: If ( (NVL(l_clev_rec.start_date,OKL_API.G_MISS_DATE) <> OKL_API.G_MISS_DATE AND
1092: service_subline_rec.start_date <> l_clev_rec.start_date) OR
1093: (NVL(l_clev_rec.end_date,OKL_API.G_MISS_DATE) <> OKL_API.G_MISS_DATE AND
1094: service_subline_rec.end_date <> l_clev_rec.end_date) ) Then
1095:

Line 1093: (NVL(l_clev_rec.end_date,OKL_API.G_MISS_DATE) <> OKL_API.G_MISS_DATE AND

1089: p_chr_id => l_clev_rec.dnz_chr_id) Loop
1090:
1091: If ( (NVL(l_clev_rec.start_date,OKL_API.G_MISS_DATE) <> OKL_API.G_MISS_DATE AND
1092: service_subline_rec.start_date <> l_clev_rec.start_date) OR
1093: (NVL(l_clev_rec.end_date,OKL_API.G_MISS_DATE) <> OKL_API.G_MISS_DATE AND
1094: service_subline_rec.end_date <> l_clev_rec.end_date) ) Then
1095:
1096: l_sub_clev_rec.id := service_subline_rec.id;
1097: l_sub_klev_rec.id := service_subline_rec.id;

Line 1113: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

1109: x_clev_rec => x_sub_clev_rec,
1110: x_klev_rec => x_sub_klev_rec
1111: );
1112:
1113: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1114: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1115: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1116: RAISE OKL_API.G_EXCEPTION_ERROR;
1117: END IF;

Line 1114: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1110: x_klev_rec => x_sub_klev_rec
1111: );
1112:
1113: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1114: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1115: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1116: RAISE OKL_API.G_EXCEPTION_ERROR;
1117: END IF;
1118: End If;

Line 1115: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

1111: );
1112:
1113: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1114: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1115: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1116: RAISE OKL_API.G_EXCEPTION_ERROR;
1117: END IF;
1118: End If;
1119: End Loop;

Line 1116: RAISE OKL_API.G_EXCEPTION_ERROR;

1112:
1113: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1114: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1115: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1116: RAISE OKL_API.G_EXCEPTION_ERROR;
1117: END IF;
1118: End If;
1119: End Loop;
1120:

Line 1158: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

1154: x_msg_data => x_msg_data,
1155: p_chr_id => x_clev_rec.dnz_chr_id,
1156: p_cle_id => x_clev_rec.id);
1157:
1158: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1159: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1160: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1161: raise OKL_API.G_EXCEPTION_ERROR;
1162: End If;

Line 1159: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1155: p_chr_id => x_clev_rec.dnz_chr_id,
1156: p_cle_id => x_clev_rec.id);
1157:
1158: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1159: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1160: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1161: raise OKL_API.G_EXCEPTION_ERROR;
1162: End If;
1163:

Line 1160: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

1156: p_cle_id => x_clev_rec.id);
1157:
1158: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1159: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1160: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1161: raise OKL_API.G_EXCEPTION_ERROR;
1162: End If;
1163:
1164: END IF;

Line 1161: raise OKL_API.G_EXCEPTION_ERROR;

1157:
1158: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1159: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1160: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1161: raise OKL_API.G_EXCEPTION_ERROR;
1162: End If;
1163:
1164: END IF;
1165: -- Bug# 6438785

Line 1741: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1737: -- End of comments
1738:
1739: PROCEDURE validate_fee_expense_rule(
1740: p_api_version IN NUMBER,
1741: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1742: x_return_status OUT NOCOPY VARCHAR2,
1743: x_msg_count OUT NOCOPY NUMBER,
1744: x_msg_data OUT NOCOPY VARCHAR2,
1745: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

Line 1818: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1814: x_klev_rec klev_rec_type ;
1815:
1816: BEGIN
1817:
1818: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1819:
1820: -- call START_ACTIVITY to create savepoint, check compatibility
1821: -- and initialize message list
1822: x_return_status := OKL_API.START_ACTIVITY(

Line 1822: x_return_status := OKL_API.START_ACTIVITY(

1818: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1819:
1820: -- call START_ACTIVITY to create savepoint, check compatibility
1821: -- and initialize message list
1822: x_return_status := OKL_API.START_ACTIVITY(
1823: p_api_name => l_api_name,
1824: p_pkg_name => G_PKG_NAME,
1825: p_init_msg_list => p_init_msg_list,
1826: l_api_version => l_api_version,

Line 1832: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

1828: p_api_type => G_API_TYPE,
1829: x_return_status => x_return_status);
1830:
1831: -- check if activity started successfully
1832: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1833: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1834: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1835: raise OKL_API.G_EXCEPTION_ERROR;
1836: END IF;

Line 1833: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1829: x_return_status => x_return_status);
1830:
1831: -- check if activity started successfully
1832: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1833: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1834: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1835: raise OKL_API.G_EXCEPTION_ERROR;
1836: END IF;
1837:

Line 1834: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

1830:
1831: -- check if activity started successfully
1832: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1833: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1834: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1835: raise OKL_API.G_EXCEPTION_ERROR;
1836: END IF;
1837:
1838: If(p_chr_id is null or p_chr_id = OKL_API.G_MISS_NUM) Then

Line 1835: raise OKL_API.G_EXCEPTION_ERROR;

1831: -- check if activity started successfully
1832: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1833: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1834: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1835: raise OKL_API.G_EXCEPTION_ERROR;
1836: END IF;
1837:
1838: If(p_chr_id is null or p_chr_id = OKL_API.G_MISS_NUM) Then
1839: x_return_status := OKL_API.g_ret_sts_error;

Line 1838: If(p_chr_id is null or p_chr_id = OKL_API.G_MISS_NUM) Then

1834: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1835: raise OKL_API.G_EXCEPTION_ERROR;
1836: END IF;
1837:
1838: If(p_chr_id is null or p_chr_id = OKL_API.G_MISS_NUM) Then
1839: x_return_status := OKL_API.g_ret_sts_error;
1840: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1841: , p_msg_name => 'OKL_INVALID_VALUE'
1842: , p_token1 => 'COL_NAME'

Line 1839: x_return_status := OKL_API.g_ret_sts_error;

1835: raise OKL_API.G_EXCEPTION_ERROR;
1836: END IF;
1837:
1838: If(p_chr_id is null or p_chr_id = OKL_API.G_MISS_NUM) Then
1839: x_return_status := OKL_API.g_ret_sts_error;
1840: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1841: , p_msg_name => 'OKL_INVALID_VALUE'
1842: , p_token1 => 'COL_NAME'
1843: , p_token1_value => 'CHR_ID'

Line 1840: OKL_API.SET_MESSAGE( p_app_name => g_app_name

1836: END IF;
1837:
1838: If(p_chr_id is null or p_chr_id = OKL_API.G_MISS_NUM) Then
1839: x_return_status := OKL_API.g_ret_sts_error;
1840: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1841: , p_msg_name => 'OKL_INVALID_VALUE'
1842: , p_token1 => 'COL_NAME'
1843: , p_token1_value => 'CHR_ID'
1844: );

Line 1845: raise OKL_API.G_EXCEPTION_ERROR;

1841: , p_msg_name => 'OKL_INVALID_VALUE'
1842: , p_token1 => 'COL_NAME'
1843: , p_token1_value => 'CHR_ID'
1844: );
1845: raise OKL_API.G_EXCEPTION_ERROR;
1846: End If;
1847:
1848:
1849: If(p_line_id is null or p_line_id = OKL_API.G_MISS_NUM) Then

Line 1849: If(p_line_id is null or p_line_id = OKL_API.G_MISS_NUM) Then

1845: raise OKL_API.G_EXCEPTION_ERROR;
1846: End If;
1847:
1848:
1849: If(p_line_id is null or p_line_id = OKL_API.G_MISS_NUM) Then
1850: x_return_status := OKL_API.g_ret_sts_error;
1851: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1852: , p_msg_name => 'OKL_INVALID_VALUE'
1853: , p_token1 => 'COL_NAME'

Line 1850: x_return_status := OKL_API.g_ret_sts_error;

1846: End If;
1847:
1848:
1849: If(p_line_id is null or p_line_id = OKL_API.G_MISS_NUM) Then
1850: x_return_status := OKL_API.g_ret_sts_error;
1851: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1852: , p_msg_name => 'OKL_INVALID_VALUE'
1853: , p_token1 => 'COL_NAME'
1854: , p_token1_value => 'CLE_ID'

Line 1851: OKL_API.SET_MESSAGE( p_app_name => g_app_name

1847:
1848:
1849: If(p_line_id is null or p_line_id = OKL_API.G_MISS_NUM) Then
1850: x_return_status := OKL_API.g_ret_sts_error;
1851: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1852: , p_msg_name => 'OKL_INVALID_VALUE'
1853: , p_token1 => 'COL_NAME'
1854: , p_token1_value => 'CLE_ID'
1855: );

Line 1856: raise OKL_API.G_EXCEPTION_ERROR;

1852: , p_msg_name => 'OKL_INVALID_VALUE'
1853: , p_token1 => 'COL_NAME'
1854: , p_token1_value => 'CLE_ID'
1855: );
1856: raise OKL_API.G_EXCEPTION_ERROR;
1857: End If;
1858:
1859: OPEN contract_csr (p_chr_id,
1860: p_line_id);

Line 1874: x_return_status := OKL_API.g_ret_sts_error;

1870: FETCH scscode_csr INTO scscode;
1871: CLOSE scscode_csr ;
1872: if(scscode='INVESTOR' and p_amount_per_period < 0) then
1873:
1874: x_return_status := OKL_API.g_ret_sts_error;
1875: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1876: , p_msg_name => 'OKL_PRDAMNT_CHCK'
1877: );
1878: raise OKL_API.G_EXCEPTION_ERROR;

Line 1875: OKL_API.SET_MESSAGE( p_app_name => g_app_name

1871: CLOSE scscode_csr ;
1872: if(scscode='INVESTOR' and p_amount_per_period < 0) then
1873:
1874: x_return_status := OKL_API.g_ret_sts_error;
1875: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1876: , p_msg_name => 'OKL_PRDAMNT_CHCK'
1877: );
1878: raise OKL_API.G_EXCEPTION_ERROR;
1879: End If;

Line 1878: raise OKL_API.G_EXCEPTION_ERROR;

1874: x_return_status := OKL_API.g_ret_sts_error;
1875: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1876: , p_msg_name => 'OKL_PRDAMNT_CHCK'
1877: );
1878: raise OKL_API.G_EXCEPTION_ERROR;
1879: End If;
1880:
1881: IF (l_line_type = 'FEE') THEN
1882:

Line 1883: If(p_no_of_period is null or p_no_of_period = OKL_API.G_MISS_NUM) Then

1879: End If;
1880:
1881: IF (l_line_type = 'FEE') THEN
1882:
1883: If(p_no_of_period is null or p_no_of_period = OKL_API.G_MISS_NUM) Then
1884: l_ak_prompt := GET_AK_PROMPT('OKL_LA_SERVICE_LINE', 'OKL_NO_OF_PERIOD');
1885: x_return_status := OKL_API.g_ret_sts_error;
1886: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1887: , p_msg_name => 'OKL_REQUIRED_VALUE'

Line 1885: x_return_status := OKL_API.g_ret_sts_error;

1881: IF (l_line_type = 'FEE') THEN
1882:
1883: If(p_no_of_period is null or p_no_of_period = OKL_API.G_MISS_NUM) Then
1884: l_ak_prompt := GET_AK_PROMPT('OKL_LA_SERVICE_LINE', 'OKL_NO_OF_PERIOD');
1885: x_return_status := OKL_API.g_ret_sts_error;
1886: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1887: , p_msg_name => 'OKL_REQUIRED_VALUE'
1888: , p_token1 => 'COL_NAME'
1889: , p_token1_value => l_ak_prompt

Line 1886: OKL_API.SET_MESSAGE( p_app_name => g_app_name

1882:
1883: If(p_no_of_period is null or p_no_of_period = OKL_API.G_MISS_NUM) Then
1884: l_ak_prompt := GET_AK_PROMPT('OKL_LA_SERVICE_LINE', 'OKL_NO_OF_PERIOD');
1885: x_return_status := OKL_API.g_ret_sts_error;
1886: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1887: , p_msg_name => 'OKL_REQUIRED_VALUE'
1888: , p_token1 => 'COL_NAME'
1889: , p_token1_value => l_ak_prompt
1890: );

Line 1891: raise OKL_API.G_EXCEPTION_ERROR;

1887: , p_msg_name => 'OKL_REQUIRED_VALUE'
1888: , p_token1 => 'COL_NAME'
1889: , p_token1_value => l_ak_prompt
1890: );
1891: raise OKL_API.G_EXCEPTION_ERROR;
1892: End If;
1893:
1894: If(p_amount_per_period is null or p_amount_per_period = OKL_API.G_MISS_NUM) Then
1895: l_ak_prompt := GET_AK_PROMPT('OKL_LA_SERVICE_LINE', 'OKL_AMT_PER_PERIOD');

Line 1894: If(p_amount_per_period is null or p_amount_per_period = OKL_API.G_MISS_NUM) Then

1890: );
1891: raise OKL_API.G_EXCEPTION_ERROR;
1892: End If;
1893:
1894: If(p_amount_per_period is null or p_amount_per_period = OKL_API.G_MISS_NUM) Then
1895: l_ak_prompt := GET_AK_PROMPT('OKL_LA_SERVICE_LINE', 'OKL_AMT_PER_PERIOD');
1896: x_return_status := OKL_API.g_ret_sts_error;
1897: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1898: , p_msg_name => 'OKL_REQUIRED_VALUE'

Line 1896: x_return_status := OKL_API.g_ret_sts_error;

1892: End If;
1893:
1894: If(p_amount_per_period is null or p_amount_per_period = OKL_API.G_MISS_NUM) Then
1895: l_ak_prompt := GET_AK_PROMPT('OKL_LA_SERVICE_LINE', 'OKL_AMT_PER_PERIOD');
1896: x_return_status := OKL_API.g_ret_sts_error;
1897: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1898: , p_msg_name => 'OKL_REQUIRED_VALUE'
1899: , p_token1 => 'COL_NAME'
1900: , p_token1_value => l_ak_prompt

Line 1897: OKL_API.SET_MESSAGE( p_app_name => g_app_name

1893:
1894: If(p_amount_per_period is null or p_amount_per_period = OKL_API.G_MISS_NUM) Then
1895: l_ak_prompt := GET_AK_PROMPT('OKL_LA_SERVICE_LINE', 'OKL_AMT_PER_PERIOD');
1896: x_return_status := OKL_API.g_ret_sts_error;
1897: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1898: , p_msg_name => 'OKL_REQUIRED_VALUE'
1899: , p_token1 => 'COL_NAME'
1900: , p_token1_value => l_ak_prompt
1901: );

Line 1902: raise OKL_API.G_EXCEPTION_ERROR;

1898: , p_msg_name => 'OKL_REQUIRED_VALUE'
1899: , p_token1 => 'COL_NAME'
1900: , p_token1_value => l_ak_prompt
1901: );
1902: raise OKL_API.G_EXCEPTION_ERROR;
1903: End If;
1904:
1905: If(p_frequency is null or p_frequency = OKL_API.G_MISS_CHAR) Then
1906: l_ak_prompt := GET_AK_PROMPT('OKL_LA_SERVICE_LINE', 'OKL_FREEQUENCY');

Line 1905: If(p_frequency is null or p_frequency = OKL_API.G_MISS_CHAR) Then

1901: );
1902: raise OKL_API.G_EXCEPTION_ERROR;
1903: End If;
1904:
1905: If(p_frequency is null or p_frequency = OKL_API.G_MISS_CHAR) Then
1906: l_ak_prompt := GET_AK_PROMPT('OKL_LA_SERVICE_LINE', 'OKL_FREEQUENCY');
1907: x_return_status := OKL_API.g_ret_sts_error;
1908: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1909: , p_msg_name => 'OKL_REQUIRED_VALUE'

Line 1907: x_return_status := OKL_API.g_ret_sts_error;

1903: End If;
1904:
1905: If(p_frequency is null or p_frequency = OKL_API.G_MISS_CHAR) Then
1906: l_ak_prompt := GET_AK_PROMPT('OKL_LA_SERVICE_LINE', 'OKL_FREEQUENCY');
1907: x_return_status := OKL_API.g_ret_sts_error;
1908: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1909: , p_msg_name => 'OKL_REQUIRED_VALUE'
1910: , p_token1 => 'COL_NAME'
1911: , p_token1_value => l_ak_prompt

Line 1908: OKL_API.SET_MESSAGE( p_app_name => g_app_name

1904:
1905: If(p_frequency is null or p_frequency = OKL_API.G_MISS_CHAR) Then
1906: l_ak_prompt := GET_AK_PROMPT('OKL_LA_SERVICE_LINE', 'OKL_FREEQUENCY');
1907: x_return_status := OKL_API.g_ret_sts_error;
1908: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1909: , p_msg_name => 'OKL_REQUIRED_VALUE'
1910: , p_token1 => 'COL_NAME'
1911: , p_token1_value => l_ak_prompt
1912: );

Line 1913: raise OKL_API.G_EXCEPTION_ERROR;

1909: , p_msg_name => 'OKL_REQUIRED_VALUE'
1910: , p_token1 => 'COL_NAME'
1911: , p_token1_value => l_ak_prompt
1912: );
1913: raise OKL_API.G_EXCEPTION_ERROR;
1914: End If;
1915:
1916: End If;
1917:

Line 1930: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1926: x_msg_count => x_msg_count,
1927: x_msg_data => x_msg_data,
1928: p_cle_id => p_line_id);
1929:
1930: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1931: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1932: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1933: RAISE OKL_API.G_EXCEPTION_ERROR;
1934: END IF;

Line 1931: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1927: x_msg_data => x_msg_data,
1928: p_cle_id => p_line_id);
1929:
1930: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1931: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1932: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1933: RAISE OKL_API.G_EXCEPTION_ERROR;
1934: END IF;
1935: --Bug# 4959361

Line 1932: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1928: p_cle_id => p_line_id);
1929:
1930: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1931: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1932: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1933: RAISE OKL_API.G_EXCEPTION_ERROR;
1934: END IF;
1935: --Bug# 4959361
1936:

Line 1933: RAISE OKL_API.G_EXCEPTION_ERROR;

1929:
1930: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1931: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1932: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1933: RAISE OKL_API.G_EXCEPTION_ERROR;
1934: END IF;
1935: --Bug# 4959361
1936:
1937: l_id1 := '?';

Line 1945: okl_api.set_message(

1941: FETCH freq_csr INTO l_id1;
1942: CLOSE freq_csr;
1943:
1944: IF (l_id1 = '?') THEN
1945: okl_api.set_message(
1946: G_APP_NAME,
1947: G_INVALID_VALUE,
1948: 'COL_NAME',
1949: 'FREQUENCY'

Line 1952: x_return_status := OKL_API.G_RET_STS_ERROR;

1948: 'COL_NAME',
1949: 'FREQUENCY'
1950: );
1951:
1952: x_return_status := OKL_API.G_RET_STS_ERROR;
1953: END IF;
1954:
1955: IF (p_no_of_period IS NULL) THEN
1956: okl_api.set_message(

Line 1956: okl_api.set_message(

1952: x_return_status := OKL_API.G_RET_STS_ERROR;
1953: END IF;
1954:
1955: IF (p_no_of_period IS NULL) THEN
1956: okl_api.set_message(
1957: G_APP_NAME,
1958: G_INCOMPLETE_RULE,
1959: 'COL_NAME',
1960: 'NO_OF_PERIOD'

Line 1963: x_return_status := OKL_API.G_RET_STS_ERROR;

1959: 'COL_NAME',
1960: 'NO_OF_PERIOD'
1961: );
1962:
1963: x_return_status := OKL_API.G_RET_STS_ERROR;
1964: ELSE
1965: IF (p_amount_per_period IS NULL) THEN
1966: okl_api.set_message(
1967: G_APP_NAME,

Line 1966: okl_api.set_message(

1962:
1963: x_return_status := OKL_API.G_RET_STS_ERROR;
1964: ELSE
1965: IF (p_amount_per_period IS NULL) THEN
1966: okl_api.set_message(
1967: G_APP_NAME,
1968: G_INCOMPLETE_RULE,
1969: 'COL_NAME',
1970: 'AMOUNT_PER_PERIOD'

Line 1973: x_return_status := OKL_API.G_RET_STS_ERROR;

1969: 'COL_NAME',
1970: 'AMOUNT_PER_PERIOD'
1971: );
1972:
1973: x_return_status := OKL_API.G_RET_STS_ERROR;
1974: END IF;
1975: END IF;
1976: ELSE
1977: okl_api.set_message(

Line 1977: okl_api.set_message(

1973: x_return_status := OKL_API.G_RET_STS_ERROR;
1974: END IF;
1975: END IF;
1976: ELSE
1977: okl_api.set_message(
1978: G_APP_NAME,
1979: G_INCOMPLETE_RULE,
1980: 'COL_NAME',
1981: 'FREQUENCY'

Line 1984: x_return_status := OKL_API.G_RET_STS_ERROR;

1980: 'COL_NAME',
1981: 'FREQUENCY'
1982: );
1983:
1984: x_return_status := OKL_API.G_RET_STS_ERROR;
1985: END IF;
1986:
1987: ELSIF (p_no_of_period IS NOT NULL
1988: OR

Line 1993: okl_api.set_message(

1989: p_frequency IS NOT NULL
1990: OR
1991: p_amount_per_period IS NOT NULL
1992: ) THEN
1993: okl_api.set_message(
1994: G_APP_NAME,
1995: G_INVALID_LINE_RULE,
1996: 'VALUE',
1997: 'FEE_NO_OF_PERIOD, FREQUENCY OR AMOUNT_PER_PERIOD',

Line 2004: x_return_status := OKL_API.G_RET_STS_ERROR;

2000: 'ACT_LINE_TYPE',
2001: 'FEE or SERVICE'
2002: );
2003:
2004: x_return_status := OKL_API.G_RET_STS_ERROR;
2005:
2006: END IF;
2007:
2008: -- cross validation

Line 2010: IF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

2006: END IF;
2007:
2008: -- cross validation
2009:
2010: IF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
2011:
2012: OPEN strm_cap_csr (p_chr_id,
2013: p_line_id);
2014: FETCH strm_cap_csr INTO l_cap_yn;

Line 2032: okl_api.set_message(

2028: l_mult_factor := 6;
2029: ELSIF (l_id1 = 'A') THEN
2030: l_mult_factor := 12;
2031: ELSE
2032: okl_api.set_message(
2033: G_APP_NAME,
2034: G_UOM_SETUP_ERROR,
2035: 'COL_VALUE',
2036: l_id1

Line 2038: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2034: G_UOM_SETUP_ERROR,
2035: 'COL_VALUE',
2036: l_id1
2037: );
2038: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2039: END IF;
2040:
2041: IF (l_end_date < (ADD_MONTHS(l_start_date, p_no_of_period * l_mult_factor)-1)) THEN
2042: okl_api.set_message(

Line 2042: okl_api.set_message(

2038: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2039: END IF;
2040:
2041: IF (l_end_date < (ADD_MONTHS(l_start_date, p_no_of_period * l_mult_factor)-1)) THEN
2042: okl_api.set_message(
2043: G_APP_NAME,
2044: G_INVALID_PERIOD,
2045: 'START_DATE',
2046: l_start_date,

Line 2050: RAISE OKL_API.G_EXCEPTION_ERROR;

2046: l_start_date,
2047: 'END_DATE',
2048: l_end_date
2049: );
2050: RAISE OKL_API.G_EXCEPTION_ERROR;
2051: END IF;
2052:
2053: If(l_fee_type is not null and (l_fee_type = G_FT_ABSORBED or l_fee_type = G_FT_FINANCED) and p_no_of_period <> 1) Then
2054: okl_api.set_message(

Line 2054: okl_api.set_message(

2050: RAISE OKL_API.G_EXCEPTION_ERROR;
2051: END IF;
2052:
2053: If(l_fee_type is not null and (l_fee_type = G_FT_ABSORBED or l_fee_type = G_FT_FINANCED) and p_no_of_period <> 1) Then
2054: okl_api.set_message(
2055: G_APP_NAME,
2056: G_INVALID_NO_OF_PAYMENTS
2057: );
2058: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 2058: RAISE OKL_API.G_EXCEPTION_ERROR;

2054: okl_api.set_message(
2055: G_APP_NAME,
2056: G_INVALID_NO_OF_PAYMENTS
2057: );
2058: RAISE OKL_API.G_EXCEPTION_ERROR;
2059: End If;
2060:
2061: -- this validation is commented for summing recurring exp amt to service/fee line
2062: /*

Line 2064: okl_api.set_message(

2060:
2061: -- this validation is commented for summing recurring exp amt to service/fee line
2062: /*
2063: IF (l_line_amount <> (p_amount_per_period * p_no_of_period)) THEN
2064: okl_api.set_message(
2065: G_APP_NAME,
2066: G_INVALID_EXP_AMOUNT
2067: );
2068: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 2068: RAISE OKL_API.G_EXCEPTION_ERROR;

2064: okl_api.set_message(
2065: G_APP_NAME,
2066: G_INVALID_EXP_AMOUNT
2067: );
2068: RAISE OKL_API.G_EXCEPTION_ERROR;
2069: END IF;
2070: */
2071: -- update line amount with recurring exp amount
2072:

Line 2087: x_return_status := OKL_API.g_ret_sts_error;

2083: l_klev_rec.capital_amount := l_line_amount;
2084: END IF;
2085:
2086: IF (l_line_type = 'FEE' and l_initial_direct_cost is not null and l_initial_direct_cost > l_klev_rec.amount) THEN
2087: x_return_status := OKL_API.g_ret_sts_error;
2088: OKL_API.SET_MESSAGE( p_app_name => g_app_name
2089: , p_msg_name => 'OKL_LLA_IDC_FEE'
2090: );
2091: raise OKL_API.G_EXCEPTION_ERROR;

Line 2088: OKL_API.SET_MESSAGE( p_app_name => g_app_name

2084: END IF;
2085:
2086: IF (l_line_type = 'FEE' and l_initial_direct_cost is not null and l_initial_direct_cost > l_klev_rec.amount) THEN
2087: x_return_status := OKL_API.g_ret_sts_error;
2088: OKL_API.SET_MESSAGE( p_app_name => g_app_name
2089: , p_msg_name => 'OKL_LLA_IDC_FEE'
2090: );
2091: raise OKL_API.G_EXCEPTION_ERROR;
2092: END IF;

Line 2091: raise OKL_API.G_EXCEPTION_ERROR;

2087: x_return_status := OKL_API.g_ret_sts_error;
2088: OKL_API.SET_MESSAGE( p_app_name => g_app_name
2089: , p_msg_name => 'OKL_LLA_IDC_FEE'
2090: );
2091: raise OKL_API.G_EXCEPTION_ERROR;
2092: END IF;
2093:
2094: okl_contract_pvt.update_contract_line(
2095: p_api_version => p_api_version,

Line 2106: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2102: x_clev_rec => x_clev_rec,
2103: x_klev_rec => x_klev_rec
2104: );
2105:
2106: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2107: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2108: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2109: raise OKL_API.G_EXCEPTION_ERROR;
2110: END IF;

Line 2107: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2103: x_klev_rec => x_klev_rec
2104: );
2105:
2106: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2107: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2108: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2109: raise OKL_API.G_EXCEPTION_ERROR;
2110: END IF;
2111:

Line 2108: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

2104: );
2105:
2106: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2107: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2108: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2109: raise OKL_API.G_EXCEPTION_ERROR;
2110: END IF;
2111:
2112: END IF;

Line 2109: raise OKL_API.G_EXCEPTION_ERROR;

2105:
2106: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2107: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2108: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2109: raise OKL_API.G_EXCEPTION_ERROR;
2110: END IF;
2111:
2112: END IF;
2113:

Line 2116: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2112: END IF;
2113:
2114: END IF;
2115:
2116: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2117:
2118:
2119: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2120: x_msg_data => x_msg_data);

Line 2119: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

2115:
2116: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2117:
2118:
2119: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2120: x_msg_data => x_msg_data);
2121:
2122: EXCEPTION
2123:

Line 2124: when OKL_API.G_EXCEPTION_ERROR then

2120: x_msg_data => x_msg_data);
2121:
2122: EXCEPTION
2123:
2124: when OKL_API.G_EXCEPTION_ERROR then
2125: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2126: p_api_name => l_api_name,
2127: p_pkg_name => G_PKG_NAME,
2128: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 2125: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2121:
2122: EXCEPTION
2123:
2124: when OKL_API.G_EXCEPTION_ERROR then
2125: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2126: p_api_name => l_api_name,
2127: p_pkg_name => G_PKG_NAME,
2128: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2129: x_msg_count => x_msg_count,

Line 2128: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

2124: when OKL_API.G_EXCEPTION_ERROR then
2125: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2126: p_api_name => l_api_name,
2127: p_pkg_name => G_PKG_NAME,
2128: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2129: x_msg_count => x_msg_count,
2130: x_msg_data => x_msg_data,
2131: p_api_type => G_API_TYPE);
2132:

Line 2133: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

2129: x_msg_count => x_msg_count,
2130: x_msg_data => x_msg_data,
2131: p_api_type => G_API_TYPE);
2132:
2133: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
2134: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2135: p_api_name => l_api_name,
2136: p_pkg_name => G_PKG_NAME,
2137: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2134: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2130: x_msg_data => x_msg_data,
2131: p_api_type => G_API_TYPE);
2132:
2133: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
2134: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2135: p_api_name => l_api_name,
2136: p_pkg_name => G_PKG_NAME,
2137: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2138: x_msg_count => x_msg_count,

Line 2137: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

2133: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
2134: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2135: p_api_name => l_api_name,
2136: p_pkg_name => G_PKG_NAME,
2137: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2138: x_msg_count => x_msg_count,
2139: x_msg_data => x_msg_data,
2140: p_api_type => G_API_TYPE);
2141:

Line 2143: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2139: x_msg_data => x_msg_data,
2140: p_api_type => G_API_TYPE);
2141:
2142: when OTHERS then
2143: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2144: p_api_name => l_api_name,
2145: p_pkg_name => G_PKG_NAME,
2146: p_exc_name => 'OTHERS',
2147: x_msg_count => x_msg_count,

Line 2164: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

2160: -- Version : 1.0
2161: -- End of comments
2162: PROCEDURE validate_passthru_rule(
2163: p_api_version IN NUMBER,
2164: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2165: x_return_status OUT NOCOPY VARCHAR2,
2166: x_msg_count OUT NOCOPY NUMBER,
2167: x_msg_data OUT NOCOPY VARCHAR2,
2168: p_line_id IN OKC_K_LINES_V.ID%TYPE,

Line 2181: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

2177: x_payment_method_id1 OUT NOCOPY VARCHAR2
2178: ) IS
2179:
2180: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CONTRACT_TOP_LINE_PVT';
2181: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
2182: G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
2183:
2184: G_INVALID_VALUE CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE';
2185: G_INVALID_LINE_RULE CONSTANT VARCHAR2(200) := 'OKL_LLA_INVALID_LINE_RULE';

Line 2243: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2239: l_line_type OKC_LINE_STYLES_B.LTY_CODE%TYPE;
2240:
2241: BEGIN
2242:
2243: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2244:
2245: -- call START_ACTIVITY to create savepoint, check compatibility
2246: -- and initialize message list
2247: x_return_status := OKL_API.START_ACTIVITY(

Line 2247: x_return_status := OKL_API.START_ACTIVITY(

2243: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2244:
2245: -- call START_ACTIVITY to create savepoint, check compatibility
2246: -- and initialize message list
2247: x_return_status := OKL_API.START_ACTIVITY(
2248: p_api_name => l_api_name,
2249: p_pkg_name => G_PKG_NAME,
2250: p_init_msg_list => p_init_msg_list,
2251: l_api_version => l_api_version,

Line 2257: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

2253: p_api_type => G_API_TYPE,
2254: x_return_status => x_return_status);
2255:
2256: -- check if activity started successfully
2257: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2258: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2259: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2260: raise OKL_API.G_EXCEPTION_ERROR;
2261: END IF;

Line 2258: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2254: x_return_status => x_return_status);
2255:
2256: -- check if activity started successfully
2257: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2258: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2259: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2260: raise OKL_API.G_EXCEPTION_ERROR;
2261: END IF;
2262:

Line 2259: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

2255:
2256: -- check if activity started successfully
2257: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2258: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2259: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2260: raise OKL_API.G_EXCEPTION_ERROR;
2261: END IF;
2262:
2263:

Line 2260: raise OKL_API.G_EXCEPTION_ERROR;

2256: -- check if activity started successfully
2257: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2258: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2259: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2260: raise OKL_API.G_EXCEPTION_ERROR;
2261: END IF;
2262:
2263:
2264: OPEN line_style_csr (p_line_id);

Line 2281: okl_api.set_message(

2277: FETCH pay_term_csr INTO l_id1;
2278: CLOSE pay_term_csr;
2279:
2280: IF (l_id1 = '?') THEN
2281: okl_api.set_message(
2282: G_APP_NAME,
2283: G_INVALID_VALUE,
2284: 'COL_NAME',
2285: 'PAYMENT_TERM'

Line 2288: x_return_status := OKL_API.G_RET_STS_ERROR;

2284: 'COL_NAME',
2285: 'PAYMENT_TERM'
2286: );
2287:
2288: x_return_status := OKL_API.G_RET_STS_ERROR;
2289: ELSE
2290: x_payment_term_id1 := l_id1;
2291: END IF;
2292:

Line 2307: okl_api.set_message(

2303: FETCH pay_site_csr INTO l_id1;
2304: CLOSE pay_site_csr;
2305:
2306: IF (l_id1 = '?') THEN
2307: okl_api.set_message(
2308: G_APP_NAME,
2309: G_INVALID_VALUE,
2310: 'COL_NAME',
2311: 'PAY_TO_SITE'

Line 2314: x_return_status := OKL_API.G_RET_STS_ERROR;

2310: 'COL_NAME',
2311: 'PAY_TO_SITE'
2312: );
2313:
2314: x_return_status := OKL_API.G_RET_STS_ERROR;
2315: ELSE
2316: x_pay_site_id1 := l_id1;
2317: END IF;
2318:

Line 2329: okl_api.set_message(

2325: FETCH pay_method_csr INTO l_id1;
2326: CLOSE pay_method_csr;
2327:
2328: IF (l_id1 = '?') THEN
2329: okl_api.set_message(
2330: G_APP_NAME,
2331: G_INVALID_VALUE,
2332: 'COL_NAME',
2333: 'PAYMENT_METHOD_CODE'

Line 2336: x_return_status := OKL_API.G_RET_STS_ERROR;

2332: 'COL_NAME',
2333: 'PAYMENT_METHOD_CODE'
2334: );
2335:
2336: x_return_status := OKL_API.G_RET_STS_ERROR;
2337: ELSE
2338: x_payment_method_id1 := l_id1;
2339: END IF;
2340: END IF;

Line 2352: okl_api.set_message(

2348: p_pay_to_site_id IS NOT NULL
2349: OR
2350: p_payment_method_code IS NOT NULL
2351: ) THEN
2352: okl_api.set_message(
2353: G_APP_NAME,
2354: G_INVALID_LINE_RULE,
2355: 'VALUE',
2356: 'PAYMENT_TERM, PAY_TO_SITE, PAYMENT_METHOD',

Line 2363: x_return_status := OKL_API.G_RET_STS_ERROR;

2359: 'ACT_LINE_TYPE',
2360: 'SERVICE or FEE'
2361: );
2362:
2363: x_return_status := OKL_API.G_RET_STS_ERROR;
2364:
2365: END IF;
2366:
2367: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 2367: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

2363: x_return_status := OKL_API.G_RET_STS_ERROR;
2364:
2365: END IF;
2366:
2367: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2368: x_msg_data => x_msg_data);
2369:
2370:
2371: RETURN;

Line 2374: when OKL_API.G_EXCEPTION_ERROR then

2370:
2371: RETURN;
2372:
2373: EXCEPTION
2374: when OKL_API.G_EXCEPTION_ERROR then
2375: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2376: p_api_name => l_api_name,
2377: p_pkg_name => G_PKG_NAME,
2378: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 2375: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2371: RETURN;
2372:
2373: EXCEPTION
2374: when OKL_API.G_EXCEPTION_ERROR then
2375: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2376: p_api_name => l_api_name,
2377: p_pkg_name => G_PKG_NAME,
2378: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2379: x_msg_count => x_msg_count,

Line 2378: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

2374: when OKL_API.G_EXCEPTION_ERROR then
2375: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2376: p_api_name => l_api_name,
2377: p_pkg_name => G_PKG_NAME,
2378: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2379: x_msg_count => x_msg_count,
2380: x_msg_data => x_msg_data,
2381: p_api_type => G_API_TYPE);
2382:

Line 2383: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

2379: x_msg_count => x_msg_count,
2380: x_msg_data => x_msg_data,
2381: p_api_type => G_API_TYPE);
2382:
2383: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
2384: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2385: p_api_name => l_api_name,
2386: p_pkg_name => G_PKG_NAME,
2387: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2384: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2380: x_msg_data => x_msg_data,
2381: p_api_type => G_API_TYPE);
2382:
2383: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
2384: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2385: p_api_name => l_api_name,
2386: p_pkg_name => G_PKG_NAME,
2387: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2388: x_msg_count => x_msg_count,

Line 2387: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

2383: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
2384: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2385: p_api_name => l_api_name,
2386: p_pkg_name => G_PKG_NAME,
2387: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2388: x_msg_count => x_msg_count,
2389: x_msg_data => x_msg_data,
2390: p_api_type => G_API_TYPE);
2391:

Line 2393: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2389: x_msg_data => x_msg_data,
2390: p_api_type => G_API_TYPE);
2391:
2392: when OTHERS then
2393: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2394: p_api_name => l_api_name,
2395: p_pkg_name => G_PKG_NAME,
2396: p_exc_name => 'OTHERS',
2397: x_msg_count => x_msg_count,