DBA Data[Home] [Help]

APPS.HRDPP_UPDATE_PRTT_RT_VAL dependencies on HR_UTILITY

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

511: hr_data_pump.entry('call');
512: open cr;
513: fetch cr into c;
514: if cr%notfound then
515: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
516: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
517: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
518: hr_utility.set_message_token('VALUE',p_batch_line_id);
519: hr_utility.raise_error;

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

512: open cr;
513: fetch cr into c;
514: if cr%notfound then
515: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
516: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
517: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
518: hr_utility.set_message_token('VALUE',p_batch_line_id);
519: hr_utility.raise_error;
520: end if;

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

513: fetch cr into c;
514: if cr%notfound then
515: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
516: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
517: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
518: hr_utility.set_message_token('VALUE',p_batch_line_id);
519: hr_utility.raise_error;
520: end if;
521: --

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

514: if cr%notfound then
515: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
516: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
517: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
518: hr_utility.set_message_token('VALUE',p_batch_line_id);
519: hr_utility.raise_error;
520: end if;
521: --
522: if upper(c.p55) = 'TRUE' then

Line 519: hr_utility.raise_error;

515: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
516: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
517: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
518: hr_utility.set_message_token('VALUE',p_batch_line_id);
519: hr_utility.raise_error;
520: end if;
521: --
522: if upper(c.p55) = 'TRUE' then
523: L_NO_END_ELEMENT := true;

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

523: L_NO_END_ELEMENT := true;
524: elsif upper(c.p55) = 'FALSE' then
525: L_NO_END_ELEMENT := false;
526: elsif c.p55 is not null then
527: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
528: hr_utility.set_message_token('TYPE','BOOLEAN');
529: hr_utility.set_message_token('PARAMETER','P_NO_END_ELEMENT');
530: hr_utility.set_message_token('VALUE',c.p55);
531: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');

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

524: elsif upper(c.p55) = 'FALSE' then
525: L_NO_END_ELEMENT := false;
526: elsif c.p55 is not null then
527: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
528: hr_utility.set_message_token('TYPE','BOOLEAN');
529: hr_utility.set_message_token('PARAMETER','P_NO_END_ELEMENT');
530: hr_utility.set_message_token('VALUE',c.p55);
531: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
532: hr_utility.raise_error;

Line 529: hr_utility.set_message_token('PARAMETER','P_NO_END_ELEMENT');

525: L_NO_END_ELEMENT := false;
526: elsif c.p55 is not null then
527: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
528: hr_utility.set_message_token('TYPE','BOOLEAN');
529: hr_utility.set_message_token('PARAMETER','P_NO_END_ELEMENT');
530: hr_utility.set_message_token('VALUE',c.p55);
531: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
532: hr_utility.raise_error;
533: end if;

Line 530: hr_utility.set_message_token('VALUE',c.p55);

526: elsif c.p55 is not null then
527: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
528: hr_utility.set_message_token('TYPE','BOOLEAN');
529: hr_utility.set_message_token('PARAMETER','P_NO_END_ELEMENT');
530: hr_utility.set_message_token('VALUE',c.p55);
531: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
532: hr_utility.raise_error;
533: end if;
534: --

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

527: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
528: hr_utility.set_message_token('TYPE','BOOLEAN');
529: hr_utility.set_message_token('PARAMETER','P_NO_END_ELEMENT');
530: hr_utility.set_message_token('VALUE',c.p55);
531: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
532: hr_utility.raise_error;
533: end if;
534: --
535: if c.p57 is null then

Line 532: hr_utility.raise_error;

528: hr_utility.set_message_token('TYPE','BOOLEAN');
529: hr_utility.set_message_token('PARAMETER','P_NO_END_ELEMENT');
530: hr_utility.set_message_token('VALUE',c.p55);
531: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
532: hr_utility.raise_error;
533: end if;
534: --
535: if c.p57 is null then
536: L_PRTT_RT_VAL_ID:=nn;