I need some suggestion in forms development. I am working on custom form, i need to do the validations to the record when there is update (change)to the record. I tried to implement new validations in when-validate-record trigger. I need to stop processing at some point. I have used raise-form-trigger failure. Its causing problem for me. The header level and line level information getting overlapped. I tried to do same validation at pre-update and pre-insert trigger. The pre-update trigger getting fired for each line record even there is no update .Is any other trigger i can do validations?
even i tried in on-insert or on-update trigger , same issue
When i wont use the raise form trigger failure no issues, but i have to stop processing. Even in form they have already taken care other validations with raise form tirgger failure. no issues that time. But one main thing is when i open form in query mode and query for particular order number its opening the form and when i switched to line tab, the form showing that frm-40400 3 records got applied and saved even i wont make any changes to the form. Its showing that only for opened (line types) opened.