222: WSH_DEBUG_SV.logmsg(l_module_name,'DUP_VAL_ON_INDEX exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
223: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DUP_VAL_ON_INDEX');
224: END IF;
225: --
226: app_exception.raise_exception;
227: when app_exception.record_lock_exception then
228: fnd_message.set_name('OE', 'WSH_NO_LOCK');
229: --
230: IF l_debug_on THEN
223: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DUP_VAL_ON_INDEX');
224: END IF;
225: --
226: app_exception.raise_exception;
227: when app_exception.record_lock_exception then
228: fnd_message.set_name('OE', 'WSH_NO_LOCK');
229: --
230: IF l_debug_on THEN
231: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.RECORD_LOCK_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
227: when app_exception.record_lock_exception then
228: fnd_message.set_name('OE', 'WSH_NO_LOCK');
229: --
230: IF l_debug_on THEN
231: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.RECORD_LOCK_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
232: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.RECORD_LOCK_EXCEPTION');
233: END IF;
234: --
235: app_exception.raise_exception;
228: fnd_message.set_name('OE', 'WSH_NO_LOCK');
229: --
230: IF l_debug_on THEN
231: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.RECORD_LOCK_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
232: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.RECORD_LOCK_EXCEPTION');
233: END IF;
234: --
235: app_exception.raise_exception;
236: end insert_row;
231: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.RECORD_LOCK_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
232: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.RECORD_LOCK_EXCEPTION');
233: END IF;
234: --
235: app_exception.raise_exception;
236: end insert_row;
237:
238:
239: -- ===========================================================================
338: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
339: IF l_debug_on THEN
340: WSH_DEBUG_SV.pop(l_module_name,'FORM_RECORD_DELETED');
341: END IF;
342: app_exception.raise_exception;
343:
344: end if;
345:
346: close lock_record;
483: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
484: IF l_debug_on THEN
485: WSH_DEBUG_SV.pop(l_module_name,'FORM_RECORD_CHANGED');
486: END IF;
487: app_exception.raise_exception;
488:
489: end if;
490:
491: for tlinfo in c1 loop
503: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
504: IF l_debug_on THEN
505: WSH_DEBUG_SV.pop(l_module_name,'FORM_RECORD_CHANGED');
506: END IF;
507: app_exception.raise_exception;
508: end if;
509: end if;
510: end loop;
511: --
661: WSH_DEBUG_SV.logmsg(l_module_name,'DUP_VAL_ON_INDEX exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
662: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DUP_VAL_ON_INDEX');
663: END IF;
664: --
665: app_exception.raise_exception;
666: when app_exception.record_lock_exception then
667: fnd_message.set_name('OE', 'WSH_NO_LOCK');
668: --
669: IF l_debug_on THEN
662: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DUP_VAL_ON_INDEX');
663: END IF;
664: --
665: app_exception.raise_exception;
666: when app_exception.record_lock_exception then
667: fnd_message.set_name('OE', 'WSH_NO_LOCK');
668: --
669: IF l_debug_on THEN
670: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.RECORD_LOCK_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
666: when app_exception.record_lock_exception then
667: fnd_message.set_name('OE', 'WSH_NO_LOCK');
668: --
669: IF l_debug_on THEN
670: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.RECORD_LOCK_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
671: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.RECORD_LOCK_EXCEPTION');
672: END IF;
673: --
674: app_exception.raise_exception;
667: fnd_message.set_name('OE', 'WSH_NO_LOCK');
668: --
669: IF l_debug_on THEN
670: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.RECORD_LOCK_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
671: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.RECORD_LOCK_EXCEPTION');
672: END IF;
673: --
674: app_exception.raise_exception;
675: end update_row;
670: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.RECORD_LOCK_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
671: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.RECORD_LOCK_EXCEPTION');
672: END IF;
673: --
674: app_exception.raise_exception;
675: end update_row;
676:
677:
678: -- ===========================================================================