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 742: hz_utility_v2pub.DEBUG

738:
739: BEGIN
740: -- debug info
741: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
742: hz_utility_v2pub.DEBUG
743: (p_message=>'SYNCHPERSONWFROLE()+',
744: p_prefix =>l_debug_prefix,
745: p_msg_level=>fnd_log.level_statement);
746: END IF;

Line 813: hz_utility_v2pub.DEBUG

809: EXCEPTION
810: WHEN NO_DATA_FOUND THEN
811: -- Debug info.
812: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
813: hz_utility_v2pub.DEBUG
814: (p_message=>'no data found to sync',
815: p_prefix =>l_debug_prefix,
816: p_msg_level=>fnd_log.level_statement);
817: END IF;

Line 823: hz_utility_v2pub.DEBUG

819:
820: IF (system_id IS NOT NULL) THEN
821: -- if there is a valid record from TCA Registry to Sync
822: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
823: hz_utility_v2pub.DEBUG
824: (p_message=>'Orig system ID:'||system_id,
825: p_prefix =>l_debug_prefix,
826: p_msg_level=>fnd_log.level_statement);
827: END IF;

Line 855: hz_utility_v2pub.DEBUG

851: wf_event.AddParameterToList('WFSYNCH_OVERWRITE', 'TRUE', List);
852: end if;
853:
854: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
855: hz_utility_v2pub.DEBUG
856: (p_message=>'bfr Calling WF_LOCAL_SYNCH.propagate_role API',
857: p_prefix =>l_debug_prefix,
858: p_msg_level=>fnd_log.level_statement);
859: END IF;

Line 872: hz_utility_v2pub.DEBUG

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

Line 1016: hz_utility_v2pub.DEBUG

1012: BEGIN
1013: SAVEPOINT SynchContactWFRole;
1014: -- Debug info.
1015: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1016: hz_utility_v2pub.DEBUG
1017: (p_message=>'SynchContactWFRole()+',
1018: p_prefix =>l_debug_prefix,
1019: p_msg_level=>fnd_log.level_statement);
1020: END IF;

Line 1024: hz_utility_v2pub.DEBUG

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

Line 1031: hz_utility_v2pub.DEBUG

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

Line 1044: hz_utility_v2pub.DEBUG

1040: LOOP
1041: -- for each of the selected record from TCA Registry
1042: -- perform WF Synchronization.
1043: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1044: hz_utility_v2pub.DEBUG
1045: (p_message=>'At '||i||' Rec',
1046: p_prefix =>l_debug_prefix,
1047: p_msg_level=>fnd_log.level_statement);
1048: END IF;

Line 1055: hz_utility_v2pub.DEBUG

1051: -- for each of the valid record with a partyId
1052:
1053: List := WF_PARAMETER_LIST_T();
1054: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1055: hz_utility_v2pub.DEBUG
1056: (p_message=>'Orig system ID: '||l_tbl(i).system_id,
1057: p_prefix =>l_debug_prefix,
1058: p_msg_level=>fnd_log.level_statement);
1059: END IF;

Line 1088: hz_utility_v2pub.DEBUG

1084: wf_event.AddParameterToList('WFSYNCH_OVERWRITE', 'TRUE', List);
1085: END IF;
1086:
1087: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1088: hz_utility_v2pub.DEBUG
1089: (p_message=>'Before WF API Call',
1090: p_prefix =>l_debug_prefix,
1091: p_msg_level=>fnd_log.level_statement);
1092: END IF;

Line 1106: hz_utility_v2pub.DEBUG

1102: END IF; -- check for valid TCA id ends
1103: END LOOP; -- looping through all selected record ends
1104:
1105: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1106: hz_utility_v2pub.DEBUG
1107: (p_message=>'SynchContactWFRole()-',
1108: p_prefix =>l_debug_prefix,
1109: p_msg_level=>fnd_log.level_statement);
1110: END IF;

Line 1115: hz_utility_v2pub.DEBUG

1111:
1112: EXCEPTION
1113: WHEN NO_DATA_FOUND THEN
1114: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1115: hz_utility_v2pub.DEBUG
1116: (p_message=>'No data found excep:'||sqlerrm,
1117: p_prefix =>l_debug_prefix,
1118: p_msg_level=>fnd_log.level_statement);
1119: END IF;

Line 1183: hz_utility_v2pub.DEBUG

1179: BEGIN
1180: SAVEPOINT SynchGroupWFRole;
1181: -- Debug info.
1182: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1183: hz_utility_v2pub.DEBUG
1184: (p_message=>'SynchGroupWFRole()+',
1185: p_prefix =>l_debug_prefix,
1186: p_msg_level=>fnd_log.level_statement);
1187: END IF;

Line 1199: hz_utility_v2pub.DEBUG

1195:
1196: BEGIN -- anonymous block to select the TCA Registry
1197: -- Debug info.
1198: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1199: hz_utility_v2pub.DEBUG
1200: (p_message=>'Bfr Selecting the data',
1201: p_prefix =>l_debug_prefix,
1202: p_msg_level=>fnd_log.level_statement);
1203: END IF;

Line 1265: hz_utility_v2pub.DEBUG

1261: EXCEPTION
1262: WHEN NO_DATA_FOUND THEN
1263: -- Debug info.
1264: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1265: hz_utility_v2pub.DEBUG
1266: (p_message=>'no data found to sync',
1267: p_prefix =>l_debug_prefix,
1268: p_msg_level=>fnd_log.level_statement);
1269: END IF;

Line 1277: hz_utility_v2pub.DEBUG

1273: IF (system_id IS NOT NULL) THEN
1274:
1275: -- if there any record to be synchonized with WF
1276: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1277: hz_utility_v2pub.DEBUG
1278: (p_message=>'Orig system ID:'||system_id,
1279: p_prefix =>l_debug_prefix,
1280: p_msg_level=>fnd_log.level_statement);
1281: END IF;

Line 1309: hz_utility_v2pub.DEBUG

1305: wf_event.AddParameterToList('WFSYNCH_OVERWRITE', 'TRUE', List);
1306: END IF;
1307:
1308: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1309: hz_utility_v2pub.DEBUG
1310: (p_message=>'bfr Calling WF_LOCAL_SYNCH.propagate_role API',
1311: p_prefix =>l_debug_prefix,
1312: p_msg_level=>fnd_log.level_statement);
1313: END IF;

Line 1326: hz_utility_v2pub.DEBUG

1322: END IF; -- if there is any TCA Registry record to sync, check ends
1323:
1324: -- Debug info.
1325: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1326: hz_utility_v2pub.DEBUG
1327: (p_message=>'SynchGroupWFRole()-',
1328: p_prefix =>l_debug_prefix,
1329: p_msg_level=>fnd_log.level_statement);
1330: END IF;

Line 1377: hz_utility_v2pub.DEBUG

1373:
1374: BEGIN
1375: -- debug info
1376: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1377: hz_utility_v2pub.DEBUG
1378: (p_message=>'SYNCHGROUPWFUSERROLE()+',
1379: p_prefix =>l_debug_prefix,
1380: p_msg_level=>fnd_log.level_statement);
1381: END IF;

Line 1390: hz_utility_v2pub.DEBUG

1386:
1387: BEGIN
1388: -- Debug info.
1389: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1390: hz_utility_v2pub.DEBUG
1391: (p_message=>'Bfr Selecting the data',
1392: p_prefix =>l_debug_prefix,
1393: p_msg_level=>fnd_log.level_statement);
1394: END IF;

Line 1432: hz_utility_v2pub.DEBUG

1428: EXCEPTION
1429: WHEN NO_DATA_FOUND THEN
1430: -- Debug info.
1431: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1432: hz_utility_v2pub.DEBUG
1433: (p_message=>'no data found to sync',
1434: p_prefix =>l_debug_prefix,
1435: p_msg_level=>fnd_log.level_statement);
1436: END IF;

Line 1444: hz_utility_v2pub.DEBUG

1440: END; -- anonymous block for selecting the person-group relationships end
1441:
1442: BEGIN
1443: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1444: hz_utility_v2pub.DEBUG
1445: (p_message=>'User Sys:'||user_system||' USER sysID:'||user_system_id,
1446: p_prefix =>l_debug_prefix,
1447: p_msg_level=>fnd_log.level_statement);
1448: END IF;

Line 1450: hz_utility_v2pub.DEBUG

1446: p_prefix =>l_debug_prefix,
1447: p_msg_level=>fnd_log.level_statement);
1448: END IF;
1449: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1450: hz_utility_v2pub.DEBUG
1451: (p_message=>'Role Sys:'||role_system||' Role sysID:'||role_system_id,
1452: p_prefix =>l_debug_prefix,
1453: p_msg_level=>fnd_log.level_statement);
1454: END IF;

Line 1467: hz_utility_v2pub.DEBUG

1463:
1464: EXCEPTION
1465: WHEN NO_DATA_FOUND THEN
1466: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1467: hz_utility_v2pub.DEBUG
1468: (p_message=>'No data found to propagate_user_role',
1469: p_prefix =>l_debug_prefix,
1470: p_msg_level=>fnd_log.level_statement);
1471: END IF;

Line 1476: hz_utility_v2pub.DEBUG

1472: -- as there is no data to sync as user role, first sync person and
1473: -- then group. After syncing person and group as roles, then sync
1474: -- person-Group as user role.
1475: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1476: hz_utility_v2pub.DEBUG
1477: (p_message=>'Bfr SynchPersonWFRole to propagate per:'||user_system_id,
1478: p_prefix =>l_debug_prefix,
1479: p_msg_level=>fnd_log.level_statement);
1480: END IF;

Line 1485: hz_utility_v2pub.DEBUG

1481:
1482: SynchPersonWFRole(user_system_id);
1483:
1484: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1485: hz_utility_v2pub.DEBUG
1486: (p_message=>'Bfr SynchGroupWFRole to propagate grp:'||role_system_id,
1487: p_prefix =>l_debug_prefix,
1488: p_msg_level=>fnd_log.level_statement);
1489: END IF;

Line 1494: hz_utility_v2pub.DEBUG

1490:
1491: SynchGroupWFRole(role_system_id);
1492:
1493: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1494: hz_utility_v2pub.DEBUG
1495: (p_message=>'Bfr WF_LOCAL_SYNCH.propagate_user_role()',
1496: p_prefix =>l_debug_prefix,
1497: p_msg_level=>fnd_log.level_statement);
1498: END IF;

Line 1510: hz_utility_v2pub.DEBUG

1506: expiration_date);
1507: END; -- anonymous block to propagate the wf tables end.
1508: -- debug info
1509: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1510: hz_utility_v2pub.DEBUG
1511: (p_message=>'SYNCHGROUPWFUSERROLE()-',
1512: p_prefix =>l_debug_prefix,
1513: p_msg_level=>fnd_log.level_statement);
1514: END IF;