76: close csr_sec_grp;
77: --
78: -- The primary key is invalid therefore we must error
79: --
80: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
81: fnd_message.raise_error;
82: --
83: end if;
84: close csr_sec_grp;
77: --
78: -- The primary key is invalid therefore we must error
79: --
80: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
81: fnd_message.raise_error;
82: --
83: end if;
84: close csr_sec_grp;
85: --
163: --
164: -- The primary key is invalid therefore we must error
165: --
166: close csr_leg_code;
167: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
168: fnd_message.raise_error;
169: end if;
170: hr_utility.set_location(l_proc,30);
171: --
164: -- The primary key is invalid therefore we must error
165: --
166: close csr_leg_code;
167: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
168: fnd_message.raise_error;
169: end if;
170: hr_utility.set_location(l_proc,30);
171: --
172: -- Set the global variables so the values are
251: --
252: -- The payroll action is invalid therefore we must error
253: --
254: close csr_pa_leg_code;
255: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
256: fnd_message.raise_error;
257: --
258: else
259: --
252: -- The payroll action is invalid therefore we must error
253: --
254: close csr_pa_leg_code;
255: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
256: fnd_message.raise_error;
257: --
258: else
259: --
260: close csr_pa_leg_code;
271: --
272: -- The assignment action is invalid therefore we must error
273: --
274: close csr_aa_leg_code;
275: fnd_message.set_name('PAY','PAY_34987_INVALID_ASG_ACTION');
276: fnd_message.raise_error;
277: --
278: else
279: --
272: -- The assignment action is invalid therefore we must error
273: --
274: close csr_aa_leg_code;
275: fnd_message.set_name('PAY','PAY_34987_INVALID_ASG_ACTION');
276: fnd_message.raise_error;
277: --
278: else
279: --
280: close csr_aa_leg_code;
285: --
286: --
287: -- The action context type is invalid therefore we must error
288: --
289: fnd_message.set_name('PAY','PAY_34986_INV_ACT_CONTEXT_TYPE');
290: fnd_message.raise_error;
291: --
292: end if;
293: --
286: --
287: -- The action context type is invalid therefore we must error
288: --
289: fnd_message.set_name('PAY','PAY_34986_INV_ACT_CONTEXT_TYPE');
290: fnd_message.raise_error;
291: --
292: end if;
293: --
294: pay_aif_bus.g_action_context_id := p_action_context_id;
522: hr_utility.set_location('Entering:'||l_proc,10);
523: --
524: if p_action_context_type not in ('PA','AAC','AAP') then
525: --
526: fnd_message.set_name('PAY','PAY_34986_INV_ACT_CONTEXT_TYPE');
527: fnd_message.raise_error;
528: --
529: end if;
530: --
523: --
524: if p_action_context_type not in ('PA','AAC','AAP') then
525: --
526: fnd_message.set_name('PAY','PAY_34986_INV_ACT_CONTEXT_TYPE');
527: fnd_message.raise_error;
528: --
529: end if;
530: --
531: hr_utility.set_location('Leaving:'||l_proc,20);
585: open csr_pact_exists;
586: fetch csr_pact_exists into l_dummy;
587: if csr_pact_exists%notfound then
588: --
589: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
590: fnd_message.raise_error;
591: --
592: end if;
593: --
586: fetch csr_pact_exists into l_dummy;
587: if csr_pact_exists%notfound then
588: --
589: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
590: fnd_message.raise_error;
591: --
592: end if;
593: --
594: elsif (p_action_context_type in ('AAC','AAP')) then
596: open csr_aact_exists;
597: fetch csr_aact_exists into l_dummy;
598: if csr_aact_exists%notfound then
599: --
600: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
601: fnd_message.raise_error;
602: --
603: end if;
604: --
597: fetch csr_aact_exists into l_dummy;
598: if csr_aact_exists%notfound then
599: --
600: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
601: fnd_message.raise_error;
602: --
603: end if;
604: --
605: else
603: end if;
604: --
605: else
606: --
607: fnd_message.set_name('PAY','PAY_34986_INV_ACT_CONTEXT_TYPE');
608: fnd_message.raise_error;
609: --
610: end if;
611: --
604: --
605: else
606: --
607: fnd_message.set_name('PAY','PAY_34986_INV_ACT_CONTEXT_TYPE');
608: fnd_message.raise_error;
609: --
610: end if;
611: --
612: hr_utility.set_location('Leaving:'||l_proc,20);
659: open csr_asg_exists;
660: fetch csr_asg_exists into l_dummy;
661: if csr_asg_exists%notfound then
662: --
663: fnd_message.set_name('PAY','PAY_52099_ASG_INV_ASG_ID');
664: fnd_message.raise_error;
665: --
666: end if;
667: --
660: fetch csr_asg_exists into l_dummy;
661: if csr_asg_exists%notfound then
662: --
663: fnd_message.set_name('PAY','PAY_52099_ASG_INV_ASG_ID');
664: fnd_message.raise_error;
665: --
666: end if;
667: --
668: end if;
714: IF NOT pay_aif_shd.api_updating
715: (p_action_information_id => p_rec.action_information_id
716: ,p_object_version_number => p_rec.object_version_number
717: ) THEN
718: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
719: fnd_message.set_token('PROCEDURE ', l_proc);
720: fnd_message.set_token('STEP ', '5');
721: fnd_message.raise_error;
722: END IF;
715: (p_action_information_id => p_rec.action_information_id
716: ,p_object_version_number => p_rec.object_version_number
717: ) THEN
718: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
719: fnd_message.set_token('PROCEDURE ', l_proc);
720: fnd_message.set_token('STEP ', '5');
721: fnd_message.raise_error;
722: END IF;
723: --
716: ,p_object_version_number => p_rec.object_version_number
717: ) THEN
718: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
719: fnd_message.set_token('PROCEDURE ', l_proc);
720: fnd_message.set_token('STEP ', '5');
721: fnd_message.raise_error;
722: END IF;
723: --
724: -- action_context_id
717: ) THEN
718: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
719: fnd_message.set_token('PROCEDURE ', l_proc);
720: fnd_message.set_token('STEP ', '5');
721: fnd_message.raise_error;
722: END IF;
723: --
724: -- action_context_id
725: --