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_ZA_UIF_REFUND_MARCH_2008 dependencies on HR_UTILITY

Line 183: hr_utility.trace('Row not found for Oct');

179: ) ;
180: exception
181: when others then
182: l_row_found := 'N';
183: hr_utility.trace('Row not found for Oct');
184: end ;
185:
186: if l_row_found = 'Y' and (l_Oct_act_seq is not null) then
187: hr_utility.trace('Inserting row for Assignment :'||p_assignment_id||' month :'||'Oct-2007');

Line 187: hr_utility.trace('Inserting row for Assignment :'||p_assignment_id||' month :'||'Oct-2007');

183: hr_utility.trace('Row not found for Oct');
184: end ;
185:
186: if l_row_found = 'Y' and (l_Oct_act_seq is not null) then
187: hr_utility.trace('Inserting row for Assignment :'||p_assignment_id||' month :'||'Oct-2007');
188: rec_assact(p_rec_count).assignment_id := p_assignment_id;
189: rec_assact(p_rec_count).assignment_number := p_assignment_number;
190: rec_assact(p_rec_count).month_yr := 'Oct-2007';
191: rec_assact(p_rec_count).action_seq := l_Oct_act_seq;

Line 220: hr_utility.trace('Row not found for Nov');

216: ) ;
217: exception
218: when others then
219: l_row_found := 'N';
220: hr_utility.trace('Row not found for Nov');
221: end ;
222:
223: if l_row_found = 'Y' and (l_Nov_act_seq is not null) then
224: hr_utility.trace('Inserting row for Assignment :'||p_assignment_id||' month :'||'Nov-2007');

Line 224: hr_utility.trace('Inserting row for Assignment :'||p_assignment_id||' month :'||'Nov-2007');

220: hr_utility.trace('Row not found for Nov');
221: end ;
222:
223: if l_row_found = 'Y' and (l_Nov_act_seq is not null) then
224: hr_utility.trace('Inserting row for Assignment :'||p_assignment_id||' month :'||'Nov-2007');
225: rec_assact(p_rec_count).assignment_id := p_assignment_id;
226: rec_assact(p_rec_count).assignment_number := p_assignment_number;
227: rec_assact(p_rec_count).month_yr := 'Nov-2007';
228: rec_assact(p_rec_count).action_seq := l_Nov_act_seq;

Line 257: hr_utility.trace('Row not found for Dec');

253: ) ;
254: exception
255: when others then
256: l_row_found := 'N';
257: hr_utility.trace('Row not found for Dec');
258: end ;
259:
260: if l_row_found = 'Y' and (l_Dec_act_seq is not null) then
261: hr_utility.trace('Inserting row for Assignment :'||p_assignment_id||' month :'||'Dec-2007');

Line 261: hr_utility.trace('Inserting row for Assignment :'||p_assignment_id||' month :'||'Dec-2007');

257: hr_utility.trace('Row not found for Dec');
258: end ;
259:
260: if l_row_found = 'Y' and (l_Dec_act_seq is not null) then
261: hr_utility.trace('Inserting row for Assignment :'||p_assignment_id||' month :'||'Dec-2007');
262: rec_assact(p_rec_count).assignment_id := p_assignment_id;
263: rec_assact(p_rec_count).assignment_number := p_assignment_number;
264: rec_assact(p_rec_count).month_yr := 'Dec-2007';
265: rec_assact(p_rec_count).action_seq := l_Dec_act_seq;

Line 293: hr_utility.trace('Row not found for Jan');

289: ) ;
290: exception
291: when others then
292: l_row_found := 'N';
293: hr_utility.trace('Row not found for Jan');
294: end ;
295:
296: if l_row_found = 'Y' and (l_Jan_act_seq is not null) then
297: hr_utility.trace('Inserting row for Assignment :'||p_assignment_id||' month :'||'Jan-2007');

Line 297: hr_utility.trace('Inserting row for Assignment :'||p_assignment_id||' month :'||'Jan-2007');

293: hr_utility.trace('Row not found for Jan');
294: end ;
295:
296: if l_row_found = 'Y' and (l_Jan_act_seq is not null) then
297: hr_utility.trace('Inserting row for Assignment :'||p_assignment_id||' month :'||'Jan-2007');
298: rec_assact(p_rec_count).assignment_id := p_assignment_id;
299: rec_assact(p_rec_count).assignment_number := p_assignment_number;
300: rec_assact(p_rec_count).month_yr := 'Jan-2008';
301: rec_assact(p_rec_count).action_seq := l_Jan_act_seq;

Line 305: hr_utility.trace('Completed row population for assignment '||p_assignment_id);

301: rec_assact(p_rec_count).action_seq := l_Jan_act_seq;
302: p_rec_count := p_rec_count + 1 ;
303: end if;
304:
305: hr_utility.trace('Completed row population for assignment '||p_assignment_id);
306: end populate_assact_tab;
307:
308:
309: -----------------------------------------------------------------------------------------

Line 397: hr_utility.trace('Balances :');

393: -- changed as while testing weekly payrolls, ASG_RUN should be zero.
394: l_UIF_ee_contr_ASG_RUN := 0;
395: l_UIF_er_contr_ASG_RUN := 0;
396:
397: hr_utility.trace('Balances :');
398: hr_utility.trace('l_Tot_UIFable_Inc_ASG_TAX_MTD :'||l_Tot_UIFable_Inc_ASG_TAX_MTD);
399: hr_utility.trace('p_UIF_ee_contr_ASG_TAX_MTD :'||p_UIF_ee_contr_ASG_TAX_MTD);
400: hr_utility.trace('l_UIF_ee_contr_ASG_RUN :'||l_UIF_ee_contr_ASG_RUN);
401: hr_utility.trace('p_UIF_er_contr_ASG_TAX_MTD :'||p_UIF_er_contr_ASG_TAX_MTD);

Line 398: hr_utility.trace('l_Tot_UIFable_Inc_ASG_TAX_MTD :'||l_Tot_UIFable_Inc_ASG_TAX_MTD);

394: l_UIF_ee_contr_ASG_RUN := 0;
395: l_UIF_er_contr_ASG_RUN := 0;
396:
397: hr_utility.trace('Balances :');
398: hr_utility.trace('l_Tot_UIFable_Inc_ASG_TAX_MTD :'||l_Tot_UIFable_Inc_ASG_TAX_MTD);
399: hr_utility.trace('p_UIF_ee_contr_ASG_TAX_MTD :'||p_UIF_ee_contr_ASG_TAX_MTD);
400: hr_utility.trace('l_UIF_ee_contr_ASG_RUN :'||l_UIF_ee_contr_ASG_RUN);
401: hr_utility.trace('p_UIF_er_contr_ASG_TAX_MTD :'||p_UIF_er_contr_ASG_TAX_MTD);
402: hr_utility.trace('p_excs_er_UIF_cntr_ASG_TAX_PTD :'||p_excs_er_UIF_cntr_ASG_TAX_PTD);

Line 399: hr_utility.trace('p_UIF_ee_contr_ASG_TAX_MTD :'||p_UIF_ee_contr_ASG_TAX_MTD);

395: l_UIF_er_contr_ASG_RUN := 0;
396:
397: hr_utility.trace('Balances :');
398: hr_utility.trace('l_Tot_UIFable_Inc_ASG_TAX_MTD :'||l_Tot_UIFable_Inc_ASG_TAX_MTD);
399: hr_utility.trace('p_UIF_ee_contr_ASG_TAX_MTD :'||p_UIF_ee_contr_ASG_TAX_MTD);
400: hr_utility.trace('l_UIF_ee_contr_ASG_RUN :'||l_UIF_ee_contr_ASG_RUN);
401: hr_utility.trace('p_UIF_er_contr_ASG_TAX_MTD :'||p_UIF_er_contr_ASG_TAX_MTD);
402: hr_utility.trace('p_excs_er_UIF_cntr_ASG_TAX_PTD :'||p_excs_er_UIF_cntr_ASG_TAX_PTD);
403: hr_utility.trace('l_UIF_er_contr_ASG_RUN :'||l_UIF_er_contr_ASG_RUN);

Line 400: hr_utility.trace('l_UIF_ee_contr_ASG_RUN :'||l_UIF_ee_contr_ASG_RUN);

396:
397: hr_utility.trace('Balances :');
398: hr_utility.trace('l_Tot_UIFable_Inc_ASG_TAX_MTD :'||l_Tot_UIFable_Inc_ASG_TAX_MTD);
399: hr_utility.trace('p_UIF_ee_contr_ASG_TAX_MTD :'||p_UIF_ee_contr_ASG_TAX_MTD);
400: hr_utility.trace('l_UIF_ee_contr_ASG_RUN :'||l_UIF_ee_contr_ASG_RUN);
401: hr_utility.trace('p_UIF_er_contr_ASG_TAX_MTD :'||p_UIF_er_contr_ASG_TAX_MTD);
402: hr_utility.trace('p_excs_er_UIF_cntr_ASG_TAX_PTD :'||p_excs_er_UIF_cntr_ASG_TAX_PTD);
403: hr_utility.trace('l_UIF_er_contr_ASG_RUN :'||l_UIF_er_contr_ASG_RUN);
404: hr_utility.trace('l_NET_PAY_ASG_RUN :'||l_NET_PAY_ASG_RUN);

Line 401: hr_utility.trace('p_UIF_er_contr_ASG_TAX_MTD :'||p_UIF_er_contr_ASG_TAX_MTD);

397: hr_utility.trace('Balances :');
398: hr_utility.trace('l_Tot_UIFable_Inc_ASG_TAX_MTD :'||l_Tot_UIFable_Inc_ASG_TAX_MTD);
399: hr_utility.trace('p_UIF_ee_contr_ASG_TAX_MTD :'||p_UIF_ee_contr_ASG_TAX_MTD);
400: hr_utility.trace('l_UIF_ee_contr_ASG_RUN :'||l_UIF_ee_contr_ASG_RUN);
401: hr_utility.trace('p_UIF_er_contr_ASG_TAX_MTD :'||p_UIF_er_contr_ASG_TAX_MTD);
402: hr_utility.trace('p_excs_er_UIF_cntr_ASG_TAX_PTD :'||p_excs_er_UIF_cntr_ASG_TAX_PTD);
403: hr_utility.trace('l_UIF_er_contr_ASG_RUN :'||l_UIF_er_contr_ASG_RUN);
404: hr_utility.trace('l_NET_PAY_ASG_RUN :'||l_NET_PAY_ASG_RUN);
405: hr_utility.trace(' ');

Line 402: hr_utility.trace('p_excs_er_UIF_cntr_ASG_TAX_PTD :'||p_excs_er_UIF_cntr_ASG_TAX_PTD);

398: hr_utility.trace('l_Tot_UIFable_Inc_ASG_TAX_MTD :'||l_Tot_UIFable_Inc_ASG_TAX_MTD);
399: hr_utility.trace('p_UIF_ee_contr_ASG_TAX_MTD :'||p_UIF_ee_contr_ASG_TAX_MTD);
400: hr_utility.trace('l_UIF_ee_contr_ASG_RUN :'||l_UIF_ee_contr_ASG_RUN);
401: hr_utility.trace('p_UIF_er_contr_ASG_TAX_MTD :'||p_UIF_er_contr_ASG_TAX_MTD);
402: hr_utility.trace('p_excs_er_UIF_cntr_ASG_TAX_PTD :'||p_excs_er_UIF_cntr_ASG_TAX_PTD);
403: hr_utility.trace('l_UIF_er_contr_ASG_RUN :'||l_UIF_er_contr_ASG_RUN);
404: hr_utility.trace('l_NET_PAY_ASG_RUN :'||l_NET_PAY_ASG_RUN);
405: hr_utility.trace(' ');
406:

Line 403: hr_utility.trace('l_UIF_er_contr_ASG_RUN :'||l_UIF_er_contr_ASG_RUN);

399: hr_utility.trace('p_UIF_ee_contr_ASG_TAX_MTD :'||p_UIF_ee_contr_ASG_TAX_MTD);
400: hr_utility.trace('l_UIF_ee_contr_ASG_RUN :'||l_UIF_ee_contr_ASG_RUN);
401: hr_utility.trace('p_UIF_er_contr_ASG_TAX_MTD :'||p_UIF_er_contr_ASG_TAX_MTD);
402: hr_utility.trace('p_excs_er_UIF_cntr_ASG_TAX_PTD :'||p_excs_er_UIF_cntr_ASG_TAX_PTD);
403: hr_utility.trace('l_UIF_er_contr_ASG_RUN :'||l_UIF_er_contr_ASG_RUN);
404: hr_utility.trace('l_NET_PAY_ASG_RUN :'||l_NET_PAY_ASG_RUN);
405: hr_utility.trace(' ');
406:
407:

Line 404: hr_utility.trace('l_NET_PAY_ASG_RUN :'||l_NET_PAY_ASG_RUN);

400: hr_utility.trace('l_UIF_ee_contr_ASG_RUN :'||l_UIF_ee_contr_ASG_RUN);
401: hr_utility.trace('p_UIF_er_contr_ASG_TAX_MTD :'||p_UIF_er_contr_ASG_TAX_MTD);
402: hr_utility.trace('p_excs_er_UIF_cntr_ASG_TAX_PTD :'||p_excs_er_UIF_cntr_ASG_TAX_PTD);
403: hr_utility.trace('l_UIF_er_contr_ASG_RUN :'||l_UIF_er_contr_ASG_RUN);
404: hr_utility.trace('l_NET_PAY_ASG_RUN :'||l_NET_PAY_ASG_RUN);
405: hr_utility.trace(' ');
406:
407:
408: -- initialise dbis

Line 405: hr_utility.trace(' ');

401: hr_utility.trace('p_UIF_er_contr_ASG_TAX_MTD :'||p_UIF_er_contr_ASG_TAX_MTD);
402: hr_utility.trace('p_excs_er_UIF_cntr_ASG_TAX_PTD :'||p_excs_er_UIF_cntr_ASG_TAX_PTD);
403: hr_utility.trace('l_UIF_er_contr_ASG_RUN :'||l_UIF_er_contr_ASG_RUN);
404: hr_utility.trace('l_NET_PAY_ASG_RUN :'||l_NET_PAY_ASG_RUN);
405: hr_utility.trace(' ');
406:
407:
408: -- initialise dbis
409: l_ZA_PAY_MONTH_PERIOD_NUMBER := get_za_pay_mnth_prd_num(p_payroll_action_id, p_payroll_id);

Line 411: hr_utility.trace('DBIs :');

407:
408: -- initialise dbis
409: l_ZA_PAY_MONTH_PERIOD_NUMBER := get_za_pay_mnth_prd_num(p_payroll_action_id, p_payroll_id);
410: l_ZA_PAY_PERIODS_PER_YEAR := get_py_prd_per_yr(p_payroll_action_id, p_payroll_id) ;
411: hr_utility.trace('DBIs :');
412: hr_utility.trace('l_ZA_PAY_MONTH_PERIOD_NUMBER :'||l_ZA_PAY_MONTH_PERIOD_NUMBER);
413: hr_utility.trace('l_ZA_PAY_PERIODS_PER_YEAR :'||l_ZA_PAY_PERIODS_PER_YEAR);
414: hr_utility.trace(' ');
415:

Line 412: hr_utility.trace('l_ZA_PAY_MONTH_PERIOD_NUMBER :'||l_ZA_PAY_MONTH_PERIOD_NUMBER);

408: -- initialise dbis
409: l_ZA_PAY_MONTH_PERIOD_NUMBER := get_za_pay_mnth_prd_num(p_payroll_action_id, p_payroll_id);
410: l_ZA_PAY_PERIODS_PER_YEAR := get_py_prd_per_yr(p_payroll_action_id, p_payroll_id) ;
411: hr_utility.trace('DBIs :');
412: hr_utility.trace('l_ZA_PAY_MONTH_PERIOD_NUMBER :'||l_ZA_PAY_MONTH_PERIOD_NUMBER);
413: hr_utility.trace('l_ZA_PAY_PERIODS_PER_YEAR :'||l_ZA_PAY_PERIODS_PER_YEAR);
414: hr_utility.trace(' ');
415:
416: -- initialse global values

Line 413: hr_utility.trace('l_ZA_PAY_PERIODS_PER_YEAR :'||l_ZA_PAY_PERIODS_PER_YEAR);

409: l_ZA_PAY_MONTH_PERIOD_NUMBER := get_za_pay_mnth_prd_num(p_payroll_action_id, p_payroll_id);
410: l_ZA_PAY_PERIODS_PER_YEAR := get_py_prd_per_yr(p_payroll_action_id, p_payroll_id) ;
411: hr_utility.trace('DBIs :');
412: hr_utility.trace('l_ZA_PAY_MONTH_PERIOD_NUMBER :'||l_ZA_PAY_MONTH_PERIOD_NUMBER);
413: hr_utility.trace('l_ZA_PAY_PERIODS_PER_YEAR :'||l_ZA_PAY_PERIODS_PER_YEAR);
414: hr_utility.trace(' ');
415:
416: -- initialse global values
417: l_ZA_UIF_ANN_LIM := get_global_value('ZA_UIF_ANN_LIM', p_eff_date);

Line 414: hr_utility.trace(' ');

410: l_ZA_PAY_PERIODS_PER_YEAR := get_py_prd_per_yr(p_payroll_action_id, p_payroll_id) ;
411: hr_utility.trace('DBIs :');
412: hr_utility.trace('l_ZA_PAY_MONTH_PERIOD_NUMBER :'||l_ZA_PAY_MONTH_PERIOD_NUMBER);
413: hr_utility.trace('l_ZA_PAY_PERIODS_PER_YEAR :'||l_ZA_PAY_PERIODS_PER_YEAR);
414: hr_utility.trace(' ');
415:
416: -- initialse global values
417: l_ZA_UIF_ANN_LIM := get_global_value('ZA_UIF_ANN_LIM', p_eff_date);
418: l_ZA_UIF_EMPY_PERC := get_global_value('ZA_UIF_EMPY_PERC', p_eff_date);

Line 420: hr_utility.trace('Globals :');

416: -- initialse global values
417: l_ZA_UIF_ANN_LIM := get_global_value('ZA_UIF_ANN_LIM', p_eff_date);
418: l_ZA_UIF_EMPY_PERC := get_global_value('ZA_UIF_EMPY_PERC', p_eff_date);
419: l_ZA_UIF_EMPR_PERC := get_global_value('ZA_UIF_EMPR_PERC', p_eff_date);
420: hr_utility.trace('Globals :');
421: hr_utility.trace('l_ZA_UIF_ANN_LIM :'||l_ZA_UIF_ANN_LIM);
422: hr_utility.trace('l_ZA_UIF_EMPY_PERC :'||l_ZA_UIF_EMPY_PERC);
423: hr_utility.trace('l_ZA_UIF_EMPR_PERC :'||l_ZA_UIF_EMPR_PERC);
424: hr_utility.trace(' ');

Line 421: hr_utility.trace('l_ZA_UIF_ANN_LIM :'||l_ZA_UIF_ANN_LIM);

417: l_ZA_UIF_ANN_LIM := get_global_value('ZA_UIF_ANN_LIM', p_eff_date);
418: l_ZA_UIF_EMPY_PERC := get_global_value('ZA_UIF_EMPY_PERC', p_eff_date);
419: l_ZA_UIF_EMPR_PERC := get_global_value('ZA_UIF_EMPR_PERC', p_eff_date);
420: hr_utility.trace('Globals :');
421: hr_utility.trace('l_ZA_UIF_ANN_LIM :'||l_ZA_UIF_ANN_LIM);
422: hr_utility.trace('l_ZA_UIF_EMPY_PERC :'||l_ZA_UIF_EMPY_PERC);
423: hr_utility.trace('l_ZA_UIF_EMPR_PERC :'||l_ZA_UIF_EMPR_PERC);
424: hr_utility.trace(' ');
425:

Line 422: hr_utility.trace('l_ZA_UIF_EMPY_PERC :'||l_ZA_UIF_EMPY_PERC);

418: l_ZA_UIF_EMPY_PERC := get_global_value('ZA_UIF_EMPY_PERC', p_eff_date);
419: l_ZA_UIF_EMPR_PERC := get_global_value('ZA_UIF_EMPR_PERC', p_eff_date);
420: hr_utility.trace('Globals :');
421: hr_utility.trace('l_ZA_UIF_ANN_LIM :'||l_ZA_UIF_ANN_LIM);
422: hr_utility.trace('l_ZA_UIF_EMPY_PERC :'||l_ZA_UIF_EMPY_PERC);
423: hr_utility.trace('l_ZA_UIF_EMPR_PERC :'||l_ZA_UIF_EMPR_PERC);
424: hr_utility.trace(' ');
425:
426: -- compute UIF contribution

Line 423: hr_utility.trace('l_ZA_UIF_EMPR_PERC :'||l_ZA_UIF_EMPR_PERC);

419: l_ZA_UIF_EMPR_PERC := get_global_value('ZA_UIF_EMPR_PERC', p_eff_date);
420: hr_utility.trace('Globals :');
421: hr_utility.trace('l_ZA_UIF_ANN_LIM :'||l_ZA_UIF_ANN_LIM);
422: hr_utility.trace('l_ZA_UIF_EMPY_PERC :'||l_ZA_UIF_EMPY_PERC);
423: hr_utility.trace('l_ZA_UIF_EMPR_PERC :'||l_ZA_UIF_EMPR_PERC);
424: hr_utility.trace(' ');
425:
426: -- compute UIF contribution
427: p_ARREAR_UIF := 0 ;

Line 424: hr_utility.trace(' ');

420: hr_utility.trace('Globals :');
421: hr_utility.trace('l_ZA_UIF_ANN_LIM :'||l_ZA_UIF_ANN_LIM);
422: hr_utility.trace('l_ZA_UIF_EMPY_PERC :'||l_ZA_UIF_EMPY_PERC);
423: hr_utility.trace('l_ZA_UIF_EMPR_PERC :'||l_ZA_UIF_EMPR_PERC);
424: hr_utility.trace(' ');
425:
426: -- compute UIF contribution
427: p_ARREAR_UIF := 0 ;
428:

Line 439: hr_utility.trace('1) p_empr_contr = '||p_empr_contr);

435: p_empr_contr := round((l_period_limit * l_ZA_UIF_EMPR_PERC) / 100,2);
436: l_ee_contr := l_ee_contr - (p_UIF_ee_contr_ASG_TAX_MTD - l_UIF_ee_contr_ASG_RUN);
437: p_empr_contr := p_empr_contr - (p_UIF_er_contr_ASG_TAX_MTD - p_excs_er_UIF_cntr_ASG_TAX_PTD -
438: l_UIF_er_contr_ASG_RUN);
439: hr_utility.trace('1) p_empr_contr = '||p_empr_contr);
440: else
441: /* calculate UIF on the period UIFable income */
442: l_ee_contr := round((l_Tot_UIFable_Inc_ASG_TAX_MTD * l_ZA_UIF_EMPY_PERC) / 100,2);
443: p_empr_contr := round((l_Tot_UIFable_Inc_ASG_TAX_MTD * l_ZA_UIF_EMPR_PERC) / 100,2);

Line 447: hr_utility.trace('2) p_empr_contr = '||p_empr_contr);

443: p_empr_contr := round((l_Tot_UIFable_Inc_ASG_TAX_MTD * l_ZA_UIF_EMPR_PERC) / 100,2);
444: l_ee_contr := l_ee_contr - (p_UIF_ee_contr_ASG_TAX_MTD - l_UIF_ee_contr_ASG_RUN);
445: p_empr_contr := p_empr_contr - (p_UIF_er_contr_ASG_TAX_MTD - p_excs_er_UIF_cntr_ASG_TAX_PTD
446: - l_UIF_er_contr_ASG_RUN);
447: hr_utility.trace('2) p_empr_contr = '||p_empr_contr);
448: end if ;
449:
450: if l_ee_contr > 0 then
451: /* check if Net Pay is zero or less */

Line 453: hr_utility.trace('3) Entered '||p_empr_contr);

449:
450: if l_ee_contr > 0 then
451: /* check if Net Pay is zero or less */
452: if l_NET_PAY_ASG_RUN <= 0 then
453: hr_utility.trace('3) Entered '||p_empr_contr);
454: p_ARREAR_UIF := l_ee_contr;
455: l_ee_contr := 0;
456: else
457: /* check if Net Pay is insufficient to deduct the full UIF contribution */

Line 459: hr_utility.trace('4) Entered '||p_empr_contr);

455: l_ee_contr := 0;
456: else
457: /* check if Net Pay is insufficient to deduct the full UIF contribution */
458: if l_ee_contr > l_NET_PAY_ASG_RUN then
459: hr_utility.trace('4) Entered '||p_empr_contr);
460: p_ARREAR_UIF := l_ee_contr - l_NET_PAY_ASG_RUN ;
461: l_ee_contr := l_NET_PAY_ASG_RUN;
462: end if ;
463: end if ;

Line 466: hr_utility.trace('5) Entered '||p_empr_contr);

462: end if ;
463: end if ;
464: else
465: /* Maximum refundable SUM for Employee Contribution */
466: hr_utility.trace('5) Entered '||p_empr_contr);
467: l_refu_ee_contr := p_UIF_ee_contr_ASG_TAX_MTD ;
468: /* Check whether current run is to refud and refund limit is more than allowable amount */
469: IF (l_ee_contr + l_refu_ee_contr) < 0
470: Then

Line 478: hr_utility.trace('6) l_refu_ee_contr : '||l_refu_ee_contr);

474: end if ;
475:
476: /* Maximum refundable SUM for Employer Contribution */
477: l_refu_ee_contr := p_UIF_er_contr_ASG_TAX_MTD - p_excs_er_UIF_cntr_ASG_TAX_PTD ;
478: hr_utility.trace('6) l_refu_ee_contr : '||l_refu_ee_contr);
479:
480: /* Check whether current run is to refud and refund limit is more than allowable amount */
481: if (p_empr_contr + l_refu_ee_contr) < 0 then
482: /* It's refund, thus, it should be negative */

Line 484: hr_utility.trace('7) p_empr_contr : '||p_empr_contr);

480: /* Check whether current run is to refud and refund limit is more than allowable amount */
481: if (p_empr_contr + l_refu_ee_contr) < 0 then
482: /* It's refund, thus, it should be negative */
483: p_empr_contr := 0 - l_refu_ee_contr;
484: hr_utility.trace('7) p_empr_contr : '||p_empr_contr);
485: end if;
486:
487: /* the UIF contribution is deducted, taking into account whether there was enough Net Pay */
488: p_pay_value := l_ee_contr ;

Line 492: hr_utility.trace('8) p_ARREAR_UIF : '||p_ARREAR_UIF);

488: p_pay_value := l_ee_contr ;
489:
490: /* Adjust Excess Employer Contrib already made in the period */
491: p_ARREAR_UIF := p_ARREAR_UIF - p_excs_er_UIF_cntr_ASG_TAX_PTD;
492: hr_utility.trace('8) p_ARREAR_UIF : '||p_ARREAR_UIF);
493:
494: end calc_UIF_contribution ;
495:
496:

Line 705: hr_utility.trace('Entering ' ||l_proc_name);

701:
702: l_proc_name := 'create_retro_ele_entry';
703: l_reflection_date := p_reflection_date ;
704:
705: hr_utility.trace('Entering ' ||l_proc_name);
706: hr_utility.trace('p_ee_contr_ele_type_id :' || p_ee_contr_ele_type_id);
707:
708: -- get end date of the new element entry
709: open csr_ee_end_date (p_payroll_id);

Line 706: hr_utility.trace('p_ee_contr_ele_type_id :' || p_ee_contr_ele_type_id);

702: l_proc_name := 'create_retro_ele_entry';
703: l_reflection_date := p_reflection_date ;
704:
705: hr_utility.trace('Entering ' ||l_proc_name);
706: hr_utility.trace('p_ee_contr_ele_type_id :' || p_ee_contr_ele_type_id);
707:
708: -- get end date of the new element entry
709: open csr_ee_end_date (p_payroll_id);
710: fetch csr_ee_end_date into l_ee_end_date;

Line 713: hr_utility.trace('End date_earned of new element_link_id entry_type :'||to_char(l_ee_end_date));

709: open csr_ee_end_date (p_payroll_id);
710: fetch csr_ee_end_date into l_ee_end_date;
711: close csr_ee_end_date;
712:
713: hr_utility.trace('End date_earned of new element_link_id entry_type :'||to_char(l_ee_end_date));
714:
715: -- get element_link_id for the retro_element
716: open csr_ele_link_id (p_retro_ee_contr_ele_type_id);
717: fetch csr_ele_link_id into l_rtr_ee_cntr_ele_link_id;

Line 720: hr_utility.trace('Element link id for Retro Element :'||l_rtr_ee_cntr_ele_link_id);

716: open csr_ele_link_id (p_retro_ee_contr_ele_type_id);
717: fetch csr_ele_link_id into l_rtr_ee_cntr_ele_link_id;
718: close csr_ele_link_id;
719:
720: hr_utility.trace('Element link id for Retro Element :'||l_rtr_ee_cntr_ele_link_id);
721:
722: hr_utility.set_location(l_proc_name,20);
723:
724: open c_get_ee_dtls (p_ee_contr_ee_id, p_eff_date);

Line 722: hr_utility.set_location(l_proc_name,20);

718: close csr_ele_link_id;
719:
720: hr_utility.trace('Element link id for Retro Element :'||l_rtr_ee_cntr_ele_link_id);
721:
722: hr_utility.set_location(l_proc_name,20);
723:
724: open c_get_ee_dtls (p_ee_contr_ee_id, p_eff_date);
725: fetch c_get_ee_dtls into
726: l_original_entry_id,

Line 761: hr_utility.trace('Values obtained from prev element entry :');

757: l_attribute20,
758: l_label_identifier;
759: close c_get_ee_dtls;
760:
761: hr_utility.trace('Values obtained from prev element entry :');
762: hr_utility.trace('Original_entry_id :'||l_original_entry_id);
763: hr_utility.trace('entry_type :'||l_entry_type);
764: hr_utility.trace('updating_action_id :'||l_updating_action_id);
765: hr_utility.trace('target_entry_id :'||l_target_entry_id);

Line 762: hr_utility.trace('Original_entry_id :'||l_original_entry_id);

758: l_label_identifier;
759: close c_get_ee_dtls;
760:
761: hr_utility.trace('Values obtained from prev element entry :');
762: hr_utility.trace('Original_entry_id :'||l_original_entry_id);
763: hr_utility.trace('entry_type :'||l_entry_type);
764: hr_utility.trace('updating_action_id :'||l_updating_action_id);
765: hr_utility.trace('target_entry_id :'||l_target_entry_id);
766: hr_utility.trace('date_earned :'||to_char(l_date_earned));

Line 763: hr_utility.trace('entry_type :'||l_entry_type);

759: close c_get_ee_dtls;
760:
761: hr_utility.trace('Values obtained from prev element entry :');
762: hr_utility.trace('Original_entry_id :'||l_original_entry_id);
763: hr_utility.trace('entry_type :'||l_entry_type);
764: hr_utility.trace('updating_action_id :'||l_updating_action_id);
765: hr_utility.trace('target_entry_id :'||l_target_entry_id);
766: hr_utility.trace('date_earned :'||to_char(l_date_earned));
767:

Line 764: hr_utility.trace('updating_action_id :'||l_updating_action_id);

760:
761: hr_utility.trace('Values obtained from prev element entry :');
762: hr_utility.trace('Original_entry_id :'||l_original_entry_id);
763: hr_utility.trace('entry_type :'||l_entry_type);
764: hr_utility.trace('updating_action_id :'||l_updating_action_id);
765: hr_utility.trace('target_entry_id :'||l_target_entry_id);
766: hr_utility.trace('date_earned :'||to_char(l_date_earned));
767:
768: if l_entry_type in ('R','A') then

Line 765: hr_utility.trace('target_entry_id :'||l_target_entry_id);

761: hr_utility.trace('Values obtained from prev element entry :');
762: hr_utility.trace('Original_entry_id :'||l_original_entry_id);
763: hr_utility.trace('entry_type :'||l_entry_type);
764: hr_utility.trace('updating_action_id :'||l_updating_action_id);
765: hr_utility.trace('target_entry_id :'||l_target_entry_id);
766: hr_utility.trace('date_earned :'||to_char(l_date_earned));
767:
768: if l_entry_type in ('R','A') then
769: -- Replacement or Additive Adjustment done to element entry

Line 766: hr_utility.trace('date_earned :'||to_char(l_date_earned));

762: hr_utility.trace('Original_entry_id :'||l_original_entry_id);
763: hr_utility.trace('entry_type :'||l_entry_type);
764: hr_utility.trace('updating_action_id :'||l_updating_action_id);
765: hr_utility.trace('target_entry_id :'||l_target_entry_id);
766: hr_utility.trace('date_earned :'||to_char(l_date_earned));
767:
768: if l_entry_type in ('R','A') then
769: -- Replacement or Additive Adjustment done to element entry
770: raise excp_uif_manipulated ;

Line 772: hr_utility.set_location(l_proc_name,30);

768: if l_entry_type in ('R','A') then
769: -- Replacement or Additive Adjustment done to element entry
770: raise excp_uif_manipulated ;
771: end if ;
772: hr_utility.set_location(l_proc_name,30);
773:
774: hr_utility.trace('Creating element entry ');
775: hr_entry_api.insert_element_entry(
776: --

Line 774: hr_utility.trace('Creating element entry ');

770: raise excp_uif_manipulated ;
771: end if ;
772: hr_utility.set_location(l_proc_name,30);
773:
774: hr_utility.trace('Creating element entry ');
775: hr_entry_api.insert_element_entry(
776: --
777: -- Common Parameters
778: --

Line 830: hr_utility.trace('New element entry id :'||l_element_entry_id);

826: -- p_override_user_ent_chk varchar2 default 'N',
827: p_label_identifier => l_label_identifier
828: ) ;
829:
830: hr_utility.trace('New element entry id :'||l_element_entry_id);
831: hr_utility.set_location(l_proc_name,40);
832:
833: select start_date,end_date
834: into l_prev_entry_start_date, l_prev_entry_end_date

Line 831: hr_utility.set_location(l_proc_name,40);

827: p_label_identifier => l_label_identifier
828: ) ;
829:
830: hr_utility.trace('New element entry id :'||l_element_entry_id);
831: hr_utility.set_location(l_proc_name,40);
832:
833: select start_date,end_date
834: into l_prev_entry_start_date, l_prev_entry_end_date
835: from per_time_periods

Line 838: hr_utility.trace('Prev entry Start Date:'||to_char(l_prev_entry_start_date));

834: into l_prev_entry_start_date, l_prev_entry_end_date
835: from per_time_periods
836: where time_period_id = p_time_prd_id ;
837:
838: hr_utility.trace('Prev entry Start Date:'||to_char(l_prev_entry_start_date));
839: hr_utility.trace('Prev entry End Date:'||to_char(l_prev_entry_end_date));
840:
841: update pay_element_entries_f
842: set source_asg_action_id = p_assact_id

Line 839: hr_utility.trace('Prev entry End Date:'||to_char(l_prev_entry_end_date));

835: from per_time_periods
836: where time_period_id = p_time_prd_id ;
837:
838: hr_utility.trace('Prev entry Start Date:'||to_char(l_prev_entry_start_date));
839: hr_utility.trace('Prev entry End Date:'||to_char(l_prev_entry_end_date));
840:
841: update pay_element_entries_f
842: set source_asg_action_id = p_assact_id
843: ,source_start_date = l_prev_entry_start_date

Line 847: hr_utility.trace('SQL%ROWCOUNT :'||SQL%ROWCOUNT);

843: ,source_start_date = l_prev_entry_start_date
844: ,source_end_date = l_prev_entry_end_date
845: where element_entry_id = l_element_entry_id;
846:
847: hr_utility.trace('SQL%ROWCOUNT :'||SQL%ROWCOUNT);
848: if SQL%ROWCOUNT = 0 then
849: hr_utility.trace('Error : No element entry created');
850: end if ;
851: hr_utility.set_location(l_proc_name,50);

Line 849: hr_utility.trace('Error : No element entry created');

845: where element_entry_id = l_element_entry_id;
846:
847: hr_utility.trace('SQL%ROWCOUNT :'||SQL%ROWCOUNT);
848: if SQL%ROWCOUNT = 0 then
849: hr_utility.trace('Error : No element entry created');
850: end if ;
851: hr_utility.set_location(l_proc_name,50);
852: end create_retro_ele_entry;
853:

Line 851: hr_utility.set_location(l_proc_name,50);

847: hr_utility.trace('SQL%ROWCOUNT :'||SQL%ROWCOUNT);
848: if SQL%ROWCOUNT = 0 then
849: hr_utility.trace('Error : No element entry created');
850: end if ;
851: hr_utility.set_location(l_proc_name,50);
852: end create_retro_ele_entry;
853:
854:
855:

Line 935: -- hr_utility.trace_on(null,'ZA_UIF');

931: l_action_type varchar2(10);
932: l_header_printed boolean := false;
933:
934: begin
935: -- hr_utility.trace_on(null,'ZA_UIF');
936:
937: hr_utility.trace('Starting Trace for UIF Refund March 2008');
938: p_reflection_date := to_date(p_reflection_date_char,'YYYY/MM/DD HH24:MI:SS');
939: l_proc_name := 'create_uif_backdated_entries' ;

Line 937: hr_utility.trace('Starting Trace for UIF Refund March 2008');

933:
934: begin
935: -- hr_utility.trace_on(null,'ZA_UIF');
936:
937: hr_utility.trace('Starting Trace for UIF Refund March 2008');
938: p_reflection_date := to_date(p_reflection_date_char,'YYYY/MM/DD HH24:MI:SS');
939: l_proc_name := 'create_uif_backdated_entries' ;
940:
941: hr_utility.set_location('Entering '||l_proc_name,10);

Line 941: hr_utility.set_location('Entering '||l_proc_name,10);

937: hr_utility.trace('Starting Trace for UIF Refund March 2008');
938: p_reflection_date := to_date(p_reflection_date_char,'YYYY/MM/DD HH24:MI:SS');
939: l_proc_name := 'create_uif_backdated_entries' ;
940:
941: hr_utility.set_location('Entering '||l_proc_name,10);
942: hr_utility.set_location('payroll_id : ' || p_payroll_id,1);
943: hr_utility.set_location('Effective_date : ' || p_reflection_date,1);
944: hr_utility.set_location('Assignment Set Id : ' ||p_asg_set_id,1);
945:

Line 942: hr_utility.set_location('payroll_id : ' || p_payroll_id,1);

938: p_reflection_date := to_date(p_reflection_date_char,'YYYY/MM/DD HH24:MI:SS');
939: l_proc_name := 'create_uif_backdated_entries' ;
940:
941: hr_utility.set_location('Entering '||l_proc_name,10);
942: hr_utility.set_location('payroll_id : ' || p_payroll_id,1);
943: hr_utility.set_location('Effective_date : ' || p_reflection_date,1);
944: hr_utility.set_location('Assignment Set Id : ' ||p_asg_set_id,1);
945:
946:

Line 943: hr_utility.set_location('Effective_date : ' || p_reflection_date,1);

939: l_proc_name := 'create_uif_backdated_entries' ;
940:
941: hr_utility.set_location('Entering '||l_proc_name,10);
942: hr_utility.set_location('payroll_id : ' || p_payroll_id,1);
943: hr_utility.set_location('Effective_date : ' || p_reflection_date,1);
944: hr_utility.set_location('Assignment Set Id : ' ||p_asg_set_id,1);
945:
946:
947: ---------------------------------------------------------------------------

Line 944: hr_utility.set_location('Assignment Set Id : ' ||p_asg_set_id,1);

940:
941: hr_utility.set_location('Entering '||l_proc_name,10);
942: hr_utility.set_location('payroll_id : ' || p_payroll_id,1);
943: hr_utility.set_location('Effective_date : ' || p_reflection_date,1);
944: hr_utility.set_location('Assignment Set Id : ' ||p_asg_set_id,1);
945:
946:
947: ---------------------------------------------------------------------------
948: -------------- Get Element Details -------------------------

Line 959: hr_utility.set_location('l_ee_contr_ele_type_id : ' || l_ee_contr_ele_type_id,2);

955: get_ele_dtls ('ZA_Retro_UIF_Employee_Contribution',sysdate,l_retro_ee_contr_ele_type_id,l_retro_ee_contr_ip_value_id);
956: get_ele_dtls ('ZA_Retro_UIF_Employer_Contribution',sysdate,l_retro_er_contr_ele_type_id,l_retro_er_contr_ip_value_id);
957: get_ele_dtls ('ZA Retro Excess Employer UIF Contribution',sysdate,l_retro_excs_er_cntr_ele_tp_id,l_retro_excs_er_cntr_ip_val_id);
958:
959: hr_utility.set_location('l_ee_contr_ele_type_id : ' || l_ee_contr_ele_type_id,2);
960: hr_utility.set_location('l_ee_contr_ip_value_id : ' || l_ee_contr_ip_value_id,2);
961: hr_utility.set_location('l_er_contr_ele_type_id : ' || l_er_contr_ele_type_id,2);
962: hr_utility.set_location('l_er_contr_ip_value_id : ' || l_er_contr_ip_value_id,2);
963: hr_utility.set_location('l_excs_er_contr_ele_type_id : ' || l_excs_er_contr_ele_type_id,2);

Line 960: hr_utility.set_location('l_ee_contr_ip_value_id : ' || l_ee_contr_ip_value_id,2);

956: get_ele_dtls ('ZA_Retro_UIF_Employer_Contribution',sysdate,l_retro_er_contr_ele_type_id,l_retro_er_contr_ip_value_id);
957: get_ele_dtls ('ZA Retro Excess Employer UIF Contribution',sysdate,l_retro_excs_er_cntr_ele_tp_id,l_retro_excs_er_cntr_ip_val_id);
958:
959: hr_utility.set_location('l_ee_contr_ele_type_id : ' || l_ee_contr_ele_type_id,2);
960: hr_utility.set_location('l_ee_contr_ip_value_id : ' || l_ee_contr_ip_value_id,2);
961: hr_utility.set_location('l_er_contr_ele_type_id : ' || l_er_contr_ele_type_id,2);
962: hr_utility.set_location('l_er_contr_ip_value_id : ' || l_er_contr_ip_value_id,2);
963: hr_utility.set_location('l_excs_er_contr_ele_type_id : ' || l_excs_er_contr_ele_type_id,2);
964: hr_utility.set_location('l_excs_er_contr_ip_value_id : ' || l_excs_er_contr_ip_value_id,2);

Line 961: hr_utility.set_location('l_er_contr_ele_type_id : ' || l_er_contr_ele_type_id,2);

957: get_ele_dtls ('ZA Retro Excess Employer UIF Contribution',sysdate,l_retro_excs_er_cntr_ele_tp_id,l_retro_excs_er_cntr_ip_val_id);
958:
959: hr_utility.set_location('l_ee_contr_ele_type_id : ' || l_ee_contr_ele_type_id,2);
960: hr_utility.set_location('l_ee_contr_ip_value_id : ' || l_ee_contr_ip_value_id,2);
961: hr_utility.set_location('l_er_contr_ele_type_id : ' || l_er_contr_ele_type_id,2);
962: hr_utility.set_location('l_er_contr_ip_value_id : ' || l_er_contr_ip_value_id,2);
963: hr_utility.set_location('l_excs_er_contr_ele_type_id : ' || l_excs_er_contr_ele_type_id,2);
964: hr_utility.set_location('l_excs_er_contr_ip_value_id : ' || l_excs_er_contr_ip_value_id,2);
965: exception

Line 962: hr_utility.set_location('l_er_contr_ip_value_id : ' || l_er_contr_ip_value_id,2);

958:
959: hr_utility.set_location('l_ee_contr_ele_type_id : ' || l_ee_contr_ele_type_id,2);
960: hr_utility.set_location('l_ee_contr_ip_value_id : ' || l_ee_contr_ip_value_id,2);
961: hr_utility.set_location('l_er_contr_ele_type_id : ' || l_er_contr_ele_type_id,2);
962: hr_utility.set_location('l_er_contr_ip_value_id : ' || l_er_contr_ip_value_id,2);
963: hr_utility.set_location('l_excs_er_contr_ele_type_id : ' || l_excs_er_contr_ele_type_id,2);
964: hr_utility.set_location('l_excs_er_contr_ip_value_id : ' || l_excs_er_contr_ip_value_id,2);
965: exception
966: WHEN others then

Line 963: hr_utility.set_location('l_excs_er_contr_ele_type_id : ' || l_excs_er_contr_ele_type_id,2);

959: hr_utility.set_location('l_ee_contr_ele_type_id : ' || l_ee_contr_ele_type_id,2);
960: hr_utility.set_location('l_ee_contr_ip_value_id : ' || l_ee_contr_ip_value_id,2);
961: hr_utility.set_location('l_er_contr_ele_type_id : ' || l_er_contr_ele_type_id,2);
962: hr_utility.set_location('l_er_contr_ip_value_id : ' || l_er_contr_ip_value_id,2);
963: hr_utility.set_location('l_excs_er_contr_ele_type_id : ' || l_excs_er_contr_ele_type_id,2);
964: hr_utility.set_location('l_excs_er_contr_ip_value_id : ' || l_excs_er_contr_ip_value_id,2);
965: exception
966: WHEN others then
967: hr_utility.set_location('ERROR while getting element_details ',9999);

Line 964: hr_utility.set_location('l_excs_er_contr_ip_value_id : ' || l_excs_er_contr_ip_value_id,2);

960: hr_utility.set_location('l_ee_contr_ip_value_id : ' || l_ee_contr_ip_value_id,2);
961: hr_utility.set_location('l_er_contr_ele_type_id : ' || l_er_contr_ele_type_id,2);
962: hr_utility.set_location('l_er_contr_ip_value_id : ' || l_er_contr_ip_value_id,2);
963: hr_utility.set_location('l_excs_er_contr_ele_type_id : ' || l_excs_er_contr_ele_type_id,2);
964: hr_utility.set_location('l_excs_er_contr_ip_value_id : ' || l_excs_er_contr_ip_value_id,2);
965: exception
966: WHEN others then
967: hr_utility.set_location('ERROR while getting element_details ',9999);
968: hr_utility.set_location('Error code is ' || SQLCODE, 9999);

Line 967: hr_utility.set_location('ERROR while getting element_details ',9999);

963: hr_utility.set_location('l_excs_er_contr_ele_type_id : ' || l_excs_er_contr_ele_type_id,2);
964: hr_utility.set_location('l_excs_er_contr_ip_value_id : ' || l_excs_er_contr_ip_value_id,2);
965: exception
966: WHEN others then
967: hr_utility.set_location('ERROR while getting element_details ',9999);
968: hr_utility.set_location('Error code is ' || SQLCODE, 9999);
969: hr_utility.set_location('Error Messages' || substr(SQLERRM,1,255), 9999);
970: RAISE;
971: end;

Line 968: hr_utility.set_location('Error code is ' || SQLCODE, 9999);

964: hr_utility.set_location('l_excs_er_contr_ip_value_id : ' || l_excs_er_contr_ip_value_id,2);
965: exception
966: WHEN others then
967: hr_utility.set_location('ERROR while getting element_details ',9999);
968: hr_utility.set_location('Error code is ' || SQLCODE, 9999);
969: hr_utility.set_location('Error Messages' || substr(SQLERRM,1,255), 9999);
970: RAISE;
971: end;
972:

Line 969: hr_utility.set_location('Error Messages' || substr(SQLERRM,1,255), 9999);

965: exception
966: WHEN others then
967: hr_utility.set_location('ERROR while getting element_details ',9999);
968: hr_utility.set_location('Error code is ' || SQLCODE, 9999);
969: hr_utility.set_location('Error Messages' || substr(SQLERRM,1,255), 9999);
970: RAISE;
971: end;
972:
973: ---------------------------------------------------------------------------

Line 1009: hr_utility.set_location('Excluding Assignment '||rec_all_asg_ids.assignment_id,10);

1005: and assignment_id = rec_all_asg_ids.assignment_id;
1006:
1007: if inc_flag = 'E' then
1008: asg_include := FALSE;
1009: hr_utility.set_location('Excluding Assignment '||rec_all_asg_ids.assignment_id,10);
1010: else
1011: hr_utility.set_location('Including Assignment '||rec_all_asg_ids.assignment_id,20);
1012: end if;
1013: exception

Line 1011: hr_utility.set_location('Including Assignment '||rec_all_asg_ids.assignment_id,20);

1007: if inc_flag = 'E' then
1008: asg_include := FALSE;
1009: hr_utility.set_location('Excluding Assignment '||rec_all_asg_ids.assignment_id,10);
1010: else
1011: hr_utility.set_location('Including Assignment '||rec_all_asg_ids.assignment_id,20);
1012: end if;
1013: exception
1014: when no_data_found then
1015: if v_incl_sw = 'I' then

Line 1017: hr_utility.set_location('Excluding Assignment '||rec_all_asg_ids.assignment_id,30);

1013: exception
1014: when no_data_found then
1015: if v_incl_sw = 'I' then
1016: asg_include := FALSE;
1017: hr_utility.set_location('Excluding Assignment '||rec_all_asg_ids.assignment_id,30);
1018: else
1019: asg_include := TRUE;
1020: hr_utility.set_location('Including Assignment '||rec_all_asg_ids.assignment_id,40);
1021: end if;

Line 1020: hr_utility.set_location('Including Assignment '||rec_all_asg_ids.assignment_id,40);

1016: asg_include := FALSE;
1017: hr_utility.set_location('Excluding Assignment '||rec_all_asg_ids.assignment_id,30);
1018: else
1019: asg_include := TRUE;
1020: hr_utility.set_location('Including Assignment '||rec_all_asg_ids.assignment_id,40);
1021: end if;
1022: end ;
1023: end if;
1024:

Line 1029: hr_utility.trace('Populating table for assignment_id :'||rec_all_asg_ids.assignment_id||' assignment_number :'||rec_all_asg_ids.assignment_number) ;

1025: if asg_include = TRUE then
1026: -- Populate table rec_assact with max(action_sequence)
1027: -- for all the assignment for the months Oct2007 - Jan2008.
1028: -- The table will contain 4 rows (for each month) per assignment
1029: hr_utility.trace('Populating table for assignment_id :'||rec_all_asg_ids.assignment_id||' assignment_number :'||rec_all_asg_ids.assignment_number) ;
1030: populate_assact_tab (rec_assact,
1031: rec_all_asg_ids.assignment_id,
1032: rec_all_asg_ids.assignment_number,
1033: l_rec_count,

Line 1039: hr_utility.trace('rec_assact.count :'||rec_assact.count);

1035: end if ;
1036: end loop ;
1037:
1038: -- Loop through all the assignments per month
1039: hr_utility.trace('rec_assact.count :'||rec_assact.count);
1040:
1041: -- Checking if there is any row to process
1042: if rec_assact.first is null then
1043: hr_utility.trace('No assignment to process... Exitting');

Line 1043: hr_utility.trace('No assignment to process... Exitting');

1039: hr_utility.trace('rec_assact.count :'||rec_assact.count);
1040:
1041: -- Checking if there is any row to process
1042: if rec_assact.first is null then
1043: hr_utility.trace('No assignment to process... Exitting');
1044: return ;
1045: end if ;
1046:
1047: l_last_printed_asg := -1 ;

Line 1055: hr_utility.trace('Processing Assignment_ID : '||rec_assact(rec_count).assignment_id);

1051: -- Get payroll_action and assignment_action details
1052: -- for the action_sequence
1053: begin
1054:
1055: hr_utility.trace('Processing Assignment_ID : '||rec_assact(rec_count).assignment_id);
1056: hr_utility.trace('Action Sequence : '||rec_assact(rec_count).action_seq);
1057:
1058:
1059: begin

Line 1056: hr_utility.trace('Action Sequence : '||rec_assact(rec_count).action_seq);

1052: -- for the action_sequence
1053: begin
1054:
1055: hr_utility.trace('Processing Assignment_ID : '||rec_assact(rec_count).assignment_id);
1056: hr_utility.trace('Action Sequence : '||rec_assact(rec_count).action_seq);
1057:
1058:
1059: begin
1060: select ppa.payroll_action_id

Line 1079: hr_utility.trace('Error while fetching payroll_action/assignment_action details for assignment_id '||rec_assact(rec_count).assignment_id);

1075: and paa.action_sequence = rec_assact(rec_count).action_seq
1076: and paa.assignment_id = rec_assact(rec_count).assignment_id ;
1077: exception
1078: when others then
1079: hr_utility.trace('Error while fetching payroll_action/assignment_action details for assignment_id '||rec_assact(rec_count).assignment_id);
1080: RAISE;
1081: end ;
1082:
1083: hr_utility.trace('Month_Year : '||rec_assact(rec_count).month_yr);

Line 1083: hr_utility.trace('Month_Year : '||rec_assact(rec_count).month_yr);

1079: hr_utility.trace('Error while fetching payroll_action/assignment_action details for assignment_id '||rec_assact(rec_count).assignment_id);
1080: RAISE;
1081: end ;
1082:
1083: hr_utility.trace('Month_Year : '||rec_assact(rec_count).month_yr);
1084: hr_utility.trace('Payroll_action_id : '||l_pact_id);
1085: hr_utility.trace('Assignment_action_id : '||l_assact_id);
1086: hr_utility.trace('Effective_Date : '||l_eff_date);
1087: hr_utility.trace('Time_Period_ID : '||l_time_prd_id);

Line 1084: hr_utility.trace('Payroll_action_id : '||l_pact_id);

1080: RAISE;
1081: end ;
1082:
1083: hr_utility.trace('Month_Year : '||rec_assact(rec_count).month_yr);
1084: hr_utility.trace('Payroll_action_id : '||l_pact_id);
1085: hr_utility.trace('Assignment_action_id : '||l_assact_id);
1086: hr_utility.trace('Effective_Date : '||l_eff_date);
1087: hr_utility.trace('Time_Period_ID : '||l_time_prd_id);
1088: hr_utility.trace('Action_Type : '||l_action_type);

Line 1085: hr_utility.trace('Assignment_action_id : '||l_assact_id);

1081: end ;
1082:
1083: hr_utility.trace('Month_Year : '||rec_assact(rec_count).month_yr);
1084: hr_utility.trace('Payroll_action_id : '||l_pact_id);
1085: hr_utility.trace('Assignment_action_id : '||l_assact_id);
1086: hr_utility.trace('Effective_Date : '||l_eff_date);
1087: hr_utility.trace('Time_Period_ID : '||l_time_prd_id);
1088: hr_utility.trace('Action_Type : '||l_action_type);
1089:

Line 1086: hr_utility.trace('Effective_Date : '||l_eff_date);

1082:
1083: hr_utility.trace('Month_Year : '||rec_assact(rec_count).month_yr);
1084: hr_utility.trace('Payroll_action_id : '||l_pact_id);
1085: hr_utility.trace('Assignment_action_id : '||l_assact_id);
1086: hr_utility.trace('Effective_Date : '||l_eff_date);
1087: hr_utility.trace('Time_Period_ID : '||l_time_prd_id);
1088: hr_utility.trace('Action_Type : '||l_action_type);
1089:
1090: -- Get MTD balances for UIF contributions

Line 1087: hr_utility.trace('Time_Period_ID : '||l_time_prd_id);

1083: hr_utility.trace('Month_Year : '||rec_assact(rec_count).month_yr);
1084: hr_utility.trace('Payroll_action_id : '||l_pact_id);
1085: hr_utility.trace('Assignment_action_id : '||l_assact_id);
1086: hr_utility.trace('Effective_Date : '||l_eff_date);
1087: hr_utility.trace('Time_Period_ID : '||l_time_prd_id);
1088: hr_utility.trace('Action_Type : '||l_action_type);
1089:
1090: -- Get MTD balances for UIF contributions
1091: -- commented while testing for weekly payrolls

Line 1088: hr_utility.trace('Action_Type : '||l_action_type);

1084: hr_utility.trace('Payroll_action_id : '||l_pact_id);
1085: hr_utility.trace('Assignment_action_id : '||l_assact_id);
1086: hr_utility.trace('Effective_Date : '||l_eff_date);
1087: hr_utility.trace('Time_Period_ID : '||l_time_prd_id);
1088: hr_utility.trace('Action_Type : '||l_action_type);
1089:
1090: -- Get MTD balances for UIF contributions
1091: -- commented while testing for weekly payrolls
1092: -- l_prev_ee_cntr := nvl(get_balance_value('UIF Employee Contribution','_ASG_TAX_MTD',l_assact_id),0);

Line 1106: hr_utility.trace('Process run count :'||l_process_run_count);

1102: and element_type_id in (l_retro_ee_contr_ele_type_id,
1103: l_retro_er_contr_ele_type_id,
1104: l_retro_excs_er_cntr_ele_tp_id);
1105:
1106: hr_utility.trace('Process run count :'||l_process_run_count);
1107:
1108: if l_process_run_count = 0 then
1109: if l_action_type in ('B','V','I') then
1110: raise excp_uif_manipulated ;

Line 1121: hr_utility.trace('Calculated UIF Contributions :');

1117: l_calc_ee_contr := nvl(l_calc_ee_contr,0);
1118: l_calc_empr_contr := nvl(l_calc_empr_contr,0);
1119: l_calc_ARREAR_UIF := nvl(l_calc_ARREAR_UIF,0);
1120:
1121: hr_utility.trace('Calculated UIF Contributions :');
1122: hr_utility.trace('Employee Contribution :'|| l_calc_ee_contr);
1123: hr_utility.trace('Employer Contribution :'|| l_calc_empr_contr);
1124: hr_utility.trace('Arrears :'|| l_calc_ARREAR_UIF);
1125: hr_utility.trace('Balance UIF_Employee_Contribution_ASG_TAX_MTD :'||l_prev_ee_cntr);

Line 1122: hr_utility.trace('Employee Contribution :'|| l_calc_ee_contr);

1118: l_calc_empr_contr := nvl(l_calc_empr_contr,0);
1119: l_calc_ARREAR_UIF := nvl(l_calc_ARREAR_UIF,0);
1120:
1121: hr_utility.trace('Calculated UIF Contributions :');
1122: hr_utility.trace('Employee Contribution :'|| l_calc_ee_contr);
1123: hr_utility.trace('Employer Contribution :'|| l_calc_empr_contr);
1124: hr_utility.trace('Arrears :'|| l_calc_ARREAR_UIF);
1125: hr_utility.trace('Balance UIF_Employee_Contribution_ASG_TAX_MTD :'||l_prev_ee_cntr);
1126: hr_utility.trace('Balance UIF_Employer_Contribution_ASG_TAX_MTD :'||l_prev_er_cntr);

Line 1123: hr_utility.trace('Employer Contribution :'|| l_calc_empr_contr);

1119: l_calc_ARREAR_UIF := nvl(l_calc_ARREAR_UIF,0);
1120:
1121: hr_utility.trace('Calculated UIF Contributions :');
1122: hr_utility.trace('Employee Contribution :'|| l_calc_ee_contr);
1123: hr_utility.trace('Employer Contribution :'|| l_calc_empr_contr);
1124: hr_utility.trace('Arrears :'|| l_calc_ARREAR_UIF);
1125: hr_utility.trace('Balance UIF_Employee_Contribution_ASG_TAX_MTD :'||l_prev_ee_cntr);
1126: hr_utility.trace('Balance UIF_Employer_Contribution_ASG_TAX_MTD :'||l_prev_er_cntr);
1127: hr_utility.trace('Balance Excess_Employer_UIF_Contrib_ASG_TAX_PTD :'||l_prev_excs_er_cntr);

Line 1124: hr_utility.trace('Arrears :'|| l_calc_ARREAR_UIF);

1120:
1121: hr_utility.trace('Calculated UIF Contributions :');
1122: hr_utility.trace('Employee Contribution :'|| l_calc_ee_contr);
1123: hr_utility.trace('Employer Contribution :'|| l_calc_empr_contr);
1124: hr_utility.trace('Arrears :'|| l_calc_ARREAR_UIF);
1125: hr_utility.trace('Balance UIF_Employee_Contribution_ASG_TAX_MTD :'||l_prev_ee_cntr);
1126: hr_utility.trace('Balance UIF_Employer_Contribution_ASG_TAX_MTD :'||l_prev_er_cntr);
1127: hr_utility.trace('Balance Excess_Employer_UIF_Contrib_ASG_TAX_PTD :'||l_prev_excs_er_cntr);
1128:

Line 1125: hr_utility.trace('Balance UIF_Employee_Contribution_ASG_TAX_MTD :'||l_prev_ee_cntr);

1121: hr_utility.trace('Calculated UIF Contributions :');
1122: hr_utility.trace('Employee Contribution :'|| l_calc_ee_contr);
1123: hr_utility.trace('Employer Contribution :'|| l_calc_empr_contr);
1124: hr_utility.trace('Arrears :'|| l_calc_ARREAR_UIF);
1125: hr_utility.trace('Balance UIF_Employee_Contribution_ASG_TAX_MTD :'||l_prev_ee_cntr);
1126: hr_utility.trace('Balance UIF_Employer_Contribution_ASG_TAX_MTD :'||l_prev_er_cntr);
1127: hr_utility.trace('Balance Excess_Employer_UIF_Contrib_ASG_TAX_PTD :'||l_prev_excs_er_cntr);
1128:
1129: -- Calculate differences between the previous balances and the

Line 1126: hr_utility.trace('Balance UIF_Employer_Contribution_ASG_TAX_MTD :'||l_prev_er_cntr);

1122: hr_utility.trace('Employee Contribution :'|| l_calc_ee_contr);
1123: hr_utility.trace('Employer Contribution :'|| l_calc_empr_contr);
1124: hr_utility.trace('Arrears :'|| l_calc_ARREAR_UIF);
1125: hr_utility.trace('Balance UIF_Employee_Contribution_ASG_TAX_MTD :'||l_prev_ee_cntr);
1126: hr_utility.trace('Balance UIF_Employer_Contribution_ASG_TAX_MTD :'||l_prev_er_cntr);
1127: hr_utility.trace('Balance Excess_Employer_UIF_Contrib_ASG_TAX_PTD :'||l_prev_excs_er_cntr);
1128:
1129: -- Calculate differences between the previous balances and the
1130: -- the newly calculated UIF contributions

Line 1127: hr_utility.trace('Balance Excess_Employer_UIF_Contrib_ASG_TAX_PTD :'||l_prev_excs_er_cntr);

1123: hr_utility.trace('Employer Contribution :'|| l_calc_empr_contr);
1124: hr_utility.trace('Arrears :'|| l_calc_ARREAR_UIF);
1125: hr_utility.trace('Balance UIF_Employee_Contribution_ASG_TAX_MTD :'||l_prev_ee_cntr);
1126: hr_utility.trace('Balance UIF_Employer_Contribution_ASG_TAX_MTD :'||l_prev_er_cntr);
1127: hr_utility.trace('Balance Excess_Employer_UIF_Contrib_ASG_TAX_PTD :'||l_prev_excs_er_cntr);
1128:
1129: -- Calculate differences between the previous balances and the
1130: -- the newly calculated UIF contributions
1131:

Line 1141: hr_utility.trace('Differences :'||l_diff_ee_contr|| ' '|| l_diff_er_contr||' '||l_diff_excs_er_contr);

1137: l_diff_ee_contr := l_calc_ee_contr ;
1138: l_diff_er_contr := l_calc_empr_contr ;
1139: l_diff_excs_er_contr := l_calc_ARREAR_UIF ;
1140:
1141: hr_utility.trace('Differences :'||l_diff_ee_contr|| ' '|| l_diff_er_contr||' '||l_diff_excs_er_contr);
1142:
1143: -- get element_entry_id for previous UIF contribution element
1144: open c_get_ee_id(l_ee_contr_ele_type_id, l_assact_id);
1145: fetch c_get_ee_id into l_ee_contr_ee_id ;

Line 1148: hr_utility.trace('Element entry ID of prev UIF contri elem :'||l_ee_contr_ee_id);

1144: open c_get_ee_id(l_ee_contr_ele_type_id, l_assact_id);
1145: fetch c_get_ee_id into l_ee_contr_ee_id ;
1146: close c_get_ee_id ;
1147:
1148: hr_utility.trace('Element entry ID of prev UIF contri elem :'||l_ee_contr_ee_id);
1149:
1150: -- Create element entries for the differences
1151: hr_utility.trace('Creating element entry for Employee COntribution');
1152: if l_diff_ee_contr <> 0 then

Line 1151: hr_utility.trace('Creating element entry for Employee COntribution');

1147:
1148: hr_utility.trace('Element entry ID of prev UIF contri elem :'||l_ee_contr_ee_id);
1149:
1150: -- Create element entries for the differences
1151: hr_utility.trace('Creating element entry for Employee COntribution');
1152: if l_diff_ee_contr <> 0 then
1153: create_retro_ele_entry(l_ee_contr_ele_type_id
1154: ,l_retro_ee_contr_ele_type_id
1155: ,l_retro_ee_contr_ip_value_id

Line 1165: hr_utility.set_location(l_proc_name,100);

1161: ,l_time_prd_id
1162: ,l_diff_ee_contr
1163: ,l_ee_contr_ee_id
1164: );
1165: hr_utility.set_location(l_proc_name,100);
1166: end if ;
1167:
1168: hr_utility.trace('Creating element entry for Employer COntribution');
1169: if l_diff_er_contr <> 0 then

Line 1168: hr_utility.trace('Creating element entry for Employer COntribution');

1164: );
1165: hr_utility.set_location(l_proc_name,100);
1166: end if ;
1167:
1168: hr_utility.trace('Creating element entry for Employer COntribution');
1169: if l_diff_er_contr <> 0 then
1170: create_retro_ele_entry(l_er_contr_ele_type_id
1171: ,l_retro_er_contr_ele_type_id
1172: ,l_retro_er_contr_ip_value_id

Line 1182: hr_utility.set_location(l_proc_name,110);

1178: ,l_time_prd_id
1179: ,l_diff_er_contr
1180: ,l_ee_contr_ee_id
1181: );
1182: hr_utility.set_location(l_proc_name,110);
1183: end if ;
1184:
1185: hr_utility.trace('Creating element entry for Excess Employer COntribution');
1186: if l_diff_excs_er_contr <> 0 then

Line 1185: hr_utility.trace('Creating element entry for Excess Employer COntribution');

1181: );
1182: hr_utility.set_location(l_proc_name,110);
1183: end if ;
1184:
1185: hr_utility.trace('Creating element entry for Excess Employer COntribution');
1186: if l_diff_excs_er_contr <> 0 then
1187: create_retro_ele_entry(l_excs_er_contr_ele_type_id
1188: ,l_retro_excs_er_cntr_ele_tp_id
1189: ,l_retro_excs_er_cntr_ip_val_id

Line 1199: hr_utility.set_location(l_proc_name,120);

1195: ,l_time_prd_id
1196: ,l_diff_excs_er_contr
1197: ,l_ee_contr_ee_id
1198: );
1199: hr_utility.set_location(l_proc_name,120);
1200: end if ;
1201:
1202: /**********************************
1203: ***** Printing the report ********

Line 1242: hr_utility.trace('Process already run for assignment_id :'||l_asg_id);

1238: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('Excess Employer Contributions :',32,' ')||lpad(l_prev_excs_er_cntr,25,' ')|| lpad((l_prev_excs_er_cntr+l_diff_excs_er_contr),25,' ')|| lpad(l_diff_excs_er_contr,30,' '));
1239: end if ;
1240:
1241: else
1242: hr_utility.trace('Process already run for assignment_id :'||l_asg_id);
1243: end if ;
1244:
1245: hr_utility.trace('Completed processing for Assignment :'||rec_assact(rec_count).assignment_id||' Month Year :'||rec_assact(rec_count).month_yr);
1246: exception

Line 1245: hr_utility.trace('Completed processing for Assignment :'||rec_assact(rec_count).assignment_id||' Month Year :'||rec_assact(rec_count).month_yr);

1241: else
1242: hr_utility.trace('Process already run for assignment_id :'||l_asg_id);
1243: end if ;
1244:
1245: hr_utility.trace('Completed processing for Assignment :'||rec_assact(rec_count).assignment_id||' Month Year :'||rec_assact(rec_count).month_yr);
1246: exception
1247: when excp_uif_manipulated then
1248: unprocessed_asgn_count := unprocessed_asgn_count + 1 ;
1249: unprocessed_assignments(unprocessed_asgn_count).assignment_id := rec_assact(rec_count).assignment_id;

Line 1278: hr_utility.trace('Exiting '||l_proc_name);

1274: -- Clear PL/SQL table
1275: --rec_assact.DELETE ;
1276: commit ;
1277:
1278: hr_utility.trace('Exiting '||l_proc_name);
1279: hr_utility.trace('Trace for UIF Refund March 2008 ends');
1280: end create_uif_backdated_entries;
1281:
1282: end PAY_ZA_UIF_REFUND_MARCH_2008;

Line 1279: hr_utility.trace('Trace for UIF Refund March 2008 ends');

1275: --rec_assact.DELETE ;
1276: commit ;
1277:
1278: hr_utility.trace('Exiting '||l_proc_name);
1279: hr_utility.trace('Trace for UIF Refund March 2008 ends');
1280: end create_uif_backdated_entries;
1281:
1282: end PAY_ZA_UIF_REFUND_MARCH_2008;