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_USER_PKG dependencies on FND_LOG

Line 191: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

187: new_employee_id number;
188: new_person_party_id number;
189:
190: begin
191: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
192: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
193: 'Begin');
194: end if;
195:

Line 192: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

188: new_person_party_id number;
189:
190: begin
191: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
192: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
193: 'Begin');
194: end if;
195:
196: -- Bug 7687370

Line 215: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

211: g_old_person_party_id := l_old_person_party_id;
212: g_old_user_guid := l_old_user_guid;
213: -- end bug 4318754
214:
215: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
216: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
217: 'Retrieved originating values: person_party_id = '||l_old_person_party_id||',customer_id='||l_old_customer_id||
218: ',employee_id='||l_old_employee_id||' and supplier_id='||l_old_supplier_id);
219: end if;

Line 216: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

212: g_old_user_guid := l_old_user_guid;
213: -- end bug 4318754
214:
215: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
216: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
217: 'Retrieved originating values: person_party_id = '||l_old_person_party_id||',customer_id='||l_old_customer_id||
218: ',employee_id='||l_old_employee_id||' and supplier_id='||l_old_supplier_id);
219: end if;
220:

Line 339: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

335: if (nvl(l_old_person_party_id, 0) <> nvl(l_person_party_id, 0)) then
336:
337: fnd_user_pkg.derive_customer_employee_id(x_user_name, l_person_party_id, l_customer_id, l_employee_id);
338:
339: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
340: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,'Derive employee_id = '||l_employee_id||
341: ' derived customer_id = '||l_customer_id);
342: end if;
343: end if;

Line 340: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,'Derive employee_id = '||l_employee_id||

336:
337: fnd_user_pkg.derive_customer_employee_id(x_user_name, l_person_party_id, l_customer_id, l_employee_id);
338:
339: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
340: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,'Derive employee_id = '||l_employee_id||
341: ' derived customer_id = '||l_customer_id);
342: end if;
343: end if;
344: else

Line 352: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

348: if (nvl(l_old_customer_id, 0) <> nvl(l_customer_id, 0)) or (nvl(l_old_employee_id, 0) <> nvl(l_employee_id, 0)) then
349:
350: l_person_party_id := fnd_user_pkg.derive_person_party_id(x_user_name, l_customer_id, l_employee_id);
351:
352: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
353: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,'Derive party id = '||l_person_party_id);
354: end if;
355:
356:

Line 353: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,'Derive party id = '||l_person_party_id);

349:
350: l_person_party_id := fnd_user_pkg.derive_person_party_id(x_user_name, l_customer_id, l_employee_id);
351:
352: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
353: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,'Derive party id = '||l_person_party_id);
354: end if;
355:
356:
357: end if;

Line 371: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

367: * be expired when updating OID pwd. Not necessary if EXTERNAL.
368: * Setting a global so that it can be checked in fnd_web_sec APIs
369: * rather than updating all the signatures for pwd mgmt*/
370:
371: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
372: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
373: c_log_head || l_api_name || '.pwdExpire',
374: 'Password is not null so set global if not external');
375: end if;

Line 372: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

368: * Setting a global so that it can be checked in fnd_web_sec APIs
369: * rather than updating all the signatures for pwd mgmt*/
370:
371: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
372: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
373: c_log_head || l_api_name || '.pwdExpire',
374: 'Password is not null so set global if not external');
375: end if;
376:

Line 391: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

387: (l_password_lifespan_days is not null and
388: sysdate >= l_password_date + l_password_lifespan_days)) then
389:
390:
391: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
392: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
393: c_log_head || l_api_name || '.pwdExpire',
394: 'pwd is not external and should be EXPIRED');
395: end if;

Line 392: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

388: sysdate >= l_password_date + l_password_lifespan_days)) then
389:
390:
391: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
392: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
393: c_log_head || l_api_name || '.pwdExpire',
394: 'pwd is not external and should be EXPIRED');
395: end if;
396:

Line 399: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

395: end if;
396:
397: G_EXPIRE_USER_PWD := fnd_ldap_wrapper.G_TRUE;
398: else
399: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
400: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
401: c_log_head || l_api_name || '.pwdExpire',
402: 'pwd is not external and should NOT be EXPIRED');
403: end if;

Line 400: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

396:
397: G_EXPIRE_USER_PWD := fnd_ldap_wrapper.G_TRUE;
398: else
399: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
400: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
401: c_log_head || l_api_name || '.pwdExpire',
402: 'pwd is not external and should NOT be EXPIRED');
403: end if;
404:

Line 410: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

406: end if; -- End calculating pwd expiration - bug 13472484
407:
408: end if; -- End calculating password expiration for non-EXTERNAL pwds
409:
410: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
411: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
412: c_log_head || l_api_name || '.before_updusr',
413: 'Now change password');
414: end if;

Line 411: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

407:
408: end if; -- End calculating password expiration for non-EXTERNAL pwds
409:
410: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
411: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
412: c_log_head || l_api_name || '.before_updusr',
413: 'Now change password');
414: end if;
415:

Line 447: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

443: -- Bug 13472484
444: -- Resetting variable to NULL now that the change_password call is complete.
445: -- Any further calls to ldap_wrapper_update_user will use the arg
446: -- passed or its default
447: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
448: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
449: 'Set G_EXPIRE_USER_PWD to null');
450: end if;
451: G_EXPIRE_USER_PWD := NULL;

Line 448: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

444: -- Resetting variable to NULL now that the change_password call is complete.
445: -- Any further calls to ldap_wrapper_update_user will use the arg
446: -- passed or its default
447: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
448: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
449: 'Set G_EXPIRE_USER_PWD to null');
450: end if;
451: G_EXPIRE_USER_PWD := NULL;
452:

Line 482: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

478: end if;
479: app_exception.raise_exception;
480: end;
481:
482: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
483: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
484: c_log_head || l_api_name || '.before_upduser',
485: 'UpdateUser(): before updating user');
486: end if;

Line 483: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

479: app_exception.raise_exception;
480: end;
481:
482: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
483: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
484: c_log_head || l_api_name || '.before_upduser',
485: 'UpdateUser(): before updating user');
486: end if;
487:

Line 488: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

484: c_log_head || l_api_name || '.before_upduser',
485: 'UpdateUser(): before updating user');
486: end if;
487:
488: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
489: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
490: 'Updating user with l_person_party_id = '||l_person_party_id||
491: ', l_employee_id = '||l_employee_id||
492: ', l_customer_id = '||l_customer_id||

Line 489: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

485: 'UpdateUser(): before updating user');
486: end if;
487:
488: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
489: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
490: 'Updating user with l_person_party_id = '||l_person_party_id||
491: ', l_employee_id = '||l_employee_id||
492: ', l_customer_id = '||l_customer_id||
493: 'and l_supplier_id = '||l_supplier_id);

Line 530: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

526: fnd_function_security_cache.update_user(l_user_id);
527: end if;
528:
529:
530: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
531: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
532: 'Start calling ldap_wrapper_update_user');
533: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
534: 'x_user_name = '||x_user_name);

Line 531: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

527: end if;
528:
529:
530: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
531: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
532: 'Start calling ldap_wrapper_update_user');
533: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
534: 'x_user_name = '||x_user_name);
535: end if;

Line 533: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

529:
530: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
531: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
532: 'Start calling ldap_wrapper_update_user');
533: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
534: 'x_user_name = '||x_user_name);
535: end if;
536:
537: -- Enhancement 5027812

Line 547: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

543: -- will be changed higher up in the call to fnd_web_sec.change_password.
544: -- This second attempt to change the password will result in an error if
545: -- password history is enabled.
546: -- G_EXPIRE_USER_PWD is NULL - this call will use the default of 0.
547: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
548: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
549: 'G_EXPIRE_USER_PWD is null and now expect the default of 0 to be used');
550: end if;
551:

Line 548: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

544: -- This second attempt to change the password will result in an error if
545: -- password history is enabled.
546: -- G_EXPIRE_USER_PWD is NULL - this call will use the default of 0.
547: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
548: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
549: 'G_EXPIRE_USER_PWD is null and now expect the default of 0 to be used');
550: end if;
551:
552: ldap_wrapper_update_user(x_user_name => upper(x_user_name),

Line 572: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

568: end;
569: end if;
570: -- End bug 4318754, 4424225
571:
572: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
573: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
574: 'After calling ldap_wrapper_update_user');
575: end if;
576:

Line 573: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

569: end if;
570: -- End bug 4318754, 4424225
571:
572: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
573: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
574: 'After calling ldap_wrapper_update_user');
575: end if;
576:
577: -- Enhancement 7311235 / Bug 8222658

Line 853: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

849: -- Bug 14673409 - set the new_customer_id to be passed to the event if the association is changed.
850: -- Since supplier_id is not being derived will continue as is
851: if (l_old_person_party_id <> l_person_party_id) then
852: new_person_party_id := l_person_party_id;
853: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
854: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
855: 'Associating with new person_party_id: '||new_person_party_id);
856: end if;
857: end if;

Line 854: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

850: -- Since supplier_id is not being derived will continue as is
851: if (l_old_person_party_id <> l_person_party_id) then
852: new_person_party_id := l_person_party_id;
853: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
854: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
855: 'Associating with new person_party_id: '||new_person_party_id);
856: end if;
857: end if;
858:

Line 861: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

857: end if;
858:
859: if (l_old_customer_id <> l_customer_id) then
860: new_customer_id := l_customer_id;
861: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
862: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
863: 'Associating with new customer_id: '||new_customer_id);
864: end if;
865: end if;

Line 862: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

858:
859: if (l_old_customer_id <> l_customer_id) then
860: new_customer_id := l_customer_id;
861: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
862: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
863: 'Associating with new customer_id: '||new_customer_id);
864: end if;
865: end if;
866:

Line 869: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

865: end if;
866:
867: if (l_old_employee_id <> l_employee_id) then
868: new_employee_id := l_employee_id;
869: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
870: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
871: 'Associating a new employee_id: '||new_employee_id);
872: end if;
873: end if;

Line 870: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

866:
867: if (l_old_employee_id <> l_employee_id) then
868: new_employee_id := l_employee_id;
869: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
870: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
871: 'Associating a new employee_id: '||new_employee_id);
872: end if;
873: end if;
874:

Line 875: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

871: 'Associating a new employee_id: '||new_employee_id);
872: end if;
873: end if;
874:
875: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
876: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
877: 'Raising event oracle.apps.fnd.post.user.update');
878: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
879: 'Passing new_customer_id = '||new_customer_id||' new_person_party_id = '||new_person_party_id ||

Line 876: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

872: end if;
873: end if;
874:
875: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
876: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
877: 'Raising event oracle.apps.fnd.post.user.update');
878: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
879: 'Passing new_customer_id = '||new_customer_id||' new_person_party_id = '||new_person_party_id ||
880: ' and new_employee_id = '||new_employee_id);

Line 878: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

874:
875: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
876: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
877: 'Raising event oracle.apps.fnd.post.user.update');
878: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
879: 'Passing new_customer_id = '||new_customer_id||' new_person_party_id = '||new_person_party_id ||
880: ' and new_employee_id = '||new_employee_id);
881: end if;
882:

Line 1209: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

1205: l_password_lifespan_accesses number;
1206: l_password_lifespan_days number;
1207:
1208: begin
1209: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1210: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1211: 'Begin');
1212: end if;
1213:

Line 1210: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

1206: l_password_lifespan_days number;
1207:
1208: begin
1209: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1210: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1211: 'Begin');
1212: end if;
1213:
1214: -- Bug 7687370

Line 1247: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

1243: pwd := '';
1244: end if;
1245:
1246: -- Bug#4118749 - Create user in OID
1247: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1248: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1249: 'Start calling ldap_wrapper_create_user');
1250: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1251: 'x_user_name = '||x_user_name);

Line 1248: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

1244: end if;
1245:
1246: -- Bug#4118749 - Create user in OID
1247: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1248: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1249: 'Start calling ldap_wrapper_create_user');
1250: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1251: 'x_user_name = '||x_user_name);
1252: end if;

Line 1250: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

1246: -- Bug#4118749 - Create user in OID
1247: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1248: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1249: 'Start calling ldap_wrapper_create_user');
1250: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1251: 'x_user_name = '||x_user_name);
1252: end if;
1253:
1254: begin

Line 1299: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

1295: and nvl(l_password_accesses_left, 0) < 1) or
1296: (l_password_lifespan_days is not null and
1297: sysdate >= l_password_date + l_password_lifespan_days)) then
1298:
1299: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1300: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1301: 'Call ldap_wrapper_create_user with expire_pwd flag=true');
1302: end if;
1303:

Line 1300: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

1296: (l_password_lifespan_days is not null and
1297: sysdate >= l_password_date + l_password_lifespan_days)) then
1298:
1299: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1300: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1301: 'Call ldap_wrapper_create_user with expire_pwd flag=true');
1302: end if;
1303:
1304: l_expire_pwd := fnd_ldap_wrapper.G_TRUE;

Line 1307: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

1303:
1304: l_expire_pwd := fnd_ldap_wrapper.G_TRUE;
1305: else
1306:
1307: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1308: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1309: 'Call ldap_wrapper_create_user with expire_pwd flag=false');
1310: end if;
1311:

Line 1308: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

1304: l_expire_pwd := fnd_ldap_wrapper.G_TRUE;
1305: else
1306:
1307: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1308: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1309: 'Call ldap_wrapper_create_user with expire_pwd flag=false');
1310: end if;
1311:
1312: l_expire_pwd := fnd_ldap_wrapper.G_FALSE;

Line 1337: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

1333: fnd_message.set_token('REASON', reason);
1334: app_exception.raise_exception;
1335: end;
1336:
1337: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1338: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1339: 'After calling ldap_wrapper_create_user');
1340: end if;
1341: else

Line 1338: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

1334: app_exception.raise_exception;
1335: end;
1336:
1337: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1338: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1339: 'After calling ldap_wrapper_create_user');
1340: end if;
1341: else
1342: l_user_guid := x_user_guid;

Line 1352: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

1348: set created_by = owner_id
1349: where user_name = upper(x_user_name);
1350:
1351: -- update the rest of the data except password
1352: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1353: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1354: c_log_head || l_api_name || '.call_upduser',
1355: 'CreateUser(): calling fnd_user_pkg.UpdateUser');
1356: end if;

Line 1353: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1349: where user_name = upper(x_user_name);
1350:
1351: -- update the rest of the data except password
1352: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1353: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1354: c_log_head || l_api_name || '.call_upduser',
1355: 'CreateUser(): calling fnd_user_pkg.UpdateUser');
1356: end if;
1357:

Line 1423: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

1419:
1420: -- bug 8227171 CreateUserIdInternal
1421: -- Raise the WF event oracle.apps.fnd.post.user.create
1422: begin
1423: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1424: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1425: 'Raising oracle.apps.fnd.post.user.create event');
1426: end if;
1427: g_event_controller := NULL; -- we try once then reset

Line 1424: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

1420: -- bug 8227171 CreateUserIdInternal
1421: -- Raise the WF event oracle.apps.fnd.post.user.create
1422: begin
1423: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1424: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1425: 'Raising oracle.apps.fnd.post.user.create event');
1426: end if;
1427: g_event_controller := NULL; -- we try once then reset
1428: wf_event.raise(p_event_name => 'oracle.apps.fnd.post.user.create',

Line 1844: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

1840: exists_flag varchar2(1);
1841: reason varchar2(32000);
1842: begin
1843:
1844: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1845: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1846: c_log_head || l_api_name || '.before_updstmnt',
1847: 'LoadUser(): before update statement');
1848: end if;

Line 1845: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1841: reason varchar2(32000);
1842: begin
1843:
1844: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1845: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1846: c_log_head || l_api_name || '.before_updstmnt',
1847: 'LoadUser(): before update statement');
1848: end if;
1849: begin

Line 1882: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

1878: else -- Must be new user
1879: -- insert the new user if x_session_number and x_start_date are provided
1880: if (x_unencrypted_password is not null) then
1881:
1882: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1883: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1884: c_log_head || l_api_name || '.call_creatuser',
1885: 'LoadUser(): calling CreateUser');
1886: end if;

Line 1883: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1879: -- insert the new user if x_session_number and x_start_date are provided
1880: if (x_unencrypted_password is not null) then
1881:
1882: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1883: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1884: c_log_head || l_api_name || '.call_creatuser',
1885: 'LoadUser(): calling CreateUser');
1886: end if;
1887: fnd_user_pkg.createuser(x_user_name,

Line 1944: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

1940: exists_flag varchar2(1);
1941: reason varchar2(32000);
1942: begin
1943:
1944: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1945: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1946: c_log_head || l_api_name || '.before_updstmnt',
1947: 'LoadUser(): before update statement');
1948: end if;

Line 1945: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1941: reason varchar2(32000);
1942: begin
1943:
1944: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1945: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1946: c_log_head || l_api_name || '.before_updstmnt',
1947: 'LoadUser(): before update statement');
1948: end if;
1949: begin

Line 1980: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

1976: else -- Must be new user
1977: -- insert the new user if x_session_number and x_start_date are provided
1978: if (x_unencrypted_password is not null) then
1979:
1980: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1981: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1982: c_log_head || l_api_name || '.call_creatuser',
1983: 'LoadUser(): calling CreateUser');
1984: end if;

Line 1981: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1977: -- insert the new user if x_session_number and x_start_date are provided
1978: if (x_unencrypted_password is not null) then
1979:
1980: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1981: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1982: c_log_head || l_api_name || '.call_creatuser',
1983: 'LoadUser(): calling CreateUser');
1984: end if;
1985: fnd_user_pkg.createuserparty(x_user_name,

Line 2241: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

2237: where user_guid = userGuid;
2238:
2239: begin
2240:
2241: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2242: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2243: 'Start user_change');
2244: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2245: 'p_subscription_guid ='||p_subscription_guid);

Line 2242: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2238:
2239: begin
2240:
2241: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2242: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2243: 'Start user_change');
2244: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2245: 'p_subscription_guid ='||p_subscription_guid);
2246: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

Line 2244: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2240:
2241: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2242: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2243: 'Start user_change');
2244: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2245: 'p_subscription_guid ='||p_subscription_guid);
2246: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2247: 'event_name ='||p_event.GetEventName);
2248: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

Line 2246: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2242: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2243: 'Start user_change');
2244: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2245: 'p_subscription_guid ='||p_subscription_guid);
2246: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2247: 'event_name ='||p_event.GetEventName);
2248: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2249: 'parameter CHANGE_SOURCE ='||
2250: p_event.GetValueForParameter('CHANGE_SOURCE'));

Line 2248: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2244: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2245: 'p_subscription_guid ='||p_subscription_guid);
2246: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2247: 'event_name ='||p_event.GetEventName);
2248: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2249: 'parameter CHANGE_SOURCE ='||
2250: p_event.GetValueForParameter('CHANGE_SOURCE'));
2251: end if;
2252:

Line 2263: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

2259:
2260: my_username := p_event.GetEventKey();
2261: my_mode := p_event.GetValueForParameter('CHANGE_TYPE');
2262:
2263: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2264: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2265: 'LDAP - event_key ='||my_username);
2266: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2267: 'LDAP - parameter CHANGE_TYPE ='||my_mode);

Line 2264: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2260: my_username := p_event.GetEventKey();
2261: my_mode := p_event.GetValueForParameter('CHANGE_TYPE');
2262:
2263: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2264: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2265: 'LDAP - event_key ='||my_username);
2266: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2267: 'LDAP - parameter CHANGE_TYPE ='||my_mode);
2268: end if;

Line 2266: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2262:
2263: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2264: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2265: 'LDAP - event_key ='||my_username);
2266: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2267: 'LDAP - parameter CHANGE_TYPE ='||my_mode);
2268: end if;
2269:
2270: if (my_mode = 'DELETE') then

Line 2361: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

2357: -- start the synch loop.
2358: x_user_guid => old_guid,
2359: x_change_source => fnd_user_pkg.change_source_oid);
2360:
2361: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2362: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2363: 'LDAP - finished fnd_user_pkg.UpdateUser('||my_username||')');
2364: end if;
2365: end if;

Line 2362: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2358: x_user_guid => old_guid,
2359: x_change_source => fnd_user_pkg.change_source_oid);
2360:
2361: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2362: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2363: 'LDAP - finished fnd_user_pkg.UpdateUser('||my_username||')');
2364: end if;
2365: end if;
2366: end if;

Line 2375: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

2371: my_cachekey := p_event.GetEventKey();
2372: my_ent_type := wf_entity_mgr.get_entity_type(p_event.GetEventName());
2373: my_guid := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
2374: 'ORCLGUID');
2375: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2376: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2377: 'OID - event_key ='||my_cachekey);
2378: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2379: 'OID - entity_type ='||my_ent_type);

Line 2376: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2372: my_ent_type := wf_entity_mgr.get_entity_type(p_event.GetEventName());
2373: my_guid := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
2374: 'ORCLGUID');
2375: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2376: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2377: 'OID - event_key ='||my_cachekey);
2378: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2379: 'OID - entity_type ='||my_ent_type);
2380: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

Line 2378: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2374: 'ORCLGUID');
2375: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2376: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2377: 'OID - event_key ='||my_cachekey);
2378: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2379: 'OID - entity_type ='||my_ent_type);
2380: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2381: 'OID - guid ='||my_guid);
2382: end if;

Line 2380: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2376: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2377: 'OID - event_key ='||my_cachekey);
2378: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2379: 'OID - entity_type ='||my_ent_type);
2380: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2381: 'OID - guid ='||my_guid);
2382: end if;
2383:
2384: open existing_users(my_guid);

Line 2456: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

2452: x_description => new_desc,
2453: x_email_address => new_email,
2454: x_fax => new_fax);
2455:
2456: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2457: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2458: 'OID - finished fnd_user_pkg.UpdateUser('||my_user||')');
2459: end if;
2460: end if;

Line 2457: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2453: x_email_address => new_email,
2454: x_fax => new_fax);
2455:
2456: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2457: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2458: 'OID - finished fnd_user_pkg.UpdateUser('||my_user||')');
2459: end if;
2460: end if;
2461: end if;

Line 2469: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

2465: END LOOP;
2466: CLOSE existing_users;
2467: end if;
2468:
2469: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2470: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2471: 'End user_change');
2472: end if;
2473: return wf_rule.default_rule(p_subscription_guid, p_event);

Line 2470: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2466: CLOSE existing_users;
2467: end if;
2468:
2469: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2470: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2471: 'End user_change');
2472: end if;
2473: return wf_rule.default_rule(p_subscription_guid, p_event);
2474: end user_change;

Line 2502: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

2498: l_api_name varchar2(30) := 'user_create_rf';
2499:
2500: begin
2501:
2502: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2503: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2504: 'Start user_create_rf');
2505: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2506: 'p_subscription_guid ='||p_subscription_guid);

Line 2503: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2499:
2500: begin
2501:
2502: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2503: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2504: 'Start user_create_rf');
2505: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2506: 'p_subscription_guid ='||p_subscription_guid);
2507: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

Line 2505: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2501:
2502: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2503: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2504: 'Start user_create_rf');
2505: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2506: 'p_subscription_guid ='||p_subscription_guid);
2507: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2508: 'event_name ='||p_event.GetEventName);
2509: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

Line 2507: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2503: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2504: 'Start user_create_rf');
2505: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2506: 'p_subscription_guid ='||p_subscription_guid);
2507: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2508: 'event_name ='||p_event.GetEventName);
2509: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2510: 'parameter CHANGE_SOURCE ='||
2511: p_event.GetValueForParameter('CHANGE_SOURCE'));

Line 2509: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2505: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2506: 'p_subscription_guid ='||p_subscription_guid);
2507: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2508: 'event_name ='||p_event.GetEventName);
2509: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2510: 'parameter CHANGE_SOURCE ='||
2511: p_event.GetValueForParameter('CHANGE_SOURCE'));
2512: end if;
2513: -- Ignore our own changes

Line 2521: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

2517: -- If CHANGE_SOURCE is LDAP, it means it's raised from one-way sync code.
2518: elsif (p_event.GetValueForParameter('CHANGE_SOURCE') = 'LDAP') then
2519: my_username := p_event.GetEventKey();
2520:
2521: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2522: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2523: 'LDAP - event_key ='||my_username);
2524: end if;
2525:

Line 2522: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2518: elsif (p_event.GetValueForParameter('CHANGE_SOURCE') = 'LDAP') then
2519: my_username := p_event.GetEventKey();
2520:
2521: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2522: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2523: 'LDAP - event_key ='||my_username);
2524: end if;
2525:
2526: begin

Line 2538: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

2534:
2535: -- user doesn't exist yet, we have work to do --
2536: my_ent_type := wf_entity_mgr.get_entity_type(p_event.GetEventName());
2537:
2538: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2539: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2540: 'LDAP - entity_type ='||my_ent_type);
2541: end if;
2542:

Line 2539: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2535: -- user doesn't exist yet, we have work to do --
2536: my_ent_type := wf_entity_mgr.get_entity_type(p_event.GetEventName());
2537:
2538: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2539: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2540: 'LDAP - entity_type ='||my_ent_type);
2541: end if;
2542:
2543: --

Line 2588: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

2584: x_description => new_desc2,
2585: x_email_address => new_email2,
2586: x_fax => new_fax2);
2587:
2588: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2589: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2590: 'LDAP - finished fnd_user_pkg.CreateUser('||my_username||')');
2591: end if;
2592: end;

Line 2589: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2585: x_email_address => new_email2,
2586: x_fax => new_fax2);
2587:
2588: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2589: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2590: 'LDAP - finished fnd_user_pkg.CreateUser('||my_username||')');
2591: end if;
2592: end;
2593:

Line 2601: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

2597: my_cachekey := p_event.GetEventKey();
2598: my_ent_type := wf_entity_mgr.get_entity_type(p_event.GetEventName());
2599: new_guid := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
2600: 'ORCLGUID');
2601: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2602: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2603: 'OID - event_key ='||my_cachekey);
2604: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2605: 'OID - entity_type ='||my_ent_type);

Line 2602: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2598: my_ent_type := wf_entity_mgr.get_entity_type(p_event.GetEventName());
2599: new_guid := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
2600: 'ORCLGUID');
2601: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2602: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2603: 'OID - event_key ='||my_cachekey);
2604: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2605: 'OID - entity_type ='||my_ent_type);
2606: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

Line 2604: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2600: 'ORCLGUID');
2601: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2602: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2603: 'OID - event_key ='||my_cachekey);
2604: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2605: 'OID - entity_type ='||my_ent_type);
2606: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2607: 'OID - guid ='||new_guid);
2608: end if;

Line 2606: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2602: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2603: 'OID - event_key ='||my_cachekey);
2604: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2605: 'OID - entity_type ='||my_ent_type);
2606: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2607: 'OID - guid ='||new_guid);
2608: end if;
2609: begin
2610: select 'Y' into existing_user

Line 2645: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

2641: x_description => new_desc,
2642: x_email_address => new_email,
2643: x_fax => new_fax);
2644:
2645: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2646: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2647: 'OID - finished fnd_user_pkg.CreateUser('||my_cachekey||')');
2648: end if;
2649:

Line 2646: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2642: x_email_address => new_email,
2643: x_fax => new_fax);
2644:
2645: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2646: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2647: 'OID - finished fnd_user_pkg.CreateUser('||my_cachekey||')');
2648: end if;
2649:
2650: --

Line 2660: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

2656:
2657: end;
2658: end if;
2659:
2660: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2661: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2662: 'End user_create_rf');
2663: end if;
2664:

Line 2661: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2657: end;
2658: end if;
2659:
2660: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2661: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2662: 'End user_create_rf');
2663: end if;
2664:
2665: return wf_rule.default_rule(p_subscription_guid, p_event);

Line 2690: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

2686: colnew(1) := '';
2687:
2688: tmpbuf := 'Start calling fnd_dictionary_pkg.updatepkcolumns('||
2689: old_name||','||new_name||')';
2690: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2691: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',
2692: tmpbuf);
2693: end if;
2694: ret := fnd_dictionary_pkg.updatepkcolumns('FND', 'FND_USER', colnames, colold,

Line 2691: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',

2687:
2688: tmpbuf := 'Start calling fnd_dictionary_pkg.updatepkcolumns('||
2689: old_name||','||new_name||')';
2690: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2691: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',
2692: tmpbuf);
2693: end if;
2694: ret := fnd_dictionary_pkg.updatepkcolumns('FND', 'FND_USER', colnames, colold,
2695: colnew);

Line 2697: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

2693: end if;
2694: ret := fnd_dictionary_pkg.updatepkcolumns('FND', 'FND_USER', colnames, colold,
2695: colnew);
2696: tmpbuf := 'Finished fnd_dictionary_pkg.updatepkcolumns';
2697: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2698: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',
2699: tmpbuf);
2700: end if;
2701: exception

Line 2698: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',

2694: ret := fnd_dictionary_pkg.updatepkcolumns('FND', 'FND_USER', colnames, colold,
2695: colnew);
2696: tmpbuf := 'Finished fnd_dictionary_pkg.updatepkcolumns';
2697: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2698: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',
2699: tmpbuf);
2700: end if;
2701: exception
2702: when others then

Line 2746: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

2742:
2743: begin
2744: -- fetch info for synch --
2745:
2746: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2747: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2748: 'Start user_synch');
2749: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2750: 'p_user_name = '||p_user_name);

Line 2747: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2743: begin
2744: -- fetch info for synch --
2745:
2746: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2747: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2748: 'Start user_synch');
2749: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2750: 'p_user_name = '||p_user_name);
2751: end if;

Line 2749: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2745:
2746: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2747: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2748: 'Start user_synch');
2749: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2750: 'p_user_name = '||p_user_name);
2751: end if;
2752:
2753: select user_id, email_address, description, fax, employee_id,

Line 2848: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

2844: wf_event.AddParameterToList('WFSYNCH_OVERWRITE','TRUE',mylist);
2845:
2846: --
2847:
2848: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2849: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2850: 'Calling wf_local_synch.propagate_user');
2851: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2852: 'ORCLGUID = '|| my_guid);

Line 2849: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2845:
2846: --
2847:
2848: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2849: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2850: 'Calling wf_local_synch.propagate_user');
2851: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2852: 'ORCLGUID = '|| my_guid);
2853: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

Line 2851: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2847:
2848: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2849: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2850: 'Calling wf_local_synch.propagate_user');
2851: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2852: 'ORCLGUID = '|| my_guid);
2853: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2854: 'PER_PERSON_ID = '|| my_empid);
2855: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

Line 2853: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2849: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2850: 'Calling wf_local_synch.propagate_user');
2851: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2852: 'ORCLGUID = '|| my_guid);
2853: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2854: 'PER_PERSON_ID = '|| my_empid);
2855: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2856: 'PERSON_PARTY_ID = '|| my_partyid);
2857: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

Line 2855: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2851: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2852: 'ORCLGUID = '|| my_guid);
2853: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2854: 'PER_PERSON_ID = '|| my_empid);
2855: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2856: 'PERSON_PARTY_ID = '|| my_partyid);
2857: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2858: 'DISPLAY_NAME(PARTY_NAME) = '|| ptyName);
2859: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

Line 2857: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2853: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2854: 'PER_PERSON_ID = '|| my_empid);
2855: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2856: 'PERSON_PARTY_ID = '|| my_partyid);
2857: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2858: 'DISPLAY_NAME(PARTY_NAME) = '|| ptyName);
2859: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2860: 'OLD_USER_NAME = '|| g_old_user_name);
2861: end if;

Line 2859: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2855: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2856: 'PERSON_PARTY_ID = '|| my_partyid);
2857: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2858: 'DISPLAY_NAME(PARTY_NAME) = '|| ptyName);
2859: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2860: 'OLD_USER_NAME = '|| g_old_user_name);
2861: end if;
2862: -- update wf and the entity manager --
2863: wf_local_synch.propagate_user('FND_USR',my_userid, myList, my_start, my_exp);

Line 2866: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

2862: -- update wf and the entity manager --
2863: wf_local_synch.propagate_user('FND_USR',my_userid, myList, my_start, my_exp);
2864: -- end of unstub
2865:
2866: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2867: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2868: 'Finished wf_local_synch.propagate_user');
2869: end if;
2870: -- -----------------------------------------------------------------

Line 2867: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2863: wf_local_synch.propagate_user('FND_USR',my_userid, myList, my_start, my_exp);
2864: -- end of unstub
2865:
2866: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2867: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2868: 'Finished wf_local_synch.propagate_user');
2869: end if;
2870: -- -----------------------------------------------------------------
2871: -- since wf_local_synch is temporarily stubbed out, also make the

Line 2911: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

2907: dummy := fnd_user_pkg.set_old_user_name(NULL);
2908: dummy := fnd_user_pkg.set_old_person_party_id(NULL);
2909: dummy := fnd_user_pkg.set_old_user_guid(NULL);
2910:
2911: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2912: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2913: 'End user_synch');
2914: end if;
2915: exception

Line 2912: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2908: dummy := fnd_user_pkg.set_old_person_party_id(NULL);
2909: dummy := fnd_user_pkg.set_old_user_guid(NULL);
2910:
2911: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2912: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2913: 'End user_synch');
2914: end if;
2915: exception
2916: -- Bug 3617474: This NO_DATA_FOUND exception handler was placed in the event

Line 3203: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

3199: if (log_exception = 'Y') then
3200: fnd_message.set_name('FND', 'USER_INVALID_CUSTOMER');
3201: fnd_message.set_token('USER', user_name);
3202: fnd_message.set_token('CUSTID', l_customer_id);
3203: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3204: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3205: c_log_head || l_api_name || '.not_in_hz_parties', FALSE);
3206: end if;
3207: app_exception.raise_exception;

Line 3204: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

3200: fnd_message.set_name('FND', 'USER_INVALID_CUSTOMER');
3201: fnd_message.set_token('USER', user_name);
3202: fnd_message.set_token('CUSTID', l_customer_id);
3203: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3204: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3205: c_log_head || l_api_name || '.not_in_hz_parties', FALSE);
3206: end if;
3207: app_exception.raise_exception;
3208: else

Line 3229: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

3225: fnd_message.set_name('FND', 'USER_INVALID_PARTY_REL');
3226: fnd_message.set_token('USER', user_name);
3227: fnd_message.set_token('PNAME', l_party_name);
3228: fnd_message.set_token('CUSTID', l_customer_id);
3229: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3230: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3231: c_log_head || l_api_name || '.not_in_hz_party_relationships',
3232: FALSE);
3233: end if;

Line 3230: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

3226: fnd_message.set_token('USER', user_name);
3227: fnd_message.set_token('PNAME', l_party_name);
3228: fnd_message.set_token('CUSTID', l_customer_id);
3229: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3230: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3231: c_log_head || l_api_name || '.not_in_hz_party_relationships',
3232: FALSE);
3233: end if;
3234: app_exception.raise_exception;

Line 3247: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

3243: fnd_message.set_token('USER', user_name);
3244: fnd_message.set_token('PNAME', l_party_name);
3245: fnd_message.set_token('PARTYID', l_customer_id);
3246: fnd_message.set_token('PARTY_TYPE', l_party_type);
3247: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3248: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3249: c_log_head || l_api_name || '.bad_party_type', FALSE);
3250: end if;
3251: app_exception.raise_exception;

Line 3248: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

3244: fnd_message.set_token('PNAME', l_party_name);
3245: fnd_message.set_token('PARTYID', l_customer_id);
3246: fnd_message.set_token('PARTY_TYPE', l_party_type);
3247: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3248: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3249: c_log_head || l_api_name || '.bad_party_type', FALSE);
3250: end if;
3251: app_exception.raise_exception;
3252: else

Line 3280: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

3276: if (log_exception = 'Y') then
3277: fnd_message.set_name('FND', 'USER_INVALID_EMPLOYEE');
3278: fnd_message.set_token('USER', user_name);
3279: fnd_message.set_token('EMPID', l_employee_id);
3280: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3281: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3282: c_log_head || l_api_name || '.bad_empid', FALSE);
3283: end if;
3284: app_exception.raise_exception;

Line 3281: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

3277: fnd_message.set_name('FND', 'USER_INVALID_EMPLOYEE');
3278: fnd_message.set_token('USER', user_name);
3279: fnd_message.set_token('EMPID', l_employee_id);
3280: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3281: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3282: c_log_head || l_api_name || '.bad_empid', FALSE);
3283: end if;
3284: app_exception.raise_exception;
3285: else

Line 3306: if (fnd_log.LEVEL_EXCEPTION >=

3302: when no_data_found then
3303: fnd_message.set_name('FND', 'USER_CUST_PARTY_NOT_FOUND');
3304: fnd_message.set_token('USER', user_name);
3305: fnd_message.set_token('CUSTID', l_customer_id);
3306: if (fnd_log.LEVEL_EXCEPTION >=
3307: fnd_log.g_current_runtime_level) then
3308: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3309: c_log_head || l_api_name || '.cust_emp_mismatch', FALSE);
3310: end if;

Line 3307: fnd_log.g_current_runtime_level) then

3303: fnd_message.set_name('FND', 'USER_CUST_PARTY_NOT_FOUND');
3304: fnd_message.set_token('USER', user_name);
3305: fnd_message.set_token('CUSTID', l_customer_id);
3306: if (fnd_log.LEVEL_EXCEPTION >=
3307: fnd_log.g_current_runtime_level) then
3308: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3309: c_log_head || l_api_name || '.cust_emp_mismatch', FALSE);
3310: end if;
3311: app_exception.raise_exception;

Line 3308: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

3304: fnd_message.set_token('USER', user_name);
3305: fnd_message.set_token('CUSTID', l_customer_id);
3306: if (fnd_log.LEVEL_EXCEPTION >=
3307: fnd_log.g_current_runtime_level) then
3308: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3309: c_log_head || l_api_name || '.cust_emp_mismatch', FALSE);
3310: end if;
3311: app_exception.raise_exception;
3312: end;

Line 3323: if (fnd_log.LEVEL_EXCEPTION >=

3319: when no_data_found then
3320: fnd_message.set_name('FND', 'USER_EMP_PARTY_NOT_FOUND');
3321: fnd_message.set_token('USER', user_name);
3322: fnd_message.set_token('EMPID', l_emp_person_party_id);
3323: if (fnd_log.LEVEL_EXCEPTION >=
3324: fnd_log.g_current_runtime_level) then
3325: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3326: c_log_head || l_api_name || '.cust_emp_mismatch', FALSE);
3327: end if;

Line 3324: fnd_log.g_current_runtime_level) then

3320: fnd_message.set_name('FND', 'USER_EMP_PARTY_NOT_FOUND');
3321: fnd_message.set_token('USER', user_name);
3322: fnd_message.set_token('EMPID', l_emp_person_party_id);
3323: if (fnd_log.LEVEL_EXCEPTION >=
3324: fnd_log.g_current_runtime_level) then
3325: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3326: c_log_head || l_api_name || '.cust_emp_mismatch', FALSE);
3327: end if;
3328: app_exception.raise_exception;

Line 3325: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

3321: fnd_message.set_token('USER', user_name);
3322: fnd_message.set_token('EMPID', l_emp_person_party_id);
3323: if (fnd_log.LEVEL_EXCEPTION >=
3324: fnd_log.g_current_runtime_level) then
3325: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3326: c_log_head || l_api_name || '.cust_emp_mismatch', FALSE);
3327: end if;
3328: app_exception.raise_exception;
3329: end;

Line 3337: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

3333: fnd_message.set_token('CUSTID', l_customer_id);
3334: fnd_message.set_token('CUSTPARTY', l_cust_person_party_name);
3335: fnd_message.set_token('EMPID', l_employee_id);
3336: fnd_message.set_token('EMPPARTY', l_emp_person_party_name);
3337: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3338: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3339: c_log_head || l_api_name || '.cust_emp_mismatch', FALSE);
3340: end if;
3341: app_exception.raise_exception;

Line 3338: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

3334: fnd_message.set_token('CUSTPARTY', l_cust_person_party_name);
3335: fnd_message.set_token('EMPID', l_employee_id);
3336: fnd_message.set_token('EMPPARTY', l_emp_person_party_name);
3337: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3338: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3339: c_log_head || l_api_name || '.cust_emp_mismatch', FALSE);
3340: end if;
3341: app_exception.raise_exception;
3342: else

Line 3413: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

3409: when no_data_found then
3410: fnd_message.set_name('FND', 'USER_INVALID_PARTY');
3411: fnd_message.set_token('USER', user_name);
3412: fnd_message.set_token('PARTYID', l_person_party_id);
3413: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3414: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3415: c_log_head || l_api_name || '.not_in_hz_parties', FALSE);
3416: end if;
3417: app_exception.raise_exception;

Line 3414: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

3410: fnd_message.set_name('FND', 'USER_INVALID_PARTY');
3411: fnd_message.set_token('USER', user_name);
3412: fnd_message.set_token('PARTYID', l_person_party_id);
3413: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3414: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3415: c_log_head || l_api_name || '.not_in_hz_parties', FALSE);
3416: end if;
3417: app_exception.raise_exception;
3418: end;

Line 3424: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

3420: fnd_message.set_name('FND', 'USER_INVALID_PARTY_TYPE');
3421: fnd_message.set_token('USER', user_name);
3422: fnd_message.set_token('PARTYID', l_person_party_id);
3423: fnd_message.set_token('PARTY_TYPE', l_party_type);
3424: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3425: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3426: c_log_head || l_api_name || '.bad_party_type', FALSE);
3427: end if;
3428: app_exception.raise_exception;

Line 3425: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

3421: fnd_message.set_token('USER', user_name);
3422: fnd_message.set_token('PARTYID', l_person_party_id);
3423: fnd_message.set_token('PARTY_TYPE', l_party_type);
3424: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3425: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3426: c_log_head || l_api_name || '.bad_party_type', FALSE);
3427: end if;
3428: app_exception.raise_exception;
3429: end if;

Line 3591: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

3587:
3588: l_api_name varchar2(30) := 'REMOVEPENDINGUSER';
3589: begin
3590:
3591: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3592: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name,
3593: 'Begin');
3594: end if;
3595:

Line 3592: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name,

3588: l_api_name varchar2(30) := 'REMOVEPENDINGUSER';
3589: begin
3590:
3591: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3592: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name,
3593: 'Begin');
3594: end if;
3595:
3596: -- Added for Function Security Cache Invalidation

Line 3609: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

3605:
3606: exception
3607: when no_data_found then
3608:
3609: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3610: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name,
3611: 'No disabled user');
3612: end if;
3613:

Line 3610: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name,

3606: exception
3607: when no_data_found then
3608:
3609: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3610: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name,
3611: 'No disabled user');
3612: end if;
3613:
3614: fnd_message.set_name('FND', 'FND_INVALID_USER');

Line 3622: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

3618:
3619: -- Bug 4318754. Synch up with SSO
3620: if (l_user_guid is not null) then
3621: begin
3622: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3623: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name,
3624: 'User guid is not null...call fnd_ldap_wrapper.delete_user');
3625: end if;
3626:

Line 3623: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name,

3619: -- Bug 4318754. Synch up with SSO
3620: if (l_user_guid is not null) then
3621: begin
3622: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3623: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name,
3624: 'User guid is not null...call fnd_ldap_wrapper.delete_user');
3625: end if;
3626:
3627: fnd_ldap_wrapper.delete_user(l_user_guid, retval);

Line 3638: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

3634: end;
3635: end if;
3636:
3637: -- Only allow to delete a PENDING user
3638: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3639: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name,
3640: 'Delete pending FND user');
3641: end if;
3642:

Line 3639: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name,

3635: end if;
3636:
3637: -- Only allow to delete a PENDING user
3638: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3639: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name,
3640: 'Delete pending FND user');
3641: end if;
3642:
3643: delete from fnd_user

Line 3649: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

3645: and to_char(start_date) = to_char(FND_API.G_MISS_DATE)
3646: and to_char(end_date) = to_char(FND_API.G_MISS_DATE);
3647:
3648: if (sql%rowcount = 0) then
3649: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3650: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name,
3651: 'This pending user does not exist');
3652: end if;
3653: fnd_message.set_name('FND', 'FND_INVALID_USER');

Line 3650: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name,

3646: and to_char(end_date) = to_char(FND_API.G_MISS_DATE);
3647:
3648: if (sql%rowcount = 0) then
3649: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3650: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name,
3651: 'This pending user does not exist');
3652: end if;
3653: fnd_message.set_name('FND', 'FND_INVALID_USER');
3654: fnd_message.set_token('USER_NAME', username);

Line 3664: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

3660:
3661: -- Bug 13824550
3662: -- A pending user was deleted...now need to remove this user from the WF
3663: -- tables by raising this event.
3664: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3665: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name,
3666: 'Call wf_directory.deleteRole to remove any inactive WF data associated with this user');
3667: end if;
3668:

Line 3665: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name,

3661: -- Bug 13824550
3662: -- A pending user was deleted...now need to remove this user from the WF
3663: -- tables by raising this event.
3664: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3665: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name,
3666: 'Call wf_directory.deleteRole to remove any inactive WF data associated with this user');
3667: end if;
3668:
3669: wf_directory.deleteRole(username,'FND_USR',l_user_id);

Line 3672: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

3668:
3669: wf_directory.deleteRole(username,'FND_USR',l_user_id);
3670: end if;
3671:
3672: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3673: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name, 'End');
3674: end if;
3675:
3676:

Line 3673: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name, 'End');

3669: wf_directory.deleteRole(username,'FND_USR',l_user_id);
3670: end if;
3671:
3672: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3673: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name, 'End');
3674: end if;
3675:
3676:
3677: end RemovePendingUser;

Line 3811: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

3807: -- Move ldap_wrapper synch call to here before we do FND user update
3808: begin
3809: tmpbuf := 'Calling ldap_wrapper_change_user_name to change '||
3810: x_old_user_name|| ' to '|| x_new_user_name;
3811: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3812: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',
3813: tmpbuf);
3814: end if;
3815: if (l_user_guid is not null) then

Line 3812: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',

3808: begin
3809: tmpbuf := 'Calling ldap_wrapper_change_user_name to change '||
3810: x_old_user_name|| ' to '|| x_new_user_name;
3811: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3812: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',
3813: tmpbuf);
3814: end if;
3815: if (l_user_guid is not null) then
3816: ldap_wrapper_change_user_name(l_user_guid, upper(x_old_user_name),

Line 3840: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

3836: -- FND_WEB_SEC.change_password having an autonomous transaction pragma.
3837: -- Password changes failed due to said change. See bug 2426407.
3838: -- handle password encryption with new username
3839: tmpbuf := 'Recrypting '||x_new_user_name|| ' password';
3840: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3841: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',
3842: tmpbuf);
3843: end if;
3844:

Line 3841: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',

3837: -- Password changes failed due to said change. See bug 2426407.
3838: -- handle password encryption with new username
3839: tmpbuf := 'Recrypting '||x_new_user_name|| ' password';
3840: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3841: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',
3842: tmpbuf);
3843: end if;
3844:
3845: -- Only have to do password reencryption if is not EXTERNAL, INVALID or Hash mode

Line 3852: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

3848: ret := fnd_user_pkg.SetReEncryptedPassword(x_new_user_name,newpass,'NEWKEY');
3849: end if;
3850:
3851: tmpbuf := 'updating fnd_user for new user_name '||x_new_user_name;
3852: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3853: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',
3854: tmpbuf);
3855: end if;
3856:

Line 3853: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',

3849: end if;
3850:
3851: tmpbuf := 'updating fnd_user for new user_name '||x_new_user_name;
3852: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3853: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',
3854: tmpbuf);
3855: end if;
3856:
3857: -- In the below WHERE clause, 'upper' is added, otherwise if the

Line 3871: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

3867: fnd_function_security_cache.update_user(l_user_id);
3868:
3869: -- propagate username change to WF and entity mgr
3870: tmpbuf := 'Start calling fnd_user_pkg.user_synch('||x_new_user_name||')';
3871: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3872: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',
3873: tmpbuf);
3874: end if;
3875: begin

Line 3872: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',

3868:
3869: -- propagate username change to WF and entity mgr
3870: tmpbuf := 'Start calling fnd_user_pkg.user_synch('||x_new_user_name||')';
3871: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3872: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',
3873: tmpbuf);
3874: end if;
3875: begin
3876: fnd_user_pkg.user_synch(upper(x_new_user_name));

Line 3897: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

3893: where grantee_key = x_old_user_name
3894: and grantee_type = 'USER';
3895:
3896: tmpbuf := 'Finished fnd_user_pkg.user_synch';
3897: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3898: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',
3899: tmpbuf);
3900: end if;
3901:

Line 3898: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',

3894: and grantee_type = 'USER';
3895:
3896: tmpbuf := 'Finished fnd_user_pkg.user_synch';
3897: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3898: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',
3899: tmpbuf);
3900: end if;
3901:
3902: -- bug 8227171 change_user_name

Line 4404: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

4400: l_result := null;
4401: l_pwd_ret := null;
4402: userid := null;
4403:
4404: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
4405: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
4406: 'Begin');
4407: end if;
4408:

Line 4405: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

4401: l_pwd_ret := null;
4402: userid := null;
4403:
4404: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
4405: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
4406: 'Begin');
4407: end if;
4408:
4409:

Line 4416: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

4412: from fnd_user
4413: where user_name = x_user_name;
4414:
4415: if (l_user_guid is null) then
4416: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
4417: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
4418: 'Not a SSO user - no user_guid found');
4419: end if;
4420: return null;

Line 4417: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

4413: where user_name = x_user_name;
4414:
4415: if (l_user_guid is null) then
4416: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
4417: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
4418: 'Not a SSO user - no user_guid found');
4419: end if;
4420: return null;
4421: end if;

Line 4426: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

4422:
4423: -- Only check the profile and expiration if password is not null
4424: l_pwd := x_unencrypted_password;
4425: if (x_unencrypted_password is not null) then
4426: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
4427: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
4428: 'Password is not null' );
4429: end if;
4430: -- Bug 5161497

Line 4427: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

4423: -- Only check the profile and expiration if password is not null
4424: l_pwd := x_unencrypted_password;
4425: if (x_unencrypted_password is not null) then
4426: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
4427: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
4428: 'Password is not null' );
4429: end if;
4430: -- Bug 5161497
4431: -- If profile is not set or case insensitive, then password passed to

Line 4454: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

4450: end if; -- End if x_unencrypted_password is not null
4451:
4452: begin
4453:
4454: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
4455: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
4456: 'Now call to fnd_ldap_wrapper.update_user');
4457: end if;
4458:

Line 4455: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

4451:
4452: begin
4453:
4454: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
4455: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
4456: 'Now call to fnd_ldap_wrapper.update_user');
4457: end if;
4458:
4459: fnd_ldap_wrapper.update_user(l_user_guid, x_user_name,

Line 4513: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

4509: l_expire_pwd pls_integer;
4510: l_api_name varchar2(256) := 'ldap_wrapper_udpate_user';
4511: begin
4512:
4513: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
4514: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head||'.'||l_api_name,
4515: 'Begin - set l_expire_pwd before calling fnd_ldap_wrapper');
4516: end if;
4517:

Line 4514: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head||'.'||l_api_name,

4510: l_api_name varchar2(256) := 'ldap_wrapper_udpate_user';
4511: begin
4512:
4513: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
4514: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head||'.'||l_api_name,
4515: 'Begin - set l_expire_pwd before calling fnd_ldap_wrapper');
4516: end if;
4517:
4518: -- Bug 13472484 - Using global when called from fnd_web_sec.change_password

Line 4529: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

4525: else
4526: l_expire_pwd := x_expire_pwd;
4527: end if;
4528:
4529: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
4530: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head||l_api_name,
4531: 'l_expire_pwd = '||l_expire_pwd);
4532: end if;
4533:

Line 4530: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head||l_api_name,

4526: l_expire_pwd := x_expire_pwd;
4527: end if;
4528:
4529: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
4530: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head||l_api_name,
4531: 'l_expire_pwd = '||l_expire_pwd);
4532: end if;
4533:
4534:

Line 4545: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

4541: -- If the return password from ldap is not null, that means ldap
4542: -- is informing us that this user is externally managed so we need
4543: -- to update the password to EXTERNAL.
4544:
4545: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
4546: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head||'.'||l_api_name,
4547: 'set fnd_user pwd to be EXTERNALLY managed. l_pwd_ret = '||l_pwd_ret);
4548: end if;
4549:

Line 4546: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head||'.'||l_api_name,

4542: -- is informing us that this user is externally managed so we need
4543: -- to update the password to EXTERNAL.
4544:
4545: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
4546: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head||'.'||l_api_name,
4547: 'set fnd_user pwd to be EXTERNALLY managed. l_pwd_ret = '||l_pwd_ret);
4548: end if;
4549:
4550: update fnd_user