DBA Data[Home] [Help]

APPS.HRDPP_UPDATE_PERSON_ADDRESS dependencies on HR_UTILITY

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

383: hr_data_pump.entry('call');
384: open cr;
385: fetch cr into c;
386: if cr%notfound then
387: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
388: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
389: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
390: hr_utility.set_message_token('VALUE',p_batch_line_id);
391: hr_utility.raise_error;

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

384: open cr;
385: fetch cr into c;
386: if cr%notfound then
387: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
388: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
389: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
390: hr_utility.set_message_token('VALUE',p_batch_line_id);
391: hr_utility.raise_error;
392: end if;

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

385: fetch cr into c;
386: if cr%notfound then
387: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
388: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
389: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
390: hr_utility.set_message_token('VALUE',p_batch_line_id);
391: hr_utility.raise_error;
392: end if;
393: --

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

386: if cr%notfound then
387: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
388: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
389: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
390: hr_utility.set_message_token('VALUE',p_batch_line_id);
391: hr_utility.raise_error;
392: end if;
393: --
394: if upper(c.p2) = 'TRUE' then

Line 391: hr_utility.raise_error;

387: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
388: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
389: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
390: hr_utility.set_message_token('VALUE',p_batch_line_id);
391: hr_utility.raise_error;
392: end if;
393: --
394: if upper(c.p2) = 'TRUE' then
395: L_VALIDATE_COUNTY := true;

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

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

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

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

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

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

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

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

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

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

Line 404: hr_utility.raise_error;

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