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:

Line 106: OKL_API.set_message(

102: EXCEPTION
103:
104: WHEN OTHERS THEN
105: -- Set the oracle error message
106: OKL_API.set_message(
107: p_app_name => G_APP_NAME_1,
108: p_msg_name => G_UNEXPECTED_ERROR,
109: p_token1 => G_SQLCODE_TOKEN,
110: p_token1_value => SQLCODE,

Line 403: OKL_API.set_message(

399: EXCEPTION
400:
401: WHEN OTHERS THEN
402: -- Set the oracle error message
403: OKL_API.set_message(
404: p_app_name => G_APP_NAME_1,
405: p_msg_name => G_UNEXPECTED_ERROR,
406: p_token1 => G_SQLCODE_TOKEN,
407: p_token1_value => SQLCODE,

Line 486: OKL_API.set_message(

482: EXCEPTION
483:
484: WHEN OTHERS THEN
485: -- Set the oracle error message
486: OKL_API.set_message(
487: p_app_name => G_APP_NAME_1,
488: p_msg_name => G_UNEXPECTED_ERROR,
489: p_token1 => G_SQLCODE_TOKEN,
490: p_token1_value => SQLCODE,

Line 585: OKL_API.set_message(

581:
582: IF l_poc_id = 1 THEN
583: -- Pool contents exist after the Investor Agreement AGREEMENT_NUMBER
584: -- end date END_DATE.
585: OKL_API.set_message(
586: p_app_name => G_APP_NAME,
587: p_msg_name => 'OKL_AM_INV_POC_DATE',
588: p_token1 => 'AGREEMENT_NUMBER',
589: p_token1_value => p_ia_rec.contract_number,

Line 608: OKL_API.set_message(

604:
605: IF l_sel_id = 1 THEN
606: -- Streams associated with Investor Agreement AGREEMENT_NUMBER has
607: -- due date after end date END_DATE.
608: OKL_API.set_message(
609: p_app_name => G_APP_NAME,
610: p_msg_name => 'OKL_AM_INV_SEL_DATE',
611: p_token1 => 'AGREEMENT_NUMBER',
612: p_token1_value => p_ia_rec.contract_number,

Line 654: OKL_API.set_message(

650: WHEN OTHERS THEN
651: ROLLBACK TO validate_ia_pool_trx;
652:
653: -- Set the oracle error message
654: OKL_API.set_message(
655: p_app_name => G_APP_NAME_1,
656: p_msg_name => G_UNEXPECTED_ERROR,
657: p_token1 => G_SQLCODE_TOKEN,
658: p_token1_value => SQLCODE,

Line 740: OKL_API.set_message(

736: IF l_strm_id = 1 THEN
737:
738: -- Streams associated with Investor Agreement AGREEMENT_NUMBER have
739: -- not been billed.
740: OKL_API.set_message(
741: p_app_name => G_APP_NAME,
742: p_msg_name => 'OKL_AM_INV_UNBILL_STRM',
743: p_token1 => 'AGREEMENT_NUMBER',
744: p_token1_value => p_ia_rec.contract_number);

Line 788: OKL_API.set_message(

784:
785: ROLLBACK TO check_unbilled_trx;
786:
787: -- Set the oracle error message
788: OKL_API.set_message(
789: p_app_name => G_APP_NAME_1,
790: p_msg_name => G_UNEXPECTED_ERROR,
791: p_token1 => G_SQLCODE_TOKEN,
792: p_token1_value => SQLCODE,

Line 1003: OKL_API.set_message(

999: /* sosharma end changes */
1000: -- If undisbursed stream elements then error
1001: IF l_disb_id = 1 THEN
1002: --Pending disbursements exists for the investor agreement AGREEMENT_NUMBER.
1003: OKL_API.set_message(
1004: p_app_name => G_APP_NAME,
1005: p_msg_name => 'OKL_AM_INV_PENDING_DISB',
1006: p_token1 => 'AGREEMENT_NUMBER',
1007: p_token1_value => p_ia_rec.contract_number);

Line 1020: OKL_API.set_message(

1016:
1017: -- If undisbursed stream elements then error
1018: IF l_disb_id = 1 THEN
1019: --Pending disbursements exists for the investor agreement AGREEMENT_NUMBER.
1020: OKL_API.set_message(
1021: p_app_name => G_APP_NAME,
1022: p_msg_name => 'OKL_AM_INV_PENDING_DISB',
1023: p_token1 => 'AGREEMENT_NUMBER',
1024: p_token1_value => p_ia_rec.contract_number);

Line 1067: OKL_API.set_message(

1063:
1064: ROLLBACK TO check_pending_disb_trx;
1065:
1066: -- Set the oracle error message
1067: OKL_API.set_message(
1068: p_app_name => G_APP_NAME_1,
1069: p_msg_name => G_UNEXPECTED_ERROR,
1070: p_token1 => G_SQLCODE_TOKEN,
1071: p_token1_value => SQLCODE,

Line 1166: OKL_API.set_message(

1162:
1163: WHEN OTHERS THEN
1164:
1165: -- Set the oracle error message
1166: OKL_API.set_message(
1167: p_app_name => G_APP_NAME_1,
1168: p_msg_name => G_UNEXPECTED_ERROR,
1169: p_token1 => G_SQLCODE_TOKEN,
1170: p_token1_value => SQLCODE,

Line 1300: OKL_API.set_message(

1296: IF l_ia_rec.id IS NULL
1297: OR l_ia_rec.contract_number IS NULL THEN
1298:
1299: -- Invalid Value
1300: OKL_API.set_message(
1301: p_app_name => G_APP_NAME_1,
1302: p_msg_name => G_INVALID_VALUE,
1303: p_token1 => G_COL_NAME_TOKEN,
1304: p_token1_value => 'id');

Line 1314: OKL_API.set_message(

1310: -- If not investor agreeement
1311: IF l_ia_rec.scs_code <> 'INVESTOR' THEN
1312:
1313: -- AGREEMENT_NUMBER is not a valid Investor Agreement.
1314: OKL_API.set_message(
1315: p_app_name => G_APP_NAME,
1316: p_msg_name => 'OKL_AM_INV_NOT_INV',
1317: p_token1 => 'AGREEMENT_NUMBER',
1318: p_token1_value => l_ia_rec.contract_number);

Line 1328: OKL_API.set_message(

1324: -- If not active
1325: IF l_ia_rec.sts_code <> 'ACTIVE' THEN
1326:
1327: -- Investor Agreement AGREEMENT_NUMBER is not in active status.
1328: OKL_API.set_message(
1329: p_app_name => G_APP_NAME,
1330: p_msg_name => 'OKL_AM_INV_NOT_ACTIVE',
1331: p_token1 => 'AGREEMENT_NUMBER',
1332: p_token1_value => l_ia_rec.contract_number);

Line 1342: OKL_API.set_message(

1338: -- If not end dated
1339: IF l_ia_rec.end_date IS NULL THEN
1340:
1341: -- End date is not available for Investor Agreement AGREEMENT_NUMBER.
1342: OKL_API.set_message(
1343: p_app_name => G_APP_NAME,
1344: p_msg_name => 'OKL_AM_INV_NOT_ENDED',
1345: p_token1 => 'AGREEMENT_NUMBER',
1346: p_token1_value => l_ia_rec.contract_number);

Line 1363: OKL_API.set_message(

1359: -- If TRN exists and was PROCESSED then error
1360: IF l_tsu_code = 'PROCESSED' THEN
1361: -- The transaction status and agreement status are mismatched for
1362: -- Investor Agreement AGREEMENT_NUMBER.
1363: OKL_API.set_message(
1364: p_app_name => G_APP_NAME,
1365: p_msg_name => 'OKL_AM_INV_PRS_TRN_EXIST',
1366: p_token1 => 'AGREEMENT_NUMBER',
1367: p_token1_value => l_ia_rec.contract_number);

Line 1384: OKL_API.set_message(

1380: END LOOP;
1381: IF l_trans_pool_id is not null THEN
1382:
1383: -- Pending pool contents and transactions are present
1384: OKL_API.set_message(
1385: p_app_name => G_APP_NAME,
1386: p_msg_name => 'OKL_AM_INV_PEND_REQ_EXIST',
1387: p_token1 => 'AGREEMENT_NUMBER',
1388: p_token1_value => l_ia_rec.contract_number);

Line 1460: OKL_API.set_message(

1456: END LOOP;
1457:
1458: -- Set the success message
1459: -- Investor Agreement AGREEMENT_NUMBER is valid.
1460: OKL_API.set_message(
1461: p_app_name => G_APP_NAME,
1462: p_msg_name => 'OKL_AM_INV_VALIDATE_SUCC',
1463: p_token1 => 'AGREEMENT_NUMBER',
1464: p_token1_value => l_ia_rec.contract_number);

Line 1508: OKL_API.set_message(

1504:
1505: WHEN OTHERS THEN
1506: ROLLBACK TO validate_ia_trx;
1507: -- Set the oracle error message
1508: OKL_API.set_message(
1509: p_app_name => G_APP_NAME_1,
1510: p_msg_name => G_UNEXPECTED_ERROR,
1511: p_token1 => G_SQLCODE_TOKEN,
1512: p_token1_value => SQLCODE,

Line 1651: OKL_API.set_message(

1647:
1648: IF l_return_status <> G_RET_STS_SUCCESS THEN
1649:
1650: -- Message: Unable to find a transaction type for the transaction TRY_NAME -- Seeded
1651: OKL_API.set_message(
1652: p_app_name => G_APP_NAME,
1653: p_msg_name => 'OKL_AM_NO_TRX_TYPE_FOUND',
1654: p_token1 => 'TRY_NAME',
1655: p_token1_value => l_trans_meaning);

Line 1698: OKL_API.set_message(

1694: -- Set msg if error
1695: IF l_return_status <> G_RET_STS_SUCCESS THEN
1696: -- Error occured while creating termination transaction for the
1697: -- Investor Agreement AGREEMENT_NUMBER..
1698: OKL_API.set_message(
1699: p_app_name => G_APP_NAME,
1700: p_msg_name => 'OKL_AM_INV_TRN_CREATE_ERR');
1701: END IF;
1702:

Line 1752: OKL_API.set_message(

1748: WHEN OTHERS THEN
1749: ROLLBACK TO pop_insert_trn_trx;
1750:
1751: -- Set the oracle error message
1752: OKL_API.set_message(
1753: p_app_name => G_APP_NAME_1,
1754: p_msg_name => G_UNEXPECTED_ERROR,
1755: p_token1 => G_SQLCODE_TOKEN,
1756: p_token1_value => SQLCODE,

Line 1822: OKL_API.set_message(

1818:
1819: IF l_return_status <> G_RET_STS_SUCCESS THEN
1820: -- Error occured during reversal of loss provisions for Investor
1821: -- Agreement AGREEMENT_NUMBER.
1822: OKL_API.set_message(
1823: p_app_name => G_APP_NAME,
1824: p_msg_name => 'OKL_AM_INV_REVERSE_ERR',
1825: p_token1 => 'AGREEMENT_NUMBER',
1826: p_token1_value => p_ia_rec.contract_number);

Line 1838: OKL_API.set_message(

1834: END IF;
1835:
1836: -- Set the success message
1837: -- Loss provisions have been reversed for Investor Agreement AGREEMENT_NUMBER.
1838: OKL_API.set_message(
1839: p_app_name => G_APP_NAME,
1840: p_msg_name => 'OKL_AM_INV_REVERSE_SUCC',
1841: p_token1 => 'AGREEMENT_NUMBER',
1842: p_token1_value => p_ia_rec.contract_number);

Line 1879: OKL_API.set_message(

1875: WHEN OTHERS THEN
1876: ROLLBACK TO reverse_loss_trx;
1877:
1878: -- Set the oracle error message
1879: OKL_API.set_message(
1880: p_app_name => G_APP_NAME_1,
1881: p_msg_name => G_UNEXPECTED_ERROR,
1882: p_token1 => G_SQLCODE_TOKEN,
1883: p_token1_value => SQLCODE,

Line 1988: OKL_API.set_message(

1984: WHEN OTHERS THEN
1985: ROLLBACK TO accounting_entries_trx;
1986:
1987: -- Set the oracle error message
1988: OKL_API.set_message(
1989: p_app_name => G_APP_NAME_1,
1990: p_msg_name => G_UNEXPECTED_ERROR,
1991: p_token1 => G_SQLCODE_TOKEN,
1992: p_token1_value => SQLCODE,

Line 2083: OKL_API.set_message(

2079: x_klev_rec => lx_klev_rec);
2080:
2081: IF l_return_status <> G_RET_STS_SUCCESS THEN
2082: -- Error occured during update of Investor Agreement AGREEMENT_NUMBER lines.
2083: OKL_API.set_message(
2084: p_app_name => G_APP_NAME,
2085: p_msg_name => 'OKL_AM_INV_TRMT_LINE_ERR',
2086: p_token1 => 'AGREEMENT_NUMBER',
2087: p_token1_value => p_ia_rec.contract_number);

Line 2127: OKL_API.set_message(

2123: x_khrv_rec => lx_khrv_rec);
2124:
2125: IF l_return_status <> G_RET_STS_SUCCESS THEN
2126: -- Error occured during update of investor agreement AGREEMENT_NUMBER.
2127: OKL_API.set_message(
2128: p_app_name => G_APP_NAME,
2129: p_msg_name => 'OKL_AM_INV_TRMT_ERR',
2130: p_token1 => 'AGREEMENT_NUMBER',
2131: p_token1_value => p_ia_rec.contract_number);

Line 2176: OKL_API.set_message(

2172: WHEN OTHERS THEN
2173: ROLLBACK TO update_ia_and_lines_trx;
2174:
2175: -- Set the oracle error message
2176: OKL_API.set_message(
2177: p_app_name => G_APP_NAME_1,
2178: p_msg_name => G_UNEXPECTED_ERROR,
2179: p_token1 => G_SQLCODE_TOKEN,
2180: p_token1_value => SQLCODE,

Line 2311: OKL_API.set_message(

2307:
2308: IF l_return_status <> G_RET_STS_SUCCESS THEN
2309: -- Error occurred during update of pool for the
2310: -- Investor Agreement AGREEMENT_NUMBER.
2311: OKL_API.set_message(
2312: p_app_name => G_APP_NAME,
2313: p_msg_name => 'OKL_AM_INV_UPD_POOL_ERR',
2314: p_token1 => 'AGREEMENT_NUMBER',
2315: p_token1_value => p_ia_rec.contract_number);

Line 2356: OKL_API.set_message(

2352:
2353: IF l_return_status <> G_RET_STS_SUCCESS THEN
2354: -- Error occurred during creation of pool transaction for
2355: -- the Investor Agreement AGREEMENT_NUMBER.
2356: OKL_API.set_message(
2357: p_app_name => G_APP_NAME,
2358: p_msg_name => 'OKL_AM_INV_POOL_TRN_CRT_ERR',
2359: p_token1 => 'AGREEMENT_NUMBER',
2360: p_token1_value => p_ia_rec.contract_number);

Line 2395: OKL_API.set_message(

2391:
2392: IF l_return_status <> G_RET_STS_SUCCESS THEN
2393: -- Error occurred during update of pool contents for
2394: -- the Investor Agreement AGREEMENT_NUMBER.
2395: OKL_API.set_message(
2396: p_app_name => G_APP_NAME,
2397: p_msg_name => 'OKL_AM_INV_UPD_POC_IA_ERR',
2398: p_token1 => 'AGREEMENT_NUMBER',
2399: p_token1_value => p_ia_rec.contract_number);

Line 2425: p_init_msg_list => OKL_API.G_FALSE,

2421: l_khrv_rec.securitized_code := 'N';
2422:
2423: OKL_CONTRACT_PUB.update_contract_header(
2424: p_api_version => l_api_version,
2425: p_init_msg_list => OKL_API.G_FALSE,
2426: x_return_status => l_return_status,
2427: x_msg_count => l_msg_count,
2428: x_msg_data => l_msg_data,
2429: p_chrv_rec => l_chrv_rec,

Line 2437: OKL_API.set_message(

2433:
2434: IF l_return_status <> G_RET_STS_SUCCESS THEN
2435: -- Error occurred during update of pool for the
2436: -- Investor Agreement AGREEMENT_NUMBER.
2437: OKL_API.set_message(
2438: p_app_name => G_APP_NAME,
2439: p_msg_name => 'OKL_AM_INV_UPD_POOL_ERR',
2440: p_token1 => 'AGREEMENT_NUMBER',
2441: p_token1_value => p_ia_rec.contract_number);

Line 2490: OKL_API.set_message(

2486: WHEN OTHERS THEN
2487: ROLLBACK TO update_pools_trx;
2488:
2489: -- Set the oracle error message
2490: OKL_API.set_message(
2491: p_app_name => G_APP_NAME_1,
2492: p_msg_name => G_UNEXPECTED_ERROR,
2493: p_token1 => G_SQLCODE_TOKEN,
2494: p_token1_value => SQLCODE,

Line 2576: OKL_API.set_message(

2572: END IF;
2573:
2574: -- Set the success message
2575: -- Investor agreement AGREEMENT_NUMBER expired successfully.
2576: OKL_API.set_message(
2577: p_app_name => G_APP_NAME,
2578: p_msg_name => 'OKL_AM_INV_TRMNT_SUCC',
2579: p_token1 => 'AGREEMENT_NUMBER',
2580: p_token1_value => p_ia_rec.contract_number);

Line 2626: OKL_API.set_message(

2622: WHEN OTHERS THEN
2623: ROLLBACK TO update_ia_trx;
2624:
2625: -- Set the oracle error message
2626: OKL_API.set_message(
2627: p_app_name => G_APP_NAME_1,
2628: p_msg_name => G_UNEXPECTED_ERROR,
2629: p_token1 => G_SQLCODE_TOKEN,
2630: p_token1_value => SQLCODE,

Line 2694: OKL_API.set_message(

2690: -- Set msg if error
2691: IF l_return_status <> G_RET_STS_SUCCESS THEN
2692: -- Error occured during update of termination transaction
2693: -- for Investor Agreement AGREEMENT_NUMBER.
2694: OKL_API.set_message(
2695: p_app_name => G_APP_NAME,
2696: p_msg_name => 'OKL_AM_INV_TRN_UPD_IA_ERR',
2697: p_token1 => 'AGREEMENT_NUMBER',
2698: p_token1_value => p_ia_rec.contract_number);

Line 2743: OKL_API.set_message(

2739: WHEN OTHERS THEN
2740: ROLLBACK TO update_transaction_trx;
2741:
2742: -- Set the oracle error message
2743: OKL_API.set_message(
2744: p_app_name => G_APP_NAME_1,
2745: p_msg_name => G_UNEXPECTED_ERROR,
2746: p_token1 => G_SQLCODE_TOKEN,
2747: p_token1_value => SQLCODE,

Line 2803: lx_error_rec OKL_API.error_rec_type;

2799: l_status VARCHAR2(300);
2800: l_control_flag VARCHAR2(300);
2801: l_valid_gl_date DATE;
2802:
2803: lx_error_rec OKL_API.error_rec_type;
2804: l_msg_idx INTEGER := G_FIRST;
2805: l_msg_tbl msg_tbl_type;
2806: l_api_name VARCHAR2(30) := 'terminate_investor_ag';
2807: l_api_version CONSTANT NUMBER := G_API_VERSION;

Line 2827: l_return_status := OKL_API.start_activity(

2823: -- *************
2824: -- Check API version, initialize message list and create savepoint
2825: -- *************
2826:
2827: l_return_status := OKL_API.start_activity(
2828: p_api_name => l_api_name,
2829: p_pkg_name => G_PKG_NAME,
2830: p_init_msg_list => p_init_msg_list,
2831: l_api_version => l_api_version,

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

3009:
3010: END IF;
3011:
3012: -- End Activity
3013: OKL_API.end_activity (x_msg_count, x_msg_data);
3014:
3015: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3016: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3017: 'OKL_AM_TERMINATE_INV_AGMT_PVT.terminate_investor_agreement.',

Line 3055: x_return_status := OKL_API.handle_exceptions(

3051: p_ia_rec => l_ia_rec,
3052: p_control_flag => 'ERROR');
3053: END IF;
3054:
3055: x_return_status := OKL_API.handle_exceptions(
3056: p_api_name => l_api_name,
3057: p_pkg_name => G_PKG_NAME,
3058: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3059: x_msg_count => x_msg_count,

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

3054:
3055: x_return_status := OKL_API.handle_exceptions(
3056: p_api_name => l_api_name,
3057: p_pkg_name => G_PKG_NAME,
3058: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3059: x_msg_count => x_msg_count,
3060: x_msg_data => x_msg_data,
3061: p_api_type => '_PVT');
3062:

Line 3078: x_return_status := OKL_API.handle_exceptions(

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

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

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

Line 3101: x_return_status := OKL_API.handle_exceptions(

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

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

3165:
3166: BEGIN
3167:
3168: -- Initialize message list
3169: OKL_API.init_msg_list('T');
3170:
3171: SELECT SYSDATE INTO l_sys_date FROM DUAL;
3172:
3173: IF p_date IS NULL THEN

Line 3236: OKL_API.set_message(

3232: EXCEPTION
3233:
3234: WHEN OTHERS THEN
3235: -- Set the oracle error message
3236: OKL_API.set_message(
3237: p_app_name => G_APP_NAME_1,
3238: p_msg_name => G_UNEXPECTED_ERROR,
3239: p_token1 => G_SQLCODE_TOKEN,
3240: p_token1_value => SQLCODE,