APPS.SHP_GEN_UNIQUE_PKG dependencies on FND_MESSAGE

Line 31: FND_MESSAGE.SET_NAME(prod_name,msg_name);

27: rec_cursor := dbms_sql.open_cursor;
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:

Line 61: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');

57:
58: EXCEPTION
59: WHEN OTHERS THEN
60: dbms_sql.close_cursor(rec_cursor);
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;

Line 62: FND_MESSAGE.Set_Token('PACKAGE','SHP_GEN_UNIQUE_PKG');

58: EXCEPTION
59: WHEN OTHERS THEN
60: dbms_sql.close_cursor(rec_cursor);
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;

Line 63: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));

59: WHEN OTHERS THEN
60: dbms_sql.close_cursor(rec_cursor);
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:

Line 64: FND_MESSAGE.Set_Token('ORA_TEXT',query_text);

60: dbms_sql.close_cursor(rec_cursor);
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: