50: ,p_prerequisite_type => p_prerequisite_type
51: ,p_enforcement_mode => p_enforcement_mode
52: );
53: exception
54: when hr_api.cannot_find_prog_unit then
55: hr_api.cannot_find_prog_unit_error
56: (p_module_name => 'create_course_prerequisite_b'
57: ,p_hook_type => 'BP'
58: );
51: ,p_enforcement_mode => p_enforcement_mode
52: );
53: exception
54: when hr_api.cannot_find_prog_unit then
55: hr_api.cannot_find_prog_unit_error
56: (p_module_name => 'create_course_prerequisite_b'
57: ,p_hook_type => 'BP'
58: );
59: end;
86: ,p_object_version_number => l_object_version_number
87: );
88:
89: exception
90: when hr_api.cannot_find_prog_unit then
91: hr_api.cannot_find_prog_unit_error
92: (p_module_name => 'create_course_prerequisite_a'
93: ,p_hook_type => 'AP'
94: );
87: );
88:
89: exception
90: when hr_api.cannot_find_prog_unit then
91: hr_api.cannot_find_prog_unit_error
92: (p_module_name => 'create_course_prerequisite_a'
93: ,p_hook_type => 'AP'
94: );
95: end;
96: --
97: -- When in validation only mode raise the Validate_Enabled exception
98: --
99: if p_validate then
100: raise hr_api.validate_enabled;
101: end if;
102: --
103: -- Set all output arguments
104: --
106: p_object_version_number := l_object_version_number;
107: --
108: hr_utility.set_location(' Leaving:'||l_proc, 70);
109: exception
110: when hr_api.validate_enabled then
111: --
112: -- As the Validate_Enabled exception has been raised
113: -- we must rollback to the savepoint
114: --
177: ,p_object_version_number => l_object_version_number
178: );
179:
180: exception
181: when hr_api.cannot_find_prog_unit then
182: hr_api.cannot_find_prog_unit_error
183: (p_module_name => 'update_course_prerequisite_b'
184: ,p_hook_type => 'BP'
185: );
178: );
179:
180: exception
181: when hr_api.cannot_find_prog_unit then
182: hr_api.cannot_find_prog_unit_error
183: (p_module_name => 'update_course_prerequisite_b'
184: ,p_hook_type => 'BP'
185: );
186: end;
212: ,p_enforcement_mode => p_enforcement_mode
213: ,p_object_version_number => l_object_version_number
214: );
215: exception
216: when hr_api.cannot_find_prog_unit then
217: hr_api.cannot_find_prog_unit_error
218: (p_module_name => 'update_course_prerequisite_a'
219: ,p_hook_type => 'AP'
220: );
213: ,p_object_version_number => l_object_version_number
214: );
215: exception
216: when hr_api.cannot_find_prog_unit then
217: hr_api.cannot_find_prog_unit_error
218: (p_module_name => 'update_course_prerequisite_a'
219: ,p_hook_type => 'AP'
220: );
221: end;
222: --
223: -- When in validation only mode raise the Validate_Enabled exception
224: --
225: if p_validate then
226: raise hr_api.validate_enabled;
227: end if;
228: --
229: -- Set all output arguments
230: --
231: p_object_version_number := l_object_version_number;
232: --
233: hr_utility.set_location(' Leaving:'||l_proc, 70);
234: exception
235: when hr_api.validate_enabled then
236: --
237: -- As the Validate_Enabled exception has been raised
238: -- we must rollback to the savepoint
239: --
285: ,p_prerequisite_course_id => p_prerequisite_course_id
286: ,p_object_version_number => p_object_version_number);
287:
288: exception
289: when hr_api.cannot_find_prog_unit then
290: hr_api.cannot_find_prog_unit_error
291: (p_module_name => 'delete_course_prerequisite_b '
292: ,p_hook_type => 'BP'
293: );
286: ,p_object_version_number => p_object_version_number);
287:
288: exception
289: when hr_api.cannot_find_prog_unit then
290: hr_api.cannot_find_prog_unit_error
291: (p_module_name => 'delete_course_prerequisite_b '
292: ,p_hook_type => 'BP'
293: );
294: end;
311: (p_activity_version_id => p_activity_version_id
312: ,p_prerequisite_course_id => p_prerequisite_course_id
313: ,p_object_version_number => p_object_version_number);
314: exception
315: when hr_api.cannot_find_prog_unit then
316: hr_api.cannot_find_prog_unit_error
317: (p_module_name => 'delete_course_prerequisite_a '
318: ,p_hook_type => 'AP'
319: );
312: ,p_prerequisite_course_id => p_prerequisite_course_id
313: ,p_object_version_number => p_object_version_number);
314: exception
315: when hr_api.cannot_find_prog_unit then
316: hr_api.cannot_find_prog_unit_error
317: (p_module_name => 'delete_course_prerequisite_a '
318: ,p_hook_type => 'AP'
319: );
320: end;
321: --
322: -- When in validation only mode raise the Validate_Enabled exception
323: --
324: if p_validate then
325: raise hr_api.validate_enabled;
326: end if;
327: --
328: -- Set all output arguments
329: --
329: --
330: --
331: hr_utility.set_location(' Leaving:'||l_proc, 170);
332: exception
333: when hr_api.validate_enabled then
334: --
335: -- As the Validate_Enabled exception has been raised
336: -- we must rollback to the savepoint
337: --