147: -- The previous 'old' created row has not been found. We need
148: -- to error as an internal datetrack problem exists.
149: --
150: Close C_Sel1;
151: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
152: fnd_message.set_token('PROCEDURE', l_proc);
153: fnd_message.set_token('STEP','10');
154: fnd_message.raise_error;
155: End If;
148: -- to error as an internal datetrack problem exists.
149: --
150: Close C_Sel1;
151: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
152: fnd_message.set_token('PROCEDURE', l_proc);
153: fnd_message.set_token('STEP','10');
154: fnd_message.raise_error;
155: End If;
156: Close C_Sel1;
149: --
150: Close C_Sel1;
151: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
152: fnd_message.set_token('PROCEDURE', l_proc);
153: fnd_message.set_token('STEP','10');
154: fnd_message.raise_error;
155: End If;
156: Close C_Sel1;
157: --
150: Close C_Sel1;
151: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
152: fnd_message.set_token('PROCEDURE', l_proc);
153: fnd_message.set_token('STEP','10');
154: fnd_message.raise_error;
155: End If;
156: Close C_Sel1;
157: --
158: --
355: Close C_Sel2;
356: --
357: -- The primary key values are already in use.
358: --
359: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
360: fnd_message.set_token('TABLE_NAME','ame_condition_usages');
361: fnd_message.raise_error;
362: End If;
363: Close C_Sel2;
356: --
357: -- The primary key values are already in use.
358: --
359: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
360: fnd_message.set_token('TABLE_NAME','ame_condition_usages');
361: fnd_message.raise_error;
362: End If;
363: Close C_Sel2;
364: --
357: -- The primary key values are already in use.
358: --
359: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
360: fnd_message.set_token('TABLE_NAME','ame_condition_usages');
361: fnd_message.raise_error;
362: End If;
363: Close C_Sel2;
364: --
365: -- Use registered key values and clear globals
541: for update of end_date nowait;
542: exception
543: when others then
544: --
545: fnd_message.set_name('PER', 'AME_99999_CANT_LOCK_PARENT');
546: fnd_message.set_token('PROCEDURE', l_proc);
547: fnd_message.set_token('STEP','40');
548: fnd_message.raise_error;
549: end;
542: exception
543: when others then
544: --
545: fnd_message.set_name('PER', 'AME_99999_CANT_LOCK_PARENT');
546: fnd_message.set_token('PROCEDURE', l_proc);
547: fnd_message.set_token('STEP','40');
548: fnd_message.raise_error;
549: end;
550: --
543: when others then
544: --
545: fnd_message.set_name('PER', 'AME_99999_CANT_LOCK_PARENT');
546: fnd_message.set_token('PROCEDURE', l_proc);
547: fnd_message.set_token('STEP','40');
548: fnd_message.raise_error;
549: end;
550: --
551: hr_utility.set_location(' Leaving:'||l_proc, 10);
544: --
545: fnd_message.set_name('PER', 'AME_99999_CANT_LOCK_PARENT');
546: fnd_message.set_token('PROCEDURE', l_proc);
547: fnd_message.set_token('STEP','40');
548: fnd_message.raise_error;
549: end;
550: --
551: hr_utility.set_location(' Leaving:'||l_proc, 10);
552: End ins_lck;