DBA Data[Home] [Help]

APPS.HRDPP_UPDATE_US_PERSON_ADDRESS dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

Line 371: hr_utility.raise_error;

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

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

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

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

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

Line 381: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');

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

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

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

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

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

Line 384: hr_utility.raise_error;

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