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

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

34: l_proc varchar2(80) := g_package||'get_age_change_life_event';
35: --
36: begin
37: --
38: hr_utility.set_location('Entering :'||l_proc,10);
39: --
40: open c1;
41: --
42: fetch c1 into l_ler_id;

Line 46: hr_utility.set_location('Leaving :'||l_proc,10);

42: fetch c1 into l_ler_id;
43: --
44: close c1;
45: --
46: hr_utility.set_location('Leaving :'||l_proc,10);
47: --
48: return l_ler_id;
49: --
50: end get_age_change_life_event;

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

66: l_proc varchar2(80) := g_package||'get_person_id';
67: --
68: begin
69: --
70: hr_utility.set_location('Entering :'||l_proc,10);
71: hr_utility.set_location('Assignment ID :'||p_assignment_id,10);
72: hr_utility.set_location('Effective Date :'||p_effective_date,10);
73: --
74: open c1;

Line 71: hr_utility.set_location('Assignment ID :'||p_assignment_id,10);

67: --
68: begin
69: --
70: hr_utility.set_location('Entering :'||l_proc,10);
71: hr_utility.set_location('Assignment ID :'||p_assignment_id,10);
72: hr_utility.set_location('Effective Date :'||p_effective_date,10);
73: --
74: open c1;
75: --

Line 72: hr_utility.set_location('Effective Date :'||p_effective_date,10);

68: begin
69: --
70: hr_utility.set_location('Entering :'||l_proc,10);
71: hr_utility.set_location('Assignment ID :'||p_assignment_id,10);
72: hr_utility.set_location('Effective Date :'||p_effective_date,10);
73: --
74: open c1;
75: --
76: fetch c1 into l_person_id;

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

76: fetch c1 into l_person_id;
77: --
78: close c1;
79: --
80: hr_utility.set_location('Leaving :'||l_proc,10);
81: --
82: hr_utility.set_location('Person ID :'||l_person_id,10);
83: return l_person_id;
84: --

Line 82: hr_utility.set_location('Person ID :'||l_person_id,10);

78: close c1;
79: --
80: hr_utility.set_location('Leaving :'||l_proc,10);
81: --
82: hr_utility.set_location('Person ID :'||l_person_id,10);
83: return l_person_id;
84: --
85: end get_person_id;
86: --

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

106: l_proc varchar2(80) := g_package||'get_spouses_age';
107: --
108: begin
109: --
110: hr_utility.set_location('Entering :'||l_proc,10);
111: hr_utility.set_location('p_contact_type :'||p_contact_type,10);
112: hr_utility.set_location('p_effective_date :'||p_effective_date,10);
113: hr_utility.set_location('p_person_id :'||p_person_id,10);
114: --

Line 111: hr_utility.set_location('p_contact_type :'||p_contact_type,10);

107: --
108: begin
109: --
110: hr_utility.set_location('Entering :'||l_proc,10);
111: hr_utility.set_location('p_contact_type :'||p_contact_type,10);
112: hr_utility.set_location('p_effective_date :'||p_effective_date,10);
113: hr_utility.set_location('p_person_id :'||p_person_id,10);
114: --
115: if p_contact_type = 'PS' then

Line 112: hr_utility.set_location('p_effective_date :'||p_effective_date,10);

108: begin
109: --
110: hr_utility.set_location('Entering :'||l_proc,10);
111: hr_utility.set_location('p_contact_type :'||p_contact_type,10);
112: hr_utility.set_location('p_effective_date :'||p_effective_date,10);
113: hr_utility.set_location('p_person_id :'||p_person_id,10);
114: --
115: if p_contact_type = 'PS' then
116: --

Line 113: hr_utility.set_location('p_person_id :'||p_person_id,10);

109: --
110: hr_utility.set_location('Entering :'||l_proc,10);
111: hr_utility.set_location('p_contact_type :'||p_contact_type,10);
112: hr_utility.set_location('p_effective_date :'||p_effective_date,10);
113: hr_utility.set_location('p_person_id :'||p_person_id,10);
114: --
115: if p_contact_type = 'PS' then
116: --
117: open c_per_spouse;

Line 125: hr_utility.set_location('Leaving :'||l_proc,10);

121: close c_per_spouse;
122: --
123: end if;
124: --
125: hr_utility.set_location('Leaving :'||l_proc,10);
126: hr_utility.set_location('dob :'||l_date_of_birth,10);
127: --
128: return l_date_of_birth;
129: --

Line 126: hr_utility.set_location('dob :'||l_date_of_birth,10);

122: --
123: end if;
124: --
125: hr_utility.set_location('Leaving :'||l_proc,10);
126: hr_utility.set_location('dob :'||l_date_of_birth,10);
127: --
128: return l_date_of_birth;
129: --
130: end get_spouses_age;

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

156: l_object_version_number number;
157: --
158: begin
159: --
160: hr_utility.set_location('Entering '||l_proc,10);
161: --
162: -- We only support contact types that we support through the derived age
163: -- factor form (BENFCTRS).
164: --

Line 180: hr_utility.set_location('Person ID is '||l_person_id,10);

176: --
177: l_person_id := get_person_id(p_assignment_id => p_assignment_id,
178: p_effective_date => p_effective_date);
179: --
180: hr_utility.set_location('Person ID is '||l_person_id,10);
181: --
182: -- Get the spouses date of birth
183: --
184: l_dob := get_spouses_age(p_person_id => l_person_id,

Line 190: hr_utility.set_location('Spouses Age is null',10);

186: p_effective_date => p_effective_date);
187: --
188: if l_dob is null then
189: --
190: hr_utility.set_location('Spouses Age is null',10);
191: return 'N';
192: --
193: end if;
194: --

Line 233: hr_utility.set_location('Leaving '||l_proc,10);

229: p_dtctd_dt => p_effective_date);
230: --
231: end if;
232: --
233: hr_utility.set_location('Leaving '||l_proc,10);
234: --
235: return 'Y';
236: --
237: end contact_valid;