APPS.BEN_EXT_ANSI dependencies on HR_UTILITY

Line 144: hr_utility.set_location('Entering'||l_proc, 5);

140:
141: --
142: Begin
143: --
144: hr_utility.set_location('Entering'||l_proc, 5);
145: --
146: -- new way of determining if this person is a participant (aka subscriber);
147: l_include := 'N';
148: for enrt in c_enrt_rslt loop

Line 244: hr_utility.set_location (' try as dpnt ' , 99 ) ;

240: --
241: --
242: -- remember a person can be both a subsciber of one plan and a dependent of another!
243: --
244: hr_utility.set_location (' try as dpnt ' , 99 ) ;
245: ben_ext_person.g_part_type := 'D'; -- Dependent
246: -- remember a person can be a dpnt for two diff subscribers.
247: for i in c_dpnt_of_distinct_participant loop
248: --

Line 249: hr_utility.set_location (' dpnt loop ' , 99 ) ;

245: ben_ext_person.g_part_type := 'D'; -- Dependent
246: -- remember a person can be a dpnt for two diff subscribers.
247: for i in c_dpnt_of_distinct_participant loop
248: --
249: hr_utility.set_location (' dpnt loop ' , 99 ) ;
250: -- now loop through each of their enrollments and see if they are included.
251: --
252: l_include := 'N';
253: for j in c_cvrd_dpnt(i.person_id,p_person_id) loop

Line 276: hr_utility.set_location (' dpnt cvg thryu dat ' || l_dpnt_cvg_thru_dt , 99 ) ;

272: p_include => l_include);
273: --
274: l_dpnt_cvg_thru_dt := j.cvg_thru_dt ;
275:
276: hr_utility.set_location (' dpnt cvg thryu dat ' || l_dpnt_cvg_thru_dt , 99 ) ;
277: hr_utility.set_location (' dpnt include ' || l_include , 99 ) ;
278: if l_include = 'Y' then -- l_include means they met inclusion criteria.
279: exit; -- out of j loop.
280: end if;

Line 277: hr_utility.set_location (' dpnt include ' || l_include , 99 ) ;

273: --
274: l_dpnt_cvg_thru_dt := j.cvg_thru_dt ;
275:
276: hr_utility.set_location (' dpnt cvg thryu dat ' || l_dpnt_cvg_thru_dt , 99 ) ;
277: hr_utility.set_location (' dpnt include ' || l_include , 99 ) ;
278: if l_include = 'Y' then -- l_include means they met inclusion criteria.
279: exit; -- out of j loop.
280: end if;
281: --

Line 357: hr_utility.set_location('Mandatory failed '||ben_extract.gtt_rcd_rqd_vals_seq(i).low_lvl_cd || ' '||

353: -- validate the mandatory for low level in sequenc
354: FOR i in ben_extract.gtt_rcd_rqd_vals_seq.first .. ben_extract.gtt_rcd_rqd_vals_seq.last LOOP
355: --
356: If NOT ben_extract.gtt_rcd_rqd_vals_seq(i).rcd_found THEN
357: hr_utility.set_location('Mandatory failed '||ben_extract.gtt_rcd_rqd_vals_seq(i).low_lvl_cd || ' '||
358: ben_extract.gtt_rcd_rqd_vals_seq(i).seq_num , 15);
359: l_rollback := TRUE; -- raise required_error;
360: end if ;
361:

Line 369: hr_utility.set_location(' record not found ' || l_proc, 15) ;

365: END LOOP;
366: --
367:
368: if l_rollback then
369: hr_utility.set_location(' record not found ' || l_proc, 15) ;
370: raise ben_ext_person.required_error ;
371: end if ;
372:
373: --

Line 374: hr_utility.set_location('Exiting'||l_proc, 15);

370: raise ben_ext_person.required_error ;
371: end if ;
372:
373: --
374: hr_utility.set_location('Exiting'||l_proc, 15);
375: --
376: End main;
377: --
378: --