70: --
71: -- The primary key is invalid therefore we must error
72: --
73: close csr_leg_code;
74: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
75: fnd_message.raise_error;
76: end if;
77: hr_utility.set_location(l_proc,30);
78: --
71: -- The primary key is invalid therefore we must error
72: --
73: close csr_leg_code;
74: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
75: fnd_message.raise_error;
76: end if;
77: hr_utility.set_location(l_proc,30);
78: --
79: -- Set the global variables so the values are
129: IF NOT irc_ios_shd.api_updating
130: (p_offer_status_history_id => p_rec.offer_status_history_id
131: ,p_object_version_number => p_rec.object_version_number
132: ) THEN
133: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
134: fnd_message.set_token('PROCEDURE ', l_proc);
135: fnd_message.set_token('STEP ', '5');
136: fnd_message.raise_error;
137: END IF;
130: (p_offer_status_history_id => p_rec.offer_status_history_id
131: ,p_object_version_number => p_rec.object_version_number
132: ) THEN
133: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
134: fnd_message.set_token('PROCEDURE ', l_proc);
135: fnd_message.set_token('STEP ', '5');
136: fnd_message.raise_error;
137: END IF;
138: --
131: ,p_object_version_number => p_rec.object_version_number
132: ) THEN
133: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
134: fnd_message.set_token('PROCEDURE ', l_proc);
135: fnd_message.set_token('STEP ', '5');
136: fnd_message.raise_error;
137: END IF;
138: --
139: if irc_ios_shd.g_old_rec.offer_status_history_id <>
132: ) THEN
133: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
134: fnd_message.set_token('PROCEDURE ', l_proc);
135: fnd_message.set_token('STEP ', '5');
136: fnd_message.raise_error;
137: END IF;
138: --
139: if irc_ios_shd.g_old_rec.offer_status_history_id <>
140: p_rec.offer_status_history_id
233: fetch csr_offer into l_offer_id;
234: hr_utility.set_location(l_proc,20);
235: if csr_offer%NOTFOUND then
236: close csr_offer;
237: fnd_message.set_name ('PER','IRC_412322_INVALID_OFFER_ID');
238: fnd_message.raise_error;
239: end if;
240: close csr_offer;
241: --
234: hr_utility.set_location(l_proc,20);
235: if csr_offer%NOTFOUND then
236: close csr_offer;
237: fnd_message.set_name ('PER','IRC_412322_INVALID_OFFER_ID');
238: fnd_message.raise_error;
239: end if;
240: close csr_offer;
241: --
242: hr_utility.set_location(' Leaving:'|| l_proc, 30);