417: fetch csr_reason_id into l_reason_id;
418: --
419: if csr_reason_id%notfound then
420: --
421: fnd_message.set_name ('SSP','SSP_35046_NO_SUCH_REASON');
422: fnd_message.set_token ('REASON',p_reason);
423: fnd_message.raise_error;
424: --
425: end if;
418: --
419: if csr_reason_id%notfound then
420: --
421: fnd_message.set_name ('SSP','SSP_35046_NO_SUCH_REASON');
422: fnd_message.set_token ('REASON',p_reason);
423: fnd_message.raise_error;
424: --
425: end if;
426: --
419: if csr_reason_id%notfound then
420: --
421: fnd_message.set_name ('SSP','SSP_35046_NO_SUCH_REASON');
422: fnd_message.set_token ('REASON',p_reason);
423: fnd_message.raise_error;
424: --
425: end if;
426: --
427: close csr_reason_id;
829: hr_utility.set_location ('Leaving :'||l_proc,1);
830: --
831: exception
832: when cannot_derive_payroll_period then
833: fnd_message.set_name ('SSP', 'SSP_35029_NO_PAYROLL_PERIOD');
834: fnd_message.raise_error;
835: when no_payroll then
836: fnd_message.set_name ('SSP','SSP_35080_NO_PAYROLL');
837: fnd_message.set_token ('DATE_EARNED',p_date_earned);
830: --
831: exception
832: when cannot_derive_payroll_period then
833: fnd_message.set_name ('SSP', 'SSP_35029_NO_PAYROLL_PERIOD');
834: fnd_message.raise_error;
835: when no_payroll then
836: fnd_message.set_name ('SSP','SSP_35080_NO_PAYROLL');
837: fnd_message.set_token ('DATE_EARNED',p_date_earned);
838: fnd_message.raise_error;
832: when cannot_derive_payroll_period then
833: fnd_message.set_name ('SSP', 'SSP_35029_NO_PAYROLL_PERIOD');
834: fnd_message.raise_error;
835: when no_payroll then
836: fnd_message.set_name ('SSP','SSP_35080_NO_PAYROLL');
837: fnd_message.set_token ('DATE_EARNED',p_date_earned);
838: fnd_message.raise_error;
839: end get_entry_details;
840: --------------------------------------------------------------------------------
833: fnd_message.set_name ('SSP', 'SSP_35029_NO_PAYROLL_PERIOD');
834: fnd_message.raise_error;
835: when no_payroll then
836: fnd_message.set_name ('SSP','SSP_35080_NO_PAYROLL');
837: fnd_message.set_token ('DATE_EARNED',p_date_earned);
838: fnd_message.raise_error;
839: end get_entry_details;
840: --------------------------------------------------------------------------------
841: function average_earnings_error return varchar2 is
834: fnd_message.raise_error;
835: when no_payroll then
836: fnd_message.set_name ('SSP','SSP_35080_NO_PAYROLL');
837: fnd_message.set_token ('DATE_EARNED',p_date_earned);
838: fnd_message.raise_error;
839: end get_entry_details;
840: --------------------------------------------------------------------------------
841: function average_earnings_error return varchar2 is
842: --