DBA Data[Home] [Help]

APPS.PAY_SG_DEDUCTIONS dependencies on HR_UTILITY

Line 178: hr_utility.set_location('Entering : '||l_proc, 5);

174: l_eot := to_date('4712/12/31 00:00:00', 'YYYY/MM/DD HH24:MI:SS');
175: l_proc := 'pay_sg_deductions.fwl_amount';
176:
177:
178: hr_utility.set_location('Entering : '||l_proc, 5);
179:
180: l_counter := 1;
181:
182: open c_get_dates( p_assignment_id, p_start_date, p_end_date) ;

Line 185: hr_utility.set_location('Leaving - No fwl in month : '||l_proc, 10);

181:
182: open c_get_dates( p_assignment_id, p_start_date, p_end_date) ;
183: fetch c_get_dates into l_permit(l_counter);
184: if c_get_dates%notfound then
185: hr_utility.set_location('Leaving - No fwl in month : '||l_proc, 10);
186: return 0;
187: end if;
188:
189: l_counter := l_counter + 1;

Line 231: hr_utility.set_location('Error - WP Category is null : '||l_proc, 88);

227: FOR i in 1..l_permit.last LOOP
228:
229: if l_permit(i).permit_category is null then
230:
231: hr_utility.set_location('Error - WP Category is null : '||l_proc, 88);
232: return (-88);
233:
234: else
235:

Line 239: hr_utility.set_location('Invalid Date Ranges Within Month: '||l_proc, 77);

235:
236: if (l_permit(i).date_start > l_permit(i).date_end)
237: OR (l_permit(i).date_start > l_permit(i).date_cancel) THEN
238:
239: hr_utility.set_location('Invalid Date Ranges Within Month: '||l_proc, 77);
240: return (-77);
241:
242:
243: elsif (l_permit(i).date_start > p_end_date )

Line 281: hr_utility.set_location('Invalid Date Ranges Within Month : '||l_proc, 77);

277:
278:
279: if l_tot_days > l_max_days then
280:
281: hr_utility.set_location('Invalid Date Ranges Within Month : '||l_proc, 77);
282: return (-77);
283:
284: end if;
285:

Line 320: hr_utility.set_location('Leaving:'||l_proc, 20);

316: end if;
317:
318: END LOOP;
319:
320: hr_utility.set_location('Leaving:'||l_proc, 20);
321: return l_amt;
322:
323: EXCEPTION
324: WHEN others THEN

Line 325: hr_utility.set_location('Unhandled Exception in function call fwl_amount : '||l_proc, 99);

321: return l_amt;
322:
323: EXCEPTION
324: WHEN others THEN
325: hr_utility.set_location('Unhandled Exception in function call fwl_amount : '||l_proc, 99);
326: RETURN -99;
327:
328: end fwl_amount;
329:

Line 386: hr_utility.set_location('Entering : '||l_proc, 5);

382: l_sot := to_date('0001/01/01 00:00:00', 'YYYY/MM/DD HH24:MI:SS');
383: l_eot := to_date('4712/12/31 00:00:00', 'YYYY/MM/DD HH24:MI:SS');
384: l_proc := 'pay_sg_deductions.spl_amount';
385:
386: hr_utility.set_location('Entering : '||l_proc, 5);
387:
388: l_counter := 1;
389:
390: open c_get_dates( p_assignment_id, p_start_date, p_end_date) ;

Line 393: hr_utility.set_location('Leaving - No fwl in month : '||l_proc, 10);

389:
390: open c_get_dates( p_assignment_id, p_start_date, p_end_date) ;
391: fetch c_get_dates into l_permit(l_counter);
392: if c_get_dates%notfound then
393: hr_utility.set_location('Leaving - No fwl in month : '||l_proc, 10);
394: return 0;
395: end if;
396:
397: l_counter := l_counter + 1;

Line 431: hr_utility.set_location('Invalid Date Ranges Within Month: '||l_proc, 77);

427: FOR i in 1..l_permit.last LOOP
428: if (l_permit(i).date_start > l_permit(i).date_end)
429: OR (l_permit(i).date_start > l_permit(i).date_cancel) THEN
430:
431: hr_utility.set_location('Invalid Date Ranges Within Month: '||l_proc, 77);
432: return (-77);
433:
434:
435: elsif (l_permit(i).date_start > p_end_date )

Line 452: hr_utility.set_location('Invalid Date Ranges Within Month : '||l_proc, 77);

448:
449: l_tot_days := l_tot_days + l_days;
450:
451: if l_tot_days > l_max_days then
452: hr_utility.set_location('Invalid Date Ranges Within Month : '||l_proc, 77);
453: return (-77);
454: end if;
455:
456: if l_months >= 1 then

Line 466: hr_utility.set_location('Leaving:'||l_proc, 20);

462: end if;
463:
464: END LOOP;
465:
466: hr_utility.set_location('Leaving:'||l_proc, 20);
467: return l_amt;
468:
469: EXCEPTION
470: WHEN others THEN

Line 471: hr_utility.set_location('Unhandled Exception in function call spl_amount : '||l_proc, 99);

467: return l_amt;
468:
469: EXCEPTION
470: WHEN others THEN
471: hr_utility.set_location('Unhandled Exception in function call spl_amount : '||l_proc, 99);
472: RETURN -99;
473:
474: end spl_amount;
475:

Line 533: hr_utility.set_location('Entering : '||l_proc, 5);

529: l_emp_end_bet_period := 'N';
530: l_proc := 'pay_sg_deductions.sg_get_prorator';
531:
532: /* Get the WAC effective at start of the pay period */
533: hr_utility.set_location('Entering : '||l_proc, 5);
534: hr_utility.trace('p_assignment_id : '||p_assignment_id);
535: hr_utility.trace('p_pay_proc_start_date : '||p_pay_proc_start_date );
536: hr_utility.trace('p_pay_proc_end_date : '||p_pay_proc_end_date );
537: hr_utility.trace('p_date_earned : '||p_date_earned );

Line 534: hr_utility.trace('p_assignment_id : '||p_assignment_id);

530: l_proc := 'pay_sg_deductions.sg_get_prorator';
531:
532: /* Get the WAC effective at start of the pay period */
533: hr_utility.set_location('Entering : '||l_proc, 5);
534: hr_utility.trace('p_assignment_id : '||p_assignment_id);
535: hr_utility.trace('p_pay_proc_start_date : '||p_pay_proc_start_date );
536: hr_utility.trace('p_pay_proc_end_date : '||p_pay_proc_end_date );
537: hr_utility.trace('p_date_earned : '||p_date_earned );
538: hr_utility.trace('p_wac : '||p_wac);

Line 535: hr_utility.trace('p_pay_proc_start_date : '||p_pay_proc_start_date );

531:
532: /* Get the WAC effective at start of the pay period */
533: hr_utility.set_location('Entering : '||l_proc, 5);
534: hr_utility.trace('p_assignment_id : '||p_assignment_id);
535: hr_utility.trace('p_pay_proc_start_date : '||p_pay_proc_start_date );
536: hr_utility.trace('p_pay_proc_end_date : '||p_pay_proc_end_date );
537: hr_utility.trace('p_date_earned : '||p_date_earned );
538: hr_utility.trace('p_wac : '||p_wac);
539:

Line 536: hr_utility.trace('p_pay_proc_end_date : '||p_pay_proc_end_date );

532: /* Get the WAC effective at start of the pay period */
533: hr_utility.set_location('Entering : '||l_proc, 5);
534: hr_utility.trace('p_assignment_id : '||p_assignment_id);
535: hr_utility.trace('p_pay_proc_start_date : '||p_pay_proc_start_date );
536: hr_utility.trace('p_pay_proc_end_date : '||p_pay_proc_end_date );
537: hr_utility.trace('p_date_earned : '||p_date_earned );
538: hr_utility.trace('p_wac : '||p_wac);
539:
540: p_cpf_calc_type := p_wac ; /* assign the default value of WAC for the person as WAC exist at period end date */

Line 537: hr_utility.trace('p_date_earned : '||p_date_earned );

533: hr_utility.set_location('Entering : '||l_proc, 5);
534: hr_utility.trace('p_assignment_id : '||p_assignment_id);
535: hr_utility.trace('p_pay_proc_start_date : '||p_pay_proc_start_date );
536: hr_utility.trace('p_pay_proc_end_date : '||p_pay_proc_end_date );
537: hr_utility.trace('p_date_earned : '||p_date_earned );
538: hr_utility.trace('p_wac : '||p_wac);
539:
540: p_cpf_calc_type := p_wac ; /* assign the default value of WAC for the person as WAC exist at period end date */
541:

Line 538: hr_utility.trace('p_wac : '||p_wac);

534: hr_utility.trace('p_assignment_id : '||p_assignment_id);
535: hr_utility.trace('p_pay_proc_start_date : '||p_pay_proc_start_date );
536: hr_utility.trace('p_pay_proc_end_date : '||p_pay_proc_end_date );
537: hr_utility.trace('p_date_earned : '||p_date_earned );
538: hr_utility.trace('p_wac : '||p_wac);
539:
540: p_cpf_calc_type := p_wac ; /* assign the default value of WAC for the person as WAC exist at period end date */
541:
542: open c_get_per_start_end_dates(p_assignment_id , p_pay_proc_start_date, p_pay_proc_end_date);

Line 547: hr_utility.set_location('Error : Assignment does not exist in the pay process period'||l_proc,5);

543: fetch c_get_per_start_end_dates into l_assign_start_date,l_assign_end_date;
544:
545: if c_get_per_start_end_dates%NOTFOUND then
546: close c_get_per_start_end_dates;
547: hr_utility.set_location('Error : Assignment does not exist in the pay process period'||l_proc,5);
548: else
549: if (l_assign_start_date > p_pay_proc_start_date ) then
550: l_proc_start_date := l_assign_start_date;
551: else

Line 565: hr_utility.set_location('Error : Assignment doesnot exist at the pay proc start date'||l_proc,10);

561: open c_get_wac( p_assignment_id , l_proc_start_date );
562: fetch c_get_wac into l_wac, l_effective_date;
563: if c_get_wac%NOTFOUND then
564: close c_get_wac;
565: hr_utility.set_location('Error : Assignment doesnot exist at the pay proc start date'||l_proc,10);
566: return 1; /* Bug#2858065 */
567: end if;
568: close c_get_wac;
569: /* store the wac at the start of the period */

Line 580: hr_utility.trace('start_wac : '||start_wac);

576: if (l_effective_date < p_pay_proc_start_date) then
577: start_date := p_pay_proc_start_date;
578: end if;
579:
580: hr_utility.trace('start_wac : '||start_wac);
581: hr_utility.trace('start_date : '||start_date);
582:
583: /* Get the WAC and at the period end date*/
584:

Line 581: hr_utility.trace('start_date : '||start_date);

577: start_date := p_pay_proc_start_date;
578: end if;
579:
580: hr_utility.trace('start_wac : '||start_wac);
581: hr_utility.trace('start_date : '||start_date);
582:
583: /* Get the WAC and at the period end date*/
584:
585: open c_get_wac( p_assignment_id,l_proc_end_date);

Line 589: hr_utility.set_location('Error : Assignment doesnot exist at the pay proc end date (ie terminated)'||l_proc,20);

585: open c_get_wac( p_assignment_id,l_proc_end_date);
586: fetch c_get_wac into l_wac, l_effective_date;
587: if c_get_wac%NOTFOUND then
588: close c_get_wac;
589: hr_utility.set_location('Error : Assignment doesnot exist at the pay proc end date (ie terminated)'||l_proc,20);
590: return 1; /* Bug#2873083 */
591: end if;
592: close c_get_wac;
593:

Line 606: hr_utility.trace('prorate_wac : '||prorate_wac);

602: if (l_effective_date < p_pay_proc_start_date ) then
603: prorate_date := p_pay_proc_start_date;
604: end if;
605:
606: hr_utility.trace('prorate_wac : '||prorate_wac);
607: hr_utility.trace('prorate_date : '||prorate_date);
608:
609: if (p_date_earned <> start_date ) then
610: l_total_days := fffunc.days_between(l_proc_end_date , l_proc_start_date)+1;

Line 607: hr_utility.trace('prorate_date : '||prorate_date);

603: prorate_date := p_pay_proc_start_date;
604: end if;
605:
606: hr_utility.trace('prorate_wac : '||prorate_wac);
607: hr_utility.trace('prorate_date : '||prorate_date);
608:
609: if (p_date_earned <> start_date ) then
610: l_total_days := fffunc.days_between(l_proc_end_date , l_proc_start_date)+1;
611: -------------------------------------------------------------------------------------------------

Line 616: hr_utility.trace('l_total_days : '||l_total_days );

612: --Bug# 4149190
613: --p_pay_proc_start_date, p_pay_proc_end_date are replaced by l_proc_start_date,
614: --l_proc_end_date respectively.
615: -------------------------------------------------------------------------------------------------
616: hr_utility.trace('l_total_days : '||l_total_days );
617: end if;
618:
619: /* Proration Calculation Block */
620: /* If the employee start date or end date is in between the pay period then

Line 649: hr_utility.trace('p_cpf_calc_type :'||p_cpf_calc_type);

645: not eligible for CPF*/
646: l_days := fffunc.days_between(prorate_date,start_date);
647: p_cpf_calc_type := start_wac;
648: l_prorator := l_days / l_total_days;
649: hr_utility.trace('p_cpf_calc_type :'||p_cpf_calc_type);
650: hr_utility.trace('l_days : '||l_days );
651:
652: elsif ((start_wac = 'WP' or start_wac = 'EP' or start_wac = 'SP') and (prorate_wac = 'PR' or prorate_wac = 'SG')) then
653: /* Need to calculate the proration for the second period and first period does not have

Line 650: hr_utility.trace('l_days : '||l_days );

646: l_days := fffunc.days_between(prorate_date,start_date);
647: p_cpf_calc_type := start_wac;
648: l_prorator := l_days / l_total_days;
649: hr_utility.trace('p_cpf_calc_type :'||p_cpf_calc_type);
650: hr_utility.trace('l_days : '||l_days );
651:
652: elsif ((start_wac = 'WP' or start_wac = 'EP' or start_wac = 'SP') and (prorate_wac = 'PR' or prorate_wac = 'SG')) then
653: /* Need to calculate the proration for the second period and first period does not have
654: eligible for the CPF Proration */

Line 657: hr_utility.trace('l_days : '||l_days );

653: /* Need to calculate the proration for the second period and first period does not have
654: eligible for the CPF Proration */
655: l_days := fffunc.days_between(l_proc_end_date,prorate_date)+1;
656: /* Added +1 to include prorate date also */
657: hr_utility.trace('l_days : '||l_days );
658: p_cpf_calc_type := prorate_wac;
659: l_prorator := l_days / l_total_days;
660:
661: elsif ((start_wac = 'SG' or start_wac = 'PR') and (prorate_wac = 'SG' or prorate_wac = 'PR')) then

Line 691: hr_utility.trace('p_cpf_calc_type :'||p_cpf_calc_type);

687:
688: end if;
689: end if;
690: /* End of Proration Calculation */
691: hr_utility.trace('p_cpf_calc_type :'||p_cpf_calc_type);
692: hr_utility.trace('l_prorator : '||l_prorator);
693: hr_utility.set_location('Leaving : '||l_proc, 5);
694:
695: return l_prorator;

Line 692: hr_utility.trace('l_prorator : '||l_prorator);

688: end if;
689: end if;
690: /* End of Proration Calculation */
691: hr_utility.trace('p_cpf_calc_type :'||p_cpf_calc_type);
692: hr_utility.trace('l_prorator : '||l_prorator);
693: hr_utility.set_location('Leaving : '||l_proc, 5);
694:
695: return l_prorator;
696: end sg_get_prorator;

Line 693: hr_utility.set_location('Leaving : '||l_proc, 5);

689: end if;
690: /* End of Proration Calculation */
691: hr_utility.trace('p_cpf_calc_type :'||p_cpf_calc_type);
692: hr_utility.trace('l_prorator : '||l_prorator);
693: hr_utility.set_location('Leaving : '||l_proc, 5);
694:
695: return l_prorator;
696: end sg_get_prorator;
697:

Line 876: hr_utility.set_location('Entering Earnings Type : ', 5);

872: l_balance_name pay_balance_types.balance_name%TYPE;
873:
874: begin
875: l_earnings_type := ' ';
876: hr_utility.set_location('Entering Earnings Type : ', 5);
877: hr_utility.set_location('Element Type Id : ' || p_element_type_id, 10);
878:
879: l_balance_name := 'CPF Ordinary Earnings Eligible Comp';
880: open c_earnings_type(p_element_type_id, l_balance_name);

Line 877: hr_utility.set_location('Element Type Id : ' || p_element_type_id, 10);

873:
874: begin
875: l_earnings_type := ' ';
876: hr_utility.set_location('Entering Earnings Type : ', 5);
877: hr_utility.set_location('Element Type Id : ' || p_element_type_id, 10);
878:
879: l_balance_name := 'CPF Ordinary Earnings Eligible Comp';
880: open c_earnings_type(p_element_type_id, l_balance_name);
881: fetch c_earnings_type into l_earnings_type;

Line 891: hr_utility.set_location('Earnings Type : ' || l_earnings_type, 15);

887: fetch c_earnings_type into l_earnings_type;
888: close c_earnings_type;
889: end if;
890:
891: hr_utility.set_location('Earnings Type : ' || l_earnings_type, 15);
892:
893: return l_earnings_type;
894:
895: EXCEPTION

Line 898: hr_utility.set_location('Exception Earnings Type : ', 20);

894:
895: EXCEPTION
896: when others then
897: l_earnings_type := ' ';
898: hr_utility.set_location('Exception Earnings Type : ', 20);
899:
900: end earnings_type;
901: ---------------------------------------------------------------------------
902: -- Function returns Previous Year Ordinary Earnings total with

Line 1339: hr_utility.set_location('Starting init',5);

1335: l_effective_date := to_date('1-10-2003','dd-mm-yyyy');
1336: l_start_date := to_date('1-10-2003','dd-mm-yyyy');
1337:
1338: /* This function call returns -1 if the formula was not found */
1339: hr_utility.set_location('Starting init',5);
1340: hr_utility.trace('Formula_id:'||l_formula_id);
1341:
1342: open c_formula_id(p_formula_name, p_effective_date);
1343: fetch c_formula_id into l_formula_id, l_start_date;

Line 1340: hr_utility.trace('Formula_id:'||l_formula_id);

1336: l_start_date := to_date('1-10-2003','dd-mm-yyyy');
1337:
1338: /* This function call returns -1 if the formula was not found */
1339: hr_utility.set_location('Starting init',5);
1340: hr_utility.trace('Formula_id:'||l_formula_id);
1341:
1342: open c_formula_id(p_formula_name, p_effective_date);
1343: fetch c_formula_id into l_formula_id, l_start_date;
1344: if c_formula_id%NOTFOUND then

Line 1348: hr_utility.trace('Formula_id:'||l_formula_id);

1344: if c_formula_id%NOTFOUND then
1345: close c_formula_id;
1346: else
1347:
1348: hr_utility.trace('Formula_id:'||l_formula_id);
1349: ff_exec.init_formula (l_formula_id,
1350: l_start_date,
1351: g_inputs,
1352: g_outputs);

Line 1355: hr_utility.set_location('Leaving init',10);

1351: g_inputs,
1352: g_outputs);
1353: end if;
1354: --
1355: hr_utility.set_location('Leaving init',10);
1356:
1357: End init_formula;
1358:
1359: Function calc_cpf_add_YTD (p_date_earned in date

Line 1374: hr_utility.set_location('Entering get_bal',7);

1370: l_cpf_add_YTD number;
1371:
1372: Begin
1373: --
1374: hr_utility.set_location('Entering get_bal',7);
1375: --
1376: init_formula('SG_STAT',p_date_earned);
1377: --
1378: -- Set up contexts for the formula

Line 1383: hr_utility.trace('setting date earned '||p_date_earned);

1379: for i in g_inputs.first..g_inputs.last loop
1380: --
1381:
1382: if g_inputs(i).name = 'DATE_EARNED' then
1383: hr_utility.trace('setting date earned '||p_date_earned);
1384: g_inputs(i).value := fnd_date.date_to_canonical(p_date_earned);
1385: elsif g_inputs(i).name = 'ASSIGNMENT_ID' then
1386: g_inputs(i).value := p_assignment_id;
1387: elsif g_inputs(i).name = 'SOURCE_TEXT' then

Line 1388: hr_utility.trace('setting source text '||p_process_type);

1384: g_inputs(i).value := fnd_date.date_to_canonical(p_date_earned);
1385: elsif g_inputs(i).name = 'ASSIGNMENT_ID' then
1386: g_inputs(i).value := p_assignment_id;
1387: elsif g_inputs(i).name = 'SOURCE_TEXT' then
1388: hr_utility.trace('setting source text '||p_process_type);
1389: g_inputs(i).value := p_process_type;
1390: elsif g_inputs(i).name = 'PROCESS_TYPE' then
1391: g_inputs(i).value := p_process_type;
1392: elsif g_inputs(i).name = 'TAX_UNIT_ID' then

Line 1405: hr_utility.set_location('ERROR value = '||g_inputs(i).name ,7);

1401: g_inputs(i).value := p_payroll_id;
1402: elsif g_inputs(i).name = 'BALANCE_DATE' then
1403: g_inputs(i).value := fnd_date.date_to_canonical(p_balance_date);
1404: else
1405: hr_utility.set_location('ERROR value = '||g_inputs(i).name ,7);
1406: end if;
1407: --
1408: hr_utility.trace('g_inputs(i).name : '||g_inputs(i).name);
1409: hr_utility.trace('g_inputs(i).value : '||g_inputs(i).value);

Line 1408: hr_utility.trace('g_inputs(i).name : '||g_inputs(i).name);

1404: else
1405: hr_utility.set_location('ERROR value = '||g_inputs(i).name ,7);
1406: end if;
1407: --
1408: hr_utility.trace('g_inputs(i).name : '||g_inputs(i).name);
1409: hr_utility.trace('g_inputs(i).value : '||g_inputs(i).value);
1410: end loop;
1411: --
1412: -- Run the formula

Line 1409: hr_utility.trace('g_inputs(i).value : '||g_inputs(i).value);

1405: hr_utility.set_location('ERROR value = '||g_inputs(i).name ,7);
1406: end if;
1407: --
1408: hr_utility.trace('g_inputs(i).name : '||g_inputs(i).name);
1409: hr_utility.trace('g_inputs(i).value : '||g_inputs(i).value);
1410: end loop;
1411: --
1412: -- Run the formula
1413: --

Line 1414: hr_utility.set_location('Prior to execute the formula',8);

1410: end loop;
1411: --
1412: -- Run the formula
1413: --
1414: hr_utility.set_location('Prior to execute the formula',8);
1415: ff_exec.run_formula (g_inputs ,
1416: g_outputs );
1417: --
1418: hr_utility.set_location('End run formula',9);

Line 1418: hr_utility.set_location('End run formula',9);

1414: hr_utility.set_location('Prior to execute the formula',8);
1415: ff_exec.run_formula (g_inputs ,
1416: g_outputs );
1417: --
1418: hr_utility.set_location('End run formula',9);
1419: --
1420: for l_out_cnt in g_outputs.first..g_outputs.last loop
1421: -- only store the output of L_CPF_ADD_CALC_YEAR , ignoe others
1422: if g_outputs(l_out_cnt).name = 'L_CPF_ADD_CALC_YEAR' then

Line 1424: hr_utility.trace('l_cpf_add_YTD:'|| g_outputs(l_out_cnt).value);

1420: for l_out_cnt in g_outputs.first..g_outputs.last loop
1421: -- only store the output of L_CPF_ADD_CALC_YEAR , ignoe others
1422: if g_outputs(l_out_cnt).name = 'L_CPF_ADD_CALC_YEAR' then
1423: l_cpf_add_YTD := g_outputs(l_out_cnt).value;
1424: hr_utility.trace('l_cpf_add_YTD:'|| g_outputs(l_out_cnt).value);
1425: end if;
1426: --
1427: hr_utility.trace('Outputs:'||g_outputs(l_out_cnt).name);
1428: hr_utility.trace('Outputs(values):'||g_outputs(l_out_cnt).value);

Line 1427: hr_utility.trace('Outputs:'||g_outputs(l_out_cnt).name);

1423: l_cpf_add_YTD := g_outputs(l_out_cnt).value;
1424: hr_utility.trace('l_cpf_add_YTD:'|| g_outputs(l_out_cnt).value);
1425: end if;
1426: --
1427: hr_utility.trace('Outputs:'||g_outputs(l_out_cnt).name);
1428: hr_utility.trace('Outputs(values):'||g_outputs(l_out_cnt).value);
1429: end loop;
1430: --
1431: return l_cpf_add_YTD;

Line 1428: hr_utility.trace('Outputs(values):'||g_outputs(l_out_cnt).value);

1424: hr_utility.trace('l_cpf_add_YTD:'|| g_outputs(l_out_cnt).value);
1425: end if;
1426: --
1427: hr_utility.trace('Outputs:'||g_outputs(l_out_cnt).name);
1428: hr_utility.trace('Outputs(values):'||g_outputs(l_out_cnt).value);
1429: end loop;
1430: --
1431: return l_cpf_add_YTD;
1432: --