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

Line 209: l_orcl_logo := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_ACCT_LEASE_MANAGEMENT');

205:
206: l_success := success_message_table.COUNT;
207: l_error := error_message_table.COUNT;
208:
209: l_orcl_logo := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_ACCT_LEASE_MANAGEMENT');
210: --l_term_heading := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_AM_TERM_INV');
211:
212: l_term_heading := 'Balance Writeoff for Terminated and Expired Contracts';
213:

Line 210: --l_term_heading := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_AM_TERM_INV');

206: l_success := success_message_table.COUNT;
207: l_error := error_message_table.COUNT;
208:
209: l_orcl_logo := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_ACCT_LEASE_MANAGEMENT');
210: --l_term_heading := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_AM_TERM_INV');
211:
212: l_term_heading := 'Balance Writeoff for Terminated and Expired Contracts';
213:
214: l_set_of_books := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_SET_OF_BOOKS');

Line 214: l_set_of_books := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_SET_OF_BOOKS');

210: --l_term_heading := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_AM_TERM_INV');
211:
212: l_term_heading := 'Balance Writeoff for Terminated and Expired Contracts';
213:
214: l_set_of_books := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_SET_OF_BOOKS');
215: l_run_date := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_RUN_DATE');
216: l_oper_unit := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_OPERUNIT');
217: l_type := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_TYPE');
218: l_processed := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_PROCESSED_ENTRIES');

Line 215: l_run_date := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_RUN_DATE');

211:
212: l_term_heading := 'Balance Writeoff for Terminated and Expired Contracts';
213:
214: l_set_of_books := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_SET_OF_BOOKS');
215: l_run_date := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_RUN_DATE');
216: l_oper_unit := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_OPERUNIT');
217: l_type := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_TYPE');
218: l_processed := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_PROCESSED_ENTRIES');
219: --l_term_k := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_AM_TERMINATED_INV');

Line 216: l_oper_unit := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_OPERUNIT');

212: l_term_heading := 'Balance Writeoff for Terminated and Expired Contracts';
213:
214: l_set_of_books := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_SET_OF_BOOKS');
215: l_run_date := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_RUN_DATE');
216: l_oper_unit := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_OPERUNIT');
217: l_type := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_TYPE');
218: l_processed := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_PROCESSED_ENTRIES');
219: --l_term_k := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_AM_TERMINATED_INV');
220:

Line 217: l_type := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_TYPE');

213:
214: l_set_of_books := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_SET_OF_BOOKS');
215: l_run_date := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_RUN_DATE');
216: l_oper_unit := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_OPERUNIT');
217: l_type := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_TYPE');
218: l_processed := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_PROCESSED_ENTRIES');
219: --l_term_k := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_AM_TERMINATED_INV');
220:
221: l_term_k := 'Successful Writeoffs';

Line 218: l_processed := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_PROCESSED_ENTRIES');

214: l_set_of_books := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_SET_OF_BOOKS');
215: l_run_date := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_RUN_DATE');
216: l_oper_unit := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_OPERUNIT');
217: l_type := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_TYPE');
218: l_processed := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_PROCESSED_ENTRIES');
219: --l_term_k := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_AM_TERMINATED_INV');
220:
221: l_term_k := 'Successful Writeoffs';
222:

Line 219: --l_term_k := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_AM_TERMINATED_INV');

215: l_run_date := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_RUN_DATE');
216: l_oper_unit := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_OPERUNIT');
217: l_type := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_TYPE');
218: l_processed := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_PROCESSED_ENTRIES');
219: --l_term_k := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_AM_TERMINATED_INV');
220:
221: l_term_k := 'Successful Writeoffs';
222:
223: --l_error_k := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_AM_ERRORED_INV');

Line 223: --l_error_k := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_AM_ERRORED_INV');

219: --l_term_k := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_AM_TERMINATED_INV');
220:
221: l_term_k := 'Successful Writeoffs';
222:
223: --l_error_k := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_AM_ERRORED_INV');
224:
225: l_error_k := 'Errored Writeoffs';
226:
227: l_serial := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_SERIAL_NUMBER');

Line 227: l_serial := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_SERIAL_NUMBER');

223: --l_error_k := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_AM_ERRORED_INV');
224:
225: l_error_k := 'Errored Writeoffs';
226:
227: l_serial := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_SERIAL_NUMBER');
228: --l_k_num := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_INV_AGR_NUM');
229:
230: l_k_num := 'Contract Number';
231: l_start_date := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_START_DATE');

Line 228: --l_k_num := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_INV_AGR_NUM');

224:
225: l_error_k := 'Errored Writeoffs';
226:
227: l_serial := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_SERIAL_NUMBER');
228: --l_k_num := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_INV_AGR_NUM');
229:
230: l_k_num := 'Contract Number';
231: l_start_date := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_START_DATE');
232: l_end_date := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_END_DATE');

Line 231: l_start_date := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_START_DATE');

227: l_serial := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_SERIAL_NUMBER');
228: --l_k_num := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_INV_AGR_NUM');
229:
230: l_k_num := 'Contract Number';
231: l_start_date := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_START_DATE');
232: l_end_date := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_END_DATE');
233: --l_status := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_STATUS');
234:
235: l_status := 'Contract Status';

Line 232: l_end_date := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_END_DATE');

228: --l_k_num := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_INV_AGR_NUM');
229:
230: l_k_num := 'Contract Number';
231: l_start_date := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_START_DATE');
232: l_end_date := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_END_DATE');
233: --l_status := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_STATUS');
234:
235: l_status := 'Contract Status';
236:

Line 233: --l_status := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_STATUS');

229:
230: l_k_num := 'Contract Number';
231: l_start_date := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_START_DATE');
232: l_end_date := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_END_DATE');
233: --l_status := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_STATUS');
234:
235: l_status := 'Contract Status';
236:
237: l_messages := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_MESSAGES');

Line 237: l_messages := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_MESSAGES');

233: --l_status := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_STATUS');
234:
235: l_status := 'Contract Status';
236:
237: l_messages := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_MESSAGES');
238: l_eop := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_END_OF_REPORT');
239: -- l_inv_ended_by := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_AM_INV_AGR_ENDED_BY');
240:
241: l_inv_ended_by := 'Contracts Ended By';

Line 238: l_eop := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_END_OF_REPORT');

234:
235: l_status := 'Contract Status';
236:
237: l_messages := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_MESSAGES');
238: l_eop := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_END_OF_REPORT');
239: -- l_inv_ended_by := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_AM_INV_AGR_ENDED_BY');
240:
241: l_inv_ended_by := 'Contracts Ended By';
242:

Line 239: -- l_inv_ended_by := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_AM_INV_AGR_ENDED_BY');

235: l_status := 'Contract Status';
236:
237: l_messages := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_MESSAGES');
238: l_eop := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_END_OF_REPORT');
239: -- l_inv_ended_by := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_AM_INV_AGR_ENDED_BY');
240:
241: l_inv_ended_by := 'Contracts Ended By';
242:
243: l_inv := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_AM_INVALID_TERM_DATE');

Line 243: l_inv := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_AM_INVALID_TERM_DATE');

239: -- l_inv_ended_by := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_AM_INV_AGR_ENDED_BY');
240:
241: l_inv_ended_by := 'Contracts Ended By';
242:
243: l_inv := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_AM_INVALID_TERM_DATE');
244:
245: l_set_of_books_name := OKL_ACCOUNTING_UTIL.get_set_of_books_name (OKL_ACCOUNTING_UTIL.get_set_of_books_id);
246:
247: -- Get the Org Name

Line 245: l_set_of_books_name := OKL_ACCOUNTING_UTIL.get_set_of_books_name (OKL_ACCOUNTING_UTIL.get_set_of_books_id);

241: l_inv_ended_by := 'Contracts Ended By';
242:
243: l_inv := OKL_ACCOUNTING_UTIL.get_message_token('OKL_AM_CONC_OUTPUT','OKL_AM_INVALID_TERM_DATE');
244:
245: l_set_of_books_name := OKL_ACCOUNTING_UTIL.get_set_of_books_name (OKL_ACCOUNTING_UTIL.get_set_of_books_id);
246:
247: -- Get the Org Name
248: FOR org_rec IN org_csr (l_org_id) LOOP
249: l_org_name := org_rec.name;

Line 905: -- OKL_ACCOUNTING_UTIL.convert_to_functional_currency and get back

901: l_converted_amount NUMBER;
902:
903: -- Since we do not use the amount or converted amount
904: -- set a hardcoded value for the amount (and pass to to
905: -- OKL_ACCOUNTING_UTIL.convert_to_functional_currency and get back
906: -- conversion values )
907: l_hard_coded_amount CONSTANT NUMBER := 100;
908:
909: lp_ajlv_rec OKL_TXL_ADJSTS_LNS_PUB.ajlv_rec_type;

Line 1103: OKL_ACCOUNTING_UTIL.convert_to_functional_currency(

1099:
1100: -- *** CONVERT CURRENCIES **************************** START ****
1101:
1102: -- Get the currency conversion details from ACCOUNTING_Util
1103: OKL_ACCOUNTING_UTIL.convert_to_functional_currency(
1104: p_khr_id => p_khr_rec.id,
1105: p_to_currency => l_functional_currency_code,
1106: p_transaction_date => p_sys_date, -- rmunjulu EDAT
1107: p_amount => l_hard_coded_amount,

Line 1114: -- If error from OKL_ACCOUNTING_UTIL

1110: x_currency_conversion_type => l_currency_conversion_type,
1111: x_currency_conversion_rate => l_currency_conversion_rate,
1112: x_currency_conversion_date => l_currency_conversion_date,
1113: x_converted_amount => l_converted_amount);
1114: -- If error from OKL_ACCOUNTING_UTIL
1115: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1116:
1117: -- Error occurred when creating accounting entries for
1118: -- transaction TRX_TYPE.

Line 1490: l_formatted_adj_amt := OKL_ACCOUNTING_UTIL.format_amount(

1486: END IF;
1487: END IF;
1488: -- ******** UPDATE TRN LINE WITH CCID ************* END ******
1489: -- Format the adjustment amt
1490: l_formatted_adj_amt := OKL_ACCOUNTING_UTIL.format_amount(
1491: ajlv_id_tbl(i).amount,
1492: l_currency_code);
1493:
1494: -- Append adjustment amt with currency code

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

1525: -- Get the currency code for contract
1526: l_currency_code := OKL_AM_UTIL_PVT.get_chr_currency(p_khr_rec.id);
1527:
1528: -- Format the balance amt
1529: l_formatted_bal_amt := OKL_ACCOUNTING_UTIL.format_amount(l_total_amount_due,l_currency_code);
1530:
1531: -- Append balance amt with currency code
1532: l_formatted_bal_amt := l_formatted_bal_amt || ' ' ||l_currency_code;
1533:

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

1531: -- Append balance amt with currency code
1532: l_formatted_bal_amt := l_formatted_bal_amt || ' ' ||l_currency_code;
1533:
1534: -- Format the tolerance amt
1535: l_formatted_tol_amt := OKL_ACCOUNTING_UTIL.format_amount(l_tolerance_amt,l_currency_code);
1536:
1537: -- Append tolerance amt with currency code
1538: l_formatted_tol_amt := l_formatted_tol_amt || ' ' ||l_currency_code;
1539: