Posts

Showing posts from November, 2019

Showing Custom Error Message - Web ADI

Image
Showing Custom Error Message - Web ADI Standard Message like :-  but we don't understand that's why we required Custom message Custom Message: - is so proper and easy to understand. CREATE OR REPLACE PACKAGE APPS . XXSD_WEB_ADI_PROC   AS   PROCEDURE INSERT_XXSD_WEB_ADI_TL (   P_EMPLOYEE_NUMBER   VARCHAR2 , P_FIRST_NAME VARCHAR2 , P_LAST_NAME VARCHAR2 , P_DATE_OF_BIRTH DATE , P_GRADE VARCHAR2 , P_REMARKS VARCHAR2 , P_ATTRIBUTE1 VARCHAR2 , P_ATTRIBUTE2 VARCHAR2 , P_ATTRIBUTE3 VARCHAR2 , P_ATTRIBUTE4 VARCHAR2 , P_ATTRIBUTE5 VARCHAR2 , P_ATTRIBUTE6 VARCHAR2 , P_ATTRIBUTE7 VARCHAR2 , P_ATTRIBUTE8 VARCHAR2 , P_ATTRIBUTE9 VARCHAR2 , P_ATTRIBUTE10 VARCHAR2 );      END; --==========================   TYPE – 1 =============================== CREATE OR REPLACE PACKAGE BODY APPS . XXSD_WEB_ADI_PROC   AS PROCEDURE INSERT_XXSD_WEB_ADI_TL (   P_EMPLOYEE_NUMBER   VARCHAR2 , P_FIRST_NAME VARCHAR2 , P_L