58: close csr_sec_grp;
59: --
60: -- The primary key is invalid therefore we must error
61: --
62: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
63: hr_multi_message.add
64: (p_associated_column1
65: => nvl(p_associated_column1,'VALIDATION_PERIOD_ID')
66: );
137: --
138: -- The primary key is invalid therefore we must error
139: --
140: close csr_leg_code;
141: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
142: fnd_message.raise_error;
143: end if;
144: hr_utility.set_location(l_proc,30);
145: --
138: -- The primary key is invalid therefore we must error
139: --
140: close csr_leg_code;
141: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
142: fnd_message.raise_error;
143: end if;
144: hr_utility.set_location(l_proc,30);
145: --
146: -- Set the global variables so the values are
196: IF NOT pqh_vlp_shd.api_updating
197: (p_validation_period_id => p_rec.validation_period_id
198: ,p_object_version_number => p_rec.object_version_number
199: ) THEN
200: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
201: fnd_message.set_token('PROCEDURE ', l_proc);
202: fnd_message.set_token('STEP ', '5');
203: fnd_message.raise_error;
204: END IF;
197: (p_validation_period_id => p_rec.validation_period_id
198: ,p_object_version_number => p_rec.object_version_number
199: ) THEN
200: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
201: fnd_message.set_token('PROCEDURE ', l_proc);
202: fnd_message.set_token('STEP ', '5');
203: fnd_message.raise_error;
204: END IF;
205: --
198: ,p_object_version_number => p_rec.object_version_number
199: ) THEN
200: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
201: fnd_message.set_token('PROCEDURE ', l_proc);
202: fnd_message.set_token('STEP ', '5');
203: fnd_message.raise_error;
204: END IF;
205: --
206: End chk_non_updateable_args;
199: ) THEN
200: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
201: fnd_message.set_token('PROCEDURE ', l_proc);
202: fnd_message.set_token('STEP ', '5');
203: fnd_message.raise_error;
204: END IF;
205: --
206: End chk_non_updateable_args;
207: --
240: and
241: nvl(end_date, hr_general.end_of_time);
242:
243: if cnt > 0 then
244: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
245: fnd_message.raise_error;
246: end if;
247: -- for p_rec.end_date
248: select count(*) into cnt from pqh_fr_validation_periods
241: nvl(end_date, hr_general.end_of_time);
242:
243: if cnt > 0 then
244: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
245: fnd_message.raise_error;
246: end if;
247: -- for p_rec.end_date
248: select count(*) into cnt from pqh_fr_validation_periods
249: where previous_employer_id = p_rec.previous_employer_id
254: and
255: nvl(end_date, hr_general.end_of_time);
256:
257: if cnt > 0 then
258: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
259: fnd_message.raise_error;
260: end if;
261: --for start_date
262: select count(*) into cnt from pqh_fr_validation_periods
255: nvl(end_date, hr_general.end_of_time);
256:
257: if cnt > 0 then
258: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
259: fnd_message.raise_error;
260: end if;
261: --for start_date
262: select count(*) into cnt from pqh_fr_validation_periods
263: where previous_employer_id = p_rec.previous_employer_id
268: and
269: nvl(p_rec.end_date, hr_general.end_of_time);
270:
271: if cnt > 0 then
272: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
273: fnd_message.raise_error;
274: end if;
275: -- for end_date
276: select count(*) into cnt from pqh_fr_validation_periods
269: nvl(p_rec.end_date, hr_general.end_of_time);
270:
271: if cnt > 0 then
272: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
273: fnd_message.raise_error;
274: end if;
275: -- for end_date
276: select count(*) into cnt from pqh_fr_validation_periods
277: where previous_employer_id = p_rec.previous_employer_id
282: and
283: nvl(p_rec.end_date, hr_general.end_of_time);
284:
285: if cnt > 0 then
286: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
287: fnd_message.raise_error;
288: end if;
289: end if;
290: hr_utility.set_location(' Leaving:'||l_proc, 10);
283: nvl(p_rec.end_date, hr_general.end_of_time);
284:
285: if cnt > 0 then
286: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
287: fnd_message.raise_error;
288: end if;
289: end if;
290: hr_utility.set_location(' Leaving:'||l_proc, 10);
291: End insert_validate;
331: and
332: nvl(end_date, hr_general.end_of_time);
333:
334: if cnt > 0 then
335: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
336: fnd_message.raise_error;
337: end if;
338: -- for p_rec.end_date
339: select count(*) into cnt from pqh_fr_validation_periods
332: nvl(end_date, hr_general.end_of_time);
333:
334: if cnt > 0 then
335: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
336: fnd_message.raise_error;
337: end if;
338: -- for p_rec.end_date
339: select count(*) into cnt from pqh_fr_validation_periods
340: where previous_employer_id = p_rec.previous_employer_id
346: and
347: nvl(end_date, hr_general.end_of_time);
348:
349: if cnt > 0 then
350: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
351: fnd_message.raise_error;
352: end if;
353: --for start_date
354: select count(*) into cnt from pqh_fr_validation_periods
347: nvl(end_date, hr_general.end_of_time);
348:
349: if cnt > 0 then
350: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
351: fnd_message.raise_error;
352: end if;
353: --for start_date
354: select count(*) into cnt from pqh_fr_validation_periods
355: where previous_employer_id = p_rec.previous_employer_id
361: and
362: nvl(p_rec.end_date, hr_general.end_of_time);
363:
364: if cnt > 0 then
365: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
366: fnd_message.raise_error;
367: end if;
368: -- for end_date
369: select count(*) into cnt from pqh_fr_validation_periods
362: nvl(p_rec.end_date, hr_general.end_of_time);
363:
364: if cnt > 0 then
365: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
366: fnd_message.raise_error;
367: end if;
368: -- for end_date
369: select count(*) into cnt from pqh_fr_validation_periods
370: where previous_employer_id = p_rec.previous_employer_id
376: and
377: nvl(p_rec.end_date, hr_general.end_of_time);
378:
379: if cnt > 0 then
380: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
381: fnd_message.raise_error;
382: end if;
383: end if;
384: --
377: nvl(p_rec.end_date, hr_general.end_of_time);
378:
379: if cnt > 0 then
380: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
381: fnd_message.raise_error;
382: end if;
383: end if;
384: --
385: hr_utility.set_location(' Leaving:'||l_proc, 10);