DBA Data[Home] [Help]

APPS.HR_RATE_VALUES_SWI dependencies on HR_MULTI_MESSAGE

Line 50: hr_multi_message.enable_message_list;

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

Line 85: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 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.

Line 102: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 115: if hr_multi_message.unexpected_error_add(l_proc) then

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

Line 126: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 169: hr_multi_message.enable_message_list;

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

Line 218: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 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.

Line 235: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 246: if hr_multi_message.unexpected_error_add(l_proc) then

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

Line 256: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 292: hr_multi_message.enable_message_list;

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;

Line 324: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 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.

Line 341: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 352: if hr_multi_message.unexpected_error_add(l_proc) then

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

Line 362: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 402: hr_multi_message.enable_message_list;

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;

Line 446: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 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.

Line 463: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 474: if hr_multi_message.unexpected_error_add(l_proc) then

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

Line 484: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 518: hr_multi_message.enable_message_list;

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;

Line 551: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 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.

Line 568: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 579: if hr_multi_message.unexpected_error_add(l_proc) then

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

Line 589: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 623: hr_multi_message.enable_message_list;

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;

Line 661: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 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.

Line 678: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 689: if hr_multi_message.unexpected_error_add(l_proc) then

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

Line 699: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 730: hr_multi_message.enable_message_list;

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

Line 763: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 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.

Line 779: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 790: if hr_multi_message.unexpected_error_add(l_proc) then

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

Line 799: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 1516: hr_multi_message.enable_message_list;

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

Line 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;

Line 1523: hr_multi_message.end_validation_set;

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

Line 1652: when hr_multi_message.error_message_exist 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)

Line 1653: p_return_status := hr_multi_message.get_return_status_disable;

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