59: close csr_sec_grp;
60: --
61: -- The primary key is invalid therefore we must error
62: --
63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
64: hr_multi_message.add
65: (p_associated_column1
66: => nvl(p_associated_column1,'FORUM_ID')
67: );
140: --
141: -- The primary key is invalid therefore we must error
142: --
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
141: -- The primary key is invalid therefore we must error
142: --
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
149: -- Set the global variables so the values are
199: IF NOT ota_frm_shd.api_updating
200: (p_forum_id => p_rec.forum_id
201: ,p_object_version_number => p_rec.object_version_number
202: ) THEN
203: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
204: fnd_message.set_token('PROCEDURE ', l_proc);
205: fnd_message.set_token('STEP ', '5');
206: fnd_message.raise_error;
207: END IF;
200: (p_forum_id => p_rec.forum_id
201: ,p_object_version_number => p_rec.object_version_number
202: ) THEN
203: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
204: fnd_message.set_token('PROCEDURE ', l_proc);
205: fnd_message.set_token('STEP ', '5');
206: fnd_message.raise_error;
207: END IF;
208: --
201: ,p_object_version_number => p_rec.object_version_number
202: ) THEN
203: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
204: fnd_message.set_token('PROCEDURE ', l_proc);
205: fnd_message.set_token('STEP ', '5');
206: fnd_message.raise_error;
207: END IF;
208: --
209: -- EDIT_HERE: Add checks to ensure non-updateable args have
202: ) THEN
203: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
204: fnd_message.set_token('PROCEDURE ', l_proc);
205: fnd_message.set_token('STEP ', '5');
206: fnd_message.raise_error;
207: END IF;
208: --
209: -- EDIT_HERE: Add checks to ensure non-updateable args have
210: -- not been updated.
307: IF ( l_cat_start_date > p_start_date
308: or nvl(l_cat_end_date,hr_api.g_eot) < nvl(p_end_date,hr_api.g_eot)
309: ) THEN
310: --
311: fnd_message.set_name ( 'OTA','OTA_443785_FRM_OUTOF_CAT_DATES');
312: fnd_message.raise_error;
313: --
314: End IF;
315: ELSE
308: or nvl(l_cat_end_date,hr_api.g_eot) < nvl(p_end_date,hr_api.g_eot)
309: ) THEN
310: --
311: fnd_message.set_name ( 'OTA','OTA_443785_FRM_OUTOF_CAT_DATES');
312: fnd_message.raise_error;
313: --
314: End IF;
315: ELSE
316: CLOSE csr_cat_start_end_date;
378:
379: IF NOT (trunc(nvl(l_cat_end_date,sysdate)) < trunc(sysdate)) then
380: IF (trunc(nvl(p_end_date,sysdate)) < trunc(sysdate)) THEN
381: --
382: fnd_message.set_name ( 'OTA','OTA_443992_FRM_END_DATE_ERR');
383: fnd_message.raise_error;
384: End IF;
385: End IF;
386: CLOSE csr_cat_start_end_date;
379: IF NOT (trunc(nvl(l_cat_end_date,sysdate)) < trunc(sysdate)) then
380: IF (trunc(nvl(p_end_date,sysdate)) < trunc(sysdate)) THEN
381: --
382: fnd_message.set_name ( 'OTA','OTA_443992_FRM_END_DATE_ERR');
383: fnd_message.raise_error;
384: End IF;
385: End IF;
386: CLOSE csr_cat_start_end_date;
387: