APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on GL_DAILY_CONVERSION_TYPES

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

6306:
6307: ------------------------------------
6308: -- validate exchange_rate_type
6309: ------------------------------------
6310: -- exchange_rate_type should be a valid value defined in GL_DAILY_CONVERSION_TYPES
6311: -- The type USER is excluded.
6312:
6313: IF p_cust_profile_amt_rec.exchange_rate_type is NOT NULL AND
6314: p_cust_profile_amt_rec.exchange_rate_type <> FND_API.G_MISS_CHAR

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

6322: p_column_value => p_cust_profile_amt_rec.exchange_rate_type,
6323: x_return_status => x_return_status );
6324:
6325: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6326: hz_utility_v2pub.debug(p_message=>'exchange_rate_type should be a valid value defined in GL_DAILY_CONVERSION_TYPES. '||
6327: 'x_return_status = ' || x_return_status,
6328: p_prefix =>l_debug_prefix,
6329: p_msg_level=>fnd_log.level_statement);
6330: END IF;

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

11398: l_dummy VARCHAR2(1);
11399: BEGIN
11400:
11401: -- Validate that the exchange_rate_type passed should be a valid
11402: -- value in GL_DAILY_CONVERSION_TYPES. where type is not USER. bug # 5065436
11403: SELECT 'Y'
11404: into l_dummy
11405: from gl_daily_conversion_types
11406: where conversion_type <> 'USER'

Line 11405: from gl_daily_conversion_types

11401: -- Validate that the exchange_rate_type passed should be a valid
11402: -- value in GL_DAILY_CONVERSION_TYPES. where type is not USER. bug # 5065436
11403: SELECT 'Y'
11404: into l_dummy
11405: from gl_daily_conversion_types
11406: where conversion_type <> 'USER'
11407: and conversion_type = p_column_value;
11408:
11409: EXCEPTION

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

11410: WHEN NO_DATA_FOUND THEN
11411: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11412: FND_MESSAGE.SET_TOKEN( 'FK', 'conversion_type' );
11413: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11414: FND_MESSAGE.SET_TOKEN( 'TABLE', 'gl_daily_conversion_types' );
11415: FND_MSG_PUB.ADD;
11416: x_return_status := FND_API.G_RET_STS_ERROR;
11417: END check_exchange_rate_type_fk;
11418: