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

Line 251: hr_utility.set_location('Entering:'|| l_proc, 5);

247: l_full_name varchar2(240);
248: l_per_comment_id number;
249: --
250: begin
251: hr_utility.set_location('Entering:'|| l_proc, 5);
252: --
253: -- Issue a savepoint.
254: --
255: l_start_date := trunc(p_start_date);

Line 260: hr_utility.set_location(l_proc, 6);

256: l_date_start := trunc(p_date_start);
257: l_date_end := trunc(p_date_end);
258: --
259: savepoint create_contact;
260: hr_utility.set_location(l_proc, 6);
261: --
262: --
263: begin
264: --

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

579: --
580: -- Now we are sure of having a person_id for a contact, insert the
581: -- details by calling the per_contact_relationships row handler.
582: --
583: hr_utility.set_location(l_proc, 40);
584: --
585: per_ctr_ins.ins(p_contact_relationship_id => l_contact_relationship_id
586: ,p_business_group_id => p_business_group_id
587: ,p_person_id => p_person_id

Line 651: hr_utility.set_location(l_proc||'First contact created with id: ',l_contact_relationship_id);

647: );
648: --
649: -- Set pipe on for Debug output
650: --
651: hr_utility.set_location(l_proc||'First contact created with id: ',l_contact_relationship_id);
652: hr_utility.set_location(l_proc||' and type: '||p_contact_type, 0);
653: hr_utility.set_location(l_proc||' and person_id: ',p_person_id);
654: hr_utility.set_location(l_proc||' and contact_person_id: ',l_contact_person_id);
655: --

Line 652: hr_utility.set_location(l_proc||' and type: '||p_contact_type, 0);

648: --
649: -- Set pipe on for Debug output
650: --
651: hr_utility.set_location(l_proc||'First contact created with id: ',l_contact_relationship_id);
652: hr_utility.set_location(l_proc||' and type: '||p_contact_type, 0);
653: hr_utility.set_location(l_proc||' and person_id: ',p_person_id);
654: hr_utility.set_location(l_proc||' and contact_person_id: ',l_contact_person_id);
655: --
656: -- start of code for bug 2678841

Line 653: hr_utility.set_location(l_proc||' and person_id: ',p_person_id);

649: -- Set pipe on for Debug output
650: --
651: hr_utility.set_location(l_proc||'First contact created with id: ',l_contact_relationship_id);
652: hr_utility.set_location(l_proc||' and type: '||p_contact_type, 0);
653: hr_utility.set_location(l_proc||' and person_id: ',p_person_id);
654: hr_utility.set_location(l_proc||' and contact_person_id: ',l_contact_person_id);
655: --
656: -- start of code for bug 2678841
657: if p_contact_type in ('P','C','S') and

Line 654: hr_utility.set_location(l_proc||' and contact_person_id: ',l_contact_person_id);

650: --
651: hr_utility.set_location(l_proc||'First contact created with id: ',l_contact_relationship_id);
652: hr_utility.set_location(l_proc||' and type: '||p_contact_type, 0);
653: hr_utility.set_location(l_proc||' and person_id: ',p_person_id);
654: hr_utility.set_location(l_proc||' and contact_person_id: ',l_contact_person_id);
655: --
656: -- start of code for bug 2678841
657: if p_contact_type in ('P','C','S') and
658: p_personal_flag <> 'Y' then

Line 659: hr_utility.set_message(800,'PER_6994_PERSONAL_FLAG');

655: --
656: -- start of code for bug 2678841
657: if p_contact_type in ('P','C','S') and
658: p_personal_flag <> 'Y' then
659: hr_utility.set_message(800,'PER_6994_PERSONAL_FLAG');
660: hr_utility.raise_error;
661: end if;
662: -- end of code for bug 2678841
663:

Line 660: hr_utility.raise_error;

656: -- start of code for bug 2678841
657: if p_contact_type in ('P','C','S') and
658: p_personal_flag <> 'Y' then
659: hr_utility.set_message(800,'PER_6994_PERSONAL_FLAG');
660: hr_utility.raise_error;
661: end if;
662: -- end of code for bug 2678841
663:
664: if p_create_mirror_flag = 'Y' then

Line 687: hr_utility.set_message(801, 'PER_6995_MIRR_CON_REL_TYPES');

683: --
684: if p_contact_type = 'P' and p_mirror_type <> 'C'
685: or p_contact_type = 'C' and p_mirror_type <> 'P'
686: or p_contact_type = 'S' and p_mirror_type <> 'S' then
687: hr_utility.set_message(801, 'PER_6995_MIRR_CON_REL_TYPES');
688: hr_utility.raise_error;
689: end if;
690: --
691: if (p_date_start is not null

Line 688: hr_utility.raise_error;

684: if p_contact_type = 'P' and p_mirror_type <> 'C'
685: or p_contact_type = 'C' and p_mirror_type <> 'P'
686: or p_contact_type = 'S' and p_mirror_type <> 'S' then
687: hr_utility.set_message(801, 'PER_6995_MIRR_CON_REL_TYPES');
688: hr_utility.raise_error;
689: end if;
690: --
691: if (p_date_start is not null
692: and p_date_of_birth is not null

Line 700: hr_utility.set_location(l_proc, 45);

696: end if;
697: --
698: -- Insert the mirror contact relationship
699: --
700: hr_utility.set_location(l_proc, 45);
701: --
702: per_ctr_ins.ins(p_contact_relationship_id => l_mirror_contact_rel_id
703: ,p_business_group_id => p_business_group_id
704: ,p_person_id => l_person_id

Line 768: hr_utility.set_location(l_proc||'Mirror contact created with id: ',l_mirror_contact_rel_id);

764: );
765: --
766: -- Set pipe on for Debug output
767: --
768: hr_utility.set_location(l_proc||'Mirror contact created with id: ',l_mirror_contact_rel_id);
769: hr_utility.set_location(l_proc||' and type: '||l_contact_type, 0);
770: hr_utility.set_location(l_proc||' and person_id: ',l_person_id);
771: hr_utility.set_location(l_proc||' and contact_person_id: ',l_contact_person_id);
772: --

Line 769: hr_utility.set_location(l_proc||' and type: '||l_contact_type, 0);

765: --
766: -- Set pipe on for Debug output
767: --
768: hr_utility.set_location(l_proc||'Mirror contact created with id: ',l_mirror_contact_rel_id);
769: hr_utility.set_location(l_proc||' and type: '||l_contact_type, 0);
770: hr_utility.set_location(l_proc||' and person_id: ',l_person_id);
771: hr_utility.set_location(l_proc||' and contact_person_id: ',l_contact_person_id);
772: --
773: end if;

Line 770: hr_utility.set_location(l_proc||' and person_id: ',l_person_id);

766: -- Set pipe on for Debug output
767: --
768: hr_utility.set_location(l_proc||'Mirror contact created with id: ',l_mirror_contact_rel_id);
769: hr_utility.set_location(l_proc||' and type: '||l_contact_type, 0);
770: hr_utility.set_location(l_proc||' and person_id: ',l_person_id);
771: hr_utility.set_location(l_proc||' and contact_person_id: ',l_contact_person_id);
772: --
773: end if;
774: --

Line 771: hr_utility.set_location(l_proc||' and contact_person_id: ',l_contact_person_id);

767: --
768: hr_utility.set_location(l_proc||'Mirror contact created with id: ',l_mirror_contact_rel_id);
769: hr_utility.set_location(l_proc||' and type: '||l_contact_type, 0);
770: hr_utility.set_location(l_proc||' and person_id: ',l_person_id);
771: hr_utility.set_location(l_proc||' and contact_person_id: ',l_contact_person_id);
772: --
773: end if;
774: --
775: -- 1766066: added call for contact start date enh.

Line 1021: hr_utility.set_location(' Leaving:'||l_proc, 11);

1017: if p_validate then
1018: raise hr_api.validate_enabled;
1019: end if;
1020: --
1021: hr_utility.set_location(' Leaving:'||l_proc, 11);
1022: exception
1023: when hr_api.validate_enabled then
1024: --
1025: -- As the Validate_Enabled exception has been raised

Line 1045: hr_utility.set_location(' Leaving:'||l_proc, 50);

1041: p_full_name := null;
1042: p_per_comment_id := null;
1043: p_contact_relationship_id := null;
1044:
1045: hr_utility.set_location(' Leaving:'||l_proc, 50);
1046: --
1047: when others then
1048: --
1049: -- A validation or unexpected error has occurred

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

1187: l_personal_flag varchar2(1);
1188: l_contact_person_id number;
1189: --
1190: begin
1191: hr_utility.set_location('Entering:'|| l_proc, 10);
1192: --
1193: -- Store initial values for IN OUT parameters
1194: --
1195: l_object_version_number := p_object_version_number;

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

1202: -- Issue a savepoint.
1203: --
1204: savepoint update_contact_relationship;
1205: --
1206: hr_utility.set_location(l_proc, 20);
1207: --
1208: begin
1209: --
1210: -- Start of API User Hook for the before hook of update_contact_relationship

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

1356: ,p_cont_information20 => p_cont_information20
1357: ,p_object_version_number => p_object_version_number
1358: );
1359:
1360: hr_utility.set_location(l_proc, 30);
1361: --
1362: if ((p_date_start <> hr_api.g_date
1363: and p_date_start <> nvl(l_date_start,hr_api.g_date))
1364: or (p_start_life_reason_id <> hr_api.g_number

Line 1386: hr_utility.set_location('id '||l_mirror_rec.contact_relationship_id, 7);

1382: open check_mirror;
1383: fetch check_mirror into l_mirror_rec;
1384: if check_mirror%found then
1385: --
1386: hr_utility.set_location('id '||l_mirror_rec.contact_relationship_id, 7);
1387: --
1388: -- Now update the Mirror Contact by calling the Row Handler.
1389: --
1390: per_ctr_upd.upd

Line 1412: hr_utility.set_message(800,'PER_6994_PERSONAL_FLAG');

1408: if p_personal_flag <> hr_api.g_varchar2 then
1409: if p_contact_type=hr_api.g_varchar2 then
1410: if l_contact_type in ('P','C','S') and
1411: p_personal_flag <> 'Y' then
1412: hr_utility.set_message(800,'PER_6994_PERSONAL_FLAG');
1413: hr_utility.raise_error;
1414: end if;
1415: else
1416: if p_contact_type in ('P','C','S') and

Line 1413: hr_utility.raise_error;

1409: if p_contact_type=hr_api.g_varchar2 then
1410: if l_contact_type in ('P','C','S') and
1411: p_personal_flag <> 'Y' then
1412: hr_utility.set_message(800,'PER_6994_PERSONAL_FLAG');
1413: hr_utility.raise_error;
1414: end if;
1415: else
1416: if p_contact_type in ('P','C','S') and
1417: p_personal_flag <> 'Y' then

Line 1418: hr_utility.set_message(800,'PER_6994_PERSONAL_FLAG');

1414: end if;
1415: else
1416: if p_contact_type in ('P','C','S') and
1417: p_personal_flag <> 'Y' then
1418: hr_utility.set_message(800,'PER_6994_PERSONAL_FLAG');
1419: hr_utility.raise_error;
1420: end if;
1421: end if;
1422: end if;

Line 1419: hr_utility.raise_error;

1415: else
1416: if p_contact_type in ('P','C','S') and
1417: p_personal_flag <> 'Y' then
1418: hr_utility.set_message(800,'PER_6994_PERSONAL_FLAG');
1419: hr_utility.raise_error;
1420: end if;
1421: end if;
1422: end if;
1423: -- end of code for bug2678841

Line 1517: hr_utility.set_location(' Leaving:'||l_proc, 100);

1513: if p_validate then
1514: raise hr_api.validate_enabled;
1515: end if;
1516: --
1517: hr_utility.set_location(' Leaving:'||l_proc, 100);
1518: exception
1519: when hr_api.validate_enabled then
1520: --
1521: -- As the Validate_Enabled exception has been raised

Line 1547: hr_utility.set_location(' Leaving:'||l_proc, 200);

1543: raise;
1544: --
1545: -- End of fix.
1546: --
1547: hr_utility.set_location(' Leaving:'||l_proc, 200);
1548: --
1549: end update_contact_relationship;
1550: --
1551: --

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

1604: l_contact_person_id number;
1605: l_contact_type varchar2(30);
1606: --
1607: begin
1608: hr_utility.set_location('Entering:'|| l_proc, 10);
1609: --
1610: -- Store initial values for IN OUT parameters
1611: --
1612: l_object_version_number := p_object_version_number;

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

1614: -- Issue a savepoint.
1615: --
1616: savepoint delete_contact_relationship;
1617: --
1618: hr_utility.set_location(l_proc, 20);
1619: --
1620: begin
1621: --
1622: -- Start of API User Hook for the before hook of delete_contact_relationship

Line 1643: hr_utility.set_location('Contact person id is: ',l_contact_person_id);

1639: --
1640: open csr_contact_person;
1641: fetch csr_contact_person into l_contact_person_id,l_contact_type;
1642: close csr_contact_person;
1643: hr_utility.set_location('Contact person id is: ',l_contact_person_id);
1644: --
1645: -- If Relationship has a mirror row then then we have to delete the mirror rel.
1646: -- Have to do this first otherwise the cursor will always fail.
1647: -- start of code for bug 2742210

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

1671: ,p_contact_relationship_id => p_contact_relationship_id
1672: ,p_object_version_number => p_object_version_number
1673: );
1674: --
1675: hr_utility.set_location(l_proc, 30);
1676: --
1677: --Added following for bug 2017198
1678: --
1679: --

Line 1683: hr_utility.set_location(l_proc, 31);

1679: --
1680: if (hr_contact_relationships.contact_only(l_contact_person_id) = 'Y'
1681: and hr_contact_relationships.multiple_contacts(l_contact_person_id) = 'N') then
1682: --
1683: hr_utility.set_location(l_proc, 31);
1684: --
1685: per_contact_relationships_pkg.delete_validation
1686: (l_contact_person_id
1687: ,p_contact_relationship_id

Line 1697: hr_utility.set_location(l_proc, 32);

1693: into l_per_object_version_number
1694: ,l_effective_date;
1695: close csr_person_details;
1696: --
1697: hr_utility.set_location(l_proc, 32);
1698: --
1699: per_per_del.del(p_person_id => l_contact_person_id
1700: ,p_effective_start_date => l_effective_start_date
1701: ,p_effective_end_date => l_effective_end_date

Line 1710: hr_utility.set_location(l_proc, 35);

1706: );
1707: end if;
1708: -- 2017198 end
1709: --
1710: hr_utility.set_location(l_proc, 35);
1711: --
1712: begin
1713: --
1714: -- Start of API User Hook for the after hook of delete_contact_relationship

Line 1737: hr_utility.set_location(' Leaving:'||l_proc, 100);

1733: if p_validate then
1734: raise hr_api.validate_enabled;
1735: end if;
1736: --
1737: hr_utility.set_location(' Leaving:'||l_proc, 100);
1738: exception
1739: when hr_api.validate_enabled then
1740: --
1741: -- As the Validate_Enabled exception has been raised

Line 1758: hr_utility.set_location(' Leaving:'||l_proc, 200);

1754: raise;
1755: --
1756: -- End of fix.
1757: --
1758: hr_utility.set_location(' Leaving:'||l_proc, 200);
1759: end delete_contact_relationship;
1760: --
1761: end hr_contact_rel_api;