88: found boolean := TRUE;
89: l_module_source varchar2(200) := G_MODULE_SOURCE || 'loadOption: ';
90:
91: BEGIN
92: val := fnd_preference.get(G_PREF_USER,G_PREF_MODULE,name||'_opt_mode');
93: IF val is null then found := FALSE;
94: ELSIF (val='STATIC') THEN opt.opt_mode:=0;
95: ELSIF (val='DYNAMIC') THEN opt.opt_mode:=1;
96: ELSIF (val='RUNTIME') THEN opt.opt_mode:=1;
96: ELSIF (val='RUNTIME') THEN opt.opt_mode:=1;
97: ELSE raise invalid_deployment;
98: END IF;
99: IF found THEN
100: opt.val := fnd_preference.get(G_PREF_USER,G_PREF_MODULE,name);
101: found := opt.val is not null;
102: if (found) THEN
103: g_option(name):= opt;
104: END IF;
117: is
118: l_module_source varchar2(200) := G_MODULE_SOURCE || 'saveOption: ';
119: BEGIN
120: if (opt_mode=0) THEN
121: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,name||'_opt_mode','STATIC');
122: elsif (opt_mode=1) THEN
123: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,name||'_opt_mode','DYNAMIC');
124: elsif (opt_mode=2) THEN
125: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,name||'_opt_mode','RUNTIME');
119: BEGIN
120: if (opt_mode=0) THEN
121: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,name||'_opt_mode','STATIC');
122: elsif (opt_mode=1) THEN
123: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,name||'_opt_mode','DYNAMIC');
124: elsif (opt_mode=2) THEN
125: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,name||'_opt_mode','RUNTIME');
126: else
127: raise invalid_deployment;
121: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,name||'_opt_mode','STATIC');
122: elsif (opt_mode=1) THEN
123: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,name||'_opt_mode','DYNAMIC');
124: elsif (opt_mode=2) THEN
125: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,name||'_opt_mode','RUNTIME');
126: else
127: raise invalid_deployment;
128: END IF;
129: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,name,value);
125: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,name||'_opt_mode','RUNTIME');
126: else
127: raise invalid_deployment;
128: END IF;
129: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,name,value);
130:
131: if (g_option.exists(name)) then
132: g_option.delete(name); --cancel the cache
133: end if;
144: PROCEDURE deleteOption( name in varchar2)
145: is
146: l_module_source varchar2(200) := G_MODULE_SOURCE || 'saveOption: ';
147: BEGIN
148: fnd_preference.remove(G_PREF_USER,G_PREF_MODULE,name);
149: fnd_preference.remove(G_PREF_USER,G_PREF_MODULE,name||'_opt_mode');
150: if (g_option.exists(name)) then
151: g_option.delete(name); --cancel the cache
152: end if;
145: is
146: l_module_source varchar2(200) := G_MODULE_SOURCE || 'saveOption: ';
147: BEGIN
148: fnd_preference.remove(G_PREF_USER,G_PREF_MODULE,name);
149: fnd_preference.remove(G_PREF_USER,G_PREF_MODULE,name||'_opt_mode');
150: if (g_option.exists(name)) then
151: g_option.delete(name); --cancel the cache
152: end if;
153:
375: then
376: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
377: end if;
378:
379: l_version := FND_PREFERENCE.get('#INTERNAL','OID_CONF','PLUGIN_VERSION');
380:
381: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
382: then
383: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Retrieved PLUGIN_VERSION preference');
400: end if;
401:
402: return l_plug_ver;
403:
404: ELSIF FND_PREFERENCE.exists('#INTERNAL','OID_CONF','CREATE_BASE') THEN
405:
406: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
407: then
408: fnd_log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'CREATE_BASE exists - PLUGIN_VERSION did not - return 1.0');
473: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'upgrading from 1.0');
474: end if;
475: params := list_t('CN_ATT_CACHED','CREATE_BASE','NICK_ATT_CACHED','REALM','SEARCH_BASE_CACHED','TYPE');
476: for p in params.first .. params.last loop
477: old_val(params(p)) := FND_PREFERENCE.GET('#INTERNAL','OID_CONF',params(p));
478: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
479: then
480: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'old '||params(p)||'='||old_val(params(p)) );
481: end if;
501: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
502: then
503: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'removing previous preferences');
504: end if;
505: FND_PREFERENCE.DELETE_ALL('#INTERNAL','OID_CONF');
506:
507: if NOT old_val.exists('REALM') THEN
508: old_val('REALM') := fnd_sso_registration.getdefaultrealm;
509: END IF;
519: saveOption('REALM',G_STATIC,old_val('REALM'));
520: saveOption('DEFAULT_CREATE_BASE',G_STATIC,old_val('CREATE_BASE'));
521: saveOption('CREATE_BASE',G_STATIC,old_val('CREATE_BASE'));
522: saveOption('RDN',G_STATIC,old_val('CN_ATT_CACHED') );
523: FND_PREFERENCE.put('#INTERNAL','OID_CONF','PLUGIN_VERSION','1.1');
524: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
525: then
526: params := list_t('DEFAULT_REALM','REALM','DEFAULT_CREATE_BASE','CREATE_BASE','RDN','PLUGIN_VERSION');
527: for p in params.first .. params.last loop
524: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
525: then
526: params := list_t('DEFAULT_REALM','REALM','DEFAULT_CREATE_BASE','CREATE_BASE','RDN','PLUGIN_VERSION');
527: for p in params.first .. params.last loop
528: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,' pref set : '||params(p)||'='||FND_PREFERENCE.GET('#INTERNAL','OID_CONF',params(p)));
529: end loop;
530: end if;
531: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
532: then
856: end if;
857: /*
858: if (plugin_name is not null) then
859: -- if ( validateTemplate('FND_OID_PLUG.getRDN',plugin_name||'.getRDN',msg) )THEN
860: -- fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_RDN,'begin '||plugin_name||'.getRDN(:1,:2,:3:,:4,:5); end;');
861: -- isDynamic := true;
862: -- ELSE
863: -- if (fnd_log.LEVEL_EXCEPTION >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
864: -- then
878: null;
879: END IF;
880:
881:
882: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_TYPE,G_DYNAMIC_DESC);
883: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_REALM,'begin :1 := '||plugin_name||'.Realm(:2); end;');
884: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_REPOSITORY,'begin :1 := '||plugin_name||'.UserRepository(:2); end;');
885: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
886: then
879: END IF;
880:
881:
882: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_TYPE,G_DYNAMIC_DESC);
883: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_REALM,'begin :1 := '||plugin_name||'.Realm(:2); end;');
884: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_REPOSITORY,'begin :1 := '||plugin_name||'.UserRepository(:2); end;');
885: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
886: then
887: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End' );
880:
881:
882: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_TYPE,G_DYNAMIC_DESC);
883: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_REALM,'begin :1 := '||plugin_name||'.Realm(:2); end;');
884: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_REPOSITORY,'begin :1 := '||plugin_name||'.UserRepository(:2); end;');
885: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
886: then
887: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End' );
888: end if;
930: g_nicknameatt := 'uid';
931: end if;
932:
933:
934: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_TYPE,G_STATIC_DESC);
935: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_REALM,g_realm);
936: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_CN_ATT,g_cnatt);
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);
931: end if;
932:
933:
934: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_TYPE,G_STATIC_DESC);
935: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_REALM,g_realm);
936: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_CN_ATT,g_cnatt);
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);
932:
933:
934: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_TYPE,G_STATIC_DESC);
935: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_REALM,g_realm);
936: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_CN_ATT,g_cnatt);
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:
933:
934: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_TYPE,G_STATIC_DESC);
935: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_REALM,g_realm);
936: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_CN_ATT,g_cnatt);
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);
934: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_TYPE,G_STATIC_DESC);
935: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_REALM,g_realm);
936: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_CN_ATT,g_cnatt);
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;
935: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_REALM,g_realm);
936: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_CN_ATT,g_cnatt);
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)