DBA Data[Home] [Help]

APPS.HR_ENTRY_DISPLAY dependencies on HR_UTILITY

Line 117: hr_utility.set_location('hr_entry_display.count_input_values', 1);

113: ) is
114: --
115: begin
116: --
117: hr_utility.set_location('hr_entry_display.count_input_values', 1);
118: --
119: -- Need to determine how many input values have been defined for the element.
120: -- This value is used to control a loop which is used to select each input
121: -- value definition in the correct order a row at a time.

Line 183: hr_utility.set_location('hr_entry_display.get_input_value_details', 1);

179: v_lookup_type varchar2(30);
180: --
181: begin
182: --
183: hr_utility.set_location('hr_entry_display.get_input_value_details', 1);
184: --
185: -- Select the input_value_id of the required input value as specified
186: -- by the ordering criteria.
187: -- The inner sub-query works by selecting the minimum order sequence of

Line 252: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

248: NVL(p_input_value_id5,0),
249: NVL(p_input_value_id6,0))));
250: exception
251: when NO_DATA_FOUND then
252: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
253: hr_utility.set_message_token('PROCEDURE',
254: 'hr_entry_display.get_input_value_details');
255: hr_utility.set_message_token('STEP','2');
256: hr_utility.raise_error;

Line 253: hr_utility.set_message_token('PROCEDURE',

249: NVL(p_input_value_id6,0))));
250: exception
251: when NO_DATA_FOUND then
252: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
253: hr_utility.set_message_token('PROCEDURE',
254: 'hr_entry_display.get_input_value_details');
255: hr_utility.set_message_token('STEP','2');
256: hr_utility.raise_error;
257: end;

Line 255: hr_utility.set_message_token('STEP','2');

251: when NO_DATA_FOUND then
252: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
253: hr_utility.set_message_token('PROCEDURE',
254: 'hr_entry_display.get_input_value_details');
255: hr_utility.set_message_token('STEP','2');
256: hr_utility.raise_error;
257: end;
258: --
259: p_input_value_id := v_select_input_value_id;

Line 256: hr_utility.raise_error;

252: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
253: hr_utility.set_message_token('PROCEDURE',
254: 'hr_entry_display.get_input_value_details');
255: hr_utility.set_message_token('STEP','2');
256: hr_utility.raise_error;
257: end;
258: --
259: p_input_value_id := v_select_input_value_id;
260: p_hot_default_flag := v_hot_default_flag;

Line 269: hr_utility.set_location('hr_entry_display.get_input_value_details', 3);

265: -- details the entry value can now be selected provided the element entry id
266: -- exists.
267: if p_element_entry_id is not null then
268: --
269: hr_utility.set_location('hr_entry_display.get_input_value_details', 3);
270: begin
271: SELECT HEEV1.SCREEN_ENTRY_VALUE
272: INTO v_database_format_value
273: FROM PAY_ELEMENT_ENTRY_VALUES_F HEEV1

Line 280: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

276: AND p_session_date
277: BETWEEN HEEV1.EFFECTIVE_START_DATE AND HEEV1.EFFECTIVE_END_DATE;
278: exception
279: when NO_DATA_FOUND then
280: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
281: hr_utility.set_message_token('PROCEDURE',
282: 'hr_entry_display.get_input_value_details');
283: hr_utility.set_message_token('STEP','3');
284: hr_utility.raise_error;

Line 281: hr_utility.set_message_token('PROCEDURE',

277: BETWEEN HEEV1.EFFECTIVE_START_DATE AND HEEV1.EFFECTIVE_END_DATE;
278: exception
279: when NO_DATA_FOUND then
280: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
281: hr_utility.set_message_token('PROCEDURE',
282: 'hr_entry_display.get_input_value_details');
283: hr_utility.set_message_token('STEP','3');
284: hr_utility.raise_error;
285: end;

Line 283: hr_utility.set_message_token('STEP','3');

279: when NO_DATA_FOUND then
280: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
281: hr_utility.set_message_token('PROCEDURE',
282: 'hr_entry_display.get_input_value_details');
283: hr_utility.set_message_token('STEP','3');
284: hr_utility.raise_error;
285: end;
286: end if;
287: --

Line 284: hr_utility.raise_error;

280: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
281: hr_utility.set_message_token('PROCEDURE',
282: 'hr_entry_display.get_input_value_details');
283: hr_utility.set_message_token('STEP','3');
284: hr_utility.raise_error;
285: end;
286: end if;
287: --
288: -- derive default value.

Line 314: hr_utility.set_location('hr_entry_display.get_input_value_details', 4);

310: elsif v_database_format_value is not null then
311: --
312: if v_lookup_type is not null then
313: --
314: hr_utility.set_location('hr_entry_display.get_input_value_details', 4);
315: begin
316: select h.meaning
317: into v_screen_format_value
318: from hr_lookups h

Line 323: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

319: where h.lookup_type = v_lookup_type
320: and h.lookup_code = v_database_format_value;
321: exception
322: when NO_DATA_FOUND then
323: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
324: hr_utility.set_message_token('PROCEDURE',
325: 'hr_entry_display.get_input_value_details');
326: hr_utility.set_message_token('STEP','4');
327: hr_utility.raise_error;

Line 324: hr_utility.set_message_token('PROCEDURE',

320: and h.lookup_code = v_database_format_value;
321: exception
322: when NO_DATA_FOUND then
323: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
324: hr_utility.set_message_token('PROCEDURE',
325: 'hr_entry_display.get_input_value_details');
326: hr_utility.set_message_token('STEP','4');
327: hr_utility.raise_error;
328: end;

Line 326: hr_utility.set_message_token('STEP','4');

322: when NO_DATA_FOUND then
323: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
324: hr_utility.set_message_token('PROCEDURE',
325: 'hr_entry_display.get_input_value_details');
326: hr_utility.set_message_token('STEP','4');
327: hr_utility.raise_error;
328: end;
329: --
330: else

Line 327: hr_utility.raise_error;

323: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
324: hr_utility.set_message_token('PROCEDURE',
325: 'hr_entry_display.get_input_value_details');
326: hr_utility.set_message_token('STEP','4');
327: hr_utility.raise_error;
328: end;
329: --
330: else
331: --