76: savepoint create_scorecard_swi;
77: --
78: -- Initialise Multiple Message Detection
79: --
80: hr_multi_message.enable_message_list;
81: --
82: -- Remember IN OUT parameter IN values
83: --
84: --
151: -- messages and add them to Multiple Message List
152: --
153: if l_duplicate_name_warning then
154: fnd_message.set_name('PER', 'HR_50268_PMS_DUP_SC_FOR_ASG');
155: hr_multi_message.add
156: (p_message_type => hr_multi_message.g_warning_msg
157: );
158: end if;
159: --
152: --
153: if l_duplicate_name_warning then
154: fnd_message.set_name('PER', 'HR_50268_PMS_DUP_SC_FOR_ASG');
155: hr_multi_message.add
156: (p_message_type => hr_multi_message.g_warning_msg
157: );
158: end if;
159: --
160: -- Convert API non-warning boolean parameter values
163: -- Derive the API return status value based on whether
164: -- messages of any type exist in the Multiple Message List.
165: -- Also disable Multiple Message Detection.
166: --
167: p_return_status := hr_multi_message.get_return_status_disable;
168: hr_utility.set_location(' Leaving:' || l_proc,20);
169: --
170: exception
171: when hr_multi_message.error_message_exist then
167: p_return_status := hr_multi_message.get_return_status_disable;
168: hr_utility.set_location(' Leaving:' || l_proc,20);
169: --
170: exception
171: when hr_multi_message.error_message_exist then
172: --
173: -- Catch the Multiple Message List exception which
174: -- indicates API processing has been aborted because
175: -- at least one message exists in the list.
179: -- Reset IN OUT parameters and set OUT parameters
180: --
181: p_object_version_number := null;
182: --p_status_code := null;
183: p_return_status := hr_multi_message.get_return_status_disable;
184: hr_utility.set_location(' Leaving:' || l_proc, 30);
185: when others then
186: --
187: -- When Multiple Message Detection is enabled catch
190: -- Multiple Message List. Otherwise re-raise the
191: -- error.
192: --
193: rollback to create_scorecard_swi;
194: if hr_multi_message.unexpected_error_add(l_proc) then
195: hr_utility.set_location(' Leaving:' || l_proc,40);
196: raise;
197: end if;
198: --
199: -- Reset IN OUT and set OUT parameters
200: --
201: p_object_version_number := null;
202: --p_status_code := null;
203: p_return_status := hr_multi_message.get_return_status_disable;
204: hr_utility.set_location(' Leaving:' || l_proc,50);
205: end create_scorecard;
206: -- ----------------------------------------------------------------------------
207: -- |---------------------------< delete_scorecard >---------------------------|
229: savepoint delete_scorecard_swi;
230: --
231: -- Initialise Multiple Message Detection
232: --
233: hr_multi_message.enable_message_list;
234: --
235: -- Remember IN OUT parameter IN values
236: --
237: --
257: -- messages and add them to Multiple Message List
258: --
259: if l_created_by_plan_warning then
260: fnd_message.set_name('PER', 'HR_50272_PMS_CREATOR_TYPE_WARN');
261: hr_multi_message.add
262: (p_message_type => hr_multi_message.g_warning_msg
263: );
264: end if; --
265: -- Convert API non-warning boolean parameter values
258: --
259: if l_created_by_plan_warning then
260: fnd_message.set_name('PER', 'HR_50272_PMS_CREATOR_TYPE_WARN');
261: hr_multi_message.add
262: (p_message_type => hr_multi_message.g_warning_msg
263: );
264: end if; --
265: -- Convert API non-warning boolean parameter values
266: --
268: -- Derive the API return status value based on whether
269: -- messages of any type exist in the Multiple Message List.
270: -- Also disable Multiple Message Detection.
271: --
272: p_return_status := hr_multi_message.get_return_status_disable;
273: hr_utility.set_location(' Leaving:' || l_proc,20);
274: --
275: exception
276: when hr_multi_message.error_message_exist then
272: p_return_status := hr_multi_message.get_return_status_disable;
273: hr_utility.set_location(' Leaving:' || l_proc,20);
274: --
275: exception
276: when hr_multi_message.error_message_exist then
277: --
278: -- Catch the Multiple Message List exception which
279: -- indicates API processing has been aborted because
280: -- at least one message exists in the list.
282: rollback to delete_scorecard_swi;
283: --
284: -- Reset IN OUT parameters and set OUT parameters
285: --
286: p_return_status := hr_multi_message.get_return_status_disable;
287: hr_utility.set_location(' Leaving:' || l_proc, 30);
288: when others then
289: --
290: -- When Multiple Message Detection is enabled catch
293: -- Multiple Message List. Otherwise re-raise the
294: -- error.
295: --
296: rollback to delete_scorecard_swi;
297: if hr_multi_message.unexpected_error_add(l_proc) then
298: hr_utility.set_location(' Leaving:' || l_proc,40);
299: raise;
300: end if;
301: --
300: end if;
301: --
302: -- Reset IN OUT and set OUT parameters
303: --
304: p_return_status := hr_multi_message.get_return_status_disable;
305: hr_utility.set_location(' Leaving:' || l_proc,50);
306: end delete_scorecard;
307: -- ----------------------------------------------------------------------------
308: -- |---------------------------< update_scorecard >---------------------------|
373: savepoint update_scorecard_swi;
374: --
375: -- Initialise Multiple Message Detection
376: --
377: hr_multi_message.enable_message_list;
378: --
379: -- Remember IN OUT parameter IN values
380: --
381: l_object_version_number := p_object_version_number;
444: -- messages and add them to Multiple Message List
445: --
446: if l_duplicate_name_warning then
447: fnd_message.set_name('PER', 'HR_50265_PMS_DUP_SCORECARD');
448: hr_multi_message.add
449: (p_message_type => hr_multi_message.g_warning_msg
450: );
451: end if; --
452: -- Convert API non-warning boolean parameter values
445: --
446: if l_duplicate_name_warning then
447: fnd_message.set_name('PER', 'HR_50265_PMS_DUP_SCORECARD');
448: hr_multi_message.add
449: (p_message_type => hr_multi_message.g_warning_msg
450: );
451: end if; --
452: -- Convert API non-warning boolean parameter values
453: --
455: -- Derive the API return status value based on whether
456: -- messages of any type exist in the Multiple Message List.
457: -- Also disable Multiple Message Detection.
458: --
459: p_return_status := hr_multi_message.get_return_status_disable;
460: hr_utility.set_location(' Leaving:' || l_proc,20);
461: --
462: exception
463: when hr_multi_message.error_message_exist then
459: p_return_status := hr_multi_message.get_return_status_disable;
460: hr_utility.set_location(' Leaving:' || l_proc,20);
461: --
462: exception
463: when hr_multi_message.error_message_exist then
464: --
465: -- Catch the Multiple Message List exception which
466: -- indicates API processing has been aborted because
467: -- at least one message exists in the list.
470: --
471: -- Reset IN OUT parameters and set OUT parameters
472: --
473: p_object_version_number := l_object_version_number;
474: p_return_status := hr_multi_message.get_return_status_disable;
475: hr_utility.set_location(' Leaving:' || l_proc, 30);
476: when others then
477: --
478: -- When Multiple Message Detection is enabled catch
481: -- Multiple Message List. Otherwise re-raise the
482: -- error.
483: --
484: rollback to update_scorecard_swi;
485: if hr_multi_message.unexpected_error_add(l_proc) then
486: hr_utility.set_location(' Leaving:' || l_proc,40);
487: raise;
488: end if;
489: --
489: --
490: -- Reset IN OUT and set OUT parameters
491: --
492: p_object_version_number := l_object_version_number;
493: p_return_status := hr_multi_message.get_return_status_disable;
494: hr_utility.set_location(' Leaving:' || l_proc,50);
495: end update_scorecard;
496: -- ----------------------------------------------------------------------------
497: -- |------------------------< update_scorecard_status >-----------------------|
521: savepoint update_scorecard_status_swi;
522: --
523: -- Initialise Multiple Message Detection
524: --
525: hr_multi_message.enable_message_list;
526: --
527: -- Remember IN OUT parameter IN values
528: --
529: l_object_version_number := p_object_version_number;
557: -- Derive the API return status value based on whether
558: -- messages of any type exist in the Multiple Message List.
559: -- Also disable Multiple Message Detection.
560: --
561: p_return_status := hr_multi_message.get_return_status_disable;
562: hr_utility.set_location(' Leaving:' || l_proc,20);
563: --
564: exception
565: when hr_multi_message.error_message_exist then
561: p_return_status := hr_multi_message.get_return_status_disable;
562: hr_utility.set_location(' Leaving:' || l_proc,20);
563: --
564: exception
565: when hr_multi_message.error_message_exist then
566: --
567: -- Catch the Multiple Message List exception which
568: -- indicates API processing has been aborted because
569: -- at least one message exists in the list.
572: --
573: -- Reset IN OUT parameters and set OUT parameters
574: --
575: p_object_version_number := l_object_version_number;
576: p_return_status := hr_multi_message.get_return_status_disable;
577: hr_utility.set_location(' Leaving:' || l_proc, 30);
578: when others then
579: --
580: -- When Multiple Message Detection is enabled catch
583: -- Multiple Message List. Otherwise re-raise the
584: -- error.
585: --
586: rollback to update_scorecard_status_swi;
587: if hr_multi_message.unexpected_error_add(l_proc) then
588: hr_utility.set_location(' Leaving:' || l_proc,40);
589: raise;
590: end if;
591: --
591: --
592: -- Reset IN OUT and set OUT parameters
593: --
594: p_object_version_number := l_object_version_number;
595: p_return_status := hr_multi_message.get_return_status_disable;
596: hr_utility.set_location(' Leaving:' || l_proc,50);
597: end update_scorecard_status;
598: end hr_personal_scorecard_swi;