DBA Data[Home] [Help]

APPS.WSH_DELIVERY_AUTOCREATE dependencies on FND_API

Line 1374: RAISE fnd_api.g_exc_error;

1370: x_empty_flag => l_empty_container,
1371: x_return_status => x_return_status);
1372:
1373: IF x_return_status <> wsh_util_core.g_ret_sts_success THEN
1374: RAISE fnd_api.g_exc_error;
1375: END IF;
1376:
1377: IF l_debug_on THEN
1378: wsh_debug_sv.log(l_module_name, 'l_empty_container', l_empty_container);

Line 1698: WHEN fnd_api.g_exc_error THEN

1694: WSH_DEBUG_SV.pop(l_module_name);
1695: END IF;
1696:
1697: EXCEPTION
1698: WHEN fnd_api.g_exc_error THEN
1699: x_return_status := fnd_api.g_ret_sts_error;
1700: --
1701: IF l_debug_on THEN
1702: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');

Line 1699: x_return_status := fnd_api.g_ret_sts_error;

1695: END IF;
1696:
1697: EXCEPTION
1698: WHEN fnd_api.g_exc_error THEN
1699: x_return_status := fnd_api.g_ret_sts_error;
1700: --
1701: IF l_debug_on THEN
1702: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
1703: END IF;

Line 1702: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');

1698: WHEN fnd_api.g_exc_error THEN
1699: x_return_status := fnd_api.g_ret_sts_error;
1700: --
1701: IF l_debug_on THEN
1702: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
1703: END IF;
1704: --
1705: WHEN DELIVERY_NOT_MATCH THEN
1706: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 2745: p_init_msg_list => FND_API.G_FALSE,

2741: l_in_param_rec.seq_tender_flag := 'Y'; -- R12 Select Carrier
2742:
2743: WSH_FTE_INTEGRATION.Rate_Delivery(
2744: p_api_version => 1.0,
2745: p_init_msg_list => FND_API.G_FALSE,
2746: p_commit => FND_API.G_FALSE,
2747: p_in_param_rec => l_in_param_rec,
2748: x_out_param_rec => l_out_param_rec,
2749: x_return_status => l_return_status,

Line 2746: p_commit => FND_API.G_FALSE,

2742:
2743: WSH_FTE_INTEGRATION.Rate_Delivery(
2744: p_api_version => 1.0,
2745: p_init_msg_list => FND_API.G_FALSE,
2746: p_commit => FND_API.G_FALSE,
2747: p_in_param_rec => l_in_param_rec,
2748: x_out_param_rec => l_out_param_rec,
2749: x_return_status => l_return_status,
2750: x_msg_count => l_msg_count,

Line 3937: WHEN FND_API.G_EXC_ERROR THEN

3933: WSH_DEBUG_SV.pop(l_module_name);
3934: END IF;
3935: --
3936: EXCEPTION
3937: WHEN FND_API.G_EXC_ERROR THEN
3938: --
3939: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3940: --
3941: IF l_debug_on THEN

Line 3942: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS FROM FND_API.G_EXC_ERROR',WSH_DEBUG_SV.C_PROC_LEVEL);

3938: --
3939: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3940: --
3941: IF l_debug_on THEN
3942: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS FROM FND_API.G_EXC_ERROR',WSH_DEBUG_SV.C_PROC_LEVEL);
3943: END IF;
3944: --
3945: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
3946: THEN

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

3967: --
3968: -- LPN CONV. rv
3969: --
3970: IF l_debug_on THEN
3971: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3972: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3973: END IF;
3974: --
3975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3968: -- LPN CONV. rv
3969: --
3970: IF l_debug_on THEN
3971: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3972: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3973: END IF;
3974: --
3975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3976: --

Line 3975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3971: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3972: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3973: END IF;
3974: --
3975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3976: --
3977: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3978: --
3979: IF l_debug_on THEN

Line 3980: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS FROM FND_API.G_EXC_UNEXPECTED_ERROR',WSH_DEBUG_SV.C_PROC_LEVEL);

3976: --
3977: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3978: --
3979: IF l_debug_on THEN
3980: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS FROM FND_API.G_EXC_UNEXPECTED_ERROR',WSH_DEBUG_SV.C_PROC_LEVEL);
3981: END IF;
3982: --
3983: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
3984: THEN

Line 4011: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

4007: --
4008: -- LPN CONV. rv
4009: --
4010: IF l_debug_on THEN
4011: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4012: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4013: END IF;
4014: --
4015: WHEN OTHERS THEN

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

4008: -- LPN CONV. rv
4009: --
4010: IF l_debug_on THEN
4011: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4012: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4013: END IF;
4014: --
4015: WHEN OTHERS THEN
4016: --

Line 4241: p_init_msg_list => fnd_api.g_false,

4237: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_FTE_COMP_CONSTRAINT_GRP.is_valid_consol',WSH_DEBUG_SV.C_PROC_LEVEL);
4238: END IF;
4239:
4240: WSH_FTE_COMP_CONSTRAINT_GRP.is_valid_consol(
4241: p_init_msg_list => fnd_api.g_false,
4242: p_input_delivery_id_tab => l_del_tab,
4243: p_target_consol_delivery_id => NULL,
4244: x_deconsolidation_location => l_intermediate_loc_id,
4245: x_return_status => l_return_status,

Line 4582: WHEN FND_API.G_EXC_ERROR THEN

4578: IF l_debug_on THEN
4579: wsh_debug_sv.pop(l_module_name);
4580: END IF;
4581: EXCEPTION
4582: WHEN FND_API.G_EXC_ERROR THEN
4583: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4584: --
4585: -- Debug Statements
4586: --

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

4584: --
4585: -- Debug Statements
4586: --
4587: IF l_debug_on THEN
4588: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4589: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4590: END IF;
4591: --
4592: WHEN WSH_INVALID_TRIPS THEN

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

4585: -- Debug Statements
4586: --
4587: IF l_debug_on THEN
4588: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4589: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4590: END IF;
4591: --
4592: WHEN WSH_INVALID_TRIPS THEN
4593: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;