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.FND_OID_UTIL dependencies on FND_LDAP_UTIL

Line 171: l_session := fnd_ldap_util.c_get_oid_session(flag);

167: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source || 'Begin'
168: , 'p_userguid = ' || p_userguid);
169: end if;
170:
171: l_session := fnd_ldap_util.c_get_oid_session(flag);
172: l_session_flag := true; /* fix for bug 8271359 */
173: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
174: then
175: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'l_session_flag = true' );

Line 180: -- l_orclcommonnicknameattr := upper(fnd_ldap_util.get_orclcommonnicknameattr(p_user_name));

176: end if;
177:
178: -- 8580552
179: p_user_name := fnd_ldap_user.get_username_from_guid(p_userguid);
180: -- l_orclcommonnicknameattr := upper(fnd_ldap_util.get_orclcommonnicknameattr(p_user_name));
181: -- Query up the user's attributes from OID using user's GUID
182: l_retval := dbms_ldap.search_s(
183: ld => l_session
184: , base => ' '

Line 237: fnd_ldap_util.c_unbind(l_session,flag);

233:
234: end loop;
235: end if;
236:
237: fnd_ldap_util.c_unbind(l_session,flag);
238: l_session_flag := false;
239:
240: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
241: then

Line 263: fnd_ldap_util.c_unbind(l_session,flag);

259: then
260: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, 'LDAP SESSION closing in EXCEPTION BLOCK - START ' );
261: end if;
262:
263: fnd_ldap_util.c_unbind(l_session,flag);
264:
265: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
266: then
267: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, 'LDAP SESSION closed in EXCEPTION BLOCK - END ');

Line 1857: l_host := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_HOST);

1853: end if;
1854:
1855: dbms_ldap.use_exception := TRUE;
1856:
1857: l_host := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_HOST);
1858: l_port := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_PORT);
1859: l_user := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_USERNAME);
1860: l_pwd := fnd_preference.eget(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_EPWD, fnd_ldap_util.G_LDAP_PWD);
1861: l_ldap_auth := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_DBLDAPAUTHLEVEL);

Line 1858: l_port := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_PORT);

1854:
1855: dbms_ldap.use_exception := TRUE;
1856:
1857: l_host := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_HOST);
1858: l_port := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_PORT);
1859: l_user := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_USERNAME);
1860: l_pwd := fnd_preference.eget(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_EPWD, fnd_ldap_util.G_LDAP_PWD);
1861: l_ldap_auth := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_DBLDAPAUTHLEVEL);
1862: l_db_wlt_url := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_DBWALLETDIR);

Line 1859: l_user := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_USERNAME);

1855: dbms_ldap.use_exception := TRUE;
1856:
1857: l_host := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_HOST);
1858: l_port := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_PORT);
1859: l_user := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_USERNAME);
1860: l_pwd := fnd_preference.eget(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_EPWD, fnd_ldap_util.G_LDAP_PWD);
1861: l_ldap_auth := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_DBLDAPAUTHLEVEL);
1862: l_db_wlt_url := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_DBWALLETDIR);
1863: l_db_wlt_pwd := fnd_preference.eget(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_DBWALLETPASS, fnd_ldap_util.G_LDAP_PWD);

Line 1860: l_pwd := fnd_preference.eget(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_EPWD, fnd_ldap_util.G_LDAP_PWD);

1856:
1857: l_host := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_HOST);
1858: l_port := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_PORT);
1859: l_user := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_USERNAME);
1860: l_pwd := fnd_preference.eget(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_EPWD, fnd_ldap_util.G_LDAP_PWD);
1861: l_ldap_auth := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_DBLDAPAUTHLEVEL);
1862: l_db_wlt_url := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_DBWALLETDIR);
1863: l_db_wlt_pwd := fnd_preference.eget(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_DBWALLETPASS, fnd_ldap_util.G_LDAP_PWD);
1864:

Line 1861: l_ldap_auth := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_DBLDAPAUTHLEVEL);

1857: l_host := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_HOST);
1858: l_port := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_PORT);
1859: l_user := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_USERNAME);
1860: l_pwd := fnd_preference.eget(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_EPWD, fnd_ldap_util.G_LDAP_PWD);
1861: l_ldap_auth := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_DBLDAPAUTHLEVEL);
1862: l_db_wlt_url := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_DBWALLETDIR);
1863: l_db_wlt_pwd := fnd_preference.eget(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_DBWALLETPASS, fnd_ldap_util.G_LDAP_PWD);
1864:
1865: --Fix bug 4233320, raise both exception and alert when preferences are missing

Line 1862: l_db_wlt_url := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_DBWALLETDIR);

1858: l_port := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_PORT);
1859: l_user := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_USERNAME);
1860: l_pwd := fnd_preference.eget(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_EPWD, fnd_ldap_util.G_LDAP_PWD);
1861: l_ldap_auth := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_DBLDAPAUTHLEVEL);
1862: l_db_wlt_url := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_DBWALLETDIR);
1863: l_db_wlt_pwd := fnd_preference.eget(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_DBWALLETPASS, fnd_ldap_util.G_LDAP_PWD);
1864:
1865: --Fix bug 4233320, raise both exception and alert when preferences are missing
1866: validate_OID_preferences (l_host, l_port, l_user, l_pwd);

Line 1863: l_db_wlt_pwd := fnd_preference.eget(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_DBWALLETPASS, fnd_ldap_util.G_LDAP_PWD);

1859: l_user := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_USERNAME);
1860: l_pwd := fnd_preference.eget(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_EPWD, fnd_ldap_util.G_LDAP_PWD);
1861: l_ldap_auth := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_DBLDAPAUTHLEVEL);
1862: l_db_wlt_url := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_DBWALLETDIR);
1863: l_db_wlt_pwd := fnd_preference.eget(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_DBWALLETPASS, fnd_ldap_util.G_LDAP_PWD);
1864:
1865: --Fix bug 4233320, raise both exception and alert when preferences are missing
1866: validate_OID_preferences (l_host, l_port, l_user, l_pwd);
1867:

Line 2124: subsNode := 'cn=ACCOUNTS,cn=subscription_data,cn=subscriptions,' || fnd_ldap_util.get_orclappname;

2120:
2121: begin
2122: l_module_source := G_MODULE_SOURCE || 'is_guid_already_subscribed' ;
2123:
2124: subsNode := 'cn=ACCOUNTS,cn=subscription_data,cn=subscriptions,' || fnd_ldap_util.get_orclappname;
2125:
2126: --Search the ldap with orclOwnerGUID attribute filter
2127: l_result := dbms_ldap.search_s(ld => ldapSession, base => subsNode,
2128: scope => dbms_ldap.SCOPE_SUBTREE, filter =>

Line 2144: usersDN := fnd_ldap_util.get_dn_for_guid(p_orclguid => p_orclguid);

2140: end if;
2141: END IF;
2142:
2143: --Search the ldap with uniquemember filter
2144: usersDN := fnd_ldap_util.get_dn_for_guid(p_orclguid => p_orclguid);
2145: l_result := dbms_ldap.search_s(ld => ldapSession, base => subsNode,
2146: scope => dbms_ldap.SCOPE_SUBTREE, filter =>
2147: 'uniquemember=' || usersDN, attrs => l_attrs,attronly => 0,
2148: res => l_message2);

Line 2227: ldapSession := fnd_ldap_util.get_oid_session;

2223: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
2224: ,'Valid registration');
2225: end if;
2226:
2227: ldapSession := fnd_ldap_util.get_oid_session;
2228: --check if the entry exists in ldap for a particular GUID.If NOT then create the entry.
2229: guid_subscribed := is_guid_already_subscribed(p_orclguid, ldapSession);
2230:
2231: if guid_subscribed

Line 2237: x_result := fnd_ldap_util.G_SUCCESS;

2233: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
2234: then
2235: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,'User already subscribed.');
2236: end if;
2237: x_result := fnd_ldap_util.G_SUCCESS;
2238: return;
2239: else
2240: subsNode := 'cn=ACCOUNTS,cn=subscription_data,cn=subscriptions,' || fnd_ldap_util.get_orclappname;
2241:

Line 2240: subsNode := 'cn=ACCOUNTS,cn=subscription_data,cn=subscriptions,' || fnd_ldap_util.get_orclappname;

2236: end if;
2237: x_result := fnd_ldap_util.G_SUCCESS;
2238: return;
2239: else
2240: subsNode := 'cn=ACCOUNTS,cn=subscription_data,cn=subscriptions,' || fnd_ldap_util.get_orclappname;
2241:
2242: modArray := dbms_ldap.create_mod_array(num => 1);
2243:
2244: modmultivalues(0) := 'orclServiceSubscriptionDetail';

Line 2253: usersDN := fnd_ldap_util.get_dn_for_guid(p_orclguid => p_orclguid);

2249: end if;
2250:
2251: if (retval = dbms_ldap.SUCCESS)
2252: then
2253: usersDN := fnd_ldap_util.get_dn_for_guid(p_orclguid => p_orclguid);
2254: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
2255: then
2256: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
2257: ,'Adding unique member :: '||usersDN);

Line 2265: subsNode := 'cn=ACCOUNTS,cn=subscription_data,cn=subscriptions,' || fnd_ldap_util.get_orclappname;

2261: dbms_ldap.populate_mod_array(modptr => modArray,
2262: mod_op => dbms_ldap.mod_add,
2263: mod_type => 'uniquemember',
2264: modval => modmultivalues);
2265: subsNode := 'cn=ACCOUNTS,cn=subscription_data,cn=subscriptions,' || fnd_ldap_util.get_orclappname;
2266: retval := dbms_ldap.modify_s(ld => ldapSession, entrydn => subsNode, modptr => modArray);
2267: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
2268: then
2269: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source

Line 2275: retval := fnd_ldap_util.G_SUCCESS;

2271: end if;
2272:
2273: if (retval = dbms_ldap.SUCCESS)
2274: then
2275: retval := fnd_ldap_util.G_SUCCESS;
2276: else
2277: retval := fnd_ldap_util.G_FAILURE;
2278: end if;
2279: else

Line 2277: retval := fnd_ldap_util.G_FAILURE;

2273: if (retval = dbms_ldap.SUCCESS)
2274: then
2275: retval := fnd_ldap_util.G_SUCCESS;
2276: else
2277: retval := fnd_ldap_util.G_FAILURE;
2278: end if;
2279: else
2280: retval := fnd_ldap_util.G_FAILURE;
2281: end if;

Line 2280: retval := fnd_ldap_util.G_FAILURE;

2276: else
2277: retval := fnd_ldap_util.G_FAILURE;
2278: end if;
2279: else
2280: retval := fnd_ldap_util.G_FAILURE;
2281: end if;
2282:
2283: dbms_ldap.free_mod_array(modptr => modArray);
2284: result := fnd_ldap_util.unbind(ldapSession);

Line 2284: result := fnd_ldap_util.unbind(ldapSession);

2280: retval := fnd_ldap_util.G_FAILURE;
2281: end if;
2282:
2283: dbms_ldap.free_mod_array(modptr => modArray);
2284: result := fnd_ldap_util.unbind(ldapSession);
2285:
2286: else
2287: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
2288: then

Line 2292: retval := fnd_ldap_util.G_FAILURE;

2288: then
2289: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
2290: ,'No registration or invalid registration');
2291: end if;
2292: retval := fnd_ldap_util.G_FAILURE;
2293: end if;
2294:
2295: x_result := retval;
2296: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 2317: x_result := fnd_ldap_util.G_SUCCESS;

2313: then
2314: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
2315: 'User already subscribed');
2316: end if;
2317: x_result := fnd_ldap_util.G_SUCCESS;
2318: else
2319: raise;
2320: end if;
2321: