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

Line 45: -- hr_utility.trace_on;

41: AND ccb.accept_reject_flag = 'ACC';
42: --
43: BEGIN
44: --
45: -- hr_utility.trace_on;
46: --
47: hr_utility.set_location('hr_ben_chk_cobra_reference', 0);
48: --
49: --

Line 47: hr_utility.set_location('hr_ben_chk_cobra_reference', 0);

43: BEGIN
44: --
45: -- hr_utility.trace_on;
46: --
47: hr_utility.set_location('hr_ben_chk_cobra_reference', 0);
48: --
49: --
50: -- execute cursor
51: --

Line 54: hr_utility.set_location('hr_ben_chk_cobra_reference', 1);

50: -- execute cursor
51: --
52: OPEN chk_cobra_ref_exists;
53: --
54: hr_utility.set_location('hr_ben_chk_cobra_reference', 1);
55: --
56: FETCH chk_cobra_ref_exists INTO l_coverage_exists;
57: --
58: hr_utility.set_location('hr_ben_chk_cobra_reference', 2);

Line 58: hr_utility.set_location('hr_ben_chk_cobra_reference', 2);

54: hr_utility.set_location('hr_ben_chk_cobra_reference', 1);
55: --
56: FETCH chk_cobra_ref_exists INTO l_coverage_exists;
57: --
58: hr_utility.set_location('hr_ben_chk_cobra_reference', 2);
59: --
60: CLOSE chk_cobra_ref_exists;
61: --
62: hr_utility.set_location('hr_ben_chk_cobra_reference', 3);

Line 62: hr_utility.set_location('hr_ben_chk_cobra_reference', 3);

58: hr_utility.set_location('hr_ben_chk_cobra_reference', 2);
59: --
60: CLOSE chk_cobra_ref_exists;
61: --
62: hr_utility.set_location('hr_ben_chk_cobra_reference', 3);
63: --
64: --
65: -- chk to see if element referenced
66: --

Line 70: hr_utility.set_location('hr_ben_chk_cobra_reference', 4);

66: --
67: IF(l_coverage_exists = 'Y')
68: THEN
69: --
70: hr_utility.set_location('hr_ben_chk_cobra_reference', 4);
71: --
72: -- return true if referenced
73: RETURN TRUE;
74: ELSE

Line 76: hr_utility.set_location('hr_ben_chk_cobra_reference', 5);

72: -- return true if referenced
73: RETURN TRUE;
74: ELSE
75: --
76: hr_utility.set_location('hr_ben_chk_cobra_reference', 5);
77: --
78: -- return false as it is not referenced
79: RETURN FALSE;
80: END IF;

Line 164: hr_utility.set_location('hr_bc_pre_update', 1);

160: --
161: local_warning exception;
162: BEGIN
163: --
164: hr_utility.set_location('hr_bc_pre_update', 1);
165: --
166: hr_ben_benefit_contributions.hr_ben_chk_duplicate_cont
167: ( p_benefit_contribution_id,
168: p_element_type_id,

Line 176: hr_utility.set_location('hr_bc_pre_update', 2);

172: p_business_group_id );
173: --
174: -- Call chk for COBRA reference
175: --
176: hr_utility.set_location('hr_bc_pre_update', 2);
177: --
178: IF(hrbeebc.hr_ben_chk_cobra_reference(p_business_group_id,
179: p_element_type_id,
180: p_coverage_type))

Line 183: hr_utility.set_location('hr_bc_pre_update', 3);

179: p_element_type_id,
180: p_coverage_type))
181: THEN
182: --
183: hr_utility.set_location('hr_bc_pre_update', 3);
184: --
185: -- raise warning
186: hr_utility.set_message(801, 'HR_BEN_COBRA_REFERENCE');
187: raise local_warning;

Line 186: hr_utility.set_message(801, 'HR_BEN_COBRA_REFERENCE');

182: --
183: hr_utility.set_location('hr_bc_pre_update', 3);
184: --
185: -- raise warning
186: hr_utility.set_message(801, 'HR_BEN_COBRA_REFERENCE');
187: raise local_warning;
188: --
189: END IF;
190: --

Line 191: hr_utility.set_location('hr_bc_pre_update', 4);

187: raise local_warning;
188: --
189: END IF;
190: --
191: hr_utility.set_location('hr_bc_pre_update', 4);
192: --
193: exception
194: when local_warning then
195: hr_utility.set_warning;

Line 195: hr_utility.set_warning;

191: hr_utility.set_location('hr_bc_pre_update', 4);
192: --
193: exception
194: when local_warning then
195: hr_utility.set_warning;
196: --
197: hr_utility.set_location('hr_bc_pre_update', 5);
198: --
199: END hr_ben_bc_pre_update;

Line 197: hr_utility.set_location('hr_bc_pre_update', 5);

193: exception
194: when local_warning then
195: hr_utility.set_warning;
196: --
197: hr_utility.set_location('hr_bc_pre_update', 5);
198: --
199: END hr_ben_bc_pre_update;
200: --
201: --

Line 225: -- hr_utility.trace_on;

221: p_validation_end_date DATE,
222: p_element_effective_start_date DATE) IS
223: BEGIN
224: --
225: -- hr_utility.trace_on;
226: --
227: -- Call referential integrity checks
228: --
229: hr_utility.set_location('hr_ben_bc_pre_delete', 0);

Line 229: hr_utility.set_location('hr_ben_bc_pre_delete', 0);

225: -- hr_utility.trace_on;
226: --
227: -- Call referential integrity checks
228: --
229: hr_utility.set_location('hr_ben_bc_pre_delete', 0);
230: --
231: hr_ben_benefit_contributions.hr_ben_ref_chk
232: ( p_element_type_id,
233: p_iv_er_id,

Line 241: hr_utility.set_location('hr_ben_bc_pre_delete', 2);

237: p_validation_start_date,
238: p_validation_end_date,
239: p_element_effective_start_date);
240: --
241: hr_utility.set_location('hr_ben_bc_pre_delete', 2);
242: --
243: -- end of procedure/function definitions
244: --
245: END hr_ben_bc_pre_delete;