77: -- Other variables
78: l_task_in_checklist_id number;
79: l_proc varchar2(72) := g_package ||'create_task_in_ckl';
80: Begin
81: hr_utility.set_location(' Entering:' || l_proc,10);
82: --
83: -- Issue a savepoint
84: --
85: savepoint create_task_in_ckl_swi;
98: (p_constant_value => p_validate);
99: --
100: -- Register Surrogate ID or user key values
101: --
102: hr_utility.set_location(' Entering:' || l_proc,11);
103: per_ctk_ins.set_base_key_value
104: (p_task_in_checklist_id => p_task_in_checklist_id
105: );
106: hr_utility.set_location(' Entering:' || l_proc,12);
102: hr_utility.set_location(' Entering:' || l_proc,11);
103: per_ctk_ins.set_base_key_value
104: (p_task_in_checklist_id => p_task_in_checklist_id
105: );
106: hr_utility.set_location(' Entering:' || l_proc,12);
107: --
108: -- Call API
109: --
110: per_tasks_in_checklist_api.create_task_in_ckl
165: ,p_information20 => p_information20
166: ,p_task_in_checklist_id => l_task_in_checklist_id
167: ,p_object_version_number => p_object_version_number
168: );
169: hr_utility.set_location(' Entering:' || l_proc,15);
170: --
171: -- Convert API warning boolean parameter values to specific
172: -- messages and add them to Multiple Message List
173: --
179: -- messages of any type exist in the Multiple Message List.
180: -- Also disable Multiple Message Detection.
181: --
182: p_return_status := hr_multi_message.get_return_status_disable;
183: hr_utility.set_location(' Leaving:' || l_proc,20);
184: --
185: exception
186: when hr_multi_message.error_message_exist then
187: --
194: -- Reset IN OUT parameters and set OUT parameters
195: --
196: p_object_version_number := null;
197: p_return_status := hr_multi_message.get_return_status_disable;
198: hr_utility.set_location(' Leaving:' || l_proc, 30);
199: when others then
200: --
201: -- When Multiple Message Detection is enabled catch
202: -- any Application specific or other unexpected
205: -- error.
206: --
207: rollback to create_task_in_ckl_swi;
208: if hr_multi_message.unexpected_error_add(l_proc) then
209: hr_utility.set_location(' Leaving:' || l_proc,40);
210: raise;
211: end if;
212: --
213: -- Reset IN OUT and set OUT parameters
213: -- Reset IN OUT and set OUT parameters
214: --
215: p_object_version_number := null;
216: p_return_status := hr_multi_message.get_return_status_disable;
217: hr_utility.set_location(' Leaving:' || l_proc,50);
218: end create_task_in_ckl;
219: -- ----------------------------------------------------------------------------
220: -- |--------------------------< update_task_in_ckl >--------------------------|
221: -- ----------------------------------------------------------------------------
288: --
289: -- Other variables
290: l_proc varchar2(72) := g_package ||'update_task_in_ckl';
291: Begin
292: hr_utility.set_location(' Entering:' || l_proc,10);
293: --
294: -- Issue a savepoint
295: --
296: savepoint update_task_in_ckl_swi;
385: -- messages of any type exist in the Multiple Message List.
386: -- Also disable Multiple Message Detection.
387: --
388: p_return_status := hr_multi_message.get_return_status_disable;
389: hr_utility.set_location(' Leaving:' || l_proc,20);
390: --
391: exception
392: when hr_multi_message.error_message_exist then
393: --
400: -- Reset IN OUT parameters and set OUT parameters
401: --
402: p_object_version_number := l_object_version_number;
403: p_return_status := hr_multi_message.get_return_status_disable;
404: hr_utility.set_location(' Leaving:' || l_proc, 30);
405: when others then
406: --
407: -- When Multiple Message Detection is enabled catch
408: -- any Application specific or other unexpected
411: -- error.
412: --
413: rollback to update_task_in_ckl_swi;
414: if hr_multi_message.unexpected_error_add(l_proc) then
415: hr_utility.set_location(' Leaving:' || l_proc,40);
416: raise;
417: end if;
418: --
419: -- Reset IN OUT and set OUT parameters
419: -- Reset IN OUT and set OUT parameters
420: --
421: p_object_version_number := l_object_version_number;
422: p_return_status := hr_multi_message.get_return_status_disable;
423: hr_utility.set_location(' Leaving:' || l_proc,50);
424: end update_task_in_ckl;
425: -- ----------------------------------------------------------------------------
426: -- |--------------------------< delete_task_in_ckl >--------------------------|
427: -- ----------------------------------------------------------------------------
439: --
440: -- Other variables
441: l_proc varchar2(72) := g_package ||'delete_task_in_ckl';
442: Begin
443: hr_utility.set_location(' Entering:' || l_proc,10);
444: --
445: -- Issue a savepoint
446: --
447: savepoint delete_task_in_ckl_swi;
481: -- messages of any type exist in the Multiple Message List.
482: -- Also disable Multiple Message Detection.
483: --
484: p_return_status := hr_multi_message.get_return_status_disable;
485: hr_utility.set_location(' Leaving:' || l_proc,20);
486: --
487: exception
488: when hr_multi_message.error_message_exist then
489: --
495: --
496: -- Reset IN OUT parameters and set OUT parameters
497: --
498: p_return_status := hr_multi_message.get_return_status_disable;
499: hr_utility.set_location(' Leaving:' || l_proc, 30);
500: when others then
501: --
502: -- When Multiple Message Detection is enabled catch
503: -- any Application specific or other unexpected
506: -- error.
507: --
508: rollback to delete_task_in_ckl_swi;
509: if hr_multi_message.unexpected_error_add(l_proc) then
510: hr_utility.set_location(' Leaving:' || l_proc,40);
511: raise;
512: end if;
513: --
514: -- Reset IN OUT and set OUT parameters
513: --
514: -- Reset IN OUT and set OUT parameters
515: --
516: p_return_status := hr_multi_message.get_return_status_disable;
517: hr_utility.set_location(' Leaving:' || l_proc,50);
518: end delete_task_in_ckl;
519: end per_tasks_in_checklist_swi;