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: fnd_message.raise_error;
64: --
65: end if;
66: 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: fnd_message.raise_error;
64: --
65: end if;
66: close csr_sec_grp;
67: --
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
510: IF NOT pay_eei_shd.api_updating
511: (p_element_type_extra_info_id => p_rec.element_type_extra_info_id
512: ,p_object_version_number => p_rec.object_version_number
513: ) THEN
514: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
515: fnd_message.set_token('PROCEDURE ', l_proc);
516: fnd_message.set_token('STEP ', '5');
517: fnd_message.raise_error;
518: END IF;
511: (p_element_type_extra_info_id => p_rec.element_type_extra_info_id
512: ,p_object_version_number => p_rec.object_version_number
513: ) THEN
514: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
515: fnd_message.set_token('PROCEDURE ', l_proc);
516: fnd_message.set_token('STEP ', '5');
517: fnd_message.raise_error;
518: END IF;
519: --
512: ,p_object_version_number => p_rec.object_version_number
513: ) THEN
514: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
515: fnd_message.set_token('PROCEDURE ', l_proc);
516: fnd_message.set_token('STEP ', '5');
517: fnd_message.raise_error;
518: END IF;
519: --
520: --
513: ) THEN
514: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
515: fnd_message.set_token('PROCEDURE ', l_proc);
516: fnd_message.set_token('STEP ', '5');
517: fnd_message.raise_error;
518: END IF;
519: --
520: --
521: EXCEPTION
919: IF l_exists is null THEN
920: hr_utility.set_message(8303, 'PQP_230445_INVAL_USER_COL_NAME');
921: hr_utility.set_message_token('COLUMN_NAME',p_eei_information17);
922: hr_utility.set_message_token('TABLE_NAME',p_eei_information3);
923: fnd_message.raise_error;
924: END IF;
925: else
926: -- note cant use the this procedure as message displayed is incorrect.
927: open c_input_value(p_eei_information17) ;