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 FTE_ACS_CACHE_PKG

Line 1: PACKAGE BODY FTE_ACS_CACHE_PKG AS

1: PACKAGE BODY FTE_ACS_CACHE_PKG AS
2: /* $Header: FTEACSCB.pls 120.5 2005/09/19 05:27:22 alksharm noship $ */
3:
4: -- -------------------------------------------------------------------------- --
5: -- --

Line 6: -- NAME: FTE_ACS_CACHE_PKG --

2: /* $Header: FTEACSCB.pls 120.5 2005/09/19 05:27:22 alksharm noship $ */
3:
4: -- -------------------------------------------------------------------------- --
5: -- --
6: -- NAME: FTE_ACS_CACHE_PKG --
7: -- TYPE: PACKAGE BODY --
8: -- DESCRIPTION: Contains core procedures for searching the rule in the cache --
9: -- In this package processing is done for a single entity. --
10: -- --

Line 86: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_ACS_CACHE_PKG';

82: -- --
83: -- -------------------------------------------------------------------------- --
84:
85: --
86: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_ACS_CACHE_PKG';
87: --
88: g_session_id NUMBER;
89: g_num_absent NUMBER := -9999 ;
90: g_val_absent VARCHAR2(25):= 'NULL';

Line 230: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.get_fixed_key');

226: RETURN (l_key);
227: EXCEPTION
228:
229: WHEN others THEN
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');

Line 276: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.get_key_for_num');

272: RETURN l_key;
273:
274: EXCEPTION
275: WHEN others THEN
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');

Line 318: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.get_key_for_char');

314:
315: RETURN l_key;
316: EXCEPTION
317: WHEN others THEN
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');

Line 358: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.get_key_for_null');

354:
355: RETURN l_key;
356: EXCEPTION
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;

Line 441: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.INITIALIZE_TABLES');

437: END IF;
438: EXCEPTION
439: WHEN others THEN
440: g_table_initialized := FALSE;
441: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.INITIALIZE_TABLES');
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);

Line 491: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.DELETE_RULE_CACHES');

487:
488: EXCEPTION
489: WHEN others THEN
490:
491: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.DELETE_RULE_CACHES');
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);

Line 552: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.refresh_cache');

548: --
549:
550: EXCEPTION
551: WHEN others THEN
552: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.refresh_cache');
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);

Line 626: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.SORT_PRIORITY_TAB');

622: END IF;
623: EXCEPTION
624: WHEN others THEN
625:
626: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.SORT_PRIORITY_TAB');
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);

Line 720: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.GET_SORTED_PRIORITY_TAB');

716: WSH_DEBUG_SV.POP (l_module_name);
717: END IF;
718: EXCEPTION
719: WHEN others THEN
720: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.GET_SORTED_PRIORITY_TAB');
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);

Line 917: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.add_group_to_cache');

913: IF c_get_group_attributes%ISOPEN THEN
914: CLOSE c_get_group_attributes;
915: END IF;
916:
917: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.add_group_to_cache');
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);

Line 992: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.ADD_TO_NON_RANGE_CACHE');

988: END IF;
989:
990: EXCEPTION
991: WHEN others THEN
992: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.ADD_TO_NON_RANGE_CACHE');
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);

Line 1115: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.ADD_TO_RANGE_CACHE');

1111:
1112: EXCEPTION
1113: WHEN others THEN
1114:
1115: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.ADD_TO_RANGE_CACHE');
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);

Line 1794: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.ADD_TO_RANGE_CACHE');

1790: IF c_get_rule_restrictions%ISOPEN THEN
1791: CLOSE c_get_rule_restrictions;
1792: END IF;
1793:
1794: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.ADD_TO_RANGE_CACHE');
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);

Line 1864: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.search_exact_cache_for_null');

1860:
1861: EXCEPTION
1862: WHEN others THEN
1863:
1864: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.search_exact_cache_for_null');
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);

Line 1941: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.search_range_cache_for_null');

1937:
1938: EXCEPTION
1939: WHEN others THEN
1940:
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');

Line 2025: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.get_higher_breaks');

2021:
2022: EXCEPTION
2023: WHEN others THEN
2024:
2025: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.get_higher_breaks');
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);

Line 2107: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.get_lower_breaks');

2103: WSH_DEBUG_SV.POP (l_module_name);
2104: END IF;
2105: EXCEPTION
2106: WHEN others THEN
2107: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.get_lower_breaks');
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);

Line 2191: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.search_exact_cache');

2187:
2188: EXCEPTION
2189: WHEN others THEN
2190:
2191: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.search_exact_cache');
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);

Line 2468: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.search_range_cache');

2464:
2465: EXCEPTION
2466: WHEN others THEN
2467:
2468: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.search_range_cache');
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);

Line 2544: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.get_all_rules_in_cache');

2540:
2541: EXCEPTION
2542: WHEN others THEN
2543:
2544: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.get_all_rules_in_cache');
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);

Line 2619: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.search_min_high_transit_time');

2615: END IF;
2616:
2617: EXCEPTION
2618: WHEN others THEN
2619: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.search_min_high_transit_time');
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);

Line 3308: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.find_rule_for_key');

3304: WSH_DEBUG_SV.pop(l_module_name);
3305: END IF;
3306:
3307: WHEN others THEN
3308: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.find_rule_for_key');
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);

Line 3331: PROCEDURE get_matching_rule( p_info IN FTE_ACS_CACHE_PKG.fte_cs_entity_attr_rec,

3327: -- COMMENT : The API returns the rule which matches attribute values passed in p_info.
3328: -- If no rule is found matching it returns g_rule_not_found
3329: --
3330: --***************************************************************************--
3331: PROCEDURE get_matching_rule( p_info IN FTE_ACS_CACHE_PKG.fte_cs_entity_attr_rec,
3332: x_rule_id OUT NOCOPY NUMBER,
3333: x_return_status OUT NOCOPY VARCHAR2)
3334:
3335: IS

Line 3978: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.get_matching_rule');

3974: END IF;
3975:
3976: WHEN others THEN
3977:
3978: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.get_matching_rule');
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);

Line 4191: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.BUILD_RULE_RESULT_CACHE');

4187: END IF;
4188:
4189: WHEN OTHERS THEN
4190: --
4191: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.BUILD_RULE_RESULT_CACHE');
4192: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4193: --
4194:
4195: IF l_debug_on THEN

Line 4221: x_result_tab OUT NOCOPY FTE_ACS_CACHE_PKG.fte_cs_result_attr_tab,

4217: -- 2. If NOT , build the cache .
4218: -- 3. Return attributes from the cache.
4219: --***************************************************************************--
4220: PROCEDURE get_results_for_rule( p_rule_id IN NUMBER,
4221: x_result_tab OUT NOCOPY FTE_ACS_CACHE_PKG.fte_cs_result_attr_tab,
4222: x_return_status OUT NOCOPY VARCHAR2)
4223:
4224: IS
4225:

Line 4325: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.GET_RESULTS_FOR_RULE');

4321: END IF;
4322:
4323: WHEN OTHERS THEN
4324:
4325: WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.GET_RESULTS_FOR_RULE');
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);

Line 4335: END FTE_ACS_CACHE_PKG;

4331: END IF;
4332:
4333: END get_results_for_rule;
4334:
4335: END FTE_ACS_CACHE_PKG;