DBA Data[Home] [Help]

APPS.WSH_DELIVERY_AUTOCREATE dependencies on FND_API

Line 1203: RAISE fnd_api.g_exc_error;

1199: x_empty_flag => l_empty_container,
1200: x_return_status => x_return_status);
1201:
1202: IF x_return_status <> wsh_util_core.g_ret_sts_success THEN
1203: RAISE fnd_api.g_exc_error;
1204: END IF;
1205:
1206: IF l_debug_on THEN
1207: wsh_debug_sv.log(l_module_name, 'l_empty_container', l_empty_container);

Line 1468: WHEN fnd_api.g_exc_error THEN

1464: WSH_DEBUG_SV.pop(l_module_name);
1465: END IF;
1466:
1467: EXCEPTION
1468: WHEN fnd_api.g_exc_error THEN
1469: x_return_status := fnd_api.g_ret_sts_error;
1470: --
1471: IF l_debug_on THEN
1472: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');

Line 1469: x_return_status := fnd_api.g_ret_sts_error;

1465: END IF;
1466:
1467: EXCEPTION
1468: WHEN fnd_api.g_exc_error THEN
1469: x_return_status := fnd_api.g_ret_sts_error;
1470: --
1471: IF l_debug_on THEN
1472: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
1473: END IF;

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

1468: WHEN fnd_api.g_exc_error THEN
1469: x_return_status := fnd_api.g_ret_sts_error;
1470: --
1471: IF l_debug_on THEN
1472: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
1473: END IF;
1474: --
1475: WHEN DELIVERY_NOT_MATCH THEN
1476: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 2495: p_init_msg_list => FND_API.G_FALSE,

2491: l_in_param_rec.seq_tender_flag := 'Y'; -- R12 Select Carrier
2492:
2493: WSH_FTE_INTEGRATION.Rate_Delivery(
2494: p_api_version => 1.0,
2495: p_init_msg_list => FND_API.G_FALSE,
2496: p_commit => FND_API.G_FALSE,
2497: p_in_param_rec => l_in_param_rec,
2498: x_out_param_rec => l_out_param_rec,
2499: x_return_status => l_return_status,

Line 2496: p_commit => FND_API.G_FALSE,

2492:
2493: WSH_FTE_INTEGRATION.Rate_Delivery(
2494: p_api_version => 1.0,
2495: p_init_msg_list => FND_API.G_FALSE,
2496: p_commit => FND_API.G_FALSE,
2497: p_in_param_rec => l_in_param_rec,
2498: x_out_param_rec => l_out_param_rec,
2499: x_return_status => l_return_status,
2500: x_msg_count => l_msg_count,

Line 3678: WHEN FND_API.G_EXC_ERROR THEN

3674: WSH_DEBUG_SV.pop(l_module_name);
3675: END IF;
3676: --
3677: EXCEPTION
3678: WHEN FND_API.G_EXC_ERROR THEN
3679: --
3680: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3681: --
3682: IF l_debug_on THEN

Line 3683: 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);

3679: --
3680: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3681: --
3682: IF l_debug_on THEN
3683: 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);
3684: END IF;
3685: --
3686: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
3687: THEN

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

3708: --
3709: -- LPN CONV. rv
3710: --
3711: IF l_debug_on THEN
3712: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3713: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3714: END IF;
3715: --
3716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3709: -- LPN CONV. rv
3710: --
3711: IF l_debug_on THEN
3712: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3713: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3714: END IF;
3715: --
3716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3717: --

Line 3716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3712: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3713: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3714: END IF;
3715: --
3716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3717: --
3718: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3719: --
3720: IF l_debug_on THEN

Line 3721: 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);

3717: --
3718: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3719: --
3720: IF l_debug_on THEN
3721: 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);
3722: END IF;
3723: --
3724: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
3725: THEN

Line 3752: 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);

3748: --
3749: -- LPN CONV. rv
3750: --
3751: IF l_debug_on THEN
3752: 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);
3753: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3754: END IF;
3755: --
3756: WHEN OTHERS THEN

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

3749: -- LPN CONV. rv
3750: --
3751: IF l_debug_on THEN
3752: 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);
3753: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3754: END IF;
3755: --
3756: WHEN OTHERS THEN
3757: --

Line 3982: p_init_msg_list => fnd_api.g_false,

3978: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_FTE_COMP_CONSTRAINT_GRP.is_valid_consol',WSH_DEBUG_SV.C_PROC_LEVEL);
3979: END IF;
3980:
3981: WSH_FTE_COMP_CONSTRAINT_GRP.is_valid_consol(
3982: p_init_msg_list => fnd_api.g_false,
3983: p_input_delivery_id_tab => l_del_tab,
3984: p_target_consol_delivery_id => NULL,
3985: x_deconsolidation_location => l_intermediate_loc_id,
3986: x_return_status => l_return_status,

Line 4323: WHEN FND_API.G_EXC_ERROR THEN

4319: IF l_debug_on THEN
4320: wsh_debug_sv.pop(l_module_name);
4321: END IF;
4322: EXCEPTION
4323: WHEN FND_API.G_EXC_ERROR THEN
4324: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4325: --
4326: -- Debug Statements
4327: --

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

4325: --
4326: -- Debug Statements
4327: --
4328: IF l_debug_on THEN
4329: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4330: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4331: END IF;
4332: --
4333: WHEN WSH_INVALID_TRIPS THEN

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

4326: -- Debug Statements
4327: --
4328: IF l_debug_on THEN
4329: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4330: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4331: END IF;
4332: --
4333: WHEN WSH_INVALID_TRIPS THEN
4334: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;