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

1537: l_proc VARCHAR2(50) := 'per_addresses_pkg.validate_address';
1538: --
1539: begin
1540: --
1541: hr_utility.set_location('Entering : '||l_proc,10);
1542: --
1543: open has_addrs;
1544: fetch has_addrs into v_dummy;
1545: --

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

1544: fetch has_addrs into v_dummy;
1545: --
1546: if has_addrs%notfound then
1547: --
1548: hr_utility.set_location(l_proc,20);
1549: --
1550: close has_addrs;
1551: --
1552: else

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

1552: else
1553: --
1554: close has_addrs;
1555: --
1556: hr_utility.set_location(l_proc,30);
1557: --
1558: -- Get the start and end of the first address
1559: --
1560: open get_mins;

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

1568: fetch check_min_is_primary into v_dummy;
1569: --
1570: if check_min_is_primary%NOTFOUND then
1571: --
1572: hr_utility.set_location(l_proc,40);
1573: --
1574: -- Minimum is not a primary,
1575: -- does a primary exist?
1576: --

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

1580: fetch has_primary into v_dummy;
1581: --
1582: if has_primary%NOTFOUND then
1583: --
1584: hr_utility.set_location(l_proc,50);
1585: --
1586: -- No primary, pass relevant error back
1587: --
1588: close has_primary;

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

1586: -- No primary, pass relevant error back
1587: --
1588: close has_primary;
1589: --
1590: hr_utility.set_message(801,'HR_7144_PER_NO_PRIM_ADD');
1591: hr_utility.raise_error;
1592: --
1593: else
1594: --

Line 1591: hr_utility.raise_error;

1587: --
1588: close has_primary;
1589: --
1590: hr_utility.set_message(801,'HR_7144_PER_NO_PRIM_ADD');
1591: hr_utility.raise_error;
1592: --
1593: else
1594: --
1595: -- Primary exists, and as minimum not the primary

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

1596: -- a gap in the primaries also exists
1597: --
1598: close has_primary;
1599: --
1600: hr_utility.set_message(800,'PER_52473_ADDR_SEC_AFTER_PRIM');
1601: hr_utility.raise_error;
1602: --
1603: end if;
1604: --

Line 1601: hr_utility.raise_error;

1597: --
1598: close has_primary;
1599: --
1600: hr_utility.set_message(800,'PER_52473_ADDR_SEC_AFTER_PRIM');
1601: hr_utility.raise_error;
1602: --
1603: end if;
1604: --
1605: else

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

1603: end if;
1604: --
1605: else
1606: --
1607: hr_utility.set_location(l_proc,60);
1608: --
1609: close check_min_is_primary;
1610: --
1611: end if;

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

1617: close get_next;
1618: if l_date_to is not null
1619: then
1620: loop
1621: hr_utility.set_location('hr_person.validate_address',5);
1622: exit when l_date_to is null;
1623: l_date_from := l_date_to + 1;
1624: open get_next(l_date_from);
1625: fetch get_next into l_date_to;

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

1622: exit when l_date_to is null;
1623: l_date_from := l_date_to + 1;
1624: open get_next(l_date_from);
1625: fetch get_next into l_date_to;
1626: hr_utility.set_location('hr_person.validate_address',6);
1627: if get_next%NOTFOUND
1628: then
1629: hr_utility.set_message(801,'HR_51030_ADDR_PRIM_GAP');
1630: hr_utility.raise_error;

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

1625: fetch get_next into l_date_to;
1626: hr_utility.set_location('hr_person.validate_address',6);
1627: if get_next%NOTFOUND
1628: then
1629: hr_utility.set_message(801,'HR_51030_ADDR_PRIM_GAP');
1630: hr_utility.raise_error;
1631: end if;
1632: hr_utility.set_location('hr_person.validate_address',7);
1633: close get_next;

Line 1630: hr_utility.raise_error;

1626: hr_utility.set_location('hr_person.validate_address',6);
1627: if get_next%NOTFOUND
1628: then
1629: hr_utility.set_message(801,'HR_51030_ADDR_PRIM_GAP');
1630: hr_utility.raise_error;
1631: end if;
1632: hr_utility.set_location('hr_person.validate_address',7);
1633: close get_next;
1634: end loop;

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

1628: then
1629: hr_utility.set_message(801,'HR_51030_ADDR_PRIM_GAP');
1630: hr_utility.raise_error;
1631: end if;
1632: hr_utility.set_location('hr_person.validate_address',7);
1633: close get_next;
1634: end loop;
1635: end if;
1636: */

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

1639: --
1640: open get_next;
1641: fetch get_next into a_date_from, a_date_to;
1642: --
1643: hr_utility.set_location(l_proc||'/'||a_date_from||'/'||a_Date_to,65);
1644: --
1645: loop
1646: --
1647: hr_utility.set_location(l_proc,70);

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

1643: hr_utility.set_location(l_proc||'/'||a_date_from||'/'||a_Date_to,65);
1644: --
1645: loop
1646: --
1647: hr_utility.set_location(l_proc,70);
1648: --
1649: fetch get_next into b_date_from, b_date_to;
1650: --
1651: hr_utility.set_location(l_proc||'/'||b_date_from||'/'||b_Date_to,75);

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

1647: hr_utility.set_location(l_proc,70);
1648: --
1649: fetch get_next into b_date_from, b_date_to;
1650: --
1651: hr_utility.set_location(l_proc||'/'||b_date_from||'/'||b_Date_to,75);
1652: --
1653: -- If there is another primary address then check that the
1654: -- dates match up so there is no gaps between the end of one
1655: -- primary address and the beginning of the next.

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

1655: -- primary address and the beginning of the next.
1656: --
1657: if get_next%FOUND then
1658: --
1659: hr_utility.set_location(l_proc,80);
1660: --
1661: if b_date_from <> a_date_to + 1 then
1662: --
1663: hr_utility.set_location(l_proc,90);

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

1659: hr_utility.set_location(l_proc,80);
1660: --
1661: if b_date_from <> a_date_to + 1 then
1662: --
1663: hr_utility.set_location(l_proc,90);
1664: --
1665: close get_next;
1666: --
1667: hr_utility.set_message(801,'HR_51030_ADDR_PRIM_GAP');

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

1663: hr_utility.set_location(l_proc,90);
1664: --
1665: close get_next;
1666: --
1667: hr_utility.set_message(801,'HR_51030_ADDR_PRIM_GAP');
1668: hr_utility.raise_error;
1669: --
1670: end if;
1671: --

Line 1668: hr_utility.raise_error;

1664: --
1665: close get_next;
1666: --
1667: hr_utility.set_message(801,'HR_51030_ADDR_PRIM_GAP');
1668: hr_utility.raise_error;
1669: --
1670: end if;
1671: --
1672: else

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

1670: end if;
1671: --
1672: else
1673: --
1674: hr_utility.set_location(l_proc,100);
1675: --
1676: open check_other_person_type;
1677: fetch check_other_person_type into v_dummy;
1678: --

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

1677: fetch check_other_person_type into v_dummy;
1678: --
1679: if check_other_person_type%FOUND then
1680: --
1681: hr_utility.set_location(l_proc,110);
1682: --
1683: exit;
1684: --
1685: end if;

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

1696: if a_date_to is not null then
1697: --
1698: close get_next;
1699: --
1700: hr_utility.set_message(801,'HR_7144_PER_NO_PRIM_ADD');
1701: hr_utility.raise_error;
1702: --
1703: end if;
1704: --

Line 1701: hr_utility.raise_error;

1697: --
1698: close get_next;
1699: --
1700: hr_utility.set_message(801,'HR_7144_PER_NO_PRIM_ADD');
1701: hr_utility.raise_error;
1702: --
1703: end if;
1704: --
1705: end if;

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

1710: a_date_to := b_date_to;
1711: --
1712: end loop;
1713: --
1714: hr_utility.set_location(l_proc,120);
1715: --
1716: close get_next;
1717: --
1718: -- Primary exists and form trying to enter primary

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

1724: if get_overlapping%FOUND then
1725: --
1726: close get_overlapping;
1727: --
1728: hr_utility.set_message(801,'HR_6510_PER_PRIMARY_ADDRESS');
1729: hr_utility.raise_error;
1730: --
1731: end if;
1732: --

Line 1729: hr_utility.raise_error;

1725: --
1726: close get_overlapping;
1727: --
1728: hr_utility.set_message(801,'HR_6510_PER_PRIMARY_ADDRESS');
1729: hr_utility.raise_error;
1730: --
1731: end if;
1732: --
1733: close get_overlapping;

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

1740: if validate_address_types%FOUND then
1741: --
1742: close validate_address_types;
1743: --
1744: hr_utility.set_message(800,'PER_52244_ONE_ADD_OF_EACH_TYPE');
1745: hr_utility.raise_error;
1746: --
1747: end if;
1748: --

Line 1745: hr_utility.raise_error;

1741: --
1742: close validate_address_types;
1743: --
1744: hr_utility.set_message(800,'PER_52244_ONE_ADD_OF_EACH_TYPE');
1745: hr_utility.raise_error;
1746: --
1747: end if;
1748: --
1749: close validate_address_types;

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

1747: end if;
1748: --
1749: close validate_address_types;
1750: --
1751: hr_utility.set_location('Leaving : '||l_proc,999);
1752: --
1753: end validate_address;
1754: --
1755: END PER_ADDRESSES_PKG;