45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: if p_calendar_usage_id is not null and p_calendar_id is not null then
48: -- *** NEW_MESSAGE_REQUIRED ***
49: fnd_message.set_name('PAY','EXCEP_USAGE_FK_CONFLICT');
50: fnd_message.raise_error;
51: elsif p_calendar_usage_id is null and p_calendar_id is null then
52: -- *** NEW_MESSAGE_REQUIRED ***
53: fnd_message.set_name('PAY','NO_FK_ENTERED');
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: if p_calendar_usage_id is not null and p_calendar_id is not null then
48: -- *** NEW_MESSAGE_REQUIRED ***
49: fnd_message.set_name('PAY','EXCEP_USAGE_FK_CONFLICT');
50: fnd_message.raise_error;
51: elsif p_calendar_usage_id is null and p_calendar_id is null then
52: -- *** NEW_MESSAGE_REQUIRED ***
53: fnd_message.set_name('PAY','NO_FK_ENTERED');
54: fnd_message.raise_error;
49: fnd_message.set_name('PAY','EXCEP_USAGE_FK_CONFLICT');
50: fnd_message.raise_error;
51: elsif p_calendar_usage_id is null and p_calendar_id is null then
52: -- *** NEW_MESSAGE_REQUIRED ***
53: fnd_message.set_name('PAY','NO_FK_ENTERED');
54: fnd_message.raise_error;
55: end if;
56: --
57: -- No conflict now check that the FK entered is valid
50: fnd_message.raise_error;
51: elsif p_calendar_usage_id is null and p_calendar_id is null then
52: -- *** NEW_MESSAGE_REQUIRED ***
53: fnd_message.set_name('PAY','NO_FK_ENTERED');
54: fnd_message.raise_error;
55: end if;
56: --
57: -- No conflict now check that the FK entered is valid
58: --
61: open c1;
62: fetch c1 into c1_rec;
63: if c1%NOTFOUND then
64: -- *** NEW_MESSAGE_REQUIRED ***
65: fnd_message.set_name('PAY', 'INVALID CALENDAR_ID');
66: fnd_message.raise_error;
67: end if;
68: close c1;
69: else
62: fetch c1 into c1_rec;
63: if c1%NOTFOUND then
64: -- *** NEW_MESSAGE_REQUIRED ***
65: fnd_message.set_name('PAY', 'INVALID CALENDAR_ID');
66: fnd_message.raise_error;
67: end if;
68: close c1;
69: else
70: hr_utility.set_location(l_proc, 15);
71: open c2;
72: fetch c2 into c2_rec;
73: if c2%NOTFOUND then
74: -- *** NEW_MESSAGE_REQUIRED ***
75: fnd_message.set_name('PAY','INVALID_CALENDAR_USAGE_ID');
76: fnd_message.raise_error;
77: end if;
78: close c2;
79: end if;
72: fetch c2 into c2_rec;
73: if c2%NOTFOUND then
74: -- *** NEW_MESSAGE_REQUIRED ***
75: fnd_message.set_name('PAY','INVALID_CALENDAR_USAGE_ID');
76: fnd_message.raise_error;
77: end if;
78: close c2;
79: end if;
80: hr_utility.set_location(' Leaving:'||l_proc, 20);
197: if excep_is_qual_non_qual(p_exception_id) then
198: null;
199: else
200: -- *** NEW_MESSAGE_REQUIRED ***
201: fnd_message.set_name('PAY','INVALID_EXCEPTION_ID');
202: fnd_message.raise_error;
203: end if;
204: end if;
205: hr_utility.set_location(' Leaving:'||l_proc, 10);
198: null;
199: else
200: -- *** NEW_MESSAGE_REQUIRED ***
201: fnd_message.set_name('PAY','INVALID_EXCEPTION_ID');
202: fnd_message.raise_error;
203: end if;
204: end if;
205: hr_utility.set_location(' Leaving:'||l_proc, 10);
206: END Check_Exception_ID;
268: fetch c2 into c2_rec;
269: if c2%FOUND then
270: close c2;
271: -- *** NEW_MESSAGE_REQUIRED ***
272: fnd_message.set_name('PAY','OVERLAPPING_EXCEPTIONS_ERROR');
273: fnd_message.raise_error;
274: end if;
275: hr_utility.set_location(' Leaving:'||l_proc, 20);
276: END Check_Unique;
269: if c2%FOUND then
270: close c2;
271: -- *** NEW_MESSAGE_REQUIRED ***
272: fnd_message.set_name('PAY','OVERLAPPING_EXCEPTIONS_ERROR');
273: fnd_message.raise_error;
274: end if;
275: hr_utility.set_location(' Leaving:'||l_proc, 20);
276: END Check_Unique;
277: --