DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_PUB dependencies on QP_PRICE_BOOK_MESSAGES_S

Line 78: SELECT qp_price_book_messages_s.nextval

74: x_return_status := 'E';
75: FND_MESSAGE.SET_NAME('QP', 'QP_INPUT_REC_NOT_FOUND');
76: l_message_text := FND_MESSAGE.GET;
77: BEGIN
78: SELECT qp_price_book_messages_s.nextval
79: INTO x_price_book_messages_tbl(1).message_id FROM dual;
80: EXCEPTION
81: WHEN OTHERS THEN
82: x_price_book_messages_tbl(1).message_id := NULL;

Line 147: SELECT qp_price_book_messages_s.nextval

143: x_return_status := 'E';
144: FND_MESSAGE.SET_NAME('QP', 'QP_FULL_PRICE_BOOK_MUST_EXIST');
145: l_message_text := FND_MESSAGE.GET;
146: BEGIN
147: SELECT qp_price_book_messages_s.nextval
148: INTO x_price_book_messages_tbl(1).message_id FROM dual;
149: EXCEPTION
150: WHEN OTHERS THEN
151: x_price_book_messages_tbl(1).message_id := NULL;

Line 199: SELECT qp_price_book_messages_s.nextval

195: x_return_status := 'E';
196: FND_MESSAGE.SET_NAME('QP', 'QP_FULL_PRICE_BOOK_MUST_EXIST');
197: l_message_text := FND_MESSAGE.GET;
198: BEGIN
199: SELECT qp_price_book_messages_s.nextval
200: INTO x_price_book_messages_tbl(1).message_id FROM dual;
201: EXCEPTION
202: WHEN OTHERS THEN
203: x_price_book_messages_tbl(1).message_id := NULL;