46: savepoint create_assignment_rate_value;
47: --
48: -- Initialise Multiple Message Detection
49: --
50: hr_multi_message.enable_message_list;
51: --
52: -- Remember IN OUT parameter IN values
53: --
54: --
81: -- Derive the API return status value based on whether
82: -- messages of any type exist in the Multiple Message List.
83: -- Also disable Multiple Message Detection.
84: --
85: p_return_status := hr_multi_message.get_return_status_disable;
86: hr_utility.set_location(' Leaving:' || l_proc,20);
87: --
88: exception
89: when hr_multi_message.error_message_exist then
85: p_return_status := hr_multi_message.get_return_status_disable;
86: hr_utility.set_location(' Leaving:' || l_proc,20);
87: --
88: exception
89: when hr_multi_message.error_message_exist then
90: --
91: -- Catch the Multiple Message List exception which
92: -- indicates API processing has been aborted because
93: -- at least one message exists in the list.
98: --
99: p_object_version_number := null;
100: p_effective_start_date := null;
101: p_effective_end_date := null;
102: p_return_status := hr_multi_message.get_return_status_disable;
103: hr_utility.set_location(' Leaving:' || l_proc, 30);
104: when others then
105: --
106: -- When Multiple Message Detection is enabled catch
111: --
112: rollback to create_assignment_rate_value;
113:
114:
115: if hr_multi_message.unexpected_error_add(l_proc) then
116: hr_utility.set_location(' Leaving:' || l_proc,40);
117: raise;
118: end if;
119: --
122: p_grade_rule_id := l_grade_rule_id_temp;
123: p_object_version_number := null;
124: p_effective_start_date := null;
125: p_effective_end_date := null;
126: p_return_status := hr_multi_message.get_return_status_disable;
127: hr_utility.set_location(' Leaving:' || l_proc,50);
128: end create_assignment_rate_value;
129: -- ----------------------------------------------------------------------------
130: -- |---------------------------< create_rate_value >--------------------------|
165: savepoint create_rate_value_swi;
166: --
167: -- Initialise Multiple Message Detection
168: --
169: hr_multi_message.enable_message_list;
170: --
171: -- Remember IN OUT parameter IN values
172: --
173: --
214: -- Derive the API return status value based on whether
215: -- messages of any type exist in the Multiple Message List.
216: -- Also disable Multiple Message Detection.
217: --
218: p_return_status := hr_multi_message.get_return_status_disable;
219: hr_utility.set_location(' Leaving:' || l_proc,20);
220: --
221: exception
222: when hr_multi_message.error_message_exist then
218: p_return_status := hr_multi_message.get_return_status_disable;
219: hr_utility.set_location(' Leaving:' || l_proc,20);
220: --
221: exception
222: when hr_multi_message.error_message_exist then
223: --
224: -- Catch the Multiple Message List exception which
225: -- indicates API processing has been aborted because
226: -- at least one message exists in the list.
231: --
232: p_object_version_number := null;
233: p_effective_start_date := null;
234: p_effective_end_date := null;
235: p_return_status := hr_multi_message.get_return_status_disable;
236: hr_utility.set_location(' Leaving:' || l_proc, 30);
237: when others then
238: --
239: -- When Multiple Message Detection is enabled catch
242: -- Multiple Message List. Otherwise re-raise the
243: -- error.
244: --
245: rollback to create_rate_value_swi;
246: if hr_multi_message.unexpected_error_add(l_proc) then
247: hr_utility.set_location(' Leaving:' || l_proc,40);
248: raise;
249: end if;
250: --
252: --
253: p_object_version_number := null;
254: p_effective_start_date := null;
255: p_effective_end_date := null;
256: p_return_status := hr_multi_message.get_return_status_disable;
257: hr_utility.set_location(' Leaving:' || l_proc,50);
258: end create_rate_value;
259: --
260: --
288: savepoint update_assignment_rate_value;
289: --
290: -- Initialise Multiple Message Detection
291: --
292: hr_multi_message.enable_message_list;
293: --
294: -- Remember IN OUT parameter IN values
295: --
296: l_object_version_number := p_object_version_number;
320: -- Derive the API return status value based on whether
321: -- messages of any type exist in the Multiple Message List.
322: -- Also disable Multiple Message Detection.
323: --
324: p_return_status := hr_multi_message.get_return_status_disable;
325: hr_utility.set_location(' Leaving:' || l_proc,20);
326: --
327: exception
328: when hr_multi_message.error_message_exist then
324: p_return_status := hr_multi_message.get_return_status_disable;
325: hr_utility.set_location(' Leaving:' || l_proc,20);
326: --
327: exception
328: when hr_multi_message.error_message_exist then
329: --
330: -- Catch the Multiple Message List exception which
331: -- indicates API processing has been aborted because
332: -- at least one message exists in the list.
337: --
338: p_object_version_number := l_object_version_number;
339: p_effective_start_date := null;
340: p_effective_end_date := null;
341: p_return_status := hr_multi_message.get_return_status_disable;
342: hr_utility.set_location(' Leaving:' || l_proc, 30);
343: when others then
344: --
345: -- When Multiple Message Detection is enabled catch
348: -- Multiple Message List. Otherwise re-raise the
349: -- error.
350: --
351: rollback to update_assignment_rate_value;
352: if hr_multi_message.unexpected_error_add(l_proc) then
353: hr_utility.set_location(' Leaving:' || l_proc,40);
354: raise;
355: end if;
356: --
358: --
359: p_object_version_number := l_object_version_number;
360: p_effective_start_date := null;
361: p_effective_end_date := null;
362: p_return_status := hr_multi_message.get_return_status_disable;
363: hr_utility.set_location(' Leaving:' || l_proc,50);
364: end update_assignment_rate_value;
365: -- ----------------------------------------------------------------------------
366: -- |---------------------------< update_rate_value >--------------------------|
398: savepoint update_rate_value_swi;
399: --
400: -- Initialise Multiple Message Detection
401: --
402: hr_multi_message.enable_message_list;
403: --
404: -- Remember IN OUT parameter IN values
405: --
406: l_object_version_number := p_object_version_number;
442: -- Derive the API return status value based on whether
443: -- messages of any type exist in the Multiple Message List.
444: -- Also disable Multiple Message Detection.
445: --
446: p_return_status := hr_multi_message.get_return_status_disable;
447: hr_utility.set_location(' Leaving:' || l_proc,20);
448: --
449: exception
450: when hr_multi_message.error_message_exist then
446: p_return_status := hr_multi_message.get_return_status_disable;
447: hr_utility.set_location(' Leaving:' || l_proc,20);
448: --
449: exception
450: when hr_multi_message.error_message_exist then
451: --
452: -- Catch the Multiple Message List exception which
453: -- indicates API processing has been aborted because
454: -- at least one message exists in the list.
459: --
460: p_object_version_number := l_object_version_number;
461: p_effective_start_date := null;
462: p_effective_end_date := null;
463: p_return_status := hr_multi_message.get_return_status_disable;
464: hr_utility.set_location(' Leaving:' || l_proc, 30);
465: when others then
466: --
467: -- When Multiple Message Detection is enabled catch
470: -- Multiple Message List. Otherwise re-raise the
471: -- error.
472: --
473: rollback to update_rate_value_swi;
474: if hr_multi_message.unexpected_error_add(l_proc) then
475: hr_utility.set_location(' Leaving:' || l_proc,40);
476: raise;
477: end if;
478: --
480: --
481: p_object_version_number := l_object_version_number;
482: p_effective_start_date := null;
483: p_effective_end_date := null;
484: p_return_status := hr_multi_message.get_return_status_disable;
485: hr_utility.set_location(' Leaving:' || l_proc,50);
486: end update_rate_value;
487: -- ----------------------------------------------------------------------------
488: -- |---------------------------< delete_rate_value >--------------------------|
514: savepoint delete_rate_value_swi;
515: --
516: -- Initialise Multiple Message Detection
517: --
518: hr_multi_message.enable_message_list;
519: --
520: -- Remember IN OUT parameter IN values
521: --
522: l_object_version_number := p_object_version_number;
547: -- Derive the API return status value based on whether
548: -- messages of any type exist in the Multiple Message List.
549: -- Also disable Multiple Message Detection.
550: --
551: p_return_status := hr_multi_message.get_return_status_disable;
552: hr_utility.set_location(' Leaving:' || l_proc,20);
553: --
554: exception
555: when hr_multi_message.error_message_exist then
551: p_return_status := hr_multi_message.get_return_status_disable;
552: hr_utility.set_location(' Leaving:' || l_proc,20);
553: --
554: exception
555: when hr_multi_message.error_message_exist then
556: --
557: -- Catch the Multiple Message List exception which
558: -- indicates API processing has been aborted because
559: -- at least one message exists in the list.
564: --
565: p_object_version_number := l_object_version_number;
566: p_effective_start_date := null;
567: p_effective_end_date := null;
568: p_return_status := hr_multi_message.get_return_status_disable;
569: hr_utility.set_location(' Leaving:' || l_proc, 30);
570: when others then
571: --
572: -- When Multiple Message Detection is enabled catch
575: -- Multiple Message List. Otherwise re-raise the
576: -- error.
577: --
578: rollback to delete_rate_value_swi;
579: if hr_multi_message.unexpected_error_add(l_proc) then
580: hr_utility.set_location(' Leaving:' || l_proc,40);
581: raise;
582: end if;
583: --
585: --
586: p_object_version_number := l_object_version_number;
587: p_effective_start_date := null;
588: p_effective_end_date := null;
589: p_return_status := hr_multi_message.get_return_status_disable;
590: hr_utility.set_location(' Leaving:' || l_proc,50);
591: end delete_rate_value;
592: -- ----------------------------------------------------------------------------
593: -- |---------------------------< delete_rate_value >--------------------------|
619: savepoint delete_rate_value_swi;
620: --
621: -- Initialise Multiple Message Detection
622: --
623: hr_multi_message.enable_message_list;
624: --
625: -- Remember IN OUT parameter IN values
626: --
627: l_object_version_number := p_object_version_number;
657: -- Derive the API return status value based on whether
658: -- messages of any type exist in the Multiple Message List.
659: -- Also disable Multiple Message Detection.
660: --
661: p_return_status := hr_multi_message.get_return_status_disable;
662: hr_utility.set_location(' Leaving:' || l_proc,20);
663: --
664: exception
665: when hr_multi_message.error_message_exist then
661: p_return_status := hr_multi_message.get_return_status_disable;
662: hr_utility.set_location(' Leaving:' || l_proc,20);
663: --
664: exception
665: when hr_multi_message.error_message_exist then
666: --
667: -- Catch the Multiple Message List exception which
668: -- indicates API processing has been aborted because
669: -- at least one message exists in the list.
674: --
675: p_object_version_number := l_object_version_number;
676: p_effective_start_date := null;
677: p_effective_end_date := null;
678: p_return_status := hr_multi_message.get_return_status_disable;
679: hr_utility.set_location(' Leaving:' || l_proc, 30);
680: when others then
681: --
682: -- When Multiple Message Detection is enabled catch
685: -- Multiple Message List. Otherwise re-raise the
686: -- error.
687: --
688: rollback to delete_rate_value_swi;
689: if hr_multi_message.unexpected_error_add(l_proc) then
690: hr_utility.set_location(' Leaving:' || l_proc,40);
691: raise;
692: end if;
693: --
695: --
696: p_object_version_number := l_object_version_number;
697: p_effective_start_date := null;
698: p_effective_end_date := null;
699: p_return_status := hr_multi_message.get_return_status_disable;
700: hr_utility.set_location(' Leaving:' || l_proc,50);
701: end delete_rate_value;
702: -- ----------------------------------------------------------------------------
703: -- |----------------------------------< lck >---------------------------------|
726: savepoint lck_swi;
727: --
728: -- Initialise Multiple Message Detection
729: --
730: hr_multi_message.enable_message_list;
731: --
732: -- Remember IN OUT parameter IN values
733: --
734: --
759: -- Derive the API return status value based on whether
760: -- messages of any type exist in the Multiple Message List.
761: -- Also disable Multiple Message Detection.
762: --
763: p_return_status := hr_multi_message.get_return_status_disable;
764: hr_utility.set_location(' Leaving:' || l_proc,20);
765: --
766: exception
767: when hr_multi_message.error_message_exist then
763: p_return_status := hr_multi_message.get_return_status_disable;
764: hr_utility.set_location(' Leaving:' || l_proc,20);
765: --
766: exception
767: when hr_multi_message.error_message_exist then
768: --
769: -- Catch the Multiple Message List exception which
770: -- indicates API processing has been aborted because
771: -- at least one message exists in the list.
775: -- Reset IN OUT parameters and set OUT parameters
776: --
777: p_validation_start_date := null;
778: p_validation_end_date := null;
779: p_return_status := hr_multi_message.get_return_status_disable;
780: hr_utility.set_location(' Leaving:' || l_proc, 30);
781: when others then
782: --
783: -- When Multiple Message Detection is enabled catch
786: -- Multiple Message List. Otherwise re-raise the
787: -- error.
788: --
789: rollback to lck_swi;
790: if hr_multi_message.unexpected_error_add(l_proc) then
791: hr_utility.set_location(' Leaving:' || l_proc,40);
792: raise;
793: end if;
794: --
795: -- Reset IN OUT and set OUT parameters
796: --
797: p_validation_start_date := null;
798: p_validation_end_date := null;
799: p_return_status := hr_multi_message.get_return_status_disable;
800: hr_utility.set_location(' Leaving:' || l_proc,50);
801: end lck;
802: -- ---------------------------------------------------------------------------
803: -- ---------------------------- < process_api > ------------------------------
1512: if (p_record_status = g_update_delete or
1513: p_record_status = g_insert_delete or
1514: p_record_status = g_delete_only)
1515: then
1516: hr_multi_message.enable_message_list;
1517: if trunc(p_asg_rate_rec.effective_start_date) > trunc(nvl(p_asg_rate_rec.effective_end_date, hr_api.g_eot))
1518: then
1519: hr_utility.set_message(800, 'HR_ASG_RATE_INV_END_DATE');
1520: l_temp := hr_multi_message.exception_add
1516: hr_multi_message.enable_message_list;
1517: if trunc(p_asg_rate_rec.effective_start_date) > trunc(nvl(p_asg_rate_rec.effective_end_date, hr_api.g_eot))
1518: then
1519: hr_utility.set_message(800, 'HR_ASG_RATE_INV_END_DATE');
1520: l_temp := hr_multi_message.exception_add
1521: (p_associated_column1 => 'PAY_GRADE_RULES_F.EFFECTIVE_END_DATE');
1522: end if;
1523: hr_multi_message.end_validation_set;
1524: end if;
1519: hr_utility.set_message(800, 'HR_ASG_RATE_INV_END_DATE');
1520: l_temp := hr_multi_message.exception_add
1521: (p_associated_column1 => 'PAY_GRADE_RULES_F.EFFECTIVE_END_DATE');
1522: end if;
1523: hr_multi_message.end_validation_set;
1524: end if;
1525:
1526: if l_grade_rule_id is not null
1527: then
1648: end if;
1649:
1650: p_return_status := l_return_status;
1651: exception
1652: when hr_multi_message.error_message_exist then
1653: p_return_status := hr_multi_message.get_return_status_disable;
1654: when others then
1655: if (p_record_status = g_update_delete or
1656: p_record_status = g_insert_delete)
1649:
1650: p_return_status := l_return_status;
1651: exception
1652: when hr_multi_message.error_message_exist then
1653: p_return_status := hr_multi_message.get_return_status_disable;
1654: when others then
1655: if (p_record_status = g_update_delete or
1656: p_record_status = g_insert_delete)
1657: then