[Home] [Help]
178: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
179: WSH_DEBUG_SV.log(l_module_name,'P_CLIENT_ID',P_CLIENT_ID); -- LSP PROJECT
180: END IF;
181: --
182: x_return_status := FND_API.G_RET_STS_SUCCESS;
183: --
184: -- Search table if it has any values
185:
186: IF g_parameters.count <> 0 THEN
376: WHEN NO_DATA_FOUND THEN
377: IF c_get_param%ISOPEN THEN
378: CLOSE c_get_param;
379: END IF;
380: x_return_status := FND_API.G_RET_STS_ERROR;
381: --
382: -- Debug Statements
383: --
384: IF l_debug_on THEN
393: FND_MESSAGE.Set_Token('ORA_TEXT','');
394: IF c_get_param%ISOPEN THEN
395: CLOSE c_get_param;
396: END IF;
397: x_return_status := FND_API.G_RET_STS_ERROR;
398:
399: --
400: -- Debug Statements
401: --
508: IF l_debug_on THEN
509: WSH_DEBUG_SV.push(l_module_name);
510: END IF;
511: --
512: x_return_status := FND_API.G_RET_STS_SUCCESS;
513:
514: -- Search table if it has global parameters already populated.
515:
516: IF g_global_parameters.count <> 0 THEN
690: WHEN NO_DATA_FOUND THEN
691: IF c_get_global_param%ISOPEN THEN
692: CLOSE c_get_global_param;
693: END IF;
694: x_return_status := FND_API.G_RET_STS_ERROR;
695: --
696: -- Debug Statements
697: --
698: IF l_debug_on THEN
707: FND_MESSAGE.Set_Token('ORA_TEXT','');
708: IF c_get_global_param%ISOPEN THEN
709: CLOSE c_get_global_param;
710: END IF;
711: x_return_status := FND_API.G_RET_STS_ERROR;
712:
713: --
714: -- Debug Statements
715: --
1869:
1870: others exception;
1871:
1872: Begin
1873: x_return_status := FND_API.G_RET_STS_SUCCESS;
1874: l_debug_on := wsh_debug_interface.g_debug;
1875: IF l_debug_on IS NULL THEN
1876: l_debug_on := wsh_debug_sv.is_debug_enabled;
1877: END IF;
1886: get(p_organization_id => p_organization_id
1887: ,x_param_info => l_param_info
1888: ,x_return_status => l_return_status);
1889:
1890: If l_return_status <> fnd_api.G_RET_STS_SUCCESS then
1891: x_return_status := l_return_status;
1892: return;
1893: Else
1894: x_param_info := l_param_info;
1980: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1981: fnd_message.set_token('PACKAGE','WSH_SHIPPING_PARAMS_PVT');
1982: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1983: fnd_message.set_token('ORA_TEXT','');
1984: x_return_status := FND_API.G_RET_STS_ERROR;
1985: If l_debug_on Then
1986: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1987: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1988: END IF;
2018: handle_exception exception;
2019:
2020: Begin
2021:
2022: x_return_status := fnd_api.g_ret_sts_success;
2023:
2024: l_debug_on := wsh_debug_interface.g_debug;
2025: If l_debug_on is null then
2026: wsh_debug_sv.push(l_module_name);
2179: handle_exception exception;
2180:
2181: Begin
2182:
2183: x_return_status := fnd_api.g_ret_sts_success;
2184:
2185: l_debug_on := wsh_debug_interface.g_debug;
2186: If l_debug_on is null then
2187: l_debug_on := wsh_debug_sv.is_debug_enabled;
2295: Others Exception;
2296:
2297: Begin
2298:
2299: x_return_status := fnd_api.g_ret_sts_success;
2300:
2301: l_debug_on := wsh_debug_interface.g_debug;
2302: If l_debug_on is null then
2303: l_debug_on := wsh_debug_sv.is_debug_enabled;
2349: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'PRINT_DEBUG_INFO';
2350:
2351: Begin
2352:
2353: x_return_status := fnd_api.g_ret_sts_success;
2354: If p_print_info = 'WSH_SHIPPING_PARAMETERS' OR p_print_info = 'ALL' then
2355: wsh_debug_sv.log(p_module_name,'x_param_info.ship_confirm_rule_id',x_param_info.ship_confirm_rule_id);
2356: wsh_debug_sv.log(p_module_name,'x_param_info.autopack_level',x_param_info.autopack_level);
2357: wsh_debug_sv.log(p_module_name,'x_param_info.task_planning_flag',x_param_info.task_planning_flag);