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.WSH_FREIGHT_COSTS_PUB dependencies on WSH_UTIL_CORE

Line 22: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

18: l_type_id NUMBER;
19: BEGIN
20: --
21: --
22: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
23:
24: IF (x_freight_cost_type_id IS NULL) THEN
25: IF (p_freight_cost_type <> FND_API.G_MISS_CHAR) THEN
26: SELECT freight_cost_type_id INTO x_freight_cost_type_id

Line 45: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

41:
42:
43: EXCEPTION
44: WHEN No_Data_Found THEN
45: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
46: WHEN Invalid_Type THEN
47: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
48: WHEN others THEN
49: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 47: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

43: EXCEPTION
44: WHEN No_Data_Found THEN
45: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
46: WHEN Invalid_Type THEN
47: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
48: WHEN others THEN
49: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
50:
51: END validate_freight_cost_type;

Line 49: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

45: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
46: WHEN Invalid_Type THEN
47: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
48: WHEN others THEN
49: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
50:
51: END validate_freight_cost_type;
52:
53: PROCEDURE Delete_Freight_Costs (

Line 67: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

63: l_return_status VARCHAR2(30);
64: BEGIN
65: --
66: --
67: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
68:
69: WSH_FREIGHT_COSTS_PVT.Delete_freight_cost(
70: p_rowid => NULL,
71: p_freight_cost_id => p_pub_freight_costs.freight_cost_id,

Line 118: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

114: WSH_DEBUG_SV.log(l_module_name,'p_pub_freight_rec.FREIGHT_COST_ID',p_pub_freight_rec.FREIGHT_COST_ID);
115: WSH_DEBUG_SV.log(l_module_name,'p_pub_freight_rec.FREIGHT_COST_TYPE_ID',p_pub_freight_rec.FREIGHT_COST_TYPE_ID);
116: END IF;
117: --
118: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
119:
120: x_pvt_freight_rec.FREIGHT_COST_ID := p_pub_freight_rec.FREIGHT_COST_ID;
121: x_pvt_freight_rec.FREIGHT_COST_TYPE_ID := p_pub_freight_rec.FREIGHT_COST_TYPE_ID;
122: x_pvt_freight_rec.UNIT_AMOUNT := p_pub_freight_rec.UNIT_AMOUNT;

Line 182: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_FTE_INTEGRATION.map_freightpub_to_pvt',l_module_name);

178: END IF;
179: --
180: EXCEPTION
181: WHEN OTHERS THEN
182: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_FTE_INTEGRATION.map_freightpub_to_pvt',l_module_name);
183: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
184: --
185: IF l_debug_on THEN
186: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 183: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

179: --
180: EXCEPTION
181: WHEN OTHERS THEN
182: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_FTE_INTEGRATION.map_freightpub_to_pvt',l_module_name);
183: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
184: --
185: IF l_debug_on THEN
186: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
187: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 259: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN

255: IF l_debug_on THEN
256: wsh_debug_sv.log(l_module_name, 'map_freightpub_to_pvt x_return_status',x_return_status);
257: END IF;
258:
259: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
260: raise FND_API.G_EXC_ERROR;
261: END IF;
262:
263: l_in_rec.caller:='PLSQL';

Line 285: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS AND l_out_tab.COUNT > 0 ) THEN

281: p_freight_info_tab => l_freight_info_tab,
282: p_in_rec => l_in_rec,
283: x_out_tab => l_out_tab );
284:
285: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS AND l_out_tab.COUNT > 0 ) THEN
286: x_freight_cost_id := l_out_tab(l_out_tab.FIRST).freight_cost_id;
287: END IF;
288:
289: FND_MSG_PUB.Count_And_Get (

Line 299: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

295: END IF;
296:
297: EXCEPTION
298: WHEN FND_API.G_EXC_ERROR THEN
299: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
300: FND_MSG_PUB.Count_And_Get (
301: p_count => x_msg_count,
302: p_data => x_msg_data,
303: p_encoded => FND_API.G_FALSE);

Line 311: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

307: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
308: END IF;
309:
310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
311: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
312: FND_MSG_PUB.Count_And_Get (
313: p_count => x_msg_count,
314: p_data => x_msg_data,
315: p_encoded => FND_API.G_FALSE);

Line 322: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

318: WSH_DEBUG_SV.C_EXCEP_LEVEL);
319: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
320: END IF;
321:
322: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
323: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
324: FND_MSG_PUB.Count_And_Get (
325: p_count => x_msg_count,
326: p_data => x_msg_data,

Line 323: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

319: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
320: END IF;
321:
322: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
323: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
324: FND_MSG_PUB.Count_And_Get (
325: p_count => x_msg_count,
326: p_data => x_msg_data,
327: p_encoded => FND_API.G_FALSE);

Line 329: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',

325: p_count => x_msg_count,
326: p_data => x_msg_data,
327: p_encoded => FND_API.G_FALSE);
328: IF l_debug_on THEN
329: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',
330: WSH_DEBUG_SV.C_EXCEP_LEVEL);
331: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
332: END IF;
333:

Line 331: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

327: p_encoded => FND_API.G_FALSE);
328: IF l_debug_on THEN
329: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',
330: WSH_DEBUG_SV.C_EXCEP_LEVEL);
331: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
332: END IF;
333:
334: WHEN OTHERS THEN
335: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 335: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

331: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
332: END IF;
333:
334: WHEN OTHERS THEN
335: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
336: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
337: FND_MSG_PUB.Count_And_Get (
338: p_count => x_msg_count,
339: p_data => x_msg_data,

Line 336: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');

332: END IF;
333:
334: WHEN OTHERS THEN
335: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
336: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
337: FND_MSG_PUB.Count_And_Get (
338: p_count => x_msg_count,
339: p_data => x_msg_data,
340: p_encoded => FND_API.G_FALSE);