41: --
42: --
43: -- Check for Mandatory Arguments before calling the row handler
44: If p_budget_version_id IS NULL THEN
45: hr_api.mandatory_arg_error(p_api_name => l_proc,
46: p_argument => 'budget version id',
47: p_argument_value => p_budget_version_id);
48: End If;
49: If p_budget_unit_id IS NULL THEN
46: p_argument => 'budget version id',
47: p_argument_value => p_budget_version_id);
48: End If;
49: If p_budget_unit_id IS NULL THEN
50: hr_api.mandatory_arg_error(p_api_name => l_proc,
51: p_argument => 'budget unit id',
52: p_argument_value => p_budget_unit_id);
53: End If;
54: If p_entity_type IS NULL THEN
51: p_argument => 'budget unit id',
52: p_argument_value => p_budget_unit_id);
53: End If;
54: If p_entity_type IS NULL THEN
55: hr_api.mandatory_arg_error(p_api_name => l_proc,
56: p_argument => 'entity type',
57: p_argument_value => p_entity_type);
58: End If;
59: If p_approval_status IS NULL THEN
56: p_argument => 'entity type',
57: p_argument_value => p_entity_type);
58: End If;
59: If p_approval_status IS NULL THEN
60: hr_api.mandatory_arg_error(p_api_name => l_proc,
61: p_argument => 'approval status',
62: p_argument_value => p_approval_status);
63: End If;
64:
81: ,p_approval_status => p_approval_status
82: ,p_wf_transaction_category_id => p_wf_transaction_category_id
83: );
84: exception
85: when hr_api.cannot_find_prog_unit then
86: hr_api.cannot_find_prog_unit_error
87: (
88: p_module_name => 'CREATE_REALLOCATION_FOLDER'
89: ,p_hook_type => 'BP'
82: ,p_wf_transaction_category_id => p_wf_transaction_category_id
83: );
84: exception
85: when hr_api.cannot_find_prog_unit then
86: hr_api.cannot_find_prog_unit_error
87: (
88: p_module_name => 'CREATE_REALLOCATION_FOLDER'
89: ,p_hook_type => 'BP'
90: );
124: ,p_business_group_id => p_business_group_id
125: ,p_wf_transaction_category_id => p_wf_transaction_category_id
126: );
127: exception
128: when hr_api.cannot_find_prog_unit then
129: hr_api.cannot_find_prog_unit_error
130: (p_module_name => 'CREATE_REALLOCATION_FOLDER'
131: ,p_hook_type => 'AP'
132: );
125: ,p_wf_transaction_category_id => p_wf_transaction_category_id
126: );
127: exception
128: when hr_api.cannot_find_prog_unit then
129: hr_api.cannot_find_prog_unit_error
130: (p_module_name => 'CREATE_REALLOCATION_FOLDER'
131: ,p_hook_type => 'AP'
132: );
133: --
139: --
140: -- When in validation only mode raise the Validate_Enabled exception
141: --
142: if p_validate then
143: raise hr_api.validate_enabled;
144: end if;
145: --
146: -- Set all output arguments
147: --
151: hr_utility.set_location(' Leaving:'||l_proc, 70);
152: --
153: exception
154: --
155: when hr_api.validate_enabled then
156: --
157: -- As the Validate_Enabled exception has been raised
158: -- we must rollback to the savepoint
159: --
230: ,p_business_group_id => p_business_group_id
231: ,p_wf_transaction_category_id => p_wf_transaction_category_id
232: );
233: exception
234: when hr_api.cannot_find_prog_unit then
235: hr_api.cannot_find_prog_unit_error
236: (p_module_name => 'UPDATE_REALLOCATION_FOLDER'
237: ,p_hook_type => 'BP'
238: );
231: ,p_wf_transaction_category_id => p_wf_transaction_category_id
232: );
233: exception
234: when hr_api.cannot_find_prog_unit then
235: hr_api.cannot_find_prog_unit_error
236: (p_module_name => 'UPDATE_REALLOCATION_FOLDER'
237: ,p_hook_type => 'BP'
238: );
239: --
272: ,p_business_group_id => p_business_group_id
273: ,p_wf_transaction_category_id => p_wf_transaction_category_id
274: );
275: exception
276: when hr_api.cannot_find_prog_unit then
277: hr_api.cannot_find_prog_unit_error
278: (p_module_name => 'UPDATE_REALLOCATION_FOLDER'
279: ,p_hook_type => 'AP'
280: );
273: ,p_wf_transaction_category_id => p_wf_transaction_category_id
274: );
275: exception
276: when hr_api.cannot_find_prog_unit then
277: hr_api.cannot_find_prog_unit_error
278: (p_module_name => 'UPDATE_REALLOCATION_FOLDER'
279: ,p_hook_type => 'AP'
280: );
281: --
287: --
288: -- When in validation only mode raise the Validate_Enabled exception
289: --
290: if p_validate then
291: raise hr_api.validate_enabled;
292: end if;
293: --
294: -- Set all output arguments
295: --
298: hr_utility.set_location(' Leaving:'||l_proc, 70);
299: --
300: exception
301: --
302: when hr_api.validate_enabled then
303: --
304: -- As the Validate_Enabled exception has been raised
305: -- we must rollback to the savepoint
306: --
361: ,p_object_version_number => p_object_version_number
362: ,p_effective_date => trunc(p_effective_date)
363: );
364: exception
365: when hr_api.cannot_find_prog_unit then
366: hr_api.cannot_find_prog_unit_error
367: (p_module_name => 'DELETE_REALLOCATION_FOLDER'
368: ,p_hook_type => 'BP'
369: );
362: ,p_effective_date => trunc(p_effective_date)
363: );
364: exception
365: when hr_api.cannot_find_prog_unit then
366: hr_api.cannot_find_prog_unit_error
367: (p_module_name => 'DELETE_REALLOCATION_FOLDER'
368: ,p_hook_type => 'BP'
369: );
370: --
388: ,p_object_version_number => l_object_version_number
389: ,p_effective_date => trunc(p_effective_date)
390: );
391: exception
392: when hr_api.cannot_find_prog_unit then
393: hr_api.cannot_find_prog_unit_error
394: (p_module_name => 'DELETE_REALLOCATION_FOLDER'
395: ,p_hook_type => 'AP'
396: );
389: ,p_effective_date => trunc(p_effective_date)
390: );
391: exception
392: when hr_api.cannot_find_prog_unit then
393: hr_api.cannot_find_prog_unit_error
394: (p_module_name => 'DELETE_REALLOCATION_FOLDER'
395: ,p_hook_type => 'AP'
396: );
397: --
403: --
404: -- When in validation only mode raise the Validate_Enabled exception
405: --
406: if p_validate then
407: raise hr_api.validate_enabled;
408: end if;
409: --
410: hr_utility.set_location(' Leaving:'||l_proc, 70);
411: --
410: hr_utility.set_location(' Leaving:'||l_proc, 70);
411: --
412: exception
413: --
414: when hr_api.validate_enabled then
415: --
416: -- As the Validate_Enabled exception has been raised
417: -- we must rollback to the savepoint
418: --
465: --
466: --
467: -- Check for Mandatory Arguments before calling the row handler
468: If p_parent_folder_id IS NULL THEN
469: hr_api.mandatory_arg_error(p_api_name => l_proc,
470: p_argument => 'parent folder id',
471: p_argument_value => p_parent_folder_id);
472: End If;
473: hr_utility.set_location(l_proc, 20);
485: ,p_effective_date => trunc(p_effective_date)
486: ,p_business_group_id => p_business_group_id
487: );
488: exception
489: when hr_api.cannot_find_prog_unit then
490: hr_api.cannot_find_prog_unit_error
491: (
492: p_module_name => 'CREATE_REALLOCATION_TXN'
493: ,p_hook_type => 'BP'
486: ,p_business_group_id => p_business_group_id
487: );
488: exception
489: when hr_api.cannot_find_prog_unit then
490: hr_api.cannot_find_prog_unit_error
491: (
492: p_module_name => 'CREATE_REALLOCATION_TXN'
493: ,p_hook_type => 'BP'
494: );
520: ,p_effective_date => trunc(p_effective_date)
521: ,p_business_group_id => p_business_group_id
522: );
523: exception
524: when hr_api.cannot_find_prog_unit then
525: hr_api.cannot_find_prog_unit_error
526: (p_module_name => 'CREATE_REALLOCATION_TXN'
527: ,p_hook_type => 'AP'
528: );
521: ,p_business_group_id => p_business_group_id
522: );
523: exception
524: when hr_api.cannot_find_prog_unit then
525: hr_api.cannot_find_prog_unit_error
526: (p_module_name => 'CREATE_REALLOCATION_TXN'
527: ,p_hook_type => 'AP'
528: );
529: --
535: --
536: -- When in validation only mode raise the Validate_Enabled exception
537: --
538: if p_validate then
539: raise hr_api.validate_enabled;
540: end if;
541: --
542: -- Set all output arguments
543: --
547: hr_utility.set_location(' Leaving:'||l_proc, 70);
548: --
549: exception
550: --
551: when hr_api.validate_enabled then
552: --
553: -- As the Validate_Enabled exception has been raised
554: -- we must rollback to the savepoint
555: --
620: ,p_effective_date => trunc(p_effective_date)
621: ,p_business_group_id => p_business_group_id
622: );
623: exception
624: when hr_api.cannot_find_prog_unit then
625: hr_api.cannot_find_prog_unit_error
626: (p_module_name => 'UPDATE_REALLOCATION_TXN'
627: ,p_hook_type => 'BP'
628: );
621: ,p_business_group_id => p_business_group_id
622: );
623: exception
624: when hr_api.cannot_find_prog_unit then
625: hr_api.cannot_find_prog_unit_error
626: (p_module_name => 'UPDATE_REALLOCATION_TXN'
627: ,p_hook_type => 'BP'
628: );
629: --
654: ,p_effective_date => trunc(p_effective_date)
655: ,p_business_group_id => p_business_group_id
656: );
657: exception
658: when hr_api.cannot_find_prog_unit then
659: hr_api.cannot_find_prog_unit_error
660: (p_module_name => 'UPDATE_REALLOCATION_TXN'
661: ,p_hook_type => 'AP'
662: );
655: ,p_business_group_id => p_business_group_id
656: );
657: exception
658: when hr_api.cannot_find_prog_unit then
659: hr_api.cannot_find_prog_unit_error
660: (p_module_name => 'UPDATE_REALLOCATION_TXN'
661: ,p_hook_type => 'AP'
662: );
663: --
669: --
670: -- When in validation only mode raise the Validate_Enabled exception
671: --
672: if p_validate then
673: raise hr_api.validate_enabled;
674: end if;
675: --
676: -- Set all output arguments
677: --
680: hr_utility.set_location(' Leaving:'||l_proc, 70);
681: --
682: exception
683: --
684: when hr_api.validate_enabled then
685: --
686: -- As the Validate_Enabled exception has been raised
687: -- we must rollback to the savepoint
688: --
743: ,p_object_version_number => p_object_version_number
744: ,p_effective_date => trunc(p_effective_date)
745: );
746: exception
747: when hr_api.cannot_find_prog_unit then
748: hr_api.cannot_find_prog_unit_error
749: (p_module_name => 'DELETE_REALLOCATION_TXN'
750: ,p_hook_type => 'BP'
751: );
744: ,p_effective_date => trunc(p_effective_date)
745: );
746: exception
747: when hr_api.cannot_find_prog_unit then
748: hr_api.cannot_find_prog_unit_error
749: (p_module_name => 'DELETE_REALLOCATION_TXN'
750: ,p_hook_type => 'BP'
751: );
752: --
770: ,p_object_version_number => l_object_version_number
771: ,p_effective_date => trunc(p_effective_date)
772: );
773: exception
774: when hr_api.cannot_find_prog_unit then
775: hr_api.cannot_find_prog_unit_error
776: (p_module_name => 'DELETE_REALLOCATION_TXN'
777: ,p_hook_type => 'AP'
778: );
771: ,p_effective_date => trunc(p_effective_date)
772: );
773: exception
774: when hr_api.cannot_find_prog_unit then
775: hr_api.cannot_find_prog_unit_error
776: (p_module_name => 'DELETE_REALLOCATION_TXN'
777: ,p_hook_type => 'AP'
778: );
779: --
785: --
786: -- When in validation only mode raise the Validate_Enabled exception
787: --
788: if p_validate then
789: raise hr_api.validate_enabled;
790: end if;
791: --
792: hr_utility.set_location(' Leaving:'||l_proc, 70);
793: --
792: hr_utility.set_location(' Leaving:'||l_proc, 70);
793: --
794: exception
795: --
796: when hr_api.validate_enabled then
797: --
798: -- As the Validate_Enabled exception has been raised
799: -- we must rollback to the savepoint
800: --