175: -- API body
176:
177: IF p_start_id < -1 OR p_batch_size < 0
178: OR (p_start_id = -1 AND p_batch_size = 0) THEN
179: FND_MESSAGE.set_name('IBE', 'IBE_DSP_QUERY_INVLD');
180: FND_MESSAGE.set_token('0', TO_CHAR(p_start_id));
181: FND_MESSAGE.set_token('1', TO_CHAR(p_batch_size));
182: FND_MSG_PUB.add;
183: RAISE FND_API.g_exc_unexpected_error;
176:
177: IF p_start_id < -1 OR p_batch_size < 0
178: OR (p_start_id = -1 AND p_batch_size = 0) THEN
179: FND_MESSAGE.set_name('IBE', 'IBE_DSP_QUERY_INVLD');
180: FND_MESSAGE.set_token('0', TO_CHAR(p_start_id));
181: FND_MESSAGE.set_token('1', TO_CHAR(p_batch_size));
182: FND_MSG_PUB.add;
183: RAISE FND_API.g_exc_unexpected_error;
184: END IF;
177: IF p_start_id < -1 OR p_batch_size < 0
178: OR (p_start_id = -1 AND p_batch_size = 0) THEN
179: FND_MESSAGE.set_name('IBE', 'IBE_DSP_QUERY_INVLD');
180: FND_MESSAGE.set_token('0', TO_CHAR(p_start_id));
181: FND_MESSAGE.set_token('1', TO_CHAR(p_batch_size));
182: FND_MSG_PUB.add;
183: RAISE FND_API.g_exc_unexpected_error;
184: END IF;
185:
184: END IF;
185:
186: IF p_category_id IS NOT NULL
187: AND TRIM(p_item_applicable_to) <> 'CATEGORY' THEN
188: FND_MESSAGE.set_name('IBE', 'IBE_DSP_AVAIL_INVLD');
189: FND_MESSAGE.set_token('0', TO_CHAR(p_category_id));
190: FND_MESSAGE.set_token('1', p_item_applicable_to);
191: FND_MSG_PUB.add;
192: RAISE FND_API.g_exc_unexpected_error;
185:
186: IF p_category_id IS NOT NULL
187: AND TRIM(p_item_applicable_to) <> 'CATEGORY' THEN
188: FND_MESSAGE.set_name('IBE', 'IBE_DSP_AVAIL_INVLD');
189: FND_MESSAGE.set_token('0', TO_CHAR(p_category_id));
190: FND_MESSAGE.set_token('1', p_item_applicable_to);
191: FND_MSG_PUB.add;
192: RAISE FND_API.g_exc_unexpected_error;
193: END IF;
186: IF p_category_id IS NOT NULL
187: AND TRIM(p_item_applicable_to) <> 'CATEGORY' THEN
188: FND_MESSAGE.set_name('IBE', 'IBE_DSP_AVAIL_INVLD');
189: FND_MESSAGE.set_token('0', TO_CHAR(p_category_id));
190: FND_MESSAGE.set_token('1', p_item_applicable_to);
191: FND_MSG_PUB.add;
192: RAISE FND_API.g_exc_unexpected_error;
193: END IF;
194: