202:
203: exception
204: when DUP_VAL_ON_INDEX then
205: fnd_message.set_name('OE', 'WSH_TMPL_DUP_VAL');
206: app_exception.raise_exception;
207:
208: when app_exception.record_lock_exception then
209: fnd_message.set_name('OE', 'WSH_NO_LOCK');
210: app_exception.raise_exception;
204: when DUP_VAL_ON_INDEX then
205: fnd_message.set_name('OE', 'WSH_TMPL_DUP_VAL');
206: app_exception.raise_exception;
207:
208: when app_exception.record_lock_exception then
209: fnd_message.set_name('OE', 'WSH_NO_LOCK');
210: app_exception.raise_exception;
211:
212: end insert_row;
206: app_exception.raise_exception;
207:
208: when app_exception.record_lock_exception then
209: fnd_message.set_name('OE', 'WSH_NO_LOCK');
210: app_exception.raise_exception;
211:
212: end insert_row;
213:
214:
302: if (lock_record%NOTFOUND) then
303: close lock_record;
304:
305: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
306: app_exception.raise_exception;
307:
308: end if;
309:
310: close lock_record;
575:
576: else
577:
578: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
579: app_exception.raise_exception;
580:
581: end if;
582:
583: end lock_row;
737:
738: exception
739: when DUP_VAL_ON_INDEX then
740: fnd_message.set_name('OE', 'WSH_TMPL_DUP_VAL');
741: app_exception.raise_exception;
742:
743: when app_exception.record_lock_exception then
744: fnd_message.set_name('OE', 'WSH_NO_LOCK');
745: app_exception.raise_exception;
739: when DUP_VAL_ON_INDEX then
740: fnd_message.set_name('OE', 'WSH_TMPL_DUP_VAL');
741: app_exception.raise_exception;
742:
743: when app_exception.record_lock_exception then
744: fnd_message.set_name('OE', 'WSH_NO_LOCK');
745: app_exception.raise_exception;
746:
747: end update_row;
741: app_exception.raise_exception;
742:
743: when app_exception.record_lock_exception then
744: fnd_message.set_name('OE', 'WSH_NO_LOCK');
745: app_exception.raise_exception;
746:
747: end update_row;
748:
749: