DBA Data[Home] [Help]

APPS.PER_ES_CREATE_APPLICANT dependencies on HR_GENERAL

Line 35: p_argument => hr_general.decode_lookup('ES_FORM_LABELS','LAST_NAME_1'),

31: IF hr_utility.chk_product_install('Oracle Human Resources', 'ES') THEN
32: --
33: hr_api.mandatory_arg_error
34: (p_api_name => l_proc,
35: p_argument => hr_general.decode_lookup('ES_FORM_LABELS','LAST_NAME_1'),
36: p_argument_value => p_last_name
37: );
38:
39: IF p_per_information3 IS NOT NULL AND

Line 42: hr_utility.set_message_token(800,'FIELD',hr_general.decode_lookup('ES_FORM_LABELS','IDENTIFIER_TYPE'));

38:
39: IF p_per_information3 IS NOT NULL AND
40: p_per_information2 IS NULL THEN
41: hr_utility.set_message(800,'HR_ES_INVALID_VALUE');
42: hr_utility.set_message_token(800,'FIELD',hr_general.decode_lookup('ES_FORM_LABELS','IDENTIFIER_TYPE'));
43: hr_utility.raise_error;
44: ELSIF p_per_information2 IS NOT NULL AND
45: p_per_information3 IS NULL THEN
46: OPEN get_lookup_type(p_per_information2);

Line 50: hr_utility.set_message_token(800,'FIELD',hr_general.decode_lookup('ES_FORM_LABELS','IDENTIFIER_TYPE'));

46: OPEN get_lookup_type(p_per_information2);
47: FETCH get_lookup_type into l_identifier_type;
48: IF get_lookup_type%NOTFOUND THEN
49: hr_utility.set_message(800,'HR_ES_INVALID_VALUE');
50: hr_utility.set_message_token(800,'FIELD',hr_general.decode_lookup('ES_FORM_LABELS','IDENTIFIER_TYPE'));
51: hr_utility.raise_error;
52: END IF;
53: CLOSE get_lookup_type;
54: hr_utility.set_message(800,'HR_ES_INVALID_VALUE');

Line 55: hr_utility.set_message_token(800,'FIELD',hr_general.decode_lookup('ES_IDENTIFIER_TYPE',p_per_information2));

51: hr_utility.raise_error;
52: END IF;
53: CLOSE get_lookup_type;
54: hr_utility.set_message(800,'HR_ES_INVALID_VALUE');
55: hr_utility.set_message_token(800,'FIELD',hr_general.decode_lookup('ES_IDENTIFIER_TYPE',p_per_information2));
56: hr_utility.raise_error;
57: END IF;
58: --
59: /*IF p_national_identifier IS NULL THEN

Line 73: hr_utility.set_message_token(800,'FIELD',hr_general.decode_lookup('ES_FORM_LABELS','IDENTIFIER_TYPE'));

69: OPEN get_lookup_type(p_per_information2);
70: FETCH get_lookup_type into l_identifier_type;
71: IF get_lookup_type%NOTFOUND THEN
72: hr_utility.set_message(800,'HR_ES_INVALID_VALUE');
73: hr_utility.set_message_token(800,'FIELD',hr_general.decode_lookup('ES_FORM_LABELS','IDENTIFIER_TYPE'));
74: hr_utility.raise_error;
75: ELSIF FND_PROFILE.VALUE('PER_NATIONAL_IDENTIFIER_VALIDATION') <> 'NONE' THEN --Bug No 4718049
76: l_identifier_value := hr_es_utility.validate_identifier(p_per_information2,p_per_information3);
77: END IF;

Line 96: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('ES_FORM_LABELS','LAST_NAME_1'));

92: end if;
93:
94: IF length(p_last_name)>40 THEN
95: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
96: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('ES_FORM_LABELS','LAST_NAME_1'));
97: hr_utility.set_message_token('COLUMN_VALUE',p_last_name);
98: hr_utility.set_message_token('MAX_LENGTH','40');
99: hr_utility.raise_error;
100: END IF;

Line 104: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('ES_FORM_LABELS','NAME'));

100: END IF;
101:
102: IF length(p_first_name)>40 THEN
103: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
104: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('ES_FORM_LABELS','NAME'));
105: hr_utility.set_message_token('COLUMN_VALUE',p_first_name);
106: hr_utility.set_message_token('MAX_LENGTH','40');
107: hr_utility.raise_error;
108: END IF;

Line 112: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('ES_FORM_LABELS','LAST_NAME_2'));

108: END IF;
109:
110: IF length(p_per_information1)>40 THEN
111: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
112: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('ES_FORM_LABELS','LAST_NAME_2'));
113: hr_utility.set_message_token('COLUMN_VALUE',p_per_information1);
114: hr_utility.set_message_token('MAX_LENGTH','40');
115: hr_utility.raise_error;
116: END IF;