DBA Data[Home] [Help]

APPS.SHP_GEN_UNIQUE_PKG dependencies on APP_EXCEPTION

Line 32: APP_EXCEPTION.RAISE_EXCEPTION;

28: dbms_sql.parse(rec_cursor,query_text,dbms_sql.v7);
29: any_found := dbms_sql.execute_and_fetch(rec_cursor);
30: IF (any_found > 0) THEN
31: FND_MESSAGE.SET_NAME(prod_name,msg_name);
32: APP_EXCEPTION.RAISE_EXCEPTION;
33: END IF;
34: END;
35:
36: PROCEDURE Get_Active_Date(query_text IN VARCHAR2,

Line 65: APP_EXCEPTION.Raise_Exception;

61: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
62: FND_MESSAGE.Set_Token('PACKAGE','SHP_GEN_UNIQUE_PKG');
63: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
64: FND_MESSAGE.Set_Token('ORA_TEXT',query_text);
65: APP_EXCEPTION.Raise_Exception;
66: END Get_Active_Date;
67:
68:
69: END SHP_GEN_UNIQUE_PKG;