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_UTILITY

Line 118: hr_utility.set_location('Entering '||l_proc,10);

114: l_invalid_char varchar2(1) := '~';
115: l_profile varchar2(1) := 'N';
116: BEGIN
117:
118: hr_utility.set_location('Entering '||l_proc,10);
119:
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

Line 121: hr_utility.set_location('Validation Nature of Person -Code 3020',10);

117:
118: hr_utility.set_location('Entering '||l_proc,10);
119:
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');

Line 123: hr_utility.set_location('Nature of Person is M',10);

119:
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

Line 128: hr_utility.set_location('Nature of Person is K',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');
131: fnd_message.raise_error;
132: end if;

Line 135: -- hr_utility.set_location('Validation EE Surname/Trading Name -Code 3030',15);

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

Line 138: -- hr_utility.set_location('EE Surname is null',15);

134: -- Validate Code Employee Surname/Trading Name (Code 3030)
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);

Line 142: -- hr_utility.set_location('EE Surname contains invalid characters',15);

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');
145: -- fnd_message.raise_error;
146: -- end if;

Line 151: hr_utility.set_location('EE Surname is null',16);

147: if p_nature in ('01','02','03','11') then
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;

Line 160: hr_utility.set_location('EE last name contains invalid characters',15);

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');
163: fnd_message.raise_error;
164: end if;

Line 169: hr_utility.set_location('Validation First Two Names -Code 3040',20);

165: end if; -- Bug#14361099
166: end if;
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');

Line 197: hr_utility.set_location('Validating Identity Number -Code 3060',22);

193: end if;
194:
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');

Line 205: hr_utility.set_location('p_ni:'||p_ni,22);

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');
207: fnd_message.set_token('FIELD', 'ID Number');
208: fnd_message.set_token('LENGTH', '13');
209: fnd_message.set_token('UNITS', 'digits');

Line 231: hr_utility.set_location('Validating Passport Number -Code 3070',22);

227: end if;
228: end if; -- Bug#14361099
229: end if;
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

Line 258: hr_utility.set_location('Validating Country of Issue -Code 3075',25);

254: end if; -- Bug#14361099
255: end if;
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

Line 280: hr_utility.set_location('Validating Income Tax Number -Code 3100',27);

276: end if ; -- Bug#14361099
277: end if;
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

Line 309: hr_utility.set_location('p_empno'|| p_empno, 14);

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);
310:
311: -- 11899934
312: -- Commenting out the validation for Employee Number as validation is done separately.
313: --Validate Employee Number (Code 3160)

Line 317: hr_utility.set_location('p_empno' || p_empno, 15);

313: --Validate Employee Number (Code 3160)
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;

Line 324: hr_utility.set_location('Leaving '||l_proc,200);

320: fnd_message.raise_error;
321: end if;
322: */
323: -- 11899934
324: hr_utility.set_location('Leaving '||l_proc,200);
325:
326: end validate_nature;
327:
328: -- 11899934

Line 387: hr_utility.set_location('Entering '||l_proc,10);

383: -- The employee number should be free text and shouldn't be
384: -- greater than 25 characters.
385: -- Validate Employee Number (Code 3160)
386:
387: hr_utility.set_location('Entering '||l_proc,10);
388: hr_utility.set_location('p_empno'|| p_emp_num, 10);
389: hr_utility.set_location('p_person_type_id'|| p_person_type_id, 15);
390:
391: if l_system_person_type = 'EMP' then

Line 388: hr_utility.set_location('p_empno'|| p_emp_num, 10);

384: -- greater than 25 characters.
385: -- Validate Employee Number (Code 3160)
386:
387: hr_utility.set_location('Entering '||l_proc,10);
388: hr_utility.set_location('p_empno'|| p_emp_num, 10);
389: hr_utility.set_location('p_person_type_id'|| p_person_type_id, 15);
390:
391: if l_system_person_type = 'EMP' then
392: --

Line 389: hr_utility.set_location('p_person_type_id'|| p_person_type_id, 15);

385: -- Validate Employee Number (Code 3160)
386:
387: hr_utility.set_location('Entering '||l_proc,10);
388: hr_utility.set_location('p_empno'|| p_emp_num, 10);
389: hr_utility.set_location('p_person_type_id'|| p_person_type_id, 15);
390:
391: if l_system_person_type = 'EMP' then
392: --
393: if ((p_emp_num is null)

Line 401: hr_utility.set_location('Leaving '||l_proc,20);

397: end if;
398:
399: end if;
400:
401: hr_utility.set_location('Leaving '||l_proc,20);
402:
403: end validate_emp_num;
404:
405: -- 11899934

Line 460: hr_utility.trace('p_phone_type='||p_phone_type);

456: procedure validate_phone_no ( p_phone_type in varchar2,
457: p_phone_number in varchar2) is
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);

Line 461: hr_utility.trace('p_phone_number='||p_phone_number);

457: p_phone_number in varchar2) is
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

Line 521: -- hr_utility.trace_on(null,'ZAUHK');

517: l_proc varchar2(40) := g_package||'validate_applicant';
518: l_person_type_id per_all_people_f.person_type_id%type;
519:
520: BEGIN
521: -- hr_utility.trace_on(null,'ZAUHK');
522: hr_utility.trace('validate person');
523: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN
524: hr_utility.set_location(l_proc,1);
525:

Line 522: hr_utility.trace('validate person');

518: l_person_type_id per_all_people_f.person_type_id%type;
519:
520: BEGIN
521: -- hr_utility.trace_on(null,'ZAUHK');
522: hr_utility.trace('validate person');
523: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN
524: hr_utility.set_location(l_proc,1);
525:
526: -- Check/Find person type id

Line 523: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN

519:
520: BEGIN
521: -- hr_utility.trace_on(null,'ZAUHK');
522: hr_utility.trace('validate person');
523: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN
524: hr_utility.set_location(l_proc,1);
525:
526: -- Check/Find person type id
527: --

Line 524: hr_utility.set_location(l_proc,1);

520: BEGIN
521: -- hr_utility.trace_on(null,'ZAUHK');
522: hr_utility.trace('validate person');
523: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN
524: hr_utility.set_location(l_proc,1);
525:
526: -- Check/Find person type id
527: --
528: per_per_bus.chk_person_type

Line 534: hr_utility.set_location(l_proc,2);

530: , p_business_group_id => p_business_group_id
531: , p_expected_sys_type => 'APL'
532: );
533:
534: hr_utility.set_location(l_proc,2);
535:
536: -- Validate the person's race
537: --
538: validate_race

Line 606: hr_utility.set_location(l_proc,3);

602: fnd_message.raise_error;
603: end if;
604: end if;
605:
606: hr_utility.set_location(l_proc,3);
607: END IF;
608: END validate_applicant;
609: -------------------------------------------------------------------------------
610: -- validate_employee

Line 691: -- hr_utility.trace_on(null,'ZAUHK');

687: l_profile varchar2(1) := 'N';
688: l_auto_generated varchar2(10); -- Bug#12674949
689:
690: BEGIN
691: -- hr_utility.trace_on(null,'ZAUHK');
692: -- hr_utility.trace('validate employee');
693: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN
694: hr_utility.set_location(l_proc,1);
695:

Line 692: -- hr_utility.trace('validate employee');

688: l_auto_generated varchar2(10); -- Bug#12674949
689:
690: BEGIN
691: -- hr_utility.trace_on(null,'ZAUHK');
692: -- hr_utility.trace('validate employee');
693: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN
694: hr_utility.set_location(l_proc,1);
695:
696: -- Check/Find person type id

Line 693: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN

689:
690: BEGIN
691: -- hr_utility.trace_on(null,'ZAUHK');
692: -- hr_utility.trace('validate employee');
693: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN
694: hr_utility.set_location(l_proc,1);
695:
696: -- Check/Find person type id
697: --

Line 694: hr_utility.set_location(l_proc,1);

690: BEGIN
691: -- hr_utility.trace_on(null,'ZAUHK');
692: -- hr_utility.trace('validate employee');
693: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN
694: hr_utility.set_location(l_proc,1);
695:
696: -- Check/Find person type id
697: --
698: per_per_bus.chk_person_type

Line 704: hr_utility.set_location(l_proc,2);

700: , p_business_group_id => p_business_group_id
701: , p_expected_sys_type => 'EMP'
702: );
703:
704: hr_utility.set_location(l_proc,2);
705:
706: -- 11899934
707:
708: -- Bug#12674949

Line 864: hr_utility.set_location(l_proc,3);

860: fnd_message.raise_error;
861: end if;
862: end if;
863:
864: hr_utility.set_location(l_proc,3);
865: END IF;
866: END validate_employee;
867: -------------------------------------------------------------------------------
868: -- validate_cwk

Line 896: -- hr_utility.trace_on(null,'ZAUHK');

892: l_proc varchar2(40) := g_package||'validate_cwk';
893: l_person_type_id per_all_people_f.person_type_id%type;
894:
895: BEGIN
896: -- hr_utility.trace_on(null,'ZAUHK');
897: hr_utility.trace('validate person');
898: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN
899: hr_utility.set_location(l_proc,1);
900:

Line 897: hr_utility.trace('validate person');

893: l_person_type_id per_all_people_f.person_type_id%type;
894:
895: BEGIN
896: -- hr_utility.trace_on(null,'ZAUHK');
897: hr_utility.trace('validate person');
898: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN
899: hr_utility.set_location(l_proc,1);
900:
901: -- Check/Find person type id

Line 898: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN

894:
895: BEGIN
896: -- hr_utility.trace_on(null,'ZAUHK');
897: hr_utility.trace('validate person');
898: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN
899: hr_utility.set_location(l_proc,1);
900:
901: -- Check/Find person type id
902: --

Line 899: hr_utility.set_location(l_proc,1);

895: BEGIN
896: -- hr_utility.trace_on(null,'ZAUHK');
897: hr_utility.trace('validate person');
898: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN
899: hr_utility.set_location(l_proc,1);
900:
901: -- Check/Find person type id
902: --
903: per_per_bus.chk_person_type

Line 909: hr_utility.set_location(l_proc,2);

905: , p_business_group_id => p_business_group_id
906: , p_expected_sys_type => 'CWK'
907: );
908:
909: hr_utility.set_location(l_proc,2);
910:
911: -- Validate the person's race
912: --
913: validate_race

Line 984: hr_utility.set_location(l_proc,3);

980: fnd_message.raise_error;
981: end if;
982: end if;
983:
984: hr_utility.set_location(l_proc,3);
985: END IF;
986: END validate_cwk;
987: -------------------------------------------------------------------------------
988: -- validate_person

Line 1110: -- hr_utility.trace_on(null,'ZAUHK');

1106:
1107: -- rec_nop_info c_person_nop%rowtype;
1108:
1109: BEGIN
1110: -- hr_utility.trace_on(null,'ZAUHK');
1111: -- hr_utility.trace('validate person');
1112: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN
1113: hr_utility.set_location(l_proc,1);
1114:

Line 1111: -- hr_utility.trace('validate person');

1107: -- rec_nop_info c_person_nop%rowtype;
1108:
1109: BEGIN
1110: -- hr_utility.trace_on(null,'ZAUHK');
1111: -- hr_utility.trace('validate person');
1112: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN
1113: hr_utility.set_location(l_proc,1);
1114:
1115: -- If the person type id was not passed

Line 1112: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN

1108:
1109: BEGIN
1110: -- hr_utility.trace_on(null,'ZAUHK');
1111: -- hr_utility.trace('validate person');
1112: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN
1113: hr_utility.set_location(l_proc,1);
1114:
1115: -- If the person type id was not passed
1116: --

Line 1113: hr_utility.set_location(l_proc,1);

1109: BEGIN
1110: -- hr_utility.trace_on(null,'ZAUHK');
1111: -- hr_utility.trace('validate person');
1112: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') 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

Line 1118: hr_utility.set_location(l_proc,2);

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;
1122: FETCH c_person_person_type INTO l_person_type_id;

Line 1125: hr_utility.set_location(l_proc,3);

1121: OPEN c_person_person_type;
1122: FETCH c_person_person_type INTO l_person_type_id;
1123: CLOSE c_person_person_type;
1124: ELSE
1125: hr_utility.set_location(l_proc,3);
1126: l_person_type_id := p_person_type_id;
1127: END IF;
1128:
1129: -- if the race field was not updated

Line 1132: hr_utility.set_location(l_proc,4);

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;
1136: FETCH c_person_race INTO l_person_race;

Line 1139: hr_utility.set_location(l_proc,5);

1135: OPEN c_person_race;
1136: FETCH c_person_race INTO l_person_race;
1137: CLOSE c_person_race;
1138: ELSE
1139: hr_utility.set_location(l_proc,5);
1140: l_person_race := p_per_information4;
1141: END IF;
1142:
1143: /* IF (fnd_release.major_version > 12 or

Line 1152: hr_utility.set_location(l_proc,4);

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;
1156: FETCH c_person_nop INTO l_person_nop;

Line 1159: hr_utility.set_location(l_proc,5);

1155: OPEN c_person_nop;
1156: FETCH c_person_nop INTO l_person_nop;
1157: CLOSE c_person_nop;
1158: ELSE
1159: hr_utility.set_location(l_proc,5);
1160: l_person_nop := p_per_information12;
1161: END IF;
1162:
1163: -- END IF;

Line 1269: hr_utility.set_location(l_proc,6);

1265: end if;
1266:
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

Line 1330: hr_utility.set_location(l_proc,6);

1326: fnd_message.raise_error;
1327: end if;
1328: end if;
1329:
1330: hr_utility.set_location(l_proc,6);
1331: END IF;
1332:
1333: END validate_person;
1334:

Line 1361: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN

1357: ) as
1358:
1359: begin
1360:
1361: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN
1362: IF P_AEI_INFORMATION_CATEGORY = 'ZA_SPECIFIC_INFO' THEN
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

Line 1403: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN

1399: l_asg_primary_flag varchar2(10);
1400: begin
1401:
1402:
1403: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN
1404: /* and (fnd_release.major_version > 12 or
1405: ((fnd_release.major_version = 12 and fnd_release.minor_version >= 2))
1406: or
1407: (FND_RELEASE.MAJOR_VERSION = 12 and FND_RELEASE.minor_version >= 1 and FND_RELEASE.point_version >= 4)) THEN */

Line 1480: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN

1476: l_asg_primary_flag varchar2(10);
1477: begin
1478:
1479:
1480: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN
1481: /* and (fnd_release.major_version > 12 or
1482: ((fnd_release.major_version = 12 and fnd_release.minor_version >= 2))
1483: or
1484: (FND_RELEASE.MAJOR_VERSION = 12 and FND_RELEASE.minor_version >= 1 and FND_RELEASE.point_version >= 4)) THEN */

Line 1573: hr_utility.trace('Address Type='||P_ADDRESS_TYPE);

1569:
1570: if p_style in('ZA_SARS','ZA_GRE') then
1571: -- ZA_SARS means Business / Residential address
1572: -- ZA_GRE means Legal Entity address
1573: hr_utility.trace('Address Type='||P_ADDRESS_TYPE);
1574: hr_utility.trace('Primary Flag='||P_PRIMARY_FLAG);
1575: hr_utility.trace('Unit Number='||P_UNIT_NUMBER);
1576: hr_utility.trace('Complex='||P_COMPLEX);
1577: hr_utility.trace('Street Number='||P_STREET_NUMBER);

Line 1574: hr_utility.trace('Primary Flag='||P_PRIMARY_FLAG);

1570: if p_style in('ZA_SARS','ZA_GRE') then
1571: -- ZA_SARS means Business / Residential address
1572: -- ZA_GRE means Legal Entity address
1573: hr_utility.trace('Address Type='||P_ADDRESS_TYPE);
1574: hr_utility.trace('Primary Flag='||P_PRIMARY_FLAG);
1575: hr_utility.trace('Unit Number='||P_UNIT_NUMBER);
1576: hr_utility.trace('Complex='||P_COMPLEX);
1577: hr_utility.trace('Street Number='||P_STREET_NUMBER);
1578: hr_utility.trace('Street or Name of Farm='||P_STREET_NAME);

Line 1575: hr_utility.trace('Unit Number='||P_UNIT_NUMBER);

1571: -- ZA_SARS means Business / Residential address
1572: -- ZA_GRE means Legal Entity address
1573: hr_utility.trace('Address Type='||P_ADDRESS_TYPE);
1574: hr_utility.trace('Primary Flag='||P_PRIMARY_FLAG);
1575: hr_utility.trace('Unit Number='||P_UNIT_NUMBER);
1576: hr_utility.trace('Complex='||P_COMPLEX);
1577: hr_utility.trace('Street Number='||P_STREET_NUMBER);
1578: hr_utility.trace('Street or Name of Farm='||P_STREET_NAME);
1579: hr_utility.trace('Suburb/District='||P_SUBURB_DISTRICT);

Line 1576: hr_utility.trace('Complex='||P_COMPLEX);

1572: -- ZA_GRE means Legal Entity address
1573: hr_utility.trace('Address Type='||P_ADDRESS_TYPE);
1574: hr_utility.trace('Primary Flag='||P_PRIMARY_FLAG);
1575: hr_utility.trace('Unit Number='||P_UNIT_NUMBER);
1576: hr_utility.trace('Complex='||P_COMPLEX);
1577: hr_utility.trace('Street Number='||P_STREET_NUMBER);
1578: hr_utility.trace('Street or Name of Farm='||P_STREET_NAME);
1579: hr_utility.trace('Suburb/District='||P_SUBURB_DISTRICT);
1580: hr_utility.trace('City/Town='||P_TOWN_OR_CITY);

Line 1577: hr_utility.trace('Street Number='||P_STREET_NUMBER);

1573: hr_utility.trace('Address Type='||P_ADDRESS_TYPE);
1574: hr_utility.trace('Primary Flag='||P_PRIMARY_FLAG);
1575: hr_utility.trace('Unit Number='||P_UNIT_NUMBER);
1576: hr_utility.trace('Complex='||P_COMPLEX);
1577: hr_utility.trace('Street Number='||P_STREET_NUMBER);
1578: hr_utility.trace('Street or Name of Farm='||P_STREET_NAME);
1579: hr_utility.trace('Suburb/District='||P_SUBURB_DISTRICT);
1580: hr_utility.trace('City/Town='||P_TOWN_OR_CITY);
1581: hr_utility.trace('Postal Code='||P_POSTAL_CODE);

Line 1578: hr_utility.trace('Street or Name of Farm='||P_STREET_NAME);

1574: hr_utility.trace('Primary Flag='||P_PRIMARY_FLAG);
1575: hr_utility.trace('Unit Number='||P_UNIT_NUMBER);
1576: hr_utility.trace('Complex='||P_COMPLEX);
1577: hr_utility.trace('Street Number='||P_STREET_NUMBER);
1578: hr_utility.trace('Street or Name of Farm='||P_STREET_NAME);
1579: hr_utility.trace('Suburb/District='||P_SUBURB_DISTRICT);
1580: hr_utility.trace('City/Town='||P_TOWN_OR_CITY);
1581: hr_utility.trace('Postal Code='||P_POSTAL_CODE);
1582: hr_utility.trace('Same as Res Address flag='||P_SAME_AS_RES_ADD);

Line 1579: hr_utility.trace('Suburb/District='||P_SUBURB_DISTRICT);

1575: hr_utility.trace('Unit Number='||P_UNIT_NUMBER);
1576: hr_utility.trace('Complex='||P_COMPLEX);
1577: hr_utility.trace('Street Number='||P_STREET_NUMBER);
1578: hr_utility.trace('Street or Name of Farm='||P_STREET_NAME);
1579: hr_utility.trace('Suburb/District='||P_SUBURB_DISTRICT);
1580: hr_utility.trace('City/Town='||P_TOWN_OR_CITY);
1581: hr_utility.trace('Postal Code='||P_POSTAL_CODE);
1582: hr_utility.trace('Same as Res Address flag='||P_SAME_AS_RES_ADD);
1583:

Line 1580: hr_utility.trace('City/Town='||P_TOWN_OR_CITY);

1576: hr_utility.trace('Complex='||P_COMPLEX);
1577: hr_utility.trace('Street Number='||P_STREET_NUMBER);
1578: hr_utility.trace('Street or Name of Farm='||P_STREET_NAME);
1579: hr_utility.trace('Suburb/District='||P_SUBURB_DISTRICT);
1580: hr_utility.trace('City/Town='||P_TOWN_OR_CITY);
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

Line 1581: hr_utility.trace('Postal Code='||P_POSTAL_CODE);

1577: hr_utility.trace('Street Number='||P_STREET_NUMBER);
1578: hr_utility.trace('Street or Name of Farm='||P_STREET_NAME);
1579: hr_utility.trace('Suburb/District='||P_SUBURB_DISTRICT);
1580: hr_utility.trace('City/Town='||P_TOWN_OR_CITY);
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');

Line 1582: hr_utility.trace('Same as Res Address flag='||P_SAME_AS_RES_ADD);

1578: hr_utility.trace('Street or Name of Farm='||P_STREET_NAME);
1579: hr_utility.trace('Suburb/District='||P_SUBURB_DISTRICT);
1580: hr_utility.trace('City/Town='||P_TOWN_OR_CITY);
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

Line 1959: hr_utility.trace('Validating value : '||p_input_value||' as '||p_mode);

1955:
1956: l_invalid_in_alphanum varchar2(100):= '~`!@#$%^&*()_+=|\[]{}<>":;?/.';
1957: l_invalid_in_alpha varchar2(100):= '~`!@#$%^&*()_+=|\[]{}<>":;?/.0123456789';
1958: begin
1959: hr_utility.trace('Validating value : '||p_input_value||' as '||p_mode);
1960: if p_mode = 'NUMERIC' then
1961: l_translated := translate (p_input_value
1962: , '~' || l_num
1963: , '~');

Line 2017: hr_utility.trace('l_translated='||l_translated);

2013: end if ;
2014: end if;
2015: */
2016:
2017: hr_utility.trace('l_translated='||l_translated);
2018: return l_result ;
2019: end validate_charcter_set;
2020:
2021: ----------------------------------------------------------------------------

Line 2033: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN

2029: is
2030: l_count NUMBER;
2031: begin
2032: l_count := 0;
2033: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN
2034: if P_PPM_INFORMATION1 in ('Y','0','7') then
2035: select count(*)
2036: into l_count
2037: from pay_personal_payment_methods_f

Line 2066: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN

2062: l_count NUMBER;
2063: l_assignment_id per_all_assignments_f.assignment_id%type;
2064: begin
2065: l_count := 0;
2066: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN
2067: select assignment_id
2068: into l_assignment_id
2069: from pay_personal_payment_methods_f
2070: where personal_payment_method_id = P_PERSONAL_PAYMENT_METHOD_ID