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.HR_CAGR_ENT_LINES_API dependencies on HR_UTILITY

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

34: l_result_id per_cagr_entitlement_results.cagr_entitlement_result_id %TYPE;
35: --
36: BEGIN
37: --
38: hr_utility.set_location('Entering:'|| l_proc, 10);
39: --
40: FOR c_results IN csr_entitlement_results LOOP
41: --
42: hr_utility.set_location(l_proc||'/'||c_results.cagr_entitlement_result_id

Line 42: hr_utility.set_location(l_proc||'/'||c_results.cagr_entitlement_result_id

38: hr_utility.set_location('Entering:'|| l_proc, 10);
39: --
40: FOR c_results IN csr_entitlement_results LOOP
41: --
42: hr_utility.set_location(l_proc||'/'||c_results.cagr_entitlement_result_id
43: ||'/'||c_results.assignment_id, 20);
44: --
45: OPEN csr_chk_for_other_lines
46: (p_cagr_request_id => c_results.cagr_request_id

Line 58: hr_utility.set_location(l_proc,30);

54: -- delete from retained rights, log and requests
55: --
56: IF csr_chk_for_other_lines%NOTFOUND THEN
57: --
58: hr_utility.set_location(l_proc,30);
59: --
60: DELETE FROM per_cagr_retained_rights
61: WHERE cagr_entitlement_line_id = p_cagr_entitlement_line_id;
62: --

Line 63: hr_utility.set_location(l_proc,40);

59: --
60: DELETE FROM per_cagr_retained_rights
61: WHERE cagr_entitlement_line_id = p_cagr_entitlement_line_id;
62: --
63: hr_utility.set_location(l_proc,40);
64: --
65: DELETE FROM per_cagr_entitlement_results
66: WHERE cagr_entitlement_result_id = c_results.cagr_entitlement_result_id;
67: --

Line 68: hr_utility.set_location(l_proc,50);

64: --
65: DELETE FROM per_cagr_entitlement_results
66: WHERE cagr_entitlement_result_id = c_results.cagr_entitlement_result_id;
67: --
68: hr_utility.set_location(l_proc,50);
69: --
70: DELETE FROM per_cagr_log
71: WHERE cagr_request_id = c_results.cagr_request_id;
72: --

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

69: --
70: DELETE FROM per_cagr_log
71: WHERE cagr_request_id = c_results.cagr_request_id;
72: --
73: hr_utility.set_location(l_proc,60);
74: --
75: DELETE FROM per_cagr_requests
76: WHERE cagr_request_id = c_results.cagr_request_id;
77: --

Line 78: hr_utility.set_location(l_proc,70);

74: --
75: DELETE FROM per_cagr_requests
76: WHERE cagr_request_id = c_results.cagr_request_id;
77: --
78: hr_utility.set_location(l_proc,70);
79: --
80: CLOSE csr_chk_for_other_lines;
81: --
82: ELSE

Line 84: hr_utility.set_location(l_proc,80);

80: CLOSE csr_chk_for_other_lines;
81: --
82: ELSE
83: --
84: hr_utility.set_location(l_proc,80);
85: --
86: DELETE FROM per_cagr_retained_rights
87: WHERE cagr_entitlement_result_id = c_results.cagr_entitlement_result_id;
88: --

Line 89: hr_utility.set_location(l_proc,90);

85: --
86: DELETE FROM per_cagr_retained_rights
87: WHERE cagr_entitlement_result_id = c_results.cagr_entitlement_result_id;
88: --
89: hr_utility.set_location(l_proc,90);
90: --
91: DELETE FROM per_cagr_entitlement_results
92: WHERE cagr_entitlement_result_id = c_results.cagr_entitlement_result_id;
93: --

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

90: --
91: DELETE FROM per_cagr_entitlement_results
92: WHERE cagr_entitlement_result_id = c_results.cagr_entitlement_result_id;
93: --
94: hr_utility.set_location(l_proc,100);
95: --
96: CLOSE csr_chk_for_other_lines;
97: --
98: END IF;

Line 102: hr_utility.set_location('Leaving:'|| l_proc, 999);

98: END IF;
99: --
100: END LOOP;
101: --
102: hr_utility.set_location('Leaving:'|| l_proc, 999);
103: --
104: END delete_from_engine_tables;
105: --
106: -- ----------------------------------------------------------------------------

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

166: l_prtn_elig_ovn NUMBER;
167: --
168: BEGIN
169: --
170: hr_utility.set_location('Entering:'|| l_proc, 10);
171: --
172: -- Issue a SAVEPOINT IF operating in validation only mode
173: --
174: SAVEPOINT create_entitlement_line;

Line 200: hr_utility.set_location(l_proc, 40);

196: ELSE
197: --
198: BEGIN
199: --
200: hr_utility.set_location(l_proc, 40);
201: --
202: l_order_number := per_cagr_utility_pkg.get_next_order_number(p_pl_id => l_pl_id);
203: --
204: ben_option_in_plan_api.create_option_in_plan

Line 222: hr_utility.set_location(l_proc||'/'||l_oipl_id, 50);

218: ,p_trk_inelig_per_flag => 'N' -- Default Value
219: ,p_auto_enrt_flag => 'N'
220: ,p_ordr_num => l_order_number);
221: --
222: hr_utility.set_location(l_proc||'/'||l_oipl_id, 50);
223: --
224: END;
225: --
226: BEGIN

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

243: END;
244: --
245: BEGIN
246: --
247: hr_utility.set_location(l_proc, 60);
248: --
249: ben_prtn_elig_prfl_api.create_prtn_elig_prfl
250: (p_validate => p_validate
251: ,p_PRTN_ELIG_PRFL_ID => l_prtn_elig_prfl_id

Line 262: hr_utility.set_location(l_proc||'/'||l_prtn_elig_prfl_id, 70);

258: ,p_oipl_id => l_oipl_id
259: ,p_object_version_number => l_prtn_ovn
260: ,p_effective_date => l_effective_date);
261: --
262: hr_utility.set_location(l_proc||'/'||l_prtn_elig_prfl_id, 70);
263: --
264: END;
265: --
266: END IF;

Line 274: hr_utility.set_location(l_proc, 80);

270: BEGIN
271: --
272: -- Start of API User Hook for the before hook of create_entitlement_line
273: --
274: hr_utility.set_location(l_proc, 80);
275: --
276: hr_cagr_ent_lines_bk1.create_entitlement_line_b
277: (
278: p_mandatory => p_mandatory

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

290: ,p_to_step_id => p_to_step_id
291: ,p_effective_date => TRUNC(p_effective_date)
292: );
293: --
294: hr_utility.set_location(l_proc, 90);
295: --
296: EXCEPTION
297: WHEN hr_api.cannot_find_prog_unit THEN
298: hr_api.cannot_find_prog_unit_error

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

304: -- End of API User Hook for the before hook of create_entitlement_line
305: --
306: END;
307: --
308: hr_utility.set_location(l_proc, 100);
309: --
310: per_pcl_ins.ins
311: (p_cagr_entitlement_line_id => l_cagr_entitlement_line_id
312: ,p_mandatory => p_mandatory

Line 331: hr_utility.set_location(l_proc, 110);

327: ,p_object_version_number => l_object_version_number
328: ,p_effective_date => TRUNC(p_effective_date)
329: );
330: --
331: hr_utility.set_location(l_proc, 110);
332: --
333: BEGIN
334: --
335: -- Start of API User Hook for the after hook of create_entitlement_line

Line 337: hr_utility.set_location(l_proc, 120);

333: BEGIN
334: --
335: -- Start of API User Hook for the after hook of create_entitlement_line
336: --
337: hr_utility.set_location(l_proc, 120);
338: --
339: hr_cagr_ent_lines_bk1.create_entitlement_line_a
340: (
341: p_cagr_entitlement_line_id => l_cagr_entitlement_line_id

Line 361: hr_utility.set_location(l_proc, 130);

357: ,p_object_version_number => l_object_version_number
358: ,p_effective_date => l_effective_date
359: );
360: --
361: hr_utility.set_location(l_proc, 130);
362: --
363: EXCEPTION
364: WHEN hr_api.cannot_find_prog_unit THEN
365: hr_api.cannot_find_prog_unit_error

Line 374: hr_utility.set_location(l_proc, 140);

370: -- End of API User Hook for the after hook of create_entitlement_line
371: --
372: END;
373: --
374: hr_utility.set_location(l_proc, 140);
375: --
376: -- When in validation only mode RAISE the Validate_Enabled EXCEPTION
377: --
378: IF p_validate THEN

Line 390: hr_utility.set_location(' Leaving:'||l_proc, 999);

386: p_effective_END_date := l_effective_END_date;
387: p_object_version_number := l_object_version_number;
388: p_oipl_id := l_oipl_id;
389: --
390: hr_utility.set_location(' Leaving:'||l_proc, 999);
391: --
392: EXCEPTION
393: --
394: WHEN hr_api.validate_enabled THEN

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

406: p_effective_start_date := null;
407: p_effective_END_date := null;
408: p_object_version_number := null;
409: --
410: hr_utility.set_location(' Leaving:'||l_proc, 80);
411: --
412: WHEN others THEN
413: --
414: -- A validation or unexpected error has occured

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

480: l_oipl_id NUMBER;
481: --
482: BEGIN
483: --
484: hr_utility.set_location('Entering:'|| l_proc, 10);
485: --
486: l_effective_date := TRUNC(p_effective_date);
487: --
488: -- Issue a SAVEPOINT IF operating in validation only mode

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

488: -- Issue a SAVEPOINT IF operating in validation only mode
489: --
490: SAVEPOINT update_entitlement_line;
491: --
492: hr_utility.set_location(l_proc, 20);
493: --
494: -- Process Logic
495: --
496: l_object_version_number := p_object_version_number;

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

532: --
533: /*
534: BEGIN
535: --
536: hr_utility.set_location(l_proc, 60);
537: --
538: OPEN get_prtn_elig_prfl_id;
539: FETCH get_prtn_elig_prfl_id INTO l_prtn_elig_prfl_id,l_prtn_ovn;
540: --

Line 541: hr_utility.set_location(l_proc||'/'||l_prtn_elig_prfl_id, 65);

537: --
538: OPEN get_prtn_elig_prfl_id;
539: FETCH get_prtn_elig_prfl_id INTO l_prtn_elig_prfl_id,l_prtn_ovn;
540: --
541: hr_utility.set_location(l_proc||'/'||l_prtn_elig_prfl_id, 65);
542: --
543: IF get_prtn_elig_prfl_id%NOTFOUND THEN
544: --
545: CLOSE get_prtn_elig_prfl_id;

Line 547: hr_utility.set_message(800,'HR_289380_CAGR_OPT_ELIG_ERROR');

543: IF get_prtn_elig_prfl_id%NOTFOUND THEN
544: --
545: CLOSE get_prtn_elig_prfl_id;
546: --
547: hr_utility.set_message(800,'HR_289380_CAGR_OPT_ELIG_ERROR');
548: hr_utility.raise_error;
549: --
550: ELSE
551: --

Line 548: hr_utility.raise_error;

544: --
545: CLOSE get_prtn_elig_prfl_id;
546: --
547: hr_utility.set_message(800,'HR_289380_CAGR_OPT_ELIG_ERROR');
548: hr_utility.raise_error;
549: --
550: ELSE
551: --
552: CLOSE get_prtn_elig_prfl_id;

Line 570: hr_utility.set_location(l_proc||'/'||l_prtn_elig_prfl_id, 70);

566: ,p_object_version_number => l_prtn_ovn
567: ,p_effective_date => l_effective_date
568: ,p_datetrack_mode => p_datetrack_mode);
569: --
570: hr_utility.set_location(l_proc||'/'||l_prtn_elig_prfl_id, 70);
571: --
572: END;
573: */
574: --

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

631: -- End of API User Hook for the after hook of update_entitlement_line
632: --
633: END;
634: --
635: hr_utility.set_location(l_proc, 60);
636: --
637: -- When in validation only mode RAISE the Validate_Enabled EXCEPTION
638: --
639: IF p_validate THEN

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

645: p_object_version_number := l_object_version_number;
646: p_effective_start_date := l_effective_start_date;
647: p_effective_END_date := l_effective_END_date;
648: --
649: hr_utility.set_location(' Leaving:'||l_proc, 70);
650: --
651: EXCEPTION
652: --
653: WHEN hr_api.validate_enabled THEN

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

660: -- Only set output warning arguments
661: -- (Any key or derived arguments must be set to null
662: -- WHEN validation only mode is being used.)
663: --
664: hr_utility.set_location(' Leaving:'||l_proc, 80);
665: --
666: WHEN others THEN
667: --
668: -- A validation or unexpected error has occured

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

726: l_prtn_elig_prfl_ovn NUMBER;
727: --
728: BEGIN
729: --
730: hr_utility.set_location('Entering:'|| l_proc, 10);
731: --
732: -- Issue a SAVEPOINT IF operating in validation only mode
733: --
734: SAVEPOINT delete_entitlement_line;

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

732: -- Issue a SAVEPOINT IF operating in validation only mode
733: --
734: SAVEPOINT delete_entitlement_line;
735: --
736: hr_utility.set_location(l_proc, 20);
737: --
738: -- Process Logic
739: --
740: l_object_version_number := p_object_version_number;

Line 779: hr_utility.set_location(l_proc, 30);

775: --
776: -- Delete option in plans created
777: -- for the entitlement line
778: --
779: hr_utility.set_location(l_proc, 30);
780: --
781: OPEN csr_oipl_details;
782: FETCH csr_oipl_details INTO l_oipl_id
783: ,l_oipl_ovn

Line 793: hr_utility.set_location(l_proc||'/'||

789: IF csr_oipl_details%FOUND THEN
790: --
791: CLOSE csr_oipl_details;
792: --
793: hr_utility.set_location(l_proc||'/'||
794: l_prtn_elig_prfl_id||'/'||
795: l_prtn_elig_prfl_ovn, 40);
796: --
797: ben_prtn_elig_prfl_api.delete_prtn_elig_prfl

Line 806: hr_utility.set_location(l_proc||'/'||

802: ,p_object_version_number => l_prtn_elig_prfl_ovn
803: ,p_effective_date => p_effective_Date
804: ,p_datetrack_mode => p_datetrack_mode);
805: --
806: hr_utility.set_location(l_proc||'/'||
807: l_prtn_elig_id||'/'||
808: l_prtn_elig_ovn, 50);
809: --
810: ben_participation_elig_api.delete_participation_elig

Line 819: hr_utility.set_location(l_proc||'/'||

815: ,p_object_version_number => l_prtn_elig_ovn
816: ,p_effective_date => p_effective_date
817: ,p_datetrack_mode => p_datetrack_mode);
818: --
819: hr_utility.set_location(l_proc||'/'||
820: l_oipl_id||'/'||
821: l_oipl_ovn, 60);
822: --
823: ben_option_in_plan_api.delete_option_in_plan

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

868: -- End of API User Hook for the after hook of delete_entitlement_line
869: --
870: END;
871: --
872: hr_utility.set_location(l_proc, 60);
873: --
874: -- When in validation only mode RAISE the Validate_Enabled EXCEPTION
875: --
876: IF p_validate THEN

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

876: IF p_validate THEN
877: RAISE hr_api.validate_enabled;
878: END IF;
879: --
880: hr_utility.set_location(' Leaving:'||l_proc, 70);
881: --
882: EXCEPTION
883: --
884: WHEN hr_api.validate_enabled THEN

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

932: l_validation_END_date DATE;
933: --
934: BEGIN
935: --
936: hr_utility.set_location('Entering:'|| l_proc, 10);
937: --
938: per_pcl_shd.lck
939: (
940: p_cagr_entitlement_line_id => p_cagr_entitlement_line_id

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

944: ,p_effective_date => p_effective_date
945: ,p_datetrack_mode => p_datetrack_mode
946: );
947: --
948: hr_utility.set_location(' Leaving:'||l_proc, 70);
949: --
950: END lck;
951: --
952: END hr_cagr_ent_lines_api;