63: open csr_name;
64: fetch csr_name into l_key,l_key2;
65: if(csr_name%notfound) then
66: close csr_name;
67: fnd_message.set_name('PER', 'AME_400497_INVALID_CONDITION');
68: fnd_message.raise_error;
69: elsif(l_key2 <> ame_util.stringAttributeType) then
70: close csr_name;
71: fnd_message.set_name('PER', 'AME_400508_ATTR_TYP_NOT_STR');
64: fetch csr_name into l_key,l_key2;
65: if(csr_name%notfound) then
66: close csr_name;
67: fnd_message.set_name('PER', 'AME_400497_INVALID_CONDITION');
68: fnd_message.raise_error;
69: elsif(l_key2 <> ame_util.stringAttributeType) then
70: close csr_name;
71: fnd_message.set_name('PER', 'AME_400508_ATTR_TYP_NOT_STR');
72: fnd_message.raise_error;
67: fnd_message.set_name('PER', 'AME_400497_INVALID_CONDITION');
68: fnd_message.raise_error;
69: elsif(l_key2 <> ame_util.stringAttributeType) then
70: close csr_name;
71: fnd_message.set_name('PER', 'AME_400508_ATTR_TYP_NOT_STR');
72: fnd_message.raise_error;
73: end if;
74: close csr_name;
75: hr_utility.set_location(' Leaving:'||l_proc,30);
68: fnd_message.raise_error;
69: elsif(l_key2 <> ame_util.stringAttributeType) then
70: close csr_name;
71: fnd_message.set_name('PER', 'AME_400508_ATTR_TYP_NOT_STR');
72: fnd_message.raise_error;
73: end if;
74: close csr_name;
75: hr_utility.set_location(' Leaving:'||l_proc,30);
76: exception
132: Begin
133: hr_utility.set_location('Entering:'||l_proc,10);
134:
135: if(p_string_value is null) then
136: fnd_message.set_name('PER','AME_400526_STR_COND_STR_NULL');
137: fnd_message.raise_error;
138: end if;
139: -- Check if String Value is NULL
140:
133: hr_utility.set_location('Entering:'||l_proc,10);
134:
135: if(p_string_value is null) then
136: fnd_message.set_name('PER','AME_400526_STR_COND_STR_NULL');
137: fnd_message.raise_error;
138: end if;
139: -- Check if String Value is NULL
140:
141: hr_api.mandatory_arg_error(p_api_name => l_proc
146: open csr_name;
147: fetch csr_name into l_key;
148: if(csr_name%found) then
149: close csr_name;
150: fnd_message.set_name('PER', 'AME_400509_DUP_STRVAL_CON');
151: fnd_message.raise_error;
152: end if;
153: close csr_name;
154: hr_utility.set_location(' Leaving:'||l_proc,30);
147: fetch csr_name into l_key;
148: if(csr_name%found) then
149: close csr_name;
150: fnd_message.set_name('PER', 'AME_400509_DUP_STRVAL_CON');
151: fnd_message.raise_error;
152: end if;
153: close csr_name;
154: hr_utility.set_location(' Leaving:'||l_proc,30);
155: exception
207: ,p_string_value => p_rec.string_value
208: ,p_effective_date => p_effective_date
209: ,p_object_version_number => p_rec.object_version_number
210: ) THEN
211: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
212: fnd_message.set_token('PROCEDURE ', l_proc);
213: fnd_message.set_token('STEP ', '5');
214: fnd_message.raise_error;
215: END IF;
208: ,p_effective_date => p_effective_date
209: ,p_object_version_number => p_rec.object_version_number
210: ) THEN
211: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
212: fnd_message.set_token('PROCEDURE ', l_proc);
213: fnd_message.set_token('STEP ', '5');
214: fnd_message.raise_error;
215: END IF;
216: --
209: ,p_object_version_number => p_rec.object_version_number
210: ) THEN
211: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
212: fnd_message.set_token('PROCEDURE ', l_proc);
213: fnd_message.set_token('STEP ', '5');
214: fnd_message.raise_error;
215: END IF;
216: --
217: -- EDIT_HERE: Add checks to ensure non-updateable args have
210: ) THEN
211: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
212: fnd_message.set_token('PROCEDURE ', l_proc);
213: fnd_message.set_token('STEP ', '5');
214: fnd_message.raise_error;
215: END IF;
216: --
217: -- EDIT_HERE: Add checks to ensure non-updateable args have
218: -- not been updated.
309: --
310: -- An unhandled or unexpected error has occurred which
311: -- we must report
312: --
313: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
314: fnd_message.set_token('PROCEDURE', l_proc);
315: fnd_message.set_token('STEP','15');
316: fnd_message.raise_error;
317: End dt_update_validate;
310: -- An unhandled or unexpected error has occurred which
311: -- we must report
312: --
313: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
314: fnd_message.set_token('PROCEDURE', l_proc);
315: fnd_message.set_token('STEP','15');
316: fnd_message.raise_error;
317: End dt_update_validate;
318: --
311: -- we must report
312: --
313: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
314: fnd_message.set_token('PROCEDURE', l_proc);
315: fnd_message.set_token('STEP','15');
316: fnd_message.raise_error;
317: End dt_update_validate;
318: --
319: -- ----------------------------------------------------------------------------
312: --
313: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
314: fnd_message.set_token('PROCEDURE', l_proc);
315: fnd_message.set_token('STEP','15');
316: fnd_message.raise_error;
317: End dt_update_validate;
318: --
319: -- ----------------------------------------------------------------------------
320: -- |--------------------------< dt_delete_validate >--------------------------|
407: --
408: -- An unhandled or unexpected error has occurred which
409: -- we must report
410: --
411: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
412: fnd_message.set_token('PROCEDURE', l_proc);
413: fnd_message.set_token('STEP','15');
414: fnd_message.raise_error;
415: --
408: -- An unhandled or unexpected error has occurred which
409: -- we must report
410: --
411: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
412: fnd_message.set_token('PROCEDURE', l_proc);
413: fnd_message.set_token('STEP','15');
414: fnd_message.raise_error;
415: --
416: End dt_delete_validate;
409: -- we must report
410: --
411: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
412: fnd_message.set_token('PROCEDURE', l_proc);
413: fnd_message.set_token('STEP','15');
414: fnd_message.raise_error;
415: --
416: End dt_delete_validate;
417: --
410: --
411: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
412: fnd_message.set_token('PROCEDURE', l_proc);
413: fnd_message.set_token('STEP','15');
414: fnd_message.raise_error;
415: --
416: End dt_delete_validate;
417: --
418: -- ----------------------------------------------------------------------------