146: -- The previous 'old' created row has not been found. We need
147: -- to error as an internal datetrack problem exists.
148: --
149: Close C_Sel1;
150: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
151: fnd_message.set_token('PROCEDURE', l_proc);
152: fnd_message.set_token('STEP','10');
153: fnd_message.raise_error;
154: End If;
147: -- to error as an internal datetrack problem exists.
148: --
149: Close C_Sel1;
150: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
151: fnd_message.set_token('PROCEDURE', l_proc);
152: fnd_message.set_token('STEP','10');
153: fnd_message.raise_error;
154: End If;
155: Close C_Sel1;
148: --
149: Close C_Sel1;
150: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
151: fnd_message.set_token('PROCEDURE', l_proc);
152: fnd_message.set_token('STEP','10');
153: fnd_message.raise_error;
154: End If;
155: Close C_Sel1;
156: --
149: Close C_Sel1;
150: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
151: fnd_message.set_token('PROCEDURE', l_proc);
152: fnd_message.set_token('STEP','10');
153: fnd_message.raise_error;
154: End If;
155: Close C_Sel1;
156: --
157: --
347: ,p_argument => 'order_number'
348: ,p_argument_value => p_order_number
349: );
350: if(p_order_number < 1) then
351: fnd_message.set_name('PER','AME_400565_INVALID_ORDER_NUM');
352: fnd_message.raise_error;
353: end if;
354: END if;
355: exception
348: ,p_argument_value => p_order_number
349: );
350: if(p_order_number < 1) then
351: fnd_message.set_name('PER','AME_400565_INVALID_ORDER_NUM');
352: fnd_message.raise_error;
353: end if;
354: END if;
355: exception
356: when app_exception.application_exception then
437: Close C_Sel2;
438: --
439: -- The primary key values are already in use.
440: --
441: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
442: fnd_message.set_token('TABLE_NAME','ame_action_type_config');
443: fnd_message.raise_error;
444: End If;
445: Close C_Sel2;
438: --
439: -- The primary key values are already in use.
440: --
441: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
442: fnd_message.set_token('TABLE_NAME','ame_action_type_config');
443: fnd_message.raise_error;
444: End If;
445: Close C_Sel2;
446: --
439: -- The primary key values are already in use.
440: --
441: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
442: fnd_message.set_token('TABLE_NAME','ame_action_type_config');
443: fnd_message.raise_error;
444: End If;
445: Close C_Sel2;
446: --
447: -- Use registered key values and clear globals