DBA Data[Home] [Help]

APPS.PER_ES_CREATE_CWK dependencies on HR_GENERAL

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

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

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

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

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

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

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

50: hr_utility.raise_error;
51: END IF;
52: CLOSE get_lookup_type;
53: hr_utility.set_message(800,'HR_ES_INVALID_VALUE');
54: hr_utility.set_message_token(800,'FIELD',hr_general.decode_lookup('ES_IDENTIFIER_TYPE',p_per_information2));
55: hr_utility.raise_error;
56: END IF;
57: --
58:

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

76: OPEN get_lookup_type(p_per_information2);
77: FETCH get_lookup_type into l_identifier_type;
78: IF get_lookup_type%NOTFOUND THEN
79: hr_utility.set_message(800,'HR_ES_INVALID_VALUE');
80: hr_utility.set_message_token(800,'FIELD',hr_general.decode_lookup('ES_FORM_LABELS','IDENTIFIER_TYPE'));
81: hr_utility.raise_error;
82: ELSIF FND_PROFILE.VALUE('PER_NATIONAL_IDENTIFIER_VALIDATION') <> 'NONE' THEN ---- Bug No 4718049
83: l_identifier_value := hr_es_utility.validate_identifier(p_per_information2,p_per_information3);
84: END IF;

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

102: end if;
103:
104: IF length(p_last_name)>40 THEN
105: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
106: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('ES_FORM_LABELS','LAST_NAME_1'));
107: hr_utility.set_message_token('COLUMN_VALUE',p_last_name);
108: hr_utility.set_message_token('MAX_LENGTH','40');
109: hr_utility.raise_error;
110: END IF;

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

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

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

118: END IF;
119:
120: IF length(p_per_information1)>40 THEN
121: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
122: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('ES_FORM_LABELS','LAST_NAME_2'));
123: hr_utility.set_message_token('COLUMN_VALUE',p_per_information1);
124: hr_utility.set_message_token('MAX_LENGTH','40');
125: hr_utility.raise_error;
126: END IF;