DBA Data[Home] [Help]

APPS.FND_LDAP_MAPPER dependencies on FND_LOG

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

23: begin
24: l_module_source := G_MODULE_SOURCE || 'map_sso_user_profiles: ';
25: l_found := false;
26:
27: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
28: then
29: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
30: end if;
31:

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

25: l_found := false;
26:
27: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
28: then
29: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
30: end if;
31:
32: open cur_fnd_users;
33: fetch cur_fnd_users into l_rec;

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

79: else
80: l_user_profiles.auto_link := fnd_oid_util.G_N;
81: end if;
82:
83: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
84: then
85: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
86: , 'l_user_profiles = ldap_sync: ' || l_user_profiles.ldap_sync ||
87: ', local_login: ' || l_user_profiles.local_login);

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

81: end if;
82:
83: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
84: then
85: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
86: , 'l_user_profiles = ldap_sync: ' || l_user_profiles.ldap_sync ||
87: ', local_login: ' || l_user_profiles.local_login);
88: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');
89: end if;

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

84: then
85: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
86: , 'l_user_profiles = ldap_sync: ' || l_user_profiles.ldap_sync ||
87: ', local_login: ' || l_user_profiles.local_login);
88: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');
89: end if;
90:
91: return (l_user_profiles);
92:

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

95: if (cur_fnd_users%isopen)
96: then
97: close cur_fnd_users;
98: end if;
99: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
100: then
101: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source,
102: 'no_such_user_exp: No matching record for FND_USER.user_name = ' ||
103: p_user_name);

Line 101: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source,

97: close cur_fnd_users;
98: end if;
99: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
100: then
101: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source,
102: 'no_such_user_exp: No matching record for FND_USER.user_name = ' ||
103: p_user_name);
104: end if;
105: raise;

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

109: if (cur_fnd_users%isopen)
110: then
111: close cur_fnd_users;
112: end if;
113: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
114: then
115: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
116: end if;
117:

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

111: close cur_fnd_users;
112: end if;
113: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
114: then
115: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
116: end if;
117:
118: raise;
119: return null;

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

140: begin
141: l_module_source := G_MODULE_SOURCE || 'map_entity_changes_rec: ';
142: l_found := false;
143:
144: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
145: then
146: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
147: end if;
148:

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

142: l_found := false;
143:
144: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
145: then
146: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
147: end if;
148:
149: open cur_entity_changes;
150: fetch cur_entity_changes into l_rec;

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

169: where current of cur_entity_changes;
170:
171: close cur_entity_changes;
172:
173: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
174: then
175: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');
176: end if;
177:

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

171: close cur_entity_changes;
172:
173: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
174: then
175: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');
176: end if;
177:
178: exception
179: when fnd_oid_util.event_not_found_exp then

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

181: then
182: close cur_entity_changes;
183: end if;
184:
185: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
186: then
187: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source
188: , 'No more changes in WF_ENTITY_CHANGES');
189: end if;

Line 187: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source

183: end if;
184:
185: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
186: then
187: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source
188: , 'No more changes in WF_ENTITY_CHANGES');
189: end if;
190: raise;
191:

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

194: then
195: close cur_entity_changes;
196: end if;
197:
198: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
199: then
200: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
201: end if;
202: raise;

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

196: end if;
197:
198: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
199: then
200: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
201: end if;
202: raise;
203: end map_entity_changes_rec;
204: --

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

238:
239: begin
240: l_module_source := G_MODULE_SOURCE || 'map_ldap_attr_list: ';
241:
242: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
243: then
244: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
245: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
246: , 'p_entity_type = ' || p_entity_type ||

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

240: l_module_source := G_MODULE_SOURCE || 'map_ldap_attr_list: ';
241:
242: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
243: then
244: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
245: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
246: , 'p_entity_type = ' || p_entity_type ||
247: ', p_entity_key_value = ' || p_entity_key_value);
248: end if;

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

241:
242: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
243: then
244: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
245: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
246: , 'p_entity_type = ' || p_entity_type ||
247: ', p_entity_key_value = ' || p_entity_key_value);
248: end if;
249:

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

288: elsif (l_rec.attribute_name = fnd_oid_util.G_ORCLISENABLED)
289: then
290: -- Elan, 18-MAR-2003. Skip the attribute, we'll compute it ourselves
291: -- based on start_date and end_date.
292: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
293: then
294: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
295: , 'Skipping attribute: ' || l_rec.attribute_name ||
296: ' - will be computed later with start_date and end_date');

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

290: -- Elan, 18-MAR-2003. Skip the attribute, we'll compute it ourselves
291: -- based on start_date and end_date.
292: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
293: then
294: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
295: , 'Skipping attribute: ' || l_rec.attribute_name ||
296: ' - will be computed later with start_date and end_date');
297: end if;
298:

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

349: -- end if;
350:
351: end if;
352:
353: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
354: then
355: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
356: , 'l_ldap_attr(' || (l_index - 1) || ') = ' ||
357: fnd_oid_util.get_ldap_attr_str(l_ldap_attr));

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

351: end if;
352:
353: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
354: then
355: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
356: , 'l_ldap_attr(' || (l_index - 1) || ') = ' ||
357: fnd_oid_util.get_ldap_attr_str(l_ldap_attr));
358: end if;
359:

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

359:
360: end loop;
361:
362:
363: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
364: then
365: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Computing ORCLISENABLED l_start_date:: '||
366: to_char(l_start_date, fnd_oid_util.G_YYYYMMDDHH24MISS) ||' l_end_date:: '||
367: to_char(l_end_date, fnd_oid_util.G_YYYYMMDDHH24MISS));

Line 365: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Computing ORCLISENABLED l_start_date:: '||

361:
362:
363: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
364: then
365: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Computing ORCLISENABLED l_start_date:: '||
366: to_char(l_start_date, fnd_oid_util.G_YYYYMMDDHH24MISS) ||' l_end_date:: '||
367: to_char(l_end_date, fnd_oid_util.G_YYYYMMDDHH24MISS));
368: end if;
369:

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

371: if ((l_start_date is not null and l_start_date > sysdate)
372: or
373: (l_end_date is not null and l_end_date <= sysdate))
374: then
375: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
376: then
377: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Setting ORCLISENABLED to DISABLED');
378: end if;
379: p_ldap_key.orclisEnabled := fnd_oid_util.G_DISABLED;

Line 377: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Setting ORCLISENABLED to DISABLED');

373: (l_end_date is not null and l_end_date <= sysdate))
374: then
375: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
376: then
377: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Setting ORCLISENABLED to DISABLED');
378: end if;
379: p_ldap_key.orclisEnabled := fnd_oid_util.G_DISABLED;
380: else
381: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

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

377: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Setting ORCLISENABLED to DISABLED');
378: end if;
379: p_ldap_key.orclisEnabled := fnd_oid_util.G_DISABLED;
380: else
381: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
382: then
383: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Setting ORCLISENABLED to ENABLED');
384: end if;
385: p_ldap_key.orclisEnabled := fnd_oid_util.G_ENABLED;

Line 383: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Setting ORCLISENABLED to ENABLED');

379: p_ldap_key.orclisEnabled := fnd_oid_util.G_DISABLED;
380: else
381: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
382: then
383: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Setting ORCLISENABLED to ENABLED');
384: end if;
385: p_ldap_key.orclisEnabled := fnd_oid_util.G_ENABLED;
386: end if;
387:

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

393: p_ldap_attr_list.extend;
394: p_ldap_attr_list(l_index) := l_ldap_attr;
395: l_index := l_index + 1;
396:
397: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
398: then
399: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
400: , 'l_ldap_attr(' || (l_index - 1) || ') = ' ||
401: fnd_oid_util.get_ldap_attr_str(l_ldap_attr));

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

395: l_index := l_index + 1;
396:
397: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
398: then
399: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
400: , 'l_ldap_attr(' || (l_index - 1) || ') = ' ||
401: fnd_oid_util.get_ldap_attr_str(l_ldap_attr));
402: end if;
403:

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

424: p_ldap_attr_list.extend;
425: p_ldap_attr_list(l_index) := l_ldap_attr;
426: l_index := l_index + 1;
427:
428: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
429: then
430: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
431: , 'l_ldap_attr(' || (l_index - 1) || ') = ' ||
432: fnd_oid_util.get_ldap_attr_str(l_ldap_attr));

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

426: l_index := l_index + 1;
427:
428: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
429: then
430: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
431: , 'l_ldap_attr(' || (l_index - 1) || ') = ' ||
432: fnd_oid_util.get_ldap_attr_str(l_ldap_attr));
433: end if;
434: l_ldap_attr := ldap_attr(

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

452: p_ldap_attr_list.extend;
453: p_ldap_attr_list(l_index) := l_ldap_attr;
454: l_index := l_index + 1;
455:
456: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
457: then
458: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
459: , 'l_ldap_attr(' || (l_index - 1) || ') = ' ||
460: fnd_oid_util.get_ldap_attr_str(l_ldap_attr));

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

454: l_index := l_index + 1;
455:
456: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
457: then
458: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
459: , 'l_ldap_attr(' || (l_index - 1) || ') = ' ||
460: fnd_oid_util.get_ldap_attr_str(l_ldap_attr));
461: end if;
462: else

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

476: l_index := l_index + 1;
477: end if;
478: end if;
479:
480: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
481: then
482: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');
483: end if;
484:

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

478: end if;
479:
480: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
481: then
482: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');
483: end if;
484:
485: exception
486: when others then

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

483: end if;
484:
485: exception
486: when others then
487: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
488: then
489: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
490: end if;
491:

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

485: exception
486: when others then
487: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
488: then
489: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
490: end if;
491:
492: raise;
493: end map_ldap_attr_list;

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

503:
504: begin
505: l_module_source := G_MODULE_SOURCE || 'map_ldap_message: ';
506:
507: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
508: then
509: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
510: end if;
511:

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

505: l_module_source := G_MODULE_SOURCE || 'map_ldap_message: ';
506:
507: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
508: then
509: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
510: end if;
511:
512: p_ldap_message.object_name := p_wf_event.GetEventKey;
513:

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

517: if (p_ldap_message.sn in ('*UNKNOWN*','*NULL*')) then
518: p_ldap_message.sn := null;
519: end if;
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, 'Surname is:' || p_ldap_message.sn
524: || ', attribute name is: ' || fnd_oid_util.G_LDAP_MESSAGE_ATTR.sn);
525: end if;

Line 523: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Surname is:' || p_ldap_message.sn

519: end if;
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, 'Surname is:' || p_ldap_message.sn
524: || ', attribute name is: ' || fnd_oid_util.G_LDAP_MESSAGE_ATTR.sn);
525: end if;
526:
527: p_ldap_message.cn := wf_entity_mgr.get_attribute_value(p_event_type,

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

590: if (p_ldap_message.givenName in ('*UNKNOWN*','*NULL*')) then
591: p_ldap_message.givenName := null;
592: end if;
593:
594: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
595: then
596: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Given name is:' || p_ldap_message.givenName
597: || ', attribute name is: ' || fnd_oid_util.G_LDAP_MESSAGE_ATTR.givenName);
598: end if;

Line 596: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Given name is:' || p_ldap_message.givenName

592: end if;
593:
594: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
595: then
596: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Given name is:' || p_ldap_message.givenName
597: || ', attribute name is: ' || fnd_oid_util.G_LDAP_MESSAGE_ATTR.givenName);
598: end if;
599:
600: p_ldap_message.homePhone := wf_entity_mgr.get_attribute_value(p_event_type,

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

643:
644: p_ldap_message.orclGUID := wf_entity_mgr.get_attribute_value(p_event_type,
645: p_ldap_message.object_name, fnd_oid_util.G_LDAP_MESSAGE_ATTR.orclGUID);
646:
647: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
648: then
649: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');
650: end if;
651:

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

645: p_ldap_message.object_name, fnd_oid_util.G_LDAP_MESSAGE_ATTR.orclGUID);
646:
647: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
648: then
649: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');
650: end if;
651:
652: exception
653: when others then

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

650: end if;
651:
652: exception
653: when others then
654: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
655: then
656: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
657: end if;
658: raise;

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

652: exception
653: when others then
654: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
655: then
656: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
657: end if;
658: raise;
659: end map_ldap_message;
660: --

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

668: l_module_source varchar2(256);
669: begin
670: l_module_source := G_MODULE_SOURCE || 'map_ldap_message: ';
671:
672: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
673: then
674: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
675: end if;
676:

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

670: l_module_source := G_MODULE_SOURCE || 'map_ldap_message: ';
671:
672: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
673: then
674: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
675: end if;
676:
677: p_ldap_message.object_name := p_user_name;
678: if (p_ldap_attr_list is not null AND p_ldap_attr_list.count > 0)

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

678: if (p_ldap_attr_list is not null AND p_ldap_attr_list.count > 0)
679: then
680: for j in p_ldap_attr_list.first .. p_ldap_attr_list.last
681: loop
682: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
683: then
684: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
685: , 'p_ldap_attr_list(' || j || ') = ' ||
686: fnd_oid_util.get_ldap_attr_str(p_ldap_attr_list(j)));

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

680: for j in p_ldap_attr_list.first .. p_ldap_attr_list.last
681: loop
682: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
683: then
684: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
685: , 'p_ldap_attr_list(' || j || ') = ' ||
686: fnd_oid_util.get_ldap_attr_str(p_ldap_attr_list(j)));
687: end if;
688:

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

814: end if;
815: end loop;
816: end if;
817:
818: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
819: then
820: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
821: , 'End');
822: end if;

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

816: end if;
817:
818: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
819: then
820: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
821: , 'End');
822: end if;
823:
824: exception

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

822: end if;
823:
824: exception
825: when others then
826: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
827: then
828: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
829: end if;
830:

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

824: exception
825: when others then
826: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
827: then
828: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
829: end if;
830:
831: raise;
832: end map_ldap_message;

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

843:
844: begin
845: l_module_source := G_MODULE_SOURCE || 'map_oid_event: ';
846:
847: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
848: then
849: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
850: end if;
851:

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

845: l_module_source := G_MODULE_SOURCE || 'map_oid_event: ';
846:
847: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
848: then
849: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
850: end if;
851:
852: if (p_ldap_key.orclGUID is null
853: and p_entity_changes_rec.entity_type = fnd_oid_util.G_USER)

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

906: , attr_list => null);
907:
908: end if;
909:
910: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
911: then
912: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');
913: end if;
914:

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

908: end if;
909:
910: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
911: then
912: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');
913: end if;
914:
915: exception
916: when others then

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

913: end if;
914:
915: exception
916: when others then
917: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
918: then
919: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
920: end if;
921: end map_oid_event;

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

915: exception
916: when others then
917: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
918: then
919: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
920: end if;
921: end map_oid_event;
922: --
923: -------------------------------------------------------------------------------