51: p_occupational_code => p_occupational_code,
52: p_grade_level => p_grade_level
53: );
54: exception
55: when hr_api.cannot_find_prog_unit then
56: hr_api.cannot_find_prog_unit_error
57: (p_module_name => 'create_pdc',
58: p_hook_type => 'BP'
59: );
52: p_grade_level => p_grade_level
53: );
54: exception
55: when hr_api.cannot_find_prog_unit then
56: hr_api.cannot_find_prog_unit_error
57: (p_module_name => 'create_pdc',
58: p_hook_type => 'BP'
59: );
60: end;
103: p_grade_level => p_grade_level,
104: p_pdc_object_version_number => l_pdc_object_version_number
105: );
106: exception
107: when hr_api.cannot_find_prog_unit then
108: hr_api.cannot_find_prog_unit_error
109: (p_module_name => 'create_pdc',
110: p_hook_type => 'AP'
111: );
104: p_pdc_object_version_number => l_pdc_object_version_number
105: );
106: exception
107: when hr_api.cannot_find_prog_unit then
108: hr_api.cannot_find_prog_unit_error
109: (p_module_name => 'create_pdc',
110: p_hook_type => 'AP'
111: );
112: end;
115: --
116: --
117: IF p_validate THEN
118:
119: RAISE hr_api.validate_enabled;
120:
121: END IF;
122:
123: --
131: hr_utility.set_location ('Leaving:'|| l_proc,11);
132:
133: EXCEPTION
134:
135: WHEN hr_api.validate_enabled THEN
136:
137: -- As the validation exception has been raised
138: -- We must rollback to the Savepoint set.
139:
198: p_grade_level => p_grade_level,
199: p_pdc_object_version_number => p_pdc_object_version_number
200: );
201: exception
202: when hr_api.cannot_find_prog_unit then
203: hr_api.cannot_find_prog_unit_error
204: (p_module_name => 'update_pdc',
205: p_hook_type => 'BP'
206: );
199: p_pdc_object_version_number => p_pdc_object_version_number
200: );
201: exception
202: when hr_api.cannot_find_prog_unit then
203: hr_api.cannot_find_prog_unit_error
204: (p_module_name => 'update_pdc',
205: p_hook_type => 'BP'
206: );
207: end;
255: p_grade_level => p_grade_level,
256: p_pdc_object_version_number => l_object_version_number
257: );
258: exception
259: when hr_api.cannot_find_prog_unit then
260: hr_api.cannot_find_prog_unit_error
261: (p_module_name => 'update_pdc',
262: p_hook_type => 'AP'
263: );
256: p_pdc_object_version_number => l_object_version_number
257: );
258: exception
259: when hr_api.cannot_find_prog_unit then
260: hr_api.cannot_find_prog_unit_error
261: (p_module_name => 'update_pdc',
262: p_hook_type => 'AP'
263: );
264: end;
266: -- End of After Process User Hook call
267: --
268: IF p_validate THEN
269:
270: RAISE hr_api.validate_enabled;
271:
272: END IF;
273:
274: --
281: hr_utility.set_location('Leaving:'|| l_proc,11);
282:
283: EXCEPTION
284:
285: WHEN hr_api.validate_enabled THEN
286:
287: --
288: -- As the Validate_Enabled exception has been raised
289: -- We must rollback to the savepoint
322: p_pd_classification_id => p_pd_classification_id,
323: p_pdc_object_version_number => l_object_version_number
324: );
325: exception
326: when hr_api.cannot_find_prog_unit then
327: hr_api.cannot_find_prog_unit_error
328: (p_module_name => 'delete_pdc',
329: p_hook_type => 'BP'
330: );
323: p_pdc_object_version_number => l_object_version_number
324: );
325: exception
326: when hr_api.cannot_find_prog_unit then
327: hr_api.cannot_find_prog_unit_error
328: (p_module_name => 'delete_pdc',
329: p_hook_type => 'BP'
330: );
331: end;
366: p_pd_classification_id => p_pd_classification_id,
367: p_pdc_object_version_number => l_object_version_number
368: );
369: exception
370: when hr_api.cannot_find_prog_unit then
371: hr_api.cannot_find_prog_unit_error
372: (p_module_name => 'delete_pdc',
373: p_hook_type => 'AP'
374: );
367: p_pdc_object_version_number => l_object_version_number
368: );
369: exception
370: when hr_api.cannot_find_prog_unit then
371: hr_api.cannot_find_prog_unit_error
372: (p_module_name => 'delete_pdc',
373: p_hook_type => 'AP'
374: );
375: end;
377: -- End of After Process User Hook call
378: --
379: IF p_validate THEN
380:
381: RAISE hr_api.validate_enabled;
382:
383: END IF;
384:
385:
387: hr_utility.set_location('Leaving:'|| l_proc,11);
388:
389: EXCEPTION
390:
391: WHEN hr_api.validate_enabled THEN
392:
393: --
394: -- As the Validate_Enabled exception has been raised
395: -- We must rollback to the savepoint