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