eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ES_CREATE_PERSON dependencies on HR_UTILITY

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

25: BEGIN
26: --
27: -- Added for GSI Bug 5472781
28: --
29: IF hr_utility.chk_product_install('Oracle Human Resources', 'ES') THEN
30: --
31: hr_api.mandatory_arg_error
32: (p_api_name => l_proc,
33: p_argument => hr_general.decode_lookup('ES_FORM_LABELS','LAST_NAME_1'),

Line 39: hr_utility.set_message(800, 'HR_ES_REQ_NIF_IDT_MISSING');

35: );
36:
37: /*IF p_per_information3 IS NOT NULL AND
38: p_per_information2 IS NULL THEN
39: hr_utility.set_message(800, 'HR_ES_REQ_NIF_IDT_MISSING');
40: hr_utility.raise_error;
41: ELSIF p_per_information2 IS NOT NULL AND
42: p_per_information3 IS NULL THEN
43: hr_utility.set_message(800, 'HR_ES_REQ_NIF_IDT_MISSING');

Line 40: hr_utility.raise_error;

36:
37: /*IF p_per_information3 IS NOT NULL AND
38: p_per_information2 IS NULL THEN
39: hr_utility.set_message(800, 'HR_ES_REQ_NIF_IDT_MISSING');
40: hr_utility.raise_error;
41: ELSIF p_per_information2 IS NOT NULL AND
42: p_per_information3 IS NULL THEN
43: hr_utility.set_message(800, 'HR_ES_REQ_NIF_IDT_MISSING');
44: hr_utility.raise_error;

Line 43: hr_utility.set_message(800, 'HR_ES_REQ_NIF_IDT_MISSING');

39: hr_utility.set_message(800, 'HR_ES_REQ_NIF_IDT_MISSING');
40: hr_utility.raise_error;
41: ELSIF p_per_information2 IS NOT NULL AND
42: p_per_information3 IS NULL THEN
43: hr_utility.set_message(800, 'HR_ES_REQ_NIF_IDT_MISSING');
44: hr_utility.raise_error;
45: END IF;
46: --
47: IF p_national_identifier IS NULL THEN

Line 44: hr_utility.raise_error;

40: hr_utility.raise_error;
41: ELSIF p_per_information2 IS NOT NULL AND
42: p_per_information3 IS NULL THEN
43: hr_utility.set_message(800, 'HR_ES_REQ_NIF_IDT_MISSING');
44: hr_utility.raise_error;
45: END IF;
46: --
47: IF p_national_identifier IS NULL THEN
48: IF p_per_information3 IS NULL THEN

Line 49: hr_utility.set_message(800, 'HR_ES_REQ_NIF_IDT_MISSING');

45: END IF;
46: --
47: IF p_national_identifier IS NULL THEN
48: IF p_per_information3 IS NULL THEN
49: hr_utility.set_message(800, 'HR_ES_REQ_NIF_IDT_MISSING');
50: hr_utility.raise_error;
51: END IF;
52: ELSE
53: l_national_identifier := hr_es_utility.check_NIF(p_national_identifier);

Line 50: hr_utility.raise_error;

46: --
47: IF p_national_identifier IS NULL THEN
48: IF p_per_information3 IS NULL THEN
49: hr_utility.set_message(800, 'HR_ES_REQ_NIF_IDT_MISSING');
50: hr_utility.raise_error;
51: END IF;
52: ELSE
53: l_national_identifier := hr_es_utility.check_NIF(p_national_identifier);
54: END IF;

Line 60: hr_utility.set_message(800,'HR_ES_INVALID_VALUE'||p_per_information2||'..'||p_per_information3||'..'||p_national_identifier);

56: IF p_per_information2 IS NOT NULL THEN
57: OPEN get_lookup_type(p_per_information2);
58: FETCH get_lookup_type into l_identifier_type;
59: IF get_lookup_type%NOTFOUND THEN
60: hr_utility.set_message(800,'HR_ES_INVALID_VALUE'||p_per_information2||'..'||p_per_information3||'..'||p_national_identifier);
61: hr_utility.set_message_token(800,'FIELD','Identifier Type');
62: hr_utility.raise_error;
63: ELSE
64: l_identifier_value := hr_es_utility.validate_identifier(p_per_information2,p_per_information3);

Line 61: hr_utility.set_message_token(800,'FIELD','Identifier Type');

57: OPEN get_lookup_type(p_per_information2);
58: FETCH get_lookup_type into l_identifier_type;
59: IF get_lookup_type%NOTFOUND THEN
60: hr_utility.set_message(800,'HR_ES_INVALID_VALUE'||p_per_information2||'..'||p_per_information3||'..'||p_national_identifier);
61: hr_utility.set_message_token(800,'FIELD','Identifier Type');
62: hr_utility.raise_error;
63: ELSE
64: l_identifier_value := hr_es_utility.validate_identifier(p_per_information2,p_per_information3);
65: END IF;

Line 62: hr_utility.raise_error;

58: FETCH get_lookup_type into l_identifier_type;
59: IF get_lookup_type%NOTFOUND THEN
60: hr_utility.set_message(800,'HR_ES_INVALID_VALUE'||p_per_information2||'..'||p_per_information3||'..'||p_national_identifier);
61: hr_utility.set_message_token(800,'FIELD','Identifier Type');
62: hr_utility.raise_error;
63: ELSE
64: l_identifier_value := hr_es_utility.validate_identifier(p_per_information2,p_per_information3);
65: END IF;
66: END IF;*/

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

65: END IF;
66: END IF;*/
67:
68: IF length(p_last_name)>40 THEN
69: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
70: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('ES_FORM_LABELS','LAST_NAME_1'));
71: hr_utility.set_message_token('COLUMN_VALUE',p_last_name);
72: hr_utility.set_message_token('MAX_LENGTH','40');
73: hr_utility.raise_error;

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

66: END IF;*/
67:
68: IF length(p_last_name)>40 THEN
69: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
70: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('ES_FORM_LABELS','LAST_NAME_1'));
71: hr_utility.set_message_token('COLUMN_VALUE',p_last_name);
72: hr_utility.set_message_token('MAX_LENGTH','40');
73: hr_utility.raise_error;
74: END IF;

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

67:
68: IF length(p_last_name)>40 THEN
69: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
70: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('ES_FORM_LABELS','LAST_NAME_1'));
71: hr_utility.set_message_token('COLUMN_VALUE',p_last_name);
72: hr_utility.set_message_token('MAX_LENGTH','40');
73: hr_utility.raise_error;
74: END IF;
75:

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

68: IF length(p_last_name)>40 THEN
69: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
70: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('ES_FORM_LABELS','LAST_NAME_1'));
71: hr_utility.set_message_token('COLUMN_VALUE',p_last_name);
72: hr_utility.set_message_token('MAX_LENGTH','40');
73: hr_utility.raise_error;
74: END IF;
75:
76: IF length(p_first_name)>40 THEN

Line 73: hr_utility.raise_error;

69: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
70: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('ES_FORM_LABELS','LAST_NAME_1'));
71: hr_utility.set_message_token('COLUMN_VALUE',p_last_name);
72: hr_utility.set_message_token('MAX_LENGTH','40');
73: hr_utility.raise_error;
74: END IF;
75:
76: IF length(p_first_name)>40 THEN
77: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');

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

73: hr_utility.raise_error;
74: END IF;
75:
76: IF length(p_first_name)>40 THEN
77: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
78: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('ES_FORM_LABELS','NAME'));
79: hr_utility.set_message_token('COLUMN_VALUE',p_first_name);
80: hr_utility.set_message_token('MAX_LENGTH','40');
81: hr_utility.raise_error;

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

74: END IF;
75:
76: IF length(p_first_name)>40 THEN
77: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
78: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('ES_FORM_LABELS','NAME'));
79: hr_utility.set_message_token('COLUMN_VALUE',p_first_name);
80: hr_utility.set_message_token('MAX_LENGTH','40');
81: hr_utility.raise_error;
82: END IF;

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

75:
76: IF length(p_first_name)>40 THEN
77: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
78: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('ES_FORM_LABELS','NAME'));
79: hr_utility.set_message_token('COLUMN_VALUE',p_first_name);
80: hr_utility.set_message_token('MAX_LENGTH','40');
81: hr_utility.raise_error;
82: END IF;
83:

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

76: IF length(p_first_name)>40 THEN
77: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
78: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('ES_FORM_LABELS','NAME'));
79: hr_utility.set_message_token('COLUMN_VALUE',p_first_name);
80: hr_utility.set_message_token('MAX_LENGTH','40');
81: hr_utility.raise_error;
82: END IF;
83:
84: IF length(p_per_information1)>40 THEN

Line 81: hr_utility.raise_error;

77: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
78: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('ES_FORM_LABELS','NAME'));
79: hr_utility.set_message_token('COLUMN_VALUE',p_first_name);
80: hr_utility.set_message_token('MAX_LENGTH','40');
81: hr_utility.raise_error;
82: END IF;
83:
84: IF length(p_per_information1)>40 THEN
85: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');

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

81: hr_utility.raise_error;
82: END IF;
83:
84: IF length(p_per_information1)>40 THEN
85: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
86: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('ES_FORM_LABELS','LAST_NAME_2'));
87: hr_utility.set_message_token('COLUMN_VALUE',p_per_information1);
88: hr_utility.set_message_token('MAX_LENGTH','40');
89: hr_utility.raise_error;

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

82: END IF;
83:
84: IF length(p_per_information1)>40 THEN
85: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
86: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('ES_FORM_LABELS','LAST_NAME_2'));
87: hr_utility.set_message_token('COLUMN_VALUE',p_per_information1);
88: hr_utility.set_message_token('MAX_LENGTH','40');
89: hr_utility.raise_error;
90: END IF;

Line 87: hr_utility.set_message_token('COLUMN_VALUE',p_per_information1);

83:
84: IF length(p_per_information1)>40 THEN
85: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
86: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('ES_FORM_LABELS','LAST_NAME_2'));
87: hr_utility.set_message_token('COLUMN_VALUE',p_per_information1);
88: hr_utility.set_message_token('MAX_LENGTH','40');
89: hr_utility.raise_error;
90: END IF;
91: --

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

84: IF length(p_per_information1)>40 THEN
85: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
86: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('ES_FORM_LABELS','LAST_NAME_2'));
87: hr_utility.set_message_token('COLUMN_VALUE',p_per_information1);
88: hr_utility.set_message_token('MAX_LENGTH','40');
89: hr_utility.raise_error;
90: END IF;
91: --
92: END IF;

Line 89: hr_utility.raise_error;

85: hr_utility.set_message(800, 'HR_289712_UTF8_LENGTH_EXCEEDED');
86: hr_utility.set_message_token('COLUMN_NAME',hr_general.decode_lookup('ES_FORM_LABELS','LAST_NAME_2'));
87: hr_utility.set_message_token('COLUMN_VALUE',p_per_information1);
88: hr_utility.set_message_token('MAX_LENGTH','40');
89: hr_utility.raise_error;
90: END IF;
91: --
92: END IF;
93: --