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.

[Home] [Help]

APPS.HR_PERSON dependencies on HR_UTILITY

Line 4: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY hr_person AS
2: /* $Header: peperson.pkb 120.5.12010000.2 2008/08/06 09:27:37 ubhat ship $ */
3: --
4: g_debug boolean := hr_utility.debug_enabled;
5:
6: -- Bug 2678794: defintions changed to varchar2
7: -- to avoid ORA-06502 when implicit numeric conversions occur.
8: --

Line 90: hr_utility.trace('Unique Person Number 999');

86:
87: EXCEPTION
88: when no_data_found then
89: if g_debug then
90: hr_utility.trace('Unique Person Number 999');
91: end if;
92: return('Y');
93:
94: END IS_UNIQUE_PERSON_NUMBER;

Line 177: hr_utility.set_message(800,'HR_7692_PERSON_NUM_EXIST');

173:
174: if l_is_unique = 'N' then
175: p_person_number := null;
176: if p_person_type = 'EMP' then
177: hr_utility.set_message(800,'HR_7692_PERSON_NUM_EXIST');
178: elsif p_person_type = 'APL' then
179: hr_utility.set_message(800,'HR_7693_PERSON_NUM_EXISTS');
180: elsif p_person_type = 'CWK' then
181: hr_utility.set_message(800,'HR_289656_CWK_NUM_EXIST');

Line 179: hr_utility.set_message(800,'HR_7693_PERSON_NUM_EXISTS');

175: p_person_number := null;
176: if p_person_type = 'EMP' then
177: hr_utility.set_message(800,'HR_7692_PERSON_NUM_EXIST');
178: elsif p_person_type = 'APL' then
179: hr_utility.set_message(800,'HR_7693_PERSON_NUM_EXISTS');
180: elsif p_person_type = 'CWK' then
181: hr_utility.set_message(800,'HR_289656_CWK_NUM_EXIST');
182: end if;
183: hr_utility.raise_error;

Line 181: hr_utility.set_message(800,'HR_289656_CWK_NUM_EXIST');

177: hr_utility.set_message(800,'HR_7692_PERSON_NUM_EXIST');
178: elsif p_person_type = 'APL' then
179: hr_utility.set_message(800,'HR_7693_PERSON_NUM_EXISTS');
180: elsif p_person_type = 'CWK' then
181: hr_utility.set_message(800,'HR_289656_CWK_NUM_EXIST');
182: end if;
183: hr_utility.raise_error;
184: end if;
185: p_person_number := l_person_number;

Line 183: hr_utility.raise_error;

179: hr_utility.set_message(800,'HR_7693_PERSON_NUM_EXISTS');
180: elsif p_person_type = 'CWK' then
181: hr_utility.set_message(800,'HR_289656_CWK_NUM_EXIST');
182: end if;
183: hr_utility.raise_error;
184: end if;
185: p_person_number := l_person_number;
186: ELSE
187: -- ------------------------------------------------------------------------+

Line 227: hr_utility.set_message(800,'HR_7692_PERSON_NUM_EXIST');

223: END LOOP;
224: if l_is_unique = 'N' then
225: p_person_number := null;
226: if p_person_type = 'EMP' then
227: hr_utility.set_message(800,'HR_7692_PERSON_NUM_EXIST');
228: elsif p_person_type = 'APL' then
229: hr_utility.set_message(800,'HR_7693_PERSON_NUM_EXISTS');
230: elsif p_person_type = 'CWK' then
231: hr_utility.set_message(800,'HR_289656_CWK_NUM_EXIST');

Line 229: hr_utility.set_message(800,'HR_7693_PERSON_NUM_EXISTS');

225: p_person_number := null;
226: if p_person_type = 'EMP' then
227: hr_utility.set_message(800,'HR_7692_PERSON_NUM_EXIST');
228: elsif p_person_type = 'APL' then
229: hr_utility.set_message(800,'HR_7693_PERSON_NUM_EXISTS');
230: elsif p_person_type = 'CWK' then
231: hr_utility.set_message(800,'HR_289656_CWK_NUM_EXIST');
232: end if;
233: hr_utility.raise_error;

Line 231: hr_utility.set_message(800,'HR_289656_CWK_NUM_EXIST');

227: hr_utility.set_message(800,'HR_7692_PERSON_NUM_EXIST');
228: elsif p_person_type = 'APL' then
229: hr_utility.set_message(800,'HR_7693_PERSON_NUM_EXISTS');
230: elsif p_person_type = 'CWK' then
231: hr_utility.set_message(800,'HR_289656_CWK_NUM_EXIST');
232: end if;
233: hr_utility.raise_error;
234: else
235: if NOT l_use_sequence then

Line 233: hr_utility.raise_error;

229: hr_utility.set_message(800,'HR_7693_PERSON_NUM_EXISTS');
230: elsif p_person_type = 'CWK' then
231: hr_utility.set_message(800,'HR_289656_CWK_NUM_EXIST');
232: end if;
233: hr_utility.raise_error;
234: else
235: if NOT l_use_sequence then
236: UPDATE per_number_generation_controls
237: SET next_value = l_person_number + 1

Line 245: hr_utility.set_message(800,'PER_289194_MAX_NUM_REACHED');

241: p_person_number := l_person_number;
242: end if;
243: EXCEPTION
244: when e_MaxExceeds then
245: hr_utility.set_message(800,'PER_289194_MAX_NUM_REACHED');
246: hr_utility.raise_error;
247: END;
248: -- ------------------------------------------------------------------------+
249: -- End existing mechanisms +

Line 246: hr_utility.raise_error;

242: end if;
243: EXCEPTION
244: when e_MaxExceeds then
245: hr_utility.set_message(800,'PER_289194_MAX_NUM_REACHED');
246: hr_utility.raise_error;
247: END;
248: -- ------------------------------------------------------------------------+
249: -- End existing mechanisms +
250: -- ------------------------------------------------------------------------+

Line 323: hr_utility.set_location('hr_person.generate_number',1);

319: --
320: begin
321: --
322: --
323: hr_utility.set_location('hr_person.generate_number',1);
324: --
325: if p_current_applicant = 'Y' then
326: --
327: if g_debug then

Line 328: hr_utility.set_location('number_generation',1);

324: --
325: if p_current_applicant = 'Y' then
326: --
327: if g_debug then
328: hr_utility.set_location('number_generation',1);
329: end if;
330: --
331: SELECT pbg.method_of_generation_apl_num
332: , pbg.legislation_code

Line 340: hr_utility.set_location('number_generation',2);

336: WHERE pbg.business_group_id = p_business_group_id;
337: --
338: if l_method_of_generation = 'A' then
339: if g_debug then
340: hr_utility.set_location('number_generation',2);
341: end if;
342: if p_applicant_number is NOT NULL then
343: begin
344: select person_id

Line 396: hr_utility.set_location('hr_person.generate_number',15);

392: exception
393: when others then p_applicant_number := NULL;
394: end;
395: if g_debug then
396: hr_utility.set_location('hr_person.generate_number',15);
397: end if;
398: apl_number_sv := p_applicant_number;
399: end if;
400: -- <<

Line 433: hr_utility.set_location('hr_person.generate_number',20);

429: -- WHERE rowid = l_rowid ;
430: -- ------------------------------------------------------------+
431:
432: if g_debug then
433: hr_utility.set_location('hr_person.generate_number',20);
434: end if;
435: apl_number_sv := p_applicant_number;
436:
437: end if;

Line 448: hr_utility.set_message(801,'HR_7580_ALL_MAN_SOL_FIELD');

444: )
445: then
446: if p_national_identifier is null then
447: if l_legislation_code = 'US' then
448: hr_utility.set_message(801,'HR_7580_ALL_MAN_SOL_FIELD');
449: else
450: hr_utility.set_message(801,'HR_7578_ALL_MAN_NAT_FIELD');
451: end if;
452: hr_utility.raise_error;

Line 450: hr_utility.set_message(801,'HR_7578_ALL_MAN_NAT_FIELD');

446: if p_national_identifier is null then
447: if l_legislation_code = 'US' then
448: hr_utility.set_message(801,'HR_7580_ALL_MAN_SOL_FIELD');
449: else
450: hr_utility.set_message(801,'HR_7578_ALL_MAN_NAT_FIELD');
451: end if;
452: hr_utility.raise_error;
453: elsif p_applicant_number is null then -- bug2986823
454: p_applicant_number := p_national_identifier ;

Line 452: hr_utility.raise_error;

448: hr_utility.set_message(801,'HR_7580_ALL_MAN_SOL_FIELD');
449: else
450: hr_utility.set_message(801,'HR_7578_ALL_MAN_NAT_FIELD');
451: end if;
452: hr_utility.raise_error;
453: elsif p_applicant_number is null then -- bug2986823
454: p_applicant_number := p_national_identifier ;
455: end if;
456: elsif l_method_of_generation = 'M'

Line 458: hr_utility.set_message(801,'HR_7579_ALL_MAN_APP_FIELD');

454: p_applicant_number := p_national_identifier ;
455: end if;
456: elsif l_method_of_generation = 'M'
457: and p_applicant_number IS NULL then
458: hr_utility.set_message(801,'HR_7579_ALL_MAN_APP_FIELD');
459: hr_utility.raise_error;
460: end if;
461: --
462: end if;

Line 459: hr_utility.raise_error;

455: end if;
456: elsif l_method_of_generation = 'M'
457: and p_applicant_number IS NULL then
458: hr_utility.set_message(801,'HR_7579_ALL_MAN_APP_FIELD');
459: hr_utility.raise_error;
460: end if;
461: --
462: end if;
463: if p_current_employee = 'Y' then

Line 466: hr_utility.set_location('hr_person.generate_number',4);

462: end if;
463: if p_current_employee = 'Y' then
464: --
465: if g_debug then
466: hr_utility.set_location('hr_person.generate_number',4);
467: end if;
468: SELECT pbg.method_of_generation_emp_num
469: , pbg.legislation_code
470: INTO l_method_of_generation

Line 477: hr_utility.set_location('hr_person.generate_number',5);

473: WHERE pbg.business_group_id = p_business_group_id;
474: --
475: if l_method_of_generation = 'A' then
476: if g_debug then
477: hr_utility.set_location('hr_person.generate_number',5);
478: end if;
479: if p_employee_number is NOT NULL then
480: begin
481: select person_id

Line 561: hr_utility.set_location('hr_person.generate_number',6);

557: -- WHERE rowid = l_rowid ;
558: -- ------------------------------------------------------------+
559:
560: if g_debug then
561: hr_utility.set_location('hr_person.generate_number',6);
562: end if;
563: emp_number_sv := p_employee_number;
564:
565: end if;

Line 576: hr_utility.set_message(801,'HR_7580_ALL_MAN_SOL_FIELD');

572: )
573: then
574: if p_national_identifier is null then
575: if l_legislation_code = 'US' then
576: hr_utility.set_message(801,'HR_7580_ALL_MAN_SOL_FIELD');
577: else
578: hr_utility.set_message(801,'HR_7578_ALL_MAN_NAT_FIELD');
579: end if;
580: hr_utility.raise_error;

Line 578: hr_utility.set_message(801,'HR_7578_ALL_MAN_NAT_FIELD');

574: if p_national_identifier is null then
575: if l_legislation_code = 'US' then
576: hr_utility.set_message(801,'HR_7580_ALL_MAN_SOL_FIELD');
577: else
578: hr_utility.set_message(801,'HR_7578_ALL_MAN_NAT_FIELD');
579: end if;
580: hr_utility.raise_error;
581: elsif p_employee_number is null then -- bug#2986823
582: p_employee_number := p_national_identifier ;

Line 580: hr_utility.raise_error;

576: hr_utility.set_message(801,'HR_7580_ALL_MAN_SOL_FIELD');
577: else
578: hr_utility.set_message(801,'HR_7578_ALL_MAN_NAT_FIELD');
579: end if;
580: hr_utility.raise_error;
581: elsif p_employee_number is null then -- bug#2986823
582: p_employee_number := p_national_identifier ;
583: end if;
584: elsif l_method_of_generation = 'M'

Line 586: hr_utility.set_message(801,'HR_7581_ALL_MAN_EMP');

582: p_employee_number := p_national_identifier ;
583: end if;
584: elsif l_method_of_generation = 'M'
585: and p_employee_number IS NULL then
586: hr_utility.set_message(801,'HR_7581_ALL_MAN_EMP');
587: hr_utility.raise_error;
588: end if;
589: --
590: end if;

Line 587: hr_utility.raise_error;

583: end if;
584: elsif l_method_of_generation = 'M'
585: and p_employee_number IS NULL then
586: hr_utility.set_message(801,'HR_7581_ALL_MAN_EMP');
587: hr_utility.raise_error;
588: end if;
589: --
590: end if;
591: if p_current_npw = 'Y' then

Line 594: hr_utility.set_location('hr_person.generate_number',10);

590: end if;
591: if p_current_npw = 'Y' then
592: --
593: if g_debug then
594: hr_utility.set_location('hr_person.generate_number',10);
595: end if;
596: SELECT pbg.method_of_generation_cwk_num
597: , pbg.method_of_generation_emp_num
598: , pbg.legislation_code

Line 609: hr_utility.set_location('hr_person.generate_number',15);

605: if l_method_of_generation = 'A'
606: or (l_method_of_generation = 'E' and
607: l_method_of_gen_emp = 'A') then
608: if g_debug then
609: hr_utility.set_location('hr_person.generate_number',15);
610: end if;
611: if p_npw_number is NOT NULL then
612: begin
613: select person_id

Line 638: hr_utility.set_location('hr_person.generate_number',20);

634:
635: -- Second check
636: if p_npw_number is NOT NULL then
637: if g_debug then
638: hr_utility.set_location('hr_person.generate_number',20);
639: end if;
640: begin
641: select null
642: into p_npw_number

Line 658: hr_utility.set_location('hr_person.generate_number',25);

654: end if;
655:
656: if p_npw_number IS NULL then
657: if g_debug then
658: hr_utility.set_location('hr_person.generate_number',25);
659: end if;
660:
661: if l_method_of_generation = 'A' then
662: --

Line 666: hr_utility.set_location('hr_person.generate_number',27);

662: --
663: -- Automatic numbering so use the CWK number type.
664: --
665: if g_debug then
666: hr_utility.set_location('hr_person.generate_number',27);
667: end if;
668: -- -> #2660279: NEW code
669: Get_Person_Number(p_person_type => 'CWK'
670: ,p_person_number => p_npw_number

Line 704: hr_utility.set_location('hr_person.generate_number',28);

700: -- Use the next employee number sequence instead of the
701: -- CWK type.
702: --
703: if g_debug then
704: hr_utility.set_location('hr_person.generate_number',28);
705: end if;
706: -- -> #2660279: NEW code
707: Get_Person_Number(p_person_type => 'EMP'
708: ,p_person_number => p_npw_number

Line 738: hr_utility.set_location('hr_person.generate_number',29);

734:
735: end if;
736:
737: if g_debug then
738: hr_utility.set_location('hr_person.generate_number',29);
739: end if;
740: npw_number_sv := p_npw_number;
741:
742: end if;

Line 754: hr_utility.set_location('hr_person.generate_number',30);

750: and p_npw_number <> p_national_identifier)
751: )
752: then
753: if g_debug then
754: hr_utility.set_location('hr_person.generate_number',30);
755: end if;
756: if p_national_identifier is null then
757: if l_legislation_code = 'US' then
758: hr_utility.set_message(801,'HR_7580_ALL_MAN_SOL_FIELD');

Line 758: hr_utility.set_message(801,'HR_7580_ALL_MAN_SOL_FIELD');

754: hr_utility.set_location('hr_person.generate_number',30);
755: end if;
756: if p_national_identifier is null then
757: if l_legislation_code = 'US' then
758: hr_utility.set_message(801,'HR_7580_ALL_MAN_SOL_FIELD');
759: else
760: hr_utility.set_message(801,'HR_7578_ALL_MAN_NAT_FIELD');
761: end if;
762: hr_utility.raise_error;

Line 760: hr_utility.set_message(801,'HR_7578_ALL_MAN_NAT_FIELD');

756: if p_national_identifier is null then
757: if l_legislation_code = 'US' then
758: hr_utility.set_message(801,'HR_7580_ALL_MAN_SOL_FIELD');
759: else
760: hr_utility.set_message(801,'HR_7578_ALL_MAN_NAT_FIELD');
761: end if;
762: hr_utility.raise_error;
763: elsif p_npw_number is null then -- bug#2986823
764: p_npw_number := p_national_identifier ;

Line 762: hr_utility.raise_error;

758: hr_utility.set_message(801,'HR_7580_ALL_MAN_SOL_FIELD');
759: else
760: hr_utility.set_message(801,'HR_7578_ALL_MAN_NAT_FIELD');
761: end if;
762: hr_utility.raise_error;
763: elsif p_npw_number is null then -- bug#2986823
764: p_npw_number := p_national_identifier ;
765: end if;
766: elsif(l_method_of_generation = 'M'

Line 771: hr_utility.set_location('hr_person.generate_number',35);

767: or (l_method_of_generation = 'E' and
768: l_method_of_gen_emp = 'M'))
769: and p_npw_number IS NULL then
770: if g_debug then
771: hr_utility.set_location('hr_person.generate_number',35);
772: end if;
773: -- Changed the application id form 801 to 800 for fix of #3295346
774: hr_utility.set_message(800,'HR_289692_ALL_MAN_CWK');
775: hr_utility.raise_error;

Line 774: hr_utility.set_message(800,'HR_289692_ALL_MAN_CWK');

770: if g_debug then
771: hr_utility.set_location('hr_person.generate_number',35);
772: end if;
773: -- Changed the application id form 801 to 800 for fix of #3295346
774: hr_utility.set_message(800,'HR_289692_ALL_MAN_CWK');
775: hr_utility.raise_error;
776: end if;
777: --
778: end if;

Line 775: hr_utility.raise_error;

771: hr_utility.set_location('hr_person.generate_number',35);
772: end if;
773: -- Changed the application id form 801 to 800 for fix of #3295346
774: hr_utility.set_message(800,'HR_289692_ALL_MAN_CWK');
775: hr_utility.raise_error;
776: end if;
777: --
778: end if;
779: --

Line 921: hr_utility.set_location('hr_person.derive_full_name',1);

917: p_duplicate_flag:='N';
918: --
919:
920: if g_debug then
921: hr_utility.set_location('hr_person.derive_full_name',1);
922: end if;
923:
924: if p_title IS NOT NULL and
925: fnd_profile.value('PER_USE_TITLE_IN_FULL_NAME') = 'Y' then

Line 934: hr_utility.set_location('l_title_meaning = '||l_title_meaning,4);

930: AND p_title = lookup_code;
931: end if;
932:
933: if g_debug then
934: hr_utility.set_location('l_title_meaning = '||l_title_meaning,4);
935: end if;
936: --
937: --
938: -- Note this is only a select because PL/SQL can't cope with DECODEs

Line 941: hr_utility.set_location('hr_person.derive_full_name',2);

937: --
938: -- Note this is only a select because PL/SQL can't cope with DECODEs
939: --
940: if g_debug then
941: hr_utility.set_location('hr_person.derive_full_name',2);
942: end if;
943: SELECT rtrim(substrb(DECODE(p_pre_name_adjunct,'','',p_pre_name_adjunct||' ')||
944: p_last_name||','||DECODE(l_title_meaning,'','',
945: ' '||l_title_meaning)||DECODE(p_first_name,'','',

Line 959: hr_utility.set_location('hr_person.derive_full_name',4);

955: --
956: p_full_name := rtrim(l_full_name);
957: --
958: if g_debug then
959: hr_utility.set_location('hr_person.derive_full_name',4);
960: end if;
961: open csr_leg_cod;
962: fetch csr_leg_cod into l_leg_code;
963: if csr_leg_cod%found then

Line 968: if ( hr_utility.chk_product_install('Oracle Human Resources',l_leg_code) or (l_leg_code = 'JP')) then

964:
965: -- Start of bug # 2459815
966: -- check for installed legislation
967: -- added the or condition for the fix of #3291084
968: if ( hr_utility.chk_product_install('Oracle Human Resources',l_leg_code) or (l_leg_code = 'JP')) then
969: -- if a legislation exits then we must call the function
970: -- hr_XX_utility.per_XX_full_name which derives the full name
971: -- according to the legislation.
972:

Line 1131: hr_utility.set_location('hr_person.derive_full_name',3);

1127: if fnd_profile.value('HR_CROSS_BUSINESS_GROUP') = 'N' then
1128: begin
1129: --
1130: if g_debug then
1131: hr_utility.set_location('hr_person.derive_full_name',3);
1132: end if;
1133: SELECT 'Y'
1134: INTO l_status
1135: FROM sys.dual

Line 1157: hr_utility.set_message(801,'HR_PERSON_DUPLICATE');

1153: AND p_person_id <> pp.person_id)
1154: OR p_person_id IS NULL)
1155: AND pp.business_group_id +0 = p_business_group_id);
1156: --
1157: hr_utility.set_message(801,'HR_PERSON_DUPLICATE');
1158:
1159: raise local_warning;
1160:
1161: --

Line 1171: hr_utility.set_warning;

1167: --
1168: --
1169: exception
1170: when local_warning then
1171: hr_utility.set_warning;
1172: p_duplicate_flag:='Y';
1173: -- #3907786 start
1174: when others then
1175: if csr_leg_cod%isopen then

Line 1377: hr_utility.set_location('hr_person.validate_national_identifier',1);

1373: local_warning exception;
1374: --
1375: begin
1376: if g_debug then
1377: hr_utility.set_location('hr_person.validate_national_identifier',1);
1378: end if;
1379: SELECT org_information9
1380: INTO l_legislation_code
1381: FROM hr_organization_information

Line 1403: hr_utility.set_message(801,'HR_EMP_SS_EXISTS');

1399: -- Note this should be printed out as a warning when called from the form
1400: -- but should be picked up as an error by HRLink
1401: --
1402: if l_legislation_code = 'US' then
1403: hr_utility.set_message(801,'HR_EMP_SS_EXISTS');
1404: elsif l_legislation_code = 'GB' then
1405: hr_utility.set_message(801,'HR_EMP_NI_EXISTS');
1406: -- psingla - If the legislation is Polish and profile PER_NI_UNIQUE_ERROR_WARNING is set to NULL
1407: elsif l_legislation_code = 'PL' and fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') is NULL then -- For Poland

Line 1405: hr_utility.set_message(801,'HR_EMP_NI_EXISTS');

1401: --
1402: if l_legislation_code = 'US' then
1403: hr_utility.set_message(801,'HR_EMP_SS_EXISTS');
1404: elsif l_legislation_code = 'GB' then
1405: hr_utility.set_message(801,'HR_EMP_NI_EXISTS');
1406: -- psingla - If the legislation is Polish and profile PER_NI_UNIQUE_ERROR_WARNING is set to NULL
1407: elsif l_legislation_code = 'PL' and fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') is NULL then -- For Poland
1408: null;
1409: else

Line 1410: hr_utility.set_message(801,'HR_EMP_NAT_ID_EXISTS');

1406: -- psingla - If the legislation is Polish and profile PER_NI_UNIQUE_ERROR_WARNING is set to NULL
1407: elsif l_legislation_code = 'PL' and fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') is NULL then -- For Poland
1408: null;
1409: else
1410: hr_utility.set_message(801,'HR_EMP_NAT_ID_EXISTS');
1411: end if;
1412: /* psingla - If the legislation is Polish and profile PER_NI_UNIQUE_ERROR_WARNING
1413: is set to NULL then only null statement to be executed.*/
1414: if l_legislation_code = 'PL' and fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') is NULL then -- For Poland

Line 1427: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

1423: raise;
1424: end;
1425: exception
1426: when NO_DATA_FOUND then
1427: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1428: hr_utility.set_message_token('PROCEDURE','CHECK_NI_UNIQUE');
1429: hr_utility.set_message_token('STEP','1');
1430: hr_utility.raise_error;
1431: when local_warning then

Line 1428: hr_utility.set_message_token('PROCEDURE','CHECK_NI_UNIQUE');

1424: end;
1425: exception
1426: when NO_DATA_FOUND then
1427: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1428: hr_utility.set_message_token('PROCEDURE','CHECK_NI_UNIQUE');
1429: hr_utility.set_message_token('STEP','1');
1430: hr_utility.raise_error;
1431: when local_warning then
1432: hr_utility.set_warning;

Line 1429: hr_utility.set_message_token('STEP','1');

1425: exception
1426: when NO_DATA_FOUND then
1427: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1428: hr_utility.set_message_token('PROCEDURE','CHECK_NI_UNIQUE');
1429: hr_utility.set_message_token('STEP','1');
1430: hr_utility.raise_error;
1431: when local_warning then
1432: hr_utility.set_warning;
1433: end check_ni_unique;

Line 1430: hr_utility.raise_error;

1426: when NO_DATA_FOUND then
1427: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1428: hr_utility.set_message_token('PROCEDURE','CHECK_NI_UNIQUE');
1429: hr_utility.set_message_token('STEP','1');
1430: hr_utility.raise_error;
1431: when local_warning then
1432: hr_utility.set_warning;
1433: end check_ni_unique;
1434: -- ------------------- validate_national_identifier -----------------------

Line 1432: hr_utility.set_warning;

1428: hr_utility.set_message_token('PROCEDURE','CHECK_NI_UNIQUE');
1429: hr_utility.set_message_token('STEP','1');
1430: hr_utility.raise_error;
1431: when local_warning then
1432: hr_utility.set_warning;
1433: end check_ni_unique;
1434: -- ------------------- validate_national_identifier -----------------------
1435: --
1436: -- Pass in national identifier and validate both construct (dependent on

Line 1453: hr_utility.set_location('hr_person.validate_national_identifier',1);

1449: begin
1450: --
1451: --
1452: if g_debug then
1453: hr_utility.set_location('hr_person.validate_national_identifier',1);
1454: end if;
1455: SELECT org_information9
1456: INTO l_legislation_code
1457: FROM hr_organization_information

Line 1488: hr_utility.set_warning;

1484: NULL ;
1485: else
1486: --Fix for bug2356249 start here.
1487: if nvl(fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION'),'ERROR') ='WARN' THEN
1488: hr_utility.set_warning;
1489: elsif nvl(fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION'),'ERROR') ='ERROR' then
1490: hr_utility.set_message(801,'HR_6522_EMP_INVALID_NI_NO');
1491: hr_utility.raise_error;
1492: end if;

Line 1490: hr_utility.set_message(801,'HR_6522_EMP_INVALID_NI_NO');

1486: --Fix for bug2356249 start here.
1487: if nvl(fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION'),'ERROR') ='WARN' THEN
1488: hr_utility.set_warning;
1489: elsif nvl(fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION'),'ERROR') ='ERROR' then
1490: hr_utility.set_message(801,'HR_6522_EMP_INVALID_NI_NO');
1491: hr_utility.raise_error;
1492: end if;
1493: --Fix for bug2356249 ends here.
1494: end if;

Line 1491: hr_utility.raise_error;

1487: if nvl(fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION'),'ERROR') ='WARN' THEN
1488: hr_utility.set_warning;
1489: elsif nvl(fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION'),'ERROR') ='ERROR' then
1490: hr_utility.set_message(801,'HR_6522_EMP_INVALID_NI_NO');
1491: hr_utility.raise_error;
1492: end if;
1493: --Fix for bug2356249 ends here.
1494: end if;
1495:

Line 1509: hr_utility.set_warning;

1505: null;
1506: else
1507: --Fix for bug2356249 start here.
1508: if nvl(fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION'),'ERROR') ='WARN' THEN
1509: hr_utility.set_warning;
1510: elsif nvl(fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION'),'ERROR') ='ERROR' then
1511: hr_utility.set_message(801,'HR_7056_EMP_INVALID_SS_NO');
1512: hr_utility.raise_error;
1513: end if;

Line 1511: hr_utility.set_message(801,'HR_7056_EMP_INVALID_SS_NO');

1507: --Fix for bug2356249 start here.
1508: if nvl(fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION'),'ERROR') ='WARN' THEN
1509: hr_utility.set_warning;
1510: elsif nvl(fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION'),'ERROR') ='ERROR' then
1511: hr_utility.set_message(801,'HR_7056_EMP_INVALID_SS_NO');
1512: hr_utility.raise_error;
1513: end if;
1514: --Fix for bug2356249 ends here.
1515: end if;

Line 1512: hr_utility.raise_error;

1508: if nvl(fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION'),'ERROR') ='WARN' THEN
1509: hr_utility.set_warning;
1510: elsif nvl(fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION'),'ERROR') ='ERROR' then
1511: hr_utility.set_message(801,'HR_7056_EMP_INVALID_SS_NO');
1512: hr_utility.raise_error;
1513: end if;
1514: --Fix for bug2356249 ends here.
1515: end if;
1516: end if;

Line 1539: hr_utility.set_location('hr_person.validate_dob',1);

1535: begin
1536: --
1537: --
1538: if g_debug then
1539: hr_utility.set_location('hr_person.validate_dob',1);
1540: end if;
1541: if p_date_of_birth > p_start_date
1542: then
1543: hr_utility.set_message(801,'HR_6523_PERSON_DOB_GT_START');

Line 1543: hr_utility.set_message(801,'HR_6523_PERSON_DOB_GT_START');

1539: hr_utility.set_location('hr_person.validate_dob',1);
1540: end if;
1541: if p_date_of_birth > p_start_date
1542: then
1543: hr_utility.set_message(801,'HR_6523_PERSON_DOB_GT_START');
1544: hr_utility.raise_error;
1545: end if;
1546: --
1547: end validate_dob;

Line 1544: hr_utility.raise_error;

1540: end if;
1541: if p_date_of_birth > p_start_date
1542: then
1543: hr_utility.set_message(801,'HR_6523_PERSON_DOB_GT_START');
1544: hr_utility.raise_error;
1545: end if;
1546: --
1547: end validate_dob;
1548: --

Line 1561: hr_utility.set_location('hr_person.validate_sex_and_title',1);

1557: begin
1558: --
1559: --
1560: if g_debug then
1561: hr_utility.set_location('hr_person.validate_sex_and_title',1);
1562: end if;
1563: if p_current_employee = 'Y' then
1564: if p_sex IS NULL then
1565: hr_utility.set_message(801,'HR_6524_EMP_MANDATORY_SEX');

Line 1565: hr_utility.set_message(801,'HR_6524_EMP_MANDATORY_SEX');

1561: hr_utility.set_location('hr_person.validate_sex_and_title',1);
1562: end if;
1563: if p_current_employee = 'Y' then
1564: if p_sex IS NULL then
1565: hr_utility.set_message(801,'HR_6524_EMP_MANDATORY_SEX');
1566: hr_utility.raise_error;
1567: end if;
1568: end if;
1569: --

Line 1566: hr_utility.raise_error;

1562: end if;
1563: if p_current_employee = 'Y' then
1564: if p_sex IS NULL then
1565: hr_utility.set_message(801,'HR_6524_EMP_MANDATORY_SEX');
1566: hr_utility.raise_error;
1567: end if;
1568: end if;
1569: --
1570: if g_debug then

Line 1571: hr_utility.set_location('hr_person.validate_sex_and_title',2);

1567: end if;
1568: end if;
1569: --
1570: if g_debug then
1571: hr_utility.set_location('hr_person.validate_sex_and_title',2);
1572: end if;
1573: if p_sex IS NULL then
1574: hr_utility.set_message(801,'PAY_6361_USER_TABLE_UNIQUE');
1575: raise local_warning;

Line 1574: hr_utility.set_message(801,'PAY_6361_USER_TABLE_UNIQUE');

1570: if g_debug then
1571: hr_utility.set_location('hr_person.validate_sex_and_title',2);
1572: end if;
1573: if p_sex IS NULL then
1574: hr_utility.set_message(801,'PAY_6361_USER_TABLE_UNIQUE');
1575: raise local_warning;
1576: elsif p_title IS NULL then
1577: hr_utility.set_message(801,'PAY_6361_USER_TABLE_UNIQUE');
1578: raise local_warning;

Line 1577: hr_utility.set_message(801,'PAY_6361_USER_TABLE_UNIQUE');

1573: if p_sex IS NULL then
1574: hr_utility.set_message(801,'PAY_6361_USER_TABLE_UNIQUE');
1575: raise local_warning;
1576: elsif p_title IS NULL then
1577: hr_utility.set_message(801,'PAY_6361_USER_TABLE_UNIQUE');
1578: raise local_warning;
1579: elsif p_title = 'MR.' then
1580: if p_sex <> 'M' then
1581: hr_utility.set_message(801,'HR_6527_PERSON_SEX_AND_TITLE');

Line 1581: hr_utility.set_message(801,'HR_6527_PERSON_SEX_AND_TITLE');

1577: hr_utility.set_message(801,'PAY_6361_USER_TABLE_UNIQUE');
1578: raise local_warning;
1579: elsif p_title = 'MR.' then
1580: if p_sex <> 'M' then
1581: hr_utility.set_message(801,'HR_6527_PERSON_SEX_AND_TITLE');
1582: hr_utility.raise_error;
1583: end if;
1584: elsif p_title IN ('MRS.','MS.','MISS') then
1585: if p_sex <> 'F' then

Line 1582: hr_utility.raise_error;

1578: raise local_warning;
1579: elsif p_title = 'MR.' then
1580: if p_sex <> 'M' then
1581: hr_utility.set_message(801,'HR_6527_PERSON_SEX_AND_TITLE');
1582: hr_utility.raise_error;
1583: end if;
1584: elsif p_title IN ('MRS.','MS.','MISS') then
1585: if p_sex <> 'F' then
1586: hr_utility.set_message(801,'HR_6527_PERSON_SEX_AND_TITLE');

Line 1586: hr_utility.set_message(801,'HR_6527_PERSON_SEX_AND_TITLE');

1582: hr_utility.raise_error;
1583: end if;
1584: elsif p_title IN ('MRS.','MS.','MISS') then
1585: if p_sex <> 'F' then
1586: hr_utility.set_message(801,'HR_6527_PERSON_SEX_AND_TITLE');
1587: hr_utility.raise_error;
1588: end if;
1589: end if;
1590: --

Line 1587: hr_utility.raise_error;

1583: end if;
1584: elsif p_title IN ('MRS.','MS.','MISS') then
1585: if p_sex <> 'F' then
1586: hr_utility.set_message(801,'HR_6527_PERSON_SEX_AND_TITLE');
1587: hr_utility.raise_error;
1588: end if;
1589: end if;
1590: --
1591: exception

Line 1593: hr_utility.set_warning;

1589: end if;
1590: --
1591: exception
1592: when local_warning then
1593: hr_utility.set_warning;
1594: --
1595: end validate_sex_and_title;
1596: --
1597: -- --------------------------------------------------------------------- +

Line 1616: hr_utility.set_location('hr_person.validate_unique_number',1);

1612: begin
1613: --
1614: --
1615: if g_debug then
1616: hr_utility.set_location('hr_person.validate_unique_number',1);
1617: end if;
1618: if p_current_applicant = 'Y' then
1619: if p_applicant_number IS NULL then
1620: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 1620: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

1616: hr_utility.set_location('hr_person.validate_unique_number',1);
1617: end if;
1618: if p_current_applicant = 'Y' then
1619: if p_applicant_number IS NULL then
1620: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1621: hr_utility.set_message_token('PROCEDURE','VALIDATE_UNIQUE_NUMBER');
1622: hr_utility.set_message_token('STEP','1');
1623: hr_utility.raise_error;
1624: end if;

Line 1621: hr_utility.set_message_token('PROCEDURE','VALIDATE_UNIQUE_NUMBER');

1617: end if;
1618: if p_current_applicant = 'Y' then
1619: if p_applicant_number IS NULL then
1620: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1621: hr_utility.set_message_token('PROCEDURE','VALIDATE_UNIQUE_NUMBER');
1622: hr_utility.set_message_token('STEP','1');
1623: hr_utility.raise_error;
1624: end if;
1625: --

Line 1622: hr_utility.set_message_token('STEP','1');

1618: if p_current_applicant = 'Y' then
1619: if p_applicant_number IS NULL then
1620: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1621: hr_utility.set_message_token('PROCEDURE','VALIDATE_UNIQUE_NUMBER');
1622: hr_utility.set_message_token('STEP','1');
1623: hr_utility.raise_error;
1624: end if;
1625: --
1626: if g_debug then

Line 1623: hr_utility.raise_error;

1619: if p_applicant_number IS NULL then
1620: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1621: hr_utility.set_message_token('PROCEDURE','VALIDATE_UNIQUE_NUMBER');
1622: hr_utility.set_message_token('STEP','1');
1623: hr_utility.raise_error;
1624: end if;
1625: --
1626: if g_debug then
1627: hr_utility.set_location('hr_person.validate_unique_number',2);

Line 1627: hr_utility.set_location('hr_person.validate_unique_number',2);

1623: hr_utility.raise_error;
1624: end if;
1625: --
1626: if g_debug then
1627: hr_utility.set_location('hr_person.validate_unique_number',2);
1628: end if;
1629: -- #2660279:
1630: -- --> delete this code
1631: -- SELECT 'Y'

Line 1649: hr_utility.set_message(801,'HR_7693_PERSON_NUM_EXISTS');

1645: ,p_business_group_id => p_business_group_id
1646: ) = 'N'
1647: then
1648:
1649: hr_utility.set_message(801,'HR_7693_PERSON_NUM_EXISTS');
1650: hr_utility.raise_error;
1651: end if;
1652: -- << End New code
1653: --

Line 1650: hr_utility.raise_error;

1646: ) = 'N'
1647: then
1648:
1649: hr_utility.set_message(801,'HR_7693_PERSON_NUM_EXISTS');
1650: hr_utility.raise_error;
1651: end if;
1652: -- << End New code
1653: --
1654: end if;

Line 1657: hr_utility.set_location('hr_person.validate_unique_number',3);

1653: --
1654: end if;
1655: --
1656: if g_debug then
1657: hr_utility.set_location('hr_person.validate_unique_number',3);
1658: end if;
1659: if p_current_employee = 'Y' then
1660: if p_employee_number IS NULL then
1661: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 1661: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

1657: hr_utility.set_location('hr_person.validate_unique_number',3);
1658: end if;
1659: if p_current_employee = 'Y' then
1660: if p_employee_number IS NULL then
1661: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1662: hr_utility.set_message_token('PROCEDURE','VALIDATE_UNIQUE_NUMBER');
1663: hr_utility.set_message_token('STEP','3');
1664: hr_utility.raise_error;
1665: end if;

Line 1662: hr_utility.set_message_token('PROCEDURE','VALIDATE_UNIQUE_NUMBER');

1658: end if;
1659: if p_current_employee = 'Y' then
1660: if p_employee_number IS NULL then
1661: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1662: hr_utility.set_message_token('PROCEDURE','VALIDATE_UNIQUE_NUMBER');
1663: hr_utility.set_message_token('STEP','3');
1664: hr_utility.raise_error;
1665: end if;
1666: --

Line 1663: hr_utility.set_message_token('STEP','3');

1659: if p_current_employee = 'Y' then
1660: if p_employee_number IS NULL then
1661: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1662: hr_utility.set_message_token('PROCEDURE','VALIDATE_UNIQUE_NUMBER');
1663: hr_utility.set_message_token('STEP','3');
1664: hr_utility.raise_error;
1665: end if;
1666: --
1667: if g_debug then

Line 1664: hr_utility.raise_error;

1660: if p_employee_number IS NULL then
1661: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1662: hr_utility.set_message_token('PROCEDURE','VALIDATE_UNIQUE_NUMBER');
1663: hr_utility.set_message_token('STEP','3');
1664: hr_utility.raise_error;
1665: end if;
1666: --
1667: if g_debug then
1668: hr_utility.set_location('hr_person.validate_unique_number',4);

Line 1668: hr_utility.set_location('hr_person.validate_unique_number',4);

1664: hr_utility.raise_error;
1665: end if;
1666: --
1667: if g_debug then
1668: hr_utility.set_location('hr_person.validate_unique_number',4);
1669: end if;
1670: -- #2660279: >> New code
1671: if is_unique_person_number(p_person_id => p_person_id
1672: ,p_person_type => 'EMP'

Line 1678: hr_utility.set_message(801,'HR_7692_PERSON_NUM_EXIST');

1674: ,p_business_group_id => p_business_group_id
1675: ) = 'N'
1676: then
1677:
1678: hr_utility.set_message(801,'HR_7692_PERSON_NUM_EXIST');
1679: hr_utility.raise_error;
1680: end if;
1681: -- << end new code
1682: --

Line 1679: hr_utility.raise_error;

1675: ) = 'N'
1676: then
1677:
1678: hr_utility.set_message(801,'HR_7692_PERSON_NUM_EXIST');
1679: hr_utility.raise_error;
1680: end if;
1681: -- << end new code
1682: --
1683:

Line 1703: hr_utility.set_location('hr_person.validate_unique_number',5);

1699: --
1700: -- << end 2660279
1701: end if;
1702: if g_debug then
1703: hr_utility.set_location('hr_person.validate_unique_number',5);
1704: end if;
1705: -- +---------------------------------------------------------------------+
1706: -- Processing contingent workers
1707: -- +---------------------------------------------------------------------+

Line 1710: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

1706: -- Processing contingent workers
1707: -- +---------------------------------------------------------------------+
1708: if p_current_npw = 'Y' then
1709: if p_npw_number IS NULL then
1710: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1711: hr_utility.set_message_token('PROCEDURE','VALIDATE_UNIQUE_NUMBER');
1712: hr_utility.set_message_token('STEP','4');
1713: hr_utility.raise_error;
1714: end if;

Line 1711: hr_utility.set_message_token('PROCEDURE','VALIDATE_UNIQUE_NUMBER');

1707: -- +---------------------------------------------------------------------+
1708: if p_current_npw = 'Y' then
1709: if p_npw_number IS NULL then
1710: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1711: hr_utility.set_message_token('PROCEDURE','VALIDATE_UNIQUE_NUMBER');
1712: hr_utility.set_message_token('STEP','4');
1713: hr_utility.raise_error;
1714: end if;
1715: --

Line 1712: hr_utility.set_message_token('STEP','4');

1708: if p_current_npw = 'Y' then
1709: if p_npw_number IS NULL then
1710: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1711: hr_utility.set_message_token('PROCEDURE','VALIDATE_UNIQUE_NUMBER');
1712: hr_utility.set_message_token('STEP','4');
1713: hr_utility.raise_error;
1714: end if;
1715: --
1716: if g_debug then

Line 1713: hr_utility.raise_error;

1709: if p_npw_number IS NULL then
1710: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1711: hr_utility.set_message_token('PROCEDURE','VALIDATE_UNIQUE_NUMBER');
1712: hr_utility.set_message_token('STEP','4');
1713: hr_utility.raise_error;
1714: end if;
1715: --
1716: if g_debug then
1717: hr_utility.set_location('hr_person.validate_unique_number',6);

Line 1717: hr_utility.set_location('hr_person.validate_unique_number',6);

1713: hr_utility.raise_error;
1714: end if;
1715: --
1716: if g_debug then
1717: hr_utility.set_location('hr_person.validate_unique_number',6);
1718: end if;
1719: -- #2660279:
1720: -- >> delete code
1721: -- SELECT 'Y'

Line 1745: hr_utility.set_message(800,'HR_289656_CWK_NUM_EXIST');

1741: ,p_business_group_id => p_business_group_id
1742: ) = 'N'
1743: then
1744:
1745: hr_utility.set_message(800,'HR_289656_CWK_NUM_EXIST');
1746: hr_utility.raise_error;
1747: end if;
1748: -- << end new code
1749: --

Line 1746: hr_utility.raise_error;

1742: ) = 'N'
1743: then
1744:
1745: hr_utility.set_message(800,'HR_289656_CWK_NUM_EXIST');
1746: hr_utility.raise_error;
1747: end if;
1748: -- << end new code
1749: --
1750: end if;

Line 2010: hr_utility.set_location('hr_person.chk_future_person_type',1);

2006: --
2007: BEGIN
2008: --
2009: if g_debug then
2010: hr_utility.set_location('hr_person.chk_future_person_type',1);
2011: end if;
2012: --
2013: --
2014: select 'Y'

Line 2049: when hr_utility.hr_error then

2045: --
2046: exception
2047: when no_data_found then
2048: RETURN FALSE;
2049: when hr_utility.hr_error then
2050: raise;
2051: RETURN FALSE;
2052: when others then
2053: hr_utility.oracle_error(sqlcode);

Line 2053: hr_utility.oracle_error(sqlcode);

2049: when hr_utility.hr_error then
2050: raise;
2051: RETURN FALSE;
2052: when others then
2053: hr_utility.oracle_error(sqlcode);
2054: RETURN FALSE;
2055: END chk_future_person_type;
2056: ------------------------- END: chk_future_person_type --------------------
2057: --

Line 2081: hr_utility.set_location('hr_person.chk_prev_person_type',1);

2077: --
2078: BEGIN
2079: --
2080: if g_debug then
2081: hr_utility.set_location('hr_person.chk_prev_person_type',1);
2082: hr_utility.set_location('p_system_person_type= '||p_system_person_type,10);
2083: hr_utility.set_location('p_person_id= '||p_person_id,20);
2084: hr_utility.set_location('p_business_group_id= '||p_business_group_id,30);
2085: hr_utility.set_location('p_effective_start_date= '||p_effective_start_date,40);

Line 2082: hr_utility.set_location('p_system_person_type= '||p_system_person_type,10);

2078: BEGIN
2079: --
2080: if g_debug then
2081: hr_utility.set_location('hr_person.chk_prev_person_type',1);
2082: hr_utility.set_location('p_system_person_type= '||p_system_person_type,10);
2083: hr_utility.set_location('p_person_id= '||p_person_id,20);
2084: hr_utility.set_location('p_business_group_id= '||p_business_group_id,30);
2085: hr_utility.set_location('p_effective_start_date= '||p_effective_start_date,40);
2086: end if;

Line 2083: hr_utility.set_location('p_person_id= '||p_person_id,20);

2079: --
2080: if g_debug then
2081: hr_utility.set_location('hr_person.chk_prev_person_type',1);
2082: hr_utility.set_location('p_system_person_type= '||p_system_person_type,10);
2083: hr_utility.set_location('p_person_id= '||p_person_id,20);
2084: hr_utility.set_location('p_business_group_id= '||p_business_group_id,30);
2085: hr_utility.set_location('p_effective_start_date= '||p_effective_start_date,40);
2086: end if;
2087:

Line 2084: hr_utility.set_location('p_business_group_id= '||p_business_group_id,30);

2080: if g_debug then
2081: hr_utility.set_location('hr_person.chk_prev_person_type',1);
2082: hr_utility.set_location('p_system_person_type= '||p_system_person_type,10);
2083: hr_utility.set_location('p_person_id= '||p_person_id,20);
2084: hr_utility.set_location('p_business_group_id= '||p_business_group_id,30);
2085: hr_utility.set_location('p_effective_start_date= '||p_effective_start_date,40);
2086: end if;
2087:
2088: select 'Y'

Line 2085: hr_utility.set_location('p_effective_start_date= '||p_effective_start_date,40);

2081: hr_utility.set_location('hr_person.chk_prev_person_type',1);
2082: hr_utility.set_location('p_system_person_type= '||p_system_person_type,10);
2083: hr_utility.set_location('p_person_id= '||p_person_id,20);
2084: hr_utility.set_location('p_business_group_id= '||p_business_group_id,30);
2085: hr_utility.set_location('p_effective_start_date= '||p_effective_start_date,40);
2086: end if;
2087:
2088: select 'Y'
2089: into p_test_func

Line 2148: when hr_utility.hr_error then

2144: --
2145: exception
2146: when no_data_found then
2147: RETURN FALSE;
2148: when hr_utility.hr_error then
2149: raise;
2150: RETURN FALSE;
2151: when others then
2152: hr_utility.oracle_error(sqlcode);

Line 2152: hr_utility.oracle_error(sqlcode);

2148: when hr_utility.hr_error then
2149: raise;
2150: RETURN FALSE;
2151: when others then
2152: hr_utility.oracle_error(sqlcode);
2153: RETURN FALSE;
2154: END chk_prev_person_type;
2155: ------------------------- BEGIN: chk_prev_person_type --------------------
2156: --

Line 2186: hr_utility.set_location('hr_person.validate_address',1);

2182: l_primary_flag VARCHAR2(1) :='Y';
2183: --
2184: begin
2185: if g_debug then
2186: hr_utility.set_location('hr_person.validate_address',1);
2187: end if;
2188: --
2189: --
2190: select 'Error : Primary address exists'

Line 2210: hr_utility.set_message(801,'HR_6510_PER_PRIMARY_ADDRESS');

2206: -- Primary exists and form trying to enter primary
2207: -- then raise error
2208: --
2209: if p_primary_flag = 'Y' then
2210: hr_utility.set_message(801,'HR_6510_PER_PRIMARY_ADDRESS');
2211: hr_utility.raise_error;
2212: end if;
2213: exception
2214: when NO_DATA_FOUND then

Line 2211: hr_utility.raise_error;

2207: -- then raise error
2208: --
2209: if p_primary_flag = 'Y' then
2210: hr_utility.set_message(801,'HR_6510_PER_PRIMARY_ADDRESS');
2211: hr_utility.raise_error;
2212: end if;
2213: exception
2214: when NO_DATA_FOUND then
2215: -- if no primary found

Line 2221: hr_utility.set_message(801,'HR_7144_PER_NO_PRIM_ADD');

2217: -- do nothing
2218: -- else flag an error
2219: --
2220: if p_primary_flag <> 'Y' then
2221: hr_utility.set_message(801,'HR_7144_PER_NO_PRIM_ADD');
2222: hr_utility.raise_error;
2223: end if;
2224: end validate_address;
2225: ------------------------- END: validate_address --------------------

Line 2222: hr_utility.raise_error;

2218: -- else flag an error
2219: --
2220: if p_primary_flag <> 'Y' then
2221: hr_utility.set_message(801,'HR_7144_PER_NO_PRIM_ADD');
2222: hr_utility.raise_error;
2223: end if;
2224: end validate_address;
2225: ------------------------- END: validate_address --------------------
2226: