DBA Data[Home] [Help]

APPS.OKL_AM_CNTRCT_LN_TRMNT_PVT dependencies on OKL_AM_UTIL_PVT

Line 520: okl_am_util_pvt.get_lookup_meaning

516: AND p_term_rec.p_quote_id <> g_miss_num
517: THEN
518: -- Get the lookup meaning for quote type
519: l_quote_type :=
520: okl_am_util_pvt.get_lookup_meaning
521: (p_lookup_type => 'OKL_QUOTE_TYPE',
522: p_lookup_code => p_term_rec.p_quote_type,
523: p_validate_yn => g_yes
524: );

Line 540: okl_am_util_pvt.get_lookup_meaning

536: ELSIF (p_term_rec.p_control_flag = 'TRMNT_QUOTE_UPDATE')
537: THEN
538: -- Get the lookup meaning for quote type
539: l_quote_type :=
540: okl_am_util_pvt.get_lookup_meaning
541: (p_lookup_type => 'OKL_QUOTE_TYPE',
542: p_lookup_code => p_term_rec.p_quote_type,
543: p_validate_yn => g_yes
544: );

Line 710: 'calling OKL_AM_UTIL_PVT.get_transaction_id'

706: THEN
707: okl_debug_pub.log_debug
708: (g_level_statement,
709: l_module_name,
710: 'calling OKL_AM_UTIL_PVT.get_transaction_id'
711: );
712: END IF;
713:
714: -- Get the Accounting Transaction Id

Line 715: okl_am_util_pvt.get_transaction_id

711: );
712: END IF;
713:
714: -- Get the Accounting Transaction Id
715: okl_am_util_pvt.get_transaction_id
716: (p_try_name => 'Termination',
717: x_return_status => l_return_status,
718: x_try_id => l_try_id
719: );

Line 726: 'called OKL_AM_UTIL_PVT.get_transaction_id , l_return_status: '

722: THEN
723: okl_debug_pub.log_debug
724: (g_level_statement,
725: l_module_name,
726: 'called OKL_AM_UTIL_PVT.get_transaction_id , l_return_status: '
727: || l_return_status
728: );
729: END IF;
730:

Line 733: okl_am_util_pvt.get_lookup_meaning

729: END IF;
730:
731: -- Get the meaning of Accounting lookup
732: l_trans_meaning :=
733: okl_am_util_pvt.get_lookup_meaning
734: (p_lookup_type => 'OKL_ACCOUNTING_EVENT_TYPE',
735: p_lookup_code => 'TERMINATION',
736: p_validate_yn => 'Y'
737: );

Line 752: okl_am_util_pvt.get_chr_currency (p_term_rec.p_contract_id);

748: END IF;
749:
750: -- Get the contract currency code
751: l_currency_code :=
752: okl_am_util_pvt.get_chr_currency (p_term_rec.p_contract_id);
753: -- initialize the transaction rec
754: px_tcnv_rec.khr_id := p_term_rec.p_contract_id;
755: px_tcnv_rec.tcn_type := 'ALT'; -- TMT
756: px_tcnv_rec.try_id := l_try_id;

Line 4174: okl_am_util_pvt.get_lookup_meaning

4170: -- GET TEMPLATES
4171:
4172: -- Get the meaning of lookup
4173: l_trans_meaning :=
4174: okl_am_util_pvt.get_lookup_meaning
4175: (p_lookup_type => 'OKL_ACCOUNTING_EVENT_TYPE',
4176: p_lookup_code => 'TERMINATION',
4177: p_validate_yn => 'Y'
4178: );

Line 4307: okl_am_util_pvt.get_chr_currency (p_term_rec.p_contract_id);

4303: -- ******************
4304: -- CURRENCY CONVERSION OPERATIONS
4305: -- ******************
4306: l_currency_code :=
4307: okl_am_util_pvt.get_chr_currency (p_term_rec.p_contract_id);
4308: l_functional_currency_code :=
4309: okl_am_util_pvt.get_functional_currency
4310: ();
4311:

Line 4309: okl_am_util_pvt.get_functional_currency

4305: -- ******************
4306: l_currency_code :=
4307: okl_am_util_pvt.get_chr_currency (p_term_rec.p_contract_id);
4308: l_functional_currency_code :=
4309: okl_am_util_pvt.get_functional_currency
4310: ();
4311:
4312: --akrangan Bug 6147049 code fix start
4313: --call functional currency conversion only

Line 4929: okl_am_util_pvt.get_lookup_meaning

4925:
4926: -- Set success messages here
4927: -- Get the meaning of lookup
4928: l_trans_meaning :=
4929: okl_am_util_pvt.get_lookup_meaning
4930: (p_lookup_type => 'OKL_ACCOUNTING_EVENT_TYPE',
4931: p_lookup_code => 'TERMINATION',
4932: p_validate_yn => 'Y'
4933: );

Line 5328: l_func_curr_code := okl_am_util_pvt.get_functional_currency;

5324:
5325: -- SECHAWLA Bug # 2726739 : added the folowing piece of code
5326:
5327: -- get the functional currency
5328: l_func_curr_code := okl_am_util_pvt.get_functional_currency;
5329: -- get the contract currency
5330: l_contract_curr_code :=
5331: okl_am_util_pvt.get_chr_currency
5332: (p_chr_id => p_term_rec.p_contract_id);

Line 5331: okl_am_util_pvt.get_chr_currency

5327: -- get the functional currency
5328: l_func_curr_code := okl_am_util_pvt.get_functional_currency;
5329: -- get the contract currency
5330: l_contract_curr_code :=
5331: okl_am_util_pvt.get_chr_currency
5332: (p_chr_id => p_term_rec.p_contract_id);
5333:
5334: IF l_contract_curr_code <> l_func_curr_code
5335: THEN

Line 6652: okl_am_util_pvt.get_lookup_meaning ('OKL_ASSET_RETURN_STATUS',

6648: p_kle_id IN NUMBER
6649: )
6650: IS
6651: SELECT arr.ID ID,
6652: okl_am_util_pvt.get_lookup_meaning ('OKL_ASSET_RETURN_STATUS',
6653: arr.ars_code,
6654: 'N'
6655: ) ret_status
6656: FROM okl_asset_returns_v arr

Line 7353: 'calling OKL_AM_UTIL_PVT.get_transaction_id'

7349: THEN
7350: okl_debug_pub.log_debug
7351: (g_level_statement,
7352: l_module_name,
7353: 'calling OKL_AM_UTIL_PVT.get_transaction_id'
7354: );
7355: END IF;
7356:
7357: -- Get the transaction id for adjustments

Line 7358: okl_am_util_pvt.get_transaction_id

7354: );
7355: END IF;
7356:
7357: -- Get the transaction id for adjustments
7358: okl_am_util_pvt.get_transaction_id
7359: (p_try_name => 'Balance Write off',
7360: x_return_status => l_return_status,
7361: x_try_id => l_try_id
7362: );

Line 7369: 'called OKL_AM_UTIL_PVT.get_transaction_id , return status: '

7365: THEN
7366: okl_debug_pub.log_debug
7367: (g_level_statement,
7368: l_module_name,
7369: 'called OKL_AM_UTIL_PVT.get_transaction_id , return status: '
7370: || l_return_status
7371: );
7372: okl_debug_pub.log_debug (g_level_statement,
7373: l_module_name,

Line 7400: okl_am_util_pvt.get_lookup_meaning

7396: END IF;
7397:
7398: -- Get the meaning of lookup BALANCE_WRITE_OFF
7399: l_trans_meaning :=
7400: okl_am_util_pvt.get_lookup_meaning
7401: (p_lookup_type => 'OKL_ACCOUNTING_EVENT_TYPE',
7402: p_lookup_code => 'BALANCE_WRITE_OFF',
7403: p_validate_yn => 'Y'
7404: );

Line 7439: okl_am_util_pvt.get_functional_currency;

7435:
7436: -- Get, set and pass the currency conversion parameters
7437: -- Get the functional currency from AM_Util
7438: l_functional_currency_code :=
7439: okl_am_util_pvt.get_functional_currency;
7440:
7441: IF (is_debug_statement_on)
7442: THEN
7443: okl_debug_pub.log_debug

Line 7750: okl_am_util_pvt.get_chr_currency (p_term_rec.p_contract_id);

7746: END IF;
7747:
7748: -- Get the currency code for contract
7749: l_currency_code :=
7750: okl_am_util_pvt.get_chr_currency (p_term_rec.p_contract_id);
7751:
7752: -- Set all success messages for all balances
7753: FOR k_bal_lns_rec IN k_bal_lns_csr (p_term_rec.p_contract_id)
7754: LOOP

Line 7791: okl_am_util_pvt.get_chr_currency (p_term_rec.p_contract_id);

7787: okl_api.set_message (p_app_name => g_app_name,
7788: p_msg_name => 'OKL_AM_ERR_CLOSE_BAL');
7789: -- Get the currency code for contract
7790: l_currency_code :=
7791: okl_am_util_pvt.get_chr_currency (p_term_rec.p_contract_id);
7792: -- Format the balance amt
7793: l_formatted_bal_amt :=
7794: okl_accounting_util.format_amount (l_total_amount_due,
7795: l_currency_code);

Line 8709: 'calling OKL_AM_UTIL_PVT.get_transaction_id'

8705: THEN
8706: okl_debug_pub.log_debug
8707: (g_level_statement,
8708: l_module_name,
8709: 'calling OKL_AM_UTIL_PVT.get_transaction_id'
8710: );
8711: END IF;
8712:
8713: -- Get the transaction id for Accrual

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

8710: );
8711: END IF;
8712:
8713: -- Get the transaction id for Accrual
8714: okl_am_util_pvt.get_transaction_id (p_try_name => 'Accrual',
8715: x_return_status => l_return_status,
8716: x_try_id => l_try_id
8717: );
8718:

Line 8724: 'called OKL_AM_UTIL_PVT.get_transaction_id , return status: '

8720: THEN
8721: okl_debug_pub.log_debug
8722: (g_level_statement,
8723: l_module_name,
8724: 'called OKL_AM_UTIL_PVT.get_transaction_id , return status: '
8725: || l_return_status
8726: );
8727: okl_debug_pub.log_debug (g_level_statement,
8728: l_module_name,

Line 8735: okl_am_util_pvt.get_lookup_meaning

8731: END IF;
8732:
8733: -- Get the meaning of lookup
8734: l_trans_meaning :=
8735: okl_am_util_pvt.get_lookup_meaning
8736: (p_lookup_type => 'OKL_ACCOUNTING_EVENT_TYPE',
8737: p_lookup_code => 'ACCRUAL',
8738: p_validate_yn => 'Y'
8739: );

Line 11872: okl_am_util_pvt.get_actual_asset_residual

11868:
11869: -- rmunjulu LOANS_ENHACEMENTS -- start
11870: -- get termination value for the terminated asset
11871: l_termination_value :=
11872: okl_am_util_pvt.get_actual_asset_residual
11873: (p_khr_id => l_chr_id,
11874: p_kle_id => l_akle_tbl (i).p_kle_id);
11875: -- update okc_k_lines termination value
11876: lap_clev_rec := l_empty_clev_rec;

Line 14228: 'calling OKL_AM_UTIL_PVT.process_messages'

14224: THEN
14225: okl_debug_pub.log_debug
14226: (g_level_statement,
14227: l_module_name,
14228: 'calling OKL_AM_UTIL_PVT.process_messages'
14229: );
14230: END IF;
14231:
14232: okl_am_util_pvt.process_messages

Line 14232: okl_am_util_pvt.process_messages

14228: 'calling OKL_AM_UTIL_PVT.process_messages'
14229: );
14230: END IF;
14231:
14232: okl_am_util_pvt.process_messages
14233: (p_trx_source_table => 'OKL_TRX_CONTRACTS',
14234: p_trx_id => lp_tcnv_rec.ID,
14235: x_return_status => l_return_status
14236: );

Line 14243: 'called OKL_AM_UTIL_PVT.process_messages , return status: '

14239: THEN
14240: okl_debug_pub.log_debug
14241: (g_level_statement,
14242: l_module_name,
14243: 'called OKL_AM_UTIL_PVT.process_messages , return status: '
14244: || l_return_status
14245: );
14246: END IF;
14247:

Line 14325: 'calling OKL_AM_UTIL_PVT.process_messages'

14321: THEN
14322: okl_debug_pub.log_debug
14323: (g_level_statement,
14324: l_module_name,
14325: 'calling OKL_AM_UTIL_PVT.process_messages'
14326: );
14327: END IF;
14328:
14329: okl_am_util_pvt.process_messages

Line 14329: okl_am_util_pvt.process_messages

14325: 'calling OKL_AM_UTIL_PVT.process_messages'
14326: );
14327: END IF;
14328:
14329: okl_am_util_pvt.process_messages
14330: (p_trx_source_table => 'OKL_TRX_CONTRACTS',
14331: p_trx_id => lp_tcnv_rec.ID,
14332: x_return_status => l_return_status
14333: );

Line 14340: 'called OKL_AM_UTIL_PVT.process_messages , return status: '

14336: THEN
14337: okl_debug_pub.log_debug
14338: (g_level_statement,
14339: l_module_name,
14340: 'called OKL_AM_UTIL_PVT.process_messages , return status: '
14341: || l_return_status
14342: );
14343: END IF;
14344:

Line 14400: 'calling OKL_AM_UTIL_PVT.process_messages'

14396: IF (is_debug_statement_on)
14397: THEN
14398: okl_debug_pub.log_debug (g_level_statement,
14399: l_module_name,
14400: 'calling OKL_AM_UTIL_PVT.process_messages'
14401: );
14402: END IF;
14403:
14404: okl_am_util_pvt.process_messages

Line 14404: okl_am_util_pvt.process_messages

14400: 'calling OKL_AM_UTIL_PVT.process_messages'
14401: );
14402: END IF;
14403:
14404: okl_am_util_pvt.process_messages
14405: (p_trx_source_table => 'OKL_TRX_CONTRACTS',
14406: p_trx_id => lp_tcnv_rec.ID,
14407: x_return_status => l_return_status
14408: );

Line 14415: 'called OKL_AM_UTIL_PVT.process_messages , return status: '

14411: THEN
14412: okl_debug_pub.log_debug
14413: (g_level_statement,
14414: l_module_name,
14415: 'called OKL_AM_UTIL_PVT.process_messages , return status: '
14416: || l_return_status
14417: );
14418: END IF;
14419:

Line 14522: 'calling OKL_AM_UTIL_PVT.process_messages'

14518: THEN
14519: okl_debug_pub.log_debug
14520: (g_level_statement,
14521: l_module_name,
14522: 'calling OKL_AM_UTIL_PVT.process_messages'
14523: );
14524: END IF;
14525:
14526: okl_am_util_pvt.process_messages

Line 14526: okl_am_util_pvt.process_messages

14522: 'calling OKL_AM_UTIL_PVT.process_messages'
14523: );
14524: END IF;
14525:
14526: okl_am_util_pvt.process_messages
14527: (p_trx_source_table => 'OKL_TRX_CONTRACTS',
14528: p_trx_id => lp_tcnv_rec.ID,
14529: x_return_status => l_return_status
14530: );

Line 14537: 'called OKL_AM_UTIL_PVT.process_messages , return status: '

14533: THEN
14534: okl_debug_pub.log_debug
14535: (g_level_statement,
14536: l_module_name,
14537: 'called OKL_AM_UTIL_PVT.process_messages , return status: '
14538: || l_return_status
14539: );
14540: END IF;
14541:

Line 14765: 'calling OKL_AM_UTIL_PVT.process_messages'

14761: THEN
14762: okl_debug_pub.log_debug
14763: (g_level_statement,
14764: l_module_name,
14765: 'calling OKL_AM_UTIL_PVT.process_messages'
14766: );
14767: END IF;
14768:
14769: okl_am_util_pvt.process_messages

Line 14769: okl_am_util_pvt.process_messages

14765: 'calling OKL_AM_UTIL_PVT.process_messages'
14766: );
14767: END IF;
14768:
14769: okl_am_util_pvt.process_messages
14770: (p_trx_source_table => 'OKL_TRX_CONTRACTS',
14771: p_trx_id => lp_tcnv_rec.ID,
14772: x_return_status => l_return_status
14773: );

Line 14780: 'called OKL_AM_UTIL_PVT.process_messages , return status: '

14776: THEN
14777: okl_debug_pub.log_debug
14778: (g_level_statement,
14779: l_module_name,
14780: 'called OKL_AM_UTIL_PVT.process_messages , return status: '
14781: || l_return_status
14782: );
14783: END IF;
14784:

Line 14893: 'calling OKL_AM_UTIL_PVT.process_messages'

14889: IF (is_debug_statement_on)
14890: THEN
14891: okl_debug_pub.log_debug (g_level_statement,
14892: l_module_name,
14893: 'calling OKL_AM_UTIL_PVT.process_messages'
14894: );
14895: END IF;
14896:
14897: okl_am_util_pvt.process_messages

Line 14897: okl_am_util_pvt.process_messages

14893: 'calling OKL_AM_UTIL_PVT.process_messages'
14894: );
14895: END IF;
14896:
14897: okl_am_util_pvt.process_messages
14898: (p_trx_source_table => 'OKL_TRX_CONTRACTS',
14899: p_trx_id => lp_tcnv_rec.ID,
14900: x_return_status => l_return_status
14901: );

Line 14908: 'called OKL_AM_UTIL_PVT.process_messages , return status: '

14904: THEN
14905: okl_debug_pub.log_debug
14906: (g_level_statement,
14907: l_module_name,
14908: 'called OKL_AM_UTIL_PVT.process_messages , return status: '
14909: || l_return_status
14910: );
14911: END IF;
14912: