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 876: hr_utility.set_location('Entering:'|| l_proc, 10);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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