DBA Data[Home] [Help]

APPS.JAI_AR_MATCH_TAX_PKG dependencies on FND_LOG

Line 4471: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

4467: ln_tax_def_acc_id NUMBER;
4468: ln_tax_rgm_acc_id NUMBER;
4469: ln_tax_acc_id NUMBER;
4470: lv_procedure_name VARCHAR2(40):='get_tax_account_id';
4471: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4472: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
4473:
4474: BEGIN
4475: --logging for debug

Line 4472: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

4468: ln_tax_rgm_acc_id NUMBER;
4469: ln_tax_acc_id NUMBER;
4470: lv_procedure_name VARCHAR2(40):='get_tax_account_id';
4471: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4472: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
4473:
4474: BEGIN
4475: --logging for debug
4476: IF (ln_proc_level >= ln_dbg_level)

Line 4478: FND_LOG.STRING( ln_proc_level

4474: BEGIN
4475: --logging for debug
4476: IF (ln_proc_level >= ln_dbg_level)
4477: THEN
4478: FND_LOG.STRING( ln_proc_level
4479: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
4480: , 'Enter procedure'
4481: );
4482: FND_LOG.STRING( ln_proc_level

Line 4482: FND_LOG.STRING( ln_proc_level

4478: FND_LOG.STRING( ln_proc_level
4479: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
4480: , 'Enter procedure'
4481: );
4482: FND_LOG.STRING( ln_proc_level
4483: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.parameter'
4484: , 'Org_id = ' || pn_org_id
4485: );
4486: FND_LOG.STRING( ln_proc_level

Line 4486: FND_LOG.STRING( ln_proc_level

4482: FND_LOG.STRING( ln_proc_level
4483: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.parameter'
4484: , 'Org_id = ' || pn_org_id
4485: );
4486: FND_LOG.STRING( ln_proc_level
4487: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.parameter'
4488: , 'Tax_id = '|| pn_tax_id ||' Tax_type = ' || pv_tax_type
4489: );
4490: END IF; --ln_proc_level>=l_dbg_level

Line 4539: FND_LOG.STRING( ln_proc_level

4535: END;
4536:
4537: IF (ln_proc_level >= ln_dbg_level)
4538: THEN
4539: FND_LOG.STRING( ln_proc_level
4540: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.result'
4541: , 'Tax Account ID = ' || ln_tax_acc_id
4542: );
4543: FND_LOG.STRING( ln_proc_level

Line 4543: FND_LOG.STRING( ln_proc_level

4539: FND_LOG.STRING( ln_proc_level
4540: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.result'
4541: , 'Tax Account ID = ' || ln_tax_acc_id
4542: );
4543: FND_LOG.STRING( ln_proc_level
4544: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
4545: , 'Enter procedure'
4546: );
4547: END IF; -- ln_proc_level >= ln_dbg_level

Line 4696: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

4692: , b.tax_type
4693: , nvl(b.rounding_factor,0);--Added by zhiwei for bug#12433891 20110509;
4694:
4695: lv_procedure_name VARCHAR2(40):='acct_inclu_taxes';
4696: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4697: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
4698:
4699:
4700: lv_acc_class_rev CONSTANT varchar2(10) := 'REV'; --bug#9461197

Line 4697: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

4693: , nvl(b.rounding_factor,0);--Added by zhiwei for bug#12433891 20110509;
4694:
4695: lv_procedure_name VARCHAR2(40):='acct_inclu_taxes';
4696: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4697: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
4698:
4699:
4700: lv_acc_class_rev CONSTANT varchar2(10) := 'REV'; --bug#9461197
4701:

Line 4911: FND_LOG.STRING( ln_proc_level

4907: BEGIN
4908: --logging for debug
4909: IF (ln_proc_level >= ln_dbg_level)
4910: THEN
4911: FND_LOG.STRING( ln_proc_level
4912: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
4913: , 'Enter procedure'
4914: );
4915: END IF; --ln_proc_level>=l_dbg_level

Line 5445: FND_LOG.STRING( ln_proc_level

5441:
5442: --logging for debug
5443: IF (ln_proc_level >= ln_dbg_level)
5444: THEN
5445: FND_LOG.STRING( ln_proc_level
5446: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
5447: , 'Exit procedure'
5448: );
5449: END IF; -- (ln_proc_level>=ln_dbg_level)

Line 5458: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

5454: WHEN OTHERS THEN
5455: xv_process_flag := 'UE';
5456: xv_process_message := Sqlerrm||'. Exception error in acct_inclu_taxes procedure';
5457:
5458: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5459: THEN
5460: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
5461: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
5462: , Sqlcode||Sqlerrm);

Line 5460: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

5456: xv_process_message := Sqlerrm||'. Exception error in acct_inclu_taxes procedure';
5457:
5458: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5459: THEN
5460: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
5461: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
5462: , Sqlcode||Sqlerrm);
5463: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5464:

Line 5463: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

5459: THEN
5460: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
5461: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
5462: , Sqlcode||Sqlerrm);
5463: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5464:
5465: END acct_inclu_taxes;
5466: -- Added by Jia Li on tax inclusive computation on 2007/11/30, End
5467:

Line 5516: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

5512: cv_seperator CONSTANT VARCHAR2(30) := ';';
5513: lv_reference ra_customer_trx_all.ct_reference%TYPE;
5514: lv_reference_check ra_customer_trx_all.ct_reference%TYPE;
5515: lv_procedure_name VARCHAR2(40):='display_all_invoice_num';
5516: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5517: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
5518:
5519: -- check the invoice numbers are in the referece field or not
5520: CURSOR check_reference IS

Line 5517: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

5513: lv_reference ra_customer_trx_all.ct_reference%TYPE;
5514: lv_reference_check ra_customer_trx_all.ct_reference%TYPE;
5515: lv_procedure_name VARCHAR2(40):='display_all_invoice_num';
5516: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5517: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
5518:
5519: -- check the invoice numbers are in the referece field or not
5520: CURSOR check_reference IS
5521: SELECT ct_reference

Line 5529: FND_LOG.STRING( ln_proc_level

5525: BEGIN
5526: --logging for debug
5527: IF (ln_proc_level >= ln_dbg_level)
5528: THEN
5529: FND_LOG.STRING( ln_proc_level
5530: , lv_procedure_name || '.begin'
5531: , 'Enter procedure'
5532: );
5533: END IF; --l_proc_level>=l_dbg_level

Line 5654: FND_LOG.STRING( ln_proc_level

5650:
5651: --logging for debug
5652: /*IF (ln_proc_level >= ln_dbg_level)
5653: THEN
5654: FND_LOG.STRING( ln_proc_level
5655: , lv_procedure_name || '.end'
5656: , 'Exit procedure');
5657: END IF;*/
5658: END update_all_invoice_num;