DBA Data[Home] [Help]

APPS.HR_BEN_BENEFIT_CONTRIBUTIONS dependencies on HR_UTILITY

Line 54: hr_utility.set_message(801, 'HR_13107_BEN_DUPLICATE_CONT');

50: IF (l_contribution_exists = 'Y')
51: THEN
52: -- set message and raise exception
53: --
54: hr_utility.set_message(801, 'HR_13107_BEN_DUPLICATE_CONT');
55: hr_utility.raise_error;
56: --
57: END IF;
58: --

Line 55: hr_utility.raise_error;

51: THEN
52: -- set message and raise exception
53: --
54: hr_utility.set_message(801, 'HR_13107_BEN_DUPLICATE_CONT');
55: hr_utility.raise_error;
56: --
57: END IF;
58: --
59: END hr_ben_chk_duplicate_cont;

Line 116: hr_utility.set_location('hr_ben_chk_future_conts', 0);

112: AND bc.effective_end_date > p_effective_end_date;
113: --
114: BEGIN
115: --
116: hr_utility.set_location('hr_ben_chk_future_conts', 0);
117: --
118: --
119: -- execute cursor
120: --

Line 123: hr_utility.set_location('hr_ben_chk_future_conts', 1);

119: -- execute cursor
120: --
121: OPEN chk_future_contribution;
122: --
123: hr_utility.set_location('hr_ben_chk_future_conts', 1);
124: --
125: FETCH chk_future_contribution INTO l_contributions_exist;
126: --
127: hr_utility.set_location('hr_ben_chk_future_conts', 2);

Line 127: hr_utility.set_location('hr_ben_chk_future_conts', 2);

123: hr_utility.set_location('hr_ben_chk_future_conts', 1);
124: --
125: FETCH chk_future_contribution INTO l_contributions_exist;
126: --
127: hr_utility.set_location('hr_ben_chk_future_conts', 2);
128: --
129: CLOSE chk_future_contribution;
130: --
131: -- chk to see if future contributions exist

Line 136: hr_utility.set_location('hr_ben_chk_future_conts', 3);

132: --
133: IF(l_contributions_exist = 'N')
134: THEN
135: --
136: hr_utility.set_location('hr_ben_chk_future_conts', 3);
137: --
138: -- abort the delete - raise error
139: --
140: hr_utility.set_message(801, 'HR_13108_BEN_NO_FUTURE_CHNGE');

Line 140: hr_utility.set_message(801, 'HR_13108_BEN_NO_FUTURE_CHNGE');

136: hr_utility.set_location('hr_ben_chk_future_conts', 3);
137: --
138: -- abort the delete - raise error
139: --
140: hr_utility.set_message(801, 'HR_13108_BEN_NO_FUTURE_CHNGE');
141: hr_utility.raise_error;
142: --
143: END IF;
144: --

Line 141: hr_utility.raise_error;

137: --
138: -- abort the delete - raise error
139: --
140: hr_utility.set_message(801, 'HR_13108_BEN_NO_FUTURE_CHNGE');
141: hr_utility.raise_error;
142: --
143: END IF;
144: --
145: hr_utility.set_location('hr_ben_chk_future_conts', 5);

Line 145: hr_utility.set_location('hr_ben_chk_future_conts', 5);

141: hr_utility.raise_error;
142: --
143: END IF;
144: --
145: hr_utility.set_location('hr_ben_chk_future_conts', 5);
146: --
147: --
148: END hr_ben_chk_future_conts;
149: --

Line 309: hr_utility.set_location('hr_ben_ref_chk', 0);

305: );
306: --
307: BEGIN
308: --
309: hr_utility.set_location('hr_ben_ref_chk', 0);
310: --
311: --
312: -- check no elements exist
313: --

Line 318: hr_utility.set_location('hr_ben_ref_chk', 1);

314: OPEN get_element;
315: FETCH get_element INTO l_element_exists;
316: CLOSE get_element;
317: --
318: hr_utility.set_location('hr_ben_ref_chk', 1);
319: --
320: --
321: -- chk flag
322: --

Line 326: hr_utility.set_location('hr_ben_ref_chk', 2);

322: --
323: IF (l_element_exists = 'N')
324: THEN
325: --
326: hr_utility.set_location('hr_ben_ref_chk', 2);
327: --
328: --
329: -- error
330: --

Line 331: hr_utility.set_message(801, 'HR_13109_BEN_CHANGE_EXISTS');

327: --
328: --
329: -- error
330: --
331: hr_utility.set_message(801, 'HR_13109_BEN_CHANGE_EXISTS');
332: hr_utility.raise_error;
333: --
334: END IF;
335: --

Line 332: hr_utility.raise_error;

328: --
329: -- error
330: --
331: hr_utility.set_message(801, 'HR_13109_BEN_CHANGE_EXISTS');
332: hr_utility.raise_error;
333: --
334: END IF;
335: --
336: -- get iv_cov_id

Line 339: hr_utility.set_location('hr_ben_ref_chk', 3);

335: --
336: -- get iv_cov_id
337: --
338: --
339: hr_utility.set_location('hr_ben_ref_chk', 3);
340: --
341: OPEN get_coverage_input_value_id;
342: FETCH get_coverage_input_value_id INTO l_iv_cov_id;
343: CLOSE get_coverage_input_value_id;

Line 345: hr_utility.set_location('hr_ben_ref_chk', 4);

341: OPEN get_coverage_input_value_id;
342: FETCH get_coverage_input_value_id INTO l_iv_cov_id;
343: CLOSE get_coverage_input_value_id;
344: --
345: hr_utility.set_location('hr_ben_ref_chk', 4);
346: --
347: --
348: -- Examine DT delete mode to determine whether checking for ANY ee's
349: --

Line 356: hr_utility.set_location('hr_ben_ref_chk', 5);

352: --
353: -- check if referenced by ANY element entries
354: --
355: --
356: hr_utility.set_location('hr_ben_ref_chk', 5);
357: --
358: OPEN get_any_element_entries;
359: FETCH get_any_element_entries INTO l_element_entries_exist;
360: CLOSE get_any_element_entries;

Line 367: hr_utility.set_location('hr_ben_ref_chk', 6);

363: --
364: -- check if referenced by specific element entries
365: --
366: --
367: hr_utility.set_location('hr_ben_ref_chk', 6);
368: --
369: OPEN get_element_entries;
370: FETCH get_element_entries INTO l_element_entries_exist;
371: CLOSE get_element_entries;

Line 376: hr_utility.set_location('hr_ben_ref_chk', 7);

372: --
373: END IF;
374: --
375: --
376: hr_utility.set_location('hr_ben_ref_chk', 7);
377: --
378: IF( l_element_entries_exist = 'Y' )
379: THEN
380: --

Line 381: hr_utility.set_location('hr_ben_ref_chk', 8);

377: --
378: IF( l_element_entries_exist = 'Y' )
379: THEN
380: --
381: hr_utility.set_location('hr_ben_ref_chk', 8);
382: --
383: hr_utility.set_message(801, 'HR_7326_BEN_ELE_ENTRIES_EXIST');
384: hr_utility.raise_error;
385: END IF;

Line 383: hr_utility.set_message(801, 'HR_7326_BEN_ELE_ENTRIES_EXIST');

379: THEN
380: --
381: hr_utility.set_location('hr_ben_ref_chk', 8);
382: --
383: hr_utility.set_message(801, 'HR_7326_BEN_ELE_ENTRIES_EXIST');
384: hr_utility.raise_error;
385: END IF;
386: --
387: hr_utility.set_location('hr_ben_ref_chk', 9);

Line 384: hr_utility.raise_error;

380: --
381: hr_utility.set_location('hr_ben_ref_chk', 8);
382: --
383: hr_utility.set_message(801, 'HR_7326_BEN_ELE_ENTRIES_EXIST');
384: hr_utility.raise_error;
385: END IF;
386: --
387: hr_utility.set_location('hr_ben_ref_chk', 9);
388: --

Line 387: hr_utility.set_location('hr_ben_ref_chk', 9);

383: hr_utility.set_message(801, 'HR_7326_BEN_ELE_ENTRIES_EXIST');
384: hr_utility.raise_error;
385: END IF;
386: --
387: hr_utility.set_location('hr_ben_ref_chk', 9);
388: --
389: --
390: END hr_ben_ref_chk;
391: --