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.BEN_ENROLMENT_REQUIREMENTS2 dependencies on BEN_ENROLMENT_REQUIREMENTS2

Line 1: PACKAGE BODY ben_enrolment_requirements2 AS

1: PACKAGE BODY ben_enrolment_requirements2 AS
2: /* $Header: bendenr2.pkb 120.0 2006/02/16 12:24:50 kmahendr noship $ */
3: -------------------------------------------------------------------------------
4: /*
5: +=============================================================================+

Line 51: hr_utility.set_location('Entering: ben_enrolment_requirements2.get_asg_dets', 10);

47: --
48: g_debug := hr_utility.debug_enabled;
49: --
50: if g_debug then
51: hr_utility.set_location('Entering: ben_enrolment_requirements2.get_asg_dets', 10);
52: end if;
53: --
54: OPEN c_asg
55: (c_per_id => p_person_id

Line 63: fnd_message.set_token('PROC', 'ben_enrolment_requirements2.get_asg_dets');

59: FETCH c_asg INTO l_asg_id, l_org_id;
60: IF c_asg%NOTFOUND THEN
61: CLOSE c_asg;
62: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
63: fnd_message.set_token('PROC', 'ben_enrolment_requirements2.get_asg_dets');
64: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
65: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_leodt));
66: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effdt));
67: RAISE ben_manage_life_events.g_record_error;

Line 75: hr_utility.set_location('Leaving: ben_enrolment_requirements2.get_asg_dets', 50);

71: p_asg_id := l_asg_id;
72: p_org_id := l_org_id;
73: --
74: if g_debug then
75: hr_utility.set_location('Leaving: ben_enrolment_requirements2.get_asg_dets', 50);
76: end if;
77: --
78: END get_asg_dets;
79: --

Line 138: hr_utility.set_location('Entering: ben_enrolment_requirements2.get_perpiller_dets', 10);

134: --
135: g_debug := hr_utility.debug_enabled;
136: --
137: if g_debug then
138: hr_utility.set_location('Entering: ben_enrolment_requirements2.get_perpiller_dets', 10);
139: end if;
140: --
141: OPEN c_per_in_ler_info
142: (c_per_id => p_person_id

Line 160: fnd_message.set_token('PROC', 'ben_enrolment_requirements2.get_perpiller_dets');

156: IF c_per_in_ler_info%NOTFOUND THEN
157: CLOSE c_per_in_ler_info;
158: --
159: fnd_message.set_name('BEN', 'BEN_91272_PER_IN_LER_MISSING');
160: fnd_message.set_token('PROC', 'ben_enrolment_requirements2.get_perpiller_dets');
161: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
162: fnd_message.set_token('LER_ID', TO_CHAR(p_ler_id));
163: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effdt));
164: fnd_message.set_token('BG_ID', TO_CHAR(p_bgp_id));

Line 178: hr_utility.set_location('Leaving: ben_enrolment_requirements2.get_perpiller_dets', 50);

174: p_ler_esd := l_ler_esd;
175: p_ler_eed := l_ler_eed;
176: --
177: if g_debug then
178: hr_utility.set_location('Leaving: ben_enrolment_requirements2.get_perpiller_dets', 50);
179: end if;
180: --
181: END get_perpiller_dets;
182: --

Line 213: hr_utility.set_location('Entering: ben_enrolment_requirements2.get_latest_enrtdt', 10);

209: --
210: g_debug := hr_utility.debug_enabled;
211: --
212: if g_debug then
213: hr_utility.set_location('Entering: ben_enrolment_requirements2.get_latest_enrtdt', 10);
214: end if;
215: --
216: OPEN c_get_latest_enrt_dt
217: (c_per_id => p_person_id

Line 226: hr_utility.set_location('Leaving: ben_enrolment_requirements2.get_latest_enrtdt', 50);

222: --
223: p_pen_mxesd := l_pen_mxesd;
224: --
225: if g_debug then
226: hr_utility.set_location('Leaving: ben_enrolment_requirements2.get_latest_enrtdt', 50);
227: end if;
228: --
229: END get_latest_enrtdt;
230: --

Line 275: hr_utility.set_location('Entering: ben_enrolment_requirements2.bckdout_ler', 10);

271: --
272: g_debug := hr_utility.debug_enabled;
273: --
274: if g_debug then
275: hr_utility.set_location('Entering: ben_enrolment_requirements2.bckdout_ler', 10);
276: end if;
277: --
278: OPEN c_backed_out_ler
279: (c_per_id => p_person_id

Line 291: hr_utility.set_location('Leaving: ben_enrolment_requirements2.bckdout_ler', 50);

287: --
288: p_pil_bcktdt := l_pil_mxbcktdt;
289: --
290: if g_debug then
291: hr_utility.set_location('Leaving: ben_enrolment_requirements2.bckdout_ler', 50);
292: end if;
293: --
294: END bckdout_ler;
295: --

Line 350: hr_utility.set_location('Entering: ben_enrolment_requirements2.ptipenrt_info', 10);

346: --
347: g_debug := hr_utility.debug_enabled;
348: --
349: if g_debug then
350: hr_utility.set_location('Entering: ben_enrolment_requirements2.ptipenrt_info', 10);
351: end if;
352: --
353: OPEN c_ptip_enrolment_info
354: (c_per_id => p_person_id

Line 368: hr_utility.set_location('Leaving: ben_enrolment_requirements2.ptipenrt_info', 50);

364: p_pen_oipl_id := l_pen_oipl_id;
365: p_pen_plip_id := l_pen_plip_id;
366: --
367: if g_debug then
368: hr_utility.set_location('Leaving: ben_enrolment_requirements2.ptipenrt_info', 50);
369: end if;
370: --
371: END ptipenrt_info;
372: --

Line 407: hr_utility.set_location('Entering: ben_enrolment_requirements2.get_lerplipdfltcd', 10);

403: --
404: g_debug := hr_utility.debug_enabled;
405: --
406: if g_debug then
407: hr_utility.set_location('Entering: ben_enrolment_requirements2.get_lerplipdfltcd', 10);
408: end if;
409: --
410: OPEN c_ler_plip_dflt_cd
411: (c_plip_id => p_plip_id

Line 422: hr_utility.set_location('Leaving: ben_enrolment_requirements2.get_lerplipdfltcd', 50);

418: p_lep_dflt_enrt_cd := l_dflt_enrt_cd;
419: p_lep_dflt_enrt_rl := l_dflt_enrt_rl;
420: --
421: if g_debug then
422: hr_utility.set_location('Leaving: ben_enrolment_requirements2.get_lerplipdfltcd', 50);
423: end if;
424: --
425: END get_lerplipdfltcd;
426: --

Line 427: END ben_enrolment_requirements2;

423: end if;
424: --
425: END get_lerplipdfltcd;
426: --
427: END ben_enrolment_requirements2;