368: --
369: EXCEPTION
370: --
371: When ben_batch_utils.g_record_error then
372: hr_utility.set_location(l_package ,10);
373: fnd_message.set_name('BEN','BEN_91698_NO_ASSIGNMENT_FND');
374: fnd_message.set_token('ID' ,to_char(p_person_id) );
375: fnd_message.set_token('PROC',l_package ) ;
376: Ben_batch_utils.write(p_text => '<< Person id : '||to_char(p_person_id)||' failed.'||
376: Ben_batch_utils.write(p_text => '<< Person id : '||to_char(p_person_id)||' failed.'||
377: ' Reason : '|| fnd_message.get ||' >>' );
378: RETURN FALSE;
379: When value_exception then
380: hr_utility.set_location(l_package ,20);
381: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
382: fnd_message.set_token('RL','person_selection_rule_id :'||p_person_selection_rule_id);
383: fnd_message.set_token('PROC',l_package ) ;
384: Ben_batch_utils.write(p_text => '<< Person id : '||to_char(p_person_id)||' failed.'||
384: Ben_batch_utils.write(p_text => '<< Person id : '||to_char(p_person_id)||' failed.'||
385: ' Reason : '|| fnd_message.get ||' >>' );
386: RETURN FALSE;
387: WHEN OTHERS THEN
388: hr_utility.set_location(l_package ,30);
389: Ben_batch_utils.write(p_text => '<< Person id : '||to_char(p_person_id)||' failed.'||
390: ' Reason : '|| SQLERRM ||' >>' );
391: RETURN FALSE;
392: --
410: l_include_link varchar2(240);
411: l_package varchar2(80) := g_package||'.inc_home_link';
412: l_error varchar2(5000);
413: begin
414: hr_utility.set_location('Entering '||l_package ,30);
415: l_include_link := wf_engine.GetItemAttrText(itemtype => itemtype,
416: itemkey => itemkey,
417: aname => 'MASS_NTF_LINK');
418: if ( l_include_link = 'Y') then
419: result:= 'COMPLETE:' ||'Y';
420: else
421: result:= 'COMPLETE:' ||'N';
422: end if;
423: hr_utility.set_location('Leaving '||l_package ,30);
424: EXCEPTION
425: when others then
426: l_error:=sqlerrm;
427: hr_utility.set_location ('exception is'||l_error , 300);
423: hr_utility.set_location('Leaving '||l_package ,30);
424: EXCEPTION
425: when others then
426: l_error:=sqlerrm;
427: hr_utility.set_location ('exception is'||l_error , 300);
428: Wf_Core.Context('BEN_CWB_MASS_NOTIFN_PKG' , 'inc_home_link',l_error);
429: raise;
430:
431: end inc_home_link;
447: l_package varchar2(80) := g_package||'.mass_ntf_cleanup';
448: l_error varchar2(5000);
449:
450: begin
451: hr_utility.set_location('Entering '||l_package ,30);
452: /* removed dynamic role based messaging
453: WF_DIRECTORY.GetRoleUsers('CWB_MASS_NTF_ROLE_TEMP1',users);
454: if users.first is not null then
455: for i in users.first..users.last
459: end loop;
460: end if;
461: */
462: result:= 'COMPLETE:';
463: hr_utility.set_location('Leaving '||l_package ,40);
464: EXCEPTION
465: when others then
466: l_error:=sqlerrm;
467: hr_utility.set_location ('exception is'||l_error , 300);
463: hr_utility.set_location('Leaving '||l_package ,40);
464: EXCEPTION
465: when others then
466: l_error:=sqlerrm;
467: hr_utility.set_location ('exception is'||l_error , 300);
468: Wf_Core.Context('BEN_CWB_MASS_NOTIFN_PKG' , 'mass_ntf_cleanup',l_error);
469: raise;
470:
471: end mass_ntf_cleanup;
486: l_package varchar2(80) := g_package||'.get_item_attribute';
487: l_error varchar2(5000);
488: l_value varchar2(1000);
489: begin
490: hr_utility.set_location('Entering '||l_package ,30);
491: l_value := WF_ENGINE.GetItemAttrText(itemtype => itemtype
492: ,itemkey => itemkey
493: ,aname => aname);
494: hr_utility.set_location('Leaving '||l_package ,40);
490: hr_utility.set_location('Entering '||l_package ,30);
491: l_value := WF_ENGINE.GetItemAttrText(itemtype => itemtype
492: ,itemkey => itemkey
493: ,aname => aname);
494: hr_utility.set_location('Leaving '||l_package ,40);
495: return l_value;
496: EXCEPTION
497: when others then
498: l_error:=sqlerrm;
495: return l_value;
496: EXCEPTION
497: when others then
498: l_error:=sqlerrm;
499: hr_utility.set_location ('exception is'||l_error , 300);
500: raise;
501:
502: end get_item_attribute;
503:
1098: WRITE('===============================END===========================================');
1099: EXCEPTION
1100: when others then
1101: l_error:=sqlerrm;
1102: hr_utility.set_location ('exception is'||l_error , 300);
1103: Wf_Core.Context('BEN_CWB_MASS_NOTIFN_PKG', 'notify',l_error);
1104: WRITE('ERROR! '||l_error);
1105: --raise;
1106: END;