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 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 741: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

737: l_debug_prefix VARCHAR2(30) := 'SYNCPERWFROLE';
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);

Line 745: p_msg_level=>fnd_log.level_statement);

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;
747: SAVEPOINT SynchPersonWFRole;
748: /*
749: As part of Bug 4390816, following changes were done to this procedure:

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

808: AND pl.language_name = fl.language_code(+);
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);

Line 816: p_msg_level=>fnd_log.level_statement);

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;
818: END; -- anonymous block to fetch the TCA Registry records ends
819:
820: IF (system_id IS NOT NULL) THEN

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

818: END; -- anonymous block to fetch the TCA Registry records ends
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);

Line 826: p_msg_level=>fnd_log.level_statement);

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;
828:
829: -- Add the TCA registry Data as parameters to wf_event
830: -- This is needed as the WF API access the wf_event structure for

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

850: if (p_overwrite = TRUE) then
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);

Line 858: p_msg_level=>fnd_log.level_statement);

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;
860:
861: -- call WF API for Synchronization
862: WF_LOCAL_SYNCH.propagate_user(

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

867: expiration_date);
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);

Line 875: p_msg_level=>fnd_log.level_statement);

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;
877:
878: END SYNCHPERSONWFROLE;
879: -------------------------------------------------------------------------

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

1011:
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);

Line 1019: p_msg_level=>fnd_log.level_statement);

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;
1021:
1022: OPEN c_rel(PartyId);
1023: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

1019: p_msg_level=>fnd_log.level_statement);
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);

Line 1027: p_msg_level=>fnd_log.level_statement);

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

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

1026: p_prefix =>l_debug_prefix,
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);

Line 1034: p_msg_level=>fnd_log.level_statement);

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;
1036: CLOSE c_rel;
1037:
1038: l_rec_count := l_tbl.COUNT;

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

1039: FOR i IN l_tbl.FIRST..l_tbl.LAST
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);

Line 1047: p_msg_level=>fnd_log.level_statement);

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;
1049:
1050: IF (l_tbl(i).system_id IS NOT NULL) THEN
1051: -- for each of the valid record with a partyId

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

1050: IF (l_tbl(i).system_id IS NOT NULL) THEN
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);

Line 1058: p_msg_level=>fnd_log.level_statement);

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;
1060:
1061: -- Add the TCA registry Data as parameters to wf_event
1062: -- This is needed as the WF API access the wf_event structure for

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

1083: IF (p_overwrite = TRUE) THEN
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);

Line 1091: p_msg_level=>fnd_log.level_statement);

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;
1093:
1094: -- call WF API for Synchronization
1095:

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

1101: l_tbl(i).expiration_date);
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);

Line 1109: p_msg_level=>fnd_log.level_statement);

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;
1111:
1112: EXCEPTION
1113: WHEN NO_DATA_FOUND THEN

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

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

Line 1118: p_msg_level=>fnd_log.level_statement);

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;
1120: -- no error is raised as not finding any record to sync is not an error.
1121: END SynchContactWFRole;
1122:

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

1178:
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);

Line 1186: p_msg_level=>fnd_log.level_statement);

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;
1188:
1189: -- As part of Bug 4390816, following changes were done to this procedure:
1190: -- select stmt changes

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

1194: -- 4. mission statement is truncated to 1000 chars
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);

Line 1202: p_msg_level=>fnd_log.level_statement);

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;
1204: /*
1205: BUG 4957312 changes
1206: 1. email_format a.k.a Notification Preference defaulting was re-inroduced.

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

1260: AND pl.language_name = fl.language_code(+);
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);

Line 1268: p_msg_level=>fnd_log.level_statement);

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;
1270: -- no error is raised as not finding any record to sync is not an error.
1271: END; -- anonymous block to query the TCA Registry ends
1272:

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

1272:
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);

Line 1280: p_msg_level=>fnd_log.level_statement);

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;
1282:
1283: -- Add the TCA registry Data as parameters to wf_event
1284: -- This is needed as the WF API access the wf_event structure for

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

1304: IF (p_overwrite = TRUE) then
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);

Line 1312: p_msg_level=>fnd_log.level_statement);

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;
1314:
1315: -- calling the WF API to propagate role
1316: WF_LOCAL_SYNCH.propagate_role(

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

1321: expiration_date);
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);

Line 1329: p_msg_level=>fnd_log.level_statement);

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;
1331: END SYNCHGROUPWFROLE;
1332:
1333: -------------------------------------------------------------------------

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

1372: l_debug_prefix VARCHAR2(30) := 'SYNCGRPWFUR';
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);

Line 1380: p_msg_level=>fnd_log.level_statement);

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;
1382:
1383: SAVEPOINT SynchGroupWFUserRole;
1384: -- changes done because of Bug#4390816 is

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

1385: -- removed the filtering based on directional flag from the select stmt
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);

Line 1393: p_msg_level=>fnd_log.level_statement);

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;
1395:
1396: SELECT
1397: 'HZ_PARTY' -- USER_ORIG_SYSTEM

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

1427:
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);

Line 1435: p_msg_level=>fnd_log.level_statement);

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;
1437: -- no error is raised as not finding any record to sync is not an error.
1438: -- return the control to the caller as no action is necessary.
1439: RETURN;

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

1439: RETURN;
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);

Line 1447: p_msg_level=>fnd_log.level_statement);

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;
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,

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

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;
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);

Line 1453: p_msg_level=>fnd_log.level_statement);

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;
1455:
1456: WF_LOCAL_SYNCH.propagate_user_role(
1457: user_system,

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

1462: expiration_date);
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);

Line 1470: p_msg_level=>fnd_log.level_statement);

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;
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.

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

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

Line 1479: p_msg_level=>fnd_log.level_statement);

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;
1481:
1482: SynchPersonWFRole(user_system_id);
1483:

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

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

Line 1488: p_msg_level=>fnd_log.level_statement);

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;
1490:
1491: SynchGroupWFRole(role_system_id);
1492:

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

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

Line 1497: p_msg_level=>fnd_log.level_statement);

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;
1499:
1500: WF_LOCAL_SYNCH.propagate_user_role(
1501: user_system,

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

1505: start_date,
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);

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=>'SYNCHGROUPWFUSERROLE()-',
1512: p_prefix =>l_debug_prefix,
1513: p_msg_level=>fnd_log.level_statement);
1514: END IF;
1515: END SYNCHGROUPWFUSERROLE;
1516: -------------------------------------------------------------------------
1517: -------------------------------------------------------------------------