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_PROFILE

Line 1090: --fnd_profile.put('WSH_DEBUG_MODE','T');

1086: --
1087: BEGIN
1088: IF p_log_level > 0
1089: THEN
1090: --fnd_profile.put('WSH_DEBUG_MODE','T');
1091: fnd_profile.put('WSH_DEBUG_MODULE','%');
1092: fnd_profile.put('WSH_DEBUG_LEVEL',WSH_DEBUG_SV.C_STMT_LEVEL);
1093: wsh_debug_sv.start_debugger(l_file_name,l_return_status,l_msg_count,l_msg_data);
1094: --wsh_debug_sv.start_debugger(l_file_name,l_return_status,l_msg_data,l_msg_count);

Line 1091: fnd_profile.put('WSH_DEBUG_MODULE','%');

1087: BEGIN
1088: IF p_log_level > 0
1089: THEN
1090: --fnd_profile.put('WSH_DEBUG_MODE','T');
1091: fnd_profile.put('WSH_DEBUG_MODULE','%');
1092: fnd_profile.put('WSH_DEBUG_LEVEL',WSH_DEBUG_SV.C_STMT_LEVEL);
1093: wsh_debug_sv.start_debugger(l_file_name,l_return_status,l_msg_count,l_msg_data);
1094: --wsh_debug_sv.start_debugger(l_file_name,l_return_status,l_msg_data,l_msg_count);
1095: -- Ignore errors;

Line 1092: fnd_profile.put('WSH_DEBUG_LEVEL',WSH_DEBUG_SV.C_STMT_LEVEL);

1088: IF p_log_level > 0
1089: THEN
1090: --fnd_profile.put('WSH_DEBUG_MODE','T');
1091: fnd_profile.put('WSH_DEBUG_MODULE','%');
1092: fnd_profile.put('WSH_DEBUG_LEVEL',WSH_DEBUG_SV.C_STMT_LEVEL);
1093: wsh_debug_sv.start_debugger(l_file_name,l_return_status,l_msg_count,l_msg_data);
1094: --wsh_debug_sv.start_debugger(l_file_name,l_return_status,l_msg_data,l_msg_count);
1095: -- Ignore errors;
1096: ELSE

Line 1097: --fnd_profile.put('WSH_DEBUG_MODE','F');

1093: wsh_debug_sv.start_debugger(l_file_name,l_return_status,l_msg_count,l_msg_data);
1094: --wsh_debug_sv.start_debugger(l_file_name,l_return_status,l_msg_data,l_msg_count);
1095: -- Ignore errors;
1096: ELSE
1097: --fnd_profile.put('WSH_DEBUG_MODE','F');
1098: wsh_debug_sv.stop_debugger;
1099: END IF;
1100: EXCEPTION
1101: WHEN OTHERS THEN

Line 3623: IF (fnd_profile.value('WSH_FTE_INSTALLATION_STATUS') = 'N') THEN

3619: IF (l_fte_install_status = 'I') THEN
3620: G_FTE_IS_INSTALLED := 'Y';
3621:
3622: -- User customization starts (FP bug 4688529--bug 4602901)
3623: IF (fnd_profile.value('WSH_FTE_INSTALLATION_STATUS') = 'N') THEN
3624: G_FTE_IS_INSTALLED := 'N';
3625: END IF;
3626: -- User customization ends
3627: ELSE

Line 3700: IF fnd_profile.value('WSH_TP_INSTALLATION_STATUS') IN ('Y','N') THEN

3696: G_TP_IS_INSTALLED := 'N';
3697: END IF;
3698:
3699: --User customization starts
3700: IF fnd_profile.value('WSH_TP_INSTALLATION_STATUS') IN ('Y','N') THEN
3701: G_TP_IS_INSTALLED := fnd_profile.value('WSH_TP_INSTALLATION_STATUS');
3702: END IF;
3703: -- User customization ends
3704: ELSE

Line 3701: G_TP_IS_INSTALLED := fnd_profile.value('WSH_TP_INSTALLATION_STATUS');

3697: END IF;
3698:
3699: --User customization starts
3700: IF fnd_profile.value('WSH_TP_INSTALLATION_STATUS') IN ('Y','N') THEN
3701: G_TP_IS_INSTALLED := fnd_profile.value('WSH_TP_INSTALLATION_STATUS');
3702: END IF;
3703: -- User customization ends
3704: ELSE
3705: /* this happens only when invalid application id is passed */

Line 7886: G_OTM_PROFILE_VALUE := NVL(fnd_profile.value('WSH_OTM_INSTALLED'), 'N');

7882: --
7883:
7884: IF G_OTM_PROFILE_VALUE IS NULL THEN
7885: -- profile value can be 'Y','N','O','P' or NULL
7886: G_OTM_PROFILE_VALUE := NVL(fnd_profile.value('WSH_OTM_INSTALLED'), 'N');
7887: END IF;
7888:
7889: IF l_debug_on THEN
7890: WSH_DEBUG_SV.log(l_module_name,'G_OTM_PROFILE_VALUE',G_OTM_PROFILE_VALUE);

Line 7935: G_OTM_PROFILE_VALUE := NVL(fnd_profile.value('WSH_OTM_INSTALLED'), 'N');

7931:
7932: IF G_GC3_IS_INSTALLED IS NULL THEN
7933: -- G_OTM_PROFILE_VALUE might be set in Get_Otm_Install_Profile_Value
7934: IF G_OTM_PROFILE_VALUE IS NULL THEN
7935: G_OTM_PROFILE_VALUE := NVL(fnd_profile.value('WSH_OTM_INSTALLED'), 'N');
7936: END IF;
7937:
7938: IF G_OTM_PROFILE_VALUE in ('Y','O') THEN
7939: G_GC3_IS_INSTALLED := 'Y';

Line 7967: -- fnd_profile.value api is called to get the profile value

7963: --
7964: -- PURPOSE : To get the value for profile option WSH_OTM_CURR_CONV_TYPE
7965: -- (WSH: Currency Conversion Type for OTM)
7966: -- It returns the cached value if it is avaiable, otherwise
7967: -- fnd_profile.value api is called to get the profile value
7968: -- PARAMETERS:
7969: -- x_curr_conv_type currency conversion type
7970: -- x_return_status return status
7971: --========================================================================

Line 7997: -- no cached value, call fnd_profile.value

7993:
7994: x_curr_conv_type := NULL;
7995: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
7996:
7997: -- no cached value, call fnd_profile.value
7998: IF G_CURRENCY_CONVERSION_TYPE IS NULL then
7999: IF l_debug_on THEN
8000: WSH_DEBUG_SV.logmsg(l_module_name, 'calling fnd_profile.value');
8001: END IF;

Line 8000: WSH_DEBUG_SV.logmsg(l_module_name, 'calling fnd_profile.value');

7996:
7997: -- no cached value, call fnd_profile.value
7998: IF G_CURRENCY_CONVERSION_TYPE IS NULL then
7999: IF l_debug_on THEN
8000: WSH_DEBUG_SV.logmsg(l_module_name, 'calling fnd_profile.value');
8001: END IF;
8002: G_CURRENCY_CONVERSION_TYPE := fnd_profile.value
8003: (name => 'WSH_OTM_CURR_CONV_TYPE');
8004: -- no value is defined for the profile option

Line 8002: G_CURRENCY_CONVERSION_TYPE := fnd_profile.value

7998: IF G_CURRENCY_CONVERSION_TYPE IS NULL then
7999: IF l_debug_on THEN
8000: WSH_DEBUG_SV.logmsg(l_module_name, 'calling fnd_profile.value');
8001: END IF;
8002: G_CURRENCY_CONVERSION_TYPE := fnd_profile.value
8003: (name => 'WSH_OTM_CURR_CONV_TYPE');
8004: -- no value is defined for the profile option
8005: IF G_CURRENCY_CONVERSION_TYPE IS NULL then
8006: Raise CURR_CONV_TYPE_UNDEFINED_EXP;

Line 8492: -- PROCEDURE : SET_FND_PROFILE

8488: -- Standalone Project - End
8489:
8490: --Added for bug 9011125
8491: --========================================================================
8492: -- PROCEDURE : SET_FND_PROFILE
8493: --
8494: -- COMMENT : This will set the FND_PROFILE for the DB cache.
8495: -- PARAMATERS: p_name - Name of the profile to be set.
8496: -- p_value - Value for the profile to be set.

Line 8494: -- COMMENT : This will set the FND_PROFILE for the DB cache.

8490: --Added for bug 9011125
8491: --========================================================================
8492: -- PROCEDURE : SET_FND_PROFILE
8493: --
8494: -- COMMENT : This will set the FND_PROFILE for the DB cache.
8495: -- PARAMATERS: p_name - Name of the profile to be set.
8496: -- p_value - Value for the profile to be set.
8497: -- MODIFIED :
8498: -- DESC : This will set the FND_PROFILE for the DB cache.This API will only be called from

Line 8498: -- DESC : This will set the FND_PROFILE for the DB cache.This API will only be called from

8494: -- COMMENT : This will set the FND_PROFILE for the DB cache.
8495: -- PARAMATERS: p_name - Name of the profile to be set.
8496: -- p_value - Value for the profile to be set.
8497: -- MODIFIED :
8498: -- DESC : This will set the FND_PROFILE for the DB cache.This API will only be called from
8499: -- Oracle Forms.From plsql we can call the FND API FND_PROFILE.PUT directly to set
8500: -- the same profile.
8501: --========================================================================
8502:

Line 8499: -- Oracle Forms.From plsql we can call the FND API FND_PROFILE.PUT directly to set

8495: -- PARAMATERS: p_name - Name of the profile to be set.
8496: -- p_value - Value for the profile to be set.
8497: -- MODIFIED :
8498: -- DESC : This will set the FND_PROFILE for the DB cache.This API will only be called from
8499: -- Oracle Forms.From plsql we can call the FND API FND_PROFILE.PUT directly to set
8500: -- the same profile.
8501: --========================================================================
8502:
8503: PROCEDURE SET_FND_PROFILE(

Line 8503: PROCEDURE SET_FND_PROFILE(

8499: -- Oracle Forms.From plsql we can call the FND API FND_PROFILE.PUT directly to set
8500: -- the same profile.
8501: --========================================================================
8502:
8503: PROCEDURE SET_FND_PROFILE(
8504: p_name IN VARCHAR2,
8505: p_value IN VARCHAR2)
8506: IS
8507: --

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

8505: p_value IN VARCHAR2)
8506: IS
8507: --
8508: l_debug_on BOOLEAN;
8509: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'SET_FND_PROFILE';
8510: --
8511: BEGIN
8512: --
8513: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

Line 8526: FND_PROFILE.PUT(NAME=>p_name,

8522: WSH_DEBUG_SV.log(l_module_name,'P_NAME',p_name);
8523: WSH_DEBUG_SV.log(l_module_name,'P_VALUE',p_value);
8524: END IF;
8525: --
8526: FND_PROFILE.PUT(NAME=>p_name,
8527: VAL =>p_value);
8528: --
8529: IF l_debug_on THEN
8530: WSH_DEBUG_SV.pop(l_module_name);

Line 8545: END SET_FND_PROFILE;

8541: --
8542: END IF;
8543: --
8544: RAISE;
8545: END SET_FND_PROFILE;
8546:
8547: --muom
8548: --***************************************************************************--
8549: --