DBA Data[Home] [Help]

APPS.HRDPP_CREATE_PLAN_BENEFICIARY dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

Line 388: hr_utility.raise_error;

384: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
385: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
386: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
387: hr_utility.set_message_token('VALUE',p_batch_line_id);
388: hr_utility.raise_error;
389: end if;
390: --
391: if upper(c.p44) = 'TRUE' then
392: L_MULTI_ROW_ACTN := true;

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

392: L_MULTI_ROW_ACTN := true;
393: elsif upper(c.p44) = 'FALSE' then
394: L_MULTI_ROW_ACTN := false;
395: elsif c.p44 is not null then
396: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
397: hr_utility.set_message_token('TYPE','BOOLEAN');
398: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
399: hr_utility.set_message_token('VALUE',c.p44);
400: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');

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

393: elsif upper(c.p44) = 'FALSE' then
394: L_MULTI_ROW_ACTN := false;
395: elsif c.p44 is not null then
396: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
397: hr_utility.set_message_token('TYPE','BOOLEAN');
398: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
399: hr_utility.set_message_token('VALUE',c.p44);
400: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
401: hr_utility.raise_error;

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

394: L_MULTI_ROW_ACTN := false;
395: elsif c.p44 is not null then
396: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
397: hr_utility.set_message_token('TYPE','BOOLEAN');
398: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
399: hr_utility.set_message_token('VALUE',c.p44);
400: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
401: hr_utility.raise_error;
402: end if;

Line 399: hr_utility.set_message_token('VALUE',c.p44);

395: elsif c.p44 is not null then
396: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
397: hr_utility.set_message_token('TYPE','BOOLEAN');
398: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
399: hr_utility.set_message_token('VALUE',c.p44);
400: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
401: hr_utility.raise_error;
402: end if;
403: --

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

396: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
397: hr_utility.set_message_token('TYPE','BOOLEAN');
398: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
399: hr_utility.set_message_token('VALUE',c.p44);
400: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
401: hr_utility.raise_error;
402: end if;
403: --
404: if c.p45 is null then

Line 401: hr_utility.raise_error;

397: hr_utility.set_message_token('TYPE','BOOLEAN');
398: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
399: hr_utility.set_message_token('VALUE',c.p44);
400: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
401: hr_utility.raise_error;
402: end if;
403: --
404: if c.p45 is null then
405: L_PRTT_ENRT_RSLT_ID:=nn;