450:
451: IF (p_debug_mode = 'Y') THEN
452: g_debug_mode := TRUE;
453: ELSE
454: IF (fnd_profile.value('GL_DEBUG_MODE') = 'Y') THEN
455: g_debug_mode := TRUE;
456: ELSE
457: g_debug_mode := FALSE;
458: END IF;
2074: ---
2075: --- Get the fusion user to be used
2076: ---
2077: BEGIN
2078: g_fusion_user := substrb(fnd_profile.value('GL_AU_FUSION_USER'), 1, 240);
2079: EXCEPTION
2080: WHEN OTHERS THEN
2081: g_fusion_user := NULL;
2082: END;
2085:
2086: BEGIN
2087: SELECT user_profile_option_name
2088: INTO l_profile_name
2089: FROM fnd_profile_options_tl
2090: WHERE profile_option_name = 'GL_AU_FUSION_USER'
2091: AND language = userenv('LANG');
2092: EXCEPTION
2093: WHEN OTHERS THEN
2117: PROCEDURE get_system_id IS
2118: BEGIN
2119:
2120: BEGIN
2121: g_system_id := fnd_profile.value('GL_AU_SYSTEM_ID');
2122:
2123: EXCEPTION
2124: WHEN OTHERS THEN
2125: g_system_id := NULL;