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_ADDRESSES_PKG dependencies on HR_UTILITY

Line 41: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

37: l_msg_data Varchar2(2000);
38: l_error_msg Varchar2(2000);
39: l_proc_name CONSTANT Varchar2(150):= g_pkg||'InsUpd_OSS_Person_Add';
40: BEGIN
41: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
42: l_return_flag := False;
43: OPEN csr_stu (c_person_id => p_addr_rec_new.person_id);
44: FETCH csr_stu INTO l_Stu_OSSData_Sync;
45: CLOSE csr_stu;

Line 54: Hr_Utility.set_location('..person_id : '||p_addr_rec_new.person_id, 6);

50: p_addr_rec_new.party_id IS NULL
51: THEN
52: l_return_flag := TRUE;
53: END IF;
54: Hr_Utility.set_location('..person_id : '||p_addr_rec_new.person_id, 6);
55: Hr_Utility.set_location('..sync Flag : '||l_Stu_OSSData_Sync, 6);
56: Hr_Utility.set_location('..party_id : '||p_addr_rec_new.party_id , 6);
57: Hr_Utility.set_location('..Bus Grp Id : '||p_addr_rec_new.business_group_id, 6);
58: -- Return if any of the above conditions are true

Line 55: Hr_Utility.set_location('..sync Flag : '||l_Stu_OSSData_Sync, 6);

51: THEN
52: l_return_flag := TRUE;
53: END IF;
54: Hr_Utility.set_location('..person_id : '||p_addr_rec_new.person_id, 6);
55: Hr_Utility.set_location('..sync Flag : '||l_Stu_OSSData_Sync, 6);
56: Hr_Utility.set_location('..party_id : '||p_addr_rec_new.party_id , 6);
57: Hr_Utility.set_location('..Bus Grp Id : '||p_addr_rec_new.business_group_id, 6);
58: -- Return if any of the above conditions are true
59: IF l_return_flag THEN

Line 56: Hr_Utility.set_location('..party_id : '||p_addr_rec_new.party_id , 6);

52: l_return_flag := TRUE;
53: END IF;
54: Hr_Utility.set_location('..person_id : '||p_addr_rec_new.person_id, 6);
55: Hr_Utility.set_location('..sync Flag : '||l_Stu_OSSData_Sync, 6);
56: Hr_Utility.set_location('..party_id : '||p_addr_rec_new.party_id , 6);
57: Hr_Utility.set_location('..Bus Grp Id : '||p_addr_rec_new.business_group_id, 6);
58: -- Return if any of the above conditions are true
59: IF l_return_flag THEN
60: Hr_Utility.set_location('..Returning : '||l_proc_name,7 );

Line 57: Hr_Utility.set_location('..Bus Grp Id : '||p_addr_rec_new.business_group_id, 6);

53: END IF;
54: Hr_Utility.set_location('..person_id : '||p_addr_rec_new.person_id, 6);
55: Hr_Utility.set_location('..sync Flag : '||l_Stu_OSSData_Sync, 6);
56: Hr_Utility.set_location('..party_id : '||p_addr_rec_new.party_id , 6);
57: Hr_Utility.set_location('..Bus Grp Id : '||p_addr_rec_new.business_group_id, 6);
58: -- Return if any of the above conditions are true
59: IF l_return_flag THEN
60: Hr_Utility.set_location('..Returning : '||l_proc_name,7 );
61: RETURN;

Line 60: Hr_Utility.set_location('..Returning : '||l_proc_name,7 );

56: Hr_Utility.set_location('..party_id : '||p_addr_rec_new.party_id , 6);
57: Hr_Utility.set_location('..Bus Grp Id : '||p_addr_rec_new.business_group_id, 6);
58: -- Return if any of the above conditions are true
59: IF l_return_flag THEN
60: Hr_Utility.set_location('..Returning : '||l_proc_name,7 );
61: RETURN;
62: END IF;
63:
64: If p_action = 'UPDATE' AND

Line 66: Hr_Utility.set_location('..p_action : '||p_action,9 );

62: END IF;
63:
64: If p_action = 'UPDATE' AND
65: Not l_return_flag THEN
66: Hr_Utility.set_location('..p_action : '||p_action,9 );
67: Pqp_Hrtca_Integration.Update_Address_HR_To_TCA
68: (p_business_group_id => p_addr_rec_new.business_group_id
69: ,p_person_id => p_addr_rec_new.person_id
70: ,p_party_id => p_addr_rec_new.party_id

Line 92: Hr_Utility.set_location('..p_action : '||p_action,9 );

88: ,p_msg_data => l_msg_data
89: );
90: ELSIF p_action = 'INSERT' AND
91: Not l_return_flag THEN
92: Hr_Utility.set_location('..p_action : '||p_action,9 );
93: Pqp_Hrtca_Integration.Create_Address_HR_To_TCA
94: (p_business_group_id => p_addr_rec_new.business_group_id
95: ,p_person_id => p_addr_rec_new.person_id
96: ,p_party_id => p_addr_rec_new.party_id

Line 117: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

113: ,p_msg_data => l_msg_data
114: );
115: END IF;
116: IF l_return_status IN ('E','U') THEN
117: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
118: Hr_Utility.set_message_token('GENERIC_TOKEN',l_msg_data );
119: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
120: Hr_Utility.raise_error;
121: END IF;

Line 118: Hr_Utility.set_message_token('GENERIC_TOKEN',l_msg_data );

114: );
115: END IF;
116: IF l_return_status IN ('E','U') THEN
117: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
118: Hr_Utility.set_message_token('GENERIC_TOKEN',l_msg_data );
119: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
120: Hr_Utility.raise_error;
121: END IF;
122:

Line 119: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

115: END IF;
116: IF l_return_status IN ('E','U') THEN
117: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
118: Hr_Utility.set_message_token('GENERIC_TOKEN',l_msg_data );
119: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
120: Hr_Utility.raise_error;
121: END IF;
122:
123: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);

Line 120: Hr_Utility.raise_error;

116: IF l_return_status IN ('E','U') THEN
117: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
118: Hr_Utility.set_message_token('GENERIC_TOKEN',l_msg_data );
119: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
120: Hr_Utility.raise_error;
121: END IF;
122:
123: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
124:

Line 123: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);

119: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
120: Hr_Utility.raise_error;
121: END IF;
122:
123: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
124:
125: EXCEPTION
126: WHEN OTHERS THEN
127: l_error_msg := Substrb(l_msg_data,1,2000);

Line 128: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

124:
125: EXCEPTION
126: WHEN OTHERS THEN
127: l_error_msg := Substrb(l_msg_data,1,2000);
128: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
129: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
130: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
131: Hr_Utility.raise_error;
132:

Line 129: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );

125: EXCEPTION
126: WHEN OTHERS THEN
127: l_error_msg := Substrb(l_msg_data,1,2000);
128: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
129: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
130: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
131: Hr_Utility.raise_error;
132:
133: END InsUpd_OSS_Person_Add;

Line 130: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

126: WHEN OTHERS THEN
127: l_error_msg := Substrb(l_msg_data,1,2000);
128: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
129: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
130: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
131: Hr_Utility.raise_error;
132:
133: END InsUpd_OSS_Person_Add;
134:

Line 131: Hr_Utility.raise_error;

127: l_error_msg := Substrb(l_msg_data,1,2000);
128: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
129: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
130: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
131: Hr_Utility.raise_error;
132:
133: END InsUpd_OSS_Person_Add;
134:
135: /*

Line 388: hr_utility.set_location('Insert_row',1);

384: --
385: -- End of Fix for WWBUG 1408379
386: --
387: begin
388: hr_utility.set_location('Insert_row',1);
389: --
390: open c1;
391: fetch c1 into p_address_id;
392: close c1;

Line 934: hr_utility.set_location('update_row',1);

930: l_return_code number;
931: l_return_text varchar2(240);
932:
933: begin
934: hr_utility.set_location('update_row',1);
935: PER_ADDRESSES_PKG.update_row(p_row_id
936: ,p_address_id
937: ,p_business_group_id
938: ,p_person_id

Line 1316: hr_utility.set_message(801,'HR_51030_ADDR_PRIM_GAP');

1312: begin
1313: open get_addr;
1314: fetch get_addr into l_gap_exists;
1315: if get_addr%FOUND then
1316: hr_utility.set_message(801,'HR_51030_ADDR_PRIM_GAP');
1317: hr_utility.raise_error;
1318: end if;
1319: close get_addr;
1320: end find_gaps;

Line 1317: hr_utility.raise_error;

1313: open get_addr;
1314: fetch get_addr into l_gap_exists;
1315: if get_addr%FOUND then
1316: hr_utility.set_message(801,'HR_51030_ADDR_PRIM_GAP');
1317: hr_utility.raise_error;
1318: end if;
1319: close get_addr;
1320: end find_gaps;
1321: --

Line 1370: hr_utility.set_location('l_default'||l_default,1);

1366: --
1367: p_default_country := l_default;
1368: p_default_style := l_default_code;
1369: --
1370: hr_utility.set_location('l_default'||l_default,1);
1371: hr_utility.set_location('l_default_code'||l_default_code,2);
1372: end get_default_style;
1373: --
1374: procedure get_addresses(p_legislation_code VARCHAR2

Line 1371: hr_utility.set_location('l_default_code'||l_default_code,2);

1367: p_default_country := l_default;
1368: p_default_style := l_default_code;
1369: --
1370: hr_utility.set_location('l_default'||l_default,1);
1371: hr_utility.set_location('l_default_code'||l_default_code,2);
1372: end get_default_style;
1373: --
1374: procedure get_addresses(p_legislation_code VARCHAR2
1375: ,p_default_country IN OUT NOCOPY VARCHAR2) is

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

1563: l_proc VARCHAR2(50) := 'per_addresses_pkg.validate_address';
1564: --
1565: begin
1566: --
1567: hr_utility.set_location('Entering : '||l_proc,10);
1568:
1569: if per_per_bus.return_legislation_code(p_person_id) ='US' -- changes for bug14230926
1570: and ((hr_general.chk_product_installed(801) = 'TRUE') or
1571: (fnd_profile.value('PER_ENABLE_DTW4') = 'Y')) then

Line 1583: hr_utility.set_message(800,'PER_PAYROLL_EXISTS');

1579: fetch get_next into a_date_from, a_date_to;
1580: if get_next%found then
1581: close get_next;
1582: if a_date_from>v_effective_date then
1583: hr_utility.set_message(800,'PER_PAYROLL_EXISTS');
1584: hr_utility.raise_error;
1585: end if;
1586: else
1587: close get_next;

Line 1584: hr_utility.raise_error;

1580: if get_next%found then
1581: close get_next;
1582: if a_date_from>v_effective_date then
1583: hr_utility.set_message(800,'PER_PAYROLL_EXISTS');
1584: hr_utility.raise_error;
1585: end if;
1586: else
1587: close get_next;
1588: hr_utility.set_message(800,'PER_51831_NO_PRI_ADDRESS');

Line 1588: hr_utility.set_message(800,'PER_51831_NO_PRI_ADDRESS');

1584: hr_utility.raise_error;
1585: end if;
1586: else
1587: close get_next;
1588: hr_utility.set_message(800,'PER_51831_NO_PRI_ADDRESS');
1589: hr_utility.raise_error;
1590: end if;
1591: else
1592: close get_payroll;

Line 1589: hr_utility.raise_error;

1585: end if;
1586: else
1587: close get_next;
1588: hr_utility.set_message(800,'PER_51831_NO_PRI_ADDRESS');
1589: hr_utility.raise_error;
1590: end if;
1591: else
1592: close get_payroll;
1593: end if;

Line 1601: hr_utility.set_location(l_proc,20);

1597: fetch has_addrs into v_dummy;
1598: --
1599: if has_addrs%notfound then
1600: --
1601: hr_utility.set_location(l_proc,20);
1602: --
1603: close has_addrs;
1604: --
1605: else

Line 1609: hr_utility.set_location(l_proc,30);

1605: else
1606: --
1607: close has_addrs;
1608: --
1609: hr_utility.set_location(l_proc,30);
1610: --
1611: -- Get the start and end of the first address
1612: --
1613: open get_mins;

Line 1625: hr_utility.set_location(l_proc,40);

1621: fetch check_min_is_primary into v_dummy;
1622: --
1623: if check_min_is_primary%NOTFOUND then
1624: --
1625: hr_utility.set_location(l_proc,40);
1626: --
1627: -- Minimum is not a primary,
1628: -- does a primary exist?
1629: --

Line 1637: hr_utility.set_location(l_proc,50);

1633: fetch has_primary into v_dummy;
1634: --
1635: if has_primary%NOTFOUND then
1636: --
1637: hr_utility.set_location(l_proc,50);
1638: --
1639: -- No primary, pass relevant error back
1640: --
1641: close has_primary;

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

1639: -- No primary, pass relevant error back
1640: --
1641: close has_primary;
1642: --
1643: hr_utility.set_message(801,'HR_7144_PER_NO_PRIM_ADD');
1644: hr_utility.raise_error;
1645: --
1646: else
1647: --

Line 1644: hr_utility.raise_error;

1640: --
1641: close has_primary;
1642: --
1643: hr_utility.set_message(801,'HR_7144_PER_NO_PRIM_ADD');
1644: hr_utility.raise_error;
1645: --
1646: else
1647: --
1648: -- Primary exists, and as minimum not the primary

Line 1653: hr_utility.set_message(800,'PER_52473_ADDR_SEC_AFTER_PRIM');

1649: -- a gap in the primaries also exists
1650: --
1651: close has_primary;
1652: --
1653: hr_utility.set_message(800,'PER_52473_ADDR_SEC_AFTER_PRIM');
1654: hr_utility.raise_error;
1655: --
1656: end if;
1657: --

Line 1654: hr_utility.raise_error;

1650: --
1651: close has_primary;
1652: --
1653: hr_utility.set_message(800,'PER_52473_ADDR_SEC_AFTER_PRIM');
1654: hr_utility.raise_error;
1655: --
1656: end if;
1657: --
1658: else

Line 1660: hr_utility.set_location(l_proc,60);

1656: end if;
1657: --
1658: else
1659: --
1660: hr_utility.set_location(l_proc,60);
1661: --
1662: close check_min_is_primary;
1663: --
1664: end if;

Line 1676: hr_utility.set_message(800,'HR_50442_PER_PRIM_ADDR_OVERLAP');

1672: if get_overlapping%FOUND then
1673: --
1674: close get_overlapping;
1675: --
1676: hr_utility.set_message(800,'HR_50442_PER_PRIM_ADDR_OVERLAP');
1677: hr_utility.raise_error;
1678: --
1679: end if;
1680: --

Line 1677: hr_utility.raise_error;

1673: --
1674: close get_overlapping;
1675: --
1676: hr_utility.set_message(800,'HR_50442_PER_PRIM_ADDR_OVERLAP');
1677: hr_utility.raise_error;
1678: --
1679: end if;
1680: --
1681: close get_overlapping;

Line 1690: hr_utility.set_location('hr_person.validate_address',5);

1686: close get_next;
1687: if l_date_to is not null
1688: then
1689: loop
1690: hr_utility.set_location('hr_person.validate_address',5);
1691: exit when l_date_to is null;
1692: l_date_from := l_date_to + 1;
1693: open get_next(l_date_from);
1694: fetch get_next into l_date_to;

Line 1695: hr_utility.set_location('hr_person.validate_address',6);

1691: exit when l_date_to is null;
1692: l_date_from := l_date_to + 1;
1693: open get_next(l_date_from);
1694: fetch get_next into l_date_to;
1695: hr_utility.set_location('hr_person.validate_address',6);
1696: if get_next%NOTFOUND
1697: then
1698: hr_utility.set_message(801,'HR_51030_ADDR_PRIM_GAP');
1699: hr_utility.raise_error;

Line 1698: hr_utility.set_message(801,'HR_51030_ADDR_PRIM_GAP');

1694: fetch get_next into l_date_to;
1695: hr_utility.set_location('hr_person.validate_address',6);
1696: if get_next%NOTFOUND
1697: then
1698: hr_utility.set_message(801,'HR_51030_ADDR_PRIM_GAP');
1699: hr_utility.raise_error;
1700: end if;
1701: hr_utility.set_location('hr_person.validate_address',7);
1702: close get_next;

Line 1699: hr_utility.raise_error;

1695: hr_utility.set_location('hr_person.validate_address',6);
1696: if get_next%NOTFOUND
1697: then
1698: hr_utility.set_message(801,'HR_51030_ADDR_PRIM_GAP');
1699: hr_utility.raise_error;
1700: end if;
1701: hr_utility.set_location('hr_person.validate_address',7);
1702: close get_next;
1703: end loop;

Line 1701: hr_utility.set_location('hr_person.validate_address',7);

1697: then
1698: hr_utility.set_message(801,'HR_51030_ADDR_PRIM_GAP');
1699: hr_utility.raise_error;
1700: end if;
1701: hr_utility.set_location('hr_person.validate_address',7);
1702: close get_next;
1703: end loop;
1704: end if;
1705: */

Line 1712: hr_utility.set_location(l_proc||'/'||a_date_from||'/'||a_Date_to,65);

1708: --
1709: open get_next;
1710: fetch get_next into a_date_from, a_date_to;
1711: --
1712: hr_utility.set_location(l_proc||'/'||a_date_from||'/'||a_Date_to,65);
1713: --
1714: loop
1715: --
1716: hr_utility.set_location(l_proc,70);

Line 1716: hr_utility.set_location(l_proc,70);

1712: hr_utility.set_location(l_proc||'/'||a_date_from||'/'||a_Date_to,65);
1713: --
1714: loop
1715: --
1716: hr_utility.set_location(l_proc,70);
1717: --
1718: fetch get_next into b_date_from, b_date_to;
1719: --
1720: hr_utility.set_location(l_proc||'/'||b_date_from||'/'||b_Date_to,75);

Line 1720: hr_utility.set_location(l_proc||'/'||b_date_from||'/'||b_Date_to,75);

1716: hr_utility.set_location(l_proc,70);
1717: --
1718: fetch get_next into b_date_from, b_date_to;
1719: --
1720: hr_utility.set_location(l_proc||'/'||b_date_from||'/'||b_Date_to,75);
1721: --
1722: -- If there is another primary address then check that the
1723: -- dates match up so there is no gaps between the end of one
1724: -- primary address and the beginning of the next.

Line 1728: hr_utility.set_location(l_proc,80);

1724: -- primary address and the beginning of the next.
1725: --
1726: if get_next%FOUND then
1727: --
1728: hr_utility.set_location(l_proc,80);
1729: --
1730: if b_date_from <> a_date_to + 1 then
1731: --
1732: hr_utility.set_location(l_proc,90);

Line 1732: hr_utility.set_location(l_proc,90);

1728: hr_utility.set_location(l_proc,80);
1729: --
1730: if b_date_from <> a_date_to + 1 then
1731: --
1732: hr_utility.set_location(l_proc,90);
1733: --
1734: close get_next;
1735: --
1736: hr_utility.set_message(801,'HR_51030_ADDR_PRIM_GAP');

Line 1736: hr_utility.set_message(801,'HR_51030_ADDR_PRIM_GAP');

1732: hr_utility.set_location(l_proc,90);
1733: --
1734: close get_next;
1735: --
1736: hr_utility.set_message(801,'HR_51030_ADDR_PRIM_GAP');
1737: hr_utility.raise_error;
1738: --
1739: end if;
1740: --

Line 1737: hr_utility.raise_error;

1733: --
1734: close get_next;
1735: --
1736: hr_utility.set_message(801,'HR_51030_ADDR_PRIM_GAP');
1737: hr_utility.raise_error;
1738: --
1739: end if;
1740: --
1741: else

Line 1743: hr_utility.set_location(l_proc,100);

1739: end if;
1740: --
1741: else
1742: --
1743: hr_utility.set_location(l_proc,100);
1744:
1745: -- start changes for bug #10067018
1746: --
1747: open check_emp_cwk_person_type1(a_date_to);

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

1761: if a_date_to is not null then
1762: --
1763: close get_next;
1764: --
1765: hr_utility.set_message(801,'HR_7144_PER_NO_PRIM_ADD');
1766: hr_utility.raise_error;
1767: --
1768: end if;
1769:

Line 1766: hr_utility.raise_error;

1762: --
1763: close get_next;
1764: --
1765: hr_utility.set_message(801,'HR_7144_PER_NO_PRIM_ADD');
1766: hr_utility.raise_error;
1767: --
1768: end if;
1769:
1770: -- start changes for bug #10067018

Line 1773: hr_utility.set_location(l_proc,110);

1769:
1770: -- start changes for bug #10067018
1771: else
1772: close check_emp_cwk_person_type1;
1773: hr_utility.set_location(l_proc,110);
1774: --
1775: --exit;
1776: --
1777: end if;

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

1791:
1792: if SQL%FOUND then
1793: close get_next;
1794: close check_emp_cwk_person_type2;
1795: hr_utility.set_message(801,'HR_7144_PER_NO_PRIM_ADD');
1796: hr_utility.raise_error;
1797: end if; */
1798:
1799: -- changes for bug13602807

Line 1796: hr_utility.raise_error;

1792: if SQL%FOUND then
1793: close get_next;
1794: close check_emp_cwk_person_type2;
1795: hr_utility.set_message(801,'HR_7144_PER_NO_PRIM_ADD');
1796: hr_utility.raise_error;
1797: end if; */
1798:
1799: -- changes for bug13602807
1800: select 'Y'

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

1807:
1808: exception when no_data_found then
1809: close get_next;
1810: close check_emp_cwk_person_type2;
1811: hr_utility.set_message(801,'HR_7144_PER_NO_PRIM_ADD');
1812: hr_utility.raise_error;
1813:
1814: end;
1815:

Line 1812: hr_utility.raise_error;

1808: exception when no_data_found then
1809: close get_next;
1810: close check_emp_cwk_person_type2;
1811: hr_utility.set_message(801,'HR_7144_PER_NO_PRIM_ADD');
1812: hr_utility.raise_error;
1813:
1814: end;
1815:
1816: -- end of changes for bug13602807

Line 1820: hr_utility.set_location(l_proc,130);

1816: -- end of changes for bug13602807
1817: else
1818:
1819: close check_emp_cwk_person_type2;
1820: hr_utility.set_location(l_proc,130);
1821: exit;
1822: end if;
1823: -- end changes for bug #10067018
1824: --

Line 1834: hr_utility.set_location(l_proc,120);

1830: a_date_to := b_date_to;
1831: --
1832: end loop;
1833: --
1834: hr_utility.set_location(l_proc,120);
1835: --
1836: close get_next;
1837: --
1838: -- Primary exists and form trying to enter primary

Line 1851: hr_utility.set_message(800,'PER_52244_ONE_ADD_OF_EACH_TYPE');

1847: if validate_address_types%FOUND then
1848: --
1849: close validate_address_types;
1850: --
1851: hr_utility.set_message(800,'PER_52244_ONE_ADD_OF_EACH_TYPE');
1852: hr_utility.raise_error;
1853: --
1854: end if;
1855: --

Line 1852: hr_utility.raise_error;

1848: --
1849: close validate_address_types;
1850: --
1851: hr_utility.set_message(800,'PER_52244_ONE_ADD_OF_EACH_TYPE');
1852: hr_utility.raise_error;
1853: --
1854: end if;
1855: --
1856: close validate_address_types;

Line 1858: hr_utility.set_location('Leaving : '||l_proc,999);

1854: end if;
1855: --
1856: close validate_address_types;
1857: --
1858: hr_utility.set_location('Leaving : '||l_proc,999);
1859: --
1860: end validate_address;
1861: --
1862: END PER_ADDRESSES_PKG;