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

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

59: l_object_version_number number;
60: l_phone_id number;
61: --
62: begin
63: hr_utility.set_location('Entering:'|| l_proc, 5);
64: --
65: -- Issue a savepoint.
66: --
67: savepoint create_phone;

Line 69: hr_utility.set_location(l_proc, 7);

65: -- Issue a savepoint.
66: --
67: savepoint create_phone;
68: --
69: hr_utility.set_location(l_proc, 7);
70: --
71: -- Process Logic
72: --
73: --

Line 174: hr_utility.set_location(l_proc, 8);

170: ,p_party_id => p_party_id -- HR/TCA merge
171: ,p_validity => p_validity
172: );
173: --
174: hr_utility.set_location(l_proc, 8);
175: --
176: -- Start of API User Hook for the after hook of create_phone
177: --
178: -- Start of Fix for Bug 2396117

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

242: --
243: p_object_version_number := l_object_version_number;
244: p_phone_id := l_phone_id;
245: --
246: hr_utility.set_location(' Leaving:'||l_proc, 11);
247: exception
248: when hr_api.validate_enabled then
249: --
250: -- As the Validate_Enabled exception has been raised

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

333: l_proc varchar2(72) := g_package||'update_phone';
334: l_temp_ovn number := p_object_version_number;
335: --
336: begin
337: hr_utility.set_location('Entering:'|| l_proc, 5);
338: --
339: -- Issue a savepoint.
340: --
341: savepoint update_phone;

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

338: --
339: -- Issue a savepoint.
340: --
341: savepoint update_phone;
342: hr_utility.set_location(l_proc, 6);
343: --
344: l_object_version_number_temp := p_object_version_number;
345: l_object_version_number := p_object_version_number;
346: --

Line 447: hr_utility.set_location(l_proc, 8);

443: ,p_party_id => p_party_id
444: ,p_validity => p_validity
445: );
446: --
447: hr_utility.set_location(l_proc, 8);
448: --
449: -- Start of API User Hook for the after hook of update_phone
450: -- Start of Fix for Bug 2396117
451: --

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

509: raise hr_api.validate_enabled;
510: end if;
511: --
512: p_object_version_number := l_object_version_number;
513: hr_utility.set_location(' Leaving:'||l_proc, 11);
514: exception
515: when hr_api.validate_enabled then
516: --
517: -- As the Validate_Enabled exception has been raised

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

551: --
552: l_proc varchar2(72) := g_package||'delete_phone';
553: --
554: begin
555: hr_utility.set_location('Entering:'|| l_proc, 5);
556: --
557: -- Issue a savepoint.
558: --
559: savepoint delete_phone;

Line 561: hr_utility.set_location(l_proc, 7);

557: -- Issue a savepoint.
558: --
559: savepoint delete_phone;
560: --
561: hr_utility.set_location(l_proc, 7);
562: --
563: -- Process Logic
564: --
565: --

Line 589: hr_utility.set_location(l_proc, 8);

585: (p_phone_id => p_phone_id
586: ,p_object_version_number => p_object_version_number
587: ,p_validate => false);
588: --
589: hr_utility.set_location(l_proc, 8);
590: --
591: -- Start of API User Hook for the after hook of delete_phone
592: -- Start of Fix for Bug 2396117
593: --

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

613: if p_validate then
614: raise hr_api.validate_enabled;
615: end if;
616: --
617: hr_utility.set_location(' Leaving:'||l_proc, 11);
618: exception
619: when hr_api.validate_enabled then
620: --
621: -- As the Validate_Enabled exception has been raised

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

695: l_effective_date date;
696: --
697: begin
698: --
699: hr_utility.set_location('Entering:'|| l_proc, 10);
700: --
701: savepoint create_or_update_phone;
702: --
703: l_update_mode:=p_update_mode;

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

704: l_effective_date:=trunc(p_effective_date);
705: l_api_updating := per_phn_shd.api_updating
706: (p_phone_id => p_phone_id
707: ,p_object_version_number => p_object_version_number);
708: hr_utility.set_location(l_proc, 20);
709: --
710: -- set the record
711: --
712: l_phn_rec:=

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

757: --
758: -- set g_old_rec to null
759: --
760: per_phn_shd.g_old_rec:=l_null_phn_rec;
761: hr_utility.set_location(l_proc, 30);
762: --
763: -- convert the null values
764: --
765: hr_utility.set_location(l_proc, 40);

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

761: hr_utility.set_location(l_proc, 30);
762: --
763: -- convert the null values
764: --
765: hr_utility.set_location(l_proc, 40);
766: per_phn_upd.convert_defs(l_phn_rec);
767: --
768: -- insert the data
769: --

Line 770: hr_utility.set_location(l_proc||l_phn_rec.parent_id, 50);

766: per_phn_upd.convert_defs(l_phn_rec);
767: --
768: -- insert the data
769: --
770: hr_utility.set_location(l_proc||l_phn_rec.parent_id, 50);
771: hr_phone_api.create_phone
772: (p_date_from => l_phn_rec.date_from
773: ,p_date_to => l_phn_rec.date_to
774: ,p_phone_type => l_phn_rec.phone_type

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

812: ,p_phone_id => l_phn_rec.phone_id
813: ,p_party_id => l_phn_rec.party_id -- HR/TCA merge
814: ,p_validity => l_phn_rec.validity
815: );
816: hr_utility.set_location(l_proc, 60);
817: else
818: hr_utility.set_location(l_proc, 70);
819: --
820: -- updating not inserting

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

814: ,p_validity => l_phn_rec.validity
815: );
816: hr_utility.set_location(l_proc, 60);
817: else
818: hr_utility.set_location(l_proc, 70);
819: --
820: -- updating not inserting
821: --
822: -- Validating update_mode values

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

820: -- updating not inserting
821: --
822: -- Validating update_mode values
823: if (l_update_mode not in (hr_api.g_update,hr_api.g_correction)) then
824: hr_utility.set_location(l_proc, 80);
825: hr_utility.set_message(800, 'HR_52858_PHN_CHK_MODE');
826: hr_utility.raise_error;
827: end if;
828: hr_utility.set_location(l_proc, 90);

Line 825: hr_utility.set_message(800, 'HR_52858_PHN_CHK_MODE');

821: --
822: -- Validating update_mode values
823: if (l_update_mode not in (hr_api.g_update,hr_api.g_correction)) then
824: hr_utility.set_location(l_proc, 80);
825: hr_utility.set_message(800, 'HR_52858_PHN_CHK_MODE');
826: hr_utility.raise_error;
827: end if;
828: hr_utility.set_location(l_proc, 90);
829: --

Line 826: hr_utility.raise_error;

822: -- Validating update_mode values
823: if (l_update_mode not in (hr_api.g_update,hr_api.g_correction)) then
824: hr_utility.set_location(l_proc, 80);
825: hr_utility.set_message(800, 'HR_52858_PHN_CHK_MODE');
826: hr_utility.raise_error;
827: end if;
828: hr_utility.set_location(l_proc, 90);
829: --
830: -- Validating effective_date

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

824: hr_utility.set_location(l_proc, 80);
825: hr_utility.set_message(800, 'HR_52858_PHN_CHK_MODE');
826: hr_utility.raise_error;
827: end if;
828: hr_utility.set_location(l_proc, 90);
829: --
830: -- Validating effective_date
831: --
832: if ((p_date_to <> hr_api.g_date) AND ( l_effective_date > p_date_to ))

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

831: --
832: if ((p_date_to <> hr_api.g_date) AND ( l_effective_date > p_date_to ))
833: or ((p_date_from <> hr_api.g_date) AND ( l_effective_date < p_date_from ))
834: then
835: hr_utility.set_location(l_proc, 100);
836: hr_utility.set_message(800, 'HR_52859_PHN_INVALID_EFF_DATE');
837: hr_utility.raise_error;
838: end if;
839: hr_utility.set_location(l_proc, 110);

Line 836: hr_utility.set_message(800, 'HR_52859_PHN_INVALID_EFF_DATE');

832: if ((p_date_to <> hr_api.g_date) AND ( l_effective_date > p_date_to ))
833: or ((p_date_from <> hr_api.g_date) AND ( l_effective_date < p_date_from ))
834: then
835: hr_utility.set_location(l_proc, 100);
836: hr_utility.set_message(800, 'HR_52859_PHN_INVALID_EFF_DATE');
837: hr_utility.raise_error;
838: end if;
839: hr_utility.set_location(l_proc, 110);
840: --

Line 837: hr_utility.raise_error;

833: or ((p_date_from <> hr_api.g_date) AND ( l_effective_date < p_date_from ))
834: then
835: hr_utility.set_location(l_proc, 100);
836: hr_utility.set_message(800, 'HR_52859_PHN_INVALID_EFF_DATE');
837: hr_utility.raise_error;
838: end if;
839: hr_utility.set_location(l_proc, 110);
840: --
841: per_phn_shd.lck

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

835: hr_utility.set_location(l_proc, 100);
836: hr_utility.set_message(800, 'HR_52859_PHN_INVALID_EFF_DATE');
837: hr_utility.raise_error;
838: end if;
839: hr_utility.set_location(l_proc, 110);
840: --
841: per_phn_shd.lck
842: (p_phone_id => p_phone_id
843: ,p_object_version_number => p_object_version_number);

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

843: ,p_object_version_number => p_object_version_number);
844: --
845: -- convert the null values
846: --
847: hr_utility.set_location(l_proc, 130);
848: per_phn_upd.convert_defs(l_phn_rec);
849: --
850: -- check to see if the start date hasn't changed and is equal to the
851: -- effective date. This will always be a correction.

Line 864: hr_utility.set_location(l_proc, 140);

860: if l_update_mode = hr_api.g_correction then
861: --
862: -- correct the data
863: --
864: hr_utility.set_location(l_proc, 140);
865: --
866: hr_phone_api.update_phone
867: (p_date_from => l_phn_rec.date_from
868: ,p_date_to => l_phn_rec.date_to

Line 909: hr_utility.set_location(l_proc, 150);

905: ,p_phone_id => l_phn_rec.phone_id
906: ,p_validity => l_phn_rec.validity
907: );
908: --
909: hr_utility.set_location(l_proc, 150);
910: --
911: else
912: --
913: -- update mode

Line 915: hr_utility.set_location(l_proc, 160);

911: else
912: --
913: -- update mode
914: --
915: hr_utility.set_location(l_proc, 160);
916: --
917: -- if the start date has changed and it is not the effective date then
918: -- we have an error. A change of start date is the new start date for
919: -- the new record, so must be the effective date so that the phone numbers

Line 924: hr_utility.set_location(l_proc, 170);

920: -- are continuous.
921: --
922: if per_phn_shd.g_old_rec.date_from <> l_phn_rec.date_from
923: and l_phn_rec.date_from <> l_effective_date then
924: hr_utility.set_location(l_proc, 170);
925: hr_utility.set_message(800, 'HR_52859_PHN_INVALID_EFF_DATE');
926: hr_utility.raise_error;
927: end if;
928: --

Line 925: hr_utility.set_message(800, 'HR_52859_PHN_INVALID_EFF_DATE');

921: --
922: if per_phn_shd.g_old_rec.date_from <> l_phn_rec.date_from
923: and l_phn_rec.date_from <> l_effective_date then
924: hr_utility.set_location(l_proc, 170);
925: hr_utility.set_message(800, 'HR_52859_PHN_INVALID_EFF_DATE');
926: hr_utility.raise_error;
927: end if;
928: --
929: hr_utility.set_location(l_proc, 180);

Line 926: hr_utility.raise_error;

922: if per_phn_shd.g_old_rec.date_from <> l_phn_rec.date_from
923: and l_phn_rec.date_from <> l_effective_date then
924: hr_utility.set_location(l_proc, 170);
925: hr_utility.set_message(800, 'HR_52859_PHN_INVALID_EFF_DATE');
926: hr_utility.raise_error;
927: end if;
928: --
929: hr_utility.set_location(l_proc, 180);
930: --

Line 929: hr_utility.set_location(l_proc, 180);

925: hr_utility.set_message(800, 'HR_52859_PHN_INVALID_EFF_DATE');
926: hr_utility.raise_error;
927: end if;
928: --
929: hr_utility.set_location(l_proc, 180);
930: --
931: -- end the old phone number
932: --
933: hr_phone_api.update_phone

Line 940: hr_utility.set_location(l_proc, 190);

936: ,p_object_version_number => l_phn_rec.object_version_number
937: ,p_validate => FALSE
938: ,p_effective_date => l_effective_date);
939: --
940: hr_utility.set_location(l_proc, 190);
941: --
942: -- insert the new phone number
943: --
944: hr_phone_api.create_phone

Line 990: hr_utility.set_location(l_proc, 190);

986: ,p_party_id => l_phn_rec.party_id -- HR/TCA merge
987: ,p_validity => l_phn_rec.validity
988: );
989: --
990: hr_utility.set_location(l_proc, 190);
991: --
992: end if;
993: end if;
994: --

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

997: end if;
998: --
999: p_phone_id:=l_phn_rec.phone_id;
1000: p_object_version_number:=l_phn_rec.object_version_number;
1001: hr_utility.set_location('Leaving:'||l_proc, 200);
1002: --
1003: exception
1004: when hr_api.validate_enabled then
1005: rollback to create_or_update_phone;

Line 1008: hr_utility.set_location('Leaving:'||l_proc, 220);

1004: when hr_api.validate_enabled then
1005: rollback to create_or_update_phone;
1006: p_phone_id:=null;
1007: p_object_version_number:=null;
1008: hr_utility.set_location('Leaving:'||l_proc, 220);
1009: --
1010: when others then
1011: rollback to create_or_update_phone;
1012: hr_utility.set_location('Leaving:'||l_proc, 230);

Line 1012: hr_utility.set_location('Leaving:'||l_proc, 230);

1008: hr_utility.set_location('Leaving:'||l_proc, 220);
1009: --
1010: when others then
1011: rollback to create_or_update_phone;
1012: hr_utility.set_location('Leaving:'||l_proc, 230);
1013: raise;
1014: --
1015: end create_or_update_phone;
1016: --