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.BEN_DISTRIBUTE_RATES dependencies on HR_UTILITY

Line 112: 13-feb-02 vsethi 115.31 Enclosed all hr_utility debug calls inside if

108: 16-an-03 kmullapu 115.43 Bug 2745691. Added convert_pcr_rates_w
109: 23-Jan-03 ikasire 115.45 Bug 2149438 Added overloaded funcrtions for
110: period_to_annual and annual_to_period to handle the
111: rounding externally.
112: 13-feb-02 vsethi 115.31 Enclosed all hr_utility debug calls inside if
113: 17-Mar-03 kmullapu 115.47 Bug 2745691:modified convert_pcr_rates_w to set
114: p_use_balance_flag:='Y' only when parent rate is SAREC or SAAEAR
115: 26-Jun-03 lakrish 115.48 Bug 2992321, made ann_rt_val parameters
116: as IN OUT in convert_pcr_rates_w

Line 269: g_debug boolean := hr_utility.debug_enabled;

265: --
266: g_element_pay_freq_perd_cache g_element_pay_freq_periods_tbl;
267: g_element_pay_freq_perd_cached pls_integer := 0;
268: --
269: g_debug boolean := hr_utility.debug_enabled;
270: --
271: ---------------------------------------------------------------------------
272: -- GEVITY
273: -- This procedure returns the defined, communicated and annual amounts.

Line 301: g_debug := hr_utility.debug_enabled;

297: l_val number;
298: --
299: BEGIN
300: --
301: g_debug := hr_utility.debug_enabled;
302: --
303: if g_debug then
304: hr_utility.set_location('Entering '||l_package, 10);
305: hr_utility.set_location(' p_convert_from_val '||p_convert_from_val,10);

Line 304: hr_utility.set_location('Entering '||l_package, 10);

300: --
301: g_debug := hr_utility.debug_enabled;
302: --
303: if g_debug then
304: hr_utility.set_location('Entering '||l_package, 10);
305: hr_utility.set_location(' p_convert_from_val '||p_convert_from_val,10);
306: end if;
307: --
308: --

Line 305: hr_utility.set_location(' p_convert_from_val '||p_convert_from_val,10);

301: g_debug := hr_utility.debug_enabled;
302: --
303: if g_debug then
304: hr_utility.set_location('Entering '||l_package, 10);
305: hr_utility.set_location(' p_convert_from_val '||p_convert_from_val,10);
306: end if;
307: --
308: --
309: IF p_convert_from_val IS NOT NULL THEN

Line 328: hr_utility.set_location('Done with Formula',10);

324: p_param5 => 'BEN_ECR_IV_ENRT_RT_ID',
325: p_param5_value => to_char(p_enrt_rt_id)
326: );
327: --
328: hr_utility.set_location('Done with Formula',10);
329: --
330: -- Loop through the returned table and make sure that the returned
331: -- values have been found
332: --

Line 353: hr_utility.set_location('In the Loop wrong Name ',10);

349: else
350: --
351: -- Account for cases where formula returns an unknown
352: -- variable name
353: hr_utility.set_location('In the Loop wrong Name ',10);
354: --
355: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM');
356: fnd_message.set_token('PROC',l_package);
357: fnd_message.set_token('FORMULA',p_formula_id);

Line 365: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM ',10);

361: end if;
362: --
363: exception when others then
364: --
365: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM ',10);
366: --
367: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
368: fnd_message.set_token('PROC',l_package);
369: fnd_message.set_token('FORMULA',p_formula_id);

Line 378: hr_utility.set_location('p_convert_from_val IS NULL returning NULLS',10);

374: end loop ;
375: ELSE
376: --
377: if g_debug then
378: hr_utility.set_location('p_convert_from_val IS NULL returning NULLS',10);
379: end if;
380: --
381: l_val := NULL;
382: l_cmcd_val := NULL;

Line 391: hr_utility.set_location('Defined Amount '||p_val,110);

387: p_val := l_val;
388: p_cmcd_val := l_cmcd_val;
389: p_ann_val := l_ann_val;
390: if g_debug then
391: hr_utility.set_location('Defined Amount '||p_val,110);
392: hr_utility.set_location('Cmcd Amount '||p_cmcd_val,110);
393: hr_utility.set_location('Ann Amount '||p_ann_val,110);
394: hr_utility.set_location('Leaving '||l_package, 20);
395: end if;

Line 392: hr_utility.set_location('Cmcd Amount '||p_cmcd_val,110);

388: p_cmcd_val := l_cmcd_val;
389: p_ann_val := l_ann_val;
390: if g_debug then
391: hr_utility.set_location('Defined Amount '||p_val,110);
392: hr_utility.set_location('Cmcd Amount '||p_cmcd_val,110);
393: hr_utility.set_location('Ann Amount '||p_ann_val,110);
394: hr_utility.set_location('Leaving '||l_package, 20);
395: end if;
396: --

Line 393: hr_utility.set_location('Ann Amount '||p_ann_val,110);

389: p_ann_val := l_ann_val;
390: if g_debug then
391: hr_utility.set_location('Defined Amount '||p_val,110);
392: hr_utility.set_location('Cmcd Amount '||p_cmcd_val,110);
393: hr_utility.set_location('Ann Amount '||p_ann_val,110);
394: hr_utility.set_location('Leaving '||l_package, 20);
395: end if;
396: --
397: END periodize_with_rule ;

Line 394: hr_utility.set_location('Leaving '||l_package, 20);

390: if g_debug then
391: hr_utility.set_location('Defined Amount '||p_val,110);
392: hr_utility.set_location('Cmcd Amount '||p_cmcd_val,110);
393: hr_utility.set_location('Ann Amount '||p_ann_val,110);
394: hr_utility.set_location('Leaving '||l_package, 20);
395: end if;
396: --
397: END periodize_with_rule ;
398: ---------------------------------------------------------------------------

Line 517: g_debug := hr_utility.debug_enabled;

513: l_max_end_date DATE;
514:
515: begin
516: --
517: g_debug := hr_utility.debug_enabled;
518: --
519: if g_debug then
520: hr_utility.set_location('Entering '||l_package, 10);
521: end if;

Line 520: hr_utility.set_location('Entering '||l_package, 10);

516: --
517: g_debug := hr_utility.debug_enabled;
518: --
519: if g_debug then
520: hr_utility.set_location('Entering '||l_package, 10);
521: end if;
522: --
523: hr_api.mandatory_arg_error(p_api_name => l_package,
524: p_argument => 'p_acty_ref_perd_cd',

Line 533: hr_utility.set_location('p_acty_ref_perd_cd '||p_acty_ref_perd_cd,20);

529: p_argument_value => p_start_date);
530:
531: --
532: if g_debug then
533: hr_utility.set_location('p_acty_ref_perd_cd '||p_acty_ref_perd_cd,20);
534: hr_utility.set_location('p_start_date '||to_char(p_start_date),30);
535: hr_utility.set_location('p_end_date '||to_char(p_end_date),40);
536: end if;
537: --

Line 534: hr_utility.set_location('p_start_date '||to_char(p_start_date),30);

530:
531: --
532: if g_debug then
533: hr_utility.set_location('p_acty_ref_perd_cd '||p_acty_ref_perd_cd,20);
534: hr_utility.set_location('p_start_date '||to_char(p_start_date),30);
535: hr_utility.set_location('p_end_date '||to_char(p_end_date),40);
536: end if;
537: --
538: if p_end_date is null then

Line 535: hr_utility.set_location('p_end_date '||to_char(p_end_date),40);

531: --
532: if g_debug then
533: hr_utility.set_location('p_acty_ref_perd_cd '||p_acty_ref_perd_cd,20);
534: hr_utility.set_location('p_start_date '||to_char(p_start_date),30);
535: hr_utility.set_location('p_end_date '||to_char(p_end_date),40);
536: end if;
537: --
538: if p_end_date is null then
539: --

Line 571: hr_utility.set_location(l_package,50);

567: --
568: end if;
569: --
570: if g_debug then
571: hr_utility.set_location(l_package,50);
572: end if;
573: --
574: if p_acty_ref_perd_cd = 'PWK' then
575: --

Line 594: hr_utility.set_location('Inside PP',2007);

590: or p_acty_ref_perd_cd = 'PPF' then
591: --
592: -- Pay Period
593: --
594: hr_utility.set_location('Inside PP',2007);
595: if p_element_type_id is not null then
596: l_element_type_id:=p_element_type_id;
597: else
598: open c_get_element_type_id;

Line 620: hr_utility.set_location('Inside Calendar Month',2007);

616: fetch get_period_type into l_period_type;
617: close get_period_type;
618: --
619: if l_period_type in ('Calendar Month','Lunar Month') then
620: hr_utility.set_location('Inside Calendar Month',2007);
621: -- 3704632 : Added IF-CLAUSE here.
622: if (p_end_date is null) THEN
623: select MAX(end_date)
624: into l_max_end_date

Line 655: hr_utility.set_location('Frequency Rule Year',2007);

651: --
652: close pay_freq_rule_exists;
653: --
654: IF l_reset <>'MM' THEN -- Year
655: hr_utility.set_location('Frequency Rule Year',2007);
656: BEGIN
657: FOR l_parse_periods IN c_parse_periods1(p_payroll_id,
658: p_start_date,
659: nvl(p_end_date,l_end_date))

Line 681: hr_utility.set_location('Frequency Rule Month',2007);

677: ELSE -- Month
678:
679: --Bug 6913654, Added 'if..else' condition if p_start_date and p_end_date fall in the same month.Old code does not handle this.
680: if TRUNC(p_start_date,l_reset) = TRUNC(p_end_date,l_reset) then
681: hr_utility.set_location('Frequency Rule Month',2007);
682: BEGIN
683: if g_debug then
684: hr_utility.set_location('get_periods_between ',10);
685: end if;

Line 684: hr_utility.set_location('get_periods_between ',10);

680: if TRUNC(p_start_date,l_reset) = TRUNC(p_end_date,l_reset) then
681: hr_utility.set_location('Frequency Rule Month',2007);
682: BEGIN
683: if g_debug then
684: hr_utility.set_location('get_periods_between ',10);
685: end if;
686: FOR l_parse_periods IN c_parse_periods1(p_payroll_id,
687: p_start_date,
688: p_end_date)

Line 709: hr_utility.set_location('Frequency Rule Month',2007);

705: --dbms_output.put_line('10:start'||to_char(p_start_date)||' end '||to_char(ADD_MONTHS(TRUNC(p_start_date,l_reset),1)-1)||' periods '||to_char(l_periods));
706: END;
707: else
708: IF p_start_date <> TRUNC(p_start_date,l_reset) THEN
709: hr_utility.set_location('Frequency Rule Month',2007);
710: BEGIN
711: if g_debug then
712: hr_utility.set_location('get_periods_between ',10);
713: end if;

Line 712: hr_utility.set_location('get_periods_between ',10);

708: IF p_start_date <> TRUNC(p_start_date,l_reset) THEN
709: hr_utility.set_location('Frequency Rule Month',2007);
710: BEGIN
711: if g_debug then
712: hr_utility.set_location('get_periods_between ',10);
713: end if;
714: FOR l_parse_periods IN c_parse_periods1(p_payroll_id,
715: p_start_date,
716: ADD_MONTHS(TRUNC(p_start_date,l_reset),1) -1)

Line 741: hr_utility.set_location('Frequency Other1',2007);

737: ELSE
738: l_start_date := p_start_date;
739: END IF;
740: IF NVL(p_end_date, l_end_date) <> (ADD_MONTHS(TRUNC(NVL(p_end_date, l_end_date),l_reset),1) -1) THEN -- 3704632 : Added NVL() to p_end_date
741: hr_utility.set_location('Frequency Other1',2007);
742: BEGIN
743: if g_debug then
744: hr_utility.set_location('get_periods_between ',15);
745: end if;

Line 744: hr_utility.set_location('get_periods_between ',15);

740: IF NVL(p_end_date, l_end_date) <> (ADD_MONTHS(TRUNC(NVL(p_end_date, l_end_date),l_reset),1) -1) THEN -- 3704632 : Added NVL() to p_end_date
741: hr_utility.set_location('Frequency Other1',2007);
742: BEGIN
743: if g_debug then
744: hr_utility.set_location('get_periods_between ',15);
745: end if;
746: FOR l_parse_periods IN c_parse_periods1(p_payroll_id,
747: TRUNC(NVL(p_end_date, l_end_date),l_reset), -- 3704632 : Added NVL() to p_end_date
748: NVL(p_end_date, l_end_date)) -- 3704632 : Added NVL() to p_end_date

Line 774: hr_utility.set_location('get_periods_between ',20);

770: l_end_date := NVL(p_end_date, l_end_date); -- 3704632 : Added NVL() to p_end_date
771: END IF;
772: IF (l_start_date <= l_end_date ) THEN
773: if g_debug then
774: hr_utility.set_location('get_periods_between ',20);
775: end if;
776: OPEN parse_periods(p_payroll_id => p_payroll_id
777: ,p_rt_start =>l_start_date
778: ,p_eoy =>l_end_date

Line 786: hr_utility.set_location('Frequency Year others 2',2007);

782: FETCH parse_periods INTO l_tot_perd;
783: --
784: CLOSE parse_periods;
785: --
786: hr_utility.set_location('Frequency Year others 2',2007);
787: l_periods := l_periods + l_tot_perd;
788: -- dbms_output.put_line('20:start'||to_char(l_start_Date)||' end '||to_char(l_end_date)||' periods '||to_char(l_periods));
789: END IF; -- l_start_date <= l_end_date
790: end if;

Line 829: hr_utility.set_location('Frequency Year other3',2007);

825: l_tot_perd := 1 ;
826: --
827: end if;
828: --
829: hr_utility.set_location('Frequency Year other3',2007);
830: l_periods := l_tot_perd;
831: --
832: END IF;
833: END IF;

Line 836: hr_utility.set_location(' Before if l_periods = 0 ',233);

832: END IF;
833: END IF;
834: END IF;
835: if g_debug then
836: hr_utility.set_location(' Before if l_periods = 0 ',233);
837: end if;
838: --
839: if l_periods = 0 or l_periods is null then
840: l_periods := l_tot_perd;

Line 847: hr_utility.set_location('l_tot_perd = 0 and l_periods = 0 ' ,234);

843: if (l_tot_perd = 0 AND l_periods = 0 and not p_called_from_est) then
844: --
845: -- Raise error as payroll was not found.
846: if g_debug then
847: hr_utility.set_location('l_tot_perd = 0 and l_periods = 0 ' ,234);
848: end if;
849: --
850: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
851: fnd_message.set_token('PROC',l_package);

Line 906: hr_utility.set_location('Pay roll id'||p_payroll_id,111);

902: close c_element_rule_exists;
903: end if;
904: --
905: if g_debug then
906: hr_utility.set_location('Pay roll id'||p_payroll_id,111);
907: hr_utility.set_location('start date '||p_start_date,111);
908: hr_utility.set_location('end date '||l_end_date,111);
909: end if;
910: if l_element_rule_exists = 'Y' then

Line 907: hr_utility.set_location('start date '||p_start_date,111);

903: end if;
904: --
905: if g_debug then
906: hr_utility.set_location('Pay roll id'||p_payroll_id,111);
907: hr_utility.set_location('start date '||p_start_date,111);
908: hr_utility.set_location('end date '||l_end_date,111);
909: end if;
910: if l_element_rule_exists = 'Y' then
911: --

Line 908: hr_utility.set_location('end date '||l_end_date,111);

904: --
905: if g_debug then
906: hr_utility.set_location('Pay roll id'||p_payroll_id,111);
907: hr_utility.set_location('start date '||p_start_date,111);
908: hr_utility.set_location('end date '||l_end_date,111);
909: end if;
910: if l_element_rule_exists = 'Y' then
911: --
912: for l_parse_periods in c_parse_periods1(p_payroll_id,

Line 1031: hr_utility.set_location('Number of Periods: '||to_char(l_periods), 90);

1027: --
1028: end if;
1029:
1030: if g_debug then
1031: hr_utility.set_location('Number of Periods: '||to_char(l_periods), 90);
1032: hr_utility.set_location('Leaving '||l_package , 90);
1033: end if;
1034:
1035: return(l_periods);

Line 1032: hr_utility.set_location('Leaving '||l_package , 90);

1028: end if;
1029:
1030: if g_debug then
1031: hr_utility.set_location('Number of Periods: '||to_char(l_periods), 90);
1032: hr_utility.set_location('Leaving '||l_package , 90);
1033: end if;
1034:
1035: return(l_periods);
1036:

Line 1206: g_debug := hr_utility.debug_enabled;

1202: l_pay_annualization_factor number ;
1203:
1204: begin
1205: --
1206: g_debug := hr_utility.debug_enabled;
1207: --
1208: if g_debug then
1209: hr_utility.set_location('Entering '||l_package, 11);
1210: end if;

Line 1209: hr_utility.set_location('Entering '||l_package, 11);

1205: --
1206: g_debug := hr_utility.debug_enabled;
1207: --
1208: if g_debug then
1209: hr_utility.set_location('Entering '||l_package, 11);
1210: end if;
1211: --
1212: hr_api.mandatory_arg_error(p_api_name => l_package,
1213: p_argument => 'p_acty_ref_perd_cd',

Line 1222: hr_utility.set_location('p_acty_ref_perd_cd '||p_acty_ref_perd_cd,21);

1218: p_argument_value => p_start_date);
1219:
1220: --
1221: if g_debug then
1222: hr_utility.set_location('p_acty_ref_perd_cd '||p_acty_ref_perd_cd,21);
1223: hr_utility.set_location('p_start_date '||to_char(p_start_date),31);
1224: hr_utility.set_location('p_end_date '||to_char(p_end_date),41);
1225: end if;
1226: --

Line 1223: hr_utility.set_location('p_start_date '||to_char(p_start_date),31);

1219:
1220: --
1221: if g_debug then
1222: hr_utility.set_location('p_acty_ref_perd_cd '||p_acty_ref_perd_cd,21);
1223: hr_utility.set_location('p_start_date '||to_char(p_start_date),31);
1224: hr_utility.set_location('p_end_date '||to_char(p_end_date),41);
1225: end if;
1226: --
1227: if p_end_date is null then

Line 1224: hr_utility.set_location('p_end_date '||to_char(p_end_date),41);

1220: --
1221: if g_debug then
1222: hr_utility.set_location('p_acty_ref_perd_cd '||p_acty_ref_perd_cd,21);
1223: hr_utility.set_location('p_start_date '||to_char(p_start_date),31);
1224: hr_utility.set_location('p_end_date '||to_char(p_end_date),41);
1225: end if;
1226: --
1227: if p_end_date is null then
1228: --

Line 1260: hr_utility.set_location(l_package,51);

1256: --
1257: end if;
1258: --
1259: if g_debug then
1260: hr_utility.set_location(l_package,51);
1261: end if;
1262: --
1263: if p_acty_ref_perd_cd = 'PWK' then
1264: --

Line 1318: hr_utility.set_location('l_tot_perd '||l_tot_perd,10);

1314: CLOSE c_count_periods_chq;
1315: --
1316: -- Bug 14164921
1317: --
1318: hr_utility.set_location('l_tot_perd '||l_tot_perd,10);
1319: --
1320: if l_tot_perd = 0 then
1321: l_tot_perd := 1;
1322: end if;

Line 1377: hr_utility.set_location('get_periods_between ',10);

1373: --Bug 6913654, Added 'if..else' condition if p_start_date and p_end_date fall in the same month.Old code does not handle this.
1374: IF TRUNC(p_start_date,l_reset) = TRUNC(p_end_date,l_reset) THEN
1375: BEGIN
1376: if g_debug then
1377: hr_utility.set_location('get_periods_between ',10);
1378: end if;
1379: FOR l_parse_periods IN c_parse_periods1(p_payroll_id,
1380: p_start_date,
1381: p_end_date)

Line 1403: hr_utility.set_location('get_periods_between ',10);

1399: else
1400: IF p_start_date <> TRUNC(p_start_date,l_reset) THEN
1401: BEGIN
1402: if g_debug then
1403: hr_utility.set_location('get_periods_between ',10);
1404: end if;
1405: FOR l_parse_periods IN c_parse_periods1(p_payroll_id,
1406: p_start_date,
1407: ADD_MONTHS(TRUNC(p_start_date,l_reset),1) -1)

Line 1433: hr_utility.set_location('get_periods_between ',15);

1429: END IF;
1430: IF p_end_date <> (ADD_MONTHS(TRUNC(p_end_date,l_reset),1) -1) THEN
1431: BEGIN
1432: if g_debug then
1433: hr_utility.set_location('get_periods_between ',15);
1434: end if;
1435: FOR l_parse_periods IN c_parse_periods1(p_payroll_id,
1436: TRUNC(p_end_date,l_reset),
1437: p_end_date)

Line 1462: hr_utility.set_location('get_periods_between ',20);

1458: l_end_date := p_end_date;
1459: END IF;
1460: IF (l_start_date <= l_end_date ) THEN
1461: if g_debug then
1462: hr_utility.set_location('get_periods_between ',20);
1463: end if;
1464: OPEN parse_periods(p_payroll_id => p_payroll_id
1465: ,p_rt_start =>l_start_date
1466: ,p_eoy =>l_end_date

Line 1510: hr_utility.set_location(' Before if l_periods = 0 ',233);

1506: --
1507: END IF;
1508: END IF;
1509: if g_debug then
1510: hr_utility.set_location(' Before if l_periods = 0 ',233);
1511: end if;
1512: --
1513: if l_periods = 0 or l_periods is null then
1514: l_periods := l_tot_perd;

Line 1521: hr_utility.set_location('l_tot_perd = 0 and l_periods = 0 ' ,234);

1517: if (l_tot_perd = 0 AND l_periods = 0) then
1518: --
1519: -- Raise error as payroll was not found.
1520: if g_debug then
1521: hr_utility.set_location('l_tot_perd = 0 and l_periods = 0 ' ,234);
1522: end if;
1523: --
1524: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
1525: fnd_message.set_token('PROC',l_package);

Line 1533: hr_utility.set_location('l_periods epp2 '||l_periods ,234);

1529: if p_acty_ref_perd_cd = 'EPP' then
1530: --
1531: if l_period_type = 'Bi-Week' then
1532: --
1533: hr_utility.set_location('l_periods epp2 '||l_periods ,234);
1534: if l_periods >= 26 then -- bug 9593336
1535: l_periods := 26;
1536: else
1537: --

Line 1656: hr_utility.set_location('Number of Periods: '||to_char(l_periods), 90);

1652: --
1653: end if;
1654:
1655: if g_debug then
1656: hr_utility.set_location('Number of Periods: '||to_char(l_periods), 90);
1657: hr_utility.set_location('Leaving '||l_package , 90);
1658: end if;
1659:
1660: return(l_periods);

Line 1657: hr_utility.set_location('Leaving '||l_package , 90);

1653: end if;
1654:
1655: if g_debug then
1656: hr_utility.set_location('Number of Periods: '||to_char(l_periods), 90);
1657: hr_utility.set_location('Leaving '||l_package , 90);
1658: end if;
1659:
1660: return(l_periods);
1661:

Line 1735: g_debug := hr_utility.debug_enabled;

1731: l_package varchar2(80) := g_package || '.estimate_balance';
1732: --
1733: begin
1734: --
1735: g_debug := hr_utility.debug_enabled;
1736: --
1737: if g_debug then
1738: hr_utility.set_location('Entering '||l_package, 10);
1739: end if;

Line 1738: hr_utility.set_location('Entering '||l_package, 10);

1734: --
1735: g_debug := hr_utility.debug_enabled;
1736: --
1737: if g_debug then
1738: hr_utility.set_location('Entering '||l_package, 10);
1739: end if;
1740: --
1741: for l_element in c_element loop
1742: --

Line 1769: hr_utility.set_location('strt dt '||to_char(l_start_date), 110);

1765: --
1766: end if;
1767: --
1768: if g_debug then
1769: hr_utility.set_location('strt dt '||to_char(l_start_date), 110);
1770: hr_utility.set_location('end dt '||to_char(l_end_date), 110);
1771: end if;
1772: l_periods := get_periods_between
1773: (p_start_date => l_start_date,

Line 1770: hr_utility.set_location('end dt '||to_char(l_end_date), 110);

1766: end if;
1767: --
1768: if g_debug then
1769: hr_utility.set_location('strt dt '||to_char(l_start_date), 110);
1770: hr_utility.set_location('end dt '||to_char(l_end_date), 110);
1771: end if;
1772: l_periods := get_periods_between
1773: (p_start_date => l_start_date,
1774: p_end_date => l_end_date,

Line 1800: hr_utility.set_location('Estimated Balance'||p_balance,11);

1796: --
1797: p_balance := nvl(l_estimate,0);
1798: --
1799: if g_debug then
1800: hr_utility.set_location('Estimated Balance'||p_balance,11);
1801: hr_utility.set_location('Leaving '||l_package, 10);
1802: end if;
1803: --
1804: end estimate_balance;

Line 1801: hr_utility.set_location('Leaving '||l_package, 10);

1797: p_balance := nvl(l_estimate,0);
1798: --
1799: if g_debug then
1800: hr_utility.set_location('Estimated Balance'||p_balance,11);
1801: hr_utility.set_location('Leaving '||l_package, 10);
1802: end if;
1803: --
1804: end estimate_balance;
1805: --

Line 1960: hr_utility.set_location('Entering '||l_package, 10);

1956: --
1957: begin
1958: --
1959: if g_debug then
1960: hr_utility.set_location('Entering '||l_package, 10);
1961: end if;
1962: --
1963: if p_enrt_rt_id is not null then
1964: --

Line 2000: hr_utility.set_location('Leaving '||l_package , 91);

1996: if l_ecr.det_pl_ytd_cntrs_cd is null or
1997: l_start_date is null then
1998: --
1999: if g_debug then
2000: hr_utility.set_location('Leaving '||l_package , 91);
2001: end if;
2002: return(0);
2003: --
2004: end if;

Line 2043: hr_utility.set_location('yr start date ' || l_start_date , 293);

2039: l_rt_end_dt := p_end_date ;
2040: end if ;
2041: ---
2042: if g_debug then
2043: hr_utility.set_location('yr start date ' || l_start_date , 293);
2044: hr_utility.set_location('l_rt_strt_dt '|| l_rt_strt_dt, 293);
2045: hr_utility.set_location('end date ' || l_rt_end_dt , 293);
2046: hr_utility.set_location('level facotr ' || l_ecr.ptd_comp_lvl_fctr_id , 293);
2047: end if;

Line 2044: hr_utility.set_location('l_rt_strt_dt '|| l_rt_strt_dt, 293);

2040: end if ;
2041: ---
2042: if g_debug then
2043: hr_utility.set_location('yr start date ' || l_start_date , 293);
2044: hr_utility.set_location('l_rt_strt_dt '|| l_rt_strt_dt, 293);
2045: hr_utility.set_location('end date ' || l_rt_end_dt , 293);
2046: hr_utility.set_location('level facotr ' || l_ecr.ptd_comp_lvl_fctr_id , 293);
2047: end if;
2048:

Line 2045: hr_utility.set_location('end date ' || l_rt_end_dt , 293);

2041: ---
2042: if g_debug then
2043: hr_utility.set_location('yr start date ' || l_start_date , 293);
2044: hr_utility.set_location('l_rt_strt_dt '|| l_rt_strt_dt, 293);
2045: hr_utility.set_location('end date ' || l_rt_end_dt , 293);
2046: hr_utility.set_location('level facotr ' || l_ecr.ptd_comp_lvl_fctr_id , 293);
2047: end if;
2048:
2049:

Line 2046: hr_utility.set_location('level facotr ' || l_ecr.ptd_comp_lvl_fctr_id , 293);

2042: if g_debug then
2043: hr_utility.set_location('yr start date ' || l_start_date , 293);
2044: hr_utility.set_location('l_rt_strt_dt '|| l_rt_strt_dt, 293);
2045: hr_utility.set_location('end date ' || l_rt_end_dt , 293);
2046: hr_utility.set_location('level facotr ' || l_ecr.ptd_comp_lvl_fctr_id , 293);
2047: end if;
2048:
2049:
2050: if l_rt_end_dt is null or

Line 2061: hr_utility.set_location('Leaving '||l_package , 92);

2057: -- calculated is 12/31/89. Here the old rate will belong in the
2058: -- previous year (1989) and should not be used for current year (1990)
2059: --
2060: if g_debug then
2061: hr_utility.set_location('Leaving '||l_package , 92);
2062: end if;
2063: return(0);
2064: --
2065: end if;

Line 2096: hr_utility.set_location('balance '||l_balance_amt , 92);

2092: -- (BTDADDEST)
2093: -- This date also makes sense only for defined balances (BALTYP).
2094: --
2095: if g_debug then
2096: hr_utility.set_location('balance '||l_balance_amt , 92);
2097: end if;
2098: if l_clf.comp_src_cd = 'BALTYP' and
2099: l_ecr.det_pl_ytd_cntrs_cd = 'BTDADDEST' and
2100: l_balance_amt > 0 then

Line 2134: hr_utility.set_location(' p_date_to '||least(l_rt_strt_dt-1, l_rt_end_dt),10);

2130: -- the rate start date - 1, there is a gap and the number
2131: -- of periods is incorrect.
2132: --
2133: if g_debug then
2134: hr_utility.set_location(' p_date_to '||least(l_rt_strt_dt-1, l_rt_end_dt),10);
2135: hr_utility.set_location(' l_start_date'||l_start_date,10);
2136: end if;
2137: --
2138: estimate_balance(p_person_id => l_epe.person_id,

Line 2135: hr_utility.set_location(' l_start_date'||l_start_date,10);

2131: -- of periods is incorrect.
2132: --
2133: if g_debug then
2134: hr_utility.set_location(' p_date_to '||least(l_rt_strt_dt-1, l_rt_end_dt),10);
2135: hr_utility.set_location(' l_start_date'||l_start_date,10);
2136: end if;
2137: --
2138: estimate_balance(p_person_id => l_epe.person_id,
2139: p_acty_base_rt_id => l_ecr.acty_base_rt_id,

Line 2151: hr_utility.set_location('Leaving '||l_package , 99);

2147: --
2148: end if;
2149: --
2150: if g_debug then
2151: hr_utility.set_location('Leaving '||l_package , 99);
2152: end if;
2153: --
2154: return(nvl(l_balance_amt,0) +l_estimated_bal);
2155: --

Line 2376: hr_utility.set_location('Entering '||l_package, 10);

2372: l_env_rec ben_env_object.g_global_env_rec_type;
2373: --
2374: begin
2375: --
2376: hr_utility.set_location('Entering '||l_package, 10);
2377: --
2378: g_debug := hr_utility.debug_enabled;
2379: --
2380: p_yr_start_date := p_start_date;

Line 2378: g_debug := hr_utility.debug_enabled;

2374: begin
2375: --
2376: hr_utility.set_location('Entering '||l_package, 10);
2377: --
2378: g_debug := hr_utility.debug_enabled;
2379: --
2380: p_yr_start_date := p_start_date;
2381: --
2382: ben_env_object.get(p_rec => l_env_rec);

Line 2462: -- hr_utility.set_location('BEN_91457_ELCTBL_CHC_NOT_FOUND ID:'||

2458: --
2459: if c_epe%notfound then
2460: --
2461: close c_epe;
2462: -- hr_utility.set_location('BEN_91457_ELCTBL_CHC_NOT_FOUND ID:'||
2463: -- to_char(p_elig_per_elctbl_chc_id), 50);
2464: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
2465: fnd_message.set_token('ID',to_char(p_elig_per_elctbl_chc_id));
2466: fnd_message.set_token('PROC',l_package);

Line 2494: -- hr_utility.set_location('BEN_91884_CHC_N_RT_NOT_FOUND:', 50);

2490: l_lf_evt_ocrd_dt := l_epe.lf_evt_ocrd_dt;
2491: --
2492: else
2493: --
2494: -- hr_utility.set_location('BEN_91884_CHC_N_RT_NOT_FOUND:', 50);
2495: fnd_message.set_name('BEN','BEN_91884_CHC_N_RT_NOT_FOUND');
2496: fnd_message.set_token('PROC',l_package);
2497: fnd_message.raise_error;
2498: --

Line 2550: -- hr_utility.set_location('BEN_91334_PLAN_YR_PERD', 50);

2546: --
2547: if c_yrp%notfound and l_benmngle_parm_rec.mode_cd <> 'D' then --ICM Changes
2548: --
2549: close c_yrp;
2550: -- hr_utility.set_location('BEN_91334_PLAN_YR_PERD', 50);
2551:
2552: -- GRADE/STEP Do not throw error for GSP programs
2553: -- Use the Start and End Dates of the year in which
2554: -- the Effective Date falls

Line 2579: hr_utility.set_location('strt dt is'||to_char(l_start_date),123);

2575: --
2576: end if;
2577: --BUG 3191928 fixes
2578: if l_yrp.end_date < l_start_date then
2579: hr_utility.set_location('strt dt is'||to_char(l_start_date),123);
2580: open c_pl_popl_yr_period_current;
2581: fetch c_pl_popl_yr_period_current into l_yrp;
2582: close c_pl_popl_yr_period_current;
2583: end if;

Line 2591: hr_utility.set_location('strt dt is'||to_char(p_start_date),123);

2587: --
2588: if p_complete_year_flag = 'Y' then
2589: --
2590: p_start_date := l_yrp.start_date;
2591: hr_utility.set_location('strt dt is'||to_char(p_start_date),123);
2592: --
2593: end if;
2594: --
2595: end if;

Line 2604: hr_utility.set_location(' p_complete_year_flag = N ',123);

2600: -- the start_date is less that the p_yr_start_date then we derive the start_date
2601: if p_complete_year_flag = 'N' and nvl(p_start_date,l_start_date) < p_yr_start_date then
2602: --
2603: if g_debug then
2604: hr_utility.set_location(' p_complete_year_flag = N ',123);
2605: end if;
2606: if p_acty_ref_perd_cd = 'PP' then
2607: --
2608: open c_parse_periods(p_payroll_id,p_yr_start_date,p_end_date );

Line 2620: hr_utility.set_location('IK RT STRT p_start_date'||p_start_date,111);

2616: end if;
2617: --
2618: end if;
2619: --
2620: hr_utility.set_location('IK RT STRT p_start_date'||p_start_date,111);
2621: if p_start_date is null then
2622: --
2623: if l_start_date is null then
2624: --

Line 2644: hr_utility.set_location('IK RT STRT p_start_date'||p_start_date,112);

2640: p_start_date := l_start_date;
2641: --
2642: end if;
2643: --Bug 2151055
2644: hr_utility.set_location('IK RT STRT p_start_date'||p_start_date,112);
2645: --
2646: if p_start_date > p_end_date and p_yr_start_date < p_start_date then
2647: --
2648: p_start_date := p_yr_start_date ;

Line 2659: -- hr_utility.set_location('Leaving '||l_package , 99);

2655: p_acty_ref_perd_cd := l_acty_ref_perd_cd;
2656: --
2657: end if;
2658: --
2659: -- hr_utility.set_location('Leaving '||l_package , 99);
2660: --
2661: exception
2662: --
2663: when others then

Line 2665: hr_utility.set_location('WHEN OTHERS: '||l_package, 100);

2661: exception
2662: --
2663: when others then
2664: if g_debug then
2665: hr_utility.set_location('WHEN OTHERS: '||l_package, 100);
2666: end if;
2667: p_start_date := l_start_date_nc_buffer; -- no copy changes
2668: p_end_date := l_end_date_nc_buffer; -- no copy changes
2669: p_yr_start_date := null; -- no copy changes

Line 2751: -- hr_utility.set_location('Entering '||l_package, 10);

2747: --End of code for Bug 6913654
2748:
2749: begin
2750: --
2751: -- hr_utility.set_location('Entering '||l_package, 10);
2752: --
2753: -- Check for a null amount. Assumption is that a calculation
2754: -- cannot be performed on a null amount.
2755: --

Line 2898: hr_utility.set_location('l_period_type '||l_period_type, 11111);

2894: open get_period_type(p_payroll_id,nvl(p_start_date, p_effective_date));
2895: fetch get_period_type into l_period_type;
2896: close get_period_type;
2897: --
2898: hr_utility.set_location('l_period_type '||l_period_type, 11111);
2899: hr_utility.set_location('p_payroll_id '||p_payroll_id, 11111);
2900: hr_utility.set_location('p_start_date '||p_start_date, 11111);
2901: --
2902: if ((p_acty_ref_perd_cd = 'BWK'

Line 2899: hr_utility.set_location('p_payroll_id '||p_payroll_id, 11111);

2895: fetch get_period_type into l_period_type;
2896: close get_period_type;
2897: --
2898: hr_utility.set_location('l_period_type '||l_period_type, 11111);
2899: hr_utility.set_location('p_payroll_id '||p_payroll_id, 11111);
2900: hr_utility.set_location('p_start_date '||p_start_date, 11111);
2901: --
2902: if ((p_acty_ref_perd_cd = 'BWK'
2903: and l_period_type <> 'Bi-Week')

Line 2900: hr_utility.set_location('p_start_date '||p_start_date, 11111);

2896: close get_period_type;
2897: --
2898: hr_utility.set_location('l_period_type '||l_period_type, 11111);
2899: hr_utility.set_location('p_payroll_id '||p_payroll_id, 11111);
2900: hr_utility.set_location('p_start_date '||p_start_date, 11111);
2901: --
2902: if ((p_acty_ref_perd_cd = 'BWK'
2903: and l_period_type <> 'Bi-Week')
2904: or (p_acty_ref_perd_cd = 'PWK'

Line 2929: --hr_utility.set_location('Inside period ESTONLY periods: '||l_no_of_periods, 9999);

2925: p_enrt_rt_id => p_enrt_rt_id,
2926: p_element_type_id => p_element_type_id,
2927: p_effective_date => p_effective_date
2928: ); */
2929: --hr_utility.set_location('Inside period ESTONLY periods: '||l_no_of_periods, 9999);
2930: --hr_utility.set_location('Inside period ESTONLY enrt_id: '||p_enrt_rt_id, 9999);
2931: ---Bug 7196470
2932: /* open c_get_cmmd_amt ;
2933: fetch c_get_cmmd_amt into l_period_amt;

Line 2930: --hr_utility.set_location('Inside period ESTONLY enrt_id: '||p_enrt_rt_id, 9999);

2926: p_element_type_id => p_element_type_id,
2927: p_effective_date => p_effective_date
2928: ); */
2929: --hr_utility.set_location('Inside period ESTONLY periods: '||l_no_of_periods, 9999);
2930: --hr_utility.set_location('Inside period ESTONLY enrt_id: '||p_enrt_rt_id, 9999);
2931: ---Bug 7196470
2932: /* open c_get_cmmd_amt ;
2933: fetch c_get_cmmd_amt into l_period_amt;
2934: close c_get_cmmd_amt;*/

Line 2935: --hr_utility.set_location('Inside period ESTONLY amt: '||l_period_amt, 9999);

2931: ---Bug 7196470
2932: /* open c_get_cmmd_amt ;
2933: fetch c_get_cmmd_amt into l_period_amt;
2934: close c_get_cmmd_amt;*/
2935: --hr_utility.set_location('Inside period ESTONLY amt: '||l_period_amt, 9999);
2936: -- else -- 12976212
2937: l_no_of_periods := get_periods_between
2938: (p_acty_ref_perd_cd => l_acty_ref_perd_cd,
2939: p_start_date => l_start_date,

Line 2952: hr_utility.set_location('perd amt '||to_char(l_period_amt), 11);

2948: --
2949: end if;
2950: --
2951: l_annual_amt := (l_period_amt * l_no_of_periods) + l_balance_amt;
2952: hr_utility.set_location('perd amt '||to_char(l_period_amt), 11);
2953: hr_utility.set_location('perd no '||to_char(l_no_of_periods), 11);
2954: hr_utility.set_location('bal amt '||to_char(l_balance_amt), 11);
2955: --
2956: l_annual_amt := round(l_annual_amt,2);

Line 2953: hr_utility.set_location('perd no '||to_char(l_no_of_periods), 11);

2949: end if;
2950: --
2951: l_annual_amt := (l_period_amt * l_no_of_periods) + l_balance_amt;
2952: hr_utility.set_location('perd amt '||to_char(l_period_amt), 11);
2953: hr_utility.set_location('perd no '||to_char(l_no_of_periods), 11);
2954: hr_utility.set_location('bal amt '||to_char(l_balance_amt), 11);
2955: --
2956: l_annual_amt := round(l_annual_amt,2);
2957: --

Line 2954: hr_utility.set_location('bal amt '||to_char(l_balance_amt), 11);

2950: --
2951: l_annual_amt := (l_period_amt * l_no_of_periods) + l_balance_amt;
2952: hr_utility.set_location('perd amt '||to_char(l_period_amt), 11);
2953: hr_utility.set_location('perd no '||to_char(l_no_of_periods), 11);
2954: hr_utility.set_location('bal amt '||to_char(l_balance_amt), 11);
2955: --
2956: l_annual_amt := round(l_annual_amt,2);
2957: --
2958: if g_period_to_annual_cached > 0 then

Line 2995: -- hr_utility.set_location('Leaving '||l_package , 90);

2991: g_period_to_annual_cache(l_hv).annual_amt := l_annual_amt;
2992: --
2993: end if;
2994: --
2995: -- hr_utility.set_location('Leaving '||l_package , 90);
2996: --
2997: return(l_annual_amt);
2998: --
2999: exception

Line 3078: -- hr_utility.set_location('Entering '||l_package, 10);

3074: l_call_balance boolean;
3075: l_period_type varchar2(30); -- 12976212
3076: begin
3077: --
3078: -- hr_utility.set_location('Entering '||l_package, 10);
3079: --
3080: -- Check for a null amount. Assumption is that a calculation
3081: -- cannot be performed on a null amount.
3082: --

Line 3226: hr_utility.set_location('l_period_type '||l_period_type, 9999);

3222: ,nvl(p_start_date, p_effective_date));
3223: fetch get_period_type into l_period_type;
3224: close get_period_type;
3225: --
3226: hr_utility.set_location('l_period_type '||l_period_type, 9999);
3227: hr_utility.set_location('p_payroll_id '||p_payroll_id, 9999);
3228: hr_utility.set_location('p_start_date '||p_start_date, 9999);
3229: --
3230: if ((p_acty_ref_perd_cd = 'BWK'

Line 3227: hr_utility.set_location('p_payroll_id '||p_payroll_id, 9999);

3223: fetch get_period_type into l_period_type;
3224: close get_period_type;
3225: --
3226: hr_utility.set_location('l_period_type '||l_period_type, 9999);
3227: hr_utility.set_location('p_payroll_id '||p_payroll_id, 9999);
3228: hr_utility.set_location('p_start_date '||p_start_date, 9999);
3229: --
3230: if ((p_acty_ref_perd_cd = 'BWK'
3231: and l_period_type <> 'Bi-Week')

Line 3228: hr_utility.set_location('p_start_date '||p_start_date, 9999);

3224: close get_period_type;
3225: --
3226: hr_utility.set_location('l_period_type '||l_period_type, 9999);
3227: hr_utility.set_location('p_payroll_id '||p_payroll_id, 9999);
3228: hr_utility.set_location('p_start_date '||p_start_date, 9999);
3229: --
3230: if ((p_acty_ref_perd_cd = 'BWK'
3231: and l_period_type <> 'Bi-Week')
3232: or (p_acty_ref_perd_cd = 'PWK'

Line 3258: --hr_utility.set_location('Inside period ETONLY periods: '||l_no_of_periods, 9999);

3254: p_enrt_rt_id => p_enrt_rt_id,
3255: p_element_type_id => p_element_type_id,
3256: p_effective_date => p_effective_date
3257: ); */
3258: --hr_utility.set_location('Inside period ETONLY periods: '||l_no_of_periods, 9999);
3259: --hr_utility.set_location('Inside period ETONLY enrt_id: '||p_enrt_rt_id, 9999);
3260: ---Bug 7196470
3261: /* open c_get_cmmd_amt ;
3262: fetch c_get_cmmd_amt into l_period_amt;

Line 3259: --hr_utility.set_location('Inside period ETONLY enrt_id: '||p_enrt_rt_id, 9999);

3255: p_element_type_id => p_element_type_id,
3256: p_effective_date => p_effective_date
3257: ); */
3258: --hr_utility.set_location('Inside period ETONLY periods: '||l_no_of_periods, 9999);
3259: --hr_utility.set_location('Inside period ETONLY enrt_id: '||p_enrt_rt_id, 9999);
3260: ---Bug 7196470
3261: /* open c_get_cmmd_amt ;
3262: fetch c_get_cmmd_amt into l_period_amt;
3263: close c_get_cmmd_amt;*/

Line 3264: --hr_utility.set_location('Inside period ETONLY amt: '||l_period_amt, 9999);

3260: ---Bug 7196470
3261: /* open c_get_cmmd_amt ;
3262: fetch c_get_cmmd_amt into l_period_amt;
3263: close c_get_cmmd_amt;*/
3264: --hr_utility.set_location('Inside period ETONLY amt: '||l_period_amt, 9999);
3265: -- else -- 12976212
3266: l_no_of_periods := get_periods_between
3267: (p_acty_ref_perd_cd => l_acty_ref_perd_cd,
3268: p_start_date => l_start_date,

Line 3281: hr_utility.set_location('perd amt '||to_char(l_period_amt), 11);

3277: --
3278: end if;
3279: --
3280: l_annual_amt := (l_period_amt * l_no_of_periods) + l_balance_amt;
3281: hr_utility.set_location('perd amt '||to_char(l_period_amt), 11);
3282: hr_utility.set_location('perd no '||to_char(l_no_of_periods), 11);
3283: hr_utility.set_location('bal amt '||to_char(l_balance_amt), 11);
3284: --
3285: if p_rounding_flag = 'Y' then

Line 3282: hr_utility.set_location('perd no '||to_char(l_no_of_periods), 11);

3278: end if;
3279: --
3280: l_annual_amt := (l_period_amt * l_no_of_periods) + l_balance_amt;
3281: hr_utility.set_location('perd amt '||to_char(l_period_amt), 11);
3282: hr_utility.set_location('perd no '||to_char(l_no_of_periods), 11);
3283: hr_utility.set_location('bal amt '||to_char(l_balance_amt), 11);
3284: --
3285: if p_rounding_flag = 'Y' then
3286: --

Line 3283: hr_utility.set_location('bal amt '||to_char(l_balance_amt), 11);

3279: --
3280: l_annual_amt := (l_period_amt * l_no_of_periods) + l_balance_amt;
3281: hr_utility.set_location('perd amt '||to_char(l_period_amt), 11);
3282: hr_utility.set_location('perd no '||to_char(l_no_of_periods), 11);
3283: hr_utility.set_location('bal amt '||to_char(l_balance_amt), 11);
3284: --
3285: if p_rounding_flag = 'Y' then
3286: --
3287: l_annual_amt := round(l_annual_amt,2);

Line 3328: -- hr_utility.set_location('Leaving '||l_package , 90);

3324: g_period_to_annual_cache(l_hv).annual_amt := l_annual_amt;
3325: --
3326: end if;
3327: --
3328: -- hr_utility.set_location('Leaving '||l_package , 90);
3329: --
3330: return(l_annual_amt);
3331: --
3332: exception

Line 3450: hr_utility.set_location('Entering '||l_package, 10);

3446: --
3447: begin
3448: --
3449: if g_debug then
3450: hr_utility.set_location('Entering '||l_package, 10);
3451: end if;
3452: hr_utility.set_location('Annual Amount in Annual to Period '||p_amount, 10);
3453: --
3454: -- Check for a null amount. Assumption is that a calculation

Line 3452: hr_utility.set_location('Annual Amount in Annual to Period '||p_amount, 10);

3448: --
3449: if g_debug then
3450: hr_utility.set_location('Entering '||l_package, 10);
3451: end if;
3452: hr_utility.set_location('Annual Amount in Annual to Period '||p_amount, 10);
3453: --
3454: -- Check for a null amount. Assumption is that a calculation
3455: -- cannot be performed on a null amount.
3456: --

Line 3626: hr_utility.set_location('l_check_date '||l_check_date,11);

3622: ,l_yr_start_date
3623: );
3624: fetch c_get_check_date into l_check_date;
3625: close c_get_check_date;
3626: hr_utility.set_location('l_check_date '||l_check_date,11);
3627: hr_utility.set_location('l_yr_start_date2 '||l_yr_start_date2,11);
3628: --
3629: if l_check_date < l_yr_start_date2 then
3630: open c_get_period_start_date(p_payroll_id

Line 3627: hr_utility.set_location('l_yr_start_date2 '||l_yr_start_date2,11);

3623: );
3624: fetch c_get_check_date into l_check_date;
3625: close c_get_check_date;
3626: hr_utility.set_location('l_check_date '||l_check_date,11);
3627: hr_utility.set_location('l_yr_start_date2 '||l_yr_start_date2,11);
3628: --
3629: if l_check_date < l_yr_start_date2 then
3630: open c_get_period_start_date(p_payroll_id
3631: ,l_yr_start_date2

Line 3640: hr_utility.set_location('Pay Date Offset'||l_first_pay_date_offset,11);

3636: end if;
3637: -- end 10058794
3638: end if;
3639: if g_debug then
3640: hr_utility.set_location('Pay Date Offset'||l_first_pay_date_offset,11);
3641: hr_utility.set_location('l_yr_start_date '||l_yr_start_date,333);
3642: end if;
3643: end if;
3644: --

Line 3641: hr_utility.set_location('l_yr_start_date '||l_yr_start_date,333);

3637: -- end 10058794
3638: end if;
3639: if g_debug then
3640: hr_utility.set_location('Pay Date Offset'||l_first_pay_date_offset,11);
3641: hr_utility.set_location('l_yr_start_date '||l_yr_start_date,333);
3642: end if;
3643: end if;
3644: --
3645:

Line 3698: hr_utility.set_location('Annual to Period Amount '||l_period_amt , 90);

3694: --
3695: end if;
3696: --
3697: l_period_amt := (l_annual_amt - l_balance_amt)/l_no_of_periods;
3698: hr_utility.set_location('Annual to Period Amount '||l_period_amt , 90);
3699: --
3700: l_period_amt := round(l_period_amt,2);
3701: --
3702: if g_annual_to_period_cached > 0 then

Line 3740: hr_utility.set_location('Leaving '||l_package , 90);

3736: g_annual_to_period_cache(l_hv).pp_in_yr_used_num := l_no_of_periods;
3737: --
3738: end if;
3739: --
3740: hr_utility.set_location('Leaving '||l_package , 90);
3741: --
3742: return(l_period_amt);
3743: --
3744: exception

Line 3859: hr_utility.set_location('Entering '||l_package, 10);

3855: --
3856: begin
3857: --
3858: if g_debug then
3859: hr_utility.set_location('Entering '||l_package, 10);
3860: end if;
3861: hr_utility.set_location('Annual Amount in Annual to Period '||p_amount, 10);
3862:
3863: --

Line 3861: hr_utility.set_location('Annual Amount in Annual to Period '||p_amount, 10);

3857: --
3858: if g_debug then
3859: hr_utility.set_location('Entering '||l_package, 10);
3860: end if;
3861: hr_utility.set_location('Annual Amount in Annual to Period '||p_amount, 10);
3862:
3863: --
3864: -- Check for a null amount. Assumption is that a calculation
3865: -- cannot be performed on a null amount.

Line 4035: hr_utility.set_location('l_check_date '||l_check_date,11);

4031: ,l_yr_start_date
4032: );
4033: fetch c_get_check_date into l_check_date;
4034: close c_get_check_date;
4035: hr_utility.set_location('l_check_date '||l_check_date,11);
4036: hr_utility.set_location('l_yr_start_date2 '||l_yr_start_date2,11);
4037: --
4038: if l_check_date < l_yr_start_date2 then
4039: open c_get_period_start_date(p_payroll_id

Line 4036: hr_utility.set_location('l_yr_start_date2 '||l_yr_start_date2,11);

4032: );
4033: fetch c_get_check_date into l_check_date;
4034: close c_get_check_date;
4035: hr_utility.set_location('l_check_date '||l_check_date,11);
4036: hr_utility.set_location('l_yr_start_date2 '||l_yr_start_date2,11);
4037: --
4038: if l_check_date < l_yr_start_date2 then
4039: open c_get_period_start_date(p_payroll_id
4040: ,l_yr_start_date2

Line 4050: hr_utility.set_location('Pay Date Offset'||l_pay_date_offset,11);

4046: -- end 10058794
4047: end if;
4048: --Bug 9309878
4049: if g_debug then
4050: hr_utility.set_location('Pay Date Offset'||l_pay_date_offset,11);
4051: hr_utility.set_location('l_yr_start_date '||l_yr_start_date,11);
4052: end if;
4053: end if;
4054: --

Line 4051: hr_utility.set_location('l_yr_start_date '||l_yr_start_date,11);

4047: end if;
4048: --Bug 9309878
4049: if g_debug then
4050: hr_utility.set_location('Pay Date Offset'||l_pay_date_offset,11);
4051: hr_utility.set_location('l_yr_start_date '||l_yr_start_date,11);
4052: end if;
4053: end if;
4054: --
4055:

Line 4153: hr_utility.set_location('Leaving '||l_package , 90);

4149: g_annual_to_period_cache(l_hv).pp_in_yr_used_num := l_no_of_periods;
4150: --
4151: end if;
4152: --
4153: hr_utility.set_location('Leaving '||l_package , 90);
4154: --
4155: return(l_period_amt);
4156: --
4157: exception

Line 4220: -- hr_utility.set_location('Entering '||l_package, 10);

4216: l_pay_date_offset number;
4217: --
4218: begin
4219: --
4220: -- hr_utility.set_location('Entering '||l_package, 10);
4221: --
4222: -- Check for a null amount. Assumption is that a calculation
4223: -- cannot be performed on a null amount.
4224: --

Line 4431: -- hr_utility.set_location('Leaving '||l_package , 90);

4427: g_annual_to_period_cache(l_hv).pp_in_yr_used_num := l_no_of_periods;
4428: --
4429: end if;
4430: --
4431: -- hr_utility.set_location('Leaving '||l_package , 90);
4432: --
4433: p_pp_in_yr_used_num := l_no_of_periods;
4434: return(l_period_amt);
4435: --

Line 4535: g_debug := hr_utility.debug_enabled;

4531: l_abr_balance abr_balance%rowtype;
4532: --
4533: begin
4534: --
4535: g_debug := hr_utility.debug_enabled;
4536: --
4537: if g_debug then
4538: hr_utility.set_location('Entering '||l_package , 10);
4539: end if;

Line 4538: hr_utility.set_location('Entering '||l_package , 10);

4534: --
4535: g_debug := hr_utility.debug_enabled;
4536: --
4537: if g_debug then
4538: hr_utility.set_location('Entering '||l_package , 10);
4539: end if;
4540:
4541: if p_elig_per_elctbl_chc_id is not null then
4542: -- get needed values

Line 4659: hr_utility.set_location('p_clm_balance '||to_char(p_clm_balance)||

4655: end if;
4656: end if;
4657:
4658: if g_debug then
4659: hr_utility.set_location('p_clm_balance '||to_char(p_clm_balance)||
4660: ' p_ptd_balance '||to_char(p_ptd_balance) , 97);
4661: end if;
4662:
4663: -- the minimum that the prtt can select is the higher of payments-to-date,

Line 4678: hr_utility.set_location('p_ann_mn_val '||to_char(p_ann_mn_val)||

4674: p_ann_mx_val := p_ann_mn_val;
4675: end if;
4676:
4677: if g_debug then
4678: hr_utility.set_location('p_ann_mn_val '||to_char(p_ann_mn_val)||
4679: ' p_ann_mx_val '||to_char(p_ann_mx_val) , 97);
4680: hr_utility.set_location('Leaving '||l_package , 99);
4681: end if;
4682: end compare_balances;

Line 4680: hr_utility.set_location('Leaving '||l_package , 99);

4676:
4677: if g_debug then
4678: hr_utility.set_location('p_ann_mn_val '||to_char(p_ann_mn_val)||
4679: ' p_ann_mx_val '||to_char(p_ann_mx_val) , 97);
4680: hr_utility.set_location('Leaving '||l_package , 99);
4681: end if;
4682: end compare_balances;
4683:
4684: ---------------------------------------------------------------------------

Line 4780: g_debug := hr_utility.debug_enabled;

4776: l_jurisdiction PAY_CA_EMP_PROV_TAX_INFO_F.JURISDICTION_CODE%type := null;
4777:
4778: begin
4779: --
4780: g_debug := hr_utility.debug_enabled;
4781: --
4782: if g_debug then
4783: hr_utility.set_location ('Entering '||l_package,10);
4784: end if;

Line 4783: hr_utility.set_location ('Entering '||l_package,10);

4779: --
4780: g_debug := hr_utility.debug_enabled;
4781: --
4782: if g_debug then
4783: hr_utility.set_location ('Entering '||l_package,10);
4784: end if;
4785:
4786: open get_cds;
4787: fetch get_cds into l_get_cds;

Line 4791: hr_utility.set_location('prort_mn_ann_elcn_val_cd '||

4787: fetch get_cds into l_get_cds;
4788: close get_cds;
4789:
4790: if g_debug then
4791: hr_utility.set_location('prort_mn_ann_elcn_val_cd '||
4792: l_get_cds.prort_mn_ann_elcn_val_cd,20);
4793: end if;
4794:
4795: if g_debug then

Line 4796: hr_utility.set_location('prort_mx_ann_elcn_val_cd '||

4792: l_get_cds.prort_mn_ann_elcn_val_cd,20);
4793: end if;
4794:
4795: if g_debug then
4796: hr_utility.set_location('prort_mx_ann_elcn_val_cd '||
4797: l_get_cds.prort_mx_ann_elcn_val_cd,20);
4798: end if;
4799:
4800: -- do not prorate null values.

Line 4991: hr_utility.set_location('p_ann_mn_val '||to_char(p_ann_mn_val)||

4987: p_jurisdiction_code => l_jurisdiction);
4988: p_ann_mx_val := l_outputs(l_outputs.first).value;
4989: end if;
4990: if g_debug then
4991: hr_utility.set_location('p_ann_mn_val '||to_char(p_ann_mn_val)||
4992: ' p_ann_mx_val '||to_char(p_ann_mx_val) , 97);
4993: end if;
4994:
4995: p_ann_mn_val := round(p_ann_mn_val,2);

Line 4999: hr_utility.set_location('p_ann_mn_val '||to_char(p_ann_mn_val)||

4995: p_ann_mn_val := round(p_ann_mn_val,2);
4996: p_ann_mx_val := round(p_ann_mx_val,2);
4997:
4998: if g_debug then
4999: hr_utility.set_location('p_ann_mn_val '||to_char(p_ann_mn_val)||
5000: ' p_ann_mx_val '||to_char(p_ann_mx_val) , 98);
5001: hr_utility.set_location('Leaving '||l_package , 99);
5002: end if;
5003: end prorate_min_max;

Line 5001: hr_utility.set_location('Leaving '||l_package , 99);

4997:
4998: if g_debug then
4999: hr_utility.set_location('p_ann_mn_val '||to_char(p_ann_mn_val)||
5000: ' p_ann_mx_val '||to_char(p_ann_mx_val) , 98);
5001: hr_utility.set_location('Leaving '||l_package , 99);
5002: end if;
5003: end prorate_min_max;
5004: --
5005: -- 0 - Always refresh

Line 5162: -- hr_utility.trace_on(null,'BENDISRT');

5158: l_payroll_id := p_payroll_id;
5159: end if;
5160: */
5161: --GEVITY
5162: -- hr_utility.trace_on(null,'BENDISRT');
5163: l_trace_param := null;
5164: l_trace_on := false;
5165: --
5166: l_trace_param := fnd_profile.value('BEN_SS_TRACE_VALUE');

Line 5175: hr_utility.trace_on(null,'BENDISRT');

5171: l_trace_on := false;
5172: end if;
5173: --
5174: if l_trace_on then
5175: hr_utility.trace_on(null,'BENDISRT');
5176: end if;
5177: hr_utility.set_location('l_trace_param : '|| l_trace_param, 5);
5178: hr_utility.set_location ('Entering '||l_proc,10);
5179:

Line 5177: hr_utility.set_location('l_trace_param : '|| l_trace_param, 5);

5173: --
5174: if l_trace_on then
5175: hr_utility.trace_on(null,'BENDISRT');
5176: end if;
5177: hr_utility.set_location('l_trace_param : '|| l_trace_param, 5);
5178: hr_utility.set_location ('Entering '||l_proc,10);
5179:
5180: open c_abr(p_enrt_rt_id,nvl(p_lf_evt_ocrd_dt,p_effective_date)) ;
5181: fetch c_abr into l_rate_periodization_rl,l_acty_base_rt_id;

Line 5178: hr_utility.set_location ('Entering '||l_proc,10);

5174: if l_trace_on then
5175: hr_utility.trace_on(null,'BENDISRT');
5176: end if;
5177: hr_utility.set_location('l_trace_param : '|| l_trace_param, 5);
5178: hr_utility.set_location ('Entering '||l_proc,10);
5179:
5180: open c_abr(p_enrt_rt_id,nvl(p_lf_evt_ocrd_dt,p_effective_date)) ;
5181: fetch c_abr into l_rate_periodization_rl,l_acty_base_rt_id;
5182: close c_abr;

Line 5301: hr_utility.set_location('sang l_ann_dummy '|| l_ann_dummy, 1);

5297: p_start_date =>p_start_date,
5298: p_end_date =>p_end_date,
5299: p_payroll_id =>l_payroll_id,
5300: p_element_type_id =>p_element_type_id);
5301: hr_utility.set_location('sang l_ann_dummy '|| l_ann_dummy, 1);
5302: --Added for bug 12595701
5303: -- convert the annual to defined rate
5304: p_val := annual_to_period
5305: (p_amount =>l_ann_dummy, --12595701

Line 5337: hr_utility.set_location('Rounding error adjustment in defined rate. value='|| p_val,15.1);

5333:
5334: if l_min_val is not null and p_val < l_min_val and
5335: (l_min_val - p_val) <= 0.01 then
5336: p_val := l_min_val;
5337: hr_utility.set_location('Rounding error adjustment in defined rate. value='|| p_val,15.1);
5338: elsif l_max_val is not null and p_val > l_max_val and
5339: (p_val - l_max_val) <= 0.01 then
5340: p_val := l_max_val;
5341: hr_utility.set_location('Rounding error adjustment in defined rate. value='|| p_val,15.2);

Line 5341: hr_utility.set_location('Rounding error adjustment in defined rate. value='|| p_val,15.2);

5337: hr_utility.set_location('Rounding error adjustment in defined rate. value='|| p_val,15.1);
5338: elsif l_max_val is not null and p_val > l_max_val and
5339: (p_val - l_max_val) <= 0.01 then
5340: p_val := l_max_val;
5341: hr_utility.set_location('Rounding error adjustment in defined rate. value='|| p_val,15.2);
5342: end if;
5343: end if;
5344: end if;
5345: --end 5460638

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

5403: else -- this is not supported
5404: raise not_supported;
5405: end if;
5406:
5407: hr_utility.set_location ('Leaving '||l_proc,20);
5408: if l_trace_on then
5409: hr_utility.trace_off;
5410: l_trace_param := null;
5411: l_trace_on := false;

Line 5409: hr_utility.trace_off;

5405: end if;
5406:
5407: hr_utility.set_location ('Leaving '||l_proc,20);
5408: if l_trace_on then
5409: hr_utility.trace_off;
5410: l_trace_param := null;
5411: l_trace_on := false;
5412: end if;
5413: --

Line 5418: hr_utility.trace_off;

5414: exception
5415: when not_supported then
5416: -- This should never happen
5417: if l_trace_on then
5418: hr_utility.trace_off;
5419: l_trace_param := null;
5420: l_trace_on := false;
5421: end if;
5422: raise;

Line 5428: hr_utility.trace_off;

5424: p_ann_rt_val := null; -- no copy changes
5425: p_cmcd_rt_val := null; -- no copy changes
5426: p_val := null; -- no copy changes
5427: if l_trace_on then
5428: hr_utility.trace_off;
5429: l_trace_param := null;
5430: l_trace_on := false;
5431: end if;
5432:

Line 5524: -- hr_utility.trace_on(null,'BENDISRT');

5520: l_trace_on boolean;
5521: l_proc varchar2(200) := 'ben_distribute_rates.convert_pcr_rates_w';
5522: --
5523: BEGIN
5524: -- hr_utility.trace_on(null,'BENDISRT');
5525: l_trace_param := null;
5526: l_trace_on := false;
5527: --
5528: l_trace_param := fnd_profile.value('BEN_SS_TRACE_VALUE');

Line 5537: hr_utility.trace_on(null,'BENDISRT');

5533: l_trace_on := false;
5534: end if;
5535: --
5536: if l_trace_on then
5537: hr_utility.trace_on(null,'BENDISRT');
5538: end if;
5539: --
5540: hr_utility.set_location('l_trace_param : '|| l_trace_param, 5);
5541: hr_utility.set_location ('Entering '||l_proc,10);

Line 5540: hr_utility.set_location('l_trace_param : '|| l_trace_param, 5);

5536: if l_trace_on then
5537: hr_utility.trace_on(null,'BENDISRT');
5538: end if;
5539: --
5540: hr_utility.set_location('l_trace_param : '|| l_trace_param, 5);
5541: hr_utility.set_location ('Entering '||l_proc,10);
5542: --
5543: OPEN c_cmplt_year;
5544: Fetch c_cmplt_year into l_complete_year_flag;

Line 5541: hr_utility.set_location ('Entering '||l_proc,10);

5537: hr_utility.trace_on(null,'BENDISRT');
5538: end if;
5539: --
5540: hr_utility.set_location('l_trace_param : '|| l_trace_param, 5);
5541: hr_utility.set_location ('Entering '||l_proc,10);
5542: --
5543: OPEN c_cmplt_year;
5544: Fetch c_cmplt_year into l_complete_year_flag;
5545: if c_cmplt_year%NOTFOUND

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

5673: CLOSE csr_is_child;
5674: END IF; -- i <> p_rate_index
5675: END LOOP;
5676: --
5677: hr_utility.set_location ('Leaving '||l_proc,20);
5678: if l_trace_on then
5679: hr_utility.trace_off;
5680: l_trace_param := null;
5681: l_trace_on := false;

Line 5679: hr_utility.trace_off;

5675: END LOOP;
5676: --
5677: hr_utility.set_location ('Leaving '||l_proc,20);
5678: if l_trace_on then
5679: hr_utility.trace_off;
5680: l_trace_param := null;
5681: l_trace_on := false;
5682: end if;
5683: --

Line 5699: hr_utility.trace_off;

5695: p_ann_rt_val4 := null; -- no copy changes
5696: p_cmcd_rt_val4 := null; -- no copy changes
5697: p_val4 := null;
5698: if l_trace_on then
5699: hr_utility.trace_off;
5700: l_trace_param := null;
5701: l_trace_on := false;
5702: end if;
5703: raise;