DBA Data[Home] [Help]

APPS.PER_HU_UPDATE_PERSON dependencies on HR_UTILITY

Line 29: IF hr_utility.chk_product_install('Oracle Human Resources', 'HU') THEN

25: BEGIN
26: --
27: -- Added for GSI Bug 5472781
28: --
29: IF hr_utility.chk_product_install('Oracle Human Resources', 'HU') THEN
30: --
31: OPEN csr_person_type;
32: FETCH csr_person_type into l_person_type,l_seed_person_type;
33: CLOSE csr_person_type;

Line 41: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');

37: p_argument => hr_general.decode_lookup('HU_FORM_LABELS','LAST_NAME'),
38: p_argument_value => p_last_name
39: );
40: IF length(p_last_name)>40 THEN
41: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
42: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('HU_FORM_LABELS','LAST_NAME'));
43: hr_utility.set_message_token('COLUMN_VALUE',p_last_name);
44: hr_utility.set_message_token('MAX_LENGTH','40');
45: hr_utility.raise_error;

Line 42: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('HU_FORM_LABELS','LAST_NAME'));

38: p_argument_value => p_last_name
39: );
40: IF length(p_last_name)>40 THEN
41: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
42: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('HU_FORM_LABELS','LAST_NAME'));
43: hr_utility.set_message_token('COLUMN_VALUE',p_last_name);
44: hr_utility.set_message_token('MAX_LENGTH','40');
45: hr_utility.raise_error;
46: END IF;

Line 43: hr_utility.set_message_token('COLUMN_VALUE',p_last_name);

39: );
40: IF length(p_last_name)>40 THEN
41: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
42: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('HU_FORM_LABELS','LAST_NAME'));
43: hr_utility.set_message_token('COLUMN_VALUE',p_last_name);
44: hr_utility.set_message_token('MAX_LENGTH','40');
45: hr_utility.raise_error;
46: END IF;
47:

Line 44: hr_utility.set_message_token('MAX_LENGTH','40');

40: IF length(p_last_name)>40 THEN
41: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
42: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('HU_FORM_LABELS','LAST_NAME'));
43: hr_utility.set_message_token('COLUMN_VALUE',p_last_name);
44: hr_utility.set_message_token('MAX_LENGTH','40');
45: hr_utility.raise_error;
46: END IF;
47:
48: /* hr_api.mandatory_arg_error

Line 45: hr_utility.raise_error;

41: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
42: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('HU_FORM_LABELS','LAST_NAME'));
43: hr_utility.set_message_token('COLUMN_VALUE',p_last_name);
44: hr_utility.set_message_token('MAX_LENGTH','40');
45: hr_utility.raise_error;
46: END IF;
47:
48: /* hr_api.mandatory_arg_error
49: (p_api_name => l_proc,

Line 54: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');

50: p_argument => hr_general.decode_lookup('HU_FORM_LABELS','FIRST_NAME'),
51: p_argument_value => p_first_name
52: );*/
53: IF length(p_first_name)>40 THEN
54: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
55: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('HU_FORM_LABELS','FIRST_NAME'));
56: hr_utility.set_message_token('COLUMN_VALUE',p_first_name);
57: hr_utility.set_message_token('MAX_LENGTH','40');
58: hr_utility.raise_error;

Line 55: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('HU_FORM_LABELS','FIRST_NAME'));

51: p_argument_value => p_first_name
52: );*/
53: IF length(p_first_name)>40 THEN
54: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
55: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('HU_FORM_LABELS','FIRST_NAME'));
56: hr_utility.set_message_token('COLUMN_VALUE',p_first_name);
57: hr_utility.set_message_token('MAX_LENGTH','40');
58: hr_utility.raise_error;
59: END IF;

Line 56: hr_utility.set_message_token('COLUMN_VALUE',p_first_name);

52: );*/
53: IF length(p_first_name)>40 THEN
54: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
55: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('HU_FORM_LABELS','FIRST_NAME'));
56: hr_utility.set_message_token('COLUMN_VALUE',p_first_name);
57: hr_utility.set_message_token('MAX_LENGTH','40');
58: hr_utility.raise_error;
59: END IF;
60:

Line 57: hr_utility.set_message_token('MAX_LENGTH','40');

53: IF length(p_first_name)>40 THEN
54: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
55: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('HU_FORM_LABELS','FIRST_NAME'));
56: hr_utility.set_message_token('COLUMN_VALUE',p_first_name);
57: hr_utility.set_message_token('MAX_LENGTH','40');
58: hr_utility.raise_error;
59: END IF;
60:
61: -- For bug 4665225

Line 58: hr_utility.raise_error;

54: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
55: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('HU_FORM_LABELS','FIRST_NAME'));
56: hr_utility.set_message_token('COLUMN_VALUE',p_first_name);
57: hr_utility.set_message_token('MAX_LENGTH','40');
58: hr_utility.raise_error;
59: END IF;
60:
61: -- For bug 4665225
62: /*IF l_person_type ='EMP' or l_seed_person_type='CONTACT' THEN