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 11871: okl_am_util_pvt.get_actual_asset_residual

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

Line 14227: 'calling OKL_AM_UTIL_PVT.process_messages'

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

Line 14231: okl_am_util_pvt.process_messages

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

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

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

Line 14324: 'calling OKL_AM_UTIL_PVT.process_messages'

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

Line 14328: okl_am_util_pvt.process_messages

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

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

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

Line 14399: 'calling OKL_AM_UTIL_PVT.process_messages'

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

Line 14403: okl_am_util_pvt.process_messages

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

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

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

Line 14521: 'calling OKL_AM_UTIL_PVT.process_messages'

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

Line 14525: okl_am_util_pvt.process_messages

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

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

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

Line 14764: 'calling OKL_AM_UTIL_PVT.process_messages'

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

Line 14768: okl_am_util_pvt.process_messages

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

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

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

Line 14892: 'calling OKL_AM_UTIL_PVT.process_messages'

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

Line 14896: okl_am_util_pvt.process_messages

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

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

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