DBA Data[Home] [Help]

APPS.HR_RATE_VALUES_SWI dependencies on HR_UTILITY

Line 41: hr_utility.set_location(' Entering:' || l_proc,10);

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;

Line 86: hr_utility.set_location(' Leaving:' || l_proc,20);

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: --

Line 103: hr_utility.set_location(' Leaving:' || l_proc, 30);

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

Line 116: hr_utility.set_location(' Leaving:' || l_proc,40);

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

Line 127: hr_utility.set_location(' Leaving:' || l_proc,50);

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: -- ----------------------------------------------------------------------------

Line 161: hr_utility.set_location(' Entering:' || l_proc,10);

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;

Line 219: hr_utility.set_location(' Leaving:' || l_proc,20);

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: --

Line 236: hr_utility.set_location(' Leaving:' || l_proc, 30);

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

Line 247: hr_utility.set_location(' Leaving:' || l_proc,40);

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

Line 257: hr_utility.set_location(' Leaving:' || l_proc,50);

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: -- ----------------------------------------------------------------------------

Line 284: hr_utility.set_location(' Entering:' || l_proc,10);

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;

Line 325: hr_utility.set_location(' Leaving:' || l_proc,20);

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: --

Line 342: hr_utility.set_location(' Leaving:' || l_proc, 30);

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

Line 353: hr_utility.set_location(' Leaving:' || l_proc,40);

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

Line 363: hr_utility.set_location(' Leaving:' || l_proc,50);

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: -- ----------------------------------------------------------------------------

Line 394: hr_utility.set_location(' Entering:' || l_proc,10);

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;

Line 447: hr_utility.set_location(' Leaving:' || l_proc,20);

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: --

Line 464: hr_utility.set_location(' Leaving:' || l_proc, 30);

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

Line 475: hr_utility.set_location(' Leaving:' || l_proc,40);

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

Line 485: hr_utility.set_location(' Leaving:' || l_proc,50);

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: -- ----------------------------------------------------------------------------

Line 510: hr_utility.set_location(' Entering:' || l_proc,10);

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;

Line 552: hr_utility.set_location(' Leaving:' || l_proc,20);

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: --

Line 569: hr_utility.set_location(' Leaving:' || l_proc, 30);

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

Line 580: hr_utility.set_location(' Leaving:' || l_proc,40);

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

Line 590: hr_utility.set_location(' Leaving:' || l_proc,50);

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: -- ----------------------------------------------------------------------------

Line 615: hr_utility.set_location(' Entering:' || l_proc,10);

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;

Line 662: hr_utility.set_location(' Leaving:' || l_proc,20);

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: --

Line 679: hr_utility.set_location(' Leaving:' || l_proc, 30);

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

Line 690: hr_utility.set_location(' Leaving:' || l_proc,40);

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

Line 700: hr_utility.set_location(' Leaving:' || l_proc,50);

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: -- ----------------------------------------------------------------------------

Line 722: hr_utility.set_location(' Entering:' || l_proc,10);

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;

Line 764: hr_utility.set_location(' Leaving:' || l_proc,20);

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: --

Line 780: hr_utility.set_location(' Leaving:' || l_proc, 30);

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

Line 791: hr_utility.set_location(' Leaving:' || l_proc,40);

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

Line 800: hr_utility.set_location(' Leaving:' || l_proc,50);

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: -- ---------------------------------------------------------------------------

Line 899: hr_utility.set_message(800, 'HR_NOT_VALID_PO_TXN');

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;

Line 900: hr_utility.raise_error;

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:

Line 1519: hr_utility.set_message(800, 'HR_ASG_RATE_INV_END_DATE');

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;