52: ,p_consolidation_set_id => p_consolidation_set_id
53: ,p_payroll_id => p_payroll_id
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_exception_group'
59: ,p_hook_type => 'BP'
60: );
53: ,p_payroll_id => p_payroll_id
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_exception_group'
59: ,p_hook_type => 'BP'
60: );
61: end;
98: ,p_exception_group_id => l_exception_group_id
99: ,p_object_version_number => l_object_version_number
100: );
101: exception
102: when hr_api.cannot_find_prog_unit then
103: hr_api.cannot_find_prog_unit_error
104: (p_module_name => 'create_exception_group'
105: ,p_hook_type => 'AP'
106: );
99: ,p_object_version_number => l_object_version_number
100: );
101: exception
102: when hr_api.cannot_find_prog_unit then
103: hr_api.cannot_find_prog_unit_error
104: (p_module_name => 'create_exception_group'
105: ,p_hook_type => 'AP'
106: );
107: end;
109: --
110: -- When in validation only mode raise the Validate_Enabled exception
111: --
112: if p_validate then
113: raise hr_api.validate_enabled;
114: end if;
115: --
116: -- Set all output arguments
117: --
119: p_object_version_number := l_object_version_number;
120: --
121: hr_utility.set_location(' Leaving:'||l_proc, 70);
122: exception
123: when hr_api.validate_enabled then
124: --
125: -- As the Validate_Enabled exception has been raised
126: -- we must rollback to the savepoint
127: --
150: -- ----------------------------------------------------------------------------
151: --
152: procedure update_exception_group
153: (p_validate in boolean default false
154: ,p_exception_group_id in number default hr_api.g_number
155: ,p_exception_group_name in varchar2 default hr_api.g_varchar2
156: ,p_exception_report_id in number default hr_api.g_number
157: ,p_legislation_code in varchar2 default hr_api.g_varchar2
158: ,p_business_group_id in number default hr_api.g_number
151: --
152: procedure update_exception_group
153: (p_validate in boolean default false
154: ,p_exception_group_id in number default hr_api.g_number
155: ,p_exception_group_name in varchar2 default hr_api.g_varchar2
156: ,p_exception_report_id in number default hr_api.g_number
157: ,p_legislation_code in varchar2 default hr_api.g_varchar2
158: ,p_business_group_id in number default hr_api.g_number
159: ,p_consolidation_set_id in number default hr_api.g_number
152: procedure update_exception_group
153: (p_validate in boolean default false
154: ,p_exception_group_id in number default hr_api.g_number
155: ,p_exception_group_name in varchar2 default hr_api.g_varchar2
156: ,p_exception_report_id in number default hr_api.g_number
157: ,p_legislation_code in varchar2 default hr_api.g_varchar2
158: ,p_business_group_id in number default hr_api.g_number
159: ,p_consolidation_set_id in number default hr_api.g_number
160: ,p_payroll_id in number default hr_api.g_number
153: (p_validate in boolean default false
154: ,p_exception_group_id in number default hr_api.g_number
155: ,p_exception_group_name in varchar2 default hr_api.g_varchar2
156: ,p_exception_report_id in number default hr_api.g_number
157: ,p_legislation_code in varchar2 default hr_api.g_varchar2
158: ,p_business_group_id in number default hr_api.g_number
159: ,p_consolidation_set_id in number default hr_api.g_number
160: ,p_payroll_id in number default hr_api.g_number
161: ,p_object_version_number in out nocopy number
154: ,p_exception_group_id in number default hr_api.g_number
155: ,p_exception_group_name in varchar2 default hr_api.g_varchar2
156: ,p_exception_report_id in number default hr_api.g_number
157: ,p_legislation_code in varchar2 default hr_api.g_varchar2
158: ,p_business_group_id in number default hr_api.g_number
159: ,p_consolidation_set_id in number default hr_api.g_number
160: ,p_payroll_id in number default hr_api.g_number
161: ,p_object_version_number in out nocopy number
162: ,p_output_format in varchar2 default hr_api.g_varchar2
155: ,p_exception_group_name in varchar2 default hr_api.g_varchar2
156: ,p_exception_report_id in number default hr_api.g_number
157: ,p_legislation_code in varchar2 default hr_api.g_varchar2
158: ,p_business_group_id in number default hr_api.g_number
159: ,p_consolidation_set_id in number default hr_api.g_number
160: ,p_payroll_id in number default hr_api.g_number
161: ,p_object_version_number in out nocopy number
162: ,p_output_format in varchar2 default hr_api.g_varchar2
163: ) is
156: ,p_exception_report_id in number default hr_api.g_number
157: ,p_legislation_code in varchar2 default hr_api.g_varchar2
158: ,p_business_group_id in number default hr_api.g_number
159: ,p_consolidation_set_id in number default hr_api.g_number
160: ,p_payroll_id in number default hr_api.g_number
161: ,p_object_version_number in out nocopy number
162: ,p_output_format in varchar2 default hr_api.g_varchar2
163: ) is
164:
158: ,p_business_group_id in number default hr_api.g_number
159: ,p_consolidation_set_id in number default hr_api.g_number
160: ,p_payroll_id in number default hr_api.g_number
161: ,p_object_version_number in out nocopy number
162: ,p_output_format in varchar2 default hr_api.g_varchar2
163: ) is
164:
165: --
166: -- Declare cursors and local variables
193: ,p_exception_group_id => p_exception_group_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_exception_group'
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_exception_group'
200: ,p_hook_type => 'BP'
201: );
202: end;
241: ,p_exception_group_id => p_exception_group_id
242: ,p_object_version_number => l_object_version_number
243: );
244: exception
245: when hr_api.cannot_find_prog_unit then
246: hr_api.cannot_find_prog_unit_error
247: (p_module_name => 'update_exception_group'
248: ,p_hook_type => 'AP'
249: );
242: ,p_object_version_number => l_object_version_number
243: );
244: exception
245: when hr_api.cannot_find_prog_unit then
246: hr_api.cannot_find_prog_unit_error
247: (p_module_name => 'update_exception_group'
248: ,p_hook_type => 'AP'
249: );
250: end;
252: --
253: -- When in validation only mode raise the Validate_Enabled exception
254: --
255: if p_validate then
256: raise hr_api.validate_enabled;
257: end if;
258: --
259: -- Set all output arguments
260: --
261: p_object_version_number := l_object_version_number;
262: --
263: hr_utility.set_location(' Leaving:'||l_proc, 70);
264: exception
265: when hr_api.validate_enabled then
266: --
267: -- As the Validate_Enabled exception has been raised
268: -- we must rollback to the savepoint
269: --
317: (p_exception_group_id => p_exception_group_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_exception_group'
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_exception_group'
324: ,p_hook_type => 'BP'
325: );
326: end;
351: (p_exception_group_id => p_exception_group_id
352: ,p_object_version_number => p_object_version_number
353: );
354: exception
355: when hr_api.cannot_find_prog_unit then
356: hr_api.cannot_find_prog_unit_error
357: (p_module_name => 'delete_exception_group'
358: ,p_hook_type => 'AP'
359: );
352: ,p_object_version_number => p_object_version_number
353: );
354: exception
355: when hr_api.cannot_find_prog_unit then
356: hr_api.cannot_find_prog_unit_error
357: (p_module_name => 'delete_exception_group'
358: ,p_hook_type => 'AP'
359: );
360: end;
362: --
363: -- When in validation only mode raise the Validate_Enabled exception
364: --
365: if p_validate then
366: raise hr_api.validate_enabled;
367: end if;
368: --
369: -- Set all output arguments
370: --
370: --
371: --
372: hr_utility.set_location(' Leaving:'||l_proc, 70);
373: exception
374: when hr_api.validate_enabled then
375: --
376: -- As the Validate_Enabled exception has been raised
377: -- we must rollback to the savepoint
378: --