[Home] [Help]
14: 115.0 14-May-99 bbulusu Created.
15: 115.1 14-Jun-99 Tmathers Fixed P1 nls to_date errors.
16: 115.2 23-JUN-98 G PERRY Performance fixes.
17: 115.3 20-JUL-99 Gperry genutils -> benutils package rename.
18: 115.4 10-AUG-99 Gperry Removed reference to ben_manage_life_events
19: old cache routine. Added fnd_date.canonical
20: _to_date for formula calls.
21: 115.5 26-AUG-99 Gperry Added call to benefits assignment cache when
22: employee assignment can not be found.
180: fnd_message.set_name('BEN', 'BEN_92197_CANT_CALC_SVC_DATE');
181: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
182: fnd_message.set_token('DATE_CODE',p_date_code);
183: fnd_message.set_token('PROC',l_proc);
184: raise ben_manage_life_events.g_record_error;
185: --
186: end if;
187: */
188: --
288: fnd_message.set_name('BEN', 'BEN_92197_CANT_CALC_SVC_DATE');
289: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
290: fnd_message.set_token('DATE_CODE',p_date_code);
291: fnd_message.set_token('PROC',l_proc);
292: raise ben_manage_life_events.g_record_error;
293: --
294: end if;
295: */
296: --
703: --
704: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
705: fnd_message.set_token('PROC',l_proc);
706: fnd_message.set_token('CODE1',p_wait_perd_dt_to_use_cd);
707: raise ben_manage_life_events.g_record_error ;
708: end if;
709: --
710: if p_wait_perd_dt_to_use_cd IS NOT NULL and l_wait_st_date IS NULL then
711: --
714: fnd_message.set_name('BEN', 'BEN_92197_CANT_CALC_SVC_DATE');
715: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
716: fnd_message.set_token('DATE_CODE',p_wait_perd_dt_to_use_cd);
717: fnd_message.set_token('PROC',l_proc);
718: raise ben_manage_life_events.g_record_error;
719: --
720: end if;
721: --
722: hr_utility.set_location('Wait start date ' || l_wait_st_date, 10);
826: -- This is the main procedure that is called to compute the waiting period end
827: -- date for a plan.
828: --
829: procedure main
830: (p_comp_obj_tree_row in ben_manage_life_events.g_cache_proc_objects_rec
831: ,p_person_id in number
832: ,p_effective_date in date
833: ,p_business_group_id in number
834: ,p_ler_id in number