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.

APPS.PAY_NO_EMP_CONT dependencies on HR_UTILITY

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

198: --------------- Begin -------------------------------------
199:
200: BEGIN
201:
202: -- hr_utility.trace_on(null,'NOEC');
203: hr_utility.trace('EMP_CONT ::: Enterd procedure GET_EMPLOYER_DEDUCTION ----------------------------------');
204: hr_utility.trace('EMP_CONT ::: -------------------------------------------------');
205: hr_utility.trace('EMP_CONT ::: p_tax_unit_id = '|| p_tax_unit_id );
206: hr_utility.trace('EMP_CONT ::: p_local_unit_id = '|| p_local_unit_id );

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

199:
200: BEGIN
201:
202: -- hr_utility.trace_on(null,'NOEC');
203: hr_utility.trace('EMP_CONT ::: Enterd procedure GET_EMPLOYER_DEDUCTION ----------------------------------');
204: hr_utility.trace('EMP_CONT ::: -------------------------------------------------');
205: hr_utility.trace('EMP_CONT ::: p_tax_unit_id = '|| p_tax_unit_id );
206: hr_utility.trace('EMP_CONT ::: p_local_unit_id = '|| p_local_unit_id );
207: hr_utility.trace('EMP_CONT ::: p_jurisdiction_code = '|| p_jurisdiction_code );

Line 204: hr_utility.trace('EMP_CONT ::: -------------------------------------------------');

200: BEGIN
201:
202: -- hr_utility.trace_on(null,'NOEC');
203: hr_utility.trace('EMP_CONT ::: Enterd procedure GET_EMPLOYER_DEDUCTION ----------------------------------');
204: hr_utility.trace('EMP_CONT ::: -------------------------------------------------');
205: hr_utility.trace('EMP_CONT ::: p_tax_unit_id = '|| p_tax_unit_id );
206: hr_utility.trace('EMP_CONT ::: p_local_unit_id = '|| p_local_unit_id );
207: hr_utility.trace('EMP_CONT ::: p_jurisdiction_code = '|| p_jurisdiction_code );
208: hr_utility.trace('EMP_CONT ::: p_payroll_id = '|| p_payroll_id );

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

201:
202: -- hr_utility.trace_on(null,'NOEC');
203: hr_utility.trace('EMP_CONT ::: Enterd procedure GET_EMPLOYER_DEDUCTION ----------------------------------');
204: hr_utility.trace('EMP_CONT ::: -------------------------------------------------');
205: hr_utility.trace('EMP_CONT ::: p_tax_unit_id = '|| p_tax_unit_id );
206: hr_utility.trace('EMP_CONT ::: p_local_unit_id = '|| p_local_unit_id );
207: hr_utility.trace('EMP_CONT ::: p_jurisdiction_code = '|| p_jurisdiction_code );
208: hr_utility.trace('EMP_CONT ::: p_payroll_id = '|| p_payroll_id );
209: hr_utility.trace('EMP_CONT ::: p_payroll_action_id = '|| p_payroll_action_id );

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

202: -- hr_utility.trace_on(null,'NOEC');
203: hr_utility.trace('EMP_CONT ::: Enterd procedure GET_EMPLOYER_DEDUCTION ----------------------------------');
204: hr_utility.trace('EMP_CONT ::: -------------------------------------------------');
205: hr_utility.trace('EMP_CONT ::: p_tax_unit_id = '|| p_tax_unit_id );
206: hr_utility.trace('EMP_CONT ::: p_local_unit_id = '|| p_local_unit_id );
207: hr_utility.trace('EMP_CONT ::: p_jurisdiction_code = '|| p_jurisdiction_code );
208: hr_utility.trace('EMP_CONT ::: p_payroll_id = '|| p_payroll_id );
209: hr_utility.trace('EMP_CONT ::: p_payroll_action_id = '|| p_payroll_action_id );
210: hr_utility.trace('EMP_CONT ::: p_asg_act_id = '|| p_asg_act_id );

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

203: hr_utility.trace('EMP_CONT ::: Enterd procedure GET_EMPLOYER_DEDUCTION ----------------------------------');
204: hr_utility.trace('EMP_CONT ::: -------------------------------------------------');
205: hr_utility.trace('EMP_CONT ::: p_tax_unit_id = '|| p_tax_unit_id );
206: hr_utility.trace('EMP_CONT ::: p_local_unit_id = '|| p_local_unit_id );
207: hr_utility.trace('EMP_CONT ::: p_jurisdiction_code = '|| p_jurisdiction_code );
208: hr_utility.trace('EMP_CONT ::: p_payroll_id = '|| p_payroll_id );
209: hr_utility.trace('EMP_CONT ::: p_payroll_action_id = '|| p_payroll_action_id );
210: hr_utility.trace('EMP_CONT ::: p_asg_act_id = '|| p_asg_act_id );
211: hr_utility.trace('EMP_CONT ::: p_bus_group_id = '|| p_bus_group_id );

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

204: hr_utility.trace('EMP_CONT ::: -------------------------------------------------');
205: hr_utility.trace('EMP_CONT ::: p_tax_unit_id = '|| p_tax_unit_id );
206: hr_utility.trace('EMP_CONT ::: p_local_unit_id = '|| p_local_unit_id );
207: hr_utility.trace('EMP_CONT ::: p_jurisdiction_code = '|| p_jurisdiction_code );
208: hr_utility.trace('EMP_CONT ::: p_payroll_id = '|| p_payroll_id );
209: hr_utility.trace('EMP_CONT ::: p_payroll_action_id = '|| p_payroll_action_id );
210: hr_utility.trace('EMP_CONT ::: p_asg_act_id = '|| p_asg_act_id );
211: hr_utility.trace('EMP_CONT ::: p_bus_group_id = '|| p_bus_group_id );
212: hr_utility.trace('EMP_CONT ::: p_date_earned = '|| p_date_earned );

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

205: hr_utility.trace('EMP_CONT ::: p_tax_unit_id = '|| p_tax_unit_id );
206: hr_utility.trace('EMP_CONT ::: p_local_unit_id = '|| p_local_unit_id );
207: hr_utility.trace('EMP_CONT ::: p_jurisdiction_code = '|| p_jurisdiction_code );
208: hr_utility.trace('EMP_CONT ::: p_payroll_id = '|| p_payroll_id );
209: hr_utility.trace('EMP_CONT ::: p_payroll_action_id = '|| p_payroll_action_id );
210: hr_utility.trace('EMP_CONT ::: p_asg_act_id = '|| p_asg_act_id );
211: hr_utility.trace('EMP_CONT ::: p_bus_group_id = '|| p_bus_group_id );
212: hr_utility.trace('EMP_CONT ::: p_date_earned = '|| p_date_earned );
213: hr_utility.trace('EMP_CONT ::: p_under_age_high_rate = '|| p_under_age_high_rate );

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

206: hr_utility.trace('EMP_CONT ::: p_local_unit_id = '|| p_local_unit_id );
207: hr_utility.trace('EMP_CONT ::: p_jurisdiction_code = '|| p_jurisdiction_code );
208: hr_utility.trace('EMP_CONT ::: p_payroll_id = '|| p_payroll_id );
209: hr_utility.trace('EMP_CONT ::: p_payroll_action_id = '|| p_payroll_action_id );
210: hr_utility.trace('EMP_CONT ::: p_asg_act_id = '|| p_asg_act_id );
211: hr_utility.trace('EMP_CONT ::: p_bus_group_id = '|| p_bus_group_id );
212: hr_utility.trace('EMP_CONT ::: p_date_earned = '|| p_date_earned );
213: hr_utility.trace('EMP_CONT ::: p_under_age_high_rate = '|| p_under_age_high_rate );
214: hr_utility.trace('EMP_CONT ::: p_over_age_high_rate = '|| p_over_age_high_rate );

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

207: hr_utility.trace('EMP_CONT ::: p_jurisdiction_code = '|| p_jurisdiction_code );
208: hr_utility.trace('EMP_CONT ::: p_payroll_id = '|| p_payroll_id );
209: hr_utility.trace('EMP_CONT ::: p_payroll_action_id = '|| p_payroll_action_id );
210: hr_utility.trace('EMP_CONT ::: p_asg_act_id = '|| p_asg_act_id );
211: hr_utility.trace('EMP_CONT ::: p_bus_group_id = '|| p_bus_group_id );
212: hr_utility.trace('EMP_CONT ::: p_date_earned = '|| p_date_earned );
213: hr_utility.trace('EMP_CONT ::: p_under_age_high_rate = '|| p_under_age_high_rate );
214: hr_utility.trace('EMP_CONT ::: p_over_age_high_rate = '|| p_over_age_high_rate );
215: hr_utility.trace('EMP_CONT ::: -------------------------------------------------');

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

208: hr_utility.trace('EMP_CONT ::: p_payroll_id = '|| p_payroll_id );
209: hr_utility.trace('EMP_CONT ::: p_payroll_action_id = '|| p_payroll_action_id );
210: hr_utility.trace('EMP_CONT ::: p_asg_act_id = '|| p_asg_act_id );
211: hr_utility.trace('EMP_CONT ::: p_bus_group_id = '|| p_bus_group_id );
212: hr_utility.trace('EMP_CONT ::: p_date_earned = '|| p_date_earned );
213: hr_utility.trace('EMP_CONT ::: p_under_age_high_rate = '|| p_under_age_high_rate );
214: hr_utility.trace('EMP_CONT ::: p_over_age_high_rate = '|| p_over_age_high_rate );
215: hr_utility.trace('EMP_CONT ::: -------------------------------------------------');
216:

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

209: hr_utility.trace('EMP_CONT ::: p_payroll_action_id = '|| p_payroll_action_id );
210: hr_utility.trace('EMP_CONT ::: p_asg_act_id = '|| p_asg_act_id );
211: hr_utility.trace('EMP_CONT ::: p_bus_group_id = '|| p_bus_group_id );
212: hr_utility.trace('EMP_CONT ::: p_date_earned = '|| p_date_earned );
213: hr_utility.trace('EMP_CONT ::: p_under_age_high_rate = '|| p_under_age_high_rate );
214: hr_utility.trace('EMP_CONT ::: p_over_age_high_rate = '|| p_over_age_high_rate );
215: hr_utility.trace('EMP_CONT ::: -------------------------------------------------');
216:
217:

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

210: hr_utility.trace('EMP_CONT ::: p_asg_act_id = '|| p_asg_act_id );
211: hr_utility.trace('EMP_CONT ::: p_bus_group_id = '|| p_bus_group_id );
212: hr_utility.trace('EMP_CONT ::: p_date_earned = '|| p_date_earned );
213: hr_utility.trace('EMP_CONT ::: p_under_age_high_rate = '|| p_under_age_high_rate );
214: hr_utility.trace('EMP_CONT ::: p_over_age_high_rate = '|| p_over_age_high_rate );
215: hr_utility.trace('EMP_CONT ::: -------------------------------------------------');
216:
217:
218: --Bug Fix 4465274

Line 215: hr_utility.trace('EMP_CONT ::: -------------------------------------------------');

211: hr_utility.trace('EMP_CONT ::: p_bus_group_id = '|| p_bus_group_id );
212: hr_utility.trace('EMP_CONT ::: p_date_earned = '|| p_date_earned );
213: hr_utility.trace('EMP_CONT ::: p_under_age_high_rate = '|| p_under_age_high_rate );
214: hr_utility.trace('EMP_CONT ::: p_over_age_high_rate = '|| p_over_age_high_rate );
215: hr_utility.trace('EMP_CONT ::: -------------------------------------------------');
216:
217:
218: --Bug Fix 4465274
219: -- cursor retrieves bimonth end date for the p_date_earned

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

230: l_curr_zone := fnd_number.canonical_to_number(hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', p_jurisdiction_code, p_date_earned )) ;
231:
232: l_curr_under_62 := check_under_62(p_asg_act_id,p_date_earned);
233:
234: hr_utility.trace('EMP_CONT ::: l_curr_zone = '|| l_curr_zone );
235: hr_utility.trace('EMP_CONT ::: l_curr_under_62 = '|| l_curr_under_62 );
236:
237: -- Get the Status and Report Separately for the Local Unit of the current assignment
238: OPEN PAY_NO_EMP_CONT.get_lu_details(p_local_unit_id);

Line 235: hr_utility.trace('EMP_CONT ::: l_curr_under_62 = '|| l_curr_under_62 );

231:
232: l_curr_under_62 := check_under_62(p_asg_act_id,p_date_earned);
233:
234: hr_utility.trace('EMP_CONT ::: l_curr_zone = '|| l_curr_zone );
235: hr_utility.trace('EMP_CONT ::: l_curr_under_62 = '|| l_curr_under_62 );
236:
237: -- Get the Status and Report Separately for the Local Unit of the current assignment
238: OPEN PAY_NO_EMP_CONT.get_lu_details(p_local_unit_id);
239: FETCH PAY_NO_EMP_CONT.get_lu_details INTO l_lu_status , l_lu_rep_sep ;

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

238: OPEN PAY_NO_EMP_CONT.get_lu_details(p_local_unit_id);
239: FETCH PAY_NO_EMP_CONT.get_lu_details INTO l_lu_status , l_lu_rep_sep ;
240: CLOSE PAY_NO_EMP_CONT.get_lu_details;
241:
242: hr_utility.trace('EMP_CONT ::: l_lu_status = '|| l_lu_status );
243: hr_utility.trace('EMP_CONT ::: l_lu_rep_sep = '|| l_lu_rep_sep );
244: hr_utility.trace('EMP_CONT ::: goin to test for local unit report separately..........');
245:
246: -- check if Local Unit is Report separately = yes

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

239: FETCH PAY_NO_EMP_CONT.get_lu_details INTO l_lu_status , l_lu_rep_sep ;
240: CLOSE PAY_NO_EMP_CONT.get_lu_details;
241:
242: hr_utility.trace('EMP_CONT ::: l_lu_status = '|| l_lu_status );
243: hr_utility.trace('EMP_CONT ::: l_lu_rep_sep = '|| l_lu_rep_sep );
244: hr_utility.trace('EMP_CONT ::: goin to test for local unit report separately..........');
245:
246: -- check if Local Unit is Report separately = yes
247: IF trim(l_lu_rep_sep) = 'Y'

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

240: CLOSE PAY_NO_EMP_CONT.get_lu_details;
241:
242: hr_utility.trace('EMP_CONT ::: l_lu_status = '|| l_lu_status );
243: hr_utility.trace('EMP_CONT ::: l_lu_rep_sep = '|| l_lu_rep_sep );
244: hr_utility.trace('EMP_CONT ::: goin to test for local unit report separately..........');
245:
246: -- check if Local Unit is Report separately = yes
247: IF trim(l_lu_rep_sep) = 'Y'
248:

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

248:
249: THEN ---------------------------------------------------------------------------------------------------------------------------------
250: -- since LU is report separately, check if LE LU combination exists
251:
252: hr_utility.trace('EMP_CONT ::: Local unit is Rep Sep');
253:
254: start_index_main := NVL (PAY_NO_EMP_CONT.g_tab_main.FIRST, 0) ;
255: end_index_main := NVL (PAY_NO_EMP_CONT.g_tab_main.LAST, 0) ;
256: l_le_lu_exists := FALSE;

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

265: THEN
266: l_le_lu_exists := TRUE;
267: l_le_lu_index := start_index_main;
268:
269: hr_utility.trace('EMP_CONT ::: LE LU combination found');
270: hr_utility.trace('EMP_CONT ::: l_le_lu_index = '|| l_le_lu_index );
271: EXIT;
272: END IF;
273: start_index_main := start_index_main + 1;

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

266: l_le_lu_exists := TRUE;
267: l_le_lu_index := start_index_main;
268:
269: hr_utility.trace('EMP_CONT ::: LE LU combination found');
270: hr_utility.trace('EMP_CONT ::: l_le_lu_index = '|| l_le_lu_index );
271: EXIT;
272: END IF;
273: start_index_main := start_index_main + 1;
274: END LOOP; -- end while loop

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

282: p_run_base := PAY_NO_EMP_CONT.g_tab_main(l_le_lu_index).run_base;
283: p_run_contribution := PAY_NO_EMP_CONT.g_tab_main(l_le_lu_index).run_contribution;
284: p_curr_exemption_limit_used := 0; -- coz this value must have been returned before
285:
286: hr_utility.trace('EMP_CONT ::: LU found, since results exist, just returning them');
287: hr_utility.trace('EMP_CONT ::: LU ***** l_le_lu_index = '|| l_le_lu_index );
288: hr_utility.trace('EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );
289: hr_utility.trace('EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );
290: hr_utility.trace('EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );

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

283: p_run_contribution := PAY_NO_EMP_CONT.g_tab_main(l_le_lu_index).run_contribution;
284: p_curr_exemption_limit_used := 0; -- coz this value must have been returned before
285:
286: hr_utility.trace('EMP_CONT ::: LU found, since results exist, just returning them');
287: hr_utility.trace('EMP_CONT ::: LU ***** l_le_lu_index = '|| l_le_lu_index );
288: hr_utility.trace('EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );
289: hr_utility.trace('EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );
290: hr_utility.trace('EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
291:

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

284: p_curr_exemption_limit_used := 0; -- coz this value must have been returned before
285:
286: hr_utility.trace('EMP_CONT ::: LU found, since results exist, just returning them');
287: hr_utility.trace('EMP_CONT ::: LU ***** l_le_lu_index = '|| l_le_lu_index );
288: hr_utility.trace('EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );
289: hr_utility.trace('EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );
290: hr_utility.trace('EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
291:
292: hr_utility.trace('EMP_CONT ::: LU ***** Leaving procedure-----------------------------------');

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

285:
286: hr_utility.trace('EMP_CONT ::: LU found, since results exist, just returning them');
287: hr_utility.trace('EMP_CONT ::: LU ***** l_le_lu_index = '|| l_le_lu_index );
288: hr_utility.trace('EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );
289: hr_utility.trace('EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );
290: hr_utility.trace('EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
291:
292: hr_utility.trace('EMP_CONT ::: LU ***** Leaving procedure-----------------------------------');
293:

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

286: hr_utility.trace('EMP_CONT ::: LU found, since results exist, just returning them');
287: hr_utility.trace('EMP_CONT ::: LU ***** l_le_lu_index = '|| l_le_lu_index );
288: hr_utility.trace('EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );
289: hr_utility.trace('EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );
290: hr_utility.trace('EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
291:
292: hr_utility.trace('EMP_CONT ::: LU ***** Leaving procedure-----------------------------------');
293:
294: RETURN 1; -- here return le_run and the other values thru OUT parameters

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

288: hr_utility.trace('EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );
289: hr_utility.trace('EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );
290: hr_utility.trace('EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
291:
292: hr_utility.trace('EMP_CONT ::: LU ***** Leaving procedure-----------------------------------');
293:
294: RETURN 1; -- here return le_run and the other values thru OUT parameters
295:
296: ELSE --------------------------------------------------------------------------------------------------------------------------

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

294: RETURN 1; -- here return le_run and the other values thru OUT parameters
295:
296: ELSE --------------------------------------------------------------------------------------------------------------------------
297: -- combination does not exist, calculation has to be done and values returned
298: hr_utility.trace('EMP_CONT ::: LU does not exist, calculate for this LU');
299:
300: ------------------- initializing the g_tab_calc table for LE LU combination
301: hr_utility.trace('EMP_CONT ::: LU ***** initializing g_tab_calc ');
302: -- loop for each zone,under_62 commbination

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

297: -- combination does not exist, calculation has to be done and values returned
298: hr_utility.trace('EMP_CONT ::: LU does not exist, calculate for this LU');
299:
300: ------------------- initializing the g_tab_calc table for LE LU combination
301: hr_utility.trace('EMP_CONT ::: LU ***** initializing g_tab_calc ');
302: -- loop for each zone,under_62 commbination
303: FOR i IN 1..10 LOOP
304:
305: -- to determine the under_62 for this combination

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

323: g_tab_calc(i).run_contribution := 0 ;
324:
325: END LOOP; -- end i loop
326:
327: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
328: l_check := display_table_calc(g_tab_calc);
329: hr_utility.trace('EMP_CONT ::: -- returned from display_table_calc function ');
330:
331: hr_utility.trace('EMP_CONT ::: LU ***** finished initializing g_tab_calc ');

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

325: END LOOP; -- end i loop
326:
327: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
328: l_check := display_table_calc(g_tab_calc);
329: hr_utility.trace('EMP_CONT ::: -- returned from display_table_calc function ');
330:
331: hr_utility.trace('EMP_CONT ::: LU ***** finished initializing g_tab_calc ');
332: -------------------- finished initializing the g_tab_lu table
333:

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

327: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
328: l_check := display_table_calc(g_tab_calc);
329: hr_utility.trace('EMP_CONT ::: -- returned from display_table_calc function ');
330:
331: hr_utility.trace('EMP_CONT ::: LU ***** finished initializing g_tab_calc ');
332: -------------------- finished initializing the g_tab_lu table
333:
334: ------------------ get exemption limit used for LU
335: hr_utility.trace('EMP_CONT ::: LU ***** get exemption limit ');

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

331: hr_utility.trace('EMP_CONT ::: LU ***** finished initializing g_tab_calc ');
332: -------------------- finished initializing the g_tab_lu table
333:
334: ------------------ get exemption limit used for LU
335: hr_utility.trace('EMP_CONT ::: LU ***** get exemption limit ');
336:
337: -- set the context values for balance
338: -- change 1a
339: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);

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

342: -- get defined balance ids
343: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_YTD') ;
344: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_BIMONTH') ;
345:
346: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_1 = '|| l_def_bal_id_1 );
347: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_2 = '|| l_def_bal_id_2 );
348:
349: -- get the balance value
350: 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 347: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_2 = '|| l_def_bal_id_2 );

343: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_YTD') ;
344: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_BIMONTH') ;
345:
346: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_1 = '|| l_def_bal_id_1 );
347: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_2 = '|| l_def_bal_id_2 );
348:
349: -- get the balance value
350: 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);
351: 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 355: hr_utility.trace('EMP_CONT ::: LU ***** l_bal_val_ytd = '|| l_bal_val_ytd );

351: 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);
352:
353: l_exemption_limit_used_yet := l_bal_val_ytd - l_bal_val_bimonth ;
354:
355: hr_utility.trace('EMP_CONT ::: LU ***** l_bal_val_ytd = '|| l_bal_val_ytd );
356: hr_utility.trace('EMP_CONT ::: LU ***** l_bal_val_bimonth = '|| l_bal_val_bimonth );
357: hr_utility.trace('EMP_CONT ::: LU ***** l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
358:
359: OPEN PAY_NO_EMP_CONT.csr_get_exemption_limit(p_local_unit_id ,p_date_earned );

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

352:
353: l_exemption_limit_used_yet := l_bal_val_ytd - l_bal_val_bimonth ;
354:
355: hr_utility.trace('EMP_CONT ::: LU ***** l_bal_val_ytd = '|| l_bal_val_ytd );
356: hr_utility.trace('EMP_CONT ::: LU ***** l_bal_val_bimonth = '|| l_bal_val_bimonth );
357: hr_utility.trace('EMP_CONT ::: LU ***** l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
358:
359: OPEN PAY_NO_EMP_CONT.csr_get_exemption_limit(p_local_unit_id ,p_date_earned );
360: FETCH PAY_NO_EMP_CONT.csr_get_exemption_limit INTO l_exemption_limit ;

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

353: l_exemption_limit_used_yet := l_bal_val_ytd - l_bal_val_bimonth ;
354:
355: hr_utility.trace('EMP_CONT ::: LU ***** l_bal_val_ytd = '|| l_bal_val_ytd );
356: hr_utility.trace('EMP_CONT ::: LU ***** l_bal_val_bimonth = '|| l_bal_val_bimonth );
357: hr_utility.trace('EMP_CONT ::: LU ***** l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
358:
359: OPEN PAY_NO_EMP_CONT.csr_get_exemption_limit(p_local_unit_id ,p_date_earned );
360: FETCH PAY_NO_EMP_CONT.csr_get_exemption_limit INTO l_exemption_limit ;
361: CLOSE PAY_NO_EMP_CONT.csr_get_exemption_limit;

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

366: ELSE
367: l_LU_over_limit := 'N';
368: END IF ; -- end if exemption limit check
369:
370: hr_utility.trace('EMP_CONT ::: LU ***** l_exemption_limit = '||l_exemption_limit );
371: hr_utility.trace('EMP_CONT ::: LU ***** l_LU_over_limit = '|| l_LU_over_limit );
372: hr_utility.trace('EMP_CONT ::: LU ***** got exemtion limt , leaving' );
373:
374: ------------------- got exemption limit used for LU

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

367: l_LU_over_limit := 'N';
368: END IF ; -- end if exemption limit check
369:
370: hr_utility.trace('EMP_CONT ::: LU ***** l_exemption_limit = '||l_exemption_limit );
371: hr_utility.trace('EMP_CONT ::: LU ***** l_LU_over_limit = '|| l_LU_over_limit );
372: hr_utility.trace('EMP_CONT ::: LU ***** got exemtion limt , leaving' );
373:
374: ------------------- got exemption limit used for LU
375:

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

368: END IF ; -- end if exemption limit check
369:
370: hr_utility.trace('EMP_CONT ::: LU ***** l_exemption_limit = '||l_exemption_limit );
371: hr_utility.trace('EMP_CONT ::: LU ***** l_LU_over_limit = '|| l_LU_over_limit );
372: hr_utility.trace('EMP_CONT ::: LU ***** got exemtion limt , leaving' );
373:
374: ------------------- got exemption limit used for LU
375:
376: ----------------- populating the tables g_lu_tab (LU) and g_mu_tab (MU)

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

373:
374: ------------------- got exemption limit used for LU
375:
376: ----------------- populating the tables g_lu_tab (LU) and g_mu_tab (MU)
377: hr_utility.trace('EMP_CONT ::: LU ***** populating g_lu_tab and g_mu_tab , entering ' );
378:
379: l_temp := populate_tables
380: (p_tax_unit_id
381: ,p_payroll_id

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

382: ,p_date_earned
383: ,g_lu_tab
384: ,g_mu_tab );
385:
386: hr_utility.trace('EMP_CONT ::: LU ***** populated g_lu_tab and g_mu_tab , leaving ' );
387: ----------------- Fetch the run base using assignment level balances (at LU level)
388: hr_utility.trace('EMP_CONT ::: LU ***** Fetch the run base using assignment level balances , enetring ' );
389:
390: -- get defined balance ids

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

384: ,g_mu_tab );
385:
386: hr_utility.trace('EMP_CONT ::: LU ***** populated g_lu_tab and g_mu_tab , leaving ' );
387: ----------------- Fetch the run base using assignment level balances (at LU level)
388: hr_utility.trace('EMP_CONT ::: LU ***** Fetch the run base using assignment level balances , enetring ' );
389:
390: -- get defined balance ids
391: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Base','_ASG_TU_MU_LU_BIMONTH') ;
392: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution Base 2','_ASG_TU_MU_LU_BIMONTH') ;

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

393:
394: l_def_bal_id_3 := get_defined_balance_id('Employer Contribution Over 62 Base','_ASG_TU_MU_LU_BIMONTH') ;
395: l_def_bal_id_4 := get_defined_balance_id('Employer Contribution Over 62 Base 2','_ASG_TU_MU_LU_BIMONTH') ;
396:
397: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_1 = '|| l_def_bal_id_1 );
398: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_2 = '|| l_def_bal_id_2 );
399: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_3 = '|| l_def_bal_id_3 );
400: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_4 = '|| l_def_bal_id_4 );
401:

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

394: l_def_bal_id_3 := get_defined_balance_id('Employer Contribution Over 62 Base','_ASG_TU_MU_LU_BIMONTH') ;
395: l_def_bal_id_4 := get_defined_balance_id('Employer Contribution Over 62 Base 2','_ASG_TU_MU_LU_BIMONTH') ;
396:
397: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_1 = '|| l_def_bal_id_1 );
398: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_2 = '|| l_def_bal_id_2 );
399: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_3 = '|| l_def_bal_id_3 );
400: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_4 = '|| l_def_bal_id_4 );
401:
402: ----- test only , Remove it

Line 399: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_3 = '|| l_def_bal_id_3 );

395: l_def_bal_id_4 := get_defined_balance_id('Employer Contribution Over 62 Base 2','_ASG_TU_MU_LU_BIMONTH') ;
396:
397: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_1 = '|| l_def_bal_id_1 );
398: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_2 = '|| l_def_bal_id_2 );
399: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_3 = '|| l_def_bal_id_3 );
400: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_4 = '|| l_def_bal_id_4 );
401:
402: ----- test only , Remove it
403: OPEN csr_test_aag_act_id (p_tax_unit_id , p_payroll_action_id, p_date_earned);

Line 400: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_4 = '|| l_def_bal_id_4 );

396:
397: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_1 = '|| l_def_bal_id_1 );
398: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_2 = '|| l_def_bal_id_2 );
399: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_3 = '|| l_def_bal_id_3 );
400: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_4 = '|| l_def_bal_id_4 );
401:
402: ----- test only , Remove it
403: OPEN csr_test_aag_act_id (p_tax_unit_id , p_payroll_action_id, p_date_earned);
404: FETCH csr_test_aag_act_id INTO l_check2;

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

402: ----- test only , Remove it
403: OPEN csr_test_aag_act_id (p_tax_unit_id , p_payroll_action_id, p_date_earned);
404: FETCH csr_test_aag_act_id INTO l_check2;
405: CLOSE csr_test_aag_act_id;
406: hr_utility.trace('EMP_CONT ::: LU ***** l_check2 , no of rows returned by asg act id cursor = '||l_check2 );
407: -- remove till here
408:
409: hr_utility.trace('EMP_CONT ::: LU ***** level 0 leave' );
410:

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

405: CLOSE csr_test_aag_act_id;
406: hr_utility.trace('EMP_CONT ::: LU ***** l_check2 , no of rows returned by asg act id cursor = '||l_check2 );
407: -- remove till here
408:
409: hr_utility.trace('EMP_CONT ::: LU ***** level 0 leave' );
410:
411: -- change 2a
412: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
413: pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);

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

415:
416: -- loop to get all assignment_action_id in the current payroll_action_id
417: FOR csr1_rec IN csr_curr_le_asg_act_id (p_tax_unit_id , p_payroll_action_id, p_date_earned) LOOP
418:
419: hr_utility.trace('EMP_CONT ::: LU ***** level 1 , loop csr_curr_le_asg_act_id ' );
420:
421: start_index_mu := NVL (g_mu_tab.FIRST, 0) ;
422: end_index_mu := NVL (g_mu_tab.LAST, 0) ;
423:

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

422: end_index_mu := NVL (g_mu_tab.LAST, 0) ;
423:
424: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
425:
426: hr_utility.trace('EMP_CONT ::: LU ***** level 2, g_mu_tab ' );
427: hr_utility.trace('EMP_CONT ::: LU ***** ASS_ACT_ID = '|| csr1_rec.ASSIGNMENT_ACTION_ID || ' MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| p_local_unit_id );
428:
429: --setting the context values
430: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);

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

423:
424: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
425:
426: hr_utility.trace('EMP_CONT ::: LU ***** level 2, g_mu_tab ' );
427: hr_utility.trace('EMP_CONT ::: LU ***** ASS_ACT_ID = '|| csr1_rec.ASSIGNMENT_ACTION_ID || ' MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| p_local_unit_id );
428:
429: --setting the context values
430: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
431: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));

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

441: l_asg_ers_base_diff := l_asg_ers_base - l_asg_ers_base2;
442:
443: l_asg_ers_over_62_base_diff := l_asg_ers_over_62_base - l_asg_ers_over_62_base2;
444:
445: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_base = '|| l_asg_ers_base );
446: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_base2 = '|| l_asg_ers_base2 );
447: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_over_62_base = '|| l_asg_ers_over_62_base );
448: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_over_62_base2 = '|| l_asg_ers_over_62_base2 );
449: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_base_diff = '|| l_asg_ers_base_diff );

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

442:
443: l_asg_ers_over_62_base_diff := l_asg_ers_over_62_base - l_asg_ers_over_62_base2;
444:
445: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_base = '|| l_asg_ers_base );
446: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_base2 = '|| l_asg_ers_base2 );
447: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_over_62_base = '|| l_asg_ers_over_62_base );
448: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_over_62_base2 = '|| l_asg_ers_over_62_base2 );
449: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_base_diff = '|| l_asg_ers_base_diff );
450: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_over_62_base_diff = '||l_asg_ers_over_62_base_diff );

Line 447: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_over_62_base = '|| l_asg_ers_over_62_base );

443: l_asg_ers_over_62_base_diff := l_asg_ers_over_62_base - l_asg_ers_over_62_base2;
444:
445: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_base = '|| l_asg_ers_base );
446: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_base2 = '|| l_asg_ers_base2 );
447: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_over_62_base = '|| l_asg_ers_over_62_base );
448: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_over_62_base2 = '|| l_asg_ers_over_62_base2 );
449: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_base_diff = '|| l_asg_ers_base_diff );
450: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_over_62_base_diff = '||l_asg_ers_over_62_base_diff );
451:

Line 448: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_over_62_base2 = '|| l_asg_ers_over_62_base2 );

444:
445: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_base = '|| l_asg_ers_base );
446: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_base2 = '|| l_asg_ers_base2 );
447: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_over_62_base = '|| l_asg_ers_over_62_base );
448: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_over_62_base2 = '|| l_asg_ers_over_62_base2 );
449: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_base_diff = '|| l_asg_ers_base_diff );
450: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_over_62_base_diff = '||l_asg_ers_over_62_base_diff );
451:
452: --l_under_62 := check_under_62(p_asg_act_id,p_date_earned);

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

445: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_base = '|| l_asg_ers_base );
446: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_base2 = '|| l_asg_ers_base2 );
447: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_over_62_base = '|| l_asg_ers_over_62_base );
448: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_over_62_base2 = '|| l_asg_ers_over_62_base2 );
449: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_base_diff = '|| l_asg_ers_base_diff );
450: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_over_62_base_diff = '||l_asg_ers_over_62_base_diff );
451:
452: --l_under_62 := check_under_62(p_asg_act_id,p_date_earned);
453:

Line 450: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_over_62_base_diff = '||l_asg_ers_over_62_base_diff );

446: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_base2 = '|| l_asg_ers_base2 );
447: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_over_62_base = '|| l_asg_ers_over_62_base );
448: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_over_62_base2 = '|| l_asg_ers_over_62_base2 );
449: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_base_diff = '|| l_asg_ers_base_diff );
450: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_over_62_base_diff = '||l_asg_ers_over_62_base_diff );
451:
452: --l_under_62 := check_under_62(p_asg_act_id,p_date_earned);
453:
454: hr_utility.trace('EMP_CONT ::: LU ***** ============== just checking================= ');

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

450: hr_utility.trace('EMP_CONT ::: LU ***** l_asg_ers_over_62_base_diff = '||l_asg_ers_over_62_base_diff );
451:
452: --l_under_62 := check_under_62(p_asg_act_id,p_date_earned);
453:
454: hr_utility.trace('EMP_CONT ::: LU ***** ============== just checking================= ');
455: hr_utility.trace('EMP_CONT ::: LU ***** g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
456:
457: l_zone_temp := to_char(g_mu_tab(start_index_mu));
458:

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

451:
452: --l_under_62 := check_under_62(p_asg_act_id,p_date_earned);
453:
454: hr_utility.trace('EMP_CONT ::: LU ***** ============== just checking================= ');
455: hr_utility.trace('EMP_CONT ::: LU ***** g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
456:
457: l_zone_temp := to_char(g_mu_tab(start_index_mu));
458:
459: hr_utility.trace('EMP_CONT ::: LU ***** l_zone_temp = '|| l_zone_temp );

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

455: hr_utility.trace('EMP_CONT ::: LU ***** g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
456:
457: l_zone_temp := to_char(g_mu_tab(start_index_mu));
458:
459: hr_utility.trace('EMP_CONT ::: LU ***** l_zone_temp = '|| l_zone_temp );
460:
461: -- l_zone := to_number(substr(get_lookup_meaning('NO_TAX_MUNICIPALITY',l_zone_temp),1,1));
462: -- Tax Municipality for Norway has been moved to User Table NO_TAX_MUNICIPALITY
463: -- The zone for a Tax Municipality will now be fetched from the user table

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

462: -- Tax Municipality for Norway has been moved to User Table NO_TAX_MUNICIPALITY
463: -- The zone for a Tax Municipality will now be fetched from the user table
464: l_zone := fnd_number.canonical_to_number(hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', l_zone_temp, p_date_earned )) ;
465:
466: hr_utility.trace('EMP_CONT ::: LU ***** l_zone = '|| l_zone );
467:
468: l_cell := lookup_cell(g_tab_calc,'Y',l_zone);
469: g_tab_calc(l_cell).run_base := g_tab_calc(l_cell).run_base + l_asg_ers_base_diff ;
470:

Line 471: hr_utility.trace('EMP_CONT ::: LU ***** l_cell below 62 = '|| l_cell );

467:
468: l_cell := lookup_cell(g_tab_calc,'Y',l_zone);
469: g_tab_calc(l_cell).run_base := g_tab_calc(l_cell).run_base + l_asg_ers_base_diff ;
470:
471: hr_utility.trace('EMP_CONT ::: LU ***** l_cell below 62 = '|| l_cell );
472:
473: l_cell := lookup_cell(g_tab_calc,'N',l_zone);
474: g_tab_calc(l_cell).run_base := g_tab_calc(l_cell).run_base + l_asg_ers_over_62_base_diff ;
475:

Line 476: hr_utility.trace('EMP_CONT ::: LU ***** l_cell above 62 = '|| l_cell );

472:
473: l_cell := lookup_cell(g_tab_calc,'N',l_zone);
474: g_tab_calc(l_cell).run_base := g_tab_calc(l_cell).run_base + l_asg_ers_over_62_base_diff ;
475:
476: hr_utility.trace('EMP_CONT ::: LU ***** l_cell above 62 = '|| l_cell );
477:
478: start_index_mu := start_index_mu + 1;
479: END LOOP; -- end while loop
480:

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

479: END LOOP; -- end while loop
480:
481: END LOOP; -- end loop csr1_rec
482:
483: hr_utility.trace('EMP_CONT ::: LU ***** level 0 back' );
484:
485: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
486: l_check := display_table_calc(g_tab_calc);
487: hr_utility.trace('EMP_CONT ::: -- returned from display_table_calc function ');

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

481: END LOOP; -- end loop csr1_rec
482:
483: hr_utility.trace('EMP_CONT ::: LU ***** level 0 back' );
484:
485: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
486: l_check := display_table_calc(g_tab_calc);
487: hr_utility.trace('EMP_CONT ::: -- returned from display_table_calc function ');
488:
489: hr_utility.trace('EMP_CONT ::: LU ***** Fetched the run base using assignment level balances , leaving ' );

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

483: hr_utility.trace('EMP_CONT ::: LU ***** level 0 back' );
484:
485: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
486: l_check := display_table_calc(g_tab_calc);
487: hr_utility.trace('EMP_CONT ::: -- returned from display_table_calc function ');
488:
489: hr_utility.trace('EMP_CONT ::: LU ***** Fetched the run base using assignment level balances , leaving ' );
490: ---------------------- Fetched the run base using assignment level balances (at LU level)
491:

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

485: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
486: l_check := display_table_calc(g_tab_calc);
487: hr_utility.trace('EMP_CONT ::: -- returned from display_table_calc function ');
488:
489: hr_utility.trace('EMP_CONT ::: LU ***** Fetched the run base using assignment level balances , leaving ' );
490: ---------------------- Fetched the run base using assignment level balances (at LU level)
491:
492: ----------------- Fetch the bimonth base using group level balances (at LU level)
493: hr_utility.trace('EMP_CONT ::: LU ***** Fetch the bimonth base using group level balances , entering ' );

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

489: hr_utility.trace('EMP_CONT ::: LU ***** Fetched the run base using assignment level balances , leaving ' );
490: ---------------------- Fetched the run base using assignment level balances (at LU level)
491:
492: ----------------- Fetch the bimonth base using group level balances (at LU level)
493: hr_utility.trace('EMP_CONT ::: LU ***** Fetch the bimonth base using group level balances , entering ' );
494:
495: -- get defined balance ids
496: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Base','_TU_MU_LU_BIMONTH') ;
497: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution','_TU_MU_LU_BIMONTH') ;

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

498:
499: l_def_bal_id_3 := get_defined_balance_id('Employer Contribution Over 62 Base','_TU_MU_LU_BIMONTH') ;
500: l_def_bal_id_4 := get_defined_balance_id('Employer Contribution Over 62','_TU_MU_LU_BIMONTH') ;
501:
502: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_1 = '|| l_def_bal_id_1 );
503: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_2 = '|| l_def_bal_id_2 );
504: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_3 = '|| l_def_bal_id_3 );
505: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_4 = '|| l_def_bal_id_4 );
506:

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

499: l_def_bal_id_3 := get_defined_balance_id('Employer Contribution Over 62 Base','_TU_MU_LU_BIMONTH') ;
500: l_def_bal_id_4 := get_defined_balance_id('Employer Contribution Over 62','_TU_MU_LU_BIMONTH') ;
501:
502: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_1 = '|| l_def_bal_id_1 );
503: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_2 = '|| l_def_bal_id_2 );
504: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_3 = '|| l_def_bal_id_3 );
505: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_4 = '|| l_def_bal_id_4 );
506:
507: -- loop to get all MU in g_mu_tab

Line 504: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_3 = '|| l_def_bal_id_3 );

500: l_def_bal_id_4 := get_defined_balance_id('Employer Contribution Over 62','_TU_MU_LU_BIMONTH') ;
501:
502: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_1 = '|| l_def_bal_id_1 );
503: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_2 = '|| l_def_bal_id_2 );
504: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_3 = '|| l_def_bal_id_3 );
505: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_4 = '|| l_def_bal_id_4 );
506:
507: -- loop to get all MU in g_mu_tab
508:

Line 505: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_4 = '|| l_def_bal_id_4 );

501:
502: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_1 = '|| l_def_bal_id_1 );
503: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_2 = '|| l_def_bal_id_2 );
504: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_3 = '|| l_def_bal_id_3 );
505: hr_utility.trace('EMP_CONT ::: LU ***** l_def_bal_id_4 = '|| l_def_bal_id_4 );
506:
507: -- loop to get all MU in g_mu_tab
508:
509: start_index_mu := NVL (g_mu_tab.FIRST, 0) ;

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

508:
509: start_index_mu := NVL (g_mu_tab.FIRST, 0) ;
510: end_index_mu := NVL (g_mu_tab.LAST, 0) ;
511:
512: hr_utility.trace('EMP_CONT ::: LU ***** level 0 leave ' );
513:
514: -- change 3a
515: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
516: pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);

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

517: -----
518:
519: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
520:
521: hr_utility.trace('EMP_CONT ::: LU ***** level 1 ,g_mu_tab ' );
522:
523: --setting the context values
524: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
525: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));

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

524: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
525: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
526: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);
527:
528: hr_utility.trace('EMP_CONT ::: LU ***** MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| p_local_unit_id );
529:
530: -- get the balance value
531: 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);
532: 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 537: hr_utility.trace('EMP_CONT ::: LU ***** l_lu_ers_base = '|| l_lu_ers_base);

533:
534: l_lu_ers_over_62_base := pay_balance_pkg.get_value(l_def_bal_id_3,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
535: l_lu_ers_over_62 := pay_balance_pkg.get_value(l_def_bal_id_4,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
536:
537: hr_utility.trace('EMP_CONT ::: LU ***** l_lu_ers_base = '|| l_lu_ers_base);
538: hr_utility.trace('EMP_CONT ::: LU ***** l_lu_ers = '||l_lu_ers );
539: hr_utility.trace('EMP_CONT ::: LU ***** l_lu_ers_over_62_base = '|| l_lu_ers_over_62_base );
540: hr_utility.trace('EMP_CONT ::: LU ***** l_lu_ers_over_62 = '|| l_lu_ers_over_62 );
541:

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

534: l_lu_ers_over_62_base := pay_balance_pkg.get_value(l_def_bal_id_3,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
535: l_lu_ers_over_62 := pay_balance_pkg.get_value(l_def_bal_id_4,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
536:
537: hr_utility.trace('EMP_CONT ::: LU ***** l_lu_ers_base = '|| l_lu_ers_base);
538: hr_utility.trace('EMP_CONT ::: LU ***** l_lu_ers = '||l_lu_ers );
539: hr_utility.trace('EMP_CONT ::: LU ***** l_lu_ers_over_62_base = '|| l_lu_ers_over_62_base );
540: hr_utility.trace('EMP_CONT ::: LU ***** l_lu_ers_over_62 = '|| l_lu_ers_over_62 );
541:
542: hr_utility.trace('EMP_CONT ::: LU ***** ============== just checking again ================= ');

Line 539: hr_utility.trace('EMP_CONT ::: LU ***** l_lu_ers_over_62_base = '|| l_lu_ers_over_62_base );

535: l_lu_ers_over_62 := pay_balance_pkg.get_value(l_def_bal_id_4,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
536:
537: hr_utility.trace('EMP_CONT ::: LU ***** l_lu_ers_base = '|| l_lu_ers_base);
538: hr_utility.trace('EMP_CONT ::: LU ***** l_lu_ers = '||l_lu_ers );
539: hr_utility.trace('EMP_CONT ::: LU ***** l_lu_ers_over_62_base = '|| l_lu_ers_over_62_base );
540: hr_utility.trace('EMP_CONT ::: LU ***** l_lu_ers_over_62 = '|| l_lu_ers_over_62 );
541:
542: hr_utility.trace('EMP_CONT ::: LU ***** ============== just checking again ================= ');
543:

Line 540: hr_utility.trace('EMP_CONT ::: LU ***** l_lu_ers_over_62 = '|| l_lu_ers_over_62 );

536:
537: hr_utility.trace('EMP_CONT ::: LU ***** l_lu_ers_base = '|| l_lu_ers_base);
538: hr_utility.trace('EMP_CONT ::: LU ***** l_lu_ers = '||l_lu_ers );
539: hr_utility.trace('EMP_CONT ::: LU ***** l_lu_ers_over_62_base = '|| l_lu_ers_over_62_base );
540: hr_utility.trace('EMP_CONT ::: LU ***** l_lu_ers_over_62 = '|| l_lu_ers_over_62 );
541:
542: hr_utility.trace('EMP_CONT ::: LU ***** ============== just checking again ================= ');
543:
544: hr_utility.trace('EMP_CONT ::: LU ***** g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );

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

538: hr_utility.trace('EMP_CONT ::: LU ***** l_lu_ers = '||l_lu_ers );
539: hr_utility.trace('EMP_CONT ::: LU ***** l_lu_ers_over_62_base = '|| l_lu_ers_over_62_base );
540: hr_utility.trace('EMP_CONT ::: LU ***** l_lu_ers_over_62 = '|| l_lu_ers_over_62 );
541:
542: hr_utility.trace('EMP_CONT ::: LU ***** ============== just checking again ================= ');
543:
544: hr_utility.trace('EMP_CONT ::: LU ***** g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
545:
546: l_zone_temp := to_char(g_mu_tab(start_index_mu));

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

540: hr_utility.trace('EMP_CONT ::: LU ***** l_lu_ers_over_62 = '|| l_lu_ers_over_62 );
541:
542: hr_utility.trace('EMP_CONT ::: LU ***** ============== just checking again ================= ');
543:
544: hr_utility.trace('EMP_CONT ::: LU ***** g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
545:
546: l_zone_temp := to_char(g_mu_tab(start_index_mu));
547:
548: hr_utility.trace('EMP_CONT ::: LU ***** l_zone_temp = '|| l_zone_temp );

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

544: hr_utility.trace('EMP_CONT ::: LU ***** g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
545:
546: l_zone_temp := to_char(g_mu_tab(start_index_mu));
547:
548: hr_utility.trace('EMP_CONT ::: LU ***** l_zone_temp = '|| l_zone_temp );
549:
550: -- l_zone := to_number(substr(get_lookup_meaning('NO_TAX_MUNICIPALITY',l_zone_temp),1,1));
551: -- Tax Municipality for Norway has been moved to User Table NO_TAX_MUNICIPALITY
552: -- The zone for a Tax Municipality will now be fetched from the user table

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

551: -- Tax Municipality for Norway has been moved to User Table NO_TAX_MUNICIPALITY
552: -- The zone for a Tax Municipality will now be fetched from the user table
553: l_zone := fnd_number.canonical_to_number(hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', l_zone_temp, p_date_earned )) ;
554:
555: hr_utility.trace('EMP_CONT ::: LU ***** l_zone = '|| l_zone );
556:
557: l_cell := lookup_cell(g_tab_calc,'Y',l_zone);
558: g_tab_calc(l_cell).bimonth_base := g_tab_calc(l_cell).bimonth_base + l_lu_ers_base ;
559: g_tab_calc(l_cell).bimonth_contribution_todate := g_tab_calc(l_cell).bimonth_contribution_todate + l_lu_ers ;

Line 561: hr_utility.trace('EMP_CONT ::: LU ***** l_cell below 62 = '|| l_cell );

557: l_cell := lookup_cell(g_tab_calc,'Y',l_zone);
558: g_tab_calc(l_cell).bimonth_base := g_tab_calc(l_cell).bimonth_base + l_lu_ers_base ;
559: g_tab_calc(l_cell).bimonth_contribution_todate := g_tab_calc(l_cell).bimonth_contribution_todate + l_lu_ers ;
560:
561: hr_utility.trace('EMP_CONT ::: LU ***** l_cell below 62 = '|| l_cell );
562:
563: l_cell := lookup_cell(g_tab_calc,'N',l_zone);
564: g_tab_calc(l_cell).bimonth_base := g_tab_calc(l_cell).bimonth_base + l_lu_ers_over_62_base ;
565: g_tab_calc(l_cell).bimonth_contribution_todate := g_tab_calc(l_cell).bimonth_contribution_todate + l_lu_ers_over_62 ;

Line 567: hr_utility.trace('EMP_CONT ::: LU ***** l_cell above 62 = '|| l_cell );

563: l_cell := lookup_cell(g_tab_calc,'N',l_zone);
564: g_tab_calc(l_cell).bimonth_base := g_tab_calc(l_cell).bimonth_base + l_lu_ers_over_62_base ;
565: g_tab_calc(l_cell).bimonth_contribution_todate := g_tab_calc(l_cell).bimonth_contribution_todate + l_lu_ers_over_62 ;
566:
567: hr_utility.trace('EMP_CONT ::: LU ***** l_cell above 62 = '|| l_cell );
568:
569: start_index_mu := start_index_mu + 1;
570: END LOOP; -- end while loop
571:

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

568:
569: start_index_mu := start_index_mu + 1;
570: END LOOP; -- end while loop
571:
572: hr_utility.trace('EMP_CONT ::: LU ***** level 0 back' );
573:
574: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
575: l_check := display_table_calc(g_tab_calc);
576: hr_utility.trace('EMP_CONT ::: -- returned from display_table_calc function ');

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

570: END LOOP; -- end while loop
571:
572: hr_utility.trace('EMP_CONT ::: LU ***** level 0 back' );
573:
574: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
575: l_check := display_table_calc(g_tab_calc);
576: hr_utility.trace('EMP_CONT ::: -- returned from display_table_calc function ');
577:
578: hr_utility.trace('EMP_CONT ::: LU ***** Fetched the bimonth base using group level balances , leaving ' );

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

572: hr_utility.trace('EMP_CONT ::: LU ***** level 0 back' );
573:
574: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
575: l_check := display_table_calc(g_tab_calc);
576: hr_utility.trace('EMP_CONT ::: -- returned from display_table_calc function ');
577:
578: hr_utility.trace('EMP_CONT ::: LU ***** Fetched the bimonth base using group level balances , leaving ' );
579: ---------------------- Fetched the bimonth base using group level balances (at LU level)
580:

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

574: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
575: l_check := display_table_calc(g_tab_calc);
576: hr_utility.trace('EMP_CONT ::: -- returned from display_table_calc function ');
577:
578: hr_utility.trace('EMP_CONT ::: LU ***** Fetched the bimonth base using group level balances , leaving ' );
579: ---------------------- Fetched the bimonth base using group level balances (at LU level)
580:
581:
582: ------------------------------ apply differential rate and check exemption limit at LU Level

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

579: ---------------------- Fetched the bimonth base using group level balances (at LU level)
580:
581:
582: ------------------------------ apply differential rate and check exemption limit at LU Level
583: hr_utility.trace('EMP_CONT ::: LU ***** apply differential rate and check exemption limit , entering ' );
584: --l_lu_status status for LU
585: --l_le_status status for LE
586: l_total_saving := 0;
587:

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

588: -- check if exemption limit already used up
589: IF l_LU_over_limit = 'Y'
590:
591: THEN
592: hr_utility.trace('EMP_CONT ::: LU ***** l_LU_over_limit = Y ' );
593:
594: -- as limit is over, put under_limit as N for all rows
595: FOR i IN 1..10 LOOP
596: g_tab_calc(i).under_limit := 'N';

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

595: FOR i IN 1..10 LOOP
596: g_tab_calc(i).under_limit := 'N';
597: END LOOP; -- end i loop
598:
599: hr_utility.trace('EMP_CONT ::: LU ***** as limit is over, put under_limit as N for all rows ' );
600:
601: ELSE
602: hr_utility.trace('EMP_CONT ::: LU ***** l_LU_over_limit = N ' );
603:

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

598:
599: hr_utility.trace('EMP_CONT ::: LU ***** as limit is over, put under_limit as N for all rows ' );
600:
601: ELSE
602: hr_utility.trace('EMP_CONT ::: LU ***** l_LU_over_limit = N ' );
603:
604: -- limit is not over
605: -- perform exemption limit check only if status = OF,HF
606: IF ((l_lu_status = 'OF') or (l_lu_status = 'HF'))

Line 608: hr_utility.trace('EMP_CONT ::: LU ***** status is OF or HF = '|| l_lu_status );

604: -- limit is not over
605: -- perform exemption limit check only if status = OF,HF
606: IF ((l_lu_status = 'OF') or (l_lu_status = 'HF'))
607: THEN
608: hr_utility.trace('EMP_CONT ::: LU ***** status is OF or HF = '|| l_lu_status );
609:
610: -------- performing exemption limit check
611: l_table_name := 'NO_NIS_ZONE_RATES';
612:

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

627: l_high_rate := p_over_age_high_rate;
628:
629: END IF; -- end IF under_62 = Y
630:
631: hr_utility.trace('EMP_CONT ::: LU ***** exemption limit check ----------------------------' );
632:
633: l_zone_value := g_tab_calc(i).zone;
634: 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 ));
635: l_diff_rate := l_high_rate - l_normal_rate ;

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

645:
646: l_saving := ( g_tab_calc(i).bimonth_base * l_diff_rate ) / 100 ;
647: l_total_saving := l_total_saving + l_saving ;
648:
649: hr_utility.trace('EMP_CONT ::: LU ***** i = '||i||' l_zone_value = '||l_zone_value
650: ||' l_normal_rate = '||l_normal_rate||' l_high_rate = '||l_high_rate
651: ||' l_diff_rate = '||l_diff_rate||' l_saving = '||l_saving||' l_total_saving = '||l_total_saving );
652:
653: -- check if exemption limit exceeded

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

652:
653: -- check if exemption limit exceeded
654: IF ((l_exemption_limit_used_yet + l_total_saving) >= l_exemption_limit)
655: THEN
656: hr_utility.trace('EMP_CONT ::: LU******** exemption limit exceeded in table');
657: hr_utility.trace('EMP_CONT ::: LU ***** bimonth_base = '|| g_tab_calc(i).bimonth_base );
658: hr_utility.trace('EMP_CONT ::: LU ***** run_base = '||g_tab_calc(i).run_base );
659: hr_utility.trace('EMP_CONT ::: LU ***** l_zone_value = '|| l_zone_value );
660: hr_utility.trace('EMP_CONT ::: LU ***** l_normal_rate = '|| l_normal_rate );

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

653: -- check if exemption limit exceeded
654: IF ((l_exemption_limit_used_yet + l_total_saving) >= l_exemption_limit)
655: THEN
656: hr_utility.trace('EMP_CONT ::: LU******** exemption limit exceeded in table');
657: hr_utility.trace('EMP_CONT ::: LU ***** bimonth_base = '|| g_tab_calc(i).bimonth_base );
658: hr_utility.trace('EMP_CONT ::: LU ***** run_base = '||g_tab_calc(i).run_base );
659: hr_utility.trace('EMP_CONT ::: LU ***** l_zone_value = '|| l_zone_value );
660: hr_utility.trace('EMP_CONT ::: LU ***** l_normal_rate = '|| l_normal_rate );
661: hr_utility.trace('EMP_CONT ::: LU ***** l_high_rate = '|| l_high_rate );

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

654: IF ((l_exemption_limit_used_yet + l_total_saving) >= l_exemption_limit)
655: THEN
656: hr_utility.trace('EMP_CONT ::: LU******** exemption limit exceeded in table');
657: hr_utility.trace('EMP_CONT ::: LU ***** bimonth_base = '|| g_tab_calc(i).bimonth_base );
658: hr_utility.trace('EMP_CONT ::: LU ***** run_base = '||g_tab_calc(i).run_base );
659: hr_utility.trace('EMP_CONT ::: LU ***** l_zone_value = '|| l_zone_value );
660: hr_utility.trace('EMP_CONT ::: LU ***** l_normal_rate = '|| l_normal_rate );
661: hr_utility.trace('EMP_CONT ::: LU ***** l_high_rate = '|| l_high_rate );
662: hr_utility.trace('EMP_CONT ::: LU ***** l_diff_rate = '|| l_diff_rate );

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

655: THEN
656: hr_utility.trace('EMP_CONT ::: LU******** exemption limit exceeded in table');
657: hr_utility.trace('EMP_CONT ::: LU ***** bimonth_base = '|| g_tab_calc(i).bimonth_base );
658: hr_utility.trace('EMP_CONT ::: LU ***** run_base = '||g_tab_calc(i).run_base );
659: hr_utility.trace('EMP_CONT ::: LU ***** l_zone_value = '|| l_zone_value );
660: hr_utility.trace('EMP_CONT ::: LU ***** l_normal_rate = '|| l_normal_rate );
661: hr_utility.trace('EMP_CONT ::: LU ***** l_high_rate = '|| l_high_rate );
662: hr_utility.trace('EMP_CONT ::: LU ***** l_diff_rate = '|| l_diff_rate );
663: hr_utility.trace('EMP_CONT ::: LU ***** l_saving = '|| l_saving );

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

656: hr_utility.trace('EMP_CONT ::: LU******** exemption limit exceeded in table');
657: hr_utility.trace('EMP_CONT ::: LU ***** bimonth_base = '|| g_tab_calc(i).bimonth_base );
658: hr_utility.trace('EMP_CONT ::: LU ***** run_base = '||g_tab_calc(i).run_base );
659: hr_utility.trace('EMP_CONT ::: LU ***** l_zone_value = '|| l_zone_value );
660: hr_utility.trace('EMP_CONT ::: LU ***** l_normal_rate = '|| l_normal_rate );
661: hr_utility.trace('EMP_CONT ::: LU ***** l_high_rate = '|| l_high_rate );
662: hr_utility.trace('EMP_CONT ::: LU ***** l_diff_rate = '|| l_diff_rate );
663: hr_utility.trace('EMP_CONT ::: LU ***** l_saving = '|| l_saving );
664: hr_utility.trace('EMP_CONT ::: LU ***** l_total_saving= '|| l_total_saving );

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

657: hr_utility.trace('EMP_CONT ::: LU ***** bimonth_base = '|| g_tab_calc(i).bimonth_base );
658: hr_utility.trace('EMP_CONT ::: LU ***** run_base = '||g_tab_calc(i).run_base );
659: hr_utility.trace('EMP_CONT ::: LU ***** l_zone_value = '|| l_zone_value );
660: hr_utility.trace('EMP_CONT ::: LU ***** l_normal_rate = '|| l_normal_rate );
661: hr_utility.trace('EMP_CONT ::: LU ***** l_high_rate = '|| l_high_rate );
662: hr_utility.trace('EMP_CONT ::: LU ***** l_diff_rate = '|| l_diff_rate );
663: hr_utility.trace('EMP_CONT ::: LU ***** l_saving = '|| l_saving );
664: hr_utility.trace('EMP_CONT ::: LU ***** l_total_saving= '|| l_total_saving );
665: hr_utility.trace('EMP_CONT ::: LU ***** l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );

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

658: hr_utility.trace('EMP_CONT ::: LU ***** run_base = '||g_tab_calc(i).run_base );
659: hr_utility.trace('EMP_CONT ::: LU ***** l_zone_value = '|| l_zone_value );
660: hr_utility.trace('EMP_CONT ::: LU ***** l_normal_rate = '|| l_normal_rate );
661: hr_utility.trace('EMP_CONT ::: LU ***** l_high_rate = '|| l_high_rate );
662: hr_utility.trace('EMP_CONT ::: LU ***** l_diff_rate = '|| l_diff_rate );
663: hr_utility.trace('EMP_CONT ::: LU ***** l_saving = '|| l_saving );
664: hr_utility.trace('EMP_CONT ::: LU ***** l_total_saving= '|| l_total_saving );
665: hr_utility.trace('EMP_CONT ::: LU ***** l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
666:

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

659: hr_utility.trace('EMP_CONT ::: LU ***** l_zone_value = '|| l_zone_value );
660: hr_utility.trace('EMP_CONT ::: LU ***** l_normal_rate = '|| l_normal_rate );
661: hr_utility.trace('EMP_CONT ::: LU ***** l_high_rate = '|| l_high_rate );
662: hr_utility.trace('EMP_CONT ::: LU ***** l_diff_rate = '|| l_diff_rate );
663: hr_utility.trace('EMP_CONT ::: LU ***** l_saving = '|| l_saving );
664: hr_utility.trace('EMP_CONT ::: LU ***** l_total_saving= '|| l_total_saving );
665: hr_utility.trace('EMP_CONT ::: LU ***** l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
666:
667: -- get the exceeding amount

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

660: hr_utility.trace('EMP_CONT ::: LU ***** l_normal_rate = '|| l_normal_rate );
661: hr_utility.trace('EMP_CONT ::: LU ***** l_high_rate = '|| l_high_rate );
662: hr_utility.trace('EMP_CONT ::: LU ***** l_diff_rate = '|| l_diff_rate );
663: hr_utility.trace('EMP_CONT ::: LU ***** l_saving = '|| l_saving );
664: hr_utility.trace('EMP_CONT ::: LU ***** l_total_saving= '|| l_total_saving );
665: hr_utility.trace('EMP_CONT ::: LU ***** l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
666:
667: -- get the exceeding amount
668: l_amount_over_limit := ((l_exemption_limit_used_yet + l_total_saving) - l_exemption_limit);

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

661: hr_utility.trace('EMP_CONT ::: LU ***** l_high_rate = '|| l_high_rate );
662: hr_utility.trace('EMP_CONT ::: LU ***** l_diff_rate = '|| l_diff_rate );
663: hr_utility.trace('EMP_CONT ::: LU ***** l_saving = '|| l_saving );
664: hr_utility.trace('EMP_CONT ::: LU ***** l_total_saving= '|| l_total_saving );
665: hr_utility.trace('EMP_CONT ::: LU ***** l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
666:
667: -- get the exceeding amount
668: l_amount_over_limit := ((l_exemption_limit_used_yet + l_total_saving) - l_exemption_limit);
669: l_base_over_limit := (l_amount_over_limit / l_diff_rate) * 100 ;

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

689: -- set the new l_total_saving
690:
691: l_total_saving := l_exemption_limit - l_exemption_limit_used_yet ;
692:
693: hr_utility.trace('EMP_CONT ::: LU ***** l_amount_over_limit = '|| l_amount_over_limit );
694: hr_utility.trace('EMP_CONT ::: LU ***** l_base_over_limit = '|| l_base_over_limit );
695: hr_utility.trace('EMP_CONT ::: LU ***** NEW bimonth base for current row = '|| g_tab_calc(i).bimonth_base );
696: hr_utility.trace('EMP_CONT ::: LU ***** NEW l_total_saving = '|| l_total_saving );
697:

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

690:
691: l_total_saving := l_exemption_limit - l_exemption_limit_used_yet ;
692:
693: hr_utility.trace('EMP_CONT ::: LU ***** l_amount_over_limit = '|| l_amount_over_limit );
694: hr_utility.trace('EMP_CONT ::: LU ***** l_base_over_limit = '|| l_base_over_limit );
695: hr_utility.trace('EMP_CONT ::: LU ***** NEW bimonth base for current row = '|| g_tab_calc(i).bimonth_base );
696: hr_utility.trace('EMP_CONT ::: LU ***** NEW l_total_saving = '|| l_total_saving );
697:
698: -- insert a new row for exceeded limit

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

691: l_total_saving := l_exemption_limit - l_exemption_limit_used_yet ;
692:
693: hr_utility.trace('EMP_CONT ::: LU ***** l_amount_over_limit = '|| l_amount_over_limit );
694: hr_utility.trace('EMP_CONT ::: LU ***** l_base_over_limit = '|| l_base_over_limit );
695: hr_utility.trace('EMP_CONT ::: LU ***** NEW bimonth base for current row = '|| g_tab_calc(i).bimonth_base );
696: hr_utility.trace('EMP_CONT ::: LU ***** NEW l_total_saving = '|| l_total_saving );
697:
698: -- insert a new row for exceeded limit
699:

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

692:
693: hr_utility.trace('EMP_CONT ::: LU ***** l_amount_over_limit = '|| l_amount_over_limit );
694: hr_utility.trace('EMP_CONT ::: LU ***** l_base_over_limit = '|| l_base_over_limit );
695: hr_utility.trace('EMP_CONT ::: LU ***** NEW bimonth base for current row = '|| g_tab_calc(i).bimonth_base );
696: hr_utility.trace('EMP_CONT ::: LU ***** NEW l_total_saving = '|| l_total_saving );
697:
698: -- insert a new row for exceeded limit
699:
700: g_tab_calc(11).zone := g_tab_calc(i).zone;

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

722: END LOOP; --end j loop
723:
724: l_LU_over_limit := 'Y'; -- indicating exemption limit on LU level is over
725:
726: --hr_utility.trace('EMP_CONT ::: LU ***** l_LU_over_limit Y' );
727: hr_utility.trace('EMP_CONT ::: LU ***** l_LU_over_limit = '||l_LU_over_limit );
728:
729: EXIT; -- exit loop i since no more check is required
730: END IF; -- end check if exemption limit exceeded

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

723:
724: l_LU_over_limit := 'Y'; -- indicating exemption limit on LU level is over
725:
726: --hr_utility.trace('EMP_CONT ::: LU ***** l_LU_over_limit Y' );
727: hr_utility.trace('EMP_CONT ::: LU ***** l_LU_over_limit = '||l_LU_over_limit );
728:
729: EXIT; -- exit loop i since no more check is required
730: END IF; -- end check if exemption limit exceeded
731:

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

740: -- from the total saving, removing exemption limit reported in the bimonth period
741: -- exemption limit used currently at LU level
742: l_exemption_limit_used := l_total_saving - l_bal_val_bimonth ;
743:
744: hr_utility.trace('EMP_CONT ::: LU ***** l_total_saving = '||l_total_saving );
745: hr_utility.trace('EMP_CONT ::: LU ***** l_bal_val_bimonth = '||l_bal_val_bimonth );
746: hr_utility.trace('EMP_CONT ::: LU ***** l_exemption_limit_used = '||l_exemption_limit_used );
747:
748: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');

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

741: -- exemption limit used currently at LU level
742: l_exemption_limit_used := l_total_saving - l_bal_val_bimonth ;
743:
744: hr_utility.trace('EMP_CONT ::: LU ***** l_total_saving = '||l_total_saving );
745: hr_utility.trace('EMP_CONT ::: LU ***** l_bal_val_bimonth = '||l_bal_val_bimonth );
746: hr_utility.trace('EMP_CONT ::: LU ***** l_exemption_limit_used = '||l_exemption_limit_used );
747:
748: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
749: l_check := display_table_calc(g_tab_calc);

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

742: l_exemption_limit_used := l_total_saving - l_bal_val_bimonth ;
743:
744: hr_utility.trace('EMP_CONT ::: LU ***** l_total_saving = '||l_total_saving );
745: hr_utility.trace('EMP_CONT ::: LU ***** l_bal_val_bimonth = '||l_bal_val_bimonth );
746: hr_utility.trace('EMP_CONT ::: LU ***** l_exemption_limit_used = '||l_exemption_limit_used );
747:
748: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
749: l_check := display_table_calc(g_tab_calc);
750: hr_utility.trace('EMP_CONT ::: -- returned from display_table_calc function ');

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

744: hr_utility.trace('EMP_CONT ::: LU ***** l_total_saving = '||l_total_saving );
745: hr_utility.trace('EMP_CONT ::: LU ***** l_bal_val_bimonth = '||l_bal_val_bimonth );
746: hr_utility.trace('EMP_CONT ::: LU ***** l_exemption_limit_used = '||l_exemption_limit_used );
747:
748: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
749: l_check := display_table_calc(g_tab_calc);
750: hr_utility.trace('EMP_CONT ::: -- returned from display_table_calc function ');
751:
752: hr_utility.trace('EMP_CONT ::: LU ***** applied differential rate and check exemption limit , leaving ' );

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

746: hr_utility.trace('EMP_CONT ::: LU ***** l_exemption_limit_used = '||l_exemption_limit_used );
747:
748: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
749: l_check := display_table_calc(g_tab_calc);
750: hr_utility.trace('EMP_CONT ::: -- returned from display_table_calc function ');
751:
752: hr_utility.trace('EMP_CONT ::: LU ***** applied differential rate and check exemption limit , leaving ' );
753: ------------------------------ applied differential rate and check exemption limit at LU Level
754:

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

748: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
749: l_check := display_table_calc(g_tab_calc);
750: hr_utility.trace('EMP_CONT ::: -- returned from display_table_calc function ');
751:
752: hr_utility.trace('EMP_CONT ::: LU ***** applied differential rate and check exemption limit , leaving ' );
753: ------------------------------ applied differential rate and check exemption limit at LU Level
754:
755: -- ec_main_calculation function call for LU
756: hr_utility.trace('EMP_CONT ::: LU ***** ec_main_calculation function call for LU , entering ' );

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

752: hr_utility.trace('EMP_CONT ::: LU ***** applied differential rate and check exemption limit , leaving ' );
753: ------------------------------ applied differential rate and check exemption limit at LU Level
754:
755: -- ec_main_calculation function call for LU
756: hr_utility.trace('EMP_CONT ::: LU ***** ec_main_calculation function call for LU , entering ' );
757:
758: l_main_index := ec_main_calculation (g_tab_calc
759: ,PAY_NO_EMP_CONT.g_tab_main
760: ,p_tax_unit_id

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

767: ,p_over_age_high_rate
768: ,l_curr_zone
769: ,l_curr_under_62 ) ;
770:
771: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
772: l_check := display_table_calc(g_tab_calc);
773: hr_utility.trace('EMP_CONT ::: -- returned from display_table_calc function ');
774:
775: hr_utility.trace('EMP_CONT ::: LU ***** ec_main_calculation function call for LU , leaving ' );

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

769: ,l_curr_under_62 ) ;
770:
771: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
772: l_check := display_table_calc(g_tab_calc);
773: hr_utility.trace('EMP_CONT ::: -- returned from display_table_calc function ');
774:
775: hr_utility.trace('EMP_CONT ::: LU ***** ec_main_calculation function call for LU , leaving ' );
776:
777: -- done all caclculation and entered values in the main table for next time usage

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

771: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
772: l_check := display_table_calc(g_tab_calc);
773: hr_utility.trace('EMP_CONT ::: -- returned from display_table_calc function ');
774:
775: hr_utility.trace('EMP_CONT ::: LU ***** ec_main_calculation function call for LU , leaving ' );
776:
777: -- done all caclculation and entered values in the main table for next time usage
778:
779: -- returning values at LU level

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

780: p_run_base := PAY_NO_EMP_CONT.g_tab_main(l_main_index).run_base;
781: p_run_contribution := PAY_NO_EMP_CONT.g_tab_main(l_main_index).run_contribution;
782: p_curr_exemption_limit_used := PAY_NO_EMP_CONT.g_tab_main(l_main_index).exemption_limit_used;
783:
784: hr_utility.trace('EMP_CONT ::: LU ***** l_main_index = '|| l_main_index );
785: hr_utility.trace('EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );
786: hr_utility.trace('EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );
787: hr_utility.trace('EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
788:

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

781: p_run_contribution := PAY_NO_EMP_CONT.g_tab_main(l_main_index).run_contribution;
782: p_curr_exemption_limit_used := PAY_NO_EMP_CONT.g_tab_main(l_main_index).exemption_limit_used;
783:
784: hr_utility.trace('EMP_CONT ::: LU ***** l_main_index = '|| l_main_index );
785: hr_utility.trace('EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );
786: hr_utility.trace('EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );
787: hr_utility.trace('EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
788:
789: hr_utility.trace('EMP_CONT ::: LU ***** Leaving procedure-----------------------------------');

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

782: p_curr_exemption_limit_used := PAY_NO_EMP_CONT.g_tab_main(l_main_index).exemption_limit_used;
783:
784: hr_utility.trace('EMP_CONT ::: LU ***** l_main_index = '|| l_main_index );
785: hr_utility.trace('EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );
786: hr_utility.trace('EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );
787: hr_utility.trace('EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
788:
789: hr_utility.trace('EMP_CONT ::: LU ***** Leaving procedure-----------------------------------');
790:

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

783:
784: hr_utility.trace('EMP_CONT ::: LU ***** l_main_index = '|| l_main_index );
785: hr_utility.trace('EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );
786: hr_utility.trace('EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );
787: hr_utility.trace('EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
788:
789: hr_utility.trace('EMP_CONT ::: LU ***** Leaving procedure-----------------------------------');
790:
791: RETURN 1; -- here return 1 , other values thru OUT parameters

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

785: hr_utility.trace('EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );
786: hr_utility.trace('EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );
787: hr_utility.trace('EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
788:
789: hr_utility.trace('EMP_CONT ::: LU ***** Leaving procedure-----------------------------------');
790:
791: RETURN 1; -- here return 1 , other values thru OUT parameters
792:
793: END IF; --end if l_le_lu_exists

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

795:
796: ELSE ---------------------------------------------------------------------------------------------------------------------------------
797: -- since LU is NOT report separately, check if LE -9999 combination exists
798:
799: hr_utility.trace('EMP_CONT ::: LU is not report separately');
800: hr_utility.trace('EMP_CONT ::: checking if LE exists');
801:
802: start_index_main := NVL (PAY_NO_EMP_CONT.g_tab_main.FIRST, 0) ;
803: end_index_main := NVL (PAY_NO_EMP_CONT.g_tab_main.LAST, 0) ;

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

796: ELSE ---------------------------------------------------------------------------------------------------------------------------------
797: -- since LU is NOT report separately, check if LE -9999 combination exists
798:
799: hr_utility.trace('EMP_CONT ::: LU is not report separately');
800: hr_utility.trace('EMP_CONT ::: checking if LE exists');
801:
802: start_index_main := NVL (PAY_NO_EMP_CONT.g_tab_main.FIRST, 0) ;
803: end_index_main := NVL (PAY_NO_EMP_CONT.g_tab_main.LAST, 0) ;
804: l_le_exists := FALSE;

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

814: THEN
815: l_le_exists := TRUE;
816: l_le_index := start_index_main;
817:
818: hr_utility.trace('EMP_CONT ::: LE exists');
819: hr_utility.trace('EMP_CONT ::: l_le_index = '||l_le_index);
820:
821: EXIT;
822: END IF;

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

815: l_le_exists := TRUE;
816: l_le_index := start_index_main;
817:
818: hr_utility.trace('EMP_CONT ::: LE exists');
819: hr_utility.trace('EMP_CONT ::: l_le_index = '||l_le_index);
820:
821: EXIT;
822: END IF;
823: start_index_main := start_index_main + 1;

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

831: p_run_base := PAY_NO_EMP_CONT.g_tab_main(l_le_index).run_base;
832: p_run_contribution := PAY_NO_EMP_CONT.g_tab_main(l_le_index).run_contribution;
833: p_curr_exemption_limit_used := 0; -- coz this value must have been returned before
834:
835: hr_utility.trace('EMP_CONT ::: LE #### LE already exists, so just returning vales' );
836: hr_utility.trace('EMP_CONT ::: LE #### l_le_index = '|| l_le_index );
837: hr_utility.trace('EMP_CONT ::: LE #### p_run_base = '|| p_run_base );
838: hr_utility.trace('EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );
839: hr_utility.trace('EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );

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

832: p_run_contribution := PAY_NO_EMP_CONT.g_tab_main(l_le_index).run_contribution;
833: p_curr_exemption_limit_used := 0; -- coz this value must have been returned before
834:
835: hr_utility.trace('EMP_CONT ::: LE #### LE already exists, so just returning vales' );
836: hr_utility.trace('EMP_CONT ::: LE #### l_le_index = '|| l_le_index );
837: hr_utility.trace('EMP_CONT ::: LE #### p_run_base = '|| p_run_base );
838: hr_utility.trace('EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );
839: hr_utility.trace('EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
840:

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

833: p_curr_exemption_limit_used := 0; -- coz this value must have been returned before
834:
835: hr_utility.trace('EMP_CONT ::: LE #### LE already exists, so just returning vales' );
836: hr_utility.trace('EMP_CONT ::: LE #### l_le_index = '|| l_le_index );
837: hr_utility.trace('EMP_CONT ::: LE #### p_run_base = '|| p_run_base );
838: hr_utility.trace('EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );
839: hr_utility.trace('EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
840:
841: hr_utility.trace('EMP_CONT ::: LE #### Leaving procedure-----------------------------------');

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

834:
835: hr_utility.trace('EMP_CONT ::: LE #### LE already exists, so just returning vales' );
836: hr_utility.trace('EMP_CONT ::: LE #### l_le_index = '|| l_le_index );
837: hr_utility.trace('EMP_CONT ::: LE #### p_run_base = '|| p_run_base );
838: hr_utility.trace('EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );
839: hr_utility.trace('EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
840:
841: hr_utility.trace('EMP_CONT ::: LE #### Leaving procedure-----------------------------------');
842:

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

835: hr_utility.trace('EMP_CONT ::: LE #### LE already exists, so just returning vales' );
836: hr_utility.trace('EMP_CONT ::: LE #### l_le_index = '|| l_le_index );
837: hr_utility.trace('EMP_CONT ::: LE #### p_run_base = '|| p_run_base );
838: hr_utility.trace('EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );
839: hr_utility.trace('EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
840:
841: hr_utility.trace('EMP_CONT ::: LE #### Leaving procedure-----------------------------------');
842:
843:

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

837: hr_utility.trace('EMP_CONT ::: LE #### p_run_base = '|| p_run_base );
838: hr_utility.trace('EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );
839: hr_utility.trace('EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
840:
841: hr_utility.trace('EMP_CONT ::: LE #### Leaving procedure-----------------------------------');
842:
843:
844: RETURN 1; -- here return le_run and the other values thru OUT parameters
845:

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

846: ELSE --------------------------------------------------------------------------------------------------------------------------
847: -- combination does not exist, calculation has to be done and values returned
848:
849: ---------- initializing the g_tab_calc table for LE and -9999 combination
850: hr_utility.trace('EMP_CONT ::: LE #### initializing the g_tab_calc , entering');
851:
852: OPEN PAY_NO_EMP_CONT.get_le_status(p_tax_unit_id);
853: FETCH PAY_NO_EMP_CONT.get_le_status INTO l_le_status;
854: CLOSE PAY_NO_EMP_CONT.get_le_status;

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

852: OPEN PAY_NO_EMP_CONT.get_le_status(p_tax_unit_id);
853: FETCH PAY_NO_EMP_CONT.get_le_status INTO l_le_status;
854: CLOSE PAY_NO_EMP_CONT.get_le_status;
855:
856: hr_utility.trace('EMP_CONT ::: LE #### l_le_status = '|| l_le_status );
857:
858: -- loop for each zone,under_62 commbination
859: FOR i IN 1..10 LOOP
860:

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

879: g_tab_calc(i).run_contribution := 0 ;
880:
881: END LOOP; -- end i loop
882:
883: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
884: l_check := display_table_calc(g_tab_calc);
885: hr_utility.trace('EMP_CONT ::: -- returned from display_table_calc function ');
886:
887: hr_utility.trace('EMP_CONT ::: LE #### finished initializing the g_tab_calc , leaving ');

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

881: END LOOP; -- end i loop
882:
883: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
884: l_check := display_table_calc(g_tab_calc);
885: hr_utility.trace('EMP_CONT ::: -- returned from display_table_calc function ');
886:
887: hr_utility.trace('EMP_CONT ::: LE #### finished initializing the g_tab_calc , leaving ');
888: ---------------- finished initializing the g_tab_lu table
889:

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

883: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
884: l_check := display_table_calc(g_tab_calc);
885: hr_utility.trace('EMP_CONT ::: -- returned from display_table_calc function ');
886:
887: hr_utility.trace('EMP_CONT ::: LE #### finished initializing the g_tab_calc , leaving ');
888: ---------------- finished initializing the g_tab_lu table
889:
890: ---------------- get exemption limit used for LE
891: hr_utility.trace('EMP_CONT ::: LE #### get exemption limit used for LE , entering');

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

887: hr_utility.trace('EMP_CONT ::: LE #### finished initializing the g_tab_calc , leaving ');
888: ---------------- finished initializing the g_tab_lu table
889:
890: ---------------- get exemption limit used for LE
891: hr_utility.trace('EMP_CONT ::: LE #### get exemption limit used for LE , entering');
892:
893: -- set the context values for balance
894: -- change 1b
895: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);

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

898: -- get defined balance ids
899: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_YTD') ;
900: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_BIMONTH') ;
901:
902: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_1 = '|| l_def_bal_id_1 );
903: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_2 = '|| l_def_bal_id_2 );
904:
905: -- get the balance value
906: 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 903: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_2 = '|| l_def_bal_id_2 );

899: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_YTD') ;
900: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_BIMONTH') ;
901:
902: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_1 = '|| l_def_bal_id_1 );
903: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_2 = '|| l_def_bal_id_2 );
904:
905: -- get the balance value
906: 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);
907: 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 914: hr_utility.trace('EMP_CONT ::: LE #### l_bal_val_ytd = '|| l_bal_val_ytd );

910: --l_bal_val_bimonth := 0 ;
911:
912: l_exemption_limit_used_yet := l_bal_val_ytd - l_bal_val_bimonth ;
913:
914: hr_utility.trace('EMP_CONT ::: LE #### l_bal_val_ytd = '|| l_bal_val_ytd );
915: hr_utility.trace('EMP_CONT ::: LE #### l_bal_val_bimonth = '|| l_bal_val_bimonth );
916: hr_utility.trace('EMP_CONT ::: LE #### l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
917:
918: OPEN PAY_NO_EMP_CONT.csr_get_exemption_limit(p_tax_unit_id ,p_date_earned );

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

911:
912: l_exemption_limit_used_yet := l_bal_val_ytd - l_bal_val_bimonth ;
913:
914: hr_utility.trace('EMP_CONT ::: LE #### l_bal_val_ytd = '|| l_bal_val_ytd );
915: hr_utility.trace('EMP_CONT ::: LE #### l_bal_val_bimonth = '|| l_bal_val_bimonth );
916: hr_utility.trace('EMP_CONT ::: LE #### l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
917:
918: OPEN PAY_NO_EMP_CONT.csr_get_exemption_limit(p_tax_unit_id ,p_date_earned );
919: FETCH PAY_NO_EMP_CONT.csr_get_exemption_limit INTO l_exemption_limit ;

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

912: l_exemption_limit_used_yet := l_bal_val_ytd - l_bal_val_bimonth ;
913:
914: hr_utility.trace('EMP_CONT ::: LE #### l_bal_val_ytd = '|| l_bal_val_ytd );
915: hr_utility.trace('EMP_CONT ::: LE #### l_bal_val_bimonth = '|| l_bal_val_bimonth );
916: hr_utility.trace('EMP_CONT ::: LE #### l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
917:
918: OPEN PAY_NO_EMP_CONT.csr_get_exemption_limit(p_tax_unit_id ,p_date_earned );
919: FETCH PAY_NO_EMP_CONT.csr_get_exemption_limit INTO l_exemption_limit ;
920: CLOSE PAY_NO_EMP_CONT.csr_get_exemption_limit;

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

925: ELSE
926: l_LE_over_limit := 'N';
927: END IF ; -- end if exemption limit check
928:
929: hr_utility.trace('EMP_CONT ::: LE #### l_exemption_limit = '|| l_exemption_limit );
930: hr_utility.trace('EMP_CONT ::: LE #### l_LE_over_limit = '|| l_LE_over_limit );
931: hr_utility.trace('EMP_CONT ::: LE #### got exemption limit used for LE , leaving ');
932: ------------------- got exemption limit used for LE
933:

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

926: l_LE_over_limit := 'N';
927: END IF ; -- end if exemption limit check
928:
929: hr_utility.trace('EMP_CONT ::: LE #### l_exemption_limit = '|| l_exemption_limit );
930: hr_utility.trace('EMP_CONT ::: LE #### l_LE_over_limit = '|| l_LE_over_limit );
931: hr_utility.trace('EMP_CONT ::: LE #### got exemption limit used for LE , leaving ');
932: ------------------- got exemption limit used for LE
933:
934: ------------------ populating the tables g_lu_tab (LU) and g_mu_tab (MU)

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

927: END IF ; -- end if exemption limit check
928:
929: hr_utility.trace('EMP_CONT ::: LE #### l_exemption_limit = '|| l_exemption_limit );
930: hr_utility.trace('EMP_CONT ::: LE #### l_LE_over_limit = '|| l_LE_over_limit );
931: hr_utility.trace('EMP_CONT ::: LE #### got exemption limit used for LE , leaving ');
932: ------------------- got exemption limit used for LE
933:
934: ------------------ populating the tables g_lu_tab (LU) and g_mu_tab (MU)
935: hr_utility.trace('EMP_CONT ::: LE #### populating the tables g_lu_tab and g_mu_tab , entering');

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

931: hr_utility.trace('EMP_CONT ::: LE #### got exemption limit used for LE , leaving ');
932: ------------------- got exemption limit used for LE
933:
934: ------------------ populating the tables g_lu_tab (LU) and g_mu_tab (MU)
935: hr_utility.trace('EMP_CONT ::: LE #### populating the tables g_lu_tab and g_mu_tab , entering');
936:
937: l_temp := populate_tables
938: (p_tax_unit_id
939: ,p_payroll_id

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

940: ,p_date_earned
941: ,g_lu_tab
942: ,g_mu_tab );
943:
944: hr_utility.trace('EMP_CONT ::: LE #### populating the tables g_lu_tab and g_mu_tab, leaving ');
945:
946: -------------------- Fetch the run base using assignment level balances (at LE level)
947: hr_utility.trace('EMP_CONT ::: LE #### Fetch the run base using assignment level balances , entering');
948:

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

943:
944: hr_utility.trace('EMP_CONT ::: LE #### populating the tables g_lu_tab and g_mu_tab, leaving ');
945:
946: -------------------- Fetch the run base using assignment level balances (at LE level)
947: hr_utility.trace('EMP_CONT ::: LE #### Fetch the run base using assignment level balances , entering');
948:
949: -- get defined balance ids
950: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Base','_ASG_TU_MU_LU_BIMONTH') ;
951: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution Base 2','_ASG_TU_MU_LU_BIMONTH') ;

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

952:
953: l_def_bal_id_3 := get_defined_balance_id('Employer Contribution Over 62 Base','_ASG_TU_MU_LU_BIMONTH') ;
954: l_def_bal_id_4 := get_defined_balance_id('Employer Contribution Over 62 Base 2','_ASG_TU_MU_LU_BIMONTH') ;
955:
956: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_1 = '|| l_def_bal_id_1 );
957: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_2 = '|| l_def_bal_id_2 );
958: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_3 = '|| l_def_bal_id_3 );
959: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_4 = '|| l_def_bal_id_4 );
960:

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

953: l_def_bal_id_3 := get_defined_balance_id('Employer Contribution Over 62 Base','_ASG_TU_MU_LU_BIMONTH') ;
954: l_def_bal_id_4 := get_defined_balance_id('Employer Contribution Over 62 Base 2','_ASG_TU_MU_LU_BIMONTH') ;
955:
956: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_1 = '|| l_def_bal_id_1 );
957: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_2 = '|| l_def_bal_id_2 );
958: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_3 = '|| l_def_bal_id_3 );
959: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_4 = '|| l_def_bal_id_4 );
960:
961: ----- test only , Remove it

Line 958: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_3 = '|| l_def_bal_id_3 );

954: l_def_bal_id_4 := get_defined_balance_id('Employer Contribution Over 62 Base 2','_ASG_TU_MU_LU_BIMONTH') ;
955:
956: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_1 = '|| l_def_bal_id_1 );
957: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_2 = '|| l_def_bal_id_2 );
958: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_3 = '|| l_def_bal_id_3 );
959: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_4 = '|| l_def_bal_id_4 );
960:
961: ----- test only , Remove it
962: OPEN csr_test_aag_act_id (p_tax_unit_id , p_payroll_action_id, p_date_earned);

Line 959: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_4 = '|| l_def_bal_id_4 );

955:
956: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_1 = '|| l_def_bal_id_1 );
957: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_2 = '|| l_def_bal_id_2 );
958: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_3 = '|| l_def_bal_id_3 );
959: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_4 = '|| l_def_bal_id_4 );
960:
961: ----- test only , Remove it
962: OPEN csr_test_aag_act_id (p_tax_unit_id , p_payroll_action_id, p_date_earned);
963: FETCH csr_test_aag_act_id INTO l_check2;

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

961: ----- test only , Remove it
962: OPEN csr_test_aag_act_id (p_tax_unit_id , p_payroll_action_id, p_date_earned);
963: FETCH csr_test_aag_act_id INTO l_check2;
964: CLOSE csr_test_aag_act_id;
965: hr_utility.trace('EMP_CONT ::: LE #### l_check2 , no of rows returned by asg act id cursor = '||l_check2 );
966: -- remove till here
967:
968: hr_utility.trace('EMP_CONT ::: LE #### level 0 leave' );
969:

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

964: CLOSE csr_test_aag_act_id;
965: hr_utility.trace('EMP_CONT ::: LE #### l_check2 , no of rows returned by asg act id cursor = '||l_check2 );
966: -- remove till here
967:
968: hr_utility.trace('EMP_CONT ::: LE #### level 0 leave' );
969:
970: -- change 2b -1
971: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
972: ----

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

973:
974: -- loop to get all assignment_action_id in the current payroll_action_id
975: FOR csr1_rec IN csr_curr_le_asg_act_id (p_tax_unit_id , p_payroll_action_id, p_date_earned) LOOP
976:
977: hr_utility.trace('EMP_CONT ::: LE #### level 1 , loop csr_curr_le_asg_act_id ' );
978:
979: start_index_lu := NVL (g_lu_tab.FIRST, 0) ;
980: end_index_lu := NVL (g_lu_tab.LAST, 0) ;
981:

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

980: end_index_lu := NVL (g_lu_tab.LAST, 0) ;
981:
982: WHILE (g_lu_tab.EXISTS(start_index_lu)) and (start_index_lu <= end_index_lu) LOOP
983:
984: hr_utility.trace('EMP_CONT ::: LE #### level 2, g_lu_tab ' );
985:
986: start_index_mu := NVL (g_mu_tab.FIRST, 0) ;
987: end_index_mu := NVL (g_mu_tab.LAST, 0) ;
988:

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

991: -----
992:
993: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
994:
995: hr_utility.trace('EMP_CONT ::: LE #### level 3, g_mu_tab ' );
996: hr_utility.trace('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) );
997:
998: --setting the context values
999: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);

Line 996: hr_utility.trace('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) );

992:
993: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
994:
995: hr_utility.trace('EMP_CONT ::: LE #### level 3, g_mu_tab ' );
996: hr_utility.trace('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) );
997:
998: --setting the context values
999: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
1000: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));

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

1010: l_asg_ers_base_diff := l_asg_ers_base - l_asg_ers_base2;
1011:
1012: l_asg_ers_over_62_base_diff := l_asg_ers_over_62_base - l_asg_ers_over_62_base2;
1013:
1014: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_base = '|| l_asg_ers_base );
1015: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_base2 = '|| l_asg_ers_base2 );
1016: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_over_62_base = '|| l_asg_ers_over_62_base );
1017: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_over_62_base2 = '|| l_asg_ers_over_62_base2 );
1018: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_base_diff = '|| l_asg_ers_base_diff );

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

1011:
1012: l_asg_ers_over_62_base_diff := l_asg_ers_over_62_base - l_asg_ers_over_62_base2;
1013:
1014: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_base = '|| l_asg_ers_base );
1015: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_base2 = '|| l_asg_ers_base2 );
1016: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_over_62_base = '|| l_asg_ers_over_62_base );
1017: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_over_62_base2 = '|| l_asg_ers_over_62_base2 );
1018: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_base_diff = '|| l_asg_ers_base_diff );
1019: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_over_62_base_diff = '||l_asg_ers_over_62_base_diff );

Line 1016: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_over_62_base = '|| l_asg_ers_over_62_base );

1012: l_asg_ers_over_62_base_diff := l_asg_ers_over_62_base - l_asg_ers_over_62_base2;
1013:
1014: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_base = '|| l_asg_ers_base );
1015: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_base2 = '|| l_asg_ers_base2 );
1016: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_over_62_base = '|| l_asg_ers_over_62_base );
1017: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_over_62_base2 = '|| l_asg_ers_over_62_base2 );
1018: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_base_diff = '|| l_asg_ers_base_diff );
1019: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_over_62_base_diff = '||l_asg_ers_over_62_base_diff );
1020:

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

1013:
1014: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_base = '|| l_asg_ers_base );
1015: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_base2 = '|| l_asg_ers_base2 );
1016: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_over_62_base = '|| l_asg_ers_over_62_base );
1017: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_over_62_base2 = '|| l_asg_ers_over_62_base2 );
1018: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_base_diff = '|| l_asg_ers_base_diff );
1019: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_over_62_base_diff = '||l_asg_ers_over_62_base_diff );
1020:
1021: --l_under_62 := check_under_62(p_asg_act_id,p_date_earned);

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

1014: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_base = '|| l_asg_ers_base );
1015: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_base2 = '|| l_asg_ers_base2 );
1016: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_over_62_base = '|| l_asg_ers_over_62_base );
1017: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_over_62_base2 = '|| l_asg_ers_over_62_base2 );
1018: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_base_diff = '|| l_asg_ers_base_diff );
1019: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_over_62_base_diff = '||l_asg_ers_over_62_base_diff );
1020:
1021: --l_under_62 := check_under_62(p_asg_act_id,p_date_earned);
1022: hr_utility.trace('EMP_CONT ::: LE #### ============== just checking================= ');

Line 1019: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_over_62_base_diff = '||l_asg_ers_over_62_base_diff );

1015: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_base2 = '|| l_asg_ers_base2 );
1016: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_over_62_base = '|| l_asg_ers_over_62_base );
1017: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_over_62_base2 = '|| l_asg_ers_over_62_base2 );
1018: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_base_diff = '|| l_asg_ers_base_diff );
1019: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_over_62_base_diff = '||l_asg_ers_over_62_base_diff );
1020:
1021: --l_under_62 := check_under_62(p_asg_act_id,p_date_earned);
1022: hr_utility.trace('EMP_CONT ::: LE #### ============== just checking================= ');
1023:

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

1018: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_base_diff = '|| l_asg_ers_base_diff );
1019: hr_utility.trace('EMP_CONT ::: LE #### l_asg_ers_over_62_base_diff = '||l_asg_ers_over_62_base_diff );
1020:
1021: --l_under_62 := check_under_62(p_asg_act_id,p_date_earned);
1022: hr_utility.trace('EMP_CONT ::: LE #### ============== just checking================= ');
1023:
1024: hr_utility.trace('EMP_CONT ::: LE #### g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
1025:
1026: l_zone_temp := to_char(g_mu_tab(start_index_mu));

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

1020:
1021: --l_under_62 := check_under_62(p_asg_act_id,p_date_earned);
1022: hr_utility.trace('EMP_CONT ::: LE #### ============== just checking================= ');
1023:
1024: hr_utility.trace('EMP_CONT ::: LE #### g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
1025:
1026: l_zone_temp := to_char(g_mu_tab(start_index_mu));
1027:
1028: hr_utility.trace('EMP_CONT ::: LE #### l_zone_temp = '|| l_zone_temp );

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

1024: hr_utility.trace('EMP_CONT ::: LE #### g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
1025:
1026: l_zone_temp := to_char(g_mu_tab(start_index_mu));
1027:
1028: hr_utility.trace('EMP_CONT ::: LE #### l_zone_temp = '|| l_zone_temp );
1029:
1030: -- l_zone := to_number(substr(get_lookup_meaning('NO_TAX_MUNICIPALITY',l_zone_temp),1,1));
1031: -- Tax Municipality for Norway has been moved to User Table NO_TAX_MUNICIPALITY
1032: -- The zone for a Tax Municipality will now be fetched from the user table

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

1031: -- Tax Municipality for Norway has been moved to User Table NO_TAX_MUNICIPALITY
1032: -- The zone for a Tax Municipality will now be fetched from the user table
1033: l_zone := fnd_number.canonical_to_number(hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', l_zone_temp, p_date_earned )) ;
1034:
1035: hr_utility.trace('EMP_CONT ::: LE #### l_zone = '|| l_zone );
1036:
1037: l_cell := lookup_cell(g_tab_calc,'Y',l_zone);
1038: g_tab_calc(l_cell).run_base := g_tab_calc(l_cell).run_base + l_asg_ers_base_diff ;
1039:

Line 1040: hr_utility.trace('EMP_CONT ::: LE #### l_cell below 62 = '|| l_cell );

1036:
1037: l_cell := lookup_cell(g_tab_calc,'Y',l_zone);
1038: g_tab_calc(l_cell).run_base := g_tab_calc(l_cell).run_base + l_asg_ers_base_diff ;
1039:
1040: hr_utility.trace('EMP_CONT ::: LE #### l_cell below 62 = '|| l_cell );
1041:
1042: l_cell := lookup_cell(g_tab_calc,'N',l_zone);
1043: g_tab_calc(l_cell).run_base := g_tab_calc(l_cell).run_base + l_asg_ers_over_62_base_diff ;
1044:

Line 1045: hr_utility.trace('EMP_CONT ::: LE #### l_cell above 62 = '|| l_cell );

1041:
1042: l_cell := lookup_cell(g_tab_calc,'N',l_zone);
1043: g_tab_calc(l_cell).run_base := g_tab_calc(l_cell).run_base + l_asg_ers_over_62_base_diff ;
1044:
1045: hr_utility.trace('EMP_CONT ::: LE #### l_cell above 62 = '|| l_cell );
1046:
1047: start_index_mu := start_index_mu + 1;
1048: END LOOP; -- end while loop g_mu_tab
1049:

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

1051: END LOOP; -- end while loop g_lu_tab
1052:
1053: END LOOP; -- end loop csr1_rec
1054:
1055: hr_utility.trace('EMP_CONT ::: LE #### level 0 back' );
1056:
1057: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
1058: l_check := display_table_calc(g_tab_calc);
1059: hr_utility.trace('EMP_CONT ::: -- returned from display_table_calc function ');

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

1053: END LOOP; -- end loop csr1_rec
1054:
1055: hr_utility.trace('EMP_CONT ::: LE #### level 0 back' );
1056:
1057: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
1058: l_check := display_table_calc(g_tab_calc);
1059: hr_utility.trace('EMP_CONT ::: -- returned from display_table_calc function ');
1060:
1061: hr_utility.trace('EMP_CONT ::: LE #### Fetched the run base using assignment level balances , leaving');

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

1055: hr_utility.trace('EMP_CONT ::: LE #### level 0 back' );
1056:
1057: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
1058: l_check := display_table_calc(g_tab_calc);
1059: hr_utility.trace('EMP_CONT ::: -- returned from display_table_calc function ');
1060:
1061: hr_utility.trace('EMP_CONT ::: LE #### Fetched the run base using assignment level balances , leaving');
1062: -------------------- Fetched the run base using assignment level balances (at LE level)
1063:

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

1057: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
1058: l_check := display_table_calc(g_tab_calc);
1059: hr_utility.trace('EMP_CONT ::: -- returned from display_table_calc function ');
1060:
1061: hr_utility.trace('EMP_CONT ::: LE #### Fetched the run base using assignment level balances , leaving');
1062: -------------------- Fetched the run base using assignment level balances (at LE level)
1063:
1064: -------------------- Fetch the bimonth base using group level balances (at LE level)
1065: hr_utility.trace('EMP_CONT ::: LE #### Fetch the bimonth base using group level balances , entering');

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

1061: hr_utility.trace('EMP_CONT ::: LE #### Fetched the run base using assignment level balances , leaving');
1062: -------------------- Fetched the run base using assignment level balances (at LE level)
1063:
1064: -------------------- Fetch the bimonth base using group level balances (at LE level)
1065: hr_utility.trace('EMP_CONT ::: LE #### Fetch the bimonth base using group level balances , entering');
1066:
1067: -- get defined balance ids
1068: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Base','_TU_MU_LU_BIMONTH') ;
1069: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution','_TU_MU_LU_BIMONTH') ;

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

1070:
1071: l_def_bal_id_3 := get_defined_balance_id('Employer Contribution Over 62 Base','_TU_MU_LU_BIMONTH') ;
1072: l_def_bal_id_4 := get_defined_balance_id('Employer Contribution Over 62','_TU_MU_LU_BIMONTH') ;
1073:
1074: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_1 = '|| l_def_bal_id_1 );
1075: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_2 = '|| l_def_bal_id_2 );
1076: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_3 = '|| l_def_bal_id_3 );
1077: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_4 = '|| l_def_bal_id_4 );
1078:

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

1071: l_def_bal_id_3 := get_defined_balance_id('Employer Contribution Over 62 Base','_TU_MU_LU_BIMONTH') ;
1072: l_def_bal_id_4 := get_defined_balance_id('Employer Contribution Over 62','_TU_MU_LU_BIMONTH') ;
1073:
1074: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_1 = '|| l_def_bal_id_1 );
1075: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_2 = '|| l_def_bal_id_2 );
1076: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_3 = '|| l_def_bal_id_3 );
1077: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_4 = '|| l_def_bal_id_4 );
1078:
1079: -- loop to get all LU in g_lu_tab

Line 1076: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_3 = '|| l_def_bal_id_3 );

1072: l_def_bal_id_4 := get_defined_balance_id('Employer Contribution Over 62','_TU_MU_LU_BIMONTH') ;
1073:
1074: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_1 = '|| l_def_bal_id_1 );
1075: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_2 = '|| l_def_bal_id_2 );
1076: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_3 = '|| l_def_bal_id_3 );
1077: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_4 = '|| l_def_bal_id_4 );
1078:
1079: -- loop to get all LU in g_lu_tab
1080:

Line 1077: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_4 = '|| l_def_bal_id_4 );

1073:
1074: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_1 = '|| l_def_bal_id_1 );
1075: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_2 = '|| l_def_bal_id_2 );
1076: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_3 = '|| l_def_bal_id_3 );
1077: hr_utility.trace('EMP_CONT ::: LE #### l_def_bal_id_4 = '|| l_def_bal_id_4 );
1078:
1079: -- loop to get all LU in g_lu_tab
1080:
1081: start_index_lu := NVL (g_lu_tab.FIRST, 0) ;

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

1080:
1081: start_index_lu := NVL (g_lu_tab.FIRST, 0) ;
1082: end_index_lu := NVL (g_lu_tab.LAST, 0) ;
1083:
1084: hr_utility.trace('EMP_CONT ::: LE #### level 0 leave ' );
1085:
1086: -- change 3b -1
1087: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
1088: ----

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

1088: ----
1089:
1090: WHILE (g_lu_tab.EXISTS(start_index_lu)) and (start_index_lu <= end_index_lu) LOOP
1091:
1092: hr_utility.trace('EMP_CONT ::: LE #### level 1 ,g_lu_tab ' );
1093:
1094: -- loop to get all MU in g_mu_tab
1095: start_index_mu := NVL (g_mu_tab.FIRST, 0) ;
1096: end_index_mu := NVL (g_mu_tab.LAST, 0) ;

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

1100: ----
1101:
1102: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
1103:
1104: hr_utility.trace('EMP_CONT ::: LE #### level 2 ,g_mu_tab ' );
1105:
1106: hr_utility.trace('EMP_CONT ::: LE #### MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| g_lu_tab(start_index_lu) );
1107:
1108: --setting the context values

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

1102: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
1103:
1104: hr_utility.trace('EMP_CONT ::: LE #### level 2 ,g_mu_tab ' );
1105:
1106: hr_utility.trace('EMP_CONT ::: LE #### MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| g_lu_tab(start_index_lu) );
1107:
1108: --setting the context values
1109: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
1110: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));

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

1116:
1117: l_le_ers_over_62_base := pay_balance_pkg.get_value(l_def_bal_id_3,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
1118: l_le_ers_over_62 := pay_balance_pkg.get_value(l_def_bal_id_4,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
1119:
1120: hr_utility.trace('EMP_CONT ::: LE #### l_le_ers_base = '|| l_le_ers_base);
1121: hr_utility.trace('EMP_CONT ::: LE #### l_le_ers = '||l_le_ers );
1122: hr_utility.trace('EMP_CONT ::: LE #### l_le_ers_over_62_base = '|| l_le_ers_over_62_base );
1123: hr_utility.trace('EMP_CONT ::: LE #### l_le_ers_over_62 = '|| l_le_ers_over_62 );
1124:

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

1117: l_le_ers_over_62_base := pay_balance_pkg.get_value(l_def_bal_id_3,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
1118: l_le_ers_over_62 := pay_balance_pkg.get_value(l_def_bal_id_4,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
1119:
1120: hr_utility.trace('EMP_CONT ::: LE #### l_le_ers_base = '|| l_le_ers_base);
1121: hr_utility.trace('EMP_CONT ::: LE #### l_le_ers = '||l_le_ers );
1122: hr_utility.trace('EMP_CONT ::: LE #### l_le_ers_over_62_base = '|| l_le_ers_over_62_base );
1123: hr_utility.trace('EMP_CONT ::: LE #### l_le_ers_over_62 = '|| l_le_ers_over_62 );
1124:
1125: hr_utility.trace('EMP_CONT ::: LE #### ============== just checking again ================= ');

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

1118: l_le_ers_over_62 := pay_balance_pkg.get_value(l_def_bal_id_4,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
1119:
1120: hr_utility.trace('EMP_CONT ::: LE #### l_le_ers_base = '|| l_le_ers_base);
1121: hr_utility.trace('EMP_CONT ::: LE #### l_le_ers = '||l_le_ers );
1122: hr_utility.trace('EMP_CONT ::: LE #### l_le_ers_over_62_base = '|| l_le_ers_over_62_base );
1123: hr_utility.trace('EMP_CONT ::: LE #### l_le_ers_over_62 = '|| l_le_ers_over_62 );
1124:
1125: hr_utility.trace('EMP_CONT ::: LE #### ============== just checking again ================= ');
1126:

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

1119:
1120: hr_utility.trace('EMP_CONT ::: LE #### l_le_ers_base = '|| l_le_ers_base);
1121: hr_utility.trace('EMP_CONT ::: LE #### l_le_ers = '||l_le_ers );
1122: hr_utility.trace('EMP_CONT ::: LE #### l_le_ers_over_62_base = '|| l_le_ers_over_62_base );
1123: hr_utility.trace('EMP_CONT ::: LE #### l_le_ers_over_62 = '|| l_le_ers_over_62 );
1124:
1125: hr_utility.trace('EMP_CONT ::: LE #### ============== just checking again ================= ');
1126:
1127: hr_utility.trace('EMP_CONT ::: LE #### g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );

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

1121: hr_utility.trace('EMP_CONT ::: LE #### l_le_ers = '||l_le_ers );
1122: hr_utility.trace('EMP_CONT ::: LE #### l_le_ers_over_62_base = '|| l_le_ers_over_62_base );
1123: hr_utility.trace('EMP_CONT ::: LE #### l_le_ers_over_62 = '|| l_le_ers_over_62 );
1124:
1125: hr_utility.trace('EMP_CONT ::: LE #### ============== just checking again ================= ');
1126:
1127: hr_utility.trace('EMP_CONT ::: LE #### g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
1128:
1129: l_zone_temp := to_char(g_mu_tab(start_index_mu));

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

1123: hr_utility.trace('EMP_CONT ::: LE #### l_le_ers_over_62 = '|| l_le_ers_over_62 );
1124:
1125: hr_utility.trace('EMP_CONT ::: LE #### ============== just checking again ================= ');
1126:
1127: hr_utility.trace('EMP_CONT ::: LE #### g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
1128:
1129: l_zone_temp := to_char(g_mu_tab(start_index_mu));
1130:
1131: hr_utility.trace('EMP_CONT ::: LE #### l_zone_temp = '|| l_zone_temp );

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

1127: hr_utility.trace('EMP_CONT ::: LE #### g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
1128:
1129: l_zone_temp := to_char(g_mu_tab(start_index_mu));
1130:
1131: hr_utility.trace('EMP_CONT ::: LE #### l_zone_temp = '|| l_zone_temp );
1132:
1133: -- l_zone := to_number(substr(get_lookup_meaning('NO_TAX_MUNICIPALITY',l_zone_temp),1,1));
1134: -- Tax Municipality for Norway has been moved to User Table NO_TAX_MUNICIPALITY
1135: -- The zone for a Tax Municipality will now be fetched from the user table

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

1134: -- Tax Municipality for Norway has been moved to User Table NO_TAX_MUNICIPALITY
1135: -- The zone for a Tax Municipality will now be fetched from the user table
1136: l_zone := fnd_number.canonical_to_number(hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', p_jurisdiction_code, p_date_earned )) ;
1137:
1138: hr_utility.trace('EMP_CONT ::: LE #### l_zone = '|| l_zone );
1139:
1140: l_cell := lookup_cell(g_tab_calc,'Y',l_zone);
1141: g_tab_calc(l_cell).bimonth_base := g_tab_calc(l_cell).bimonth_base + l_le_ers_base ;
1142: g_tab_calc(l_cell).bimonth_contribution_todate := g_tab_calc(l_cell).bimonth_contribution_todate + l_le_ers ;

Line 1144: hr_utility.trace('EMP_CONT ::: LE #### l_cell below 62 = '|| l_cell );

1140: l_cell := lookup_cell(g_tab_calc,'Y',l_zone);
1141: g_tab_calc(l_cell).bimonth_base := g_tab_calc(l_cell).bimonth_base + l_le_ers_base ;
1142: g_tab_calc(l_cell).bimonth_contribution_todate := g_tab_calc(l_cell).bimonth_contribution_todate + l_le_ers ;
1143:
1144: hr_utility.trace('EMP_CONT ::: LE #### l_cell below 62 = '|| l_cell );
1145:
1146: l_cell := lookup_cell(g_tab_calc,'N',l_zone);
1147: g_tab_calc(l_cell).bimonth_base := g_tab_calc(l_cell).bimonth_base + l_le_ers_over_62_base ;
1148: g_tab_calc(l_cell).bimonth_contribution_todate := g_tab_calc(l_cell).bimonth_contribution_todate + l_le_ers_over_62 ;

Line 1150: hr_utility.trace('EMP_CONT ::: LE #### l_cell above 62 = '|| l_cell );

1146: l_cell := lookup_cell(g_tab_calc,'N',l_zone);
1147: g_tab_calc(l_cell).bimonth_base := g_tab_calc(l_cell).bimonth_base + l_le_ers_over_62_base ;
1148: g_tab_calc(l_cell).bimonth_contribution_todate := g_tab_calc(l_cell).bimonth_contribution_todate + l_le_ers_over_62 ;
1149:
1150: hr_utility.trace('EMP_CONT ::: LE #### l_cell above 62 = '|| l_cell );
1151:
1152: start_index_mu := start_index_mu + 1;
1153: END LOOP; -- end while loop g_mu_tab
1154:

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

1154:
1155: start_index_lu := start_index_lu + 1;
1156: END LOOP; -- end while loop g_lu_tab
1157:
1158: hr_utility.trace('EMP_CONT ::: LE #### level 0 back' );
1159:
1160: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
1161: l_check := display_table_calc(g_tab_calc);
1162: hr_utility.trace('EMP_CONT ::: -- returned from display_table_calc function ');

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

1156: END LOOP; -- end while loop g_lu_tab
1157:
1158: hr_utility.trace('EMP_CONT ::: LE #### level 0 back' );
1159:
1160: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
1161: l_check := display_table_calc(g_tab_calc);
1162: hr_utility.trace('EMP_CONT ::: -- returned from display_table_calc function ');
1163:
1164: hr_utility.trace('EMP_CONT ::: LE #### Fetch the bimonth base using group level balances , leaving ');

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

1158: hr_utility.trace('EMP_CONT ::: LE #### level 0 back' );
1159:
1160: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
1161: l_check := display_table_calc(g_tab_calc);
1162: hr_utility.trace('EMP_CONT ::: -- returned from display_table_calc function ');
1163:
1164: hr_utility.trace('EMP_CONT ::: LE #### Fetch the bimonth base using group level balances , leaving ');
1165: -------------------- Fetched the bimonth base using group level balances (at LE level)
1166:

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

1160: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
1161: l_check := display_table_calc(g_tab_calc);
1162: hr_utility.trace('EMP_CONT ::: -- returned from display_table_calc function ');
1163:
1164: hr_utility.trace('EMP_CONT ::: LE #### Fetch the bimonth base using group level balances , leaving ');
1165: -------------------- Fetched the bimonth base using group level balances (at LE level)
1166:
1167: ------------------------------ apply differential rate and check exemption limit at LE Level
1168: hr_utility.trace('EMP_CONT ::: LE #### apply differential rate and check exemption limit , entering ');

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

1164: hr_utility.trace('EMP_CONT ::: LE #### Fetch the bimonth base using group level balances , leaving ');
1165: -------------------- Fetched the bimonth base using group level balances (at LE level)
1166:
1167: ------------------------------ apply differential rate and check exemption limit at LE Level
1168: hr_utility.trace('EMP_CONT ::: LE #### apply differential rate and check exemption limit , entering ');
1169:
1170: --l_lu_status --status for LU
1171: --l_le_status --status for LE
1172: l_total_saving := 0;

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

1174: -- check if exemption limit already used up
1175: IF l_LE_over_limit = 'Y'
1176:
1177: THEN
1178: hr_utility.trace('EMP_CONT ::: LE #### l_LE_over_limit = Y ' );
1179:
1180: -- as limit is over, put under_limit as N for all rows
1181: FOR i IN 1..10 LOOP
1182: g_tab_calc(i).under_limit := 'N';

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

1181: FOR i IN 1..10 LOOP
1182: g_tab_calc(i).under_limit := 'N';
1183: END LOOP; -- end i loop
1184:
1185: hr_utility.trace('EMP_CONT ::: LE #### as limit is over, put under_limit as N for all rows ');
1186:
1187: ELSE
1188: hr_utility.trace('EMP_CONT ::: LE #### l_LE_over_limit = N ' );
1189:

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

1184:
1185: hr_utility.trace('EMP_CONT ::: LE #### as limit is over, put under_limit as N for all rows ');
1186:
1187: ELSE
1188: hr_utility.trace('EMP_CONT ::: LE #### l_LE_over_limit = N ' );
1189:
1190: -- limit is not over
1191: -- perform exemption limit check only if status = OF,HF
1192: IF ((l_le_status = 'OF') or (l_le_status = 'HF'))

Line 1194: hr_utility.trace('EMP_CONT ::: LE #### status is OF or HF = '|| l_le_status );

1190: -- limit is not over
1191: -- perform exemption limit check only if status = OF,HF
1192: IF ((l_le_status = 'OF') or (l_le_status = 'HF'))
1193: THEN
1194: hr_utility.trace('EMP_CONT ::: LE #### status is OF or HF = '|| l_le_status );
1195:
1196: -------- performing exemption limit check
1197: l_table_name := 'NO_NIS_ZONE_RATES';
1198:

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

1213: l_high_rate := p_over_age_high_rate;
1214:
1215: END IF; -- end IF under_62 = Y
1216:
1217: hr_utility.trace('EMP_CONT ::: LE #### exemption limit check ----------------------' );
1218:
1219: l_zone_value := to_char(g_tab_calc(i).zone);
1220: 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 ));
1221: l_diff_rate := l_high_rate - l_normal_rate ;

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

1231:
1232: l_saving := ( g_tab_calc(i).bimonth_base * l_diff_rate ) / 100 ;
1233: l_total_saving := l_total_saving + l_saving ;
1234:
1235: hr_utility.trace('EMP_CONT ::: LE #### i = '||i||' l_zone_value = '||l_zone_value
1236: ||' l_normal_rate = '||l_normal_rate||' l_high_rate = '||l_high_rate
1237: ||' l_diff_rate = '||l_diff_rate||' l_saving = '||l_saving||' l_total_saving = '||l_total_saving );
1238:
1239: -- check if exemption limit exceeded

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

1238:
1239: -- check if exemption limit exceeded
1240: IF ((l_exemption_limit_used_yet + l_total_saving) >= l_exemption_limit)
1241: THEN
1242: hr_utility.trace('EMP_CONT ::: LE #### exemption limit exceeded in table');
1243: hr_utility.trace('EMP_CONT ::: LE #### bimonth_base = '|| g_tab_calc(i).bimonth_base );
1244: hr_utility.trace('EMP_CONT ::: LE #### run_base = '||g_tab_calc(i).run_base );
1245: hr_utility.trace('EMP_CONT ::: LE #### l_zone_value = '|| l_zone_value );
1246: hr_utility.trace('EMP_CONT ::: LE #### l_normal_rate = '|| l_normal_rate );

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

1239: -- check if exemption limit exceeded
1240: IF ((l_exemption_limit_used_yet + l_total_saving) >= l_exemption_limit)
1241: THEN
1242: hr_utility.trace('EMP_CONT ::: LE #### exemption limit exceeded in table');
1243: hr_utility.trace('EMP_CONT ::: LE #### bimonth_base = '|| g_tab_calc(i).bimonth_base );
1244: hr_utility.trace('EMP_CONT ::: LE #### run_base = '||g_tab_calc(i).run_base );
1245: hr_utility.trace('EMP_CONT ::: LE #### l_zone_value = '|| l_zone_value );
1246: hr_utility.trace('EMP_CONT ::: LE #### l_normal_rate = '|| l_normal_rate );
1247: hr_utility.trace('EMP_CONT ::: LE #### l_high_rate = '|| l_high_rate );

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

1240: IF ((l_exemption_limit_used_yet + l_total_saving) >= l_exemption_limit)
1241: THEN
1242: hr_utility.trace('EMP_CONT ::: LE #### exemption limit exceeded in table');
1243: hr_utility.trace('EMP_CONT ::: LE #### bimonth_base = '|| g_tab_calc(i).bimonth_base );
1244: hr_utility.trace('EMP_CONT ::: LE #### run_base = '||g_tab_calc(i).run_base );
1245: hr_utility.trace('EMP_CONT ::: LE #### l_zone_value = '|| l_zone_value );
1246: hr_utility.trace('EMP_CONT ::: LE #### l_normal_rate = '|| l_normal_rate );
1247: hr_utility.trace('EMP_CONT ::: LE #### l_high_rate = '|| l_high_rate );
1248: hr_utility.trace('EMP_CONT ::: LE #### l_diff_rate = '|| l_diff_rate );

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

1241: THEN
1242: hr_utility.trace('EMP_CONT ::: LE #### exemption limit exceeded in table');
1243: hr_utility.trace('EMP_CONT ::: LE #### bimonth_base = '|| g_tab_calc(i).bimonth_base );
1244: hr_utility.trace('EMP_CONT ::: LE #### run_base = '||g_tab_calc(i).run_base );
1245: hr_utility.trace('EMP_CONT ::: LE #### l_zone_value = '|| l_zone_value );
1246: hr_utility.trace('EMP_CONT ::: LE #### l_normal_rate = '|| l_normal_rate );
1247: hr_utility.trace('EMP_CONT ::: LE #### l_high_rate = '|| l_high_rate );
1248: hr_utility.trace('EMP_CONT ::: LE #### l_diff_rate = '|| l_diff_rate );
1249: hr_utility.trace('EMP_CONT ::: LE #### l_saving = '|| l_saving );

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

1242: hr_utility.trace('EMP_CONT ::: LE #### exemption limit exceeded in table');
1243: hr_utility.trace('EMP_CONT ::: LE #### bimonth_base = '|| g_tab_calc(i).bimonth_base );
1244: hr_utility.trace('EMP_CONT ::: LE #### run_base = '||g_tab_calc(i).run_base );
1245: hr_utility.trace('EMP_CONT ::: LE #### l_zone_value = '|| l_zone_value );
1246: hr_utility.trace('EMP_CONT ::: LE #### l_normal_rate = '|| l_normal_rate );
1247: hr_utility.trace('EMP_CONT ::: LE #### l_high_rate = '|| l_high_rate );
1248: hr_utility.trace('EMP_CONT ::: LE #### l_diff_rate = '|| l_diff_rate );
1249: hr_utility.trace('EMP_CONT ::: LE #### l_saving = '|| l_saving );
1250: hr_utility.trace('EMP_CONT ::: LE #### l_total_saving= '|| l_total_saving );

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

1243: hr_utility.trace('EMP_CONT ::: LE #### bimonth_base = '|| g_tab_calc(i).bimonth_base );
1244: hr_utility.trace('EMP_CONT ::: LE #### run_base = '||g_tab_calc(i).run_base );
1245: hr_utility.trace('EMP_CONT ::: LE #### l_zone_value = '|| l_zone_value );
1246: hr_utility.trace('EMP_CONT ::: LE #### l_normal_rate = '|| l_normal_rate );
1247: hr_utility.trace('EMP_CONT ::: LE #### l_high_rate = '|| l_high_rate );
1248: hr_utility.trace('EMP_CONT ::: LE #### l_diff_rate = '|| l_diff_rate );
1249: hr_utility.trace('EMP_CONT ::: LE #### l_saving = '|| l_saving );
1250: hr_utility.trace('EMP_CONT ::: LE #### l_total_saving= '|| l_total_saving );
1251: hr_utility.trace('EMP_CONT ::: LE #### l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );

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

1244: hr_utility.trace('EMP_CONT ::: LE #### run_base = '||g_tab_calc(i).run_base );
1245: hr_utility.trace('EMP_CONT ::: LE #### l_zone_value = '|| l_zone_value );
1246: hr_utility.trace('EMP_CONT ::: LE #### l_normal_rate = '|| l_normal_rate );
1247: hr_utility.trace('EMP_CONT ::: LE #### l_high_rate = '|| l_high_rate );
1248: hr_utility.trace('EMP_CONT ::: LE #### l_diff_rate = '|| l_diff_rate );
1249: hr_utility.trace('EMP_CONT ::: LE #### l_saving = '|| l_saving );
1250: hr_utility.trace('EMP_CONT ::: LE #### l_total_saving= '|| l_total_saving );
1251: hr_utility.trace('EMP_CONT ::: LE #### l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
1252:

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

1245: hr_utility.trace('EMP_CONT ::: LE #### l_zone_value = '|| l_zone_value );
1246: hr_utility.trace('EMP_CONT ::: LE #### l_normal_rate = '|| l_normal_rate );
1247: hr_utility.trace('EMP_CONT ::: LE #### l_high_rate = '|| l_high_rate );
1248: hr_utility.trace('EMP_CONT ::: LE #### l_diff_rate = '|| l_diff_rate );
1249: hr_utility.trace('EMP_CONT ::: LE #### l_saving = '|| l_saving );
1250: hr_utility.trace('EMP_CONT ::: LE #### l_total_saving= '|| l_total_saving );
1251: hr_utility.trace('EMP_CONT ::: LE #### l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
1252:
1253: -- get the exceeding amount

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

1246: hr_utility.trace('EMP_CONT ::: LE #### l_normal_rate = '|| l_normal_rate );
1247: hr_utility.trace('EMP_CONT ::: LE #### l_high_rate = '|| l_high_rate );
1248: hr_utility.trace('EMP_CONT ::: LE #### l_diff_rate = '|| l_diff_rate );
1249: hr_utility.trace('EMP_CONT ::: LE #### l_saving = '|| l_saving );
1250: hr_utility.trace('EMP_CONT ::: LE #### l_total_saving= '|| l_total_saving );
1251: hr_utility.trace('EMP_CONT ::: LE #### l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
1252:
1253: -- get the exceeding amount
1254: l_amount_over_limit := ((l_exemption_limit_used_yet + l_total_saving) - l_exemption_limit);

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

1247: hr_utility.trace('EMP_CONT ::: LE #### l_high_rate = '|| l_high_rate );
1248: hr_utility.trace('EMP_CONT ::: LE #### l_diff_rate = '|| l_diff_rate );
1249: hr_utility.trace('EMP_CONT ::: LE #### l_saving = '|| l_saving );
1250: hr_utility.trace('EMP_CONT ::: LE #### l_total_saving= '|| l_total_saving );
1251: hr_utility.trace('EMP_CONT ::: LE #### l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
1252:
1253: -- get the exceeding amount
1254: l_amount_over_limit := ((l_exemption_limit_used_yet + l_total_saving) - l_exemption_limit);
1255: l_base_over_limit := ( l_amount_over_limit / l_diff_rate ) * 100 ;

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

1277: -- set the new l_total_saving
1278:
1279: l_total_saving := l_exemption_limit - l_exemption_limit_used_yet ;
1280:
1281: hr_utility.trace('EMP_CONT ::: LE #### l_amount_over_limit = '|| l_amount_over_limit );
1282: hr_utility.trace('EMP_CONT ::: LE #### l_base_over_limit = '|| l_base_over_limit );
1283: hr_utility.trace('EMP_CONT ::: LE #### NEW bimonth base for current row = '|| g_tab_calc(i).bimonth_base );
1284: hr_utility.trace('EMP_CONT ::: LE #### NEW l_total_saving = '|| l_total_saving );
1285:

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

1278:
1279: l_total_saving := l_exemption_limit - l_exemption_limit_used_yet ;
1280:
1281: hr_utility.trace('EMP_CONT ::: LE #### l_amount_over_limit = '|| l_amount_over_limit );
1282: hr_utility.trace('EMP_CONT ::: LE #### l_base_over_limit = '|| l_base_over_limit );
1283: hr_utility.trace('EMP_CONT ::: LE #### NEW bimonth base for current row = '|| g_tab_calc(i).bimonth_base );
1284: hr_utility.trace('EMP_CONT ::: LE #### NEW l_total_saving = '|| l_total_saving );
1285:
1286: -- insert a new row for exceeded limit

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

1279: l_total_saving := l_exemption_limit - l_exemption_limit_used_yet ;
1280:
1281: hr_utility.trace('EMP_CONT ::: LE #### l_amount_over_limit = '|| l_amount_over_limit );
1282: hr_utility.trace('EMP_CONT ::: LE #### l_base_over_limit = '|| l_base_over_limit );
1283: hr_utility.trace('EMP_CONT ::: LE #### NEW bimonth base for current row = '|| g_tab_calc(i).bimonth_base );
1284: hr_utility.trace('EMP_CONT ::: LE #### NEW l_total_saving = '|| l_total_saving );
1285:
1286: -- insert a new row for exceeded limit
1287:

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

1280:
1281: hr_utility.trace('EMP_CONT ::: LE #### l_amount_over_limit = '|| l_amount_over_limit );
1282: hr_utility.trace('EMP_CONT ::: LE #### l_base_over_limit = '|| l_base_over_limit );
1283: hr_utility.trace('EMP_CONT ::: LE #### NEW bimonth base for current row = '|| g_tab_calc(i).bimonth_base );
1284: hr_utility.trace('EMP_CONT ::: LE #### NEW l_total_saving = '|| l_total_saving );
1285:
1286: -- insert a new row for exceeded limit
1287:
1288: g_tab_calc(11).zone := g_tab_calc(i).zone;

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

1311: END LOOP; --end j loop
1312:
1313: l_LE_over_limit := 'Y'; -- indicating exemption limit on LE level is over
1314:
1315: --hr_utility.trace('EMP_CONT ::: LE #### l_LE_over_limit Y' );
1316: hr_utility.trace('EMP_CONT ::: LE #### l_LE_over_limit = '||l_LE_over_limit );
1317:
1318: EXIT; -- exit loop i since no more check is required
1319: END IF; -- end check if exemption limit exceeded

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

1312:
1313: l_LE_over_limit := 'Y'; -- indicating exemption limit on LE level is over
1314:
1315: --hr_utility.trace('EMP_CONT ::: LE #### l_LE_over_limit Y' );
1316: hr_utility.trace('EMP_CONT ::: LE #### l_LE_over_limit = '||l_LE_over_limit );
1317:
1318: EXIT; -- exit loop i since no more check is required
1319: END IF; -- end check if exemption limit exceeded
1320:

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

1327: END IF; -- end if l_LE_over_limit = Y
1328:
1329: l_exemption_limit_used := l_total_saving - l_bal_val_bimonth ;
1330:
1331: hr_utility.trace('EMP_CONT ::: LE #### l_total_saving = '||l_total_saving );
1332: hr_utility.trace('EMP_CONT ::: LE #### l_bal_val_bimonth = '||l_bal_val_bimonth );
1333: hr_utility.trace('EMP_CONT ::: LE #### l_exemption_limit_used = '||l_exemption_limit_used );
1334:
1335: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');

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

1328:
1329: l_exemption_limit_used := l_total_saving - l_bal_val_bimonth ;
1330:
1331: hr_utility.trace('EMP_CONT ::: LE #### l_total_saving = '||l_total_saving );
1332: hr_utility.trace('EMP_CONT ::: LE #### l_bal_val_bimonth = '||l_bal_val_bimonth );
1333: hr_utility.trace('EMP_CONT ::: LE #### l_exemption_limit_used = '||l_exemption_limit_used );
1334:
1335: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
1336: l_check := display_table_calc(g_tab_calc);

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

1329: l_exemption_limit_used := l_total_saving - l_bal_val_bimonth ;
1330:
1331: hr_utility.trace('EMP_CONT ::: LE #### l_total_saving = '||l_total_saving );
1332: hr_utility.trace('EMP_CONT ::: LE #### l_bal_val_bimonth = '||l_bal_val_bimonth );
1333: hr_utility.trace('EMP_CONT ::: LE #### l_exemption_limit_used = '||l_exemption_limit_used );
1334:
1335: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
1336: l_check := display_table_calc(g_tab_calc);
1337: hr_utility.trace('EMP_CONT ::: -- returned from display_table_calc function ');

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

1331: hr_utility.trace('EMP_CONT ::: LE #### l_total_saving = '||l_total_saving );
1332: hr_utility.trace('EMP_CONT ::: LE #### l_bal_val_bimonth = '||l_bal_val_bimonth );
1333: hr_utility.trace('EMP_CONT ::: LE #### l_exemption_limit_used = '||l_exemption_limit_used );
1334:
1335: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
1336: l_check := display_table_calc(g_tab_calc);
1337: hr_utility.trace('EMP_CONT ::: -- returned from display_table_calc function ');
1338:
1339: hr_utility.trace('EMP_CONT ::: LE #### apply differential rate and check exemption limit , leaving ');

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

1333: hr_utility.trace('EMP_CONT ::: LE #### l_exemption_limit_used = '||l_exemption_limit_used );
1334:
1335: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
1336: l_check := display_table_calc(g_tab_calc);
1337: hr_utility.trace('EMP_CONT ::: -- returned from display_table_calc function ');
1338:
1339: hr_utility.trace('EMP_CONT ::: LE #### apply differential rate and check exemption limit , leaving ');
1340: ------------------------------ applied differential rate and check exemption limit at LE Level
1341:

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

1335: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
1336: l_check := display_table_calc(g_tab_calc);
1337: hr_utility.trace('EMP_CONT ::: -- returned from display_table_calc function ');
1338:
1339: hr_utility.trace('EMP_CONT ::: LE #### apply differential rate and check exemption limit , leaving ');
1340: ------------------------------ applied differential rate and check exemption limit at LE Level
1341:
1342: -- ec_main_calculation function call for LE
1343: hr_utility.trace('EMP_CONT ::: LE #### ec_main_calculation function call for LE , entering ' );

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

1339: hr_utility.trace('EMP_CONT ::: LE #### apply differential rate and check exemption limit , leaving ');
1340: ------------------------------ applied differential rate and check exemption limit at LE Level
1341:
1342: -- ec_main_calculation function call for LE
1343: hr_utility.trace('EMP_CONT ::: LE #### ec_main_calculation function call for LE , entering ' );
1344:
1345: l_main_index := ec_main_calculation (g_tab_calc
1346: ,PAY_NO_EMP_CONT.g_tab_main
1347: ,p_tax_unit_id

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

1356: ,l_curr_under_62 ) ;
1357:
1358:
1359:
1360: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
1361: l_check := display_table_calc(g_tab_calc);
1362: hr_utility.trace('EMP_CONT ::: -- returned from display_table_calc function ');
1363:
1364: hr_utility.trace('EMP_CONT ::: LE #### ec_main_calculation function call for LE , leaving ' );

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

1358:
1359:
1360: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
1361: l_check := display_table_calc(g_tab_calc);
1362: hr_utility.trace('EMP_CONT ::: -- returned from display_table_calc function ');
1363:
1364: hr_utility.trace('EMP_CONT ::: LE #### ec_main_calculation function call for LE , leaving ' );
1365:
1366: -- done all caclculation and entered values in the main table for next time usage

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

1360: hr_utility.trace('EMP_CONT ::: -- calling display_table_calc function ');
1361: l_check := display_table_calc(g_tab_calc);
1362: hr_utility.trace('EMP_CONT ::: -- returned from display_table_calc function ');
1363:
1364: hr_utility.trace('EMP_CONT ::: LE #### ec_main_calculation function call for LE , leaving ' );
1365:
1366: -- done all caclculation and entered values in the main table for next time usage
1367:
1368: -- returning values at LE level

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

1369: p_run_base := PAY_NO_EMP_CONT.g_tab_main(l_main_index).run_base;
1370: p_run_contribution := PAY_NO_EMP_CONT.g_tab_main(l_main_index).run_contribution;
1371: p_curr_exemption_limit_used := PAY_NO_EMP_CONT.g_tab_main(l_main_index).exemption_limit_used;
1372:
1373: hr_utility.trace('EMP_CONT ::: LE #### l_main_index = '|| l_main_index );
1374: hr_utility.trace('EMP_CONT ::: LE #### p_run_base = '|| p_run_base );
1375: hr_utility.trace('EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );
1376: hr_utility.trace('EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
1377:

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

1370: p_run_contribution := PAY_NO_EMP_CONT.g_tab_main(l_main_index).run_contribution;
1371: p_curr_exemption_limit_used := PAY_NO_EMP_CONT.g_tab_main(l_main_index).exemption_limit_used;
1372:
1373: hr_utility.trace('EMP_CONT ::: LE #### l_main_index = '|| l_main_index );
1374: hr_utility.trace('EMP_CONT ::: LE #### p_run_base = '|| p_run_base );
1375: hr_utility.trace('EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );
1376: hr_utility.trace('EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
1377:
1378: hr_utility.trace('EMP_CONT ::: LE #### Leaving procedure-----------------------------------');

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

1371: p_curr_exemption_limit_used := PAY_NO_EMP_CONT.g_tab_main(l_main_index).exemption_limit_used;
1372:
1373: hr_utility.trace('EMP_CONT ::: LE #### l_main_index = '|| l_main_index );
1374: hr_utility.trace('EMP_CONT ::: LE #### p_run_base = '|| p_run_base );
1375: hr_utility.trace('EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );
1376: hr_utility.trace('EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
1377:
1378: hr_utility.trace('EMP_CONT ::: LE #### Leaving procedure-----------------------------------');
1379:

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

1372:
1373: hr_utility.trace('EMP_CONT ::: LE #### l_main_index = '|| l_main_index );
1374: hr_utility.trace('EMP_CONT ::: LE #### p_run_base = '|| p_run_base );
1375: hr_utility.trace('EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );
1376: hr_utility.trace('EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
1377:
1378: hr_utility.trace('EMP_CONT ::: LE #### Leaving procedure-----------------------------------');
1379:
1380: RETURN 1; -- here return 1 and the other values thru OUT parameters

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

1374: hr_utility.trace('EMP_CONT ::: LE #### p_run_base = '|| p_run_base );
1375: hr_utility.trace('EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );
1376: hr_utility.trace('EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
1377:
1378: hr_utility.trace('EMP_CONT ::: LE #### Leaving procedure-----------------------------------');
1379:
1380: RETURN 1; -- here return 1 and the other values thru OUT parameters
1381:
1382:

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

1384:
1385:
1386: END IF; -- end if l_lu_rep_sep = 'Y'
1387:
1388: hr_utility.trace('EMP_CONT ::: exiting main function');
1389: --hr_utility.trace_off();
1390:
1391: -----------------------------------Exception -----------------------------------------------------------
1392: --EXCEPTION

Line 1389: --hr_utility.trace_off();

1385:
1386: END IF; -- end if l_lu_rep_sep = 'Y'
1387:
1388: hr_utility.trace('EMP_CONT ::: exiting main function');
1389: --hr_utility.trace_off();
1390:
1391: -----------------------------------Exception -----------------------------------------------------------
1392: --EXCEPTION
1393:

Line 1488: hr_utility.trace('EMP_CONT ::: --------------------------------------------------------');

1484:
1485: /* Bug Fix: 5042861 - Changed call of cursor PAY_NO_EMP_CONT.csr_lu_mu */
1486: FOR csr3_rec IN PAY_NO_EMP_CONT.csr_lu_mu (csr2_rec.ASSIGNMENT_ID , csr2_rec.ASSIGNMENT_ACTION_ID , p_date_earned , l_tax_dedn_base_ele_type_id ) LOOP
1487:
1488: hr_utility.trace('EMP_CONT ::: --------------------------------------------------------');
1489:
1490: hr_utility.trace('EMP_CONT ::: PAY_ACT_ID = '||csr1_rec.PAYROLL_ACTION_ID||' ASS_ID = '||csr2_rec.ASSIGNMENT_ID||' ASS_ACT_ID = '||csr2_rec.ASSIGNMENT_ACTION_ID
1491: ||' Local Unit = '||csr3_rec.local_unit_id||' Tax Mul = '||csr3_rec.tax_mun_id);
1492:

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

1486: FOR csr3_rec IN PAY_NO_EMP_CONT.csr_lu_mu (csr2_rec.ASSIGNMENT_ID , csr2_rec.ASSIGNMENT_ACTION_ID , p_date_earned , l_tax_dedn_base_ele_type_id ) LOOP
1487:
1488: hr_utility.trace('EMP_CONT ::: --------------------------------------------------------');
1489:
1490: hr_utility.trace('EMP_CONT ::: PAY_ACT_ID = '||csr1_rec.PAYROLL_ACTION_ID||' ASS_ID = '||csr2_rec.ASSIGNMENT_ID||' ASS_ACT_ID = '||csr2_rec.ASSIGNMENT_ACTION_ID
1491: ||' Local Unit = '||csr3_rec.local_unit_id||' Tax Mul = '||csr3_rec.tax_mun_id);
1492:
1493: ----------------------------- check for MU -------------------------------------------
1494: start_index_mu := NVL (g_mu_tab.FIRST, 0) ;

Line 1566: hr_utility.trace('EMP_CONT ::: *****************************************************************************');

1562: start_index_mu := NVL (g_mu_tab.FIRST, 0) ;
1563: end_index_mu := NVL (g_mu_tab.LAST, 0) ;
1564:
1565: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
1566: hr_utility.trace('EMP_CONT ::: *****************************************************************************');
1567: hr_utility.trace('EMP_CONT ::: Tax Mul = '|| g_mu_tab(start_index_mu));
1568:
1569: start_index_mu := start_index_mu + 1;
1570: END LOOP; -- end while loop

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

1563: end_index_mu := NVL (g_mu_tab.LAST, 0) ;
1564:
1565: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
1566: hr_utility.trace('EMP_CONT ::: *****************************************************************************');
1567: hr_utility.trace('EMP_CONT ::: Tax Mul = '|| g_mu_tab(start_index_mu));
1568:
1569: start_index_mu := start_index_mu + 1;
1570: END LOOP; -- end while loop
1571: hr_utility.trace('EMP_CONT ::: *****************************************************************************');

Line 1571: hr_utility.trace('EMP_CONT ::: *****************************************************************************');

1567: hr_utility.trace('EMP_CONT ::: Tax Mul = '|| g_mu_tab(start_index_mu));
1568:
1569: start_index_mu := start_index_mu + 1;
1570: END LOOP; -- end while loop
1571: hr_utility.trace('EMP_CONT ::: *****************************************************************************');
1572:
1573: -- end sub test 1
1574: -------------------------------------------------------------------------------------------------
1575:

Line 1584: hr_utility.trace('EMP_CONT ::: \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\');

1580: end_index_lu := NVL (g_lu_tab.LAST, 0) ;
1581:
1582:
1583: WHILE (g_lu_tab.EXISTS(start_index_lu)) and (start_index_lu <= end_index_lu) LOOP
1584: hr_utility.trace('EMP_CONT ::: \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\');
1585: hr_utility.trace('EMP_CONT ::: Local Unit = '|| g_lu_tab(start_index_lu));
1586:
1587: start_index_lu := start_index_lu + 1;
1588: END LOOP; -- end while loop

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

1581:
1582:
1583: WHILE (g_lu_tab.EXISTS(start_index_lu)) and (start_index_lu <= end_index_lu) LOOP
1584: hr_utility.trace('EMP_CONT ::: \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\');
1585: hr_utility.trace('EMP_CONT ::: Local Unit = '|| g_lu_tab(start_index_lu));
1586:
1587: start_index_lu := start_index_lu + 1;
1588: END LOOP; -- end while loop
1589: hr_utility.trace('EMP_CONT ::: \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\');

Line 1589: hr_utility.trace('EMP_CONT ::: \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\');

1585: hr_utility.trace('EMP_CONT ::: Local Unit = '|| g_lu_tab(start_index_lu));
1586:
1587: start_index_lu := start_index_lu + 1;
1588: END LOOP; -- end while loop
1589: hr_utility.trace('EMP_CONT ::: \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\');
1590:
1591: -- end sub test 2
1592:
1593: ------------------------------

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

1731: start_main_index := NVL (g_tab_main.LAST, 0) + 1 ;
1732: end_main_index := start_main_index + 9;
1733: x := 1;
1734:
1735: hr_utility.trace('EMP_CONT ::: Initializing Main Table --------');
1736:
1737: -- initialize 10 rows of the main table g_tab_main
1738: ------------------------------------------------------------------------------------------------------
1739: FOR j IN start_main_index..end_main_index LOOP

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

1765:
1766:
1767: END LOOP; -- end loop for initializing g_tab_main
1768:
1769: hr_utility.trace('EMP_CONT ::: Finished Initializing Main Table --------');
1770: ------------------------------------------------------------------------------------------------------
1771:
1772: l_run_base := 0;
1773: l_unallocated_cont := 0;

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

1774:
1775: start_index_calc := NVL (g_tab_calc.FIRST, 0) ;
1776: end_index_calc := NVL (g_tab_calc.LAST, 0) ;
1777:
1778: hr_utility.trace('EMP_CONT ::: Main Calc Entered--------' );
1779:
1780: hr_utility.trace('EMP_CONT ::: Main Calc i -- p_org_status - zone -- under_62 = -- under_limit -- l_rate = -- bimonth_base -- bimonth_cont -- bimonth_todate -- run_cont ' );
1781:
1782: FOR i IN start_index_calc..end_index_calc LOOP

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

1776: end_index_calc := NVL (g_tab_calc.LAST, 0) ;
1777:
1778: hr_utility.trace('EMP_CONT ::: Main Calc Entered--------' );
1779:
1780: hr_utility.trace('EMP_CONT ::: Main Calc i -- p_org_status - zone -- under_62 = -- under_limit -- l_rate = -- bimonth_base -- bimonth_cont -- bimonth_todate -- run_cont ' );
1781:
1782: FOR i IN start_index_calc..end_index_calc LOOP
1783:
1784: l_rate := get_ec_rate (g_tab_calc(i).under_62

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

1805: THEN
1806: l_unallocated_cont := l_unallocated_cont + g_tab_calc(i).run_contribution ;
1807: END IF;
1808:
1809: hr_utility.trace('EMP_CONT ::: Main Calc '||i
1810: ||' '||p_org_status
1811: ||' '||g_tab_calc(i).zone
1812: ||' '||g_tab_calc(i).under_62
1813: ||' '||g_tab_calc(i).under_limit

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

1818: ||' '||g_tab_calc(i).run_contribution );
1819:
1820: END LOOP;
1821:
1822: hr_utility.trace('EMP_CONT ::: Main Calc --- exited from Main calc loop' );
1823: hr_utility.trace('EMP_CONT ::: Main Calc l_run_base = '|| l_run_base );
1824: hr_utility.trace('EMP_CONT ::: Main Calc l_unallocated_cont = '|| l_unallocated_cont );
1825:
1826: -- re-allocating the run_contributions that can be allocated

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

1819:
1820: END LOOP;
1821:
1822: hr_utility.trace('EMP_CONT ::: Main Calc --- exited from Main calc loop' );
1823: hr_utility.trace('EMP_CONT ::: Main Calc l_run_base = '|| l_run_base );
1824: hr_utility.trace('EMP_CONT ::: Main Calc l_unallocated_cont = '|| l_unallocated_cont );
1825:
1826: -- re-allocating the run_contributions that can be allocated
1827: -- and also summing the values to get the final values

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

1820: END LOOP;
1821:
1822: hr_utility.trace('EMP_CONT ::: Main Calc --- exited from Main calc loop' );
1823: hr_utility.trace('EMP_CONT ::: Main Calc l_run_base = '|| l_run_base );
1824: hr_utility.trace('EMP_CONT ::: Main Calc l_unallocated_cont = '|| l_unallocated_cont );
1825:
1826: -- re-allocating the run_contributions that can be allocated
1827: -- and also summing the values to get the final values
1828:

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

1825:
1826: -- re-allocating the run_contributions that can be allocated
1827: -- and also summing the values to get the final values
1828:
1829: hr_utility.trace('EMP_CONT ::: Main Calc --- entered loop for re-allocation and summing up values' );
1830:
1831:
1832:
1833: FOR i IN start_index_calc..end_index_calc LOOP

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

1848:
1849: END IF;
1850:
1851:
1852: hr_utility.trace('EMP_CONT ::: Main Calc '||i
1853: ||' '||g_tab_calc(i).run_base
1854: ||' '||l_run_base
1855: ||' '||l_unallocated_cont
1856: ||' '||l_extra_run_cont

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

1865: g_tab_main(l_curr_index).run_contribution := g_tab_main(l_curr_index).run_contribution + g_tab_calc(i).run_contribution ;
1866:
1867: END LOOP;
1868:
1869: hr_utility.trace('EMP_CONT ::: Main Calc --- leaving loop for re-allocation and summing up values' );
1870:
1871: hr_utility.trace('EMP_CONT ::: Main Calc Leaving--------' );
1872:
1873: RETURN l_main_index ;

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

1867: END LOOP;
1868:
1869: hr_utility.trace('EMP_CONT ::: Main Calc --- leaving loop for re-allocation and summing up values' );
1870:
1871: hr_utility.trace('EMP_CONT ::: Main Calc Leaving--------' );
1872:
1873: RETURN l_main_index ;
1874:
1875: END ec_main_calculation ;

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

2009:
2010: start_index_calc := NVL (g_tab_calc.FIRST, 0) ;
2011: end_index_calc := NVL (g_tab_calc.LAST, 0) ;
2012:
2013: hr_utility.trace('EMP_CONT ::: ---------- Displaying g_tab_calc table data ----------------------');
2014: hr_utility.trace('EMP_CONT ::: zone -- under_62 -- under_limit -- status -- bimonth_base -- run_base -- bimonth_cont -- bimonth_cont_todate -- run_cont ');
2015:
2016: FOR i IN start_index_calc..end_index_calc LOOP
2017:

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

2010: start_index_calc := NVL (g_tab_calc.FIRST, 0) ;
2011: end_index_calc := NVL (g_tab_calc.LAST, 0) ;
2012:
2013: hr_utility.trace('EMP_CONT ::: ---------- Displaying g_tab_calc table data ----------------------');
2014: hr_utility.trace('EMP_CONT ::: zone -- under_62 -- under_limit -- status -- bimonth_base -- run_base -- bimonth_cont -- bimonth_cont_todate -- run_cont ');
2015:
2016: FOR i IN start_index_calc..end_index_calc LOOP
2017:
2018: hr_utility.trace('EMP_CONT ::: '

Line 2018: hr_utility.trace('EMP_CONT ::: '

2014: hr_utility.trace('EMP_CONT ::: zone -- under_62 -- under_limit -- status -- bimonth_base -- run_base -- bimonth_cont -- bimonth_cont_todate -- run_cont ');
2015:
2016: FOR i IN start_index_calc..end_index_calc LOOP
2017:
2018: hr_utility.trace('EMP_CONT ::: '
2019: ||' '||g_tab_calc(i).zone
2020: ||' '||g_tab_calc(i).under_62
2021: ||' '||g_tab_calc(i).under_limit
2022: ||' '||g_tab_calc(i).status

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

2026: ||' '||g_tab_calc(i).bimonth_contribution_todate
2027: ||' '||g_tab_calc(i).run_contribution );
2028:
2029: END LOOP;
2030: hr_utility.trace('EMP_CONT ::: ---------- Displayed g_tab_calc table data , exiting function ----------------------');
2031:
2032: RETURN 1 ;
2033:
2034: END display_table_calc ;

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

2102: l_start_of_year := trunc(p_date_earned, 'Y');
2103:
2104: l_cum_base_rate_value := 0 ;
2105:
2106: hr_utility.trace('EMP_CONT ::: p_date_earned = '||p_date_earned);
2107: hr_utility.trace('EMP_CONT ::: l_start_of_year = '||l_start_of_year);
2108: hr_utility.trace('EMP_CONT ::: l_end_of_year = '||l_end_of_year);
2109: hr_utility.trace('EMP_CONT ::: ========================================= ');
2110:

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

2103:
2104: l_cum_base_rate_value := 0 ;
2105:
2106: hr_utility.trace('EMP_CONT ::: p_date_earned = '||p_date_earned);
2107: hr_utility.trace('EMP_CONT ::: l_start_of_year = '||l_start_of_year);
2108: hr_utility.trace('EMP_CONT ::: l_end_of_year = '||l_end_of_year);
2109: hr_utility.trace('EMP_CONT ::: ========================================= ');
2110:
2111: -- Bug Fix 5566622 : Value of G (National Insurance Base Rate) to be taken from Global and not user table.

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

2104: l_cum_base_rate_value := 0 ;
2105:
2106: hr_utility.trace('EMP_CONT ::: p_date_earned = '||p_date_earned);
2107: hr_utility.trace('EMP_CONT ::: l_start_of_year = '||l_start_of_year);
2108: hr_utility.trace('EMP_CONT ::: l_end_of_year = '||l_end_of_year);
2109: hr_utility.trace('EMP_CONT ::: ========================================= ');
2110:
2111: -- Bug Fix 5566622 : Value of G (National Insurance Base Rate) to be taken from Global and not user table.
2112: -- modifying call for cursor csr_get_ni_base_rates

Line 2109: hr_utility.trace('EMP_CONT ::: ========================================= ');

2105:
2106: hr_utility.trace('EMP_CONT ::: p_date_earned = '||p_date_earned);
2107: hr_utility.trace('EMP_CONT ::: l_start_of_year = '||l_start_of_year);
2108: hr_utility.trace('EMP_CONT ::: l_end_of_year = '||l_end_of_year);
2109: hr_utility.trace('EMP_CONT ::: ========================================= ');
2110:
2111: -- Bug Fix 5566622 : Value of G (National Insurance Base Rate) to be taken from Global and not user table.
2112: -- modifying call for cursor csr_get_ni_base_rates
2113:

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

2121: -- check if effective start date is before the starting of the year
2122:
2123: IF (l_eff_start_date < l_start_of_year)
2124: THEN
2125: hr_utility.trace('EMP_CONT ::: OLD l_eff_start_date = '||l_eff_start_date);
2126: l_eff_start_date := l_start_of_year;
2127: hr_utility.trace('EMP_CONT ::: NEW l_eff_start_date = '||l_eff_start_date);
2128: END IF;
2129:

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

2123: IF (l_eff_start_date < l_start_of_year)
2124: THEN
2125: hr_utility.trace('EMP_CONT ::: OLD l_eff_start_date = '||l_eff_start_date);
2126: l_eff_start_date := l_start_of_year;
2127: hr_utility.trace('EMP_CONT ::: NEW l_eff_start_date = '||l_eff_start_date);
2128: END IF;
2129:
2130: -- check if effective end date is after the end of the period
2131:

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

2130: -- check if effective end date is after the end of the period
2131:
2132: IF (l_eff_end_date > l_end_of_year)
2133: THEN
2134: hr_utility.trace('EMP_CONT ::: OLD l_eff_end_date = '||l_eff_end_date);
2135: l_eff_end_date := l_end_of_year;
2136: hr_utility.trace('EMP_CONT ::: NEW l_eff_end_date = '||l_eff_end_date);
2137: END IF;
2138:

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

2132: IF (l_eff_end_date > l_end_of_year)
2133: THEN
2134: hr_utility.trace('EMP_CONT ::: OLD l_eff_end_date = '||l_eff_end_date);
2135: l_eff_end_date := l_end_of_year;
2136: hr_utility.trace('EMP_CONT ::: NEW l_eff_end_date = '||l_eff_end_date);
2137: END IF;
2138:
2139: -- calculating the number of months the value is valid for
2140:

Line 2145: hr_utility.trace('EMP_CONT ::: -------------- ');

2141: l_no_of_mths := months_between(l_eff_end_date , (l_eff_start_date -1) );
2142: l_cum_base_rate_value := l_cum_base_rate_value + (l_base_rate_value * l_no_of_mths) ;
2143:
2144:
2145: hr_utility.trace('EMP_CONT ::: -------------- ');
2146: hr_utility.trace('EMP_CONT ::: l_base_rate_value = '||l_base_rate_value);
2147: hr_utility.trace('EMP_CONT ::: l_eff_start_date = '||l_eff_start_date);
2148: hr_utility.trace('EMP_CONT ::: l_eff_end_date = '||l_eff_end_date);
2149: hr_utility.trace('EMP_CONT ::: l_no_of_mths = '||l_no_of_mths);

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

2142: l_cum_base_rate_value := l_cum_base_rate_value + (l_base_rate_value * l_no_of_mths) ;
2143:
2144:
2145: hr_utility.trace('EMP_CONT ::: -------------- ');
2146: hr_utility.trace('EMP_CONT ::: l_base_rate_value = '||l_base_rate_value);
2147: hr_utility.trace('EMP_CONT ::: l_eff_start_date = '||l_eff_start_date);
2148: hr_utility.trace('EMP_CONT ::: l_eff_end_date = '||l_eff_end_date);
2149: hr_utility.trace('EMP_CONT ::: l_no_of_mths = '||l_no_of_mths);
2150: hr_utility.trace('EMP_CONT ::: l_base_rate_value * l_no_of_mths = '||l_base_rate_value * l_no_of_mths);

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

2143:
2144:
2145: hr_utility.trace('EMP_CONT ::: -------------- ');
2146: hr_utility.trace('EMP_CONT ::: l_base_rate_value = '||l_base_rate_value);
2147: hr_utility.trace('EMP_CONT ::: l_eff_start_date = '||l_eff_start_date);
2148: hr_utility.trace('EMP_CONT ::: l_eff_end_date = '||l_eff_end_date);
2149: hr_utility.trace('EMP_CONT ::: l_no_of_mths = '||l_no_of_mths);
2150: hr_utility.trace('EMP_CONT ::: l_base_rate_value * l_no_of_mths = '||l_base_rate_value * l_no_of_mths);
2151: hr_utility.trace('EMP_CONT ::: l_cum_base_rate_value = '||l_cum_base_rate_value);

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

2144:
2145: hr_utility.trace('EMP_CONT ::: -------------- ');
2146: hr_utility.trace('EMP_CONT ::: l_base_rate_value = '||l_base_rate_value);
2147: hr_utility.trace('EMP_CONT ::: l_eff_start_date = '||l_eff_start_date);
2148: hr_utility.trace('EMP_CONT ::: l_eff_end_date = '||l_eff_end_date);
2149: hr_utility.trace('EMP_CONT ::: l_no_of_mths = '||l_no_of_mths);
2150: hr_utility.trace('EMP_CONT ::: l_base_rate_value * l_no_of_mths = '||l_base_rate_value * l_no_of_mths);
2151: hr_utility.trace('EMP_CONT ::: l_cum_base_rate_value = '||l_cum_base_rate_value);
2152: hr_utility.trace('EMP_CONT ::: -------------- ');

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

2145: hr_utility.trace('EMP_CONT ::: -------------- ');
2146: hr_utility.trace('EMP_CONT ::: l_base_rate_value = '||l_base_rate_value);
2147: hr_utility.trace('EMP_CONT ::: l_eff_start_date = '||l_eff_start_date);
2148: hr_utility.trace('EMP_CONT ::: l_eff_end_date = '||l_eff_end_date);
2149: hr_utility.trace('EMP_CONT ::: l_no_of_mths = '||l_no_of_mths);
2150: hr_utility.trace('EMP_CONT ::: l_base_rate_value * l_no_of_mths = '||l_base_rate_value * l_no_of_mths);
2151: hr_utility.trace('EMP_CONT ::: l_cum_base_rate_value = '||l_cum_base_rate_value);
2152: hr_utility.trace('EMP_CONT ::: -------------- ');
2153:

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

2146: hr_utility.trace('EMP_CONT ::: l_base_rate_value = '||l_base_rate_value);
2147: hr_utility.trace('EMP_CONT ::: l_eff_start_date = '||l_eff_start_date);
2148: hr_utility.trace('EMP_CONT ::: l_eff_end_date = '||l_eff_end_date);
2149: hr_utility.trace('EMP_CONT ::: l_no_of_mths = '||l_no_of_mths);
2150: hr_utility.trace('EMP_CONT ::: l_base_rate_value * l_no_of_mths = '||l_base_rate_value * l_no_of_mths);
2151: hr_utility.trace('EMP_CONT ::: l_cum_base_rate_value = '||l_cum_base_rate_value);
2152: hr_utility.trace('EMP_CONT ::: -------------- ');
2153:
2154: END LOOP; -- end cursor loop

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

2147: hr_utility.trace('EMP_CONT ::: l_eff_start_date = '||l_eff_start_date);
2148: hr_utility.trace('EMP_CONT ::: l_eff_end_date = '||l_eff_end_date);
2149: hr_utility.trace('EMP_CONT ::: l_no_of_mths = '||l_no_of_mths);
2150: hr_utility.trace('EMP_CONT ::: l_base_rate_value * l_no_of_mths = '||l_base_rate_value * l_no_of_mths);
2151: hr_utility.trace('EMP_CONT ::: l_cum_base_rate_value = '||l_cum_base_rate_value);
2152: hr_utility.trace('EMP_CONT ::: -------------- ');
2153:
2154: END LOOP; -- end cursor loop
2155:

Line 2152: hr_utility.trace('EMP_CONT ::: -------------- ');

2148: hr_utility.trace('EMP_CONT ::: l_eff_end_date = '||l_eff_end_date);
2149: hr_utility.trace('EMP_CONT ::: l_no_of_mths = '||l_no_of_mths);
2150: hr_utility.trace('EMP_CONT ::: l_base_rate_value * l_no_of_mths = '||l_base_rate_value * l_no_of_mths);
2151: hr_utility.trace('EMP_CONT ::: l_cum_base_rate_value = '||l_cum_base_rate_value);
2152: hr_utility.trace('EMP_CONT ::: -------------- ');
2153:
2154: END LOOP; -- end cursor loop
2155:
2156: l_avg_base_rate_value := l_cum_base_rate_value / 12 ;

Line 2158: hr_utility.trace('EMP_CONT ::: =================================================== ');

2154: END LOOP; -- end cursor loop
2155:
2156: l_avg_base_rate_value := l_cum_base_rate_value / 12 ;
2157:
2158: hr_utility.trace('EMP_CONT ::: =================================================== ');
2159: hr_utility.trace('EMP_CONT ::: l_cum_base_rate_value = '||l_cum_base_rate_value);
2160: hr_utility.trace('EMP_CONT ::: l_avg_base_rate_value = '||l_avg_base_rate_value);
2161: hr_utility.trace('EMP_CONT ::: ---------------- OVER ---------------- ');
2162:

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

2155:
2156: l_avg_base_rate_value := l_cum_base_rate_value / 12 ;
2157:
2158: hr_utility.trace('EMP_CONT ::: =================================================== ');
2159: hr_utility.trace('EMP_CONT ::: l_cum_base_rate_value = '||l_cum_base_rate_value);
2160: hr_utility.trace('EMP_CONT ::: l_avg_base_rate_value = '||l_avg_base_rate_value);
2161: hr_utility.trace('EMP_CONT ::: ---------------- OVER ---------------- ');
2162:
2163:

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

2156: l_avg_base_rate_value := l_cum_base_rate_value / 12 ;
2157:
2158: hr_utility.trace('EMP_CONT ::: =================================================== ');
2159: hr_utility.trace('EMP_CONT ::: l_cum_base_rate_value = '||l_cum_base_rate_value);
2160: hr_utility.trace('EMP_CONT ::: l_avg_base_rate_value = '||l_avg_base_rate_value);
2161: hr_utility.trace('EMP_CONT ::: ---------------- OVER ---------------- ');
2162:
2163:
2164: RETURN l_avg_base_rate_value ;

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

2157:
2158: hr_utility.trace('EMP_CONT ::: =================================================== ');
2159: hr_utility.trace('EMP_CONT ::: l_cum_base_rate_value = '||l_cum_base_rate_value);
2160: hr_utility.trace('EMP_CONT ::: l_avg_base_rate_value = '||l_avg_base_rate_value);
2161: hr_utility.trace('EMP_CONT ::: ---------------- OVER ---------------- ');
2162:
2163:
2164: RETURN l_avg_base_rate_value ;
2165:

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

2221: l_org_name VARCHAR2(240);
2222:
2223: BEGIN
2224:
2225: hr_utility.trace('EXEM_LIM ::: Entered the procedure for exemption limit ');
2226: --p_err_text := '';
2227:
2228: IF ( g_error_flag = TRUE )
2229:

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

2228: IF ( g_error_flag = TRUE )
2229:
2230: THEN
2231:
2232: hr_utility.trace('EXEM_LIM ::: g_error_flag = TRUE , returning 1' );
2233: RETURN 1 ; -- error has occured already , return 1 to formula funnction and from there just RETURN
2234:
2235: ELSIF ( g_error_check = TRUE )
2236:

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

2234:
2235: ELSIF ( g_error_check = TRUE )
2236:
2237: THEN
2238: hr_utility.trace('EXEM_LIM ::: g_error_flag = FALE but g_error_check = TRUE , returning 0' );
2239: RETURN 0 ; -- checking has been done but no error is there , return 0 to formula function , continue processing
2240:
2241: ELSE -- the error condition has not been checked yet
2242:

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

2239: RETURN 0 ; -- checking has been done but no error is there , return 0 to formula function , continue processing
2240:
2241: ELSE -- the error condition has not been checked yet
2242:
2243: hr_utility.trace('EXEM_LIM ::: both globals are false , nocheck has been performed ');
2244: -- since we are checking the condition now , set the check global to TRUE
2245: g_error_check := TRUE ;
2246: hr_utility.trace('EXEM_LIM ::: made g_error_check := TRUE ');
2247:

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

2242:
2243: hr_utility.trace('EXEM_LIM ::: both globals are false , nocheck has been performed ');
2244: -- since we are checking the condition now , set the check global to TRUE
2245: g_error_check := TRUE ;
2246: hr_utility.trace('EXEM_LIM ::: made g_error_check := TRUE ');
2247:
2248: -- loop thru the cursor csr_get_lu_le and get all LE and LU
2249:
2250: FOR csr_rec in PAY_NO_EMP_CONT.csr_get_lu_le (p_payroll_action_id ,p_date_earned ) LOOP

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

2248: -- loop thru the cursor csr_get_lu_le and get all LE and LU
2249:
2250: FOR csr_rec in PAY_NO_EMP_CONT.csr_get_lu_le (p_payroll_action_id ,p_date_earned ) LOOP
2251:
2252: hr_utility.trace('EXEM_LIM ::: ------------------Inside For loop------------- ' );
2253: hr_utility.trace('EXEM_LIM ::: Local unit id = '||csr_rec.loc_unit ||' Legal Employer ID = '||csr_rec.leg_emp );
2254: -- get the status and report separately for the LU
2255:
2256: OPEN PAY_NO_EMP_CONT.get_lu_details (csr_rec.loc_unit);

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

2249:
2250: FOR csr_rec in PAY_NO_EMP_CONT.csr_get_lu_le (p_payroll_action_id ,p_date_earned ) LOOP
2251:
2252: hr_utility.trace('EXEM_LIM ::: ------------------Inside For loop------------- ' );
2253: hr_utility.trace('EXEM_LIM ::: Local unit id = '||csr_rec.loc_unit ||' Legal Employer ID = '||csr_rec.leg_emp );
2254: -- get the status and report separately for the LU
2255:
2256: OPEN PAY_NO_EMP_CONT.get_lu_details (csr_rec.loc_unit);
2257: FETCH PAY_NO_EMP_CONT.get_lu_details INTO l_status , l_rep_sep ;

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

2256: OPEN PAY_NO_EMP_CONT.get_lu_details (csr_rec.loc_unit);
2257: FETCH PAY_NO_EMP_CONT.get_lu_details INTO l_status , l_rep_sep ;
2258: CLOSE PAY_NO_EMP_CONT.get_lu_details ;
2259:
2260: hr_utility.trace('EXEM_LIM ::: l_status '|| l_status );
2261: hr_utility.trace('EXEM_LIM ::: l_rep_sep '||l_rep_sep );
2262:
2263: -- if report separately = yes and status in OF,HF
2264: IF ( trim(l_rep_sep) = 'Y' ) AND ( l_status IN ('OF','HF') )

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

2257: FETCH PAY_NO_EMP_CONT.get_lu_details INTO l_status , l_rep_sep ;
2258: CLOSE PAY_NO_EMP_CONT.get_lu_details ;
2259:
2260: hr_utility.trace('EXEM_LIM ::: l_status '|| l_status );
2261: hr_utility.trace('EXEM_LIM ::: l_rep_sep '||l_rep_sep );
2262:
2263: -- if report separately = yes and status in OF,HF
2264: IF ( trim(l_rep_sep) = 'Y' ) AND ( l_status IN ('OF','HF') )
2265:

Line 2267: hr_utility.trace('EXEM_LIM ::: local unit is rep sep and status in OF , HF....fetching exemption limit ');

2263: -- if report separately = yes and status in OF,HF
2264: IF ( trim(l_rep_sep) = 'Y' ) AND ( l_status IN ('OF','HF') )
2265:
2266: THEN
2267: hr_utility.trace('EXEM_LIM ::: local unit is rep sep and status in OF , HF....fetching exemption limit ');
2268: -- then open exemption limit cursor
2269: OPEN PAY_NO_EMP_CONT.csr_get_exemption_limit (csr_rec.loc_unit, p_date_earned) ;
2270: FETCH PAY_NO_EMP_CONT.csr_get_exemption_limit INTO l_exempt_limit ;
2271:

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

2272: -- if any error is there
2273: -- checking if no data returned for Exemption Limit
2274: IF (PAY_NO_EMP_CONT.csr_get_exemption_limit%NOTFOUND OR l_exempt_limit IS NULL)
2275: THEN
2276: hr_utility.trace('EXEM_LIM ::: Problem in getting Exemption limit ' );
2277: -- Exemption Limit for this Local Unit Not Specified for this Period or not specified at all
2278:
2279: -- get global error flag to TRUE
2280: g_error_flag := TRUE ;

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

2277: -- Exemption Limit for this Local Unit Not Specified for this Period or not specified at all
2278:
2279: -- get global error flag to TRUE
2280: g_error_flag := TRUE ;
2281: hr_utility.trace('EXEM_LIM ::: set g_error_flag = TRUE ');
2282:
2283: -- get the name of the local unit
2284: OPEN PAY_NO_EMP_CONT.csr_org_name(csr_rec.loc_unit ,p_bus_grp_id );
2285: FETCH PAY_NO_EMP_CONT.csr_org_name INTO l_org_name ;

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

2284: OPEN PAY_NO_EMP_CONT.csr_org_name(csr_rec.loc_unit ,p_bus_grp_id );
2285: FETCH PAY_NO_EMP_CONT.csr_org_name INTO l_org_name ;
2286: CLOSE PAY_NO_EMP_CONT.csr_org_name;
2287:
2288: hr_utility.trace('EXEM_LIM ::: name of local unit = '|| l_org_name );
2289:
2290: -- Set the message and message token
2291: hr_utility.set_message (801, 'PAY_376856_NO_LU_NO_EXEM_LIMIT');
2292: hr_utility.set_message_token (801, 'ORG_NAME', l_org_name);

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

2287:
2288: hr_utility.trace('EXEM_LIM ::: name of local unit = '|| l_org_name );
2289:
2290: -- Set the message and message token
2291: hr_utility.set_message (801, 'PAY_376856_NO_LU_NO_EXEM_LIMIT');
2292: hr_utility.set_message_token (801, 'ORG_NAME', l_org_name);
2293:
2294: hr_utility.trace('EXEM_LIM ::: set the message = '||hr_utility.get_message );
2295:

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

2288: hr_utility.trace('EXEM_LIM ::: name of local unit = '|| l_org_name );
2289:
2290: -- Set the message and message token
2291: hr_utility.set_message (801, 'PAY_376856_NO_LU_NO_EXEM_LIMIT');
2292: hr_utility.set_message_token (801, 'ORG_NAME', l_org_name);
2293:
2294: hr_utility.trace('EXEM_LIM ::: set the message = '||hr_utility.get_message );
2295:
2296: -- Put the meassage in the log file

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

2290: -- Set the message and message token
2291: hr_utility.set_message (801, 'PAY_376856_NO_LU_NO_EXEM_LIMIT');
2292: hr_utility.set_message_token (801, 'ORG_NAME', l_org_name);
2293:
2294: hr_utility.trace('EXEM_LIM ::: set the message = '||hr_utility.get_message );
2295:
2296: -- Put the meassage in the log file
2297: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
2298:

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

2293:
2294: hr_utility.trace('EXEM_LIM ::: set the message = '||hr_utility.get_message );
2295:
2296: -- Put the meassage in the log file
2297: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
2298:
2299: hr_utility.trace('EXEM_LIM ::: put the msg in the log file ');
2300:
2301: -- p_err_text := p_err_text || hr_utility.get_message ;

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

2295:
2296: -- Put the meassage in the log file
2297: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
2298:
2299: hr_utility.trace('EXEM_LIM ::: put the msg in the log file ');
2300:
2301: -- p_err_text := p_err_text || hr_utility.get_message ;
2302:
2303: END IF; -- end exemption limit got check

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

2297: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
2298:
2299: hr_utility.trace('EXEM_LIM ::: put the msg in the log file ');
2300:
2301: -- p_err_text := p_err_text || hr_utility.get_message ;
2302:
2303: END IF; -- end exemption limit got check
2304:
2305: CLOSE PAY_NO_EMP_CONT.csr_get_exemption_limit;

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

2306:
2307: ELSIF ( trim(l_rep_sep) = 'N' ) -- else if LU is not rep sep , check at the legal employer level
2308:
2309: THEN
2310: hr_utility.trace('EXEM_LIM ::: local unit is NOT rep sep....fetching LE Status ');
2311: -- get the status of the LE
2312: OPEN PAY_NO_EMP_CONT.get_le_status (csr_rec.leg_emp) ;
2313: FETCH PAY_NO_EMP_CONT.get_le_status INTO l_status ;
2314: CLOSE PAY_NO_EMP_CONT.get_le_status ;

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

2312: OPEN PAY_NO_EMP_CONT.get_le_status (csr_rec.leg_emp) ;
2313: FETCH PAY_NO_EMP_CONT.get_le_status INTO l_status ;
2314: CLOSE PAY_NO_EMP_CONT.get_le_status ;
2315:
2316: hr_utility.trace('EXEM_LIM ::: LE l_status '|| l_status );
2317:
2318: -- if the status of LE in OF,HF
2319: IF ( l_status IN ('OF','HF') )
2320: THEN

Line 2321: hr_utility.trace('EXEM_LIM ::: Legal Emp status in OF , HF....fetching exemption limit ');

2317:
2318: -- if the status of LE in OF,HF
2319: IF ( l_status IN ('OF','HF') )
2320: THEN
2321: hr_utility.trace('EXEM_LIM ::: Legal Emp status in OF , HF....fetching exemption limit ');
2322: -- then open exemption limit cursor
2323: OPEN PAY_NO_EMP_CONT.csr_get_exemption_limit (csr_rec.leg_emp, p_date_earned) ;
2324: FETCH PAY_NO_EMP_CONT.csr_get_exemption_limit INTO l_exempt_limit ;
2325:

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

2326: -- if any error is there
2327: -- checking if no data returned for Exemption Limit
2328: IF (PAY_NO_EMP_CONT.csr_get_exemption_limit%NOTFOUND OR l_exempt_limit IS NULL)
2329: THEN
2330: hr_utility.trace('EXEM_LIM ::: Problem in getting Exemption limit ' );
2331: -- Exemption Limit for this Legal Emplyer Not Specified for this Period or not specified at all
2332:
2333: -- get global error flag to TRUE
2334: g_error_flag := TRUE ;

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

2331: -- Exemption Limit for this Legal Emplyer Not Specified for this Period or not specified at all
2332:
2333: -- get global error flag to TRUE
2334: g_error_flag := TRUE ;
2335: hr_utility.trace('EXEM_LIM ::: set g_error_flag = TRUE ');
2336:
2337: -- get the name of the Legal Employer
2338: OPEN PAY_NO_EMP_CONT.csr_org_name(csr_rec.leg_emp ,p_bus_grp_id );
2339: FETCH PAY_NO_EMP_CONT.csr_org_name INTO l_org_name ;

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

2338: OPEN PAY_NO_EMP_CONT.csr_org_name(csr_rec.leg_emp ,p_bus_grp_id );
2339: FETCH PAY_NO_EMP_CONT.csr_org_name INTO l_org_name ;
2340: CLOSE PAY_NO_EMP_CONT.csr_org_name;
2341:
2342: hr_utility.trace('EXEM_LIM ::: name of legal employer = '|| l_org_name );
2343:
2344: -- Set the message and message token
2345: hr_utility.set_message (801, 'PAY_376857_NO_LE_NO_EXEM_LIMIT');
2346: hr_utility.set_message_token (801, 'ORG_NAME', l_org_name);

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

2341:
2342: hr_utility.trace('EXEM_LIM ::: name of legal employer = '|| l_org_name );
2343:
2344: -- Set the message and message token
2345: hr_utility.set_message (801, 'PAY_376857_NO_LE_NO_EXEM_LIMIT');
2346: hr_utility.set_message_token (801, 'ORG_NAME', l_org_name);
2347: hr_utility.trace('EXEM_LIM ::: set the message = '||hr_utility.get_message );
2348:
2349: -- Put the meassage in the log file

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

2342: hr_utility.trace('EXEM_LIM ::: name of legal employer = '|| l_org_name );
2343:
2344: -- Set the message and message token
2345: hr_utility.set_message (801, 'PAY_376857_NO_LE_NO_EXEM_LIMIT');
2346: hr_utility.set_message_token (801, 'ORG_NAME', l_org_name);
2347: hr_utility.trace('EXEM_LIM ::: set the message = '||hr_utility.get_message );
2348:
2349: -- Put the meassage in the log file
2350: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);

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

2343:
2344: -- Set the message and message token
2345: hr_utility.set_message (801, 'PAY_376857_NO_LE_NO_EXEM_LIMIT');
2346: hr_utility.set_message_token (801, 'ORG_NAME', l_org_name);
2347: hr_utility.trace('EXEM_LIM ::: set the message = '||hr_utility.get_message );
2348:
2349: -- Put the meassage in the log file
2350: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
2351: hr_utility.trace('EXEM_LIM ::: put the msg in the log file ');

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

2346: hr_utility.set_message_token (801, 'ORG_NAME', l_org_name);
2347: hr_utility.trace('EXEM_LIM ::: set the message = '||hr_utility.get_message );
2348:
2349: -- Put the meassage in the log file
2350: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
2351: hr_utility.trace('EXEM_LIM ::: put the msg in the log file ');
2352:
2353: -- p_err_text := p_err_text || hr_utility.get_message ;
2354:

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

2347: hr_utility.trace('EXEM_LIM ::: set the message = '||hr_utility.get_message );
2348:
2349: -- Put the meassage in the log file
2350: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
2351: hr_utility.trace('EXEM_LIM ::: put the msg in the log file ');
2352:
2353: -- p_err_text := p_err_text || hr_utility.get_message ;
2354:
2355: END IF; -- end exemption limit got check

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

2349: -- Put the meassage in the log file
2350: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
2351: hr_utility.trace('EXEM_LIM ::: put the msg in the log file ');
2352:
2353: -- p_err_text := p_err_text || hr_utility.get_message ;
2354:
2355: END IF; -- end exemption limit got check
2356:
2357: CLOSE PAY_NO_EMP_CONT.csr_get_exemption_limit;

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

2361: END IF ; -- end if report separately = yes and status in OF,HF
2362:
2363: END LOOP; -- end loop thru the cursor csr_get_lu_le and get all LE and LU
2364:
2365: hr_utility.trace('EXEM_LIM ::: **************** end of loop ************* ');
2366:
2367: hr_utility.trace('EXEM_LIM ::: final error check ');
2368:
2369: -- finally check if any error did occur

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

2363: END LOOP; -- end loop thru the cursor csr_get_lu_le and get all LE and LU
2364:
2365: hr_utility.trace('EXEM_LIM ::: **************** end of loop ************* ');
2366:
2367: hr_utility.trace('EXEM_LIM ::: final error check ');
2368:
2369: -- finally check if any error did occur
2370: IF ( g_error_flag = TRUE )
2371: THEN

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

2368:
2369: -- finally check if any error did occur
2370: IF ( g_error_flag = TRUE )
2371: THEN
2372: hr_utility.trace('EXEM_LIM ::: g_error_flag = TRUE , returning 1 ');
2373: RETURN 1 ; -- error did occur
2374: ELSE
2375: hr_utility.trace('EXEM_LIM ::: g_error_flag = FALSE , returning 1 ');
2376: RETURN 0 ; -- error didnot occur

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

2371: THEN
2372: hr_utility.trace('EXEM_LIM ::: g_error_flag = TRUE , returning 1 ');
2373: RETURN 1 ; -- error did occur
2374: ELSE
2375: hr_utility.trace('EXEM_LIM ::: g_error_flag = FALSE , returning 1 ');
2376: RETURN 0 ; -- error didnot occur
2377:
2378: END IF; -- end final check for error
2379: