DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_ACTIONS dependencies on WSH_NEW_DELIVERY_ACTIONS

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

1319: return;
1320:
1321: WHEN OTHERS THEN
1322: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1323: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.UNRESERVE_DELIVERY_DETAIL',l_module_name);
1324: --
1325: IF l_debug_on THEN
1326: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1327: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

1774: IF (l_delivery1 = p_delivery_id) THEN --already assigned to the delivery
1775: x_assign_update := FALSE; --same delivery, no need to update
1776: ELSE
1777:
1778: l_is_delivery_empty := WSH_NEW_DELIVERY_ACTIONS.IS_DELIVERY_EMPTY(p_delivery_id);
1779: IF (l_is_delivery_empty = 'Y') THEN
1780: x_delivery_was_empty := TRUE;
1781: ELSIF (l_is_delivery_empty = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
1782: IF l_debug_on THEN

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

1779: IF (l_is_delivery_empty = 'Y') THEN
1780: x_delivery_was_empty := TRUE;
1781: ELSIF (l_is_delivery_empty = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
1782: IF l_debug_on THEN
1783: WSH_DEBUG_SV.log(l_module_name,'error from wsh_new_delivery_actions.is_delivery_empty');
1784: END IF;
1785: raise FND_API.G_EXC_ERROR;
1786: END IF;
1787: END IF;

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

1829: IF (l_delivery1 = l_delivery2) THEN --both belong to same delivery and not NULL
1830: x_assign_update := FALSE; --same delivery, no need to update
1831: ELSIF (l_delivery1 IS NOT NULL) THEN --cannot have both NOT NULL
1832:
1833: l_is_delivery_empty := WSH_NEW_DELIVERY_ACTIONS.IS_DELIVERY_EMPTY(l_delivery1);
1834: IF (l_is_delivery_empty = 'Y') THEN
1835: x_delivery_was_empty := TRUE;
1836: ELSIF (l_is_delivery_empty = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
1837: IF l_debug_on THEN

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

1834: IF (l_is_delivery_empty = 'Y') THEN
1835: x_delivery_was_empty := TRUE;
1836: ELSIF (l_is_delivery_empty = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
1837: IF l_debug_on THEN
1838: WSH_DEBUG_SV.log(l_module_name,'error from wsh_new_delivery_actions.is_delivery_empty');
1839: END IF;
1840: raise FND_API.G_EXC_ERROR;
1841: END IF;
1842: ELSIF (l_delivery2 IS NOT NULL) THEN

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

1840: raise FND_API.G_EXC_ERROR;
1841: END IF;
1842: ELSIF (l_delivery2 IS NOT NULL) THEN
1843:
1844: l_is_delivery_empty := WSH_NEW_DELIVERY_ACTIONS.IS_DELIVERY_EMPTY(l_delivery2);
1845: IF (l_is_delivery_empty = 'Y') THEN
1846: x_delivery_was_empty := TRUE;
1847: ELSIF (l_is_delivery_empty = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
1848: IF l_debug_on THEN

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

1845: IF (l_is_delivery_empty = 'Y') THEN
1846: x_delivery_was_empty := TRUE;
1847: ELSIF (l_is_delivery_empty = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
1848: IF l_debug_on THEN
1849: WSH_DEBUG_SV.log(l_module_name,'error from wsh_new_delivery_actions.is_delivery_empty');
1850: END IF;
1851: raise FND_API.G_EXC_ERROR;
1852: END IF;
1853: END IF;

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

1970: l_call_update := 'Y';
1971: l_delivery_id_tab(1) := p_delivery_id;
1972:
1973: IF (p_delivery_was_empty) THEN
1974: l_is_delivery_empty := WSH_NEW_DELIVERY_ACTIONS.IS_DELIVERY_EMPTY(p_delivery_id);
1975:
1976: IF (l_is_delivery_empty = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
1977: IF l_debug_on THEN
1978: WSH_DEBUG_SV.log(l_module_name,'error from wsh_new_delivery_actions.is_delivery_empty');

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

1974: l_is_delivery_empty := WSH_NEW_DELIVERY_ACTIONS.IS_DELIVERY_EMPTY(p_delivery_id);
1975:
1976: IF (l_is_delivery_empty = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
1977: IF l_debug_on THEN
1978: WSH_DEBUG_SV.log(l_module_name,'error from wsh_new_delivery_actions.is_delivery_empty');
1979: END IF;
1980: raise FND_API.G_EXC_ERROR;
1981: ELSIF (l_is_delivery_empty = 'Y') THEN
1982: l_call_update := 'N';

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

7202: nvl(l_del1.ignore_for_planning, 'N') = 'N') THEN
7203:
7204: l_call_update := 'Y';
7205: l_delivery_id_tab(1) := l_assign.delivery_id;
7206: l_is_delivery_empty := WSH_NEW_DELIVERY_ACTIONS.IS_DELIVERY_EMPTY(l_assign.delivery_id);
7207:
7208: IF (l_is_delivery_empty = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
7209: --handle the error approriately to the procedure this code is in
7210: IF l_debug_on THEN

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

7207:
7208: IF (l_is_delivery_empty = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
7209: --handle the error approriately to the procedure this code is in
7210: IF l_debug_on THEN
7211: WSH_DEBUG_SV.log(l_module_name,'error from wsh_new_delivery_actions.is_delivery_empty');
7212: END IF;
7213: raise FND_API.G_EXC_ERROR;
7214: ELSIF (l_is_delivery_empty = 'Y') THEN
7215: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED;

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

7863:
7864: --
7865: IF l_debug_on THEN
7866: WSH_DEBUG_SV.log(l_module_name,'l_dlvy_tbl(l_index).value',l_dlvy_tbl(l_index).value);
7867: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.update_freight_terms',WSH_DEBUG_SV.C_PROC_LEVEL);
7868: END IF;
7869: --
7870: WSH_NEW_DELIVERY_ACTIONS.update_freight_terms
7871: (

Line 7870: WSH_NEW_DELIVERY_ACTIONS.update_freight_terms

7866: WSH_DEBUG_SV.log(l_module_name,'l_dlvy_tbl(l_index).value',l_dlvy_tbl(l_index).value);
7867: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.update_freight_terms',WSH_DEBUG_SV.C_PROC_LEVEL);
7868: END IF;
7869: --
7870: WSH_NEW_DELIVERY_ACTIONS.update_freight_terms
7871: (
7872: p_delivery_id => l_dlvy_tbl(l_index).value,
7873: p_action_code => 'UNASSIGN',
7874: x_return_status => l_return_status,

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

7932: END IF;
7933:
7934: IF l_debug_on THEN
7935: WSH_DEBUG_SV.log(l_module_name,'l_dlvy_ext_tbl(l_index).value',l_dlvy_ext_tbl(l_index).value);
7936: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.update_freight_terms',WSH_DEBUG_SV.C_PROC_LEVEL);
7937: END IF;
7938: --
7939: WSH_NEW_DELIVERY_ACTIONS.update_freight_terms
7940: (

Line 7939: WSH_NEW_DELIVERY_ACTIONS.update_freight_terms

7935: WSH_DEBUG_SV.log(l_module_name,'l_dlvy_ext_tbl(l_index).value',l_dlvy_ext_tbl(l_index).value);
7936: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.update_freight_terms',WSH_DEBUG_SV.C_PROC_LEVEL);
7937: END IF;
7938: --
7939: WSH_NEW_DELIVERY_ACTIONS.update_freight_terms
7940: (
7941: p_delivery_id => l_dlvy_ext_tbl(l_index).value,
7942: p_action_code => 'UNASSIGN',
7943: x_return_status => l_return_status,

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

11869: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_return_excp');
11870: END IF;
11871:
11872: WHEN OTHERS THEN
11873: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.unassign_unpack_empty_cont');
11874: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
11875: --
11876: IF l_debug_on THEN
11877: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);