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
190: (p_cost_allocation_id => p_rec.cost_allocation_id
191: ,p_effective_date => p_effective_date
192: ,p_object_version_number => p_rec.object_version_number
193: ) THEN
194: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
195: fnd_message.set_token('PROCEDURE ', l_proc);
196: fnd_message.set_token('STEP ', '5');
197: fnd_message.raise_error;
198: END IF;
191: ,p_effective_date => p_effective_date
192: ,p_object_version_number => p_rec.object_version_number
193: ) THEN
194: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
195: fnd_message.set_token('PROCEDURE ', l_proc);
196: fnd_message.set_token('STEP ', '5');
197: fnd_message.raise_error;
198: END IF;
199: --
192: ,p_object_version_number => p_rec.object_version_number
193: ) THEN
194: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
195: fnd_message.set_token('PROCEDURE ', l_proc);
196: fnd_message.set_token('STEP ', '5');
197: fnd_message.raise_error;
198: END IF;
199: --
200: -- p_cost_allocation_id
193: ) THEN
194: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
195: fnd_message.set_token('PROCEDURE ', l_proc);
196: fnd_message.set_token('STEP ', '5');
197: fnd_message.raise_error;
198: END IF;
199: --
200: -- p_cost_allocation_id
201: --
269: open csr_combination_exists;
270: fetch csr_combination_exists into l_exists;
271: if csr_combination_exists%notfound then
272: close csr_combination_exists;
273: fnd_message.set_name('PAY', 'PAY_50982_INVALID_COST_KEYFLEX');
274: fnd_message.raise_error;
275: end if;
276: close csr_combination_exists;
277: End chk_cost_allocation_keyflex_id;
270: fetch csr_combination_exists into l_exists;
271: if csr_combination_exists%notfound then
272: close csr_combination_exists;
273: fnd_message.set_name('PAY', 'PAY_50982_INVALID_COST_KEYFLEX');
274: fnd_message.raise_error;
275: end if;
276: close csr_combination_exists;
277: End chk_cost_allocation_keyflex_id;
278: --
313: open csr_assignment_exists;
314: fetch csr_assignment_exists into l_exists;
315: if csr_assignment_exists%notfound then
316: close csr_assignment_exists;
317: fnd_message.set_name('PAY', 'HR_7467_PLK_NOT_ELGBLE_ASS_ID');
318: fnd_message.set_token('ASSIGNMENT_ID', p_assignment_id);
319: fnd_message.raise_error;
320: end if;
321: close csr_assignment_exists;
314: fetch csr_assignment_exists into l_exists;
315: if csr_assignment_exists%notfound then
316: close csr_assignment_exists;
317: fnd_message.set_name('PAY', 'HR_7467_PLK_NOT_ELGBLE_ASS_ID');
318: fnd_message.set_token('ASSIGNMENT_ID', p_assignment_id);
319: fnd_message.raise_error;
320: end if;
321: close csr_assignment_exists;
322: End chk_assignment_id;
315: if csr_assignment_exists%notfound then
316: close csr_assignment_exists;
317: fnd_message.set_name('PAY', 'HR_7467_PLK_NOT_ELGBLE_ASS_ID');
318: fnd_message.set_token('ASSIGNMENT_ID', p_assignment_id);
319: fnd_message.raise_error;
320: end if;
321: close csr_assignment_exists;
322: End chk_assignment_id;
323: --
345: if ((nvl(pay_cal_shd.g_old_rec.proportion,hr_api.g_number) <> p_proportion)
346: or (p_cost_allocation_id is null)) then
347: --
348: if p_proportion not between 0 and 1 then
349: fnd_message.set_name('PAY', 'PAY_50983_INVALID_PROPORTION');
350: fnd_message.raise_error;
351: end if;
352: --
353: end if;
346: or (p_cost_allocation_id is null)) then
347: --
348: if p_proportion not between 0 and 1 then
349: fnd_message.set_name('PAY', 'PAY_50983_INVALID_PROPORTION');
350: fnd_message.raise_error;
351: end if;
352: --
353: end if;
354: --
486: fetch csr_duplicate_cost_keyflex into l_exists;
487: if csr_duplicate_cost_keyflex%found then
488: close csr_duplicate_cost_keyflex;
489:
490: fnd_message.set_name('PER','HR_6645_ASS_COST_DUPL');
491: fnd_message.raise_error;
492:
493: end if;
494: close csr_duplicate_cost_keyflex;
487: if csr_duplicate_cost_keyflex%found then
488: close csr_duplicate_cost_keyflex;
489:
490: fnd_message.set_name('PER','HR_6645_ASS_COST_DUPL');
491: fnd_message.raise_error;
492:
493: end if;
494: close csr_duplicate_cost_keyflex;
495: end if;
569: --
570: -- A referential integrity check was violated therefore
571: -- we must error
572: --
573: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
574: fnd_message.set_token('TABLE_NAME', l_table_name);
575: fnd_message.raise_error;
576: When Others Then
577: --
570: -- A referential integrity check was violated therefore
571: -- we must error
572: --
573: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
574: fnd_message.set_token('TABLE_NAME', l_table_name);
575: fnd_message.raise_error;
576: When Others Then
577: --
578: -- An unhandled or unexpected error has occurred which
571: -- we must error
572: --
573: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
574: fnd_message.set_token('TABLE_NAME', l_table_name);
575: fnd_message.raise_error;
576: When Others Then
577: --
578: -- An unhandled or unexpected error has occurred which
579: -- we must report
577: --
578: -- An unhandled or unexpected error has occurred which
579: -- we must report
580: --
581: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
582: fnd_message.set_token('PROCEDURE', l_proc);
583: fnd_message.set_token('STEP','15');
584: fnd_message.raise_error;
585: End dt_update_validate;
578: -- An unhandled or unexpected error has occurred which
579: -- we must report
580: --
581: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
582: fnd_message.set_token('PROCEDURE', l_proc);
583: fnd_message.set_token('STEP','15');
584: fnd_message.raise_error;
585: End dt_update_validate;
586: --
579: -- we must report
580: --
581: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
582: fnd_message.set_token('PROCEDURE', l_proc);
583: fnd_message.set_token('STEP','15');
584: fnd_message.raise_error;
585: End dt_update_validate;
586: --
587: -- ----------------------------------------------------------------------------
580: --
581: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
582: fnd_message.set_token('PROCEDURE', l_proc);
583: fnd_message.set_token('STEP','15');
584: fnd_message.raise_error;
585: End dt_update_validate;
586: --
587: -- ----------------------------------------------------------------------------
588: -- |--------------------------< dt_delete_validate >--------------------------|
676: --
677: -- A referential integrity check was violated therefore
678: -- we must error
679: --
680: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
681: fnd_message.set_token('TABLE_NAME', l_table_name);
682: fnd_message.raise_error;
683: When Others Then
684: --
677: -- A referential integrity check was violated therefore
678: -- we must error
679: --
680: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
681: fnd_message.set_token('TABLE_NAME', l_table_name);
682: fnd_message.raise_error;
683: When Others Then
684: --
685: -- An unhandled or unexpected error has occurred which
678: -- we must error
679: --
680: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
681: fnd_message.set_token('TABLE_NAME', l_table_name);
682: fnd_message.raise_error;
683: When Others Then
684: --
685: -- An unhandled or unexpected error has occurred which
686: -- we must report
684: --
685: -- An unhandled or unexpected error has occurred which
686: -- we must report
687: --
688: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
689: fnd_message.set_token('PROCEDURE', l_proc);
690: fnd_message.set_token('STEP','15');
691: fnd_message.raise_error;
692: --
685: -- An unhandled or unexpected error has occurred which
686: -- we must report
687: --
688: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
689: fnd_message.set_token('PROCEDURE', l_proc);
690: fnd_message.set_token('STEP','15');
691: fnd_message.raise_error;
692: --
693: End dt_delete_validate;
686: -- we must report
687: --
688: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
689: fnd_message.set_token('PROCEDURE', l_proc);
690: fnd_message.set_token('STEP','15');
691: fnd_message.raise_error;
692: --
693: End dt_delete_validate;
694: --
687: --
688: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
689: fnd_message.set_token('PROCEDURE', l_proc);
690: fnd_message.set_token('STEP','15');
691: fnd_message.raise_error;
692: --
693: End dt_delete_validate;
694: --
695: -- ----------------------------------------------------------------------------