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.FTE_ACS_CACHE_PKG dependencies on FND_API

Line 234: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

230: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.get_fixed_key');
231:
232: IF l_debug_on THEN
233: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
234: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
235: END IF;
236: --
237: END get_fixed_key;
238:

Line 280: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

276: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.get_key_for_num');
277:
278: IF l_debug_on THEN
279: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
280: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
281: END IF;
282: --
283: END get_key_for_num;
284:

Line 322: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

318: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.get_key_for_char');
319:
320: IF l_debug_on THEN
321: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
322: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
323: END IF;
324: --
325: END get_key_for_char;
326:

Line 361: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

357: WHEN others THEN
358: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.get_key_for_null');
359: IF l_debug_on THEN
360: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
361: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
362: END IF;
363: --
364:
365: END get_key_for_null;

Line 446: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

442: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
443:
444: IF l_debug_on THEN
445: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
446: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
447: END IF;
448: --
449: END initialize_tables;
450:

Line 496: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

492: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
493:
494: IF l_debug_on THEN
495: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
496: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
497: END IF;
498: --
499: END delete_rule_caches;
500:

Line 557: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

553: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
554: --
555: IF l_debug_on THEN
556: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
557: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
558: END IF;
559: --
560: END refresh_cache;
561:

Line 631: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

627: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
628:
629: IF l_debug_on THEN
630: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
631: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
632: END IF;
633: --
634: END sort_priority_tab;
635:

Line 708: raise FND_API.G_EXC_UNEXPECTED_ERROR;

704: x_return_status => x_return_status);
705:
706: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
707: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
708: raise FND_API.G_EXC_UNEXPECTED_ERROR;
709: END IF;
710: END IF;
711: END IF;
712:

Line 725: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

721: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
722:
723: IF l_debug_on THEN
724: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
725: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
726: END IF;
727: --
728: END get_sorted_priority_tab;
729:

Line 884: raise FND_API.G_EXC_UNEXPECTED_ERROR;

880: x_return_status => x_return_status);
881:
882: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
883: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
884: raise FND_API.G_EXC_UNEXPECTED_ERROR;
885: END IF;
886: END IF;
887:
888: l_group_cache_rec.attribute_tab := l_group_attr;

Line 922: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

918: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
919:
920: IF l_debug_on THEN
921: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
922: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
923: END IF;
924: --
925: END add_group_to_group_cache;
926:

Line 997: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

993: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
994:
995: IF l_debug_on THEN
996: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
997: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
998: END IF;
999: --
1000: END add_to_non_range_cache;
1001:

Line 1120: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

1116: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1117:
1118: IF l_debug_on THEN
1119: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1120: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1121: END IF;
1122: END add_to_range_cache;
1123:
1124:

Line 1410: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1406: x_return_status => x_return_status);
1407:
1408: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1409: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1410: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1411: END IF;
1412: END IF;
1413:
1414: ELSIF (from_weight = g_num_absent) AND (to_weight = g_num_absent) THEN

Line 1424: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1420: x_return_status => x_return_status);
1421:
1422: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1423: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1424: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1425: END IF;
1426: END IF;
1427: ELSE
1428: RAISE FTE_CS_ERROR_INVALID_RANGE;

Line 1456: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1452: x_return_status => x_return_status);
1453:
1454: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1455: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1456: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1457: END IF;
1458: END IF;
1459:
1460: ELSIF (from_volume = g_num_absent) AND (to_volume = g_num_absent) THEN

Line 1469: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1465: x_return_status => x_return_status);
1466:
1467: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1468: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1469: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1470: END IF;
1471: END IF;
1472: ELSE
1473: RAISE FTE_CS_ERROR_INVALID_RANGE;

Line 1502: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1498: x_return_status => x_return_status );
1499:
1500: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1501: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1502: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1503: END IF;
1504: END IF;
1505:
1506: ELSIF (from_transit_time = g_num_absent) AND (to_transit_time = g_num_absent) THEN

Line 1515: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1511: x_return_status => x_return_status);
1512:
1513: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1514: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1515: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1516: END IF;
1517: END IF;
1518:
1519: ELSE

Line 1549: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1545: x_return_status => x_return_status );
1546:
1547: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1548: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1549: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1550: END IF;
1551: END IF;
1552:
1553: ELSIF (to_postal_low = g_val_absent) AND (to_postal_high = g_val_absent) THEN

Line 1562: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1558: x_return_status => x_return_status);
1559:
1560: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1561: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1562: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1563: END IF;
1564: END IF;
1565:
1566: --

Line 1588: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1584: x_return_status => x_return_status );
1585:
1586: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1587: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1588: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1589: END IF;
1590: END IF;
1591:
1592: ELSE

Line 1610: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1606: x_return_status => x_return_status );
1607:
1608: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1609: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1610: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1611: END IF;
1612: END IF;
1613: END IF;
1614: END IF;

Line 1639: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1635: x_return_status => x_return_status );
1636:
1637: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1638: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1639: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1640: END IF;
1641: END IF;
1642:
1643: ELSIF (from_postal_low = g_val_absent) AND (from_postal_high = g_val_absent) THEN

Line 1656: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1652: x_return_status => x_return_status);
1653:
1654: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1655: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1656: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1657: END IF;
1658: END IF;
1659:
1660: ELSIF (from_postal_low = g_val_absent) AND (from_postal_high <> g_val_absent) THEN

Line 1678: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1674: x_return_status => x_return_status );
1675:
1676: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1677: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1678: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1679: END IF;
1680: END IF;
1681:
1682: ELSE

Line 1700: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1696: x_return_status => x_return_status );
1697:
1698: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1699: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1700: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1701: END IF;
1702: END IF;
1703:
1704: END IF;

Line 1726: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1722: x_return_status => x_return_status );
1723:
1724: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1725: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1726: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1727: END IF;
1728: END IF;
1729:
1730: ELSE

Line 1738: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1734: x_return_status => x_return_status);
1735:
1736: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1737: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1738: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1739: END IF;
1740: END IF;
1741: END IF;
1742: END IF;

Line 1750: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1746: END LOOP;
1747:
1748: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1749: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1750: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1751: END IF;
1752: END IF;
1753:
1754: END IF;

Line 1773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1769: IF l_debug_on THEN
1770: WSH_DEBUG_SV.pop(l_module_name,'Attribute Range has either FROM or TO Only (Range is Invalid');
1771: END IF;
1772:
1773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1774:
1775: IF c_get_rule_restrictions%ISOPEN THEN
1776: CLOSE c_get_rule_restrictions;
1777: END IF;

Line 1784: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

1780: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1781: --
1782: IF l_debug_on THEN
1783: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1784: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1785: END IF;
1786: --
1787:
1788: WHEN others THEN

Line 1799: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

1795: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1796: --
1797: IF l_debug_on THEN
1798: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1799: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1800: END IF;
1801:
1802: END build_cache;
1803:

Line 1869: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

1865: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1866:
1867: IF l_debug_on THEN
1868: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1869: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1870: END IF;
1871: --
1872: END search_exact_cache_for_null;
1873:

Line 1945: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

1941: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.search_range_cache_for_null');
1942: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1943: IF l_debug_on THEN
1944: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1945: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1946: END IF;
1947: --
1948: END search_range_cache_for_null;
1949:

Line 2030: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

2026: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2027:
2028: IF l_debug_on THEN
2029: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2030: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2031: END IF;
2032: --
2033: END get_higher_breaks;
2034:

Line 2112: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

2108: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2109:
2110: IF l_debug_on THEN
2111: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2112: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2113: END IF;
2114:
2115: END get_lower_breaks;
2116:

Line 2162: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2158: x_return_status=> x_return_status);
2159:
2160: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2161: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2162: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2163: END IF;
2164: END IF;
2165: END IF;
2166:

Line 2196: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

2192: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2193:
2194: IF l_debug_on THEN
2195: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2196: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2197: END IF;
2198: --
2199: END search_exact_cache;
2200:

Line 2267: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2263: --Done with search range cache for null
2264:
2265: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2266: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2267: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2268: END IF;
2269: END IF;
2270: END IF;
2271:

Line 2419: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2415: x_return_status => x_return_status);
2416:
2417: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2418: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2419: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2420: END IF;
2421: END IF;
2422:
2423: IF (lower_breaks IS NULL) THEN

Line 2439: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2435: x_return_status => x_return_status);
2436:
2437: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2438: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2439: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2440: END IF;
2441: END IF;
2442:
2443: IF (higher_breaks IS NULL) THEN

Line 2473: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

2469: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2470:
2471: IF l_debug_on THEN
2472: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2473: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2474: END IF;
2475: --
2476: END search_range_cache;
2477:

Line 2549: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

2545: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2546:
2547: IF l_debug_on THEN
2548: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2549: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2550: END IF;
2551: --
2552: END get_all_rules_in_cache;
2553:

Line 2624: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

2620: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2621:
2622: IF l_debug_on THEN
2623: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2624: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2625: END IF;
2626: END search_min_high_transit_time;
2627:
2628:

Line 2726: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2722: x_return_status => x_return_status);
2723:
2724: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2725: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2726: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2727: END IF;
2728: END IF;
2729: ELSE
2730:

Line 2742: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2738: x_return_status => x_return_status);
2739:
2740: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2741: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2742: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2743: END IF;
2744: END IF;
2745: END IF;
2746:

Line 2808: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2804: x_return_status => x_return_status);
2805:
2806: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2807: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2808: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2809: END IF;
2810: END IF;
2811:
2812: ELSE

Line 2825: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2821: x_return_status => x_return_status);
2822:
2823: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2824: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2825: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2826: END IF;
2827: END IF;
2828:
2829: END IF;

Line 2900: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2896: x_return_status => x_return_status);
2897:
2898: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2899: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2900: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2901: END IF;
2902: END IF;
2903: ELSE
2904:

Line 2916: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2912: x_return_status => x_return_status);
2913:
2914: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2915: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2916: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2917: END IF;
2918: END IF;
2919: END IF;
2920:

Line 2991: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2987: x_return_status => x_return_status);
2988:
2989: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2990: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2991: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2992: END IF;
2993: END IF;
2994:
2995: ELSE

Line 3013: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3009: x_return_status => x_return_status);
3010:
3011: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3012: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3013: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3014: END IF;
3015: END IF;
3016: END IF;
3017:

Line 3094: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3090: x_return_status => x_return_status);
3091:
3092: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3093: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3094: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3095: END IF;
3096: END IF;
3097: ELSE
3098: --

Line 3113: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3109: x_return_status => x_return_status);
3110:
3111: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3112: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3113: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3114: END IF;
3115: END IF;
3116: END IF;
3117:

Line 3196: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3192:
3193:
3194: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3195: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3196: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3197: END IF;
3198: END IF;
3199:
3200: IF l_debug_on THEN

Line 3264: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3260: x_return_status => x_return_status);
3261:
3262: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3263: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3264: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3265: END IF;
3266: END IF;
3267:
3268: IF l_debug_on THEN

Line 3313: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

3309: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3310:
3311: IF l_debug_on THEN
3312: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3313: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3314: END IF;
3315:
3316: END find_rule_for_key;
3317:

Line 3413: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3409: END IF;
3410:
3411: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3412: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3413: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3414: END IF;
3415: END IF;
3416: END IF;
3417:

Line 3429: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3425: END IF;
3426:
3427: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3428: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3429: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3430: END IF;
3431: END IF;
3432:
3433: END IF;

Line 3512: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3508: END IF;
3509:
3510: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3511: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3512: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3513: END IF;
3514: END IF;
3515: --
3516: -- Depending on results obtained above we can remove certain priorities from the list.

Line 3567: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3563: END IF;
3564:
3565: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3566: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3567: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3568: END IF;
3569: END IF;
3570:
3571: --

Line 3608: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3604: END IF;
3605:
3606: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3607: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3608: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3609: END IF;
3610: END IF;
3611:
3612: --

Line 3641: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3637: END IF;
3638:
3639: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3640: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3641: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3642: END IF;
3643: END IF;
3644: END IF;
3645:

Line 3657: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3653: END IF;
3654:
3655: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3656: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3657: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3658: END IF;
3659: END IF;
3660: END IF;
3661:

Line 3912: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3908: END IF;
3909:
3910: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3911: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3912: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3913: END IF;
3914: END IF;
3915:
3916: IF (l_rule_id <> g_rule_not_found) THEN

Line 3983: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

3979: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3980:
3981: IF l_debug_on THEN
3982: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3983: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3984: END IF;
3985: --
3986: END get_matching_rule;
3987:

Line 4197: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

4193: --
4194:
4195: IF l_debug_on THEN
4196: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4197: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4198: END IF;
4199:
4200: END build_rule_result_cache;
4201:

Line 4257: raise FND_API.G_EXC_UNEXPECTED_ERROR;

4253: END IF;
4254:
4255: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4256: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4257: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4258: END IF;
4259: END IF;
4260: END IF;
4261:

Line 4330: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

4326: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4327: --
4328: IF l_debug_on THEN
4329: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4330: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4331: END IF;
4332:
4333: END get_results_for_rule;
4334: