242:
243: WSH_DEBUG_SV.log(l_module_name,'FORM_RECORD_DELETED');
244:
245: END IF;
246: app_exception.raise_exception;
247: END IF;
248: CLOSE C_Lock_Row;
249:
250: IF
322: --
323: RETURN;
324: ELSE
325: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
326: app_exception.raise_exception;
327: END IF;
328: --
329: IF l_debug_on THEN
330: WSH_DEBUG_SV.pop(l_module_name);
330: WSH_DEBUG_SV.pop(l_module_name);
331: END IF;
332: --
333: EXCEPTION
334: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
335:
336: if (c_lock_row%ISOPEN) then
337: close c_lock_row;
338: end if;
339:
340:
341: --
342: IF l_debug_on THEN
343: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
344: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');
345: END IF;
346: --
347: RAISE;
340:
341: --
342: IF l_debug_on THEN
343: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
344: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');
345: END IF;
346: --
347: RAISE;
348: