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: --
315: l_temp_count := l_temp_count + 1;
316: p_order_number := l_temp_count;
317: else
318: if(p_order_number < 1) then
319: fnd_message.set_name('PER','AME_400565_INVALID_ORDER_NUM');
320: fnd_message.raise_error;
321: end if;
322: end if;
323: exception
316: p_order_number := l_temp_count;
317: else
318: if(p_order_number < 1) then
319: fnd_message.set_name('PER','AME_400565_INVALID_ORDER_NUM');
320: fnd_message.raise_error;
321: end if;
322: end if;
323: exception
324: when app_exception.application_exception then
406: Close C_Sel2;
407: --
408: -- The primary key values are already in use.
409: --
410: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
411: fnd_message.set_token('TABLE_NAME','ame_approval_group_config');
412: fnd_message.raise_error;
413: End If;
414: Close C_Sel2;
407: --
408: -- The primary key values are already in use.
409: --
410: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
411: fnd_message.set_token('TABLE_NAME','ame_approval_group_config');
412: fnd_message.raise_error;
413: End If;
414: Close C_Sel2;
415: --
408: -- The primary key values are already in use.
409: --
410: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
411: fnd_message.set_token('TABLE_NAME','ame_approval_group_config');
412: fnd_message.raise_error;
413: End If;
414: Close C_Sel2;
415: --
416: -- Use registered key values and clear globals