DBA Data[Home] [Help]

APPS.BEN_CWB_MASS_NOTIFN_PKG dependencies on HR_UTILITY

Line 372: hr_utility.set_location(l_package ,10);

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

Line 380: hr_utility.set_location(l_package ,20);

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

Line 388: hr_utility.set_location(l_package ,30);

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

Line 414: hr_utility.set_location('Entering '||l_package ,30);

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

Line 423: hr_utility.set_location('Leaving '||l_package ,30);

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

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

Line 451: hr_utility.set_location('Entering '||l_package ,30);

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

Line 463: hr_utility.set_location('Leaving '||l_package ,40);

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

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

Line 490: hr_utility.set_location('Entering '||l_package ,30);

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

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

Line 499: hr_utility.set_location ('exception is'||l_error , 300);

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:

Line 1102: hr_utility.set_location ('exception is'||l_error , 300);

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;