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: --
351: Close C_Sel2;
352: --
353: -- The primary key values are already in use.
354: --
355: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
356: fnd_message.set_token('TABLE_NAME','ame_action_usages');
357: fnd_message.raise_error;
358: End If;
359: Close C_Sel2;
352: --
353: -- The primary key values are already in use.
354: --
355: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
356: fnd_message.set_token('TABLE_NAME','ame_action_usages');
357: fnd_message.raise_error;
358: End If;
359: Close C_Sel2;
360: --
353: -- The primary key values are already in use.
354: --
355: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
356: fnd_message.set_token('TABLE_NAME','ame_action_usages');
357: fnd_message.raise_error;
358: End If;
359: Close C_Sel2;
360: --
361: -- Use registered key values and clear globals
535: for update of end_date nowait;
536: exception
537: when others then
538: --
539: fnd_message.set_name('PER', 'AME_99999_CANT_LOCK_PARENT');
540: fnd_message.set_token('PROCEDURE', l_proc);
541: fnd_message.set_token('STEP','40');
542: fnd_message.raise_error;
543: end;
536: exception
537: when others then
538: --
539: fnd_message.set_name('PER', 'AME_99999_CANT_LOCK_PARENT');
540: fnd_message.set_token('PROCEDURE', l_proc);
541: fnd_message.set_token('STEP','40');
542: fnd_message.raise_error;
543: end;
544: --
537: when others then
538: --
539: fnd_message.set_name('PER', 'AME_99999_CANT_LOCK_PARENT');
540: fnd_message.set_token('PROCEDURE', l_proc);
541: fnd_message.set_token('STEP','40');
542: fnd_message.raise_error;
543: end;
544: --
545: hr_utility.set_location(' Leaving:'||l_proc, 10);
538: --
539: fnd_message.set_name('PER', 'AME_99999_CANT_LOCK_PARENT');
540: fnd_message.set_token('PROCEDURE', l_proc);
541: fnd_message.set_token('STEP','40');
542: fnd_message.raise_error;
543: end;
544: --
545: hr_utility.set_location(' Leaving:'||l_proc, 10);
546: --