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 237: FND_MESSAGE.SET_NAME('WSH','WSH_PUB_INVALID_PARAMETER');

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

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

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

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

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

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

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

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

447: IF (l_location_id IS NULL) THEN
448: --Bug 4891887 and 4891881 If call is made from Constraints then ignore the warning
449: IF WSH_FTE_CONSTRAINT_FRAMEWORK.G_CALLING_API IS NULL THEN
450: --The following message is modified as part of bug # 4256319
451: FND_MESSAGE.Set_Name('WSH','WSH_DET_NO_LOCATION_FOR_ORG');
452: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
453: wsh_util_core.add_message(x_api_status,l_module_name);
454: ELSE
455: WSH_FTE_CONSTRAINT_FRAMEWORK.G_CALLING_API :=NULL;

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

512: INTO l_location_id;
513: CLOSE site_to_loc;
514:
515: IF (l_location_id IS NULL) THEN
516: FND_MESSAGE.Set_Name('WSH','WSH_SITE_LOCATION_UNDEFINED');
517: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
518: wsh_util_core.add_message(x_api_status,l_module_name);
519: IF site_to_loc%ISOPEN THEN
520: CLOSE site_to_loc;

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

566: END IF;
567: --
568: RETURN;
569: ELSE
570: FND_MESSAGE.Set_Name('WSH','WSH_API_INVALID_PARAM_VALUE');
571: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
572: --
573: IF l_debug_on THEN
574: WSH_DEBUG_SV.pop(l_module_name);

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

583: --
584: EXCEPTION
585: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
586: x_api_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
587: fnd_message.set_name('WSH','WSH_XC_INVALID_LOCATION');
588: wsh_util_core.add_message(x_api_status,l_module_name);
589: --
590: IF l_debug_on THEN
591: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:G_RET_STS_WARNING');

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

618: END IF;
619: IF site_to_loc%ISOPEN THEN
620: CLOSE site_to_loc;
621: END IF;
622: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
623: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
624:
625: --
626: IF l_debug_on THEN

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

992: FETCH get_freight INTO l_freight_code;
993:
994: IF (get_freight%NOTFOUND) THEN
995: CLOSE get_freight;
996: fnd_message.set_name('WSH','WSH_FREIGHT_CODE_NOT_FOUND');
997: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
998: RAISE NO_DATA_FOUND;
999: END IF;
1000:

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

1590:
1591:
1592: any_found := dbms_sql.execute_and_fetch(rec_cursor);
1593: IF (any_found > 0) THEN
1594: FND_MESSAGE.SET_NAME(p_prod_name,p_msg_name);
1595: APP_EXCEPTION.RAISE_EXCEPTION;
1596: END IF;
1597: --
1598: -- Debug Statements

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

1667: --
1668: EXCEPTION
1669: WHEN OTHERS THEN
1670: dbms_sql.close_cursor(rec_cursor);
1671: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
1672: FND_MESSAGE.Set_Token('PACKAGE','WSH_UTIL_CORE');
1673: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
1674: FND_MESSAGE.Set_Token('ORA_TEXT',query_text);
1675: APP_EXCEPTION.Raise_Exception;

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

1668: EXCEPTION
1669: WHEN OTHERS THEN
1670: dbms_sql.close_cursor(rec_cursor);
1671: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
1672: FND_MESSAGE.Set_Token('PACKAGE','WSH_UTIL_CORE');
1673: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
1674: FND_MESSAGE.Set_Token('ORA_TEXT',query_text);
1675: APP_EXCEPTION.Raise_Exception;
1676: --

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

1669: WHEN OTHERS THEN
1670: dbms_sql.close_cursor(rec_cursor);
1671: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
1672: FND_MESSAGE.Set_Token('PACKAGE','WSH_UTIL_CORE');
1673: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
1674: FND_MESSAGE.Set_Token('ORA_TEXT',query_text);
1675: APP_EXCEPTION.Raise_Exception;
1676: --
1677: -- Debug Statements

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

1670: dbms_sql.close_cursor(rec_cursor);
1671: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
1672: FND_MESSAGE.Set_Token('PACKAGE','WSH_UTIL_CORE');
1673: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
1674: FND_MESSAGE.Set_Token('ORA_TEXT',query_text);
1675: APP_EXCEPTION.Raise_Exception;
1676: --
1677: -- Debug Statements
1678: --

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

1736: --
1737: EXCEPTION
1738: WHEN OTHERS THEN
1739: dbms_sql.close_cursor(rec_cursor);
1740: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
1741: FND_MESSAGE.Set_Token('PACKAGE','WSH_UTIL_CORE');
1742: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
1743: FND_MESSAGE.Set_Token('ORA_TEXT',query_text);
1744: APP_EXCEPTION.Raise_Exception;

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

1737: EXCEPTION
1738: WHEN OTHERS THEN
1739: dbms_sql.close_cursor(rec_cursor);
1740: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
1741: FND_MESSAGE.Set_Token('PACKAGE','WSH_UTIL_CORE');
1742: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
1743: FND_MESSAGE.Set_Token('ORA_TEXT',query_text);
1744: APP_EXCEPTION.Raise_Exception;
1745: --

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

1738: WHEN OTHERS THEN
1739: dbms_sql.close_cursor(rec_cursor);
1740: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
1741: FND_MESSAGE.Set_Token('PACKAGE','WSH_UTIL_CORE');
1742: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
1743: FND_MESSAGE.Set_Token('ORA_TEXT',query_text);
1744: APP_EXCEPTION.Raise_Exception;
1745: --
1746: -- Debug Statements

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

1739: dbms_sql.close_cursor(rec_cursor);
1740: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
1741: FND_MESSAGE.Set_Token('PACKAGE','WSH_UTIL_CORE');
1742: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
1743: FND_MESSAGE.Set_Token('ORA_TEXT',query_text);
1744: APP_EXCEPTION.Raise_Exception;
1745: --
1746: -- Debug Statements
1747: --

Line 1809: msg_buffer := fnd_message.get;

1805:
1806: --IF WSH_UTIL_CORE.G_STORE_MSG_IN_TABLE = FALSE THEN
1807: IF G_STORE_MSG_IN_TABLE = FALSE THEN
1808: IF (l_message_type IS NOT NULL) THEN
1809: msg_buffer := fnd_message.get;
1810: IF msg_buffer is not null THEN
1811: IF l_debug_on THEN
1812: WSH_DEBUG_SV.log(l_module_name,'msg_buffer',msg_buffer);
1813: END IF;

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

1810: IF msg_buffer is not null THEN
1811: IF l_debug_on THEN
1812: WSH_DEBUG_SV.log(l_module_name,'msg_buffer',msg_buffer);
1813: END IF;
1814: fnd_message.set_name('WSH','WSH_UTIL_MESSAGE_'||l_message_type);
1815: fnd_message.set_token('MSG_TEXT',msg_buffer);
1816: END IF;
1817: --
1818: -- Log the message in debug file as well.

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

1811: IF l_debug_on THEN
1812: WSH_DEBUG_SV.log(l_module_name,'msg_buffer',msg_buffer);
1813: END IF;
1814: fnd_message.set_name('WSH','WSH_UTIL_MESSAGE_'||l_message_type);
1815: fnd_message.set_token('MSG_TEXT',msg_buffer);
1816: END IF;
1817: --
1818: -- Log the message in debug file as well.
1819: --

Line 1837: l_encoded_msg := fnd_message.get_encoded ;

1833: OR p_message_type = 'S' THEN
1834: fnd_msg_pub.add;
1835: END IF;
1836: ELSE
1837: l_encoded_msg := fnd_message.get_encoded ;
1838: fnd_message.parse_encoded(l_encoded_msg, l_app_short_name , l_message_name );
1839: fnd_message.set_encoded(l_encoded_msg);
1840: msg_buffer := fnd_message.get;
1841: WSH_INTEGRATION.G_MSG_TABLE(WSH_INTEGRATION.G_MSG_TABLE.COUNT + 1 ).message_name := l_message_name ;

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

1834: fnd_msg_pub.add;
1835: END IF;
1836: ELSE
1837: l_encoded_msg := fnd_message.get_encoded ;
1838: fnd_message.parse_encoded(l_encoded_msg, l_app_short_name , l_message_name );
1839: fnd_message.set_encoded(l_encoded_msg);
1840: msg_buffer := fnd_message.get;
1841: WSH_INTEGRATION.G_MSG_TABLE(WSH_INTEGRATION.G_MSG_TABLE.COUNT + 1 ).message_name := l_message_name ;
1842: WSH_INTEGRATION.G_MSG_TABLE(WSH_INTEGRATION.G_MSG_TABLE.COUNT ).message_text := msg_buffer ;

Line 1839: fnd_message.set_encoded(l_encoded_msg);

1835: END IF;
1836: ELSE
1837: l_encoded_msg := fnd_message.get_encoded ;
1838: fnd_message.parse_encoded(l_encoded_msg, l_app_short_name , l_message_name );
1839: fnd_message.set_encoded(l_encoded_msg);
1840: msg_buffer := fnd_message.get;
1841: WSH_INTEGRATION.G_MSG_TABLE(WSH_INTEGRATION.G_MSG_TABLE.COUNT + 1 ).message_name := l_message_name ;
1842: WSH_INTEGRATION.G_MSG_TABLE(WSH_INTEGRATION.G_MSG_TABLE.COUNT ).message_text := msg_buffer ;
1843: WSH_INTEGRATION.G_MSG_TABLE(WSH_INTEGRATION.G_MSG_TABLE.COUNT ).message_type := p_message_type ;

Line 1840: msg_buffer := fnd_message.get;

1836: ELSE
1837: l_encoded_msg := fnd_message.get_encoded ;
1838: fnd_message.parse_encoded(l_encoded_msg, l_app_short_name , l_message_name );
1839: fnd_message.set_encoded(l_encoded_msg);
1840: msg_buffer := fnd_message.get;
1841: WSH_INTEGRATION.G_MSG_TABLE(WSH_INTEGRATION.G_MSG_TABLE.COUNT + 1 ).message_name := l_message_name ;
1842: WSH_INTEGRATION.G_MSG_TABLE(WSH_INTEGRATION.G_MSG_TABLE.COUNT ).message_text := msg_buffer ;
1843: WSH_INTEGRATION.G_MSG_TABLE(WSH_INTEGRATION.G_MSG_TABLE.COUNT ).message_type := p_message_type ;
1844: --

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

1919: WSH_DEBUG_SV.log(l_module_name,'p_value1',p_value1);
1920: END IF;
1921:
1922: IF p_error_name IS NOT NULL THEN
1923: FND_MESSAGE.SET_NAME('WSH',p_error_name);
1924:
1925: IF p_token1 IS NOT NULL AND p_value1 IS NOT NULL THEN
1926: FND_MESSAGE.SET_TOKEN(p_token1, p_value1);
1927: END IF;

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

1922: IF p_error_name IS NOT NULL THEN
1923: FND_MESSAGE.SET_NAME('WSH',p_error_name);
1924:
1925: IF p_token1 IS NOT NULL AND p_value1 IS NOT NULL THEN
1926: FND_MESSAGE.SET_TOKEN(p_token1, p_value1);
1927: END IF;
1928:
1929: --Bugfix 6816437 Start
1930: IF p_token2 IS NOT NULL AND p_value2 IS NOT NULL THEN

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

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

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

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

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

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

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

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

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

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

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

1971: IF l_debug_on THEN
1972: WSH_DEBUG_SV.log(l_module_name,'p_token7',p_token7);
1973: WSH_DEBUG_SV.log(l_module_name,'p_value7',p_value7);
1974: END IF;
1975: FND_MESSAGE.SET_TOKEN(p_token7, p_value7);
1976: END IF;
1977:
1978: IF p_token8 IS NOT NULL AND p_value8 IS NOT NULL THEN
1979: IF l_debug_on THEN

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

1979: IF l_debug_on THEN
1980: WSH_DEBUG_SV.log(l_module_name,'p_token8',p_token8);
1981: WSH_DEBUG_SV.log(l_module_name,'p_value8',p_value8);
1982: END IF;
1983: FND_MESSAGE.SET_TOKEN(p_token8, p_value8);
1984: END IF;
1985: --Bugfix 6816437 End
1986: END IF;
1987:

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

2046: l_errors := nvl(p_errors, 0);
2047:
2048: IF (l_errors > 0) OR (l_warnings > 0) THEN
2049: IF (l_total > 1) THEN
2050: FND_MESSAGE.SET_NAME('WSH', p_message);
2051: FND_MESSAGE.SET_TOKEN('NUM_ERROR', l_errors);
2052: FND_MESSAGE.SET_TOKEN('NUM_WARN', l_warnings);
2053: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS', l_total - l_errors - l_warnings);
2054:

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

2047:
2048: IF (l_errors > 0) OR (l_warnings > 0) THEN
2049: IF (l_total > 1) THEN
2050: FND_MESSAGE.SET_NAME('WSH', p_message);
2051: FND_MESSAGE.SET_TOKEN('NUM_ERROR', l_errors);
2052: FND_MESSAGE.SET_TOKEN('NUM_WARN', l_warnings);
2053: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS', l_total - l_errors - l_warnings);
2054:
2055: wsh_util_core.add_message(p_return_status, p_module_name);

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

2048: IF (l_errors > 0) OR (l_warnings > 0) THEN
2049: IF (l_total > 1) THEN
2050: FND_MESSAGE.SET_NAME('WSH', p_message);
2051: FND_MESSAGE.SET_TOKEN('NUM_ERROR', l_errors);
2052: FND_MESSAGE.SET_TOKEN('NUM_WARN', l_warnings);
2053: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS', l_total - l_errors - l_warnings);
2054:
2055: wsh_util_core.add_message(p_return_status, p_module_name);
2056: END IF;

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

2049: IF (l_total > 1) THEN
2050: FND_MESSAGE.SET_NAME('WSH', p_message);
2051: FND_MESSAGE.SET_TOKEN('NUM_ERROR', l_errors);
2052: FND_MESSAGE.SET_TOKEN('NUM_WARN', l_warnings);
2053: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS', l_total - l_errors - l_warnings);
2054:
2055: wsh_util_core.add_message(p_return_status, p_module_name);
2056: END IF;
2057:

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

2213: WSH_DEBUG_SV.log(l_module_name,'P_ROUTINE_NAME',P_ROUTINE_NAME);
2214: WSH_DEBUG_SV.log(l_module_name,'P_MODULE_NAME',P_MODULE_NAME);
2215: END IF;
2216: --
2217: FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');
2218: FND_MESSAGE.Set_Token('PACKAGE',p_routine_name);
2219: FND_MESSAGE.Set_Token('ORA_ERROR',sqlcode);
2220: FND_MESSAGE.Set_Token('ORA_TEXT',sqlerrm);
2221: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_UNEXP_ERROR, p_module_name);

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

2214: WSH_DEBUG_SV.log(l_module_name,'P_MODULE_NAME',P_MODULE_NAME);
2215: END IF;
2216: --
2217: FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');
2218: FND_MESSAGE.Set_Token('PACKAGE',p_routine_name);
2219: FND_MESSAGE.Set_Token('ORA_ERROR',sqlcode);
2220: FND_MESSAGE.Set_Token('ORA_TEXT',sqlerrm);
2221: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_UNEXP_ERROR, p_module_name);
2222:

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

2215: END IF;
2216: --
2217: FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');
2218: FND_MESSAGE.Set_Token('PACKAGE',p_routine_name);
2219: FND_MESSAGE.Set_Token('ORA_ERROR',sqlcode);
2220: FND_MESSAGE.Set_Token('ORA_TEXT',sqlerrm);
2221: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_UNEXP_ERROR, p_module_name);
2222:
2223: --

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

2216: --
2217: FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');
2218: FND_MESSAGE.Set_Token('PACKAGE',p_routine_name);
2219: FND_MESSAGE.Set_Token('ORA_ERROR',sqlcode);
2220: FND_MESSAGE.Set_Token('ORA_TEXT',sqlerrm);
2221: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_UNEXP_ERROR, p_module_name);
2222:
2223: --
2224: -- Debug Statements

Line 2242: PROCEDURE Clear_FND_Messages IS

2238: --
2239: default_handler( p_routine_name, NULL );
2240: END default_handler;
2241:
2242: PROCEDURE Clear_FND_Messages IS
2243:
2244: --
2245: l_debug_on BOOLEAN;
2246: --

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

2243:
2244: --
2245: l_debug_on BOOLEAN;
2246: --
2247: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CLEAR_FND_MESSAGES';
2248: --
2249: BEGIN
2250:
2251: --

Line 2266: fnd_message.clear;

2262: IF l_debug_on THEN
2263: WSH_DEBUG_SV.push(l_module_name);
2264: END IF;
2265: --
2266: fnd_message.clear;
2267:
2268: --
2269: -- Debug Statements
2270: --

Line 2275: END Clear_FND_Messages;

2271: IF l_debug_on THEN
2272: WSH_DEBUG_SV.pop(l_module_name);
2273: END IF;
2274: --
2275: END Clear_FND_Messages;
2276:
2277: FUNCTION Get_Org_Name
2278: (p_organization_id IN NUMBER
2279: ) RETURN VARCHAR2 IS

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

2848: elsif (p_type = 'DLEG') then
2849:
2850: -- wsh_delivery_legs_pvt.delete_delivery_leg(null, p_rows(i), cur_return_status);
2851:
2852: fnd_message.set_name('WSH','DEL_DLEG_NOT_IMPLEMENTED_YET');
2853: cur_return_status := wsh_util_core.g_ret_sts_error;
2854: wsh_util_core.add_message(cur_return_status);
2855:
2856: elsif (p_type = 'DLVB') then

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

3391: END IF;
3392: x_ledger_id := NULL;
3393: x_func_currency := NULL;
3394: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3395: fnd_message.set_name('WSH', 'WSH_LEDGER_ID_NOT_FOUND');
3396: WSH_UTIL_CORE.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
3397:
3398: IF l_debug_on THEN
3399: WSH_DEBUG_SV.pop(l_module_name);

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

3535: p_business_flow_code => 21,
3536: p_transaction_id => l_del_tab);
3537:
3538: IF (l_label_return_status <> 'S') THEN
3539: FND_MESSAGE.SET_NAME('WSH','WSH_PRINT_LABEL_ERROR');
3540: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3541: wsh_util_core.add_message(x_return_status);
3542: END IF;
3543: END IF;

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

3851: */
3852:
3853: --
3854: IF p_msg_data IS NOT NULL THEN
3855: fnd_message.set_name('WSH','WSH_MESSAGE_DATA');
3856: fnd_message.set_token('MESSAGE_DATA',p_msg_data);
3857: END IF;
3858: --
3859: --

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

3852:
3853: --
3854: IF p_msg_data IS NOT NULL THEN
3855: fnd_message.set_name('WSH','WSH_MESSAGE_DATA');
3856: fnd_message.set_token('MESSAGE_DATA',p_msg_data);
3857: END IF;
3858: --
3859: --
3860: IF p_return_status IS NULL THEN

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

4095: x_msg_rec_count.w_count := 0;
4096: x_msg_rec_count.u_count := 0;
4097: x_msg_rec_count.s_count := 0;
4098: FOR i IN 1..WSH_INTEGRATION.G_MSG_TABLE.COUNT LOOP
4099: fnd_message.set_name('WSH','WSH_UTIL_MESSAGE_'||WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_TYPE);
4100: fnd_message.set_token('MSG_TEXT',WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_TEXT);
4101: fnd_msg_pub.add;
4102: IF ( WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_TYPE = 'E' ) THEN
4103: x_msg_rec_count.e_count := x_msg_rec_count.e_count + 1 ;

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

4096: x_msg_rec_count.u_count := 0;
4097: x_msg_rec_count.s_count := 0;
4098: FOR i IN 1..WSH_INTEGRATION.G_MSG_TABLE.COUNT LOOP
4099: fnd_message.set_name('WSH','WSH_UTIL_MESSAGE_'||WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_TYPE);
4100: fnd_message.set_token('MSG_TEXT',WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_TEXT);
4101: fnd_msg_pub.add;
4102: IF ( WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_TYPE = 'E' ) THEN
4103: x_msg_rec_count.e_count := x_msg_rec_count.e_count + 1 ;
4104: ELSIF ( WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_TYPE = 'W' ) THEN

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

7789: IF l_debug_on THEN
7790: WSH_DEBUG_SV.logmsg(l_module_name,'Invalid Entity Type Passed');
7791: END IF;
7792: --
7793: FND_MESSAGE.SET_NAME ( 'WSH', 'WSH_INVALID_ENTITY_TYPE' );
7794: FND_MESSAGE.SET_TOKEN ('ENT_TYPE', p_entity_type );
7795: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7796: WSH_UTIL_CORE.add_message(x_return_status);
7797: --

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

7790: WSH_DEBUG_SV.logmsg(l_module_name,'Invalid Entity Type Passed');
7791: END IF;
7792: --
7793: FND_MESSAGE.SET_NAME ( 'WSH', 'WSH_INVALID_ENTITY_TYPE' );
7794: FND_MESSAGE.SET_TOKEN ('ENT_TYPE', p_entity_type );
7795: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7796: WSH_UTIL_CORE.add_message(x_return_status);
7797: --
7798: END IF;

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

7802: --
7803:
7804: IF ( l_error_flag ) THEN
7805: --
7806: FND_MESSAGE.SET_NAME ( 'WSH', 'WSH_DET_INVALID_DEL' );
7807: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7808: WSH_UTIL_CORE.add_message(x_return_status);
7809: --
7810: END IF;

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

8016:
8017: EXCEPTION
8018: when CURR_CONV_TYPE_UNDEFINED_EXP then
8019: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8020: fnd_message.set_name('WSH', 'WSH_CURR_CONV_TYPE_UNDEFINED');
8021: wsh_util_core.add_message(x_return_status);
8022: IF l_debug_on THEN
8023: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
8024: WSH_DEBUG_SV.logmsg(l_module_name, 'WSH: Currency Conversion Type for OTM profile value is not defined.');