APPS.PER_GRA_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: per_gra_shd.g_api_dml := false; -- Unset the api dml status
86: per_gra_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: per_gra_shd.g_api_dml := false; -- Unset the api dml status
86: per_gra_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: per_gra_shd.g_api_dml := false; -- Unset the api dml status
91: per_gra_shd.constraint_error

Line 88: When hr_api.parent_integrity_violated Then

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

Line 93: When hr_api.unique_integrity_violated Then

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

Line 207: when hr_api.cannot_find_prog_unit then

203: );
204: --
205: exception
206: --
207: when hr_api.cannot_find_prog_unit then
208: --
209: hr_api.cannot_find_prog_unit_error
210: (p_module_name => 'per_cagr_grades'
211: ,p_hook_type => 'AU');

Line 209: hr_api.cannot_find_prog_unit_error

205: exception
206: --
207: when hr_api.cannot_find_prog_unit then
208: --
209: hr_api.cannot_find_prog_unit_error
210: (p_module_name => 'per_cagr_grades'
211: ,p_hook_type => 'AU');
212: --
213: end;

Line 277: If (p_rec.cagr_grade_structure_id = hr_api.g_number) then

273: -- p_rec plsql record structure
274: -- to see if a system default is being used. If a system default
275: -- is being used then we must set to the 'current' argument value.
276: --
277: If (p_rec.cagr_grade_structure_id = hr_api.g_number) then
278: p_rec.cagr_grade_structure_id :=
279: per_gra_shd.g_old_rec.cagr_grade_structure_id;
280: End If;
281: If (p_rec.cagr_grade_def_id = hr_api.g_number) then

Line 281: If (p_rec.cagr_grade_def_id = hr_api.g_number) then

277: If (p_rec.cagr_grade_structure_id = hr_api.g_number) then
278: p_rec.cagr_grade_structure_id :=
279: per_gra_shd.g_old_rec.cagr_grade_structure_id;
280: End If;
281: If (p_rec.cagr_grade_def_id = hr_api.g_number) then
282: p_rec.cagr_grade_def_id :=
283: per_gra_shd.g_old_rec.cagr_grade_def_id;
284: End If;
285: If (p_rec.sequence = hr_api.g_number) then

Line 285: If (p_rec.sequence = hr_api.g_number) then

281: If (p_rec.cagr_grade_def_id = hr_api.g_number) then
282: p_rec.cagr_grade_def_id :=
283: per_gra_shd.g_old_rec.cagr_grade_def_id;
284: End If;
285: If (p_rec.sequence = hr_api.g_number) then
286: p_rec.sequence :=
287: per_gra_shd.g_old_rec.sequence;
288: End If;
289:

Line 352: p_cagr_grade_structure_id in number default hr_api.g_number,

348: -- ----------------------------------------------------------------------------
349: Procedure upd
350: (
351: p_cagr_grade_id in number,
352: p_cagr_grade_structure_id in number default hr_api.g_number,
353: p_cagr_grade_def_id in number default hr_api.g_number,
354: p_sequence in number default hr_api.g_number,
355: p_object_version_number in out nocopy number,
356: p_effective_date in date

Line 353: p_cagr_grade_def_id in number default hr_api.g_number,

349: Procedure upd
350: (
351: p_cagr_grade_id in number,
352: p_cagr_grade_structure_id in number default hr_api.g_number,
353: p_cagr_grade_def_id in number default hr_api.g_number,
354: p_sequence in number default hr_api.g_number,
355: p_object_version_number in out nocopy number,
356: p_effective_date in date
357: ) is

Line 354: p_sequence in number default hr_api.g_number,

350: (
351: p_cagr_grade_id in number,
352: p_cagr_grade_structure_id in number default hr_api.g_number,
353: p_cagr_grade_def_id in number default hr_api.g_number,
354: p_sequence in number default hr_api.g_number,
355: p_object_version_number in out nocopy number,
356: p_effective_date in date
357: ) is
358: --