DBA Data[Home] [Help]

APPS.WSH_PICK_LIST dependencies on WSH_INTEGRATION

Line 1401: WSH_INTEGRATION.DBI_Update_Detail_Log (

1397: -- Update of wsh_delivery_details where released_status is changed, call DBI API after the update.
1398: IF l_debug_on THEN
1399: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail Count-',l_rel_delivery_detail_id.count);
1400: END IF;
1401: WSH_INTEGRATION.DBI_Update_Detail_Log (
1402: p_delivery_detail_id_tab => l_rel_delivery_detail_id,
1403: p_dml_type => 'UPDATE',
1404: x_return_status => l_dbi_rs );
1405: IF l_debug_on THEN

Line 1409: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_INTEGRATION.DBI_Update_Detail_Log');

1405: IF l_debug_on THEN
1406: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
1407: END IF;
1408: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1409: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_INTEGRATION.DBI_Update_Detail_Log');
1410: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1411: IF l_debug_on THEN
1412: WSH_DEBUG_SV.pop(l_module_name);
1413: END IF;

Line 1764: WSH_INTEGRATION.DBI_Update_Detail_Log (

1760: -- Update of wsh_delivery_details where released_status is changed, call DBI API after the update.
1761: IF l_debug_on THEN
1762: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail count',l_detail_tab.count);
1763: END IF;
1764: WSH_INTEGRATION.DBI_Update_Detail_Log (
1765: p_delivery_detail_id_tab => l_detail_tab,
1766: p_dml_type => 'UPDATE',
1767: x_return_status => l_dbi_rs );
1768: IF l_debug_on THEN

Line 1773: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_INTEGRATION.DBI_Update_Detail_Log');

1769: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
1770: END IF;
1771: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1772: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1773: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_INTEGRATION.DBI_Update_Detail_Log');
1774: IF l_debug_on THEN
1775: WSH_DEBUG_SV.pop(l_module_name);
1776: END IF;
1777: RETURN;