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

Line 76: hr_utility.set_location('Entering:'|| l_proc, 12);

72: l_proc varchar2(72) := g_package||'create_spinal_point_placement';
73: --
74: begin
75:
76: hr_utility.set_location('Entering:'|| l_proc, 12);
77:
78: hr_sp_placement_api.create_spp
79: (p_validate => p_validate
80: ,p_effective_date => p_effective_date

Line 137: hr_utility.set_location(' Leaving:'||l_proc, 70);

133: p_object_version_number := l_object_version_number;
134: p_effective_start_date := l_effective_start_date;
135: p_effective_end_date := l_effective_end_date;
136: --
137: hr_utility.set_location(' Leaving:'||l_proc, 70);
138: end create_spp;
139: -- ----------------------------------------------------------------------------
140: -- |--------------------< create_spinal_point_placement OVERLOAD>-------------|
141: -- ----------------------------------------------------------------------------

Line 208: hr_utility.set_location('Entering:'|| l_proc, 12);

204: l_proc varchar2(72) := g_package||'create_spinal_point_placement';
205: --
206: begin
207:
208: hr_utility.set_location('Entering:'|| l_proc, 12);
209: hr_utility.set_location('Entering:'|| p_auto_increment_flag, 15);
210: --
211: -- Issue a savepoint
212: --

Line 209: hr_utility.set_location('Entering:'|| p_auto_increment_flag, 15);

205: --
206: begin
207:
208: hr_utility.set_location('Entering:'|| l_proc, 12);
209: hr_utility.set_location('Entering:'|| p_auto_increment_flag, 15);
210: --
211: -- Issue a savepoint
212: --
213: savepoint create_spinal_point_placement;

Line 217: hr_utility.set_location('Entering mandatory arg check', 20);

213: savepoint create_spinal_point_placement;
214: --
215: -- Check that all not null parameters have a variable passed in
216: --
217: hr_utility.set_location('Entering mandatory arg check', 20);
218: --
219: hr_api.mandatory_arg_error
220: (p_api_name => l_proc,
221: p_argument => 'assignment_id',

Line 253: hr_utility.set_location('Entering: call - create_spinal_point_placement_b ', 30);

249: */
250: --
251: l_effective_date := trunc(p_effective_date);
252: --
253: hr_utility.set_location('Entering: call - create_spinal_point_placement_b ', 30);
254: --
255:
256: begin
257:

Line 312: hr_utility.set_location('Entering: call - per_spp_ins.ins ', 40);

308:
309: end;
310:
311: --
312: hr_utility.set_location('Entering: call - per_spp_ins.ins ', 40);
313: --
314: per_spp_ins.ins
315: (p_effective_date => l_effective_date
316: ,p_business_group_id => p_business_group_id

Line 363: hr_utility.set_location('Entering: call - create_spinal_point_placement_a', 50);

359: ,p_information30 => p_information30
360: ,p_information_category => p_information_category
361: );
362: --
363: hr_utility.set_location('Entering: call - create_spinal_point_placement_a', 50);
364: --
365:
366: begin
367: hr_sp_placement_api_bk1.create_sp_placement_a

Line 449: hr_utility.set_location(' Leaving:'||l_proc, 70);

445: p_effective_start_date := l_effective_start_date;
446: p_effective_end_date := l_effective_end_date;
447: p_gsp_post_process_warning := l_gsp_post_process_warning;
448: --
449: hr_utility.set_location(' Leaving:'||l_proc, 70);
450: exception
451: when hr_api.validate_enabled then
452: --
453: -- As the Validate_Enabled exception has been raised

Line 468: hr_utility.set_location(' Leaving:'||l_proc, 80);

464: p_effective_start_date := null;
465: p_effective_end_date := null;
466: p_gsp_post_process_warning := null;
467: --
468: hr_utility.set_location(' Leaving:'||l_proc, 80);
469: when others then
470: --
471: -- A validation or unexpected error has occured
472: --

Line 479: hr_utility.set_location(' Leaving:'||l_proc, 90);

475: p_effective_start_date := null;
476: p_effective_end_date := null;
477: p_gsp_post_process_warning := null;
478: rollback to create_spinal_point_placement;
479: hr_utility.set_location(' Leaving:'||l_proc, 90);
480: raise;
481: end create_spp;
482: --
483:

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

562: --
563: l_proc varchar2(72) := g_package||'update_spinal_point_placement';
564: --
565: begin
566: hr_utility.set_location('Entering:'|| l_proc, 10);
567:
568: l_effective_date := trunc(p_effective_date);
569: l_effective_start_date := p_effective_start_date;
570: l_effective_end_date := p_effective_end_date;

Line 627: hr_utility.set_location(' Leaving:'||l_proc, 70);

623: p_effective_start_date := l_effective_start_date;
624: p_effective_end_date := l_effective_end_date;
625: p_object_version_number := l_object_version_number;
626:
627: hr_utility.set_location(' Leaving:'||l_proc, 70);
628: --
629: end update_spp;
630:
631: --

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

711: --
712: l_proc varchar2(72) := g_package||'update_spinal_point_placement';
713: --
714: begin
715: hr_utility.set_location('Entering:'|| l_proc, 10);
716: --
717: -- Issue a savepoint
718: --
719: savepoint update_spinal_point_placement;

Line 723: hr_utility.set_location('Entering mandatory arg check', 20);

719: savepoint update_spinal_point_placement;
720: --
721: -- Check that all required parameters are not null
722: --
723: hr_utility.set_location('Entering mandatory arg check', 20);
724: --
725: hr_api.mandatory_arg_error
726: (p_api_name => l_proc,
727: p_argument => 'placement_id',

Line 746: hr_utility.set_location('Entering: call - update_spinal_point_placement_b ', 30);

742: l_effective_end_date := p_effective_end_date;
743: l_object_version_number := p_object_version_number;
744: l_datetrack_mode := p_datetrack_mode;
745: --
746: hr_utility.set_location('Entering: call - update_spinal_point_placement_b ', 30);
747: hr_utility.set_location('Increment Number:'||p_increment_number,1);
748: hr_utility.set_location('Effective_date:'||l_effective_date,9);
749: hr_utility.set_location('EFFECTIVE_END_DATE : '||p_effective_end_date,9);
750: --

Line 747: hr_utility.set_location('Increment Number:'||p_increment_number,1);

743: l_object_version_number := p_object_version_number;
744: l_datetrack_mode := p_datetrack_mode;
745: --
746: hr_utility.set_location('Entering: call - update_spinal_point_placement_b ', 30);
747: hr_utility.set_location('Increment Number:'||p_increment_number,1);
748: hr_utility.set_location('Effective_date:'||l_effective_date,9);
749: hr_utility.set_location('EFFECTIVE_END_DATE : '||p_effective_end_date,9);
750: --
751:

Line 748: hr_utility.set_location('Effective_date:'||l_effective_date,9);

744: l_datetrack_mode := p_datetrack_mode;
745: --
746: hr_utility.set_location('Entering: call - update_spinal_point_placement_b ', 30);
747: hr_utility.set_location('Increment Number:'||p_increment_number,1);
748: hr_utility.set_location('Effective_date:'||l_effective_date,9);
749: hr_utility.set_location('EFFECTIVE_END_DATE : '||p_effective_end_date,9);
750: --
751:
752: --

Line 749: hr_utility.set_location('EFFECTIVE_END_DATE : '||p_effective_end_date,9);

745: --
746: hr_utility.set_location('Entering: call - update_spinal_point_placement_b ', 30);
747: hr_utility.set_location('Increment Number:'||p_increment_number,1);
748: hr_utility.set_location('Effective_date:'||l_effective_date,9);
749: hr_utility.set_location('EFFECTIVE_END_DATE : '||p_effective_end_date,9);
750: --
751:
752: --
753: -- Get the non passed parameters

Line 756: hr_utility.set_location(p_placement_id,33);

752: --
753: -- Get the non passed parameters
754: --
755:
756: hr_utility.set_location(p_placement_id,33);
757: --
758: hr_utility.set_location(l_proc,20);
759: select parent_spine_id, business_group_id, assignment_id
760: into l_parent_spine_id, l_business_group_id, l_assignment_id

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

754: --
755:
756: hr_utility.set_location(p_placement_id,33);
757: --
758: hr_utility.set_location(l_proc,20);
759: select parent_spine_id, business_group_id, assignment_id
760: into l_parent_spine_id, l_business_group_id, l_assignment_id
761: from per_spinal_point_placements_f
762: where placement_id = p_placement_id

Line 768: hr_utility.set_location(l_assignment_id,22);

764: and effective_end_date;
765: --
766: -- Call the user hook before update process
767: --
768: hr_utility.set_location(l_assignment_id,22);
769:
770: begin
771:
772: hr_sp_placement_api_bk2.update_sp_placement_b

Line 830: hr_utility.set_location(l_proc,21);

826: ,p_hook_type => 'BP'
827: );
828:
829: end;
830: hr_utility.set_location(l_proc,21);
831: hr_utility.set_location('Entering: call - per_spp_upd.upd ', 40);
832: --
833:
834: per_spp_upd.upd

Line 831: hr_utility.set_location('Entering: call - per_spp_upd.upd ', 40);

827: );
828:
829: end;
830: hr_utility.set_location(l_proc,21);
831: hr_utility.set_location('Entering: call - per_spp_upd.upd ', 40);
832: --
833:
834: per_spp_upd.upd
835: (p_effective_date => l_effective_date

Line 884: hr_utility.set_location('l_placement_id'||l_placement_id,52);

880: ,p_information_category => p_information_category
881: );
882:
883: --
884: hr_utility.set_location('l_placement_id'||l_placement_id,52);
885: --
886: p_effective_start_date := l_effective_start_date;
887: p_effective_end_date := l_effective_end_date;
888: p_object_version_number := l_object_version_number;

Line 891: hr_utility.set_location('p_effective_start_date'||p_effective_start_date,55);

887: p_effective_end_date := l_effective_end_date;
888: p_object_version_number := l_object_version_number;
889: -- p_datetrack_mode := l_datetrack_mode;
890: --
891: hr_utility.set_location('p_effective_start_date'||p_effective_start_date,55);
892: hr_utility.set_location('Entering: call - update_spinal_point_placement_a', 50);
893: --
894:
895: begin

Line 892: hr_utility.set_location('Entering: call - update_spinal_point_placement_a', 50);

888: p_object_version_number := l_object_version_number;
889: -- p_datetrack_mode := l_datetrack_mode;
890: --
891: hr_utility.set_location('p_effective_start_date'||p_effective_start_date,55);
892: hr_utility.set_location('Entering: call - update_spinal_point_placement_a', 50);
893: --
894:
895: begin
896: --

Line 956: hr_utility.set_location(' Leaving:'||l_proc, 60);

952: ,p_hook_type => 'AP'
953: );
954: end;
955:
956: hr_utility.set_location(' Leaving:'||l_proc, 60);
957:
958: --
959: -- call pqh post process procedure -- bug 2999562
960: --

Line 968: hr_utility.set_location(' Leaving:'||l_proc, 65);

964: ,p_date_track_mode => p_datetrack_mode
965: ,p_warning_mesg => l_gsp_post_process_warning
966: );
967:
968: hr_utility.set_location(' Leaving:'||l_proc, 65);
969:
970: --
971: -- When in validation only mode raise the Validate_Enabled exception
972: --

Line 981: hr_utility.set_location(' Leaving:'||l_proc, 70);

977: --
978: p_gsp_post_process_warning := l_gsp_post_process_warning;
979: --
980: --
981: hr_utility.set_location(' Leaving:'||l_proc, 70);
982: exception
983: when hr_api.validate_enabled then
984: --
985: -- As the Validate_Enabled exception has been raised

Line 996: hr_utility.set_location(' Leaving:'||l_proc, 80);

992: -- when validation only mode is being used.)
993: --
994: p_object_version_number := l_object_version_number;
995: --
996: hr_utility.set_location(' Leaving:'||l_proc, 80);
997: when others then
998: --
999: -- A validation or unexpected error has occured
1000: --

Line 1006: hr_utility.set_location(' Leaving:'||l_proc, 90);

1002: p_effective_start_date := l_effective_start_date_temp;
1003: p_effective_end_date := l_effective_end_date_temp;
1004: p_gsp_post_process_warning := l_gsp_post_process_warning;
1005: rollback to update_spinal_point_placement;
1006: hr_utility.set_location(' Leaving:'||l_proc, 90);
1007: raise;
1008: end update_spp;
1009: --
1010: -- ----------------------------------------------------------------------------

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

1041: (p_api_name => l_proc,
1042: p_argument => 'effective_date',
1043: p_argument_value => p_effective_date);
1044: --
1045: hr_utility.set_location('Entering:'|| l_proc, 10);
1046: --
1047: -- Issue a savepoint if operating in validation only mode
1048: --
1049: savepoint delete_spinal_point_placement;

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

1047: -- Issue a savepoint if operating in validation only mode
1048: --
1049: savepoint delete_spinal_point_placement;
1050: --
1051: hr_utility.set_location(l_proc, 20);
1052: --
1053: l_object_version_number := p_object_version_number;
1054: -- Process Logic
1055: --

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

1110: --
1111: end;
1112:
1113: --
1114: hr_utility.set_location(l_proc, 60);
1115: --
1116: -- When in validation only mode raise the Validate_Enabled exception
1117: --
1118: if p_validate then

Line 1122: hr_utility.set_location(' Leaving:'||l_proc, 70);

1118: if p_validate then
1119: raise hr_api.validate_enabled;
1120: end if;
1121: --
1122: hr_utility.set_location(' Leaving:'||l_proc, 70);
1123: --
1124: exception
1125: --
1126: when hr_api.validate_enabled then