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

Line 417: l_func_currency_code := Okl_Accounting_Util.GET_FUNC_CURR_CODE;

413: RAISE OKL_API.G_EXCEPTION_ERROR;
414: END IF;
415:
416: -- retrieve the functional currency code
417: l_func_currency_code := Okl_Accounting_Util.GET_FUNC_CURR_CODE;
418: IF l_func_currency_code IS NULL THEN
419: RAISE OKL_API.G_EXCEPTION_ERROR;
420: END IF;
421:

Line 426: OKL_ACCOUNTING_UTIL.convert_to_contract_currency

422: l_original_amt := calculate_cntrct_nbv (p_cntrct_id => p_cntrct_id);
423:
424: -- convert NBV to contract currency. Bug 2712001
425: IF l_func_currency_code <> l_khr_currency_code THEN
426: OKL_ACCOUNTING_UTIL.convert_to_contract_currency
427: (p_khr_id => p_cntrct_id,
428: p_from_currency => l_func_currency_code,
429: p_transaction_date => l_loss_date,
430: p_amount => l_original_amt,

Line 461: Okl_Accounting_Util.GET_PERIOD_INFO(l_loss_date,l_period_name,l_period_start_date,l_period_end_date);

457: -- if rev_rec_method is 'STREAMS' then use the period start and end dates else use
458: -- the last interest calc date and get the principal balance.. racheruv. Bug 6342556
459: IF l_rev_rec_method_code = 'STREAMS' THEN
460: -- Get period end date for principal balance
461: Okl_Accounting_Util.GET_PERIOD_INFO(l_loss_date,l_period_name,l_period_start_date,l_period_end_date);
462: l_capital_bal := get_contract_principal_balance(p_cntrct_id => p_cntrct_id
463: ,p_period_start_date => l_period_start_date
464: ,p_period_end_date => l_period_end_date);
465:

Line 1071: l_outer_error_msg_tbl Okl_Accounting_Util.ERROR_MESSAGE_TYPE;

1067: TYPE date_tbl_type IS TABLE OF DATE INDEX BY BINARY_INTEGER;
1068: l_int_calc_date_tbl date_tbl_type;
1069:
1070: l_contract_error_tbl contract_error_tbl_type;
1071: l_outer_error_msg_tbl Okl_Accounting_Util.ERROR_MESSAGE_TYPE;
1072: l_bktv_tbl bucket_tbl_type;
1073: l_pdt_contracts_rec pdt_contracts_rec_type;
1074: l_pdt_contracts_tbl pdt_contracts_tbl_type;
1075: pool_contents_tbl pool_contents_tbl_type;

Line 1280: l_set_of_books_id := OKL_ACCOUNTING_UTIL.GET_SET_OF_BOOKS_ID;

1276:
1277: BEGIN
1278:
1279: -- get the set of books id
1280: l_set_of_books_id := OKL_ACCOUNTING_UTIL.GET_SET_OF_BOOKS_ID;
1281: IF (l_set_of_books_id IS NULL) THEN
1282: Okl_Api.set_message(p_app_name => g_app_name,
1283: p_msg_name => 'OKL_AGN_SOB_ID_ERROR');
1284: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1288: l_sob_name := Okl_Accounting_Util.GET_SET_OF_BOOKS_NAME(l_set_of_books_id);

1284: RAISE OKL_API.G_EXCEPTION_ERROR;
1285: END IF;
1286:
1287: -- Find set of books name for report
1288: l_sob_name := Okl_Accounting_Util.GET_SET_OF_BOOKS_NAME(l_set_of_books_id);
1289:
1290: -- Find org name for report
1291: l_org_id := mo_global.get_current_org_id();
1292: IF l_org_id IS NULL THEN

Line 1314: Okl_Accounting_Util.GET_PERIOD_INFO(l_entry_date,l_period_name,l_period_start_date,l_period_end_date);

1310: RAISE OKL_API.G_EXCEPTION_ERROR;
1311: END IF;
1312:
1313: -- Get Period info for PB
1314: Okl_Accounting_Util.GET_PERIOD_INFO(l_entry_date,l_period_name,l_period_start_date,l_period_end_date);
1315: IF l_period_name IS NULL THEN
1316: Okl_Api.set_message(p_app_name => g_app_name,
1317: p_msg_name => 'OKL_AGN_PERIOD_END_DATE');
1318: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 1323: l_period_status := Okl_Accounting_Util.GET_OKL_PERIOD_STATUS(l_period_name);

1319: END IF;
1320:
1321: --Bug# 2781593
1322: -- check for open period
1323: l_period_status := Okl_Accounting_Util.GET_OKL_PERIOD_STATUS(l_period_name);
1324: IF l_period_status IS NULL THEN
1325: Okl_Api.set_message(p_app_name => g_app_name,
1326: p_msg_name => 'OKL_AGN_PERIOD_STATUS_ERROR',
1327: p_token1 => 'PERIOD_NAME',

Line 1358: l_func_currency_code := Okl_Accounting_Util.GET_FUNC_CURR_CODE;

1354: RAISE Okl_Api.G_EXCEPTION_ERROR;
1355: END IF;
1356:
1357: -- Find currency code for the set of books id
1358: l_func_currency_code := Okl_Accounting_Util.GET_FUNC_CURR_CODE;
1359: IF (l_func_currency_code IS NULL) THEN
1360: -- store SQL error message on message stack for caller
1361: Okl_Api.set_message(p_app_name => g_app_name,
1362: p_msg_name => 'OKL_AGN_CURR_CODE_ERROR');

Line 1535: -- creating variable required by okl_accounting_util.convert_to_contract_currency

1531: l_sty_id OKL_TXL_CNTRCT_LNS.STY_ID%TYPE; --:= to_number(p_sty_id);
1532: l_sty_name OKL_STRM_TYPE_V.NAME%TYPE;
1533:
1534:
1535: -- creating variable required by okl_accounting_util.convert_to_contract_currency
1536: -- these variables not used anywhere.
1537: x_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
1538: x_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
1539: x_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;

Line 1548: l_error_msg_tbl Okl_Accounting_Util.ERROR_MESSAGE_TYPE;

1544: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
1545: x_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
1546: x_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
1547: l_lprv_rec OKL_REV_LOSS_PROV_PUB.lprv_rec_type;
1548: l_error_msg_tbl Okl_Accounting_Util.ERROR_MESSAGE_TYPE;
1549:
1550: -- Begin a new PL/SQL block to trap errors related to a praticular contract and to move on to the next contract
1551: BEGIN
1552:

Line 1624: l_currency_conv_rate := OKL_ACCOUNTING_UTIL.get_curr_con_rate

1620: -- );
1621: -- RAISE Okl_Api.G_EXCEPTION_ERROR;
1622: -- END IF;
1623: -- CLOSE currency_conv_csr;
1624: l_currency_conv_rate := OKL_ACCOUNTING_UTIL.get_curr_con_rate
1625: (p_from_curr_code => l_khr_currency_code,
1626: p_to_curr_code => l_func_currency_code,
1627: p_con_date => l_entry_date,--Bug 6970675
1628: p_con_type => l_currency_conv_type);

Line 1682: OKL_ACCOUNTING_UTIL.convert_to_contract_currency

1678:
1679: -- convert NBV to contract currency. Bug 2712001
1680: IF l_net_book_value <> 0 THEN
1681: IF l_func_currency_code <> l_khr_currency_code THEN
1682: OKL_ACCOUNTING_UTIL.convert_to_contract_currency
1683: (p_khr_id => l_cntrct_id,
1684: p_from_currency => l_func_currency_code,
1685: p_transaction_date => l_entry_date,
1686: p_amount => l_net_book_value,

Line 2108: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',x_tcnv_rec.tax_deductible_local,0,0),23)||

2104: END IF;
2105:
2106: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_cntrct_number,28)||
2107: RPAD(x_tcnv_rec.trx_number,22)||
2108: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',x_tcnv_rec.tax_deductible_local,0,0),23)||
2109: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',x_tcnv_rec.tax_deductible_corporate,0,0),26)||
2110: RPAD(x_tcnv_rec.currency_code,9)||
2111: -- Bug# 2774187. Commenting precision as accounting util takes care of formatting.
2112: --LPAD(x_tcnv_rec.amount,17));

Line 2109: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',x_tcnv_rec.tax_deductible_corporate,0,0),26)||

2105:
2106: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_cntrct_number,28)||
2107: RPAD(x_tcnv_rec.trx_number,22)||
2108: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',x_tcnv_rec.tax_deductible_local,0,0),23)||
2109: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',x_tcnv_rec.tax_deductible_corporate,0,0),26)||
2110: RPAD(x_tcnv_rec.currency_code,9)||
2111: -- Bug# 2774187. Commenting precision as accounting util takes care of formatting.
2112: --LPAD(x_tcnv_rec.amount,17));
2113: LPAD(Okl_Accounting_Util.FORMAT_AMOUNT(x_tcnv_rec.amount,x_tcnv_rec.currency_code),17));

Line 2113: LPAD(Okl_Accounting_Util.FORMAT_AMOUNT(x_tcnv_rec.amount,x_tcnv_rec.currency_code),17));

2109: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',x_tcnv_rec.tax_deductible_corporate,0,0),26)||
2110: RPAD(x_tcnv_rec.currency_code,9)||
2111: -- Bug# 2774187. Commenting precision as accounting util takes care of formatting.
2112: --LPAD(x_tcnv_rec.amount,17));
2113: LPAD(Okl_Accounting_Util.FORMAT_AMOUNT(x_tcnv_rec.amount,x_tcnv_rec.currency_code),17));
2114: END IF;
2115: END IF; -- end if for contract did not have a specific loss trx
2116: EXCEPTION
2117:

Line 2123: l_error_cnt := l_error_cnt + 1; Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_tbl);

2119: l_return_status := Okl_Api.G_RET_STS_ERROR;
2120: -- Select the contract for error reporting
2121: FND_FILE.PUT_LINE(FND_FILE.LOG,l_cntrct_number||', '||'Error Status: '||l_return_status);
2122: l_contract_error_tbl(l_error_cnt) := l_cntrct_number;
2123: l_error_cnt := l_error_cnt + 1; Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_tbl);
2124: IF (l_error_msg_tbl.COUNT > 0) THEN
2125: FOR i IN l_error_msg_tbl.FIRST..l_error_msg_tbl.LAST
2126: LOOP
2127: IF l_error_msg_tbl(i) IS NOT NULL THEN

Line 2140: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_tbl);

2136: -- Select the contract for error reporting
2137: FND_FILE.PUT_LINE(FND_FILE.LOG,l_cntrct_number||', '||'Error Status: '||l_return_status);
2138: l_contract_error_tbl(l_error_cnt) := l_cntrct_number;
2139: l_error_cnt := l_error_cnt + 1;
2140: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_tbl);
2141: IF (l_error_msg_tbl.COUNT > 0) THEN
2142: FOR i IN l_error_msg_tbl.FIRST..l_error_msg_tbl.LAST
2143: LOOP
2144: IF l_error_msg_tbl(i) IS NOT NULL THEN

Line 2173: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_tbl);

2169: -- Select the contract for error reporting
2170: FND_FILE.PUT_LINE(FND_FILE.LOG,l_cntrct_number||', '||'Error Status: '||l_return_status);
2171: l_contract_error_tbl(l_error_cnt) := l_cntrct_number;
2172: l_error_cnt := l_error_cnt + 1;
2173: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_tbl);
2174: IF (l_error_msg_tbl.COUNT > 0) THEN
2175: FOR i IN l_error_msg_tbl.FIRST..l_error_msg_tbl.LAST
2176: LOOP
2177: IF l_error_msg_tbl(i) IS NOT NULL THEN

Line 2213: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);

2209: l_return_status := Okl_Api.G_RET_STS_ERROR;
2210:
2211: -- print the overall status in the log file
2212: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Overall Program Status = '||l_return_status);
2213: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
2214: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
2215: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST
2216: LOOP
2217: IF l_outer_error_msg_tbl(i) IS NOT NULL THEN

Line 2229: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);

2225: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2226:
2227: -- print the overall status in the log file
2228: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Overall Program Status = '||l_return_status);
2229: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
2230: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
2231: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST
2232: LOOP
2233: IF l_outer_error_msg_tbl(i) IS NOT NULL THEN

Line 2266: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);

2262: errbuf := SQLERRM;
2263: retcode := 2;
2264: -- print the overall status in the log file
2265: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Overall Program Status = '||l_return_status);
2266: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
2267: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
2268: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST
2269: LOOP
2270: IF l_outer_error_msg_tbl(i) IS NOT NULL THEN

Line 2492: Okl_Accounting_Util.GET_PERIOD_INFO(p_slpv_rec.provision_date,l_period_name,l_period_start_date,l_period_end_date);

2488: -- END LOOP;
2489: --END IF;
2490:
2491: -- get period info
2492: Okl_Accounting_Util.GET_PERIOD_INFO(p_slpv_rec.provision_date,l_period_name,l_period_start_date,l_period_end_date);
2493: IF l_period_name IS NULL THEN
2494: Okl_Api.set_message(p_app_name => g_app_name,
2495: p_msg_name => 'OKL_AGN_PERIOD_END_DATE');
2496: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 2500: l_period_status := Okl_Accounting_Util.GET_OKL_PERIOD_STATUS(l_period_name);

2496: RAISE Okl_Api.G_EXCEPTION_ERROR;
2497: END IF;
2498:
2499: -- check for open period
2500: l_period_status := Okl_Accounting_Util.GET_OKL_PERIOD_STATUS(l_period_name);
2501: IF l_period_status IS NULL THEN
2502: Okl_Api.set_message(p_app_name => g_app_name,
2503: p_msg_name => 'OKL_AGN_PERIOD_STATUS_ERROR',
2504: p_token1 => 'PERIOD_NAME',

Line 2516: l_set_of_books_id := OKL_ACCOUNTING_UTIL.GET_SET_OF_BOOKS_ID;

2512: RAISE Okl_Api.G_EXCEPTION_ERROR;
2513: END IF;
2514:
2515: -- get the set of books id
2516: l_set_of_books_id := OKL_ACCOUNTING_UTIL.GET_SET_OF_BOOKS_ID;
2517: IF l_set_of_books_id IS NULL THEN
2518: Okl_Api.set_message(p_app_name => g_app_name,
2519: p_msg_name => 'OKL_AGN_SOB_ID_ERROR');
2520: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 2534: l_func_currency_code := Okl_Accounting_Util.GET_FUNC_CURR_CODE;

2530: RAISE OKL_API.G_EXCEPTION_ERROR;
2531: END IF;
2532:
2533: -- retrieve the functional currency code
2534: l_func_currency_code := Okl_Accounting_Util.GET_FUNC_CURR_CODE;
2535: IF l_func_currency_code IS NULL THEN
2536: Okl_Api.set_message(p_app_name => g_app_name,
2537: p_msg_name => 'OKL_AGN_CURR_CODE_ERROR');
2538: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 2597: l_currency_conv_rate := OKL_ACCOUNTING_UTIL.get_curr_con_rate

2593: -- );
2594: -- RAISE Okl_Api.G_EXCEPTION_ERROR;
2595: -- END IF;
2596: -- CLOSE currency_conv_csr;
2597: l_currency_conv_rate := OKL_ACCOUNTING_UTIL.get_curr_con_rate
2598: (p_from_curr_code => l_khr_currency_code,
2599: p_to_curr_code => l_func_currency_code,
2600: p_con_date => p_slpv_rec.provision_date, -- Bug 6970654
2601: p_con_type => l_currency_conv_type);