567: FND_MSG_PUB.Add;
568: BEGIN
569: SELECT start_date
570: INTO p_adjustment_rec.adjustment_date
571: FROM gmf_period_statuses
572: WHERE period_id = p_adjustment_rec.period_id;
573: EXCEPTION
574: WHEN no_data_found THEN
575: p_adjustment_rec.adjustment_date := SYSDATE;
577: ELSE
578: BEGIN
579: SELECT start_date, end_date
580: INTO l_start_date, l_end_date
581: FROM gmf_period_statuses
582: WHERE period_id = p_adjustment_rec.period_id;
583: EXCEPTION
584: WHEN no_data_found THEN
585: l_start_date := NULL;