DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_PKG dependencies on APP_EXCEPTION

Line 2148: app_exception.raise_exception;

2144: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
2145: IF l_debug_on THEN
2146: WSH_DEBUG_SV.log(l_module_name,'FORM_RECORD_DELETED');
2147: END IF;
2148: app_exception.raise_exception;
2149: END IF;
2150: CLOSE C_LOCK_DELIVERY_DETAIL;
2151:
2152: if ((recinfo.source_code = p_delivery_details_info.SOURCE_CODE)

Line 3086: app_exception.raise_exception;

3082: --
3083: RETURN;
3084: ELSE
3085: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
3086: app_exception.raise_exception;
3087: END IF;
3088:
3089: --
3090: IF l_debug_on THEN

Line 3095: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN

3091: WSH_DEBUG_SV.pop(l_module_name);
3092: END IF;
3093: --
3094: EXCEPTION
3095: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
3096:
3097: -- Is this necessary? Does PL/SQL automatically close a
3098: -- cursor when it goes out of scope?
3099:

Line 3106: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

3102: end if;
3103:
3104: --
3105: IF l_debug_on THEN
3106: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3107: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');
3108: END IF;
3109: --
3110: RAISE;

Line 3107: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');

3103:
3104: --
3105: IF l_debug_on THEN
3106: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3107: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');
3108: END IF;
3109: --
3110: RAISE;
3111:

Line 4663: app_exception.raise_exception;

4659: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
4660: IF l_debug_on THEN
4661: WSH_DEBUG_SV.log(l_module_name,'FORM RECORD CHANGED');
4662: END IF;
4663: app_exception.raise_exception;
4664:
4665: END IF;
4666:
4667: --

Line 4743: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN

4739: END IF;
4740: --
4741: exception
4742: --
4743: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
4744: rollback to lock_delivery_detail_loop;
4745: IF nvl(p_caller,'!') = 'WSH_PUB'
4746: OR nvl(p_caller, '!') like 'FTE%' THEN
4747: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVB_LOCK_FAILED');

Line 4905: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN

4901: IF l_debug_on THEN
4902: WSH_DEBUG_SV.pop(l_module_name);
4903: END IF;
4904: EXCEPTION
4905: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
4906: IF p_delivery_id IS NOT NULL THEN
4907: l_del_name := wsh_new_deliveries_pvt.get_name(p_delivery_id);
4908: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LINE_LPN_LOCK');
4909: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);

Line 4921: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

4917: END IF;
4918: END IF;
4919:
4920: IF l_debug_on THEN
4921: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4922: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');
4923: END IF;
4924: --
4925: RAISE;

Line 4922: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');

4918: END IF;
4919:
4920: IF l_debug_on THEN
4921: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4922: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');
4923: END IF;
4924: --
4925: RAISE;
4926:

Line 5264: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN

5260: IF l_debug_on THEN
5261: WSH_DEBUG_SV.pop(l_module_name);
5262: END IF;
5263: EXCEPTION
5264: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
5265: IF p_delivery_id IS NOT NULL THEN
5266: l_del_name := wsh_new_deliveries_pvt.get_name(p_delivery_id);
5267: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LINE_LPN_LOCK');
5268: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);

Line 5280: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

5276: END IF;
5277: END IF;
5278:
5279: IF l_debug_on THEN
5280: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5281: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');
5282: END IF;
5283: --
5284: RAISE;

Line 5281: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');

5277: END IF;
5278:
5279: IF l_debug_on THEN
5280: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5281: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');
5282: END IF;
5283: --
5284: RAISE;
5285: