43: ,p_form_tab_page_id => p_form_tab_page_id
44: ,p_form_canvas_id => p_form_canvas_id
45: );
46: exception
47: when hr_api.cannot_find_prog_unit then
48: hr_api.cannot_find_prog_unit_error
49: (p_module_name => 'create_form_tab_stacked_canvas'
50: ,p_hook_type => 'BP'
51: );
44: ,p_form_canvas_id => p_form_canvas_id
45: );
46: exception
47: when hr_api.cannot_find_prog_unit then
48: hr_api.cannot_find_prog_unit_error
49: (p_module_name => 'create_form_tab_stacked_canvas'
50: ,p_hook_type => 'BP'
51: );
52: end;
69: ,p_form_tab_stacked_canvas_id => l_form_tab_stacked_canvas_id
70: ,p_object_version_number => l_object_version_number
71: );
72: exception
73: when hr_api.cannot_find_prog_unit then
74: hr_api.cannot_find_prog_unit_error
75: (p_module_name => 'create_form_tab_stacked_canvas'
76: ,p_hook_type => 'AP'
77: );
70: ,p_object_version_number => l_object_version_number
71: );
72: exception
73: when hr_api.cannot_find_prog_unit then
74: hr_api.cannot_find_prog_unit_error
75: (p_module_name => 'create_form_tab_stacked_canvas'
76: ,p_hook_type => 'AP'
77: );
78: end;
79: --
80: -- When in validation only mode raise the Validate_Enabled exception
81: --
82: if p_validate then
83: raise hr_api.validate_enabled;
84: end if;
85: --
86: -- Set all output arguments
87: --
89: p_form_tab_stacked_canvas_id := l_form_tab_stacked_canvas_id;
90: p_object_version_number := l_object_version_number;
91: hr_utility.set_location(' Leaving:'||l_proc, 70);
92: exception
93: when hr_api.validate_enabled then
94: --
95: -- As the Validate_Enabled exception has been raised
96: -- we must rollback to the savepoint
97: --
144: (p_form_tab_stacked_canvas_id => p_form_tab_stacked_canvas_id
145: ,p_object_version_number => p_object_version_number
146: );
147: exception
148: when hr_api.cannot_find_prog_unit then
149: hr_api.cannot_find_prog_unit_error
150: (p_module_name => 'delete_form_tab_stacked_canvas'
151: ,p_hook_type => 'BP'
152: );
145: ,p_object_version_number => p_object_version_number
146: );
147: exception
148: when hr_api.cannot_find_prog_unit then
149: hr_api.cannot_find_prog_unit_error
150: (p_module_name => 'delete_form_tab_stacked_canvas'
151: ,p_hook_type => 'BP'
152: );
153: end;
167: (p_form_tab_stacked_canvas_id => p_form_tab_stacked_canvas_id
168: ,p_object_version_number => p_object_version_number
169: );
170: exception
171: when hr_api.cannot_find_prog_unit then
172: hr_api.cannot_find_prog_unit_error
173: (p_module_name => 'delete_form_tab_stacked_canvas'
174: ,p_hook_type => 'AP'
175: );
168: ,p_object_version_number => p_object_version_number
169: );
170: exception
171: when hr_api.cannot_find_prog_unit then
172: hr_api.cannot_find_prog_unit_error
173: (p_module_name => 'delete_form_tab_stacked_canvas'
174: ,p_hook_type => 'AP'
175: );
176: end;
177: --
178: -- When in validation only mode raise the Validate_Enabled exception
179: --
180: if p_validate then
181: raise hr_api.validate_enabled;
182: end if;
183: --
184: hr_utility.set_location(' Leaving:'||l_proc, 70);
185: exception
182: end if;
183: --
184: hr_utility.set_location(' Leaving:'||l_proc, 70);
185: exception
186: when hr_api.validate_enabled then
187: --
188: -- As the Validate_Enabled exception has been raised
189: -- we must rollback to the savepoint
190: --