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_US_PERSON_ADDRESS dependencies on HR_UTILITY

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

388: hr_data_pump.entry('call');
389: open cr;
390: fetch cr into c;
391: if cr%notfound then
392: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
393: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
394: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
395: hr_utility.set_message_token('VALUE',p_batch_line_id);
396: hr_utility.raise_error;

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

389: open cr;
390: fetch cr into c;
391: if cr%notfound then
392: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
393: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
394: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
395: hr_utility.set_message_token('VALUE',p_batch_line_id);
396: hr_utility.raise_error;
397: end if;

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

390: fetch cr into c;
391: if cr%notfound then
392: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
393: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
394: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
395: hr_utility.set_message_token('VALUE',p_batch_line_id);
396: hr_utility.raise_error;
397: end if;
398: --

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

391: if cr%notfound then
392: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
393: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
394: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
395: hr_utility.set_message_token('VALUE',p_batch_line_id);
396: hr_utility.raise_error;
397: end if;
398: --
399: if upper(c.p2) = 'TRUE' then

Line 396: hr_utility.raise_error;

392: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
393: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
394: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
395: hr_utility.set_message_token('VALUE',p_batch_line_id);
396: hr_utility.raise_error;
397: end if;
398: --
399: if upper(c.p2) = 'TRUE' then
400: L_PRADD_OVLAPVAL_OVERRIDE := true;

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

400: L_PRADD_OVLAPVAL_OVERRIDE := true;
401: elsif upper(c.p2) = 'FALSE' then
402: L_PRADD_OVLAPVAL_OVERRIDE := false;
403: elsif c.p2 is not null then
404: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
405: hr_utility.set_message_token('TYPE','BOOLEAN');
406: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
407: hr_utility.set_message_token('VALUE',c.p2);
408: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');

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

401: elsif upper(c.p2) = 'FALSE' then
402: L_PRADD_OVLAPVAL_OVERRIDE := false;
403: elsif c.p2 is not null then
404: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
405: hr_utility.set_message_token('TYPE','BOOLEAN');
406: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
407: hr_utility.set_message_token('VALUE',c.p2);
408: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
409: hr_utility.raise_error;

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

402: L_PRADD_OVLAPVAL_OVERRIDE := false;
403: elsif c.p2 is not null then
404: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
405: hr_utility.set_message_token('TYPE','BOOLEAN');
406: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
407: hr_utility.set_message_token('VALUE',c.p2);
408: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
409: hr_utility.raise_error;
410: end if;

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

403: elsif c.p2 is not null then
404: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
405: hr_utility.set_message_token('TYPE','BOOLEAN');
406: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
407: hr_utility.set_message_token('VALUE',c.p2);
408: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
409: hr_utility.raise_error;
410: end if;
411: --

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

404: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
405: hr_utility.set_message_token('TYPE','BOOLEAN');
406: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
407: hr_utility.set_message_token('VALUE',c.p2);
408: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
409: hr_utility.raise_error;
410: end if;
411: --
412: if upper(c.p3) = 'TRUE' then

Line 409: hr_utility.raise_error;

405: hr_utility.set_message_token('TYPE','BOOLEAN');
406: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
407: hr_utility.set_message_token('VALUE',c.p2);
408: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
409: hr_utility.raise_error;
410: end if;
411: --
412: if upper(c.p3) = 'TRUE' then
413: L_VALIDATE_COUNTY := true;

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

413: L_VALIDATE_COUNTY := true;
414: elsif upper(c.p3) = 'FALSE' then
415: L_VALIDATE_COUNTY := false;
416: elsif c.p3 is not null then
417: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
418: hr_utility.set_message_token('TYPE','BOOLEAN');
419: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');
420: hr_utility.set_message_token('VALUE',c.p3);
421: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');

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

414: elsif upper(c.p3) = 'FALSE' then
415: L_VALIDATE_COUNTY := false;
416: elsif c.p3 is not null then
417: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
418: hr_utility.set_message_token('TYPE','BOOLEAN');
419: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');
420: hr_utility.set_message_token('VALUE',c.p3);
421: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
422: hr_utility.raise_error;

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

415: L_VALIDATE_COUNTY := false;
416: elsif c.p3 is not null then
417: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
418: hr_utility.set_message_token('TYPE','BOOLEAN');
419: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');
420: hr_utility.set_message_token('VALUE',c.p3);
421: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
422: hr_utility.raise_error;
423: end if;

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

416: elsif c.p3 is not null then
417: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
418: hr_utility.set_message_token('TYPE','BOOLEAN');
419: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');
420: hr_utility.set_message_token('VALUE',c.p3);
421: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
422: hr_utility.raise_error;
423: end if;
424: --

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

417: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
418: hr_utility.set_message_token('TYPE','BOOLEAN');
419: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');
420: hr_utility.set_message_token('VALUE',c.p3);
421: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
422: hr_utility.raise_error;
423: end if;
424: --
425: if c.p50 is null then

Line 422: hr_utility.raise_error;

418: hr_utility.set_message_token('TYPE','BOOLEAN');
419: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');
420: hr_utility.set_message_token('VALUE',c.p3);
421: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
422: hr_utility.raise_error;
423: end if;
424: --
425: if c.p50 is null then
426: L_PERSON_ID:=nn;