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

Line 176: hr_utility.set_location(' No DM ' || l_proc, 10);

172: -- Not to be called when Data Migrator is in progress
173: --
174: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
175: --
176: hr_utility.set_location(' No DM ' || l_proc, 10);
177: --
178: -- Check if truncated sysdate global has previously been set
179: -- if not then set it
180: --

Line 212: hr_utility.set_location(' Entering: ben_egd_trigger', 10);

208: IF l_status = 'I' THEN
209: */
210: -- commented since the L_status check is available in the beltrgch cursor itself.
211:
212: hr_utility.set_location(' Entering: ben_egd_trigger', 10);
213: --
214: -- Check if oab install status global has previously been set
215: -- if not then set it
216: --

Line 226: hr_utility.set_location(' ben_egd_trigger', 20);

222: -- use session date instead.
223: l_elig_strt_dt := NVL(p_new.elig_strt_dt, l_session_date);
224: l_elig_thru_dt := NVL(p_new.elig_thru_dt, l_session_date);
225: l_create_dt := NVL(p_new.create_dt, l_session_date);
226: hr_utility.set_location(' ben_egd_trigger', 20);
227: --
228: -- Get the ler details list
229: --
230: hr_utility.set_location(' LE EGD Cac ' || l_proc, 10);

Line 230: hr_utility.set_location(' LE EGD Cac ' || l_proc, 10);

226: hr_utility.set_location(' ben_egd_trigger', 20);
227: --
228: -- Get the ler details list
229: --
230: hr_utility.set_location(' LE EGD Cac ' || l_proc, 10);
231: ben_letrg_cache.get_egdlertrg_dets
232: (p_business_group_id => p_new.business_group_id
233: ,p_effective_date => l_session_date
234: ,p_inst_set => l_egdlertrg_set

Line 236: hr_utility.set_location(' Dn LE EGD Cac ' || l_proc, 10);

232: (p_business_group_id => p_new.business_group_id
233: ,p_effective_date => l_session_date
234: ,p_inst_set => l_egdlertrg_set
235: );
236: hr_utility.set_location(' Dn LE EGD Cac ' || l_proc, 10);
237: --
238: if l_egdlertrg_set.count > 0 then
239: --
240: for ler_row in l_egdlertrg_set.first..l_egdlertrg_set.last loop

Line 268: hr_utility.set_location('LER ' || l_egdlertrg_set(ler_row).ler_id, 20);

264: l_old_val,
265: l_type,
266: l_per_info_chg_cs_ler_rl, l_rule_overrides_flag, l_chg_mandatory_cd;
267: EXIT get_ler_col_loop WHEN get_ler_col%NOTFOUND;
268: hr_utility.set_location('LER ' || l_egdlertrg_set(ler_row).ler_id, 20);
269: hr_utility.set_location('COLUMN ' || l_column, 20);
270: hr_utility.set_location('NEWVAL ' || l_new_val, 20);
271: hr_utility.set_location('OLDVAL ' || l_old_val, 20);
272: hr_utility.set_location('TYPE ' || l_type, 20);

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

265: l_type,
266: l_per_info_chg_cs_ler_rl, l_rule_overrides_flag, l_chg_mandatory_cd;
267: EXIT get_ler_col_loop WHEN get_ler_col%NOTFOUND;
268: hr_utility.set_location('LER ' || l_egdlertrg_set(ler_row).ler_id, 20);
269: hr_utility.set_location('COLUMN ' || l_column, 20);
270: hr_utility.set_location('NEWVAL ' || l_new_val, 20);
271: hr_utility.set_location('OLDVAL ' || l_old_val, 20);
272: hr_utility.set_location('TYPE ' || l_type, 20);
273: hr_utility.set_location('CD ' || l_egdlertrg_set(ler_row).ocrd_dt_det_cd, 20);

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

266: l_per_info_chg_cs_ler_rl, l_rule_overrides_flag, l_chg_mandatory_cd;
267: EXIT get_ler_col_loop WHEN get_ler_col%NOTFOUND;
268: hr_utility.set_location('LER ' || l_egdlertrg_set(ler_row).ler_id, 20);
269: hr_utility.set_location('COLUMN ' || l_column, 20);
270: hr_utility.set_location('NEWVAL ' || l_new_val, 20);
271: hr_utility.set_location('OLDVAL ' || l_old_val, 20);
272: hr_utility.set_location('TYPE ' || l_type, 20);
273: hr_utility.set_location('CD ' || l_egdlertrg_set(ler_row).ocrd_dt_det_cd, 20);
274: hr_utility.set_location('create dt' || l_create_dt, 20);

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

267: EXIT get_ler_col_loop WHEN get_ler_col%NOTFOUND;
268: hr_utility.set_location('LER ' || l_egdlertrg_set(ler_row).ler_id, 20);
269: hr_utility.set_location('COLUMN ' || l_column, 20);
270: hr_utility.set_location('NEWVAL ' || l_new_val, 20);
271: hr_utility.set_location('OLDVAL ' || l_old_val, 20);
272: hr_utility.set_location('TYPE ' || l_type, 20);
273: hr_utility.set_location('CD ' || l_egdlertrg_set(ler_row).ocrd_dt_det_cd, 20);
274: hr_utility.set_location('create dt' || l_create_dt, 20);
275: hr_utility.set_location('elig strt dt ' || l_elig_strt_dt, 20);

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

268: hr_utility.set_location('LER ' || l_egdlertrg_set(ler_row).ler_id, 20);
269: hr_utility.set_location('COLUMN ' || l_column, 20);
270: hr_utility.set_location('NEWVAL ' || l_new_val, 20);
271: hr_utility.set_location('OLDVAL ' || l_old_val, 20);
272: hr_utility.set_location('TYPE ' || l_type, 20);
273: hr_utility.set_location('CD ' || l_egdlertrg_set(ler_row).ocrd_dt_det_cd, 20);
274: hr_utility.set_location('create dt' || l_create_dt, 20);
275: hr_utility.set_location('elig strt dt ' || l_elig_strt_dt, 20);
276: hr_utility.set_location('elig thru dt ' || l_elig_thru_dt, 20);

Line 273: hr_utility.set_location('CD ' || l_egdlertrg_set(ler_row).ocrd_dt_det_cd, 20);

269: hr_utility.set_location('COLUMN ' || l_column, 20);
270: hr_utility.set_location('NEWVAL ' || l_new_val, 20);
271: hr_utility.set_location('OLDVAL ' || l_old_val, 20);
272: hr_utility.set_location('TYPE ' || l_type, 20);
273: hr_utility.set_location('CD ' || l_egdlertrg_set(ler_row).ocrd_dt_det_cd, 20);
274: hr_utility.set_location('create dt' || l_create_dt, 20);
275: hr_utility.set_location('elig strt dt ' || l_elig_strt_dt, 20);
276: hr_utility.set_location('elig thru dt ' || l_elig_thru_dt, 20);
277: l_changed := TRUE;

Line 274: hr_utility.set_location('create dt' || l_create_dt, 20);

270: hr_utility.set_location('NEWVAL ' || l_new_val, 20);
271: hr_utility.set_location('OLDVAL ' || l_old_val, 20);
272: hr_utility.set_location('TYPE ' || l_type, 20);
273: hr_utility.set_location('CD ' || l_egdlertrg_set(ler_row).ocrd_dt_det_cd, 20);
274: hr_utility.set_location('create dt' || l_create_dt, 20);
275: hr_utility.set_location('elig strt dt ' || l_elig_strt_dt, 20);
276: hr_utility.set_location('elig thru dt ' || l_elig_thru_dt, 20);
277: l_changed := TRUE;
278: if get_ler_col%ROWCOUNT = 1 then

Line 275: hr_utility.set_location('elig strt dt ' || l_elig_strt_dt, 20);

271: hr_utility.set_location('OLDVAL ' || l_old_val, 20);
272: hr_utility.set_location('TYPE ' || l_type, 20);
273: hr_utility.set_location('CD ' || l_egdlertrg_set(ler_row).ocrd_dt_det_cd, 20);
274: hr_utility.set_location('create dt' || l_create_dt, 20);
275: hr_utility.set_location('elig strt dt ' || l_elig_strt_dt, 20);
276: hr_utility.set_location('elig thru dt ' || l_elig_thru_dt, 20);
277: l_changed := TRUE;
278: if get_ler_col%ROWCOUNT = 1 then
279: l_changed := TRUE;

Line 276: hr_utility.set_location('elig thru dt ' || l_elig_thru_dt, 20);

272: hr_utility.set_location('TYPE ' || l_type, 20);
273: hr_utility.set_location('CD ' || l_egdlertrg_set(ler_row).ocrd_dt_det_cd, 20);
274: hr_utility.set_location('create dt' || l_create_dt, 20);
275: hr_utility.set_location('elig strt dt ' || l_elig_strt_dt, 20);
276: hr_utility.set_location('elig thru dt ' || l_elig_thru_dt, 20);
277: l_changed := TRUE;
278: if get_ler_col%ROWCOUNT = 1 then
279: l_changed := TRUE;
280: END IF;

Line 281: hr_utility.set_location(' ben_egd_trigger', 50);

277: l_changed := TRUE;
278: if get_ler_col%ROWCOUNT = 1 then
279: l_changed := TRUE;
280: END IF;
281: hr_utility.set_location(' ben_egd_trigger', 50);
282: --
283: -- Call the formula here to evaluate per_info_chg_cs_ler_rl.
284: -- If it returns Y, then see the applicability of the data
285: -- changes based on new and old values.

Line 417: hr_utility.set_location(' l_changed:', 40);

413: p_new.elig_strt_dt,
414: p_old.elig_strt_dt,
415: l_old_val)
416: AND (l_changed));
417: hr_utility.set_location(' l_changed:', 40);
418: ELSIF l_column = 'ELIG_THRU_DT' THEN
419: l_changed :=
420: (
421: benutils.column_changed(

Line 497: hr_utility.set_location(

493: p_returned_date => l_lf_evt_ocrd_date);
494: END IF;
495: --
496: ELSIF l_column = 'OVRDN_FLAG' THEN
497: hr_utility.set_location(
498: 'Old ovrdn_flag ' || p_old.ovrdn_flag,
499: 20);
500: hr_utility.set_location(
501: 'New ovrdn_flag ' || p_new.ovrdn_flag,

Line 500: hr_utility.set_location(

496: ELSIF l_column = 'OVRDN_FLAG' THEN
497: hr_utility.set_location(
498: 'Old ovrdn_flag ' || p_old.ovrdn_flag,
499: 20);
500: hr_utility.set_location(
501: 'New ovrdn_flag ' || p_new.ovrdn_flag,
502: 20);
503: hr_utility.set_location('lodt ' || l_lf_evt_ocrd_date, 20);
504: l_changed :=

Line 503: hr_utility.set_location('lodt ' || l_lf_evt_ocrd_date, 20);

499: 20);
500: hr_utility.set_location(
501: 'New ovrdn_flag ' || p_new.ovrdn_flag,
502: 20);
503: hr_utility.set_location('lodt ' || l_lf_evt_ocrd_date, 20);
504: l_changed :=
505: (
506: benutils.column_changed(
507: p_old.ovrdn_flag,

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

538: l_changed := TRUE ;
539: elsif l_rule_output = 'Y' and l_rule_overrides_flag = 'N' then
540: l_changed := l_changed AND TRUE;
541: elsif l_rule_output = 'N' then
542: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
543: l_changed := FALSE;
544: end if;
545:
546: hr_utility.set_location('After the rule Check ',20.05);

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

542: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
543: l_changed := FALSE;
544: end if;
545:
546: hr_utility.set_location('After the rule Check ',20.05);
547: if l_changed then
548: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
549: else
550: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);

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

544: end if;
545:
546: hr_utility.set_location('After the rule Check ',20.05);
547: if l_changed then
548: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
549: else
550: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
551: end if;
552: -- Check for Column Mandatory Change

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

546: hr_utility.set_location('After the rule Check ',20.05);
547: if l_changed then
548: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
549: else
550: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
551: end if;
552: -- Check for Column Mandatory Change
553: -- If column change is mandatory and data change has failed then dont trigger
554: -- If column change is non-mandatory and the data change has passed, then trigger.

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

553: -- If column change is mandatory and data change has failed then dont trigger
554: -- If column change is non-mandatory and the data change has passed, then trigger.
555:
556: if l_chg_mandatory_cd = 'Y' and not l_changed then
557: hr_utility.set_location('Found Mandatory and its failed ', 20.1);
558: l_changed := FALSE;
559: l_trigger := FALSE;
560: exit;
561: elsif l_chg_mandatory_cd = 'Y' and l_changed then

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

558: l_changed := FALSE;
559: l_trigger := FALSE;
560: exit;
561: elsif l_chg_mandatory_cd = 'Y' and l_changed then
562: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
563: l_changed := TRUE;
564: -- exit; */
565: elsif l_chg_mandatory_cd = 'N' and l_changed then
566: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);

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

562: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
563: l_changed := TRUE;
564: -- exit; */
565: elsif l_chg_mandatory_cd = 'N' and l_changed then
566: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);
567: l_changed := TRUE;
568: l_trigger := TRUE;
569: exit;
570: end if;

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

568: l_trigger := TRUE;
569: exit;
570: end if;
571:
572: hr_utility.set_location('After the Mandatory code check ',20.05);
573: if l_changed then
574: hr_utility.set_location(' l_change TRUE ', 20.1);
575: else
576: hr_utility.set_location(' l_change FALSE ', 20.1);

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

570: end if;
571:
572: hr_utility.set_location('After the Mandatory code check ',20.05);
573: if l_changed then
574: hr_utility.set_location(' l_change TRUE ', 20.1);
575: else
576: hr_utility.set_location(' l_change FALSE ', 20.1);
577: end if;
578: --

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

572: hr_utility.set_location('After the Mandatory code check ',20.05);
573: if l_changed then
574: hr_utility.set_location(' l_change TRUE ', 20.1);
575: else
576: hr_utility.set_location(' l_change FALSE ', 20.1);
577: end if;
578: --
579: /* if not l_changed then
580: exit;

Line 584: hr_utility.set_location(' ben_egd_trigger', 50);

580: exit;
581: end if; */
582:
583: END LOOP get_ler_col_loop;
584: hr_utility.set_location(' ben_egd_trigger', 50);
585: l_ptnl_id := 0;
586: l_ovn := NULL;
587:
588: --Bug 5630251

Line 596: hr_utility.set_location('l_person_id' || l_person_id , 50);

592: if get_person%notfound then
593: l_person_id := -999999999;
594: end if;
595:
596: hr_utility.set_location('l_person_id' || l_person_id , 50);
597: hr_utility.set_location('per_in_ler_id' || p_new.per_in_ler_id, 50);
598:
599: close get_person;
600: --End Bug 5630251

Line 597: hr_utility.set_location('per_in_ler_id' || p_new.per_in_ler_id, 50);

593: l_person_id := -999999999;
594: end if;
595:
596: hr_utility.set_location('l_person_id' || l_person_id , 50);
597: hr_utility.set_location('per_in_ler_id' || p_new.per_in_ler_id, 50);
598:
599: close get_person;
600: --End Bug 5630251
601:

Line 607: hr_utility.set_location(' Entering: ben_egd_trigger5', 60);

603: IF l_type = 'P' THEN
604: OPEN le_exists(l_person_id, l_ler_id, l_lf_evt_ocrd_date); --Bug 5630251
605: FETCH le_exists INTO l_le_exists;
606: IF le_exists%NOTFOUND THEN
607: hr_utility.set_location(' Entering: ben_egd_trigger5', 60);
608:
609: ben_create_ptnl_ler_for_per.create_ptnl_ler_event(
610: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per(
611: p_validate => FALSE,

Line 626: hr_utility.set_location(' Entering: ben_egd_trigger5-', 65);

622: p_dtctd_dt => l_effective_start_date);
623: END IF;
624: CLOSE le_exists;
625: ELSIF l_type = 'R' THEN
626: hr_utility.set_location(' Entering: ben_egd_trigger5-', 65);
627: OPEN get_contacts(l_person_id); --Bug 5630251
628: <>
629: LOOP
630: FETCH get_contacts INTO l_hld_person_id;

Line 635: hr_utility.set_location(' Entering: ben_egd_trigger5', 60);

631: EXIT get_contacts_loop WHEN get_contacts%NOTFOUND;
632: OPEN le_exists(l_hld_person_id, l_ler_id, l_lf_evt_ocrd_date);
633: FETCH le_exists INTO l_le_exists;
634: IF le_exists%NOTFOUND THEN
635: hr_utility.set_location(' Entering: ben_egd_trigger5', 60);
636:
637: ben_create_ptnl_ler_for_per.create_ptnl_ler_event(
638: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per(
639: p_validate => FALSE,

Line 669: hr_utility.set_location(' Dn get_ler loop ' || l_proc, 10);

665: -- l_lf_evt_ocrd_date := l_session_date;
666: END IF;
667: CLOSE get_ler_col;
668: END LOOP get_ler_loop;
669: hr_utility.set_location(' Dn get_ler loop ' || l_proc, 10);
670: -- END IF;
671: END IF;
672: END IF;
673: END ler_chk;