200: hr_data_pump.entry('call');
201: open cr;
202: fetch cr into c;
203: if cr%notfound then
204: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
205: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
206: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
207: hr_utility.set_message_token('VALUE',p_batch_line_id);
208: hr_utility.raise_error;
201: open cr;
202: fetch cr into c;
203: if cr%notfound then
204: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
205: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
206: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
207: hr_utility.set_message_token('VALUE',p_batch_line_id);
208: hr_utility.raise_error;
209: end if;
202: fetch cr into c;
203: if cr%notfound then
204: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
205: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
206: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
207: hr_utility.set_message_token('VALUE',p_batch_line_id);
208: hr_utility.raise_error;
209: end if;
210: --
203: if cr%notfound then
204: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
205: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
206: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
207: hr_utility.set_message_token('VALUE',p_batch_line_id);
208: hr_utility.raise_error;
209: end if;
210: --
211: if c.p14 is null then
204: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
205: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
206: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
207: hr_utility.set_message_token('VALUE',p_batch_line_id);
208: hr_utility.raise_error;
209: end if;
210: --
211: if c.p14 is null then
212: L_PERSON_ID:=nn;