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

Line 53: l_entity_id_tab wsh_util_core.id_tab_type;

49: l_api_version_number CONSTANT NUMBER := 1.0;
50: l_api_name CONSTANT VARCHAR2(30):= 'Trip_Action';
51: l_trip_out_rec WSH_TRIPS_GRP.tripActionOutRecType;
52: l_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
53: l_entity_id_tab wsh_util_core.id_tab_type;
54: l_num_warning NUMBER := 0;
55: l_num_errors NUMBER := 0;
56: l_return_status varchar2(1000);
57: l_report_set_id NUMBER;

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

109: wsh_util_validate.validate_trip_name( l_trip_id,
110: p_trip_name,
111: x_return_status);
112:
113: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
114: raise trip_action_error;
115: END IF;
116:
117: IF p_report_set_name IS NOT NULL

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

125: IF l_debug_on THEN
126: wsh_debug_sv.log (l_module_name,'l_report_set_id',l_report_set_id);
127: END IF;
128:
129: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
130: raise trip_action_error;
131: END IF;
132:
133: l_action_prms.report_set_id := l_report_set_id;

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

151: x_return_status => l_return_status,
152: x_msg_count => x_msg_count,
153: x_msg_data => x_msg_data);
154:
155: wsh_util_core.api_post_call(p_return_status =>l_return_status,
156: x_num_warnings =>l_num_warning,
157: x_num_errors =>l_num_errors);
158:
159: x_return_status := l_return_status;

Line 177: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('TRIP',p_action_code));

173:
174: WHEN trip_action_error THEN
175: FND_MESSAGE.SET_NAME('WSH','WSH_OI_TRIP_ACTION_ERROR');
176: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(l_trip_id));
177: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('TRIP',p_action_code));
178: wsh_util_core.add_message(x_return_status,l_module_name);
179: FND_MSG_PUB.Count_And_Get
180: ( p_count => x_msg_count
181: , p_data => x_msg_data

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

174: WHEN trip_action_error THEN
175: FND_MESSAGE.SET_NAME('WSH','WSH_OI_TRIP_ACTION_ERROR');
176: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(l_trip_id));
177: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('TRIP',p_action_code));
178: wsh_util_core.add_message(x_return_status,l_module_name);
179: FND_MSG_PUB.Count_And_Get
180: ( p_count => x_msg_count
181: , p_data => x_msg_data
182: ,p_encoded => FND_API.G_FALSE

Line 215: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

211: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_RET_STS_UNEXP_ERROR');
212: WSH_DEBUG_SV.pop(l_module_name);
213: END IF;
214:
215: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
216:
217: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
218: -- Get message count and data
219: FND_MSG_PUB.Count_And_Get

Line 217: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

213: END IF;
214:
215: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
216:
217: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
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 292: l_entity_id_tab wsh_util_core.id_tab_type;

288: l_api_version_number CONSTANT NUMBER := 1.0;
289: l_api_name CONSTANT VARCHAR2(30):= 'Trip_Action';
290: l_trip_out_rec WSH_TRIPS_GRP.tripActionOutRecType;
291: l_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
292: l_entity_id_tab wsh_util_core.id_tab_type;
293: l_num_warning NUMBER := 0;
294: l_num_errors NUMBER := 0;
295: l_return_status varchar2(1000);
296: l_report_set_id NUMBER;

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

357: wsh_util_validate.validate_trip_name( l_trip_id,
358: p_trip_name,
359: x_return_status);
360:
361: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
362: raise trip_action_error;
363: END IF;
364:
365:

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

371: p_report_set_name => p_action_param_rec.report_set_name,
372: x_return_status => x_return_status);
373:
374:
375: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
376: raise trip_action_error;
377: END IF;
378:
379: l_action_prms.report_set_id := l_report_set_id;

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

414: x_return_status => l_return_status,
415: x_msg_count => x_msg_count,
416: x_msg_data => x_msg_data);
417:
418: wsh_util_core.api_post_call(p_return_status =>l_return_status,
419: x_num_warnings =>l_num_warning,
420: x_num_errors =>l_num_errors);
421:
422: x_return_status := l_return_status;

Line 430: IF FND_API.to_boolean(p_commit) AND x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

426: , p_data => x_msg_data
427: ,p_encoded => FND_API.G_FALSE
428: );
429:
430: IF FND_API.to_boolean(p_commit) AND x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
431: COMMIT;
432: END IF;
433:
434: IF l_debug_on THEN

Line 444: FND_MESSAGE.SET_TOKEN('ACTION',wsh_util_core.get_action_meaning('TRIP', p_action_param_rec.action_code));

440:
441: WHEN trip_action_error THEN
442: FND_MESSAGE.SET_NAME('WSH','WSH_OI_TRIP_ACTION_ERROR');
443: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(l_trip_id));
444: FND_MESSAGE.SET_TOKEN('ACTION',wsh_util_core.get_action_meaning('TRIP', p_action_param_rec.action_code));
445: wsh_util_core.add_message(x_return_status,l_module_name);
446: FND_MSG_PUB.Count_And_Get
447: ( p_count => x_msg_count
448: , p_data => x_msg_data

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

441: WHEN trip_action_error THEN
442: FND_MESSAGE.SET_NAME('WSH','WSH_OI_TRIP_ACTION_ERROR');
443: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(l_trip_id));
444: FND_MESSAGE.SET_TOKEN('ACTION',wsh_util_core.get_action_meaning('TRIP', p_action_param_rec.action_code));
445: wsh_util_core.add_message(x_return_status,l_module_name);
446: FND_MSG_PUB.Count_And_Get
447: ( p_count => x_msg_count
448: , p_data => x_msg_data
449: ,p_encoded => FND_API.G_FALSE

Line 482: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

478: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_RET_STS_UNEXP_ERROR');
479: WSH_DEBUG_SV.pop(l_module_name);
480: END IF;
481:
482: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
483:
484: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
485: -- Get message count and data
486: FND_MSG_PUB.Count_And_Get

Line 484: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

480: END IF;
481:
482: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
483:
484: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
485: -- Get message count and data
486: FND_MSG_PUB.Count_And_Get
487: ( p_count => x_msg_count
488: , p_data => x_msg_data

Line 550: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

546: WSH_DEBUG_SV.log(l_module_name,'p_pub_trip_rec.TRIP_ID',p_pub_trip_rec.TRIP_ID);
547: WSH_DEBUG_SV.log(l_module_name,'p_pub_trip_rec.NAME',p_pub_trip_rec.NAME);
548: END IF;
549: --
550: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
551:
552: x_pvt_trip_rec.TRIP_ID := p_pub_trip_rec.TRIP_ID;
553: x_pvt_trip_rec.NAME := p_pub_trip_rec.NAME;
554: x_pvt_trip_rec.PLANNED_FLAG := FND_API.G_MISS_CHAR;

Line 606: WSH_UTIL_CORE.api_post_call(

602: IF l_debug_on THEN
603: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_freight_terms',l_return_status);
604: END IF;
605: --
606: WSH_UTIL_CORE.api_post_call(
607: p_return_status => l_return_status,
608: x_num_warnings => l_num_warnings,
609: x_num_errors => l_num_errors);
610: --

Line 661: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_FTE_INTEGRATION.map_trippub_to_pvt',l_module_name);

657: END IF;
658: --
659:
660: WHEN OTHERS THEN
661: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_FTE_INTEGRATION.map_trippub_to_pvt',l_module_name);
662: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
663: --
664: IF l_debug_on THEN
665: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 662: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

658: --
659:
660: WHEN OTHERS THEN
661: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_FTE_INTEGRATION.map_trippub_to_pvt',l_module_name);
662: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
663: --
664: IF l_debug_on THEN
665: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
666: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

737: p_pub_trip_rec => p_trip_info,
738: x_pvt_trip_rec => l_pvt_trip_rec,
739: x_return_status => x_return_status);
740:
741: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
742: raise FND_API.G_EXC_ERROR;
743: END IF;
744:
745: l_in_rec.caller:='WSH_PUB';

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

755: wsh_util_validate.validate_trip_name( l_pvt_trip_rec.trip_id,
756: l_pvt_trip_rec.name,
757: x_return_status);
758:
759: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
760: raise FND_API.G_EXC_ERROR;
761: END IF;
762: END IF;
763:

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

766: wsh_util_validate.validate_trip_name( l_pvt_trip_rec.arrive_after_trip_id,
767: l_pvt_trip_rec.arrive_after_trip_name,
768: x_return_status);
769:
770: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
771: raise FND_API.G_EXC_ERROR;
772: END IF;
773: END IF;
774:

Line 791: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS and l_Out_Tab.count > 0) THEN

787:
788: IF l_debug_on THEN
789: wsh_debug_sv.log (l_module_name,'WSH_INTERFACE_GRP.Create_Update_Trip x_return_status',x_return_status);
790: END IF;
791: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS and l_Out_Tab.count > 0) THEN
792: x_trip_id := l_out_tab(l_out_tab.FIRST).trip_id;
793: x_trip_name := l_out_tab(l_out_tab.FIRST).trip_name;
794: END IF;
795:

Line 806: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

802: END IF;
803:
804: EXCEPTION
805: WHEN FND_API.G_EXC_ERROR THEN
806: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
807: FND_MSG_PUB.Count_And_Get (
808: p_count => x_msg_count,
809: p_data => x_msg_data,
810: p_encoded => FND_API.G_FALSE);

Line 818: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

814: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
815: END IF;
816:
817: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
818: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
819: FND_MSG_PUB.Count_And_Get (
820: p_count => x_msg_count,
821: p_data => x_msg_data,
822: p_encoded => FND_API.G_FALSE);

Line 829: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

825: WSH_DEBUG_SV.C_EXCEP_LEVEL);
826: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
827: END IF;
828:
829: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
830: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
831: FND_MSG_PUB.Count_And_Get (
832: p_count => x_msg_count,
833: p_data => x_msg_data,

Line 830: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

826: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
827: END IF;
828:
829: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
830: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
831: FND_MSG_PUB.Count_And_Get (
832: p_count => x_msg_count,
833: p_data => x_msg_data,
834: p_encoded => FND_API.G_FALSE);

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

832: p_count => x_msg_count,
833: p_data => x_msg_data,
834: p_encoded => FND_API.G_FALSE);
835: IF l_debug_on THEN
836: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',
837: WSH_DEBUG_SV.C_EXCEP_LEVEL);
838: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
839: END IF;
840:

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

834: p_encoded => FND_API.G_FALSE);
835: IF l_debug_on THEN
836: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',
837: WSH_DEBUG_SV.C_EXCEP_LEVEL);
838: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
839: END IF;
840:
841: WHEN OTHERS THEN
842: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 842: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

838: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
839: END IF;
840:
841: WHEN OTHERS THEN
842: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
843: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
844: FND_MSG_PUB.Count_And_Get (
845: p_count => x_msg_count,
846: p_data => x_msg_data,

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

839: END IF;
840:
841: WHEN OTHERS THEN
842: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
843: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
844: FND_MSG_PUB.Count_And_Get (
845: p_count => x_msg_count,
846: p_data => x_msg_data,
847: p_encoded => FND_API.G_FALSE);