231: open c_get_gre_name(p_tax_unit_id);
232: fetch c_get_gre_name into lv_gre_name;
233: close c_get_gre_name;
234:
235: insert into pay_message_lines
236: (line_sequence, payroll_id, message_level,
237: source_id, source_type, line_text) values
238: (pay_message_lines_s.nextval, NULL, 'F',
239: p_payroll_action_id, 'P',
234:
235: insert into pay_message_lines
236: (line_sequence, payroll_id, message_level,
237: source_id, source_type, line_text) values
238: (pay_message_lines_s.nextval, NULL, 'F',
239: p_payroll_action_id, 'P',
240: 'FEIN is not 9 charcters for GRE: ' || lv_gre_name);
241: end if;
242: