104: ,p_tk_resource_id => p_tk_resource_id
105: ,p_business_group_id => p_business_group_id
106: );
107: exception
108: when hr_api.cannot_find_prog_unit then
109: hr_api.cannot_find_prog_unit_error
110: (p_module_name => 'create_timekeeper_group'
111: ,p_hook_type => 'BP'
112: );
105: ,p_business_group_id => p_business_group_id
106: );
107: exception
108: when hr_api.cannot_find_prog_unit then
109: hr_api.cannot_find_prog_unit_error
110: (p_module_name => 'create_timekeeper_group'
111: ,p_hook_type => 'BP'
112: );
113: end;
146: ,p_tk_resource_id => p_tk_resource_id
147: ,p_business_group_id => p_business_group_id
148: );
149: exception
150: when hr_api.cannot_find_prog_unit then
151: hr_api.cannot_find_prog_unit_error
152: (p_module_name => 'create_timekeeper_group'
153: ,p_hook_type => 'AP'
154: );
147: ,p_business_group_id => p_business_group_id
148: );
149: exception
150: when hr_api.cannot_find_prog_unit then
151: hr_api.cannot_find_prog_unit_error
152: (p_module_name => 'create_timekeeper_group'
153: ,p_hook_type => 'AP'
154: );
155: end;
160: --
161: -- When in validation only mode raise the Validate_Enabled exception
162: --
163: if p_validate then
164: raise hr_api.validate_enabled;
165: end if;
166: --
167: if g_debug then
168: hr_utility.set_location(' Leaving:'||l_proc, 70);
174: p_object_version_number := l_object_version_number;
175: --
176: exception
177: --
178: when hr_api.validate_enabled then
179: --
180: -- As the Validate_Enabled exception has been raised
181: -- we must rollback to the savepoint
182: --
299: ,p_tk_resource_id => p_tk_resource_id
300: ,p_business_group_id => p_business_group_id
301: );
302: exception
303: when hr_api.cannot_find_prog_unit then
304: hr_api.cannot_find_prog_unit_error
305: (p_module_name => 'update_timekeeper_group'
306: ,p_hook_type => 'BP'
307: );
300: ,p_business_group_id => p_business_group_id
301: );
302: exception
303: when hr_api.cannot_find_prog_unit then
304: hr_api.cannot_find_prog_unit_error
305: (p_module_name => 'update_timekeeper_group'
306: ,p_hook_type => 'BP'
307: );
308: end;
338: ,p_tk_resource_id => p_tk_resource_id
339: ,p_business_group_id => p_business_group_id
340: );
341: exception
342: when hr_api.cannot_find_prog_unit then
343: hr_api.cannot_find_prog_unit_error
344: (p_module_name => 'update_timekeeper_group'
345: ,p_hook_type => 'AP'
346: );
339: ,p_business_group_id => p_business_group_id
340: );
341: exception
342: when hr_api.cannot_find_prog_unit then
343: hr_api.cannot_find_prog_unit_error
344: (p_module_name => 'update_timekeeper_group'
345: ,p_hook_type => 'AP'
346: );
347: end;
352: --
353: -- When in validation only mode raise the Validate_Enabled exception
354: --
355: if p_validate then
356: raise hr_api.validate_enabled;
357: end if;
358: --
359: if g_debug then
360: hr_utility.set_location(' Leaving:'||l_proc, 60);
365: p_object_version_number := l_object_version_number;
366: --
367: exception
368: --
369: when hr_api.validate_enabled then
370: --
371: -- As the Validate_Enabled exception has been raised
372: -- we must rollback to the savepoint
373: --
469: (p_tk_group_id => p_tk_group_id
470: ,p_object_version_number => p_object_version_number
471: );
472: exception
473: when hr_api.cannot_find_prog_unit then
474: hr_api.cannot_find_prog_unit_error
475: (p_module_name => 'delete_timekeeper_group'
476: ,p_hook_type => 'BP'
477: );
470: ,p_object_version_number => p_object_version_number
471: );
472: exception
473: when hr_api.cannot_find_prog_unit then
474: hr_api.cannot_find_prog_unit_error
475: (p_module_name => 'delete_timekeeper_group'
476: ,p_hook_type => 'BP'
477: );
478: end;
501: (p_tk_group_id => p_tk_group_id
502: ,p_object_version_number => p_object_version_number
503: );
504: exception
505: when hr_api.cannot_find_prog_unit then
506: hr_api.cannot_find_prog_unit_error
507: (p_module_name => 'delete_timekeeper_group'
508: ,p_hook_type => 'AP'
509: );
502: ,p_object_version_number => p_object_version_number
503: );
504: exception
505: when hr_api.cannot_find_prog_unit then
506: hr_api.cannot_find_prog_unit_error
507: (p_module_name => 'delete_timekeeper_group'
508: ,p_hook_type => 'AP'
509: );
510: end;
511: --
512: -- When in validation only mode raise the Validate_Enabled exception
513: --
514: if p_validate then
515: raise hr_api.validate_enabled;
516: end if;
517: --
518: if g_debug then
519: hr_utility.set_location(' Leaving:'||l_proc, 50);
520: end if;
521: --
522: exception
523: --
524: when hr_api.validate_enabled then
525: --
526: -- As the Validate_Enabled exception has been raised
527: -- we must rollback to the savepoint
528: --
642: WHERE p.person_id = p_tk_resource_id );
643:
644: BEGIN
645:
646: hr_api.mandatory_arg_error
647: (p_api_name => l_proc
648: ,p_argument => 'TK_RESOURCE_ID'
649: ,p_argument_value => p_tk_resource_id
650: );