1555: FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');
1556: IF l_debug_on THEN
1557: WSH_DEBUG_SV.log(l_module_name,'FORM_RECORD_DELETED');
1558: END IF;
1559: app_exception.raise_exception;
1560: END IF;
1561:
1562: CLOSE lock_row;
1563:
1989: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1990: IF l_debug_on THEN
1991: WSH_DEBUG_SV.log(l_module_name,'FORM_RECORD_CHANGED');
1992: END IF;
1993: app_exception.raise_exception;
1994: END IF;
1995: --
1996: IF l_debug_on THEN
1997: WSH_DEBUG_SV.pop(l_module_name);
1997: WSH_DEBUG_SV.pop(l_module_name);
1998: END IF;
1999: --
2000: EXCEPTION
2001: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
2002: if (lock_row%ISOPEN) then
2003: close lock_row;
2004: end if;
2005: --
2003: close lock_row;
2004: end if;
2005: --
2006: IF l_debug_on THEN
2007: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2008: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');
2009: END IF;
2010: --
2011: RAISE;
2004: end if;
2005: --
2006: IF l_debug_on THEN
2007: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2008: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');
2009: END IF;
2010: --
2011: RAISE;
2012: --
2447: END IF;
2448: --
2449: exception
2450: --
2451: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
2452: rollback to lock_delivery_loop;
2453: IF nvl(p_caller,FND_API.G_MISS_CHAR) = 'WSH_PUB'
2454: OR nvl(p_caller, '!') like 'FTE%'
2455: OR nvl(p_caller, '!') = 'WSH_TRCON' THEN
2599: WSH_DEBUG_SV.pop(l_module_name);
2600: END IF;
2601:
2602: EXCEPTION
2603: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
2604: IF l_debug_on THEN
2605: wsh_debug_sv.log(l_module_name, 'Could not lock delivery', p_delivery_id);
2606: END IF;
2607: IF l_debug_on THEN
2604: IF l_debug_on THEN
2605: wsh_debug_sv.log(l_module_name, 'Could not lock delivery', p_delivery_id);
2606: END IF;
2607: IF l_debug_on THEN
2608: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2609: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');
2610: END IF;
2611: --
2612: RAISE;
2605: wsh_debug_sv.log(l_module_name, 'Could not lock delivery', p_delivery_id);
2606: END IF;
2607: IF l_debug_on THEN
2608: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2609: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');
2610: END IF;
2611: --
2612: RAISE;
2613: