359: hr_data_pump.entry('call');
360: open cr;
361: fetch cr into c;
362: if cr%notfound then
363: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
364: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
365: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
366: hr_utility.set_message_token('VALUE',p_batch_line_id);
367: hr_utility.raise_error;
360: open cr;
361: fetch cr into c;
362: if cr%notfound then
363: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
364: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
365: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
366: hr_utility.set_message_token('VALUE',p_batch_line_id);
367: hr_utility.raise_error;
368: end if;
361: fetch cr into c;
362: if cr%notfound then
363: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
364: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
365: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
366: hr_utility.set_message_token('VALUE',p_batch_line_id);
367: hr_utility.raise_error;
368: end if;
369: --
362: if cr%notfound then
363: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
364: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
365: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
366: hr_utility.set_message_token('VALUE',p_batch_line_id);
367: hr_utility.raise_error;
368: end if;
369: --
370: if upper(c.p2) = 'TRUE' then
363: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
364: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
365: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
366: hr_utility.set_message_token('VALUE',p_batch_line_id);
367: hr_utility.raise_error;
368: end if;
369: --
370: if upper(c.p2) = 'TRUE' then
371: L_VALIDATE_COUNTY := true;
371: L_VALIDATE_COUNTY := true;
372: elsif upper(c.p2) = 'FALSE' then
373: L_VALIDATE_COUNTY := false;
374: elsif c.p2 is not null then
375: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
376: hr_utility.set_message_token('TYPE','BOOLEAN');
377: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');
378: hr_utility.set_message_token('VALUE',c.p2);
379: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
372: elsif upper(c.p2) = 'FALSE' then
373: L_VALIDATE_COUNTY := false;
374: elsif c.p2 is not null then
375: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
376: hr_utility.set_message_token('TYPE','BOOLEAN');
377: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');
378: hr_utility.set_message_token('VALUE',c.p2);
379: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
380: hr_utility.raise_error;
373: L_VALIDATE_COUNTY := false;
374: elsif c.p2 is not null then
375: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
376: hr_utility.set_message_token('TYPE','BOOLEAN');
377: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');
378: hr_utility.set_message_token('VALUE',c.p2);
379: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
380: hr_utility.raise_error;
381: end if;
374: elsif c.p2 is not null then
375: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
376: hr_utility.set_message_token('TYPE','BOOLEAN');
377: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');
378: hr_utility.set_message_token('VALUE',c.p2);
379: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
380: hr_utility.raise_error;
381: end if;
382: --
375: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
376: hr_utility.set_message_token('TYPE','BOOLEAN');
377: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');
378: hr_utility.set_message_token('VALUE',c.p2);
379: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
380: hr_utility.raise_error;
381: end if;
382: --
383: L_COMMENTS := c.plongval;
376: hr_utility.set_message_token('TYPE','BOOLEAN');
377: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');
378: hr_utility.set_message_token('VALUE',c.p2);
379: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
380: hr_utility.raise_error;
381: end if;
382: --
383: L_COMMENTS := c.plongval;
384: if L_COMMENTS = cn then