511: );
512:
513: else
514:
515: FND_MESSAGE.set_name('HXC','HXC_NO_TIMECARD_ID');
516: FND_MESSAGE.set_token('TIMECARD_ID',to_char(p_timecard_id));
517: FND_MESSAGE.raise_error;
518:
519: end if;
512:
513: else
514:
515: FND_MESSAGE.set_name('HXC','HXC_NO_TIMECARD_ID');
516: FND_MESSAGE.set_token('TIMECARD_ID',to_char(p_timecard_id));
517: FND_MESSAGE.raise_error;
518:
519: end if;
520:
513: else
514:
515: FND_MESSAGE.set_name('HXC','HXC_NO_TIMECARD_ID');
516: FND_MESSAGE.set_token('TIMECARD_ID',to_char(p_timecard_id));
517: FND_MESSAGE.raise_error;
518:
519: end if;
520:
521: End insert_summary_row;
580: delete from hxc_timecard_summary where timecard_id = p_timecard_id;
581:
582: Exception
583: When others then
584: FND_MESSAGE.set_name('HXC','HXC_NO_TIMECARD_ID');
585: FND_MESSAGE.raise_error;
586:
587: End delete_summary_row;
588:
581:
582: Exception
583: When others then
584: FND_MESSAGE.set_name('HXC','HXC_NO_TIMECARD_ID');
585: FND_MESSAGE.raise_error;
586:
587: End delete_summary_row;
588:
589: procedure reject_timecard(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is