DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on OKC_API

Line 537: p_app_name => OKC_API.G_APP_NAME,

533: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
534:
535: -- Set the oracle error message
536: OKL_API.set_message(
537: p_app_name => OKC_API.G_APP_NAME,
538: p_msg_name => g_unexpected_error,
539: p_token1 => g_sqlcode_token,
540: p_token1_value => SQLCODE,
541: p_token2 => g_sqlerrm_token,

Line 638: OKC_API.set_message( p_app_name => 'OKC',

634:
635: IF p_khr_id IS NULL OR p_khr_id = OKL_API.G_MISS_NUM THEN
636: x_return_status := OKL_API.G_RET_STS_ERROR;
637: -- chr id is required
638: OKC_API.set_message( p_app_name => 'OKC',
639: p_msg_name => G_REQUIRED_VALUE,
640: p_token1 => G_COL_NAME_TOKEN,
641: p_token1_value => 'Contract Id');
642: RAISE delink_exception;

Line 649: OKC_API.set_message( p_app_name => 'OKC',

645: -- rmunjulu modified to check for statusonly in case of full termination
646: IF nvl(p_full_term_yn,'Y') = 'Y' AND (p_sts_code IS NULL OR p_sts_code = OKL_API.G_MISS_CHAR) THEN
647: x_return_status := OKL_API.G_RET_STS_ERROR;
648: -- Status code is required
649: OKC_API.set_message( p_app_name => 'OKC',
650: p_msg_name => G_REQUIRED_VALUE,
651: p_token1 => G_COL_NAME_TOKEN,
652: p_token1_value => 'Contract Status Code');
653: RAISE delink_exception;

Line 659: OKC_API.set_message( p_app_name => 'OKC',

655:
656: IF p_quote_accpt_date IS NULL OR p_quote_accpt_date = OKL_API.G_MISS_DATE THEN
657: x_return_status := OKL_API.G_RET_STS_ERROR;
658: -- Quote Acceptance Date is required
659: OKC_API.set_message( p_app_name => 'OKC',
660: p_msg_name => G_REQUIRED_VALUE,
661: p_token1 => G_COL_NAME_TOKEN,
662: p_token1_value => 'Quote Acceptance Date');
663: RAISE delink_exception;

Line 669: OKC_API.set_message( p_app_name => 'OKC',

665:
666: IF p_quote_eff_date IS NULL OR p_quote_eff_date = OKL_API.G_MISS_DATE THEN
667: x_return_status := OKL_API.G_RET_STS_ERROR;
668: -- Quote Effective Date is required
669: OKC_API.set_message( p_app_name => 'OKC',
670: p_msg_name => G_REQUIRED_VALUE,
671: p_token1 => G_COL_NAME_TOKEN,
672: p_token1_value => 'Quote Effective Date');
673: RAISE delink_exception;

Line 718: p_init_msg_list => OKC_API.G_FALSE,

714: END IF;
715:
716: fa_adjustment_pub.do_adjustment(
717: p_api_version => p_api_version,
718: p_init_msg_list => OKC_API.G_FALSE,
719: p_commit => FND_API.G_FALSE,
720: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
721: p_calling_fn => NULL,
722: x_return_status => x_return_status,

Line 744: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

740: 'AFTER CALL TO FA_ADJUSTMENT_PUB.DO_ADJUSTMENT, x_return_status: '|| x_return_status);
741:
742: END IF;
743:
744: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
745:
746: -- Error processing TRX_TYPE transaction in Fixed Assets for asset ASSET_NUMBER in book BOOK.
747: OKC_API.set_message( p_app_name => 'OKL',
748: p_msg_name => 'OKL_AM_AMT_TRANS_FAILED',

Line 747: OKC_API.set_message( p_app_name => 'OKL',

743:
744: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
745:
746: -- Error processing TRX_TYPE transaction in Fixed Assets for asset ASSET_NUMBER in book BOOK.
747: OKC_API.set_message( p_app_name => 'OKL',
748: p_msg_name => 'OKL_AM_AMT_TRANS_FAILED',
749: p_token1 => 'TRX_TYPE',
750: p_token1_value => 'Contract Delink',
751: p_token2 => 'ASSET_NUMBER',

Line 813: p_init_msg_list => OKC_API.G_FALSE,

809: END IF;
810:
811: fa_adjustment_pub.do_adjustment(
812: p_api_version => p_api_version,
813: p_init_msg_list => OKC_API.G_FALSE,
814: p_commit => FND_API.G_FALSE,
815: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
816: p_calling_fn => NULL,
817: x_return_status => x_return_status,

Line 839: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

835: 'AFTER CALL TO FA_ADJUSTMENT_PUB.DO_ADJUSTMENT, x_return_status: '|| x_return_status);
836:
837: END IF;
838:
839: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
840:
841: -- Error processing TRX_TYPE transaction in Fixed Assets for asset ASSET_NUMBER in book BOOK.
842: OKC_API.set_message( p_app_name => 'OKL',
843: p_msg_name => 'OKL_AM_AMT_TRANS_FAILED',

Line 842: OKC_API.set_message( p_app_name => 'OKL',

838:
839: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
840:
841: -- Error processing TRX_TYPE transaction in Fixed Assets for asset ASSET_NUMBER in book BOOK.
842: OKC_API.set_message( p_app_name => 'OKL',
843: p_msg_name => 'OKL_AM_AMT_TRANS_FAILED',
844: p_token1 => 'TRX_TYPE',
845: p_token1_value => 'Contract Delink',
846: p_token2 => 'ASSET_NUMBER',

Line 901: p_app_name => OKC_API.G_APP_NAME,

897: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
898:
899: -- Set the oracle error message
900: OKL_API.set_message(
901: p_app_name => OKC_API.G_APP_NAME,
902: p_msg_name => g_unexpected_error,
903: p_token1 => g_sqlcode_token,
904: p_token1_value => SQLCODE,
905: p_token2 => g_sqlerrm_token,

Line 1335: p_app_name => OKC_API.G_APP_NAME,

1331: px_tcnv_rec => px_tcnv_rec);
1332:
1333: -- Set the oracle error message
1334: OKL_API.set_message(
1335: p_app_name => OKC_API.G_APP_NAME,
1336: p_msg_name => g_unexpected_error,
1337: p_token1 => g_sqlcode_token,
1338: p_token1_value => SQLCODE,
1339: p_token2 => g_sqlerrm_token,

Line 1428: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,

1424: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
1425: END IF;
1426:
1427: -- Set the oracle error message
1428: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,
1429: p_msg_name => g_unexpected_error,
1430: p_token1 => g_sqlcode_token,
1431: p_token1_value => SQLCODE,
1432: p_token2 => g_sqlerrm_token,

Line 1502: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,

1498: CLOSE k_lines_csr;
1499: END IF;
1500:
1501: -- Set the oracle error message
1502: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,
1503: p_msg_name => g_unexpected_error,
1504: p_token1 => g_sqlcode_token,
1505: p_token1_value => SQLCODE,
1506: p_token2 => g_sqlerrm_token,

Line 1733: p_app_name => OKC_API.G_APP_NAME,

1729: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
1730: END IF;
1731:
1732: OKL_API.set_message(
1733: p_app_name => OKC_API.G_APP_NAME,
1734: p_msg_name => g_unexpected_error,
1735: p_token1 => g_sqlcode_token,
1736: p_token1_value => SQLCODE,
1737: p_token2 => g_sqlerrm_token,

Line 1911: p_app_name => OKC_API.G_APP_NAME,

1907: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
1908: END IF;
1909:
1910: OKL_API.set_message(
1911: p_app_name => OKC_API.G_APP_NAME,
1912: p_msg_name => g_unexpected_error,
1913: p_token1 => g_sqlcode_token,
1914: p_token1_value => SQLCODE,
1915: p_token2 => g_sqlerrm_token,

Line 1990: p_app_name => OKC_API.G_APP_NAME,

1986: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
1987: END IF;
1988:
1989: OKL_API.set_message(
1990: p_app_name => OKC_API.G_APP_NAME,
1991: p_msg_name => g_unexpected_error,
1992: p_token1 => g_sqlcode_token,
1993: p_token1_value => SQLCODE,
1994: p_token2 => g_sqlerrm_token,

Line 2090: p_app_name => OKC_API.G_APP_NAME,

2086: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
2087: END IF;
2088:
2089: OKL_API.set_message(
2090: p_app_name => OKC_API.G_APP_NAME,
2091: p_msg_name => g_unexpected_error,
2092: p_token1 => g_sqlcode_token,
2093: p_token1_value => SQLCODE,
2094: p_token2 => g_sqlerrm_token,

Line 2241: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,

2237: IF (is_debug_exception_on) THEN
2238: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
2239: END IF;
2240:
2241: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,
2242: p_msg_name => g_unexpected_error,
2243: p_token1 => g_sqlcode_token,
2244: p_token1_value => SQLCODE,
2245: p_token2 => g_sqlerrm_token,

Line 3159: p_app_name => OKC_API.G_APP_NAME,

3155: px_tcnv_rec => px_tcnv_rec);
3156:
3157: -- Set the oracle error message
3158: OKL_API.set_message(
3159: p_app_name => OKC_API.G_APP_NAME,
3160: p_msg_name => g_unexpected_error,
3161: p_token1 => g_sqlcode_token,
3162: p_token1_value => SQLCODE,
3163: p_token2 => g_sqlerrm_token,

Line 4063: p_app_name => OKC_API.G_APP_NAME,

4059: px_tcnv_rec => px_tcnv_rec);
4060:
4061: -- Set the oracle error message
4062: OKL_API.set_message(
4063: p_app_name => OKC_API.G_APP_NAME,
4064: p_msg_name => g_unexpected_error,
4065: p_token1 => g_sqlcode_token,
4066: p_token1_value => SQLCODE,
4067: p_token2 => g_sqlerrm_token,

Line 4314: p_app_name => OKC_API.G_APP_NAME,

4310: px_tcnv_rec => px_tcnv_rec);
4311:
4312: -- Set the oracle error message
4313: OKL_API.set_message(
4314: p_app_name => OKC_API.G_APP_NAME,
4315: p_msg_name => g_unexpected_error,
4316: p_token1 => g_sqlcode_token,
4317: p_token1_value => SQLCODE,
4318: p_token2 => g_sqlerrm_token,

Line 4590: p_app_name => OKC_API.G_APP_NAME,

4586: px_tcnv_rec => px_tcnv_rec);
4587:
4588: -- Set the oracle error message
4589: OKL_API.set_message(
4590: p_app_name => OKC_API.G_APP_NAME,
4591: p_msg_name => g_unexpected_error,
4592: p_token1 => g_sqlcode_token,
4593: p_token1_value => SQLCODE,
4594: p_token2 => g_sqlerrm_token,

Line 6095: p_app_name => OKC_API.G_APP_NAME,

6091: px_tcnv_rec => px_tcnv_rec);
6092:
6093: -- Set the oracle error message
6094: OKL_API.set_message(
6095: p_app_name => OKC_API.G_APP_NAME,
6096: p_msg_name => g_unexpected_error,
6097: p_token1 => g_sqlcode_token,
6098: p_token1_value => SQLCODE,
6099: p_token2 => g_sqlerrm_token,

Line 7395: p_term_rec.p_termination_date = okc_api.g_miss_date

7391: lx_sty_id ,primary_sty_id_rec.kle_id )
7392: LOOP
7393:
7394: IF p_term_rec.p_termination_date IS NULL OR
7395: p_term_rec.p_termination_date = okc_api.g_miss_date
7396: THEN
7397: l_acceleration_rec.acceleration_date := l_valid_gl_date; --sysdate; -- rmunjulu EDAT
7398: ELSE
7399: l_acceleration_rec.acceleration_date := p_term_rec.p_termination_date;

Line 7403: l_accelerate_till_date = okc_api.g_miss_date

7399: l_acceleration_rec.acceleration_date := p_term_rec.p_termination_date;
7400: END IF;
7401:
7402: IF l_accelerate_till_date IS NULL OR
7403: l_accelerate_till_date = okc_api.g_miss_date
7404: THEN
7405: l_acceleration_rec.accelerate_till_date := p_term_rec.p_orig_end_date;
7406: ELSE
7407: l_acceleration_rec.accelerate_till_date := l_accelerate_till_date;

Line 7802: okl_api.set_message(p_app_name => okc_api.g_app_name,

7798: p_tsu_code => 'ERROR',
7799: px_tcnv_rec => px_tcnv_rec);
7800:
7801: -- Set the oracle error message
7802: okl_api.set_message(p_app_name => okc_api.g_app_name,
7803: p_msg_name => g_unexpected_error,
7804: p_token1 => g_sqlcode_token,
7805: p_token1_value => SQLCODE,
7806: p_token2 => g_sqlerrm_token,

Line 8137: p_init_msg_list => okc_api.g_false,

8133: END IF;
8134:
8135: okl_okc_migration_pvt.update_contract_item(
8136: p_api_version => 1.0,
8137: p_init_msg_list => okc_api.g_false,
8138: x_return_status =>x_return_status,
8139: x_msg_count =>x_msg_count,
8140: x_msg_data =>x_msg_data,
8141: p_cimv_rec =>l_cim_rec,

Line 8390: p_init_msg_list => okc_api.g_false,

8386: l_fxlv_rec.asset_book_type_name := p_corporate_book;
8387:
8388: --call Populate sources api
8389: okl_sla_acc_sources_pvt.populate_sources(p_api_version => p_api_version,
8390: p_init_msg_list => okc_api.g_false,
8391: p_fxhv_rec => l_fxhv_rec,
8392: p_fxlv_rec => l_fxlv_rec,
8393: x_return_status => x_return_status,
8394: x_msg_count => x_msg_count,

Line 8754: p_init_msg_list => okc_api.g_false,

8750: END IF;
8751:
8752: okl_okc_migration_pvt.update_contract_item(
8753: p_api_version => 1.0,
8754: p_init_msg_list => okc_api.g_false,
8755: x_return_status =>x_return_status,
8756: x_msg_count =>x_msg_count,
8757: x_msg_data =>x_msg_data,
8758: p_cimv_rec =>l_cim_rec,

Line 8925: p_init_msg_list => OKC_API.G_FALSE,

8921:
8922:
8923: fa_adjustment_pub.do_adjustment(
8924: p_api_version => L_api_version,
8925: p_init_msg_list => OKC_API.G_FALSE,
8926: p_commit => FND_API.G_FALSE,
8927: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
8928: p_calling_fn => NULL,
8929: x_return_status => x_return_status,

Line 9735: p_app_name => OKC_API.G_APP_NAME,

9731: px_tcnv_rec => px_tcnv_rec);
9732:
9733: -- Set the oracle error message
9734: OKL_API.set_message(
9735: p_app_name => OKC_API.G_APP_NAME,
9736: p_msg_name => g_unexpected_error,
9737: p_token1 => g_sqlcode_token,
9738: p_token1_value => SQLCODE,
9739: p_token2 => g_sqlerrm_token,

Line 10004: p_app_name => OKC_API.G_APP_NAME,

10000: px_tcnv_rec => px_tcnv_rec);
10001:
10002: -- Set the oracle error message
10003: OKL_API.set_message(
10004: p_app_name => OKC_API.G_APP_NAME,
10005: p_msg_name => g_unexpected_error,
10006: p_token1 => g_sqlcode_token,
10007: p_token1_value => SQLCODE,
10008: p_token2 => g_sqlerrm_token,

Line 10307: p_app_name => OKC_API.G_APP_NAME,

10303: px_tcnv_rec => px_tcnv_rec);
10304:
10305: -- Set the oracle error message
10306: OKL_API.set_message(
10307: p_app_name => OKC_API.G_APP_NAME,
10308: p_msg_name => g_unexpected_error,
10309: p_token1 => g_sqlcode_token,
10310: p_token1_value => SQLCODE,
10311: p_token2 => g_sqlerrm_token,

Line 10442: p_app_name => OKC_API.G_APP_NAME,

10438: px_tcnv_rec => px_tcnv_rec);
10439:
10440: -- Set the oracle error message
10441: OKL_API.set_message(
10442: p_app_name => OKC_API.G_APP_NAME,
10443: p_msg_name => g_unexpected_error,
10444: p_token1 => g_sqlcode_token,
10445: p_token1_value => SQLCODE,
10446: p_token2 => g_sqlerrm_token,

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

10508: l_auto_invoice_yn VARCHAR2(3);
10509: l_purchase_amount NUMBER;
10510: -- Added for bug# 6964174
10511: --start:| 05-29-08 cklee -- fixed bug: 7017824(R12)/OKL.H: bug#6964174 |
10512: l_is_securitized VARCHAR2(1) := OKC_API.G_FALSE;
10513: l_inv_agmt_chr_id_tbl OKL_SECURITIZATION_PVT.inv_agmt_chr_id_tbl_type;
10514: --end:| 05-29-08 cklee -- fixed bug: 7017824(R12)/OKL.H: bug#6964174 |
10515:
10516: -- asawanka added for debug feature start

Line 11097: IF l_is_securitized = OKC_API.G_TRUE THEN

11093: END IF;
11094:
11095: -- if contract is securitized, then call the modify pool contents. Prior to fix for bug# 6964174
11096: -- this was present in OKL_AM_SECURITIZATION_PVT.create_pool_transaction
11097: IF l_is_securitized = OKC_API.G_TRUE THEN
11098: OKL_SECURITIZATION_PVT.MODIFY_POOL_CONTENTS
11099: ( p_api_version => p_api_version
11100: ,p_init_msg_list => OKL_API.G_FALSE
11101: ,p_transaction_reason => OKL_SECURITIZATION_PVT.G_TRX_REASON_EARLY_TERMINATION