DBA Data[Home] [Help]

APPS.FTE_MLS_UTIL dependencies on FTE_MLS_UTIL

Line 1: PACKAGE BODY FTE_MLS_UTIL AS

1: PACKAGE BODY FTE_MLS_UTIL AS
2: /* $Header: FTEMLUTB.pls 120.6 2006/05/11 17:10:51 nltan ship $ */
3: --{
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FTE_MLS_UTIL';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FTE_MLS_UTIL';

1: PACKAGE BODY FTE_MLS_UTIL AS
2: /* $Header: FTEMLUTB.pls 120.6 2006/05/11 17:10:51 nltan ship $ */
3: --{
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FTE_MLS_UTIL';
6:
7: --
8: --
9: PROCEDURE api_post_call

Line 108: wsh_util_core.default_handler('FTE_MLS_UTIL.API_POST_CALL');

104: END IF;
105: --}
106: EXCEPTION
107: WHEN OTHERS THEN
108: wsh_util_core.default_handler('FTE_MLS_UTIL.API_POST_CALL');
109: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
110: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
111: END api_post_call;
112: --

Line 156: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_TRIP_SEGMENT_NAME');

152: --}
153: EXCEPTION
154: --{
155: WHEN OTHERS THEN
156: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_TRIP_SEGMENT_NAME');
157: FND_MESSAGE.SET_NAME('FTE','FTE_GET_TRIP_SEG_NAME_ERROR');
158: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_ID',p_trip_segment_id);
159: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
160: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 421: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_PREVIOUS_SEGMENT_ID');

417: --}
418: EXCEPTION
419: --{
420: WHEN OTHERS THEN
421: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_PREVIOUS_SEGMENT_ID');
422: FND_MESSAGE.SET_NAME('FTE','FTE_GET_NEXT_SEGMENT_ERROR');
423: FND_MESSAGE.SET_TOKEN('TRIP_NAME',x_trip_name);
424: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',x_trip_segment_name);
425: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

Line 505: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_FIRST_STOP_LOCATION_ID');

501: --}
502: EXCEPTION
503: --{
504: WHEN OTHERS THEN
505: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_FIRST_STOP_LOCATION_ID');
506: FND_MESSAGE.SET_NAME('FTE','FTE_GET_FIRST_STOP_ERROR');
507: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',x_trip_segment_name);
508: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
509: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 588: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_LAST_STOP_LOCATION_ID');

584: --}
585: EXCEPTION
586: --{
587: WHEN OTHERS THEN
588: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_LAST_STOP_LOCATION_ID');
589: FND_MESSAGE.SET_NAME('FTE','FTE_GET_LAST_STOP_ERROR');
590: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',x_trip_segment_name);
591: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
592: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 799: wsh_util_core.default_handler('FTE_MLS_UTIL.CHECK_NEXT_SEGMENT');

795: --}
796: EXCEPTION
797: --{
798: WHEN OTHERS THEN
799: wsh_util_core.default_handler('FTE_MLS_UTIL.CHECK_NEXT_SEGMENT');
800: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
801: --}
802: END check_next_segment;
803: --

Line 847: wsh_util_core.default_handler('FTE_MLS_UTIL.CHECK_NEXT_SEGMENT');

843: --}
844: EXCEPTION
845: --{
846: WHEN OTHERS THEN
847: wsh_util_core.default_handler('FTE_MLS_UTIL.CHECK_NEXT_SEGMENT');
848: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
849: --}
850: END check_next_segment;
851: --

Line 1051: wsh_util_core.default_handler('FTE_MLS_UTIL.CHECK_PREVIOUS_SEGMENT');

1047: --}
1048: EXCEPTION
1049: --{
1050: WHEN OTHERS THEN
1051: wsh_util_core.default_handler('FTE_MLS_UTIL.CHECK_PREVIOUS_SEGMENT');
1052: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1053: --}
1054: END check_previous_segment;
1055: --

Line 1091: wsh_util_core.default_handler('FTE_MLS_UTIL.CHECK_PREVIOUS_SEGMENT');

1087: --}
1088: EXCEPTION
1089: --{
1090: WHEN OTHERS THEN
1091: wsh_util_core.default_handler('FTE_MLS_UTIL.CHECK_PREVIOUS_SEGMENT');
1092: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1093: --}
1094: END check_previous_segment;
1095: --

Line 1132: wsh_util_core.default_handler('FTE_MLS_UTIL.SEGMENT_HAS_INTRANSIT_DLVY');

1128: RETURN FALSE;
1129: EXCEPTION
1130: --{
1131: WHEN OTHERS THEN
1132: wsh_util_core.default_handler('FTE_MLS_UTIL.SEGMENT_HAS_INTRANSIT_DLVY');
1133: RAISE;
1134: --}
1135: END segment_has_intransit_dlvy;
1136: --

Line 1172: wsh_util_core.default_handler('FTE_MLS_UTIL.SEGMENT_HAS_OTHER_DELIVERIES');

1168: RETURN FALSE;
1169: EXCEPTION
1170: --{
1171: WHEN OTHERS THEN
1172: wsh_util_core.default_handler('FTE_MLS_UTIL.SEGMENT_HAS_OTHER_DELIVERIES');
1173: RAISE;
1174: --}
1175: END segment_has_other_deliveries;
1176: --

Line 1198: wsh_util_core.default_handler('FTE_MLS_UTIL.STOP_HAS_INTRANSIT_DLVY');

1194: );
1195: EXCEPTION
1196: --{
1197: WHEN OTHERS THEN
1198: wsh_util_core.default_handler('FTE_MLS_UTIL.STOP_HAS_INTRANSIT_DLVY');
1199: RAISE;
1200: --}
1201: END stop_has_intransit_dlvy;
1202: --

Line 1237: wsh_util_core.default_handler('FTE_MLS_UTIL.STOP_HAS_INTRANSIT_DLVY');

1233: RETURN FALSE;
1234: EXCEPTION
1235: --{
1236: WHEN OTHERS THEN
1237: wsh_util_core.default_handler('FTE_MLS_UTIL.STOP_HAS_INTRANSIT_DLVY');
1238: RAISE;
1239: --}
1240: END stop_has_intransit_dlvy;
1241: --

Line 1314: wsh_util_core.default_handler('FTE_MLS_UTIL.DERIVE_SHIP_METHOD_CODE');

1310: --}
1311: EXCEPTION
1312: --{
1313: WHEN OTHERS THEN
1314: wsh_util_core.default_handler('FTE_MLS_UTIL.DERIVE_SHIP_METHOD_CODE');
1315: FND_MESSAGE.SET_NAME('FTE','FTE_GET_SHIPMETHOD_UNEXP_ERROR');
1316: FND_MESSAGE.SET_TOKEN('CARRIER_NAME',p_carrier_name);
1317: FND_MESSAGE.SET_TOKEN('MODE_OF_TRANSPORT',NVL(p_mode_of_transport_meaning,'NULL'));
1318: FND_MESSAGE.SET_TOKEN('SERVICE_LEVEL',NVL(p_service_level_meaning,'NULL'));

Line 1384: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_LOCATION');

1380: --}
1381: EXCEPTION
1382: --{
1383: WHEN OTHERS THEN
1384: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_LOCATION');
1385: FND_MESSAGE.SET_NAME('FTE','FTE_GET_LOCATION_UNEXP_ERROR');
1386: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1387: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1388: --}

Line 1424: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_CARRIER_NAME');

1420: RETURN l_carrier_name;
1421: EXCEPTION
1422: --{
1423: WHEN OTHERS THEN
1424: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_CARRIER_NAME');
1425: RAISE;
1426: --}
1427: END get_carrier_name;
1428: --

Line 1659: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_LOCATION');

1655: --}
1656: EXCEPTION
1657: --{
1658: WHEN OTHERS THEN
1659: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_LOCATION');
1660: FND_MESSAGE.SET_NAME('FTE','FTE_GET_LOCATION_UNEXP_ERROR');
1661: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1662: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1663: --}

Line 1818: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_CARRIER_CONTACT_INFO');

1814: p_encoded => FND_API.G_FALSE
1815: );
1816: WHEN OTHERS THEN
1817: ROLLBACK TO GET_CARRIER_CONTACT_INFO_PUB;
1818: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_CARRIER_CONTACT_INFO');
1819: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1820: FND_MSG_PUB.Count_And_Get
1821: (
1822: p_count => x_msg_count,

Line 1865: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_ORG_NAME_BY_FIRSTSTOP');

1861:
1862: --}
1863: EXCEPTION
1864: WHEN OTHERS THEN
1865: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_ORG_NAME_BY_FIRSTSTOP');
1866: RAISE;
1867: --}
1868:
1869: END GET_ORG_NAME_BY_FIRSTSTOP;

Line 1907: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_PICKUP_DLVY_ORG_BY_TRIP');

1903:
1904: --}
1905: EXCEPTION
1906: WHEN OTHERS THEN
1907: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_PICKUP_DLVY_ORG_BY_TRIP');
1908: RAISE;
1909: --}
1910:
1911: END GET_PICKUP_DLVY_ORG_BY_TRIP;

Line 1947: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_PICKUP_DLVY_ORGID_BY_TRIP');

1943:
1944: --}
1945: EXCEPTION
1946: WHEN OTHERS THEN
1947: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_PICKUP_DLVY_ORGID_BY_TRIP');
1948: RAISE;
1949: --}
1950:
1951: END GET_PICKUP_DLVY_ORGID_BY_TRIP;

Line 2086: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_SHIPPER_CONTACT_INFO');

2082: p_encoded => FND_API.G_FALSE
2083: );
2084: WHEN OTHERS THEN
2085: ROLLBACK TO GET_SHIPPER_CONTACT_INFO_PUB;
2086: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_SHIPPER_CONTACT_INFO');
2087: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2088: FND_MSG_PUB.Count_And_Get
2089: (
2090: p_count => x_msg_count,

Line 2152: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_CARRIER_ID');

2148:
2149: EXCEPTION
2150: --{
2151: WHEN OTHERS THEN
2152: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_CARRIER_ID');
2153: RAISE;
2154: --}
2155:
2156: END GET_CARRIER_ID;

Line 2260: wsh_util_core.default_handler('FTE_MLS_UTIL.FTE_UOM_CONV');

2256:
2257: EXCEPTION
2258: --{
2259: WHEN OTHERS THEN
2260: wsh_util_core.default_handler('FTE_MLS_UTIL.FTE_UOM_CONV');
2261: RAISE;
2262: --}
2263:
2264: END FTE_UOM_CONV;

Line 2422: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || 'FTE_MLS_UTIL' || '.' || 'GET_LOOKUP_MEANING';

2418:
2419: l_meaning VARCHAR2(80);
2420:
2421: l_debug_on BOOLEAN;
2422: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || 'FTE_MLS_UTIL' || '.' || 'GET_LOOKUP_MEANING';
2423: --
2424: BEGIN
2425: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2426:

Line 2796: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_CURRENCY_CODE');

2792: IF l_debug_on THEN
2793: WSH_DEBUG_SV.pop(l_module_name);
2794: END IF;
2795: WHEN OTHERS THEN
2796: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_CURRENCY_CODE');
2797: x_return_status := FND_API.G_RET_STS_ERROR;
2798: FND_MSG_PUB.Count_And_Get
2799: (
2800: p_count => x_msg_count,

Line 3044: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_SUPPLIER_INFO');

3040: IF l_debug_on THEN
3041: WSH_DEBUG_SV.pop(l_module_name);
3042: END IF;
3043: WHEN OTHERS THEN
3044: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_SUPPLIER_INFO');
3045: x_return_status := FND_API.G_RET_STS_ERROR;
3046: FND_MSG_PUB.Count_And_Get
3047: (
3048: p_count => x_msg_count,

Line 3392: END FTE_MLS_UTIL;

3388:
3389: END GET_FIRST_LAST_STOP_INFO;
3390:
3391:
3392: END FTE_MLS_UTIL;