90: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
91: --
92: IF l_debug_on IS NULL
93: THEN
94: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
95: END IF;
96: --
97: IF l_debug_on THEN
98: --
95: END IF;
96: --
97: IF l_debug_on THEN
98: --
99: WSH_DEBUG_SV.push(l_module_name);
100: WSH_DEBUG_SV.log(l_module_name,'p_date',p_date);
101: WSH_DEBUG_SV.log(l_module_name,'p_location_id',p_location_id);
102: --
103: END IF;
96: --
97: IF l_debug_on THEN
98: --
99: WSH_DEBUG_SV.push(l_module_name);
100: WSH_DEBUG_SV.log(l_module_name,'p_date',p_date);
101: WSH_DEBUG_SV.log(l_module_name,'p_location_id',p_location_id);
102: --
103: END IF;
104:
97: IF l_debug_on THEN
98: --
99: WSH_DEBUG_SV.push(l_module_name);
100: WSH_DEBUG_SV.log(l_module_name,'p_date',p_date);
101: WSH_DEBUG_SV.log(l_module_name,'p_location_id',p_location_id);
102: --
103: END IF;
104:
105: x_return_status := wsh_util_core.g_ret_sts_success;
120: END IF;
121:
122: IF l_debug_on THEN
123: --
124: WSH_DEBUG_SV.log(l_module_name,'x_from_time',x_from_time);
125: WSH_DEBUG_SV.log(l_module_name,'x_to_time',x_to_time);
126: WSH_DEBUG_SV.pop(l_module_name);
127: --
128: END IF;
121:
122: IF l_debug_on THEN
123: --
124: WSH_DEBUG_SV.log(l_module_name,'x_from_time',x_from_time);
125: WSH_DEBUG_SV.log(l_module_name,'x_to_time',x_to_time);
126: WSH_DEBUG_SV.pop(l_module_name);
127: --
128: END IF;
129:
122: IF l_debug_on THEN
123: --
124: WSH_DEBUG_SV.log(l_module_name,'x_from_time',x_from_time);
125: WSH_DEBUG_SV.log(l_module_name,'x_to_time',x_to_time);
126: WSH_DEBUG_SV.pop(l_module_name);
127: --
128: END IF;
129:
130: EXCEPTION
132: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
133: wsh_util_core.default_handler('WSH_U_UTIL.Get_Shift_Times',l_module_name);
134: --
135: IF l_debug_on THEN
136: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');
137: END IF;
138:
139:
140: END Get_Shift_Times;