216: */
217:
218: BEGIN
219: pv_effective_start_date :=
220: FND_DATE.Canonical_To_Date(v_effective_start_char);
221: pv_effective_end_date :=
222: FND_DATE.Canonical_To_Date(v_effective_end_char);
223: EXCEPTION
224: WHEN OTHERS THEN
218: BEGIN
219: pv_effective_start_date :=
220: FND_DATE.Canonical_To_Date(v_effective_start_char);
221: pv_effective_end_date :=
222: FND_DATE.Canonical_To_Date(v_effective_end_char);
223: EXCEPTION
224: WHEN OTHERS THEN
225:
226: pv_completion_status := 'WARNING';