0 Replies Latest reply on Jun 23, 2013 6:49 AM by Syed.Ali

    Validations in SSHR Transfer Request


      Hello Gurus,


      I would like to restrict the Managers to do Transfer of employee effective first day of any month. I thought that user hook of assignment will help, it helps but not in user friendly manner and not on the first page of transfer request, it will throw an SQL Exception defined in my hook package after 3 step in transfer request. The error looks like


      Exception Details.
      oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20040: The effective date should be first day of the month. ORA-06512: at "APPS.HR_PROCESS_ASSIGNMENT_SS", line 5940 ORA-06512: at "APPS.HR_PROCESS_ASSIGNMENT_SS", line 1959 ORA-06512: at line 1 at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912) at oracle.apps.per.selfservice.common.server.ProcessAssignment.processSave(ProcessAssignment.java:2763) at oracle.apps.per.selfservice.location.server.ChangeLocationVORowImpl.updateRow(ChangeLocationVORowImpl.java:207) at oracle.apps.fnd.framework.server.OAPlsqlViewRowImpl.callAPI(OAPlsqlViewRowImpl.java:111) at oracle.apps.fnd.framework.server.OAPlsqlViewObjectImpl.callAPI(OAPlsqlViewObjectImpl.java:163)



      How can I turn this into user friendly message on first page itself?



      Syed Ali