383: hr_data_pump.entry('call');
384: open cr;
385: fetch cr into c;
386: if cr%notfound then
387: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
388: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
389: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
390: hr_utility.set_message_token('VALUE',p_batch_line_id);
391: hr_utility.raise_error;
384: open cr;
385: fetch cr into c;
386: if cr%notfound then
387: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
388: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
389: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
390: hr_utility.set_message_token('VALUE',p_batch_line_id);
391: hr_utility.raise_error;
392: end if;
385: fetch cr into c;
386: if cr%notfound then
387: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
388: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
389: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
390: hr_utility.set_message_token('VALUE',p_batch_line_id);
391: hr_utility.raise_error;
392: end if;
393: --
386: if cr%notfound then
387: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
388: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
389: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
390: hr_utility.set_message_token('VALUE',p_batch_line_id);
391: hr_utility.raise_error;
392: end if;
393: --
394: if upper(c.p2) = 'TRUE' then
387: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
388: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
389: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
390: hr_utility.set_message_token('VALUE',p_batch_line_id);
391: hr_utility.raise_error;
392: end if;
393: --
394: if upper(c.p2) = 'TRUE' then
395: L_VALIDATE_COUNTY := true;
395: L_VALIDATE_COUNTY := true;
396: elsif upper(c.p2) = 'FALSE' then
397: L_VALIDATE_COUNTY := false;
398: elsif c.p2 is not null then
399: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
400: hr_utility.set_message_token('TYPE','BOOLEAN');
401: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');
402: hr_utility.set_message_token('VALUE',c.p2);
403: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
396: elsif upper(c.p2) = 'FALSE' then
397: L_VALIDATE_COUNTY := false;
398: elsif c.p2 is not null then
399: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
400: hr_utility.set_message_token('TYPE','BOOLEAN');
401: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');
402: hr_utility.set_message_token('VALUE',c.p2);
403: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
404: hr_utility.raise_error;
397: L_VALIDATE_COUNTY := false;
398: elsif c.p2 is not null then
399: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
400: hr_utility.set_message_token('TYPE','BOOLEAN');
401: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');
402: hr_utility.set_message_token('VALUE',c.p2);
403: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
404: hr_utility.raise_error;
405: end if;
398: elsif c.p2 is not null then
399: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
400: hr_utility.set_message_token('TYPE','BOOLEAN');
401: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');
402: hr_utility.set_message_token('VALUE',c.p2);
403: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
404: hr_utility.raise_error;
405: end if;
406: --
399: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
400: hr_utility.set_message_token('TYPE','BOOLEAN');
401: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');
402: hr_utility.set_message_token('VALUE',c.p2);
403: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
404: hr_utility.raise_error;
405: end if;
406: --
407: L_COMMENTS := c.plongval;
400: hr_utility.set_message_token('TYPE','BOOLEAN');
401: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');
402: hr_utility.set_message_token('VALUE',c.p2);
403: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
404: hr_utility.raise_error;
405: end if;
406: --
407: L_COMMENTS := c.plongval;
408: if L_COMMENTS = cn then