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;
83: END;
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;
152: END;
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;
204: END;
561: --customer associated with user
562: BEGIN
563: SELECT 'Y'
564: INTO l_party_id_match
565: FROM dual
566: WHERE EXISTS (
567: SELECT 'x'
568: FROM hz_relationships rel, hz_parties party3,
569: hz_parties party4, hz_parties party5