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

Line 263: p_delivery_id_tab IN wsh_util_core.id_tab_type,

259: ( p_api_version_number IN NUMBER,
260: p_init_msg_list IN VARCHAR2,
261: p_commit IN VARCHAR2 , -- default fnd_api.g_false
262: p_action_prms IN WSH_INTERFACE_EXT_GRP.del_action_parameters_rectype,
263: p_delivery_id_tab IN wsh_util_core.id_tab_type,
264: x_delivery_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.Del_Action_Out_Rec_Type,
265: x_return_status OUT NOCOPY VARCHAR2,
266: x_msg_count OUT NOCOPY NUMBER,
267: x_msg_data OUT NOCOPY VARCHAR2)

Line 295: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

291: --
292: EXCEPTION
293: --
294: WHEN OTHERS THEN
295: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
296: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.DELIVERY_ACTION');
297: --
298: END Delivery_Action;
299:

Line 296: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.DELIVERY_ACTION');

292: EXCEPTION
293: --
294: WHEN OTHERS THEN
295: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
296: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.DELIVERY_ACTION');
297: --
298: END Delivery_Action;
299:
300: Procedure Map_Del_InRecType(

Line 543: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

539: --
540: EXCEPTION
541: --
542: WHEN OTHERS THEN
543: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
544: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.CREATE_UPDATE_DELIVERY');
545: --
546:
547: END Create_Update_Delivery;

Line 544: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.CREATE_UPDATE_DELIVERY');

540: EXCEPTION
541: --
542: WHEN OTHERS THEN
543: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
544: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.CREATE_UPDATE_DELIVERY');
545: --
546:
547: END Create_Update_Delivery;
548: --========================================================================

Line 619: p_detail_id_tab IN WSH_UTIL_CORE.id_tab_type,

615: x_msg_count OUT NOCOPY NUMBER,
616: x_msg_data OUT NOCOPY VARCHAR2,
617:
618: -- Procedure specific Parameters
619: p_detail_id_tab IN WSH_UTIL_CORE.id_tab_type,
620: p_action_prms IN WSH_INTERFACE_EXT_GRP.det_action_parameters_rec_type,
621: x_action_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.det_action_out_rec_type
622: ) IS
623:

Line 652: WSH_UTIL_CORE.default_handler('WSH_INTERFACE_EXT_GRP.Delivery_Detail_Action');

648: --
649: EXCEPTION
650: --
651: WHEN OTHERS THEN
652: WSH_UTIL_CORE.default_handler('WSH_INTERFACE_EXT_GRP.Delivery_Detail_Action');
653: ROLLBACK TO DEL_DETAIL_ACTION_WRAP_GRP;
654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
655: --
656: END Delivery_Detail_Action;

Line 918: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

914: AND (p_detail_info_tab(i).replenishment_status <> 'C') )THEN
915: --{
916: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
917: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','replenishment_status');
918: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
919: wsh_util_core.add_message(x_return_status);
920: return;
921: --}
922: END IF;

Line 919: wsh_util_core.add_message(x_return_status);

915: --{
916: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
917: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','replenishment_status');
918: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
919: wsh_util_core.add_message(x_return_status);
920: return;
921: --}
922: END IF;
923: --}

Line 950: WSH_UTIL_CORE.default_handler('WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail');

946:
947: --
948: EXCEPTION
949: WHEN OTHERS THEN
950: WSH_UTIL_CORE.default_handler('WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail');
951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
952: END Create_Update_Delivery_Detail;
953:
954:

Line 1007: p_entity_id_tab IN wsh_util_core.id_tab_type,

1003: PROCEDURE Trip_Action
1004: ( p_api_version_number IN NUMBER,
1005: p_init_msg_list IN VARCHAR2,
1006: p_commit IN VARCHAR2,
1007: p_entity_id_tab IN wsh_util_core.id_tab_type,
1008: p_action_prms IN WSH_INTERFACE_EXT_GRP.trip_action_parameters_rectype,
1009: x_trip_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.tripActionOutRecType,
1010: x_return_status OUT NOCOPY VARCHAR2,
1011: x_msg_count OUT NOCOPY NUMBER,

Line 1037: wsh_util_core.default_handler('WSH_TRIPS_GRP.TRIP_ACTION');

1033: map_tripActionOutRecType(l_tripActionOutRecType, x_trip_out_rec);
1034:
1035: EXCEPTION
1036: WHEN OTHERS THEN
1037: wsh_util_core.default_handler('WSH_TRIPS_GRP.TRIP_ACTION');
1038:
1039: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1040:
1041: END Trip_Action;

Line 1039: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1035: EXCEPTION
1036: WHEN OTHERS THEN
1037: wsh_util_core.default_handler('WSH_TRIPS_GRP.TRIP_ACTION');
1038:
1039: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1040:
1041: END Trip_Action;
1042:
1043:

Line 1083: p_entity_id_tab IN wsh_util_core.id_tab_type,

1079: PROCEDURE Stop_Action
1080: ( p_api_version_number IN NUMBER,
1081: p_init_msg_list IN VARCHAR2,
1082: p_commit IN VARCHAR2,
1083: p_entity_id_tab IN wsh_util_core.id_tab_type,
1084: p_action_prms IN WSH_INTERFACE_EXT_GRP.stop_action_parameters_rectype,
1085: x_stop_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.stopActionOutRecType,
1086: x_return_status OUT NOCOPY VARCHAR2,
1087: x_msg_count OUT NOCOPY NUMBER,

Line 1114: wsh_util_core.default_handler('WSH_TRIP_STOPS_GRP.STOP_ACTION');

1110: map_stopActionOutRecType(l_stopActionOutRecType, x_stop_out_rec);
1111:
1112: EXCEPTION
1113: WHEN OTHERS THEN
1114: wsh_util_core.default_handler('WSH_TRIP_STOPS_GRP.STOP_ACTION');
1115:
1116: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1117:
1118: END Stop_Action;

Line 1116: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1112: EXCEPTION
1113: WHEN OTHERS THEN
1114: wsh_util_core.default_handler('WSH_TRIP_STOPS_GRP.STOP_ACTION');
1115:
1116: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1117:
1118: END Stop_Action;
1119:
1120: --heali

Line 1288: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1284: map_stop_out_tab_type(l_stop_out_tab_type, x_stop_out_tab);
1285: --
1286: EXCEPTION
1287: WHEN OTHERS THEN
1288: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1289: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.CREATE_UPDATE_STOP');
1290: --
1291: END Create_Update_Stop;
1292:

Line 1289: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.CREATE_UPDATE_STOP');

1285: --
1286: EXCEPTION
1287: WHEN OTHERS THEN
1288: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1289: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.CREATE_UPDATE_STOP');
1290: --
1291: END Create_Update_Stop;
1292:
1293:

Line 1448: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1444: map_trip_Out_Tab_Type(l_trip_Out_Tab_Type, x_Out_Tab);
1445:
1446: EXCEPTION
1447: WHEN OTHERS THEN
1448: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1449: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.CREATE_UPDATE_TRIP');
1450: --
1451: END Create_Update_Trip;
1452:

Line 1449: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.CREATE_UPDATE_TRIP');

1445:
1446: EXCEPTION
1447: WHEN OTHERS THEN
1448: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1449: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.CREATE_UPDATE_TRIP');
1450: --
1451: END Create_Update_Trip;
1452:
1453:

Line 1584: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1580: map_freight_out_tab_type(l_freight_out_tab_type, x_out_tab);
1581: --
1582: EXCEPTION
1583: WHEN OTHERS THEN
1584: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1585: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.CREATE_UPDATE_FREIGHT_COSTS');
1586: END Create_Update_Freight_costs;
1587: --heali
1588:

Line 1585: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.CREATE_UPDATE_FREIGHT_COSTS');

1581: --
1582: EXCEPTION
1583: WHEN OTHERS THEN
1584: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1585: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.CREATE_UPDATE_FREIGHT_COSTS');
1586: END Create_Update_Freight_costs;
1587: --heali
1588:
1589: PROCEDURE Get_Exceptions (

Line 1609: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1605:
1606: BEGIN
1607: --
1608: --
1609: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1610: --
1611: EXCEPTION
1612: WHEN OTHERS THEN
1613: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 1613: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1609: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1610: --
1611: EXCEPTION
1612: WHEN OTHERS THEN
1613: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1614: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.Get_Exceptions');
1615: END Get_Exceptions;
1616:
1617:

Line 1614: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.Get_Exceptions');

1610: --
1611: EXCEPTION
1612: WHEN OTHERS THEN
1613: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1614: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.Get_Exceptions');
1615: END Get_Exceptions;
1616:
1617:
1618: PROCEDURE Exception_Action (

Line 1636: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1632:
1633: BEGIN
1634: --
1635: --
1636: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1637: --
1638: EXCEPTION
1639: WHEN OTHERS THEN
1640: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 1640: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1636: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1637: --
1638: EXCEPTION
1639: WHEN OTHERS THEN
1640: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1641: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.Exception_Action');
1642: END Exception_Action;
1643:
1644:

Line 1641: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.Exception_Action');

1637: --
1638: EXCEPTION
1639: WHEN OTHERS THEN
1640: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1641: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.Exception_Action');
1642: END Exception_Action;
1643:
1644:
1645:

Line 1650: p_dlvy_leg_id_tab IN wsh_util_core.id_tab_type,

1646: PROCEDURE Delivery_Leg_Action(
1647: p_api_version_number IN NUMBER,
1648: p_init_msg_list IN VARCHAR2,
1649: p_commit IN VARCHAR2,
1650: p_dlvy_leg_id_tab IN wsh_util_core.id_tab_type,
1651: p_action_prms IN WSH_INTERFACE_EXT_GRP.dlvy_leg_action_prms_rectype,
1652: x_action_out_rec IN OUT NOCOPY WSH_INTERFACE_EXT_GRP.dlvy_leg_action_out_rec_type,
1653: x_return_status OUT NOCOPY VARCHAR2,
1654: x_msg_count OUT NOCOPY NUMBER,

Line 1661: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1657:
1658: BEGIN
1659: --
1660: --
1661: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1662: --
1663: EXCEPTION
1664: WHEN OTHERS THEN
1665: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 1665: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1661: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1662: --
1663: EXCEPTION
1664: WHEN OTHERS THEN
1665: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1666: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.Delivery_Leg_Action');
1667: END Delivery_Leg_Action;
1668:
1669:

Line 1666: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.Delivery_Leg_Action');

1662: --
1663: EXCEPTION
1664: WHEN OTHERS THEN
1665: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1666: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.Delivery_Leg_Action');
1667: END Delivery_Leg_Action;
1668:
1669:
1670: --OTM R12

Line 1694: l_otm_del_ids WSH_UTIL_CORE.id_tab_type;

1690: l_exception_name WSH_EXCEPTIONS.EXCEPTION_NAME%TYPE;
1691: l_severity WSH_EXCEPTIONS.SEVERITY%TYPE;
1692: l_return_status VARCHAR2(1);
1693: -- This table is used to pass delivery ids to Ignore_for_Plan during forced ship-confirm.
1694: l_otm_del_ids WSH_UTIL_CORE.id_tab_type;
1695: l_num_warn NUMBER;
1696: api_return_fail EXCEPTION;
1697:
1698: l_debug_on BOOLEAN;

Line 1716: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1712: WSH_DEBUG_SV.log(l_module_name, 'tms interface flag', p_tms_interface_flag);
1713: WSH_DEBUG_SV.log(l_module_name, 'trip id', p_trip_id);
1714: END IF;
1715:
1716: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1717:
1718: l_exception_name := NULL;
1719: l_severity := NULL;
1720: l_num_warn := 0;

Line 1746: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

1742: WSH_DEBUG_SV.log(l_module_name, 'exception name', l_exception_name);
1743: WSH_DEBUG_SV.log(l_module_name, 'severity', l_severity);
1744: END IF;
1745:
1746: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1747:
1748: IF l_debug_on THEN
1749: WSH_DEBUG_SV.logmsg(l_module_name, 'WSH_XC_UTIL.GET_OTM_DELIVERY_EXCEPTION procedure failed');
1750: END IF;

Line 1756: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

1752: RAISE api_return_fail;
1753:
1754: END IF;
1755:
1756: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1757: l_num_warn := l_num_warn + 1 ;
1758: END IF;
1759:
1760: IF (l_severity IS NULL OR l_severity = 'WARNING') THEN

Line 1771: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING, l_module_name);

1767: ELSE
1768: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME', p_delivery_name);
1769: END IF;
1770: l_num_warn := l_num_warn + 1;
1771: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING, l_module_name);
1772: END IF;
1773:
1774: l_otm_del_ids(1) := p_delivery_id;
1775:

Line 1790: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

1786: IF l_debug_on THEN
1787: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_TP_RELEASE.CHANGE_IGNOREPLAN_STATUS: ' || l_return_status);
1788: END IF;
1789:
1790: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1791:
1792: IF l_debug_on THEN
1793: WSH_DEBUG_SV.logmsg(l_module_name, 'WSH_TP_RELEASE.CHANGE_IGNOREPLAN_STATUS procedure failed');
1794: END IF;

Line 1797: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

1793: WSH_DEBUG_SV.logmsg(l_module_name, 'WSH_TP_RELEASE.CHANGE_IGNOREPLAN_STATUS procedure failed');
1794: END IF;
1795: RAISE api_return_fail;
1796:
1797: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1798: l_num_warn := l_num_warn + 1;
1799: END IF;
1800: END IF;
1801: END IF;

Line 1824: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

1820: WSH_DEBUG_SV.log(l_module_name, 'exception name', l_exception_name);
1821: WSH_DEBUG_SV.log(l_module_name, 'severity', l_severity);
1822: END IF;
1823:
1824: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1825:
1826: IF l_debug_on THEN
1827: WSH_DEBUG_SV.logmsg(l_module_name, 'WSH_XC_UTIL.GET_OTM_DELIVERY_EXCEPTION procedure failed');
1828: END IF;

Line 1834: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

1830: RAISE api_return_fail;
1831:
1832: END IF;
1833:
1834: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1835: l_num_warn := l_num_warn + 1 ;
1836: END IF;
1837:
1838: IF (l_severity IS NULL OR l_severity = 'WARNING') THEN

Line 1849: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING, l_module_name);

1845: ELSE
1846: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME', p_delivery_name);
1847: END IF;
1848: l_num_warn := l_num_warn + 1;
1849: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING, l_module_name);
1850: END IF;
1851: END IF;
1852: END IF;
1853: --Bug 8571352

Line 1854: IF (l_num_warn > 0 AND x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

1850: END IF;
1851: END IF;
1852: END IF;
1853: --Bug 8571352
1854: IF (l_num_warn > 0 AND x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1855: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1856: END IF;
1857:
1858: --

Line 1855: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1851: END IF;
1852: END IF;
1853: --Bug 8571352
1854: IF (l_num_warn > 0 AND x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1855: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1856: END IF;
1857:
1858: --
1859: -- Debug Statements

Line 1876: WSH_UTIL_CORE.Default_Handler('WSH_INTERFACE_EXT_GRP.OTM_PRE_SHIP_CONFIRM', l_module_name);

1872: END IF;
1873:
1874: WHEN Others THEN
1875:
1876: WSH_UTIL_CORE.Default_Handler('WSH_INTERFACE_EXT_GRP.OTM_PRE_SHIP_CONFIRM', l_module_name);
1877: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1878:
1879: IF l_debug_on THEN
1880: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1877: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1873:
1874: WHEN Others THEN
1875:
1876: WSH_UTIL_CORE.Default_Handler('WSH_INTERFACE_EXT_GRP.OTM_PRE_SHIP_CONFIRM', l_module_name);
1877: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1878:
1879: IF l_debug_on THEN
1880: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1881: WSH_DEBUG_SV.pop(l_module_name);