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

Line 169: hr_utility.set_location('Entering:'||l_procedure, 10);

165: ,dep_appl_id =>805
166: ,status => l_status
167: ,industry => l_industry);
168:
169: hr_utility.set_location('Entering:'||l_procedure, 10);
170: l_changed := FALSE;
171: --
172: --Bug 4390330 We need to get the dependent person here.
173: --

Line 194: hr_utility.set_location('RKG l_person_id :'|| l_person_id, 10);

190: fetch get_person_id into l_person_id;
191: close get_person_id;
192: end if;
193:
194: hr_utility.set_location('RKG l_person_id :'|| l_person_id, 10);
195:
196: /*
197: open get_session_date;
198: fetch get_session_date into l_session_date;

Line 232: hr_utility.set_location(' l_system_date:'||to_char(l_system_date), 20);

228: else
229: l_cvg_thru_dt := p_new.cvg_thru_dt;
230: end if;
231:
232: hr_utility.set_location(' l_system_date:'||to_char(l_system_date), 20);
233: hr_utility.set_location(' l_session_date:'||to_char(l_session_date), 20);
234: open get_ler(l_status);
235:
236: loop

Line 233: hr_utility.set_location(' l_session_date:'||to_char(l_session_date), 20);

229: l_cvg_thru_dt := p_new.cvg_thru_dt;
230: end if;
231:
232: hr_utility.set_location(' l_system_date:'||to_char(l_system_date), 20);
233: hr_utility.set_location(' l_session_date:'||to_char(l_session_date), 20);
234: open get_ler(l_status);
235:
236: loop
237: fetch get_ler into l_ler_id, l_typ_cd, l_ocrd_dt_cd;

Line 263: hr_utility.set_location(' l_column:'||l_column, 30);

259: l_changed := TRUE;
260: if get_ler_col%ROWCOUNT = 1 then
261: l_changed := TRUE;
262: end if;
263: hr_utility.set_location(' l_column:'||l_column, 30);
264: --
265: -- Call the formula here to evaluate per_info_chg_cs_ler_rl.
266: -- If it returns Y, then see the applicability of the data
267: -- changes based on new and old values.

Line 361: hr_utility.set_location(' CVG_STRT_DT',40);

357: ,p_new.cvg_strt_dt,l_new_val) AND
358: benutils.column_changed(p_new.cvg_strt_dt
359: ,p_old.cvg_strt_dt,l_old_val) AND
360: (l_changed));
361: hr_utility.set_location(' CVG_STRT_DT',40);
362: --
363: if l_ocrd_dt_cd is null then
364: l_lf_evt_ocrd_date := l_cvg_strt_dt;
365: else

Line 388: hr_utility.set_location(' CVG_THRU_DT',41);

384: ,p_new.cvg_thru_dt,l_new_val) AND
385: benutils.column_changed(p_new.cvg_thru_dt
386: ,p_old.cvg_thru_dt,l_old_val) AND
387: (l_changed));
388: hr_utility.set_location(' CVG_THRU_DT',41);
389: hr_utility.set_location(' p_new.cvg_thru_dt:'||to_char(p_new.cvg_thru_dt),41);
390: if l_ocrd_dt_cd is null then
391: l_lf_evt_ocrd_date := l_cvg_thru_dt;
392: else

Line 389: hr_utility.set_location(' p_new.cvg_thru_dt:'||to_char(p_new.cvg_thru_dt),41);

385: benutils.column_changed(p_new.cvg_thru_dt
386: ,p_old.cvg_thru_dt,l_old_val) AND
387: (l_changed));
388: hr_utility.set_location(' CVG_THRU_DT',41);
389: hr_utility.set_location(' p_new.cvg_thru_dt:'||to_char(p_new.cvg_thru_dt),41);
390: if l_ocrd_dt_cd is null then
391: l_lf_evt_ocrd_date := l_cvg_thru_dt;
392: else
393: --

Line 412: hr_utility.set_location(' EFFECTIVE_START_DATE',42);

408: ,p_new.effective_start_date,l_new_val) AND
409: benutils.column_changed(p_new.effective_start_date
410: ,p_old.effective_start_date,l_old_val) AND
411: (l_changed));
412: hr_utility.set_location(' EFFECTIVE_START_DATE',42);
413: end if;
414: --
415: if l_column = 'EFFECTIVE_END_DATE' then
416: if p_new.effective_end_date = hr_api.g_eot then

Line 424: hr_utility.set_location(' EFFECTIVE_END_DATE',43);

420: ,p_new.effective_end_date,l_new_val) AND
421: benutils.column_changed(p_new.effective_end_date
422: ,p_old.effective_end_date,l_old_val) AND
423: (l_changed));
424: hr_utility.set_location(' EFFECTIVE_END_DATE',43);
425: --
426: if l_ocrd_dt_cd is null then
427: l_lf_evt_ocrd_date := p_new.effective_end_date;
428: else

Line 448: hr_utility.set_location(' OVRDN_FLAG ',44);

444: ,p_new.ovrdn_flag,l_new_val) AND
445: benutils.column_changed(p_new.ovrdn_flag
446: ,p_old.ovrdn_flag,l_old_val) AND
447: (l_changed));
448: hr_utility.set_location(' OVRDN_FLAG ',44);
449: end if;
450: --
451: if l_column = 'OVRDN_THRU_DT' then
452: l_changed := (benutils.column_changed(p_old.ovrdn_thru_dt

Line 457: hr_utility.set_location(' OVRDN_THRU_DT ',45);

453: ,p_new.ovrdn_thru_dt,l_new_val) AND
454: benutils.column_changed(p_new.ovrdn_thru_dt
455: ,p_old.ovrdn_thru_dt,l_old_val) AND
456: (l_changed));
457: hr_utility.set_location(' OVRDN_THRU_DT ',45);
458: end if;
459: --
460:
461: --

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

467: l_changed := TRUE ;
468: elsif l_rule_output = 'Y' and l_rule_overrides_flag = 'N' then
469: l_changed := l_changed AND TRUE;
470: elsif l_rule_output = 'N' then
471: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
472: l_changed := FALSE;
473: end if;
474:
475: hr_utility.set_location('After the rule Check ',20.05);

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

471: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
472: l_changed := FALSE;
473: end if;
474:
475: hr_utility.set_location('After the rule Check ',20.05);
476: if l_changed then
477: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
478: else
479: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);

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

473: end if;
474:
475: hr_utility.set_location('After the rule Check ',20.05);
476: if l_changed then
477: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
478: else
479: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
480: end if;
481: -- Check for Column Mandatory Change

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

475: hr_utility.set_location('After the rule Check ',20.05);
476: if l_changed then
477: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
478: else
479: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
480: end if;
481: -- Check for Column Mandatory Change
482: -- If column change is mandatory and data change has failed then dont trigger
483: -- If column change is non-mandatory and the data change has passed, then trigger.

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

482: -- If column change is mandatory and data change has failed then dont trigger
483: -- If column change is non-mandatory and the data change has passed, then trigger.
484:
485: if l_chg_mandatory_cd = 'Y' and not l_changed then
486: hr_utility.set_location('Found Mandatory and its failed ', 20.1);
487: l_changed := FALSE;
488: l_trigger := FALSE;
489: exit;
490: elsif l_chg_mandatory_cd = 'Y' and l_changed then

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

487: l_changed := FALSE;
488: l_trigger := FALSE;
489: exit;
490: elsif l_chg_mandatory_cd = 'Y' and l_changed then
491: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
492: l_changed := TRUE;
493: -- exit; */
494: elsif l_chg_mandatory_cd = 'N' and l_changed then
495: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);

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

491: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
492: l_changed := TRUE;
493: -- exit; */
494: elsif l_chg_mandatory_cd = 'N' and l_changed then
495: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);
496: l_changed := TRUE;
497: l_trigger := TRUE;
498: exit;
499: end if;

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

497: l_trigger := TRUE;
498: exit;
499: end if;
500:
501: hr_utility.set_location('After the Mandatory code check ',20.05);
502: if l_changed then
503: hr_utility.set_location(' l_change TRUE ', 20.1);
504: else
505: hr_utility.set_location(' l_change FALSE ', 20.1);

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

499: end if;
500:
501: hr_utility.set_location('After the Mandatory code check ',20.05);
502: if l_changed then
503: hr_utility.set_location(' l_change TRUE ', 20.1);
504: else
505: hr_utility.set_location(' l_change FALSE ', 20.1);
506: end if;
507: --

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

501: hr_utility.set_location('After the Mandatory code check ',20.05);
502: if l_changed then
503: hr_utility.set_location(' l_change TRUE ', 20.1);
504: else
505: hr_utility.set_location(' l_change FALSE ', 20.1);
506: end if;
507: --
508: /* if not l_changed then
509: exit;

Line 513: hr_utility.set_location(' out nocopy of loop', 60);

509: exit;
510: end if; */
511: --
512: end loop;
513: hr_utility.set_location(' out nocopy of loop', 60);
514: l_ptnl_id := 0;
515: l_ovn :=null;
516: if l_trigger then
517: hr_utility.set_location('RKG l_person_id :'|| l_person_id, 10);

Line 517: hr_utility.set_location('RKG l_person_id :'|| l_person_id, 10);

513: hr_utility.set_location(' out nocopy of loop', 60);
514: l_ptnl_id := 0;
515: l_ovn :=null;
516: if l_trigger then
517: hr_utility.set_location('RKG l_person_id :'|| l_person_id, 10);
518: if l_type = 'P' then
519: open le_exists(l_person_id,l_ler_id,l_lf_evt_ocrd_date);
520: fetch le_exists into l_le_exists;
521: if le_exists%notfound then

Line 523: hr_utility.set_location(' about to create ptnl-ler', 70);

519: open le_exists(l_person_id,l_ler_id,l_lf_evt_ocrd_date);
520: fetch le_exists into l_le_exists;
521: if le_exists%notfound then
522:
523: hr_utility.set_location(' about to create ptnl-ler', 70);
524: hr_utility.set_location(' l_person_id:'||to_char(l_person_id)||
525: ' l_lf_evt_ocrd_date:'||to_char(l_lf_evt_ocrd_date), 70);
526: hr_utility.set_location(' l_ler_id:'||to_char(l_ler_id)||
527: ' l_effective_start_date:'||to_char(l_effective_start_date), 70);

Line 524: hr_utility.set_location(' l_person_id:'||to_char(l_person_id)||

520: fetch le_exists into l_le_exists;
521: if le_exists%notfound then
522:
523: hr_utility.set_location(' about to create ptnl-ler', 70);
524: hr_utility.set_location(' l_person_id:'||to_char(l_person_id)||
525: ' l_lf_evt_ocrd_date:'||to_char(l_lf_evt_ocrd_date), 70);
526: hr_utility.set_location(' l_ler_id:'||to_char(l_ler_id)||
527: ' l_effective_start_date:'||to_char(l_effective_start_date), 70);
528: hr_utility.set_location(' about to create ptnl-ler', 70);

Line 526: hr_utility.set_location(' l_ler_id:'||to_char(l_ler_id)||

522:
523: hr_utility.set_location(' about to create ptnl-ler', 70);
524: hr_utility.set_location(' l_person_id:'||to_char(l_person_id)||
525: ' l_lf_evt_ocrd_date:'||to_char(l_lf_evt_ocrd_date), 70);
526: hr_utility.set_location(' l_ler_id:'||to_char(l_ler_id)||
527: ' l_effective_start_date:'||to_char(l_effective_start_date), 70);
528: hr_utility.set_location(' about to create ptnl-ler', 70);
529:
530: if l_person_id is null then

Line 528: hr_utility.set_location(' about to create ptnl-ler', 70);

524: hr_utility.set_location(' l_person_id:'||to_char(l_person_id)||
525: ' l_lf_evt_ocrd_date:'||to_char(l_lf_evt_ocrd_date), 70);
526: hr_utility.set_location(' l_ler_id:'||to_char(l_ler_id)||
527: ' l_effective_start_date:'||to_char(l_effective_start_date), 70);
528: hr_utility.set_location(' about to create ptnl-ler', 70);
529:
530: if l_person_id is null then
531: fnd_message.set_name('BEN','BEN_92299_CANNOT_CREATE_PIL');
532: fnd_message.raise_error;

Line 551: hr_utility.set_location(' l_type = R', 75);

547: ,p_dtctd_dt => l_effective_start_date);
548: end if;
549: close le_exists;
550: elsif l_type = 'R' then
551: hr_utility.set_location(' l_type = R', 75);
552: open get_contacts(l_person_id);
553: loop
554: fetch get_contacts into l_hld_person_id;
555: exit when get_contacts%notfound;

Line 557: hr_utility.set_location('RKG l_hld_person_id :'|| l_hld_person_id, 10);

553: loop
554: fetch get_contacts into l_hld_person_id;
555: exit when get_contacts%notfound;
556:
557: hr_utility.set_location('RKG l_hld_person_id :'|| l_hld_person_id, 10);
558:
559: open le_exists(l_hld_person_id,l_ler_id,l_lf_evt_ocrd_date);
560: fetch le_exists into l_le_exists;
561: if le_exists%notfound then

Line 562: hr_utility.set_location(' le_exists%notfound', 76);

558:
559: open le_exists(l_hld_person_id,l_ler_id,l_lf_evt_ocrd_date);
560: fetch le_exists into l_le_exists;
561: if le_exists%notfound then
562: hr_utility.set_location(' le_exists%notfound', 76);
563:
564: if l_hld_person_id is null then
565: fnd_message.set_name('BEN','BEN_92299_CANNOT_CREATE_PIL');
566: fnd_message.raise_error;

Line 593: hr_utility.set_location(' reset the variables', 80);

589: end if;
590: --
591: -- reset the variables.
592: --
593: hr_utility.set_location(' reset the variables', 80);
594: l_changed := FALSE;
595: l_trigger := TRUE;
596: l_ovn := NULL;
597: --l_effective_start_date := p_new.effective_start_date;

Line 603: hr_utility.set_location('Leaving:'||l_procedure, 99);

599: close get_ler_col;
600: end loop;
601:
602: close get_ler;
603: hr_utility.set_location('Leaving:'||l_procedure, 99);
604:
605: end;
606: end ben_ecd_ler;