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

Line 143: hr_utility.set_location(' Entering: ben_pen_trigger', 10);

139: end if;
140: --
141: -- End of Bug 3320133
142:
143: hr_utility.set_location(' Entering: ben_pen_trigger', 10);
144: l_changed := FALSE;
145: /*
146: open get_session_date;
147: fetch get_session_date into l_session_date;

Line 175: hr_utility.set_location(' ben_pen_trigger', 20);

171: (p_business_group_id => p_new.business_group_id
172: ,p_effective_date => l_session_date
173: ,p_inst_set => l_lertrg_set
174: );
175: hr_utility.set_location(' ben_pen_trigger', 20);
176: --
177: if l_lertrg_set.count > 0 then
178: --
179: for ler_row in l_lertrg_set.first..l_lertrg_set.last loop

Line 207: hr_utility.set_location('LER '||l_lertrg_set(ler_row).ler_id, 20);

203: open get_ler_col(l_lertrg_set(ler_row).ler_id);
204: loop
205: 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;
206: exit when get_ler_col%NOTFOUND;
207: hr_utility.set_location('LER '||l_lertrg_set(ler_row).ler_id, 20);
208: hr_utility.set_location('COLUMN '||l_column, 20);
209: hr_utility.set_location('NEWVAL '||l_new_val, 20);
210: hr_utility.set_location('OLDVAL '||l_old_val, 20);
211: hr_utility.set_location('TYPE '||l_type, 20);

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

204: loop
205: 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;
206: exit when get_ler_col%NOTFOUND;
207: hr_utility.set_location('LER '||l_lertrg_set(ler_row).ler_id, 20);
208: hr_utility.set_location('COLUMN '||l_column, 20);
209: hr_utility.set_location('NEWVAL '||l_new_val, 20);
210: hr_utility.set_location('OLDVAL '||l_old_val, 20);
211: hr_utility.set_location('TYPE '||l_type, 20);
212: hr_utility.set_location('CD '||l_lertrg_set(ler_row).ocrd_dt_det_cd, 20);

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

205: 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;
206: exit when get_ler_col%NOTFOUND;
207: hr_utility.set_location('LER '||l_lertrg_set(ler_row).ler_id, 20);
208: hr_utility.set_location('COLUMN '||l_column, 20);
209: hr_utility.set_location('NEWVAL '||l_new_val, 20);
210: hr_utility.set_location('OLDVAL '||l_old_val, 20);
211: hr_utility.set_location('TYPE '||l_type, 20);
212: hr_utility.set_location('CD '||l_lertrg_set(ler_row).ocrd_dt_det_cd, 20);
213: hr_utility.set_location('enrt cvg strt dt'||p_new.enrt_cvg_strt_dt, 20);

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

206: exit when get_ler_col%NOTFOUND;
207: hr_utility.set_location('LER '||l_lertrg_set(ler_row).ler_id, 20);
208: hr_utility.set_location('COLUMN '||l_column, 20);
209: hr_utility.set_location('NEWVAL '||l_new_val, 20);
210: hr_utility.set_location('OLDVAL '||l_old_val, 20);
211: hr_utility.set_location('TYPE '||l_type, 20);
212: hr_utility.set_location('CD '||l_lertrg_set(ler_row).ocrd_dt_det_cd, 20);
213: hr_utility.set_location('enrt cvg strt dt'||p_new.enrt_cvg_strt_dt, 20);
214: hr_utility.set_location('enrt cvg thru dt '||p_new.enrt_cvg_thru_dt, 20);

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

207: hr_utility.set_location('LER '||l_lertrg_set(ler_row).ler_id, 20);
208: hr_utility.set_location('COLUMN '||l_column, 20);
209: hr_utility.set_location('NEWVAL '||l_new_val, 20);
210: hr_utility.set_location('OLDVAL '||l_old_val, 20);
211: hr_utility.set_location('TYPE '||l_type, 20);
212: hr_utility.set_location('CD '||l_lertrg_set(ler_row).ocrd_dt_det_cd, 20);
213: hr_utility.set_location('enrt cvg strt dt'||p_new.enrt_cvg_strt_dt, 20);
214: hr_utility.set_location('enrt cvg thru dt '||p_new.enrt_cvg_thru_dt, 20);
215: l_changed := TRUE;

Line 212: hr_utility.set_location('CD '||l_lertrg_set(ler_row).ocrd_dt_det_cd, 20);

208: hr_utility.set_location('COLUMN '||l_column, 20);
209: hr_utility.set_location('NEWVAL '||l_new_val, 20);
210: hr_utility.set_location('OLDVAL '||l_old_val, 20);
211: hr_utility.set_location('TYPE '||l_type, 20);
212: hr_utility.set_location('CD '||l_lertrg_set(ler_row).ocrd_dt_det_cd, 20);
213: hr_utility.set_location('enrt cvg strt dt'||p_new.enrt_cvg_strt_dt, 20);
214: hr_utility.set_location('enrt cvg thru dt '||p_new.enrt_cvg_thru_dt, 20);
215: l_changed := TRUE;
216: if get_ler_col%ROWCOUNT = 1 then

Line 213: hr_utility.set_location('enrt cvg strt dt'||p_new.enrt_cvg_strt_dt, 20);

209: hr_utility.set_location('NEWVAL '||l_new_val, 20);
210: hr_utility.set_location('OLDVAL '||l_old_val, 20);
211: hr_utility.set_location('TYPE '||l_type, 20);
212: hr_utility.set_location('CD '||l_lertrg_set(ler_row).ocrd_dt_det_cd, 20);
213: hr_utility.set_location('enrt cvg strt dt'||p_new.enrt_cvg_strt_dt, 20);
214: hr_utility.set_location('enrt cvg thru dt '||p_new.enrt_cvg_thru_dt, 20);
215: l_changed := TRUE;
216: if get_ler_col%ROWCOUNT = 1 then
217: l_changed := TRUE;

Line 214: hr_utility.set_location('enrt cvg thru dt '||p_new.enrt_cvg_thru_dt, 20);

210: hr_utility.set_location('OLDVAL '||l_old_val, 20);
211: hr_utility.set_location('TYPE '||l_type, 20);
212: hr_utility.set_location('CD '||l_lertrg_set(ler_row).ocrd_dt_det_cd, 20);
213: hr_utility.set_location('enrt cvg strt dt'||p_new.enrt_cvg_strt_dt, 20);
214: hr_utility.set_location('enrt cvg thru dt '||p_new.enrt_cvg_thru_dt, 20);
215: l_changed := TRUE;
216: if get_ler_col%ROWCOUNT = 1 then
217: l_changed := TRUE;
218: end if;

Line 219: hr_utility.set_location(' ben_pen_trigger', 50);

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

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

295: ,p_new.enrt_cvg_strt_dt,l_new_val) AND
296: benutils.column_changed(p_new.enrt_cvg_strt_dt
297: ,p_old.enrt_cvg_strt_dt,l_old_val) AND
298: (l_changed));
299: hr_utility.set_location(' l_changed:',40);
300: end if;
301: --
302: if l_column = 'ENRT_CVG_THRU_DT' then
303: if p_new.enrt_cvg_thru_dt = hr_api.g_eot then

Line 329: hr_utility.set_location('Old bnft_amt '||p_old.bnft_amt, 20);

325: --
326: end if;
327: --
328: if l_column = 'BNFT_AMT' then
329: hr_utility.set_location('Old bnft_amt '||p_old.bnft_amt, 20);
330: hr_utility.set_location('New bnft_amt '||p_new.bnft_amt, 20);
331: hr_utility.set_location('lodt '||l_lf_evt_ocrd_date, 20);
332: l_changed := (benutils.column_changed(p_old.bnft_amt
333: ,p_new.bnft_amt,l_new_val) AND

Line 330: hr_utility.set_location('New bnft_amt '||p_new.bnft_amt, 20);

326: end if;
327: --
328: if l_column = 'BNFT_AMT' then
329: hr_utility.set_location('Old bnft_amt '||p_old.bnft_amt, 20);
330: hr_utility.set_location('New bnft_amt '||p_new.bnft_amt, 20);
331: hr_utility.set_location('lodt '||l_lf_evt_ocrd_date, 20);
332: l_changed := (benutils.column_changed(p_old.bnft_amt
333: ,p_new.bnft_amt,l_new_val) AND
334: benutils.column_changed(p_new.bnft_amt

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

327: --
328: if l_column = 'BNFT_AMT' then
329: hr_utility.set_location('Old bnft_amt '||p_old.bnft_amt, 20);
330: hr_utility.set_location('New bnft_amt '||p_new.bnft_amt, 20);
331: hr_utility.set_location('lodt '||l_lf_evt_ocrd_date, 20);
332: l_changed := (benutils.column_changed(p_old.bnft_amt
333: ,p_new.bnft_amt,l_new_val) AND
334: benutils.column_changed(p_new.bnft_amt
335: ,p_old.bnft_amt,l_old_val) AND

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

343: l_changed := TRUE ;
344: elsif l_rule_output = 'Y' and l_rule_overrides_flag = 'N' then
345: l_changed := l_changed AND TRUE;
346: elsif l_rule_output = 'N' then
347: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
348: l_changed := FALSE;
349: end if;
350:
351: hr_utility.set_location('After the rule Check ',20.05);

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

347: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
348: l_changed := FALSE;
349: end if;
350:
351: hr_utility.set_location('After the rule Check ',20.05);
352: if l_changed then
353: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
354: else
355: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);

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

349: end if;
350:
351: hr_utility.set_location('After the rule Check ',20.05);
352: if l_changed then
353: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
354: else
355: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
356: end if;
357: -- Check for Column Mandatory Change

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

351: hr_utility.set_location('After the rule Check ',20.05);
352: if l_changed then
353: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
354: else
355: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
356: end if;
357: -- Check for Column Mandatory Change
358: -- If column change is mandatory and data change has failed then dont trigger
359: -- If column change is non-mandatory and the data change has passed, then trigger.

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

358: -- If column change is mandatory and data change has failed then dont trigger
359: -- If column change is non-mandatory and the data change has passed, then trigger.
360:
361: if l_chg_mandatory_cd = 'Y' and not l_changed then
362: hr_utility.set_location('Found Mandatory and its failed ', 20.1);
363: l_changed := FALSE;
364: l_trigger := FALSE;
365: exit;
366: elsif l_chg_mandatory_cd = 'Y' and l_changed then

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

363: l_changed := FALSE;
364: l_trigger := FALSE;
365: exit;
366: elsif l_chg_mandatory_cd = 'Y' and l_changed then
367: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
368: l_changed := TRUE;
369: -- exit; */
370: elsif l_chg_mandatory_cd = 'N' and l_changed then
371: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);

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

367: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
368: l_changed := TRUE;
369: -- exit; */
370: elsif l_chg_mandatory_cd = 'N' and l_changed then
371: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);
372: l_changed := TRUE;
373: l_trigger := TRUE;
374: exit;
375: end if;

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

373: l_trigger := TRUE;
374: exit;
375: end if;
376:
377: hr_utility.set_location('After the Mandatory code check ',20.05);
378: if l_changed then
379: hr_utility.set_location(' l_change TRUE ', 20.1);
380: else
381: hr_utility.set_location(' l_change FALSE ', 20.1);

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

375: end if;
376:
377: hr_utility.set_location('After the Mandatory code check ',20.05);
378: if l_changed then
379: hr_utility.set_location(' l_change TRUE ', 20.1);
380: else
381: hr_utility.set_location(' l_change FALSE ', 20.1);
382: end if;
383: --

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

377: hr_utility.set_location('After the Mandatory code check ',20.05);
378: if l_changed then
379: hr_utility.set_location(' l_change TRUE ', 20.1);
380: else
381: hr_utility.set_location(' l_change FALSE ', 20.1);
382: end if;
383: --
384:
385: /* if not l_changed then

Line 390: hr_utility.set_location(' ben_pen_trigger', 50);

386: exit;
387: end if; */
388: --
389: end loop;
390: hr_utility.set_location(' ben_pen_trigger', 50);
391: l_ptnl_id := 0;
392: l_ovn :=null;
393: if l_trigger then
394: if l_type = 'P' then

Line 398: hr_utility.set_location(' Entering: ben_pen_trigger5', 60);

394: if l_type = 'P' then
395: open le_exists(p_new.person_id,l_lertrg_set(ler_row).ler_id,l_lf_evt_ocrd_date);
396: fetch le_exists into l_le_exists;
397: if le_exists%notfound then
398: hr_utility.set_location(' Entering: ben_pen_trigger5', 60);
399:
400: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
401: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
402: (p_validate => false

Line 417: hr_utility.set_location(' Entering: ben_pen_trigger5-', 65);

413: ,p_dtctd_dt => l_effective_start_date);
414: end if;
415: close le_exists;
416: elsif l_type = 'R' then
417: hr_utility.set_location(' Entering: ben_pen_trigger5-', 65);
418: open get_contacts(p_new.person_id);
419: loop
420: fetch get_contacts into l_hld_person_id;
421: exit when get_contacts%notfound;

Line 425: hr_utility.set_location(' Entering: ben_pen_trigger5', 60);

421: exit when get_contacts%notfound;
422: open le_exists(l_hld_person_id,l_lertrg_set(ler_row).ler_id,l_lf_evt_ocrd_date);
423: fetch le_exists into l_le_exists;
424: if le_exists%notfound then
425: hr_utility.set_location(' Entering: ben_pen_trigger5', 60);
426: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
427: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
428: (p_validate => false
429: ,p_ptnl_ler_for_per_id => l_ptnl_id

Line 450: hr_utility.set_location(' ben_pen_trigger', 40);

446: end if;
447: --
448: -- reset the variables.
449: --
450: hr_utility.set_location(' ben_pen_trigger', 40);
451: l_changed := FALSE;
452: l_trigger := TRUE;
453: l_ovn := NULL;
454: l_effective_start_date := l_session_date;

Line 459: hr_utility.set_location(' ben_pen_trigger', 50);

455: -- l_lf_evt_ocrd_date := l_session_date;
456: end if;
457: close get_ler_col;
458: end loop;
459: hr_utility.set_location(' ben_pen_trigger', 50);
460: end if;
461:
462: hr_utility.set_location(' leaving ben_pen_trigger', 60);
463:

Line 462: hr_utility.set_location(' leaving ben_pen_trigger', 60);

458: end loop;
459: hr_utility.set_location(' ben_pen_trigger', 50);
460: end if;
461:
462: hr_utility.set_location(' leaving ben_pen_trigger', 60);
463:
464: end;
465: end ben_pen_ler;