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

APPS.FND_LDAP_USER dependencies on FND_USER

Line 17: procedure decode_dates(p_user_name in varchar2, p_start_date in date default null, p_end_date in date default null, x_orclisEnabled out nocopy varchar2, x_user_id out nocopy fnd_user.user_id%type);

13: -------------------------------------------------------------------------------
14:
15: function create_user_nodes(p_ldap_session in dbms_ldap.session, p_mod_array in dbms_ldap.mod_array, p_ldap_user in fnd_ldap_util.ldap_user_type,userDN out nocopy varchar2) return pls_integer ;
16: function create_user_subscription(p_guid in raw) return pls_integer;
17: procedure decode_dates(p_user_name in varchar2, p_start_date in date default null, p_end_date in date default null, x_orclisEnabled out nocopy varchar2, x_user_id out nocopy fnd_user.user_id%type);
18: function delete_user_by_name(p_ldap_session in dbms_ldap.session, p_cn in varchar2) return pls_integer;
19: function delete_user_nodes(p_ldap_session in dbms_ldap.session, p_orclguid in fnd_user.user_guid%type) return pls_integer;
20: function delete_user_subscription(p_ldap_session in dbms_ldap.session, guid raw) return pls_integer;
21: function delete_uniquemember(p_ldap_session in dbms_ldap.session, p_orclguid in fnd_user.user_guid%type) return pls_integer;

Line 19: function delete_user_nodes(p_ldap_session in dbms_ldap.session, p_orclguid in fnd_user.user_guid%type) return pls_integer;

15: function create_user_nodes(p_ldap_session in dbms_ldap.session, p_mod_array in dbms_ldap.mod_array, p_ldap_user in fnd_ldap_util.ldap_user_type,userDN out nocopy varchar2) return pls_integer ;
16: function create_user_subscription(p_guid in raw) return pls_integer;
17: procedure decode_dates(p_user_name in varchar2, p_start_date in date default null, p_end_date in date default null, x_orclisEnabled out nocopy varchar2, x_user_id out nocopy fnd_user.user_id%type);
18: function delete_user_by_name(p_ldap_session in dbms_ldap.session, p_cn in varchar2) return pls_integer;
19: function delete_user_nodes(p_ldap_session in dbms_ldap.session, p_orclguid in fnd_user.user_guid%type) return pls_integer;
20: function delete_user_subscription(p_ldap_session in dbms_ldap.session, guid raw) return pls_integer;
21: function delete_uniquemember(p_ldap_session in dbms_ldap.session, p_orclguid in fnd_user.user_guid%type) return pls_integer;
22: procedure disable_user(p_user_guid in raw,p_user_name in varchar2,x_result out nocopy pls_integer);
23: function process_attributes(p_ldap_user in fnd_ldap_util.ldap_user_type,

Line 21: function delete_uniquemember(p_ldap_session in dbms_ldap.session, p_orclguid in fnd_user.user_guid%type) return pls_integer;

17: procedure decode_dates(p_user_name in varchar2, p_start_date in date default null, p_end_date in date default null, x_orclisEnabled out nocopy varchar2, x_user_id out nocopy fnd_user.user_id%type);
18: function delete_user_by_name(p_ldap_session in dbms_ldap.session, p_cn in varchar2) return pls_integer;
19: function delete_user_nodes(p_ldap_session in dbms_ldap.session, p_orclguid in fnd_user.user_guid%type) return pls_integer;
20: function delete_user_subscription(p_ldap_session in dbms_ldap.session, guid raw) return pls_integer;
21: function delete_uniquemember(p_ldap_session in dbms_ldap.session, p_orclguid in fnd_user.user_guid%type) return pls_integer;
22: procedure disable_user(p_user_guid in raw,p_user_name in varchar2,x_result out nocopy pls_integer);
23: function process_attributes(p_ldap_user in fnd_ldap_util.ldap_user_type,
24: p_operation_type in pls_integer default G_CREATE,
25: x_atts out nocopy dbms_ldap.string_collection,

Line 42: procedure delete_user(ldapSession in dbms_ldap.session, p_user_guid in fnd_user.user_guid%type ,

38: -- Will attempt to translate the sqlerrms from an dbms_ldap operation into a FND message
39:
40: -------------------------------------------------------------------------------
41:
42: procedure delete_user(ldapSession in dbms_ldap.session, p_user_guid in fnd_user.user_guid%type ,
43: x_result out nocopy pls_integer) is
44:
45:
46: l_module_source varchar2(256) := G_MODULE_SOURCE || 'delete_user: ';

Line 65: l_orclguid fnd_user.user_guid%type;

61: l_fnd_op pls_integer;
62: l_oid_op pls_integer;
63: sso_registration_failure exception;
64: -- l_apps_user_key_type fnd_oid_util.apps_user_key_type;
65: l_orclguid fnd_user.user_guid%type;
66: begin
67:
68: -- initializing
69: l_module_source := G_MODULE_SOURCE || 'delete_user: ';

Line 77: --scheruku :: Added logic to get orclguid from fnd_user

73: then
74: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
75: end if;
76:
77: --scheruku :: Added logic to get orclguid from fnd_user
78: -- l_apps_user_key_type := fnd_oid_util.get_fnd_user(p_user_name => p_user_name);
79: -- l_orclguid := l_apps_user_key_type.user_guid;
80: l_orclguid := p_user_guid;
81:

Line 78: -- l_apps_user_key_type := fnd_oid_util.get_fnd_user(p_user_name => p_user_name);

74: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
75: end if;
76:
77: --scheruku :: Added logic to get orclguid from fnd_user
78: -- l_apps_user_key_type := fnd_oid_util.get_fnd_user(p_user_name => p_user_name);
79: -- l_orclguid := l_apps_user_key_type.user_guid;
80: l_orclguid := p_user_guid;
81:
82: if(l_orclguid IS NULL)

Line 87: 'NULL guid in FND_USER');

83: then
84: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
85: then
86: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
87: 'NULL guid in FND_USER');
88: end if;
89: x_result := fnd_ldap_util.G_FAILURE;
90: else
91: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 94: 'FND_USER GUID::'||l_orclguid);

90: else
91: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
92: then
93: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
94: 'FND_USER GUID::'||l_orclguid);
95: end if;
96: l_filter := 'orclguid='||l_orclguid;
97: --ldapSession := fnd_ldap_util.get_oid_session;
98: --searchNodes := fnd_ldap_util.get_search_nodes;

Line 147: end if;-- fnd_user guid null check if block ends here

143: --x_result := fnd_ldap_util.unbind(ldapSession);
144: if (x_result = dbms_ldap.SUCCESS) then
145: x_result := fnd_ldap_util.G_SUCCESS;
146: end if;
147: end if;-- fnd_user guid null check if block ends here
148:
149: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
150: then
151: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');

Line 164: procedure delete_user(p_user_guid in fnd_user.user_guid%type ,

160: x_result := fnd_ldap_util.G_FAILURE;
161:
162: end delete_user;
163:
164: procedure delete_user(p_user_guid in fnd_user.user_guid%type ,
165: x_result out nocopy pls_integer) is
166:
167: ldapSession dbms_ldap.session;
168: dummy pls_integer;

Line 187: l_user_id fnd_user.user_id%type;

183:
184: usertype fnd_ldap_util.ldap_user_type;
185: l_module_source varchar2(256);
186: no_such_user_exp exception;
187: l_user_id fnd_user.user_id%type;
188: l_local_login varchar2(30);
189: l_allow_sync varchar2(1);
190: l_profile_defined boolean;
191: l_to_synch boolean;

Line 204: from fnd_user

200: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
201: end if;
202:
203: select user_id into l_user_id
204: from fnd_user
205: where user_name = p_user_name;
206:
207: l_to_synch := TRUE;
208:

Line 324: l_user_id fnd_user.user_id%type;

320: no_such_user_exp exception;
321: invalid_new_user_exp exception;
322: l_nickname varchar2(256);
323:
324: l_user_id fnd_user.user_id%type;
325: l_local_login varchar2(30);
326: l_allow_sync varchar2(1);
327: l_profile_defined boolean;
328: l_to_synch boolean;

Line 432: 'Nickname of the oid user for the old fnd username is same: '|| l_old_nick_name);

428: then
429: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
430: then
431: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
432: 'Nickname of the oid user for the old fnd username is same: '|| l_old_nick_name);
433: end if;
434:
435: l_new_user_name_exists := user_exists(p_user_name => p_new_user_name);
436:

Line 463: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Current FND_USER user_name '|| p_old_user_name);

459:
460: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
461: then
462: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Current Nickname: '|| l_old_nick_name);
463: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Current FND_USER user_name '|| p_old_user_name);
464: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
465: 'Nickname of the oid user for the old fnd username is not same: ');
466: end if;
467: if(l_old_nick_name = p_new_user_name)

Line 465: 'Nickname of the oid user for the old fnd username is not same: ');

461: then
462: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Current Nickname: '|| l_old_nick_name);
463: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Current FND_USER user_name '|| p_old_user_name);
464: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
465: 'Nickname of the oid user for the old fnd username is not same: ');
466: end if;
467: if(l_old_nick_name = p_new_user_name)
468: then
469: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 471: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Current OID nickname and new fnd username match '

467: if(l_old_nick_name = p_new_user_name)
468: then
469: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
470: then
471: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Current OID nickname and new fnd username match '
472: || l_old_nick_name);
473: end if;
474:
475: x_result := fnd_ldap_util.G_SUCCESS;

Line 479: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Current OID nickname and new fnd username dont match '

475: x_result := fnd_ldap_util.G_SUCCESS;
476: else --if(l_old_nick_name != p_new_user_name)
477: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
478: then
479: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Current OID nickname and new fnd username dont match '
480: || l_old_nick_name);
481: end if;
482:
483: l_new_user_name_exists := user_exists(p_user_name => p_new_user_name);

Line 489: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'New fnd user_name does not exist in OID ');

485: if(l_new_user_name_exists = FND_LDAP_UTIL.G_FALSE)
486: then
487: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
488: then
489: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'New fnd user_name does not exist in OID ');
490: end if;
491: x_result := fnd_ldap_util.G_SUCCESS;
492: else
493: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 495: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'New fnd user_name does exist in OID ');

491: x_result := fnd_ldap_util.G_SUCCESS;
492: else
493: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
494: then
495: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'New fnd user_name does exist in OID ');
496: end if;
497: raise invalid_new_user_exp;
498: end if;
499: end if;

Line 563: user_name fnd_user.user_name%type;

559: l_password varchar2(256);
560: l_enabled varchar2(30);
561: l_du_result pls_integer;
562: l_cp_result pls_integer;
563: user_name fnd_user.user_name%type;
564:
565: begin
566: l_module_source := G_MODULE_SOURCE || 'create_user: ';
567: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 700: l_orclguid fnd_user.user_guid%type;

696: l_att_values dbms_ldap.string_collection;
697: l_link varchar2(10);
698: l_profile_defined boolean;
699: l_nickname varchar2(256);
700: l_orclguid fnd_user.user_guid%type;
701: l_userDN varchar2(4000);
702: l_guid raw(16);
703: flag pls_integer;
704:

Line 833: user_name fnd_user.user_name%type;

829: retval pls_integer;
830: i number;
831: break pls_integer;
832: dn varchar2(1000);
833: user_name fnd_user.user_name%type;
834: --l_data varchar2(200);
835:
836: begin
837: l_module_source := G_MODULE_SOURCE || 'create_user_nodes: ';

Line 976: procedure decode_dates(p_user_name in varchar2, p_start_date in date, p_end_date in date, x_orclisEnabled out nocopy varchar2, x_user_id out nocopy fnd_user.user_id%type) is

972:
973: end create_user_subscription;
974: --
975: -------------------------------------------------------------------------------
976: procedure decode_dates(p_user_name in varchar2, p_start_date in date, p_end_date in date, x_orclisEnabled out nocopy varchar2, x_user_id out nocopy fnd_user.user_id%type) is
977:
978: cursor fnd_dates is
979: select user_id, decode(p_start_date, fnd_user_pkg.null_date, null,
980: null, start_date,

Line 979: select user_id, decode(p_start_date, fnd_user_pkg.null_date, null,

975: -------------------------------------------------------------------------------
976: procedure decode_dates(p_user_name in varchar2, p_start_date in date, p_end_date in date, x_orclisEnabled out nocopy varchar2, x_user_id out nocopy fnd_user.user_id%type) is
977:
978: cursor fnd_dates is
979: select user_id, decode(p_start_date, fnd_user_pkg.null_date, null,
980: null, start_date,
981: p_start_date) l_start_date,
982: decode(p_end_date, fnd_user_pkg.null_date, null,
983: null, end_date,

Line 982: decode(p_end_date, fnd_user_pkg.null_date, null,

978: cursor fnd_dates is
979: select user_id, decode(p_start_date, fnd_user_pkg.null_date, null,
980: null, start_date,
981: p_start_date) l_start_date,
982: decode(p_end_date, fnd_user_pkg.null_date, null,
983: null, end_date,
984: p_end_date) l_end_date
985: from fnd_user
986: where user_name = p_user_name;

Line 985: from fnd_user

981: p_start_date) l_start_date,
982: decode(p_end_date, fnd_user_pkg.null_date, null,
983: null, end_date,
984: p_end_date) l_end_date
985: from fnd_user
986: where user_name = p_user_name;
987:
988: l_rec fnd_dates%rowtype;
989: l_found boolean;

Line 990: l_user_id fnd_user.user_id%type;

986: where user_name = p_user_name;
987:
988: l_rec fnd_dates%rowtype;
989: l_found boolean;
990: l_user_id fnd_user.user_id%type;
991: l_start_date date;
992: l_end_date date;
993: l_module_source varchar2(256);
994: no_such_user_exp exception;

Line 1056: l_guid fnd_user.user_guid%type;

1052: result pls_integer;
1053: subsNode varchar2(1000);
1054: usersNode varchar2(1000);
1055: usersNodes dbms_ldap.string_collection;
1056: l_guid fnd_user.user_guid%type;
1057:
1058: begin
1059: l_module_source := G_MODULE_SOURCE || 'delete_user: ';
1060: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 1089: p_orclguid in fnd_user.user_guid%type) return pls_integer is

1085: --
1086: --Added by scheruku for Nickname changes
1087: -------------------------------------------------------------------------------
1088: function delete_user_nodes(p_ldap_session in dbms_ldap.session,
1089: p_orclguid in fnd_user.user_guid%type) return pls_integer is
1090:
1091: l_module_source varchar2(256);
1092: usersNode varchar2(1000);
1093: usersNodes dbms_ldap.string_collection;

Line 1161: p_orclguid in fnd_user.user_guid%type) return pls_integer is

1157: end delete_user_subscription;
1158: --
1159: -------------------------------------------------------------------------------
1160: function delete_uniquemember(p_ldap_session in dbms_ldap.session,
1161: p_orclguid in fnd_user.user_guid%type) return pls_integer is
1162:
1163: l_module_source varchar2(256);
1164: subsNode varchar2(1000);
1165: usersNode varchar2(1000);

Line 1224: l_user_id fnd_user.user_id%type;

1220:
1221: usertype fnd_ldap_util.ldap_user_type;
1222: l_module_source varchar2(256);
1223: no_such_user_exp exception;
1224: l_user_id fnd_user.user_id%type;
1225: l_local_login varchar2(30);
1226: l_allow_sync varchar2(1);
1227: l_profile_defined boolean;
1228: l_to_synch boolean;

Line 1489: ret fnd_user.user_guid%type;

1485:
1486: function get_user_guid( p_user_name in varchar2)
1487: return raw is
1488: l_ldap dbms_ldap.session;
1489: ret fnd_user.user_guid%type;
1490: dummy pls_integer;
1491: BEGIN
1492: l_ldap := fnd_ldap_util.c_get_oid_session(dummy);
1493: ret := get_user_guid(l_ldap,p_user_name);

Line 1508: l_orclguid fnd_user.user_guid%type;

1504:
1505: l_module_source varchar2(256);
1506: l_user_exists pls_integer;
1507: l_result pls_integer;
1508: l_orclguid fnd_user.user_guid%type;
1509: l_local_login varchar2(100);
1510: l_profile_defined boolean;
1511: l_nickname varchar2(256);
1512:

Line 1705: procedure unlink_user(p_user_guid in fnd_user.user_guid%type,

1701:
1702: end process_attributes;
1703: --
1704: -------------------------------------------------------------------------------
1705: procedure unlink_user(p_user_guid in fnd_user.user_guid%type,
1706: p_user_name in varchar2,
1707: x_result out nocopy pls_integer) is
1708:
1709: cursor linked_users is

Line 1711: from fnd_user

1707: x_result out nocopy pls_integer) is
1708:
1709: cursor linked_users is
1710: select user_name
1711: from fnd_user
1712: where user_guid = p_user_guid
1713: and user_name <> p_user_name;
1714:
1715: l_rec linked_users%rowtype;

Line 1743: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'No other FND users linked to this OID User');

1739: then
1740:
1741: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1742: then
1743: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'No other FND users linked to this OID User');
1744: end if;
1745: l_user_exists := user_exists_by_guid( p_user_guid);
1746:
1747: if (l_user_exists = fnd_ldap_util.G_SUCCESS) then

Line 1765: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Other FND users linked to this OID User');

1761: else
1762:
1763: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1764: then
1765: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Other FND users linked to this OID User');
1766: end if;
1767:
1768: x_result := fnd_ldap_util.G_FAILURE;
1769: fnd_message.set_name ('FND', 'FND_SSO_USER_MULT_LINKED');

Line 1830: l_user_id fnd_user.user_id%type;

1826: l_module_source varchar2(256);
1827: no_such_user_exp exception;
1828: l_nickname varchar2(256);
1829:
1830: l_user_id fnd_user.user_id%type;
1831: l_local_login varchar2(30);
1832: l_allow_sync varchar2(1);
1833: l_profile_defined boolean;
1834: l_to_synch boolean;

Line 1989: l_user_id fnd_user.user_id%type;

1985: usertype fnd_ldap_util.ldap_user_type;
1986: l_module_source varchar2(256);
1987: no_such_user_exp exception;
1988: l_nickname varchar2(256);
1989: l_user_id fnd_user.user_id%type;
1990: l_local_login varchar2(30);
1991: l_allow_sync varchar2(1);
1992: l_profile_defined boolean;
1993: l_to_synch boolean;

Line 2466: l_user_name fnd_user.user_name%type;

2462:
2463: result pls_integer;
2464: retval pls_integer;
2465: l_user_guid raw(256);
2466: l_user_name fnd_user.user_name%type;
2467: l_enabled boolean;
2468: l_ldap_attr_list ldap_attr_list;
2469: ldapSession dbms_ldap.session;
2470: l_retval pls_integer;

Line 2502: select user_guid into l_user_guid from fnd_user where user_name=p_user_name;

2498: end if;
2499:
2500: -- Find the DN of the linked guid
2501: begin
2502: select user_guid into l_user_guid from fnd_user where user_name=p_user_name;
2503: if (l_user_guid is null ) then
2504: if (fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
2505: then
2506: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source, 'END: Null guid in FND_USER for: '||p_user_name);

Line 2506: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source, 'END: Null guid in FND_USER for: '||p_user_name);

2502: select user_guid into l_user_guid from fnd_user where user_name=p_user_name;
2503: if (l_user_guid is null ) then
2504: if (fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
2505: then
2506: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source, 'END: Null guid in FND_USER for: '||p_user_name);
2507: end if;
2508: fnd_message.set_name('FND','FND_SSO_NOT_LINKED');
2509: return fnd_ldap_util.G_FAILURE;
2510: end if;