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 170: l_session := fnd_ldap_util.c_get_oid_session(flag);

166: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source || 'Begin'
167: , 'p_userguid = ' || p_userguid);
168: end if;
169:
170: l_session := fnd_ldap_util.c_get_oid_session(flag);
171: p_user_name := fnd_oid_plug.get_username_from_guid(p_userguid);
172: l_orclcommonnicknameattr := upper(fnd_ldap_util.get_orclcommonnicknameattr(p_user_name));
173: -- Query up the user's attributes from OID using user's GUID
174: l_retval := dbms_ldap.search_s(

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

168: end if;
169:
170: l_session := fnd_ldap_util.c_get_oid_session(flag);
171: p_user_name := fnd_oid_plug.get_username_from_guid(p_userguid);
172: l_orclcommonnicknameattr := upper(fnd_ldap_util.get_orclcommonnicknameattr(p_user_name));
173: -- Query up the user's attributes from OID using user's GUID
174: l_retval := dbms_ldap.search_s(
175: ld => l_session
176: , base => ' '

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

225:
226: end loop;
227: end if;
228:
229: fnd_ldap_util.c_unbind(l_session,flag);
230:
231: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
232: then
233: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');

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

1785: end if;
1786:
1787: dbms_ldap.use_exception := TRUE;
1788:
1789: l_host := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_HOST);
1790: l_port := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_PORT);
1791: l_user := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_USERNAME);
1792: 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);
1793: l_ldap_auth := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_DBLDAPAUTHLEVEL);

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

1786:
1787: dbms_ldap.use_exception := TRUE;
1788:
1789: l_host := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_HOST);
1790: l_port := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_PORT);
1791: l_user := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_USERNAME);
1792: 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);
1793: l_ldap_auth := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_DBLDAPAUTHLEVEL);
1794: l_db_wlt_url := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_DBWALLETDIR);

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

1787: dbms_ldap.use_exception := TRUE;
1788:
1789: l_host := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_HOST);
1790: l_port := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_PORT);
1791: l_user := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_USERNAME);
1792: 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);
1793: l_ldap_auth := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_DBLDAPAUTHLEVEL);
1794: l_db_wlt_url := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_DBWALLETDIR);
1795: 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 1792: 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);

1788:
1789: l_host := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_HOST);
1790: l_port := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_PORT);
1791: l_user := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_USERNAME);
1792: 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);
1793: l_ldap_auth := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_DBLDAPAUTHLEVEL);
1794: l_db_wlt_url := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_DBWALLETDIR);
1795: 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);
1796:

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

1789: l_host := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_HOST);
1790: l_port := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_PORT);
1791: l_user := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_USERNAME);
1792: 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);
1793: l_ldap_auth := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_DBLDAPAUTHLEVEL);
1794: l_db_wlt_url := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_DBWALLETDIR);
1795: 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);
1796:
1797: --Fix bug 4233320, raise both exception and alert when preferences are missing

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

1790: l_port := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_PORT);
1791: l_user := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_USERNAME);
1792: 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);
1793: l_ldap_auth := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_DBLDAPAUTHLEVEL);
1794: l_db_wlt_url := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_DBWALLETDIR);
1795: 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);
1796:
1797: --Fix bug 4233320, raise both exception and alert when preferences are missing
1798: validate_OID_preferences (l_host, l_port, l_user, l_pwd);

Line 1795: 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);

1791: l_user := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_USERNAME);
1792: 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);
1793: l_ldap_auth := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_DBLDAPAUTHLEVEL);
1794: l_db_wlt_url := fnd_preference.get(fnd_ldap_util.G_INTERNAL, fnd_ldap_util.G_LDAP_SYNCH, fnd_ldap_util.G_DBWALLETDIR);
1795: 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);
1796:
1797: --Fix bug 4233320, raise both exception and alert when preferences are missing
1798: validate_OID_preferences (l_host, l_port, l_user, l_pwd);
1799:

Line 2077: ldapSession := fnd_ldap_util.get_oid_session;

2073: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
2074: ,'Valid registration');
2075: end if;
2076:
2077: ldapSession := fnd_ldap_util.get_oid_session;
2078: subsNode := 'cn=ACCOUNTS,cn=subscription_data,cn=subscriptions,' || fnd_ldap_util.get_orclappname;
2079: modArray := dbms_ldap.create_mod_array(num => 1);
2080:
2081: modmultivalues(0) := 'orclServiceSubscriptionDetail';

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

2074: ,'Valid registration');
2075: end if;
2076:
2077: ldapSession := fnd_ldap_util.get_oid_session;
2078: subsNode := 'cn=ACCOUNTS,cn=subscription_data,cn=subscriptions,' || fnd_ldap_util.get_orclappname;
2079: modArray := dbms_ldap.create_mod_array(num => 1);
2080:
2081: modmultivalues(0) := 'orclServiceSubscriptionDetail';
2082: dbms_ldap.populate_mod_array(modptr => modArray, mod_op => dbms_ldap.mod_add,

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

2085: retval := dbms_ldap.add_s(ld => ldapSession, entrydn => subsNode, modptr => modArray);
2086:
2087: if (retval = dbms_ldap.SUCCESS)
2088: then
2089: usersDN := fnd_ldap_util.get_dn_for_guid(p_orclguid => p_orclguid);
2090: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
2091: then
2092: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
2093: ,'Adding unique member :: '||usersDN);

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

2097: dbms_ldap.populate_mod_array(modptr => modArray,
2098: mod_op => dbms_ldap.mod_add,
2099: mod_type => 'uniquemember',
2100: modval => modmultivalues);
2101: subsNode := 'cn=ACCOUNTS,cn=subscription_data,cn=subscriptions,' || fnd_ldap_util.get_orclappname;
2102: retval := dbms_ldap.modify_s(ld => ldapSession, entrydn => subsNode, modptr => modArray);
2103: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
2104: then
2105: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source

Line 2111: retval := fnd_ldap_util.G_SUCCESS;

2107: end if;
2108:
2109: if (retval = dbms_ldap.SUCCESS)
2110: then
2111: retval := fnd_ldap_util.G_SUCCESS;
2112: else
2113: retval := fnd_ldap_util.G_FAILURE;
2114: end if;
2115: else

Line 2113: retval := fnd_ldap_util.G_FAILURE;

2109: if (retval = dbms_ldap.SUCCESS)
2110: then
2111: retval := fnd_ldap_util.G_SUCCESS;
2112: else
2113: retval := fnd_ldap_util.G_FAILURE;
2114: end if;
2115: else
2116: retval := fnd_ldap_util.G_FAILURE;
2117: end if;

Line 2116: retval := fnd_ldap_util.G_FAILURE;

2112: else
2113: retval := fnd_ldap_util.G_FAILURE;
2114: end if;
2115: else
2116: retval := fnd_ldap_util.G_FAILURE;
2117: end if;
2118:
2119: dbms_ldap.free_mod_array(modptr => modArray);
2120: result := fnd_ldap_util.unbind(ldapSession);

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

2116: retval := fnd_ldap_util.G_FAILURE;
2117: end if;
2118:
2119: dbms_ldap.free_mod_array(modptr => modArray);
2120: result := fnd_ldap_util.unbind(ldapSession);
2121:
2122: else
2123: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
2124: then

Line 2128: retval := fnd_ldap_util.G_FAILURE;

2124: then
2125: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
2126: ,'No registration or invalid registration');
2127: end if;
2128: retval := fnd_ldap_util.G_FAILURE;
2129: end if;
2130:
2131: x_result := retval;
2132: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 2153: x_result := fnd_ldap_util.G_SUCCESS;

2149: then
2150: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
2151: 'User already subscribed');
2152: end if;
2153: x_result := fnd_ldap_util.G_SUCCESS;
2154: else
2155: raise;
2156: end if;
2157: