42: hr_utility.set_location('Entering:'|| l_proc, 10);
43: --
44: -- Ensure that all the mandatory parameter are not null
45: --
46: hr_api.mandatory_arg_error
47: (p_api_name => l_proc
48: ,p_argument => 'prsi_details_id'
49: ,p_argument_value => p_prsi_details_id
50: );
65: close csr_sec_grp;
66: --
67: -- Set the security_group_id in CLIENT_INFO
68: --
69: hr_api.set_security_group_id
70: (p_security_group_id => l_security_group_id
71: );
72: --
73: hr_utility.set_location(' Leaving:'|| l_proc, 20);
104: hr_utility.set_location('Entering:'|| l_proc, 10);
105: --
106: -- Ensure that all the mandatory parameter are not null
107: --
108: hr_api.mandatory_arg_error
109: (p_api_name => l_proc
110: ,p_argument => 'prsi_details_id'
111: ,p_argument_value => p_prsi_details_id
112: );
110: ,p_argument => 'prsi_details_id'
111: ,p_argument_value => p_prsi_details_id
112: );
113: --
114: if ( nvl(pay_sid_bus.g_prsi_details_id, hr_api.g_number)
115: = p_prsi_details_id) then
116: --
117: -- The legislation code has already been found with a previous
118: -- call to this function. Just return the value in the global
201: fnd_message.raise_error;
202: END IF;
203: --
204: --
205: IF nvl(p_rec.assignment_id, hr_api.g_number) <>
206: nvl(pay_ipd_shd.g_old_rec.assignment_id, hr_api.g_number) THEN
207: l_argument := 'assignment_id';
208: END IF;
209: --
202: END IF;
203: --
204: --
205: IF nvl(p_rec.assignment_id, hr_api.g_number) <>
206: nvl(pay_ipd_shd.g_old_rec.assignment_id, hr_api.g_number) THEN
207: l_argument := 'assignment_id';
208: END IF;
209: --
210: EXCEPTION
208: END IF;
209: --
210: EXCEPTION
211: WHEN l_error THEN
212: hr_api.argument_changed_error
213: (p_api_name => l_proc
214: ,p_argument => l_argument);
215: WHEN OTHERS THEN
216: RAISE;
837: --
838: -- {End Of Comments}
839: -- ----------------------------------------------------------------------------
840: Procedure dt_update_validate
841: (p_assignment_id in number default hr_api.g_number
842: ,p_datetrack_mode in varchar2
843: ,p_validation_start_date in date
844: ,p_validation_end_date in date
845: ) Is
851: Begin
852: --
853: -- Ensure that the p_datetrack_mode argument is not null
854: --
855: hr_api.mandatory_arg_error
856: (p_api_name => l_proc
857: ,p_argument => 'datetrack_mode'
858: ,p_argument_value => p_datetrack_mode
859: );
861: -- Mode will be valid, as this is checked at the start of the upd.
862: --
863: -- Ensure the arguments are not null
864: --
865: hr_api.mandatory_arg_error
866: (p_api_name => l_proc
867: ,p_argument => 'validation_start_date'
868: ,p_argument_value => p_validation_start_date
869: );
867: ,p_argument => 'validation_start_date'
868: ,p_argument_value => p_validation_start_date
869: );
870: --
871: hr_api.mandatory_arg_error
872: (p_api_name => l_proc
873: ,p_argument => 'validation_end_date'
874: ,p_argument_value => p_validation_end_date
875: );
873: ,p_argument => 'validation_end_date'
874: ,p_argument_value => p_validation_end_date
875: );
876: --
877: If ((nvl(p_assignment_id, hr_api.g_number) <> hr_api.g_number) and
878: NOT (dt_api.check_min_max_dates
879: (p_base_table_name => 'per_all_assignments_f'
880: ,p_base_key_column => 'ASSIGNMENT_ID'
881: ,p_base_key_value => p_assignment_id
954: Begin
955: --
956: -- Ensure that the p_datetrack_mode argument is not null
957: --
958: hr_api.mandatory_arg_error
959: (p_api_name => l_proc
960: ,p_argument => 'datetrack_mode'
961: ,p_argument_value => p_datetrack_mode
962: );
963: --
964: -- Only perform the validation if the datetrack mode is either
965: -- DELETE or ZAP
966: --
967: If (p_datetrack_mode = hr_api.g_delete or
968: p_datetrack_mode = hr_api.g_zap) then
969: --
970: --
971: -- Ensure the arguments are not null
964: -- Only perform the validation if the datetrack mode is either
965: -- DELETE or ZAP
966: --
967: If (p_datetrack_mode = hr_api.g_delete or
968: p_datetrack_mode = hr_api.g_zap) then
969: --
970: --
971: -- Ensure the arguments are not null
972: --
969: --
970: --
971: -- Ensure the arguments are not null
972: --
973: hr_api.mandatory_arg_error
974: (p_api_name => l_proc
975: ,p_argument => 'validation_start_date'
976: ,p_argument_value => p_validation_start_date
977: );
975: ,p_argument => 'validation_start_date'
976: ,p_argument_value => p_validation_start_date
977: );
978: --
979: hr_api.mandatory_arg_error
980: (p_api_name => l_proc
981: ,p_argument => 'validation_end_date'
982: ,p_argument_value => p_validation_end_date
983: );
981: ,p_argument => 'validation_end_date'
982: ,p_argument_value => p_validation_end_date
983: );
984: --
985: hr_api.mandatory_arg_error
986: (p_api_name => l_proc
987: ,p_argument => 'prsi_details_id'
988: ,p_argument_value => p_prsi_details_id
989: );