DBA Data[Home] [Help]

APPS.JAI_AP_UTILS_PKG dependencies on FND_LOG

Line 2761: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2757: ln_tax_def_acc_id NUMBER;
2758: ln_tax_rgm_acc_id NUMBER;
2759: ln_tax_acc_id NUMBER;
2760: lv_procedure_name VARCHAR2(40):='get_tax_account_id';
2761: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2762: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
2763:
2764: CURSOR cur_tax_acc IS
2765: SELECT

Line 2762: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

2758: ln_tax_rgm_acc_id NUMBER;
2759: ln_tax_acc_id NUMBER;
2760: lv_procedure_name VARCHAR2(40):='get_tax_account_id';
2761: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2762: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
2763:
2764: CURSOR cur_tax_acc IS
2765: SELECT
2766: tax_account_id

Line 2775: FND_LOG.STRING( ln_proc_level

2771: BEGIN
2772: --logging for debug
2773: IF (ln_proc_level >= ln_dbg_level)
2774: THEN
2775: FND_LOG.STRING( ln_proc_level
2776: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
2777: , 'Enter procedure'
2778: );
2779: FND_LOG.STRING( ln_proc_level

Line 2779: FND_LOG.STRING( ln_proc_level

2775: FND_LOG.STRING( ln_proc_level
2776: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
2777: , 'Enter procedure'
2778: );
2779: FND_LOG.STRING( ln_proc_level
2780: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.parameter'
2781: , 'Org_id = ' || pn_org_id
2782: );
2783: FND_LOG.STRING( ln_proc_level

Line 2783: FND_LOG.STRING( ln_proc_level

2779: FND_LOG.STRING( ln_proc_level
2780: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.parameter'
2781: , 'Org_id = ' || pn_org_id
2782: );
2783: FND_LOG.STRING( ln_proc_level
2784: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.parameter'
2785: , 'Tax_id = '|| pn_tax_id ||' Tax_type = ' || pv_tax_type
2786: );
2787: END IF; --ln_proc_level>=l_dbg_level

Line 2823: FND_LOG.STRING( ln_proc_level

2819: END;
2820:
2821: IF (ln_proc_level >= ln_dbg_level)
2822: THEN
2823: FND_LOG.STRING( ln_proc_level
2824: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.result'
2825: , 'Tax Account ID = ' || ln_tax_acc_id
2826: );
2827: FND_LOG.STRING( ln_proc_level

Line 2827: FND_LOG.STRING( ln_proc_level

2823: FND_LOG.STRING( ln_proc_level
2824: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.result'
2825: , 'Tax Account ID = ' || ln_tax_acc_id
2826: );
2827: FND_LOG.STRING( ln_proc_level
2828: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
2829: , 'Enter procedure'
2830: );
2831: END IF; -- ln_proc_level >= ln_dbg_level

Line 3007: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

3003: ln_cr_line_amt NUMBER;
3004: ln_total_cr_line_amt NUMBER;
3005:
3006: lv_procedure_name VARCHAR2(40):='acct_inclu_taxes';
3007: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3008: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
3009:
3010: CURSOR match_inclu_tax_cur
3011: ( pn_invoice_line_num NUMBER

Line 3008: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

3004: ln_total_cr_line_amt NUMBER;
3005:
3006: lv_procedure_name VARCHAR2(40):='acct_inclu_taxes';
3007: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3008: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
3009:
3010: CURSOR match_inclu_tax_cur
3011: ( pn_invoice_line_num NUMBER
3012: )

Line 3065: FND_LOG.STRING( ln_proc_level

3061: BEGIN
3062: --logging for debug
3063: IF (ln_proc_level >= ln_dbg_level)
3064: THEN
3065: FND_LOG.STRING( ln_proc_level
3066: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
3067: , 'Enter procedure'
3068: );
3069: END IF; --ln_proc_level>=l_dbg_level

Line 3223: FND_LOG.STRING( ln_proc_level

3219:
3220: ln_total_inclu_tax_amt := ln_total_inclu_tax_amt + standalone_inclu_tax_csr.tax_amount;
3221: IF (ln_proc_level >= ln_dbg_level)
3222: THEN
3223: FND_LOG.STRING( ln_proc_level
3224: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.debug'
3225: , 'Inclusive tax account = '|| ln_tax_account_id
3226: );
3227: FND_LOG.STRING( ln_proc_level

Line 3227: FND_LOG.STRING( ln_proc_level

3223: FND_LOG.STRING( ln_proc_level
3224: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.debug'
3225: , 'Inclusive tax account = '|| ln_tax_account_id
3226: );
3227: FND_LOG.STRING( ln_proc_level
3228: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.debug'
3229: , 'Inclusive tax amount = '|| standalone_inclu_tax_csr.tax_amount
3230: );
3231: END IF; --ln_proc_level>=l_dbg_level

Line 3262: FND_LOG.STRING( ln_proc_level

3258:
3259: ln_total_inclu_tax_amt := ln_total_inclu_tax_amt + match_inclu_tax_csr.tax_amount;
3260: IF (ln_proc_level >= ln_dbg_level)
3261: THEN
3262: FND_LOG.STRING( ln_proc_level
3263: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.debug'
3264: , 'Inclusive tax account = '|| ln_tax_account_id
3265: );
3266: FND_LOG.STRING( ln_proc_level

Line 3266: FND_LOG.STRING( ln_proc_level

3262: FND_LOG.STRING( ln_proc_level
3263: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.debug'
3264: , 'Inclusive tax account = '|| ln_tax_account_id
3265: );
3266: FND_LOG.STRING( ln_proc_level
3267: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.debug'
3268: , 'Inclusive tax amount = '|| match_inclu_tax_csr.tax_amount
3269: );
3270: END IF; --ln_proc_level>=l_dbg_level

Line 3316: FND_LOG.STRING( ln_proc_level

3312:
3313: --logging for debug
3314: IF (ln_proc_level >= ln_dbg_level)
3315: THEN
3316: FND_LOG.STRING( ln_proc_level
3317: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
3318: , 'Exit procedure'
3319: );
3320: END IF; -- (ln_proc_level>=ln_dbg_level)

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

3323: WHEN OTHERS THEN
3324: xv_process_flag := 'UE';
3325: xv_process_message := 'Exception error in acct_inclu_taxes procedure';
3326:
3327: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3328: THEN
3329: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
3330: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
3331: , Sqlcode||Sqlerrm);

Line 3329: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

3325: xv_process_message := 'Exception error in acct_inclu_taxes procedure';
3326:
3327: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3328: THEN
3329: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
3330: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
3331: , Sqlcode||Sqlerrm);
3332: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3333:

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

3328: THEN
3329: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
3330: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
3331: , Sqlcode||Sqlerrm);
3332: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3333:
3334: END acct_inclu_taxes;
3335:
3336: -- Added by Jia Li on tax inclusive computation on 2007/12/17, End

Line 3434: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_STATEMENT, 'JAI.PLSQL.JAI_AP_UTILS_PKG.get_section_code', 'get effective section code:' || lv_section_code);

3430: );
3431: FETCH cur_get_section_code INTO lv_section_code;
3432: CLOSE cur_get_section_code;
3433:
3434: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_STATEMENT, 'JAI.PLSQL.JAI_AP_UTILS_PKG.get_section_code', 'get effective section code:' || lv_section_code);
3435: RETURN lv_section_code;
3436: END get_section_code;
3437:
3438: FUNCTION GET_NATURAL_ACCOUNT_VALUE (PN_DISTRIBUTION_CCID NUMBER, PV_SEGMENT_NAME VARCHAR2) RETURN VARCHAR2

Line 4139: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_PROCEDURE, 'JAI.PLSQL.JAI_AP_UTILS_PKG.insert_jai_cmn_taxes_all',

4135: ,p_jai_cmn_taxes_all_rec.auto_create_category
4136: ,p_jai_cmn_taxes_all_rec.reverse_charge_flag
4137: );
4138:
4139: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_PROCEDURE, 'JAI.PLSQL.JAI_AP_UTILS_PKG.insert_jai_cmn_taxes_all',
4140: 'Created a new tax code ' || p_jai_cmn_taxes_all_rec.tax_id || '-' || p_jai_cmn_taxes_all_rec.tax_name);
4141:
4142: END insert_jai_cmn_taxes_all;
4143:

Line 4210: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_PROCEDURE, 'JAI.PLSQL.JAI_AP_UTILS_PKG.insert_jai_cmn_tax_ctg_lines',

4206: ,p_jai_cmn_tax_ctg_lines_rec.last_update_login
4207: ,p_jai_cmn_tax_ctg_lines_rec.object_version_number
4208: );
4209:
4210: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_PROCEDURE, 'JAI.PLSQL.JAI_AP_UTILS_PKG.insert_jai_cmn_tax_ctg_lines',
4211: 'Created a tax category line ' || p_jai_cmn_tax_ctg_lines_rec.line_no || '-' || p_jai_cmn_tax_ctg_lines_rec.tax_id);
4212:
4213: END insert_jai_cmn_tax_ctg_lines;
4214: ------------------------------------------------------------------------------------------------