5 Replies Latest reply: Jul 30, 2013 7:13 AM by 1009235 RSS

    Calling FND Request Submit Request from OAF page

    1009235

      Hi

       

      I am trying to call the FND_Request.submit_request function from my OAF page but I always get the error as “            

       

      13/07/29 16:43:09 java.sql.SQLException: ORA-06550: line 1, column 13:

      PLS-00306: wrong number or types of arguments in call to 'SUBMIT_REQUEST'

       

       

      I am passing the correct arguments and everything but I keep getting the above error.

       

       

      Below is the code ....

       

      Any thoughts ?

       

       

                          try

                    {
                                 

      String sSqlStmt  = "{? = call FND_REQUEST.submit_request(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, " +

      "?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}";

       

                                    cStmt =  conn.prepareCall(sSqlStmt);
                                    cStmt.registerOutParameter(1, Types.INTEGER);
                                    cStmt.setString(2,"PA");
                                    cStmt.setString(3,"PAIGEN");
                                    cStmt.setString(4,"Generate Draft Invoices for a Range of Projects");
                                    cStmt.setString(5,null);
                                    cStmt.setBoolean(6,false); 
                                    cStmt.setString(7,"CANCEL");
                                    cStmt.setString(8,sProjectID);
                                    cStmt.setString(9,sDraftInvcNum);
                                    cStmt.setString(10,"");
                                    cStmt.setString(11,"");cStmt.setString(12,"");cStmt.setString(13,"");cStmt.setString(14,"");cStmt.setString(15,"");cStmt.setString(16,"");cStmt.setString(17,"");cStmt.setString(18,"");cStmt.setString(19,"");cStmt.setString(20,""); (13,"");cStmt.setString(14,"");cStmt.setString(15,"");cStmt.setString   (16,"");cStmt.setString(17,"");cStmt.setString(18,"");cStmt.setString(19,"");cStmt.setString(20,"");
                                    cStmt.setString(21,"");cStmt.setString(22,"");cStmt.setString(23,"");cStmt.setString(24,"");cStmt.setString(25,"");cStmt.setString(26,"");cStmt.setString(27,"");cStmt.setString(28,null);cStmt.setString(29,"");cStmt.setString(30,"");
                                    cStmt.setString(31,"");cStmt.setString(32,"");cStmt.setString(33,"");cStmt.setString(34,"");cStmt.setString(35,"");cStmt.setString(36,"");cStmt.setString(37,"");cStmt.setString(38,"");cStmt.setString(39,"");cStmt.setString(40,"");
                                    cStmt.setString(41,"");cStmt.setString(42,"");cStmt.setString(43,"");cStmt.setString(44,"");cStmt.setString(45,"");cStmt.setString(46,"");cStmt.setString(47,"");cStmt.setString(48,"");cStmt.setString(49,"");cStmt.setString(50,"");
                                    cStmt.setString(51,"");cStmt.setString(52,"");cStmt.setString(53,"");cStmt.setString(54,"");cStmt.setString(55,"");cStmt.setString(56,"");cStmt.setString(57,"");cStmt.setString(58,"");cStmt.setString(59,"");cStmt.setString(60,"");
                                    cStmt.setString(61,"");cStmt.setString(62,"");cStmt.setString(63,"");cStmt.setString(64,"");cStmt.setString(65,"");cStmt.setString(66,"");cStmt.setString(67,"");cStmt.setString(68,"");cStmt.setString(69,"");cStmt.setString(70,"");
                                    cStmt.setString(71,"");cStmt.setString(72,"");cStmt.setString(73,"");cStmt.setString(74,"");cStmt.setString(75,"");cStmt.setString(76,"");cStmt.setString(77,"");cStmt.setString(78,"");cStmt.setString(79,"");cStmt.setString(80,"");
                                    cStmt.setString(81,"");cStmt.setString(82,"");cStmt.setString(83,"");cStmt.setString(84,"");cStmt.setString(85,"");cStmt.setString(86,"");cStmt.setString(87,"");cStmt.setString(88,"");cStmt.setString(89,"");cStmt.setString(90,"");
                                    cStmt.setString(91,"");cStmt.setString(92,"");cStmt.setString(93,"");cStmt.setString(94,"");cStmt.setString(95,"");cStmt.setString(96,"");cStmt.setString(97,"");cStmt.setString(98,"");cStmt.setString(99,"");cStmt.setString(100,"");
                                    cStmt.setString(101,"");cStmt.setString(102,"");cStmt.setString(103,"");cStmt.setString(104,"");cStmt.setString(105,"");cStmt.setString(106,"");
                                  
                                  
                                    cStmt.execute();
                                    int requestID = cStmt.getInt(1);
                                    System.out.println ("Request ID "  + requestID); 

       

                               }
                               catch(Exception e)
                               {
                                  System.out.println("ERRO" + e);

       

                                 System.out.println("ERRO" + e.getStackTrace());
                                 System.out.println("ERRO" + e.toString());
                                 throw OAException.wrapperException(e);

       

                               }