DBA Data[Home] [Help]

APPS.PER_PEOPLE_PKG dependencies on HR_UTILITY

Line 543: hr_utility.set_location('Updating party id',10);

539: close c_person;
540: --
541: per_hrtca_merge.create_tca_person(p_rec => l_person);
542: --
543: hr_utility.set_location('Updating party id',10);
544: --
545: -- Now assign the resulting party id back to the record.
546: --
547: if p_party_id is null then

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

1353: -- If no data found and a previous hire date existed
1354: -- then raise an error;
1355: --
1356: if p_s_hire_date is not null then
1357: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
1358: hr_utility.set_message_token('PROCEDURE','Update_row');
1359: hr_utility.raise_error;
1360: end if;
1361: end;

Line 1358: hr_utility.set_message_token('PROCEDURE','Update_row');

1354: -- then raise an error;
1355: --
1356: if p_s_hire_date is not null then
1357: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
1358: hr_utility.set_message_token('PROCEDURE','Update_row');
1359: hr_utility.raise_error;
1360: end if;
1361: end;
1362: --

Line 1359: hr_utility.raise_error;

1355: --
1356: if p_s_hire_date is not null then
1357: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
1358: hr_utility.set_message_token('PROCEDURE','Update_row');
1359: hr_utility.raise_error;
1360: end if;
1361: end;
1362: --
1363: -- check the integrity of the date change.

Line 1534: hr_utility.raise_error;

1530: ,p_person_id
1531: ,p_business_group_id
1532: ,p_effective_start_date) then
1533: fnd_message.set_name('PAY','HR_7193_PER_FUT_TYPE_EXISTS');
1534: hr_utility.raise_error;
1535: end if;
1536: --
1537: -- Ensure there are no future applicant assignments
1538: --

Line 1587: hr_utility.set_message('801','HR_6791_EMP_APL_NO_ASG');

1583: -- then there is an error. Otherwise go around end_accepted
1584: -- to multiple contracts.
1585: --
1586: if l_num_accepted_appls = l_num_appls then
1587: hr_utility.set_message('801','HR_6791_EMP_APL_NO_ASG');
1588: hr_utility.raise_error;
1589: else
1590: p_status := 'MULTIPLE_CONTRACTS';-- Set next re-entry point.
1591: end if;

Line 1588: hr_utility.raise_error;

1584: -- to multiple contracts.
1585: --
1586: if l_num_accepted_appls = l_num_appls then
1587: hr_utility.set_message('801','HR_6791_EMP_APL_NO_ASG');
1588: hr_utility.raise_error;
1589: else
1590: p_status := 'MULTIPLE_CONTRACTS';-- Set next re-entry point.
1591: end if;
1592: --

Line 1597: hr_utility.set_message('801','HR_EMP_UNACCEPTED_APPL');

1593: -- Number of accepted does not equal number of current then
1594: -- end_accepted.
1595: --
1596: elsif l_num_accepted_appls <> l_num_appls then
1597: hr_utility.set_message('801','HR_EMP_UNACCEPTED_APPL');
1598: p_status := 'END_UNACCEPTED'; -- next code re-entry,
1599: return;
1600: --
1601: -- Otherwise ignore end_accepted.

Line 1621: hr_utility.set_location('update_row - b4 MULTIPLE_CONTRACTS',1);

1617: end if; -- End of END_UNACCEPTED
1618: --
1619: -- Test to see if multiple contracts are a possibility.
1620: --
1621: hr_utility.set_location('update_row - b4 MULTIPLE_CONTRACTS',1);
1622: if p_status = 'MULTIPLE_CONTRACTS' then -- MULTIPLE_CONTRACTS
1623: if l_num_accepted_appls >1 then
1624: hr_utility.set_message('801','HR_EMP_MULTIPLE_CONTRACTS');
1625: return;

Line 1624: hr_utility.set_message('801','HR_EMP_MULTIPLE_CONTRACTS');

1620: --
1621: hr_utility.set_location('update_row - b4 MULTIPLE_CONTRACTS',1);
1622: if p_status = 'MULTIPLE_CONTRACTS' then -- MULTIPLE_CONTRACTS
1623: if l_num_accepted_appls >1 then
1624: hr_utility.set_message('801','HR_EMP_MULTIPLE_CONTRACTS');
1625: return;
1626: else
1627: p_status := 'CHOOSE_VAC'; -- next code re-entry.
1628: end if;

Line 1634: hr_utility.set_location('update_row - b4 CHOOSE_VAC',1);

1630: --
1631: -- Choose whether to change the Primary assignment
1632: -- and which vacancy is to be the primary if so.
1633: --
1634: hr_utility.set_location('update_row - b4 CHOOSE_VAC',1);
1635: if p_status = 'CHOOSE_VAC' then
1636: return;
1637: end if; --End of CHOOSE_VAC
1638: --

Line 1643: hr_utility.set_location('update_row - b4 HIRE',1);

1639: -- Can now hire the Person
1640: -- Note HIRE status can only be set from client form
1641: -- as interaction is generally required.
1642: --
1643: hr_utility.set_location('update_row - b4 HIRE',1);
1644: if p_status = 'HIRE' then
1645: --
1646: -- If new is Emp and old was Emp_apl
1647: -- then l_emp_emp_apl is set to Y

Line 1658: hr_utility.set_location('update_row - b4 hrhirapl',1);

1654: end if;
1655: --
1656: -- Run the employ_applicant stored procedure
1657: --
1658: hr_utility.set_location('update_row - b4 hrhirapl',1);
1659: hrhirapl.employ_applicant(p_person_id
1660: ,p_business_group_id
1661: ,p_legislation_code
1662: ,p_new_primary_id

Line 1675: hr_utility.set_location('update_row - after hrhirapl',2);

1671: ,l_set_of_books_id
1672: ,l_employ_emp_apl
1673: ,NULL
1674: ,p_session_date); -- Bug 3564129
1675: hr_utility.set_location('update_row - after hrhirapl',2);
1676: end if; -- End of HIRE.
1677: end if; -- Of Person type change checks.
1678: --
1679: hr_utility.set_location('update_row - b4 update',1);

Line 1679: hr_utility.set_location('update_row - b4 update',1);

1675: hr_utility.set_location('update_row - after hrhirapl',2);
1676: end if; -- End of HIRE.
1677: end if; -- Of Person type change checks.
1678: --
1679: hr_utility.set_location('update_row - b4 update',1);
1680: update per_people_f ppf
1681: set ppf.person_id = p_person_id
1682: ,ppf.effective_start_date = p_effective_start_date
1683: ,ppf.effective_end_date = p_effective_end_date

Line 1786: hr_utility.set_message(801,'HR_6001_ALL_MANDATORY_FIELD');

1782: ,ppf.per_information30 = p_i30
1783: where ppf.rowid = p_rowid;
1784: --
1785: if sql%rowcount <1 then
1786: hr_utility.set_message(801,'HR_6001_ALL_MANDATORY_FIELD');
1787: hr_utility.set_message_token('MISSING_FIELD','rowid is'||p_rowid);
1788: hr_utility.raise_error;
1789: end if;
1790: --

Line 1787: hr_utility.set_message_token('MISSING_FIELD','rowid is'||p_rowid);

1783: where ppf.rowid = p_rowid;
1784: --
1785: if sql%rowcount <1 then
1786: hr_utility.set_message(801,'HR_6001_ALL_MANDATORY_FIELD');
1787: hr_utility.set_message_token('MISSING_FIELD','rowid is'||p_rowid);
1788: hr_utility.raise_error;
1789: end if;
1790: --
1791: -- Tests required post-update

Line 1788: hr_utility.raise_error;

1784: --
1785: if sql%rowcount <1 then
1786: hr_utility.set_message(801,'HR_6001_ALL_MANDATORY_FIELD');
1787: hr_utility.set_message_token('MISSING_FIELD','rowid is'||p_rowid);
1788: hr_utility.raise_error;
1789: end if;
1790: --
1791: -- Tests required post-update
1792: --

Line 1793: hr_utility.set_location('update_row - after update',1);

1789: end if;
1790: --
1791: -- Tests required post-update
1792: --
1793: hr_utility.set_location('update_row - after update',1);
1794: --
1795: -- Has the Date of Birth changed?
1796: --
1797: if p_date_of_birth <> p_s_date_of_birth then

Line 1810: hr_utility.set_location('update_row - after update',2);

1806: ,p_start_date => p_last_update_date
1807: );
1808: end if;
1809: --
1810: hr_utility.set_location('update_row - after update',2);
1811: --
1812: -- test if hire_date has changed. and system person type has not.
1813: --
1814: if ((p_current_employee_flag = 'Y')

Line 1825: hr_utility.set_location('update_row - after update',3);

1821: per_people3_pkg.update_period(p_person_id =>p_person_id
1822: ,p_hire_date => p_s_hire_date
1823: ,p_new_hire_date =>p_hire_date);
1824: --
1825: hr_utility.set_location('update_row - after update',3);
1826: --
1827: -- Update the hire records i.e
1828: -- assignment etc.
1829: --

Line 1838: hr_utility.set_location('update_row - after update',4);

1834: ,p_s_hire_date
1835: ,p_last_updated_by
1836: ,p_last_update_login);
1837: --
1838: hr_utility.set_location('update_row - after update',4);
1839: --
1840: -- Run the assignment_link_usages and Element_entry
1841: -- code for Assignment Criteria.
1842: --