eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PAY_NO_EMP_CONT_2007 dependencies on HR_UTILITY

Line 169: -- hr_utility.trace_on(null,'NOEC');

165: --------------- Begin -------------------------------------
166:
167: BEGIN
168:
169: -- hr_utility.trace_on(null,'NOEC');
170: hr_utility.trace('2007 EMP_CONT ::: Enterd procedure GET_EMPLOYER_DEDUCTION ----------------------------------');
171: hr_utility.trace('2007 EMP_CONT ::: -------------------------------------------------');
172: hr_utility.trace('2007 EMP_CONT ::: p_tax_unit_id = '|| p_tax_unit_id );
173: hr_utility.trace('2007 EMP_CONT ::: p_local_unit_id = '|| p_local_unit_id );

Line 170: hr_utility.trace('2007 EMP_CONT ::: Enterd procedure GET_EMPLOYER_DEDUCTION ----------------------------------');

166:
167: BEGIN
168:
169: -- hr_utility.trace_on(null,'NOEC');
170: hr_utility.trace('2007 EMP_CONT ::: Enterd procedure GET_EMPLOYER_DEDUCTION ----------------------------------');
171: hr_utility.trace('2007 EMP_CONT ::: -------------------------------------------------');
172: hr_utility.trace('2007 EMP_CONT ::: p_tax_unit_id = '|| p_tax_unit_id );
173: hr_utility.trace('2007 EMP_CONT ::: p_local_unit_id = '|| p_local_unit_id );
174: hr_utility.trace('2007 EMP_CONT ::: p_jurisdiction_code = '|| p_jurisdiction_code );

Line 171: hr_utility.trace('2007 EMP_CONT ::: -------------------------------------------------');

167: BEGIN
168:
169: -- hr_utility.trace_on(null,'NOEC');
170: hr_utility.trace('2007 EMP_CONT ::: Enterd procedure GET_EMPLOYER_DEDUCTION ----------------------------------');
171: hr_utility.trace('2007 EMP_CONT ::: -------------------------------------------------');
172: hr_utility.trace('2007 EMP_CONT ::: p_tax_unit_id = '|| p_tax_unit_id );
173: hr_utility.trace('2007 EMP_CONT ::: p_local_unit_id = '|| p_local_unit_id );
174: hr_utility.trace('2007 EMP_CONT ::: p_jurisdiction_code = '|| p_jurisdiction_code );
175: hr_utility.trace('2007 EMP_CONT ::: p_payroll_id = '|| p_payroll_id );

Line 172: hr_utility.trace('2007 EMP_CONT ::: p_tax_unit_id = '|| p_tax_unit_id );

168:
169: -- hr_utility.trace_on(null,'NOEC');
170: hr_utility.trace('2007 EMP_CONT ::: Enterd procedure GET_EMPLOYER_DEDUCTION ----------------------------------');
171: hr_utility.trace('2007 EMP_CONT ::: -------------------------------------------------');
172: hr_utility.trace('2007 EMP_CONT ::: p_tax_unit_id = '|| p_tax_unit_id );
173: hr_utility.trace('2007 EMP_CONT ::: p_local_unit_id = '|| p_local_unit_id );
174: hr_utility.trace('2007 EMP_CONT ::: p_jurisdiction_code = '|| p_jurisdiction_code );
175: hr_utility.trace('2007 EMP_CONT ::: p_payroll_id = '|| p_payroll_id );
176: hr_utility.trace('2007 EMP_CONT ::: p_payroll_action_id = '|| p_payroll_action_id );

Line 173: hr_utility.trace('2007 EMP_CONT ::: p_local_unit_id = '|| p_local_unit_id );

169: -- hr_utility.trace_on(null,'NOEC');
170: hr_utility.trace('2007 EMP_CONT ::: Enterd procedure GET_EMPLOYER_DEDUCTION ----------------------------------');
171: hr_utility.trace('2007 EMP_CONT ::: -------------------------------------------------');
172: hr_utility.trace('2007 EMP_CONT ::: p_tax_unit_id = '|| p_tax_unit_id );
173: hr_utility.trace('2007 EMP_CONT ::: p_local_unit_id = '|| p_local_unit_id );
174: hr_utility.trace('2007 EMP_CONT ::: p_jurisdiction_code = '|| p_jurisdiction_code );
175: hr_utility.trace('2007 EMP_CONT ::: p_payroll_id = '|| p_payroll_id );
176: hr_utility.trace('2007 EMP_CONT ::: p_payroll_action_id = '|| p_payroll_action_id );
177: hr_utility.trace('2007 EMP_CONT ::: p_asg_act_id = '|| p_asg_act_id );

Line 174: hr_utility.trace('2007 EMP_CONT ::: p_jurisdiction_code = '|| p_jurisdiction_code );

170: hr_utility.trace('2007 EMP_CONT ::: Enterd procedure GET_EMPLOYER_DEDUCTION ----------------------------------');
171: hr_utility.trace('2007 EMP_CONT ::: -------------------------------------------------');
172: hr_utility.trace('2007 EMP_CONT ::: p_tax_unit_id = '|| p_tax_unit_id );
173: hr_utility.trace('2007 EMP_CONT ::: p_local_unit_id = '|| p_local_unit_id );
174: hr_utility.trace('2007 EMP_CONT ::: p_jurisdiction_code = '|| p_jurisdiction_code );
175: hr_utility.trace('2007 EMP_CONT ::: p_payroll_id = '|| p_payroll_id );
176: hr_utility.trace('2007 EMP_CONT ::: p_payroll_action_id = '|| p_payroll_action_id );
177: hr_utility.trace('2007 EMP_CONT ::: p_asg_act_id = '|| p_asg_act_id );
178: hr_utility.trace('2007 EMP_CONT ::: p_bus_group_id = '|| p_bus_group_id );

Line 175: hr_utility.trace('2007 EMP_CONT ::: p_payroll_id = '|| p_payroll_id );

171: hr_utility.trace('2007 EMP_CONT ::: -------------------------------------------------');
172: hr_utility.trace('2007 EMP_CONT ::: p_tax_unit_id = '|| p_tax_unit_id );
173: hr_utility.trace('2007 EMP_CONT ::: p_local_unit_id = '|| p_local_unit_id );
174: hr_utility.trace('2007 EMP_CONT ::: p_jurisdiction_code = '|| p_jurisdiction_code );
175: hr_utility.trace('2007 EMP_CONT ::: p_payroll_id = '|| p_payroll_id );
176: hr_utility.trace('2007 EMP_CONT ::: p_payroll_action_id = '|| p_payroll_action_id );
177: hr_utility.trace('2007 EMP_CONT ::: p_asg_act_id = '|| p_asg_act_id );
178: hr_utility.trace('2007 EMP_CONT ::: p_bus_group_id = '|| p_bus_group_id );
179: hr_utility.trace('2007 EMP_CONT ::: p_date_earned = '|| p_date_earned );

Line 176: hr_utility.trace('2007 EMP_CONT ::: p_payroll_action_id = '|| p_payroll_action_id );

172: hr_utility.trace('2007 EMP_CONT ::: p_tax_unit_id = '|| p_tax_unit_id );
173: hr_utility.trace('2007 EMP_CONT ::: p_local_unit_id = '|| p_local_unit_id );
174: hr_utility.trace('2007 EMP_CONT ::: p_jurisdiction_code = '|| p_jurisdiction_code );
175: hr_utility.trace('2007 EMP_CONT ::: p_payroll_id = '|| p_payroll_id );
176: hr_utility.trace('2007 EMP_CONT ::: p_payroll_action_id = '|| p_payroll_action_id );
177: hr_utility.trace('2007 EMP_CONT ::: p_asg_act_id = '|| p_asg_act_id );
178: hr_utility.trace('2007 EMP_CONT ::: p_bus_group_id = '|| p_bus_group_id );
179: hr_utility.trace('2007 EMP_CONT ::: p_date_earned = '|| p_date_earned );
180: hr_utility.trace('2007 EMP_CONT ::: p_under_age_high_rate = '|| p_under_age_high_rate );

Line 177: hr_utility.trace('2007 EMP_CONT ::: p_asg_act_id = '|| p_asg_act_id );

173: hr_utility.trace('2007 EMP_CONT ::: p_local_unit_id = '|| p_local_unit_id );
174: hr_utility.trace('2007 EMP_CONT ::: p_jurisdiction_code = '|| p_jurisdiction_code );
175: hr_utility.trace('2007 EMP_CONT ::: p_payroll_id = '|| p_payroll_id );
176: hr_utility.trace('2007 EMP_CONT ::: p_payroll_action_id = '|| p_payroll_action_id );
177: hr_utility.trace('2007 EMP_CONT ::: p_asg_act_id = '|| p_asg_act_id );
178: hr_utility.trace('2007 EMP_CONT ::: p_bus_group_id = '|| p_bus_group_id );
179: hr_utility.trace('2007 EMP_CONT ::: p_date_earned = '|| p_date_earned );
180: hr_utility.trace('2007 EMP_CONT ::: p_under_age_high_rate = '|| p_under_age_high_rate );
181: hr_utility.trace('2007 EMP_CONT ::: p_over_age_high_rate = '|| p_over_age_high_rate );

Line 178: hr_utility.trace('2007 EMP_CONT ::: p_bus_group_id = '|| p_bus_group_id );

174: hr_utility.trace('2007 EMP_CONT ::: p_jurisdiction_code = '|| p_jurisdiction_code );
175: hr_utility.trace('2007 EMP_CONT ::: p_payroll_id = '|| p_payroll_id );
176: hr_utility.trace('2007 EMP_CONT ::: p_payroll_action_id = '|| p_payroll_action_id );
177: hr_utility.trace('2007 EMP_CONT ::: p_asg_act_id = '|| p_asg_act_id );
178: hr_utility.trace('2007 EMP_CONT ::: p_bus_group_id = '|| p_bus_group_id );
179: hr_utility.trace('2007 EMP_CONT ::: p_date_earned = '|| p_date_earned );
180: hr_utility.trace('2007 EMP_CONT ::: p_under_age_high_rate = '|| p_under_age_high_rate );
181: hr_utility.trace('2007 EMP_CONT ::: p_over_age_high_rate = '|| p_over_age_high_rate );
182: hr_utility.trace('2007 EMP_CONT ::: -------------------------------------------------');

Line 179: hr_utility.trace('2007 EMP_CONT ::: p_date_earned = '|| p_date_earned );

175: hr_utility.trace('2007 EMP_CONT ::: p_payroll_id = '|| p_payroll_id );
176: hr_utility.trace('2007 EMP_CONT ::: p_payroll_action_id = '|| p_payroll_action_id );
177: hr_utility.trace('2007 EMP_CONT ::: p_asg_act_id = '|| p_asg_act_id );
178: hr_utility.trace('2007 EMP_CONT ::: p_bus_group_id = '|| p_bus_group_id );
179: hr_utility.trace('2007 EMP_CONT ::: p_date_earned = '|| p_date_earned );
180: hr_utility.trace('2007 EMP_CONT ::: p_under_age_high_rate = '|| p_under_age_high_rate );
181: hr_utility.trace('2007 EMP_CONT ::: p_over_age_high_rate = '|| p_over_age_high_rate );
182: hr_utility.trace('2007 EMP_CONT ::: -------------------------------------------------');
183:

Line 180: hr_utility.trace('2007 EMP_CONT ::: p_under_age_high_rate = '|| p_under_age_high_rate );

176: hr_utility.trace('2007 EMP_CONT ::: p_payroll_action_id = '|| p_payroll_action_id );
177: hr_utility.trace('2007 EMP_CONT ::: p_asg_act_id = '|| p_asg_act_id );
178: hr_utility.trace('2007 EMP_CONT ::: p_bus_group_id = '|| p_bus_group_id );
179: hr_utility.trace('2007 EMP_CONT ::: p_date_earned = '|| p_date_earned );
180: hr_utility.trace('2007 EMP_CONT ::: p_under_age_high_rate = '|| p_under_age_high_rate );
181: hr_utility.trace('2007 EMP_CONT ::: p_over_age_high_rate = '|| p_over_age_high_rate );
182: hr_utility.trace('2007 EMP_CONT ::: -------------------------------------------------');
183:
184:

Line 181: hr_utility.trace('2007 EMP_CONT ::: p_over_age_high_rate = '|| p_over_age_high_rate );

177: hr_utility.trace('2007 EMP_CONT ::: p_asg_act_id = '|| p_asg_act_id );
178: hr_utility.trace('2007 EMP_CONT ::: p_bus_group_id = '|| p_bus_group_id );
179: hr_utility.trace('2007 EMP_CONT ::: p_date_earned = '|| p_date_earned );
180: hr_utility.trace('2007 EMP_CONT ::: p_under_age_high_rate = '|| p_under_age_high_rate );
181: hr_utility.trace('2007 EMP_CONT ::: p_over_age_high_rate = '|| p_over_age_high_rate );
182: hr_utility.trace('2007 EMP_CONT ::: -------------------------------------------------');
183:
184:
185: -- cursor retrieves bimonth end date for the p_date_earned

Line 182: hr_utility.trace('2007 EMP_CONT ::: -------------------------------------------------');

178: hr_utility.trace('2007 EMP_CONT ::: p_bus_group_id = '|| p_bus_group_id );
179: hr_utility.trace('2007 EMP_CONT ::: p_date_earned = '|| p_date_earned );
180: hr_utility.trace('2007 EMP_CONT ::: p_under_age_high_rate = '|| p_under_age_high_rate );
181: hr_utility.trace('2007 EMP_CONT ::: p_over_age_high_rate = '|| p_over_age_high_rate );
182: hr_utility.trace('2007 EMP_CONT ::: -------------------------------------------------');
183:
184:
185: -- cursor retrieves bimonth end date for the p_date_earned
186: OPEN csr_get_bimonth_end_date (p_date_earned);

Line 196: hr_utility.trace('2007 EMP_CONT ::: l_curr_zone = '|| l_curr_zone );

192: -- zone will now be fetched from user tables, have to change the below call
193: -- l_curr_zone := to_number(substr(get_lookup_meaning('NO_TAX_MUNICIPALITY',p_jurisdiction_code),1,1));
194: l_curr_zone := hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', p_jurisdiction_code, p_date_earned ) ;
195:
196: hr_utility.trace('2007 EMP_CONT ::: l_curr_zone = '|| l_curr_zone );
197:
198: -- Get the Status , Report Separately and Tax Municipality for the Local Unit of the current assignment
199: OPEN PAY_NO_EMP_CONT_2007.get_lu_details(p_local_unit_id);
200: FETCH PAY_NO_EMP_CONT_2007.get_lu_details INTO l_lu_status , l_lu_rep_sep , l_lu_tax_mun ;

Line 203: hr_utility.trace('2007 EMP_CONT ::: l_lu_status = '|| l_lu_status );

199: OPEN PAY_NO_EMP_CONT_2007.get_lu_details(p_local_unit_id);
200: FETCH PAY_NO_EMP_CONT_2007.get_lu_details INTO l_lu_status , l_lu_rep_sep , l_lu_tax_mun ;
201: CLOSE PAY_NO_EMP_CONT_2007.get_lu_details;
202:
203: hr_utility.trace('2007 EMP_CONT ::: l_lu_status = '|| l_lu_status );
204: hr_utility.trace('2007 EMP_CONT ::: l_lu_rep_sep = '|| l_lu_rep_sep );
205: hr_utility.trace('2007 EMP_CONT ::: l_lu_tax_mun = '|| l_lu_tax_mun );
206: hr_utility.trace('2007 EMP_CONT ::: goin to test for local unit report separately..........');
207:

Line 204: hr_utility.trace('2007 EMP_CONT ::: l_lu_rep_sep = '|| l_lu_rep_sep );

200: FETCH PAY_NO_EMP_CONT_2007.get_lu_details INTO l_lu_status , l_lu_rep_sep , l_lu_tax_mun ;
201: CLOSE PAY_NO_EMP_CONT_2007.get_lu_details;
202:
203: hr_utility.trace('2007 EMP_CONT ::: l_lu_status = '|| l_lu_status );
204: hr_utility.trace('2007 EMP_CONT ::: l_lu_rep_sep = '|| l_lu_rep_sep );
205: hr_utility.trace('2007 EMP_CONT ::: l_lu_tax_mun = '|| l_lu_tax_mun );
206: hr_utility.trace('2007 EMP_CONT ::: goin to test for local unit report separately..........');
207:
208: -- check if Local Unit is Report separately = yes

Line 205: hr_utility.trace('2007 EMP_CONT ::: l_lu_tax_mun = '|| l_lu_tax_mun );

201: CLOSE PAY_NO_EMP_CONT_2007.get_lu_details;
202:
203: hr_utility.trace('2007 EMP_CONT ::: l_lu_status = '|| l_lu_status );
204: hr_utility.trace('2007 EMP_CONT ::: l_lu_rep_sep = '|| l_lu_rep_sep );
205: hr_utility.trace('2007 EMP_CONT ::: l_lu_tax_mun = '|| l_lu_tax_mun );
206: hr_utility.trace('2007 EMP_CONT ::: goin to test for local unit report separately..........');
207:
208: -- check if Local Unit is Report separately = yes
209: IF trim(l_lu_rep_sep) = 'Y'

Line 206: hr_utility.trace('2007 EMP_CONT ::: goin to test for local unit report separately..........');

202:
203: hr_utility.trace('2007 EMP_CONT ::: l_lu_status = '|| l_lu_status );
204: hr_utility.trace('2007 EMP_CONT ::: l_lu_rep_sep = '|| l_lu_rep_sep );
205: hr_utility.trace('2007 EMP_CONT ::: l_lu_tax_mun = '|| l_lu_tax_mun );
206: hr_utility.trace('2007 EMP_CONT ::: goin to test for local unit report separately..........');
207:
208: -- check if Local Unit is Report separately = yes
209: IF trim(l_lu_rep_sep) = 'Y'
210:

Line 214: hr_utility.trace('2007 EMP_CONT ::: Local unit is Rep Sep');

210:
211: THEN ---------------------------------------------------------------------------------------------------------------------------------
212: -- since LU is report separately, check if LE LU combination exists
213:
214: hr_utility.trace('2007 EMP_CONT ::: Local unit is Rep Sep');
215:
216: start_index_main := NVL (PAY_NO_EMP_CONT_2007.g_tab_main.FIRST, 0) ;
217: end_index_main := NVL (PAY_NO_EMP_CONT_2007.g_tab_main.LAST, 0) ;
218: l_le_lu_exists := FALSE;

Line 231: hr_utility.trace('2007 EMP_CONT ::: LE LU combination found');

227: THEN
228: l_le_lu_exists := TRUE;
229: l_le_lu_index := start_index_main;
230:
231: hr_utility.trace('2007 EMP_CONT ::: LE LU combination found');
232: hr_utility.trace('2007 EMP_CONT ::: l_le_lu_index = '|| l_le_lu_index );
233: EXIT;
234: END IF;
235: start_index_main := start_index_main + 1;

Line 232: hr_utility.trace('2007 EMP_CONT ::: l_le_lu_index = '|| l_le_lu_index );

228: l_le_lu_exists := TRUE;
229: l_le_lu_index := start_index_main;
230:
231: hr_utility.trace('2007 EMP_CONT ::: LE LU combination found');
232: hr_utility.trace('2007 EMP_CONT ::: l_le_lu_index = '|| l_le_lu_index );
233: EXIT;
234: END IF;
235: start_index_main := start_index_main + 1;
236: END LOOP; -- end while loop

Line 248: hr_utility.trace('2007 EMP_CONT ::: LU found, since results exist, just returning them');

244: p_run_base := PAY_NO_EMP_CONT_2007.g_tab_main(l_le_lu_index).run_base;
245: p_run_contribution := PAY_NO_EMP_CONT_2007.g_tab_main(l_le_lu_index).run_contribution;
246: p_curr_exemption_limit_used := 0; -- coz this value must have been returned before
247:
248: hr_utility.trace('2007 EMP_CONT ::: LU found, since results exist, just returning them');
249: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_le_lu_index = '|| l_le_lu_index );
250: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );
251: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );
252: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );

Line 249: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_le_lu_index = '|| l_le_lu_index );

245: p_run_contribution := PAY_NO_EMP_CONT_2007.g_tab_main(l_le_lu_index).run_contribution;
246: p_curr_exemption_limit_used := 0; -- coz this value must have been returned before
247:
248: hr_utility.trace('2007 EMP_CONT ::: LU found, since results exist, just returning them');
249: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_le_lu_index = '|| l_le_lu_index );
250: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );
251: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );
252: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
253:

Line 250: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );

246: p_curr_exemption_limit_used := 0; -- coz this value must have been returned before
247:
248: hr_utility.trace('2007 EMP_CONT ::: LU found, since results exist, just returning them');
249: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_le_lu_index = '|| l_le_lu_index );
250: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );
251: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );
252: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
253:
254: hr_utility.trace('2007 EMP_CONT ::: LU ***** Leaving procedure-----------------------------------');

Line 251: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );

247:
248: hr_utility.trace('2007 EMP_CONT ::: LU found, since results exist, just returning them');
249: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_le_lu_index = '|| l_le_lu_index );
250: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );
251: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );
252: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
253:
254: hr_utility.trace('2007 EMP_CONT ::: LU ***** Leaving procedure-----------------------------------');
255:

Line 252: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );

248: hr_utility.trace('2007 EMP_CONT ::: LU found, since results exist, just returning them');
249: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_le_lu_index = '|| l_le_lu_index );
250: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );
251: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );
252: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
253:
254: hr_utility.trace('2007 EMP_CONT ::: LU ***** Leaving procedure-----------------------------------');
255:
256: RETURN 1; -- here return le_run and the other values thru OUT parameters

Line 254: hr_utility.trace('2007 EMP_CONT ::: LU ***** Leaving procedure-----------------------------------');

250: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );
251: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );
252: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
253:
254: hr_utility.trace('2007 EMP_CONT ::: LU ***** Leaving procedure-----------------------------------');
255:
256: RETURN 1; -- here return le_run and the other values thru OUT parameters
257:
258: ELSE --------------------------------------------------------------------------------------------------------------------------

Line 260: hr_utility.trace('2007 EMP_CONT ::: LU does not exist, calculate for this LU');

256: RETURN 1; -- here return le_run and the other values thru OUT parameters
257:
258: ELSE --------------------------------------------------------------------------------------------------------------------------
259: -- combination does not exist, calculation has to be done and values returned
260: hr_utility.trace('2007 EMP_CONT ::: LU does not exist, calculate for this LU');
261:
262: ------------------- initializing the g_tab_calc table for LE LU combination
263: hr_utility.trace('2007 EMP_CONT ::: LU ***** initializing g_tab_calc ');
264: -- loop for each zone

Line 263: hr_utility.trace('2007 EMP_CONT ::: LU ***** initializing g_tab_calc ');

259: -- combination does not exist, calculation has to be done and values returned
260: hr_utility.trace('2007 EMP_CONT ::: LU does not exist, calculate for this LU');
261:
262: ------------------- initializing the g_tab_calc table for LE LU combination
263: hr_utility.trace('2007 EMP_CONT ::: LU ***** initializing g_tab_calc ');
264: -- loop for each zone
265:
266: g_tab_calc(1).zone := '1' ;
267: g_tab_calc(2).zone := '1a' ;

Line 289: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');

285: g_tab_calc(i).run_contribution := 0 ;
286:
287: END LOOP; -- end i loop
288:
289: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
290: l_check := display_table_calc(g_tab_calc);
291: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
292:
293: hr_utility.trace('2007 EMP_CONT ::: LU ***** finished initializing g_tab_calc ');

Line 291: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');

287: END LOOP; -- end i loop
288:
289: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
290: l_check := display_table_calc(g_tab_calc);
291: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
292:
293: hr_utility.trace('2007 EMP_CONT ::: LU ***** finished initializing g_tab_calc ');
294: -------------------- finished initializing the g_tab_lu table
295:

Line 293: hr_utility.trace('2007 EMP_CONT ::: LU ***** finished initializing g_tab_calc ');

289: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
290: l_check := display_table_calc(g_tab_calc);
291: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
292:
293: hr_utility.trace('2007 EMP_CONT ::: LU ***** finished initializing g_tab_calc ');
294: -------------------- finished initializing the g_tab_lu table
295:
296: ------------------ get exemption limit used for LU
297: hr_utility.trace('2007 EMP_CONT ::: LU ***** get exemption limit ');

Line 297: hr_utility.trace('2007 EMP_CONT ::: LU ***** get exemption limit ');

293: hr_utility.trace('2007 EMP_CONT ::: LU ***** finished initializing g_tab_calc ');
294: -------------------- finished initializing the g_tab_lu table
295:
296: ------------------ get exemption limit used for LU
297: hr_utility.trace('2007 EMP_CONT ::: LU ***** get exemption limit ');
298:
299: -- set the context values for balance
300: pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);
301:

Line 306: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_1 = '|| l_def_bal_id_1 );

302: -- get defined balance ids
303: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_YTD') ;
304: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_BIMONTH') ;
305:
306: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_1 = '|| l_def_bal_id_1 );
307: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_2 = '|| l_def_bal_id_2 );
308:
309: -- get the balance value
310: l_bal_val_ytd := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);

Line 307: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_2 = '|| l_def_bal_id_2 );

303: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_YTD') ;
304: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_BIMONTH') ;
305:
306: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_1 = '|| l_def_bal_id_1 );
307: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_2 = '|| l_def_bal_id_2 );
308:
309: -- get the balance value
310: l_bal_val_ytd := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);
311: l_bal_val_bimonth := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);

Line 315: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_bal_val_ytd = '|| l_bal_val_ytd );

311: l_bal_val_bimonth := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);
312:
313: l_exemption_limit_used_yet := l_bal_val_ytd - l_bal_val_bimonth ;
314:
315: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_bal_val_ytd = '|| l_bal_val_ytd );
316: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_bal_val_bimonth = '|| l_bal_val_bimonth );
317: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
318:
319: OPEN PAY_NO_EMP_CONT_2007.csr_get_exemption_limit(p_local_unit_id ,p_date_earned );

Line 316: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_bal_val_bimonth = '|| l_bal_val_bimonth );

312:
313: l_exemption_limit_used_yet := l_bal_val_ytd - l_bal_val_bimonth ;
314:
315: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_bal_val_ytd = '|| l_bal_val_ytd );
316: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_bal_val_bimonth = '|| l_bal_val_bimonth );
317: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
318:
319: OPEN PAY_NO_EMP_CONT_2007.csr_get_exemption_limit(p_local_unit_id ,p_date_earned );
320:

Line 317: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );

313: l_exemption_limit_used_yet := l_bal_val_ytd - l_bal_val_bimonth ;
314:
315: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_bal_val_ytd = '|| l_bal_val_ytd );
316: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_bal_val_bimonth = '|| l_bal_val_bimonth );
317: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
318:
319: OPEN PAY_NO_EMP_CONT_2007.csr_get_exemption_limit(p_local_unit_id ,p_date_earned );
320:
321: -- 2007 Legislative changes for 'Economic Aid' to Employer

Line 327: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit = ' || l_exemption_limit );

323: FETCH PAY_NO_EMP_CONT_2007.csr_get_exemption_limit INTO l_exemption_limit , l_economic_aid ;
324:
325: CLOSE PAY_NO_EMP_CONT_2007.csr_get_exemption_limit;
326:
327: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit = ' || l_exemption_limit );
328: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_economic_aid = ' || l_economic_aid );
329:
330: -- 2007 Legislative changes for 'Economic Aid' to Employer
331: l_exemption_limit := l_exemption_limit - l_economic_aid ;

Line 328: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_economic_aid = ' || l_economic_aid );

324:
325: CLOSE PAY_NO_EMP_CONT_2007.csr_get_exemption_limit;
326:
327: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit = ' || l_exemption_limit );
328: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_economic_aid = ' || l_economic_aid );
329:
330: -- 2007 Legislative changes for 'Economic Aid' to Employer
331: l_exemption_limit := l_exemption_limit - l_economic_aid ;
332:

Line 333: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit after reducing eco aid = ' || l_exemption_limit );

329:
330: -- 2007 Legislative changes for 'Economic Aid' to Employer
331: l_exemption_limit := l_exemption_limit - l_economic_aid ;
332:
333: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit after reducing eco aid = ' || l_exemption_limit );
334:
335:
336: IF l_exemption_limit_used_yet >= l_exemption_limit
337: THEN

Line 343: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit = '||l_exemption_limit );

339: ELSE
340: l_LU_over_limit := 'N';
341: END IF ; -- end if exemption limit check
342:
343: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit = '||l_exemption_limit );
344: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_LU_over_limit = '|| l_LU_over_limit );
345: hr_utility.trace('2007 EMP_CONT ::: LU ***** got exemtion limt , leaving' );
346:
347: ------------------- got exemption limit used for LU

Line 344: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_LU_over_limit = '|| l_LU_over_limit );

340: l_LU_over_limit := 'N';
341: END IF ; -- end if exemption limit check
342:
343: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit = '||l_exemption_limit );
344: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_LU_over_limit = '|| l_LU_over_limit );
345: hr_utility.trace('2007 EMP_CONT ::: LU ***** got exemtion limt , leaving' );
346:
347: ------------------- got exemption limit used for LU
348:

Line 345: hr_utility.trace('2007 EMP_CONT ::: LU ***** got exemtion limt , leaving' );

341: END IF ; -- end if exemption limit check
342:
343: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit = '||l_exemption_limit );
344: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_LU_over_limit = '|| l_LU_over_limit );
345: hr_utility.trace('2007 EMP_CONT ::: LU ***** got exemtion limt , leaving' );
346:
347: ------------------- got exemption limit used for LU
348:
349: ----------------- populating the tables g_lu_tab (LU) and g_mu_tab (MU)

Line 353: hr_utility.trace('2007 EMP_CONT ::: LU ***** populating g_lu_tab and g_mu_tab , entering ' );

349: ----------------- populating the tables g_lu_tab (LU) and g_mu_tab (MU)
350:
351: -- from 2007 , the tax municipality will be picked from the local unit
352:
353: hr_utility.trace('2007 EMP_CONT ::: LU ***** populating g_lu_tab and g_mu_tab , entering ' );
354:
355: l_temp := populate_tables
356: (p_tax_unit_id
357: ,p_payroll_id

Line 363: hr_utility.trace('2007 EMP_CONT ::: LU ***** populated g_lu_tab and g_mu_tab , leaving ' );

359: ,g_lu_tab
360: ,g_mu_tab );
361:
362:
363: hr_utility.trace('2007 EMP_CONT ::: LU ***** populated g_lu_tab and g_mu_tab , leaving ' );
364: ----------------- Fetch the run base using assignment level balances (at LU level)
365: hr_utility.trace('2007 EMP_CONT ::: LU ***** Fetch the run base using assignment level balances , enetring ' );
366:
367: -- get defined balance ids

Line 365: hr_utility.trace('2007 EMP_CONT ::: LU ***** Fetch the run base using assignment level balances , enetring ' );

361:
362:
363: hr_utility.trace('2007 EMP_CONT ::: LU ***** populated g_lu_tab and g_mu_tab , leaving ' );
364: ----------------- Fetch the run base using assignment level balances (at LU level)
365: hr_utility.trace('2007 EMP_CONT ::: LU ***** Fetch the run base using assignment level balances , enetring ' );
366:
367: -- get defined balance ids
368: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Base','_ASG_TU_MU_LU_BIMONTH') ;
369: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution Base 2','_ASG_TU_MU_LU_BIMONTH') ;

Line 371: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_1 = '|| l_def_bal_id_1 );

367: -- get defined balance ids
368: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Base','_ASG_TU_MU_LU_BIMONTH') ;
369: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution Base 2','_ASG_TU_MU_LU_BIMONTH') ;
370:
371: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_1 = '|| l_def_bal_id_1 );
372: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_2 = '|| l_def_bal_id_2 );
373:
374: ----- test only , Remove it
375: OPEN csr_test_aag_act_id (p_tax_unit_id , p_payroll_action_id, p_date_earned);

Line 372: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_2 = '|| l_def_bal_id_2 );

368: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Base','_ASG_TU_MU_LU_BIMONTH') ;
369: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution Base 2','_ASG_TU_MU_LU_BIMONTH') ;
370:
371: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_1 = '|| l_def_bal_id_1 );
372: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_2 = '|| l_def_bal_id_2 );
373:
374: ----- test only , Remove it
375: OPEN csr_test_aag_act_id (p_tax_unit_id , p_payroll_action_id, p_date_earned);
376: FETCH csr_test_aag_act_id INTO l_check2;

Line 378: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_check2 , no of rows returned by asg act id cursor = '||l_check2 );

374: ----- test only , Remove it
375: OPEN csr_test_aag_act_id (p_tax_unit_id , p_payroll_action_id, p_date_earned);
376: FETCH csr_test_aag_act_id INTO l_check2;
377: CLOSE csr_test_aag_act_id;
378: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_check2 , no of rows returned by asg act id cursor = '||l_check2 );
379: -- remove till here
380:
381: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 0 leave' );
382:

Line 381: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 0 leave' );

377: CLOSE csr_test_aag_act_id;
378: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_check2 , no of rows returned by asg act id cursor = '||l_check2 );
379: -- remove till here
380:
381: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 0 leave' );
382:
383: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
384: pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);
385:

Line 391: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 1 , loop csr_curr_le_asg_act_id ' );

387:
388: -- loop to get all assignment_action_id in the current payroll_action_id
389: FOR csr1_rec IN csr_curr_le_asg_act_id (p_tax_unit_id , p_payroll_action_id, p_date_earned) LOOP
390:
391: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 1 , loop csr_curr_le_asg_act_id ' );
392:
393: start_index_mu := NVL (g_mu_tab.FIRST, 0) ;
394: end_index_mu := NVL (g_mu_tab.LAST, 0) ;
395:

Line 398: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 2, g_mu_tab ' );

394: end_index_mu := NVL (g_mu_tab.LAST, 0) ;
395:
396: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
397:
398: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 2, g_mu_tab ' );
399: hr_utility.trace('2007 EMP_CONT ::: LU ***** ASS_ACT_ID = '|| csr1_rec.ASSIGNMENT_ACTION_ID || ' MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| p_local_unit_id );
400:
401: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
402:

Line 399: hr_utility.trace('2007 EMP_CONT ::: LU ***** ASS_ACT_ID = '|| csr1_rec.ASSIGNMENT_ACTION_ID || ' MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| p_local_unit_id );

395:
396: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
397:
398: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 2, g_mu_tab ' );
399: hr_utility.trace('2007 EMP_CONT ::: LU ***** ASS_ACT_ID = '|| csr1_rec.ASSIGNMENT_ACTION_ID || ' MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| p_local_unit_id );
400:
401: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
402:
403: -- get the balance value

Line 409: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_asg_ers_base = '|| l_asg_ers_base );

405: l_asg_ers_base2 := pay_balance_pkg.get_value(l_def_bal_id_2,csr1_rec.ASSIGNMENT_ACTION_ID);
406: l_asg_ers_base_diff := l_asg_ers_base - l_asg_ers_base2;
407:
408:
409: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_asg_ers_base = '|| l_asg_ers_base );
410: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_asg_ers_base2 = '|| l_asg_ers_base2 );
411: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_asg_ers_base_diff = '|| l_asg_ers_base_diff );
412:
413: hr_utility.trace('2007 EMP_CONT ::: LU ***** ============== just checking================= ');

Line 410: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_asg_ers_base2 = '|| l_asg_ers_base2 );

406: l_asg_ers_base_diff := l_asg_ers_base - l_asg_ers_base2;
407:
408:
409: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_asg_ers_base = '|| l_asg_ers_base );
410: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_asg_ers_base2 = '|| l_asg_ers_base2 );
411: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_asg_ers_base_diff = '|| l_asg_ers_base_diff );
412:
413: hr_utility.trace('2007 EMP_CONT ::: LU ***** ============== just checking================= ');
414: hr_utility.trace('2007 EMP_CONT ::: LU ***** g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );

Line 411: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_asg_ers_base_diff = '|| l_asg_ers_base_diff );

407:
408:
409: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_asg_ers_base = '|| l_asg_ers_base );
410: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_asg_ers_base2 = '|| l_asg_ers_base2 );
411: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_asg_ers_base_diff = '|| l_asg_ers_base_diff );
412:
413: hr_utility.trace('2007 EMP_CONT ::: LU ***** ============== just checking================= ');
414: hr_utility.trace('2007 EMP_CONT ::: LU ***** g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
415:

Line 413: hr_utility.trace('2007 EMP_CONT ::: LU ***** ============== just checking================= ');

409: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_asg_ers_base = '|| l_asg_ers_base );
410: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_asg_ers_base2 = '|| l_asg_ers_base2 );
411: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_asg_ers_base_diff = '|| l_asg_ers_base_diff );
412:
413: hr_utility.trace('2007 EMP_CONT ::: LU ***** ============== just checking================= ');
414: hr_utility.trace('2007 EMP_CONT ::: LU ***** g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
415:
416: l_zone_temp := to_char(g_mu_tab(start_index_mu));
417:

Line 414: hr_utility.trace('2007 EMP_CONT ::: LU ***** g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );

410: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_asg_ers_base2 = '|| l_asg_ers_base2 );
411: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_asg_ers_base_diff = '|| l_asg_ers_base_diff );
412:
413: hr_utility.trace('2007 EMP_CONT ::: LU ***** ============== just checking================= ');
414: hr_utility.trace('2007 EMP_CONT ::: LU ***** g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
415:
416: l_zone_temp := to_char(g_mu_tab(start_index_mu));
417:
418: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone_temp = '|| l_zone_temp );

Line 418: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone_temp = '|| l_zone_temp );

414: hr_utility.trace('2007 EMP_CONT ::: LU ***** g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
415:
416: l_zone_temp := to_char(g_mu_tab(start_index_mu));
417:
418: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone_temp = '|| l_zone_temp );
419:
420: -- l_zone := to_number(substr(get_lookup_meaning('NO_TAX_MUNICIPALITY',l_zone_temp),1,1));
421: l_zone := hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', l_zone_temp, p_date_earned ) ;
422:

Line 424: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone = '|| l_zone );

420: -- l_zone := to_number(substr(get_lookup_meaning('NO_TAX_MUNICIPALITY',l_zone_temp),1,1));
421: l_zone := hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', l_zone_temp, p_date_earned ) ;
422:
423:
424: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone = '|| l_zone );
425:
426: l_cell := lookup_cell(g_tab_calc, l_zone);
427: g_tab_calc(l_cell).run_base := g_tab_calc(l_cell).run_base + l_asg_ers_base_diff ;
428:

Line 429: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_cell = '|| l_cell );

425:
426: l_cell := lookup_cell(g_tab_calc, l_zone);
427: g_tab_calc(l_cell).run_base := g_tab_calc(l_cell).run_base + l_asg_ers_base_diff ;
428:
429: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_cell = '|| l_cell );
430:
431: start_index_mu := start_index_mu + 1;
432:
433: END LOOP; -- end while loop

Line 438: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 0 back' );

434:
435: END LOOP; -- end loop csr1_rec
436:
437:
438: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 0 back' );
439:
440: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
441: l_check := display_table_calc(g_tab_calc);
442: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');

Line 440: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');

436:
437:
438: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 0 back' );
439:
440: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
441: l_check := display_table_calc(g_tab_calc);
442: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
443:
444: hr_utility.trace('2007 EMP_CONT ::: LU ***** Fetched the run base using assignment level balances , leaving ' );

Line 442: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');

438: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 0 back' );
439:
440: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
441: l_check := display_table_calc(g_tab_calc);
442: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
443:
444: hr_utility.trace('2007 EMP_CONT ::: LU ***** Fetched the run base using assignment level balances , leaving ' );
445: ---------------------- Fetched the run base using assignment level balances (at LU level)
446:

Line 444: hr_utility.trace('2007 EMP_CONT ::: LU ***** Fetched the run base using assignment level balances , leaving ' );

440: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
441: l_check := display_table_calc(g_tab_calc);
442: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
443:
444: hr_utility.trace('2007 EMP_CONT ::: LU ***** Fetched the run base using assignment level balances , leaving ' );
445: ---------------------- Fetched the run base using assignment level balances (at LU level)
446:
447: ----------------- Fetch the bimonth base using group level balances (at LU level)
448: hr_utility.trace('2007 EMP_CONT ::: LU ***** Fetch the bimonth base using group level balances , entering ' );

Line 448: hr_utility.trace('2007 EMP_CONT ::: LU ***** Fetch the bimonth base using group level balances , entering ' );

444: hr_utility.trace('2007 EMP_CONT ::: LU ***** Fetched the run base using assignment level balances , leaving ' );
445: ---------------------- Fetched the run base using assignment level balances (at LU level)
446:
447: ----------------- Fetch the bimonth base using group level balances (at LU level)
448: hr_utility.trace('2007 EMP_CONT ::: LU ***** Fetch the bimonth base using group level balances , entering ' );
449:
450: -- get defined balance ids
451: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Base','_TU_MU_LU_BIMONTH') ;
452: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution','_TU_MU_LU_BIMONTH') ;

Line 454: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_1 = '|| l_def_bal_id_1 );

450: -- get defined balance ids
451: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Base','_TU_MU_LU_BIMONTH') ;
452: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution','_TU_MU_LU_BIMONTH') ;
453:
454: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_1 = '|| l_def_bal_id_1 );
455: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_2 = '|| l_def_bal_id_2 );
456:
457: -- loop to get all MU in g_mu_tab
458:

Line 455: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_2 = '|| l_def_bal_id_2 );

451: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Base','_TU_MU_LU_BIMONTH') ;
452: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution','_TU_MU_LU_BIMONTH') ;
453:
454: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_1 = '|| l_def_bal_id_1 );
455: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_2 = '|| l_def_bal_id_2 );
456:
457: -- loop to get all MU in g_mu_tab
458:
459: start_index_mu := NVL (g_mu_tab.FIRST, 0) ;

Line 462: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 0 leave ' );

458:
459: start_index_mu := NVL (g_mu_tab.FIRST, 0) ;
460: end_index_mu := NVL (g_mu_tab.LAST, 0) ;
461:
462: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 0 leave ' );
463:
464: pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);
465:
466:

Line 469: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 1 ,g_mu_tab ' );

465:
466:
467: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
468:
469: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 1 ,g_mu_tab ' );
470:
471: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
472:
473: hr_utility.trace('2007 EMP_CONT ::: LU ***** MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| p_local_unit_id );

Line 473: hr_utility.trace('2007 EMP_CONT ::: LU ***** MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| p_local_unit_id );

469: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 1 ,g_mu_tab ' );
470:
471: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
472:
473: hr_utility.trace('2007 EMP_CONT ::: LU ***** MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| p_local_unit_id );
474:
475: -- get the balance value
476: l_lu_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
477: l_lu_ers := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);

Line 479: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_lu_ers_base = '|| l_lu_ers_base);

475: -- get the balance value
476: l_lu_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
477: l_lu_ers := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
478:
479: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_lu_ers_base = '|| l_lu_ers_base);
480: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_lu_ers = '||l_lu_ers );
481:
482: hr_utility.trace('2007 EMP_CONT ::: LU ***** ============== just checking again ================= ');
483:

Line 480: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_lu_ers = '||l_lu_ers );

476: l_lu_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
477: l_lu_ers := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
478:
479: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_lu_ers_base = '|| l_lu_ers_base);
480: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_lu_ers = '||l_lu_ers );
481:
482: hr_utility.trace('2007 EMP_CONT ::: LU ***** ============== just checking again ================= ');
483:
484: hr_utility.trace('2007 EMP_CONT ::: LU ***** g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );

Line 482: hr_utility.trace('2007 EMP_CONT ::: LU ***** ============== just checking again ================= ');

478:
479: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_lu_ers_base = '|| l_lu_ers_base);
480: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_lu_ers = '||l_lu_ers );
481:
482: hr_utility.trace('2007 EMP_CONT ::: LU ***** ============== just checking again ================= ');
483:
484: hr_utility.trace('2007 EMP_CONT ::: LU ***** g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
485:
486: l_zone_temp := to_char(g_mu_tab(start_index_mu));

Line 484: hr_utility.trace('2007 EMP_CONT ::: LU ***** g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );

480: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_lu_ers = '||l_lu_ers );
481:
482: hr_utility.trace('2007 EMP_CONT ::: LU ***** ============== just checking again ================= ');
483:
484: hr_utility.trace('2007 EMP_CONT ::: LU ***** g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
485:
486: l_zone_temp := to_char(g_mu_tab(start_index_mu));
487:
488: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone_temp = '|| l_zone_temp );

Line 488: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone_temp = '|| l_zone_temp );

484: hr_utility.trace('2007 EMP_CONT ::: LU ***** g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
485:
486: l_zone_temp := to_char(g_mu_tab(start_index_mu));
487:
488: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone_temp = '|| l_zone_temp );
489:
490: -- l_zone := to_number(substr(get_lookup_meaning('NO_TAX_MUNICIPALITY',l_zone_temp),1,1));
491: l_zone := hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', l_zone_temp, p_date_earned ) ;
492:

Line 493: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone = '|| l_zone );

489:
490: -- l_zone := to_number(substr(get_lookup_meaning('NO_TAX_MUNICIPALITY',l_zone_temp),1,1));
491: l_zone := hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', l_zone_temp, p_date_earned ) ;
492:
493: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone = '|| l_zone );
494:
495: l_cell := lookup_cell(g_tab_calc, l_zone);
496: g_tab_calc(l_cell).bimonth_base := g_tab_calc(l_cell).bimonth_base + l_lu_ers_base ;
497: g_tab_calc(l_cell).bimonth_contribution_todate := g_tab_calc(l_cell).bimonth_contribution_todate + l_lu_ers ;

Line 499: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_cell = '|| l_cell );

495: l_cell := lookup_cell(g_tab_calc, l_zone);
496: g_tab_calc(l_cell).bimonth_base := g_tab_calc(l_cell).bimonth_base + l_lu_ers_base ;
497: g_tab_calc(l_cell).bimonth_contribution_todate := g_tab_calc(l_cell).bimonth_contribution_todate + l_lu_ers ;
498:
499: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_cell = '|| l_cell );
500:
501: start_index_mu := start_index_mu + 1;
502: END LOOP; -- end while loop
503:

Line 504: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 0 back' );

500:
501: start_index_mu := start_index_mu + 1;
502: END LOOP; -- end while loop
503:
504: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 0 back' );
505:
506: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
507: l_check := display_table_calc(g_tab_calc);
508: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');

Line 506: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');

502: END LOOP; -- end while loop
503:
504: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 0 back' );
505:
506: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
507: l_check := display_table_calc(g_tab_calc);
508: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
509:
510: hr_utility.trace('2007 EMP_CONT ::: LU ***** Fetched the bimonth base using group level balances , leaving ' );

Line 508: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');

504: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 0 back' );
505:
506: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
507: l_check := display_table_calc(g_tab_calc);
508: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
509:
510: hr_utility.trace('2007 EMP_CONT ::: LU ***** Fetched the bimonth base using group level balances , leaving ' );
511: ---------------------- Fetched the bimonth base using group level balances (at LU level)
512:

Line 510: hr_utility.trace('2007 EMP_CONT ::: LU ***** Fetched the bimonth base using group level balances , leaving ' );

506: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
507: l_check := display_table_calc(g_tab_calc);
508: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
509:
510: hr_utility.trace('2007 EMP_CONT ::: LU ***** Fetched the bimonth base using group level balances , leaving ' );
511: ---------------------- Fetched the bimonth base using group level balances (at LU level)
512:
513:
514: ------------------------------ apply differential rate and check exemption limit at LU Level

Line 516: hr_utility.trace('2007 EMP_CONT ::: LU ***** apply differential rate and check exemption limit , entering ' );

512:
513:
514: ------------------------------ apply differential rate and check exemption limit at LU Level
515:
516: hr_utility.trace('2007 EMP_CONT ::: LU ***** apply differential rate and check exemption limit , entering ' );
517: --l_lu_status status for LU
518: --l_le_status status for LE
519: l_total_saving := 0;
520:

Line 527: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_LU_over_limit = Y ' );

523: -- check if exemption limit already used up
524: IF l_LU_over_limit = 'Y'
525:
526: THEN
527: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_LU_over_limit = Y ' );
528:
529: -- as limit is over, put under_limit as N for all rows
530: FOR i IN 1..7 LOOP
531: g_tab_calc(i).under_limit := 'N';

Line 534: hr_utility.trace('2007 EMP_CONT ::: LU ***** as limit is over, put under_limit as N for all rows ' );

530: FOR i IN 1..7 LOOP
531: g_tab_calc(i).under_limit := 'N';
532: END LOOP; -- end i loop
533:
534: hr_utility.trace('2007 EMP_CONT ::: LU ***** as limit is over, put under_limit as N for all rows ' );
535:
536: ELSE
537: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_LU_over_limit = N ' );
538:

Line 537: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_LU_over_limit = N ' );

533:
534: hr_utility.trace('2007 EMP_CONT ::: LU ***** as limit is over, put under_limit as N for all rows ' );
535:
536: ELSE
537: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_LU_over_limit = N ' );
538:
539: -- limit is not over
540: -- perform exemption limit check only if status = AA,CC,GG
541: IF ( l_lu_status = 'AA' OR l_lu_status = 'GG' OR l_lu_status = 'CC' )

Line 544: hr_utility.trace('2007 EMP_CONT ::: LU ***** status is = '|| l_lu_status );

540: -- perform exemption limit check only if status = AA,CC,GG
541: IF ( l_lu_status = 'AA' OR l_lu_status = 'GG' OR l_lu_status = 'CC' )
542:
543: THEN
544: hr_utility.trace('2007 EMP_CONT ::: LU ***** status is = '|| l_lu_status );
545:
546: -------- performing exemption limit check
547: l_table_name := 'NO_NIS_ZONE_RATES';
548:

Line 559: hr_utility.trace('2007 EMP_CONT ::: LU ***** exemption limit check ----------------------------' );

555:
556: l_col_name := 'NIS Rates';
557: l_high_rate := p_under_age_high_rate;
558:
559: hr_utility.trace('2007 EMP_CONT ::: LU ***** exemption limit check ----------------------------' );
560:
561: l_zone_value := g_tab_calc(i).zone;
562: -- l_normal_rate := TO_NUMBER(hruserdt.get_table_value (p_bus_group_id, l_table_name, l_col_name, l_zone_value, p_date_earned ));
563: l_normal_rate := fnd_number.canonical_to_number(hruserdt.get_table_value (p_bus_group_id, l_table_name, l_col_name, l_zone_value, p_date_earned ));

Line 570: hr_utility.trace('2007 EMP_CONT ::: LU ***** i = '||i||' l_zone_value = '||l_zone_value

566:
567: l_saving := ( g_tab_calc(i).bimonth_base * l_diff_rate ) / 100 ;
568: l_total_saving := l_total_saving + l_saving ;
569:
570: hr_utility.trace('2007 EMP_CONT ::: LU ***** i = '||i||' l_zone_value = '||l_zone_value
571: ||' l_normal_rate = '||l_normal_rate||' l_high_rate = '||l_high_rate
572: ||' l_diff_rate = '||l_diff_rate||' l_saving = '||l_saving||' l_total_saving = '||l_total_saving );
573:
574: -- check if exemption limit exceeded

Line 577: hr_utility.trace('2007 EMP_CONT ::: LU******** exemption limit exceeded in table');

573:
574: -- check if exemption limit exceeded
575: IF ((l_exemption_limit_used_yet + l_total_saving) >= l_exemption_limit)
576: THEN
577: hr_utility.trace('2007 EMP_CONT ::: LU******** exemption limit exceeded in table');
578: hr_utility.trace('2007 EMP_CONT ::: LU ***** bimonth_base = '|| g_tab_calc(i).bimonth_base );
579: hr_utility.trace('2007 EMP_CONT ::: LU ***** run_base = '||g_tab_calc(i).run_base );
580: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone_value = '|| l_zone_value );
581: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_normal_rate = '|| l_normal_rate );

Line 578: hr_utility.trace('2007 EMP_CONT ::: LU ***** bimonth_base = '|| g_tab_calc(i).bimonth_base );

574: -- check if exemption limit exceeded
575: IF ((l_exemption_limit_used_yet + l_total_saving) >= l_exemption_limit)
576: THEN
577: hr_utility.trace('2007 EMP_CONT ::: LU******** exemption limit exceeded in table');
578: hr_utility.trace('2007 EMP_CONT ::: LU ***** bimonth_base = '|| g_tab_calc(i).bimonth_base );
579: hr_utility.trace('2007 EMP_CONT ::: LU ***** run_base = '||g_tab_calc(i).run_base );
580: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone_value = '|| l_zone_value );
581: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_normal_rate = '|| l_normal_rate );
582: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_high_rate = '|| l_high_rate );

Line 579: hr_utility.trace('2007 EMP_CONT ::: LU ***** run_base = '||g_tab_calc(i).run_base );

575: IF ((l_exemption_limit_used_yet + l_total_saving) >= l_exemption_limit)
576: THEN
577: hr_utility.trace('2007 EMP_CONT ::: LU******** exemption limit exceeded in table');
578: hr_utility.trace('2007 EMP_CONT ::: LU ***** bimonth_base = '|| g_tab_calc(i).bimonth_base );
579: hr_utility.trace('2007 EMP_CONT ::: LU ***** run_base = '||g_tab_calc(i).run_base );
580: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone_value = '|| l_zone_value );
581: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_normal_rate = '|| l_normal_rate );
582: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_high_rate = '|| l_high_rate );
583: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_diff_rate = '|| l_diff_rate );

Line 580: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone_value = '|| l_zone_value );

576: THEN
577: hr_utility.trace('2007 EMP_CONT ::: LU******** exemption limit exceeded in table');
578: hr_utility.trace('2007 EMP_CONT ::: LU ***** bimonth_base = '|| g_tab_calc(i).bimonth_base );
579: hr_utility.trace('2007 EMP_CONT ::: LU ***** run_base = '||g_tab_calc(i).run_base );
580: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone_value = '|| l_zone_value );
581: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_normal_rate = '|| l_normal_rate );
582: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_high_rate = '|| l_high_rate );
583: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_diff_rate = '|| l_diff_rate );
584: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_saving = '|| l_saving );

Line 581: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_normal_rate = '|| l_normal_rate );

577: hr_utility.trace('2007 EMP_CONT ::: LU******** exemption limit exceeded in table');
578: hr_utility.trace('2007 EMP_CONT ::: LU ***** bimonth_base = '|| g_tab_calc(i).bimonth_base );
579: hr_utility.trace('2007 EMP_CONT ::: LU ***** run_base = '||g_tab_calc(i).run_base );
580: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone_value = '|| l_zone_value );
581: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_normal_rate = '|| l_normal_rate );
582: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_high_rate = '|| l_high_rate );
583: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_diff_rate = '|| l_diff_rate );
584: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_saving = '|| l_saving );
585: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_total_saving= '|| l_total_saving );

Line 582: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_high_rate = '|| l_high_rate );

578: hr_utility.trace('2007 EMP_CONT ::: LU ***** bimonth_base = '|| g_tab_calc(i).bimonth_base );
579: hr_utility.trace('2007 EMP_CONT ::: LU ***** run_base = '||g_tab_calc(i).run_base );
580: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone_value = '|| l_zone_value );
581: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_normal_rate = '|| l_normal_rate );
582: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_high_rate = '|| l_high_rate );
583: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_diff_rate = '|| l_diff_rate );
584: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_saving = '|| l_saving );
585: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_total_saving= '|| l_total_saving );
586: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );

Line 583: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_diff_rate = '|| l_diff_rate );

579: hr_utility.trace('2007 EMP_CONT ::: LU ***** run_base = '||g_tab_calc(i).run_base );
580: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone_value = '|| l_zone_value );
581: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_normal_rate = '|| l_normal_rate );
582: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_high_rate = '|| l_high_rate );
583: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_diff_rate = '|| l_diff_rate );
584: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_saving = '|| l_saving );
585: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_total_saving= '|| l_total_saving );
586: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
587:

Line 584: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_saving = '|| l_saving );

580: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone_value = '|| l_zone_value );
581: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_normal_rate = '|| l_normal_rate );
582: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_high_rate = '|| l_high_rate );
583: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_diff_rate = '|| l_diff_rate );
584: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_saving = '|| l_saving );
585: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_total_saving= '|| l_total_saving );
586: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
587:
588: -- get the exceeding amount

Line 585: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_total_saving= '|| l_total_saving );

581: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_normal_rate = '|| l_normal_rate );
582: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_high_rate = '|| l_high_rate );
583: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_diff_rate = '|| l_diff_rate );
584: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_saving = '|| l_saving );
585: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_total_saving= '|| l_total_saving );
586: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
587:
588: -- get the exceeding amount
589: l_amount_over_limit := ((l_exemption_limit_used_yet + l_total_saving) - l_exemption_limit);

Line 586: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );

582: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_high_rate = '|| l_high_rate );
583: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_diff_rate = '|| l_diff_rate );
584: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_saving = '|| l_saving );
585: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_total_saving= '|| l_total_saving );
586: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
587:
588: -- get the exceeding amount
589: l_amount_over_limit := ((l_exemption_limit_used_yet + l_total_saving) - l_exemption_limit);
590: l_base_over_limit := (l_amount_over_limit / l_diff_rate) * 100 ;

Line 614: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_amount_over_limit = '|| l_amount_over_limit );

610: -- set the new l_total_saving
611:
612: l_total_saving := l_exemption_limit - l_exemption_limit_used_yet ;
613:
614: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_amount_over_limit = '|| l_amount_over_limit );
615: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_base_over_limit = '|| l_base_over_limit );
616: hr_utility.trace('2007 EMP_CONT ::: LU ***** NEW bimonth base for current row = '|| g_tab_calc(i).bimonth_base );
617: hr_utility.trace('2007 EMP_CONT ::: LU ***** NEW l_total_saving = '|| l_total_saving );
618:

Line 615: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_base_over_limit = '|| l_base_over_limit );

611:
612: l_total_saving := l_exemption_limit - l_exemption_limit_used_yet ;
613:
614: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_amount_over_limit = '|| l_amount_over_limit );
615: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_base_over_limit = '|| l_base_over_limit );
616: hr_utility.trace('2007 EMP_CONT ::: LU ***** NEW bimonth base for current row = '|| g_tab_calc(i).bimonth_base );
617: hr_utility.trace('2007 EMP_CONT ::: LU ***** NEW l_total_saving = '|| l_total_saving );
618:
619: -- insert a new row for exceeded limit

Line 616: hr_utility.trace('2007 EMP_CONT ::: LU ***** NEW bimonth base for current row = '|| g_tab_calc(i).bimonth_base );

612: l_total_saving := l_exemption_limit - l_exemption_limit_used_yet ;
613:
614: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_amount_over_limit = '|| l_amount_over_limit );
615: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_base_over_limit = '|| l_base_over_limit );
616: hr_utility.trace('2007 EMP_CONT ::: LU ***** NEW bimonth base for current row = '|| g_tab_calc(i).bimonth_base );
617: hr_utility.trace('2007 EMP_CONT ::: LU ***** NEW l_total_saving = '|| l_total_saving );
618:
619: -- insert a new row for exceeded limit
620:

Line 617: hr_utility.trace('2007 EMP_CONT ::: LU ***** NEW l_total_saving = '|| l_total_saving );

613:
614: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_amount_over_limit = '|| l_amount_over_limit );
615: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_base_over_limit = '|| l_base_over_limit );
616: hr_utility.trace('2007 EMP_CONT ::: LU ***** NEW bimonth base for current row = '|| g_tab_calc(i).bimonth_base );
617: hr_utility.trace('2007 EMP_CONT ::: LU ***** NEW l_total_saving = '|| l_total_saving );
618:
619: -- insert a new row for exceeded limit
620:
621: g_tab_calc(8).zone := g_tab_calc(i).zone;

Line 639: --hr_utility.trace('2007 EMP_CONT ::: LU ***** l_LU_over_limit Y' );

635: END LOOP; --end j loop
636:
637: l_LU_over_limit := 'Y'; -- indicating exemption limit on LU level is over
638:
639: --hr_utility.trace('2007 EMP_CONT ::: LU ***** l_LU_over_limit Y' );
640: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_LU_over_limit = '||l_LU_over_limit );
641:
642: EXIT; -- exit loop i since no more check is required
643: END IF; -- end check if exemption limit exceeded

Line 640: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_LU_over_limit = '||l_LU_over_limit );

636:
637: l_LU_over_limit := 'Y'; -- indicating exemption limit on LU level is over
638:
639: --hr_utility.trace('2007 EMP_CONT ::: LU ***** l_LU_over_limit Y' );
640: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_LU_over_limit = '||l_LU_over_limit );
641:
642: EXIT; -- exit loop i since no more check is required
643: END IF; -- end check if exemption limit exceeded
644:

Line 662: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_total_saving = '||l_total_saving );

658: -- from the total saving, removing exemption limit reported in the bimonth period
659: -- exemption limit used currently at LU level
660: l_exemption_limit_used := l_total_saving - l_bal_val_bimonth ;
661:
662: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_total_saving = '||l_total_saving );
663: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_bal_val_bimonth = '||l_bal_val_bimonth );
664: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit_used = '||l_exemption_limit_used );
665:
666: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');

Line 663: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_bal_val_bimonth = '||l_bal_val_bimonth );

659: -- exemption limit used currently at LU level
660: l_exemption_limit_used := l_total_saving - l_bal_val_bimonth ;
661:
662: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_total_saving = '||l_total_saving );
663: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_bal_val_bimonth = '||l_bal_val_bimonth );
664: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit_used = '||l_exemption_limit_used );
665:
666: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
667: l_check := display_table_calc(g_tab_calc);

Line 664: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit_used = '||l_exemption_limit_used );

660: l_exemption_limit_used := l_total_saving - l_bal_val_bimonth ;
661:
662: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_total_saving = '||l_total_saving );
663: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_bal_val_bimonth = '||l_bal_val_bimonth );
664: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit_used = '||l_exemption_limit_used );
665:
666: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
667: l_check := display_table_calc(g_tab_calc);
668: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');

Line 666: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');

662: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_total_saving = '||l_total_saving );
663: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_bal_val_bimonth = '||l_bal_val_bimonth );
664: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit_used = '||l_exemption_limit_used );
665:
666: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
667: l_check := display_table_calc(g_tab_calc);
668: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
669:
670: hr_utility.trace('2007 EMP_CONT ::: LU ***** applied differential rate and check exemption limit , leaving ' );

Line 668: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');

664: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit_used = '||l_exemption_limit_used );
665:
666: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
667: l_check := display_table_calc(g_tab_calc);
668: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
669:
670: hr_utility.trace('2007 EMP_CONT ::: LU ***** applied differential rate and check exemption limit , leaving ' );
671: ------------------------------ applied differential rate and check exemption limit at LU Level
672:

Line 670: hr_utility.trace('2007 EMP_CONT ::: LU ***** applied differential rate and check exemption limit , leaving ' );

666: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
667: l_check := display_table_calc(g_tab_calc);
668: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
669:
670: hr_utility.trace('2007 EMP_CONT ::: LU ***** applied differential rate and check exemption limit , leaving ' );
671: ------------------------------ applied differential rate and check exemption limit at LU Level
672:
673: -- ec_main_calculation function call for LU
674: hr_utility.trace('2007 EMP_CONT ::: LU ***** ec_main_calculation function call for LU , entering ' );

Line 674: hr_utility.trace('2007 EMP_CONT ::: LU ***** ec_main_calculation function call for LU , entering ' );

670: hr_utility.trace('2007 EMP_CONT ::: LU ***** applied differential rate and check exemption limit , leaving ' );
671: ------------------------------ applied differential rate and check exemption limit at LU Level
672:
673: -- ec_main_calculation function call for LU
674: hr_utility.trace('2007 EMP_CONT ::: LU ***** ec_main_calculation function call for LU , entering ' );
675:
676: l_main_index := ec_main_calculation ( g_tab_calc
677: ,PAY_NO_EMP_CONT_2007.g_tab_main
678: ,p_tax_unit_id

Line 688: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');

684: ,p_under_age_high_rate
685: ,p_over_age_high_rate
686: ,l_curr_zone ) ;
687:
688: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
689: l_check := display_table_calc(g_tab_calc);
690: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
691:
692: hr_utility.trace('2007 EMP_CONT ::: LU ***** ec_main_calculation function call for LU , leaving ' );

Line 690: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');

686: ,l_curr_zone ) ;
687:
688: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
689: l_check := display_table_calc(g_tab_calc);
690: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
691:
692: hr_utility.trace('2007 EMP_CONT ::: LU ***** ec_main_calculation function call for LU , leaving ' );
693:
694: -- done all caclculation and entered values in the main table for next time usage

Line 692: hr_utility.trace('2007 EMP_CONT ::: LU ***** ec_main_calculation function call for LU , leaving ' );

688: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
689: l_check := display_table_calc(g_tab_calc);
690: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
691:
692: hr_utility.trace('2007 EMP_CONT ::: LU ***** ec_main_calculation function call for LU , leaving ' );
693:
694: -- done all caclculation and entered values in the main table for next time usage
695:
696: -- returning values at LU level

Line 701: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_main_index = '|| l_main_index );

697: p_run_base := PAY_NO_EMP_CONT_2007.g_tab_main(l_main_index).run_base;
698: p_run_contribution := PAY_NO_EMP_CONT_2007.g_tab_main(l_main_index).run_contribution;
699: p_curr_exemption_limit_used := PAY_NO_EMP_CONT_2007.g_tab_main(l_main_index).exemption_limit_used;
700:
701: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_main_index = '|| l_main_index );
702: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );
703: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );
704: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
705:

Line 702: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );

698: p_run_contribution := PAY_NO_EMP_CONT_2007.g_tab_main(l_main_index).run_contribution;
699: p_curr_exemption_limit_used := PAY_NO_EMP_CONT_2007.g_tab_main(l_main_index).exemption_limit_used;
700:
701: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_main_index = '|| l_main_index );
702: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );
703: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );
704: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
705:
706: hr_utility.trace('2007 EMP_CONT ::: LU ***** Leaving procedure-----------------------------------');

Line 703: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );

699: p_curr_exemption_limit_used := PAY_NO_EMP_CONT_2007.g_tab_main(l_main_index).exemption_limit_used;
700:
701: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_main_index = '|| l_main_index );
702: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );
703: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );
704: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
705:
706: hr_utility.trace('2007 EMP_CONT ::: LU ***** Leaving procedure-----------------------------------');
707:

Line 704: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );

700:
701: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_main_index = '|| l_main_index );
702: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );
703: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );
704: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
705:
706: hr_utility.trace('2007 EMP_CONT ::: LU ***** Leaving procedure-----------------------------------');
707:
708: RETURN 1; -- here return 1 , other values thru OUT parameters

Line 706: hr_utility.trace('2007 EMP_CONT ::: LU ***** Leaving procedure-----------------------------------');

702: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );
703: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );
704: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
705:
706: hr_utility.trace('2007 EMP_CONT ::: LU ***** Leaving procedure-----------------------------------');
707:
708: RETURN 1; -- here return 1 , other values thru OUT parameters
709:
710: END IF; --end if l_le_lu_exists

Line 716: hr_utility.trace('2007 EMP_CONT ::: LU is not report separately');

712:
713: ELSE ---------------------------------------------------------------------------------------------------------------------------------
714: -- since LU is NOT report separately, check if LE -9999 combination exists
715:
716: hr_utility.trace('2007 EMP_CONT ::: LU is not report separately');
717: hr_utility.trace('2007 EMP_CONT ::: checking if LE exists');
718:
719: start_index_main := NVL (PAY_NO_EMP_CONT_2007.g_tab_main.FIRST, 0) ;
720: end_index_main := NVL (PAY_NO_EMP_CONT_2007.g_tab_main.LAST, 0) ;

Line 717: hr_utility.trace('2007 EMP_CONT ::: checking if LE exists');

713: ELSE ---------------------------------------------------------------------------------------------------------------------------------
714: -- since LU is NOT report separately, check if LE -9999 combination exists
715:
716: hr_utility.trace('2007 EMP_CONT ::: LU is not report separately');
717: hr_utility.trace('2007 EMP_CONT ::: checking if LE exists');
718:
719: start_index_main := NVL (PAY_NO_EMP_CONT_2007.g_tab_main.FIRST, 0) ;
720: end_index_main := NVL (PAY_NO_EMP_CONT_2007.g_tab_main.LAST, 0) ;
721: l_le_exists := FALSE;

Line 734: hr_utility.trace('2007 EMP_CONT ::: LE exists');

730: THEN
731: l_le_exists := TRUE;
732: l_le_index := start_index_main;
733:
734: hr_utility.trace('2007 EMP_CONT ::: LE exists');
735: hr_utility.trace('2007 EMP_CONT ::: l_le_index = '||l_le_index);
736:
737: EXIT;
738: END IF;

Line 735: hr_utility.trace('2007 EMP_CONT ::: l_le_index = '||l_le_index);

731: l_le_exists := TRUE;
732: l_le_index := start_index_main;
733:
734: hr_utility.trace('2007 EMP_CONT ::: LE exists');
735: hr_utility.trace('2007 EMP_CONT ::: l_le_index = '||l_le_index);
736:
737: EXIT;
738: END IF;
739: start_index_main := start_index_main + 1;

Line 751: hr_utility.trace('2007 EMP_CONT ::: LE #### LE already exists, so just returning vales' );

747: p_run_base := PAY_NO_EMP_CONT_2007.g_tab_main(l_le_index).run_base;
748: p_run_contribution := PAY_NO_EMP_CONT_2007.g_tab_main(l_le_index).run_contribution;
749: p_curr_exemption_limit_used := 0; -- coz this value must have been returned before
750:
751: hr_utility.trace('2007 EMP_CONT ::: LE #### LE already exists, so just returning vales' );
752: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_index = '|| l_le_index );
753: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_base = '|| p_run_base );
754: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );
755: hr_utility.trace('2007 EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );

Line 752: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_index = '|| l_le_index );

748: p_run_contribution := PAY_NO_EMP_CONT_2007.g_tab_main(l_le_index).run_contribution;
749: p_curr_exemption_limit_used := 0; -- coz this value must have been returned before
750:
751: hr_utility.trace('2007 EMP_CONT ::: LE #### LE already exists, so just returning vales' );
752: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_index = '|| l_le_index );
753: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_base = '|| p_run_base );
754: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );
755: hr_utility.trace('2007 EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
756:

Line 753: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_base = '|| p_run_base );

749: p_curr_exemption_limit_used := 0; -- coz this value must have been returned before
750:
751: hr_utility.trace('2007 EMP_CONT ::: LE #### LE already exists, so just returning vales' );
752: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_index = '|| l_le_index );
753: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_base = '|| p_run_base );
754: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );
755: hr_utility.trace('2007 EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
756:
757: hr_utility.trace('2007 EMP_CONT ::: LE #### Leaving procedure-----------------------------------');

Line 754: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );

750:
751: hr_utility.trace('2007 EMP_CONT ::: LE #### LE already exists, so just returning vales' );
752: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_index = '|| l_le_index );
753: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_base = '|| p_run_base );
754: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );
755: hr_utility.trace('2007 EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
756:
757: hr_utility.trace('2007 EMP_CONT ::: LE #### Leaving procedure-----------------------------------');
758:

Line 755: hr_utility.trace('2007 EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );

751: hr_utility.trace('2007 EMP_CONT ::: LE #### LE already exists, so just returning vales' );
752: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_index = '|| l_le_index );
753: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_base = '|| p_run_base );
754: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );
755: hr_utility.trace('2007 EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
756:
757: hr_utility.trace('2007 EMP_CONT ::: LE #### Leaving procedure-----------------------------------');
758:
759:

Line 757: hr_utility.trace('2007 EMP_CONT ::: LE #### Leaving procedure-----------------------------------');

753: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_base = '|| p_run_base );
754: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );
755: hr_utility.trace('2007 EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
756:
757: hr_utility.trace('2007 EMP_CONT ::: LE #### Leaving procedure-----------------------------------');
758:
759:
760: RETURN 1; -- here return le_run and the other values thru OUT parameters
761:

Line 766: hr_utility.trace('2007 EMP_CONT ::: LE #### initializing the g_tab_calc , entering');

762: ELSE --------------------------------------------------------------------------------------------------------------------------
763: -- combination does not exist, calculation has to be done and values returned
764:
765: ---------- initializing the g_tab_calc table for LE and -9999 combination
766: hr_utility.trace('2007 EMP_CONT ::: LE #### initializing the g_tab_calc , entering');
767:
768: OPEN PAY_NO_EMP_CONT_2007.get_le_status(p_tax_unit_id);
769: FETCH PAY_NO_EMP_CONT_2007.get_le_status INTO l_le_status;
770: CLOSE PAY_NO_EMP_CONT_2007.get_le_status;

Line 772: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_status = '|| l_le_status );

768: OPEN PAY_NO_EMP_CONT_2007.get_le_status(p_tax_unit_id);
769: FETCH PAY_NO_EMP_CONT_2007.get_le_status INTO l_le_status;
770: CLOSE PAY_NO_EMP_CONT_2007.get_le_status;
771:
772: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_status = '|| l_le_status );
773:
774: -- loop for each zone
775:
776: g_tab_calc(1).zone := '1' ;

Line 799: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');

795: g_tab_calc(i).run_contribution := 0 ;
796:
797: END LOOP; -- end i loop
798:
799: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
800: l_check := display_table_calc(g_tab_calc);
801: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
802:
803: hr_utility.trace('2007 EMP_CONT ::: LE #### finished initializing the g_tab_calc , leaving ');

Line 801: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');

797: END LOOP; -- end i loop
798:
799: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
800: l_check := display_table_calc(g_tab_calc);
801: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
802:
803: hr_utility.trace('2007 EMP_CONT ::: LE #### finished initializing the g_tab_calc , leaving ');
804: ---------------- finished initializing the g_tab_lu table
805:

Line 803: hr_utility.trace('2007 EMP_CONT ::: LE #### finished initializing the g_tab_calc , leaving ');

799: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
800: l_check := display_table_calc(g_tab_calc);
801: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
802:
803: hr_utility.trace('2007 EMP_CONT ::: LE #### finished initializing the g_tab_calc , leaving ');
804: ---------------- finished initializing the g_tab_lu table
805:
806: ---------------- get exemption limit used for LE
807: hr_utility.trace('2007 EMP_CONT ::: LE #### get exemption limit used for LE , entering');

Line 807: hr_utility.trace('2007 EMP_CONT ::: LE #### get exemption limit used for LE , entering');

803: hr_utility.trace('2007 EMP_CONT ::: LE #### finished initializing the g_tab_calc , leaving ');
804: ---------------- finished initializing the g_tab_lu table
805:
806: ---------------- get exemption limit used for LE
807: hr_utility.trace('2007 EMP_CONT ::: LE #### get exemption limit used for LE , entering');
808:
809: -- set the context values for balance
810:
811: pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);

Line 817: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_1 = '|| l_def_bal_id_1 );

813: -- get defined balance ids
814: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_YTD') ;
815: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_BIMONTH') ;
816:
817: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_1 = '|| l_def_bal_id_1 );
818: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_2 = '|| l_def_bal_id_2 );
819:
820: -- get the balance value
821: l_bal_val_ytd := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);

Line 818: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_2 = '|| l_def_bal_id_2 );

814: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_YTD') ;
815: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_BIMONTH') ;
816:
817: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_1 = '|| l_def_bal_id_1 );
818: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_2 = '|| l_def_bal_id_2 );
819:
820: -- get the balance value
821: l_bal_val_ytd := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);
822: l_bal_val_bimonth := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);

Line 829: hr_utility.trace('2007 EMP_CONT ::: LE #### l_bal_val_ytd = '|| l_bal_val_ytd );

825: --l_bal_val_bimonth := 0 ;
826:
827: l_exemption_limit_used_yet := l_bal_val_ytd - l_bal_val_bimonth ;
828:
829: hr_utility.trace('2007 EMP_CONT ::: LE #### l_bal_val_ytd = '|| l_bal_val_ytd );
830: hr_utility.trace('2007 EMP_CONT ::: LE #### l_bal_val_bimonth = '|| l_bal_val_bimonth );
831: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
832:
833: OPEN PAY_NO_EMP_CONT_2007.csr_get_exemption_limit(p_tax_unit_id ,p_date_earned );

Line 830: hr_utility.trace('2007 EMP_CONT ::: LE #### l_bal_val_bimonth = '|| l_bal_val_bimonth );

826:
827: l_exemption_limit_used_yet := l_bal_val_ytd - l_bal_val_bimonth ;
828:
829: hr_utility.trace('2007 EMP_CONT ::: LE #### l_bal_val_ytd = '|| l_bal_val_ytd );
830: hr_utility.trace('2007 EMP_CONT ::: LE #### l_bal_val_bimonth = '|| l_bal_val_bimonth );
831: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
832:
833: OPEN PAY_NO_EMP_CONT_2007.csr_get_exemption_limit(p_tax_unit_id ,p_date_earned );
834:

Line 831: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );

827: l_exemption_limit_used_yet := l_bal_val_ytd - l_bal_val_bimonth ;
828:
829: hr_utility.trace('2007 EMP_CONT ::: LE #### l_bal_val_ytd = '|| l_bal_val_ytd );
830: hr_utility.trace('2007 EMP_CONT ::: LE #### l_bal_val_bimonth = '|| l_bal_val_bimonth );
831: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
832:
833: OPEN PAY_NO_EMP_CONT_2007.csr_get_exemption_limit(p_tax_unit_id ,p_date_earned );
834:
835: -- 2007 Legislative changes for 'Economic Aid' to Employer

Line 841: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit = ' || l_exemption_limit );

837: FETCH PAY_NO_EMP_CONT_2007.csr_get_exemption_limit INTO l_exemption_limit , l_economic_aid ;
838:
839: CLOSE PAY_NO_EMP_CONT_2007.csr_get_exemption_limit;
840:
841: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit = ' || l_exemption_limit );
842: hr_utility.trace('2007 EMP_CONT ::: LE #### l_economic_aid = ' || l_economic_aid );
843:
844: -- 2007 Legislative changes for 'Economic Aid' to Employer
845: l_exemption_limit := l_exemption_limit - l_economic_aid ;

Line 842: hr_utility.trace('2007 EMP_CONT ::: LE #### l_economic_aid = ' || l_economic_aid );

838:
839: CLOSE PAY_NO_EMP_CONT_2007.csr_get_exemption_limit;
840:
841: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit = ' || l_exemption_limit );
842: hr_utility.trace('2007 EMP_CONT ::: LE #### l_economic_aid = ' || l_economic_aid );
843:
844: -- 2007 Legislative changes for 'Economic Aid' to Employer
845: l_exemption_limit := l_exemption_limit - l_economic_aid ;
846:

Line 847: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit after reducing eco aid = ' || l_exemption_limit );

843:
844: -- 2007 Legislative changes for 'Economic Aid' to Employer
845: l_exemption_limit := l_exemption_limit - l_economic_aid ;
846:
847: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit after reducing eco aid = ' || l_exemption_limit );
848:
849: IF l_exemption_limit_used_yet >= l_exemption_limit
850: THEN
851: l_LE_over_limit := 'Y';

Line 856: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit = '|| l_exemption_limit );

852: ELSE
853: l_LE_over_limit := 'N';
854: END IF ; -- end if exemption limit check
855:
856: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit = '|| l_exemption_limit );
857: hr_utility.trace('2007 EMP_CONT ::: LE #### l_LE_over_limit = '|| l_LE_over_limit );
858: hr_utility.trace('2007 EMP_CONT ::: LE #### got exemption limit used for LE , leaving ');
859: ------------------- got exemption limit used for LE
860:

Line 857: hr_utility.trace('2007 EMP_CONT ::: LE #### l_LE_over_limit = '|| l_LE_over_limit );

853: l_LE_over_limit := 'N';
854: END IF ; -- end if exemption limit check
855:
856: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit = '|| l_exemption_limit );
857: hr_utility.trace('2007 EMP_CONT ::: LE #### l_LE_over_limit = '|| l_LE_over_limit );
858: hr_utility.trace('2007 EMP_CONT ::: LE #### got exemption limit used for LE , leaving ');
859: ------------------- got exemption limit used for LE
860:
861: ------------------ populating the tables g_lu_tab (LU) and g_mu_tab (MU)

Line 858: hr_utility.trace('2007 EMP_CONT ::: LE #### got exemption limit used for LE , leaving ');

854: END IF ; -- end if exemption limit check
855:
856: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit = '|| l_exemption_limit );
857: hr_utility.trace('2007 EMP_CONT ::: LE #### l_LE_over_limit = '|| l_LE_over_limit );
858: hr_utility.trace('2007 EMP_CONT ::: LE #### got exemption limit used for LE , leaving ');
859: ------------------- got exemption limit used for LE
860:
861: ------------------ populating the tables g_lu_tab (LU) and g_mu_tab (MU)
862: hr_utility.trace('2007 EMP_CONT ::: LE #### populating the tables g_lu_tab and g_mu_tab , entering');

Line 862: hr_utility.trace('2007 EMP_CONT ::: LE #### populating the tables g_lu_tab and g_mu_tab , entering');

858: hr_utility.trace('2007 EMP_CONT ::: LE #### got exemption limit used for LE , leaving ');
859: ------------------- got exemption limit used for LE
860:
861: ------------------ populating the tables g_lu_tab (LU) and g_mu_tab (MU)
862: hr_utility.trace('2007 EMP_CONT ::: LE #### populating the tables g_lu_tab and g_mu_tab , entering');
863:
864: -- from 2007 , the tax municipality will be picked from the local unit
865:
866: l_temp := populate_tables

Line 873: hr_utility.trace('2007 EMP_CONT ::: LE #### populating the tables g_lu_tab and g_mu_tab, leaving ');

869: ,p_date_earned
870: ,g_lu_tab
871: ,g_mu_tab );
872:
873: hr_utility.trace('2007 EMP_CONT ::: LE #### populating the tables g_lu_tab and g_mu_tab, leaving ');
874:
875: -------------------- Fetch the run base using assignment level balances (at LE level)
876: hr_utility.trace('2007 EMP_CONT ::: LE #### Fetch the run base using assignment level balances , entering');
877:

Line 876: hr_utility.trace('2007 EMP_CONT ::: LE #### Fetch the run base using assignment level balances , entering');

872:
873: hr_utility.trace('2007 EMP_CONT ::: LE #### populating the tables g_lu_tab and g_mu_tab, leaving ');
874:
875: -------------------- Fetch the run base using assignment level balances (at LE level)
876: hr_utility.trace('2007 EMP_CONT ::: LE #### Fetch the run base using assignment level balances , entering');
877:
878: -- get defined balance ids
879: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Base','_ASG_TU_MU_LU_BIMONTH') ;
880: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution Base 2','_ASG_TU_MU_LU_BIMONTH') ;

Line 882: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_1 = '|| l_def_bal_id_1 );

878: -- get defined balance ids
879: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Base','_ASG_TU_MU_LU_BIMONTH') ;
880: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution Base 2','_ASG_TU_MU_LU_BIMONTH') ;
881:
882: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_1 = '|| l_def_bal_id_1 );
883: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_2 = '|| l_def_bal_id_2 );
884:
885: ----- test only , Remove it
886: OPEN csr_test_aag_act_id (p_tax_unit_id , p_payroll_action_id, p_date_earned);

Line 883: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_2 = '|| l_def_bal_id_2 );

879: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Base','_ASG_TU_MU_LU_BIMONTH') ;
880: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution Base 2','_ASG_TU_MU_LU_BIMONTH') ;
881:
882: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_1 = '|| l_def_bal_id_1 );
883: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_2 = '|| l_def_bal_id_2 );
884:
885: ----- test only , Remove it
886: OPEN csr_test_aag_act_id (p_tax_unit_id , p_payroll_action_id, p_date_earned);
887: FETCH csr_test_aag_act_id INTO l_check2;

Line 889: hr_utility.trace('2007 EMP_CONT ::: LE #### l_check2 , no of rows returned by asg act id cursor = '||l_check2 );

885: ----- test only , Remove it
886: OPEN csr_test_aag_act_id (p_tax_unit_id , p_payroll_action_id, p_date_earned);
887: FETCH csr_test_aag_act_id INTO l_check2;
888: CLOSE csr_test_aag_act_id;
889: hr_utility.trace('2007 EMP_CONT ::: LE #### l_check2 , no of rows returned by asg act id cursor = '||l_check2 );
890: -- remove till here
891:
892: hr_utility.trace('2007 EMP_CONT ::: LE #### level 0 leave' );
893:

Line 892: hr_utility.trace('2007 EMP_CONT ::: LE #### level 0 leave' );

888: CLOSE csr_test_aag_act_id;
889: hr_utility.trace('2007 EMP_CONT ::: LE #### l_check2 , no of rows returned by asg act id cursor = '||l_check2 );
890: -- remove till here
891:
892: hr_utility.trace('2007 EMP_CONT ::: LE #### level 0 leave' );
893:
894: -- change 2b -1
895: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
896: ----

Line 901: hr_utility.trace('2007 EMP_CONT ::: LE #### level 1 , loop csr_curr_le_asg_act_id ' );

897:
898: -- loop to get all assignment_action_id in the current payroll_action_id
899: FOR csr1_rec IN csr_curr_le_asg_act_id (p_tax_unit_id , p_payroll_action_id, p_date_earned) LOOP
900:
901: hr_utility.trace('2007 EMP_CONT ::: LE #### level 1 , loop csr_curr_le_asg_act_id ' );
902:
903: start_index_lu := NVL (g_lu_tab.FIRST, 0) ;
904: end_index_lu := NVL (g_lu_tab.LAST, 0) ;
905:

Line 908: hr_utility.trace('2007 EMP_CONT ::: LE #### level 2, g_lu_tab ' );

904: end_index_lu := NVL (g_lu_tab.LAST, 0) ;
905:
906: WHILE (g_lu_tab.EXISTS(start_index_lu)) and (start_index_lu <= end_index_lu) LOOP
907:
908: hr_utility.trace('2007 EMP_CONT ::: LE #### level 2, g_lu_tab ' );
909:
910: start_index_mu := NVL (g_mu_tab.FIRST, 0) ;
911: end_index_mu := NVL (g_mu_tab.LAST, 0) ;
912:

Line 919: hr_utility.trace('2007 EMP_CONT ::: LE #### level 3, g_mu_tab ' );

915: -----
916:
917: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
918:
919: hr_utility.trace('2007 EMP_CONT ::: LE #### level 3, g_mu_tab ' );
920: hr_utility.trace('2007 EMP_CONT ::: LE #### ASS_ACT_ID = '|| csr1_rec.ASSIGNMENT_ACTION_ID || ' MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| g_lu_tab(start_index_lu) );
921:
922: --setting the context values
923: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));

Line 920: hr_utility.trace('2007 EMP_CONT ::: LE #### ASS_ACT_ID = '|| csr1_rec.ASSIGNMENT_ACTION_ID || ' MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| g_lu_tab(start_index_lu) );

916:
917: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
918:
919: hr_utility.trace('2007 EMP_CONT ::: LE #### level 3, g_mu_tab ' );
920: hr_utility.trace('2007 EMP_CONT ::: LE #### ASS_ACT_ID = '|| csr1_rec.ASSIGNMENT_ACTION_ID || ' MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| g_lu_tab(start_index_lu) );
921:
922: --setting the context values
923: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
924:

Line 930: hr_utility.trace('2007 EMP_CONT ::: LE #### l_asg_ers_base = '|| l_asg_ers_base );

926: l_asg_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,csr1_rec.ASSIGNMENT_ACTION_ID);
927: l_asg_ers_base2 := pay_balance_pkg.get_value(l_def_bal_id_2,csr1_rec.ASSIGNMENT_ACTION_ID);
928: l_asg_ers_base_diff := l_asg_ers_base - l_asg_ers_base2;
929:
930: hr_utility.trace('2007 EMP_CONT ::: LE #### l_asg_ers_base = '|| l_asg_ers_base );
931: hr_utility.trace('2007 EMP_CONT ::: LE #### l_asg_ers_base2 = '|| l_asg_ers_base2 );
932: hr_utility.trace('2007 EMP_CONT ::: LE #### l_asg_ers_base_diff = '|| l_asg_ers_base_diff );
933:
934: hr_utility.trace('2007 EMP_CONT ::: LE #### ============== just checking================= ');

Line 931: hr_utility.trace('2007 EMP_CONT ::: LE #### l_asg_ers_base2 = '|| l_asg_ers_base2 );

927: l_asg_ers_base2 := pay_balance_pkg.get_value(l_def_bal_id_2,csr1_rec.ASSIGNMENT_ACTION_ID);
928: l_asg_ers_base_diff := l_asg_ers_base - l_asg_ers_base2;
929:
930: hr_utility.trace('2007 EMP_CONT ::: LE #### l_asg_ers_base = '|| l_asg_ers_base );
931: hr_utility.trace('2007 EMP_CONT ::: LE #### l_asg_ers_base2 = '|| l_asg_ers_base2 );
932: hr_utility.trace('2007 EMP_CONT ::: LE #### l_asg_ers_base_diff = '|| l_asg_ers_base_diff );
933:
934: hr_utility.trace('2007 EMP_CONT ::: LE #### ============== just checking================= ');
935:

Line 932: hr_utility.trace('2007 EMP_CONT ::: LE #### l_asg_ers_base_diff = '|| l_asg_ers_base_diff );

928: l_asg_ers_base_diff := l_asg_ers_base - l_asg_ers_base2;
929:
930: hr_utility.trace('2007 EMP_CONT ::: LE #### l_asg_ers_base = '|| l_asg_ers_base );
931: hr_utility.trace('2007 EMP_CONT ::: LE #### l_asg_ers_base2 = '|| l_asg_ers_base2 );
932: hr_utility.trace('2007 EMP_CONT ::: LE #### l_asg_ers_base_diff = '|| l_asg_ers_base_diff );
933:
934: hr_utility.trace('2007 EMP_CONT ::: LE #### ============== just checking================= ');
935:
936: hr_utility.trace('2007 EMP_CONT ::: LE #### g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );

Line 934: hr_utility.trace('2007 EMP_CONT ::: LE #### ============== just checking================= ');

930: hr_utility.trace('2007 EMP_CONT ::: LE #### l_asg_ers_base = '|| l_asg_ers_base );
931: hr_utility.trace('2007 EMP_CONT ::: LE #### l_asg_ers_base2 = '|| l_asg_ers_base2 );
932: hr_utility.trace('2007 EMP_CONT ::: LE #### l_asg_ers_base_diff = '|| l_asg_ers_base_diff );
933:
934: hr_utility.trace('2007 EMP_CONT ::: LE #### ============== just checking================= ');
935:
936: hr_utility.trace('2007 EMP_CONT ::: LE #### g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
937:
938: l_zone_temp := to_char(g_mu_tab(start_index_mu));

Line 936: hr_utility.trace('2007 EMP_CONT ::: LE #### g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );

932: hr_utility.trace('2007 EMP_CONT ::: LE #### l_asg_ers_base_diff = '|| l_asg_ers_base_diff );
933:
934: hr_utility.trace('2007 EMP_CONT ::: LE #### ============== just checking================= ');
935:
936: hr_utility.trace('2007 EMP_CONT ::: LE #### g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
937:
938: l_zone_temp := to_char(g_mu_tab(start_index_mu));
939:
940: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone_temp = '|| l_zone_temp );

Line 940: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone_temp = '|| l_zone_temp );

936: hr_utility.trace('2007 EMP_CONT ::: LE #### g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
937:
938: l_zone_temp := to_char(g_mu_tab(start_index_mu));
939:
940: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone_temp = '|| l_zone_temp );
941:
942: -- l_zone := to_number(substr(get_lookup_meaning('NO_TAX_MUNICIPALITY',l_zone_temp),1,1));
943: l_zone := hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', l_zone_temp, p_date_earned ) ;
944:

Line 945: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone = '|| l_zone );

941:
942: -- l_zone := to_number(substr(get_lookup_meaning('NO_TAX_MUNICIPALITY',l_zone_temp),1,1));
943: l_zone := hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', l_zone_temp, p_date_earned ) ;
944:
945: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone = '|| l_zone );
946:
947: l_cell := lookup_cell(g_tab_calc,l_zone);
948: g_tab_calc(l_cell).run_base := g_tab_calc(l_cell).run_base + l_asg_ers_base_diff ;
949:

Line 950: hr_utility.trace('2007 EMP_CONT ::: LE #### l_cell = '|| l_cell );

946:
947: l_cell := lookup_cell(g_tab_calc,l_zone);
948: g_tab_calc(l_cell).run_base := g_tab_calc(l_cell).run_base + l_asg_ers_base_diff ;
949:
950: hr_utility.trace('2007 EMP_CONT ::: LE #### l_cell = '|| l_cell );
951:
952: start_index_mu := start_index_mu + 1;
953: END LOOP; -- end while loop g_mu_tab
954:

Line 960: hr_utility.trace('2007 EMP_CONT ::: LE #### level 0 back' );

956: END LOOP; -- end while loop g_lu_tab
957:
958: END LOOP; -- end loop csr1_rec
959:
960: hr_utility.trace('2007 EMP_CONT ::: LE #### level 0 back' );
961:
962: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
963: l_check := display_table_calc(g_tab_calc);
964: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');

Line 962: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');

958: END LOOP; -- end loop csr1_rec
959:
960: hr_utility.trace('2007 EMP_CONT ::: LE #### level 0 back' );
961:
962: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
963: l_check := display_table_calc(g_tab_calc);
964: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
965:
966: hr_utility.trace('2007 EMP_CONT ::: LE #### Fetched the run base using assignment level balances , leaving');

Line 964: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');

960: hr_utility.trace('2007 EMP_CONT ::: LE #### level 0 back' );
961:
962: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
963: l_check := display_table_calc(g_tab_calc);
964: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
965:
966: hr_utility.trace('2007 EMP_CONT ::: LE #### Fetched the run base using assignment level balances , leaving');
967: -------------------- Fetched the run base using assignment level balances (at LE level)
968:

Line 966: hr_utility.trace('2007 EMP_CONT ::: LE #### Fetched the run base using assignment level balances , leaving');

962: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
963: l_check := display_table_calc(g_tab_calc);
964: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
965:
966: hr_utility.trace('2007 EMP_CONT ::: LE #### Fetched the run base using assignment level balances , leaving');
967: -------------------- Fetched the run base using assignment level balances (at LE level)
968:
969: -------------------- Fetch the bimonth base using group level balances (at LE level)
970: hr_utility.trace('2007 EMP_CONT ::: LE #### Fetch the bimonth base using group level balances , entering');

Line 970: hr_utility.trace('2007 EMP_CONT ::: LE #### Fetch the bimonth base using group level balances , entering');

966: hr_utility.trace('2007 EMP_CONT ::: LE #### Fetched the run base using assignment level balances , leaving');
967: -------------------- Fetched the run base using assignment level balances (at LE level)
968:
969: -------------------- Fetch the bimonth base using group level balances (at LE level)
970: hr_utility.trace('2007 EMP_CONT ::: LE #### Fetch the bimonth base using group level balances , entering');
971:
972: -- get defined balance ids
973: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Base','_TU_MU_LU_BIMONTH') ;
974: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution','_TU_MU_LU_BIMONTH') ;

Line 976: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_1 = '|| l_def_bal_id_1 );

972: -- get defined balance ids
973: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Base','_TU_MU_LU_BIMONTH') ;
974: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution','_TU_MU_LU_BIMONTH') ;
975:
976: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_1 = '|| l_def_bal_id_1 );
977: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_2 = '|| l_def_bal_id_2 );
978:
979: -- loop to get all LU in g_lu_tab
980:

Line 977: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_2 = '|| l_def_bal_id_2 );

973: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Base','_TU_MU_LU_BIMONTH') ;
974: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution','_TU_MU_LU_BIMONTH') ;
975:
976: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_1 = '|| l_def_bal_id_1 );
977: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_2 = '|| l_def_bal_id_2 );
978:
979: -- loop to get all LU in g_lu_tab
980:
981: start_index_lu := NVL (g_lu_tab.FIRST, 0) ;

Line 984: hr_utility.trace('2007 EMP_CONT ::: LE #### level 0 leave ' );

980:
981: start_index_lu := NVL (g_lu_tab.FIRST, 0) ;
982: end_index_lu := NVL (g_lu_tab.LAST, 0) ;
983:
984: hr_utility.trace('2007 EMP_CONT ::: LE #### level 0 leave ' );
985:
986: -- change 3b -1
987: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
988: ----

Line 992: hr_utility.trace('2007 EMP_CONT ::: LE #### level 1 ,g_lu_tab ' );

988: ----
989:
990: WHILE (g_lu_tab.EXISTS(start_index_lu)) and (start_index_lu <= end_index_lu) LOOP
991:
992: hr_utility.trace('2007 EMP_CONT ::: LE #### level 1 ,g_lu_tab ' );
993:
994: -- loop to get all MU in g_mu_tab
995: start_index_mu := NVL (g_mu_tab.FIRST, 0) ;
996: end_index_mu := NVL (g_mu_tab.LAST, 0) ;

Line 1004: hr_utility.trace('2007 EMP_CONT ::: LE #### level 2 ,g_mu_tab ' );

1000: ----
1001:
1002: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
1003:
1004: hr_utility.trace('2007 EMP_CONT ::: LE #### level 2 ,g_mu_tab ' );
1005:
1006: hr_utility.trace('2007 EMP_CONT ::: LE #### MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| g_lu_tab(start_index_lu) );
1007:
1008: --setting the context values

Line 1006: hr_utility.trace('2007 EMP_CONT ::: LE #### MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| g_lu_tab(start_index_lu) );

1002: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
1003:
1004: hr_utility.trace('2007 EMP_CONT ::: LE #### level 2 ,g_mu_tab ' );
1005:
1006: hr_utility.trace('2007 EMP_CONT ::: LE #### MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| g_lu_tab(start_index_lu) );
1007:
1008: --setting the context values
1009: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
1010: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));

Line 1017: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_ers_base = '|| l_le_ers_base);

1013: -- get the balance value
1014: l_le_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
1015: l_le_ers := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
1016:
1017: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_ers_base = '|| l_le_ers_base);
1018: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_ers = '||l_le_ers );
1019:
1020: hr_utility.trace('2007 EMP_CONT ::: LE #### ============== just checking again ================= ');
1021:

Line 1018: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_ers = '||l_le_ers );

1014: l_le_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
1015: l_le_ers := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
1016:
1017: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_ers_base = '|| l_le_ers_base);
1018: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_ers = '||l_le_ers );
1019:
1020: hr_utility.trace('2007 EMP_CONT ::: LE #### ============== just checking again ================= ');
1021:
1022: hr_utility.trace('2007 EMP_CONT ::: LE #### g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );

Line 1020: hr_utility.trace('2007 EMP_CONT ::: LE #### ============== just checking again ================= ');

1016:
1017: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_ers_base = '|| l_le_ers_base);
1018: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_ers = '||l_le_ers );
1019:
1020: hr_utility.trace('2007 EMP_CONT ::: LE #### ============== just checking again ================= ');
1021:
1022: hr_utility.trace('2007 EMP_CONT ::: LE #### g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
1023:
1024: l_zone_temp := to_char(g_mu_tab(start_index_mu));

Line 1022: hr_utility.trace('2007 EMP_CONT ::: LE #### g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );

1018: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_ers = '||l_le_ers );
1019:
1020: hr_utility.trace('2007 EMP_CONT ::: LE #### ============== just checking again ================= ');
1021:
1022: hr_utility.trace('2007 EMP_CONT ::: LE #### g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
1023:
1024: l_zone_temp := to_char(g_mu_tab(start_index_mu));
1025:
1026: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone_temp = '|| l_zone_temp );

Line 1026: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone_temp = '|| l_zone_temp );

1022: hr_utility.trace('2007 EMP_CONT ::: LE #### g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
1023:
1024: l_zone_temp := to_char(g_mu_tab(start_index_mu));
1025:
1026: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone_temp = '|| l_zone_temp );
1027:
1028: -- l_zone := to_number(substr(get_lookup_meaning('NO_TAX_MUNICIPALITY',l_zone_temp),1,1));
1029: l_zone := hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', l_zone_temp, p_date_earned ) ;
1030:

Line 1031: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone = '|| l_zone );

1027:
1028: -- l_zone := to_number(substr(get_lookup_meaning('NO_TAX_MUNICIPALITY',l_zone_temp),1,1));
1029: l_zone := hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', l_zone_temp, p_date_earned ) ;
1030:
1031: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone = '|| l_zone );
1032:
1033: l_cell := lookup_cell(g_tab_calc,l_zone);
1034: g_tab_calc(l_cell).bimonth_base := g_tab_calc(l_cell).bimonth_base + l_le_ers_base ;
1035: g_tab_calc(l_cell).bimonth_contribution_todate := g_tab_calc(l_cell).bimonth_contribution_todate + l_le_ers ;

Line 1037: hr_utility.trace('2007 EMP_CONT ::: LE #### l_cell = '|| l_cell );

1033: l_cell := lookup_cell(g_tab_calc,l_zone);
1034: g_tab_calc(l_cell).bimonth_base := g_tab_calc(l_cell).bimonth_base + l_le_ers_base ;
1035: g_tab_calc(l_cell).bimonth_contribution_todate := g_tab_calc(l_cell).bimonth_contribution_todate + l_le_ers ;
1036:
1037: hr_utility.trace('2007 EMP_CONT ::: LE #### l_cell = '|| l_cell );
1038:
1039: start_index_mu := start_index_mu + 1;
1040: END LOOP; -- end while loop g_mu_tab
1041:

Line 1045: hr_utility.trace('2007 EMP_CONT ::: LE #### level 0 back' );

1041:
1042: start_index_lu := start_index_lu + 1;
1043: END LOOP; -- end while loop g_lu_tab
1044:
1045: hr_utility.trace('2007 EMP_CONT ::: LE #### level 0 back' );
1046:
1047: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
1048: l_check := display_table_calc(g_tab_calc);
1049: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');

Line 1047: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');

1043: END LOOP; -- end while loop g_lu_tab
1044:
1045: hr_utility.trace('2007 EMP_CONT ::: LE #### level 0 back' );
1046:
1047: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
1048: l_check := display_table_calc(g_tab_calc);
1049: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
1050:
1051: hr_utility.trace('2007 EMP_CONT ::: LE #### Fetch the bimonth base using group level balances , leaving ');

Line 1049: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');

1045: hr_utility.trace('2007 EMP_CONT ::: LE #### level 0 back' );
1046:
1047: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
1048: l_check := display_table_calc(g_tab_calc);
1049: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
1050:
1051: hr_utility.trace('2007 EMP_CONT ::: LE #### Fetch the bimonth base using group level balances , leaving ');
1052: -------------------- Fetched the bimonth base using group level balances (at LE level)
1053:

Line 1051: hr_utility.trace('2007 EMP_CONT ::: LE #### Fetch the bimonth base using group level balances , leaving ');

1047: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
1048: l_check := display_table_calc(g_tab_calc);
1049: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
1050:
1051: hr_utility.trace('2007 EMP_CONT ::: LE #### Fetch the bimonth base using group level balances , leaving ');
1052: -------------------- Fetched the bimonth base using group level balances (at LE level)
1053:
1054: ------------------------------ apply differential rate and check exemption limit at LE Level
1055: hr_utility.trace('2007 EMP_CONT ::: LE #### apply differential rate and check exemption limit , entering ');

Line 1055: hr_utility.trace('2007 EMP_CONT ::: LE #### apply differential rate and check exemption limit , entering ');

1051: hr_utility.trace('2007 EMP_CONT ::: LE #### Fetch the bimonth base using group level balances , leaving ');
1052: -------------------- Fetched the bimonth base using group level balances (at LE level)
1053:
1054: ------------------------------ apply differential rate and check exemption limit at LE Level
1055: hr_utility.trace('2007 EMP_CONT ::: LE #### apply differential rate and check exemption limit , entering ');
1056:
1057: --l_lu_status --status for LU
1058: --l_le_status --status for LE
1059: l_total_saving := 0;

Line 1065: hr_utility.trace('2007 EMP_CONT ::: LE #### l_LE_over_limit = Y ' );

1061: -- check if exemption limit already used up
1062: IF l_LE_over_limit = 'Y'
1063:
1064: THEN
1065: hr_utility.trace('2007 EMP_CONT ::: LE #### l_LE_over_limit = Y ' );
1066:
1067: -- as limit is over, put under_limit as N for all rows
1068: FOR i IN 1..7 LOOP
1069: g_tab_calc(i).under_limit := 'N';

Line 1072: hr_utility.trace('2007 EMP_CONT ::: LE #### as limit is over, put under_limit as N for all rows ');

1068: FOR i IN 1..7 LOOP
1069: g_tab_calc(i).under_limit := 'N';
1070: END LOOP; -- end i loop
1071:
1072: hr_utility.trace('2007 EMP_CONT ::: LE #### as limit is over, put under_limit as N for all rows ');
1073:
1074: ELSE
1075: hr_utility.trace('2007 EMP_CONT ::: LE #### l_LE_over_limit = N ' );
1076:

Line 1075: hr_utility.trace('2007 EMP_CONT ::: LE #### l_LE_over_limit = N ' );

1071:
1072: hr_utility.trace('2007 EMP_CONT ::: LE #### as limit is over, put under_limit as N for all rows ');
1073:
1074: ELSE
1075: hr_utility.trace('2007 EMP_CONT ::: LE #### l_LE_over_limit = N ' );
1076:
1077: -- limit is not over
1078: -- perform exemption limit check only if status = AA,CC,GG
1079: IF ( l_le_status = 'AA' OR l_le_status = 'GG' OR l_le_status = 'CC' )

Line 1082: hr_utility.trace('2007 EMP_CONT ::: LE #### status is = '|| l_le_status );

1078: -- perform exemption limit check only if status = AA,CC,GG
1079: IF ( l_le_status = 'AA' OR l_le_status = 'GG' OR l_le_status = 'CC' )
1080:
1081: THEN
1082: hr_utility.trace('2007 EMP_CONT ::: LE #### status is = '|| l_le_status );
1083:
1084: -------- performing exemption limit check
1085: l_table_name := 'NO_NIS_ZONE_RATES';
1086:

Line 1097: hr_utility.trace('2007 EMP_CONT ::: LE #### exemption limit check ----------------------' );

1093:
1094: l_col_name := 'NIS Rates';
1095: l_high_rate := p_under_age_high_rate;
1096:
1097: hr_utility.trace('2007 EMP_CONT ::: LE #### exemption limit check ----------------------' );
1098:
1099: l_zone_value := to_char(g_tab_calc(i).zone);
1100: -- l_normal_rate := TO_NUMBER(hruserdt.get_table_value (p_bus_group_id, l_table_name, l_col_name, l_zone_value, p_date_earned ));
1101: l_normal_rate := fnd_number.canonical_to_number(hruserdt.get_table_value (p_bus_group_id, l_table_name, l_col_name, l_zone_value, p_date_earned ));

Line 1107: hr_utility.trace('2007 EMP_CONT ::: LE #### i = '||i||' l_zone_value = '||l_zone_value

1103:
1104: l_saving := ( g_tab_calc(i).bimonth_base * l_diff_rate ) / 100 ;
1105: l_total_saving := l_total_saving + l_saving ;
1106:
1107: hr_utility.trace('2007 EMP_CONT ::: LE #### i = '||i||' l_zone_value = '||l_zone_value
1108: ||' l_normal_rate = '||l_normal_rate||' l_high_rate = '||l_high_rate
1109: ||' l_diff_rate = '||l_diff_rate||' l_saving = '||l_saving||' l_total_saving = '||l_total_saving );
1110:
1111: -- check if exemption limit exceeded

Line 1114: hr_utility.trace('2007 EMP_CONT ::: LE #### exemption limit exceeded in table');

1110:
1111: -- check if exemption limit exceeded
1112: IF ((l_exemption_limit_used_yet + l_total_saving) >= l_exemption_limit)
1113: THEN
1114: hr_utility.trace('2007 EMP_CONT ::: LE #### exemption limit exceeded in table');
1115: hr_utility.trace('2007 EMP_CONT ::: LE #### bimonth_base = '|| g_tab_calc(i).bimonth_base );
1116: hr_utility.trace('2007 EMP_CONT ::: LE #### run_base = '||g_tab_calc(i).run_base );
1117: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone_value = '|| l_zone_value );
1118: hr_utility.trace('2007 EMP_CONT ::: LE #### l_normal_rate = '|| l_normal_rate );

Line 1115: hr_utility.trace('2007 EMP_CONT ::: LE #### bimonth_base = '|| g_tab_calc(i).bimonth_base );

1111: -- check if exemption limit exceeded
1112: IF ((l_exemption_limit_used_yet + l_total_saving) >= l_exemption_limit)
1113: THEN
1114: hr_utility.trace('2007 EMP_CONT ::: LE #### exemption limit exceeded in table');
1115: hr_utility.trace('2007 EMP_CONT ::: LE #### bimonth_base = '|| g_tab_calc(i).bimonth_base );
1116: hr_utility.trace('2007 EMP_CONT ::: LE #### run_base = '||g_tab_calc(i).run_base );
1117: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone_value = '|| l_zone_value );
1118: hr_utility.trace('2007 EMP_CONT ::: LE #### l_normal_rate = '|| l_normal_rate );
1119: hr_utility.trace('2007 EMP_CONT ::: LE #### l_high_rate = '|| l_high_rate );

Line 1116: hr_utility.trace('2007 EMP_CONT ::: LE #### run_base = '||g_tab_calc(i).run_base );

1112: IF ((l_exemption_limit_used_yet + l_total_saving) >= l_exemption_limit)
1113: THEN
1114: hr_utility.trace('2007 EMP_CONT ::: LE #### exemption limit exceeded in table');
1115: hr_utility.trace('2007 EMP_CONT ::: LE #### bimonth_base = '|| g_tab_calc(i).bimonth_base );
1116: hr_utility.trace('2007 EMP_CONT ::: LE #### run_base = '||g_tab_calc(i).run_base );
1117: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone_value = '|| l_zone_value );
1118: hr_utility.trace('2007 EMP_CONT ::: LE #### l_normal_rate = '|| l_normal_rate );
1119: hr_utility.trace('2007 EMP_CONT ::: LE #### l_high_rate = '|| l_high_rate );
1120: hr_utility.trace('2007 EMP_CONT ::: LE #### l_diff_rate = '|| l_diff_rate );

Line 1117: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone_value = '|| l_zone_value );

1113: THEN
1114: hr_utility.trace('2007 EMP_CONT ::: LE #### exemption limit exceeded in table');
1115: hr_utility.trace('2007 EMP_CONT ::: LE #### bimonth_base = '|| g_tab_calc(i).bimonth_base );
1116: hr_utility.trace('2007 EMP_CONT ::: LE #### run_base = '||g_tab_calc(i).run_base );
1117: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone_value = '|| l_zone_value );
1118: hr_utility.trace('2007 EMP_CONT ::: LE #### l_normal_rate = '|| l_normal_rate );
1119: hr_utility.trace('2007 EMP_CONT ::: LE #### l_high_rate = '|| l_high_rate );
1120: hr_utility.trace('2007 EMP_CONT ::: LE #### l_diff_rate = '|| l_diff_rate );
1121: hr_utility.trace('2007 EMP_CONT ::: LE #### l_saving = '|| l_saving );

Line 1118: hr_utility.trace('2007 EMP_CONT ::: LE #### l_normal_rate = '|| l_normal_rate );

1114: hr_utility.trace('2007 EMP_CONT ::: LE #### exemption limit exceeded in table');
1115: hr_utility.trace('2007 EMP_CONT ::: LE #### bimonth_base = '|| g_tab_calc(i).bimonth_base );
1116: hr_utility.trace('2007 EMP_CONT ::: LE #### run_base = '||g_tab_calc(i).run_base );
1117: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone_value = '|| l_zone_value );
1118: hr_utility.trace('2007 EMP_CONT ::: LE #### l_normal_rate = '|| l_normal_rate );
1119: hr_utility.trace('2007 EMP_CONT ::: LE #### l_high_rate = '|| l_high_rate );
1120: hr_utility.trace('2007 EMP_CONT ::: LE #### l_diff_rate = '|| l_diff_rate );
1121: hr_utility.trace('2007 EMP_CONT ::: LE #### l_saving = '|| l_saving );
1122: hr_utility.trace('2007 EMP_CONT ::: LE #### l_total_saving= '|| l_total_saving );

Line 1119: hr_utility.trace('2007 EMP_CONT ::: LE #### l_high_rate = '|| l_high_rate );

1115: hr_utility.trace('2007 EMP_CONT ::: LE #### bimonth_base = '|| g_tab_calc(i).bimonth_base );
1116: hr_utility.trace('2007 EMP_CONT ::: LE #### run_base = '||g_tab_calc(i).run_base );
1117: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone_value = '|| l_zone_value );
1118: hr_utility.trace('2007 EMP_CONT ::: LE #### l_normal_rate = '|| l_normal_rate );
1119: hr_utility.trace('2007 EMP_CONT ::: LE #### l_high_rate = '|| l_high_rate );
1120: hr_utility.trace('2007 EMP_CONT ::: LE #### l_diff_rate = '|| l_diff_rate );
1121: hr_utility.trace('2007 EMP_CONT ::: LE #### l_saving = '|| l_saving );
1122: hr_utility.trace('2007 EMP_CONT ::: LE #### l_total_saving= '|| l_total_saving );
1123: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );

Line 1120: hr_utility.trace('2007 EMP_CONT ::: LE #### l_diff_rate = '|| l_diff_rate );

1116: hr_utility.trace('2007 EMP_CONT ::: LE #### run_base = '||g_tab_calc(i).run_base );
1117: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone_value = '|| l_zone_value );
1118: hr_utility.trace('2007 EMP_CONT ::: LE #### l_normal_rate = '|| l_normal_rate );
1119: hr_utility.trace('2007 EMP_CONT ::: LE #### l_high_rate = '|| l_high_rate );
1120: hr_utility.trace('2007 EMP_CONT ::: LE #### l_diff_rate = '|| l_diff_rate );
1121: hr_utility.trace('2007 EMP_CONT ::: LE #### l_saving = '|| l_saving );
1122: hr_utility.trace('2007 EMP_CONT ::: LE #### l_total_saving= '|| l_total_saving );
1123: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
1124:

Line 1121: hr_utility.trace('2007 EMP_CONT ::: LE #### l_saving = '|| l_saving );

1117: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone_value = '|| l_zone_value );
1118: hr_utility.trace('2007 EMP_CONT ::: LE #### l_normal_rate = '|| l_normal_rate );
1119: hr_utility.trace('2007 EMP_CONT ::: LE #### l_high_rate = '|| l_high_rate );
1120: hr_utility.trace('2007 EMP_CONT ::: LE #### l_diff_rate = '|| l_diff_rate );
1121: hr_utility.trace('2007 EMP_CONT ::: LE #### l_saving = '|| l_saving );
1122: hr_utility.trace('2007 EMP_CONT ::: LE #### l_total_saving= '|| l_total_saving );
1123: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
1124:
1125: -- get the exceeding amount

Line 1122: hr_utility.trace('2007 EMP_CONT ::: LE #### l_total_saving= '|| l_total_saving );

1118: hr_utility.trace('2007 EMP_CONT ::: LE #### l_normal_rate = '|| l_normal_rate );
1119: hr_utility.trace('2007 EMP_CONT ::: LE #### l_high_rate = '|| l_high_rate );
1120: hr_utility.trace('2007 EMP_CONT ::: LE #### l_diff_rate = '|| l_diff_rate );
1121: hr_utility.trace('2007 EMP_CONT ::: LE #### l_saving = '|| l_saving );
1122: hr_utility.trace('2007 EMP_CONT ::: LE #### l_total_saving= '|| l_total_saving );
1123: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
1124:
1125: -- get the exceeding amount
1126: l_amount_over_limit := ((l_exemption_limit_used_yet + l_total_saving) - l_exemption_limit);

Line 1123: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );

1119: hr_utility.trace('2007 EMP_CONT ::: LE #### l_high_rate = '|| l_high_rate );
1120: hr_utility.trace('2007 EMP_CONT ::: LE #### l_diff_rate = '|| l_diff_rate );
1121: hr_utility.trace('2007 EMP_CONT ::: LE #### l_saving = '|| l_saving );
1122: hr_utility.trace('2007 EMP_CONT ::: LE #### l_total_saving= '|| l_total_saving );
1123: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
1124:
1125: -- get the exceeding amount
1126: l_amount_over_limit := ((l_exemption_limit_used_yet + l_total_saving) - l_exemption_limit);
1127: l_base_over_limit := ( l_amount_over_limit / l_diff_rate ) * 100 ;

Line 1153: hr_utility.trace('2007 EMP_CONT ::: LE #### l_amount_over_limit = '|| l_amount_over_limit );

1149: -- set the new l_total_saving
1150:
1151: l_total_saving := l_exemption_limit - l_exemption_limit_used_yet ;
1152:
1153: hr_utility.trace('2007 EMP_CONT ::: LE #### l_amount_over_limit = '|| l_amount_over_limit );
1154: hr_utility.trace('2007 EMP_CONT ::: LE #### l_base_over_limit = '|| l_base_over_limit );
1155: hr_utility.trace('2007 EMP_CONT ::: LE #### NEW bimonth base for current row = '|| g_tab_calc(i).bimonth_base );
1156: hr_utility.trace('2007 EMP_CONT ::: LE #### NEW l_total_saving = '|| l_total_saving );
1157:

Line 1154: hr_utility.trace('2007 EMP_CONT ::: LE #### l_base_over_limit = '|| l_base_over_limit );

1150:
1151: l_total_saving := l_exemption_limit - l_exemption_limit_used_yet ;
1152:
1153: hr_utility.trace('2007 EMP_CONT ::: LE #### l_amount_over_limit = '|| l_amount_over_limit );
1154: hr_utility.trace('2007 EMP_CONT ::: LE #### l_base_over_limit = '|| l_base_over_limit );
1155: hr_utility.trace('2007 EMP_CONT ::: LE #### NEW bimonth base for current row = '|| g_tab_calc(i).bimonth_base );
1156: hr_utility.trace('2007 EMP_CONT ::: LE #### NEW l_total_saving = '|| l_total_saving );
1157:
1158: -- insert a new row for exceeded limit

Line 1155: hr_utility.trace('2007 EMP_CONT ::: LE #### NEW bimonth base for current row = '|| g_tab_calc(i).bimonth_base );

1151: l_total_saving := l_exemption_limit - l_exemption_limit_used_yet ;
1152:
1153: hr_utility.trace('2007 EMP_CONT ::: LE #### l_amount_over_limit = '|| l_amount_over_limit );
1154: hr_utility.trace('2007 EMP_CONT ::: LE #### l_base_over_limit = '|| l_base_over_limit );
1155: hr_utility.trace('2007 EMP_CONT ::: LE #### NEW bimonth base for current row = '|| g_tab_calc(i).bimonth_base );
1156: hr_utility.trace('2007 EMP_CONT ::: LE #### NEW l_total_saving = '|| l_total_saving );
1157:
1158: -- insert a new row for exceeded limit
1159:

Line 1156: hr_utility.trace('2007 EMP_CONT ::: LE #### NEW l_total_saving = '|| l_total_saving );

1152:
1153: hr_utility.trace('2007 EMP_CONT ::: LE #### l_amount_over_limit = '|| l_amount_over_limit );
1154: hr_utility.trace('2007 EMP_CONT ::: LE #### l_base_over_limit = '|| l_base_over_limit );
1155: hr_utility.trace('2007 EMP_CONT ::: LE #### NEW bimonth base for current row = '|| g_tab_calc(i).bimonth_base );
1156: hr_utility.trace('2007 EMP_CONT ::: LE #### NEW l_total_saving = '|| l_total_saving );
1157:
1158: -- insert a new row for exceeded limit
1159:
1160: g_tab_calc(8).zone := g_tab_calc(i).zone;

Line 1178: --hr_utility.trace('2007 EMP_CONT ::: LE #### l_LE_over_limit Y' );

1174: END LOOP; --end j loop
1175:
1176: l_LE_over_limit := 'Y'; -- indicating exemption limit on LE level is over
1177:
1178: --hr_utility.trace('2007 EMP_CONT ::: LE #### l_LE_over_limit Y' );
1179: hr_utility.trace('2007 EMP_CONT ::: LE #### l_LE_over_limit = '||l_LE_over_limit );
1180:
1181: EXIT; -- exit loop i since no more check is required
1182: END IF; -- end check if exemption limit exceeded

Line 1179: hr_utility.trace('2007 EMP_CONT ::: LE #### l_LE_over_limit = '||l_LE_over_limit );

1175:
1176: l_LE_over_limit := 'Y'; -- indicating exemption limit on LE level is over
1177:
1178: --hr_utility.trace('2007 EMP_CONT ::: LE #### l_LE_over_limit Y' );
1179: hr_utility.trace('2007 EMP_CONT ::: LE #### l_LE_over_limit = '||l_LE_over_limit );
1180:
1181: EXIT; -- exit loop i since no more check is required
1182: END IF; -- end check if exemption limit exceeded
1183:

Line 1199: hr_utility.trace('2007 EMP_CONT ::: LE #### l_total_saving = '||l_total_saving );

1195: END IF; -- end if l_LE_over_limit = Y
1196:
1197: l_exemption_limit_used := l_total_saving - l_bal_val_bimonth ;
1198:
1199: hr_utility.trace('2007 EMP_CONT ::: LE #### l_total_saving = '||l_total_saving );
1200: hr_utility.trace('2007 EMP_CONT ::: LE #### l_bal_val_bimonth = '||l_bal_val_bimonth );
1201: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit_used = '||l_exemption_limit_used );
1202:
1203: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');

Line 1200: hr_utility.trace('2007 EMP_CONT ::: LE #### l_bal_val_bimonth = '||l_bal_val_bimonth );

1196:
1197: l_exemption_limit_used := l_total_saving - l_bal_val_bimonth ;
1198:
1199: hr_utility.trace('2007 EMP_CONT ::: LE #### l_total_saving = '||l_total_saving );
1200: hr_utility.trace('2007 EMP_CONT ::: LE #### l_bal_val_bimonth = '||l_bal_val_bimonth );
1201: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit_used = '||l_exemption_limit_used );
1202:
1203: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
1204: l_check := display_table_calc(g_tab_calc);

Line 1201: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit_used = '||l_exemption_limit_used );

1197: l_exemption_limit_used := l_total_saving - l_bal_val_bimonth ;
1198:
1199: hr_utility.trace('2007 EMP_CONT ::: LE #### l_total_saving = '||l_total_saving );
1200: hr_utility.trace('2007 EMP_CONT ::: LE #### l_bal_val_bimonth = '||l_bal_val_bimonth );
1201: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit_used = '||l_exemption_limit_used );
1202:
1203: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
1204: l_check := display_table_calc(g_tab_calc);
1205: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');

Line 1203: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');

1199: hr_utility.trace('2007 EMP_CONT ::: LE #### l_total_saving = '||l_total_saving );
1200: hr_utility.trace('2007 EMP_CONT ::: LE #### l_bal_val_bimonth = '||l_bal_val_bimonth );
1201: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit_used = '||l_exemption_limit_used );
1202:
1203: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
1204: l_check := display_table_calc(g_tab_calc);
1205: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
1206:
1207: hr_utility.trace('2007 EMP_CONT ::: LE #### apply differential rate and check exemption limit , leaving ');

Line 1205: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');

1201: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit_used = '||l_exemption_limit_used );
1202:
1203: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
1204: l_check := display_table_calc(g_tab_calc);
1205: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
1206:
1207: hr_utility.trace('2007 EMP_CONT ::: LE #### apply differential rate and check exemption limit , leaving ');
1208: ------------------------------ applied differential rate and check exemption limit at LE Level
1209:

Line 1207: hr_utility.trace('2007 EMP_CONT ::: LE #### apply differential rate and check exemption limit , leaving ');

1203: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
1204: l_check := display_table_calc(g_tab_calc);
1205: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
1206:
1207: hr_utility.trace('2007 EMP_CONT ::: LE #### apply differential rate and check exemption limit , leaving ');
1208: ------------------------------ applied differential rate and check exemption limit at LE Level
1209:
1210: -- ec_main_calculation function call for LE
1211: hr_utility.trace('2007 EMP_CONT ::: LE #### ec_main_calculation function call for LE , entering ' );

Line 1211: hr_utility.trace('2007 EMP_CONT ::: LE #### ec_main_calculation function call for LE , entering ' );

1207: hr_utility.trace('2007 EMP_CONT ::: LE #### apply differential rate and check exemption limit , leaving ');
1208: ------------------------------ applied differential rate and check exemption limit at LE Level
1209:
1210: -- ec_main_calculation function call for LE
1211: hr_utility.trace('2007 EMP_CONT ::: LE #### ec_main_calculation function call for LE , entering ' );
1212:
1213: l_main_index := ec_main_calculation ( g_tab_calc
1214: ,PAY_NO_EMP_CONT_2007.g_tab_main
1215: ,p_tax_unit_id

Line 1227: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');

1223: ,l_curr_zone ) ;
1224:
1225:
1226:
1227: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
1228: l_check := display_table_calc(g_tab_calc);
1229: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
1230:
1231: hr_utility.trace('2007 EMP_CONT ::: LE #### ec_main_calculation function call for LE , leaving ' );

Line 1229: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');

1225:
1226:
1227: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
1228: l_check := display_table_calc(g_tab_calc);
1229: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
1230:
1231: hr_utility.trace('2007 EMP_CONT ::: LE #### ec_main_calculation function call for LE , leaving ' );
1232:
1233: -- done all caclculation and entered values in the main table for next time usage

Line 1231: hr_utility.trace('2007 EMP_CONT ::: LE #### ec_main_calculation function call for LE , leaving ' );

1227: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
1228: l_check := display_table_calc(g_tab_calc);
1229: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
1230:
1231: hr_utility.trace('2007 EMP_CONT ::: LE #### ec_main_calculation function call for LE , leaving ' );
1232:
1233: -- done all caclculation and entered values in the main table for next time usage
1234:
1235: -- returning values at LE level

Line 1240: hr_utility.trace('2007 EMP_CONT ::: LE #### l_main_index = '|| l_main_index );

1236: p_run_base := PAY_NO_EMP_CONT_2007.g_tab_main(l_main_index).run_base;
1237: p_run_contribution := PAY_NO_EMP_CONT_2007.g_tab_main(l_main_index).run_contribution;
1238: p_curr_exemption_limit_used := PAY_NO_EMP_CONT_2007.g_tab_main(l_main_index).exemption_limit_used;
1239:
1240: hr_utility.trace('2007 EMP_CONT ::: LE #### l_main_index = '|| l_main_index );
1241: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_base = '|| p_run_base );
1242: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );
1243: hr_utility.trace('2007 EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
1244:

Line 1241: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_base = '|| p_run_base );

1237: p_run_contribution := PAY_NO_EMP_CONT_2007.g_tab_main(l_main_index).run_contribution;
1238: p_curr_exemption_limit_used := PAY_NO_EMP_CONT_2007.g_tab_main(l_main_index).exemption_limit_used;
1239:
1240: hr_utility.trace('2007 EMP_CONT ::: LE #### l_main_index = '|| l_main_index );
1241: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_base = '|| p_run_base );
1242: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );
1243: hr_utility.trace('2007 EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
1244:
1245: hr_utility.trace('2007 EMP_CONT ::: LE #### Leaving procedure-----------------------------------');

Line 1242: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );

1238: p_curr_exemption_limit_used := PAY_NO_EMP_CONT_2007.g_tab_main(l_main_index).exemption_limit_used;
1239:
1240: hr_utility.trace('2007 EMP_CONT ::: LE #### l_main_index = '|| l_main_index );
1241: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_base = '|| p_run_base );
1242: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );
1243: hr_utility.trace('2007 EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
1244:
1245: hr_utility.trace('2007 EMP_CONT ::: LE #### Leaving procedure-----------------------------------');
1246:

Line 1243: hr_utility.trace('2007 EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );

1239:
1240: hr_utility.trace('2007 EMP_CONT ::: LE #### l_main_index = '|| l_main_index );
1241: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_base = '|| p_run_base );
1242: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );
1243: hr_utility.trace('2007 EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
1244:
1245: hr_utility.trace('2007 EMP_CONT ::: LE #### Leaving procedure-----------------------------------');
1246:
1247: RETURN 1; -- here return 1 and the other values thru OUT parameters

Line 1245: hr_utility.trace('2007 EMP_CONT ::: LE #### Leaving procedure-----------------------------------');

1241: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_base = '|| p_run_base );
1242: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );
1243: hr_utility.trace('2007 EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
1244:
1245: hr_utility.trace('2007 EMP_CONT ::: LE #### Leaving procedure-----------------------------------');
1246:
1247: RETURN 1; -- here return 1 and the other values thru OUT parameters
1248:
1249:

Line 1255: hr_utility.trace('2007 EMP_CONT ::: exiting main function');

1251:
1252:
1253: END IF; -- end if l_lu_rep_sep = 'Y'
1254:
1255: hr_utility.trace('2007 EMP_CONT ::: exiting main function');
1256: --hr_utility.trace_off();
1257:
1258: -----------------------------------Exception -----------------------------------------------------------
1259: --EXCEPTION

Line 1256: --hr_utility.trace_off();

1252:
1253: END IF; -- end if l_lu_rep_sep = 'Y'
1254:
1255: hr_utility.trace('2007 EMP_CONT ::: exiting main function');
1256: --hr_utility.trace_off();
1257:
1258: -----------------------------------Exception -----------------------------------------------------------
1259: --EXCEPTION
1260:

Line 1360: hr_utility.trace('2007 EMP_CONT ::: --------------------------------------------------------');

1356:
1357: -- loop to get local unit and tax municipality for all assignment actions obtained above
1358: FOR csr3_rec IN PAY_NO_EMP_CONT_2007.csr_lu_mu (csr2_rec.ASSIGNMENT_ID , csr2_rec.ASSIGNMENT_ACTION_ID , p_date_earned , l_tax_ele_type_id ) LOOP
1359:
1360: hr_utility.trace('2007 EMP_CONT ::: --------------------------------------------------------');
1361:
1362: hr_utility.trace('2007 EMP_CONT ::: PAY_ACT_ID = '||csr1_rec.PAYROLL_ACTION_ID||' ASS_ID = '||csr2_rec.ASSIGNMENT_ID||' ASS_ACT_ID = '||csr2_rec.ASSIGNMENT_ACTION_ID
1363: ||' Local Unit = '||csr3_rec.local_unit_id||' Tax Mul = '||csr3_rec.tax_mun_id);
1364:

Line 1362: hr_utility.trace('2007 EMP_CONT ::: PAY_ACT_ID = '||csr1_rec.PAYROLL_ACTION_ID||' ASS_ID = '||csr2_rec.ASSIGNMENT_ID||' ASS_ACT_ID = '||csr2_rec.ASSIGNMENT_ACTION_ID

1358: FOR csr3_rec IN PAY_NO_EMP_CONT_2007.csr_lu_mu (csr2_rec.ASSIGNMENT_ID , csr2_rec.ASSIGNMENT_ACTION_ID , p_date_earned , l_tax_ele_type_id ) LOOP
1359:
1360: hr_utility.trace('2007 EMP_CONT ::: --------------------------------------------------------');
1361:
1362: hr_utility.trace('2007 EMP_CONT ::: PAY_ACT_ID = '||csr1_rec.PAYROLL_ACTION_ID||' ASS_ID = '||csr2_rec.ASSIGNMENT_ID||' ASS_ACT_ID = '||csr2_rec.ASSIGNMENT_ACTION_ID
1363: ||' Local Unit = '||csr3_rec.local_unit_id||' Tax Mul = '||csr3_rec.tax_mun_id);
1364:
1365: ----------------------------- check for MU -------------------------------------------
1366: start_index_mu := NVL (g_mu_tab.FIRST, 0) ;

Line 1438: hr_utility.trace('2007 EMP_CONT ::: *****************************************************************************');

1434: start_index_mu := NVL (g_mu_tab.FIRST, 0) ;
1435: end_index_mu := NVL (g_mu_tab.LAST, 0) ;
1436:
1437: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
1438: hr_utility.trace('2007 EMP_CONT ::: *****************************************************************************');
1439: hr_utility.trace('2007 EMP_CONT ::: Tax Mul = '|| g_mu_tab(start_index_mu));
1440:
1441: start_index_mu := start_index_mu + 1;
1442: END LOOP; -- end while loop

Line 1439: hr_utility.trace('2007 EMP_CONT ::: Tax Mul = '|| g_mu_tab(start_index_mu));

1435: end_index_mu := NVL (g_mu_tab.LAST, 0) ;
1436:
1437: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
1438: hr_utility.trace('2007 EMP_CONT ::: *****************************************************************************');
1439: hr_utility.trace('2007 EMP_CONT ::: Tax Mul = '|| g_mu_tab(start_index_mu));
1440:
1441: start_index_mu := start_index_mu + 1;
1442: END LOOP; -- end while loop
1443: hr_utility.trace('2007 EMP_CONT ::: *****************************************************************************');

Line 1443: hr_utility.trace('2007 EMP_CONT ::: *****************************************************************************');

1439: hr_utility.trace('2007 EMP_CONT ::: Tax Mul = '|| g_mu_tab(start_index_mu));
1440:
1441: start_index_mu := start_index_mu + 1;
1442: END LOOP; -- end while loop
1443: hr_utility.trace('2007 EMP_CONT ::: *****************************************************************************');
1444:
1445: -- end sub test 1
1446: -------------------------------------------------------------------------------------------------
1447:

Line 1456: hr_utility.trace('2007 EMP_CONT ::: \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\');

1452: end_index_lu := NVL (g_lu_tab.LAST, 0) ;
1453:
1454:
1455: WHILE (g_lu_tab.EXISTS(start_index_lu)) and (start_index_lu <= end_index_lu) LOOP
1456: hr_utility.trace('2007 EMP_CONT ::: \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\');
1457: hr_utility.trace('2007 EMP_CONT ::: Local Unit = '|| g_lu_tab(start_index_lu));
1458:
1459: start_index_lu := start_index_lu + 1;
1460: END LOOP; -- end while loop

Line 1457: hr_utility.trace('2007 EMP_CONT ::: Local Unit = '|| g_lu_tab(start_index_lu));

1453:
1454:
1455: WHILE (g_lu_tab.EXISTS(start_index_lu)) and (start_index_lu <= end_index_lu) LOOP
1456: hr_utility.trace('2007 EMP_CONT ::: \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\');
1457: hr_utility.trace('2007 EMP_CONT ::: Local Unit = '|| g_lu_tab(start_index_lu));
1458:
1459: start_index_lu := start_index_lu + 1;
1460: END LOOP; -- end while loop
1461: hr_utility.trace('2007 EMP_CONT ::: \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\');

Line 1461: hr_utility.trace('2007 EMP_CONT ::: \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\');

1457: hr_utility.trace('2007 EMP_CONT ::: Local Unit = '|| g_lu_tab(start_index_lu));
1458:
1459: start_index_lu := start_index_lu + 1;
1460: END LOOP; -- end while loop
1461: hr_utility.trace('2007 EMP_CONT ::: \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\');
1462:
1463: -- end sub test 2
1464:
1465: ------------------------------

Line 1559: hr_utility.trace('2007 EMP_CONT ::: Initializing Main Table --------');

1555: start_main_index := NVL (g_tab_main.LAST, 0) + 1 ;
1556: end_main_index := start_main_index + 6 ;
1557: x := 1;
1558:
1559: hr_utility.trace('2007 EMP_CONT ::: Initializing Main Table --------');
1560:
1561: -- initialize 7 rows of the main table g_tab_main
1562: ------------------------------------------------------------------------------------------------------
1563:

Line 1592: hr_utility.trace('2007 EMP_CONT ::: Finished Initializing Main Table --------');

1588:
1589:
1590: END LOOP; -- end loop for initializing g_tab_main
1591:
1592: hr_utility.trace('2007 EMP_CONT ::: Finished Initializing Main Table --------');
1593: ------------------------------------------------------------------------------------------------------
1594:
1595: l_run_base := 0;
1596: l_unallocated_cont := 0;

Line 1601: hr_utility.trace('2007 EMP_CONT ::: Main Calc Entered--------' );

1597:
1598: start_index_calc := NVL (g_tab_calc.FIRST, 0) ;
1599: end_index_calc := NVL (g_tab_calc.LAST, 0) ;
1600:
1601: hr_utility.trace('2007 EMP_CONT ::: Main Calc Entered--------' );
1602: hr_utility.trace('2007 EMP_CONT ::: Main Calc i -- p_org_status - zone -- under_limit -- l_rate = -- bimonth_base -- bimonth_cont -- bimonth_todate -- run_cont ' );
1603:
1604: FOR i IN start_index_calc..end_index_calc LOOP
1605:

Line 1602: hr_utility.trace('2007 EMP_CONT ::: Main Calc i -- p_org_status - zone -- under_limit -- l_rate = -- bimonth_base -- bimonth_cont -- bimonth_todate -- run_cont ' );

1598: start_index_calc := NVL (g_tab_calc.FIRST, 0) ;
1599: end_index_calc := NVL (g_tab_calc.LAST, 0) ;
1600:
1601: hr_utility.trace('2007 EMP_CONT ::: Main Calc Entered--------' );
1602: hr_utility.trace('2007 EMP_CONT ::: Main Calc i -- p_org_status - zone -- under_limit -- l_rate = -- bimonth_base -- bimonth_cont -- bimonth_todate -- run_cont ' );
1603:
1604: FOR i IN start_index_calc..end_index_calc LOOP
1605:
1606: l_rate := PAY_NO_EMP_CONT_2007.get_ec_rate (g_tab_calc(i).zone

Line 1630: hr_utility.trace('2007 EMP_CONT ::: Main Calc '||i

1626: THEN
1627: l_unallocated_cont := l_unallocated_cont + g_tab_calc(i).run_contribution ;
1628: END IF;
1629:
1630: hr_utility.trace('2007 EMP_CONT ::: Main Calc '||i
1631: ||' '||p_org_status
1632: ||' '||g_tab_calc(i).zone
1633: ||' '||g_tab_calc(i).under_limit
1634: ||' '||l_rate

Line 1642: hr_utility.trace('2007 EMP_CONT ::: Main Calc --- exited from Main calc loop' );

1638: ||' '||g_tab_calc(i).run_contribution );
1639:
1640: END LOOP;
1641:
1642: hr_utility.trace('2007 EMP_CONT ::: Main Calc --- exited from Main calc loop' );
1643: hr_utility.trace('2007 EMP_CONT ::: Main Calc l_run_base = '|| l_run_base );
1644: hr_utility.trace('2007 EMP_CONT ::: Main Calc l_unallocated_cont = '|| l_unallocated_cont );
1645:
1646: -- re-allocating the run_contributions that can be allocated

Line 1643: hr_utility.trace('2007 EMP_CONT ::: Main Calc l_run_base = '|| l_run_base );

1639:
1640: END LOOP;
1641:
1642: hr_utility.trace('2007 EMP_CONT ::: Main Calc --- exited from Main calc loop' );
1643: hr_utility.trace('2007 EMP_CONT ::: Main Calc l_run_base = '|| l_run_base );
1644: hr_utility.trace('2007 EMP_CONT ::: Main Calc l_unallocated_cont = '|| l_unallocated_cont );
1645:
1646: -- re-allocating the run_contributions that can be allocated
1647: -- and also summing the values to get the final values

Line 1644: hr_utility.trace('2007 EMP_CONT ::: Main Calc l_unallocated_cont = '|| l_unallocated_cont );

1640: END LOOP;
1641:
1642: hr_utility.trace('2007 EMP_CONT ::: Main Calc --- exited from Main calc loop' );
1643: hr_utility.trace('2007 EMP_CONT ::: Main Calc l_run_base = '|| l_run_base );
1644: hr_utility.trace('2007 EMP_CONT ::: Main Calc l_unallocated_cont = '|| l_unallocated_cont );
1645:
1646: -- re-allocating the run_contributions that can be allocated
1647: -- and also summing the values to get the final values
1648:

Line 1649: hr_utility.trace('2007 EMP_CONT ::: Main Calc --- entered loop for re-allocation and summing up values' );

1645:
1646: -- re-allocating the run_contributions that can be allocated
1647: -- and also summing the values to get the final values
1648:
1649: hr_utility.trace('2007 EMP_CONT ::: Main Calc --- entered loop for re-allocation and summing up values' );
1650:
1651: FOR i IN start_index_calc..end_index_calc LOOP
1652:
1653: -- to handle the error of division by zero

Line 1669: hr_utility.trace('2007 EMP_CONT ::: Main Calc '||i

1665: l_extra_run_cont := 0 ;
1666:
1667: END IF;
1668:
1669: hr_utility.trace('2007 EMP_CONT ::: Main Calc '||i
1670: ||' '||g_tab_calc(i).run_base
1671: ||' '||l_run_base
1672: ||' '||l_unallocated_cont
1673: ||' '||l_extra_run_cont

Line 1687: hr_utility.trace('2007 EMP_CONT ::: Main Calc --- leaving loop for re-allocation and summing up values' );

1683: g_tab_main(l_curr_index).run_contribution := g_tab_main(l_curr_index).run_contribution + g_tab_calc(i).run_contribution ;
1684:
1685: END LOOP;
1686:
1687: hr_utility.trace('2007 EMP_CONT ::: Main Calc --- leaving loop for re-allocation and summing up values' );
1688:
1689: hr_utility.trace('2007 EMP_CONT ::: Main Calc Leaving--------' );
1690:
1691: RETURN l_main_index ;

Line 1689: hr_utility.trace('2007 EMP_CONT ::: Main Calc Leaving--------' );

1685: END LOOP;
1686:
1687: hr_utility.trace('2007 EMP_CONT ::: Main Calc --- leaving loop for re-allocation and summing up values' );
1688:
1689: hr_utility.trace('2007 EMP_CONT ::: Main Calc Leaving--------' );
1690:
1691: RETURN l_main_index ;
1692:
1693: END ec_main_calculation ;

Line 1819: hr_utility.trace('2007 EMP_CONT ::: ---------- Displaying g_tab_calc table data ----------------------');

1815:
1816: start_index_calc := NVL (g_tab_calc.FIRST, 0) ;
1817: end_index_calc := NVL (g_tab_calc.LAST, 0) ;
1818:
1819: hr_utility.trace('2007 EMP_CONT ::: ---------- Displaying g_tab_calc table data ----------------------');
1820: hr_utility.trace('2007 EMP_CONT ::: zone -- under_limit -- status -- bimonth_base -- run_base -- bimonth_cont -- bimonth_cont_todate -- run_cont ');
1821:
1822: FOR i IN start_index_calc..end_index_calc LOOP
1823:

Line 1820: hr_utility.trace('2007 EMP_CONT ::: zone -- under_limit -- status -- bimonth_base -- run_base -- bimonth_cont -- bimonth_cont_todate -- run_cont ');

1816: start_index_calc := NVL (g_tab_calc.FIRST, 0) ;
1817: end_index_calc := NVL (g_tab_calc.LAST, 0) ;
1818:
1819: hr_utility.trace('2007 EMP_CONT ::: ---------- Displaying g_tab_calc table data ----------------------');
1820: hr_utility.trace('2007 EMP_CONT ::: zone -- under_limit -- status -- bimonth_base -- run_base -- bimonth_cont -- bimonth_cont_todate -- run_cont ');
1821:
1822: FOR i IN start_index_calc..end_index_calc LOOP
1823:
1824: hr_utility.trace('2007 EMP_CONT ::: '

Line 1824: hr_utility.trace('2007 EMP_CONT ::: '

1820: hr_utility.trace('2007 EMP_CONT ::: zone -- under_limit -- status -- bimonth_base -- run_base -- bimonth_cont -- bimonth_cont_todate -- run_cont ');
1821:
1822: FOR i IN start_index_calc..end_index_calc LOOP
1823:
1824: hr_utility.trace('2007 EMP_CONT ::: '
1825: ||' '||g_tab_calc(i).zone
1826: ||' '||g_tab_calc(i).under_limit
1827: ||' '||g_tab_calc(i).status
1828: ||' '||g_tab_calc(i).bimonth_base

Line 1835: hr_utility.trace('2007 EMP_CONT ::: ---------- Displayed g_tab_calc table data , exiting function ----------------------');

1831: ||' '||g_tab_calc(i).bimonth_contribution_todate
1832: ||' '||g_tab_calc(i).run_contribution );
1833:
1834: END LOOP;
1835: hr_utility.trace('2007 EMP_CONT ::: ---------- Displayed g_tab_calc table data , exiting function ----------------------');
1836:
1837: RETURN 1 ;
1838:
1839: END display_table_calc ;

Line 1924: hr_utility.trace('2007 EMP_CONT ::: p_date_earned = '||p_date_earned);

1920: l_start_of_year := trunc(p_date_earned, 'Y');
1921:
1922: l_cum_base_rate_value := 0 ;
1923:
1924: hr_utility.trace('2007 EMP_CONT ::: p_date_earned = '||p_date_earned);
1925: hr_utility.trace('2007 EMP_CONT ::: l_start_of_year = '||l_start_of_year);
1926: hr_utility.trace('2007 EMP_CONT ::: l_end_of_year = '||l_end_of_year);
1927: hr_utility.trace('2007 EMP_CONT ::: ========================================= ');
1928:

Line 1925: hr_utility.trace('2007 EMP_CONT ::: l_start_of_year = '||l_start_of_year);

1921:
1922: l_cum_base_rate_value := 0 ;
1923:
1924: hr_utility.trace('2007 EMP_CONT ::: p_date_earned = '||p_date_earned);
1925: hr_utility.trace('2007 EMP_CONT ::: l_start_of_year = '||l_start_of_year);
1926: hr_utility.trace('2007 EMP_CONT ::: l_end_of_year = '||l_end_of_year);
1927: hr_utility.trace('2007 EMP_CONT ::: ========================================= ');
1928:
1929: -- Bug Fix 5566622 : Value of G (National Insurance Base Rate) to be taken from Global and not user table.

Line 1926: hr_utility.trace('2007 EMP_CONT ::: l_end_of_year = '||l_end_of_year);

1922: l_cum_base_rate_value := 0 ;
1923:
1924: hr_utility.trace('2007 EMP_CONT ::: p_date_earned = '||p_date_earned);
1925: hr_utility.trace('2007 EMP_CONT ::: l_start_of_year = '||l_start_of_year);
1926: hr_utility.trace('2007 EMP_CONT ::: l_end_of_year = '||l_end_of_year);
1927: hr_utility.trace('2007 EMP_CONT ::: ========================================= ');
1928:
1929: -- Bug Fix 5566622 : Value of G (National Insurance Base Rate) to be taken from Global and not user table.
1930: -- modifying call for cursor csr_get_ni_base_rates

Line 1927: hr_utility.trace('2007 EMP_CONT ::: ========================================= ');

1923:
1924: hr_utility.trace('2007 EMP_CONT ::: p_date_earned = '||p_date_earned);
1925: hr_utility.trace('2007 EMP_CONT ::: l_start_of_year = '||l_start_of_year);
1926: hr_utility.trace('2007 EMP_CONT ::: l_end_of_year = '||l_end_of_year);
1927: hr_utility.trace('2007 EMP_CONT ::: ========================================= ');
1928:
1929: -- Bug Fix 5566622 : Value of G (National Insurance Base Rate) to be taken from Global and not user table.
1930: -- modifying call for cursor csr_get_ni_base_rates
1931:

Line 1943: hr_utility.trace('2007 EMP_CONT ::: OLD l_eff_start_date = '||l_eff_start_date);

1939: -- check if effective start date is before the starting of the year
1940:
1941: IF (l_eff_start_date < l_start_of_year)
1942: THEN
1943: hr_utility.trace('2007 EMP_CONT ::: OLD l_eff_start_date = '||l_eff_start_date);
1944: l_eff_start_date := l_start_of_year;
1945: hr_utility.trace('2007 EMP_CONT ::: NEW l_eff_start_date = '||l_eff_start_date);
1946: END IF;
1947:

Line 1945: hr_utility.trace('2007 EMP_CONT ::: NEW l_eff_start_date = '||l_eff_start_date);

1941: IF (l_eff_start_date < l_start_of_year)
1942: THEN
1943: hr_utility.trace('2007 EMP_CONT ::: OLD l_eff_start_date = '||l_eff_start_date);
1944: l_eff_start_date := l_start_of_year;
1945: hr_utility.trace('2007 EMP_CONT ::: NEW l_eff_start_date = '||l_eff_start_date);
1946: END IF;
1947:
1948: -- check if effective end date is after the end of the period
1949:

Line 1952: hr_utility.trace('2007 EMP_CONT ::: OLD l_eff_end_date = '||l_eff_end_date);

1948: -- check if effective end date is after the end of the period
1949:
1950: IF (l_eff_end_date > l_end_of_year)
1951: THEN
1952: hr_utility.trace('2007 EMP_CONT ::: OLD l_eff_end_date = '||l_eff_end_date);
1953: l_eff_end_date := l_end_of_year;
1954: hr_utility.trace('2007 EMP_CONT ::: NEW l_eff_end_date = '||l_eff_end_date);
1955: END IF;
1956:

Line 1954: hr_utility.trace('2007 EMP_CONT ::: NEW l_eff_end_date = '||l_eff_end_date);

1950: IF (l_eff_end_date > l_end_of_year)
1951: THEN
1952: hr_utility.trace('2007 EMP_CONT ::: OLD l_eff_end_date = '||l_eff_end_date);
1953: l_eff_end_date := l_end_of_year;
1954: hr_utility.trace('2007 EMP_CONT ::: NEW l_eff_end_date = '||l_eff_end_date);
1955: END IF;
1956:
1957: -- calculating the number of months the value is valid for
1958:

Line 1963: hr_utility.trace('2007 EMP_CONT ::: -------------- ');

1959: l_no_of_mths := months_between(l_eff_end_date , (l_eff_start_date -1) );
1960: l_cum_base_rate_value := l_cum_base_rate_value + (l_base_rate_value * l_no_of_mths) ;
1961:
1962:
1963: hr_utility.trace('2007 EMP_CONT ::: -------------- ');
1964: hr_utility.trace('2007 EMP_CONT ::: l_base_rate_value = '||l_base_rate_value);
1965: hr_utility.trace('2007 EMP_CONT ::: l_eff_start_date = '||l_eff_start_date);
1966: hr_utility.trace('2007 EMP_CONT ::: l_eff_end_date = '||l_eff_end_date);
1967: hr_utility.trace('2007 EMP_CONT ::: l_no_of_mths = '||l_no_of_mths);

Line 1964: hr_utility.trace('2007 EMP_CONT ::: l_base_rate_value = '||l_base_rate_value);

1960: l_cum_base_rate_value := l_cum_base_rate_value + (l_base_rate_value * l_no_of_mths) ;
1961:
1962:
1963: hr_utility.trace('2007 EMP_CONT ::: -------------- ');
1964: hr_utility.trace('2007 EMP_CONT ::: l_base_rate_value = '||l_base_rate_value);
1965: hr_utility.trace('2007 EMP_CONT ::: l_eff_start_date = '||l_eff_start_date);
1966: hr_utility.trace('2007 EMP_CONT ::: l_eff_end_date = '||l_eff_end_date);
1967: hr_utility.trace('2007 EMP_CONT ::: l_no_of_mths = '||l_no_of_mths);
1968: hr_utility.trace('2007 EMP_CONT ::: l_base_rate_value * l_no_of_mths = '||l_base_rate_value * l_no_of_mths);

Line 1965: hr_utility.trace('2007 EMP_CONT ::: l_eff_start_date = '||l_eff_start_date);

1961:
1962:
1963: hr_utility.trace('2007 EMP_CONT ::: -------------- ');
1964: hr_utility.trace('2007 EMP_CONT ::: l_base_rate_value = '||l_base_rate_value);
1965: hr_utility.trace('2007 EMP_CONT ::: l_eff_start_date = '||l_eff_start_date);
1966: hr_utility.trace('2007 EMP_CONT ::: l_eff_end_date = '||l_eff_end_date);
1967: hr_utility.trace('2007 EMP_CONT ::: l_no_of_mths = '||l_no_of_mths);
1968: hr_utility.trace('2007 EMP_CONT ::: l_base_rate_value * l_no_of_mths = '||l_base_rate_value * l_no_of_mths);
1969: hr_utility.trace('2007 EMP_CONT ::: l_cum_base_rate_value = '||l_cum_base_rate_value);

Line 1966: hr_utility.trace('2007 EMP_CONT ::: l_eff_end_date = '||l_eff_end_date);

1962:
1963: hr_utility.trace('2007 EMP_CONT ::: -------------- ');
1964: hr_utility.trace('2007 EMP_CONT ::: l_base_rate_value = '||l_base_rate_value);
1965: hr_utility.trace('2007 EMP_CONT ::: l_eff_start_date = '||l_eff_start_date);
1966: hr_utility.trace('2007 EMP_CONT ::: l_eff_end_date = '||l_eff_end_date);
1967: hr_utility.trace('2007 EMP_CONT ::: l_no_of_mths = '||l_no_of_mths);
1968: hr_utility.trace('2007 EMP_CONT ::: l_base_rate_value * l_no_of_mths = '||l_base_rate_value * l_no_of_mths);
1969: hr_utility.trace('2007 EMP_CONT ::: l_cum_base_rate_value = '||l_cum_base_rate_value);
1970: hr_utility.trace('2007 EMP_CONT ::: -------------- ');

Line 1967: hr_utility.trace('2007 EMP_CONT ::: l_no_of_mths = '||l_no_of_mths);

1963: hr_utility.trace('2007 EMP_CONT ::: -------------- ');
1964: hr_utility.trace('2007 EMP_CONT ::: l_base_rate_value = '||l_base_rate_value);
1965: hr_utility.trace('2007 EMP_CONT ::: l_eff_start_date = '||l_eff_start_date);
1966: hr_utility.trace('2007 EMP_CONT ::: l_eff_end_date = '||l_eff_end_date);
1967: hr_utility.trace('2007 EMP_CONT ::: l_no_of_mths = '||l_no_of_mths);
1968: hr_utility.trace('2007 EMP_CONT ::: l_base_rate_value * l_no_of_mths = '||l_base_rate_value * l_no_of_mths);
1969: hr_utility.trace('2007 EMP_CONT ::: l_cum_base_rate_value = '||l_cum_base_rate_value);
1970: hr_utility.trace('2007 EMP_CONT ::: -------------- ');
1971:

Line 1968: hr_utility.trace('2007 EMP_CONT ::: l_base_rate_value * l_no_of_mths = '||l_base_rate_value * l_no_of_mths);

1964: hr_utility.trace('2007 EMP_CONT ::: l_base_rate_value = '||l_base_rate_value);
1965: hr_utility.trace('2007 EMP_CONT ::: l_eff_start_date = '||l_eff_start_date);
1966: hr_utility.trace('2007 EMP_CONT ::: l_eff_end_date = '||l_eff_end_date);
1967: hr_utility.trace('2007 EMP_CONT ::: l_no_of_mths = '||l_no_of_mths);
1968: hr_utility.trace('2007 EMP_CONT ::: l_base_rate_value * l_no_of_mths = '||l_base_rate_value * l_no_of_mths);
1969: hr_utility.trace('2007 EMP_CONT ::: l_cum_base_rate_value = '||l_cum_base_rate_value);
1970: hr_utility.trace('2007 EMP_CONT ::: -------------- ');
1971:
1972: END LOOP; -- end cursor loop

Line 1969: hr_utility.trace('2007 EMP_CONT ::: l_cum_base_rate_value = '||l_cum_base_rate_value);

1965: hr_utility.trace('2007 EMP_CONT ::: l_eff_start_date = '||l_eff_start_date);
1966: hr_utility.trace('2007 EMP_CONT ::: l_eff_end_date = '||l_eff_end_date);
1967: hr_utility.trace('2007 EMP_CONT ::: l_no_of_mths = '||l_no_of_mths);
1968: hr_utility.trace('2007 EMP_CONT ::: l_base_rate_value * l_no_of_mths = '||l_base_rate_value * l_no_of_mths);
1969: hr_utility.trace('2007 EMP_CONT ::: l_cum_base_rate_value = '||l_cum_base_rate_value);
1970: hr_utility.trace('2007 EMP_CONT ::: -------------- ');
1971:
1972: END LOOP; -- end cursor loop
1973:

Line 1970: hr_utility.trace('2007 EMP_CONT ::: -------------- ');

1966: hr_utility.trace('2007 EMP_CONT ::: l_eff_end_date = '||l_eff_end_date);
1967: hr_utility.trace('2007 EMP_CONT ::: l_no_of_mths = '||l_no_of_mths);
1968: hr_utility.trace('2007 EMP_CONT ::: l_base_rate_value * l_no_of_mths = '||l_base_rate_value * l_no_of_mths);
1969: hr_utility.trace('2007 EMP_CONT ::: l_cum_base_rate_value = '||l_cum_base_rate_value);
1970: hr_utility.trace('2007 EMP_CONT ::: -------------- ');
1971:
1972: END LOOP; -- end cursor loop
1973:
1974: l_avg_base_rate_value := l_cum_base_rate_value / 12 ;

Line 1976: hr_utility.trace('2007 EMP_CONT ::: =================================================== ');

1972: END LOOP; -- end cursor loop
1973:
1974: l_avg_base_rate_value := l_cum_base_rate_value / 12 ;
1975:
1976: hr_utility.trace('2007 EMP_CONT ::: =================================================== ');
1977: hr_utility.trace('2007 EMP_CONT ::: l_cum_base_rate_value = '||l_cum_base_rate_value);
1978: hr_utility.trace('2007 EMP_CONT ::: l_avg_base_rate_value = '||l_avg_base_rate_value);
1979: hr_utility.trace('2007 EMP_CONT ::: ---------------- OVER ---------------- ');
1980:

Line 1977: hr_utility.trace('2007 EMP_CONT ::: l_cum_base_rate_value = '||l_cum_base_rate_value);

1973:
1974: l_avg_base_rate_value := l_cum_base_rate_value / 12 ;
1975:
1976: hr_utility.trace('2007 EMP_CONT ::: =================================================== ');
1977: hr_utility.trace('2007 EMP_CONT ::: l_cum_base_rate_value = '||l_cum_base_rate_value);
1978: hr_utility.trace('2007 EMP_CONT ::: l_avg_base_rate_value = '||l_avg_base_rate_value);
1979: hr_utility.trace('2007 EMP_CONT ::: ---------------- OVER ---------------- ');
1980:
1981:

Line 1978: hr_utility.trace('2007 EMP_CONT ::: l_avg_base_rate_value = '||l_avg_base_rate_value);

1974: l_avg_base_rate_value := l_cum_base_rate_value / 12 ;
1975:
1976: hr_utility.trace('2007 EMP_CONT ::: =================================================== ');
1977: hr_utility.trace('2007 EMP_CONT ::: l_cum_base_rate_value = '||l_cum_base_rate_value);
1978: hr_utility.trace('2007 EMP_CONT ::: l_avg_base_rate_value = '||l_avg_base_rate_value);
1979: hr_utility.trace('2007 EMP_CONT ::: ---------------- OVER ---------------- ');
1980:
1981:
1982: RETURN l_avg_base_rate_value ;

Line 1979: hr_utility.trace('2007 EMP_CONT ::: ---------------- OVER ---------------- ');

1975:
1976: hr_utility.trace('2007 EMP_CONT ::: =================================================== ');
1977: hr_utility.trace('2007 EMP_CONT ::: l_cum_base_rate_value = '||l_cum_base_rate_value);
1978: hr_utility.trace('2007 EMP_CONT ::: l_avg_base_rate_value = '||l_avg_base_rate_value);
1979: hr_utility.trace('2007 EMP_CONT ::: ---------------- OVER ---------------- ');
1980:
1981:
1982: RETURN l_avg_base_rate_value ;
1983:

Line 2039: hr_utility.trace('2007 EXEM_LIM ::: Entered the procedure for exemption limit ');

2035: l_economic_aid NUMBER;
2036:
2037: BEGIN
2038:
2039: hr_utility.trace('2007 EXEM_LIM ::: Entered the procedure for exemption limit ');
2040: --p_err_text := '';
2041:
2042: IF ( g_error_flag = TRUE )
2043:

Line 2045: hr_utility.trace('2007 EXEM_LIM ::: g_error_flag = TRUE , returning 1' );

2041:
2042: IF ( g_error_flag = TRUE )
2043:
2044: THEN
2045: hr_utility.trace('2007 EXEM_LIM ::: g_error_flag = TRUE , returning 1' );
2046: RETURN 1 ; -- error has occured already , return 1 to formula funnction and from there just RETURN
2047:
2048: ELSIF ( g_error_check = TRUE )
2049:

Line 2051: hr_utility.trace('2007 EXEM_LIM ::: g_error_flag = FALE but g_error_check = TRUE , returning 0' );

2047:
2048: ELSIF ( g_error_check = TRUE )
2049:
2050: THEN
2051: hr_utility.trace('2007 EXEM_LIM ::: g_error_flag = FALE but g_error_check = TRUE , returning 0' );
2052: RETURN 0 ; -- checking has been done but no error is there , return 0 to formula function , continue processing
2053:
2054: ELSE -- the error condition has not been checked yet
2055:

Line 2056: hr_utility.trace('2007 EXEM_LIM ::: both globals are false , nocheck has been performed ');

2052: RETURN 0 ; -- checking has been done but no error is there , return 0 to formula function , continue processing
2053:
2054: ELSE -- the error condition has not been checked yet
2055:
2056: hr_utility.trace('2007 EXEM_LIM ::: both globals are false , nocheck has been performed ');
2057: -- since we are checking the condition now , set the check global to TRUE
2058: g_error_check := TRUE ;
2059: hr_utility.trace('2007 EXEM_LIM ::: made g_error_check := TRUE ');
2060:

Line 2059: hr_utility.trace('2007 EXEM_LIM ::: made g_error_check := TRUE ');

2055:
2056: hr_utility.trace('2007 EXEM_LIM ::: both globals are false , nocheck has been performed ');
2057: -- since we are checking the condition now , set the check global to TRUE
2058: g_error_check := TRUE ;
2059: hr_utility.trace('2007 EXEM_LIM ::: made g_error_check := TRUE ');
2060:
2061: -- loop thru the cursor csr_get_lu_le and get all LE and LU
2062:
2063: FOR csr_rec in PAY_NO_EMP_CONT_2007.csr_get_lu_le (p_payroll_action_id ,p_date_earned ) LOOP

Line 2065: hr_utility.trace('2007 EXEM_LIM ::: ------------------Inside For loop------------- ' );

2061: -- loop thru the cursor csr_get_lu_le and get all LE and LU
2062:
2063: FOR csr_rec in PAY_NO_EMP_CONT_2007.csr_get_lu_le (p_payroll_action_id ,p_date_earned ) LOOP
2064:
2065: hr_utility.trace('2007 EXEM_LIM ::: ------------------Inside For loop------------- ' );
2066: hr_utility.trace('2007 EXEM_LIM ::: Local unit id = '||csr_rec.loc_unit ||' Legal Employer ID = '||csr_rec.leg_emp );
2067: -- get the status and report separately for the LU
2068:
2069: OPEN PAY_NO_EMP_CONT_2007.get_lu_details (csr_rec.loc_unit);

Line 2066: hr_utility.trace('2007 EXEM_LIM ::: Local unit id = '||csr_rec.loc_unit ||' Legal Employer ID = '||csr_rec.leg_emp );

2062:
2063: FOR csr_rec in PAY_NO_EMP_CONT_2007.csr_get_lu_le (p_payroll_action_id ,p_date_earned ) LOOP
2064:
2065: hr_utility.trace('2007 EXEM_LIM ::: ------------------Inside For loop------------- ' );
2066: hr_utility.trace('2007 EXEM_LIM ::: Local unit id = '||csr_rec.loc_unit ||' Legal Employer ID = '||csr_rec.leg_emp );
2067: -- get the status and report separately for the LU
2068:
2069: OPEN PAY_NO_EMP_CONT_2007.get_lu_details (csr_rec.loc_unit);
2070: FETCH PAY_NO_EMP_CONT_2007.get_lu_details INTO l_status , l_rep_sep , l_lu_tax_mun ;

Line 2073: hr_utility.trace('2007 EXEM_LIM ::: l_status '|| l_status );

2069: OPEN PAY_NO_EMP_CONT_2007.get_lu_details (csr_rec.loc_unit);
2070: FETCH PAY_NO_EMP_CONT_2007.get_lu_details INTO l_status , l_rep_sep , l_lu_tax_mun ;
2071: CLOSE PAY_NO_EMP_CONT_2007.get_lu_details ;
2072:
2073: hr_utility.trace('2007 EXEM_LIM ::: l_status '|| l_status );
2074: hr_utility.trace('2007 EXEM_LIM ::: l_rep_sep '||l_rep_sep );
2075:
2076: -- if report separately = yes and status in AA,CC,GG
2077: IF ( trim(l_rep_sep) = 'Y' ) AND ( l_status IN ('AA','CC','GG') )

Line 2074: hr_utility.trace('2007 EXEM_LIM ::: l_rep_sep '||l_rep_sep );

2070: FETCH PAY_NO_EMP_CONT_2007.get_lu_details INTO l_status , l_rep_sep , l_lu_tax_mun ;
2071: CLOSE PAY_NO_EMP_CONT_2007.get_lu_details ;
2072:
2073: hr_utility.trace('2007 EXEM_LIM ::: l_status '|| l_status );
2074: hr_utility.trace('2007 EXEM_LIM ::: l_rep_sep '||l_rep_sep );
2075:
2076: -- if report separately = yes and status in AA,CC,GG
2077: IF ( trim(l_rep_sep) = 'Y' ) AND ( l_status IN ('AA','CC','GG') )
2078:

Line 2080: hr_utility.trace('2007 EXEM_LIM ::: local unit is rep sep and status in AA,CC,GG....fetching exemption limit ');

2076: -- if report separately = yes and status in AA,CC,GG
2077: IF ( trim(l_rep_sep) = 'Y' ) AND ( l_status IN ('AA','CC','GG') )
2078:
2079: THEN
2080: hr_utility.trace('2007 EXEM_LIM ::: local unit is rep sep and status in AA,CC,GG....fetching exemption limit ');
2081: -- then open exemption limit cursor
2082: OPEN PAY_NO_EMP_CONT_2007.csr_get_exemption_limit (csr_rec.loc_unit, p_date_earned) ;
2083:
2084: -- 2007 Legislative changes for 'Economic Aid' to Employer

Line 2092: hr_utility.trace('2007 EXEM_LIM ::: Problem in getting Exemption limit ' );

2088: -- if any error is there
2089: -- checking if no data returned for Exemption Limit
2090: IF (PAY_NO_EMP_CONT_2007.csr_get_exemption_limit%NOTFOUND OR l_exempt_limit IS NULL)
2091: THEN
2092: hr_utility.trace('2007 EXEM_LIM ::: Problem in getting Exemption limit ' );
2093: -- Exemption Limit for this Local Unit Not Specified for this Period or not specified at all
2094:
2095: -- get global error flag to TRUE
2096: g_error_flag := TRUE ;

Line 2097: hr_utility.trace('2007 EXEM_LIM ::: set g_error_flag = TRUE ');

2093: -- Exemption Limit for this Local Unit Not Specified for this Period or not specified at all
2094:
2095: -- get global error flag to TRUE
2096: g_error_flag := TRUE ;
2097: hr_utility.trace('2007 EXEM_LIM ::: set g_error_flag = TRUE ');
2098:
2099: -- get the name of the local unit
2100: OPEN PAY_NO_EMP_CONT_2007.csr_org_name(csr_rec.loc_unit ,p_bus_grp_id );
2101: FETCH PAY_NO_EMP_CONT_2007.csr_org_name INTO l_org_name ;

Line 2104: hr_utility.trace('2007 EXEM_LIM ::: name of local unit = '|| l_org_name );

2100: OPEN PAY_NO_EMP_CONT_2007.csr_org_name(csr_rec.loc_unit ,p_bus_grp_id );
2101: FETCH PAY_NO_EMP_CONT_2007.csr_org_name INTO l_org_name ;
2102: CLOSE PAY_NO_EMP_CONT_2007.csr_org_name;
2103:
2104: hr_utility.trace('2007 EXEM_LIM ::: name of local unit = '|| l_org_name );
2105:
2106: -- Set the message and message token
2107: hr_utility.set_message (801, 'PAY_376856_NO_LU_NO_EXEM_LIMIT');
2108: hr_utility.set_message_token (801, 'ORG_NAME', l_org_name);

Line 2107: hr_utility.set_message (801, 'PAY_376856_NO_LU_NO_EXEM_LIMIT');

2103:
2104: hr_utility.trace('2007 EXEM_LIM ::: name of local unit = '|| l_org_name );
2105:
2106: -- Set the message and message token
2107: hr_utility.set_message (801, 'PAY_376856_NO_LU_NO_EXEM_LIMIT');
2108: hr_utility.set_message_token (801, 'ORG_NAME', l_org_name);
2109:
2110: hr_utility.trace('2007 EXEM_LIM ::: set the message = '||hr_utility.get_message );
2111:

Line 2108: hr_utility.set_message_token (801, 'ORG_NAME', l_org_name);

2104: hr_utility.trace('2007 EXEM_LIM ::: name of local unit = '|| l_org_name );
2105:
2106: -- Set the message and message token
2107: hr_utility.set_message (801, 'PAY_376856_NO_LU_NO_EXEM_LIMIT');
2108: hr_utility.set_message_token (801, 'ORG_NAME', l_org_name);
2109:
2110: hr_utility.trace('2007 EXEM_LIM ::: set the message = '||hr_utility.get_message );
2111:
2112: -- Put the meassage in the log file

Line 2110: hr_utility.trace('2007 EXEM_LIM ::: set the message = '||hr_utility.get_message );

2106: -- Set the message and message token
2107: hr_utility.set_message (801, 'PAY_376856_NO_LU_NO_EXEM_LIMIT');
2108: hr_utility.set_message_token (801, 'ORG_NAME', l_org_name);
2109:
2110: hr_utility.trace('2007 EXEM_LIM ::: set the message = '||hr_utility.get_message );
2111:
2112: -- Put the meassage in the log file
2113: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
2114:

Line 2113: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);

2109:
2110: hr_utility.trace('2007 EXEM_LIM ::: set the message = '||hr_utility.get_message );
2111:
2112: -- Put the meassage in the log file
2113: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
2114:
2115: hr_utility.trace('2007 EXEM_LIM ::: put the msg in the log file ');
2116:
2117: -- p_err_text := p_err_text || hr_utility.get_message ;

Line 2115: hr_utility.trace('2007 EXEM_LIM ::: put the msg in the log file ');

2111:
2112: -- Put the meassage in the log file
2113: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
2114:
2115: hr_utility.trace('2007 EXEM_LIM ::: put the msg in the log file ');
2116:
2117: -- p_err_text := p_err_text || hr_utility.get_message ;
2118:
2119: END IF; -- end exemption limit got check

Line 2117: -- p_err_text := p_err_text || hr_utility.get_message ;

2113: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
2114:
2115: hr_utility.trace('2007 EXEM_LIM ::: put the msg in the log file ');
2116:
2117: -- p_err_text := p_err_text || hr_utility.get_message ;
2118:
2119: END IF; -- end exemption limit got check
2120:
2121: CLOSE PAY_NO_EMP_CONT_2007.csr_get_exemption_limit;

Line 2126: hr_utility.trace('2007 EXEM_LIM ::: local unit is NOT rep sep....fetching LE Status ');

2122:
2123: ELSIF ( trim(l_rep_sep) = 'N' ) -- else if LU is not rep sep , check at the legal employer level
2124:
2125: THEN
2126: hr_utility.trace('2007 EXEM_LIM ::: local unit is NOT rep sep....fetching LE Status ');
2127: -- get the status of the LE
2128: OPEN PAY_NO_EMP_CONT_2007.get_le_status (csr_rec.leg_emp) ;
2129: FETCH PAY_NO_EMP_CONT_2007.get_le_status INTO l_status ;
2130: CLOSE PAY_NO_EMP_CONT_2007.get_le_status ;

Line 2132: hr_utility.trace('2007 EXEM_LIM ::: LE l_status '|| l_status );

2128: OPEN PAY_NO_EMP_CONT_2007.get_le_status (csr_rec.leg_emp) ;
2129: FETCH PAY_NO_EMP_CONT_2007.get_le_status INTO l_status ;
2130: CLOSE PAY_NO_EMP_CONT_2007.get_le_status ;
2131:
2132: hr_utility.trace('2007 EXEM_LIM ::: LE l_status '|| l_status );
2133:
2134: -- if the status of LE in AA,CC,GG
2135: IF ( l_status IN ('AA','CC','GG') )
2136: THEN

Line 2137: hr_utility.trace('2007 EXEM_LIM ::: Legal Emp status in AA,CC,GG ....fetching exemption limit ');

2133:
2134: -- if the status of LE in AA,CC,GG
2135: IF ( l_status IN ('AA','CC','GG') )
2136: THEN
2137: hr_utility.trace('2007 EXEM_LIM ::: Legal Emp status in AA,CC,GG ....fetching exemption limit ');
2138: -- then open exemption limit cursor
2139: OPEN PAY_NO_EMP_CONT_2007.csr_get_exemption_limit (csr_rec.leg_emp, p_date_earned) ;
2140:
2141: -- 2007 Legislative changes for 'Economic Aid' to Employer

Line 2149: hr_utility.trace('2007 EXEM_LIM ::: Problem in getting Exemption limit ' );

2145: -- if any error is there
2146: -- checking if no data returned for Exemption Limit
2147: IF (PAY_NO_EMP_CONT_2007.csr_get_exemption_limit%NOTFOUND OR l_exempt_limit IS NULL)
2148: THEN
2149: hr_utility.trace('2007 EXEM_LIM ::: Problem in getting Exemption limit ' );
2150: -- Exemption Limit for this Legal Emplyer Not Specified for this Period or not specified at all
2151:
2152: -- get global error flag to TRUE
2153: g_error_flag := TRUE ;

Line 2154: hr_utility.trace('2007 EXEM_LIM ::: set g_error_flag = TRUE ');

2150: -- Exemption Limit for this Legal Emplyer Not Specified for this Period or not specified at all
2151:
2152: -- get global error flag to TRUE
2153: g_error_flag := TRUE ;
2154: hr_utility.trace('2007 EXEM_LIM ::: set g_error_flag = TRUE ');
2155:
2156: -- get the name of the Legal Employer
2157: OPEN PAY_NO_EMP_CONT_2007.csr_org_name(csr_rec.leg_emp ,p_bus_grp_id );
2158: FETCH PAY_NO_EMP_CONT_2007.csr_org_name INTO l_org_name ;

Line 2161: hr_utility.trace('2007 EXEM_LIM ::: name of legal employer = '|| l_org_name );

2157: OPEN PAY_NO_EMP_CONT_2007.csr_org_name(csr_rec.leg_emp ,p_bus_grp_id );
2158: FETCH PAY_NO_EMP_CONT_2007.csr_org_name INTO l_org_name ;
2159: CLOSE PAY_NO_EMP_CONT_2007.csr_org_name;
2160:
2161: hr_utility.trace('2007 EXEM_LIM ::: name of legal employer = '|| l_org_name );
2162:
2163: -- Set the message and message token
2164: hr_utility.set_message (801, 'PAY_376857_NO_LE_NO_EXEM_LIMIT');
2165: hr_utility.set_message_token (801, 'ORG_NAME', l_org_name);

Line 2164: hr_utility.set_message (801, 'PAY_376857_NO_LE_NO_EXEM_LIMIT');

2160:
2161: hr_utility.trace('2007 EXEM_LIM ::: name of legal employer = '|| l_org_name );
2162:
2163: -- Set the message and message token
2164: hr_utility.set_message (801, 'PAY_376857_NO_LE_NO_EXEM_LIMIT');
2165: hr_utility.set_message_token (801, 'ORG_NAME', l_org_name);
2166: hr_utility.trace('2007 EXEM_LIM ::: set the message = '||hr_utility.get_message );
2167:
2168: -- Put the meassage in the log file

Line 2165: hr_utility.set_message_token (801, 'ORG_NAME', l_org_name);

2161: hr_utility.trace('2007 EXEM_LIM ::: name of legal employer = '|| l_org_name );
2162:
2163: -- Set the message and message token
2164: hr_utility.set_message (801, 'PAY_376857_NO_LE_NO_EXEM_LIMIT');
2165: hr_utility.set_message_token (801, 'ORG_NAME', l_org_name);
2166: hr_utility.trace('2007 EXEM_LIM ::: set the message = '||hr_utility.get_message );
2167:
2168: -- Put the meassage in the log file
2169: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);

Line 2166: hr_utility.trace('2007 EXEM_LIM ::: set the message = '||hr_utility.get_message );

2162:
2163: -- Set the message and message token
2164: hr_utility.set_message (801, 'PAY_376857_NO_LE_NO_EXEM_LIMIT');
2165: hr_utility.set_message_token (801, 'ORG_NAME', l_org_name);
2166: hr_utility.trace('2007 EXEM_LIM ::: set the message = '||hr_utility.get_message );
2167:
2168: -- Put the meassage in the log file
2169: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
2170: hr_utility.trace('2007 EXEM_LIM ::: put the msg in the log file ');

Line 2169: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);

2165: hr_utility.set_message_token (801, 'ORG_NAME', l_org_name);
2166: hr_utility.trace('2007 EXEM_LIM ::: set the message = '||hr_utility.get_message );
2167:
2168: -- Put the meassage in the log file
2169: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
2170: hr_utility.trace('2007 EXEM_LIM ::: put the msg in the log file ');
2171:
2172: -- p_err_text := p_err_text || hr_utility.get_message ;
2173:

Line 2170: hr_utility.trace('2007 EXEM_LIM ::: put the msg in the log file ');

2166: hr_utility.trace('2007 EXEM_LIM ::: set the message = '||hr_utility.get_message );
2167:
2168: -- Put the meassage in the log file
2169: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
2170: hr_utility.trace('2007 EXEM_LIM ::: put the msg in the log file ');
2171:
2172: -- p_err_text := p_err_text || hr_utility.get_message ;
2173:
2174: END IF; -- end exemption limit got check

Line 2172: -- p_err_text := p_err_text || hr_utility.get_message ;

2168: -- Put the meassage in the log file
2169: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
2170: hr_utility.trace('2007 EXEM_LIM ::: put the msg in the log file ');
2171:
2172: -- p_err_text := p_err_text || hr_utility.get_message ;
2173:
2174: END IF; -- end exemption limit got check
2175:
2176: CLOSE PAY_NO_EMP_CONT_2007.csr_get_exemption_limit;

Line 2184: hr_utility.trace('2007 EXEM_LIM ::: **** end of loop * ');

2180: END IF ; -- end if report separately = yes and status in AA,CC,GG
2181:
2182: END LOOP; -- end loop thru the cursor csr_get_lu_le and get all LE and LU
2183:
2184: hr_utility.trace('2007 EXEM_LIM ::: **************** end of loop ************* ');
2185:
2186: hr_utility.trace('2007 EXEM_LIM ::: final error check ');
2187:
2188: -- finally check if any error did occur

Line 2186: hr_utility.trace('2007 EXEM_LIM ::: final error check ');

2182: END LOOP; -- end loop thru the cursor csr_get_lu_le and get all LE and LU
2183:
2184: hr_utility.trace('2007 EXEM_LIM ::: **************** end of loop ************* ');
2185:
2186: hr_utility.trace('2007 EXEM_LIM ::: final error check ');
2187:
2188: -- finally check if any error did occur
2189: IF ( g_error_flag = TRUE )
2190: THEN

Line 2191: hr_utility.trace('2007 EXEM_LIM ::: g_error_flag = TRUE , returning 1 ');

2187:
2188: -- finally check if any error did occur
2189: IF ( g_error_flag = TRUE )
2190: THEN
2191: hr_utility.trace('2007 EXEM_LIM ::: g_error_flag = TRUE , returning 1 ');
2192: RETURN 1 ; -- error did occur
2193: ELSE
2194: hr_utility.trace('2007 EXEM_LIM ::: g_error_flag = FALSE , returning 1 ');
2195: RETURN 0 ; -- error didnot occur

Line 2194: hr_utility.trace('2007 EXEM_LIM ::: g_error_flag = FALSE , returning 1 ');

2190: THEN
2191: hr_utility.trace('2007 EXEM_LIM ::: g_error_flag = TRUE , returning 1 ');
2192: RETURN 1 ; -- error did occur
2193: ELSE
2194: hr_utility.trace('2007 EXEM_LIM ::: g_error_flag = FALSE , returning 1 ');
2195: RETURN 0 ; -- error didnot occur
2196:
2197: END IF; -- end final check for error
2198: