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 1385: hr_utility.set_location('id '||l_mirror_rec.contact_relationship_id, 7);

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

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

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

Line 1412: hr_utility.raise_error;

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

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

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

Line 1418: hr_utility.raise_error;

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

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

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

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

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

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

1597: l_contact_person_id number;
1598: l_contact_type varchar2(30);
1599: --
1600: begin
1601: hr_utility.set_location('Entering:'|| l_proc, 10);
1602: --
1603: -- Store initial values for IN OUT parameters
1604: --
1605: l_object_version_number := p_object_version_number;

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

1607: -- Issue a savepoint.
1608: --
1609: savepoint delete_contact_relationship;
1610: --
1611: hr_utility.set_location(l_proc, 20);
1612: --
1613: begin
1614: --
1615: -- Start of API User Hook for the before hook of delete_contact_relationship

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

1632: --
1633: open csr_contact_person;
1634: fetch csr_contact_person into l_contact_person_id,l_contact_type;
1635: close csr_contact_person;
1636: hr_utility.set_location('Contact person id is: ',l_contact_person_id);
1637: --
1638: -- If Relationship has a mirror row then then we have to delete the mirror rel.
1639: -- Have to do this first otherwise the cursor will always fail.
1640: -- start of code for bug 2742210

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

1664: ,p_contact_relationship_id => p_contact_relationship_id
1665: ,p_object_version_number => p_object_version_number
1666: );
1667: --
1668: hr_utility.set_location(l_proc, 30);
1669: --
1670: --Added following for bug 2017198
1671: --
1672: --

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

1672: --
1673: if (hr_contact_relationships.contact_only(l_contact_person_id) = 'Y'
1674: and hr_contact_relationships.multiple_contacts(l_contact_person_id) = 'N') then
1675: --
1676: hr_utility.set_location(l_proc, 31);
1677: --
1678: per_contact_relationships_pkg.delete_validation
1679: (l_contact_person_id
1680: ,p_contact_relationship_id

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

1686: into l_per_object_version_number
1687: ,l_effective_date;
1688: close csr_person_details;
1689: --
1690: hr_utility.set_location(l_proc, 32);
1691: --
1692: per_per_del.del(p_person_id => l_contact_person_id
1693: ,p_effective_start_date => l_effective_start_date
1694: ,p_effective_end_date => l_effective_end_date

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

1699: );
1700: end if;
1701: -- 2017198 end
1702: --
1703: hr_utility.set_location(l_proc, 35);
1704: --
1705: begin
1706: --
1707: -- Start of API User Hook for the after hook of delete_contact_relationship

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

1726: if p_validate then
1727: raise hr_api.validate_enabled;
1728: end if;
1729: --
1730: hr_utility.set_location(' Leaving:'||l_proc, 100);
1731: exception
1732: when hr_api.validate_enabled then
1733: --
1734: -- As the Validate_Enabled exception has been raised

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

1747: raise;
1748: --
1749: -- End of fix.
1750: --
1751: hr_utility.set_location(' Leaving:'||l_proc, 200);
1752: end delete_contact_relationship;
1753: --
1754: end hr_contact_rel_api;