37: l_grade_rule_id number;
38: l_grade_rule_id_temp number;
39: l_proc varchar2(72) := g_package ||'create_assignment_rate_value';
40: Begin
41: hr_utility.set_location(' Entering:' || l_proc,10);
42: --
43: -- Issue a savepoint
44: --
45: l_grade_rule_id_temp := p_grade_rule_id;
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
90: --
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
107: -- any Application specific or other unexpected
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: --
120: -- Reset IN OUT and set OUT parameters
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 >--------------------------|
131: -- ----------------------------------------------------------------------------
157: -- Other variables
158: l_grade_rule_id number;
159: l_proc varchar2(72) := g_package ||'create_rate_value';
160: Begin
161: hr_utility.set_location(' Entering:' || l_proc,10);
162: --
163: -- Issue a savepoint
164: --
165: savepoint create_rate_value_swi;
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
223: --
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
240: -- any Application specific or other unexpected
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: --
251: -- Reset IN OUT and set OUT parameters
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: --
261: -- ----------------------------------------------------------------------------
280: --
281: -- Other variables
282: l_proc varchar2(72) := g_package ||'update_assignment_rate_value';
283: Begin
284: hr_utility.set_location(' Entering:' || l_proc,10);
285: --
286: -- Issue a savepoint
287: --
288: savepoint update_assignment_rate_value;
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
329: --
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
346: -- any Application specific or other unexpected
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: --
357: -- Reset IN OUT and set OUT parameters
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 >--------------------------|
367: -- ----------------------------------------------------------------------------
390: --
391: -- Other variables
392: l_proc varchar2(72) := g_package ||'update_rate_value';
393: Begin
394: hr_utility.set_location(' Entering:' || l_proc,10);
395: --
396: -- Issue a savepoint
397: --
398: savepoint update_rate_value_swi;
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
451: --
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
468: -- any Application specific or other unexpected
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: --
479: -- Reset IN OUT and set OUT parameters
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 >--------------------------|
489: -- ----------------------------------------------------------------------------
506: --
507: -- Other variables
508: l_proc varchar2(72) := g_package ||'delete_rate_value';
509: Begin
510: hr_utility.set_location(' Entering:' || l_proc,10);
511: --
512: -- Issue a savepoint
513: --
514: savepoint delete_rate_value_swi;
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
556: --
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
573: -- any Application specific or other unexpected
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: --
584: -- Reset IN OUT and set OUT parameters
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 >--------------------------|
594: -- ----------------------------------------------------------------------------
611: --
612: -- Other variables
613: l_proc varchar2(72) := g_package ||'delete_rate_value';
614: Begin
615: hr_utility.set_location(' Entering:' || l_proc,10);
616: --
617: -- Issue a savepoint
618: --
619: savepoint delete_rate_value_swi;
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
666: --
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
683: -- any Application specific or other unexpected
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: --
694: -- Reset IN OUT and set OUT parameters
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 >---------------------------------|
704: -- ----------------------------------------------------------------------------
718: --
719: -- Other variables
720: l_proc varchar2(72) := g_package ||'lck';
721: Begin
722: hr_utility.set_location(' Entering:' || l_proc,10);
723: --
724: -- Issue a savepoint
725: --
726: savepoint lck_swi;
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
768: --
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
784: -- any Application specific or other unexpected
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 > ------------------------------
804: -- ---------------------------------------------------------------------------
895: ,p_return_status => l_return_status
896: );
897: exception
898: when not_a_valid_po_txn then
899: hr_utility.set_message(800, 'HR_NOT_VALID_PO_TXN');
900: hr_utility.raise_error;
901: when others then
902: raise;
903: end process_api;
896: );
897: exception
898: when not_a_valid_po_txn then
899: hr_utility.set_message(800, 'HR_NOT_VALID_PO_TXN');
900: hr_utility.raise_error;
901: when others then
902: raise;
903: end process_api;
904:
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
1521: (p_associated_column1 => 'PAY_GRADE_RULES_F.EFFECTIVE_END_DATE');
1522: end if;
1523: hr_multi_message.end_validation_set;