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 1103: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

1099: x_msg_data => x_msg_data,
1100: p_chr_id => x_clev_rec.dnz_chr_id,
1101: p_cle_id => x_clev_rec.id);
1102:
1103: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1104: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1105: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1106: raise OKL_API.G_EXCEPTION_ERROR;
1107: End If;

Line 1104: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1100: p_chr_id => x_clev_rec.dnz_chr_id,
1101: p_cle_id => x_clev_rec.id);
1102:
1103: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1104: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1105: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1106: raise OKL_API.G_EXCEPTION_ERROR;
1107: End If;
1108:

Line 1105: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

1101: p_cle_id => x_clev_rec.id);
1102:
1103: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1104: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1105: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1106: raise OKL_API.G_EXCEPTION_ERROR;
1107: End If;
1108:
1109: END IF;

Line 1106: raise OKL_API.G_EXCEPTION_ERROR;

1102:
1103: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1104: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1105: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1106: raise OKL_API.G_EXCEPTION_ERROR;
1107: End If;
1108:
1109: END IF;
1110: -- Bug# 6438785

Line 1686: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1682: -- End of comments
1683:
1684: PROCEDURE validate_fee_expense_rule(
1685: p_api_version IN NUMBER,
1686: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1687: x_return_status OUT NOCOPY VARCHAR2,
1688: x_msg_count OUT NOCOPY NUMBER,
1689: x_msg_data OUT NOCOPY VARCHAR2,
1690: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

Line 1763: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1759: x_klev_rec klev_rec_type ;
1760:
1761: BEGIN
1762:
1763: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1764:
1765: -- call START_ACTIVITY to create savepoint, check compatibility
1766: -- and initialize message list
1767: x_return_status := OKL_API.START_ACTIVITY(

Line 1767: x_return_status := OKL_API.START_ACTIVITY(

1763: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1764:
1765: -- call START_ACTIVITY to create savepoint, check compatibility
1766: -- and initialize message list
1767: x_return_status := OKL_API.START_ACTIVITY(
1768: p_api_name => l_api_name,
1769: p_pkg_name => G_PKG_NAME,
1770: p_init_msg_list => p_init_msg_list,
1771: l_api_version => l_api_version,

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

1773: p_api_type => G_API_TYPE,
1774: x_return_status => x_return_status);
1775:
1776: -- check if activity started successfully
1777: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1778: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1779: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1780: raise OKL_API.G_EXCEPTION_ERROR;
1781: END IF;

Line 1778: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1774: x_return_status => x_return_status);
1775:
1776: -- check if activity started successfully
1777: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1778: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1779: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1780: raise OKL_API.G_EXCEPTION_ERROR;
1781: END IF;
1782:

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

1775:
1776: -- check if activity started successfully
1777: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1778: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1779: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1780: raise OKL_API.G_EXCEPTION_ERROR;
1781: END IF;
1782:
1783: If(p_chr_id is null or p_chr_id = OKL_API.G_MISS_NUM) Then

Line 1780: raise OKL_API.G_EXCEPTION_ERROR;

1776: -- check if activity started successfully
1777: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1778: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1779: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1780: raise OKL_API.G_EXCEPTION_ERROR;
1781: END IF;
1782:
1783: If(p_chr_id is null or p_chr_id = OKL_API.G_MISS_NUM) Then
1784: x_return_status := OKL_API.g_ret_sts_error;

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

1779: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1780: raise OKL_API.G_EXCEPTION_ERROR;
1781: END IF;
1782:
1783: If(p_chr_id is null or p_chr_id = OKL_API.G_MISS_NUM) Then
1784: x_return_status := OKL_API.g_ret_sts_error;
1785: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1786: , p_msg_name => 'OKL_INVALID_VALUE'
1787: , p_token1 => 'COL_NAME'

Line 1784: x_return_status := OKL_API.g_ret_sts_error;

1780: raise OKL_API.G_EXCEPTION_ERROR;
1781: END IF;
1782:
1783: If(p_chr_id is null or p_chr_id = OKL_API.G_MISS_NUM) Then
1784: x_return_status := OKL_API.g_ret_sts_error;
1785: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1786: , p_msg_name => 'OKL_INVALID_VALUE'
1787: , p_token1 => 'COL_NAME'
1788: , p_token1_value => 'CHR_ID'

Line 1785: OKL_API.SET_MESSAGE( p_app_name => g_app_name

1781: END IF;
1782:
1783: If(p_chr_id is null or p_chr_id = OKL_API.G_MISS_NUM) Then
1784: x_return_status := OKL_API.g_ret_sts_error;
1785: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1786: , p_msg_name => 'OKL_INVALID_VALUE'
1787: , p_token1 => 'COL_NAME'
1788: , p_token1_value => 'CHR_ID'
1789: );

Line 1790: raise OKL_API.G_EXCEPTION_ERROR;

1786: , p_msg_name => 'OKL_INVALID_VALUE'
1787: , p_token1 => 'COL_NAME'
1788: , p_token1_value => 'CHR_ID'
1789: );
1790: raise OKL_API.G_EXCEPTION_ERROR;
1791: End If;
1792:
1793:
1794: If(p_line_id is null or p_line_id = OKL_API.G_MISS_NUM) Then

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

1790: raise OKL_API.G_EXCEPTION_ERROR;
1791: End If;
1792:
1793:
1794: If(p_line_id is null or p_line_id = OKL_API.G_MISS_NUM) Then
1795: x_return_status := OKL_API.g_ret_sts_error;
1796: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1797: , p_msg_name => 'OKL_INVALID_VALUE'
1798: , p_token1 => 'COL_NAME'

Line 1795: x_return_status := OKL_API.g_ret_sts_error;

1791: End If;
1792:
1793:
1794: If(p_line_id is null or p_line_id = OKL_API.G_MISS_NUM) Then
1795: x_return_status := OKL_API.g_ret_sts_error;
1796: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1797: , p_msg_name => 'OKL_INVALID_VALUE'
1798: , p_token1 => 'COL_NAME'
1799: , p_token1_value => 'CLE_ID'

Line 1796: OKL_API.SET_MESSAGE( p_app_name => g_app_name

1792:
1793:
1794: If(p_line_id is null or p_line_id = OKL_API.G_MISS_NUM) Then
1795: x_return_status := OKL_API.g_ret_sts_error;
1796: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1797: , p_msg_name => 'OKL_INVALID_VALUE'
1798: , p_token1 => 'COL_NAME'
1799: , p_token1_value => 'CLE_ID'
1800: );

Line 1801: raise OKL_API.G_EXCEPTION_ERROR;

1797: , p_msg_name => 'OKL_INVALID_VALUE'
1798: , p_token1 => 'COL_NAME'
1799: , p_token1_value => 'CLE_ID'
1800: );
1801: raise OKL_API.G_EXCEPTION_ERROR;
1802: End If;
1803:
1804: OPEN contract_csr (p_chr_id,
1805: p_line_id);

Line 1819: x_return_status := OKL_API.g_ret_sts_error;

1815: FETCH scscode_csr INTO scscode;
1816: CLOSE scscode_csr ;
1817: if(scscode='INVESTOR' and p_amount_per_period < 0) then
1818:
1819: x_return_status := OKL_API.g_ret_sts_error;
1820: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1821: , p_msg_name => 'OKL_PRDAMNT_CHCK'
1822: );
1823: raise OKL_API.G_EXCEPTION_ERROR;

Line 1820: OKL_API.SET_MESSAGE( p_app_name => g_app_name

1816: CLOSE scscode_csr ;
1817: if(scscode='INVESTOR' and p_amount_per_period < 0) then
1818:
1819: x_return_status := OKL_API.g_ret_sts_error;
1820: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1821: , p_msg_name => 'OKL_PRDAMNT_CHCK'
1822: );
1823: raise OKL_API.G_EXCEPTION_ERROR;
1824: End If;

Line 1823: raise OKL_API.G_EXCEPTION_ERROR;

1819: x_return_status := OKL_API.g_ret_sts_error;
1820: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1821: , p_msg_name => 'OKL_PRDAMNT_CHCK'
1822: );
1823: raise OKL_API.G_EXCEPTION_ERROR;
1824: End If;
1825:
1826: IF (l_line_type = 'FEE') THEN
1827:

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

1824: End If;
1825:
1826: IF (l_line_type = 'FEE') THEN
1827:
1828: If(p_no_of_period is null or p_no_of_period = OKL_API.G_MISS_NUM) Then
1829: l_ak_prompt := GET_AK_PROMPT('OKL_LA_SERVICE_LINE', 'OKL_NO_OF_PERIOD');
1830: x_return_status := OKL_API.g_ret_sts_error;
1831: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1832: , p_msg_name => 'OKL_REQUIRED_VALUE'

Line 1830: x_return_status := OKL_API.g_ret_sts_error;

1826: IF (l_line_type = 'FEE') THEN
1827:
1828: If(p_no_of_period is null or p_no_of_period = OKL_API.G_MISS_NUM) Then
1829: l_ak_prompt := GET_AK_PROMPT('OKL_LA_SERVICE_LINE', 'OKL_NO_OF_PERIOD');
1830: x_return_status := OKL_API.g_ret_sts_error;
1831: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1832: , p_msg_name => 'OKL_REQUIRED_VALUE'
1833: , p_token1 => 'COL_NAME'
1834: , p_token1_value => l_ak_prompt

Line 1831: OKL_API.SET_MESSAGE( p_app_name => g_app_name

1827:
1828: If(p_no_of_period is null or p_no_of_period = OKL_API.G_MISS_NUM) Then
1829: l_ak_prompt := GET_AK_PROMPT('OKL_LA_SERVICE_LINE', 'OKL_NO_OF_PERIOD');
1830: x_return_status := OKL_API.g_ret_sts_error;
1831: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1832: , p_msg_name => 'OKL_REQUIRED_VALUE'
1833: , p_token1 => 'COL_NAME'
1834: , p_token1_value => l_ak_prompt
1835: );

Line 1836: raise OKL_API.G_EXCEPTION_ERROR;

1832: , p_msg_name => 'OKL_REQUIRED_VALUE'
1833: , p_token1 => 'COL_NAME'
1834: , p_token1_value => l_ak_prompt
1835: );
1836: raise OKL_API.G_EXCEPTION_ERROR;
1837: End If;
1838:
1839: If(p_amount_per_period is null or p_amount_per_period = OKL_API.G_MISS_NUM) Then
1840: l_ak_prompt := GET_AK_PROMPT('OKL_LA_SERVICE_LINE', 'OKL_AMT_PER_PERIOD');

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

1835: );
1836: raise OKL_API.G_EXCEPTION_ERROR;
1837: End If;
1838:
1839: If(p_amount_per_period is null or p_amount_per_period = OKL_API.G_MISS_NUM) Then
1840: l_ak_prompt := GET_AK_PROMPT('OKL_LA_SERVICE_LINE', 'OKL_AMT_PER_PERIOD');
1841: x_return_status := OKL_API.g_ret_sts_error;
1842: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1843: , p_msg_name => 'OKL_REQUIRED_VALUE'

Line 1841: x_return_status := OKL_API.g_ret_sts_error;

1837: End If;
1838:
1839: If(p_amount_per_period is null or p_amount_per_period = OKL_API.G_MISS_NUM) Then
1840: l_ak_prompt := GET_AK_PROMPT('OKL_LA_SERVICE_LINE', 'OKL_AMT_PER_PERIOD');
1841: x_return_status := OKL_API.g_ret_sts_error;
1842: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1843: , p_msg_name => 'OKL_REQUIRED_VALUE'
1844: , p_token1 => 'COL_NAME'
1845: , p_token1_value => l_ak_prompt

Line 1842: OKL_API.SET_MESSAGE( p_app_name => g_app_name

1838:
1839: If(p_amount_per_period is null or p_amount_per_period = OKL_API.G_MISS_NUM) Then
1840: l_ak_prompt := GET_AK_PROMPT('OKL_LA_SERVICE_LINE', 'OKL_AMT_PER_PERIOD');
1841: x_return_status := OKL_API.g_ret_sts_error;
1842: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1843: , p_msg_name => 'OKL_REQUIRED_VALUE'
1844: , p_token1 => 'COL_NAME'
1845: , p_token1_value => l_ak_prompt
1846: );

Line 1847: raise OKL_API.G_EXCEPTION_ERROR;

1843: , p_msg_name => 'OKL_REQUIRED_VALUE'
1844: , p_token1 => 'COL_NAME'
1845: , p_token1_value => l_ak_prompt
1846: );
1847: raise OKL_API.G_EXCEPTION_ERROR;
1848: End If;
1849:
1850: If(p_frequency is null or p_frequency = OKL_API.G_MISS_CHAR) Then
1851: l_ak_prompt := GET_AK_PROMPT('OKL_LA_SERVICE_LINE', 'OKL_FREEQUENCY');

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

1846: );
1847: raise OKL_API.G_EXCEPTION_ERROR;
1848: End If;
1849:
1850: If(p_frequency is null or p_frequency = OKL_API.G_MISS_CHAR) Then
1851: l_ak_prompt := GET_AK_PROMPT('OKL_LA_SERVICE_LINE', 'OKL_FREEQUENCY');
1852: x_return_status := OKL_API.g_ret_sts_error;
1853: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1854: , p_msg_name => 'OKL_REQUIRED_VALUE'

Line 1852: x_return_status := OKL_API.g_ret_sts_error;

1848: End If;
1849:
1850: If(p_frequency is null or p_frequency = OKL_API.G_MISS_CHAR) Then
1851: l_ak_prompt := GET_AK_PROMPT('OKL_LA_SERVICE_LINE', 'OKL_FREEQUENCY');
1852: x_return_status := OKL_API.g_ret_sts_error;
1853: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1854: , p_msg_name => 'OKL_REQUIRED_VALUE'
1855: , p_token1 => 'COL_NAME'
1856: , p_token1_value => l_ak_prompt

Line 1853: OKL_API.SET_MESSAGE( p_app_name => g_app_name

1849:
1850: If(p_frequency is null or p_frequency = OKL_API.G_MISS_CHAR) Then
1851: l_ak_prompt := GET_AK_PROMPT('OKL_LA_SERVICE_LINE', 'OKL_FREEQUENCY');
1852: x_return_status := OKL_API.g_ret_sts_error;
1853: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1854: , p_msg_name => 'OKL_REQUIRED_VALUE'
1855: , p_token1 => 'COL_NAME'
1856: , p_token1_value => l_ak_prompt
1857: );

Line 1858: raise OKL_API.G_EXCEPTION_ERROR;

1854: , p_msg_name => 'OKL_REQUIRED_VALUE'
1855: , p_token1 => 'COL_NAME'
1856: , p_token1_value => l_ak_prompt
1857: );
1858: raise OKL_API.G_EXCEPTION_ERROR;
1859: End If;
1860:
1861: End If;
1862:

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

1871: x_msg_count => x_msg_count,
1872: x_msg_data => x_msg_data,
1873: p_cle_id => p_line_id);
1874:
1875: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1876: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1877: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1878: RAISE OKL_API.G_EXCEPTION_ERROR;
1879: END IF;

Line 1876: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1872: x_msg_data => x_msg_data,
1873: p_cle_id => p_line_id);
1874:
1875: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1876: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1877: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1878: RAISE OKL_API.G_EXCEPTION_ERROR;
1879: END IF;
1880: --Bug# 4959361

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

1873: p_cle_id => p_line_id);
1874:
1875: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1876: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1877: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1878: RAISE OKL_API.G_EXCEPTION_ERROR;
1879: END IF;
1880: --Bug# 4959361
1881:

Line 1878: RAISE OKL_API.G_EXCEPTION_ERROR;

1874:
1875: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1876: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1877: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1878: RAISE OKL_API.G_EXCEPTION_ERROR;
1879: END IF;
1880: --Bug# 4959361
1881:
1882: l_id1 := '?';

Line 1890: okl_api.set_message(

1886: FETCH freq_csr INTO l_id1;
1887: CLOSE freq_csr;
1888:
1889: IF (l_id1 = '?') THEN
1890: okl_api.set_message(
1891: G_APP_NAME,
1892: G_INVALID_VALUE,
1893: 'COL_NAME',
1894: 'FREQUENCY'

Line 1897: x_return_status := OKL_API.G_RET_STS_ERROR;

1893: 'COL_NAME',
1894: 'FREQUENCY'
1895: );
1896:
1897: x_return_status := OKL_API.G_RET_STS_ERROR;
1898: END IF;
1899:
1900: IF (p_no_of_period IS NULL) THEN
1901: okl_api.set_message(

Line 1901: okl_api.set_message(

1897: x_return_status := OKL_API.G_RET_STS_ERROR;
1898: END IF;
1899:
1900: IF (p_no_of_period IS NULL) THEN
1901: okl_api.set_message(
1902: G_APP_NAME,
1903: G_INCOMPLETE_RULE,
1904: 'COL_NAME',
1905: 'NO_OF_PERIOD'

Line 1908: x_return_status := OKL_API.G_RET_STS_ERROR;

1904: 'COL_NAME',
1905: 'NO_OF_PERIOD'
1906: );
1907:
1908: x_return_status := OKL_API.G_RET_STS_ERROR;
1909: ELSE
1910: IF (p_amount_per_period IS NULL) THEN
1911: okl_api.set_message(
1912: G_APP_NAME,

Line 1911: okl_api.set_message(

1907:
1908: x_return_status := OKL_API.G_RET_STS_ERROR;
1909: ELSE
1910: IF (p_amount_per_period IS NULL) THEN
1911: okl_api.set_message(
1912: G_APP_NAME,
1913: G_INCOMPLETE_RULE,
1914: 'COL_NAME',
1915: 'AMOUNT_PER_PERIOD'

Line 1918: x_return_status := OKL_API.G_RET_STS_ERROR;

1914: 'COL_NAME',
1915: 'AMOUNT_PER_PERIOD'
1916: );
1917:
1918: x_return_status := OKL_API.G_RET_STS_ERROR;
1919: END IF;
1920: END IF;
1921: ELSE
1922: okl_api.set_message(

Line 1922: okl_api.set_message(

1918: x_return_status := OKL_API.G_RET_STS_ERROR;
1919: END IF;
1920: END IF;
1921: ELSE
1922: okl_api.set_message(
1923: G_APP_NAME,
1924: G_INCOMPLETE_RULE,
1925: 'COL_NAME',
1926: 'FREQUENCY'

Line 1929: x_return_status := OKL_API.G_RET_STS_ERROR;

1925: 'COL_NAME',
1926: 'FREQUENCY'
1927: );
1928:
1929: x_return_status := OKL_API.G_RET_STS_ERROR;
1930: END IF;
1931:
1932: ELSIF (p_no_of_period IS NOT NULL
1933: OR

Line 1938: okl_api.set_message(

1934: p_frequency IS NOT NULL
1935: OR
1936: p_amount_per_period IS NOT NULL
1937: ) THEN
1938: okl_api.set_message(
1939: G_APP_NAME,
1940: G_INVALID_LINE_RULE,
1941: 'VALUE',
1942: 'FEE_NO_OF_PERIOD, FREQUENCY OR AMOUNT_PER_PERIOD',

Line 1949: x_return_status := OKL_API.G_RET_STS_ERROR;

1945: 'ACT_LINE_TYPE',
1946: 'FEE or SERVICE'
1947: );
1948:
1949: x_return_status := OKL_API.G_RET_STS_ERROR;
1950:
1951: END IF;
1952:
1953: -- cross validation

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

1951: END IF;
1952:
1953: -- cross validation
1954:
1955: IF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
1956:
1957: OPEN strm_cap_csr (p_chr_id,
1958: p_line_id);
1959: FETCH strm_cap_csr INTO l_cap_yn;

Line 1977: okl_api.set_message(

1973: l_mult_factor := 6;
1974: ELSIF (l_id1 = 'A') THEN
1975: l_mult_factor := 12;
1976: ELSE
1977: okl_api.set_message(
1978: G_APP_NAME,
1979: G_UOM_SETUP_ERROR,
1980: 'COL_VALUE',
1981: l_id1

Line 1983: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1979: G_UOM_SETUP_ERROR,
1980: 'COL_VALUE',
1981: l_id1
1982: );
1983: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1984: END IF;
1985:
1986: IF (l_end_date < (ADD_MONTHS(l_start_date, p_no_of_period * l_mult_factor)-1)) THEN
1987: okl_api.set_message(

Line 1987: okl_api.set_message(

1983: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1984: END IF;
1985:
1986: IF (l_end_date < (ADD_MONTHS(l_start_date, p_no_of_period * l_mult_factor)-1)) THEN
1987: okl_api.set_message(
1988: G_APP_NAME,
1989: G_INVALID_PERIOD,
1990: 'START_DATE',
1991: l_start_date,

Line 1995: RAISE OKL_API.G_EXCEPTION_ERROR;

1991: l_start_date,
1992: 'END_DATE',
1993: l_end_date
1994: );
1995: RAISE OKL_API.G_EXCEPTION_ERROR;
1996: END IF;
1997:
1998: 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
1999: okl_api.set_message(

Line 1999: okl_api.set_message(

1995: RAISE OKL_API.G_EXCEPTION_ERROR;
1996: END IF;
1997:
1998: 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
1999: okl_api.set_message(
2000: G_APP_NAME,
2001: G_INVALID_NO_OF_PAYMENTS
2002: );
2003: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 2003: RAISE OKL_API.G_EXCEPTION_ERROR;

1999: okl_api.set_message(
2000: G_APP_NAME,
2001: G_INVALID_NO_OF_PAYMENTS
2002: );
2003: RAISE OKL_API.G_EXCEPTION_ERROR;
2004: End If;
2005:
2006: -- this validation is commented for summing recurring exp amt to service/fee line
2007: /*

Line 2009: okl_api.set_message(

2005:
2006: -- this validation is commented for summing recurring exp amt to service/fee line
2007: /*
2008: IF (l_line_amount <> (p_amount_per_period * p_no_of_period)) THEN
2009: okl_api.set_message(
2010: G_APP_NAME,
2011: G_INVALID_EXP_AMOUNT
2012: );
2013: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 2013: RAISE OKL_API.G_EXCEPTION_ERROR;

2009: okl_api.set_message(
2010: G_APP_NAME,
2011: G_INVALID_EXP_AMOUNT
2012: );
2013: RAISE OKL_API.G_EXCEPTION_ERROR;
2014: END IF;
2015: */
2016: -- update line amount with recurring exp amount
2017:

Line 2032: x_return_status := OKL_API.g_ret_sts_error;

2028: l_klev_rec.capital_amount := l_line_amount;
2029: END IF;
2030:
2031: IF (l_line_type = 'FEE' and l_initial_direct_cost is not null and l_initial_direct_cost > l_klev_rec.amount) THEN
2032: x_return_status := OKL_API.g_ret_sts_error;
2033: OKL_API.SET_MESSAGE( p_app_name => g_app_name
2034: , p_msg_name => 'OKL_LLA_IDC_FEE'
2035: );
2036: raise OKL_API.G_EXCEPTION_ERROR;

Line 2033: OKL_API.SET_MESSAGE( p_app_name => g_app_name

2029: END IF;
2030:
2031: IF (l_line_type = 'FEE' and l_initial_direct_cost is not null and l_initial_direct_cost > l_klev_rec.amount) THEN
2032: x_return_status := OKL_API.g_ret_sts_error;
2033: OKL_API.SET_MESSAGE( p_app_name => g_app_name
2034: , p_msg_name => 'OKL_LLA_IDC_FEE'
2035: );
2036: raise OKL_API.G_EXCEPTION_ERROR;
2037: END IF;

Line 2036: raise OKL_API.G_EXCEPTION_ERROR;

2032: x_return_status := OKL_API.g_ret_sts_error;
2033: OKL_API.SET_MESSAGE( p_app_name => g_app_name
2034: , p_msg_name => 'OKL_LLA_IDC_FEE'
2035: );
2036: raise OKL_API.G_EXCEPTION_ERROR;
2037: END IF;
2038:
2039: okl_contract_pvt.update_contract_line(
2040: p_api_version => p_api_version,

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

2047: x_clev_rec => x_clev_rec,
2048: x_klev_rec => x_klev_rec
2049: );
2050:
2051: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2052: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2053: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2054: raise OKL_API.G_EXCEPTION_ERROR;
2055: END IF;

Line 2052: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2048: x_klev_rec => x_klev_rec
2049: );
2050:
2051: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2052: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2053: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2054: raise OKL_API.G_EXCEPTION_ERROR;
2055: END IF;
2056:

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

2049: );
2050:
2051: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2052: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2053: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2054: raise OKL_API.G_EXCEPTION_ERROR;
2055: END IF;
2056:
2057: END IF;

Line 2054: raise OKL_API.G_EXCEPTION_ERROR;

2050:
2051: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2052: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2053: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2054: raise OKL_API.G_EXCEPTION_ERROR;
2055: END IF;
2056:
2057: END IF;
2058:

Line 2061: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2057: END IF;
2058:
2059: END IF;
2060:
2061: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2062:
2063:
2064: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2065: x_msg_data => x_msg_data);

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

2060:
2061: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2062:
2063:
2064: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2065: x_msg_data => x_msg_data);
2066:
2067: EXCEPTION
2068:

Line 2069: when OKL_API.G_EXCEPTION_ERROR then

2065: x_msg_data => x_msg_data);
2066:
2067: EXCEPTION
2068:
2069: when OKL_API.G_EXCEPTION_ERROR then
2070: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2071: p_api_name => l_api_name,
2072: p_pkg_name => G_PKG_NAME,
2073: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 2070: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2066:
2067: EXCEPTION
2068:
2069: when OKL_API.G_EXCEPTION_ERROR then
2070: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2071: p_api_name => l_api_name,
2072: p_pkg_name => G_PKG_NAME,
2073: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2074: x_msg_count => x_msg_count,

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

2069: when OKL_API.G_EXCEPTION_ERROR then
2070: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2071: p_api_name => l_api_name,
2072: p_pkg_name => G_PKG_NAME,
2073: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2074: x_msg_count => x_msg_count,
2075: x_msg_data => x_msg_data,
2076: p_api_type => G_API_TYPE);
2077:

Line 2078: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

2074: x_msg_count => x_msg_count,
2075: x_msg_data => x_msg_data,
2076: p_api_type => G_API_TYPE);
2077:
2078: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
2079: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2080: p_api_name => l_api_name,
2081: p_pkg_name => G_PKG_NAME,
2082: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2079: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2075: x_msg_data => x_msg_data,
2076: p_api_type => G_API_TYPE);
2077:
2078: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
2079: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2080: p_api_name => l_api_name,
2081: p_pkg_name => G_PKG_NAME,
2082: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2083: x_msg_count => x_msg_count,

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

2078: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
2079: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2080: p_api_name => l_api_name,
2081: p_pkg_name => G_PKG_NAME,
2082: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2083: x_msg_count => x_msg_count,
2084: x_msg_data => x_msg_data,
2085: p_api_type => G_API_TYPE);
2086:

Line 2088: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2084: x_msg_data => x_msg_data,
2085: p_api_type => G_API_TYPE);
2086:
2087: when OTHERS then
2088: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2089: p_api_name => l_api_name,
2090: p_pkg_name => G_PKG_NAME,
2091: p_exc_name => 'OTHERS',
2092: x_msg_count => x_msg_count,

Line 2109: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

2105: -- Version : 1.0
2106: -- End of comments
2107: PROCEDURE validate_passthru_rule(
2108: p_api_version IN NUMBER,
2109: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2110: x_return_status OUT NOCOPY VARCHAR2,
2111: x_msg_count OUT NOCOPY NUMBER,
2112: x_msg_data OUT NOCOPY VARCHAR2,
2113: p_line_id IN OKC_K_LINES_V.ID%TYPE,

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

2122: x_payment_method_id1 OUT NOCOPY VARCHAR2
2123: ) IS
2124:
2125: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CONTRACT_TOP_LINE_PVT';
2126: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
2127: G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
2128:
2129: G_INVALID_VALUE CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE';
2130: G_INVALID_LINE_RULE CONSTANT VARCHAR2(200) := 'OKL_LLA_INVALID_LINE_RULE';

Line 2188: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2184: l_line_type OKC_LINE_STYLES_B.LTY_CODE%TYPE;
2185:
2186: BEGIN
2187:
2188: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2189:
2190: -- call START_ACTIVITY to create savepoint, check compatibility
2191: -- and initialize message list
2192: x_return_status := OKL_API.START_ACTIVITY(

Line 2192: x_return_status := OKL_API.START_ACTIVITY(

2188: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2189:
2190: -- call START_ACTIVITY to create savepoint, check compatibility
2191: -- and initialize message list
2192: x_return_status := OKL_API.START_ACTIVITY(
2193: p_api_name => l_api_name,
2194: p_pkg_name => G_PKG_NAME,
2195: p_init_msg_list => p_init_msg_list,
2196: l_api_version => l_api_version,

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

2198: p_api_type => G_API_TYPE,
2199: x_return_status => x_return_status);
2200:
2201: -- check if activity started successfully
2202: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2203: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2204: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2205: raise OKL_API.G_EXCEPTION_ERROR;
2206: END IF;

Line 2203: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2199: x_return_status => x_return_status);
2200:
2201: -- check if activity started successfully
2202: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2203: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2204: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2205: raise OKL_API.G_EXCEPTION_ERROR;
2206: END IF;
2207:

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

2200:
2201: -- check if activity started successfully
2202: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2203: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2204: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2205: raise OKL_API.G_EXCEPTION_ERROR;
2206: END IF;
2207:
2208:

Line 2205: raise OKL_API.G_EXCEPTION_ERROR;

2201: -- check if activity started successfully
2202: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2203: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2204: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2205: raise OKL_API.G_EXCEPTION_ERROR;
2206: END IF;
2207:
2208:
2209: OPEN line_style_csr (p_line_id);

Line 2226: okl_api.set_message(

2222: FETCH pay_term_csr INTO l_id1;
2223: CLOSE pay_term_csr;
2224:
2225: IF (l_id1 = '?') THEN
2226: okl_api.set_message(
2227: G_APP_NAME,
2228: G_INVALID_VALUE,
2229: 'COL_NAME',
2230: 'PAYMENT_TERM'

Line 2233: x_return_status := OKL_API.G_RET_STS_ERROR;

2229: 'COL_NAME',
2230: 'PAYMENT_TERM'
2231: );
2232:
2233: x_return_status := OKL_API.G_RET_STS_ERROR;
2234: ELSE
2235: x_payment_term_id1 := l_id1;
2236: END IF;
2237:

Line 2252: okl_api.set_message(

2248: FETCH pay_site_csr INTO l_id1;
2249: CLOSE pay_site_csr;
2250:
2251: IF (l_id1 = '?') THEN
2252: okl_api.set_message(
2253: G_APP_NAME,
2254: G_INVALID_VALUE,
2255: 'COL_NAME',
2256: 'PAY_TO_SITE'

Line 2259: x_return_status := OKL_API.G_RET_STS_ERROR;

2255: 'COL_NAME',
2256: 'PAY_TO_SITE'
2257: );
2258:
2259: x_return_status := OKL_API.G_RET_STS_ERROR;
2260: ELSE
2261: x_pay_site_id1 := l_id1;
2262: END IF;
2263:

Line 2274: okl_api.set_message(

2270: FETCH pay_method_csr INTO l_id1;
2271: CLOSE pay_method_csr;
2272:
2273: IF (l_id1 = '?') THEN
2274: okl_api.set_message(
2275: G_APP_NAME,
2276: G_INVALID_VALUE,
2277: 'COL_NAME',
2278: 'PAYMENT_METHOD_CODE'

Line 2281: x_return_status := OKL_API.G_RET_STS_ERROR;

2277: 'COL_NAME',
2278: 'PAYMENT_METHOD_CODE'
2279: );
2280:
2281: x_return_status := OKL_API.G_RET_STS_ERROR;
2282: ELSE
2283: x_payment_method_id1 := l_id1;
2284: END IF;
2285: END IF;

Line 2297: okl_api.set_message(

2293: p_pay_to_site_id IS NOT NULL
2294: OR
2295: p_payment_method_code IS NOT NULL
2296: ) THEN
2297: okl_api.set_message(
2298: G_APP_NAME,
2299: G_INVALID_LINE_RULE,
2300: 'VALUE',
2301: 'PAYMENT_TERM, PAY_TO_SITE, PAYMENT_METHOD',

Line 2308: x_return_status := OKL_API.G_RET_STS_ERROR;

2304: 'ACT_LINE_TYPE',
2305: 'SERVICE or FEE'
2306: );
2307:
2308: x_return_status := OKL_API.G_RET_STS_ERROR;
2309:
2310: END IF;
2311:
2312: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

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

2308: x_return_status := OKL_API.G_RET_STS_ERROR;
2309:
2310: END IF;
2311:
2312: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2313: x_msg_data => x_msg_data);
2314:
2315:
2316: RETURN;

Line 2319: when OKL_API.G_EXCEPTION_ERROR then

2315:
2316: RETURN;
2317:
2318: EXCEPTION
2319: when OKL_API.G_EXCEPTION_ERROR then
2320: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2321: p_api_name => l_api_name,
2322: p_pkg_name => G_PKG_NAME,
2323: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 2320: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2316: RETURN;
2317:
2318: EXCEPTION
2319: when OKL_API.G_EXCEPTION_ERROR then
2320: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2321: p_api_name => l_api_name,
2322: p_pkg_name => G_PKG_NAME,
2323: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2324: x_msg_count => x_msg_count,

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

2319: when OKL_API.G_EXCEPTION_ERROR then
2320: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2321: p_api_name => l_api_name,
2322: p_pkg_name => G_PKG_NAME,
2323: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2324: x_msg_count => x_msg_count,
2325: x_msg_data => x_msg_data,
2326: p_api_type => G_API_TYPE);
2327:

Line 2328: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

2324: x_msg_count => x_msg_count,
2325: x_msg_data => x_msg_data,
2326: p_api_type => G_API_TYPE);
2327:
2328: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
2329: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2330: p_api_name => l_api_name,
2331: p_pkg_name => G_PKG_NAME,
2332: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2329: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2325: x_msg_data => x_msg_data,
2326: p_api_type => G_API_TYPE);
2327:
2328: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
2329: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2330: p_api_name => l_api_name,
2331: p_pkg_name => G_PKG_NAME,
2332: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2333: x_msg_count => x_msg_count,

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

2328: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
2329: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2330: p_api_name => l_api_name,
2331: p_pkg_name => G_PKG_NAME,
2332: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2333: x_msg_count => x_msg_count,
2334: x_msg_data => x_msg_data,
2335: p_api_type => G_API_TYPE);
2336:

Line 2338: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2334: x_msg_data => x_msg_data,
2335: p_api_type => G_API_TYPE);
2336:
2337: when OTHERS then
2338: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2339: p_api_name => l_api_name,
2340: p_pkg_name => G_PKG_NAME,
2341: p_exc_name => 'OTHERS',
2342: x_msg_count => x_msg_count,