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 811: WHEN FND_API.G_EXC_ERROR THEN

807: END IF;
808: --
809: EXCEPTION
810: --{
811: WHEN FND_API.G_EXC_ERROR THEN
812: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
813: --
814: -- Debug Statements
815: --

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

813: --
814: -- Debug Statements
815: --
816: IF l_debug_on THEN
817: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
818: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
819: END IF;
820: --
821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

814: -- Debug Statements
815: --
816: IF l_debug_on THEN
817: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
818: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
819: END IF;
820: --
821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
822: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

817: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
818: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
819: END IF;
820: --
821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
822: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
823: --
824: -- Debug Statements
825: --

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

823: --
824: -- Debug Statements
825: --
826: IF l_debug_on THEN
827: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
828: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
829: END IF;
830: --
831: WHEN OTHERS THEN

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

824: -- Debug Statements
825: --
826: IF l_debug_on THEN
827: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
828: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
829: END IF;
830: --
831: WHEN OTHERS THEN
832: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1610: wsh_util_core.add_message(x_return_status, l_module_name);
1611: IF l_debug_on THEN
1612: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_DOMAIN_NAME is set to NULL. Please correct the profile value');
1613: END IF;
1614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1615: --}
1616: END IF;
1617:
1618: IF (l_country_code is null) THEN

Line 1626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1622: wsh_util_core.add_message(x_return_status, l_module_name);
1623: IF l_debug_on THEN
1624: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_CORP_COUNTRY_CODE is set to NULL. Please correct the profile value');
1625: END IF;
1626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1627: --}
1628: END IF;
1629:
1630: -- Extracting the Org Location Information

Line 2179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2175: wsh_util_core.add_message(x_return_status, l_module_name);
2176: IF l_debug_on THEN
2177: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_USER_ID is set to NULL. Please correct the profile value');
2178: END IF;
2179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2180: --}
2181: END IF;
2182:
2183: IF (x_loc_xmission_rec.password is null) THEN

Line 2192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2188: wsh_util_core.add_message(x_return_status, l_module_name);
2189: IF l_debug_on THEN
2190: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_PASSWORD is set to NULL. Please correct the profile value');
2191: END IF;
2192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2193: --}
2194: END IF;
2195: --
2196: l_profile_queried := true;

Line 2767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2763: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_INVALID_ENTITY');
2764: FND_MESSAGE.SET_TOKEN('ENTITY',p_entity_in_rec.entity_type);
2765: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
2766: wsh_util_core.add_message(x_return_status, l_module_name);
2767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2768: --}
2769: END IF;
2770:
2771: -- wms-otm-proj : Added p_entity_type to Distinguish ORG_LOC separately

Line 2831: WHEN FND_API.G_EXC_ERROR THEN

2827: --
2828: --}
2829: EXCEPTION
2830: --{
2831: WHEN FND_API.G_EXC_ERROR THEN
2832: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2833: --
2834: -- Debug Statements
2835: --

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

2843:
2844: x_msg_data := x_msg_data || l_summary || ' ' || l_details;
2845:
2846: IF l_debug_on THEN
2847: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2848: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2849: END IF;
2850: --
2851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2844: x_msg_data := x_msg_data || l_summary || ' ' || l_details;
2845:
2846: IF l_debug_on THEN
2847: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2848: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2849: END IF;
2850: --
2851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2852: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 2851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2847: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2848: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2849: END IF;
2850: --
2851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2852: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2853: --
2854: WSH_UTIL_CORE.Get_Messages
2855: (

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

2864: --
2865: -- Debug Statements
2866: --
2867: IF l_debug_on THEN
2868: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2869: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2870: END IF;
2871: --
2872: WHEN OTHERS THEN

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

2865: -- Debug Statements
2866: --
2867: IF l_debug_on THEN
2868: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2869: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2870: END IF;
2871: --
2872: WHEN OTHERS THEN
2873: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 3184: WHEN FND_API.G_EXC_ERROR THEN

3180: --
3181: --}
3182: EXCEPTION
3183: --{
3184: WHEN FND_API.G_EXC_ERROR THEN
3185: --
3186: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3187: --
3188:

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

3186: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3187: --
3188:
3189: IF l_debug_on THEN
3190: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3191: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3192: END IF;
3193: --
3194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3187: --
3188:
3189: IF l_debug_on THEN
3190: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3191: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3192: END IF;
3193: --
3194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3195: --

Line 3194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3190: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3191: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3192: END IF;
3193: --
3194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3195: --
3196: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3197: --
3198: -- Debug Statements

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

3197: --
3198: -- Debug Statements
3199: --
3200: IF l_debug_on THEN
3201: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3202: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3203: END IF;
3204: --
3205: WHEN OTHERS THEN

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

3198: -- Debug Statements
3199: --
3200: IF l_debug_on THEN
3201: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3202: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3203: END IF;
3204: --
3205: WHEN OTHERS THEN
3206: --