2247: if P_UWQ_STATUS is null then
2248: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2249: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
2250: END IF;
2251: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2252: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
2253: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2254: FND_MSG_PUB.Add;
2255: RAISE FND_API.G_EXC_ERROR;
2248: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2249: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
2250: END IF;
2251: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2252: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
2253: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2254: FND_MSG_PUB.Add;
2255: RAISE FND_API.G_EXC_ERROR;
2256: end if;
2249: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
2250: END IF;
2251: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2252: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
2253: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2254: FND_MSG_PUB.Add;
2255: RAISE FND_API.G_EXC_ERROR;
2256: end if;
2257:
2264: if P_DELINQUENCY_ID_TBL.count = 0 then
2265: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2266: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
2267: END IF;
2268: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2269: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
2270: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2271: FND_MSG_PUB.Add;
2272: RAISE FND_API.G_EXC_ERROR;
2265: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2266: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
2267: END IF;
2268: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2269: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
2270: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2271: FND_MSG_PUB.Add;
2272: RAISE FND_API.G_EXC_ERROR;
2273: end if;
2266: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
2267: END IF;
2268: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2269: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
2270: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2271: FND_MSG_PUB.Add;
2272: RAISE FND_API.G_EXC_ERROR;
2273: end if;
2274:
2281: if P_NO_DAYS is not null and P_NO_DAYS < 0 then
2282: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2283: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
2284: END IF;
2285: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2286: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
2287: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2288: FND_MSG_PUB.Add;
2289: RAISE FND_API.G_EXC_ERROR;
2282: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2283: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
2284: END IF;
2285: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2286: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
2287: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2288: FND_MSG_PUB.Add;
2289: RAISE FND_API.G_EXC_ERROR;
2290: end if;
2283: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
2284: END IF;
2285: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2286: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
2287: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2288: FND_MSG_PUB.Add;
2289: RAISE FND_API.G_EXC_ERROR;
2290: end if;
2291: