eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HRDPP_CREATE_CN_PERSON_ADDRESS dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

Line 379: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

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

387: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
388: hr_utility.set_message_token('TYPE','BOOLEAN');
389: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
390: hr_utility.set_message_token('VALUE',c.p2);
391: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
392: hr_utility.raise_error;
393: end if;
394: --
395: if upper(c.p3) = 'TRUE' then

Line 392: hr_utility.raise_error;

388: hr_utility.set_message_token('TYPE','BOOLEAN');
389: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
390: hr_utility.set_message_token('VALUE',c.p2);
391: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
392: hr_utility.raise_error;
393: end if;
394: --
395: if upper(c.p3) = 'TRUE' then
396: L_VALIDATE_COUNTY := true;

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

396: L_VALIDATE_COUNTY := true;
397: elsif upper(c.p3) = 'FALSE' then
398: L_VALIDATE_COUNTY := false;
399: elsif c.p3 is not null then
400: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
401: hr_utility.set_message_token('TYPE','BOOLEAN');
402: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');
403: hr_utility.set_message_token('VALUE',c.p3);
404: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');

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

397: elsif upper(c.p3) = 'FALSE' then
398: L_VALIDATE_COUNTY := false;
399: elsif c.p3 is not null then
400: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
401: hr_utility.set_message_token('TYPE','BOOLEAN');
402: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');
403: hr_utility.set_message_token('VALUE',c.p3);
404: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
405: hr_utility.raise_error;

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

398: L_VALIDATE_COUNTY := false;
399: elsif c.p3 is not null then
400: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
401: hr_utility.set_message_token('TYPE','BOOLEAN');
402: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');
403: hr_utility.set_message_token('VALUE',c.p3);
404: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
405: hr_utility.raise_error;
406: end if;

Line 403: hr_utility.set_message_token('VALUE',c.p3);

399: elsif c.p3 is not null then
400: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
401: hr_utility.set_message_token('TYPE','BOOLEAN');
402: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');
403: hr_utility.set_message_token('VALUE',c.p3);
404: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
405: hr_utility.raise_error;
406: end if;
407: --

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

400: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
401: hr_utility.set_message_token('TYPE','BOOLEAN');
402: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');
403: hr_utility.set_message_token('VALUE',c.p3);
404: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
405: hr_utility.raise_error;
406: end if;
407: --
408: L_COMMENTS := c.plongval;

Line 405: hr_utility.raise_error;

401: hr_utility.set_message_token('TYPE','BOOLEAN');
402: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');
403: hr_utility.set_message_token('VALUE',c.p3);
404: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
405: hr_utility.raise_error;
406: end if;
407: --
408: L_COMMENTS := c.plongval;
409: if L_COMMENTS = cn then