IF v_status<>'PRODUCTION' THEN
  FND_MESSAGE.SET_STRING('The item status is Not Production.'||chr(10)|| 'A Scheduling OR Cancel Action has been triggered. '||chr(10)|| 'Do you want to continue with the transaction?'||chr(10)|| 'Item Type : '||v_item||chr(10)||'Item Status : ' ||v_status||chr(10)||'Item Product Line: '||v_item_line||chr(10)||'Planner Name : '||v_name);
  l_button_selected:=fnd_message.question(button1 => 'Cancel', button2 => 'No', button3 => 'Yes', default_btn => 2, cancel_btn => 1, icon => 'question');
  fnd_message.show;
  IF l_button_selected = 1 THEN -- 1 cancel
    v_test            :='cancel';
    FND_MESSAGE.SET_STRING('This is a test message confirmation_1'||l_button_selected);
    fnd_message.error;
    Raise form_trigger_failure ;
  END IF;
  IF l_button_selected = 2 THEN -- 2 No
    FND_MESSAGE.SET_STRING('This is a test message confirmation_2'||l_button_selected);
    fnd_message.show;
    fnd_message.error;
    Raise form_trigger_failure;
  END IF;
  IF l_button_selected = 3 THEN -- 3 Yes
    FND_MESSAGE.SET_STRING('This is a test message confirmation_3'||l_button_selected);
    fnd_message.show;
    NULL;
  END IF;
END IF;
END IF;
EXCEPTION
WHEN OTHERS THEN
  Raise Form_Trigger_Failure ;
END;