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.WSH_UTIL_CORE dependencies on FND_MESSAGE

Line 233: FND_MESSAGE.SET_NAME('WSH','WSH_PUB_INVALID_PARAMETER');

229: AND p_format <> 'CSZ' THEN
230: l_loc_string := l_loc_string || ', ' || g_loc_desc_Tab(l_counter).country;
231: END IF;
232: ELSE -- bad format_code
233: FND_MESSAGE.SET_NAME('WSH','WSH_PUB_INVALID_PARAMETER');
234: FND_MESSAGE.Set_Token('PARAMETER',p_format);
235: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,
236: l_module_name);
237: IF l_debug_on THEN

Line 234: FND_MESSAGE.Set_Token('PARAMETER',p_format);

230: l_loc_string := l_loc_string || ', ' || g_loc_desc_Tab(l_counter).country;
231: END IF;
232: ELSE -- bad format_code
233: FND_MESSAGE.SET_NAME('WSH','WSH_PUB_INVALID_PARAMETER');
234: FND_MESSAGE.Set_Token('PARAMETER',p_format);
235: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,
236: l_module_name);
237: IF l_debug_on THEN
238: WSH_DEBUG_SV.pop(l_module_name);

Line 314: FND_MESSAGE.Set_Name('WSH','WSH_SITE_LOCATION_UNDEFINED');

310: FETCH get_id INTO p_site_id;
311: CLOSE get_id;
312:
313: IF (p_site_id IS NULL) THEN
314: FND_MESSAGE.Set_Name('WSH','WSH_SITE_LOCATION_UNDEFINED');
315: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
316: IF get_id%ISOPEN THEN
317: CLOSE get_id;
318: END IF;

Line 359: -- If Error message can be retrieved using FND_MESSAGE.GET

355: -- based on p_mode
356: -- x_location_id - Converted to location_id
357: -- x_api_status - WSH_UTIL_CORE.G_RET_STS_SUCCESS
358: -- WSH_UTIL_CORE.G_RET_STS_ERROR
359: -- If Error message can be retrieved using FND_MESSAGE.GET
360: -- Description: Gets location information for a particular inventory
361: -- organization using hr_locations view
362: --
363:

Line 443: FND_MESSAGE.Set_Name('WSH','WSH_DET_NO_LOCATION_FOR_ORG');

439: IF (l_location_id IS NULL) THEN
440: --Bug 4891887 and 4891881 If call is made from Constraints then ignore the warning
441: IF WSH_FTE_CONSTRAINT_FRAMEWORK.G_CALLING_API IS NULL THEN
442: --The following message is modified as part of bug # 4256319
443: FND_MESSAGE.Set_Name('WSH','WSH_DET_NO_LOCATION_FOR_ORG');
444: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
445: wsh_util_core.add_message(x_api_status,l_module_name);
446: ELSE
447: WSH_FTE_CONSTRAINT_FRAMEWORK.G_CALLING_API :=NULL;

Line 508: FND_MESSAGE.Set_Name('WSH','WSH_SITE_LOCATION_UNDEFINED');

504: INTO l_location_id;
505: CLOSE site_to_loc;
506:
507: IF (l_location_id IS NULL) THEN
508: FND_MESSAGE.Set_Name('WSH','WSH_SITE_LOCATION_UNDEFINED');
509: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
510: wsh_util_core.add_message(x_api_status,l_module_name);
511: IF site_to_loc%ISOPEN THEN
512: CLOSE site_to_loc;

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

558: END IF;
559: --
560: RETURN;
561: ELSE
562: FND_MESSAGE.Set_Name('WSH','WSH_API_INVALID_PARAM_VALUE');
563: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
564: --
565: IF l_debug_on THEN
566: WSH_DEBUG_SV.pop(l_module_name);

Line 579: fnd_message.set_name('WSH','WSH_XC_INVALID_LOCATION');

575: --
576: EXCEPTION
577: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
578: x_api_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
579: fnd_message.set_name('WSH','WSH_XC_INVALID_LOCATION');
580: wsh_util_core.add_message(x_api_status,l_module_name);
581: --
582: IF l_debug_on THEN
583: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:G_RET_STS_WARNING');

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

610: END IF;
611: IF site_to_loc%ISOPEN THEN
612: CLOSE site_to_loc;
613: END IF;
614: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
615: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
616:
617: --
618: IF l_debug_on THEN

Line 988: fnd_message.set_name('WSH','WSH_FREIGHT_CODE_NOT_FOUND');

984: FETCH get_freight INTO l_freight_code;
985:
986: IF (get_freight%NOTFOUND) THEN
987: CLOSE get_freight;
988: fnd_message.set_name('WSH','WSH_FREIGHT_CODE_NOT_FOUND');
989: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
990: RAISE NO_DATA_FOUND;
991: END IF;
992:

Line 1586: FND_MESSAGE.SET_NAME(p_prod_name,p_msg_name);

1582:
1583:
1584: any_found := dbms_sql.execute_and_fetch(rec_cursor);
1585: IF (any_found > 0) THEN
1586: FND_MESSAGE.SET_NAME(p_prod_name,p_msg_name);
1587: APP_EXCEPTION.RAISE_EXCEPTION;
1588: END IF;
1589: --
1590: -- Debug Statements

Line 1663: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');

1659: --
1660: EXCEPTION
1661: WHEN OTHERS THEN
1662: dbms_sql.close_cursor(rec_cursor);
1663: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
1664: FND_MESSAGE.Set_Token('PACKAGE','WSH_UTIL_CORE');
1665: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
1666: FND_MESSAGE.Set_Token('ORA_TEXT',query_text);
1667: APP_EXCEPTION.Raise_Exception;

Line 1664: FND_MESSAGE.Set_Token('PACKAGE','WSH_UTIL_CORE');

1660: EXCEPTION
1661: WHEN OTHERS THEN
1662: dbms_sql.close_cursor(rec_cursor);
1663: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
1664: FND_MESSAGE.Set_Token('PACKAGE','WSH_UTIL_CORE');
1665: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
1666: FND_MESSAGE.Set_Token('ORA_TEXT',query_text);
1667: APP_EXCEPTION.Raise_Exception;
1668: --

Line 1665: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));

1661: WHEN OTHERS THEN
1662: dbms_sql.close_cursor(rec_cursor);
1663: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
1664: FND_MESSAGE.Set_Token('PACKAGE','WSH_UTIL_CORE');
1665: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
1666: FND_MESSAGE.Set_Token('ORA_TEXT',query_text);
1667: APP_EXCEPTION.Raise_Exception;
1668: --
1669: -- Debug Statements

Line 1666: FND_MESSAGE.Set_Token('ORA_TEXT',query_text);

1662: dbms_sql.close_cursor(rec_cursor);
1663: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
1664: FND_MESSAGE.Set_Token('PACKAGE','WSH_UTIL_CORE');
1665: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
1666: FND_MESSAGE.Set_Token('ORA_TEXT',query_text);
1667: APP_EXCEPTION.Raise_Exception;
1668: --
1669: -- Debug Statements
1670: --

Line 1732: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');

1728: --
1729: EXCEPTION
1730: WHEN OTHERS THEN
1731: dbms_sql.close_cursor(rec_cursor);
1732: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
1733: FND_MESSAGE.Set_Token('PACKAGE','WSH_UTIL_CORE');
1734: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
1735: FND_MESSAGE.Set_Token('ORA_TEXT',query_text);
1736: APP_EXCEPTION.Raise_Exception;

Line 1733: FND_MESSAGE.Set_Token('PACKAGE','WSH_UTIL_CORE');

1729: EXCEPTION
1730: WHEN OTHERS THEN
1731: dbms_sql.close_cursor(rec_cursor);
1732: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
1733: FND_MESSAGE.Set_Token('PACKAGE','WSH_UTIL_CORE');
1734: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
1735: FND_MESSAGE.Set_Token('ORA_TEXT',query_text);
1736: APP_EXCEPTION.Raise_Exception;
1737: --

Line 1734: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));

1730: WHEN OTHERS THEN
1731: dbms_sql.close_cursor(rec_cursor);
1732: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
1733: FND_MESSAGE.Set_Token('PACKAGE','WSH_UTIL_CORE');
1734: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
1735: FND_MESSAGE.Set_Token('ORA_TEXT',query_text);
1736: APP_EXCEPTION.Raise_Exception;
1737: --
1738: -- Debug Statements

Line 1735: FND_MESSAGE.Set_Token('ORA_TEXT',query_text);

1731: dbms_sql.close_cursor(rec_cursor);
1732: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
1733: FND_MESSAGE.Set_Token('PACKAGE','WSH_UTIL_CORE');
1734: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
1735: FND_MESSAGE.Set_Token('ORA_TEXT',query_text);
1736: APP_EXCEPTION.Raise_Exception;
1737: --
1738: -- Debug Statements
1739: --

Line 1801: msg_buffer := fnd_message.get;

1797:
1798: --IF WSH_UTIL_CORE.G_STORE_MSG_IN_TABLE = FALSE THEN
1799: IF G_STORE_MSG_IN_TABLE = FALSE THEN
1800: IF (l_message_type IS NOT NULL) THEN
1801: msg_buffer := fnd_message.get;
1802: IF msg_buffer is not null THEN
1803: IF l_debug_on THEN
1804: WSH_DEBUG_SV.log(l_module_name,'msg_buffer',msg_buffer);
1805: END IF;

Line 1806: fnd_message.set_name('WSH','WSH_UTIL_MESSAGE_'||l_message_type);

1802: IF msg_buffer is not null THEN
1803: IF l_debug_on THEN
1804: WSH_DEBUG_SV.log(l_module_name,'msg_buffer',msg_buffer);
1805: END IF;
1806: fnd_message.set_name('WSH','WSH_UTIL_MESSAGE_'||l_message_type);
1807: fnd_message.set_token('MSG_TEXT',msg_buffer);
1808: END IF;
1809: --
1810: -- Log the message in debug file as well.

Line 1807: fnd_message.set_token('MSG_TEXT',msg_buffer);

1803: IF l_debug_on THEN
1804: WSH_DEBUG_SV.log(l_module_name,'msg_buffer',msg_buffer);
1805: END IF;
1806: fnd_message.set_name('WSH','WSH_UTIL_MESSAGE_'||l_message_type);
1807: fnd_message.set_token('MSG_TEXT',msg_buffer);
1808: END IF;
1809: --
1810: -- Log the message in debug file as well.
1811: --

Line 1829: l_encoded_msg := fnd_message.get_encoded ;

1825: OR p_message_type = 'S' THEN
1826: fnd_msg_pub.add;
1827: END IF;
1828: ELSE
1829: l_encoded_msg := fnd_message.get_encoded ;
1830: fnd_message.parse_encoded(l_encoded_msg, l_app_short_name , l_message_name );
1831: fnd_message.set_encoded(l_encoded_msg);
1832: msg_buffer := fnd_message.get;
1833: WSH_INTEGRATION.G_MSG_TABLE(WSH_INTEGRATION.G_MSG_TABLE.COUNT + 1 ).message_name := l_message_name ;

Line 1830: fnd_message.parse_encoded(l_encoded_msg, l_app_short_name , l_message_name );

1826: fnd_msg_pub.add;
1827: END IF;
1828: ELSE
1829: l_encoded_msg := fnd_message.get_encoded ;
1830: fnd_message.parse_encoded(l_encoded_msg, l_app_short_name , l_message_name );
1831: fnd_message.set_encoded(l_encoded_msg);
1832: msg_buffer := fnd_message.get;
1833: WSH_INTEGRATION.G_MSG_TABLE(WSH_INTEGRATION.G_MSG_TABLE.COUNT + 1 ).message_name := l_message_name ;
1834: WSH_INTEGRATION.G_MSG_TABLE(WSH_INTEGRATION.G_MSG_TABLE.COUNT ).message_text := msg_buffer ;

Line 1831: fnd_message.set_encoded(l_encoded_msg);

1827: END IF;
1828: ELSE
1829: l_encoded_msg := fnd_message.get_encoded ;
1830: fnd_message.parse_encoded(l_encoded_msg, l_app_short_name , l_message_name );
1831: fnd_message.set_encoded(l_encoded_msg);
1832: msg_buffer := fnd_message.get;
1833: WSH_INTEGRATION.G_MSG_TABLE(WSH_INTEGRATION.G_MSG_TABLE.COUNT + 1 ).message_name := l_message_name ;
1834: WSH_INTEGRATION.G_MSG_TABLE(WSH_INTEGRATION.G_MSG_TABLE.COUNT ).message_text := msg_buffer ;
1835: WSH_INTEGRATION.G_MSG_TABLE(WSH_INTEGRATION.G_MSG_TABLE.COUNT ).message_type := p_message_type ;

Line 1832: msg_buffer := fnd_message.get;

1828: ELSE
1829: l_encoded_msg := fnd_message.get_encoded ;
1830: fnd_message.parse_encoded(l_encoded_msg, l_app_short_name , l_message_name );
1831: fnd_message.set_encoded(l_encoded_msg);
1832: msg_buffer := fnd_message.get;
1833: WSH_INTEGRATION.G_MSG_TABLE(WSH_INTEGRATION.G_MSG_TABLE.COUNT + 1 ).message_name := l_message_name ;
1834: WSH_INTEGRATION.G_MSG_TABLE(WSH_INTEGRATION.G_MSG_TABLE.COUNT ).message_text := msg_buffer ;
1835: WSH_INTEGRATION.G_MSG_TABLE(WSH_INTEGRATION.G_MSG_TABLE.COUNT ).message_type := p_message_type ;
1836: --

Line 1915: FND_MESSAGE.SET_NAME('WSH',p_error_name);

1911: WSH_DEBUG_SV.log(l_module_name,'p_value1',p_value1);
1912: END IF;
1913:
1914: IF p_error_name IS NOT NULL THEN
1915: FND_MESSAGE.SET_NAME('WSH',p_error_name);
1916:
1917: IF p_token1 IS NOT NULL AND p_value1 IS NOT NULL THEN
1918: FND_MESSAGE.SET_TOKEN(p_token1, p_value1);
1919: END IF;

Line 1918: FND_MESSAGE.SET_TOKEN(p_token1, p_value1);

1914: IF p_error_name IS NOT NULL THEN
1915: FND_MESSAGE.SET_NAME('WSH',p_error_name);
1916:
1917: IF p_token1 IS NOT NULL AND p_value1 IS NOT NULL THEN
1918: FND_MESSAGE.SET_TOKEN(p_token1, p_value1);
1919: END IF;
1920:
1921: --Bugfix 6816437 Start
1922: IF p_token2 IS NOT NULL AND p_value2 IS NOT NULL THEN

Line 1927: FND_MESSAGE.SET_TOKEN(p_token2, p_value2);

1923: IF l_debug_on THEN
1924: WSH_DEBUG_SV.log(l_module_name,'p_token2',p_token2);
1925: WSH_DEBUG_SV.log(l_module_name,'p_value2',p_value2);
1926: END IF;
1927: FND_MESSAGE.SET_TOKEN(p_token2, p_value2);
1928: END IF;
1929:
1930: IF p_token3 IS NOT NULL AND p_value3 IS NOT NULL THEN
1931: IF l_debug_on THEN

Line 1935: FND_MESSAGE.SET_TOKEN(p_token3, p_value3);

1931: IF l_debug_on THEN
1932: WSH_DEBUG_SV.log(l_module_name,'p_token3',p_token3);
1933: WSH_DEBUG_SV.log(l_module_name,'p_value3',p_value3);
1934: END IF;
1935: FND_MESSAGE.SET_TOKEN(p_token3, p_value3);
1936: END IF;
1937:
1938: IF p_token4 IS NOT NULL AND p_value4 IS NOT NULL THEN
1939: IF l_debug_on THEN

Line 1943: FND_MESSAGE.SET_TOKEN(p_token4, p_value4);

1939: IF l_debug_on THEN
1940: WSH_DEBUG_SV.log(l_module_name,'p_token4',p_token4);
1941: WSH_DEBUG_SV.log(l_module_name,'p_value4',p_value4);
1942: END IF;
1943: FND_MESSAGE.SET_TOKEN(p_token4, p_value4);
1944: END IF;
1945:
1946: IF p_token5 IS NOT NULL AND p_value5 IS NOT NULL THEN
1947: IF l_debug_on THEN

Line 1951: FND_MESSAGE.SET_TOKEN(p_token5, p_value5);

1947: IF l_debug_on THEN
1948: WSH_DEBUG_SV.log(l_module_name,'p_token5',p_token5);
1949: WSH_DEBUG_SV.log(l_module_name,'p_value5',p_value5);
1950: END IF;
1951: FND_MESSAGE.SET_TOKEN(p_token5, p_value5);
1952: END IF;
1953:
1954: IF p_token6 IS NOT NULL AND p_value6 IS NOT NULL THEN
1955: IF l_debug_on THEN

Line 1959: FND_MESSAGE.SET_TOKEN(p_token6, p_value6);

1955: IF l_debug_on THEN
1956: WSH_DEBUG_SV.log(l_module_name,'p_token6',p_token6);
1957: WSH_DEBUG_SV.log(l_module_name,'p_value6',p_value6);
1958: END IF;
1959: FND_MESSAGE.SET_TOKEN(p_token6, p_value6);
1960: END IF;
1961:
1962: IF p_token7 IS NOT NULL AND p_value7 IS NOT NULL THEN
1963: IF l_debug_on THEN

Line 1967: FND_MESSAGE.SET_TOKEN(p_token7, p_value7);

1963: IF l_debug_on THEN
1964: WSH_DEBUG_SV.log(l_module_name,'p_token7',p_token7);
1965: WSH_DEBUG_SV.log(l_module_name,'p_value7',p_value7);
1966: END IF;
1967: FND_MESSAGE.SET_TOKEN(p_token7, p_value7);
1968: END IF;
1969:
1970: IF p_token8 IS NOT NULL AND p_value8 IS NOT NULL THEN
1971: IF l_debug_on THEN

Line 1975: FND_MESSAGE.SET_TOKEN(p_token8, p_value8);

1971: IF l_debug_on THEN
1972: WSH_DEBUG_SV.log(l_module_name,'p_token8',p_token8);
1973: WSH_DEBUG_SV.log(l_module_name,'p_value8',p_value8);
1974: END IF;
1975: FND_MESSAGE.SET_TOKEN(p_token8, p_value8);
1976: END IF;
1977: --Bugfix 6816437 End
1978: END IF;
1979:

Line 2042: FND_MESSAGE.SET_NAME('WSH', p_message);

2038: l_errors := nvl(p_errors, 0);
2039:
2040: IF (l_errors > 0) OR (l_warnings > 0) THEN
2041: IF (l_total > 1) THEN
2042: FND_MESSAGE.SET_NAME('WSH', p_message);
2043: FND_MESSAGE.SET_TOKEN('NUM_ERROR', l_errors);
2044: FND_MESSAGE.SET_TOKEN('NUM_WARN', l_warnings);
2045: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS', l_total - l_errors - l_warnings);
2046:

Line 2043: FND_MESSAGE.SET_TOKEN('NUM_ERROR', l_errors);

2039:
2040: IF (l_errors > 0) OR (l_warnings > 0) THEN
2041: IF (l_total > 1) THEN
2042: FND_MESSAGE.SET_NAME('WSH', p_message);
2043: FND_MESSAGE.SET_TOKEN('NUM_ERROR', l_errors);
2044: FND_MESSAGE.SET_TOKEN('NUM_WARN', l_warnings);
2045: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS', l_total - l_errors - l_warnings);
2046:
2047: wsh_util_core.add_message(p_return_status, p_module_name);

Line 2044: FND_MESSAGE.SET_TOKEN('NUM_WARN', l_warnings);

2040: IF (l_errors > 0) OR (l_warnings > 0) THEN
2041: IF (l_total > 1) THEN
2042: FND_MESSAGE.SET_NAME('WSH', p_message);
2043: FND_MESSAGE.SET_TOKEN('NUM_ERROR', l_errors);
2044: FND_MESSAGE.SET_TOKEN('NUM_WARN', l_warnings);
2045: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS', l_total - l_errors - l_warnings);
2046:
2047: wsh_util_core.add_message(p_return_status, p_module_name);
2048: END IF;

Line 2045: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS', l_total - l_errors - l_warnings);

2041: IF (l_total > 1) THEN
2042: FND_MESSAGE.SET_NAME('WSH', p_message);
2043: FND_MESSAGE.SET_TOKEN('NUM_ERROR', l_errors);
2044: FND_MESSAGE.SET_TOKEN('NUM_WARN', l_warnings);
2045: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS', l_total - l_errors - l_warnings);
2046:
2047: wsh_util_core.add_message(p_return_status, p_module_name);
2048: END IF;
2049:

Line 2209: FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');

2205: WSH_DEBUG_SV.log(l_module_name,'P_ROUTINE_NAME',P_ROUTINE_NAME);
2206: WSH_DEBUG_SV.log(l_module_name,'P_MODULE_NAME',P_MODULE_NAME);
2207: END IF;
2208: --
2209: FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');
2210: FND_MESSAGE.Set_Token('PACKAGE',p_routine_name);
2211: FND_MESSAGE.Set_Token('ORA_ERROR',sqlcode);
2212: FND_MESSAGE.Set_Token('ORA_TEXT',sqlerrm);
2213: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_UNEXP_ERROR, p_module_name);

Line 2210: FND_MESSAGE.Set_Token('PACKAGE',p_routine_name);

2206: WSH_DEBUG_SV.log(l_module_name,'P_MODULE_NAME',P_MODULE_NAME);
2207: END IF;
2208: --
2209: FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');
2210: FND_MESSAGE.Set_Token('PACKAGE',p_routine_name);
2211: FND_MESSAGE.Set_Token('ORA_ERROR',sqlcode);
2212: FND_MESSAGE.Set_Token('ORA_TEXT',sqlerrm);
2213: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_UNEXP_ERROR, p_module_name);
2214:

Line 2211: FND_MESSAGE.Set_Token('ORA_ERROR',sqlcode);

2207: END IF;
2208: --
2209: FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');
2210: FND_MESSAGE.Set_Token('PACKAGE',p_routine_name);
2211: FND_MESSAGE.Set_Token('ORA_ERROR',sqlcode);
2212: FND_MESSAGE.Set_Token('ORA_TEXT',sqlerrm);
2213: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_UNEXP_ERROR, p_module_name);
2214:
2215: --

Line 2212: FND_MESSAGE.Set_Token('ORA_TEXT',sqlerrm);

2208: --
2209: FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');
2210: FND_MESSAGE.Set_Token('PACKAGE',p_routine_name);
2211: FND_MESSAGE.Set_Token('ORA_ERROR',sqlcode);
2212: FND_MESSAGE.Set_Token('ORA_TEXT',sqlerrm);
2213: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_UNEXP_ERROR, p_module_name);
2214:
2215: --
2216: -- Debug Statements

Line 2234: PROCEDURE Clear_FND_Messages IS

2230: --
2231: default_handler( p_routine_name, NULL );
2232: END default_handler;
2233:
2234: PROCEDURE Clear_FND_Messages IS
2235:
2236: --
2237: l_debug_on BOOLEAN;
2238: --

Line 2239: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CLEAR_FND_MESSAGES';

2235:
2236: --
2237: l_debug_on BOOLEAN;
2238: --
2239: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CLEAR_FND_MESSAGES';
2240: --
2241: BEGIN
2242:
2243: --

Line 2258: fnd_message.clear;

2254: IF l_debug_on THEN
2255: WSH_DEBUG_SV.push(l_module_name);
2256: END IF;
2257: --
2258: fnd_message.clear;
2259:
2260: --
2261: -- Debug Statements
2262: --

Line 2267: END Clear_FND_Messages;

2263: IF l_debug_on THEN
2264: WSH_DEBUG_SV.pop(l_module_name);
2265: END IF;
2266: --
2267: END Clear_FND_Messages;
2268:
2269: FUNCTION Get_Org_Name
2270: (p_organization_id IN NUMBER
2271: ) RETURN VARCHAR2 IS

Line 2816: fnd_message.set_name('WSH','DEL_DLEG_NOT_IMPLEMENTED_YET');

2812: elsif (p_type = 'DLEG') then
2813:
2814: -- wsh_delivery_legs_pvt.delete_delivery_leg(null, p_rows(i), cur_return_status);
2815:
2816: fnd_message.set_name('WSH','DEL_DLEG_NOT_IMPLEMENTED_YET');
2817: cur_return_status := wsh_util_core.g_ret_sts_error;
2818: wsh_util_core.add_message(cur_return_status);
2819:
2820: elsif (p_type = 'DLVB') then

Line 3359: fnd_message.set_name('WSH', 'WSH_LEDGER_ID_NOT_FOUND');

3355: END IF;
3356: x_ledger_id := NULL;
3357: x_func_currency := NULL;
3358: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3359: fnd_message.set_name('WSH', 'WSH_LEDGER_ID_NOT_FOUND');
3360: WSH_UTIL_CORE.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
3361:
3362: IF l_debug_on THEN
3363: WSH_DEBUG_SV.pop(l_module_name);

Line 3503: FND_MESSAGE.SET_NAME('WSH','WSH_PRINT_LABEL_ERROR');

3499: p_business_flow_code => 21,
3500: p_transaction_id => l_del_tab);
3501:
3502: IF (l_label_return_status <> 'S') THEN
3503: FND_MESSAGE.SET_NAME('WSH','WSH_PRINT_LABEL_ERROR');
3504: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3505: wsh_util_core.add_message(x_return_status);
3506: END IF;
3507: END IF;

Line 3819: fnd_message.set_name('WSH','WSH_MESSAGE_DATA');

3815: */
3816:
3817: --
3818: IF p_msg_data IS NOT NULL THEN
3819: fnd_message.set_name('WSH','WSH_MESSAGE_DATA');
3820: fnd_message.set_token('MESSAGE_DATA',p_msg_data);
3821: END IF;
3822: --
3823: --

Line 3820: fnd_message.set_token('MESSAGE_DATA',p_msg_data);

3816:
3817: --
3818: IF p_msg_data IS NOT NULL THEN
3819: fnd_message.set_name('WSH','WSH_MESSAGE_DATA');
3820: fnd_message.set_token('MESSAGE_DATA',p_msg_data);
3821: END IF;
3822: --
3823: --
3824: IF p_return_status IS NULL THEN

Line 4063: fnd_message.set_name('WSH','WSH_UTIL_MESSAGE_'||WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_TYPE);

4059: x_msg_rec_count.w_count := 0;
4060: x_msg_rec_count.u_count := 0;
4061: x_msg_rec_count.s_count := 0;
4062: FOR i IN 1..WSH_INTEGRATION.G_MSG_TABLE.COUNT LOOP
4063: fnd_message.set_name('WSH','WSH_UTIL_MESSAGE_'||WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_TYPE);
4064: fnd_message.set_token('MSG_TEXT',WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_TEXT);
4065: fnd_msg_pub.add;
4066: IF ( WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_TYPE = 'E' ) THEN
4067: x_msg_rec_count.e_count := x_msg_rec_count.e_count + 1 ;

Line 4064: fnd_message.set_token('MSG_TEXT',WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_TEXT);

4060: x_msg_rec_count.u_count := 0;
4061: x_msg_rec_count.s_count := 0;
4062: FOR i IN 1..WSH_INTEGRATION.G_MSG_TABLE.COUNT LOOP
4063: fnd_message.set_name('WSH','WSH_UTIL_MESSAGE_'||WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_TYPE);
4064: fnd_message.set_token('MSG_TEXT',WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_TEXT);
4065: fnd_msg_pub.add;
4066: IF ( WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_TYPE = 'E' ) THEN
4067: x_msg_rec_count.e_count := x_msg_rec_count.e_count + 1 ;
4068: ELSIF ( WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_TYPE = 'W' ) THEN

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

7753: IF l_debug_on THEN
7754: WSH_DEBUG_SV.logmsg(l_module_name,'Invalid Entity Type Passed');
7755: END IF;
7756: --
7757: FND_MESSAGE.SET_NAME ( 'WSH', 'WSH_INVALID_ENTITY_TYPE' );
7758: FND_MESSAGE.SET_TOKEN ('ENT_TYPE', p_entity_type );
7759: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7760: WSH_UTIL_CORE.add_message(x_return_status);
7761: --

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

7754: WSH_DEBUG_SV.logmsg(l_module_name,'Invalid Entity Type Passed');
7755: END IF;
7756: --
7757: FND_MESSAGE.SET_NAME ( 'WSH', 'WSH_INVALID_ENTITY_TYPE' );
7758: FND_MESSAGE.SET_TOKEN ('ENT_TYPE', p_entity_type );
7759: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7760: WSH_UTIL_CORE.add_message(x_return_status);
7761: --
7762: END IF;

Line 7770: FND_MESSAGE.SET_NAME ( 'WSH', 'WSH_DET_INVALID_DEL' );

7766: --
7767:
7768: IF ( l_error_flag ) THEN
7769: --
7770: FND_MESSAGE.SET_NAME ( 'WSH', 'WSH_DET_INVALID_DEL' );
7771: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7772: WSH_UTIL_CORE.add_message(x_return_status);
7773: --
7774: END IF;

Line 7984: fnd_message.set_name('WSH', 'WSH_CURR_CONV_TYPE_UNDEFINED');

7980:
7981: EXCEPTION
7982: when CURR_CONV_TYPE_UNDEFINED_EXP then
7983: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7984: fnd_message.set_name('WSH', 'WSH_CURR_CONV_TYPE_UNDEFINED');
7985: wsh_util_core.add_message(x_return_status);
7986: IF l_debug_on THEN
7987: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
7988: WSH_DEBUG_SV.logmsg(l_module_name, 'WSH: Currency Conversion Type for OTM profile value is not defined.');