148: -- API body
149:
150: IF p_start_id < -1 OR p_batch_size < 0
151: OR (p_start_id = -1 AND p_batch_size = 0) THEN
152: FND_MESSAGE.set_name('JTF', 'JTF_DSP_QUERY_INVLD');
153: FND_MESSAGE.set_token('0', TO_CHAR(p_start_id));
154: FND_MESSAGE.set_token('1', TO_CHAR(p_batch_size));
155: FND_MSG_PUB.add;
156: RAISE FND_API.g_exc_unexpected_error;
149:
150: IF p_start_id < -1 OR p_batch_size < 0
151: OR (p_start_id = -1 AND p_batch_size = 0) THEN
152: FND_MESSAGE.set_name('JTF', 'JTF_DSP_QUERY_INVLD');
153: FND_MESSAGE.set_token('0', TO_CHAR(p_start_id));
154: FND_MESSAGE.set_token('1', TO_CHAR(p_batch_size));
155: FND_MSG_PUB.add;
156: RAISE FND_API.g_exc_unexpected_error;
157: END IF;
150: IF p_start_id < -1 OR p_batch_size < 0
151: OR (p_start_id = -1 AND p_batch_size = 0) THEN
152: FND_MESSAGE.set_name('JTF', 'JTF_DSP_QUERY_INVLD');
153: FND_MESSAGE.set_token('0', TO_CHAR(p_start_id));
154: FND_MESSAGE.set_token('1', TO_CHAR(p_batch_size));
155: FND_MSG_PUB.add;
156: RAISE FND_API.g_exc_unexpected_error;
157: END IF;
158:
157: END IF;
158:
159: IF p_category_id IS NOT NULL
160: AND TRIM(p_item_applicable_to) <> 'CATEGORY' THEN
161: FND_MESSAGE.set_name('JTF', 'JTF_DSP_AVAIL_INVLD');
162: FND_MESSAGE.set_token('0', TO_CHAR(p_category_id));
163: FND_MESSAGE.set_token('1', p_item_applicable_to);
164: FND_MSG_PUB.add;
165: RAISE FND_API.g_exc_unexpected_error;
158:
159: IF p_category_id IS NOT NULL
160: AND TRIM(p_item_applicable_to) <> 'CATEGORY' THEN
161: FND_MESSAGE.set_name('JTF', 'JTF_DSP_AVAIL_INVLD');
162: FND_MESSAGE.set_token('0', TO_CHAR(p_category_id));
163: FND_MESSAGE.set_token('1', p_item_applicable_to);
164: FND_MSG_PUB.add;
165: RAISE FND_API.g_exc_unexpected_error;
166: END IF;
159: IF p_category_id IS NOT NULL
160: AND TRIM(p_item_applicable_to) <> 'CATEGORY' THEN
161: FND_MESSAGE.set_name('JTF', 'JTF_DSP_AVAIL_INVLD');
162: FND_MESSAGE.set_token('0', TO_CHAR(p_category_id));
163: FND_MESSAGE.set_token('1', p_item_applicable_to);
164: FND_MSG_PUB.add;
165: RAISE FND_API.g_exc_unexpected_error;
166: END IF;
167: