DBA Data[Home] [Help]

APPS.HRDPP_CREATE_ELIG_CVRD_DPNT dependencies on HR_UTILITY

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

353: hr_data_pump.entry('call');
354: open cr;
355: fetch cr into c;
356: if cr%notfound then
357: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
358: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
359: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
360: hr_utility.set_message_token('VALUE',p_batch_line_id);
361: hr_utility.raise_error;

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

354: open cr;
355: fetch cr into c;
356: if cr%notfound then
357: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
358: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
359: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
360: hr_utility.set_message_token('VALUE',p_batch_line_id);
361: hr_utility.raise_error;
362: end if;

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

355: fetch cr into c;
356: if cr%notfound then
357: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
358: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
359: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
360: hr_utility.set_message_token('VALUE',p_batch_line_id);
361: hr_utility.raise_error;
362: end if;
363: --

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

356: if cr%notfound then
357: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
358: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
359: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
360: hr_utility.set_message_token('VALUE',p_batch_line_id);
361: hr_utility.raise_error;
362: end if;
363: --
364: if upper(c.p43) = 'TRUE' then

Line 361: hr_utility.raise_error;

357: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
358: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
359: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
360: hr_utility.set_message_token('VALUE',p_batch_line_id);
361: hr_utility.raise_error;
362: end if;
363: --
364: if upper(c.p43) = 'TRUE' then
365: L_MULTI_ROW_ACTN := true;

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

365: L_MULTI_ROW_ACTN := true;
366: elsif upper(c.p43) = 'FALSE' then
367: L_MULTI_ROW_ACTN := false;
368: elsif c.p43 is not null then
369: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
370: hr_utility.set_message_token('TYPE','BOOLEAN');
371: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
372: hr_utility.set_message_token('VALUE',c.p43);
373: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');

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

366: elsif upper(c.p43) = 'FALSE' then
367: L_MULTI_ROW_ACTN := false;
368: elsif c.p43 is not null then
369: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
370: hr_utility.set_message_token('TYPE','BOOLEAN');
371: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
372: hr_utility.set_message_token('VALUE',c.p43);
373: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
374: hr_utility.raise_error;

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

367: L_MULTI_ROW_ACTN := false;
368: elsif c.p43 is not null then
369: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
370: hr_utility.set_message_token('TYPE','BOOLEAN');
371: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
372: hr_utility.set_message_token('VALUE',c.p43);
373: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
374: hr_utility.raise_error;
375: end if;

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

368: elsif c.p43 is not null then
369: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
370: hr_utility.set_message_token('TYPE','BOOLEAN');
371: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
372: hr_utility.set_message_token('VALUE',c.p43);
373: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
374: hr_utility.raise_error;
375: end if;
376: --

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

369: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
370: hr_utility.set_message_token('TYPE','BOOLEAN');
371: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
372: hr_utility.set_message_token('VALUE',c.p43);
373: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
374: hr_utility.raise_error;
375: end if;
376: --
377: if c.p44 is null then

Line 374: hr_utility.raise_error;

370: hr_utility.set_message_token('TYPE','BOOLEAN');
371: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
372: hr_utility.set_message_token('VALUE',c.p43);
373: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
374: hr_utility.raise_error;
375: end if;
376: --
377: if c.p44 is null then
378: L_PRTT_ENRT_RSLT_ID:=nn;