176: --
177: hr_utility.set_location('ERROR. Unable to calculate service date : ' ||
178: p_date_code, 10);
179: --
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;
177: hr_utility.set_location('ERROR. Unable to calculate service date : ' ||
178: p_date_code, 10);
179: --
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: --
178: p_date_code, 10);
179: --
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;
179: --
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: */
284: if l_return_date is null then
285: --
286: hr_utility.set_location('ERROR in ' || l_proc, 10);
287: --
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;
285: --
286: hr_utility.set_location('ERROR in ' || l_proc, 10);
287: --
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: --
286: hr_utility.set_location('ERROR in ' || l_proc, 10);
287: --
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;
287: --
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: */
415: l_wait_st_date := fnd_date.canonical_to_date
416: (l_outputs(l_outputs.first).value);
417: exception
418: when others then
419: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
420: fnd_message.set_token('RL',
421: 'wait_perd_dt_to_use_rl :'||p_wait_perd_dt_to_use_rl);
422: fnd_message.set_token('PROC',l_proc);
423: fnd_message.raise_error;
416: (l_outputs(l_outputs.first).value);
417: exception
418: when others then
419: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
420: fnd_message.set_token('RL',
421: 'wait_perd_dt_to_use_rl :'||p_wait_perd_dt_to_use_rl);
422: fnd_message.set_token('PROC',l_proc);
423: fnd_message.raise_error;
424: end;
418: when others then
419: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
420: fnd_message.set_token('RL',
421: 'wait_perd_dt_to_use_rl :'||p_wait_perd_dt_to_use_rl);
422: fnd_message.set_token('PROC',l_proc);
423: fnd_message.raise_error;
424: end;
425:
426: elsif p_wait_perd_dt_to_use_cd = 'EOSDNOSD' then
419: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
420: fnd_message.set_token('RL',
421: 'wait_perd_dt_to_use_rl :'||p_wait_perd_dt_to_use_rl);
422: fnd_message.set_token('PROC',l_proc);
423: fnd_message.raise_error;
424: end;
425:
426: elsif p_wait_perd_dt_to_use_cd = 'EOSDNOSD' then
427: --
700: else
701: --
702: -- Defensive coding in case code is not known.
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;
701: --
702: -- Defensive coding in case code is not known.
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: --
702: -- Defensive coding in case code is not known.
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
710: if p_wait_perd_dt_to_use_cd IS NOT NULL and l_wait_st_date IS NULL then
711: --
712: hr_utility.set_location('ERROR in ' || l_proc, 10);
713: --
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;
711: --
712: hr_utility.set_location('ERROR in ' || l_proc, 10);
713: --
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: --
712: hr_utility.set_location('ERROR in ' || l_proc, 10);
713: --
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;
713: --
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: --
783: l_wait_perd_val := l_outputs(l_count).value;
784: elsif l_outputs(l_count).name = 'WAIT_PERD_UOM' then
785: l_wait_perd_uom := l_outputs(l_count).value;
786: else
787: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
788: fnd_message.set_token('RL',
789: 'wait_perd_rl :'||p_wait_perd_rl);
790: fnd_message.set_token('PROC',l_proc);
791: fnd_message.raise_error;
784: elsif l_outputs(l_count).name = 'WAIT_PERD_UOM' then
785: l_wait_perd_uom := l_outputs(l_count).value;
786: else
787: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
788: fnd_message.set_token('RL',
789: 'wait_perd_rl :'||p_wait_perd_rl);
790: fnd_message.set_token('PROC',l_proc);
791: fnd_message.raise_error;
792: end if;
786: else
787: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
788: fnd_message.set_token('RL',
789: 'wait_perd_rl :'||p_wait_perd_rl);
790: fnd_message.set_token('PROC',l_proc);
791: fnd_message.raise_error;
792: end if;
793: end loop;
794: else
787: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
788: fnd_message.set_token('RL',
789: 'wait_perd_rl :'||p_wait_perd_rl);
790: fnd_message.set_token('PROC',l_proc);
791: fnd_message.raise_error;
792: end if;
793: end loop;
794: else
795: --