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.

[Home] [Help]

APPS.HZ_WF_SYNCH dependencies on FND_LOG

Line 70: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

66: (l_key like 'oracle.apps.ar.hz.Relationship.update%') THEN
67: id := p_event.getValueForParameter('RELATIONSHIP_ID');
68: SynchGroupWFUserRole(id);
69: -- Debug info.
70: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
71: hz_utility_v2pub.debug(
72: p_message=>'After calling the propagate_user_role for the relationship_id '||id,
73: p_prefix =>l_debug_prefix,
74: p_msg_level=>fnd_log.level_statement);

Line 74: p_msg_level=>fnd_log.level_statement);

70: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
71: hz_utility_v2pub.debug(
72: p_message=>'After calling the propagate_user_role for the relationship_id '||id,
73: p_prefix =>l_debug_prefix,
74: p_msg_level=>fnd_log.level_statement);
75: END IF;
76: END IF; -- chk for Relationship Create or Update Events
77: RETURN 'SUCCESS';
78: EXCEPTION

Line 181: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

177:
178: IF (l_key LIKE 'oracle.apps.ar.hz.Person.create%') THEN
179:
180: -- Debug info.
181: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
182: hz_utility_v2pub.debug(
183: p_message=>l_key,
184: p_prefix =>l_debug_prefix,
185: p_msg_level=>fnd_log.level_statement);

Line 185: p_msg_level=>fnd_log.level_statement);

181: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
182: hz_utility_v2pub.debug(
183: p_message=>l_key,
184: p_prefix =>l_debug_prefix,
185: p_msg_level=>fnd_log.level_statement);
186: END IF;
187:
188: wf_party_id := p_event.getValueForParameter('PARTY_ID');
189: SynchPersonWFRole(wf_party_id);

Line 192: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

188: wf_party_id := p_event.getValueForParameter('PARTY_ID');
189: SynchPersonWFRole(wf_party_id);
190:
191: -- Debug info.
192: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
193: hz_utility_v2pub.debug(
194: p_message=>'After calling the SynchPersonWFRole for party '||wf_party_id,
195: p_prefix =>l_debug_prefix,
196: p_msg_level=>fnd_log.level_statement);

Line 196: p_msg_level=>fnd_log.level_statement);

192: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
193: hz_utility_v2pub.debug(
194: p_message=>'After calling the SynchPersonWFRole for party '||wf_party_id,
195: p_prefix =>l_debug_prefix,
196: p_msg_level=>fnd_log.level_statement);
197: END IF;
198:
199: ELSIF (l_key LIKE 'oracle.apps.ar.hz.Person.update%') THEN
200: -- Debug info.

Line 201: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

197: END IF;
198:
199: ELSIF (l_key LIKE 'oracle.apps.ar.hz.Person.update%') THEN
200: -- Debug info.
201: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
202: hz_utility_v2pub.debug(
203: p_message=>l_key,
204: p_prefix =>l_debug_prefix,
205: p_msg_level=>fnd_log.level_statement);

Line 205: p_msg_level=>fnd_log.level_statement);

201: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
202: hz_utility_v2pub.debug(
203: p_message=>l_key,
204: p_prefix =>l_debug_prefix,
205: p_msg_level=>fnd_log.level_statement);
206: END IF;
207:
208: wf_party_id := p_event.getValueForParameter('PARTY_ID');
209: SynchPersonWFRole(wf_party_id,TRUE,TRUE);

Line 212: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

208: wf_party_id := p_event.getValueForParameter('PARTY_ID');
209: SynchPersonWFRole(wf_party_id,TRUE,TRUE);
210:
211: -- Debug info.
212: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
213: hz_utility_v2pub.debug(
214: p_message=>'After calling the SynchPersonWFRole for party '||wf_party_id,
215: p_prefix =>l_debug_prefix,
216: p_msg_level=>fnd_log.level_statement);

Line 216: p_msg_level=>fnd_log.level_statement);

212: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
213: hz_utility_v2pub.debug(
214: p_message=>'After calling the SynchPersonWFRole for party '||wf_party_id,
215: p_prefix =>l_debug_prefix,
216: p_msg_level=>fnd_log.level_statement);
217: END IF;
218:
219: --While updating the person details, his details in contact should
220: --also be updated in workflow tables

Line 226: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

222: SynchContactWFRole(Contact.party_id,TRUE,TRUE);
223: End Loop;
224:
225: -- Debug info.
226: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
227: hz_utility_v2pub.debug(
228: p_message=>'After updating the contact details in WF for subject partyid: '||wf_party_id,
229: p_prefix =>l_debug_prefix,
230: p_msg_level=>fnd_log.level_statement);

Line 230: p_msg_level=>fnd_log.level_statement);

226: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
227: hz_utility_v2pub.debug(
228: p_message=>'After updating the contact details in WF for subject partyid: '||wf_party_id,
229: p_prefix =>l_debug_prefix,
230: p_msg_level=>fnd_log.level_statement);
231: END IF;
232:
233: ELSIF (l_key LIKE 'oracle.apps.ar.hz.PersonLanguage.create%') THEN
234: -- Debug info.

Line 235: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

231: END IF;
232:
233: ELSIF (l_key LIKE 'oracle.apps.ar.hz.PersonLanguage.create%') THEN
234: -- Debug info.
235: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
236: hz_utility_v2pub.debug(
237: p_message=>l_key,
238: p_prefix =>l_debug_prefix,
239: p_msg_level=>fnd_log.level_statement);

Line 239: p_msg_level=>fnd_log.level_statement);

235: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
236: hz_utility_v2pub.debug(
237: p_message=>l_key,
238: p_prefix =>l_debug_prefix,
239: p_msg_level=>fnd_log.level_statement);
240: END IF;
241:
242: wf_lang_user_ref_id := p_event.getValueForParameter('LANGUAGE_USE_REFERENCE_ID');
243:

Line 256: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

252: language_use_reference_id = wf_lang_user_ref_id;
253: EXCEPTION
254: WHEN NO_DATA_FOUND THEN
255: -- Debug info.
256: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
257: hz_utility_v2pub.debug(
258: p_message=>'No person found for language_use_reference_id: '||wf_lang_user_ref_id,
259: p_prefix =>l_debug_prefix,
260: p_msg_level=>fnd_log.level_statement);

Line 260: p_msg_level=>fnd_log.level_statement);

256: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
257: hz_utility_v2pub.debug(
258: p_message=>'No person found for language_use_reference_id: '||wf_lang_user_ref_id,
259: p_prefix =>l_debug_prefix,
260: p_msg_level=>fnd_log.level_statement);
261: hz_utility_v2pub.debug(
262: p_message=>'No person party_id found for event '||l_key,
263: p_prefix =>l_debug_prefix,
264: p_msg_level=>fnd_log.level_statement);

Line 264: p_msg_level=>fnd_log.level_statement);

260: p_msg_level=>fnd_log.level_statement);
261: hz_utility_v2pub.debug(
262: p_message=>'No person party_id found for event '||l_key,
263: p_prefix =>l_debug_prefix,
264: p_msg_level=>fnd_log.level_statement);
265: END IF;
266: END; -- end of anonymous block to find the person corresponding to language
267:
268: --For personLanguage create event it tries to synch all the

Line 274: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

270: IF (wf_party_type = 'PERSON') THEN
271: -- sync person
272: SynchPersonWFRole(wf_party_id);
273: -- Debug info.
274: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
275: hz_utility_v2pub.debug(
276: p_message=>'After calling the SynchPersonWFRole for party '||wf_party_id,
277: p_prefix =>l_debug_prefix,
278: p_msg_level=>fnd_log.level_statement);

Line 278: p_msg_level=>fnd_log.level_statement);

274: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
275: hz_utility_v2pub.debug(
276: p_message=>'After calling the SynchPersonWFRole for party '||wf_party_id,
277: p_prefix =>l_debug_prefix,
278: p_msg_level=>fnd_log.level_statement);
279: END IF;
280:
281: -- sync all the contacts
282: For Contact in find_contacts

Line 287: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

283: Loop
284: SynchContactWFRole(Contact.party_id);
285: End Loop;
286: -- Debug info.
287: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
288: hz_utility_v2pub.debug(
289: p_message=>'After updating the contact details in WF for subject partyid: '||wf_party_id,
290: p_prefix =>l_debug_prefix,
291: p_msg_level=>fnd_log.level_statement);

Line 291: p_msg_level=>fnd_log.level_statement);

287: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
288: hz_utility_v2pub.debug(
289: p_message=>'After updating the contact details in WF for subject partyid: '||wf_party_id,
290: p_prefix =>l_debug_prefix,
291: p_msg_level=>fnd_log.level_statement);
292: END IF;
293:
294: ELSIF (wf_party_type = 'GROUP') THEN
295: -- sync group

Line 298: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

294: ELSIF (wf_party_type = 'GROUP') THEN
295: -- sync group
296: SynchGroupWFRole(wf_party_id);
297: -- Debug info.
298: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
299: hz_utility_v2pub.debug(
300: p_message=>'After calling the SynchPersonWFRole for party '||wf_party_id,
301: p_prefix =>l_debug_prefix,
302: p_msg_level=>fnd_log.level_statement);

Line 302: p_msg_level=>fnd_log.level_statement);

298: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
299: hz_utility_v2pub.debug(
300: p_message=>'After calling the SynchPersonWFRole for party '||wf_party_id,
301: p_prefix =>l_debug_prefix,
302: p_msg_level=>fnd_log.level_statement);
303: END IF;
304: END IF;
305:
306: --For personLanguage update event it tries to synch all the

Line 311: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

307: --personLanguage related details in workflow table
308:
309: ELSIF (l_key LIKE 'oracle.apps.ar.hz.PersonLanguage.update%') THEN
310: -- Debug info.
311: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
312: hz_utility_v2pub.debug(
313: p_message=>l_key,
314: p_prefix =>l_debug_prefix,
315: p_msg_level=>fnd_log.level_statement);

Line 315: p_msg_level=>fnd_log.level_statement);

311: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
312: hz_utility_v2pub.debug(
313: p_message=>l_key,
314: p_prefix =>l_debug_prefix,
315: p_msg_level=>fnd_log.level_statement);
316: END IF;
317: -- read the lang ref id from param
318: wf_lang_user_ref_id := p_event.getValueForParameter('LANGUAGE_USE_REFERENCE_ID');
319: -- anonymous block to find the person corresponding to language

Line 331: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

327: language_use_reference_id = wf_lang_user_ref_id;
328: EXCEPTION
329: WHEN NO_DATA_FOUND THEN
330: -- Debug info.
331: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
332: hz_utility_v2pub.debug(
333: p_message=>'No person found for language_use_reference_id: '||wf_lang_user_ref_id,
334: p_prefix =>l_debug_prefix,
335: p_msg_level=>fnd_log.level_statement);

Line 335: p_msg_level=>fnd_log.level_statement);

331: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
332: hz_utility_v2pub.debug(
333: p_message=>'No person found for language_use_reference_id: '||wf_lang_user_ref_id,
334: p_prefix =>l_debug_prefix,
335: p_msg_level=>fnd_log.level_statement);
336: hz_utility_v2pub.debug(
337: p_message=>'No person party_id found for event '||l_key,
338: p_prefix =>l_debug_prefix,
339: p_msg_level=>fnd_log.level_statement);

Line 339: p_msg_level=>fnd_log.level_statement);

335: p_msg_level=>fnd_log.level_statement);
336: hz_utility_v2pub.debug(
337: p_message=>'No person party_id found for event '||l_key,
338: p_prefix =>l_debug_prefix,
339: p_msg_level=>fnd_log.level_statement);
340: END IF;
341: END; -- end of anonymous block to find the person corresponding to language
342:
343: IF (wf_party_type = 'PERSON') THEN

Line 347: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

343: IF (wf_party_type = 'PERSON') THEN
344: -- sync person
345: SynchPersonWFRole(wf_party_id,TRUE,TRUE);
346: -- Debug info.
347: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
348: hz_utility_v2pub.debug(
349: p_message=>'After calling the SynchPersonWFRole for party '||wf_party_id,
350: p_prefix =>l_debug_prefix,
351: p_msg_level=>fnd_log.level_statement);

Line 351: p_msg_level=>fnd_log.level_statement);

347: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
348: hz_utility_v2pub.debug(
349: p_message=>'After calling the SynchPersonWFRole for party '||wf_party_id,
350: p_prefix =>l_debug_prefix,
351: p_msg_level=>fnd_log.level_statement);
352: END IF;
353: -- sync all the contacts
354: For Contact in find_contacts Loop
355: SynchContactWFRole(Contact.party_id,TRUE,TRUE);

Line 358: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

354: For Contact in find_contacts Loop
355: SynchContactWFRole(Contact.party_id,TRUE,TRUE);
356: End Loop;
357: -- Debug info.
358: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
359: hz_utility_v2pub.debug(
360: p_message=>'After updating the contact details in WF for subject partyid: '||wf_party_id,
361: p_prefix =>l_debug_prefix,
362: p_msg_level=>fnd_log.level_statement);

Line 362: p_msg_level=>fnd_log.level_statement);

358: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
359: hz_utility_v2pub.debug(
360: p_message=>'After updating the contact details in WF for subject partyid: '||wf_party_id,
361: p_prefix =>l_debug_prefix,
362: p_msg_level=>fnd_log.level_statement);
363: END IF;
364: ELSIF (wf_party_type = 'GROUP') THEN
365: -- sync group
366: SynchGroupWFRole(wf_party_id,TRUE,TRUE);

Line 368: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

364: ELSIF (wf_party_type = 'GROUP') THEN
365: -- sync group
366: SynchGroupWFRole(wf_party_id,TRUE,TRUE);
367: -- Debug info.
368: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
369: hz_utility_v2pub.debug(
370: p_message=>'After calling the SynchPersonWFRole for party '||wf_party_id,
371: p_prefix =>l_debug_prefix,
372: p_msg_level=>fnd_log.level_statement);

Line 372: p_msg_level=>fnd_log.level_statement);

368: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
369: hz_utility_v2pub.debug(
370: p_message=>'After calling the SynchPersonWFRole for party '||wf_party_id,
371: p_prefix =>l_debug_prefix,
372: p_msg_level=>fnd_log.level_statement);
373: END IF;
374: END IF; -- check for party type ends in personLang.update event
375:
376: --On creation of OrgContact this code synchs this details with

Line 380: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

376: --On creation of OrgContact this code synchs this details with
377: --work flow table
378: ELSIF (l_key LIKE 'oracle.apps.ar.hz.OrgContact.create%') THEN
379: -- Debug info.
380: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
381: hz_utility_v2pub.debug(
382: p_message=>l_key,
383: p_prefix =>l_debug_prefix,
384: p_msg_level=>fnd_log.level_statement);

Line 384: p_msg_level=>fnd_log.level_statement);

380: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
381: hz_utility_v2pub.debug(
382: p_message=>l_key,
383: p_prefix =>l_debug_prefix,
384: p_msg_level=>fnd_log.level_statement);
385: END IF;
386: l_match_string := p_event.getValueForParameter('ORG_CONTACT_ID');
387:
388: -- given an orgContactId, get the relParty (Contact) that must be synced

Line 402: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

398: org.org_contact_id=l_match_string;
399:
400: SynchContactWFRole(wf_party_id);
401: -- Debug info.
402: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
403: hz_utility_v2pub.debug(
404: p_message=>'After updating the contact details in WF for partyid: '||wf_party_id,
405: p_prefix =>l_debug_prefix,
406: p_msg_level=>fnd_log.level_statement);

Line 406: p_msg_level=>fnd_log.level_statement);

402: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
403: hz_utility_v2pub.debug(
404: p_message=>'After updating the contact details in WF for partyid: '||wf_party_id,
405: p_prefix =>l_debug_prefix,
406: p_msg_level=>fnd_log.level_statement);
407: END IF;
408: EXCEPTION
409: WHEN NO_DATA_FOUND THEN
410: -- Debug info.

Line 411: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

407: END IF;
408: EXCEPTION
409: WHEN NO_DATA_FOUND THEN
410: -- Debug info.
411: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
412: hz_utility_v2pub.debug(
413: p_message=>'No orgContact found for orgContactId: '||l_match_string,
414: p_prefix =>l_debug_prefix,
415: p_msg_level=>fnd_log.level_statement);

Line 415: p_msg_level=>fnd_log.level_statement);

411: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
412: hz_utility_v2pub.debug(
413: p_message=>'No orgContact found for orgContactId: '||l_match_string,
414: p_prefix =>l_debug_prefix,
415: p_msg_level=>fnd_log.level_statement);
416: hz_utility_v2pub.debug(
417: p_message=>'No rel party_id found for event '||l_key,
418: p_prefix =>l_debug_prefix,
419: p_msg_level=>fnd_log.level_statement);

Line 419: p_msg_level=>fnd_log.level_statement);

415: p_msg_level=>fnd_log.level_statement);
416: hz_utility_v2pub.debug(
417: p_message=>'No rel party_id found for event '||l_key,
418: p_prefix =>l_debug_prefix,
419: p_msg_level=>fnd_log.level_statement);
420: END IF;
421: END; -- end of anonymous block to find the orgContact
422:
423: --On updation of OrgContact this code synchs this details with

Line 427: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

423: --On updation of OrgContact this code synchs this details with
424: --work flow table
425: ELSIF (l_key like 'oracle.apps.ar.hz.OrgContact.update%') THEN
426: -- Debug info.
427: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
428: hz_utility_v2pub.debug(
429: p_message=>l_key,
430: p_prefix =>l_debug_prefix,
431: p_msg_level=>fnd_log.level_statement);

Line 431: p_msg_level=>fnd_log.level_statement);

427: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
428: hz_utility_v2pub.debug(
429: p_message=>l_key,
430: p_prefix =>l_debug_prefix,
431: p_msg_level=>fnd_log.level_statement);
432: END IF;
433: l_match_string := p_event.getValueForParameter('ORG_CONTACT_ID');
434: -- given an orgContactId, get the relParty (Contact) that must be synced
435: -- anonymous block to find the orgContact

Line 448: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

444: org.org_contact_id=l_match_string;
445: -- sync contact
446: SynchContactWFRole(wf_party_id,TRUE,TRUE);
447: -- Debug info.
448: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
449: hz_utility_v2pub.debug(
450: p_message=>'After updating the contact details in WF for partyid: '||wf_party_id,
451: p_prefix =>l_debug_prefix,
452: p_msg_level=>fnd_log.level_statement);

Line 452: p_msg_level=>fnd_log.level_statement);

448: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
449: hz_utility_v2pub.debug(
450: p_message=>'After updating the contact details in WF for partyid: '||wf_party_id,
451: p_prefix =>l_debug_prefix,
452: p_msg_level=>fnd_log.level_statement);
453: END IF;
454: EXCEPTION
455: WHEN NO_DATA_FOUND THEN
456: -- Debug info.

Line 457: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

453: END IF;
454: EXCEPTION
455: WHEN NO_DATA_FOUND THEN
456: -- Debug info.
457: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
458: hz_utility_v2pub.debug(
459: p_message=>'No orgContact found for orgContactId: '||l_match_string,
460: p_prefix =>l_debug_prefix,
461: p_msg_level=>fnd_log.level_statement);

Line 461: p_msg_level=>fnd_log.level_statement);

457: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
458: hz_utility_v2pub.debug(
459: p_message=>'No orgContact found for orgContactId: '||l_match_string,
460: p_prefix =>l_debug_prefix,
461: p_msg_level=>fnd_log.level_statement);
462: hz_utility_v2pub.debug(
463: p_message=>'No rel party_id found for event '||l_key,
464: p_prefix =>l_debug_prefix,
465: p_msg_level=>fnd_log.level_statement);

Line 465: p_msg_level=>fnd_log.level_statement);

461: p_msg_level=>fnd_log.level_statement);
462: hz_utility_v2pub.debug(
463: p_message=>'No rel party_id found for event '||l_key,
464: p_prefix =>l_debug_prefix,
465: p_msg_level=>fnd_log.level_statement);
466: END IF;
467: END; -- end of anonymous block to find the orgContact
468:
469: --On creation of Group party this code synchs this details with

Line 473: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

469: --On creation of Group party this code synchs this details with
470: --work flow table
471: ELSIF (l_key LIKE 'oracle.apps.ar.hz.Group.create%') THEN
472: -- Debug info.
473: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
474: hz_utility_v2pub.debug(
475: p_message=>l_key,
476: p_prefix =>l_debug_prefix,
477: p_msg_level=>fnd_log.level_statement);

Line 477: p_msg_level=>fnd_log.level_statement);

473: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
474: hz_utility_v2pub.debug(
475: p_message=>l_key,
476: p_prefix =>l_debug_prefix,
477: p_msg_level=>fnd_log.level_statement);
478: END IF;
479: l_match_string := p_event.getValueForParameter('PARTY_ID');
480: SynchGroupWFRole(l_match_string);
481: -- Debug info.

Line 482: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

478: END IF;
479: l_match_string := p_event.getValueForParameter('PARTY_ID');
480: SynchGroupWFRole(l_match_string);
481: -- Debug info.
482: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
483: hz_utility_v2pub.debug(
484: p_message=>'After SynchGroupWFRole() for party_id: '||l_match_string,
485: p_prefix =>l_debug_prefix,
486: p_msg_level=>fnd_log.level_statement);

Line 486: p_msg_level=>fnd_log.level_statement);

482: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
483: hz_utility_v2pub.debug(
484: p_message=>'After SynchGroupWFRole() for party_id: '||l_match_string,
485: p_prefix =>l_debug_prefix,
486: p_msg_level=>fnd_log.level_statement);
487: END IF;
488: --On updation of Group party this code synchs this details with
489: --work flow table
490: ELSIF (l_key like 'oracle.apps.ar.hz.Group.update%') THEN

Line 492: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

488: --On updation of Group party this code synchs this details with
489: --work flow table
490: ELSIF (l_key like 'oracle.apps.ar.hz.Group.update%') THEN
491: -- Debug info.
492: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
493: hz_utility_v2pub.debug(
494: p_message=>l_key,
495: p_prefix =>l_debug_prefix,
496: p_msg_level=>fnd_log.level_statement);

Line 496: p_msg_level=>fnd_log.level_statement);

492: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
493: hz_utility_v2pub.debug(
494: p_message=>l_key,
495: p_prefix =>l_debug_prefix,
496: p_msg_level=>fnd_log.level_statement);
497: END IF;
498: l_match_string := p_event.getValueForParameter('PARTY_ID');
499: SynchGroupWFRole(l_match_string,TRUE,TRUE);
500: -- Debug info.

Line 501: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

497: END IF;
498: l_match_string := p_event.getValueForParameter('PARTY_ID');
499: SynchGroupWFRole(l_match_string,TRUE,TRUE);
500: -- Debug info.
501: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
502: hz_utility_v2pub.debug(
503: p_message=>'After SynchGroupWFRole() for party_id: '||l_match_string,
504: p_prefix =>l_debug_prefix,
505: p_msg_level=>fnd_log.level_statement);

Line 505: p_msg_level=>fnd_log.level_statement);

501: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
502: hz_utility_v2pub.debug(
503: p_message=>'After SynchGroupWFRole() for party_id: '||l_match_string,
504: p_prefix =>l_debug_prefix,
505: p_msg_level=>fnd_log.level_statement);
506: END IF;
507: --On creation of ContactPoint this code synchs this details with
508: --work flow table
509: ELSIF (l_key LIKE 'oracle.apps.ar.hz.ContactPoint.create%') THEN

Line 511: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

507: --On creation of ContactPoint this code synchs this details with
508: --work flow table
509: ELSIF (l_key LIKE 'oracle.apps.ar.hz.ContactPoint.create%') THEN
510: -- Debug info.
511: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
512: hz_utility_v2pub.debug(
513: p_message=>l_key,
514: p_prefix =>l_debug_prefix,
515: p_msg_level=>fnd_log.level_statement);

Line 515: p_msg_level=>fnd_log.level_statement);

511: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
512: hz_utility_v2pub.debug(
513: p_message=>l_key,
514: p_prefix =>l_debug_prefix,
515: p_msg_level=>fnd_log.level_statement);
516: END IF;
517: l_match_string := p_event.getValueForParameter('CONTACT_POINT_ID');
518: -- anonymous block to find the party corresponding to CP
519: BEGIN

Line 532: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

528: pt.contact_point_id = l_match_string;
529: EXCEPTION
530: WHEN NO_DATA_FOUND THEN
531: -- Debug info.
532: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
533: hz_utility_v2pub.debug(
534: p_message=>'No party_id found for contact point id: '||l_match_string,
535: p_prefix =>l_debug_prefix,
536: p_msg_level=>fnd_log.level_statement);

Line 536: p_msg_level=>fnd_log.level_statement);

532: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
533: hz_utility_v2pub.debug(
534: p_message=>'No party_id found for contact point id: '||l_match_string,
535: p_prefix =>l_debug_prefix,
536: p_msg_level=>fnd_log.level_statement);
537: hz_utility_v2pub.debug(
538: p_message=>'No party_id found for event '||l_key,
539: p_prefix =>l_debug_prefix,
540: p_msg_level=>fnd_log.level_statement);

Line 540: p_msg_level=>fnd_log.level_statement);

536: p_msg_level=>fnd_log.level_statement);
537: hz_utility_v2pub.debug(
538: p_message=>'No party_id found for event '||l_key,
539: p_prefix =>l_debug_prefix,
540: p_msg_level=>fnd_log.level_statement);
541: END IF;
542: END; -- end of anonymous block to find the party corresponding to CP
543:
544: IF (wf_party_type = 'PERSON') THEN

Line 548: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

544: IF (wf_party_type = 'PERSON') THEN
545: -- sync person
546: SynchPersonWFRole(wf_party_id);
547: -- Debug info.
548: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
549: hz_utility_v2pub.debug(
550: p_message=>'After calling the SynchPersonWFRole for party '||wf_party_id,
551: p_prefix =>l_debug_prefix,
552: p_msg_level=>fnd_log.level_statement);

Line 552: p_msg_level=>fnd_log.level_statement);

548: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
549: hz_utility_v2pub.debug(
550: p_message=>'After calling the SynchPersonWFRole for party '||wf_party_id,
551: p_prefix =>l_debug_prefix,
552: p_msg_level=>fnd_log.level_statement);
553: END IF;
554: ELSIF (wf_party_type = 'PARTY_RELATIONSHIP') then
555: -- sync Contact
556: SynchContactWFRole(wf_party_id);

Line 558: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

554: ELSIF (wf_party_type = 'PARTY_RELATIONSHIP') then
555: -- sync Contact
556: SynchContactWFRole(wf_party_id);
557: -- Debug info.
558: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
559: hz_utility_v2pub.debug(
560: p_message=>'After updating the contact details in WF for subject partyid: '||wf_party_id,
561: p_prefix =>l_debug_prefix,
562: p_msg_level=>fnd_log.level_statement);

Line 562: p_msg_level=>fnd_log.level_statement);

558: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
559: hz_utility_v2pub.debug(
560: p_message=>'After updating the contact details in WF for subject partyid: '||wf_party_id,
561: p_prefix =>l_debug_prefix,
562: p_msg_level=>fnd_log.level_statement);
563: END IF;
564: ELSIF (wf_party_type = 'GROUP') THEN
565: -- sync Group
566: SynchGroupWFRole(wf_party_id);

Line 568: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

564: ELSIF (wf_party_type = 'GROUP') THEN
565: -- sync Group
566: SynchGroupWFRole(wf_party_id);
567: -- Debug info.
568: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
569: hz_utility_v2pub.debug(
570: p_message=>'After SynchGroupWFRole() for party_id: '||wf_party_id,
571: p_prefix =>l_debug_prefix,
572: p_msg_level=>fnd_log.level_statement);

Line 572: p_msg_level=>fnd_log.level_statement);

568: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
569: hz_utility_v2pub.debug(
570: p_message=>'After SynchGroupWFRole() for party_id: '||wf_party_id,
571: p_prefix =>l_debug_prefix,
572: p_msg_level=>fnd_log.level_statement);
573: END IF;
574: END IF; -- check of partyType ends
575:
576: --On updation of ContactPoint this code synchs this details with

Line 580: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

576: --On updation of ContactPoint this code synchs this details with
577: --work flow table
578: ELSIF (l_key like 'oracle.apps.ar.hz.ContactPoint.update%') THEN
579: -- Debug info.
580: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
581: hz_utility_v2pub.debug(
582: p_message=>l_key,
583: p_prefix =>l_debug_prefix,
584: p_msg_level=>fnd_log.level_statement);

Line 584: p_msg_level=>fnd_log.level_statement);

580: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
581: hz_utility_v2pub.debug(
582: p_message=>l_key,
583: p_prefix =>l_debug_prefix,
584: p_msg_level=>fnd_log.level_statement);
585: END IF;
586: l_match_string := p_event.getValueForParameter('CONTACT_POINT_ID');
587: -- anonymous block to find the party corresponding to CP
588: BEGIN

Line 599: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

595: pt.contact_point_id = l_match_string;
596: EXCEPTION
597: WHEN NO_DATA_FOUND THEN
598: -- Debug info.
599: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
600: hz_utility_v2pub.debug(
601: p_message=>'No party_id found for contact point id: '||l_match_string,
602: p_prefix =>l_debug_prefix,
603: p_msg_level=>fnd_log.level_statement);

Line 603: p_msg_level=>fnd_log.level_statement);

599: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
600: hz_utility_v2pub.debug(
601: p_message=>'No party_id found for contact point id: '||l_match_string,
602: p_prefix =>l_debug_prefix,
603: p_msg_level=>fnd_log.level_statement);
604: hz_utility_v2pub.debug(
605: p_message=>'No party_id found for event '||l_key,
606: p_prefix =>l_debug_prefix,
607: p_msg_level=>fnd_log.level_statement);

Line 607: p_msg_level=>fnd_log.level_statement);

603: p_msg_level=>fnd_log.level_statement);
604: hz_utility_v2pub.debug(
605: p_message=>'No party_id found for event '||l_key,
606: p_prefix =>l_debug_prefix,
607: p_msg_level=>fnd_log.level_statement);
608: END IF;
609: END; -- end of anonymous block to find the party corresponding to CP
610:
611: IF (wf_party_type = 'PERSON') THEN

Line 615: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

611: IF (wf_party_type = 'PERSON') THEN
612: -- sync person
613: SynchPersonWFRole(wf_party_id,TRUE,TRUE);
614: -- Debug info.
615: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
616: hz_utility_v2pub.debug(
617: p_message=>'After calling the SynchPersonWFRole for party '||wf_party_id,
618: p_prefix =>l_debug_prefix,
619: p_msg_level=>fnd_log.level_statement);

Line 619: p_msg_level=>fnd_log.level_statement);

615: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
616: hz_utility_v2pub.debug(
617: p_message=>'After calling the SynchPersonWFRole for party '||wf_party_id,
618: p_prefix =>l_debug_prefix,
619: p_msg_level=>fnd_log.level_statement);
620: END IF;
621: ELSIF (wf_party_type = 'PARTY_RELATIONSHIP') then
622: -- sync Contact
623: SynchContactWFRole(wf_party_id,TRUE,TRUE);

Line 625: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

621: ELSIF (wf_party_type = 'PARTY_RELATIONSHIP') then
622: -- sync Contact
623: SynchContactWFRole(wf_party_id,TRUE,TRUE);
624: -- Debug info.
625: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
626: hz_utility_v2pub.debug(
627: p_message=>'After updating the contact details in WF for subject partyid: '||wf_party_id,
628: p_prefix =>l_debug_prefix,
629: p_msg_level=>fnd_log.level_statement);

Line 629: p_msg_level=>fnd_log.level_statement);

625: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
626: hz_utility_v2pub.debug(
627: p_message=>'After updating the contact details in WF for subject partyid: '||wf_party_id,
628: p_prefix =>l_debug_prefix,
629: p_msg_level=>fnd_log.level_statement);
630: END IF;
631: ELSIF (wf_party_type = 'GROUP') THEN
632: -- sync Group
633: SynchGroupWFRole(wf_party_id,TRUE,TRUE);

Line 635: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

631: ELSIF (wf_party_type = 'GROUP') THEN
632: -- sync Group
633: SynchGroupWFRole(wf_party_id,TRUE,TRUE);
634: -- Debug info.
635: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
636: hz_utility_v2pub.debug(
637: p_message=>'After SynchGroupWFRole() for party_id: '||wf_party_id,
638: p_prefix =>l_debug_prefix,
639: p_msg_level=>fnd_log.level_statement);

Line 639: p_msg_level=>fnd_log.level_statement);

635: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
636: hz_utility_v2pub.debug(
637: p_message=>'After SynchGroupWFRole() for party_id: '||wf_party_id,
638: p_prefix =>l_debug_prefix,
639: p_msg_level=>fnd_log.level_statement);
640: END IF;
641: END IF; -- check of partyType ends
642:
643: --On updation of Organization this code synchs this details with

Line 647: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

643: --On updation of Organization this code synchs this details with
644: --work flow table
645: ELSIF (l_key like 'oracle.apps.ar.hz.Organization.update%') THEN
646: -- Debug info.
647: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
648: hz_utility_v2pub.debug(
649: p_message=>l_key,
650: p_prefix =>l_debug_prefix,
651: p_msg_level=>fnd_log.level_statement);

Line 651: p_msg_level=>fnd_log.level_statement);

647: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
648: hz_utility_v2pub.debug(
649: p_message=>l_key,
650: p_prefix =>l_debug_prefix,
651: p_msg_level=>fnd_log.level_statement);
652: END IF;
653: l_match_string := p_event.getValueForParameter('PARTY_ID');
654: -- sync all orgContacts for the Org
655: For orga_update in org_update Loop

Line 659: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

655: For orga_update in org_update Loop
656: SynchContactWFRole(orga_update.party_id,TRUE,TRUE);
657: End Loop;
658: -- Debug info.
659: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
660: hz_utility_v2pub.debug(p_message=>'After updating the Contact details in WF for Org party_id: '||l_match_string,
661: p_prefix =>l_debug_prefix,
662: p_msg_level=>fnd_log.level_statement);
663: END IF;

Line 662: p_msg_level=>fnd_log.level_statement);

658: -- Debug info.
659: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
660: hz_utility_v2pub.debug(p_message=>'After updating the Contact details in WF for Org party_id: '||l_match_string,
661: p_prefix =>l_debug_prefix,
662: p_msg_level=>fnd_log.level_statement);
663: END IF;
664:
665: END IF; -- end of event key check
666:

Line 745: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

741: l_debug_prefix VARCHAR2(30) := 'SYNCPERWFROLE';
742:
743: BEGIN
744: -- debug info
745: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
746: hz_utility_v2pub.DEBUG
747: (p_message=>'SYNCHPERSONWFROLE()+',
748: p_prefix =>l_debug_prefix,
749: p_msg_level=>fnd_log.level_statement);

Line 749: p_msg_level=>fnd_log.level_statement);

745: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
746: hz_utility_v2pub.DEBUG
747: (p_message=>'SYNCHPERSONWFROLE()+',
748: p_prefix =>l_debug_prefix,
749: p_msg_level=>fnd_log.level_statement);
750: END IF;
751: SAVEPOINT SynchPersonWFRole;
752: /*
753: As part of Bug 4390816, following changes were done to this procedure:

Line 817: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

813: AND pl.language_name = fl.language_code(+);
814: EXCEPTION
815: WHEN NO_DATA_FOUND THEN
816: -- Debug info.
817: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
818: hz_utility_v2pub.DEBUG
819: (p_message=>'no data found to sync',
820: p_prefix =>l_debug_prefix,
821: p_msg_level=>fnd_log.level_statement);

Line 821: p_msg_level=>fnd_log.level_statement);

817: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
818: hz_utility_v2pub.DEBUG
819: (p_message=>'no data found to sync',
820: p_prefix =>l_debug_prefix,
821: p_msg_level=>fnd_log.level_statement);
822: END IF;
823: END; -- anonymous block to fetch the TCA Registry records ends
824:
825: IF (system_id IS NOT NULL) THEN

Line 827: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

823: END; -- anonymous block to fetch the TCA Registry records ends
824:
825: IF (system_id IS NOT NULL) THEN
826: -- if there is a valid record from TCA Registry to Sync
827: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
828: hz_utility_v2pub.DEBUG
829: (p_message=>'Orig system ID:'||system_id,
830: p_prefix =>l_debug_prefix,
831: p_msg_level=>fnd_log.level_statement);

Line 831: p_msg_level=>fnd_log.level_statement);

827: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
828: hz_utility_v2pub.DEBUG
829: (p_message=>'Orig system ID:'||system_id,
830: p_prefix =>l_debug_prefix,
831: p_msg_level=>fnd_log.level_statement);
832: END IF;
833:
834: -- Add the TCA registry Data as parameters to wf_event
835: -- This is needed as the WF API access the wf_event structure for

Line 859: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

855: if (p_overwrite = TRUE) then
856: wf_event.AddParameterToList('WFSYNCH_OVERWRITE', 'TRUE', List);
857: end if;
858:
859: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
860: hz_utility_v2pub.DEBUG
861: (p_message=>'bfr Calling WF_LOCAL_SYNCH.propagate_role API',
862: p_prefix =>l_debug_prefix,
863: p_msg_level=>fnd_log.level_statement);

Line 863: p_msg_level=>fnd_log.level_statement);

859: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
860: hz_utility_v2pub.DEBUG
861: (p_message=>'bfr Calling WF_LOCAL_SYNCH.propagate_role API',
862: p_prefix =>l_debug_prefix,
863: p_msg_level=>fnd_log.level_statement);
864: END IF;
865:
866: -- call WF API for Synchronization
867: WF_LOCAL_SYNCH.propagate_user(

Line 876: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

872: expiration_date);
873: END IF; -- check for valid TCA id ends
874:
875: -- debug info
876: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
877: hz_utility_v2pub.DEBUG
878: (p_message=>'SYNCHPERSONWFROLE()-',
879: p_prefix =>l_debug_prefix,
880: p_msg_level=>fnd_log.level_statement);

Line 880: p_msg_level=>fnd_log.level_statement);

876: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
877: hz_utility_v2pub.DEBUG
878: (p_message=>'SYNCHPERSONWFROLE()-',
879: p_prefix =>l_debug_prefix,
880: p_msg_level=>fnd_log.level_statement);
881: END IF;
882:
883: END SYNCHPERSONWFROLE;
884: -------------------------------------------------------------------------

Line 1020: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1016:
1017: BEGIN
1018: SAVEPOINT SynchContactWFRole;
1019: -- Debug info.
1020: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1021: hz_utility_v2pub.DEBUG
1022: (p_message=>'SynchContactWFRole()+',
1023: p_prefix =>l_debug_prefix,
1024: p_msg_level=>fnd_log.level_statement);

Line 1024: p_msg_level=>fnd_log.level_statement);

1020: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1021: hz_utility_v2pub.DEBUG
1022: (p_message=>'SynchContactWFRole()+',
1023: p_prefix =>l_debug_prefix,
1024: p_msg_level=>fnd_log.level_statement);
1025: END IF;
1026:
1027: OPEN c_rel(PartyId);
1028: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1028: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1024: p_msg_level=>fnd_log.level_statement);
1025: END IF;
1026:
1027: OPEN c_rel(PartyId);
1028: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1029: hz_utility_v2pub.DEBUG
1030: (p_message=>'OPENED THE CURSOR',
1031: p_prefix =>l_debug_prefix,
1032: p_msg_level=>fnd_log.level_statement);

Line 1032: p_msg_level=>fnd_log.level_statement);

1028: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1029: hz_utility_v2pub.DEBUG
1030: (p_message=>'OPENED THE CURSOR',
1031: p_prefix =>l_debug_prefix,
1032: p_msg_level=>fnd_log.level_statement);
1033: END IF;
1034: FETCH c_rel BULK COLLECT INTO l_tbl; -- select records from TCA Registry
1035: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1036: hz_utility_v2pub.DEBUG

Line 1035: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1031: p_prefix =>l_debug_prefix,
1032: p_msg_level=>fnd_log.level_statement);
1033: END IF;
1034: FETCH c_rel BULK COLLECT INTO l_tbl; -- select records from TCA Registry
1035: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1036: hz_utility_v2pub.DEBUG
1037: (p_message=>'Bulk collected the data',
1038: p_prefix =>l_debug_prefix,
1039: p_msg_level=>fnd_log.level_statement);

Line 1039: p_msg_level=>fnd_log.level_statement);

1035: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1036: hz_utility_v2pub.DEBUG
1037: (p_message=>'Bulk collected the data',
1038: p_prefix =>l_debug_prefix,
1039: p_msg_level=>fnd_log.level_statement);
1040: END IF;
1041: CLOSE c_rel;
1042:
1043: l_rec_count := l_tbl.COUNT;

Line 1053: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1049: FOR i IN l_tbl.FIRST..l_tbl.LAST
1050: LOOP
1051: -- for each of the selected record from TCA Registry
1052: -- perform WF Synchronization.
1053: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1054: hz_utility_v2pub.DEBUG
1055: (p_message=>'At '||i||' Rec',
1056: p_prefix =>l_debug_prefix,
1057: p_msg_level=>fnd_log.level_statement);

Line 1057: p_msg_level=>fnd_log.level_statement);

1053: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1054: hz_utility_v2pub.DEBUG
1055: (p_message=>'At '||i||' Rec',
1056: p_prefix =>l_debug_prefix,
1057: p_msg_level=>fnd_log.level_statement);
1058: END IF;
1059:
1060: IF (l_tbl(i).system_id IS NOT NULL) THEN
1061: -- for each of the valid record with a partyId

Line 1064: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1060: IF (l_tbl(i).system_id IS NOT NULL) THEN
1061: -- for each of the valid record with a partyId
1062:
1063: List := WF_PARAMETER_LIST_T();
1064: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1065: hz_utility_v2pub.DEBUG
1066: (p_message=>'Orig system ID: '||l_tbl(i).system_id,
1067: p_prefix =>l_debug_prefix,
1068: p_msg_level=>fnd_log.level_statement);

Line 1068: p_msg_level=>fnd_log.level_statement);

1064: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1065: hz_utility_v2pub.DEBUG
1066: (p_message=>'Orig system ID: '||l_tbl(i).system_id,
1067: p_prefix =>l_debug_prefix,
1068: p_msg_level=>fnd_log.level_statement);
1069: END IF;
1070:
1071: -- Add the TCA registry Data as parameters to wf_event
1072: -- This is needed as the WF API access the wf_event structure for

Line 1097: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1093: IF (p_overwrite = TRUE) THEN
1094: wf_event.AddParameterToList('WFSYNCH_OVERWRITE', 'TRUE', List);
1095: END IF;
1096:
1097: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1098: hz_utility_v2pub.DEBUG
1099: (p_message=>'Before WF API Call',
1100: p_prefix =>l_debug_prefix,
1101: p_msg_level=>fnd_log.level_statement);

Line 1101: p_msg_level=>fnd_log.level_statement);

1097: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1098: hz_utility_v2pub.DEBUG
1099: (p_message=>'Before WF API Call',
1100: p_prefix =>l_debug_prefix,
1101: p_msg_level=>fnd_log.level_statement);
1102: END IF;
1103:
1104: -- call WF API for Synchronization
1105:

Line 1115: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1111: l_tbl(i).expiration_date);
1112: END IF; -- check for valid TCA id ends
1113: END LOOP; -- looping through all selected record ends
1114: ELSE
1115: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1116: hz_utility_v2pub.DEBUG
1117: (p_message=>'No record found at c_rel cursor. ',
1118: p_prefix =>l_debug_prefix,
1119: p_msg_level=>fnd_log.level_statement);

Line 1119: p_msg_level=>fnd_log.level_statement);

1115: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1116: hz_utility_v2pub.DEBUG
1117: (p_message=>'No record found at c_rel cursor. ',
1118: p_prefix =>l_debug_prefix,
1119: p_msg_level=>fnd_log.level_statement);
1120: END IF;
1121:
1122: END IF; -- For l_rec_count check.
1123: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1123: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1119: p_msg_level=>fnd_log.level_statement);
1120: END IF;
1121:
1122: END IF; -- For l_rec_count check.
1123: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1124: hz_utility_v2pub.DEBUG
1125: (p_message=>'SynchContactWFRole()-',
1126: p_prefix =>l_debug_prefix,
1127: p_msg_level=>fnd_log.level_statement);

Line 1127: p_msg_level=>fnd_log.level_statement);

1123: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1124: hz_utility_v2pub.DEBUG
1125: (p_message=>'SynchContactWFRole()-',
1126: p_prefix =>l_debug_prefix,
1127: p_msg_level=>fnd_log.level_statement);
1128: END IF;
1129:
1130: EXCEPTION
1131: WHEN NO_DATA_FOUND THEN

Line 1132: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1128: END IF;
1129:
1130: EXCEPTION
1131: WHEN NO_DATA_FOUND THEN
1132: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1133: hz_utility_v2pub.DEBUG
1134: (p_message=>'No data found excep:'||sqlerrm,
1135: p_prefix =>l_debug_prefix,
1136: p_msg_level=>fnd_log.level_statement);

Line 1136: p_msg_level=>fnd_log.level_statement);

1132: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1133: hz_utility_v2pub.DEBUG
1134: (p_message=>'No data found excep:'||sqlerrm,
1135: p_prefix =>l_debug_prefix,
1136: p_msg_level=>fnd_log.level_statement);
1137: END IF;
1138: -- no error is raised as not finding any record to sync is not an error.
1139: WHEN OTHERS THEN
1140: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1140: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1136: p_msg_level=>fnd_log.level_statement);
1137: END IF;
1138: -- no error is raised as not finding any record to sync is not an error.
1139: WHEN OTHERS THEN
1140: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1141: hz_utility_v2pub.DEBUG
1142: (p_message=>'Error raised :'||sqlerrm,
1143: p_prefix =>l_debug_prefix,
1144: p_msg_level=>fnd_log.level_statement);

Line 1144: p_msg_level=>fnd_log.level_statement);

1140: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1141: hz_utility_v2pub.DEBUG
1142: (p_message=>'Error raised :'||sqlerrm,
1143: p_prefix =>l_debug_prefix,
1144: p_msg_level=>fnd_log.level_statement);
1145: END IF;
1146: END SynchContactWFRole;
1147:
1148: -------------------------------------------------------------------------

Line 1207: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1203:
1204: BEGIN
1205: SAVEPOINT SynchGroupWFRole;
1206: -- Debug info.
1207: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1208: hz_utility_v2pub.DEBUG
1209: (p_message=>'SynchGroupWFRole()+',
1210: p_prefix =>l_debug_prefix,
1211: p_msg_level=>fnd_log.level_statement);

Line 1211: p_msg_level=>fnd_log.level_statement);

1207: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1208: hz_utility_v2pub.DEBUG
1209: (p_message=>'SynchGroupWFRole()+',
1210: p_prefix =>l_debug_prefix,
1211: p_msg_level=>fnd_log.level_statement);
1212: END IF;
1213:
1214: -- As part of Bug 4390816, following changes were done to this procedure:
1215: -- select stmt changes

Line 1223: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1219: -- 4. mission statement is truncated to 1000 chars
1220:
1221: BEGIN -- anonymous block to select the TCA Registry
1222: -- Debug info.
1223: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1224: hz_utility_v2pub.DEBUG
1225: (p_message=>'Bfr Selecting the data',
1226: p_prefix =>l_debug_prefix,
1227: p_msg_level=>fnd_log.level_statement);

Line 1227: p_msg_level=>fnd_log.level_statement);

1223: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1224: hz_utility_v2pub.DEBUG
1225: (p_message=>'Bfr Selecting the data',
1226: p_prefix =>l_debug_prefix,
1227: p_msg_level=>fnd_log.level_statement);
1228: END IF;
1229: /*
1230: BUG 4957312 changes
1231: 1. email_format a.k.a Notification Preference defaulting was re-inroduced.

Line 1289: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1285: AND pl.language_name = fl.language_code(+);
1286: EXCEPTION
1287: WHEN NO_DATA_FOUND THEN
1288: -- Debug info.
1289: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1290: hz_utility_v2pub.DEBUG
1291: (p_message=>'no data found to sync',
1292: p_prefix =>l_debug_prefix,
1293: p_msg_level=>fnd_log.level_statement);

Line 1293: p_msg_level=>fnd_log.level_statement);

1289: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1290: hz_utility_v2pub.DEBUG
1291: (p_message=>'no data found to sync',
1292: p_prefix =>l_debug_prefix,
1293: p_msg_level=>fnd_log.level_statement);
1294: END IF;
1295: -- no error is raised as not finding any record to sync is not an error.
1296: END; -- anonymous block to query the TCA Registry ends
1297:

Line 1301: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1297:
1298: IF (system_id IS NOT NULL) THEN
1299:
1300: -- if there any record to be synchonized with WF
1301: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1302: hz_utility_v2pub.DEBUG
1303: (p_message=>'Orig system ID:'||system_id,
1304: p_prefix =>l_debug_prefix,
1305: p_msg_level=>fnd_log.level_statement);

Line 1305: p_msg_level=>fnd_log.level_statement);

1301: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1302: hz_utility_v2pub.DEBUG
1303: (p_message=>'Orig system ID:'||system_id,
1304: p_prefix =>l_debug_prefix,
1305: p_msg_level=>fnd_log.level_statement);
1306: END IF;
1307:
1308: -- Add the TCA registry Data as parameters to wf_event
1309: -- This is needed as the WF API access the wf_event structure for

Line 1333: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1329: IF (p_overwrite = TRUE) then
1330: wf_event.AddParameterToList('WFSYNCH_OVERWRITE', 'TRUE', List);
1331: END IF;
1332:
1333: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1334: hz_utility_v2pub.DEBUG
1335: (p_message=>'bfr Calling WF_LOCAL_SYNCH.propagate_role API',
1336: p_prefix =>l_debug_prefix,
1337: p_msg_level=>fnd_log.level_statement);

Line 1337: p_msg_level=>fnd_log.level_statement);

1333: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1334: hz_utility_v2pub.DEBUG
1335: (p_message=>'bfr Calling WF_LOCAL_SYNCH.propagate_role API',
1336: p_prefix =>l_debug_prefix,
1337: p_msg_level=>fnd_log.level_statement);
1338: END IF;
1339:
1340: -- calling the WF API to propagate role
1341: WF_LOCAL_SYNCH.propagate_role(

Line 1350: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1346: expiration_date);
1347: END IF; -- if there is any TCA Registry record to sync, check ends
1348:
1349: -- Debug info.
1350: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1351: hz_utility_v2pub.DEBUG
1352: (p_message=>'SynchGroupWFRole()-',
1353: p_prefix =>l_debug_prefix,
1354: p_msg_level=>fnd_log.level_statement);

Line 1354: p_msg_level=>fnd_log.level_statement);

1350: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1351: hz_utility_v2pub.DEBUG
1352: (p_message=>'SynchGroupWFRole()-',
1353: p_prefix =>l_debug_prefix,
1354: p_msg_level=>fnd_log.level_statement);
1355: END IF;
1356: END SYNCHGROUPWFROLE;
1357:
1358: -------------------------------------------------------------------------

Line 1401: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1397: l_debug_prefix VARCHAR2(30) := 'SYNCGRPWFUR';
1398:
1399: BEGIN
1400: -- debug info
1401: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1402: hz_utility_v2pub.DEBUG
1403: (p_message=>'SYNCHGROUPWFUSERROLE()+',
1404: p_prefix =>l_debug_prefix,
1405: p_msg_level=>fnd_log.level_statement);

Line 1405: p_msg_level=>fnd_log.level_statement);

1401: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1402: hz_utility_v2pub.DEBUG
1403: (p_message=>'SYNCHGROUPWFUSERROLE()+',
1404: p_prefix =>l_debug_prefix,
1405: p_msg_level=>fnd_log.level_statement);
1406: END IF;
1407:
1408: SAVEPOINT SynchGroupWFUserRole;
1409: -- changes done because of Bug#4390816 is

Line 1414: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1410: -- removed the filtering based on directional flag from the select stmt
1411:
1412: BEGIN
1413: -- Debug info.
1414: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1415: hz_utility_v2pub.DEBUG
1416: (p_message=>'Bfr Selecting the data',
1417: p_prefix =>l_debug_prefix,
1418: p_msg_level=>fnd_log.level_statement);

Line 1418: p_msg_level=>fnd_log.level_statement);

1414: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1415: hz_utility_v2pub.DEBUG
1416: (p_message=>'Bfr Selecting the data',
1417: p_prefix =>l_debug_prefix,
1418: p_msg_level=>fnd_log.level_statement);
1419: END IF;
1420:
1421: SELECT
1422: 'HZ_PARTY' -- USER_ORIG_SYSTEM

Line 1456: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1452:
1453: EXCEPTION
1454: WHEN NO_DATA_FOUND THEN
1455: -- Debug info.
1456: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1457: hz_utility_v2pub.DEBUG
1458: (p_message=>'no data found to sync',
1459: p_prefix =>l_debug_prefix,
1460: p_msg_level=>fnd_log.level_statement);

Line 1460: p_msg_level=>fnd_log.level_statement);

1456: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1457: hz_utility_v2pub.DEBUG
1458: (p_message=>'no data found to sync',
1459: p_prefix =>l_debug_prefix,
1460: p_msg_level=>fnd_log.level_statement);
1461: END IF;
1462: -- no error is raised as not finding any record to sync is not an error.
1463: -- return the control to the caller as no action is necessary.
1464: RETURN;

Line 1468: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1464: RETURN;
1465: END; -- anonymous block for selecting the person-group relationships end
1466:
1467: BEGIN
1468: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1469: hz_utility_v2pub.DEBUG
1470: (p_message=>'User Sys:'||user_system||' USER sysID:'||user_system_id,
1471: p_prefix =>l_debug_prefix,
1472: p_msg_level=>fnd_log.level_statement);

Line 1472: p_msg_level=>fnd_log.level_statement);

1468: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1469: hz_utility_v2pub.DEBUG
1470: (p_message=>'User Sys:'||user_system||' USER sysID:'||user_system_id,
1471: p_prefix =>l_debug_prefix,
1472: p_msg_level=>fnd_log.level_statement);
1473: END IF;
1474: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1475: hz_utility_v2pub.DEBUG
1476: (p_message=>'Role Sys:'||role_system||' Role sysID:'||role_system_id,

Line 1474: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1470: (p_message=>'User Sys:'||user_system||' USER sysID:'||user_system_id,
1471: p_prefix =>l_debug_prefix,
1472: p_msg_level=>fnd_log.level_statement);
1473: END IF;
1474: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1475: hz_utility_v2pub.DEBUG
1476: (p_message=>'Role Sys:'||role_system||' Role sysID:'||role_system_id,
1477: p_prefix =>l_debug_prefix,
1478: p_msg_level=>fnd_log.level_statement);

Line 1478: p_msg_level=>fnd_log.level_statement);

1474: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1475: hz_utility_v2pub.DEBUG
1476: (p_message=>'Role Sys:'||role_system||' Role sysID:'||role_system_id,
1477: p_prefix =>l_debug_prefix,
1478: p_msg_level=>fnd_log.level_statement);
1479: END IF;
1480:
1481: WF_LOCAL_SYNCH.propagate_user_role(
1482: user_system,

Line 1491: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1487: expiration_date);
1488:
1489: EXCEPTION
1490: WHEN NO_DATA_FOUND THEN
1491: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1492: hz_utility_v2pub.DEBUG
1493: (p_message=>'No data found to propagate_user_role',
1494: p_prefix =>l_debug_prefix,
1495: p_msg_level=>fnd_log.level_statement);

Line 1495: p_msg_level=>fnd_log.level_statement);

1491: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1492: hz_utility_v2pub.DEBUG
1493: (p_message=>'No data found to propagate_user_role',
1494: p_prefix =>l_debug_prefix,
1495: p_msg_level=>fnd_log.level_statement);
1496: END IF;
1497: -- as there is no data to sync as user role, first sync person and
1498: -- then group. After syncing person and group as roles, then sync
1499: -- person-Group as user role.

Line 1500: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1496: END IF;
1497: -- as there is no data to sync as user role, first sync person and
1498: -- then group. After syncing person and group as roles, then sync
1499: -- person-Group as user role.
1500: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1501: hz_utility_v2pub.DEBUG
1502: (p_message=>'Bfr SynchPersonWFRole to propagate per:'||user_system_id,
1503: p_prefix =>l_debug_prefix,
1504: p_msg_level=>fnd_log.level_statement);

Line 1504: p_msg_level=>fnd_log.level_statement);

1500: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1501: hz_utility_v2pub.DEBUG
1502: (p_message=>'Bfr SynchPersonWFRole to propagate per:'||user_system_id,
1503: p_prefix =>l_debug_prefix,
1504: p_msg_level=>fnd_log.level_statement);
1505: END IF;
1506:
1507: SynchPersonWFRole(user_system_id);
1508:

Line 1509: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1505: END IF;
1506:
1507: SynchPersonWFRole(user_system_id);
1508:
1509: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1510: hz_utility_v2pub.DEBUG
1511: (p_message=>'Bfr SynchGroupWFRole to propagate grp:'||role_system_id,
1512: p_prefix =>l_debug_prefix,
1513: p_msg_level=>fnd_log.level_statement);

Line 1513: p_msg_level=>fnd_log.level_statement);

1509: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1510: hz_utility_v2pub.DEBUG
1511: (p_message=>'Bfr SynchGroupWFRole to propagate grp:'||role_system_id,
1512: p_prefix =>l_debug_prefix,
1513: p_msg_level=>fnd_log.level_statement);
1514: END IF;
1515:
1516: SynchGroupWFRole(role_system_id);
1517:

Line 1518: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1514: END IF;
1515:
1516: SynchGroupWFRole(role_system_id);
1517:
1518: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1519: hz_utility_v2pub.DEBUG
1520: (p_message=>'Bfr WF_LOCAL_SYNCH.propagate_user_role()',
1521: p_prefix =>l_debug_prefix,
1522: p_msg_level=>fnd_log.level_statement);

Line 1522: p_msg_level=>fnd_log.level_statement);

1518: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1519: hz_utility_v2pub.DEBUG
1520: (p_message=>'Bfr WF_LOCAL_SYNCH.propagate_user_role()',
1521: p_prefix =>l_debug_prefix,
1522: p_msg_level=>fnd_log.level_statement);
1523: END IF;
1524:
1525: WF_LOCAL_SYNCH.propagate_user_role(
1526: user_system,

Line 1534: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1530: start_date,
1531: expiration_date);
1532: END; -- anonymous block to propagate the wf tables end.
1533: -- debug info
1534: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1535: hz_utility_v2pub.DEBUG
1536: (p_message=>'SYNCHGROUPWFUSERROLE()-',
1537: p_prefix =>l_debug_prefix,
1538: p_msg_level=>fnd_log.level_statement);

Line 1538: p_msg_level=>fnd_log.level_statement);

1534: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1535: hz_utility_v2pub.DEBUG
1536: (p_message=>'SYNCHGROUPWFUSERROLE()-',
1537: p_prefix =>l_debug_prefix,
1538: p_msg_level=>fnd_log.level_statement);
1539: END IF;
1540: END SYNCHGROUPWFUSERROLE;
1541: -------------------------------------------------------------------------
1542: -------------------------------------------------------------------------