DBA Data[Home] [Help]

APPS.HRDPP_CREATE_GB_PERSON_ADDRESS dependencies on HR_UTILITY

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

369: hr_data_pump.entry('call');
370: open cr;
371: fetch cr into c;
372: if cr%notfound then
373: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
374: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
375: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
376: hr_utility.set_message_token('VALUE',p_batch_line_id);
377: hr_utility.raise_error;

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

370: open cr;
371: fetch cr into c;
372: if cr%notfound then
373: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
374: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
375: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
376: hr_utility.set_message_token('VALUE',p_batch_line_id);
377: hr_utility.raise_error;
378: end if;

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

371: fetch cr into c;
372: if cr%notfound then
373: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
374: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
375: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
376: hr_utility.set_message_token('VALUE',p_batch_line_id);
377: hr_utility.raise_error;
378: end if;
379: --

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

372: if cr%notfound then
373: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
374: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
375: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
376: hr_utility.set_message_token('VALUE',p_batch_line_id);
377: hr_utility.raise_error;
378: end if;
379: --
380: if upper(c.p2) = 'TRUE' then

Line 377: hr_utility.raise_error;

373: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
374: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
375: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
376: hr_utility.set_message_token('VALUE',p_batch_line_id);
377: hr_utility.raise_error;
378: end if;
379: --
380: if upper(c.p2) = 'TRUE' then
381: L_PRADD_OVLAPVAL_OVERRIDE := true;

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

381: L_PRADD_OVLAPVAL_OVERRIDE := true;
382: elsif upper(c.p2) = 'FALSE' then
383: L_PRADD_OVLAPVAL_OVERRIDE := false;
384: elsif c.p2 is not null then
385: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
386: hr_utility.set_message_token('TYPE','BOOLEAN');
387: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
388: hr_utility.set_message_token('VALUE',c.p2);
389: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');

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

382: elsif upper(c.p2) = 'FALSE' then
383: L_PRADD_OVLAPVAL_OVERRIDE := false;
384: elsif c.p2 is not null then
385: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
386: hr_utility.set_message_token('TYPE','BOOLEAN');
387: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
388: hr_utility.set_message_token('VALUE',c.p2);
389: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
390: hr_utility.raise_error;

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

383: L_PRADD_OVLAPVAL_OVERRIDE := false;
384: elsif c.p2 is not null then
385: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
386: hr_utility.set_message_token('TYPE','BOOLEAN');
387: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
388: hr_utility.set_message_token('VALUE',c.p2);
389: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
390: hr_utility.raise_error;
391: end if;

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

384: elsif c.p2 is not null then
385: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
386: hr_utility.set_message_token('TYPE','BOOLEAN');
387: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
388: hr_utility.set_message_token('VALUE',c.p2);
389: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
390: hr_utility.raise_error;
391: end if;
392: --

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

385: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
386: hr_utility.set_message_token('TYPE','BOOLEAN');
387: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
388: hr_utility.set_message_token('VALUE',c.p2);
389: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
390: hr_utility.raise_error;
391: end if;
392: --
393: if c.p48 is null then

Line 390: hr_utility.raise_error;

386: hr_utility.set_message_token('TYPE','BOOLEAN');
387: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
388: hr_utility.set_message_token('VALUE',c.p2);
389: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
390: hr_utility.raise_error;
391: end if;
392: --
393: if c.p48 is null then
394: L_PERSON_ID:=nn;