DBA Data[Home] [Help]

APPS.JAI_AR_TCS_REP_PKG dependencies on FND_LOG

Line 126: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_STATEMENT, 'JAI.PLSQL.JAI_AR_TCS_REP_PKG.get_tcs_fin_year'

122: OPEN c_get_period_year(lv_gl_calendar_id,cp_trx_date);
123: FETCH c_get_period_year INTO lv_fin_year;
124: CLOSE c_get_period_year;
125:
126: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_STATEMENT, 'JAI.PLSQL.JAI_AR_TCS_REP_PKG.get_tcs_fin_year'
127: ,'Get ' || cp_rgm_code || ' Finanical year: ' || lv_fin_year);
128: return lv_fin_year;
129:
130: EXCEPTION

Line 132: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_UNEXPECTED, 'JAI.PLSQL.JAI_AR_TCS_REP_PKG.get_tcs_fin_year.Other_Exception '

128: return lv_fin_year;
129:
130: EXCEPTION
131: WHEN OTHERS THEN
132: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_UNEXPECTED, 'JAI.PLSQL.JAI_AR_TCS_REP_PKG.get_tcs_fin_year.Other_Exception '
133: , SQLCODE || ':' || SQLERRM
134: );
135:
136: END get_tcs_fin_year;

Line 5978: ln_login_id fnd_logins.login_id%type := fnd_global.login_id;

5974: ln_customer_type_lkup_code JAI_CMN_CUS_ADDRESSES.tcs_customer_type%type;
5975: ln_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%type default NULL;
5976: lr_hdr_record jai_rgm_thresholds%rowtype;
5977: ln_user_id fnd_user.user_id%type := fnd_global.user_id;
5978: ln_login_id fnd_logins.login_id%type := fnd_global.login_id;
5979: ln_count NUMBER;
5980: ln_threshold_id jai_rgm_thresholds.threshold_id%type default NULL;
5981: BEGIN
5982: -- code ported from BL12.1.3 by zhiwei.xin on 15-MAR-2013 begin