191: hr_data_pump.entry('call');
192: open cr;
193: fetch cr into c;
194: if cr%notfound then
195: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
196: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
197: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
198: hr_utility.set_message_token('VALUE',p_batch_line_id);
199: hr_utility.raise_error;
192: open cr;
193: fetch cr into c;
194: if cr%notfound then
195: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
196: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
197: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
198: hr_utility.set_message_token('VALUE',p_batch_line_id);
199: hr_utility.raise_error;
200: end if;
193: fetch cr into c;
194: if cr%notfound then
195: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
196: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
197: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
198: hr_utility.set_message_token('VALUE',p_batch_line_id);
199: hr_utility.raise_error;
200: end if;
201: --
194: if cr%notfound then
195: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
196: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
197: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
198: hr_utility.set_message_token('VALUE',p_batch_line_id);
199: hr_utility.raise_error;
200: end if;
201: --
202: if c.p15 is null then
195: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
196: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
197: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
198: hr_utility.set_message_token('VALUE',p_batch_line_id);
199: hr_utility.raise_error;
200: end if;
201: --
202: if c.p15 is null then
203: L_PERSON_ID:=nn;