APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on GL_DAILY_CONVERSION_TYPES

Line 6253: -- exchange_rate_type should be a valid value defined in GL_DAILY_CONVERSION_TYPES

6249:
6250: ------------------------------------
6251: -- validate exchange_rate_type
6252: ------------------------------------
6253: -- exchange_rate_type should be a valid value defined in GL_DAILY_CONVERSION_TYPES
6254: -- The type USER is excluded.
6255:
6256: IF p_cust_profile_amt_rec.exchange_rate_type is NOT NULL AND
6257: p_cust_profile_amt_rec.exchange_rate_type <> FND_API.G_MISS_CHAR

Line 6269: hz_utility_v2pub.debug(p_message=>'exchange_rate_type should be a valid value defined in GL_DAILY_CONVERSION_TYPES. '||

6265: p_column_value => p_cust_profile_amt_rec.exchange_rate_type,
6266: x_return_status => x_return_status );
6267:
6268: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6269: hz_utility_v2pub.debug(p_message=>'exchange_rate_type should be a valid value defined in GL_DAILY_CONVERSION_TYPES. '||
6270: 'x_return_status = ' || x_return_status,
6271: p_prefix =>l_debug_prefix,
6272: p_msg_level=>fnd_log.level_statement);
6273: END IF;

Line 11111: -- value in GL_DAILY_CONVERSION_TYPES. where type is not USER. bug # 5065436

11107: l_dummy VARCHAR2(1);
11108: BEGIN
11109:
11110: -- Validate that the exchange_rate_type passed should be a valid
11111: -- value in GL_DAILY_CONVERSION_TYPES. where type is not USER. bug # 5065436
11112: SELECT 'Y'
11113: into l_dummy
11114: from gl_daily_conversion_types
11115: where conversion_type <> 'USER'

Line 11114: from gl_daily_conversion_types

11110: -- Validate that the exchange_rate_type passed should be a valid
11111: -- value in GL_DAILY_CONVERSION_TYPES. where type is not USER. bug # 5065436
11112: SELECT 'Y'
11113: into l_dummy
11114: from gl_daily_conversion_types
11115: where conversion_type <> 'USER'
11116: and conversion_type = p_column_value;
11117:
11118: EXCEPTION

Line 11123: FND_MESSAGE.SET_TOKEN( 'TABLE', 'gl_daily_conversion_types' );

11119: WHEN NO_DATA_FOUND THEN
11120: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11121: FND_MESSAGE.SET_TOKEN( 'FK', 'conversion_type' );
11122: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11123: FND_MESSAGE.SET_TOKEN( 'TABLE', 'gl_daily_conversion_types' );
11124: FND_MSG_PUB.ADD;
11125: x_return_status := FND_API.G_RET_STS_ERROR;
11126: END check_exchange_rate_type_fk;
11127: