DBA Data[Home] [Help]

APPS.WSH_DLVB_COMMON_ACTIONS dependencies on WSH_DLVB_COMMON_ACTIONS

Line 1: PACKAGE BODY WSH_DLVB_COMMON_ACTIONS as

1: PACKAGE BODY WSH_DLVB_COMMON_ACTIONS as
2: /* $Header: WSHDDCMB.pls 120.1.12010000.2 2009/05/18 13:17:53 selsubra ship $ */
3:
4:
5: /*

Line 29: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_DLVB_COMMON_ACTIONS';

25: */
26:
27:
28: --
29: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_DLVB_COMMON_ACTIONS';
30: --
31: PROCEDURE Assign_Details (
32: p_detail_tab IN WSH_UTIL_CORE.id_tab_type,
33: p_parent_detail_id IN NUMBER,

Line 128: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.SEPARATE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);

124: --
125: -- Debug Statements
126: --
127: IF l_debug_on THEN
128: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.SEPARATE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
129: END IF;
130: --
131: WSH_DLVB_COMMON_ACTIONS.Separate_Details (
132: p_input_tab =>p_detail_tab,

Line 131: WSH_DLVB_COMMON_ACTIONS.Separate_Details (

127: IF l_debug_on THEN
128: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.SEPARATE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
129: END IF;
130: --
131: WSH_DLVB_COMMON_ACTIONS.Separate_Details (
132: p_input_tab =>p_detail_tab,
133: x_cont_inst_tab =>l_cont_tab,
134: x_detail_tab =>l_detail_tab,
135: x_error_tab =>l_error_tab,

Line 576: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Assign_Details');

572: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_RETURN_EXCP');
573: END IF;
574: --
575: WHEN Others THEN
576: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Assign_Details');
577: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
578: IF l_debug_on THEN
579: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
580: END IF;

Line 724: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.SEPARATE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);

720: --
721: -- Debug Statements
722: --
723: IF l_debug_on THEN
724: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.SEPARATE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
725: END IF;
726: --
727: WSH_DLVB_COMMON_ACTIONS.Separate_Details (
728: p_detail_tab,

Line 727: WSH_DLVB_COMMON_ACTIONS.Separate_Details (

723: IF l_debug_on THEN
724: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.SEPARATE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
725: END IF;
726: --
727: WSH_DLVB_COMMON_ACTIONS.Separate_Details (
728: p_detail_tab,
729: l_cont_tab,
730: l_detail_tab,
731: l_error_tab,

Line 930: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Unassign_Details');

926: --
927: -- K LPN CONV. rv
928: --
929: WHEN Others THEN
930: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Unassign_Details');
931: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
932: IF l_debug_on THEN
933: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
934: END IF;

Line 1024: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.UNASSIGN_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);

1020: --
1021: -- Debug Statements
1022: --
1023: IF l_debug_on THEN
1024: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.UNASSIGN_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
1025: END IF;
1026: --
1027: Unassign_Details (
1028: p_detail_tab,

Line 1044: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Unassign_Details',l_module_name);

1040: --
1041: EXCEPTION
1042:
1043: WHEN Others THEN
1044: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Unassign_Details',l_module_name);
1045: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1046: --
1047: -- Debug Statements
1048: --

Line 1146: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.SEPARATE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);

1142:
1143: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1144:
1145: IF l_debug_on THEN
1146: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.SEPARATE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
1147: END IF;
1148: --
1149: WSH_DLVB_COMMON_ACTIONS.Separate_Details (
1150: p_detail_tab,

Line 1149: WSH_DLVB_COMMON_ACTIONS.Separate_Details (

1145: IF l_debug_on THEN
1146: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.SEPARATE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
1147: END IF;
1148: --
1149: WSH_DLVB_COMMON_ACTIONS.Separate_Details (
1150: p_detail_tab,
1151: l_cont_tab,
1152: l_detail_tab,
1153: l_error_tab,

Line 1441: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Auto_Pack_Lines');

1437: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:MARK_REPRICE_ERROR');
1438: END IF;
1439: --
1440: WHEN Others THEN
1441: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Auto_Pack_Lines');
1442: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1443: IF l_debug_on THEN
1444: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1445: END IF;

Line 1637: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Separate_Details');

1633: --
1634: EXCEPTION
1635:
1636: WHEN Others THEN
1637: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Separate_Details');
1638: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1639:
1640: --
1641: -- Debug Statements

Line 2018: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Calc_Cont_Avail');

2014: --
2015: EXCEPTION
2016:
2017: WHEN Others THEN
2018: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Calc_Cont_Avail');
2019: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2020:
2021: --
2022: -- Debug Statements

Line 2264: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Calc_Item_Total');

2260: --
2261: EXCEPTION
2262:
2263: WHEN Others THEN
2264: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Calc_Item_Total');
2265: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2266:
2267: --
2268: -- Debug Statements

Line 2383: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.SEPARATE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);

2379: --
2380: -- Debug Statements
2381: --
2382: IF l_debug_on THEN
2383: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.SEPARATE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
2384: END IF;
2385: --
2386: WSH_DLVB_COMMON_ACTIONS.Separate_Details (
2387: p_detail_input_tab,

Line 2386: WSH_DLVB_COMMON_ACTIONS.Separate_Details (

2382: IF l_debug_on THEN
2383: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.SEPARATE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
2384: END IF;
2385: --
2386: WSH_DLVB_COMMON_ACTIONS.Separate_Details (
2387: p_detail_input_tab,
2388: l_cont_tab,
2389: l_detail_tab,
2390: l_error_tab,

Line 2416: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.CALC_CONT_AVAIL',WSH_DEBUG_SV.C_PROC_LEVEL);

2412: --
2413: -- Debug Statements
2414: --
2415: IF l_debug_on THEN
2416: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.CALC_CONT_AVAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
2417: END IF;
2418: --
2419: WSH_DLVB_COMMON_ACTIONS.Calc_Cont_Avail (
2420: l_cont_tab(i),

Line 2419: WSH_DLVB_COMMON_ACTIONS.Calc_Cont_Avail (

2415: IF l_debug_on THEN
2416: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.CALC_CONT_AVAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
2417: END IF;
2418: --
2419: WSH_DLVB_COMMON_ACTIONS.Calc_Cont_Avail (
2420: l_cont_tab(i),
2421: l_avail_wt,
2422: l_avail_vol,
2423: l_wt_uom,

Line 2447: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.CALC_ITEM_TOTAL',WSH_DEBUG_SV.C_PROC_LEVEL);

2443: --
2444: -- Debug Statements
2445: --
2446: IF l_debug_on THEN
2447: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.CALC_ITEM_TOTAL',WSH_DEBUG_SV.C_PROC_LEVEL);
2448: END IF;
2449: --
2450: WSH_DLVB_COMMON_ACTIONS.Calc_Item_Total (
2451: l_detail_tab(i),

Line 2450: WSH_DLVB_COMMON_ACTIONS.Calc_Item_Total (

2446: IF l_debug_on THEN
2447: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.CALC_ITEM_TOTAL',WSH_DEBUG_SV.C_PROC_LEVEL);
2448: END IF;
2449: --
2450: WSH_DLVB_COMMON_ACTIONS.Calc_Item_Total (
2451: l_detail_tab(i),
2452: l_item_wt_total,
2453: l_item_vol_total,
2454: l_wt_uom,

Line 2563: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Calculate_Total_Capacities');

2559: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_RETURN_EXCP');
2560: END IF;
2561: --
2562: WHEN Others THEN
2563: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Calculate_Total_Capacities');
2564: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2565: IF l_debug_on THEN
2566: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2567: END IF;

Line 2607: END WSH_DLVB_COMMON_ACTIONS;

2603: --
2604: END Calculate_Total_Capacities;
2605:
2606:
2607: END WSH_DLVB_COMMON_ACTIONS;