DBA Data[Home] [Help]

APPS.WSH_FTE_COMP_CONSTRAINT_PKG dependencies on FND_API

Line 147: IF NOT FND_API.Compatible_API_Call

143: l_released_status VARCHAR2(1);
144:
145: BEGIN
146:
147: IF NOT FND_API.Compatible_API_Call
148: ( l_api_version_number,
149: p_api_version_number,
150: l_api_name,
151: G_PKG_NAME

Line 154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

150: l_api_name,
151: G_PKG_NAME
152: )
153: THEN
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: END IF;
156:
157: --
158: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 158: IF FND_API.to_Boolean(p_init_msg_list) THEN

154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: END IF;
156:
157: --
158: IF FND_API.to_Boolean(p_init_msg_list) THEN
159: FND_MSG_PUB.initialize;
160: END IF;
161:
162: --

Line 752: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

748: WSH_DEBUG_SV.log(l_module_name,'x_return_status', x_return_status);
749: WSH_DEBUG_SV.pop(l_module_name);
750: END IF;
751:
752: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
753: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
754: --
755: IF l_debug_on THEN
756: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

753: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
754: --
755: IF l_debug_on THEN
756: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
757: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
758: END IF;
759: --
760: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
761: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

773: wsh_util_core.default_handler('validate_constraint_main');
774: --
775: IF l_debug_on THEN
776: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
777: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
778: END IF;
779: --
780: END validate_constraint_main;
781:

Line 788: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

784: -- For DST (Search trip for a delivery leg) pass the target trip id
785: -- For DCE, pass dleg details
786:
787: PROCEDURE validate_constraint_dleg(
788: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
789: p_action_code IN VARCHAR2,
790: p_delivery_leg_id IN NUMBER DEFAULT NULL,
791: p_delivery_id IN NUMBER,
792: p_sequence_num IN NUMBER DEFAULT NULL,

Line 928: raise FND_API.G_EXC_UNEXPECTED_ERROR;

924: x_return_status => l_return_status);
925:
926: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
927:
928: raise FND_API.G_EXC_UNEXPECTED_ERROR;
929: ELSE
930: x_return_status := l_return_status;
931: END IF;
932:

Line 940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

936: END IF;
937: --
938:
939: EXCEPTION
940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
941: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
942: --
943: IF l_debug_on THEN
944: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

941: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
942: --
943: IF l_debug_on THEN
944: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
945: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
946: END IF;
947: --
948: WHEN others THEN
949: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

949: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
950: --
951: IF l_debug_on THEN
952: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
953: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
954: END IF;
955: --
956:
957: END validate_constraint_dleg;