DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_PKG dependencies on APP_EXCEPTION

Line 2283: app_exception.raise_exception;

2279: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
2280: IF l_debug_on THEN
2281: WSH_DEBUG_SV.log(l_module_name,'FORM_RECORD_DELETED');
2282: END IF;
2283: app_exception.raise_exception;
2284: END IF;
2285: CLOSE C_LOCK_DELIVERY_DETAIL;
2286:
2287: if ((recinfo.source_code = p_delivery_details_info.SOURCE_CODE)

Line 3221: app_exception.raise_exception;

3217: --
3218: RETURN;
3219: ELSE
3220: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
3221: app_exception.raise_exception;
3222: END IF;
3223:
3224: --
3225: IF l_debug_on THEN

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

3226: WSH_DEBUG_SV.pop(l_module_name);
3227: END IF;
3228: --
3229: EXCEPTION
3230: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
3231:
3232: -- Is this necessary? Does PL/SQL automatically close a
3233: -- cursor when it goes out of scope?
3234:

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

3237: end if;
3238:
3239: --
3240: IF l_debug_on THEN
3241: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3242: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');
3243: END IF;
3244: --
3245: RAISE;

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

3238:
3239: --
3240: IF l_debug_on THEN
3241: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3242: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');
3243: END IF;
3244: --
3245: RAISE;
3246:

Line 4798: app_exception.raise_exception;

4794: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
4795: IF l_debug_on THEN
4796: WSH_DEBUG_SV.log(l_module_name,'FORM RECORD CHANGED');
4797: END IF;
4798: app_exception.raise_exception;
4799:
4800: END IF;
4801:
4802: --

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

4874: END IF;
4875: --
4876: exception
4877: --
4878: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
4879: rollback to lock_delivery_detail_loop;
4880: IF nvl(p_caller,'!') = 'WSH_PUB'
4881: OR nvl(p_caller, '!') like 'FTE%' THEN
4882: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVB_LOCK_FAILED');

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

5036: IF l_debug_on THEN
5037: WSH_DEBUG_SV.pop(l_module_name);
5038: END IF;
5039: EXCEPTION
5040: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
5041: IF p_delivery_id IS NOT NULL THEN
5042: l_del_name := wsh_new_deliveries_pvt.get_name(p_delivery_id);
5043: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LINE_LPN_LOCK');
5044: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);

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

5052: END IF;
5053: END IF;
5054:
5055: IF l_debug_on THEN
5056: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5057: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');
5058: END IF;
5059: --
5060: RAISE;

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

5053: END IF;
5054:
5055: IF l_debug_on THEN
5056: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5057: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');
5058: END IF;
5059: --
5060: RAISE;
5061:

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

5412: IF l_debug_on THEN
5413: WSH_DEBUG_SV.pop(l_module_name);
5414: END IF;
5415: EXCEPTION
5416: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
5417: IF p_delivery_id IS NOT NULL THEN
5418: l_del_name := wsh_new_deliveries_pvt.get_name(p_delivery_id);
5419: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LINE_LPN_LOCK');
5420: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);

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

5428: END IF;
5429: END IF;
5430:
5431: IF l_debug_on THEN
5432: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5433: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');
5434: END IF;
5435: --
5436: RAISE;

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

5429: END IF;
5430:
5431: IF l_debug_on THEN
5432: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5433: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');
5434: END IF;
5435: --
5436: RAISE;
5437: