APPS.HR_PPU_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_ppu_shd.g_api_dml := false; -- Unset the api dml status
86: hr_ppu_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_ppu_shd.g_api_dml := false; -- Unset the api dml status
86: hr_ppu_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_ppu_shd.g_api_dml := false; -- Unset the api dml status
91: hr_ppu_shd.constraint_error

Line 88: When hr_api.parent_integrity_violated Then

84: -- A check constraint has been violated
85: hr_ppu_shd.g_api_dml := false; -- Unset the api dml status
86: hr_ppu_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_ppu_shd.g_api_dml := false; -- Unset the api dml status
91: hr_ppu_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_ppu_shd.g_api_dml := false; -- Unset the api dml status
91: hr_ppu_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_ppu_shd.g_api_dml := false; -- Unset the api dml status
96: hr_ppu_shd.constraint_error

Line 93: When hr_api.unique_integrity_violated Then

89: -- Parent integrity has been violated
90: hr_ppu_shd.g_api_dml := false; -- Unset the api dml status
91: hr_ppu_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_ppu_shd.g_api_dml := false; -- Unset the api dml status
96: hr_ppu_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_ppu_shd.g_api_dml := false; -- Unset the api dml status
96: hr_ppu_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When Others Then
99: hr_ppu_shd.g_api_dml := false; -- Unset the api dml status
100: Raise;
101: End update_dml;

Line 247: If (p_rec.entity_name = hr_api.g_varchar2) then

243: -- p_rec plsql record structure
244: -- to see if a system default is being used. If a system default
245: -- is being used then we must set to the 'current' argument value.
246: --
247: If (p_rec.entity_name = hr_api.g_varchar2) then
248: p_rec.entity_name :=
249: hr_ppu_shd.g_old_rec.entity_name;
250: End If;
251: If (p_rec.pattern_purpose = hr_api.g_varchar2) then

Line 251: If (p_rec.pattern_purpose = hr_api.g_varchar2) then

247: If (p_rec.entity_name = hr_api.g_varchar2) then
248: p_rec.entity_name :=
249: hr_ppu_shd.g_old_rec.entity_name;
250: End If;
251: If (p_rec.pattern_purpose = hr_api.g_varchar2) then
252: p_rec.pattern_purpose :=
253: hr_ppu_shd.g_old_rec.pattern_purpose;
254: End If;
255: If (p_rec.hierarchy_level = hr_api.g_number) then

Line 255: If (p_rec.hierarchy_level = hr_api.g_number) then

251: If (p_rec.pattern_purpose = hr_api.g_varchar2) then
252: p_rec.pattern_purpose :=
253: hr_ppu_shd.g_old_rec.pattern_purpose;
254: End If;
255: If (p_rec.hierarchy_level = hr_api.g_number) then
256: p_rec.hierarchy_level :=
257: hr_ppu_shd.g_old_rec.hierarchy_level;
258: End If;
259:

Line 320: Raise HR_Api.Validate_Enabled;

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

Line 325: When HR_Api.Validate_Enabled Then

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

Line 339: p_entity_name in varchar2 default hr_api.g_varchar2,

335: -- ----------------------------------------------------------------------------
336: Procedure upd
337: (
338: p_purpose_usage_id in number,
339: p_entity_name in varchar2 default hr_api.g_varchar2,
340: p_pattern_purpose in varchar2 default hr_api.g_varchar2,
341: p_hierarchy_level in number default hr_api.g_number,
342: p_object_version_number in out number,
343: p_validate in boolean default false

Line 340: p_pattern_purpose in varchar2 default hr_api.g_varchar2,

336: Procedure upd
337: (
338: p_purpose_usage_id in number,
339: p_entity_name in varchar2 default hr_api.g_varchar2,
340: p_pattern_purpose in varchar2 default hr_api.g_varchar2,
341: p_hierarchy_level in number default hr_api.g_number,
342: p_object_version_number in out number,
343: p_validate in boolean default false
344: ) is

Line 341: p_hierarchy_level in number default hr_api.g_number,

337: (
338: p_purpose_usage_id in number,
339: p_entity_name in varchar2 default hr_api.g_varchar2,
340: p_pattern_purpose in varchar2 default hr_api.g_varchar2,
341: p_hierarchy_level in number default hr_api.g_number,
342: p_object_version_number in out number,
343: p_validate in boolean default false
344: ) is
345: --