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: hr_api.mandatory_arg_error
526: (p_api_name => l_proc,

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

577: IF p_sex = 'M'
578: AND (l_age BETWEEN 17 AND 65)
579: AND p_per_information5 IS NULL
580: THEN
581: hr_utility.set_message (800, 'HR_RU_MIL_DOC_REQUIRED');
582: hr_utility.raise_error;
583: END IF;
584: END IF;
585: END IF;

Line 582: hr_utility.raise_error;

578: AND (l_age BETWEEN 17 AND 65)
579: AND p_per_information5 IS NULL
580: THEN
581: hr_utility.set_message (800, 'HR_RU_MIL_DOC_REQUIRED');
582: hr_utility.raise_error;
583: END IF;
584: END IF;
585: END IF;
586: END create_ru_employee;

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

608: BEGIN
609: --
610: -- Added for GSI Bug 5472781
611: --
612: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN
613: --
614: -- Check for Citizenship
615: hr_api.mandatory_arg_error
616: (p_api_name => l_proc,

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

672: BEGIN
673: --
674: -- Added for GSI Bug 5472781
675: --
676: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN
677: --
678: validate_person (p_first_name => p_first_name,
679: p_effective_date => p_start_date,
680: p_per_information1 => p_per_information1,

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

718: BEGIN
719: --
720: -- Added for GSI Bug 5472781
721: --
722: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN
723: --
724: -- Check for Citizenship
725: hr_api.mandatory_arg_error
726: (p_api_name => l_proc,

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

813: BEGIN
814: --
815: -- Added for GSI Bug 5472781
816: --
817: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN
818: --
819: l_effective_date := TRUNC (p_effective_date);
820:
821: IF (p_person_type_id <> hr_api.g_number

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

917: IF l_sex = 'M'
918: AND (l_age BETWEEN 17 AND 65)
919: AND l_per_information5 IS NULL
920: THEN
921: hr_utility.set_message (800, 'HR_RU_MIL_DOC_REQUIRED');
922: hr_utility.raise_error;
923: END IF;
924: END IF;
925: END IF;

Line 922: hr_utility.raise_error;

918: AND (l_age BETWEEN 17 AND 65)
919: AND l_per_information5 IS NULL
920: THEN
921: hr_utility.set_message (800, 'HR_RU_MIL_DOC_REQUIRED');
922: hr_utility.raise_error;
923: END IF;
924: END IF;
925: END IF;
926: