32: l_object_version_number pqh_budget_pools.object_version_number%TYPE;
33: --
34: begin
35: --
36: hr_utility.set_location('Entering:'|| l_proc, 10);
37: --
38: -- Issue a savepoint if operating in validation only mode
39: --
40: savepoint create_reallocation_folder;
61: p_argument => 'approval status',
62: p_argument_value => p_approval_status);
63: End If;
64:
65: hr_utility.set_location(l_proc, 20);
66: --
67: -- Process Logic
68: --
69: begin
134: -- End of API User Hook for the after hook of create_reallocation_folder
135: --
136: end;
137: --
138: hr_utility.set_location(l_proc, 60);
139: --
140: -- When in validation only mode raise the Validate_Enabled exception
141: --
142: if p_validate then
147: --
148: p_folder_id := l_folder_id;
149: p_object_version_number := l_object_version_number;
150: --
151: hr_utility.set_location(' Leaving:'||l_proc, 70);
152: --
153: exception
154: --
155: when hr_api.validate_enabled then
164: -- when validation only mode is being used.)
165: --
166: p_folder_id := null;
167: p_object_version_number := null;
168: hr_utility.set_location(' Leaving:'||l_proc, 80);
169: --
170: when others then
171: --
172: -- A validation or unexpected error has occured
200: l_object_version_number pqh_budget_pools.object_version_number%TYPE;
201: --
202: begin
203: --
204: hr_utility.set_location('Entering:'|| l_proc, 10);
205: --
206: -- Issue a savepoint if operating in validation only mode
207: --
208: savepoint update_reallocation_folder;
206: -- Issue a savepoint if operating in validation only mode
207: --
208: savepoint update_reallocation_folder;
209: --
210: hr_utility.set_location(l_proc, 20);
211: --
212: -- Process Logic
213: --
214: l_object_version_number := p_object_version_number;
282: -- End of API User Hook for the after hook of update_reallocation_folder
283: --
284: end;
285: --
286: hr_utility.set_location(l_proc, 60);
287: --
288: -- When in validation only mode raise the Validate_Enabled exception
289: --
290: if p_validate then
294: -- Set all output arguments
295: --
296: p_object_version_number := l_object_version_number;
297: --
298: hr_utility.set_location(' Leaving:'||l_proc, 70);
299: --
300: exception
301: --
302: when hr_api.validate_enabled then
309: -- Only set output warning arguments
310: -- (Any key or derived arguments must be set to null
311: -- when validation only mode is being used.)
312: --
313: hr_utility.set_location(' Leaving:'||l_proc, 80);
314: --
315: when others then
316: --
317: -- A validation or unexpected error has occured
337: l_object_version_number pqh_budget_pools.object_version_number%TYPE;
338: --
339: begin
340: --
341: hr_utility.set_location('Entering:'|| l_proc, 10);
342: --
343: -- Issue a savepoint if operating in validation only mode
344: --
345: savepoint delete_reallocation_folder;
343: -- Issue a savepoint if operating in validation only mode
344: --
345: savepoint delete_reallocation_folder;
346: --
347: hr_utility.set_location(l_proc, 20);
348: --
349: -- Process Logic
350: --
351: l_object_version_number := p_object_version_number;
398: -- End of API User Hook for the after hook of delete_reallocation_folder
399: --
400: end;
401: --
402: hr_utility.set_location(l_proc, 60);
403: --
404: -- When in validation only mode raise the Validate_Enabled exception
405: --
406: if p_validate then
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: --
412: exception
413: --
414: when hr_api.validate_enabled then
456: l_object_version_number pqh_budget_pools.object_version_number%TYPE;
457: --
458: begin
459: --
460: hr_utility.set_location('Entering:'|| l_proc, 10);
461: --
462: -- Issue a savepoint if operating in validation only mode
463: --
464: savepoint create_reallocation_txn;
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);
474: --
475: -- Process Logic
476: --
477: begin
530: -- End of API User Hook for the after hook of create_reallocation_txn
531: --
532: end;
533: --
534: hr_utility.set_location(l_proc, 60);
535: --
536: -- When in validation only mode raise the Validate_Enabled exception
537: --
538: if p_validate then
543: --
544: p_transaction_id := l_transaction_id;
545: p_object_version_number := l_object_version_number;
546: --
547: hr_utility.set_location(' Leaving:'||l_proc, 70);
548: --
549: exception
550: --
551: when hr_api.validate_enabled then
560: -- when validation only mode is being used.)
561: --
562: p_transaction_id := null;
563: p_object_version_number := null;
564: hr_utility.set_location(' Leaving:'||l_proc, 80);
565: --
566: when others then
567: --
568: -- A validation or unexpected error has occured
594: l_object_version_number pqh_budget_pools.object_version_number%TYPE;
595: --
596: begin
597: --
598: hr_utility.set_location('Entering:'|| l_proc, 10);
599: --
600: -- Issue a savepoint if operating in validation only mode
601: --
602: savepoint update_reallocation_txn;
600: -- Issue a savepoint if operating in validation only mode
601: --
602: savepoint update_reallocation_txn;
603: --
604: hr_utility.set_location(l_proc, 20);
605: --
606: -- Process Logic
607: --
608: l_object_version_number := p_object_version_number;
664: -- End of API User Hook for the after hook of update_reallocation_txn
665: --
666: end;
667: --
668: hr_utility.set_location(l_proc, 60);
669: --
670: -- When in validation only mode raise the Validate_Enabled exception
671: --
672: if p_validate then
676: -- Set all output arguments
677: --
678: p_object_version_number := l_object_version_number;
679: --
680: hr_utility.set_location(' Leaving:'||l_proc, 70);
681: --
682: exception
683: --
684: when hr_api.validate_enabled then
691: -- Only set output warning arguments
692: -- (Any key or derived arguments must be set to null
693: -- when validation only mode is being used.)
694: --
695: hr_utility.set_location(' Leaving:'||l_proc, 80);
696: --
697: when others then
698: --
699: -- A validation or unexpected error has occured
719: l_object_version_number pqh_budget_pools.object_version_number%TYPE;
720: --
721: begin
722: --
723: hr_utility.set_location('Entering:'|| l_proc, 10);
724: --
725: -- Issue a savepoint if operating in validation only mode
726: --
727: savepoint delete_reallocation_txn;
725: -- Issue a savepoint if operating in validation only mode
726: --
727: savepoint delete_reallocation_txn;
728: --
729: hr_utility.set_location(l_proc, 20);
730: --
731: -- Process Logic
732: --
733: l_object_version_number := p_object_version_number;
780: -- End of API User Hook for the after hook of delete_reallocation_txn
781: --
782: end;
783: --
784: hr_utility.set_location(l_proc, 60);
785: --
786: -- When in validation only mode raise the Validate_Enabled exception
787: --
788: if p_validate then
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: --
794: exception
795: --
796: when hr_api.validate_enabled then