DBA Data[Home] [Help]

APPS.PAY_PYR_INS dependencies on HR_API

Line 168: WHEN hr_api.check_integrity_violated THEN

164: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status
165: --
166: hr_utility.set_location(' Leaving:'||l_proc, 10);
167: EXCEPTION
168: WHEN hr_api.check_integrity_violated THEN
169: -- A check constraint has been violated
170: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status
171: pay_pyr_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

168: WHEN hr_api.check_integrity_violated THEN
169: -- A check constraint has been violated
170: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status
171: pay_pyr_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
173: WHEN hr_api.parent_integrity_violated THEN
174: -- Parent integrity has been violated
175: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status
176: pay_pyr_shd.constraint_error

Line 173: WHEN hr_api.parent_integrity_violated THEN

169: -- A check constraint has been violated
170: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status
171: pay_pyr_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
173: WHEN hr_api.parent_integrity_violated THEN
174: -- Parent integrity has been violated
175: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status
176: pay_pyr_shd.constraint_error
177: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

173: WHEN hr_api.parent_integrity_violated THEN
174: -- Parent integrity has been violated
175: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status
176: pay_pyr_shd.constraint_error
177: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
178: WHEN hr_api.unique_integrity_violated THEN
179: -- Unique integrity has been violated
180: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status
181: pay_pyr_shd.constraint_error

Line 178: WHEN hr_api.unique_integrity_violated THEN

174: -- Parent integrity has been violated
175: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status
176: pay_pyr_shd.constraint_error
177: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
178: WHEN hr_api.unique_integrity_violated THEN
179: -- Unique integrity has been violated
180: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status
181: pay_pyr_shd.constraint_error
182: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

178: WHEN hr_api.unique_integrity_violated THEN
179: -- Unique integrity has been violated
180: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status
181: pay_pyr_shd.constraint_error
182: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
183: WHEN Others THEN
184: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status
185: Raise;
186: END insert_dml;

Line 399: when hr_api.cannot_find_prog_unit THEN

395: );
396: --
397: exception
398: --
399: when hr_api.cannot_find_prog_unit THEN
400: --
401: hr_api.cannot_find_prog_unit_error
402: (p_module_name => 'PAY_RATES'
403: ,p_hook_type => 'AI');

Line 401: hr_api.cannot_find_prog_unit_error

397: exception
398: --
399: when hr_api.cannot_find_prog_unit THEN
400: --
401: hr_api.cannot_find_prog_unit_error
402: (p_module_name => 'PAY_RATES'
403: ,p_hook_type => 'AI');
404: --
405: END;