APPS.BEN_PUMP_GET dependencies on HR_DATA_PUMP

Line 41: hr_data_pump.fail('get_acty_base_rt_id1', sqlerrm, p_business_group_id, p_acty_base_rate_name1, p_effective_date);

37: END IF;
38: return(l_acty_base_rt_id);
39: exception
40: when others then
41: hr_data_pump.fail('get_acty_base_rt_id1', sqlerrm, p_business_group_id, p_acty_base_rate_name1, p_effective_date);
42: raise;
43: end get_acty_base_rt_id1;
44: --
45: /* returns an acty_base_rt_id2 */

Line 69: hr_data_pump.fail('get_acty_base_rt_id2', sqlerrm, p_business_group_id, p_acty_base_rate_name2, p_effective_date);

65: END IF;
66: return(l_acty_base_rt_id);
67: exception
68: when others then
69: hr_data_pump.fail('get_acty_base_rt_id2', sqlerrm, p_business_group_id, p_acty_base_rate_name2, p_effective_date);
70: raise;
71: end get_acty_base_rt_id2;
72: --
73: /* returns an acty_base_rt_id */

Line 97: hr_data_pump.fail('get_acty_base_rt_id3', sqlerrm, p_business_group_id, p_acty_base_rate_name3, p_effective_date);

93: END IF;
94: return(l_acty_base_rt_id);
95: exception
96: when others then
97: hr_data_pump.fail('get_acty_base_rt_id3', sqlerrm, p_business_group_id, p_acty_base_rate_name3, p_effective_date);
98: raise;
99: end get_acty_base_rt_id3;
100: --
101: /* returns an acty_base_rt_id4 */

Line 125: hr_data_pump.fail('get_acty_base_rt_id4', sqlerrm, p_business_group_id, p_acty_base_rate_name4, p_effective_date);

121: END IF;
122: return(l_acty_base_rt_id);
123: exception
124: when others then
125: hr_data_pump.fail('get_acty_base_rt_id4', sqlerrm, p_business_group_id, p_acty_base_rate_name4, p_effective_date);
126: raise;
127: end get_acty_base_rt_id4;
128: --
129: ------------------------------ get_pgm_id ---------------------------

Line 161: hr_data_pump.fail('get_pgm_id', sqlerrm, p_business_group_id, p_program,p_program_num, p_effective_date);

157: END IF;
158: return(l_pgm_id);
159: exception
160: when others then
161: hr_data_pump.fail('get_pgm_id', sqlerrm, p_business_group_id, p_program,p_program_num, p_effective_date);
162: raise;
163: end get_pgm_id;
164: --
165:

Line 190: hr_data_pump.fail('get_pl_id', sqlerrm, p_business_group_id, p_plan, p_effective_date);

186: END IF;
187: return(l_pl_id);
188: exception
189: when others then
190: hr_data_pump.fail('get_pl_id', sqlerrm, p_business_group_id, p_plan, p_effective_date);
191: raise;
192: end get_pl_id;
193: --
194: /* returns a ended_pl_id */

Line 218: hr_data_pump.fail('get_ended_pl_id', sqlerrm, p_business_group_id, p_ended_plan, p_effective_date);

214: END IF;
215: return(l_pl_id);
216: exception
217: when others then
218: hr_data_pump.fail('get_ended_pl_id', sqlerrm, p_business_group_id, p_ended_plan, p_effective_date);
219: raise;
220: end get_ended_pl_id;
221: --
222: /* returns an opt_id */

Line 246: hr_data_pump.fail('get_opt_id', sqlerrm, p_business_group_id, p_option, p_effective_date);

242: END IF;
243: return(l_opt_id);
244: exception
245: when others then
246: hr_data_pump.fail('get_opt_id', sqlerrm, p_business_group_id, p_option, p_effective_date);
247: raise;
248: end get_opt_id;
249: --
250: /* returns an ended_opt_id */

Line 276: hr_data_pump.fail('get_ended_opt_id', sqlerrm, p_business_group_id, p_ended_option, p_effective_date);

272: --
273: return(l_opt_id);
274: exception
275: when others then
276: hr_data_pump.fail('get_ended_opt_id', sqlerrm, p_business_group_id, p_ended_option, p_effective_date);
277: raise;
278: end get_ended_opt_id;
279: --
280: ------------------------------ get_pen_person_id ---------------------------

Line 350: hr_data_pump.fail('get_pen_person_id', sqlerrm,

346: --
347: return l_person_id ;
348: --
349: exception when others then
350: hr_data_pump.fail('get_pen_person_id', sqlerrm,
351: p_business_group_id, p_employee_number, p_national_identifier,
352: p_full_name,p_date_of_birth, p_effective_date);
353: raise;
354: end get_pen_person_id ;

Line 419: hr_data_pump.fail('get_con_person_id', sqlerrm,

415: --
416: return l_person_id ;
417: --
418: exception when others then
419: hr_data_pump.fail('get_con_person_id', sqlerrm,
420: p_business_group_id, p_con_employee_number, p_con_national_identifier,
421: p_con_full_name,p_con_date_of_birth, p_effective_date);
422: raise;
423: end get_con_person_id ;