APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on AR_STANDARD_TEXT

Line 5453: -- 1. message_text_id should be a valid value defined in AR_STANDARD_TEXT

5449:
5450: ------------------------------------
5451: -- validate message_text_id
5452: ------------------------------------
5453: -- 1. message_text_id should be a valid value defined in AR_STANDARD_TEXT
5454: -- 2. Message text can be entered only when late charge type is debit memo or interest invoice
5455:
5456: IF ((p_customer_profile_rec.late_charge_type = 'ADJ') AND
5457: (p_customer_profile_rec.message_text_id IS NOT NULL AND p_customer_profile_rec.message_text_id <> FND_API.G_MISS_NUM)) THEN

Line 5478: hz_utility_v2pub.debug(p_message=>'message_text_id should be a valid value defined in AR_STANDARD_TEXT. '||

5474: p_column_value => p_customer_profile_rec.message_text_id,
5475: x_return_status => x_return_status );
5476:
5477: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5478: hz_utility_v2pub.debug(p_message=>'message_text_id should be a valid value defined in AR_STANDARD_TEXT. '||
5479: 'x_return_status = ' || x_return_status,
5480: p_prefix =>l_debug_prefix,
5481: p_msg_level=>fnd_log.level_statement);
5482: END IF;

Line 11085: -- value in AR_STANDARD_TEXT.STANDARD_TEXT_ID. bug # 5065436

11081: l_dummy VARCHAR2(1);
11082: BEGIN
11083:
11084: -- Validate that the message_text_id passed should be a valid
11085: -- value in AR_STANDARD_TEXT.STANDARD_TEXT_ID. bug # 5065436
11086: SELECT 'Y'
11087: into l_dummy
11088: from AR_STANDARD_TEXT
11089: where STANDARD_TEXT_ID = p_column_value

Line 11088: from AR_STANDARD_TEXT

11084: -- Validate that the message_text_id passed should be a valid
11085: -- value in AR_STANDARD_TEXT.STANDARD_TEXT_ID. bug # 5065436
11086: SELECT 'Y'
11087: into l_dummy
11088: from AR_STANDARD_TEXT
11089: where STANDARD_TEXT_ID = p_column_value
11090: and trunc(sysdate) between
11091: start_date and nvl(end_date,trunc(sysdate));
11092: EXCEPTION

Line 11097: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_standard_text' );

11093: WHEN NO_DATA_FOUND THEN
11094: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11095: FND_MESSAGE.SET_TOKEN( 'FK', 'standard_text_id' );
11096: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11097: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_standard_text' );
11098: FND_MSG_PUB.ADD;
11099: x_return_status := FND_API.G_RET_STS_ERROR;
11100: END check_message_text_id_fk;
11101: