DBA Data[Home] [Help]

APPS.GHR_PDC_INS dependencies on HR_API

Line 90: When hr_api.check_integrity_violated Then

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));

Line 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

Line 95: When hr_api.parent_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
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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

Line 100: When hr_api.unique_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
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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;

Line 220: when hr_api.cannot_find_prog_unit then

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: );

Line 221: hr_api.cannot_find_prog_unit_error

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;

Line 286: hr_api.mandatory_arg_error

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: );

Line 292: hr_api.mandatory_arg_error

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: );

Line 298: hr_api.mandatory_arg_error

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: );

Line 304: hr_api.mandatory_arg_error

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: );

Line 310: hr_api.mandatory_arg_error

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: );