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

Line 164: hr_utility.set_location(' Entering: ben_ptu_trigger', 10);

160: ,status => l_status
161: ,industry => l_industry);
162:
163: begin
164: hr_utility.set_location(' Entering: ben_ptu_trigger', 10);
165: l_changed := FALSE;
166: If p_effective_date is not null then
167: l_session_date := p_effective_date ;
168: else

Line 183: hr_utility.set_location('sess '||l_session_date, 20);

179: open get_business_group_id;
180: fetch get_business_group_id into l_business_group_id;
181: close get_business_group_id;
182:
183: hr_utility.set_location('sess '||l_session_date, 20);
184: hr_utility.set_location('PERSON '||p_new.person_id, 20);
185: hr_utility.set_location('BG '||l_business_group_id, 20);
186: --
187: open get_ler(l_status);

Line 184: hr_utility.set_location('PERSON '||p_new.person_id, 20);

180: fetch get_business_group_id into l_business_group_id;
181: close get_business_group_id;
182:
183: hr_utility.set_location('sess '||l_session_date, 20);
184: hr_utility.set_location('PERSON '||p_new.person_id, 20);
185: hr_utility.set_location('BG '||l_business_group_id, 20);
186: --
187: open get_ler(l_status);
188: loop

Line 185: hr_utility.set_location('BG '||l_business_group_id, 20);

181: close get_business_group_id;
182:
183: hr_utility.set_location('sess '||l_session_date, 20);
184: hr_utility.set_location('PERSON '||p_new.person_id, 20);
185: hr_utility.set_location('BG '||l_business_group_id, 20);
186: --
187: open get_ler(l_status);
188: loop
189: fetch get_ler into l_ler_id,l_typ_cd, l_ocrd_dt_cd;

Line 192: hr_utility.set_location('ROWS FOUND HERE MUPPET',10);

188: loop
189: fetch get_ler into l_ler_id,l_typ_cd, l_ocrd_dt_cd;
190: exit when get_ler%notfound;
191: l_trigger := TRUE;
192: hr_utility.set_location('ROWS FOUND HERE MUPPET',10);
193: if l_ocrd_dt_cd is null then
194: l_lf_evt_ocrd_date := p_new.effective_start_date;
195: else
196: --

Line 211: hr_utility.set_location('ROWS FOUND HERE AS WELL MUPPET',10);

207: open get_ler_col(l_ler_id);
208: loop
209: 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;
210: exit when get_ler_col%NOTFOUND;
211: hr_utility.set_location('ROWS FOUND HERE AS WELL MUPPET',10);
212: hr_utility.set_location('LER '||l_ler_id, 20);
213: hr_utility.set_location('det cd '||l_ocrd_dt_cd, 20);
214: hr_utility.set_location('COLUMN '||l_column, 20);
215: hr_utility.set_location('OLDVAL '||l_old_val, 20);

Line 212: hr_utility.set_location('LER '||l_ler_id, 20);

208: loop
209: 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;
210: exit when get_ler_col%NOTFOUND;
211: hr_utility.set_location('ROWS FOUND HERE AS WELL MUPPET',10);
212: hr_utility.set_location('LER '||l_ler_id, 20);
213: hr_utility.set_location('det cd '||l_ocrd_dt_cd, 20);
214: hr_utility.set_location('COLUMN '||l_column, 20);
215: hr_utility.set_location('OLDVAL '||l_old_val, 20);
216: hr_utility.set_location('NEWVAL '||l_new_val, 20);

Line 213: hr_utility.set_location('det cd '||l_ocrd_dt_cd, 20);

209: 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;
210: exit when get_ler_col%NOTFOUND;
211: hr_utility.set_location('ROWS FOUND HERE AS WELL MUPPET',10);
212: hr_utility.set_location('LER '||l_ler_id, 20);
213: hr_utility.set_location('det cd '||l_ocrd_dt_cd, 20);
214: hr_utility.set_location('COLUMN '||l_column, 20);
215: hr_utility.set_location('OLDVAL '||l_old_val, 20);
216: hr_utility.set_location('NEWVAL '||l_new_val, 20);
217: hr_utility.set_location('TYPE '||l_type, 20);

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

210: exit when get_ler_col%NOTFOUND;
211: hr_utility.set_location('ROWS FOUND HERE AS WELL MUPPET',10);
212: hr_utility.set_location('LER '||l_ler_id, 20);
213: hr_utility.set_location('det cd '||l_ocrd_dt_cd, 20);
214: hr_utility.set_location('COLUMN '||l_column, 20);
215: hr_utility.set_location('OLDVAL '||l_old_val, 20);
216: hr_utility.set_location('NEWVAL '||l_new_val, 20);
217: hr_utility.set_location('TYPE '||l_type, 20);
218: l_changed := TRUE;

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

211: hr_utility.set_location('ROWS FOUND HERE AS WELL MUPPET',10);
212: hr_utility.set_location('LER '||l_ler_id, 20);
213: hr_utility.set_location('det cd '||l_ocrd_dt_cd, 20);
214: hr_utility.set_location('COLUMN '||l_column, 20);
215: hr_utility.set_location('OLDVAL '||l_old_val, 20);
216: hr_utility.set_location('NEWVAL '||l_new_val, 20);
217: hr_utility.set_location('TYPE '||l_type, 20);
218: l_changed := TRUE;
219: if get_ler_col%ROWCOUNT = 1 then

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

212: hr_utility.set_location('LER '||l_ler_id, 20);
213: hr_utility.set_location('det cd '||l_ocrd_dt_cd, 20);
214: hr_utility.set_location('COLUMN '||l_column, 20);
215: hr_utility.set_location('OLDVAL '||l_old_val, 20);
216: hr_utility.set_location('NEWVAL '||l_new_val, 20);
217: hr_utility.set_location('TYPE '||l_type, 20);
218: l_changed := TRUE;
219: if get_ler_col%ROWCOUNT = 1 then
220: l_changed := TRUE;

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

213: hr_utility.set_location('det cd '||l_ocrd_dt_cd, 20);
214: hr_utility.set_location('COLUMN '||l_column, 20);
215: hr_utility.set_location('OLDVAL '||l_old_val, 20);
216: hr_utility.set_location('NEWVAL '||l_new_val, 20);
217: hr_utility.set_location('TYPE '||l_type, 20);
218: l_changed := TRUE;
219: if get_ler_col%ROWCOUNT = 1 then
220: l_changed := TRUE;
221: hr_utility.set_location('rowcount 1 ', 20);

Line 221: hr_utility.set_location('rowcount 1 ', 20);

217: hr_utility.set_location('TYPE '||l_type, 20);
218: l_changed := TRUE;
219: if get_ler_col%ROWCOUNT = 1 then
220: l_changed := TRUE;
221: hr_utility.set_location('rowcount 1 ', 20);
222: end if;
223: hr_utility.set_location(' ben_ptu_trigger', 20);
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

Line 223: hr_utility.set_location(' ben_ptu_trigger', 20);

219: if get_ler_col%ROWCOUNT = 1 then
220: l_changed := TRUE;
221: hr_utility.set_location('rowcount 1 ', 20);
222: end if;
223: hr_utility.set_location(' ben_ptu_trigger', 20);
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 298: hr_utility.set_location('New perty'||p_new.person_type_id, 20);

294: --
295:
296: --
297: if l_column = 'PERSON_TYPE_ID' then
298: hr_utility.set_location('New perty'||p_new.person_type_id, 20);
299: hr_utility.set_location('Old perty'||p_old.person_type_id, 20);
300: l_changed := (benutils.column_changed(p_old.person_type_id
301: ,p_new.person_type_id,l_new_val) AND
302: benutils.column_changed(p_new.person_type_id

Line 299: hr_utility.set_location('Old perty'||p_old.person_type_id, 20);

295:
296: --
297: if l_column = 'PERSON_TYPE_ID' then
298: hr_utility.set_location('New perty'||p_new.person_type_id, 20);
299: hr_utility.set_location('Old perty'||p_old.person_type_id, 20);
300: l_changed := (benutils.column_changed(p_old.person_type_id
301: ,p_new.person_type_id,l_new_val) AND
302: benutils.column_changed(p_new.person_type_id
303: ,p_old.person_type_id,l_old_val) AND

Line 306: hr_utility.set_location(' ben_ptu_trigger', 21);

302: benutils.column_changed(p_new.person_type_id
303: ,p_old.person_type_id,l_old_val) AND
304: (l_changed));
305: end if;
306: hr_utility.set_location(' ben_ptu_trigger', 21);
307: --
308: if l_column = 'EFFECTIVE_START_DATE' then
309: l_changed := (benutils.column_changed(p_old.effective_start_date
310: ,p_new.effective_start_date,l_new_val) AND

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

310: ,p_new.effective_start_date,l_new_val) AND
311: benutils.column_changed(p_new.effective_start_date
312: ,p_old.effective_start_date,l_old_val) AND
313: (l_changed));
314: hr_utility.set_location(' l_changed:',40);
315: end if;
316: --
317: if l_column = 'EFFECTIVE_END_DATE' then
318: hr_utility.set_location('New eed'||p_new.effective_end_date, 20);

Line 318: hr_utility.set_location('New eed'||p_new.effective_end_date, 20);

314: hr_utility.set_location(' l_changed:',40);
315: end if;
316: --
317: if l_column = 'EFFECTIVE_END_DATE' then
318: hr_utility.set_location('New eed'||p_new.effective_end_date, 20);
319: hr_utility.set_location('Old eed'||p_old.effective_end_date, 20);
320: if p_new.effective_end_date = hr_api.g_eot then
321: l_changed := FALSE;
322: end if;

Line 319: hr_utility.set_location('Old eed'||p_old.effective_end_date, 20);

315: end if;
316: --
317: if l_column = 'EFFECTIVE_END_DATE' then
318: hr_utility.set_location('New eed'||p_new.effective_end_date, 20);
319: hr_utility.set_location('Old eed'||p_old.effective_end_date, 20);
320: if p_new.effective_end_date = hr_api.g_eot then
321: l_changed := FALSE;
322: end if;
323: l_changed := (benutils.column_changed(p_old.effective_end_date

Line 328: -- hr_utility.set_location(' l_changed:'||l_changed,40);

324: ,p_new.effective_end_date,l_new_val) AND
325: benutils.column_changed(p_new.effective_end_date
326: ,p_old.effective_end_date,l_old_val) AND
327: (l_changed));
328: -- hr_utility.set_location(' l_changed:'||l_changed,40);
329: --
330: if l_ocrd_dt_cd is null then
331: l_lf_evt_ocrd_date := p_new.effective_end_date;
332: else

Line 344: hr_utility.set_location(' l_lf_evt_ocrd_date:'||l_lf_evt_ocrd_date,40);

340: ,p_returned_date => l_lf_evt_ocrd_date
341: );
342: end if;
343: --
344: hr_utility.set_location(' l_lf_evt_ocrd_date:'||l_lf_evt_ocrd_date,40);
345: end if;
346: --
347: --
348: -- Checking the rule output and the rule override flag.

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

353: l_changed := TRUE ;
354: elsif l_rule_output = 'Y' and l_rule_overrides_flag = 'N' then
355: l_changed := l_changed AND TRUE;
356: elsif l_rule_output = 'N' then
357: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
358: l_changed := FALSE;
359: end if;
360:
361: hr_utility.set_location('After the rule Check ',20.05);

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

357: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
358: l_changed := FALSE;
359: end if;
360:
361: hr_utility.set_location('After the rule Check ',20.05);
362: if l_changed then
363: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
364: else
365: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);

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

359: end if;
360:
361: hr_utility.set_location('After the rule Check ',20.05);
362: if l_changed then
363: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
364: else
365: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
366: end if;
367: -- Check for Column Mandatory Change

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

361: hr_utility.set_location('After the rule Check ',20.05);
362: if l_changed then
363: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
364: else
365: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
366: end if;
367: -- Check for Column Mandatory Change
368: -- If column change is mandatory and data change has failed then dont trigger
369: -- If column change is non-mandatory and the data change has passed, then trigger.

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

368: -- If column change is mandatory and data change has failed then dont trigger
369: -- If column change is non-mandatory and the data change has passed, then trigger.
370:
371: if l_chg_mandatory_cd = 'Y' and not l_changed then
372: hr_utility.set_location('Found Mandatory and its failed ', 20.1);
373: l_changed := FALSE;
374: l_trigger := FALSE;
375: exit;
376: elsif l_chg_mandatory_cd = 'Y' and l_changed then

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

373: l_changed := FALSE;
374: l_trigger := FALSE;
375: exit;
376: elsif l_chg_mandatory_cd = 'Y' and l_changed then
377: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
378: l_changed := TRUE;
379: -- exit; */
380: elsif l_chg_mandatory_cd = 'N' and l_changed then
381: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);

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

377: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
378: l_changed := TRUE;
379: -- exit; */
380: elsif l_chg_mandatory_cd = 'N' and l_changed then
381: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);
382: l_changed := TRUE;
383: l_trigger := TRUE;
384: exit;
385: end if;

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

383: l_trigger := TRUE;
384: exit;
385: end if;
386:
387: hr_utility.set_location('After the Mandatory code check ',20.05);
388: if l_changed then
389: hr_utility.set_location(' l_change TRUE ', 20.1);
390: else
391: hr_utility.set_location(' l_change FALSE ', 20.1);

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

385: end if;
386:
387: hr_utility.set_location('After the Mandatory code check ',20.05);
388: if l_changed then
389: hr_utility.set_location(' l_change TRUE ', 20.1);
390: else
391: hr_utility.set_location(' l_change FALSE ', 20.1);
392: end if;
393: --

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

387: hr_utility.set_location('After the Mandatory code check ',20.05);
388: if l_changed then
389: hr_utility.set_location(' l_change TRUE ', 20.1);
390: else
391: hr_utility.set_location(' l_change FALSE ', 20.1);
392: end if;
393: --
394: /* if not l_changed then
395: exit;

Line 398: hr_utility.set_location(' ben_ptu_trigger', 30);

394: /* if not l_changed then
395: exit;
396: end if; */
397: end loop;
398: hr_utility.set_location(' ben_ptu_trigger', 30);
399: l_ptnl_id := 0;
400: l_ovn :=null;
401: if l_trigger then
402: if l_type = 'P' then

Line 406: hr_utility.set_location(' Entering: ben_ptu_trigger5', 60);

402: if l_type = 'P' then
403: open le_exists(p_new.person_id,l_ler_id,l_lf_evt_ocrd_date);
404: fetch le_exists into l_le_exists;
405: if le_exists%notfound then
406: hr_utility.set_location(' Entering: ben_ptu_trigger5', 60);
407:
408: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
409: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
410: (p_validate => false

Line 425: hr_utility.set_location(' Entering: ben_ptu_trigger5-', 65);

421: ,p_dtctd_dt => l_effective_start_date);
422: end if;
423: close le_exists;
424: elsif l_type = 'R' then
425: hr_utility.set_location(' Entering: ben_ptu_trigger5-', 65);
426: open get_contacts(p_new.person_id);
427: loop
428: fetch get_contacts into l_hld_person_id;
429: exit when get_contacts%notfound;

Line 433: hr_utility.set_location(' Entering: ben_ptu_trigger5', 60);

429: exit when get_contacts%notfound;
430: open le_exists(l_hld_person_id,l_ler_id,l_lf_evt_ocrd_date);
431: fetch le_exists into l_le_exists;
432: if le_exists%notfound then
433: hr_utility.set_location(' Entering: ben_ptu_trigger5', 60);
434: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
435: -- ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
436: (p_validate => false
437: ,p_ptnl_ler_for_per_id => l_ptnl_id

Line 458: hr_utility.set_location(' ben_ptu_trigger', 40);

454: end if;
455: --
456: -- reset the variables.
457: --
458: hr_utility.set_location(' ben_ptu_trigger', 40);
459: l_changed := FALSE;
460: l_trigger := TRUE;
461: l_ovn := NULL;
462: l_effective_start_date := l_session_date;

Line 467: hr_utility.set_location(' ben_ptu_trigger', 50);

463: -- l_lf_evt_ocrd_date := l_session_date;
464: end if;
465: close get_ler_col;
466: end loop;
467: hr_utility.set_location(' ben_ptu_trigger', 50);
468: close get_ler;
469: hr_utility.set_location(' leaving ben_ptu_trigger', 70);
470: exception
471: when others then

Line 469: hr_utility.set_location(' leaving ben_ptu_trigger', 70);

465: close get_ler_col;
466: end loop;
467: hr_utility.set_location(' ben_ptu_trigger', 50);
468: close get_ler;
469: hr_utility.set_location(' leaving ben_ptu_trigger', 70);
470: exception
471: when others then
472: hr_utility.set_location(sqlerrm, 70);
473: raise;

Line 472: hr_utility.set_location(sqlerrm, 70);

468: close get_ler;
469: hr_utility.set_location(' leaving ben_ptu_trigger', 70);
470: exception
471: when others then
472: hr_utility.set_location(sqlerrm, 70);
473: raise;
474: end;
475: end;
476: end ben_ptu_ler;