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

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

33: l_package varchar2(80) := g_package||'.rt_typ_calc';
34: --
35: BEGIN
36: --
37: -- hr_utility.set_location ('Entering '||l_package,10);
38: --
39: if p_val is null /*or p_val = 0 commented for 3497676*/then
40: --
41: -- hr_utility.set_location ('Leaving '||l_package,1);

Line 41: -- hr_utility.set_location ('Leaving '||l_package,1);

37: -- hr_utility.set_location ('Entering '||l_package,10);
38: --
39: if p_val is null /*or p_val = 0 commented for 3497676*/then
40: --
41: -- hr_utility.set_location ('Leaving '||l_package,1);
42: return;
43: --
44: end if;
45: --

Line 48: -- hr_utility.set_location ('Leaving '||l_package,2);

44: end if;
45: --
46: if p_val_2 is null /*or p_val_2 = 0 commented for 3497676*/then
47: --
48: -- hr_utility.set_location ('Leaving '||l_package,2);
49: return;
50: --
51: end if;
52: --

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

76: fnd_message.set_token('CODE1',p_rt_typ_cd);
77: fnd_message.raise_error;
78: end if;
79: --
80: -- hr_utility.set_location ('Leaving '||l_package,10);
81: --
82: END rt_typ_calc;
83: --
84: ------------------------------------------------------------------------

Line 113: hr_utility.set_location('Entering '||l_package,20);

109: l_jurisdiction PAY_CA_EMP_PROV_TAX_INFO_F.JURISDICTION_CODE%type := null;
110: --
111: BEGIN
112: --
113: hr_utility.set_location('Entering '||l_package,20);
114: --
115: hr_utility.set_location('Floor/Ceiling Rule Checking'||l_package,30);
116: --
117: -- Bug 1949361 : jurisdiction code is fetched inside formula function

Line 115: hr_utility.set_location('Floor/Ceiling Rule Checking'||l_package,30);

111: BEGIN
112: --
113: hr_utility.set_location('Entering '||l_package,20);
114: --
115: hr_utility.set_location('Floor/Ceiling Rule Checking'||l_package,30);
116: --
117: -- Bug 1949361 : jurisdiction code is fetched inside formula function
118: -- call.
119: --

Line 175: hr_utility.set_location('Floor/Ceiling Val Checking'||l_package,40);

171: p_jurisdiction_code => l_jurisdiction);
172: --
173: end if;
174: --
175: hr_utility.set_location('Floor/Ceiling Val Checking'||l_package,40);
176: --
177: if p_val > nvl(p_upr_lmt_val,p_val+1) then
178: --
179: p_val := p_upr_lmt_val;

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

193: p_val := l_lwr_outputs(l_lwr_outputs.first).value;
194: --
195: end if;
196: --
197: hr_utility.set_location('Leaving '||l_package,20);
198: --
199: END limit_checks;
200:
201: ------------------------------------------------------------------------

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

238: l_lookups c_lookups%rowtype;
239: --
240: begin
241: --
242: hr_utility.set_location('Entering:'||l_proc, 5);
243: --
244: -- First clear old cache
245: --
246: g_cache_lookup_object.delete;

Line 252: hr_utility.set_location('open c_lookups: '||l_proc, 10);

248: -- Now load cache structure
249: --
250: open c_lookups;
251: --
252: hr_utility.set_location('open c_lookups: '||l_proc, 10);
253: --
254: loop
255: --
256: fetch c_lookups into l_lookups;

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

265: end loop;
266: --
267: close c_lookups;
268: --
269: hr_utility.set_location('Leaving:'||l_proc, 5);
270: --
271: end init_lookups;
272:
273: ------------------------------------------------------------------------

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

290: and pil.per_in_ler_stat_cd = 'STRTD';
291: --
292: begin
293: --
294: hr_utility.set_location('Entering:'||l_proc, 5);
295: --
296: open c_lf_evt_ocrd_dt;
297: --
298: fetch c_lf_evt_ocrd_dt into l_lf_evt_ocrd_dt;

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

298: fetch c_lf_evt_ocrd_dt into l_lf_evt_ocrd_dt;
299: --
300: close c_lf_evt_ocrd_dt;
301: --
302: hr_utility.set_location('Leaving:'||l_proc, 5);
303: --
304: return l_lf_evt_ocrd_dt;
305: --
306: end get_lf_evt_ocrd_dt;

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

332: ler.effective_start_date and ler.effective_end_date;
333: --
334: begin
335: --
336: hr_utility.set_location('Entering:'||l_proc, 5);
337: --
338: open c_per_in_ler_id;
339: --
340: fetch c_per_in_ler_id into l_per_in_ler_id;

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

340: fetch c_per_in_ler_id into l_per_in_ler_id;
341: --
342: close c_per_in_ler_id;
343: --
344: hr_utility.set_location('Leaving:'||l_proc, 5);
345: --
346: return l_per_in_ler_id;
347: --
348: end get_per_in_ler_id;

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

386: and ler.typ_cd = 'COMP';
387: --
388: begin
389: --
390: hr_utility.set_location('Entering:'||l_proc, 5);
391: --
392: open c_active_life_event;
393: --
394: fetch c_active_life_event into p_rec;

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

394: fetch c_active_life_event into p_rec;
395: --
396: close c_active_life_event;
397: --
398: hr_utility.set_location('Leaving:'||l_proc, 5);
399: --
400: end get_active_life_event;
401: -----------------------------------------------------------------------
402: -- get_per_in_ler_id

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

425: ler.effective_start_date and ler.effective_end_date;
426: --
427: begin
428: --
429: hr_utility.set_location('Entering:'||l_proc, 5);
430: --
431: open c_per_in_ler_id;
432: --
433: fetch c_per_in_ler_id into l_per_in_ler_id;

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

433: fetch c_per_in_ler_id into l_per_in_ler_id;
434: --
435: close c_per_in_ler_id;
436: --
437: hr_utility.set_location('Leaving:'||l_proc, 5);
438: return l_per_in_ler_id;
439: --
440: end get_per_in_ler_id;
441: ------------------------------------------------------------------------

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

475: and ler.typ_cd not in ('SCHEDDU', 'COMP', 'GSP', 'ABS', 'IREC');
476: --
477: begin
478: --
479: hr_utility.set_location('Entering:'||l_proc, 5);
480: --
481: open c_active_life_event;
482: --
483: fetch c_active_life_event into p_rec;

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

483: fetch c_active_life_event into p_rec;
484: --
485: close c_active_life_event;
486: --
487: hr_utility.set_location('Leaving:'||l_proc, 5);
488: --
489: end get_active_life_event;
490:
491: ------------------------------------------------------------------------

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

530: and pil.assignment_id = ben_manage_life_events.g_irec_ass_rec.assignment_id) ); -- iRec
531: --
532: begin
533: --
534: hr_utility.set_location('Entering:'||l_proc, 5);
535: --
536: open c_active_life_event;
537: --
538: fetch c_active_life_event into p_rec;

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

538: fetch c_active_life_event into p_rec;
539: --
540: close c_active_life_event;
541: --
542: hr_utility.set_location('Leaving:'||l_proc, 5);
543: --
544: end get_active_life_event;
545:
546:

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

566: and ler.effective_end_date;
567: --
568: begin
569: --
570: hr_utility.set_location('Entering:'||l_proc, 5);
571: --
572: open c_ler;
573: --
574: fetch c_ler into p_rec;

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

574: fetch c_ler into p_rec;
575: --
576: close c_ler;
577: --
578: hr_utility.set_location('Leaving:'||l_proc, 5);
579: --
580: end get_ler;
581: --
582: procedure get_ler(p_business_group_id in number,

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

603:
604: --
605: begin
606: --
607: hr_utility.set_location('Entering:'||l_proc, 5);
608: hr_utility.set_location('ACE p_typ_cd : ' || p_typ_cd, 5);
609: hr_utility.set_location('ACE p_lf_evt_oper_cd : ' || p_lf_evt_oper_cd, 5);
610: --
611: open c_ler;

Line 608: hr_utility.set_location('ACE p_typ_cd : ' || p_typ_cd, 5);

604: --
605: begin
606: --
607: hr_utility.set_location('Entering:'||l_proc, 5);
608: hr_utility.set_location('ACE p_typ_cd : ' || p_typ_cd, 5);
609: hr_utility.set_location('ACE p_lf_evt_oper_cd : ' || p_lf_evt_oper_cd, 5);
610: --
611: open c_ler;
612: --

Line 609: hr_utility.set_location('ACE p_lf_evt_oper_cd : ' || p_lf_evt_oper_cd, 5);

605: begin
606: --
607: hr_utility.set_location('Entering:'||l_proc, 5);
608: hr_utility.set_location('ACE p_typ_cd : ' || p_typ_cd, 5);
609: hr_utility.set_location('ACE p_lf_evt_oper_cd : ' || p_lf_evt_oper_cd, 5);
610: --
611: open c_ler;
612: --
613: fetch c_ler into p_rec;

Line 617: hr_utility.set_location('ACE p_rec.name : ' || p_rec.name, 5);

613: fetch c_ler into p_rec;
614: --
615: close c_ler;
616: --
617: hr_utility.set_location('ACE p_rec.name : ' || p_rec.name, 5);
618: hr_utility.set_location('Leaving:'||l_proc, 5);
619: --
620: end get_ler;
621:

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

614: --
615: close c_ler;
616: --
617: hr_utility.set_location('ACE p_rec.name : ' || p_rec.name, 5);
618: hr_utility.set_location('Leaving:'||l_proc, 5);
619: --
620: end get_ler;
621:
622: ------------------------------------------------------------------------

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

640: and ptn.lf_evt_ocrd_dt = p_effective_date;
641: --
642: begin
643: --
644: hr_utility.set_location('Leaving:'||l_proc, 5);
645: --
646: open c_ptnl;
647: --
648: fetch c_ptnl into p_rec;

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

648: fetch c_ptnl into p_rec;
649: --
650: close c_ptnl;
651: --
652: hr_utility.set_location('Leaving:'||l_proc, 5);
653: --
654: end get_ptnl_ler;
655:
656: ------------------------------------------------------------------------

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

695: -- bug 8431552
696: l_rec ben_env_object.g_global_env_rec_type;
697: begin
698: --
699: hr_utility.set_location('Entering:'||l_proc, 5);
700: ben_env_object.get(l_rec);
701: -- Perf changes
702: -- bug 8431552: Skip the security profile check for CWB mode
703: if (hr_security.view_all = 'Y' and hr_general.get_xbg_profile = 'Y') or (nvl(l_rec.mode_cd,hr_api.g_varchar2) = 'W')

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

714: --
715: close c_assignment;
716: end if;
717: --
718: hr_utility.set_location('Leaving:'||l_proc, 5);
719: --
720: return l_assignment_id;
721: --
722: end get_assignment_id;

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

730: l_proc varchar2(80) := 'benutils.not_exists_in_hr_lookups';
731: --
732: begin
733: --
734: hr_utility.set_location('Entering:'||l_proc, 5);
735: --
736: -- Check if lookup type and lookup code can be found in cache structure
737: --
738: for l_count in g_cache_lookup_object.first..g_cache_lookup_object.last loop

Line 743: hr_utility.set_location('Leaving:'||l_proc, 3);

739: --
740: if g_cache_lookup_object(l_count).lookup_type = p_lookup_type and
741: g_cache_lookup_object(l_count).lookup_code = p_lookup_code then
742: --
743: hr_utility.set_location('Leaving:'||l_proc, 3);
744: return false;
745: --
746: end if;
747: --

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

746: end if;
747: --
748: end loop;
749: --
750: hr_utility.set_location('Leaving:'||l_proc, 5);
751: return true;
752: --
753: end not_exists_in_hr_lookups;
754:

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

779: and ff.effective_end_date;
780: --
781: begin
782: --
783: hr_utility.set_location('Entering:'||l_proc, 5);
784: --
785: open c1;
786: --
787: fetch c1 into l_dummy;

Line 791: hr_utility.set_location('Leaving:'||l_proc, 3);

787: fetch c1 into l_dummy;
788: if c1%notfound then
789: --
790: close c1;
791: hr_utility.set_location('Leaving:'||l_proc, 3);
792: return false;
793: --
794: end if;
795: --

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

794: end if;
795: --
796: close c1;
797: --
798: hr_utility.set_location('Leaving:'||l_proc, 5);
799: return true;
800: --
801: end formula_exists;
802:

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

836: l_proc varchar2(80) := 'benutils.set_cache_record_position';
837: --
838: begin
839: --
840: hr_utility.set_location('Entering:'||l_proc, 5);
841:
842: -- Set '_count' parms to indicate the last global record written
843: -- to each global table for a particular person.
844:

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

852: g_batch_commu_table_count := nvl(g_batch_commu_table_object.count,0);
853:
854: ben_warnings.g_oab_warnings_count := nvl(ben_warnings.g_oab_warnings.count, 0);
855: --
856: hr_utility.set_location('Leaving:'||l_proc, 5);
857: --
858: end set_cache_record_position;
859:
860: ------------------------------------------------------------------------

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

864: --
865: l_proc varchar2(80) := 'benutils.rollback_cache';
866: --
867: begin
868: hr_utility.set_location('Entering:'||l_proc, 5);
869:
870: -- The '_count' parms are set in set_cache_record_position above each
871: -- time we finish with a person. It indicates the last record written
872: -- for a person.

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

928: (ben_warnings.g_oab_warnings.count-
929: ben_warnings.g_oab_warnings_count);
930: end if;
931:
932: hr_utility.set_location('Leaving:'||l_proc, 5);
933: end rollback_cache;
934: --
935: procedure clear_down_cache is
936: --

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

999: pragma exception_init(table_full,-1653);
1000: pragma exception_init(index_full,-1654);
1001: begin
1002: --
1003: hr_utility.set_location('Entering:'||l_proc, 5);
1004: --
1005: -- Loop through cache routine and write to ben_reporting table and
1006: -- to the output file
1007: --

Line 1011: hr_utility.set_location('Leaving:'||l_proc, 2);

1007: --
1008: if p_table = false and
1009: p_file = false then
1010: --
1011: hr_utility.set_location('Leaving:'||l_proc, 2);
1012: return;
1013: --
1014: end if;
1015:

Line 1115: hr_utility.set_location('BEN_REP Ins: '||l_proc, 6);

1111: end loop;
1112: --
1113: if p_table then
1114: --
1115: hr_utility.set_location('BEN_REP Ins: '||l_proc, 6);
1116: l_table_name := 'BEN_REPORTING';
1117: forall l_count in 1..l_num_recs
1118: insert into ben_reporting
1119: (reporting_id,

Line 1164: hr_utility.set_location('Dn BEN_REP Ins: '||l_proc, 7);

1160: l_num15_col(l_count),
1161: l_num16_col(l_count),
1162: l_num17_col(l_count),
1163: l_num18_col(l_count));
1164: hr_utility.set_location('Dn BEN_REP Ins: '||l_proc, 7);
1165: --
1166: end if;
1167: --
1168: g_report_table_object.delete;

Line 1173: hr_utility.set_location(l_proc||' Elig: ', 10);

1169: --
1170: end if;
1171: --
1172: --
1173: hr_utility.set_location(l_proc||' Elig: ', 10);
1174: if nvl(g_batch_elig_table_object.count,0) > 0 then
1175: --
1176: if p_table then
1177: --

Line 1263: hr_utility.set_location(l_proc||' Ler: ', 20);

1259: g_batch_elig_table_object.delete;
1260: --
1261: end if;
1262: --
1263: hr_utility.set_location(l_proc||' Ler: ', 20);
1264: if nvl(g_batch_ler_table_object.count,0) > 0 then
1265: --
1266: if p_table then
1267: --

Line 1409: hr_utility.set_location(l_proc||' Action: ', 30);

1405: g_batch_ler_table_object.delete;
1406: --
1407: end if;
1408: --
1409: hr_utility.set_location(l_proc||' Action: ', 30);
1410: if nvl(g_batch_action_table_object.count,0) > 0 then
1411: --
1412: if p_table then
1413: --

Line 1446: hr_utility.set_location(l_proc||' elctbl: ', 40);

1442: g_batch_action_table_object.delete;
1443: --
1444: end if;
1445: --
1446: hr_utility.set_location(l_proc||' elctbl: ', 40);
1447: if nvl(g_batch_elctbl_table_object.count,0) > 0 then
1448: --
1449: if p_table then
1450: --

Line 1572: hr_utility.set_location(l_proc||' rate: ', 50);

1568: g_batch_elctbl_table_object.delete;
1569: --
1570: end if;
1571: --
1572: hr_utility.set_location(l_proc||' rate: ', 50);
1573: if nvl(g_batch_rate_table_object.count,0) > 0 then
1574: --
1575: if p_table then
1576: --

Line 1602: hr_utility.set_location('batch rate'||l_num_recs,3333);

1598: l_dat3_col.delete;
1599: l_dat4_col.delete;
1600: l_num_recs := g_batch_rate_table_object.count;
1601: --
1602: hr_utility.set_location('batch rate'||l_num_recs,3333);
1603: for l_count in 1..l_num_recs loop
1604: --
1605: l_num1_col.extend(1);
1606: l_num1_col(l_count) :=

Line 1675: hr_utility.set_location(l_proc||' rate: ' ||

1671: l_num14_col.extend(1);
1672: l_num14_col(l_count) :=
1673: g_batch_rate_table_object(l_count).old_val;
1674: --
1675: hr_utility.set_location(l_proc||' rate: ' ||
1676: g_batch_rate_table_object(l_count).old_val, 1111);
1677: end loop;
1678: --
1679: l_table_name :='BEN_BATCH_RATE_INFO';

Line 1737: hr_utility.set_location(l_proc||' dpnt: ', 60);

1733: g_batch_rate_table_object.delete;
1734: --
1735: end if;
1736: --
1737: hr_utility.set_location(l_proc||' dpnt: ', 60);
1738: if nvl(g_batch_dpnt_table_object.count,0) > 0 then
1739: --
1740: if p_table then
1741: --

Line 1840: hr_utility.set_location(l_proc||' commu: ', 70);

1836: g_batch_dpnt_table_object.delete;
1837: --
1838: end if;
1839: --
1840: hr_utility.set_location(l_proc||' commu: ', 70);
1841: if nvl(g_batch_commu_table_object.count,0) > 0 then
1842: --
1843: if p_table then
1844: --

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

1915: g_batch_commu_table_object.delete;
1916: --
1917: end if;
1918: --
1919: hr_utility.set_location('Leaving:'||l_proc, 5);
1920: --
1921: exception
1922: when table_full then
1923: fnd_message.set_name('BEN','BEN_92651_LOG_TABLE_FULL');

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

1943: l_count number := 1;
1944: --
1945: begin
1946: --
1947: -- hr_utility.set_location('Entering:'||l_proc, 5);
1948: -- hr_utility.set_location(substr(p_rec.text,1,100),10);
1949: --
1950: g_sequence := g_sequence +1;
1951: --

Line 1948: -- hr_utility.set_location(substr(p_rec.text,1,100),10);

1944: --
1945: begin
1946: --
1947: -- hr_utility.set_location('Entering:'||l_proc, 5);
1948: -- hr_utility.set_location(substr(p_rec.text,1,100),10);
1949: --
1950: g_sequence := g_sequence +1;
1951: --
1952: g_report_table_object.extend(1);

Line 1986: -- hr_utility.set_location('Leaving:'||l_proc, 40);

1982: -- Reset p_rec to null
1983: --
1984: p_rec := l_rec;
1985: --
1986: -- hr_utility.set_location('Leaving:'||l_proc, 40);
1987: --
1988: end write;
1989: ------------------------------------------------------------------------
1990: -- get_batch_parameters

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

2044: where benefit_action_id = p_benefit_action_id;
2045: --
2046: begin
2047: --
2048: hr_utility.set_location('Entering:'||l_proc, 5);
2049: --
2050: if not g_batch_param_table_object.exists(1) then
2051: --
2052: open c1;

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

2069: p_rec := g_batch_param_table_object(1); /* Bug 5009662 */
2070: --
2071: end if;
2072: --
2073: hr_utility.set_location('Leaving:'||l_proc, 5);
2074: --
2075: end get_batch_parameters;
2076:
2077: ------------------------------------------------------------------------

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

2088: l_params g_batch_param_rec;
2089: --
2090: begin
2091: --
2092: -- hr_utility.set_location('Entering:'||l_proc, 5);
2093: --
2094: if g_benefit_action_id is null then
2095: return;
2096: end if;

Line 2103: -- hr_utility.set_location('Leaving:'||l_proc, 4);

2099: p_rec => l_params);
2100: --
2101: if l_params.audit_log_flag <> 'Y' then
2102: --
2103: -- hr_utility.set_location('Leaving:'||l_proc, 4);
2104: return;
2105: --
2106: end if;
2107: --

Line 2144: -- hr_utility.set_location('Leaving:'||l_proc, 40);

2140: -- Reset p_rec to null
2141: --
2142: p_rec := l_rec;
2143: --
2144: -- hr_utility.set_location('Leaving:'||l_proc, 40);
2145: --
2146: end write;
2147: --
2148: procedure write(p_rec in out nocopy ben_type.g_batch_action_rec) is

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

2152: l_count number := 1;
2153: --
2154: begin
2155: --
2156: -- hr_utility.set_location('Entering:'||l_proc, 5);
2157: --
2158: g_batch_action_table_object.extend(1);
2159: l_count := g_batch_action_table_object.count;
2160: --

Line 2171: -- hr_utility.set_location('Leaving:'||l_proc, 40);

2167: -- Reset p_rec to null
2168: --
2169: p_rec := l_rec;
2170: --
2171: -- hr_utility.set_location('Leaving:'||l_proc, 40);
2172: --
2173: end write;
2174: --
2175: procedure write(p_rec in out nocopy g_batch_elctbl_rec) is

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

2180: l_params g_batch_param_rec;
2181: --
2182: begin
2183: --
2184: -- hr_utility.set_location('Entering:'||l_proc, 5);
2185: --
2186: if g_benefit_action_id is null then
2187: return;
2188: end if;

Line 2194: -- hr_utility.set_location('Leaving:'||l_proc, 3);

2190: get_batch_parameters(p_benefit_action_id => g_benefit_action_id,
2191: p_rec => l_params);
2192: --
2193: if l_params.audit_log_flag <> 'Y' then
2194: -- hr_utility.set_location('Leaving:'||l_proc, 3);
2195: --
2196: return;
2197: --
2198: end if;

Line 2229: -- hr_utility.set_location('Leaving:'||l_proc, 40);

2225: -- Reset p_rec to null
2226: --
2227: p_rec := l_rec;
2228: --
2229: -- hr_utility.set_location('Leaving:'||l_proc, 40);
2230: --
2231: end write;
2232: --
2233: procedure write(p_rec in out nocopy g_batch_rate_rec) is

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

2238: l_params g_batch_param_rec;
2239: --
2240: begin
2241: --
2242: -- hr_utility.set_location('Entering:'||l_proc, 5);
2243: --
2244: if g_benefit_action_id is null then
2245: return;
2246: end if;

Line 2253: -- hr_utility.set_location('Entering:'||l_proc, 3);

2249: p_rec => l_params);
2250: --
2251: if l_params.audit_log_flag <> 'Y' then
2252: --
2253: -- hr_utility.set_location('Entering:'||l_proc, 3);
2254: return;
2255: --
2256: end if;
2257: --

Line 2258: -- hr_utility.set_location('Writing Rate Record:'||l_proc, 5);

2254: return;
2255: --
2256: end if;
2257: --
2258: -- hr_utility.set_location('Writing Rate Record:'||l_proc, 5);
2259: --
2260: g_batch_rate_table_object.extend(1);
2261: l_count := g_batch_rate_table_object.count;
2262: select ben_batch_rate_info_s.nextval into

Line 2294: -- hr_utility.set_location('Leaving:'||l_proc, 40);

2290: -- Reset p_rec to null
2291: --
2292: p_rec := l_rec;
2293: --
2294: -- hr_utility.set_location('Leaving:'||l_proc, 40);
2295: -- hr_utility.set_location('Number of Rate Records:'||g_batch_rate_table_object.count,5);
2296: --
2297: end write;
2298: --

Line 2295: -- hr_utility.set_location('Number of Rate Records:'||g_batch_rate_table_object.count,5);

2291: --
2292: p_rec := l_rec;
2293: --
2294: -- hr_utility.set_location('Leaving:'||l_proc, 40);
2295: -- hr_utility.set_location('Number of Rate Records:'||g_batch_rate_table_object.count,5);
2296: --
2297: end write;
2298: --
2299: procedure write(p_rec in out nocopy g_batch_dpnt_rec) is

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

2304: l_params g_batch_param_rec;
2305: --
2306: begin
2307: --
2308: -- hr_utility.set_location('Entering:'||l_proc, 5);
2309: --
2310: if g_benefit_action_id is null then
2311: return;
2312: end if;

Line 2319: -- hr_utility.set_location('Leaving:'||l_proc, 3);

2315: p_rec => l_params);
2316: --
2317: if l_params.audit_log_flag <> 'Y' then
2318: --
2319: -- hr_utility.set_location('Leaving:'||l_proc, 3);
2320: return;
2321: --
2322: end if;
2323: --

Line 2349: -- hr_utility.set_location('Leaving:'||l_proc, 40);

2345: -- Reset p_rec to null
2346: --
2347: p_rec := l_rec;
2348: --
2349: -- hr_utility.set_location('Leaving:'||l_proc, 40);
2350: --
2351: end write;
2352: --
2353: procedure write(p_rec in out nocopy ben_type.g_batch_commu_rec) is

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

2357: l_count number := 1;
2358: --
2359: begin
2360: --
2361: -- hr_utility.set_location('Entering:'||l_proc, 5);
2362: --
2363: g_batch_commu_table_object.extend(1);
2364: l_count := g_batch_commu_table_object.count;
2365: select ben_batch_commu_info_s.nextval into

Line 2382: -- hr_utility.set_location('Leaving:'||l_proc, 40);

2378: -- Reset p_rec to null
2379: --
2380: p_rec := l_rec;
2381: --
2382: -- hr_utility.set_location('Leaving:'||l_proc, 40);
2383: --
2384: end write;
2385: --
2386: procedure write(p_rec in out nocopy g_batch_ler_rec) is

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

2393: l_params g_batch_param_rec;
2394: --
2395: begin
2396: --
2397: -- hr_utility.set_location('Entering:'||l_proc, 5);
2398: --
2399: g_batch_ler_table_object.extend(1);
2400: l_count := g_batch_ler_table_object.count;
2401: select ben_batch_ler_info_s.nextval into

Line 2430: -- hr_utility.set_location('Leaving:'||l_proc, 40);

2426: -- Reset p_rec to null
2427: --
2428: p_rec := l_rec;
2429: --
2430: -- hr_utility.set_location('Leaving:'||l_proc, 40);
2431: --
2432: end write;
2433: --
2434: procedure write(p_rec in out nocopy ben_type.g_batch_proc_rec) is

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

2440: l_count number := 1;
2441: --
2442: begin
2443: --
2444: -- hr_utility.set_location('Entering:'||l_proc, 5);
2445: --
2446: ben_batch_proc_info_api.create_batch_proc_info
2447: (p_validate => false
2448: ,p_batch_proc_id => l_batch_proc_id

Line 2467: -- hr_utility.set_location('Leaving:'||l_proc, 40);

2463: -- Reset p_rec to null
2464: --
2465: p_rec := l_rec;
2466: --
2467: -- hr_utility.set_location('Leaving:'||l_proc, 40);
2468: --
2469: end write;
2470: --
2471: procedure write(p_text in varchar2,

Line 2500: -- hr_utility.set_location('Leaving:'||l_proc, 4);

2496: then
2497: --
2498: -- Assume no logging required
2499: --
2500: -- hr_utility.set_location('Leaving:'||l_proc, 4);
2501: return;
2502: --
2503: end if;
2504: --

Line 2507: -- hr_utility.set_location('Report Varray:'||l_proc, 5);

2503: end if;
2504: --
2505: g_sequence := g_sequence +1;
2506: --
2507: -- hr_utility.set_location('Report Varray:'||l_proc, 5);
2508: g_report_table_object.extend(1);
2509: l_count := g_report_table_object.count;
2510: /*
2511: select ben_reporting_s.nextval into

Line 2538: -- hr_utility.set_location('Leaving:'||l_proc, 40);

2534: g_report_table_object(l_count).val := null;
2535: g_report_table_object(l_count).mo_num := null;
2536: g_report_table_object(l_count).yr_num := null;
2537: --
2538: -- hr_utility.set_location('Leaving:'||l_proc, 40);
2539: --
2540: end write;
2541:
2542: ------------------------------------------------------------------------

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

2548: l_proc varchar2(80) := 'benutils.update_life_event_cache';
2549: --
2550: begin
2551: --
2552: hr_utility.set_location('Entering:'||l_proc, 5);
2553: --
2554: -- Special case where we have to update the open_and_clsd_flag if the
2555: -- life event was created and not replaced
2556: --

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

2572: end if;
2573: --
2574: end if;
2575: --
2576: hr_utility.set_location('Entering:'||l_proc, 5);
2577: --
2578: end update_life_event_cache;
2579:
2580: ------------------------------------------------------------------------

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

2598: and bbp.business_group_id = p_business_group_id;
2599: --
2600: begin
2601: --
2602: hr_utility.set_location('Entering:'||l_proc, 5);
2603: --
2604: open c1;
2605: --
2606: fetch c1 into p_threads,

Line 2629: hr_utility.set_location(l_proc||'p_threads : '||p_threads, 5);

2625: end if;
2626: --
2627: close c1;
2628: --
2629: hr_utility.set_location(l_proc||'p_threads : '||p_threads, 5);
2630: hr_utility.set_location('Leaving:'||l_proc, 5);
2631: --
2632: end get_parameter;
2633:

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

2626: --
2627: close c1;
2628: --
2629: hr_utility.set_location(l_proc||'p_threads : '||p_threads, 5);
2630: hr_utility.set_location('Leaving:'||l_proc, 5);
2631: --
2632: end get_parameter;
2633:
2634: ------------------------------------------------------------------------

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

2641: l_proc varchar2(80) := 'benutils.iftrue';
2642: --
2643: begin
2644: --
2645: hr_utility.set_location('Entering:'||l_proc, 5);
2646: --
2647: if p_expression then
2648: --
2649: --hr_utility.set_location('Leaving:'||l_proc, 4);

Line 2649: --hr_utility.set_location('Leaving:'||l_proc, 4);

2645: hr_utility.set_location('Entering:'||l_proc, 5);
2646: --
2647: if p_expression then
2648: --
2649: --hr_utility.set_location('Leaving:'||l_proc, 4);
2650: return p_true;
2651: --
2652: else
2653: --

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

2650: return p_true;
2651: --
2652: else
2653: --
2654: --hr_utility.set_location('Leaving:'||l_proc, 5);
2655: return p_false;
2656: --
2657: end if;
2658: --

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

2667: l_proc varchar2(80) := 'benutils.zero_to_null';
2668: --
2669: begin
2670: --
2671: --hr_utility.set_location('Entering:'||l_proc, 5);
2672: --
2673: l_value := iftrue(p_expression => p_value = 0,
2674: p_true => null,
2675: p_false => p_value);

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

2673: l_value := iftrue(p_expression => p_value = 0,
2674: p_true => null,
2675: p_false => p_value);
2676: --
2677: --hr_utility.set_location('Leaving:'||l_proc, 5);
2678: return l_value;
2679: --
2680: --
2681: end zero_to_null;

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

2703: l_proc varchar2(80) := 'benutils.get_bp_name';
2704: --
2705: begin
2706: --
2707: hr_utility.set_location('Entering:'||l_proc, 5);
2708: --
2709: -- Bug 3431740 Parameter l_oracle_schema added to cursor c1, the value is got by the
2710: -- following call
2711: l_return := fnd_installation.get_app_info(application_short_name => l_application_short_name,

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

2735: l_comments := 'BP_NOT_FOUND';
2736: --
2737: end if;
2738: --
2739: hr_utility.set_location('Leaving:'||l_proc, 5);
2740: return l_comments;
2741: --
2742: --
2743: end get_bp_name;

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

2750: l_proc varchar2(80) := 'benutils.part_of_pkey';
2751: --
2752: begin
2753: --
2754: --hr_utility.set_location('Entering:'||l_proc, 5);
2755: --
2756: -- Check if a column is part of the Primary Key
2757: --
2758: for l_counter in 1..g_primary_key_count loop

Line 2762: --hr_utility.set_location('Leaving:'||l_proc, 3);

2758: for l_counter in 1..g_primary_key_count loop
2759: --
2760: if p_column_name = g_part_of_pkey(l_counter) then
2761: --
2762: --hr_utility.set_location('Leaving:'||l_proc, 3);
2763: return true;
2764: --
2765: end if;
2766: --

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

2765: end if;
2766: --
2767: end loop;
2768: --
2769: --hr_utility.set_location('Leaving:'||l_proc, 5);
2770: return false;
2771: --
2772: end part_of_pkey;
2773:

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

2829: l_proc varchar2(80) := 'benutils.define_primary_key';
2830: --
2831: begin
2832: --
2833: hr_utility.set_location('Entering:'||l_proc, 5);
2834: --
2835: -- Get the column if is part of the primary key.
2836: --
2837: -- Bug 3431740 Parameter l_oracle_schema added to cursor c1, the value is got by the

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

2860: close c1;
2861: --
2862: g_primary_key_count := l_number_of_columns;
2863: --
2864: hr_utility.set_location('Leaving:'||l_proc, 5);
2865: --
2866: end define_primary_key;
2867:
2868: ------------------------------------------------------------------------

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

2906: l_proc varchar2(80) := 'benutils.lookups_exist';
2907: --
2908: begin
2909: --
2910: --hr_utility.set_location('Entering:'||l_proc, 5);
2911: --
2912: -- Bug 3431740 Parameter l_oracle_schema added to cursor c1, the value is got by the
2913: -- following call
2914: l_return := fnd_installation.get_app_info(application_short_name => l_application_short_name,

Line 2924: --hr_utility.set_location('Leaving:'||l_proc, 3);

2920: fetch c1 into l_dummy;
2921: if c1%found then
2922: --
2923: close c1;
2924: --hr_utility.set_location('Leaving:'||l_proc, 3);
2925: return true;
2926: --
2927: end if;
2928: --

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

2927: end if;
2928: --
2929: close c1;
2930: --
2931: --hr_utility.set_location('Leaving:'||l_proc, 5);
2932: return false;
2933: --
2934: end lookups_exist;
2935:

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

2983: --
2984: -- Bug 15876152 end
2985: begin
2986: --
2987: --hr_utility.set_location('Entering:'||l_proc, 5);
2988: --
2989: -- Get the Primary Key for the table.
2990: --
2991: -- Bug 3431740 Parameter l_oracle_schema added to cursor c1, the value is got by the

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

3000: fetch c1 into l_primary_key;
3001: --
3002: close c1;
3003: --
3004: --hr_utility.set_location('Leaving:'||l_proc, 5);
3005: return l_primary_key;
3006: --
3007: end get_primary_key;
3008:

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

3038: l_proc varchar2(80) := 'benutils.business_group_exists';
3039: --
3040: begin
3041: --
3042: --hr_utility.set_location('Entering:'||l_proc, 5);
3043: --
3044: -- Bug 3431740 Parameter l_oracle_schema added to cursor c1, the value is got by the
3045: -- following call
3046: l_return := fnd_installation.get_app_info(application_short_name => l_application_short_name,

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

3059: end if;
3060: --
3061: close c1;
3062: --
3063: --hr_utility.set_location('Leaving:'||l_proc, 5);
3064: return l_result;
3065: --
3066: end business_group_exists;
3067:

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

3073: l_proc varchar2(80) := 'benutils.table_datetracked';
3074: --
3075: begin
3076: --
3077: --hr_utility.set_location('Entering:'||l_proc, 5);
3078: --
3079: if substr(p_tablename,length(p_tablename)-1,2) = '_F' then
3080: --hr_utility.set_location('Leaving:'||l_proc, 3);
3081: return true;

Line 3080: --hr_utility.set_location('Leaving:'||l_proc, 3);

3076: --
3077: --hr_utility.set_location('Entering:'||l_proc, 5);
3078: --
3079: if substr(p_tablename,length(p_tablename)-1,2) = '_F' then
3080: --hr_utility.set_location('Leaving:'||l_proc, 3);
3081: return true;
3082: else
3083: --hr_utility.set_location('Leaving:'||l_proc, 5);
3084: return false;

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

3079: if substr(p_tablename,length(p_tablename)-1,2) = '_F' then
3080: --hr_utility.set_location('Leaving:'||l_proc, 3);
3081: return true;
3082: else
3083: --hr_utility.set_location('Leaving:'||l_proc, 5);
3084: return false;
3085: end if;
3086: --
3087: end table_datetracked;

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

3119: l_proc varchar2(80) := 'benutils.attributes_exist';
3120: --
3121: begin
3122: --
3123: --hr_utility.set_location('Entering:'||l_proc, 5);
3124: --
3125: -- See if attributes exist for the table
3126: --
3127: -- Bug 3431740 Parameter l_oracle_schema added to cursor c1, the value is got by the

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

3141: end if;
3142: --
3143: close c1;
3144: --
3145: --hr_utility.set_location('Leaving:'||l_proc, 5);
3146: return l_found;
3147: --
3148: end attributes_exist;
3149:

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

3169: l_proc varchar2(80) := 'benutils.get_pk_constraint_name';
3170: --
3171: begin
3172: --
3173: --hr_utility.set_location('Entering:'||l_proc, 5);
3174: --
3175: -- get the Primary Key constraint name for the table
3176: --
3177: -- Bug 3431740 Parameter l_oracle_schema added to cursor c1, the value is got by the

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

3186: fetch c1 into l_constraint_name;
3187: --
3188: close c1;
3189: --
3190: --hr_utility.set_location('Leaving:'||l_proc, 5);
3191: return l_constraint_name;
3192: --
3193: end get_pk_constraint_name;
3194: --

Line 3203: hr_utility.set_location('FALSE',10);

3199: if ((p_new_column = p_old_column)
3200: OR ((p_old_column IS NULL)
3201: AND (p_new_column IS NULL)))
3202: then
3203: hr_utility.set_location('FALSE',10);
3204: return FALSE;
3205: --
3206: -- Value MUST have changed
3207: -- so if any value chosen return true

Line 3212: hr_utility.set_location('TRUE',10);

3208: -- elsif specific value test for it
3209: -- being new value.
3210: elsif p_new_value = 'OABANY'
3211: then
3212: hr_utility.set_location('TRUE',10);
3213: return TRUE;
3214: elsif ((p_new_value = 'NULL')
3215: AND (p_new_column IS NULL)
3216: )

Line 3218: hr_utility.set_location('TRUE',10);

3214: elsif ((p_new_value = 'NULL')
3215: AND (p_new_column IS NULL)
3216: )
3217: then
3218: hr_utility.set_location('TRUE',10);
3219: return TRUE;
3220: elsif ((p_new_value = 'NULL')
3221: AND (p_new_column IS NOT NULL))
3222: then

Line 3223: hr_utility.set_location('FALSE',10);

3219: return TRUE;
3220: elsif ((p_new_value = 'NULL')
3221: AND (p_new_column IS NOT NULL))
3222: then
3223: hr_utility.set_location('FALSE',10);
3224: return FALSE;
3225: elsif ((p_new_column IS NOT NULL)
3226: AND (p_new_column = p_new_value)
3227: )

Line 3229: hr_utility.set_location('TRUE',10);

3225: elsif ((p_new_column IS NOT NULL)
3226: AND (p_new_column = p_new_value)
3227: )
3228: then
3229: hr_utility.set_location('TRUE',10);
3230: return TRUE;
3231: end if;
3232: hr_utility.set_location('FALSE',10);
3233: return FALSE;

Line 3232: hr_utility.set_location('FALSE',10);

3228: then
3229: hr_utility.set_location('TRUE',10);
3230: return TRUE;
3231: end if;
3232: hr_utility.set_location('FALSE',10);
3233: return FALSE;
3234: end;
3235:
3236: ------------------------------------------------------------------------

Line 3243: hr_utility.set_location('In routine',10);

3239: function column_changed(p_old_column in date
3240: ,p_new_column in date
3241: ,p_new_value in varchar2) return boolean is
3242: begin
3243: hr_utility.set_location('In routine',10);
3244: if ((p_new_column = p_old_column)
3245: OR ((p_old_column IS NULL)
3246: AND (p_new_column IS NULL)))
3247: then

Line 3248: hr_utility.set_location('FALSE1',10);

3244: if ((p_new_column = p_old_column)
3245: OR ((p_old_column IS NULL)
3246: AND (p_new_column IS NULL)))
3247: then
3248: hr_utility.set_location('FALSE1',10);
3249: return FALSE;
3250: --
3251: -- Value MUST have changed
3252: -- so if any value chosen return true

Line 3263: hr_utility.set_location('FALSE2',10);

3259: -- Bug#2001857-null value must be treated differently as the condition above checks
3260: -- and both the values are null then false is returnedi-null condition masked
3261: if p_new_column = hr_api.g_eot then
3262: -- or p_new_column is null then
3263: hr_utility.set_location('FALSE2',10);
3264: return FALSE;
3265: else
3266: hr_utility.set_location('TRUE3',10);
3267: return TRUE;

Line 3266: hr_utility.set_location('TRUE3',10);

3262: -- or p_new_column is null then
3263: hr_utility.set_location('FALSE2',10);
3264: return FALSE;
3265: else
3266: hr_utility.set_location('TRUE3',10);
3267: return TRUE;
3268: end if;
3269: elsif ((p_new_value = 'NULL')
3270: AND (p_new_column IS NULL or

Line 3275: hr_utility.set_location('TRUE4',10);

3271: p_new_column = hr_api.g_eot)
3272: )
3273: then
3274: -- Bug 1167017, treat eot as null
3275: hr_utility.set_location('TRUE4',10);
3276: return TRUE;
3277: elsif ((p_new_value = 'NULL')
3278: AND (p_new_column IS NOT NULL) and
3279: p_new_column <> hr_api.g_eot)

Line 3281: hr_utility.set_location('FALSE5',10);

3277: elsif ((p_new_value = 'NULL')
3278: AND (p_new_column IS NOT NULL) and
3279: p_new_column <> hr_api.g_eot)
3280: then
3281: hr_utility.set_location('FALSE5',10);
3282: return FALSE;
3283: elsif p_new_value = 'ENDTM' and p_new_column = hr_api.g_eot then
3284: hr_utility.set_location('TRUE5',10);
3285: return true;

Line 3284: hr_utility.set_location('TRUE5',10);

3280: then
3281: hr_utility.set_location('FALSE5',10);
3282: return FALSE;
3283: elsif p_new_value = 'ENDTM' and p_new_column = hr_api.g_eot then
3284: hr_utility.set_location('TRUE5',10);
3285: return true;
3286: elsif ((p_new_column IS NOT NULL)
3287: AND (to_char(p_new_column) = p_new_value)
3288: )

Line 3290: hr_utility.set_location('TRUE6',10);

3286: elsif ((p_new_column IS NOT NULL)
3287: AND (to_char(p_new_column) = p_new_value)
3288: )
3289: then
3290: hr_utility.set_location('TRUE6',10);
3291: return TRUE;
3292: end if;
3293: hr_utility.set_location('FALSE7',10);
3294: return FALSE;

Line 3293: hr_utility.set_location('FALSE7',10);

3289: then
3290: hr_utility.set_location('TRUE6',10);
3291: return TRUE;
3292: end if;
3293: hr_utility.set_location('FALSE7',10);
3294: return FALSE;
3295: end;
3296: --
3297: function column_changed(p_old_column in number

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

3352: l_outputs ff_exec.outputs_t;
3353: --
3354: Begin
3355: --
3356: hr_utility.set_location('Entering:'||l_proc, 5);
3357: --
3358: if p_rounding_cd is null then
3359: --
3360: l_result := p_value;

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

3357: --
3358: if p_rounding_cd is null then
3359: --
3360: l_result := p_value;
3361: hr_utility.set_location('Leaving:'||l_proc, 5);
3362: return l_result;
3363: --
3364: elsif p_rounding_cd = 'RL' then
3365: --

Line 3490: hr_utility.set_location('p_value:'||to_char(l_value), 5);

3486: l_result:=l_value-l_modulus+l_rndg_fctr;
3487: --
3488: elsif l_rndg_type = 'DOWN' then
3489: --
3490: hr_utility.set_location('p_value:'||to_char(l_value), 5);
3491: hr_utility.set_location('l_modulus:'||to_char(l_modulus), 5);
3492: l_result:=l_value-l_modulus;
3493: hr_utility.set_location('l_result:'||l_result, 5);
3494: --

Line 3491: hr_utility.set_location('l_modulus:'||to_char(l_modulus), 5);

3487: --
3488: elsif l_rndg_type = 'DOWN' then
3489: --
3490: hr_utility.set_location('p_value:'||to_char(l_value), 5);
3491: hr_utility.set_location('l_modulus:'||to_char(l_modulus), 5);
3492: l_result:=l_value-l_modulus;
3493: hr_utility.set_location('l_result:'||l_result, 5);
3494: --
3495: else

Line 3493: hr_utility.set_location('l_result:'||l_result, 5);

3489: --
3490: hr_utility.set_location('p_value:'||to_char(l_value), 5);
3491: hr_utility.set_location('l_modulus:'||to_char(l_modulus), 5);
3492: l_result:=l_value-l_modulus;
3493: hr_utility.set_location('l_result:'||l_result, 5);
3494: --
3495: else
3496: --
3497: -- go for nearest

Line 3522: hr_utility.set_location(' negetive value ' || l_result, 199 );

3518:
3519: ---bug 2083228
3520: if l_val_chg_flag = 'Y' then
3521: l_result:=l_result * -1 ;
3522: hr_utility.set_location(' negetive value ' || l_result, 199 );
3523: end if ;
3524: --
3525: hr_utility.set_location('Leaving:'||l_proc, 99);
3526: return l_result;

Line 3525: hr_utility.set_location('Leaving:'||l_proc, 99);

3521: l_result:=l_result * -1 ;
3522: hr_utility.set_location(' negetive value ' || l_result, 199 );
3523: end if ;
3524: --
3525: hr_utility.set_location('Leaving:'||l_proc, 99);
3526: return l_result;
3527: --
3528: end do_rounding;
3529:

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

3543: l_fractional number;
3544: --
3545: begin
3546: --
3547: hr_utility.set_location('Entering:'||l_proc, 5);
3548: hr_utility.set_location(' P_VALUE ' || p_value, 926);
3549: hr_utility.set_location(' P_max ' || p_max, 926);
3550: if p_value = 'LT_MIN' or
3551: p_value = 'GT_MIN' then

Line 3548: hr_utility.set_location(' P_VALUE ' || p_value, 926);

3544: --
3545: begin
3546: --
3547: hr_utility.set_location('Entering:'||l_proc, 5);
3548: hr_utility.set_location(' P_VALUE ' || p_value, 926);
3549: hr_utility.set_location(' P_max ' || p_max, 926);
3550: if p_value = 'LT_MIN' or
3551: p_value = 'GT_MIN' then
3552: --

Line 3549: hr_utility.set_location(' P_max ' || p_max, 926);

3545: begin
3546: --
3547: hr_utility.set_location('Entering:'||l_proc, 5);
3548: hr_utility.set_location(' P_VALUE ' || p_value, 926);
3549: hr_utility.set_location(' P_max ' || p_max, 926);
3550: if p_value = 'LT_MIN' or
3551: p_value = 'GT_MIN' then
3552: --
3553: l_val := p_min;

Line 3595: hr_utility.set_location( p_value||' '||l_val, 926);

3591: l_val := p_max ;
3592: --
3593: end if;
3594: --
3595: hr_utility.set_location( p_value||' '||l_val, 926);
3596: if p_uom = 'YR' then
3597: --
3598: l_value := add_months(p_date,l_val*12);
3599: --bug#4156125 - the add_months function takes only integer to add months

Line 3649: hr_utility.set_location(' calcualted return ' || l_value, 926);

3645: raise ben_manage_life_events.g_record_error;
3646: --
3647: end if;
3648: --
3649: hr_utility.set_location(' calcualted return ' || l_value, 926);
3650: hr_utility.set_location('Leaving:'||l_proc, 99);
3651: return l_value;
3652: --
3653: end derive_date;

Line 3650: hr_utility.set_location('Leaving:'||l_proc, 99);

3646: --
3647: end if;
3648: --
3649: hr_utility.set_location(' calcualted return ' || l_value, 926);
3650: hr_utility.set_location('Leaving:'||l_proc, 99);
3651: return l_value;
3652: --
3653: end derive_date;
3654:

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

3663: l_proc varchar2(72) := 'benutils.do_uom';
3664: --
3665: begin
3666: --
3667: hr_utility.set_location('Entering:'||l_proc, 5);
3668: --
3669: -- Calculate details based on UOM
3670: --
3671: -- All values expressed as days

Line 3711: hr_utility.set_location('BEN_91342_UNKNOWN_CODE_1', 99);

3707: else
3708: --
3709: -- Defensive programming
3710: --
3711: hr_utility.set_location('BEN_91342_UNKNOWN_CODE_1', 99);
3712: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
3713: fnd_message.set_token('PROC',l_proc);
3714: fnd_message.set_token('CODE1',p_uom);
3715: raise ben_manage_life_events.g_record_error;

Line 3719: hr_utility.set_location('Leaving:'||l_proc, 99);

3715: raise ben_manage_life_events.g_record_error;
3716: --
3717: end if;
3718: --
3719: hr_utility.set_location('Leaving:'||l_proc, 99);
3720: return l_value;
3721: --
3722: end do_uom;
3723:

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

3730: l_proc varchar2(80) := 'benutils.id';
3731: --
3732: begin
3733: --
3734: hr_utility.set_location('Entering:'||l_proc, 5);
3735: --
3736: if p_value is null then
3737: --
3738: hr_utility.set_location('Leaving:'||l_proc, 3);

Line 3738: hr_utility.set_location('Leaving:'||l_proc, 3);

3734: hr_utility.set_location('Entering:'||l_proc, 5);
3735: --
3736: if p_value is null then
3737: --
3738: hr_utility.set_location('Leaving:'||l_proc, 3);
3739: return null;
3740: --
3741: end if;
3742: --

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

3741: end if;
3742: --
3743: l_value := ' ('||p_value||')';
3744: --
3745: hr_utility.set_location('Leaving:'||l_proc, 5);
3746: return l_value;
3747: --
3748: end id;
3749:

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

3769: l_new_value number := p_new_value ;
3770: --
3771: begin
3772: --
3773: -- hr_utility.set_location ('Entering '||l_package,10);
3774: -- hr_utility.set_location ('Min '||p_min_value,10);
3775: -- hr_utility.set_location ('Max '||p_max_value,10);
3776: -- hr_utility.set_location ('Old Value '||p_old_value,10);
3777: -- hr_utility.set_location ('New Value '||p_new_value,10);

Line 3774: -- hr_utility.set_location ('Min '||p_min_value,10);

3770: --
3771: begin
3772: --
3773: -- hr_utility.set_location ('Entering '||l_package,10);
3774: -- hr_utility.set_location ('Min '||p_min_value,10);
3775: -- hr_utility.set_location ('Max '||p_max_value,10);
3776: -- hr_utility.set_location ('Old Value '||p_old_value,10);
3777: -- hr_utility.set_location ('New Value '||p_new_value,10);
3778: --

Line 3775: -- hr_utility.set_location ('Max '||p_max_value,10);

3771: begin
3772: --
3773: -- hr_utility.set_location ('Entering '||l_package,10);
3774: -- hr_utility.set_location ('Min '||p_min_value,10);
3775: -- hr_utility.set_location ('Max '||p_max_value,10);
3776: -- hr_utility.set_location ('Old Value '||p_old_value,10);
3777: -- hr_utility.set_location ('New Value '||p_new_value,10);
3778: --
3779: p_break := 'NONE';

Line 3776: -- hr_utility.set_location ('Old Value '||p_old_value,10);

3772: --
3773: -- hr_utility.set_location ('Entering '||l_package,10);
3774: -- hr_utility.set_location ('Min '||p_min_value,10);
3775: -- hr_utility.set_location ('Max '||p_max_value,10);
3776: -- hr_utility.set_location ('Old Value '||p_old_value,10);
3777: -- hr_utility.set_location ('New Value '||p_new_value,10);
3778: --
3779: p_break := 'NONE';
3780: --

Line 3777: -- hr_utility.set_location ('New Value '||p_new_value,10);

3773: -- hr_utility.set_location ('Entering '||l_package,10);
3774: -- hr_utility.set_location ('Min '||p_min_value,10);
3775: -- hr_utility.set_location ('Max '||p_max_value,10);
3776: -- hr_utility.set_location ('Old Value '||p_old_value,10);
3777: -- hr_utility.set_location ('New Value '||p_new_value,10);
3778: --
3779: p_break := 'NONE';
3780: --
3781: if p_min_value is null then

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

3924: end if;
3925: --
3926: end if;
3927: --
3928: -- hr_utility.set_location ('Leaving '||l_package,10);
3929: --
3930: return l_return;
3931: --
3932: end min_max_breach;

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

3940: l_package varchar2(80) := 'benutils.eot_to_null';
3941: --
3942: begin
3943: --
3944: hr_utility.set_location ('Entering '||l_package,10);
3945: --
3946: if p_date = hr_api.g_eot then
3947: --
3948: l_date := null;

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

3952: l_date := p_date;
3953: --
3954: end if;
3955: --
3956: hr_utility.set_location ('Leaving '||l_package,10);
3957: return(l_date);
3958: --
3959: end eot_to_null;
3960: --

Line 3968: hr_utility.set_location ('Entering '||l_package,5);

3964: l_package varchar2(80) := 'benutils.eot_to_null';
3965: --
3966: begin
3967: --
3968: hr_utility.set_location ('Entering '||l_package,5);
3969: --
3970: l_date := benutils.eot_to_null(to_date(p_date,'DD/MM/YYYY'));
3971: --
3972: hr_utility.set_location ('Leaving '||l_package,5);

Line 3972: hr_utility.set_location ('Leaving '||l_package,5);

3968: hr_utility.set_location ('Entering '||l_package,5);
3969: --
3970: l_date := benutils.eot_to_null(to_date(p_date,'DD/MM/YYYY'));
3971: --
3972: hr_utility.set_location ('Leaving '||l_package,5);
3973: return(to_char(l_date,'DD/MM/YYYY'));
3974: --
3975: end eot_to_null;
3976: --

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

4004: l_months number := 12;
4005: --
4006: begin
4007: --
4008: hr_utility.set_location ('Entering '||l_package,10);
4009: --
4010: -- Set to prev year
4011: --
4012: l_months := to_number(to_char(p_date,'MM'))+3;

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

4016: -- Set to first of month of October
4017: --
4018: l_date := last_day(l_date)+1;
4019: --
4020: hr_utility.set_location ('Leaving '||l_package,10);
4021: return l_date;
4022: --
4023: end set_to_oct1_prev_year;
4024:

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

4175: l_jurisdiction_code varchar2(150);
4176: --
4177: begin
4178: --
4179: -- hr_utility.set_location ('Entering '||l_package,10);
4180: --
4181: -- hr_utility.set_location ('Before Init Formula '||l_package,10);
4182: --
4183: -- Bug 1949361 : Get the jurisdiction code for US legislation only.

Line 4181: -- hr_utility.set_location ('Before Init Formula '||l_package,10);

4177: begin
4178: --
4179: -- hr_utility.set_location ('Entering '||l_package,10);
4180: --
4181: -- hr_utility.set_location ('Before Init Formula '||l_package,10);
4182: --
4183: -- Bug 1949361 : Get the jurisdiction code for US legislation only.
4184: --
4185: open c_leg;

Line 4217: -- hr_utility.set_location ('After Init Formula '||l_package,10);

4213: (p_formula_id => p_formula_id,
4214: p_effective_date => p_effective_date,
4215: p_inputs => l_inputs,
4216: p_outputs => l_outputs);
4217: -- hr_utility.set_location ('After Init Formula '||l_package,10);
4218: --
4219: -- NOTE that we use special parameter values in order to state which
4220: -- array locations we put the values into, this is because of the caching
4221: -- mechanism that formula uses.

Line 4223: -- hr_utility.set_location ('First Position'||l_inputs.first,10);

4219: -- NOTE that we use special parameter values in order to state which
4220: -- array locations we put the values into, this is because of the caching
4221: -- mechanism that formula uses.
4222: --
4223: -- hr_utility.set_location ('First Position'||l_inputs.first,10);
4224: -- hr_utility.set_location ('Last Position'||l_inputs.last,10);
4225: l_param_tab_count := p_param_tab.count;
4226: --
4227: -- Account for case where formula has no contexts or inputs

Line 4224: -- hr_utility.set_location ('Last Position'||l_inputs.last,10);

4220: -- array locations we put the values into, this is because of the caching
4221: -- mechanism that formula uses.
4222: --
4223: -- hr_utility.set_location ('First Position'||l_inputs.first,10);
4224: -- hr_utility.set_location ('Last Position'||l_inputs.last,10);
4225: l_param_tab_count := p_param_tab.count;
4226: --
4227: -- Account for case where formula has no contexts or inputs
4228: --

Line 4231: -- hr_utility.set_location ('Current Context'||l_inputs(l_count).name,10);

4227: -- Account for case where formula has no contexts or inputs
4228: --
4229: for l_count in nvl(l_inputs.first,0)..nvl(l_inputs.last,-1) loop
4230: --
4231: -- hr_utility.set_location ('Current Context'||l_inputs(l_count).name,10);
4232: --
4233: if l_inputs(l_count).name = 'BUSINESS_GROUP_ID' then
4234: --
4235: l_inputs(l_count).value := nvl(p_business_group_id, -1);

Line 4326: -- hr_utility.set_location ('Date Earned '||to_char(p_effective_date),10);

4322: --
4323: -- Note that you must pass the date as a string, that is because
4324: -- of the canonical date change of 11.5
4325: --
4326: -- hr_utility.set_location ('Date Earned '||to_char(p_effective_date),10);
4327: -- Still the fast formula does't accept the full canonical form.
4328: -- l_inputs(l_count).value := fnd_date.date_to_canonical(p_effective_date);
4329: l_inputs(l_count).value := to_char(p_effective_date, 'YYYY/MM/DD');
4330: --

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

4498: ff_exec.run_formula(p_inputs => l_inputs,
4499: p_outputs => l_outputs,
4500: p_use_dbi_cache => false); -- bug# 2430017
4501: --
4502: -- hr_utility.set_location ('Leaving '||l_package,10);
4503: return l_outputs;
4504: --
4505: end formula;
4506: --

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

4608: l_env ben_env_object.g_global_env_rec_type;
4609: --
4610: begin
4611: --
4612: hr_utility.set_location ('Entering '||l_package,10);
4613: --
4614: -- Bug : 1656320 : context assignment id is not available.
4615: -- Add environment init procedure
4616: -- Work out if we are being called from a concurrent program

Line 4621: hr_utility.set_location('p_ff_date '||p_effective_date ||

4617: -- otherwise we need to initialize the environment to set the business_goup_id
4618: -- and effective_date in the cache, so that assignment get_object
4619: -- routines work fine.
4620: --
4621: hr_utility.set_location('p_ff_date '||p_effective_date ||
4622: ' p_leod ' || p_lf_evt_ocrd_dt,11);
4623: --
4624: -- if fnd_global.conc_request_id = -1 then
4625: -- bug 4947096

Line 4688: hr_utility.set_location('assignment_id '||l_ass_rec.assignment_id , 13);

4684: --
4685: end if;
4686: */
4687: --
4688: hr_utility.set_location('assignment_id '||l_ass_rec.assignment_id , 13);
4689: l_outputs := benutils.formula
4690: (p_formula_id => p_formula_id,
4691: p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date),
4692: p_assignment_id => l_ass_rec.assignment_id,

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

4779: p_ret_val := 'Y';
4780: --
4781: end if;
4782: --
4783: hr_utility.set_location ('Leaving '||l_package,10);
4784: --
4785: end exec_rule;
4786: --
4787: --

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

5063: --
5064: --
5065: begin
5066: --
5067: --hr_utility.set_location('Entering ' ||l_package, 10);
5068: --hr_utility.set_location('p_elig_per_elctbl_chc_id ' || to_char(p_elig_per_elctbl_chc_id ), 20);
5069: --hr_utility.set_location('p_enrt_bnft_id ' || to_char(p_enrt_bnft_id ), 20);
5070: --hr_utility.set_location('p_effective_date ' || to_char(p_effective_date ), 20);
5071: --hr_utility.set_location('p_enrt_rt_id ' || to_char(p_enrt_rt_id ), 20);

Line 5068: --hr_utility.set_location('p_elig_per_elctbl_chc_id ' || to_char(p_elig_per_elctbl_chc_id ), 20);

5064: --
5065: begin
5066: --
5067: --hr_utility.set_location('Entering ' ||l_package, 10);
5068: --hr_utility.set_location('p_elig_per_elctbl_chc_id ' || to_char(p_elig_per_elctbl_chc_id ), 20);
5069: --hr_utility.set_location('p_enrt_bnft_id ' || to_char(p_enrt_bnft_id ), 20);
5070: --hr_utility.set_location('p_effective_date ' || to_char(p_effective_date ), 20);
5071: --hr_utility.set_location('p_enrt_rt_id ' || to_char(p_enrt_rt_id ), 20);
5072: --hr_utility.set_location('p_enrt_rt_id2 ' || to_char(p_enrt_rt_id2 ), 20);

Line 5069: --hr_utility.set_location('p_enrt_bnft_id ' || to_char(p_enrt_bnft_id ), 20);

5065: begin
5066: --
5067: --hr_utility.set_location('Entering ' ||l_package, 10);
5068: --hr_utility.set_location('p_elig_per_elctbl_chc_id ' || to_char(p_elig_per_elctbl_chc_id ), 20);
5069: --hr_utility.set_location('p_enrt_bnft_id ' || to_char(p_enrt_bnft_id ), 20);
5070: --hr_utility.set_location('p_effective_date ' || to_char(p_effective_date ), 20);
5071: --hr_utility.set_location('p_enrt_rt_id ' || to_char(p_enrt_rt_id ), 20);
5072: --hr_utility.set_location('p_enrt_rt_id2 ' || to_char(p_enrt_rt_id2 ), 20);
5073: --hr_utility.set_location('p_enrt_rt_id3 ' || to_char(p_enrt_rt_id3 ), 20);

Line 5070: --hr_utility.set_location('p_effective_date ' || to_char(p_effective_date ), 20);

5066: --
5067: --hr_utility.set_location('Entering ' ||l_package, 10);
5068: --hr_utility.set_location('p_elig_per_elctbl_chc_id ' || to_char(p_elig_per_elctbl_chc_id ), 20);
5069: --hr_utility.set_location('p_enrt_bnft_id ' || to_char(p_enrt_bnft_id ), 20);
5070: --hr_utility.set_location('p_effective_date ' || to_char(p_effective_date ), 20);
5071: --hr_utility.set_location('p_enrt_rt_id ' || to_char(p_enrt_rt_id ), 20);
5072: --hr_utility.set_location('p_enrt_rt_id2 ' || to_char(p_enrt_rt_id2 ), 20);
5073: --hr_utility.set_location('p_enrt_rt_id3 ' || to_char(p_enrt_rt_id3 ), 20);
5074: --hr_utility.set_location('p_enrt_rt_id4 ' || to_char(p_enrt_rt_id4 ), 20);

Line 5071: --hr_utility.set_location('p_enrt_rt_id ' || to_char(p_enrt_rt_id ), 20);

5067: --hr_utility.set_location('Entering ' ||l_package, 10);
5068: --hr_utility.set_location('p_elig_per_elctbl_chc_id ' || to_char(p_elig_per_elctbl_chc_id ), 20);
5069: --hr_utility.set_location('p_enrt_bnft_id ' || to_char(p_enrt_bnft_id ), 20);
5070: --hr_utility.set_location('p_effective_date ' || to_char(p_effective_date ), 20);
5071: --hr_utility.set_location('p_enrt_rt_id ' || to_char(p_enrt_rt_id ), 20);
5072: --hr_utility.set_location('p_enrt_rt_id2 ' || to_char(p_enrt_rt_id2 ), 20);
5073: --hr_utility.set_location('p_enrt_rt_id3 ' || to_char(p_enrt_rt_id3 ), 20);
5074: --hr_utility.set_location('p_enrt_rt_id4 ' || to_char(p_enrt_rt_id4 ), 20);
5075: --

Line 5072: --hr_utility.set_location('p_enrt_rt_id2 ' || to_char(p_enrt_rt_id2 ), 20);

5068: --hr_utility.set_location('p_elig_per_elctbl_chc_id ' || to_char(p_elig_per_elctbl_chc_id ), 20);
5069: --hr_utility.set_location('p_enrt_bnft_id ' || to_char(p_enrt_bnft_id ), 20);
5070: --hr_utility.set_location('p_effective_date ' || to_char(p_effective_date ), 20);
5071: --hr_utility.set_location('p_enrt_rt_id ' || to_char(p_enrt_rt_id ), 20);
5072: --hr_utility.set_location('p_enrt_rt_id2 ' || to_char(p_enrt_rt_id2 ), 20);
5073: --hr_utility.set_location('p_enrt_rt_id3 ' || to_char(p_enrt_rt_id3 ), 20);
5074: --hr_utility.set_location('p_enrt_rt_id4 ' || to_char(p_enrt_rt_id4 ), 20);
5075: --
5076: open c_pen_bnft_amt;

Line 5073: --hr_utility.set_location('p_enrt_rt_id3 ' || to_char(p_enrt_rt_id3 ), 20);

5069: --hr_utility.set_location('p_enrt_bnft_id ' || to_char(p_enrt_bnft_id ), 20);
5070: --hr_utility.set_location('p_effective_date ' || to_char(p_effective_date ), 20);
5071: --hr_utility.set_location('p_enrt_rt_id ' || to_char(p_enrt_rt_id ), 20);
5072: --hr_utility.set_location('p_enrt_rt_id2 ' || to_char(p_enrt_rt_id2 ), 20);
5073: --hr_utility.set_location('p_enrt_rt_id3 ' || to_char(p_enrt_rt_id3 ), 20);
5074: --hr_utility.set_location('p_enrt_rt_id4 ' || to_char(p_enrt_rt_id4 ), 20);
5075: --
5076: open c_pen_bnft_amt;
5077: fetch c_pen_bnft_amt into l_bnft_amt;

Line 5074: --hr_utility.set_location('p_enrt_rt_id4 ' || to_char(p_enrt_rt_id4 ), 20);

5070: --hr_utility.set_location('p_effective_date ' || to_char(p_effective_date ), 20);
5071: --hr_utility.set_location('p_enrt_rt_id ' || to_char(p_enrt_rt_id ), 20);
5072: --hr_utility.set_location('p_enrt_rt_id2 ' || to_char(p_enrt_rt_id2 ), 20);
5073: --hr_utility.set_location('p_enrt_rt_id3 ' || to_char(p_enrt_rt_id3 ), 20);
5074: --hr_utility.set_location('p_enrt_rt_id4 ' || to_char(p_enrt_rt_id4 ), 20);
5075: --
5076: open c_pen_bnft_amt;
5077: fetch c_pen_bnft_amt into l_bnft_amt;
5078: if c_pen_bnft_amt%found then

Line 5080: --hr_utility.set_location(' bnft amt found ' || to_char(l_bnft_amt), 30);

5076: open c_pen_bnft_amt;
5077: fetch c_pen_bnft_amt into l_bnft_amt;
5078: if c_pen_bnft_amt%found then
5079: --
5080: --hr_utility.set_location(' bnft amt found ' || to_char(l_bnft_amt), 30);
5081: p_bnft_amt := l_bnft_amt ;
5082: --
5083: end if;
5084: close c_pen_bnft_amt;

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

5114: end if;
5115: --
5116: end loop;
5117: --
5118: --hr_utility.set_location('Entering ' ||l_package, 10);
5119: --
5120: exception
5121: --
5122: when others then

Line 5454: hr_utility.set_location('Entering '||l_proc, 999);

5450: l_profile_value number ;
5451: l_defined Boolean ;
5452: --
5453: begin
5454: hr_utility.set_location('Entering '||l_proc, 999);
5455: --
5456: -- check if the profile is set with PAP group
5457: --
5458: fnd_profile.get_specific( name_z => 'ACTION_PARAMETER_GROUPS'

Line 5465: hr_utility.set_location('l_profile_value '||l_profile_value, 999);

5461: ,application_id_z => fnd_global.resp_appl_id
5462: ,val_z => l_profile_value
5463: ,defined_z => l_defined );
5464:
5465: hr_utility.set_location('l_profile_value '||l_profile_value, 999);
5466: --
5467: -- If the profile is not set with PAP group then look for default
5468: --
5469: if (l_profile_value is null or l_defined = FALSE )

Line 5475: hr_utility.set_location('l_profile_value not defined '||l_mode, 999);

5471: open c_mode;
5472: fetch c_mode into l_mode;
5473: close c_mode;
5474: --
5475: hr_utility.set_location('l_profile_value not defined '||l_mode, 999);
5476: elsif ( l_profile_value is not null or l_defined = TRUE ) then
5477: --
5478: open c_pap_mode(l_profile_value );
5479: fetch c_pap_mode into l_mode;

Line 5482: hr_utility.set_location('l_profile_value defined '||l_mode, 999);

5478: open c_pap_mode(l_profile_value );
5479: fetch c_pap_mode into l_mode;
5480: close c_pap_mode;
5481: --
5482: hr_utility.set_location('l_profile_value defined '||l_mode, 999);
5483: end if ;
5484: --
5485: if l_mode not in ('P','Y','N') then
5486: --

Line 5493: hr_utility.set_location('successful '||hr_general.g_data_migrator_mode, 999);

5489: else
5490: hr_general.g_data_migrator_mode := l_mode ;
5491: end if;
5492: --
5493: hr_utility.set_location('successful '||hr_general.g_data_migrator_mode, 999);
5494: hr_utility.set_location('Leaving '||l_proc, 999);
5495: exception
5496: --
5497: when others then

Line 5494: hr_utility.set_location('Leaving '||l_proc, 999);

5490: hr_general.g_data_migrator_mode := l_mode ;
5491: end if;
5492: --
5493: hr_utility.set_location('successful '||hr_general.g_data_migrator_mode, 999);
5494: hr_utility.set_location('Leaving '||l_proc, 999);
5495: exception
5496: --
5497: when others then
5498: --

Line 5501: hr_utility.set_location('when others value '||hr_general.g_data_migrator_mode, 999);

5497: when others then
5498: --
5499: hr_general.g_data_migrator_mode := 'N';
5500: --
5501: hr_utility.set_location('when others value '||hr_general.g_data_migrator_mode, 999);
5502: end set_data_migrator_mode;
5503: --
5504: -- Bug 2016857
5505: --

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

5953:
5954: --
5955: begin
5956: --
5957: hr_utility.set_location('Entering:'||l_proc, 5);
5958: --
5959: -- Get the last updated date from pil record for Unrestricted LE run
5960: --
5961: open c_pil_last_upd_date;

Line 5978: hr_utility.set_location('p_effective_date = '||p_effective_date, 999);

5974: --
5975: -- If session date is farther than the last Unrestricted run date,
5976: -- then also we need to run Unrest even if ssProcessUnrestricted flag is 'N'
5977: --
5978: hr_utility.set_location('p_effective_date = '||p_effective_date, 999);
5979: hr_utility.set_location('l_pil_lf_evt_ocrd_dt is '||l_pil_lf_evt_ocrd_dt, 999);
5980: --
5981: l_run_benmngle := true;
5982: --

Line 5979: hr_utility.set_location('l_pil_lf_evt_ocrd_dt is '||l_pil_lf_evt_ocrd_dt, 999);

5975: -- If session date is farther than the last Unrestricted run date,
5976: -- then also we need to run Unrest even if ssProcessUnrestricted flag is 'N'
5977: --
5978: hr_utility.set_location('p_effective_date = '||p_effective_date, 999);
5979: hr_utility.set_location('l_pil_lf_evt_ocrd_dt is '||l_pil_lf_evt_ocrd_dt, 999);
5980: --
5981: l_run_benmngle := true;
5982: --
5983: elsif (p_effective_date = l_pil_lf_evt_ocrd_dt

Line 5993: hr_utility.set_location('l_per_last_upd_date is '||l_per_last_upd_date, 999);

5989: open c_per_last_upd_date(l_pil_last_upd_date);
5990: fetch c_per_last_upd_date into l_per_last_upd_date;
5991: close c_per_last_upd_date;
5992: --
5993: hr_utility.set_location('l_per_last_upd_date is '||l_per_last_upd_date, 999);
5994: hr_utility.set_location('l_pil_last_upd_date is '||l_pil_last_upd_date, 999);
5995: --
5996: if (nvl(l_per_last_upd_date,l_pil_last_upd_date) > l_pil_last_upd_date) then
5997: --

Line 5994: hr_utility.set_location('l_pil_last_upd_date is '||l_pil_last_upd_date, 999);

5990: fetch c_per_last_upd_date into l_per_last_upd_date;
5991: close c_per_last_upd_date;
5992: --
5993: hr_utility.set_location('l_per_last_upd_date is '||l_per_last_upd_date, 999);
5994: hr_utility.set_location('l_pil_last_upd_date is '||l_pil_last_upd_date, 999);
5995: --
5996: if (nvl(l_per_last_upd_date,l_pil_last_upd_date) > l_pil_last_upd_date) then
5997: --
5998: -- If Person data has changed since the last Unrest LEOD then run benmngle

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

6009: --
6010: end if;
6011: close c_pil_last_upd_date;
6012: --
6013: hr_utility.set_location('Leaving:'||l_proc, 5);
6014: return l_run_benmngle;
6015: --
6016: end run_osb_benmngle_flag;
6017: --