5794: END IF;
5795:
5796: -- initialize the parameters
5797: x_records_count := 0;
5798: x_return_status := FND_API.G_RET_STS_SUCCESS ;
5799: l_success := 'N';
5800: l_geo_validation_passed := 'N';
5801:
5802: -- Maximum number of rows fetched from suggestion API. If more than this
5913: P_ATTRIBUTE8 => P_ATTRIBUTE8,
5914: P_ATTRIBUTE9 => P_ATTRIBUTE9,
5915: P_ATTRIBUTE10 => P_ATTRIBUTE10,
5916: P_CALLED_FROM => 'VALIDATE',
5917: P_LOCK_FLAG => FND_API.G_TRUE,
5918: X_ADDR_VAL_LEVEL => LX_ADDR_VAL_LEVEL,
5919: X_ADDR_WARN_MSG => LX_ADDR_WARN_MSG,
5920: X_ADDR_VAL_STATUS => LX_ADDR_VAL_STATUS,
5921: X_STATUS => LX_STATUS)
5920: X_ADDR_VAL_STATUS => LX_ADDR_VAL_STATUS,
5921: X_STATUS => LX_STATUS)
5922: ;
5923:
5924: IF (LX_STATUS <> FND_API.G_RET_STS_SUCCESS) THEN
5925: l_success := 'N';
5926:
5927: -- FND Logging for debug purpose
5928: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6566: );
6567: END IF;
6568:
6569: HZ_GNR_PVT.G_USER_ATTEMPT_COUNT := NULL; -- reset the global variable
6570: x_return_status := FND_API.G_RET_STS_ERROR ;
6571:
6572: -- set return code and return message
6573: setup_msg_and_ret_code_proc(p_return_code => 200); /* SYSTEM_ERROR (System Error) */
6574:
6576: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
6577: FND_MSG_PUB.ADD;
6578:
6579: FND_MSG_PUB.Count_And_Get(
6580: p_encoded => FND_API.G_FALSE,
6581: p_count => x_msg_count,
6582: p_data => x_msg_data );
6583:
6584: -- ns_debug.put_line(SUBSTR('ERROR :'||SQLERRM,1,255));