DBA Data[Home] [Help]

APPS.PAY_RETRO_STATUS_LOAD_API dependencies on HR_UTILITY

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

35: l_retro_assignment_id number;
36: l_retro_entry_rec t_retro_entry_rec;
37: l_idx binary_integer;
38: begin
39: hr_utility.set_location('Entering:'|| l_proc, 10);
40: --
41: -- Issue a savepoint
42: --
43: savepoint load_retro_asg_and_entries;

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

79: -- Set out variables
80: --
81: p_retro_assignment_id := l_retro_assignment_id;
82:
83: hr_utility.set_location(' Leaving:'||l_proc, 80);
84: exception
85: when others then
86: --
87: -- A validation or unexpected error has occured

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

86: --
87: -- A validation or unexpected error has occured
88: --
89: rollback to load_retro_asg_and_entries;
90: hr_utility.set_location(' Leaving:'||l_proc, 90);
91: raise;
92: end create_retro_asg_and_entries;
93: --
94: -- ----------------------------------------------------------------------------

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

158: l_retro_component_id number;
159: l_rec t_retro_entry_rec;
160: l_leg_code varchar2(5);
161: begin
162: hr_utility.set_location('Entering:'|| l_proc, 10);
163: --
164: -- If element_name and element_entry_id are both null, this record is ignored.
165: -- Setting values_set flag to False and exit immediately.
166: --

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

166: --
167: if (p_element_name is null)
168: and (p_element_entry_id is null) then
169: --
170: hr_utility.set_location(l_proc, 20);
171: p_values_set := false;
172: return;
173: end if;
174: --

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

171: p_values_set := false;
172: return;
173: end if;
174: --
175: hr_utility.set_location(l_proc, 30);
176: --
177: -- Identify element entry id.
178: --
179: l_leg_code := hr_api.return_legislation_code(p_business_group_id);

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

253: --
254: p_retro_entry_rec := l_rec;
255: p_values_set := true;
256:
257: hr_utility.set_location(' Leaving:'||l_proc, 80);
258: end get_retro_entry_rec;
259: --
260: -- ----------------------------------------------------------------------------
261: -- |-------------------------< get_retro_entry_tab >--------------------------|

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

347: l_retro_entry_tab t_retro_entry_tab;
348: l_values_set boolean;
349: l_idx number:= 0;
350: begin
351: hr_utility.set_location('Entering:'|| l_proc, 10);
352:
353: --
354: -- Entry 1
355: --

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

639: -- Set out variable.
640: --
641: p_retro_entry_tab := l_retro_entry_tab;
642:
643: hr_utility.set_location(' Leaving:'||l_proc, 80);
644: end get_retro_entry_tab;
645: --
646: -- ----------------------------------------------------------------------------
647: -- |----------------------< create_retro_asg_and_entries >----------------------|

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

735: l_retro_assignment_id number;
736: l_assignment_id number;
737: l_retro_entry_tab t_retro_entry_tab;
738: begin
739: hr_utility.set_location('Entering:'|| l_proc, 10);
740: --
741: -- Check mandatory parameters have been set
742: --
743: hr_api.mandatory_arg_error

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

866: -- Set out variables
867: --
868: p_retro_assignment_id := l_retro_assignment_id;
869:
870: hr_utility.set_location(' Leaving:'||l_proc, 80);
871: end create_retro_asg_and_entries;
872: --
873: -- ----------------------------------------------------------------------------
874: -- |----------------------< update_or_delete_retro_asg >----------------------|

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

886: l_retro_assignment_id number;
887: l_replaced_retro_asg_id number;
888: l_assignment_id number;
889: begin
890: hr_utility.set_location('Entering:'|| l_proc, 10);
891: --
892: --
893: -- Check mandatory parameters have been set
894: --

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

955: pay_core_utils.assert_condition
956: (l_proc||':chk_update_or_delete_mode' ,false);
957: end if;
958:
959: hr_utility.set_location(' Leaving:'||l_proc, 80);
960: end update_or_delete_retro_asg;
961: --
962: procedure update_reprocess_date(
963: p_business_group_id in number

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

971: l_proc varchar2(72) := g_package||'update_reprocess_date';
972: l_assignment_id number;
973:
974: begin
975: hr_utility.set_location('Entering : '|| l_proc, 10);
976: --
977: -- Check mandatory parameters have been set
978: --
979: hr_utility.set_location('Checking mandatory argument business_group_id : '|| l_proc, 15);

Line 979: hr_utility.set_location('Checking mandatory argument business_group_id : '|| l_proc, 15);

975: hr_utility.set_location('Entering : '|| l_proc, 10);
976: --
977: -- Check mandatory parameters have been set
978: --
979: hr_utility.set_location('Checking mandatory argument business_group_id : '|| l_proc, 15);
980: hr_api.mandatory_arg_error
981: (p_api_name => l_proc
982: ,p_argument => 'business_group_id'
983: ,p_argument_value => p_business_group_id

Line 986: hr_utility.set_location('Checking mandatory argument assignment_number : '|| l_proc, 20);

982: ,p_argument => 'business_group_id'
983: ,p_argument_value => p_business_group_id
984: );
985:
986: hr_utility.set_location('Checking mandatory argument assignment_number : '|| l_proc, 20);
987: hr_api.mandatory_arg_error
988: (p_api_name => l_proc
989: ,p_argument => 'assignment_number'
990: ,p_argument_value => p_assignment_number

Line 992: hr_utility.set_location('Checking mandatory argument reprocess_date : '|| l_proc, 30);

988: (p_api_name => l_proc
989: ,p_argument => 'assignment_number'
990: ,p_argument_value => p_assignment_number
991: );
992: hr_utility.set_location('Checking mandatory argument reprocess_date : '|| l_proc, 30);
993: hr_api.mandatory_arg_error
994: (p_api_name => l_proc
995: ,p_argument => 'reprocess_date'
996: ,p_argument_value => p_reprocess_date

Line 1002: hr_utility.set_location('Validating business group : '|| l_proc, 40);

998:
999: --
1000: -- Validate business group.
1001: --
1002: hr_utility.set_location('Validating business group : '|| l_proc, 40);
1003: hr_api.validate_bus_grp_id
1004: (p_business_group_id => p_business_group_id
1005: );
1006: --

Line 1009: hr_utility.set_location('Getting assignment id : '|| l_proc, 50);

1005: );
1006: --
1007: -- Get assignment id.
1008: --
1009: hr_utility.set_location('Getting assignment id : '|| l_proc, 50);
1010: l_assignment_id := get_assignment_id
1011: (p_business_group_id => p_business_group_id
1012: ,p_assignment_number => p_assignment_number
1013: ,p_full_name => p_full_name

Line 1016: hr_utility.set_location('Calling pay_retro_status_internal.update_reprocess_date : '|| l_proc, 60);

1012: ,p_assignment_number => p_assignment_number
1013: ,p_full_name => p_full_name
1014: );
1015:
1016: hr_utility.set_location('Calling pay_retro_status_internal.update_reprocess_date : '|| l_proc, 60);
1017: pay_retro_status_internal.update_reprocess_date(
1018: p_assignment_id => l_assignment_id
1019: ,p_reprocess_date => p_reprocess_date
1020: ,p_retro_asg_id => p_new_retro_asg_id);

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

1018: p_assignment_id => l_assignment_id
1019: ,p_reprocess_date => p_reprocess_date
1020: ,p_retro_asg_id => p_new_retro_asg_id);
1021:
1022: hr_utility.set_location('Leaving:'|| l_proc, 100);
1023:
1024: end update_reprocess_date;
1025: --
1026: end pay_retro_status_load_api;