APPS.FND_SSO_MANAGER dependencies on FND_LOG

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

42: l_user_name fnd_user.user_name%type;
43: begin
44: l_module_source := G_MODULE_SOURCE || 'synch_user_from_LDAP';
45:
46: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
47: then
48: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
49: end if;
50:

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

44: l_module_source := G_MODULE_SOURCE || 'synch_user_from_LDAP';
45:
46: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
47: then
48: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
49: end if;
50:
51: l_user_name := p_user_name;
52: fnd_ldap_wrapper.synch_user_from_LDAP(p_user_name => l_user_name,

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

51: l_user_name := p_user_name;
52: fnd_ldap_wrapper.synch_user_from_LDAP(p_user_name => l_user_name,
53: p_result => l_result);
54:
55: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
56: then
57: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'l_result: '||l_result);
58: end if;
59:

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

53: p_result => l_result);
54:
55: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
56: then
57: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'l_result: '||l_result);
58: end if;
59:
60: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
61: then

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

56: then
57: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'l_result: '||l_result);
58: end if;
59:
60: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
61: then
62: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');
63: end if;
64:

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

58: end if;
59:
60: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
61: then
62: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');
63: end if;
64:
65: exception
66: when others then

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

64:
65: exception
66: when others then
67: raise;
68: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
69: then
70: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
71: end if;
72: end synch_user_from_LDAP;

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

66: when others then
67: raise;
68: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
69: then
70: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
71: end if;
72: end synch_user_from_LDAP;
73:
74: /*

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

84: begin
85: l_returnVal := false;
86: l_module_source := G_MODULE_SOURCE || 'isUserCreateUpdateAllowed: ';
87:
88: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
89: then
90: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
91: end if;
92:

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

86: l_module_source := G_MODULE_SOURCE || 'isUserCreateUpdateAllowed: ';
87:
88: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
89: then
90: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
91: end if;
92:
93: fnd_profile.get(name => 'APPS_SSO_USER_CREATE_UPDATE',
94: val => l_apps_sso_user_create_update);

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

92:
93: fnd_profile.get(name => 'APPS_SSO_USER_CREATE_UPDATE',
94: val => l_apps_sso_user_create_update);
95:
96: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
97: then
98: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
99: 'APPS_SSO_USER_CREATE_UPDATE: ' || l_apps_sso_user_create_update);
100: end if;

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

94: val => l_apps_sso_user_create_update);
95:
96: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
97: then
98: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
99: 'APPS_SSO_USER_CREATE_UPDATE: ' || l_apps_sso_user_create_update);
100: end if;
101:
102: if (l_apps_sso_user_create_update = 'N')

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

105: else
106: l_returnVal := TRUE;
107: end if;
108:
109: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
110: then
111: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');
112: end if;
113:

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

107: end if;
108:
109: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
110: then
111: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');
112: end if;
113:
114: return l_returnVal;
115:

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

114: return l_returnVal;
115:
116: exception
117: when others then
118: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
119: then
120: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
121: end if;
122: return false;

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

116: exception
117: when others then
118: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
119: then
120: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
121: end if;
122: return false;
123: end;
124:

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

239:
240: l_module_source := G_MODULE_SOURCE || 'isPasswordChangeable';
241:
242:
243: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
244: then
245: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
246: end if;
247:

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

241:
242:
243: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
244: then
245: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
246: end if;
247:
248: select user_id, user_guid into p_user_id, p_user_guid from fnd_user where user_name = upper(username);
249:

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

246: end if;
247:
248: select user_id, user_guid into p_user_id, p_user_guid from fnd_user where user_name = upper(username);
249:
250: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
251: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Retrieved user_id and user_guid for user '||username);
252: end if;
253:
254: if (p_user_guid is not null) then

Line 251: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Retrieved user_id and user_guid for user '||username);

247:
248: select user_id, user_guid into p_user_id, p_user_guid from fnd_user where user_name = upper(username);
249:
250: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
251: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Retrieved user_id and user_guid for user '||username);
252: end if;
253:
254: if (p_user_guid is not null) then
255:

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

252: end if;
253:
254: if (p_user_guid is not null) then
255:
256: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
257: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'User: '||username||' is linked' );
258: end if;
259:
260: FND_PROFILE.GET_SPECIFIC(name_z => 'APPS_SSO_LOCAL_LOGIN',

Line 257: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'User: '||username||' is linked' );

253:
254: if (p_user_guid is not null) then
255:
256: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
257: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'User: '||username||' is linked' );
258: end if;
259:
260: FND_PROFILE.GET_SPECIFIC(name_z => 'APPS_SSO_LOCAL_LOGIN',
261: user_id_z => p_user_id,

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

261: user_id_z => p_user_id,
262: val_z => pValue,
263: defined_z => l_profile_defined);
264:
265: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
266: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'APPS_SSO_LOCAL_LOGIN for' ||username||' is '||pValue);
267: end if;
268:
269:

Line 266: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'APPS_SSO_LOCAL_LOGIN for' ||username||' is '||pValue);

262: val_z => pValue,
263: defined_z => l_profile_defined);
264:
265: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
266: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'APPS_SSO_LOCAL_LOGIN for' ||username||' is '||pValue);
267: end if;
268:
269:
270: if (pValue is null or not l_profile_defined) then

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

280: x_attribute => l_attribute,
281: x_fnd_user => l_fnd_user,
282: x_oid => l_oid);
283:
284: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
285: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'User is an SSO user. Verifying password can be synched');
286: end if;
287:
288: if (l_oid = fnd_ldap_wrapper.G_SUCCESS AND fnd_ldap_wrapper.is_present(p_attribute =>'userpassword', p_template_attr_list =>l_attribute) )

Line 285: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'User is an SSO user. Verifying password can be synched');

281: x_fnd_user => l_fnd_user,
282: x_oid => l_oid);
283:
284: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
285: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'User is an SSO user. Verifying password can be synched');
286: end if;
287:
288: if (l_oid = fnd_ldap_wrapper.G_SUCCESS AND fnd_ldap_wrapper.is_present(p_attribute =>'userpassword', p_template_attr_list =>l_attribute) )
289: then

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

286: end if;
287:
288: if (l_oid = fnd_ldap_wrapper.G_SUCCESS AND fnd_ldap_wrapper.is_present(p_attribute =>'userpassword', p_template_attr_list =>l_attribute) )
289: then
290: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
291: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'User is an SSO user and password can be synched');
292: end if;
293:
294: l_pwd_changable := true;

Line 291: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'User is an SSO user and password can be synched');

287:
288: if (l_oid = fnd_ldap_wrapper.G_SUCCESS AND fnd_ldap_wrapper.is_present(p_attribute =>'userpassword', p_template_attr_list =>l_attribute) )
289: then
290: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
291: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'User is an SSO user and password can be synched');
292: end if;
293:
294: l_pwd_changable := true;
295: else

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

292: end if;
293:
294: l_pwd_changable := true;
295: else
296: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
297: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'User is an SSO user but password cannot be synched');
298: end if;
299:
300: l_pwd_changable := false;

Line 297: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'User is an SSO user but password cannot be synched');

293:
294: l_pwd_changable := true;
295: else
296: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
297: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'User is an SSO user but password cannot be synched');
298: end if;
299:
300: l_pwd_changable := false;
301: end if;

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

302:
303: end if;
304:
305: else
306: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
307: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'User is not linked - password can be changed');
308: end if;
309:
310: l_pwd_changable := true;

Line 307: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'User is not linked - password can be changed');

303: end if;
304:
305: else
306: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
307: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'User is not linked - password can be changed');
308: end if;
309:
310: l_pwd_changable := true;
311: end if;

Line 313: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then

309:
310: l_pwd_changable := true;
311: end if;
312:
313: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
314: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
315: end if;
316:
317: return l_pwd_changable;

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

310: l_pwd_changable := true;
311: end if;
312:
313: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
314: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
315: end if;
316:
317: return l_pwd_changable;
318:

Line 323: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL) THEN

319: exception
320: when no_data_found THEN
321: raise userNotFound;
322: when others then
323: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL) THEN
324: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END -EXCEPTION '||sqlerrm);
325: end if;
326:
327: return false;

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

320: when no_data_found THEN
321: raise userNotFound;
322: when others then
323: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL) THEN
324: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END -EXCEPTION '||sqlerrm);
325: end if;
326:
327: return false;
328:

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

335: l_result varchar2(4000);
336: begin
337: l_module_source := G_MODULE_SOURCE || 'get_ldap_user_name';
338:
339: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
340: then
341: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
342: end if;
343:

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

337: l_module_source := G_MODULE_SOURCE || 'get_ldap_user_name';
338:
339: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
340: then
341: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
342: end if;
343:
344: l_result := fnd_ldap_wrapper.get_ldap_user_name(p_user_name => p_user_name);
345:

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

342: end if;
343:
344: l_result := fnd_ldap_wrapper.get_ldap_user_name(p_user_name => p_user_name);
345:
346: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
347: then
348: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'l_result: '||l_result);
349: end if;
350:

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

344: l_result := fnd_ldap_wrapper.get_ldap_user_name(p_user_name => p_user_name);
345:
346: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
347: then
348: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'l_result: '||l_result);
349: end if;
350:
351: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
352: then

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

347: then
348: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'l_result: '||l_result);
349: end if;
350:
351: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
352: then
353: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');
354: end if;
355: return l_result;

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

349: end if;
350:
351: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
352: then
353: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');
354: end if;
355: return l_result;
356: end get_ldap_user_name;
357: