DBA Data[Home] [Help]

APPS.OTA_FORUM_API dependencies on HR_API

Line 64: when hr_api.cannot_find_prog_unit then

60: ,p_end_date_active => p_end_date_active
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'
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'
67: ,p_hook_type => 'BP'
68: );
69: end;

Line 121: when hr_api.cannot_find_prog_unit then

117: ,p_forum_id => p_forum_id
118: ,p_object_version_number => p_object_version_number
119: );
120: exception
121: when hr_api.cannot_find_prog_unit then
122: hr_api.cannot_find_prog_unit_error
123: (p_module_name => 'CREATE_FORUM'
124: ,p_hook_type => 'AP'
125: );

Line 122: hr_api.cannot_find_prog_unit_error

118: ,p_object_version_number => p_object_version_number
119: );
120: exception
121: when hr_api.cannot_find_prog_unit then
122: hr_api.cannot_find_prog_unit_error
123: (p_module_name => 'CREATE_FORUM'
124: ,p_hook_type => 'AP'
125: );
126: end;

Line 133: raise hr_api.validate_enabled;

129: --
130: -- When in validation only mode raise the Validate_Enabled exception
131: --
132: if p_validate then
133: raise hr_api.validate_enabled;
134: end if;
135: --
136: -- Set all output arguments
137: --

Line 144: when hr_api.validate_enabled then

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

Line 178: ,p_start_date_active in date default hr_api.g_date

174: ,p_effective_date in date
175: ,p_name in varchar2
176: ,p_description in varchar2
177: ,p_business_group_id in number
178: ,p_start_date_active in date default hr_api.g_date
179: ,p_end_date_active in date default hr_api.g_date
180: ,p_message_type_flag in varchar2 default hr_api.g_varchar2
181: ,p_allow_html_flag in varchar2 default hr_api.g_varchar2
182: ,p_allow_attachment_flag in varchar2 default hr_api.g_varchar2

Line 179: ,p_end_date_active in date default hr_api.g_date

175: ,p_name in varchar2
176: ,p_description in varchar2
177: ,p_business_group_id in number
178: ,p_start_date_active in date default hr_api.g_date
179: ,p_end_date_active in date default hr_api.g_date
180: ,p_message_type_flag in varchar2 default hr_api.g_varchar2
181: ,p_allow_html_flag in varchar2 default hr_api.g_varchar2
182: ,p_allow_attachment_flag in varchar2 default hr_api.g_varchar2
183: ,p_auto_notification_flag in varchar2 default hr_api.g_varchar2

Line 180: ,p_message_type_flag in varchar2 default hr_api.g_varchar2

176: ,p_description in varchar2
177: ,p_business_group_id in number
178: ,p_start_date_active in date default hr_api.g_date
179: ,p_end_date_active in date default hr_api.g_date
180: ,p_message_type_flag in varchar2 default hr_api.g_varchar2
181: ,p_allow_html_flag in varchar2 default hr_api.g_varchar2
182: ,p_allow_attachment_flag in varchar2 default hr_api.g_varchar2
183: ,p_auto_notification_flag in varchar2 default hr_api.g_varchar2
184: ,p_public_flag in varchar2 default hr_api.g_varchar2

Line 181: ,p_allow_html_flag in varchar2 default hr_api.g_varchar2

177: ,p_business_group_id in number
178: ,p_start_date_active in date default hr_api.g_date
179: ,p_end_date_active in date default hr_api.g_date
180: ,p_message_type_flag in varchar2 default hr_api.g_varchar2
181: ,p_allow_html_flag in varchar2 default hr_api.g_varchar2
182: ,p_allow_attachment_flag in varchar2 default hr_api.g_varchar2
183: ,p_auto_notification_flag in varchar2 default hr_api.g_varchar2
184: ,p_public_flag in varchar2 default hr_api.g_varchar2
185: ,p_forum_id in number

Line 182: ,p_allow_attachment_flag in varchar2 default hr_api.g_varchar2

178: ,p_start_date_active in date default hr_api.g_date
179: ,p_end_date_active in date default hr_api.g_date
180: ,p_message_type_flag in varchar2 default hr_api.g_varchar2
181: ,p_allow_html_flag in varchar2 default hr_api.g_varchar2
182: ,p_allow_attachment_flag in varchar2 default hr_api.g_varchar2
183: ,p_auto_notification_flag in varchar2 default hr_api.g_varchar2
184: ,p_public_flag in varchar2 default hr_api.g_varchar2
185: ,p_forum_id in number
186: ,p_object_version_number in out nocopy number) is

Line 183: ,p_auto_notification_flag in varchar2 default hr_api.g_varchar2

179: ,p_end_date_active in date default hr_api.g_date
180: ,p_message_type_flag in varchar2 default hr_api.g_varchar2
181: ,p_allow_html_flag in varchar2 default hr_api.g_varchar2
182: ,p_allow_attachment_flag in varchar2 default hr_api.g_varchar2
183: ,p_auto_notification_flag in varchar2 default hr_api.g_varchar2
184: ,p_public_flag in varchar2 default hr_api.g_varchar2
185: ,p_forum_id in number
186: ,p_object_version_number in out nocopy number) is
187: --

Line 184: ,p_public_flag in varchar2 default hr_api.g_varchar2

180: ,p_message_type_flag in varchar2 default hr_api.g_varchar2
181: ,p_allow_html_flag in varchar2 default hr_api.g_varchar2
182: ,p_allow_attachment_flag in varchar2 default hr_api.g_varchar2
183: ,p_auto_notification_flag in varchar2 default hr_api.g_varchar2
184: ,p_public_flag in varchar2 default hr_api.g_varchar2
185: ,p_forum_id in number
186: ,p_object_version_number in out nocopy number) is
187: --
188: -- Declare cursors and local variables

Line 225: when hr_api.cannot_find_prog_unit then

221: ,p_object_version_number => p_object_version_number
222: );
223:
224: exception
225: when hr_api.cannot_find_prog_unit then
226: hr_api.cannot_find_prog_unit_error
227: (p_module_name => 'UPDATE_FORUM'
228: ,p_hook_type => 'BP'
229: );

Line 226: hr_api.cannot_find_prog_unit_error

222: );
223:
224: exception
225: when hr_api.cannot_find_prog_unit then
226: hr_api.cannot_find_prog_unit_error
227: (p_module_name => 'UPDATE_FORUM'
228: ,p_hook_type => 'BP'
229: );
230: end;

Line 279: when hr_api.cannot_find_prog_unit then

275: ,p_object_version_number => p_object_version_number
276: );
277:
278: exception
279: when hr_api.cannot_find_prog_unit then
280: hr_api.cannot_find_prog_unit_error
281: (p_module_name => 'UPDATE_FORUM'
282: ,p_hook_type => 'AP'
283: );

Line 280: hr_api.cannot_find_prog_unit_error

276: );
277:
278: exception
279: when hr_api.cannot_find_prog_unit then
280: hr_api.cannot_find_prog_unit_error
281: (p_module_name => 'UPDATE_FORUM'
282: ,p_hook_type => 'AP'
283: );
284: end;

Line 290: raise hr_api.validate_enabled;

286: --
287: -- When in validation only mode raise the Validate_Enabled exception
288: --
289: if p_validate then
290: raise hr_api.validate_enabled;
291: end if;
292: --
293: -- Set all output arguments
294: --

Line 297: when hr_api.validate_enabled then

293: -- Set all output arguments
294: --
295: hr_utility.set_location(' Leaving:'||l_proc, 70);
296: exception
297: when hr_api.validate_enabled then
298: --
299: -- As the Validate_Enabled exception has been raised
300: -- we must rollback to the savepoint
301: --

Line 354: when hr_api.cannot_find_prog_unit then

350: (p_forum_id => p_forum_id
351: ,p_object_version_number => p_object_version_number
352: );
353: exception
354: when hr_api.cannot_find_prog_unit then
355: hr_api.cannot_find_prog_unit_error
356: (p_module_name => 'DELETE_FORUM'
357: ,p_hook_type => 'BP'
358: );

Line 355: hr_api.cannot_find_prog_unit_error

351: ,p_object_version_number => p_object_version_number
352: );
353: exception
354: when hr_api.cannot_find_prog_unit then
355: hr_api.cannot_find_prog_unit_error
356: (p_module_name => 'DELETE_FORUM'
357: ,p_hook_type => 'BP'
358: );
359: end;

Line 386: when hr_api.cannot_find_prog_unit then

382: (p_forum_id => p_forum_id
383: ,p_object_version_number => p_object_version_number
384: );
385: exception
386: when hr_api.cannot_find_prog_unit then
387: hr_api.cannot_find_prog_unit_error
388: (p_module_name => 'DELETE_FORUM'
389: ,p_hook_type => 'AP'
390: );

Line 387: hr_api.cannot_find_prog_unit_error

383: ,p_object_version_number => p_object_version_number
384: );
385: exception
386: when hr_api.cannot_find_prog_unit then
387: hr_api.cannot_find_prog_unit_error
388: (p_module_name => 'DELETE_FORUM'
389: ,p_hook_type => 'AP'
390: );
391: end;

Line 396: raise hr_api.validate_enabled;

392: --
393: -- When in validation only mode raise the Validate_Enabled exception
394: --
395: if p_validate then
396: raise hr_api.validate_enabled;
397: end if;
398: --
399: -- Set all output arguments
400: --

Line 404: when hr_api.validate_enabled then

400: --
401: --
402: hr_utility.set_location(' Leaving:'||l_proc, 170);
403: exception
404: when hr_api.validate_enabled then
405: --
406: -- As the Validate_Enabled exception has been raised
407: -- we must rollback to the savepoint
408: --