APPS.FND_OID_PLUG dependencies on FND_LOG

Line 67: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

63: l_module_source varchar2(1000) ;
64: BEGIN
65: l_module_source := G_MODULE_SOURCE || 'getAttribute: ';
66:
67: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
68: then
69: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
70: end if;
71:

Line 69: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

65: l_module_source := G_MODULE_SOURCE || 'getAttribute: ';
66:
67: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
68: then
69: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
70: end if;
71:
72: l_attrs(0):= attrName;
73: result := dbms_ldap.search_s(ld => ldap

Line 84: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

80: l_entry := dbms_ldap.first_entry(ldap, l_message);
81: if (l_entry is null ) then return null; end if;
82: l_attrs := dbms_ldap.get_values(ldap, l_entry, attrName);
83: l_result := l_attrs(0);
84: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
85: then
86: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'ldapsearch -b "'||dn||'" -s base "'||filterExp||'" '||attrName);
87: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'result:'||l_result);
88: end if;

Line 86: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'ldapsearch -b "'||dn||'" -s base "'||filterExp||'" '||attrName);

82: l_attrs := dbms_ldap.get_values(ldap, l_entry, attrName);
83: l_result := l_attrs(0);
84: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
85: then
86: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'ldapsearch -b "'||dn||'" -s base "'||filterExp||'" '||attrName);
87: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'result:'||l_result);
88: end if;
89:
90: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 87: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'result:'||l_result);

83: l_result := l_attrs(0);
84: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
85: then
86: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'ldapsearch -b "'||dn||'" -s base "'||filterExp||'" '||attrName);
87: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'result:'||l_result);
88: end if;
89:
90: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
91: then

Line 90: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

86: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'ldapsearch -b "'||dn||'" -s base "'||filterExp||'" '||attrName);
87: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'result:'||l_result);
88: end if;
89:
90: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
91: then
92: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ');
93: end if;
94: return l_result;

Line 92: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ');

88: end if;
89:
90: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
91: then
92: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ');
93: end if;
94: return l_result;
95:
96:

Line 100: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

96:
97: exception
98:
99: when NO_DATA_FOUND then
100: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
101: then
102: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END -> NULL');
103: end if;
104: return null;

Line 102: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END -> NULL');

98:
99: when NO_DATA_FOUND then
100: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
101: then
102: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END -> NULL');
103: end if;
104: return null;
105:
106:

Line 109: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

105:
106:
107: when dbms_ldap.general_error then
108:
109: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
110: then
111: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END no rows');
112: end if;
113: return null;

Line 111: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END no rows');

107: when dbms_ldap.general_error then
108:
109: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
110: then
111: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END no rows');
112: end if;
113: return null;
114:
115: when OTHERS then

Line 116: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

112: end if;
113: return null;
114:
115: when OTHERS then
116: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
117: then
118: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END -> EXCEPTION '||sqlerrm);
119: end if;
120: l_result :=sqlerrm;

Line 118: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END -> EXCEPTION '||sqlerrm);

114:
115: when OTHERS then
116: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
117: then
118: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END -> EXCEPTION '||sqlerrm);
119: end if;
120: l_result :=sqlerrm;
121: raise;
122: END getAttribute;

Line 134: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

130: l_module_source varchar2(1000) ;
131: BEGIN
132: l_module_source := G_MODULE_SOURCE || 'getRealmNickNameattr: ';
133:
134: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
135: then
136: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin realm='||realm);
137: end if;
138:

Line 136: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin realm='||realm);

132: l_module_source := G_MODULE_SOURCE || 'getRealmNickNameattr: ';
133:
134: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
135: then
136: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin realm='||realm);
137: end if;
138:
139: ldap := fnd_ldap_util.c_get_oid_session(flag);
140: ret := getAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext,'||realm,'orclcommonnicknameattribute');

Line 142: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

138:
139: ldap := fnd_ldap_util.c_get_oid_session(flag);
140: ret := getAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext,'||realm,'orclcommonnicknameattribute');
141: fnd_ldap_util.c_unbind(ldap,flag);
142: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
143: then
144: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END nicknameAttr='||ret);
145: end if;
146: return ret;

Line 144: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END nicknameAttr='||ret);

140: ret := getAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext,'||realm,'orclcommonnicknameattribute');
141: fnd_ldap_util.c_unbind(ldap,flag);
142: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
143: then
144: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END nicknameAttr='||ret);
145: end if;
146: return ret;
147: end getRealmNickNameattr;
148:

Line 174: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

170: plugin_type := null ; -- bug 6164880
171:
172: l_module_source := G_MODULE_SOURCE || 'setPlugin: ';
173:
174: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
175: then
176: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin' );
177: end if;
178:

Line 176: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin' );

172: l_module_source := G_MODULE_SOURCE || 'setPlugin: ';
173:
174: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
175: then
176: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin' );
177: end if;
178:
179: if (plugin_name is not null) then
180: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_TYPE,G_DYNAMIC_DESC);

Line 183: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

179: if (plugin_name is not null) then
180: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_TYPE,G_DYNAMIC_DESC);
181: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_REALM,'begin :1 := '||plugin_name||'.Realm(:2); end;');
182: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_REPOSITORY,'begin :1 := '||plugin_name||'.UserRepository(:2); end;');
183: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
184: then
185: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End' );
186: end if;
187: return;

Line 185: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End' );

181: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_REALM,'begin :1 := '||plugin_name||'.Realm(:2); end;');
182: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_REPOSITORY,'begin :1 := '||plugin_name||'.UserRepository(:2); end;');
183: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
184: then
185: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End' );
186: end if;
187: return;
188: else
189: ldap := fnd_ldap_util.c_get_oid_session(flag);

Line 277: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

273: fnd_preference.put(G_PREF_USER,G_PREF_MODULE,L_REPOSITORY,g_user_repo);
274: fnd_ldap_util.c_unbind(ldap,flag);
275:
276: end if;
277: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
278: then
279: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End' );
280: end if;
281: EXCEPTION

Line 279: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End' );

275:
276: end if;
277: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
278: then
279: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End' );
280: end if;
281: EXCEPTION
282: when others then
283: rollback;

Line 298: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

294: l_module_source varchar2(1000) ;
295: BEGIN
296: l_module_source := G_MODULE_SOURCE || 'upgrade_preferences: ';
297:
298: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
299: then
300: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
301: end if;
302: ldap := fnd_ldap_util.c_get_oid_session(flag);

Line 300: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

296: l_module_source := G_MODULE_SOURCE || 'upgrade_preferences: ';
297:
298: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
299: then
300: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
301: end if;
302: ldap := fnd_ldap_util.c_get_oid_session(flag);
303: l_realm := getAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext','orclDefaultSubscriber');
304: l_repo := getAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext,'||l_realm,'orclcommondefaultusercreatebase');

Line 305: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

301: end if;
302: ldap := fnd_ldap_util.c_get_oid_session(flag);
303: l_realm := getAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext','orclDefaultSubscriber');
304: l_repo := getAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext,'||l_realm,'orclcommondefaultusercreatebase');
305: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
306: then
307: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'AUTO UPGRADE');
308: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, '=============');
309: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'realm:'||l_realm);

Line 307: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'AUTO UPGRADE');

303: l_realm := getAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext','orclDefaultSubscriber');
304: l_repo := getAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext,'||l_realm,'orclcommondefaultusercreatebase');
305: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
306: then
307: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'AUTO UPGRADE');
308: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, '=============');
309: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'realm:'||l_realm);
310: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'user creation base:'||l_repo);
311: end if;

Line 308: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, '=============');

304: l_repo := getAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext,'||l_realm,'orclcommondefaultusercreatebase');
305: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
306: then
307: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'AUTO UPGRADE');
308: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, '=============');
309: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'realm:'||l_realm);
310: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'user creation base:'||l_repo);
311: end if;
312:

Line 309: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'realm:'||l_realm);

305: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
306: then
307: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'AUTO UPGRADE');
308: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, '=============');
309: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'realm:'||l_realm);
310: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'user creation base:'||l_repo);
311: end if;
312:
313: setPlugin( default_realm => l_realm ,default_user_repository=>l_repo,plugin_name =>null);

Line 310: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'user creation base:'||l_repo);

306: then
307: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'AUTO UPGRADE');
308: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, '=============');
309: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'realm:'||l_realm);
310: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'user creation base:'||l_repo);
311: end if;
312:
313: setPlugin( default_realm => l_realm ,default_user_repository=>l_repo,plugin_name =>null);
314: fnd_ldap_util.c_unbind(ldap,flag);

Line 316: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

312:
313: setPlugin( default_realm => l_realm ,default_user_repository=>l_repo,plugin_name =>null);
314: fnd_ldap_util.c_unbind(ldap,flag);
315:
316: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
317: then
318: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'end');
319: end if;
320:

Line 318: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'end');

314: fnd_ldap_util.c_unbind(ldap,flag);
315:
316: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
317: then
318: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'end');
319: end if;
320:
321:
322: exception when others then

Line 323: if (fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

319: end if;
320:
321:
322: exception when others then
323: if (fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
324: then
325: fnd_log.string(fnd_log.LEVEL_UNEXPECTED , l_module_source, 'Error '||sqlerrm);
326: end if;
327: raise;

Line 325: fnd_log.string(fnd_log.LEVEL_UNEXPECTED , l_module_source, 'Error '||sqlerrm);

321:
322: exception when others then
323: if (fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
324: then
325: fnd_log.string(fnd_log.LEVEL_UNEXPECTED , l_module_source, 'Error '||sqlerrm);
326: end if;
327: raise;
328: END upgrade_preferences;
329:

Line 337: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

333: l_module_source varchar2(1000) ;
334: BEGIN
335: l_module_source := G_MODULE_SOURCE || 'pluginType: ';
336:
337: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
338: then
339: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
340: end if;
341: if (plugin_type is null)

Line 339: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

335: l_module_source := G_MODULE_SOURCE || 'pluginType: ';
336:
337: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
338: then
339: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
340: end if;
341: if (plugin_type is null)
342: then
343: val := fnd_preference.get(G_PREF_USER,G_PREF_MODULE,L_TYPE);

Line 348: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

344: if (val IS NULL) THEN
345: -- FIRST TIME CALLER, after patch application
346: -- make it compatible with new functionality
347: upgrade_preferences;
348: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
349: then
350: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END(1)');
351: end if;
352: return pluginType;

Line 350: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END(1)');

346: -- make it compatible with new functionality
347: upgrade_preferences;
348: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
349: then
350: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END(1)');
351: end if;
352: return pluginType;
353: elsif (val=G_STATIC_DESC) THEN
354: plugin_type:=G_STATIC;

Line 367: if (fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

363: g_realm:=fnd_preference.get(G_PREF_USER,G_PREF_MODULE,L_REALM);
364: g_user_repo:=fnd_preference.get(G_PREF_USER,G_PREF_MODULE,L_REPOSITORY);
365:
366: else
367: if (fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
368: then
369: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source, 'invalid deployment option/val='||val);
370: end if;
371: raise invalid_deployment;

Line 369: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source, 'invalid deployment option/val='||val);

365:
366: else
367: if (fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
368: then
369: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source, 'invalid deployment option/val='||val);
370: end if;
371: raise invalid_deployment;
372: end if;
373: end if;

Line 374: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

370: end if;
371: raise invalid_deployment;
372: end if;
373: end if;
374: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
375: then
376: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END');
377: end if;
378: RETURN plugin_type;

Line 376: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END');

372: end if;
373: end if;
374: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
375: then
376: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END');
377: end if;
378: RETURN plugin_type;
379: END pluginType;
380:

Line 390: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

386: l_module_source varchar2(1000) ;
387: BEGIN
388: l_module_source := G_MODULE_SOURCE || 'sql_execute: ';
389:
390: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
391: then
392: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
393: end if;
394: c := dbms_sql.open_cursor;

Line 392: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

388: l_module_source := G_MODULE_SOURCE || 'sql_execute: ';
389:
390: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
391: then
392: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
393: end if;
394: c := dbms_sql.open_cursor;
395: dbms_sql.parse(c, stmt, dbms_sql.NATIVE);
396: dbms_sql.bind_variable(c, ':2', param);

Line 402: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

398: res := dbms_sql.execute(c);
399: dbms_sql.variable_value(c,':1',result);
400: dbms_sql.close_cursor(c);
401:
402: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
403: then
404: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END');
405: end if;
406: return result;

Line 404: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END');

400: dbms_sql.close_cursor(c);
401:
402: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
403: then
404: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END');
405: end if;
406: return result;
407: END sql_execute;
408:

Line 417: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

413: result varchar2(4000);
414: BEGIN
415: l_module_source := G_MODULE_SOURCE || 'getDN: ';
416:
417: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
418: then
419: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
420: end if;
421:

Line 419: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

415: l_module_source := G_MODULE_SOURCE || 'getDN: ';
416:
417: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
418: then
419: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
420: end if;
421:
422:
423: if (plugin_type is null) then plugin_type:=pluginType; end if;

Line 427: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

423: if (plugin_type is null) then plugin_type:=pluginType; end if;
424:
425: result := getRDN(username)||','||getUserRepository(username);
426:
427: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
428: then
429: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||result);
430: end if;
431: return result;

Line 429: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||result);

425: result := getRDN(username)||','||getUserRepository(username);
426:
427: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
428: then
429: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||result);
430: end if;
431: return result;
432:
433: END getDN;

Line 443: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

439: l_module_source varchar2(1000) ;
440: BEGIN
441: l_module_source := G_MODULE_SOURCE || 'getRealmDN: ';
442:
443: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
444: then
445: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
446: end if;
447:

Line 445: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

441: l_module_source := G_MODULE_SOURCE || 'getRealmDN: ';
442:
443: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
444: then
445: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
446: end if;
447:
448: if (plugin_type is null) then plugin_type:=pluginType; end if;
449: if (plugin_type=G_STATIC) then

Line 455: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

451: else
452: result := sql_execute(g_realm,username);
453: end if;
454:
455: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
456: then
457: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||result);
458: end if;
459:

Line 457: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||result);

453: end if;
454:
455: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
456: then
457: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||result);
458: end if;
459:
460: return result;
461: END getRealmDN;

Line 469: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

465: l_module_source varchar2(1000) ;
466: BEGIN
467: l_module_source := G_MODULE_SOURCE || 'getUserRepository: ';
468:
469: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
470: then
471: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
472: end if;
473:

Line 471: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

467: l_module_source := G_MODULE_SOURCE || 'getUserRepository: ';
468:
469: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
470: then
471: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
472: end if;
473:
474: if (plugin_type is null) then plugin_type:=pluginType; end if;
475: if (plugin_type=G_STATIC) then

Line 482: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

478: result := sql_execute(g_user_repo,username);
479: end if;
480:
481:
482: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
483: then
484: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||result);
485: end if;
486:

Line 484: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||result);

480:
481:
482: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
483: then
484: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||result);
485: end if;
486:
487:
488: return result;

Line 500: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

496: l_module_source varchar2(1000) ;
497: BEGIN
498: l_module_source := G_MODULE_SOURCE || 'getNickNameattr: ';
499:
500: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
501: then
502: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
503: end if;
504:

Line 502: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

498: l_module_source := G_MODULE_SOURCE || 'getNickNameattr: ';
499:
500: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
501: then
502: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
503: end if;
504:
505:
506: if (plugin_type is null) then plugin_type:=pluginType; end if;

Line 516: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

512: fnd_ldap_util.c_unbind(ldap,dummy);
513: if (result is null) then result:='uid'; end if;
514: end if;
515:
516: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
517: then
518: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||result);
519: end if;
520:

Line 518: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||result);

514: end if;
515:
516: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
517: then
518: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||result);
519: end if;
520:
521:
522: return result;

Line 532: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

528: l_module_source varchar2(1000) ;
529: BEGIN
530: l_module_source := G_MODULE_SOURCE || 'getRDN: ';
531:
532: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
533: then
534: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
535: end if;
536:

Line 534: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

530: l_module_source := G_MODULE_SOURCE || 'getRDN: ';
531:
532: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
533: then
534: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
535: end if;
536:
537: if (plugin_type is null) then plugin_type:=pluginType; end if;
538: if (plugin_type=G_STATIC) then

Line 544: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

540: else
541: result:= getNickNameattr(username)||'='||username;
542: end if;
543:
544: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
545: then
546: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||result);
547: end if;
548:

Line 546: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||result);

542: end if;
543:
544: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
545: then
546: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||result);
547: end if;
548:
549:
550: return result;

Line 562: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

558: l_module_source varchar2(1000) ;
559: BEGIN
560: l_module_source := G_MODULE_SOURCE || 'getSearchBase: ';
561:
562: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
563: then
564: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
565: end if;
566:

Line 564: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

560: l_module_source := G_MODULE_SOURCE || 'getSearchBase: ';
561:
562: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
563: then
564: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
565: end if;
566:
567: if (plugin_type is null) then plugin_type:=pluginType; end if;
568: if (plugin_type=G_STATIC) then

Line 576: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

572: result:= getAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext,'||getRealmDN(username),'orclcommonusersearchbase');
573: fnd_ldap_util.c_unbind(ldap,dummy);
574: end if;
575:
576: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
577: then
578: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||result);
579: end if;
580:

Line 578: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||result);

574: end if;
575:
576: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
577: then
578: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||result);
579: end if;
580:
581:
582: return result;

Line 591: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

587: l_module_source varchar2(1000) ;
588: BEGIN
589: l_module_source := G_MODULE_SOURCE || 'getSearchFilter: ';
590:
591: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
592: then
593: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
594: end if;
595:

Line 593: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

589: l_module_source := G_MODULE_SOURCE || 'getSearchFilter: ';
590:
591: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
592: then
593: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
594: end if;
595:
596: if (plugin_type is null) then plugin_type:=pluginType; end if;
597: if (plugin_type=G_STATIC) then

Line 603: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

599: else
600: result:=getRDN(username);
601: end if;
602:
603: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
604: then
605: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||result);
606: end if;
607:

Line 605: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||result);

601: end if;
602:
603: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
604: then
605: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||result);
606: end if;
607:
608:
609: return result;

Line 623: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

619: l_module_source varchar2(1000) ;
620: BEGIN
621: l_module_source := G_MODULE_SOURCE || 'getNickNameAttributeFromRealm: ';
622:
623: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
624: then
625: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
626: end if;
627:

Line 625: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

621: l_module_source := G_MODULE_SOURCE || 'getNickNameAttributeFromRealm: ';
622:
623: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
624: then
625: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
626: end if;
627:
628: ldap := fnd_ldap_util.c_get_oid_session(dummy);
629: result:= getAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext,'||realmDn,'orclcommonnicknameattribute');

Line 633: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

629: result:= getAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext,'||realmDn,'orclcommonnicknameattribute');
630: fnd_ldap_util.c_unbind(ldap,dummy);
631: if (result is null) then result:='uid'; end if;
632: return result;
633: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
634: then
635: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||result);
636: end if;
637:

Line 635: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||result);

631: if (result is null) then result:='uid'; end if;
632: return result;
633: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
634: then
635: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||result);
636: end if;
637:
638:
639: return result;

Line 651: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

647: l_module_source varchar2(1000) ;
648: BEGIN
649: l_module_source := G_MODULE_SOURCE || 'getUsernameFromEntry: ';
650:
651: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
652: then
653: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
654: end if;
655:

Line 653: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

649: l_module_source := G_MODULE_SOURCE || 'getUsernameFromEntry: ';
650:
651: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
652: then
653: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
654: end if;
655:
656: if (attr_list is not null AND attr_list.count > 0)
657: then

Line 663: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

659: loop
660:
661: if(upper(attr_list(j).attr_name) = 'ORCLGUID') then
662: result:= get_username_from_guid(attr_list(j).attr_value);
663: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
664: then
665: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||result);
666: end if;
667:

Line 665: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||result);

661: if(upper(attr_list(j).attr_name) = 'ORCLGUID') then
662: result:= get_username_from_guid(attr_list(j).attr_value);
663: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
664: then
665: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||result);
666: end if;
667:
668: return result;
669: end if;

Line 672: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

668: return result;
669: end if;
670: end loop;
671: end if;
672: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
673: then
674: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END -> raise NO_DATA_FOUND');
675: end if;
676: raise no_data_found;

Line 674: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END -> raise NO_DATA_FOUND');

670: end loop;
671: end if;
672: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
673: then
674: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END -> raise NO_DATA_FOUND');
675: end if;
676: raise no_data_found;
677: end getUsernameFromEntry;
678:

Line 691: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

687: l_module_source varchar2(1000) ;
688: BEGIN
689: l_module_source := G_MODULE_SOURCE || 'get_entry_dn: ';
690:
691: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
692: then
693: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
694: end if;
695:

Line 693: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

689: l_module_source := G_MODULE_SOURCE || 'get_entry_dn: ';
690:
691: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
692: then
693: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
694: end if;
695:
696: l_attrs(0) := 'dn'; -- NO_ATTRS
697: result := dbms_ldap.search_s(ld => ldap

Line 706: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

702: , attronly => 0
703: , res => l_message);
704: l_entry := dbms_ldap.first_entry(ldap, l_message);
705: entry_dn := dbms_ldap.get_dn(ldap,l_entry);
706: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
707: then
708: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||entry_dn);
709: end if;
710:

Line 708: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||entry_dn);

704: l_entry := dbms_ldap.first_entry(ldap, l_message);
705: entry_dn := dbms_ldap.get_dn(ldap,l_entry);
706: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
707: then
708: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||entry_dn);
709: end if;
710:
711: return entry_dn;
712:

Line 730: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

726: l_module_source varchar2(1000) ;
727: BEGIN
728: l_module_source := G_MODULE_SOURCE || 'get_realm_from_user_dn: ';
729:
730: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
731: then
732: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
733: end if;
734: cn_list := dbms_ldap.explode_dn(user_dn,0);

Line 732: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

728: l_module_source := G_MODULE_SOURCE || 'get_realm_from_user_dn: ';
729:
730: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
731: then
732: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
733: end if;
734: cn_list := dbms_ldap.explode_dn(user_dn,0);
735: len := cn_list.count;
736: i:= 0;

Line 748: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

744: j:=j+1;
745: end loop;
746: g := getAttribute(ldap,dn,'orclguid','objectclass=orclSubscriber');
747: if (g is not null) then
748: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
749: then
750: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||dn);
751: end if;
752: return dn;

Line 750: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||dn);

746: g := getAttribute(ldap,dn,'orclguid','objectclass=orclSubscriber');
747: if (g is not null) then
748: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
749: then
750: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||dn);
751: end if;
752: return dn;
753: end if;
754: i:=i+1;

Line 756: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

752: return dn;
753: end if;
754: i:=i+1;
755: end loop;
756: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
757: then
758: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END NULL!');
759: end if;
760: return null;

Line 758: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END NULL!');

754: i:=i+1;
755: end loop;
756: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
757: then
758: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END NULL!');
759: end if;
760: return null;
761: end get_realm_from_user_dn;
762:

Line 777: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

773: l_module_source varchar2(1000) ;
774: BEGIN
775: l_module_source := G_MODULE_SOURCE || 'get_username_from_guid: ';
776:
777: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
778: then
779: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
780: end if;
781:

Line 779: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

775: l_module_source := G_MODULE_SOURCE || 'get_username_from_guid: ';
776:
777: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
778: then
779: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
780: end if;
781:
782: ldap := fnd_ldap_util.c_get_oid_session(dummy);
783:

Line 794: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

790: user_name := getAttribute(ldap,user_dn,nickNameAttr);
791: if user_dn is null then raise NO_DATA_FOUND ; end if;
792: fnd_ldap_util.c_unbind(ldap,dummy);
793:
794: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
795: then
796: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||user_name);
797: end if;
798:

Line 796: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||user_name);

792: fnd_ldap_util.c_unbind(ldap,dummy);
793:
794: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
795: then
796: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||user_name);
797: end if;
798:
799: return user_name;
800: EXCEPTION when NO_DATA_FOUND THEN

Line 802: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

798:
799: return user_name;
800: EXCEPTION when NO_DATA_FOUND THEN
801: fnd_ldap_util.c_unbind(ldap,dummy);
802: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
803: then
804: fnd_log.string(fnd_log.LEVEL_EXCEPTION, l_module_source, ' Not found guid='||p_user_guid);
805: end if;
806: raise;

Line 804: fnd_log.string(fnd_log.LEVEL_EXCEPTION, l_module_source, ' Not found guid='||p_user_guid);

800: EXCEPTION when NO_DATA_FOUND THEN
801: fnd_ldap_util.c_unbind(ldap,dummy);
802: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
803: then
804: fnd_log.string(fnd_log.LEVEL_EXCEPTION, l_module_source, ' Not found guid='||p_user_guid);
805: end if;
806: raise;
807: end get_username_from_guid;
808:

Line 820: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

816: l_module_source varchar2(1000) ;
817: BEGIN
818: l_module_source := G_MODULE_SOURCE || 'get_default_realm: ';
819:
820: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
821: then
822: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
823: end if;
824:

Line 822: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

818: l_module_source := G_MODULE_SOURCE || 'get_default_realm: ';
819:
820: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
821: then
822: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
823: end if;
824:
825: if (plugin_type is null) then plugin_type:=pluginType; end if;
826: if (plugin_type=G_STATIC) then

Line 835: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

831: ldap := fnd_ldap_util.c_get_oid_session(dummy);
832: result := getAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext','orcldefaultsubscriber');
833: fnd_ldap_util.c_unbind(ldap,dummy);
834: end if;
835: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
836: then
837: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||result);
838: end if;
839: return result;

Line 837: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||result);

833: fnd_ldap_util.c_unbind(ldap,dummy);
834: end if;
835: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
836: then
837: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||result);
838: end if;
839: return result;
840: END get_default_realm;
841:

Line 852: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

848: l_module_source varchar2(1000) ;
849: BEGIN
850: l_module_source := G_MODULE_SOURCE || 'get_realm_dn: ';
851:
852: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
853: then
854: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
855: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
856: then

Line 854: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

850: l_module_source := G_MODULE_SOURCE || 'get_realm_dn: ';
851:
852: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
853: then
854: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
855: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
856: then
857: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'guid:'||p_user_guid);
858: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'username:'||p_user_name);

Line 855: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

851:
852: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
853: then
854: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
855: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
856: then
857: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'guid:'||p_user_guid);
858: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'username:'||p_user_name);
859: end if;

Line 857: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'guid:'||p_user_guid);

853: then
854: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
855: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
856: then
857: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'guid:'||p_user_guid);
858: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'username:'||p_user_name);
859: end if;
860: end if;
861:

Line 858: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'username:'||p_user_name);

854: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
855: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
856: then
857: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'guid:'||p_user_guid);
858: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'username:'||p_user_name);
859: end if;
860: end if;
861:
862: ldap := fnd_ldap_util.c_get_oid_session(flag);

Line 866: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

862: ldap := fnd_ldap_util.c_get_oid_session(flag);
863: result := null;
864: if (p_user_guid is not null) then
865: result:=get_realm_from_user_dn(ldap,get_entry_dn(ldap,p_user_guid));
866: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
867: then
868: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Using guid, realm:'||result);
869: end if;
870: end if;

Line 868: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Using guid, realm:'||result);

864: if (p_user_guid is not null) then
865: result:=get_realm_from_user_dn(ldap,get_entry_dn(ldap,p_user_guid));
866: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
867: then
868: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Using guid, realm:'||result);
869: end if;
870: end if;
871: if (result is null and p_user_name is not null) then
872: result:= getRealmDN(p_user_name);

Line 873: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

869: end if;
870: end if;
871: if (result is null and p_user_name is not null) then
872: result:= getRealmDN(p_user_name);
873: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
874: then
875: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Using username, realm:'||result);
876: end if;
877: end if;

Line 875: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Using username, realm:'||result);

871: if (result is null and p_user_name is not null) then
872: result:= getRealmDN(p_user_name);
873: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
874: then
875: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Using username, realm:'||result);
876: end if;
877: end if;
878: if (result is null) then
879: result := get_default_realm;

Line 880: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

876: end if;
877: end if;
878: if (result is null) then
879: result := get_default_realm;
880: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
881: then
882: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'fallback to default realm:'||result);
883: end if;
884: end if;

Line 882: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'fallback to default realm:'||result);

878: if (result is null) then
879: result := get_default_realm;
880: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
881: then
882: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'fallback to default realm:'||result);
883: end if;
884: end if;
885: fnd_ldap_util.c_unbind(ldap,flag);
886:

Line 887: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

883: end if;
884: end if;
885: fnd_ldap_util.c_unbind(ldap,flag);
886:
887: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
888: then
889: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||result);
890: end if;
891: return result;

Line 889: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||result);

885: fnd_ldap_util.c_unbind(ldap,flag);
886:
887: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
888: then
889: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||result);
890: end if;
891: return result;
892: end get_realm_dn;
893:

Line 907: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

903: l_module_source varchar2(4000);
904: begin
905: l_module_source := G_MODULE_SOURCE || 'count_attributes: ';
906:
907: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
908: then
909: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
910: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
911: then

Line 909: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

905: l_module_source := G_MODULE_SOURCE || 'count_attributes: ';
906:
907: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
908: then
909: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
910: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
911: then
912: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'dn:'||dn);
913: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'attribute:'||attName);

Line 910: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

906:
907: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
908: then
909: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
910: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
911: then
912: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'dn:'||dn);
913: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'attribute:'||attName);
914: end if;

Line 912: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'dn:'||dn);

908: then
909: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
910: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
911: then
912: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'dn:'||dn);
913: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'attribute:'||attName);
914: end if;
915: end if;
916: l_attrs(0):= attName;

Line 913: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'attribute:'||attName);

909: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
910: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
911: then
912: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'dn:'||dn);
913: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'attribute:'||attName);
914: end if;
915: end if;
916: l_attrs(0):= attName;
917: l_result := dbms_ldap.search_s(ld => ldap

Line 926: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

922: , attronly => 0
923: , res => l_message);
924: l_entry := dbms_ldap.first_entry(ldap, l_message);
925: if (l_entry is null ) then
926: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
927: then
928: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End(not found)');
929: end if;
930: return 0;

Line 928: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End(not found)');

924: l_entry := dbms_ldap.first_entry(ldap, l_message);
925: if (l_entry is null ) then
926: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
927: then
928: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End(not found)');
929: end if;
930: return 0;
931: end if;
932: l_attrs := dbms_ldap.get_values(ldap, l_entry, attName);

Line 934: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

930: return 0;
931: end if;
932: l_attrs := dbms_ldap.get_values(ldap, l_entry, attName);
933: l_result := l_attrs.count;
934: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
935: then
936: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'result:'||l_result);
937: end if;
938: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 936: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'result:'||l_result);

932: l_attrs := dbms_ldap.get_values(ldap, l_entry, attName);
933: l_result := l_attrs.count;
934: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
935: then
936: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'result:'||l_result);
937: end if;
938: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
939: then
940: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END');

Line 938: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

934: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
935: then
936: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'result:'||l_result);
937: end if;
938: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
939: then
940: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END');
941: end if;
942: return l_result;

Line 940: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END');

936: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'result:'||l_result);
937: end if;
938: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
939: then
940: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END');
941: end if;
942: return l_result;
943:
944: EXCEPTION when others then

Line 945: if (fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

941: end if;
942: return l_result;
943:
944: EXCEPTION when others then
945: if (fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
946: then
947: fnd_log.string(fnd_log.LEVEL_UNEXPECTED , l_module_source, 'Error '||sqlerrm);
948: end if;
949: raise;

Line 947: fnd_log.string(fnd_log.LEVEL_UNEXPECTED , l_module_source, 'Error '||sqlerrm);

943:
944: EXCEPTION when others then
945: if (fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
946: then
947: fnd_log.string(fnd_log.LEVEL_UNEXPECTED , l_module_source, 'Error '||sqlerrm);
948: end if;
949: raise;
950: end count_attributes;
951: