APPS.PER_ORS_INS dependencies on HR_API

Line 162: When hr_api.check_integrity_violated Then

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

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

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

Line 167: When hr_api.parent_integrity_violated Then

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

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

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

Line 172: When hr_api.unique_integrity_violated Then

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

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

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

Line 387: when hr_api.cannot_find_prog_unit then

383: );
384: --
385: exception
386: --
387: when hr_api.cannot_find_prog_unit then
388: --
389: hr_api.cannot_find_prog_unit_error
390: (p_module_name => 'PER_ORGANIZATION_STRUCTURES'
391: ,p_hook_type => 'AI');

Line 389: hr_api.cannot_find_prog_unit_error

385: exception
386: --
387: when hr_api.cannot_find_prog_unit then
388: --
389: hr_api.cannot_find_prog_unit_error
390: (p_module_name => 'PER_ORGANIZATION_STRUCTURES'
391: ,p_hook_type => 'AI');
392: --
393: end;