83: close csr_sec_grp;
84: --
85: -- The primary key is invalid therefore we must error
86: --
87: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
88: hr_multi_message.add
89: (p_associated_column1
90: => nvl(p_associated_column1,'FORUM_ID')
91: ,p_associated_column2
192: --
193: -- The primary key is invalid therefore we must error
194: --
195: close csr_leg_code;
196: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
197: fnd_message.raise_error;
198: end if;
199: hr_utility.set_location(l_proc,30);
200: --
193: -- The primary key is invalid therefore we must error
194: --
195: close csr_leg_code;
196: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
197: fnd_message.raise_error;
198: end if;
199: hr_utility.set_location(l_proc,30);
200: --
201: -- Set the global variables so the values are
255: ,p_object_id => p_rec.object_id
256: ,p_object_type => p_rec.object_type
257: ,p_object_version_number => p_rec.object_version_number
258: ) THEN
259: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
260: fnd_message.set_token('PROCEDURE ', l_proc);
261: fnd_message.set_token('STEP ', '5');
262: fnd_message.raise_error;
263: END IF;
256: ,p_object_type => p_rec.object_type
257: ,p_object_version_number => p_rec.object_version_number
258: ) THEN
259: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
260: fnd_message.set_token('PROCEDURE ', l_proc);
261: fnd_message.set_token('STEP ', '5');
262: fnd_message.raise_error;
263: END IF;
264: --
257: ,p_object_version_number => p_rec.object_version_number
258: ) THEN
259: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
260: fnd_message.set_token('PROCEDURE ', l_proc);
261: fnd_message.set_token('STEP ', '5');
262: fnd_message.raise_error;
263: END IF;
264: --
265: -- EDIT_HERE: Add checks to ensure non-updateable args have
258: ) THEN
259: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
260: fnd_message.set_token('PROCEDURE ', l_proc);
261: fnd_message.set_token('STEP ', '5');
262: fnd_message.raise_error;
263: END IF;
264: --
265: -- EDIT_HERE: Add checks to ensure non-updateable args have
266: -- not been updated.
300: --
301: if sel_unique_key%found then
302: close sel_unique_key;
303:
304: fnd_message.set_name('OTA', 'OTA_13676_DCI_DUPLICATE');
305: fnd_message.raise_error;
306: end if;
307: close sel_unique_key;
308: --
301: if sel_unique_key%found then
302: close sel_unique_key;
303:
304: fnd_message.set_name('OTA', 'OTA_13676_DCI_DUPLICATE');
305: fnd_message.raise_error;
306: end if;
307: close sel_unique_key;
308: --
309: hr_utility.set_location(' Leaving:'|| v_proc, 10);
383: IF ( l_cat_start_date > l_forum_start_date
384: or l_cat_end_date < l_forum_end_date
385: ) THEN
386: --
387: fnd_message.set_name ( 'OTA','OTA_443785_FRM_OUTOF_CAT_DATES');
388: fnd_message.raise_error;
389: --
390: End IF;
391: ELSE
384: or l_cat_end_date < l_forum_end_date
385: ) THEN
386: --
387: fnd_message.set_name ( 'OTA','OTA_443785_FRM_OUTOF_CAT_DATES');
388: fnd_message.raise_error;
389: --
390: End IF;
391: ELSE
392: CLOSE csr_cat_start_end_date;
438: --
439: if sel_multiple_primary%found then
440: close sel_multiple_primary;
441:
442: fnd_message.set_name('OTA', 'OTA_13676_DCI_DUPLICATE');
443: fnd_message.raise_error;
444: end if;
445: close sel_multiple_primary;
446: --
439: if sel_multiple_primary%found then
440: close sel_multiple_primary;
441:
442: fnd_message.set_name('OTA', 'OTA_13676_DCI_DUPLICATE');
443: fnd_message.raise_error;
444: end if;
445: close sel_multiple_primary;
446: --
447: hr_utility.set_location(' Leaving:'|| v_proc, 10);
493: --
494: if sel_primary_category%found then
495: close sel_primary_category;
496:
497: fnd_message.set_name('OTA', 'OTA_443940_FRM_DEL_PRIMARY');
498: fnd_message.raise_error;
499: end if;
500: close sel_primary_category;
501: --
494: if sel_primary_category%found then
495: close sel_primary_category;
496:
497: fnd_message.set_name('OTA', 'OTA_443940_FRM_DEL_PRIMARY');
498: fnd_message.raise_error;
499: end if;
500: close sel_primary_category;
501: --
502: hr_utility.set_location(' Leaving:'|| v_proc, 10);