APPS.HR_CAL_UPD dependencies on HR_API

Line 80: When hr_api.check_integrity_violated Then

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

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

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

Line 85: When hr_api.parent_integrity_violated Then

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

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

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

Line 90: When hr_api.unique_integrity_violated Then

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

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

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

Line 241: If (p_rec.calendar_name = hr_api.g_varchar2) then

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

Line 245: If (p_rec.pattern_start_position = hr_api.g_number) then

241: If (p_rec.calendar_name = hr_api.g_varchar2) then
242: p_rec.calendar_name :=
243: hr_cal_shd.g_old_rec.calendar_name;
244: End If;
245: If (p_rec.pattern_start_position = hr_api.g_number) then
246: p_rec.pattern_start_position :=
247: hr_cal_shd.g_old_rec.pattern_start_position;
248: End If;
249: If (p_rec.calendar_start_time = hr_api.g_date) then

Line 249: If (p_rec.calendar_start_time = hr_api.g_date) then

245: If (p_rec.pattern_start_position = hr_api.g_number) then
246: p_rec.pattern_start_position :=
247: hr_cal_shd.g_old_rec.pattern_start_position;
248: End If;
249: If (p_rec.calendar_start_time = hr_api.g_date) then
250: p_rec.calendar_start_time :=
251: hr_cal_shd.g_old_rec.calendar_start_time;
252: End If;
253: If (p_rec.pattern_id = hr_api.g_number) then

Line 253: If (p_rec.pattern_id = hr_api.g_number) then

249: If (p_rec.calendar_start_time = hr_api.g_date) then
250: p_rec.calendar_start_time :=
251: hr_cal_shd.g_old_rec.calendar_start_time;
252: End If;
253: If (p_rec.pattern_id = hr_api.g_number) then
254: p_rec.pattern_id :=
255: hr_cal_shd.g_old_rec.pattern_id;
256: End If;
257:

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_calendar_name in varchar2 default hr_api.g_varchar2,

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

Line 356: hr_api.g_number,

352: hr_cal_shd.convert_args
353: (
354: p_calendar_id,
355: p_calendar_name,
356: hr_api.g_number,
357: hr_api.g_date,
358: hr_api.g_number,
359: p_object_version_number
360: );

Line 357: hr_api.g_date,

353: (
354: p_calendar_id,
355: p_calendar_name,
356: hr_api.g_number,
357: hr_api.g_date,
358: hr_api.g_number,
359: p_object_version_number
360: );
361: --

Line 358: hr_api.g_number,

354: p_calendar_id,
355: p_calendar_name,
356: hr_api.g_number,
357: hr_api.g_date,
358: hr_api.g_number,
359: p_object_version_number
360: );
361: --
362: -- Having converted the arguments into the