Getting Error in PA_PROJECT_ASSETS_PUB.add_project_asset

Hi All,

I am getting error " ERROR: 1: ORA-01422: exact fetch returns more than requested number of rows in Package PA_PROJECT_ASSETS_PUB Procedure add_project_asset " in the API when trying to create asset via add_project_asset api.

Below is the script :

set serveroutput on;

DECLARE

l_msg_count        NUMBER;

l_msg_data        VARCHAR2(2000);

l_return_status      VARCHAR2(1);

l_init_msg_list   VARCHAR2(1) := 'F';

l_pa_project_id_out number;

l_pa_project_number_out number;

l_pa_project_asset_id_out number;

l_pm_asset_reference_out number;

-- Variables used specifically in error message retrieval

 l_encoded            VARCHAR2(1) := 'F';