59: close csr_sec_grp;
60: --
61: -- The primary key is invalid therefore we must error
62: --
63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
64: hr_multi_message.add
65: (p_associated_column1
66: => nvl(p_associated_column1,'ELEMENT_SPAN_USAGE_ID')
67: );
140: --
141: -- The primary key is invalid therefore we must error
142: --
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
141: -- The primary key is invalid therefore we must error
142: --
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
149: -- Set the global variables so the values are
201: IF NOT pay_esu_shd.api_updating
202: (p_element_span_usage_id => p_rec.element_span_usage_id
203: ,p_object_version_number => p_rec.object_version_number
204: ) THEN
205: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
206: fnd_message.set_token('PROCEDURE ', l_proc);
207: fnd_message.set_token('STEP ', '5');
208: fnd_message.raise_error;
209: END IF;
202: (p_element_span_usage_id => p_rec.element_span_usage_id
203: ,p_object_version_number => p_rec.object_version_number
204: ) THEN
205: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
206: fnd_message.set_token('PROCEDURE ', l_proc);
207: fnd_message.set_token('STEP ', '5');
208: fnd_message.raise_error;
209: END IF;
210: --
203: ,p_object_version_number => p_rec.object_version_number
204: ) THEN
205: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
206: fnd_message.set_token('PROCEDURE ', l_proc);
207: fnd_message.set_token('STEP ', '5');
208: fnd_message.raise_error;
209: END IF;
210: --
211: hr_utility.set_location(l_proc, 10);
204: ) THEN
205: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
206: fnd_message.set_token('PROCEDURE ', l_proc);
207: fnd_message.set_token('STEP ', '5');
208: fnd_message.raise_error;
209: END IF;
210: --
211: hr_utility.set_location(l_proc, 10);
212: --
372: fetch csr_retro_component_usage into l_exists;
373: if csr_retro_component_usage%notfound then
374: close csr_retro_component_usage;
375:
376: fnd_message.set_name('PAY','PAY_33164_ESU_INV_RET_COMP_USG');
377: fnd_message.raise_error;
378:
379: end if;
380: close csr_retro_component_usage;
373: if csr_retro_component_usage%notfound then
374: close csr_retro_component_usage;
375:
376: fnd_message.set_name('PAY','PAY_33164_ESU_INV_RET_COMP_USG');
377: fnd_message.raise_error;
378:
379: end if;
380: close csr_retro_component_usage;
381:
459: fetch csr_time_span into l_exists;
460: if csr_time_span%notfound then
461: close csr_time_span;
462:
463: fnd_message.set_name('PAY','PAY_33165_ESU_INV_TIME_SPAN');
464: fnd_message.raise_error;
465:
466: end if;
467: close csr_time_span;
460: if csr_time_span%notfound then
461: close csr_time_span;
462:
463: fnd_message.set_name('PAY','PAY_33165_ESU_INV_TIME_SPAN');
464: fnd_message.raise_error;
465:
466: end if;
467: close csr_time_span;
468:
562: ,p_lookup_type => 'RETRO_ADJUSTMENT_TYPE'
563: ,p_lookup_code => p_adjustment_type
564: ) then
565:
566: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
567: fnd_message.set_token('COLUMN','ADJUSTMENT_TYPE');
568: fnd_message.set_token('LOOKUP_TYPE','RETRO_ADJUSTMENT_TYPE');
569: fnd_message.raise_error;
570:
563: ,p_lookup_code => p_adjustment_type
564: ) then
565:
566: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
567: fnd_message.set_token('COLUMN','ADJUSTMENT_TYPE');
568: fnd_message.set_token('LOOKUP_TYPE','RETRO_ADJUSTMENT_TYPE');
569: fnd_message.raise_error;
570:
571: end if;
564: ) then
565:
566: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
567: fnd_message.set_token('COLUMN','ADJUSTMENT_TYPE');
568: fnd_message.set_token('LOOKUP_TYPE','RETRO_ADJUSTMENT_TYPE');
569: fnd_message.raise_error;
570:
571: end if;
572: end if;
565:
566: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
567: fnd_message.set_token('COLUMN','ADJUSTMENT_TYPE');
568: fnd_message.set_token('LOOKUP_TYPE','RETRO_ADJUSTMENT_TYPE');
569: fnd_message.raise_error;
570:
571: end if;
572: end if;
573: end if;
688: fetch csr_retro_element_type into l_exists;
689: if csr_retro_element_type%notfound then
690: close csr_retro_element_type;
691:
692: fnd_message.set_name('PAY','PAY_33166_ESU_INV_RET_ELE_TYP');
693: fnd_message.raise_error;
694:
695: end if;
696: close csr_retro_element_type;
689: if csr_retro_element_type%notfound then
690: close csr_retro_element_type;
691:
692: fnd_message.set_name('PAY','PAY_33166_ESU_INV_RET_ELE_TYP');
693: fnd_message.raise_error;
694:
695: end if;
696: close csr_retro_element_type;
697: end if;