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

Line 476: x_return_status := OKC_API.G_RET_STS_SUCCESS;

472: END IF;
473: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
474: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
475: END IF;
476: x_return_status := OKC_API.G_RET_STS_SUCCESS;
477:
478: OPEN rebook_csr(p_rebook_reason_code);
479: FETCH rebook_csr INTO l_dummy;
480: IF rebook_csr%NOTFOUND THEN

Line 495: x_return_status := OKC_API.G_RET_STS_ERROR;

491: G_INVALID_VALUE,
492: 'COL_NAME',
493: 'REBOOK REASON'
494: );
495: x_return_status := OKC_API.G_RET_STS_ERROR;
496:
497: END validate_rebook_reason;
498:
499: ------------------------------------------------------------------------------

Line 683: x_return_status := OKC_API.G_RET_STS_SUCCESS;

679: BEGIN
680: IF (G_DEBUG_ENABLED = 'Y') THEN
681: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
682: END IF;
683: x_return_status := OKC_API.G_RET_STS_SUCCESS;
684: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
685: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
686: END IF;
687:

Line 812: p_init_msg_list => OKC_API.G_FALSE,

808:
809: IF (l_orig_strm_tbl.COUNT > 0) THEN
810: okl_streams_pub.update_streams(
811: p_api_version => 1.0,
812: p_init_msg_list => OKC_API.G_FALSE,
813: x_return_status => x_return_status,
814: x_msg_count => x_msg_count,
815: x_msg_data => x_msg_data,
816: p_stmv_tbl => l_orig_strm_tbl,

Line 824: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

820: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
821: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After Update of Deleted Orig strm to HIST '||x_return_status);
822: END IF;
823:
824: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
825: RAISE copy_failed;
826: END IF;
827: END IF;
828:

Line 950: p_init_msg_list => OKC_API.G_FALSE,

946:
947: IF (l_orig_strm_tbl.COUNT > 0) THEN
948: okl_streams_pub.update_streams(
949: p_api_version => 1.0,
950: p_init_msg_list => OKC_API.G_FALSE,
951: x_return_status => x_return_status,
952: x_msg_count => x_msg_count,
953: x_msg_data => x_msg_data,
954: p_stmv_tbl => l_orig_strm_tbl,

Line 962: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

958: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
959: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After Update of Orig strm to HIST '||x_return_status);
960: END IF;
961:
962: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
963: RAISE copy_failed;
964: END IF;
965: END IF;
966:

Line 1043: p_init_msg_list => OKC_API.G_FALSE,

1039:
1040: -- call API to create new streams
1041: okl_streams_pub.create_streams(
1042: p_api_version => 1.0,
1043: p_init_msg_list => OKC_API.G_FALSE,
1044: x_return_status => x_return_status,
1045: x_msg_count => x_msg_count,
1046: x_msg_data => x_msg_data,
1047: p_stmv_rec => l_stmv_rec,

Line 1053: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1049: x_stmv_rec => x_stmv_rec,
1050: x_selv_tbl => x_selv_tbl
1051: );
1052:
1053: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1054: RAISE copy_failed;
1055: END IF;
1056:
1057: END LOOP; -- Header stream

Line 1064: x_return_status := OKC_API.G_RET_STS_ERROR;

1060: RETURN;
1061:
1062: EXCEPTION
1063: WHEN copy_failed THEN
1064: x_return_status := OKC_API.G_RET_STS_ERROR;
1065: END copy_rebook_stream;
1066:
1067: ------------------------------------------------------------------------------
1068: -- PROCEDURE get_orig_chr_id

Line 1096: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1092: IF (G_DEBUG_ENABLED = 'Y') THEN
1093: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1094: END IF;
1095:
1096: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1097: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1098: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
1099: END IF;
1100:

Line 1121: x_return_status := OKC_API.G_RET_STS_ERROR;

1117: WHEN orig_failed THEN
1118: IF orig_csr%ISOPEN THEN
1119: CLOSE orig_csr;
1120: END IF;
1121: x_return_status := OKC_API.G_RET_STS_ERROR;
1122:
1123: END get_orig_chr_id;
1124:
1125: ------------------------------------------------------------------------------

Line 1160: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1156: BEGIN
1157: IF (G_DEBUG_ENABLED = 'Y') THEN
1158: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1159: END IF;
1160: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1161:
1162: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1163: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
1164: END IF;

Line 1200: p_init_msg_list => OKC_API.G_FALSE,

1196: END IF;
1197:
1198: okl_streams_pub.update_streams(
1199: p_api_version => 1.0,
1200: p_init_msg_list => OKC_API.G_FALSE,
1201: x_return_status => x_return_status,
1202: x_msg_count => x_msg_count,
1203: x_msg_data => x_msg_data,
1204: p_stmv_rec => l_stmv_rec,

Line 1210: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1206: );
1207: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1208: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After Update API Call');
1209: END IF;
1210: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1211: RAISE strm_failed;
1212: END IF;
1213:
1214: END LOOP;

Line 1223: x_return_status := OKC_API.G_RET_STS_ERROR;

1219: WHEN strm_failed THEN
1220: IF strm_csr%ISOPEN THEN
1221: CLOSE strm_csr;
1222: END IF;
1223: x_return_status := OKC_API.G_RET_STS_ERROR;
1224: END change_stream_status;
1225:
1226: ------------------------------------------------------------------------------
1227: -- PROCEDURE get_sll_rules

Line 1686: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1682: BEGIN
1683: IF (G_DEBUG_ENABLED = 'Y') THEN
1684: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1685: END IF;
1686: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1687: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1688: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
1689: END IF;
1690:

Line 1716: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

1712: p_rgpv_rec => l_rgpv_rec,
1713: x_rgpv_rec => x_rgpv_rec
1714: );
1715:
1716: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1717: RAISE sync_header_failed;
1718: END IF;
1719:
1720: l_orig_rgp_id := x_rgpv_rec.id;

Line 1745: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

1741: x_msg_data => x_msg_data,
1742: x_rulv_tbl => x_slh_rulv_tbl,
1743: x_rule_count => x_slh_rule_count
1744: );
1745: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1746: RAISE sync_header_failed;
1747: END IF;
1748:
1749: --x_slh_rulv_tbl_out := x_slh_rulv_tbl;

Line 1760: p_init_msg_list => Okc_Api.G_FALSE,

1756: l_slh_rulv_rec.dnz_chr_id := p_orig_chr_id;
1757:
1758: Okl_Rule_Pub.create_rule(
1759: p_api_version => 1.0,
1760: p_init_msg_list => Okc_Api.G_FALSE,
1761: x_return_status => x_return_status,
1762: x_msg_count => x_msg_count,
1763: x_msg_data => x_msg_data,
1764: p_rulv_rec => l_slh_rulv_rec,

Line 1767: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

1763: x_msg_data => x_msg_data,
1764: p_rulv_rec => l_slh_rulv_rec,
1765: x_rulv_rec => x_new_slh_rulv_rec
1766: );
1767: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1768: x_return_status := Okc_Api.G_RET_STS_ERROR;
1769: RAISE sync_header_failed;
1770: END IF;
1771:

Line 1768: x_return_status := Okc_Api.G_RET_STS_ERROR;

1764: p_rulv_rec => l_slh_rulv_rec,
1765: x_rulv_rec => x_new_slh_rulv_rec
1766: );
1767: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1768: x_return_status := Okc_Api.G_RET_STS_ERROR;
1769: RAISE sync_header_failed;
1770: END IF;
1771:
1772: --

Line 1785: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

1781: p_slh_id => x_slh_rulv_tbl(i).id,
1782: x_rulv_tbl => x_sll_rulv_tbl,
1783: x_rule_count => x_sll_rule_count
1784: );
1785: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1786: RAISE sync_header_failed;
1787: END IF;
1788:
1789: --x_sll_rulv_tbl_out := x_sll_rulv_tbl;

Line 1803: p_init_msg_list => Okc_Api.G_FALSE,

1799: l_sll_rulv_rec.dnz_chr_id := p_orig_chr_id;
1800:
1801: Okl_Rule_Pub.create_rule(
1802: p_api_version => 1.0,
1803: p_init_msg_list => Okc_Api.G_FALSE,
1804: x_return_status => x_return_status,
1805: x_msg_count => x_msg_count,
1806: x_msg_data => x_msg_data,
1807: p_rulv_rec => l_sll_rulv_rec,

Line 1810: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

1806: x_msg_data => x_msg_data,
1807: p_rulv_rec => l_sll_rulv_rec,
1808: x_rulv_rec => x_rulv_rec
1809: );
1810: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1811: x_return_status := Okc_Api.G_RET_STS_ERROR;
1812: RAISE sync_header_failed;
1813: END IF;
1814: END LOOP; -- SLL

Line 1811: x_return_status := Okc_Api.G_RET_STS_ERROR;

1807: p_rulv_rec => l_sll_rulv_rec,
1808: x_rulv_rec => x_rulv_rec
1809: );
1810: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1811: x_return_status := Okc_Api.G_RET_STS_ERROR;
1812: RAISE sync_header_failed;
1813: END IF;
1814: END LOOP; -- SLL
1815:

Line 1822: x_return_status := OKC_API.G_RET_STS_ERROR;

1818: END LOOP;
1819:
1820: EXCEPTION
1821: WHEN sync_header_failed THEN
1822: x_return_status := OKC_API.G_RET_STS_ERROR;
1823:
1824: END sync_header_slh_sll;
1825:
1826: ------------------------------------------------------------------------------

Line 1943: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1939: BEGIN
1940: IF (G_DEBUG_ENABLED = 'Y') THEN
1941: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1942: END IF;
1943: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1944: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1945: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
1946: END IF;
1947:

Line 1963: p_init_msg_list => OKC_API.G_FALSE,

1959: END LOOP;
1960:
1961: okl_rule_pub.delete_rule(
1962: p_api_version => 1.0,
1963: p_init_msg_list => OKC_API.G_FALSE,
1964: x_return_status => x_return_status,
1965: x_msg_count => x_msg_count,
1966: x_msg_data => x_msg_data,
1967: p_rulv_tbl => l_rulv_tbl

Line 1969: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1965: x_msg_count => x_msg_count,
1966: x_msg_data => x_msg_data,
1967: p_rulv_tbl => l_rulv_tbl
1968: );
1969: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1970: RAISE sync_failed;
1971: END IF;
1972: */
1973:

Line 1991: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1987: p_for_line => 'N',
1988: p_rebook_chr_id => p_rebook_chr_id,
1989: p_orig_chr_id => p_orig_chr_id
1990: );
1991: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1992: RAISE sync_failed;
1993: END IF;
1994: GOTO process_next;
1995:

Line 2033: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

2029: x_msg_data => x_msg_data,
2030: x_rulv_tbl => x_slh_rulv_tbl,
2031: x_rule_count => x_slh_rule_count
2032: );
2033: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2034: RAISE sync_failed;
2035: END IF;
2036:
2037: --x_slh_rulv_tbl_out := x_slh_rulv_tbl;

Line 2051: p_init_msg_list => Okc_Api.G_False,

2047: l_lalevl_rgpv_rec.rgp_type := 'KRG';
2048:
2049: OKL_RULE_PUB.create_rule_group(
2050: p_api_version => 1.0,
2051: p_init_msg_list => Okc_Api.G_False,
2052: x_return_status => x_return_status,
2053: x_msg_count => x_msg_count,
2054: x_msg_data => x_msg_data,
2055: p_rgpv_rec => l_lalevl_rgpv_rec,

Line 2058: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

2054: x_msg_data => x_msg_data,
2055: p_rgpv_rec => l_lalevl_rgpv_rec,
2056: x_rgpv_rec => x_lalevl_rgpv_rec);
2057:
2058: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2059: RAISE sync_failed;
2060: END IF;
2061:
2062: l_orig_rgp_id := x_lalevl_rgpv_rec.id;

Line 2075: p_init_msg_list => Okc_Api.G_FALSE,

2071: l_slh_rulv_rec.dnz_chr_id := p_orig_chr_id;
2072:
2073: Okl_Rule_Pub.create_rule(
2074: p_api_version => 1.0,
2075: p_init_msg_list => Okc_Api.G_FALSE,
2076: x_return_status => x_return_status,
2077: x_msg_count => x_msg_count,
2078: x_msg_data => x_msg_data,
2079: p_rulv_rec => l_slh_rulv_rec,

Line 2082: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

2078: x_msg_data => x_msg_data,
2079: p_rulv_rec => l_slh_rulv_rec,
2080: x_rulv_rec => x_new_slh_rulv_rec
2081: );
2082: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2083: x_return_status := Okc_Api.G_RET_STS_ERROR;
2084: RAISE sync_failed;
2085: END IF;
2086:

Line 2083: x_return_status := Okc_Api.G_RET_STS_ERROR;

2079: p_rulv_rec => l_slh_rulv_rec,
2080: x_rulv_rec => x_new_slh_rulv_rec
2081: );
2082: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2083: x_return_status := Okc_Api.G_RET_STS_ERROR;
2084: RAISE sync_failed;
2085: END IF;
2086:
2087: --

Line 2100: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

2096: p_slh_id => x_slh_rulv_tbl(i).id,
2097: x_rulv_tbl => x_sll_rulv_tbl,
2098: x_rule_count => x_sll_rule_count
2099: );
2100: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2101: RAISE sync_failed;
2102: END IF;
2103:
2104: --x_sll_rulv_tbl_out := x_sll_rulv_tbl;

Line 2118: p_init_msg_list => Okc_Api.G_FALSE,

2114: l_sll_rulv_rec.dnz_chr_id := p_orig_chr_id;
2115:
2116: Okl_Rule_Pub.create_rule(
2117: p_api_version => 1.0,
2118: p_init_msg_list => Okc_Api.G_FALSE,
2119: x_return_status => x_return_status,
2120: x_msg_count => x_msg_count,
2121: x_msg_data => x_msg_data,
2122: p_rulv_rec => l_sll_rulv_rec,

Line 2125: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

2121: x_msg_data => x_msg_data,
2122: p_rulv_rec => l_sll_rulv_rec,
2123: x_rulv_rec => x_rulv_rec
2124: );
2125: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2126: x_return_status := Okc_Api.G_RET_STS_ERROR;
2127: RAISE sync_failed;
2128: END IF;
2129: END LOOP; -- SLL

Line 2126: x_return_status := Okc_Api.G_RET_STS_ERROR;

2122: p_rulv_rec => l_sll_rulv_rec,
2123: x_rulv_rec => x_rulv_rec
2124: );
2125: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2126: x_return_status := Okc_Api.G_RET_STS_ERROR;
2127: RAISE sync_failed;
2128: END IF;
2129: END LOOP; -- SLL
2130:

Line 2139: x_return_status := OKC_API.G_RET_STS_ERROR;

2135: END LOOP;
2136:
2137: EXCEPTION
2138: WHEN sync_failed THEN
2139: x_return_status := OKC_API.G_RET_STS_ERROR;
2140: END sync_slh_sll;
2141:
2142: ------------------------------------------------------------------------------
2143: -- PROCEDURE sync_sales_tax

Line 2203: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

2199: p_rule_code => 'LASTCL',
2200: x_rulv_rec => x_rbk_lastcl_rec,
2201: x_rule_count => x_rbk_lastcl_count
2202: );
2203: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2204: x_return_status := Okc_Api.G_RET_STS_ERROR;
2205: RAISE sync_tax_failed;
2206: END IF;
2207:

Line 2204: x_return_status := Okc_Api.G_RET_STS_ERROR;

2200: x_rulv_rec => x_rbk_lastcl_rec,
2201: x_rule_count => x_rbk_lastcl_count
2202: );
2203: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2204: x_return_status := Okc_Api.G_RET_STS_ERROR;
2205: RAISE sync_tax_failed;
2206: END IF;
2207:
2208: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 2222: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

2218: x_rulv_rec => x_orig_lastcl_rec,
2219: x_rule_count => x_orig_lastcl_count
2220: );
2221:
2222: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2223: x_return_status := Okc_Api.G_RET_STS_ERROR;
2224: RAISE sync_tax_failed;
2225: END IF;
2226:

Line 2223: x_return_status := Okc_Api.G_RET_STS_ERROR;

2219: x_rule_count => x_orig_lastcl_count
2220: );
2221:
2222: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2223: x_return_status := Okc_Api.G_RET_STS_ERROR;
2224: RAISE sync_tax_failed;
2225: END IF;
2226:
2227: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 2267: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

2263: p_rulv_rec => x_rbk_lastcl_rec,
2264: x_rulv_rec => x_rulv_rec
2265: );
2266:
2267: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2268: x_return_status := Okc_Api.G_RET_STS_ERROR;
2269: RAISE sync_tax_failed;
2270: END IF;
2271: END IF; -- LASTCL changed

Line 2268: x_return_status := Okc_Api.G_RET_STS_ERROR;

2264: x_rulv_rec => x_rulv_rec
2265: );
2266:
2267: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2268: x_return_status := Okc_Api.G_RET_STS_ERROR;
2269: RAISE sync_tax_failed;
2270: END IF;
2271: END IF; -- LASTCL changed
2272: END IF;

Line 2293: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

2289: p_rgpv_rec => l_rgpv_rec,
2290: x_rgpv_rec => x_rgpv_rec
2291: );
2292:
2293: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2294: x_return_status := Okc_Api.G_RET_STS_ERROR;
2295: RAISE sync_tax_failed;
2296: END IF;
2297:

Line 2294: x_return_status := Okc_Api.G_RET_STS_ERROR;

2290: x_rgpv_rec => x_rgpv_rec
2291: );
2292:
2293: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2294: x_return_status := Okc_Api.G_RET_STS_ERROR;
2295: RAISE sync_tax_failed;
2296: END IF;
2297:
2298: x_rbk_lastcl_rec.id := NULL;

Line 2310: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

2306: p_rulv_rec => x_rbk_lastcl_rec,
2307: x_rulv_rec => x_rulv_rec
2308: );
2309:
2310: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2311: x_return_status := Okc_Api.G_RET_STS_ERROR;
2312: RAISE sync_tax_failed;
2313: END IF;
2314:

Line 2311: x_return_status := Okc_Api.G_RET_STS_ERROR;

2307: x_rulv_rec => x_rulv_rec
2308: );
2309:
2310: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2311: x_return_status := Okc_Api.G_RET_STS_ERROR;
2312: RAISE sync_tax_failed;
2313: END IF;
2314:
2315: END IF; -- LASTCL

Line 2327: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

2323: p_rule_code => 'LASTPR',
2324: x_rulv_rec => x_rbk_lastpr_rec,
2325: x_rule_count => x_rbk_lastpr_count
2326: );
2327: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2328: x_return_status := Okc_Api.G_RET_STS_ERROR;
2329: RAISE sync_tax_failed;
2330: END IF;
2331:

Line 2328: x_return_status := Okc_Api.G_RET_STS_ERROR;

2324: x_rulv_rec => x_rbk_lastpr_rec,
2325: x_rule_count => x_rbk_lastpr_count
2326: );
2327: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2328: x_return_status := Okc_Api.G_RET_STS_ERROR;
2329: RAISE sync_tax_failed;
2330: END IF;
2331:
2332: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 2346: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

2342: x_rulv_rec => x_orig_lastpr_rec,
2343: x_rule_count => x_orig_lastpr_count
2344: );
2345:
2346: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2347: x_return_status := Okc_Api.G_RET_STS_ERROR;
2348: RAISE sync_tax_failed;
2349: END IF;
2350:

Line 2347: x_return_status := Okc_Api.G_RET_STS_ERROR;

2343: x_rule_count => x_orig_lastpr_count
2344: );
2345:
2346: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2347: x_return_status := Okc_Api.G_RET_STS_ERROR;
2348: RAISE sync_tax_failed;
2349: END IF;
2350:
2351: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 2385: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

2381: p_rulv_rec => x_rbk_lastpr_rec,
2382: x_rulv_rec => x_rulv_rec
2383: );
2384:
2385: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2386: x_return_status := Okc_Api.G_RET_STS_ERROR;
2387: RAISE sync_tax_failed;
2388: END IF;
2389: END IF; -- LASTCL changed

Line 2386: x_return_status := Okc_Api.G_RET_STS_ERROR;

2382: x_rulv_rec => x_rulv_rec
2383: );
2384:
2385: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2386: x_return_status := Okc_Api.G_RET_STS_ERROR;
2387: RAISE sync_tax_failed;
2388: END IF;
2389: END IF; -- LASTCL changed
2390: END IF;

Line 2415: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

2411: p_rgpv_rec => l_rgpv_rec,
2412: x_rgpv_rec => x_rgpv_rec
2413: );
2414:
2415: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2416: x_return_status := Okc_Api.G_RET_STS_ERROR;
2417: RAISE sync_tax_failed;
2418: END IF;
2419: END IF;

Line 2416: x_return_status := Okc_Api.G_RET_STS_ERROR;

2412: x_rgpv_rec => x_rgpv_rec
2413: );
2414:
2415: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2416: x_return_status := Okc_Api.G_RET_STS_ERROR;
2417: RAISE sync_tax_failed;
2418: END IF;
2419: END IF;
2420: x_rbk_lastpr_rec.id := NULL;

Line 2432: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

2428: p_rulv_rec => x_rbk_lastpr_rec,
2429: x_rulv_rec => x_rulv_rec
2430: );
2431:
2432: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2433: x_return_status := Okc_Api.G_RET_STS_ERROR;
2434: RAISE sync_tax_failed;
2435: END IF;
2436:

Line 2433: x_return_status := Okc_Api.G_RET_STS_ERROR;

2429: x_rulv_rec => x_rulv_rec
2430: );
2431:
2432: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2433: x_return_status := Okc_Api.G_RET_STS_ERROR;
2434: RAISE sync_tax_failed;
2435: END IF;
2436:
2437: END IF; -- LASTPR

Line 2440: x_return_status := OKC_API.G_RET_STS_ERROR;

2436:
2437: END IF; -- LASTPR
2438: EXCEPTION
2439: WHEN sync_tax_failed THEN
2440: x_return_status := OKC_API.G_RET_STS_ERROR;
2441: END sync_sales_tax;
2442:
2443: ------------------------------------------------------------------------------
2444: -- PROCEDURE sync_party_role

Line 2812: x_return_status := OKC_API.G_RET_STS_ERROR;

2808: END LOOP; -- role
2809:
2810: EXCEPTION
2811: WHEN sync_party_failed THEN
2812: x_return_status := OKC_API.G_RET_STS_ERROR;
2813: END sync_party_role;
2814:
2815: ------------------------------------------------------------------------------
2816: -- PROCEDURE sync_header_values

Line 2887: x_return_status := OKC_API.G_RET_STS_SUCCESS;

2883: END IF;
2884: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2885: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
2886: END IF;
2887: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2888:
2889: l_khrv_rec := get_khrv_rec(
2890: p_khr_id => p_orig_chr_id,
2891: x_return_status => x_return_status

Line 2950: p_init_msg_list => OKC_API.G_FALSE,

2946: l_chrv_rec.end_date := header_rec.end_date;
2947:
2948: okl_contract_pub.update_contract_header(
2949: p_api_version => 1.0,
2950: p_init_msg_list => OKC_API.G_FALSE,
2951: x_return_status => x_return_status,
2952: x_msg_count => x_msg_count,
2953: x_msg_data => x_msg_data,
2954: p_restricted_update => OKC_API.G_FALSE,

Line 2954: p_restricted_update => OKC_API.G_FALSE,

2950: p_init_msg_list => OKC_API.G_FALSE,
2951: x_return_status => x_return_status,
2952: x_msg_count => x_msg_count,
2953: x_msg_data => x_msg_data,
2954: p_restricted_update => OKC_API.G_FALSE,
2955: p_chrv_rec => l_chrv_rec,
2956: p_khrv_rec => l_khrv_rec,
2957: x_chrv_rec => x_chrv_rec,
2958: x_khrv_rec => x_khrv_rec

Line 2960: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

2956: p_khrv_rec => l_khrv_rec,
2957: x_chrv_rec => x_chrv_rec,
2958: x_khrv_rec => x_khrv_rec
2959: );
2960: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2961: x_return_status := Okc_Api.G_RET_STS_ERROR;
2962: RAISE sync_failed;
2963: END IF;
2964:

Line 2961: x_return_status := Okc_Api.G_RET_STS_ERROR;

2957: x_chrv_rec => x_chrv_rec,
2958: x_khrv_rec => x_khrv_rec
2959: );
2960: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2961: x_return_status := Okc_Api.G_RET_STS_ERROR;
2962: RAISE sync_failed;
2963: END IF;
2964:
2965: END LOOP;

Line 2971: x_return_status := OKC_API.G_RET_STS_ERROR;

2967: RETURN;
2968:
2969: EXCEPTION
2970: WHEN sync_failed THEN
2971: x_return_status := OKC_API.G_RET_STS_ERROR;
2972: END sync_header_values;
2973:
2974: PROCEDURE sync_passthru_party(
2975: x_return_status OUT NOCOPY VARCHAR2

Line 3940: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

3936: p_klev_rec => l_klev_rec,
3937: x_clev_rec => x_clev_rec,
3938: x_klev_rec => x_klev_rec
3939: );
3940: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3941: RAISE sync_fee_failed;
3942: END IF;
3943:
3944: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 3969: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

3965: p_klev_rec => l_klev_rec,
3966: x_clev_rec => x_clev_rec,
3967: x_klev_rec => x_klev_rec
3968: );
3969: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3970: RAISE sync_fee_failed;
3971: END IF;
3972: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3973: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Sub line deleted');

Line 3989: p_init_msg_list => OKC_API.G_FALSE,

3985: END LOOP;
3986: IF (l_orig_fee_strm_tbl.COUNT <> 0) THEN
3987: okl_streams_pub.update_streams(
3988: p_api_version => 1.0,
3989: p_init_msg_list => OKC_API.G_FALSE,
3990: x_return_status => x_return_status,
3991: x_msg_count => x_msg_count,
3992: x_msg_data => x_msg_data,
3993: p_stmv_tbl => l_orig_fee_strm_tbl,

Line 3997: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

3993: p_stmv_tbl => l_orig_fee_strm_tbl,
3994: x_stmv_tbl => x_orig_fee_strm_tbl
3995: );
3996:
3997: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3998: RAISE sync_fee_failed;
3999: END IF;
4000: END IF; -- end of l_orig_fee_strm_tbl.COUNT <> 0
4001: END LOOP; -- Orig Fee line ABANDON

Line 4037: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

4033: p_trans_type => 'CRB',
4034: x_cle_id_tbl => lx_rbk_fee_tbl
4035: );
4036:
4037: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4038: RAISE sync_fee_failed;
4039: END IF;
4040:
4041: END IF;

Line 4079: p_init_msg_list => OKC_API.G_FALSE,

4075: l_rvi_klev_rec.attribute15 := rvi_fee_rec.attribute15;
4076:
4077: okl_contract_pub.update_contract_line(
4078: p_api_version => 1.0,
4079: p_init_msg_list => OKC_API.G_FALSE,
4080: x_return_status => x_return_status,
4081: x_msg_count => x_msg_count,
4082: x_msg_data => x_msg_data,
4083: p_clev_rec => l_rvi_clev_rec,

Line 4089: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

4085: x_clev_rec => x_clev_rec,
4086: x_klev_rec => x_klev_rec
4087: );
4088:
4089: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4090: RAISE sync_fee_failed;
4091: END IF;
4092:
4093: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 4237: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

4233: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4234: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL.H*** After Update Top line: '||x_return_status);
4235: END IF;
4236:
4237: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4238: RAISE sync_fee_failed;
4239: END IF;
4240: END IF; -- end of attribute comparision and calling update_fee_type API
4241:

Line 4244: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

4240: END IF; -- end of attribute comparision and calling update_fee_type API
4241:
4242: IF (c_fee_rbk_rec.fee_type = 'PASSTHROUGH') THEN
4243: sync_passthru_party(x_return_status => x_return_status);
4244: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4245: RAISE sync_fee_failed;
4246: END IF;
4247: ELSE
4248: -- Sync Fee expense rules for Financed Fee line

Line 4307: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

4303: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4304: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Update LAFREQ : '||x_return_status);
4305: END IF;
4306:
4307: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
4308: x_return_status := Okc_Api.G_RET_STS_ERROR;
4309: RAISE sync_fee_failed;
4310: END IF;
4311: END IF;

Line 4308: x_return_status := Okc_Api.G_RET_STS_ERROR;

4304: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Update LAFREQ : '||x_return_status);
4305: END IF;
4306:
4307: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
4308: x_return_status := Okc_Api.G_RET_STS_ERROR;
4309: RAISE sync_fee_failed;
4310: END IF;
4311: END IF;
4312:

Line 4369: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

4365: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4366: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Update LAFEXP : '||x_return_status);
4367: END IF;
4368:
4369: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
4370: x_return_status := Okc_Api.G_RET_STS_ERROR;
4371: RAISE sync_fee_failed;
4372: END IF;
4373: END IF;

Line 4370: x_return_status := Okc_Api.G_RET_STS_ERROR;

4366: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Update LAFEXP : '||x_return_status);
4367: END IF;
4368:
4369: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
4370: x_return_status := Okc_Api.G_RET_STS_ERROR;
4371: RAISE sync_fee_failed;
4372: END IF;
4373: END IF;
4374: END IF;

Line 4420: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

4416: x_cplv_rec => x_cplv_rec,
4417: p_kplv_rec => l_kplv_rec,
4418: x_kplv_rec => x_kplv_rec );
4419:
4420: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4421: RAISE sync_fee_failed;
4422: END IF;
4423: END IF;
4424: ELSE -- new party

Line 4461: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

4457: x_cplv_rec => x_cplv_rec,
4458: p_kplv_rec => l_kplv_rec,
4459: x_kplv_rec => x_kplv_rec);
4460:
4461: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4462: RAISE sync_fee_failed;
4463: END IF;
4464: END IF;
4465: END LOOP; -- party

Line 4553: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

4549: x_msg_data => x_msg_data,
4550: p_line_item_tbl => l_u_line_item_tbl,
4551: x_line_item_tbl => x_u_line_item_tbl
4552: );
4553: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4554: RAISE sync_fee_failed;
4555: END IF;
4556: END IF;
4557: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 4568: p_init_msg_list => OKC_API.G_FALSE,

4564: -- new covered asset lines.
4565: IF (l_cov_ast_tbl.COUNT > 0) THEN
4566: okl_copy_asset_pub.copy_all_lines(
4567: p_api_version => 1.0,
4568: p_init_msg_list => OKC_API.G_FALSE,
4569: x_return_status => x_return_status,
4570: x_msg_count => x_msg_count,
4571: x_msg_data => x_msg_data,
4572: P_from_cle_id_tbl => l_cov_ast_tbl,

Line 4582: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

4578: p_renew_ref_yn => 'N',
4579: p_trans_type => 'CRB',
4580: x_cle_id_tbl => lx_cov_ast_tbl
4581: );
4582: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4583: RAISE sync_fee_failed;
4584: END IF;
4585: END IF;
4586:

Line 4603: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

4599: x_msg_data => x_msg_data,
4600: p_line_item_tbl => l_c_line_item_tbl,
4601: x_line_item_tbl => x_c_line_item_tbl
4602: );
4603: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4604: RAISE sync_fee_failed;
4605: END IF;
4606: END IF;
4607: debug_message('Link Fee asset inserted; '||l_c_line_item_tbl.COUNT);

Line 4622: x_return_status := 'OKC_API.G_RET_STS_ERROR';

4618: WHEN sync_fee_failed THEN
4619: x_return_status := OKL_API.G_RET_STS_ERROR;
4620:
4621: when OKL_API.G_EXCEPTION_ERROR then
4622: x_return_status := 'OKC_API.G_RET_STS_ERROR';
4623:
4624: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
4625: x_return_status := 'OKC_API.G_RET_STS_UNEXP_ERROR';
4626:

Line 4625: x_return_status := 'OKC_API.G_RET_STS_UNEXP_ERROR';

4621: when OKL_API.G_EXCEPTION_ERROR then
4622: x_return_status := 'OKC_API.G_RET_STS_ERROR';
4623:
4624: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
4625: x_return_status := 'OKC_API.G_RET_STS_UNEXP_ERROR';
4626:
4627: END sync_fee_line;
4628:
4629: ------------------------------------------------------------------------------

Line 4779: x_return_status := OKC_API.G_RET_STS_SUCCESS;

4775: BEGIN
4776: IF (G_DEBUG_ENABLED = 'Y') THEN
4777: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
4778: END IF;
4779: x_return_status := OKC_API.G_RET_STS_SUCCESS;
4780: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4781: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
4782: END IF;
4783:

Line 4802: p_init_msg_list => OKC_API.G_FALSE,

4798: END LOOP;
4799:
4800: okl_rule_pub.delete_rule(
4801: p_api_version => 1.0,
4802: p_init_msg_list => OKC_API.G_FALSE,
4803: x_return_status => x_return_status,
4804: x_msg_count => x_msg_count,
4805: x_msg_data => x_msg_data,
4806: p_rulv_tbl => l_rulv_tbl

Line 4808: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

4804: x_msg_count => x_msg_count,
4805: x_msg_data => x_msg_data,
4806: p_rulv_tbl => l_rulv_tbl
4807: );
4808: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4809: RAISE sync_failed;
4810: END IF;
4811:
4812: i := 1;

Line 4956: p_init_msg_list => okc_api.g_false,

4952:
4953: okl_okc_migration_pvt.update_contract_item(
4954:
4955: p_api_version => 1.0,
4956: p_init_msg_list => okc_api.g_false,
4957: x_return_status =>x_return_status,
4958: x_msg_count =>x_msg_count,
4959: x_msg_data =>x_msg_data,
4960: p_cimv_rec =>l_cim_rec,

Line 4964: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

4960: p_cimv_rec =>l_cim_rec,
4961: x_cimv_rec =>x_cim_rec);
4962:
4963:
4964: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4965: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4966: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' okc_cim_pvt.update_row sync_failed= ');
4967: END IF;
4968: RAISE sync_failed;

Line 4998: p_init_msg_list => OKC_API.G_FALSE,

4994: END IF;
4995:
4996: okl_contract_pub.update_contract_line(
4997: p_api_version => 1.0,
4998: p_init_msg_list => OKC_API.G_FALSE,
4999: x_return_status => x_return_status,
5000: x_msg_count => x_msg_count,
5001: x_msg_data => x_msg_data,
5002: p_clev_tbl => l_clev_tbl,

Line 5007: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

5003: p_klev_tbl => l_klev_tbl,
5004: x_clev_tbl => x_clev_tbl,
5005: x_klev_tbl => x_klev_tbl
5006: );
5007: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5008: RAISE sync_failed;
5009: END IF;
5010:
5011: j := 1;

Line 5041: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

5037: p_trans_type => 'CRB',
5038: x_cle_id_tbl => lx_new_klev_tbl
5039: );
5040:
5041: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5042: RAISE sync_failed;
5043: END IF;
5044:
5045: --

Line 5101: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

5097: p_trans_type => 'CRB',
5098: x_cle_id_tbl => lx_new_klev_tbl
5099: );
5100:
5101: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5102: RAISE sync_failed;
5103: END IF;
5104:
5105: --

Line 5149: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

5145: p_rebook_chr_id => p_rebook_chr_id,
5146: p_orig_chr_id => p_orig_chr_id
5147: );
5148:
5149: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5150: RAISE sync_failed;
5151: END IF;
5152:
5153: EXCEPTION

Line 5155: x_return_status := OKC_API.G_RET_STS_ERROR;

5151: END IF;
5152:
5153: EXCEPTION
5154: WHEN sync_failed THEN
5155: x_return_status := OKC_API.G_RET_STS_ERROR;
5156: END sync_line_values;
5157:
5158: ------------------------------------------------------------------------------
5159: -- PROCEDURE version_contract

Line 5184: x_return_status := OKC_API.G_RET_STS_SUCCESS;

5180: END IF;
5181: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
5182: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
5183: END IF;
5184: x_return_status := OKC_API.G_RET_STS_SUCCESS;
5185:
5186: l_cvmv_rec.chr_id := p_chr_id;
5187: okl_version_pub.version_contract(
5188: p_api_version => 1.0,

Line 5189: p_init_msg_list => OKC_API.G_FALSE,

5185:
5186: l_cvmv_rec.chr_id := p_chr_id;
5187: okl_version_pub.version_contract(
5188: p_api_version => 1.0,
5189: p_init_msg_list => OKC_API.G_FALSE,
5190: x_return_status => x_return_status,
5191: x_msg_count => x_msg_count,
5192: x_msg_data => x_msg_data,
5193: p_cvmv_rec => l_cvmv_rec,

Line 5195: --p_commit => OKC_API.G_FALSE

5191: x_msg_count => x_msg_count,
5192: x_msg_data => x_msg_data,
5193: p_cvmv_rec => l_cvmv_rec,
5194: x_cvmv_rec => x_cvmv_rec --,
5195: --p_commit => OKC_API.G_FALSE
5196: );
5197: RETURN;
5198:
5199: END version_contract;

Line 5256: x_return_status := OKC_API.G_RET_STS_SUCCESS;

5252: END IF;
5253: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
5254: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
5255: END IF;
5256: x_return_status := OKC_API.G_RET_STS_SUCCESS;
5257:
5258: l_orig_term := NULL;
5259: OPEN term_csr(p_orig_chr_id);
5260: FETCH term_csr INTO l_orig_term,

Line 5309: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

5305: x_chrv_rec => x_chrv_rec,
5306: x_khrv_rec => x_khrv_rec
5307: );
5308:
5309: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
5310: RAISE check_update_failed;
5311: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
5312: RAISE check_update_failed;
5313: END IF;

Line 5311: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

5307: );
5308:
5309: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
5310: RAISE check_update_failed;
5311: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
5312: RAISE check_update_failed;
5313: END IF;
5314:
5315: END IF;

Line 5338: p_init_msg_list IN VARCHAR2, -- DEFAULT OKC_API.G_FALSE,

5334: -- Called By:
5335: ------------------------------------------------------------------------------
5336: PROCEDURE sync_rebook_orig_contract(
5337: p_api_version IN NUMBER,
5338: p_init_msg_list IN VARCHAR2, -- DEFAULT OKC_API.G_FALSE,
5339: x_return_status OUT NOCOPY VARCHAR2,
5340: x_msg_count OUT NOCOPY NUMBER,
5341: x_msg_data OUT NOCOPY VARCHAR2,
5342: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE

Line 5374: x_return_status := OKC_API.G_RET_STS_SUCCESS;

5370: IF (G_DEBUG_ENABLED = 'Y') THEN
5371: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
5372: END IF;
5373:
5374: x_return_status := OKC_API.G_RET_STS_SUCCESS;
5375: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
5376: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
5377: END IF;
5378: -- call START_ACTIVITY to create savepoint, check compatibility

Line 5380: x_return_status := OKC_API.START_ACTIVITY(

5376: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
5377: END IF;
5378: -- call START_ACTIVITY to create savepoint, check compatibility
5379: -- and initialize message list
5380: x_return_status := OKC_API.START_ACTIVITY(
5381: p_api_name => l_api_name,
5382: p_pkg_name => G_PKG_NAME,
5383: p_init_msg_list => p_init_msg_list,
5384: l_api_version => p_api_version,

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

5386: p_api_type => G_API_TYPE,
5387: x_return_status => x_return_status);
5388:
5389: -- check if activity started successfully
5390: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5391: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5392: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5393: RAISE OKC_API.G_EXCEPTION_ERROR;
5394: END IF;

Line 5391: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5387: x_return_status => x_return_status);
5388:
5389: -- check if activity started successfully
5390: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5391: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5392: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5393: RAISE OKC_API.G_EXCEPTION_ERROR;
5394: END IF;
5395:

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

5388:
5389: -- check if activity started successfully
5390: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5391: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5392: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5393: RAISE OKC_API.G_EXCEPTION_ERROR;
5394: END IF;
5395:
5396: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Line 5393: RAISE OKC_API.G_EXCEPTION_ERROR;

5389: -- check if activity started successfully
5390: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5391: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5392: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5393: RAISE OKC_API.G_EXCEPTION_ERROR;
5394: END IF;
5395:
5396: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
5397:

Line 5403: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

5399: x_return_status => x_return_status,
5400: p_chr_id => p_rebook_chr_id,
5401: x_orig_chr_id => l_orig_chr_id
5402: );
5403: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5404: okl_api.set_message(
5405: G_APP_NAME,
5406: G_LLA_NO_ORIG_REFERENCE
5407: );

Line 5408: RAISE OKC_API.G_EXCEPTION_ERROR;

5404: okl_api.set_message(
5405: G_APP_NAME,
5406: G_LLA_NO_ORIG_REFERENCE
5407: );
5408: RAISE OKC_API.G_EXCEPTION_ERROR;
5409: END IF;
5410:
5411: --
5412: -- Version the Original Contract

Line 5422: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

5418: x_msg_data => x_msg_data,
5419: p_chr_id => l_orig_chr_id
5420: );
5421:
5422: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5423: RAISE OKC_API.G_EXCEPTION_ERROR;
5424: END IF;
5425:
5426: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 5423: RAISE OKC_API.G_EXCEPTION_ERROR;

5419: p_chr_id => l_orig_chr_id
5420: );
5421:
5422: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5423: RAISE OKC_API.G_EXCEPTION_ERROR;
5424: END IF;
5425:
5426: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
5427: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After Versioning of Contract');

Line 5449: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

5445: p_orig_chr_id => l_orig_chr_id,
5446: p_rebook_chr_id => p_rebook_chr_id
5447: );
5448:
5449: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5450: RAISE OKC_API.G_EXCEPTION_ERROR;
5451: END IF;
5452:
5453: --

Line 5450: RAISE OKC_API.G_EXCEPTION_ERROR;

5446: p_rebook_chr_id => p_rebook_chr_id
5447: );
5448:
5449: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5450: RAISE OKC_API.G_EXCEPTION_ERROR;
5451: END IF;
5452:
5453: --
5454: -- Fix Bug# 3042346

Line 5464: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

5460: p_rebook_chr_id => p_rebook_chr_id,
5461: p_orig_chr_id => l_orig_chr_id
5462: );
5463:
5464: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5465: RAISE OKC_API.G_EXCEPTION_ERROR;
5466: END IF;
5467:
5468: --

Line 5465: RAISE OKC_API.G_EXCEPTION_ERROR;

5461: p_orig_chr_id => l_orig_chr_id
5462: );
5463:
5464: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5465: RAISE OKC_API.G_EXCEPTION_ERROR;
5466: END IF;
5467:
5468: --
5469: -- 1. Adjust Residual Value

Line 5482: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

5478: x_new_klev_tbl => l_update_klev_tbl,
5479: x_new_clev_tbl => l_update_clev_tbl
5480: );
5481:
5482: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5483: RAISE OKC_API.G_EXCEPTION_ERROR;
5484: END IF;
5485:
5486: -- 3. Change Due Date

Line 5483: RAISE OKC_API.G_EXCEPTION_ERROR;

5479: x_new_clev_tbl => l_update_clev_tbl
5480: );
5481:
5482: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5483: RAISE OKC_API.G_EXCEPTION_ERROR;
5484: END IF;
5485:
5486: -- 3. Change Due Date
5487: -- 4. Change Start Date

Line 5500: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

5496: p_rebook_chr_id => p_rebook_chr_id,
5497: p_orig_chr_id => l_orig_chr_id
5498: );
5499:
5500: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5501: RAISE OKC_API.G_EXCEPTION_ERROR;
5502: END IF;
5503:
5504: --4542290

Line 5501: RAISE OKC_API.G_EXCEPTION_ERROR;

5497: p_orig_chr_id => l_orig_chr_id
5498: );
5499:
5500: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5501: RAISE OKC_API.G_EXCEPTION_ERROR;
5502: END IF;
5503:
5504: --4542290
5505: OKL_K_RATE_PARAMS_PVT.SYNC_RATE_PARAMS(

Line 5518: p_init_msg_list => OKC_API.G_FALSE,

5514: IF l_update_clev_tbl.COUNT > 0 THEN
5515:
5516: OKL_CONTRACT_PUB.update_contract_line(
5517: p_api_version => p_api_version,
5518: p_init_msg_list => OKC_API.G_FALSE,
5519: x_return_status => x_return_status,
5520: x_msg_count => x_msg_count,
5521: x_msg_data => x_msg_data,
5522: p_clev_tbl => l_update_clev_tbl,

Line 5527: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

5523: p_klev_tbl => l_update_klev_tbl,
5524: x_clev_tbl => x_update_clev_tbl,
5525: x_klev_tbl => x_update_klev_tbl);
5526:
5527: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5528: RAISE OKC_API.G_EXCEPTION_ERROR;
5529: END IF;
5530:
5531: END IF;

Line 5528: RAISE OKC_API.G_EXCEPTION_ERROR;

5524: x_clev_tbl => x_update_clev_tbl,
5525: x_klev_tbl => x_update_klev_tbl);
5526:
5527: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5528: RAISE OKC_API.G_EXCEPTION_ERROR;
5529: END IF;
5530:
5531: END IF;
5532:

Line 5542: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

5538: p_rebook_chr_id => p_rebook_chr_id,
5539: p_orig_chr_id => l_orig_chr_id
5540: );
5541:
5542: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5543: RAISE OKC_API.G_EXCEPTION_ERROR;
5544: END IF;
5545:
5546: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 5543: RAISE OKC_API.G_EXCEPTION_ERROR;

5539: p_orig_chr_id => l_orig_chr_id
5540: );
5541:
5542: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5543: RAISE OKC_API.G_EXCEPTION_ERROR;
5544: END IF;
5545:
5546: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
5547: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After SYNC_SLH_SLL');

Line 5564: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

5560: p_rbk_chr_id => p_rebook_chr_id,
5561: p_orig_chr_id => l_orig_chr_id
5562: );
5563:
5564: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5565: raise OKC_API.G_EXCEPTION_ERROR;
5566: END IF;
5567:
5568: debug_message('After Sync Subsidy lines');

Line 5565: raise OKC_API.G_EXCEPTION_ERROR;

5561: p_orig_chr_id => l_orig_chr_id
5562: );
5563:
5564: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5565: raise OKC_API.G_EXCEPTION_ERROR;
5566: END IF;
5567:
5568: debug_message('After Sync Subsidy lines');
5569: */

Line 5580: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

5576: p_rebook_chr_id => p_rebook_chr_id,
5577: p_orig_chr_id => l_orig_chr_id
5578: );
5579:
5580: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5581: RAISE OKC_API.G_EXCEPTION_ERROR;
5582: END IF;
5583: */
5584:

Line 5581: RAISE OKC_API.G_EXCEPTION_ERROR;

5577: p_orig_chr_id => l_orig_chr_id
5578: );
5579:
5580: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5581: RAISE OKC_API.G_EXCEPTION_ERROR;
5582: END IF;
5583: */
5584:
5585: -- Sync passthru vendor and line parameters

Line 5594: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

5590: p_rebook_chr_id => p_rebook_chr_id,
5591: p_orig_chr_id => l_orig_chr_id
5592: );
5593:
5594: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5595: RAISE OKC_API.G_EXCEPTION_ERROR;
5596: END IF;
5597:
5598: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Line 5595: RAISE OKC_API.G_EXCEPTION_ERROR;

5591: p_orig_chr_id => l_orig_chr_id
5592: );
5593:
5594: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5595: RAISE OKC_API.G_EXCEPTION_ERROR;
5596: END IF;
5597:
5598: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
5599: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 5603: WHEN OKC_API.G_EXCEPTION_ERROR THEN

5599: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
5600: x_msg_data => x_msg_data);
5601:
5602: EXCEPTION
5603: WHEN OKC_API.G_EXCEPTION_ERROR THEN
5604: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
5605: p_api_name => l_api_name,
5606: p_pkg_name => G_PKG_NAME,
5607: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 5604: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

5600: x_msg_data => x_msg_data);
5601:
5602: EXCEPTION
5603: WHEN OKC_API.G_EXCEPTION_ERROR THEN
5604: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
5605: p_api_name => l_api_name,
5606: p_pkg_name => G_PKG_NAME,
5607: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
5608: x_msg_count => x_msg_count,

Line 5607: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

5603: WHEN OKC_API.G_EXCEPTION_ERROR THEN
5604: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
5605: p_api_name => l_api_name,
5606: p_pkg_name => G_PKG_NAME,
5607: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
5608: x_msg_count => x_msg_count,
5609: x_msg_data => x_msg_data,
5610: p_api_type => G_API_TYPE);
5611:

Line 5612: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

5608: x_msg_count => x_msg_count,
5609: x_msg_data => x_msg_data,
5610: p_api_type => G_API_TYPE);
5611:
5612: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5613: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
5614: p_api_name => l_api_name,
5615: p_pkg_name => G_PKG_NAME,
5616: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 5613: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

5609: x_msg_data => x_msg_data,
5610: p_api_type => G_API_TYPE);
5611:
5612: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5613: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
5614: p_api_name => l_api_name,
5615: p_pkg_name => G_PKG_NAME,
5616: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
5617: x_msg_count => x_msg_count,

Line 5616: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

5612: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5613: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
5614: p_api_name => l_api_name,
5615: p_pkg_name => G_PKG_NAME,
5616: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
5617: x_msg_count => x_msg_count,
5618: x_msg_data => x_msg_data,
5619: p_api_type => G_API_TYPE);
5620:

Line 5622: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

5618: x_msg_data => x_msg_data,
5619: p_api_type => G_API_TYPE);
5620:
5621: WHEN OTHERS THEN
5622: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
5623: p_api_name => l_api_name,
5624: p_pkg_name => G_PKG_NAME,
5625: p_exc_name => 'OTHERS',
5626: x_msg_count => x_msg_count,

Line 5642: p_init_msg_list IN VARCHAR2, -- DEFAULT OKC_API.G_FALSE,

5638: -- Called By:
5639: ------------------------------------------------------------------------------
5640: PROCEDURE create_txn_contract(
5641: p_api_version IN NUMBER,
5642: p_init_msg_list IN VARCHAR2, -- DEFAULT OKC_API.G_FALSE,
5643: x_return_status OUT NOCOPY VARCHAR2,
5644: x_msg_count OUT NOCOPY NUMBER,
5645: x_msg_data OUT NOCOPY VARCHAR2,
5646: p_from_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

Line 5704: x_return_status := OKC_API.G_RET_STS_SUCCESS;

5700:
5701:
5702: BEGIN -- main process begins here
5703:
5704: x_return_status := OKC_API.G_RET_STS_SUCCESS;
5705: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
5706: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
5707: END IF;
5708: -- call START_ACTIVITY to create savepoint, check compatibility

Line 5710: x_return_status := OKC_API.START_ACTIVITY(

5706: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
5707: END IF;
5708: -- call START_ACTIVITY to create savepoint, check compatibility
5709: -- and initialize message list
5710: x_return_status := OKC_API.START_ACTIVITY(
5711: p_api_name => l_api_name,
5712: p_pkg_name => G_PKG_NAME,
5713: p_init_msg_list => p_init_msg_list,
5714: l_api_version => l_api_version,

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

5716: p_api_type => G_API_TYPE,
5717: x_return_status => x_return_status);
5718:
5719: -- check if activity started successfully
5720: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5721: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5722: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5723: RAISE OKC_API.G_EXCEPTION_ERROR;
5724: END IF;

Line 5721: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5717: x_return_status => x_return_status);
5718:
5719: -- check if activity started successfully
5720: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5721: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5722: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5723: RAISE OKC_API.G_EXCEPTION_ERROR;
5724: END IF;
5725:

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

5718:
5719: -- check if activity started successfully
5720: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5721: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5722: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5723: RAISE OKC_API.G_EXCEPTION_ERROR;
5724: END IF;
5725:
5726: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Line 5723: RAISE OKC_API.G_EXCEPTION_ERROR;

5719: -- check if activity started successfully
5720: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5721: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5722: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5723: RAISE OKC_API.G_EXCEPTION_ERROR;
5724: END IF;
5725:
5726: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
5727: -- Create Rebook Contract

Line 5740: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

5736: x_rebook_chr_id => x_rebook_chr_id,
5737: p_rbk_date => p_trx_date
5738: );
5739:
5740: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5741: RAISE OKC_API.G_EXCEPTION_ERROR;
5742: END IF;
5743:
5744: -- Create Transaction for the rebook-ed contract

Line 5741: RAISE OKC_API.G_EXCEPTION_ERROR;

5737: p_rbk_date => p_trx_date
5738: );
5739:
5740: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5741: RAISE OKC_API.G_EXCEPTION_ERROR;
5742: END IF;
5743:
5744: -- Create Transaction for the rebook-ed contract
5745: okl_transaction_pvt.create_transaction(

Line 5760: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

5756: p_trx_type => 'REBOOK',
5757: x_tcnv_rec => x_tcnv_rec
5758: );
5759:
5760: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5761: RAISE OKC_API.G_EXCEPTION_ERROR;
5762: END IF;
5763:
5764: /*

Line 5761: RAISE OKC_API.G_EXCEPTION_ERROR;

5757: x_tcnv_rec => x_tcnv_rec
5758: );
5759:
5760: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5761: RAISE OKC_API.G_EXCEPTION_ERROR;
5762: END IF;
5763:
5764: /*
5765: -- mvasudev, 08/23/2004

Line 5787: WHEN OKC_API.G_EXCEPTION_ERROR THEN

5783: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
5784: x_msg_data => x_msg_data);
5785:
5786: EXCEPTION
5787: WHEN OKC_API.G_EXCEPTION_ERROR THEN
5788: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
5789: p_api_name => l_api_name,
5790: p_pkg_name => G_PKG_NAME,
5791: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 5788: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

5784: x_msg_data => x_msg_data);
5785:
5786: EXCEPTION
5787: WHEN OKC_API.G_EXCEPTION_ERROR THEN
5788: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
5789: p_api_name => l_api_name,
5790: p_pkg_name => G_PKG_NAME,
5791: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
5792: x_msg_count => x_msg_count,

Line 5791: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

5787: WHEN OKC_API.G_EXCEPTION_ERROR THEN
5788: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
5789: p_api_name => l_api_name,
5790: p_pkg_name => G_PKG_NAME,
5791: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
5792: x_msg_count => x_msg_count,
5793: x_msg_data => x_msg_data,
5794: p_api_type => G_API_TYPE);
5795:

Line 5796: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

5792: x_msg_count => x_msg_count,
5793: x_msg_data => x_msg_data,
5794: p_api_type => G_API_TYPE);
5795:
5796: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5797: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
5798: p_api_name => l_api_name,
5799: p_pkg_name => G_PKG_NAME,
5800: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 5797: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

5793: x_msg_data => x_msg_data,
5794: p_api_type => G_API_TYPE);
5795:
5796: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5797: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
5798: p_api_name => l_api_name,
5799: p_pkg_name => G_PKG_NAME,
5800: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
5801: x_msg_count => x_msg_count,

Line 5800: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

5796: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5797: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
5798: p_api_name => l_api_name,
5799: p_pkg_name => G_PKG_NAME,
5800: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
5801: x_msg_count => x_msg_count,
5802: x_msg_data => x_msg_data,
5803: p_api_type => G_API_TYPE);
5804:

Line 5806: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

5802: x_msg_data => x_msg_data,
5803: p_api_type => G_API_TYPE);
5804:
5805: WHEN OTHERS THEN
5806: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
5807: p_api_name => l_api_name,
5808: p_pkg_name => G_PKG_NAME,
5809: p_exc_name => 'OTHERS',
5810: x_msg_count => x_msg_count,

Line 5895: x_return_status := OKC_API.G_RET_STS_SUCCESS;

5891: IF (G_DEBUG_ENABLED = 'Y') THEN
5892: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
5893: END IF;
5894:
5895: x_return_status := OKC_API.G_RET_STS_SUCCESS;
5896: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
5897: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
5898: END IF;
5899:

Line 5910: p_init_msg_list => OKC_API.G_FALSE,

5906: END LOOP;
5907:
5908: okl_securitization_pvt.check_khr_securitized(
5909: p_api_version => 1.0,
5910: p_init_msg_list => OKC_API.G_FALSE,
5911: x_return_status => x_return_status,
5912: x_msg_count => x_msg_count,
5913: x_msg_data => x_msg_data,
5914: p_khr_id => p_orig_chr_id,

Line 5948: p_init_msg_list => OKC_API.G_FALSE,

5944:
5945: IF (l_disb_strm_tbl.COUNT > 0) THEN
5946: okl_streams_pub.update_streams(
5947: p_api_version => 1.0,
5948: p_init_msg_list => OKC_API.G_FALSE,
5949: x_return_status => x_return_status,
5950: x_msg_count => x_msg_count,
5951: x_msg_data => x_msg_data,
5952: p_stmv_tbl => l_disb_strm_tbl,

Line 5956: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

5952: p_stmv_tbl => l_disb_strm_tbl,
5953: x_stmv_tbl => x_disb_strm_tbl
5954: );
5955:
5956: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5957: RAISE secu_failed;
5958: END IF;
5959: END IF;
5960:

Line 5969: p_init_msg_list => OKC_API.G_FALSE,

5965: -- Create Pool transaction after rebook
5966: --
5967: okl_securitization_pvt.modify_pool_contents(
5968: p_api_version => 1.0,
5969: p_init_msg_list => OKC_API.G_FALSE,
5970: x_return_status => x_return_status,
5971: x_msg_count => x_msg_count,
5972: x_msg_data => x_msg_data,
5973: p_transaction_reason => OKL_SECURITIZATION_PVT.G_TRX_REASON_CONTRACT_REBOOK,

Line 5979: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

5975: p_transaction_date => l_rebook_date,
5976: p_effective_date => l_rebook_date
5977: );
5978:
5979: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5980: RAISE secu_failed;
5981: END IF;
5982: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
5983: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After Modify pool contents');

Line 6005: p_init_msg_list => OKC_API.G_FALSE,

6001:
6002: IF (l_accu_strm_tbl.COUNT > 0) THEN
6003: okl_streams_pub.update_streams(
6004: p_api_version => 1.0,
6005: p_init_msg_list => OKC_API.G_FALSE,
6006: x_return_status => x_return_status,
6007: x_msg_count => x_msg_count,
6008: x_msg_data => x_msg_data,
6009: p_stmv_tbl => l_accu_strm_tbl,

Line 6013: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

6009: p_stmv_tbl => l_accu_strm_tbl,
6010: x_stmv_tbl => x_accu_strm_tbl
6011: );
6012:
6013: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
6014: RAISE secu_failed;
6015: END IF;
6016: END IF;
6017:

Line 6027: p_init_msg_list => OKC_API.G_FALSE,

6023: -- Regenerate disbursement streams
6024: --
6025: okl_stream_generator_pvt.create_disb_streams(
6026: p_api_version => 1.0,
6027: p_init_msg_list => OKC_API.G_FALSE,
6028: x_return_status => x_return_status,
6029: x_msg_count => x_msg_count,
6030: x_msg_data => x_msg_data,
6031: p_contract_id => p_orig_chr_id

Line 6034: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

6030: x_msg_data => x_msg_data,
6031: p_contract_id => p_orig_chr_id
6032: );
6033:
6034: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
6035: RAISE secu_failed;
6036: END IF;
6037: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
6038: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After regerating disb. streams');

Line 6047: p_init_msg_list => OKC_API.G_FALSE,

6043: -- Regenerate Present Value Disbursement streams
6044: --
6045: okl_stream_generator_pvt.create_pv_streams(
6046: p_api_version => 1.0,
6047: p_init_msg_list => OKC_API.G_FALSE,
6048: x_return_status => x_return_status,
6049: x_msg_count => x_msg_count,
6050: x_msg_data => x_msg_data,
6051: p_contract_id => p_orig_chr_id

Line 6054: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

6050: x_msg_data => x_msg_data,
6051: p_contract_id => p_orig_chr_id
6052: );
6053:
6054: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
6055: RAISE secu_failed;
6056: END IF;
6057: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
6058: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After regerating Present Value Disbursement streams');

Line 6073: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

6069: x_msg_data => x_msg_data,
6070: p_khr_id => p_orig_chr_id
6071: );
6072:
6073: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
6074: RAISE secu_failed;
6075: END IF;
6076: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
6077: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After regerating Investor accrual streams');

Line 6087: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

6083: WHEN secu_failed THEN
6084: NULL; -- excception is handled by caller
6085:
6086: WHEN OTHERS THEN
6087: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
6088: p_api_name => l_api_name,
6089: p_pkg_name => G_PKG_NAME,
6090: p_exc_name => 'OTHERS',
6091: x_msg_count => x_msg_count,

Line 6108: p_init_msg_list IN VARCHAR2, -- DEFAULT OKC_API.G_FALSE,

6104: ------------------------------------------------------------------------------
6105:
6106: PROCEDURE sync_rebook_stream(
6107: p_api_version IN NUMBER,
6108: p_init_msg_list IN VARCHAR2, -- DEFAULT OKC_API.G_FALSE,
6109: x_return_status OUT NOCOPY VARCHAR2,
6110: x_msg_count OUT NOCOPY NUMBER,
6111: x_msg_data OUT NOCOPY VARCHAR2,
6112: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

Line 6153: x_return_status := OKC_API.G_RET_STS_SUCCESS;

6149: IF (G_DEBUG_ENABLED = 'Y') THEN
6150: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
6151: END IF;
6152:
6153: x_return_status := OKC_API.G_RET_STS_SUCCESS;
6154: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
6155: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
6156: END IF;
6157: -- call START_ACTIVITY to create savepoint, check compatibility

Line 6159: x_return_status := OKC_API.START_ACTIVITY(

6155: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
6156: END IF;
6157: -- call START_ACTIVITY to create savepoint, check compatibility
6158: -- and initialize message list
6159: x_return_status := OKC_API.START_ACTIVITY(
6160: p_api_name => l_api_name,
6161: p_pkg_name => G_PKG_NAME,
6162: p_init_msg_list => p_init_msg_list,
6163: l_api_version => l_api_version,

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

6165: p_api_type => G_API_TYPE,
6166: x_return_status => x_return_status);
6167:
6168: -- check if activity started successfully
6169: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6170: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6171: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6172: RAISE OKC_API.G_EXCEPTION_ERROR;
6173: END IF;

Line 6170: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

6166: x_return_status => x_return_status);
6167:
6168: -- check if activity started successfully
6169: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6170: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6171: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6172: RAISE OKC_API.G_EXCEPTION_ERROR;
6173: END IF;
6174: --**********************************************************

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

6167:
6168: -- check if activity started successfully
6169: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6170: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6171: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6172: RAISE OKC_API.G_EXCEPTION_ERROR;
6173: END IF;
6174: --**********************************************************
6175:

Line 6172: RAISE OKC_API.G_EXCEPTION_ERROR;

6168: -- check if activity started successfully
6169: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6170: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6171: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6172: RAISE OKC_API.G_EXCEPTION_ERROR;
6173: END IF;
6174: --**********************************************************
6175:
6176: get_orig_chr_id(

Line 6181: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

6177: x_return_status => x_return_status,
6178: p_chr_id => p_chr_id,
6179: x_orig_chr_id => l_orig_chr_id
6180: );
6181: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
6182: okl_api.set_message(
6183: G_APP_NAME,
6184: G_LLA_NO_ORIG_REFERENCE
6185: );

Line 6186: RAISE OKC_API.G_EXCEPTION_ERROR;

6182: okl_api.set_message(
6183: G_APP_NAME,
6184: G_LLA_NO_ORIG_REFERENCE
6185: );
6186: RAISE OKC_API.G_EXCEPTION_ERROR;
6187: END IF;
6188:
6189: /*
6190: * Bug# , 03/12/2003

Line 6206: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

6202: p_status => 'HIST',
6203: p_active_yn => 'N'
6204: );
6205:
6206: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
6207: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6208: END IF;
6209:
6210: debug_message('Change Status: '||x_return_status);

Line 6207: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

6203: p_active_yn => 'N'
6204: );
6205:
6206: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
6207: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6208: END IF;
6209:
6210: debug_message('Change Status: '||x_return_status);
6211: */

Line 6222: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

6218: p_orig_chr_id => l_orig_chr_id,
6219: p_rebook_chr_id => p_chr_id
6220: );
6221:
6222: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
6223: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6224: END IF;
6225:
6226: -- Change status of Rebooked Stream to 'HIST'

Line 6223: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

6219: p_rebook_chr_id => p_chr_id
6220: );
6221:
6222: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
6223: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6224: END IF;
6225:
6226: -- Change status of Rebooked Stream to 'HIST'
6227: change_stream_status(

Line 6236: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

6232: p_status => 'HIST',
6233: p_active_yn => 'N'
6234: );
6235:
6236: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
6237: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6238: END IF;
6239:
6240: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 6237: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

6233: p_active_yn => 'N'
6234: );
6235:
6236: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
6237: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6238: END IF;
6239:
6240: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
6241: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Change Status 2: '||x_return_status);

Line 6255: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

6251: p_orig_chr_id => l_orig_chr_id,
6252: p_rebook_chr_id => p_chr_id
6253: );
6254:
6255: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
6256: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6257: END IF;
6258:
6259: -- Bug# 4775555: Start

Line 6256: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

6252: p_rebook_chr_id => p_chr_id
6253: );
6254:
6255: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
6256: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6257: END IF;
6258:
6259: -- Bug# 4775555: Start
6260: --

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

6274: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
6275: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After call create_inv_disb_adjustment'||x_return_status);
6276: END IF;
6277:
6278: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6279: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6280: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6281: RAISE OKC_API.G_EXCEPTION_ERROR;
6282: END IF;

Line 6279: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

6275: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After call create_inv_disb_adjustment'||x_return_status);
6276: END IF;
6277:
6278: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6279: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6280: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6281: RAISE OKC_API.G_EXCEPTION_ERROR;
6282: END IF;
6283:

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

6276: END IF;
6277:
6278: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6279: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6280: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6281: RAISE OKC_API.G_EXCEPTION_ERROR;
6282: END IF;
6283:
6284: --get rebook transaction

Line 6281: RAISE OKC_API.G_EXCEPTION_ERROR;

6277:
6278: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6279: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6280: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6281: RAISE OKC_API.G_EXCEPTION_ERROR;
6282: END IF;
6283:
6284: --get rebook transaction
6285: OPEN l_rbk_trx_csr (p_chr_id => p_chr_id);

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

6308: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
6309: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After call calc_inv_acc_adjustment'||x_return_status);
6310: END IF;
6311:
6312: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6313: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6314: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6315: RAISE OKC_API.G_EXCEPTION_ERROR;
6316: END IF;

Line 6313: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

6309: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After call calc_inv_acc_adjustment'||x_return_status);
6310: END IF;
6311:
6312: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6313: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6314: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6315: RAISE OKC_API.G_EXCEPTION_ERROR;
6316: END IF;
6317:

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

6310: END IF;
6311:
6312: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6313: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6314: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6315: RAISE OKC_API.G_EXCEPTION_ERROR;
6316: END IF;
6317:
6318: IF (l_inv_stream_tbl.COUNT > 0) THEN

Line 6315: RAISE OKC_API.G_EXCEPTION_ERROR;

6311:
6312: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6313: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6314: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6315: RAISE OKC_API.G_EXCEPTION_ERROR;
6316: END IF;
6317:
6318: IF (l_inv_stream_tbl.COUNT > 0) THEN
6319: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

6366: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
6367: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After call calc_inv_acc_adjustment'||x_return_status);
6368: END IF;
6369:
6370: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6371: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6372: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6373: RAISE OKC_API.G_EXCEPTION_ERROR;
6374: END IF;

Line 6371: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

6367: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After call calc_inv_acc_adjustment'||x_return_status);
6368: END IF;
6369:
6370: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6371: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6372: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6373: RAISE OKC_API.G_EXCEPTION_ERROR;
6374: END IF;
6375:

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

6368: END IF;
6369:
6370: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6371: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6372: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6373: RAISE OKC_API.G_EXCEPTION_ERROR;
6374: END IF;
6375:
6376: IF (l_inv_stream_tbl.COUNT > 0) THEN

Line 6373: RAISE OKC_API.G_EXCEPTION_ERROR;

6369:
6370: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6371: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6372: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6373: RAISE OKC_API.G_EXCEPTION_ERROR;
6374: END IF;
6375:
6376: IF (l_inv_stream_tbl.COUNT > 0) THEN
6377: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 6412: WHEN OKC_API.G_EXCEPTION_ERROR THEN

6408: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
6409: x_msg_data => x_msg_data);
6410:
6411: EXCEPTION
6412: WHEN OKC_API.G_EXCEPTION_ERROR THEN
6413: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
6414: p_api_name => l_api_name,
6415: p_pkg_name => G_PKG_NAME,
6416: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 6413: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

6409: x_msg_data => x_msg_data);
6410:
6411: EXCEPTION
6412: WHEN OKC_API.G_EXCEPTION_ERROR THEN
6413: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
6414: p_api_name => l_api_name,
6415: p_pkg_name => G_PKG_NAME,
6416: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
6417: x_msg_count => x_msg_count,

Line 6416: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

6412: WHEN OKC_API.G_EXCEPTION_ERROR THEN
6413: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
6414: p_api_name => l_api_name,
6415: p_pkg_name => G_PKG_NAME,
6416: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
6417: x_msg_count => x_msg_count,
6418: x_msg_data => x_msg_data,
6419: p_api_type => G_API_TYPE);
6420:

Line 6421: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

6417: x_msg_count => x_msg_count,
6418: x_msg_data => x_msg_data,
6419: p_api_type => G_API_TYPE);
6420:
6421: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
6422: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
6423: p_api_name => l_api_name,
6424: p_pkg_name => G_PKG_NAME,
6425: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 6422: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

6418: x_msg_data => x_msg_data,
6419: p_api_type => G_API_TYPE);
6420:
6421: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
6422: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
6423: p_api_name => l_api_name,
6424: p_pkg_name => G_PKG_NAME,
6425: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
6426: x_msg_count => x_msg_count,

Line 6425: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

6421: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
6422: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
6423: p_api_name => l_api_name,
6424: p_pkg_name => G_PKG_NAME,
6425: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
6426: x_msg_count => x_msg_count,
6427: x_msg_data => x_msg_data,
6428: p_api_type => G_API_TYPE);
6429:

Line 6431: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

6427: x_msg_data => x_msg_data,
6428: p_api_type => G_API_TYPE);
6429:
6430: WHEN OTHERS THEN
6431: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
6432: p_api_name => l_api_name,
6433: p_pkg_name => G_PKG_NAME,
6434: p_exc_name => 'OTHERS',
6435: x_msg_count => x_msg_count,

Line 6454: p_init_msg_list IN VARCHAR2, -- DEFAULT OKC_API.G_FALSE,

6450: ------------------------------------------------------------------------------
6451:
6452: PROCEDURE create_rebook_contract(
6453: p_api_version IN NUMBER,
6454: p_init_msg_list IN VARCHAR2, -- DEFAULT OKC_API.G_FALSE,
6455: x_return_status OUT NOCOPY VARCHAR2,
6456: x_msg_count OUT NOCOPY NUMBER,
6457: x_msg_data OUT NOCOPY VARCHAR2,
6458: p_from_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

Line 6505: x_return_status := OKC_API.G_RET_STS_SUCCESS;

6501: IF (G_DEBUG_ENABLED = 'Y') THEN
6502: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
6503: END IF;
6504:
6505: x_return_status := OKC_API.G_RET_STS_SUCCESS;
6506: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
6507: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
6508: END IF;
6509: -- call START_ACTIVITY to create savepoint, check compatibility

Line 6511: x_return_status := OKC_API.START_ACTIVITY(

6507: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
6508: END IF;
6509: -- call START_ACTIVITY to create savepoint, check compatibility
6510: -- and initialize message list
6511: x_return_status := OKC_API.START_ACTIVITY(
6512: p_api_name => l_api_name,
6513: p_pkg_name => G_PKG_NAME,
6514: p_init_msg_list => p_init_msg_list,
6515: l_api_version => l_api_version,

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

6517: p_api_type => G_API_TYPE,
6518: x_return_status => x_return_status);
6519:
6520: -- check if activity started successfully
6521: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6522: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6523: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6524: RAISE OKC_API.G_EXCEPTION_ERROR;
6525: END IF;

Line 6522: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

6518: x_return_status => x_return_status);
6519:
6520: -- check if activity started successfully
6521: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6522: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6523: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6524: RAISE OKC_API.G_EXCEPTION_ERROR;
6525: END IF;
6526: --**********************************************************

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

6519:
6520: -- check if activity started successfully
6521: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6522: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6523: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6524: RAISE OKC_API.G_EXCEPTION_ERROR;
6525: END IF;
6526: --**********************************************************
6527: -- Get Sequence Number to generate Contract Number

Line 6524: RAISE OKC_API.G_EXCEPTION_ERROR;

6520: -- check if activity started successfully
6521: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6522: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6523: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6524: RAISE OKC_API.G_EXCEPTION_ERROR;
6525: END IF;
6526: --**********************************************************
6527: -- Get Sequence Number to generate Contract Number
6528: SELECT okl_rbk_seq.NEXTVAL

Line 6541: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

6537: okl_api.set_message(
6538: G_APP_NAME,
6539: G_LLA_CHR_ID
6540: );
6541: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6542: --start:| 24-Mar-08 cklee Bug# 6801137 -- Added validation logic |
6543: ELSE
6544: IF l_orig_sts_code <> 'BOOKED' THEN
6545: okl_api.set_message(

Line 6549: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

6545: okl_api.set_message(
6546: G_APP_NAME,
6547: 'OKL_LLA_REV_ONLY_BOOKED'
6548: );
6549: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6550: END IF;
6551: --end:| 24-Mar-08 cklee Bug# 6801137 -- Added validation logic |
6552:
6553: END IF;

Line 6563: p_init_msg_list => OKC_API.G_FALSE,

6559: -- Copy Contract to Create Rebook Contract
6560: --
6561: okl_copy_contract_pub.copy_lease_contract_new(
6562: p_api_version => 1.0,
6563: p_init_msg_list => OKC_API.G_FALSE,
6564: x_return_status => x_return_status,
6565: x_msg_count => x_msg_count,
6566: x_msg_data => x_msg_data,
6567: p_chr_id => p_from_chr_id,

Line 6576: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

6572: x_chr_id => x_chr_id,
6573: p_rbk_date => p_rbk_date
6574: );
6575:
6576: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
6577: RAISE OKC_API.G_EXCEPTION_ERROR;
6578: END IF;
6579:
6580:

Line 6577: RAISE OKC_API.G_EXCEPTION_ERROR;

6573: p_rbk_date => p_rbk_date
6574: );
6575:
6576: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
6577: RAISE OKC_API.G_EXCEPTION_ERROR;
6578: END IF;
6579:
6580:
6581: /*

Line 6584: p_init_msg_list => OKC_API.G_FALSE,

6580:
6581: /*
6582: okl_copy_contract_pub.copy_contract(
6583: p_api_version => 1.0,
6584: p_init_msg_list => OKC_API.G_FALSE,
6585: x_return_status => x_return_status,
6586: x_msg_count => x_msg_count,
6587: x_msg_data => x_msg_data,
6588: p_commit => OKC_API.G_FALSE,

Line 6588: p_commit => OKC_API.G_FALSE,

6584: p_init_msg_list => OKC_API.G_FALSE,
6585: x_return_status => x_return_status,
6586: x_msg_count => x_msg_count,
6587: x_msg_data => x_msg_data,
6588: p_commit => OKC_API.G_FALSE,
6589: p_chr_id => p_from_chr_id,
6590: p_contract_number => l_new_contract_number,
6591: p_contract_number_modifier => NULL,
6592: p_to_template_yn => 'N',

Line 6599: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

6595: p_override_org => 'N',
6596: x_chr_id => x_chr_id
6597: );
6598:
6599: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
6600: RAISE OKC_API.G_EXCEPTION_ERROR;
6601: END IF;
6602:
6603: debug_message('New Chr ID: '||x_chr_id);

Line 6600: RAISE OKC_API.G_EXCEPTION_ERROR;

6596: x_chr_id => x_chr_id
6597: );
6598:
6599: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
6600: RAISE OKC_API.G_EXCEPTION_ERROR;
6601: END IF;
6602:
6603: debug_message('New Chr ID: '||x_chr_id);
6604:

Line 6615: p_init_msg_list => OKC_API.G_FALSE,

6611: END LOOP;
6612:
6613: okl_copy_asset_pub.copy_all_lines(
6614: p_api_version => 1.0,
6615: p_init_msg_list => OKC_API.G_FALSE,
6616: x_return_status => x_return_status,
6617: x_msg_count => x_msg_count,
6618: x_msg_data => x_msg_data,
6619: P_from_cle_id_tbl => l_from_cle_id_tbl,

Line 6628: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

6624: p_renew_ref_yn => 'N',
6625: p_trans_type => 'CRB',
6626: x_cle_id_tbl => x_cle_id_tbl
6627: );
6628: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
6629: RAISE OKC_API.G_EXCEPTION_ERROR;
6630: END IF;
6631:
6632: */

Line 6629: RAISE OKC_API.G_EXCEPTION_ERROR;

6625: p_trans_type => 'CRB',
6626: x_cle_id_tbl => x_cle_id_tbl
6627: );
6628: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
6629: RAISE OKC_API.G_EXCEPTION_ERROR;
6630: END IF;
6631:
6632: */
6633: --

Line 6644: p_init_msg_list => OKC_API.G_FALSE,

6640: l_chrv_rec.orig_system_source_code := 'OKL_REBOOK';
6641:
6642: Okl_Okc_Migration_Pvt.update_contract_header(
6643: p_api_version => 1.0,
6644: p_init_msg_list => OKC_API.G_FALSE,
6645: x_return_status => x_return_status,
6646: x_msg_count => x_msg_count,
6647: x_msg_data => x_msg_data,
6648: p_restricted_update => OKC_API.G_FALSE,

Line 6648: p_restricted_update => OKC_API.G_FALSE,

6644: p_init_msg_list => OKC_API.G_FALSE,
6645: x_return_status => x_return_status,
6646: x_msg_count => x_msg_count,
6647: x_msg_data => x_msg_data,
6648: p_restricted_update => OKC_API.G_FALSE,
6649: p_chrv_rec => l_chrv_rec,
6650: x_chrv_rec => x_chrv_rec
6651: );
6652: /* dedey - 27-AUG-2002

Line 6663: p_restricted_update => OKC_API.G_FALSE,

6659: p_init_msg_list => p_init_msg_list,
6660: x_return_status => x_return_status,
6661: x_msg_count => x_msg_count,
6662: x_msg_data => x_msg_data,
6663: p_restricted_update => OKC_API.G_FALSE,
6664: p_chrv_rec => l_chrv_rec,
6665: p_khrv_rec => l_khrv_rec,
6666: x_chrv_rec => x_chrv_rec,
6667: x_khrv_rec => x_khrv_rec

Line 6671: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

6667: x_khrv_rec => x_khrv_rec
6668: );
6669: */
6670:
6671: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
6672: RAISE OKC_API.G_EXCEPTION_ERROR;
6673: END IF;
6674:
6675: x_rebook_chr_id := x_chr_id;

Line 6672: RAISE OKC_API.G_EXCEPTION_ERROR;

6668: );
6669: */
6670:
6671: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
6672: RAISE OKC_API.G_EXCEPTION_ERROR;
6673: END IF;
6674:
6675: x_rebook_chr_id := x_chr_id;
6676:

Line 6682: WHEN OKC_API.G_EXCEPTION_ERROR THEN

6678: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
6679: x_msg_data => x_msg_data);
6680:
6681: EXCEPTION
6682: WHEN OKC_API.G_EXCEPTION_ERROR THEN
6683: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
6684: p_api_name => l_api_name,
6685: p_pkg_name => G_PKG_NAME,
6686: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 6683: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

6679: x_msg_data => x_msg_data);
6680:
6681: EXCEPTION
6682: WHEN OKC_API.G_EXCEPTION_ERROR THEN
6683: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
6684: p_api_name => l_api_name,
6685: p_pkg_name => G_PKG_NAME,
6686: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
6687: x_msg_count => x_msg_count,

Line 6686: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

6682: WHEN OKC_API.G_EXCEPTION_ERROR THEN
6683: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
6684: p_api_name => l_api_name,
6685: p_pkg_name => G_PKG_NAME,
6686: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
6687: x_msg_count => x_msg_count,
6688: x_msg_data => x_msg_data,
6689: p_api_type => G_API_TYPE);
6690:

Line 6691: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

6687: x_msg_count => x_msg_count,
6688: x_msg_data => x_msg_data,
6689: p_api_type => G_API_TYPE);
6690:
6691: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
6692: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
6693: p_api_name => l_api_name,
6694: p_pkg_name => G_PKG_NAME,
6695: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 6692: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

6688: x_msg_data => x_msg_data,
6689: p_api_type => G_API_TYPE);
6690:
6691: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
6692: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
6693: p_api_name => l_api_name,
6694: p_pkg_name => G_PKG_NAME,
6695: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
6696: x_msg_count => x_msg_count,

Line 6695: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

6691: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
6692: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
6693: p_api_name => l_api_name,
6694: p_pkg_name => G_PKG_NAME,
6695: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
6696: x_msg_count => x_msg_count,
6697: x_msg_data => x_msg_data,
6698: p_api_type => G_API_TYPE);
6699:

Line 6701: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

6697: x_msg_data => x_msg_data,
6698: p_api_type => G_API_TYPE);
6699:
6700: WHEN OTHERS THEN
6701: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
6702: p_api_name => l_api_name,
6703: p_pkg_name => G_PKG_NAME,
6704: p_exc_name => 'OTHERS',
6705: x_msg_count => x_msg_count,

Line 6724: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

6720: -- Called By:
6721: ------------------------------------------------------------------------------
6722: PROCEDURE link_streams(
6723: p_api_version IN NUMBER,
6724: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
6725: x_return_status OUT NOCOPY VARCHAR2,
6726: x_msg_count OUT NOCOPY NUMBER,
6727: x_msg_data OUT NOCOPY VARCHAR2,
6728: p_khr_id IN NUMBER

Line 7037: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

7033: -- Called By:
7034: ------------------------------------------------------------------------------
7035: PROCEDURE create_pth_disb_adjustment(
7036: p_api_version IN NUMBER,
7037: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
7038: x_return_status OUT NOCOPY VARCHAR2,
7039: x_msg_count OUT NOCOPY NUMBER,
7040: x_msg_data OUT NOCOPY VARCHAR2,
7041: p_rbk_khr_id IN NUMBER,

Line 7394: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

7390: -- Called By:
7391: ------------------------------------------------------------------------------
7392: PROCEDURE create_billing_adjustment(
7393: p_api_version IN NUMBER,
7394: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
7395: x_return_status OUT NOCOPY VARCHAR2,
7396: x_msg_count OUT NOCOPY NUMBER,
7397: x_msg_data OUT NOCOPY VARCHAR2,
7398: p_rbk_khr_id IN NUMBER,

Line 7785: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

7781: -- Called By:
7782: ------------------------------------------------------------------------------
7783: PROCEDURE create_accrual_adjustment(
7784: p_api_version IN NUMBER,
7785: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
7786: x_return_status OUT NOCOPY VARCHAR2,
7787: x_msg_count OUT NOCOPY NUMBER,
7788: x_msg_data OUT NOCOPY VARCHAR2,
7789: p_rbk_khr_id IN NUMBER,

Line 8130: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

8126: -- Added new input parameters p_trx_tbl_code and p_trx_type for Bug# 6344223
8127: ------------------------------------------------------------------------------
8128: PROCEDURE calc_accrual_adjustment(
8129: p_api_version IN NUMBER,
8130: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
8131: x_return_status OUT NOCOPY VARCHAR2,
8132: x_msg_count OUT NOCOPY NUMBER,
8133: x_msg_data OUT NOCOPY VARCHAR2,
8134: p_rbk_khr_id IN NUMBER,

Line 8542: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

8538: -- Called By:
8539: ------------------------------------------------------------------------------
8540: PROCEDURE create_inv_disb_adjustment(
8541: p_api_version IN NUMBER,
8542: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
8543: x_return_status OUT NOCOPY VARCHAR2,
8544: x_msg_count OUT NOCOPY NUMBER,
8545: x_msg_data OUT NOCOPY VARCHAR2,
8546: p_orig_khr_id IN NUMBER

Line 9018: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

9014: -- Called By:
9015: ------------------------------------------------------------------------------
9016: PROCEDURE link_inv_accrual_streams(
9017: p_api_version IN NUMBER,
9018: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
9019: x_return_status OUT NOCOPY VARCHAR2,
9020: x_msg_count OUT NOCOPY NUMBER,
9021: x_msg_data OUT NOCOPY VARCHAR2,
9022: p_khr_id IN NUMBER

Line 9278: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

9274: -- Added new input parameters p_trx_tbl_code and p_trx_type for Bug# 6344223
9275: ------------------------------------------------------------------------------
9276: PROCEDURE calc_inv_acc_adjustment(
9277: p_api_version IN NUMBER,
9278: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
9279: x_return_status OUT NOCOPY VARCHAR2,
9280: x_msg_count OUT NOCOPY NUMBER,
9281: x_msg_data OUT NOCOPY VARCHAR2,
9282: p_orig_khr_id IN NUMBER,