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_VALIDATIONS dependencies on WSH_TRIP_VALIDATIONS

Line 1: PACKAGE BODY WSH_TRIP_VALIDATIONS as

1: PACKAGE BODY WSH_TRIP_VALIDATIONS as
2: /* $Header: WSHTRVLB.pls 120.10.12000000.6 2007/01/26 20:56:27 rvishnuv ship $ */
3:
4: --
5: --3509004:public api changes

Line 29: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TRIP_VALIDATIONS';

25: --
26: -----------------------------------------------------------------------------
27:
28: --
29: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TRIP_VALIDATIONS';
30: --
31: PROCEDURE Check_Plan ( p_trip_id IN NUMBER,
32: x_return_status OUT NOCOPY VARCHAR2,
33: p_caller IN VARCHAR2) IS

Line 272: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.CHECK_PLAN');

268: END IF;
269: --
270: EXCEPTION
271: WHEN others THEN
272: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.CHECK_PLAN');
273: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
274: IF l_debug_on THEN
275: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
276: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 363: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.CHECK_UNPLAN');

359: END IF;
360: --
361: EXCEPTION
362: WHEN others THEN
363: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.CHECK_UNPLAN');
364: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
365:
366: --
367: -- Debug Statements

Line 457: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.Dropoff_Del_Intransit');

453: END IF;
454: --
455: EXCEPTION
456: WHEN others THEN
457: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.Dropoff_Del_Intransit');
458: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
459: IF prev_stop_info%ISOPEN THEN
460: CLOSE prev_stop_info;
461: END IF;

Line 652: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.Check_Prev_Stop_Close');

648: WHEN others THEN
649: IF c_linked_stop%ISOPEN THEN
650: CLOSE c_linked_stop;
651: END IF;
652: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.Check_Prev_Stop_Close');
653: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
654: IF prev_stop_info%ISOPEN THEN
655: CLOSE prev_stop_info;
656: END IF;

Line 739: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.CHECK_TRIP_CLOSE');

735: END IF;
736: --
737: EXCEPTION
738: WHEN others THEN
739: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.CHECK_TRIP_CLOSE');
740: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
741: IF open_stop%ISOPEN THEN
742: CLOSE open_stop;
743: END IF;

Line 935: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.CHECK_TRIP_DELETE');

931: END IF;
932: --
933: EXCEPTION
934: WHEN others THEN
935: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.CHECK_TRIP_DELETE');
936: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
937:
938: --
939: -- Debug Statements

Line 1052: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.CHECK_CHANGE_CARRIER');

1048: END IF;
1049: --
1050: EXCEPTION
1051: WHEN others THEN
1052: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.CHECK_CHANGE_CARRIER');
1053: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1054:
1055: --
1056: -- Debug Statements

Line 1186: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.CHECK_STOP_ARRIVE');

1182: END IF;
1183: --
1184: EXCEPTION
1185: WHEN others THEN
1186: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.CHECK_STOP_ARRIVE');
1187: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1188:
1189: --
1190: -- Debug Statements

Line 1329: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.CHECK_STOP_CLOSE');

1325: END IF;
1326: --
1327: EXCEPTION
1328: WHEN others THEN
1329: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.CHECK_STOP_CLOSE');
1330: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1331:
1332: --
1333: -- Debug Statements

Line 1627: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.CHECK_STOP_DELETE');

1623: END IF;
1624: --
1625: EXCEPTION
1626: WHEN others THEN
1627: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.CHECK_STOP_DELETE');
1628: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1629:
1630: --
1631: -- Debug Statements

Line 2414: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.IS_ACTION_ENABLED');

2410: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:error_in_init_actions');
2411: END IF;
2412:
2413: WHEN OTHERS THEN
2414: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.IS_ACTION_ENABLED');
2415: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2416: IF l_debug_on THEN
2417: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2418: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2507: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.VALIDATE_ARRIVE_AFTER_TRIP');

2503: END IF;
2504:
2505: EXCEPTION
2506: WHEN OTHERS THEN
2507: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.VALIDATE_ARRIVE_AFTER_TRIP');
2508: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2509: IF l_debug_on THEN
2510: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2511: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2616: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.VALIDATE_CONSOL_ALLOWED');

2612: END IF;
2613:
2614: EXCEPTION
2615: WHEN OTHERS THEN
2616: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.VALIDATE_CONSOL_ALLOWED');
2617: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2618: IF l_debug_on THEN
2619: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2620: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2978: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.ELIMINATE_DISPLAYONLY_FIELDS');

2974:
2975: EXCEPTION
2976: -- OTM 12, glog proj, no debug or x_return_status variable here
2977: WHEN OTHERS THEN
2978: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.ELIMINATE_DISPLAYONLY_FIELDS');
2979:
2980: END eliminate_displayonly_fields;
2981:
2982: /*----------------------------------------------------------

Line 3449: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.ENABLE_FROM_LIST');

3445:
3446: EXCEPTION
3447: -- OTM R12, glog proj, add when Others exception handler
3448: WHEN others THEN
3449: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.ENABLE_FROM_LIST');
3450: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3451:
3452: END enable_from_list;
3453:

Line 3942: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIP_VALIDATIONS.init_trip_actions_tbl'

3938:
3939: EXCEPTION
3940: -- OTM R12, glog proj
3941: WHEN OTHERS THEN
3942: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIP_VALIDATIONS.init_trip_actions_tbl'
3943: ,l_module_name);
3944: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3945: IF l_debug_on THEN
3946: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 4280: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.check_Close',l_module_name);

4276: --
4277: WHEN OTHERS THEN
4278:
4279: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4280: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.check_Close',l_module_name);
4281: --
4282: IF l_debug_on THEN
4283: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4284: END IF;

Line 4574: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.check_inTransit',l_module_name);

4570: --
4571: WHEN OTHERS THEN
4572:
4573: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4574: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.check_inTransit',l_module_name);
4575: --
4576: IF l_debug_on THEN
4577: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4578: END IF;

Line 4679: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.validate_trip_status', l_module_name);

4675: END IF;
4676: --
4677: WHEN OTHERS THEN
4678: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4679: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.validate_trip_status', l_module_name);
4680: IF l_debug_on THEN
4681: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4682: END IF;
4683: --}

Line 4786: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.has_outbound_deliveries', l_module_name);

4782: --}
4783: EXCEPTION
4784: --{
4785: WHEN OTHERS THEN
4786: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.has_outbound_deliveries', l_module_name);
4787: --
4788: IF l_debug_on THEN
4789: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4790: END IF;

Line 4896: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.has_inbound_deliveries', l_module_name);

4892: --}
4893: EXCEPTION
4894: --{
4895: WHEN OTHERS THEN
4896: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.has_inbound_deliveries', l_module_name);
4897: --
4898: IF l_debug_on THEN
4899: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4900: END IF;

Line 4973: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.has_outbound_deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);

4969: IF (p_trip_id IS NOT NULL)
4970: THEN
4971: --{
4972: IF l_debug_on THEN
4973: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.has_outbound_deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);
4974: END IF;
4975: --
4976: --
4977: l_has_outbound_deliveries := WSH_TRIP_VALIDATIONS.has_outbound_deliveries

Line 4977: l_has_outbound_deliveries := WSH_TRIP_VALIDATIONS.has_outbound_deliveries

4973: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.has_outbound_deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);
4974: END IF;
4975: --
4976: --
4977: l_has_outbound_deliveries := WSH_TRIP_VALIDATIONS.has_outbound_deliveries
4978: (
4979: p_trip_id => p_trip_id,
4980: p_stop_id => p_stop_id
4981: );

Line 4986: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.has_inbound_deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);

4982: --
4983: --
4984: IF l_debug_on THEN
4985: WSH_DEBUG_SV.log(l_module_name,'l_has_outbound_deliveries',l_has_outbound_deliveries);
4986: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.has_inbound_deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);
4987: END IF;
4988: --
4989: l_has_inbound_deliveries := WSH_TRIP_VALIDATIONS.has_inbound_deliveries
4990: (

Line 4989: l_has_inbound_deliveries := WSH_TRIP_VALIDATIONS.has_inbound_deliveries

4985: WSH_DEBUG_SV.log(l_module_name,'l_has_outbound_deliveries',l_has_outbound_deliveries);
4986: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.has_inbound_deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);
4987: END IF;
4988: --
4989: l_has_inbound_deliveries := WSH_TRIP_VALIDATIONS.has_inbound_deliveries
4990: (
4991: p_trip_id => p_trip_id,
4992: p_stop_id => p_stop_id
4993: );

Line 5023: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.has_mixed_deliveries', l_module_name);

5019: --}
5020: EXCEPTION
5021: --{
5022: WHEN OTHERS THEN
5023: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.has_mixed_deliveries', l_module_name);
5024: --
5025: IF l_debug_on THEN
5026: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5027: END IF;

Line 6145: END WSH_TRIP_VALIDATIONS;

6141: END IF;
6142:
6143: END Validate_Stop_Dates;
6144:
6145: END WSH_TRIP_VALIDATIONS;