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;
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;
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: --
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
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;
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');
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;
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;
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: --
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
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;