DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on OKL_ACCOUNTING_UTIL

Line 4657: -- OKL_ACCOUNTING_UTIL.convert_to_functional_currency and get back

4653: l_converted_amount NUMBER;
4654:
4655: -- Since we do not use the amount or converted amount
4656: -- set a hardcoded value for the amount (and pass to to
4657: -- OKL_ACCOUNTING_UTIL.convert_to_functional_currency and get back
4658: -- conversion values )
4659: l_hard_coded_amount NUMBER := 100;
4660:
4661: -- ansethur 23-FEB-07 R12B Added for Billing Enhancement Project Start Changes

Line 4750: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_ACCOUNTING_UTIL.convert_to_functional_currency');

4746:
4747: -- Get the functional currency from AM_Util
4748: l_functional_currency_code := OKL_AM_UTIL_PVT.get_functional_currency();
4749: IF (is_debug_statement_on) THEN
4750: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_ACCOUNTING_UTIL.convert_to_functional_currency');
4751: END IF;
4752: -- Get the currency conversion details from ACCOUNTING_Util
4753: OKL_ACCOUNTING_UTIL.convert_to_functional_currency(
4754: p_khr_id => p_term_rec.p_contract_id,

Line 4753: OKL_ACCOUNTING_UTIL.convert_to_functional_currency(

4749: IF (is_debug_statement_on) THEN
4750: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_ACCOUNTING_UTIL.convert_to_functional_currency');
4751: END IF;
4752: -- Get the currency conversion details from ACCOUNTING_Util
4753: OKL_ACCOUNTING_UTIL.convert_to_functional_currency(
4754: p_khr_id => p_term_rec.p_contract_id,
4755: p_to_currency => l_functional_currency_code,
4756: p_transaction_date => l_quote_accpt_date, -- rmunjulu EDAT
4757: p_amount => l_hard_coded_amount,

Line 4765: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Called OKL_ACCOUNTING_UTIL.convert_to_functional_currency l_return_status ='||l_return_status);

4761: x_currency_conversion_rate => l_currency_conversion_rate,
4762: x_currency_conversion_date => l_currency_conversion_date,
4763: x_converted_amount => l_converted_amount);
4764: IF (is_debug_statement_on) THEN
4765: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Called OKL_ACCOUNTING_UTIL.convert_to_functional_currency l_return_status ='||l_return_status);
4766: END IF;
4767:
4768: -- Set some of the taiv rec attributes
4769: l_taiv_rec.currency_code := l_contract_currency_code;

Line 5031: l_formatted_inv_amt := OKL_ACCOUNTING_UTIL.format_amount(

5027: --ansethur 23-FEB-2007 commented for R12 B Billing Architecture Ends
5028: */
5029: --ansethur 23-FEB-2007 Added for R12 B Billing Architecture End Changes
5030: -- Format the invoice amt
5031: l_formatted_inv_amt := OKL_ACCOUNTING_UTIL.format_amount(
5032: p_amount => l_invoice_amount,
5033: p_currency_code => l_curr_code);
5034:
5035: -- Asset ASSET_NUMBER of Contract CONTRACT_NUMBER is invoiced with amount AMOUNT.

Line 5280: -- OKL_ACCOUNTING_UTIL.convert_to_functional_currency and get back

5276: l_converted_amount NUMBER;
5277:
5278: -- Since we do not use the amount or converted amount
5279: -- set a hardcoded value for the amount (and pass to to
5280: -- OKL_ACCOUNTING_UTIL.convert_to_functional_currency and get back
5281: -- conversion values )
5282: l_hard_coded_amount NUMBER := 100;
5283:
5284: -- RMUNJULU 3596626

Line 5563: OKL_ACCOUNTING_UTIL.convert_to_functional_currency(

5559: -- Get the functional currency from AM_Util
5560: l_functional_currency_code := OKL_AM_UTIL_PVT.get_functional_currency;
5561:
5562: -- Get the currency conversion details from ACCOUNTING_Util
5563: OKL_ACCOUNTING_UTIL.convert_to_functional_currency(
5564: p_khr_id => p_term_rec.p_contract_id,
5565: p_to_currency => l_functional_currency_code,
5566: p_transaction_date => l_quote_accpt_date, -- rmunjulu EDAT
5567: p_amount => l_hard_coded_amount,

Line 5576: -- If error from OKL_ACCOUNTING_UTIL

5572: x_currency_conversion_date => l_currency_conversion_date,
5573: x_converted_amount => l_converted_amount);
5574:
5575:
5576: -- If error from OKL_ACCOUNTING_UTIL
5577: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
5578:
5579: -- Error occurred when creating accounting entries for
5580: -- transaction TRX_TYPE.

Line 5879: l_formatted_adj_amt := OKL_ACCOUNTING_UTIL.format_amount(

5875: -- Set all success messages for all balances
5876: FOR k_bal_lns_rec IN k_bal_lns_csr ( p_term_rec.p_contract_id, l_quote_eff_date) LOOP -- rmunjulu EDAT
5877:
5878: -- Format the adjustment amt
5879: l_formatted_adj_amt := OKL_ACCOUNTING_UTIL.format_amount(
5880: k_bal_lns_rec.amount,
5881: l_currency_code);
5882:
5883: -- Append adjustment amt with currency code

Line 5931: l_formatted_bal_amt := OKL_ACCOUNTING_UTIL.format_amount(l_total_amount_due,l_currency_code);

5927: -- Get the currency code for contract
5928: l_currency_code := OKL_AM_UTIL_PVT.get_chr_currency(p_term_rec.p_contract_id);
5929:
5930: -- Format the balance amt
5931: l_formatted_bal_amt := OKL_ACCOUNTING_UTIL.format_amount(l_total_amount_due,l_currency_code);
5932:
5933: -- Append balance amt with currency code
5934: l_formatted_bal_amt := l_formatted_bal_amt || ' ' ||l_currency_code;
5935:

Line 5937: l_formatted_tol_amt := OKL_ACCOUNTING_UTIL.format_amount(l_tolerance_amt,l_currency_code);

5933: -- Append balance amt with currency code
5934: l_formatted_bal_amt := l_formatted_bal_amt || ' ' ||l_currency_code;
5935:
5936: -- Format the tolerance amt
5937: l_formatted_tol_amt := OKL_ACCOUNTING_UTIL.format_amount(l_tolerance_amt,l_currency_code);
5938:
5939: -- Append tolerance amt with currency code
5940: l_formatted_tol_amt := l_formatted_tol_amt || ' ' ||l_currency_code;
5941:

Line 6218: -- OKL_ACCOUNTING_UTIL.convert_to_functional_currency and get back

6214: l_converted_amount NUMBER;
6215:
6216: -- Since we do not use the amount or converted amount
6217: -- set a hardcoded value for the amount (and pass to to
6218: -- OKL_ACCOUNTING_UTIL.convert_to_functional_currency and get back
6219: -- conversion values )
6220: l_hard_coded_amount NUMBER := 100;
6221:
6222: -- Bug 2902876

Line 6563: l_valid_gl_date := okl_accounting_util.get_valid_gl_date(p_gl_date => l_quote_accpt_date); -- rmunjulu EDAT

6559: lip_tmpl_identify_rec.memo_yn := g_no;
6560: lip_tmpl_identify_rec.prior_year_yn := g_no;
6561:
6562: -- Bug 2902876 Added to get the valid GL date
6563: l_valid_gl_date := okl_accounting_util.get_valid_gl_date(p_gl_date => l_quote_accpt_date); -- rmunjulu EDAT
6564:
6565: IF (is_debug_statement_on) THEN
6566: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_securitization_pvt.check_khr_ia_associated');
6567: END IF;

Line 6643: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_accounting_util.convert_to_functional_currency');

6639: THEN
6640: --akrangan Bug 6147049 code fix end
6641: -- Get the currency conversion details from ACCOUNTING_Util
6642: IF (is_debug_statement_on) THEN
6643: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_accounting_util.convert_to_functional_currency');
6644: END IF;
6645: okl_accounting_util.convert_to_functional_currency(
6646: p_khr_id => p_term_rec.p_contract_id,
6647: p_to_currency => l_functional_currency_code,

Line 6645: okl_accounting_util.convert_to_functional_currency(

6641: -- Get the currency conversion details from ACCOUNTING_Util
6642: IF (is_debug_statement_on) THEN
6643: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_accounting_util.convert_to_functional_currency');
6644: END IF;
6645: okl_accounting_util.convert_to_functional_currency(
6646: p_khr_id => p_term_rec.p_contract_id,
6647: p_to_currency => l_functional_currency_code,
6648: p_transaction_date => l_quote_accpt_date, -- rmunjulu EDAT
6649: p_amount => l_hard_coded_amount,

Line 6658: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'called okl_accounting_util.convert_to_functional_currency l_return_status = '||l_return_status);

6654: x_currency_conversion_date => l_currency_conversion_date,
6655: x_converted_amount => l_converted_amount
6656: );
6657: IF (is_debug_statement_on) THEN
6658: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'called okl_accounting_util.convert_to_functional_currency l_return_status = '||l_return_status);
6659: END IF;
6660: -- If error from OKL_ACCOUNTING_UTIL
6661: IF l_return_status <> okl_api.g_ret_sts_success
6662: THEN

Line 6660: -- If error from OKL_ACCOUNTING_UTIL

6656: );
6657: IF (is_debug_statement_on) THEN
6658: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'called okl_accounting_util.convert_to_functional_currency l_return_status = '||l_return_status);
6659: END IF;
6660: -- If error from OKL_ACCOUNTING_UTIL
6661: IF l_return_status <> okl_api.g_ret_sts_success
6662: THEN
6663:
6664: -- Error occurred when creating accounting entries for

Line 6914: lip_tcnv_rec.set_of_books_id := okl_accounting_util.get_set_of_books_id();

6910: --call the update trx contract api to update amount per stream type
6911: lip_tcnv_rec := px_tcnv_rec;
6912: --set all the necessary attributes of the record type
6913: lip_tcnv_rec.amount := 0;
6914: lip_tcnv_rec.set_of_books_id := okl_accounting_util.get_set_of_books_id();
6915: --akrangan bug 6147049 fix start
6916: lip_tcnv_rec.currency_conversion_rate := l_currency_conversion_rate;
6917: lip_tcnv_rec.currency_conversion_type := l_currency_conversion_type;
6918: lip_tcnv_rec.currency_conversion_date := l_currency_conversion_date;

Line 7142: l_sob_id_rep := Okl_Accounting_Util.GET_SET_OF_BOOKS_ID(

7138: -- MGAAP 7263041 start
7139:
7140: IF (l_multi_gaap_yn = 'Y') THEN
7141:
7142: l_sob_id_rep := Okl_Accounting_Util.GET_SET_OF_BOOKS_ID(
7143: p_representation_type => 'SECONDARY');
7144:
7145: l_valid_gl_date_rep :=
7146: okl_accounting_util.get_valid_gl_date (

Line 7146: okl_accounting_util.get_valid_gl_date (

7142: l_sob_id_rep := Okl_Accounting_Util.GET_SET_OF_BOOKS_ID(
7143: p_representation_type => 'SECONDARY');
7144:
7145: l_valid_gl_date_rep :=
7146: okl_accounting_util.get_valid_gl_date (
7147: p_gl_date => l_quote_accpt_date,
7148: p_ledger_id => l_sob_id_rep
7149: );
7150:

Line 8008: l_set_of_books_id := OKL_ACCOUNTING_UTIL.GET_SET_OF_BOOKS_ID;

8004: FETCH c_asset_ret_dtls INTO l_asset_ret_dtls;
8005: CLOSE c_asset_ret_dtls;
8006: l_oec := l_asset_ret_dtls.asset_fmv_amount;
8007:
8008: l_set_of_books_id := OKL_ACCOUNTING_UTIL.GET_SET_OF_BOOKS_ID;
8009:
8010: /*IF (p_tax_book_2 IS NOT NULL AND p_tax_book_2 <> OKL_API.G_MISS_CHAR)
8011: THEN
8012: l_max_books := 3;

Line 8622: l_set_of_books_id := OKL_ACCOUNTING_UTIL.GET_SET_OF_BOOKS_ID;

8618: FETCH c_asset_ret_dtls INTO l_asset_ret_dtls;
8619: CLOSE c_asset_ret_dtls;
8620: l_oec := l_asset_ret_dtls.asset_fmv_amount;
8621:
8622: l_set_of_books_id := OKL_ACCOUNTING_UTIL.GET_SET_OF_BOOKS_ID;
8623:
8624: /*IF (p_tax_book_2 IS NOT NULL AND p_tax_book_2 <> OKL_API.G_MISS_CHAR)
8625: THEN
8626: l_max_books := 3;

Line 9459: okl_accounting_util.convert_to_functional_currency(

9455: l_contract_curr_code := okl_am_util_pvt.get_chr_currency( p_chr_id => p_term_rec.p_contract_id);
9456:
9457: IF l_contract_curr_code <> l_func_curr_code THEN
9458: -- convert amount to functional currency
9459: okl_accounting_util.convert_to_functional_currency(
9460: p_khr_id => p_term_rec.p_contract_id,
9461: p_to_currency => l_func_curr_code,
9462: p_transaction_date => l_quote_accpt_date , --px_tcnv_rec.date_transaction_occurred, -- rmunjulu EDAT
9463: p_amount => l_proceeds_of_sale,