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.35.12020000.2 2013/03/14 16:13:09 suppal 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 365: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_SMC');

361: END IF;
362: --
363: EXCEPTION
364: WHEN others THEN
365: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_SMC');
366: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
367:
368: --
369: -- Debug Statements

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

461: END IF;
462: --
463: EXCEPTION
464: WHEN others THEN
465: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_ARRIVAL_SET');
466: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
467:
468: --
469: -- Debug Statements

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

536: END IF;
537: --
538: EXCEPTION
539: WHEN others THEN
540: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_DEL_NOT_I_T');
541: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
542:
543: --
544: -- Debug Statements

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

607: END IF;
608: --
609: EXCEPTION
610: WHEN others THEN
611: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_RELEASED_LINES');
612: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
613:
614: --
615: -- Debug Statements

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

686: END IF;
687: --
688: EXCEPTION
689: WHEN others THEN
690: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_DEL_UNPACKED');
691: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
692:
693: --
694: -- Debug Statements

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

767: END IF;
768: --
769: EXCEPTION
770: WHEN others THEN
771: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_DEL_OVERFILLED');
772: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
773:
774: --
775: -- Debug Statements

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

849: END IF;
850: --
851: EXCEPTION
852: WHEN others THEN
853: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_DEL_UNDERFILLED');
854: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
855:
856: --
857: -- Debug Statements

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

927: END IF;
928: --
929: EXCEPTION
930: WHEN others THEN
931: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_DEL_FINAL_DEST');
932: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
933:
934: --
935: -- Debug Statements

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

1162: END IF;
1163: --
1164: EXCEPTION
1165: WHEN others THEN
1166: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_CALENDAR');
1167: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1168:
1169: --
1170: -- Debug Statements

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

1582: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_FREIGHT_CODE');
1583: END IF;
1584: --
1585: WHEN others THEN
1586: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_PLAN');
1587: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1588:
1589: --
1590: -- Debug Statements

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

1694: END IF;
1695: --
1696: EXCEPTION
1697: WHEN others THEN
1698: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_UNPLAN');
1699: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1700:
1701: --
1702: -- Debug Statements

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

1838: END IF;
1839: --
1840: EXCEPTION
1841: WHEN others THEN
1842: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_UNPLAN');
1843: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1844:
1845: --
1846: -- Debug Statements

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

2397: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:TRIP_DIFFIGNORE');
2398: END IF;
2399:
2400: WHEN others THEN
2401: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_ASSIGN_TRIP');
2402: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2403:
2404: --
2405: -- Debug Statements

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

2550: END IF;
2551: --
2552: EXCEPTION
2553: WHEN others THEN
2554: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_ASSIGN_TRIP');
2555: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2556:
2557: --
2558: -- Debug Statements

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

2794: END IF;
2795: --
2796: EXCEPTION
2797: WHEN others THEN
2798: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_PACK');
2799: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2800:
2801: --
2802: -- Debug Statements

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

3256: END IF;
3257: --
3258: EXCEPTION
3259: WHEN others THEN
3260: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_DETAIL_FOR_CONFIRM');
3261: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3262:
3263: IF C_GET_SERIAL%ISOPEN THEN
3264: CLOSE C_GET_SERIAL;

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

3465: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3466: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
3467: WSH_NEW_DELIVERY_ACTIONS.g_break_ship_set_or_smc := nvl(WSH_NEW_DELIVERY_ACTIONS.g_break_ship_set_or_smc,0) + 1;
3468: IF l_debug_on THEN
3469: WSH_DEBUG_SV.log(l_module_name,'Going to exit wsh_delivery_validations due to message severity set to (SMC) ',g_break_smc_severity);
3470: WSH_DEBUG_SV.pop(l_module_name);
3471: END IF;
3472: RETURN;
3473: Else

Line 3527: 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);

3523: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3524: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
3525: WSH_NEW_DELIVERY_ACTIONS.g_break_ship_set_or_smc := nvl(WSH_NEW_DELIVERY_ACTIONS.g_break_ship_set_or_smc,0) + 1;
3526: IF l_debug_on THEN
3527: 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);
3528: WSH_DEBUG_SV.pop(l_module_name);
3529: END IF;
3530: RETURN;
3531: Else

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

3621: END IF;
3622: --
3623: EXCEPTION
3624: WHEN others THEN
3625: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_CONFIRM');
3626: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3627:
3628: --
3629: -- Debug Statements

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

3721: END IF;
3722: --
3723: EXCEPTION
3724: WHEN others THEN
3725: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_REOPEN');
3726: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3727:
3728: --
3729: -- Debug Statements

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

3860: END IF;
3861: --
3862: EXCEPTION
3863: WHEN others THEN
3864: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_INTRANSIT');
3865: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3866:
3867: --
3868: -- Debug Statements

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

4188: END IF;
4189: --
4190: EXCEPTION
4191: WHEN others THEN
4192: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_CLOSE');
4193: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4194:
4195: --
4196: -- Debug Statements

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

4635: --
4636: WHEN OTHERS THEN
4637:
4638: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4639: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.Check_Close',l_module_name);
4640: --
4641: IF l_debug_on THEN
4642: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4643: END IF;

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

4930: IF (freight_costs_exist%ISOPEN) THEN
4931: CLOSE freight_costs_exist;
4932: END IF;
4933:
4934: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_DELETE_DELIVERY');
4935: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4936:
4937: IF l_debug_on THEN
4938: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

5086: END IF;
5087: --
5088: EXCEPTION
5089: WHEN others THEN
5090: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_CHANGE_CARRIER');
5091: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5092:
5093: --
5094: -- Debug Statements

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

5669: END IF;
5670: IF (has_delivery_lines%ISOPEN) THEN
5671: CLOSE has_delivery_lines;
5672: END IF;
5673: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.get_disabled_list');
5674: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5675:
5676: --
5677: -- Debug Statements

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

5811: return l_lines_exist;
5812:
5813: EXCEPTION
5814: WHEN OTHERS THEN
5815: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.Check_SS_Imp_Pending');
5816: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5817: --
5818: -- Debug Statements
5819: --

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

6278: WHEN others THEN
6279: if c_total_line_quantities%ISOPEN THEN
6280: close c_total_line_quantities ;
6281: end if ;
6282: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHECK_DELIVERY_FOR_TOLERANCE');
6283: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6284:
6285: --
6286: -- Debug Statements

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

6363: IF check_assigned%ISOPEN THEN
6364: CLOSE check_assigned;
6365: END IF;
6366: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6367: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.Del_Assigned_To_Trip');
6368: --
6369: -- Debug Statements
6370: --
6371: IF l_debug_on THEN

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

10007: CLOSE c_tbl_rec;
10008: END IF;
10009:
10010: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
10011: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.get_disabled_list', l_module_name);
10012: IF l_debug_on THEN
10013: WSH_DEBUG_SV.log(l_module_name,'Error:',SUBSTR(SQLERRM,1,200));
10014: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
10015: END IF;

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

10438: END IF;
10439: EXCEPTION
10440: WHEN OTHERS THEN
10441: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
10442: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.get_disabled_list', l_module_name);
10443: IF l_debug_on THEN
10444: WSH_DEBUG_SV.log(l_module_name,'Error:',SUBSTR(SQLERRM,1,200));
10445: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
10446: END IF;

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

10622: END IF;
10623: --
10624: WHEN OTHERS THEN
10625: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10626: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.DERIVE_DELIVERY_UOM');
10627: --
10628: IF l_debug_on THEN
10629: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
10630: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

10722: --
10723: WHEN OTHERS THEN
10724: ROLLBACK TO VALIDATE_ROUTED_EXPORT_TXN;
10725: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10726: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.VALIDATE_ROUTED_EXPORT_TXN');
10727: --
10728: IF l_debug_on THEN
10729: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
10730: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

10819: --
10820: WHEN OTHERS THEN
10821: ROLLBACK TO DERIVE_NUMBER_OF_LPN;
10822: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10823: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.DERIVE_NUMBER_OF_LPN');
10824: --
10825: IF l_debug_on THEN
10826: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
10827: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

10980: END IF;
10981: --
10982: WHEN OTHERS THEN
10983: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10984: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.CHK_DUP_PICKUP_DROPOFF_LOCNS');
10985: --
10986: IF l_debug_on THEN
10987: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
10988: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

11120:
11121: WHEN OTHERS THEN
11122: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
11123: WSH_UTIL_CORE.add_message (x_return_status);
11124: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_VALIDATIONS.Check_ITM_REQD');
11125: --
11126: IF l_debug_on THEN
11127: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
11128: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

11213:
11214: WHEN OTHERS THEN
11215: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
11216: WSH_UTIL_CORE.add_message (x_return_status);
11217: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_VALIDATIONS.Log_ITM_Exception');
11218: --
11219: IF l_debug_on THEN
11220: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
11221: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 11229: , x_exceptions_tab OUT NOCOPY wsh_delivery_validations.exception_rec_Tab_type

11225:
11226: PROCEDURE check_exception(
11227: p_deliveries_tab IN wsh_util_core.id_tab_type
11228: , x_exceptions_exist OUT NOCOPY VARCHAR2
11229: , x_exceptions_tab OUT NOCOPY wsh_delivery_validations.exception_rec_Tab_type
11230: , x_return_status OUT NOCOPY VARCHAR2)
11231: IS
11232: --
11233: l_debug_on BOOLEAN;

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

11289: IF c_check_exception%isopen then
11290: Close c_check_exception;
11291: END IF;
11292: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
11293: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_VALIDATIONS.check_exception','WSH_DELIVERY_VALIDATIONS');
11294: IF l_debug_on THEN
11295: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
11296: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
11297: END IF;

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

11365: RETURN(l_has_lines);
11366: --}
11367: EXCEPTION
11368: WHEN OTHERS THEN
11369: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.has_lines',l_module_name);
11370: --
11371: IF l_debug_on THEN
11372: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');
11373: END IF;

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

11615: --
11616: WHEN OTHERS THEN
11617:
11618: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
11619: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.check_inTransit',l_module_name);
11620: --
11621: IF l_debug_on THEN
11622: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
11623: END IF;

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

11795: --
11796: WHEN OTHERS THEN
11797:
11798: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
11799: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.get_shipping_control',l_module_name);
11800: --
11801: IF l_debug_on THEN
11802: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
11803: END IF;

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

13000: WHEN Others THEN
13001: IF (c_get_trip_info%ISOPEN) THEN
13002: CLOSE c_get_trip_info;
13003: END IF;
13004: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERY_VALIDATIONS.GET_TRIP_INFORMATION', l_module_name);
13005: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
13006:
13007: IF l_debug_on THEN
13008: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 13149: END WSH_DELIVERY_VALIDATIONS;

13145: END GET_DELIVERY_INFORMATION;
13146:
13147: --END OTM R12
13148:
13149: END WSH_DELIVERY_VALIDATIONS;