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

Line 175: hr_utility.set_location(' Entering: ben_prv_trigger', 10);

171: ,status => l_status
172: ,industry => l_industry);
173: if l_status = 'I' then
174: */
175: hr_utility.set_location(' Entering: ben_prv_trigger', 10);
176: l_changed := FALSE;
177: --open get_session_date;
178: --fetch get_session_date into l_session_date;
179: --close get_session_date;

Line 189: hr_utility.set_location(' ben_prv_trigger', 20);

185: fetch get_system_date into l_system_date;
186: close get_system_date;
187: l_effective_start_date := l_session_date;
188: -- l_lf_evt_ocrd_date := l_session_date;
189: hr_utility.set_location(' ben_prv_trigger', 20);
190:
191: if p_new.rt_strt_dt is null then
192: l_rt_strt_dt := l_session_date;
193: else

Line 242: hr_utility.set_location('LER '||l_prvlertrg_set(ler_row).ler_id, 20);

238: open get_ler_col(l_prvlertrg_set(ler_row).ler_id);
239: loop
240: fetch get_ler_col into l_column,l_new_val, l_old_val, l_type, l_per_info_chg_cs_ler_rl, l_rule_overrides_flag, l_chg_mandatory_cd;
241: exit when get_ler_col%NOTFOUND;
242: hr_utility.set_location('LER '||l_prvlertrg_set(ler_row).ler_id, 20);
243: hr_utility.set_location('COLUMN '||l_column, 20);
244: hr_utility.set_location('NEWVAL '||l_new_val, 20);
245: hr_utility.set_location('OLDVAL '||l_old_val, 20);
246: hr_utility.set_location('TYPE '||l_type, 20);

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

239: loop
240: fetch get_ler_col into l_column,l_new_val, l_old_val, l_type, l_per_info_chg_cs_ler_rl, l_rule_overrides_flag, l_chg_mandatory_cd;
241: exit when get_ler_col%NOTFOUND;
242: hr_utility.set_location('LER '||l_prvlertrg_set(ler_row).ler_id, 20);
243: hr_utility.set_location('COLUMN '||l_column, 20);
244: hr_utility.set_location('NEWVAL '||l_new_val, 20);
245: hr_utility.set_location('OLDVAL '||l_old_val, 20);
246: hr_utility.set_location('TYPE '||l_type, 20);
247: hr_utility.set_location('CD '||l_prvlertrg_set(ler_row).ocrd_dt_det_cd, 20);

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

240: fetch get_ler_col into l_column,l_new_val, l_old_val, l_type, l_per_info_chg_cs_ler_rl, l_rule_overrides_flag, l_chg_mandatory_cd;
241: exit when get_ler_col%NOTFOUND;
242: hr_utility.set_location('LER '||l_prvlertrg_set(ler_row).ler_id, 20);
243: hr_utility.set_location('COLUMN '||l_column, 20);
244: hr_utility.set_location('NEWVAL '||l_new_val, 20);
245: hr_utility.set_location('OLDVAL '||l_old_val, 20);
246: hr_utility.set_location('TYPE '||l_type, 20);
247: hr_utility.set_location('CD '||l_prvlertrg_set(ler_row).ocrd_dt_det_cd, 20);
248: hr_utility.set_location('rsd'||l_rt_strt_dt, 20);

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

241: exit when get_ler_col%NOTFOUND;
242: hr_utility.set_location('LER '||l_prvlertrg_set(ler_row).ler_id, 20);
243: hr_utility.set_location('COLUMN '||l_column, 20);
244: hr_utility.set_location('NEWVAL '||l_new_val, 20);
245: hr_utility.set_location('OLDVAL '||l_old_val, 20);
246: hr_utility.set_location('TYPE '||l_type, 20);
247: hr_utility.set_location('CD '||l_prvlertrg_set(ler_row).ocrd_dt_det_cd, 20);
248: hr_utility.set_location('rsd'||l_rt_strt_dt, 20);
249: l_changed := TRUE;

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

242: hr_utility.set_location('LER '||l_prvlertrg_set(ler_row).ler_id, 20);
243: hr_utility.set_location('COLUMN '||l_column, 20);
244: hr_utility.set_location('NEWVAL '||l_new_val, 20);
245: hr_utility.set_location('OLDVAL '||l_old_val, 20);
246: hr_utility.set_location('TYPE '||l_type, 20);
247: hr_utility.set_location('CD '||l_prvlertrg_set(ler_row).ocrd_dt_det_cd, 20);
248: hr_utility.set_location('rsd'||l_rt_strt_dt, 20);
249: l_changed := TRUE;
250: if get_ler_col%ROWCOUNT = 1 then

Line 247: hr_utility.set_location('CD '||l_prvlertrg_set(ler_row).ocrd_dt_det_cd, 20);

243: hr_utility.set_location('COLUMN '||l_column, 20);
244: hr_utility.set_location('NEWVAL '||l_new_val, 20);
245: hr_utility.set_location('OLDVAL '||l_old_val, 20);
246: hr_utility.set_location('TYPE '||l_type, 20);
247: hr_utility.set_location('CD '||l_prvlertrg_set(ler_row).ocrd_dt_det_cd, 20);
248: hr_utility.set_location('rsd'||l_rt_strt_dt, 20);
249: l_changed := TRUE;
250: if get_ler_col%ROWCOUNT = 1 then
251: l_changed := TRUE;

Line 248: hr_utility.set_location('rsd'||l_rt_strt_dt, 20);

244: hr_utility.set_location('NEWVAL '||l_new_val, 20);
245: hr_utility.set_location('OLDVAL '||l_old_val, 20);
246: hr_utility.set_location('TYPE '||l_type, 20);
247: hr_utility.set_location('CD '||l_prvlertrg_set(ler_row).ocrd_dt_det_cd, 20);
248: hr_utility.set_location('rsd'||l_rt_strt_dt, 20);
249: l_changed := TRUE;
250: if get_ler_col%ROWCOUNT = 1 then
251: l_changed := TRUE;
252: end if;

Line 253: hr_utility.set_location(' ben_prv_trigger', 50);

249: l_changed := TRUE;
250: if get_ler_col%ROWCOUNT = 1 then
251: l_changed := TRUE;
252: end if;
253: hr_utility.set_location(' ben_prv_trigger', 50);
254: --
255: -- Call the formula here to evaluate per_info_chg_cs_ler_rl.
256: -- If it returns Y, then see the applicability of the data
257: -- changes based on new and old values.

Line 393: hr_utility.set_location(' l_changed:',60);

389: ,p_new.cmcd_rt_val,l_new_val) AND
390: benutils.column_changed(p_new.cmcd_rt_val
391: ,p_old.cmcd_rt_val,l_old_val) AND
392: (l_changed));
393: hr_utility.set_location(' l_changed:',60);
394: end if;
395: --
396: if l_column = 'ANN_RT_VAL' then
397: l_changed := (benutils.column_changed(p_old.ann_rt_val

Line 402: hr_utility.set_location(' l_changed:',70);

398: ,p_new.ann_rt_val,l_new_val) AND
399: benutils.column_changed(p_new.ann_rt_val
400: ,p_old.ann_rt_val,l_old_val) AND
401: (l_changed));
402: hr_utility.set_location(' l_changed:',70);
403: end if;
404: --
405: if l_column = 'RT_VAL' then
406: hr_utility.set_location('Old rt_val '||p_old.rt_val, 20);

Line 406: hr_utility.set_location('Old rt_val '||p_old.rt_val, 20);

402: hr_utility.set_location(' l_changed:',70);
403: end if;
404: --
405: if l_column = 'RT_VAL' then
406: hr_utility.set_location('Old rt_val '||p_old.rt_val, 20);
407: hr_utility.set_location('New rt val '||p_new.rt_val, 20);
408: hr_utility.set_location('lodt '||l_lf_evt_ocrd_date, 20);
409: l_changed := (benutils.column_changed(p_old.rt_val
410: ,p_new.rt_val,l_new_val) AND

Line 407: hr_utility.set_location('New rt val '||p_new.rt_val, 20);

403: end if;
404: --
405: if l_column = 'RT_VAL' then
406: hr_utility.set_location('Old rt_val '||p_old.rt_val, 20);
407: hr_utility.set_location('New rt val '||p_new.rt_val, 20);
408: hr_utility.set_location('lodt '||l_lf_evt_ocrd_date, 20);
409: l_changed := (benutils.column_changed(p_old.rt_val
410: ,p_new.rt_val,l_new_val) AND
411: benutils.column_changed(p_new.rt_val

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

404: --
405: if l_column = 'RT_VAL' then
406: hr_utility.set_location('Old rt_val '||p_old.rt_val, 20);
407: hr_utility.set_location('New rt val '||p_new.rt_val, 20);
408: hr_utility.set_location('lodt '||l_lf_evt_ocrd_date, 20);
409: l_changed := (benutils.column_changed(p_old.rt_val
410: ,p_new.rt_val,l_new_val) AND
411: benutils.column_changed(p_new.rt_val
412: ,p_old.rt_val,l_old_val) AND

Line 414: hr_utility.set_location(' l_changed:',80);

410: ,p_new.rt_val,l_new_val) AND
411: benutils.column_changed(p_new.rt_val
412: ,p_old.rt_val,l_old_val) AND
413: (l_changed));
414: hr_utility.set_location(' l_changed:',80);
415: end if;
416: --
417: if l_column = 'RT_STRT_DT' then
418: l_changed := (benutils.column_changed(p_old.rt_strt_dt

Line 423: hr_utility.set_location(' l_changed:',90);

419: ,p_new.rt_strt_dt,l_new_val) AND
420: benutils.column_changed(p_new.rt_strt_dt
421: ,p_old.rt_strt_dt,l_old_val) AND
422: (l_changed));
423: hr_utility.set_location(' l_changed:',90);
424: end if;
425: --
426: if l_column = 'RT_END_DT' then
427: l_changed := (benutils.column_changed(p_old.rt_end_dt

Line 432: hr_utility.set_location(' l_changed:',100);

428: ,p_new.rt_end_dt,l_new_val) AND
429: benutils.column_changed(p_new.rt_end_dt
430: ,p_old.rt_end_dt,l_old_val) AND
431: (l_changed));
432: hr_utility.set_location(' l_changed:',100);
433: --
434: if l_prvlertrg_set(ler_row).ocrd_dt_det_cd is null then
435: l_lf_evt_ocrd_date := l_rt_end_dt;
436: else

Line 455: hr_utility.set_location(' l_changed:',110);

451: ,p_new.rt_ovridn_flag,l_new_val) AND
452: benutils.column_changed(p_new.rt_ovridn_flag
453: ,p_old.rt_ovridn_flag,l_old_val) AND
454: (l_changed));
455: hr_utility.set_location(' l_changed:',110);
456: end if;
457: --
458: if l_column = 'ELCTNS_MADE_DT' then
459: l_changed := (benutils.column_changed(p_old.elctns_made_dt

Line 464: hr_utility.set_location(' l_changed:',120);

460: ,p_new.elctns_made_dt,l_new_val) AND
461: benutils.column_changed(p_new.elctns_made_dt
462: ,p_old.elctns_made_dt,l_old_val) AND
463: (l_changed));
464: hr_utility.set_location(' l_changed:',120);
465: end if;
466: --
467: if l_column = 'RT_OVRIDN_THRU_DT' then
468: l_changed := (benutils.column_changed(p_old.rt_ovridn_thru_dt

Line 473: hr_utility.set_location(' l_changed:',130);

469: ,p_new.rt_ovridn_thru_dt,l_new_val) AND
470: benutils.column_changed(p_new.rt_ovridn_thru_dt
471: ,p_old.rt_ovridn_thru_dt,l_old_val) AND
472: (l_changed));
473: hr_utility.set_location(' l_changed:',130);
474: end if;
475: --
476: -- Checking the rule output and the rule override flag.
477: -- Whether the rule is mandatory or not, rule output should return 'Y'

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

481: l_changed := TRUE ;
482: elsif l_rule_output = 'Y' and l_rule_overrides_flag = 'N' then
483: l_changed := l_changed AND TRUE;
484: elsif l_rule_output = 'N' then
485: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
486: l_changed := FALSE;
487: end if;
488:
489: hr_utility.set_location('After the rule Check ',20.05);

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

485: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
486: l_changed := FALSE;
487: end if;
488:
489: hr_utility.set_location('After the rule Check ',20.05);
490: if l_changed then
491: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
492: else
493: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);

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

487: end if;
488:
489: hr_utility.set_location('After the rule Check ',20.05);
490: if l_changed then
491: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
492: else
493: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
494: end if;
495: -- Check for Column Mandatory Change

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

489: hr_utility.set_location('After the rule Check ',20.05);
490: if l_changed then
491: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
492: else
493: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
494: end if;
495: -- Check for Column Mandatory Change
496: -- If column change is mandatory and data change has failed then dont trigger
497: -- If column change is non-mandatory and the data change has passed, then trigger.

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

496: -- If column change is mandatory and data change has failed then dont trigger
497: -- If column change is non-mandatory and the data change has passed, then trigger.
498:
499: if l_chg_mandatory_cd = 'Y' and not l_changed then
500: hr_utility.set_location('Found Mandatory and its failed ', 20.1);
501: l_changed := FALSE;
502: l_trigger := FALSE;
503: exit;
504: elsif l_chg_mandatory_cd = 'Y' and l_changed then

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

501: l_changed := FALSE;
502: l_trigger := FALSE;
503: exit;
504: elsif l_chg_mandatory_cd = 'Y' and l_changed then
505: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
506: l_changed := TRUE;
507: -- exit; */
508: elsif l_chg_mandatory_cd = 'N' and l_changed then
509: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);

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

505: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
506: l_changed := TRUE;
507: -- exit; */
508: elsif l_chg_mandatory_cd = 'N' and l_changed then
509: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);
510: l_changed := TRUE;
511: l_trigger := TRUE;
512: exit;
513: end if;

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

511: l_trigger := TRUE;
512: exit;
513: end if;
514:
515: hr_utility.set_location('After the Mandatory code check ',20.05);
516: if l_changed then
517: hr_utility.set_location(' l_change TRUE ', 20.1);
518: else
519: hr_utility.set_location(' l_change FALSE ', 20.1);

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

513: end if;
514:
515: hr_utility.set_location('After the Mandatory code check ',20.05);
516: if l_changed then
517: hr_utility.set_location(' l_change TRUE ', 20.1);
518: else
519: hr_utility.set_location(' l_change FALSE ', 20.1);
520: end if;
521: --

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

515: hr_utility.set_location('After the Mandatory code check ',20.05);
516: if l_changed then
517: hr_utility.set_location(' l_change TRUE ', 20.1);
518: else
519: hr_utility.set_location(' l_change FALSE ', 20.1);
520: end if;
521: --
522: --
523: /* if not l_changed then

Line 527: hr_utility.set_location(' ben_prv_trigger', 30);

523: /* if not l_changed then
524: exit;
525: end if; */
526: end loop;
527: hr_utility.set_location(' ben_prv_trigger', 30);
528: l_ptnl_id := 0;
529: l_ovn :=null;
530: if l_trigger then
531: if l_type = 'P' then

Line 535: hr_utility.set_location(' Entering: ben_prv_trigger5', 60);

531: if l_type = 'P' then
532: open le_exists(l_person_id,l_prvlertrg_set(ler_row).ler_id,l_lf_evt_ocrd_date);
533: fetch le_exists into l_le_exists;
534: if le_exists%notfound then
535: hr_utility.set_location(' Entering: ben_prv_trigger5', 60);
536: hr_utility.set_location(' about to create ptnl-ler', 70);
537: hr_utility.set_location(' l_person_id:'||to_char(l_person_id)||
538: ' l_lf_evt_ocrd_date:'||to_char(l_lf_evt_ocrd_date), 70);
539: hr_utility.set_location(' l_ler_id:'||to_char(l_prvlertrg_set(ler_row).ler_id)||

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

532: open le_exists(l_person_id,l_prvlertrg_set(ler_row).ler_id,l_lf_evt_ocrd_date);
533: fetch le_exists into l_le_exists;
534: if le_exists%notfound then
535: hr_utility.set_location(' Entering: ben_prv_trigger5', 60);
536: hr_utility.set_location(' about to create ptnl-ler', 70);
537: hr_utility.set_location(' l_person_id:'||to_char(l_person_id)||
538: ' l_lf_evt_ocrd_date:'||to_char(l_lf_evt_ocrd_date), 70);
539: hr_utility.set_location(' l_ler_id:'||to_char(l_prvlertrg_set(ler_row).ler_id)||
540: ' l_effective_start_date:'||to_char(l_effective_start_date), 70);

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

533: fetch le_exists into l_le_exists;
534: if le_exists%notfound then
535: hr_utility.set_location(' Entering: ben_prv_trigger5', 60);
536: hr_utility.set_location(' about to create ptnl-ler', 70);
537: hr_utility.set_location(' l_person_id:'||to_char(l_person_id)||
538: ' l_lf_evt_ocrd_date:'||to_char(l_lf_evt_ocrd_date), 70);
539: hr_utility.set_location(' l_ler_id:'||to_char(l_prvlertrg_set(ler_row).ler_id)||
540: ' l_effective_start_date:'||to_char(l_effective_start_date), 70);
541: hr_utility.set_location(' about to create ptnl-ler', 70);

Line 539: hr_utility.set_location(' l_ler_id:'||to_char(l_prvlertrg_set(ler_row).ler_id)||

535: hr_utility.set_location(' Entering: ben_prv_trigger5', 60);
536: hr_utility.set_location(' about to create ptnl-ler', 70);
537: hr_utility.set_location(' l_person_id:'||to_char(l_person_id)||
538: ' l_lf_evt_ocrd_date:'||to_char(l_lf_evt_ocrd_date), 70);
539: hr_utility.set_location(' l_ler_id:'||to_char(l_prvlertrg_set(ler_row).ler_id)||
540: ' l_effective_start_date:'||to_char(l_effective_start_date), 70);
541: hr_utility.set_location(' about to create ptnl-ler', 70);
542:
543: if l_person_id is null then

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

537: hr_utility.set_location(' l_person_id:'||to_char(l_person_id)||
538: ' l_lf_evt_ocrd_date:'||to_char(l_lf_evt_ocrd_date), 70);
539: hr_utility.set_location(' l_ler_id:'||to_char(l_prvlertrg_set(ler_row).ler_id)||
540: ' l_effective_start_date:'||to_char(l_effective_start_date), 70);
541: hr_utility.set_location(' about to create ptnl-ler', 70);
542:
543: if l_person_id is null then
544: fnd_message.set_name('BEN','BEN_92299_CANNOT_CREATE_PIL');
545: fnd_message.raise_error;

Line 564: hr_utility.set_location(' Entering: ben_prv_trigger5-', 65);

560: ,p_dtctd_dt => l_effective_start_date);
561: end if;
562: close le_exists;
563: elsif l_type = 'R' then
564: hr_utility.set_location(' Entering: ben_prv_trigger5-', 65);
565: open get_contacts(l_person_id);
566: loop
567: fetch get_contacts into l_hld_person_id;
568: exit when get_contacts%notfound;

Line 572: hr_utility.set_location(' Entering: ben_prv_trigger5', 60);

568: exit when get_contacts%notfound;
569: open le_exists(l_hld_person_id,l_prvlertrg_set(ler_row).ler_id,l_lf_evt_ocrd_date);
570: fetch le_exists into l_le_exists;
571: if le_exists%notfound then
572: hr_utility.set_location(' Entering: ben_prv_trigger5', 60);
573:
574: if l_hld_person_id is null then
575: fnd_message.set_name('BEN','BEN_92299_CANNOT_CREATE_PIL');
576: fnd_message.raise_error;

Line 602: hr_utility.set_location(' ben_prv_trigger', 40);

598: end if;
599: --
600: -- reset the variables.
601: --
602: hr_utility.set_location(' ben_prv_trigger', 40);
603: l_changed := FALSE;
604: l_trigger := TRUE;
605: l_ovn := NULL;
606: l_effective_start_date := l_session_date;

Line 611: hr_utility.set_location(' ben_prv_trigger', 180);

607: -- l_lf_evt_ocrd_date := p_new.effective_start_date;
608: end if;
609: close get_ler_col;
610: end loop;
611: hr_utility.set_location(' ben_prv_trigger', 180);
612: end if;
613: /*
614: close get_ler;
615: */

Line 616: hr_utility.set_location(' Leaving: ben_prv_trigger', 200);

612: end if;
613: /*
614: close get_ler;
615: */
616: hr_utility.set_location(' Leaving: ben_prv_trigger', 200);
617: --end if;
618: end;
619: end ben_prv_ler;