APPS.HR_PAT_UPD dependencies on HR_API

Line 83: When hr_api.check_integrity_violated Then

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_pat_shd.g_api_dml := false; -- Unset the api dml status
86: hr_pat_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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_pat_shd.g_api_dml := false; -- Unset the api dml status
86: hr_pat_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_pat_shd.g_api_dml := false; -- Unset the api dml status
91: hr_pat_shd.constraint_error

Line 88: When hr_api.parent_integrity_violated Then

84: -- A check constraint has been violated
85: hr_pat_shd.g_api_dml := false; -- Unset the api dml status
86: hr_pat_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_pat_shd.g_api_dml := false; -- Unset the api dml status
91: hr_pat_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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_pat_shd.g_api_dml := false; -- Unset the api dml status
91: hr_pat_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_pat_shd.g_api_dml := false; -- Unset the api dml status
96: hr_pat_shd.constraint_error

Line 93: When hr_api.unique_integrity_violated Then

89: -- Parent integrity has been violated
90: hr_pat_shd.g_api_dml := false; -- Unset the api dml status
91: hr_pat_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_pat_shd.g_api_dml := false; -- Unset the api dml status
96: hr_pat_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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_pat_shd.g_api_dml := false; -- Unset the api dml status
96: hr_pat_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When Others Then
99: hr_pat_shd.g_api_dml := false; -- Unset the api dml status
100: Raise;
101: End update_dml;

Line 244: If (p_rec.pattern_name = hr_api.g_varchar2) then

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_name = hr_api.g_varchar2) then
245: p_rec.pattern_name :=
246: hr_pat_shd.g_old_rec.pattern_name;
247: End If;
248: If (p_rec.pattern_start_weekday = hr_api.g_varchar2) then

Line 248: If (p_rec.pattern_start_weekday = hr_api.g_varchar2) then

244: If (p_rec.pattern_name = hr_api.g_varchar2) then
245: p_rec.pattern_name :=
246: hr_pat_shd.g_old_rec.pattern_name;
247: End If;
248: If (p_rec.pattern_start_weekday = hr_api.g_varchar2) then
249: p_rec.pattern_start_weekday :=
250: hr_pat_shd.g_old_rec.pattern_start_weekday;
251: End If;
252: If (p_rec.pattern_start_time = hr_api.g_varchar2) then

Line 252: If (p_rec.pattern_start_time = hr_api.g_varchar2) then

248: If (p_rec.pattern_start_weekday = hr_api.g_varchar2) then
249: p_rec.pattern_start_weekday :=
250: hr_pat_shd.g_old_rec.pattern_start_weekday;
251: End If;
252: If (p_rec.pattern_start_time = hr_api.g_varchar2) then
253: p_rec.pattern_start_time :=
254: hr_pat_shd.g_old_rec.pattern_start_time;
255: End If;
256:

Line 317: Raise HR_Api.Validate_Enabled;

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

Line 322: When HR_Api.Validate_Enabled Then

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

Line 336: p_pattern_name in varchar2 default hr_api.g_varchar2,

332: -- ----------------------------------------------------------------------------
333: Procedure upd
334: (
335: p_pattern_id in number,
336: p_pattern_name in varchar2 default hr_api.g_varchar2,
337: p_pattern_start_weekday in varchar2 default hr_api.g_varchar2,
338: p_pattern_start_time in varchar2 default hr_api.g_varchar2,
339: p_object_version_number in out nocopy number,
340: p_validate in boolean default false

Line 337: p_pattern_start_weekday in varchar2 default hr_api.g_varchar2,

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

Line 338: p_pattern_start_time in varchar2 default hr_api.g_varchar2,

334: (
335: p_pattern_id in number,
336: p_pattern_name in varchar2 default hr_api.g_varchar2,
337: p_pattern_start_weekday in varchar2 default hr_api.g_varchar2,
338: p_pattern_start_time in varchar2 default hr_api.g_varchar2,
339: p_object_version_number in out nocopy number,
340: p_validate in boolean default false
341: ) is
342: --