1: PACKAGE BODY BEN_CWB_MASS_NOTIFN_PKG as
2: /* $Header: bencwbnf.pkb 120.10.12010000.3 2008/09/18 07:31:00 sgnanama ship $ */
3:
4: TYPE pid IS RECORD (
5: person_id ben_per_in_ler.person_id%type);
18: TYPE g_users_t IS TABLE OF fnd_user.user_name%type;
19:
20: g_actn VARCHAR2 (2000);
21: g_proc VARCHAR2 (80);
22: g_package VARCHAR2 (80) := 'BEN_CWB_MASS_NOTIFN_PKG';
23: g_selected_persons g_person_sel_table_type := g_person_sel_table_type();
24: g_sent_total NUMBER;
25: g_unsent_total NUMBER;
26:
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;
432: -- --------------------------------------------------------------------------
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;
472:
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;
1107:
1104: WRITE('ERROR! '||l_error);
1105: --raise;
1106: END;
1107:
1108: end BEN_CWB_MASS_NOTIFN_PKG;