120: IF NOT irc_ivc_shd.api_updating
121: (p_vacancy_consideration_id => p_rec.vacancy_consideration_id
122: ,p_object_version_number => p_rec.object_version_number
123: ) THEN
124: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
125: fnd_message.set_token('PROCEDURE ', l_proc);
126: fnd_message.set_token('STEP ', '5');
127: fnd_message.raise_error;
128: END IF;
121: (p_vacancy_consideration_id => p_rec.vacancy_consideration_id
122: ,p_object_version_number => p_rec.object_version_number
123: ) THEN
124: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
125: fnd_message.set_token('PROCEDURE ', l_proc);
126: fnd_message.set_token('STEP ', '5');
127: fnd_message.raise_error;
128: END IF;
129: --
122: ,p_object_version_number => p_rec.object_version_number
123: ) THEN
124: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
125: fnd_message.set_token('PROCEDURE ', l_proc);
126: fnd_message.set_token('STEP ', '5');
127: fnd_message.raise_error;
128: END IF;
129: --
130: -- Checks to ensure non-updateable args have
123: ) THEN
124: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
125: fnd_message.set_token('PROCEDURE ', l_proc);
126: fnd_message.set_token('STEP ', '5');
127: fnd_message.raise_error;
128: END IF;
129: --
130: -- Checks to ensure non-updateable args have
131: -- not been updated.
223: fetch csr_vacancy_dates into l_date_from,l_date_to;
224: hr_utility.set_location(l_proc, 30);
225: if csr_vacancy_dates%notfound then
226: close csr_vacancy_dates;
227: fnd_message.set_name('PER','IRC_412032_RTM_INV_VACANCY_ID');
228: fnd_message.raise_error;
229: --
230: elsif (p_effective_date > l_date_to) then
231: hr_utility.set_location(l_proc, 35);
224: hr_utility.set_location(l_proc, 30);
225: if csr_vacancy_dates%notfound then
226: close csr_vacancy_dates;
227: fnd_message.set_name('PER','IRC_412032_RTM_INV_VACANCY_ID');
228: fnd_message.raise_error;
229: --
230: elsif (p_effective_date > l_date_to) then
231: hr_utility.set_location(l_proc, 35);
232: close csr_vacancy_dates;
229: --
230: elsif (p_effective_date > l_date_to) then
231: hr_utility.set_location(l_proc, 35);
232: close csr_vacancy_dates;
233: fnd_message.set_name('PER','IRC_412132_CLOSED_VACANCY_ID');
234: fnd_message.raise_error;
235: --
236: elsif (l_date_from > p_effective_date and p_consideration_status = 'PURSUE')
237: then
230: elsif (p_effective_date > l_date_to) then
231: hr_utility.set_location(l_proc, 35);
232: close csr_vacancy_dates;
233: fnd_message.set_name('PER','IRC_412132_CLOSED_VACANCY_ID');
234: fnd_message.raise_error;
235: --
236: elsif (l_date_from > p_effective_date and p_consideration_status = 'PURSUE')
237: then
238: hr_utility.set_location(l_proc, 37);
236: elsif (l_date_from > p_effective_date and p_consideration_status = 'PURSUE')
237: then
238: hr_utility.set_location(l_proc, 37);
239: close csr_vacancy_dates;
240: fnd_message.set_name('PER','IRC_FUTURE_VACANCY_ID');
241: fnd_message.raise_error;
242: --
243: end if;
244: close csr_vacancy_dates;
237: then
238: hr_utility.set_location(l_proc, 37);
239: close csr_vacancy_dates;
240: fnd_message.set_name('PER','IRC_FUTURE_VACANCY_ID');
241: fnd_message.raise_error;
242: --
243: end if;
244: close csr_vacancy_dates;
245: --
317: fetch csr_person_id into l_party_id;
318: hr_utility.set_location(l_proc, 30);
319: if csr_person_id%notfound then
320: close csr_person_id;
321: fnd_message.set_name('PER','IRC_412157_PARTY_PERS_MISMTCH');
322: fnd_message.raise_error;
323: end if;
324: close csr_person_id;
325: if p_party_id is not null then
318: hr_utility.set_location(l_proc, 30);
319: if csr_person_id%notfound then
320: close csr_person_id;
321: fnd_message.set_name('PER','IRC_412157_PARTY_PERS_MISMTCH');
322: fnd_message.raise_error;
323: end if;
324: close csr_person_id;
325: if p_party_id is not null then
326: if p_party_id<>l_party_id then
323: end if;
324: close csr_person_id;
325: if p_party_id is not null then
326: if p_party_id<>l_party_id then
327: fnd_message.set_name('PER','IRC_412033_RTM_INV_PARTY_ID');
328: fnd_message.raise_error;
329: end if;
330: else
331: p_party_id:=l_party_id;
324: close csr_person_id;
325: if p_party_id is not null then
326: if p_party_id<>l_party_id then
327: fnd_message.set_name('PER','IRC_412033_RTM_INV_PARTY_ID');
328: fnd_message.raise_error;
329: end if;
330: else
331: p_party_id:=l_party_id;
332: end if;
337: fetch csr_not_pref into l_var;
338: hr_utility.set_location(l_proc, 40);
339: if csr_not_pref%notfound then
340: close csr_not_pref;
341: fnd_message.set_name('PER','IRC_412047_IVC_NO_ALLOW_ACCESS');
342: fnd_message.raise_error;
343: end if;
344: close csr_not_pref;
345: --
338: hr_utility.set_location(l_proc, 40);
339: if csr_not_pref%notfound then
340: close csr_not_pref;
341: fnd_message.set_name('PER','IRC_412047_IVC_NO_ALLOW_ACCESS');
342: fnd_message.raise_error;
343: end if;
344: close csr_not_pref;
345: --
346: hr_utility.set_location(' Leaving:'||l_proc,70);
420: ,p_consideration_status
421: );
422: hr_utility.set_location(l_proc, 30);
423: if (l_var = true) then
424: fnd_message.set_name('PER','IRC_412048_IVC_INV_CONS_STATUS');
425: fnd_message.raise_error;
426: end if;
427: --
428: -- Check that the updated consideration status value is 'Pursue' if the
421: );
422: hr_utility.set_location(l_proc, 30);
423: if (l_var = true) then
424: fnd_message.set_name('PER','IRC_412048_IVC_INV_CONS_STATUS');
425: fnd_message.raise_error;
426: end if;
427: --
428: -- Check that the updated consideration status value is 'Pursue' if the
429: -- old value was 'Pursue'
430: --
431: hr_utility.set_location(l_proc, 40);
432: if(l_api_updating and irc_ivc_shd.g_old_rec.consideration_status = 'PURSUE'
433: and (p_consideration_status <> 'PURSUE')) then
434: fnd_message.set_name('PER','IRC_412049_IVC_INV_UPD_CONS_ST');
435: fnd_message.raise_error;
436: end if;
437: end if;
438: hr_utility.set_location(' Leaving:'||l_proc,50);
431: hr_utility.set_location(l_proc, 40);
432: if(l_api_updating and irc_ivc_shd.g_old_rec.consideration_status = 'PURSUE'
433: and (p_consideration_status <> 'PURSUE')) then
434: fnd_message.set_name('PER','IRC_412049_IVC_INV_UPD_CONS_ST');
435: fnd_message.raise_error;
436: end if;
437: end if;
438: hr_utility.set_location(' Leaving:'||l_proc,50);
439: --