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.OE_PROFILE dependencies on FND_PROFILE

Line 97: FND_PROFILE.GET(l_active_profile,VAL);

93: ELSE
94:
95: l_active_profile := Get_Active_Profile_Name(NAME);
96:
97: FND_PROFILE.GET(l_active_profile,VAL);
98: END IF;
99: END GET;
100:
101:

Line 124: l_profile_value := FND_PROFILE.VALUE(l_active_profile);

120: ELSE
121:
122: l_active_profile := Get_Active_Profile_Name(NAME);
123:
124: l_profile_value := FND_PROFILE.VALUE(l_active_profile);
125:
126: END IF;
127: RETURN(l_profile_value);
128:

Line 153: l_profile_value := FND_PROFILE.VALUE_WNPS(l_active_profile);

149:
150: ELSE
151: l_active_profile := Get_Active_Profile_Name(NAME);
152:
153: l_profile_value := FND_PROFILE.VALUE_WNPS(l_active_profile);
154: END IF;
155:
156: RETURN(l_profile_value);
157:

Line 183: l_org_id := TO_NUMBER(FND_PROFILE.Value_Specific('ORG_ID',

179: -- removing ELSE clause as part of MOAC project as we should not be looking at the ORG_ID profile.
180: -- this can be taken out NOCOPY /* file.sql.39 change */ completely as no caller is populating the user/app/resp when calling this procedure
181: /*
182: ELSE
183: l_org_id := TO_NUMBER(FND_PROFILE.Value_Specific('ORG_ID',
184: USER_ID, RESPONSIBILITY_ID, APPLICATION_ID));
185: l_profile_value := OE_Sys_Parameters.VALUE(
186: param_name => 'MASTER_ORGANIZATION_ID',
187: p_org_id => l_org_id);

Line 199: l_org_id := TO_NUMBER(FND_PROFILE.Value_Specific('ORG_ID',

195: -- removing ELSE clause as part of MOAC project as we should not be looking at the ORG_ID profile.
196: -- this can be taken out NOCOPY /* file.sql.39 change */ completely as no caller is populating the user/app/resp when calling this procedure
197: /*
198: ELSE
199: l_org_id := TO_NUMBER(FND_PROFILE.Value_Specific('ORG_ID',
200: USER_ID, RESPONSIBILITY_ID, APPLICATION_ID));
201: l_profile_value := OE_Sys_Parameters.VALUE(
202: param_name => 'SET_OF_BOOKS_ID',
203: p_org_id => l_org_id);

Line 212: l_profile_value := FND_PROFILE.VALUE_SPECIFIC(l_active_profile

208:
209:
210: l_active_profile := Get_Active_Profile_Name(NAME);
211:
212: l_profile_value := FND_PROFILE.VALUE_SPECIFIC(l_active_profile
213: , USER_ID
214: , RESPONSIBILITY_ID
215: , APPLICATION_ID);
216: END IF;

Line 394: -- call FND_PROFILE.Value_Specific to retrieve context-based profile option value

390: END IF;
391:
392: IF l_get_cache_profile_result <> 'S' THEN
393: -- profile option value was not found in cache.
394: -- call FND_PROFILE.Value_Specific to retrieve context-based profile option value
395: IF l_debug_level > 0 THEN
396: oe_debug_pub.add('profile value was not found in the cache...calling FND_PROFILE.value_specific');
397: END IF;
398: l_profile_option_value := FND_PROFILE.Value_Specific(p_profile_option_name, l_cached_user_id,

Line 396: oe_debug_pub.add('profile value was not found in the cache...calling FND_PROFILE.value_specific');

392: IF l_get_cache_profile_result <> 'S' THEN
393: -- profile option value was not found in cache.
394: -- call FND_PROFILE.Value_Specific to retrieve context-based profile option value
395: IF l_debug_level > 0 THEN
396: oe_debug_pub.add('profile value was not found in the cache...calling FND_PROFILE.value_specific');
397: END IF;
398: l_profile_option_value := FND_PROFILE.Value_Specific(p_profile_option_name, l_cached_user_id,
399: l_cached_resp_id, l_cached_resp_appl_id,
400: l_cached_org_id);

Line 398: l_profile_option_value := FND_PROFILE.Value_Specific(p_profile_option_name, l_cached_user_id,

394: -- call FND_PROFILE.Value_Specific to retrieve context-based profile option value
395: IF l_debug_level > 0 THEN
396: oe_debug_pub.add('profile value was not found in the cache...calling FND_PROFILE.value_specific');
397: END IF;
398: l_profile_option_value := FND_PROFILE.Value_Specific(p_profile_option_name, l_cached_user_id,
399: l_cached_resp_id, l_cached_resp_appl_id,
400: l_cached_org_id);
401:
402: IF l_debug_level > 0 THEN

Line 407: --make original call to FND_PROFILE.Value

403: oe_debug_pub.add('profile option value from value_specific: ' || l_profile_option_value);
404: END IF;
405:
406: IF l_profile_option_value IS NULL THEN
407: --make original call to FND_PROFILE.Value
408: IF l_debug_level > 0 THEN
409: oe_debug_pub.add('got NULL...calling FND_PROFILE.value');
410: END IF;
411: l_profile_option_value := FND_PROFILE.Value(p_profile_option_name);

Line 409: oe_debug_pub.add('got NULL...calling FND_PROFILE.value');

405:
406: IF l_profile_option_value IS NULL THEN
407: --make original call to FND_PROFILE.Value
408: IF l_debug_level > 0 THEN
409: oe_debug_pub.add('got NULL...calling FND_PROFILE.value');
410: END IF;
411: l_profile_option_value := FND_PROFILE.Value(p_profile_option_name);
412:
413: IF l_debug_level > 0 THEN

Line 411: l_profile_option_value := FND_PROFILE.Value(p_profile_option_name);

407: --make original call to FND_PROFILE.Value
408: IF l_debug_level > 0 THEN
409: oe_debug_pub.add('got NULL...calling FND_PROFILE.value');
410: END IF;
411: l_profile_option_value := FND_PROFILE.Value(p_profile_option_name);
412:
413: IF l_debug_level > 0 THEN
414: oe_debug_pub.add('profile option value from value: ' || l_profile_option_value);
415: END IF;

Line 418: -- FND_PROFILE.Value_Specfic returned a value, so cache it for later use

414: oe_debug_pub.add('profile option value from value: ' || l_profile_option_value);
415: END IF;
416:
417: ELSE
418: -- FND_PROFILE.Value_Specfic returned a value, so cache it for later use
419: IF l_debug_level > 0 THEN
420: oe_debug_pub.add('before caching the retrieved profile option value');
421: END IF;
422: PUT_CACHED_PROFILE_FOR_CONTEXT( p_profile_option_name => p_profile_option_name,

Line 437: -- no id was passed so call should use session context so use FND_PROFILE.value

433: --end of l_profile_option_value IS NULL
434: END IF;
435: -- end of l_get_cache_profile_result <> 'S'
436: ELSE
437: -- no id was passed so call should use session context so use FND_PROFILE.value
438: IF l_debug_level > 0 THEN
439: oe_debug_pub.add('no id was passed, calling FND_PROFILE.value');
440: END IF;
441: l_profile_option_value := FND_PROFILE.Value(p_profile_option_name);

Line 439: oe_debug_pub.add('no id was passed, calling FND_PROFILE.value');

435: -- end of l_get_cache_profile_result <> 'S'
436: ELSE
437: -- no id was passed so call should use session context so use FND_PROFILE.value
438: IF l_debug_level > 0 THEN
439: oe_debug_pub.add('no id was passed, calling FND_PROFILE.value');
440: END IF;
441: l_profile_option_value := FND_PROFILE.Value(p_profile_option_name);
442: IF l_debug_level > 0 THEN
443: oe_debug_pub.add('profile option value from value: ' || l_profile_option_value);

Line 441: l_profile_option_value := FND_PROFILE.Value(p_profile_option_name);

437: -- no id was passed so call should use session context so use FND_PROFILE.value
438: IF l_debug_level > 0 THEN
439: oe_debug_pub.add('no id was passed, calling FND_PROFILE.value');
440: END IF;
441: l_profile_option_value := FND_PROFILE.Value(p_profile_option_name);
442: IF l_debug_level > 0 THEN
443: oe_debug_pub.add('profile option value from value: ' || l_profile_option_value);
444: END IF;
445: END IF;

Line 448: --neither flag was set so call should use session context so use FND_PROFILE.value

444: END IF;
445: END IF;
446: -- end of l_id_passed = 'Y'
447: ELSE
448: --neither flag was set so call should use session context so use FND_PROFILE.value
449: IF l_debug_level > 0 THEN
450: oe_debug_pub.add('neither global was set, calling FND_PROFILE.value');
451: END IF;
452: l_profile_option_value := FND_PROFILE.Value(p_profile_option_name);

Line 450: oe_debug_pub.add('neither global was set, calling FND_PROFILE.value');

446: -- end of l_id_passed = 'Y'
447: ELSE
448: --neither flag was set so call should use session context so use FND_PROFILE.value
449: IF l_debug_level > 0 THEN
450: oe_debug_pub.add('neither global was set, calling FND_PROFILE.value');
451: END IF;
452: l_profile_option_value := FND_PROFILE.Value(p_profile_option_name);
453: IF l_debug_level > 0 THEN
454: oe_debug_pub.add('profile option value from value: ' || l_profile_option_value);

Line 452: l_profile_option_value := FND_PROFILE.Value(p_profile_option_name);

448: --neither flag was set so call should use session context so use FND_PROFILE.value
449: IF l_debug_level > 0 THEN
450: oe_debug_pub.add('neither global was set, calling FND_PROFILE.value');
451: END IF;
452: l_profile_option_value := FND_PROFILE.Value(p_profile_option_name);
453: IF l_debug_level > 0 THEN
454: oe_debug_pub.add('profile option value from value: ' || l_profile_option_value);
455: END IF;
456: END IF;