DBA Data[Home] [Help]

APPS.HRDPP_UPDATE_CN_PERSON_ADDRESS dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

Line 367: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

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

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

Line 380: hr_utility.raise_error;

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