DBA Data[Home] [Help]

APPS.HRDPP_PROCESS_DEPENDENT dependencies on HR_UTILITY

Line 244: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');

240: hr_data_pump.entry('call');
241: open cr;
242: fetch cr into c;
243: if cr%notfound then
244: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
245: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
246: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
247: hr_utility.set_message_token('VALUE',p_batch_line_id);
248: hr_utility.raise_error;

Line 245: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');

241: open cr;
242: fetch cr into c;
243: if cr%notfound then
244: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
245: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
246: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
247: hr_utility.set_message_token('VALUE',p_batch_line_id);
248: hr_utility.raise_error;
249: end if;

Line 246: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');

242: fetch cr into c;
243: if cr%notfound then
244: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
245: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
246: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
247: hr_utility.set_message_token('VALUE',p_batch_line_id);
248: hr_utility.raise_error;
249: end if;
250: --

Line 247: hr_utility.set_message_token('VALUE',p_batch_line_id);

243: if cr%notfound then
244: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
245: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
246: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
247: hr_utility.set_message_token('VALUE',p_batch_line_id);
248: hr_utility.raise_error;
249: end if;
250: --
251: if upper(c.p5) = 'TRUE' then

Line 248: hr_utility.raise_error;

244: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
245: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
246: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
247: hr_utility.set_message_token('VALUE',p_batch_line_id);
248: hr_utility.raise_error;
249: end if;
250: --
251: if upper(c.p5) = 'TRUE' then
252: L_MULTI_ROW_ACTN := true;

Line 256: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');

252: L_MULTI_ROW_ACTN := true;
253: elsif upper(c.p5) = 'FALSE' then
254: L_MULTI_ROW_ACTN := false;
255: elsif c.p5 is not null then
256: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
257: hr_utility.set_message_token('TYPE','BOOLEAN');
258: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
259: hr_utility.set_message_token('VALUE',c.p5);
260: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');

Line 257: hr_utility.set_message_token('TYPE','BOOLEAN');

253: elsif upper(c.p5) = 'FALSE' then
254: L_MULTI_ROW_ACTN := false;
255: elsif c.p5 is not null then
256: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
257: hr_utility.set_message_token('TYPE','BOOLEAN');
258: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
259: hr_utility.set_message_token('VALUE',c.p5);
260: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
261: hr_utility.raise_error;

Line 258: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');

254: L_MULTI_ROW_ACTN := false;
255: elsif c.p5 is not null then
256: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
257: hr_utility.set_message_token('TYPE','BOOLEAN');
258: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
259: hr_utility.set_message_token('VALUE',c.p5);
260: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
261: hr_utility.raise_error;
262: end if;

Line 259: hr_utility.set_message_token('VALUE',c.p5);

255: elsif c.p5 is not null then
256: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
257: hr_utility.set_message_token('TYPE','BOOLEAN');
258: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
259: hr_utility.set_message_token('VALUE',c.p5);
260: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
261: hr_utility.raise_error;
262: end if;
263: --

Line 260: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');

256: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
257: hr_utility.set_message_token('TYPE','BOOLEAN');
258: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
259: hr_utility.set_message_token('VALUE',c.p5);
260: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
261: hr_utility.raise_error;
262: end if;
263: --
264: L_PERSON_ID :=

Line 261: hr_utility.raise_error;

257: hr_utility.set_message_token('TYPE','BOOLEAN');
258: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
259: hr_utility.set_message_token('VALUE',c.p5);
260: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
261: hr_utility.raise_error;
262: end if;
263: --
264: L_PERSON_ID :=
265: BEN_PUMP_GET.GET_PEN_PERSON_ID