APPS.HR_EXU_UPD dependencies on HR_API

Line 81: When hr_api.check_integrity_violated Then

77: --
78: hr_utility.set_location(' Leaving:'||l_proc, 10);
79: --
80: Exception
81: When hr_api.check_integrity_violated Then
82: -- A check constraint has been violated
83: hr_exu_shd.g_api_dml := false; -- Unset the api dml status
84: hr_exu_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

81: When hr_api.check_integrity_violated Then
82: -- A check constraint has been violated
83: hr_exu_shd.g_api_dml := false; -- Unset the api dml status
84: hr_exu_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When hr_api.parent_integrity_violated Then
87: -- Parent integrity has been violated
88: hr_exu_shd.g_api_dml := false; -- Unset the api dml status
89: hr_exu_shd.constraint_error

Line 86: When hr_api.parent_integrity_violated Then

82: -- A check constraint has been violated
83: hr_exu_shd.g_api_dml := false; -- Unset the api dml status
84: hr_exu_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When hr_api.parent_integrity_violated Then
87: -- Parent integrity has been violated
88: hr_exu_shd.g_api_dml := false; -- Unset the api dml status
89: hr_exu_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

86: When hr_api.parent_integrity_violated Then
87: -- Parent integrity has been violated
88: hr_exu_shd.g_api_dml := false; -- Unset the api dml status
89: hr_exu_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.unique_integrity_violated Then
92: -- Unique integrity has been violated
93: hr_exu_shd.g_api_dml := false; -- Unset the api dml status
94: hr_exu_shd.constraint_error

Line 91: When hr_api.unique_integrity_violated Then

87: -- Parent integrity has been violated
88: hr_exu_shd.g_api_dml := false; -- Unset the api dml status
89: hr_exu_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.unique_integrity_violated Then
92: -- Unique integrity has been violated
93: hr_exu_shd.g_api_dml := false; -- Unset the api dml status
94: hr_exu_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

91: When hr_api.unique_integrity_violated Then
92: -- Unique integrity has been violated
93: hr_exu_shd.g_api_dml := false; -- Unset the api dml status
94: hr_exu_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When Others Then
97: hr_exu_shd.g_api_dml := false; -- Unset the api dml status
98: Raise;
99: End update_dml;

Line 242: If (p_rec.exception_reason = hr_api.g_varchar2) then

238: -- p_rec plsql record structure
239: -- to see if a system default is being used. If a system default
240: -- is being used then we must set to the 'current' argument value.
241: --
242: If (p_rec.exception_reason = hr_api.g_varchar2) then
243: p_rec.exception_reason :=
244: hr_exu_shd.g_old_rec.exception_reason;
245: End If;
246: If (p_rec.calendar_id = hr_api.g_number) then

Line 246: If (p_rec.calendar_id = hr_api.g_number) then

242: If (p_rec.exception_reason = hr_api.g_varchar2) then
243: p_rec.exception_reason :=
244: hr_exu_shd.g_old_rec.exception_reason;
245: End If;
246: If (p_rec.calendar_id = hr_api.g_number) then
247: p_rec.calendar_id :=
248: hr_exu_shd.g_old_rec.calendar_id;
249: End If;
250: If (p_rec.calendar_usage_id = hr_api.g_number) then

Line 250: If (p_rec.calendar_usage_id = hr_api.g_number) then

246: If (p_rec.calendar_id = hr_api.g_number) then
247: p_rec.calendar_id :=
248: hr_exu_shd.g_old_rec.calendar_id;
249: End If;
250: If (p_rec.calendar_usage_id = hr_api.g_number) then
251: p_rec.calendar_usage_id :=
252: hr_exu_shd.g_old_rec.calendar_usage_id;
253: End If;
254: If (p_rec.exception_id = hr_api.g_number) then

Line 254: If (p_rec.exception_id = hr_api.g_number) then

250: If (p_rec.calendar_usage_id = hr_api.g_number) then
251: p_rec.calendar_usage_id :=
252: hr_exu_shd.g_old_rec.calendar_usage_id;
253: End If;
254: If (p_rec.exception_id = hr_api.g_number) then
255: p_rec.exception_id :=
256: hr_exu_shd.g_old_rec.exception_id;
257: End If;
258: --

Line 318: Raise HR_Api.Validate_Enabled;

314: --
315: -- If we are validating then raise the Validate_Enabled exception
316: --
317: If p_validate then
318: Raise HR_Api.Validate_Enabled;
319: End If;
320: --
321: hr_utility.set_location(' Leaving:'||l_proc, 10);
322: Exception

Line 323: When HR_Api.Validate_Enabled Then

319: End If;
320: --
321: hr_utility.set_location(' Leaving:'||l_proc, 10);
322: Exception
323: When HR_Api.Validate_Enabled Then
324: --
325: -- As the Validate_Enabled exception has been raised
326: -- we must rollback to the savepoint
327: --

Line 337: p_exception_reason in varchar2 default hr_api.g_varchar2,

333: -- ----------------------------------------------------------------------------
334: Procedure upd
335: (
336: p_exception_usage_id in number,
337: p_exception_reason in varchar2 default hr_api.g_varchar2,
338: p_object_version_number in out nocopy number,
339: p_validate in boolean default false
340: ) is
341: --

Line 356: hr_api.g_number,

352: hr_exu_shd.convert_args
353: (
354: p_exception_usage_id,
355: p_exception_reason,
356: hr_api.g_number,
357: hr_api.g_number,
358: p_object_version_number,
359: hr_api.g_number
360: );

Line 357: hr_api.g_number,

353: (
354: p_exception_usage_id,
355: p_exception_reason,
356: hr_api.g_number,
357: hr_api.g_number,
358: p_object_version_number,
359: hr_api.g_number
360: );
361: --

Line 359: hr_api.g_number

355: p_exception_reason,
356: hr_api.g_number,
357: hr_api.g_number,
358: p_object_version_number,
359: hr_api.g_number
360: );
361: --
362: -- Having converted the arguments into the
363: -- plsql record structure we call the corresponding record