DBA Data[Home] [Help]

APPS.PAY_RETRO_STATUS_LOAD dependencies on HR_UTILITY

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

20: l_retro_assignment_id number;
21: l_retro_entry_rec t_retro_entry_rec;
22: l_idx binary_integer;
23: begin
24: hr_utility.set_location('Entering:'|| l_proc, 10);
25: --
26: -- Issue a savepoint
27: --
28: savepoint load_retro_asg_and_entries;

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

64: -- Set out variables
65: --
66: p_retro_assignment_id := l_retro_assignment_id;
67:
68: hr_utility.set_location(' Leaving:'||l_proc, 80);
69: exception
70: when others then
71: --
72: -- A validation or unexpected error has occured

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

71: --
72: -- A validation or unexpected error has occured
73: --
74: rollback to load_retro_asg_and_entries;
75: hr_utility.set_location(' Leaving:'||l_proc, 90);
76: raise;
77: end load_retro_asg_and_entries;
78: --
79: -- ----------------------------------------------------------------------------

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

143: l_retro_component_id number;
144: l_rec t_retro_entry_rec;
145: l_leg_code varchar2(5);
146: begin
147: hr_utility.set_location('Entering:'|| l_proc, 10);
148: --
149: -- If element_name and element_entry_id are both null, this record is ignored.
150: -- Setting values_set flag to False and exit immediately.
151: --

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

151: --
152: if (p_element_name is null)
153: and (p_element_entry_id is null) then
154: --
155: hr_utility.set_location(l_proc, 20);
156: p_values_set := false;
157: return;
158: end if;
159: --

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

156: p_values_set := false;
157: return;
158: end if;
159: --
160: hr_utility.set_location(l_proc, 30);
161: --
162: -- Identify element entry id.
163: --
164: l_leg_code := hr_api.return_legislation_code(p_business_group_id);

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

238: --
239: p_retro_entry_rec := l_rec;
240: p_values_set := true;
241:
242: hr_utility.set_location(' Leaving:'||l_proc, 80);
243: end get_retro_entry_rec;
244: --
245: -- ----------------------------------------------------------------------------
246: -- |-------------------------< get_retro_entry_tab >--------------------------|

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

332: l_retro_entry_tab t_retro_entry_tab;
333: l_values_set boolean;
334: l_idx number:= 0;
335: begin
336: hr_utility.set_location('Entering:'|| l_proc, 10);
337:
338: --
339: -- Entry 1
340: --

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

624: -- Set out variable.
625: --
626: p_retro_entry_tab := l_retro_entry_tab;
627:
628: hr_utility.set_location(' Leaving:'||l_proc, 80);
629: end get_retro_entry_tab;
630: --
631: -- ----------------------------------------------------------------------------
632: -- |----------------------< load_retro_asg_and_entries >----------------------|

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

720: l_retro_assignment_id number;
721: l_assignment_id number;
722: l_retro_entry_tab t_retro_entry_tab;
723: begin
724: hr_utility.set_location('Entering:'|| l_proc, 10);
725: --
726: -- Check mandatory parameters have been set
727: --
728: hr_api.mandatory_arg_error

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

851: -- Set out variables
852: --
853: p_retro_assignment_id := l_retro_assignment_id;
854:
855: hr_utility.set_location(' Leaving:'||l_proc, 80);
856: end load_retro_asg_and_entries;
857: --
858: -- ----------------------------------------------------------------------------
859: -- |----------------------< update_or_delete_retro_asg >----------------------|

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

871: l_retro_assignment_id number;
872: l_replaced_retro_asg_id number;
873: l_assignment_id number;
874: begin
875: hr_utility.set_location('Entering:'|| l_proc, 10);
876: --
877: --
878: -- Check mandatory parameters have been set
879: --

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

940: pay_core_utils.assert_condition
941: (l_proc||':chk_update_or_delete_mode' ,false);
942: end if;
943:
944: hr_utility.set_location(' Leaving:'||l_proc, 80);
945: end update_or_delete_retro_asg;
946: --
947: procedure update_reprocess_date(
948: p_business_group_id in number

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

956: l_proc varchar2(72) := g_package||'update_reprocess_date';
957: l_assignment_id number;
958:
959: begin
960: hr_utility.set_location('Entering : '|| l_proc, 10);
961: --
962: -- Check mandatory parameters have been set
963: --
964: hr_utility.set_location('Checking mandatory argument business_group_id : '|| l_proc, 15);

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

960: hr_utility.set_location('Entering : '|| l_proc, 10);
961: --
962: -- Check mandatory parameters have been set
963: --
964: hr_utility.set_location('Checking mandatory argument business_group_id : '|| l_proc, 15);
965: hr_api.mandatory_arg_error
966: (p_api_name => l_proc
967: ,p_argument => 'business_group_id'
968: ,p_argument_value => p_business_group_id

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

967: ,p_argument => 'business_group_id'
968: ,p_argument_value => p_business_group_id
969: );
970:
971: hr_utility.set_location('Checking mandatory argument assignment_number : '|| l_proc, 20);
972: hr_api.mandatory_arg_error
973: (p_api_name => l_proc
974: ,p_argument => 'assignment_number'
975: ,p_argument_value => p_assignment_number

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

973: (p_api_name => l_proc
974: ,p_argument => 'assignment_number'
975: ,p_argument_value => p_assignment_number
976: );
977: hr_utility.set_location('Checking mandatory argument reprocess_date : '|| l_proc, 30);
978: hr_api.mandatory_arg_error
979: (p_api_name => l_proc
980: ,p_argument => 'reprocess_date'
981: ,p_argument_value => p_reprocess_date

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

983:
984: --
985: -- Validate business group.
986: --
987: hr_utility.set_location('Validating business group : '|| l_proc, 40);
988: hr_api.validate_bus_grp_id
989: (p_business_group_id => p_business_group_id
990: );
991: --

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

990: );
991: --
992: -- Get assignment id.
993: --
994: hr_utility.set_location('Getting assignment id : '|| l_proc, 50);
995: l_assignment_id := get_assignment_id
996: (p_business_group_id => p_business_group_id
997: ,p_assignment_number => p_assignment_number
998: ,p_full_name => p_full_name

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

997: ,p_assignment_number => p_assignment_number
998: ,p_full_name => p_full_name
999: );
1000:
1001: hr_utility.set_location('Calling pay_retro_status_internal.update_reprocess_date : '|| l_proc, 60);
1002: pay_retro_status_internal.update_reprocess_date(
1003: p_assignment_id => l_assignment_id
1004: ,p_reprocess_date => p_reprocess_date
1005: ,p_retro_asg_id => p_new_retro_asg_id);

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

1003: p_assignment_id => l_assignment_id
1004: ,p_reprocess_date => p_reprocess_date
1005: ,p_retro_asg_id => p_new_retro_asg_id);
1006:
1007: hr_utility.set_location('Leaving:'|| l_proc, 100);
1008:
1009: end update_reprocess_date;
1010: --
1011: end pay_retro_status_load;