DBA Data[Home] [Help]

APPS.WF_LDAP dependencies on FND_PREFERENCE

Line 361: my_host := fnd_preference.get('#INTERNAL', 'LDAP_SYNCH', 'HOST');

357: my_pwd varchar2(256);
358: begin
359: dbms_ldap.use_exception := TRUE;
360:
361: my_host := fnd_preference.get('#INTERNAL', 'LDAP_SYNCH', 'HOST');
362: my_port := fnd_preference.get('#INTERNAL', 'LDAP_SYNCH', 'PORT');
363: my_user := fnd_preference.get('#INTERNAL', 'LDAP_SYNCH', 'USERNAME');
364: my_pwd := fnd_preference.eget('#INTERNAL','LDAP_SYNCH', 'EPWD', 'LDAP_PWD');
365:

Line 362: my_port := fnd_preference.get('#INTERNAL', 'LDAP_SYNCH', 'PORT');

358: begin
359: dbms_ldap.use_exception := TRUE;
360:
361: my_host := fnd_preference.get('#INTERNAL', 'LDAP_SYNCH', 'HOST');
362: my_port := fnd_preference.get('#INTERNAL', 'LDAP_SYNCH', 'PORT');
363: my_user := fnd_preference.get('#INTERNAL', 'LDAP_SYNCH', 'USERNAME');
364: my_pwd := fnd_preference.eget('#INTERNAL','LDAP_SYNCH', 'EPWD', 'LDAP_PWD');
365:
366: p_session := DBMS_LDAP.init(my_host, my_port);

Line 363: my_user := fnd_preference.get('#INTERNAL', 'LDAP_SYNCH', 'USERNAME');

359: dbms_ldap.use_exception := TRUE;
360:
361: my_host := fnd_preference.get('#INTERNAL', 'LDAP_SYNCH', 'HOST');
362: my_port := fnd_preference.get('#INTERNAL', 'LDAP_SYNCH', 'PORT');
363: my_user := fnd_preference.get('#INTERNAL', 'LDAP_SYNCH', 'USERNAME');
364: my_pwd := fnd_preference.eget('#INTERNAL','LDAP_SYNCH', 'EPWD', 'LDAP_PWD');
365:
366: p_session := DBMS_LDAP.init(my_host, my_port);
367: retval := dbms_ldap.simple_bind_s(p_session, my_user, my_pwd);

Line 364: my_pwd := fnd_preference.eget('#INTERNAL','LDAP_SYNCH', 'EPWD', 'LDAP_PWD');

360:
361: my_host := fnd_preference.get('#INTERNAL', 'LDAP_SYNCH', 'HOST');
362: my_port := fnd_preference.get('#INTERNAL', 'LDAP_SYNCH', 'PORT');
363: my_user := fnd_preference.get('#INTERNAL', 'LDAP_SYNCH', 'USERNAME');
364: my_pwd := fnd_preference.eget('#INTERNAL','LDAP_SYNCH', 'EPWD', 'LDAP_PWD');
365:
366: p_session := DBMS_LDAP.init(my_host, my_port);
367: retval := dbms_ldap.simple_bind_s(p_session, my_user, my_pwd);
368: exception

Line 464: my_host := fnd_preference.get('#INTERNAL','LDAP_SYNCH','HOST');

460: found boolean := FALSE;
461: fullbucket boolean := TRUE;
462: begin
463: wf_ldap.get_ldap_session(my_session);
464: my_host := fnd_preference.get('#INTERNAL','LDAP_SYNCH','HOST');
465: my_user_base := fnd_preference.get('#INTERNAL','LDAP_SYNCH','USER_DIR');
466: my_log_base := fnd_preference.get('#INTERNAL','LDAP_SYNCH','CHANGELOG_DIR');
467:
468: if (my_log_base is null OR my_user_base is null) then

Line 465: my_user_base := fnd_preference.get('#INTERNAL','LDAP_SYNCH','USER_DIR');

461: fullbucket boolean := TRUE;
462: begin
463: wf_ldap.get_ldap_session(my_session);
464: my_host := fnd_preference.get('#INTERNAL','LDAP_SYNCH','HOST');
465: my_user_base := fnd_preference.get('#INTERNAL','LDAP_SYNCH','USER_DIR');
466: my_log_base := fnd_preference.get('#INTERNAL','LDAP_SYNCH','CHANGELOG_DIR');
467:
468: if (my_log_base is null OR my_user_base is null) then
469: wf_core.context('wf_ldap', 'synch_changes');

Line 466: my_log_base := fnd_preference.get('#INTERNAL','LDAP_SYNCH','CHANGELOG_DIR');

462: begin
463: wf_ldap.get_ldap_session(my_session);
464: my_host := fnd_preference.get('#INTERNAL','LDAP_SYNCH','HOST');
465: my_user_base := fnd_preference.get('#INTERNAL','LDAP_SYNCH','USER_DIR');
466: my_log_base := fnd_preference.get('#INTERNAL','LDAP_SYNCH','CHANGELOG_DIR');
467:
468: if (my_log_base is null OR my_user_base is null) then
469: wf_core.context('wf_ldap', 'synch_changes');
470: wf_core.raise('WF_LDAP_INVALID_PREFS');

Line 537: my_key_att := fnd_preference.get('#INTERNAL','LDAP_SYNCH', 'KEYATT');

533: DBMS_LDAP.SCOPE_SUBTREE,
534: '(&(objectclass=person)(cn='||my_uname||'))');
535:
536: --start bug 3101137
537: my_key_att := fnd_preference.get('#INTERNAL','LDAP_SYNCH', 'KEYATT');
538: if (my_key_att is null) then
539: my_key_att := 'cn';
540: end if;
541: -- my_key_att := get_name_attr(my_session);

Line 579: my_user_base := fnd_preference.get('#INTERNAL','LDAP_SYNCH','USER_DIR');

575: origsizelimit varchar2(10) := 'DUNNO';
576: begin
577: wf_ldap.get_ldap_session(my_session);
578:
579: my_user_base := fnd_preference.get('#INTERNAL','LDAP_SYNCH','USER_DIR');
580: if (my_user_base is null) then
581: wf_core.context('wf_ldap', 'synch_all');
582: wf_core.raise('WF_LDAP_INVALID_PREFS');
583: end if;

Line 606: my_key_att := fnd_preference.get('#INTERNAL','LDAP_SYNCH', 'KEYATT');

602: DBMS_LDAP.SCOPE_SUBTREE, 'objectclass=person');
603: wf_entity_mgr.flush_cache('*ALL*', null);
604:
605: --start bug 3101137
606: my_key_att := fnd_preference.get('#INTERNAL','LDAP_SYNCH', 'KEYATT');
607: if (my_key_att is null) then
608: my_key_att := 'cn';
609: end if;
610: -- my_key_att := get_name_attr(my_session);