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

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

144: l_return boolean;
145: --
146: begin
147: --
148: hr_utility.set_location('Entering:'|| l_proc, 10);
149: --
150: open get_change;
151: fetch get_change into l_dummy;
152: --

Line 163: hr_utility.set_location('Exiting:'|| l_proc, 99);

159: close get_change;
160: --
161: return (l_return);
162: --
163: hr_utility.set_location('Exiting:'|| l_proc, 99);
164: --
165: end change_exists_in_db;
166: --
167: --

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

177: l_return boolean := FALSE;
178: --
179: begin
180: --
181: hr_utility.set_location('Entering:'|| l_proc, 10);
182: --
183: for l_counter in 1..p_chg_evt_tab.count loop
184: if p_chg_evt_tab(l_counter) = p_chg_evt_cd
185: and p_chg_eff_tab(l_counter) = p_chg_eff_dt then

Line 193: hr_utility.set_location('Exiting:'|| l_proc, 99);

189: end loop;
190: --
191: return (l_return);
192: --
193: hr_utility.set_location('Exiting:'|| l_proc, 99);
194: --
195: end change_exists_in_mem;
196: --
197: ------------------------------------------------------------------------

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

214: l_return boolean;
215: --
216: begin
217: --
218: hr_utility.set_location('Entering:'|| l_proc, 10);
219: --
220: open c_lookup_is_enabled;
221: fetch c_lookup_is_enabled into l_dummy;
222: --

Line 233: hr_utility.set_location('Exiting:'|| l_proc, 99);

229: close c_lookup_is_enabled;
230: --
231: return (l_return);
232: --
233: hr_utility.set_location('Exiting:'|| l_proc, 99);
234: --
235: end change_event_is_enabled;
236: --
237:

Line 255: hr_utility.set_location('Entering:'|| l_proc, 05);

251: --
252: l_proc varchar2(100) := 'ben_ext_chlg.log_per_chg';
253: begin
254:
255: hr_utility.set_location('Entering:'|| l_proc, 05);
256:
257:
258: l_old_rec.national_identifier := p_old_rec.national_identifier;
259: l_old_rec.full_name := p_old_rec.full_name;

Line 420: hr_utility.set_location('Exiting:'|| l_proc, 99);

416: (p_event => p_event
417: ,p_old_rec => l_old_rec
418: ,p_new_rec => l_new_rec
419: );
420: hr_utility.set_location('Exiting:'|| l_proc, 99);
421: end ;
422:
423: ------------------------------------------------------------------------------------------
424: procedure log_per_chg

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

515: l_proc varchar2(100) := 'ben_ext_chlg.log_per_chg';
516: --
517: begin
518: --
519: hr_utility.set_location('Entering:'|| l_proc, 10);
520: --
521: if p_event = 'UPDATE' then
522: --
523: if nvl(p_old_rec.national_identifier, '000-00-0000')

Line 1628: hr_utility.set_location ( 'Contact person ' || l_relationship , 11 ) ;

1624: open c_con_relationship(p_new_rec.person_id , p_new_rec.effective_start_date );
1625: Loop
1626: fetch c_con_relationship into l_contact,l_relationship , l_person_type ;
1627: Exit When c_con_relationship%notfound ;
1628: hr_utility.set_location ( 'Contact person ' || l_relationship , 11 ) ;
1629: hr_utility.set_location ( 'relation type ' || l_person_type , 11 ) ;
1630: l_ini_tab_counter := 1 ;
1631: l_tab_counter := 0 ;
1632: l_cont_chg_evt_tab.delete ;

Line 1629: hr_utility.set_location ( 'relation type ' || l_person_type , 11 ) ;

1625: Loop
1626: fetch c_con_relationship into l_contact,l_relationship , l_person_type ;
1627: Exit When c_con_relationship%notfound ;
1628: hr_utility.set_location ( 'Contact person ' || l_relationship , 11 ) ;
1629: hr_utility.set_location ( 'relation type ' || l_person_type , 11 ) ;
1630: l_ini_tab_counter := 1 ;
1631: l_tab_counter := 0 ;
1632: l_cont_chg_evt_tab.delete ;
1633:

Line 1765: hr_utility.set_location ( ' change event ' || l_cont_chg_evt_tab(l_count) , 11 ) ;

1761: end if;
1762: -- insert the row for every relation , the person id may change for every row
1763: for l_count in 1 .. l_tab_counter loop
1764:
1765: hr_utility.set_location ( ' change event ' || l_cont_chg_evt_tab(l_count) , 11 ) ;
1766: if change_event_is_enabled(l_cont_chg_evt_tab(l_count),p_new_rec.effective_start_date)
1767: then
1768:
1769: ben_ext_chg_evt_api.create_ext_chg_evt

Line 1807: hr_utility.set_location('Exiting:'|| l_proc, 99);

1803: close c_con_relationship ;
1804: ----
1805: end if;
1806: --
1807: hr_utility.set_location('Exiting:'|| l_proc, 99);
1808: --
1809: end log_per_chg;
1810: --
1811: procedure log_cont_chg

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

1861: where hl.lookup_type = 'CONTACT'
1862: and hl.lookup_code = p_lookup_code;
1863: begin
1864: --
1865: hr_utility.set_location('Entering:'|| l_proc, 10);
1866: --
1867: open c_person_type(p_new_rec.contact_person_id);
1868: fetch c_person_type into l_person_type,l_full_name;
1869: if c_person_type%notfound then

Line 1877: hr_utility.set_location ( 'old contact ' || l_old_contact_type,99) ;

1873: close c_person_type;
1874: open c_lookup_value( p_old_rec.contact_type);
1875: fetch c_lookup_value into l_old_contact_type;
1876: close c_lookup_value;
1877: hr_utility.set_location ( 'old contact ' || l_old_contact_type,99) ;
1878: open c_lookup_value( p_new_rec.contact_type);
1879: fetch c_lookup_value into l_new_contact_type;
1880: close c_lookup_value;
1881: hr_utility.set_location ( 'new contact ' || l_new_contact_type,99) ;

Line 1881: hr_utility.set_location ( 'new contact ' || l_new_contact_type,99) ;

1877: hr_utility.set_location ( 'old contact ' || l_old_contact_type,99) ;
1878: open c_lookup_value( p_new_rec.contact_type);
1879: fetch c_lookup_value into l_new_contact_type;
1880: close c_lookup_value;
1881: hr_utility.set_location ( 'new contact ' || l_new_contact_type,99) ;
1882:
1883: if l_person_type = 'OTHER' then
1884: l_tab_counter := l_tab_counter + 1;
1885:

Line 1886: hr_utility.set_location ( 'change evnt ' ,99) ;

1882:
1883: if l_person_type = 'OTHER' then
1884: l_tab_counter := l_tab_counter + 1;
1885:
1886: hr_utility.set_location ( 'change evnt ' ,99) ;
1887: --
1888: -- Handle web case where date_start is null
1889: --
1890: l_chg_evt_tab(l_tab_counter) := 'CCRE';

Line 1915: hr_utility.set_location ( 'change evnt ' ,99) ;

1911: end if ;
1912: --- for every person contact changes
1913: l_tab_counter := l_tab_counter + 1;
1914:
1915: hr_utility.set_location ( 'change evnt ' ,99) ;
1916: --
1917: -- Handle web case where date_start is null
1918: --
1919: l_chg_evt_tab(l_tab_counter) := 'CCNRE';

Line 1944: hr_utility.set_location ( 'calling api ' ,99) ;

1940:
1941: end if;
1942: for l_count in 1..l_chg_evt_tab.count loop
1943: if change_event_is_enabled(l_chg_evt_tab(l_count),trunc(sysdate)) then
1944: hr_utility.set_location ( 'calling api ' ,99) ;
1945: ben_ext_chg_evt_api.create_ext_chg_evt
1946: (p_validate => FALSE
1947: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
1948: ,p_chg_evt_cd => l_chg_evt_tab(l_count)

Line 1977: hr_utility.set_location('Exiting:'|| l_proc, 99);

1973: );
1974: end if;
1975: end loop;
1976: --
1977: hr_utility.set_location('Exiting:'|| l_proc, 99);
1978: --
1979: end log_cont_chg;
1980: --
1981: procedure log_add_chg

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

2049: ;
2050: --
2051: begin
2052: --
2053: hr_utility.set_location('Entering:'|| l_proc, 10);
2054: --
2055: if p_event = 'INSERT' then
2056: l_person_id := p_new_rec.person_id;
2057: l_business_group_id := p_new_rec.business_group_id;

Line 2344: hr_utility.set_location(' in address changes ' , 673);

2340: --
2341: --
2342: elsif p_event = 'UPDATE' then
2343: -- cache this data for later use.
2344: hr_utility.set_location(' in address changes ' , 673);
2345: g_prev_upd_adr_person_id := p_new_rec.person_id;
2346: g_prev_upd_adr_primary_flag := p_new_rec.primary_flag;
2347: g_prev_upd_adr_to_date := p_new_rec.date_to;
2348: g_prev_upd_adr_address_line1 := p_new_rec.address_line1;

Line 3016: hr_utility.set_location('Continuing:'|| l_proc, 20);

3012: end if;
3013: end if;
3014: end if;
3015: --
3016: hr_utility.set_location('Continuing:'|| l_proc, 20);
3017: hr_utility.set_location('BGP ID:'||p_new_rec.business_group_id||' '||l_proc, 30);
3018: for l_count in 1..l_chg_evt_tab.count loop
3019: if change_event_is_enabled(l_chg_evt_tab(l_count),trunc(sysdate)) then
3020: if l_chg_evt_tab(l_count) in ('CCPA','CCMA','CCNPA','CCNMA') then

Line 3017: hr_utility.set_location('BGP ID:'||p_new_rec.business_group_id||' '||l_proc, 30);

3013: end if;
3014: end if;
3015: --
3016: hr_utility.set_location('Continuing:'|| l_proc, 20);
3017: hr_utility.set_location('BGP ID:'||p_new_rec.business_group_id||' '||l_proc, 30);
3018: for l_count in 1..l_chg_evt_tab.count loop
3019: if change_event_is_enabled(l_chg_evt_tab(l_count),trunc(sysdate)) then
3020: if l_chg_evt_tab(l_count) in ('CCPA','CCMA','CCNPA','CCNMA') then
3021: l_person_id := nvl(l_prmtr_07_tab(l_count),l_relationship);

Line 3059: hr_utility.set_location('Exiting:'|| l_proc, 99);

3055: );
3056: end if;
3057: end loop;
3058: --
3059: hr_utility.set_location('Exiting:'|| l_proc, 99);
3060: --
3061: end log_add_chg;
3062:
3063: ----- this is a overlaod procedure to call from core HR

Line 3077: hr_utility.set_location('Entering:'|| l_proc, 05);

3073: --
3074: l_proc varchar2(100) := 'ben_ext_chlg.log_asg_chg';
3075: begin
3076:
3077: hr_utility.set_location('Entering:'|| l_proc, 05);
3078: -------------
3079: l_old_rec.assignment_id := p_old_rec.assignment_id;
3080: l_old_rec.assignment_status_type_id := p_old_rec.assignment_status_type_id;
3081: l_old_rec.hourly_salaried_code := p_old_rec.hourly_salaried_code;

Line 3152: hr_utility.set_location('Exiting:'|| l_proc, 99);

3148: ,p_new_rec => l_new_rec
3149: );
3150: ---------------
3151:
3152: hr_utility.set_location('Exiting:'|| l_proc, 99);
3153:
3154: end ;
3155: --
3156: procedure log_asg_chg

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

3244: l_proc varchar2(80) := 'ben_ext_chlg.log_asg_chg';
3245: --
3246: begin
3247: --
3248: hr_utility.set_location('Entering:'|| l_proc, 10);
3249: --
3250: if p_event = 'UPDATE' then
3251: --
3252: if nvl(p_old_rec.assignment_status_type_id, 1)

Line 3656: hr_utility.set_location('Exiting:'|| l_proc, 99);

3652: );
3653: end if;
3654: end loop;
3655: --
3656: hr_utility.set_location('Exiting:'|| l_proc, 99);
3657: --
3658: end log_asg_chg;
3659: --
3660: procedure log_abs_chg

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

3713: where aar.abs_attendance_reason_id = p_abs_attendance_reason_id;
3714: --
3715: begin
3716: --
3717: hr_utility.set_location('Entering:'|| l_proc, 10);
3718: --
3719: if p_event = 'UPDATE' then
3720: --
3721: l_business_group_id := p_new_rec.business_group_id;

Line 3890: hr_utility.set_location('Exiting:'|| l_proc, 99);

3886: );
3887: end if;
3888: end loop;
3889: --
3890: hr_utility.set_location('Exiting:'|| l_proc, 99);
3891: --
3892: end log_abs_chg;
3893: --
3894: --

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

3965: and p_effective_date between opt.effective_start_date and opt.effective_end_date;
3966: --
3967: begin
3968: --
3969: hr_utility.set_location('Entering:'||l_proc, 10);
3970: --
3971: -- Get the new values to be store or updated
3972: --
3973: if p_prtt_enrt_rslt_id is not null then

Line 4587: hr_utility.set_location('Exiting:'||l_proc, 99);

4583: --
4584: end if; -- DELETE
4585: --
4586: --
4587: hr_utility.set_location('Exiting:'||l_proc, 99);
4588: --
4589: END log_benefit_chg;
4590: --
4591: procedure log_dependent_chg(

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

4655: --
4656: --
4657: begin
4658: --
4659: hr_utility.set_location('Entering:'||l_proc, 10);
4660: --
4661: -- Get the new values to be store or updated
4662: --
4663: open c_plan_name(p_pl_id);

Line 4885: hr_utility.set_location('Exiting:'||l_proc, 99);

4881: );
4882: end if;
4883: end if;
4884: --
4885: hr_utility.set_location('Exiting:'||l_proc, 99);
4886: --
4887: end log_dependent_chg;
4888: --
4889: procedure log_pcp_chg(

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

4968: l_pcp_chg boolean := FALSE;
4969: --
4970: begin
4971: --
4972: hr_utility.set_location('Entering:'||l_proc, 10);
4973: --
4974: -- Get the values to be store or updated
4975: if p_prtt_enrt_rslt_id is not null then
4976: open c_prtt_person_id;

Line 5262: hr_utility.set_location('Exiting:'||l_proc, 99);

5258: close c_con_relationship;
5259: -- end of creating log for all relationship
5260: --
5261: end if; --p_action
5262: hr_utility.set_location('Exiting:'||l_proc, 99);
5263: --
5264: end log_pcp_chg;
5265: --
5266: procedure log_pos_chg

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

5300: l_proc varchar2(72) := 'ben_ext_chlg.log_pos_chg';
5301: --
5302: begin
5303: --
5304: hr_utility.set_location('Entering:'||l_proc, 10);
5305:
5306:
5307: --
5308: if p_event = 'UPDATE' then

Line 5440: hr_utility.set_location('Exiting:'||l_proc, 99);

5436: --End Bug 4539732
5437: end if;
5438: end loop;
5439: --
5440: hr_utility.set_location('Exiting:'||l_proc, 99);
5441: --
5442: end log_pos_chg;
5443: --
5444: procedure log_apl_chg

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

5487: l_new_termination_reason varchar2(50);
5488: --
5489: begin
5490: --
5491: hr_utility.set_location('Entering:'||l_proc, 10);
5492: -- removed because the pos leaving reason should
5493: -- have been used.
5494: null;
5495: --

Line 5496: hr_utility.set_location('Exiting:'||l_proc, 99);

5492: -- removed because the pos leaving reason should
5493: -- have been used.
5494: null;
5495: --
5496: hr_utility.set_location('Exiting:'||l_proc, 99);
5497: --
5498: end log_apl_chg;
5499: --
5500:

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

5517: and ppe.per_in_ler_id = pil.per_in_ler_id ;
5518: --
5519: l_proc varchar2(72) := 'ben_ext_chlg.log_prem_mo_chg';
5520: Begin
5521: hr_utility.set_location('Entering:'||l_proc, 10);
5522: open c_person(p_new_rec.prtt_prem_id) ;
5523: fetch c_person into l_person_id ;
5524: close c_person ;
5525:

Line 5533: hr_utility.set_location('valiating chg evt cd :', 10);

5529: -- this is fixed by obsolete the COPMPRM and added CCOPMPRM in lookup
5530: -- the code support for COPMPRM to make sure the customer has no problem
5531: -- if the data is logged, ct can get the data by changing the setup at anytime
5532:
5533: hr_utility.set_location('valiating chg evt cd :', 10);
5534: if (change_event_is_enabled('COPMPRM',p_new_rec.effective_start_date) or
5535: change_event_is_enabled('CCOPMPRM',p_new_rec.effective_start_date) ) then
5536:
5537: hr_utility.set_location('calling log event :', 10);

Line 5537: hr_utility.set_location('calling log event :', 10);

5533: hr_utility.set_location('valiating chg evt cd :', 10);
5534: if (change_event_is_enabled('COPMPRM',p_new_rec.effective_start_date) or
5535: change_event_is_enabled('CCOPMPRM',p_new_rec.effective_start_date) ) then
5536:
5537: hr_utility.set_location('calling log event :', 10);
5538:
5539: ben_ext_chg_evt_api.create_ext_chg_evt
5540: (p_validate => FALSE
5541: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id

Line 5561: hr_utility.set_location('Exiting:'||l_proc, 99);

5557:
5558: end if ;
5559: end if ;
5560: --
5561: hr_utility.set_location('Exiting:'||l_proc, 99);
5562: --
5563: end log_prem_mo_chg;
5564:
5565: --

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

5580:
5581: --
5582: l_proc varchar2(72) := 'ben_ext_chlg.log_school_chg';
5583: Begin
5584: hr_utility.set_location('Entering:'||l_proc, 10);
5585: open c_name(p_old_rec.establishment_id) ;
5586: fetch c_name into l_old_name ;
5587: close c_name ;
5588:

Line 5616: hr_utility.set_location('Exiting:'||l_proc, 99);

5612: );
5613: end if ;
5614: end if ;
5615: --
5616: hr_utility.set_location('Exiting:'||l_proc, 99);
5617: --
5618: end log_school_chg;
5619:
5620:

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

5660: --
5661: begin
5662: --
5663:
5664: hr_utility.set_location('Entering:'||l_proc, 10);
5665: hr_utility.set_location('assignment_id:'||p_new_rec.assignment_id, 10);
5666: /*
5667: open c_person(p_new_rec.assignment_id);
5668: fetch c_person into l_person_id,l_business_group_id ;

Line 5665: hr_utility.set_location('assignment_id:'||p_new_rec.assignment_id, 10);

5661: begin
5662: --
5663:
5664: hr_utility.set_location('Entering:'||l_proc, 10);
5665: hr_utility.set_location('assignment_id:'||p_new_rec.assignment_id, 10);
5666: /*
5667: open c_person(p_new_rec.assignment_id);
5668: fetch c_person into l_person_id,l_business_group_id ;
5669: close c_person ;

Line 5671: hr_utility.set_location(' EVENT ' || p_event, 99 );

5667: open c_person(p_new_rec.assignment_id);
5668: fetch c_person into l_person_id,l_business_group_id ;
5669: close c_person ;
5670: */
5671: hr_utility.set_location(' EVENT ' || p_event, 99 );
5672:
5673: --- previously part of trigger now the trigger moved to api (pepyprhi.pkb)
5674: --- so the approved validation moved here
5675:

Line 5678: hr_utility.set_location('change_date' || p_new_rec.change_date,10);

5674: --- so the approved validation moved here
5675:
5676: if nvl(p_new_rec.approved,'N') = 'Y' then
5677: if p_event = 'INSERT' then
5678: hr_utility.set_location('change_date' || p_new_rec.change_date,10);
5679: open c_old_sal(p_new_rec.assignment_id,p_new_rec.change_date);
5680: fetch c_old_sal into l_old_proposed_salary_n ,l_old_approved ;
5681: close c_old_sal ;
5682: hr_utility.set_location('salary ' || l_old_proposed_salary_n,10);

Line 5682: hr_utility.set_location('salary ' || l_old_proposed_salary_n,10);

5678: hr_utility.set_location('change_date' || p_new_rec.change_date,10);
5679: open c_old_sal(p_new_rec.assignment_id,p_new_rec.change_date);
5680: fetch c_old_sal into l_old_proposed_salary_n ,l_old_approved ;
5681: close c_old_sal ;
5682: hr_utility.set_location('salary ' || l_old_proposed_salary_n,10);
5683: end if ;
5684:
5685:
5686:

Line 5714: hr_utility.set_location('Exiting:'||l_proc, 99);

5710: End if;
5711: end if ;
5712: end if ;
5713: --
5714: hr_utility.set_location('Exiting:'||l_proc, 99);
5715: --
5716: end log_per_pay_chg;
5717:
5718: ----

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

5778: l_update_mode varchar2(15); --Bug 1554477
5779: --
5780: begin
5781: --
5782: hr_utility.set_location('Entering:'||l_proc, 10);
5783: --
5784: if p_event = 'UPDATE' and p_new_rec.parent_table = 'PER_ALL_PEOPLE_F'
5785: and p_new_rec.phone_type in ('H1', 'W1', 'HF','M') then
5786: --

Line 5943: hr_utility.set_location('l_business_group_id:'||l_business_group_id, 876);

5939: open c_business_group_id(l_person_id); --, l_chg_eff_dt); -- commented for bug 3361237
5940: -- Bug 1554477
5941: fetch c_business_group_id into l_business_group_id;
5942: close c_business_group_id;
5943: hr_utility.set_location('l_business_group_id:'||l_business_group_id, 876);
5944:
5945: for l_count in 1..l_chg_evt_tab.count loop
5946: if change_event_is_enabled(l_chg_evt_tab(l_count),l_chg_eff_dt) then
5947:

Line 5972: hr_utility.set_location('Exiting:'||l_proc, 99);

5968:
5969: end if;
5970: end loop;
5971: --
5972: hr_utility.set_location('Exiting:'||l_proc, 99);
5973: --
5974: end log_phn_chg;
5975: --
5976: procedure log_ptu_chg

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

6022: l_business_group_id number;
6023: --
6024: begin
6025: --
6026: hr_utility.set_location('Entering:'||l_proc, 10);
6027: --
6028: if p_event = 'INSERT' then
6029: --
6030: open c_person_type(p_new_rec.person_type_id);

Line 6094: hr_utility.set_location('Exiting:'||l_proc, 99);

6090: );
6091: end if;
6092: end loop;
6093: --
6094: hr_utility.set_location('Exiting:'||l_proc, 99);
6095: --
6096: end log_ptu_chg;
6097: --
6098: procedure log_element_chg(

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

6125:
6126: --
6127: begin
6128: --
6129: hr_utility.set_location('Entering:'||l_proc, 10);
6130: --
6131: open c_get_element_info(p_input_value_id);
6132: fetch c_get_element_info into l_element_info;
6133: close c_get_element_info;

Line 6175: hr_utility.set_location('deleteing element entry ' , 195);

6171: ,p_new_val3 => p_amt);
6172: end if;
6173: --
6174: elsif p_action = 'DELETE' then
6175: hr_utility.set_location('deleteing element entry ' , 195);
6176: if change_event_is_enabled('DEE',p_effective_date) then
6177: ben_ext_chg_evt_api.create_ext_chg_evt
6178: (p_validate => FALSE
6179: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id

Line 6195: hr_utility.set_location('Exiting:'||l_proc, 99);

6191: end if;
6192: end if;
6193: --
6194: --
6195: hr_utility.set_location('Exiting:'||l_proc, 99);
6196: --
6197: end log_element_chg;
6198: --
6199: -- procedure for logging changes to per_disabilities_f

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

6257:
6258: --
6259: begin
6260: --
6261: hr_utility.set_location('Entering:'|| l_proc, 10);
6262: --
6263: if p_event = 'UPDATE' then
6264:
6265: if nvl(p_old_rec.incident_id,1) <> nvl(p_new_rec.incident_id,1) then

Line 7136: hr_utility.set_location('Exiting:'|| l_proc, 99);

7132:
7133: ----
7134: end if;
7135: --
7136: hr_utility.set_location('Exiting:'|| l_proc, 99);
7137: --
7138: end log_per_dis_chg;
7139: --
7140: end ben_ext_chlg;