930: open formulatypeid;
931: fetch formulatypeid into l_formula_type_id;
932: if formulatypeid%notfound
933: then
934: hr_utility.set_message(800,'PER_289164_INVAL_FORMULA_TYPE');
935: hr_utility.set_message_token('FORMULA_TYPE', p_formula_type_name);
936: hr_utility.raise_error;
937: end if;
938: close formulatypeid;
931: fetch formulatypeid into l_formula_type_id;
932: if formulatypeid%notfound
933: then
934: hr_utility.set_message(800,'PER_289164_INVAL_FORMULA_TYPE');
935: hr_utility.set_message_token('FORMULA_TYPE', p_formula_type_name);
936: hr_utility.raise_error;
937: end if;
938: close formulatypeid;
939: return l_formula_type_id;
932: if formulatypeid%notfound
933: then
934: hr_utility.set_message(800,'PER_289164_INVAL_FORMULA_TYPE');
935: hr_utility.set_message_token('FORMULA_TYPE', p_formula_type_name);
936: hr_utility.raise_error;
937: end if;
938: close formulatypeid;
939: return l_formula_type_id;
940: