DBA Data[Home] [Help]

APPS.HR_RU_PEOPLE_LEG_HOOK dependencies on HR_UTILITY

Line 81: hr_utility.set_message (800, 'HR_RU_INVALID_SPIF_NUMBER');

77: );
78:
79: IF (l_err = 1)
80: THEN
81: hr_utility.set_message (800, 'HR_RU_INVALID_SPIF_NUMBER');
82: hr_utility.set_message_token
83: ('NUMBER',
84: hr_general.decode_lookup ('RU_FORM_LABELS',
85: 'SPIFN'

Line 82: hr_utility.set_message_token

78:
79: IF (l_err = 1)
80: THEN
81: hr_utility.set_message (800, 'HR_RU_INVALID_SPIF_NUMBER');
82: hr_utility.set_message_token
83: ('NUMBER',
84: hr_general.decode_lookup ('RU_FORM_LABELS',
85: 'SPIFN'
86: )

Line 88: hr_utility.raise_error;

84: hr_general.decode_lookup ('RU_FORM_LABELS',
85: 'SPIFN'
86: )
87: );
88: hr_utility.raise_error;
89: ELSIF l_err = 2
90: THEN
91: hr_utility.set_message (800, 'HR_RU_SPIFN_FORMULA_ERROR');
92: hr_utility.raise_error;

Line 91: hr_utility.set_message (800, 'HR_RU_SPIFN_FORMULA_ERROR');

87: );
88: hr_utility.raise_error;
89: ELSIF l_err = 2
90: THEN
91: hr_utility.set_message (800, 'HR_RU_SPIFN_FORMULA_ERROR');
92: hr_utility.raise_error;
93: END IF;
94: END IF;
95:

Line 92: hr_utility.raise_error;

88: hr_utility.raise_error;
89: ELSIF l_err = 2
90: THEN
91: hr_utility.set_message (800, 'HR_RU_SPIFN_FORMULA_ERROR');
92: hr_utility.raise_error;
93: END IF;
94: END IF;
95:
96: --Check for Invalid Combination of military document and other military details

Line 199: hr_utility.set_message (800, 'HR_RU_MIL_INVALID_COMBINATION');

195: OR l_per_information15 IS NOT NULL
196: OR l_per_information18 IS NOT NULL
197: )
198: THEN
199: hr_utility.set_message (800, 'HR_RU_MIL_INVALID_COMBINATION');
200: hr_utility.raise_error;
201: ELSIF l_per_information5 = '1'
202: THEN
203: IF (l_per_information6 IS NOT NULL)

Line 200: hr_utility.raise_error;

196: OR l_per_information18 IS NOT NULL
197: )
198: THEN
199: hr_utility.set_message (800, 'HR_RU_MIL_INVALID_COMBINATION');
200: hr_utility.raise_error;
201: ELSIF l_per_information5 = '1'
202: THEN
203: IF (l_per_information6 IS NOT NULL)
204: THEN

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

253: END IF;
254:
255: IF l_per_information10 = 'E'
256: THEN
257: hr_utility.set_message (800, 'HR_7209_API_LOOK_INVALID');
258: hr_utility.set_message_token ('API_NAME', l_proc);
259: hr_utility.set_message_token
260: ('ARGUMENT',
261: hr_general.decode_lookup ('RU_FORM_LABELS',

Line 258: hr_utility.set_message_token ('API_NAME', l_proc);

254:
255: IF l_per_information10 = 'E'
256: THEN
257: hr_utility.set_message (800, 'HR_7209_API_LOOK_INVALID');
258: hr_utility.set_message_token ('API_NAME', l_proc);
259: hr_utility.set_message_token
260: ('ARGUMENT',
261: hr_general.decode_lookup ('RU_FORM_LABELS',
262: 'MIL_SERVICE_READINESS'

Line 259: hr_utility.set_message_token

255: IF l_per_information10 = 'E'
256: THEN
257: hr_utility.set_message (800, 'HR_7209_API_LOOK_INVALID');
258: hr_utility.set_message_token ('API_NAME', l_proc);
259: hr_utility.set_message_token
260: ('ARGUMENT',
261: hr_general.decode_lookup ('RU_FORM_LABELS',
262: 'MIL_SERVICE_READINESS'
263: )

Line 265: hr_utility.raise_error;

261: hr_general.decode_lookup ('RU_FORM_LABELS',
262: 'MIL_SERVICE_READINESS'
263: )
264: );
265: hr_utility.raise_error;
266: END IF;
267: END IF;
268: ELSIF l_per_information5 IS NULL
269: AND ( l_per_information6 IS NOT NULL

Line 281: hr_utility.set_message (800, 'HR_RU_MIL_INVALID_COMBINATION');

277: OR l_per_information15 IS NOT NULL
278: OR l_per_information18 IS NOT NULL
279: )
280: THEN
281: hr_utility.set_message (800, 'HR_RU_MIL_INVALID_COMBINATION');
282: hr_utility.raise_error;
283: END IF;
284: END IF;
285: END validate_person_upd;

Line 282: hr_utility.raise_error;

278: OR l_per_information18 IS NOT NULL
279: )
280: THEN
281: hr_utility.set_message (800, 'HR_RU_MIL_INVALID_COMBINATION');
282: hr_utility.raise_error;
283: END IF;
284: END IF;
285: END validate_person_upd;
286:

Line 339: hr_utility.set_message (800, 'HR_RU_INVALID_SPIF_NUMBER');

335: );
336:
337: IF (l_err = 1)
338: THEN
339: hr_utility.set_message (800, 'HR_RU_INVALID_SPIF_NUMBER');
340: hr_utility.set_message_token
341: ('NUMBER',
342: hr_general.decode_lookup ('RU_FORM_LABELS',
343: 'SPIFN'

Line 340: hr_utility.set_message_token

336:
337: IF (l_err = 1)
338: THEN
339: hr_utility.set_message (800, 'HR_RU_INVALID_SPIF_NUMBER');
340: hr_utility.set_message_token
341: ('NUMBER',
342: hr_general.decode_lookup ('RU_FORM_LABELS',
343: 'SPIFN'
344: )

Line 346: hr_utility.raise_error;

342: hr_general.decode_lookup ('RU_FORM_LABELS',
343: 'SPIFN'
344: )
345: );
346: hr_utility.raise_error;
347: ELSIF l_err = 2
348: THEN
349: hr_utility.set_message (800, 'HR_RU_SPIFN_FORMULA_ERROR');
350: hr_utility.raise_error;

Line 349: hr_utility.set_message (800, 'HR_RU_SPIFN_FORMULA_ERROR');

345: );
346: hr_utility.raise_error;
347: ELSIF l_err = 2
348: THEN
349: hr_utility.set_message (800, 'HR_RU_SPIFN_FORMULA_ERROR');
350: hr_utility.raise_error;
351: END IF;
352: END IF;
353:

Line 350: hr_utility.raise_error;

346: hr_utility.raise_error;
347: ELSIF l_err = 2
348: THEN
349: hr_utility.set_message (800, 'HR_RU_SPIFN_FORMULA_ERROR');
350: hr_utility.raise_error;
351: END IF;
352: END IF;
353:
354: --Check for Invalid Combination of military document and other military details

Line 407: hr_utility.set_message (800, 'HR_RU_MIL_INVALID_COMBINATION');

403: OR p_per_information15 IS NOT NULL
404: OR p_per_information18 IS NOT NULL
405: )
406: THEN
407: hr_utility.set_message (800, 'HR_RU_MIL_INVALID_COMBINATION');
408: hr_utility.raise_error;
409: ELSIF p_per_information5 = '1'
410: THEN
411: IF (p_per_information6 IS NOT NULL)

Line 408: hr_utility.raise_error;

404: OR p_per_information18 IS NOT NULL
405: )
406: THEN
407: hr_utility.set_message (800, 'HR_RU_MIL_INVALID_COMBINATION');
408: hr_utility.raise_error;
409: ELSIF p_per_information5 = '1'
410: THEN
411: IF (p_per_information6 IS NOT NULL)
412: THEN

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

461: END IF;
462:
463: IF p_per_information10 = 'E'
464: THEN
465: hr_utility.set_message (800, 'HR_7209_API_LOOK_INVALID');
466: hr_utility.set_message_token ('API_NAME', l_proc);
467: hr_utility.set_message_token
468: ('ARGUMENT',
469: hr_general.decode_lookup ('RU_FORM_LABELS',

Line 466: hr_utility.set_message_token ('API_NAME', l_proc);

462:
463: IF p_per_information10 = 'E'
464: THEN
465: hr_utility.set_message (800, 'HR_7209_API_LOOK_INVALID');
466: hr_utility.set_message_token ('API_NAME', l_proc);
467: hr_utility.set_message_token
468: ('ARGUMENT',
469: hr_general.decode_lookup ('RU_FORM_LABELS',
470: 'MIL_SERVICE_READINESS'

Line 467: hr_utility.set_message_token

463: IF p_per_information10 = 'E'
464: THEN
465: hr_utility.set_message (800, 'HR_7209_API_LOOK_INVALID');
466: hr_utility.set_message_token ('API_NAME', l_proc);
467: hr_utility.set_message_token
468: ('ARGUMENT',
469: hr_general.decode_lookup ('RU_FORM_LABELS',
470: 'MIL_SERVICE_READINESS'
471: )

Line 473: hr_utility.raise_error;

469: hr_general.decode_lookup ('RU_FORM_LABELS',
470: 'MIL_SERVICE_READINESS'
471: )
472: );
473: hr_utility.raise_error;
474: END IF;
475: END IF;
476: ELSIF p_per_information5 IS NULL
477: AND ( p_per_information6 IS NOT NULL

Line 489: hr_utility.set_message (800, 'HR_RU_MIL_INVALID_COMBINATION');

485: OR p_per_information15 IS NOT NULL
486: OR p_per_information18 IS NOT NULL
487: )
488: THEN
489: hr_utility.set_message (800, 'HR_RU_MIL_INVALID_COMBINATION');
490: hr_utility.raise_error;
491: END IF;
492: END validate_person;
493:

Line 490: hr_utility.raise_error;

486: OR p_per_information18 IS NOT NULL
487: )
488: THEN
489: hr_utility.set_message (800, 'HR_RU_MIL_INVALID_COMBINATION');
490: hr_utility.raise_error;
491: END IF;
492: END validate_person;
493:
494: PROCEDURE create_ru_employee (

Line 522: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN

518: BEGIN
519: --
520: -- Added for GSI Bug 5472781
521: --
522: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN
523: --
524: -- Check for Citizenship
525: IF per_per_bus.g_global_transfer_in_process IS NULL
526: OR per_per_bus.g_global_transfer_in_process = FALSE THEN --BUG 14509259

Line 589: -- hr_utility.set_message (800, 'HR_RU_MIL_DOC_REQUIRED');

585: -- IF p_sex = 'M'
586: -- AND (l_age BETWEEN 17 AND 65)
587: -- AND p_per_information5 IS NULL
588: -- THEN
589: -- hr_utility.set_message (800, 'HR_RU_MIL_DOC_REQUIRED');
590: -- hr_utility.raise_error;
591: -- END IF;
592: --END IF;
593: END IF;

Line 590: -- hr_utility.raise_error;

586: -- AND (l_age BETWEEN 17 AND 65)
587: -- AND p_per_information5 IS NULL
588: -- THEN
589: -- hr_utility.set_message (800, 'HR_RU_MIL_DOC_REQUIRED');
590: -- hr_utility.raise_error;
591: -- END IF;
592: --END IF;
593: END IF;
594: END create_ru_employee;

Line 620: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN

616: BEGIN
617: --
618: -- Added for GSI Bug 5472781
619: --
620: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN
621: --
622: -- Check for Citizenship
623: hr_api.mandatory_arg_error
624: (p_api_name => l_proc,

Line 684: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN

680: BEGIN
681: --
682: -- Added for GSI Bug 5472781
683: --
684: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN
685: --
686: validate_person (p_first_name => p_first_name,
687: p_effective_date => p_start_date,
688: p_per_information1 => p_per_information1,

Line 730: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN

726: BEGIN
727: --
728: -- Added for GSI Bug 5472781
729: --
730: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN
731: --
732: -- Check for Citizenship
733: hr_api.mandatory_arg_error
734: (p_api_name => l_proc,

Line 825: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN

821: BEGIN
822: --
823: -- Added for GSI Bug 5472781
824: --
825: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN
826: --
827: l_effective_date := TRUNC (p_effective_date);
828:
829: IF (p_person_type_id <> hr_api.g_number

Line 931: -- hr_utility.set_message (800, 'HR_RU_MIL_DOC_REQUIRED');

927: --IF l_sex = 'M'
928: -- AND (l_age BETWEEN 17 AND 65)
929: -- AND l_per_information5 IS NULL
930: --THEN
931: -- hr_utility.set_message (800, 'HR_RU_MIL_DOC_REQUIRED');
932: -- hr_utility.raise_error;
933: --END IF;
934: END IF;
935: END IF;

Line 932: -- hr_utility.raise_error;

928: -- AND (l_age BETWEEN 17 AND 65)
929: -- AND l_per_information5 IS NULL
930: --THEN
931: -- hr_utility.set_message (800, 'HR_RU_MIL_DOC_REQUIRED');
932: -- hr_utility.raise_error;
933: --END IF;
934: END IF;
935: END IF;
936: