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

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

166:
167: --
168: begin
169: --
170: hr_utility.set_location('Entering '||l_proc,10);
171: hr_utility.set_location('p_new.information_type '||p_new.information_type,10);
172: hr_utility.set_location('p_old.information_type '||p_old.information_type,10);
173: benutils.set_data_migrator_mode;
174: if hr_general.g_data_migrator_mode in ( 'Y','P') then

Line 171: hr_utility.set_location('p_new.information_type '||p_new.information_type,10);

167: --
168: begin
169: --
170: hr_utility.set_location('Entering '||l_proc,10);
171: hr_utility.set_location('p_new.information_type '||p_new.information_type,10);
172: hr_utility.set_location('p_old.information_type '||p_old.information_type,10);
173: benutils.set_data_migrator_mode;
174: if hr_general.g_data_migrator_mode in ( 'Y','P') then
175: --

Line 172: hr_utility.set_location('p_old.information_type '||p_old.information_type,10);

168: begin
169: --
170: hr_utility.set_location('Entering '||l_proc,10);
171: hr_utility.set_location('p_new.information_type '||p_new.information_type,10);
172: hr_utility.set_location('p_old.information_type '||p_old.information_type,10);
173: benutils.set_data_migrator_mode;
174: if hr_general.g_data_migrator_mode in ( 'Y','P') then
175: --
176: return;

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

205: open get_system_date;
206: fetch get_system_date into l_system_date;
207: close get_system_date;
208: --
209: hr_utility.set_location(l_proc,20);
210: --
211: open get_ler(l_status);
212: loop
213: fetch get_ler into l_ler_id,

Line 218: hr_utility.set_location(' l_ler_id '||l_ler_id,10);

214: l_typ_cd,
215: l_ocrd_dt_cd;
216: exit when get_ler%notfound;
217: l_trigger := TRUE;
218: hr_utility.set_location(' l_ler_id '||l_ler_id,10);
219:
220: --Bug 16288193
221: if l_ocrd_dt_cd is null then
222: l_lf_evt_ocrd_date := l_session_date;

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

240: l_rule_overrides_flag,
241: l_chg_mandatory_cd;
242: exit when get_ler_col%NOTFOUND;
243: if get_ler_col%ROWCOUNT = 1 then
244: hr_utility.set_location('rowcount 1 ', 50);
245: l_changed := TRUE;
246: end if;
247: --
248: hr_utility.set_location(l_proc,30);

Line 248: hr_utility.set_location(l_proc,30);

244: hr_utility.set_location('rowcount 1 ', 50);
245: l_changed := TRUE;
246: end if;
247: --
248: hr_utility.set_location(l_proc,30);
249: --
250:
251: l_rule_output := 'Y';
252:

Line 277: hr_utility.set_location('l_new_val '||l_new_val,10);

273: p_pk_id => to_char(nvl(p_new.PERSON_EXTRA_INFO_ID,p_old.PERSON_EXTRA_INFO_ID)),
274: p_ret_val => l_rule_output);
275: end if;
276:
277: hr_utility.set_location('l_new_val '||l_new_val,10);
278: hr_utility.set_location('l_old_val '||l_old_val,10);
279: --
280: if p_mode <> 'UPDATE' THEN
281: l_changed := (benutils.column_changed(p_old.information_type

Line 278: hr_utility.set_location('l_old_val '||l_old_val,10);

274: p_ret_val => l_rule_output);
275: end if;
276:
277: hr_utility.set_location('l_new_val '||l_new_val,10);
278: hr_utility.set_location('l_old_val '||l_old_val,10);
279: --
280: if p_mode <> 'UPDATE' THEN
281: l_changed := (benutils.column_changed(p_old.information_type
282: ,p_new.information_type,l_new_val) AND

Line 295: hr_utility.set_location('in 1',10);

291: end if;
292: end if;
293:
294: if l_rule_output = 'Y' and l_rule_overrides_flag = 'Y' then
295: hr_utility.set_location('in 1',10);
296: l_changed := TRUE ;
297: elsif l_rule_output = 'Y' and l_rule_overrides_flag = 'N' then
298: hr_utility.set_location('in 2',10);
299: l_changed := l_changed AND TRUE;

Line 298: hr_utility.set_location('in 2',10);

294: if l_rule_output = 'Y' and l_rule_overrides_flag = 'Y' then
295: hr_utility.set_location('in 1',10);
296: l_changed := TRUE ;
297: elsif l_rule_output = 'Y' and l_rule_overrides_flag = 'N' then
298: hr_utility.set_location('in 2',10);
299: l_changed := l_changed AND TRUE;
300: elsif l_rule_output = 'N' then
301: hr_utility.set_location('in 3',10);
302: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);

Line 301: hr_utility.set_location('in 3',10);

297: elsif l_rule_output = 'Y' and l_rule_overrides_flag = 'N' then
298: hr_utility.set_location('in 2',10);
299: l_changed := l_changed AND TRUE;
300: elsif l_rule_output = 'N' then
301: hr_utility.set_location('in 3',10);
302: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
303: l_changed := FALSE;
304: end if;
305:

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

298: hr_utility.set_location('in 2',10);
299: l_changed := l_changed AND TRUE;
300: elsif l_rule_output = 'N' then
301: hr_utility.set_location('in 3',10);
302: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
303: l_changed := FALSE;
304: end if;
305:
306: if l_chg_mandatory_cd = 'Y' and not l_changed then

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

303: l_changed := FALSE;
304: end if;
305:
306: if l_chg_mandatory_cd = 'Y' and not l_changed then
307: hr_utility.set_location('Found Mandatory and its failed ', 20.1);
308: l_changed := FALSE;
309: l_trigger := FALSE;
310: exit;
311: elsif l_chg_mandatory_cd = 'Y' and l_changed then

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

308: l_changed := FALSE;
309: l_trigger := FALSE;
310: exit;
311: elsif l_chg_mandatory_cd = 'Y' and l_changed then
312: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
313: l_changed := TRUE;
314: -- exit; */
315: elsif l_chg_mandatory_cd = 'N' and l_changed then
316: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);

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

312: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
313: l_changed := TRUE;
314: -- exit; */
315: elsif l_chg_mandatory_cd = 'N' and l_changed then
316: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);
317: l_changed := TRUE;
318: l_trigger := TRUE;
319: exit;
320: end if;

Line 373: hr_utility.set_location('leaving '||l_proc,11);

369: ,p_object_version_number => l_ovn
370: ,p_effective_date => l_effective_start_date
371: ,p_dtctd_dt => l_effective_start_date);
372: end if; --1.2
373: hr_utility.set_location('leaving '||l_proc,11);
374: l_ptnl_id := 0;
375: l_ovn :=null;
376: close le_exists;
377: end loop;

Line 378: hr_utility.set_location('leaving '||l_proc,12);

374: l_ptnl_id := 0;
375: l_ovn :=null;
376: close le_exists;
377: end loop;
378: hr_utility.set_location('leaving '||l_proc,12);
379: close get_contacts;
380: end if; --1
381: --
382: -- reset the variables.

Line 392: hr_utility.set_location('leaving '||l_proc,20);

388: end if;
389: close get_ler_col;
390: end loop;
391: close get_ler;
392: hr_utility.set_location('leaving '||l_proc,20);
393: exception
394: when others then
395: hr_utility.set_location('leaving '||l_proc,21);
396: raise;

Line 395: hr_utility.set_location('leaving '||l_proc,21);

391: close get_ler;
392: hr_utility.set_location('leaving '||l_proc,20);
393: exception
394: when others then
395: hr_utility.set_location('leaving '||l_proc,21);
396: raise;
397: end ler_per_chk;
398:
399: procedure ler_asg_chk(p_old IN g_asg_ler_rec

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

553:
554: --
555: begin
556: --
557: hr_utility.set_location('Entering '||l_proc,10);
558: benutils.set_data_migrator_mode;
559: if hr_general.g_data_migrator_mode in ( 'Y','P') then
560: --
561: return;

Line 600: hr_utility.set_location('NOT primary assignment',10);

596: close get_person_id_primary_flag;
597:
598: if l_primary_flag <> 'Y'
599: then
600: hr_utility.set_location('NOT primary assignment',10);
601: hr_utility.set_location('leaving '||l_proc,10);
602: return;
603: end if;
604:

Line 601: hr_utility.set_location('leaving '||l_proc,10);

597:
598: if l_primary_flag <> 'Y'
599: then
600: hr_utility.set_location('NOT primary assignment',10);
601: hr_utility.set_location('leaving '||l_proc,10);
602: return;
603: end if;
604:
605: --

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

602: return;
603: end if;
604:
605: --
606: hr_utility.set_location(l_proc,20);
607: --
608: open get_ler(l_status);
609: loop
610: fetch get_ler into l_ler_id,

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

635: l_rule_overrides_flag,
636: l_chg_mandatory_cd;
637: exit when get_ler_col%NOTFOUND;
638: if get_ler_col%ROWCOUNT = 1 then
639: hr_utility.set_location('rowcount 1 ', 50);
640: l_changed := TRUE;
641: end if;
642: --
643: hr_utility.set_location(l_proc,30);

Line 643: hr_utility.set_location(l_proc,30);

639: hr_utility.set_location('rowcount 1 ', 50);
640: l_changed := TRUE;
641: end if;
642: --
643: hr_utility.set_location(l_proc,30);
644: --
645:
646: l_rule_output := 'Y';
647:

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

688: l_changed := TRUE ;
689: elsif l_rule_output = 'Y' and l_rule_overrides_flag = 'N' then
690: l_changed := l_changed AND TRUE;
691: elsif l_rule_output = 'N' then
692: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
693: l_changed := FALSE;
694: end if;
695:
696: if l_chg_mandatory_cd = 'Y' and not l_changed then

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

693: l_changed := FALSE;
694: end if;
695:
696: if l_chg_mandatory_cd = 'Y' and not l_changed then
697: hr_utility.set_location('Found Mandatory and its failed ', 20.1);
698: l_changed := FALSE;
699: l_trigger := FALSE;
700: exit;
701: elsif l_chg_mandatory_cd = 'Y' and l_changed then

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

698: l_changed := FALSE;
699: l_trigger := FALSE;
700: exit;
701: elsif l_chg_mandatory_cd = 'Y' and l_changed then
702: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
703: l_changed := TRUE;
704: -- exit; */
705: elsif l_chg_mandatory_cd = 'N' and l_changed then
706: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);

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

702: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
703: l_changed := TRUE;
704: -- exit; */
705: elsif l_chg_mandatory_cd = 'N' and l_changed then
706: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);
707: l_changed := TRUE;
708: l_trigger := TRUE;
709: exit;
710: end if;

Line 780: hr_utility.set_location('leaving '||l_proc,20);

776: end if;
777: close get_ler_col;
778: end loop;
779: close get_ler;
780: hr_utility.set_location('leaving '||l_proc,20);
781: exception
782: when others then
783: hr_utility.set_location('leaving '||l_proc,21);
784: raise;

Line 783: hr_utility.set_location('leaving '||l_proc,21);

779: close get_ler;
780: hr_utility.set_location('leaving '||l_proc,20);
781: exception
782: when others then
783: hr_utility.set_location('leaving '||l_proc,21);
784: raise;
785: end ler_asg_chk;
786:
787: ----------------------------------------------------------------------------------------------

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

793: l_proc varchar2(200) := 'ben_per_asg_eit_ler.create_ler_per';
794: c_new_rec ben_per_asg_eit_ler.g_per_ler_rec;
795:
796: begin
797: hr_utility.set_location('Entering '||l_proc,10);
798: hr_utility.set_location('p_person_extra_info_id '||p_person_extra_info_id,10);
799: hr_utility.set_location('p_person_id '||p_person_id,10);
800: hr_utility.set_location('p_INFORMATION_TYPE '||p_INFORMATION_TYPE,10);
801:

Line 798: hr_utility.set_location('p_person_extra_info_id '||p_person_extra_info_id,10);

794: c_new_rec ben_per_asg_eit_ler.g_per_ler_rec;
795:
796: begin
797: hr_utility.set_location('Entering '||l_proc,10);
798: hr_utility.set_location('p_person_extra_info_id '||p_person_extra_info_id,10);
799: hr_utility.set_location('p_person_id '||p_person_id,10);
800: hr_utility.set_location('p_INFORMATION_TYPE '||p_INFORMATION_TYPE,10);
801:
802: if (p_person_extra_info_id is null or p_person_id is null or p_INFORMATION_TYPE is null) then

Line 799: hr_utility.set_location('p_person_id '||p_person_id,10);

795:
796: begin
797: hr_utility.set_location('Entering '||l_proc,10);
798: hr_utility.set_location('p_person_extra_info_id '||p_person_extra_info_id,10);
799: hr_utility.set_location('p_person_id '||p_person_id,10);
800: hr_utility.set_location('p_INFORMATION_TYPE '||p_INFORMATION_TYPE,10);
801:
802: if (p_person_extra_info_id is null or p_person_id is null or p_INFORMATION_TYPE is null) then
803: hr_utility.set_location('Values are null',10);

Line 800: hr_utility.set_location('p_INFORMATION_TYPE '||p_INFORMATION_TYPE,10);

796: begin
797: hr_utility.set_location('Entering '||l_proc,10);
798: hr_utility.set_location('p_person_extra_info_id '||p_person_extra_info_id,10);
799: hr_utility.set_location('p_person_id '||p_person_id,10);
800: hr_utility.set_location('p_INFORMATION_TYPE '||p_INFORMATION_TYPE,10);
801:
802: if (p_person_extra_info_id is null or p_person_id is null or p_INFORMATION_TYPE is null) then
803: hr_utility.set_location('Values are null',10);
804: return;

Line 803: hr_utility.set_location('Values are null',10);

799: hr_utility.set_location('p_person_id '||p_person_id,10);
800: hr_utility.set_location('p_INFORMATION_TYPE '||p_INFORMATION_TYPE,10);
801:
802: if (p_person_extra_info_id is null or p_person_id is null or p_INFORMATION_TYPE is null) then
803: hr_utility.set_location('Values are null',10);
804: return;
805: end if;
806:
807: c_new_rec.person_extra_info_id := p_person_extra_info_id;

Line 817: hr_utility.set_location('leaving '||l_proc,20);

813: p_old =>null,
814: p_new =>c_new_rec,
815: p_mode => 'CREATE'
816: );
817: hr_utility.set_location('leaving '||l_proc,20);
818: exception
819: when others then
820: hr_utility.set_location('leaving '||l_proc,21);
821: raise;

Line 820: hr_utility.set_location('leaving '||l_proc,21);

816: );
817: hr_utility.set_location('leaving '||l_proc,20);
818: exception
819: when others then
820: hr_utility.set_location('leaving '||l_proc,21);
821: raise;
822: end create_ler_per;
823: ----------------------------------------------------------------------------------------------
824:

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

838: c_old_rec ben_per_asg_eit_ler.g_per_ler_rec;
839: c_new_rec ben_per_asg_eit_ler.g_per_ler_rec;
840:
841: begin
842: hr_utility.set_location('Entering '||l_proc,10);
843: hr_utility.set_location('New p_person_extra_info_id '||p_person_extra_info_id,10);
844: hr_utility.set_location('Old p_person_extra_info_id '||pe_pei_shd.g_old_rec.person_extra_info_id,10);
845:
846: if p_person_extra_info_id is null then

Line 843: hr_utility.set_location('New p_person_extra_info_id '||p_person_extra_info_id,10);

839: c_new_rec ben_per_asg_eit_ler.g_per_ler_rec;
840:
841: begin
842: hr_utility.set_location('Entering '||l_proc,10);
843: hr_utility.set_location('New p_person_extra_info_id '||p_person_extra_info_id,10);
844: hr_utility.set_location('Old p_person_extra_info_id '||pe_pei_shd.g_old_rec.person_extra_info_id,10);
845:
846: if p_person_extra_info_id is null then
847: hr_utility.set_location('Values are null',10);

Line 844: hr_utility.set_location('Old p_person_extra_info_id '||pe_pei_shd.g_old_rec.person_extra_info_id,10);

840:
841: begin
842: hr_utility.set_location('Entering '||l_proc,10);
843: hr_utility.set_location('New p_person_extra_info_id '||p_person_extra_info_id,10);
844: hr_utility.set_location('Old p_person_extra_info_id '||pe_pei_shd.g_old_rec.person_extra_info_id,10);
845:
846: if p_person_extra_info_id is null then
847: hr_utility.set_location('Values are null',10);
848: return;

Line 847: hr_utility.set_location('Values are null',10);

843: hr_utility.set_location('New p_person_extra_info_id '||p_person_extra_info_id,10);
844: hr_utility.set_location('Old p_person_extra_info_id '||pe_pei_shd.g_old_rec.person_extra_info_id,10);
845:
846: if p_person_extra_info_id is null then
847: hr_utility.set_location('Values are null',10);
848: return;
849: end if;
850:
851: open c1(pe_pei_shd.g_old_rec.person_extra_info_id);

Line 855: hr_utility.set_location('c_old_rec.person_extra_info_id '||c_old_rec.person_extra_info_id,10);

851: open c1(pe_pei_shd.g_old_rec.person_extra_info_id);
852: fetch c1 into c_old_rec;
853: close c1;
854:
855: hr_utility.set_location('c_old_rec.person_extra_info_id '||c_old_rec.person_extra_info_id,10);
856: hr_utility.set_location('c_old_rec.person_id '||c_old_rec.person_id,10);
857: hr_utility.set_location('c_old_rec.information_type '||c_old_rec.information_type,10);
858:
859:

Line 856: hr_utility.set_location('c_old_rec.person_id '||c_old_rec.person_id,10);

852: fetch c1 into c_old_rec;
853: close c1;
854:
855: hr_utility.set_location('c_old_rec.person_extra_info_id '||c_old_rec.person_extra_info_id,10);
856: hr_utility.set_location('c_old_rec.person_id '||c_old_rec.person_id,10);
857: hr_utility.set_location('c_old_rec.information_type '||c_old_rec.information_type,10);
858:
859:
860: open c1(p_person_extra_info_id);

Line 857: hr_utility.set_location('c_old_rec.information_type '||c_old_rec.information_type,10);

853: close c1;
854:
855: hr_utility.set_location('c_old_rec.person_extra_info_id '||c_old_rec.person_extra_info_id,10);
856: hr_utility.set_location('c_old_rec.person_id '||c_old_rec.person_id,10);
857: hr_utility.set_location('c_old_rec.information_type '||c_old_rec.information_type,10);
858:
859:
860: open c1(p_person_extra_info_id);
861: fetch c1 into c_new_rec;

Line 864: hr_utility.set_location('c_new_rec.person_extra_info_id '||c_new_rec.person_extra_info_id,10);

860: open c1(p_person_extra_info_id);
861: fetch c1 into c_new_rec;
862: close c1;
863:
864: hr_utility.set_location('c_new_rec.person_extra_info_id '||c_new_rec.person_extra_info_id,10);
865: hr_utility.set_location('c_new_rec.person_id '||c_new_rec.person_id,10);
866: hr_utility.set_location('c_new_rec.information_type '||c_new_rec.information_type,10);
867:
868: ben_per_asg_eit_ler.ler_per_chk(

Line 865: hr_utility.set_location('c_new_rec.person_id '||c_new_rec.person_id,10);

861: fetch c1 into c_new_rec;
862: close c1;
863:
864: hr_utility.set_location('c_new_rec.person_extra_info_id '||c_new_rec.person_extra_info_id,10);
865: hr_utility.set_location('c_new_rec.person_id '||c_new_rec.person_id,10);
866: hr_utility.set_location('c_new_rec.information_type '||c_new_rec.information_type,10);
867:
868: ben_per_asg_eit_ler.ler_per_chk(
869: p_old =>c_old_rec,

Line 866: hr_utility.set_location('c_new_rec.information_type '||c_new_rec.information_type,10);

862: close c1;
863:
864: hr_utility.set_location('c_new_rec.person_extra_info_id '||c_new_rec.person_extra_info_id,10);
865: hr_utility.set_location('c_new_rec.person_id '||c_new_rec.person_id,10);
866: hr_utility.set_location('c_new_rec.information_type '||c_new_rec.information_type,10);
867:
868: ben_per_asg_eit_ler.ler_per_chk(
869: p_old =>c_old_rec,
870: p_new =>c_new_rec,

Line 873: hr_utility.set_location('leaving '||l_proc,20);

869: p_old =>c_old_rec,
870: p_new =>c_new_rec,
871: p_mode => 'UPDATE'
872: );
873: hr_utility.set_location('leaving '||l_proc,20);
874: exception
875: when others then
876: hr_utility.set_location('leaving '||l_proc,21);
877: raise;

Line 876: hr_utility.set_location('leaving '||l_proc,21);

872: );
873: hr_utility.set_location('leaving '||l_proc,20);
874: exception
875: when others then
876: hr_utility.set_location('leaving '||l_proc,21);
877: raise;
878: end update_ler_per;
879: -----------------------------------------------------------------------------------------------
880:

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

886:
887: c_old_rec ben_per_asg_eit_ler.g_per_ler_rec;
888:
889: begin
890: hr_utility.set_location('Entering '||l_proc,10);
891: hr_utility.set_location('New p_person_extra_info_id '||p_person_extra_info_id,10);
892: hr_utility.set_location('Old p_person_extra_info_id '||pe_pei_shd.g_old_rec.person_extra_info_id,10);
893:
894: if pe_pei_shd.g_old_rec.person_extra_info_id is null then

Line 891: hr_utility.set_location('New p_person_extra_info_id '||p_person_extra_info_id,10);

887: c_old_rec ben_per_asg_eit_ler.g_per_ler_rec;
888:
889: begin
890: hr_utility.set_location('Entering '||l_proc,10);
891: hr_utility.set_location('New p_person_extra_info_id '||p_person_extra_info_id,10);
892: hr_utility.set_location('Old p_person_extra_info_id '||pe_pei_shd.g_old_rec.person_extra_info_id,10);
893:
894: if pe_pei_shd.g_old_rec.person_extra_info_id is null then
895: hr_utility.set_location('Values are null',10);

Line 892: hr_utility.set_location('Old p_person_extra_info_id '||pe_pei_shd.g_old_rec.person_extra_info_id,10);

888:
889: begin
890: hr_utility.set_location('Entering '||l_proc,10);
891: hr_utility.set_location('New p_person_extra_info_id '||p_person_extra_info_id,10);
892: hr_utility.set_location('Old p_person_extra_info_id '||pe_pei_shd.g_old_rec.person_extra_info_id,10);
893:
894: if pe_pei_shd.g_old_rec.person_extra_info_id is null then
895: hr_utility.set_location('Values are null',10);
896: return;

Line 895: hr_utility.set_location('Values are null',10);

891: hr_utility.set_location('New p_person_extra_info_id '||p_person_extra_info_id,10);
892: hr_utility.set_location('Old p_person_extra_info_id '||pe_pei_shd.g_old_rec.person_extra_info_id,10);
893:
894: if pe_pei_shd.g_old_rec.person_extra_info_id is null then
895: hr_utility.set_location('Values are null',10);
896: return;
897: end if;
898: c_old_rec.person_extra_info_id := pe_pei_shd.g_old_rec.person_extra_info_id;
899: c_old_rec.person_id := pe_pei_shd.g_old_rec.person_id;

Line 902: hr_utility.set_location('c_old_rec.person_extra_info_id '||c_old_rec.person_extra_info_id,10);

898: c_old_rec.person_extra_info_id := pe_pei_shd.g_old_rec.person_extra_info_id;
899: c_old_rec.person_id := pe_pei_shd.g_old_rec.person_id;
900: c_old_rec.information_type := pe_pei_shd.g_old_rec.information_type;
901:
902: hr_utility.set_location('c_old_rec.person_extra_info_id '||c_old_rec.person_extra_info_id,10);
903: hr_utility.set_location('c_old_rec.person_id '||c_old_rec.person_id,10);
904: hr_utility.set_location('c_old_rec.information_type '||c_old_rec.information_type,10);
905:
906: ben_per_asg_eit_ler.ler_per_chk(

Line 903: hr_utility.set_location('c_old_rec.person_id '||c_old_rec.person_id,10);

899: c_old_rec.person_id := pe_pei_shd.g_old_rec.person_id;
900: c_old_rec.information_type := pe_pei_shd.g_old_rec.information_type;
901:
902: hr_utility.set_location('c_old_rec.person_extra_info_id '||c_old_rec.person_extra_info_id,10);
903: hr_utility.set_location('c_old_rec.person_id '||c_old_rec.person_id,10);
904: hr_utility.set_location('c_old_rec.information_type '||c_old_rec.information_type,10);
905:
906: ben_per_asg_eit_ler.ler_per_chk(
907: p_old =>c_old_rec,

Line 904: hr_utility.set_location('c_old_rec.information_type '||c_old_rec.information_type,10);

900: c_old_rec.information_type := pe_pei_shd.g_old_rec.information_type;
901:
902: hr_utility.set_location('c_old_rec.person_extra_info_id '||c_old_rec.person_extra_info_id,10);
903: hr_utility.set_location('c_old_rec.person_id '||c_old_rec.person_id,10);
904: hr_utility.set_location('c_old_rec.information_type '||c_old_rec.information_type,10);
905:
906: ben_per_asg_eit_ler.ler_per_chk(
907: p_old =>c_old_rec,
908: p_new =>null,

Line 911: hr_utility.set_location('leaving '||l_proc,20);

907: p_old =>c_old_rec,
908: p_new =>null,
909: p_mode => 'DELETE'
910: );
911: hr_utility.set_location('leaving '||l_proc,20);
912: exception
913: when others then
914: hr_utility.set_location('leaving '||l_proc,21);
915: raise;

Line 914: hr_utility.set_location('leaving '||l_proc,21);

910: );
911: hr_utility.set_location('leaving '||l_proc,20);
912: exception
913: when others then
914: hr_utility.set_location('leaving '||l_proc,21);
915: raise;
916: end delete_ler_per;
917: -----------------------------------------------------------------------------------------------------------
918:

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

925: l_proc varchar2(200) := 'ben_per_asg_eit_ler.create_ler_asg';
926: c_new_rec ben_per_asg_eit_ler.g_asg_ler_rec;
927:
928: begin
929: hr_utility.set_location('Entering '||l_proc,10);
930: hr_utility.set_location('p_assignment_extra_info_id '||p_assignment_extra_info_id,10);
931: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
932: hr_utility.set_location('p_INFORMATION_TYPE '||p_INFORMATION_TYPE,10);
933:

Line 930: hr_utility.set_location('p_assignment_extra_info_id '||p_assignment_extra_info_id,10);

926: c_new_rec ben_per_asg_eit_ler.g_asg_ler_rec;
927:
928: begin
929: hr_utility.set_location('Entering '||l_proc,10);
930: hr_utility.set_location('p_assignment_extra_info_id '||p_assignment_extra_info_id,10);
931: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
932: hr_utility.set_location('p_INFORMATION_TYPE '||p_INFORMATION_TYPE,10);
933:
934: if p_assignment_extra_info_id is null or p_assignment_id is null or p_INFORMATION_TYPE is null then

Line 931: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);

927:
928: begin
929: hr_utility.set_location('Entering '||l_proc,10);
930: hr_utility.set_location('p_assignment_extra_info_id '||p_assignment_extra_info_id,10);
931: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
932: hr_utility.set_location('p_INFORMATION_TYPE '||p_INFORMATION_TYPE,10);
933:
934: if p_assignment_extra_info_id is null or p_assignment_id is null or p_INFORMATION_TYPE is null then
935: hr_utility.set_location('Values are null',10);

Line 932: hr_utility.set_location('p_INFORMATION_TYPE '||p_INFORMATION_TYPE,10);

928: begin
929: hr_utility.set_location('Entering '||l_proc,10);
930: hr_utility.set_location('p_assignment_extra_info_id '||p_assignment_extra_info_id,10);
931: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
932: hr_utility.set_location('p_INFORMATION_TYPE '||p_INFORMATION_TYPE,10);
933:
934: if p_assignment_extra_info_id is null or p_assignment_id is null or p_INFORMATION_TYPE is null then
935: hr_utility.set_location('Values are null',10);
936: return;

Line 935: hr_utility.set_location('Values are null',10);

931: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
932: hr_utility.set_location('p_INFORMATION_TYPE '||p_INFORMATION_TYPE,10);
933:
934: if p_assignment_extra_info_id is null or p_assignment_id is null or p_INFORMATION_TYPE is null then
935: hr_utility.set_location('Values are null',10);
936: return;
937: end if;
938:
939: c_new_rec.assignment_extra_info_id :=p_assignment_extra_info_id;

Line 948: hr_utility.set_location('leaving '||l_proc,20);

944: p_old =>null,
945: p_new =>c_new_rec,
946: p_mode => 'CREATE'
947: );
948: hr_utility.set_location('leaving '||l_proc,20);
949: exception
950: when others then
951: hr_utility.set_location('leaving '||l_proc,21);
952: raise;

Line 951: hr_utility.set_location('leaving '||l_proc,21);

947: );
948: hr_utility.set_location('leaving '||l_proc,20);
949: exception
950: when others then
951: hr_utility.set_location('leaving '||l_proc,21);
952: raise;
953: end create_ler_asg;
954: -----------------------------------------------------------------------------------------------------
955: procedure update_ler_asg (p_assignment_extra_info_id In number)

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

968: c_new_rec ben_per_asg_eit_ler.g_asg_ler_rec;
969: c_old_rec ben_per_asg_eit_ler.g_asg_ler_rec;
970:
971: begin
972: hr_utility.set_location('Entering '||l_proc,10);
973: hr_utility.set_location('New p_assignment_extra_info_id '||p_assignment_extra_info_id,10);
974: hr_utility.set_location('Old p_assignment_extra_info_id '||pe_aei_shd.g_old_rec.assignment_extra_info_id,10);
975:
976: if p_assignment_extra_info_id is null then

Line 973: hr_utility.set_location('New p_assignment_extra_info_id '||p_assignment_extra_info_id,10);

969: c_old_rec ben_per_asg_eit_ler.g_asg_ler_rec;
970:
971: begin
972: hr_utility.set_location('Entering '||l_proc,10);
973: hr_utility.set_location('New p_assignment_extra_info_id '||p_assignment_extra_info_id,10);
974: hr_utility.set_location('Old p_assignment_extra_info_id '||pe_aei_shd.g_old_rec.assignment_extra_info_id,10);
975:
976: if p_assignment_extra_info_id is null then
977: hr_utility.set_location('Values are null',10);

Line 974: hr_utility.set_location('Old p_assignment_extra_info_id '||pe_aei_shd.g_old_rec.assignment_extra_info_id,10);

970:
971: begin
972: hr_utility.set_location('Entering '||l_proc,10);
973: hr_utility.set_location('New p_assignment_extra_info_id '||p_assignment_extra_info_id,10);
974: hr_utility.set_location('Old p_assignment_extra_info_id '||pe_aei_shd.g_old_rec.assignment_extra_info_id,10);
975:
976: if p_assignment_extra_info_id is null then
977: hr_utility.set_location('Values are null',10);
978: return;

Line 977: hr_utility.set_location('Values are null',10);

973: hr_utility.set_location('New p_assignment_extra_info_id '||p_assignment_extra_info_id,10);
974: hr_utility.set_location('Old p_assignment_extra_info_id '||pe_aei_shd.g_old_rec.assignment_extra_info_id,10);
975:
976: if p_assignment_extra_info_id is null then
977: hr_utility.set_location('Values are null',10);
978: return;
979: end if;
980:
981: open c1(pe_aei_shd.g_old_rec.assignment_extra_info_id);

Line 985: hr_utility.set_location('c_old_rec.assignment_extra_info_id '||c_old_rec.assignment_extra_info_id,10);

981: open c1(pe_aei_shd.g_old_rec.assignment_extra_info_id);
982: fetch c1 into c_old_rec;
983: close c1;
984:
985: hr_utility.set_location('c_old_rec.assignment_extra_info_id '||c_old_rec.assignment_extra_info_id,10);
986: hr_utility.set_location('c_old_rec.assignment_id '||c_old_rec.assignment_id,10);
987: hr_utility.set_location('c_old_rec.information_type '||c_old_rec.information_type,10);
988:
989:

Line 986: hr_utility.set_location('c_old_rec.assignment_id '||c_old_rec.assignment_id,10);

982: fetch c1 into c_old_rec;
983: close c1;
984:
985: hr_utility.set_location('c_old_rec.assignment_extra_info_id '||c_old_rec.assignment_extra_info_id,10);
986: hr_utility.set_location('c_old_rec.assignment_id '||c_old_rec.assignment_id,10);
987: hr_utility.set_location('c_old_rec.information_type '||c_old_rec.information_type,10);
988:
989:
990: open c1(p_assignment_extra_info_id);

Line 987: hr_utility.set_location('c_old_rec.information_type '||c_old_rec.information_type,10);

983: close c1;
984:
985: hr_utility.set_location('c_old_rec.assignment_extra_info_id '||c_old_rec.assignment_extra_info_id,10);
986: hr_utility.set_location('c_old_rec.assignment_id '||c_old_rec.assignment_id,10);
987: hr_utility.set_location('c_old_rec.information_type '||c_old_rec.information_type,10);
988:
989:
990: open c1(p_assignment_extra_info_id);
991: fetch c1 into c_new_rec;

Line 994: hr_utility.set_location('c_new_rec.assignment_extra_info_id '||c_new_rec.assignment_extra_info_id,10);

990: open c1(p_assignment_extra_info_id);
991: fetch c1 into c_new_rec;
992: close c1;
993:
994: hr_utility.set_location('c_new_rec.assignment_extra_info_id '||c_new_rec.assignment_extra_info_id,10);
995: hr_utility.set_location('c_new_rec.assignment_id '||c_new_rec.assignment_id,10);
996: hr_utility.set_location('c_new_rec.information_type '||c_new_rec.information_type,10);
997:
998: ben_per_asg_eit_ler.ler_asg_chk(

Line 995: hr_utility.set_location('c_new_rec.assignment_id '||c_new_rec.assignment_id,10);

991: fetch c1 into c_new_rec;
992: close c1;
993:
994: hr_utility.set_location('c_new_rec.assignment_extra_info_id '||c_new_rec.assignment_extra_info_id,10);
995: hr_utility.set_location('c_new_rec.assignment_id '||c_new_rec.assignment_id,10);
996: hr_utility.set_location('c_new_rec.information_type '||c_new_rec.information_type,10);
997:
998: ben_per_asg_eit_ler.ler_asg_chk(
999: p_old =>c_old_rec,

Line 996: hr_utility.set_location('c_new_rec.information_type '||c_new_rec.information_type,10);

992: close c1;
993:
994: hr_utility.set_location('c_new_rec.assignment_extra_info_id '||c_new_rec.assignment_extra_info_id,10);
995: hr_utility.set_location('c_new_rec.assignment_id '||c_new_rec.assignment_id,10);
996: hr_utility.set_location('c_new_rec.information_type '||c_new_rec.information_type,10);
997:
998: ben_per_asg_eit_ler.ler_asg_chk(
999: p_old =>c_old_rec,
1000: p_new =>c_new_rec,

Line 1003: hr_utility.set_location('leaving '||l_proc,20);

999: p_old =>c_old_rec,
1000: p_new =>c_new_rec,
1001: p_mode => 'UPDATE'
1002: );
1003: hr_utility.set_location('leaving '||l_proc,20);
1004: exception
1005: when others then
1006: hr_utility.set_location('leaving '||l_proc,21);
1007: raise;

Line 1006: hr_utility.set_location('leaving '||l_proc,21);

1002: );
1003: hr_utility.set_location('leaving '||l_proc,20);
1004: exception
1005: when others then
1006: hr_utility.set_location('leaving '||l_proc,21);
1007: raise;
1008: end update_ler_asg;
1009: ---------------------------------------------------------------------------------------------------
1010:

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

1015:
1016: c_old_rec ben_per_asg_eit_ler.g_asg_ler_rec;
1017:
1018: begin
1019: hr_utility.set_location('Entering '||l_proc,10);
1020: hr_utility.set_location('New p_assignment_extra_info_id '||p_assignment_extra_info_id,10);
1021: hr_utility.set_location('Old p_assignment_extra_info_id '||pe_aei_shd.g_old_rec.assignment_extra_info_id,10);
1022:
1023: if pe_aei_shd.g_old_rec.assignment_extra_info_id is null then

Line 1020: hr_utility.set_location('New p_assignment_extra_info_id '||p_assignment_extra_info_id,10);

1016: c_old_rec ben_per_asg_eit_ler.g_asg_ler_rec;
1017:
1018: begin
1019: hr_utility.set_location('Entering '||l_proc,10);
1020: hr_utility.set_location('New p_assignment_extra_info_id '||p_assignment_extra_info_id,10);
1021: hr_utility.set_location('Old p_assignment_extra_info_id '||pe_aei_shd.g_old_rec.assignment_extra_info_id,10);
1022:
1023: if pe_aei_shd.g_old_rec.assignment_extra_info_id is null then
1024: hr_utility.set_location('Values are null',10);

Line 1021: hr_utility.set_location('Old p_assignment_extra_info_id '||pe_aei_shd.g_old_rec.assignment_extra_info_id,10);

1017:
1018: begin
1019: hr_utility.set_location('Entering '||l_proc,10);
1020: hr_utility.set_location('New p_assignment_extra_info_id '||p_assignment_extra_info_id,10);
1021: hr_utility.set_location('Old p_assignment_extra_info_id '||pe_aei_shd.g_old_rec.assignment_extra_info_id,10);
1022:
1023: if pe_aei_shd.g_old_rec.assignment_extra_info_id is null then
1024: hr_utility.set_location('Values are null',10);
1025: return;

Line 1024: hr_utility.set_location('Values are null',10);

1020: hr_utility.set_location('New p_assignment_extra_info_id '||p_assignment_extra_info_id,10);
1021: hr_utility.set_location('Old p_assignment_extra_info_id '||pe_aei_shd.g_old_rec.assignment_extra_info_id,10);
1022:
1023: if pe_aei_shd.g_old_rec.assignment_extra_info_id is null then
1024: hr_utility.set_location('Values are null',10);
1025: return;
1026: end if;
1027:
1028: c_old_rec.assignment_extra_info_id := pe_aei_shd.g_old_rec.assignment_extra_info_id;

Line 1032: hr_utility.set_location('c_old_rec.assignment_extra_info_id '||c_old_rec.assignment_extra_info_id,10);

1028: c_old_rec.assignment_extra_info_id := pe_aei_shd.g_old_rec.assignment_extra_info_id;
1029: c_old_rec.assignment_id := pe_aei_shd.g_old_rec.assignment_id;
1030: c_old_rec.information_type := pe_aei_shd.g_old_rec.information_type;
1031:
1032: hr_utility.set_location('c_old_rec.assignment_extra_info_id '||c_old_rec.assignment_extra_info_id,10);
1033: hr_utility.set_location('c_old_rec.assignment_id '||c_old_rec.assignment_id,10);
1034: hr_utility.set_location('c_old_rec.information_type '||c_old_rec.information_type,10);
1035:
1036: ben_per_asg_eit_ler.ler_asg_chk(

Line 1033: hr_utility.set_location('c_old_rec.assignment_id '||c_old_rec.assignment_id,10);

1029: c_old_rec.assignment_id := pe_aei_shd.g_old_rec.assignment_id;
1030: c_old_rec.information_type := pe_aei_shd.g_old_rec.information_type;
1031:
1032: hr_utility.set_location('c_old_rec.assignment_extra_info_id '||c_old_rec.assignment_extra_info_id,10);
1033: hr_utility.set_location('c_old_rec.assignment_id '||c_old_rec.assignment_id,10);
1034: hr_utility.set_location('c_old_rec.information_type '||c_old_rec.information_type,10);
1035:
1036: ben_per_asg_eit_ler.ler_asg_chk(
1037: p_old =>c_old_rec,

Line 1034: hr_utility.set_location('c_old_rec.information_type '||c_old_rec.information_type,10);

1030: c_old_rec.information_type := pe_aei_shd.g_old_rec.information_type;
1031:
1032: hr_utility.set_location('c_old_rec.assignment_extra_info_id '||c_old_rec.assignment_extra_info_id,10);
1033: hr_utility.set_location('c_old_rec.assignment_id '||c_old_rec.assignment_id,10);
1034: hr_utility.set_location('c_old_rec.information_type '||c_old_rec.information_type,10);
1035:
1036: ben_per_asg_eit_ler.ler_asg_chk(
1037: p_old =>c_old_rec,
1038: p_new =>null,

Line 1041: hr_utility.set_location('leaving '||l_proc,20);

1037: p_old =>c_old_rec,
1038: p_new =>null,
1039: p_mode => 'DELETE'
1040: );
1041: hr_utility.set_location('leaving '||l_proc,20);
1042: exception
1043: when others then
1044: hr_utility.set_location('leaving '||l_proc,21);
1045: raise;

Line 1044: hr_utility.set_location('leaving '||l_proc,21);

1040: );
1041: hr_utility.set_location('leaving '||l_proc,20);
1042: exception
1043: when others then
1044: hr_utility.set_location('leaving '||l_proc,21);
1045: raise;
1046: end delete_ler_asg;
1047: end ben_per_asg_eit_ler;