DBA Data[Home] [Help]

APPS.WSH_UTIL_VALIDATE dependencies on FND_MESSAGE

Line 239: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ORG');

235: END IF;
236: --
237: IF l_failed THEN
238: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
239: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ORG');
240: wsh_util_core.add_message(x_return_status,l_module_name);
241: END IF;
242: --
243: IF l_debug_on THEN

Line 469: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOCATION');

465: --
466: EXCEPTION
467:
468: WHEN FND_API.G_EXC_ERROR THEN
469: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOCATION');
470: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
471: wsh_util_core.add_message(x_return_status,l_module_name);
472: IF l_debug_on THEN
473: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION G_EXC_ERROR');

Line 476: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOCATION');

472: IF l_debug_on THEN
473: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION G_EXC_ERROR');
474: END IF;
475: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
476: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOCATION');
477: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
478: wsh_util_core.add_message(x_return_status,l_module_name);
479: IF l_debug_on THEN
480: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION G_EXC_UNEXPECTED_ERROR');

Line 598: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_SERVICE_LEVEL');

594: IF g_lookup_tab(l_index).valid_flag = 'N' THEN
595: --OTM R12 bug fix. Added the if condition for service level and
596: --mode of transport to display more specific message to user.
597: IF p_lookup_type = 'WSH_SERVICE_LEVELS' THEN
598: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_SERVICE_LEVEL');
599: ELSIF p_lookup_type = 'WSH_MODE_OF_TRANSPORT' THEN
600: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_MODE_OF_TRANSPORT');
601: ELSE
602: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOOKUP');

Line 600: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_MODE_OF_TRANSPORT');

596: --mode of transport to display more specific message to user.
597: IF p_lookup_type = 'WSH_SERVICE_LEVELS' THEN
598: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_SERVICE_LEVEL');
599: ELSIF p_lookup_type = 'WSH_MODE_OF_TRANSPORT' THEN
600: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_MODE_OF_TRANSPORT');
601: ELSE
602: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOOKUP');
603: END IF;
604: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 602: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOOKUP');

598: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_SERVICE_LEVEL');
599: ELSIF p_lookup_type = 'WSH_MODE_OF_TRANSPORT' THEN
600: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_MODE_OF_TRANSPORT');
601: ELSE
602: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOOKUP');
603: END IF;
604: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
605: wsh_util_core.add_message(x_return_status,l_module_name);
606: END IF;

Line 681: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_CUSTOMER');

677: FETCH check_customer INTO p_customer_id;
678:
679: IF (check_customer%NOTFOUND) THEN
680:
681: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_CUSTOMER');
682: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
683: wsh_util_core.add_message(x_return_status,l_module_name);
684:
685: END IF;

Line 746: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_CONTACT');

742: FETCH check_contact INTO p_contact_id;
743:
744: IF (check_contact%NOTFOUND) THEN
745:
746: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_CONTACT');
747: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
748: wsh_util_core.add_message(x_return_status,l_module_name);
749:
750: END IF;

Line 802: FND_MESSAGE.SET_NAME('WSH','WSH_QUANTITY_NOT_WHOLE');

798: IF (p_quantity IS NOT NULL) THEN
799:
800: IF (p_quantity < 0) OR (p_quantity <> trunc(p_quantity)) THEN
801:
802: FND_MESSAGE.SET_NAME('WSH','WSH_QUANTITY_NOT_WHOLE');
803: FND_MESSAGE.SET_TOKEN('QTY',p_quantity);
804: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
805: wsh_util_core.add_message(x_return_status,l_module_name);
806:

Line 803: FND_MESSAGE.SET_TOKEN('QTY',p_quantity);

799:
800: IF (p_quantity < 0) OR (p_quantity <> trunc(p_quantity)) THEN
801:
802: FND_MESSAGE.SET_NAME('WSH','WSH_QUANTITY_NOT_WHOLE');
803: FND_MESSAGE.SET_TOKEN('QTY',p_quantity);
804: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
805: wsh_util_core.add_message(x_return_status,l_module_name);
806:
807: END IF;

Line 855: FND_MESSAGE.SET_NAME('WSH','WSH_VALUE_NEGATIVE');

851: IF (p_value IS NOT NULL) THEN
852:
853: IF (p_value < 0) THEN
854:
855: FND_MESSAGE.SET_NAME('WSH','WSH_VALUE_NEGATIVE');
856: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
857: wsh_util_core.add_message(x_return_status,l_module_name);
858:
859: END IF;

Line 910: FND_MESSAGE.SET_NAME('WSH','WSH_VALUE_NEGATIVE');

906: IF (p_value IS NOT NULL) THEN
907:
908: IF (p_value < 0) THEN
909:
910: FND_MESSAGE.SET_NAME('WSH','WSH_VALUE_NEGATIVE');
911: FND_MESSAGE.SET_TOKEN('FIELD_NAME',p_field_name);
912: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
913: wsh_util_core.add_message(x_return_status,l_module_name);
914:

Line 911: FND_MESSAGE.SET_TOKEN('FIELD_NAME',p_field_name);

907:
908: IF (p_value < 0) THEN
909:
910: FND_MESSAGE.SET_NAME('WSH','WSH_VALUE_NEGATIVE');
911: FND_MESSAGE.SET_TOKEN('FIELD_NAME',p_field_name);
912: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
913: wsh_util_core.add_message(x_return_status,l_module_name);
914:
915: END IF;

Line 1003: FND_MESSAGE.SET_NAME('FND', error_code);

999: IF (currency_cursor%NOTFOUND) THEN
1000:
1001: IF p_currency_code IS NOT NULL THEN
1002: error_code := 'CURR-Invalid code';
1003: FND_MESSAGE.SET_NAME('FND', error_code);
1004: FND_MESSAGE.SET_TOKEN('CODE',p_currency_code);
1005: ELSE
1006: error_code := 'CURR-Invalid currency value';
1007: FND_MESSAGE.set_name('FND', error_code);

Line 1004: FND_MESSAGE.SET_TOKEN('CODE',p_currency_code);

1000:
1001: IF p_currency_code IS NOT NULL THEN
1002: error_code := 'CURR-Invalid code';
1003: FND_MESSAGE.SET_NAME('FND', error_code);
1004: FND_MESSAGE.SET_TOKEN('CODE',p_currency_code);
1005: ELSE
1006: error_code := 'CURR-Invalid currency value';
1007: FND_MESSAGE.set_name('FND', error_code);
1008: END IF;

Line 1007: FND_MESSAGE.set_name('FND', error_code);

1003: FND_MESSAGE.SET_NAME('FND', error_code);
1004: FND_MESSAGE.SET_TOKEN('CODE',p_currency_code);
1005: ELSE
1006: error_code := 'CURR-Invalid currency value';
1007: FND_MESSAGE.set_name('FND', error_code);
1008: END IF;
1009:
1010: -- OTM R12
1011: CLOSE currency_cursor;

Line 1037: FND_MESSAGE.SET_NAME('FND', error_code);

1033: END IF;
1034: ELSE
1035: -- existing code
1036: error_code := 'CURR-Precision';
1037: FND_MESSAGE.SET_NAME('FND', error_code);
1038: FND_MESSAGE.SET_TOKEN('PRECISON',TO_CHAR(l_precision));
1039: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1040: wsh_util_core.add_message(x_return_status,l_module_name);
1041: END IF;

Line 1038: FND_MESSAGE.SET_TOKEN('PRECISON',TO_CHAR(l_precision));

1034: ELSE
1035: -- existing code
1036: error_code := 'CURR-Precision';
1037: FND_MESSAGE.SET_NAME('FND', error_code);
1038: FND_MESSAGE.SET_TOKEN('PRECISON',TO_CHAR(l_precision));
1039: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1040: wsh_util_core.add_message(x_return_status,l_module_name);
1041: END IF;
1042: END IF;

Line 1189: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ORG');

1185: g_org_uom_class_tab(l_index) := l_cache_rec;
1186: END IF;
1187: -- Always check if input is valid or not
1188: IF g_org_uom_class_tab(l_index).valid_flag = 'N' THEN
1189: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ORG');
1190: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1191: wsh_util_core.add_message(x_return_status,l_module_name);
1192: RETURN;
1193: END IF;

Line 1248: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_UOM');

1244: g_uom_tab(l_uom_index) := l_cache_uom_rec;
1245: END IF;
1246: -- Always check if input is valid or not
1247: IF g_uom_tab(l_uom_index).valid_flag = 'N' THEN
1248: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_UOM');
1249: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1250: wsh_util_core.add_message(x_return_status,l_module_name);
1251: END IF;
1252: -- Always Populate return variables

Line 1332: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_USER');

1328: FETCH check_user INTO p_user_id;
1329:
1330: IF (check_user%NOTFOUND) THEN
1331:
1332: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_USER');
1333: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1334: wsh_util_core.add_message(x_return_status,l_module_name);
1335:
1336: END IF;

Line 1458: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_SHIP_METHOD');

1454: END IF;
1455:
1456: -- Always check if input is valid or not
1457: IF g_ship_method_tab(l_index).valid_flag = 'N' THEN
1458: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_SHIP_METHOD');
1459: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1460: wsh_util_core.add_message(x_return_status,l_module_name);
1461: END IF;
1462:

Line 1536: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_FREIGHT_TERMS');

1532: END IF;
1533:
1534: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1535:
1536: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_FREIGHT_TERMS');
1537: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1538: wsh_util_core.add_message(x_return_status,l_module_name);
1539:
1540: END IF;

Line 1595: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_FOB');

1591: END IF;
1592:
1593: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1594:
1595: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_FOB');
1596: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1597: wsh_util_core.add_message(x_return_status,l_module_name);
1598:
1599: END IF;

Line 1792: FND_MESSAGE.SET_NAME('WSH','WSH_OI_FLEX_DELIMITER_NULL');

1788: END IF;
1789: --
1790: EXCEPTION
1791: WHEN delimiter_null THEN
1792: FND_MESSAGE.SET_NAME('WSH','WSH_OI_FLEX_DELIMITER_NULL');
1793: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1794: --
1795: IF l_debug_on THEN
1796: WSH_DEBUG_SV.logmsg(l_module_name,'DELIMITER_NULL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1801: FND_MESSAGE.SET_NAME('WSH','WSH_OI_FLEX_INV_COMB_ERROR');

1797: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DELIMITER_NULL');
1798: END IF;
1799: --
1800: WHEN wrong_combination THEN
1801: FND_MESSAGE.SET_NAME('WSH','WSH_OI_FLEX_INV_COMB_ERROR');
1802: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1803: --
1804: IF l_debug_on THEN
1805: WSH_DEBUG_SV.logmsg(l_module_name,'WRONG_COMBINATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1888: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ITEM');

1884: x_flag => valid_flag);
1885:
1886: IF valid_flag = FALSE THEN
1887:
1888: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ITEM');
1889: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1890: wsh_util_core.add_message(x_return_status,l_module_name);
1891: IF l_debug_on THEN
1892: WSH_DEBUG_SV.pop(l_module_name);

Line 1907: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ITEM');

1903: x_item_type => l_item_type,
1904: x_return_status => l_return_status);
1905:
1906: IF nvl(l_item_type, FND_API.G_MISS_CHAR) <> p_item_type THEN
1907: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ITEM');
1908: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1909: wsh_util_core.add_message(x_return_status,l_module_name);
1910: END IF;
1911: END IF;

Line 2045: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_UOM');

2041: FETCH check_order_uom INTO x_uom_code;
2042:
2043: IF (check_order_uom%NOTFOUND) THEN
2044:
2045: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_UOM');
2046: FND_MESSAGE.SET_TOKEN('UOM_TYPE','ordered quantity uom');
2047: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2048: wsh_util_core.add_message(x_return_status,l_module_name);
2049:

Line 2046: FND_MESSAGE.SET_TOKEN('UOM_TYPE','ordered quantity uom');

2042:
2043: IF (check_order_uom%NOTFOUND) THEN
2044:
2045: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_UOM');
2046: FND_MESSAGE.SET_TOKEN('UOM_TYPE','ordered quantity uom');
2047: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2048: wsh_util_core.add_message(x_return_status,l_module_name);
2049:
2050: END IF;

Line 2121: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_DEL_NAME');

2117: FETCH check_delivery_name INTO p_delivery_id;
2118:
2119: IF (check_delivery_name%NOTFOUND) THEN
2120:
2121: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_DEL_NAME');
2122: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2123: wsh_util_core.add_message(x_return_status,l_module_name);
2124:
2125: END IF;

Line 2200: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_REPORT_SET');

2196: FETCH check_report_set INTO p_report_set_id;
2197:
2198: IF (check_report_set%NOTFOUND) THEN
2199:
2200: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_REPORT_SET');
2201: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2202: wsh_util_core.add_message(x_return_status,l_module_name);
2203:
2204: END IF;

Line 2269: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOADING_ORDER');

2265: ELSIF upper(p_loading_order_desc) ='REVERSE INVERTED' THEN
2266: p_loading_order_flag := 'RI';
2267: ELSE
2268: --
2269: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOADING_ORDER');
2270: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2271: wsh_util_core.add_message(x_return_status,l_module_name);
2272: --
2273: END IF;

Line 2277: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOADING_ORDER');

2273: END IF;
2274: --
2275: ELSIF p_loading_order_flag NOT IN ('F','FI', 'R','RI') THEN
2276: --
2277: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOADING_ORDER');
2278: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2279: wsh_util_core.add_message(x_return_status,l_module_name);
2280: --
2281: END IF;

Line 2366: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_STOP_NAME');

2362: FETCH check_stop_name INTO p_stop_id;
2363:
2364: IF (check_stop_name%NOTFOUND) THEN
2365:
2366: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_STOP_NAME');
2367: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2368: wsh_util_core.add_message(x_return_status,l_module_name);
2369:
2370: END IF;

Line 2441: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_TRIP_NAME');

2437: FETCH check_trip_name INTO p_trip_id;
2438:
2439: IF (check_trip_name%NOTFOUND) THEN
2440:
2441: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_TRIP_NAME');
2442: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2443: wsh_util_core.add_message(x_return_status,l_module_name);
2444:
2445: END IF;

Line 2510: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_MOT_STOP_COUNT');

2506:
2507: IF l_stop_count = 3 THEN
2508:
2509: l_trip_name := WSH_TRIPS_PVT.Get_Name(p_trip_id);
2510: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_MOT_STOP_COUNT');
2511: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_name);
2512: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2513: wsh_util_core.add_message(x_return_status,l_module_name);
2514:

Line 2511: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_name);

2507: IF l_stop_count = 3 THEN
2508:
2509: l_trip_name := WSH_TRIPS_PVT.Get_Name(p_trip_id);
2510: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_MOT_STOP_COUNT');
2511: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_name);
2512: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2513: wsh_util_core.add_message(x_return_status,l_module_name);
2514:
2515: END IF;

Line 2732: FND_MESSAGE.SET_NAME('WSH','WSH_XC_INVALID_DATE_RANGE');

2728: OR nvl(p_to_date, fnd_api.g_miss_date) <> fnd_api.g_miss_date
2729: THEN
2730: IF (p_from_date > p_to_date) THEN
2731: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2732: FND_MESSAGE.SET_NAME('WSH','WSH_XC_INVALID_DATE_RANGE');
2733: wsh_util_core.add_message(x_return_status,l_module_name);
2734: END IF;
2735: END IF;
2736:

Line 2820: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_STATUS_NO_ACTION');

2816: END IF;
2817:
2818: IF ( nvl(l_valid_trip, FND_API.G_MISS_CHAR) <> 'X' ) THEN
2819: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2820: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_STATUS_NO_ACTION');
2821: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_name);
2822: wsh_util_core.add_message(x_return_status,l_module_name);
2823: END IF;
2824: END IF;

Line 2821: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_name);

2817:
2818: IF ( nvl(l_valid_trip, FND_API.G_MISS_CHAR) <> 'X' ) THEN
2819: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2820: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_STATUS_NO_ACTION');
2821: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_name);
2822: wsh_util_core.add_message(x_return_status,l_module_name);
2823: END IF;
2824: END IF;
2825:

Line 2902: FND_MESSAGE.SET_NAME('WSH','WSH_CARRIER_NOT_FOUND');

2898: open l_carrier_csr;
2899: fetch l_carrier_csr into x_carrier_id;
2900: --
2901: IF l_carrier_csr%NOTFOUND THEN
2902: FND_MESSAGE.SET_NAME('WSH','WSH_CARRIER_NOT_FOUND');
2903: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2904: wsh_util_core.add_message(x_return_status,l_module_name);
2905: END IF;
2906: close l_carrier_csr;

Line 3171: FND_MESSAGE.SET_NAME('WSH', 'WSH_INVALID_ENTITY_TYPE');

3167: IF p_entity_type IS NULL
3168: OR p_entity_type NOT IN ( 'TRIP','DLVY')
3169: THEN
3170: --
3171: FND_MESSAGE.SET_NAME('WSH', 'WSH_INVALID_ENTITY_TYPE');
3172: FND_MESSAGE.SET_TOKEN('ENT_TYPE', p_entity_type);
3173: x_return_status := wsh_util_core.g_ret_sts_error;
3174: wsh_util_core.add_message(x_return_status,l_module_name);
3175: RAISE FND_API.G_EXC_ERROR;

Line 3172: FND_MESSAGE.SET_TOKEN('ENT_TYPE', p_entity_type);

3168: OR p_entity_type NOT IN ( 'TRIP','DLVY')
3169: THEN
3170: --
3171: FND_MESSAGE.SET_NAME('WSH', 'WSH_INVALID_ENTITY_TYPE');
3172: FND_MESSAGE.SET_TOKEN('ENT_TYPE', p_entity_type);
3173: x_return_status := wsh_util_core.g_ret_sts_error;
3174: wsh_util_core.add_message(x_return_status,l_module_name);
3175: RAISE FND_API.G_EXC_ERROR;
3176: --

Line 3370: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_SHIP_METHOD');

3366: x_mode_of_transport;
3367: --
3368: IF l_dlvy_ship_method_code_csr_tp%NOTFOUND THEN
3369: close l_dlvy_ship_method_code_csr_tp;
3370: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_SHIP_METHOD');
3371: x_return_status := wsh_util_core.g_ret_sts_error;
3372: wsh_util_core.add_message(x_return_status,l_module_name);
3373: RAISE FND_API.G_EXC_ERROR;
3374: END IF;

Line 3385: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_SHIP_METHOD');

3381: x_mode_of_transport;
3382: --
3383: IF l_dlvy_ship_method_code_csr%NOTFOUND THEN
3384: close l_dlvy_ship_method_code_csr;
3385: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_SHIP_METHOD');
3386: x_return_status := wsh_util_core.g_ret_sts_error;
3387: wsh_util_core.add_message(x_return_status,l_module_name);
3388: RAISE FND_API.G_EXC_ERROR;
3389: END IF;

Line 3403: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_SHIP_METHOD');

3399: x_mode_of_transport;
3400: --
3401: IF l_trip_ship_method_code_csr%NOTFOUND THEN
3402: close l_trip_ship_method_code_csr;
3403: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_SHIP_METHOD');
3404: x_return_status := wsh_util_core.g_ret_sts_error;
3405: wsh_util_core.add_message(x_return_status,l_module_name);
3406: RAISE FND_API.G_EXC_ERROR;
3407: END IF;

Line 3425: FND_MESSAGE.SET_NAME('WSH','WSH_NO_SHIP_METHOD_FOR_CS');

3421: open l_dlvy_carrier_services_csr_tp;
3422: fetch l_dlvy_carrier_services_csr_tp into x_ship_method_code;
3423: IF l_dlvy_carrier_services_csr_tp%NOTFOUND THEN
3424: close l_dlvy_carrier_services_csr_tp;
3425: FND_MESSAGE.SET_NAME('WSH','WSH_NO_SHIP_METHOD_FOR_CS');
3426: x_return_status := wsh_util_core.g_ret_sts_warning;
3427: wsh_util_core.add_message(x_return_status,l_module_name);
3428: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
3429: END IF;

Line 3437: FND_MESSAGE.SET_NAME('WSH','WSH_NO_SHIP_METHOD_FOR_CS');

3433: open l_dlvy_carrier_services_csr;
3434: fetch l_dlvy_carrier_services_csr into x_ship_method_code;
3435: IF l_dlvy_carrier_services_csr%NOTFOUND THEN
3436: close l_dlvy_carrier_services_csr;
3437: FND_MESSAGE.SET_NAME('WSH','WSH_NO_SHIP_METHOD_FOR_CS');
3438: x_return_status := wsh_util_core.g_ret_sts_warning;
3439: wsh_util_core.add_message(x_return_status,l_module_name);
3440: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
3441: END IF;

Line 3452: FND_MESSAGE.SET_NAME('WSH','WSH_NO_SHIP_METHOD_FOR_CS');

3448: open l_trip_carrier_services_csr;
3449: fetch l_trip_carrier_services_csr into x_ship_method_code;
3450: IF l_trip_carrier_services_csr%NOTFOUND THEN
3451: close l_trip_carrier_services_csr;
3452: FND_MESSAGE.SET_NAME('WSH','WSH_NO_SHIP_METHOD_FOR_CS');
3453: x_return_status := wsh_util_core.g_ret_sts_warning;
3454: wsh_util_core.add_message(x_return_status,l_module_name);
3455: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
3456: END IF;

Line 3523: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_MOT_STOP_COUNT');

3519:
3520: IF l_stop_count = 3 THEN
3521:
3522: l_trip_name := WSH_TRIPS_PVT.Get_Name(p_entity_id);
3523: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_MOT_STOP_COUNT');
3524: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_name);
3525: x_return_status := wsh_util_core.g_ret_sts_error;
3526: wsh_util_core.add_message(x_return_status,l_module_name);
3527: RAISE FND_API.G_EXC_ERROR;

Line 3524: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_name);

3520: IF l_stop_count = 3 THEN
3521:
3522: l_trip_name := WSH_TRIPS_PVT.Get_Name(p_entity_id);
3523: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_MOT_STOP_COUNT');
3524: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_name);
3525: x_return_status := wsh_util_core.g_ret_sts_error;
3526: wsh_util_core.add_message(x_return_status,l_module_name);
3527: RAISE FND_API.G_EXC_ERROR;
3528:

Line 3545: FND_MESSAGE.SET_NAME('WSH','WSH_SHIP_METHOD_CHANGE');

3541: --
3542: IF l_debug_on THEN
3543: wsh_debug_sv.logmsg(l_module_name,'Ship method calculated is different');
3544: END IF;
3545: FND_MESSAGE.SET_NAME('WSH','WSH_SHIP_METHOD_CHANGE');
3546: FND_MESSAGE.SET_TOKEN('ORIG_SM', l_ship_method_code_backup);
3547: FND_MESSAGE.SET_TOKEN('CALC_SM', x_ship_method_code);
3548: x_return_status := wsh_util_core.g_ret_sts_warning;
3549: wsh_util_core.add_message(x_return_status,l_module_name);

Line 3546: FND_MESSAGE.SET_TOKEN('ORIG_SM', l_ship_method_code_backup);

3542: IF l_debug_on THEN
3543: wsh_debug_sv.logmsg(l_module_name,'Ship method calculated is different');
3544: END IF;
3545: FND_MESSAGE.SET_NAME('WSH','WSH_SHIP_METHOD_CHANGE');
3546: FND_MESSAGE.SET_TOKEN('ORIG_SM', l_ship_method_code_backup);
3547: FND_MESSAGE.SET_TOKEN('CALC_SM', x_ship_method_code);
3548: x_return_status := wsh_util_core.g_ret_sts_warning;
3549: wsh_util_core.add_message(x_return_status,l_module_name);
3550: END IF;

Line 3547: FND_MESSAGE.SET_TOKEN('CALC_SM', x_ship_method_code);

3543: wsh_debug_sv.logmsg(l_module_name,'Ship method calculated is different');
3544: END IF;
3545: FND_MESSAGE.SET_NAME('WSH','WSH_SHIP_METHOD_CHANGE');
3546: FND_MESSAGE.SET_TOKEN('ORIG_SM', l_ship_method_code_backup);
3547: FND_MESSAGE.SET_TOKEN('CALC_SM', x_ship_method_code);
3548: x_return_status := wsh_util_core.g_ret_sts_warning;
3549: wsh_util_core.add_message(x_return_status,l_module_name);
3550: END IF;
3551:

Line 3657: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ITEM');

3653: FETCH veh_cont_item_cur INTO
3654: l_container_item_flag, l_shippable_flag, l_vehicle_item_flag;
3655: IF veh_cont_item_cur%NOTFOUND THEN
3656: CLOSE veh_cont_item_cur;
3657: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ITEM');
3658: RAISE FND_API.G_EXC_ERROR;
3659: END IF;
3660: CLOSE veh_cont_item_cur;
3661:

Line 4659: fnd_message.SET_name('WSH', 'WSH_SUPP_LOCN_ERROR');

4655: 1,
4656: 60
4657: );
4658: --
4659: fnd_message.SET_name('WSH', 'WSH_SUPP_LOCN_ERROR');
4660: FND_MESSAGE.SET_TOKEN('LOCATION_NAME',l_location_name);
4661: --
4662: WSH_UTIL_CORE.add_message (wsh_util_core.g_ret_sts_error,l_module_name);
4663: RAISE FND_API.G_EXC_ERROR;

Line 4660: FND_MESSAGE.SET_TOKEN('LOCATION_NAME',l_location_name);

4656: 60
4657: );
4658: --
4659: fnd_message.SET_name('WSH', 'WSH_SUPP_LOCN_ERROR');
4660: FND_MESSAGE.SET_TOKEN('LOCATION_NAME',l_location_name);
4661: --
4662: WSH_UTIL_CORE.add_message (wsh_util_core.g_ret_sts_error,l_module_name);
4663: RAISE FND_API.G_EXC_ERROR;
4664: --}

Line 4780: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');

4776: OPEN check_pick_grouping_rule_name;
4777: FETCH check_pick_grouping_rule_name INTO p_pick_grouping_rule_id;
4778: IF (check_pick_grouping_rule_name%NOTFOUND) THEN
4779: --{
4780: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
4781: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pick Grouping Rule');
4782: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4783: wsh_util_core.add_message(x_return_status,l_module_name);
4784: --}

Line 4781: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pick Grouping Rule');

4777: FETCH check_pick_grouping_rule_name INTO p_pick_grouping_rule_id;
4778: IF (check_pick_grouping_rule_name%NOTFOUND) THEN
4779: --{
4780: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
4781: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pick Grouping Rule');
4782: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4783: wsh_util_core.add_message(x_return_status,l_module_name);
4784: --}
4785: END IF;

Line 4857: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');

4853: OPEN check_pick_sequence_rule_name;
4854: FETCH check_pick_sequence_rule_name INTO p_pick_sequence_rule_id;
4855: IF (check_pick_sequence_rule_name%NOTFOUND) THEN
4856: --{
4857: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
4858: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pick Sequence Rule');
4859: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4860: wsh_util_core.add_message(x_return_status,l_module_name);
4861: --}

Line 4858: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pick Sequence Rule');

4854: FETCH check_pick_sequence_rule_name INTO p_pick_sequence_rule_id;
4855: IF (check_pick_sequence_rule_name%NOTFOUND) THEN
4856: --{
4857: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
4858: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pick Sequence Rule');
4859: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4860: wsh_util_core.add_message(x_return_status,l_module_name);
4861: --}
4862: END IF;

Line 4934: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');

4930: OPEN check_ship_confirm_rule_name;
4931: FETCH check_ship_confirm_rule_name INTO p_ship_confirm_rule_id;
4932: IF (check_ship_confirm_rule_name%NOTFOUND) THEN
4933: --{
4934: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
4935: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ship Confirm Rule');
4936: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4937: wsh_util_core.add_message(x_return_status,l_module_name);
4938: --}

Line 4935: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ship Confirm Rule');

4931: FETCH check_ship_confirm_rule_name INTO p_ship_confirm_rule_id;
4932: IF (check_ship_confirm_rule_name%NOTFOUND) THEN
4933: --{
4934: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
4935: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ship Confirm Rule');
4936: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4937: wsh_util_core.add_message(x_return_status,l_module_name);
4938: --}
4939: END IF;

Line 5010: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');

5006: OPEN check_Picking_Batch_name;
5007: FETCH check_Picking_Batch_name INTO p_Picking_Batch_id;
5008: IF (check_Picking_Batch_name%NOTFOUND) THEN
5009: --{
5010: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
5011: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Picking Batch Name');
5012: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5013: wsh_util_core.add_message(x_return_status,l_module_name);
5014: --}

Line 5011: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Picking Batch Name');

5007: FETCH check_Picking_Batch_name INTO p_Picking_Batch_id;
5008: IF (check_Picking_Batch_name%NOTFOUND) THEN
5009: --{
5010: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
5011: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Picking Batch Name');
5012: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5013: wsh_util_core.add_message(x_return_status,l_module_name);
5014: --}
5015: END IF;

Line 5094: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INACTIVE_SHIP_METHOD');

5090: OPEN check_ship_method;
5091: FETCH check_ship_method INTO p_ship_method_code, p_ship_method_name;
5092: --
5093: IF (check_ship_method%NOTFOUND) THEN
5094: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INACTIVE_SHIP_METHOD');
5095: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5096: wsh_util_core.add_message(x_return_status,l_module_name);
5097: END IF;
5098: --

Line 5220: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_LOOKUP_CODE');

5216: IF l_count = 1 THEN
5217: l_cache_rec.valid_flag := 'Y';
5218: ELSIF l_count > 1 THEN -- more than 1 record found
5219: -- Add this Message to the one at the end
5220: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_LOOKUP_CODE');
5221: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE',p_lookup_type);
5222: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5223: wsh_util_core.add_message(x_return_status,l_module_name);
5224: END IF;

Line 5221: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE',p_lookup_type);

5217: l_cache_rec.valid_flag := 'Y';
5218: ELSIF l_count > 1 THEN -- more than 1 record found
5219: -- Add this Message to the one at the end
5220: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_LOOKUP_CODE');
5221: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE',p_lookup_type);
5222: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5223: wsh_util_core.add_message(x_return_status,l_module_name);
5224: END IF;
5225:

Line 5242: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOOKUP');

5238: END IF;--}
5239:
5240: -- Always check if input is valid or not
5241: IF g_lookup_tab(l_index).valid_flag = 'N' THEN
5242: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOOKUP');
5243: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5244: wsh_util_core.add_message(x_return_status,l_module_name);
5245: END IF;
5246: -- Always Populate return variables

Line 5325: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_FUTURE_SHIP_DATE');

5321: IF l_debug_on THEN
5322: wsh_debug_sv.logmsg(l_module_name, 'Future ship date is not allowed');
5323: END IF;
5324: --
5325: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_FUTURE_SHIP_DATE');
5326: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5327: wsh_util_core.add_message(x_return_status);
5328: --
5329: END IF;