eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FTE_SOURCE_LINE_CONSOLIDATION dependencies on WSH_UTIL_CORE

Line 64: l_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

60: --
61: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
62: END IF;
63: --
64: l_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
65:
66: IF (g_weight_uom_tab.EXISTS(p_org_id)) THEN
67: l_weight_uom_code := g_weight_uom_tab(p_org_id);
68: END IF;

Line 89: l_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

85: l_volume_uom_code,
86: l_status);
87:
88: IF (l_status is null) THEN
89: l_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
90: END IF;
91:
92: g_weight_uom_tab(p_org_id) := l_weight_uom_code;
93: g_volume_uom_tab(p_org_id) := l_volume_uom_code;

Line 404: l_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

400: WSH_DEBUG_SV.logmsg(l_module_name,'l_counter = '||l_counter,WSH_DEBUG_SV.C_PROC_LEVEL);
401: END IF;
402:
403: -- reset variables
404: l_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
405: l_weight_uom_code := NULL;
406: l_volume_uom_code := NULL;
407: l_converted_weight := NULL;
408: l_converted_volume := NULL;

Line 416: IF (l_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

412: l_weight_uom_code,
413: l_volume_uom_code,
414: l_status);
415:
416: IF (l_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
417: p_source_line_tab(l_counter).status := l_status;
418: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NO_DEFAULT_UOM');
419: p_source_line_tab(l_counter).message_data := FND_MESSAGE.GET;
420: END IF;

Line 423: IF (l_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

419: p_source_line_tab(l_counter).message_data := FND_MESSAGE.GET;
420: END IF;
421:
422: -- calculated weight and volume for this inventory item against requested quantity
423: IF (l_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
424:
425: OPEN get_converted_wv(p_source_line_tab(l_counter).ship_from_org_id,
426: p_source_line_tab(l_counter).inventory_item_id,
427: p_source_line_tab(l_counter).source_quantity,

Line 441: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_LOCATION_ID',WSH_DEBUG_SV.C_PROC_LEVEL);

437: --
438: -- Debug Statements
439: --
440: IF l_debug_on THEN
441: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_LOCATION_ID',WSH_DEBUG_SV.C_PROC_LEVEL);
442: END IF;
443: --
444: WSH_UTIL_CORE.Get_Location_Id('ORG',
445: p_source_line_tab(l_counter).ship_from_org_id,

Line 444: WSH_UTIL_CORE.Get_Location_Id('ORG',

440: IF l_debug_on THEN
441: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_LOCATION_ID',WSH_DEBUG_SV.C_PROC_LEVEL);
442: END IF;
443: --
444: WSH_UTIL_CORE.Get_Location_Id('ORG',
445: p_source_line_tab(l_counter).ship_from_org_id,
446: p_source_line_tab(l_counter).ship_from_location_id,
447: l_status);
448: END IF;

Line 450: IF (l_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

446: p_source_line_tab(l_counter).ship_from_location_id,
447: l_status);
448: END IF;
449:
450: IF (l_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
451: p_source_line_tab(l_counter).status := l_status;
452: FND_MESSAGE.SET_NAME('WSH', 'WSH_ORG_LOCATION_UNDEFINED');
453: p_source_line_tab(l_counter).message_data := FND_MESSAGE.GET;
454: END IF;

Line 462: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_LOCATION_ID',WSH_DEBUG_SV.C_PROC_LEVEL);

458: --
459: -- Debug Statements
460: --
461: IF l_debug_on THEN
462: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_LOCATION_ID',WSH_DEBUG_SV.C_PROC_LEVEL);
463: END IF;
464: --
465: WSH_UTIL_CORE.Get_Location_Id('CUSTOMER SITE',
466: p_source_line_tab(l_counter).ship_to_site_id,

Line 465: WSH_UTIL_CORE.Get_Location_Id('CUSTOMER SITE',

461: IF l_debug_on THEN
462: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_LOCATION_ID',WSH_DEBUG_SV.C_PROC_LEVEL);
463: END IF;
464: --
465: WSH_UTIL_CORE.Get_Location_Id('CUSTOMER SITE',
466: p_source_line_tab(l_counter).ship_to_site_id,
467: p_source_line_tab(l_counter).ship_to_location_id,
468: l_status);
469: END IF;

Line 471: IF (l_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

467: p_source_line_tab(l_counter).ship_to_location_id,
468: l_status);
469: END IF;
470:
471: IF (l_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
472: p_source_line_tab(l_counter).status := l_status;
473: FND_MESSAGE.SET_NAME('WSH', 'WSH_SITE_LOCATION_UNDEFINED');
474: p_source_line_tab(l_counter).message_data := FND_MESSAGE.GET;
475: END IF;

Line 484: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_LOCATION_ID',WSH_DEBUG_SV.C_PROC_LEVEL);

480: --
481: -- Debug Statements
482: --
483: IF l_debug_on THEN
484: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_LOCATION_ID',WSH_DEBUG_SV.C_PROC_LEVEL);
485: END IF;
486: --
487: WSH_UTIL_CORE.Get_Location_Id('CUSTOMER SITE',
488: p_source_line_tab(l_counter).intmed_ship_to_site_id,

Line 487: WSH_UTIL_CORE.Get_Location_Id('CUSTOMER SITE',

483: IF l_debug_on THEN
484: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_LOCATION_ID',WSH_DEBUG_SV.C_PROC_LEVEL);
485: END IF;
486: --
487: WSH_UTIL_CORE.Get_Location_Id('CUSTOMER SITE',
488: p_source_line_tab(l_counter).intmed_ship_to_site_id,
489: p_source_line_tab(l_counter).intmed_ship_to_loc_id,
490: l_status);
491: END IF;

Line 493: IF (l_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

489: p_source_line_tab(l_counter).intmed_ship_to_loc_id,
490: l_status);
491: END IF;
492:
493: IF (l_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
494: p_source_line_tab(l_counter).status := l_status;
495: FND_MESSAGE.SET_NAME('WSH', 'WSH_SITE_LOCATION_UNDEFINED');
496: p_source_line_tab(l_counter).message_data := FND_MESSAGE.GET;
497: END IF;

Line 499: IF (l_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

495: FND_MESSAGE.SET_NAME('WSH', 'WSH_SITE_LOCATION_UNDEFINED');
496: p_source_line_tab(l_counter).message_data := FND_MESSAGE.GET;
497: END IF;
498:
499: IF (l_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
500: -- get hash value for this source line
501: Create_Hash(p_source_line_rec => p_source_line_tab(l_counter),
502: p_action => p_action,
503: x_hash_value => l_hash_value,

Line 704: p_source_line_tab(l_counter).status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

700: p_source_line_tab(l_counter).volume := l_converted_volume;
701: p_source_line_tab(l_counter).volume_uom_code := l_volume_uom_code;
702: p_source_line_tab(l_counter).freight_rate := null;
703: p_source_line_tab(l_counter).freight_rate_currency := null;
704: p_source_line_tab(l_counter).status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
705: p_source_line_tab(l_counter).message_data := null;
706: p_source_line_tab(l_counter).consolidation_id := l_con_id;
707:
708: END LOOP;

Line 710: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

706: p_source_line_tab(l_counter).consolidation_id := l_con_id;
707:
708: END LOOP;
709:
710: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
711:
712: --
713: -- Debug Statements
714: --

Line 721: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

717: END IF;
718: --
719: EXCEPTION
720: WHEN OTHERS THEN
721: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
722: x_msg_data := SQLERRM;
723: --
724: -- Debug Statements
725: --