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_DELIVERY_VALIDATIONS dependencies on WSH_DELIVERY_VALIDATIONS

Line 1: PACKAGE BODY WSH_DELIVERY_VALIDATIONS as

1: PACKAGE BODY WSH_DELIVERY_VALIDATIONS as
2: /* $Header: WSHDEVLB.pls 120.22.12010000.2 2008/09/26 08:10:32 sankarun ship $ */
3: --6156495 : A global variable added to store the value of actual_departure_date
4: G_ACT_DEPT_DATE DATE;
5:

Line 25: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_DELIVERY_VALIDATIONS';

21: --
22: -----------------------------------------------------------------------------
23:
24: --
25: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_DELIVERY_VALIDATIONS';
26: --
27:
28:
29: /* The following 2 global variables added as part of Ship Message Customization

Line 146: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_SHIP_SET');

142: END IF;
143: --
144: EXCEPTION
145: WHEN others THEN
146: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_SHIP_SET');
147: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
148:
149: --
150: -- Debug Statements

Line 360: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_SMC');

356: END IF;
357: --
358: EXCEPTION
359: WHEN others THEN
360: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_SMC');
361: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
362:
363: --
364: -- Debug Statements

Line 460: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_ARRIVAL_SET');

456: END IF;
457: --
458: EXCEPTION
459: WHEN others THEN
460: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_ARRIVAL_SET');
461: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
462:
463: --
464: -- Debug Statements

Line 535: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_DEL_NOT_I_T');

531: END IF;
532: --
533: EXCEPTION
534: WHEN others THEN
535: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_DEL_NOT_I_T');
536: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
537:
538: --
539: -- Debug Statements

Line 606: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_RELEASED_LINES');

602: END IF;
603: --
604: EXCEPTION
605: WHEN others THEN
606: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_RELEASED_LINES');
607: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
608:
609: --
610: -- Debug Statements

Line 685: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_DEL_UNPACKED');

681: END IF;
682: --
683: EXCEPTION
684: WHEN others THEN
685: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_DEL_UNPACKED');
686: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
687:
688: --
689: -- Debug Statements

Line 766: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_DEL_OVERFILLED');

762: END IF;
763: --
764: EXCEPTION
765: WHEN others THEN
766: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_DEL_OVERFILLED');
767: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
768:
769: --
770: -- Debug Statements

Line 848: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_DEL_UNDERFILLED');

844: END IF;
845: --
846: EXCEPTION
847: WHEN others THEN
848: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_DEL_UNDERFILLED');
849: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
850:
851: --
852: -- Debug Statements

Line 926: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_DEL_FINAL_DEST');

922: END IF;
923: --
924: EXCEPTION
925: WHEN others THEN
926: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_DEL_FINAL_DEST');
927: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
928:
929: --
930: -- Debug Statements

Line 1141: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_CALENDAR');

1137: END IF;
1138: --
1139: EXCEPTION
1140: WHEN others THEN
1141: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_CALENDAR');
1142: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1143:
1144: --
1145: -- Debug Statements

Line 1546: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_PLAN');

1542: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_FREIGHT_CODE');
1543: END IF;
1544: --
1545: WHEN others THEN
1546: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_PLAN');
1547: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1548:
1549: --
1550: -- Debug Statements

Line 1658: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_UNPLAN');

1654: END IF;
1655: --
1656: EXCEPTION
1657: WHEN others THEN
1658: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_UNPLAN');
1659: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1660:
1661: --
1662: -- Debug Statements

Line 1802: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_UNPLAN');

1798: END IF;
1799: --
1800: EXCEPTION
1801: WHEN others THEN
1802: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_UNPLAN');
1803: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1804:
1805: --
1806: -- Debug Statements

Line 2361: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_ASSIGN_TRIP');

2357: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:TRIP_DIFFIGNORE');
2358: END IF;
2359:
2360: WHEN others THEN
2361: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_ASSIGN_TRIP');
2362: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2363:
2364: --
2365: -- Debug Statements

Line 2514: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_ASSIGN_TRIP');

2510: END IF;
2511: --
2512: EXCEPTION
2513: WHEN others THEN
2514: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_ASSIGN_TRIP');
2515: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2516:
2517: --
2518: -- Debug Statements

Line 2758: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_PACK');

2754: END IF;
2755: --
2756: EXCEPTION
2757: WHEN others THEN
2758: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_PACK');
2759: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2760:
2761: --
2762: -- Debug Statements

Line 3186: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_DETAIL_FOR_CONFIRM');

3182: END IF;
3183: --
3184: EXCEPTION
3185: WHEN others THEN
3186: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_DETAIL_FOR_CONFIRM');
3187: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3188:
3189: IF C_GET_SERIAL%ISOPEN THEN
3190: CLOSE C_GET_SERIAL;

Line 3393: WSH_DEBUG_SV.log(l_module_name,'Going to exit wsh_delivery_validations due to message severity set to (SMC) ',g_break_smc_severity);

3389: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3390: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
3391: WSH_NEW_DELIVERY_ACTIONS.g_break_ship_set_or_smc := nvl(WSH_NEW_DELIVERY_ACTIONS.g_break_ship_set_or_smc,0) + 1;
3392: IF l_debug_on THEN
3393: WSH_DEBUG_SV.log(l_module_name,'Going to exit wsh_delivery_validations due to message severity set to (SMC) ',g_break_smc_severity);
3394: WSH_DEBUG_SV.pop(l_module_name);
3395: END IF;
3396: RETURN;
3397: Else

Line 3451: WSH_DEBUG_SV.log(l_module_name,'Going to exit wsh_delivery_validations due to message severity set to (ShipSet) ',g_break_ship_set_severity);

3447: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3448: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
3449: WSH_NEW_DELIVERY_ACTIONS.g_break_ship_set_or_smc := nvl(WSH_NEW_DELIVERY_ACTIONS.g_break_ship_set_or_smc,0) + 1;
3450: IF l_debug_on THEN
3451: WSH_DEBUG_SV.log(l_module_name,'Going to exit wsh_delivery_validations due to message severity set to (ShipSet) ',g_break_ship_set_severity);
3452: WSH_DEBUG_SV.pop(l_module_name);
3453: END IF;
3454: RETURN;
3455: Else

Line 3535: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_CONFIRM');

3531: END IF;
3532: --
3533: EXCEPTION
3534: WHEN others THEN
3535: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_CONFIRM');
3536: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3537:
3538: --
3539: -- Debug Statements

Line 3635: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_REOPEN');

3631: END IF;
3632: --
3633: EXCEPTION
3634: WHEN others THEN
3635: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_REOPEN');
3636: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3637:
3638: --
3639: -- Debug Statements

Line 3774: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_INTRANSIT');

3770: END IF;
3771: --
3772: EXCEPTION
3773: WHEN others THEN
3774: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_INTRANSIT');
3775: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3776:
3777: --
3778: -- Debug Statements

Line 4102: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_CLOSE');

4098: END IF;
4099: --
4100: EXCEPTION
4101: WHEN others THEN
4102: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_CLOSE');
4103: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4104:
4105: --
4106: -- Debug Statements

Line 4549: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.Check_Close',l_module_name);

4545: --
4546: WHEN OTHERS THEN
4547:
4548: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4549: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.Check_Close',l_module_name);
4550: --
4551: IF l_debug_on THEN
4552: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4553: END IF;

Line 4844: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_DELETE_DELIVERY');

4840: IF (freight_costs_exist%ISOPEN) THEN
4841: CLOSE freight_costs_exist;
4842: END IF;
4843:
4844: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_DELETE_DELIVERY');
4845: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4846:
4847: IF l_debug_on THEN
4848: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 5000: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_CHANGE_CARRIER');

4996: END IF;
4997: --
4998: EXCEPTION
4999: WHEN others THEN
5000: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_CHANGE_CARRIER');
5001: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5002:
5003: --
5004: -- Debug Statements

Line 5570: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.get_disabled_list');

5566: END IF;
5567: IF (has_delivery_lines%ISOPEN) THEN
5568: CLOSE has_delivery_lines;
5569: END IF;
5570: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.get_disabled_list');
5571: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5572:
5573: --
5574: -- Debug Statements

Line 5712: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.Check_SS_Imp_Pending');

5708: return l_lines_exist;
5709:
5710: EXCEPTION
5711: WHEN OTHERS THEN
5712: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.Check_SS_Imp_Pending');
5713: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5714: --
5715: -- Debug Statements
5716: --

Line 6123: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_DELIVERY_FOR_TOLERANCE');

6119: WHEN others THEN
6120: if c_total_line_quantities%ISOPEN THEN
6121: close c_total_line_quantities ;
6122: end if ;
6123: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_DELIVERY_FOR_TOLERANCE');
6124: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6125:
6126: --
6127: -- Debug Statements

Line 6208: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.Del_Assigned_To_Trip');

6204: IF check_assigned%ISOPEN THEN
6205: CLOSE check_assigned;
6206: END IF;
6207: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6208: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.Del_Assigned_To_Trip');
6209: --
6210: -- Debug Statements
6211: --
6212: IF l_debug_on THEN

Line 9757: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.get_disabled_list', l_module_name);

9753: CLOSE c_tbl_rec;
9754: END IF;
9755:
9756: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
9757: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.get_disabled_list', l_module_name);
9758: IF l_debug_on THEN
9759: WSH_DEBUG_SV.log(l_module_name,'Error:',SUBSTR(SQLERRM,1,200));
9760: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
9761: END IF;

Line 10188: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.get_disabled_list', l_module_name);

10184: END IF;
10185: EXCEPTION
10186: WHEN OTHERS THEN
10187: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
10188: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.get_disabled_list', l_module_name);
10189: IF l_debug_on THEN
10190: WSH_DEBUG_SV.log(l_module_name,'Error:',SUBSTR(SQLERRM,1,200));
10191: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
10192: END IF;

Line 10354: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.DERIVE_DELIVERY_UOM');

10350: END IF;
10351: --
10352: WHEN OTHERS THEN
10353: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10354: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.DERIVE_DELIVERY_UOM');
10355: --
10356: IF l_debug_on THEN
10357: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
10358: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 10454: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.VALIDATE_ROUTED_EXPORT_TXN');

10450: --
10451: WHEN OTHERS THEN
10452: ROLLBACK TO VALIDATE_ROUTED_EXPORT_TXN;
10453: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10454: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.VALIDATE_ROUTED_EXPORT_TXN');
10455: --
10456: IF l_debug_on THEN
10457: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
10458: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 10551: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.DERIVE_NUMBER_OF_LPN');

10547: --
10548: WHEN OTHERS THEN
10549: ROLLBACK TO DERIVE_NUMBER_OF_LPN;
10550: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10551: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.DERIVE_NUMBER_OF_LPN');
10552: --
10553: IF l_debug_on THEN
10554: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
10555: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 10712: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHK_DUP_PICKUP_DROPOFF_LOCNS');

10708: END IF;
10709: --
10710: WHEN OTHERS THEN
10711: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10712: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHK_DUP_PICKUP_DROPOFF_LOCNS');
10713: --
10714: IF l_debug_on THEN
10715: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
10716: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 10852: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_VALIDATIONS.Check_ITM_REQD');

10848:
10849: WHEN OTHERS THEN
10850: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
10851: WSH_UTIL_CORE.add_message (x_return_status);
10852: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_VALIDATIONS.Check_ITM_REQD');
10853: --
10854: IF l_debug_on THEN
10855: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
10856: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 10945: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_VALIDATIONS.Log_ITM_Exception');

10941:
10942: WHEN OTHERS THEN
10943: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
10944: WSH_UTIL_CORE.add_message (x_return_status);
10945: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_VALIDATIONS.Log_ITM_Exception');
10946: --
10947: IF l_debug_on THEN
10948: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
10949: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 10957: , x_exceptions_tab OUT NOCOPY wsh_delivery_validations.exception_rec_Tab_type

10953:
10954: PROCEDURE check_exception(
10955: p_deliveries_tab IN wsh_util_core.id_tab_type
10956: , x_exceptions_exist OUT NOCOPY VARCHAR2
10957: , x_exceptions_tab OUT NOCOPY wsh_delivery_validations.exception_rec_Tab_type
10958: , x_return_status OUT NOCOPY VARCHAR2)
10959: IS
10960: --
10961: l_debug_on BOOLEAN;

Line 11021: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_VALIDATIONS.check_exception','WSH_DELIVERY_VALIDATIONS');

11017: IF c_check_exception%isopen then
11018: Close c_check_exception;
11019: END IF;
11020: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
11021: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_VALIDATIONS.check_exception','WSH_DELIVERY_VALIDATIONS');
11022: IF l_debug_on THEN
11023: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
11024: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
11025: END IF;

Line 11097: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.has_lines',l_module_name);

11093: RETURN(l_has_lines);
11094: --}
11095: EXCEPTION
11096: WHEN OTHERS THEN
11097: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.has_lines',l_module_name);
11098: --
11099: IF l_debug_on THEN
11100: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');
11101: END IF;

Line 11347: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.check_inTransit',l_module_name);

11343: --
11344: WHEN OTHERS THEN
11345:
11346: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
11347: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.check_inTransit',l_module_name);
11348: --
11349: IF l_debug_on THEN
11350: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
11351: END IF;

Line 11527: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.get_shipping_control',l_module_name);

11523: --
11524: WHEN OTHERS THEN
11525:
11526: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
11527: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.get_shipping_control',l_module_name);
11528: --
11529: IF l_debug_on THEN
11530: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
11531: END IF;

Line 12725: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERY_VALIDATIONS.GET_TRIP_INFORMATION', l_module_name);

12721: WHEN Others THEN
12722: IF (c_get_trip_info%ISOPEN) THEN
12723: CLOSE c_get_trip_info;
12724: END IF;
12725: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERY_VALIDATIONS.GET_TRIP_INFORMATION', l_module_name);
12726: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
12727:
12728: IF l_debug_on THEN
12729: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 12868: END WSH_DELIVERY_VALIDATIONS;

12864: END GET_DELIVERY_INFORMATION;
12865:
12866: --END OTM R12
12867:
12868: END WSH_DELIVERY_VALIDATIONS;