APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on AR_DUNNING_LETTER_SETS

Line 4502: ar_dunning_letter_sets . ' || 'x_return_status = ' ||

4498: x_return_status => x_return_status );
4499:
4500: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4501: hz_utility_v2pub.debug(p_message=>'dunning_letter_set_id is foreign key to
4502: ar_dunning_letter_sets . ' || 'x_return_status = ' ||
4503: x_return_status,
4504: p_prefix =>l_debug_prefix,
4505: p_msg_level=>fnd_log.level_statement);
4506: END IF; */

Line 11503: FROM ar_dunning_letter_sets dls

11499: l_dummy VARCHAR2(1);
11500:
11501: BEGIN
11502: SELECT 'Y' into l_dummy
11503: FROM ar_dunning_letter_sets dls
11504: WHERE dls.status = 'A'
11505: AND dls.dunning_letter_set_id =
11506: p_column_value;
11507: EXCEPTION

Line 11512: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_dunning_letter_sets');

11508: WHEN NO_DATA_FOUND THEN
11509: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11510: FND_MESSAGE.SET_TOKEN( 'FK', 'dunning_letter_set_id' );
11511: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11512: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_dunning_letter_sets');
11513: FND_MSG_PUB.ADD;
11514: x_return_status := FND_API.G_RET_STS_ERROR;
11515:
11516: END check_dunning_letid_fk;