0 Replies Latest reply on Jun 4, 2009 12:58 PM by Jegan

    HRMS API Error

    Jegan
      Hi Gurus,


      In HRMS API

      APPS.HR_ASSIGNMENT_API.UPDATE_EMP_ASG_CRITERIA i get error as

      ORA-20001: You must enter GRE details for the assignment.

      The API is used is

      DECLARE
      P_EFFECTIVE_DATE DATE;
      P_DATETRACK_UPDATE_MODE VARCHAR2(200);
      P_ASSIGNMENT_ID NUMBER;
      P_VALIDATE BOOLEAN;
      P_CALLED_FROM_MASS_UPDATE BOOLEAN;
      P_GRADE_ID NUMBER;
      P_POSITION_ID NUMBER;
      P_JOB_ID NUMBER;
      P_PAYROLL_ID NUMBER;
      P_LOCATION_ID NUMBER;
      P_ORGANIZATION_ID NUMBER;
      P_PAY_BASIS_ID NUMBER;
      P_SEGMENT1 VARCHAR2(200);
      P_SEGMENT2 VARCHAR2(200);
      P_SEGMENT3 VARCHAR2(200);
      P_SEGMENT4 VARCHAR2(200);
      P_SEGMENT5 VARCHAR2(200);
      P_SEGMENT6 VARCHAR2(200);
      P_SEGMENT7 VARCHAR2(200);
      P_SEGMENT8 VARCHAR2(200);
      P_SEGMENT9 VARCHAR2(200);
      P_SEGMENT10 VARCHAR2(200);
      P_SEGMENT11 VARCHAR2(200);
      P_SEGMENT12 VARCHAR2(200);
      P_SEGMENT13 VARCHAR2(200);
      P_SEGMENT14 VARCHAR2(200);
      P_SEGMENT15 VARCHAR2(200);
      P_SEGMENT16 VARCHAR2(200);
      P_SEGMENT17 VARCHAR2(200);
      P_SEGMENT18 VARCHAR2(200);
      P_SEGMENT19 VARCHAR2(200);
      P_SEGMENT20 VARCHAR2(200);
      P_SEGMENT21 VARCHAR2(200);
      P_SEGMENT22 VARCHAR2(200);
      P_SEGMENT23 VARCHAR2(200);
      P_SEGMENT24 VARCHAR2(200);
      P_SEGMENT25 VARCHAR2(200);
      P_SEGMENT26 VARCHAR2(200);
      P_SEGMENT27 VARCHAR2(200);
      P_SEGMENT28 VARCHAR2(200);
      P_SEGMENT29 VARCHAR2(200);
      P_SEGMENT30 VARCHAR2(200);
      P_EMPLOYMENT_CATEGORY VARCHAR2(200);
      P_CONCAT_SEGMENTS VARCHAR2(200);
      P_GRADE_LADDER_PGM_ID NUMBER;
      P_SUPERVISOR_ASSIGNMENT_ID NUMBER;
      P_PEOPLE_GROUP_ID NUMBER;
      P_OBJECT_VERSION_NUMBER NUMBER;
      P_SPECIAL_CEILING_STEP_ID NUMBER;
      P_GROUP_NAME VARCHAR2(200);
      P_EFFECTIVE_START_DATE DATE;
      P_EFFECTIVE_END_DATE DATE;
      P_ORG_NOW_NO_MANAGER_WARNING BOOLEAN;
      P_OTHER_MANAGER_WARNING BOOLEAN;
      P_SPP_DELETE_WARNING BOOLEAN;
      P_ENTRIES_CHANGED_WARNING VARCHAR2(200);
      P_TAX_DISTRICT_CHANGED_WARNING BOOLEAN;

      FUNCTION BOOL2CHAR(bool IN boolean) RETURN varchar2 IS
      BEGIN
      IF bool THEN RETURN 'TRUE';
      ELSIF NOT bool THEN RETURN 'FALSE';
      ELSE RETURN 'NULL'; END IF;
      END;

      BEGIN
      P_EFFECTIVE_DATE := '3-JUN-2009';
      P_DATETRACK_UPDATE_MODE := 'CORRECTION';
      P_ASSIGNMENT_ID := 52511;
      P_VALIDATE := FALSE;
      P_CALLED_FROM_MASS_UPDATE := NULL;
      P_GRADE_ID := 68;
      P_POSITION_ID := 507;
      P_JOB_ID := 232;
      P_PAYROLL_ID := 112;
      P_LOCATION_ID := 431;
      P_ORGANIZATION_ID := 650;
      P_PAY_BASIS_ID := 24;
      P_SEGMENT1 := NULL;
      P_SEGMENT2 := NULL;
      P_SEGMENT3 := NULL;
      P_SEGMENT4 := NULL;
      P_SEGMENT5 := NULL;
      P_SEGMENT6 := NULL;
      P_SEGMENT7 := NULL;
      P_SEGMENT8 := NULL;
      P_SEGMENT9 := NULL;
      P_SEGMENT10 := NULL;
      P_SEGMENT11 := NULL;
      P_SEGMENT12 := NULL;
      P_SEGMENT13 := NULL;
      P_SEGMENT14 := NULL;
      P_SEGMENT15 := NULL;
      P_SEGMENT16 := NULL;
      P_SEGMENT17 := NULL;
      P_SEGMENT18 := NULL;
      P_SEGMENT19 := NULL;
      P_SEGMENT20 := NULL;
      P_SEGMENT21 := NULL;
      P_SEGMENT22 := NULL;
      P_SEGMENT23 := NULL;
      P_SEGMENT24 := NULL;
      P_SEGMENT25 := NULL;
      P_SEGMENT26 := NULL;
      P_SEGMENT27 := NULL;
      P_SEGMENT28 := NULL;
      P_SEGMENT29 := NULL;
      P_SEGMENT30 := NULL;
      P_EMPLOYMENT_CATEGORY := NULL;
      P_CONCAT_SEGMENTS := NULL;
      P_GRADE_LADDER_PGM_ID := NULL;
      P_SUPERVISOR_ASSIGNMENT_ID := NULL;
      P_PEOPLE_GROUP_ID := NULL;
      P_OBJECT_VERSION_NUMBER := 1;
      P_SPECIAL_CEILING_STEP_ID := NULL;
      P_GROUP_NAME := NULL;
      P_EFFECTIVE_START_DATE := '3-JUN-2009';
      P_EFFECTIVE_END_DATE := '3-JUN-2009';
      P_ORG_NOW_NO_MANAGER_WARNING := NULL;
      P_OTHER_MANAGER_WARNING := NULL;
      P_SPP_DELETE_WARNING := NULL;
      P_ENTRIES_CHANGED_WARNING := NULL;
      P_TAX_DISTRICT_CHANGED_WARNING := NULL;

      APPS.HR_ASSIGNMENT_API.UPDATE_EMP_ASG_CRITERIA ( P_EFFECTIVE_DATE, P_DATETRACK_UPDATE_MODE, P_ASSIGNMENT_ID, P_VALIDATE, P_CALLED_FROM_MASS_UPDATE, P_GRADE_ID, P_POSITION_ID, P_JOB_ID, P_PAYROLL_ID, P_LOCATION_ID, P_ORGANIZATION_ID, P_PAY_BASIS_ID, P_SEGMENT1, P_SEGMENT2, P_SEGMENT3, P_SEGMENT4, P_SEGMENT5, P_SEGMENT6, P_SEGMENT7, P_SEGMENT8, P_SEGMENT9, P_SEGMENT10, P_SEGMENT11, P_SEGMENT12, P_SEGMENT13, P_SEGMENT14, P_SEGMENT15, P_SEGMENT16, P_SEGMENT17, P_SEGMENT18, P_SEGMENT19, P_SEGMENT20, P_SEGMENT21, P_SEGMENT22, P_SEGMENT23, P_SEGMENT24, P_SEGMENT25, P_SEGMENT26, P_SEGMENT27, P_SEGMENT28, P_SEGMENT29, P_SEGMENT30, P_EMPLOYMENT_CATEGORY, P_CONCAT_SEGMENTS, P_GRADE_LADDER_PGM_ID, P_SUPERVISOR_ASSIGNMENT_ID, P_PEOPLE_GROUP_ID, P_OBJECT_VERSION_NUMBER, P_SPECIAL_CEILING_STEP_ID, P_GROUP_NAME, P_EFFECTIVE_START_DATE, P_EFFECTIVE_END_DATE, P_ORG_NOW_NO_MANAGER_WARNING, P_OTHER_MANAGER_WARNING, P_SPP_DELETE_WARNING, P_ENTRIES_CHANGED_WARNING, P_TAX_DISTRICT_CHANGED_WARNING );

      DBMS_OUTPUT.Put_Line('P_PEOPLE_GROUP_ID = ' || TO_CHAR(P_PEOPLE_GROUP_ID));
      DBMS_OUTPUT.Put_Line('P_OBJECT_VERSION_NUMBER = ' || TO_CHAR(P_OBJECT_VERSION_NUMBER));
      DBMS_OUTPUT.Put_Line('P_SPECIAL_CEILING_STEP_ID = ' || TO_CHAR(P_SPECIAL_CEILING_STEP_ID));
      DBMS_OUTPUT.Put_Line('P_GROUP_NAME = ' || P_GROUP_NAME);
      DBMS_OUTPUT.Put_Line('P_EFFECTIVE_START_DATE = ' || P_EFFECTIVE_START_DATE);
      DBMS_OUTPUT.Put_Line('P_EFFECTIVE_END_DATE = ' || P_EFFECTIVE_END_DATE);
      DBMS_OUTPUT.Put_Line('P_ORG_NOW_NO_MANAGER_WARNING = ' || BOOL2CHAR(P_ORG_NOW_NO_MANAGER_WARNING));
      DBMS_OUTPUT.Put_Line('P_OTHER_MANAGER_WARNING = ' || BOOL2CHAR(P_OTHER_MANAGER_WARNING));
      DBMS_OUTPUT.Put_Line('P_SPP_DELETE_WARNING = ' || BOOL2CHAR(P_SPP_DELETE_WARNING));
      DBMS_OUTPUT.Put_Line('P_ENTRIES_CHANGED_WARNING = ' || P_ENTRIES_CHANGED_WARNING);
      DBMS_OUTPUT.Put_Line('P_TAX_DISTRICT_CHANGED_WARNING = ' || BOOL2CHAR(P_TAX_DISTRICT_CHANGED_WARNING));

      DBMS_OUTPUT.Put_Line('');

      COMMIT;
      END;



      Thanks in Advance,
      Jegan