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

APPS.HZ_WF_SYNCH dependencies on HZ_UTILITY_V2PUB

Line 71: hz_utility_v2pub.debug(

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);
75: END IF;

Line 182: hz_utility_v2pub.debug(

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);
186: END IF;

Line 193: hz_utility_v2pub.debug(

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);
197: END IF;

Line 202: hz_utility_v2pub.debug(

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);
206: END IF;

Line 213: hz_utility_v2pub.debug(

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);
217: END IF;

Line 227: hz_utility_v2pub.debug(

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);
231: END IF;

Line 236: hz_utility_v2pub.debug(

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);
240: END IF;

Line 257: hz_utility_v2pub.debug(

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);
261: hz_utility_v2pub.debug(

Line 261: hz_utility_v2pub.debug(

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);
265: END IF;

Line 275: hz_utility_v2pub.debug(

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);
279: END IF;

Line 288: hz_utility_v2pub.debug(

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);
292: END IF;

Line 299: hz_utility_v2pub.debug(

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);
303: END IF;

Line 312: hz_utility_v2pub.debug(

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);
316: END IF;

Line 332: hz_utility_v2pub.debug(

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);
336: hz_utility_v2pub.debug(

Line 336: hz_utility_v2pub.debug(

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);
340: END IF;

Line 348: hz_utility_v2pub.debug(

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);
352: END IF;

Line 359: hz_utility_v2pub.debug(

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);
363: END IF;

Line 369: hz_utility_v2pub.debug(

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);
373: END IF;

Line 381: hz_utility_v2pub.debug(

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);
385: END IF;

Line 403: hz_utility_v2pub.debug(

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);
407: END IF;

Line 412: hz_utility_v2pub.debug(

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);
416: hz_utility_v2pub.debug(

Line 416: hz_utility_v2pub.debug(

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);
420: END IF;

Line 428: hz_utility_v2pub.debug(

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);
432: END IF;

Line 449: hz_utility_v2pub.debug(

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);
453: END IF;

Line 458: hz_utility_v2pub.debug(

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);
462: hz_utility_v2pub.debug(

Line 462: hz_utility_v2pub.debug(

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);
466: END IF;

Line 474: hz_utility_v2pub.debug(

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);
478: END IF;

Line 483: hz_utility_v2pub.debug(

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);
487: END IF;

Line 493: hz_utility_v2pub.debug(

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);
497: END IF;

Line 502: hz_utility_v2pub.debug(

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);
506: END IF;

Line 512: hz_utility_v2pub.debug(

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);
516: END IF;

Line 533: hz_utility_v2pub.debug(

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);
537: hz_utility_v2pub.debug(

Line 537: hz_utility_v2pub.debug(

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);
541: END IF;

Line 549: hz_utility_v2pub.debug(

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);
553: END IF;

Line 559: hz_utility_v2pub.debug(

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);
563: END IF;

Line 569: hz_utility_v2pub.debug(

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);
573: END IF;

Line 581: hz_utility_v2pub.debug(

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);
585: END IF;

Line 600: hz_utility_v2pub.debug(

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);
604: hz_utility_v2pub.debug(

Line 604: hz_utility_v2pub.debug(

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);
608: END IF;

Line 616: hz_utility_v2pub.debug(

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);
620: END IF;

Line 626: hz_utility_v2pub.debug(

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);
630: END IF;

Line 636: hz_utility_v2pub.debug(

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);
640: END IF;

Line 648: hz_utility_v2pub.debug(

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);
652: END IF;

Line 660: hz_utility_v2pub.debug(p_message=>'After updating the Contact details in WF for Org party_id: '||l_match_string,

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;
664:

Line 746: hz_utility_v2pub.DEBUG

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);
750: END IF;

Line 818: hz_utility_v2pub.DEBUG

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);
822: END IF;

Line 828: hz_utility_v2pub.DEBUG

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);
832: END IF;

Line 860: hz_utility_v2pub.DEBUG

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);
864: END IF;

Line 877: hz_utility_v2pub.DEBUG

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);
881: END IF;

Line 1021: hz_utility_v2pub.DEBUG

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);
1025: END IF;

Line 1029: hz_utility_v2pub.DEBUG

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);
1033: END IF;

Line 1036: hz_utility_v2pub.DEBUG

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);
1040: END IF;

Line 1054: hz_utility_v2pub.DEBUG

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);
1058: END IF;

Line 1065: hz_utility_v2pub.DEBUG

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);
1069: END IF;

Line 1098: hz_utility_v2pub.DEBUG

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);
1102: END IF;

Line 1116: hz_utility_v2pub.DEBUG

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);
1120: END IF;

Line 1124: hz_utility_v2pub.DEBUG

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);
1128: END IF;

Line 1133: hz_utility_v2pub.DEBUG

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);
1137: END IF;

Line 1141: hz_utility_v2pub.DEBUG

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);
1145: END IF;

Line 1208: hz_utility_v2pub.DEBUG

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);
1212: END IF;

Line 1224: hz_utility_v2pub.DEBUG

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);
1228: END IF;

Line 1290: hz_utility_v2pub.DEBUG

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);
1294: END IF;

Line 1302: hz_utility_v2pub.DEBUG

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);
1306: END IF;

Line 1334: hz_utility_v2pub.DEBUG

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);
1338: END IF;

Line 1351: hz_utility_v2pub.DEBUG

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);
1355: END IF;

Line 1402: hz_utility_v2pub.DEBUG

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);
1406: END IF;

Line 1415: hz_utility_v2pub.DEBUG

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);
1419: END IF;

Line 1457: hz_utility_v2pub.DEBUG

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);
1461: END IF;

Line 1469: hz_utility_v2pub.DEBUG

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);
1473: END IF;

Line 1475: hz_utility_v2pub.DEBUG

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);
1479: END IF;

Line 1492: hz_utility_v2pub.DEBUG

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);
1496: END IF;

Line 1501: hz_utility_v2pub.DEBUG

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);
1505: END IF;

Line 1510: hz_utility_v2pub.DEBUG

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);
1514: END IF;

Line 1519: hz_utility_v2pub.DEBUG

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);
1523: END IF;

Line 1535: hz_utility_v2pub.DEBUG

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);
1539: END IF;