Line 49: fnd_message.set_name('AK', 'AK_NEW_REGION_ALREADY_EXISTS');
45: b_success := r_csr%found;
46: close r_csr;
47: -- ak_regions is a parent table. If you can't find a record, exit with an error message.
48: if (not b_success) then 49: fnd_message.set_name('AK', 'AK_NEW_REGION_ALREADY_EXISTS'); 50: app_exception.raise_exception;
51: end if;
52: -- Put new code and id into record and insert into appropriate table
53: r_rec.region_code := p_n_code;