DBA Data[Home] [Help]

APPS.PER_HU_CREATE_EMPLOYEE dependencies on HR_UTILITY

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

31: );*/
32: --
33: -- Added for GSI Bug 5472781
34: --
35: IF hr_utility.chk_product_install('Oracle Human Resources', 'HU') THEN
36: --
37: -- Bug 8605683
38: -- Suppress checking national identifier if the person is getting created
39: -- using global deployments (transfer of a person from one BG to another)

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

48: END IF;
49: end if ;
50:
51: IF length(p_last_name)>40 THEN
52: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
53: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('HU_FORM_LABELS','LAST_NAME'));
54: hr_utility.set_message_token('COLUMN_VALUE',p_last_name);
55: hr_utility.set_message_token('MAX_LENGTH','40');
56: hr_utility.raise_error;

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

49: end if ;
50:
51: IF length(p_last_name)>40 THEN
52: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
53: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('HU_FORM_LABELS','LAST_NAME'));
54: hr_utility.set_message_token('COLUMN_VALUE',p_last_name);
55: hr_utility.set_message_token('MAX_LENGTH','40');
56: hr_utility.raise_error;
57: END IF;

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

50:
51: IF length(p_last_name)>40 THEN
52: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
53: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('HU_FORM_LABELS','LAST_NAME'));
54: hr_utility.set_message_token('COLUMN_VALUE',p_last_name);
55: hr_utility.set_message_token('MAX_LENGTH','40');
56: hr_utility.raise_error;
57: END IF;
58:

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

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

Line 56: hr_utility.raise_error;

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

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

56: hr_utility.raise_error;
57: END IF;
58:
59: IF length(p_first_name)>40 THEN
60: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
61: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('HU_FORM_LABELS','FIRST_NAME'));
62: hr_utility.set_message_token('COLUMN_VALUE',p_first_name);
63: hr_utility.set_message_token('MAX_LENGTH','40');
64: hr_utility.raise_error;

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

57: END IF;
58:
59: IF length(p_first_name)>40 THEN
60: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
61: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('HU_FORM_LABELS','FIRST_NAME'));
62: hr_utility.set_message_token('COLUMN_VALUE',p_first_name);
63: hr_utility.set_message_token('MAX_LENGTH','40');
64: hr_utility.raise_error;
65: END IF;

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

58:
59: IF length(p_first_name)>40 THEN
60: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
61: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('HU_FORM_LABELS','FIRST_NAME'));
62: hr_utility.set_message_token('COLUMN_VALUE',p_first_name);
63: hr_utility.set_message_token('MAX_LENGTH','40');
64: hr_utility.raise_error;
65: END IF;
66: END IF;

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

59: IF length(p_first_name)>40 THEN
60: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
61: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('HU_FORM_LABELS','FIRST_NAME'));
62: hr_utility.set_message_token('COLUMN_VALUE',p_first_name);
63: hr_utility.set_message_token('MAX_LENGTH','40');
64: hr_utility.raise_error;
65: END IF;
66: END IF;
67: END create_hu_employee;

Line 64: hr_utility.raise_error;

60: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
61: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('HU_FORM_LABELS','FIRST_NAME'));
62: hr_utility.set_message_token('COLUMN_VALUE',p_first_name);
63: hr_utility.set_message_token('MAX_LENGTH','40');
64: hr_utility.raise_error;
65: END IF;
66: END IF;
67: END create_hu_employee;
68: