56: close csr_sec_grp;
57: --
58: -- The primary key is invalid therefore we must error
59: --
60: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
61: hr_multi_message.add
62: (p_associated_column1
63: => nvl(p_associated_column1,'EVENT_VALUE_CHANGE_ID')
64: );
133: --
134: -- The primary key is invalid therefore we must error
135: --
136: close csr_leg_code;
137: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
138: fnd_message.raise_error;
139: end if;
140: hr_utility.set_location(l_proc,30);
141: --
134: -- The primary key is invalid therefore we must error
135: --
136: close csr_leg_code;
137: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
138: fnd_message.raise_error;
139: end if;
140: hr_utility.set_location(l_proc,30);
141: --
142: -- Set the global variables so the values are
196: (p_event_value_change_id => p_rec.event_value_change_id
197: ,p_effective_date => p_effective_date
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_effective_date => p_effective_date
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: -- Checks to ensure non-updateable args have
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: -- Checks to ensure non-updateable args have
207: -- not been updated.
309: p_lookup_code => p_rec.default_event,
310: p_effective_date => p_effective_date)
311: then
312: hr_utility.set_location(' Leaving:'||l_proc, 10);
313: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
314: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
315: fnd_message.set_token('VALUE', p_rec.default_event);
316: fnd_message.raise_error;
317: end if;
310: p_effective_date => p_effective_date)
311: then
312: hr_utility.set_location(' Leaving:'||l_proc, 10);
313: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
314: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
315: fnd_message.set_token('VALUE', p_rec.default_event);
316: fnd_message.raise_error;
317: end if;
318: ELSE
311: then
312: hr_utility.set_location(' Leaving:'||l_proc, 10);
313: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
314: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
315: fnd_message.set_token('VALUE', p_rec.default_event);
316: fnd_message.raise_error;
317: end if;
318: ELSE
319: -- Validate against hr_standard_lookups as DateTracked and no bg context.
312: hr_utility.set_location(' Leaving:'||l_proc, 10);
313: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
314: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
315: fnd_message.set_token('VALUE', p_rec.default_event);
316: fnd_message.raise_error;
317: end if;
318: ELSE
319: -- Validate against hr_standard_lookups as DateTracked and no bg context.
320: if hr_api.not_exists_in_dt_hrstanlookups
325: ,p_lookup_code => p_rec.default_event
326: )
327: then
328: hr_utility.set_location(' Leaving:'||l_proc, 10);
329: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
330: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
331: fnd_message.set_token('VALUE', p_rec.default_event);
332: fnd_message.raise_error;
333: end if;
326: )
327: then
328: hr_utility.set_location(' Leaving:'||l_proc, 10);
329: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
330: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
331: fnd_message.set_token('VALUE', p_rec.default_event);
332: fnd_message.raise_error;
333: end if;
334: END IF;
327: then
328: hr_utility.set_location(' Leaving:'||l_proc, 10);
329: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
330: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
331: fnd_message.set_token('VALUE', p_rec.default_event);
332: fnd_message.raise_error;
333: end if;
334: END IF;
335: hr_utility.set_location(' Leaving:'||l_proc, 20);
328: hr_utility.set_location(' Leaving:'||l_proc, 10);
329: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
330: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
331: fnd_message.set_token('VALUE', p_rec.default_event);
332: fnd_message.raise_error;
333: end if;
334: END IF;
335: hr_utility.set_location(' Leaving:'||l_proc, 20);
336: End chk_default_event;
386: p_lookup_code => p_rec.valid_event,
387: p_effective_date => p_effective_date)
388: then
389: hr_utility.set_location(' Leaving:'||l_proc, 10);
390: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
391: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
392: fnd_message.set_token('VALUE', p_rec.valid_event);
393: fnd_message.raise_error;
394: end if;
387: p_effective_date => p_effective_date)
388: then
389: hr_utility.set_location(' Leaving:'||l_proc, 10);
390: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
391: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
392: fnd_message.set_token('VALUE', p_rec.valid_event);
393: fnd_message.raise_error;
394: end if;
395: ELSE
388: then
389: hr_utility.set_location(' Leaving:'||l_proc, 10);
390: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
391: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
392: fnd_message.set_token('VALUE', p_rec.valid_event);
393: fnd_message.raise_error;
394: end if;
395: ELSE
396: -- Validate against hr_standard_lookups as DateTracked and no bg context.
389: hr_utility.set_location(' Leaving:'||l_proc, 10);
390: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
391: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
392: fnd_message.set_token('VALUE', p_rec.valid_event);
393: fnd_message.raise_error;
394: end if;
395: ELSE
396: -- Validate against hr_standard_lookups as DateTracked and no bg context.
397: if hr_api.not_exists_in_dt_hrstanlookups
402: ,p_lookup_code => p_rec.valid_event
403: )
404: then
405: hr_utility.set_location(' Leaving:'||l_proc, 10);
406: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
407: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
408: fnd_message.set_token('VALUE', p_rec.valid_event);
409: fnd_message.raise_error;
410: end if;
403: )
404: then
405: hr_utility.set_location(' Leaving:'||l_proc, 10);
406: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
407: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
408: fnd_message.set_token('VALUE', p_rec.valid_event);
409: fnd_message.raise_error;
410: end if;
411: END IF;
404: then
405: hr_utility.set_location(' Leaving:'||l_proc, 10);
406: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
407: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
408: fnd_message.set_token('VALUE', p_rec.valid_event);
409: fnd_message.raise_error;
410: end if;
411: END IF;
412: hr_utility.set_location(' Leaving:'||l_proc, 20);
405: hr_utility.set_location(' Leaving:'||l_proc, 10);
406: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
407: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
408: fnd_message.set_token('VALUE', p_rec.valid_event);
409: fnd_message.raise_error;
410: end if;
411: END IF;
412: hr_utility.set_location(' Leaving:'||l_proc, 20);
413: End chk_valid_event;
465: p_lookup_code => p_rec.proration_style,
466: p_effective_date => p_effective_date)
467: then
468: hr_utility.set_location(' Leaving:'||l_proc, 10);
469: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
470: fnd_message.set_token('LOOKUP_TYPE', 'PAY_PRORATION_STYLE');
471: fnd_message.set_token('VALUE', p_rec.proration_style);
472: fnd_message.raise_error;
473: end if;
466: p_effective_date => p_effective_date)
467: then
468: hr_utility.set_location(' Leaving:'||l_proc, 10);
469: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
470: fnd_message.set_token('LOOKUP_TYPE', 'PAY_PRORATION_STYLE');
471: fnd_message.set_token('VALUE', p_rec.proration_style);
472: fnd_message.raise_error;
473: end if;
474: ELSE
467: then
468: hr_utility.set_location(' Leaving:'||l_proc, 10);
469: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
470: fnd_message.set_token('LOOKUP_TYPE', 'PAY_PRORATION_STYLE');
471: fnd_message.set_token('VALUE', p_rec.proration_style);
472: fnd_message.raise_error;
473: end if;
474: ELSE
475: -- Validate against hr_standard_lookups as DateTracked and no bg context.
468: hr_utility.set_location(' Leaving:'||l_proc, 10);
469: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
470: fnd_message.set_token('LOOKUP_TYPE', 'PAY_PRORATION_STYLE');
471: fnd_message.set_token('VALUE', p_rec.proration_style);
472: fnd_message.raise_error;
473: end if;
474: ELSE
475: -- Validate against hr_standard_lookups as DateTracked and no bg context.
476: if hr_api.not_exists_in_dt_hrstanlookups
481: ,p_lookup_code => p_rec.proration_style
482: )
483: then
484: hr_utility.set_location(' Leaving:'||l_proc, 10);
485: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
486: fnd_message.set_token('LOOKUP_TYPE', 'PAY_PRORATION_STYLE');
487: fnd_message.set_token('VALUE', p_rec.proration_style);
488: fnd_message.raise_error;
489: end if;
482: )
483: then
484: hr_utility.set_location(' Leaving:'||l_proc, 10);
485: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
486: fnd_message.set_token('LOOKUP_TYPE', 'PAY_PRORATION_STYLE');
487: fnd_message.set_token('VALUE', p_rec.proration_style);
488: fnd_message.raise_error;
489: end if;
490: END IF;
483: then
484: hr_utility.set_location(' Leaving:'||l_proc, 10);
485: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
486: fnd_message.set_token('LOOKUP_TYPE', 'PAY_PRORATION_STYLE');
487: fnd_message.set_token('VALUE', p_rec.proration_style);
488: fnd_message.raise_error;
489: end if;
490: END IF;
491: hr_utility.set_location(' Leaving:'||l_proc, 20);
484: hr_utility.set_location(' Leaving:'||l_proc, 10);
485: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
486: fnd_message.set_token('LOOKUP_TYPE', 'PAY_PRORATION_STYLE');
487: fnd_message.set_token('VALUE', p_rec.proration_style);
488: fnd_message.raise_error;
489: end if;
490: END IF;
491: hr_utility.set_location(' Leaving:'||l_proc, 20);
492: End chk_proration_style;
562: ,p_base_key_column => 'EVENT_QUALIFIER_ID'
563: ,p_base_key_value => p_event_qualifier_id
564: ,p_from_date => p_validation_start_date
565: ,p_to_date => p_validation_end_date))) Then
566: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
567: fnd_message.set_token('TABLE_NAME','event qualifiers');
568: hr_multi_message.add
569: (p_associated_column1 => pay_evc_shd.g_tab_nam || '.EVENT_QUALIFIER_ID');
570: End If;
563: ,p_base_key_value => p_event_qualifier_id
564: ,p_from_date => p_validation_start_date
565: ,p_to_date => p_validation_end_date))) Then
566: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
567: fnd_message.set_token('TABLE_NAME','event qualifiers');
568: hr_multi_message.add
569: (p_associated_column1 => pay_evc_shd.g_tab_nam || '.EVENT_QUALIFIER_ID');
570: End If;
571: --
574: --
575: -- An unhandled or unexpected error has occurred which
576: -- we must report
577: --
578: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
579: fnd_message.set_token('PROCEDURE', l_proc);
580: fnd_message.set_token('STEP','15');
581: fnd_message.raise_error;
582: End dt_update_validate;
575: -- An unhandled or unexpected error has occurred which
576: -- we must report
577: --
578: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
579: fnd_message.set_token('PROCEDURE', l_proc);
580: fnd_message.set_token('STEP','15');
581: fnd_message.raise_error;
582: End dt_update_validate;
583: --
576: -- we must report
577: --
578: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
579: fnd_message.set_token('PROCEDURE', l_proc);
580: fnd_message.set_token('STEP','15');
581: fnd_message.raise_error;
582: End dt_update_validate;
583: --
584: -- ----------------------------------------------------------------------------
577: --
578: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
579: fnd_message.set_token('PROCEDURE', l_proc);
580: fnd_message.set_token('STEP','15');
581: fnd_message.raise_error;
582: End dt_update_validate;
583: --
584: -- ----------------------------------------------------------------------------
585: -- |--------------------------< dt_delete_validate >--------------------------|
671: --
672: -- An unhandled or unexpected error has occurred which
673: -- we must report
674: --
675: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
676: fnd_message.set_token('PROCEDURE', l_proc);
677: fnd_message.set_token('STEP','15');
678: fnd_message.raise_error;
679: --
672: -- An unhandled or unexpected error has occurred which
673: -- we must report
674: --
675: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
676: fnd_message.set_token('PROCEDURE', l_proc);
677: fnd_message.set_token('STEP','15');
678: fnd_message.raise_error;
679: --
680: End dt_delete_validate;
673: -- we must report
674: --
675: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
676: fnd_message.set_token('PROCEDURE', l_proc);
677: fnd_message.set_token('STEP','15');
678: fnd_message.raise_error;
679: --
680: End dt_delete_validate;
681: --
674: --
675: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
676: fnd_message.set_token('PROCEDURE', l_proc);
677: fnd_message.set_token('STEP','15');
678: fnd_message.raise_error;
679: --
680: End dt_delete_validate;
681: --
682: -- ----------------------------------------------------------------------------