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

APPS.PER_ZA_USER_HOOK_PKG dependencies on HR_API

Line 63: hr_api.not_exists_in_hr_lookups

59: )
60: THEN
61: IF p_race_code IS NULL OR
62: p_race_code = 'N' OR
63: hr_api.not_exists_in_hr_lookups
64: (p_effective_date => p_effective_date
65: ,p_lookup_type => 'ZA_RACE'
66: ,p_lookup_code => p_race_code
67: )

Line 158: if p_last_name <> hr_api.g_varchar2 then -- Bug#14361099

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
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');

Line 171: if p_first_name <> hr_api.g_varchar2 and p_middle_name <> hr_api.g_varchar2 then -- Bug#14361099

167:
168: --Validate First Two Names ( Code 3040 )
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*/

Line 199: if p_ni <> hr_api.g_varchar2 then -- Bug#14361099

195:
196: --Validate Identity Number (Code 3060)
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;

Line 234: if p_passport_no <> hr_api.g_varchar2 then

230: --Validate Passport Number (Code 3070)
231: hr_utility.set_location('Validating Passport Number -Code 3070',22);
232:
233: if p_nature not in ('02','04','05','06','07','08') and p_passport_no is not null then
234: if p_passport_no <> hr_api.g_varchar2 then
235: -- bug 12914879
236: -- if length(p_passport_no)< 7 then
237: if length(p_passport_no)< 6 then
238: -- bug 12914879

Line 263: if p_country_passport <> hr_api.g_varchar2 then -- Bug#14361099

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');
266: fnd_message.set_token('FIELD', 'Country of Passport Issue');
267: fnd_message.raise_error;

Line 286: if p_it_no_value <> hr_api.g_varchar2 then -- Bug#14361099

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
288: fnd_message.set_name('PAY', 'PY_ZA_INVALID_IT_TAX_NO');
289: fnd_message.raise_error;
290: end if;

Line 427: if p_email_id is not null and p_email_id <> hr_api.g_varchar2 then

423: ---------------------------------------------------------------------------
424: procedure validate_email_id (p_email_id varchar2 ) is
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');

Line 462: if p_phone_number is not null and p_phone_number <> hr_api.g_varchar2 then

458: l_phone_int number ;
459: begin
460: hr_utility.trace('p_phone_type='||p_phone_type);
461: hr_utility.trace('p_phone_number='||p_phone_number);
462: if p_phone_number is not null and p_phone_number <> hr_api.g_varchar2 then
463: begin
464: l_phone_int := to_number(p_phone_number);
465: exception
466: when others then

Line 547: if p_per_information2 is not null and p_per_information2 <> hr_api.g_varchar2 then

543:
544: validate_email_id
545: ( p_email_id => p_email_address);
546:
547: if p_per_information2 is not null and p_per_information2 <> hr_api.g_varchar2 then
548: -- bug 12914879
549: -- if length(p_per_information2)< 7 then
550: if length(p_per_information2)< 6 then
551: -- bug 12914879

Line 590: if p_per_information10 is not null and p_per_information10 <> hr_api.g_varchar2 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
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;

Line 760: if p_per_information12 is not null and p_per_information12 <> hr_api.g_varchar2 then

756: -- if p_per_information12 is not null then
757:
758: -- Modifying the check condition for Nature of person
759:
760: if p_per_information12 is not null and p_per_information12 <> hr_api.g_varchar2 then
761:
762: -- Bug#12585688
763:
764: validate_nature

Line 804: if p_per_information2 is not null and p_per_information2 <> hr_api.g_varchar2 then

800: end if;
801:
802: -- END IF;
803:
804: if p_per_information2 is not null and p_per_information2 <> hr_api.g_varchar2 then
805: -- bug 12914879
806: -- if length(p_per_information2)< 7 then
807: if length(p_per_information2)< 6 then
808: -- bug 12914879

Line 848: if p_per_information10 is not null and p_per_information10 <> hr_api.g_varchar2 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
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;

Line 924: if p_per_information2 is not null and p_per_information2 <> hr_api.g_varchar2 then

920: -- Validate email_address
921: validate_email_id
922: ( p_email_id => p_email_address);
923:
924: if p_per_information2 is not null and p_per_information2 <> hr_api.g_varchar2 then
925: -- bug 12914879
926: -- if length(p_per_information2)< 7 then
927: if length(p_per_information2)< 6 then
928: -- bug 12914879

Line 968: if p_per_information10 is not null and p_per_information10 <> hr_api.g_varchar2 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
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;

Line 1117: IF p_person_type_id = hr_api.g_number THEN

1113: hr_utility.set_location(l_proc,1);
1114:
1115: -- If the person type id was not passed
1116: --
1117: IF p_person_type_id = hr_api.g_number THEN
1118: hr_utility.set_location(l_proc,2);
1119: -- Find the person's person type
1120: --
1121: OPEN c_person_person_type;

Line 1131: IF p_per_information4 = hr_api.g_varchar2 THEN

1127: END IF;
1128:
1129: -- if the race field was not updated
1130: --
1131: IF p_per_information4 = hr_api.g_varchar2 THEN
1132: hr_utility.set_location(l_proc,4);
1133: -- find the person's race
1134: --
1135: OPEN c_person_race;

Line 1151: IF p_per_information12 is null OR p_per_information12 = hr_api.g_varchar2 THEN

1147:
1148:
1149: -- if the nature of person field was not updated
1150: --
1151: IF p_per_information12 is null OR p_per_information12 = hr_api.g_varchar2 THEN
1152: hr_utility.set_location(l_proc,4);
1153: -- find the person's nature of person
1154: --
1155: OPEN c_person_nop;

Line 1229: if l_person_nop is not null and l_person_nop <> hr_api.g_varchar2 then

1225: -- if p_per_information12 is not null then
1226:
1227: -- Modifying the check condition for Nature of person
1228:
1229: if l_person_nop is not null and l_person_nop <> hr_api.g_varchar2 then
1230: -- Bug#12585688
1231: validate_nature
1232: ( p_effective_date => p_effective_date
1233: , p_nature => l_person_nop

Line 1271: if p_per_information2 is not null and p_per_information2 <> hr_api.g_varchar2 then

1267: -- END IF;
1268:
1269: hr_utility.set_location(l_proc,6);
1270:
1271: if p_per_information2 is not null and p_per_information2 <> hr_api.g_varchar2 then
1272: -- bug 12914879
1273: -- if length(p_per_information2)< 7 then
1274: if length(p_per_information2)< 6 then
1275: -- bug 12914879

Line 1314: if p_per_information10 is not null and p_per_information10 <> hr_api.g_varchar2 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
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;