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_TERMINATE_INV_AGMT_PVT dependencies on OKL_API

Line 39: lx_error_rec OKL_API.error_rec_type;

35: PROCEDURE fnd_output (
36: p_ia_rec IN ia_rec_type,
37: p_control_flag IN VARCHAR2 ) IS
38:
39: lx_error_rec OKL_API.error_rec_type;
40: l_msg_idx INTEGER := G_FIRST;
41:
42: -- SECHAWLA l_msg_tbl msg_tbl_type;
43: l_tbl_count INTEGER := 0; --Bug 7007686

Line 112: OKL_API.set_message(

108: EXCEPTION
109:
110: WHEN OTHERS THEN
111: -- Set the oracle error message
112: OKL_API.set_message(
113: p_app_name => G_APP_NAME_1,
114: p_msg_name => G_UNEXPECTED_ERROR,
115: p_token1 => G_SQLCODE_TOKEN,
116: p_token1_value => SQLCODE,

Line 425: OKL_API.set_message(

421: EXCEPTION
422:
423: WHEN OTHERS THEN
424: -- Set the oracle error message
425: OKL_API.set_message(
426: p_app_name => G_APP_NAME_1,
427: p_msg_name => G_UNEXPECTED_ERROR,
428: p_token1 => G_SQLCODE_TOKEN,
429: p_token1_value => SQLCODE,

Line 508: OKL_API.set_message(

504: EXCEPTION
505:
506: WHEN OTHERS THEN
507: -- Set the oracle error message
508: OKL_API.set_message(
509: p_app_name => G_APP_NAME_1,
510: p_msg_name => G_UNEXPECTED_ERROR,
511: p_token1 => G_SQLCODE_TOKEN,
512: p_token1_value => SQLCODE,

Line 607: OKL_API.set_message(

603:
604: IF l_poc_id = 1 THEN
605: -- Pool contents exist after the Investor Agreement AGREEMENT_NUMBER
606: -- end date END_DATE.
607: OKL_API.set_message(
608: p_app_name => G_APP_NAME,
609: p_msg_name => 'OKL_AM_INV_POC_DATE',
610: p_token1 => 'AGREEMENT_NUMBER',
611: p_token1_value => p_ia_rec.contract_number,

Line 630: OKL_API.set_message(

626:
627: IF l_sel_id = 1 THEN
628: -- Streams associated with Investor Agreement AGREEMENT_NUMBER has
629: -- due date after end date END_DATE.
630: OKL_API.set_message(
631: p_app_name => G_APP_NAME,
632: p_msg_name => 'OKL_AM_INV_SEL_DATE',
633: p_token1 => 'AGREEMENT_NUMBER',
634: p_token1_value => p_ia_rec.contract_number,

Line 676: OKL_API.set_message(

672: WHEN OTHERS THEN
673: ROLLBACK TO validate_ia_pool_trx;
674:
675: -- Set the oracle error message
676: OKL_API.set_message(
677: p_app_name => G_APP_NAME_1,
678: p_msg_name => G_UNEXPECTED_ERROR,
679: p_token1 => G_SQLCODE_TOKEN,
680: p_token1_value => SQLCODE,

Line 762: OKL_API.set_message(

758: IF l_strm_id = 1 THEN
759:
760: -- Streams associated with Investor Agreement AGREEMENT_NUMBER have
761: -- not been billed.
762: OKL_API.set_message(
763: p_app_name => G_APP_NAME,
764: p_msg_name => 'OKL_AM_INV_UNBILL_STRM',
765: p_token1 => 'AGREEMENT_NUMBER',
766: p_token1_value => p_ia_rec.contract_number);

Line 810: OKL_API.set_message(

806:
807: ROLLBACK TO check_unbilled_trx;
808:
809: -- Set the oracle error message
810: OKL_API.set_message(
811: p_app_name => G_APP_NAME_1,
812: p_msg_name => G_UNEXPECTED_ERROR,
813: p_token1 => G_SQLCODE_TOKEN,
814: p_token1_value => SQLCODE,

Line 1025: OKL_API.set_message(

1021: /* sosharma end changes */
1022: -- If undisbursed stream elements then error
1023: IF l_disb_id = 1 THEN
1024: --Pending disbursements exists for the investor agreement AGREEMENT_NUMBER.
1025: OKL_API.set_message(
1026: p_app_name => G_APP_NAME,
1027: p_msg_name => 'OKL_AM_INV_PENDING_DISB',
1028: p_token1 => 'AGREEMENT_NUMBER',
1029: p_token1_value => p_ia_rec.contract_number);

Line 1042: OKL_API.set_message(

1038:
1039: -- If undisbursed stream elements then error
1040: IF l_disb_id = 1 THEN
1041: --Pending disbursements exists for the investor agreement AGREEMENT_NUMBER.
1042: OKL_API.set_message(
1043: p_app_name => G_APP_NAME,
1044: p_msg_name => 'OKL_AM_INV_PENDING_DISB',
1045: p_token1 => 'AGREEMENT_NUMBER',
1046: p_token1_value => p_ia_rec.contract_number);

Line 1089: OKL_API.set_message(

1085:
1086: ROLLBACK TO check_pending_disb_trx;
1087:
1088: -- Set the oracle error message
1089: OKL_API.set_message(
1090: p_app_name => G_APP_NAME_1,
1091: p_msg_name => G_UNEXPECTED_ERROR,
1092: p_token1 => G_SQLCODE_TOKEN,
1093: p_token1_value => SQLCODE,

Line 1188: OKL_API.set_message(

1184:
1185: WHEN OTHERS THEN
1186:
1187: -- Set the oracle error message
1188: OKL_API.set_message(
1189: p_app_name => G_APP_NAME_1,
1190: p_msg_name => G_UNEXPECTED_ERROR,
1191: p_token1 => G_SQLCODE_TOKEN,
1192: p_token1_value => SQLCODE,

Line 1322: OKL_API.set_message(

1318: IF l_ia_rec.id IS NULL
1319: OR l_ia_rec.contract_number IS NULL THEN
1320:
1321: -- Invalid Value
1322: OKL_API.set_message(
1323: p_app_name => G_APP_NAME_1,
1324: p_msg_name => G_INVALID_VALUE,
1325: p_token1 => G_COL_NAME_TOKEN,
1326: p_token1_value => 'id');

Line 1336: OKL_API.set_message(

1332: -- If not investor agreeement
1333: IF l_ia_rec.scs_code <> 'INVESTOR' THEN
1334:
1335: -- AGREEMENT_NUMBER is not a valid Investor Agreement.
1336: OKL_API.set_message(
1337: p_app_name => G_APP_NAME,
1338: p_msg_name => 'OKL_AM_INV_NOT_INV',
1339: p_token1 => 'AGREEMENT_NUMBER',
1340: p_token1_value => l_ia_rec.contract_number);

Line 1350: OKL_API.set_message(

1346: -- If not active
1347: IF l_ia_rec.sts_code <> 'ACTIVE' THEN
1348:
1349: -- Investor Agreement AGREEMENT_NUMBER is not in active status.
1350: OKL_API.set_message(
1351: p_app_name => G_APP_NAME,
1352: p_msg_name => 'OKL_AM_INV_NOT_ACTIVE',
1353: p_token1 => 'AGREEMENT_NUMBER',
1354: p_token1_value => l_ia_rec.contract_number);

Line 1364: OKL_API.set_message(

1360: -- If not end dated
1361: IF l_ia_rec.end_date IS NULL THEN
1362:
1363: -- End date is not available for Investor Agreement AGREEMENT_NUMBER.
1364: OKL_API.set_message(
1365: p_app_name => G_APP_NAME,
1366: p_msg_name => 'OKL_AM_INV_NOT_ENDED',
1367: p_token1 => 'AGREEMENT_NUMBER',
1368: p_token1_value => l_ia_rec.contract_number);

Line 1385: OKL_API.set_message(

1381: -- If TRN exists and was PROCESSED then error
1382: IF l_tsu_code = 'PROCESSED' THEN
1383: -- The transaction status and agreement status are mismatched for
1384: -- Investor Agreement AGREEMENT_NUMBER.
1385: OKL_API.set_message(
1386: p_app_name => G_APP_NAME,
1387: p_msg_name => 'OKL_AM_INV_PRS_TRN_EXIST',
1388: p_token1 => 'AGREEMENT_NUMBER',
1389: p_token1_value => l_ia_rec.contract_number);

Line 1406: OKL_API.set_message(

1402: END LOOP;
1403: IF l_trans_pool_id is not null THEN
1404:
1405: -- Pending pool contents and transactions are present
1406: OKL_API.set_message(
1407: p_app_name => G_APP_NAME,
1408: p_msg_name => 'OKL_AM_INV_PEND_REQ_EXIST',
1409: p_token1 => 'AGREEMENT_NUMBER',
1410: p_token1_value => l_ia_rec.contract_number);

Line 1482: OKL_API.set_message(

1478: END LOOP;
1479:
1480: -- Set the success message
1481: -- Investor Agreement AGREEMENT_NUMBER is valid.
1482: OKL_API.set_message(
1483: p_app_name => G_APP_NAME,
1484: p_msg_name => 'OKL_AM_INV_VALIDATE_SUCC',
1485: p_token1 => 'AGREEMENT_NUMBER',
1486: p_token1_value => l_ia_rec.contract_number);

Line 1530: OKL_API.set_message(

1526:
1527: WHEN OTHERS THEN
1528: ROLLBACK TO validate_ia_trx;
1529: -- Set the oracle error message
1530: OKL_API.set_message(
1531: p_app_name => G_APP_NAME_1,
1532: p_msg_name => G_UNEXPECTED_ERROR,
1533: p_token1 => G_SQLCODE_TOKEN,
1534: p_token1_value => SQLCODE,

Line 1673: OKL_API.set_message(

1669:
1670: IF l_return_status <> G_RET_STS_SUCCESS THEN
1671:
1672: -- Message: Unable to find a transaction type for the transaction TRY_NAME -- Seeded
1673: OKL_API.set_message(
1674: p_app_name => G_APP_NAME,
1675: p_msg_name => 'OKL_AM_NO_TRX_TYPE_FOUND',
1676: p_token1 => 'TRY_NAME',
1677: p_token1_value => l_trans_meaning);

Line 1720: OKL_API.set_message(

1716: -- Set msg if error
1717: IF l_return_status <> G_RET_STS_SUCCESS THEN
1718: -- Error occured while creating termination transaction for the
1719: -- Investor Agreement AGREEMENT_NUMBER..
1720: OKL_API.set_message(
1721: p_app_name => G_APP_NAME,
1722: p_msg_name => 'OKL_AM_INV_TRN_CREATE_ERR');
1723: END IF;
1724:

Line 1774: OKL_API.set_message(

1770: WHEN OTHERS THEN
1771: ROLLBACK TO pop_insert_trn_trx;
1772:
1773: -- Set the oracle error message
1774: OKL_API.set_message(
1775: p_app_name => G_APP_NAME_1,
1776: p_msg_name => G_UNEXPECTED_ERROR,
1777: p_token1 => G_SQLCODE_TOKEN,
1778: p_token1_value => SQLCODE,

Line 1844: OKL_API.set_message(

1840:
1841: IF l_return_status <> G_RET_STS_SUCCESS THEN
1842: -- Error occured during reversal of loss provisions for Investor
1843: -- Agreement AGREEMENT_NUMBER.
1844: OKL_API.set_message(
1845: p_app_name => G_APP_NAME,
1846: p_msg_name => 'OKL_AM_INV_REVERSE_ERR',
1847: p_token1 => 'AGREEMENT_NUMBER',
1848: p_token1_value => p_ia_rec.contract_number);

Line 1860: OKL_API.set_message(

1856: END IF;
1857:
1858: -- Set the success message
1859: -- Loss provisions have been reversed for Investor Agreement AGREEMENT_NUMBER.
1860: OKL_API.set_message(
1861: p_app_name => G_APP_NAME,
1862: p_msg_name => 'OKL_AM_INV_REVERSE_SUCC',
1863: p_token1 => 'AGREEMENT_NUMBER',
1864: p_token1_value => p_ia_rec.contract_number);

Line 1901: OKL_API.set_message(

1897: WHEN OTHERS THEN
1898: ROLLBACK TO reverse_loss_trx;
1899:
1900: -- Set the oracle error message
1901: OKL_API.set_message(
1902: p_app_name => G_APP_NAME_1,
1903: p_msg_name => G_UNEXPECTED_ERROR,
1904: p_token1 => G_SQLCODE_TOKEN,
1905: p_token1_value => SQLCODE,

Line 2010: OKL_API.set_message(

2006: WHEN OTHERS THEN
2007: ROLLBACK TO accounting_entries_trx;
2008:
2009: -- Set the oracle error message
2010: OKL_API.set_message(
2011: p_app_name => G_APP_NAME_1,
2012: p_msg_name => G_UNEXPECTED_ERROR,
2013: p_token1 => G_SQLCODE_TOKEN,
2014: p_token1_value => SQLCODE,

Line 2105: OKL_API.set_message(

2101: x_klev_rec => lx_klev_rec);
2102:
2103: IF l_return_status <> G_RET_STS_SUCCESS THEN
2104: -- Error occured during update of Investor Agreement AGREEMENT_NUMBER lines.
2105: OKL_API.set_message(
2106: p_app_name => G_APP_NAME,
2107: p_msg_name => 'OKL_AM_INV_TRMT_LINE_ERR',
2108: p_token1 => 'AGREEMENT_NUMBER',
2109: p_token1_value => p_ia_rec.contract_number);

Line 2149: OKL_API.set_message(

2145: x_khrv_rec => lx_khrv_rec);
2146:
2147: IF l_return_status <> G_RET_STS_SUCCESS THEN
2148: -- Error occured during update of investor agreement AGREEMENT_NUMBER.
2149: OKL_API.set_message(
2150: p_app_name => G_APP_NAME,
2151: p_msg_name => 'OKL_AM_INV_TRMT_ERR',
2152: p_token1 => 'AGREEMENT_NUMBER',
2153: p_token1_value => p_ia_rec.contract_number);

Line 2198: OKL_API.set_message(

2194: WHEN OTHERS THEN
2195: ROLLBACK TO update_ia_and_lines_trx;
2196:
2197: -- Set the oracle error message
2198: OKL_API.set_message(
2199: p_app_name => G_APP_NAME_1,
2200: p_msg_name => G_UNEXPECTED_ERROR,
2201: p_token1 => G_SQLCODE_TOKEN,
2202: p_token1_value => SQLCODE,

Line 2333: OKL_API.set_message(

2329:
2330: IF l_return_status <> G_RET_STS_SUCCESS THEN
2331: -- Error occurred during update of pool for the
2332: -- Investor Agreement AGREEMENT_NUMBER.
2333: OKL_API.set_message(
2334: p_app_name => G_APP_NAME,
2335: p_msg_name => 'OKL_AM_INV_UPD_POOL_ERR',
2336: p_token1 => 'AGREEMENT_NUMBER',
2337: p_token1_value => p_ia_rec.contract_number);

Line 2378: OKL_API.set_message(

2374:
2375: IF l_return_status <> G_RET_STS_SUCCESS THEN
2376: -- Error occurred during creation of pool transaction for
2377: -- the Investor Agreement AGREEMENT_NUMBER.
2378: OKL_API.set_message(
2379: p_app_name => G_APP_NAME,
2380: p_msg_name => 'OKL_AM_INV_POOL_TRN_CRT_ERR',
2381: p_token1 => 'AGREEMENT_NUMBER',
2382: p_token1_value => p_ia_rec.contract_number);

Line 2417: OKL_API.set_message(

2413:
2414: IF l_return_status <> G_RET_STS_SUCCESS THEN
2415: -- Error occurred during update of pool contents for
2416: -- the Investor Agreement AGREEMENT_NUMBER.
2417: OKL_API.set_message(
2418: p_app_name => G_APP_NAME,
2419: p_msg_name => 'OKL_AM_INV_UPD_POC_IA_ERR',
2420: p_token1 => 'AGREEMENT_NUMBER',
2421: p_token1_value => p_ia_rec.contract_number);

Line 2447: p_init_msg_list => OKL_API.G_FALSE,

2443: l_khrv_rec.securitized_code := 'N';
2444:
2445: OKL_CONTRACT_PUB.update_contract_header(
2446: p_api_version => l_api_version,
2447: p_init_msg_list => OKL_API.G_FALSE,
2448: x_return_status => l_return_status,
2449: x_msg_count => l_msg_count,
2450: x_msg_data => l_msg_data,
2451: p_chrv_rec => l_chrv_rec,

Line 2459: OKL_API.set_message(

2455:
2456: IF l_return_status <> G_RET_STS_SUCCESS THEN
2457: -- Error occurred during update of pool for the
2458: -- Investor Agreement AGREEMENT_NUMBER.
2459: OKL_API.set_message(
2460: p_app_name => G_APP_NAME,
2461: p_msg_name => 'OKL_AM_INV_UPD_POOL_ERR',
2462: p_token1 => 'AGREEMENT_NUMBER',
2463: p_token1_value => p_ia_rec.contract_number);

Line 2512: OKL_API.set_message(

2508: WHEN OTHERS THEN
2509: ROLLBACK TO update_pools_trx;
2510:
2511: -- Set the oracle error message
2512: OKL_API.set_message(
2513: p_app_name => G_APP_NAME_1,
2514: p_msg_name => G_UNEXPECTED_ERROR,
2515: p_token1 => G_SQLCODE_TOKEN,
2516: p_token1_value => SQLCODE,

Line 2598: OKL_API.set_message(

2594: END IF;
2595:
2596: -- Set the success message
2597: -- Investor agreement AGREEMENT_NUMBER expired successfully.
2598: OKL_API.set_message(
2599: p_app_name => G_APP_NAME,
2600: p_msg_name => 'OKL_AM_INV_TRMNT_SUCC',
2601: p_token1 => 'AGREEMENT_NUMBER',
2602: p_token1_value => p_ia_rec.contract_number);

Line 2648: OKL_API.set_message(

2644: WHEN OTHERS THEN
2645: ROLLBACK TO update_ia_trx;
2646:
2647: -- Set the oracle error message
2648: OKL_API.set_message(
2649: p_app_name => G_APP_NAME_1,
2650: p_msg_name => G_UNEXPECTED_ERROR,
2651: p_token1 => G_SQLCODE_TOKEN,
2652: p_token1_value => SQLCODE,

Line 2716: OKL_API.set_message(

2712: -- Set msg if error
2713: IF l_return_status <> G_RET_STS_SUCCESS THEN
2714: -- Error occured during update of termination transaction
2715: -- for Investor Agreement AGREEMENT_NUMBER.
2716: OKL_API.set_message(
2717: p_app_name => G_APP_NAME,
2718: p_msg_name => 'OKL_AM_INV_TRN_UPD_IA_ERR',
2719: p_token1 => 'AGREEMENT_NUMBER',
2720: p_token1_value => p_ia_rec.contract_number);

Line 2765: OKL_API.set_message(

2761: WHEN OTHERS THEN
2762: ROLLBACK TO update_transaction_trx;
2763:
2764: -- Set the oracle error message
2765: OKL_API.set_message(
2766: p_app_name => G_APP_NAME_1,
2767: p_msg_name => G_UNEXPECTED_ERROR,
2768: p_token1 => G_SQLCODE_TOKEN,
2769: p_token1_value => SQLCODE,

Line 2825: lx_error_rec OKL_API.error_rec_type;

2821: l_status VARCHAR2(300);
2822: l_control_flag VARCHAR2(300);
2823: l_valid_gl_date DATE;
2824:
2825: lx_error_rec OKL_API.error_rec_type;
2826: l_msg_idx INTEGER := G_FIRST;
2827: l_msg_tbl msg_tbl_type;
2828: l_api_name VARCHAR2(30) := 'terminate_investor_ag';
2829: l_api_version CONSTANT NUMBER := G_API_VERSION;

Line 2849: l_return_status := OKL_API.start_activity(

2845: -- *************
2846: -- Check API version, initialize message list and create savepoint
2847: -- *************
2848:
2849: l_return_status := OKL_API.start_activity(
2850: p_api_name => l_api_name,
2851: p_pkg_name => G_PKG_NAME,
2852: p_init_msg_list => p_init_msg_list,
2853: l_api_version => l_api_version,

Line 3035: OKL_API.end_activity (x_msg_count, x_msg_data);

3031:
3032: END IF;
3033:
3034: -- End Activity
3035: OKL_API.end_activity (x_msg_count, x_msg_data);
3036:
3037: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3038: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3039: 'OKL_AM_TERMINATE_INV_AGMT_PVT.terminate_investor_agreement.',

Line 3077: x_return_status := OKL_API.handle_exceptions(

3073: p_ia_rec => l_ia_rec,
3074: p_control_flag => 'ERROR');
3075: END IF;
3076:
3077: x_return_status := OKL_API.handle_exceptions(
3078: p_api_name => l_api_name,
3079: p_pkg_name => G_PKG_NAME,
3080: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3081: x_msg_count => x_msg_count,

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

3076:
3077: x_return_status := OKL_API.handle_exceptions(
3078: p_api_name => l_api_name,
3079: p_pkg_name => G_PKG_NAME,
3080: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3081: x_msg_count => x_msg_count,
3082: x_msg_data => x_msg_data,
3083: p_api_type => '_PVT');
3084:

Line 3100: x_return_status := OKL_API.handle_exceptions(

3096: p_ia_rec => l_ia_rec,
3097: p_control_flag => 'ERROR');
3098: END IF;
3099:
3100: x_return_status := OKL_API.handle_exceptions(
3101: p_api_name => l_api_name,
3102: p_pkg_name => G_PKG_NAME,
3103: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3104: x_msg_count => x_msg_count,

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

3099:
3100: x_return_status := OKL_API.handle_exceptions(
3101: p_api_name => l_api_name,
3102: p_pkg_name => G_PKG_NAME,
3103: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3104: x_msg_count => x_msg_count,
3105: x_msg_data => x_msg_data,
3106: p_api_type => '_PVT');
3107:

Line 3123: x_return_status := OKL_API.handle_exceptions(

3119: p_ia_rec => l_ia_rec,
3120: p_control_flag => 'ERROR');
3121: END IF;
3122:
3123: x_return_status := OKL_API.handle_exceptions(
3124: p_api_name => l_api_name,
3125: p_pkg_name => G_PKG_NAME,
3126: p_exc_name => 'OTHERS',
3127: x_msg_count => x_msg_count,

Line 3191: OKL_API.init_msg_list('T');

3187:
3188: BEGIN
3189:
3190: -- Initialize message list
3191: OKL_API.init_msg_list('T');
3192:
3193: SELECT SYSDATE INTO l_sys_date FROM DUAL;
3194:
3195: IF p_date IS NULL THEN

Line 3258: OKL_API.set_message(

3254: EXCEPTION
3255:
3256: WHEN OTHERS THEN
3257: -- Set the oracle error message
3258: OKL_API.set_message(
3259: p_app_name => G_APP_NAME_1,
3260: p_msg_name => G_UNEXPECTED_ERROR,
3261: p_token1 => G_SQLCODE_TOKEN,
3262: p_token1_value => SQLCODE,