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

APPS.HR_PERSON dependencies on HR_PERSON

Line 1: PACKAGE BODY hr_person AS

1: PACKAGE BODY hr_person AS
2: /* $Header: peperson.pkb 120.9.12020000.5 2013/01/30 09:42:35 srannama ship $ */
3: --
4: g_debug boolean := hr_utility.debug_enabled;
5:

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

370: --
371: begin
372: --
373: --
374: hr_utility.set_location('hr_person.generate_number',1);
375: --
376: if p_current_applicant = 'Y' then
377: --
378: if g_debug then

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

443: exception
444: when others then p_applicant_number := NULL;
445: end;
446: if g_debug then
447: hr_utility.set_location('hr_person.generate_number',15);
448: end if;
449: apl_number_sv := p_applicant_number;
450: end if;
451: -- <<

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

480: -- WHERE rowid = l_rowid ;
481: -- ------------------------------------------------------------+
482:
483: if g_debug then
484: hr_utility.set_location('hr_person.generate_number',20);
485: end if;
486: apl_number_sv := p_applicant_number;
487:
488: end if;

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

513: end if;
514: if p_current_employee = 'Y' then
515: --
516: if g_debug then
517: hr_utility.set_location('hr_person.generate_number',4);
518: end if;
519: SELECT pbg.method_of_generation_emp_num
520: , pbg.legislation_code
521: INTO l_method_of_generation

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

524: WHERE pbg.business_group_id = p_business_group_id;
525: --
526: if l_method_of_generation = 'A' then
527: if g_debug then
528: hr_utility.set_location('hr_person.generate_number',5);
529: end if;
530: if p_employee_number is NOT NULL then
531: begin
532: select person_id

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

608: -- WHERE rowid = l_rowid ;
609: -- ------------------------------------------------------------+
610:
611: if g_debug then
612: hr_utility.set_location('hr_person.generate_number',6);
613: end if;
614: emp_number_sv := p_employee_number;
615:
616: end if;

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

641: end if;
642: if p_current_npw = 'Y' then
643: --
644: if g_debug then
645: hr_utility.set_location('hr_person.generate_number',10);
646: end if;
647: SELECT pbg.method_of_generation_cwk_num
648: , pbg.method_of_generation_emp_num
649: , pbg.legislation_code

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

656: if l_method_of_generation = 'A'
657: or (l_method_of_generation = 'E' and
658: l_method_of_gen_emp = 'A') then
659: if g_debug then
660: hr_utility.set_location('hr_person.generate_number',15);
661: end if;
662: if p_npw_number is NOT NULL then
663: begin
664: select person_id

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

685:
686: -- Second check
687: if p_npw_number is NOT NULL then
688: if g_debug then
689: hr_utility.set_location('hr_person.generate_number',20);
690: end if;
691: begin
692: select null
693: into p_npw_number

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

705: end if;
706:
707: if p_npw_number IS NULL then
708: if g_debug then
709: hr_utility.set_location('hr_person.generate_number',25);
710: end if;
711:
712: if l_method_of_generation = 'A' then
713: --

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

713: --
714: -- Automatic numbering so use the CWK number type.
715: --
716: if g_debug then
717: hr_utility.set_location('hr_person.generate_number',27);
718: end if;
719: -- -> #2660279: NEW code
720: Get_Person_Number(p_person_type => 'CWK'
721: ,p_person_number => p_npw_number

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

751: -- Use the next employee number sequence instead of the
752: -- CWK type.
753: --
754: if g_debug then
755: hr_utility.set_location('hr_person.generate_number',28);
756: end if;
757: -- -> #2660279: NEW code
758: Get_Person_Number(p_person_type => 'EMP'
759: ,p_person_number => p_npw_number

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

785:
786: end if;
787:
788: if g_debug then
789: hr_utility.set_location('hr_person.generate_number',29);
790: end if;
791: npw_number_sv := p_npw_number;
792:
793: end if;

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

801: and p_npw_number <> p_national_identifier)
802: )
803: then
804: if g_debug then
805: hr_utility.set_location('hr_person.generate_number',30);
806: end if;
807: if p_national_identifier is null then
808: if l_legislation_code = 'US' then
809: hr_utility.set_message(801,'HR_7580_ALL_MAN_SOL_FIELD');

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

818: or (l_method_of_generation = 'E' and
819: l_method_of_gen_emp = 'M'))
820: and p_npw_number IS NULL then
821: if g_debug then
822: hr_utility.set_location('hr_person.generate_number',35);
823: end if;
824: -- Changed the application id form 801 to 800 for fix of #3295346
825: hr_utility.set_message(800,'HR_289692_ALL_MAN_CWK');
826: hr_utility.raise_error;

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

968: p_duplicate_flag:='N';
969: --
970:
971: if g_debug then
972: hr_utility.set_location('hr_person.derive_full_name',1);
973: end if;
974:
975: if p_title IS NOT NULL and
976: fnd_profile.value('PER_USE_TITLE_IN_FULL_NAME') = 'Y' then

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

988: --
989: -- Note this is only a select because PL/SQL can't cope with DECODEs
990: --
991: if g_debug then
992: hr_utility.set_location('hr_person.derive_full_name',2);
993: end if;
994: SELECT rtrim(substrb(DECODE(p_pre_name_adjunct,'','',p_pre_name_adjunct||' ')||
995: p_last_name||','||DECODE(l_title_meaning,'','',
996: ' '||l_title_meaning)||DECODE(p_first_name,'','',

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

1006: --
1007: p_full_name := rtrim(l_full_name);
1008: --
1009: if g_debug then
1010: hr_utility.set_location('hr_person.derive_full_name',4);
1011: end if;
1012: open csr_leg_cod;
1013: fetch csr_leg_cod into l_leg_code;
1014: if csr_leg_cod%found then

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

1178: if fnd_profile.value('HR_CROSS_BUSINESS_GROUP') = 'N' then
1179: begin
1180: --
1181: if g_debug then
1182: hr_utility.set_location('hr_person.derive_full_name',3);
1183: end if;
1184: SELECT 'Y'
1185: INTO l_status
1186: FROM sys.dual

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

1204: AND p_person_id <> pp.person_id)
1205: OR p_person_id IS NULL)
1206: AND pp.business_group_id +0 = p_business_group_id);
1207: --
1208: hr_utility.set_message(801,'HR_PERSON_DUPLICATE');
1209:
1210: raise local_warning;
1211:
1212: --

Line 1278: hr_person.derive_full_name(

1274: p_per_information29 VARCHAR2 DEFAULT NULL,
1275: p_per_information30 VARCHAR2 DEFAULT NULL) is
1276: l_pre_name_adjunct VARCHAR2(30);
1277: begin
1278: hr_person.derive_full_name(
1279: p_first_name =>p_first_name
1280: ,p_middle_names =>p_middle_names
1281: ,p_last_name =>p_last_name
1282: ,p_known_as =>p_known_as

Line 1367: hr_person.derive_full_name(

1363: p_per_information30 VARCHAR2 DEFAULT NULL) is
1364: l_suffix VARCHAR2(30);
1365: l_pre_name_adjunct VARCHAR2(30);
1366: begin
1367: hr_person.derive_full_name(
1368: p_first_name =>p_first_name
1369: ,p_middle_names =>p_middle_names
1370: ,p_last_name =>p_last_name
1371: ,p_known_as =>p_known_as

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

1424: local_warning exception;
1425: --
1426: begin
1427: if g_debug then
1428: hr_utility.set_location('hr_person.validate_national_identifier',1);
1429: end if;
1430: SELECT org_information9
1431: INTO l_legislation_code
1432: FROM hr_organization_information

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

1500: begin
1501: --
1502: --
1503: if g_debug then
1504: hr_utility.set_location('hr_person.validate_national_identifier',1);
1505: end if;
1506: SELECT org_information9
1507: INTO l_legislation_code
1508: FROM hr_organization_information

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

1586: begin
1587: --
1588: --
1589: if g_debug then
1590: hr_utility.set_location('hr_person.validate_dob',1);
1591: end if;
1592: if p_date_of_birth > p_start_date
1593: then
1594: hr_utility.set_message(801,'HR_6523_PERSON_DOB_GT_START');

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

1608: begin
1609: --
1610: --
1611: if g_debug then
1612: hr_utility.set_location('hr_person.validate_sex_and_title',1);
1613: end if;
1614: if p_current_employee = 'Y' then
1615: if p_sex IS NULL then
1616: hr_utility.set_message(801,'HR_6524_EMP_MANDATORY_SEX');

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

1618: end if;
1619: end if;
1620: --
1621: if g_debug then
1622: hr_utility.set_location('hr_person.validate_sex_and_title',2);
1623: end if;
1624: if p_sex IS NULL then
1625: hr_utility.set_message(801,'PAY_6361_USER_TABLE_UNIQUE');
1626: raise local_warning;

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

1663: begin
1664: --
1665: --
1666: if g_debug then
1667: hr_utility.set_location('hr_person.validate_unique_number',1);
1668: end if;
1669: if p_current_applicant = 'Y' then
1670: if p_applicant_number IS NULL then
1671: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

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

1674: hr_utility.raise_error;
1675: end if;
1676: --
1677: if g_debug then
1678: hr_utility.set_location('hr_person.validate_unique_number',2);
1679: end if;
1680: -- #2660279:
1681: -- --> delete this code
1682: -- SELECT 'Y'

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

1704: --
1705: end if;
1706: --
1707: if g_debug then
1708: hr_utility.set_location('hr_person.validate_unique_number',3);
1709: end if;
1710: if p_current_employee = 'Y' then
1711: if p_employee_number IS NULL then
1712: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

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

1715: hr_utility.raise_error;
1716: end if;
1717: --
1718: if g_debug then
1719: hr_utility.set_location('hr_person.validate_unique_number',4);
1720: end if;
1721: -- #2660279: >> New code
1722: if is_unique_person_number(p_person_id => p_person_id
1723: ,p_person_type => 'EMP'

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

1750: --
1751: -- << end 2660279
1752: end if;
1753: if g_debug then
1754: hr_utility.set_location('hr_person.validate_unique_number',5);
1755: end if;
1756: -- +---------------------------------------------------------------------+
1757: -- Processing contingent workers
1758: -- +---------------------------------------------------------------------+

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

1764: hr_utility.raise_error;
1765: end if;
1766: --
1767: if g_debug then
1768: hr_utility.set_location('hr_person.validate_unique_number',6);
1769: end if;
1770: -- #2660279:
1771: -- >> delete code
1772: -- SELECT 'Y'

Line 1824: -- Fix for bug 3908271. replace hr_person_delete with hr_person_internal.

1820: IS
1821: --
1822: BEGIN
1823: --
1824: -- Fix for bug 3908271. replace hr_person_delete with hr_person_internal.
1825: --
1826: hr_person_internal.product_installed(p_application_short_name,
1827: p_status,
1828: p_yes_no,

Line 1826: hr_person_internal.product_installed(p_application_short_name,

1822: BEGIN
1823: --
1824: -- Fix for bug 3908271. replace hr_person_delete with hr_person_internal.
1825: --
1826: hr_person_internal.product_installed(p_application_short_name,
1827: p_status,
1828: p_yes_no,
1829: p_oracle_username);
1830:

Line 1851: -- Fix for bug 3908271. replace hr_person_delete with hr_person_internal.

1847: IS
1848: --
1849: BEGIN
1850: --
1851: -- Fix for bug 3908271. replace hr_person_delete with hr_person_internal.
1852: --
1853: hr_person_internal.weak_predel_validation(p_person_id,
1854: p_session_date);
1855: END weak_predel_validation;

Line 1853: hr_person_internal.weak_predel_validation(p_person_id,

1849: BEGIN
1850: --
1851: -- Fix for bug 3908271. replace hr_person_delete with hr_person_internal.
1852: --
1853: hr_person_internal.weak_predel_validation(p_person_id,
1854: p_session_date);
1855: END weak_predel_validation;
1856: -------------------- END: weak_predel_validation --------------------------
1857: --

Line 1888: -- Fix for bug 3908271. replace hr_person_delete with hr_person_internal.

1884: --
1885: --
1886: BEGIN
1887: --
1888: -- Fix for bug 3908271. replace hr_person_delete with hr_person_internal.
1889: --
1890: hr_person_internal.strong_predel_validation(p_person_id,
1891: p_session_date);
1892: END strong_predel_validation;

Line 1890: hr_person_internal.strong_predel_validation(p_person_id,

1886: BEGIN
1887: --
1888: -- Fix for bug 3908271. replace hr_person_delete with hr_person_internal.
1889: --
1890: hr_person_internal.strong_predel_validation(p_person_id,
1891: p_session_date);
1892: END strong_predel_validation;
1893: -------------------- END: strong_predel_validation -----------------------
1894: --

Line 1921: -- Fix for bug 3908271. replace hr_person_delete with hr_person_internal.

1917: IS
1918: --
1919: BEGIN
1920: --
1921: -- Fix for bug 3908271. replace hr_person_delete with hr_person_internal.
1922: --
1923: hr_person_internal.check_contact(p_person_id,
1924: p_contact_person_id,
1925: p_contact_relationship_id,

Line 1923: hr_person_internal.check_contact(p_person_id,

1919: BEGIN
1920: --
1921: -- Fix for bug 3908271. replace hr_person_delete with hr_person_internal.
1922: --
1923: hr_person_internal.check_contact(p_person_id,
1924: p_contact_person_id,
1925: p_contact_relationship_id,
1926: p_session_date);
1927: END check_contact;

Line 1954: -- Fix for bug 3908271. replace hr_person_delete with hr_person_internal.

1950: IS
1951: --
1952: BEGIN
1953: --
1954: -- Fix for bug 3908271. replace hr_person_delete with hr_person_internal.
1955: --
1956: hr_person_internal.delete_person(p_person_id,
1957: -- p_form_call,
1958: p_session_date);

Line 1956: hr_person_internal.delete_person(p_person_id,

1952: BEGIN
1953: --
1954: -- Fix for bug 3908271. replace hr_person_delete with hr_person_internal.
1955: --
1956: hr_person_internal.delete_person(p_person_id,
1957: -- p_form_call,
1958: p_session_date);
1959: END delete_a_person;
1960: -------------------- END: delete_a_person ----------------------------------

Line 1985: -- Fix for bug 3908271. replace hr_person_delete with hr_person_internal.

1981: --
1982: --
1983: BEGIN
1984: --
1985: -- Fix for bug 3908271. replace hr_person_delete with hr_person_internal.
1986: --
1987: hr_person_internal.people_default_deletes(p_person_id);
1988: -- p_form_call);
1989: --

Line 1987: hr_person_internal.people_default_deletes(p_person_id);

1983: BEGIN
1984: --
1985: -- Fix for bug 3908271. replace hr_person_delete with hr_person_internal.
1986: --
1987: hr_person_internal.people_default_deletes(p_person_id);
1988: -- p_form_call);
1989: --
1990: END people_default_deletes;
1991: -------------------- END: people_default_deletes --------------------------

Line 2014: -- Fix for bug 3908271. replace hr_person_delete with hr_person_internal.

2010: --
2011: --
2012: BEGIN
2013: --
2014: -- Fix for bug 3908271. replace hr_person_delete with hr_person_internal.
2015: --
2016: hr_person_internal.applicant_default_deletes(p_person_id);
2017: -- p_form_call);
2018: END applicant_default_deletes;

Line 2016: hr_person_internal.applicant_default_deletes(p_person_id);

2012: BEGIN
2013: --
2014: -- Fix for bug 3908271. replace hr_person_delete with hr_person_internal.
2015: --
2016: hr_person_internal.applicant_default_deletes(p_person_id);
2017: -- p_form_call);
2018: END applicant_default_deletes;
2019: -------------------- END: applicant_default_deletes -----------------------
2020: -- ER FPT

Line 2033: hr_utility.set_location ('hr_person.fpt_check_ft_person_type',10);

2029: p_test_func varchar2(60);
2030:
2031: BEGIN
2032: IF g_debug THEN
2033: hr_utility.set_location ('hr_person.fpt_check_ft_person_type',10);
2034: END IF;
2035:
2036: IF (nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') THEN
2037:

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

2130: --
2131: BEGIN
2132: --
2133: if g_debug then
2134: hr_utility.set_location('hr_person.chk_future_person_type',1);
2135: end if;
2136: --
2137: --
2138: -- Fix for bug 7045968 starts here

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

2228: --
2229: BEGIN
2230: --
2231: if g_debug then
2232: hr_utility.set_location('hr_person.chk_prev_person_type',1);
2233: hr_utility.set_location('p_system_person_type= '||p_system_person_type,10);
2234: hr_utility.set_location('p_person_id= '||p_person_id,20);
2235: hr_utility.set_location('p_business_group_id= '||p_business_group_id,30);
2236: hr_utility.set_location('p_effective_start_date= '||p_effective_start_date,40);

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

2333: l_primary_flag VARCHAR2(1) :='Y';
2334: --
2335: begin
2336: if g_debug then
2337: hr_utility.set_location('hr_person.validate_address',1);
2338: end if;
2339: --
2340: --
2341: select 'Error : Primary address exists'

Line 2378: end hr_person;

2374: end if;
2375: end validate_address;
2376: ------------------------- END: validate_address --------------------
2377:
2378: end hr_person;
2379: