APPS.WSH_PICK_LIST dependencies on WSH_INTEGRATION

Line 1340: WSH_INTEGRATION.DBI_Update_Detail_Log (

1336: -- Update of wsh_delivery_details where released_status is changed, call DBI API after the update.
1337: IF l_debug_on THEN
1338: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail Count-',l_rel_delivery_detail_id.count);
1339: END IF;
1340: WSH_INTEGRATION.DBI_Update_Detail_Log (
1341: p_delivery_detail_id_tab => l_rel_delivery_detail_id,
1342: p_dml_type => 'UPDATE',
1343: x_return_status => l_dbi_rs );
1344: IF l_debug_on THEN

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

1344: IF l_debug_on THEN
1345: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
1346: END IF;
1347: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1348: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_INTEGRATION.DBI_Update_Detail_Log');
1349: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1350: IF l_debug_on THEN
1351: WSH_DEBUG_SV.pop(l_module_name);
1352: END IF;

Line 1703: WSH_INTEGRATION.DBI_Update_Detail_Log (

1699: -- Update of wsh_delivery_details where released_status is changed, call DBI API after the update.
1700: IF l_debug_on THEN
1701: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail count',l_detail_tab.count);
1702: END IF;
1703: WSH_INTEGRATION.DBI_Update_Detail_Log (
1704: p_delivery_detail_id_tab => l_detail_tab,
1705: p_dml_type => 'UPDATE',
1706: x_return_status => l_dbi_rs );
1707: IF l_debug_on THEN

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

1708: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
1709: END IF;
1710: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1711: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1712: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_INTEGRATION.DBI_Update_Detail_Log');
1713: IF l_debug_on THEN
1714: WSH_DEBUG_SV.pop(l_module_name);
1715: END IF;
1716: RETURN;