71: savepoint create_scorecard_swi;
72: --
73: -- Initialise Multiple Message Detection
74: --
75: hr_multi_message.enable_message_list;
76: --
77: -- Remember IN OUT parameter IN values
78: --
79: --
141: -- messages and add them to Multiple Message List
142: --
143: if l_duplicate_name_warning then
144: fnd_message.set_name('PER', 'HR_50268_PMS_DUP_SC_FOR_ASG');
145: hr_multi_message.add
146: (p_message_type => hr_multi_message.g_warning_msg
147: );
148: end if;
149: --
142: --
143: if l_duplicate_name_warning then
144: fnd_message.set_name('PER', 'HR_50268_PMS_DUP_SC_FOR_ASG');
145: hr_multi_message.add
146: (p_message_type => hr_multi_message.g_warning_msg
147: );
148: end if;
149: --
150: -- Convert API non-warning boolean parameter values
153: -- Derive the API return status value based on whether
154: -- messages of any type exist in the Multiple Message List.
155: -- Also disable Multiple Message Detection.
156: --
157: p_return_status := hr_multi_message.get_return_status_disable;
158: hr_utility.set_location(' Leaving:' || l_proc,20);
159: --
160: exception
161: when hr_multi_message.error_message_exist then
157: p_return_status := hr_multi_message.get_return_status_disable;
158: hr_utility.set_location(' Leaving:' || l_proc,20);
159: --
160: exception
161: when hr_multi_message.error_message_exist then
162: --
163: -- Catch the Multiple Message List exception which
164: -- indicates API processing has been aborted because
165: -- at least one message exists in the list.
169: -- Reset IN OUT parameters and set OUT parameters
170: --
171: p_object_version_number := null;
172: --p_status_code := null;
173: p_return_status := hr_multi_message.get_return_status_disable;
174: hr_utility.set_location(' Leaving:' || l_proc, 30);
175: when others then
176: --
177: -- When Multiple Message Detection is enabled catch
180: -- Multiple Message List. Otherwise re-raise the
181: -- error.
182: --
183: rollback to create_scorecard_swi;
184: if hr_multi_message.unexpected_error_add(l_proc) then
185: hr_utility.set_location(' Leaving:' || l_proc,40);
186: raise;
187: end if;
188: --
189: -- Reset IN OUT and set OUT parameters
190: --
191: p_object_version_number := null;
192: --p_status_code := null;
193: p_return_status := hr_multi_message.get_return_status_disable;
194: hr_utility.set_location(' Leaving:' || l_proc,50);
195: end create_scorecard;
196: -- ----------------------------------------------------------------------------
197: -- |---------------------------< delete_scorecard >---------------------------|
219: savepoint delete_scorecard_swi;
220: --
221: -- Initialise Multiple Message Detection
222: --
223: hr_multi_message.enable_message_list;
224: --
225: -- Remember IN OUT parameter IN values
226: --
227: --
247: -- messages and add them to Multiple Message List
248: --
249: if l_created_by_plan_warning then
250: fnd_message.set_name('PER', 'HR_50272_PMS_CREATOR_TYPE_WARN');
251: hr_multi_message.add
252: (p_message_type => hr_multi_message.g_warning_msg
253: );
254: end if; --
255: -- Convert API non-warning boolean parameter values
248: --
249: if l_created_by_plan_warning then
250: fnd_message.set_name('PER', 'HR_50272_PMS_CREATOR_TYPE_WARN');
251: hr_multi_message.add
252: (p_message_type => hr_multi_message.g_warning_msg
253: );
254: end if; --
255: -- Convert API non-warning boolean parameter values
256: --
258: -- Derive the API return status value based on whether
259: -- messages of any type exist in the Multiple Message List.
260: -- Also disable Multiple Message Detection.
261: --
262: p_return_status := hr_multi_message.get_return_status_disable;
263: hr_utility.set_location(' Leaving:' || l_proc,20);
264: --
265: exception
266: when hr_multi_message.error_message_exist then
262: p_return_status := hr_multi_message.get_return_status_disable;
263: hr_utility.set_location(' Leaving:' || l_proc,20);
264: --
265: exception
266: when hr_multi_message.error_message_exist then
267: --
268: -- Catch the Multiple Message List exception which
269: -- indicates API processing has been aborted because
270: -- at least one message exists in the list.
272: rollback to delete_scorecard_swi;
273: --
274: -- Reset IN OUT parameters and set OUT parameters
275: --
276: p_return_status := hr_multi_message.get_return_status_disable;
277: hr_utility.set_location(' Leaving:' || l_proc, 30);
278: when others then
279: --
280: -- When Multiple Message Detection is enabled catch
283: -- Multiple Message List. Otherwise re-raise the
284: -- error.
285: --
286: rollback to delete_scorecard_swi;
287: if hr_multi_message.unexpected_error_add(l_proc) then
288: hr_utility.set_location(' Leaving:' || l_proc,40);
289: raise;
290: end if;
291: --
290: end if;
291: --
292: -- Reset IN OUT and set OUT parameters
293: --
294: p_return_status := hr_multi_message.get_return_status_disable;
295: hr_utility.set_location(' Leaving:' || l_proc,50);
296: end delete_scorecard;
297: -- ----------------------------------------------------------------------------
298: -- |---------------------------< update_scorecard >---------------------------|
358: savepoint update_scorecard_swi;
359: --
360: -- Initialise Multiple Message Detection
361: --
362: hr_multi_message.enable_message_list;
363: --
364: -- Remember IN OUT parameter IN values
365: --
366: l_object_version_number := p_object_version_number;
424: -- messages and add them to Multiple Message List
425: --
426: if l_duplicate_name_warning then
427: fnd_message.set_name('PER', 'HR_50265_PMS_DUP_SCORECARD');
428: hr_multi_message.add
429: (p_message_type => hr_multi_message.g_warning_msg
430: );
431: end if; --
432: -- Convert API non-warning boolean parameter values
425: --
426: if l_duplicate_name_warning then
427: fnd_message.set_name('PER', 'HR_50265_PMS_DUP_SCORECARD');
428: hr_multi_message.add
429: (p_message_type => hr_multi_message.g_warning_msg
430: );
431: end if; --
432: -- Convert API non-warning boolean parameter values
433: --
435: -- Derive the API return status value based on whether
436: -- messages of any type exist in the Multiple Message List.
437: -- Also disable Multiple Message Detection.
438: --
439: p_return_status := hr_multi_message.get_return_status_disable;
440: hr_utility.set_location(' Leaving:' || l_proc,20);
441: --
442: exception
443: when hr_multi_message.error_message_exist then
439: p_return_status := hr_multi_message.get_return_status_disable;
440: hr_utility.set_location(' Leaving:' || l_proc,20);
441: --
442: exception
443: when hr_multi_message.error_message_exist then
444: --
445: -- Catch the Multiple Message List exception which
446: -- indicates API processing has been aborted because
447: -- at least one message exists in the list.
450: --
451: -- Reset IN OUT parameters and set OUT parameters
452: --
453: p_object_version_number := l_object_version_number;
454: p_return_status := hr_multi_message.get_return_status_disable;
455: hr_utility.set_location(' Leaving:' || l_proc, 30);
456: when others then
457: --
458: -- When Multiple Message Detection is enabled catch
461: -- Multiple Message List. Otherwise re-raise the
462: -- error.
463: --
464: rollback to update_scorecard_swi;
465: if hr_multi_message.unexpected_error_add(l_proc) then
466: hr_utility.set_location(' Leaving:' || l_proc,40);
467: raise;
468: end if;
469: --
469: --
470: -- Reset IN OUT and set OUT parameters
471: --
472: p_object_version_number := l_object_version_number;
473: p_return_status := hr_multi_message.get_return_status_disable;
474: hr_utility.set_location(' Leaving:' || l_proc,50);
475: end update_scorecard;
476: -- ----------------------------------------------------------------------------
477: -- |------------------------< update_scorecard_status >-----------------------|
501: savepoint update_scorecard_status_swi;
502: --
503: -- Initialise Multiple Message Detection
504: --
505: hr_multi_message.enable_message_list;
506: --
507: -- Remember IN OUT parameter IN values
508: --
509: l_object_version_number := p_object_version_number;
537: -- Derive the API return status value based on whether
538: -- messages of any type exist in the Multiple Message List.
539: -- Also disable Multiple Message Detection.
540: --
541: p_return_status := hr_multi_message.get_return_status_disable;
542: hr_utility.set_location(' Leaving:' || l_proc,20);
543: --
544: exception
545: when hr_multi_message.error_message_exist then
541: p_return_status := hr_multi_message.get_return_status_disable;
542: hr_utility.set_location(' Leaving:' || l_proc,20);
543: --
544: exception
545: when hr_multi_message.error_message_exist then
546: --
547: -- Catch the Multiple Message List exception which
548: -- indicates API processing has been aborted because
549: -- at least one message exists in the list.
552: --
553: -- Reset IN OUT parameters and set OUT parameters
554: --
555: p_object_version_number := l_object_version_number;
556: p_return_status := hr_multi_message.get_return_status_disable;
557: hr_utility.set_location(' Leaving:' || l_proc, 30);
558: when others then
559: --
560: -- When Multiple Message Detection is enabled catch
563: -- Multiple Message List. Otherwise re-raise the
564: -- error.
565: --
566: rollback to update_scorecard_status_swi;
567: if hr_multi_message.unexpected_error_add(l_proc) then
568: hr_utility.set_location(' Leaving:' || l_proc,40);
569: raise;
570: end if;
571: --
571: --
572: -- Reset IN OUT and set OUT parameters
573: --
574: p_object_version_number := l_object_version_number;
575: p_return_status := hr_multi_message.get_return_status_disable;
576: hr_utility.set_location(' Leaving:' || l_proc,50);
577: end update_scorecard_status;
578: end hr_personal_scorecard_swi;