78: fixInfo := fixInfo || '
283: pwd varchar2(100);
284: begin
285: currentMethod := 'preference_test';
286: ldapSession := null;
287: orclAppName := fnd_preference.get(p_user_name => '#INTERNAL', p_module_name => 'LDAP_SYNCH', p_pref_name => 'USERNAME');
288: pwd :=fnd_preference.eget('#INTERNAL','LDAP_SYNCH', 'EPWD', 'LDAP_PWD');
289: host := fnd_preference.get('#INTERNAL', 'LDAP_SYNCH', 'HOST');
290: port := fnd_preference.get('#INTERNAL', 'LDAP_SYNCH', 'PORT');
291: beginTable('OiD connect parameters ');
284: begin
285: currentMethod := 'preference_test';
286: ldapSession := null;
287: orclAppName := fnd_preference.get(p_user_name => '#INTERNAL', p_module_name => 'LDAP_SYNCH', p_pref_name => 'USERNAME');
288: pwd :=fnd_preference.eget('#INTERNAL','LDAP_SYNCH', 'EPWD', 'LDAP_PWD');
289: host := fnd_preference.get('#INTERNAL', 'LDAP_SYNCH', 'HOST');
290: port := fnd_preference.get('#INTERNAL', 'LDAP_SYNCH', 'PORT');
291: beginTable('OiD connect parameters ');
292: if (orclAppName is null) then
285: currentMethod := 'preference_test';
286: ldapSession := null;
287: orclAppName := fnd_preference.get(p_user_name => '#INTERNAL', p_module_name => 'LDAP_SYNCH', p_pref_name => 'USERNAME');
288: pwd :=fnd_preference.eget('#INTERNAL','LDAP_SYNCH', 'EPWD', 'LDAP_PWD');
289: host := fnd_preference.get('#INTERNAL', 'LDAP_SYNCH', 'HOST');
290: port := fnd_preference.get('#INTERNAL', 'LDAP_SYNCH', 'PORT');
291: beginTable('OiD connect parameters ');
292: if (orclAppName is null) then
293: insertRow('AppDN is null');
286: ldapSession := null;
287: orclAppName := fnd_preference.get(p_user_name => '#INTERNAL', p_module_name => 'LDAP_SYNCH', p_pref_name => 'USERNAME');
288: pwd :=fnd_preference.eget('#INTERNAL','LDAP_SYNCH', 'EPWD', 'LDAP_PWD');
289: host := fnd_preference.get('#INTERNAL', 'LDAP_SYNCH', 'HOST');
290: port := fnd_preference.get('#INTERNAL', 'LDAP_SYNCH', 'PORT');
291: beginTable('OiD connect parameters ');
292: if (orclAppName is null) then
293: insertRow('AppDN is null');
294: statusStr := 'FAILURE';
581: result pls_integer;
582:
583: begin
584: currentMethod := 'passwordTest';
585: select fnd_preference.eget('#INTERNAL','LDAP_SYNCH', 'EPWD', 'LDAP_PWD')
586: into appsPwd
587: from dual;
588:
589: result := dbms_ldap.compare_s(ld => ldapSession, dn => orclAppName,