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_TRIP_STOPS_PUB dependencies on WSH_UTIL_CORE

Line 60: l_entity_id_tab wsh_util_core.id_tab_type;

56: p_defer_interface_flag IN VARCHAR2 DEFAULT 'Y') IS
57:
58: l_api_version_number CONSTANT NUMBER := 1.0;
59: l_api_name CONSTANT VARCHAR2(30):= 'Stop_Action';
60: l_entity_id_tab wsh_util_core.id_tab_type;
61: l_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
62: l_stop_out_rec WSH_TRIP_STOPS_GRP.stopActionOutRecType;
63:
64: --

Line 133: wsh_util_core.api_post_call(p_return_status =>l_return_status,

129: wsh_util_validate.validate_trip_name( l_trip_id,
130: p_trip_name,
131: l_return_status);
132:
133: wsh_util_core.api_post_call(p_return_status =>l_return_status,
134: x_num_warnings =>l_num_warning,
135: x_num_errors =>l_num_errors);
136:
137: IF ((l_stop_location_id IS NOT NULL)

Line 146: wsh_util_core.api_post_call(p_return_status =>l_return_status,

142: wsh_util_validate.validate_location( l_stop_location_id,
143: p_stop_location_code,
144: l_return_status);
145:
146: wsh_util_core.api_post_call(p_return_status =>l_return_status,
147: x_num_warnings =>l_num_warning,
148: x_num_errors =>l_num_errors);
149:
150: END IF;

Line 157: wsh_util_core.api_post_call(p_return_status =>l_return_status,

153: l_stop_location_id,
154: p_planned_dep_date,
155: l_return_status);
156:
157: wsh_util_core.api_post_call(p_return_status =>l_return_status,
158: x_num_warnings =>l_num_warning,
159: x_num_errors =>l_num_errors);
160:
161: IF (l_stop_id IS NULL) THEN

Line 203: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('STOP',p_action_code));

199: WHEN FND_API.G_EXC_ERROR THEN
200: x_return_status := FND_API.G_RET_STS_ERROR;
201: FND_MESSAGE.SET_NAME('WSH','WSH_OI_STOP_ACTION_ERROR');
202: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(l_stop_id));
203: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('STOP',p_action_code));
204: wsh_util_core.add_message(x_return_status,l_module_name);
205:
206: IF l_debug_on THEN
207: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_EXC_ERROR');

Line 204: wsh_util_core.add_message(x_return_status,l_module_name);

200: x_return_status := FND_API.G_RET_STS_ERROR;
201: FND_MESSAGE.SET_NAME('WSH','WSH_OI_STOP_ACTION_ERROR');
202: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(l_stop_id));
203: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('STOP',p_action_code));
204: wsh_util_core.add_message(x_return_status,l_module_name);
205:
206: IF l_debug_on THEN
207: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_EXC_ERROR');
208: WSH_DEBUG_SV.pop(l_module_name);

Line 216: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('STOP',p_action_code));

212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
214: FND_MESSAGE.SET_NAME('WSH','WSH_OI_STOP_ACTION_ERROR');
215: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(l_stop_id));
216: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('STOP',p_action_code));
217: wsh_util_core.add_message(x_return_status,l_module_name);
218: -- Get message count and data
219: FND_MSG_PUB.Count_And_Get
220: ( p_count => x_msg_count

Line 217: wsh_util_core.add_message(x_return_status,l_module_name);

213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
214: FND_MESSAGE.SET_NAME('WSH','WSH_OI_STOP_ACTION_ERROR');
215: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(l_stop_id));
216: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('STOP',p_action_code));
217: wsh_util_core.add_message(x_return_status,l_module_name);
218: -- Get message count and data
219: FND_MSG_PUB.Count_And_Get
220: ( p_count => x_msg_count
221: , p_data => x_msg_data

Line 275: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

271: WSH_DEBUG_SV.log(l_module_name,'p_pub_stop_rec.TRIP_ID',p_pub_stop_rec.TRIP_ID);
272: WSH_DEBUG_SV.log(l_module_name,'p_pub_stop_rec.TRIP_NAME',p_pub_stop_rec.TRIP_NAME);
273: END IF;
274:
275: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
276:
277: x_pvt_stop_rec.STOP_ID := p_pub_stop_rec.STOP_ID;
278: x_pvt_stop_rec.TRIP_ID := p_pub_stop_rec.TRIP_ID;
279: x_pvt_stop_rec.STOP_LOCATION_ID := p_pub_stop_rec.STOP_LOCATION_ID;

Line 362: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_FTE_INTEGRATION.map_stoppub_to_grp',l_module_name);

358: WSH_DEBUG_SV.pop(l_module_name);
359: END IF;
360: EXCEPTION
361: WHEN OTHERS THEN
362: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_FTE_INTEGRATION.map_stoppub_to_grp',l_module_name);
363: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
364: --
365: IF l_debug_on THEN
366: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||

Line 363: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

359: END IF;
360: EXCEPTION
361: WHEN OTHERS THEN
362: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_FTE_INTEGRATION.map_stoppub_to_grp',l_module_name);
363: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
364: --
365: IF l_debug_on THEN
366: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
367: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

448: x_return_status => x_return_status);
449: IF l_debug_on THEN
450: wsh_debug_sv.log (l_module_name, 'map_stoppub_to_pvt x_return_status',x_return_status);
451: END IF;
452: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
453: raise FND_API.G_EXC_ERROR;
454: END IF;
455:
456: IF (p_trip_id IS NOT NULL) AND (p_trip_id <> FND_API.G_MISS_NUM) THEN

Line 510: IF ( x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS AND l_stop_out_tab.count > 0) THEN

506: IF l_debug_on THEN
507: WSH_DEBUG_SV.log(l_module_name,'WSH_INTERFACE_GRP.CREATE_UPDATE_STOP x_return_status',x_return_status);
508: END IF;
509:
510: IF ( x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS AND l_stop_out_tab.count > 0) THEN
511: x_stop_id := l_stop_out_tab(l_stop_out_tab.FIRST).stop_id;
512: END IF;
513:
514:

Line 525: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

521: END IF;
522:
523: EXCEPTION
524: WHEN FND_API.G_EXC_ERROR THEN
525: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
526: FND_MSG_PUB.Count_And_Get (
527: p_count => x_msg_count,
528: p_data => x_msg_data,
529: p_encoded => FND_API.G_FALSE);

Line 537: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

533: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
534: END IF;
535:
536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
537: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
538: FND_MSG_PUB.Count_And_Get (
539: p_count => x_msg_count,
540: p_data => x_msg_data,
541: p_encoded => FND_API.G_FALSE);

Line 548: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

544: WSH_DEBUG_SV.C_EXCEP_LEVEL);
545: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
546: END IF;
547:
548: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
549: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
550: FND_MSG_PUB.Count_And_Get (
551: p_count => x_msg_count,
552: p_data => x_msg_data,

Line 549: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

545: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
546: END IF;
547:
548: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
549: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
550: FND_MSG_PUB.Count_And_Get (
551: p_count => x_msg_count,
552: p_data => x_msg_data,
553: p_encoded => FND_API.G_FALSE);

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

551: p_count => x_msg_count,
552: p_data => x_msg_data,
553: p_encoded => FND_API.G_FALSE);
554: IF l_debug_on THEN
555: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',
556: WSH_DEBUG_SV.C_EXCEP_LEVEL);
557: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
558: END IF;
559:

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

553: p_encoded => FND_API.G_FALSE);
554: IF l_debug_on THEN
555: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',
556: WSH_DEBUG_SV.C_EXCEP_LEVEL);
557: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
558: END IF;
559:
560: WHEN OTHERS THEN
561: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 561: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

557: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
558: END IF;
559:
560: WHEN OTHERS THEN
561: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
562: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
563: FND_MSG_PUB.Count_And_Get (
564: p_count => x_msg_count,
565: p_data => x_msg_data,

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

558: END IF;
559:
560: WHEN OTHERS THEN
561: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
562: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
563: FND_MSG_PUB.Count_And_Get (
564: p_count => x_msg_count,
565: p_data => x_msg_data,
566: p_encoded => FND_API.G_FALSE);