54: ,p_location_id => p_location_id
55: ,p_comments => p_comments
56: );
57: exception
58: when hr_api.cannot_find_prog_unit then
59: hr_api.cannot_find_prog_unit_error
60: (p_module_name => 'create_wci_account'
61: ,p_hook_type => 'BP'
62: );
55: ,p_comments => p_comments
56: );
57: exception
58: when hr_api.cannot_find_prog_unit then
59: hr_api.cannot_find_prog_unit_error
60: (p_module_name => 'create_wci_account'
61: ,p_hook_type => 'BP'
62: );
63: end;
98: ,p_location_id => p_location_id
99: ,p_comments => p_comments
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_wci_account'
105: ,p_hook_type => 'AP'
106: );
99: ,p_comments => p_comments
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_wci_account'
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: --
118: hr_utility.set_location(' Leaving:'||l_proc, 70);
119:
120: exception
121:
122: when hr_api.validate_enabled then
123: --
124: -- As the Validate_Enabled exception has been raised
125: -- we must rollback to the savepoint
126: --
157: (p_validate in boolean default false
158: ,p_effective_date in date
159: ,p_account_id in number
160: ,p_object_version_number in out nocopy number
161: ,p_name in varchar2 default hr_api.g_varchar2
162: ,p_account_number in varchar2 default hr_api.g_varchar2
163: ,p_location_id in number default hr_api.g_number
164: ,p_comments in varchar2 default hr_api.g_varchar2
165: ) is
158: ,p_effective_date in date
159: ,p_account_id in number
160: ,p_object_version_number in out nocopy number
161: ,p_name in varchar2 default hr_api.g_varchar2
162: ,p_account_number in varchar2 default hr_api.g_varchar2
163: ,p_location_id in number default hr_api.g_number
164: ,p_comments in varchar2 default hr_api.g_varchar2
165: ) is
166: --
159: ,p_account_id in number
160: ,p_object_version_number in out nocopy number
161: ,p_name in varchar2 default hr_api.g_varchar2
162: ,p_account_number in varchar2 default hr_api.g_varchar2
163: ,p_location_id in number default hr_api.g_number
164: ,p_comments in varchar2 default hr_api.g_varchar2
165: ) is
166: --
167: -- Declare cursors and local variables
160: ,p_object_version_number in out nocopy number
161: ,p_name in varchar2 default hr_api.g_varchar2
162: ,p_account_number in varchar2 default hr_api.g_varchar2
163: ,p_location_id in number default hr_api.g_number
164: ,p_comments in varchar2 default hr_api.g_varchar2
165: ) is
166: --
167: -- Declare cursors and local variables
168: --
215: ,p_location_id => p_location_id
216: ,p_comments => p_comments
217: );
218: exception
219: when hr_api.cannot_find_prog_unit then
220: hr_api.cannot_find_prog_unit_error
221: (p_module_name => 'update_wci_account'
222: ,p_hook_type => 'BP'
223: );
216: ,p_comments => p_comments
217: );
218: exception
219: when hr_api.cannot_find_prog_unit then
220: hr_api.cannot_find_prog_unit_error
221: (p_module_name => 'update_wci_account'
222: ,p_hook_type => 'BP'
223: );
224: end;
257: ,p_location_id => p_location_id
258: ,p_comments => p_comments
259: );
260: exception
261: when hr_api.cannot_find_prog_unit then
262: hr_api.cannot_find_prog_unit_error
263: (p_module_name => 'update_wci_account'
264: ,p_hook_type => 'AP'
265: );
258: ,p_comments => p_comments
259: );
260: exception
261: when hr_api.cannot_find_prog_unit then
262: hr_api.cannot_find_prog_unit_error
263: (p_module_name => 'update_wci_account'
264: ,p_hook_type => 'AP'
265: );
266: end;
268: --
269: -- When in validation only mode raise the Validate_Enabled exception
270: --
271: if p_validate then
272: raise hr_api.validate_enabled;
273: end if;
274: --
275: -- Set all output arguments
276: --
277: hr_utility.set_location(' Leaving:'||l_proc, 70);
278:
279: exception
280:
281: when hr_api.validate_enabled then
282: --
283: -- As the Validate_Enabled exception has been raised
284: -- we must rollback to the savepoint
285: --
352: ,p_business_group_id => l_business_group_id
353: ,p_object_version_number => p_object_version_number
354: );
355: exception
356: when hr_api.cannot_find_prog_unit then
357: hr_api.cannot_find_prog_unit_error
358: (p_module_name => 'delete_wci_account'
359: ,p_hook_type => 'BP'
360: );
353: ,p_object_version_number => p_object_version_number
354: );
355: exception
356: when hr_api.cannot_find_prog_unit then
357: hr_api.cannot_find_prog_unit_error
358: (p_module_name => 'delete_wci_account'
359: ,p_hook_type => 'BP'
360: );
361: end;
384: ,p_business_group_id => l_business_group_id
385: ,p_object_version_number => p_object_version_number
386: );
387: exception
388: when hr_api.cannot_find_prog_unit then
389: hr_api.cannot_find_prog_unit_error
390: (p_module_name => 'delete_wci_account'
391: ,p_hook_type => 'AP'
392: );
385: ,p_object_version_number => p_object_version_number
386: );
387: exception
388: when hr_api.cannot_find_prog_unit then
389: hr_api.cannot_find_prog_unit_error
390: (p_module_name => 'delete_wci_account'
391: ,p_hook_type => 'AP'
392: );
393: end;
395: --
396: -- When in validation only mode raise the Validate_Enabled exception
397: --
398: if p_validate then
399: raise hr_api.validate_enabled;
400: end if;
401: --
402: -- Set all output arguments
403: --
404: hr_utility.set_location(' Leaving:'||l_proc, 70);
405:
406: exception
407:
408: when hr_api.validate_enabled then
409: --
410: -- As the Validate_Enabled exception has been raised
411: -- we must rollback to the savepoint
412: --