DBA Data[Home] [Help]

APPS.OTA_FORUM_MESSAGE_API dependencies on HR_API

Line 64: when hr_api.cannot_find_prog_unit then

60: ,p_target_contact_id => p_target_contact_id
61: ,p_object_version_number => p_object_version_number
62: );
63: exception
64: when hr_api.cannot_find_prog_unit then
65: hr_api.cannot_find_prog_unit_error
66: (p_module_name => 'CREATE_FORUM_MESSAGE'
67: ,p_hook_type => 'BP'
68: );

Line 65: hr_api.cannot_find_prog_unit_error

61: ,p_object_version_number => p_object_version_number
62: );
63: exception
64: when hr_api.cannot_find_prog_unit then
65: hr_api.cannot_find_prog_unit_error
66: (p_module_name => 'CREATE_FORUM_MESSAGE'
67: ,p_hook_type => 'BP'
68: );
69: end;

Line 117: when hr_api.cannot_find_prog_unit then

113: ,p_forum_message_id => l_forum_message_id
114: ,p_object_version_number => p_object_version_number
115: );
116: exception
117: when hr_api.cannot_find_prog_unit then
118: hr_api.cannot_find_prog_unit_error
119: (p_module_name => 'CREATE_FORUM_MESSAGE'
120: ,p_hook_type => 'AP'
121: );

Line 118: hr_api.cannot_find_prog_unit_error

114: ,p_object_version_number => p_object_version_number
115: );
116: exception
117: when hr_api.cannot_find_prog_unit then
118: hr_api.cannot_find_prog_unit_error
119: (p_module_name => 'CREATE_FORUM_MESSAGE'
120: ,p_hook_type => 'AP'
121: );
122: end;

Line 129: raise hr_api.validate_enabled;

125: --
126: -- When in validation only mode raise the Validate_Enabled exception
127: --
128: if p_validate then
129: raise hr_api.validate_enabled;
130: end if;
131: --
132: -- Set all output arguments
133: --

Line 146: when hr_api.validate_enabled then

142: end if;
143:
144: hr_utility.set_location(' Leaving:'||l_proc, 70);
145: exception
146: when hr_api.validate_enabled then
147: --
148: -- As the Validate_Enabled exception has been raised
149: -- we must rollback to the savepoint
150: --

Line 179: ,p_forum_id in number default hr_api.g_number

175: --
176: procedure update_forum_message(
177: p_validate in boolean default false
178: ,p_effective_date in date
179: ,p_forum_id in number default hr_api.g_number
180: ,p_forum_thread_id in number default hr_api.g_number
181: ,p_business_group_id in number default hr_api.g_number
182: ,p_message_scope in varchar2 default hr_api.g_varchar2
183: ,p_message_body in varchar2 default hr_api.g_varchar2

Line 180: ,p_forum_thread_id in number default hr_api.g_number

176: procedure update_forum_message(
177: p_validate in boolean default false
178: ,p_effective_date in date
179: ,p_forum_id in number default hr_api.g_number
180: ,p_forum_thread_id in number default hr_api.g_number
181: ,p_business_group_id in number default hr_api.g_number
182: ,p_message_scope in varchar2 default hr_api.g_varchar2
183: ,p_message_body in varchar2 default hr_api.g_varchar2
184: ,p_parent_message_id in number default hr_api.g_number

Line 181: ,p_business_group_id in number default hr_api.g_number

177: p_validate in boolean default false
178: ,p_effective_date in date
179: ,p_forum_id in number default hr_api.g_number
180: ,p_forum_thread_id in number default hr_api.g_number
181: ,p_business_group_id in number default hr_api.g_number
182: ,p_message_scope in varchar2 default hr_api.g_varchar2
183: ,p_message_body in varchar2 default hr_api.g_varchar2
184: ,p_parent_message_id in number default hr_api.g_number
185: ,p_person_id in number default hr_api.g_number

Line 182: ,p_message_scope in varchar2 default hr_api.g_varchar2

178: ,p_effective_date in date
179: ,p_forum_id in number default hr_api.g_number
180: ,p_forum_thread_id in number default hr_api.g_number
181: ,p_business_group_id in number default hr_api.g_number
182: ,p_message_scope in varchar2 default hr_api.g_varchar2
183: ,p_message_body in varchar2 default hr_api.g_varchar2
184: ,p_parent_message_id in number default hr_api.g_number
185: ,p_person_id in number default hr_api.g_number
186: ,p_contact_id in number default hr_api.g_number

Line 183: ,p_message_body in varchar2 default hr_api.g_varchar2

179: ,p_forum_id in number default hr_api.g_number
180: ,p_forum_thread_id in number default hr_api.g_number
181: ,p_business_group_id in number default hr_api.g_number
182: ,p_message_scope in varchar2 default hr_api.g_varchar2
183: ,p_message_body in varchar2 default hr_api.g_varchar2
184: ,p_parent_message_id in number default hr_api.g_number
185: ,p_person_id in number default hr_api.g_number
186: ,p_contact_id in number default hr_api.g_number
187: ,p_target_person_id in number default hr_api.g_number

Line 184: ,p_parent_message_id in number default hr_api.g_number

180: ,p_forum_thread_id in number default hr_api.g_number
181: ,p_business_group_id in number default hr_api.g_number
182: ,p_message_scope in varchar2 default hr_api.g_varchar2
183: ,p_message_body in varchar2 default hr_api.g_varchar2
184: ,p_parent_message_id in number default hr_api.g_number
185: ,p_person_id in number default hr_api.g_number
186: ,p_contact_id in number default hr_api.g_number
187: ,p_target_person_id in number default hr_api.g_number
188: ,p_target_contact_id in number default hr_api.g_number

Line 185: ,p_person_id in number default hr_api.g_number

181: ,p_business_group_id in number default hr_api.g_number
182: ,p_message_scope in varchar2 default hr_api.g_varchar2
183: ,p_message_body in varchar2 default hr_api.g_varchar2
184: ,p_parent_message_id in number default hr_api.g_number
185: ,p_person_id in number default hr_api.g_number
186: ,p_contact_id in number default hr_api.g_number
187: ,p_target_person_id in number default hr_api.g_number
188: ,p_target_contact_id in number default hr_api.g_number
189: ,p_forum_message_id in number

Line 186: ,p_contact_id in number default hr_api.g_number

182: ,p_message_scope in varchar2 default hr_api.g_varchar2
183: ,p_message_body in varchar2 default hr_api.g_varchar2
184: ,p_parent_message_id in number default hr_api.g_number
185: ,p_person_id in number default hr_api.g_number
186: ,p_contact_id in number default hr_api.g_number
187: ,p_target_person_id in number default hr_api.g_number
188: ,p_target_contact_id in number default hr_api.g_number
189: ,p_forum_message_id in number
190: ,p_object_version_number in out nocopy number) is

Line 187: ,p_target_person_id in number default hr_api.g_number

183: ,p_message_body in varchar2 default hr_api.g_varchar2
184: ,p_parent_message_id in number default hr_api.g_number
185: ,p_person_id in number default hr_api.g_number
186: ,p_contact_id in number default hr_api.g_number
187: ,p_target_person_id in number default hr_api.g_number
188: ,p_target_contact_id in number default hr_api.g_number
189: ,p_forum_message_id in number
190: ,p_object_version_number in out nocopy number) is
191: --

Line 188: ,p_target_contact_id in number default hr_api.g_number

184: ,p_parent_message_id in number default hr_api.g_number
185: ,p_person_id in number default hr_api.g_number
186: ,p_contact_id in number default hr_api.g_number
187: ,p_target_person_id in number default hr_api.g_number
188: ,p_target_contact_id in number default hr_api.g_number
189: ,p_forum_message_id in number
190: ,p_object_version_number in out nocopy number) is
191: --
192: -- Declare cursors and local variables

Line 229: when hr_api.cannot_find_prog_unit then

225: ,p_forum_message_id => p_forum_message_id
226: ,p_object_version_number => l_object_version_number
227: );
228: exception
229: when hr_api.cannot_find_prog_unit then
230: hr_api.cannot_find_prog_unit_error
231: (p_module_name => 'UPDATE_FORUM_MESSAGE'
232: ,p_hook_type => 'BP'
233: );

Line 230: hr_api.cannot_find_prog_unit_error

226: ,p_object_version_number => l_object_version_number
227: );
228: exception
229: when hr_api.cannot_find_prog_unit then
230: hr_api.cannot_find_prog_unit_error
231: (p_module_name => 'UPDATE_FORUM_MESSAGE'
232: ,p_hook_type => 'BP'
233: );
234: end;

Line 282: when hr_api.cannot_find_prog_unit then

278: ,p_forum_message_id => p_forum_message_id
279: ,p_object_version_number => l_object_version_number
280: );
281: exception
282: when hr_api.cannot_find_prog_unit then
283: hr_api.cannot_find_prog_unit_error
284: (p_module_name => 'UPDATE_FORUM_MESSAGE'
285: ,p_hook_type => 'AP'
286: );

Line 283: hr_api.cannot_find_prog_unit_error

279: ,p_object_version_number => l_object_version_number
280: );
281: exception
282: when hr_api.cannot_find_prog_unit then
283: hr_api.cannot_find_prog_unit_error
284: (p_module_name => 'UPDATE_FORUM_MESSAGE'
285: ,p_hook_type => 'AP'
286: );
287: end;

Line 294: raise hr_api.validate_enabled;

290: --
291: -- When in validation only mode raise the Validate_Enabled exception
292: --
293: if p_validate then
294: raise hr_api.validate_enabled;
295: end if;
296: --
297:
298: hr_utility.set_location(' Leaving:'||l_proc, 70);

Line 300: when hr_api.validate_enabled then

296: --
297:
298: hr_utility.set_location(' Leaving:'||l_proc, 70);
299: exception
300: when hr_api.validate_enabled then
301: --
302: -- As the Validate_Enabled exception has been raised
303: -- we must rollback to the savepoint
304: --

Line 369: when hr_api.cannot_find_prog_unit then

365: (p_forum_message_id =>p_forum_message_id
366: ,p_object_version_number =>p_object_version_number
367: );
368: exception
369: when hr_api.cannot_find_prog_unit then
370: hr_api.cannot_find_prog_unit_error
371: (p_module_name => 'DELETE_FORUM_MESSAGE'
372: ,p_hook_type => 'BP'
373: );

Line 370: hr_api.cannot_find_prog_unit_error

366: ,p_object_version_number =>p_object_version_number
367: );
368: exception
369: when hr_api.cannot_find_prog_unit then
370: hr_api.cannot_find_prog_unit_error
371: (p_module_name => 'DELETE_FORUM_MESSAGE'
372: ,p_hook_type => 'BP'
373: );
374: end;

Line 413: when hr_api.cannot_find_prog_unit then

409: (p_forum_message_id =>p_forum_message_id
410: ,p_object_version_number =>p_object_version_number
411: );
412: exception
413: when hr_api.cannot_find_prog_unit then
414: hr_api.cannot_find_prog_unit_error
415: (p_module_name => 'DELETE_FORUM_MESSAGE'
416: ,p_hook_type => 'AP'
417: );

Line 414: hr_api.cannot_find_prog_unit_error

410: ,p_object_version_number =>p_object_version_number
411: );
412: exception
413: when hr_api.cannot_find_prog_unit then
414: hr_api.cannot_find_prog_unit_error
415: (p_module_name => 'DELETE_FORUM_MESSAGE'
416: ,p_hook_type => 'AP'
417: );
418: end;

Line 423: raise hr_api.validate_enabled;

419: --
420: -- When in validation only mode raise the Validate_Enabled exception
421: --
422: if p_validate then
423: raise hr_api.validate_enabled;
424: end if;
425: --
426: -- Set all output arguments
427: --

Line 431: when hr_api.validate_enabled then

427: --
428: --
429: hr_utility.set_location(' Leaving:'||l_proc, 170);
430: exception
431: when hr_api.validate_enabled then
432: --
433: -- As the Validate_Enabled exception has been raised
434: -- we must rollback to the savepoint
435: --