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.18 2011/02/21 09:35:54 brana 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 2417: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.IS_ACTION_ENABLED');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 4980: l_has_outbound_deliveries := WSH_TRIP_VALIDATIONS.has_outbound_deliveries

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

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

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

Line 4992: l_has_inbound_deliveries := WSH_TRIP_VALIDATIONS.has_inbound_deliveries

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

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

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

Line 6148: END WSH_TRIP_VALIDATIONS;

6144: END IF;
6145:
6146: END Validate_Stop_Dates;
6147:
6148: END WSH_TRIP_VALIDATIONS;