eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_BDGT_POOL_REALLOCTIONS_API dependencies on HR_UTILITY

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

28: l_object_version_number pqh_bdgt_pool_realloctions.object_version_number%TYPE;
29: --
30: begin
31: --
32: hr_utility.set_location('Entering:'|| l_proc, 10);
33: --
34: -- Issue a savepoint if operating in validation only mode
35: --
36: savepoint create_realloc_txn_dtl;

Line 38: hr_utility.set_location(l_proc, 20);

34: -- Issue a savepoint if operating in validation only mode
35: --
36: savepoint create_realloc_txn_dtl;
37: --
38: hr_utility.set_location(l_proc, 20);
39: --
40: -- Process Logic
41: --
42: begin

Line 100: hr_utility.set_location(l_proc, 60);

96: -- End of API User Hook for the after hook of create_realloc_txn_dtl
97: --
98: end;
99: --
100: hr_utility.set_location(l_proc, 60);
101: --
102: -- When in validation only mode raise the Validate_Enabled exception
103: --
104: if p_validate then

Line 113: hr_utility.set_location(' Leaving:'||l_proc, 70);

109: --
110: p_txn_detail_id := l_txn_detail_id;
111: p_object_version_number := l_object_version_number;
112: --
113: hr_utility.set_location(' Leaving:'||l_proc, 70);
114: --
115: exception
116: --
117: when hr_api.validate_enabled then

Line 130: hr_utility.set_location(' Leaving:'||l_proc, 80);

126: -- when validation only mode is being used.)
127: --
128: p_txn_detail_id := null;
129: p_object_version_number := null;
130: hr_utility.set_location(' Leaving:'||l_proc, 80);
131: --
132: when others then
133: --
134: -- A validation or unexpected error has occured

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

159: l_object_version_number pqh_bdgt_pool_realloctions.object_version_number%TYPE;
160: --
161: begin
162: --
163: hr_utility.set_location('Entering:'|| l_proc, 10);
164: --
165: -- Issue a savepoint if operating in validation only mode
166: --
167: savepoint update_realloc_txn_dtl;

Line 169: hr_utility.set_location(l_proc, 20);

165: -- Issue a savepoint if operating in validation only mode
166: --
167: savepoint update_realloc_txn_dtl;
168: --
169: hr_utility.set_location(l_proc, 20);
170: --
171: -- Process Logic
172: --
173: l_object_version_number := p_object_version_number;

Line 234: hr_utility.set_location(l_proc, 60);

230: -- End of API User Hook for the after hook of update_realloc_txn_dtl
231: --
232: end;
233: --
234: hr_utility.set_location(l_proc, 60);
235: --
236: -- When in validation only mode raise the Validate_Enabled exception
237: --
238: if p_validate then

Line 246: hr_utility.set_location(' Leaving:'||l_proc, 70);

242: -- Set all output arguments
243: --
244: p_object_version_number := l_object_version_number;
245: --
246: hr_utility.set_location(' Leaving:'||l_proc, 70);
247: --
248: exception
249: --
250: when hr_api.validate_enabled then

Line 261: hr_utility.set_location(' Leaving:'||l_proc, 80);

257: -- Only set output warning arguments
258: -- (Any key or derived arguments must be set to null
259: -- when validation only mode is being used.)
260: --
261: hr_utility.set_location(' Leaving:'||l_proc, 80);
262: --
263: when others then
264: --
265: -- A validation or unexpected error has occured

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

284: l_object_version_number pqh_bdgt_pool_realloctions.object_version_number%TYPE;
285: --
286: begin
287: --
288: hr_utility.set_location('Entering:'|| l_proc, 10);
289: --
290: -- Issue a savepoint if operating in validation only mode
291: --
292: savepoint delete_realloc_txn_dtl;

Line 294: hr_utility.set_location(l_proc, 20);

290: -- Issue a savepoint if operating in validation only mode
291: --
292: savepoint delete_realloc_txn_dtl;
293: --
294: hr_utility.set_location(l_proc, 20);
295: --
296: -- Process Logic
297: --
298: l_object_version_number := p_object_version_number;

Line 347: hr_utility.set_location(l_proc, 60);

343: -- End of API User Hook for the after hook of delete_realloc_txn_dtl
344: --
345: end;
346: --
347: hr_utility.set_location(l_proc, 60);
348: --
349: -- When in validation only mode raise the Validate_Enabled exception
350: --
351: if p_validate then

Line 355: hr_utility.set_location(' Leaving:'||l_proc, 70);

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: --
357: exception
358: --
359: when hr_api.validate_enabled then

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

424: AND NVL(p_start_date,sysdate) <= NVL(txnprd.end_date,sysdate);
425: l_dup_exist Varchar2(10);
426: begin
427: --
428: hr_utility.set_location('Entering:'|| l_proc, 10);
429:
430: --
431: -- Issue a savepoint if operating in validation only mode
432: --

Line 444: hr_utility.set_message(8302,'PQH_DUP_RCVR_PERIOD');

440: OPEN csr_dup_rcvr_period(l_transaction_id);
441: FETCH csr_dup_rcvr_period INTO l_dup_exist;
442: CLOSE csr_dup_rcvr_period;
443: IF l_dup_exist IS NOT NULL THEN
444: hr_utility.set_message(8302,'PQH_DUP_RCVR_PERIOD');
445: hr_utility.raise_error;
446: END IF;
447: END IF;
448: END IF;

Line 445: hr_utility.raise_error;

441: FETCH csr_dup_rcvr_period INTO l_dup_exist;
442: CLOSE csr_dup_rcvr_period;
443: IF l_dup_exist IS NOT NULL THEN
444: hr_utility.set_message(8302,'PQH_DUP_RCVR_PERIOD');
445: hr_utility.raise_error;
446: END IF;
447: END IF;
448: END IF;
449: --

Line 450: hr_utility.set_location(l_proc, 20);

446: END IF;
447: END IF;
448: END IF;
449: --
450: hr_utility.set_location(l_proc, 20);
451: --
452: -- Process Logic
453: --
454: begin

Line 524: hr_utility.set_location(l_proc, 60);

520: -- End of API User Hook for the after hook of create_realloc_txn_period
521: --
522: end;
523: --
524: hr_utility.set_location(l_proc, 60);
525: --
526: -- When in validation only mode raise the Validate_Enabled exception
527: --
528: if p_validate then

Line 537: hr_utility.set_location(' Leaving:'||l_proc, 70);

533: --
534: p_reallocation_period_id := l_reallocation_period_id;
535: p_object_version_number := l_object_version_number;
536: --
537: hr_utility.set_location(' Leaving:'||l_proc, 70);
538: --
539: exception
540: --
541: when hr_api.validate_enabled then

Line 554: hr_utility.set_location(' Leaving:'||l_proc, 80);

550: -- when validation only mode is being used.)
551: --
552: p_reallocation_period_id := null;
553: p_object_version_number := null;
554: hr_utility.set_location(' Leaving:'||l_proc, 80);
555: --
556: when others then
557: --
558: -- A validation or unexpected error has occured

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

606: AND NVL(p_start_date,sysdate) <= NVL(txnprd.end_date,sysdate);
607: l_dup_exist varchar2(10);
608: begin
609: --
610: hr_utility.set_location('Entering:'|| l_proc, 10);
611: --
612: -- Issue a savepoint if operating in validation only mode
613: --
614: savepoint update_realloc_txn_period;

Line 626: hr_utility.set_message(8302,'PQH_DUP_RCVR_PERIOD');

622: OPEN csr_dup_rcvr_period(l_transaction_id);
623: FETCH csr_dup_rcvr_period INTO l_dup_exist;
624: CLOSE csr_dup_rcvr_period;
625: IF l_dup_exist IS NOT NULL THEN
626: hr_utility.set_message(8302,'PQH_DUP_RCVR_PERIOD');
627: hr_utility.raise_error;
628: END IF;
629: END IF;
630: END IF;

Line 627: hr_utility.raise_error;

623: FETCH csr_dup_rcvr_period INTO l_dup_exist;
624: CLOSE csr_dup_rcvr_period;
625: IF l_dup_exist IS NOT NULL THEN
626: hr_utility.set_message(8302,'PQH_DUP_RCVR_PERIOD');
627: hr_utility.raise_error;
628: END IF;
629: END IF;
630: END IF;
631: hr_utility.set_location(l_proc, 20);

Line 631: hr_utility.set_location(l_proc, 20);

627: hr_utility.raise_error;
628: END IF;
629: END IF;
630: END IF;
631: hr_utility.set_location(l_proc, 20);
632: --
633: -- Process Logic
634: --
635: l_object_version_number := p_object_version_number;

Line 708: hr_utility.set_location(l_proc, 60);

704: -- End of API User Hook for the after hook of update_realloc_txn_period
705: --
706: end;
707: --
708: hr_utility.set_location(l_proc, 60);
709: --
710: -- When in validation only mode raise the Validate_Enabled exception
711: --
712: if p_validate then

Line 720: hr_utility.set_location(' Leaving:'||l_proc, 70);

716: -- Set all output arguments
717: --
718: p_object_version_number := l_object_version_number;
719: --
720: hr_utility.set_location(' Leaving:'||l_proc, 70);
721: --
722: exception
723: --
724: when hr_api.validate_enabled then

Line 735: hr_utility.set_location(' Leaving:'||l_proc, 80);

731: -- Only set output warning arguments
732: -- (Any key or derived arguments must be set to null
733: -- when validation only mode is being used.)
734: --
735: hr_utility.set_location(' Leaving:'||l_proc, 80);
736: --
737: when others then
738: --
739: -- A validation or unexpected error has occured

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

758: l_object_version_number pqh_bdgt_pool_realloctions.object_version_number%TYPE;
759: --
760: begin
761: --
762: hr_utility.set_location('Entering:'|| l_proc, 10);
763: --
764: -- Issue a savepoint if operating in validation only mode
765: --
766: savepoint delete_realloc_txn_period;

Line 768: hr_utility.set_location(l_proc, 20);

764: -- Issue a savepoint if operating in validation only mode
765: --
766: savepoint delete_realloc_txn_period;
767: --
768: hr_utility.set_location(l_proc, 20);
769: --
770: -- Process Logic
771: --
772: l_object_version_number := p_object_version_number;

Line 821: hr_utility.set_location(l_proc, 60);

817: -- End of API User Hook for the after hook of delete_realloc_txn_period
818: --
819: end;
820: --
821: hr_utility.set_location(l_proc, 60);
822: --
823: -- When in validation only mode raise the Validate_Enabled exception
824: --
825: if p_validate then

Line 829: hr_utility.set_location(' Leaving:'||l_proc, 70);

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: --
831: exception
832: --
833: when hr_api.validate_enabled then