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_LEASE_TRMNT_PVT dependencies on OKL_AM_UTIL_PVT

Line 233: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Calling OKL_AM_UTIL_PVT.get_rule_record');

229:
230: -- Check if Automatically Invoice YN is Y
231: IF (is_debug_statement_on) THEN
232: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'p_term_rec.p_quote_id = '||p_term_rec.p_quote_id);
233: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Calling OKL_AM_UTIL_PVT.get_rule_record');
234: END IF;
235: OKL_AM_UTIL_PVT.get_rule_record(
236: p_rgd_code => l_rgd_code,
237: p_rdf_code => l_rule_code,

Line 235: OKL_AM_UTIL_PVT.get_rule_record(

231: IF (is_debug_statement_on) THEN
232: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'p_term_rec.p_quote_id = '||p_term_rec.p_quote_id);
233: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Calling OKL_AM_UTIL_PVT.get_rule_record');
234: END IF;
235: OKL_AM_UTIL_PVT.get_rule_record(
236: p_rgd_code => l_rgd_code,
237: p_rdf_code => l_rule_code,
238: p_chr_id => l_khr_id,
239: p_cle_id => NULL,

Line 245: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Called OKL_AM_UTIL_PVT.get_rule_record l_return_status = '||l_return_status);

241: x_return_status => l_return_status,
242: p_message_yn => TRUE);
243:
244: IF (is_debug_statement_on) THEN
245: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Called OKL_AM_UTIL_PVT.get_rule_record l_return_status = '||l_return_status);
246: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_rulv_rec.rule_information1 = '||l_rulv_rec.rule_information1);
247: END IF;
248: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN
249: l_auto_invoce_yn := nvl(l_rulv_rec.rule_information1,'N'); -- Automatically Invoice YN, NULL is considered N

Line 333: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Called OKL_AM_UTIL_PVT.get_rule_record l_return_status = '||l_return_status);

329: l_rule_code := 'AMBPOC'; -- Purchase Options
330: IF (is_debug_statement_on) THEN
331: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'p_term_rec.p_contract_id = '||p_term_rec.p_contract_id);
332: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'p_kle_id = '||p_kle_id);
333: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Called OKL_AM_UTIL_PVT.get_rule_record l_return_status = '||l_return_status);
334: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_rulv_rec.rule_information1 = '||l_rulv_rec.rule_information1);
335: END IF;
336: l_khr_id := p_term_rec.p_contract_id;
337: IF (is_debug_statement_on) THEN

Line 338: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Calling OKL_AM_UTIL_PVT.get_rule_record');

334: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_rulv_rec.rule_information1 = '||l_rulv_rec.rule_information1);
335: END IF;
336: l_khr_id := p_term_rec.p_contract_id;
337: IF (is_debug_statement_on) THEN
338: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Calling OKL_AM_UTIL_PVT.get_rule_record');
339: END IF;
340: -- Get End of Term Purchase Amount Details
341: OKL_AM_UTIL_PVT.get_rule_record(
342: p_rgd_code => l_rgd_code,

Line 341: OKL_AM_UTIL_PVT.get_rule_record(

337: IF (is_debug_statement_on) THEN
338: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Calling OKL_AM_UTIL_PVT.get_rule_record');
339: END IF;
340: -- Get End of Term Purchase Amount Details
341: OKL_AM_UTIL_PVT.get_rule_record(
342: p_rgd_code => l_rgd_code,
343: p_rdf_code => l_rule_code,
344: p_chr_id => l_khr_id,
345: p_cle_id => NULL,

Line 351: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Called OKL_AM_UTIL_PVT.get_rule_record l_return_status = '||l_return_status);

347: x_return_status => l_return_status,
348: p_message_yn => TRUE);
349:
350: IF (is_debug_statement_on) THEN
351: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Called OKL_AM_UTIL_PVT.get_rule_record l_return_status = '||l_return_status);
352: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_rulv_rec.rule_information1 = '||l_rulv_rec.rule_information1);
353: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_rulv_rec.rule_information2 = '||l_rulv_rec.rule_information2);
354: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_rulv_rec.rule_information3 = '||l_rulv_rec.rule_information3);
355: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_rulv_rec.rule_information4 = '||l_rulv_rec.rule_information4);

Line 378: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Calling OKL_AM_UTIL_PVT.get_formula_value');

374:
375: ELSIF l_calc_option = 'USE_FORMULA' THEN -- Purchase Amount is FORMULA
376:
377: IF (is_debug_statement_on) THEN
378: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Calling OKL_AM_UTIL_PVT.get_formula_value');
379: END IF;
380: -- Get the formula value
381: OKL_AM_UTIL_PVT.get_formula_value (
382: p_formula_name => l_formula_name,

Line 381: OKL_AM_UTIL_PVT.get_formula_value (

377: IF (is_debug_statement_on) THEN
378: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Calling OKL_AM_UTIL_PVT.get_formula_value');
379: END IF;
380: -- Get the formula value
381: OKL_AM_UTIL_PVT.get_formula_value (
382: p_formula_name => l_formula_name,
383: p_chr_id => l_khr_id,
384: p_cle_id => p_kle_id,
385: p_additional_parameters => l_params,

Line 389: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Called OKL_AM_UTIL_PVT.get_formula_value l_return_status = '||l_return_status);

385: p_additional_parameters => l_params,
386: x_formula_value => l_formula_value,
387: x_return_status => l_return_status);
388: IF (is_debug_statement_on) THEN
389: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Called OKL_AM_UTIL_PVT.get_formula_value l_return_status = '||l_return_status);
390: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_formula_value = '||l_formula_value);
391: END IF;
392:
393: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

Line 404: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Calling OKL_AM_UTIL_PVT.get_formula_value');

400: IF l_prorate = 'PRORATE' AND l_purchase_amount <> 0 THEN
401:
402: -- Get line oec (evaluate formula contract_oec and pass line id)
403: IF (is_debug_statement_on) THEN
404: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Calling OKL_AM_UTIL_PVT.get_formula_value');
405: END IF;
406: OKL_AM_UTIL_PVT.get_formula_value (
407: p_formula_name => 'CONTRACT_OEC',
408: p_chr_id => l_khr_id,

Line 406: OKL_AM_UTIL_PVT.get_formula_value (

402: -- Get line oec (evaluate formula contract_oec and pass line id)
403: IF (is_debug_statement_on) THEN
404: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Calling OKL_AM_UTIL_PVT.get_formula_value');
405: END IF;
406: OKL_AM_UTIL_PVT.get_formula_value (
407: p_formula_name => 'CONTRACT_OEC',
408: p_chr_id => l_khr_id,
409: p_cle_id => p_kle_id,
410: p_additional_parameters => l_params,

Line 414: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Called OKL_AM_UTIL_PVT.get_formula_value l_return_status = '||l_return_status);

410: p_additional_parameters => l_params,
411: x_formula_value => l_line_oec,
412: x_return_status => l_return_status);
413: IF (is_debug_statement_on) THEN
414: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Called OKL_AM_UTIL_PVT.get_formula_value l_return_status = '||l_return_status);
415: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_formula_value = '||l_formula_value);
416: END IF;
417:
418: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

Line 424: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Calling OKL_AM_UTIL_PVT.get_formula_value');

420: END IF;
421:
422: -- Get contract oec
423: IF (is_debug_statement_on) THEN
424: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Calling OKL_AM_UTIL_PVT.get_formula_value');
425: END IF;
426: OKL_AM_UTIL_PVT.get_formula_value (
427: p_formula_name => 'CONTRACT_OEC',
428: p_chr_id => l_khr_id,

Line 426: OKL_AM_UTIL_PVT.get_formula_value (

422: -- Get contract oec
423: IF (is_debug_statement_on) THEN
424: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Calling OKL_AM_UTIL_PVT.get_formula_value');
425: END IF;
426: OKL_AM_UTIL_PVT.get_formula_value (
427: p_formula_name => 'CONTRACT_OEC',
428: p_chr_id => l_khr_id,
429: p_cle_id => NULL,
430: p_additional_parameters => l_params,

Line 434: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Called OKL_AM_UTIL_PVT.get_formula_value l_return_status = '||l_return_status);

430: p_additional_parameters => l_params,
431: x_formula_value => l_contract_oec,
432: x_return_status => l_return_status);
433: IF (is_debug_statement_on) THEN
434: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Called OKL_AM_UTIL_PVT.get_formula_value l_return_status = '||l_return_status);
435: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_formula_value = '||l_formula_value);
436: END IF;
437:
438:

Line 520: OKL_AM_UTIL_PVT.get_rule_record(

516:
517: l_khr_id := p_term_rec.p_contract_id;
518:
519: -- Get End of Term Purchase Amount Details
520: OKL_AM_UTIL_PVT.get_rule_record(
521: p_rgd_code => l_rgd_code,
522: p_rdf_code => l_rule_code,
523: p_chr_id => l_khr_id,
524: p_cle_id => NULL,

Line 549: OKL_AM_UTIL_PVT.get_formula_value (

545:
546: ELSIF l_calc_option = 'USE_FORMULA' THEN -- Purchase Amount is FORMULA
547:
548: -- Get the formula value
549: OKL_AM_UTIL_PVT.get_formula_value (
550: p_formula_name => l_formula_name,
551: p_chr_id => l_khr_id,
552: p_cle_id => null,
553: p_additional_parameters => l_params,

Line 1493: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record p_term_rec.p_contract_id = '||p_term_rec.p_contract_id);

1489: IF (is_debug_procedure_on) THEN
1490: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1491: END IF;
1492: IF (is_debug_statement_on) THEN
1493: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record p_term_rec.p_contract_id = '||p_term_rec.p_contract_id);
1494: END IF;
1495: OKL_AM_UTIL_PVT.get_rule_record(
1496: p_rgd_code => 'LAEVEL',
1497: p_rdf_code => l_rule_code,

Line 1495: OKL_AM_UTIL_PVT.get_rule_record(

1491: END IF;
1492: IF (is_debug_statement_on) THEN
1493: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record p_term_rec.p_contract_id = '||p_term_rec.p_contract_id);
1494: END IF;
1495: OKL_AM_UTIL_PVT.get_rule_record(
1496: p_rgd_code => 'LAEVEL',
1497: p_rdf_code => l_rule_code,
1498: p_chr_id => p_term_rec.p_contract_id,
1499: p_cle_id => NULL,

Line 1504: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record l_return_status = '||l_return_status);

1500: x_rulv_rec => l_rulv_rec,
1501: x_return_status => l_return_status,
1502: p_message_yn => FALSE);
1503: IF (is_debug_statement_on) THEN
1504: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record l_return_status = '||l_return_status);
1505: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_rulv_rec.rule_information1 = '||l_rulv_rec.rule_information1);
1506: END IF;
1507: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN
1508: IF (NVL (l_rulv_rec.rule_information1, '*') = G_YES) THEN

Line 1761: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_AM_UTIL_PVT.get_transaction_id ');

1757: END IF;
1758: --akrangan bug 5354501 fix end
1759: -- Get the Transaction Id
1760: IF (is_debug_statement_on) THEN
1761: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_AM_UTIL_PVT.get_transaction_id ');
1762: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'l_try_name = '||l_try_name);
1763: END IF;
1764: OKL_AM_UTIL_PVT.get_transaction_id (
1765: p_try_name => l_try_name , --akrangan bug 5354501 fix added l_try_name

Line 1764: OKL_AM_UTIL_PVT.get_transaction_id (

1760: IF (is_debug_statement_on) THEN
1761: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_AM_UTIL_PVT.get_transaction_id ');
1762: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'l_try_name = '||l_try_name);
1763: END IF;
1764: OKL_AM_UTIL_PVT.get_transaction_id (
1765: p_try_name => l_try_name , --akrangan bug 5354501 fix added l_try_name
1766: x_return_status => l_return_status,
1767: x_try_id => l_try_id);
1768: IF (is_debug_statement_on) THEN

Line 1769: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Called OKL_AM_UTIL_PVT.get_transaction_id l_return_status = '||l_return_status);

1765: p_try_name => l_try_name , --akrangan bug 5354501 fix added l_try_name
1766: x_return_status => l_return_status,
1767: x_try_id => l_try_id);
1768: IF (is_debug_statement_on) THEN
1769: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Called OKL_AM_UTIL_PVT.get_transaction_id l_return_status = '||l_return_status);
1770: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'l_trans_code = '||l_trans_code);
1771: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'l_try_id = '||l_try_id);
1772: END IF;
1773: -- Get the meaning of lookup

Line 1774: l_trans_meaning := OKL_AM_UTIL_PVT.get_lookup_meaning(

1770: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'l_trans_code = '||l_trans_code);
1771: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'l_try_id = '||l_try_id);
1772: END IF;
1773: -- Get the meaning of lookup
1774: l_trans_meaning := OKL_AM_UTIL_PVT.get_lookup_meaning(
1775: p_lookup_type => 'OKL_ACCOUNTING_EVENT_TYPE',
1776: p_lookup_code => l_trans_code, --akrangan bug 5354501 fix added l_trans_code
1777: p_validate_yn => 'Y');
1778: IF (is_debug_statement_on) THEN

Line 1793: l_currency_code := OKL_AM_UTIL_PVT.get_chr_currency(p_term_rec.p_contract_id);

1789: RAISE OKL_API.G_EXCEPTION_ERROR;
1790: END IF;
1791:
1792: -- Get the contract currency code
1793: l_currency_code := OKL_AM_UTIL_PVT.get_chr_currency(p_term_rec.p_contract_id);
1794: IF (is_debug_statement_on) THEN
1795: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'l_currency_code = '||l_currency_code);
1796: END IF;
1797: -- initialize the transaction rec

Line 2156: l_quote_type := OKL_AM_UTIL_PVT.get_lookup_meaning(

2152: IF p_term_rec.p_quote_id IS NOT NULL
2153: AND p_term_rec.p_quote_id <> OKL_API.G_MISS_NUM THEN
2154:
2155: -- Get the lookup meaning for quote type
2156: l_quote_type := OKL_AM_UTIL_PVT.get_lookup_meaning(
2157: p_lookup_type => 'OKL_QUOTE_TYPE',
2158: p_lookup_code => p_term_rec.p_quote_type,
2159: p_validate_yn => G_YES);
2160:

Line 2174: l_quote_type := OKL_AM_UTIL_PVT.get_lookup_meaning(

2170:
2171: ELSIF (p_term_rec.p_control_flag = 'TRMNT_QUOTE_UPDATE') THEN
2172:
2173: -- Get the lookup meaning for quote type
2174: l_quote_type := OKL_AM_UTIL_PVT.get_lookup_meaning(
2175: p_lookup_type => 'OKL_QUOTE_TYPE',
2176: p_lookup_code => p_term_rec.p_quote_type,
2177: p_validate_yn => G_YES);
2178:

Line 3568: okl_am_util_pvt.get_rule_record(p_rgd_code => 'LATOWN'

3564: -- to adjust tax books directly. Tax books need to be adjusted in a
3565: -- different manner for different tax owners.
3566: -- Currently we do not have any control over tax books adjusments
3567:
3568: okl_am_util_pvt.get_rule_record(p_rgd_code => 'LATOWN'
3569: ,p_rdf_code =>'LATOWN'
3570: ,p_chr_id => p_contract_id
3571: ,p_cle_id => NULL
3572: ,x_rulv_rec => l_rulv_rec

Line 3591: OKL_AM_UTIL_PVT.get_transaction_id('?',x_return_status,l_try_id);

3587: END IF;
3588:
3589:
3590:
3591: OKL_AM_UTIL_PVT.get_transaction_id('?',x_return_status,l_try_id);
3592: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
3593: OKL_API.set_message(p_app_name => 'OKL',
3594: p_msg_name => 'OKL_AM_NO_TRX_TYPE_FOUND',
3595: p_token1 => 'TRY_NAME',

Line 4888: l_curr_code := OKL_AM_UTIL_PVT.get_chr_currency(

4884: RAISE OKL_API.G_EXCEPTION_ERROR;
4885: END IF;
4886:
4887: -- Get the currency code for contract
4888: l_curr_code := OKL_AM_UTIL_PVT.get_chr_currency(
4889: p_chr_id => p_term_rec.p_contract_id);
4890:
4891: -- Get the functional currency from AM_Util
4892: l_functional_currency_code := OKL_AM_UTIL_PVT.get_functional_currency();

Line 4892: l_functional_currency_code := OKL_AM_UTIL_PVT.get_functional_currency();

4888: l_curr_code := OKL_AM_UTIL_PVT.get_chr_currency(
4889: p_chr_id => p_term_rec.p_contract_id);
4890:
4891: -- Get the functional currency from AM_Util
4892: l_functional_currency_code := OKL_AM_UTIL_PVT.get_functional_currency();
4893: IF (is_debug_statement_on) THEN
4894: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_ACCOUNTING_UTIL.convert_to_functional_currency');
4895: END IF;
4896: -- Get the currency conversion details from ACCOUNTING_Util

Line 4982: okl_am_util_pvt.get_transaction_id (

4978:
4979: -- Get transaction id based on amount type
4980: IF l_invoice_amount > 0 THEN
4981:
4982: okl_am_util_pvt.get_transaction_id (
4983: p_try_name => 'BILLING',
4984: x_return_status => l_return_status,
4985: x_try_id => l_try_id);
4986:

Line 4989: okl_am_util_pvt.get_transaction_id (

4985: x_try_id => l_try_id);
4986:
4987: ELSIF l_invoice_amount < 0 THEN
4988:
4989: okl_am_util_pvt.get_transaction_id (
4990: p_try_name => 'CREDIT MEMO',
4991: x_return_status => l_return_status,
4992: x_try_id => l_try_id);
4993: END IF;

Line 5666: OKL_AM_UTIL_PVT.get_transaction_id(

5662:
5663: -- ******** GET TRY ID FOR Balance Write off ************* --
5664:
5665: -- Get the transaction id for adjustments
5666: OKL_AM_UTIL_PVT.get_transaction_id(
5667: p_try_name => 'Balance Write off',
5668: x_return_status => l_return_status,
5669: x_try_id => l_try_id);
5670:

Line 5690: l_trans_meaning := OKL_AM_UTIL_PVT.get_lookup_meaning(

5686: RAISE OKL_API.G_EXCEPTION_ERROR;
5687: END IF;
5688:
5689: -- Get the meaning of lookup BALANCE_WRITE_OFF
5690: l_trans_meaning := OKL_AM_UTIL_PVT.get_lookup_meaning(
5691: p_lookup_type => 'OKL_ACCOUNTING_EVENT_TYPE',
5692: p_lookup_code => 'BALANCE_WRITE_OFF',
5693: p_validate_yn => 'Y');
5694:

Line 5726: l_functional_currency_code := OKL_AM_UTIL_PVT.get_functional_currency;

5722: -- RMUNJULU 03-JAN-03 2683876 Added code to Get
5723: -- the currency conversion parameters -- START
5724:
5725: -- Get the functional currency from AM_Util
5726: l_functional_currency_code := OKL_AM_UTIL_PVT.get_functional_currency;
5727:
5728: -- Get the currency conversion details from ACCOUNTING_Util
5729: OKL_ACCOUNTING_UTIL.convert_to_functional_currency(
5730: p_khr_id => p_term_rec.p_contract_id,

Line 6038: l_currency_code := OKL_AM_UTIL_PVT.get_chr_currency(

6034: END IF;
6035: */
6036:
6037: /* -- Get the currency code for contract
6038: l_currency_code := OKL_AM_UTIL_PVT.get_chr_currency(
6039: p_term_rec.p_contract_id);
6040:
6041: -- Set all success messages for all balances
6042: FOR k_bal_lns_rec IN k_bal_lns_csr ( p_term_rec.p_contract_id, l_quote_eff_date) LOOP -- rmunjulu EDAT

Line 6094: l_currency_code := OKL_AM_UTIL_PVT.get_chr_currency(p_term_rec.p_contract_id);

6090: OKL_API.set_message( p_app_name => G_APP_NAME,
6091: p_msg_name => 'OKL_AM_ERR_CLOSE_BAL');
6092:
6093: -- Get the currency code for contract
6094: l_currency_code := OKL_AM_UTIL_PVT.get_chr_currency(p_term_rec.p_contract_id);
6095:
6096: -- Format the balance amt
6097: l_formatted_bal_amt := OKL_ACCOUNTING_UTIL.format_amount(l_total_amount_due,l_currency_code);
6098:

Line 6724: l_trans_meaning := okl_am_util_pvt.get_lookup_meaning(p_lookup_type => 'OKL_ACCOUNTING_EVENT_TYPE',

6720: -- GET TEMPLATES
6721: -- ********************
6722:
6723: -- Get the meaning of lookup
6724: l_trans_meaning := okl_am_util_pvt.get_lookup_meaning(p_lookup_type => 'OKL_ACCOUNTING_EVENT_TYPE',
6725: p_lookup_code => 'TERMINATION',
6726: p_validate_yn => 'Y');
6727:
6728: -- Set the tmpl_identify_rec in parameter to get accounting templates for the product

Line 6804: l_functional_currency_code := okl_am_util_pvt.get_functional_currency();

6800: ELSIF (l_return_status = okl_api.g_ret_sts_error)
6801: THEN
6802: RAISE okl_api.g_exception_error;
6803: END IF;
6804: l_functional_currency_code := okl_am_util_pvt.get_functional_currency();
6805: --akrangan Bug 6147049 code fix start
6806: --call functional currency conversion only
6807: --if functional currency and contract currency are not same
6808: l_currency_code := okl_am_util_pvt.get_chr_currency(p_term_rec.p_contract_id);

Line 6808: l_currency_code := okl_am_util_pvt.get_chr_currency(p_term_rec.p_contract_id);

6804: l_functional_currency_code := okl_am_util_pvt.get_functional_currency();
6805: --akrangan Bug 6147049 code fix start
6806: --call functional currency conversion only
6807: --if functional currency and contract currency are not same
6808: l_currency_code := okl_am_util_pvt.get_chr_currency(p_term_rec.p_contract_id);
6809: IF l_functional_currency_code IS NOT NULL AND
6810: l_functional_currency_code <> l_currency_code
6811: THEN
6812: --akrangan Bug 6147049 code fix end

Line 7302: okl_am_util_pvt.get_transaction_id(p_try_name => 'Accrual',

7298: -- *************
7299:
7300: -- Reversal of non-income during contract termination
7301: -- Get the transaction id for Accrual
7302: okl_am_util_pvt.get_transaction_id(p_try_name => 'Accrual',
7303: x_return_status => l_return_status,
7304: x_try_id => l_try_id);
7305:
7306: -- Get the meaning of lookup

Line 7307: l_trans_meaning := okl_am_util_pvt.get_lookup_meaning(p_lookup_type => 'OKL_ACCOUNTING_EVENT_TYPE',

7303: x_return_status => l_return_status,
7304: x_try_id => l_try_id);
7305:
7306: -- Get the meaning of lookup
7307: l_trans_meaning := okl_am_util_pvt.get_lookup_meaning(p_lookup_type => 'OKL_ACCOUNTING_EVENT_TYPE',
7308: p_lookup_code => 'ACCRUAL',
7309: p_validate_yn => 'Y');
7310:
7311: IF l_return_status <> okl_api.g_ret_sts_success

Line 7793: l_trans_meaning := okl_am_util_pvt.get_lookup_meaning(p_lookup_type => 'OKL_ACCOUNTING_EVENT_TYPE',

7789: END IF; -- rmunjulu 4141991 End of new If
7790:
7791: -- Set success messages here
7792: -- Get the meaning of lookup
7793: l_trans_meaning := okl_am_util_pvt.get_lookup_meaning(p_lookup_type => 'OKL_ACCOUNTING_EVENT_TYPE',
7794: p_lookup_code => 'TERMINATION',
7795: p_validate_yn => 'Y');
7796:
7797: -- Accounting entries created for transaction type TRX_TYPE.

Line 9652: l_func_curr_code := okl_am_util_pvt.get_functional_currency;

9648:
9649: -- SECHAWLA Bug # 2726739 : added the folowing piece of code
9650:
9651: -- get the functional currency
9652: l_func_curr_code := okl_am_util_pvt.get_functional_currency;
9653: -- get the contract currency
9654: l_contract_curr_code := okl_am_util_pvt.get_chr_currency( p_chr_id => p_term_rec.p_contract_id);
9655:
9656: IF l_contract_curr_code <> l_func_curr_code THEN

Line 9654: l_contract_curr_code := okl_am_util_pvt.get_chr_currency( p_chr_id => p_term_rec.p_contract_id);

9650:
9651: -- get the functional currency
9652: l_func_curr_code := okl_am_util_pvt.get_functional_currency;
9653: -- get the contract currency
9654: l_contract_curr_code := okl_am_util_pvt.get_chr_currency( p_chr_id => p_term_rec.p_contract_id);
9655:
9656: IF l_contract_curr_code <> l_func_curr_code THEN
9657: -- convert amount to functional currency
9658: okl_accounting_util.convert_to_functional_currency(

Line 9982: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_ASSET_RETURN_STATUS',ars_code,'N') ret_status

9978:
9979: -- Get the non-cancelled asset return for asset
9980: CURSOR get_asset_return_csr ( p_kle_id IN NUMBER) IS
9981: SELECT id id,
9982: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_ASSET_RETURN_STATUS',ars_code,'N') ret_status
9983: FROM OKL_ASSET_RETURNS_V
9984: WHERE kle_id = p_kle_id
9985: AND ars_code <> 'CANCELLED';
9986:

Line 10962: OKL_AM_UTIL_PVT.process_messages(

10958: RAISE OKL_API.G_EXCEPTION_ERROR;
10959: END IF;
10960:
10961: -- Save messages from stack into transaction message table
10962: OKL_AM_UTIL_PVT.process_messages(
10963: p_trx_source_table => 'OKL_TRX_CONTRACTS',
10964: p_trx_id => lp_tcnv_rec.id,
10965: x_return_status => l_return_status);
10966:

Line 11035: OKL_AM_UTIL_PVT.process_messages(

11031: RAISE OKL_API.G_EXCEPTION_ERROR;
11032: END IF;
11033:
11034: -- Save messages from stack into transaction message table
11035: OKL_AM_UTIL_PVT.process_messages(
11036: p_trx_source_table => 'OKL_TRX_CONTRACTS',
11037: p_trx_id => lp_tcnv_rec.id,
11038: x_return_status => l_return_status);
11039:

Line 11105: OKL_AM_UTIL_PVT.process_messages(

11101: RAISE OKL_API.G_EXCEPTION_ERROR;
11102: END IF;
11103:
11104: -- Save messages from stack into transaction message table
11105: OKL_AM_UTIL_PVT.process_messages(
11106: p_trx_source_table => 'OKL_TRX_CONTRACTS',
11107: p_trx_id => lp_tcnv_rec.id,
11108: x_return_status => l_return_status);
11109:

Line 11392: OKL_AM_UTIL_PVT.process_messages(

11388: RAISE OKL_API.G_EXCEPTION_ERROR;
11389: END IF;
11390:
11391: -- Save messages from stack into transaction message table
11392: OKL_AM_UTIL_PVT.process_messages(
11393: p_trx_source_table => 'OKL_TRX_CONTRACTS',
11394: p_trx_id => lp_tcnv_rec.id,
11395: x_return_status => l_return_status);
11396: