458: fetch csr_reason_id into l_reason_id;
459: --
460: if csr_reason_id%notfound then
461: --
462: fnd_message.set_name ('SSP','SSP_35046_NO_SUCH_REASON');
463: fnd_message.set_token ('REASON',p_reason);
464: fnd_message.raise_error;
465: --
466: end if;
459: --
460: if csr_reason_id%notfound then
461: --
462: fnd_message.set_name ('SSP','SSP_35046_NO_SUCH_REASON');
463: fnd_message.set_token ('REASON',p_reason);
464: fnd_message.raise_error;
465: --
466: end if;
467: --
460: if csr_reason_id%notfound then
461: --
462: fnd_message.set_name ('SSP','SSP_35046_NO_SUCH_REASON');
463: fnd_message.set_token ('REASON',p_reason);
464: fnd_message.raise_error;
465: --
466: end if;
467: --
468: close csr_reason_id;
874: hr_utility.set_location ('Leaving :'||l_proc,1);
875: --
876: exception
877: when cannot_derive_payroll_period then
878: fnd_message.set_name ('SSP', 'SSP_35029_NO_PAYROLL_PERIOD');
879: fnd_message.raise_error;
880: when no_payroll then
881: fnd_message.set_name ('SSP','SSP_35080_NO_PAYROLL');
882: fnd_message.set_token ('DATE_EARNED',p_date_earned);
875: --
876: exception
877: when cannot_derive_payroll_period then
878: fnd_message.set_name ('SSP', 'SSP_35029_NO_PAYROLL_PERIOD');
879: fnd_message.raise_error;
880: when no_payroll then
881: fnd_message.set_name ('SSP','SSP_35080_NO_PAYROLL');
882: fnd_message.set_token ('DATE_EARNED',p_date_earned);
883: fnd_message.raise_error;
877: when cannot_derive_payroll_period then
878: fnd_message.set_name ('SSP', 'SSP_35029_NO_PAYROLL_PERIOD');
879: fnd_message.raise_error;
880: when no_payroll then
881: fnd_message.set_name ('SSP','SSP_35080_NO_PAYROLL');
882: fnd_message.set_token ('DATE_EARNED',p_date_earned);
883: fnd_message.raise_error;
884: end get_entry_details;
885: --------------------------------------------------------------------------------
878: fnd_message.set_name ('SSP', 'SSP_35029_NO_PAYROLL_PERIOD');
879: fnd_message.raise_error;
880: when no_payroll then
881: fnd_message.set_name ('SSP','SSP_35080_NO_PAYROLL');
882: fnd_message.set_token ('DATE_EARNED',p_date_earned);
883: fnd_message.raise_error;
884: end get_entry_details;
885: --------------------------------------------------------------------------------
886: function average_earnings_error return varchar2 is
879: fnd_message.raise_error;
880: when no_payroll then
881: fnd_message.set_name ('SSP','SSP_35080_NO_PAYROLL');
882: fnd_message.set_token ('DATE_EARNED',p_date_earned);
883: fnd_message.raise_error;
884: end get_entry_details;
885: --------------------------------------------------------------------------------
886: function average_earnings_error return varchar2 is
887: --