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

Line 11: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

7:
8: -- Global Variables
9: G_INIT_NUMBER NUMBER := -9999;
10: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TRANSACTION_PVT';
11: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
12: G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
13:
14: -- smadhava Bug# 4542290 - 24-Aug-2005 - Added - Start
15: G_REBOOK_TRX CONSTANT VARCHAR(30) := 'REBOOK';

Line 55: okl_api.end_activity(

51: x_msg_out VARCHAR2(2000);
52:
53: BEGIN
54:
55: okl_api.end_activity(
56: X_msg_count => x_msg_count,
57: X_msg_data => x_msg_data
58: );
59:

Line 122: okl_api.set_message(

118: RETURN;
119:
120: EXCEPTION
121: WHEN rebook_failed THEN
122: okl_api.set_message(
123: G_APP_NAME,
124: G_INVALID_VALUE,
125: 'COL_NAME',
126: 'REBOOK REASON'

Line 190: okl_api.set_message(

186: OPEN con_header_csr(p_chr_id);
187: FETCH con_header_csr INTO l_currency_code,
188: l_org_id;
189: IF con_header_csr%NOTFOUND THEN
190: okl_api.set_message(
191: G_APP_NAME,
192: G_LLA_CHR_ID
193: );
194: RAISE populate_failed;

Line 215: okl_api.set_message(

211:
212: OPEN try_csr (p_trx_type);
213: FETCH try_csr INTO l_try_id;
214: IF try_csr%NOTFOUND THEN
215: okl_api.set_message(
216: G_APP_NAME,
217: G_LLA_NO_TRY,
218: 'TRX_TYPE',
219: p_trx_type

Line 251: Okl_Api.set_message(p_app_name => g_app_name,

247: -- get the contract number
248: OPEN contract_num_csr(p_chr_id);
249: FETCH contract_num_csr INTO l_cntrct_number;
250: CLOSE contract_num_csr;
251: Okl_Api.set_message(p_app_name => g_app_name,
252: p_msg_name => 'OKL_LE_NOT_EXIST_CNTRCT',
253: p_token1 => 'CONTRACT_NUMBER',
254: p_token1_value => l_cntrct_number);
255: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 255: RAISE OKL_API.G_EXCEPTION_ERROR;

251: Okl_Api.set_message(p_app_name => g_app_name,
252: p_msg_name => 'OKL_LE_NOT_EXIST_CNTRCT',
253: p_token1 => 'CONTRACT_NUMBER',
254: p_token1_value => l_cntrct_number);
255: RAISE OKL_API.G_EXCEPTION_ERROR;
256: END IF;
257: RETURN;
258:
259:

Line 274: okl_api.set_message(

270:
271: x_return_status := OKC_API.G_RET_STS_ERROR;
272:
273: WHEN OTHERS THEN
274: okl_api.set_message(
275: G_APP_NAME,
276: G_UNEXPECTED_ERROR,
277: 'OKL_SQLCODE',
278: SQLCODE,

Line 392: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

388:
389: END LOOP; --sechawla 01-oct-09 8967918
390:
391: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
392: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
393: x_msg_data => x_msg_data);
394:
395: EXCEPTION
396: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 455: x_return_status := OKL_API.G_RET_STS_SUCCESS;

451: IF (G_DEBUG_ENABLED = 'Y') THEN
452: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
453: END IF;
454:
455: x_return_status := OKL_API.G_RET_STS_SUCCESS;
456: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
457: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
458: END IF;
459:

Line 472: IF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

468: x_value => l_contract_secu,
469: x_inv_agmt_chr_id_tbl => l_inv_agmt_chr_id_tbl
470: );
471:
472: IF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
473: IF (l_contract_secu = OKL_API.G_TRUE) THEN
474: okl_api.set_message(
475: G_APP_NAME,
476: G_LLA_SECU_ERROR

Line 473: IF (l_contract_secu = OKL_API.G_TRUE) THEN

469: x_inv_agmt_chr_id_tbl => l_inv_agmt_chr_id_tbl
470: );
471:
472: IF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
473: IF (l_contract_secu = OKL_API.G_TRUE) THEN
474: okl_api.set_message(
475: G_APP_NAME,
476: G_LLA_SECU_ERROR
477: );

Line 474: okl_api.set_message(

470: );
471:
472: IF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
473: IF (l_contract_secu = OKL_API.G_TRUE) THEN
474: okl_api.set_message(
475: G_APP_NAME,
476: G_LLA_SECU_ERROR
477: );
478: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 478: x_return_status := OKL_API.G_RET_STS_ERROR;

474: okl_api.set_message(
475: G_APP_NAME,
476: G_LLA_SECU_ERROR
477: );
478: x_return_status := OKL_API.G_RET_STS_ERROR;
479: END IF;
480: END IF;
481:
482: RETURN;

Line 531: x_return_status := OKL_API.G_RET_STS_SUCCESS;

527: IF (G_DEBUG_ENABLED = 'Y') THEN
528: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
529: END IF;
530:
531: x_return_status := OKL_API.G_RET_STS_SUCCESS;
532: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
533: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
534: END IF;
535:

Line 538: p_init_msg_list => OKL_API.G_FALSE,

534: END IF;
535:
536: okl_securitization_pvt.check_kle_securitized(
537: p_api_version => p_api_version,
538: p_init_msg_list => OKL_API.G_FALSE,
539: x_return_status => x_return_status,
540: x_msg_count => x_msg_count,
541: x_msg_data => x_msg_data,
542: p_kle_id => p_cle_id,

Line 549: IF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

545: x_value => l_asset_secu,
546: x_inv_agmt_chr_id_tbl => l_inv_agmt_chr_id_tbl
547: );
548:
549: IF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
550: IF (l_asset_secu = OKL_API.G_TRUE) THEN
551: okl_api.set_message(
552: G_APP_NAME,
553: G_LLA_SECU_ERROR

Line 550: IF (l_asset_secu = OKL_API.G_TRUE) THEN

546: x_inv_agmt_chr_id_tbl => l_inv_agmt_chr_id_tbl
547: );
548:
549: IF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
550: IF (l_asset_secu = OKL_API.G_TRUE) THEN
551: okl_api.set_message(
552: G_APP_NAME,
553: G_LLA_SECU_ERROR
554: );

Line 551: okl_api.set_message(

547: );
548:
549: IF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
550: IF (l_asset_secu = OKL_API.G_TRUE) THEN
551: okl_api.set_message(
552: G_APP_NAME,
553: G_LLA_SECU_ERROR
554: );
555: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 555: x_return_status := OKL_API.G_RET_STS_ERROR;

551: okl_api.set_message(
552: G_APP_NAME,
553: G_LLA_SECU_ERROR
554: );
555: x_return_status := OKL_API.G_RET_STS_ERROR;
556: END IF;
557: END IF;
558:
559: RETURN;

Line 671: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

667: END IF;
668:
669: EXCEPTION
670: WHEN OTHERS THEN
671: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
672: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
673: END raise_business_event;
674:
675:

Line 672: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

668:
669: EXCEPTION
670: WHEN OTHERS THEN
671: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
672: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
673: END raise_business_event;
674:
675:
676: /*

Line 708: okl_api.set_message(

704: RAISE OKC_API.G_EXCEPTION_ERROR;
705: END IF;
706:
707: IF (p_trx_type NOT IN ('REBOOK','SPLIT')) THEN
708: okl_api.set_message(
709: G_APP_NAME,
710: G_LLA_INVALID_TRX_TYPE,
711: 'TRX_TYPE',
712: p_trx_type

Line 723: p_init_msg_list => OKL_API.G_FALSE,

719: -- Check for securitization during split contract
720: --
721: check_contract_securitized(
722: p_api_version => p_api_version,
723: p_init_msg_list => OKL_API.G_FALSE,
724: x_return_status => x_return_status,
725: x_msg_count => x_msg_count,
726: x_msg_data => x_msg_data,
727: p_chr_id => p_chr_id,

Line 731: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

727: p_chr_id => p_chr_id,
728: p_trx_date => p_trx_date
729: );
730:
731: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
732: RAISE OKC_API.G_EXCEPTION_ERROR;
733: END IF;
734: END IF;
735:

Line 750: okl_api.set_message(

746: OPEN contract_num_csr(p_chr_id);
747: FETCH contract_num_csr INTO l_contract_number;
748: CLOSE contract_num_csr;
749:
750: okl_api.set_message(
751: G_APP_NAME,
752: 'OKL_TX_AST_LOC_RBK_NOTALLWED',
753: 'CONTRACT_NUMBER',
754: l_contract_number

Line 776: okl_api.set_message(

772: --
773: -- Check for Transaction Date, it is mandetory
774: --
775: IF (p_trx_date IS NULL) THEN
776: okl_api.set_message(
777: G_APP_NAME,
778: G_LLA_MISSING_TRX_DATE
779: );
780: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 801: okl_api.set_message(

797: FETCH check_date_csr INTO l_date_valid;
798: CLOSE check_date_csr;
799:
800: IF (l_date_valid = 'N') THEN
801: okl_api.set_message(
802: G_APP_NAME,
803: G_LLA_WRONG_TRX_DATE,
804: 'START_DATE',
805: l_con_start_date,

Line 818: , p_init_msg_list => OKL_API.G_FALSE

814: IF (p_trx_type = G_REBOOK_TRX) THEN
815: -- check if the rebook transaction is allowed for the contract for this rebook date
816: OKL_K_RATE_PARAMS_PVT.check_rebook_allowed(
817: p_api_version => p_api_version
818: , p_init_msg_list => OKL_API.G_FALSE
819: , x_return_status => x_return_status
820: , x_msg_count => x_msg_count
821: , x_msg_data => x_msg_data
822: , p_chr_id => p_chr_id

Line 871: , p_init_msg_list => OKL_API.G_FALSE

867: IF (p_trx_type = G_REBOOK_TRX) THEN
868: -- check if the rebook transaction is allowed for the contract for this rebook date
869: OKL_K_RATE_PARAMS_PVT.check_rebook_allowed(
870: p_api_version => p_api_version
871: , p_init_msg_list => OKL_API.G_FALSE
872: , x_return_status => x_return_status
873: , x_msg_count => x_msg_count
874: , x_msg_data => x_msg_data
875: , p_chr_id => p_chr_id

Line 892: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

888: -- mvasudev, 08/30/2004
889: -- Code change to enable Business Event
890: */
891: raise_business_event(x_return_status => x_return_status);
892: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
893: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
894: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
895: RAISE OKL_API.G_EXCEPTION_ERROR;
896: END IF;

Line 893: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

889: -- Code change to enable Business Event
890: */
891: raise_business_event(x_return_status => x_return_status);
892: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
893: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
894: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
895: RAISE OKL_API.G_EXCEPTION_ERROR;
896: END IF;
897:

Line 894: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

890: */
891: raise_business_event(x_return_status => x_return_status);
892: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
893: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
894: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
895: RAISE OKL_API.G_EXCEPTION_ERROR;
896: END IF;
897:
898: /*

Line 895: RAISE OKL_API.G_EXCEPTION_ERROR;

891: raise_business_event(x_return_status => x_return_status);
892: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
893: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
894: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
895: RAISE OKL_API.G_EXCEPTION_ERROR;
896: END IF;
897:
898: /*
899: -- mvasudev, 08/30/2004

Line 904: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

900: -- END, Code change to enable Business Event
901: */
902:
903: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
904: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
905: x_msg_data => x_msg_data);
906:
907: EXCEPTION
908: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1148: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

1144: EXIT WHEN (i >= l_rev_tbl.last);
1145:
1146: END LOOP;
1147:
1148: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1149: x_msg_data => x_msg_data);
1150:
1151: EXCEPTION
1152: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1263: okl_api.set_message(

1259: --
1260: -- Check for Transaction Date, it is mandetory
1261: --
1262: IF (p_trx_date IS NULL) THEN
1263: okl_api.set_message(
1264: G_APP_NAME,
1265: G_LLA_MISSING_TRX_DATE
1266: );
1267: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1305: Okl_Api.set_message(p_app_name => g_app_name,

1301: -- get the contract number
1302: OPEN contract_num_csr(p_lease_id);
1303: FETCH contract_num_csr INTO l_cntrct_number;
1304: CLOSE contract_num_csr;
1305: Okl_Api.set_message(p_app_name => g_app_name,
1306: p_msg_name => 'OKL_LE_NOT_EXIST_CNTRCT',
1307: p_token1 => 'CONTRACT_NUMBER',
1308: p_token1_value => l_cntrct_number);
1309: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1309: RAISE OKL_API.G_EXCEPTION_ERROR;

1305: Okl_Api.set_message(p_app_name => g_app_name,
1306: p_msg_name => 'OKL_LE_NOT_EXIST_CNTRCT',
1307: p_token1 => 'CONTRACT_NUMBER',
1308: p_token1_value => l_cntrct_number);
1309: RAISE OKL_API.G_EXCEPTION_ERROR;
1310: END IF;
1311: FOR con_header_rec IN con_header_csr (p_lease_id)
1312: LOOP
1313: l_tcnv_rec.org_id := con_header_rec.authoring_org_id;

Line 1346: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

1342: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done...');
1343: END IF;
1344:
1345: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1346: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1347: x_msg_data => x_msg_data);
1348:
1349: EXCEPTION
1350:

Line 1355: x_return_status := OKL_API.G_RET_STS_ERROR;

1351: WHEN service_txn_failed THEN
1352: IF try_csr%ISOPEN THEN
1353: CLOSE try_csr;
1354: END IF;
1355: x_return_status := OKL_API.G_RET_STS_ERROR;
1356:
1357: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1358: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1359: p_api_name => l_api_name,

Line 1468: okl_api.set_message(

1464: --
1465: -- Check for Transaction Date, it is mandetory
1466: --
1467: IF (p_trx_date IS NULL) THEN
1468: okl_api.set_message(
1469: G_APP_NAME,
1470: G_LLA_MISSING_TRX_DATE
1471: );
1472: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1511: Okl_Api.set_message(p_app_name => g_app_name,

1507: -- get the contract number
1508: OPEN contract_num_csr(p_chr_id);
1509: FETCH contract_num_csr INTO l_cntrct_number;
1510: CLOSE contract_num_csr;
1511: Okl_Api.set_message(p_app_name => g_app_name,
1512: p_msg_name => 'OKL_LE_NOT_EXIST_CNTRCT',
1513: p_token1 => 'CONTRACT_NUMBER',
1514: p_token1_value => l_cntrct_number);
1515: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1515: RAISE OKL_API.G_EXCEPTION_ERROR;

1511: Okl_Api.set_message(p_app_name => g_app_name,
1512: p_msg_name => 'OKL_LE_NOT_EXIST_CNTRCT',
1513: p_token1 => 'CONTRACT_NUMBER',
1514: p_token1_value => l_cntrct_number);
1515: RAISE OKL_API.G_EXCEPTION_ERROR;
1516: END IF;
1517: FOR con_header_rec IN con_header_csr (p_chr_id)
1518: LOOP
1519: l_tcnv_rec.org_id := con_header_rec.authoring_org_id;

Line 1552: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

1548: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done...');
1549: END IF;
1550:
1551: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1552: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1553: x_msg_data => x_msg_data);
1554:
1555: EXCEPTION
1556:

Line 1561: x_return_status := OKL_API.G_RET_STS_ERROR;

1557: WHEN ppd_txn_failed THEN
1558: IF try_csr%ISOPEN THEN
1559: CLOSE try_csr;
1560: END IF;
1561: x_return_status := OKL_API.G_RET_STS_ERROR;
1562:
1563: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1564: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1565: p_api_name => l_api_name,