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

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

148:
149: --
150: BEGIN
151: --
152: hr_utility.set_location('Entering'||l_proc, 5);
153: --
154: open c_xre;
155: fetch c_xre into l_dummy;
156: hr_utility.set_location('error msg '||substr(p_err_name,1,100), 99.96 );

Line 156: hr_utility.set_location('error msg '||substr(p_err_name,1,100), 99.96 );

152: hr_utility.set_location('Entering'||l_proc, 5);
153: --
154: open c_xre;
155: fetch c_xre into l_dummy;
156: hr_utility.set_location('error msg '||substr(p_err_name,1,100), 99.96 );
157: if c_xre%notfound then -- only write once.
158: ben_ext_rslt_err_api.create_ext_rslt_err
159: (p_validate => FALSE,
160: p_ext_rslt_err_id => l_ext_rslt_err_id,

Line 176: hr_utility.set_location('Exiting'||l_proc, 15);

172: p_effective_date => sysdate
173: );
174: end if;
175: --
176: hr_utility.set_location('Exiting'||l_proc, 15);
177: --
178: END WRITE_ERR;
179: --
180: --

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

258: l_proc varchar2(72) := g_package||'.get_rec_nam_num';
259: --
260: begin
261: --
262: hr_utility.set_location('Entering'||l_proc, 5);
263: --
264: if p_ext_rslt_id is null and p_request_id is null then
265: p_rec_tab(1).name := null;
266: p_rec_tab(1).num := 0;

Line 317: hr_utility.set_location('Exiting'||l_proc, 15);

313: p_rec_tab(1).num := 0;
314: end if;
315: end if;
316: --
317: hr_utility.set_location('Exiting'||l_proc, 15);
318: --
319: --
320: end get_rec_nam_num;
321: --

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

364: AND a.ext_rslt_id = p_ext_rslt_id;
365: --
366: begin
367: --
368: hr_utility.set_location('Entering'||l_proc, 5);
369: --
370: if p_ext_rslt_id is null and p_request_id is null then
371: p_header_rec := 0;
372: p_detail_rec := 0;

Line 394: hr_utility.set_location('Exiting'||l_proc, 15);

390: p_trailer_rec;
391: close csr_get_rec_statistics_both;
392: end if;
393: --
394: hr_utility.set_location('Exiting'||l_proc, 15);
395: --
396: end get_rec_statistics;
397: --
398: --

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

438: --
439: begin
440: --
441: --
442: hr_utility.set_location('Entering'||l_proc, 5);
443: --
444: if p_ext_rslt_id is null and p_request_id is null then
445: p_per_xtrctd := 0;
446: p_per_not_xtrctd := 0;

Line 494: hr_utility.set_location('Exiting'||l_proc, 15);

490: end if;
491: --
492: end if;
493: --
494: hr_utility.set_location('Exiting'||l_proc, 15);
495: --
496: end get_per_statistics;
497: --
498: --

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

527: --
528: begin
529: --
530: --
531: hr_utility.set_location('Entering'||l_proc, 5);
532: --
533: if p_ext_rslt_id is null and p_request_id is null then
534: p_job_failure := 0;
535: p_error := 0;

Line 581: hr_utility.set_location('Exiting'||l_proc, 15);

577: end if;
578: --
579: end if;
580: --
581: hr_utility.set_location('Exiting'||l_proc, 15);
582: --
583: end get_err_warn_statistics;
584: --
585: --

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

651: --
652: begin
653: --
654: --
655: hr_utility.set_location('Entering'||l_proc, 5);
656: --
657: open get_prompt;
658: loop
659: fetch get_prompt into l_lookup_code, l_meaning;

Line 668: hr_utility.set_location('p_ext_rslt_id'||p_ext_rslt_id, 5);

664: end loop;
665: close get_prompt;
666: --
667:
668: hr_utility.set_location('p_ext_rslt_id'||p_ext_rslt_id, 5);
669: hr_utility.set_location('p_request_id'||p_request_id, 5);
670: get_rec_nam_num(p_ext_rslt_id => p_ext_rslt_id
671: ,p_request_id => p_request_id
672: ,p_rec_tab => l_rec_tab

Line 669: hr_utility.set_location('p_request_id'||p_request_id, 5);

665: close get_prompt;
666: --
667:
668: hr_utility.set_location('p_ext_rslt_id'||p_ext_rslt_id, 5);
669: hr_utility.set_location('p_request_id'||p_request_id, 5);
670: get_rec_nam_num(p_ext_rslt_id => p_ext_rslt_id
671: ,p_request_id => p_request_id
672: ,p_rec_tab => l_rec_tab
673: );

Line 683: hr_utility.set_location ( l_rec_tab(i).name || ' ' || l_rec_tab(i).num , 60);

679: ,p_key => '2E')).meaning, 34) || ' ' || lpad('0', 6) || ' ';
680: else
681: for i in 1..l_rec_tab.count
682: loop
683: hr_utility.set_location ( l_rec_tab(i).name || ' ' || l_rec_tab(i).num , 60);
684: l_tot_rec := l_tot_rec + l_rec_tab(i).num;
685: end loop;
686: --
687: l_text := rpad(l_lookup_tab(get_index(p_array => l_lookup_tab

Line 781: hr_utility.set_location('Exiting'||l_proc, 15);

777: end if ;
778: p_text := l_text;
779: --
780: --
781: hr_utility.set_location('Exiting'||l_proc, 15);
782: --
783: end get_statistics_text;
784: -----------------------------------------------------------------------------------
785: ----------------------------< Get_Value >------------------------------------------

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

798: --
799: BEGIN
800: --
801: --
802: hr_utility.set_location('Entering'||l_proc, 5);
803: --
804: if p_seq_num < 10 then
805: l_char_seq_num := '0' || to_char(p_seq_num);
806: else

Line 827: hr_utility.set_location('Exiting'||l_proc, 5);

823: --
824: DBMS_SQL.CLOSE_CURSOR(l_cid);
825: --
826: --
827: hr_utility.set_location('Exiting'||l_proc, 5);
828: --
829: return(l_value);
830: --
831: END get_value;

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

868: l_proc varchar2(72) := g_package||'.get_chg_dates';
869: --
870: Begin
871: --
872: hr_utility.set_location('Entering'||l_proc, 5);
873: --
874: -- Note about this logic: If the exclude flag is on for these ranges,
875: -- then we will set the range from bot to eot, and let the evaluate
876: -- inclusion program handle it.

Line 931: hr_utility.set_location('chg start date ' || p_chg_eff_strt_dt , 9185);

927: p_ext_dfn_id => p_ext_dfn_id
928: );
929: end if;
930: --
931: hr_utility.set_location('chg start date ' || p_chg_eff_strt_dt , 9185);
932: hr_utility.set_location('chg End date ' || p_chg_eff_end_dt , 9185);
933: hr_utility.set_location('Exiting'||l_proc, 5);
934: --
935: End get_chg_dates;

Line 932: hr_utility.set_location('chg End date ' || p_chg_eff_end_dt , 9185);

928: );
929: end if;
930: --
931: hr_utility.set_location('chg start date ' || p_chg_eff_strt_dt , 9185);
932: hr_utility.set_location('chg End date ' || p_chg_eff_end_dt , 9185);
933: hr_utility.set_location('Exiting'||l_proc, 5);
934: --
935: End get_chg_dates;
936: --

Line 933: hr_utility.set_location('Exiting'||l_proc, 5);

929: end if;
930: --
931: hr_utility.set_location('chg start date ' || p_chg_eff_strt_dt , 9185);
932: hr_utility.set_location('chg End date ' || p_chg_eff_end_dt , 9185);
933: hr_utility.set_location('Exiting'||l_proc, 5);
934: --
935: End get_chg_dates;
936: --
937: -----------------------------------------------------------------------------------

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

958: l_proc varchar2(72) := g_package||'.get_cm_dates';
959: --
960: Begin
961: --
962: hr_utility.set_location('Entering'||l_proc, 5);
963: --
964: -- Note about this logic: If the exclude flag is on for these ranges,
965: -- then we will set the range from bot to eot, and let the evaluate
966: -- inclusion program handle it.

Line 976: hr_utility.set_location(' 514 error cm ' , 514);

972: if nvl(l_to_be_sent_dt.excld_flag,'N') = 'Y' or l_to_be_sent_dt.val_1 is null then
973: p_to_be_sent_strt_dt := hr_api.g_sot;
974: else
975:
976: hr_utility.set_location(' 514 error cm ' , 514);
977: p_to_be_sent_strt_dt := ben_ext_util.calc_ext_date
978: (p_ext_date_cd => l_to_be_sent_dt.val_1,
979: p_abs_date => p_effective_date,
980: p_ext_dfn_id => p_ext_dfn_id

Line 987: hr_utility.set_location(' 514 error cmm ' , 514);

983: --
984: if nvl(l_to_be_sent_dt.excld_flag,'N') = 'Y' or l_to_be_sent_dt.val_2 is null then
985: p_to_be_sent_end_dt := hr_api.g_eot;
986: else
987: hr_utility.set_location(' 514 error cmm ' , 514);
988: p_to_be_sent_end_dt := ben_ext_util.calc_ext_date
989: (p_ext_date_cd => l_to_be_sent_dt.val_2,
990: p_abs_date => p_effective_date,
991: p_ext_dfn_id => p_ext_dfn_id

Line 995: hr_utility.set_location('cm start date ' || p_to_be_sent_strt_dt , 9185);

991: p_ext_dfn_id => p_ext_dfn_id
992: );
993: end if;
994: --
995: hr_utility.set_location('cm start date ' || p_to_be_sent_strt_dt , 9185);
996: hr_utility.set_location('cm End date ' || p_to_be_sent_end_dt , 9185);
997:
998: hr_utility.set_location('Exiting'||l_proc, 5);
999: --

Line 996: hr_utility.set_location('cm End date ' || p_to_be_sent_end_dt , 9185);

992: );
993: end if;
994: --
995: hr_utility.set_location('cm start date ' || p_to_be_sent_strt_dt , 9185);
996: hr_utility.set_location('cm End date ' || p_to_be_sent_end_dt , 9185);
997:
998: hr_utility.set_location('Exiting'||l_proc, 5);
999: --
1000: End get_cm_dates;

Line 998: hr_utility.set_location('Exiting'||l_proc, 5);

994: --
995: hr_utility.set_location('cm start date ' || p_to_be_sent_strt_dt , 9185);
996: hr_utility.set_location('cm End date ' || p_to_be_sent_end_dt , 9185);
997:
998: hr_utility.set_location('Exiting'||l_proc, 5);
999: --
1000: End get_cm_dates;
1001: --
1002: -----------------------------------------------------------------------------------

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

1091: l_proc varchar2(72) := g_package||'.get_ext_dates';
1092: --
1093: Begin
1094: --
1095: hr_utility.set_location('Entering'||l_proc, 5);
1096:
1097: --
1098: if ben_extract.g_pasor_dt_cd is not null then
1099: l_person_dt_cd := ben_extract.g_pasor_dt_cd ;

Line 1102: hr_utility.set_location('pasor_dt_cd '||l_person_dt_cd, 5);

1098: if ben_extract.g_pasor_dt_cd is not null then
1099: l_person_dt_cd := ben_extract.g_pasor_dt_cd ;
1100: end if ;
1101:
1102: hr_utility.set_location('pasor_dt_cd '||l_person_dt_cd, 5);
1103: hr_utility.set_location('effective date '||p_effective_date, 5);
1104:
1105: if l_person_dt_cd in ( 'TDRASG','TDPRASG') then
1106: l_person_dt := p_effective_date;

Line 1103: hr_utility.set_location('effective date '||p_effective_date, 5);

1099: l_person_dt_cd := ben_extract.g_pasor_dt_cd ;
1100: end if ;
1101:
1102: hr_utility.set_location('pasor_dt_cd '||l_person_dt_cd, 5);
1103: hr_utility.set_location('effective date '||p_effective_date, 5);
1104:
1105: if l_person_dt_cd in ( 'TDRASG','TDPRASG') then
1106: l_person_dt := p_effective_date;
1107: l_benefits_dt := p_effective_date;

Line 1119: hr_utility.set_location('terminated asg eff date'||l_person_dt, 5);

1115: open c_asg_term ;
1116: fetch c_asg_term into l_person_dt ;
1117: close c_asg_term ;
1118: l_benefits_dt := l_person_dt ;
1119: hr_utility.set_location('terminated asg eff date'||l_person_dt, 5);
1120: end if ;
1121: -- if employee assignment not there
1122: -- check for any other primary asg , if not
1123: -- check for any applicant assg , if not

Line 1131: hr_utility.set_location(' pr asg not found '||l_person_dt_cd , 6);

1127: open c_asg_exist ;
1128: fetch c_asg_exist into l_dummy ;
1129: if c_asg_exist%notfound then
1130:
1131: hr_utility.set_location(' pr asg not found '||l_person_dt_cd , 6);
1132: -- get applicant assignment
1133: open c_a_asg_exist ;
1134: fetch c_a_asg_exist into l_dummy ;
1135: if c_a_asg_exist%notfound then

Line 1141: hr_utility.set_location('termianted asg eff date '||l_person_dt, 7) ;

1137: open c_asg_term ;
1138: fetch c_asg_term into l_person_dt ;
1139: close c_asg_term ;
1140: l_benefits_dt := l_person_dt ;
1141: hr_utility.set_location('termianted asg eff date '||l_person_dt, 7) ;
1142: end if ;
1143: close c_a_asg_exist ;
1144: end if ;
1145: close c_asg_exist ;

Line 1218: hr_utility.set_location('l_person_dt_cd '||l_person_dt_cd||' / '||p_person_ext_dt , 5);

1214:
1215: p_person_ext_dt := nvl(l_person_dt , p_effective_date );
1216: p_benefits_ext_dt := nvl(l_benefits_dt, p_effective_date);
1217: --
1218: hr_utility.set_location('l_person_dt_cd '||l_person_dt_cd||' / '||p_person_ext_dt , 5);
1219: hr_utility.set_location('l_benefits_dt_cd '||l_benefits_dt_cd||' / '|| p_benefits_ext_dt ,5);
1220: hr_utility.set_location('Exiting'||l_proc, 5);
1221: --
1222: End get_ext_dates;

Line 1219: hr_utility.set_location('l_benefits_dt_cd '||l_benefits_dt_cd||' / '|| p_benefits_ext_dt ,5);

1215: p_person_ext_dt := nvl(l_person_dt , p_effective_date );
1216: p_benefits_ext_dt := nvl(l_benefits_dt, p_effective_date);
1217: --
1218: hr_utility.set_location('l_person_dt_cd '||l_person_dt_cd||' / '||p_person_ext_dt , 5);
1219: hr_utility.set_location('l_benefits_dt_cd '||l_benefits_dt_cd||' / '|| p_benefits_ext_dt ,5);
1220: hr_utility.set_location('Exiting'||l_proc, 5);
1221: --
1222: End get_ext_dates;
1223: --

Line 1220: hr_utility.set_location('Exiting'||l_proc, 5);

1216: p_benefits_ext_dt := nvl(l_benefits_dt, p_effective_date);
1217: --
1218: hr_utility.set_location('l_person_dt_cd '||l_person_dt_cd||' / '||p_person_ext_dt , 5);
1219: hr_utility.set_location('l_benefits_dt_cd '||l_benefits_dt_cd||' / '|| p_benefits_ext_dt ,5);
1220: hr_utility.set_location('Exiting'||l_proc, 5);
1221: --
1222: End get_ext_dates;
1223: --
1224: Function calc_ext_date(p_ext_date_cd in varchar2,

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

1261:
1262: --
1263: Begin
1264: --
1265: hr_utility.set_location('Entering:'||l_proc, 5);
1266: hr_utility.set_location('date '||p_abs_date, 5);
1267: --
1268: -- User entered date
1269: --

Line 1266: hr_utility.set_location('date '||p_abs_date, 5);

1262: --
1263: Begin
1264: --
1265: hr_utility.set_location('Entering:'||l_proc, 5);
1266: hr_utility.set_location('date '||p_abs_date, 5);
1267: --
1268: -- User entered date
1269: --
1270: if substr(p_ext_date_cd, 3, 1) IN ('-', '/') then

Line 1446: hr_utility.set_location(' 514 error '|| p_ext_date_cd , 514);

1442: --
1443: elsif p_ext_date_cd IN ('CTBSD','CESD','CLEOD','CDBLEOD') then
1444: --
1445: if ben_ext_person.g_cm_type_id is null then
1446: hr_utility.set_location(' 514 error '|| p_ext_date_cd , 514);
1447:
1448: ben_ext_thread.g_err_num := 92451;
1449: ben_ext_thread.g_err_name := 'BEN_92451_EXT_INV_CM_DT';
1450: raise ben_ext_thread.g_job_failure_error;

Line 1505: hr_utility.set_location(' 514 error 1' , 514);

1501: --
1502: elsif p_ext_date_cd = 'CHAD' then
1503:
1504: if ben_ext_person.g_chg_actl_dt is null then
1505: hr_utility.set_location(' 514 error 1' , 514);
1506: ben_ext_thread.g_err_num := 92455;
1507: ben_ext_thread.g_err_name := 'BEN_92455_EXT_INV_CHG_DT';
1508: raise ben_ext_thread.g_job_failure_error;
1509:

Line 1520: hr_utility.set_location(' 514 error 2' , 514);

1516: elsif p_ext_date_cd = 'CHED' then
1517:
1518: if ben_ext_person.g_chg_eff_dt is null then
1519:
1520: hr_utility.set_location(' 514 error 2' , 514);
1521: ben_ext_thread.g_err_num := 92455;
1522: ben_ext_thread.g_err_name := 'BEN_92455_EXT_INV_CHG_DT';
1523: raise ben_ext_thread.g_job_failure_error;
1524:

Line 1824: hr_utility.set_location ( ' plan year start date ' , 99 );

1820: close c_pln_yr ;
1821:
1822: if l_yr_strt_date is not null then
1823: l_rslt_dt := l_yr_strt_date;
1824: hr_utility.set_location ( ' plan year start date ' , 99 );
1825: else
1826: l_rslt_dt := trunc(p_abs_date, 'YYYY');
1827: end if ;
1828:

Line 1839: hr_utility.set_location ( ' plan year End date ' , 99 );

1835: close c_pln_yr ;
1836:
1837: if l_yr_end_date is not null then
1838: l_rslt_dt := l_yr_end_date;
1839: hr_utility.set_location ( ' plan year End date ' , 99 );
1840: else
1841: l_rslt_dt := trunc(add_months(p_abs_date, 12), 'YYYY') - 1 ;
1842: end if ;
1843:

Line 1854: hr_utility.set_location(' ext_date : '||p_ext_date_cd ||l_rslt_dt, 185);

1850: --
1851: end if;
1852: --
1853:
1854: hr_utility.set_location(' ext_date : '||p_ext_date_cd ||l_rslt_dt, 185);
1855: hr_utility.set_location(' Exiting:'||l_proc, 15);
1856:
1857: return (l_rslt_dt);
1858: --

Line 1855: hr_utility.set_location(' Exiting:'||l_proc, 15);

1851: end if;
1852: --
1853:
1854: hr_utility.set_location(' ext_date : '||p_ext_date_cd ||l_rslt_dt, 185);
1855: hr_utility.set_location(' Exiting:'||l_proc, 15);
1856:
1857: return (l_rslt_dt);
1858: --
1859:

Line 1966: hr_utility.trace('Entering: '||l_proc);

1962: AND ppe.effective_date BETWEEN p_start_date AND p_end_date;
1963:
1964:
1965: BEGIN
1966: hr_utility.trace('Entering: '||l_proc);
1967: hr_utility.trace('Entered get_element_entries_for_eg: EG_Id:'||to_char(p_event_group_id));
1968: hr_utility.trace('Assignment Id:'||to_char(p_assignment_id));
1969: hr_utility.trace('Start Date:'||to_char(p_start_date, 'DD/MM/YYYY'));
1970: hr_utility.trace('End Date:'||to_char(p_end_date, 'DD/MM/YYYY'));

Line 1967: hr_utility.trace('Entered get_element_entries_for_eg: EG_Id:'||to_char(p_event_group_id));

1963:
1964:
1965: BEGIN
1966: hr_utility.trace('Entering: '||l_proc);
1967: hr_utility.trace('Entered get_element_entries_for_eg: EG_Id:'||to_char(p_event_group_id));
1968: hr_utility.trace('Assignment Id:'||to_char(p_assignment_id));
1969: hr_utility.trace('Start Date:'||to_char(p_start_date, 'DD/MM/YYYY'));
1970: hr_utility.trace('End Date:'||to_char(p_end_date, 'DD/MM/YYYY'));
1971:

Line 1968: hr_utility.trace('Assignment Id:'||to_char(p_assignment_id));

1964:
1965: BEGIN
1966: hr_utility.trace('Entering: '||l_proc);
1967: hr_utility.trace('Entered get_element_entries_for_eg: EG_Id:'||to_char(p_event_group_id));
1968: hr_utility.trace('Assignment Id:'||to_char(p_assignment_id));
1969: hr_utility.trace('Start Date:'||to_char(p_start_date, 'DD/MM/YYYY'));
1970: hr_utility.trace('End Date:'||to_char(p_end_date, 'DD/MM/YYYY'));
1971:
1972: p_element_entries_tab.element_entry_id.DELETE;

Line 1969: hr_utility.trace('Start Date:'||to_char(p_start_date, 'DD/MM/YYYY'));

1965: BEGIN
1966: hr_utility.trace('Entering: '||l_proc);
1967: hr_utility.trace('Entered get_element_entries_for_eg: EG_Id:'||to_char(p_event_group_id));
1968: hr_utility.trace('Assignment Id:'||to_char(p_assignment_id));
1969: hr_utility.trace('Start Date:'||to_char(p_start_date, 'DD/MM/YYYY'));
1970: hr_utility.trace('End Date:'||to_char(p_end_date, 'DD/MM/YYYY'));
1971:
1972: p_element_entries_tab.element_entry_id.DELETE;
1973: p_element_entries_tab.datetracked_event_id.DELETE;

Line 1970: hr_utility.trace('End Date:'||to_char(p_end_date, 'DD/MM/YYYY'));

1966: hr_utility.trace('Entering: '||l_proc);
1967: hr_utility.trace('Entered get_element_entries_for_eg: EG_Id:'||to_char(p_event_group_id));
1968: hr_utility.trace('Assignment Id:'||to_char(p_assignment_id));
1969: hr_utility.trace('Start Date:'||to_char(p_start_date, 'DD/MM/YYYY'));
1970: hr_utility.trace('End Date:'||to_char(p_end_date, 'DD/MM/YYYY'));
1971:
1972: p_element_entries_tab.element_entry_id.DELETE;
1973: p_element_entries_tab.datetracked_event_id.DELETE;
1974:

Line 1977: hr_utility.trace('Obtained the value from cache: '||g_eg_has_purge_dte(p_event_group_id));

1973: p_element_entries_tab.datetracked_event_id.DELETE;
1974:
1975: --- get the ids from cache
1976: IF g_eg_has_purge_dte.EXISTS(p_event_group_id) THEN
1977: hr_utility.trace('Obtained the value from cache: '||g_eg_has_purge_dte(p_event_group_id));
1978: l_purge_dte_id := g_eg_has_purge_dte(p_event_group_id);
1979: END IF;
1980:
1981:

Line 1985: hr_utility.trace('Obtained element set ids from cache');

1981:
1982: -- get the element set ids attached to the event group
1983: IF g_ele_set_ids_on_eg.EXISTS(p_event_group_id) THEN
1984: -- found ion the cache
1985: hr_utility.trace('Obtained element set ids from cache');
1986: l_element_set_ids_tab := g_ele_set_ids_on_eg(p_event_group_id);
1987: END IF;
1988:
1989: -- get the dte ids of the current event group

Line 1992: hr_utility.trace('Obtained element set ids from cache');

1988:
1989: -- get the dte ids of the current event group
1990: IF g_datetraced_event_ids.EXISTS(p_event_group_id) THEN
1991: -- found ion the cache
1992: hr_utility.trace('Obtained element set ids from cache');
1993: l_dte_ids_tab := g_datetraced_event_ids(p_event_group_id);
1994: END IF;
1995: ---
1996:

Line 2010: hr_utility.trace('Count:'||to_char(l_element_entries_tab.COUNT));

2006: l_element_entries_tab.delete ;
2007: --
2008: FETCH csr_element_entries BULK COLLECT INTO l_element_entries_tab;
2009: CLOSE csr_element_entries;
2010: hr_utility.trace('Count:'||to_char(l_element_entries_tab.COUNT));
2011:
2012: -- prepare l_global_env_collection with the ee_ids and dte_ids collections
2013: FOR i IN 1 .. l_dte_ids_tab.count
2014: LOOP

Line 2034: hr_utility.trace('There are puge events on element entries table in the eg.');

2030:
2031:
2032: IF nvl(l_purge_dte_id,-1) <> -1 THEN
2033: -- if there are purge events in the event group
2034: hr_utility.trace('There are puge events on element entries table in the eg.');
2035: OPEN csr_get_purged_ee_ids(l_element_set_ids_tab(i));
2036: FETCH csr_get_purged_ee_ids BULK COLLECT INTO l_purge_ee_ids;
2037: CLOSE csr_get_purged_ee_ids;
2038:

Line 2039: hr_utility.trace('Fill the values in the element entries collection.');

2035: OPEN csr_get_purged_ee_ids(l_element_set_ids_tab(i));
2036: FETCH csr_get_purged_ee_ids BULK COLLECT INTO l_purge_ee_ids;
2037: CLOSE csr_get_purged_ee_ids;
2038:
2039: hr_utility.trace('Fill the values in the element entries collection.');
2040: FOR i IN 1..l_purge_ee_ids.COUNT
2041: LOOP
2042: hr_utility.trace('l_purge_ee_ids(i): '||l_purge_ee_ids(i));
2043: -- bug fix 5368066. nvl is added for this bug fix.

Line 2042: hr_utility.trace('l_purge_ee_ids(i): '||l_purge_ee_ids(i));

2038:
2039: hr_utility.trace('Fill the values in the element entries collection.');
2040: FOR i IN 1..l_purge_ee_ids.COUNT
2041: LOOP
2042: hr_utility.trace('l_purge_ee_ids(i): '||l_purge_ee_ids(i));
2043: -- bug fix 5368066. nvl is added for this bug fix.
2044: l_next := nvl(l_global_env_collection.element_entry_id.LAST,0) + 1;
2045: l_global_env_collection.element_entry_id(l_next) := fnd_number.canonical_to_number(l_purge_ee_ids(i));
2046: l_global_env_collection.datetracked_event_id(l_next) := l_purge_dte_id;

Line 2077: hr_utility.trace('Count:'||to_char(p_element_entries_tab.element_entry_id.COUNT));

2073: END LOOP; -- i loop
2074:
2075: END LOOP; -- element set loop ...
2076:
2077: hr_utility.trace('Count:'||to_char(p_element_entries_tab.element_entry_id.COUNT));
2078:
2079: hr_utility.trace('Leaving: '||l_proc);
2080: RETURN p_element_entries_tab.element_entry_id.COUNT;
2081:

Line 2079: hr_utility.trace('Leaving: '||l_proc);

2075: END LOOP; -- element set loop ...
2076:
2077: hr_utility.trace('Count:'||to_char(p_element_entries_tab.element_entry_id.COUNT));
2078:
2079: hr_utility.trace('Leaving: '||l_proc);
2080: RETURN p_element_entries_tab.element_entry_id.COUNT;
2081:
2082: EXCEPTION
2083: WHEN OTHERS THEN

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

2148:
2149: Begin
2150: l_proc := g_package||'.event_element_exists';
2151: l_return := 'N' ;
2152: hr_utility.set_location('Entering'||l_proc, 5);
2153:
2154: -- for every person the event are executed
2155: -- instead of getting the value from cursor
2156: -- the values are cached so one event executes once for a theread

Line 2172: hr_utility.trace('element set ids in cache');

2168:
2169: -- when the element exists
2170: if l_return = 'Y' then
2171:
2172: hr_utility.trace('element set ids in cache');
2173: OPEN csr_get_element_set ;
2174: FETCH csr_get_element_set BULK COLLECT INTO l_element_set_ids_tab;
2175: CLOSE csr_get_element_set;
2176:

Line 2180: hr_utility.trace('Count:'||to_char(l_element_set_ids_tab.COUNT));

2176:
2177: --put the element set ids in the cache
2178:
2179: g_ele_set_ids_on_eg(p_event_group_id) := l_element_set_ids_tab;
2180: hr_utility.trace('Count:'||to_char(l_element_set_ids_tab.COUNT));
2181:
2182: hr_utility.trace('date treac event ids in cache');
2183: OPEN csr_get_dte_ids ;
2184: FETCH csr_get_dte_ids BULK COLLECT INTO l_dte_ids_tab;

Line 2182: hr_utility.trace('date treac event ids in cache');

2178:
2179: g_ele_set_ids_on_eg(p_event_group_id) := l_element_set_ids_tab;
2180: hr_utility.trace('Count:'||to_char(l_element_set_ids_tab.COUNT));
2181:
2182: hr_utility.trace('date treac event ids in cache');
2183: OPEN csr_get_dte_ids ;
2184: FETCH csr_get_dte_ids BULK COLLECT INTO l_dte_ids_tab;
2185: CLOSE csr_get_dte_ids;
2186: --put the element set ids in the cache

Line 2190: hr_utility.trace('date treack purge event ids in cache');

2186: --put the element set ids in the cache
2187: g_datetraced_event_ids(p_event_group_id) := l_dte_ids_tab;
2188:
2189:
2190: hr_utility.trace('date treack purge event ids in cache');
2191: OPEN csr_get_purge_events_ids;
2192: FETCH csr_get_purge_events_ids into l_purge_dte_id;
2193: CLOSE csr_get_purge_events_ids;
2194: g_eg_has_purge_dte(p_event_group_id) := nvl(l_purge_dte_id,-1);

Line 2200: hr_utility.set_location('Exiting '|| l_return ||l_proc, 10);

2196:
2197: end if ;
2198: end if ;
2199:
2200: hr_utility.set_location('Exiting '|| l_return ||l_proc, 10);
2201: Return l_return ;
2202:
2203: End event_element_exists ;
2204:

Line 2255: hr_utility.trace('Entering: '||l_proc);

2251: l_eg_has_ee_tab VARCHAR2(1);
2252:
2253:
2254: BEGIN --entries_effected
2255: hr_utility.trace('Entering: '||l_proc);
2256: hr_utility.trace('Get the element entries for the assignment id');
2257:
2258: -- Bugfix 4739067: Performance enhancement
2259: -- Checking if the event group has element entries or

Line 2256: hr_utility.trace('Get the element entries for the assignment id');

2252:
2253:
2254: BEGIN --entries_effected
2255: hr_utility.trace('Entering: '||l_proc);
2256: hr_utility.trace('Get the element entries for the assignment id');
2257:
2258: -- Bugfix 4739067: Performance enhancement
2259: -- Checking if the event group has element entries or
2260: -- element entry values table before trying to fetch events

Line 2282: hr_utility.trace('Our procedure');

2278: -- entry_affected and entries_affected - kkarri
2279: pay_interpreter_pkg.t_distinct_tab := pay_interpreter_pkg.glo_monitored_events;
2280: -----
2281: IF l_count > 0 THEN
2282: hr_utility.trace('Our procedure');
2283: hr_utility.trace('Setup the global area');
2284: pay_interpreter_pkg.initialise_global(l_global_env);
2285: pay_interpreter_pkg.event_group_tables
2286: (p_event_group_id => p_event_group_id

Line 2283: hr_utility.trace('Setup the global area');

2279: pay_interpreter_pkg.t_distinct_tab := pay_interpreter_pkg.glo_monitored_events;
2280: -----
2281: IF l_count > 0 THEN
2282: hr_utility.trace('Our procedure');
2283: hr_utility.trace('Setup the global area');
2284: pay_interpreter_pkg.initialise_global(l_global_env);
2285: pay_interpreter_pkg.event_group_tables
2286: (p_event_group_id => p_event_group_id
2287: ,p_distinct_tab => pay_interpreter_pkg.glo_monitored_events

Line 2300: hr_utility.trace(' call add_datetrack_event_to_entry for collection ');

2296: := pay_interpreter_pkg.t_proration_group_tab(p_event_group_id).range_end;
2297: ---
2298: l_global_env.datetrack_ee_tab_use := TRUE;
2299: l_global_env.validate_run_actions := FALSE;
2300: hr_utility.trace(' call add_datetrack_event_to_entry for collection ');
2301:
2302: FOR i IN l_datetrack_ee_tab.element_entry_id.FIRST..l_datetrack_ee_tab.element_entry_id.LAST
2303: LOOP
2304: hr_utility.trace('----------------------------------');

Line 2304: hr_utility.trace('----------------------------------');

2300: hr_utility.trace(' call add_datetrack_event_to_entry for collection ');
2301:
2302: FOR i IN l_datetrack_ee_tab.element_entry_id.FIRST..l_datetrack_ee_tab.element_entry_id.LAST
2303: LOOP
2304: hr_utility.trace('----------------------------------');
2305: hr_utility.trace('i: '||i);
2306: hr_utility.trace('datetracked_event_id: '||l_datetrack_ee_tab.datetracked_event_id(i));
2307: hr_utility.trace('element_entry_id: '||l_datetrack_ee_tab.element_entry_id(i));
2308: pay_interpreter_pkg.add_datetrack_event_to_entry

Line 2305: hr_utility.trace('i: '||i);

2301:
2302: FOR i IN l_datetrack_ee_tab.element_entry_id.FIRST..l_datetrack_ee_tab.element_entry_id.LAST
2303: LOOP
2304: hr_utility.trace('----------------------------------');
2305: hr_utility.trace('i: '||i);
2306: hr_utility.trace('datetracked_event_id: '||l_datetrack_ee_tab.datetracked_event_id(i));
2307: hr_utility.trace('element_entry_id: '||l_datetrack_ee_tab.element_entry_id(i));
2308: pay_interpreter_pkg.add_datetrack_event_to_entry
2309: (p_datetracked_evt_id => l_datetrack_ee_tab.datetracked_event_id(i)

Line 2306: hr_utility.trace('datetracked_event_id: '||l_datetrack_ee_tab.datetracked_event_id(i));

2302: FOR i IN l_datetrack_ee_tab.element_entry_id.FIRST..l_datetrack_ee_tab.element_entry_id.LAST
2303: LOOP
2304: hr_utility.trace('----------------------------------');
2305: hr_utility.trace('i: '||i);
2306: hr_utility.trace('datetracked_event_id: '||l_datetrack_ee_tab.datetracked_event_id(i));
2307: hr_utility.trace('element_entry_id: '||l_datetrack_ee_tab.element_entry_id(i));
2308: pay_interpreter_pkg.add_datetrack_event_to_entry
2309: (p_datetracked_evt_id => l_datetrack_ee_tab.datetracked_event_id(i)
2310: ,p_element_entry_id => l_datetrack_ee_tab.element_entry_id(i)

Line 2307: hr_utility.trace('element_entry_id: '||l_datetrack_ee_tab.element_entry_id(i));

2303: LOOP
2304: hr_utility.trace('----------------------------------');
2305: hr_utility.trace('i: '||i);
2306: hr_utility.trace('datetracked_event_id: '||l_datetrack_ee_tab.datetracked_event_id(i));
2307: hr_utility.trace('element_entry_id: '||l_datetrack_ee_tab.element_entry_id(i));
2308: pay_interpreter_pkg.add_datetrack_event_to_entry
2309: (p_datetracked_evt_id => l_datetrack_ee_tab.datetracked_event_id(i)
2310: ,p_element_entry_id => l_datetrack_ee_tab.element_entry_id(i)
2311: ,p_global_env => l_global_env

Line 2314: hr_utility.trace('Entered all the dte_id X ee_ids');

2310: ,p_element_entry_id => l_datetrack_ee_tab.element_entry_id(i)
2311: ,p_global_env => l_global_env
2312: );
2313: END LOOP;
2314: hr_utility.trace('Entered all the dte_id X ee_ids');
2315:
2316: BEGIN
2317: --call entries_effected
2318: hr_utility.trace('element call to entries_effected');

Line 2318: hr_utility.trace('element call to entries_effected');

2314: hr_utility.trace('Entered all the dte_id X ee_ids');
2315:
2316: BEGIN
2317: --call entries_effected
2318: hr_utility.trace('element call to entries_effected');
2319: pay_interpreter_pkg.entries_affected
2320: (p_assignment_id => p_assignment_id
2321: ,p_mode => p_mode
2322: ,p_start_date => p_start_date

Line 2332: hr_utility.trace('No payroll run for the assignment');

2328: ,p_penserv_mode => p_penserv_mode --vkodedal changes for penserver - 30-apr-2008
2329: );
2330: EXCEPTION
2331: WHEN NO_DATA_FOUND THEN
2332: hr_utility.trace('No payroll run for the assignment');
2333: hr_utility.set_message(8303,'BEN_94629_NO_ASG_ACTION_ID');
2334: hr_utility.raise_error;
2335: END;
2336: -- reset l_global_env

Line 2333: hr_utility.set_message(8303,'BEN_94629_NO_ASG_ACTION_ID');

2329: );
2330: EXCEPTION
2331: WHEN NO_DATA_FOUND THEN
2332: hr_utility.trace('No payroll run for the assignment');
2333: hr_utility.set_message(8303,'BEN_94629_NO_ASG_ACTION_ID');
2334: hr_utility.raise_error;
2335: END;
2336: -- reset l_global_env
2337: pay_interpreter_pkg.clear_dt_event_for_entry

Line 2334: hr_utility.raise_error;

2330: EXCEPTION
2331: WHEN NO_DATA_FOUND THEN
2332: hr_utility.trace('No payroll run for the assignment');
2333: hr_utility.set_message(8303,'BEN_94629_NO_ASG_ACTION_ID');
2334: hr_utility.raise_error;
2335: END;
2336: -- reset l_global_env
2337: pay_interpreter_pkg.clear_dt_event_for_entry
2338: (p_global_env => l_global_env);

Line 2340: hr_utility.trace('Normal call to entries_effected');

2336: -- reset l_global_env
2337: pay_interpreter_pkg.clear_dt_event_for_entry
2338: (p_global_env => l_global_env);
2339: ELSE
2340: hr_utility.trace('Normal call to entries_effected');
2341: --call entry_affected
2342: pay_interpreter_pkg.entry_affected(
2343: p_element_entry_id => NULL
2344: ,p_assignment_action_id => NULL

Line 2359: hr_utility.trace('Leaving: '||l_proc);

2355: ,t_proration_type => l_pro_type_tab -- OUT
2356: ,p_penserv_mode => p_penserv_mode --vkodedal changes for penserver - 30-apr-2008
2357: );
2358: END IF;
2359: hr_utility.trace('Leaving: '||l_proc);
2360: END entries_affected;
2361:
2362: --
2363: END BEN_EXT_UTIL;