DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_ACTIONS dependencies on WSH_NEW_DELIVERY_ACTIONS

Line 1409: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.UNRESERVE_DELIVERY_DETAIL',l_module_name);

1405: return;
1406:
1407: WHEN OTHERS THEN
1408: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1409: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.UNRESERVE_DELIVERY_DETAIL',l_module_name);
1410: --
1411: IF l_debug_on THEN
1412: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1413: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1889: l_is_delivery_empty := WSH_NEW_DELIVERY_ACTIONS.IS_DELIVERY_EMPTY(p_delivery_id);

1885: IF (l_delivery1 = p_delivery_id) THEN --already assigned to the delivery
1886: x_assign_update := FALSE; --same delivery, no need to update
1887: ELSE
1888:
1889: l_is_delivery_empty := WSH_NEW_DELIVERY_ACTIONS.IS_DELIVERY_EMPTY(p_delivery_id);
1890: IF (l_is_delivery_empty = 'Y') THEN
1891: x_delivery_was_empty := TRUE;
1892: ELSIF (l_is_delivery_empty = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
1893: IF l_debug_on THEN

Line 1894: WSH_DEBUG_SV.log(l_module_name,'error from wsh_new_delivery_actions.is_delivery_empty');

1890: IF (l_is_delivery_empty = 'Y') THEN
1891: x_delivery_was_empty := TRUE;
1892: ELSIF (l_is_delivery_empty = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
1893: IF l_debug_on THEN
1894: WSH_DEBUG_SV.log(l_module_name,'error from wsh_new_delivery_actions.is_delivery_empty');
1895: END IF;
1896: raise FND_API.G_EXC_ERROR;
1897: END IF;
1898: END IF;

Line 1944: l_is_delivery_empty := WSH_NEW_DELIVERY_ACTIONS.IS_DELIVERY_EMPTY(l_delivery1);

1940: IF (l_delivery1 = l_delivery2) THEN --both belong to same delivery and not NULL
1941: x_assign_update := FALSE; --same delivery, no need to update
1942: ELSIF (l_delivery1 IS NOT NULL) THEN --cannot have both NOT NULL
1943:
1944: l_is_delivery_empty := WSH_NEW_DELIVERY_ACTIONS.IS_DELIVERY_EMPTY(l_delivery1);
1945: IF (l_is_delivery_empty = 'Y') THEN
1946: x_delivery_was_empty := TRUE;
1947: ELSIF (l_is_delivery_empty = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
1948: IF l_debug_on THEN

Line 1949: WSH_DEBUG_SV.log(l_module_name,'error from wsh_new_delivery_actions.is_delivery_empty');

1945: IF (l_is_delivery_empty = 'Y') THEN
1946: x_delivery_was_empty := TRUE;
1947: ELSIF (l_is_delivery_empty = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
1948: IF l_debug_on THEN
1949: WSH_DEBUG_SV.log(l_module_name,'error from wsh_new_delivery_actions.is_delivery_empty');
1950: END IF;
1951: raise FND_API.G_EXC_ERROR;
1952: END IF;
1953: ELSIF (l_delivery2 IS NOT NULL) THEN

Line 1955: l_is_delivery_empty := WSH_NEW_DELIVERY_ACTIONS.IS_DELIVERY_EMPTY(l_delivery2);

1951: raise FND_API.G_EXC_ERROR;
1952: END IF;
1953: ELSIF (l_delivery2 IS NOT NULL) THEN
1954:
1955: l_is_delivery_empty := WSH_NEW_DELIVERY_ACTIONS.IS_DELIVERY_EMPTY(l_delivery2);
1956: IF (l_is_delivery_empty = 'Y') THEN
1957: x_delivery_was_empty := TRUE;
1958: ELSIF (l_is_delivery_empty = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
1959: IF l_debug_on THEN

Line 1960: WSH_DEBUG_SV.log(l_module_name,'error from wsh_new_delivery_actions.is_delivery_empty');

1956: IF (l_is_delivery_empty = 'Y') THEN
1957: x_delivery_was_empty := TRUE;
1958: ELSIF (l_is_delivery_empty = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
1959: IF l_debug_on THEN
1960: WSH_DEBUG_SV.log(l_module_name,'error from wsh_new_delivery_actions.is_delivery_empty');
1961: END IF;
1962: raise FND_API.G_EXC_ERROR;
1963: END IF;
1964: END IF;

Line 2085: l_is_delivery_empty := WSH_NEW_DELIVERY_ACTIONS.IS_DELIVERY_EMPTY(p_delivery_id);

2081: l_call_update := 'Y';
2082: l_delivery_id_tab(1) := p_delivery_id;
2083:
2084: IF (p_delivery_was_empty) THEN
2085: l_is_delivery_empty := WSH_NEW_DELIVERY_ACTIONS.IS_DELIVERY_EMPTY(p_delivery_id);
2086:
2087: IF (l_is_delivery_empty = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
2088: IF l_debug_on THEN
2089: WSH_DEBUG_SV.log(l_module_name,'error from wsh_new_delivery_actions.is_delivery_empty');

Line 2089: WSH_DEBUG_SV.log(l_module_name,'error from wsh_new_delivery_actions.is_delivery_empty');

2085: l_is_delivery_empty := WSH_NEW_DELIVERY_ACTIONS.IS_DELIVERY_EMPTY(p_delivery_id);
2086:
2087: IF (l_is_delivery_empty = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
2088: IF l_debug_on THEN
2089: WSH_DEBUG_SV.log(l_module_name,'error from wsh_new_delivery_actions.is_delivery_empty');
2090: END IF;
2091: raise FND_API.G_EXC_ERROR;
2092: ELSIF (l_is_delivery_empty = 'Y') THEN
2093: l_call_update := 'N';

Line 7375: l_is_delivery_empty := WSH_NEW_DELIVERY_ACTIONS.IS_DELIVERY_EMPTY(l_assign.delivery_id);

7371: nvl(l_del1.ignore_for_planning, 'N') = 'N') THEN
7372:
7373: l_call_update := 'Y';
7374: l_delivery_id_tab(1) := l_assign.delivery_id;
7375: l_is_delivery_empty := WSH_NEW_DELIVERY_ACTIONS.IS_DELIVERY_EMPTY(l_assign.delivery_id);
7376:
7377: IF (l_is_delivery_empty = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
7378: --handle the error approriately to the procedure this code is in
7379: IF l_debug_on THEN

Line 7380: WSH_DEBUG_SV.log(l_module_name,'error from wsh_new_delivery_actions.is_delivery_empty');

7376:
7377: IF (l_is_delivery_empty = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
7378: --handle the error approriately to the procedure this code is in
7379: IF l_debug_on THEN
7380: WSH_DEBUG_SV.log(l_module_name,'error from wsh_new_delivery_actions.is_delivery_empty');
7381: END IF;
7382: raise FND_API.G_EXC_ERROR;
7383: ELSIF (l_is_delivery_empty = 'Y') THEN
7384: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED;

Line 8031: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.update_freight_terms',WSH_DEBUG_SV.C_PROC_LEVEL);

8027:
8028: --
8029: IF l_debug_on THEN
8030: WSH_DEBUG_SV.log(l_module_name,'l_dlvy_tbl(l_index).value',l_dlvy_tbl(l_index).value);
8031: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.update_freight_terms',WSH_DEBUG_SV.C_PROC_LEVEL);
8032: END IF;
8033: --
8034: WSH_NEW_DELIVERY_ACTIONS.update_freight_terms
8035: (

Line 8034: WSH_NEW_DELIVERY_ACTIONS.update_freight_terms

8030: WSH_DEBUG_SV.log(l_module_name,'l_dlvy_tbl(l_index).value',l_dlvy_tbl(l_index).value);
8031: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.update_freight_terms',WSH_DEBUG_SV.C_PROC_LEVEL);
8032: END IF;
8033: --
8034: WSH_NEW_DELIVERY_ACTIONS.update_freight_terms
8035: (
8036: p_delivery_id => l_dlvy_tbl(l_index).value,
8037: p_action_code => 'UNASSIGN',
8038: x_return_status => l_return_status,

Line 8100: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.update_freight_terms',WSH_DEBUG_SV.C_PROC_LEVEL);

8096: END IF;
8097:
8098: IF l_debug_on THEN
8099: WSH_DEBUG_SV.log(l_module_name,'l_dlvy_ext_tbl(l_index).value',l_dlvy_ext_tbl(l_index).value);
8100: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.update_freight_terms',WSH_DEBUG_SV.C_PROC_LEVEL);
8101: END IF;
8102: --
8103: WSH_NEW_DELIVERY_ACTIONS.update_freight_terms
8104: (

Line 8103: WSH_NEW_DELIVERY_ACTIONS.update_freight_terms

8099: WSH_DEBUG_SV.log(l_module_name,'l_dlvy_ext_tbl(l_index).value',l_dlvy_ext_tbl(l_index).value);
8100: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.update_freight_terms',WSH_DEBUG_SV.C_PROC_LEVEL);
8101: END IF;
8102: --
8103: WSH_NEW_DELIVERY_ACTIONS.update_freight_terms
8104: (
8105: p_delivery_id => l_dlvy_ext_tbl(l_index).value,
8106: p_action_code => 'UNASSIGN',
8107: x_return_status => l_return_status,

Line 12338: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.unassign_unpack_empty_cont');

12334: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_return_excp');
12335: END IF;
12336:
12337: WHEN OTHERS THEN
12338: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.unassign_unpack_empty_cont');
12339: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
12340: --
12341: IF l_debug_on THEN
12342: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);