DBA Data[Home] [Help]

APPS.HRDPP_CREATE_MX_LOC_PERSON_ADD dependencies on HR_UTILITY

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

364: hr_data_pump.entry('call');
365: open cr;
366: fetch cr into c;
367: if cr%notfound then
368: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
369: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
370: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
371: hr_utility.set_message_token('VALUE',p_batch_line_id);
372: hr_utility.raise_error;

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

365: open cr;
366: fetch cr into c;
367: if cr%notfound then
368: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
369: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
370: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
371: hr_utility.set_message_token('VALUE',p_batch_line_id);
372: hr_utility.raise_error;
373: end if;

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

366: fetch cr into c;
367: if cr%notfound then
368: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
369: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
370: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
371: hr_utility.set_message_token('VALUE',p_batch_line_id);
372: hr_utility.raise_error;
373: end if;
374: --

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

367: if cr%notfound then
368: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
369: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
370: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
371: hr_utility.set_message_token('VALUE',p_batch_line_id);
372: hr_utility.raise_error;
373: end if;
374: --
375: if upper(c.p2) = 'TRUE' then

Line 372: hr_utility.raise_error;

368: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
369: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
370: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
371: hr_utility.set_message_token('VALUE',p_batch_line_id);
372: hr_utility.raise_error;
373: end if;
374: --
375: if upper(c.p2) = 'TRUE' then
376: L_PRADD_OVLAPVAL_OVERRIDE := true;

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

376: L_PRADD_OVLAPVAL_OVERRIDE := true;
377: elsif upper(c.p2) = 'FALSE' then
378: L_PRADD_OVLAPVAL_OVERRIDE := false;
379: elsif c.p2 is not null then
380: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
381: hr_utility.set_message_token('TYPE','BOOLEAN');
382: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
383: hr_utility.set_message_token('VALUE',c.p2);
384: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');

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

377: elsif upper(c.p2) = 'FALSE' then
378: L_PRADD_OVLAPVAL_OVERRIDE := false;
379: elsif c.p2 is not null then
380: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
381: hr_utility.set_message_token('TYPE','BOOLEAN');
382: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
383: hr_utility.set_message_token('VALUE',c.p2);
384: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
385: hr_utility.raise_error;

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

378: L_PRADD_OVLAPVAL_OVERRIDE := false;
379: elsif c.p2 is not null then
380: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
381: hr_utility.set_message_token('TYPE','BOOLEAN');
382: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
383: hr_utility.set_message_token('VALUE',c.p2);
384: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
385: hr_utility.raise_error;
386: end if;

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

379: elsif c.p2 is not null then
380: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
381: hr_utility.set_message_token('TYPE','BOOLEAN');
382: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
383: hr_utility.set_message_token('VALUE',c.p2);
384: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
385: hr_utility.raise_error;
386: end if;
387: --

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

380: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
381: hr_utility.set_message_token('TYPE','BOOLEAN');
382: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
383: hr_utility.set_message_token('VALUE',c.p2);
384: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
385: hr_utility.raise_error;
386: end if;
387: --
388: L_COMMENTS := c.plongval;

Line 385: hr_utility.raise_error;

381: hr_utility.set_message_token('TYPE','BOOLEAN');
382: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
383: hr_utility.set_message_token('VALUE',c.p2);
384: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
385: hr_utility.raise_error;
386: end if;
387: --
388: L_COMMENTS := c.plongval;
389: if L_COMMENTS = cn then