56: ,p_author_contact_id => p_author_contact_id
57: ,p_object_version_number => p_object_version_number
58: );
59: exception
60: when hr_api.cannot_find_prog_unit then
61: hr_api.cannot_find_prog_unit_error
62: (p_module_name => 'CREATE_PVT_FRM_THREAD_USER'
63: ,p_hook_type => 'BP'
64: );
57: ,p_object_version_number => p_object_version_number
58: );
59: exception
60: when hr_api.cannot_find_prog_unit then
61: hr_api.cannot_find_prog_unit_error
62: (p_module_name => 'CREATE_PVT_FRM_THREAD_USER'
63: ,p_hook_type => 'BP'
64: );
65: end;
97: ,p_object_version_number => p_object_version_number
98: );
99:
100: exception
101: when hr_api.cannot_find_prog_unit then
102: hr_api.cannot_find_prog_unit_error
103: (p_module_name => 'CREATE_PVT_FRM_THREAD_USER'
104: ,p_hook_type => 'AP'
105: );
98: );
99:
100: exception
101: when hr_api.cannot_find_prog_unit then
102: hr_api.cannot_find_prog_unit_error
103: (p_module_name => 'CREATE_PVT_FRM_THREAD_USER'
104: ,p_hook_type => 'AP'
105: );
106: end;
108: --
109: -- When in validation only mode raise the Validate_Enabled exception
110: --
111: if p_validate then
112: raise hr_api.validate_enabled;
113: end if;
114: --
115: -- Set all output arguments
116: --
118: p_object_version_number := l_object_version_number;
119: --
120: hr_utility.set_location(' Leaving:'||l_proc, 70);
121: exception
122: when hr_api.validate_enabled then
123: --
124: -- As the Validate_Enabled exception has been raised
125: -- we must rollback to the savepoint
126: --
193: ,p_author_contact_id => p_author_contact_id
194: ,p_object_version_number => p_object_version_number
195: );
196: exception
197: when hr_api.cannot_find_prog_unit then
198: hr_api.cannot_find_prog_unit_error
199: (p_module_name => 'UPDATE_PVT_FRM_THREAD_USER'
200: ,p_hook_type => 'BP'
201: );
194: ,p_object_version_number => p_object_version_number
195: );
196: exception
197: when hr_api.cannot_find_prog_unit then
198: hr_api.cannot_find_prog_unit_error
199: (p_module_name => 'UPDATE_PVT_FRM_THREAD_USER'
200: ,p_hook_type => 'BP'
201: );
202: end;
234: ,p_object_version_number => p_object_version_number
235: );
236:
237: exception
238: when hr_api.cannot_find_prog_unit then
239: hr_api.cannot_find_prog_unit_error
240: (p_module_name => 'UPDATE_PVT_FRM_THREAD_USER'
241: ,p_hook_type => 'AP'
242: );
235: );
236:
237: exception
238: when hr_api.cannot_find_prog_unit then
239: hr_api.cannot_find_prog_unit_error
240: (p_module_name => 'UPDATE_PVT_FRM_THREAD_USER'
241: ,p_hook_type => 'AP'
242: );
243: end;
245: --
246: -- When in validation only mode raise the Validate_Enabled exception
247: --
248: if p_validate then
249: raise hr_api.validate_enabled;
250: end if;
251: --
252: -- Set all output arguments
253: --
255: p_object_version_number := l_object_version_number;
256: --
257: hr_utility.set_location(' Leaving:'||l_proc, 70);
258: exception
259: when hr_api.validate_enabled then
260: --
261: -- As the Validate_Enabled exception has been raised
262: -- we must rollback to the savepoint
263: --
313: ,p_contact_id =>p_contact_id
314: ,p_object_version_number =>p_object_version_number
315: );
316: exception
317: when hr_api.cannot_find_prog_unit then
318: hr_api.cannot_find_prog_unit_error
319: (p_module_name => 'DELETE_PVT_FRM_THREAD_USER'
320: ,p_hook_type => 'BP'
321: );
314: ,p_object_version_number =>p_object_version_number
315: );
316: exception
317: when hr_api.cannot_find_prog_unit then
318: hr_api.cannot_find_prog_unit_error
319: (p_module_name => 'DELETE_PVT_FRM_THREAD_USER'
320: ,p_hook_type => 'BP'
321: );
322: end;
346: ,p_object_version_number =>p_object_version_number
347: );
348:
349: exception
350: when hr_api.cannot_find_prog_unit then
351: hr_api.cannot_find_prog_unit_error
352: (p_module_name => 'DELETE_PVT_FRM_THREAD_USER'
353: ,p_hook_type => 'AP'
354: );
347: );
348:
349: exception
350: when hr_api.cannot_find_prog_unit then
351: hr_api.cannot_find_prog_unit_error
352: (p_module_name => 'DELETE_PVT_FRM_THREAD_USER'
353: ,p_hook_type => 'AP'
354: );
355: end;
358: --
359: -- When in validation only mode raise the Validate_Enabled exception
360: --
361: if p_validate then
362: raise hr_api.validate_enabled;
363: end if;
364: --
365: -- Set all output arguments
366: --
366: --
367: --
368: hr_utility.set_location(' Leaving:'||l_proc, 170);
369: exception
370: when hr_api.validate_enabled then
371: --
372: -- As the Validate_Enabled exception has been raised
373: -- we must rollback to the savepoint
374: --