DBA Data[Home] [Help]

APPS.WSH_VENDOR_PARTY_MERGE_PKG dependencies on WSH_WV_UTILS

Line 2520: -- AND call WSH_WV_UTILS.delivery_weight_volume

2516: END IF;
2517:
2518: --
2519: --Convert l_dlvy_cache_tbl into a contiguous table l_dlvy_tbl
2520: -- AND call WSH_WV_UTILS.delivery_weight_volume
2521: --l_dlvy_tbl.delete;
2522: l_cache_index := l_delivery_cache_tbl.FIRST ;
2523: WHILE l_cache_index IS NOT NULL
2524: LOOP

Line 2533: WSH_DEBUG_SV.logmsg( l_module_name,'Calling program unit WSH_WV_UTILS.DELIVERY_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL );

2529: END LOOP;
2530:
2531: IF l_debug_on THEN
2532: --{
2533: WSH_DEBUG_SV.logmsg( l_module_name,'Calling program unit WSH_WV_UTILS.DELIVERY_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL );
2534: WSH_DEBUG_SV.log(l_module_name, 'l_dlvy_tbl.COUNT', l_dlvy_tbl.COUNT);
2535: FOR i IN 1..l_dlvy_tbl.COUNT LOOP
2536: wsh_debug_sv.log(l_module_name, 'l_dlvy_tbl(i)', l_dlvy_tbl(i));
2537: END LOOP;

Line 2544: WSH_WV_UTILS.delivery_weight_volume(

2540: END IF;
2541: --
2542: IF l_dlvy_tbl.COUNT > 0 THEN
2543: --{
2544: WSH_WV_UTILS.delivery_weight_volume(
2545: p_del_rows => l_dlvy_tbl,
2546: p_update_flag => 'Y',
2547: p_calc_wv_if_frozen => 'N',
2548: x_return_status => l_return_status

Line 2552: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status from WSH_WV_UTILS.DELIVERY_WEIGHT_VOLUME is ' || l_return_status, WSH_DEBUG_SV.C_PROC_LEVEL);

2548: x_return_status => l_return_status
2549: );
2550: IF l_debug_on THEN
2551: --{
2552: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status from WSH_WV_UTILS.DELIVERY_WEIGHT_VOLUME is ' || l_return_status, WSH_DEBUG_SV.C_PROC_LEVEL);
2553: --}
2554: END IF;
2555:
2556: wsh_util_core.api_post_call(

Line 3117: WSH_WV_UTILS.DD_WV_Post_Process (

3113: THEN
3114: -- {
3115: l_return_status := NULL;
3116:
3117: WSH_WV_UTILS.DD_WV_Post_Process (
3118: p_delivery_detail_id => p_delivery_detail(wvCnt),
3119: p_diff_gross_wt => -1 * p_gross_weight(wvCnt),
3120: p_diff_net_wt => -1 * p_net_weight(wvCnt),
3121: p_diff_volume => -1 * p_volume(wvCnt),

Line 3131: WSH_DEBUG_SV.logmsg(l_module_name,'API WSH_WV_UTILS.DD_WV_Post_Process returned error');

3127: WSH_UTIL_CORE.G_RET_STS_WARNING) )
3128: THEN
3129: --
3130: IF ( l_debug_on ) THEN
3131: WSH_DEBUG_SV.logmsg(l_module_name,'API WSH_WV_UTILS.DD_WV_Post_Process returned error');
3132: END IF;
3133: --
3134: RAISE Weight_Volume_Exp;
3135: END IF;

Line 3148: WSH_WV_UTILS.Del_WV_Post_Process(

3144: FOR wvCnt IN p_delivery_id.FIRST..p_delivery_id.LAST
3145: LOOP
3146: l_return_status := NULL;
3147:
3148: WSH_WV_UTILS.Del_WV_Post_Process(
3149: p_delivery_id => p_delivery_id(wvCnt),
3150: p_diff_gross_wt => -1 * p_gross_weight(wvCnt),
3151: p_diff_net_wt => -1 * p_net_weight(wvCnt),
3152: p_diff_volume => -1 * p_volume(wvCnt),

Line 3162: WSH_DEBUG_SV.logmsg(l_module_name,'API WSH_WV_UTILS.Del_WV_Post_Process returned error');

3158: WSH_UTIL_CORE.G_RET_STS_WARNING) )
3159: THEN
3160: --
3161: IF ( l_debug_on ) THEN
3162: WSH_DEBUG_SV.logmsg(l_module_name,'API WSH_WV_UTILS.Del_WV_Post_Process returned error');
3163: END IF;
3164: --
3165: RAISE Weight_Volume_Exp;
3166: END IF;

Line 3297: WSH_WV_UTILS.Adjust_Parent_WV(

3293: ( p_entity_type = 'CONT' ) ) )
3294: THEN
3295: l_return_status := NULL;
3296:
3297: WSH_WV_UTILS.Adjust_Parent_WV(
3298: p_entity_type => 'CONTAINER',
3299: p_entity_id => p_parent_delivery_detail(wvCnt),
3300: p_gross_weight => 0,
3301: p_net_weight => 0,

Line 3314: WSH_DEBUG_SV.logmsg(l_module_name,'API WSH_WV_UTILS.Adjust_Parent_WV returned error');

3310: WSH_UTIL_CORE.G_RET_STS_WARNING) )
3311: THEN
3312: --
3313: IF ( l_debug_on ) THEN
3314: WSH_DEBUG_SV.logmsg(l_module_name,'API WSH_WV_UTILS.Adjust_Parent_WV returned error');
3315: END IF;
3316: --
3317: RAISE Weight_Volume_Exp;
3318: END IF;