DBA Data[Home] [Help]

APPS.PSP_POA_INS dependencies on HR_API

Line 166: When hr_api.check_integrity_violated Then

162: psp_poa_shd.g_api_dml := false; -- Unset the api dml status
163: --
164: hr_utility.set_location(' Leaving:'||l_proc, 10);
165: Exception
166: When hr_api.check_integrity_violated Then
167: -- A check constraint has been violated
168: psp_poa_shd.g_api_dml := false; -- Unset the api dml status
169: psp_poa_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.check_integrity_violated Then
167: -- A check constraint has been violated
168: psp_poa_shd.g_api_dml := false; -- Unset the api dml status
169: psp_poa_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When hr_api.parent_integrity_violated Then
172: -- Parent integrity has been violated
173: psp_poa_shd.g_api_dml := false; -- Unset the api dml status
174: psp_poa_shd.constraint_error

Line 171: When hr_api.parent_integrity_violated Then

167: -- A check constraint has been violated
168: psp_poa_shd.g_api_dml := false; -- Unset the api dml status
169: psp_poa_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When hr_api.parent_integrity_violated Then
172: -- Parent integrity has been violated
173: psp_poa_shd.g_api_dml := false; -- Unset the api dml status
174: psp_poa_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.parent_integrity_violated Then
172: -- Parent integrity has been violated
173: psp_poa_shd.g_api_dml := false; -- Unset the api dml status
174: psp_poa_shd.constraint_error
175: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
176: When hr_api.unique_integrity_violated Then
177: -- Unique integrity has been violated
178: psp_poa_shd.g_api_dml := false; -- Unset the api dml status
179: psp_poa_shd.constraint_error

Line 176: When hr_api.unique_integrity_violated Then

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

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

176: When hr_api.unique_integrity_violated Then
177: -- Unique integrity has been violated
178: psp_poa_shd.g_api_dml := false; -- Unset the api dml status
179: psp_poa_shd.constraint_error
180: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
181: When Others Then
182: psp_poa_shd.g_api_dml := false; -- Unset the api dml status
183: Raise;
184: 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 => 'PSP_ORGANIZATION_ACCOUNTS'
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 => 'PSP_ORGANIZATION_ACCOUNTS'
397: ,p_hook_type => 'AI');
398: --
399: end;