60: close csr_sec_grp;
61: --
62: -- The primary key is invalid therefore we must error
63: --
64: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
65: hr_multi_message.add
66: (p_associated_column1
67: => nvl(p_associated_column1,'LEARNING_PATH_SECTION_ID')
68: );
141: --
142: -- The primary key is invalid therefore we must error
143: --
144: close csr_leg_code;
145: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
146: fnd_message.raise_error;
147: end if;
148: hr_utility.set_location(l_proc,30);
149: --
142: -- The primary key is invalid therefore we must error
143: --
144: close csr_leg_code;
145: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
146: fnd_message.raise_error;
147: end if;
148: hr_utility.set_location(l_proc,30);
149: --
150: -- Set the global variables so the values are
337: IF NOT ota_lpc_shd.api_updating
338: (p_learning_path_section_id => p_rec.learning_path_section_id
339: ,p_object_version_number => p_rec.object_version_number
340: ) THEN
341: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
342: fnd_message.set_token('PROCEDURE ', l_proc);
343: fnd_message.set_token('STEP ', '5');
344: fnd_message.raise_error;
345: END IF;
338: (p_learning_path_section_id => p_rec.learning_path_section_id
339: ,p_object_version_number => p_rec.object_version_number
340: ) THEN
341: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
342: fnd_message.set_token('PROCEDURE ', l_proc);
343: fnd_message.set_token('STEP ', '5');
344: fnd_message.raise_error;
345: END IF;
346: --
339: ,p_object_version_number => p_rec.object_version_number
340: ) THEN
341: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
342: fnd_message.set_token('PROCEDURE ', l_proc);
343: fnd_message.set_token('STEP ', '5');
344: fnd_message.raise_error;
345: END IF;
346: --
347: -- EDIT_HERE: Add checks to ensure non-updateable args have
340: ) THEN
341: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
342: fnd_message.set_token('PROCEDURE ', l_proc);
343: fnd_message.set_token('STEP ', '5');
344: fnd_message.raise_error;
345: END IF;
346: --
347: -- EDIT_HERE: Add checks to ensure non-updateable args have
348: -- not been updated.
371: hr_utility.set_location('Entering:'|| v_proc, 5);
372: --
373: -- ** TEMP ** Add error message with the following text.
374: --
375: fnd_message.set_name ( p_error_appl ,p_error_txt);
376: fnd_message.raise_error;
377: --
378: hr_utility.set_location(' Leaving:'|| v_proc, 10);
379: --
372: --
373: -- ** TEMP ** Add error message with the following text.
374: --
375: fnd_message.set_name ( p_error_appl ,p_error_txt);
376: fnd_message.raise_error;
377: --
378: hr_utility.set_location(' Leaving:'|| v_proc, 10);
379: --
380: End call_error_message;
669: --
670: hr_utility.set_location('Entering:'|| v_proc, 5);
671: --Added for Bug#3861877
672: IF NOT p_no_of_mandatory_courses > 0 THEN
673: fnd_message.set_name('OTA','OTA_443368_POSITIVE_NUMBER');
674: fnd_message.raise_error;
675: END IF;
676: --
677: Open sel_lpm_count;
670: hr_utility.set_location('Entering:'|| v_proc, 5);
671: --Added for Bug#3861877
672: IF NOT p_no_of_mandatory_courses > 0 THEN
673: fnd_message.set_name('OTA','OTA_443368_POSITIVE_NUMBER');
674: fnd_message.raise_error;
675: END IF;
676: --
677: Open sel_lpm_count;
678: fetch sel_lpm_count into v_count;