DBA Data[Home] [Help]

APPS.HRDPP_PROCESS_BENEFICIARY dependencies on HR_UTILITY

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

288: hr_data_pump.entry('call');
289: open cr;
290: fetch cr into c;
291: if cr%notfound then
292: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
293: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
294: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
295: hr_utility.set_message_token('VALUE',p_batch_line_id);
296: hr_utility.raise_error;

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

289: open cr;
290: fetch cr into c;
291: if cr%notfound then
292: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
293: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
294: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
295: hr_utility.set_message_token('VALUE',p_batch_line_id);
296: hr_utility.raise_error;
297: end if;

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

290: fetch cr into c;
291: if cr%notfound then
292: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
293: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
294: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
295: hr_utility.set_message_token('VALUE',p_batch_line_id);
296: hr_utility.raise_error;
297: end if;
298: --

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

291: if cr%notfound then
292: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
293: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
294: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
295: hr_utility.set_message_token('VALUE',p_batch_line_id);
296: hr_utility.raise_error;
297: end if;
298: --
299: if upper(c.p11) = 'TRUE' then

Line 296: hr_utility.raise_error;

292: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
293: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
294: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
295: hr_utility.set_message_token('VALUE',p_batch_line_id);
296: hr_utility.raise_error;
297: end if;
298: --
299: if upper(c.p11) = 'TRUE' then
300: L_MULTI_ROW_ACTN := true;

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

300: L_MULTI_ROW_ACTN := true;
301: elsif upper(c.p11) = 'FALSE' then
302: L_MULTI_ROW_ACTN := false;
303: elsif c.p11 is not null then
304: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
305: hr_utility.set_message_token('TYPE','BOOLEAN');
306: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
307: hr_utility.set_message_token('VALUE',c.p11);
308: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');

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

301: elsif upper(c.p11) = 'FALSE' then
302: L_MULTI_ROW_ACTN := false;
303: elsif c.p11 is not null then
304: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
305: hr_utility.set_message_token('TYPE','BOOLEAN');
306: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
307: hr_utility.set_message_token('VALUE',c.p11);
308: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
309: hr_utility.raise_error;

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

302: L_MULTI_ROW_ACTN := false;
303: elsif c.p11 is not null then
304: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
305: hr_utility.set_message_token('TYPE','BOOLEAN');
306: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
307: hr_utility.set_message_token('VALUE',c.p11);
308: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
309: hr_utility.raise_error;
310: end if;

Line 307: hr_utility.set_message_token('VALUE',c.p11);

303: elsif c.p11 is not null then
304: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
305: hr_utility.set_message_token('TYPE','BOOLEAN');
306: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
307: hr_utility.set_message_token('VALUE',c.p11);
308: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
309: hr_utility.raise_error;
310: end if;
311: --

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

304: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
305: hr_utility.set_message_token('TYPE','BOOLEAN');
306: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
307: hr_utility.set_message_token('VALUE',c.p11);
308: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
309: hr_utility.raise_error;
310: end if;
311: --
312: L_PERSON_ID :=

Line 309: hr_utility.raise_error;

305: hr_utility.set_message_token('TYPE','BOOLEAN');
306: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
307: hr_utility.set_message_token('VALUE',c.p11);
308: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
309: hr_utility.raise_error;
310: end if;
311: --
312: L_PERSON_ID :=
313: BEN_PUMP_GET.GET_PEN_PERSON_ID