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 WSH_UTIL_CORE

Line 53: TYPE group_cache_rec IS RECORD( attribute_tab wsh_util_core.id_tab_type,

49: TYPE priority_tab_type IS TABLE OF NUMBER;
50:
51: TYPE rule_match_tab IS TABLE OF NUMBER;
52:
53: TYPE group_cache_rec IS RECORD( attribute_tab wsh_util_core.id_tab_type,
54: priority_tab priority_tab_type,
55: weight_uom_code VARCHAR2(30),
56: volume_uom_code VARCHAR2(30));
57:

Line 92: g_null_tab WSH_UTIL_CORE.ID_TAB_TYPE;

88: g_session_id NUMBER;
89: g_num_absent NUMBER := -9999 ;
90: g_val_absent VARCHAR2(25):= 'NULL';
91: g_max_cache_size NUMBER := 10;
92: g_null_tab WSH_UTIL_CORE.ID_TAB_TYPE;
93:
94: --
95: -- 2^10 = 2 147 483 648 ,
96: -- Taking 11 characters in the index

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 409: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

405: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
406: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.'||G_PKG_NAME||'.'||'initialize_tables';
407:
408: BEGIN
409: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
410:
411: IF l_debug_on THEN
412: wsh_debug_sv.push (l_module_name);
413: 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 442: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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);
446: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 469: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

465: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'delete_rule_caches';
466:
467: BEGIN
468:
469: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
470:
471: IF l_debug_on THEN
472: wsh_debug_sv.push (l_module_name);
473: END IF;

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 492: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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);
496: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 520: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

516: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
517: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'refresh_cache';
518:
519: BEGIN
520: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
521: --
522: IF l_debug_on THEN
523: wsh_debug_sv.push (l_module_name);
524: END IF;

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 553: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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);
557: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 586: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

582: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
583: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.'||G_PKG_NAME||'.'||'sort_priority_tab';
584:
585: BEGIN
586: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
587:
588: IF l_debug_on THEN
589: wsh_debug_sv.push (l_module_name);
590: END IF;

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 627: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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);
631: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 654: PROCEDURE get_sorted_priority_tab( p_attribute_tab IN WSH_UTIL_CORE.ID_TAB_TYPE,

650: -- evaluated. The procees is not an additive process it is a subtractive process.
651: -- Remove all that need not be evaluated
652: --***************************************************************************--
653:
654: PROCEDURE get_sorted_priority_tab( p_attribute_tab IN WSH_UTIL_CORE.ID_TAB_TYPE,
655: x_priority_tab OUT NOCOPY PRIORITY_TAB_TYPE,
656: x_return_status OUT NOCOPY VARCHAR2)
657: IS
658:

Line 666: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

662: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
663: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.'||G_PKG_NAME||'.'||'get_sorted_priority_tab';
664:
665: BEGIN
666: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
667:
668: IF l_debug_on THEN
669: wsh_debug_sv.push (l_module_name);
670: END IF;

Line 706: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

702:
703: sort_priority_tab( p_priority_tab => l_priority_tab,
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;

Line 707: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

703: sort_priority_tab( p_priority_tab => l_priority_tab,
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;

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 721: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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);
725: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 760: l_group_attr WSH_UTIL_CORE.ID_TAB_TYPE;

756:
757: itr NUMBER;
758:
759: l_attr_tab FTE_ATTR_CODE_VAL_TAB_TYPE;
760: l_group_attr WSH_UTIL_CORE.ID_TAB_TYPE;
761:
762: l_group_cache_rec GROUP_CACHE_REC;
763: l_priority_tab PRIORITY_TAB_TYPE;
764: l_priority_str VARCHAR2(600);

Line 770: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

766: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
767: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.'||G_PKG_NAME||'.'||'add_group_to_group_cache';
768:
769: BEGIN
770: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
771:
772: IF l_debug_on THEN
773: wsh_debug_sv.push (l_module_name);
774: WSH_DEBUG_SV.log(l_module_name,'Adding group to Group Cache ',p_group_id);

Line 882: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

878: get_sorted_priority_tab( p_attribute_tab => l_group_attr,
879: x_priority_tab => l_priority_tab,
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;

Line 883: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

879: x_priority_tab => l_priority_tab,
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:

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 918: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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);
922: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 960: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

956: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'add_to_non_range_cache';
957:
958: BEGIN
959:
960: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
961:
962: IF l_debug_on THEN
963: WSH_DEBUG_SV.push(l_module_name);
964: WSH_DEBUG_SV.log(l_module_name,'p_fixed_key',p_fixed_key);

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 993: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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);
997: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 1043: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1039: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' ||G_PKG_NAME ||'.'||'add_to_range_cache';
1040:
1041: BEGIN
1042:
1043: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1044:
1045: IF l_debug_on THEN
1046:
1047: WSH_DEBUG_SV.push(l_module_name);

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 1116: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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);
1120: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 1202: l_group_attr WSH_UTIL_CORE.ID_TAB_TYPE;

1198: itr NUMBER;
1199: next_itr NUMBER;
1200: next_rule_id NUMBER;
1201:
1202: l_group_attr WSH_UTIL_CORE.ID_TAB_TYPE;
1203:
1204: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1205: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.'||G_PKG_NAME||'.'||'build_cache';
1206:

Line 1214: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1210: FTE_CS_ERROR_INVALID_RANGE EXCEPTION;
1211:
1212: BEGIN
1213:
1214: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1215:
1216: IF l_debug_on THEN
1217: WSH_DEBUG_SV.push(l_module_name);
1218: WSH_DEBUG_SV.log(l_module_name,'p_group_id ',p_group_id);

Line 1408: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1404: p_overlap_flag => weight_overlap,
1405: p_rule_id => curr_rule_id,
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;

Line 1409: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1405: p_rule_id => curr_rule_id,
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:

Line 1422: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1418: p_null_key => null_key,
1419: p_rule_id => curr_rule_id,
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;

Line 1423: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1419: p_rule_id => curr_rule_id,
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

Line 1454: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1450: p_overlap_flag => volume_overlap,
1451: p_rule_id => curr_rule_id,
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;

Line 1455: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1451: p_rule_id => curr_rule_id,
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:

Line 1467: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1463: p_null_key => null_key,
1464: p_rule_id => curr_rule_id,
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;

Line 1468: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1464: p_rule_id => curr_rule_id,
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

Line 1500: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1496: p_overlap_flag => transit_overlap,
1497: p_rule_id => curr_rule_id,
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;

Line 1501: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1497: p_rule_id => curr_rule_id,
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:

Line 1513: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1509: p_null_key => null_key,
1510: p_rule_id => curr_rule_id,
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;

Line 1514: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1510: p_rule_id => curr_rule_id,
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:

Line 1547: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1543: p_overlap_flag => to_postal_overlap,
1544: p_rule_id => curr_rule_id,
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;

Line 1548: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1544: p_rule_id => curr_rule_id,
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:

Line 1560: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1556: p_null_key => null_key,
1557: p_rule_id => curr_rule_id,
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;

Line 1561: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1557: p_rule_id => curr_rule_id,
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:

Line 1586: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1582: p_overlap_flag => to_postal_overlap,
1583: p_rule_id => curr_rule_id,
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;

Line 1587: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1583: p_rule_id => curr_rule_id,
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:

Line 1608: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1604: p_overlap_flag => to_postal_overlap,
1605: p_rule_id => curr_rule_id,
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;

Line 1609: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1605: p_rule_id => curr_rule_id,
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;

Line 1637: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1633: p_overlap_flag => from_postal_overlap,
1634: p_rule_id => curr_rule_id,
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;

Line 1638: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1634: p_rule_id => curr_rule_id,
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:

Line 1654: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1650: p_null_key => null_key,
1651: p_rule_id => curr_rule_id,
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;

Line 1655: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1651: p_rule_id => curr_rule_id,
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:

Line 1676: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1672: p_overlap_flag => from_postal_overlap,
1673: p_rule_id => curr_rule_id,
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;

Line 1677: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1673: p_rule_id => curr_rule_id,
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:

Line 1698: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1694: p_overlap_flag => from_postal_overlap,
1695: p_rule_id => curr_rule_id,
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;

Line 1699: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1695: p_rule_id => curr_rule_id,
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:

Line 1724: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1720: p_fixed_key => key_low,
1721: p_rule_id => curr_rule_id,
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;

Line 1725: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1721: p_rule_id => curr_rule_id,
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:

Line 1736: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1732: p_null_key => null_key,
1733: p_rule_id => curr_rule_id,
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;

Line 1737: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1733: p_rule_id => curr_rule_id,
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;

Line 1748: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1744: EXIT WHEN itr = rule_tab.LAST;
1745: itr := rule_tab.NEXT(itr);
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;

Line 1749: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1745: itr := rule_tab.NEXT(itr);
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:

Line 1767: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1763: IF c_get_rule_restrictions%ISOPEN THEN
1764: CLOSE c_get_rule_restrictions;
1765: END IF;
1766: --
1767: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1768: --
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;

Line 1780: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1776: CLOSE c_get_rule_restrictions;
1777: END IF;
1778:
1779: --
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');

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 1795: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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);
1799: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 1835: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1831: IF l_debug_on THEN
1832: wsh_debug_sv.push (l_module_name);
1833: END IF;
1834:
1835: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1836:
1837: l_null_key := get_key_for_null ( p_fixed_key) ;
1838:
1839: IF (p_cache.EXISTS(l_null_key)) THEN

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 1865: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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);
1869: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 1906: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1902: IF l_debug_on THEN
1903: wsh_debug_sv.push (l_module_name);
1904: END IF;
1905:
1906: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1907:
1908: l_null_key := get_key_for_null(p_fixed_key);
1909:
1910: IF (p_cache.EXISTS(l_null_key)) THEN

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 1942: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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');
1946: END IF;

Line 1978: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1974: itr NUMBER;
1975: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1976: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.'||G_PKG_NAME||'.'||'GET_HIGHER_BREAKS';
1977: BEGIN
1978: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1979:
1980: IF l_debug_on THEN
1981: wsh_debug_sv.push(l_module_name);
1982: END IF;

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 2026: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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);
2030: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 2068: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2064: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.'||G_PKG_NAME||'.'||'GET_LOWER_BREAKS';
2065:
2066: BEGIN
2067:
2068: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2069:
2070: IF l_debug_on THEN
2071: wsh_debug_sv.push (l_module_name);
2072: END IF;

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 2108: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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);
2112: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 2151: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2147: IF l_debug_on THEN
2148: wsh_debug_sv.push (l_module_name);
2149: END IF;
2150:
2151: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2152:
2153: IF (p_search_null) THEN
2154:
2155: search_exact_cache_for_null( p_cache => p_cache,

Line 2160: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2156: p_fixed_key => p_fixed_key,
2157: x_result_tab => x_result_tab,
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;

Line 2161: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

2157: x_result_tab => x_result_tab,
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;

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 2192: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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);
2196: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 2254: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2250: IF l_debug_on THEN
2251: wsh_debug_sv.push (l_module_name);
2252: END IF;
2253:
2254: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2255: l_unique_rule := true;
2256: IF (p_search_null) THEN
2257:
2258: search_range_cache_for_null( p_cache => p_cache,

Line 2265: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2261: x_return_status=> x_return_status);
2262:
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;

Line 2266: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

2262:
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;

Line 2417: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2413: p_null_key => l_null_key,
2414: x_rule_tab => lower_breaks,
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;

Line 2418: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

2414: x_rule_tab => lower_breaks,
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:

Line 2437: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2433: p_null_key => l_null_key,
2434: x_rule_tab => higher_breaks,
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;

Line 2438: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

2434: x_rule_tab => higher_breaks,
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:

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 2469: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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);
2473: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 2508: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2504: IF l_debug_on THEN
2505: wsh_debug_sv.push (l_module_name);
2506: END IF;
2507:
2508: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2509:
2510: l_rule_tab_itr := p_cache.FIRST;
2511:
2512: IF p_cache.FIRST IS NOT NULL THEN

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 2545: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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);
2549: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 2579: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2575: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2576: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'search_min_high_transit_time';
2577:
2578: BEGIN
2579: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2580: itr := p_result_tab.FIRST;
2581:
2582: IF (itr IS NOT NULL) THEN
2583: LOOP

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 2620: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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);
2624: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 2675: l_attribute_tab WSH_UTIL_CORE.ID_TAB_TYPE;

2671: WHERE group_id = p_group_id;
2672:
2673: l_result_set RULE_MATCH_TAB ;
2674: l_temp_set RULE_MATCH_TAB ;
2675: l_attribute_tab WSH_UTIL_CORE.ID_TAB_TYPE;
2676: l_attribute_key VARCHAR2(32767);
2677: itr NUMBER;
2678:
2679: l_group_name VARCHAR2(32767);

Line 2687: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2683:
2684: OVERLAPPING_RULES_EXIST EXCEPTION;
2685: BEGIN
2686:
2687: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2688:
2689: IF l_debug_on THEN
2690: wsh_debug_sv.push(l_module_name);
2691: END IF;

Line 2724: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2720: p_search_null => TRUE,
2721: x_result_tab => l_temp_set,
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;

Line 2725: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

2721: x_result_tab => l_temp_set,
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

Line 2740: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2736: p_fixed_key => p_fixed_key,
2737: x_result_tab => l_temp_set,
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;

Line 2741: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

2737: x_result_tab => l_temp_set,
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;

Line 2806: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2802: p_match_upper_limit => FALSE,
2803: x_result_tab => l_temp_set,
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;

Line 2807: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

2803: x_result_tab => l_temp_set,
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:

Line 2823: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2819: p_fixed_key => p_fixed_key,
2820: x_result_tab => l_temp_set,
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;

Line 2824: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

2820: x_result_tab => l_temp_set,
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:

Line 2898: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2894: p_search_null => TRUE,
2895: x_result_tab => l_temp_set,
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;

Line 2899: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

2895: x_result_tab => l_temp_set,
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

Line 2914: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2910: p_fixed_key => p_fixed_key,
2911: x_result_tab => l_temp_set,
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;

Line 2915: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

2911: x_result_tab => l_temp_set,
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;

Line 2989: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2985: p_search_null => FALSE,
2986: x_result_tab => l_temp_set,
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;

Line 2990: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

2986: x_result_tab => l_temp_set,
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:

Line 3011: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

3007: p_fixed_key => p_fixed_key,
3008: x_result_tab => l_temp_set,
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;

Line 3012: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

3008: x_result_tab => l_temp_set,
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;

Line 3092: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

3088: p_search_null => FALSE,
3089: x_result_tab => l_temp_set,
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;

Line 3093: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

3089: x_result_tab => l_temp_set,
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

Line 3111: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

3107: p_fixed_key => p_fixed_key,
3108: x_result_tab => l_temp_set,
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;

Line 3112: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

3108: x_result_tab => l_temp_set,
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;

Line 3194: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

3190: x_result_tab => l_temp_set,
3191: x_return_status => x_return_status);
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;

Line 3195: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

3191: x_return_status => x_return_status);
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:

Line 3262: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

3258: search_min_high_Transit_Time( p_result_tab => l_result_set,
3259: x_rule_id => x_rule_id,
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;

Line 3263: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

3259: x_rule_id => x_rule_id,
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:

Line 3299: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3295: CLOSE c_get_group_name;
3296:
3297: FND_MESSAGE.SET_NAME('FTE','FTE_POSTAL_CODE_OVERLAP');
3298: FND_MESSAGE.SET_TOKEN('RULE_NAME',l_group_name);
3299: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3300: WSH_UTIL_CORE.add_message(x_return_status);
3301:
3302: IF l_debug_on THEN
3303: WSH_DEBUG_SV.logmsg(l_module_name,'Overlapping Rules Exist for Group'||l_group_name);

Line 3300: WSH_UTIL_CORE.add_message(x_return_status);

3296:
3297: FND_MESSAGE.SET_NAME('FTE','FTE_POSTAL_CODE_OVERLAP');
3298: FND_MESSAGE.SET_TOKEN('RULE_NAME',l_group_name);
3299: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3300: WSH_UTIL_CORE.add_message(x_return_status);
3301:
3302: IF l_debug_on THEN
3303: WSH_DEBUG_SV.logmsg(l_module_name,'Overlapping Rules Exist for Group'||l_group_name);
3304: WSH_DEBUG_SV.pop(l_module_name);

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 3309: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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);
3313: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 3338: l_attribute_tab WSH_UTIL_CORE.ID_TAB_TYPE;

3334:
3335: IS
3336:
3337: l_group_cache_rec GROUP_CACHE_REC;
3338: l_attribute_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3339: l_priority_tab PRIORITY_TAB_TYPE;
3340:
3341: from_pregion_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3342: from_all_region_tab WSH_UTIL_CORE.ID_TAB_TYPE;

Line 3341: from_pregion_tab WSH_UTIL_CORE.ID_TAB_TYPE;

3337: l_group_cache_rec GROUP_CACHE_REC;
3338: l_attribute_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3339: l_priority_tab PRIORITY_TAB_TYPE;
3340:
3341: from_pregion_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3342: from_all_region_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3343: from_postal_zone_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3344:
3345:

Line 3342: from_all_region_tab WSH_UTIL_CORE.ID_TAB_TYPE;

3338: l_attribute_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3339: l_priority_tab PRIORITY_TAB_TYPE;
3340:
3341: from_pregion_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3342: from_all_region_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3343: from_postal_zone_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3344:
3345:
3346: to_pregion_tab WSH_UTIL_CORE.ID_TAB_TYPE;

Line 3343: from_postal_zone_tab WSH_UTIL_CORE.ID_TAB_TYPE;

3339: l_priority_tab PRIORITY_TAB_TYPE;
3340:
3341: from_pregion_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3342: from_all_region_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3343: from_postal_zone_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3344:
3345:
3346: to_pregion_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3347: to_all_region_tab WSH_UTIL_CORE.ID_TAB_TYPE;

Line 3346: to_pregion_tab WSH_UTIL_CORE.ID_TAB_TYPE;

3342: from_all_region_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3343: from_postal_zone_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3344:
3345:
3346: to_pregion_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3347: to_all_region_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3348: to_postal_zone_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3349:
3350: from_postal_code WSH_LOCATIONS.POSTAL_CODE%TYPE;

Line 3347: to_all_region_tab WSH_UTIL_CORE.ID_TAB_TYPE;

3343: from_postal_zone_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3344:
3345:
3346: to_pregion_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3347: to_all_region_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3348: to_postal_zone_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3349:
3350: from_postal_code WSH_LOCATIONS.POSTAL_CODE%TYPE;
3351: to_postal_code WSH_LOCATIONS.POSTAL_CODE%TYPE;

Line 3348: to_postal_zone_tab WSH_UTIL_CORE.ID_TAB_TYPE;

3344:
3345:
3346: to_pregion_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3347: to_all_region_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3348: to_postal_zone_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3349:
3350: from_postal_code WSH_LOCATIONS.POSTAL_CODE%TYPE;
3351: to_postal_code WSH_LOCATIONS.POSTAL_CODE%TYPE;
3352:

Line 3358: from_tab WSH_UTIL_CORE.ID_TAB_TYPE;

3354: priority NUMBER;
3355:
3356: l_fixed_key VARCHAR2(32767);
3357:
3358: from_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3359: to_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3360: from_postal_flag BOOLEAN;
3361: to_postal_flag BOOLEAN;
3362:

Line 3359: to_tab WSH_UTIL_CORE.ID_TAB_TYPE;

3355:
3356: l_fixed_key VARCHAR2(32767);
3357:
3358: from_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3359: to_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3360: from_postal_flag BOOLEAN;
3361: to_postal_flag BOOLEAN;
3362:
3363: from_itr NUMBER;

Line 3386: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3382:
3383:
3384: BEGIN
3385:
3386: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3387:
3388: IF l_debug_on THEN
3389: wsh_debug_sv.push (l_module_name);
3390: WSH_DEBUG_SV.log(l_module_name,'Group Id ',p_info.group_id);

Line 3411: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

3407: IF l_debug_on THEN
3408: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);
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;

Line 3412: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

3408: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);
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;

Line 3427: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

3423: IF l_debug_on THEN
3424: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);
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;

Line 3428: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

3424: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);
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:

Line 3510: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

3506: IF l_debug_on THEN
3507: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);
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;

Line 3511: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

3507: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);
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: --

Line 3565: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

3561: IF l_debug_on THEN
3562: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);
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;

Line 3566: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

3562: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);
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:

Line 3606: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

3602: IF l_debug_on THEN
3603: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);
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;

Line 3607: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

3603: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);
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:

Line 3639: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

3635: IF l_debug_on THEN
3636: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);
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;

Line 3640: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

3636: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);
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;

Line 3655: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

3651: IF l_debug_on THEN
3652: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);
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;

Line 3656: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

3652: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);
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;

Line 3910: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

3906: WSH_DEBUG_SV.log(l_module_name,'l_rule_id ', l_rule_id);
3907: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);
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;

Line 3911: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

3907: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);
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:

Line 3959: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3955:
3956: WHEN FTE_CS_VOL_CONV_ERR THEN
3957:
3958: FND_MESSAGE.SET_NAME('FTE','FTE_CS_VOL_CONV_ERR');
3959: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3960: WSH_UTIL_CORE.add_message(x_return_status);
3961:
3962: IF l_debug_on THEN
3963: WSH_DEBUG_SV.pop(l_module_name,'Volume UOM Conversion Error');

Line 3960: WSH_UTIL_CORE.add_message(x_return_status);

3956: WHEN FTE_CS_VOL_CONV_ERR THEN
3957:
3958: FND_MESSAGE.SET_NAME('FTE','FTE_CS_VOL_CONV_ERR');
3959: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3960: WSH_UTIL_CORE.add_message(x_return_status);
3961:
3962: IF l_debug_on THEN
3963: WSH_DEBUG_SV.pop(l_module_name,'Volume UOM Conversion Error');
3964: END IF;

Line 3969: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3965:
3966: WHEN FTE_CS_WGHT_CONV_ERR THEN
3967:
3968: FND_MESSAGE.SET_NAME('FTE','FTE_CS_WGHT_CONV_ERR');
3969: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3970: WSH_UTIL_CORE.add_message(x_return_status);
3971:
3972: IF l_debug_on THEN
3973: WSH_DEBUG_SV.pop(l_module_name,'Volume UOM Conversion Error');

Line 3970: WSH_UTIL_CORE.add_message(x_return_status);

3966: WHEN FTE_CS_WGHT_CONV_ERR THEN
3967:
3968: FND_MESSAGE.SET_NAME('FTE','FTE_CS_WGHT_CONV_ERR');
3969: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3970: WSH_UTIL_CORE.add_message(x_return_status);
3971:
3972: IF l_debug_on THEN
3973: WSH_DEBUG_SV.pop(l_module_name,'Volume UOM Conversion Error');
3974: END IF;

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 3979: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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);
3983: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 4047: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4043: --
4044: -- Values are not in cache.
4045: -- Query the database tables to return results;
4046: --
4047: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4048:
4049: IF l_debug_on THEN
4050: WSH_DEBUG_SV.push(l_module_name);
4051: WSH_DEBUG_SV.log(l_module_name,'p_rule_id',p_rule_id);

Line 4175: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4171:
4172:
4173: EXCEPTION
4174: WHEN INVALID_RESULT_ATTRIBUTE THEN
4175: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4176: --
4177: IF l_debug_on THEN
4178: WSH_DEBUG_SV.pop(l_module_name,'Invalid Attribute associated with Rule'||p_rule_id);
4179: END IF;

Line 4183: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4179: END IF;
4180:
4181: WHEN NO_RESULTS_FOR_RULE THEN
4182:
4183: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4184: --
4185: IF l_debug_on THEN
4186: WSH_DEBUG_SV.pop(l_module_name,'No Results Associated with Rule'||p_rule_id);
4187: END IF;

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 4192: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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
4196: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 4239: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4235: NO_RESULTS_FOR_RULE EXCEPTION;
4236:
4237: BEGIN
4238:
4239: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4240:
4241: IF l_debug_on THEN
4242: WSH_DEBUG_SV.push(l_module_name);
4243: WSH_DEBUG_SV.log(l_module_name,'p_rule_id',p_rule_id);

Line 4255: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

4251: IF l_debug_on THEN
4252: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);
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;

Line 4256: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

4252: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);
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;

Line 4317: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4313: EXCEPTION
4314:
4315: WHEN NO_RESULTS_FOR_RULE THEN
4316:
4317: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4318: --
4319: IF l_debug_on THEN
4320: WSH_DEBUG_SV.pop(l_module_name,'No Results Associated with Rule'||p_rule_id);
4321: END IF;

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 4326: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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);
4330: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');