DBA Data[Home] [Help]

APPS.HR_RU_UTILITY dependencies on HR_UTILITY

Line 23: hr_utility.set_message (800, 'HR_7209_API_LOOK_INVALID');

19: p_argument_value
20: )
21: )
22: THEN
23: hr_utility.set_message (800, 'HR_7209_API_LOOK_INVALID');
24: hr_utility.set_message_token ('ARGUMENT', p_argument);
25: hr_utility.raise_error;
26: END IF;
27: --

Line 24: hr_utility.set_message_token ('ARGUMENT', p_argument);

20: )
21: )
22: THEN
23: hr_utility.set_message (800, 'HR_7209_API_LOOK_INVALID');
24: hr_utility.set_message_token ('ARGUMENT', p_argument);
25: hr_utility.raise_error;
26: END IF;
27: --
28: END check_lookup_value;

Line 25: hr_utility.raise_error;

21: )
22: THEN
23: hr_utility.set_message (800, 'HR_7209_API_LOOK_INVALID');
24: hr_utility.set_message_token ('ARGUMENT', p_argument);
25: hr_utility.raise_error;
26: END IF;
27: --
28: END check_lookup_value;
29:

Line 203: hr_utility.set_message (801, 'HR_NI_UNIQUE_WARNING');

199:
200: --
201: IF l_status = 'Y'
202: THEN
203: hr_utility.set_message (801, 'HR_NI_UNIQUE_WARNING');
204: hr_utility.set_message_token ('NI_NUMBER'
205: ,hr_general.decode_lookup ('RU_FORM_LABELS', 'SPIFN')
206: );
207: hr_utility.set_warning;

Line 204: hr_utility.set_message_token ('NI_NUMBER'

200: --
201: IF l_status = 'Y'
202: THEN
203: hr_utility.set_message (801, 'HR_NI_UNIQUE_WARNING');
204: hr_utility.set_message_token ('NI_NUMBER'
205: ,hr_general.decode_lookup ('RU_FORM_LABELS', 'SPIFN')
206: );
207: hr_utility.set_warning;
208: END IF;

Line 207: hr_utility.set_warning;

203: hr_utility.set_message (801, 'HR_NI_UNIQUE_WARNING');
204: hr_utility.set_message_token ('NI_NUMBER'
205: ,hr_general.decode_lookup ('RU_FORM_LABELS', 'SPIFN')
206: );
207: hr_utility.set_warning;
208: END IF;
209: --
210: EXCEPTION
211: WHEN no_data_found

Line 273: /* hr_utility.set_message (800, 'HR_RU_INVALID_SPIF_NUMBER');

269: LOOP
270: IF (l_outputs (l_out_cnt).NAME = 'RETURN_VALUE')
271: AND (l_outputs (l_out_cnt).VALUE = 'INVALID_ID')
272: THEN
273: /* hr_utility.set_message (800, 'HR_RU_INVALID_SPIF_NUMBER');
274: hr_utility.set_message_token
275: ('NUMBER',
276: hr_general.decode_lookup ('RU_FORM_LABELS',
277: 'SPIFN'

Line 274: hr_utility.set_message_token

270: IF (l_outputs (l_out_cnt).NAME = 'RETURN_VALUE')
271: AND (l_outputs (l_out_cnt).VALUE = 'INVALID_ID')
272: THEN
273: /* hr_utility.set_message (800, 'HR_RU_INVALID_SPIF_NUMBER');
274: hr_utility.set_message_token
275: ('NUMBER',
276: hr_general.decode_lookup ('RU_FORM_LABELS',
277: 'SPIFN'
278: )

Line 280: hr_utility.raise_error;*/

276: hr_general.decode_lookup ('RU_FORM_LABELS',
277: 'SPIFN'
278: )
279: );
280: hr_utility.raise_error;*/
281: l_err := 1;
282: END IF;
283: END LOOP;
284: ELSE

Line 285: /*hr_utility.set_message (800, 'HR_RU_SPIFN_FORMULA_ERROR');

281: l_err := 1;
282: END IF;
283: END LOOP;
284: ELSE
285: /*hr_utility.set_message (800, 'HR_RU_SPIFN_FORMULA_ERROR');
286: hr_utility.raise_error;*/
287: l_err := 2;
288: END IF;
289:

Line 286: hr_utility.raise_error;*/

282: END IF;
283: END LOOP;
284: ELSE
285: /*hr_utility.set_message (800, 'HR_RU_SPIFN_FORMULA_ERROR');
286: hr_utility.raise_error;*/
287: l_err := 2;
288: END IF;
289:
290: CLOSE csr_formula;

Line 296: /*hr_utility.set_message (800, 'HR_RU_SPIFN_FORMULA_ERROR');

292: RETURN l_err;
293: EXCEPTION
294: WHEN no_data_found
295: THEN
296: /*hr_utility.set_message (800, 'HR_RU_SPIFN_FORMULA_ERROR');
297: hr_utility.raise_error;*/
298: l_err := 2;
299: RETURN l_err;
300: END validate_spifn;

Line 297: hr_utility.raise_error;*/

293: EXCEPTION
294: WHEN no_data_found
295: THEN
296: /*hr_utility.set_message (800, 'HR_RU_SPIFN_FORMULA_ERROR');
297: hr_utility.raise_error;*/
298: l_err := 2;
299: RETURN l_err;
300: END validate_spifn;
301:

Line 314: hr_utility.set_message (800, 'HR_RU_INVALID_MIL_REG_CODE');

310: BEGIN
311: l_len := LENGTH (p_military_reg_board_code);
312: IF (l_len <> 7) AND (l_len <> 6)
313: THEN
314: hr_utility.set_message (800, 'HR_RU_INVALID_MIL_REG_CODE');
315: hr_utility.set_warning;
316: ELSE
317: SELECT translate (p_military_reg_board_code, '0123456789', ' ')
318: INTO l_tmp

Line 315: hr_utility.set_warning;

311: l_len := LENGTH (p_military_reg_board_code);
312: IF (l_len <> 7) AND (l_len <> 6)
313: THEN
314: hr_utility.set_message (800, 'HR_RU_INVALID_MIL_REG_CODE');
315: hr_utility.set_warning;
316: ELSE
317: SELECT translate (p_military_reg_board_code, '0123456789', ' ')
318: INTO l_tmp
319: FROM dual;

Line 322: hr_utility.set_message (800, 'HR_RU_INVALID_MIL_REG_CODE');

318: INTO l_tmp
319: FROM dual;
320: IF (l_len =7 AND (l_tmp IS NULL OR hr_ni_chk_pkg.chk_nat_id_format(l_tmp,'A') = '0' )) OR (l_len=6 AND l_tmp IS NOT NULL)
321: THEN
322: hr_utility.set_message (800, 'HR_RU_INVALID_MIL_REG_CODE');
323: hr_utility.set_warning;
324: END IF;
325: END IF;
326: END validate_mil_reg_board_code;

Line 323: hr_utility.set_warning;

319: FROM dual;
320: IF (l_len =7 AND (l_tmp IS NULL OR hr_ni_chk_pkg.chk_nat_id_format(l_tmp,'A') = '0' )) OR (l_len=6 AND l_tmp IS NOT NULL)
321: THEN
322: hr_utility.set_message (800, 'HR_RU_INVALID_MIL_REG_CODE');
323: hr_utility.set_warning;
324: END IF;
325: END IF;
326: END validate_mil_reg_board_code;
327:

Line 494: hr_utility.set_message (800, 'HR_RU_INVALID_TAX_NO');

490:
491: --
492: IF l_status = 'Y'
493: THEN
494: hr_utility.set_message (800, 'HR_RU_INVALID_TAX_NO');
495: RETURN 0;
496: END IF;
497: RETURN 1;
498: END;