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: END IF;
915:
916:
917: l_tapv_rec.TRY_ID := p_trx_id ;

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

1628: and IPYB.territory_code = inr.ic_id
1629: AND IPYB.FACTOR_VALUE BETWEEN inr.FACTOR_RANGE_START AND inr.FACTOR_RANGE_END ;
1630:
1631:
1632: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
1633:
1634: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
1635: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1636: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

Line 1715: OKL_ACCOUNTING_UTIL.convert_to_functional_currency

1711: ELSE
1712:
1713: -- Covered amount from contract to functional
1714:
1715: OKL_ACCOUNTING_UTIL.convert_to_functional_currency
1716: (
1717: p_ipyv_rec.khr_id,
1718: l_functional_currency ,
1719: l_start_date,

Line 1728: okl_accounting_util.cross_currency_round_amount(p_amount =>

1724: x_currency_conversion_date,
1725: x_functional_covered_amt ) ;
1726:
1727: x_functional_covered_amt :=
1728: okl_accounting_util.cross_currency_round_amount(p_amount =>
1729: x_functional_covered_amt,
1730: p_currency_code => l_functional_currency);
1731:
1732: OPEN c_ins_opt_premium (x_functional_covered_amt);

Line 1742: OKL_ACCOUNTING_UTIL.convert_to_contract_currency

1738: RAISE OKC_API.G_EXCEPTION_ERROR;
1739: END if ;
1740:
1741: --- total lessor premium from functional to contract currency
1742: OKL_ACCOUNTING_UTIL.convert_to_contract_currency
1743: (
1744: p_ipyv_rec.khr_id,
1745: l_functional_currency,
1746: p_ipyv_rec.date_from,

Line 1755: okl_accounting_util.cross_currency_round_amount(p_amount =>

1751: x_currency_conversion_date,
1752: l_total_lessor_premium ) ;
1753:
1754: l_total_lessor_premium :=
1755: okl_accounting_util.cross_currency_round_amount(p_amount =>
1756: l_total_lessor_premium,
1757: p_currency_code => x_contract_currency);
1758:
1759: END IF ;

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

1876: -- GET TRANSACTION TYPE
1877: OPEN c_trx_type ('Disbursement', 'US');
1878: FETCH c_trx_type INTO l_trx_type_ID;
1879: IF(c_trx_type%NOTFOUND) THEN
1880: l_attribute_label := OKL_ACCOUNTING_UTIL.get_message_token('OKL_LA_SEC_INVESTOR','OKL_LA_SEC_BILL'); --3927315
1881: Okc_Api.set_message(G_APP_NAME, 'OKL_AM_NO_TRX_TYPE_FOUND',
1882: 'TRY_NAME',l_attribute_label); -- 3745151
1883: l_attribute_label := null;
1884: x_return_status := OKC_API.G_RET_STS_ERROR ;

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

2937: AND IPYB.date_from between inr.date_FROM and DECODE(NVL(inr.date_TO,NULL),NULL,SYSDATE, inr.date_TO)
2938: and IPYB.territory_code = inr.ic_id
2939: AND IPYB.FACTOR_VALUE BETWEEN inr.FACTOR_RANGE_START AND inr.FACTOR_RANGE_END ;
2940:
2941: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
2942: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
2943: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
2944: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
2945: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

Line 2989: OKL_ACCOUNTING_UTIL.convert_to_functional_currency

2985: CLOSE c_okl_ins_asset ;
2986:
2987: ELSE
2988: -- Covered amount from contract to functional
2989: OKL_ACCOUNTING_UTIL.convert_to_functional_currency
2990: (
2991: p_ipyv_rec.khr_id,
2992: l_functional_currency ,
2993: l_start_date,

Line 3001: okl_accounting_util.cross_currency_round_amount(p_amount =>

2997: x_currency_conversion_rate ,
2998: x_currency_conversion_date,
2999: x_functional_covered_amt ) ;
3000: x_functional_covered_amt :=
3001: okl_accounting_util.cross_currency_round_amount(p_amount =>
3002: x_functional_covered_amt,
3003: p_currency_code => l_functional_currency);
3004: OPEN c_ins_opt_premium (x_functional_covered_amt);
3005: FETCH c_ins_opt_premium INTO l_func_total_lessor_premium;

Line 3013: OKL_ACCOUNTING_UTIL.convert_to_contract_currency

3009: CLOSE c_ins_opt_premium ;
3010: RAISE OKC_API.G_EXCEPTION_ERROR;
3011: END if ;
3012: --- total lessor premium from functional to contract currency
3013: OKL_ACCOUNTING_UTIL.convert_to_contract_currency
3014: (
3015: p_ipyv_rec.khr_id,
3016: l_functional_currency,
3017: p_ipyv_rec.date_from,

Line 3025: okl_accounting_util.cross_currency_round_amount(p_amount =>

3021: x_currency_conversion_rate ,
3022: x_currency_conversion_date,
3023: l_total_lessor_premium ) ;
3024: l_total_lessor_premium :=
3025: okl_accounting_util.cross_currency_round_amount(p_amount =>
3026: l_total_lessor_premium,
3027: p_currency_code => x_contract_currency);
3028: END IF ;
3029: IF(p_ipyv_rec.ipf_code = 'MONTHLY') THEN

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

3142: -- GET TRANSACTION TYPE
3143: OPEN c_trx_type('Disbursement', 'US');
3144: FETCH c_trx_type INTO l_trx_type_ID;
3145: IF(c_trx_type%NOTFOUND) THEN
3146: l_attribute_label := OKL_ACCOUNTING_UTIL.get_message_token('OKL_LA_SEC_INVESTOR','OKL_LA_SEC_BILL'); --3927315
3147: Okc_Api.set_message(G_APP_NAME, 'OKL_AM_NO_TRX_TYPE_FOUND',
3148: 'TRY_NAME',l_attribute_label); --3745151
3149: l_attribute_label := null;
3150: x_return_status := OKC_API.G_RET_STS_ERROR ;

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

3540: SQLCODE, G_SQLERRM_TOKEN, SQLERRM);
3541: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR ;
3542: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR ;
3543: END;
3544: --- l_curr_code := OKL_ACCOUNTING_UTIL.GET_FUNC_CURR_CODE;
3545:
3546: IF (l_adjustment_amount <> 0 ) THEN
3547:
3548: -- header data

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

3711: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_STREAM_TYPE', G_PURPOSE_TOKEN,'INSURANCE_INCOME_ACCRUAL'); --bug 4024785
3712: RAISE OKC_API.G_EXCEPTION_ERROR;
3713: END IF;
3714:
3715: l_gl_date := OKL_ACCOUNTING_UTIL.get_valid_gl_date(p_gl_date => l_ipyv_rec.CANCELLATION_DATE);
3716: l_ins_acc_adj := fnd_message.get_string('OKL','OKL_INS_INC_ACC_ADJ');
3717: if(l_ins_acc_adj IS NULL) then
3718: l_ins_acc_adj := 'Insurance income accrual adjustment';
3719: end if;

Line 3776: l_sob_id := Okl_Accounting_Util.GET_SET_OF_BOOKS_ID(

3772: 'INSURANCE_INCOME_ACCRUAL',
3773: l_return_status,
3774: l_inc_sty_id_rep);
3775: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
3776: l_sob_id := Okl_Accounting_Util.GET_SET_OF_BOOKS_ID(
3777: p_representation_type => 'SECONDARY');
3778: 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
3779: l_ins_acc_adj := fnd_message.get_string('OKL','OKL_INS_INC_ACC_ADJ');
3780: if(l_ins_acc_adj IS NULL) then

Line 3778: 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

3774: l_inc_sty_id_rep);
3775: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
3776: l_sob_id := Okl_Accounting_Util.GET_SET_OF_BOOKS_ID(
3777: p_representation_type => 'SECONDARY');
3778: 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
3779: l_ins_acc_adj := fnd_message.get_string('OKL','OKL_INS_INC_ACC_ADJ');
3780: if(l_ins_acc_adj IS NULL) then
3781: l_ins_acc_adj := 'Insurance income accrual adjustment';
3782: end if;

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

4340: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_STREAM_TYPE', G_PURPOSE_TOKEN,'INSURANCE_INCOME_ACCRUAL'); --bug 4024785
4341: RAISE OKC_API.G_EXCEPTION_ERROR;
4342: END IF;
4343:
4344: l_gl_date := OKL_ACCOUNTING_UTIL.get_valid_gl_date(p_gl_date => l_ipyv_rec.CANCELLATION_DATE);
4345: l_ins_acc_adj := fnd_message.get_string('OKL','OKL_INS_EXP_ACC_ADJ');
4346: if(l_ins_acc_adj IS NULL) then
4347: l_ins_acc_adj := 'Insurance expense accrual adjustment';
4348: end if;

Line 4408: l_sob_id := Okl_Accounting_Util.GET_SET_OF_BOOKS_ID(

4404: l_return_status,
4405: l_inc_sty_id_rep);
4406: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4407:
4408: l_sob_id := Okl_Accounting_Util.GET_SET_OF_BOOKS_ID(
4409: p_representation_type => 'SECONDARY');
4410: l_gl_date := OKL_ACCOUNTING_UTIL.get_valid_gl_date(p_gl_date => l_ipyv_rec.CANCELLATION_DATE, p_ledger_id => l_sob_id);
4411: l_ins_acc_adj := fnd_message.get_string('OKL','OKL_INS_EXP_ACC_ADJ');
4412: if(l_ins_acc_adj IS NULL) then

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

4406: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4407:
4408: l_sob_id := Okl_Accounting_Util.GET_SET_OF_BOOKS_ID(
4409: p_representation_type => 'SECONDARY');
4410: l_gl_date := OKL_ACCOUNTING_UTIL.get_valid_gl_date(p_gl_date => l_ipyv_rec.CANCELLATION_DATE, p_ledger_id => l_sob_id);
4411: l_ins_acc_adj := fnd_message.get_string('OKL','OKL_INS_EXP_ACC_ADJ');
4412: if(l_ins_acc_adj IS NULL) then
4413: l_ins_acc_adj := 'Insurance expense accrual adjustment';
4414: end if;

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

6365: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR ;
6366: END;
6367:
6368:
6369: --- l_curr_code := OKL_ACCOUNTING_UTIL.GET_FUNC_CURR_CODE;
6370:
6371: /* Bug#5955320
6372: IF (l_adjustment_amount <> 0 ) THEN
6373: