[Home] [Help]
65: ,p_lookup_type => 'ZA_RACE'
66: ,p_lookup_code => p_race_code
67: )
68: THEN
69: fnd_message.set_name('PER', 'HR_ZA_MAND_SEG_RACE');
70: hr_multi_message.add
71: (p_associated_column1 => 'PER_ALL_PEOPLE_F.PER_INFORMATION4'
72: );
73: END IF;
120: --Validate Nature of Person (Code 3020)
121: hr_utility.set_location('Validation Nature of Person -Code 3020',10);
122: if p_nature = '10' then
123: hr_utility.set_location('Nature of Person is M',10);
124: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NATURE_PERSON');
125: fnd_message.set_token('NATURE', 'M');
126: fnd_message.raise_error;
127: elsif p_nature = '09' then
128: hr_utility.set_location('Nature of Person is K',10);
121: hr_utility.set_location('Validation Nature of Person -Code 3020',10);
122: if p_nature = '10' then
123: hr_utility.set_location('Nature of Person is M',10);
124: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NATURE_PERSON');
125: fnd_message.set_token('NATURE', 'M');
126: fnd_message.raise_error;
127: elsif p_nature = '09' then
128: hr_utility.set_location('Nature of Person is K',10);
129: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NATURE_PERSON');
122: if p_nature = '10' then
123: hr_utility.set_location('Nature of Person is M',10);
124: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NATURE_PERSON');
125: fnd_message.set_token('NATURE', 'M');
126: fnd_message.raise_error;
127: elsif p_nature = '09' then
128: hr_utility.set_location('Nature of Person is K',10);
129: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NATURE_PERSON');
130: fnd_message.set_token('NATURE', 'K');
125: fnd_message.set_token('NATURE', 'M');
126: fnd_message.raise_error;
127: elsif p_nature = '09' then
128: hr_utility.set_location('Nature of Person is K',10);
129: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NATURE_PERSON');
130: fnd_message.set_token('NATURE', 'K');
131: fnd_message.raise_error;
132: end if;
133:
126: fnd_message.raise_error;
127: elsif p_nature = '09' then
128: hr_utility.set_location('Nature of Person is K',10);
129: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NATURE_PERSON');
130: fnd_message.set_token('NATURE', 'K');
131: fnd_message.raise_error;
132: end if;
133:
134: -- Validate Code Employee Surname/Trading Name (Code 3030)
127: elsif p_nature = '09' then
128: hr_utility.set_location('Nature of Person is K',10);
129: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NATURE_PERSON');
130: fnd_message.set_token('NATURE', 'K');
131: fnd_message.raise_error;
132: end if;
133:
134: -- Validate Code Employee Surname/Trading Name (Code 3030)
135: -- hr_utility.set_location('Validation EE Surname/Trading Name -Code 3030',15);
135: -- hr_utility.set_location('Validation EE Surname/Trading Name -Code 3030',15);
136: -- if p_nature in ('D','E','F','G','H') then
137: -- if p_last_name is null then
138: -- hr_utility.set_location('EE Surname is null',15);
139: -- fnd_message.set_name('PAY', 'PY_ZA_ENTER_NAT_DEFGH_TRADE');
140: -- fnd_message.raise_error;
141: -- elsif validate_charcter_set(p_last_name,'FREETEXT')= FALSE then
142: -- hr_utility.set_location('EE Surname contains invalid characters',15);
143: -- fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
136: -- if p_nature in ('D','E','F','G','H') then
137: -- if p_last_name is null then
138: -- hr_utility.set_location('EE Surname is null',15);
139: -- fnd_message.set_name('PAY', 'PY_ZA_ENTER_NAT_DEFGH_TRADE');
140: -- fnd_message.raise_error;
141: -- elsif validate_charcter_set(p_last_name,'FREETEXT')= FALSE then
142: -- hr_utility.set_location('EE Surname contains invalid characters',15);
143: -- fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
144: -- fnd_message.set_token('FIELD', 'Employee Trading Name');
139: -- fnd_message.set_name('PAY', 'PY_ZA_ENTER_NAT_DEFGH_TRADE');
140: -- fnd_message.raise_error;
141: -- elsif validate_charcter_set(p_last_name,'FREETEXT')= FALSE then
142: -- hr_utility.set_location('EE Surname contains invalid characters',15);
143: -- fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
144: -- fnd_message.set_token('FIELD', 'Employee Trading Name');
145: -- fnd_message.raise_error;
146: -- end if;
147: if p_nature in ('01','02','03','11') then
140: -- fnd_message.raise_error;
141: -- elsif validate_charcter_set(p_last_name,'FREETEXT')= FALSE then
142: -- hr_utility.set_location('EE Surname contains invalid characters',15);
143: -- fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
144: -- fnd_message.set_token('FIELD', 'Employee Trading Name');
145: -- fnd_message.raise_error;
146: -- end if;
147: if p_nature in ('01','02','03','11') then
148: --Validate code 3030
141: -- elsif validate_charcter_set(p_last_name,'FREETEXT')= FALSE then
142: -- hr_utility.set_location('EE Surname contains invalid characters',15);
143: -- fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
144: -- fnd_message.set_token('FIELD', 'Employee Trading Name');
145: -- fnd_message.raise_error;
146: -- end if;
147: if p_nature in ('01','02','03','11') then
148: --Validate code 3030
149: --Checking IF the Surname IS Null
148: --Validate code 3030
149: --Checking IF the Surname IS Null
150: IF p_last_name IS NULL then
151: hr_utility.set_location('EE Surname is null',16);
152: fnd_message.set_name('PAY', 'PY_ZA_ENTER_NAT_ABC_S_F_NAME');
153: -- fnd_message.set_token('FIELD', 'Employee''s Surname');
154: fnd_message.raise_error;
155: END if;
156: /* commented as the numeric are allowed in 3030 as it is free text bug 9507670*/
149: --Checking IF the Surname IS Null
150: IF p_last_name IS NULL then
151: hr_utility.set_location('EE Surname is null',16);
152: fnd_message.set_name('PAY', 'PY_ZA_ENTER_NAT_ABC_S_F_NAME');
153: -- fnd_message.set_token('FIELD', 'Employee''s Surname');
154: fnd_message.raise_error;
155: END if;
156: /* commented as the numeric are allowed in 3030 as it is free text bug 9507670*/
157: /* uncommented for Aug 2010 reconciliation phase II as numeric are not allowed in 3030 */
150: IF p_last_name IS NULL then
151: hr_utility.set_location('EE Surname is null',16);
152: fnd_message.set_name('PAY', 'PY_ZA_ENTER_NAT_ABC_S_F_NAME');
153: -- fnd_message.set_token('FIELD', 'Employee''s Surname');
154: fnd_message.raise_error;
155: END if;
156: /* commented as the numeric are allowed in 3030 as it is free text bug 9507670*/
157: /* uncommented for Aug 2010 reconciliation phase II as numeric are not allowed in 3030 */
158: if p_last_name <> hr_api.g_varchar2 then -- Bug#14361099
157: /* uncommented for Aug 2010 reconciliation phase II as numeric are not allowed in 3030 */
158: if p_last_name <> hr_api.g_varchar2 then -- Bug#14361099
159: if nvl(length(translate(p_last_name,'~0123456789','~')),0) <> length(p_last_name) then
160: hr_utility.set_location('EE last name contains invalid characters',15);
161: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
162: fnd_message.set_token('FIELD', 'Employee''s Surname');
163: fnd_message.raise_error;
164: end if;
165: end if; -- Bug#14361099
158: if p_last_name <> hr_api.g_varchar2 then -- Bug#14361099
159: if nvl(length(translate(p_last_name,'~0123456789','~')),0) <> length(p_last_name) then
160: hr_utility.set_location('EE last name contains invalid characters',15);
161: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
162: fnd_message.set_token('FIELD', 'Employee''s Surname');
163: fnd_message.raise_error;
164: end if;
165: end if; -- Bug#14361099
166: end if;
159: if nvl(length(translate(p_last_name,'~0123456789','~')),0) <> length(p_last_name) then
160: hr_utility.set_location('EE last name contains invalid characters',15);
161: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
162: fnd_message.set_token('FIELD', 'Employee''s Surname');
163: fnd_message.raise_error;
164: end if;
165: end if; -- Bug#14361099
166: end if;
167:
169: hr_utility.set_location('Validation First Two Names -Code 3040',20);
170: if p_nature in ('01','02','03','11') then
171: if p_first_name <> hr_api.g_varchar2 and p_middle_name <> hr_api.g_varchar2 then -- Bug#14361099
172: if p_first_name is null and p_middle_name is null then
173: fnd_message.set_name('PAY', 'PY_ZA_ENTER_NAT_ABCN_F_NAME');
174: fnd_message.raise_error;
175: /* uncommented as the numeric are not allowed in first two Names bug 9507670*/
176: elsif nvl(length(translate(p_first_name,'~0123456789','~')),0) <> nvl(length(p_first_name),0)
177: OR nvl(length(translate(p_middle_name,'~0123456789','~')),0) <> nvl(length(p_middle_name),0) then
170: if p_nature in ('01','02','03','11') then
171: if p_first_name <> hr_api.g_varchar2 and p_middle_name <> hr_api.g_varchar2 then -- Bug#14361099
172: if p_first_name is null and p_middle_name is null then
173: fnd_message.set_name('PAY', 'PY_ZA_ENTER_NAT_ABCN_F_NAME');
174: fnd_message.raise_error;
175: /* uncommented as the numeric are not allowed in first two Names bug 9507670*/
176: elsif nvl(length(translate(p_first_name,'~0123456789','~')),0) <> nvl(length(p_first_name),0)
177: OR nvl(length(translate(p_middle_name,'~0123456789','~')),0) <> nvl(length(p_middle_name),0) then
178: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
174: fnd_message.raise_error;
175: /* uncommented as the numeric are not allowed in first two Names bug 9507670*/
176: elsif nvl(length(translate(p_first_name,'~0123456789','~')),0) <> nvl(length(p_first_name),0)
177: OR nvl(length(translate(p_middle_name,'~0123456789','~')),0) <> nvl(length(p_middle_name),0) then
178: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
179: fnd_message.set_token('FIELD', 'First or Middle Name');
180: fnd_message.raise_error;
181: end if;
182: --First and Middle name contains invalid characters only
175: /* uncommented as the numeric are not allowed in first two Names bug 9507670*/
176: elsif nvl(length(translate(p_first_name,'~0123456789','~')),0) <> nvl(length(p_first_name),0)
177: OR nvl(length(translate(p_middle_name,'~0123456789','~')),0) <> nvl(length(p_middle_name),0) then
178: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
179: fnd_message.set_token('FIELD', 'First or Middle Name');
180: fnd_message.raise_error;
181: end if;
182: --First and Middle name contains invalid characters only
183: --characters like ' ',- etc (Invalid characters for Initials
176: elsif nvl(length(translate(p_first_name,'~0123456789','~')),0) <> nvl(length(p_first_name),0)
177: OR nvl(length(translate(p_middle_name,'~0123456789','~')),0) <> nvl(length(p_middle_name),0) then
178: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
179: fnd_message.set_token('FIELD', 'First or Middle Name');
180: fnd_message.raise_error;
181: end if;
182: --First and Middle name contains invalid characters only
183: --characters like ' ',- etc (Invalid characters for Initials
184: --Validate Initials
185:
186: if nvl(length(translate(p_first_name,l_invalid_char||l_alpha,l_invalid_char)),0) = 0
187: AND nvl(length(translate(p_middle_name,l_invalid_char||l_alpha,l_invalid_char)),0) = 0
188: AND (p_first_name is not null OR p_middle_name is not null) then
189: fnd_message.set_name('PAY', 'PY_ZA_INVALID_INITIALS');
190: fnd_message.raise_error;
191: end if;
192: end if; -- Bug#14361099
193: end if;
186: if nvl(length(translate(p_first_name,l_invalid_char||l_alpha,l_invalid_char)),0) = 0
187: AND nvl(length(translate(p_middle_name,l_invalid_char||l_alpha,l_invalid_char)),0) = 0
188: AND (p_first_name is not null OR p_middle_name is not null) then
189: fnd_message.set_name('PAY', 'PY_ZA_INVALID_INITIALS');
190: fnd_message.raise_error;
191: end if;
192: end if; -- Bug#14361099
193: end if;
194:
197: hr_utility.set_location('Validating Identity Number -Code 3060',22);
198: if p_nature in ('01','03','11') then
199: if p_ni <> hr_api.g_varchar2 then -- Bug#14361099
200: if p_ni is null and p_passport_no is null and p_nature <> '11' then
201: fnd_message.set_name('PAY', 'PY_ZA_ENTER_NAT_ACN_ID_PASSNO');
202: fnd_message.raise_error;
203: end if;
204: if nvl(length(p_ni),13)<>13 then
205: hr_utility.set_location('p_ni:'||p_ni,22);
198: if p_nature in ('01','03','11') then
199: if p_ni <> hr_api.g_varchar2 then -- Bug#14361099
200: if p_ni is null and p_passport_no is null and p_nature <> '11' then
201: fnd_message.set_name('PAY', 'PY_ZA_ENTER_NAT_ACN_ID_PASSNO');
202: fnd_message.raise_error;
203: end if;
204: if nvl(length(p_ni),13)<>13 then
205: hr_utility.set_location('p_ni:'||p_ni,22);
206: fnd_message.set_name('PER', 'HR_ZA_INVALID_LENGTH');
202: fnd_message.raise_error;
203: end if;
204: if nvl(length(p_ni),13)<>13 then
205: hr_utility.set_location('p_ni:'||p_ni,22);
206: fnd_message.set_name('PER', 'HR_ZA_INVALID_LENGTH');
207: fnd_message.set_token('FIELD', 'ID Number');
208: fnd_message.set_token('LENGTH', '13');
209: fnd_message.set_token('UNITS', 'digits');
210: fnd_message.raise_error;
203: end if;
204: if nvl(length(p_ni),13)<>13 then
205: hr_utility.set_location('p_ni:'||p_ni,22);
206: fnd_message.set_name('PER', 'HR_ZA_INVALID_LENGTH');
207: fnd_message.set_token('FIELD', 'ID Number');
208: fnd_message.set_token('LENGTH', '13');
209: fnd_message.set_token('UNITS', 'digits');
210: fnd_message.raise_error;
211: end if;
204: if nvl(length(p_ni),13)<>13 then
205: hr_utility.set_location('p_ni:'||p_ni,22);
206: fnd_message.set_name('PER', 'HR_ZA_INVALID_LENGTH');
207: fnd_message.set_token('FIELD', 'ID Number');
208: fnd_message.set_token('LENGTH', '13');
209: fnd_message.set_token('UNITS', 'digits');
210: fnd_message.raise_error;
211: end if;
212: if validate_charcter_set(p_ni,'NUMERIC')= FALSE then
205: hr_utility.set_location('p_ni:'||p_ni,22);
206: fnd_message.set_name('PER', 'HR_ZA_INVALID_LENGTH');
207: fnd_message.set_token('FIELD', 'ID Number');
208: fnd_message.set_token('LENGTH', '13');
209: fnd_message.set_token('UNITS', 'digits');
210: fnd_message.raise_error;
211: end if;
212: if validate_charcter_set(p_ni,'NUMERIC')= FALSE then
213: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
206: fnd_message.set_name('PER', 'HR_ZA_INVALID_LENGTH');
207: fnd_message.set_token('FIELD', 'ID Number');
208: fnd_message.set_token('LENGTH', '13');
209: fnd_message.set_token('UNITS', 'digits');
210: fnd_message.raise_error;
211: end if;
212: if validate_charcter_set(p_ni,'NUMERIC')= FALSE then
213: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
214: fnd_message.set_token('FIELD', 'ID Number');
209: fnd_message.set_token('UNITS', 'digits');
210: fnd_message.raise_error;
211: end if;
212: if validate_charcter_set(p_ni,'NUMERIC')= FALSE then
213: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
214: fnd_message.set_token('FIELD', 'ID Number');
215: fnd_message.raise_error;
216: end if;
217: if p_ni is not null then
210: fnd_message.raise_error;
211: end if;
212: if validate_charcter_set(p_ni,'NUMERIC')= FALSE then
213: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
214: fnd_message.set_token('FIELD', 'ID Number');
215: fnd_message.raise_error;
216: end if;
217: if p_ni is not null then
218: if pay_za_eoy_val.modulus_13_test(p_ni)=0 then
211: end if;
212: if validate_charcter_set(p_ni,'NUMERIC')= FALSE then
213: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
214: fnd_message.set_token('FIELD', 'ID Number');
215: fnd_message.raise_error;
216: end if;
217: if p_ni is not null then
218: if pay_za_eoy_val.modulus_13_test(p_ni)=0 then
219: fnd_message.set_name('PER', 'HR_ZA_INVALID_NI');
215: fnd_message.raise_error;
216: end if;
217: if p_ni is not null then
218: if pay_za_eoy_val.modulus_13_test(p_ni)=0 then
219: fnd_message.set_name('PER', 'HR_ZA_INVALID_NI');
220: fnd_message.raise_error;
221: end if;
222: end if;
223: -- if p_id_dob = 0 then
216: end if;
217: if p_ni is not null then
218: if pay_za_eoy_val.modulus_13_test(p_ni)=0 then
219: fnd_message.set_name('PER', 'HR_ZA_INVALID_NI');
220: fnd_message.raise_error;
221: end if;
222: end if;
223: -- if p_id_dob = 0 then
224: if pay_za_eoy_val.check_id_dob(p_ni,p_dob,'Y') = 0 then
221: end if;
222: end if;
223: -- if p_id_dob = 0 then
224: if pay_za_eoy_val.check_id_dob(p_ni,p_dob,'Y') = 0 then
225: fnd_message.set_name('PAY', 'PY_ZA_INVALID_ID_DOB_CORRELAT');
226: fnd_message.raise_error;
227: end if;
228: end if; -- Bug#14361099
229: end if;
222: end if;
223: -- if p_id_dob = 0 then
224: if pay_za_eoy_val.check_id_dob(p_ni,p_dob,'Y') = 0 then
225: fnd_message.set_name('PAY', 'PY_ZA_INVALID_ID_DOB_CORRELAT');
226: fnd_message.raise_error;
227: end if;
228: end if; -- Bug#14361099
229: end if;
230: --Validate Passport Number (Code 3070)
235: -- bug 12914879
236: -- if length(p_passport_no)< 7 then
237: if length(p_passport_no)< 6 then
238: -- bug 12914879
239: fnd_message.set_name('PAY', 'PY_ZA_INVALID_MIN_LENGTH');
240: fnd_message.set_token('FIELD', 'Passport Number');
241: -- bug 12914879
242: -- fnd_message.set_token('LENGTH', '7');
243: fnd_message.set_token('LENGTH', '6');
236: -- if length(p_passport_no)< 7 then
237: if length(p_passport_no)< 6 then
238: -- bug 12914879
239: fnd_message.set_name('PAY', 'PY_ZA_INVALID_MIN_LENGTH');
240: fnd_message.set_token('FIELD', 'Passport Number');
241: -- bug 12914879
242: -- fnd_message.set_token('LENGTH', '7');
243: fnd_message.set_token('LENGTH', '6');
244: -- bug 12914879
238: -- bug 12914879
239: fnd_message.set_name('PAY', 'PY_ZA_INVALID_MIN_LENGTH');
240: fnd_message.set_token('FIELD', 'Passport Number');
241: -- bug 12914879
242: -- fnd_message.set_token('LENGTH', '7');
243: fnd_message.set_token('LENGTH', '6');
244: -- bug 12914879
245: fnd_message.set_token('UNITS', 'characters');
246: fnd_message.raise_error;
239: fnd_message.set_name('PAY', 'PY_ZA_INVALID_MIN_LENGTH');
240: fnd_message.set_token('FIELD', 'Passport Number');
241: -- bug 12914879
242: -- fnd_message.set_token('LENGTH', '7');
243: fnd_message.set_token('LENGTH', '6');
244: -- bug 12914879
245: fnd_message.set_token('UNITS', 'characters');
246: fnd_message.raise_error;
247: end if;
241: -- bug 12914879
242: -- fnd_message.set_token('LENGTH', '7');
243: fnd_message.set_token('LENGTH', '6');
244: -- bug 12914879
245: fnd_message.set_token('UNITS', 'characters');
246: fnd_message.raise_error;
247: end if;
248:
249: if validate_charcter_set(p_passport_no,'ALPHANUM')= FALSE then
242: -- fnd_message.set_token('LENGTH', '7');
243: fnd_message.set_token('LENGTH', '6');
244: -- bug 12914879
245: fnd_message.set_token('UNITS', 'characters');
246: fnd_message.raise_error;
247: end if;
248:
249: if validate_charcter_set(p_passport_no,'ALPHANUM')= FALSE then
250: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
246: fnd_message.raise_error;
247: end if;
248:
249: if validate_charcter_set(p_passport_no,'ALPHANUM')= FALSE then
250: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
251: fnd_message.set_token('FIELD', 'Passport Number');
252: fnd_message.raise_error;
253: end if;
254: end if; -- Bug#14361099
247: end if;
248:
249: if validate_charcter_set(p_passport_no,'ALPHANUM')= FALSE then
250: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
251: fnd_message.set_token('FIELD', 'Passport Number');
252: fnd_message.raise_error;
253: end if;
254: end if; -- Bug#14361099
255: end if;
248:
249: if validate_charcter_set(p_passport_no,'ALPHANUM')= FALSE then
250: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
251: fnd_message.set_token('FIELD', 'Passport Number');
252: fnd_message.raise_error;
253: end if;
254: end if; -- Bug#14361099
255: end if;
256: --Validate Country of Issue ( Code 3075 )
256: --Validate Country of Issue ( Code 3075 )
257: --If Nature of Person is B, then country of Issue is archived as ZNC, hence validation not required.
258: hr_utility.set_location('Validating Country of Issue -Code 3075',25);
259: if p_country_passport is null and p_passport_no is not null then -- 9877034 fix removed B and N
260: fnd_message.set_name('PAY', 'PY_ZA_ENTER_PASS_COUNTRY_ISSUE');
261: fnd_message.raise_error;
262: elsif p_country_passport is not null then
263: if p_country_passport <> hr_api.g_varchar2 then -- Bug#14361099
264: if validate_charcter_set(p_country_passport,'ALPHA')= FALSE then -- 9877034 fix removed B
257: --If Nature of Person is B, then country of Issue is archived as ZNC, hence validation not required.
258: hr_utility.set_location('Validating Country of Issue -Code 3075',25);
259: if p_country_passport is null and p_passport_no is not null then -- 9877034 fix removed B and N
260: fnd_message.set_name('PAY', 'PY_ZA_ENTER_PASS_COUNTRY_ISSUE');
261: fnd_message.raise_error;
262: elsif p_country_passport is not null then
263: if p_country_passport <> hr_api.g_varchar2 then -- Bug#14361099
264: if validate_charcter_set(p_country_passport,'ALPHA')= FALSE then -- 9877034 fix removed B
265: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
261: fnd_message.raise_error;
262: elsif p_country_passport is not null then
263: if p_country_passport <> hr_api.g_varchar2 then -- Bug#14361099
264: if validate_charcter_set(p_country_passport,'ALPHA')= FALSE then -- 9877034 fix removed B
265: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
266: fnd_message.set_token('FIELD', 'Country of Passport Issue');
267: fnd_message.raise_error;
268: end if;
269: if length(p_country_passport)> 3 then -- 9877034 fix removed B
262: elsif p_country_passport is not null then
263: if p_country_passport <> hr_api.g_varchar2 then -- Bug#14361099
264: if validate_charcter_set(p_country_passport,'ALPHA')= FALSE then -- 9877034 fix removed B
265: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
266: fnd_message.set_token('FIELD', 'Country of Passport Issue');
267: fnd_message.raise_error;
268: end if;
269: if length(p_country_passport)> 3 then -- 9877034 fix removed B
270: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
263: if p_country_passport <> hr_api.g_varchar2 then -- Bug#14361099
264: if validate_charcter_set(p_country_passport,'ALPHA')= FALSE then -- 9877034 fix removed B
265: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
266: fnd_message.set_token('FIELD', 'Country of Passport Issue');
267: fnd_message.raise_error;
268: end if;
269: if length(p_country_passport)> 3 then -- 9877034 fix removed B
270: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
271: fnd_message.set_token('FIELD', 'Country of Passport Issue');
266: fnd_message.set_token('FIELD', 'Country of Passport Issue');
267: fnd_message.raise_error;
268: end if;
269: if length(p_country_passport)> 3 then -- 9877034 fix removed B
270: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
271: fnd_message.set_token('FIELD', 'Country of Passport Issue');
272: fnd_message.set_token('LENGTH', '3');
273: fnd_message.set_token('UNITS', 'characters');
274: fnd_message.raise_error;
267: fnd_message.raise_error;
268: end if;
269: if length(p_country_passport)> 3 then -- 9877034 fix removed B
270: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
271: fnd_message.set_token('FIELD', 'Country of Passport Issue');
272: fnd_message.set_token('LENGTH', '3');
273: fnd_message.set_token('UNITS', 'characters');
274: fnd_message.raise_error;
275: end if;
268: end if;
269: if length(p_country_passport)> 3 then -- 9877034 fix removed B
270: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
271: fnd_message.set_token('FIELD', 'Country of Passport Issue');
272: fnd_message.set_token('LENGTH', '3');
273: fnd_message.set_token('UNITS', 'characters');
274: fnd_message.raise_error;
275: end if;
276: end if ; -- Bug#14361099
269: if length(p_country_passport)> 3 then -- 9877034 fix removed B
270: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
271: fnd_message.set_token('FIELD', 'Country of Passport Issue');
272: fnd_message.set_token('LENGTH', '3');
273: fnd_message.set_token('UNITS', 'characters');
274: fnd_message.raise_error;
275: end if;
276: end if ; -- Bug#14361099
277: end if;
270: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
271: fnd_message.set_token('FIELD', 'Country of Passport Issue');
272: fnd_message.set_token('LENGTH', '3');
273: fnd_message.set_token('UNITS', 'characters');
274: fnd_message.raise_error;
275: end if;
276: end if ; -- Bug#14361099
277: end if;
278:
278:
279: --Validate code Income Tax Number (Code 3100)
280: hr_utility.set_location('Validating Income Tax Number -Code 3100',27);
281: if p_it_no_value is null and p_nature <> '06' then
282: fnd_message.set_name('PAY', 'PY_ZA_ENTER_IT_TAX_NO');
283: fnd_message.raise_error;
284: elsif p_it_no_value is not null and p_nature <> '06' then
285: --Check the modulus 10 test
286: if p_it_no_value <> hr_api.g_varchar2 then -- Bug#14361099
279: --Validate code Income Tax Number (Code 3100)
280: hr_utility.set_location('Validating Income Tax Number -Code 3100',27);
281: if p_it_no_value is null and p_nature <> '06' then
282: fnd_message.set_name('PAY', 'PY_ZA_ENTER_IT_TAX_NO');
283: fnd_message.raise_error;
284: elsif p_it_no_value is not null and p_nature <> '06' then
285: --Check the modulus 10 test
286: if p_it_no_value <> hr_api.g_varchar2 then -- Bug#14361099
287: if pay_za_eoy_val.modulus_10_test(p_it_no_value) = 0 then
284: elsif p_it_no_value is not null and p_nature <> '06' then
285: --Check the modulus 10 test
286: if p_it_no_value <> hr_api.g_varchar2 then -- Bug#14361099
287: if pay_za_eoy_val.modulus_10_test(p_it_no_value) = 0 then
288: fnd_message.set_name('PAY', 'PY_ZA_INVALID_IT_TAX_NO');
289: fnd_message.raise_error;
290: end if;
291: if p_nature in ('01','02','03','04','11') and substr(p_it_no_value,1,1) not in ('0','1','2','3') then
292: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NAT_IT_TAX_NO');
285: --Check the modulus 10 test
286: if p_it_no_value <> hr_api.g_varchar2 then -- Bug#14361099
287: if pay_za_eoy_val.modulus_10_test(p_it_no_value) = 0 then
288: fnd_message.set_name('PAY', 'PY_ZA_INVALID_IT_TAX_NO');
289: fnd_message.raise_error;
290: end if;
291: if p_nature in ('01','02','03','04','11') and substr(p_it_no_value,1,1) not in ('0','1','2','3') then
292: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NAT_IT_TAX_NO');
293: fnd_message.set_token('VALID_NUM', '0, 1, 2 or 3');
288: fnd_message.set_name('PAY', 'PY_ZA_INVALID_IT_TAX_NO');
289: fnd_message.raise_error;
290: end if;
291: if p_nature in ('01','02','03','04','11') and substr(p_it_no_value,1,1) not in ('0','1','2','3') then
292: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NAT_IT_TAX_NO');
293: fnd_message.set_token('VALID_NUM', '0, 1, 2 or 3');
294: fnd_message.set_token('VALID_NATURE', 'A, B, C, D, or N');
295: fnd_message.raise_error;
296: elsif p_nature in ('05','07','08') and substr(p_it_no_value,1,1) <> '9' then
289: fnd_message.raise_error;
290: end if;
291: if p_nature in ('01','02','03','04','11') and substr(p_it_no_value,1,1) not in ('0','1','2','3') then
292: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NAT_IT_TAX_NO');
293: fnd_message.set_token('VALID_NUM', '0, 1, 2 or 3');
294: fnd_message.set_token('VALID_NATURE', 'A, B, C, D, or N');
295: fnd_message.raise_error;
296: elsif p_nature in ('05','07','08') and substr(p_it_no_value,1,1) <> '9' then
297: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NAT_IT_TAX_NO');
290: end if;
291: if p_nature in ('01','02','03','04','11') and substr(p_it_no_value,1,1) not in ('0','1','2','3') then
292: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NAT_IT_TAX_NO');
293: fnd_message.set_token('VALID_NUM', '0, 1, 2 or 3');
294: fnd_message.set_token('VALID_NATURE', 'A, B, C, D, or N');
295: fnd_message.raise_error;
296: elsif p_nature in ('05','07','08') and substr(p_it_no_value,1,1) <> '9' then
297: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NAT_IT_TAX_NO');
298: fnd_message.set_token('VALID_NUM', '9');
291: if p_nature in ('01','02','03','04','11') and substr(p_it_no_value,1,1) not in ('0','1','2','3') then
292: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NAT_IT_TAX_NO');
293: fnd_message.set_token('VALID_NUM', '0, 1, 2 or 3');
294: fnd_message.set_token('VALID_NATURE', 'A, B, C, D, or N');
295: fnd_message.raise_error;
296: elsif p_nature in ('05','07','08') and substr(p_it_no_value,1,1) <> '9' then
297: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NAT_IT_TAX_NO');
298: fnd_message.set_token('VALID_NUM', '9');
299: fnd_message.set_token('VALID_NATURE', 'E, G, or H');
293: fnd_message.set_token('VALID_NUM', '0, 1, 2 or 3');
294: fnd_message.set_token('VALID_NATURE', 'A, B, C, D, or N');
295: fnd_message.raise_error;
296: elsif p_nature in ('05','07','08') and substr(p_it_no_value,1,1) <> '9' then
297: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NAT_IT_TAX_NO');
298: fnd_message.set_token('VALID_NUM', '9');
299: fnd_message.set_token('VALID_NATURE', 'E, G, or H');
300: fnd_message.raise_error;
301: end if;
294: fnd_message.set_token('VALID_NATURE', 'A, B, C, D, or N');
295: fnd_message.raise_error;
296: elsif p_nature in ('05','07','08') and substr(p_it_no_value,1,1) <> '9' then
297: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NAT_IT_TAX_NO');
298: fnd_message.set_token('VALID_NUM', '9');
299: fnd_message.set_token('VALID_NATURE', 'E, G, or H');
300: fnd_message.raise_error;
301: end if;
302: if validate_charcter_set(p_it_no_value,'NUMERIC')= FALSE then
295: fnd_message.raise_error;
296: elsif p_nature in ('05','07','08') and substr(p_it_no_value,1,1) <> '9' then
297: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NAT_IT_TAX_NO');
298: fnd_message.set_token('VALID_NUM', '9');
299: fnd_message.set_token('VALID_NATURE', 'E, G, or H');
300: fnd_message.raise_error;
301: end if;
302: if validate_charcter_set(p_it_no_value,'NUMERIC')= FALSE then
303: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
296: elsif p_nature in ('05','07','08') and substr(p_it_no_value,1,1) <> '9' then
297: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NAT_IT_TAX_NO');
298: fnd_message.set_token('VALID_NUM', '9');
299: fnd_message.set_token('VALID_NATURE', 'E, G, or H');
300: fnd_message.raise_error;
301: end if;
302: if validate_charcter_set(p_it_no_value,'NUMERIC')= FALSE then
303: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
304: fnd_message.set_token('FIELD', 'Income Tax Number');
299: fnd_message.set_token('VALID_NATURE', 'E, G, or H');
300: fnd_message.raise_error;
301: end if;
302: if validate_charcter_set(p_it_no_value,'NUMERIC')= FALSE then
303: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
304: fnd_message.set_token('FIELD', 'Income Tax Number');
305: fnd_message.raise_error;
306: end if;
307: end if ; -- Bug#14361099
300: fnd_message.raise_error;
301: end if;
302: if validate_charcter_set(p_it_no_value,'NUMERIC')= FALSE then
303: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
304: fnd_message.set_token('FIELD', 'Income Tax Number');
305: fnd_message.raise_error;
306: end if;
307: end if ; -- Bug#14361099
308: end if;
301: end if;
302: if validate_charcter_set(p_it_no_value,'NUMERIC')= FALSE then
303: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
304: fnd_message.set_token('FIELD', 'Income Tax Number');
305: fnd_message.raise_error;
306: end if;
307: end if ; -- Bug#14361099
308: end if;
309: hr_utility.set_location('p_empno'|| p_empno, 14);
314: /*
315: if validate_charcter_set(p_empno,'ALPHANUM')= FALSE then
316:
317: hr_utility.set_location('p_empno' || p_empno, 15);
318: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
319: fnd_message.set_token('FIELD', 'Employee Number:' || p_empno ||':');
320: fnd_message.raise_error;
321: end if;
322: */
315: if validate_charcter_set(p_empno,'ALPHANUM')= FALSE then
316:
317: hr_utility.set_location('p_empno' || p_empno, 15);
318: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
319: fnd_message.set_token('FIELD', 'Employee Number:' || p_empno ||':');
320: fnd_message.raise_error;
321: end if;
322: */
323: -- 11899934
316:
317: hr_utility.set_location('p_empno' || p_empno, 15);
318: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
319: fnd_message.set_token('FIELD', 'Employee Number:' || p_empno ||':');
320: fnd_message.raise_error;
321: end if;
322: */
323: -- 11899934
324: hr_utility.set_location('Leaving '||l_proc,200);
391: if l_system_person_type = 'EMP' then
392: --
393: if ((p_emp_num is null)
394: or (length(p_emp_num) > 25 or per_za_user_hook_pkg.validate_charcter_set(p_emp_num, 'FREETEXT')= FALSE)) then
395: fnd_message.set_name('PER', 'HR_ZA_INVALID_EMP_NO');
396: fnd_message.raise_error;
397: end if;
398:
399: end if;
392: --
393: if ((p_emp_num is null)
394: or (length(p_emp_num) > 25 or per_za_user_hook_pkg.validate_charcter_set(p_emp_num, 'FREETEXT')= FALSE)) then
395: fnd_message.set_name('PER', 'HR_ZA_INVALID_EMP_NO');
396: fnd_message.raise_error;
397: end if;
398:
399: end if;
400:
425: l_validate_flag boolean := true ;
426: begin
427: if p_email_id is not null and p_email_id <> hr_api.g_varchar2 then
428: if length(p_email_id) >70 then
429: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
430: fnd_message.set_token('FIELD', 'Email Address');
431: fnd_message.set_token('LENGTH', '70');
432: fnd_message.set_token('UNITS', 'characters');
433: fnd_message.raise_error;
426: begin
427: if p_email_id is not null and p_email_id <> hr_api.g_varchar2 then
428: if length(p_email_id) >70 then
429: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
430: fnd_message.set_token('FIELD', 'Email Address');
431: fnd_message.set_token('LENGTH', '70');
432: fnd_message.set_token('UNITS', 'characters');
433: fnd_message.raise_error;
434: elsif instr(p_email_id,'@') <= 0 or instr(p_email_id,'.') <= 0 then
427: if p_email_id is not null and p_email_id <> hr_api.g_varchar2 then
428: if length(p_email_id) >70 then
429: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
430: fnd_message.set_token('FIELD', 'Email Address');
431: fnd_message.set_token('LENGTH', '70');
432: fnd_message.set_token('UNITS', 'characters');
433: fnd_message.raise_error;
434: elsif instr(p_email_id,'@') <= 0 or instr(p_email_id,'.') <= 0 then
435: fnd_message.set_name('PER', 'HR_ZA_INVALID_CONTACT_EMAIL');
428: if length(p_email_id) >70 then
429: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
430: fnd_message.set_token('FIELD', 'Email Address');
431: fnd_message.set_token('LENGTH', '70');
432: fnd_message.set_token('UNITS', 'characters');
433: fnd_message.raise_error;
434: elsif instr(p_email_id,'@') <= 0 or instr(p_email_id,'.') <= 0 then
435: fnd_message.set_name('PER', 'HR_ZA_INVALID_CONTACT_EMAIL');
436: fnd_message.set_token('CONTACT', '');
429: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
430: fnd_message.set_token('FIELD', 'Email Address');
431: fnd_message.set_token('LENGTH', '70');
432: fnd_message.set_token('UNITS', 'characters');
433: fnd_message.raise_error;
434: elsif instr(p_email_id,'@') <= 0 or instr(p_email_id,'.') <= 0 then
435: fnd_message.set_name('PER', 'HR_ZA_INVALID_CONTACT_EMAIL');
436: fnd_message.set_token('CONTACT', '');
437: fnd_message.raise_error;
431: fnd_message.set_token('LENGTH', '70');
432: fnd_message.set_token('UNITS', 'characters');
433: fnd_message.raise_error;
434: elsif instr(p_email_id,'@') <= 0 or instr(p_email_id,'.') <= 0 then
435: fnd_message.set_name('PER', 'HR_ZA_INVALID_CONTACT_EMAIL');
436: fnd_message.set_token('CONTACT', '');
437: fnd_message.raise_error;
438: elsif validate_charcter_set(p_email_id,'FREETEXT') = false then
439: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
432: fnd_message.set_token('UNITS', 'characters');
433: fnd_message.raise_error;
434: elsif instr(p_email_id,'@') <= 0 or instr(p_email_id,'.') <= 0 then
435: fnd_message.set_name('PER', 'HR_ZA_INVALID_CONTACT_EMAIL');
436: fnd_message.set_token('CONTACT', '');
437: fnd_message.raise_error;
438: elsif validate_charcter_set(p_email_id,'FREETEXT') = false then
439: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
440: fnd_message.set_token('FIELD', 'Email Address');
433: fnd_message.raise_error;
434: elsif instr(p_email_id,'@') <= 0 or instr(p_email_id,'.') <= 0 then
435: fnd_message.set_name('PER', 'HR_ZA_INVALID_CONTACT_EMAIL');
436: fnd_message.set_token('CONTACT', '');
437: fnd_message.raise_error;
438: elsif validate_charcter_set(p_email_id,'FREETEXT') = false then
439: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
440: fnd_message.set_token('FIELD', 'Email Address');
441: fnd_message.raise_error;
435: fnd_message.set_name('PER', 'HR_ZA_INVALID_CONTACT_EMAIL');
436: fnd_message.set_token('CONTACT', '');
437: fnd_message.raise_error;
438: elsif validate_charcter_set(p_email_id,'FREETEXT') = false then
439: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
440: fnd_message.set_token('FIELD', 'Email Address');
441: fnd_message.raise_error;
442: end if ;
443:
436: fnd_message.set_token('CONTACT', '');
437: fnd_message.raise_error;
438: elsif validate_charcter_set(p_email_id,'FREETEXT') = false then
439: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
440: fnd_message.set_token('FIELD', 'Email Address');
441: fnd_message.raise_error;
442: end if ;
443:
444: end if;
437: fnd_message.raise_error;
438: elsif validate_charcter_set(p_email_id,'FREETEXT') = false then
439: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
440: fnd_message.set_token('FIELD', 'Email Address');
441: fnd_message.raise_error;
442: end if ;
443:
444: end if;
445: end validate_email_id ;
463: begin
464: l_phone_int := to_number(p_phone_number);
465: exception
466: when others then
467: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
468: fnd_message.set_token('FIELD', hr_general.decode_lookup('PHONE_TYPE', p_phone_type)||' phone number');
469: fnd_message.raise_error;
470: end;
471:
464: l_phone_int := to_number(p_phone_number);
465: exception
466: when others then
467: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
468: fnd_message.set_token('FIELD', hr_general.decode_lookup('PHONE_TYPE', p_phone_type)||' phone number');
469: fnd_message.raise_error;
470: end;
471:
472: if p_phone_type in ('GRE') then
465: exception
466: when others then
467: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
468: fnd_message.set_token('FIELD', hr_general.decode_lookup('PHONE_TYPE', p_phone_type)||' phone number');
469: fnd_message.raise_error;
470: end;
471:
472: if p_phone_type in ('GRE') then
473: if length(p_phone_number)<9 or length(p_phone_number)>11 then
470: end;
471:
472: if p_phone_type in ('GRE') then
473: if length(p_phone_number)<9 or length(p_phone_number)>11 then
474: fnd_message.set_name('PER', 'HR_ZA_INVALID_PH_NO');
475: fnd_message.set_token('FIELD', 'phone number');
476: fnd_message.raise_error;
477: end if;
478: elsif p_phone_type in ('H1','H2','H3','W1','W2','W3','HF','WF') then
471:
472: if p_phone_type in ('GRE') then
473: if length(p_phone_number)<9 or length(p_phone_number)>11 then
474: fnd_message.set_name('PER', 'HR_ZA_INVALID_PH_NO');
475: fnd_message.set_token('FIELD', 'phone number');
476: fnd_message.raise_error;
477: end if;
478: elsif p_phone_type in ('H1','H2','H3','W1','W2','W3','HF','WF') then
479: if length(p_phone_number)<9 or length(p_phone_number)>11 then
472: if p_phone_type in ('GRE') then
473: if length(p_phone_number)<9 or length(p_phone_number)>11 then
474: fnd_message.set_name('PER', 'HR_ZA_INVALID_PH_NO');
475: fnd_message.set_token('FIELD', 'phone number');
476: fnd_message.raise_error;
477: end if;
478: elsif p_phone_type in ('H1','H2','H3','W1','W2','W3','HF','WF') then
479: if length(p_phone_number)<9 or length(p_phone_number)>11 then
480: fnd_message.set_name('PER', 'HR_ZA_INVALID_PH_NO');
476: fnd_message.raise_error;
477: end if;
478: elsif p_phone_type in ('H1','H2','H3','W1','W2','W3','HF','WF') then
479: if length(p_phone_number)<9 or length(p_phone_number)>11 then
480: fnd_message.set_name('PER', 'HR_ZA_INVALID_PH_NO');
481: fnd_message.set_token('FIELD', hr_general.decode_lookup('PHONE_TYPE', p_phone_type)||' phone number');
482: fnd_message.raise_error;
483: end if;
484: elsif p_phone_type in ('M') then
477: end if;
478: elsif p_phone_type in ('H1','H2','H3','W1','W2','W3','HF','WF') then
479: if length(p_phone_number)<9 or length(p_phone_number)>11 then
480: fnd_message.set_name('PER', 'HR_ZA_INVALID_PH_NO');
481: fnd_message.set_token('FIELD', hr_general.decode_lookup('PHONE_TYPE', p_phone_type)||' phone number');
482: fnd_message.raise_error;
483: end if;
484: elsif p_phone_type in ('M') then
485: if length(p_phone_number)<10 or length(p_phone_number)>11 then
478: elsif p_phone_type in ('H1','H2','H3','W1','W2','W3','HF','WF') then
479: if length(p_phone_number)<9 or length(p_phone_number)>11 then
480: fnd_message.set_name('PER', 'HR_ZA_INVALID_PH_NO');
481: fnd_message.set_token('FIELD', hr_general.decode_lookup('PHONE_TYPE', p_phone_type)||' phone number');
482: fnd_message.raise_error;
483: end if;
484: elsif p_phone_type in ('M') then
485: if length(p_phone_number)<10 or length(p_phone_number)>11 then
486: fnd_message.set_name('PER', 'HR_ZA_INVALID_MOBILE');
482: fnd_message.raise_error;
483: end if;
484: elsif p_phone_type in ('M') then
485: if length(p_phone_number)<10 or length(p_phone_number)>11 then
486: fnd_message.set_name('PER', 'HR_ZA_INVALID_MOBILE');
487: fnd_message.raise_error;
488: end if;
489: end if;
490: end if;
483: end if;
484: elsif p_phone_type in ('M') then
485: if length(p_phone_number)<10 or length(p_phone_number)>11 then
486: fnd_message.set_name('PER', 'HR_ZA_INVALID_MOBILE');
487: fnd_message.raise_error;
488: end if;
489: end if;
490: end if;
491: end validate_phone_no;
548: -- bug 12914879
549: -- if length(p_per_information2)< 7 then
550: if length(p_per_information2)< 6 then
551: -- bug 12914879
552: fnd_message.set_name('PAY', 'PY_ZA_INVALID_MIN_LENGTH');
553: fnd_message.set_token('FIELD', 'Passport Number');
554: -- bug 12914879
555: -- fnd_message.set_token('LENGTH', '7');
556: fnd_message.set_token('LENGTH', '6');
549: -- if length(p_per_information2)< 7 then
550: if length(p_per_information2)< 6 then
551: -- bug 12914879
552: fnd_message.set_name('PAY', 'PY_ZA_INVALID_MIN_LENGTH');
553: fnd_message.set_token('FIELD', 'Passport Number');
554: -- bug 12914879
555: -- fnd_message.set_token('LENGTH', '7');
556: fnd_message.set_token('LENGTH', '6');
557: -- bug 12914879
551: -- bug 12914879
552: fnd_message.set_name('PAY', 'PY_ZA_INVALID_MIN_LENGTH');
553: fnd_message.set_token('FIELD', 'Passport Number');
554: -- bug 12914879
555: -- fnd_message.set_token('LENGTH', '7');
556: fnd_message.set_token('LENGTH', '6');
557: -- bug 12914879
558: fnd_message.set_token('UNITS', 'characters');
559: fnd_message.raise_error;
552: fnd_message.set_name('PAY', 'PY_ZA_INVALID_MIN_LENGTH');
553: fnd_message.set_token('FIELD', 'Passport Number');
554: -- bug 12914879
555: -- fnd_message.set_token('LENGTH', '7');
556: fnd_message.set_token('LENGTH', '6');
557: -- bug 12914879
558: fnd_message.set_token('UNITS', 'characters');
559: fnd_message.raise_error;
560: end if;
554: -- bug 12914879
555: -- fnd_message.set_token('LENGTH', '7');
556: fnd_message.set_token('LENGTH', '6');
557: -- bug 12914879
558: fnd_message.set_token('UNITS', 'characters');
559: fnd_message.raise_error;
560: end if;
561:
562: -- bug 13006122
555: -- fnd_message.set_token('LENGTH', '7');
556: fnd_message.set_token('LENGTH', '6');
557: -- bug 12914879
558: fnd_message.set_token('UNITS', 'characters');
559: fnd_message.raise_error;
560: end if;
561:
562: -- bug 13006122
563:
561:
562: -- bug 13006122
563:
564: if length(p_per_information2)> 13 then
565: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
566: fnd_message.set_token('FIELD', 'Passport Number');
567: fnd_message.set_token('LENGTH', '13');
568: fnd_message.set_token('UNITS', 'characters');
569: fnd_message.raise_error;
562: -- bug 13006122
563:
564: if length(p_per_information2)> 13 then
565: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
566: fnd_message.set_token('FIELD', 'Passport Number');
567: fnd_message.set_token('LENGTH', '13');
568: fnd_message.set_token('UNITS', 'characters');
569: fnd_message.raise_error;
570: end if;
563:
564: if length(p_per_information2)> 13 then
565: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
566: fnd_message.set_token('FIELD', 'Passport Number');
567: fnd_message.set_token('LENGTH', '13');
568: fnd_message.set_token('UNITS', 'characters');
569: fnd_message.raise_error;
570: end if;
571:
564: if length(p_per_information2)> 13 then
565: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
566: fnd_message.set_token('FIELD', 'Passport Number');
567: fnd_message.set_token('LENGTH', '13');
568: fnd_message.set_token('UNITS', 'characters');
569: fnd_message.raise_error;
570: end if;
571:
572: -- bug 13006122 ends
565: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
566: fnd_message.set_token('FIELD', 'Passport Number');
567: fnd_message.set_token('LENGTH', '13');
568: fnd_message.set_token('UNITS', 'characters');
569: fnd_message.raise_error;
570: end if;
571:
572: -- bug 13006122 ends
573:
571:
572: -- bug 13006122 ends
573:
574: if validate_charcter_set(p_per_information2,'ALPHANUM')= FALSE then
575: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
576: fnd_message.set_token('FIELD', 'Passport Number');
577: fnd_message.raise_error;
578: end if;
579: end if;
572: -- bug 13006122 ends
573:
574: if validate_charcter_set(p_per_information2,'ALPHANUM')= FALSE then
575: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
576: fnd_message.set_token('FIELD', 'Passport Number');
577: fnd_message.raise_error;
578: end if;
579: end if;
580:
573:
574: if validate_charcter_set(p_per_information2,'ALPHANUM')= FALSE then
575: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
576: fnd_message.set_token('FIELD', 'Passport Number');
577: fnd_message.raise_error;
578: end if;
579: end if;
580:
581: -- Removing this validation, as it does not holds true for Nature of Person N
582: -- where country of passport issue is Optional
583: -- If Passport number is provided, then Country of Passport Issue
584: -- must also be provided
585: -- if p_per_information2 is not null and p_per_information10 is null then
586: -- fnd_message.set_name('PAY', 'PY_ZA_ENTER_PASS_COUNTRY_ISSUE');
587: -- fnd_message.raise_error;
588: --end if ;
589:
590: if p_per_information10 is not null and p_per_information10 <> hr_api.g_varchar2 then
583: -- If Passport number is provided, then Country of Passport Issue
584: -- must also be provided
585: -- if p_per_information2 is not null and p_per_information10 is null then
586: -- fnd_message.set_name('PAY', 'PY_ZA_ENTER_PASS_COUNTRY_ISSUE');
587: -- fnd_message.raise_error;
588: --end if ;
589:
590: if p_per_information10 is not null and p_per_information10 <> hr_api.g_varchar2 then
591: if validate_charcter_set(p_per_information10,'ALPHA') = false then
588: --end if ;
589:
590: if p_per_information10 is not null and p_per_information10 <> hr_api.g_varchar2 then
591: if validate_charcter_set(p_per_information10,'ALPHA') = false then
592: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
593: fnd_message.set_token('FIELD', 'Country of Passport Issue');
594: fnd_message.raise_error;
595: end if;
596:
589:
590: if p_per_information10 is not null and p_per_information10 <> hr_api.g_varchar2 then
591: if validate_charcter_set(p_per_information10,'ALPHA') = false then
592: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
593: fnd_message.set_token('FIELD', 'Country of Passport Issue');
594: fnd_message.raise_error;
595: end if;
596:
597: if length(p_per_information10) > 3 then
590: if p_per_information10 is not null and p_per_information10 <> hr_api.g_varchar2 then
591: if validate_charcter_set(p_per_information10,'ALPHA') = false then
592: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
593: fnd_message.set_token('FIELD', 'Country of Passport Issue');
594: fnd_message.raise_error;
595: end if;
596:
597: if length(p_per_information10) > 3 then
598: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
594: fnd_message.raise_error;
595: end if;
596:
597: if length(p_per_information10) > 3 then
598: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
599: fnd_message.set_token('FIELD', 'Country of Passport Issue');
600: fnd_message.set_token('LENGTH', '3');
601: fnd_message.set_token('UNITS', 'characters');
602: fnd_message.raise_error;
595: end if;
596:
597: if length(p_per_information10) > 3 then
598: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
599: fnd_message.set_token('FIELD', 'Country of Passport Issue');
600: fnd_message.set_token('LENGTH', '3');
601: fnd_message.set_token('UNITS', 'characters');
602: fnd_message.raise_error;
603: end if;
596:
597: if length(p_per_information10) > 3 then
598: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
599: fnd_message.set_token('FIELD', 'Country of Passport Issue');
600: fnd_message.set_token('LENGTH', '3');
601: fnd_message.set_token('UNITS', 'characters');
602: fnd_message.raise_error;
603: end if;
604: end if;
597: if length(p_per_information10) > 3 then
598: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
599: fnd_message.set_token('FIELD', 'Country of Passport Issue');
600: fnd_message.set_token('LENGTH', '3');
601: fnd_message.set_token('UNITS', 'characters');
602: fnd_message.raise_error;
603: end if;
604: end if;
605:
598: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
599: fnd_message.set_token('FIELD', 'Country of Passport Issue');
600: fnd_message.set_token('LENGTH', '3');
601: fnd_message.set_token('UNITS', 'characters');
602: fnd_message.raise_error;
603: end if;
604: end if;
605:
606: hr_utility.set_location(l_proc,3);
747:
748: l_profile := fnd_profile.value('ZA_NOP_PERSON_LEVEL');
749:
750: IF (( NVL(l_profile,'N') = 'Y') and p_per_information12 IS NULL) then
751: fnd_message.set_name('PER', 'HR_ZA_ENTER_NOP_PERSON_LEVEL');
752: fnd_message.raise_error;
753: end if;
754:
755: -- Bug#12585688
748: l_profile := fnd_profile.value('ZA_NOP_PERSON_LEVEL');
749:
750: IF (( NVL(l_profile,'N') = 'Y') and p_per_information12 IS NULL) then
751: fnd_message.set_name('PER', 'HR_ZA_ENTER_NOP_PERSON_LEVEL');
752: fnd_message.raise_error;
753: end if;
754:
755: -- Bug#12585688
756: -- if p_per_information12 is not null then
805: -- bug 12914879
806: -- if length(p_per_information2)< 7 then
807: if length(p_per_information2)< 6 then
808: -- bug 12914879
809: fnd_message.set_name('PAY', 'PY_ZA_INVALID_MIN_LENGTH');
810: fnd_message.set_token('FIELD', 'Passport Number');
811: -- bug 12914879
812: -- fnd_message.set_token('LENGTH', '7');
813: fnd_message.set_token('LENGTH', '6');
806: -- if length(p_per_information2)< 7 then
807: if length(p_per_information2)< 6 then
808: -- bug 12914879
809: fnd_message.set_name('PAY', 'PY_ZA_INVALID_MIN_LENGTH');
810: fnd_message.set_token('FIELD', 'Passport Number');
811: -- bug 12914879
812: -- fnd_message.set_token('LENGTH', '7');
813: fnd_message.set_token('LENGTH', '6');
814: -- bug 12914879
808: -- bug 12914879
809: fnd_message.set_name('PAY', 'PY_ZA_INVALID_MIN_LENGTH');
810: fnd_message.set_token('FIELD', 'Passport Number');
811: -- bug 12914879
812: -- fnd_message.set_token('LENGTH', '7');
813: fnd_message.set_token('LENGTH', '6');
814: -- bug 12914879
815: fnd_message.set_token('UNITS', 'characters');
816: fnd_message.raise_error;
809: fnd_message.set_name('PAY', 'PY_ZA_INVALID_MIN_LENGTH');
810: fnd_message.set_token('FIELD', 'Passport Number');
811: -- bug 12914879
812: -- fnd_message.set_token('LENGTH', '7');
813: fnd_message.set_token('LENGTH', '6');
814: -- bug 12914879
815: fnd_message.set_token('UNITS', 'characters');
816: fnd_message.raise_error;
817: end if;
811: -- bug 12914879
812: -- fnd_message.set_token('LENGTH', '7');
813: fnd_message.set_token('LENGTH', '6');
814: -- bug 12914879
815: fnd_message.set_token('UNITS', 'characters');
816: fnd_message.raise_error;
817: end if;
818:
819: -- bug 13006122
812: -- fnd_message.set_token('LENGTH', '7');
813: fnd_message.set_token('LENGTH', '6');
814: -- bug 12914879
815: fnd_message.set_token('UNITS', 'characters');
816: fnd_message.raise_error;
817: end if;
818:
819: -- bug 13006122
820:
818:
819: -- bug 13006122
820:
821: if length(p_per_information2)> 13 then
822: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
823: fnd_message.set_token('FIELD', 'Passport Number');
824: fnd_message.set_token('LENGTH', '13');
825: fnd_message.set_token('UNITS', 'characters');
826: fnd_message.raise_error;
819: -- bug 13006122
820:
821: if length(p_per_information2)> 13 then
822: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
823: fnd_message.set_token('FIELD', 'Passport Number');
824: fnd_message.set_token('LENGTH', '13');
825: fnd_message.set_token('UNITS', 'characters');
826: fnd_message.raise_error;
827: end if;
820:
821: if length(p_per_information2)> 13 then
822: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
823: fnd_message.set_token('FIELD', 'Passport Number');
824: fnd_message.set_token('LENGTH', '13');
825: fnd_message.set_token('UNITS', 'characters');
826: fnd_message.raise_error;
827: end if;
828:
821: if length(p_per_information2)> 13 then
822: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
823: fnd_message.set_token('FIELD', 'Passport Number');
824: fnd_message.set_token('LENGTH', '13');
825: fnd_message.set_token('UNITS', 'characters');
826: fnd_message.raise_error;
827: end if;
828:
829: -- bug 13006122 ends
822: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
823: fnd_message.set_token('FIELD', 'Passport Number');
824: fnd_message.set_token('LENGTH', '13');
825: fnd_message.set_token('UNITS', 'characters');
826: fnd_message.raise_error;
827: end if;
828:
829: -- bug 13006122 ends
830:
829: -- bug 13006122 ends
830:
831:
832: if validate_charcter_set(p_per_information2,'ALPHANUM')= FALSE then
833: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
834: fnd_message.set_token('FIELD', 'Passport Number');
835: fnd_message.raise_error;
836: end if;
837: end if;
830:
831:
832: if validate_charcter_set(p_per_information2,'ALPHANUM')= FALSE then
833: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
834: fnd_message.set_token('FIELD', 'Passport Number');
835: fnd_message.raise_error;
836: end if;
837: end if;
838:
831:
832: if validate_charcter_set(p_per_information2,'ALPHANUM')= FALSE then
833: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
834: fnd_message.set_token('FIELD', 'Passport Number');
835: fnd_message.raise_error;
836: end if;
837: end if;
838:
839: -- Removing this validation, as it does not holds true for Nature of Person N
840: -- where country of passport issue is Optional
841: -- If Passport number is provided, then Country of Passport Issue
842: -- must also be provided
843: --if p_per_information2 is not null and p_per_information10 is null then
844: -- fnd_message.set_name('PAY', 'PY_ZA_ENTER_PASS_COUNTRY_ISSUE');
845: -- fnd_message.raise_error;
846: --end if ;
847:
848: if p_per_information10 is not null and p_per_information10 <> hr_api.g_varchar2 then
841: -- If Passport number is provided, then Country of Passport Issue
842: -- must also be provided
843: --if p_per_information2 is not null and p_per_information10 is null then
844: -- fnd_message.set_name('PAY', 'PY_ZA_ENTER_PASS_COUNTRY_ISSUE');
845: -- fnd_message.raise_error;
846: --end if ;
847:
848: if p_per_information10 is not null and p_per_information10 <> hr_api.g_varchar2 then
849: if validate_charcter_set(p_per_information10,'ALPHA') = false then
846: --end if ;
847:
848: if p_per_information10 is not null and p_per_information10 <> hr_api.g_varchar2 then
849: if validate_charcter_set(p_per_information10,'ALPHA') = false then
850: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
851: fnd_message.set_token('FIELD', 'Country of Passport Issue');
852: fnd_message.raise_error;
853: end if;
854:
847:
848: if p_per_information10 is not null and p_per_information10 <> hr_api.g_varchar2 then
849: if validate_charcter_set(p_per_information10,'ALPHA') = false then
850: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
851: fnd_message.set_token('FIELD', 'Country of Passport Issue');
852: fnd_message.raise_error;
853: end if;
854:
855: if length(p_per_information10) > 3 then
848: if p_per_information10 is not null and p_per_information10 <> hr_api.g_varchar2 then
849: if validate_charcter_set(p_per_information10,'ALPHA') = false then
850: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
851: fnd_message.set_token('FIELD', 'Country of Passport Issue');
852: fnd_message.raise_error;
853: end if;
854:
855: if length(p_per_information10) > 3 then
856: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
852: fnd_message.raise_error;
853: end if;
854:
855: if length(p_per_information10) > 3 then
856: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
857: fnd_message.set_token('FIELD', 'Country of Passport Issue');
858: fnd_message.set_token('LENGTH', '3');
859: fnd_message.set_token('UNITS', 'characters');
860: fnd_message.raise_error;
853: end if;
854:
855: if length(p_per_information10) > 3 then
856: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
857: fnd_message.set_token('FIELD', 'Country of Passport Issue');
858: fnd_message.set_token('LENGTH', '3');
859: fnd_message.set_token('UNITS', 'characters');
860: fnd_message.raise_error;
861: end if;
854:
855: if length(p_per_information10) > 3 then
856: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
857: fnd_message.set_token('FIELD', 'Country of Passport Issue');
858: fnd_message.set_token('LENGTH', '3');
859: fnd_message.set_token('UNITS', 'characters');
860: fnd_message.raise_error;
861: end if;
862: end if;
855: if length(p_per_information10) > 3 then
856: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
857: fnd_message.set_token('FIELD', 'Country of Passport Issue');
858: fnd_message.set_token('LENGTH', '3');
859: fnd_message.set_token('UNITS', 'characters');
860: fnd_message.raise_error;
861: end if;
862: end if;
863:
856: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
857: fnd_message.set_token('FIELD', 'Country of Passport Issue');
858: fnd_message.set_token('LENGTH', '3');
859: fnd_message.set_token('UNITS', 'characters');
860: fnd_message.raise_error;
861: end if;
862: end if;
863:
864: hr_utility.set_location(l_proc,3);
925: -- bug 12914879
926: -- if length(p_per_information2)< 7 then
927: if length(p_per_information2)< 6 then
928: -- bug 12914879
929: fnd_message.set_name('PAY', 'PY_ZA_INVALID_MIN_LENGTH');
930: fnd_message.set_token('FIELD', 'Passport Number');
931: -- bug 12914879
932: -- fnd_message.set_token('LENGTH', '7');
933: fnd_message.set_token('LENGTH', '6');
926: -- if length(p_per_information2)< 7 then
927: if length(p_per_information2)< 6 then
928: -- bug 12914879
929: fnd_message.set_name('PAY', 'PY_ZA_INVALID_MIN_LENGTH');
930: fnd_message.set_token('FIELD', 'Passport Number');
931: -- bug 12914879
932: -- fnd_message.set_token('LENGTH', '7');
933: fnd_message.set_token('LENGTH', '6');
934: -- bug 12914879
928: -- bug 12914879
929: fnd_message.set_name('PAY', 'PY_ZA_INVALID_MIN_LENGTH');
930: fnd_message.set_token('FIELD', 'Passport Number');
931: -- bug 12914879
932: -- fnd_message.set_token('LENGTH', '7');
933: fnd_message.set_token('LENGTH', '6');
934: -- bug 12914879
935: fnd_message.set_token('UNITS', 'characters');
936: fnd_message.raise_error;
929: fnd_message.set_name('PAY', 'PY_ZA_INVALID_MIN_LENGTH');
930: fnd_message.set_token('FIELD', 'Passport Number');
931: -- bug 12914879
932: -- fnd_message.set_token('LENGTH', '7');
933: fnd_message.set_token('LENGTH', '6');
934: -- bug 12914879
935: fnd_message.set_token('UNITS', 'characters');
936: fnd_message.raise_error;
937: end if;
931: -- bug 12914879
932: -- fnd_message.set_token('LENGTH', '7');
933: fnd_message.set_token('LENGTH', '6');
934: -- bug 12914879
935: fnd_message.set_token('UNITS', 'characters');
936: fnd_message.raise_error;
937: end if;
938:
939: -- bug 13006122
932: -- fnd_message.set_token('LENGTH', '7');
933: fnd_message.set_token('LENGTH', '6');
934: -- bug 12914879
935: fnd_message.set_token('UNITS', 'characters');
936: fnd_message.raise_error;
937: end if;
938:
939: -- bug 13006122
940:
938:
939: -- bug 13006122
940:
941: if length(p_per_information2)> 13 then
942: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
943: fnd_message.set_token('FIELD', 'Passport Number');
944: fnd_message.set_token('LENGTH', '13');
945: fnd_message.set_token('UNITS', 'characters');
946: fnd_message.raise_error;
939: -- bug 13006122
940:
941: if length(p_per_information2)> 13 then
942: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
943: fnd_message.set_token('FIELD', 'Passport Number');
944: fnd_message.set_token('LENGTH', '13');
945: fnd_message.set_token('UNITS', 'characters');
946: fnd_message.raise_error;
947: end if;
940:
941: if length(p_per_information2)> 13 then
942: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
943: fnd_message.set_token('FIELD', 'Passport Number');
944: fnd_message.set_token('LENGTH', '13');
945: fnd_message.set_token('UNITS', 'characters');
946: fnd_message.raise_error;
947: end if;
948:
941: if length(p_per_information2)> 13 then
942: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
943: fnd_message.set_token('FIELD', 'Passport Number');
944: fnd_message.set_token('LENGTH', '13');
945: fnd_message.set_token('UNITS', 'characters');
946: fnd_message.raise_error;
947: end if;
948:
949: -- bug 13006122 ends
942: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
943: fnd_message.set_token('FIELD', 'Passport Number');
944: fnd_message.set_token('LENGTH', '13');
945: fnd_message.set_token('UNITS', 'characters');
946: fnd_message.raise_error;
947: end if;
948:
949: -- bug 13006122 ends
950:
949: -- bug 13006122 ends
950:
951:
952: if validate_charcter_set(p_per_information2,'ALPHANUM')= FALSE then
953: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
954: fnd_message.set_token('FIELD', 'Passport Number');
955: fnd_message.raise_error;
956: end if;
957: end if;
950:
951:
952: if validate_charcter_set(p_per_information2,'ALPHANUM')= FALSE then
953: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
954: fnd_message.set_token('FIELD', 'Passport Number');
955: fnd_message.raise_error;
956: end if;
957: end if;
958:
951:
952: if validate_charcter_set(p_per_information2,'ALPHANUM')= FALSE then
953: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
954: fnd_message.set_token('FIELD', 'Passport Number');
955: fnd_message.raise_error;
956: end if;
957: end if;
958:
959: -- Removing this validation, as it does not holds true for Nature of Person N
960: -- where country of passport issue is Optional
961: -- If Passport number is provided, then Country of Passport Issue
962: -- must also be provided
963: --if p_per_information2 is not null and p_per_information10 is null then
964: -- fnd_message.set_name('PAY', 'PY_ZA_ENTER_PASS_COUNTRY_ISSUE');
965: -- fnd_message.raise_error;
966: --end if ;
967:
968: if p_per_information10 is not null and p_per_information10 <> hr_api.g_varchar2 then
961: -- If Passport number is provided, then Country of Passport Issue
962: -- must also be provided
963: --if p_per_information2 is not null and p_per_information10 is null then
964: -- fnd_message.set_name('PAY', 'PY_ZA_ENTER_PASS_COUNTRY_ISSUE');
965: -- fnd_message.raise_error;
966: --end if ;
967:
968: if p_per_information10 is not null and p_per_information10 <> hr_api.g_varchar2 then
969: if validate_charcter_set(p_per_information10,'ALPHA') = false then
966: --end if ;
967:
968: if p_per_information10 is not null and p_per_information10 <> hr_api.g_varchar2 then
969: if validate_charcter_set(p_per_information10,'ALPHA') = false then
970: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
971: fnd_message.set_token('FIELD', 'Country of Passport Issue');
972: fnd_message.raise_error;
973: end if;
974:
967:
968: if p_per_information10 is not null and p_per_information10 <> hr_api.g_varchar2 then
969: if validate_charcter_set(p_per_information10,'ALPHA') = false then
970: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
971: fnd_message.set_token('FIELD', 'Country of Passport Issue');
972: fnd_message.raise_error;
973: end if;
974:
975: if length(p_per_information10) > 3 then
968: if p_per_information10 is not null and p_per_information10 <> hr_api.g_varchar2 then
969: if validate_charcter_set(p_per_information10,'ALPHA') = false then
970: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
971: fnd_message.set_token('FIELD', 'Country of Passport Issue');
972: fnd_message.raise_error;
973: end if;
974:
975: if length(p_per_information10) > 3 then
976: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
972: fnd_message.raise_error;
973: end if;
974:
975: if length(p_per_information10) > 3 then
976: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
977: fnd_message.set_token('FIELD', 'Country of Passport Issue');
978: fnd_message.set_token('LENGTH', '3');
979: fnd_message.set_token('UNITS', 'characters');
980: fnd_message.raise_error;
973: end if;
974:
975: if length(p_per_information10) > 3 then
976: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
977: fnd_message.set_token('FIELD', 'Country of Passport Issue');
978: fnd_message.set_token('LENGTH', '3');
979: fnd_message.set_token('UNITS', 'characters');
980: fnd_message.raise_error;
981: end if;
974:
975: if length(p_per_information10) > 3 then
976: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
977: fnd_message.set_token('FIELD', 'Country of Passport Issue');
978: fnd_message.set_token('LENGTH', '3');
979: fnd_message.set_token('UNITS', 'characters');
980: fnd_message.raise_error;
981: end if;
982: end if;
975: if length(p_per_information10) > 3 then
976: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
977: fnd_message.set_token('FIELD', 'Country of Passport Issue');
978: fnd_message.set_token('LENGTH', '3');
979: fnd_message.set_token('UNITS', 'characters');
980: fnd_message.raise_error;
981: end if;
982: end if;
983:
976: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
977: fnd_message.set_token('FIELD', 'Country of Passport Issue');
978: fnd_message.set_token('LENGTH', '3');
979: fnd_message.set_token('UNITS', 'characters');
980: fnd_message.raise_error;
981: end if;
982: end if;
983:
984: hr_utility.set_location(l_proc,3);
1216: -- Validate the person's nature of person
1217: --
1218: l_profile := fnd_profile.value('ZA_NOP_PERSON_LEVEL');
1219: IF (( NVL(l_profile,'N') = 'Y') and l_person_nop IS NULL) then
1220: fnd_message.set_name('PER', 'HR_ZA_ENTER_NOP_PERSON_LEVEL');
1221: fnd_message.raise_error;
1222: end if;
1223:
1224: -- Bug#12585688
1217: --
1218: l_profile := fnd_profile.value('ZA_NOP_PERSON_LEVEL');
1219: IF (( NVL(l_profile,'N') = 'Y') and l_person_nop IS NULL) then
1220: fnd_message.set_name('PER', 'HR_ZA_ENTER_NOP_PERSON_LEVEL');
1221: fnd_message.raise_error;
1222: end if;
1223:
1224: -- Bug#12585688
1225: -- if p_per_information12 is not null then
1272: -- bug 12914879
1273: -- if length(p_per_information2)< 7 then
1274: if length(p_per_information2)< 6 then
1275: -- bug 12914879
1276: fnd_message.set_name('PAY', 'PY_ZA_INVALID_MIN_LENGTH');
1277: fnd_message.set_token('FIELD', 'Passport Number');
1278: -- bug 12914879
1279: -- fnd_message.set_token('LENGTH', '7');
1280: fnd_message.set_token('LENGTH', '6');
1273: -- if length(p_per_information2)< 7 then
1274: if length(p_per_information2)< 6 then
1275: -- bug 12914879
1276: fnd_message.set_name('PAY', 'PY_ZA_INVALID_MIN_LENGTH');
1277: fnd_message.set_token('FIELD', 'Passport Number');
1278: -- bug 12914879
1279: -- fnd_message.set_token('LENGTH', '7');
1280: fnd_message.set_token('LENGTH', '6');
1281: -- bug 12914879
1275: -- bug 12914879
1276: fnd_message.set_name('PAY', 'PY_ZA_INVALID_MIN_LENGTH');
1277: fnd_message.set_token('FIELD', 'Passport Number');
1278: -- bug 12914879
1279: -- fnd_message.set_token('LENGTH', '7');
1280: fnd_message.set_token('LENGTH', '6');
1281: -- bug 12914879
1282: fnd_message.set_token('UNITS', 'characters');
1283: fnd_message.raise_error;
1276: fnd_message.set_name('PAY', 'PY_ZA_INVALID_MIN_LENGTH');
1277: fnd_message.set_token('FIELD', 'Passport Number');
1278: -- bug 12914879
1279: -- fnd_message.set_token('LENGTH', '7');
1280: fnd_message.set_token('LENGTH', '6');
1281: -- bug 12914879
1282: fnd_message.set_token('UNITS', 'characters');
1283: fnd_message.raise_error;
1284: end if;
1278: -- bug 12914879
1279: -- fnd_message.set_token('LENGTH', '7');
1280: fnd_message.set_token('LENGTH', '6');
1281: -- bug 12914879
1282: fnd_message.set_token('UNITS', 'characters');
1283: fnd_message.raise_error;
1284: end if;
1285:
1286: -- bug 13006122
1279: -- fnd_message.set_token('LENGTH', '7');
1280: fnd_message.set_token('LENGTH', '6');
1281: -- bug 12914879
1282: fnd_message.set_token('UNITS', 'characters');
1283: fnd_message.raise_error;
1284: end if;
1285:
1286: -- bug 13006122
1287:
1285:
1286: -- bug 13006122
1287:
1288: if length(p_per_information2)> 13 then
1289: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
1290: fnd_message.set_token('FIELD', 'Passport Number');
1291: fnd_message.set_token('LENGTH', '13');
1292: fnd_message.set_token('UNITS', 'characters');
1293: fnd_message.raise_error;
1286: -- bug 13006122
1287:
1288: if length(p_per_information2)> 13 then
1289: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
1290: fnd_message.set_token('FIELD', 'Passport Number');
1291: fnd_message.set_token('LENGTH', '13');
1292: fnd_message.set_token('UNITS', 'characters');
1293: fnd_message.raise_error;
1294: end if;
1287:
1288: if length(p_per_information2)> 13 then
1289: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
1290: fnd_message.set_token('FIELD', 'Passport Number');
1291: fnd_message.set_token('LENGTH', '13');
1292: fnd_message.set_token('UNITS', 'characters');
1293: fnd_message.raise_error;
1294: end if;
1295:
1288: if length(p_per_information2)> 13 then
1289: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
1290: fnd_message.set_token('FIELD', 'Passport Number');
1291: fnd_message.set_token('LENGTH', '13');
1292: fnd_message.set_token('UNITS', 'characters');
1293: fnd_message.raise_error;
1294: end if;
1295:
1296: -- bug 13006122 ends
1289: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
1290: fnd_message.set_token('FIELD', 'Passport Number');
1291: fnd_message.set_token('LENGTH', '13');
1292: fnd_message.set_token('UNITS', 'characters');
1293: fnd_message.raise_error;
1294: end if;
1295:
1296: -- bug 13006122 ends
1297:
1295:
1296: -- bug 13006122 ends
1297:
1298: if validate_charcter_set(p_per_information2,'ALPHANUM')= FALSE then
1299: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1300: fnd_message.set_token('FIELD', 'Passport Number');
1301: fnd_message.raise_error;
1302: end if;
1303: end if;
1296: -- bug 13006122 ends
1297:
1298: if validate_charcter_set(p_per_information2,'ALPHANUM')= FALSE then
1299: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1300: fnd_message.set_token('FIELD', 'Passport Number');
1301: fnd_message.raise_error;
1302: end if;
1303: end if;
1304:
1297:
1298: if validate_charcter_set(p_per_information2,'ALPHANUM')= FALSE then
1299: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1300: fnd_message.set_token('FIELD', 'Passport Number');
1301: fnd_message.raise_error;
1302: end if;
1303: end if;
1304:
1305: -- Removing this validation, as it does not holds true for Nature of Person N
1306: -- where country of passport issue is Optional
1307: -- If Passport number is provided, then Country of Passport Issue
1308: -- must also be provided
1309: --if p_per_information2 is not null and p_per_information10 is null then
1310: -- fnd_message.set_name('PAY', 'PY_ZA_ENTER_PASS_COUNTRY_ISSUE');
1311: -- fnd_message.raise_error;
1312: --end if ;
1313:
1314: if p_per_information10 is not null and p_per_information10 <> hr_api.g_varchar2 then
1307: -- If Passport number is provided, then Country of Passport Issue
1308: -- must also be provided
1309: --if p_per_information2 is not null and p_per_information10 is null then
1310: -- fnd_message.set_name('PAY', 'PY_ZA_ENTER_PASS_COUNTRY_ISSUE');
1311: -- fnd_message.raise_error;
1312: --end if ;
1313:
1314: if p_per_information10 is not null and p_per_information10 <> hr_api.g_varchar2 then
1315: if validate_charcter_set(p_per_information10,'ALPHA') = false then
1312: --end if ;
1313:
1314: if p_per_information10 is not null and p_per_information10 <> hr_api.g_varchar2 then
1315: if validate_charcter_set(p_per_information10,'ALPHA') = false then
1316: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1317: fnd_message.set_token('FIELD', 'Country of Passport Issue');
1318: fnd_message.raise_error;
1319: end if;
1320:
1313:
1314: if p_per_information10 is not null and p_per_information10 <> hr_api.g_varchar2 then
1315: if validate_charcter_set(p_per_information10,'ALPHA') = false then
1316: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1317: fnd_message.set_token('FIELD', 'Country of Passport Issue');
1318: fnd_message.raise_error;
1319: end if;
1320:
1321: if length(p_per_information10) > 3 then
1314: if p_per_information10 is not null and p_per_information10 <> hr_api.g_varchar2 then
1315: if validate_charcter_set(p_per_information10,'ALPHA') = false then
1316: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1317: fnd_message.set_token('FIELD', 'Country of Passport Issue');
1318: fnd_message.raise_error;
1319: end if;
1320:
1321: if length(p_per_information10) > 3 then
1322: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
1318: fnd_message.raise_error;
1319: end if;
1320:
1321: if length(p_per_information10) > 3 then
1322: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
1323: fnd_message.set_token('FIELD', 'Country of Passport Issue');
1324: fnd_message.set_token('LENGTH', '3');
1325: fnd_message.set_token('UNITS', 'characters');
1326: fnd_message.raise_error;
1319: end if;
1320:
1321: if length(p_per_information10) > 3 then
1322: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
1323: fnd_message.set_token('FIELD', 'Country of Passport Issue');
1324: fnd_message.set_token('LENGTH', '3');
1325: fnd_message.set_token('UNITS', 'characters');
1326: fnd_message.raise_error;
1327: end if;
1320:
1321: if length(p_per_information10) > 3 then
1322: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
1323: fnd_message.set_token('FIELD', 'Country of Passport Issue');
1324: fnd_message.set_token('LENGTH', '3');
1325: fnd_message.set_token('UNITS', 'characters');
1326: fnd_message.raise_error;
1327: end if;
1328: end if;
1321: if length(p_per_information10) > 3 then
1322: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
1323: fnd_message.set_token('FIELD', 'Country of Passport Issue');
1324: fnd_message.set_token('LENGTH', '3');
1325: fnd_message.set_token('UNITS', 'characters');
1326: fnd_message.raise_error;
1327: end if;
1328: end if;
1329:
1322: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
1323: fnd_message.set_token('FIELD', 'Country of Passport Issue');
1324: fnd_message.set_token('LENGTH', '3');
1325: fnd_message.set_token('UNITS', 'characters');
1326: fnd_message.raise_error;
1327: end if;
1328: end if;
1329:
1330: hr_utility.set_location(l_proc,6);
1363: -- Employee Trade Name id mandatory if nature of person
1364: -- is in (D,E,F,G,H)
1365: IF P_AEI_INFORMATION4 in ('04','05','06','07','08') THEN
1366: IF P_AEI_INFORMATION2 is null THEN
1367: fnd_message.set_name('PAY', 'PY_ZA_ENTER_NAT_DEFGH_TRADE');
1368: fnd_message.raise_error;
1369: END IF;
1370: END IF;
1371:
1364: -- is in (D,E,F,G,H)
1365: IF P_AEI_INFORMATION4 in ('04','05','06','07','08') THEN
1366: IF P_AEI_INFORMATION2 is null THEN
1367: fnd_message.set_name('PAY', 'PY_ZA_ENTER_NAT_DEFGH_TRADE');
1368: fnd_message.raise_error;
1369: END IF;
1370: END IF;
1371:
1372: IF validate_charcter_set(P_AEI_INFORMATION2,'FREETEXT') = false then
1369: END IF;
1370: END IF;
1371:
1372: IF validate_charcter_set(P_AEI_INFORMATION2,'FREETEXT') = false then
1373: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1374: fnd_message.set_token('FIELD', 'Employee Trading Name');
1375: fnd_message.raise_error;
1376: END IF;
1377: -- SARS Reporting Account Name is mandatory if Payment Type is
1370: END IF;
1371:
1372: IF validate_charcter_set(P_AEI_INFORMATION2,'FREETEXT') = false then
1373: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1374: fnd_message.set_token('FIELD', 'Employee Trading Name');
1375: fnd_message.raise_error;
1376: END IF;
1377: -- SARS Reporting Account Name is mandatory if Payment Type is
1378: -- 'Internal Account Transfer'
1371:
1372: IF validate_charcter_set(P_AEI_INFORMATION2,'FREETEXT') = false then
1373: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1374: fnd_message.set_token('FIELD', 'Employee Trading Name');
1375: fnd_message.raise_error;
1376: END IF;
1377: -- SARS Reporting Account Name is mandatory if Payment Type is
1378: -- 'Internal Account Transfer'
1379: IF P_AEI_INFORMATION13 = '1' THEN
1377: -- SARS Reporting Account Name is mandatory if Payment Type is
1378: -- 'Internal Account Transfer'
1379: IF P_AEI_INFORMATION13 = '1' THEN
1380: IF P_AEI_INFORMATION14 is null THEN
1381: fnd_message.set_name('PAY', 'PY_ZA_ENTER_REP_ACC_NO');
1382: fnd_message.raise_error;
1383: END IF;
1384: END IF;
1385:
1378: -- 'Internal Account Transfer'
1379: IF P_AEI_INFORMATION13 = '1' THEN
1380: IF P_AEI_INFORMATION14 is null THEN
1381: fnd_message.set_name('PAY', 'PY_ZA_ENTER_REP_ACC_NO');
1382: fnd_message.raise_error;
1383: END IF;
1384: END IF;
1385:
1386: END IF;
1447: AND paaf.effective_start_date BETWEEN paf.effective_start_date
1448: AND paf.effective_end_date;
1449:
1450: if l_person_nop is not NULL and P_AEI_INFORMATION4 <> l_person_nop then
1451: fnd_message.set_name('PER', 'HR_ZA_UPDATE_NOP_PERSON_LEVEL');
1452: fnd_message.raise_error;
1453: end if;
1454: end if;
1455:
1448: AND paf.effective_end_date;
1449:
1450: if l_person_nop is not NULL and P_AEI_INFORMATION4 <> l_person_nop then
1451: fnd_message.set_name('PER', 'HR_ZA_UPDATE_NOP_PERSON_LEVEL');
1452: fnd_message.raise_error;
1453: end if;
1454: end if;
1455:
1456: EXCEPTION
1525: ) BETWEEN paaf.effective_start_date AND paaf.effective_end_date
1526: AND paaf.effective_start_date BETWEEN paf.effective_start_date AND paf.effective_end_date;
1527:
1528: if l_person_nop is not NULL and P_AEI_INFORMATION4 <> l_person_nop then
1529: fnd_message.set_name('PER', 'HR_ZA_UPDATE_NOP_PERSON_LEVEL');
1530: fnd_message.raise_error;
1531: end if;
1532: end if;
1533:
1526: AND paaf.effective_start_date BETWEEN paf.effective_start_date AND paf.effective_end_date;
1527:
1528: if l_person_nop is not NULL and P_AEI_INFORMATION4 <> l_person_nop then
1529: fnd_message.set_name('PER', 'HR_ZA_UPDATE_NOP_PERSON_LEVEL');
1530: fnd_message.raise_error;
1531: end if;
1532: end if;
1533:
1534: EXCEPTION
1562: begin
1563: -- Primary address must be with 'South Africa' address style
1564: -- This will be assumed and reported as Postal Address of the person
1565: if P_PRIMARY_FLAG = 'Y' and p_style <> 'ZA' then
1566: fnd_message.set_name('PER','HR_ZA_PRIM_ADD_STYLE');
1567: fnd_message.raise_error;
1568: end if;
1569:
1570: if p_style in('ZA_SARS','ZA_GRE') then
1563: -- Primary address must be with 'South Africa' address style
1564: -- This will be assumed and reported as Postal Address of the person
1565: if P_PRIMARY_FLAG = 'Y' and p_style <> 'ZA' then
1566: fnd_message.set_name('PER','HR_ZA_PRIM_ADD_STYLE');
1567: fnd_message.raise_error;
1568: end if;
1569:
1570: if p_style in('ZA_SARS','ZA_GRE') then
1571: -- ZA_SARS means Business / Residential address
1581: hr_utility.trace('Postal Code='||P_POSTAL_CODE);
1582: hr_utility.trace('Same as Res Address flag='||P_SAME_AS_RES_ADD);
1583:
1584: if P_SUBURB_DISTRICT is null and P_TOWN_OR_CITY is null then
1585: fnd_message.set_name('PER', 'HR_ZA_ENTER_DISTRICT_OR_TOWN');
1586: if p_style in('ZA_SARS') then
1587: fnd_message.set_token('LOCATION', 'Person Address');
1588: else
1589: fnd_message.set_token('LOCATION', 'Employer Address');
1583:
1584: if P_SUBURB_DISTRICT is null and P_TOWN_OR_CITY is null then
1585: fnd_message.set_name('PER', 'HR_ZA_ENTER_DISTRICT_OR_TOWN');
1586: if p_style in('ZA_SARS') then
1587: fnd_message.set_token('LOCATION', 'Person Address');
1588: else
1589: fnd_message.set_token('LOCATION', 'Employer Address');
1590: end if;
1591: fnd_message.raise_error;
1585: fnd_message.set_name('PER', 'HR_ZA_ENTER_DISTRICT_OR_TOWN');
1586: if p_style in('ZA_SARS') then
1587: fnd_message.set_token('LOCATION', 'Person Address');
1588: else
1589: fnd_message.set_token('LOCATION', 'Employer Address');
1590: end if;
1591: fnd_message.raise_error;
1592: end if ;
1593:
1587: fnd_message.set_token('LOCATION', 'Person Address');
1588: else
1589: fnd_message.set_token('LOCATION', 'Employer Address');
1590: end if;
1591: fnd_message.raise_error;
1592: end if ;
1593:
1594: if validate_charcter_set(P_UNIT_NUMBER,'ALPHANUM') = false then
1595: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1591: fnd_message.raise_error;
1592: end if ;
1593:
1594: if validate_charcter_set(P_UNIT_NUMBER,'ALPHANUM') = false then
1595: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1596: fnd_message.set_token('FIELD', 'Unit Number');
1597: fnd_message.raise_error;
1598: elsif validate_charcter_set(P_COMPLEX,'FREETEXT') = false then
1599: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1592: end if ;
1593:
1594: if validate_charcter_set(P_UNIT_NUMBER,'ALPHANUM') = false then
1595: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1596: fnd_message.set_token('FIELD', 'Unit Number');
1597: fnd_message.raise_error;
1598: elsif validate_charcter_set(P_COMPLEX,'FREETEXT') = false then
1599: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1600: fnd_message.set_token('FIELD', 'Complex');
1593:
1594: if validate_charcter_set(P_UNIT_NUMBER,'ALPHANUM') = false then
1595: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1596: fnd_message.set_token('FIELD', 'Unit Number');
1597: fnd_message.raise_error;
1598: elsif validate_charcter_set(P_COMPLEX,'FREETEXT') = false then
1599: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1600: fnd_message.set_token('FIELD', 'Complex');
1601: fnd_message.raise_error;
1595: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1596: fnd_message.set_token('FIELD', 'Unit Number');
1597: fnd_message.raise_error;
1598: elsif validate_charcter_set(P_COMPLEX,'FREETEXT') = false then
1599: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1600: fnd_message.set_token('FIELD', 'Complex');
1601: fnd_message.raise_error;
1602: elsif validate_charcter_set(P_STREET_NUMBER,'ALPHANUM') = false then
1603: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1596: fnd_message.set_token('FIELD', 'Unit Number');
1597: fnd_message.raise_error;
1598: elsif validate_charcter_set(P_COMPLEX,'FREETEXT') = false then
1599: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1600: fnd_message.set_token('FIELD', 'Complex');
1601: fnd_message.raise_error;
1602: elsif validate_charcter_set(P_STREET_NUMBER,'ALPHANUM') = false then
1603: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1604: fnd_message.set_token('FIELD', 'Street Number');
1597: fnd_message.raise_error;
1598: elsif validate_charcter_set(P_COMPLEX,'FREETEXT') = false then
1599: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1600: fnd_message.set_token('FIELD', 'Complex');
1601: fnd_message.raise_error;
1602: elsif validate_charcter_set(P_STREET_NUMBER,'ALPHANUM') = false then
1603: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1604: fnd_message.set_token('FIELD', 'Street Number');
1605: fnd_message.raise_error;
1599: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1600: fnd_message.set_token('FIELD', 'Complex');
1601: fnd_message.raise_error;
1602: elsif validate_charcter_set(P_STREET_NUMBER,'ALPHANUM') = false then
1603: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1604: fnd_message.set_token('FIELD', 'Street Number');
1605: fnd_message.raise_error;
1606: elsif validate_charcter_set(P_STREET_NAME,'FREETEXT') = false then
1607: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1600: fnd_message.set_token('FIELD', 'Complex');
1601: fnd_message.raise_error;
1602: elsif validate_charcter_set(P_STREET_NUMBER,'ALPHANUM') = false then
1603: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1604: fnd_message.set_token('FIELD', 'Street Number');
1605: fnd_message.raise_error;
1606: elsif validate_charcter_set(P_STREET_NAME,'FREETEXT') = false then
1607: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1608: fnd_message.set_token('FIELD', 'Street or Name of Farm');
1601: fnd_message.raise_error;
1602: elsif validate_charcter_set(P_STREET_NUMBER,'ALPHANUM') = false then
1603: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1604: fnd_message.set_token('FIELD', 'Street Number');
1605: fnd_message.raise_error;
1606: elsif validate_charcter_set(P_STREET_NAME,'FREETEXT') = false then
1607: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1608: fnd_message.set_token('FIELD', 'Street or Name of Farm');
1609: fnd_message.raise_error;
1603: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1604: fnd_message.set_token('FIELD', 'Street Number');
1605: fnd_message.raise_error;
1606: elsif validate_charcter_set(P_STREET_NAME,'FREETEXT') = false then
1607: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1608: fnd_message.set_token('FIELD', 'Street or Name of Farm');
1609: fnd_message.raise_error;
1610: elsif validate_charcter_set(P_SUBURB_DISTRICT,'FREETEXT') = false then
1611: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1604: fnd_message.set_token('FIELD', 'Street Number');
1605: fnd_message.raise_error;
1606: elsif validate_charcter_set(P_STREET_NAME,'FREETEXT') = false then
1607: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1608: fnd_message.set_token('FIELD', 'Street or Name of Farm');
1609: fnd_message.raise_error;
1610: elsif validate_charcter_set(P_SUBURB_DISTRICT,'FREETEXT') = false then
1611: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1612: fnd_message.set_token('FIELD', 'Suburb or District');
1605: fnd_message.raise_error;
1606: elsif validate_charcter_set(P_STREET_NAME,'FREETEXT') = false then
1607: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1608: fnd_message.set_token('FIELD', 'Street or Name of Farm');
1609: fnd_message.raise_error;
1610: elsif validate_charcter_set(P_SUBURB_DISTRICT,'FREETEXT') = false then
1611: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1612: fnd_message.set_token('FIELD', 'Suburb or District');
1613: fnd_message.raise_error;
1607: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1608: fnd_message.set_token('FIELD', 'Street or Name of Farm');
1609: fnd_message.raise_error;
1610: elsif validate_charcter_set(P_SUBURB_DISTRICT,'FREETEXT') = false then
1611: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1612: fnd_message.set_token('FIELD', 'Suburb or District');
1613: fnd_message.raise_error;
1614: elsif validate_charcter_set(P_TOWN_OR_CITY,'FREETEXT') = false then
1615: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1608: fnd_message.set_token('FIELD', 'Street or Name of Farm');
1609: fnd_message.raise_error;
1610: elsif validate_charcter_set(P_SUBURB_DISTRICT,'FREETEXT') = false then
1611: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1612: fnd_message.set_token('FIELD', 'Suburb or District');
1613: fnd_message.raise_error;
1614: elsif validate_charcter_set(P_TOWN_OR_CITY,'FREETEXT') = false then
1615: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1616: fnd_message.set_token('FIELD', 'City or Town');
1609: fnd_message.raise_error;
1610: elsif validate_charcter_set(P_SUBURB_DISTRICT,'FREETEXT') = false then
1611: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1612: fnd_message.set_token('FIELD', 'Suburb or District');
1613: fnd_message.raise_error;
1614: elsif validate_charcter_set(P_TOWN_OR_CITY,'FREETEXT') = false then
1615: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1616: fnd_message.set_token('FIELD', 'City or Town');
1617: fnd_message.raise_error;
1611: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1612: fnd_message.set_token('FIELD', 'Suburb or District');
1613: fnd_message.raise_error;
1614: elsif validate_charcter_set(P_TOWN_OR_CITY,'FREETEXT') = false then
1615: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1616: fnd_message.set_token('FIELD', 'City or Town');
1617: fnd_message.raise_error;
1618: elsif validate_charcter_set(P_POSTAL_CODE,'ALPHANUM') = false then
1619: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1612: fnd_message.set_token('FIELD', 'Suburb or District');
1613: fnd_message.raise_error;
1614: elsif validate_charcter_set(P_TOWN_OR_CITY,'FREETEXT') = false then
1615: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1616: fnd_message.set_token('FIELD', 'City or Town');
1617: fnd_message.raise_error;
1618: elsif validate_charcter_set(P_POSTAL_CODE,'ALPHANUM') = false then
1619: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1620: fnd_message.set_token('FIELD', 'Postal Code');
1613: fnd_message.raise_error;
1614: elsif validate_charcter_set(P_TOWN_OR_CITY,'FREETEXT') = false then
1615: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1616: fnd_message.set_token('FIELD', 'City or Town');
1617: fnd_message.raise_error;
1618: elsif validate_charcter_set(P_POSTAL_CODE,'ALPHANUM') = false then
1619: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1620: fnd_message.set_token('FIELD', 'Postal Code');
1621: fnd_message.raise_error;
1615: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1616: fnd_message.set_token('FIELD', 'City or Town');
1617: fnd_message.raise_error;
1618: elsif validate_charcter_set(P_POSTAL_CODE,'ALPHANUM') = false then
1619: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1620: fnd_message.set_token('FIELD', 'Postal Code');
1621: fnd_message.raise_error;
1622: end if ;
1623:
1616: fnd_message.set_token('FIELD', 'City or Town');
1617: fnd_message.raise_error;
1618: elsif validate_charcter_set(P_POSTAL_CODE,'ALPHANUM') = false then
1619: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1620: fnd_message.set_token('FIELD', 'Postal Code');
1621: fnd_message.raise_error;
1622: end if ;
1623:
1624: if p_style = 'ZA_GRE' then
1617: fnd_message.raise_error;
1618: elsif validate_charcter_set(P_POSTAL_CODE,'ALPHANUM') = false then
1619: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1620: fnd_message.set_token('FIELD', 'Postal Code');
1621: fnd_message.raise_error;
1622: end if ;
1623:
1624: if p_style = 'ZA_GRE' then
1625: if length(P_POSTAL_CODE)<> 4 then
1622: end if ;
1623:
1624: if p_style = 'ZA_GRE' then
1625: if length(P_POSTAL_CODE)<> 4 then
1626: fnd_message.set_name('PER', 'HR_ZA_INVALID_LENGTH');
1627: fnd_message.set_token('FIELD', 'Postal Code');
1628: fnd_message.set_token('LENGTH', '4');
1629: fnd_message.set_token('UNITS', 'digits');
1630: fnd_message.raise_error;
1623:
1624: if p_style = 'ZA_GRE' then
1625: if length(P_POSTAL_CODE)<> 4 then
1626: fnd_message.set_name('PER', 'HR_ZA_INVALID_LENGTH');
1627: fnd_message.set_token('FIELD', 'Postal Code');
1628: fnd_message.set_token('LENGTH', '4');
1629: fnd_message.set_token('UNITS', 'digits');
1630: fnd_message.raise_error;
1631: end if;
1624: if p_style = 'ZA_GRE' then
1625: if length(P_POSTAL_CODE)<> 4 then
1626: fnd_message.set_name('PER', 'HR_ZA_INVALID_LENGTH');
1627: fnd_message.set_token('FIELD', 'Postal Code');
1628: fnd_message.set_token('LENGTH', '4');
1629: fnd_message.set_token('UNITS', 'digits');
1630: fnd_message.raise_error;
1631: end if;
1632: end if;
1625: if length(P_POSTAL_CODE)<> 4 then
1626: fnd_message.set_name('PER', 'HR_ZA_INVALID_LENGTH');
1627: fnd_message.set_token('FIELD', 'Postal Code');
1628: fnd_message.set_token('LENGTH', '4');
1629: fnd_message.set_token('UNITS', 'digits');
1630: fnd_message.raise_error;
1631: end if;
1632: end if;
1633: elsif p_style = 'ZA' then
1626: fnd_message.set_name('PER', 'HR_ZA_INVALID_LENGTH');
1627: fnd_message.set_token('FIELD', 'Postal Code');
1628: fnd_message.set_token('LENGTH', '4');
1629: fnd_message.set_token('UNITS', 'digits');
1630: fnd_message.raise_error;
1631: end if;
1632: end if;
1633: elsif p_style = 'ZA' then
1634: -- Postal Address
1633: elsif p_style = 'ZA' then
1634: -- Postal Address
1635: if P_SAME_AS_RES_ADD is null or P_SAME_AS_RES_ADD = 'N' then
1636: if P_ADDRESS_LINE1 is null then
1637: fnd_message.set_name('PER', 'HR_ZA_NEW_ENTER_ADDRESS_LINE1');
1638: fnd_message.raise_error;
1639: end if;
1640: if P_POSTAL_CODE is null then
1641: fnd_message.set_name('PER', 'HR_ZA_NEW_ENTER_POSTAL_CODE');
1634: -- Postal Address
1635: if P_SAME_AS_RES_ADD is null or P_SAME_AS_RES_ADD = 'N' then
1636: if P_ADDRESS_LINE1 is null then
1637: fnd_message.set_name('PER', 'HR_ZA_NEW_ENTER_ADDRESS_LINE1');
1638: fnd_message.raise_error;
1639: end if;
1640: if P_POSTAL_CODE is null then
1641: fnd_message.set_name('PER', 'HR_ZA_NEW_ENTER_POSTAL_CODE');
1642: fnd_message.set_token('LOCATION', 'Postal Address');
1637: fnd_message.set_name('PER', 'HR_ZA_NEW_ENTER_ADDRESS_LINE1');
1638: fnd_message.raise_error;
1639: end if;
1640: if P_POSTAL_CODE is null then
1641: fnd_message.set_name('PER', 'HR_ZA_NEW_ENTER_POSTAL_CODE');
1642: fnd_message.set_token('LOCATION', 'Postal Address');
1643: fnd_message.raise_error;
1644: end if;
1645: end if ;
1638: fnd_message.raise_error;
1639: end if;
1640: if P_POSTAL_CODE is null then
1641: fnd_message.set_name('PER', 'HR_ZA_NEW_ENTER_POSTAL_CODE');
1642: fnd_message.set_token('LOCATION', 'Postal Address');
1643: fnd_message.raise_error;
1644: end if;
1645: end if ;
1646:
1639: end if;
1640: if P_POSTAL_CODE is null then
1641: fnd_message.set_name('PER', 'HR_ZA_NEW_ENTER_POSTAL_CODE');
1642: fnd_message.set_token('LOCATION', 'Postal Address');
1643: fnd_message.raise_error;
1644: end if;
1645: end if ;
1646:
1647: if validate_charcter_set(P_ADDRESS_LINE1,'FREETEXT') = false then
1644: end if;
1645: end if ;
1646:
1647: if validate_charcter_set(P_ADDRESS_LINE1,'FREETEXT') = false then
1648: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1649: fnd_message.set_token('FIELD', 'Address Line 1');
1650: fnd_message.raise_error;
1651: elsif validate_charcter_set(P_ADDRESS_LINE2,'FREETEXT') = false then
1652: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1645: end if ;
1646:
1647: if validate_charcter_set(P_ADDRESS_LINE1,'FREETEXT') = false then
1648: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1649: fnd_message.set_token('FIELD', 'Address Line 1');
1650: fnd_message.raise_error;
1651: elsif validate_charcter_set(P_ADDRESS_LINE2,'FREETEXT') = false then
1652: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1653: fnd_message.set_token('FIELD', 'Address Line 2');
1646:
1647: if validate_charcter_set(P_ADDRESS_LINE1,'FREETEXT') = false then
1648: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1649: fnd_message.set_token('FIELD', 'Address Line 1');
1650: fnd_message.raise_error;
1651: elsif validate_charcter_set(P_ADDRESS_LINE2,'FREETEXT') = false then
1652: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1653: fnd_message.set_token('FIELD', 'Address Line 2');
1654: fnd_message.raise_error;
1648: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1649: fnd_message.set_token('FIELD', 'Address Line 1');
1650: fnd_message.raise_error;
1651: elsif validate_charcter_set(P_ADDRESS_LINE2,'FREETEXT') = false then
1652: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1653: fnd_message.set_token('FIELD', 'Address Line 2');
1654: fnd_message.raise_error;
1655: elsif validate_charcter_set(P_ADDRESS_LINE3,'FREETEXT') = false then
1656: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1649: fnd_message.set_token('FIELD', 'Address Line 1');
1650: fnd_message.raise_error;
1651: elsif validate_charcter_set(P_ADDRESS_LINE2,'FREETEXT') = false then
1652: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1653: fnd_message.set_token('FIELD', 'Address Line 2');
1654: fnd_message.raise_error;
1655: elsif validate_charcter_set(P_ADDRESS_LINE3,'FREETEXT') = false then
1656: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1657: fnd_message.set_token('FIELD', 'Address Line 3');
1650: fnd_message.raise_error;
1651: elsif validate_charcter_set(P_ADDRESS_LINE2,'FREETEXT') = false then
1652: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1653: fnd_message.set_token('FIELD', 'Address Line 2');
1654: fnd_message.raise_error;
1655: elsif validate_charcter_set(P_ADDRESS_LINE3,'FREETEXT') = false then
1656: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1657: fnd_message.set_token('FIELD', 'Address Line 3');
1658: fnd_message.raise_error;
1652: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1653: fnd_message.set_token('FIELD', 'Address Line 2');
1654: fnd_message.raise_error;
1655: elsif validate_charcter_set(P_ADDRESS_LINE3,'FREETEXT') = false then
1656: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1657: fnd_message.set_token('FIELD', 'Address Line 3');
1658: fnd_message.raise_error;
1659: elsif validate_charcter_set(P_POSTAL_CODE,'ALPHANUM') = false then
1660: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1653: fnd_message.set_token('FIELD', 'Address Line 2');
1654: fnd_message.raise_error;
1655: elsif validate_charcter_set(P_ADDRESS_LINE3,'FREETEXT') = false then
1656: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1657: fnd_message.set_token('FIELD', 'Address Line 3');
1658: fnd_message.raise_error;
1659: elsif validate_charcter_set(P_POSTAL_CODE,'ALPHANUM') = false then
1660: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1661: fnd_message.set_token('FIELD', 'Postal Code');
1654: fnd_message.raise_error;
1655: elsif validate_charcter_set(P_ADDRESS_LINE3,'FREETEXT') = false then
1656: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1657: fnd_message.set_token('FIELD', 'Address Line 3');
1658: fnd_message.raise_error;
1659: elsif validate_charcter_set(P_POSTAL_CODE,'ALPHANUM') = false then
1660: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1661: fnd_message.set_token('FIELD', 'Postal Code');
1662: fnd_message.raise_error;
1656: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1657: fnd_message.set_token('FIELD', 'Address Line 3');
1658: fnd_message.raise_error;
1659: elsif validate_charcter_set(P_POSTAL_CODE,'ALPHANUM') = false then
1660: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1661: fnd_message.set_token('FIELD', 'Postal Code');
1662: fnd_message.raise_error;
1663: end if;
1664: end if;
1657: fnd_message.set_token('FIELD', 'Address Line 3');
1658: fnd_message.raise_error;
1659: elsif validate_charcter_set(P_POSTAL_CODE,'ALPHANUM') = false then
1660: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1661: fnd_message.set_token('FIELD', 'Postal Code');
1662: fnd_message.raise_error;
1663: end if;
1664: end if;
1665: end validate_address;
1658: fnd_message.raise_error;
1659: elsif validate_charcter_set(P_POSTAL_CODE,'ALPHANUM') = false then
1660: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1661: fnd_message.set_token('FIELD', 'Postal Code');
1662: fnd_message.raise_error;
1663: end if;
1664: end if;
1665: end validate_address;
1666:
1820: begin
1821: -- Org Info Type : ZA_GRE_TAX_FILE_ENTITY
1822: if p_org_info_type_code = 'ZA_GRE_TAX_FILE_ENTITY' then
1823: if validate_charcter_set(p_org_information1,'ALPHA') = false then
1824: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1825: fnd_message.set_token('FIELD', 'Contact Person');
1826: fnd_message.raise_error;
1827: end if;
1828:
1821: -- Org Info Type : ZA_GRE_TAX_FILE_ENTITY
1822: if p_org_info_type_code = 'ZA_GRE_TAX_FILE_ENTITY' then
1823: if validate_charcter_set(p_org_information1,'ALPHA') = false then
1824: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1825: fnd_message.set_token('FIELD', 'Contact Person');
1826: fnd_message.raise_error;
1827: end if;
1828:
1829: validate_phone_no(p_phone_type => 'GRE'
1822: if p_org_info_type_code = 'ZA_GRE_TAX_FILE_ENTITY' then
1823: if validate_charcter_set(p_org_information1,'ALPHA') = false then
1824: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1825: fnd_message.set_token('FIELD', 'Contact Person');
1826: fnd_message.raise_error;
1827: end if;
1828:
1829: validate_phone_no(p_phone_type => 'GRE'
1830: , p_phone_number => p_org_information2);
1842: ,P_POSTAL_CODE => p_org_information10
1843: );
1844: elsif p_org_info_type_code = 'ZA_LEGAL_ENTITY' then
1845: if validate_charcter_set(p_org_information1,'FREETEXT') = false then
1846: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1847: fnd_message.set_token('FIELD', 'Company Trading or Other Name');
1848: fnd_message.raise_error;
1849: end if;
1850:
1843: );
1844: elsif p_org_info_type_code = 'ZA_LEGAL_ENTITY' then
1845: if validate_charcter_set(p_org_information1,'FREETEXT') = false then
1846: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1847: fnd_message.set_token('FIELD', 'Company Trading or Other Name');
1848: fnd_message.raise_error;
1849: end if;
1850:
1851: if validate_charcter_set(p_org_information13,'NUMERIC') = false then
1844: elsif p_org_info_type_code = 'ZA_LEGAL_ENTITY' then
1845: if validate_charcter_set(p_org_information1,'FREETEXT') = false then
1846: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1847: fnd_message.set_token('FIELD', 'Company Trading or Other Name');
1848: fnd_message.raise_error;
1849: end if;
1850:
1851: if validate_charcter_set(p_org_information13,'NUMERIC') = false then
1852: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1848: fnd_message.raise_error;
1849: end if;
1850:
1851: if validate_charcter_set(p_org_information13,'NUMERIC') = false then
1852: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1853: fnd_message.set_token('FIELD', 'Trade Classification');
1854: fnd_message.raise_error;
1855: end if;
1856:
1849: end if;
1850:
1851: if validate_charcter_set(p_org_information13,'NUMERIC') = false then
1852: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1853: fnd_message.set_token('FIELD', 'Trade Classification');
1854: fnd_message.raise_error;
1855: end if;
1856:
1857: if length(p_org_information13) > 4 then
1850:
1851: if validate_charcter_set(p_org_information13,'NUMERIC') = false then
1852: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1853: fnd_message.set_token('FIELD', 'Trade Classification');
1854: fnd_message.raise_error;
1855: end if;
1856:
1857: if length(p_org_information13) > 4 then
1858: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
1854: fnd_message.raise_error;
1855: end if;
1856:
1857: if length(p_org_information13) > 4 then
1858: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
1859: fnd_message.set_token('FIELD', 'Trade Classification');
1860: fnd_message.set_token('LENGTH', '4');
1861: fnd_message.set_token('UNITS', 'digits');
1862: fnd_message.raise_error;
1855: end if;
1856:
1857: if length(p_org_information13) > 4 then
1858: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
1859: fnd_message.set_token('FIELD', 'Trade Classification');
1860: fnd_message.set_token('LENGTH', '4');
1861: fnd_message.set_token('UNITS', 'digits');
1862: fnd_message.raise_error;
1863: end if;
1856:
1857: if length(p_org_information13) > 4 then
1858: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
1859: fnd_message.set_token('FIELD', 'Trade Classification');
1860: fnd_message.set_token('LENGTH', '4');
1861: fnd_message.set_token('UNITS', 'digits');
1862: fnd_message.raise_error;
1863: end if;
1864:
1857: if length(p_org_information13) > 4 then
1858: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
1859: fnd_message.set_token('FIELD', 'Trade Classification');
1860: fnd_message.set_token('LENGTH', '4');
1861: fnd_message.set_token('UNITS', 'digits');
1862: fnd_message.raise_error;
1863: end if;
1864:
1865: -- 9864910 fix starts
1858: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
1859: fnd_message.set_token('FIELD', 'Trade Classification');
1860: fnd_message.set_token('LENGTH', '4');
1861: fnd_message.set_token('UNITS', 'digits');
1862: fnd_message.raise_error;
1863: end if;
1864:
1865: -- 9864910 fix starts
1866: if p_org_information15 = 'Y' and p_org_information12 is null then
1863: end if;
1864:
1865: -- 9864910 fix starts
1866: if p_org_information15 = 'Y' and p_org_information12 is null then
1867: fnd_message.set_name('PER', 'HR_ZA_INPUT_REQUIRED');
1868: fnd_message.set_token('FIELD', 'SDL Number');
1869: fnd_message.raise_error;
1870: end if;
1871:
1864:
1865: -- 9864910 fix starts
1866: if p_org_information15 = 'Y' and p_org_information12 is null then
1867: fnd_message.set_name('PER', 'HR_ZA_INPUT_REQUIRED');
1868: fnd_message.set_token('FIELD', 'SDL Number');
1869: fnd_message.raise_error;
1870: end if;
1871:
1872: if p_org_information16 = 'Y' and p_org_information6 is null then
1865: -- 9864910 fix starts
1866: if p_org_information15 = 'Y' and p_org_information12 is null then
1867: fnd_message.set_name('PER', 'HR_ZA_INPUT_REQUIRED');
1868: fnd_message.set_token('FIELD', 'SDL Number');
1869: fnd_message.raise_error;
1870: end if;
1871:
1872: if p_org_information16 = 'Y' and p_org_information6 is null then
1873: fnd_message.set_name('PER', 'HR_ZA_INPUT_REQUIRED');
1869: fnd_message.raise_error;
1870: end if;
1871:
1872: if p_org_information16 = 'Y' and p_org_information6 is null then
1873: fnd_message.set_name('PER', 'HR_ZA_INPUT_REQUIRED');
1874: fnd_message.set_token('FIELD', 'UIF Number');
1875: fnd_message.raise_error;
1876: end if;
1877:
1870: end if;
1871:
1872: if p_org_information16 = 'Y' and p_org_information6 is null then
1873: fnd_message.set_name('PER', 'HR_ZA_INPUT_REQUIRED');
1874: fnd_message.set_token('FIELD', 'UIF Number');
1875: fnd_message.raise_error;
1876: end if;
1877:
1878: -- 9815318 fix start
1871:
1872: if p_org_information16 = 'Y' and p_org_information6 is null then
1873: fnd_message.set_name('PER', 'HR_ZA_INPUT_REQUIRED');
1874: fnd_message.set_token('FIELD', 'UIF Number');
1875: fnd_message.raise_error;
1876: end if;
1877:
1878: -- 9815318 fix start
1879: if p_org_information16 = 'Y' and p_org_information17 is null then
1876: end if;
1877:
1878: -- 9815318 fix start
1879: if p_org_information16 = 'Y' and p_org_information17 is null then
1880: fnd_message.set_name('PER', 'HR_ZA_INPUT_REQUIRED');
1881: fnd_message.set_token('FIELD', 'UIF Number (UIF File)');
1882: fnd_message.raise_error;
1883: end if;
1884:
1877:
1878: -- 9815318 fix start
1879: if p_org_information16 = 'Y' and p_org_information17 is null then
1880: fnd_message.set_name('PER', 'HR_ZA_INPUT_REQUIRED');
1881: fnd_message.set_token('FIELD', 'UIF Number (UIF File)');
1882: fnd_message.raise_error;
1883: end if;
1884:
1885: -- 9815318 fix end
1878: -- 9815318 fix start
1879: if p_org_information16 = 'Y' and p_org_information17 is null then
1880: fnd_message.set_name('PER', 'HR_ZA_INPUT_REQUIRED');
1881: fnd_message.set_token('FIELD', 'UIF Number (UIF File)');
1882: fnd_message.raise_error;
1883: end if;
1884:
1885: -- 9815318 fix end
1886:
1886:
1887: if p_org_information12 is not null then
1888: l_sdl_num := UPPER(p_org_information12);
1889: if substr(l_sdl_num,1,1) <> 'L' OR length(l_sdl_num) <> 10 then
1890: fnd_message.set_name('PAY', 'PY_ZA_INVALID_FIRST_CHAR');
1891: fnd_message.set_token('FIELD','SDL Number');
1892: fnd_message.set_token('CHAR1','L');
1893: fnd_message.raise_error;
1894: end if;
1887: if p_org_information12 is not null then
1888: l_sdl_num := UPPER(p_org_information12);
1889: if substr(l_sdl_num,1,1) <> 'L' OR length(l_sdl_num) <> 10 then
1890: fnd_message.set_name('PAY', 'PY_ZA_INVALID_FIRST_CHAR');
1891: fnd_message.set_token('FIELD','SDL Number');
1892: fnd_message.set_token('CHAR1','L');
1893: fnd_message.raise_error;
1894: end if;
1895: if substr(l_sdl_num,2,9) <> substr(p_org_information3,2,9)
1888: l_sdl_num := UPPER(p_org_information12);
1889: if substr(l_sdl_num,1,1) <> 'L' OR length(l_sdl_num) <> 10 then
1890: fnd_message.set_name('PAY', 'PY_ZA_INVALID_FIRST_CHAR');
1891: fnd_message.set_token('FIELD','SDL Number');
1892: fnd_message.set_token('CHAR1','L');
1893: fnd_message.raise_error;
1894: end if;
1895: if substr(l_sdl_num,2,9) <> substr(p_org_information3,2,9)
1896: AND substr(p_org_information3,1,1) = '7' then
1889: if substr(l_sdl_num,1,1) <> 'L' OR length(l_sdl_num) <> 10 then
1890: fnd_message.set_name('PAY', 'PY_ZA_INVALID_FIRST_CHAR');
1891: fnd_message.set_token('FIELD','SDL Number');
1892: fnd_message.set_token('CHAR1','L');
1893: fnd_message.raise_error;
1894: end if;
1895: if substr(l_sdl_num,2,9) <> substr(p_org_information3,2,9)
1896: AND substr(p_org_information3,1,1) = '7' then
1897: fnd_message.set_name('PAY', 'PY_ZA_INVALID_LAST_NINE_CHAR');
1893: fnd_message.raise_error;
1894: end if;
1895: if substr(l_sdl_num,2,9) <> substr(p_org_information3,2,9)
1896: AND substr(p_org_information3,1,1) = '7' then
1897: fnd_message.set_name('PAY', 'PY_ZA_INVALID_LAST_NINE_CHAR');
1898: fnd_message.set_token('FIELD','SDL Number');
1899: fnd_message.raise_error;
1900: end if;
1901: if pay_za_eoy_val.modulus_10_test(l_sdl_num,'S') =0 then
1894: end if;
1895: if substr(l_sdl_num,2,9) <> substr(p_org_information3,2,9)
1896: AND substr(p_org_information3,1,1) = '7' then
1897: fnd_message.set_name('PAY', 'PY_ZA_INVALID_LAST_NINE_CHAR');
1898: fnd_message.set_token('FIELD','SDL Number');
1899: fnd_message.raise_error;
1900: end if;
1901: if pay_za_eoy_val.modulus_10_test(l_sdl_num,'S') =0 then
1902: fnd_message.set_name('PAY', 'PY_ZA_INVALID_SDL_NO');
1895: if substr(l_sdl_num,2,9) <> substr(p_org_information3,2,9)
1896: AND substr(p_org_information3,1,1) = '7' then
1897: fnd_message.set_name('PAY', 'PY_ZA_INVALID_LAST_NINE_CHAR');
1898: fnd_message.set_token('FIELD','SDL Number');
1899: fnd_message.raise_error;
1900: end if;
1901: if pay_za_eoy_val.modulus_10_test(l_sdl_num,'S') =0 then
1902: fnd_message.set_name('PAY', 'PY_ZA_INVALID_SDL_NO');
1903: fnd_message.raise_error;
1898: fnd_message.set_token('FIELD','SDL Number');
1899: fnd_message.raise_error;
1900: end if;
1901: if pay_za_eoy_val.modulus_10_test(l_sdl_num,'S') =0 then
1902: fnd_message.set_name('PAY', 'PY_ZA_INVALID_SDL_NO');
1903: fnd_message.raise_error;
1904: end if;
1905: end if;
1906:
1899: fnd_message.raise_error;
1900: end if;
1901: if pay_za_eoy_val.modulus_10_test(l_sdl_num,'S') =0 then
1902: fnd_message.set_name('PAY', 'PY_ZA_INVALID_SDL_NO');
1903: fnd_message.raise_error;
1904: end if;
1905: end if;
1906:
1907: if p_org_information6 is not null then
1909: l_uif_num := translate(l_uif_num,
1910: 'U0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ- "\/?@&$!#+=;:,''().',
1911: 'U0123456789');
1912: if substr(l_uif_num,1,1) <> 'U' OR length(l_uif_num) <> 10 then
1913: fnd_message.set_name('PAY', 'PY_ZA_INVALID_FIRST_CHAR');
1914: fnd_message.set_token('FIELD','UIF Number');
1915: fnd_message.set_token('CHAR1','U');
1916: fnd_message.raise_error;
1917: end if;
1910: 'U0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ- "\/?@&$!#+=;:,''().',
1911: 'U0123456789');
1912: if substr(l_uif_num,1,1) <> 'U' OR length(l_uif_num) <> 10 then
1913: fnd_message.set_name('PAY', 'PY_ZA_INVALID_FIRST_CHAR');
1914: fnd_message.set_token('FIELD','UIF Number');
1915: fnd_message.set_token('CHAR1','U');
1916: fnd_message.raise_error;
1917: end if;
1918: if substr(l_uif_num,2,9) <> substr(l_uif_num,2,9)
1911: 'U0123456789');
1912: if substr(l_uif_num,1,1) <> 'U' OR length(l_uif_num) <> 10 then
1913: fnd_message.set_name('PAY', 'PY_ZA_INVALID_FIRST_CHAR');
1914: fnd_message.set_token('FIELD','UIF Number');
1915: fnd_message.set_token('CHAR1','U');
1916: fnd_message.raise_error;
1917: end if;
1918: if substr(l_uif_num,2,9) <> substr(l_uif_num,2,9)
1919: AND substr(p_org_information3,1,1) = '7' then
1912: if substr(l_uif_num,1,1) <> 'U' OR length(l_uif_num) <> 10 then
1913: fnd_message.set_name('PAY', 'PY_ZA_INVALID_FIRST_CHAR');
1914: fnd_message.set_token('FIELD','UIF Number');
1915: fnd_message.set_token('CHAR1','U');
1916: fnd_message.raise_error;
1917: end if;
1918: if substr(l_uif_num,2,9) <> substr(l_uif_num,2,9)
1919: AND substr(p_org_information3,1,1) = '7' then
1920: fnd_message.set_name('PAY', 'PY_ZA_INVALID_LAST_NINE_CHAR');
1916: fnd_message.raise_error;
1917: end if;
1918: if substr(l_uif_num,2,9) <> substr(l_uif_num,2,9)
1919: AND substr(p_org_information3,1,1) = '7' then
1920: fnd_message.set_name('PAY', 'PY_ZA_INVALID_LAST_NINE_CHAR');
1921: fnd_message.set_token('FIELD','UIF Number');
1922: fnd_message.raise_error;
1923: end if;
1924: if pay_za_eoy_val.modulus_10_test(l_uif_num,'U') =0 then
1917: end if;
1918: if substr(l_uif_num,2,9) <> substr(l_uif_num,2,9)
1919: AND substr(p_org_information3,1,1) = '7' then
1920: fnd_message.set_name('PAY', 'PY_ZA_INVALID_LAST_NINE_CHAR');
1921: fnd_message.set_token('FIELD','UIF Number');
1922: fnd_message.raise_error;
1923: end if;
1924: if pay_za_eoy_val.modulus_10_test(l_uif_num,'U') =0 then
1925: fnd_message.set_name('PAY', 'PY_ZA_INVALID_UIF_NO');
1918: if substr(l_uif_num,2,9) <> substr(l_uif_num,2,9)
1919: AND substr(p_org_information3,1,1) = '7' then
1920: fnd_message.set_name('PAY', 'PY_ZA_INVALID_LAST_NINE_CHAR');
1921: fnd_message.set_token('FIELD','UIF Number');
1922: fnd_message.raise_error;
1923: end if;
1924: if pay_za_eoy_val.modulus_10_test(l_uif_num,'U') =0 then
1925: fnd_message.set_name('PAY', 'PY_ZA_INVALID_UIF_NO');
1926: fnd_message.raise_error;
1921: fnd_message.set_token('FIELD','UIF Number');
1922: fnd_message.raise_error;
1923: end if;
1924: if pay_za_eoy_val.modulus_10_test(l_uif_num,'U') =0 then
1925: fnd_message.set_name('PAY', 'PY_ZA_INVALID_UIF_NO');
1926: fnd_message.raise_error;
1927: end if;
1928: end if;
1929: -- 9864910 fix ends
1922: fnd_message.raise_error;
1923: end if;
1924: if pay_za_eoy_val.modulus_10_test(l_uif_num,'U') =0 then
1925: fnd_message.set_name('PAY', 'PY_ZA_INVALID_UIF_NO');
1926: fnd_message.raise_error;
1927: end if;
1928: end if;
1929: -- 9864910 fix ends
1930:
2041: and PPM_INFORMATION_CATEGORY in ('ZA_ACB','ZA_CHEQUE','ZA_CREDIT TRANSFER','ZA_MANUAL PAYMENT')
2042: and nvl(PPM_INFORMATION1,'N') in ('Y','0','7');
2043:
2044: if l_count > 0 then
2045: fnd_message.set_name('PAY','PY_ZA_INV_PERS_PAYM_DDF');
2046: fnd_message.raise_error;
2047: end if;
2048: end if;
2049: end if;
2042: and nvl(PPM_INFORMATION1,'N') in ('Y','0','7');
2043:
2044: if l_count > 0 then
2045: fnd_message.set_name('PAY','PY_ZA_INV_PERS_PAYM_DDF');
2046: fnd_message.raise_error;
2047: end if;
2048: end if;
2049: end if;
2050:
2080: and effective_start_date <= P_EFFECTIVE_END_DATE and effective_end_date >= P_EFFECTIVE_START_DATE
2081: and PPM_INFORMATION1 in ('Y','0','7');
2082:
2083: if l_count > 0 then
2084: fnd_message.set_name('PAY','PY_ZA_INV_PERS_PAYM_DDF');
2085: fnd_message.raise_error;
2086: end if;
2087: end if;
2088: end if;
2081: and PPM_INFORMATION1 in ('Y','0','7');
2082:
2083: if l_count > 0 then
2084: fnd_message.set_name('PAY','PY_ZA_INV_PERS_PAYM_DDF');
2085: fnd_message.raise_error;
2086: end if;
2087: end if;
2088: end if;
2089: end validate_update_per_payment;