240: open c_get_gre_name(p_tax_unit_id);
241: fetch c_get_gre_name into lv_gre_name;
242: close c_get_gre_name;
243:
244: insert into pay_message_lines
245: (line_sequence, payroll_id, message_level,
246: source_id, source_type, line_text) values
247: (pay_message_lines_s.nextval, NULL, 'F',
248: p_payroll_action_id, 'P',
243:
244: insert into pay_message_lines
245: (line_sequence, payroll_id, message_level,
246: source_id, source_type, line_text) values
247: (pay_message_lines_s.nextval, NULL, 'F',
248: p_payroll_action_id, 'P',
249: 'FEIN is not 9 charcters for GRE: ' || lv_gre_name);
250: end if;
251: