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_OTM_REF_DATA_GEN_PKG dependencies on FND_API

Line 850: WHEN FND_API.G_EXC_ERROR THEN

846: END IF;
847: --
848: EXCEPTION
849: --{
850: WHEN FND_API.G_EXC_ERROR THEN
851: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
852: --
853: -- Debug Statements
854: --

Line 856: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

852: --
853: -- Debug Statements
854: --
855: IF l_debug_on THEN
856: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
857: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
858: END IF;
859: --
860: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 857: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

853: -- Debug Statements
854: --
855: IF l_debug_on THEN
856: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
857: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
858: END IF;
859: --
860: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
861: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 860: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

856: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
857: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
858: END IF;
859: --
860: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
861: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
862: --
863: -- Debug Statements
864: --

Line 866: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

862: --
863: -- Debug Statements
864: --
865: IF l_debug_on THEN
866: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
867: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
868: END IF;
869: --
870: WHEN OTHERS THEN

Line 867: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

863: -- Debug Statements
864: --
865: IF l_debug_on THEN
866: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
867: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
868: END IF;
869: --
870: WHEN OTHERS THEN
871: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1649: wsh_util_core.add_message(x_return_status, l_module_name);
1650: IF l_debug_on THEN
1651: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_DOMAIN_NAME is set to NULL. Please correct the profile value');
1652: END IF;
1653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1654: --}
1655: END IF;
1656:
1657: IF (l_country_code is null) THEN

Line 1665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1661: wsh_util_core.add_message(x_return_status, l_module_name);
1662: IF l_debug_on THEN
1663: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_CORP_COUNTRY_CODE is set to NULL. Please correct the profile value');
1664: END IF;
1665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1666: --}
1667: END IF;
1668:
1669: -- Extracting the Org Location Information

Line 2218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2214: wsh_util_core.add_message(x_return_status, l_module_name);
2215: IF l_debug_on THEN
2216: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_USER_ID is set to NULL. Please correct the profile value');
2217: END IF;
2218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2219: --}
2220: END IF;
2221:
2222: IF (x_loc_xmission_rec.password is null) THEN

Line 2231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2227: wsh_util_core.add_message(x_return_status, l_module_name);
2228: IF l_debug_on THEN
2229: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_PASSWORD is set to NULL. Please correct the profile value');
2230: END IF;
2231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2232: --}
2233: END IF;
2234: --
2235: l_profile_queried := true;

Line 2806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2802: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_INVALID_ENTITY');
2803: FND_MESSAGE.SET_TOKEN('ENTITY',p_entity_in_rec.entity_type);
2804: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
2805: wsh_util_core.add_message(x_return_status, l_module_name);
2806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2807: --}
2808: END IF;
2809:
2810: -- wms-otm-proj : Added p_entity_type to Distinguish ORG_LOC separately

Line 2870: WHEN FND_API.G_EXC_ERROR THEN

2866: --
2867: --}
2868: EXCEPTION
2869: --{
2870: WHEN FND_API.G_EXC_ERROR THEN
2871: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2872: --
2873: -- Debug Statements
2874: --

Line 2886: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2882:
2883: x_msg_data := x_msg_data || l_summary || ' ' || l_details;
2884:
2885: IF l_debug_on THEN
2886: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2887: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2888: END IF;
2889: --
2890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2887: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

2883: x_msg_data := x_msg_data || l_summary || ' ' || l_details;
2884:
2885: IF l_debug_on THEN
2886: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2887: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2888: END IF;
2889: --
2890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2891: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 2890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2886: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2887: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2888: END IF;
2889: --
2890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2891: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2892: --
2893: WSH_UTIL_CORE.Get_Messages
2894: (

Line 2907: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2903: --
2904: -- Debug Statements
2905: --
2906: IF l_debug_on THEN
2907: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2908: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2909: END IF;
2910: --
2911: WHEN OTHERS THEN

Line 2908: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

2904: -- Debug Statements
2905: --
2906: IF l_debug_on THEN
2907: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2908: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2909: END IF;
2910: --
2911: WHEN OTHERS THEN
2912: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 3223: WHEN FND_API.G_EXC_ERROR THEN

3219: --
3220: --}
3221: EXCEPTION
3222: --{
3223: WHEN FND_API.G_EXC_ERROR THEN
3224: --
3225: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3226: --
3227:

Line 3229: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

3225: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3226: --
3227:
3228: IF l_debug_on THEN
3229: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3230: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3231: END IF;
3232: --
3233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3230: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

3226: --
3227:
3228: IF l_debug_on THEN
3229: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3230: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3231: END IF;
3232: --
3233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3234: --

Line 3233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3229: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3230: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3231: END IF;
3232: --
3233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3234: --
3235: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3236: --
3237: -- Debug Statements

Line 3240: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

3236: --
3237: -- Debug Statements
3238: --
3239: IF l_debug_on THEN
3240: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3241: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3242: END IF;
3243: --
3244: WHEN OTHERS THEN

Line 3241: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

3237: -- Debug Statements
3238: --
3239: IF l_debug_on THEN
3240: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3241: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3242: END IF;
3243: --
3244: WHEN OTHERS THEN
3245: --