APPS.OTA_TRB_INS dependencies on HR_API

Line 192: When hr_api.check_integrity_violated Then

188: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
189: --
190: hr_utility.set_location(' Leaving:'||l_proc, 10);
191: Exception
192: When hr_api.check_integrity_violated Then
193: -- A check constraint has been violated
194: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
195: ota_trb_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.check_integrity_violated Then
193: -- A check constraint has been violated
194: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
195: ota_trb_shd.constraint_error
196: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
197: When hr_api.parent_integrity_violated Then
198: -- Parent integrity has been violated
199: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
200: ota_trb_shd.constraint_error

Line 197: When hr_api.parent_integrity_violated Then

193: -- A check constraint has been violated
194: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
195: ota_trb_shd.constraint_error
196: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
197: When hr_api.parent_integrity_violated Then
198: -- Parent integrity has been violated
199: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
200: ota_trb_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.parent_integrity_violated Then
198: -- Parent integrity has been violated
199: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
200: ota_trb_shd.constraint_error
201: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
202: When hr_api.unique_integrity_violated Then
203: -- Unique integrity has been violated
204: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
205: ota_trb_shd.constraint_error

Line 202: When hr_api.unique_integrity_violated Then

198: -- Parent integrity has been violated
199: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
200: ota_trb_shd.constraint_error
201: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
202: When hr_api.unique_integrity_violated Then
203: -- Unique integrity has been violated
204: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
205: ota_trb_shd.constraint_error
206: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

202: When hr_api.unique_integrity_violated Then
203: -- Unique integrity has been violated
204: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
205: ota_trb_shd.constraint_error
206: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
207: When Others Then
208: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
209: Raise;
210: End insert_dml;

Line 506: when hr_api.cannot_find_prog_unit then

502: );
503: --
504: exception
505: --
506: when hr_api.cannot_find_prog_unit then
507: --
508: hr_api.cannot_find_prog_unit_error
509: (p_module_name => 'OTA_RESOURCE_BOOKINGS'
510: ,p_hook_type => 'AI');

Line 508: hr_api.cannot_find_prog_unit_error

504: exception
505: --
506: when hr_api.cannot_find_prog_unit then
507: --
508: hr_api.cannot_find_prog_unit_error
509: (p_module_name => 'OTA_RESOURCE_BOOKINGS'
510: ,p_hook_type => 'AI');
511: --
512: end;