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_SEC_AGREEMENT_PVT dependencies on OKC_API

Line 1714: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1710: --
1711: -- Contract header specific validation
1712: --
1713: x_return_status := validate_header_attributes(p_secAgreement_rec, 'C');
1714: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1715: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1716: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1717: RAISE OKC_API.G_EXCEPTION_ERROR;
1718: END IF;

Line 1715: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1711: -- Contract header specific validation
1712: --
1713: x_return_status := validate_header_attributes(p_secAgreement_rec, 'C');
1714: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1715: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1716: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1717: RAISE OKC_API.G_EXCEPTION_ERROR;
1718: END IF;
1719:

Line 1716: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1712: --
1713: x_return_status := validate_header_attributes(p_secAgreement_rec, 'C');
1714: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1715: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1716: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1717: RAISE OKC_API.G_EXCEPTION_ERROR;
1718: END IF;
1719:
1720: OKL_CONTRACT_PUB.validate_contract_header(

Line 1717: RAISE OKC_API.G_EXCEPTION_ERROR;

1713: x_return_status := validate_header_attributes(p_secAgreement_rec, 'C');
1714: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1715: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1716: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1717: RAISE OKC_API.G_EXCEPTION_ERROR;
1718: END IF;
1719:
1720: OKL_CONTRACT_PUB.validate_contract_header(
1721: p_api_version => p_api_version,

Line 1729: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1725: x_msg_data => x_msg_data,
1726: p_chrv_rec => lp_chrv_rec,
1727: p_khrv_rec => lp_khrv_rec);
1728:
1729: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1730: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1731: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1732: RAISE OKC_API.G_EXCEPTION_ERROR;
1733: END IF;

Line 1730: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1726: p_chrv_rec => lp_chrv_rec,
1727: p_khrv_rec => lp_khrv_rec);
1728:
1729: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1730: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1731: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1732: RAISE OKC_API.G_EXCEPTION_ERROR;
1733: END IF;
1734:

Line 1731: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1727: p_khrv_rec => lp_khrv_rec);
1728:
1729: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1730: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1731: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1732: RAISE OKC_API.G_EXCEPTION_ERROR;
1733: END IF;
1734:
1735: OKL_CONTRACT_PUB.create_contract_header(

Line 1732: RAISE OKC_API.G_EXCEPTION_ERROR;

1728:
1729: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1730: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1731: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1732: RAISE OKC_API.G_EXCEPTION_ERROR;
1733: END IF;
1734:
1735: OKL_CONTRACT_PUB.create_contract_header(
1736: p_api_version => p_api_version,

Line 1746: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1742: p_khrv_rec => lp_khrv_rec,
1743: x_chrv_rec => lx_chrv_rec,
1744: x_khrv_rec => lx_khrv_rec);
1745:
1746: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1747: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1748: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1749: RAISE OKC_API.G_EXCEPTION_ERROR;
1750: END IF;

Line 1747: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1743: x_chrv_rec => lx_chrv_rec,
1744: x_khrv_rec => lx_khrv_rec);
1745:
1746: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1747: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1748: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1749: RAISE OKC_API.G_EXCEPTION_ERROR;
1750: END IF;
1751:

Line 1748: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1744: x_khrv_rec => lx_khrv_rec);
1745:
1746: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1747: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1748: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1749: RAISE OKC_API.G_EXCEPTION_ERROR;
1750: END IF;
1751:
1752: x_secAgreement_rec.ID := lx_chrv_rec.id;

Line 1749: RAISE OKC_API.G_EXCEPTION_ERROR;

1745:
1746: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1747: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1748: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1749: RAISE OKC_API.G_EXCEPTION_ERROR;
1750: END IF;
1751:
1752: x_secAgreement_rec.ID := lx_chrv_rec.id;
1753:

Line 1762: lp_cplv_rec.sfwt_flag := OKC_API.G_FALSE;

1758: -- x_chr_id := lx_chrv_rec.id;
1759:
1760: -- now we attach the party to the header
1761: lp_cplv_rec.object_version_number := 1.0;
1762: lp_cplv_rec.sfwt_flag := OKC_API.G_FALSE;
1763: lp_cplv_rec.dnz_chr_id := lx_chrv_rec.id;
1764: lp_cplv_rec.chr_id := lx_chrv_rec.id;
1765: lp_cplv_rec.cle_id := NULL;
1766: lp_cplv_rec.object1_id1 := lp_chrv_rec.authoring_org_id;

Line 1781: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1777: x_msg_data => x_msg_data,
1778: p_cplv_rec => lp_cplv_rec);
1779:
1780:
1781: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1782: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1783: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1784: RAISE OKC_API.G_EXCEPTION_ERROR;
1785: END IF;

Line 1782: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1778: p_cplv_rec => lp_cplv_rec);
1779:
1780:
1781: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1782: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1783: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1784: RAISE OKC_API.G_EXCEPTION_ERROR;
1785: END IF;
1786:

Line 1783: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1779:
1780:
1781: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1782: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1783: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1784: RAISE OKC_API.G_EXCEPTION_ERROR;
1785: END IF;
1786:
1787: ----- Changes by Kanti

Line 1784: RAISE OKC_API.G_EXCEPTION_ERROR;

1780:
1781: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1782: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1783: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1784: RAISE OKC_API.G_EXCEPTION_ERROR;
1785: END IF;
1786:
1787: ----- Changes by Kanti
1788: ----- Validate the JTOT Object code, ID1 and ID2

Line 1797: p_init_msg_list => OKC_API.G_FALSE,

1793:
1794: IF (l_access_level = 'S') THEN
1795:
1796: okl_la_validation_util_pvt.VALIDATE_ROLE_JTOT (p_api_version => p_api_version,
1797: p_init_msg_list => OKC_API.G_FALSE,
1798: x_return_status => x_return_status,
1799: x_msg_count => x_msg_count,
1800: x_msg_data => x_msg_data,
1801: p_object_name => lp_cplv_rec.jtot_object1_code,

Line 1804: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1800: x_msg_data => x_msg_data,
1801: p_object_name => lp_cplv_rec.jtot_object1_code,
1802: p_id1 => lp_cplv_rec.object1_id1,
1803: p_id2 => lp_cplv_rec.object1_id2);
1804: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1805: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1806: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1807: RAISE OKC_API.G_EXCEPTION_ERROR;
1808: END IF;

Line 1805: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1801: p_object_name => lp_cplv_rec.jtot_object1_code,
1802: p_id1 => lp_cplv_rec.object1_id1,
1803: p_id2 => lp_cplv_rec.object1_id2);
1804: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1805: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1806: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1807: RAISE OKC_API.G_EXCEPTION_ERROR;
1808: END IF;
1809:

Line 1806: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1802: p_id1 => lp_cplv_rec.object1_id1,
1803: p_id2 => lp_cplv_rec.object1_id2);
1804: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1805: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1806: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1807: RAISE OKC_API.G_EXCEPTION_ERROR;
1808: END IF;
1809:
1810: END IF;

Line 1807: RAISE OKC_API.G_EXCEPTION_ERROR;

1803: p_id2 => lp_cplv_rec.object1_id2);
1804: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1805: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1806: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1807: RAISE OKC_API.G_EXCEPTION_ERROR;
1808: END IF;
1809:
1810: END IF;
1811:

Line 1825: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1821: x_msg_data => x_msg_data,
1822: p_cplv_rec => lp_cplv_rec,
1823: x_cplv_rec => lx_cplv_rec);
1824:
1825: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1826: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1827: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1828: RAISE OKC_API.G_EXCEPTION_ERROR;
1829: END IF;

Line 1826: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1822: p_cplv_rec => lp_cplv_rec,
1823: x_cplv_rec => lx_cplv_rec);
1824:
1825: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1826: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1827: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1828: RAISE OKC_API.G_EXCEPTION_ERROR;
1829: END IF;
1830:

Line 1827: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1823: x_cplv_rec => lx_cplv_rec);
1824:
1825: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1826: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1827: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1828: RAISE OKC_API.G_EXCEPTION_ERROR;
1829: END IF;
1830:
1831: --

Line 1828: RAISE OKC_API.G_EXCEPTION_ERROR;

1824:
1825: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1826: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1827: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1828: RAISE OKC_API.G_EXCEPTION_ERROR;
1829: END IF;
1830:
1831: --
1832: -- ************************************************************

Line 1842: lp_cplv_rec.sfwt_flag := OKC_API.G_FALSE;

1838: -- x_chr_id := lx_chrv_rec.id;
1839:
1840: -- now we attach the party to the header
1841: lp_cplv_rec.object_version_number := 1.0;
1842: lp_cplv_rec.sfwt_flag := OKC_API.G_FALSE;
1843: lp_cplv_rec.dnz_chr_id := lx_chrv_rec.id;
1844: lp_cplv_rec.chr_id := lx_chrv_rec.id;
1845: lp_cplv_rec.cle_id := NULL;
1846: lp_cplv_rec.object1_id1 := p_secAgreement_rec.trustee_object1_id1;

Line 1861: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1857: x_msg_data => x_msg_data,
1858: p_cplv_rec => lp_cplv_rec);
1859:
1860:
1861: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1862: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1863: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1864: RAISE OKC_API.G_EXCEPTION_ERROR;
1865: END IF;

Line 1862: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1858: p_cplv_rec => lp_cplv_rec);
1859:
1860:
1861: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1862: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1863: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1864: RAISE OKC_API.G_EXCEPTION_ERROR;
1865: END IF;
1866:

Line 1863: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1859:
1860:
1861: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1862: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1863: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1864: RAISE OKC_API.G_EXCEPTION_ERROR;
1865: END IF;
1866:
1867: ----- Changes by Kanti

Line 1864: RAISE OKC_API.G_EXCEPTION_ERROR;

1860:
1861: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1862: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1863: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1864: RAISE OKC_API.G_EXCEPTION_ERROR;
1865: END IF;
1866:
1867: ----- Changes by Kanti
1868: ----- Validate the JTOT Object code, ID1 and ID2

Line 1878: p_init_msg_list => OKC_API.G_FALSE,

1874:
1875: IF (l_access_level = 'S') THEN
1876:
1877: okl_la_validation_util_pvt.VALIDATE_ROLE_JTOT (p_api_version => p_api_version,
1878: p_init_msg_list => OKC_API.G_FALSE,
1879: x_return_status => x_return_status,
1880: x_msg_count => x_msg_count,
1881: x_msg_data => x_msg_data,
1882: p_object_name => lp_cplv_rec.jtot_object1_code,

Line 1885: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1881: x_msg_data => x_msg_data,
1882: p_object_name => lp_cplv_rec.jtot_object1_code,
1883: p_id1 => lp_cplv_rec.object1_id1,
1884: p_id2 => lp_cplv_rec.object1_id2);
1885: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1886: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1887: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1888: RAISE OKC_API.G_EXCEPTION_ERROR;
1889: END IF;

Line 1886: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1882: p_object_name => lp_cplv_rec.jtot_object1_code,
1883: p_id1 => lp_cplv_rec.object1_id1,
1884: p_id2 => lp_cplv_rec.object1_id2);
1885: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1886: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1887: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1888: RAISE OKC_API.G_EXCEPTION_ERROR;
1889: END IF;
1890:

Line 1887: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1883: p_id1 => lp_cplv_rec.object1_id1,
1884: p_id2 => lp_cplv_rec.object1_id2);
1885: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1886: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1887: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1888: RAISE OKC_API.G_EXCEPTION_ERROR;
1889: END IF;
1890:
1891: END IF;

Line 1888: RAISE OKC_API.G_EXCEPTION_ERROR;

1884: p_id2 => lp_cplv_rec.object1_id2);
1885: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1886: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1887: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1888: RAISE OKC_API.G_EXCEPTION_ERROR;
1889: END IF;
1890:
1891: END IF;
1892:

Line 1905: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1901: x_msg_data => x_msg_data,
1902: p_cplv_rec => lp_cplv_rec,
1903: x_cplv_rec => lx_cplv_rec);
1904:
1905: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1906: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1907: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1908: RAISE OKC_API.G_EXCEPTION_ERROR;
1909: END IF;

Line 1906: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1902: p_cplv_rec => lp_cplv_rec,
1903: x_cplv_rec => lx_cplv_rec);
1904:
1905: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1906: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1907: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1908: RAISE OKC_API.G_EXCEPTION_ERROR;
1909: END IF;
1910:

Line 1907: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1903: x_cplv_rec => lx_cplv_rec);
1904:
1905: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1906: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1907: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1908: RAISE OKC_API.G_EXCEPTION_ERROR;
1909: END IF;
1910:
1911: --

Line 1908: RAISE OKC_API.G_EXCEPTION_ERROR;

1904:
1905: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1906: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1907: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1908: RAISE OKC_API.G_EXCEPTION_ERROR;
1909: END IF;
1910:
1911: --
1912: -- ************************************************************

Line 2123: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2119: --
2120: -- Contract header specific validation
2121: --
2122: x_return_status := validate_header_attributes(p_secAgreement_rec, 'U');
2123: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2124: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2125: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2126: RAISE OKC_API.G_EXCEPTION_ERROR;
2127: END IF;

Line 2124: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2120: -- Contract header specific validation
2121: --
2122: x_return_status := validate_header_attributes(p_secAgreement_rec, 'U');
2123: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2124: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2125: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2126: RAISE OKC_API.G_EXCEPTION_ERROR;
2127: END IF;
2128:

Line 2125: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2121: --
2122: x_return_status := validate_header_attributes(p_secAgreement_rec, 'U');
2123: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2124: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2125: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2126: RAISE OKC_API.G_EXCEPTION_ERROR;
2127: END IF;
2128:
2129: OKL_CONTRACT_PUB.update_contract_header(

Line 2126: RAISE OKC_API.G_EXCEPTION_ERROR;

2122: x_return_status := validate_header_attributes(p_secAgreement_rec, 'U');
2123: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2124: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2125: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2126: RAISE OKC_API.G_EXCEPTION_ERROR;
2127: END IF;
2128:
2129: OKL_CONTRACT_PUB.update_contract_header(
2130: p_api_version => p_api_version,

Line 2140: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2136: p_khrv_rec => lp_khrv_rec,
2137: x_chrv_rec => lx_chrv_rec,
2138: x_khrv_rec => lx_khrv_rec);
2139:
2140: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2141: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2142: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2143: RAISE OKC_API.G_EXCEPTION_ERROR;
2144: END IF;

Line 2141: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2137: x_chrv_rec => lx_chrv_rec,
2138: x_khrv_rec => lx_khrv_rec);
2139:
2140: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2141: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2142: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2143: RAISE OKC_API.G_EXCEPTION_ERROR;
2144: END IF;
2145:

Line 2142: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2138: x_khrv_rec => lx_khrv_rec);
2139:
2140: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2141: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2142: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2143: RAISE OKC_API.G_EXCEPTION_ERROR;
2144: END IF;
2145:
2146: -- copy back to x_secAgreement_rec

Line 2143: RAISE OKC_API.G_EXCEPTION_ERROR;

2139:
2140: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2141: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2142: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2143: RAISE OKC_API.G_EXCEPTION_ERROR;
2144: END IF;
2145:
2146: -- copy back to x_secAgreement_rec
2147:

Line 2177: -- lp_cplv_rec.sfwt_flag := OKC_API.G_FALSE;

2173: -- x_chr_id := lx_chrv_rec.id;
2174:
2175: -- now we attach the party to the header
2176: -- lp_cplv_rec.object_version_number := 1.0;
2177: -- lp_cplv_rec.sfwt_flag := OKC_API.G_FALSE;
2178:
2179: -- lp_cplv_rec.dnz_chr_id := lx_chrv_rec.id;
2180: -- lp_cplv_rec.chr_id := lx_chrv_rec.id;
2181: -- lp_cplv_rec.cle_id := null;

Line 2197: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2193: x_msg_data => x_msg_data,
2194: p_cplv_rec => lp_cplv_rec);
2195:
2196:
2197: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2198: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2199: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2200: RAISE OKC_API.G_EXCEPTION_ERROR;
2201: END IF;

Line 2198: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2194: p_cplv_rec => lp_cplv_rec);
2195:
2196:
2197: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2198: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2199: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2200: RAISE OKC_API.G_EXCEPTION_ERROR;
2201: END IF;
2202:

Line 2199: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2195:
2196:
2197: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2198: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2199: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2200: RAISE OKC_API.G_EXCEPTION_ERROR;
2201: END IF;
2202:
2203: ----- Changes by Kanti

Line 2200: RAISE OKC_API.G_EXCEPTION_ERROR;

2196:
2197: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2198: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2199: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2200: RAISE OKC_API.G_EXCEPTION_ERROR;
2201: END IF;
2202:
2203: ----- Changes by Kanti
2204: ----- Validate the JTOT Object code, ID1 and ID2

Line 2213: p_init_msg_list => OKC_API.G_FALSE,

2209:
2210: IF (l_access_level = 'S') THEN
2211:
2212: okl_la_validation_util_pvt.VALIDATE_ROLE_JTOT (p_api_version => p_api_version,
2213: p_init_msg_list => OKC_API.G_FALSE,
2214: x_return_status => x_return_status,
2215: x_msg_count => x_msg_count,
2216: x_msg_data => x_msg_data,
2217: p_object_name => lp_cplv_rec.jtot_object1_code,

Line 2220: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2216: x_msg_data => x_msg_data,
2217: p_object_name => lp_cplv_rec.jtot_object1_code,
2218: p_id1 => lp_cplv_rec.object1_id1,
2219: p_id2 => lp_cplv_rec.object1_id2);
2220: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2221: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2222: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2223: RAISE OKC_API.G_EXCEPTION_ERROR;
2224: END IF;

Line 2221: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2217: p_object_name => lp_cplv_rec.jtot_object1_code,
2218: p_id1 => lp_cplv_rec.object1_id1,
2219: p_id2 => lp_cplv_rec.object1_id2);
2220: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2221: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2222: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2223: RAISE OKC_API.G_EXCEPTION_ERROR;
2224: END IF;
2225:

Line 2222: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2218: p_id1 => lp_cplv_rec.object1_id1,
2219: p_id2 => lp_cplv_rec.object1_id2);
2220: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2221: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2222: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2223: RAISE OKC_API.G_EXCEPTION_ERROR;
2224: END IF;
2225:
2226: END IF;

Line 2223: RAISE OKC_API.G_EXCEPTION_ERROR;

2219: p_id2 => lp_cplv_rec.object1_id2);
2220: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2221: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2222: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2223: RAISE OKC_API.G_EXCEPTION_ERROR;
2224: END IF;
2225:
2226: END IF;
2227:

Line 2239: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2235: x_msg_data => x_msg_data,
2236: p_cplv_rec => lp_cplv_rec,
2237: x_cplv_rec => lx_cplv_rec);
2238:
2239: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2240: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2241: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2242: RAISE OKC_API.G_EXCEPTION_ERROR;
2243: END IF;

Line 2240: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2236: p_cplv_rec => lp_cplv_rec,
2237: x_cplv_rec => lx_cplv_rec);
2238:
2239: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2240: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2241: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2242: RAISE OKC_API.G_EXCEPTION_ERROR;
2243: END IF;
2244:

Line 2241: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2237: x_cplv_rec => lx_cplv_rec);
2238:
2239: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2240: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2241: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2242: RAISE OKC_API.G_EXCEPTION_ERROR;
2243: END IF;
2244:
2245: -- copy back to x_secAgreement_rec

Line 2242: RAISE OKC_API.G_EXCEPTION_ERROR;

2238:
2239: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2240: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2241: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2242: RAISE OKC_API.G_EXCEPTION_ERROR;
2243: END IF;
2244:
2245: -- copy back to x_secAgreement_rec
2246: x_secAgreement_rec.trustee_party_roles_id := lx_cplv_rec.id;