51: end if;
52:
53: dbms_ldap.use_exception := TRUE;
54:
55: l_host := fnd_preference.get(G_INTERNAL, G_LDAP_SYNCH, G_HOST);
56: l_port := fnd_preference.get(G_INTERNAL, G_LDAP_SYNCH, G_PORT);
57: l_user := fnd_preference.get(G_INTERNAL, G_LDAP_SYNCH, G_USERNAME);
58: l_pwd := fnd_preference.eget(G_INTERNAL, G_LDAP_SYNCH, G_EPWD, G_LDAP_PWD);
59: l_ldap_auth := fnd_preference.get(G_INTERNAL, G_LDAP_SYNCH, G_DBLDAPAUTHLEVEL);
52:
53: dbms_ldap.use_exception := TRUE;
54:
55: l_host := fnd_preference.get(G_INTERNAL, G_LDAP_SYNCH, G_HOST);
56: l_port := fnd_preference.get(G_INTERNAL, G_LDAP_SYNCH, G_PORT);
57: l_user := fnd_preference.get(G_INTERNAL, G_LDAP_SYNCH, G_USERNAME);
58: l_pwd := fnd_preference.eget(G_INTERNAL, G_LDAP_SYNCH, G_EPWD, G_LDAP_PWD);
59: l_ldap_auth := fnd_preference.get(G_INTERNAL, G_LDAP_SYNCH, G_DBLDAPAUTHLEVEL);
60: l_db_wlt_url := fnd_preference.get(G_INTERNAL, G_LDAP_SYNCH, G_DBWALLETDIR);
53: dbms_ldap.use_exception := TRUE;
54:
55: l_host := fnd_preference.get(G_INTERNAL, G_LDAP_SYNCH, G_HOST);
56: l_port := fnd_preference.get(G_INTERNAL, G_LDAP_SYNCH, G_PORT);
57: l_user := fnd_preference.get(G_INTERNAL, G_LDAP_SYNCH, G_USERNAME);
58: l_pwd := fnd_preference.eget(G_INTERNAL, G_LDAP_SYNCH, G_EPWD, G_LDAP_PWD);
59: l_ldap_auth := fnd_preference.get(G_INTERNAL, G_LDAP_SYNCH, G_DBLDAPAUTHLEVEL);
60: l_db_wlt_url := fnd_preference.get(G_INTERNAL, G_LDAP_SYNCH, G_DBWALLETDIR);
61: l_db_wlt_pwd := fnd_preference.eget(G_INTERNAL, G_LDAP_SYNCH, G_DBWALLETPASS, G_LDAP_PWD);
54:
55: l_host := fnd_preference.get(G_INTERNAL, G_LDAP_SYNCH, G_HOST);
56: l_port := fnd_preference.get(G_INTERNAL, G_LDAP_SYNCH, G_PORT);
57: l_user := fnd_preference.get(G_INTERNAL, G_LDAP_SYNCH, G_USERNAME);
58: l_pwd := fnd_preference.eget(G_INTERNAL, G_LDAP_SYNCH, G_EPWD, G_LDAP_PWD);
59: l_ldap_auth := fnd_preference.get(G_INTERNAL, G_LDAP_SYNCH, G_DBLDAPAUTHLEVEL);
60: l_db_wlt_url := fnd_preference.get(G_INTERNAL, G_LDAP_SYNCH, G_DBWALLETDIR);
61: l_db_wlt_pwd := fnd_preference.eget(G_INTERNAL, G_LDAP_SYNCH, G_DBWALLETPASS, G_LDAP_PWD);
62:
55: l_host := fnd_preference.get(G_INTERNAL, G_LDAP_SYNCH, G_HOST);
56: l_port := fnd_preference.get(G_INTERNAL, G_LDAP_SYNCH, G_PORT);
57: l_user := fnd_preference.get(G_INTERNAL, G_LDAP_SYNCH, G_USERNAME);
58: l_pwd := fnd_preference.eget(G_INTERNAL, G_LDAP_SYNCH, G_EPWD, G_LDAP_PWD);
59: l_ldap_auth := fnd_preference.get(G_INTERNAL, G_LDAP_SYNCH, G_DBLDAPAUTHLEVEL);
60: l_db_wlt_url := fnd_preference.get(G_INTERNAL, G_LDAP_SYNCH, G_DBWALLETDIR);
61: l_db_wlt_pwd := fnd_preference.eget(G_INTERNAL, G_LDAP_SYNCH, G_DBWALLETPASS, G_LDAP_PWD);
62:
63: l_session := DBMS_LDAP.init(l_host, l_port);
56: l_port := fnd_preference.get(G_INTERNAL, G_LDAP_SYNCH, G_PORT);
57: l_user := fnd_preference.get(G_INTERNAL, G_LDAP_SYNCH, G_USERNAME);
58: l_pwd := fnd_preference.eget(G_INTERNAL, G_LDAP_SYNCH, G_EPWD, G_LDAP_PWD);
59: l_ldap_auth := fnd_preference.get(G_INTERNAL, G_LDAP_SYNCH, G_DBLDAPAUTHLEVEL);
60: l_db_wlt_url := fnd_preference.get(G_INTERNAL, G_LDAP_SYNCH, G_DBWALLETDIR);
61: l_db_wlt_pwd := fnd_preference.eget(G_INTERNAL, G_LDAP_SYNCH, G_DBWALLETPASS, G_LDAP_PWD);
62:
63: l_session := DBMS_LDAP.init(l_host, l_port);
64:
57: l_user := fnd_preference.get(G_INTERNAL, G_LDAP_SYNCH, G_USERNAME);
58: l_pwd := fnd_preference.eget(G_INTERNAL, G_LDAP_SYNCH, G_EPWD, G_LDAP_PWD);
59: l_ldap_auth := fnd_preference.get(G_INTERNAL, G_LDAP_SYNCH, G_DBLDAPAUTHLEVEL);
60: l_db_wlt_url := fnd_preference.get(G_INTERNAL, G_LDAP_SYNCH, G_DBWALLETDIR);
61: l_db_wlt_pwd := fnd_preference.eget(G_INTERNAL, G_LDAP_SYNCH, G_DBWALLETPASS, G_LDAP_PWD);
62:
63: l_session := DBMS_LDAP.init(l_host, l_port);
64:
65: -- Elan, 04/27/2004, Not disclosing the password - gets saved to the database
222:
223: -- Bug 5001849 use FND API instead of directly doing a select against
224: -- fnd_user_preferences
225:
226: orclAppName := fnd_preference.get(p_user_name => '#INTERNAL',
227: p_module_name => 'LDAP_SYNCH',
228: p_pref_name => 'USERNAME');
229:
230: removeExtraQuotes(orclAppName);