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 166: hr_utility.set_location('Entering:'||l_procedure, 10);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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