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 150: hr_utility.set_location('Entering'||l_proc, 5);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

819: --
820: DBMS_SQL.CLOSE_CURSOR(l_cid);
821: --
822: --
823: hr_utility.set_location('Exiting'||l_proc, 5);
824: --
825: return(l_value);
826: --
827: END get_value;

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

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

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

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

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

924: );
925: end if;
926: --
927: hr_utility.set_location('chg start date ' || p_chg_eff_strt_dt , 9185);
928: hr_utility.set_location('chg End date ' || p_chg_eff_end_dt , 9185);
929: hr_utility.set_location('Exiting'||l_proc, 5);
930: --
931: End get_chg_dates;
932: --

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

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

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

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

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

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

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

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

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

987: p_ext_dfn_id => p_ext_dfn_id
988: );
989: end if;
990: --
991: hr_utility.set_location('cm start date ' || p_to_be_sent_strt_dt , 9185);
992: hr_utility.set_location('cm End date ' || p_to_be_sent_end_dt , 9185);
993:
994: hr_utility.set_location('Exiting'||l_proc, 5);
995: --

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

988: );
989: end if;
990: --
991: hr_utility.set_location('cm start date ' || p_to_be_sent_strt_dt , 9185);
992: hr_utility.set_location('cm End date ' || p_to_be_sent_end_dt , 9185);
993:
994: hr_utility.set_location('Exiting'||l_proc, 5);
995: --
996: End get_cm_dates;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1210:
1211: p_person_ext_dt := nvl(l_person_dt , p_effective_date );
1212: p_benefits_ext_dt := nvl(l_benefits_dt, p_effective_date);
1213: --
1214: hr_utility.set_location('l_person_dt_cd '||l_person_dt_cd||' / '||p_person_ext_dt , 5);
1215: hr_utility.set_location('l_benefits_dt_cd '||l_benefits_dt_cd||' / '|| p_benefits_ext_dt ,5);
1216: hr_utility.set_location('Exiting'||l_proc, 5);
1217: --
1218: End get_ext_dates;

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

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

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

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

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

1257:
1258: --
1259: Begin
1260: --
1261: hr_utility.set_location('Entering:'||l_proc, 5);
1262: hr_utility.set_location('date '||p_abs_date, 5);
1263: --
1264: -- User entered date
1265: --

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

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

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

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

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

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

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

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

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

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

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

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

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

1846: --
1847: end if;
1848: --
1849:
1850: hr_utility.set_location(' ext_date : '||p_ext_date_cd ||l_rslt_dt, 185);
1851: hr_utility.set_location(' Exiting:'||l_proc, 15);
1852:
1853: return (l_rslt_dt);
1854: --

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2069: END LOOP; -- i loop
2070:
2071: END LOOP; -- element set loop ...
2072:
2073: hr_utility.trace('Count:'||to_char(p_element_entries_tab.element_entry_id.COUNT));
2074:
2075: hr_utility.trace('Leaving: '||l_proc);
2076: RETURN p_element_entries_tab.element_entry_id.COUNT;
2077:

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

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

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

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

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

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

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

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

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

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

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

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

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

2192:
2193: end if ;
2194: end if ;
2195:
2196: hr_utility.set_location('Exiting '|| l_return ||l_proc, 10);
2197: Return l_return ;
2198:
2199: End event_element_exists ;
2200:

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

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

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

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

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

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

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

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

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

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

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

2296: hr_utility.trace(' call add_datetrack_event_to_entry for collection ');
2297:
2298: FOR i IN l_datetrack_ee_tab.element_entry_id.FIRST..l_datetrack_ee_tab.element_entry_id.LAST
2299: LOOP
2300: hr_utility.trace('----------------------------------');
2301: hr_utility.trace('i: '||i);
2302: hr_utility.trace('datetracked_event_id: '||l_datetrack_ee_tab.datetracked_event_id(i));
2303: hr_utility.trace('element_entry_id: '||l_datetrack_ee_tab.element_entry_id(i));
2304: pay_interpreter_pkg.add_datetrack_event_to_entry

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

2297:
2298: FOR i IN l_datetrack_ee_tab.element_entry_id.FIRST..l_datetrack_ee_tab.element_entry_id.LAST
2299: LOOP
2300: hr_utility.trace('----------------------------------');
2301: hr_utility.trace('i: '||i);
2302: hr_utility.trace('datetracked_event_id: '||l_datetrack_ee_tab.datetracked_event_id(i));
2303: hr_utility.trace('element_entry_id: '||l_datetrack_ee_tab.element_entry_id(i));
2304: pay_interpreter_pkg.add_datetrack_event_to_entry
2305: (p_datetracked_evt_id => l_datetrack_ee_tab.datetracked_event_id(i)

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

2298: FOR i IN l_datetrack_ee_tab.element_entry_id.FIRST..l_datetrack_ee_tab.element_entry_id.LAST
2299: LOOP
2300: hr_utility.trace('----------------------------------');
2301: hr_utility.trace('i: '||i);
2302: hr_utility.trace('datetracked_event_id: '||l_datetrack_ee_tab.datetracked_event_id(i));
2303: hr_utility.trace('element_entry_id: '||l_datetrack_ee_tab.element_entry_id(i));
2304: pay_interpreter_pkg.add_datetrack_event_to_entry
2305: (p_datetracked_evt_id => l_datetrack_ee_tab.datetracked_event_id(i)
2306: ,p_element_entry_id => l_datetrack_ee_tab.element_entry_id(i)

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

2299: LOOP
2300: hr_utility.trace('----------------------------------');
2301: hr_utility.trace('i: '||i);
2302: hr_utility.trace('datetracked_event_id: '||l_datetrack_ee_tab.datetracked_event_id(i));
2303: hr_utility.trace('element_entry_id: '||l_datetrack_ee_tab.element_entry_id(i));
2304: pay_interpreter_pkg.add_datetrack_event_to_entry
2305: (p_datetracked_evt_id => l_datetrack_ee_tab.datetracked_event_id(i)
2306: ,p_element_entry_id => l_datetrack_ee_tab.element_entry_id(i)
2307: ,p_global_env => l_global_env

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

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

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

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

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

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

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

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

Line 2330: hr_utility.raise_error;

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

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

2332: -- reset l_global_env
2333: pay_interpreter_pkg.clear_dt_event_for_entry
2334: (p_global_env => l_global_env);
2335: ELSE
2336: hr_utility.trace('Normal call to entries_effected');
2337: --call entry_affected
2338: pay_interpreter_pkg.entry_affected(
2339: p_element_entry_id => NULL
2340: ,p_assignment_action_id => NULL

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

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