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_INSURANCE_POLICIES_PVT dependencies on OKL_ACCOUNTING_UTIL

Line 590: l_tapv_rec.SET_OF_BOOKS_ID := OKL_ACCOUNTING_UTIL.get_set_of_books_id; --smoduga fix for bug 4238141

586:
587: l_tapv_rec.TAP_ID_REVERSES := OKC_API.G_MISS_NUM ;
588: l_tapv_rec.INVOICE_TYPE := 'STANDARD';
589: -- GET SET OF BOOK
590: l_tapv_rec.SET_OF_BOOKS_ID := OKL_ACCOUNTING_UTIL.get_set_of_books_id; --smoduga fix for bug 4238141
591:
592: END IF;
593:
594: l_tapv_rec.TRY_ID := p_trx_id ;

Line 913: l_tapv_rec.SET_OF_BOOKS_ID := OKL_ACCOUNTING_UTIL.get_set_of_books_id; --smoduga fix for bug 4238141

909: CLOSE C_CURRENCY;
910: l_tapv_rec.TAP_ID_REVERSES := OKC_API.G_MISS_NUM ;
911: l_tapv_rec.INVOICE_TYPE := 'STANDARD';
912: -- GET SET OF BOOK
913: l_tapv_rec.SET_OF_BOOKS_ID := OKL_ACCOUNTING_UTIL.get_set_of_books_id; --smoduga fix for bug 4238141
914:
915: --Fix for bug#13433145 Start
916:
917: OPEN c_trx_type ('Debit Memo', 'US');

Line 1651: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;

1647: and IPYB.territory_code = inr.ic_id
1648: AND IPYB.FACTOR_VALUE BETWEEN inr.FACTOR_RANGE_START AND inr.FACTOR_RANGE_END ;
1649:
1650:
1651: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
1652:
1653: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
1654: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1655: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

Line 1734: OKL_ACCOUNTING_UTIL.convert_to_functional_currency

1730: ELSE
1731:
1732: -- Covered amount from contract to functional
1733:
1734: OKL_ACCOUNTING_UTIL.convert_to_functional_currency
1735: (
1736: p_ipyv_rec.khr_id,
1737: l_functional_currency ,
1738: l_start_date,

Line 1747: okl_accounting_util.cross_currency_round_amount(p_amount =>

1743: x_currency_conversion_date,
1744: x_functional_covered_amt ) ;
1745:
1746: x_functional_covered_amt :=
1747: okl_accounting_util.cross_currency_round_amount(p_amount =>
1748: x_functional_covered_amt,
1749: p_currency_code => l_functional_currency);
1750:
1751: OPEN c_ins_opt_premium (x_functional_covered_amt);

Line 1761: OKL_ACCOUNTING_UTIL.convert_to_contract_currency

1757: RAISE OKC_API.G_EXCEPTION_ERROR;
1758: END if ;
1759:
1760: --- total lessor premium from functional to contract currency
1761: OKL_ACCOUNTING_UTIL.convert_to_contract_currency
1762: (
1763: p_ipyv_rec.khr_id,
1764: l_functional_currency,
1765: p_ipyv_rec.date_from,

Line 1774: okl_accounting_util.cross_currency_round_amount(p_amount =>

1770: x_currency_conversion_date,
1771: l_total_lessor_premium ) ;
1772:
1773: l_total_lessor_premium :=
1774: okl_accounting_util.cross_currency_round_amount(p_amount =>
1775: l_total_lessor_premium,
1776: p_currency_code => x_contract_currency);
1777:
1778: END IF ;

Line 1899: l_attribute_label := OKL_ACCOUNTING_UTIL.get_message_token('OKL_LA_SEC_INVESTOR','OKL_LA_SEC_BILL'); --3927315

1895: -- GET TRANSACTION TYPE
1896: OPEN c_trx_type ('Disbursement', 'US');
1897: FETCH c_trx_type INTO l_trx_type_ID;
1898: IF(c_trx_type%NOTFOUND) THEN
1899: l_attribute_label := OKL_ACCOUNTING_UTIL.get_message_token('OKL_LA_SEC_INVESTOR','OKL_LA_SEC_BILL'); --3927315
1900: Okc_Api.set_message(G_APP_NAME, 'OKL_AM_NO_TRX_TYPE_FOUND',
1901: 'TRY_NAME',l_attribute_label); -- 3745151
1902: l_attribute_label := null;
1903: x_return_status := OKC_API.G_RET_STS_ERROR ;

Line 2960: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;

2956: AND IPYB.date_from between inr.date_FROM and DECODE(NVL(inr.date_TO,NULL),NULL,SYSDATE, inr.date_TO)
2957: and IPYB.territory_code = inr.ic_id
2958: AND IPYB.FACTOR_VALUE BETWEEN inr.FACTOR_RANGE_START AND inr.FACTOR_RANGE_END ;
2959:
2960: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
2961: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
2962: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
2963: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
2964: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

Line 3008: OKL_ACCOUNTING_UTIL.convert_to_functional_currency

3004: CLOSE c_okl_ins_asset ;
3005:
3006: ELSE
3007: -- Covered amount from contract to functional
3008: OKL_ACCOUNTING_UTIL.convert_to_functional_currency
3009: (
3010: p_ipyv_rec.khr_id,
3011: l_functional_currency ,
3012: l_start_date,

Line 3020: okl_accounting_util.cross_currency_round_amount(p_amount =>

3016: x_currency_conversion_rate ,
3017: x_currency_conversion_date,
3018: x_functional_covered_amt ) ;
3019: x_functional_covered_amt :=
3020: okl_accounting_util.cross_currency_round_amount(p_amount =>
3021: x_functional_covered_amt,
3022: p_currency_code => l_functional_currency);
3023: OPEN c_ins_opt_premium (x_functional_covered_amt);
3024: FETCH c_ins_opt_premium INTO l_func_total_lessor_premium;

Line 3032: OKL_ACCOUNTING_UTIL.convert_to_contract_currency

3028: CLOSE c_ins_opt_premium ;
3029: RAISE OKC_API.G_EXCEPTION_ERROR;
3030: END if ;
3031: --- total lessor premium from functional to contract currency
3032: OKL_ACCOUNTING_UTIL.convert_to_contract_currency
3033: (
3034: p_ipyv_rec.khr_id,
3035: l_functional_currency,
3036: p_ipyv_rec.date_from,

Line 3044: okl_accounting_util.cross_currency_round_amount(p_amount =>

3040: x_currency_conversion_rate ,
3041: x_currency_conversion_date,
3042: l_total_lessor_premium ) ;
3043: l_total_lessor_premium :=
3044: okl_accounting_util.cross_currency_round_amount(p_amount =>
3045: l_total_lessor_premium,
3046: p_currency_code => x_contract_currency);
3047: END IF ;
3048: IF(p_ipyv_rec.ipf_code = 'MONTHLY') THEN

Line 3165: l_attribute_label := OKL_ACCOUNTING_UTIL.get_message_token('OKL_LA_SEC_INVESTOR','OKL_LA_SEC_BILL'); --3927315

3161: -- GET TRANSACTION TYPE
3162: OPEN c_trx_type('Disbursement', 'US');
3163: FETCH c_trx_type INTO l_trx_type_ID;
3164: IF(c_trx_type%NOTFOUND) THEN
3165: l_attribute_label := OKL_ACCOUNTING_UTIL.get_message_token('OKL_LA_SEC_INVESTOR','OKL_LA_SEC_BILL'); --3927315
3166: Okc_Api.set_message(G_APP_NAME, 'OKL_AM_NO_TRX_TYPE_FOUND',
3167: 'TRY_NAME',l_attribute_label); --3745151
3168: l_attribute_label := null;
3169: x_return_status := OKC_API.G_RET_STS_ERROR ;

Line 3566: --- l_curr_code := OKL_ACCOUNTING_UTIL.GET_FUNC_CURR_CODE;

3562: SQLCODE, G_SQLERRM_TOKEN, SQLERRM);
3563: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR ;
3564: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR ;
3565: END;
3566: --- l_curr_code := OKL_ACCOUNTING_UTIL.GET_FUNC_CURR_CODE;
3567:
3568: IF (l_adjustment_amount <> 0 ) THEN
3569:
3570: -- header data

Line 3737: l_gl_date := OKL_ACCOUNTING_UTIL.get_valid_gl_date(p_gl_date => l_ipyv_rec.CANCELLATION_DATE);

3733: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_STREAM_TYPE', G_PURPOSE_TOKEN,'INSURANCE_INCOME_ACCRUAL'); --bug 4024785
3734: RAISE OKC_API.G_EXCEPTION_ERROR;
3735: END IF;
3736:
3737: l_gl_date := OKL_ACCOUNTING_UTIL.get_valid_gl_date(p_gl_date => l_ipyv_rec.CANCELLATION_DATE);
3738: l_ins_acc_adj := fnd_message.get_string('OKL','OKL_INS_INC_ACC_ADJ');
3739: if(l_ins_acc_adj IS NULL) then
3740: l_ins_acc_adj := 'Insurance income accrual adjustment';
3741: end if;

Line 3799: l_sob_id := Okl_Accounting_Util.GET_SET_OF_BOOKS_ID(

3795: 'INSURANCE_INCOME_ACCRUAL',
3796: l_return_status,
3797: l_inc_sty_id_rep);
3798: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
3799: l_sob_id := Okl_Accounting_Util.GET_SET_OF_BOOKS_ID(
3800: p_representation_type => 'SECONDARY');
3801: l_gl_date := OKL_ACCOUNTING_UTIL.get_valid_gl_date(p_gl_date => l_ipyv_rec.CANCELLATION_DATE, p_ledger_id => l_sob_id); --MGAAP 7263041
3802: l_ins_acc_adj := fnd_message.get_string('OKL','OKL_INS_INC_ACC_ADJ');
3803: if(l_ins_acc_adj IS NULL) then

Line 3801: l_gl_date := OKL_ACCOUNTING_UTIL.get_valid_gl_date(p_gl_date => l_ipyv_rec.CANCELLATION_DATE, p_ledger_id => l_sob_id); --MGAAP 7263041

3797: l_inc_sty_id_rep);
3798: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
3799: l_sob_id := Okl_Accounting_Util.GET_SET_OF_BOOKS_ID(
3800: p_representation_type => 'SECONDARY');
3801: l_gl_date := OKL_ACCOUNTING_UTIL.get_valid_gl_date(p_gl_date => l_ipyv_rec.CANCELLATION_DATE, p_ledger_id => l_sob_id); --MGAAP 7263041
3802: l_ins_acc_adj := fnd_message.get_string('OKL','OKL_INS_INC_ACC_ADJ');
3803: if(l_ins_acc_adj IS NULL) then
3804: l_ins_acc_adj := 'Insurance income accrual adjustment';
3805: end if;

Line 4372: l_gl_date := OKL_ACCOUNTING_UTIL.get_valid_gl_date(p_gl_date => l_ipyv_rec.CANCELLATION_DATE);

4368: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_STREAM_TYPE', G_PURPOSE_TOKEN,'INSURANCE_INCOME_ACCRUAL'); --bug 4024785
4369: RAISE OKC_API.G_EXCEPTION_ERROR;
4370: END IF;
4371:
4372: l_gl_date := OKL_ACCOUNTING_UTIL.get_valid_gl_date(p_gl_date => l_ipyv_rec.CANCELLATION_DATE);
4373: l_ins_acc_adj := fnd_message.get_string('OKL','OKL_INS_EXP_ACC_ADJ');
4374: if(l_ins_acc_adj IS NULL) then
4375: l_ins_acc_adj := 'Insurance expense accrual adjustment';
4376: end if;

Line 4437: l_sob_id := Okl_Accounting_Util.GET_SET_OF_BOOKS_ID(

4433: l_return_status,
4434: l_inc_sty_id_rep);
4435: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4436:
4437: l_sob_id := Okl_Accounting_Util.GET_SET_OF_BOOKS_ID(
4438: p_representation_type => 'SECONDARY');
4439: l_gl_date := OKL_ACCOUNTING_UTIL.get_valid_gl_date(p_gl_date => l_ipyv_rec.CANCELLATION_DATE, p_ledger_id => l_sob_id);
4440: l_ins_acc_adj := fnd_message.get_string('OKL','OKL_INS_EXP_ACC_ADJ');
4441: if(l_ins_acc_adj IS NULL) then

Line 4439: l_gl_date := OKL_ACCOUNTING_UTIL.get_valid_gl_date(p_gl_date => l_ipyv_rec.CANCELLATION_DATE, p_ledger_id => l_sob_id);

4435: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4436:
4437: l_sob_id := Okl_Accounting_Util.GET_SET_OF_BOOKS_ID(
4438: p_representation_type => 'SECONDARY');
4439: l_gl_date := OKL_ACCOUNTING_UTIL.get_valid_gl_date(p_gl_date => l_ipyv_rec.CANCELLATION_DATE, p_ledger_id => l_sob_id);
4440: l_ins_acc_adj := fnd_message.get_string('OKL','OKL_INS_EXP_ACC_ADJ');
4441: if(l_ins_acc_adj IS NULL) then
4442: l_ins_acc_adj := 'Insurance expense accrual adjustment';
4443: end if;

Line 6362: --- l_curr_code := OKL_ACCOUNTING_UTIL.GET_FUNC_CURR_CODE;

6358: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR ;
6359: END;
6360:
6361:
6362: --- l_curr_code := OKL_ACCOUNTING_UTIL.GET_FUNC_CURR_CODE;
6363:
6364: /* Bug#5955320
6365: IF (l_adjustment_amount <> 0 ) THEN
6366: