APPS.WSH_TRIPS_PVT dependencies on APP_EXCEPTION

Line 1139: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:app_exception');

1135: CLOSE lock_row;
1136: FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');
1137: IF l_debug_on THEN
1138: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1139: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:app_exception');
1140: END IF;
1141: app_exception.raise_exception;
1142: END IF;
1143:

Line 1141: app_exception.raise_exception;

1137: IF l_debug_on THEN
1138: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1139: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:app_exception');
1140: END IF;
1141: app_exception.raise_exception;
1142: END IF;
1143:
1144: CLOSE lock_row;
1145:

Line 1322: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:app_exception');

1318: ELSE
1319: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1320: IF l_debug_on THEN
1321: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1322: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:app_exception');
1323: END IF;
1324: app_exception.raise_exception;
1325: END IF;
1326:

Line 1324: app_exception.raise_exception;

1320: IF l_debug_on THEN
1321: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1322: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:app_exception');
1323: END IF;
1324: app_exception.raise_exception;
1325: END IF;
1326:
1327: --
1328: -- Debug Statements

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

1331: WSH_DEBUG_SV.pop(l_module_name);
1332: END IF;
1333: --
1334: EXCEPTION
1335: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
1336: if (lock_row%ISOPEN) then
1337: close lock_row;
1338: end if;
1339: --

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

1337: close lock_row;
1338: end if;
1339: --
1340: IF l_debug_on THEN
1341: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1342: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');
1343: END IF;
1344: --
1345: RAISE;

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

1338: end if;
1339: --
1340: IF l_debug_on THEN
1341: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1342: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');
1343: END IF;
1344: --
1345: RAISE;
1346: --

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

1681: END IF;
1682: --
1683: exception
1684: --
1685: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
1686: rollback to lock_trip_loop;
1687: IF nvl(p_caller,FND_API.G_MISS_CHAR) = 'WSH_PUB'
1688: OR nvl(p_caller, '!') like 'FTE%' THEN
1689: FND_MESSAGE.SET_NAME('WSH', 'WSH_TRIP_LOCK_FAILED');

Line 1817: WHEN app_exception.application_exception

1813: WSH_DEBUG_SV.pop(l_module_name);
1814: END IF;
1815:
1816: EXCEPTION
1817: WHEN app_exception.application_exception
1818: OR app_exception.record_lock_exception THEN
1819: IF l_debug_on THEN
1820: wsh_debug_sv.log(l_module_name, 'Could not lock trip', p_trip_id);
1821: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:APPLICTION_EXCEPTION');

Line 1818: OR app_exception.record_lock_exception THEN

1814: END IF;
1815:
1816: EXCEPTION
1817: WHEN app_exception.application_exception
1818: OR app_exception.record_lock_exception THEN
1819: IF l_debug_on THEN
1820: wsh_debug_sv.log(l_module_name, 'Could not lock trip', p_trip_id);
1821: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:APPLICTION_EXCEPTION');
1822: END IF;