eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_LDAP_UTIL dependencies on FND_LOG

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

44: -- change it to FAILURE if open_ssl fails, else let the simple_bind_s
45: -- go through
46: l_retval := dbms_ldap.SUCCESS;
47:
48: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
49: then
50: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
51: end if;
52:

Line 50: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');

46: l_retval := dbms_ldap.SUCCESS;
47:
48: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
49: then
50: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
51: end if;
52:
53: dbms_ldap.use_exception := TRUE;
54:

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

62:
63: l_session := DBMS_LDAP.init(l_host, l_port);
64:
65: -- Elan, 04/27/2004, Not disclosing the password - gets saved to the database
66: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
67: then
68: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
69: , 'l_host = ' || l_host || ', l_port = ' || l_port ||
70: ', l_ldap_auth = ' || l_ldap_auth || ', l_db_wlt_url = ' ||

Line 68: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source

64:
65: -- Elan, 04/27/2004, Not disclosing the password - gets saved to the database
66: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
67: then
68: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
69: , 'l_host = ' || l_host || ', l_port = ' || l_port ||
70: ', l_ldap_auth = ' || l_ldap_auth || ', l_db_wlt_url = ' ||
71: l_db_wlt_url ||
72: ', l_user = ' || l_user || ', l_pwd = ****');

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

87: fnd_message.set_name ('FND', 'FND_SSO_SSL_ERROR');
88: raise_application_error(-20002, 'FND_SSO_SSL_ERROR');
89: end if;
90:
91: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
92: then
93: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');
94: end if;
95:

Line 93: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');

89: end if;
90:
91: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
92: then
93: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');
94: end if;
95:
96: return l_session;
97:

Line 101: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

97:
98: exception
99: when dbms_ldap.invalid_session then
100: fnd_message.set_name ('FND', 'FND_SSO_INV_SESSION');
101: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
102: then
103: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
104: end if;
105: raise;

Line 103: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);

99: when dbms_ldap.invalid_session then
100: fnd_message.set_name ('FND', 'FND_SSO_INV_SESSION');
101: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
102: then
103: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
104: end if;
105: raise;
106: when dbms_ldap.invalid_ssl_wallet_loc then
107: fnd_message.set_name ('FND', 'FND_SSO_WALLET_LOC');

Line 108: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

104: end if;
105: raise;
106: when dbms_ldap.invalid_ssl_wallet_loc then
107: fnd_message.set_name ('FND', 'FND_SSO_WALLET_LOC');
108: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
109: then
110: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
111: end if;
112: raise;

Line 110: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);

106: when dbms_ldap.invalid_ssl_wallet_loc then
107: fnd_message.set_name ('FND', 'FND_SSO_WALLET_LOC');
108: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
109: then
110: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
111: end if;
112: raise;
113: when dbms_ldap.invalid_ssl_wallet_passwd then
114: fnd_message.set_name ('FND', 'FND_SSO_WALLET_PWD');

Line 115: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

111: end if;
112: raise;
113: when dbms_ldap.invalid_ssl_wallet_passwd then
114: fnd_message.set_name ('FND', 'FND_SSO_WALLET_PWD');
115: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
116: then
117: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
118: end if;
119: raise;

Line 117: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);

113: when dbms_ldap.invalid_ssl_wallet_passwd then
114: fnd_message.set_name ('FND', 'FND_SSO_WALLET_PWD');
115: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
116: then
117: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
118: end if;
119: raise;
120: when dbms_ldap.invalid_ssl_auth_mode then
121: fnd_message.set_name ('FND', 'FND_SSO_INV_AUTH_MODE');

Line 122: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

118: end if;
119: raise;
120: when dbms_ldap.invalid_ssl_auth_mode then
121: fnd_message.set_name ('FND', 'FND_SSO_INV_AUTH_MODE');
122: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
123: then
124: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
125: end if;
126: raise;

Line 124: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);

120: when dbms_ldap.invalid_ssl_auth_mode then
121: fnd_message.set_name ('FND', 'FND_SSO_INV_AUTH_MODE');
122: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
123: then
124: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
125: end if;
126: raise;
127: when others then
128: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 128: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

124: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
125: end if;
126: raise;
127: when others then
128: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
129: then
130: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
131: end if;
132: raise;

Line 130: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);

126: raise;
127: when others then
128: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
129: then
130: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
131: end if;
132: raise;
133:
134: end get_oid_session;

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

141: begin
142:
143: l_module_source := G_MODULE_SOURCE || 'unbind: ';
144:
145: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
146: then
147: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
148: end if;
149:

Line 147: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');

143: l_module_source := G_MODULE_SOURCE || 'unbind: ';
144:
145: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
146: then
147: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
148: end if;
149:
150: retval := dbms_ldap.unbind_s(p_session);
151:

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

148: end if;
149:
150: retval := dbms_ldap.unbind_s(p_session);
151:
152: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
153: then
154: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');
155: end if;
156:

Line 154: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');

150: retval := dbms_ldap.unbind_s(p_session);
151:
152: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
153: then
154: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');
155: end if;
156:
157: return retval;
158:

Line 161: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

157: return retval;
158:
159: exception
160: when others then
161: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
162: then
163: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
164: end if;
165: raise;

Line 163: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);

159: exception
160: when others then
161: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
162: then
163: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
164: end if;
165: raise;
166:
167: end unbind;

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

177: begin
178:
179: l_module_source := G_MODULE_SOURCE || 'removeExtraQuotes: ';
180:
181: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
182: then
183: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
184: end if;
185:

Line 183: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');

179: l_module_source := G_MODULE_SOURCE || 'removeExtraQuotes: ';
180:
181: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
182: then
183: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
184: end if;
185:
186: strLength := length(p_app);
187:

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

189: quotesIndex := instr(p_app, '"');
190: p_app := Substr(p_app, 0, quotesIndex-1) || Substr(p_app, quotesIndex+1, strLength);
191: end loop;
192:
193: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
194: then
195: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');
196: end if;
197:

Line 195: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');

191: end loop;
192:
193: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
194: then
195: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');
196: end if;
197:
198: exception
199: when others then

Line 200: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

196: end if;
197:
198: exception
199: when others then
200: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
201: then
202: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
203: end if;
204: raise;

Line 202: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);

198: exception
199: when others then
200: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
201: then
202: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
203: end if;
204: raise;
205:
206: end removeExtraQuotes;

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

214: begin
215:
216: l_module_source := G_MODULE_SOURCE || 'get_orclappname: ';
217:
218: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
219: then
220: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
221: end if;
222:

Line 220: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');

216: l_module_source := G_MODULE_SOURCE || 'get_orclappname: ';
217:
218: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
219: then
220: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
221: end if;
222:
223: -- Bug 5001849 use FND API instead of directly doing a select against
224: -- fnd_user_preferences

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

228: p_pref_name => 'USERNAME');
229:
230: removeExtraQuotes(orclAppName);
231:
232: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
233: then
234: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');
235: end if;
236:

Line 234: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');

230: removeExtraQuotes(orclAppName);
231:
232: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
233: then
234: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');
235: end if;
236:
237: return orclAppName;
238:

Line 241: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

237: return orclAppName;
238:
239: exception
240: when others then
241: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
242: then
243: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
244: end if;
245: raise;

Line 243: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);

239: exception
240: when others then
241: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
242: then
243: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
244: end if;
245: raise;
246:
247: end get_orclappname;

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

265: begin
266:
267: l_module_source := G_MODULE_SOURCE || 'get_dn_for_GUID: ';
268:
269: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
270: then
271: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
272: end if;
273:

Line 271: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');

267: l_module_source := G_MODULE_SOURCE || 'get_dn_for_GUID: ';
268:
269: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
270: then
271: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
272: end if;
273:
274: l_base := '';
275: l_ldap_session := get_oid_session;

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

288: else
289: l_dn := dbms_ldap.get_dn(l_ldap_session, l_entry);
290: end if;
291:
292: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
293: then
294: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'GUID::'||p_orclguid||' DN::'||l_dn);
295: end if;
296:

Line 294: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'GUID::'||p_orclguid||' DN::'||l_dn);

290: end if;
291:
292: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
293: then
294: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'GUID::'||p_orclguid||' DN::'||l_dn);
295: end if;
296:
297: result := unbind(l_ldap_session);
298:

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

299: if (l_dn is null) then
300: raise no_data_found;
301: end if;
302:
303: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
304: then
305: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');
306: end if;
307:

Line 305: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');

301: end if;
302:
303: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
304: then
305: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');
306: end if;
307:
308: return l_dn;
309:

Line 313: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

309:
310: exception
311: when no_data_found then
312: fnd_message.set_name ('FND', 'FND_SSO_USER_NOT_FOUND');
313: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
314: then
315: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, 'No user found with the given GUID');
316: end if;
317: raise;

Line 315: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, 'No user found with the given GUID');

311: when no_data_found then
312: fnd_message.set_name ('FND', 'FND_SSO_USER_NOT_FOUND');
313: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
314: then
315: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, 'No user found with the given GUID');
316: end if;
317: raise;
318: when others then
319: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 319: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

315: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, 'No user found with the given GUID');
316: end if;
317: raise;
318: when others then
319: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
320: then
321: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
322: end if;
323: raise;

Line 321: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);

317: raise;
318: when others then
319: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
320: then
321: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
322: end if;
323: raise;
324:
325: end get_dn_for_GUID;

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

339: begin
340:
341: l_module_source := G_MODULE_SOURCE || 'get_dn_for_GUID: ';
342:
343: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
344: then
345: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
346: end if;
347:

Line 345: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');

341: l_module_source := G_MODULE_SOURCE || 'get_dn_for_GUID: ';
342:
343: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
344: then
345: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
346: end if;
347:
348: l_base := '';
349:

Line 365: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then

361: else
362: l_dn := dbms_ldap.get_dn(p_ldap_session, l_entry);
363: end if;
364:
365: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
366: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'GUID::'||p_orclguid||' DN::'||l_dn);
367: end if;
368:
369: if (l_dn is null) then

Line 366: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'GUID::'||p_orclguid||' DN::'||l_dn);

362: l_dn := dbms_ldap.get_dn(p_ldap_session, l_entry);
363: end if;
364:
365: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
366: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'GUID::'||p_orclguid||' DN::'||l_dn);
367: end if;
368:
369: if (l_dn is null) then
370: raise no_data_found;

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

369: if (l_dn is null) then
370: raise no_data_found;
371: end if;
372:
373: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
374: then
375: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');
376: end if;
377:

Line 375: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');

371: end if;
372:
373: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
374: then
375: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');
376: end if;
377:
378: return l_dn;
379:

Line 383: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

379:
380: exception
381: when no_data_found then
382: fnd_message.set_name ('FND', 'FND_SSO_USER_NOT_FOUND');
383: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
384: then
385: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, 'No user found with the given GUID');
386: end if;
387: raise;

Line 385: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, 'No user found with the given GUID');

381: when no_data_found then
382: fnd_message.set_name ('FND', 'FND_SSO_USER_NOT_FOUND');
383: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
384: then
385: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, 'No user found with the given GUID');
386: end if;
387: raise;
388: when others then
389: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 389: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

385: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, 'No user found with the given GUID');
386: end if;
387: raise;
388: when others then
389: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
390: then
391: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
392: end if;
393: raise;

Line 391: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);

387: raise;
388: when others then
389: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
390: then
391: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
392: end if;
393: raise;
394:
395: end get_dn_for_GUID;

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

425: l_module_source varchar2(256);
426: begin
427: l_module_source := G_MODULE_SOURCE || 'get_guid_for_dn:';
428:
429: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
430: then
431: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
432: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'DN='||p_dn);
433: end if;

Line 431: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');

427: l_module_source := G_MODULE_SOURCE || 'get_guid_for_dn:';
428:
429: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
430: then
431: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
432: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'DN='||p_dn);
433: end if;
434:
435: l_attrs(0) := 'orclGuid';

Line 432: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'DN='||p_dn);

428:
429: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
430: then
431: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
432: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'DN='||p_dn);
433: end if;
434:
435: l_attrs(0) := 'orclGuid';
436: begin

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

446: -- asume that DN not found
447: -- is not accurate, but better that nothing
448: err := SQLERRM;
449: if (instr(err,'No such object')>1) then
450: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
451: then
452: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
453: ' DN not found : raise NO_DATA_FOUND');
454: end if;

Line 452: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,

448: err := SQLERRM;
449: if (instr(err,'No such object')>1) then
450: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
451: then
452: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
453: ' DN not found : raise NO_DATA_FOUND');
454: end if;
455: raise NO_DATA_FOUND;
456: else

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

453: ' DN not found : raise NO_DATA_FOUND');
454: end if;
455: raise NO_DATA_FOUND;
456: else
457: if (fnd_log.LEVEL_EXCEPTION>= fnd_log.G_CURRENT_RUNTIME_LEVEL)
458: then
459: fnd_log.string(fnd_log.LEVEL_EXCEPTION, l_module_source, SQLERRM);
460: fnd_log.string(fnd_log.LEVEL_EXCEPTION, l_module_source, ' from dbms_ldap.search_s, dn='||p_dn);
461: end if;

Line 459: fnd_log.string(fnd_log.LEVEL_EXCEPTION, l_module_source, SQLERRM);

455: raise NO_DATA_FOUND;
456: else
457: if (fnd_log.LEVEL_EXCEPTION>= fnd_log.G_CURRENT_RUNTIME_LEVEL)
458: then
459: fnd_log.string(fnd_log.LEVEL_EXCEPTION, l_module_source, SQLERRM);
460: fnd_log.string(fnd_log.LEVEL_EXCEPTION, l_module_source, ' from dbms_ldap.search_s, dn='||p_dn);
461: end if;
462: raise;
463: end if;

Line 460: fnd_log.string(fnd_log.LEVEL_EXCEPTION, l_module_source, ' from dbms_ldap.search_s, dn='||p_dn);

456: else
457: if (fnd_log.LEVEL_EXCEPTION>= fnd_log.G_CURRENT_RUNTIME_LEVEL)
458: then
459: fnd_log.string(fnd_log.LEVEL_EXCEPTION, l_module_source, SQLERRM);
460: fnd_log.string(fnd_log.LEVEL_EXCEPTION, l_module_source, ' from dbms_ldap.search_s, dn='||p_dn);
461: end if;
462: raise;
463: end if;
464: end;

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

472: l_guid := null;
473: end;
474:
475:
476: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
477: then
478: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, ' END : guid='||l_guid);
479: end if;
480: return l_guid;

Line 478: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, ' END : guid='||l_guid);

474:
475:
476: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
477: then
478: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, ' END : guid='||l_guid);
479: end if;
480: return l_guid;
481:
482: exception

Line 484: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

480: return l_guid;
481:
482: exception
483: when others then
484: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
485: then
486: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, ' for DN='||p_dn);
487: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
488: end if;

Line 486: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, ' for DN='||p_dn);

482: exception
483: when others then
484: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
485: then
486: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, ' for DN='||p_dn);
487: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
488: end if;
489: raise;
490: end get_guid_for_dn;

Line 487: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);

483: when others then
484: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
485: then
486: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, ' for DN='||p_dn);
487: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
488: end if;
489: raise;
490: end get_guid_for_dn;
491: --

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

504: begin
505:
506: l_module_source := G_MODULE_SOURCE || 'get_default_realm ';
507:
508: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
509: then
510: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
511: end if;
512: l_result := FND_OID_PLUG.getRealmDN(username);

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

506: l_module_source := G_MODULE_SOURCE || 'get_default_realm ';
507:
508: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
509: then
510: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
511: end if;
512: l_result := FND_OID_PLUG.getRealmDN(username);
513: if (fnd_log.LEVEL_STATEMENT>= fnd_log.G_CURRENT_RUNTIME_LEVEL)
514: then

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

509: then
510: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
511: end if;
512: l_result := FND_OID_PLUG.getRealmDN(username);
513: if (fnd_log.LEVEL_STATEMENT>= fnd_log.G_CURRENT_RUNTIME_LEVEL)
514: then
515: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'realm: '||l_result);
516: end if;
517:

Line 515: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'realm: '||l_result);

511: end if;
512: l_result := FND_OID_PLUG.getRealmDN(username);
513: if (fnd_log.LEVEL_STATEMENT>= fnd_log.G_CURRENT_RUNTIME_LEVEL)
514: then
515: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'realm: '||l_result);
516: end if;
517:
518: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
519: then

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

514: then
515: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'realm: '||l_result);
516: end if;
517:
518: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
519: then
520: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
521: end if;
522:

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

516: end if;
517:
518: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
519: then
520: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
521: end if;
522:
523: return l_result;
524:

Line 527: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

523: return l_result;
524:
525: exception
526: when others then
527: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
528: then
529: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
530: end if;
531: raise;

Line 529: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);

525: exception
526: when others then
527: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
528: then
529: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
530: end if;
531: raise;
532:
533: end get_default_realm;

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

551: begin
552:
553: l_module_source := G_MODULE_SOURCE || 'get_orclcommonnicknameattr ';
554:
555: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
556: then
557: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
558: end if;
559: l_base := fnd_oid_plug.getNickNameattr(username);

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

553: l_module_source := G_MODULE_SOURCE || 'get_orclcommonnicknameattr ';
554:
555: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
556: then
557: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
558: end if;
559: l_base := fnd_oid_plug.getNickNameattr(username);
560: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
561: then

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

556: then
557: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
558: end if;
559: l_base := fnd_oid_plug.getNickNameattr(username);
560: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
561: then
562: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END:'||username||' '||l_base);
563: end if;
564: return l_base;

Line 562: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END:'||username||' '||l_base);

558: end if;
559: l_base := fnd_oid_plug.getNickNameattr(username);
560: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
561: then
562: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END:'||username||' '||l_base);
563: end if;
564: return l_base;
565: exception
566: when others then

Line 567: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

563: end if;
564: return l_base;
565: exception
566: when others then
567: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
568: then
569: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
570: end if;
571: raise;

Line 569: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);

565: exception
566: when others then
567: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
568: then
569: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
570: end if;
571: raise;
572: end get_orclcommonnicknameattr;
573: --

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

584:
585: begin
586: l_module_source := G_MODULE_SOURCE || 'proxy_as_user: ';
587:
588: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
589: then
590: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
591: end if;
592:

Line 590: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');

586: l_module_source := G_MODULE_SOURCE || 'proxy_as_user: ';
587:
588: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
589: then
590: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
591: end if;
592:
593: x_ldap_session := fnd_ldap_util.get_oid_session;
594: l_dn := get_dn_for_guid(p_orclguid => p_orclguid, p_ldap_session => x_ldap_session);

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

597:
598: l_retval := dbms_ldap.simple_bind_s(x_ldap_session, l_dn, null);
599:
600: if (l_retval = dbms_ldap.SUCCESS) then
601: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
602: then
603: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Proxied Successfully for User DN:' ||
604: l_dn);
605: end if;

Line 603: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Proxied Successfully for User DN:' ||

599:
600: if (l_retval = dbms_ldap.SUCCESS) then
601: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
602: then
603: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Proxied Successfully for User DN:' ||
604: l_dn);
605: end if;
606: else
607: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

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

603: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Proxied Successfully for User DN:' ||
604: l_dn);
605: end if;
606: else
607: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
608: then
609: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Proxy Failed for User DN: ' ||
610: l_dn);
611: end if;

Line 609: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Proxy Failed for User DN: ' ||

605: end if;
606: else
607: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
608: then
609: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Proxy Failed for User DN: ' ||
610: l_dn);
611: end if;
612: raise proxy_failed_exp;
613: end if;

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

611: end if;
612: raise proxy_failed_exp;
613: end if;
614:
615: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
616: then
617: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');
618: end if;
619:

Line 617: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');

613: end if;
614:
615: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
616: then
617: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');
618: end if;
619:
620: --return l_session;
621:

Line 625: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

621:
622: exception
623: when dbms_ldap.invalid_session then
624: fnd_message.set_name ('FND', 'FND_SSO_INV_SESSION');
625: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
626: then
627: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
628: end if;
629: raise;

Line 627: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);

623: when dbms_ldap.invalid_session then
624: fnd_message.set_name ('FND', 'FND_SSO_INV_SESSION');
625: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
626: then
627: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
628: end if;
629: raise;
630: when others then
631: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 631: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

627: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
628: end if;
629: raise;
630: when others then
631: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
632: then
633: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
634: end if;
635: raise;

Line 633: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);

629: raise;
630: when others then
631: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
632: then
633: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
634: end if;
635: raise;
636:
637: end proxy_as_user;

Line 670: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

666: l_message dbms_ldap.message := NULL;
667: BEGIN
668: l_module_source := g_module_source || 'get_Attribute ';
669:
670: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
671: fnd_log.string(fnd_log.level_statement, l_module_source, 'Begin ');
672: fnd_log.string(fnd_log.level_statement, l_module_source, ' dn:' || p_dn || ' attr:' || p_attr_name);
673: END IF;
674:

Line 671: fnd_log.string(fnd_log.level_statement, l_module_source, 'Begin ');

667: BEGIN
668: l_module_source := g_module_source || 'get_Attribute ';
669:
670: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
671: fnd_log.string(fnd_log.level_statement, l_module_source, 'Begin ');
672: fnd_log.string(fnd_log.level_statement, l_module_source, ' dn:' || p_dn || ' attr:' || p_attr_name);
673: END IF;
674:
675: l_attrs(0) := p_attr_name;

Line 672: fnd_log.string(fnd_log.level_statement, l_module_source, ' dn:' || p_dn || ' attr:' || p_attr_name);

668: l_module_source := g_module_source || 'get_Attribute ';
669:
670: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
671: fnd_log.string(fnd_log.level_statement, l_module_source, 'Begin ');
672: fnd_log.string(fnd_log.level_statement, l_module_source, ' dn:' || p_dn || ' attr:' || p_attr_name);
673: END IF;
674:
675: l_attrs(0) := p_attr_name;
676: result := dbms_ldap.search_s(ld => p_ldap_session, base => p_dn,

Line 684: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

680: l_attrs := dbms_ldap.get_values(p_ldap_session, l_entry, p_attr_name);
681: BEGIN
682: l_result := l_attrs(0);
683: EXCEPTION WHEN NO_DATA_FOUND THEN
684: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
685: fnd_log.string(fnd_log.level_statement, l_module_source, 'attribute '||p_attr_name||' not present at '||p_dn);
686: END IF;
687: l_result := null; -- DN found, but does not contain the attribute
688: END;

Line 685: fnd_log.string(fnd_log.level_statement, l_module_source, 'attribute '||p_attr_name||' not present at '||p_dn);

681: BEGIN
682: l_result := l_attrs(0);
683: EXCEPTION WHEN NO_DATA_FOUND THEN
684: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
685: fnd_log.string(fnd_log.level_statement, l_module_source, 'attribute '||p_attr_name||' not present at '||p_dn);
686: END IF;
687: l_result := null; -- DN found, but does not contain the attribute
688: END;
689:

Line 690: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

686: END IF;
687: l_result := null; -- DN found, but does not contain the attribute
688: END;
689:
690: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
691: fnd_log.string(fnd_log.level_statement, l_module_source, 'END-> ' || l_result);
692: END IF;
693: return l_result;
694:

Line 691: fnd_log.string(fnd_log.level_statement, l_module_source, 'END-> ' || l_result);

687: l_result := null; -- DN found, but does not contain the attribute
688: END;
689:
690: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
691: fnd_log.string(fnd_log.level_statement, l_module_source, 'END-> ' || l_result);
692: END IF;
693: return l_result;
694:
695: EXCEPTION

Line 699: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

695: EXCEPTION
696: WHEN dbms_ldap.general_error THEN
697: BEGIN
698:
699: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
700: fnd_log.string(fnd_log.level_statement, l_module_source, 'END-> not found '||sqlerrm);
701: END IF;
702: return null; -- DN NOT FOUND
703: END;

Line 700: fnd_log.string(fnd_log.level_statement, l_module_source, 'END-> not found '||sqlerrm);

696: WHEN dbms_ldap.general_error THEN
697: BEGIN
698:
699: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
700: fnd_log.string(fnd_log.level_statement, l_module_source, 'END-> not found '||sqlerrm);
701: END IF;
702: return null; -- DN NOT FOUND
703: END;
704: WHEN OTHERS THEN

Line 706: IF(fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN

702: return null; -- DN NOT FOUND
703: END;
704: WHEN OTHERS THEN
705:
706: IF(fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
707: fnd_log.string(fnd_log.level_error, l_module_source, sqlerrm);
708:
709: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
710: fnd_log.string(fnd_log.level_statement, l_module_source, 'END-> RAISE');

Line 707: fnd_log.string(fnd_log.level_error, l_module_source, sqlerrm);

703: END;
704: WHEN OTHERS THEN
705:
706: IF(fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
707: fnd_log.string(fnd_log.level_error, l_module_source, sqlerrm);
708:
709: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
710: fnd_log.string(fnd_log.level_statement, l_module_source, 'END-> RAISE');
711: END IF;

Line 709: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

705:
706: IF(fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
707: fnd_log.string(fnd_log.level_error, l_module_source, sqlerrm);
708:
709: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
710: fnd_log.string(fnd_log.level_statement, l_module_source, 'END-> RAISE');
711: END IF;
712:
713: END IF;

Line 710: fnd_log.string(fnd_log.level_statement, l_module_source, 'END-> RAISE');

706: IF(fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
707: fnd_log.string(fnd_log.level_error, l_module_source, sqlerrm);
708:
709: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
710: fnd_log.string(fnd_log.level_statement, l_module_source, 'END-> RAISE');
711: END IF;
712:
713: END IF;
714:

Line 751: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

747:
748: BEGIN
749: l_module_source := g_module_source || 'get_DAS_BASE_URL ';
750:
751: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
752: fnd_log.string(fnd_log.level_statement, l_module_source, 'Begin ');
753: END IF;
754:
755: IF(g_das_base_url is not NULL) THEN

Line 752: fnd_log.string(fnd_log.level_statement, l_module_source, 'Begin ');

748: BEGIN
749: l_module_source := g_module_source || 'get_DAS_BASE_URL ';
750:
751: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
752: fnd_log.string(fnd_log.level_statement, l_module_source, 'Begin ');
753: END IF;
754:
755: IF(g_das_base_url is not NULL) THEN
756:

Line 757: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

753: END IF;
754:
755: IF(g_das_base_url is not NULL) THEN
756:
757: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
758: fnd_log.string(fnd_log.level_statement, l_module_source, 'END (cached)-> ' || g_das_base_url);
759: END IF;
760:
761: RETURN g_das_base_url;

Line 758: fnd_log.string(fnd_log.level_statement, l_module_source, 'END (cached)-> ' || g_das_base_url);

754:
755: IF(g_das_base_url is not NULL) THEN
756:
757: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
758: fnd_log.string(fnd_log.level_statement, l_module_source, 'END (cached)-> ' || g_das_base_url);
759: END IF;
760:
761: RETURN g_das_base_url;
762: END IF;

Line 769: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

765: if (l_result is not null)
766: THEN
767: g_das_product_base := l_try;
768: g_das_base_url := l_result;
769: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
770: fnd_log.string(fnd_log.level_statement, l_module_source, ' DAS_BASE_DN ' || g_das_product_base);
771: fnd_log.string(fnd_log.level_statement, l_module_source, ' DAS_URL-> ' || g_das_base_url);
772: fnd_log.string(fnd_log.level_statement, l_module_source, 'END -> ' || g_das_base_url);
773: END IF;

Line 770: fnd_log.string(fnd_log.level_statement, l_module_source, ' DAS_BASE_DN ' || g_das_product_base);

766: THEN
767: g_das_product_base := l_try;
768: g_das_base_url := l_result;
769: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
770: fnd_log.string(fnd_log.level_statement, l_module_source, ' DAS_BASE_DN ' || g_das_product_base);
771: fnd_log.string(fnd_log.level_statement, l_module_source, ' DAS_URL-> ' || g_das_base_url);
772: fnd_log.string(fnd_log.level_statement, l_module_source, 'END -> ' || g_das_base_url);
773: END IF;
774:

Line 771: fnd_log.string(fnd_log.level_statement, l_module_source, ' DAS_URL-> ' || g_das_base_url);

767: g_das_product_base := l_try;
768: g_das_base_url := l_result;
769: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
770: fnd_log.string(fnd_log.level_statement, l_module_source, ' DAS_BASE_DN ' || g_das_product_base);
771: fnd_log.string(fnd_log.level_statement, l_module_source, ' DAS_URL-> ' || g_das_base_url);
772: fnd_log.string(fnd_log.level_statement, l_module_source, 'END -> ' || g_das_base_url);
773: END IF;
774:
775: return g_das_base_url;

Line 772: fnd_log.string(fnd_log.level_statement, l_module_source, 'END -> ' || g_das_base_url);

768: g_das_base_url := l_result;
769: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
770: fnd_log.string(fnd_log.level_statement, l_module_source, ' DAS_BASE_DN ' || g_das_product_base);
771: fnd_log.string(fnd_log.level_statement, l_module_source, ' DAS_URL-> ' || g_das_base_url);
772: fnd_log.string(fnd_log.level_statement, l_module_source, 'END -> ' || g_das_base_url);
773: END IF;
774:
775: return g_das_base_url;
776: END IF;

Line 783: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

779: if (l_result is not null)
780: THEN
781: g_das_product_base :=l_try;
782: g_das_base_url := l_result;
783: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
784: fnd_log.string(fnd_log.level_statement, l_module_source, ' DAS_BASE_DN ' || g_das_product_base);
785: fnd_log.string(fnd_log.level_statement, l_module_source, ' DAS_URL-> ' || g_das_base_url);
786: fnd_log.string(fnd_log.level_statement, l_module_source, 'END -> ' || g_das_base_url);
787: END IF;

Line 784: fnd_log.string(fnd_log.level_statement, l_module_source, ' DAS_BASE_DN ' || g_das_product_base);

780: THEN
781: g_das_product_base :=l_try;
782: g_das_base_url := l_result;
783: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
784: fnd_log.string(fnd_log.level_statement, l_module_source, ' DAS_BASE_DN ' || g_das_product_base);
785: fnd_log.string(fnd_log.level_statement, l_module_source, ' DAS_URL-> ' || g_das_base_url);
786: fnd_log.string(fnd_log.level_statement, l_module_source, 'END -> ' || g_das_base_url);
787: END IF;
788: return g_das_base_url;

Line 785: fnd_log.string(fnd_log.level_statement, l_module_source, ' DAS_URL-> ' || g_das_base_url);

781: g_das_product_base :=l_try;
782: g_das_base_url := l_result;
783: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
784: fnd_log.string(fnd_log.level_statement, l_module_source, ' DAS_BASE_DN ' || g_das_product_base);
785: fnd_log.string(fnd_log.level_statement, l_module_source, ' DAS_URL-> ' || g_das_base_url);
786: fnd_log.string(fnd_log.level_statement, l_module_source, 'END -> ' || g_das_base_url);
787: END IF;
788: return g_das_base_url;
789: END IF;

Line 786: fnd_log.string(fnd_log.level_statement, l_module_source, 'END -> ' || g_das_base_url);

782: g_das_base_url := l_result;
783: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
784: fnd_log.string(fnd_log.level_statement, l_module_source, ' DAS_BASE_DN ' || g_das_product_base);
785: fnd_log.string(fnd_log.level_statement, l_module_source, ' DAS_URL-> ' || g_das_base_url);
786: fnd_log.string(fnd_log.level_statement, l_module_source, 'END -> ' || g_das_base_url);
787: END IF;
788: return g_das_base_url;
789: END IF;
790: /*

Line 793: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level)

789: END IF;
790: /*
791: * Incorrect settings or something
792: */
793: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level)
794: THEN
795: fnd_log.string(fnd_log.level_statement, l_module_source, 'END-> FAILED ' );
796: END IF;
797: G_DAS_PRODUCT_BASE:=NULL;

Line 795: fnd_log.string(fnd_log.level_statement, l_module_source, 'END-> FAILED ' );

791: * Incorrect settings or something
792: */
793: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level)
794: THEN
795: fnd_log.string(fnd_log.level_statement, l_module_source, 'END-> FAILED ' );
796: END IF;
797: G_DAS_PRODUCT_BASE:=NULL;
798: G_DAS_BASE_URL := NULL;
799: return NULL;

Line 803: IF(fnd_log.level_error >= fnd_log.g_current_runtime_level)

799: return NULL;
800:
801: EXCEPTION WHEN others THEN
802:
803: IF(fnd_log.level_error >= fnd_log.g_current_runtime_level)
804: THEN
805: fnd_log.string(fnd_log.level_error, l_module_source, sqlerrm);
806: END IF;
807:

Line 805: fnd_log.string(fnd_log.level_error, l_module_source, sqlerrm);

801: EXCEPTION WHEN others THEN
802:
803: IF(fnd_log.level_error >= fnd_log.g_current_runtime_level)
804: THEN
805: fnd_log.string(fnd_log.level_error, l_module_source, sqlerrm);
806: END IF;
807:
808: fnd_message.set_name('FND', 'get_DAS_BASE_URL'); RETURN NULL;
809: END get_das_base_url;

Line 843: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

839: result pls_integer;
840: BEGIN
841: l_module_source := g_module_source || 'get_das_operationurl ';
842:
843: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
844: fnd_log.string(fnd_log.level_statement, l_module_source, 'Begin ');
845: fnd_log.string(fnd_log.level_statement, l_module_source, ' realm:' || p_realm || ' op:"' || p_operation||'"');
846: END IF;
847:

Line 844: fnd_log.string(fnd_log.level_statement, l_module_source, 'Begin ');

840: BEGIN
841: l_module_source := g_module_source || 'get_das_operationurl ';
842:
843: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
844: fnd_log.string(fnd_log.level_statement, l_module_source, 'Begin ');
845: fnd_log.string(fnd_log.level_statement, l_module_source, ' realm:' || p_realm || ' op:"' || p_operation||'"');
846: END IF;
847:
848: l_ldap_session := fnd_ldap_util.get_oid_session;

Line 845: fnd_log.string(fnd_log.level_statement, l_module_source, ' realm:' || p_realm || ' op:"' || p_operation||'"');

841: l_module_source := g_module_source || 'get_das_operationurl ';
842:
843: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
844: fnd_log.string(fnd_log.level_statement, l_module_source, 'Begin ');
845: fnd_log.string(fnd_log.level_statement, l_module_source, ' realm:' || p_realm || ' op:"' || p_operation||'"');
846: END IF;
847:
848: l_ldap_session := fnd_ldap_util.get_oid_session;
849: IF (p_realm is NOT null)

Line 854: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

850: THEN
851:
852: l_result := get_attribute(l_ldap_session, 'cn='|| p_operation||','|| g_das_relative_base||','||p_realm, 'orcldasurl' );
853: l_base := get_das_base_url(l_ldap_session,p_realm);
854: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
855:
856: fnd_log.string(fnd_log.level_statement, l_module_source, ' op_url:' || l_result);
857: fnd_log.string(fnd_log.level_statement, l_module_source, ' base:' || l_base);
858:

Line 856: fnd_log.string(fnd_log.level_statement, l_module_source, ' op_url:' || l_result);

852: l_result := get_attribute(l_ldap_session, 'cn='|| p_operation||','|| g_das_relative_base||','||p_realm, 'orcldasurl' );
853: l_base := get_das_base_url(l_ldap_session,p_realm);
854: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
855:
856: fnd_log.string(fnd_log.level_statement, l_module_source, ' op_url:' || l_result);
857: fnd_log.string(fnd_log.level_statement, l_module_source, ' base:' || l_base);
858:
859: END IF;
860: END IF;

Line 857: fnd_log.string(fnd_log.level_statement, l_module_source, ' base:' || l_base);

853: l_base := get_das_base_url(l_ldap_session,p_realm);
854: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
855:
856: fnd_log.string(fnd_log.level_statement, l_module_source, ' op_url:' || l_result);
857: fnd_log.string(fnd_log.level_statement, l_module_source, ' base:' || l_base);
858:
859: END IF;
860: END IF;
861: -- For no realm returned the default data (which is not the same

Line 865: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

861: -- For no realm returned the default data (which is not the same
862: -- as data for the default realm )
863: if (p_realm is NULL or l_result is null)
864: THEN
865: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
866: fnd_log.string(fnd_log.level_statement, l_module_source, ' get default Urls');
867: END IF;
868:
869: l_result := get_attribute(l_ldap_session, 'cn='||p_operation||','||g_das_relative_base, 'orcldasurl' );

Line 866: fnd_log.string(fnd_log.level_statement, l_module_source, ' get default Urls');

862: -- as data for the default realm )
863: if (p_realm is NULL or l_result is null)
864: THEN
865: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
866: fnd_log.string(fnd_log.level_statement, l_module_source, ' get default Urls');
867: END IF;
868:
869: l_result := get_attribute(l_ldap_session, 'cn='||p_operation||','||g_das_relative_base, 'orcldasurl' );
870: l_base := get_das_base_url(l_ldap_session,null);

Line 871: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

867: END IF;
868:
869: l_result := get_attribute(l_ldap_session, 'cn='||p_operation||','||g_das_relative_base, 'orcldasurl' );
870: l_base := get_das_base_url(l_ldap_session,null);
871: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
872: fnd_log.string(fnd_log.level_statement, l_module_source, ' op_url:' || l_result);
873: fnd_log.string(fnd_log.level_statement, l_module_source, ' base:' || l_base);
874: END IF;
875: END IF;

Line 872: fnd_log.string(fnd_log.level_statement, l_module_source, ' op_url:' || l_result);

868:
869: l_result := get_attribute(l_ldap_session, 'cn='||p_operation||','||g_das_relative_base, 'orcldasurl' );
870: l_base := get_das_base_url(l_ldap_session,null);
871: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
872: fnd_log.string(fnd_log.level_statement, l_module_source, ' op_url:' || l_result);
873: fnd_log.string(fnd_log.level_statement, l_module_source, ' base:' || l_base);
874: END IF;
875: END IF;
876:

Line 873: fnd_log.string(fnd_log.level_statement, l_module_source, ' base:' || l_base);

869: l_result := get_attribute(l_ldap_session, 'cn='||p_operation||','||g_das_relative_base, 'orcldasurl' );
870: l_base := get_das_base_url(l_ldap_session,null);
871: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
872: fnd_log.string(fnd_log.level_statement, l_module_source, ' op_url:' || l_result);
873: fnd_log.string(fnd_log.level_statement, l_module_source, ' base:' || l_base);
874: END IF;
875: END IF;
876:
877: result := fnd_ldap_util.unbind(l_ldap_session);

Line 880: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

876:
877: result := fnd_ldap_util.unbind(l_ldap_session);
878: if (l_result is null or l_base is null)
879: then
880: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
881: fnd_log.string(fnd_log.level_statement, l_module_source, 'END->NULLl:');
882: END IF;
883: return NULL;
884: end if;

Line 881: fnd_log.string(fnd_log.level_statement, l_module_source, 'END->NULLl:');

877: result := fnd_ldap_util.unbind(l_ldap_session);
878: if (l_result is null or l_base is null)
879: then
880: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
881: fnd_log.string(fnd_log.level_statement, l_module_source, 'END->NULLl:');
882: END IF;
883: return NULL;
884: end if;
885: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 885: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

881: fnd_log.string(fnd_log.level_statement, l_module_source, 'END->NULLl:');
882: END IF;
883: return NULL;
884: end if;
885: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
886: fnd_log.string(fnd_log.level_statement, l_module_source, 'END-> ' || l_base||l_result);
887: END IF;
888: return l_base||l_result;
889:

Line 886: fnd_log.string(fnd_log.level_statement, l_module_source, 'END-> ' || l_base||l_result);

882: END IF;
883: return NULL;
884: end if;
885: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
886: fnd_log.string(fnd_log.level_statement, l_module_source, 'END-> ' || l_base||l_result);
887: END IF;
888: return l_base||l_result;
889:
890: EXCEPTION WHEN OTHERS THEN

Line 891: IF(fnd_log.level_error >= fnd_log.g_current_runtime_level)

887: END IF;
888: return l_base||l_result;
889:
890: EXCEPTION WHEN OTHERS THEN
891: IF(fnd_log.level_error >= fnd_log.g_current_runtime_level)
892: THEN
893: fnd_log.string(fnd_log.level_error, l_module_source, sqlerrm);
894: END IF;
895:

Line 893: fnd_log.string(fnd_log.level_error, l_module_source, sqlerrm);

889:
890: EXCEPTION WHEN OTHERS THEN
891: IF(fnd_log.level_error >= fnd_log.g_current_runtime_level)
892: THEN
893: fnd_log.string(fnd_log.level_error, l_module_source, sqlerrm);
894: END IF;
895:
896: fnd_message.set_name('FND', 'get_DAS_BASE_URL'); RETURN NULL;
897: return null;

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

920: ret pls_integer;
921: l_module_source varchar2(256):= G_MODULE_SOURCE || 'add_attribute_M: ';
922:
923: BEGIN
924: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
925: then
926: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
927: end if;
928: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

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

922:
923: BEGIN
924: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
925: then
926: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
927: end if;
928: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
929: then
930: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'dn='||dn);

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

924: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
925: then
926: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
927: end if;
928: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
929: then
930: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'dn='||dn);
931: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'attribute='||name||' value='||value);
932: end if;

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

926: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
927: end if;
928: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
929: then
930: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'dn='||dn);
931: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'attribute='||name||' value='||value);
932: end if;
933:
934: modArray := dbms_ldap.create_mod_array(num => 1);

Line 931: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'attribute='||name||' value='||value);

927: end if;
928: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
929: then
930: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'dn='||dn);
931: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'attribute='||name||' value='||value);
932: end if;
933:
934: modArray := dbms_ldap.create_mod_array(num => 1);
935: vals(0) := value;

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

935: vals(0) := value;
936: dbms_ldap.populate_mod_array(modptr=>modArray,mod_op=>dbms_ldap.mod_add,mod_type=>name,modval=>vals);
937: ret := dbms_ldap.modify_s(ld=>x_ldap,entrydn=>dn,modptr=>modArray);
938: dbms_ldap.free_mod_array(modptr => modArray);
939: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
940: then
941: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END');
942: end if;
943:

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

937: ret := dbms_ldap.modify_s(ld=>x_ldap,entrydn=>dn,modptr=>modArray);
938: dbms_ldap.free_mod_array(modptr => modArray);
939: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
940: then
941: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END');
942: end if;
943:
944: exception when others then
945: if (fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

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

941: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END');
942: end if;
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, sqlerrm);
948: end if;
949: raise;

Line 947: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source, 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, sqlerrm);
948: end if;
949: raise;
950:
951: END add_attribute_M;

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

958: /*
959: * flag=-99 just to print the stack on the log
960: */
961: IF (flag=-99) THEN
962: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
963: then
964: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'DUMP ldap status for FND_LDAP_UTIL='||g_common_counter);
965: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'g_common_counter='||g_common_counter);
966: IF (G_TRACK_LDAP_STACK) THEN

Line 964: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'DUMP ldap status for FND_LDAP_UTIL='||g_common_counter);

960: */
961: IF (flag=-99) THEN
962: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
963: then
964: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'DUMP ldap status for FND_LDAP_UTIL='||g_common_counter);
965: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'g_common_counter='||g_common_counter);
966: IF (G_TRACK_LDAP_STACK) THEN
967: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, ldap_session_stack);
968: END IF;

Line 965: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'g_common_counter='||g_common_counter);

961: IF (flag=-99) THEN
962: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
963: then
964: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'DUMP ldap status for FND_LDAP_UTIL='||g_common_counter);
965: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'g_common_counter='||g_common_counter);
966: IF (G_TRACK_LDAP_STACK) THEN
967: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, ldap_session_stack);
968: END IF;
969: end if;

Line 967: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, ldap_session_stack);

963: then
964: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'DUMP ldap status for FND_LDAP_UTIL='||g_common_counter);
965: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'g_common_counter='||g_common_counter);
966: IF (G_TRACK_LDAP_STACK) THEN
967: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, ldap_session_stack);
968: END IF;
969: end if;
970: return null;
971: END IF;

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

971: END IF;
972:
973:
974:
975: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
976: then
977: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
978: end if;
979: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

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

973:
974:
975: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
976: then
977: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
978: end if;
979: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
980: then
981: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'initialy g_common_counter='||g_common_counter);

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

975: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
976: then
977: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
978: end if;
979: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
980: then
981: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'initialy g_common_counter='||g_common_counter);
982: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'initialy flag='||flag);
983: end if;

Line 981: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'initialy g_common_counter='||g_common_counter);

977: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
978: end if;
979: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
980: then
981: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'initialy g_common_counter='||g_common_counter);
982: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'initialy flag='||flag);
983: end if;
984:
985: if (g_common_counter=0) then

Line 982: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'initialy flag='||flag);

978: end if;
979: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
980: then
981: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'initialy g_common_counter='||g_common_counter);
982: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'initialy flag='||flag);
983: end if;
984:
985: if (g_common_counter=0) then
986: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

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

982: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'initialy flag='||flag);
983: end if;
984:
985: if (g_common_counter=0) then
986: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
987: then
988: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'creating a new connection');
989: IF (G_TRACK_LDAP_STACK) THEN
990: ldap_session_stack := dbms_utility.FORMAT_CALL_STACK;

Line 988: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'creating a new connection');

984:
985: if (g_common_counter=0) then
986: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
987: then
988: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'creating a new connection');
989: IF (G_TRACK_LDAP_STACK) THEN
990: ldap_session_stack := dbms_utility.FORMAT_CALL_STACK;
991: END IF;
992: end if;

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

994: end if;
995: flag := g_common_counter;
996: g_common_counter := g_common_counter + 1;
997:
998: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
999: then
1000: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'finally g_common_counter='||g_common_counter);
1001: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'finally flag='||flag);
1002: end if;

Line 1000: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'finally g_common_counter='||g_common_counter);

996: g_common_counter := g_common_counter + 1;
997:
998: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
999: then
1000: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'finally g_common_counter='||g_common_counter);
1001: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'finally flag='||flag);
1002: end if;
1003: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1004: then

Line 1001: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'finally flag='||flag);

997:
998: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
999: then
1000: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'finally g_common_counter='||g_common_counter);
1001: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'finally flag='||flag);
1002: end if;
1003: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1004: then
1005: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END');

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

999: then
1000: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'finally g_common_counter='||g_common_counter);
1001: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'finally flag='||flag);
1002: end if;
1003: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1004: then
1005: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END');
1006: end if;
1007: return g_common_ldap;

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

1001: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'finally flag='||flag);
1002: end if;
1003: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1004: then
1005: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END');
1006: end if;
1007: return g_common_ldap;
1008:
1009: exception when others then

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

1006: end if;
1007: return g_common_ldap;
1008:
1009: exception when others then
1010: if (fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1011: then
1012: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source, sqlerrm);
1013: end if;
1014: raise;

Line 1012: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source, sqlerrm);

1008:
1009: exception when others then
1010: if (fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1011: then
1012: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source, sqlerrm);
1013: end if;
1014: raise;
1015: END c_get_oid_session;
1016: procedure c_unbind(ldap in out nocopy dbms_ldap.session , flag in out nocopy pls_integer)

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

1017: is
1018: l_module_source varchar2(256):= G_MODULE_SOURCE || 'c_unbind: ';
1019: ret pls_integer;
1020: begin
1021: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1022: then
1023: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1024: end if;
1025:

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

1019: ret pls_integer;
1020: begin
1021: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1022: then
1023: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1024: end if;
1025:
1026: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1027: then

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

1022: then
1023: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1024: end if;
1025:
1026: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1027: then
1028: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, ' incomming g_common_counter='||g_common_counter);
1029: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, ' incomming flag='||flag);
1030: end if;

Line 1028: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, ' incomming g_common_counter='||g_common_counter);

1024: end if;
1025:
1026: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1027: then
1028: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, ' incomming g_common_counter='||g_common_counter);
1029: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, ' incomming flag='||flag);
1030: end if;
1031:
1032: if (flag=0)then

Line 1029: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, ' incomming flag='||flag);

1025:
1026: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1027: then
1028: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, ' incomming g_common_counter='||g_common_counter);
1029: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, ' incomming flag='||flag);
1030: end if;
1031:
1032: if (flag=0)then
1033: ret := unbind(g_common_ldap);

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

1035: elsif (g_common_counter>1) then
1036: g_common_counter := g_common_counter - 1;
1037: -- we don't wont to reach 0, because we will lose control.
1038: else
1039: if (fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1040: then
1041: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source, 'g_common_counter reached invalid value='||g_common_counter);
1042: end if;
1043:

Line 1041: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source, 'g_common_counter reached invalid value='||g_common_counter);

1037: -- we don't wont to reach 0, because we will lose control.
1038: else
1039: if (fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1040: then
1041: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source, 'g_common_counter reached invalid value='||g_common_counter);
1042: end if;
1043:
1044: end if;
1045: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

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

1041: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source, 'g_common_counter reached invalid value='||g_common_counter);
1042: end if;
1043:
1044: end if;
1045: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1046: then
1047: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, ' final g_common_counter='||g_common_counter);
1048: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, ' final flag='||flag);
1049: end if;

Line 1047: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, ' final g_common_counter='||g_common_counter);

1043:
1044: end if;
1045: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1046: then
1047: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, ' final g_common_counter='||g_common_counter);
1048: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, ' final flag='||flag);
1049: end if;
1050: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1051: then

Line 1048: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, ' final flag='||flag);

1044: end if;
1045: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1046: then
1047: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, ' final g_common_counter='||g_common_counter);
1048: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, ' final flag='||flag);
1049: end if;
1050: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1051: then
1052: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END');

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

1046: then
1047: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, ' final g_common_counter='||g_common_counter);
1048: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, ' final flag='||flag);
1049: end if;
1050: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1051: then
1052: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END');
1053: end if;
1054: exception when others then

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

1048: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, ' final flag='||flag);
1049: end if;
1050: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1051: then
1052: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END');
1053: end if;
1054: exception when others then
1055: if (fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1056: then

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

1051: then
1052: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END');
1053: end if;
1054: exception when others then
1055: if (fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1056: then
1057: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source, sqlerrm);
1058: end if;
1059: raise;

Line 1057: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source, sqlerrm);

1053: end if;
1054: exception when others then
1055: if (fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1056: then
1057: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source, sqlerrm);
1058: end if;
1059: raise;
1060: end c_unbind;
1061: end fnd_ldap_util;