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

Line 33: l_ext_fwk_agent := FND_PROFILE.value('PON_EXT_APPS_FRAMEWORK_AGENT');

29: BEGIN
30: --
31: -- Access the Sourcing external APPS_FRAMEWORK_AGENT
32: --
33: l_ext_fwk_agent := FND_PROFILE.value('PON_EXT_APPS_FRAMEWORK_AGENT');
34: --
35: -- If the profile is not set, then try the default responsibility approach
36: --
37: IF (l_ext_fwk_agent IS NULL) THEN

Line 39: l_ext_fwk_agent := FND_PROFILE.value('APPS_FRAMEWORK_AGENT');

35: -- If the profile is not set, then try the default responsibility approach
36: --
37: IF (l_ext_fwk_agent IS NULL) THEN
38: --
39: l_ext_fwk_agent := FND_PROFILE.value('APPS_FRAMEWORK_AGENT');
40: END IF;
41: --
42: -- add OA_HTML/OA.jsp to the profile value
43: --

Line 89: l_base_url := FND_PROFILE.value('APPS_FRAMEWORK_AGENT');

85: END IF;
86: END IF;
87:
88: if (l_base_url is null) then
89: l_base_url := FND_PROFILE.value('APPS_FRAMEWORK_AGENT');
90: IF (g_fnd_debug = 'Y') THEN
91: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
92: FND_LOG.string(log_level => FND_LOG.level_statement,
93: module => g_module_prefix || l_api_name,

Line 94: message => 'get_site_level_profile return NULL. After calling FND_PROFILE.value(); l_base_url='

90: IF (g_fnd_debug = 'Y') THEN
91: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
92: FND_LOG.string(log_level => FND_LOG.level_statement,
93: module => g_module_prefix || l_api_name,
94: message => 'get_site_level_profile return NULL. After calling FND_PROFILE.value(); l_base_url='
95: || l_base_url);
96: END IF;
97: END IF;
98:

Line 543: l_ext_fwk_agent := FND_PROFILE.value('PON_EXT_APPS_FRAMEWORK_AGENT');

539:
540: --
541: -- Access the Sourcing external APPS_FRAMEWORK_AGENT
542: --
543: l_ext_fwk_agent := FND_PROFILE.value('PON_EXT_APPS_FRAMEWORK_AGENT');
544: --
545: -- If the profile is not set, then try the default responsibility approach
546: --
547: IF (l_ext_fwk_agent IS NULL) THEN

Line 549: l_ext_fwk_agent := FND_PROFILE.value('APPS_FRAMEWORK_AGENT');

545: -- If the profile is not set, then try the default responsibility approach
546: --
547: IF (l_ext_fwk_agent IS NULL) THEN
548: --
549: l_ext_fwk_agent := FND_PROFILE.value('APPS_FRAMEWORK_AGENT');
550: END IF;
551:
552: IF ( substr(l_ext_fwk_agent, -1, 1) <> '/' ) THEN
553: l_ext_fwk_agent := l_ext_fwk_agent||'/';

Line 998: l_ext_fwk_agent := FND_PROFILE.value('PON_EXT_APPS_FRAMEWORK_AGENT');

994: BEGIN
995: --
996: -- Access the Sourcing external APPS_FRAMEWORK_AGENT
997: --
998: l_ext_fwk_agent := FND_PROFILE.value('PON_EXT_APPS_FRAMEWORK_AGENT');
999: --
1000: -- If the profile is not set, then try the default responsibility approach
1001: --
1002: IF (l_ext_fwk_agent IS NULL) THEN

Line 1004: l_def_ext_user_resp := FND_PROFILE.value('PON_DEFAULT_EXT_USER_RESP');

1000: -- If the profile is not set, then try the default responsibility approach
1001: --
1002: IF (l_ext_fwk_agent IS NULL) THEN
1003: --
1004: l_def_ext_user_resp := FND_PROFILE.value('PON_DEFAULT_EXT_USER_RESP');
1005: --
1006: IF (l_def_ext_user_resp IS NOT NULL) THEN
1007: --
1008: -- get the value of 'APPS_FRAMEWORK_AGENT' profile at this responsibility level

Line 1017: l_ext_fwk_agent := FND_PROFILE.value_specific(

1013: FROM fnd_responsibility
1014: WHERE responsibility_key = l_def_ext_user_resp
1015: AND (end_date IS NULL OR end_date > sysdate);
1016: --
1017: l_ext_fwk_agent := FND_PROFILE.value_specific(
1018: name => 'APPS_FRAMEWORK_AGENT',
1019: responsibility_id => l_responsibility_id,
1020: application_id => l_application_id );
1021: --

Line 1032: l_ext_fwk_agent := FND_PROFILE.value('APPS_FRAMEWORK_AGENT');

1028: --
1029: -- If still NULL, fall back to APPS_FRAMEWORK_AGENT
1030: --
1031: IF (l_ext_fwk_agent IS NULL) THEN
1032: l_ext_fwk_agent := FND_PROFILE.value('APPS_FRAMEWORK_AGENT');
1033: END IF;
1034:
1035: RETURN l_ext_fwk_agent;
1036:

Line 1051: from fnd_profile_options fpo,

1047:
1048: -- this cursor fetches profile option values
1049: cursor profile_value(p_name varchar2, a_id number, l_id number, l_val number) is
1050: select fpov.profile_option_value
1051: from fnd_profile_options fpo,
1052: fnd_profile_option_values fpov
1053: where fpo.profile_option_name = p_name
1054: and fpo.start_date_active <= sysdate
1055: and nvl(fpo.end_date_active, sysdate) >= sysdate

Line 1052: fnd_profile_option_values fpov

1048: -- this cursor fetches profile option values
1049: cursor profile_value(p_name varchar2, a_id number, l_id number, l_val number) is
1050: select fpov.profile_option_value
1051: from fnd_profile_options fpo,
1052: fnd_profile_option_values fpov
1053: where fpo.profile_option_name = p_name
1054: and fpo.start_date_active <= sysdate
1055: and nvl(fpo.end_date_active, sysdate) >= sysdate
1056: and fpo.profile_option_id=fpov.profile_option_id

Line 1105: l_base_url := FND_PROFILE.value('APPS_FRAMEWORK_AGENT');

1101: END IF;
1102: END IF;
1103:
1104: IF (l_base_url is null) then
1105: l_base_url := FND_PROFILE.value('APPS_FRAMEWORK_AGENT');
1106: IF (g_fnd_debug = 'Y') THEN
1107: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1108: FND_LOG.string(log_level => FND_LOG.level_statement,
1109: module => g_module_prefix || l_api_name,

Line 1110: message => 'get_site_level_profile return NULL. After calling FND_PROFILE.value(); l_base_url='

1106: IF (g_fnd_debug = 'Y') THEN
1107: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1108: FND_LOG.string(log_level => FND_LOG.level_statement,
1109: module => g_module_prefix || l_api_name,
1110: message => 'get_site_level_profile return NULL. After calling FND_PROFILE.value(); l_base_url='
1111: || l_base_url);
1112: END IF;
1113: END IF;
1114: