50: ,p_entity_id => p_entity_id
51: ,p_budget_detail_id => p_budget_detail_id
52: );
53: exception
54: when hr_api.cannot_find_prog_unit then
55: hr_api.cannot_find_prog_unit_error
56: (
57: p_module_name => 'CREATE_REALLOC_TXN_DTL'
58: ,p_hook_type => 'BP'
51: ,p_budget_detail_id => p_budget_detail_id
52: );
53: exception
54: when hr_api.cannot_find_prog_unit then
55: hr_api.cannot_find_prog_unit_error
56: (
57: p_module_name => 'CREATE_REALLOC_TXN_DTL'
58: ,p_hook_type => 'BP'
59: );
86: ,p_entity_id => p_entity_id
87: ,p_object_version_number => l_object_version_number
88: );
89: exception
90: when hr_api.cannot_find_prog_unit then
91: hr_api.cannot_find_prog_unit_error
92: (p_module_name => 'CREATE_REALLOC_TXN_DTL'
93: ,p_hook_type => 'AP'
94: );
87: ,p_object_version_number => l_object_version_number
88: );
89: exception
90: when hr_api.cannot_find_prog_unit then
91: hr_api.cannot_find_prog_unit_error
92: (p_module_name => 'CREATE_REALLOC_TXN_DTL'
93: ,p_hook_type => 'AP'
94: );
95: --
101: --
102: -- When in validation only mode raise the Validate_Enabled exception
103: --
104: if p_validate then
105: raise hr_api.validate_enabled;
106: end if;
107: --
108: -- Set all output arguments
109: --
113: hr_utility.set_location(' Leaving:'||l_proc, 70);
114: --
115: exception
116: --
117: when hr_api.validate_enabled then
118: --
119: -- As the Validate_Enabled exception has been raised
120: -- we must rollback to the savepoint
121: --
185: ,p_txn_detail_id => p_txn_detail_id
186: ,p_object_version_number => l_object_version_number
187: );
188: exception
189: when hr_api.cannot_find_prog_unit then
190: hr_api.cannot_find_prog_unit_error
191: (p_module_name => 'UPDATE_REALLOC_TXN_DTL'
192: ,p_hook_type => 'BP'
193: );
186: ,p_object_version_number => l_object_version_number
187: );
188: exception
189: when hr_api.cannot_find_prog_unit then
190: hr_api.cannot_find_prog_unit_error
191: (p_module_name => 'UPDATE_REALLOC_TXN_DTL'
192: ,p_hook_type => 'BP'
193: );
194: --
220: ,p_txn_detail_id => p_txn_detail_id
221: ,p_object_version_number => l_object_version_number
222: );
223: exception
224: when hr_api.cannot_find_prog_unit then
225: hr_api.cannot_find_prog_unit_error
226: (p_module_name => 'UPDATE_REALLOC_TXN_DTL'
227: ,p_hook_type => 'AP'
228: );
221: ,p_object_version_number => l_object_version_number
222: );
223: exception
224: when hr_api.cannot_find_prog_unit then
225: hr_api.cannot_find_prog_unit_error
226: (p_module_name => 'UPDATE_REALLOC_TXN_DTL'
227: ,p_hook_type => 'AP'
228: );
229: --
235: --
236: -- When in validation only mode raise the Validate_Enabled exception
237: --
238: if p_validate then
239: raise hr_api.validate_enabled;
240: end if;
241: --
242: -- Set all output arguments
243: --
246: hr_utility.set_location(' Leaving:'||l_proc, 70);
247: --
248: exception
249: --
250: when hr_api.validate_enabled then
251: --
252: -- As the Validate_Enabled exception has been raised
253: -- we must rollback to the savepoint
254: --
307: p_txn_detail_id => p_txn_detail_id
308: ,p_object_version_number => p_object_version_number
309: );
310: exception
311: when hr_api.cannot_find_prog_unit then
312: hr_api.cannot_find_prog_unit_error
313: (p_module_name => 'DELETE_REALLOC_TXN_DTL'
314: ,p_hook_type => 'BP'
315: );
308: ,p_object_version_number => p_object_version_number
309: );
310: exception
311: when hr_api.cannot_find_prog_unit then
312: hr_api.cannot_find_prog_unit_error
313: (p_module_name => 'DELETE_REALLOC_TXN_DTL'
314: ,p_hook_type => 'BP'
315: );
316: --
333: p_txn_detail_id => p_txn_detail_id
334: ,p_object_version_number => l_object_version_number
335: );
336: exception
337: when hr_api.cannot_find_prog_unit then
338: hr_api.cannot_find_prog_unit_error
339: (p_module_name => 'DELETE_REALLOC_TXN_DTL'
340: ,p_hook_type => 'AP'
341: );
334: ,p_object_version_number => l_object_version_number
335: );
336: exception
337: when hr_api.cannot_find_prog_unit then
338: hr_api.cannot_find_prog_unit_error
339: (p_module_name => 'DELETE_REALLOC_TXN_DTL'
340: ,p_hook_type => 'AP'
341: );
342: --
348: --
349: -- When in validation only mode raise the Validate_Enabled exception
350: --
351: if p_validate then
352: raise hr_api.validate_enabled;
353: end if;
354: --
355: hr_utility.set_location(' Leaving:'||l_proc, 70);
356: --
355: hr_utility.set_location(' Leaving:'||l_proc, 70);
356: --
357: exception
358: --
359: when hr_api.validate_enabled then
360: --
361: -- As the Validate_Enabled exception has been raised
362: -- we must rollback to the savepoint
363: --
466: ,p_reallocation_amt => p_reallocation_amt
467: ,p_reserved_amt => p_reserved_amt
468: );
469: exception
470: when hr_api.cannot_find_prog_unit then
471: hr_api.cannot_find_prog_unit_error
472: (
473: p_module_name => 'CREATE_REALLOC_TXN_PERIOD'
474: ,p_hook_type => 'BP'
467: ,p_reserved_amt => p_reserved_amt
468: );
469: exception
470: when hr_api.cannot_find_prog_unit then
471: hr_api.cannot_find_prog_unit_error
472: (
473: p_module_name => 'CREATE_REALLOC_TXN_PERIOD'
474: ,p_hook_type => 'BP'
475: );
510: ,p_reallocation_period_id => l_reallocation_period_id
511: ,p_object_version_number => l_object_version_number
512: );
513: exception
514: when hr_api.cannot_find_prog_unit then
515: hr_api.cannot_find_prog_unit_error
516: (p_module_name => 'CREATE_REALLOC_TXN_PERIOD'
517: ,p_hook_type => 'AP'
518: );
511: ,p_object_version_number => l_object_version_number
512: );
513: exception
514: when hr_api.cannot_find_prog_unit then
515: hr_api.cannot_find_prog_unit_error
516: (p_module_name => 'CREATE_REALLOC_TXN_PERIOD'
517: ,p_hook_type => 'AP'
518: );
519: --
525: --
526: -- When in validation only mode raise the Validate_Enabled exception
527: --
528: if p_validate then
529: raise hr_api.validate_enabled;
530: end if;
531: --
532: -- Set all output arguments
533: --
537: hr_utility.set_location(' Leaving:'||l_proc, 70);
538: --
539: exception
540: --
541: when hr_api.validate_enabled then
542: --
543: -- As the Validate_Enabled exception has been raised
544: -- we must rollback to the savepoint
545: --
651: ,p_reallocation_period_id => p_reallocation_period_id
652: ,p_object_version_number => l_object_version_number
653: );
654: exception
655: when hr_api.cannot_find_prog_unit then
656: hr_api.cannot_find_prog_unit_error
657: (p_module_name => 'UPDATE_REALLOC_TXN_PERIOD'
658: ,p_hook_type => 'BP'
659: );
652: ,p_object_version_number => l_object_version_number
653: );
654: exception
655: when hr_api.cannot_find_prog_unit then
656: hr_api.cannot_find_prog_unit_error
657: (p_module_name => 'UPDATE_REALLOC_TXN_PERIOD'
658: ,p_hook_type => 'BP'
659: );
660: --
694: ,p_reallocation_period_id => p_reallocation_period_id
695: ,p_object_version_number => l_object_version_number
696: );
697: exception
698: when hr_api.cannot_find_prog_unit then
699: hr_api.cannot_find_prog_unit_error
700: (p_module_name => 'UPDATE_REALLOC_TXN_PERIOD'
701: ,p_hook_type => 'AP'
702: );
695: ,p_object_version_number => l_object_version_number
696: );
697: exception
698: when hr_api.cannot_find_prog_unit then
699: hr_api.cannot_find_prog_unit_error
700: (p_module_name => 'UPDATE_REALLOC_TXN_PERIOD'
701: ,p_hook_type => 'AP'
702: );
703: --
709: --
710: -- When in validation only mode raise the Validate_Enabled exception
711: --
712: if p_validate then
713: raise hr_api.validate_enabled;
714: end if;
715: --
716: -- Set all output arguments
717: --
720: hr_utility.set_location(' Leaving:'||l_proc, 70);
721: --
722: exception
723: --
724: when hr_api.validate_enabled then
725: --
726: -- As the Validate_Enabled exception has been raised
727: -- we must rollback to the savepoint
728: --
781: p_reallocation_period_id => p_reallocation_period_id
782: ,p_object_version_number => p_object_version_number
783: );
784: exception
785: when hr_api.cannot_find_prog_unit then
786: hr_api.cannot_find_prog_unit_error
787: (p_module_name => 'DELETE_REALLOC_TXN_PERIOD'
788: ,p_hook_type => 'BP'
789: );
782: ,p_object_version_number => p_object_version_number
783: );
784: exception
785: when hr_api.cannot_find_prog_unit then
786: hr_api.cannot_find_prog_unit_error
787: (p_module_name => 'DELETE_REALLOC_TXN_PERIOD'
788: ,p_hook_type => 'BP'
789: );
790: --
807: p_reallocation_period_id => p_reallocation_period_id
808: ,p_object_version_number => l_object_version_number
809: );
810: exception
811: when hr_api.cannot_find_prog_unit then
812: hr_api.cannot_find_prog_unit_error
813: (p_module_name => 'DELETE_REALLOC_TXN_PERIOD'
814: ,p_hook_type => 'AP'
815: );
808: ,p_object_version_number => l_object_version_number
809: );
810: exception
811: when hr_api.cannot_find_prog_unit then
812: hr_api.cannot_find_prog_unit_error
813: (p_module_name => 'DELETE_REALLOC_TXN_PERIOD'
814: ,p_hook_type => 'AP'
815: );
816: --
822: --
823: -- When in validation only mode raise the Validate_Enabled exception
824: --
825: if p_validate then
826: raise hr_api.validate_enabled;
827: end if;
828: --
829: hr_utility.set_location(' Leaving:'||l_proc, 70);
830: --
829: hr_utility.set_location(' Leaving:'||l_proc, 70);
830: --
831: exception
832: --
833: when hr_api.validate_enabled then
834: --
835: -- As the Validate_Enabled exception has been raised
836: -- we must rollback to the savepoint
837: --