DBA Data[Home] [Help]

APPS.WSH_TRIPS_PVT dependencies on FND_API

Line 1677: IF nvl(p_caller,FND_API.G_MISS_CHAR) <> 'WSH_FSTRX' THEN

1673: ELSE
1674: lock_trip_no_compare(p_rec_attr_tab(l_index).trip_id);
1675: END IF;
1676:
1677: IF nvl(p_caller,FND_API.G_MISS_CHAR) <> 'WSH_FSTRX' THEN
1678: x_valid_ids_tab(x_valid_ids_tab.COUNT + 1) := p_rec_attr_tab(l_index).trip_id;
1679: ELSE
1680: x_valid_ids_tab(x_valid_ids_tab.COUNT + 1) := l_index;
1681: END IF;

Line 1687: IF nvl(p_caller,FND_API.G_MISS_CHAR) = 'WSH_PUB'

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');
1690: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',p_rec_attr_tab(l_index).name);
1691: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);

Line 1701: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1697: WSH_DEBUG_SV.log(l_module_name,'Unable to obtain lock on the Trip Id',p_rec_attr_tab(l_index).trip_id);
1698: END IF;
1699: --
1700: WHEN others THEN
1701: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1702: end;
1703: --
1704: l_index := p_valid_index_tab.NEXT(l_index);
1705: --

Line 1717: RAISE FND_API.G_EXC_ERROR;

1713: wsh_util_core.add_message(x_return_status,l_module_name);
1714: IF l_debug_on THEN
1715: wsh_debug_sv.logmsg(l_module_name, 'WSH_UI_NOT_PERFORMED');
1716: END IF;
1717: RAISE FND_API.G_EXC_ERROR;
1718: ELSIF l_num_errors > 0 THEN
1719: FND_MESSAGE.SET_NAME('WSH', 'WSH_UI_NOT_PROCESSED');
1720: x_return_status := wsh_util_core.g_ret_sts_warning;
1721: wsh_util_core.add_message(x_return_status,l_module_name);

Line 1738: WHEN FND_API.G_EXC_ERROR THEN

1734: --
1735: EXCEPTION
1736: --
1737: --
1738: WHEN FND_API.G_EXC_ERROR THEN
1739: --
1740: x_return_status := wsh_util_core.g_ret_sts_error;
1741: --
1742: IF l_debug_on THEN

Line 1743: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1739: --
1740: x_return_status := wsh_util_core.g_ret_sts_error;
1741: --
1742: IF l_debug_on THEN
1743: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1744: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1745: END IF;
1746: --
1747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1744: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

1740: x_return_status := wsh_util_core.g_ret_sts_error;
1741: --
1742: IF l_debug_on THEN
1743: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1744: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1745: END IF;
1746: --
1747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1748: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

Line 1747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1743: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1744: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1745: END IF;
1746: --
1747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1748: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1749: --
1750: IF l_debug_on THEN
1751: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1752: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

1748: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1749: --
1750: IF l_debug_on THEN
1751: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1752: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1753: END IF;
1754: --
1755: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1756: x_return_status := wsh_util_core.g_ret_sts_warning;