APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on AR_DUNNING_LETTER_SETS

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

4525: x_return_status => x_return_status );
4526:
4527: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4528: hz_utility_v2pub.debug(p_message=>'dunning_letter_set_id is foreign key to
4529: ar_dunning_letter_sets . ' || 'x_return_status = ' ||
4530: x_return_status,
4531: p_prefix =>l_debug_prefix,
4532: p_msg_level=>fnd_log.level_statement);
4533: END IF;

Line 11795: FROM ar_dunning_letter_sets dls

11791: l_dummy VARCHAR2(1);
11792:
11793: BEGIN
11794: SELECT 'Y' into l_dummy
11795: FROM ar_dunning_letter_sets dls
11796: WHERE dls.status = 'A'
11797: AND dls.dunning_letter_set_id =
11798: p_column_value;
11799: EXCEPTION

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

11800: WHEN NO_DATA_FOUND THEN
11801: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11802: FND_MESSAGE.SET_TOKEN( 'FK', 'dunning_letter_set_id' );
11803: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11804: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_dunning_letter_sets');
11805: FND_MSG_PUB.ADD;
11806: x_return_status := FND_API.G_RET_STS_ERROR;
11807:
11808: END check_dunning_letid_fk;