50: p_vald_rlshp_for_reimb_id => p_vald_rlshp_for_reimb_id,
51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_vald_rlshp_for_reimb_id,hr_api.g_number)
55: <> ben_vrp_shd.g_old_rec.vald_rlshp_for_reimb_id) then
56: --
57: -- raise error as PK has changed
58: --
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_rlshp_typ_cd
124: <> nvl(ben_vrp_shd.g_old_rec.rlshp_typ_cd,hr_api.g_varchar2)
125: or not l_api_updating)
126: and p_rlshp_typ_cd is not null then
127: --
128: -- check if value of lookup falls within lookup type.
126: and p_rlshp_typ_cd is not null then
127: --
128: -- check if value of lookup falls within lookup type.
129: --
130: if hr_api.not_exists_in_hr_lookups
131: (p_lookup_type => 'CONTACT',
132: p_lookup_code => p_rlshp_typ_cd,
133: p_effective_date => p_effective_date) then
134: --
174: --
175: -- {End Of Comments}
176: -- ----------------------------------------------------------------------------
177: Procedure dt_update_validate
178: (p_pl_id in number default hr_api.g_number,
179: p_datetrack_mode in varchar2,
180: p_validation_start_date in date,
181: p_validation_end_date in date) Is
182: --
188: hr_utility.set_location('Entering:'||l_proc, 5);
189: --
190: -- Ensure that the p_datetrack_mode argument is not null
191: --
192: hr_api.mandatory_arg_error
193: (p_api_name => l_proc,
194: p_argument => 'datetrack_mode',
195: p_argument_value => p_datetrack_mode);
196: --
200: --
201: --
202: -- Ensure the arguments are not null
203: --
204: hr_api.mandatory_arg_error
205: (p_api_name => l_proc,
206: p_argument => 'validation_start_date',
207: p_argument_value => p_validation_start_date);
208: --
205: (p_api_name => l_proc,
206: p_argument => 'validation_start_date',
207: p_argument_value => p_validation_start_date);
208: --
209: hr_api.mandatory_arg_error
210: (p_api_name => l_proc,
211: p_argument => 'validation_end_date',
212: p_argument_value => p_validation_end_date);
213: --
210: (p_api_name => l_proc,
211: p_argument => 'validation_end_date',
212: p_argument_value => p_validation_end_date);
213: --
214: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
215: NOT (dt_api.check_min_max_dates
216: (p_base_table_name => 'ben_pl_f',
217: p_base_key_column => 'pl_id',
218: p_base_key_value => p_pl_id,
294: hr_utility.set_location('Entering:'||l_proc, 5);
295: --
296: -- Ensure that the p_datetrack_mode argument is not null
297: --
298: hr_api.mandatory_arg_error
299: (p_api_name => l_proc,
300: p_argument => 'datetrack_mode',
301: p_argument_value => p_datetrack_mode);
302: --
308: --
309: --
310: -- Ensure the arguments are not null
311: --
312: hr_api.mandatory_arg_error
313: (p_api_name => l_proc,
314: p_argument => 'validation_start_date',
315: p_argument_value => p_validation_start_date);
316: --
313: (p_api_name => l_proc,
314: p_argument => 'validation_start_date',
315: p_argument_value => p_validation_start_date);
316: --
317: hr_api.mandatory_arg_error
318: (p_api_name => l_proc,
319: p_argument => 'validation_end_date',
320: p_argument_value => p_validation_end_date);
321: --
318: (p_api_name => l_proc,
319: p_argument => 'validation_end_date',
320: p_argument_value => p_validation_end_date);
321: --
322: hr_api.mandatory_arg_error
323: (p_api_name => l_proc,
324: p_argument => 'vald_rlshp_for_reimb_id',
325: p_argument_value => p_vald_rlshp_for_reimb_id);
326: --
366: --
367: -- Call all supporting business operations
368: --
369: --
370: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
371: --
372: chk_vald_rlshp_for_reimb_id
373: (p_vald_rlshp_for_reimb_id => p_rec.vald_rlshp_for_reimb_id,
374: p_effective_date => p_effective_date,
400: --
401: -- Call all supporting business operations
402: --
403: --
404: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
405: --
406: chk_vald_rlshp_for_reimb_id
407: (p_vald_rlshp_for_reimb_id => p_rec.vald_rlshp_for_reimb_id,
408: p_effective_date => p_effective_date,
478: hr_utility.set_location('Entering:'|| l_proc, 10);
479: --
480: -- Ensure that all the mandatory parameter are not null
481: --
482: hr_api.mandatory_arg_error(p_api_name => l_proc,
483: p_argument => 'vald_rlshp_for_reimb_id',
484: p_argument_value => p_vald_rlshp_for_reimb_id);
485: --
486: open csr_leg_code;