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 LDAP_ATTR

Line 143: ) return ldap_attr_list is

139: -------------------------------------------------------------------------------
140: function get_user_attributes(
141: p_userguid in varchar2
142: , p_user_name out nocopy varchar2
143: ) return ldap_attr_list is
144:
145: l_module_source varchar2(256);
146: l_session dbms_ldap.session;
147: l_result_message dbms_ldap.message;

Line 154: l_attribute_list ldap_attr_list;

150: l_ber_element dbms_ldap.ber_element;
151: l_values dbms_ldap.string_collection;
152: l_attribute_name varchar2(256);
153: l_attribute_value varchar2(4000);
154: l_attribute_list ldap_attr_list;
155: l_index number;
156: l_retval pls_integer;
157: l_orclcommonnicknameattr varchar2(256);
158: flag pls_integer;

Line 183: -- walk the results and convert to an ldap_attr_list

179: , attrs => l_attrs
180: , attronly => 0
181: , res => l_result_message);
182:
183: -- walk the results and convert to an ldap_attr_list
184: l_attribute_list := ldap_attr_list();
185: l_entry_message := dbms_ldap.first_entry(
186: ld => l_session
187: , msg => l_result_message);

Line 184: l_attribute_list := ldap_attr_list();

180: , attronly => 0
181: , res => l_result_message);
182:
183: -- walk the results and convert to an ldap_attr_list
184: l_attribute_list := ldap_attr_list();
185: l_entry_message := dbms_ldap.first_entry(
186: ld => l_session
187: , msg => l_result_message);
188:

Line 212: l_attribute_list(l_index) := ldap_attr(

208: end if;
209:
210:
211: l_attribute_list.extend;
212: l_attribute_list(l_index) := ldap_attr(
213: attr_name => l_attribute_name
214: , attr_value => l_attribute_value
215: , attr_bvalue => null
216: , attr_value_len => length(l_attribute_value)

Line 284: function get_ldap_attr_str(p_ldap_attr in ldap_attr)

280: return null;
281: end get_ldap_event_str;
282: --
283: -------------------------------------------------------------------------------
284: function get_ldap_attr_str(p_ldap_attr in ldap_attr)
285: return varchar2 is
286:
287: l_str varchar2(4000);
288: l_module_source varchar2(256);

Line 291: l_module_source := G_MODULE_SOURCE || 'get_ldap_attr_str: ';

287: l_str varchar2(4000);
288: l_module_source varchar2(256);
289:
290: begin
291: l_module_source := G_MODULE_SOURCE || 'get_ldap_attr_str: ';
292:
293: if (p_ldap_attr is not null) then
294: l_str := 'attr_name : ' || p_ldap_attr.attr_name;
295: l_str := l_str || ', attr_value: ' || p_ldap_attr.attr_value;

Line 293: if (p_ldap_attr is not null) then

289:
290: begin
291: l_module_source := G_MODULE_SOURCE || 'get_ldap_attr_str: ';
292:
293: if (p_ldap_attr is not null) then
294: l_str := 'attr_name : ' || p_ldap_attr.attr_name;
295: l_str := l_str || ', attr_value: ' || p_ldap_attr.attr_value;
296: l_str := l_str || ', attr_value_len: ' || p_ldap_attr.attr_value_len;
297: l_str := l_str || ', attr_type: ' || p_ldap_attr.attr_type;

Line 294: l_str := 'attr_name : ' || p_ldap_attr.attr_name;

290: begin
291: l_module_source := G_MODULE_SOURCE || 'get_ldap_attr_str: ';
292:
293: if (p_ldap_attr is not null) then
294: l_str := 'attr_name : ' || p_ldap_attr.attr_name;
295: l_str := l_str || ', attr_value: ' || p_ldap_attr.attr_value;
296: l_str := l_str || ', attr_value_len: ' || p_ldap_attr.attr_value_len;
297: l_str := l_str || ', attr_type: ' || p_ldap_attr.attr_type;
298: l_str := l_str || ', attr_mod_op: ' || p_ldap_attr.attr_mod_op;

Line 295: l_str := l_str || ', attr_value: ' || p_ldap_attr.attr_value;

291: l_module_source := G_MODULE_SOURCE || 'get_ldap_attr_str: ';
292:
293: if (p_ldap_attr is not null) then
294: l_str := 'attr_name : ' || p_ldap_attr.attr_name;
295: l_str := l_str || ', attr_value: ' || p_ldap_attr.attr_value;
296: l_str := l_str || ', attr_value_len: ' || p_ldap_attr.attr_value_len;
297: l_str := l_str || ', attr_type: ' || p_ldap_attr.attr_type;
298: l_str := l_str || ', attr_mod_op: ' || p_ldap_attr.attr_mod_op;
299: end if;

Line 296: l_str := l_str || ', attr_value_len: ' || p_ldap_attr.attr_value_len;

292:
293: if (p_ldap_attr is not null) then
294: l_str := 'attr_name : ' || p_ldap_attr.attr_name;
295: l_str := l_str || ', attr_value: ' || p_ldap_attr.attr_value;
296: l_str := l_str || ', attr_value_len: ' || p_ldap_attr.attr_value_len;
297: l_str := l_str || ', attr_type: ' || p_ldap_attr.attr_type;
298: l_str := l_str || ', attr_mod_op: ' || p_ldap_attr.attr_mod_op;
299: end if;
300:

Line 297: l_str := l_str || ', attr_type: ' || p_ldap_attr.attr_type;

293: if (p_ldap_attr is not null) then
294: l_str := 'attr_name : ' || p_ldap_attr.attr_name;
295: l_str := l_str || ', attr_value: ' || p_ldap_attr.attr_value;
296: l_str := l_str || ', attr_value_len: ' || p_ldap_attr.attr_value_len;
297: l_str := l_str || ', attr_type: ' || p_ldap_attr.attr_type;
298: l_str := l_str || ', attr_mod_op: ' || p_ldap_attr.attr_mod_op;
299: end if;
300:
301: return (l_str);

Line 298: l_str := l_str || ', attr_mod_op: ' || p_ldap_attr.attr_mod_op;

294: l_str := 'attr_name : ' || p_ldap_attr.attr_name;
295: l_str := l_str || ', attr_value: ' || p_ldap_attr.attr_value;
296: l_str := l_str || ', attr_value_len: ' || p_ldap_attr.attr_value_len;
297: l_str := l_str || ', attr_type: ' || p_ldap_attr.attr_type;
298: l_str := l_str || ', attr_mod_op: ' || p_ldap_attr.attr_mod_op;
299: end if;
300:
301: return (l_str);
302:

Line 312: end get_ldap_attr_str;

308: end if;
309:
310: raise;
311: return null;
312: end get_ldap_attr_str;
313: --
314: -------------------------------------------------------------------------------
315: function get_ldap_event_status_str(p_ldap_event_status in ldap_event_status)
316: return varchar2 is

Line 470: function isUserEnabled(p_ldap_attr_list in ldap_attr_list) return boolean is

466: return null;
467: end get_fnd_user;
468: --
469: -------------------------------------------------------------------------------
470: function isUserEnabled(p_ldap_attr_list in ldap_attr_list) return boolean is
471:
472: l_module_source varchar2(256);
473: l_user_enabled boolean;
474: l_inactive_start boolean;

Line 494: if (p_ldap_attr_list is not null AND p_ldap_attr_list.count > 0)

490: l_user_enabled := true;
491: l_inactive_start := false;
492: l_inactive_end := false;
493:
494: if (p_ldap_attr_list is not null AND p_ldap_attr_list.count > 0)
495: then
496: for j in p_ldap_attr_list.first .. p_ldap_attr_list.last
497: loop
498:

Line 496: for j in p_ldap_attr_list.first .. p_ldap_attr_list.last

492: l_inactive_end := false;
493:
494: if (p_ldap_attr_list is not null AND p_ldap_attr_list.count > 0)
495: then
496: for j in p_ldap_attr_list.first .. p_ldap_attr_list.last
497: loop
498:
499: if(upper(p_ldap_attr_list(j).attr_name) = G_ORCLISENABLED) then
500: if(p_ldap_attr_list(j).attr_value = G_DISABLED) then

Line 499: if(upper(p_ldap_attr_list(j).attr_name) = G_ORCLISENABLED) then

495: then
496: for j in p_ldap_attr_list.first .. p_ldap_attr_list.last
497: loop
498:
499: if(upper(p_ldap_attr_list(j).attr_name) = G_ORCLISENABLED) then
500: if(p_ldap_attr_list(j).attr_value = G_DISABLED) then
501: l_user_enabled := false;
502: fnd_message.set_name ('FND', 'FND_SSO_USER_DISABLED');
503:

Line 500: if(p_ldap_attr_list(j).attr_value = G_DISABLED) then

496: for j in p_ldap_attr_list.first .. p_ldap_attr_list.last
497: loop
498:
499: if(upper(p_ldap_attr_list(j).attr_name) = G_ORCLISENABLED) then
500: if(p_ldap_attr_list(j).attr_value = G_DISABLED) then
501: l_user_enabled := false;
502: fnd_message.set_name ('FND', 'FND_SSO_USER_DISABLED');
503:
504: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 515: if(upper(p_ldap_attr_list(j).attr_name) = G_ORCLACTIVESTARTDATE) then

511: end if;
512: -- if start greater than sysdate or end date less than equal sysdate
513: -- user is disabled.
514:
515: if(upper(p_ldap_attr_list(j).attr_name) = G_ORCLACTIVESTARTDATE) then
516: if(p_ldap_attr_list(j).attr_value is not null) then
517:
518:
519: l_start_date_oid_tz := to_date(substr(p_ldap_attr_list(j).attr_value,1,14),G_YYYYMMDDHH24MISS);

Line 516: if(p_ldap_attr_list(j).attr_value is not null) then

512: -- if start greater than sysdate or end date less than equal sysdate
513: -- user is disabled.
514:
515: if(upper(p_ldap_attr_list(j).attr_name) = G_ORCLACTIVESTARTDATE) then
516: if(p_ldap_attr_list(j).attr_value is not null) then
517:
518:
519: l_start_date_oid_tz := to_date(substr(p_ldap_attr_list(j).attr_value,1,14),G_YYYYMMDDHH24MISS);
520:

Line 519: l_start_date_oid_tz := to_date(substr(p_ldap_attr_list(j).attr_value,1,14),G_YYYYMMDDHH24MISS);

515: if(upper(p_ldap_attr_list(j).attr_name) = G_ORCLACTIVESTARTDATE) then
516: if(p_ldap_attr_list(j).attr_value is not null) then
517:
518:
519: l_start_date_oid_tz := to_date(substr(p_ldap_attr_list(j).attr_value,1,14),G_YYYYMMDDHH24MISS);
520:
521: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
522: then
523: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,

Line 556: if(upper(p_ldap_attr_list(j).attr_name) = G_ORCLACTIVEENDDATE) then

552:
553: end if;
554: end if;
555:
556: if(upper(p_ldap_attr_list(j).attr_name) = G_ORCLACTIVEENDDATE) then
557:
558: if(p_ldap_attr_list(j).attr_value is not null) then
559: l_end_date_oid_tz := to_date(substr(p_ldap_attr_list(j).attr_value,1,14),G_YYYYMMDDHH24MISS);
560:

Line 558: if(p_ldap_attr_list(j).attr_value is not null) then

554: end if;
555:
556: if(upper(p_ldap_attr_list(j).attr_name) = G_ORCLACTIVEENDDATE) then
557:
558: if(p_ldap_attr_list(j).attr_value is not null) then
559: l_end_date_oid_tz := to_date(substr(p_ldap_attr_list(j).attr_value,1,14),G_YYYYMMDDHH24MISS);
560:
561: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
562: then

Line 559: l_end_date_oid_tz := to_date(substr(p_ldap_attr_list(j).attr_value,1,14),G_YYYYMMDDHH24MISS);

555:
556: if(upper(p_ldap_attr_list(j).attr_name) = G_ORCLACTIVEENDDATE) then
557:
558: if(p_ldap_attr_list(j).attr_value is not null) then
559: l_end_date_oid_tz := to_date(substr(p_ldap_attr_list(j).attr_value,1,14),G_YYYYMMDDHH24MISS);
560:
561: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
562: then
563: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,

Line 641: l_ldap_attr_list ldap_attr_list;

637: -------------------------------------------------------------------------------
638: procedure process_identity_add(p_event in ldap_event) is
639:
640: l_module_source varchar2(256);
641: l_ldap_attr_list ldap_attr_list;
642: l_user_name fnd_user.user_name%type;
643: my_ent_type varchar2(50);
644: my_parms wf_parameter_list_t;
645: l_allow_identity_add varchar2(1);

Line 651: l_ldap_attr_list := get_user_attributes(p_event.object_guid, l_user_name);

647: l_user_enabled boolean;
648:
649: begin
650: l_module_source := G_MODULE_SOURCE || 'process_identity_add: ';
651: l_ldap_attr_list := get_user_attributes(p_event.object_guid, l_user_name);
652:
653: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
654: then
655: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source

Line 682: p_ldap_attr_list => l_ldap_attr_list

678: wf_event.AddParameterToList('CHANGE_SOURCE', G_OID, my_parms);
679: wf_event.AddParameterToList('ORCLGUID', p_event.object_guid, my_parms);
680: wf_event.AddParameterToList('CHANGE_TYPE', G_LOAD, my_parms);
681: save_to_cache(
682: p_ldap_attr_list => l_ldap_attr_list
683: , p_entity_type => wf_oid.IDENTITY_ADD
684: , p_entity_key_value => l_user_name);
685: wf_event.raise('oracle.apps.fnd.identity.add',
686: upper(l_user_name), null, my_parms);

Line 741: l_ldap_attr_list ldap_attr_list;

737: l_profiles apps_sso_user_profiles_type;
738: l_user_name fnd_user.user_name%type;
739: l_oid_user_name fnd_user.user_name%type;
740: l_user_id fnd_user.user_id%type;
741: l_ldap_attr_list ldap_attr_list;
742:
743: begin
744: l_module_source := G_MODULE_SOURCE || 'process_identity_modify: ';
745: l_ldap_attr_list := get_user_attributes(p_event.object_guid, l_oid_user_name);

Line 745: l_ldap_attr_list := get_user_attributes(p_event.object_guid, l_oid_user_name);

741: l_ldap_attr_list ldap_attr_list;
742:
743: begin
744: l_module_source := G_MODULE_SOURCE || 'process_identity_modify: ';
745: l_ldap_attr_list := get_user_attributes(p_event.object_guid, l_oid_user_name);
746:
747: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
748: then
749: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source

Line 770: p_ldap_attr_list => p_event.attr_list

766: --For AOl/J consumption
767: wf_entity_mgr.put_attribute_value(G_USER, l_user_name,
768: G_ORCLGUID, p_event.object_guid);
769: save_to_cache(
770: p_ldap_attr_list => p_event.attr_list
771: , p_entity_type => G_USER
772: , p_entity_key_value => l_user_name);
773: wf_entity_mgr.process_changes(G_USER, l_user_name, G_OID);
774: --For our consumption so that only we update TCA tables

Line 776: p_ldap_attr_list => l_ldap_attr_list

772: , p_entity_key_value => l_user_name);
773: wf_entity_mgr.process_changes(G_USER, l_user_name, G_OID);
774: --For our consumption so that only we update TCA tables
775: save_to_cache(
776: p_ldap_attr_list => l_ldap_attr_list
777: , p_entity_type => wf_oid.IDENTITY_MODIFY
778: , p_entity_key_value => l_user_name);
779: wf_event.raise('oracle.apps.fnd.identity.modify',
780: upper(l_user_name), null, null);

Line 885: l_ldap_attr_list ldap_attr_list;

881: -------------------------------------------------------------------------------
882: procedure process_subscription_add(p_event in ldap_event) is
883:
884: l_module_source varchar2(256);
885: l_ldap_attr_list ldap_attr_list;
886: l_user_name fnd_user.user_name%type;
887: my_ent_type varchar2(50);
888: my_parms wf_parameter_list_t;
889:

Line 901: l_ldap_attr_list := get_user_attributes(p_event.object_guid, l_user_name);

897: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
898: , 'p_event = ' || get_ldap_event_str(p_event));
899: end if;
900:
901: l_ldap_attr_list := get_user_attributes(p_event.object_guid, l_user_name);
902: if( isUserEnabled(l_ldap_attr_list)) then
903:
904: -- Moving it out since we need the orclisenabled
905: -- l_ldap_attr_list := get_user_attributes(p_event.object_guid, l_user_name);

Line 902: if( isUserEnabled(l_ldap_attr_list)) then

898: , 'p_event = ' || get_ldap_event_str(p_event));
899: end if;
900:
901: l_ldap_attr_list := get_user_attributes(p_event.object_guid, l_user_name);
902: if( isUserEnabled(l_ldap_attr_list)) then
903:
904: -- Moving it out since we need the orclisenabled
905: -- l_ldap_attr_list := get_user_attributes(p_event.object_guid, l_user_name);
906: wf_entity_mgr.put_attribute_value(wf_oid.SUBSCRIPTION_ADD, l_user_name,

Line 905: -- l_ldap_attr_list := get_user_attributes(p_event.object_guid, l_user_name);

901: l_ldap_attr_list := get_user_attributes(p_event.object_guid, l_user_name);
902: if( isUserEnabled(l_ldap_attr_list)) then
903:
904: -- Moving it out since we need the orclisenabled
905: -- l_ldap_attr_list := get_user_attributes(p_event.object_guid, l_user_name);
906: wf_entity_mgr.put_attribute_value(wf_oid.SUBSCRIPTION_ADD, l_user_name,
907: G_CACHE_CHANGED, G_YES);
908:
909: save_to_cache(

Line 910: p_ldap_attr_list => l_ldap_attr_list

906: wf_entity_mgr.put_attribute_value(wf_oid.SUBSCRIPTION_ADD, l_user_name,
907: G_CACHE_CHANGED, G_YES);
908:
909: save_to_cache(
910: p_ldap_attr_list => l_ldap_attr_list
911: , p_entity_type => wf_oid.SUBSCRIPTION_ADD
912: , p_entity_key_value => l_user_name);
913: my_ent_type := upper(wf_oid.SUBSCRIPTION_ADD);
914: wf_entity_mgr.put_attribute_value(my_ent_type, l_user_name,

Line 990: l_ldap_attr_list ldap_attr_list;

986: ) is
987: l_module_source varchar2(256);
988: l_apps_user_key apps_user_key_type;
989: l_user_name fnd_user.user_name%type;
990: l_ldap_attr_list ldap_attr_list;
991: l_ldap_message fnd_oid_util.ldap_message_type;
992: l_return_status varchar2(1);
993:
994: PRAGMA AUTONOMOUS_TRANSACTION;

Line 1021: 'Trying to get ldap attribute list for GUID: '||l_apps_user_key.user_guid||'::');

1017:
1018: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1019: then
1020: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
1021: 'Trying to get ldap attribute list for GUID: '||l_apps_user_key.user_guid||'::');
1022: end if;
1023:
1024:
1025: if(l_apps_user_key.user_guid is null)

Line 1030: l_ldap_attr_list := fnd_oid_util.get_user_attributes(p_userguid => l_apps_user_key.user_guid,

1026: then
1027: raise user_guid_null_exp;
1028: end if;
1029:
1030: l_ldap_attr_list := fnd_oid_util.get_user_attributes(p_userguid => l_apps_user_key.user_guid,
1031: p_user_name => l_user_name);
1032: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1033: then
1034: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,

Line 1035: 'Got the ldap attribute list');

1031: p_user_name => l_user_name);
1032: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1033: then
1034: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
1035: 'Got the ldap attribute list');
1036: end if;
1037:
1038: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1039: then

Line 1046: , p_ldap_attr_list => l_ldap_attr_list

1042: ' from l_apps_user_key:'||l_apps_user_key.user_name);
1043: end if;
1044:
1045: fnd_ldap_mapper.map_ldap_message(p_user_name => p_user_name
1046: , p_ldap_attr_list => l_ldap_attr_list
1047: , p_ldap_message => l_ldap_message);
1048:
1049: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1050: then

Line 1136: l_ldap_attr_list ldap_attr_list;

1132: ) is
1133: l_module_source varchar2(256);
1134: l_apps_user_key apps_user_key_type;
1135: l_user_name fnd_user.user_name%type;
1136: l_ldap_attr_list ldap_attr_list;
1137: l_ldap_message fnd_oid_util.ldap_message_type;
1138: l_return_status varchar2(1);
1139: begin
1140: l_module_source := G_MODULE_SOURCE || 'synch_user_from_LDAP_NO_AUTO: ';

Line 1165: 'Trying to get ldap attribute list for GUID: '||l_apps_user_key.user_guid||'::');

1161:
1162: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1163: then
1164: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
1165: 'Trying to get ldap attribute list for GUID: '||l_apps_user_key.user_guid||'::');
1166: end if;
1167:
1168:
1169: if(l_apps_user_key.user_guid is null)

Line 1174: l_ldap_attr_list := fnd_oid_util.get_user_attributes(p_userguid => l_apps_user_key.user_guid,

1170: then
1171: raise user_guid_null_exp;
1172: end if;
1173:
1174: l_ldap_attr_list := fnd_oid_util.get_user_attributes(p_userguid => l_apps_user_key.user_guid,
1175: p_user_name => l_user_name);
1176: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1177: then
1178: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,

Line 1179: 'Got the ldap attribute list');

1175: p_user_name => l_user_name);
1176: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1177: then
1178: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
1179: 'Got the ldap attribute list');
1180: end if;
1181:
1182: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1183: then

Line 1190: , p_ldap_attr_list => l_ldap_attr_list

1186: ' from l_apps_user_key:'||l_apps_user_key.user_name);
1187: end if;
1188:
1189: fnd_ldap_mapper.map_ldap_message(p_user_name => p_user_name
1190: , p_ldap_attr_list => l_ldap_attr_list
1191: , p_ldap_message => l_ldap_message);
1192:
1193: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1194: then

Line 1287: l_ldap_attr_list ldap_attr_list;

1283: l_event_name varchar2(80);
1284: l_parmeter_list wf_parameter_list_t;
1285: l_result pls_integer;
1286: l_sub_add_result pls_integer;
1287: l_ldap_attr_list ldap_attr_list;
1288: l_ldap_message ldap_message_type;
1289: l_user_name fnd_user.user_name%type;
1290: l_rec cur_fnd_users%rowtype;
1291: l_found boolean;

Line 1324: l_ldap_attr_list := fnd_oid_util.get_user_attributes(p_userguid => p_user_guid,

1320: l_user_name := p_user_name;
1321:
1322: -- Adding the following login for updating FAX and Email from OID when users are creared onDemand
1323: -- Refer to Bug 4411170
1324: l_ldap_attr_list := fnd_oid_util.get_user_attributes(p_userguid => p_user_guid,
1325: p_user_name => l_user_name);
1326:
1327: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1328: then

Line 1329: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Got ldap_attr_list');

1325: p_user_name => l_user_name);
1326:
1327: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1328: then
1329: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Got ldap_attr_list');
1330: end if;
1331:
1332: fnd_ldap_mapper.map_ldap_message(p_user_name => l_user_name
1333: , p_ldap_attr_list => l_ldap_attr_list

Line 1333: , p_ldap_attr_list => l_ldap_attr_list

1329: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Got ldap_attr_list');
1330: end if;
1331:
1332: fnd_ldap_mapper.map_ldap_message(p_user_name => l_user_name
1333: , p_ldap_attr_list => l_ldap_attr_list
1334: , p_ldap_message => l_ldap_message);
1335:
1336:
1337: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 1556: p_ldap_attr_list in ldap_attr_list

1552: end process_no_success_event;
1553: --
1554: -------------------------------------------------------------------------------
1555: procedure save_to_cache(
1556: p_ldap_attr_list in ldap_attr_list
1557: , p_entity_type in varchar2
1558: , p_entity_key_value in varchar2
1559: ) is
1560:

Line 1572: if (p_ldap_attr_list is not null AND p_ldap_attr_list.count > 0)

1568: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
1569: , 'Begin');
1570: end if;
1571:
1572: if (p_ldap_attr_list is not null AND p_ldap_attr_list.count > 0)
1573: then
1574: for j in p_ldap_attr_list.first .. p_ldap_attr_list.last
1575: loop
1576:

Line 1574: for j in p_ldap_attr_list.first .. p_ldap_attr_list.last

1570: end if;
1571:
1572: if (p_ldap_attr_list is not null AND p_ldap_attr_list.count > 0)
1573: then
1574: for j in p_ldap_attr_list.first .. p_ldap_attr_list.last
1575: loop
1576:
1577: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1578: then

Line 1580: , 'p_ldap_attr_list(' || j || ') = ' ||

1576:
1577: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1578: then
1579: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
1580: , 'p_ldap_attr_list(' || j || ') = ' ||
1581: get_ldap_attr_str(p_ldap_attr_list(j)));
1582: end if;
1583:
1584: if ((upper(p_ldap_attr_list(j).attr_name) <> G_USERPASSWORD)

Line 1581: get_ldap_attr_str(p_ldap_attr_list(j)));

1577: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1578: then
1579: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
1580: , 'p_ldap_attr_list(' || j || ') = ' ||
1581: get_ldap_attr_str(p_ldap_attr_list(j)));
1582: end if;
1583:
1584: if ((upper(p_ldap_attr_list(j).attr_name) <> G_USERPASSWORD)
1585: AND (upper(p_ldap_attr_list(j).attr_name) <> G_ORCLISENABLED)

Line 1584: if ((upper(p_ldap_attr_list(j).attr_name) <> G_USERPASSWORD)

1580: , 'p_ldap_attr_list(' || j || ') = ' ||
1581: get_ldap_attr_str(p_ldap_attr_list(j)));
1582: end if;
1583:
1584: if ((upper(p_ldap_attr_list(j).attr_name) <> G_USERPASSWORD)
1585: AND (upper(p_ldap_attr_list(j).attr_name) <> G_ORCLISENABLED)
1586: AND (upper(p_ldap_attr_list(j).attr_name) <> G_OBJECTCLASS))
1587: then
1588: wf_entity_mgr.put_attribute_value(p_entity_type, p_entity_key_value,

Line 1585: AND (upper(p_ldap_attr_list(j).attr_name) <> G_ORCLISENABLED)

1581: get_ldap_attr_str(p_ldap_attr_list(j)));
1582: end if;
1583:
1584: if ((upper(p_ldap_attr_list(j).attr_name) <> G_USERPASSWORD)
1585: AND (upper(p_ldap_attr_list(j).attr_name) <> G_ORCLISENABLED)
1586: AND (upper(p_ldap_attr_list(j).attr_name) <> G_OBJECTCLASS))
1587: then
1588: wf_entity_mgr.put_attribute_value(p_entity_type, p_entity_key_value,
1589: p_ldap_attr_list(j).attr_name, p_ldap_attr_list(j).attr_value);

Line 1586: AND (upper(p_ldap_attr_list(j).attr_name) <> G_OBJECTCLASS))

1582: end if;
1583:
1584: if ((upper(p_ldap_attr_list(j).attr_name) <> G_USERPASSWORD)
1585: AND (upper(p_ldap_attr_list(j).attr_name) <> G_ORCLISENABLED)
1586: AND (upper(p_ldap_attr_list(j).attr_name) <> G_OBJECTCLASS))
1587: then
1588: wf_entity_mgr.put_attribute_value(p_entity_type, p_entity_key_value,
1589: p_ldap_attr_list(j).attr_name, p_ldap_attr_list(j).attr_value);
1590: end if;

Line 1589: p_ldap_attr_list(j).attr_name, p_ldap_attr_list(j).attr_value);

1585: AND (upper(p_ldap_attr_list(j).attr_name) <> G_ORCLISENABLED)
1586: AND (upper(p_ldap_attr_list(j).attr_name) <> G_OBJECTCLASS))
1587: then
1588: wf_entity_mgr.put_attribute_value(p_entity_type, p_entity_key_value,
1589: p_ldap_attr_list(j).attr_name, p_ldap_attr_list(j).attr_value);
1590: end if;
1591: end loop;
1592: end if;
1593: