APPS.FTE_COMP_CONSTRAINT_UTIL dependencies on WSH_UTIL_CORE

Line 8: g_unexp_char VARCHAR2(30) := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FTE_COMP_CONSTRAINT_UTIL';
6: -- Global Variables
7:
8: g_unexp_char VARCHAR2(30) := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
9: g_unexp_num NUMBER := -999999;
10:
11:
12: CURSOR c_meaning(c_lookup_type IN VARCHAR2,c_lookup_code IN VARCHAR2) IS

Line 294: IF WSH_UTIL_CORE.TP_Is_Installed = 'Y' THEN

290: END IF;
291:
292: ELSIF p_object_type = 'ITM' THEN
293:
294: IF WSH_UTIL_CORE.TP_Is_Installed = 'Y' THEN
295:
296: OPEN c_get_item_name(p_object_value_num);
297: FETCH c_get_item_name INTO l_result;
298: CLOSE c_get_item_name;

Line 302: l_result := WSH_UTIL_CORE.Get_Item_Name

298: CLOSE c_get_item_name;
299:
300: ELSE
301:
302: l_result := WSH_UTIL_CORE.Get_Item_Name
303: (p_item_id => p_object_value_num,
304: p_organization_id => p_object_parent_id
305: );
306: END IF;

Line 320: l_result := WSH_UTIL_CORE.Get_Item_Name

316: OPEN c_get_vehicle_det(p_object_value_num);
317: FETCH c_get_vehicle_det INTO l_veh_item_id,l_veh_org_id,l_veh_class_code;
318: CLOSE c_get_vehicle_det;
319:
320: l_result := WSH_UTIL_CORE.Get_Item_Name
321: (p_item_id => l_veh_item_id,
322: p_organization_id => l_veh_org_id
323: );
324:

Line 490: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

486: others EXCEPTION;
487:
488: BEGIN
489:
490: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
491:
492: IF l_debug_on THEN
493: wsh_debug_sv.push(l_module_name);
494: END IF;

Line 542: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

538: p_encoded => FND_API.G_FALSE);
539:
540: EXCEPTION
541: WHEN invalid_loc_src_code THEN
542: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
543:
544: FND_MSG_PUB.Count_And_Get (
545: p_count => x_msg_count,
546: p_data => x_msg_data,

Line 555: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

551: WSH_DEBUG_SV.log(l_module_name,'Error : Invalid Location Source Code : ', p_source_location_code);
552: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
553: END IF;
554: WHEN OTHERS THEN
555: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
556:
557: FND_MSG_PUB.Count_And_Get (
558: p_count => x_msg_count,
559: p_data => x_msg_data,