DBA Data[Home] [Help]

APPS.HRDPP_UPDATE_PLAN_BENEFICIARY dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

Line 397: hr_utility.raise_error;

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

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

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

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

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

Line 407: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');

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

Line 408: hr_utility.set_message_token('VALUE',c.p43);

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

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

405: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
406: hr_utility.set_message_token('TYPE','BOOLEAN');
407: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
408: hr_utility.set_message_token('VALUE',c.p43);
409: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
410: hr_utility.raise_error;
411: end if;
412: --
413: if c.p44 is null then

Line 410: hr_utility.raise_error;

406: hr_utility.set_message_token('TYPE','BOOLEAN');
407: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
408: hr_utility.set_message_token('VALUE',c.p43);
409: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
410: hr_utility.raise_error;
411: end if;
412: --
413: if c.p44 is null then
414: L_PL_BNF_ID:=nn;