APPS.FTE_ESTIMATE_FREIGHT_RATE dependencies on FTE_ESTIMATE_FREIGHT_RATE

Line 1: PACKAGE BODY FTE_ESTIMATE_FREIGHT_RATE AS

1: PACKAGE BODY FTE_ESTIMATE_FREIGHT_RATE AS
2: /* $Header: FTEEFREB.pls 120.2 2005/07/26 14:06:56 schennal noship $ */
3: /*
4: -- Global constants
5: -- +======================================================================+

Line 23: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_ESTIMATE_FREIGHT_RATE';

19: -- +======================================================================+
20: */
21:
22: --
23: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_ESTIMATE_FREIGHT_RATE';
24: --
25:
26: PROCEDURE Rate_Search(
27: p_init_msg_list IN VARCHAR2 default fnd_api.g_false,

Line 244: FTE_ESTIMATE_FREIGHT_RATE.SPLIT_CITY_STATE_ZIP

240: -- Splitting Orgin into City, State and ZIP Code.
241: l_org_error_flag := 'N' ;
242: if nvl(p_org_location_id,0) = 0 then
243: l_org_location_id := null;
244: FTE_ESTIMATE_FREIGHT_RATE.SPLIT_CITY_STATE_ZIP
245: (p_city_state_zip=>p_origin,
246: x_city =>l_origin_city,
247: x_state =>l_origin_state,
248: x_zip =>l_origin_zip,

Line 272: FTE_ESTIMATE_FREIGHT_RATE.SPLIT_CITY_STATE_ZIP

268: end if;
269: -- Splitting Destination into City, State and ZIP Code.
270: if nvl(p_dest_location_id,0) = 0 then
271: l_dest_location_id := null;
272: FTE_ESTIMATE_FREIGHT_RATE.SPLIT_CITY_STATE_ZIP
273: (p_city_state_zip=>p_destination,
274: x_city =>l_destination_city,
275: x_state =>l_destination_state,
276: x_zip =>l_destination_zip,

Line 731: wsh_util_core.default_handler('FTE_ESTIMATE_FREIGHT_RATE.RATE_SEARCH');

727: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
728: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
729:
730: WHEN others then
731: wsh_util_core.default_handler('FTE_ESTIMATE_FREIGHT_RATE.RATE_SEARCH');
732: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
733: --dbms_output.put_line('Unhandled Exception '||sqlerrm );
734: END;
735:

Line 792: END FTE_ESTIMATE_FREIGHT_RATE;

788: x_return_status:= 'E';
789: raise;
790: end;
791:
792: END FTE_ESTIMATE_FREIGHT_RATE;