AnsweredAssumed Answered

Restrict project hierarchy changes

Question asked by gauripalekar on Mar 22, 2011
Latest reply on Mar 24, 2011 by Akhil.Kakkar
We have a requirement to restrict hierarchy changes of certain projects, and show an error message to the user whenever there is a validation failure.

We have tried implementing this through a trigger on inv_hierarchies. When the validation fails, raise an application error in the trigger (added the corresponding error message in file).

However, when a child or parent is added for a project i.e. insert of record in the table, the error message doesn't show up on the Front End.
This is probably because Clarity redirects us to an intermediate screen for selecting parent/child(Sub project List Screen/ Investment Parent Child List). No custom error message is being displayed on this intermediate screen. Has any one come across such an issue ever?

If so, is there any work around for this?