DBA Data[Home] [Help]

APPS.WSH_TRIP_STOPS_PUB dependencies on WSH_UTIL_CORE

Line 62: l_entity_id_tab wsh_util_core.id_tab_type;

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

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

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

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

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

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

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

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

211: WHEN FND_API.G_EXC_ERROR THEN
212: x_return_status := FND_API.G_RET_STS_ERROR;
213: FND_MESSAGE.SET_NAME('WSH','WSH_OI_STOP_ACTION_ERROR');
214: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(l_stop_id));
215: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('STOP',p_action_code));
216: wsh_util_core.add_message(x_return_status,l_module_name);
217:
218: IF l_debug_on THEN
219: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_EXC_ERROR');

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

212: x_return_status := FND_API.G_RET_STS_ERROR;
213: FND_MESSAGE.SET_NAME('WSH','WSH_OI_STOP_ACTION_ERROR');
214: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(l_stop_id));
215: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('STOP',p_action_code));
216: wsh_util_core.add_message(x_return_status,l_module_name);
217:
218: IF l_debug_on THEN
219: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_EXC_ERROR');
220: WSH_DEBUG_SV.pop(l_module_name);

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

224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
226: FND_MESSAGE.SET_NAME('WSH','WSH_OI_STOP_ACTION_ERROR');
227: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(l_stop_id));
228: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('STOP',p_action_code));
229: wsh_util_core.add_message(x_return_status,l_module_name);
230: -- Get message count and data
231: FND_MSG_PUB.Count_And_Get
232: ( p_count => x_msg_count

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

225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
226: FND_MESSAGE.SET_NAME('WSH','WSH_OI_STOP_ACTION_ERROR');
227: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(l_stop_id));
228: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('STOP',p_action_code));
229: wsh_util_core.add_message(x_return_status,l_module_name);
230: -- Get message count and data
231: FND_MSG_PUB.Count_And_Get
232: ( p_count => x_msg_count
233: , p_data => x_msg_data

Line 287: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

283: WSH_DEBUG_SV.log(l_module_name,'p_pub_stop_rec.TRIP_ID',p_pub_stop_rec.TRIP_ID);
284: WSH_DEBUG_SV.log(l_module_name,'p_pub_stop_rec.TRIP_NAME',p_pub_stop_rec.TRIP_NAME);
285: END IF;
286:
287: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
288:
289: x_pvt_stop_rec.STOP_ID := p_pub_stop_rec.STOP_ID;
290: x_pvt_stop_rec.TRIP_ID := p_pub_stop_rec.TRIP_ID;
291: x_pvt_stop_rec.STOP_LOCATION_ID := p_pub_stop_rec.STOP_LOCATION_ID;

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

370: WSH_DEBUG_SV.pop(l_module_name);
371: END IF;
372: EXCEPTION
373: WHEN OTHERS THEN
374: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_FTE_INTEGRATION.map_stoppub_to_grp',l_module_name);
375: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
376: --
377: IF l_debug_on THEN
378: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||

Line 375: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

371: END IF;
372: EXCEPTION
373: WHEN OTHERS THEN
374: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_FTE_INTEGRATION.map_stoppub_to_grp',l_module_name);
375: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
376: --
377: IF l_debug_on THEN
378: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
379: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

460: x_return_status => x_return_status);
461: IF l_debug_on THEN
462: wsh_debug_sv.log (l_module_name, 'map_stoppub_to_pvt x_return_status',x_return_status);
463: END IF;
464: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
465: raise FND_API.G_EXC_ERROR;
466: END IF;
467:
468: IF (p_trip_id IS NOT NULL) AND (p_trip_id <> FND_API.G_MISS_NUM) THEN

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

518: IF l_debug_on THEN
519: WSH_DEBUG_SV.log(l_module_name,'WSH_INTERFACE_GRP.CREATE_UPDATE_STOP x_return_status',x_return_status);
520: END IF;
521:
522: IF ( x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS AND l_stop_out_tab.count > 0) THEN
523: x_stop_id := l_stop_out_tab(l_stop_out_tab.FIRST).stop_id;
524: END IF;
525:
526:

Line 537: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

533: END IF;
534:
535: EXCEPTION
536: WHEN FND_API.G_EXC_ERROR THEN
537: x_return_status := WSH_UTIL_CORE.G_RET_STS_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 549: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

545: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
546: END IF;
547:
548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
549: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
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 560: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

556: WSH_DEBUG_SV.C_EXCEP_LEVEL);
557: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
558: END IF;
559:
560: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
561: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
562: FND_MSG_PUB.Count_And_Get (
563: p_count => x_msg_count,
564: p_data => x_msg_data,

Line 561: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

557: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
558: END IF;
559:
560: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
561: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
562: FND_MSG_PUB.Count_And_Get (
563: p_count => x_msg_count,
564: p_data => x_msg_data,
565: p_encoded => FND_API.G_FALSE);

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

563: p_count => x_msg_count,
564: p_data => x_msg_data,
565: p_encoded => FND_API.G_FALSE);
566: IF l_debug_on THEN
567: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',
568: WSH_DEBUG_SV.C_EXCEP_LEVEL);
569: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
570: END IF;
571:

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

565: p_encoded => FND_API.G_FALSE);
566: IF l_debug_on THEN
567: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',
568: WSH_DEBUG_SV.C_EXCEP_LEVEL);
569: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
570: END IF;
571:
572: WHEN OTHERS THEN
573: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 573: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

569: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
570: END IF;
571:
572: WHEN OTHERS THEN
573: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
574: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
575: FND_MSG_PUB.Count_And_Get (
576: p_count => x_msg_count,
577: p_data => x_msg_data,

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

570: END IF;
571:
572: WHEN OTHERS THEN
573: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
574: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
575: FND_MSG_PUB.Count_And_Get (
576: p_count => x_msg_count,
577: p_data => x_msg_data,
578: p_encoded => FND_API.G_FALSE);