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

Line 164: hr_utility.set_location(' Entering: ben_cel_ler', 10);

160: ,dep_appl_id =>805
161: ,status => l_status
162: ,industry => l_industry);
163:
164: hr_utility.set_location(' Entering: ben_cel_ler', 10);
165: l_changed := FALSE;
166: --
167: if p_effective_date is not null then
168: --

Line 181: hr_utility.set_location('l_effective_start_date' || to_char(l_effective_start_date,'dd-mon-yyyy') , 10);

177: end if;
178: --
179: --
180: l_effective_start_date := l_session_date; --for Detected Date
181: hr_utility.set_location('l_effective_start_date' || to_char(l_effective_start_date,'dd-mon-yyyy') , 10);
182: --
183: --
184: -- bug 2862886
185: -- the lf evt occurred date cannot be less than the date the person rec was created.

Line 190: hr_utility.set_location('l_person_date' || to_char(l_person_date,'dd-mon-yyyy') , 10);

186: open get_person_date(p_new.person_id, l_session_date);
187: fetch get_person_date into l_person_date;
188: close get_person_date;
189:
190: hr_utility.set_location('l_person_date' || to_char(l_person_date,'dd-mon-yyyy') , 10);
191: hr_utility.set_location('p_new.effective_date_from' || to_char(p_new.effective_date_from,'dd-mon-yyyy') , 10);
192:
193: l_greatest_date := greatest(l_person_date, nvl(p_new.effective_date_from, l_effective_start_date) );
194: l_effective_start_date := greatest ( l_effective_start_date, l_person_date);

Line 191: hr_utility.set_location('p_new.effective_date_from' || to_char(p_new.effective_date_from,'dd-mon-yyyy') , 10);

187: fetch get_person_date into l_person_date;
188: close get_person_date;
189:
190: hr_utility.set_location('l_person_date' || to_char(l_person_date,'dd-mon-yyyy') , 10);
191: hr_utility.set_location('p_new.effective_date_from' || to_char(p_new.effective_date_from,'dd-mon-yyyy') , 10);
192:
193: l_greatest_date := greatest(l_person_date, nvl(p_new.effective_date_from, l_effective_start_date) );
194: l_effective_start_date := greatest ( l_effective_start_date, l_person_date);
195: hr_utility.set_location(' greatest dt '||l_greatest_date, 987);

Line 195: hr_utility.set_location(' greatest dt '||l_greatest_date, 987);

191: hr_utility.set_location('p_new.effective_date_from' || to_char(p_new.effective_date_from,'dd-mon-yyyy') , 10);
192:
193: l_greatest_date := greatest(l_person_date, nvl(p_new.effective_date_from, l_effective_start_date) );
194: l_effective_start_date := greatest ( l_effective_start_date, l_person_date);
195: hr_utility.set_location(' greatest dt '||l_greatest_date, 987);
196: hr_utility.set_location(' l_effective_start_date '|| l_effective_start_date, 987);
197: --
198:
199:

Line 196: hr_utility.set_location(' l_effective_start_date '|| l_effective_start_date, 987);

192:
193: l_greatest_date := greatest(l_person_date, nvl(p_new.effective_date_from, l_effective_start_date) );
194: l_effective_start_date := greatest ( l_effective_start_date, l_person_date);
195: hr_utility.set_location(' greatest dt '||l_greatest_date, 987);
196: hr_utility.set_location(' l_effective_start_date '|| l_effective_start_date, 987);
197: --
198:
199:
200: hr_utility.set_location('opening get_ler',30);

Line 200: hr_utility.set_location('opening get_ler',30);

196: hr_utility.set_location(' l_effective_start_date '|| l_effective_start_date, 987);
197: --
198:
199:
200: hr_utility.set_location('opening get_ler',30);
201: hr_utility.set_location('l sess date is '||l_session_date,9876);
202:
203: open get_ler(l_status);
204: loop

Line 201: hr_utility.set_location('l sess date is '||l_session_date,9876);

197: --
198:
199:
200: hr_utility.set_location('opening get_ler',30);
201: hr_utility.set_location('l sess date is '||l_session_date,9876);
202:
203: open get_ler(l_status);
204: loop
205: fetch get_ler into l_ler_id,l_typ_cd, l_ocrd_dt_cd;

Line 228: hr_utility.set_location('Life Event Occured date is '||l_lf_evt_ocrd_date,30);

224: ,p_returned_date => l_lf_evt_ocrd_date
225: );
226: end if;
227:
228: hr_utility.set_location('Life Event Occured date is '||l_lf_evt_ocrd_date,30);
229: hr_utility.set_location('l_session_date:'||to_char(l_session_date), 30);
230: hr_utility.set_location('l_effective_start_date: '||to_char(l_effective_start_date),30);
231:
232: --

Line 229: hr_utility.set_location('l_session_date:'||to_char(l_session_date), 30);

225: );
226: end if;
227:
228: hr_utility.set_location('Life Event Occured date is '||l_lf_evt_ocrd_date,30);
229: hr_utility.set_location('l_session_date:'||to_char(l_session_date), 30);
230: hr_utility.set_location('l_effective_start_date: '||to_char(l_effective_start_date),30);
231:
232: --
233: open get_ler_col(l_ler_id);

Line 230: hr_utility.set_location('l_effective_start_date: '||to_char(l_effective_start_date),30);

226: end if;
227:
228: hr_utility.set_location('Life Event Occured date is '||l_lf_evt_ocrd_date,30);
229: hr_utility.set_location('l_session_date:'||to_char(l_session_date), 30);
230: hr_utility.set_location('l_effective_start_date: '||to_char(l_effective_start_date),30);
231:
232: --
233: open get_ler_col(l_ler_id);
234: loop

Line 241: hr_utility.set_location(' ben_cel_ler', 50);

237: if get_ler_col%ROWCOUNT =1 then
238: l_changed := TRUE;
239: end if;
240: l_changed := TRUE;
241: hr_utility.set_location(' ben_cel_ler', 50);
242: hr_utility.set_location('LER '||l_ler_id, 20);
243: hr_utility.set_location('COLUMN '||l_column, 20);
244: hr_utility.set_location('NEWVAL '||l_new_val, 20);
245: hr_utility.set_location('OLDVAL '||l_old_val, 20);

Line 242: hr_utility.set_location('LER '||l_ler_id, 20);

238: l_changed := TRUE;
239: end if;
240: l_changed := TRUE;
241: hr_utility.set_location(' ben_cel_ler', 50);
242: hr_utility.set_location('LER '||l_ler_id, 20);
243: hr_utility.set_location('COLUMN '||l_column, 20);
244: hr_utility.set_location('NEWVAL '||l_new_val, 20);
245: hr_utility.set_location('OLDVAL '||l_old_val, 20);
246: hr_utility.set_location('TYPE '||l_type, 20);

Line 243: hr_utility.set_location('COLUMN '||l_column, 20);

239: end if;
240: l_changed := TRUE;
241: hr_utility.set_location(' ben_cel_ler', 50);
242: hr_utility.set_location('LER '||l_ler_id, 20);
243: hr_utility.set_location('COLUMN '||l_column, 20);
244: hr_utility.set_location('NEWVAL '||l_new_val, 20);
245: hr_utility.set_location('OLDVAL '||l_old_val, 20);
246: hr_utility.set_location('TYPE '||l_type, 20);
247: --

Line 244: hr_utility.set_location('NEWVAL '||l_new_val, 20);

240: l_changed := TRUE;
241: hr_utility.set_location(' ben_cel_ler', 50);
242: hr_utility.set_location('LER '||l_ler_id, 20);
243: hr_utility.set_location('COLUMN '||l_column, 20);
244: hr_utility.set_location('NEWVAL '||l_new_val, 20);
245: hr_utility.set_location('OLDVAL '||l_old_val, 20);
246: hr_utility.set_location('TYPE '||l_type, 20);
247: --
248: -- Call the formula here to evaluate per_info_chg_cs_ler_rl.

Line 245: hr_utility.set_location('OLDVAL '||l_old_val, 20);

241: hr_utility.set_location(' ben_cel_ler', 50);
242: hr_utility.set_location('LER '||l_ler_id, 20);
243: hr_utility.set_location('COLUMN '||l_column, 20);
244: hr_utility.set_location('NEWVAL '||l_new_val, 20);
245: hr_utility.set_location('OLDVAL '||l_old_val, 20);
246: hr_utility.set_location('TYPE '||l_type, 20);
247: --
248: -- Call the formula here to evaluate per_info_chg_cs_ler_rl.
249: -- If it returns Y, then see the applicability of the data

Line 246: hr_utility.set_location('TYPE '||l_type, 20);

242: hr_utility.set_location('LER '||l_ler_id, 20);
243: hr_utility.set_location('COLUMN '||l_column, 20);
244: hr_utility.set_location('NEWVAL '||l_new_val, 20);
245: hr_utility.set_location('OLDVAL '||l_old_val, 20);
246: hr_utility.set_location('TYPE '||l_type, 20);
247: --
248: -- Call the formula here to evaluate per_info_chg_cs_ler_rl.
249: -- If it returns Y, then see the applicability of the data
250: -- changes based on new and old values.

Line 466: hr_utility.set_location('p_old.COMPETENCE_ID '||p_old.COMPETENCE_ID, 111);

462: --
463:
464: --
465: if l_column = 'COMPETENCE_ID' then
466: hr_utility.set_location('p_old.COMPETENCE_ID '||p_old.COMPETENCE_ID, 111);
467: hr_utility.set_location('p_new.COMPETENCE_ID '||p_new.COMPETENCE_ID, 222);
468:
469: l_changed := (benutils.column_changed(p_old.COMPETENCE_ID
470: ,p_new.COMPETENCE_ID,l_new_val) AND

Line 467: hr_utility.set_location('p_new.COMPETENCE_ID '||p_new.COMPETENCE_ID, 222);

463:
464: --
465: if l_column = 'COMPETENCE_ID' then
466: hr_utility.set_location('p_old.COMPETENCE_ID '||p_old.COMPETENCE_ID, 111);
467: hr_utility.set_location('p_new.COMPETENCE_ID '||p_new.COMPETENCE_ID, 222);
468:
469: l_changed := (benutils.column_changed(p_old.COMPETENCE_ID
470: ,p_new.COMPETENCE_ID,l_new_val) AND
471: benutils.column_changed(p_new.COMPETENCE_ID

Line 477: hr_utility.set_location('p_old.PROFICIENCY_LEVEL_ID '||p_old.PROFICIENCY_LEVEL_ID, 111);

473: (l_changed));
474: end if;
475: --
476: if l_column = 'PROFICIENCY_LEVEL_ID' then
477: hr_utility.set_location('p_old.PROFICIENCY_LEVEL_ID '||p_old.PROFICIENCY_LEVEL_ID, 111);
478: hr_utility.set_location('p_new.PROFICIENCY_LEVEL_ID '||p_new.PROFICIENCY_LEVEL_ID, 222);
479: l_changed := (benutils.column_changed(p_old.PROFICIENCY_LEVEL_ID
480: ,p_new.PROFICIENCY_LEVEL_ID,l_new_val) AND
481: benutils.column_changed(p_new.PROFICIENCY_LEVEL_ID

Line 478: hr_utility.set_location('p_new.PROFICIENCY_LEVEL_ID '||p_new.PROFICIENCY_LEVEL_ID, 222);

474: end if;
475: --
476: if l_column = 'PROFICIENCY_LEVEL_ID' then
477: hr_utility.set_location('p_old.PROFICIENCY_LEVEL_ID '||p_old.PROFICIENCY_LEVEL_ID, 111);
478: hr_utility.set_location('p_new.PROFICIENCY_LEVEL_ID '||p_new.PROFICIENCY_LEVEL_ID, 222);
479: l_changed := (benutils.column_changed(p_old.PROFICIENCY_LEVEL_ID
480: ,p_new.PROFICIENCY_LEVEL_ID,l_new_val) AND
481: benutils.column_changed(p_new.PROFICIENCY_LEVEL_ID
482: ,p_old.PROFICIENCY_LEVEL_ID,l_old_val) AND

Line 488: hr_utility.set_location('p_old.EFFECTIVE_DATE_FROM '||p_old.EFFECTIVE_DATE_FROM, 111);

484: end if;
485: --
486:
487: if l_column = 'EFFECTIVE_DATE_FROM' then
488: hr_utility.set_location('p_old.EFFECTIVE_DATE_FROM '||p_old.EFFECTIVE_DATE_FROM, 111);
489: hr_utility.set_location('p_new.EFFECTIVE_DATE_FROM '||p_new.EFFECTIVE_DATE_FROM, 222);
490:
491: l_changed := (benutils.column_changed(p_old.EFFECTIVE_DATE_FROM
492: ,p_new.EFFECTIVE_DATE_FROM,l_new_val) AND

Line 489: hr_utility.set_location('p_new.EFFECTIVE_DATE_FROM '||p_new.EFFECTIVE_DATE_FROM, 222);

485: --
486:
487: if l_column = 'EFFECTIVE_DATE_FROM' then
488: hr_utility.set_location('p_old.EFFECTIVE_DATE_FROM '||p_old.EFFECTIVE_DATE_FROM, 111);
489: hr_utility.set_location('p_new.EFFECTIVE_DATE_FROM '||p_new.EFFECTIVE_DATE_FROM, 222);
490:
491: l_changed := (benutils.column_changed(p_old.EFFECTIVE_DATE_FROM
492: ,p_new.EFFECTIVE_DATE_FROM,l_new_val) AND
493: benutils.column_changed(p_new.EFFECTIVE_DATE_FROM

Line 499: hr_utility.set_location('p_old.EFFECTIVE_DATE_TO '||p_old.EFFECTIVE_DATE_TO, 111);

495: (l_changed));
496: end if;
497: --
498: if l_column = 'EFFECTIVE_DATE_TO' then
499: hr_utility.set_location('p_old.EFFECTIVE_DATE_TO '||p_old.EFFECTIVE_DATE_TO, 111);
500: hr_utility.set_location('p_new.EFFECTIVE_DATE_TO '||p_new.EFFECTIVE_DATE_TO, 222);
501:
502:
503: l_changed := (benutils.column_changed(p_old.EFFECTIVE_DATE_TO

Line 500: hr_utility.set_location('p_new.EFFECTIVE_DATE_TO '||p_new.EFFECTIVE_DATE_TO, 222);

496: end if;
497: --
498: if l_column = 'EFFECTIVE_DATE_TO' then
499: hr_utility.set_location('p_old.EFFECTIVE_DATE_TO '||p_old.EFFECTIVE_DATE_TO, 111);
500: hr_utility.set_location('p_new.EFFECTIVE_DATE_TO '||p_new.EFFECTIVE_DATE_TO, 222);
501:
502:
503: l_changed := (benutils.column_changed(p_old.EFFECTIVE_DATE_TO
504: ,p_new.EFFECTIVE_DATE_TO,l_new_val) AND

Line 695: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);

691: l_changed := TRUE ;
692: elsif l_rule_output = 'Y' and l_rule_overrides_flag = 'N' then
693: l_changed := l_changed AND TRUE;
694: elsif l_rule_output = 'N' then
695: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
696: l_changed := FALSE;
697: end if;
698:
699: hr_utility.set_location('After the rule Check ',20.05);

Line 699: hr_utility.set_location('After the rule Check ',20.05);

695: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
696: l_changed := FALSE;
697: end if;
698:
699: hr_utility.set_location('After the rule Check ',20.05);
700: if l_changed then
701: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
702: else
703: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);

Line 701: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);

697: end if;
698:
699: hr_utility.set_location('After the rule Check ',20.05);
700: if l_changed then
701: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
702: else
703: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
704: end if;
705: -- Check for Column Mandatory Change

Line 703: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);

699: hr_utility.set_location('After the rule Check ',20.05);
700: if l_changed then
701: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
702: else
703: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
704: end if;
705: -- Check for Column Mandatory Change
706: -- If column change is mandatory and data change has failed then dont trigger
707: -- If column change is non-mandatory and the data change has passed, then trigger.

Line 710: hr_utility.set_location('Found Mandatory and its failed ', 20.1);

706: -- If column change is mandatory and data change has failed then dont trigger
707: -- If column change is non-mandatory and the data change has passed, then trigger.
708:
709: if l_chg_mandatory_cd = 'Y' and not l_changed then
710: hr_utility.set_location('Found Mandatory and its failed ', 20.1);
711: l_changed := FALSE;
712: l_trigger := FALSE;
713: exit;
714: elsif l_chg_mandatory_cd = 'Y' and l_changed then

Line 715: hr_utility.set_location('Found Mandatory and its passed ', 20.1);

711: l_changed := FALSE;
712: l_trigger := FALSE;
713: exit;
714: elsif l_chg_mandatory_cd = 'Y' and l_changed then
715: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
716: l_changed := TRUE;
717: -- exit; */
718: elsif l_chg_mandatory_cd = 'N' and l_changed then
719: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);

Line 719: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);

715: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
716: l_changed := TRUE;
717: -- exit; */
718: elsif l_chg_mandatory_cd = 'N' and l_changed then
719: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);
720: l_changed := TRUE;
721: l_trigger := TRUE;
722: exit;
723: end if;

Line 725: hr_utility.set_location('After the Mandatory code check ',20.05);

721: l_trigger := TRUE;
722: exit;
723: end if;
724:
725: hr_utility.set_location('After the Mandatory code check ',20.05);
726: if l_changed then
727: hr_utility.set_location(' l_change TRUE ', 20.1);
728: else
729: hr_utility.set_location(' l_change FALSE ', 20.1);

Line 727: hr_utility.set_location(' l_change TRUE ', 20.1);

723: end if;
724:
725: hr_utility.set_location('After the Mandatory code check ',20.05);
726: if l_changed then
727: hr_utility.set_location(' l_change TRUE ', 20.1);
728: else
729: hr_utility.set_location(' l_change FALSE ', 20.1);
730: end if;
731: --

Line 729: hr_utility.set_location(' l_change FALSE ', 20.1);

725: hr_utility.set_location('After the Mandatory code check ',20.05);
726: if l_changed then
727: hr_utility.set_location(' l_change TRUE ', 20.1);
728: else
729: hr_utility.set_location(' l_change FALSE ', 20.1);
730: end if;
731: --
732: /* if not l_changed then
733: exit;

Line 737: hr_utility.set_location(' ben_cel_trigger', 30);

733: exit;
734: end if; */
735: --
736: end loop;
737: hr_utility.set_location(' ben_cel_trigger', 30);
738: if l_changed then
739: hr_utility.set_location('Change detected', 30);
740: end if;
741: l_ptnl_id := 0;

Line 739: hr_utility.set_location('Change detected', 30);

735: --
736: end loop;
737: hr_utility.set_location(' ben_cel_trigger', 30);
738: if l_changed then
739: hr_utility.set_location('Change detected', 30);
740: end if;
741: l_ptnl_id := 0;
742: l_ovn :=null;
743: if l_trigger then

Line 748: hr_utility.set_location(' Entering: ben_cel_trigger5', 60);

744: if l_type = 'P' then
745: open le_exists(p_new.person_id,l_ler_id,l_lf_evt_ocrd_date);
746: fetch le_exists into l_le_exists;
747: if le_exists%notfound then
748: hr_utility.set_location(' Entering: ben_cel_trigger5', 60);
749:
750: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
751: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
752: (p_validate => false

Line 767: hr_utility.set_location(' Entering: ben_cel_trigger5-', 65);

763: ,p_dtctd_dt => l_lf_evt_ocrd_date);
764: end if;
765: close le_exists;
766: elsif l_type = 'R' then
767: hr_utility.set_location(' Entering: ben_cel_trigger5-', 65);
768: open get_contacts(p_new.person_id);
769: loop
770: fetch get_contacts into l_hld_person_id;
771: exit when get_contacts%notfound;

Line 775: hr_utility.set_location(' Entering: ben_cel_trigger5', 60);

771: exit when get_contacts%notfound;
772: open le_exists(l_hld_person_id,l_ler_id,l_lf_evt_ocrd_date);
773: fetch le_exists into l_le_exists;
774: if le_exists%notfound then
775: hr_utility.set_location(' Entering: ben_cel_trigger5', 60);
776:
777: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
778: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
779: (p_validate => false

Line 801: hr_utility.set_location(' ben_cel_ler', 100);

797: end if;
798: --
799: -- reset the variables.
800: --
801: hr_utility.set_location(' ben_cel_ler', 100);
802: l_changed := FALSE;
803: l_trigger := TRUE;
804: l_ovn := NULL;
805: end if;

Line 808: hr_utility.set_location(' ben_cel_ler', 110);

804: l_ovn := NULL;
805: end if;
806: close get_ler_col;
807: end loop;
808: hr_utility.set_location(' ben_cel_ler', 110);
809: close get_ler;
810: hr_utility.set_location(' Leaving: ben_cel_ler', 120);
811:
812: end;

Line 810: hr_utility.set_location(' Leaving: ben_cel_ler', 120);

806: close get_ler_col;
807: end loop;
808: hr_utility.set_location(' ben_cel_ler', 110);
809: close get_ler;
810: hr_utility.set_location(' Leaving: ben_cel_ler', 120);
811:
812: end;
813: end ben_cel_ler;