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 198: hr_utility.set_location(' No DM ' || l_proc, 10);

194: -- Not to be called when Data Migrator is in progress
195: --
196: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
197: --
198: hr_utility.set_location(' No DM ' || l_proc, 10);
199: --
200: -- Check if truncated sysdate global has previously been set
201: -- if not then set it
202: --

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

230: IF l_status = 'I' THEN
231: */
232: -- commented since the L_status check is available in the beltrgch cursor itself.
233:
234: hr_utility.set_location(' Entering: ben_egd_trigger', 10);
235: --
236: -- Check if oab install status global has previously been set
237: -- if not then set it
238: --

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

244: -- use session date instead.
245: l_elig_strt_dt := NVL(p_new.elig_strt_dt, l_session_date);
246: l_elig_thru_dt := NVL(p_new.elig_thru_dt, l_session_date);
247: l_create_dt := NVL(p_new.create_dt, l_session_date);
248: hr_utility.set_location(' ben_egd_trigger', 20);
249: --
250: -- Get the ler details list
251: --
252: hr_utility.set_location(' LE EGD Cac ' || l_proc, 10);

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

248: hr_utility.set_location(' ben_egd_trigger', 20);
249: --
250: -- Get the ler details list
251: --
252: hr_utility.set_location(' LE EGD Cac ' || l_proc, 10);
253: ben_letrg_cache.get_egdlertrg_dets
254: (p_business_group_id => p_new.business_group_id
255: ,p_effective_date => l_session_date
256: ,p_inst_set => l_egdlertrg_set

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

254: (p_business_group_id => p_new.business_group_id
255: ,p_effective_date => l_session_date
256: ,p_inst_set => l_egdlertrg_set
257: );
258: hr_utility.set_location(' Dn LE EGD Cac ' || l_proc, 10);
259: --
260: if l_egdlertrg_set.count > 0 then
261: --
262: for ler_row in l_egdlertrg_set.first..l_egdlertrg_set.last loop

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

286: l_old_val,
287: l_type,
288: l_per_info_chg_cs_ler_rl, l_rule_overrides_flag, l_chg_mandatory_cd;
289: EXIT get_ler_col_loop WHEN get_ler_col%NOTFOUND;
290: hr_utility.set_location('LER ' || l_egdlertrg_set(ler_row).ler_id, 20);
291: hr_utility.set_location('COLUMN ' || l_column, 20);
292: hr_utility.set_location('NEWVAL ' || l_new_val, 20);
293: hr_utility.set_location('OLDVAL ' || l_old_val, 20);
294: hr_utility.set_location('TYPE ' || l_type, 20);

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

287: l_type,
288: l_per_info_chg_cs_ler_rl, l_rule_overrides_flag, l_chg_mandatory_cd;
289: EXIT get_ler_col_loop WHEN get_ler_col%NOTFOUND;
290: hr_utility.set_location('LER ' || l_egdlertrg_set(ler_row).ler_id, 20);
291: hr_utility.set_location('COLUMN ' || l_column, 20);
292: hr_utility.set_location('NEWVAL ' || l_new_val, 20);
293: hr_utility.set_location('OLDVAL ' || l_old_val, 20);
294: hr_utility.set_location('TYPE ' || l_type, 20);
295: hr_utility.set_location('CD ' || l_egdlertrg_set(ler_row).ocrd_dt_det_cd, 20);

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

288: l_per_info_chg_cs_ler_rl, l_rule_overrides_flag, l_chg_mandatory_cd;
289: EXIT get_ler_col_loop WHEN get_ler_col%NOTFOUND;
290: hr_utility.set_location('LER ' || l_egdlertrg_set(ler_row).ler_id, 20);
291: hr_utility.set_location('COLUMN ' || l_column, 20);
292: hr_utility.set_location('NEWVAL ' || l_new_val, 20);
293: hr_utility.set_location('OLDVAL ' || l_old_val, 20);
294: hr_utility.set_location('TYPE ' || l_type, 20);
295: hr_utility.set_location('CD ' || l_egdlertrg_set(ler_row).ocrd_dt_det_cd, 20);
296: hr_utility.set_location('create dt' || l_create_dt, 20);

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

289: EXIT get_ler_col_loop WHEN get_ler_col%NOTFOUND;
290: hr_utility.set_location('LER ' || l_egdlertrg_set(ler_row).ler_id, 20);
291: hr_utility.set_location('COLUMN ' || l_column, 20);
292: hr_utility.set_location('NEWVAL ' || l_new_val, 20);
293: hr_utility.set_location('OLDVAL ' || l_old_val, 20);
294: hr_utility.set_location('TYPE ' || l_type, 20);
295: hr_utility.set_location('CD ' || l_egdlertrg_set(ler_row).ocrd_dt_det_cd, 20);
296: hr_utility.set_location('create dt' || l_create_dt, 20);
297: hr_utility.set_location('elig strt dt ' || l_elig_strt_dt, 20);

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

290: hr_utility.set_location('LER ' || l_egdlertrg_set(ler_row).ler_id, 20);
291: hr_utility.set_location('COLUMN ' || l_column, 20);
292: hr_utility.set_location('NEWVAL ' || l_new_val, 20);
293: hr_utility.set_location('OLDVAL ' || l_old_val, 20);
294: hr_utility.set_location('TYPE ' || l_type, 20);
295: hr_utility.set_location('CD ' || l_egdlertrg_set(ler_row).ocrd_dt_det_cd, 20);
296: hr_utility.set_location('create dt' || l_create_dt, 20);
297: hr_utility.set_location('elig strt dt ' || l_elig_strt_dt, 20);
298: hr_utility.set_location('elig thru dt ' || l_elig_thru_dt, 20);

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

291: hr_utility.set_location('COLUMN ' || l_column, 20);
292: hr_utility.set_location('NEWVAL ' || l_new_val, 20);
293: hr_utility.set_location('OLDVAL ' || l_old_val, 20);
294: hr_utility.set_location('TYPE ' || l_type, 20);
295: hr_utility.set_location('CD ' || l_egdlertrg_set(ler_row).ocrd_dt_det_cd, 20);
296: hr_utility.set_location('create dt' || l_create_dt, 20);
297: hr_utility.set_location('elig strt dt ' || l_elig_strt_dt, 20);
298: hr_utility.set_location('elig thru dt ' || l_elig_thru_dt, 20);
299: l_changed := TRUE;

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

292: hr_utility.set_location('NEWVAL ' || l_new_val, 20);
293: hr_utility.set_location('OLDVAL ' || l_old_val, 20);
294: hr_utility.set_location('TYPE ' || l_type, 20);
295: hr_utility.set_location('CD ' || l_egdlertrg_set(ler_row).ocrd_dt_det_cd, 20);
296: hr_utility.set_location('create dt' || l_create_dt, 20);
297: hr_utility.set_location('elig strt dt ' || l_elig_strt_dt, 20);
298: hr_utility.set_location('elig thru dt ' || l_elig_thru_dt, 20);
299: l_changed := TRUE;
300: if get_ler_col%ROWCOUNT = 1 then

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

293: hr_utility.set_location('OLDVAL ' || l_old_val, 20);
294: hr_utility.set_location('TYPE ' || l_type, 20);
295: hr_utility.set_location('CD ' || l_egdlertrg_set(ler_row).ocrd_dt_det_cd, 20);
296: hr_utility.set_location('create dt' || l_create_dt, 20);
297: hr_utility.set_location('elig strt dt ' || l_elig_strt_dt, 20);
298: hr_utility.set_location('elig thru dt ' || l_elig_thru_dt, 20);
299: l_changed := TRUE;
300: if get_ler_col%ROWCOUNT = 1 then
301: l_changed := TRUE;

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

294: hr_utility.set_location('TYPE ' || l_type, 20);
295: hr_utility.set_location('CD ' || l_egdlertrg_set(ler_row).ocrd_dt_det_cd, 20);
296: hr_utility.set_location('create dt' || l_create_dt, 20);
297: hr_utility.set_location('elig strt dt ' || l_elig_strt_dt, 20);
298: hr_utility.set_location('elig thru dt ' || l_elig_thru_dt, 20);
299: l_changed := TRUE;
300: if get_ler_col%ROWCOUNT = 1 then
301: l_changed := TRUE;
302: END IF;

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

299: l_changed := TRUE;
300: if get_ler_col%ROWCOUNT = 1 then
301: l_changed := TRUE;
302: END IF;
303: hr_utility.set_location(' ben_egd_trigger', 50);
304: --
305: -- Call the formula here to evaluate per_info_chg_cs_ler_rl.
306: -- If it returns Y, then see the applicability of the data
307: -- changes based on new and old values.

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

435: p_new.elig_strt_dt,
436: p_old.elig_strt_dt,
437: l_old_val)
438: AND (l_changed));
439: hr_utility.set_location(' l_changed:', 40);
440: ELSIF l_column = 'ELIG_THRU_DT' THEN
441: l_changed :=
442: (
443: benutils.column_changed(

Line 519: hr_utility.set_location(

515: p_returned_date => l_lf_evt_ocrd_date);
516: END IF;
517: --
518: ELSIF l_column = 'OVRDN_FLAG' THEN
519: hr_utility.set_location(
520: 'Old ovrdn_flag ' || p_old.ovrdn_flag,
521: 20);
522: hr_utility.set_location(
523: 'New ovrdn_flag ' || p_new.ovrdn_flag,

Line 522: hr_utility.set_location(

518: ELSIF l_column = 'OVRDN_FLAG' THEN
519: hr_utility.set_location(
520: 'Old ovrdn_flag ' || p_old.ovrdn_flag,
521: 20);
522: hr_utility.set_location(
523: 'New ovrdn_flag ' || p_new.ovrdn_flag,
524: 20);
525: hr_utility.set_location('lodt ' || l_lf_evt_ocrd_date, 20);
526: l_changed :=

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

521: 20);
522: hr_utility.set_location(
523: 'New ovrdn_flag ' || p_new.ovrdn_flag,
524: 20);
525: hr_utility.set_location('lodt ' || l_lf_evt_ocrd_date, 20);
526: l_changed :=
527: (
528: benutils.column_changed(
529: p_old.ovrdn_flag,

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

560: l_changed := TRUE ;
561: elsif l_rule_output = 'Y' and l_rule_overrides_flag = 'N' then
562: l_changed := l_changed AND TRUE;
563: elsif l_rule_output = 'N' then
564: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
565: l_changed := FALSE;
566: end if;
567:
568: hr_utility.set_location('After the rule Check ',20.05);

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

564: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
565: l_changed := FALSE;
566: end if;
567:
568: hr_utility.set_location('After the rule Check ',20.05);
569: if l_changed then
570: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
571: else
572: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);

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

566: end if;
567:
568: hr_utility.set_location('After the rule Check ',20.05);
569: if l_changed then
570: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
571: else
572: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
573: end if;
574: -- Check for Column Mandatory Change

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

568: hr_utility.set_location('After the rule Check ',20.05);
569: if l_changed then
570: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
571: else
572: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
573: end if;
574: -- Check for Column Mandatory Change
575: -- If column change is mandatory and data change has failed then dont trigger
576: -- If column change is non-mandatory and the data change has passed, then trigger.

Line 580: hr_utility.set_location('Adding p_new.DPNT_PERSON_ID '||p_new.DPNT_PERSON_ID,855);

576: -- If column change is non-mandatory and the data change has passed, then trigger.
577:
578: /*Bug 9500422: if there is a change, add the dpnt_person_id to the list*/
579: if(l_changed) then
580: hr_utility.set_location('Adding p_new.DPNT_PERSON_ID '||p_new.DPNT_PERSON_ID,855);
581: g_dpnt_person_id_list.extend;
582: g_dpnt_person_id_list(g_dpnt_person_id_list.last) := p_new.DPNT_PERSON_ID;
583: end if;
584: /*End Bug 9500422*/

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

584: /*End Bug 9500422*/
585:
586:
587: if l_chg_mandatory_cd = 'Y' and not l_changed then
588: hr_utility.set_location('Found Mandatory and its failed ', 20.1);
589: l_changed := FALSE;
590: l_trigger := FALSE;
591: exit;
592: elsif l_chg_mandatory_cd = 'Y' and l_changed then

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

589: l_changed := FALSE;
590: l_trigger := FALSE;
591: exit;
592: elsif l_chg_mandatory_cd = 'Y' and l_changed then
593: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
594: l_changed := TRUE;
595: -- exit; */
596: elsif l_chg_mandatory_cd = 'N' and l_changed then
597: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);

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

593: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
594: l_changed := TRUE;
595: -- exit; */
596: elsif l_chg_mandatory_cd = 'N' and l_changed then
597: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);
598: l_changed := TRUE;
599: l_trigger := TRUE;
600: exit;
601: end if;

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

599: l_trigger := TRUE;
600: exit;
601: end if;
602:
603: hr_utility.set_location('After the Mandatory code check ',20.05);
604: if l_changed then
605: hr_utility.set_location(' l_change TRUE ', 20.1);
606: else
607: hr_utility.set_location(' l_change FALSE ', 20.1);

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

601: end if;
602:
603: hr_utility.set_location('After the Mandatory code check ',20.05);
604: if l_changed then
605: hr_utility.set_location(' l_change TRUE ', 20.1);
606: else
607: hr_utility.set_location(' l_change FALSE ', 20.1);
608: end if;
609: --

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

603: hr_utility.set_location('After the Mandatory code check ',20.05);
604: if l_changed then
605: hr_utility.set_location(' l_change TRUE ', 20.1);
606: else
607: hr_utility.set_location(' l_change FALSE ', 20.1);
608: end if;
609: --
610: /* if not l_changed then
611: exit;

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

611: exit;
612: end if; */
613:
614: END LOOP get_ler_col_loop;
615: hr_utility.set_location(' ben_egd_trigger', 50);
616: l_ptnl_id := 0;
617: l_ovn := NULL;
618:
619: --Bug 5630251

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

623: if get_person%notfound then
624: l_person_id := -999999999;
625: end if;
626:
627: hr_utility.set_location('l_person_id' || l_person_id , 50);
628: hr_utility.set_location('per_in_ler_id' || p_new.per_in_ler_id, 50);
629:
630: close get_person;
631: --End Bug 5630251

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

624: l_person_id := -999999999;
625: end if;
626:
627: hr_utility.set_location('l_person_id' || l_person_id , 50);
628: hr_utility.set_location('per_in_ler_id' || p_new.per_in_ler_id, 50);
629:
630: close get_person;
631: --End Bug 5630251
632:

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

634: IF l_type = 'P' THEN
635: OPEN le_exists(l_person_id, l_ler_id, l_lf_evt_ocrd_date); --Bug 5630251
636: FETCH le_exists INTO l_le_exists;
637: IF le_exists%NOTFOUND THEN
638: hr_utility.set_location(' Entering: ben_egd_trigger5', 60);
639:
640: ben_create_ptnl_ler_for_per.create_ptnl_ler_event(
641: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per(
642: p_validate => FALSE,

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

653: p_dtctd_dt => l_effective_start_date);
654: END IF;
655: CLOSE le_exists;
656: ELSIF l_type = 'R' THEN
657: hr_utility.set_location(' Entering: ben_egd_trigger5-', 65);
658: OPEN get_contacts(l_person_id); --Bug 5630251
659: <>
660: LOOP
661: FETCH get_contacts INTO l_hld_person_id;

Line 666: hr_utility.set_location(' Creating ptnl for dep', 60);

662: EXIT get_contacts_loop WHEN get_contacts%NOTFOUND;
663: /*Bug 9500422: Added below if.else condition. If dpnt_person_id is present in the list,
664: then create the potential*/
665: if(is_present(l_hld_person_id)) then
666: hr_utility.set_location(' Creating ptnl for dep', 60);
667: OPEN le_exists(l_person_id, l_ler_id, l_lf_evt_ocrd_date);--Bug 10100651
668: FETCH le_exists INTO l_le_exists;
669: IF le_exists%NOTFOUND THEN
670: hr_utility.set_location(' Entering: ben_egd_trigger5', 60);

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

666: hr_utility.set_location(' Creating ptnl for dep', 60);
667: OPEN le_exists(l_person_id, l_ler_id, l_lf_evt_ocrd_date);--Bug 10100651
668: FETCH le_exists INTO l_le_exists;
669: IF le_exists%NOTFOUND THEN
670: hr_utility.set_location(' Entering: ben_egd_trigger5', 60);
671:
672: ben_create_ptnl_ler_for_per.create_ptnl_ler_event(
673: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per(
674: p_validate => FALSE,

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

701: -- l_lf_evt_ocrd_date := l_session_date;
702: END IF;
703: CLOSE get_ler_col;
704: END LOOP get_ler_loop;
705: hr_utility.set_location(' Dn get_ler loop ' || l_proc, 10);
706: -- END IF;
707: END IF;
708: END IF;
709: END ler_chk;