[Home] [Help]
79: --
80: hr_utility.set_location(' Leaving:'||l_proc, 10);
81: --
82: Exception
83: When hr_api.check_integrity_violated Then
84: -- A check constraint has been violated
85: hr_pae_shd.g_api_dml := false; -- Unset the api dml status
86: hr_pae_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When hr_api.check_integrity_violated Then
84: -- A check constraint has been violated
85: hr_pae_shd.g_api_dml := false; -- Unset the api dml status
86: hr_pae_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
88: When hr_api.parent_integrity_violated Then
89: -- Parent integrity has been violated
90: hr_pae_shd.g_api_dml := false; -- Unset the api dml status
91: hr_pae_shd.constraint_error
84: -- A check constraint has been violated
85: hr_pae_shd.g_api_dml := false; -- Unset the api dml status
86: hr_pae_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
88: When hr_api.parent_integrity_violated Then
89: -- Parent integrity has been violated
90: hr_pae_shd.g_api_dml := false; -- Unset the api dml status
91: hr_pae_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
88: When hr_api.parent_integrity_violated Then
89: -- Parent integrity has been violated
90: hr_pae_shd.g_api_dml := false; -- Unset the api dml status
91: hr_pae_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.unique_integrity_violated Then
94: -- Unique integrity has been violated
95: hr_pae_shd.g_api_dml := false; -- Unset the api dml status
96: hr_pae_shd.constraint_error
89: -- Parent integrity has been violated
90: hr_pae_shd.g_api_dml := false; -- Unset the api dml status
91: hr_pae_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.unique_integrity_violated Then
94: -- Unique integrity has been violated
95: hr_pae_shd.g_api_dml := false; -- Unset the api dml status
96: hr_pae_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.unique_integrity_violated Then
94: -- Unique integrity has been violated
95: hr_pae_shd.g_api_dml := false; -- Unset the api dml status
96: hr_pae_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When Others Then
99: hr_pae_shd.g_api_dml := false; -- Unset the api dml status
100: Raise;
101: End update_dml;
240: -- p_rec plsql record structure
241: -- to see if a system default is being used. If a system default
242: -- is being used then we must set to the 'current' argument value.
243: --
244: If (p_rec.pattern_id = hr_api.g_number) then
245: p_rec.pattern_id :=
246: hr_pae_shd.g_old_rec.pattern_id;
247: End If;
248: If (p_rec.exception_name = hr_api.g_varchar2) then
244: If (p_rec.pattern_id = hr_api.g_number) then
245: p_rec.pattern_id :=
246: hr_pae_shd.g_old_rec.pattern_id;
247: End If;
248: If (p_rec.exception_name = hr_api.g_varchar2) then
249: p_rec.exception_name :=
250: hr_pae_shd.g_old_rec.exception_name;
251: End If;
252: If (p_rec.exception_start_time = hr_api.g_date) then
248: If (p_rec.exception_name = hr_api.g_varchar2) then
249: p_rec.exception_name :=
250: hr_pae_shd.g_old_rec.exception_name;
251: End If;
252: If (p_rec.exception_start_time = hr_api.g_date) then
253: p_rec.exception_start_time :=
254: hr_pae_shd.g_old_rec.exception_start_time;
255: End If;
256: If (p_rec.exception_end_time = hr_api.g_date) then
252: If (p_rec.exception_start_time = hr_api.g_date) then
253: p_rec.exception_start_time :=
254: hr_pae_shd.g_old_rec.exception_start_time;
255: End If;
256: If (p_rec.exception_end_time = hr_api.g_date) then
257: p_rec.exception_end_time :=
258: hr_pae_shd.g_old_rec.exception_end_time;
259: End If;
260: If (p_rec.exception_category = hr_api.g_varchar2) then
256: If (p_rec.exception_end_time = hr_api.g_date) then
257: p_rec.exception_end_time :=
258: hr_pae_shd.g_old_rec.exception_end_time;
259: End If;
260: If (p_rec.exception_category = hr_api.g_varchar2) then
261: p_rec.exception_category :=
262: hr_pae_shd.g_old_rec.exception_category;
263: End If;
264:
321: --
322: -- If we are validating then raise the Validate_Enabled exception
323: --
324: If p_validate then
325: Raise HR_Api.Validate_Enabled;
326: End If;
327: --
328: hr_utility.set_location(' Leaving:'||l_proc, 10);
329: Exception
326: End If;
327: --
328: hr_utility.set_location(' Leaving:'||l_proc, 10);
329: Exception
330: When HR_Api.Validate_Enabled Then
331: --
332: -- As the Validate_Enabled exception has been raised
333: -- we must rollback to the savepoint
334: --
340: -- ----------------------------------------------------------------------------
341: Procedure upd
342: (
343: p_exception_id in number,
344: p_exception_name in varchar2 default hr_api.g_varchar2,
345: p_exception_category in varchar2 default hr_api.g_varchar2,
346: p_object_version_number in out number,
347: p_validate in boolean default false
348: ) is
341: Procedure upd
342: (
343: p_exception_id in number,
344: p_exception_name in varchar2 default hr_api.g_varchar2,
345: p_exception_category in varchar2 default hr_api.g_varchar2,
346: p_object_version_number in out number,
347: p_validate in boolean default false
348: ) is
349: --
361: (
362: p_exception_id,
363: null,
364: p_exception_name,
365: hr_api.g_date,
366: hr_api.g_date,
367: p_exception_category,
368: p_object_version_number
369: );
362: p_exception_id,
363: null,
364: p_exception_name,
365: hr_api.g_date,
366: hr_api.g_date,
367: p_exception_category,
368: p_object_version_number
369: );
370: --