DBA Data[Home] [Help]

APPS.PQH_STS_INS dependencies on HR_API

Line 187: When hr_api.check_integrity_violated Then

183: --
184: End if;
185:
186: Exception
187: When hr_api.check_integrity_violated Then
188: -- A check constraint has been violated
189: --
190: pqh_sts_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

187: When hr_api.check_integrity_violated Then
188: -- A check constraint has been violated
189: --
190: pqh_sts_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.parent_integrity_violated Then
193: -- Parent integrity has been violated
194: --
195: pqh_sts_shd.constraint_error

Line 192: When hr_api.parent_integrity_violated Then

188: -- A check constraint has been violated
189: --
190: pqh_sts_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.parent_integrity_violated Then
193: -- Parent integrity has been violated
194: --
195: pqh_sts_shd.constraint_error
196: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

192: When hr_api.parent_integrity_violated Then
193: -- Parent integrity has been violated
194: --
195: pqh_sts_shd.constraint_error
196: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
197: When hr_api.unique_integrity_violated Then
198: -- Unique integrity has been violated
199: --
200: pqh_sts_shd.constraint_error

Line 197: When hr_api.unique_integrity_violated Then

193: -- Parent integrity has been violated
194: --
195: pqh_sts_shd.constraint_error
196: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
197: When hr_api.unique_integrity_violated Then
198: -- Unique integrity has been violated
199: --
200: pqh_sts_shd.constraint_error
201: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

197: When hr_api.unique_integrity_violated Then
198: -- Unique integrity has been violated
199: --
200: pqh_sts_shd.constraint_error
201: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
202: When Others Then
203: --
204: Raise;
205: End insert_dml;

Line 426: when hr_api.cannot_find_prog_unit then

422: );
423: --
424: exception
425: --
426: when hr_api.cannot_find_prog_unit then
427: --
428: hr_api.cannot_find_prog_unit_error
429: (p_module_name => 'PQH_FR_STAT_SITUATIONS'
430: ,p_hook_type => 'AI');

Line 428: hr_api.cannot_find_prog_unit_error

424: exception
425: --
426: when hr_api.cannot_find_prog_unit then
427: --
428: hr_api.cannot_find_prog_unit_error
429: (p_module_name => 'PQH_FR_STAT_SITUATIONS'
430: ,p_hook_type => 'AI');
431: --
432: end;