459: );
460:
461: else
462:
463: FND_MESSAGE.set_name('HXC','HXC_NO_TIMECARD_ID');
464: FND_MESSAGE.set_token('TIMECARD_ID',to_char(p_timecard_id));
465: FND_MESSAGE.raise_error;
466:
467: end if;
460:
461: else
462:
463: FND_MESSAGE.set_name('HXC','HXC_NO_TIMECARD_ID');
464: FND_MESSAGE.set_token('TIMECARD_ID',to_char(p_timecard_id));
465: FND_MESSAGE.raise_error;
466:
467: end if;
468:
461: else
462:
463: FND_MESSAGE.set_name('HXC','HXC_NO_TIMECARD_ID');
464: FND_MESSAGE.set_token('TIMECARD_ID',to_char(p_timecard_id));
465: FND_MESSAGE.raise_error;
466:
467: end if;
468:
469: End insert_summary_row;
528: delete from hxc_timecard_summary where timecard_id = p_timecard_id;
529:
530: Exception
531: When others then
532: FND_MESSAGE.set_name('HXC','HXC_NO_TIMECARD_ID');
533: FND_MESSAGE.raise_error;
534:
535: End delete_summary_row;
536:
529:
530: Exception
531: When others then
532: FND_MESSAGE.set_name('HXC','HXC_NO_TIMECARD_ID');
533: FND_MESSAGE.raise_error;
534:
535: End delete_summary_row;
536:
537: procedure reject_timecard(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is