DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on OKC_API

Line 653: p_app_name => OKC_API.G_APP_NAME,

649: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
650:
651: -- Set the oracle error message
652: OKL_API.set_message(
653: p_app_name => OKC_API.G_APP_NAME,
654: p_msg_name => g_unexpected_error,
655: p_token1 => g_sqlcode_token,
656: p_token1_value => SQLCODE,
657: p_token2 => g_sqlerrm_token,

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

750:
751: IF p_khr_id IS NULL OR p_khr_id = OKL_API.G_MISS_NUM THEN
752: x_return_status := OKL_API.G_RET_STS_ERROR;
753: -- chr id is required
754: OKC_API.set_message( p_app_name => 'OKC',
755: p_msg_name => G_REQUIRED_VALUE,
756: p_token1 => G_COL_NAME_TOKEN,
757: p_token1_value => 'Contract Id');
758: RAISE delink_exception;

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

761: -- rmunjulu modified to check for statusonly in case of full termination
762: IF nvl(p_full_term_yn,'Y') = 'Y' AND (p_sts_code IS NULL OR p_sts_code = OKL_API.G_MISS_CHAR) THEN
763: x_return_status := OKL_API.G_RET_STS_ERROR;
764: -- Status code is required
765: OKC_API.set_message( p_app_name => 'OKC',
766: p_msg_name => G_REQUIRED_VALUE,
767: p_token1 => G_COL_NAME_TOKEN,
768: p_token1_value => 'Contract Status Code');
769: RAISE delink_exception;

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

771:
772: IF p_quote_accpt_date IS NULL OR p_quote_accpt_date = OKL_API.G_MISS_DATE THEN
773: x_return_status := OKL_API.G_RET_STS_ERROR;
774: -- Quote Acceptance Date is required
775: OKC_API.set_message( p_app_name => 'OKC',
776: p_msg_name => G_REQUIRED_VALUE,
777: p_token1 => G_COL_NAME_TOKEN,
778: p_token1_value => 'Quote Acceptance Date');
779: RAISE delink_exception;

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

781:
782: IF p_quote_eff_date IS NULL OR p_quote_eff_date = OKL_API.G_MISS_DATE THEN
783: x_return_status := OKL_API.G_RET_STS_ERROR;
784: -- Quote Effective Date is required
785: OKC_API.set_message( p_app_name => 'OKC',
786: p_msg_name => G_REQUIRED_VALUE,
787: p_token1 => G_COL_NAME_TOKEN,
788: p_token1_value => 'Quote Effective Date');
789: RAISE delink_exception;

Line 834: p_init_msg_list => OKC_API.G_FALSE,

830: END IF;
831:
832: fa_adjustment_pub.do_adjustment(
833: p_api_version => p_api_version,
834: p_init_msg_list => OKC_API.G_FALSE,
835: p_commit => FND_API.G_FALSE,
836: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
837: p_calling_fn => NULL,
838: x_return_status => x_return_status,

Line 860: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

856: 'AFTER CALL TO FA_ADJUSTMENT_PUB.DO_ADJUSTMENT, x_return_status: '|| x_return_status);
857:
858: END IF;
859:
860: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
861:
862: -- Error processing TRX_TYPE transaction in Fixed Assets for asset ASSET_NUMBER in book BOOK.
863: OKC_API.set_message( p_app_name => 'OKL',
864: p_msg_name => 'OKL_AM_AMT_TRANS_FAILED',

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

859:
860: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
861:
862: -- Error processing TRX_TYPE transaction in Fixed Assets for asset ASSET_NUMBER in book BOOK.
863: OKC_API.set_message( p_app_name => 'OKL',
864: p_msg_name => 'OKL_AM_AMT_TRANS_FAILED',
865: p_token1 => 'TRX_TYPE',
866: p_token1_value => 'Contract Delink',
867: p_token2 => 'ASSET_NUMBER',

Line 929: p_init_msg_list => OKC_API.G_FALSE,

925: END IF;
926:
927: fa_adjustment_pub.do_adjustment(
928: p_api_version => p_api_version,
929: p_init_msg_list => OKC_API.G_FALSE,
930: p_commit => FND_API.G_FALSE,
931: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
932: p_calling_fn => NULL,
933: x_return_status => x_return_status,

Line 955: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

951: 'AFTER CALL TO FA_ADJUSTMENT_PUB.DO_ADJUSTMENT, x_return_status: '|| x_return_status);
952:
953: END IF;
954:
955: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
956:
957: -- Error processing TRX_TYPE transaction in Fixed Assets for asset ASSET_NUMBER in book BOOK.
958: OKC_API.set_message( p_app_name => 'OKL',
959: p_msg_name => 'OKL_AM_AMT_TRANS_FAILED',

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

954:
955: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
956:
957: -- Error processing TRX_TYPE transaction in Fixed Assets for asset ASSET_NUMBER in book BOOK.
958: OKC_API.set_message( p_app_name => 'OKL',
959: p_msg_name => 'OKL_AM_AMT_TRANS_FAILED',
960: p_token1 => 'TRX_TYPE',
961: p_token1_value => 'Contract Delink',
962: p_token2 => 'ASSET_NUMBER',

Line 1017: p_app_name => OKC_API.G_APP_NAME,

1013: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1014:
1015: -- Set the oracle error message
1016: OKL_API.set_message(
1017: p_app_name => OKC_API.G_APP_NAME,
1018: p_msg_name => g_unexpected_error,
1019: p_token1 => g_sqlcode_token,
1020: p_token1_value => SQLCODE,
1021: p_token2 => g_sqlerrm_token,

Line 1451: p_app_name => OKC_API.G_APP_NAME,

1447: px_tcnv_rec => px_tcnv_rec);
1448:
1449: -- Set the oracle error message
1450: OKL_API.set_message(
1451: p_app_name => OKC_API.G_APP_NAME,
1452: p_msg_name => g_unexpected_error,
1453: p_token1 => g_sqlcode_token,
1454: p_token1_value => SQLCODE,
1455: p_token2 => g_sqlerrm_token,

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

1540: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
1541: END IF;
1542:
1543: -- Set the oracle error message
1544: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,
1545: p_msg_name => g_unexpected_error,
1546: p_token1 => g_sqlcode_token,
1547: p_token1_value => SQLCODE,
1548: p_token2 => g_sqlerrm_token,

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

1614: CLOSE k_lines_csr;
1615: END IF;
1616:
1617: -- Set the oracle error message
1618: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,
1619: p_msg_name => g_unexpected_error,
1620: p_token1 => g_sqlcode_token,
1621: p_token1_value => SQLCODE,
1622: p_token2 => g_sqlerrm_token,

Line 1849: p_app_name => OKC_API.G_APP_NAME,

1845: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
1846: END IF;
1847:
1848: OKL_API.set_message(
1849: p_app_name => OKC_API.G_APP_NAME,
1850: p_msg_name => g_unexpected_error,
1851: p_token1 => g_sqlcode_token,
1852: p_token1_value => SQLCODE,
1853: p_token2 => g_sqlerrm_token,

Line 2027: p_app_name => OKC_API.G_APP_NAME,

2023: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
2024: END IF;
2025:
2026: OKL_API.set_message(
2027: p_app_name => OKC_API.G_APP_NAME,
2028: p_msg_name => g_unexpected_error,
2029: p_token1 => g_sqlcode_token,
2030: p_token1_value => SQLCODE,
2031: p_token2 => g_sqlerrm_token,

Line 2106: p_app_name => OKC_API.G_APP_NAME,

2102: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
2103: END IF;
2104:
2105: OKL_API.set_message(
2106: p_app_name => OKC_API.G_APP_NAME,
2107: p_msg_name => g_unexpected_error,
2108: p_token1 => g_sqlcode_token,
2109: p_token1_value => SQLCODE,
2110: p_token2 => g_sqlerrm_token,

Line 2206: p_app_name => OKC_API.G_APP_NAME,

2202: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
2203: END IF;
2204:
2205: OKL_API.set_message(
2206: p_app_name => OKC_API.G_APP_NAME,
2207: p_msg_name => g_unexpected_error,
2208: p_token1 => g_sqlcode_token,
2209: p_token1_value => SQLCODE,
2210: p_token2 => g_sqlerrm_token,

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

2353: IF (is_debug_exception_on) THEN
2354: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
2355: END IF;
2356:
2357: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,
2358: p_msg_name => g_unexpected_error,
2359: p_token1 => g_sqlcode_token,
2360: p_token1_value => SQLCODE,
2361: p_token2 => g_sqlerrm_token,

Line 3275: p_app_name => OKC_API.G_APP_NAME,

3271: px_tcnv_rec => px_tcnv_rec);
3272:
3273: -- Set the oracle error message
3274: OKL_API.set_message(
3275: p_app_name => OKC_API.G_APP_NAME,
3276: p_msg_name => g_unexpected_error,
3277: p_token1 => g_sqlcode_token,
3278: p_token1_value => SQLCODE,
3279: p_token2 => g_sqlerrm_token,

Line 4179: p_app_name => OKC_API.G_APP_NAME,

4175: px_tcnv_rec => px_tcnv_rec);
4176:
4177: -- Set the oracle error message
4178: OKL_API.set_message(
4179: p_app_name => OKC_API.G_APP_NAME,
4180: p_msg_name => g_unexpected_error,
4181: p_token1 => g_sqlcode_token,
4182: p_token1_value => SQLCODE,
4183: p_token2 => g_sqlerrm_token,

Line 4430: p_app_name => OKC_API.G_APP_NAME,

4426: px_tcnv_rec => px_tcnv_rec);
4427:
4428: -- Set the oracle error message
4429: OKL_API.set_message(
4430: p_app_name => OKC_API.G_APP_NAME,
4431: p_msg_name => g_unexpected_error,
4432: p_token1 => g_sqlcode_token,
4433: p_token1_value => SQLCODE,
4434: p_token2 => g_sqlerrm_token,

Line 4729: p_app_name => OKC_API.G_APP_NAME,

4725: px_tcnv_rec => px_tcnv_rec);
4726:
4727: -- Set the oracle error message
4728: OKL_API.set_message(
4729: p_app_name => OKC_API.G_APP_NAME,
4730: p_msg_name => g_unexpected_error,
4731: p_token1 => g_sqlcode_token,
4732: p_token1_value => SQLCODE,
4733: p_token2 => g_sqlerrm_token,

Line 6261: p_app_name => OKC_API.G_APP_NAME,

6257: px_tcnv_rec => px_tcnv_rec);
6258:
6259: -- Set the oracle error message
6260: OKL_API.set_message(
6261: p_app_name => OKC_API.G_APP_NAME,
6262: p_msg_name => g_unexpected_error,
6263: p_token1 => g_sqlcode_token,
6264: p_token1_value => SQLCODE,
6265: p_token2 => g_sqlerrm_token,

Line 7584: p_term_rec.p_termination_date = okc_api.g_miss_date

7580: lx_sty_id ,primary_sty_id_rec.kle_id )
7581: LOOP
7582:
7583: IF p_term_rec.p_termination_date IS NULL OR
7584: p_term_rec.p_termination_date = okc_api.g_miss_date
7585: THEN
7586: l_acceleration_rec.acceleration_date := l_valid_gl_date; --sysdate; -- rmunjulu EDAT
7587: ELSE
7588: l_acceleration_rec.acceleration_date := p_term_rec.p_termination_date;

Line 7592: l_accelerate_till_date = okc_api.g_miss_date

7588: l_acceleration_rec.acceleration_date := p_term_rec.p_termination_date;
7589: END IF;
7590:
7591: IF l_accelerate_till_date IS NULL OR
7592: l_accelerate_till_date = okc_api.g_miss_date
7593: THEN
7594: l_acceleration_rec.accelerate_till_date := p_term_rec.p_orig_end_date;
7595: ELSE
7596: l_acceleration_rec.accelerate_till_date := l_accelerate_till_date;

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

7997: p_tsu_code => 'ERROR',
7998: px_tcnv_rec => px_tcnv_rec);
7999:
8000: -- Set the oracle error message
8001: okl_api.set_message(p_app_name => okc_api.g_app_name,
8002: p_msg_name => g_unexpected_error,
8003: p_token1 => g_sqlcode_token,
8004: p_token1_value => SQLCODE,
8005: p_token2 => g_sqlerrm_token,

Line 8336: p_init_msg_list => okc_api.g_false,

8332: END IF;
8333:
8334: okl_okc_migration_pvt.update_contract_item(
8335: p_api_version => 1.0,
8336: p_init_msg_list => okc_api.g_false,
8337: x_return_status =>x_return_status,
8338: x_msg_count =>x_msg_count,
8339: x_msg_data =>x_msg_data,
8340: p_cimv_rec =>l_cim_rec,

Line 8589: p_init_msg_list => okc_api.g_false,

8585: l_fxlv_rec.asset_book_type_name := p_corporate_book;
8586:
8587: --call Populate sources api
8588: okl_sla_acc_sources_pvt.populate_sources(p_api_version => p_api_version,
8589: p_init_msg_list => okc_api.g_false,
8590: p_fxhv_rec => l_fxhv_rec,
8591: p_fxlv_rec => l_fxlv_rec,
8592: x_return_status => x_return_status,
8593: x_msg_count => x_msg_count,

Line 8953: p_init_msg_list => okc_api.g_false,

8949: END IF;
8950:
8951: okl_okc_migration_pvt.update_contract_item(
8952: p_api_version => 1.0,
8953: p_init_msg_list => okc_api.g_false,
8954: x_return_status =>x_return_status,
8955: x_msg_count =>x_msg_count,
8956: x_msg_data =>x_msg_data,
8957: p_cimv_rec =>l_cim_rec,

Line 9124: p_init_msg_list => OKC_API.G_FALSE,

9120:
9121:
9122: fa_adjustment_pub.do_adjustment(
9123: p_api_version => L_api_version,
9124: p_init_msg_list => OKC_API.G_FALSE,
9125: p_commit => FND_API.G_FALSE,
9126: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9127: p_calling_fn => NULL,
9128: x_return_status => x_return_status,

Line 9934: p_app_name => OKC_API.G_APP_NAME,

9930: px_tcnv_rec => px_tcnv_rec);
9931:
9932: -- Set the oracle error message
9933: OKL_API.set_message(
9934: p_app_name => OKC_API.G_APP_NAME,
9935: p_msg_name => g_unexpected_error,
9936: p_token1 => g_sqlcode_token,
9937: p_token1_value => SQLCODE,
9938: p_token2 => g_sqlerrm_token,

Line 10203: p_app_name => OKC_API.G_APP_NAME,

10199: px_tcnv_rec => px_tcnv_rec);
10200:
10201: -- Set the oracle error message
10202: OKL_API.set_message(
10203: p_app_name => OKC_API.G_APP_NAME,
10204: p_msg_name => g_unexpected_error,
10205: p_token1 => g_sqlcode_token,
10206: p_token1_value => SQLCODE,
10207: p_token2 => g_sqlerrm_token,

Line 10506: p_app_name => OKC_API.G_APP_NAME,

10502: px_tcnv_rec => px_tcnv_rec);
10503:
10504: -- Set the oracle error message
10505: OKL_API.set_message(
10506: p_app_name => OKC_API.G_APP_NAME,
10507: p_msg_name => g_unexpected_error,
10508: p_token1 => g_sqlcode_token,
10509: p_token1_value => SQLCODE,
10510: p_token2 => g_sqlerrm_token,

Line 10641: p_app_name => OKC_API.G_APP_NAME,

10637: px_tcnv_rec => px_tcnv_rec);
10638:
10639: -- Set the oracle error message
10640: OKL_API.set_message(
10641: p_app_name => OKC_API.G_APP_NAME,
10642: p_msg_name => g_unexpected_error,
10643: p_token1 => g_sqlcode_token,
10644: p_token1_value => SQLCODE,
10645: p_token2 => g_sqlerrm_token,

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

10707: l_auto_invoice_yn VARCHAR2(3);
10708: l_purchase_amount NUMBER;
10709: -- Added for bug# 6964174
10710: --start:| 05-29-08 cklee -- fixed bug: 7017824(R12)/OKL.H: bug#6964174 |
10711: l_is_securitized VARCHAR2(1) := OKC_API.G_FALSE;
10712: l_inv_agmt_chr_id_tbl OKL_SECURITIZATION_PVT.inv_agmt_chr_id_tbl_type;
10713: --end:| 05-29-08 cklee -- fixed bug: 7017824(R12)/OKL.H: bug#6964174 |
10714:
10715: -- asawanka added for debug feature start

Line 11296: IF l_is_securitized = OKC_API.G_TRUE THEN

11292: END IF;
11293:
11294: -- if contract is securitized, then call the modify pool contents. Prior to fix for bug# 6964174
11295: -- this was present in OKL_AM_SECURITIZATION_PVT.create_pool_transaction
11296: IF l_is_securitized = OKC_API.G_TRUE THEN
11297: OKL_SECURITIZATION_PVT.MODIFY_POOL_CONTENTS
11298: ( p_api_version => p_api_version
11299: ,p_init_msg_list => OKL_API.G_FALSE
11300: ,p_transaction_reason => OKL_SECURITIZATION_PVT.G_TRX_REASON_EARLY_TERMINATION