153:
154: WHEN OTHERS
155: THEN
156: ROLLBACK TO purge_notes;
157: fnd_message.set_name ('JTF', 'CAC_NOTE_UNKNOWN_ERROR');
158: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
159: fnd_msg_pub.add;
160:
161: x_return_status := fnd_api.g_ret_sts_unexp_error;
154: WHEN OTHERS
155: THEN
156: ROLLBACK TO purge_notes;
157: fnd_message.set_name ('JTF', 'CAC_NOTE_UNKNOWN_ERROR');
158: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
159: fnd_msg_pub.add;
160:
161: x_return_status := fnd_api.g_ret_sts_unexp_error;
162: fnd_msg_pub.count_and_get (