66: ,p_no_formula_flag => p_no_formula_flag
67: ,p_effective_date => trunc(p_effective_date)
68: );
69: exception
70: when hr_api.cannot_find_prog_unit then
71: hr_api.cannot_find_prog_unit_error
72: (
73: p_module_name => 'CREATE_popup_message'
74: ,p_hook_type => 'BP'
67: ,p_effective_date => trunc(p_effective_date)
68: );
69: exception
70: when hr_api.cannot_find_prog_unit then
71: hr_api.cannot_find_prog_unit_error
72: (
73: p_module_name => 'CREATE_popup_message'
74: ,p_hook_type => 'BP'
75: );
119: ,p_no_formula_flag => p_no_formula_flag
120: ,p_effective_date => trunc(p_effective_date)
121: );
122: exception
123: when hr_api.cannot_find_prog_unit then
124: hr_api.cannot_find_prog_unit_error
125: (p_module_name => 'CREATE_popup_message'
126: ,p_hook_type => 'AP'
127: );
120: ,p_effective_date => trunc(p_effective_date)
121: );
122: exception
123: when hr_api.cannot_find_prog_unit then
124: hr_api.cannot_find_prog_unit_error
125: (p_module_name => 'CREATE_popup_message'
126: ,p_hook_type => 'AP'
127: );
128: --
134: --
135: -- When in validation only mode raise the Validate_Enabled exception
136: --
137: if p_validate then
138: raise hr_api.validate_enabled;
139: end if;
140: --
141: -- Set all output arguments
142: --
146: hr_utility.set_location(' Leaving:'||l_proc, 70);
147: --
148: exception
149: --
150: when hr_api.validate_enabled then
151: --
152: -- As the Validate_Enabled exception has been raised
153: -- we must rollback to the savepoint
154: --
180: --
181: procedure update_popup_message
182: (p_validate in boolean default false
183: ,p_pop_up_messages_id in number
184: ,p_pop_name in varchar2 default hr_api.g_varchar2
185: ,p_formula_id in number default hr_api.g_number
186: ,p_function_name in varchar2 default hr_api.g_varchar2
187: ,p_block_name in varchar2 default hr_api.g_varchar2
188: ,p_field_name in varchar2 default hr_api.g_varchar2
181: procedure update_popup_message
182: (p_validate in boolean default false
183: ,p_pop_up_messages_id in number
184: ,p_pop_name in varchar2 default hr_api.g_varchar2
185: ,p_formula_id in number default hr_api.g_number
186: ,p_function_name in varchar2 default hr_api.g_varchar2
187: ,p_block_name in varchar2 default hr_api.g_varchar2
188: ,p_field_name in varchar2 default hr_api.g_varchar2
189: ,p_event_name in varchar2 default hr_api.g_varchar2
182: (p_validate in boolean default false
183: ,p_pop_up_messages_id in number
184: ,p_pop_name in varchar2 default hr_api.g_varchar2
185: ,p_formula_id in number default hr_api.g_number
186: ,p_function_name in varchar2 default hr_api.g_varchar2
187: ,p_block_name in varchar2 default hr_api.g_varchar2
188: ,p_field_name in varchar2 default hr_api.g_varchar2
189: ,p_event_name in varchar2 default hr_api.g_varchar2
190: ,p_message in varchar2 default hr_api.g_varchar2
183: ,p_pop_up_messages_id in number
184: ,p_pop_name in varchar2 default hr_api.g_varchar2
185: ,p_formula_id in number default hr_api.g_number
186: ,p_function_name in varchar2 default hr_api.g_varchar2
187: ,p_block_name in varchar2 default hr_api.g_varchar2
188: ,p_field_name in varchar2 default hr_api.g_varchar2
189: ,p_event_name in varchar2 default hr_api.g_varchar2
190: ,p_message in varchar2 default hr_api.g_varchar2
191: ,p_message_type in varchar2 default hr_api.g_varchar2
184: ,p_pop_name in varchar2 default hr_api.g_varchar2
185: ,p_formula_id in number default hr_api.g_number
186: ,p_function_name in varchar2 default hr_api.g_varchar2
187: ,p_block_name in varchar2 default hr_api.g_varchar2
188: ,p_field_name in varchar2 default hr_api.g_varchar2
189: ,p_event_name in varchar2 default hr_api.g_varchar2
190: ,p_message in varchar2 default hr_api.g_varchar2
191: ,p_message_type in varchar2 default hr_api.g_varchar2
192: ,p_business_group_id in number default hr_api.g_number
185: ,p_formula_id in number default hr_api.g_number
186: ,p_function_name in varchar2 default hr_api.g_varchar2
187: ,p_block_name in varchar2 default hr_api.g_varchar2
188: ,p_field_name in varchar2 default hr_api.g_varchar2
189: ,p_event_name in varchar2 default hr_api.g_varchar2
190: ,p_message in varchar2 default hr_api.g_varchar2
191: ,p_message_type in varchar2 default hr_api.g_varchar2
192: ,p_business_group_id in number default hr_api.g_number
193: ,p_object_version_number in out nocopy number
186: ,p_function_name in varchar2 default hr_api.g_varchar2
187: ,p_block_name in varchar2 default hr_api.g_varchar2
188: ,p_field_name in varchar2 default hr_api.g_varchar2
189: ,p_event_name in varchar2 default hr_api.g_varchar2
190: ,p_message in varchar2 default hr_api.g_varchar2
191: ,p_message_type in varchar2 default hr_api.g_varchar2
192: ,p_business_group_id in number default hr_api.g_number
193: ,p_object_version_number in out nocopy number
194: ,p_start_date in date default hr_api.g_date
187: ,p_block_name in varchar2 default hr_api.g_varchar2
188: ,p_field_name in varchar2 default hr_api.g_varchar2
189: ,p_event_name in varchar2 default hr_api.g_varchar2
190: ,p_message in varchar2 default hr_api.g_varchar2
191: ,p_message_type in varchar2 default hr_api.g_varchar2
192: ,p_business_group_id in number default hr_api.g_number
193: ,p_object_version_number in out nocopy number
194: ,p_start_date in date default hr_api.g_date
195: ,p_end_date in date default hr_api.g_date
188: ,p_field_name in varchar2 default hr_api.g_varchar2
189: ,p_event_name in varchar2 default hr_api.g_varchar2
190: ,p_message in varchar2 default hr_api.g_varchar2
191: ,p_message_type in varchar2 default hr_api.g_varchar2
192: ,p_business_group_id in number default hr_api.g_number
193: ,p_object_version_number in out nocopy number
194: ,p_start_date in date default hr_api.g_date
195: ,p_end_date in date default hr_api.g_date
196: ,p_no_formula_flag in varchar2 default hr_api.g_varchar2
190: ,p_message in varchar2 default hr_api.g_varchar2
191: ,p_message_type in varchar2 default hr_api.g_varchar2
192: ,p_business_group_id in number default hr_api.g_number
193: ,p_object_version_number in out nocopy number
194: ,p_start_date in date default hr_api.g_date
195: ,p_end_date in date default hr_api.g_date
196: ,p_no_formula_flag in varchar2 default hr_api.g_varchar2
197: ,p_effective_date in date
198: ) is
191: ,p_message_type in varchar2 default hr_api.g_varchar2
192: ,p_business_group_id in number default hr_api.g_number
193: ,p_object_version_number in out nocopy number
194: ,p_start_date in date default hr_api.g_date
195: ,p_end_date in date default hr_api.g_date
196: ,p_no_formula_flag in varchar2 default hr_api.g_varchar2
197: ,p_effective_date in date
198: ) is
199: --
192: ,p_business_group_id in number default hr_api.g_number
193: ,p_object_version_number in out nocopy number
194: ,p_start_date in date default hr_api.g_date
195: ,p_end_date in date default hr_api.g_date
196: ,p_no_formula_flag in varchar2 default hr_api.g_varchar2
197: ,p_effective_date in date
198: ) is
199: --
200: -- Declare cursors and local variables
238: ,p_no_formula_flag => p_no_formula_flag
239: ,p_effective_date => trunc(p_effective_date)
240: );
241: exception
242: when hr_api.cannot_find_prog_unit then
243: hr_api.cannot_find_prog_unit_error
244: (p_module_name => 'UPDATE_popup_message'
245: ,p_hook_type => 'BP'
246: );
239: ,p_effective_date => trunc(p_effective_date)
240: );
241: exception
242: when hr_api.cannot_find_prog_unit then
243: hr_api.cannot_find_prog_unit_error
244: (p_module_name => 'UPDATE_popup_message'
245: ,p_hook_type => 'BP'
246: );
247: --
290: ,p_no_formula_flag => p_no_formula_flag
291: ,p_effective_date => trunc(p_effective_date)
292: );
293: exception
294: when hr_api.cannot_find_prog_unit then
295: hr_api.cannot_find_prog_unit_error
296: (p_module_name => 'UPDATE_popup_message'
297: ,p_hook_type => 'AP'
298: );
291: ,p_effective_date => trunc(p_effective_date)
292: );
293: exception
294: when hr_api.cannot_find_prog_unit then
295: hr_api.cannot_find_prog_unit_error
296: (p_module_name => 'UPDATE_popup_message'
297: ,p_hook_type => 'AP'
298: );
299: --
305: --
306: -- When in validation only mode raise the Validate_Enabled exception
307: --
308: if p_validate then
309: raise hr_api.validate_enabled;
310: end if;
311: --
312: -- Set all output arguments
313: --
316: hr_utility.set_location(' Leaving:'||l_proc, 70);
317: --
318: exception
319: --
320: when hr_api.validate_enabled then
321: --
322: -- As the Validate_Enabled exception has been raised
323: -- we must rollback to the savepoint
324: --
379: ,p_object_version_number => p_object_version_number
380: ,p_effective_date => trunc(p_effective_date)
381: );
382: exception
383: when hr_api.cannot_find_prog_unit then
384: hr_api.cannot_find_prog_unit_error
385: (p_module_name => 'DELETE_popup_message'
386: ,p_hook_type => 'BP'
387: );
380: ,p_effective_date => trunc(p_effective_date)
381: );
382: exception
383: when hr_api.cannot_find_prog_unit then
384: hr_api.cannot_find_prog_unit_error
385: (p_module_name => 'DELETE_popup_message'
386: ,p_hook_type => 'BP'
387: );
388: --
407: ,p_object_version_number => l_object_version_number
408: ,p_effective_date => trunc(p_effective_date)
409: );
410: exception
411: when hr_api.cannot_find_prog_unit then
412: hr_api.cannot_find_prog_unit_error
413: (p_module_name => 'DELETE_popup_message'
414: ,p_hook_type => 'AP'
415: );
408: ,p_effective_date => trunc(p_effective_date)
409: );
410: exception
411: when hr_api.cannot_find_prog_unit then
412: hr_api.cannot_find_prog_unit_error
413: (p_module_name => 'DELETE_popup_message'
414: ,p_hook_type => 'AP'
415: );
416: --
422: --
423: -- When in validation only mode raise the Validate_Enabled exception
424: --
425: if p_validate then
426: raise hr_api.validate_enabled;
427: end if;
428: --
429: hr_utility.set_location(' Leaving:'||l_proc, 70);
430: --
429: hr_utility.set_location(' Leaving:'||l_proc, 70);
430: --
431: exception
432: --
433: when hr_api.validate_enabled then
434: --
435: -- As the Validate_Enabled exception has been raised
436: -- we must rollback to the savepoint
437: --