111: -- The previous 'old' created row has not been found. We need
112: -- to error as an internal datetrack problem exists.
113: --
114: Close C_Sel1;
115: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
116: fnd_message.set_token('PROCEDURE', l_proc);
117: fnd_message.set_token('STEP','10');
118: fnd_message.raise_error;
119: End If;
112: -- to error as an internal datetrack problem exists.
113: --
114: Close C_Sel1;
115: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
116: fnd_message.set_token('PROCEDURE', l_proc);
117: fnd_message.set_token('STEP','10');
118: fnd_message.raise_error;
119: End If;
120: Close C_Sel1;
113: --
114: Close C_Sel1;
115: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
116: fnd_message.set_token('PROCEDURE', l_proc);
117: fnd_message.set_token('STEP','10');
118: fnd_message.raise_error;
119: End If;
120: Close C_Sel1;
121: --
114: Close C_Sel1;
115: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
116: fnd_message.set_token('PROCEDURE', l_proc);
117: fnd_message.set_token('STEP','10');
118: fnd_message.raise_error;
119: End If;
120: Close C_Sel1;
121: --
122: -- Set the AOL updated WHO values
396: -- number.
397: p_rec.instnc_num := l_this_instnc;
398: elsif l_this_instnc > l_max_num then
399: -- there is a max and this one would exceed it, error out.
400: fnd_message.set_name('BEN','BEN_91883_PCD_TOO_MANY_TIMES');
401: fnd_message.raise_error;
402: else
403: -- there is a max and this one doesn't exceed it, set this one to the
404: -- next instance number.
397: p_rec.instnc_num := l_this_instnc;
398: elsif l_this_instnc > l_max_num then
399: -- there is a max and this one would exceed it, error out.
400: fnd_message.set_name('BEN','BEN_91883_PCD_TOO_MANY_TIMES');
401: fnd_message.raise_error;
402: else
403: -- there is a max and this one doesn't exceed it, set this one to the
404: -- next instance number.
405: p_rec.instnc_num := l_this_instnc;