DBA Data[Home] [Help]

APPS.HRDPP_UPDATE_ELIG_CVRD_DPNT dependencies on HR_UTILITY

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

361: hr_data_pump.entry('call');
362: open cr;
363: fetch cr into c;
364: if cr%notfound then
365: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
366: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
367: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
368: hr_utility.set_message_token('VALUE',p_batch_line_id);
369: hr_utility.raise_error;

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

362: open cr;
363: fetch cr into c;
364: if cr%notfound then
365: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
366: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
367: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
368: hr_utility.set_message_token('VALUE',p_batch_line_id);
369: hr_utility.raise_error;
370: end if;

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

363: fetch cr into c;
364: if cr%notfound then
365: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
366: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
367: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
368: hr_utility.set_message_token('VALUE',p_batch_line_id);
369: hr_utility.raise_error;
370: end if;
371: --

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

364: if cr%notfound then
365: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
366: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
367: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
368: hr_utility.set_message_token('VALUE',p_batch_line_id);
369: hr_utility.raise_error;
370: end if;
371: --
372: if upper(c.p42) = 'TRUE' then

Line 369: hr_utility.raise_error;

365: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
366: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
367: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
368: hr_utility.set_message_token('VALUE',p_batch_line_id);
369: hr_utility.raise_error;
370: end if;
371: --
372: if upper(c.p42) = 'TRUE' then
373: L_MULTI_ROW_ACTN := true;

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

373: L_MULTI_ROW_ACTN := true;
374: elsif upper(c.p42) = 'FALSE' then
375: L_MULTI_ROW_ACTN := false;
376: elsif c.p42 is not null then
377: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
378: hr_utility.set_message_token('TYPE','BOOLEAN');
379: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
380: hr_utility.set_message_token('VALUE',c.p42);
381: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');

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

374: elsif upper(c.p42) = 'FALSE' then
375: L_MULTI_ROW_ACTN := false;
376: elsif c.p42 is not null then
377: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
378: hr_utility.set_message_token('TYPE','BOOLEAN');
379: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
380: hr_utility.set_message_token('VALUE',c.p42);
381: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
382: hr_utility.raise_error;

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

375: L_MULTI_ROW_ACTN := false;
376: elsif c.p42 is not null then
377: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
378: hr_utility.set_message_token('TYPE','BOOLEAN');
379: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
380: hr_utility.set_message_token('VALUE',c.p42);
381: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
382: hr_utility.raise_error;
383: end if;

Line 380: hr_utility.set_message_token('VALUE',c.p42);

376: elsif c.p42 is not null then
377: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
378: hr_utility.set_message_token('TYPE','BOOLEAN');
379: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
380: hr_utility.set_message_token('VALUE',c.p42);
381: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
382: hr_utility.raise_error;
383: end if;
384: --

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

377: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
378: hr_utility.set_message_token('TYPE','BOOLEAN');
379: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
380: hr_utility.set_message_token('VALUE',c.p42);
381: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
382: hr_utility.raise_error;
383: end if;
384: --
385: if c.p43 is null then

Line 382: hr_utility.raise_error;

378: hr_utility.set_message_token('TYPE','BOOLEAN');
379: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
380: hr_utility.set_message_token('VALUE',c.p42);
381: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
382: hr_utility.raise_error;
383: end if;
384: --
385: if c.p43 is null then
386: L_ELIG_CVRD_DPNT_ID:=nn;