Line 294: dbms_lob.writeappend(v_notes, length(v_ack_phrase),
290: from fnd_exception_notes
291: where unique_exception_id = to_number(v_curr_id)
292: for update;
293: 294: dbms_lob.writeappend(v_notes, length(v_ack_phrase), 295: v_ack_phrase);
296: exception
297: when no_data_found then
298: insert into fnd_exception_notes (