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 2005/07/28 18:36:01 sperera noship $ */
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 574: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Assign_Details');

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

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

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

Line 725: WSH_DLVB_COMMON_ACTIONS.Separate_Details (

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

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

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

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

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

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

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

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

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

Line 1147: WSH_DLVB_COMMON_ACTIONS.Separate_Details (

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

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

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

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

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

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

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

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

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

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

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

Line 2384: WSH_DLVB_COMMON_ACTIONS.Separate_Details (

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

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

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

Line 2417: WSH_DLVB_COMMON_ACTIONS.Calc_Cont_Avail (

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

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

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

Line 2448: WSH_DLVB_COMMON_ACTIONS.Calc_Item_Total (

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

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

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

Line 2605: END WSH_DLVB_COMMON_ACTIONS;

2601: --
2602: END Calculate_Total_Capacities;
2603:
2604:
2605: END WSH_DLVB_COMMON_ACTIONS;