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_GRADES_API dependencies on HR_UTILITY

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

36: l_proc varchar2(72) := g_package||'update_concat_segs_auto';
37: --
38: begin
39: --
40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: --
42: open csr_cagr_lock;
43: fetch csr_cagr_lock into l_exists;
44: if csr_cagr_lock%found then

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

43: fetch csr_cagr_lock into l_exists;
44: if csr_cagr_lock%found then
45: close csr_cagr_lock;
46: --
47: hr_utility.set_location(l_proc, 20);
48: --
49: UPDATE per_cagr_grades_def
50: SET concatenated_segments = p_concatenated_segments
51: WHERE cagr_grade_def_id = p_cagr_grade_def_id;

Line 59: hr_utility.set_location('Leaving:'|| l_proc, 30);

55: close csr_cagr_lock;
56: rollback; -- Added for bug 3578845.
57: end if;
58: --
59: hr_utility.set_location('Leaving:'|| l_proc, 30);
60: --
61: Exception
62: When HR_Api.Object_Locked then
63: rollback; -- Added for bug 3578845.

Line 64: hr_utility.set_location('Leaving:'|| l_proc, 40);

60: --
61: Exception
62: When HR_Api.Object_Locked then
63: rollback; -- Added for bug 3578845.
64: hr_utility.set_location('Leaving:'|| l_proc, 40);
65: end update_concat_segs_auto;
66: --
67: BEGIN
68: --

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

65: end update_concat_segs_auto;
66: --
67: BEGIN
68: --
69: hr_utility.set_location('Entering:'|| l_proc, 10);
70: --
71: OPEN get_concat_segs;
72: FETCH get_concat_segs INTO l_concat_segments;
73: if get_concat_segs%found then

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

76: l_cagr_found := 'N';
77: end if;
78: CLOSE get_concat_segs;
79: --
80: hr_utility.set_location(l_proc,20);
81: --
82: IF (l_concat_segments <> p_concatenated_segments) OR
83: (l_concat_segments IS NULL AND p_concatenated_segments IS NOT NULL) THEN
84: --

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

81: --
82: IF (l_concat_segments <> p_concatenated_segments) OR
83: (l_concat_segments IS NULL AND p_concatenated_segments IS NOT NULL) THEN
84: --
85: hr_utility.set_location(l_proc, 30);
86: --
87: if l_cagr_found = 'Y' then
88: update_concat_segs_auto(p_cagr_grade_def_id);
89: end if;

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

89: end if;
90: --
91: END IF;
92: --
93: hr_utility.set_location('Leaving:'|| l_proc, 999);
94: --
95: end update_concat_segs;
96: --
97: -- ----------------------------------------------------------------------------

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

199: where cagr_grade_def_id = l_cagr_grade_def_id;
200: --
201: begin
202: --
203: hr_utility.set_location('Entering:'|| l_proc, 10);
204: --
205: -- Issue a savepoint if operating in validation only mode
206: --
207: savepoint create_cagr_grades;

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

205: -- Issue a savepoint if operating in validation only mode
206: --
207: savepoint create_cagr_grades;
208: --
209: hr_utility.set_location(l_proc, 20);
210: --
211: if l_cagr_grade_def_id is not null
212: --
213: then

Line 215: hr_utility.set_location(l_proc, 15);

211: if l_cagr_grade_def_id is not null
212: --
213: then
214: --
215: hr_utility.set_location(l_proc, 15);
216: --
217: -- set indicator to show p_cagr_grade_def_id did not enter pgm null
218: --
219: l_null_ind := 1;

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

243: if c_segments%NOTFOUND OR c_segments%NOTFOUND IS NULL
244: then
245: l_cagr_grade_def_id := NULL;
246: l_null_ind := 0;
247: hr_utility.set_location(l_proc, 27);
248: end if;
249: close c_segments;
250: end if;
251: --

Line 304: hr_utility.set_message(800,'PER_52810_INVALID_STRUCTURE');

300: fetch csr_id_flex_num
301: into l_id_flex_num;
302: if csr_id_flex_num%NOTFOUND then
303: close csr_id_flex_num;
304: hr_utility.set_message(800,'PER_52810_INVALID_STRUCTURE');
305: hr_utility.raise_error;
306: end if;
307: close csr_id_flex_num;
308: --

Line 305: hr_utility.raise_error;

301: into l_id_flex_num;
302: if csr_id_flex_num%NOTFOUND then
303: close csr_id_flex_num;
304: hr_utility.set_message(800,'PER_52810_INVALID_STRUCTURE');
305: hr_utility.raise_error;
306: end if;
307: close csr_id_flex_num;
308: --
309: hr_utility.set_location(l_proc, 30);

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

305: hr_utility.raise_error;
306: end if;
307: close csr_id_flex_num;
308: --
309: hr_utility.set_location(l_proc, 30);
310: --
311: if l_cagr_grade_def_id is null then
312: l_null_ind := 0;
313: --

Line 314: hr_utility.set_location(l_proc, 37);

310: --
311: if l_cagr_grade_def_id is null then
312: l_null_ind := 0;
313: --
314: hr_utility.set_location(l_proc, 37);
315: --
316: --
317: -- Determine the Grade defintion by calling ins_or_sel
318: --

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

344: ,p_ccid => l_cagr_grade_def_id
345: ,p_concat_segments_out => l_name
346: );
347: --
348: hr_utility.set_location(l_proc, 40);
349: --
350: -- Added as part of fix for bug 2126247
351: --
352: -- Updates the concatenated segments for the new

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

355: update_concat_segs
356: (p_cagr_grade_def_id => l_cagr_grade_def_id
357: ,p_concatenated_segments => l_name);
358: --
359: hr_utility.set_location(l_proc, 50);
360: --
361: end if;
362: --
363: per_gra_ins.ins

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

413: end;
414: --
415: -- End of API User Hook for the after hook of create_cagr_grades
416: --
417: hr_utility.set_location(l_proc, 60);
418: --
419: -- When in validation only mode raise the Validate_Enabled exception
420: --
421: if p_validate then

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

428: p_cagr_grade_def_id := l_cagr_grade_def_id;
429: p_object_version_number := l_object_version_number;
430: p_name := l_name;
431: --
432: hr_utility.set_location(' Leaving:'||l_proc, 70);
433: --
434: exception
435: --
436: when hr_api.validate_enabled then

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

450: p_cagr_grade_def_id := null;
451: end if;
452: p_object_version_number := null;
453: p_name := null;
454: hr_utility.set_location(' Leaving:'||l_proc, 80);
455: --
456: when others then
457: --
458: -- A validation or unexpected error has occured

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

576: where cagr_grade_def_id = l_cagr_grade_def_id;
577: --
578: BEGIN
579: --
580: hr_utility.set_location('Entering:'|| l_proc, 10);
581: --
582: --
583: -- Issue a savepoint if operating in validation only mode
584: --

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

583: -- Issue a savepoint if operating in validation only mode
584: --
585: savepoint update_cagr_grades;
586: --
587: hr_utility.set_location(l_proc, 20);
588: --
589: -- Process Logic
590: --
591: l_object_version_number := p_object_version_number;

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

595: -- set indicator to show p_cagr_grade_def_id did not enter pgm null
596: --
597: if l_cagr_grade_def_id is not null then
598: --
599: hr_utility.set_location(l_proc, 30);
600: --
601: -- set indicator to show p_competence_definition_id did not enter pgm null
602: --
603: l_null_ind := 1;

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

629: --
630: l_cagr_grade_def_id := NULL;
631: l_null_ind := 0;
632: --
633: hr_utility.set_location(l_proc, 40);
634: --
635: end if;
636: --
637: close c_segments;

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

680: -- End of API User Hook for the before hook of update_cagr_grades
681: --
682: end;
683: --
684: hr_utility.set_location(l_proc, 50);
685: --
686: -- Populate l_id_flex_num.
687: --
688: open csr_id_flex_num;

Line 695: hr_utility.set_message(800, 'PER_52617_INVALID_GRADE');

691: if csr_id_flex_num%NOTFOUND then
692: --
693: close csr_id_flex_num;
694: --
695: hr_utility.set_message(800, 'PER_52617_INVALID_GRADE');
696: hr_utility.raise_error;
697: --
698: end if;
699: --

Line 696: hr_utility.raise_error;

692: --
693: close csr_id_flex_num;
694: --
695: hr_utility.set_message(800, 'PER_52617_INVALID_GRADE');
696: hr_utility.raise_error;
697: --
698: end if;
699: --
700: close csr_id_flex_num;

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

698: end if;
699: --
700: close csr_id_flex_num;
701: --
702: hr_utility.set_location(l_proc, 60);
703: --
704: -- 2284889
705: -- update cagr grades definitions in per_cagr_grades_def if
706: -- p_cagr_grade_def_id had no value when passed into program

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

706: -- p_cagr_grade_def_id had no value when passed into program
707: --
708: if l_null_ind = 0 OR l_segments_changed = TRUE then
709: --
710: hr_utility.set_location(l_proc, 70);
711: --
712: -- Maintain the collective agreement key flexfields.
713: --
714: hr_kflex_utility.upd_or_sel_keyflex_comb

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

738: ,p_concat_segments_in => p_concat_segments
739: ,p_ccid => l_cagr_grade_def_id
740: ,p_concat_segments_out => l_name);
741: --
742: hr_utility.set_location(l_proc, 80);
743: --
744: end if;
745: --
746: -- Added as part of fix for bug 2126247

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

751: update_concat_segs
752: (p_cagr_grade_def_id => l_cagr_grade_def_id
753: ,p_concatenated_segments => l_name);
754: --
755: hr_utility.set_location(l_proc, 90);
756: --
757: per_gra_upd.upd
758: (p_cagr_grade_id => p_cagr_grade_id
759: ,p_cagr_grade_def_id => l_cagr_grade_def_id

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

805: -- End of API User Hook for the after hook of update_cagr_grades
806: --
807: end;
808: --
809: hr_utility.set_location(l_proc, 100);
810: --
811: -- When in validation only mode raise the Validate_Enabled exception
812: --
813: if p_validate then

Line 823: hr_utility.set_location(' Leaving:'||l_proc, 997);

819: p_object_version_number := l_object_version_number;
820: p_name := l_name;
821: p_cagr_grade_def_id := l_cagr_grade_def_id;
822: --
823: hr_utility.set_location(' Leaving:'||l_proc, 997);
824: --
825: exception
826: --
827: when hr_api.validate_enabled then

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

825: exception
826: --
827: when hr_api.validate_enabled then
828: --
829: hr_utility.set_location(' Leaving:'||l_proc, 998);
830: --
831: -- As the Validate_Enabled exception has been raised
832: -- we must rollback to the savepoint
833: --

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

845: end if;
846: --
847: when others then
848: --
849: hr_utility.set_location(' Leaving:'||l_proc, 999);
850: --
851: -- A validation or unexpected error has occured
852: --
853: ROLLBACK TO update_cagr_grades;

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

878: l_ovn per_cagr_grades.object_version_number%TYPE := p_object_version_number;
879: --
880: begin
881: --
882: hr_utility.set_location('Entering:'|| l_proc, 10);
883: --
884: -- Issue a savepoint if operating in validation only mode
885: --
886: savepoint delete_cagr_grades;

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

884: -- Issue a savepoint if operating in validation only mode
885: --
886: savepoint delete_cagr_grades;
887: --
888: hr_utility.set_location(l_proc, 20);
889: --
890: -- Process Logic
891: --
892: l_object_version_number := p_object_version_number;

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

939: -- End of API User Hook for the after hook of delete_cagr_grades
940: --
941: end;
942: --
943: hr_utility.set_location(l_proc, 60);
944: --
945: -- When in validation only mode raise the Validate_Enabled exception
946: --
947: if p_validate then

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

951: -- Set all output arguments
952: --
953: p_object_version_number := l_object_version_number;
954: --
955: hr_utility.set_location(' Leaving:'||l_proc, 70);
956: --
957: exception
958: --
959: when hr_api.validate_enabled then

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

998: l_proc varchar2(72) := g_package||'lck';
999: --
1000: begin
1001: --
1002: hr_utility.set_location('Entering:'|| l_proc, 10);
1003: --
1004: per_gra_shd.lck
1005: (
1006: p_cagr_grade_id => p_cagr_grade_id

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

1007: ,p_object_version_number => p_object_version_number
1008: ,p_effective_date => trunc(p_effective_date)
1009: );
1010: --
1011: hr_utility.set_location(' Leaving:'||l_proc, 70);
1012: --
1013: end lck;
1014: --
1015: end hr_cagr_grades_api;