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

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

403: hr_data_pump.entry('call');
404: open cr;
405: fetch cr into c;
406: if cr%notfound then
407: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
408: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
409: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
410: hr_utility.set_message_token('VALUE',p_batch_line_id);
411: hr_utility.raise_error;

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

404: open cr;
405: fetch cr into c;
406: if cr%notfound then
407: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
408: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
409: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
410: hr_utility.set_message_token('VALUE',p_batch_line_id);
411: hr_utility.raise_error;
412: end if;

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

405: fetch cr into c;
406: if cr%notfound then
407: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
408: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
409: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
410: hr_utility.set_message_token('VALUE',p_batch_line_id);
411: hr_utility.raise_error;
412: end if;
413: --

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

406: if cr%notfound then
407: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
408: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
409: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
410: hr_utility.set_message_token('VALUE',p_batch_line_id);
411: hr_utility.raise_error;
412: end if;
413: --
414: if upper(c.p2) = 'TRUE' then

Line 411: hr_utility.raise_error;

407: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
408: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
409: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
410: hr_utility.set_message_token('VALUE',p_batch_line_id);
411: hr_utility.raise_error;
412: end if;
413: --
414: if upper(c.p2) = 'TRUE' then
415: L_PRADD_OVLAPVAL_OVERRIDE := true;

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

415: L_PRADD_OVLAPVAL_OVERRIDE := true;
416: elsif upper(c.p2) = 'FALSE' then
417: L_PRADD_OVLAPVAL_OVERRIDE := false;
418: elsif c.p2 is not null then
419: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
420: hr_utility.set_message_token('TYPE','BOOLEAN');
421: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
422: hr_utility.set_message_token('VALUE',c.p2);
423: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');

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

416: elsif upper(c.p2) = 'FALSE' then
417: L_PRADD_OVLAPVAL_OVERRIDE := false;
418: elsif c.p2 is not null then
419: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
420: hr_utility.set_message_token('TYPE','BOOLEAN');
421: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
422: hr_utility.set_message_token('VALUE',c.p2);
423: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
424: hr_utility.raise_error;

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

417: L_PRADD_OVLAPVAL_OVERRIDE := false;
418: elsif c.p2 is not null then
419: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
420: hr_utility.set_message_token('TYPE','BOOLEAN');
421: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
422: hr_utility.set_message_token('VALUE',c.p2);
423: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
424: hr_utility.raise_error;
425: end if;

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

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

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

419: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
420: hr_utility.set_message_token('TYPE','BOOLEAN');
421: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
422: hr_utility.set_message_token('VALUE',c.p2);
423: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
424: hr_utility.raise_error;
425: end if;
426: --
427: if upper(c.p3) = 'TRUE' then

Line 424: hr_utility.raise_error;

420: hr_utility.set_message_token('TYPE','BOOLEAN');
421: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
422: hr_utility.set_message_token('VALUE',c.p2);
423: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
424: hr_utility.raise_error;
425: end if;
426: --
427: if upper(c.p3) = 'TRUE' then
428: L_VALIDATE_COUNTY := true;

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

428: L_VALIDATE_COUNTY := true;
429: elsif upper(c.p3) = 'FALSE' then
430: L_VALIDATE_COUNTY := false;
431: elsif c.p3 is not null then
432: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
433: hr_utility.set_message_token('TYPE','BOOLEAN');
434: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');
435: hr_utility.set_message_token('VALUE',c.p3);
436: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');

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

429: elsif upper(c.p3) = 'FALSE' then
430: L_VALIDATE_COUNTY := false;
431: elsif c.p3 is not null then
432: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
433: hr_utility.set_message_token('TYPE','BOOLEAN');
434: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');
435: hr_utility.set_message_token('VALUE',c.p3);
436: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
437: hr_utility.raise_error;

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

430: L_VALIDATE_COUNTY := false;
431: elsif c.p3 is not null then
432: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
433: hr_utility.set_message_token('TYPE','BOOLEAN');
434: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');
435: hr_utility.set_message_token('VALUE',c.p3);
436: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
437: hr_utility.raise_error;
438: end if;

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

431: elsif c.p3 is not null then
432: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
433: hr_utility.set_message_token('TYPE','BOOLEAN');
434: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');
435: hr_utility.set_message_token('VALUE',c.p3);
436: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
437: hr_utility.raise_error;
438: end if;
439: --

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

432: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
433: hr_utility.set_message_token('TYPE','BOOLEAN');
434: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');
435: hr_utility.set_message_token('VALUE',c.p3);
436: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
437: hr_utility.raise_error;
438: end if;
439: --
440: if c.p53 is null then

Line 437: hr_utility.raise_error;

433: hr_utility.set_message_token('TYPE','BOOLEAN');
434: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');
435: hr_utility.set_message_token('VALUE',c.p3);
436: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
437: hr_utility.raise_error;
438: end if;
439: --
440: if c.p53 is null then
441: L_PERSON_ID:=nn;