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_OID_UTIL dependencies on FND_USER

Line 91: from fnd_user

87: null, decode(customer_id, null, 'FND', 'TCA'),
88: 'HR'),
89: user_id, start_date, end_date
90: into my_flavor, my_userid, my_start, my_end
91: from fnd_user
92: where user_name = p_username;
93: exception
94: when no_data_found then
95: my_flavor := 'FND';

Line 372: function get_fnd_user(p_user_guid in varchar2)

368: return null;
369: end get_ldap_event_status_str;
370: --
371: -------------------------------------------------------------------------------
372: function get_fnd_user(p_user_guid in varchar2)
373: return apps_user_key_type is
374:
375:
376: cursor cur_fnd_users is

Line 376: cursor cur_fnd_users is

372: function get_fnd_user(p_user_guid in varchar2)
373: return apps_user_key_type is
374:
375:
376: cursor cur_fnd_users is
377: select user_id, user_name, user_guid, person_party_id
378: from fnd_user
379: where user_guid = hextoraw(p_user_guid);
380:

Line 378: from fnd_user

374:
375:
376: cursor cur_fnd_users is
377: select user_id, user_name, user_guid, person_party_id
378: from fnd_user
379: where user_guid = hextoraw(p_user_guid);
380:
381: l_module_source varchar2(256);
382: l_apps_user_key apps_user_key_type;

Line 386: l_module_source := G_MODULE_SOURCE || 'get_fnd_user: ';

382: l_apps_user_key apps_user_key_type;
383: l_found boolean;
384:
385: begin
386: l_module_source := G_MODULE_SOURCE || 'get_fnd_user: ';
387: l_found := false;
388:
389: open cur_fnd_users;
390: fetch cur_fnd_users into l_apps_user_key.user_id, l_apps_user_key.user_name

Line 389: open cur_fnd_users;

385: begin
386: l_module_source := G_MODULE_SOURCE || 'get_fnd_user: ';
387: l_found := false;
388:
389: open cur_fnd_users;
390: fetch cur_fnd_users into l_apps_user_key.user_id, l_apps_user_key.user_name
391: , l_apps_user_key.user_guid, l_apps_user_key.person_party_id;
392: l_found := cur_fnd_users%found;
393:

Line 390: fetch cur_fnd_users into l_apps_user_key.user_id, l_apps_user_key.user_name

386: l_module_source := G_MODULE_SOURCE || 'get_fnd_user: ';
387: l_found := false;
388:
389: open cur_fnd_users;
390: fetch cur_fnd_users into l_apps_user_key.user_id, l_apps_user_key.user_name
391: , l_apps_user_key.user_guid, l_apps_user_key.person_party_id;
392: l_found := cur_fnd_users%found;
393:
394: if (not l_found)

Line 392: l_found := cur_fnd_users%found;

388:
389: open cur_fnd_users;
390: fetch cur_fnd_users into l_apps_user_key.user_id, l_apps_user_key.user_name
391: , l_apps_user_key.user_guid, l_apps_user_key.person_party_id;
392: l_found := cur_fnd_users%found;
393:
394: if (not l_found)
395: then
396: l_apps_user_key.user_guid := null;

Line 401: close cur_fnd_users;

397: l_apps_user_key.user_id := null;
398: l_apps_user_key.user_name := null;
399: l_apps_user_key.person_party_id := null;
400: end if;
401: close cur_fnd_users;
402:
403: return (l_apps_user_key);
404:
405: exception

Line 407: if (cur_fnd_users%isopen)

403: return (l_apps_user_key);
404:
405: exception
406: when others then
407: if (cur_fnd_users%isopen)
408: then
409: close cur_fnd_users;
410: end if;
411:

Line 409: close cur_fnd_users;

405: exception
406: when others then
407: if (cur_fnd_users%isopen)
408: then
409: close cur_fnd_users;
410: end if;
411:
412: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
413: then

Line 419: end get_fnd_user;

415: end if;
416:
417: raise;
418: return null;
419: end get_fnd_user;
420: --
421: -------------------------------------------------------------------------------
422: function get_fnd_user(p_user_name in varchar2)
423: return apps_user_key_type is

Line 422: function get_fnd_user(p_user_name in varchar2)

418: return null;
419: end get_fnd_user;
420: --
421: -------------------------------------------------------------------------------
422: function get_fnd_user(p_user_name in varchar2)
423: return apps_user_key_type is
424:
425:
426: cursor cur_fnd_users is

Line 426: cursor cur_fnd_users is

422: function get_fnd_user(p_user_name in varchar2)
423: return apps_user_key_type is
424:
425:
426: cursor cur_fnd_users is
427: select user_id, user_name, user_guid, person_party_id
428: from fnd_user
429: where user_name = upper(p_user_name);
430:

Line 428: from fnd_user

424:
425:
426: cursor cur_fnd_users is
427: select user_id, user_name, user_guid, person_party_id
428: from fnd_user
429: where user_name = upper(p_user_name);
430:
431: l_module_source varchar2(256);
432: l_apps_user_key apps_user_key_type;

Line 436: l_module_source := G_MODULE_SOURCE || 'get_fnd_user: ';

432: l_apps_user_key apps_user_key_type;
433: l_found boolean;
434:
435: begin
436: l_module_source := G_MODULE_SOURCE || 'get_fnd_user: ';
437: l_found := false;
438:
439: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
440: then

Line 446: open cur_fnd_users;

442: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
443: , 'p_user_name = ' || p_user_name);
444: end if;
445:
446: open cur_fnd_users;
447: fetch cur_fnd_users into l_apps_user_key.user_id, l_apps_user_key.user_name
448: , l_apps_user_key.user_guid, l_apps_user_key.person_party_id;
449: l_found := cur_fnd_users%found;
450:

Line 447: fetch cur_fnd_users into l_apps_user_key.user_id, l_apps_user_key.user_name

443: , 'p_user_name = ' || p_user_name);
444: end if;
445:
446: open cur_fnd_users;
447: fetch cur_fnd_users into l_apps_user_key.user_id, l_apps_user_key.user_name
448: , l_apps_user_key.user_guid, l_apps_user_key.person_party_id;
449: l_found := cur_fnd_users%found;
450:
451: if (not l_found)

Line 449: l_found := cur_fnd_users%found;

445:
446: open cur_fnd_users;
447: fetch cur_fnd_users into l_apps_user_key.user_id, l_apps_user_key.user_name
448: , l_apps_user_key.user_guid, l_apps_user_key.person_party_id;
449: l_found := cur_fnd_users%found;
450:
451: if (not l_found)
452: then
453: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 470: close cur_fnd_users;

466: ,'User found: user_guid: '||l_apps_user_key.user_guid ||
467: ' user_name: '||l_apps_user_key.user_name);
468: end if;
469: end if;
470: close cur_fnd_users;
471:
472: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
473: then
474: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');

Line 481: if (cur_fnd_users%isopen)

477: return (l_apps_user_key);
478:
479: exception
480: when others then
481: if (cur_fnd_users%isopen)
482: then
483: close cur_fnd_users;
484: end if;
485:

Line 483: close cur_fnd_users;

479: exception
480: when others then
481: if (cur_fnd_users%isopen)
482: then
483: close cur_fnd_users;
484: end if;
485:
486: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
487: then

Line 493: end get_fnd_user;

489: end if;
490:
491: raise;
492: return null;
493: end get_fnd_user;
494: --
495: -------------------------------------------------------------------------------
496: function isUserEnabled(p_ldap_attr_list in ldap_attr_list) return boolean is
497:

Line 647: l_user_name fnd_user.user_name%type;

643: procedure process_identity_add(p_event in ldap_event) is
644:
645: l_module_source varchar2(256);
646: l_ldap_attr_list ldap_attr_list;
647: l_user_name fnd_user.user_name%type;
648: my_ent_type varchar2(50);
649: my_parms wf_parameter_list_t;
650: l_allow_identity_add varchar2(1);
651: l_profile_defined boolean;

Line 736: cursor cur_fnd_users(p_user_guid in varchar2) is

732: -------------------------------------------------------------------------------
733: -------------------------------------------------------------------------------
734: procedure process_identity_modify(p_event in ldap_event) is
735:
736: cursor cur_fnd_users(p_user_guid in varchar2) is
737: select user_name, user_id
738: from fnd_user
739: where user_guid = hextoraw(p_user_guid);
740:

Line 738: from fnd_user

734: procedure process_identity_modify(p_event in ldap_event) is
735:
736: cursor cur_fnd_users(p_user_guid in varchar2) is
737: select user_name, user_id
738: from fnd_user
739: where user_guid = hextoraw(p_user_guid);
740:
741: l_module_source varchar2(256);
742: l_profiles apps_sso_user_profiles_type;

Line 743: l_user_name fnd_user.user_name%type;

739: where user_guid = hextoraw(p_user_guid);
740:
741: l_module_source varchar2(256);
742: l_profiles apps_sso_user_profiles_type;
743: l_user_name fnd_user.user_name%type;
744: l_oid_user_name fnd_user.user_name%type;
745: l_user_id fnd_user.user_id%type;
746: l_ldap_attr_list ldap_attr_list;
747: l_count pls_integer:= 0;

Line 744: l_oid_user_name fnd_user.user_name%type;

740:
741: l_module_source varchar2(256);
742: l_profiles apps_sso_user_profiles_type;
743: l_user_name fnd_user.user_name%type;
744: l_oid_user_name fnd_user.user_name%type;
745: l_user_id fnd_user.user_id%type;
746: l_ldap_attr_list ldap_attr_list;
747: l_count pls_integer:= 0;
748:

Line 745: l_user_id fnd_user.user_id%type;

741: l_module_source varchar2(256);
742: l_profiles apps_sso_user_profiles_type;
743: l_user_name fnd_user.user_name%type;
744: l_oid_user_name fnd_user.user_name%type;
745: l_user_id fnd_user.user_id%type;
746: l_ldap_attr_list ldap_attr_list;
747: l_count pls_integer:= 0;
748:
749: begin

Line 762: open cur_fnd_users(p_event.object_guid);

758: , 'p_event = ' || get_ldap_event_str(p_event));
759: end if;
760:
761:
762: open cur_fnd_users(p_event.object_guid);
763: loop
764: fetch cur_fnd_users into l_user_name, l_user_id;
765: exit when cur_fnd_users%notfound;
766: l_count := l_count+1;

Line 764: fetch cur_fnd_users into l_user_name, l_user_id;

760:
761:
762: open cur_fnd_users(p_event.object_guid);
763: loop
764: fetch cur_fnd_users into l_user_name, l_user_id;
765: exit when cur_fnd_users%notfound;
766: l_count := l_count+1;
767:
768: l_profiles := fnd_ldap_mapper.map_sso_user_profiles(l_user_name);

Line 765: exit when cur_fnd_users%notfound;

761:
762: open cur_fnd_users(p_event.object_guid);
763: loop
764: fetch cur_fnd_users into l_user_name, l_user_id;
765: exit when cur_fnd_users%notfound;
766: l_count := l_count+1;
767:
768: l_profiles := fnd_ldap_mapper.map_sso_user_profiles(l_user_name);
769: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 797: close cur_fnd_users;

793: upper(l_user_name), null, null);
794:
795: end if;
796: end loop;
797: close cur_fnd_users;
798:
799: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)THEN
800: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
801: , 'events risen:'||l_count);

Line 812: if (cur_fnd_users%isopen)

808: end if;
809:
810: exception
811: when others then
812: if (cur_fnd_users%isopen)
813: then
814: close cur_fnd_users;
815: end if;
816:

Line 814: close cur_fnd_users;

810: exception
811: when others then
812: if (cur_fnd_users%isopen)
813: then
814: close cur_fnd_users;
815: end if;
816:
817: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
818: then

Line 829: cursor cur_fnd_users(p_user_guid in varchar2) is

825: --
826: -------------------------------------------------------------------------------
827: procedure process_identity_delete(p_event in ldap_event) is
828:
829: cursor cur_fnd_users(p_user_guid in varchar2) is
830: select user_name, user_id
831: from fnd_user
832: where user_guid = hextoraw(p_user_guid);
833:

Line 831: from fnd_user

827: procedure process_identity_delete(p_event in ldap_event) is
828:
829: cursor cur_fnd_users(p_user_guid in varchar2) is
830: select user_name, user_id
831: from fnd_user
832: where user_guid = hextoraw(p_user_guid);
833:
834: l_module_source varchar2(256);
835: l_profiles apps_sso_user_profiles_type;

Line 836: l_user_name fnd_user.user_name%type;

832: where user_guid = hextoraw(p_user_guid);
833:
834: l_module_source varchar2(256);
835: l_profiles apps_sso_user_profiles_type;
836: l_user_name fnd_user.user_name%type;
837: l_user_id fnd_user.user_id%type;
838: my_parms wf_parameter_list_t;
839:
840: begin

Line 837: l_user_id fnd_user.user_id%type;

833:
834: l_module_source varchar2(256);
835: l_profiles apps_sso_user_profiles_type;
836: l_user_name fnd_user.user_name%type;
837: l_user_id fnd_user.user_id%type;
838: my_parms wf_parameter_list_t;
839:
840: begin
841: l_module_source := G_MODULE_SOURCE || 'process_identity_delete: ';

Line 856: open cur_fnd_users(p_event.object_guid);

852: then
853: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,'Get users');
854: end if;
855:
856: open cur_fnd_users(p_event.object_guid);
857: loop
858: fetch cur_fnd_users into l_user_name, l_user_id;
859: exit when cur_fnd_users%notfound;
860:

Line 858: fetch cur_fnd_users into l_user_name, l_user_id;

854: end if;
855:
856: open cur_fnd_users(p_event.object_guid);
857: loop
858: fetch cur_fnd_users into l_user_name, l_user_id;
859: exit when cur_fnd_users%notfound;
860:
861: l_profiles := fnd_ldap_mapper.map_sso_user_profiles(l_user_name);
862:

Line 859: exit when cur_fnd_users%notfound;

855:
856: open cur_fnd_users(p_event.object_guid);
857: loop
858: fetch cur_fnd_users into l_user_name, l_user_id;
859: exit when cur_fnd_users%notfound;
860:
861: l_profiles := fnd_ldap_mapper.map_sso_user_profiles(l_user_name);
862:
863: if ( (l_profiles.ldap_sync = G_Y)

Line 911: -- don't call fnd_user_pkg.DisableUser(), it'd fail because user is deleted on OID

907: then
908: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,'Unlink user');
909: end if;
910:
911: -- don't call fnd_user_pkg.DisableUser(), it'd fail because user is deleted on OID
912:
913: -- Bug 13829710: Moved the end dating of the user to the fnd_oid_subscriptions.identity_delete
914: -- Nulling out of user_guid should occur regardless
915: update fnd_user

Line 915: update fnd_user

911: -- don't call fnd_user_pkg.DisableUser(), it'd fail because user is deleted on OID
912:
913: -- Bug 13829710: Moved the end dating of the user to the fnd_oid_subscriptions.identity_delete
914: -- Nulling out of user_guid should occur regardless
915: update fnd_user
916: set user_guid = null
917: where user_name = l_user_name;
918:
919: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 926: close cur_fnd_users;

922: end if;
923:
924: end if;
925: end loop;
926: close cur_fnd_users;
927:
928: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
929: then
930: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source

Line 936: if (cur_fnd_users%isopen)

932: end if;
933:
934: exception
935: when others then
936: if (cur_fnd_users%isopen)
937: then
938: close cur_fnd_users;
939: end if;
940:

Line 938: close cur_fnd_users;

934: exception
935: when others then
936: if (cur_fnd_users%isopen)
937: then
938: close cur_fnd_users;
939: end if;
940:
941: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
942: then

Line 954: l_user_name fnd_user.user_name%type;

950: procedure process_subscription_add(p_event in ldap_event) is
951:
952: l_module_source varchar2(256);
953: l_ldap_attr_list ldap_attr_list;
954: l_user_name fnd_user.user_name%type;
955: my_ent_type varchar2(50);
956: my_parms wf_parameter_list_t;
957:
958: begin

Line 1052: p_user_name in fnd_user.user_name%type

1048: end process_subscription_delete;
1049: --
1050: -------------------------------------------------------------------------------
1051: procedure synch_user_from_LDAP(
1052: p_user_name in fnd_user.user_name%type
1053: , p_result out nocopy pls_integer
1054: ) is
1055: l_module_source varchar2(256);
1056: l_apps_user_key apps_user_key_type;

Line 1057: l_user_name fnd_user.user_name%type;

1053: , p_result out nocopy pls_integer
1054: ) is
1055: l_module_source varchar2(256);
1056: l_apps_user_key apps_user_key_type;
1057: l_user_name fnd_user.user_name%type;
1058: l_ldap_attr_list ldap_attr_list;
1059: l_ldap_message fnd_oid_util.ldap_message_type;
1060: l_return_status varchar2(1);
1061:

Line 1077: l_apps_user_key := fnd_oid_util.get_fnd_user(p_user_name => l_user_name);

1073: raise user_name_null_exp;
1074: end if;
1075:
1076: l_user_name := p_user_name;
1077: l_apps_user_key := fnd_oid_util.get_fnd_user(p_user_name => l_user_name);
1078:
1079: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1080: then
1081: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,

Line 1128: 'Person Party exists in FND_USER for user:'||l_apps_user_key.user_name);

1124: then
1125: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1126: then
1127: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
1128: 'Person Party exists in FND_USER for user:'||l_apps_user_key.user_name);
1129: end if;
1130: fnd_oid_users.hz_update(
1131: p_ldap_message => l_ldap_message
1132: , x_return_status => l_return_status);

Line 1143: 'Person Party does NOT exist in FND_USER for user:'||l_apps_user_key.user_name||', creating a new TCA entry');

1139: else
1140: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1141: then
1142: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
1143: 'Person Party does NOT exist in FND_USER for user:'||l_apps_user_key.user_name||', creating a new TCA entry');
1144: end if;
1145: if (isTCAenabled('ADD')) then
1146: fnd_oid_users.hz_create(
1147: p_ldap_message => l_ldap_message

Line 1198: p_user_name in fnd_user.user_name%type

1194: end synch_user_from_LDAP;
1195: --
1196: -------------------------------------------------------------------------------
1197: procedure synch_user_from_LDAP_NO_AUTO(
1198: p_user_name in fnd_user.user_name%type
1199: , p_result out nocopy pls_integer
1200: ) is
1201: l_module_source varchar2(256);
1202: l_apps_user_key apps_user_key_type;

Line 1203: l_user_name fnd_user.user_name%type;

1199: , p_result out nocopy pls_integer
1200: ) is
1201: l_module_source varchar2(256);
1202: l_apps_user_key apps_user_key_type;
1203: l_user_name fnd_user.user_name%type;
1204: l_ldap_attr_list ldap_attr_list;
1205: l_ldap_message fnd_oid_util.ldap_message_type;
1206: l_return_status varchar2(1);
1207: begin

Line 1221: l_apps_user_key := fnd_oid_util.get_fnd_user(p_user_name => l_user_name);

1217: raise user_name_null_exp;
1218: end if;
1219:
1220: l_user_name := p_user_name;
1221: l_apps_user_key := fnd_oid_util.get_fnd_user(p_user_name => l_user_name);
1222:
1223: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1224: then
1225: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,

Line 1272: 'Person Party exists in FND_USER for user:'||l_apps_user_key.user_name);

1268: then
1269: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1270: then
1271: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
1272: 'Person Party exists in FND_USER for user:'||l_apps_user_key.user_name);
1273: end if;
1274: fnd_oid_users.hz_update(
1275: p_ldap_message => l_ldap_message
1276: , x_return_status => l_return_status);

Line 1287: 'Person Party does NOT exist in FND_USER for user:'||l_apps_user_key.user_name||', creating a new TCA entry');

1283: else
1284: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1285: then
1286: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
1287: 'Person Party does NOT exist in FND_USER for user:'||l_apps_user_key.user_name||', creating a new TCA entry');
1288: end if;
1289: if (isTCAenabled('ADD')) then
1290: fnd_oid_users.hz_create(
1291: p_ldap_message => l_ldap_message

Line 1342: cursor cur_fnd_users is

1338: p_user_name in varchar2,
1339: p_user_guid in varchar2
1340: ) is
1341:
1342: cursor cur_fnd_users is
1343: select user_id, start_date, end_date, encrypted_user_password
1344: from fnd_user
1345: where user_name = p_user_name
1346: and (user_guid is NULL or user_guid = hextoraw(p_user_guid))

Line 1344: from fnd_user

1340: ) is
1341:
1342: cursor cur_fnd_users is
1343: select user_id, start_date, end_date, encrypted_user_password
1344: from fnd_user
1345: where user_name = p_user_name
1346: and (user_guid is NULL or user_guid = hextoraw(p_user_guid))
1347: and sysdate >= start_date
1348: and (end_date is NULL or end_date > sysdate);

Line 1357: l_user_name fnd_user.user_name%type;

1353: l_result pls_integer;
1354: l_sub_add_result pls_integer;
1355: l_ldap_attr_list ldap_attr_list;
1356: l_ldap_message ldap_message_type;
1357: l_user_name fnd_user.user_name%type;
1358: l_rec cur_fnd_users%rowtype;
1359: l_found boolean;
1360: l_local_login varchar2(10);
1361: l_profile_defined boolean;

Line 1358: l_rec cur_fnd_users%rowtype;

1354: l_sub_add_result pls_integer;
1355: l_ldap_attr_list ldap_attr_list;
1356: l_ldap_message ldap_message_type;
1357: l_user_name fnd_user.user_name%type;
1358: l_rec cur_fnd_users%rowtype;
1359: l_found boolean;
1360: l_local_login varchar2(10);
1361: l_profile_defined boolean;
1362: l_user_id number;

Line 1410: open cur_fnd_users;

1406: then
1407: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'After calling map_ldap_message');
1408: end if;
1409:
1410: open cur_fnd_users;
1411: fetch cur_fnd_users into l_rec;
1412: l_found := cur_fnd_users%found;
1413: close cur_fnd_users;
1414:

Line 1411: fetch cur_fnd_users into l_rec;

1407: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'After calling map_ldap_message');
1408: end if;
1409:
1410: open cur_fnd_users;
1411: fetch cur_fnd_users into l_rec;
1412: l_found := cur_fnd_users%found;
1413: close cur_fnd_users;
1414:
1415: if (l_found)

Line 1412: l_found := cur_fnd_users%found;

1408: end if;
1409:
1410: open cur_fnd_users;
1411: fetch cur_fnd_users into l_rec;
1412: l_found := cur_fnd_users%found;
1413: close cur_fnd_users;
1414:
1415: if (l_found)
1416: then

Line 1413: close cur_fnd_users;

1409:
1410: open cur_fnd_users;
1411: fetch cur_fnd_users into l_rec;
1412: l_found := cur_fnd_users%found;
1413: close cur_fnd_users;
1414:
1415: if (l_found)
1416: then
1417: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 1434: fnd_user_pkg.UpdateUser(

1430: if(l_local_login <>G_LOCAL)
1431: then
1432: if(l_local_login = G_SSO)
1433: then
1434: fnd_user_pkg.UpdateUser(
1435: x_user_name=>p_user_name
1436: , x_owner=>null
1437: , x_unencrypted_password=>fnd_web_sec.EXTERNAL_PWD
1438: , x_email_address => l_ldap_message.mail

Line 1441: , x_change_source => fnd_user_pkg.change_source_oid

1437: , x_unencrypted_password=>fnd_web_sec.EXTERNAL_PWD
1438: , x_email_address => l_ldap_message.mail
1439: , x_fax => l_ldap_message.facsimileTelephoneNumber
1440: , x_user_guid=>p_user_guid
1441: , x_change_source => fnd_user_pkg.change_source_oid
1442: );
1443:
1444: else
1445: fnd_user_pkg.UpdateUser(

Line 1445: fnd_user_pkg.UpdateUser(

1441: , x_change_source => fnd_user_pkg.change_source_oid
1442: );
1443:
1444: else
1445: fnd_user_pkg.UpdateUser(
1446: x_user_name=>p_user_name
1447: , x_owner=>null
1448: , x_email_address => l_ldap_message.mail
1449: , x_fax => l_ldap_message.facsimileTelephoneNumber

Line 1451: , x_change_source => fnd_user_pkg.change_source_oid

1447: , x_owner=>null
1448: , x_email_address => l_ldap_message.mail
1449: , x_fax => l_ldap_message.facsimileTelephoneNumber
1450: , x_user_guid=>p_user_guid
1451: , x_change_source => fnd_user_pkg.change_source_oid
1452: );
1453: end if;
1454: end if;
1455: else

Line 1461: l_user_id := fnd_user_pkg.CreateUserId(

1457: then
1458: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Could not find a linkable user: ');
1459: end if;
1460: -- Changed to CreateUserId - we need the user_id to set the profile.
1461: l_user_id := fnd_user_pkg.CreateUserId(
1462: x_user_name=>p_user_name
1463: , x_owner=>null
1464: , x_unencrypted_password=>fnd_web_sec.EXTERNAL_PWD
1465: , x_email_address => l_ldap_message.mail

Line 1468: , x_change_source => fnd_user_pkg.change_source_oid

1464: , x_unencrypted_password=>fnd_web_sec.EXTERNAL_PWD
1465: , x_email_address => l_ldap_message.mail
1466: , x_fax => l_ldap_message.facsimileTelephoneNumber
1467: , x_user_guid=>p_user_guid
1468: , x_change_source => fnd_user_pkg.change_source_oid
1469: );
1470:
1471: -- Bug 4880490 New users should have the local login profile set to SSO
1472: l_found := fnd_profile.save(x_name => 'APPS_SSO_LOCAL_LOGIN'

Line 1520: if (cur_fnd_users%isopen)

1516: then
1517: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source
1518: , 'Cannot call on_demand_user_create will null GUID');
1519: end if;
1520: if (cur_fnd_users%isopen)
1521: then
1522: close cur_fnd_users;
1523: end if;
1524: raise;

Line 1522: close cur_fnd_users;

1518: , 'Cannot call on_demand_user_create will null GUID');
1519: end if;
1520: if (cur_fnd_users%isopen)
1521: then
1522: close cur_fnd_users;
1523: end if;
1524: raise;
1525:
1526: when user_name_null_exp then

Line 1532: if (cur_fnd_users%isopen)

1528: then
1529: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source
1530: , 'Cannot call on_demand_user_create will null username');
1531: end if;
1532: if (cur_fnd_users%isopen)
1533: then
1534: close cur_fnd_users;
1535: end if;
1536: raise;

Line 1534: close cur_fnd_users;

1530: , 'Cannot call on_demand_user_create will null username');
1531: end if;
1532: if (cur_fnd_users%isopen)
1533: then
1534: close cur_fnd_users;
1535: end if;
1536: raise;
1537:
1538: when others then

Line 1543: if (cur_fnd_users%isopen)

1539: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1540: then
1541: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
1542: end if;
1543: if (cur_fnd_users%isopen)
1544: then
1545: close cur_fnd_users;
1546: end if;
1547:

Line 1545: close cur_fnd_users;

1541: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
1542: end if;
1543: if (cur_fnd_users%isopen)
1544: then
1545: close cur_fnd_users;
1546: end if;
1547:
1548: raise;
1549: end on_demand_user_create;

Line 1576: -- Get the fnd_user.user_name

1572: elsif (p_event_status.error_disposition = wf_oid.EVENT_RESEND)
1573: then
1574: l_event_name := 'oracle.apps.fnd.oidsync.resend';
1575: end if;
1576: -- Get the fnd_user.user_name
1577: fnd_oid_util.get_entity_key_value(p_event_status.event_id
1578: , l_entity_key_value);
1579:
1580: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 1978: function get_oid_nickname(p_user_guid in fnd_user.user_guid%type)

1974:
1975: end get_entity_changes_rec_str;
1976: --
1977: -------------------------------------------------------------------------------
1978: function get_oid_nickname(p_user_guid in fnd_user.user_guid%type)
1979: return varchar2 is
1980:
1981: l_module_source varchar2(256);
1982: result pls_integer;

Line 2034: l_apps_user_key := get_fnd_user(p_user_name => p_user_name);

2030: then
2031: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
2032: end if;
2033:
2034: l_apps_user_key := get_fnd_user(p_user_name => p_user_name);
2035:
2036: if (l_apps_user_key.person_party_id is not null)
2037: then
2038: l_retval := true;

Line 2108: fnd_user.user_guid%type,ldapSession in dbms_ldap.session) return BOOLEAN

2104: end set_ldap_message_attr;
2105: --
2106: -------------------------------------------------------------------------------
2107: function is_guid_already_subscribed(p_orclguid in
2108: fnd_user.user_guid%type,ldapSession in dbms_ldap.session) return BOOLEAN
2109: is
2110: l_module_source varchar(256);
2111: l_attrs dbms_ldap.string_collection;
2112: subsNode varchar2(1000);

Line 2188: procedure add_user_to_OID_sub_list(p_orclguid in fnd_user.user_guid%type, x_result out nocopy pls_integer) is

2184: return FALSE;
2185: end;
2186:
2187:
2188: procedure add_user_to_OID_sub_list(p_orclguid in fnd_user.user_guid%type, x_result out nocopy pls_integer) is
2189:
2190: l_module_source varchar2(256);
2191: usersDN varchar2(1000);
2192: subsNode varchar2(1000);

Line 2326: (p_orcl_guid fnd_user.user_guid%type)

2322: end add_user_to_OID_sub_list;
2323: --
2324: -------------------------------------------------------------------------------
2325: procedure send_subscription_add_to_OID
2326: (p_orcl_guid fnd_user.user_guid%type)
2327: is
2328: l_module_source varchar2(256);
2329: l_apps_user_key apps_user_key_type;
2330: l_user_name fnd_user.user_name%type;

Line 2330: l_user_name fnd_user.user_name%type;

2326: (p_orcl_guid fnd_user.user_guid%type)
2327: is
2328: l_module_source varchar2(256);
2329: l_apps_user_key apps_user_key_type;
2330: l_user_name fnd_user.user_name%type;
2331: my_parms wf_parameter_list_t;
2332: begin
2333: l_module_source := G_MODULE_SOURCE || 'send_subscription_add_to_OID: ';
2334:

Line 2340: -- Cache attributes are queried in wf_oid.GetAppEvent based on FND user_name

2336: then
2337: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
2338: , 'Begin');
2339: end if;
2340: -- Cache attributes are queried in wf_oid.GetAppEvent based on FND user_name
2341: l_apps_user_key:= get_fnd_user(p_user_guid => p_orcl_guid);
2342: l_user_name := l_apps_user_key.user_name;
2343: if (l_user_name is null) then
2344: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 2341: l_apps_user_key:= get_fnd_user(p_user_guid => p_orcl_guid);

2337: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
2338: , 'Begin');
2339: end if;
2340: -- Cache attributes are queried in wf_oid.GetAppEvent based on FND user_name
2341: l_apps_user_key:= get_fnd_user(p_user_guid => p_orcl_guid);
2342: l_user_name := l_apps_user_key.user_name;
2343: if (l_user_name is null) then
2344: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
2345: then

Line 2348: 'does not exist in FND_USER');

2344: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
2345: then
2346: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
2347: , 'Cannot send SUBSCRIPTION_ADD to OID because user ' ||
2348: 'does not exist in FND_USER');
2349: end if;
2350: return;
2351: end if;
2352: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)