52: ,p_reply_count => p_reply_count
53: ,p_object_version_number => p_object_version_number
54: );
55: exception
56: when hr_api.cannot_find_prog_unit then
57: hr_api.cannot_find_prog_unit_error
58: (p_module_name => 'CREATE_FORUM_THREAD'
59: ,p_hook_type => 'BP'
60: );
53: ,p_object_version_number => p_object_version_number
54: );
55: exception
56: when hr_api.cannot_find_prog_unit then
57: hr_api.cannot_find_prog_unit_error
58: (p_module_name => 'CREATE_FORUM_THREAD'
59: ,p_hook_type => 'BP'
60: );
61: end;
94: ,p_forum_thread_id => p_forum_thread_id
95: ,p_object_version_number => p_object_version_number
96: );
97: exception
98: when hr_api.cannot_find_prog_unit then
99: hr_api.cannot_find_prog_unit_error
100: (p_module_name => 'CREATE_FORUM_THREAD'
101: ,p_hook_type => 'AP'
102: );
95: ,p_object_version_number => p_object_version_number
96: );
97: exception
98: when hr_api.cannot_find_prog_unit then
99: hr_api.cannot_find_prog_unit_error
100: (p_module_name => 'CREATE_FORUM_THREAD'
101: ,p_hook_type => 'AP'
102: );
103: end;
104: --
105: -- When in validation only mode raise the Validate_Enabled exception
106: --
107: if p_validate then
108: raise hr_api.validate_enabled;
109: end if;
110: --
111: -- Set all output arguments
112: --
115:
116:
117: hr_utility.set_location(' Leaving:'||l_proc, 70);
118: exception
119: when hr_api.validate_enabled then
120: --
121: -- As the Validate_Enabled exception has been raised
122: -- we must rollback to the savepoint
123: --
189: ,p_forum_thread_id => p_forum_thread_id
190: ,p_object_version_number => l_object_version_number
191: );
192: exception
193: when hr_api.cannot_find_prog_unit then
194: hr_api.cannot_find_prog_unit_error
195: (p_module_name => 'UPDATE_FORUM_THREAD'
196: ,p_hook_type => 'BP'
197: );
190: ,p_object_version_number => l_object_version_number
191: );
192: exception
193: when hr_api.cannot_find_prog_unit then
194: hr_api.cannot_find_prog_unit_error
195: (p_module_name => 'UPDATE_FORUM_THREAD'
196: ,p_hook_type => 'BP'
197: );
198: end;
231: ,p_forum_thread_id => p_forum_thread_id
232: ,p_object_version_number => l_object_version_number
233: );
234: exception
235: when hr_api.cannot_find_prog_unit then
236: hr_api.cannot_find_prog_unit_error
237: (p_module_name => 'UPDATE_FORUM_THREAD'
238: ,p_hook_type => 'AP'
239: );
232: ,p_object_version_number => l_object_version_number
233: );
234: exception
235: when hr_api.cannot_find_prog_unit then
236: hr_api.cannot_find_prog_unit_error
237: (p_module_name => 'UPDATE_FORUM_THREAD'
238: ,p_hook_type => 'AP'
239: );
240: end;
241: --
242: -- When in validation only mode raise the Validate_Enabled exception
243: --
244: if p_validate then
245: raise hr_api.validate_enabled;
246: end if;
247: --
248: -- Set all output arguments
249: --
251:
252:
253: hr_utility.set_location(' Leaving:'||l_proc, 70);
254: exception
255: when hr_api.validate_enabled then
256: --
257: -- As the Validate_Enabled exception has been raised
258: -- we must rollback to the savepoint
259: --
317: (p_forum_thread_id => p_forum_thread_id
318: ,p_object_version_number => p_object_version_number
319: );
320: exception
321: when hr_api.cannot_find_prog_unit then
322: hr_api.cannot_find_prog_unit_error
323: (p_module_name => 'DELETE_FORUM_THREAD'
324: ,p_hook_type => 'BP'
325: );
318: ,p_object_version_number => p_object_version_number
319: );
320: exception
321: when hr_api.cannot_find_prog_unit then
322: hr_api.cannot_find_prog_unit_error
323: (p_module_name => 'DELETE_FORUM_THREAD'
324: ,p_hook_type => 'BP'
325: );
326: end;
362: (p_forum_thread_id => p_forum_thread_id
363: ,p_object_version_number => p_object_version_number
364: );
365: exception
366: when hr_api.cannot_find_prog_unit then
367: hr_api.cannot_find_prog_unit_error
368: (p_module_name => 'DELETE_FORUM_THREAD'
369: ,p_hook_type => 'AP'
370: );
363: ,p_object_version_number => p_object_version_number
364: );
365: exception
366: when hr_api.cannot_find_prog_unit then
367: hr_api.cannot_find_prog_unit_error
368: (p_module_name => 'DELETE_FORUM_THREAD'
369: ,p_hook_type => 'AP'
370: );
371: end;
372: --
373: -- When in validation only mode raise the Validate_Enabled exception
374: --
375: if p_validate then
376: raise hr_api.validate_enabled;
377: end if;
378: --
379: -- Set all output arguments
380: --
380: --
381: --
382: hr_utility.set_location(' Leaving:'||l_proc, 170);
383: exception
384: when hr_api.validate_enabled then
385: --
386: -- As the Validate_Enabled exception has been raised
387: -- we must rollback to the savepoint
388: --