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 325: 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);

321: l_rule_code := 'AMBPOC'; -- Purchase Options
322: IF (is_debug_statement_on) THEN
323: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'p_term_rec.p_contract_id = '||p_term_rec.p_contract_id);
324: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'p_kle_id = '||p_kle_id);
325: 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);
326: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_rulv_rec.rule_information1 = '||l_rulv_rec.rule_information1);
327: END IF;
328: l_khr_id := p_term_rec.p_contract_id;
329: IF (is_debug_statement_on) THEN

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

326: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_rulv_rec.rule_information1 = '||l_rulv_rec.rule_information1);
327: END IF;
328: l_khr_id := p_term_rec.p_contract_id;
329: IF (is_debug_statement_on) THEN
330: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Calling OKL_AM_UTIL_PVT.get_rule_record');
331: END IF;
332: -- Get End of Term Purchase Amount Details
333: OKL_AM_UTIL_PVT.get_rule_record(
334: p_rgd_code => l_rgd_code,

Line 333: OKL_AM_UTIL_PVT.get_rule_record(

329: IF (is_debug_statement_on) THEN
330: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Calling OKL_AM_UTIL_PVT.get_rule_record');
331: END IF;
332: -- Get End of Term Purchase Amount Details
333: OKL_AM_UTIL_PVT.get_rule_record(
334: p_rgd_code => l_rgd_code,
335: p_rdf_code => l_rule_code,
336: p_chr_id => l_khr_id,
337: p_cle_id => NULL,

Line 343: 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);

339: x_return_status => l_return_status,
340: p_message_yn => TRUE);
341:
342: IF (is_debug_statement_on) THEN
343: 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);
344: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_rulv_rec.rule_information1 = '||l_rulv_rec.rule_information1);
345: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_rulv_rec.rule_information2 = '||l_rulv_rec.rule_information2);
346: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_rulv_rec.rule_information3 = '||l_rulv_rec.rule_information3);
347: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_rulv_rec.rule_information4 = '||l_rulv_rec.rule_information4);

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

366:
367: ELSIF l_calc_option = 'USE_FORMULA' THEN -- Purchase Amount is FORMULA
368:
369: IF (is_debug_statement_on) THEN
370: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Calling OKL_AM_UTIL_PVT.get_formula_value');
371: END IF;
372: -- Get the formula value
373: OKL_AM_UTIL_PVT.get_formula_value (
374: p_formula_name => l_formula_name,

Line 373: OKL_AM_UTIL_PVT.get_formula_value (

369: IF (is_debug_statement_on) THEN
370: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Calling OKL_AM_UTIL_PVT.get_formula_value');
371: END IF;
372: -- Get the formula value
373: OKL_AM_UTIL_PVT.get_formula_value (
374: p_formula_name => l_formula_name,
375: p_chr_id => l_khr_id,
376: p_cle_id => p_kle_id,
377: p_additional_parameters => l_params,

Line 381: 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);

377: p_additional_parameters => l_params,
378: x_formula_value => l_formula_value,
379: x_return_status => l_return_status);
380: IF (is_debug_statement_on) THEN
381: 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);
382: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_formula_value = '||l_formula_value);
383: END IF;
384:
385: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

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

392: IF l_prorate = 'PRORATE' AND l_purchase_amount <> 0 THEN
393:
394: -- Get line oec (evaluate formula contract_oec and pass line id)
395: IF (is_debug_statement_on) THEN
396: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Calling OKL_AM_UTIL_PVT.get_formula_value');
397: END IF;
398: OKL_AM_UTIL_PVT.get_formula_value (
399: p_formula_name => 'CONTRACT_OEC',
400: p_chr_id => l_khr_id,

Line 398: OKL_AM_UTIL_PVT.get_formula_value (

394: -- Get line oec (evaluate formula contract_oec and pass line id)
395: IF (is_debug_statement_on) THEN
396: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Calling OKL_AM_UTIL_PVT.get_formula_value');
397: END IF;
398: OKL_AM_UTIL_PVT.get_formula_value (
399: p_formula_name => 'CONTRACT_OEC',
400: p_chr_id => l_khr_id,
401: p_cle_id => p_kle_id,
402: p_additional_parameters => l_params,

Line 406: 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);

402: p_additional_parameters => l_params,
403: x_formula_value => l_line_oec,
404: x_return_status => l_return_status);
405: IF (is_debug_statement_on) THEN
406: 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);
407: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_formula_value = '||l_formula_value);
408: END IF;
409:
410: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

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

412: END IF;
413:
414: -- Get contract oec
415: IF (is_debug_statement_on) THEN
416: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Calling OKL_AM_UTIL_PVT.get_formula_value');
417: END IF;
418: OKL_AM_UTIL_PVT.get_formula_value (
419: p_formula_name => 'CONTRACT_OEC',
420: p_chr_id => l_khr_id,

Line 418: OKL_AM_UTIL_PVT.get_formula_value (

414: -- Get contract oec
415: IF (is_debug_statement_on) THEN
416: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Calling OKL_AM_UTIL_PVT.get_formula_value');
417: END IF;
418: OKL_AM_UTIL_PVT.get_formula_value (
419: p_formula_name => 'CONTRACT_OEC',
420: p_chr_id => l_khr_id,
421: p_cle_id => NULL,
422: p_additional_parameters => l_params,

Line 426: 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);

422: p_additional_parameters => l_params,
423: x_formula_value => l_contract_oec,
424: x_return_status => l_return_status);
425: IF (is_debug_statement_on) THEN
426: 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);
427: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_formula_value = '||l_formula_value);
428: END IF;
429:
430:

Line 1377: 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);

1373: IF (is_debug_procedure_on) THEN
1374: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1375: END IF;
1376: IF (is_debug_statement_on) THEN
1377: 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);
1378: END IF;
1379: OKL_AM_UTIL_PVT.get_rule_record(
1380: p_rgd_code => 'LAEVEL',
1381: p_rdf_code => l_rule_code,

Line 1379: OKL_AM_UTIL_PVT.get_rule_record(

1375: END IF;
1376: IF (is_debug_statement_on) THEN
1377: 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);
1378: END IF;
1379: OKL_AM_UTIL_PVT.get_rule_record(
1380: p_rgd_code => 'LAEVEL',
1381: p_rdf_code => l_rule_code,
1382: p_chr_id => p_term_rec.p_contract_id,
1383: p_cle_id => NULL,

Line 1388: 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);

1384: x_rulv_rec => l_rulv_rec,
1385: x_return_status => l_return_status,
1386: p_message_yn => FALSE);
1387: IF (is_debug_statement_on) THEN
1388: 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);
1389: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_rulv_rec.rule_information1 = '||l_rulv_rec.rule_information1);
1390: END IF;
1391: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN
1392: IF (NVL (l_rulv_rec.rule_information1, '*') = G_YES) THEN

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

1641: END IF;
1642: --akrangan bug 5354501 fix end
1643: -- Get the Transaction Id
1644: IF (is_debug_statement_on) THEN
1645: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_AM_UTIL_PVT.get_transaction_id ');
1646: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'l_try_name = '||l_try_name);
1647: END IF;
1648: OKL_AM_UTIL_PVT.get_transaction_id (
1649: p_try_name => l_try_name , --akrangan bug 5354501 fix added l_try_name

Line 1648: OKL_AM_UTIL_PVT.get_transaction_id (

1644: IF (is_debug_statement_on) THEN
1645: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_AM_UTIL_PVT.get_transaction_id ');
1646: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'l_try_name = '||l_try_name);
1647: END IF;
1648: OKL_AM_UTIL_PVT.get_transaction_id (
1649: p_try_name => l_try_name , --akrangan bug 5354501 fix added l_try_name
1650: x_return_status => l_return_status,
1651: x_try_id => l_try_id);
1652: IF (is_debug_statement_on) THEN

Line 1653: 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);

1649: p_try_name => l_try_name , --akrangan bug 5354501 fix added l_try_name
1650: x_return_status => l_return_status,
1651: x_try_id => l_try_id);
1652: IF (is_debug_statement_on) THEN
1653: 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);
1654: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'l_trans_code = '||l_trans_code);
1655: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'l_try_id = '||l_try_id);
1656: END IF;
1657: -- Get the meaning of lookup

Line 1658: l_trans_meaning := OKL_AM_UTIL_PVT.get_lookup_meaning(

1654: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'l_trans_code = '||l_trans_code);
1655: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'l_try_id = '||l_try_id);
1656: END IF;
1657: -- Get the meaning of lookup
1658: l_trans_meaning := OKL_AM_UTIL_PVT.get_lookup_meaning(
1659: p_lookup_type => 'OKL_ACCOUNTING_EVENT_TYPE',
1660: p_lookup_code => l_trans_code, --akrangan bug 5354501 fix added l_trans_code
1661: p_validate_yn => 'Y');
1662: IF (is_debug_statement_on) THEN

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

1673: RAISE OKL_API.G_EXCEPTION_ERROR;
1674: END IF;
1675:
1676: -- Get the contract currency code
1677: l_currency_code := OKL_AM_UTIL_PVT.get_chr_currency(p_term_rec.p_contract_id);
1678: IF (is_debug_statement_on) THEN
1679: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'l_currency_code = '||l_currency_code);
1680: END IF;
1681: -- initialize the transaction rec

Line 2040: l_quote_type := OKL_AM_UTIL_PVT.get_lookup_meaning(

2036: IF p_term_rec.p_quote_id IS NOT NULL
2037: AND p_term_rec.p_quote_id <> OKL_API.G_MISS_NUM THEN
2038:
2039: -- Get the lookup meaning for quote type
2040: l_quote_type := OKL_AM_UTIL_PVT.get_lookup_meaning(
2041: p_lookup_type => 'OKL_QUOTE_TYPE',
2042: p_lookup_code => p_term_rec.p_quote_type,
2043: p_validate_yn => G_YES);
2044:

Line 2058: l_quote_type := OKL_AM_UTIL_PVT.get_lookup_meaning(

2054:
2055: ELSIF (p_term_rec.p_control_flag = 'TRMNT_QUOTE_UPDATE') THEN
2056:
2057: -- Get the lookup meaning for quote type
2058: l_quote_type := OKL_AM_UTIL_PVT.get_lookup_meaning(
2059: p_lookup_type => 'OKL_QUOTE_TYPE',
2060: p_lookup_code => p_term_rec.p_quote_type,
2061: p_validate_yn => G_YES);
2062:

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

3448: -- to adjust tax books directly. Tax books need to be adjusted in a
3449: -- different manner for different tax owners.
3450: -- Currently we do not have any control over tax books adjusments
3451:
3452: okl_am_util_pvt.get_rule_record(p_rgd_code => 'LATOWN'
3453: ,p_rdf_code =>'LATOWN'
3454: ,p_chr_id => p_contract_id
3455: ,p_cle_id => NULL
3456: ,x_rulv_rec => l_rulv_rec

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

3471: END IF;
3472:
3473:
3474:
3475: OKL_AM_UTIL_PVT.get_transaction_id('?',x_return_status,l_try_id);
3476: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
3477: OKL_API.set_message(p_app_name => 'OKL',
3478: p_msg_name => 'OKL_AM_NO_TRX_TYPE_FOUND',
3479: p_token1 => 'TRY_NAME',

Line 4744: l_curr_code := OKL_AM_UTIL_PVT.get_chr_currency(

4740: RAISE OKL_API.G_EXCEPTION_ERROR;
4741: END IF;
4742:
4743: -- Get the currency code for contract
4744: l_curr_code := OKL_AM_UTIL_PVT.get_chr_currency(
4745: p_chr_id => p_term_rec.p_contract_id);
4746:
4747: -- Get the functional currency from AM_Util
4748: l_functional_currency_code := OKL_AM_UTIL_PVT.get_functional_currency();

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

4744: l_curr_code := OKL_AM_UTIL_PVT.get_chr_currency(
4745: p_chr_id => p_term_rec.p_contract_id);
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

Line 4816: okl_am_util_pvt.get_transaction_id (

4812:
4813: -- Get transaction id based on amount type
4814: IF l_invoice_amount > 0 THEN
4815:
4816: okl_am_util_pvt.get_transaction_id (
4817: p_try_name => 'BILLING',
4818: x_return_status => l_return_status,
4819: x_try_id => l_try_id);
4820:

Line 4823: okl_am_util_pvt.get_transaction_id (

4819: x_try_id => l_try_id);
4820:
4821: ELSIF l_invoice_amount < 0 THEN
4822:
4823: okl_am_util_pvt.get_transaction_id (
4824: p_try_name => 'CREDIT MEMO',
4825: x_return_status => l_return_status,
4826: x_try_id => l_try_id);
4827: END IF;

Line 5500: OKL_AM_UTIL_PVT.get_transaction_id(

5496:
5497: -- ******** GET TRY ID FOR Balance Write off ************* --
5498:
5499: -- Get the transaction id for adjustments
5500: OKL_AM_UTIL_PVT.get_transaction_id(
5501: p_try_name => 'Balance Write off',
5502: x_return_status => l_return_status,
5503: x_try_id => l_try_id);
5504:

Line 5524: l_trans_meaning := OKL_AM_UTIL_PVT.get_lookup_meaning(

5520: RAISE OKL_API.G_EXCEPTION_ERROR;
5521: END IF;
5522:
5523: -- Get the meaning of lookup BALANCE_WRITE_OFF
5524: l_trans_meaning := OKL_AM_UTIL_PVT.get_lookup_meaning(
5525: p_lookup_type => 'OKL_ACCOUNTING_EVENT_TYPE',
5526: p_lookup_code => 'BALANCE_WRITE_OFF',
5527: p_validate_yn => 'Y');
5528:

Line 5560: l_functional_currency_code := OKL_AM_UTIL_PVT.get_functional_currency;

5556: -- RMUNJULU 03-JAN-03 2683876 Added code to Get
5557: -- the currency conversion parameters -- START
5558:
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,

Line 5872: l_currency_code := OKL_AM_UTIL_PVT.get_chr_currency(

5868: END IF;
5869: */
5870:
5871: /* -- Get the currency code for contract
5872: l_currency_code := OKL_AM_UTIL_PVT.get_chr_currency(
5873: p_term_rec.p_contract_id);
5874:
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

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

5924: OKL_API.set_message( p_app_name => G_APP_NAME,
5925: p_msg_name => 'OKL_AM_ERR_CLOSE_BAL');
5926:
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:

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

6548: -- GET TEMPLATES
6549: -- ********************
6550:
6551: -- Get the meaning of lookup
6552: l_trans_meaning := okl_am_util_pvt.get_lookup_meaning(p_lookup_type => 'OKL_ACCOUNTING_EVENT_TYPE',
6553: p_lookup_code => 'TERMINATION',
6554: p_validate_yn => 'Y');
6555:
6556: -- Set the tmpl_identify_rec in parameter to get accounting templates for the product

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

6628: ELSIF (l_return_status = okl_api.g_ret_sts_error)
6629: THEN
6630: RAISE okl_api.g_exception_error;
6631: END IF;
6632: l_functional_currency_code := okl_am_util_pvt.get_functional_currency();
6633: --akrangan Bug 6147049 code fix start
6634: --call functional currency conversion only
6635: --if functional currency and contract currency are not same
6636: l_currency_code := okl_am_util_pvt.get_chr_currency(p_term_rec.p_contract_id);

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

6632: l_functional_currency_code := okl_am_util_pvt.get_functional_currency();
6633: --akrangan Bug 6147049 code fix start
6634: --call functional currency conversion only
6635: --if functional currency and contract currency are not same
6636: l_currency_code := okl_am_util_pvt.get_chr_currency(p_term_rec.p_contract_id);
6637: IF l_functional_currency_code IS NOT NULL AND
6638: l_functional_currency_code <> l_currency_code
6639: THEN
6640: --akrangan Bug 6147049 code fix end

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

7049: -- *************
7050:
7051: -- Reversal of non-income during contract termination
7052: -- Get the transaction id for Accrual
7053: okl_am_util_pvt.get_transaction_id(p_try_name => 'Accrual',
7054: x_return_status => l_return_status,
7055: x_try_id => l_try_id);
7056:
7057: -- Get the meaning of lookup

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

7054: x_return_status => l_return_status,
7055: x_try_id => l_try_id);
7056:
7057: -- Get the meaning of lookup
7058: l_trans_meaning := okl_am_util_pvt.get_lookup_meaning(p_lookup_type => 'OKL_ACCOUNTING_EVENT_TYPE',
7059: p_lookup_code => 'ACCRUAL',
7060: p_validate_yn => 'Y');
7061:
7062: IF l_return_status <> okl_api.g_ret_sts_success

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

7590: END IF; -- rmunjulu 4141991 End of new If
7591:
7592: -- Set success messages here
7593: -- Get the meaning of lookup
7594: l_trans_meaning := okl_am_util_pvt.get_lookup_meaning(p_lookup_type => 'OKL_ACCOUNTING_EVENT_TYPE',
7595: p_lookup_code => 'TERMINATION',
7596: p_validate_yn => 'Y');
7597:
7598: -- Accounting entries created for transaction type TRX_TYPE.

Line 9453: l_func_curr_code := okl_am_util_pvt.get_functional_currency;

9449:
9450: -- SECHAWLA Bug # 2726739 : added the folowing piece of code
9451:
9452: -- get the functional currency
9453: l_func_curr_code := okl_am_util_pvt.get_functional_currency;
9454: -- get the contract 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

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

9451:
9452: -- get the functional currency
9453: l_func_curr_code := okl_am_util_pvt.get_functional_currency;
9454: -- get the contract 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(

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

9779:
9780: -- Get the non-cancelled asset return for asset
9781: CURSOR get_asset_return_csr ( p_kle_id IN NUMBER) IS
9782: SELECT id id,
9783: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_ASSET_RETURN_STATUS',ars_code,'N') ret_status
9784: FROM OKL_ASSET_RETURNS_V
9785: WHERE kle_id = p_kle_id
9786: AND ars_code <> 'CANCELLED';
9787:

Line 10763: OKL_AM_UTIL_PVT.process_messages(

10759: RAISE OKL_API.G_EXCEPTION_ERROR;
10760: END IF;
10761:
10762: -- Save messages from stack into transaction message table
10763: OKL_AM_UTIL_PVT.process_messages(
10764: p_trx_source_table => 'OKL_TRX_CONTRACTS',
10765: p_trx_id => lp_tcnv_rec.id,
10766: x_return_status => l_return_status);
10767:

Line 10836: OKL_AM_UTIL_PVT.process_messages(

10832: RAISE OKL_API.G_EXCEPTION_ERROR;
10833: END IF;
10834:
10835: -- Save messages from stack into transaction message table
10836: OKL_AM_UTIL_PVT.process_messages(
10837: p_trx_source_table => 'OKL_TRX_CONTRACTS',
10838: p_trx_id => lp_tcnv_rec.id,
10839: x_return_status => l_return_status);
10840:

Line 10906: OKL_AM_UTIL_PVT.process_messages(

10902: RAISE OKL_API.G_EXCEPTION_ERROR;
10903: END IF;
10904:
10905: -- Save messages from stack into transaction message table
10906: OKL_AM_UTIL_PVT.process_messages(
10907: p_trx_source_table => 'OKL_TRX_CONTRACTS',
10908: p_trx_id => lp_tcnv_rec.id,
10909: x_return_status => l_return_status);
10910:

Line 11193: OKL_AM_UTIL_PVT.process_messages(

11189: RAISE OKL_API.G_EXCEPTION_ERROR;
11190: END IF;
11191:
11192: -- Save messages from stack into transaction message table
11193: OKL_AM_UTIL_PVT.process_messages(
11194: p_trx_source_table => 'OKL_TRX_CONTRACTS',
11195: p_trx_id => lp_tcnv_rec.id,
11196: x_return_status => l_return_status);
11197: