44: p_occupational_code => p_occupational_code,
45: p_grade_level => p_grade_level
46: );
47: exception
48: when hr_api.cannot_find_prog_unit then
49: hr_api.cannot_find_prog_unit_error
50: (p_module_name => 'create_pdc',
51: p_hook_type => 'BP'
52: );
45: p_grade_level => p_grade_level
46: );
47: exception
48: when hr_api.cannot_find_prog_unit then
49: hr_api.cannot_find_prog_unit_error
50: (p_module_name => 'create_pdc',
51: p_hook_type => 'BP'
52: );
53: end;
96: p_grade_level => p_grade_level,
97: p_pdc_object_version_number => l_pdc_object_version_number
98: );
99: exception
100: when hr_api.cannot_find_prog_unit then
101: hr_api.cannot_find_prog_unit_error
102: (p_module_name => 'create_pdc',
103: p_hook_type => 'AP'
104: );
97: p_pdc_object_version_number => l_pdc_object_version_number
98: );
99: exception
100: when hr_api.cannot_find_prog_unit then
101: hr_api.cannot_find_prog_unit_error
102: (p_module_name => 'create_pdc',
103: p_hook_type => 'AP'
104: );
105: end;
108: --
109: --
110: IF p_validate THEN
111:
112: RAISE hr_api.validate_enabled;
113:
114: END IF;
115:
116: --
124: hr_utility.set_location ('Leaving:'|| l_proc,11);
125:
126: EXCEPTION
127:
128: WHEN hr_api.validate_enabled THEN
129:
130: -- As the validation exception has been raised
131: -- We must rollback to the Savepoint set.
132:
192: p_grade_level => p_grade_level,
193: p_pdc_object_version_number => p_pdc_object_version_number
194: );
195: exception
196: when hr_api.cannot_find_prog_unit then
197: p_pdc_object_version_number := l_pdc_object_version_number; -- Nocopy changes
198: hr_api.cannot_find_prog_unit_error
199: (p_module_name => 'update_pdc',
200: p_hook_type => 'BP'
194: );
195: exception
196: when hr_api.cannot_find_prog_unit then
197: p_pdc_object_version_number := l_pdc_object_version_number; -- Nocopy changes
198: hr_api.cannot_find_prog_unit_error
199: (p_module_name => 'update_pdc',
200: p_hook_type => 'BP'
201: );
202: end;
250: p_grade_level => p_grade_level,
251: p_pdc_object_version_number => l_object_version_number
252: );
253: exception
254: when hr_api.cannot_find_prog_unit then
255: p_pdc_object_version_number := l_pdc_object_version_number; -- Nocopy changes
256: hr_api.cannot_find_prog_unit_error
257: (p_module_name => 'update_pdc',
258: p_hook_type => 'AP'
252: );
253: exception
254: when hr_api.cannot_find_prog_unit then
255: p_pdc_object_version_number := l_pdc_object_version_number; -- Nocopy changes
256: hr_api.cannot_find_prog_unit_error
257: (p_module_name => 'update_pdc',
258: p_hook_type => 'AP'
259: );
260: end;
262: -- End of After Process User Hook call
263: --
264: IF p_validate THEN
265:
266: RAISE hr_api.validate_enabled;
267:
268: END IF;
269:
270: --
277: hr_utility.set_location('Leaving:'|| l_proc,11);
278:
279: EXCEPTION
280:
281: WHEN hr_api.validate_enabled THEN
282:
283: --
284: -- As the Validate_Enabled exception has been raised
285: -- We must rollback to the savepoint
320: p_pd_classification_id => p_pd_classification_id,
321: p_pdc_object_version_number => l_object_version_number
322: );
323: exception
324: when hr_api.cannot_find_prog_unit then
325: hr_api.cannot_find_prog_unit_error
326: (p_module_name => 'delete_pdc',
327: p_hook_type => 'BP'
328: );
321: p_pdc_object_version_number => l_object_version_number
322: );
323: exception
324: when hr_api.cannot_find_prog_unit then
325: hr_api.cannot_find_prog_unit_error
326: (p_module_name => 'delete_pdc',
327: p_hook_type => 'BP'
328: );
329: end;
364: p_pd_classification_id => p_pd_classification_id,
365: p_pdc_object_version_number => l_object_version_number
366: );
367: exception
368: when hr_api.cannot_find_prog_unit then
369: hr_api.cannot_find_prog_unit_error
370: (p_module_name => 'delete_pdc',
371: p_hook_type => 'AP'
372: );
365: p_pdc_object_version_number => l_object_version_number
366: );
367: exception
368: when hr_api.cannot_find_prog_unit then
369: hr_api.cannot_find_prog_unit_error
370: (p_module_name => 'delete_pdc',
371: p_hook_type => 'AP'
372: );
373: end;
375: -- End of After Process User Hook call
376: --
377: IF p_validate THEN
378:
379: RAISE hr_api.validate_enabled;
380:
381: END IF;
382:
383:
385: hr_utility.set_location('Leaving:'|| l_proc,11);
386:
387: EXCEPTION
388:
389: WHEN hr_api.validate_enabled THEN
390: --
391: -- As the Validate_Enabled exception has been raised
392: -- We must rollback to the savepoint
393: --