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 236: g_debug boolean := hr_utility.debug_enabled;

232: --
233: g_element_pay_freq_perd_cache g_element_pay_freq_periods_tbl;
234: g_element_pay_freq_perd_cached pls_integer := 0;
235: --
236: g_debug boolean := hr_utility.debug_enabled;
237: --
238: ---------------------------------------------------------------------------
239: -- GEVITY
240: -- This procedure returns the defined, communicated and annual amounts.

Line 268: g_debug := hr_utility.debug_enabled;

264: l_val number;
265: --
266: BEGIN
267: --
268: g_debug := hr_utility.debug_enabled;
269: --
270: if g_debug then
271: hr_utility.set_location('Entering '||l_package, 10);
272: hr_utility.set_location(' p_convert_from_val '||p_convert_from_val,10);

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

267: --
268: g_debug := hr_utility.debug_enabled;
269: --
270: if g_debug then
271: hr_utility.set_location('Entering '||l_package, 10);
272: hr_utility.set_location(' p_convert_from_val '||p_convert_from_val,10);
273: end if;
274: --
275: --

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

268: g_debug := hr_utility.debug_enabled;
269: --
270: if g_debug then
271: hr_utility.set_location('Entering '||l_package, 10);
272: hr_utility.set_location(' p_convert_from_val '||p_convert_from_val,10);
273: end if;
274: --
275: --
276: IF p_convert_from_val IS NOT NULL THEN

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

291: p_param5 => 'BEN_ECR_IV_ENRT_RT_ID',
292: p_param5_value => to_char(p_enrt_rt_id)
293: );
294: --
295: hr_utility.set_location('Done with Formula',10);
296: --
297: -- Loop through the returned table and make sure that the returned
298: -- values have been found
299: --

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

316: else
317: --
318: -- Account for cases where formula returns an unknown
319: -- variable name
320: hr_utility.set_location('In the Loop wrong Name ',10);
321: --
322: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM');
323: fnd_message.set_token('PROC',l_package);
324: fnd_message.set_token('FORMULA',p_formula_id);

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

328: end if;
329: --
330: exception when others then
331: --
332: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM ',10);
333: --
334: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
335: fnd_message.set_token('PROC',l_package);
336: fnd_message.set_token('FORMULA',p_formula_id);

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

341: end loop ;
342: ELSE
343: --
344: if g_debug then
345: hr_utility.set_location('p_convert_from_val IS NULL returning NULLS',10);
346: end if;
347: --
348: l_val := NULL;
349: l_cmcd_val := NULL;

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

354: p_val := l_val;
355: p_cmcd_val := l_cmcd_val;
356: p_ann_val := l_ann_val;
357: if g_debug then
358: hr_utility.set_location('Defined Amount '||p_val,110);
359: hr_utility.set_location('Cmcd Amount '||p_cmcd_val,110);
360: hr_utility.set_location('Ann Amount '||p_ann_val,110);
361: hr_utility.set_location('Leaving '||l_package, 20);
362: end if;

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

355: p_cmcd_val := l_cmcd_val;
356: p_ann_val := l_ann_val;
357: if g_debug then
358: hr_utility.set_location('Defined Amount '||p_val,110);
359: hr_utility.set_location('Cmcd Amount '||p_cmcd_val,110);
360: hr_utility.set_location('Ann Amount '||p_ann_val,110);
361: hr_utility.set_location('Leaving '||l_package, 20);
362: end if;
363: --

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

356: p_ann_val := l_ann_val;
357: if g_debug then
358: hr_utility.set_location('Defined Amount '||p_val,110);
359: hr_utility.set_location('Cmcd Amount '||p_cmcd_val,110);
360: hr_utility.set_location('Ann Amount '||p_ann_val,110);
361: hr_utility.set_location('Leaving '||l_package, 20);
362: end if;
363: --
364: END periodize_with_rule ;

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

357: if g_debug then
358: hr_utility.set_location('Defined Amount '||p_val,110);
359: hr_utility.set_location('Cmcd Amount '||p_cmcd_val,110);
360: hr_utility.set_location('Ann Amount '||p_ann_val,110);
361: hr_utility.set_location('Leaving '||l_package, 20);
362: end if;
363: --
364: END periodize_with_rule ;
365: ---------------------------------------------------------------------------

Line 483: g_debug := hr_utility.debug_enabled;

479: l_max_end_date DATE;
480:
481: begin
482: --
483: g_debug := hr_utility.debug_enabled;
484: --
485: if g_debug then
486: hr_utility.set_location('Entering '||l_package, 10);
487: end if;

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

482: --
483: g_debug := hr_utility.debug_enabled;
484: --
485: if g_debug then
486: hr_utility.set_location('Entering '||l_package, 10);
487: end if;
488: --
489: hr_api.mandatory_arg_error(p_api_name => l_package,
490: p_argument => 'p_acty_ref_perd_cd',

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

495: p_argument_value => p_start_date);
496:
497: --
498: if g_debug then
499: hr_utility.set_location('p_acty_ref_perd_cd '||p_acty_ref_perd_cd,20);
500: hr_utility.set_location('p_start_date '||to_char(p_start_date),30);
501: hr_utility.set_location('p_end_date '||to_char(p_end_date),40);
502: end if;
503: --

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

496:
497: --
498: if g_debug then
499: hr_utility.set_location('p_acty_ref_perd_cd '||p_acty_ref_perd_cd,20);
500: hr_utility.set_location('p_start_date '||to_char(p_start_date),30);
501: hr_utility.set_location('p_end_date '||to_char(p_end_date),40);
502: end if;
503: --
504: if p_end_date is null then

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

497: --
498: if g_debug then
499: hr_utility.set_location('p_acty_ref_perd_cd '||p_acty_ref_perd_cd,20);
500: hr_utility.set_location('p_start_date '||to_char(p_start_date),30);
501: hr_utility.set_location('p_end_date '||to_char(p_end_date),40);
502: end if;
503: --
504: if p_end_date is null then
505: --

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

533: --
534: end if;
535: --
536: if g_debug then
537: hr_utility.set_location(l_package,50);
538: end if;
539: --
540: if p_acty_ref_perd_cd = 'PWK' then
541: --

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

556: or p_acty_ref_perd_cd = 'PPF' then
557: --
558: -- Pay Period
559: --
560: hr_utility.set_location('Inside PP',2007);
561: if p_element_type_id is not null then
562: l_element_type_id:=p_element_type_id;
563: else
564: open c_get_element_type_id;

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

582: fetch get_period_type into l_period_type;
583: close get_period_type;
584: --
585: if l_period_type in ('Calendar Month','Lunar Month') then
586: hr_utility.set_location('Inside Calendar Month',2007);
587: -- 3704632 : Added IF-CLAUSE here.
588: if (p_end_date is null) THEN
589: select MAX(end_date)
590: into l_max_end_date

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

617: --
618: close pay_freq_rule_exists;
619: --
620: IF l_reset <>'MM' THEN -- Year
621: hr_utility.set_location('Frequency Rule Year',2007);
622: BEGIN
623: FOR l_parse_periods IN c_parse_periods1(p_payroll_id,
624: p_start_date,
625: nvl(p_end_date,l_end_date))

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

643: ELSE -- Month
644:
645: --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.
646: if TRUNC(p_start_date,l_reset) = TRUNC(p_end_date,l_reset) then
647: hr_utility.set_location('Frequency Rule Month',2007);
648: BEGIN
649: if g_debug then
650: hr_utility.set_location('get_periods_between ',10);
651: end if;

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

646: if TRUNC(p_start_date,l_reset) = TRUNC(p_end_date,l_reset) then
647: hr_utility.set_location('Frequency Rule Month',2007);
648: BEGIN
649: if g_debug then
650: hr_utility.set_location('get_periods_between ',10);
651: end if;
652: FOR l_parse_periods IN c_parse_periods1(p_payroll_id,
653: p_start_date,
654: p_end_date)

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

671: --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));
672: END;
673: else
674: IF p_start_date <> TRUNC(p_start_date,l_reset) THEN
675: hr_utility.set_location('Frequency Rule Month',2007);
676: BEGIN
677: if g_debug then
678: hr_utility.set_location('get_periods_between ',10);
679: end if;

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

674: IF p_start_date <> TRUNC(p_start_date,l_reset) THEN
675: hr_utility.set_location('Frequency Rule Month',2007);
676: BEGIN
677: if g_debug then
678: hr_utility.set_location('get_periods_between ',10);
679: end if;
680: FOR l_parse_periods IN c_parse_periods1(p_payroll_id,
681: p_start_date,
682: ADD_MONTHS(TRUNC(p_start_date,l_reset),1) -1)

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

703: ELSE
704: l_start_date := p_start_date;
705: END IF;
706: 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
707: hr_utility.set_location('Frequency Other1',2007);
708: BEGIN
709: if g_debug then
710: hr_utility.set_location('get_periods_between ',15);
711: end if;

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

706: 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
707: hr_utility.set_location('Frequency Other1',2007);
708: BEGIN
709: if g_debug then
710: hr_utility.set_location('get_periods_between ',15);
711: end if;
712: FOR l_parse_periods IN c_parse_periods1(p_payroll_id,
713: TRUNC(NVL(p_end_date, l_end_date),l_reset), -- 3704632 : Added NVL() to p_end_date
714: NVL(p_end_date, l_end_date)) -- 3704632 : Added NVL() to p_end_date

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

736: l_end_date := NVL(p_end_date, l_end_date); -- 3704632 : Added NVL() to p_end_date
737: END IF;
738: IF (l_start_date <= l_end_date ) THEN
739: if g_debug then
740: hr_utility.set_location('get_periods_between ',20);
741: end if;
742: OPEN parse_periods(p_payroll_id => p_payroll_id
743: ,p_rt_start =>l_start_date
744: ,p_eoy =>l_end_date

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

748: FETCH parse_periods INTO l_tot_perd;
749: --
750: CLOSE parse_periods;
751: --
752: hr_utility.set_location('Frequency Year others 2',2007);
753: l_periods := l_periods + l_tot_perd;
754: -- dbms_output.put_line('20:start'||to_char(l_start_Date)||' end '||to_char(l_end_date)||' periods '||to_char(l_periods));
755: END IF; -- l_start_date <= l_end_date
756: end if;

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

791: l_tot_perd := 1 ;
792: --
793: end if;
794: --
795: hr_utility.set_location('Frequency Year other3',2007);
796: l_periods := l_tot_perd;
797: --
798: END IF;
799: END IF;

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

798: END IF;
799: END IF;
800: END IF;
801: if g_debug then
802: hr_utility.set_location(' Before if l_periods = 0 ',233);
803: end if;
804: --
805: if l_periods = 0 or l_periods is null then
806: l_periods := l_tot_perd;

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

809: if (l_tot_perd = 0 AND l_periods = 0 and not p_called_from_est) then
810: --
811: -- Raise error as payroll was not found.
812: if g_debug then
813: hr_utility.set_location('l_tot_perd = 0 and l_periods = 0 ' ,234);
814: end if;
815: --
816: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
817: fnd_message.set_token('PROC',l_package);

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

868: close c_element_rule_exists;
869: end if;
870: --
871: if g_debug then
872: hr_utility.set_location('Pay roll id'||p_payroll_id,111);
873: hr_utility.set_location('start date '||p_start_date,111);
874: hr_utility.set_location('end date '||l_end_date,111);
875: end if;
876: if l_element_rule_exists = 'Y' then

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

869: end if;
870: --
871: if g_debug then
872: hr_utility.set_location('Pay roll id'||p_payroll_id,111);
873: hr_utility.set_location('start date '||p_start_date,111);
874: hr_utility.set_location('end date '||l_end_date,111);
875: end if;
876: if l_element_rule_exists = 'Y' then
877: --

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

870: --
871: if g_debug then
872: hr_utility.set_location('Pay roll id'||p_payroll_id,111);
873: hr_utility.set_location('start date '||p_start_date,111);
874: hr_utility.set_location('end date '||l_end_date,111);
875: end if;
876: if l_element_rule_exists = 'Y' then
877: --
878: for l_parse_periods in c_parse_periods1(p_payroll_id,

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

988: --
989: end if;
990:
991: if g_debug then
992: hr_utility.set_location('Number of Periods: '||to_char(l_periods), 90);
993: hr_utility.set_location('Leaving '||l_package , 90);
994: end if;
995:
996: return(l_periods);

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

989: end if;
990:
991: if g_debug then
992: hr_utility.set_location('Number of Periods: '||to_char(l_periods), 90);
993: hr_utility.set_location('Leaving '||l_package , 90);
994: end if;
995:
996: return(l_periods);
997:

Line 1142: g_debug := hr_utility.debug_enabled;

1138: l_pay_annualization_factor number ;
1139:
1140: begin
1141: --
1142: g_debug := hr_utility.debug_enabled;
1143: --
1144: if g_debug then
1145: hr_utility.set_location('Entering '||l_package, 11);
1146: end if;

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

1141: --
1142: g_debug := hr_utility.debug_enabled;
1143: --
1144: if g_debug then
1145: hr_utility.set_location('Entering '||l_package, 11);
1146: end if;
1147: --
1148: hr_api.mandatory_arg_error(p_api_name => l_package,
1149: p_argument => 'p_acty_ref_perd_cd',

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

1154: p_argument_value => p_start_date);
1155:
1156: --
1157: if g_debug then
1158: hr_utility.set_location('p_acty_ref_perd_cd '||p_acty_ref_perd_cd,21);
1159: hr_utility.set_location('p_start_date '||to_char(p_start_date),31);
1160: hr_utility.set_location('p_end_date '||to_char(p_end_date),41);
1161: end if;
1162: --

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

1155:
1156: --
1157: if g_debug then
1158: hr_utility.set_location('p_acty_ref_perd_cd '||p_acty_ref_perd_cd,21);
1159: hr_utility.set_location('p_start_date '||to_char(p_start_date),31);
1160: hr_utility.set_location('p_end_date '||to_char(p_end_date),41);
1161: end if;
1162: --
1163: if p_end_date is null then

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

1156: --
1157: if g_debug then
1158: hr_utility.set_location('p_acty_ref_perd_cd '||p_acty_ref_perd_cd,21);
1159: hr_utility.set_location('p_start_date '||to_char(p_start_date),31);
1160: hr_utility.set_location('p_end_date '||to_char(p_end_date),41);
1161: end if;
1162: --
1163: if p_end_date is null then
1164: --

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

1192: --
1193: end if;
1194: --
1195: if g_debug then
1196: hr_utility.set_location(l_package,51);
1197: end if;
1198: --
1199: if p_acty_ref_perd_cd = 'PWK' then
1200: --

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

1299: --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.
1300: IF TRUNC(p_start_date,l_reset) = TRUNC(p_end_date,l_reset) THEN
1301: BEGIN
1302: if g_debug then
1303: hr_utility.set_location('get_periods_between ',10);
1304: end if;
1305: FOR l_parse_periods IN c_parse_periods1(p_payroll_id,
1306: p_start_date,
1307: p_end_date)

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

1325: else
1326: IF p_start_date <> TRUNC(p_start_date,l_reset) THEN
1327: BEGIN
1328: if g_debug then
1329: hr_utility.set_location('get_periods_between ',10);
1330: end if;
1331: FOR l_parse_periods IN c_parse_periods1(p_payroll_id,
1332: p_start_date,
1333: ADD_MONTHS(TRUNC(p_start_date,l_reset),1) -1)

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

1355: END IF;
1356: IF p_end_date <> (ADD_MONTHS(TRUNC(p_end_date,l_reset),1) -1) THEN
1357: BEGIN
1358: if g_debug then
1359: hr_utility.set_location('get_periods_between ',15);
1360: end if;
1361: FOR l_parse_periods IN c_parse_periods1(p_payroll_id,
1362: TRUNC(p_end_date,l_reset),
1363: p_end_date)

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

1384: l_end_date := p_end_date;
1385: END IF;
1386: IF (l_start_date <= l_end_date ) THEN
1387: if g_debug then
1388: hr_utility.set_location('get_periods_between ',20);
1389: end if;
1390: OPEN parse_periods(p_payroll_id => p_payroll_id
1391: ,p_rt_start =>l_start_date
1392: ,p_eoy =>l_end_date

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

1432: --
1433: END IF;
1434: END IF;
1435: if g_debug then
1436: hr_utility.set_location(' Before if l_periods = 0 ',233);
1437: end if;
1438: --
1439: if l_periods = 0 or l_periods is null then
1440: l_periods := l_tot_perd;

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

1443: if (l_tot_perd = 0 AND l_periods = 0) then
1444: --
1445: -- Raise error as payroll was not found.
1446: if g_debug then
1447: hr_utility.set_location('l_tot_perd = 0 and l_periods = 0 ' ,234);
1448: end if;
1449: --
1450: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
1451: fnd_message.set_token('PROC',l_package);

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

1532: --
1533: end if;
1534:
1535: if g_debug then
1536: hr_utility.set_location('Number of Periods: '||to_char(l_periods), 90);
1537: hr_utility.set_location('Leaving '||l_package , 90);
1538: end if;
1539:
1540: return(l_periods);

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

1533: end if;
1534:
1535: if g_debug then
1536: hr_utility.set_location('Number of Periods: '||to_char(l_periods), 90);
1537: hr_utility.set_location('Leaving '||l_package , 90);
1538: end if;
1539:
1540: return(l_periods);
1541:

Line 1615: g_debug := hr_utility.debug_enabled;

1611: l_package varchar2(80) := g_package || '.estimate_balance';
1612: --
1613: begin
1614: --
1615: g_debug := hr_utility.debug_enabled;
1616: --
1617: if g_debug then
1618: hr_utility.set_location('Entering '||l_package, 10);
1619: end if;

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

1614: --
1615: g_debug := hr_utility.debug_enabled;
1616: --
1617: if g_debug then
1618: hr_utility.set_location('Entering '||l_package, 10);
1619: end if;
1620: --
1621: for l_element in c_element loop
1622: --

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

1645: --
1646: end if;
1647: --
1648: if g_debug then
1649: hr_utility.set_location('strt dt '||to_char(l_start_date), 110);
1650: hr_utility.set_location('end dt '||to_char(l_end_date), 110);
1651: end if;
1652: l_periods := get_periods_between
1653: (p_start_date => l_start_date,

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

1646: end if;
1647: --
1648: if g_debug then
1649: hr_utility.set_location('strt dt '||to_char(l_start_date), 110);
1650: hr_utility.set_location('end dt '||to_char(l_end_date), 110);
1651: end if;
1652: l_periods := get_periods_between
1653: (p_start_date => l_start_date,
1654: p_end_date => l_end_date,

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

1676: --
1677: p_balance := nvl(l_estimate,0);
1678: --
1679: if g_debug then
1680: hr_utility.set_location('Estimated Balance'||p_balance,11);
1681: hr_utility.set_location('Leaving '||l_package, 10);
1682: end if;
1683: --
1684: end estimate_balance;

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

1677: p_balance := nvl(l_estimate,0);
1678: --
1679: if g_debug then
1680: hr_utility.set_location('Estimated Balance'||p_balance,11);
1681: hr_utility.set_location('Leaving '||l_package, 10);
1682: end if;
1683: --
1684: end estimate_balance;
1685: --

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

1836: --
1837: begin
1838: --
1839: if g_debug then
1840: hr_utility.set_location('Entering '||l_package, 10);
1841: end if;
1842: --
1843: if p_enrt_rt_id is not null then
1844: --

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

1876: if l_ecr.det_pl_ytd_cntrs_cd is null or
1877: l_start_date is null then
1878: --
1879: if g_debug then
1880: hr_utility.set_location('Leaving '||l_package , 91);
1881: end if;
1882: return(0);
1883: --
1884: end if;

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

1919: l_rt_end_dt := p_end_date ;
1920: end if ;
1921: ---
1922: if g_debug then
1923: hr_utility.set_location('yr start date ' || l_start_date , 293);
1924: hr_utility.set_location('l_rt_strt_dt '|| l_rt_strt_dt, 293);
1925: hr_utility.set_location('end date ' || l_rt_end_dt , 293);
1926: hr_utility.set_location('level facotr ' || l_ecr.ptd_comp_lvl_fctr_id , 293);
1927: end if;

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

1920: end if ;
1921: ---
1922: if g_debug then
1923: hr_utility.set_location('yr start date ' || l_start_date , 293);
1924: hr_utility.set_location('l_rt_strt_dt '|| l_rt_strt_dt, 293);
1925: hr_utility.set_location('end date ' || l_rt_end_dt , 293);
1926: hr_utility.set_location('level facotr ' || l_ecr.ptd_comp_lvl_fctr_id , 293);
1927: end if;
1928:

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

1921: ---
1922: if g_debug then
1923: hr_utility.set_location('yr start date ' || l_start_date , 293);
1924: hr_utility.set_location('l_rt_strt_dt '|| l_rt_strt_dt, 293);
1925: hr_utility.set_location('end date ' || l_rt_end_dt , 293);
1926: hr_utility.set_location('level facotr ' || l_ecr.ptd_comp_lvl_fctr_id , 293);
1927: end if;
1928:
1929:

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

1922: if g_debug then
1923: hr_utility.set_location('yr start date ' || l_start_date , 293);
1924: hr_utility.set_location('l_rt_strt_dt '|| l_rt_strt_dt, 293);
1925: hr_utility.set_location('end date ' || l_rt_end_dt , 293);
1926: hr_utility.set_location('level facotr ' || l_ecr.ptd_comp_lvl_fctr_id , 293);
1927: end if;
1928:
1929:
1930: if l_rt_end_dt is null or

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

1937: -- calculated is 12/31/89. Here the old rate will belong in the
1938: -- previous year (1989) and should not be used for current year (1990)
1939: --
1940: if g_debug then
1941: hr_utility.set_location('Leaving '||l_package , 92);
1942: end if;
1943: return(0);
1944: --
1945: end if;

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

1972: -- (BTDADDEST)
1973: -- This date also makes sense only for defined balances (BALTYP).
1974: --
1975: if g_debug then
1976: hr_utility.set_location('balance '||l_balance_amt , 92);
1977: end if;
1978: if l_clf.comp_src_cd = 'BALTYP' and
1979: l_ecr.det_pl_ytd_cntrs_cd = 'BTDADDEST' and
1980: l_balance_amt > 0 then

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

2006: -- if l_rt_end_dt is greater than the rate start date, we need to take the rates
2007: -- rate start date - 1 else take the rate end end date.
2008: --
2009: if g_debug then
2010: hr_utility.set_location(' p_date_to '||least(l_rt_strt_dt-1, l_rt_end_dt),10);
2011: hr_utility.set_location(' l_start_date'||l_start_date,10);
2012: end if;
2013: --
2014: estimate_balance(p_person_id => l_epe.person_id,

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

2007: -- rate start date - 1 else take the rate end end date.
2008: --
2009: if g_debug then
2010: hr_utility.set_location(' p_date_to '||least(l_rt_strt_dt-1, l_rt_end_dt),10);
2011: hr_utility.set_location(' l_start_date'||l_start_date,10);
2012: end if;
2013: --
2014: estimate_balance(p_person_id => l_epe.person_id,
2015: p_acty_base_rt_id => l_ecr.acty_base_rt_id,

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

2022: --
2023: end if;
2024: --
2025: if g_debug then
2026: hr_utility.set_location('Leaving '||l_package , 99);
2027: end if;
2028: --
2029: return(nvl(l_balance_amt,0) +l_estimated_bal);
2030: --

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

2247: l_env_rec ben_env_object.g_global_env_rec_type;
2248: --
2249: begin
2250: --
2251: hr_utility.set_location('Entering '||l_package, 10);
2252: --
2253: g_debug := hr_utility.debug_enabled;
2254: --
2255: p_yr_start_date := p_start_date;

Line 2253: g_debug := hr_utility.debug_enabled;

2249: begin
2250: --
2251: hr_utility.set_location('Entering '||l_package, 10);
2252: --
2253: g_debug := hr_utility.debug_enabled;
2254: --
2255: p_yr_start_date := p_start_date;
2256: --
2257: ben_env_object.get(p_rec => l_env_rec);

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

2333: --
2334: if c_epe%notfound then
2335: --
2336: close c_epe;
2337: -- hr_utility.set_location('BEN_91457_ELCTBL_CHC_NOT_FOUND ID:'||
2338: -- to_char(p_elig_per_elctbl_chc_id), 50);
2339: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
2340: fnd_message.set_token('ID',to_char(p_elig_per_elctbl_chc_id));
2341: fnd_message.set_token('PROC',l_package);

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

2365: l_lf_evt_ocrd_dt := l_epe.lf_evt_ocrd_dt;
2366: --
2367: else
2368: --
2369: -- hr_utility.set_location('BEN_91884_CHC_N_RT_NOT_FOUND:', 50);
2370: fnd_message.set_name('BEN','BEN_91884_CHC_N_RT_NOT_FOUND');
2371: fnd_message.set_token('PROC',l_package);
2372: fnd_message.raise_error;
2373: --

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

2421: --
2422: if c_yrp%notfound and l_benmngle_parm_rec.mode_cd <> 'D' then --ICM Changes
2423: --
2424: close c_yrp;
2425: -- hr_utility.set_location('BEN_91334_PLAN_YR_PERD', 50);
2426:
2427: -- GRADE/STEP Do not throw error for GSP programs
2428: -- Use the Start and End Dates of the year in which
2429: -- the Effective Date falls

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

2450: --
2451: end if;
2452: --BUG 3191928 fixes
2453: if l_yrp.end_date < l_start_date then
2454: hr_utility.set_location('strt dt is'||to_char(l_start_date),123);
2455: open c_pl_popl_yr_period_current;
2456: fetch c_pl_popl_yr_period_current into l_yrp;
2457: close c_pl_popl_yr_period_current;
2458: end if;

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

2462: --
2463: if p_complete_year_flag = 'Y' then
2464: --
2465: p_start_date := l_yrp.start_date;
2466: hr_utility.set_location('strt dt is'||to_char(p_start_date),123);
2467: --
2468: end if;
2469: --
2470: end if;

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

2475: -- the start_date is less that the p_yr_start_date then we derive the start_date
2476: if p_complete_year_flag = 'N' and nvl(p_start_date,l_start_date) < p_yr_start_date then
2477: --
2478: if g_debug then
2479: hr_utility.set_location(' p_complete_year_flag = N ',123);
2480: end if;
2481: if p_acty_ref_perd_cd = 'PP' then
2482: --
2483: open c_parse_periods(p_payroll_id,p_yr_start_date,p_end_date );

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

2491: end if;
2492: --
2493: end if;
2494: --
2495: hr_utility.set_location('IK RT STRT p_start_date'||p_start_date,111);
2496: if p_start_date is null then
2497: --
2498: if l_start_date is null then
2499: --

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

2515: p_start_date := l_start_date;
2516: --
2517: end if;
2518: --Bug 2151055
2519: hr_utility.set_location('IK RT STRT p_start_date'||p_start_date,112);
2520: --
2521: if p_start_date > p_end_date and p_yr_start_date < p_start_date then
2522: --
2523: p_start_date := p_yr_start_date ;

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

2530: p_acty_ref_perd_cd := l_acty_ref_perd_cd;
2531: --
2532: end if;
2533: --
2534: -- hr_utility.set_location('Leaving '||l_package , 99);
2535: --
2536: exception
2537: --
2538: when others then

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

2536: exception
2537: --
2538: when others then
2539: if g_debug then
2540: hr_utility.set_location('WHEN OTHERS: '||l_package, 100);
2541: end if;
2542: p_start_date := l_start_date_nc_buffer; -- no copy changes
2543: p_end_date := l_end_date_nc_buffer; -- no copy changes
2544: p_yr_start_date := null; -- no copy changes

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

2606: --End of code for Bug 6913654
2607:
2608: begin
2609: --
2610: -- hr_utility.set_location('Entering '||l_package, 10);
2611: --
2612: -- Check for a null amount. Assumption is that a calculation
2613: -- cannot be performed on a null amount.
2614: --

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

2755: p_enrt_rt_id => p_enrt_rt_id,
2756: p_element_type_id => p_element_type_id,
2757: p_effective_date => p_effective_date
2758: );
2759: --hr_utility.set_location('Inside period ESTONLY periods: '||l_no_of_periods, 9999);
2760: --hr_utility.set_location('Inside period ESTONLY enrt_id: '||p_enrt_rt_id, 9999);
2761: open c_get_cmmd_amt ;
2762: fetch c_get_cmmd_amt into l_period_amt;
2763: close c_get_cmmd_amt;

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

2756: p_element_type_id => p_element_type_id,
2757: p_effective_date => p_effective_date
2758: );
2759: --hr_utility.set_location('Inside period ESTONLY periods: '||l_no_of_periods, 9999);
2760: --hr_utility.set_location('Inside period ESTONLY enrt_id: '||p_enrt_rt_id, 9999);
2761: open c_get_cmmd_amt ;
2762: fetch c_get_cmmd_amt into l_period_amt;
2763: close c_get_cmmd_amt;
2764: --hr_utility.set_location('Inside period ESTONLY amt: '||l_period_amt, 9999);

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

2760: --hr_utility.set_location('Inside period ESTONLY enrt_id: '||p_enrt_rt_id, 9999);
2761: open c_get_cmmd_amt ;
2762: fetch c_get_cmmd_amt into l_period_amt;
2763: close c_get_cmmd_amt;
2764: --hr_utility.set_location('Inside period ESTONLY amt: '||l_period_amt, 9999);
2765: else
2766: l_no_of_periods := get_periods_between
2767: (p_acty_ref_perd_cd => l_acty_ref_perd_cd,
2768: p_start_date => l_start_date,

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

2777: --
2778: end if;
2779: --
2780: l_annual_amt := (l_period_amt * l_no_of_periods) + l_balance_amt;
2781: -- hr_utility.set_location('perd amt '||to_char(l_period_amt), 11);
2782: -- hr_utility.set_location('perd no '||to_char(l_no_of_periods), 11);
2783: -- hr_utility.set_location('bal amt '||to_char(l_balance_amt), 11);
2784: --
2785: l_annual_amt := round(l_annual_amt,2);

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

2778: end if;
2779: --
2780: l_annual_amt := (l_period_amt * l_no_of_periods) + l_balance_amt;
2781: -- hr_utility.set_location('perd amt '||to_char(l_period_amt), 11);
2782: -- hr_utility.set_location('perd no '||to_char(l_no_of_periods), 11);
2783: -- hr_utility.set_location('bal amt '||to_char(l_balance_amt), 11);
2784: --
2785: l_annual_amt := round(l_annual_amt,2);
2786: --

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

2779: --
2780: l_annual_amt := (l_period_amt * l_no_of_periods) + l_balance_amt;
2781: -- hr_utility.set_location('perd amt '||to_char(l_period_amt), 11);
2782: -- hr_utility.set_location('perd no '||to_char(l_no_of_periods), 11);
2783: -- hr_utility.set_location('bal amt '||to_char(l_balance_amt), 11);
2784: --
2785: l_annual_amt := round(l_annual_amt,2);
2786: --
2787: if g_period_to_annual_cached > 0 then

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

2820: g_period_to_annual_cache(l_hv).annual_amt := l_annual_amt;
2821: --
2822: end if;
2823: --
2824: -- hr_utility.set_location('Leaving '||l_package , 90);
2825: --
2826: return(l_annual_amt);
2827: --
2828: exception

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

2891: l_cd ben_acty_base_rt_f.det_pl_ytd_cntrs_cd%TYPE := null;
2892: l_call_balance boolean;
2893: begin
2894: --
2895: -- hr_utility.set_location('Entering '||l_package, 10);
2896: --
2897: -- Check for a null amount. Assumption is that a calculation
2898: -- cannot be performed on a null amount.
2899: --

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

3040: p_enrt_rt_id => p_enrt_rt_id,
3041: p_element_type_id => p_element_type_id,
3042: p_effective_date => p_effective_date
3043: );
3044: --hr_utility.set_location('Inside period ETONLY periods: '||l_no_of_periods, 9999);
3045: --hr_utility.set_location('Inside period ETONLY enrt_id: '||p_enrt_rt_id, 9999);
3046: open c_get_cmmd_amt ;
3047: fetch c_get_cmmd_amt into l_period_amt;
3048: close c_get_cmmd_amt;

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

3041: p_element_type_id => p_element_type_id,
3042: p_effective_date => p_effective_date
3043: );
3044: --hr_utility.set_location('Inside period ETONLY periods: '||l_no_of_periods, 9999);
3045: --hr_utility.set_location('Inside period ETONLY enrt_id: '||p_enrt_rt_id, 9999);
3046: open c_get_cmmd_amt ;
3047: fetch c_get_cmmd_amt into l_period_amt;
3048: close c_get_cmmd_amt;
3049: --hr_utility.set_location('Inside period ETONLY amt: '||l_period_amt, 9999);

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

3045: --hr_utility.set_location('Inside period ETONLY enrt_id: '||p_enrt_rt_id, 9999);
3046: open c_get_cmmd_amt ;
3047: fetch c_get_cmmd_amt into l_period_amt;
3048: close c_get_cmmd_amt;
3049: --hr_utility.set_location('Inside period ETONLY amt: '||l_period_amt, 9999);
3050: else
3051: l_no_of_periods := get_periods_between
3052: (p_acty_ref_perd_cd => l_acty_ref_perd_cd,
3053: p_start_date => l_start_date,

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

3062: --
3063: end if;
3064: --
3065: l_annual_amt := (l_period_amt * l_no_of_periods) + l_balance_amt;
3066: -- hr_utility.set_location('perd amt '||to_char(l_period_amt), 11);
3067: -- hr_utility.set_location('perd no '||to_char(l_no_of_periods), 11);
3068: -- hr_utility.set_location('bal amt '||to_char(l_balance_amt), 11);
3069: --
3070: if p_rounding_flag = 'Y' then

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

3063: end if;
3064: --
3065: l_annual_amt := (l_period_amt * l_no_of_periods) + l_balance_amt;
3066: -- hr_utility.set_location('perd amt '||to_char(l_period_amt), 11);
3067: -- hr_utility.set_location('perd no '||to_char(l_no_of_periods), 11);
3068: -- hr_utility.set_location('bal amt '||to_char(l_balance_amt), 11);
3069: --
3070: if p_rounding_flag = 'Y' then
3071: --

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

3064: --
3065: l_annual_amt := (l_period_amt * l_no_of_periods) + l_balance_amt;
3066: -- hr_utility.set_location('perd amt '||to_char(l_period_amt), 11);
3067: -- hr_utility.set_location('perd no '||to_char(l_no_of_periods), 11);
3068: -- hr_utility.set_location('bal amt '||to_char(l_balance_amt), 11);
3069: --
3070: if p_rounding_flag = 'Y' then
3071: --
3072: l_annual_amt := round(l_annual_amt,2);

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

3109: g_period_to_annual_cache(l_hv).annual_amt := l_annual_amt;
3110: --
3111: end if;
3112: --
3113: -- hr_utility.set_location('Leaving '||l_package , 90);
3114: --
3115: return(l_annual_amt);
3116: --
3117: exception

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

3210: --
3211: begin
3212: --
3213: if g_debug then
3214: hr_utility.set_location('Entering '||l_package, 10);
3215: end if;
3216: hr_utility.set_location('Annual Amount in Annual to Period '||p_amount, 10);
3217: --
3218: -- Check for a null amount. Assumption is that a calculation

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

3212: --
3213: if g_debug then
3214: hr_utility.set_location('Entering '||l_package, 10);
3215: end if;
3216: hr_utility.set_location('Annual Amount in Annual to Period '||p_amount, 10);
3217: --
3218: -- Check for a null amount. Assumption is that a calculation
3219: -- cannot be performed on a null amount.
3220: --

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

3373: l_yr_start_date := l_yr_start_date - NVL(l_first_pay_date_offset,0); -- 5642552: Added NVL.
3374: l_start_date_check := l_start_date;
3375: end if;
3376: if g_debug then
3377: hr_utility.set_location('Pay Date Offset'||l_first_pay_date_offset,11);
3378: end if;
3379: end if;
3380: --
3381:

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

3429: --
3430: end if;
3431: --
3432: l_period_amt := (l_annual_amt - l_balance_amt)/l_no_of_periods;
3433: hr_utility.set_location('Annual to Period Amount '||l_period_amt , 90);
3434: --
3435: l_period_amt := round(l_period_amt,2);
3436: --
3437: if g_annual_to_period_cached > 0 then

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

3471: g_annual_to_period_cache(l_hv).pp_in_yr_used_num := l_no_of_periods;
3472: --
3473: end if;
3474: --
3475: hr_utility.set_location('Leaving '||l_package , 90);
3476: --
3477: return(l_period_amt);
3478: --
3479: exception

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

3567: --
3568: begin
3569: --
3570: if g_debug then
3571: hr_utility.set_location('Entering '||l_package, 10);
3572: end if;
3573: hr_utility.set_location('Annual Amount in Annual to Period '||p_amount, 10);
3574:
3575: --

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

3569: --
3570: if g_debug then
3571: hr_utility.set_location('Entering '||l_package, 10);
3572: end if;
3573: hr_utility.set_location('Annual Amount in Annual to Period '||p_amount, 10);
3574:
3575: --
3576: -- Check for a null amount. Assumption is that a calculation
3577: -- cannot be performed on a null amount.

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

3729: --
3730: l_yr_start_date := l_yr_start_date - NVL(l_first_pay_date_offset,0);
3731: --
3732: if g_debug then
3733: hr_utility.set_location('Pay Date Offset'||l_pay_date_offset,11);
3734: end if;
3735: end if;
3736: --
3737:

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

3830: g_annual_to_period_cache(l_hv).pp_in_yr_used_num := l_no_of_periods;
3831: --
3832: end if;
3833: --
3834: hr_utility.set_location('Leaving '||l_package , 90);
3835: --
3836: return(l_period_amt);
3837: --
3838: exception

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

3897: l_pay_date_offset number;
3898: --
3899: begin
3900: --
3901: -- hr_utility.set_location('Entering '||l_package, 10);
3902: --
3903: -- Check for a null amount. Assumption is that a calculation
3904: -- cannot be performed on a null amount.
3905: --

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

4107: g_annual_to_period_cache(l_hv).pp_in_yr_used_num := l_no_of_periods;
4108: --
4109: end if;
4110: --
4111: -- hr_utility.set_location('Leaving '||l_package , 90);
4112: --
4113: p_pp_in_yr_used_num := l_no_of_periods;
4114: return(l_period_amt);
4115: --

Line 4215: g_debug := hr_utility.debug_enabled;

4211: l_abr_balance abr_balance%rowtype;
4212: --
4213: begin
4214: --
4215: g_debug := hr_utility.debug_enabled;
4216: --
4217: if g_debug then
4218: hr_utility.set_location('Entering '||l_package , 10);
4219: end if;

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

4214: --
4215: g_debug := hr_utility.debug_enabled;
4216: --
4217: if g_debug then
4218: hr_utility.set_location('Entering '||l_package , 10);
4219: end if;
4220:
4221: if p_elig_per_elctbl_chc_id is not null then
4222: -- get needed values

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

4335: end if;
4336: end if;
4337:
4338: if g_debug then
4339: hr_utility.set_location('p_clm_balance '||to_char(p_clm_balance)||
4340: ' p_ptd_balance '||to_char(p_ptd_balance) , 97);
4341: end if;
4342:
4343: -- the minimum that the prtt can select is the higher of payments-to-date,

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

4354: p_ann_mx_val := p_ann_mn_val;
4355: end if;
4356:
4357: if g_debug then
4358: hr_utility.set_location('p_ann_mn_val '||to_char(p_ann_mn_val)||
4359: ' p_ann_mx_val '||to_char(p_ann_mx_val) , 97);
4360: hr_utility.set_location('Leaving '||l_package , 99);
4361: end if;
4362: end compare_balances;

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

4356:
4357: if g_debug then
4358: hr_utility.set_location('p_ann_mn_val '||to_char(p_ann_mn_val)||
4359: ' p_ann_mx_val '||to_char(p_ann_mx_val) , 97);
4360: hr_utility.set_location('Leaving '||l_package , 99);
4361: end if;
4362: end compare_balances;
4363:
4364: ---------------------------------------------------------------------------

Line 4451: g_debug := hr_utility.debug_enabled;

4447: l_jurisdiction PAY_CA_EMP_PROV_TAX_INFO_F.JURISDICTION_CODE%type := null;
4448:
4449: begin
4450: --
4451: g_debug := hr_utility.debug_enabled;
4452: --
4453: if g_debug then
4454: hr_utility.set_location ('Entering '||l_package,10);
4455: end if;

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

4450: --
4451: g_debug := hr_utility.debug_enabled;
4452: --
4453: if g_debug then
4454: hr_utility.set_location ('Entering '||l_package,10);
4455: end if;
4456:
4457: open get_cds;
4458: fetch get_cds into l_get_cds;

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

4458: fetch get_cds into l_get_cds;
4459: close get_cds;
4460:
4461: if g_debug then
4462: hr_utility.set_location('prort_mn_ann_elcn_val_cd '||
4463: l_get_cds.prort_mn_ann_elcn_val_cd,20);
4464: end if;
4465:
4466: if g_debug then

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

4463: l_get_cds.prort_mn_ann_elcn_val_cd,20);
4464: end if;
4465:
4466: if g_debug then
4467: hr_utility.set_location('prort_mx_ann_elcn_val_cd '||
4468: l_get_cds.prort_mx_ann_elcn_val_cd,20);
4469: end if;
4470:
4471: -- do not prorate null values.

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

4652: p_jurisdiction_code => l_jurisdiction);
4653: p_ann_mx_val := l_outputs(l_outputs.first).value;
4654: end if;
4655: if g_debug then
4656: hr_utility.set_location('p_ann_mn_val '||to_char(p_ann_mn_val)||
4657: ' p_ann_mx_val '||to_char(p_ann_mx_val) , 97);
4658: end if;
4659:
4660: p_ann_mn_val := round(p_ann_mn_val,2);

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

4660: p_ann_mn_val := round(p_ann_mn_val,2);
4661: p_ann_mx_val := round(p_ann_mx_val,2);
4662:
4663: if g_debug then
4664: hr_utility.set_location('p_ann_mn_val '||to_char(p_ann_mn_val)||
4665: ' p_ann_mx_val '||to_char(p_ann_mx_val) , 98);
4666: hr_utility.set_location('Leaving '||l_package , 99);
4667: end if;
4668: end prorate_min_max;

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

4662:
4663: if g_debug then
4664: hr_utility.set_location('p_ann_mn_val '||to_char(p_ann_mn_val)||
4665: ' p_ann_mx_val '||to_char(p_ann_mx_val) , 98);
4666: hr_utility.set_location('Leaving '||l_package , 99);
4667: end if;
4668: end prorate_min_max;
4669: --
4670: -- 0 - Always refresh

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

4823: l_payroll_id := p_payroll_id;
4824: end if;
4825: */
4826: --GEVITY
4827: -- hr_utility.trace_on(null,'BENDISRT');
4828: l_trace_param := null;
4829: l_trace_on := false;
4830: --
4831: l_trace_param := fnd_profile.value('BEN_SS_TRACE_VALUE');

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

4836: l_trace_on := false;
4837: end if;
4838: --
4839: if l_trace_on then
4840: hr_utility.trace_on(null,'BENDISRT');
4841: end if;
4842: hr_utility.set_location('l_trace_param : '|| l_trace_param, 5);
4843: hr_utility.set_location ('Entering '||l_proc,10);
4844:

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

4838: --
4839: if l_trace_on then
4840: hr_utility.trace_on(null,'BENDISRT');
4841: end if;
4842: hr_utility.set_location('l_trace_param : '|| l_trace_param, 5);
4843: hr_utility.set_location ('Entering '||l_proc,10);
4844:
4845: open c_abr(p_enrt_rt_id,nvl(p_lf_evt_ocrd_dt,p_effective_date)) ;
4846: fetch c_abr into l_rate_periodization_rl,l_acty_base_rt_id;

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

4839: if l_trace_on then
4840: hr_utility.trace_on(null,'BENDISRT');
4841: end if;
4842: hr_utility.set_location('l_trace_param : '|| l_trace_param, 5);
4843: hr_utility.set_location ('Entering '||l_proc,10);
4844:
4845: open c_abr(p_enrt_rt_id,nvl(p_lf_evt_ocrd_dt,p_effective_date)) ;
4846: fetch c_abr into l_rate_periodization_rl,l_acty_base_rt_id;
4847: close c_abr;

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

4982:
4983: if l_min_val is not null and p_val < l_min_val and
4984: (l_min_val - p_val) <= 0.01 then
4985: p_val := l_min_val;
4986: hr_utility.set_location('Rounding error adjustment in defined rate. value='|| p_val,15.1);
4987: elsif l_max_val is not null and p_val > l_max_val and
4988: (p_val - l_max_val) <= 0.01 then
4989: p_val := l_max_val;
4990: hr_utility.set_location('Rounding error adjustment in defined rate. value='|| p_val,15.2);

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

4986: hr_utility.set_location('Rounding error adjustment in defined rate. value='|| p_val,15.1);
4987: elsif l_max_val is not null and p_val > l_max_val and
4988: (p_val - l_max_val) <= 0.01 then
4989: p_val := l_max_val;
4990: hr_utility.set_location('Rounding error adjustment in defined rate. value='|| p_val,15.2);
4991: end if;
4992: end if;
4993: end if;
4994: --end 5460638

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

5052: else -- this is not supported
5053: raise not_supported;
5054: end if;
5055:
5056: hr_utility.set_location ('Leaving '||l_proc,20);
5057: if l_trace_on then
5058: hr_utility.trace_off;
5059: l_trace_param := null;
5060: l_trace_on := false;

Line 5058: hr_utility.trace_off;

5054: end if;
5055:
5056: hr_utility.set_location ('Leaving '||l_proc,20);
5057: if l_trace_on then
5058: hr_utility.trace_off;
5059: l_trace_param := null;
5060: l_trace_on := false;
5061: end if;
5062: --

Line 5067: hr_utility.trace_off;

5063: exception
5064: when not_supported then
5065: -- This should never happen
5066: if l_trace_on then
5067: hr_utility.trace_off;
5068: l_trace_param := null;
5069: l_trace_on := false;
5070: end if;
5071: raise;

Line 5077: hr_utility.trace_off;

5073: p_ann_rt_val := null; -- no copy changes
5074: p_cmcd_rt_val := null; -- no copy changes
5075: p_val := null; -- no copy changes
5076: if l_trace_on then
5077: hr_utility.trace_off;
5078: l_trace_param := null;
5079: l_trace_on := false;
5080: end if;
5081:

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

5169: l_trace_on boolean;
5170: l_proc varchar2(200) := 'ben_distribute_rates.convert_pcr_rates_w';
5171: --
5172: BEGIN
5173: -- hr_utility.trace_on(null,'BENDISRT');
5174: l_trace_param := null;
5175: l_trace_on := false;
5176: --
5177: l_trace_param := fnd_profile.value('BEN_SS_TRACE_VALUE');

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

5182: l_trace_on := false;
5183: end if;
5184: --
5185: if l_trace_on then
5186: hr_utility.trace_on(null,'BENDISRT');
5187: end if;
5188: --
5189: hr_utility.set_location('l_trace_param : '|| l_trace_param, 5);
5190: hr_utility.set_location ('Entering '||l_proc,10);

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

5185: if l_trace_on then
5186: hr_utility.trace_on(null,'BENDISRT');
5187: end if;
5188: --
5189: hr_utility.set_location('l_trace_param : '|| l_trace_param, 5);
5190: hr_utility.set_location ('Entering '||l_proc,10);
5191: --
5192: OPEN c_cmplt_year;
5193: Fetch c_cmplt_year into l_complete_year_flag;

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

5186: hr_utility.trace_on(null,'BENDISRT');
5187: end if;
5188: --
5189: hr_utility.set_location('l_trace_param : '|| l_trace_param, 5);
5190: hr_utility.set_location ('Entering '||l_proc,10);
5191: --
5192: OPEN c_cmplt_year;
5193: Fetch c_cmplt_year into l_complete_year_flag;
5194: if c_cmplt_year%NOTFOUND

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

5322: CLOSE csr_is_child;
5323: END IF; -- i <> p_rate_index
5324: END LOOP;
5325: --
5326: hr_utility.set_location ('Leaving '||l_proc,20);
5327: if l_trace_on then
5328: hr_utility.trace_off;
5329: l_trace_param := null;
5330: l_trace_on := false;

Line 5328: hr_utility.trace_off;

5324: END LOOP;
5325: --
5326: hr_utility.set_location ('Leaving '||l_proc,20);
5327: if l_trace_on then
5328: hr_utility.trace_off;
5329: l_trace_param := null;
5330: l_trace_on := false;
5331: end if;
5332: --

Line 5348: hr_utility.trace_off;

5344: p_ann_rt_val4 := null; -- no copy changes
5345: p_cmcd_rt_val4 := null; -- no copy changes
5346: p_val4 := null;
5347: if l_trace_on then
5348: hr_utility.trace_off;
5349: l_trace_param := null;
5350: l_trace_on := false;
5351: end if;
5352: raise;