655: open csr_matching_children;
656: fetch csr_matching_children into l_dummy;
657: if csr_matching_children%found then
658: close csr_matching_children;
659: fnd_message.set_name('PER','HR_449035_ASGRAT_INV_CHILD');
660: hr_multi_message.add
661: (p_associated_column1
662: => 'ASG_RATE_TYPE');
663: else
711: CLOSE csr_sec_grp;
712: --
713: -- The primary key IS invalid therefore we must error
714: --
715: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
716: hr_multi_message.add
717: (p_associated_column1
718: => NVL(p_associated_column1,'RATE_ID')
719: );
788: --
789: -- The primary key IS invalid therefore we must error
790: --
791: CLOSE csr_leg_code;
792: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
793: fnd_message.raise_error;
794: END IF;
795: hr_utility.set_location(l_proc,30);
796: --
789: -- The primary key IS invalid therefore we must error
790: --
791: CLOSE csr_leg_code;
792: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
793: fnd_message.raise_error;
794: END IF;
795: hr_utility.set_location(l_proc,30);
796: --
797: -- Set the global variables so the values are
988: IF NOT pay_pyr_shd.api_updating
989: (p_rate_id => p_rec.rate_id
990: ,p_object_version_number => p_rec.object_version_number
991: ) THEN
992: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
993: fnd_message.set_token('PROCEDURE ', l_proc);
994: fnd_message.set_token('STEP ', '5');
995: fnd_message.raise_error;
996: END IF;
989: (p_rate_id => p_rec.rate_id
990: ,p_object_version_number => p_rec.object_version_number
991: ) THEN
992: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
993: fnd_message.set_token('PROCEDURE ', l_proc);
994: fnd_message.set_token('STEP ', '5');
995: fnd_message.raise_error;
996: END IF;
997: --
990: ,p_object_version_number => p_rec.object_version_number
991: ) THEN
992: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
993: fnd_message.set_token('PROCEDURE ', l_proc);
994: fnd_message.set_token('STEP ', '5');
995: fnd_message.raise_error;
996: END IF;
997: --
998: hr_utility.set_location(l_proc,20);
991: ) THEN
992: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
993: fnd_message.set_token('PROCEDURE ', l_proc);
994: fnd_message.set_token('STEP ', '5');
995: fnd_message.raise_error;
996: END IF;
997: --
998: hr_utility.set_location(l_proc,20);
999: --