2324: if P_UWQ_STATUS is null then
2325: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2326: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
2327: END IF;
2328: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2329: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
2330: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2331: FND_MSG_PUB.Add;
2332: RAISE FND_API.G_EXC_ERROR;
2325: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2326: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
2327: END IF;
2328: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2329: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
2330: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2331: FND_MSG_PUB.Add;
2332: RAISE FND_API.G_EXC_ERROR;
2333: end if;
2326: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
2327: END IF;
2328: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2329: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
2330: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2331: FND_MSG_PUB.Add;
2332: RAISE FND_API.G_EXC_ERROR;
2333: end if;
2334:
2341: if P_DELINQUENCY_ID_TBL.count = 0 then
2342: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2343: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
2344: END IF;
2345: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2346: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
2347: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2348: FND_MSG_PUB.Add;
2349: RAISE FND_API.G_EXC_ERROR;
2342: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2343: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
2344: END IF;
2345: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2346: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
2347: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2348: FND_MSG_PUB.Add;
2349: RAISE FND_API.G_EXC_ERROR;
2350: end if;
2343: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
2344: END IF;
2345: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2346: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
2347: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2348: FND_MSG_PUB.Add;
2349: RAISE FND_API.G_EXC_ERROR;
2350: end if;
2351:
2358: if P_NO_DAYS is not null and P_NO_DAYS < 0 then
2359: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2360: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
2361: END IF;
2362: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2363: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
2364: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2365: FND_MSG_PUB.Add;
2366: RAISE FND_API.G_EXC_ERROR;
2359: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2360: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
2361: END IF;
2362: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2363: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
2364: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2365: FND_MSG_PUB.Add;
2366: RAISE FND_API.G_EXC_ERROR;
2367: end if;
2360: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
2361: END IF;
2362: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2363: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
2364: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2365: FND_MSG_PUB.Add;
2366: RAISE FND_API.G_EXC_ERROR;
2367: end if;
2368: