APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on AR_STANDARD_TEXT

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

5506:
5507: ------------------------------------
5508: -- validate message_text_id
5509: ------------------------------------
5510: -- 1. message_text_id should be a valid value defined in AR_STANDARD_TEXT
5511: -- 2. Message text can be entered only when late charge type is debit memo or interest invoice
5512:
5513: IF ((p_customer_profile_rec.late_charge_type = 'ADJ') AND
5514: (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 5535: hz_utility_v2pub.debug(p_message=>'message_text_id should be a valid value defined in AR_STANDARD_TEXT. '||

5531: p_column_value => p_customer_profile_rec.message_text_id,
5532: x_return_status => x_return_status );
5533:
5534: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5535: hz_utility_v2pub.debug(p_message=>'message_text_id should be a valid value defined in AR_STANDARD_TEXT. '||
5536: 'x_return_status = ' || x_return_status,
5537: p_prefix =>l_debug_prefix,
5538: p_msg_level=>fnd_log.level_statement);
5539: END IF;

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

11372: l_dummy VARCHAR2(1);
11373: BEGIN
11374:
11375: -- Validate that the message_text_id passed should be a valid
11376: -- value in AR_STANDARD_TEXT.STANDARD_TEXT_ID. bug # 5065436
11377: SELECT 'Y'
11378: into l_dummy
11379: from AR_STANDARD_TEXT
11380: where STANDARD_TEXT_ID = p_column_value

Line 11379: from AR_STANDARD_TEXT

11375: -- Validate that the message_text_id passed should be a valid
11376: -- value in AR_STANDARD_TEXT.STANDARD_TEXT_ID. bug # 5065436
11377: SELECT 'Y'
11378: into l_dummy
11379: from AR_STANDARD_TEXT
11380: where STANDARD_TEXT_ID = p_column_value
11381: and trunc(sysdate) between
11382: start_date and nvl(end_date,trunc(sysdate));
11383: EXCEPTION

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

11384: WHEN NO_DATA_FOUND THEN
11385: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11386: FND_MESSAGE.SET_TOKEN( 'FK', 'standard_text_id' );
11387: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11388: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_standard_text' );
11389: FND_MSG_PUB.ADD;
11390: x_return_status := FND_API.G_RET_STS_ERROR;
11391: END check_message_text_id_fk;
11392: