DBA Data[Home] [Help]

APPS.WSH_SHIPPING_PARAMS_PVT dependencies on FND_API

Line 172: x_return_status := FND_API.G_RET_STS_SUCCESS;

168: --
169: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
170: END IF;
171: --
172: x_return_status := FND_API.G_RET_STS_SUCCESS;
173:
174: -- Search table if it has any values
175:
176: IF g_parameters.count <> 0 THEN

Line 435: x_return_status := FND_API.G_RET_STS_ERROR;

431: WHEN NO_DATA_FOUND THEN
432: IF c_get_param%ISOPEN THEN
433: CLOSE c_get_param;
434: END IF;
435: x_return_status := FND_API.G_RET_STS_ERROR;
436: --
437: -- Debug Statements
438: --
439: IF l_debug_on THEN

Line 452: x_return_status := FND_API.G_RET_STS_ERROR;

448: FND_MESSAGE.Set_Token('ORA_TEXT','');
449: IF c_get_param%ISOPEN THEN
450: CLOSE c_get_param;
451: END IF;
452: x_return_status := FND_API.G_RET_STS_ERROR;
453:
454: --
455: -- Debug Statements
456: --

Line 567: x_return_status := FND_API.G_RET_STS_SUCCESS;

563: IF l_debug_on THEN
564: WSH_DEBUG_SV.push(l_module_name);
565: END IF;
566: --
567: x_return_status := FND_API.G_RET_STS_SUCCESS;
568:
569: -- Search table if it has global parameters already populated.
570:
571: IF g_global_parameters.count <> 0 THEN

Line 749: x_return_status := FND_API.G_RET_STS_ERROR;

745: WHEN NO_DATA_FOUND THEN
746: IF c_get_global_param%ISOPEN THEN
747: CLOSE c_get_global_param;
748: END IF;
749: x_return_status := FND_API.G_RET_STS_ERROR;
750: --
751: -- Debug Statements
752: --
753: IF l_debug_on THEN

Line 766: x_return_status := FND_API.G_RET_STS_ERROR;

762: FND_MESSAGE.Set_Token('ORA_TEXT','');
763: IF c_get_global_param%ISOPEN THEN
764: CLOSE c_get_global_param;
765: END IF;
766: x_return_status := FND_API.G_RET_STS_ERROR;
767:
768: --
769: -- Debug Statements
770: --

Line 1915: x_return_status := FND_API.G_RET_STS_SUCCESS;

1911:
1912: others exception;
1913:
1914: Begin
1915: x_return_status := FND_API.G_RET_STS_SUCCESS;
1916: l_debug_on := wsh_debug_interface.g_debug;
1917: IF l_debug_on IS NULL THEN
1918: l_debug_on := wsh_debug_sv.is_debug_enabled;
1919: END IF;

Line 1932: If l_return_status <> fnd_api.G_RET_STS_SUCCESS then

1928: get(p_organization_id => p_organization_id
1929: ,x_param_info => l_param_info
1930: ,x_return_status => l_return_status);
1931:
1932: If l_return_status <> fnd_api.G_RET_STS_SUCCESS then
1933: x_return_status := l_return_status;
1934: return;
1935: Else
1936: x_param_info := l_param_info;

Line 2026: x_return_status := FND_API.G_RET_STS_ERROR;

2022: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2023: fnd_message.set_token('PACKAGE','WSH_SHIPPING_PARAMS_PVT');
2024: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2025: fnd_message.set_token('ORA_TEXT','');
2026: x_return_status := FND_API.G_RET_STS_ERROR;
2027: If l_debug_on Then
2028: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2029: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2030: END IF;

Line 2064: x_return_status := fnd_api.g_ret_sts_success;

2060: handle_exception exception;
2061:
2062: Begin
2063:
2064: x_return_status := fnd_api.g_ret_sts_success;
2065:
2066: l_debug_on := wsh_debug_interface.g_debug;
2067: If l_debug_on is null then
2068: wsh_debug_sv.push(l_module_name);

Line 2225: x_return_status := fnd_api.g_ret_sts_success;

2221: handle_exception exception;
2222:
2223: Begin
2224:
2225: x_return_status := fnd_api.g_ret_sts_success;
2226:
2227: l_debug_on := wsh_debug_interface.g_debug;
2228: If l_debug_on is null then
2229: l_debug_on := wsh_debug_sv.is_debug_enabled;

Line 2341: x_return_status := fnd_api.g_ret_sts_success;

2337: Others Exception;
2338:
2339: Begin
2340:
2341: x_return_status := fnd_api.g_ret_sts_success;
2342:
2343: l_debug_on := wsh_debug_interface.g_debug;
2344: If l_debug_on is null then
2345: l_debug_on := wsh_debug_sv.is_debug_enabled;

Line 2395: x_return_status := fnd_api.g_ret_sts_success;

2391: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'PRINT_DEBUG_INFO';
2392:
2393: Begin
2394:
2395: x_return_status := fnd_api.g_ret_sts_success;
2396: If p_print_info = 'WSH_SHIPPING_PARAMETERS' OR p_print_info = 'ALL' then
2397: wsh_debug_sv.log(p_module_name,'x_param_info.ship_confirm_rule_id',x_param_info.ship_confirm_rule_id);
2398: wsh_debug_sv.log(p_module_name,'x_param_info.autopack_level',x_param_info.autopack_level);
2399: wsh_debug_sv.log(p_module_name,'x_param_info.task_planning_flag',x_param_info.task_planning_flag);