86: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status
87: --
88: hr_utility.set_location(' Leaving:'||l_proc, 10);
89: Exception
90: When hr_api.check_integrity_violated Then
91: -- A check constraint has been violated
92: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status
93: ghr_pdc_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.check_integrity_violated Then
91: -- A check constraint has been violated
92: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status
93: ghr_pdc_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status
98: ghr_pdc_shd.constraint_error
91: -- A check constraint has been violated
92: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status
93: ghr_pdc_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status
98: ghr_pdc_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status
98: ghr_pdc_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status
103: ghr_pdc_shd.constraint_error
96: -- Parent integrity has been violated
97: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status
98: ghr_pdc_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status
103: ghr_pdc_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status
103: ghr_pdc_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When Others Then
106: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status
107: Raise;
108: End insert_dml;
216: p_grade_level => p_rec.grade_level,
217: p_object_version_number => p_rec.object_version_number
218: );
219: exception
220: when hr_api.cannot_find_prog_unit then
221: hr_api.cannot_find_prog_unit_error
222: ( p_module_name => 'GHR_PD_CLASSIFICATIONS'
223: ,p_hook_type => 'AI'
224: );
217: p_object_version_number => p_rec.object_version_number
218: );
219: exception
220: when hr_api.cannot_find_prog_unit then
221: hr_api.cannot_find_prog_unit_error
222: ( p_module_name => 'GHR_PD_CLASSIFICATIONS'
223: ,p_hook_type => 'AI'
224: );
225: end;
282: -- Call conversion function to turn arguments into the
283: -- p_rec structure.
284: --
285: -- Class Grade by
286: hr_api.mandatory_arg_error
287: (p_api_name => l_proc,
288: p_argument => 'Class Grade By',
289: p_argument_value => p_class_grade_by
290: );
288: p_argument => 'Class Grade By',
289: p_argument_value => p_class_grade_by
290: );
291: -- Official Title
292: hr_api.mandatory_arg_error
293: (p_api_name => l_proc,
294: p_argument => 'Position Title',
295: p_argument_value => p_official_title
296: );
294: p_argument => 'Position Title',
295: p_argument_value => p_official_title
296: );
297: -- Pay plan
298: hr_api.mandatory_arg_error
299: (p_api_name => l_proc,
300: p_argument => 'Pay Plan',
301: p_argument_value => p_pay_plan
302: );
300: p_argument => 'Pay Plan',
301: p_argument_value => p_pay_plan
302: );
303: -- Occ Code
304: hr_api.mandatory_arg_error
305: (p_api_name => l_proc,
306: p_argument => 'Occupational Series',
307: p_argument_value => p_occupational_code
308: );
306: p_argument => 'Occupational Series',
307: p_argument_value => p_occupational_code
308: );
309: -- Grade or Level
310: hr_api.mandatory_arg_error
311: (p_api_name => l_proc,
312: p_argument => 'Grade',
313: p_argument_value => p_grade_level
314: );