DBA Data[Home] [Help]

APPS.WSH_TRIP_STOPS_PVT dependencies on APP_EXCEPTION

Line 1054: app_exception.raise_exception;

1050:
1051: IF (lock_row%NOTFOUND) THEN
1052: CLOSE lock_row;
1053: FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');
1054: app_exception.raise_exception;
1055: END IF;
1056:
1057: CLOSE lock_row;
1058:

Line 1286: app_exception.raise_exception;

1282: --
1283: return;
1284: ELSE
1285: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1286: app_exception.raise_exception;
1287: END IF;
1288:
1289: --
1290: -- Debug Statements

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

1293: WSH_DEBUG_SV.pop(l_module_name);
1294: END IF;
1295: --
1296: EXCEPTION
1297: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
1298: if (lock_row%ISOPEN) then
1299: close lock_row;
1300: end if;
1301: --

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

1299: close lock_row;
1300: end if;
1301: --
1302: IF l_debug_on THEN
1303: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1304: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');
1305: END IF;
1306: --
1307: RAISE;

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

1300: end if;
1301: --
1302: IF l_debug_on THEN
1303: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1304: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');
1305: END IF;
1306: --
1307: RAISE;
1308: --

Line 2198: WHEN app_exception.application_exception

2194: WSH_DEBUG_SV.pop(l_module_name);
2195: END IF;
2196:
2197: EXCEPTION
2198: WHEN app_exception.application_exception
2199: OR app_exception.record_lock_exception THEN
2200: IF l_debug_on THEN
2201: wsh_debug_sv.log(l_module_name, 'Could not lock stop', p_stop_id);
2202: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:APPLICTION_EXCEPTION');

Line 2199: OR app_exception.record_lock_exception THEN

2195: END IF;
2196:
2197: EXCEPTION
2198: WHEN app_exception.application_exception
2199: OR app_exception.record_lock_exception THEN
2200: IF l_debug_on THEN
2201: wsh_debug_sv.log(l_module_name, 'Could not lock stop', p_stop_id);
2202: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:APPLICTION_EXCEPTION');
2203: END IF;

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

2272: END IF;
2273: --
2274: exception
2275: --
2276: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
2277: rollback to lock_trip_stop_loop;
2278: IF nvl(p_caller,'!') <> 'WSH_FSTRX' THEN
2279: FND_MESSAGE.SET_NAME('WSH', 'WSH_STOP_LOCK_FAILED');
2280: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',p_rec_attr_tab(l_index).stop_id);