APPS.HR_CAU_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_cau_shd.g_api_dml := false; -- Unset the api dml status
84: hr_cau_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_cau_shd.g_api_dml := false; -- Unset the api dml status
84: hr_cau_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_cau_shd.g_api_dml := false; -- Unset the api dml status
89: hr_cau_shd.constraint_error

Line 86: When hr_api.parent_integrity_violated Then

82: -- A check constraint has been violated
83: hr_cau_shd.g_api_dml := false; -- Unset the api dml status
84: hr_cau_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_cau_shd.g_api_dml := false; -- Unset the api dml status
89: hr_cau_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_cau_shd.g_api_dml := false; -- Unset the api dml status
89: hr_cau_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_cau_shd.g_api_dml := false; -- Unset the api dml status
94: hr_cau_shd.constraint_error

Line 91: When hr_api.unique_integrity_violated Then

87: -- Parent integrity has been violated
88: hr_cau_shd.g_api_dml := false; -- Unset the api dml status
89: hr_cau_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_cau_shd.g_api_dml := false; -- Unset the api dml status
94: hr_cau_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_cau_shd.g_api_dml := false; -- Unset the api dml status
94: hr_cau_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When Others Then
97: hr_cau_shd.g_api_dml := false; -- Unset the api dml status
98: Raise;
99: End update_dml;

Line 242: If (p_rec.calendar_id = hr_api.g_number) 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.calendar_id = hr_api.g_number) then
243: p_rec.calendar_id :=
244: hr_cau_shd.g_old_rec.calendar_id;
245: End If;
246: If (p_rec.primary_key_value = hr_api.g_number) then

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

242: If (p_rec.calendar_id = hr_api.g_number) then
243: p_rec.calendar_id :=
244: hr_cau_shd.g_old_rec.calendar_id;
245: End If;
246: If (p_rec.primary_key_value = hr_api.g_number) then
247: p_rec.primary_key_value :=
248: hr_cau_shd.g_old_rec.primary_key_value;
249: End If;
250: If (p_rec.purpose_usage_id = hr_api.g_number) then

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

246: If (p_rec.primary_key_value = hr_api.g_number) then
247: p_rec.primary_key_value :=
248: hr_cau_shd.g_old_rec.primary_key_value;
249: End If;
250: If (p_rec.purpose_usage_id = hr_api.g_number) then
251: p_rec.purpose_usage_id :=
252: hr_cau_shd.g_old_rec.purpose_usage_id;
253: End If;
254: If (p_rec.start_date = hr_api.g_date) then

Line 254: If (p_rec.start_date = hr_api.g_date) then

250: If (p_rec.purpose_usage_id = hr_api.g_number) then
251: p_rec.purpose_usage_id :=
252: hr_cau_shd.g_old_rec.purpose_usage_id;
253: End If;
254: If (p_rec.start_date = hr_api.g_date) then
255: p_rec.start_date :=
256: hr_cau_shd.g_old_rec.start_date;
257: End If;
258: If (p_rec.end_date = hr_api.g_date) then

Line 258: If (p_rec.end_date = hr_api.g_date) then

254: If (p_rec.start_date = hr_api.g_date) then
255: p_rec.start_date :=
256: hr_cau_shd.g_old_rec.start_date;
257: End If;
258: If (p_rec.end_date = hr_api.g_date) then
259: p_rec.end_date :=
260: hr_cau_shd.g_old_rec.end_date;
261: End If;
262:

Line 323: Raise HR_Api.Validate_Enabled;

319: --
320: -- If we are validating then raise the Validate_Enabled exception
321: --
322: If p_validate then
323: Raise HR_Api.Validate_Enabled;
324: End If;
325: --
326: hr_utility.set_location(' Leaving:'||l_proc, 10);
327: Exception

Line 328: When HR_Api.Validate_Enabled Then

324: End If;
325: --
326: hr_utility.set_location(' Leaving:'||l_proc, 10);
327: Exception
328: When HR_Api.Validate_Enabled Then
329: --
330: -- As the Validate_Enabled exception has been raised
331: -- we must rollback to the savepoint
332: --

Line 342: p_start_date in date default hr_api.g_date,

338: -- ----------------------------------------------------------------------------
339: Procedure upd
340: (
341: p_calendar_usage_id in number,
342: p_start_date in date default hr_api.g_date,
343: p_end_date in date default hr_api.g_date,
344: p_object_version_number in out nocopy number,
345: p_validate in boolean default false
346: ) is

Line 343: p_end_date in date default hr_api.g_date,

339: Procedure upd
340: (
341: p_calendar_usage_id in number,
342: p_start_date in date default hr_api.g_date,
343: p_end_date in date default hr_api.g_date,
344: p_object_version_number in out nocopy number,
345: p_validate in boolean default false
346: ) is
347: --

Line 360: hr_api.g_number,

356: --
357: l_rec :=
358: hr_cau_shd.convert_args
359: (
360: hr_api.g_number,
361: p_calendar_usage_id,
362: hr_api.g_number,
363: hr_api.g_number,
364: p_start_date,

Line 362: hr_api.g_number,

358: hr_cau_shd.convert_args
359: (
360: hr_api.g_number,
361: p_calendar_usage_id,
362: hr_api.g_number,
363: hr_api.g_number,
364: p_start_date,
365: p_end_date,
366: p_object_version_number

Line 363: hr_api.g_number,

359: (
360: hr_api.g_number,
361: p_calendar_usage_id,
362: hr_api.g_number,
363: hr_api.g_number,
364: p_start_date,
365: p_end_date,
366: p_object_version_number
367: );