DBA Data[Home] [Help]

APPS.HRDPP_CREATE_BEN_ASG dependencies on HR_UTILITY

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

572: hr_data_pump.entry('call');
573: open cr;
574: fetch cr into c;
575: if cr%notfound then
576: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
577: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
578: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
579: hr_utility.set_message_token('VALUE',p_batch_line_id);
580: hr_utility.raise_error;

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

573: open cr;
574: fetch cr into c;
575: if cr%notfound then
576: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
577: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
578: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
579: hr_utility.set_message_token('VALUE',p_batch_line_id);
580: hr_utility.raise_error;
581: end if;

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

574: fetch cr into c;
575: if cr%notfound then
576: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
577: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
578: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
579: hr_utility.set_message_token('VALUE',p_batch_line_id);
580: hr_utility.raise_error;
581: end if;
582: --

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

575: if cr%notfound then
576: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
577: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
578: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
579: hr_utility.set_message_token('VALUE',p_batch_line_id);
580: hr_utility.raise_error;
581: end if;
582: --
583: if upper(c.p1) = 'TRUE' then

Line 580: hr_utility.raise_error;

576: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
577: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
578: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
579: hr_utility.set_message_token('VALUE',p_batch_line_id);
580: hr_utility.raise_error;
581: end if;
582: --
583: if upper(c.p1) = 'TRUE' then
584: L_EVENT_MODE := true;

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

584: L_EVENT_MODE := true;
585: elsif upper(c.p1) = 'FALSE' then
586: L_EVENT_MODE := false;
587: elsif c.p1 is not null then
588: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
589: hr_utility.set_message_token('TYPE','BOOLEAN');
590: hr_utility.set_message_token('PARAMETER','P_EVENT_MODE');
591: hr_utility.set_message_token('VALUE',c.p1);
592: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');

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

585: elsif upper(c.p1) = 'FALSE' then
586: L_EVENT_MODE := false;
587: elsif c.p1 is not null then
588: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
589: hr_utility.set_message_token('TYPE','BOOLEAN');
590: hr_utility.set_message_token('PARAMETER','P_EVENT_MODE');
591: hr_utility.set_message_token('VALUE',c.p1);
592: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
593: hr_utility.raise_error;

Line 590: hr_utility.set_message_token('PARAMETER','P_EVENT_MODE');

586: L_EVENT_MODE := false;
587: elsif c.p1 is not null then
588: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
589: hr_utility.set_message_token('TYPE','BOOLEAN');
590: hr_utility.set_message_token('PARAMETER','P_EVENT_MODE');
591: hr_utility.set_message_token('VALUE',c.p1);
592: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
593: hr_utility.raise_error;
594: end if;

Line 591: hr_utility.set_message_token('VALUE',c.p1);

587: elsif c.p1 is not null then
588: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
589: hr_utility.set_message_token('TYPE','BOOLEAN');
590: hr_utility.set_message_token('PARAMETER','P_EVENT_MODE');
591: hr_utility.set_message_token('VALUE',c.p1);
592: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
593: hr_utility.raise_error;
594: end if;
595: --

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

588: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
589: hr_utility.set_message_token('TYPE','BOOLEAN');
590: hr_utility.set_message_token('PARAMETER','P_EVENT_MODE');
591: hr_utility.set_message_token('VALUE',c.p1);
592: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
593: hr_utility.raise_error;
594: end if;
595: --
596: if c.p71 is null then

Line 593: hr_utility.raise_error;

589: hr_utility.set_message_token('TYPE','BOOLEAN');
590: hr_utility.set_message_token('PARAMETER','P_EVENT_MODE');
591: hr_utility.set_message_token('VALUE',c.p1);
592: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
593: hr_utility.raise_error;
594: end if;
595: --
596: if c.p71 is null then
597: L_PERSON_ID:=nn;