DBA Data[Home] [Help]

APPS.FND_OID_PLUG dependencies on FND_LDAP_UTIL

Line 586: ldap:= FND_LDAP_UTIl.c_get_oid_session(flag);

582: BEGIN
583: -- if there is no session , create one , so we cann LOG acctions
584: -- VALIDATE THERE IS A PACKAGE
585: UpgradePlugin;
586: ldap:= FND_LDAP_UTIl.c_get_oid_session(flag);
587: l_session_flag := true; /* fix for bug 8271359 */
588:
589: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
590: then

Line 708: guid := FND_LDAP_UTIL.get_guid_for_dn(ldap,p_default_user_repository);

704: if (p_default_user_repository is not null) THEN
705:
706: -- validation
707: BEGIN
708: guid := FND_LDAP_UTIL.get_guid_for_dn(ldap,p_default_user_repository);
709: EXCEPTION WHEN OTHERS THEN
710: guid:=NULL;
711: raise_application_error(-20100,'Given createBaseDn does not exists :'||p_default_user_repository );
712:

Line 740: guid := FND_LDAP_UTIL.get_guid_for_dn(ldap,val);

736: if (val is null ) THEN
737: val := 'cn=Users,'||realm;
738: END IF;
739: BEGIN
740: guid := FND_LDAP_UTIL.get_guid_for_dn(ldap,val);
741: EXCEPTION WHEN OTHERS THEN
742: raise_application_error(-20100,'Default create user base does not exists:'||val);
743: END;
744:

Line 805: FND_LDAP_UTIl.c_unbind(ldap,flag);

801:
802: ELSE
803: saveOption('FIXUP',G_STATIC,'NONE');
804: END IF;
805: FND_LDAP_UTIl.c_unbind(ldap,flag);
806: l_session_flag := false;
807: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
808: then
809: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'l_session_flag : = false ' );

Line 824: fnd_ldap_util.c_unbind(ldap,flag);

820: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
821: then
822: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, 'LDAP SESSION closing in EXCEPTION BLOCK - START ' );
823: end if;
824: fnd_ldap_util.c_unbind(ldap,flag);
825:
826: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
827: then
828: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, 'LDAP SESSION closed in EXCEPTION BLOCK - END ');

Line 892: ldap := fnd_ldap_util.c_get_oid_session(flag);

888: end if;
889: return;
890: else
891: */
892: ldap := fnd_ldap_util.c_get_oid_session(flag);
893: l_session_flag := true; /* fix for bug 8271359 */
894:
895: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
896: then

Line 903: g_realm := FND_LDAP_UTIl.getLDAPAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext','orclDefaultSubscriber');

899:
900: if (default_realm is not null) then
901: g_realm := default_realm;
902: else
903: g_realm := FND_LDAP_UTIl.getLDAPAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext','orclDefaultSubscriber');
904: end if;
905:
906: if (default_user_repository is not null) then
907: g_user_repo := default_user_repository;

Line 909: g_user_repo := FND_LDAP_UTIl.getLDAPAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext,'||g_realm,'orclcommondefaultusercreatebase');

905:
906: if (default_user_repository is not null) then
907: g_user_repo := default_user_repository;
908: else
909: g_user_repo := FND_LDAP_UTIl.getLDAPAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext,'||g_realm,'orclcommondefaultusercreatebase');
910: end if;
911: if (g_user_repo is null) then
912: g_user_repo := 'cn=Users,'||g_realm;
913: end if;

Line 917: g_user_search := FND_LDAP_UTIL.getLDAPAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext,'||g_realm,'orclcommonusersearchbase');

913: end if;
914:
915:
916:
917: g_user_search := FND_LDAP_UTIL.getLDAPAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext,'||g_realm,'orclcommonusersearchbase');
918:
919: if (g_user_search is null) then
920: g_user_search := 'cn=Users,'||g_realm;
921: end if;

Line 923: g_cnatt := FND_LDAP_UTIL.getLDAPAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext,'||g_realm,'orclcommonnamingattribute');

919: if (g_user_search is null) then
920: g_user_search := 'cn=Users,'||g_realm;
921: end if;
922:
923: g_cnatt := FND_LDAP_UTIL.getLDAPAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext,'||g_realm,'orclcommonnamingattribute');
924: if (g_cnatt is null) then
925: g_cnatt := 'cn';
926: end if;
927:

Line 928: g_nicknameatt := FND_LDAP_UTIL.getLDAPAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext,'||g_realm,'orclcommonnicknameattribute');

924: if (g_cnatt is null) then
925: g_cnatt := 'cn';
926: end if;
927:
928: g_nicknameatt := FND_LDAP_UTIL.getLDAPAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext,'||g_realm,'orclcommonnicknameattribute');
929: if (g_nicknameatt is null) then
930: g_nicknameatt := 'uid';
931: end if;
932:

Line 941: fnd_ldap_util.c_unbind(ldap,flag);

937: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_NICK_ATT,g_nicknameatt);
938: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_SEARCH,g_user_search);
939: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_REPOSITORY,g_user_repo);
940:
941: fnd_ldap_util.c_unbind(ldap,flag);
942: l_session_flag := false;
943: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
944: then
945: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'l_session_flag : = false ' );

Line 962: fnd_ldap_util.c_unbind(ldap,flag);

958: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
959: then
960: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, 'LDAP SESSION closing in EXCEPTION BLOCK - START ' );
961: end if;
962: fnd_ldap_util.c_unbind(ldap,flag);
963:
964: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
965: then
966: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, 'LDAP SESSION closed in EXCEPTION BLOCK - END ');

Line 993: ldap := fnd_ldap_util.c_get_oid_session(flag);

989: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
990: then
991: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
992: end if;
993: ldap := fnd_ldap_util.c_get_oid_session(flag);
994: l_session_flag := true; /* fix for bug 8271359 */
995:
996: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
997: then

Line 1000: l_realm := FND_LDAP_UTIL.getLDAPAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext','orclDefaultSubscriber');

996: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
997: then
998: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'l_session_flag = true ' );
999: end if;
1000: l_realm := FND_LDAP_UTIL.getLDAPAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext','orclDefaultSubscriber');
1001: l_repo := FND_LDAP_UTIL.getLDAPAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext,'||l_realm,'orclcommondefaultusercreatebase');
1002: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1003: then
1004: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'AUTO UPGRADE');

Line 1001: l_repo := FND_LDAP_UTIL.getLDAPAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext,'||l_realm,'orclcommondefaultusercreatebase');

997: then
998: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'l_session_flag = true ' );
999: end if;
1000: l_realm := FND_LDAP_UTIL.getLDAPAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext','orclDefaultSubscriber');
1001: l_repo := FND_LDAP_UTIL.getLDAPAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext,'||l_realm,'orclcommondefaultusercreatebase');
1002: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1003: then
1004: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'AUTO UPGRADE');
1005: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, '=============');

Line 1011: fnd_ldap_util.c_unbind(ldap,flag);

1007: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'user creation base:'||l_repo);
1008: end if;
1009:
1010: setPlugin_old( default_realm => l_realm ,default_user_repository=>l_repo,plugin_name =>null);
1011: fnd_ldap_util.c_unbind(ldap,flag);
1012: l_session_flag := false;
1013: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1014: then
1015: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'l_session_flag : = false ' );

Line 1032: fnd_ldap_util.c_unbind(ldap,flag);

1028: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1029: then
1030: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, 'LDAP SESSION closing in EXCEPTION BLOCK - START ' );
1031: end if;
1032: fnd_ldap_util.c_unbind(ldap,flag);
1033:
1034: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1035: then
1036: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, 'LDAP SESSION closed in EXCEPTION BLOCK - END ');

Line 1383: ldap := fnd_ldap_util.c_get_oid_session(dummy);

1379: if (plugin_type is null) then plugin_type:=pluginType; end if;
1380: if (plugin_type=G_STATIC) then
1381: result:= g_user_search;
1382: else
1383: ldap := fnd_ldap_util.c_get_oid_session(dummy);
1384: result:= FND_LDAP_UTIL.getLDAPAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext,'||getRealmDN(username),'orclcommonusersearchbase');
1385: fnd_ldap_util.c_unbind(ldap,dummy);
1386: end if;
1387:

Line 1384: result:= FND_LDAP_UTIL.getLDAPAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext,'||getRealmDN(username),'orclcommonusersearchbase');

1380: if (plugin_type=G_STATIC) then
1381: result:= g_user_search;
1382: else
1383: ldap := fnd_ldap_util.c_get_oid_session(dummy);
1384: result:= FND_LDAP_UTIL.getLDAPAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext,'||getRealmDN(username),'orclcommonusersearchbase');
1385: fnd_ldap_util.c_unbind(ldap,dummy);
1386: end if;
1387:
1388: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 1385: fnd_ldap_util.c_unbind(ldap,dummy);

1381: result:= g_user_search;
1382: else
1383: ldap := fnd_ldap_util.c_get_oid_session(dummy);
1384: result:= FND_LDAP_UTIL.getLDAPAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext,'||getRealmDN(username),'orclcommonusersearchbase');
1385: fnd_ldap_util.c_unbind(ldap,dummy);
1386: end if;
1387:
1388: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1389: then

Line 1456: ldap := fnd_ldap_util.c_get_oid_session(dummy);

1452: then
1453: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1454: end if;
1455:
1456: ldap := fnd_ldap_util.c_get_oid_session(dummy);
1457: l_session_flag := true; /* fix for bug 8271359 */
1458:
1459: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1460: then

Line 1464: result:= FND_LDAP_UTIL.getLDAPAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext,'||realmDn,'orclcommonnicknameattribute');

1460: then
1461: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'l_session_flag = true ' );
1462: end if;
1463:
1464: result:= FND_LDAP_UTIL.getLDAPAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext,'||realmDn,'orclcommonnicknameattribute');
1465: fnd_ldap_util.c_unbind(ldap,dummy);
1466:
1467: l_session_flag := false;
1468: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 1465: fnd_ldap_util.c_unbind(ldap,dummy);

1461: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'l_session_flag = true ' );
1462: end if;
1463:
1464: result:= FND_LDAP_UTIL.getLDAPAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext,'||realmDn,'orclcommonnicknameattribute');
1465: fnd_ldap_util.c_unbind(ldap,dummy);
1466:
1467: l_session_flag := false;
1468: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1469: then

Line 1494: fnd_ldap_util.c_unbind(ldap,dummy);

1490: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1491: then
1492: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, 'LDAP SESSION closing in EXCEPTION BLOCK - START ' );
1493: end if;
1494: fnd_ldap_util.c_unbind(ldap,dummy);
1495:
1496: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1497: then
1498: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, 'LDAP SESSION closed in EXCEPTION BLOCK - END ');

Line 1633: g := FND_LDAP_UTIL.getLDAPAttribute(ldap,dn,'orclguid','objectclass=orclSubscriber');

1629: dn := dn||','||cn_list(j);
1630: j:=j+1;
1631: end loop;
1632: BEGIN
1633: g := FND_LDAP_UTIL.getLDAPAttribute(ldap,dn,'orclguid','objectclass=orclSubscriber');
1634: if (dev_version>=1.1) THEN -- we check something more
1635: g := FND_LDAP_UTIL.getLDAPAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext,'||dn,'orclcommonnicknameattribute','objectclass=*');
1636: END IF;
1637: EXCEPTION

Line 1635: g := FND_LDAP_UTIL.getLDAPAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext,'||dn,'orclcommonnicknameattribute','objectclass=*');

1631: end loop;
1632: BEGIN
1633: g := FND_LDAP_UTIL.getLDAPAttribute(ldap,dn,'orclguid','objectclass=orclSubscriber');
1634: if (dev_version>=1.1) THEN -- we check something more
1635: g := FND_LDAP_UTIL.getLDAPAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext,'||dn,'orclcommonnicknameattribute','objectclass=*');
1636: END IF;
1637: EXCEPTION
1638: WHEN DBMS_LDAP.general_error THEN
1639: g:= null;

Line 1704: ldap := fnd_ldap_util.c_get_oid_session(dummy);

1700: then
1701: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'guid='||p_user_guid);
1702: end if;
1703:
1704: ldap := fnd_ldap_util.c_get_oid_session(dummy);
1705: l_session_flag := true; /* fix for bug 8271359 */
1706:
1707: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1708: then

Line 1757: --nickNameAttr:=FND_LDAP_UTIL.getLDAPAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext,'||realm_dn,'orclCommonNicknameAttribute');

1753: fnd_message.set_name ('FND', 'FND-9903'); -- cannot find realm idx
1754: raise NO_DATA_FOUND ;
1755: end if;
1756:
1757: --nickNameAttr:=FND_LDAP_UTIL.getLDAPAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext,'||realm_dn,'orclCommonNicknameAttribute');
1758: nickNameAttr := FND_SSO_REGISTRATION.get_realm_attribute(realm_idx,'orclCommonNicknameAttribute');
1759: if (fnd_log.LEVEL_STATEMENT>= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1760: then
1761: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Realm=>NickNameAttrubute:'||nickNameAttr);

Line 1774: user_name := FND_LDAP_UTIL.getLDAPAttribute(ldap,user_dn,nickNameAttr);

1770: fnd_message.set_name ('FND', 'FND-9903'); -- cannot find nickname attribute specification
1771: raise NO_DATA_FOUND ;
1772: end if;
1773:
1774: user_name := FND_LDAP_UTIL.getLDAPAttribute(ldap,user_dn,nickNameAttr);
1775: if (fnd_log.LEVEL_STATEMENT>= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1776: then
1777: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'DN+NickNameAttrubute=>user_name:'||user_name);
1778: end if;

Line 1788: fnd_ldap_util.c_unbind(ldap,dummy);

1784: end if;
1785: fnd_message.set_name ('FND', 'FND_SSO_USER_NOT_FOUND'); --user has no nickname
1786: raise NO_DATA_FOUND ;
1787: end if;
1788: fnd_ldap_util.c_unbind(ldap,dummy);
1789: l_session_flag := false;
1790: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1791: then
1792: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'l_session_flag : = false ' );

Line 1803: fnd_ldap_util.c_unbind(ldap,dummy);

1799: end if;
1800:
1801: return user_name;
1802: EXCEPTION when NO_DATA_FOUND THEN
1803: fnd_ldap_util.c_unbind(ldap,dummy);
1804: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1805: then
1806: fnd_log.string(fnd_log.LEVEL_EXCEPTION, l_module_source, ' Not found guid='||p_user_guid);
1807: end if;

Line 1879: ldap := fnd_ldap_util.c_get_oid_session(flag);

1875: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'No guid or username=> returning the default realm');
1876: END IF;
1877: result:= FND_OID_PLUG.get_default_realm;
1878: ELSE
1879: ldap := fnd_ldap_util.c_get_oid_session(flag);
1880: l_session_flag := true; /* fix for bug 8271359 */
1881:
1882: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1883: then

Line 1914: fnd_ldap_util.c_unbind(ldap,flag);

1910: IF (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) THEN
1911: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'fallback to default realm:'||result);
1912: END IF;
1913: END IF;
1914: fnd_ldap_util.c_unbind(ldap,flag);
1915: l_session_flag := false;
1916: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1917: then
1918: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'l_session_flag : = false ' );

Line 1933: fnd_ldap_util.c_unbind(ldap,flag);

1929: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1930: then
1931: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, 'LDAP SESSION closing in EXCEPTION BLOCK - START ' );
1932: end if;
1933: fnd_ldap_util.c_unbind(ldap,flag);
1934:
1935: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1936: then
1937: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, 'LDAP SESSION closed in EXCEPTION BLOCK - END ');

Line 2110: procedure copyData( d1 in out nocopy FND_LDAP_UTIl.ldap_record_values, d2 in out nocopy FND_LDAP_UTIL.ldap_record_values )

2106: begin
2107: return t;
2108: end Helper_NewEmptyCollection;
2109:
2110: procedure copyData( d1 in out nocopy FND_LDAP_UTIl.ldap_record_values, d2 in out nocopy FND_LDAP_UTIL.ldap_record_values )
2111: is
2112: atName varchar2(4000);
2113: idx pls_integer;
2114: begin