ORA-01403 no data found error in form

Hi,

I have a custom form that uses special menu from Tools. The form is not performing the intended function so while figuring out the cause I see there is a select into statement within the form (when-button-pressed) event. This select statement gives me an output when I run in sql developer. But the same sql statement gives ORA-01403 in the form. I used debugging messages through out the when-button-pressed code to see where it is erroring out. It shows the message before the select statement and immediately gives me ora-01403 error. I did assign the value manually to avoid