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

Line 89: TYPE fte_cs_bulk_entity_gtt IS RECORD( delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,

85:
86: --
87: --R12 Enhancement
88: --
89: TYPE fte_cs_bulk_entity_gtt IS RECORD( delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
90: trip_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
91: delivery_name_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
92: trip_name_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
93: organization_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,

Line 90: trip_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,

86: --
87: --R12 Enhancement
88: --
89: TYPE fte_cs_bulk_entity_gtt IS RECORD( delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
90: trip_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
91: delivery_name_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
92: trip_name_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
93: organization_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
94: triporigin_internal_org_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,

Line 91: delivery_name_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,

87: --R12 Enhancement
88: --
89: TYPE fte_cs_bulk_entity_gtt IS RECORD( delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
90: trip_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
91: delivery_name_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
92: trip_name_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
93: organization_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
94: triporigin_internal_org_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
95: customer_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,

Line 92: trip_name_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,

88: --
89: TYPE fte_cs_bulk_entity_gtt IS RECORD( delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
90: trip_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
91: delivery_name_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
92: trip_name_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
93: organization_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
94: triporigin_internal_org_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
95: customer_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
96: customer_site_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,

Line 93: organization_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,

89: TYPE fte_cs_bulk_entity_gtt IS RECORD( delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
90: trip_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
91: delivery_name_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
92: trip_name_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
93: organization_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
94: triporigin_internal_org_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
95: customer_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
96: customer_site_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
97: gross_weight_tab WSH_UTIL_CORE.ID_TAB_TYPE,

Line 94: triporigin_internal_org_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,

90: trip_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
91: delivery_name_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
92: trip_name_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
93: organization_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
94: triporigin_internal_org_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
95: customer_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
96: customer_site_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
97: gross_weight_tab WSH_UTIL_CORE.ID_TAB_TYPE,
98: weight_uom_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,

Line 95: customer_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,

91: delivery_name_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
92: trip_name_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
93: organization_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
94: triporigin_internal_org_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
95: customer_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
96: customer_site_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
97: gross_weight_tab WSH_UTIL_CORE.ID_TAB_TYPE,
98: weight_uom_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
99: volume_tab WSH_UTIL_CORE.ID_TAB_TYPE,

Line 96: customer_site_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,

92: trip_name_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
93: organization_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
94: triporigin_internal_org_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
95: customer_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
96: customer_site_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
97: gross_weight_tab WSH_UTIL_CORE.ID_TAB_TYPE,
98: weight_uom_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
99: volume_tab WSH_UTIL_CORE.ID_TAB_TYPE,
100: volume_uom_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,

Line 97: gross_weight_tab WSH_UTIL_CORE.ID_TAB_TYPE,

93: organization_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
94: triporigin_internal_org_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
95: customer_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
96: customer_site_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
97: gross_weight_tab WSH_UTIL_CORE.ID_TAB_TYPE,
98: weight_uom_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
99: volume_tab WSH_UTIL_CORE.ID_TAB_TYPE,
100: volume_uom_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
101: initial_pickup_loc_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,

Line 98: weight_uom_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,

94: triporigin_internal_org_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
95: customer_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
96: customer_site_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
97: gross_weight_tab WSH_UTIL_CORE.ID_TAB_TYPE,
98: weight_uom_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
99: volume_tab WSH_UTIL_CORE.ID_TAB_TYPE,
100: volume_uom_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
101: initial_pickup_loc_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
102: ultimate_dropoff_loc_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,

Line 99: volume_tab WSH_UTIL_CORE.ID_TAB_TYPE,

95: customer_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
96: customer_site_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
97: gross_weight_tab WSH_UTIL_CORE.ID_TAB_TYPE,
98: weight_uom_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
99: volume_tab WSH_UTIL_CORE.ID_TAB_TYPE,
100: volume_uom_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
101: initial_pickup_loc_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
102: ultimate_dropoff_loc_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
103: initial_pickup_date_tab WSH_UTIL_CORE.DATE_TAB_TYPE,

Line 100: volume_uom_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,

96: customer_site_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
97: gross_weight_tab WSH_UTIL_CORE.ID_TAB_TYPE,
98: weight_uom_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
99: volume_tab WSH_UTIL_CORE.ID_TAB_TYPE,
100: volume_uom_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
101: initial_pickup_loc_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
102: ultimate_dropoff_loc_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
103: initial_pickup_date_tab WSH_UTIL_CORE.DATE_TAB_TYPE,
104: ultimate_dropoff_date_tab WSH_UTIL_CORE.DATE_TAB_TYPE,

Line 101: initial_pickup_loc_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,

97: gross_weight_tab WSH_UTIL_CORE.ID_TAB_TYPE,
98: weight_uom_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
99: volume_tab WSH_UTIL_CORE.ID_TAB_TYPE,
100: volume_uom_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
101: initial_pickup_loc_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
102: ultimate_dropoff_loc_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
103: initial_pickup_date_tab WSH_UTIL_CORE.DATE_TAB_TYPE,
104: ultimate_dropoff_date_tab WSH_UTIL_CORE.DATE_TAB_TYPE,
105: freight_terms_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,

Line 102: ultimate_dropoff_loc_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,

98: weight_uom_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
99: volume_tab WSH_UTIL_CORE.ID_TAB_TYPE,
100: volume_uom_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
101: initial_pickup_loc_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
102: ultimate_dropoff_loc_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
103: initial_pickup_date_tab WSH_UTIL_CORE.DATE_TAB_TYPE,
104: ultimate_dropoff_date_tab WSH_UTIL_CORE.DATE_TAB_TYPE,
105: freight_terms_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
106: fob_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,

Line 103: initial_pickup_date_tab WSH_UTIL_CORE.DATE_TAB_TYPE,

99: volume_tab WSH_UTIL_CORE.ID_TAB_TYPE,
100: volume_uom_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
101: initial_pickup_loc_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
102: ultimate_dropoff_loc_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
103: initial_pickup_date_tab WSH_UTIL_CORE.DATE_TAB_TYPE,
104: ultimate_dropoff_date_tab WSH_UTIL_CORE.DATE_TAB_TYPE,
105: freight_terms_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
106: fob_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
107: search_level_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,

Line 104: ultimate_dropoff_date_tab WSH_UTIL_CORE.DATE_TAB_TYPE,

100: volume_uom_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
101: initial_pickup_loc_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
102: ultimate_dropoff_loc_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
103: initial_pickup_date_tab WSH_UTIL_CORE.DATE_TAB_TYPE,
104: ultimate_dropoff_date_tab WSH_UTIL_CORE.DATE_TAB_TYPE,
105: freight_terms_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
106: fob_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
107: search_level_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
108: transit_time_tab WSH_UTIL_CORE.ID_TAB_TYPE);

Line 105: freight_terms_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,

101: initial_pickup_loc_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
102: ultimate_dropoff_loc_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
103: initial_pickup_date_tab WSH_UTIL_CORE.DATE_TAB_TYPE,
104: ultimate_dropoff_date_tab WSH_UTIL_CORE.DATE_TAB_TYPE,
105: freight_terms_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
106: fob_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
107: search_level_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
108: transit_time_tab WSH_UTIL_CORE.ID_TAB_TYPE);
109:

Line 106: fob_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,

102: ultimate_dropoff_loc_id_tab WSH_UTIL_CORE.ID_TAB_TYPE,
103: initial_pickup_date_tab WSH_UTIL_CORE.DATE_TAB_TYPE,
104: ultimate_dropoff_date_tab WSH_UTIL_CORE.DATE_TAB_TYPE,
105: freight_terms_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
106: fob_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
107: search_level_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
108: transit_time_tab WSH_UTIL_CORE.ID_TAB_TYPE);
109:
110: TYPE fte_cs_group_rec_type IS RECORD(GROUP_ID NUMBER,

Line 107: search_level_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,

103: initial_pickup_date_tab WSH_UTIL_CORE.DATE_TAB_TYPE,
104: ultimate_dropoff_date_tab WSH_UTIL_CORE.DATE_TAB_TYPE,
105: freight_terms_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
106: fob_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
107: search_level_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
108: transit_time_tab WSH_UTIL_CORE.ID_TAB_TYPE);
109:
110: TYPE fte_cs_group_rec_type IS RECORD(GROUP_ID NUMBER,
111: START_DATE DATE,

Line 108: transit_time_tab WSH_UTIL_CORE.ID_TAB_TYPE);

104: ultimate_dropoff_date_tab WSH_UTIL_CORE.DATE_TAB_TYPE,
105: freight_terms_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
106: fob_code_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
107: search_level_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE,
108: transit_time_tab WSH_UTIL_CORE.ID_TAB_TYPE);
109:
110: TYPE fte_cs_group_rec_type IS RECORD(GROUP_ID NUMBER,
111: START_DATE DATE,
112: END_DATE DATE);

Line 269: WSH_UTIL_CORE.default_handler('FTE_ACS_RULE_UTIL_PKG.CONV_TO_BASE_UOM');

265: IF l_debug_on THEN
266: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_ACS_RULE_UTIL_PKG.CONV_VAL_TO_BASE_UOM IS ' ||L_ERROR_TEXT );
267: END IF;
268: --
269: WSH_UTIL_CORE.default_handler('FTE_ACS_RULE_UTIL_PKG.CONV_TO_BASE_UOM');
270: --
271: -- Debug Statements
272: --
273: IF l_debug_on THEN

Line 489: x_region_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,

485: -- regions is same as is returned by WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches
486: --
487: --***************************************************************************--
488: PROCEDURE GET_FORMATED_REGIONS( p_location_id IN NUMBER,
489: x_region_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
490: x_all_region_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
491: x_postal_zone_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
492: x_return_status OUT NOCOPY VARCHAR2)
493: IS

Line 490: x_all_region_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,

486: --
487: --***************************************************************************--
488: PROCEDURE GET_FORMATED_REGIONS( p_location_id IN NUMBER,
489: x_region_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
490: x_all_region_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
491: x_postal_zone_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
492: x_return_status OUT NOCOPY VARCHAR2)
493: IS
494:

Line 491: x_postal_zone_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,

487: --***************************************************************************--
488: PROCEDURE GET_FORMATED_REGIONS( p_location_id IN NUMBER,
489: x_region_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
490: x_all_region_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
491: x_postal_zone_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
492: x_return_status OUT NOCOPY VARCHAR2)
493: IS
494:
495: l_postal_tab WSH_UTIL_CORE.ID_TAB_TYPE;

Line 495: l_postal_tab WSH_UTIL_CORE.ID_TAB_TYPE;

491: x_postal_zone_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
492: x_return_status OUT NOCOPY VARCHAR2)
493: IS
494:
495: l_postal_tab WSH_UTIL_CORE.ID_TAB_TYPE;
496: l_region_tab WSH_UTIL_CORE.ID_TAB_TYPE;
497: l_postal_code_tab WSH_UTIL_CORE.ID_TAB_TYPE;
498: l_region_table WSH_REGIONS_SEARCH_PKG.region_table;
499:

Line 496: l_region_tab WSH_UTIL_CORE.ID_TAB_TYPE;

492: x_return_status OUT NOCOPY VARCHAR2)
493: IS
494:
495: l_postal_tab WSH_UTIL_CORE.ID_TAB_TYPE;
496: l_region_tab WSH_UTIL_CORE.ID_TAB_TYPE;
497: l_postal_code_tab WSH_UTIL_CORE.ID_TAB_TYPE;
498: l_region_table WSH_REGIONS_SEARCH_PKG.region_table;
499:
500: l_language VARCHAR2(720);

Line 497: l_postal_code_tab WSH_UTIL_CORE.ID_TAB_TYPE;

493: IS
494:
495: l_postal_tab WSH_UTIL_CORE.ID_TAB_TYPE;
496: l_region_tab WSH_UTIL_CORE.ID_TAB_TYPE;
497: l_postal_code_tab WSH_UTIL_CORE.ID_TAB_TYPE;
498: l_region_table WSH_REGIONS_SEARCH_PKG.region_table;
499:
500: l_language VARCHAR2(720);
501: l_zone_flag VARCHAR2(1):='Y';

Line 511: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

507: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.'||G_PKG_NAME||'.'||'get_formatted_regions';
508:
509: BEGIN
510:
511: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
512:
513: IF l_debug_on THEN
514: wsh_debug_sv.push (l_module_name);
515: END IF;

Line 538: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

534: x_status => x_return_status,
535: x_regions => l_region_table);
536:
537:
538: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
539: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
540: raise FND_API.G_EXC_UNEXPECTED_ERROR;
541: END IF;
542: END IF;

Line 539: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

535: x_regions => l_region_table);
536:
537:
538: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
539: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
540: raise FND_API.G_EXC_UNEXPECTED_ERROR;
541: END IF;
542: END IF;
543:

Line 578: WSH_UTIL_CORE.default_handler('FTE_ACS_UTIL_PKG.GET_FORMATTED_REGION');

574: EXCEPTION
575:
576: WHEN others THEN
577:
578: WSH_UTIL_CORE.default_handler('FTE_ACS_UTIL_PKG.GET_FORMATTED_REGION');
579: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
580:
581: IF l_debug_on THEN
582: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 579: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

575:
576: WHEN others THEN
577:
578: WSH_UTIL_CORE.default_handler('FTE_ACS_UTIL_PKG.GET_FORMATTED_REGION');
579: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
580:
581: IF l_debug_on THEN
582: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
583: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 617: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

613: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.'||G_PKG_NAME||'.'||'get_postal_code';
614:
615: BEGIN
616:
617: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
618:
619: IF l_debug_on THEN
620: wsh_debug_sv.push (l_module_name);
621: END IF;

Line 640: WSH_UTIL_CORE.default_handler('FTE_ACS_UTIL_PKG.get_postal_code');

636: IF c_get_postal_code%ISOPEN THEN
637: CLOSE c_get_postal_code;
638: END IF;
639:
640: WSH_UTIL_CORE.default_handler('FTE_ACS_UTIL_PKG.get_postal_code');
641: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
642:
643: IF l_debug_on THEN
644: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 641: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

637: CLOSE c_get_postal_code;
638: END IF;
639:
640: WSH_UTIL_CORE.default_handler('FTE_ACS_UTIL_PKG.get_postal_code');
641: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
642:
643: IF l_debug_on THEN
644: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
645: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 674: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

670: i NUMBER;
671: itr NUMBER;
672:
673: BEGIN
674: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
675:
676: IF l_debug_on THEN
677: wsh_debug_sv.push (l_module_name);
678: WSH_DEBUG_SV.logmsg(l_module_name,'Number of input records'||p_input_data.COUNT);

Line 796: WSH_UTIL_CORE.default_handler('FTE_ACS_RULE_UTIL_PKG.INSERT_INTO_GTT');

792:
793: EXCEPTION
794: WHEN OTHERS THEN
795: --
796: WSH_UTIL_CORE.default_handler('FTE_ACS_RULE_UTIL_PKG.INSERT_INTO_GTT');
797: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
798: --
799: IF l_debug_on THEN
800: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 797: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

793: EXCEPTION
794: WHEN OTHERS THEN
795: --
796: WSH_UTIL_CORE.default_handler('FTE_ACS_RULE_UTIL_PKG.INSERT_INTO_GTT');
797: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
798: --
799: IF l_debug_on THEN
800: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
801: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 835: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

831: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'FORMAT_ENTITY_INFO';
832:
833: BEGIN
834:
835: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
836:
837: IF l_debug_on THEN
838: wsh_debug_sv.push (l_module_name);
839: WSH_DEBUG_SV.logmsg(l_module_name,'Number of input records'||p_input_cs_tab.COUNT);

Line 883: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN

879:
880: WSH_SHIPPING_PARAMS_PVT.GET( x_param_value_info => l_param_rec,
881: x_return_status => x_return_status);
882:
883: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
884: raise FND_API.G_EXC_UNEXPECTED_ERROR;
885: END IF;
886:
887: l_itr := l_param_rec.param_value_chr.FIRST;

Line 919: WSH_UTIL_CORE.default_handler('FTE_ACS_RULE_UTIL_PKG.FORMAT_ENTITY_INFO');

915: END IF;
916: EXCEPTION
917: WHEN OTHERS THEN
918: --
919: WSH_UTIL_CORE.default_handler('FTE_ACS_RULE_UTIL_PKG.FORMAT_ENTITY_INFO');
920: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
921: --
922: IF l_debug_on THEN
923: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 920: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

916: EXCEPTION
917: WHEN OTHERS THEN
918: --
919: WSH_UTIL_CORE.default_handler('FTE_ACS_RULE_UTIL_PKG.FORMAT_ENTITY_INFO');
920: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
921: --
922: IF l_debug_on THEN
923: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
924: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 988: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

984: THEN
985: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
986: END IF;
987: --
988: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
989: x_return_message := null;
990:
991: IF l_debug_on THEN
992: WSH_DEBUG_SV.push(l_module_name);

Line 1030: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_UTIL_CORE.GET_SHIP_METHOD_CODE IS ' ||L_ERROR_TEXT );

1026: --
1027: -- Debug Statements
1028: --
1029: IF l_debug_on THEN
1030: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_UTIL_CORE.GET_SHIP_METHOD_CODE IS ' ||L_ERROR_TEXT );
1031: WSH_DEBUG_SV.pop(l_module_name);
1032: END IF;
1033: --
1034: WSH_UTIL_CORE.default_handler('WSH_UTIL_CORE.GET_SHIP_METHOD_CODE');

Line 1034: WSH_UTIL_CORE.default_handler('WSH_UTIL_CORE.GET_SHIP_METHOD_CODE');

1030: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_UTIL_CORE.GET_SHIP_METHOD_CODE IS ' ||L_ERROR_TEXT );
1031: WSH_DEBUG_SV.pop(l_module_name);
1032: END IF;
1033: --
1034: WSH_UTIL_CORE.default_handler('WSH_UTIL_CORE.GET_SHIP_METHOD_CODE');
1035: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_GET_SMC_ERROR');
1036: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1037: x_return_message := 'WSH_FTE_GET_SMC_ERROR';
1038: WSH_UTIL_CORE.add_message(x_return_status);

Line 1036: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1032: END IF;
1033: --
1034: WSH_UTIL_CORE.default_handler('WSH_UTIL_CORE.GET_SHIP_METHOD_CODE');
1035: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_GET_SMC_ERROR');
1036: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1037: x_return_message := 'WSH_FTE_GET_SMC_ERROR';
1038: WSH_UTIL_CORE.add_message(x_return_status);
1039:
1040: END GET_SHIP_METHOD_CODE;

Line 1038: WSH_UTIL_CORE.add_message(x_return_status);

1034: WSH_UTIL_CORE.default_handler('WSH_UTIL_CORE.GET_SHIP_METHOD_CODE');
1035: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_GET_SMC_ERROR');
1036: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1037: x_return_message := 'WSH_FTE_GET_SMC_ERROR';
1038: WSH_UTIL_CORE.add_message(x_return_status);
1039:
1040: END GET_SHIP_METHOD_CODE;
1041:
1042:

Line 1327: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1323: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1324: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' ||'GET_CANDIDATE_RECORDS';
1325: BEGIN
1326:
1327: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1328:
1329: IF l_debug_on THEN
1330:
1331: wsh_debug_sv.push(l_module_name);

Line 1634: WSH_UTIL_CORE.default_handler('FTE_ACS_UTIL_PKG.get_candidate_records');

1630: IF (c_get_ship_group%ISOPEN) THEN
1631: CLOSE c_get_ship_group ;
1632: END IF;
1633:
1634: WSH_UTIL_CORE.default_handler('FTE_ACS_UTIL_PKG.get_candidate_records');
1635: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1636: --
1637: IF l_debug_on THEN
1638: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1635: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1631: CLOSE c_get_ship_group ;
1632: END IF;
1633:
1634: WSH_UTIL_CORE.default_handler('FTE_ACS_UTIL_PKG.get_candidate_records');
1635: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1636: --
1637: IF l_debug_on THEN
1638: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1639: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');