DBA Data[Home] [Help]

APPS.HRDPP_CREATE_IN_PERSON_ADDRESS dependencies on HR_UTILITY

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

319: hr_data_pump.entry('call');
320: open cr;
321: fetch cr into c;
322: if cr%notfound then
323: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
324: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
325: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
326: hr_utility.set_message_token('VALUE',p_batch_line_id);
327: hr_utility.raise_error;

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

320: open cr;
321: fetch cr into c;
322: if cr%notfound then
323: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
324: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
325: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
326: hr_utility.set_message_token('VALUE',p_batch_line_id);
327: hr_utility.raise_error;
328: end if;

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

321: fetch cr into c;
322: if cr%notfound then
323: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
324: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
325: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
326: hr_utility.set_message_token('VALUE',p_batch_line_id);
327: hr_utility.raise_error;
328: end if;
329: --

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

322: if cr%notfound then
323: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
324: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
325: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
326: hr_utility.set_message_token('VALUE',p_batch_line_id);
327: hr_utility.raise_error;
328: end if;
329: --
330: if upper(c.p2) = 'TRUE' then

Line 327: hr_utility.raise_error;

323: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
324: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
325: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
326: hr_utility.set_message_token('VALUE',p_batch_line_id);
327: hr_utility.raise_error;
328: end if;
329: --
330: if upper(c.p2) = 'TRUE' then
331: L_PRADD_OVLAPVAL_OVERRIDE := true;

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

331: L_PRADD_OVLAPVAL_OVERRIDE := true;
332: elsif upper(c.p2) = 'FALSE' then
333: L_PRADD_OVLAPVAL_OVERRIDE := false;
334: elsif c.p2 is not null then
335: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
336: hr_utility.set_message_token('TYPE','BOOLEAN');
337: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
338: hr_utility.set_message_token('VALUE',c.p2);
339: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');

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

332: elsif upper(c.p2) = 'FALSE' then
333: L_PRADD_OVLAPVAL_OVERRIDE := false;
334: elsif c.p2 is not null then
335: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
336: hr_utility.set_message_token('TYPE','BOOLEAN');
337: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
338: hr_utility.set_message_token('VALUE',c.p2);
339: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
340: hr_utility.raise_error;

Line 337: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');

333: L_PRADD_OVLAPVAL_OVERRIDE := false;
334: elsif c.p2 is not null then
335: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
336: hr_utility.set_message_token('TYPE','BOOLEAN');
337: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
338: hr_utility.set_message_token('VALUE',c.p2);
339: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
340: hr_utility.raise_error;
341: end if;

Line 338: hr_utility.set_message_token('VALUE',c.p2);

334: elsif c.p2 is not null then
335: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
336: hr_utility.set_message_token('TYPE','BOOLEAN');
337: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
338: hr_utility.set_message_token('VALUE',c.p2);
339: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
340: hr_utility.raise_error;
341: end if;
342: --

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

335: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
336: hr_utility.set_message_token('TYPE','BOOLEAN');
337: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
338: hr_utility.set_message_token('VALUE',c.p2);
339: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
340: hr_utility.raise_error;
341: end if;
342: --
343: L_COMMENTS := c.plongval;

Line 340: hr_utility.raise_error;

336: hr_utility.set_message_token('TYPE','BOOLEAN');
337: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
338: hr_utility.set_message_token('VALUE',c.p2);
339: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
340: hr_utility.raise_error;
341: end if;
342: --
343: L_COMMENTS := c.plongval;
344: if L_COMMENTS = cn then