DBA Data[Home] [Help]

APPS.WF_OID dependencies on FND_LOG

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

65: begin
66: l_module_source := G_MODULE_SOURCE || 'PutOIDEvent: ';
67: fnd_global.apps_initialize(0, -1, -1);
68:
69: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
70: then
71: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
72: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
73: , 'event = ' || fnd_oid_util.GET_LDAP_EVENT_STR(event));

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

67: fnd_global.apps_initialize(0, -1, -1);
68:
69: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
70: then
71: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
72: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
73: , 'event = ' || fnd_oid_util.GET_LDAP_EVENT_STR(event));
74: end if;
75:

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

68:
69: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
70: then
71: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
72: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
73: , 'event = ' || fnd_oid_util.GET_LDAP_EVENT_STR(event));
74: end if;
75:
76: if (event is null)

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

115:
116: event_status := ldap_event_status(event.event_id, null,
117: 0, null, wf_oid.EVENT_SUCCESS);
118:
119: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
120: then
121: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');
122: end if;
123:

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

117: 0, null, wf_oid.EVENT_SUCCESS);
118:
119: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
120: then
121: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');
122: end if;
123:
124: exception
125: when l_null_event_exp then

Line 128: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

124: exception
125: when l_null_event_exp then
126: event_status := LDAP_EVENT_STATUS(null, null, 0,
127: 'Received Null Event', wf_oid.EVENT_RESEND);
128: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
129: then
130: fnd_log.string(fnd_log.LEVEL_EXCEPTION, l_module_source,
131: 'Receiced Null Event. Sending wf_oid.EVENT_RESEND');
132: end if;

Line 130: fnd_log.string(fnd_log.LEVEL_EXCEPTION, l_module_source,

126: event_status := LDAP_EVENT_STATUS(null, null, 0,
127: 'Received Null Event', wf_oid.EVENT_RESEND);
128: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
129: then
130: fnd_log.string(fnd_log.LEVEL_EXCEPTION, l_module_source,
131: 'Receiced Null Event. Sending wf_oid.EVENT_RESEND');
132: end if;
133:
134: when others then

Line 137: if (fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

133:
134: when others then
135: event_status := LDAP_EVENT_STATUS(event.event_id, null, to_char(sqlcode),
136: sqlerrm, wf_oid.EVENT_ERROR);
137: if (fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
138: then
139: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source, sqlerrm);
140: end if;
141: end PutOIDEvent;

Line 139: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source, sqlerrm);

135: event_status := LDAP_EVENT_STATUS(event.event_id, null, to_char(sqlcode),
136: sqlerrm, wf_oid.EVENT_ERROR);
137: if (fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
138: then
139: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source, sqlerrm);
140: end if;
141: end PutOIDEvent;
142: --
143: -------------------------------------------------------------------------------

Line 163: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

159: begin
160: l_module_source := G_MODULE_SOURCE || 'GetAppEvent: ';
161: fnd_global.apps_initialize(0, -1, -1);
162:
163: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
164: then
165: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
166: end if;
167: fnd_ldap_mapper.map_entity_changes_rec(l_entity_changes_rec);

Line 165: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

161: fnd_global.apps_initialize(0, -1, -1);
162:
163: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
164: then
165: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
166: end if;
167: fnd_ldap_mapper.map_entity_changes_rec(l_entity_changes_rec);
168: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
169: then

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

164: then
165: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
166: end if;
167: fnd_ldap_mapper.map_entity_changes_rec(l_entity_changes_rec);
168: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
169: then
170: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
171: 'l_entity_changes_rec = ' ||
172: fnd_oid_util.GET_ENTITY_CHANGES_REC_STR(l_entity_changes_rec));

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

166: end if;
167: fnd_ldap_mapper.map_entity_changes_rec(l_entity_changes_rec);
168: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
169: then
170: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
171: 'l_entity_changes_rec = ' ||
172: fnd_oid_util.GET_ENTITY_CHANGES_REC_STR(l_entity_changes_rec));
173: end if;
174: l_apps_username_key := fnd_oid_util.get_fnd_user(p_user_name => l_entity_changes_rec.entity_key_value);

Line 182: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then

178: val_z => l_local_login,
179: defined_z => l_profile_defined);
180:
181: if (not l_profile_defined or l_local_login = fnd_oid_util.G_LOCAL) then
182: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
183: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
184: 'We don''t sync users with profile APPS_SSO_LOCAL_LOGIN=LOCAL: '
185: || l_entity_changes_rec.entity_key_value);
186: end if;

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

179: defined_z => l_profile_defined);
180:
181: if (not l_profile_defined or l_local_login = fnd_oid_util.G_LOCAL) then
182: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
183: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
184: 'We don''t sync users with profile APPS_SSO_LOCAL_LOGIN=LOCAL: '
185: || l_entity_changes_rec.entity_key_value);
186: end if;
187: --Remove from wf_entity_changes to fix bug 4233358

Line 212: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then

208: user_id_z => l_apps_username_key.user_id,
209: val_z => l_allow_sync,
210: defined_z => l_profile_defined);
211: if (not l_profile_defined or l_allow_sync = fnd_oid_util.G_N) then
212: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
213: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
214: 'We don''t modify users with profile APPS_SSO_LDAP_SYNC=N: '
215: || l_entity_changes_rec.entity_key_value);
216: end if;

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

209: val_z => l_allow_sync,
210: defined_z => l_profile_defined);
211: if (not l_profile_defined or l_allow_sync = fnd_oid_util.G_N) then
212: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
213: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
214: 'We don''t modify users with profile APPS_SSO_LDAP_SYNC=N: '
215: || l_entity_changes_rec.entity_key_value);
216: end if;
217: event := l_copy_event;

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

221: raise fnd_oid_util.event_not_found_exp;
222: end if;
223: end if;
224:
225: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
226: then
227: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
228: , fnd_oid_util.get_ldap_event_str(event));
229: end if;

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

223: end if;
224:
225: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
226: then
227: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
228: , fnd_oid_util.get_ldap_event_str(event));
229: end if;
230:
231: l_ldap_attr_list.delete;

Line 233: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

229: end if;
230:
231: l_ldap_attr_list.delete;
232:
233: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
234: then
235: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
236: end if;
237:

Line 235: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');

231: l_ldap_attr_list.delete;
232:
233: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
234: then
235: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
236: end if;
237:
238: return wf_oid.EVENT_FOUND;
239:

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

238: return wf_oid.EVENT_FOUND;
239:
240: exception
241: when fnd_oid_util.event_not_found_exp then
242: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
243: then
244: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
245: , 'No more events to send.Sending wf_oid.EVENT_NOT_FOUND');
246: end if;

Line 244: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source

240: exception
241: when fnd_oid_util.event_not_found_exp then
242: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
243: then
244: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
245: , 'No more events to send.Sending wf_oid.EVENT_NOT_FOUND');
246: end if;
247:
248: return wf_oid.EVENT_NOT_FOUND;

Line 251: if (fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

247:
248: return wf_oid.EVENT_NOT_FOUND;
249:
250: when others then
251: if (fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
252: then
253: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source, sqlerrm);
254: end if;
255:

Line 253: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source, sqlerrm);

249:
250: when others then
251: if (fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
252: then
253: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source, sqlerrm);
254: end if;
255:
256: return wf_oid.EVENT_NOT_FOUND;
257: end GetAppEvent;

Line 272: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

268:
269: begin
270: l_module_source := G_MODULE_SOURCE || 'PutAppEventStatus: ';
271:
272: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
273: then
274: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
275: if (fnd_log.LEVEL_STATEMENT>= fnd_log.G_CURRENT_RUNTIME_LEVEL)
276: then

Line 274: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

270: l_module_source := G_MODULE_SOURCE || 'PutAppEventStatus: ';
271:
272: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
273: then
274: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
275: if (fnd_log.LEVEL_STATEMENT>= fnd_log.G_CURRENT_RUNTIME_LEVEL)
276: then
277: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
278: , 'event_status = ' || fnd_oid_util.get_ldap_event_status_str(event_status));

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

271:
272: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
273: then
274: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
275: if (fnd_log.LEVEL_STATEMENT>= fnd_log.G_CURRENT_RUNTIME_LEVEL)
276: then
277: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
278: , 'event_status = ' || fnd_oid_util.get_ldap_event_status_str(event_status));
279: end if;

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

273: then
274: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
275: if (fnd_log.LEVEL_STATEMENT>= fnd_log.G_CURRENT_RUNTIME_LEVEL)
276: then
277: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
278: , 'event_status = ' || fnd_oid_util.get_ldap_event_status_str(event_status));
279: end if;
280: end if;
281:

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

285: end if;
286:
287: fnd_oid_util.get_entity_key_value(event_status.event_id, l_entity_key_value);
288:
289: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
290: then
291: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
292: 'l_entity_key_value = ' || l_entity_key_value);
293: end if;

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

287: fnd_oid_util.get_entity_key_value(event_status.event_id, l_entity_key_value);
288:
289: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
290: then
291: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
292: 'l_entity_key_value = ' || l_entity_key_value);
293: end if;
294:
295:

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

302: where user_name = l_entity_key_value;
303: else
304: return;
305: end if;
306: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
307: then
308: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
309: , 'Update FND_USER where user_name = ' || l_entity_key_value ||
310: ' with user_guid = ' || event_status.orclguid);

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

304: return;
305: end if;
306: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
307: then
308: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
309: , 'Update FND_USER where user_name = ' || l_entity_key_value ||
310: ' with user_guid = ' || event_status.orclguid);
311: end if;
312:

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

321:
322: delete from wf_entity_changes
323: where entity_id = event_status.event_id;
324:
325: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
326: then
327: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
328: , 'Deleted WF_ENTITY_CHANGES where entity_id = ' ||
329: event_status.event_id);

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

323: where entity_id = event_status.event_id;
324:
325: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
326: then
327: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
328: , 'Deleted WF_ENTITY_CHANGES where entity_id = ' ||
329: event_status.event_id);
330: end if;
331: else

Line 338: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

334:
335: end if;
336:
337:
338: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
339: then
340: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
341: end if;
342:

Line 340: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');

336:
337:
338: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
339: then
340: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
341: end if;
342:
343: exception
344: -- FIXME: Review the behavior with OID team

Line 346: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

342:
343: exception
344: -- FIXME: Review the behavior with OID team
345: when null_event_status_exp then
346: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
347: then
348: fnd_log.string(fnd_log.LEVEL_EXCEPTION, l_module_source,
349: 'Received null_event_status_exp from OiD');
350: end if;

Line 348: fnd_log.string(fnd_log.LEVEL_EXCEPTION, l_module_source,

344: -- FIXME: Review the behavior with OID team
345: when null_event_status_exp then
346: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
347: then
348: fnd_log.string(fnd_log.LEVEL_EXCEPTION, l_module_source,
349: 'Received null_event_status_exp from OiD');
350: end if;
351: when no_data_found then
352: -- FIXME: Review the behavior with OID team

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

349: 'Received null_event_status_exp from OiD');
350: end if;
351: when no_data_found then
352: -- FIXME: Review the behavior with OID team
353: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
354: then
355: fnd_log.string(fnd_log.LEVEL_EXCEPTION, l_module_source,
356: 'No Data Found');
357: end if;

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

351: when no_data_found then
352: -- FIXME: Review the behavior with OID team
353: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
354: then
355: fnd_log.string(fnd_log.LEVEL_EXCEPTION, l_module_source,
356: 'No Data Found');
357: end if;
358: --RDESPOTO, 09/23/2004
359: if(fnd_log.LEVEL_UNEXPECTED >=

Line 359: if(fnd_log.LEVEL_UNEXPECTED >=

355: fnd_log.string(fnd_log.LEVEL_EXCEPTION, l_module_source,
356: 'No Data Found');
357: end if;
358: --RDESPOTO, 09/23/2004
359: if(fnd_log.LEVEL_UNEXPECTED >=
360: fnd_log.G_CURRENT_RUNTIME_LEVEL) then
361: fnd_message.SET_NAME('FND', 'FND_SSO_EVENT_ERROR');
362: fnd_message.SET_TOKEN('USER_NAME', l_entity_key_value);
363: fnd_message.SET_TOKEN('ENTITY_ID', event_status.event_id);

Line 360: fnd_log.G_CURRENT_RUNTIME_LEVEL) then

356: 'No Data Found');
357: end if;
358: --RDESPOTO, 09/23/2004
359: if(fnd_log.LEVEL_UNEXPECTED >=
360: fnd_log.G_CURRENT_RUNTIME_LEVEL) then
361: fnd_message.SET_NAME('FND', 'FND_SSO_EVENT_ERROR');
362: fnd_message.SET_TOKEN('USER_NAME', l_entity_key_value);
363: fnd_message.SET_TOKEN('ENTITY_ID', event_status.event_id);
364: fnd_message.SET_TOKEN('ORCLGUID', event_status.orclguid);

Line 365: fnd_log.MESSAGE(fnd_log.LEVEL_UNEXPECTED,

361: fnd_message.SET_NAME('FND', 'FND_SSO_EVENT_ERROR');
362: fnd_message.SET_TOKEN('USER_NAME', l_entity_key_value);
363: fnd_message.SET_TOKEN('ENTITY_ID', event_status.event_id);
364: fnd_message.SET_TOKEN('ORCLGUID', event_status.orclguid);
365: fnd_log.MESSAGE(fnd_log.LEVEL_UNEXPECTED,
366: l_module_source, TRUE);
367: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source,
368: 'Synchronization of user definiton between E-Business Suite'||
369: ' and Oracle Internet Directory has failed for user:' || l_entity_key_value ||

Line 367: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source,

363: fnd_message.SET_TOKEN('ENTITY_ID', event_status.event_id);
364: fnd_message.SET_TOKEN('ORCLGUID', event_status.orclguid);
365: fnd_log.MESSAGE(fnd_log.LEVEL_UNEXPECTED,
366: l_module_source, TRUE);
367: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source,
368: 'Synchronization of user definiton between E-Business Suite'||
369: ' and Oracle Internet Directory has failed for user:' || l_entity_key_value ||
370: ', event id:' || event_status.event_id || ', guid:' || event_status.orclguid);
371: end if;

Line 373: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

369: ' and Oracle Internet Directory has failed for user:' || l_entity_key_value ||
370: ', event id:' || event_status.event_id || ', guid:' || event_status.orclguid);
371: end if;
372: when others then
373: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
374: then
375: fnd_log.string(fnd_log.LEVEL_EXCEPTION, l_module_source, sqlerrm);
376: end if;
377: --RDESPOTO, 09/23/2004

Line 375: fnd_log.string(fnd_log.LEVEL_EXCEPTION, l_module_source, sqlerrm);

371: end if;
372: when others then
373: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
374: then
375: fnd_log.string(fnd_log.LEVEL_EXCEPTION, l_module_source, sqlerrm);
376: end if;
377: --RDESPOTO, 09/23/2004
378: if(fnd_log.LEVEL_UNEXPECTED >=
379: fnd_log.G_CURRENT_RUNTIME_LEVEL) then

Line 378: if(fnd_log.LEVEL_UNEXPECTED >=

374: then
375: fnd_log.string(fnd_log.LEVEL_EXCEPTION, l_module_source, sqlerrm);
376: end if;
377: --RDESPOTO, 09/23/2004
378: if(fnd_log.LEVEL_UNEXPECTED >=
379: fnd_log.G_CURRENT_RUNTIME_LEVEL) then
380: fnd_message.SET_NAME('FND', 'FND_SSO_EVENT_ERROR');
381: fnd_message.SET_TOKEN('USER_NAME', l_entity_key_value);
382: fnd_message.SET_TOKEN('ENTITY_ID', event_status.event_id);

Line 379: fnd_log.G_CURRENT_RUNTIME_LEVEL) then

375: fnd_log.string(fnd_log.LEVEL_EXCEPTION, l_module_source, sqlerrm);
376: end if;
377: --RDESPOTO, 09/23/2004
378: if(fnd_log.LEVEL_UNEXPECTED >=
379: fnd_log.G_CURRENT_RUNTIME_LEVEL) then
380: fnd_message.SET_NAME('FND', 'FND_SSO_EVENT_ERROR');
381: fnd_message.SET_TOKEN('USER_NAME', l_entity_key_value);
382: fnd_message.SET_TOKEN('ENTITY_ID', event_status.event_id);
383: fnd_message.SET_TOKEN('ORCLGUID', event_status.orclguid);

Line 384: fnd_log.MESSAGE(fnd_log.LEVEL_UNEXPECTED,

380: fnd_message.SET_NAME('FND', 'FND_SSO_EVENT_ERROR');
381: fnd_message.SET_TOKEN('USER_NAME', l_entity_key_value);
382: fnd_message.SET_TOKEN('ENTITY_ID', event_status.event_id);
383: fnd_message.SET_TOKEN('ORCLGUID', event_status.orclguid);
384: fnd_log.MESSAGE(fnd_log.LEVEL_UNEXPECTED,
385: l_module_source, TRUE);
386: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source,
387: 'Synchronization of user definiton between E-Business Suite'||
388: ' and Oracle Internet Directory has failed for user:' || l_entity_key_value ||

Line 386: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source,

382: fnd_message.SET_TOKEN('ENTITY_ID', event_status.event_id);
383: fnd_message.SET_TOKEN('ORCLGUID', event_status.orclguid);
384: fnd_log.MESSAGE(fnd_log.LEVEL_UNEXPECTED,
385: l_module_source, TRUE);
386: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source,
387: 'Synchronization of user definiton between E-Business Suite'||
388: ' and Oracle Internet Directory has failed for user:' || l_entity_key_value ||
389: ', event id:' || event_status.event_id || ', guid:' || event_status.orclguid);
390: end if;