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.HR_AE_VALIDATE_PKG dependencies on HR_GENERAL

Line 62: v_len_field := hr_general.decode_lookup('AE_FORM_LABELS','FIRST_M');

58:
59: --Validate length of name fields
60: IF length(p_first_name) > 60 THEN
61: IF v_len_field IS NULL THEN
62: v_len_field := hr_general.decode_lookup('AE_FORM_LABELS','FIRST_M');
63: ELSE
64: v_len_field := v_len_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','FIRST_M');
65: END IF;
66: END IF;

Line 64: v_len_field := v_len_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','FIRST_M');

60: IF length(p_first_name) > 60 THEN
61: IF v_len_field IS NULL THEN
62: v_len_field := hr_general.decode_lookup('AE_FORM_LABELS','FIRST_M');
63: ELSE
64: v_len_field := v_len_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','FIRST_M');
65: END IF;
66: END IF;
67: IF length(p_last_name) > 60 THEN
68: IF v_len_field IS NULL THEN

Line 69: v_len_field := hr_general.decode_lookup('AE_FORM_LABELS','LAST_M');

65: END IF;
66: END IF;
67: IF length(p_last_name) > 60 THEN
68: IF v_len_field IS NULL THEN
69: v_len_field := hr_general.decode_lookup('AE_FORM_LABELS','LAST_M');
70: ELSE
71: v_len_field := v_len_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','LAST_M');
72: END IF;
73: END IF;

Line 71: v_len_field := v_len_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','LAST_M');

67: IF length(p_last_name) > 60 THEN
68: IF v_len_field IS NULL THEN
69: v_len_field := hr_general.decode_lookup('AE_FORM_LABELS','LAST_M');
70: ELSE
71: v_len_field := v_len_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','LAST_M');
72: END IF;
73: END IF;
74: IF length(p_per_information1) > 60 THEN
75: IF v_len_field IS NULL THEN

Line 76: v_len_field := hr_general.decode_lookup('AE_FORM_LABELS','FATHER_M');

72: END IF;
73: END IF;
74: IF length(p_per_information1) > 60 THEN
75: IF v_len_field IS NULL THEN
76: v_len_field := hr_general.decode_lookup('AE_FORM_LABELS','FATHER_M');
77: ELSE
78: v_len_field := v_len_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','FATHER_M');
79: END IF;
80: END IF;

Line 78: v_len_field := v_len_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','FATHER_M');

74: IF length(p_per_information1) > 60 THEN
75: IF v_len_field IS NULL THEN
76: v_len_field := hr_general.decode_lookup('AE_FORM_LABELS','FATHER_M');
77: ELSE
78: v_len_field := v_len_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','FATHER_M');
79: END IF;
80: END IF;
81: IF length(p_per_information2) > 60 THEN
82: IF v_len_field IS NULL THEN

Line 83: v_len_field := hr_general.decode_lookup('AE_FORM_LABELS','GRANDFATHER_M');

79: END IF;
80: END IF;
81: IF length(p_per_information2) > 60 THEN
82: IF v_len_field IS NULL THEN
83: v_len_field := hr_general.decode_lookup('AE_FORM_LABELS','GRANDFATHER_M');
84: ELSE
85: v_len_field := v_len_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','GRANDFATHER_M');
86: END IF;
87: END IF;

Line 85: v_len_field := v_len_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','GRANDFATHER_M');

81: IF length(p_per_information2) > 60 THEN
82: IF v_len_field IS NULL THEN
83: v_len_field := hr_general.decode_lookup('AE_FORM_LABELS','GRANDFATHER_M');
84: ELSE
85: v_len_field := v_len_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','GRANDFATHER_M');
86: END IF;
87: END IF;
88: IF length(p_per_information3) > 60 THEN
89: IF v_len_field IS NULL THEN

Line 90: v_len_field := hr_general.decode_lookup('AE_FORM_LABELS','MOTHER_M');

86: END IF;
87: END IF;
88: IF length(p_per_information3) > 60 THEN
89: IF v_len_field IS NULL THEN
90: v_len_field := hr_general.decode_lookup('AE_FORM_LABELS','MOTHER_M');
91: ELSE
92: v_len_field := v_len_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','MOTHER_M');
93: END IF;
94: END IF;

Line 92: v_len_field := v_len_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','MOTHER_M');

88: IF length(p_per_information3) > 60 THEN
89: IF v_len_field IS NULL THEN
90: v_len_field := hr_general.decode_lookup('AE_FORM_LABELS','MOTHER_M');
91: ELSE
92: v_len_field := v_len_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','MOTHER_M');
93: END IF;
94: END IF;
95: IF length(p_per_information4) > 60 THEN
96: IF v_len_field IS NULL THEN

Line 97: v_len_field := hr_general.decode_lookup('AE_FORM_LABELS','ALT_FIRST_M');

93: END IF;
94: END IF;
95: IF length(p_per_information4) > 60 THEN
96: IF v_len_field IS NULL THEN
97: v_len_field := hr_general.decode_lookup('AE_FORM_LABELS','ALT_FIRST_M');
98: ELSE
99: v_len_field := v_len_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','ALT_FIRST_M');
100: END IF;
101: END IF;

Line 99: v_len_field := v_len_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','ALT_FIRST_M');

95: IF length(p_per_information4) > 60 THEN
96: IF v_len_field IS NULL THEN
97: v_len_field := hr_general.decode_lookup('AE_FORM_LABELS','ALT_FIRST_M');
98: ELSE
99: v_len_field := v_len_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','ALT_FIRST_M');
100: END IF;
101: END IF;
102: IF length(p_per_information5) > 60 THEN
103: IF v_len_field IS NULL THEN

Line 104: v_len_field := hr_general.decode_lookup('AE_FORM_LABELS','ALT_FATHER_M');

100: END IF;
101: END IF;
102: IF length(p_per_information5) > 60 THEN
103: IF v_len_field IS NULL THEN
104: v_len_field := hr_general.decode_lookup('AE_FORM_LABELS','ALT_FATHER_M');
105: ELSE
106: v_len_field := v_len_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','ALT_FATHER_M');
107: END IF;
108: END IF;

Line 106: v_len_field := v_len_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','ALT_FATHER_M');

102: IF length(p_per_information5) > 60 THEN
103: IF v_len_field IS NULL THEN
104: v_len_field := hr_general.decode_lookup('AE_FORM_LABELS','ALT_FATHER_M');
105: ELSE
106: v_len_field := v_len_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','ALT_FATHER_M');
107: END IF;
108: END IF;
109: IF length(p_per_information6) > 60 THEN
110: IF v_len_field IS NULL THEN

Line 111: v_len_field := hr_general.decode_lookup('AE_FORM_LABELS','ALT_GRANDFATHER_M');

107: END IF;
108: END IF;
109: IF length(p_per_information6) > 60 THEN
110: IF v_len_field IS NULL THEN
111: v_len_field := hr_general.decode_lookup('AE_FORM_LABELS','ALT_GRANDFATHER_M');
112: ELSE
113: v_len_field := v_len_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','ALT_GRANDFATHER_M');
114: END IF;
115: END IF;

Line 113: v_len_field := v_len_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','ALT_GRANDFATHER_M');

109: IF length(p_per_information6) > 60 THEN
110: IF v_len_field IS NULL THEN
111: v_len_field := hr_general.decode_lookup('AE_FORM_LABELS','ALT_GRANDFATHER_M');
112: ELSE
113: v_len_field := v_len_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','ALT_GRANDFATHER_M');
114: END IF;
115: END IF;
116: IF length(p_per_information7) > 60 THEN
117: IF v_len_field IS NULL THEN

Line 118: v_len_field := hr_general.decode_lookup('AE_FORM_LABELS','ALT_LAST_M');

114: END IF;
115: END IF;
116: IF length(p_per_information7) > 60 THEN
117: IF v_len_field IS NULL THEN
118: v_len_field := hr_general.decode_lookup('AE_FORM_LABELS','ALT_LAST_M');
119: ELSE
120: v_len_field := v_len_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','ALT_LAST_M');
121: END IF;
122: END IF;

Line 120: v_len_field := v_len_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','ALT_LAST_M');

116: IF length(p_per_information7) > 60 THEN
117: IF v_len_field IS NULL THEN
118: v_len_field := hr_general.decode_lookup('AE_FORM_LABELS','ALT_LAST_M');
119: ELSE
120: v_len_field := v_len_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','ALT_LAST_M');
121: END IF;
122: END IF;
123: IF length(p_per_information8) > 60 THEN
124: IF v_len_field IS NULL THEN

Line 125: v_len_field := hr_general.decode_lookup('AE_FORM_LABELS','ALT_MOTHER_M');

121: END IF;
122: END IF;
123: IF length(p_per_information8) > 60 THEN
124: IF v_len_field IS NULL THEN
125: v_len_field := hr_general.decode_lookup('AE_FORM_LABELS','ALT_MOTHER_M');
126: ELSE
127: v_len_field := v_len_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','ALT_MOTHER_M');
128: END IF;
129: END IF;

Line 127: v_len_field := v_len_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','ALT_MOTHER_M');

123: IF length(p_per_information8) > 60 THEN
124: IF v_len_field IS NULL THEN
125: v_len_field := hr_general.decode_lookup('AE_FORM_LABELS','ALT_MOTHER_M');
126: ELSE
127: v_len_field := v_len_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','ALT_MOTHER_M');
128: END IF;
129: END IF;
130: IF v_len_field IS NOT NULL THEN
131: fnd_message.set_name('PER', 'HR_377418_AE_INVALID_LENGTH');

Line 140: v_field := hr_general.decode_lookup('AE_FORM_LABELS','FIRST_NAME');

136: --Validate not null fields
137: IF g_per_type = 'Y' THEN
138: IF p_first_name IS NULL THEN
139: IF v_field IS NULL THEN
140: v_field := hr_general.decode_lookup('AE_FORM_LABELS','FIRST_NAME');
141: ELSE
142: v_field := v_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','FIRST_NAME');
143: END IF;
144: END IF;

Line 142: v_field := v_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','FIRST_NAME');

138: IF p_first_name IS NULL THEN
139: IF v_field IS NULL THEN
140: v_field := hr_general.decode_lookup('AE_FORM_LABELS','FIRST_NAME');
141: ELSE
142: v_field := v_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','FIRST_NAME');
143: END IF;
144: END IF;
145: END IF;
146: OPEN c_per_type;

Line 154: v_field := hr_general.decode_lookup('AE_FORM_LABELS','CIVIL_IDENTIFIER');

150: /*IF g_per_type IS NOT NULL THEN
151:
152: IF p_national_identifier IS NULL THEN
153: IF v_field IS NULL THEN
154: v_field := hr_general.decode_lookup('AE_FORM_LABELS','CIVIL_IDENTIFIER');
155: ELSE
156: v_field := v_field||hr_general.decode_lookup('AE_FORM_LABELS','CIVIL_IDENTIFIER');
157: END IF;
158: END IF;

Line 156: v_field := v_field||hr_general.decode_lookup('AE_FORM_LABELS','CIVIL_IDENTIFIER');

152: IF p_national_identifier IS NULL THEN
153: IF v_field IS NULL THEN
154: v_field := hr_general.decode_lookup('AE_FORM_LABELS','CIVIL_IDENTIFIER');
155: ELSE
156: v_field := v_field||hr_general.decode_lookup('AE_FORM_LABELS','CIVIL_IDENTIFIER');
157: END IF;
158: END IF;
159: END IF;*/
160:

Line 169: v_field := hr_general.decode_lookup('AE_FORM_LABELS','NATIONALITY');

165: IF g_per_type = 'Y' THEN
166: --IF p_nationality IS NULL THEN
167: IF p_per_information18 IS NULL THEN
168: IF v_field IS NULL THEN
169: v_field := hr_general.decode_lookup('AE_FORM_LABELS','NATIONALITY');
170: ELSE
171: v_field := v_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','NATIONALITY');
172: END IF;
173: END IF;

Line 171: v_field := v_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','NATIONALITY');

167: IF p_per_information18 IS NULL THEN
168: IF v_field IS NULL THEN
169: v_field := hr_general.decode_lookup('AE_FORM_LABELS','NATIONALITY');
170: ELSE
171: v_field := v_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','NATIONALITY');
172: END IF;
173: END IF;
174: END IF;
175: --END IF;

Line 1314: v_field := hr_general.decode_lookup('AE_FORM_LABELS','PREVIOUS_EMPLOYER');

1310: v_field := NULL;
1311: IF p_pem_information_category = 'AE' then
1312: IF p_employer_name is null then
1313: IF v_field IS NULL THEN
1314: v_field := hr_general.decode_lookup('AE_FORM_LABELS','PREVIOUS_EMPLOYER');
1315: ELSE
1316: v_field := v_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','PREVIOUS_EMPLOYER');
1317: END IF;
1318:

Line 1316: v_field := v_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','PREVIOUS_EMPLOYER');

1312: IF p_employer_name is null then
1313: IF v_field IS NULL THEN
1314: v_field := hr_general.decode_lookup('AE_FORM_LABELS','PREVIOUS_EMPLOYER');
1315: ELSE
1316: v_field := v_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','PREVIOUS_EMPLOYER');
1317: END IF;
1318:
1319: fnd_message.set_name('PER', 'PQH_FR_MANDATORY_MSG');
1320: fnd_message.set_token('NAME',v_field, translate => true );

Line 1376: v_field := hr_general.decode_lookup('AE_FORM_LABELS','SOCIAL_SEC_NUMBER');

1372: IF p_org_info_type_code = 'AE_LEGAL_EMPLOYER_DETAILS' THEN
1373:
1374: IF p_org_information1 is null then
1375: IF v_field IS NULL THEN
1376: v_field := hr_general.decode_lookup('AE_FORM_LABELS','SOCIAL_SEC_NUMBER');
1377: ELSE
1378: v_field := v_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','SOCIAL_SEC_NUMBER');
1379: END IF;
1380:

Line 1378: v_field := v_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','SOCIAL_SEC_NUMBER');

1374: IF p_org_information1 is null then
1375: IF v_field IS NULL THEN
1376: v_field := hr_general.decode_lookup('AE_FORM_LABELS','SOCIAL_SEC_NUMBER');
1377: ELSE
1378: v_field := v_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','SOCIAL_SEC_NUMBER');
1379: END IF;
1380:
1381: fnd_message.set_name('PER', 'PQH_FR_MANDATORY_MSG');
1382: fnd_message.set_token('NAME',v_field, translate => true );

Line 1437: v_field := hr_general.decode_lookup('AE_FORM_LABELS','SOCIAL_SEC_NUMBER');

1433: IF p_org_info_type_code = 'AE_LEGAL_EMPLOYER_DETAILS' THEN
1434:
1435: IF p_org_information1 is null then
1436: IF v_field IS NULL THEN
1437: v_field := hr_general.decode_lookup('AE_FORM_LABELS','SOCIAL_SEC_NUMBER');
1438: ELSE
1439: v_field := v_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','SOCIAL_SEC_NUMBER');
1440: END IF;
1441:

Line 1439: v_field := v_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','SOCIAL_SEC_NUMBER');

1435: IF p_org_information1 is null then
1436: IF v_field IS NULL THEN
1437: v_field := hr_general.decode_lookup('AE_FORM_LABELS','SOCIAL_SEC_NUMBER');
1438: ELSE
1439: v_field := v_field||', '||hr_general.decode_lookup('AE_FORM_LABELS','SOCIAL_SEC_NUMBER');
1440: END IF;
1441:
1442: fnd_message.set_name('PER', 'PQH_FR_MANDATORY_MSG');
1443: fnd_message.set_token('NAME',v_field, translate => true );