DBA Data[Home] [Help]

APPS.PER_IN_DATA_PUMP dependencies on HR_DATA_PUMP

Line 59: hr_data_pump.fail('get_opm_ovn', sqlerrm,

55: opm.effective_start_date and opm.effective_end_date;
56: RETURN(l_ovn);
57: EXCEPTION
58: WHEN OTHERS THEN
59: hr_data_pump.fail('get_opm_ovn', sqlerrm,
60: p_org_payment_method_user_key ,p_effective_date);
61: RAISE;
62: END get_opm_ovn;
63:

Line 112: hr_data_pump.fail('get_contact_relationship_ovn',

108: RETURN l_contact_relationship_ovn;
109:
110: EXCEPTION
111: WHEN OTHERS THEN
112: hr_data_pump.fail('get_contact_relationship_ovn',
113: sqlerrm,
114: p_contact_rel_user_key);
115: RAISE;
116: END get_contact_relationship_ovn;

Line 154: hr_data_pump.fail('get_contact_extra_info_ovn', sqlerrm, p_contact_extra_info_user_key ,

150: RETURN(l_ovn);
151:
152: EXCEPTION
153: WHEN OTHERS THEN
154: hr_data_pump.fail('get_contact_extra_info_ovn', sqlerrm, p_contact_extra_info_user_key ,
155: p_effective_date);
156: RAISE;
157: END get_contact_extra_info_ovn;
158:

Line 185: hr_data_pump.fail('get_person_extra_info_ovn',

181:
182: RETURN l_person_extra_info_ovn;
183: EXCEPTION
184: WHEN OTHERS THEN
185: hr_data_pump.fail('get_person_extra_info_ovn',
186: sqlerrm,
187: p_person_extra_info_user_key );
188: RAISE;
189: END get_person_extra_info_ovn;

Line 212: hr_data_pump.fail('get_person_extra_info_id', sqlerrm, p_person_extra_info_user_key);

208:
209: RETURN(l_person_extra_info_id);
210: EXCEPTION
211: WHEN OTHERS THEN
212: hr_data_pump.fail('get_person_extra_info_id', sqlerrm, p_person_extra_info_user_key);
213: RAISE;
214: END get_person_extra_info_id;
215:
216:

Line 244: hr_data_pump.fail('get_passport_country',

240:
241: RETURN l_territory_code;
242: EXCEPTION
243: WHEN OTHERS THEN
244: hr_data_pump.fail('get_passport_country',
245: sqlerrm,
246: p_issuing_country );
247: RAISE;
248: END get_passport_country;

Line 272: hr_data_pump.fail('get_contact_extra_info_id', sqlerrm,p_contact_extra_info_user_key);

268:
269: RETURN(l_contact_extra_info_id);
270: EXCEPTION
271: WHEN OTHERS THEN
272: hr_data_pump.fail('get_contact_extra_info_id', sqlerrm,p_contact_extra_info_user_key);
273: RAISE;
274: END get_contact_extra_info_id;
275:
276: -- -----------------------------------------------------------------------+

Line 342: hr_data_pump.fail('get_gre_id', sqlerrm,p_gre_legal_entity);

338: RETURN get_id(p_gre_legal_entity );
339:
340: EXCEPTION
341: WHEN OTHERS THEN
342: hr_data_pump.fail('get_gre_id', sqlerrm,p_gre_legal_entity);
343: RAISE;
344: END get_gre_id;
345:
346:

Line 367: hr_data_pump.fail('get_pf_org_id', sqlerrm,p_pf_organization);

363: RETURN get_id( p_pf_organization);
364:
365: EXCEPTION
366: WHEN OTHERS THEN
367: hr_data_pump.fail('get_pf_org_id', sqlerrm,p_pf_organization);
368: RAISE;
369: END get_pf_org_id;
370:
371: -- -----------------------------------------------------------------------+

Line 390: hr_data_pump.fail('get_prof_tax_org_id', sqlerrm,p_prof_tax_organization);

386: RETURN get_id( p_prof_tax_organization);
387:
388: EXCEPTION
389: WHEN OTHERS THEN
390: hr_data_pump.fail('get_prof_tax_org_id', sqlerrm,p_prof_tax_organization);
391: RAISE;
392: END get_prof_tax_org_id;
393:
394: -- -----------------------------------------------------------------------+

Line 413: hr_data_pump.fail('get_esi_id', sqlerrm,p_esi_organization);

409: RETURN get_id( p_esi_organization);
410:
411: EXCEPTION
412: WHEN OTHERS THEN
413: hr_data_pump.fail('get_esi_id', sqlerrm,p_esi_organization);
414: RAISE;
415:
416: END get_esi_id;
417:

Line 437: hr_data_pump.fail('get_factory_id', sqlerrm,p_factory);

433: RETURN get_id( p_factory);
434:
435: EXCEPTION
436: WHEN OTHERS THEN
437: hr_data_pump.fail('get_factory_id', sqlerrm,p_factory);
438: RAISE;
439:
440: END get_factory_id;
441:

Line 461: hr_data_pump.fail('get_est_id', sqlerrm,p_establishment);

457: RETURN get_id( p_establishment);
458:
459: EXCEPTION
460: WHEN OTHERS THEN
461: hr_data_pump.fail('get_est_id', sqlerrm,p_establishment);
462: RAISE;
463:
464: END get_est_id;
465:

Line 633: hr_data_pump.fail('get_issue_date', sqlerrm, p_issue_date);

629: BEGIN
630: RETURN fnd_date.date_to_canonical(fnd_date.chardt_to_date(p_issue_date));
631: EXCEPTION
632: WHEN OTHERS THEN
633: hr_data_pump.fail('get_issue_date', sqlerrm, p_issue_date);
634: RAISE;
635: END get_issue_date;
636:
637: -- -----------------------------------------------------------------------+

Line 656: hr_data_pump.fail('get_birth_date', sqlerrm, p_guardian_birth_date);

652: BEGIN
653: RETURN fnd_date.date_to_canonical(fnd_date.chardt_to_date(p_guardian_birth_date));
654: EXCEPTION
655: WHEN OTHERS THEN
656: hr_data_pump.fail('get_birth_date', sqlerrm, p_guardian_birth_date);
657: RAISE;
658: END get_birth_date;
659:
660: -- -----------------------------------------------------------------------+

Line 678: hr_data_pump.fail('get_expiry_date', sqlerrm, p_expiry_date);

674: BEGIN
675: RETURN fnd_date.date_to_canonical(fnd_date.chardt_to_date(p_expiry_date));
676: EXCEPTION
677: WHEN OTHERS THEN
678: hr_data_pump.fail('get_expiry_date', sqlerrm, p_expiry_date);
679: RAISE;
680: END get_expiry_date;
681:
682: -- -----------------------------------------------------------------------+

Line 707: hr_data_pump.fail('get_height', sqlerrm, p_height);

703: RAISE E_INVALID_DATA_ERR;
704: END IF;
705: EXCEPTION
706: WHEN E_INVALID_DATA_ERR THEN
707: hr_data_pump.fail('get_height', sqlerrm, p_height);
708: RAISE;
709: WHEN OTHERS THEN
710: hr_data_pump.fail('get_height', sqlerrm, p_height);
711: RAISE;

Line 710: hr_data_pump.fail('get_height', sqlerrm, p_height);

706: WHEN E_INVALID_DATA_ERR THEN
707: hr_data_pump.fail('get_height', sqlerrm, p_height);
708: RAISE;
709: WHEN OTHERS THEN
710: hr_data_pump.fail('get_height', sqlerrm, p_height);
711: RAISE;
712: END get_height;
713: -- -----------------------------------------------------------------------+
714: -- Name : get_weight --+

Line 738: hr_data_pump.fail('get_weight', sqlerrm, p_weight);

734: RAISE E_INVALID_DATA_ERR;
735: END IF;
736: EXCEPTION
737: WHEN E_INVALID_DATA_ERR THEN
738: hr_data_pump.fail('get_weight', sqlerrm, p_weight);
739: RAISE;
740: WHEN OTHERS THEN
741: hr_data_pump.fail('get_weight', sqlerrm, p_weight);
742: RAISE;

Line 741: hr_data_pump.fail('get_weight', sqlerrm, p_weight);

737: WHEN E_INVALID_DATA_ERR THEN
738: hr_data_pump.fail('get_weight', sqlerrm, p_weight);
739: RAISE;
740: WHEN OTHERS THEN
741: hr_data_pump.fail('get_weight', sqlerrm, p_weight);
742: RAISE;
743: END get_weight;
744:
745: -- -----------------------------------------------------------------------+

Line 764: hr_data_pump.fail('get_scl_contractor_id', sqlerrm,p_scl_contractor_name);

760: RETURN get_id( p_scl_contractor_name);
761:
762: EXCEPTION
763: WHEN OTHERS THEN
764: hr_data_pump.fail('get_scl_contractor_id', sqlerrm,p_scl_contractor_name);
765: RAISE;
766:
767: END get_scl_contractor_id;
768: