370: END;
371:
372:
373: EXCEPTION
374: When hr_api.check_integrity_violated Then
375: -- A check constraint has been violated
376: --
377: hxc_hav_shd.constraint_error
378: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
374: When hr_api.check_integrity_violated Then
375: -- A check constraint has been violated
376: --
377: hxc_hav_shd.constraint_error
378: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
379: When hr_api.parent_integrity_violated Then
380: -- Parent integrity has been violated
381: --
382: hxc_hav_shd.constraint_error
375: -- A check constraint has been violated
376: --
377: hxc_hav_shd.constraint_error
378: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
379: When hr_api.parent_integrity_violated Then
380: -- Parent integrity has been violated
381: --
382: hxc_hav_shd.constraint_error
383: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
379: When hr_api.parent_integrity_violated Then
380: -- Parent integrity has been violated
381: --
382: hxc_hav_shd.constraint_error
383: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
384: When hr_api.unique_integrity_violated Then
385: -- Unique integrity has been violated
386: --
387: hxc_hav_shd.constraint_error
380: -- Parent integrity has been violated
381: --
382: hxc_hav_shd.constraint_error
383: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
384: When hr_api.unique_integrity_violated Then
385: -- Unique integrity has been violated
386: --
387: hxc_hav_shd.constraint_error
388: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
384: When hr_api.unique_integrity_violated Then
385: -- Unique integrity has been violated
386: --
387: hxc_hav_shd.constraint_error
388: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
389:
390: END create_alias_value;
391:
392:
597: END;
598:
599:
600: EXCEPTION
601: When hr_api.check_integrity_violated Then
602: -- A check constraint has been violated
603: --
604: hxc_hav_shd.constraint_error
605: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
601: When hr_api.check_integrity_violated Then
602: -- A check constraint has been violated
603: --
604: hxc_hav_shd.constraint_error
605: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
606: When hr_api.parent_integrity_violated Then
607: -- Parent integrity has been violated
608: --
609: hxc_hav_shd.constraint_error
602: -- A check constraint has been violated
603: --
604: hxc_hav_shd.constraint_error
605: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
606: When hr_api.parent_integrity_violated Then
607: -- Parent integrity has been violated
608: --
609: hxc_hav_shd.constraint_error
610: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
606: When hr_api.parent_integrity_violated Then
607: -- Parent integrity has been violated
608: --
609: hxc_hav_shd.constraint_error
610: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
611: When hr_api.unique_integrity_violated Then
612: -- Unique integrity has been violated
613: --
614: hxc_hav_shd.constraint_error
607: -- Parent integrity has been violated
608: --
609: hxc_hav_shd.constraint_error
610: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
611: When hr_api.unique_integrity_violated Then
612: -- Unique integrity has been violated
613: --
614: hxc_hav_shd.constraint_error
615: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
611: When hr_api.unique_integrity_violated Then
612: -- Unique integrity has been violated
613: --
614: hxc_hav_shd.constraint_error
615: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
616:
617: END create_time_category_comp;
618:
619: