57: close csr_sec_grp;
58: --
59: -- The primary key is invalid therefore we must error
60: --
61: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
62: fnd_message.raise_error;
63: --
64: end if;
65: close csr_sec_grp;
58: --
59: -- The primary key is invalid therefore we must error
60: --
61: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
62: fnd_message.raise_error;
63: --
64: end if;
65: close csr_sec_grp;
66: --
132: --
133: -- The primary key is invalid therefore we must error
134: --
135: close csr_leg_code;
136: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
137: fnd_message.raise_error;
138: end if;
139: hr_utility.set_location(l_proc,30);
140: --
133: -- The primary key is invalid therefore we must error
134: --
135: close csr_leg_code;
136: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
137: fnd_message.raise_error;
138: end if;
139: hr_utility.set_location(l_proc,30);
140: --
141: -- Set the global variables so the values are
375: (p_element_entry_id => p_rec.element_entry_id
376: ,p_effective_date => p_effective_date
377: ,p_object_version_number => p_rec.object_version_number
378: ) THEN
379: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
380: fnd_message.set_token('PROCEDURE ', l_proc);
381: fnd_message.set_token('STEP ', '5');
382: fnd_message.raise_error;
383: END IF;
376: ,p_effective_date => p_effective_date
377: ,p_object_version_number => p_rec.object_version_number
378: ) THEN
379: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
380: fnd_message.set_token('PROCEDURE ', l_proc);
381: fnd_message.set_token('STEP ', '5');
382: fnd_message.raise_error;
383: END IF;
384: --
377: ,p_object_version_number => p_rec.object_version_number
378: ) THEN
379: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
380: fnd_message.set_token('PROCEDURE ', l_proc);
381: fnd_message.set_token('STEP ', '5');
382: fnd_message.raise_error;
383: END IF;
384: --
385: hr_utility.set_location(l_proc, 10);
378: ) THEN
379: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
380: fnd_message.set_token('PROCEDURE ', l_proc);
381: fnd_message.set_token('STEP ', '5');
382: fnd_message.raise_error;
383: END IF;
384: --
385: hr_utility.set_location(l_proc, 10);
386: --
493: --
494: -- A referential integrity check was violated therefore
495: -- we must error
496: --
497: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
498: fnd_message.set_token('TABLE_NAME', l_table_name);
499: fnd_message.raise_error;
500: When Others Then
501: --
494: -- A referential integrity check was violated therefore
495: -- we must error
496: --
497: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
498: fnd_message.set_token('TABLE_NAME', l_table_name);
499: fnd_message.raise_error;
500: When Others Then
501: --
502: -- An unhandled or unexpected error has occurred which
495: -- we must error
496: --
497: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
498: fnd_message.set_token('TABLE_NAME', l_table_name);
499: fnd_message.raise_error;
500: When Others Then
501: --
502: -- An unhandled or unexpected error has occurred which
503: -- we must report
501: --
502: -- An unhandled or unexpected error has occurred which
503: -- we must report
504: --
505: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
506: fnd_message.set_token('PROCEDURE', l_proc);
507: fnd_message.set_token('STEP','15');
508: fnd_message.raise_error;
509: End dt_update_validate;
502: -- An unhandled or unexpected error has occurred which
503: -- we must report
504: --
505: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
506: fnd_message.set_token('PROCEDURE', l_proc);
507: fnd_message.set_token('STEP','15');
508: fnd_message.raise_error;
509: End dt_update_validate;
510: --
503: -- we must report
504: --
505: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
506: fnd_message.set_token('PROCEDURE', l_proc);
507: fnd_message.set_token('STEP','15');
508: fnd_message.raise_error;
509: End dt_update_validate;
510: --
511: -- ----------------------------------------------------------------------------
504: --
505: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
506: fnd_message.set_token('PROCEDURE', l_proc);
507: fnd_message.set_token('STEP','15');
508: fnd_message.raise_error;
509: End dt_update_validate;
510: --
511: -- ----------------------------------------------------------------------------
512: -- |--------------------------< dt_delete_validate >--------------------------|
600: --
601: -- A referential integrity check was violated therefore
602: -- we must error
603: --
604: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
605: fnd_message.set_token('TABLE_NAME', l_table_name);
606: fnd_message.raise_error;
607: When Others Then
608: --
601: -- A referential integrity check was violated therefore
602: -- we must error
603: --
604: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
605: fnd_message.set_token('TABLE_NAME', l_table_name);
606: fnd_message.raise_error;
607: When Others Then
608: --
609: -- An unhandled or unexpected error has occurred which
602: -- we must error
603: --
604: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
605: fnd_message.set_token('TABLE_NAME', l_table_name);
606: fnd_message.raise_error;
607: When Others Then
608: --
609: -- An unhandled or unexpected error has occurred which
610: -- we must report
608: --
609: -- An unhandled or unexpected error has occurred which
610: -- we must report
611: --
612: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
613: fnd_message.set_token('PROCEDURE', l_proc);
614: fnd_message.set_token('STEP','15');
615: fnd_message.raise_error;
616: --
609: -- An unhandled or unexpected error has occurred which
610: -- we must report
611: --
612: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
613: fnd_message.set_token('PROCEDURE', l_proc);
614: fnd_message.set_token('STEP','15');
615: fnd_message.raise_error;
616: --
617: End dt_delete_validate;
610: -- we must report
611: --
612: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
613: fnd_message.set_token('PROCEDURE', l_proc);
614: fnd_message.set_token('STEP','15');
615: fnd_message.raise_error;
616: --
617: End dt_delete_validate;
618: --
611: --
612: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
613: fnd_message.set_token('PROCEDURE', l_proc);
614: fnd_message.set_token('STEP','15');
615: fnd_message.raise_error;
616: --
617: End dt_delete_validate;
618: --
619: -- ----------------------------------------------------------------------------