55: close csr_sec_grp;
56: --
57: -- The primary key is invalid therefore we must error
58: --
59: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
60: fnd_message.raise_error;
61: --
62: end if;
63: close csr_sec_grp;
56: --
57: -- The primary key is invalid therefore we must error
58: --
59: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
60: fnd_message.raise_error;
61: --
62: end if;
63: close csr_sec_grp;
64: --
128: --
129: -- The primary key is invalid therefore we must error
130: --
131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
129: -- The primary key is invalid therefore we must error
130: --
131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
137: -- Set the global variables so the values are
370: (p_prtt_rmt_rqst_ctfn_prvdd_id => p_rec.prtt_rmt_rqst_ctfn_prvdd_id
371: ,p_effective_date => p_effective_date
372: ,p_object_version_number => p_rec.object_version_number
373: ) THEN
374: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
375: fnd_message.set_token('PROCEDURE ', l_proc);
376: fnd_message.set_token('STEP ', '5');
377: fnd_message.raise_error;
378: END IF;
371: ,p_effective_date => p_effective_date
372: ,p_object_version_number => p_rec.object_version_number
373: ) THEN
374: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
375: fnd_message.set_token('PROCEDURE ', l_proc);
376: fnd_message.set_token('STEP ', '5');
377: fnd_message.raise_error;
378: END IF;
379: --
372: ,p_object_version_number => p_rec.object_version_number
373: ) THEN
374: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
375: fnd_message.set_token('PROCEDURE ', l_proc);
376: fnd_message.set_token('STEP ', '5');
377: fnd_message.raise_error;
378: END IF;
379: --
380: -- EDIT_HERE: Add checks to ensure non-updateable args have
373: ) THEN
374: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
375: fnd_message.set_token('PROCEDURE ', l_proc);
376: fnd_message.set_token('STEP ', '5');
377: fnd_message.raise_error;
378: END IF;
379: --
380: -- EDIT_HERE: Add checks to ensure non-updateable args have
381: -- not been updated.
482: --
483: -- A referential integrity check was violated therefore
484: -- we must error
485: --
486: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
487: fnd_message.set_token('TABLE_NAME', l_table_name);
488: fnd_message.raise_error;
489: When Others Then
490: --
483: -- A referential integrity check was violated therefore
484: -- we must error
485: --
486: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
487: fnd_message.set_token('TABLE_NAME', l_table_name);
488: fnd_message.raise_error;
489: When Others Then
490: --
491: -- An unhandled or unexpected error has occurred which
484: -- we must error
485: --
486: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
487: fnd_message.set_token('TABLE_NAME', l_table_name);
488: fnd_message.raise_error;
489: When Others Then
490: --
491: -- An unhandled or unexpected error has occurred which
492: -- we must report
490: --
491: -- An unhandled or unexpected error has occurred which
492: -- we must report
493: --
494: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
495: fnd_message.set_token('PROCEDURE', l_proc);
496: fnd_message.set_token('STEP','15');
497: fnd_message.raise_error;
498: End dt_update_validate;
491: -- An unhandled or unexpected error has occurred which
492: -- we must report
493: --
494: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
495: fnd_message.set_token('PROCEDURE', l_proc);
496: fnd_message.set_token('STEP','15');
497: fnd_message.raise_error;
498: End dt_update_validate;
499: --
492: -- we must report
493: --
494: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
495: fnd_message.set_token('PROCEDURE', l_proc);
496: fnd_message.set_token('STEP','15');
497: fnd_message.raise_error;
498: End dt_update_validate;
499: --
500: -- ----------------------------------------------------------------------------
493: --
494: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
495: fnd_message.set_token('PROCEDURE', l_proc);
496: fnd_message.set_token('STEP','15');
497: fnd_message.raise_error;
498: End dt_update_validate;
499: --
500: -- ----------------------------------------------------------------------------
501: -- |--------------------------< dt_delete_validate >--------------------------|
589: --
590: -- A referential integrity check was violated therefore
591: -- we must error
592: --
593: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
594: fnd_message.set_token('TABLE_NAME', l_table_name);
595: fnd_message.raise_error;
596: When Others Then
597: --
590: -- A referential integrity check was violated therefore
591: -- we must error
592: --
593: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
594: fnd_message.set_token('TABLE_NAME', l_table_name);
595: fnd_message.raise_error;
596: When Others Then
597: --
598: -- An unhandled or unexpected error has occurred which
591: -- we must error
592: --
593: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
594: fnd_message.set_token('TABLE_NAME', l_table_name);
595: fnd_message.raise_error;
596: When Others Then
597: --
598: -- An unhandled or unexpected error has occurred which
599: -- we must report
597: --
598: -- An unhandled or unexpected error has occurred which
599: -- we must report
600: --
601: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
602: fnd_message.set_token('PROCEDURE', l_proc);
603: fnd_message.set_token('STEP','15');
604: fnd_message.raise_error;
605: --
598: -- An unhandled or unexpected error has occurred which
599: -- we must report
600: --
601: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
602: fnd_message.set_token('PROCEDURE', l_proc);
603: fnd_message.set_token('STEP','15');
604: fnd_message.raise_error;
605: --
606: End dt_delete_validate;
599: -- we must report
600: --
601: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
602: fnd_message.set_token('PROCEDURE', l_proc);
603: fnd_message.set_token('STEP','15');
604: fnd_message.raise_error;
605: --
606: End dt_delete_validate;
607: --
600: --
601: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
602: fnd_message.set_token('PROCEDURE', l_proc);
603: fnd_message.set_token('STEP','15');
604: fnd_message.raise_error;
605: --
606: End dt_delete_validate;
607: --
608: -- ----------------------------------------------------------------------------