268: IF (c_client_nfn_log%ISOPEN) THEN
269: CLOSE c_client_nfn_log;
270: END IF;
271:
272: fnd_message.set_name ('CSM', 'CSM_CLIENT_NFN_LOG');
273: fnd_message.set_token ('NOTIFICATION_ID', p_record.notification_id);
274: fnd_msg_pub.add;
275: RAISE no_data_found;
276: END IF;
269: CLOSE c_client_nfn_log;
270: END IF;
271:
272: fnd_message.set_name ('CSM', 'CSM_CLIENT_NFN_LOG');
273: fnd_message.set_token ('NOTIFICATION_ID', p_record.notification_id);
274: fnd_msg_pub.add;
275: RAISE no_data_found;
276: END IF;
277: