APPS.JAI_RGM_THHOLD_PROC_PKG dependencies on FND_LOG

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 159: ln_login_id fnd_logins.login_id%type := fnd_global.login_id;

155: ln_trx_ref_id jai_rgm_refs_all.trx_ref_id%type;
156: ln_currency_code jai_rgm_taxes.currency_code%type;
157:
158: ln_user_id fnd_user.user_id%type := fnd_global.user_id;
159: ln_login_id fnd_logins.login_id%type := fnd_global.login_id;
160:
161: -- start, Bgowrava for Forward porting Bug#5989740
162: ln_surcharge_sh_cess_tax_id jai_rgm_taxes.tax_id%type;
163: ln_surcharge_sh_cess_tax_rate jai_rgm_taxes.tax_rate%type;

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

1178: r_taxes jai_cmn_tax_defaultation_pkg.tax_rec_typ;
1179:
1180: ln_tax_amount number ;
1181: ln_user_id fnd_user.user_id%type := fnd_global.user_id;
1182: ln_login_id fnd_logins.login_id%type := fnd_global.login_id;
1183: lv_currency fnd_currencies.currency_code%type;
1184: ln_curr_conv_factor number;
1185: ln_exists number(2);
1186:

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

1607: ln_thhold_tax_cat_id jai_ap_tds_thhold_taxes.tax_category_id%type;
1608:
1609:
1610: ln_user_id fnd_user.user_id%type := fnd_global.user_id;
1611: ln_login_id fnd_logins.login_id%type := fnd_global.login_id;
1612:
1613:
1614:
1615: begin

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

2261: ln_total_thhold_amt jai_rgm_thresholds.total_threshold_amt%type;
2262: ln_total_thhold_base_amt jai_rgm_thresholds.total_threshold_base_amt%type;
2263:
2264: ln_user_id fnd_user.user_id%type := fnd_global.user_id;
2265: ln_login_id fnd_logins.login_id%type := fnd_global.login_id;
2266:
2267:
2268: begin
2269: /** Initialize process variables */