129: p_effective_date => p_effective_date) then
130: --
131: -- raise error as does not exist as lookup
132: --
133: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
134: fnd_message.set_token('FIELD','p_batch_exe_cd');
135: fnd_message.set_token('TYPE','BEN_BATCH_EXE');
136: fnd_message.raise_error;
137: --
130: --
131: -- raise error as does not exist as lookup
132: --
133: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
134: fnd_message.set_token('FIELD','p_batch_exe_cd');
135: fnd_message.set_token('TYPE','BEN_BATCH_EXE');
136: fnd_message.raise_error;
137: --
138: end if;
131: -- raise error as does not exist as lookup
132: --
133: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
134: fnd_message.set_token('FIELD','p_batch_exe_cd');
135: fnd_message.set_token('TYPE','BEN_BATCH_EXE');
136: fnd_message.raise_error;
137: --
138: end if;
139: --
132: --
133: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
134: fnd_message.set_token('FIELD','p_batch_exe_cd');
135: fnd_message.set_token('TYPE','BEN_BATCH_EXE');
136: fnd_message.raise_error;
137: --
138: end if;
139: --
140: end if;
197: if p_thread_cnt_num not between 1 and 80 then
198: --
199: -- raise error as too large a value for the number of threads.
200: --
201: fnd_message.set_name('BEN','BEN_91934_NUMBER_OF_THREADS');
202: fnd_message.raise_error;
203: --
204: end if;
205: --
198: --
199: -- raise error as too large a value for the number of threads.
200: --
201: fnd_message.set_name('BEN','BEN_91934_NUMBER_OF_THREADS');
202: fnd_message.raise_error;
203: --
204: end if;
205: --
206: end if;
216: if p_max_err_num not between 0 and 90000 then
217: --
218: -- raise error as too large a value for the number of errors.
219: --
220: fnd_message.set_name('BEN','BEN_91935_MAX_NUMBER_ERRORS');
221: fnd_message.raise_error;
222: --
223: end if;
224: --
217: --
218: -- raise error as too large a value for the number of errors.
219: --
220: fnd_message.set_name('BEN','BEN_91935_MAX_NUMBER_ERRORS');
221: fnd_message.raise_error;
222: --
223: end if;
224: --
225: end if;
235: if p_chunk_size not between 1 and 200 then
236: --
237: -- raise error as too large a value for the number of threads.
238: --
239: fnd_message.set_name('BEN','BEN_91936_CHUNK_SIZE');
240: fnd_message.raise_error;
241: --
242: end if;
243: --
236: --
237: -- raise error as too large a value for the number of threads.
238: --
239: fnd_message.set_name('BEN','BEN_91936_CHUNK_SIZE');
240: fnd_message.raise_error;
241: --
242: end if;
243: --
244: end if;
309: fetch c1 into l_dummy;
310: if c1%found then
311: --
312: close c1;
313: fnd_message.set_name('BEN','BEN_91937_RECORD_ALREADY_SAVED');
314: fnd_message.raise_error;
315: --
316: end if;
317: --
310: if c1%found then
311: --
312: close c1;
313: fnd_message.set_name('BEN','BEN_91937_RECORD_ALREADY_SAVED');
314: fnd_message.raise_error;
315: --
316: end if;
317: --
318: close c1;