DBA Data[Home] [Help]

APPS.WSH_TRIP_STOPS_PVT dependencies on FND_MESSAGE

Line 365: fnd_message.set_name('WSH', 'WSH_LOCATION_CONVERT_ERR');

361: EXCEPTION
362:
363: WHEN get_physical_loc_err THEN
364: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
365: fnd_message.set_name('WSH', 'WSH_LOCATION_CONVERT_ERR');
366: fnd_message.set_token('LOCATION_NAME',
367: SUBSTRB(WSH_UTIL_CORE.get_location_description(p_trip_stop_info.stop_location_id,'NEW UI CODE'), 1, 60));
368: wsh_util_core.add_message(x_return_status,l_module_name);
369:

Line 366: fnd_message.set_token('LOCATION_NAME',

362:
363: WHEN get_physical_loc_err THEN
364: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
365: fnd_message.set_name('WSH', 'WSH_LOCATION_CONVERT_ERR');
366: fnd_message.set_token('LOCATION_NAME',
367: SUBSTRB(WSH_UTIL_CORE.get_location_description(p_trip_stop_info.stop_location_id,'NEW UI CODE'), 1, 60));
368: wsh_util_core.add_message(x_return_status,l_module_name);
369:
370: WHEN others THEN

Line 534: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_DELETE_ERROR');

530: END IF;
531:
532: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
533: x_return_status := l_return_status;
534: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_DELETE_ERROR');
535: --
536: -- Debug Statements
537: --
538: IF l_debug_on THEN

Line 542: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(l_stop_id, p_caller));

538: IF l_debug_on THEN
539: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
540: END IF;
541: --
542: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(l_stop_id, p_caller));
543: wsh_util_core.add_message(x_return_status,l_module_name);
544: --
545: -- Debug Statements
546: --

Line 671: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_FOUND');

667: WHEN no_data_found THEN
668: IF c_get_trip_status%ISOPEN THEN
669: CLOSE c_get_trip_status;
670: END IF;
671: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_FOUND');
672: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
673: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
674: --
675: -- Debug Statements

Line 688: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_TRIP_STOP_DEL_ERROR');

684: WHEN e_gc3_trip THEN
685: IF c_get_trip_status%ISOPEN THEN
686: CLOSE c_get_trip_status;
687: END IF;
688: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_TRIP_STOP_DEL_ERROR');
689: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
690: wsh_util_core.add_message(x_return_status);
691: --
692: -- Debug Statements

Line 964: FND_MESSAGE.Set_Name('WSH','WSH_STOP_NOT_FOUND');

960: END IF;
961: --
962: EXCEPTION
963: WHEN no_data_found THEN
964: FND_MESSAGE.Set_Name('WSH','WSH_STOP_NOT_FOUND');
965: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
966: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
967: --
968: -- Debug Statements

Line 1053: FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');

1049: FETCH lock_row INTO Recinfo;
1050:
1051: IF (lock_row%NOTFOUND) THEN
1052: CLOSE lock_row;
1053: FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');
1054: app_exception.raise_exception;
1055: END IF;
1056:
1057: CLOSE lock_row;

Line 1285: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

1281: END IF;
1282: --
1283: return;
1284: ELSE
1285: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1286: app_exception.raise_exception;
1287: END IF;
1288:
1289: --

Line 1450: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_FOUND');

1446: OPEN stop_record;
1447: FETCH stop_record INTO x_stop_info;
1448:
1449: IF (stop_record%NOTFOUND) THEN
1450: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_FOUND');
1451: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1452: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
1453: ELSE
1454: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1548: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_FOUND');

1544: FETCH get_id INTO x_id, l_phys_loc_id;
1545:
1546: IF get_id%NOTFOUND THEN
1547: CLOSE get_id;
1548: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_FOUND');
1549: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1550: IF l_debug_on THEN
1551: WSH_DEBUG_SV.pop(l_module_name);
1552: END IF;

Line 1579: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_FOUND');

1575: l_name := WSH_UTIL_CORE.get_location_description(x_id, 'NEW UI CODE');
1576: x_name := SUBSTR(l_name,1,60);
1577:
1578: IF (x_name IS NULL) THEN
1579: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_FOUND');
1580: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1581: --
1582: -- Debug Statements
1583: --

Line 1781: FND_MESSAGE.Set_Name('WSH','WSH_API_INVALID_PARAM_VALUE');

1777: -- OTM R12, glog proj
1778: l_tp_plan_name;
1779: IF get_trip_status%NOTFOUND THEN
1780: CLOSE get_trip_status;
1781: FND_MESSAGE.Set_Name('WSH','WSH_API_INVALID_PARAM_VALUE');
1782: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1783: --
1784: RETURN;
1785: END IF;

Line 1811: FND_MESSAGE.Set_Name('WSH','WSH_API_INVALID_PARAM_VALUE');

1807: l_pad_disabled := FALSE;
1808: l_ssn_disabled := FALSE;
1809:
1810: IF (p_parent_entity_id IS NULL) THEN
1811: FND_MESSAGE.Set_Name('WSH','WSH_API_INVALID_PARAM_VALUE');
1812: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1813: --
1814: -- Debug Statements
1815: --

Line 1831: FND_MESSAGE.Set_Name('WSH','WSH_API_INVALID_PARAM_VALUE');

1827: -- OTM R12, glog proj
1828: l_tp_plan_name;
1829: IF get_trip_status%NOTFOUND THEN
1830: CLOSE get_trip_status;
1831: FND_MESSAGE.Set_Name('WSH','WSH_API_INVALID_PARAM_VALUE');
1832: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1833: --
1834: -- Debug Statements
1835: --

Line 2079: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_COLS_DISABLED');

2075: --
2076: EXCEPTION
2077: WHEN e_all_disabled THEN --3509004:public api changes
2078: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2079: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_COLS_DISABLED');
2080: FND_MESSAGE.Set_Token('ENTITY_ID',p_stop_id);
2081: wsh_util_core.add_message(x_return_status,l_module_name);
2082: IF l_debug_on THEN
2083: -- Nothing is updateable

Line 2080: FND_MESSAGE.Set_Token('ENTITY_ID',p_stop_id);

2076: EXCEPTION
2077: WHEN e_all_disabled THEN --3509004:public api changes
2078: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2079: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_COLS_DISABLED');
2080: FND_MESSAGE.Set_Token('ENTITY_ID',p_stop_id);
2081: wsh_util_core.add_message(x_return_status,l_module_name);
2082: IF l_debug_on THEN
2083: -- Nothing is updateable
2084: WSH_DEBUG_SV.pop(l_module_name,'e_all_disabled');

Line 2088: FND_MESSAGE.SET_NAME('WSH', 'WSH_DP_NO_ENTITY');

2084: WSH_DEBUG_SV.pop(l_module_name,'e_all_disabled');
2085: END IF;
2086:
2087: WHEN WSH_DP_NO_ENTITY THEN
2088: FND_MESSAGE.SET_NAME('WSH', 'WSH_DP_NO_ENTITY');
2089: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
2090: x_return_status := FND_API.G_RET_STS_ERROR;
2091: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2092: if x_msg_count > 1 then

Line 2108: FND_MESSAGE.SET_NAME('WSH', 'WSH_INV_LIST_TYPE');

2104: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_DP_NO_ENTITY');
2105: END IF;
2106: --
2107: WHEN WSH_INV_LIST_TYPE THEN
2108: FND_MESSAGE.SET_NAME('WSH', 'WSH_INV_LIST_TYPE');
2109: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
2110: x_return_status := FND_API.G_RET_STS_ERROR;
2111: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2112: if x_msg_count > 1 then

Line 2149: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');

2145: IF get_trip_status%ISOPEN THEN
2146: CLOSE get_trip_status;
2147: END IF;
2148:
2149: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
2150: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2151:
2152: IF l_debug_on THEN
2153: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2279: FND_MESSAGE.SET_NAME('WSH', 'WSH_STOP_LOCK_FAILED');

2275: --
2276: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
2277: rollback to lock_trip_stop_loop;
2278: IF nvl(p_caller,'!') <> 'WSH_FSTRX' THEN
2279: FND_MESSAGE.SET_NAME('WSH', 'WSH_STOP_LOCK_FAILED');
2280: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',p_rec_attr_tab(l_index).stop_id);
2281: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
2282: END IF;
2283: l_num_errors := l_num_errors + 1;

Line 2280: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',p_rec_attr_tab(l_index).stop_id);

2276: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
2277: rollback to lock_trip_stop_loop;
2278: IF nvl(p_caller,'!') <> 'WSH_FSTRX' THEN
2279: FND_MESSAGE.SET_NAME('WSH', 'WSH_STOP_LOCK_FAILED');
2280: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',p_rec_attr_tab(l_index).stop_id);
2281: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
2282: END IF;
2283: l_num_errors := l_num_errors + 1;
2284: --

Line 2300: FND_MESSAGE.SET_NAME('WSH', 'WSH_UI_NOT_PERFORMED');

2296: --
2297: IF p_valid_index_tab.COUNT = 0 THEN
2298: x_return_status := wsh_util_core.g_ret_sts_success;
2299: ELSIF l_num_errors = p_valid_index_tab.COUNT THEN
2300: FND_MESSAGE.SET_NAME('WSH', 'WSH_UI_NOT_PERFORMED');
2301: x_return_status := wsh_util_core.g_ret_sts_error;
2302: wsh_util_core.add_message(x_return_status,l_module_name);
2303: IF l_debug_on THEN
2304: wsh_debug_sv.logmsg(l_module_name, 'WSH_UI_NOT_PERFORMED');

Line 2308: FND_MESSAGE.SET_NAME('WSH', 'WSH_UI_NOT_PROCESSED');

2304: wsh_debug_sv.logmsg(l_module_name, 'WSH_UI_NOT_PERFORMED');
2305: END IF;
2306: RAISE FND_API.G_EXC_ERROR;
2307: ELSIF l_num_errors > 0 THEN
2308: FND_MESSAGE.SET_NAME('WSH', 'WSH_UI_NOT_PROCESSED');
2309: x_return_status := wsh_util_core.g_ret_sts_warning;
2310: wsh_util_core.add_message(x_return_status,l_module_name);
2311: IF l_debug_on THEN
2312: wsh_debug_sv.logmsg(l_module_name, 'WSH_UI_NOT_PROCESSED');