APPS.OTA_ACI_INS dependencies on HR_API

Line 161: When hr_api.check_integrity_violated Then

157: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
158: --
159: hr_utility.set_location(' Leaving:'||l_proc, 10);
160: Exception
161: When hr_api.check_integrity_violated Then
162: -- A check constraint has been violated
163: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
164: ota_aci_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

161: When hr_api.check_integrity_violated Then
162: -- A check constraint has been violated
163: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
164: ota_aci_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.parent_integrity_violated Then
167: -- Parent integrity has been violated
168: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
169: ota_aci_shd.constraint_error

Line 166: When hr_api.parent_integrity_violated Then

162: -- A check constraint has been violated
163: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
164: ota_aci_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.parent_integrity_violated Then
167: -- Parent integrity has been violated
168: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
169: ota_aci_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

166: When hr_api.parent_integrity_violated Then
167: -- Parent integrity has been violated
168: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
169: ota_aci_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When hr_api.unique_integrity_violated Then
172: -- Unique integrity has been violated
173: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
174: ota_aci_shd.constraint_error

Line 171: When hr_api.unique_integrity_violated Then

167: -- Parent integrity has been violated
168: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
169: ota_aci_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When hr_api.unique_integrity_violated Then
172: -- Unique integrity has been violated
173: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
174: ota_aci_shd.constraint_error
175: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

171: When hr_api.unique_integrity_violated Then
172: -- Unique integrity has been violated
173: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
174: ota_aci_shd.constraint_error
175: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
176: When Others Then
177: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
178: Raise;
179: End insert_dml;

Line 393: when hr_api.cannot_find_prog_unit then

389: );
390: --
391: exception
392: --
393: when hr_api.cannot_find_prog_unit then
394: --
395: hr_api.cannot_find_prog_unit_error
396: (p_module_name => 'OTA_ACT_CAT_INCLUSIONS'
397: ,p_hook_type => 'AI');

Line 395: hr_api.cannot_find_prog_unit_error

391: exception
392: --
393: when hr_api.cannot_find_prog_unit then
394: --
395: hr_api.cannot_find_prog_unit_error
396: (p_module_name => 'OTA_ACT_CAT_INCLUSIONS'
397: ,p_hook_type => 'AI');
398: --
399: end;