DBA Data[Home] [Help]

APPS.FND_CLIENT_INFO dependencies on FND_PROFILE

Line 60: /* Bug 5646892: APPSPERFR12:FND:EXTRA FND_PROFILE.GET_SPECIFIC CALL IN

56: l_security_profile_id NUMBER;
57: l_morg_profile_name varchar2(240);
58: begin
59:
60: /* Bug 5646892: APPSPERFR12:FND:EXTRA FND_PROFILE.GET_SPECIFIC CALL IN
61: FND_CLIENT_INFO.SETUP_CLIENT_INFO
62: FND_GLOBAL will now pass in the org_id context, i.e. FND_GLOBAL.org_id.
63: There is no need for setup_client_info to get the ORG_ID value again.
64: */

Line 70: -- fnd_global is passing it in. When fnd_global calls fnd_profile to get the

66: --
67: -- Set MultiOrg Context
68: --
69: -- Check if org_id is NULL or -1. It is likely that org_id = -1, not NULL since
70: -- fnd_global is passing it in. When fnd_global calls fnd_profile to get the
71: -- org_id value and the value returned is NULL, fnd_global does not set org_id
72: -- to NULL. It just leaves the default value of -1. So, org_id = -1 means there
73: -- was no value returned by fnd_profile. A benefit of calling fnd_profile in
74: -- setup_client_info was that it did not check the value, but rather whether a

Line 73: -- was no value returned by fnd_profile. A benefit of calling fnd_profile in

69: -- Check if org_id is NULL or -1. It is likely that org_id = -1, not NULL since
70: -- fnd_global is passing it in. When fnd_global calls fnd_profile to get the
71: -- org_id value and the value returned is NULL, fnd_global does not set org_id
72: -- to NULL. It just leaves the default value of -1. So, org_id = -1 means there
73: -- was no value returned by fnd_profile. A benefit of calling fnd_profile in
74: -- setup_client_info was that it did not check the value, but rather whether a
75: -- value was defined.
76: if (org_id is NULL) or (org_id = -1) then
77: -- If not R12, then check if the instance is multiorg-enabled.

Line 86: /* Bug 6637377: This fnd_profile.get_specific call is a LAST CHECK to

82: from fnd_product_groups;
83: -- If multiorg-enabled, raise an error since org_id should not be NULL.
84: -- FND_GLOBAL.org_id should not be NULL if instance is multiorg-enabled.
85: if is_multi_org = 'Y' then
86: /* Bug 6637377: This fnd_profile.get_specific call is a LAST CHECK to
87: make sure that org_id is, indeed, not set. Need to make sure before
88: the error is raised. This should not undo the fix for 5646892
89: completely and is needed.
90: */

Line 91: fnd_profile.get_specific('ORG_ID', user_id, responsibility_id,

87: make sure that org_id is, indeed, not set. Need to make sure before
88: the error is raised. This should not undo the fix for 5646892
89: completely and is needed.
90: */
91: fnd_profile.get_specific('ORG_ID', user_id, responsibility_id,
92: application_id, org_id_char, org_id_defined);
93:
94: -- If org_id is really not defined, then raise the exception, as
95: -- planned.

Line 100: from fnd_profile_options_vl

96: if (not org_id_defined) then
97:
98: select user_profile_option_name
99: into l_morg_profile_name
100: from fnd_profile_options_vl
101: where profile_option_name = 'ORG_ID';
102:
103: raise no_morg_profile_value;
104: end if;

Line 128: fnd_profile.get_specific('MRC_REPORTING_SOB_ID',

124: if is_multi_currency = 'Y' then
125: --
126: -- Get MRC_REPORTING_SOB_ID profile option value
127: --
128: fnd_profile.get_specific('MRC_REPORTING_SOB_ID',
129: user_id, responsibility_id, application_id,
130: reporting_sob_id_char, reporting_sob_id_defined);
131: --
132: -- If MRC_REPORTING_SOB_ID profile option defined for this responsibility,