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

Line 163: hr_utility.set_location(' Entering: ben_pps_trigger', 10);

159: ,dep_appl_id =>805
160: ,status => l_status
161: ,industry => l_industry);
162:
163: hr_utility.set_location(' Entering: ben_pps_trigger', 10);
164: l_changed := FALSE;
165: --open get_session_date;
166: --fetch get_session_date into l_session_date;
167: --close get_session_date;

Line 182: hr_utility.set_location(' ben_pps_trigger', 20);

178: fetch get_system_date into l_system_date;
179: close get_system_date;
180: l_effective_start_date := l_session_date;
181: -- l_lf_evt_ocrd_date := l_session_date;
182: hr_utility.set_location(' ben_pps_trigger', 20);
183:
184: -- in some situations the date we use for occured on date is null,
185: -- use session date instead.
186: if p_new.actual_termination_date is null then

Line 198: hr_utility.set_location(' ler type '|| l_typ_cd, 20);

194: fetch get_ler into l_ler_id,l_typ_cd, l_ocrd_dt_cd;
195: exit when get_ler%notfound;
196: l_trigger := TRUE;
197: --
198: hr_utility.set_location(' ler type '|| l_typ_cd, 20);
199: if l_ocrd_dt_cd is null then
200: l_lf_evt_ocrd_date := p_new.date_start;
201: else
202: --

Line 223: hr_utility.set_location(' ben_pps_trigger', 50);

219: l_changed := TRUE;
220: if get_ler_col%ROWCOUNT = 1 then
221: l_changed := TRUE;
222: end if;
223: hr_utility.set_location(' ben_pps_trigger', 50);
224: -- Call the formula here to evaluate per_info_chg_cs_ler_rl.
225: -- If it returns Y, then see the applicability of the data
226: -- changes based on new and old values.
227: --

Line 365: hr_utility.set_location(' l_changed:',39);

361: l_session_date)
362: ,p_returned_date => l_lf_evt_ocrd_date
363: );
364: end if;
365: hr_utility.set_location(' l_changed:',39);
366: end if;
367: --
368: if l_column = 'DATE_START' then
369: l_changed := (benutils.column_changed(p_old.date_start

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

370: ,p_new.date_start,l_new_val) AND
371: benutils.column_changed(p_new.date_start
372: ,p_old.date_start,l_old_val) AND
373: (l_changed));
374: hr_utility.set_location(' l_changed:',40);
375: --
376: -- Bug 5672925
377: -- If Person Changes are based on DATE_START then LF_EVT_OCRD_DT should be
378: -- new DATE_START and not the effective date

Line 393: hr_utility.set_location('ACE l_lf_evt_ocrd_date = ' || l_lf_evt_ocrd_date, 9999);

389: ,p_lf_evt_ocrd_dt => p_new.date_start
390: ,p_returned_date => l_lf_evt_ocrd_date
391: );
392: end if;
393: hr_utility.set_location('ACE l_lf_evt_ocrd_date = ' || l_lf_evt_ocrd_date, 9999);
394: -- Bug 5672925
395: --
396: end if;
397: --

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

499: l_changed := TRUE ;
500: elsif l_rule_output = 'Y' and l_rule_overrides_flag = 'N' then
501: l_changed := l_changed AND TRUE;
502: elsif l_rule_output = 'N' then
503: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
504: l_changed := FALSE;
505: end if;
506:
507: hr_utility.set_location('After the rule Check ',20.05);

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

503: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
504: l_changed := FALSE;
505: end if;
506:
507: hr_utility.set_location('After the rule Check ',20.05);
508: if l_changed then
509: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
510: else
511: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);

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

505: end if;
506:
507: hr_utility.set_location('After the rule Check ',20.05);
508: if l_changed then
509: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
510: else
511: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
512: end if;
513: -- Check for Column Mandatory Change

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

507: hr_utility.set_location('After the rule Check ',20.05);
508: if l_changed then
509: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
510: else
511: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
512: end if;
513: -- Check for Column Mandatory Change
514: -- If column change is mandatory and data change has failed then dont trigger
515: -- If column change is non-mandatory and the data change has passed, then trigger.

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

514: -- If column change is mandatory and data change has failed then dont trigger
515: -- If column change is non-mandatory and the data change has passed, then trigger.
516:
517: if l_chg_mandatory_cd = 'Y' and not l_changed then
518: hr_utility.set_location('Found Mandatory and its failed ', 20.1);
519: l_changed := FALSE;
520: l_trigger := FALSE;
521: exit;
522: elsif l_chg_mandatory_cd = 'Y' and l_changed then

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

519: l_changed := FALSE;
520: l_trigger := FALSE;
521: exit;
522: elsif l_chg_mandatory_cd = 'Y' and l_changed then
523: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
524: l_changed := TRUE;
525: -- exit; */
526: elsif l_chg_mandatory_cd = 'N' and l_changed then
527: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);

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

523: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
524: l_changed := TRUE;
525: -- exit; */
526: elsif l_chg_mandatory_cd = 'N' and l_changed then
527: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);
528: l_changed := TRUE;
529: l_trigger := TRUE;
530: exit;
531: end if;

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

529: l_trigger := TRUE;
530: exit;
531: end if;
532:
533: hr_utility.set_location('After the Mandatory code check ',20.05);
534: if l_changed then
535: hr_utility.set_location(' l_change TRUE ', 20.1);
536: else
537: hr_utility.set_location(' l_change FALSE ', 20.1);

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

531: end if;
532:
533: hr_utility.set_location('After the Mandatory code check ',20.05);
534: if l_changed then
535: hr_utility.set_location(' l_change TRUE ', 20.1);
536: else
537: hr_utility.set_location(' l_change FALSE ', 20.1);
538: end if;
539: --

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

533: hr_utility.set_location('After the Mandatory code check ',20.05);
534: if l_changed then
535: hr_utility.set_location(' l_change TRUE ', 20.1);
536: else
537: hr_utility.set_location(' l_change FALSE ', 20.1);
538: end if;
539: --
540: /* if not l_changed then
541: exit;

Line 544: hr_utility.set_location(' ben_pps_trigger', 50);

540: /* if not l_changed then
541: exit;
542: end if; */
543: end loop;
544: hr_utility.set_location(' ben_pps_trigger', 50);
545: l_ptnl_id := 0;
546: l_ovn :=null;
547: if l_trigger then
548: if l_type = 'P' then

Line 552: hr_utility.set_location(' Entering: ben_pps_trigger5', 60);

548: if l_type = 'P' then
549: open le_exists(p_new.person_id,l_ler_id,l_lf_evt_ocrd_date);
550: fetch le_exists into l_le_exists;
551: if le_exists%notfound then
552: hr_utility.set_location(' Entering: ben_pps_trigger5', 60);
553:
554: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
555: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
556: (p_validate => false

Line 571: hr_utility.set_location(' Entering: ben_pps_trigger5-', 65);

567: ,p_dtctd_dt => l_effective_start_date);
568: end if;
569: close le_exists;
570: elsif l_type = 'R' then
571: hr_utility.set_location(' Entering: ben_pps_trigger5-', 65);
572: open get_contacts(p_new.person_id);
573: loop
574: fetch get_contacts into l_hld_person_id;
575: exit when get_contacts%notfound;

Line 579: hr_utility.set_location(' Entering: ben_pps_trigger5', 60);

575: exit when get_contacts%notfound;
576: open le_exists(l_hld_person_id,l_ler_id,l_lf_evt_ocrd_date);
577: fetch le_exists into l_le_exists;
578: if le_exists%notfound then
579: hr_utility.set_location(' Entering: ben_pps_trigger5', 60);
580:
581: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
582: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
583: (p_validate => false

Line 605: hr_utility.set_location(' ben_pps_trigger', 60);

601: end if;
602: --
603: -- reset the variables.
604: --
605: hr_utility.set_location(' ben_pps_trigger', 60);
606: l_changed := FALSE;
607: l_trigger := TRUE;
608: l_ovn := NULL;
609: l_effective_start_date := l_session_date;

Line 614: hr_utility.set_location(' ben_pps_trigger', 70);

610: -- l_lf_evt_ocrd_date := l_session_date;
611: end if;
612: close get_ler_col;
613: end loop;
614: hr_utility.set_location(' ben_pps_trigger', 70);
615: close get_ler;
616: hr_utility.set_location(' leaving ben_pps_trigger', 80);
617: end if;
618: --

Line 616: hr_utility.set_location(' leaving ben_pps_trigger', 80);

612: close get_ler_col;
613: end loop;
614: hr_utility.set_location(' ben_pps_trigger', 70);
615: close get_ler;
616: hr_utility.set_location(' leaving ben_pps_trigger', 80);
617: end if;
618: --
619: -- following are to be removed whne hr fix the bug
620: --