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 505: x_return_status := OKC_API.G_RET_STS_SUCCESS;

501: END IF;
502: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
503: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
504: END IF;
505: x_return_status := OKC_API.G_RET_STS_SUCCESS;
506:
507: OPEN rebook_csr(p_rebook_reason_code);
508: FETCH rebook_csr INTO l_dummy;
509: IF rebook_csr%NOTFOUND THEN

Line 524: x_return_status := OKC_API.G_RET_STS_ERROR;

520: G_INVALID_VALUE,
521: 'COL_NAME',
522: 'REBOOK REASON'
523: );
524: x_return_status := OKC_API.G_RET_STS_ERROR;
525:
526: END validate_rebook_reason;
527:
528: ------------------------------------------------------------------------------

Line 712: x_return_status := OKC_API.G_RET_STS_SUCCESS;

708: BEGIN
709: IF (G_DEBUG_ENABLED = 'Y') THEN
710: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
711: END IF;
712: x_return_status := OKC_API.G_RET_STS_SUCCESS;
713: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
714: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
715: END IF;
716:

Line 841: p_init_msg_list => OKC_API.G_FALSE,

837:
838: IF (l_orig_strm_tbl.COUNT > 0) THEN
839: okl_streams_pub.update_streams(
840: p_api_version => 1.0,
841: p_init_msg_list => OKC_API.G_FALSE,
842: x_return_status => x_return_status,
843: x_msg_count => x_msg_count,
844: x_msg_data => x_msg_data,
845: p_stmv_tbl => l_orig_strm_tbl,

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

849: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
850: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After Update of Deleted Orig strm to HIST '||x_return_status);
851: END IF;
852:
853: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
854: RAISE copy_failed;
855: END IF;
856: END IF;
857:

Line 979: p_init_msg_list => OKC_API.G_FALSE,

975:
976: IF (l_orig_strm_tbl.COUNT > 0) THEN
977: okl_streams_pub.update_streams(
978: p_api_version => 1.0,
979: p_init_msg_list => OKC_API.G_FALSE,
980: x_return_status => x_return_status,
981: x_msg_count => x_msg_count,
982: x_msg_data => x_msg_data,
983: p_stmv_tbl => l_orig_strm_tbl,

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

987: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
988: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After Update of Orig strm to HIST '||x_return_status);
989: END IF;
990:
991: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
992: RAISE copy_failed;
993: END IF;
994: END IF;
995:

Line 1072: p_init_msg_list => OKC_API.G_FALSE,

1068:
1069: -- call API to create new streams
1070: okl_streams_pub.create_streams(
1071: p_api_version => 1.0,
1072: p_init_msg_list => OKC_API.G_FALSE,
1073: x_return_status => x_return_status,
1074: x_msg_count => x_msg_count,
1075: x_msg_data => x_msg_data,
1076: p_stmv_rec => l_stmv_rec,

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

1078: x_stmv_rec => x_stmv_rec,
1079: x_selv_tbl => x_selv_tbl
1080: );
1081:
1082: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1083: RAISE copy_failed;
1084: END IF;
1085:
1086: END LOOP; -- Header stream

Line 1093: x_return_status := OKC_API.G_RET_STS_ERROR;

1089: RETURN;
1090:
1091: EXCEPTION
1092: WHEN copy_failed THEN
1093: x_return_status := OKC_API.G_RET_STS_ERROR;
1094: END copy_rebook_stream;
1095:
1096: ------------------------------------------------------------------------------
1097: -- PROCEDURE get_orig_chr_id

Line 1125: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1121: IF (G_DEBUG_ENABLED = 'Y') THEN
1122: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1123: END IF;
1124:
1125: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1126: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1127: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
1128: END IF;
1129:

Line 1150: x_return_status := OKC_API.G_RET_STS_ERROR;

1146: WHEN orig_failed THEN
1147: IF orig_csr%ISOPEN THEN
1148: CLOSE orig_csr;
1149: END IF;
1150: x_return_status := OKC_API.G_RET_STS_ERROR;
1151:
1152: END get_orig_chr_id;
1153:
1154: ------------------------------------------------------------------------------

Line 1189: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1185: BEGIN
1186: IF (G_DEBUG_ENABLED = 'Y') THEN
1187: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1188: END IF;
1189: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1190:
1191: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1192: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
1193: END IF;

Line 1229: p_init_msg_list => OKC_API.G_FALSE,

1225: END IF;
1226:
1227: okl_streams_pub.update_streams(
1228: p_api_version => 1.0,
1229: p_init_msg_list => OKC_API.G_FALSE,
1230: x_return_status => x_return_status,
1231: x_msg_count => x_msg_count,
1232: x_msg_data => x_msg_data,
1233: p_stmv_rec => l_stmv_rec,

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

1235: );
1236: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1237: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After Update API Call');
1238: END IF;
1239: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1240: RAISE strm_failed;
1241: END IF;
1242:
1243: END LOOP;

Line 1252: x_return_status := OKC_API.G_RET_STS_ERROR;

1248: WHEN strm_failed THEN
1249: IF strm_csr%ISOPEN THEN
1250: CLOSE strm_csr;
1251: END IF;
1252: x_return_status := OKC_API.G_RET_STS_ERROR;
1253: END change_stream_status;
1254:
1255: ------------------------------------------------------------------------------
1256: -- PROCEDURE get_sll_rules

Line 1715: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1711: BEGIN
1712: IF (G_DEBUG_ENABLED = 'Y') THEN
1713: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1714: END IF;
1715: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1716: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1717: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
1718: END IF;
1719:

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

1741: p_rgpv_rec => l_rgpv_rec,
1742: x_rgpv_rec => x_rgpv_rec
1743: );
1744:
1745: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1746: RAISE sync_header_failed;
1747: END IF;
1748:
1749: l_orig_rgp_id := x_rgpv_rec.id;

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

1770: x_msg_data => x_msg_data,
1771: x_rulv_tbl => x_slh_rulv_tbl,
1772: x_rule_count => x_slh_rule_count
1773: );
1774: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1775: RAISE sync_header_failed;
1776: END IF;
1777:
1778: --x_slh_rulv_tbl_out := x_slh_rulv_tbl;

Line 1789: p_init_msg_list => Okc_Api.G_FALSE,

1785: l_slh_rulv_rec.dnz_chr_id := p_orig_chr_id;
1786:
1787: Okl_Rule_Pub.create_rule(
1788: p_api_version => 1.0,
1789: p_init_msg_list => Okc_Api.G_FALSE,
1790: x_return_status => x_return_status,
1791: x_msg_count => x_msg_count,
1792: x_msg_data => x_msg_data,
1793: p_rulv_rec => l_slh_rulv_rec,

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

1792: x_msg_data => x_msg_data,
1793: p_rulv_rec => l_slh_rulv_rec,
1794: x_rulv_rec => x_new_slh_rulv_rec
1795: );
1796: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1797: x_return_status := Okc_Api.G_RET_STS_ERROR;
1798: RAISE sync_header_failed;
1799: END IF;
1800:

Line 1797: x_return_status := Okc_Api.G_RET_STS_ERROR;

1793: p_rulv_rec => l_slh_rulv_rec,
1794: x_rulv_rec => x_new_slh_rulv_rec
1795: );
1796: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1797: x_return_status := Okc_Api.G_RET_STS_ERROR;
1798: RAISE sync_header_failed;
1799: END IF;
1800:
1801: --

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

1810: p_slh_id => x_slh_rulv_tbl(i).id,
1811: x_rulv_tbl => x_sll_rulv_tbl,
1812: x_rule_count => x_sll_rule_count
1813: );
1814: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1815: RAISE sync_header_failed;
1816: END IF;
1817:
1818: --x_sll_rulv_tbl_out := x_sll_rulv_tbl;

Line 1832: p_init_msg_list => Okc_Api.G_FALSE,

1828: l_sll_rulv_rec.dnz_chr_id := p_orig_chr_id;
1829:
1830: Okl_Rule_Pub.create_rule(
1831: p_api_version => 1.0,
1832: p_init_msg_list => Okc_Api.G_FALSE,
1833: x_return_status => x_return_status,
1834: x_msg_count => x_msg_count,
1835: x_msg_data => x_msg_data,
1836: p_rulv_rec => l_sll_rulv_rec,

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

1835: x_msg_data => x_msg_data,
1836: p_rulv_rec => l_sll_rulv_rec,
1837: x_rulv_rec => x_rulv_rec
1838: );
1839: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1840: x_return_status := Okc_Api.G_RET_STS_ERROR;
1841: RAISE sync_header_failed;
1842: END IF;
1843: END LOOP; -- SLL

Line 1840: x_return_status := Okc_Api.G_RET_STS_ERROR;

1836: p_rulv_rec => l_sll_rulv_rec,
1837: x_rulv_rec => x_rulv_rec
1838: );
1839: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1840: x_return_status := Okc_Api.G_RET_STS_ERROR;
1841: RAISE sync_header_failed;
1842: END IF;
1843: END LOOP; -- SLL
1844:

Line 1851: x_return_status := OKC_API.G_RET_STS_ERROR;

1847: END LOOP;
1848:
1849: EXCEPTION
1850: WHEN sync_header_failed THEN
1851: x_return_status := OKC_API.G_RET_STS_ERROR;
1852:
1853: END sync_header_slh_sll;
1854:
1855: ------------------------------------------------------------------------------

Line 1972: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1968: BEGIN
1969: IF (G_DEBUG_ENABLED = 'Y') THEN
1970: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1971: END IF;
1972: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1973: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1974: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
1975: END IF;
1976:

Line 1992: p_init_msg_list => OKC_API.G_FALSE,

1988: END LOOP;
1989:
1990: okl_rule_pub.delete_rule(
1991: p_api_version => 1.0,
1992: p_init_msg_list => OKC_API.G_FALSE,
1993: x_return_status => x_return_status,
1994: x_msg_count => x_msg_count,
1995: x_msg_data => x_msg_data,
1996: p_rulv_tbl => l_rulv_tbl

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

1994: x_msg_count => x_msg_count,
1995: x_msg_data => x_msg_data,
1996: p_rulv_tbl => l_rulv_tbl
1997: );
1998: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1999: RAISE sync_failed;
2000: END IF;
2001: */
2002:

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

2016: p_for_line => 'N',
2017: p_rebook_chr_id => p_rebook_chr_id,
2018: p_orig_chr_id => p_orig_chr_id
2019: );
2020: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2021: RAISE sync_failed;
2022: END IF;
2023: GOTO process_next;
2024:

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

2058: x_msg_data => x_msg_data,
2059: x_rulv_tbl => x_slh_rulv_tbl,
2060: x_rule_count => x_slh_rule_count
2061: );
2062: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2063: RAISE sync_failed;
2064: END IF;
2065:
2066: --x_slh_rulv_tbl_out := x_slh_rulv_tbl;

Line 2080: p_init_msg_list => Okc_Api.G_False,

2076: l_lalevl_rgpv_rec.rgp_type := 'KRG';
2077:
2078: OKL_RULE_PUB.create_rule_group(
2079: p_api_version => 1.0,
2080: p_init_msg_list => Okc_Api.G_False,
2081: x_return_status => x_return_status,
2082: x_msg_count => x_msg_count,
2083: x_msg_data => x_msg_data,
2084: p_rgpv_rec => l_lalevl_rgpv_rec,

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

2083: x_msg_data => x_msg_data,
2084: p_rgpv_rec => l_lalevl_rgpv_rec,
2085: x_rgpv_rec => x_lalevl_rgpv_rec);
2086:
2087: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2088: RAISE sync_failed;
2089: END IF;
2090:
2091: l_orig_rgp_id := x_lalevl_rgpv_rec.id;

Line 2104: p_init_msg_list => Okc_Api.G_FALSE,

2100: l_slh_rulv_rec.dnz_chr_id := p_orig_chr_id;
2101:
2102: Okl_Rule_Pub.create_rule(
2103: p_api_version => 1.0,
2104: p_init_msg_list => Okc_Api.G_FALSE,
2105: x_return_status => x_return_status,
2106: x_msg_count => x_msg_count,
2107: x_msg_data => x_msg_data,
2108: p_rulv_rec => l_slh_rulv_rec,

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

2107: x_msg_data => x_msg_data,
2108: p_rulv_rec => l_slh_rulv_rec,
2109: x_rulv_rec => x_new_slh_rulv_rec
2110: );
2111: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2112: x_return_status := Okc_Api.G_RET_STS_ERROR;
2113: RAISE sync_failed;
2114: END IF;
2115:

Line 2112: x_return_status := Okc_Api.G_RET_STS_ERROR;

2108: p_rulv_rec => l_slh_rulv_rec,
2109: x_rulv_rec => x_new_slh_rulv_rec
2110: );
2111: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2112: x_return_status := Okc_Api.G_RET_STS_ERROR;
2113: RAISE sync_failed;
2114: END IF;
2115:
2116: --

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

2125: p_slh_id => x_slh_rulv_tbl(i).id,
2126: x_rulv_tbl => x_sll_rulv_tbl,
2127: x_rule_count => x_sll_rule_count
2128: );
2129: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2130: RAISE sync_failed;
2131: END IF;
2132:
2133: --x_sll_rulv_tbl_out := x_sll_rulv_tbl;

Line 2147: p_init_msg_list => Okc_Api.G_FALSE,

2143: l_sll_rulv_rec.dnz_chr_id := p_orig_chr_id;
2144:
2145: Okl_Rule_Pub.create_rule(
2146: p_api_version => 1.0,
2147: p_init_msg_list => Okc_Api.G_FALSE,
2148: x_return_status => x_return_status,
2149: x_msg_count => x_msg_count,
2150: x_msg_data => x_msg_data,
2151: p_rulv_rec => l_sll_rulv_rec,

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

2150: x_msg_data => x_msg_data,
2151: p_rulv_rec => l_sll_rulv_rec,
2152: x_rulv_rec => x_rulv_rec
2153: );
2154: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2155: x_return_status := Okc_Api.G_RET_STS_ERROR;
2156: RAISE sync_failed;
2157: END IF;
2158: END LOOP; -- SLL

Line 2155: x_return_status := Okc_Api.G_RET_STS_ERROR;

2151: p_rulv_rec => l_sll_rulv_rec,
2152: x_rulv_rec => x_rulv_rec
2153: );
2154: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2155: x_return_status := Okc_Api.G_RET_STS_ERROR;
2156: RAISE sync_failed;
2157: END IF;
2158: END LOOP; -- SLL
2159:

Line 2168: x_return_status := OKC_API.G_RET_STS_ERROR;

2164: END LOOP;
2165:
2166: EXCEPTION
2167: WHEN sync_failed THEN
2168: x_return_status := OKC_API.G_RET_STS_ERROR;
2169: END sync_slh_sll;
2170:
2171: ------------------------------------------------------------------------------
2172: -- PROCEDURE sync_party_role

Line 2540: x_return_status := OKC_API.G_RET_STS_ERROR;

2536: END LOOP; -- role
2537:
2538: EXCEPTION
2539: WHEN sync_party_failed THEN
2540: x_return_status := OKC_API.G_RET_STS_ERROR;
2541: END sync_party_role;
2542:
2543: ------------------------------------------------------------------------------
2544: -- PROCEDURE sync_header_values

Line 2627: x_return_status := OKC_API.G_RET_STS_SUCCESS;

2623: END IF;
2624: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2625: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
2626: END IF;
2627: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2628:
2629: l_khrv_rec := get_khrv_rec(
2630: p_khr_id => p_orig_chr_id,
2631: x_return_status => x_return_status

Line 2703: p_init_msg_list => OKC_API.G_FALSE,

2699: --Bug# 8652738
2700:
2701: okl_contract_pub.update_contract_header(
2702: p_api_version => 1.0,
2703: p_init_msg_list => OKC_API.G_FALSE,
2704: x_return_status => x_return_status,
2705: x_msg_count => x_msg_count,
2706: x_msg_data => x_msg_data,
2707: p_restricted_update => OKC_API.G_FALSE,

Line 2707: p_restricted_update => OKC_API.G_FALSE,

2703: p_init_msg_list => OKC_API.G_FALSE,
2704: x_return_status => x_return_status,
2705: x_msg_count => x_msg_count,
2706: x_msg_data => x_msg_data,
2707: p_restricted_update => OKC_API.G_FALSE,
2708: p_chrv_rec => l_chrv_rec,
2709: p_khrv_rec => l_khrv_rec,
2710: x_chrv_rec => x_chrv_rec,
2711: x_khrv_rec => x_khrv_rec

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

2709: p_khrv_rec => l_khrv_rec,
2710: x_chrv_rec => x_chrv_rec,
2711: x_khrv_rec => x_khrv_rec
2712: );
2713: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2714: x_return_status := Okc_Api.G_RET_STS_ERROR;
2715: RAISE sync_failed;
2716: END IF;
2717:

Line 2714: x_return_status := Okc_Api.G_RET_STS_ERROR;

2710: x_chrv_rec => x_chrv_rec,
2711: x_khrv_rec => x_khrv_rec
2712: );
2713: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2714: x_return_status := Okc_Api.G_RET_STS_ERROR;
2715: RAISE sync_failed;
2716: END IF;
2717:
2718: END LOOP;

Line 2724: x_return_status := OKC_API.G_RET_STS_ERROR;

2720: RETURN;
2721:
2722: EXCEPTION
2723: WHEN sync_failed THEN
2724: x_return_status := OKC_API.G_RET_STS_ERROR;
2725: END sync_header_values;
2726:
2727: PROCEDURE sync_passthru_party(
2728: x_return_status OUT NOCOPY VARCHAR2

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

3659: p_klev_rec => l_klev_rec,
3660: x_clev_rec => x_clev_rec,
3661: x_klev_rec => x_klev_rec
3662: );
3663: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3664: RAISE sync_fee_failed;
3665: END IF;
3666:
3667: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

3688: p_klev_rec => l_klev_rec,
3689: x_clev_rec => x_clev_rec,
3690: x_klev_rec => x_klev_rec
3691: );
3692: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3693: RAISE sync_fee_failed;
3694: END IF;
3695: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3696: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Sub line deleted');

Line 3712: p_init_msg_list => OKC_API.G_FALSE,

3708: END LOOP;
3709: IF (l_orig_fee_strm_tbl.COUNT <> 0) THEN
3710: okl_streams_pub.update_streams(
3711: p_api_version => 1.0,
3712: p_init_msg_list => OKC_API.G_FALSE,
3713: x_return_status => x_return_status,
3714: x_msg_count => x_msg_count,
3715: x_msg_data => x_msg_data,
3716: p_stmv_tbl => l_orig_fee_strm_tbl,

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

3716: p_stmv_tbl => l_orig_fee_strm_tbl,
3717: x_stmv_tbl => x_orig_fee_strm_tbl
3718: );
3719:
3720: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3721: RAISE sync_fee_failed;
3722: END IF;
3723: END IF; -- end of l_orig_fee_strm_tbl.COUNT <> 0
3724: END LOOP; -- Orig Fee line ABANDON

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

3756: p_trans_type => 'CRB',
3757: x_cle_id_tbl => lx_rbk_fee_tbl
3758: );
3759:
3760: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3761: RAISE sync_fee_failed;
3762: END IF;
3763:
3764: END IF;

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

3906: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3907: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL.H*** After Update Top line: '||x_return_status);
3908: END IF;
3909:
3910: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3911: RAISE sync_fee_failed;
3912: END IF;
3913: END IF; -- end of attribute comparision and calling update_fee_type API
3914:

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

3913: END IF; -- end of attribute comparision and calling update_fee_type API
3914:
3915: IF (c_fee_rbk_rec.fee_type = 'PASSTHROUGH') THEN
3916: sync_passthru_party(x_return_status => x_return_status);
3917: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3918: RAISE sync_fee_failed;
3919: END IF;
3920: ELSE
3921: -- Sync Fee expense rules for Financed Fee line

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

3976: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3977: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Update LAFREQ : '||x_return_status);
3978: END IF;
3979:
3980: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
3981: x_return_status := Okc_Api.G_RET_STS_ERROR;
3982: RAISE sync_fee_failed;
3983: END IF;
3984: END IF;

Line 3981: x_return_status := Okc_Api.G_RET_STS_ERROR;

3977: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Update LAFREQ : '||x_return_status);
3978: END IF;
3979:
3980: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
3981: x_return_status := Okc_Api.G_RET_STS_ERROR;
3982: RAISE sync_fee_failed;
3983: END IF;
3984: END IF;
3985:

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

4038: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4039: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Update LAFEXP : '||x_return_status);
4040: END IF;
4041:
4042: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
4043: x_return_status := Okc_Api.G_RET_STS_ERROR;
4044: RAISE sync_fee_failed;
4045: END IF;
4046: END IF;

Line 4043: x_return_status := Okc_Api.G_RET_STS_ERROR;

4039: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Update LAFEXP : '||x_return_status);
4040: END IF;
4041:
4042: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
4043: x_return_status := Okc_Api.G_RET_STS_ERROR;
4044: RAISE sync_fee_failed;
4045: END IF;
4046: END IF;
4047: END IF;

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

4089: x_cplv_rec => x_cplv_rec,
4090: p_kplv_rec => l_kplv_rec,
4091: x_kplv_rec => x_kplv_rec );
4092:
4093: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4094: RAISE sync_fee_failed;
4095: END IF;
4096: END IF;
4097: ELSE -- new party

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

4130: x_cplv_rec => x_cplv_rec,
4131: p_kplv_rec => l_kplv_rec,
4132: x_kplv_rec => x_kplv_rec);
4133:
4134: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4135: RAISE sync_fee_failed;
4136: END IF;
4137: END IF;
4138: END LOOP; -- party

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

4222: x_msg_data => x_msg_data,
4223: p_line_item_tbl => l_u_line_item_tbl,
4224: x_line_item_tbl => x_u_line_item_tbl
4225: );
4226: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4227: RAISE sync_fee_failed;
4228: END IF;
4229: END IF;
4230: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 4241: p_init_msg_list => OKC_API.G_FALSE,

4237: -- new covered asset lines.
4238: IF (l_cov_ast_tbl.COUNT > 0) THEN
4239: okl_copy_asset_pub.copy_all_lines(
4240: p_api_version => 1.0,
4241: p_init_msg_list => OKC_API.G_FALSE,
4242: x_return_status => x_return_status,
4243: x_msg_count => x_msg_count,
4244: x_msg_data => x_msg_data,
4245: P_from_cle_id_tbl => l_cov_ast_tbl,

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

4251: p_renew_ref_yn => 'N',
4252: p_trans_type => 'CRB',
4253: x_cle_id_tbl => lx_cov_ast_tbl
4254: );
4255: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4256: RAISE sync_fee_failed;
4257: END IF;
4258: END IF;
4259:

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

4272: x_msg_data => x_msg_data,
4273: p_line_item_tbl => l_c_line_item_tbl,
4274: x_line_item_tbl => x_c_line_item_tbl
4275: );
4276: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4277: RAISE sync_fee_failed;
4278: END IF;
4279: END IF;
4280: debug_message('Link Fee asset inserted; '||l_c_line_item_tbl.COUNT);

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

4291: WHEN sync_fee_failed THEN
4292: x_return_status := OKL_API.G_RET_STS_ERROR;
4293:
4294: when OKL_API.G_EXCEPTION_ERROR then
4295: x_return_status := 'OKC_API.G_RET_STS_ERROR';
4296:
4297: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
4298: x_return_status := 'OKC_API.G_RET_STS_UNEXP_ERROR';
4299:

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

4294: when OKL_API.G_EXCEPTION_ERROR then
4295: x_return_status := 'OKC_API.G_RET_STS_ERROR';
4296:
4297: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
4298: x_return_status := 'OKC_API.G_RET_STS_UNEXP_ERROR';
4299:
4300: END sync_fee_line;
4301:
4302: ------------------------------------------------------------------------------

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

4568: p_trans_type => 'CRB',
4569: x_cle_id_tbl => lx_rbk_service_tbl
4570: );
4571:
4572: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4573: RAISE sync_service_failed;
4574: END IF;
4575: END IF;
4576:

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

4695: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4696: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After Update Service Top line: '||x_return_status);
4697: END IF;
4698:
4699: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4700: RAISE sync_service_failed;
4701: END IF;
4702: END IF;
4703:

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

4838: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4839: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Update LAFREQ : '||x_return_status);
4840: END IF;
4841:
4842: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
4843: x_return_status := Okc_Api.G_RET_STS_ERROR;
4844: RAISE sync_service_failed;
4845: END IF;
4846: END IF;

Line 4843: x_return_status := Okc_Api.G_RET_STS_ERROR;

4839: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Update LAFREQ : '||x_return_status);
4840: END IF;
4841:
4842: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
4843: x_return_status := Okc_Api.G_RET_STS_ERROR;
4844: RAISE sync_service_failed;
4845: END IF;
4846: END IF;
4847:

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

4901: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4902: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Update LAFEXP : '||x_return_status);
4903: END IF;
4904:
4905: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
4906: x_return_status := Okc_Api.G_RET_STS_ERROR;
4907: RAISE sync_service_failed;
4908: END IF;
4909: END IF;

Line 4906: x_return_status := Okc_Api.G_RET_STS_ERROR;

4902: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Update LAFEXP : '||x_return_status);
4903: END IF;
4904:
4905: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
4906: x_return_status := Okc_Api.G_RET_STS_ERROR;
4907: RAISE sync_service_failed;
4908: END IF;
4909: END IF;
4910: END IF; -- Bug#9689536

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

4973: x_msg_data => x_msg_data,
4974: p_line_item_tbl => l_u_line_item_tbl,
4975: x_line_item_tbl => x_u_line_item_tbl
4976: );
4977: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4978: RAISE sync_service_failed;
4979: END IF;
4980: END IF;
4981: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 4988: p_init_msg_list => OKC_API.G_FALSE,

4984:
4985: IF (l_cov_ast_tbl.COUNT > 0) THEN
4986: okl_copy_asset_pub.copy_all_lines(
4987: p_api_version => 1.0,
4988: p_init_msg_list => OKC_API.G_FALSE,
4989: x_return_status => x_return_status,
4990: x_msg_count => x_msg_count,
4991: x_msg_data => x_msg_data,
4992: P_from_cle_id_tbl => l_cov_ast_tbl,

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

4998: p_renew_ref_yn => 'N',
4999: p_trans_type => 'CRB',
5000: x_cle_id_tbl => lx_cov_ast_tbl
5001: );
5002: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5003: RAISE sync_service_failed;
5004: END IF;
5005: END IF;
5006:

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

5017: WHEN sync_service_failed THEN
5018: x_return_status := OKL_API.G_RET_STS_ERROR;
5019:
5020: when OKL_API.G_EXCEPTION_ERROR then
5021: x_return_status := 'OKC_API.G_RET_STS_ERROR';
5022:
5023: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
5024: x_return_status := 'OKC_API.G_RET_STS_UNEXP_ERROR';
5025:

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

5020: when OKL_API.G_EXCEPTION_ERROR then
5021: x_return_status := 'OKC_API.G_RET_STS_ERROR';
5022:
5023: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
5024: x_return_status := 'OKC_API.G_RET_STS_UNEXP_ERROR';
5025:
5026: END sync_service_line;
5027:
5028: ------------------------------------------------------------------------------

Line 5509: x_return_status := OKC_API.G_RET_STS_ERROR;

5505: END LOOP;
5506:
5507: EXCEPTION
5508: WHEN sync_terms_failed THEN
5509: x_return_status := OKC_API.G_RET_STS_ERROR;
5510: END sync_line_terms_conditions;
5511:
5512: ------------------------------------------------------------------------------
5513: -- PROCEDURE sync_line_values

Line 5714: x_return_status := OKC_API.G_RET_STS_SUCCESS;

5710: BEGIN
5711: IF (G_DEBUG_ENABLED = 'Y') THEN
5712: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
5713: END IF;
5714: x_return_status := OKC_API.G_RET_STS_SUCCESS;
5715: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
5716: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
5717: END IF;
5718:

Line 5737: p_init_msg_list => OKC_API.G_FALSE,

5733: END LOOP;
5734:
5735: okl_rule_pub.delete_rule(
5736: p_api_version => 1.0,
5737: p_init_msg_list => OKC_API.G_FALSE,
5738: x_return_status => x_return_status,
5739: x_msg_count => x_msg_count,
5740: x_msg_data => x_msg_data,
5741: p_rulv_tbl => l_rulv_tbl

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

5739: x_msg_count => x_msg_count,
5740: x_msg_data => x_msg_data,
5741: p_rulv_tbl => l_rulv_tbl
5742: );
5743: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5744: RAISE sync_failed;
5745: END IF;
5746:
5747: i := 1;

Line 5988: p_init_msg_list => okc_api.g_false,

5984:
5985: okl_okc_migration_pvt.update_contract_item(
5986:
5987: p_api_version => 1.0,
5988: p_init_msg_list => okc_api.g_false,
5989: x_return_status =>x_return_status,
5990: x_msg_count =>x_msg_count,
5991: x_msg_data =>x_msg_data,
5992: p_cimv_rec =>l_cim_rec,

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

5992: p_cimv_rec =>l_cim_rec,
5993: x_cimv_rec =>x_cim_rec);
5994:
5995:
5996: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5997: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
5998: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' okc_cim_pvt.update_row sync_failed= ');
5999: END IF;
6000: RAISE sync_failed;

Line 6022: p_init_msg_list => OKC_API.G_FALSE,

6018: END IF;
6019:
6020: okl_contract_pub.update_contract_line(
6021: p_api_version => 1.0,
6022: p_init_msg_list => OKC_API.G_FALSE,
6023: x_return_status => x_return_status,
6024: x_msg_count => x_msg_count,
6025: x_msg_data => x_msg_data,
6026: p_clev_tbl => l_clev_tbl,

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

6027: p_klev_tbl => l_klev_tbl,
6028: x_clev_tbl => x_clev_tbl,
6029: x_klev_tbl => x_klev_tbl
6030: );
6031: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
6032: RAISE sync_failed;
6033: END IF;
6034:
6035: --Bug# 8652738

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

6041: p_rebook_chr_id => p_rebook_chr_id,
6042: p_orig_chr_id => p_orig_chr_id
6043: );
6044:
6045: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
6046: RAISE sync_failed;
6047: END IF;
6048:
6049: j := 1;

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

6075: p_trans_type => 'CRB',
6076: x_cle_id_tbl => lx_new_klev_tbl
6077: );
6078:
6079: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
6080: RAISE sync_failed;
6081: END IF;
6082:
6083: --

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

6135: p_trans_type => 'CRB',
6136: x_cle_id_tbl => lx_new_klev_tbl
6137: );
6138:
6139: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
6140: RAISE sync_failed;
6141: END IF;
6142:
6143: --

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

6195: p_trans_type => 'CRB',
6196: x_cle_id_tbl => lx_new_klev_tbl
6197: );
6198:
6199: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
6200: RAISE sync_failed;
6201: END IF;
6202:
6203: -- Supplier Invoice details do not get copied over when copying only Add-On lines

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

6283: p_rebook_chr_id => p_rebook_chr_id,
6284: p_orig_chr_id => p_orig_chr_id
6285: );
6286:
6287: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
6288: RAISE sync_failed;
6289: END IF;
6290:
6291: --Bug# 8652738

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

6299: p_rebook_chr_id => p_rebook_chr_id,
6300: p_orig_chr_id => p_orig_chr_id
6301: );
6302:
6303: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
6304: RAISE sync_failed;
6305: END IF;
6306:
6307: EXCEPTION

Line 6309: x_return_status := OKC_API.G_RET_STS_ERROR;

6305: END IF;
6306:
6307: EXCEPTION
6308: WHEN sync_failed THEN
6309: x_return_status := OKC_API.G_RET_STS_ERROR;
6310: END sync_line_values;
6311:
6312: ------------------------------------------------------------------------------
6313: -- PROCEDURE version_contract

Line 6338: x_return_status := OKC_API.G_RET_STS_SUCCESS;

6334: END IF;
6335: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
6336: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
6337: END IF;
6338: x_return_status := OKC_API.G_RET_STS_SUCCESS;
6339:
6340: l_cvmv_rec.chr_id := p_chr_id;
6341: okl_version_pub.version_contract(
6342: p_api_version => 1.0,

Line 6343: p_init_msg_list => OKC_API.G_FALSE,

6339:
6340: l_cvmv_rec.chr_id := p_chr_id;
6341: okl_version_pub.version_contract(
6342: p_api_version => 1.0,
6343: p_init_msg_list => OKC_API.G_FALSE,
6344: x_return_status => x_return_status,
6345: x_msg_count => x_msg_count,
6346: x_msg_data => x_msg_data,
6347: p_cvmv_rec => l_cvmv_rec,

Line 6349: --p_commit => OKC_API.G_FALSE

6345: x_msg_count => x_msg_count,
6346: x_msg_data => x_msg_data,
6347: p_cvmv_rec => l_cvmv_rec,
6348: x_cvmv_rec => x_cvmv_rec --,
6349: --p_commit => OKC_API.G_FALSE
6350: );
6351: RETURN;
6352:
6353: END version_contract;

Line 6410: x_return_status := OKC_API.G_RET_STS_SUCCESS;

6406: END IF;
6407: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
6408: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
6409: END IF;
6410: x_return_status := OKC_API.G_RET_STS_SUCCESS;
6411:
6412: l_orig_term := NULL;
6413: OPEN term_csr(p_orig_chr_id);
6414: FETCH term_csr INTO l_orig_term,

Line 6463: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

6459: x_chrv_rec => x_chrv_rec,
6460: x_khrv_rec => x_khrv_rec
6461: );
6462:
6463: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
6464: RAISE check_update_failed;
6465: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
6466: RAISE check_update_failed;
6467: END IF;

Line 6465: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

6461: );
6462:
6463: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
6464: RAISE check_update_failed;
6465: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
6466: RAISE check_update_failed;
6467: END IF;
6468:
6469: END IF;

Line 6963: x_return_status := OKC_API.G_RET_STS_ERROR;

6959: END LOOP;
6960:
6961: EXCEPTION
6962: WHEN sync_terms_failed THEN
6963: x_return_status := OKC_API.G_RET_STS_ERROR;
6964: END sync_terms_conditions;
6965:
6966: ------------------------------------------------------------------------------
6967: -- PROCEDURE sync_rebook_orig_contract

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

6981: -- Called By:
6982: ------------------------------------------------------------------------------
6983: PROCEDURE sync_rebook_orig_contract(
6984: p_api_version IN NUMBER,
6985: p_init_msg_list IN VARCHAR2, -- DEFAULT OKC_API.G_FALSE,
6986: x_return_status OUT NOCOPY VARCHAR2,
6987: x_msg_count OUT NOCOPY NUMBER,
6988: x_msg_data OUT NOCOPY VARCHAR2,
6989: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE

Line 7021: x_return_status := OKC_API.G_RET_STS_SUCCESS;

7017: IF (G_DEBUG_ENABLED = 'Y') THEN
7018: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
7019: END IF;
7020:
7021: x_return_status := OKC_API.G_RET_STS_SUCCESS;
7022: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
7023: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
7024: END IF;
7025: -- call START_ACTIVITY to create savepoint, check compatibility

Line 7027: x_return_status := OKC_API.START_ACTIVITY(

7023: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
7024: END IF;
7025: -- call START_ACTIVITY to create savepoint, check compatibility
7026: -- and initialize message list
7027: x_return_status := OKC_API.START_ACTIVITY(
7028: p_api_name => l_api_name,
7029: p_pkg_name => G_PKG_NAME,
7030: p_init_msg_list => p_init_msg_list,
7031: l_api_version => p_api_version,

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

7033: p_api_type => G_API_TYPE,
7034: x_return_status => x_return_status);
7035:
7036: -- check if activity started successfully
7037: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7038: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7039: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7040: RAISE OKC_API.G_EXCEPTION_ERROR;
7041: END IF;

Line 7038: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

7034: x_return_status => x_return_status);
7035:
7036: -- check if activity started successfully
7037: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7038: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7039: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7040: RAISE OKC_API.G_EXCEPTION_ERROR;
7041: END IF;
7042:

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

7035:
7036: -- check if activity started successfully
7037: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7038: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7039: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7040: RAISE OKC_API.G_EXCEPTION_ERROR;
7041: END IF;
7042:
7043: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Line 7040: RAISE OKC_API.G_EXCEPTION_ERROR;

7036: -- check if activity started successfully
7037: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7038: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7039: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7040: RAISE OKC_API.G_EXCEPTION_ERROR;
7041: END IF;
7042:
7043: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
7044:

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

7046: x_return_status => x_return_status,
7047: p_chr_id => p_rebook_chr_id,
7048: x_orig_chr_id => l_orig_chr_id
7049: );
7050: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7051: okl_api.set_message(
7052: G_APP_NAME,
7053: G_LLA_NO_ORIG_REFERENCE
7054: );

Line 7055: RAISE OKC_API.G_EXCEPTION_ERROR;

7051: okl_api.set_message(
7052: G_APP_NAME,
7053: G_LLA_NO_ORIG_REFERENCE
7054: );
7055: RAISE OKC_API.G_EXCEPTION_ERROR;
7056: END IF;
7057:
7058: --
7059: -- Version the Original Contract

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

7065: x_msg_data => x_msg_data,
7066: p_chr_id => l_orig_chr_id
7067: );
7068:
7069: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7070: RAISE OKC_API.G_EXCEPTION_ERROR;
7071: END IF;
7072:
7073: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 7070: RAISE OKC_API.G_EXCEPTION_ERROR;

7066: p_chr_id => l_orig_chr_id
7067: );
7068:
7069: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7070: RAISE OKC_API.G_EXCEPTION_ERROR;
7071: END IF;
7072:
7073: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
7074: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After Versioning of Contract');

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

7092: p_orig_chr_id => l_orig_chr_id,
7093: p_rebook_chr_id => p_rebook_chr_id
7094: );
7095:
7096: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7097: RAISE OKC_API.G_EXCEPTION_ERROR;
7098: END IF;
7099:
7100: --

Line 7097: RAISE OKC_API.G_EXCEPTION_ERROR;

7093: p_rebook_chr_id => p_rebook_chr_id
7094: );
7095:
7096: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7097: RAISE OKC_API.G_EXCEPTION_ERROR;
7098: END IF;
7099:
7100: --
7101: -- Fix Bug# 3042346

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

7107: p_rebook_chr_id => p_rebook_chr_id,
7108: p_orig_chr_id => l_orig_chr_id
7109: );
7110:
7111: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7112: RAISE OKC_API.G_EXCEPTION_ERROR;
7113: END IF;
7114:
7115: --

Line 7112: RAISE OKC_API.G_EXCEPTION_ERROR;

7108: p_orig_chr_id => l_orig_chr_id
7109: );
7110:
7111: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7112: RAISE OKC_API.G_EXCEPTION_ERROR;
7113: END IF;
7114:
7115: --
7116: -- 1. Adjust Residual Value

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

7125: x_new_klev_tbl => l_update_klev_tbl,
7126: x_new_clev_tbl => l_update_clev_tbl
7127: );
7128:
7129: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7130: RAISE OKC_API.G_EXCEPTION_ERROR;
7131: END IF;
7132:
7133: -- 3. Change Due Date

Line 7130: RAISE OKC_API.G_EXCEPTION_ERROR;

7126: x_new_clev_tbl => l_update_clev_tbl
7127: );
7128:
7129: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7130: RAISE OKC_API.G_EXCEPTION_ERROR;
7131: END IF;
7132:
7133: -- 3. Change Due Date
7134: -- 4. Change Start Date

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

7143: p_rebook_chr_id => p_rebook_chr_id,
7144: p_orig_chr_id => l_orig_chr_id
7145: );
7146:
7147: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7148: RAISE OKC_API.G_EXCEPTION_ERROR;
7149: END IF;
7150:
7151: --4542290

Line 7148: RAISE OKC_API.G_EXCEPTION_ERROR;

7144: p_orig_chr_id => l_orig_chr_id
7145: );
7146:
7147: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7148: RAISE OKC_API.G_EXCEPTION_ERROR;
7149: END IF;
7150:
7151: --4542290
7152: OKL_K_RATE_PARAMS_PVT.SYNC_RATE_PARAMS(

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

7166: p_rebook_chr_id => p_rebook_chr_id,
7167: p_orig_chr_id => l_orig_chr_id
7168: );
7169:
7170: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7171: RAISE OKC_API.G_EXCEPTION_ERROR;
7172: END IF;
7173:
7174: IF l_update_clev_tbl.COUNT > 0 THEN

Line 7171: RAISE OKC_API.G_EXCEPTION_ERROR;

7167: p_orig_chr_id => l_orig_chr_id
7168: );
7169:
7170: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7171: RAISE OKC_API.G_EXCEPTION_ERROR;
7172: END IF;
7173:
7174: IF l_update_clev_tbl.COUNT > 0 THEN
7175:

Line 7178: p_init_msg_list => OKC_API.G_FALSE,

7174: IF l_update_clev_tbl.COUNT > 0 THEN
7175:
7176: OKL_CONTRACT_PUB.update_contract_line(
7177: p_api_version => p_api_version,
7178: p_init_msg_list => OKC_API.G_FALSE,
7179: x_return_status => x_return_status,
7180: x_msg_count => x_msg_count,
7181: x_msg_data => x_msg_data,
7182: p_clev_tbl => l_update_clev_tbl,

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

7183: p_klev_tbl => l_update_klev_tbl,
7184: x_clev_tbl => x_update_clev_tbl,
7185: x_klev_tbl => x_update_klev_tbl);
7186:
7187: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7188: RAISE OKC_API.G_EXCEPTION_ERROR;
7189: END IF;
7190:
7191: END IF;

Line 7188: RAISE OKC_API.G_EXCEPTION_ERROR;

7184: x_clev_tbl => x_update_clev_tbl,
7185: x_klev_tbl => x_update_klev_tbl);
7186:
7187: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7188: RAISE OKC_API.G_EXCEPTION_ERROR;
7189: END IF;
7190:
7191: END IF;
7192:

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

7198: p_rebook_chr_id => p_rebook_chr_id,
7199: p_orig_chr_id => l_orig_chr_id
7200: );
7201:
7202: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7203: RAISE OKC_API.G_EXCEPTION_ERROR;
7204: END IF;
7205:
7206: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 7203: RAISE OKC_API.G_EXCEPTION_ERROR;

7199: p_orig_chr_id => l_orig_chr_id
7200: );
7201:
7202: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7203: RAISE OKC_API.G_EXCEPTION_ERROR;
7204: END IF;
7205:
7206: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
7207: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After SYNC_SLH_SLL');

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

7216: p_rebook_chr_id => p_rebook_chr_id,
7217: p_orig_chr_id => l_orig_chr_id
7218: );
7219:
7220: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7221: RAISE OKC_API.G_EXCEPTION_ERROR;
7222: END IF;
7223:
7224: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Line 7221: RAISE OKC_API.G_EXCEPTION_ERROR;

7217: p_orig_chr_id => l_orig_chr_id
7218: );
7219:
7220: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7221: RAISE OKC_API.G_EXCEPTION_ERROR;
7222: END IF;
7223:
7224: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
7225: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 7229: WHEN OKC_API.G_EXCEPTION_ERROR THEN

7225: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
7226: x_msg_data => x_msg_data);
7227:
7228: EXCEPTION
7229: WHEN OKC_API.G_EXCEPTION_ERROR THEN
7230: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
7231: p_api_name => l_api_name,
7232: p_pkg_name => G_PKG_NAME,
7233: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 7230: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

7226: x_msg_data => x_msg_data);
7227:
7228: EXCEPTION
7229: WHEN OKC_API.G_EXCEPTION_ERROR THEN
7230: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
7231: p_api_name => l_api_name,
7232: p_pkg_name => G_PKG_NAME,
7233: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
7234: x_msg_count => x_msg_count,

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

7229: WHEN OKC_API.G_EXCEPTION_ERROR THEN
7230: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
7231: p_api_name => l_api_name,
7232: p_pkg_name => G_PKG_NAME,
7233: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
7234: x_msg_count => x_msg_count,
7235: x_msg_data => x_msg_data,
7236: p_api_type => G_API_TYPE);
7237:

Line 7238: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

7234: x_msg_count => x_msg_count,
7235: x_msg_data => x_msg_data,
7236: p_api_type => G_API_TYPE);
7237:
7238: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
7239: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
7240: p_api_name => l_api_name,
7241: p_pkg_name => G_PKG_NAME,
7242: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 7239: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

7235: x_msg_data => x_msg_data,
7236: p_api_type => G_API_TYPE);
7237:
7238: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
7239: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
7240: p_api_name => l_api_name,
7241: p_pkg_name => G_PKG_NAME,
7242: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
7243: x_msg_count => x_msg_count,

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

7238: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
7239: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
7240: p_api_name => l_api_name,
7241: p_pkg_name => G_PKG_NAME,
7242: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
7243: x_msg_count => x_msg_count,
7244: x_msg_data => x_msg_data,
7245: p_api_type => G_API_TYPE);
7246:

Line 7248: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

7244: x_msg_data => x_msg_data,
7245: p_api_type => G_API_TYPE);
7246:
7247: WHEN OTHERS THEN
7248: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
7249: p_api_name => l_api_name,
7250: p_pkg_name => G_PKG_NAME,
7251: p_exc_name => 'OTHERS',
7252: x_msg_count => x_msg_count,

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

7264: -- Called By:
7265: ------------------------------------------------------------------------------
7266: PROCEDURE create_txn_contract(
7267: p_api_version IN NUMBER,
7268: p_init_msg_list IN VARCHAR2, -- DEFAULT OKC_API.G_FALSE,
7269: x_return_status OUT NOCOPY VARCHAR2,
7270: x_msg_count OUT NOCOPY NUMBER,
7271: x_msg_data OUT NOCOPY VARCHAR2,
7272: p_from_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

Line 7346: x_return_status := OKC_API.G_RET_STS_SUCCESS;

7342:
7343:
7344: BEGIN -- main process begins here
7345:
7346: x_return_status := OKC_API.G_RET_STS_SUCCESS;
7347: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
7348: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
7349: END IF;
7350: -- call START_ACTIVITY to create savepoint, check compatibility

Line 7352: x_return_status := OKC_API.START_ACTIVITY(

7348: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
7349: END IF;
7350: -- call START_ACTIVITY to create savepoint, check compatibility
7351: -- and initialize message list
7352: x_return_status := OKC_API.START_ACTIVITY(
7353: p_api_name => l_api_name,
7354: p_pkg_name => G_PKG_NAME,
7355: p_init_msg_list => p_init_msg_list,
7356: l_api_version => l_api_version,

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

7358: p_api_type => G_API_TYPE,
7359: x_return_status => x_return_status);
7360:
7361: -- check if activity started successfully
7362: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7363: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7364: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7365: RAISE OKC_API.G_EXCEPTION_ERROR;
7366: END IF;

Line 7363: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

7359: x_return_status => x_return_status);
7360:
7361: -- check if activity started successfully
7362: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7363: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7364: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7365: RAISE OKC_API.G_EXCEPTION_ERROR;
7366: END IF;
7367:

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

7360:
7361: -- check if activity started successfully
7362: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7363: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7364: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7365: RAISE OKC_API.G_EXCEPTION_ERROR;
7366: END IF;
7367:
7368: --Bug# 8351588

Line 7365: RAISE OKC_API.G_EXCEPTION_ERROR;

7361: -- check if activity started successfully
7362: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7363: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7364: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7365: RAISE OKC_API.G_EXCEPTION_ERROR;
7366: END IF;
7367:
7368: --Bug# 8351588
7369: OPEN l_rbk_limit_date_csr(p_chr_id => p_from_chr_id);

Line 7383: RAISE OKC_API.G_EXCEPTION_ERROR;

7379: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
7380: p_msg_name => 'OKL_LLA_CHK_RBK_LIMIT_DATE',
7381: p_token1 => 'REBOOK_LIMIT_DATE',
7382: p_token1_value => TO_CHAR(FND_DATE.canonical_to_date(l_rbk_limit_date_rec.rule_information1),l_icx_date_format));
7383: RAISE OKC_API.G_EXCEPTION_ERROR;
7384: END IF;
7385: --Bug# 8351588
7386:
7387: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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

7397: x_rebook_chr_id => x_rebook_chr_id,
7398: p_rbk_date => p_trx_date
7399: );
7400:
7401: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7402: RAISE OKC_API.G_EXCEPTION_ERROR;
7403: END IF;
7404:
7405: -- Create Transaction for the rebook-ed contract

Line 7402: RAISE OKC_API.G_EXCEPTION_ERROR;

7398: p_rbk_date => p_trx_date
7399: );
7400:
7401: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7402: RAISE OKC_API.G_EXCEPTION_ERROR;
7403: END IF;
7404:
7405: -- Create Transaction for the rebook-ed contract
7406: okl_transaction_pvt.create_transaction(

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

7417: p_trx_type => 'REBOOK',
7418: x_tcnv_rec => x_tcnv_rec
7419: );
7420:
7421: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7422: RAISE OKC_API.G_EXCEPTION_ERROR;
7423: END IF;
7424:
7425: /*

Line 7422: RAISE OKC_API.G_EXCEPTION_ERROR;

7418: x_tcnv_rec => x_tcnv_rec
7419: );
7420:
7421: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7422: RAISE OKC_API.G_EXCEPTION_ERROR;
7423: END IF;
7424:
7425: /*
7426: -- mvasudev, 08/23/2004

Line 7448: WHEN OKC_API.G_EXCEPTION_ERROR THEN

7444: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
7445: x_msg_data => x_msg_data);
7446:
7447: EXCEPTION
7448: WHEN OKC_API.G_EXCEPTION_ERROR THEN
7449: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
7450: p_api_name => l_api_name,
7451: p_pkg_name => G_PKG_NAME,
7452: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 7449: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

7445: x_msg_data => x_msg_data);
7446:
7447: EXCEPTION
7448: WHEN OKC_API.G_EXCEPTION_ERROR THEN
7449: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
7450: p_api_name => l_api_name,
7451: p_pkg_name => G_PKG_NAME,
7452: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
7453: x_msg_count => x_msg_count,

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

7448: WHEN OKC_API.G_EXCEPTION_ERROR THEN
7449: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
7450: p_api_name => l_api_name,
7451: p_pkg_name => G_PKG_NAME,
7452: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
7453: x_msg_count => x_msg_count,
7454: x_msg_data => x_msg_data,
7455: p_api_type => G_API_TYPE);
7456:

Line 7457: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

7453: x_msg_count => x_msg_count,
7454: x_msg_data => x_msg_data,
7455: p_api_type => G_API_TYPE);
7456:
7457: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
7458: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
7459: p_api_name => l_api_name,
7460: p_pkg_name => G_PKG_NAME,
7461: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 7458: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

7454: x_msg_data => x_msg_data,
7455: p_api_type => G_API_TYPE);
7456:
7457: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
7458: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
7459: p_api_name => l_api_name,
7460: p_pkg_name => G_PKG_NAME,
7461: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
7462: x_msg_count => x_msg_count,

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

7457: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
7458: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
7459: p_api_name => l_api_name,
7460: p_pkg_name => G_PKG_NAME,
7461: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
7462: x_msg_count => x_msg_count,
7463: x_msg_data => x_msg_data,
7464: p_api_type => G_API_TYPE);
7465:

Line 7467: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

7463: x_msg_data => x_msg_data,
7464: p_api_type => G_API_TYPE);
7465:
7466: WHEN OTHERS THEN
7467: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
7468: p_api_name => l_api_name,
7469: p_pkg_name => G_PKG_NAME,
7470: p_exc_name => 'OTHERS',
7471: x_msg_count => x_msg_count,

Line 7556: x_return_status := OKC_API.G_RET_STS_SUCCESS;

7552: IF (G_DEBUG_ENABLED = 'Y') THEN
7553: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
7554: END IF;
7555:
7556: x_return_status := OKC_API.G_RET_STS_SUCCESS;
7557: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
7558: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
7559: END IF;
7560:

Line 7571: p_init_msg_list => OKC_API.G_FALSE,

7567: END LOOP;
7568:
7569: okl_securitization_pvt.check_khr_securitized(
7570: p_api_version => 1.0,
7571: p_init_msg_list => OKC_API.G_FALSE,
7572: x_return_status => x_return_status,
7573: x_msg_count => x_msg_count,
7574: x_msg_data => x_msg_data,
7575: p_khr_id => p_orig_chr_id,

Line 7609: p_init_msg_list => OKC_API.G_FALSE,

7605:
7606: IF (l_disb_strm_tbl.COUNT > 0) THEN
7607: okl_streams_pub.update_streams(
7608: p_api_version => 1.0,
7609: p_init_msg_list => OKC_API.G_FALSE,
7610: x_return_status => x_return_status,
7611: x_msg_count => x_msg_count,
7612: x_msg_data => x_msg_data,
7613: p_stmv_tbl => l_disb_strm_tbl,

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

7613: p_stmv_tbl => l_disb_strm_tbl,
7614: x_stmv_tbl => x_disb_strm_tbl
7615: );
7616:
7617: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7618: RAISE secu_failed;
7619: END IF;
7620: END IF;
7621:

Line 7630: p_init_msg_list => OKC_API.G_FALSE,

7626: -- Create Pool transaction after rebook
7627: --
7628: okl_securitization_pvt.modify_pool_contents(
7629: p_api_version => 1.0,
7630: p_init_msg_list => OKC_API.G_FALSE,
7631: x_return_status => x_return_status,
7632: x_msg_count => x_msg_count,
7633: x_msg_data => x_msg_data,
7634: p_transaction_reason => OKL_SECURITIZATION_PVT.G_TRX_REASON_CONTRACT_REBOOK,

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

7636: p_transaction_date => l_rebook_date,
7637: p_effective_date => l_rebook_date
7638: );
7639:
7640: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7641: RAISE secu_failed;
7642: END IF;
7643: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
7644: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After Modify pool contents');

Line 7666: p_init_msg_list => OKC_API.G_FALSE,

7662:
7663: IF (l_accu_strm_tbl.COUNT > 0) THEN
7664: okl_streams_pub.update_streams(
7665: p_api_version => 1.0,
7666: p_init_msg_list => OKC_API.G_FALSE,
7667: x_return_status => x_return_status,
7668: x_msg_count => x_msg_count,
7669: x_msg_data => x_msg_data,
7670: p_stmv_tbl => l_accu_strm_tbl,

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

7670: p_stmv_tbl => l_accu_strm_tbl,
7671: x_stmv_tbl => x_accu_strm_tbl
7672: );
7673:
7674: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7675: RAISE secu_failed;
7676: END IF;
7677: END IF;
7678:

Line 7688: p_init_msg_list => OKC_API.G_FALSE,

7684: -- Regenerate disbursement streams
7685: --
7686: okl_stream_generator_pvt.create_disb_streams(
7687: p_api_version => 1.0,
7688: p_init_msg_list => OKC_API.G_FALSE,
7689: x_return_status => x_return_status,
7690: x_msg_count => x_msg_count,
7691: x_msg_data => x_msg_data,
7692: p_contract_id => p_orig_chr_id

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

7691: x_msg_data => x_msg_data,
7692: p_contract_id => p_orig_chr_id
7693: );
7694:
7695: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7696: RAISE secu_failed;
7697: END IF;
7698: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
7699: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After regerating disb. streams');

Line 7708: p_init_msg_list => OKC_API.G_FALSE,

7704: -- Regenerate Present Value Disbursement streams
7705: --
7706: okl_stream_generator_pvt.create_pv_streams(
7707: p_api_version => 1.0,
7708: p_init_msg_list => OKC_API.G_FALSE,
7709: x_return_status => x_return_status,
7710: x_msg_count => x_msg_count,
7711: x_msg_data => x_msg_data,
7712: p_contract_id => p_orig_chr_id

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

7711: x_msg_data => x_msg_data,
7712: p_contract_id => p_orig_chr_id
7713: );
7714:
7715: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7716: RAISE secu_failed;
7717: END IF;
7718: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
7719: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After regerating Present Value Disbursement streams');

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

7730: x_msg_data => x_msg_data,
7731: p_khr_id => p_orig_chr_id
7732: );
7733:
7734: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7735: RAISE secu_failed;
7736: END IF;
7737: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
7738: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After regerating Investor accrual streams');

Line 7748: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

7744: WHEN secu_failed THEN
7745: NULL; -- excception is handled by caller
7746:
7747: WHEN OTHERS THEN
7748: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
7749: p_api_name => l_api_name,
7750: p_pkg_name => G_PKG_NAME,
7751: p_exc_name => 'OTHERS',
7752: x_msg_count => x_msg_count,

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

7765: ------------------------------------------------------------------------------
7766:
7767: PROCEDURE sync_rebook_stream(
7768: p_api_version IN NUMBER,
7769: p_init_msg_list IN VARCHAR2, -- DEFAULT OKC_API.G_FALSE,
7770: x_return_status OUT NOCOPY VARCHAR2,
7771: x_msg_count OUT NOCOPY NUMBER,
7772: x_msg_data OUT NOCOPY VARCHAR2,
7773: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

Line 7817: x_return_status := OKC_API.G_RET_STS_SUCCESS;

7813: IF (G_DEBUG_ENABLED = 'Y') THEN
7814: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
7815: END IF;
7816:
7817: x_return_status := OKC_API.G_RET_STS_SUCCESS;
7818: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
7819: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
7820: END IF;
7821: -- call START_ACTIVITY to create savepoint, check compatibility

Line 7823: x_return_status := OKC_API.START_ACTIVITY(

7819: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
7820: END IF;
7821: -- call START_ACTIVITY to create savepoint, check compatibility
7822: -- and initialize message list
7823: x_return_status := OKC_API.START_ACTIVITY(
7824: p_api_name => l_api_name,
7825: p_pkg_name => G_PKG_NAME,
7826: p_init_msg_list => p_init_msg_list,
7827: l_api_version => l_api_version,

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

7829: p_api_type => G_API_TYPE,
7830: x_return_status => x_return_status);
7831:
7832: -- check if activity started successfully
7833: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7834: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7835: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7836: RAISE OKC_API.G_EXCEPTION_ERROR;
7837: END IF;

Line 7834: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

7830: x_return_status => x_return_status);
7831:
7832: -- check if activity started successfully
7833: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7834: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7835: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7836: RAISE OKC_API.G_EXCEPTION_ERROR;
7837: END IF;
7838: --**********************************************************

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

7831:
7832: -- check if activity started successfully
7833: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7834: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7835: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7836: RAISE OKC_API.G_EXCEPTION_ERROR;
7837: END IF;
7838: --**********************************************************
7839:

Line 7836: RAISE OKC_API.G_EXCEPTION_ERROR;

7832: -- check if activity started successfully
7833: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7834: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7835: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7836: RAISE OKC_API.G_EXCEPTION_ERROR;
7837: END IF;
7838: --**********************************************************
7839:
7840: get_orig_chr_id(

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

7841: x_return_status => x_return_status,
7842: p_chr_id => p_chr_id,
7843: x_orig_chr_id => l_orig_chr_id
7844: );
7845: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7846: okl_api.set_message(
7847: G_APP_NAME,
7848: G_LLA_NO_ORIG_REFERENCE
7849: );

Line 7850: RAISE OKC_API.G_EXCEPTION_ERROR;

7846: okl_api.set_message(
7847: G_APP_NAME,
7848: G_LLA_NO_ORIG_REFERENCE
7849: );
7850: RAISE OKC_API.G_EXCEPTION_ERROR;
7851: END IF;
7852:
7853: /*
7854: * Bug# , 03/12/2003

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

7866: p_status => 'HIST',
7867: p_active_yn => 'N'
7868: );
7869:
7870: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7871: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7872: END IF;
7873:
7874: debug_message('Change Status: '||x_return_status);

Line 7871: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

7867: p_active_yn => 'N'
7868: );
7869:
7870: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7871: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7872: END IF;
7873:
7874: debug_message('Change Status: '||x_return_status);
7875: */

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

7882: p_orig_chr_id => l_orig_chr_id,
7883: p_rebook_chr_id => p_chr_id
7884: );
7885:
7886: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7887: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7888: END IF;
7889:
7890: -- Change status of Rebooked Stream to 'HIST'

Line 7887: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

7883: p_rebook_chr_id => p_chr_id
7884: );
7885:
7886: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7887: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7888: END IF;
7889:
7890: -- Change status of Rebooked Stream to 'HIST'
7891: change_stream_status(

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

7896: p_status => 'HIST',
7897: p_active_yn => 'N'
7898: );
7899:
7900: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7901: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7902: END IF;
7903:
7904: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 7901: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

7897: p_active_yn => 'N'
7898: );
7899:
7900: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7901: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7902: END IF;
7903:
7904: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
7905: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Change Status 2: '||x_return_status);

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

7915: p_orig_chr_id => l_orig_chr_id,
7916: p_rebook_chr_id => p_chr_id
7917: );
7918:
7919: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7920: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7921: END IF;
7922:
7923: -- Bug# 4775555: Start

Line 7920: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

7916: p_rebook_chr_id => p_chr_id
7917: );
7918:
7919: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7920: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7921: END IF;
7922:
7923: -- Bug# 4775555: Start
7924: --

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

7938: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
7939: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After call create_inv_disb_adjustment'||x_return_status);
7940: END IF;
7941:
7942: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7943: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7944: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7945: RAISE OKC_API.G_EXCEPTION_ERROR;
7946: END IF;

Line 7943: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

7939: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After call create_inv_disb_adjustment'||x_return_status);
7940: END IF;
7941:
7942: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7943: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7944: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7945: RAISE OKC_API.G_EXCEPTION_ERROR;
7946: END IF;
7947:

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

7940: END IF;
7941:
7942: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7943: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7944: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7945: RAISE OKC_API.G_EXCEPTION_ERROR;
7946: END IF;
7947:
7948: --get rebook transaction

Line 7945: RAISE OKC_API.G_EXCEPTION_ERROR;

7941:
7942: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7943: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7944: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7945: RAISE OKC_API.G_EXCEPTION_ERROR;
7946: END IF;
7947:
7948: --get rebook transaction
7949: OPEN l_rbk_trx_csr (p_chr_id => p_chr_id);

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

7972: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
7973: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After call calc_inv_acc_adjustment'||x_return_status);
7974: END IF;
7975:
7976: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7977: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7978: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7979: RAISE OKC_API.G_EXCEPTION_ERROR;
7980: END IF;

Line 7977: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

7973: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After call calc_inv_acc_adjustment'||x_return_status);
7974: END IF;
7975:
7976: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7977: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7978: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7979: RAISE OKC_API.G_EXCEPTION_ERROR;
7980: END IF;
7981:

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

7974: END IF;
7975:
7976: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7977: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7978: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7979: RAISE OKC_API.G_EXCEPTION_ERROR;
7980: END IF;
7981:
7982: IF (l_inv_stream_tbl.COUNT > 0) THEN

Line 7979: RAISE OKC_API.G_EXCEPTION_ERROR;

7975:
7976: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7977: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7978: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7979: RAISE OKC_API.G_EXCEPTION_ERROR;
7980: END IF;
7981:
7982: IF (l_inv_stream_tbl.COUNT > 0) THEN
7983: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

8032: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
8033: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After call calc_inv_acc_adjustment'||x_return_status);
8034: END IF;
8035:
8036: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8037: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8038: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8039: RAISE OKC_API.G_EXCEPTION_ERROR;
8040: END IF;

Line 8037: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

8033: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After call calc_inv_acc_adjustment'||x_return_status);
8034: END IF;
8035:
8036: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8037: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8038: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8039: RAISE OKC_API.G_EXCEPTION_ERROR;
8040: END IF;
8041:

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

8034: END IF;
8035:
8036: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8037: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8038: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8039: RAISE OKC_API.G_EXCEPTION_ERROR;
8040: END IF;
8041:
8042: IF (l_inv_stream_tbl.COUNT > 0) THEN

Line 8039: RAISE OKC_API.G_EXCEPTION_ERROR;

8035:
8036: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8037: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8038: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8039: RAISE OKC_API.G_EXCEPTION_ERROR;
8040: END IF;
8041:
8042: IF (l_inv_stream_tbl.COUNT > 0) THEN
8043: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 8081: WHEN OKC_API.G_EXCEPTION_ERROR THEN

8077: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
8078: x_msg_data => x_msg_data);
8079:
8080: EXCEPTION
8081: WHEN OKC_API.G_EXCEPTION_ERROR THEN
8082: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
8083: p_api_name => l_api_name,
8084: p_pkg_name => G_PKG_NAME,
8085: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 8082: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

8078: x_msg_data => x_msg_data);
8079:
8080: EXCEPTION
8081: WHEN OKC_API.G_EXCEPTION_ERROR THEN
8082: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
8083: p_api_name => l_api_name,
8084: p_pkg_name => G_PKG_NAME,
8085: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
8086: x_msg_count => x_msg_count,

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

8081: WHEN OKC_API.G_EXCEPTION_ERROR THEN
8082: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
8083: p_api_name => l_api_name,
8084: p_pkg_name => G_PKG_NAME,
8085: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
8086: x_msg_count => x_msg_count,
8087: x_msg_data => x_msg_data,
8088: p_api_type => G_API_TYPE);
8089:

Line 8090: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

8086: x_msg_count => x_msg_count,
8087: x_msg_data => x_msg_data,
8088: p_api_type => G_API_TYPE);
8089:
8090: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8091: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
8092: p_api_name => l_api_name,
8093: p_pkg_name => G_PKG_NAME,
8094: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 8091: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

8087: x_msg_data => x_msg_data,
8088: p_api_type => G_API_TYPE);
8089:
8090: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8091: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
8092: p_api_name => l_api_name,
8093: p_pkg_name => G_PKG_NAME,
8094: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
8095: x_msg_count => x_msg_count,

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

8090: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8091: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
8092: p_api_name => l_api_name,
8093: p_pkg_name => G_PKG_NAME,
8094: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
8095: x_msg_count => x_msg_count,
8096: x_msg_data => x_msg_data,
8097: p_api_type => G_API_TYPE);
8098:

Line 8100: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

8096: x_msg_data => x_msg_data,
8097: p_api_type => G_API_TYPE);
8098:
8099: WHEN OTHERS THEN
8100: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
8101: p_api_name => l_api_name,
8102: p_pkg_name => G_PKG_NAME,
8103: p_exc_name => 'OTHERS',
8104: x_msg_count => x_msg_count,

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

8119: ------------------------------------------------------------------------------
8120:
8121: PROCEDURE create_rebook_contract(
8122: p_api_version IN NUMBER,
8123: p_init_msg_list IN VARCHAR2, -- DEFAULT OKC_API.G_FALSE,
8124: x_return_status OUT NOCOPY VARCHAR2,
8125: x_msg_count OUT NOCOPY NUMBER,
8126: x_msg_data OUT NOCOPY VARCHAR2,
8127: p_from_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

Line 8174: x_return_status := OKC_API.G_RET_STS_SUCCESS;

8170: IF (G_DEBUG_ENABLED = 'Y') THEN
8171: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
8172: END IF;
8173:
8174: x_return_status := OKC_API.G_RET_STS_SUCCESS;
8175: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
8176: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
8177: END IF;
8178: -- call START_ACTIVITY to create savepoint, check compatibility

Line 8180: x_return_status := OKC_API.START_ACTIVITY(

8176: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
8177: END IF;
8178: -- call START_ACTIVITY to create savepoint, check compatibility
8179: -- and initialize message list
8180: x_return_status := OKC_API.START_ACTIVITY(
8181: p_api_name => l_api_name,
8182: p_pkg_name => G_PKG_NAME,
8183: p_init_msg_list => p_init_msg_list,
8184: l_api_version => l_api_version,

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

8186: p_api_type => G_API_TYPE,
8187: x_return_status => x_return_status);
8188:
8189: -- check if activity started successfully
8190: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8191: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8192: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8193: RAISE OKC_API.G_EXCEPTION_ERROR;
8194: END IF;

Line 8191: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

8187: x_return_status => x_return_status);
8188:
8189: -- check if activity started successfully
8190: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8191: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8192: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8193: RAISE OKC_API.G_EXCEPTION_ERROR;
8194: END IF;
8195: --**********************************************************

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

8188:
8189: -- check if activity started successfully
8190: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8191: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8192: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8193: RAISE OKC_API.G_EXCEPTION_ERROR;
8194: END IF;
8195: --**********************************************************
8196: -- Get Sequence Number to generate Contract Number

Line 8193: RAISE OKC_API.G_EXCEPTION_ERROR;

8189: -- check if activity started successfully
8190: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8191: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8192: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8193: RAISE OKC_API.G_EXCEPTION_ERROR;
8194: END IF;
8195: --**********************************************************
8196: -- Get Sequence Number to generate Contract Number
8197: SELECT okl_rbk_seq.NEXTVAL

Line 8210: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

8206: okl_api.set_message(
8207: G_APP_NAME,
8208: G_LLA_CHR_ID
8209: );
8210: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8211: --start:| 24-Mar-08 cklee Bug# 6801137 -- Added validation logic |
8212: ELSE
8213: IF l_orig_sts_code <> 'BOOKED' THEN
8214: okl_api.set_message(

Line 8218: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

8214: okl_api.set_message(
8215: G_APP_NAME,
8216: 'OKL_LLA_REV_ONLY_BOOKED'
8217: );
8218: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8219: END IF;
8220: --end:| 24-Mar-08 cklee Bug# 6801137 -- Added validation logic |
8221:
8222: END IF;

Line 8232: p_init_msg_list => OKC_API.G_FALSE,

8228: -- Copy Contract to Create Rebook Contract
8229: --
8230: okl_copy_contract_pub.copy_lease_contract_new(
8231: p_api_version => 1.0,
8232: p_init_msg_list => OKC_API.G_FALSE,
8233: x_return_status => x_return_status,
8234: x_msg_count => x_msg_count,
8235: x_msg_data => x_msg_data,
8236: p_chr_id => p_from_chr_id,

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

8241: x_chr_id => x_chr_id,
8242: p_rbk_date => p_rbk_date
8243: );
8244:
8245: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
8246: RAISE OKC_API.G_EXCEPTION_ERROR;
8247: END IF;
8248:
8249:

Line 8246: RAISE OKC_API.G_EXCEPTION_ERROR;

8242: p_rbk_date => p_rbk_date
8243: );
8244:
8245: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
8246: RAISE OKC_API.G_EXCEPTION_ERROR;
8247: END IF;
8248:
8249:
8250: /*

Line 8253: p_init_msg_list => OKC_API.G_FALSE,

8249:
8250: /*
8251: okl_copy_contract_pub.copy_contract(
8252: p_api_version => 1.0,
8253: p_init_msg_list => OKC_API.G_FALSE,
8254: x_return_status => x_return_status,
8255: x_msg_count => x_msg_count,
8256: x_msg_data => x_msg_data,
8257: p_commit => OKC_API.G_FALSE,

Line 8257: p_commit => OKC_API.G_FALSE,

8253: p_init_msg_list => OKC_API.G_FALSE,
8254: x_return_status => x_return_status,
8255: x_msg_count => x_msg_count,
8256: x_msg_data => x_msg_data,
8257: p_commit => OKC_API.G_FALSE,
8258: p_chr_id => p_from_chr_id,
8259: p_contract_number => l_new_contract_number,
8260: p_contract_number_modifier => NULL,
8261: p_to_template_yn => 'N',

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

8264: p_override_org => 'N',
8265: x_chr_id => x_chr_id
8266: );
8267:
8268: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
8269: RAISE OKC_API.G_EXCEPTION_ERROR;
8270: END IF;
8271:
8272: debug_message('New Chr ID: '||x_chr_id);

Line 8269: RAISE OKC_API.G_EXCEPTION_ERROR;

8265: x_chr_id => x_chr_id
8266: );
8267:
8268: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
8269: RAISE OKC_API.G_EXCEPTION_ERROR;
8270: END IF;
8271:
8272: debug_message('New Chr ID: '||x_chr_id);
8273:

Line 8284: p_init_msg_list => OKC_API.G_FALSE,

8280: END LOOP;
8281:
8282: okl_copy_asset_pub.copy_all_lines(
8283: p_api_version => 1.0,
8284: p_init_msg_list => OKC_API.G_FALSE,
8285: x_return_status => x_return_status,
8286: x_msg_count => x_msg_count,
8287: x_msg_data => x_msg_data,
8288: P_from_cle_id_tbl => l_from_cle_id_tbl,

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

8293: p_renew_ref_yn => 'N',
8294: p_trans_type => 'CRB',
8295: x_cle_id_tbl => x_cle_id_tbl
8296: );
8297: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
8298: RAISE OKC_API.G_EXCEPTION_ERROR;
8299: END IF;
8300:
8301: */

Line 8298: RAISE OKC_API.G_EXCEPTION_ERROR;

8294: p_trans_type => 'CRB',
8295: x_cle_id_tbl => x_cle_id_tbl
8296: );
8297: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
8298: RAISE OKC_API.G_EXCEPTION_ERROR;
8299: END IF;
8300:
8301: */
8302: --

Line 8313: p_init_msg_list => OKC_API.G_FALSE,

8309: l_chrv_rec.orig_system_source_code := 'OKL_REBOOK';
8310:
8311: Okl_Okc_Migration_Pvt.update_contract_header(
8312: p_api_version => 1.0,
8313: p_init_msg_list => OKC_API.G_FALSE,
8314: x_return_status => x_return_status,
8315: x_msg_count => x_msg_count,
8316: x_msg_data => x_msg_data,
8317: p_restricted_update => OKC_API.G_FALSE,

Line 8317: p_restricted_update => OKC_API.G_FALSE,

8313: p_init_msg_list => OKC_API.G_FALSE,
8314: x_return_status => x_return_status,
8315: x_msg_count => x_msg_count,
8316: x_msg_data => x_msg_data,
8317: p_restricted_update => OKC_API.G_FALSE,
8318: p_chrv_rec => l_chrv_rec,
8319: x_chrv_rec => x_chrv_rec
8320: );
8321: /* dedey - 27-AUG-2002

Line 8332: p_restricted_update => OKC_API.G_FALSE,

8328: p_init_msg_list => p_init_msg_list,
8329: x_return_status => x_return_status,
8330: x_msg_count => x_msg_count,
8331: x_msg_data => x_msg_data,
8332: p_restricted_update => OKC_API.G_FALSE,
8333: p_chrv_rec => l_chrv_rec,
8334: p_khrv_rec => l_khrv_rec,
8335: x_chrv_rec => x_chrv_rec,
8336: x_khrv_rec => x_khrv_rec

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

8336: x_khrv_rec => x_khrv_rec
8337: );
8338: */
8339:
8340: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
8341: RAISE OKC_API.G_EXCEPTION_ERROR;
8342: END IF;
8343:
8344: x_rebook_chr_id := x_chr_id;

Line 8341: RAISE OKC_API.G_EXCEPTION_ERROR;

8337: );
8338: */
8339:
8340: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
8341: RAISE OKC_API.G_EXCEPTION_ERROR;
8342: END IF;
8343:
8344: x_rebook_chr_id := x_chr_id;
8345:

Line 8351: WHEN OKC_API.G_EXCEPTION_ERROR THEN

8347: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
8348: x_msg_data => x_msg_data);
8349:
8350: EXCEPTION
8351: WHEN OKC_API.G_EXCEPTION_ERROR THEN
8352: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
8353: p_api_name => l_api_name,
8354: p_pkg_name => G_PKG_NAME,
8355: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 8352: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

8348: x_msg_data => x_msg_data);
8349:
8350: EXCEPTION
8351: WHEN OKC_API.G_EXCEPTION_ERROR THEN
8352: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
8353: p_api_name => l_api_name,
8354: p_pkg_name => G_PKG_NAME,
8355: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
8356: x_msg_count => x_msg_count,

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

8351: WHEN OKC_API.G_EXCEPTION_ERROR THEN
8352: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
8353: p_api_name => l_api_name,
8354: p_pkg_name => G_PKG_NAME,
8355: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
8356: x_msg_count => x_msg_count,
8357: x_msg_data => x_msg_data,
8358: p_api_type => G_API_TYPE);
8359:

Line 8360: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

8356: x_msg_count => x_msg_count,
8357: x_msg_data => x_msg_data,
8358: p_api_type => G_API_TYPE);
8359:
8360: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8361: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
8362: p_api_name => l_api_name,
8363: p_pkg_name => G_PKG_NAME,
8364: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 8361: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

8357: x_msg_data => x_msg_data,
8358: p_api_type => G_API_TYPE);
8359:
8360: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8361: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
8362: p_api_name => l_api_name,
8363: p_pkg_name => G_PKG_NAME,
8364: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
8365: x_msg_count => x_msg_count,

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

8360: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8361: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
8362: p_api_name => l_api_name,
8363: p_pkg_name => G_PKG_NAME,
8364: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
8365: x_msg_count => x_msg_count,
8366: x_msg_data => x_msg_data,
8367: p_api_type => G_API_TYPE);
8368:

Line 8370: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

8366: x_msg_data => x_msg_data,
8367: p_api_type => G_API_TYPE);
8368:
8369: WHEN OTHERS THEN
8370: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
8371: p_api_name => l_api_name,
8372: p_pkg_name => G_PKG_NAME,
8373: p_exc_name => 'OTHERS',
8374: x_msg_count => x_msg_count,

Line 8393: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

8389: -- Called By:
8390: ------------------------------------------------------------------------------
8391: PROCEDURE link_streams(
8392: p_api_version IN NUMBER,
8393: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
8394: x_return_status OUT NOCOPY VARCHAR2,
8395: x_msg_count OUT NOCOPY NUMBER,
8396: x_msg_data OUT NOCOPY VARCHAR2,
8397: p_khr_id IN NUMBER

Line 8706: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

8702: -- Called By:
8703: ------------------------------------------------------------------------------
8704: PROCEDURE create_pth_disb_adjustment(
8705: p_api_version IN NUMBER,
8706: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
8707: x_return_status OUT NOCOPY VARCHAR2,
8708: x_msg_count OUT NOCOPY NUMBER,
8709: x_msg_data OUT NOCOPY VARCHAR2,
8710: p_rbk_khr_id IN NUMBER,

Line 9063: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

9059: -- Called By:
9060: ------------------------------------------------------------------------------
9061: PROCEDURE create_billing_adjustment(
9062: p_api_version IN NUMBER,
9063: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
9064: x_return_status OUT NOCOPY VARCHAR2,
9065: x_msg_count OUT NOCOPY NUMBER,
9066: x_msg_data OUT NOCOPY VARCHAR2,
9067: p_rbk_khr_id IN NUMBER,

Line 9459: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

9455: -- Called By:
9456: ------------------------------------------------------------------------------
9457: PROCEDURE create_accrual_adjustment(
9458: p_api_version IN NUMBER,
9459: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
9460: x_return_status OUT NOCOPY VARCHAR2,
9461: x_msg_count OUT NOCOPY NUMBER,
9462: x_msg_data OUT NOCOPY VARCHAR2,
9463: p_rbk_khr_id IN NUMBER,

Line 9804: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

9800: -- Added new input parameters p_trx_tbl_code and p_trx_type for Bug# 6344223
9801: ------------------------------------------------------------------------------
9802: PROCEDURE calc_accrual_adjustment(
9803: p_api_version IN NUMBER,
9804: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
9805: x_return_status OUT NOCOPY VARCHAR2,
9806: x_msg_count OUT NOCOPY NUMBER,
9807: x_msg_data OUT NOCOPY VARCHAR2,
9808: p_rbk_khr_id IN NUMBER,

Line 10216: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

10212: -- Called By:
10213: ------------------------------------------------------------------------------
10214: PROCEDURE create_inv_disb_adjustment(
10215: p_api_version IN NUMBER,
10216: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
10217: x_return_status OUT NOCOPY VARCHAR2,
10218: x_msg_count OUT NOCOPY NUMBER,
10219: x_msg_data OUT NOCOPY VARCHAR2,
10220: p_orig_khr_id IN NUMBER

Line 10694: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

10690: -- streams generated during rebook with trx_id and link_hist_stream_id
10691: ------------------------------------------------------------------------------
10692: PROCEDURE link_inv_accrual_streams(
10693: p_api_version IN NUMBER,
10694: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
10695: x_return_status OUT NOCOPY VARCHAR2,
10696: x_msg_count OUT NOCOPY NUMBER,
10697: x_msg_data OUT NOCOPY VARCHAR2,
10698: p_khr_id IN NUMBER

Line 11149: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

11145: -- Added new input parameters p_trx_tbl_code and p_trx_type for Bug# 6344223
11146: ------------------------------------------------------------------------------
11147: PROCEDURE calc_inv_acc_adjustment(
11148: p_api_version IN NUMBER,
11149: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
11150: x_return_status OUT NOCOPY VARCHAR2,
11151: x_msg_count OUT NOCOPY NUMBER,
11152: x_msg_data OUT NOCOPY VARCHAR2,
11153: p_orig_khr_id IN NUMBER,