37: hr_utility.set_location('Entering:'||l_proc, 1);
38: open c1;
39: fetch c1 into c1_rec;
40: if c1%NOTFOUND then
41: fnd_message.set_name ('SSP' , 'SSP_35049_INV_PERSON_EFF_DATE' );
42: fnd_message.raise_error;
43: end if;
44: close c1;
45: hr_utility.set_location('Leaving :'||l_proc, 100);
38: open c1;
39: fetch c1 into c1_rec;
40: if c1%NOTFOUND then
41: fnd_message.set_name ('SSP' , 'SSP_35049_INV_PERSON_EFF_DATE' );
42: fnd_message.raise_error;
43: end if;
44: close c1;
45: hr_utility.set_location('Leaving :'||l_proc, 100);
46: End check_person_id;
73:
74: open c2;
75: fetch c2 into c2_rec;
76: if c2%NOTFOUND then
77: fnd_message.set_name ('SSP' , 'SSP_35050_INV_EFFECTIVE_DATE' );
78: fnd_message.raise_error;
79: end if;
80: close c2;
81: hr_utility.set_location('Leaving :'||l_proc, 100);
74: open c2;
75: fetch c2 into c2_rec;
76: if c2%NOTFOUND then
77: fnd_message.set_name ('SSP' , 'SSP_35050_INV_EFFECTIVE_DATE' );
78: fnd_message.raise_error;
79: end if;
80: close c2;
81: hr_utility.set_location('Leaving :'||l_proc, 100);
82: END check_effective_date;
940: hr_utility.set_location ('Leaving :'||l_proc||', exception',999);
941: --
942: p_average_earnings_amount := 0;
943: --
944: fnd_message.set_name ('SSP',ssp_smp_support_pkg.reason_for_no_earnings);
945: --
946: if p_user_entered = 'Y' then
947: --
948: -- We only fail the procedure if the user is entering the amount.
948: -- We only fail the procedure if the user is entering the amount.
949: -- If the system is calculating it (eg as part of the SSP/SMP process)
950: -- then we must allow the process to continue and handle the error
951: --
952: fnd_message.raise_error;
953: end if;
954: --
955: end calculate_average_earnings;
956: