DBA Data[Home] [Help]

APPS.BEN_PLAN_COPY_LOADER dependencies on HR_API

Line 126: raise hr_API.validate_enabled;

122: --
123: -- When in validation only mode raise the Validate_Enabled exception
124: --
125: if p_validate = 1 then
126: raise hr_API.validate_enabled;
127: end if;
128: --
129: hr_utility.set_location(' Leaving:'||l_proc, 40);
130: --

Line 133: when hr_API.validate_enabled then

129: hr_utility.set_location(' Leaving:'||l_proc, 40);
130: --
131: exception
132: --
133: when hr_API.validate_enabled then
134: --
135: -- As the Validate_Enabled exception has been raised
136: -- we must rollback to the savepoint
137: --

Line 389: When hr_api.check_integrity_violated Then

385: end if;
386: --
387: hr_utility.set_location(' Leaving:'||l_proc, 10);
388: Exception
389: When hr_api.check_integrity_violated Then
390: -- A check constraint has been violated
391: pqh_cet_shd.constraint_error
392: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
393: When hr_api.parent_integrity_violated Then

Line 392: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

388: Exception
389: When hr_api.check_integrity_violated Then
390: -- A check constraint has been violated
391: pqh_cet_shd.constraint_error
392: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
393: When hr_api.parent_integrity_violated Then
394: -- Parent integrity has been violated
395: pqh_cet_shd.constraint_error
396: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 393: When hr_api.parent_integrity_violated Then

389: When hr_api.check_integrity_violated Then
390: -- A check constraint has been violated
391: pqh_cet_shd.constraint_error
392: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
393: When hr_api.parent_integrity_violated Then
394: -- Parent integrity has been violated
395: pqh_cet_shd.constraint_error
396: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
397: When hr_api.unique_integrity_violated Then

Line 396: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

392: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
393: When hr_api.parent_integrity_violated Then
394: -- Parent integrity has been violated
395: pqh_cet_shd.constraint_error
396: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
397: When hr_api.unique_integrity_violated Then
398: -- Unique integrity has been violated
399: pqh_cet_shd.constraint_error
400: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 397: When hr_api.unique_integrity_violated Then

393: When hr_api.parent_integrity_violated Then
394: -- Parent integrity has been violated
395: pqh_cet_shd.constraint_error
396: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
397: When hr_api.unique_integrity_violated Then
398: -- Unique integrity has been violated
399: pqh_cet_shd.constraint_error
400: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
401: When Others Then

Line 400: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

396: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
397: When hr_api.unique_integrity_violated Then
398: -- Unique integrity has been violated
399: pqh_cet_shd.constraint_error
400: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
401: When Others Then
402: Raise;
403: End ;
404: end ;

Line 663: When hr_api.check_integrity_violated Then

659: );
660: --
661: hr_utility.set_location(' Leaving:'||l_proc, 10);
662: Exception
663: When hr_api.check_integrity_violated Then
664: -- A check constraint has been violated
665: pqh_cea_shd.constraint_error
666: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
667: When hr_api.parent_integrity_violated Then

Line 666: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

662: Exception
663: When hr_api.check_integrity_violated Then
664: -- A check constraint has been violated
665: pqh_cea_shd.constraint_error
666: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
667: When hr_api.parent_integrity_violated Then
668: -- Parent integrity has been violated
669: pqh_cea_shd.constraint_error
670: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 667: When hr_api.parent_integrity_violated Then

663: When hr_api.check_integrity_violated Then
664: -- A check constraint has been violated
665: pqh_cea_shd.constraint_error
666: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
667: When hr_api.parent_integrity_violated Then
668: -- Parent integrity has been violated
669: pqh_cea_shd.constraint_error
670: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
671: When hr_api.unique_integrity_violated Then

Line 670: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

666: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
667: When hr_api.parent_integrity_violated Then
668: -- Parent integrity has been violated
669: pqh_cea_shd.constraint_error
670: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
671: When hr_api.unique_integrity_violated Then
672: -- Unique integrity has been violated
673: pqh_cea_shd.constraint_error
674: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 671: When hr_api.unique_integrity_violated Then

667: When hr_api.parent_integrity_violated Then
668: -- Parent integrity has been violated
669: pqh_cea_shd.constraint_error
670: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
671: When hr_api.unique_integrity_violated Then
672: -- Unique integrity has been violated
673: pqh_cea_shd.constraint_error
674: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
675: When Others Then

Line 674: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

670: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
671: When hr_api.unique_integrity_violated Then
672: -- Unique integrity has been violated
673: pqh_cea_shd.constraint_error
674: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
675: When Others Then
676: Raise;
677: End ;
678: end if ;

Line 1460: When hr_api.check_integrity_violated Then

1456: );
1457: --
1458: hr_utility.set_location(' Leaving:'||l_proc, 10);
1459: Exception
1460: When hr_api.check_integrity_violated Then
1461: -- A check constraint has been violated
1462: pqh_cer_shd.constraint_error
1463: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1464: When hr_api.parent_integrity_violated Then

Line 1463: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

1459: Exception
1460: When hr_api.check_integrity_violated Then
1461: -- A check constraint has been violated
1462: pqh_cer_shd.constraint_error
1463: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1464: When hr_api.parent_integrity_violated Then
1465: -- Parent integrity has been violated
1466: pqh_cer_shd.constraint_error
1467: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 1464: When hr_api.parent_integrity_violated Then

1460: When hr_api.check_integrity_violated Then
1461: -- A check constraint has been violated
1462: pqh_cer_shd.constraint_error
1463: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1464: When hr_api.parent_integrity_violated Then
1465: -- Parent integrity has been violated
1466: pqh_cer_shd.constraint_error
1467: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1468: When hr_api.unique_integrity_violated Then

Line 1467: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

1463: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1464: When hr_api.parent_integrity_violated Then
1465: -- Parent integrity has been violated
1466: pqh_cer_shd.constraint_error
1467: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1468: When hr_api.unique_integrity_violated Then
1469: -- Unique integrity has been violated
1470: pqh_cer_shd.constraint_error
1471: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 1468: When hr_api.unique_integrity_violated Then

1464: When hr_api.parent_integrity_violated Then
1465: -- Parent integrity has been violated
1466: pqh_cer_shd.constraint_error
1467: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1468: When hr_api.unique_integrity_violated Then
1469: -- Unique integrity has been violated
1470: pqh_cer_shd.constraint_error
1471: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1472: When Others Then

Line 1471: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

1467: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1468: When hr_api.unique_integrity_violated Then
1469: -- Unique integrity has been violated
1470: pqh_cer_shd.constraint_error
1471: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1472: When Others Then
1473: Raise;
1474: End ;
1475: -- end if ;

Line 2845: When hr_api.check_integrity_violated Then

2841:
2842: --
2843: hr_utility.set_location(' Leaving:'||l_proc, 10);
2844: Exception
2845: When hr_api.check_integrity_violated Then
2846: -- A check constraint has been violated
2847: pqh_cer_shd.constraint_error
2848: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
2849: When hr_api.parent_integrity_violated Then

Line 2848: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

2844: Exception
2845: When hr_api.check_integrity_violated Then
2846: -- A check constraint has been violated
2847: pqh_cer_shd.constraint_error
2848: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
2849: When hr_api.parent_integrity_violated Then
2850: -- Parent integrity has been violated
2851: pqh_cer_shd.constraint_error
2852: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 2849: When hr_api.parent_integrity_violated Then

2845: When hr_api.check_integrity_violated Then
2846: -- A check constraint has been violated
2847: pqh_cer_shd.constraint_error
2848: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
2849: When hr_api.parent_integrity_violated Then
2850: -- Parent integrity has been violated
2851: pqh_cer_shd.constraint_error
2852: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
2853: When hr_api.unique_integrity_violated Then

Line 2852: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

2848: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
2849: When hr_api.parent_integrity_violated Then
2850: -- Parent integrity has been violated
2851: pqh_cer_shd.constraint_error
2852: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
2853: When hr_api.unique_integrity_violated Then
2854: -- Unique integrity has been violated
2855: pqh_cer_shd.constraint_error
2856: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 2853: When hr_api.unique_integrity_violated Then

2849: When hr_api.parent_integrity_violated Then
2850: -- Parent integrity has been violated
2851: pqh_cer_shd.constraint_error
2852: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
2853: When hr_api.unique_integrity_violated Then
2854: -- Unique integrity has been violated
2855: pqh_cer_shd.constraint_error
2856: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
2857: When Others Then

Line 2856: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

2852: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
2853: When hr_api.unique_integrity_violated Then
2854: -- Unique integrity has been violated
2855: pqh_cer_shd.constraint_error
2856: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
2857: When Others Then
2858: Raise;
2859: End ;
2860: end if;