59: ,p_template_item_context_id => p_template_item_context_id
60: ,p_template_tab_page_id => p_template_tab_page_id
61: );
62: exception
63: when hr_api.cannot_find_prog_unit then
64: hr_api.cannot_find_prog_unit_error
65: (p_module_name => 'create_tcp'
66: ,p_hook_type => 'BP'
67: );
60: ,p_template_tab_page_id => p_template_tab_page_id
61: );
62: exception
63: when hr_api.cannot_find_prog_unit then
64: hr_api.cannot_find_prog_unit_error
65: (p_module_name => 'create_tcp'
66: ,p_hook_type => 'BP'
67: );
68: end;
107: ,p_template_item_context_page_i => l_template_item_context_page_i
108: ,p_object_version_number => l_object_version_number
109: );
110: exception
111: when hr_api.cannot_find_prog_unit then
112: hr_api.cannot_find_prog_unit_error
113: (p_module_name => 'create_tcp'
114: ,p_hook_type => 'AP'
115: );
108: ,p_object_version_number => l_object_version_number
109: );
110: exception
111: when hr_api.cannot_find_prog_unit then
112: hr_api.cannot_find_prog_unit_error
113: (p_module_name => 'create_tcp'
114: ,p_hook_type => 'AP'
115: );
116: end;
117: --
118: -- When in validation only mode raise the Validate_Enabled exception
119: --
120: if p_validate then
121: raise hr_api.validate_enabled;
122: end if;
123: --
124: -- Set all output arguments
125: --
127: p_object_version_number := l_object_version_number;
128: --
129: hr_utility.set_location(' Leaving:'||l_proc, 70);
130: exception
131: when hr_api.validate_enabled then
132: --
133: -- As the Validate_Enabled exception has been raised
134: -- we must rollback to the savepoint
135: --
197: ( p_template_item_context_page_i => p_template_item_context_page_i
198: ,p_object_version_number => p_object_version_number
199: );
200: exception
201: when hr_api.cannot_find_prog_unit then
202: hr_api.cannot_find_prog_unit_error
203: (p_module_name => 'delete_tcp'
204: ,p_hook_type => 'BP'
205: );
198: ,p_object_version_number => p_object_version_number
199: );
200: exception
201: when hr_api.cannot_find_prog_unit then
202: hr_api.cannot_find_prog_unit_error
203: (p_module_name => 'delete_tcp'
204: ,p_hook_type => 'BP'
205: );
206: end;
239: ( p_template_item_context_page_i => p_template_item_context_page_i
240: ,p_object_version_number => p_object_version_number
241: );
242: exception
243: when hr_api.cannot_find_prog_unit then
244: hr_api.cannot_find_prog_unit_error
245: (p_module_name => 'delete_tcp'
246: ,p_hook_type => 'AP'
247: );
240: ,p_object_version_number => p_object_version_number
241: );
242: exception
243: when hr_api.cannot_find_prog_unit then
244: hr_api.cannot_find_prog_unit_error
245: (p_module_name => 'delete_tcp'
246: ,p_hook_type => 'AP'
247: );
248: end;
249: --
250: -- When in validation only mode raise the Validate_Enabled exception
251: --
252: if p_validate then
253: raise hr_api.validate_enabled;
254: end if;
255: --
256: hr_utility.set_location(' Leaving:'||l_proc, 70);
257: exception
254: end if;
255: --
256: hr_utility.set_location(' Leaving:'||l_proc, 70);
257: exception
258: when hr_api.validate_enabled then
259: --
260: -- As the Validate_Enabled exception has been raised
261: -- we must rollback to the savepoint
262: --