DBA Data[Home] [Help]

APPS.WSH_DCP_PVT dependencies on FND_PROFILE

Line 40: wsh_dcp_pvt.g_email_server := fnd_profile.value('WSH_DCP_EMAIL_SERVER');

36:
37: RETURN wsh_dcp_pvt.g_email_server;
38: END IF;
39:
40: wsh_dcp_pvt.g_email_server := fnd_profile.value('WSH_DCP_EMAIL_SERVER');
41:
42: IF l_debug_on THEN
43: WSH_DEBUG_SV.LOG(l_module_name, 'server name profile', wsh_dcp_pvt.g_email_server);
44: wsh_debug_sv.pop(l_module_name);

Line 83: wsh_dcp_pvt.g_email_address := fnd_profile.value('WSH_DCP_EMAIL_ADDRESSES');

79: END IF;
80: RETURN wsh_dcp_pvt.g_email_address;
81: END IF;
82:
83: wsh_dcp_pvt.g_email_address := fnd_profile.value('WSH_DCP_EMAIL_ADDRESSES');
84:
85: IF l_debug_on THEN
86: WSH_DEBUG_SV.LOG(l_module_name, 'Email Address profile', wsh_dcp_pvt.g_email_address);
87: wsh_debug_sv.pop(l_module_name);

Line 266: wsh_dcp_pvt.g_check_dcp := nvl(fnd_profile.value('WSH_ENABLE_DCP'), 0);

262: THEN
263: RETURN(wsh_dcp_pvt.g_check_dcp);
264: END IF;
265: --
266: wsh_dcp_pvt.g_check_dcp := nvl(fnd_profile.value('WSH_ENABLE_DCP'), 0);
267: --
268: RETURN wsh_dcp_pvt.g_check_dcp;
269:
270: EXCEPTION

Line 332: fnd_profile.get('USER_ID',g_userid);

328: END IF;
329:
330: -- NO NEED TO CHECK USER EMAIL. USING HARDCODED EMAIL IDS
331: IF g_userid IS NULL THEN
332: fnd_profile.get('USER_ID',g_userid);
333: OPEN c_user_info(g_userid);
334: FETCH c_user_info INTO g_user_name, g_user_email;
335: CLOSE c_user_info;
336: END IF;

Line 377: fnd_profile.get('WSH_DEBUG_MODULE',l_module);

373:
374: IF g_dc_table.count > 0
375: AND l_rollback_allowed = 'Y' THEN
376: --{
377: fnd_profile.get('WSH_DEBUG_MODULE',l_module);
378: --
379: fnd_profile.get('WSH_DEBUG_LEVEL', l_level);
380: --
381: fnd_profile.get('WSH_DEBUG_LOG_DIRECTORY',l_dir);

Line 379: fnd_profile.get('WSH_DEBUG_LEVEL', l_level);

375: AND l_rollback_allowed = 'Y' THEN
376: --{
377: fnd_profile.get('WSH_DEBUG_MODULE',l_module);
378: --
379: fnd_profile.get('WSH_DEBUG_LEVEL', l_level);
380: --
381: fnd_profile.get('WSH_DEBUG_LOG_DIRECTORY',l_dir);
382:
383:

Line 381: fnd_profile.get('WSH_DEBUG_LOG_DIRECTORY',l_dir);

377: fnd_profile.get('WSH_DEBUG_MODULE',l_module);
378: --
379: fnd_profile.get('WSH_DEBUG_LEVEL', l_level);
380: --
381: fnd_profile.get('WSH_DEBUG_LOG_DIRECTORY',l_dir);
382:
383:
384: -- Check Debug directory is a valid location
385: -- Check Debug level is set to maximum i.e statement level

Line 399: fnd_profile.put('WSH_DEBUG_LOG_DIRECTORY', l_debug_dir);

395: THEN
396: --Debug directory is not a utl file location. Set debug directory.
397: l_comma_pos := INSTRB(l_utl_file_locns, ',');
398: l_debug_dir := SUBSTRB(l_utl_file_locns, 1, l_comma_pos-1);
399: fnd_profile.put('WSH_DEBUG_LOG_DIRECTORY', l_debug_dir);
400: IF l_debug_on THEN
401: l_debug_reset := 'Y';
402: END IF;
403: l_debug_on := FALSE;

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

409:
410: IF nvl(l_level, 9999) > WSH_DEBUG_SV.C_STMT_LEVEL THEN
411: --Debug level is either not set or is set to a higher level
412: --Need to set to statement level.
413: fnd_profile.put('WSH_DEBUG_LEVEL', WSH_DEBUG_SV.C_STMT_LEVEL);
414: IF l_debug_on THEN
415: l_debug_reset := 'Y';
416: END IF;
417: l_debug_on := FALSE;