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

Line 252: 'OKC_API.G_RET_STS_ERROR',

248: x_return_status := OKL_API.HANDLE_EXCEPTIONS
249: (
250: 'create_inv_khr_obligation',
251: G_PKG_NAME,
252: 'OKC_API.G_RET_STS_ERROR',
253: x_msg_count,
254: x_msg_data,
255: '_PVT'
256: );

Line 276: 'OKC_API.G_RET_STS_UNEXP_ERROR',

272: x_return_status := OKL_API.HANDLE_EXCEPTIONS
273: (
274: 'create_inv_khr_obligation',
275: G_PKG_NAME,
276: 'OKC_API.G_RET_STS_UNEXP_ERROR',
277: x_msg_count,
278: x_msg_data,
279: '_PVT'
280: );

Line 548: WHEN OKC_API.G_EXCEPTION_ERROR THEN

544: , 'END-');
545: END IF;
546:
547: EXCEPTION
548: WHEN OKC_API.G_EXCEPTION_ERROR THEN
549:
550: IF get_disb_streams_csr%ISOPEN THEN
551: CLOSE get_disb_streams_csr;
552: END IF;

Line 568: x_return_status := OKC_API.HANDLE_EXCEPTIONS

564: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION
565: ,'OKL_AM_SECURITIZATION_PVT.do_disb_adjustments'
566: , 'Handled exception occured');
567: END IF;
568: x_return_status := OKC_API.HANDLE_EXCEPTIONS
569: (
570: l_api_name,
571: G_PKG_NAME,
572: 'OKC_API.G_RET_STS_ERROR',

Line 572: 'OKC_API.G_RET_STS_ERROR',

568: x_return_status := OKC_API.HANDLE_EXCEPTIONS
569: (
570: l_api_name,
571: G_PKG_NAME,
572: 'OKC_API.G_RET_STS_ERROR',
573: x_msg_count,
574: x_msg_data,
575: '_PVT'
576: );

Line 578: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

574: x_msg_data,
575: '_PVT'
576: );
577:
578: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
579:
580: IF get_disb_streams_csr%ISOPEN THEN
581: CLOSE get_disb_streams_csr;
582: END IF;

Line 598: x_return_status := OKC_API.HANDLE_EXCEPTIONS

594: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION
595: ,'OKL_AM_SECURITIZATION_PVT.do_disb_adjustments'
596: , 'Unexpected exception occured');
597: END IF;
598: x_return_status := OKC_API.HANDLE_EXCEPTIONS
599: (
600: l_api_name,
601: G_PKG_NAME,
602: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 602: 'OKC_API.G_RET_STS_UNEXP_ERROR',

598: x_return_status := OKC_API.HANDLE_EXCEPTIONS
599: (
600: l_api_name,
601: G_PKG_NAME,
602: 'OKC_API.G_RET_STS_UNEXP_ERROR',
603: x_msg_count,
604: x_msg_data,
605: '_PVT'
606: );

Line 883: WHEN OKC_API.G_EXCEPTION_ERROR THEN

879: , 'END-');
880: END IF;
881:
882: EXCEPTION
883: WHEN OKC_API.G_EXCEPTION_ERROR THEN
884:
885: IF get_disb_streams_csr%ISOPEN THEN
886: CLOSE get_disb_streams_csr;
887: END IF;

Line 903: x_return_status := OKC_API.HANDLE_EXCEPTIONS

899: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION
900: ,'OKL_AM_SECURITIZATION_PVT.do_disb_adjustments_loan'
901: , 'Handled exception occured');
902: END IF;
903: x_return_status := OKC_API.HANDLE_EXCEPTIONS
904: (
905: l_api_name,
906: G_PKG_NAME,
907: 'OKC_API.G_RET_STS_ERROR',

Line 907: 'OKC_API.G_RET_STS_ERROR',

903: x_return_status := OKC_API.HANDLE_EXCEPTIONS
904: (
905: l_api_name,
906: G_PKG_NAME,
907: 'OKC_API.G_RET_STS_ERROR',
908: x_msg_count,
909: x_msg_data,
910: '_PVT'
911: );

Line 913: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

909: x_msg_data,
910: '_PVT'
911: );
912:
913: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
914:
915: IF get_disb_streams_csr%ISOPEN THEN
916: CLOSE get_disb_streams_csr;
917: END IF;

Line 933: x_return_status := OKC_API.HANDLE_EXCEPTIONS

929: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION
930: ,'OKL_AM_SECURITIZATION_PVT.do_disb_adjustments_loan'
931: , 'Unexpected exception occured');
932: END IF;
933: x_return_status := OKC_API.HANDLE_EXCEPTIONS
934: (
935: l_api_name,
936: G_PKG_NAME,
937: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 937: 'OKC_API.G_RET_STS_UNEXP_ERROR',

933: x_return_status := OKC_API.HANDLE_EXCEPTIONS
934: (
935: l_api_name,
936: G_PKG_NAME,
937: 'OKC_API.G_RET_STS_UNEXP_ERROR',
938: x_msg_count,
939: x_msg_data,
940: '_PVT'
941: );

Line 1162: l_is_securitized VARCHAR2(1) := OKC_API.G_FALSE;

1158: l_disb_type VARCHAR2(20);
1159: l_kle_id NUMBER;
1160: l_khr_id NUMBER;
1161: l_loop_counter NUMBER := 0;
1162: l_is_securitized VARCHAR2(1) := OKC_API.G_FALSE;
1163:
1164: lp_stmv_tbl OKL_STREAMS_PUB.stmv_tbl_type;
1165: lx_stmv_tbl OKL_STREAMS_PUB.stmv_tbl_type;
1166:

Line 1444: l_is_securitized := OKC_API.G_FALSE; -- not securitized

1440: ,'returning from OKL_SECURITIZATION_PVT.check_khr_securitized'
1441: ||', status is '||l_return_status);
1442: END IF;
1443: ELSE
1444: l_is_securitized := OKC_API.G_FALSE; -- not securitized
1445: END IF;
1446:
1447: IF l_partial = 'Y' THEN
1448: -- modifiy call origin

Line 1578: IF l_is_securitized = OKC_API.G_TRUE THEN

1574: END IF;
1575: END IF;
1576:
1577: -- Do disbursement adjustments if contract is securitized as of termination date
1578: IF l_is_securitized = OKC_API.G_TRUE THEN
1579: do_disb_adjustments (
1580: p_api_version => p_api_version,
1581: p_init_msg_list => OKL_API.G_FALSE,
1582: x_msg_count => x_msg_count,

Line 1604: IF l_is_securitized = OKC_API.G_TRUE THEN -- this contract is securitized.

1600: END IF;
1601: END IF; -- end of check for l_inv_agmt_chr_id_tbl.COUNT > 0
1602: -- Bug# 7009075 - Moved - End
1603:
1604: IF l_is_securitized = OKC_API.G_TRUE THEN -- this contract is securitized.
1605:
1606: IF l_disb_type = 'RESIDUAL' THEN
1607:
1608: -- Disburse Investor Residual Stream

Line 1653: p_init_msg_list => OKC_API.G_FALSE,

1649:
1650: -- historize rv streams
1651: OKL_STREAMS_PUB.update_streams(
1652: p_api_version => p_api_version,
1653: p_init_msg_list => OKC_API.G_FALSE,
1654: x_return_status => l_return_status,
1655: x_msg_count => x_msg_count,
1656: x_msg_data => x_msg_data,
1657: p_stmv_tbl => lp_stmv_tbl,

Line 1797: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1793: , 'End (-)');
1794: END IF;
1795:
1796: EXCEPTION
1797: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1798:
1799: IF get_khr_id_csr%ISOPEN THEN
1800: CLOSE get_khr_id_csr;
1801: END IF;

Line 1821: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1817: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION
1818: ,'OKL_AM_SECURITIZATION_PVT.process_securitized_streams'
1819: , 'Handled exception occured');
1820: END IF;
1821: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1822: (
1823: l_api_name,
1824: G_PKG_NAME,
1825: 'OKC_API.G_RET_STS_ERROR',

Line 1825: 'OKC_API.G_RET_STS_ERROR',

1821: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1822: (
1823: l_api_name,
1824: G_PKG_NAME,
1825: 'OKC_API.G_RET_STS_ERROR',
1826: x_msg_count,
1827: x_msg_data,
1828: '_PVT'
1829: );

Line 1831: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1827: x_msg_data,
1828: '_PVT'
1829: );
1830:
1831: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1832:
1833: IF get_khr_id_csr%ISOPEN THEN
1834: CLOSE get_khr_id_csr;
1835: END IF;

Line 1855: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1851: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION
1852: ,'OKL_AM_SECURITIZATION_PVT.process_securitized_streams'
1853: , 'Unexpected exception occured');
1854: END IF;
1855: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1856: (
1857: l_api_name,
1858: G_PKG_NAME,
1859: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1859: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1855: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1856: (
1857: l_api_name,
1858: G_PKG_NAME,
1859: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1860: x_msg_count,
1861: x_msg_data,
1862: '_PVT'
1863: );

Line 2170: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2166:
2167: x_return_status := l_return_status;
2168:
2169: EXCEPTION
2170: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2171:
2172:
2173: IF get_next_trx_val_csr%ISOPEN THEN
2174: CLOSE get_next_trx_val_csr;

Line 2184: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2180: ,'OKL_AM_SECURITIZATION_PVT.disburse_investor_rent'
2181: , 'Handled exception occured');
2182: END IF;
2183:
2184: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2185: (
2186: 'proc_secure_streams',
2187: G_PKG_NAME,
2188: 'OKC_API.G_RET_STS_ERROR',

Line 2188: 'OKC_API.G_RET_STS_ERROR',

2184: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2185: (
2186: 'proc_secure_streams',
2187: G_PKG_NAME,
2188: 'OKC_API.G_RET_STS_ERROR',
2189: x_msg_count,
2190: x_msg_data,
2191: '_PVT'
2192: );

Line 2194: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2190: x_msg_data,
2191: '_PVT'
2192: );
2193:
2194: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2195:
2196:
2197: IF get_next_trx_val_csr%ISOPEN THEN
2198: CLOSE get_next_trx_val_csr;

Line 2208: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2204: ,'OKL_AM_SECURITIZATION_PVT.disburse_investor_rent'
2205: , 'Expected exception occured');
2206: END IF;
2207:
2208: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2209: (
2210: 'proc_secure_streams',
2211: G_PKG_NAME,
2212: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2212: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2208: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2209: (
2210: 'proc_secure_streams',
2211: G_PKG_NAME,
2212: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2213: x_msg_count,
2214: x_msg_data,
2215: '_PVT'
2216: );

Line 2505: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2501:
2502: x_return_status := l_return_status;
2503:
2504: EXCEPTION
2505: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2506:
2507:
2508: IF get_next_trx_val_csr%ISOPEN THEN
2509: CLOSE get_next_trx_val_csr;

Line 2519: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2515: ,'OKL_AM_SECURITIZATION_PVT.disburse_investor_loan_payment'
2516: , 'Handled exception occured');
2517: END IF;
2518:
2519: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2520: (
2521: 'proc_secure_streams',
2522: G_PKG_NAME,
2523: 'OKC_API.G_RET_STS_ERROR',

Line 2523: 'OKC_API.G_RET_STS_ERROR',

2519: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2520: (
2521: 'proc_secure_streams',
2522: G_PKG_NAME,
2523: 'OKC_API.G_RET_STS_ERROR',
2524: x_msg_count,
2525: x_msg_data,
2526: '_PVT'
2527: );

Line 2529: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2525: x_msg_data,
2526: '_PVT'
2527: );
2528:
2529: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2530:
2531:
2532: IF get_next_trx_val_csr%ISOPEN THEN
2533: CLOSE get_next_trx_val_csr;

Line 2543: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2539: ,'OKL_AM_SECURITIZATION_PVT.disburse_investor_loan_payment'
2540: , 'Expected exception occured');
2541: END IF;
2542:
2543: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2544: (
2545: 'proc_secure_streams',
2546: G_PKG_NAME,
2547: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2547: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2543: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2544: (
2545: 'proc_secure_streams',
2546: G_PKG_NAME,
2547: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2548: x_msg_count,
2549: x_msg_data,
2550: '_PVT'
2551: );

Line 2787: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2783:
2784: x_return_status := l_return_status;
2785:
2786: EXCEPTION
2787: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2788:
2789:
2790: IF get_next_trx_val_csr%ISOPEN THEN
2791: CLOSE get_next_trx_val_csr;

Line 2801: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2797: ,'OKL_AM_SECURITIZATION_PVT.disburse_investor_rv'
2798: , 'Handled exception occured');
2799: END IF;
2800:
2801: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2802: (
2803: 'proc_secure_streams',
2804: G_PKG_NAME,
2805: 'OKC_API.G_RET_STS_ERROR',

Line 2805: 'OKC_API.G_RET_STS_ERROR',

2801: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2802: (
2803: 'proc_secure_streams',
2804: G_PKG_NAME,
2805: 'OKC_API.G_RET_STS_ERROR',
2806: x_msg_count,
2807: x_msg_data,
2808: '_PVT'
2809: );

Line 2811: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2807: x_msg_data,
2808: '_PVT'
2809: );
2810:
2811: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2812:
2813:
2814: IF get_next_trx_val_csr%ISOPEN THEN
2815: CLOSE get_next_trx_val_csr;

Line 2825: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2821: ,'OKL_AM_SECURITIZATION_PVT.disburse_investor_rv'
2822: , 'Unexpected exception occured');
2823: END IF;
2824:
2825: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2826: (
2827: 'proc_secure_streams',
2828: G_PKG_NAME,
2829: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2829: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2825: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2826: (
2827: 'proc_secure_streams',
2828: G_PKG_NAME,
2829: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2830: x_msg_count,
2831: x_msg_data,
2832: '_PVT'
2833: );

Line 3043: WHEN OKC_API.G_EXCEPTION_ERROR THEN

3039:
3040: x_return_status := l_return_status;
3041:
3042: EXCEPTION
3043: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3044:
3045: --message logging
3046: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3047: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION

Line 3052: x_return_status := OKC_API.HANDLE_EXCEPTIONS

3048: ,'OKL_AM_SECURITIZATION_PVT.create_pool_transaction'
3049: , 'Handled exception occured');
3050: END IF;
3051:
3052: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3053: (
3054: 'proc_secure_streams',
3055: G_PKG_NAME,
3056: 'OKC_API.G_RET_STS_ERROR',

Line 3056: 'OKC_API.G_RET_STS_ERROR',

3052: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3053: (
3054: 'proc_secure_streams',
3055: G_PKG_NAME,
3056: 'OKC_API.G_RET_STS_ERROR',
3057: x_msg_count,
3058: x_msg_data,
3059: '_PVT'
3060: );

Line 3062: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3058: x_msg_data,
3059: '_PVT'
3060: );
3061:
3062: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3063:
3064: --message logging
3065: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3066: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION

Line 3071: x_return_status := OKC_API.HANDLE_EXCEPTIONS

3067: ,'OKL_AM_SECURITIZATION_PVT.create_pool_transaction'
3068: , 'Unexpected exception occured');
3069: END IF;
3070:
3071: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3072: (
3073: 'proc_secure_streams',
3074: G_PKG_NAME,
3075: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 3075: 'OKC_API.G_RET_STS_UNEXP_ERROR',

3071: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3072: (
3073: 'proc_secure_streams',
3074: G_PKG_NAME,
3075: 'OKC_API.G_RET_STS_UNEXP_ERROR',
3076: x_msg_count,
3077: x_msg_data,
3078: '_PVT'
3079: );