32: END IF;*/
33: --
34: -- Added for GSI Bug 5472781
35: --
36: IF hr_utility.chk_product_install('Oracle Human Resources', 'HU') THEN
37: --
38: IF length(p_last_name)>40 THEN
39: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
40: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('HU_FORM_LABELS','LAST_NAME'));
35: --
36: IF hr_utility.chk_product_install('Oracle Human Resources', 'HU') THEN
37: --
38: IF length(p_last_name)>40 THEN
39: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
40: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('HU_FORM_LABELS','LAST_NAME'));
41: hr_utility.set_message_token('COLUMN_VALUE',p_last_name);
42: hr_utility.set_message_token('MAX_LENGTH','40');
43: hr_utility.raise_error;
36: IF hr_utility.chk_product_install('Oracle Human Resources', 'HU') THEN
37: --
38: IF length(p_last_name)>40 THEN
39: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
40: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('HU_FORM_LABELS','LAST_NAME'));
41: hr_utility.set_message_token('COLUMN_VALUE',p_last_name);
42: hr_utility.set_message_token('MAX_LENGTH','40');
43: hr_utility.raise_error;
44: END IF;
37: --
38: IF length(p_last_name)>40 THEN
39: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
40: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('HU_FORM_LABELS','LAST_NAME'));
41: hr_utility.set_message_token('COLUMN_VALUE',p_last_name);
42: hr_utility.set_message_token('MAX_LENGTH','40');
43: hr_utility.raise_error;
44: END IF;
45:
38: IF length(p_last_name)>40 THEN
39: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
40: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('HU_FORM_LABELS','LAST_NAME'));
41: hr_utility.set_message_token('COLUMN_VALUE',p_last_name);
42: hr_utility.set_message_token('MAX_LENGTH','40');
43: hr_utility.raise_error;
44: END IF;
45:
46: IF length(p_first_name)>40 THEN
39: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
40: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('HU_FORM_LABELS','LAST_NAME'));
41: hr_utility.set_message_token('COLUMN_VALUE',p_last_name);
42: hr_utility.set_message_token('MAX_LENGTH','40');
43: hr_utility.raise_error;
44: END IF;
45:
46: IF length(p_first_name)>40 THEN
47: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
43: hr_utility.raise_error;
44: END IF;
45:
46: IF length(p_first_name)>40 THEN
47: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
48: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('HU_FORM_LABELS','FIRST_NAME'));
49: hr_utility.set_message_token('COLUMN_VALUE',p_first_name);
50: hr_utility.set_message_token('MAX_LENGTH','40');
51: hr_utility.raise_error;
44: END IF;
45:
46: IF length(p_first_name)>40 THEN
47: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
48: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('HU_FORM_LABELS','FIRST_NAME'));
49: hr_utility.set_message_token('COLUMN_VALUE',p_first_name);
50: hr_utility.set_message_token('MAX_LENGTH','40');
51: hr_utility.raise_error;
52: END IF;
45:
46: IF length(p_first_name)>40 THEN
47: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
48: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('HU_FORM_LABELS','FIRST_NAME'));
49: hr_utility.set_message_token('COLUMN_VALUE',p_first_name);
50: hr_utility.set_message_token('MAX_LENGTH','40');
51: hr_utility.raise_error;
52: END IF;
53: END IF;
46: IF length(p_first_name)>40 THEN
47: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
48: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('HU_FORM_LABELS','FIRST_NAME'));
49: hr_utility.set_message_token('COLUMN_VALUE',p_first_name);
50: hr_utility.set_message_token('MAX_LENGTH','40');
51: hr_utility.raise_error;
52: END IF;
53: END IF;
54: END create_hu_person;
47: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
48: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('HU_FORM_LABELS','FIRST_NAME'));
49: hr_utility.set_message_token('COLUMN_VALUE',p_first_name);
50: hr_utility.set_message_token('MAX_LENGTH','40');
51: hr_utility.raise_error;
52: END IF;
53: END IF;
54: END create_hu_person;
55: --