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 364: hr_utility.set_location('Entering: call - create_spinal_point_placement_a', 50);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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