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

Line 192: hr_utility.set_location(' Entering: '||l_proc, 10);

188: ,dep_appl_id =>805
189: ,status => l_status
190: ,industry => l_industry);
191:
192: hr_utility.set_location(' Entering: '||l_proc, 10);
193: l_changed := FALSE;
194:
195: If p_effective_date is not null then
196: l_initial_date := p_effective_date ;

Line 224: hr_utility.set_location(l_proc, 20);

220: -- Bug 3105696
221:
222: l_effective_start_date := l_session_date;
223:
224: hr_utility.set_location(l_proc, 20);
225: hr_utility.set_location('CONTACT PERSON '||p_new.contact_person_id, 20);
226: hr_utility.set_location('PERSON '||p_new.person_id, 20);
227: hr_utility.set_location('BG '||p_new.business_group_id, 20);
228:

Line 225: hr_utility.set_location('CONTACT PERSON '||p_new.contact_person_id, 20);

221:
222: l_effective_start_date := l_session_date;
223:
224: hr_utility.set_location(l_proc, 20);
225: hr_utility.set_location('CONTACT PERSON '||p_new.contact_person_id, 20);
226: hr_utility.set_location('PERSON '||p_new.person_id, 20);
227: hr_utility.set_location('BG '||p_new.business_group_id, 20);
228:
229: -- in some situations the date we use for occured on date is null,

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

222: l_effective_start_date := l_session_date;
223:
224: hr_utility.set_location(l_proc, 20);
225: hr_utility.set_location('CONTACT PERSON '||p_new.contact_person_id, 20);
226: hr_utility.set_location('PERSON '||p_new.person_id, 20);
227: hr_utility.set_location('BG '||p_new.business_group_id, 20);
228:
229: -- in some situations the date we use for occured on date is null,
230: -- use session date instead.

Line 227: hr_utility.set_location('BG '||p_new.business_group_id, 20);

223:
224: hr_utility.set_location(l_proc, 20);
225: hr_utility.set_location('CONTACT PERSON '||p_new.contact_person_id, 20);
226: hr_utility.set_location('PERSON '||p_new.person_id, 20);
227: hr_utility.set_location('BG '||p_new.business_group_id, 20);
228:
229: -- in some situations the date we use for occured on date is null,
230: -- use session date instead.
231: if p_new.date_start is null then

Line 259: hr_utility.set_location(' l_person_esd:'||to_char(l_person_esd), 30);

255: l_effective_start_date := nvl(l_person_esd, l_date_start) ;
256: --
257: end if;
258: --
259: hr_utility.set_location(' l_person_esd:'||to_char(l_person_esd), 30);
260: hr_utility.set_location(' l_date_start:'||to_char(l_date_start), 30);
261: hr_utility.set_location(' l_system_date:'||to_char(l_system_date), 30);
262: hr_utility.set_location(' l_session_date:'||to_char(l_session_date), 30);
263: hr_utility.set_location('l_initial_date:'||to_char(l_initial_date), 30);

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

256: --
257: end if;
258: --
259: hr_utility.set_location(' l_person_esd:'||to_char(l_person_esd), 30);
260: hr_utility.set_location(' l_date_start:'||to_char(l_date_start), 30);
261: hr_utility.set_location(' l_system_date:'||to_char(l_system_date), 30);
262: hr_utility.set_location(' l_session_date:'||to_char(l_session_date), 30);
263: hr_utility.set_location('l_initial_date:'||to_char(l_initial_date), 30);
264: hr_utility.set_location('l_effective_start_date: '||to_char(l_effective_start_date),30);

Line 261: hr_utility.set_location(' l_system_date:'||to_char(l_system_date), 30);

257: end if;
258: --
259: hr_utility.set_location(' l_person_esd:'||to_char(l_person_esd), 30);
260: hr_utility.set_location(' l_date_start:'||to_char(l_date_start), 30);
261: hr_utility.set_location(' l_system_date:'||to_char(l_system_date), 30);
262: hr_utility.set_location(' l_session_date:'||to_char(l_session_date), 30);
263: hr_utility.set_location('l_initial_date:'||to_char(l_initial_date), 30);
264: hr_utility.set_location('l_effective_start_date: '||to_char(l_effective_start_date),30);
265: --

Line 262: hr_utility.set_location(' l_session_date:'||to_char(l_session_date), 30);

258: --
259: hr_utility.set_location(' l_person_esd:'||to_char(l_person_esd), 30);
260: hr_utility.set_location(' l_date_start:'||to_char(l_date_start), 30);
261: hr_utility.set_location(' l_system_date:'||to_char(l_system_date), 30);
262: hr_utility.set_location(' l_session_date:'||to_char(l_session_date), 30);
263: hr_utility.set_location('l_initial_date:'||to_char(l_initial_date), 30);
264: hr_utility.set_location('l_effective_start_date: '||to_char(l_effective_start_date),30);
265: --
266: open get_ler(l_status);

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

259: hr_utility.set_location(' l_person_esd:'||to_char(l_person_esd), 30);
260: hr_utility.set_location(' l_date_start:'||to_char(l_date_start), 30);
261: hr_utility.set_location(' l_system_date:'||to_char(l_system_date), 30);
262: hr_utility.set_location(' l_session_date:'||to_char(l_session_date), 30);
263: hr_utility.set_location('l_initial_date:'||to_char(l_initial_date), 30);
264: hr_utility.set_location('l_effective_start_date: '||to_char(l_effective_start_date),30);
265: --
266: open get_ler(l_status);
267: loop

Line 264: hr_utility.set_location('l_effective_start_date: '||to_char(l_effective_start_date),30);

260: hr_utility.set_location(' l_date_start:'||to_char(l_date_start), 30);
261: hr_utility.set_location(' l_system_date:'||to_char(l_system_date), 30);
262: hr_utility.set_location(' l_session_date:'||to_char(l_session_date), 30);
263: hr_utility.set_location('l_initial_date:'||to_char(l_initial_date), 30);
264: hr_utility.set_location('l_effective_start_date: '||to_char(l_effective_start_date),30);
265: --
266: open get_ler(l_status);
267: loop
268: fetch get_ler into l_ler_id,l_typ_cd, l_ocrd_dt_cd, l_ler_eff_strt_dt;

Line 286: hr_utility.set_location(' l_lf_evt_ocrd_date ' ||l_lf_evt_ocrd_date, 95);

282: ,p_returned_date => l_lf_evt_ocrd_date
283: );
284: end if;
285:
286: hr_utility.set_location(' l_lf_evt_ocrd_date ' ||l_lf_evt_ocrd_date, 95);
287: hr_utility.set_location(' l_effective_start_date ' ||l_effective_start_date, 95);
288: hr_utility.set_location(' l_dtctd_dt ' ||l_dtctd_dt, 95);
289: hr_utility.set_location(' l_ler_eff_strt_dt ' ||l_ler_eff_strt_dt, 95);
290:

Line 287: hr_utility.set_location(' l_effective_start_date ' ||l_effective_start_date, 95);

283: );
284: end if;
285:
286: hr_utility.set_location(' l_lf_evt_ocrd_date ' ||l_lf_evt_ocrd_date, 95);
287: hr_utility.set_location(' l_effective_start_date ' ||l_effective_start_date, 95);
288: hr_utility.set_location(' l_dtctd_dt ' ||l_dtctd_dt, 95);
289: hr_utility.set_location(' l_ler_eff_strt_dt ' ||l_ler_eff_strt_dt, 95);
290:
291: open get_ler_col(l_ler_id);

Line 288: hr_utility.set_location(' l_dtctd_dt ' ||l_dtctd_dt, 95);

284: end if;
285:
286: hr_utility.set_location(' l_lf_evt_ocrd_date ' ||l_lf_evt_ocrd_date, 95);
287: hr_utility.set_location(' l_effective_start_date ' ||l_effective_start_date, 95);
288: hr_utility.set_location(' l_dtctd_dt ' ||l_dtctd_dt, 95);
289: hr_utility.set_location(' l_ler_eff_strt_dt ' ||l_ler_eff_strt_dt, 95);
290:
291: open get_ler_col(l_ler_id);
292: loop

Line 289: hr_utility.set_location(' l_ler_eff_strt_dt ' ||l_ler_eff_strt_dt, 95);

285:
286: hr_utility.set_location(' l_lf_evt_ocrd_date ' ||l_lf_evt_ocrd_date, 95);
287: hr_utility.set_location(' l_effective_start_date ' ||l_effective_start_date, 95);
288: hr_utility.set_location(' l_dtctd_dt ' ||l_dtctd_dt, 95);
289: hr_utility.set_location(' l_ler_eff_strt_dt ' ||l_ler_eff_strt_dt, 95);
290:
291: open get_ler_col(l_ler_id);
292: loop
293: 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;

Line 295: hr_utility.set_location('LER '||l_ler_id, 40);

291: open get_ler_col(l_ler_id);
292: loop
293: 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;
294: exit when get_ler_col%NOTFOUND;
295: hr_utility.set_location('LER '||l_ler_id, 40);
296: hr_utility.set_location('COLUMN '||l_column, 40);
297: hr_utility.set_location('NEWVAL '||l_new_val, 40);
298: hr_utility.set_location('OLDVAL '||l_old_val, 40);
299: hr_utility.set_location('TYPE '||l_type, 40);

Line 296: hr_utility.set_location('COLUMN '||l_column, 40);

292: loop
293: 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;
294: exit when get_ler_col%NOTFOUND;
295: hr_utility.set_location('LER '||l_ler_id, 40);
296: hr_utility.set_location('COLUMN '||l_column, 40);
297: hr_utility.set_location('NEWVAL '||l_new_val, 40);
298: hr_utility.set_location('OLDVAL '||l_old_val, 40);
299: hr_utility.set_location('TYPE '||l_type, 40);
300: --l_changed := TRUE; -- Bug 6219676 -- No need of this

Line 297: hr_utility.set_location('NEWVAL '||l_new_val, 40);

293: 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;
294: exit when get_ler_col%NOTFOUND;
295: hr_utility.set_location('LER '||l_ler_id, 40);
296: hr_utility.set_location('COLUMN '||l_column, 40);
297: hr_utility.set_location('NEWVAL '||l_new_val, 40);
298: hr_utility.set_location('OLDVAL '||l_old_val, 40);
299: hr_utility.set_location('TYPE '||l_type, 40);
300: --l_changed := TRUE; -- Bug 6219676 -- No need of this
301: if get_ler_col%ROWCOUNT = 1 then

Line 298: hr_utility.set_location('OLDVAL '||l_old_val, 40);

294: exit when get_ler_col%NOTFOUND;
295: hr_utility.set_location('LER '||l_ler_id, 40);
296: hr_utility.set_location('COLUMN '||l_column, 40);
297: hr_utility.set_location('NEWVAL '||l_new_val, 40);
298: hr_utility.set_location('OLDVAL '||l_old_val, 40);
299: hr_utility.set_location('TYPE '||l_type, 40);
300: --l_changed := TRUE; -- Bug 6219676 -- No need of this
301: if get_ler_col%ROWCOUNT = 1 then
302: hr_utility.set_location('rowcount 1 ', 50);

Line 299: hr_utility.set_location('TYPE '||l_type, 40);

295: hr_utility.set_location('LER '||l_ler_id, 40);
296: hr_utility.set_location('COLUMN '||l_column, 40);
297: hr_utility.set_location('NEWVAL '||l_new_val, 40);
298: hr_utility.set_location('OLDVAL '||l_old_val, 40);
299: hr_utility.set_location('TYPE '||l_type, 40);
300: --l_changed := TRUE; -- Bug 6219676 -- No need of this
301: if get_ler_col%ROWCOUNT = 1 then
302: hr_utility.set_location('rowcount 1 ', 50);
303: l_changed := TRUE;

Line 302: hr_utility.set_location('rowcount 1 ', 50);

298: hr_utility.set_location('OLDVAL '||l_old_val, 40);
299: hr_utility.set_location('TYPE '||l_type, 40);
300: --l_changed := TRUE; -- Bug 6219676 -- No need of this
301: if get_ler_col%ROWCOUNT = 1 then
302: hr_utility.set_location('rowcount 1 ', 50);
303: l_changed := TRUE;
304: end if;
305:
306: -- Due to mirroring this will avoid ptnl being written for both

Line 314: -- hr_utility.set_location('Mirror - disregard ', 60);

310: --
311: -- Bug - 1809612 added code to ensure that ptnl LE gets created for contact who is also an employee.
312: -- Also the ptnl LE should not get created for contacts who are not EMP , EMP_APL .
313: --
314: -- hr_utility.set_location('Mirror - disregard ', 60);
315: -- l_changed := FALSE;
316: --
317: --
318: open c_per_type (p_new.contact_person_id );

Line 322: hr_utility.set_location('person type '||l_con_per_type||'PER'||l_per_type, 52);

318: open c_per_type (p_new.contact_person_id );
319: fetch c_per_type into l_con_per_type;
320: close c_per_type ;
321: --
322: hr_utility.set_location('person type '||l_con_per_type||'PER'||l_per_type, 52);
323: if l_con_per_type in ( 'EMP' , 'EMP_APL', 'EX_EMP') -- Added ex-employee for bug 7113467
324: then
325: --
326: open c_per_type (p_new.person_id );

Line 332: hr_utility.set_location('person type '||l_per_type , 55);

328: close c_per_type ;
329: --
330: if l_per_type in ( 'EMP' , 'EMP_APL')
331: then
332: hr_utility.set_location('person type '||l_per_type , 55);
333: l_changed := TRUE;
334: else
335: hr_utility.set_location('Mirror - disregard ', 57);
336: l_changed := FALSE;

Line 335: hr_utility.set_location('Mirror - disregard ', 57);

331: then
332: hr_utility.set_location('person type '||l_per_type , 55);
333: l_changed := TRUE;
334: else
335: hr_utility.set_location('Mirror - disregard ', 57);
336: l_changed := FALSE;
337: end if;
338: else
339: hr_utility.set_location('Mirror - disregard ', 60);

Line 339: hr_utility.set_location('Mirror - disregard ', 60);

335: hr_utility.set_location('Mirror - disregard ', 57);
336: l_changed := FALSE;
337: end if;
338: else
339: hr_utility.set_location('Mirror - disregard ', 60);
340: l_changed := l_changed AND TRUE; -- Bug 6219676
341: end if ;
342: -- bug - 1809612
343: -- end if;

Line 345: hr_utility.set_location(l_proc, 70);

341: end if ;
342: -- bug - 1809612
343: -- end if;
344:
345: hr_utility.set_location(l_proc, 70);
346:
347: --
348: -- Call the formula here to evaluate per_info_chg_cs_ler_rl.
349: -- If it returns Y, then see the applicability of the data

Line 507: hr_utility.set_location('Populating the g_param_tab', 66);

503: -- End fix 1772037
504: --
505:
506: -- Start Fix 4911130
507: hr_utility.set_location('Populating the g_param_tab', 66);
508: populate_param_tab('BEN_CON_IN_PERSON_ID', to_char(p_new.PERSON_ID));
509: populate_param_tab('BEN_CON_IN_CONTACT_PERSON_ID', to_char(p_new.CONTACT_PERSON_ID));
510: populate_param_tab('BEN_CON_IN_DATE_START', to_char(p_new.DATE_START, 'YYYY/MM/DD HH24:MI:SS'));
511: populate_param_tab('BEN_CON_IN_DATE_END', to_char(p_new.DATE_END, 'YYYY/MM/DD HH24:MI:SS'));

Line 568: hr_utility.set_location('Done Populating the g_param_tab', 66);

564: populate_param_tab('BEN_CON_IO_CONT_ATTRIBUTE18', p_old.cont_attribute18);
565: populate_param_tab('BEN_CON_IO_CONT_ATTRIBUTE19', p_old.cont_attribute19);
566: populate_param_tab('BEN_CON_IO_CONT_ATTRIBUTE20', p_old.cont_attribute20);
567: populate_param_tab('BEN_IV_LER_ID', to_char(l_ler_id));
568: hr_utility.set_location('Done Populating the g_param_tab', 66);
569: -- End Fix 4911130
570:
571: benutils.exec_rule(
572: p_formula_id => l_per_info_chg_cs_ler_rl,

Line 590: hr_utility.set_location('Old Start Date '||p_old.date_start,10);

586: --
587:
588: --
589: if l_column = 'DATE_START' then
590: hr_utility.set_location('Old Start Date '||p_old.date_start,10);
591: hr_utility.set_location('New Start Date '||p_new.date_start,10);
592: l_changed := (benutils.column_changed(p_old.date_start
593: ,p_new.date_start,l_new_val) AND
594: benutils.column_changed(p_new.date_start

Line 591: hr_utility.set_location('New Start Date '||p_new.date_start,10);

587:
588: --
589: if l_column = 'DATE_START' then
590: hr_utility.set_location('Old Start Date '||p_old.date_start,10);
591: hr_utility.set_location('New Start Date '||p_new.date_start,10);
592: l_changed := (benutils.column_changed(p_old.date_start
593: ,p_new.date_start,l_new_val) AND
594: benutils.column_changed(p_new.date_start
595: ,p_old.date_start,l_old_val) AND

Line 607: hr_utility.set_location(' l_person_esd (DATE END) ' ||l_person_esd, 70);

603: benutils.column_changed(p_new.date_end
604: ,p_old.date_end,l_old_val) AND
605: (l_person_esd <= l_session_date) AND -- Added for 3105696
606: (l_changed));
607: hr_utility.set_location(' l_person_esd (DATE END) ' ||l_person_esd, 70);
608: hr_utility.set_location(' l_session_date (DATE END) ' || l_session_date, 70);
609: if l_ocrd_dt_cd is null then
610: l_lf_evt_ocrd_date := l_date_end;
611: else

Line 608: hr_utility.set_location(' l_session_date (DATE END) ' || l_session_date, 70);

604: ,p_old.date_end,l_old_val) AND
605: (l_person_esd <= l_session_date) AND -- Added for 3105696
606: (l_changed));
607: hr_utility.set_location(' l_person_esd (DATE END) ' ||l_person_esd, 70);
608: hr_utility.set_location(' l_session_date (DATE END) ' || l_session_date, 70);
609: if l_ocrd_dt_cd is null then
610: l_lf_evt_ocrd_date := l_date_end;
611: else
612: --

Line 626: hr_utility.set_location('Old ConTYp '||p_old.contact_type, 80);

622: l_dtctd_dt := l_date_end;
623: end if;
624:
625: if l_column = 'CONTACT_TYPE' then
626: hr_utility.set_location('Old ConTYp '||p_old.contact_type, 80);
627: hr_utility.set_location('New ConTYp '||p_new.contact_type, 80);
628: l_changed := (benutils.column_changed(p_old.contact_type
629: ,p_new.contact_type,l_new_val) AND
630: benutils.column_changed(p_new.contact_type

Line 627: hr_utility.set_location('New ConTYp '||p_new.contact_type, 80);

623: end if;
624:
625: if l_column = 'CONTACT_TYPE' then
626: hr_utility.set_location('Old ConTYp '||p_old.contact_type, 80);
627: hr_utility.set_location('New ConTYp '||p_new.contact_type, 80);
628: l_changed := (benutils.column_changed(p_old.contact_type
629: ,p_new.contact_type,l_new_val) AND
630: benutils.column_changed(p_new.contact_type
631: ,p_old.contact_type,l_old_val) AND

Line 636: hr_utility.set_location('Old Per_flag '||p_old.personal_flag, 90);

632: (l_changed));
633: end if;
634:
635: if l_column = 'PERSONAL_FLAG' then
636: hr_utility.set_location('Old Per_flag '||p_old.personal_flag, 90);
637: hr_utility.set_location('New Per_flag '||p_new.personal_flag, 90);
638: l_changed := (benutils.column_changed(p_old.personal_flag
639: ,p_new.personal_flag,l_new_val) AND
640: benutils.column_changed(p_new.personal_flag

Line 637: hr_utility.set_location('New Per_flag '||p_new.personal_flag, 90);

633: end if;
634:
635: if l_column = 'PERSONAL_FLAG' then
636: hr_utility.set_location('Old Per_flag '||p_old.personal_flag, 90);
637: hr_utility.set_location('New Per_flag '||p_new.personal_flag, 90);
638: l_changed := (benutils.column_changed(p_old.personal_flag
639: ,p_new.personal_flag,l_new_val) AND
640: benutils.column_changed(p_new.personal_flag
641: ,p_old.personal_flag,l_old_val) AND

Line 661: hr_utility.set_location(' l_person_esd (END_LIFE_REASON_ID) ' ||l_person_esd, 70);

657: benutils.column_changed(p_new.end_life_reason_id
658: ,p_old.end_life_reason_id,l_old_val) AND
659: (l_person_esd <= l_session_date) AND -- Added for 3105696
660: (l_changed));
661: hr_utility.set_location(' l_person_esd (END_LIFE_REASON_ID) ' ||l_person_esd, 70);
662: hr_utility.set_location(' l_session_date (END_LIFE_REASON_ID) ' || l_session_date, 70);
663: if l_ocrd_dt_cd is null then
664: l_lf_evt_ocrd_date := l_date_end;
665: else

Line 662: hr_utility.set_location(' l_session_date (END_LIFE_REASON_ID) ' || l_session_date, 70);

658: ,p_old.end_life_reason_id,l_old_val) AND
659: (l_person_esd <= l_session_date) AND -- Added for 3105696
660: (l_changed));
661: hr_utility.set_location(' l_person_esd (END_LIFE_REASON_ID) ' ||l_person_esd, 70);
662: hr_utility.set_location(' l_session_date (END_LIFE_REASON_ID) ' || l_session_date, 70);
663: if l_ocrd_dt_cd is null then
664: l_lf_evt_ocrd_date := l_date_end;
665: else
666: --

Line 856: hr_utility.set_location('Setting the flag true', 95);

852: -- Added for 3105696
853: l_flag:=FALSE;
854: if l_column in ('DATE_START','START_LIFE_REASON_ID') then
855: l_flag := TRUE;
856: hr_utility.set_location('Setting the flag true', 95);
857: end if;
858:
859: -- End of 3105696
860:

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

868: l_changed := TRUE ;
869: elsif l_rule_output = 'Y' and l_rule_overrides_flag = 'N' then
870: l_changed := l_changed AND TRUE;
871: elsif l_rule_output = 'N' then
872: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
873: l_changed := FALSE;
874: end if;
875:
876: hr_utility.set_location('After the rule Check ',20.05);

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

872: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
873: l_changed := FALSE;
874: end if;
875:
876: hr_utility.set_location('After the rule Check ',20.05);
877: if l_changed then
878: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
879: else
880: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);

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

874: end if;
875:
876: hr_utility.set_location('After the rule Check ',20.05);
877: if l_changed then
878: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
879: else
880: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
881: end if;
882: -- Check for Column Mandatory Change

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

876: hr_utility.set_location('After the rule Check ',20.05);
877: if l_changed then
878: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
879: else
880: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
881: end if;
882: -- Check for Column Mandatory Change
883: -- If column change is mandatory and data change has failed then dont trigger
884: -- If column change is non-mandatory and the data change has passed, then trigger.

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

883: -- If column change is mandatory and data change has failed then dont trigger
884: -- If column change is non-mandatory and the data change has passed, then trigger.
885:
886: if l_chg_mandatory_cd = 'Y' and not l_changed then
887: hr_utility.set_location('Found Mandatory and its failed ', 20.1);
888: l_changed := FALSE;
889: l_trigger := FALSE;
890: exit;
891: elsif l_chg_mandatory_cd = 'Y' and l_changed then

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

888: l_changed := FALSE;
889: l_trigger := FALSE;
890: exit;
891: elsif l_chg_mandatory_cd = 'Y' and l_changed then
892: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
893: l_changed := TRUE;
894: -- exit; */
895: elsif l_chg_mandatory_cd = 'N' and l_changed then
896: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);

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

892: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
893: l_changed := TRUE;
894: -- exit; */
895: elsif l_chg_mandatory_cd = 'N' and l_changed then
896: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);
897: l_changed := TRUE;
898: l_trigger := TRUE;
899: exit;
900: end if;

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

899: exit;
900: end if;
901:
902:
903: hr_utility.set_location('After the Mandatory code check ',20.05);
904: if l_changed then
905: hr_utility.set_location(' l_change TRUE ', 20.1);
906: else
907: hr_utility.set_location(' l_change FALSE ', 20.1);

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

901:
902:
903: hr_utility.set_location('After the Mandatory code check ',20.05);
904: if l_changed then
905: hr_utility.set_location(' l_change TRUE ', 20.1);
906: else
907: hr_utility.set_location(' l_change FALSE ', 20.1);
908: end if;
909: --

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

903: hr_utility.set_location('After the Mandatory code check ',20.05);
904: if l_changed then
905: hr_utility.set_location(' l_change TRUE ', 20.1);
906: else
907: hr_utility.set_location(' l_change FALSE ', 20.1);
908: end if;
909: --
910: /* if not l_changed then
911: exit;

Line 926: hr_utility.set_location('Making flag False', 95);

922:
923: if l_ler_eff_strt_dt >= l_initial_date then
924: -- we should not trigger the LE
925: l_changed := FALSE;
926: hr_utility.set_location('Making flag False', 95);
927: end if;
928: end if;
929: -- End of 3105696
930:

Line 932: hr_utility.set_location( l_proc, 95);

928: end if;
929: -- End of 3105696
930:
931:
932: hr_utility.set_location( l_proc, 95);
933: hr_utility.set_location(' l_lf_evt_ocrd_date ' ||l_lf_evt_ocrd_date, 95);
934: hr_utility.set_location(' l_effective_start_date ' ||l_effective_start_date, 95);
935: hr_utility.set_location(' l_dtctd_dt ' ||l_dtctd_dt, 95);
936: l_ptnl_id := 0;

Line 933: hr_utility.set_location(' l_lf_evt_ocrd_date ' ||l_lf_evt_ocrd_date, 95);

929: -- End of 3105696
930:
931:
932: hr_utility.set_location( l_proc, 95);
933: hr_utility.set_location(' l_lf_evt_ocrd_date ' ||l_lf_evt_ocrd_date, 95);
934: hr_utility.set_location(' l_effective_start_date ' ||l_effective_start_date, 95);
935: hr_utility.set_location(' l_dtctd_dt ' ||l_dtctd_dt, 95);
936: l_ptnl_id := 0;
937: l_ovn :=null;

Line 934: hr_utility.set_location(' l_effective_start_date ' ||l_effective_start_date, 95);

930:
931:
932: hr_utility.set_location( l_proc, 95);
933: hr_utility.set_location(' l_lf_evt_ocrd_date ' ||l_lf_evt_ocrd_date, 95);
934: hr_utility.set_location(' l_effective_start_date ' ||l_effective_start_date, 95);
935: hr_utility.set_location(' l_dtctd_dt ' ||l_dtctd_dt, 95);
936: l_ptnl_id := 0;
937: l_ovn :=null;
938: --

Line 935: hr_utility.set_location(' l_dtctd_dt ' ||l_dtctd_dt, 95);

931:
932: hr_utility.set_location( l_proc, 95);
933: hr_utility.set_location(' l_lf_evt_ocrd_date ' ||l_lf_evt_ocrd_date, 95);
934: hr_utility.set_location(' l_effective_start_date ' ||l_effective_start_date, 95);
935: hr_utility.set_location(' l_dtctd_dt ' ||l_dtctd_dt, 95);
936: l_ptnl_id := 0;
937: l_ovn :=null;
938: --
939: if l_trigger then

Line 944: hr_utility.set_location(l_proc, 96);

940: if l_type = 'P' then
941: open le_exists(p_new.person_id,l_ler_id,l_lf_evt_ocrd_date);
942: fetch le_exists into l_le_exists;
943: if le_exists%notfound then
944: hr_utility.set_location(l_proc, 96);
945: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
946: ---ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
947: (p_validate => false
948: ,p_ptnl_ler_for_per_id => l_ptnl_id

Line 963: hr_utility.set_location(l_proc, 97);

959: );
960: end if;
961: close le_exists;
962: elsif l_type = 'R' then
963: hr_utility.set_location(l_proc, 97);
964: open le_exists(p_new.contact_person_id,l_ler_id,l_lf_evt_ocrd_date);
965: fetch le_exists into l_le_exists;
966: if le_exists%notfound then
967: hr_utility.set_location(l_proc, 98);

Line 967: hr_utility.set_location(l_proc, 98);

963: hr_utility.set_location(l_proc, 97);
964: open le_exists(p_new.contact_person_id,l_ler_id,l_lf_evt_ocrd_date);
965: fetch le_exists into l_le_exists;
966: if le_exists%notfound then
967: hr_utility.set_location(l_proc, 98);
968:
969: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
970: ---ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
971: (p_validate => false

Line 992: hr_utility.set_location(l_proc, 99);

988: end if;
989: --
990: -- reset the variables.
991: --
992: hr_utility.set_location(l_proc, 99);
993: l_changed := FALSE;
994: l_flag := FALSE;
995: l_trigger := TRUE;
996: l_ovn := NULL;

Line 997: hr_utility.set_location( l_proc, 95);

993: l_changed := FALSE;
994: l_flag := FALSE;
995: l_trigger := TRUE;
996: l_ovn := NULL;
997: hr_utility.set_location( l_proc, 95);
998: --hr_utility.set_location(' l_lf_evt_ocrd_date ' ||l_lf_evt_ocrd_date, 95);
999: --hr_utility.set_location(' l_effective_start_date ' ||l_effective_start_date, 95);
1000: --hr_utility.set_location(' l_dtctd_dt ' ||l_dtctd_dt, 95);
1001: --hr_utility.set_location(' l_session_date ' ||l_session_date, 95);

Line 998: --hr_utility.set_location(' l_lf_evt_ocrd_date ' ||l_lf_evt_ocrd_date, 95);

994: l_flag := FALSE;
995: l_trigger := TRUE;
996: l_ovn := NULL;
997: hr_utility.set_location( l_proc, 95);
998: --hr_utility.set_location(' l_lf_evt_ocrd_date ' ||l_lf_evt_ocrd_date, 95);
999: --hr_utility.set_location(' l_effective_start_date ' ||l_effective_start_date, 95);
1000: --hr_utility.set_location(' l_dtctd_dt ' ||l_dtctd_dt, 95);
1001: --hr_utility.set_location(' l_session_date ' ||l_session_date, 95);
1002:

Line 999: --hr_utility.set_location(' l_effective_start_date ' ||l_effective_start_date, 95);

995: l_trigger := TRUE;
996: l_ovn := NULL;
997: hr_utility.set_location( l_proc, 95);
998: --hr_utility.set_location(' l_lf_evt_ocrd_date ' ||l_lf_evt_ocrd_date, 95);
999: --hr_utility.set_location(' l_effective_start_date ' ||l_effective_start_date, 95);
1000: --hr_utility.set_location(' l_dtctd_dt ' ||l_dtctd_dt, 95);
1001: --hr_utility.set_location(' l_session_date ' ||l_session_date, 95);
1002:
1003: -- l_effective_start_date := l_session_date; Commented part of 3105696 bug fix

Line 1000: --hr_utility.set_location(' l_dtctd_dt ' ||l_dtctd_dt, 95);

996: l_ovn := NULL;
997: hr_utility.set_location( l_proc, 95);
998: --hr_utility.set_location(' l_lf_evt_ocrd_date ' ||l_lf_evt_ocrd_date, 95);
999: --hr_utility.set_location(' l_effective_start_date ' ||l_effective_start_date, 95);
1000: --hr_utility.set_location(' l_dtctd_dt ' ||l_dtctd_dt, 95);
1001: --hr_utility.set_location(' l_session_date ' ||l_session_date, 95);
1002:
1003: -- l_effective_start_date := l_session_date; Commented part of 3105696 bug fix
1004: -- hr_utility.set_location(' l_effective_start_date ' ||l_effective_start_date, 567);

Line 1001: --hr_utility.set_location(' l_session_date ' ||l_session_date, 95);

997: hr_utility.set_location( l_proc, 95);
998: --hr_utility.set_location(' l_lf_evt_ocrd_date ' ||l_lf_evt_ocrd_date, 95);
999: --hr_utility.set_location(' l_effective_start_date ' ||l_effective_start_date, 95);
1000: --hr_utility.set_location(' l_dtctd_dt ' ||l_dtctd_dt, 95);
1001: --hr_utility.set_location(' l_session_date ' ||l_session_date, 95);
1002:
1003: -- l_effective_start_date := l_session_date; Commented part of 3105696 bug fix
1004: -- hr_utility.set_location(' l_effective_start_date ' ||l_effective_start_date, 567);
1005: l_dtctd_dt := null;

Line 1004: -- hr_utility.set_location(' l_effective_start_date ' ||l_effective_start_date, 567);

1000: --hr_utility.set_location(' l_dtctd_dt ' ||l_dtctd_dt, 95);
1001: --hr_utility.set_location(' l_session_date ' ||l_session_date, 95);
1002:
1003: -- l_effective_start_date := l_session_date; Commented part of 3105696 bug fix
1004: -- hr_utility.set_location(' l_effective_start_date ' ||l_effective_start_date, 567);
1005: l_dtctd_dt := null;
1006: end if;
1007: close get_ler_col;
1008: end loop;

Line 1009: hr_utility.set_location(l_proc, 100);

1005: l_dtctd_dt := null;
1006: end if;
1007: close get_ler_col;
1008: end loop;
1009: hr_utility.set_location(l_proc, 100);
1010: close get_ler;
1011: hr_utility.set_location('Leaving: '||l_proc, 999);
1012: --
1013:

Line 1011: hr_utility.set_location('Leaving: '||l_proc, 999);

1007: close get_ler_col;
1008: end loop;
1009: hr_utility.set_location(l_proc, 100);
1010: close get_ler;
1011: hr_utility.set_location('Leaving: '||l_proc, 999);
1012: --
1013:
1014: end;
1015: end ben_con_ler;