APPS.JAI_RGM_THHOLD_PROC_PKG dependencies on JAI_RGM_THHOLD_PROC_PKG

Line 1: package body jai_rgm_thhold_proc_pkg AS

1: package body jai_rgm_thhold_proc_pkg AS
2: /*$Header: jai_rgm_thld_prc.plb 120.5.12020000.4 2013/03/18 06:01:33 zxin ship $ */
3:
4: /* ----------------------------------------------------------------------------
5:

Line 43: lv_object_name jai_cmn_debug_contexts.log_context%type default 'TCS.JAI_RGM_THHOLD_PROC_PKG';

39:
40: /*----------------------------------------- PRIVATE MEMBERS DECLRATION -------------------------------------*/
41:
42: /** Package level variables used in debug package*/
43: lv_object_name jai_cmn_debug_contexts.log_context%type default 'TCS.JAI_RGM_THHOLD_PROC_PKG';
44: lv_member_name jai_cmn_debug_contexts.log_context%type;
45: lv_context jai_cmn_debug_contexts.log_context%type;
46:
47: procedure set_debug_context

Line 115: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_STATEMENT, 'JAI.PLSQL.jai_rgm_thhold_proc_pkg.get_tcs_fin_year'

111: OPEN c_get_period_year(lv_gl_calendar_id,cp_trx_date);
112: FETCH c_get_period_year INTO lv_fin_year;
113: CLOSE c_get_period_year;
114:
115: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_STATEMENT, 'JAI.PLSQL.jai_rgm_thhold_proc_pkg.get_tcs_fin_year'
116: ,'Get ' || cp_rgm_code || ' Finanical year: ' || lv_fin_year);
117: return lv_fin_year;
118:
119: EXCEPTION

Line 121: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_UNEXPECTED, 'JAI.PLSQL.jai_rgm_thhold_proc_pkg.get_tcs_fin_year.Other_Exception '

117: return lv_fin_year;
118:
119: EXCEPTION
120: WHEN OTHERS THEN
121: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_UNEXPECTED, 'JAI.PLSQL.jai_rgm_thhold_proc_pkg.get_tcs_fin_year.Other_Exception '
122: , SQLCODE || ':' || SQLERRM
123: );
124:
125: END get_tcs_fin_year;

Line 483: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before: JAI_RGM_THHOLD_PROC_PKG.GET_THRESHOLD_TAX_CAT_ID');

479: /**
480: if this is the first iteration, get tax category for the slab . In other way if we already have tax_category_id (say -1) don't
481: even make a call to get_threshold_tax_cat_id API
482: */
483: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before: JAI_RGM_THHOLD_PROC_PKG.GET_THRESHOLD_TAX_CAT_ID');
484:
485: if ln_threshold_tax_cat_id is null then
486: /** Control will never come here if THRESHOLD_SLAB_ID is null (i.e. if no slab is applicable) */
487: jai_rgm_thhold_proc_pkg.get_threshold_tax_cat_id

Line 487: jai_rgm_thhold_proc_pkg.get_threshold_tax_cat_id

483: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before: JAI_RGM_THHOLD_PROC_PKG.GET_THRESHOLD_TAX_CAT_ID');
484:
485: if ln_threshold_tax_cat_id is null then
486: /** Control will never come here if THRESHOLD_SLAB_ID is null (i.e. if no slab is applicable) */
487: jai_rgm_thhold_proc_pkg.get_threshold_tax_cat_id
488: ( p_threshold_slab_id => r_thhold_info.threshold_slab_id
489: , p_org_id => p_org_id
490: , p_threshold_tax_cat_id => ln_threshold_tax_cat_id
491: , p_process_flag => p_process_flag

Line 497: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After: JAI_RGM_THHOLD_PROC_PKG.GET_THRESHOLD_TAX_CAT_ID');

493: );
494:
495: end if;
496:
497: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After: JAI_RGM_THHOLD_PROC_PKG.GET_THRESHOLD_TAX_CAT_ID');
498: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'p_process_flag='||p_process_flag||', p_process_message='||p_process_message); */ --commented by bgowrava for bug#5631784
499:
500: if p_process_flag <> jai_constants.successful then
501: return;

Line 1881: jai_rgm_thhold_proc_pkg.get_threshold_tax_cat_id

1877:
1878: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Calling GET_THRESHOLD_TAX_CAT_ID to get tax category for current slab='||lr_hdr_record.threshold_slab_id );*/ --commented by bgowrava for bug#5631784
1879:
1880: if lr_hdr_record.threshold_slab_id is not null then
1881: jai_rgm_thhold_proc_pkg.get_threshold_tax_cat_id
1882: (
1883: p_threshold_slab_id => lr_hdr_record.threshold_slab_id
1884: , p_org_id => r_trx_lines.org_id
1885: , p_threshold_tax_cat_id => ln_thhold_tax_cat_id

Line 2319: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before JAI_RGM_THHOLD_PROC_PKG.GET_THRESHOLD_SLAB_ID'); */ --commented by bgowrava for bug#5631784

2315: close c_get_thhold_hdr_info;
2316:
2317: /** Get what is new threshold_slab_id*/
2318:
2319: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before JAI_RGM_THHOLD_PROC_PKG.GET_THRESHOLD_SLAB_ID'); */ --commented by bgowrava for bug#5631784
2320: jai_rgm_thhold_proc_pkg.get_threshold_slab_id
2321: ( p_regime_id => ln_regime_id
2322: , p_org_tan_no => lv_org_tan_no
2323: , p_party_type => lv_party_type

Line 2320: jai_rgm_thhold_proc_pkg.get_threshold_slab_id

2316:
2317: /** Get what is new threshold_slab_id*/
2318:
2319: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before JAI_RGM_THHOLD_PROC_PKG.GET_THRESHOLD_SLAB_ID'); */ --commented by bgowrava for bug#5631784
2320: jai_rgm_thhold_proc_pkg.get_threshold_slab_id
2321: ( p_regime_id => ln_regime_id
2322: , p_org_tan_no => lv_org_tan_no
2323: , p_party_type => lv_party_type
2324: , p_party_id => ln_party_id

Line 2332: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After JAI_RGM_THHOLD_PROC_PKG.GET_THRESHOLD_SLAB_ID');

2328: , p_threshold_slab_id => ln_new_thhold_slab_id
2329: , p_process_flag => p_process_flag
2330: , p_process_message => p_process_message
2331: );
2332: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After JAI_RGM_THHOLD_PROC_PKG.GET_THRESHOLD_SLAB_ID');
2333: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'p_process_flag='||p_process_flag||',p_process_message='||p_process_message);*/ --commented by bgowrava for bug#5631784
2334: if p_process_flag <> jai_constants.successful then
2335: return;
2336: end if;

Line 2373: end jai_rgm_thhold_proc_pkg;

2369:
2370: end sync_threshold_header;
2371: /*------------------------------------------------------------------------------------------------------------*/
2372:
2373: end jai_rgm_thhold_proc_pkg;