149: hr_data_pump.entry('call');
150: open cr;
151: fetch cr into c;
152: if cr%notfound then
153: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
154: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
155: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
156: hr_utility.set_message_token('VALUE',p_batch_line_id);
157: hr_utility.raise_error;
150: open cr;
151: fetch cr into c;
152: if cr%notfound then
153: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
154: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
155: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
156: hr_utility.set_message_token('VALUE',p_batch_line_id);
157: hr_utility.raise_error;
158: end if;
151: fetch cr into c;
152: if cr%notfound then
153: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
154: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
155: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
156: hr_utility.set_message_token('VALUE',p_batch_line_id);
157: hr_utility.raise_error;
158: end if;
159: --
152: if cr%notfound then
153: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
154: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
155: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
156: hr_utility.set_message_token('VALUE',p_batch_line_id);
157: hr_utility.raise_error;
158: end if;
159: --
160: if upper(c.p5) = 'TRUE' then
153: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
154: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
155: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
156: hr_utility.set_message_token('VALUE',p_batch_line_id);
157: hr_utility.raise_error;
158: end if;
159: --
160: if upper(c.p5) = 'TRUE' then
161: L_MULTI_ROW_VALIDATE := true;
161: L_MULTI_ROW_VALIDATE := true;
162: elsif upper(c.p5) = 'FALSE' then
163: L_MULTI_ROW_VALIDATE := false;
164: elsif c.p5 is not null then
165: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
166: hr_utility.set_message_token('TYPE','BOOLEAN');
167: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_VALIDATE');
168: hr_utility.set_message_token('VALUE',c.p5);
169: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
162: elsif upper(c.p5) = 'FALSE' then
163: L_MULTI_ROW_VALIDATE := false;
164: elsif c.p5 is not null then
165: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
166: hr_utility.set_message_token('TYPE','BOOLEAN');
167: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_VALIDATE');
168: hr_utility.set_message_token('VALUE',c.p5);
169: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
170: hr_utility.raise_error;
163: L_MULTI_ROW_VALIDATE := false;
164: elsif c.p5 is not null then
165: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
166: hr_utility.set_message_token('TYPE','BOOLEAN');
167: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_VALIDATE');
168: hr_utility.set_message_token('VALUE',c.p5);
169: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
170: hr_utility.raise_error;
171: end if;
164: elsif c.p5 is not null then
165: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
166: hr_utility.set_message_token('TYPE','BOOLEAN');
167: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_VALIDATE');
168: hr_utility.set_message_token('VALUE',c.p5);
169: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
170: hr_utility.raise_error;
171: end if;
172: --
165: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
166: hr_utility.set_message_token('TYPE','BOOLEAN');
167: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_VALIDATE');
168: hr_utility.set_message_token('VALUE',c.p5);
169: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
170: hr_utility.raise_error;
171: end if;
172: --
173: if c.p6 is null then
166: hr_utility.set_message_token('TYPE','BOOLEAN');
167: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_VALIDATE');
168: hr_utility.set_message_token('VALUE',c.p5);
169: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
170: hr_utility.raise_error;
171: end if;
172: --
173: if c.p6 is null then
174: L_PRTT_ENRT_RSLT_ID:=nn;