APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on AR_CHARGE_SCHEDULES

Line 6454: -- Validated against ar_charge_schedules.schedule_id.

6450: -- Must be null if interest_type <> FIXED_RATE OR interest_type is null
6451: -- interest_fixed_amount is populated and mandatory only if interest_type = FIXED_AMOUNT.
6452: -- Must be null if interest_type <> FIXED_AMOUNT OR interest_type is null
6453: -- interest_schedule_id is populated and mandatory if only if interest_type is CHARGES_SCHEDULE or CHARGE_PER_TIER.
6454: -- Validated against ar_charge_schedules.schedule_id.
6455:
6456: IF p_create_update_flag = 'U' THEN
6457: IF p_cust_profile_amt_rec.interest_type is NULL THEN
6458: v_cust_profile_amt_rec.interest_type := l_interest_type;

Line 6535: hz_utility_v2pub.debug(p_message=>'interest_schedule_id should be a valid value defined in ar_charge_schedules' ||'x_return_status = ' ||

6531: p_column_value => v_cust_profile_amt_rec.interest_schedule_id,
6532: x_return_status => x_return_status );
6533:
6534: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6535: hz_utility_v2pub.debug(p_message=>'interest_schedule_id should be a valid value defined in ar_charge_schedules' ||'x_return_status = ' ||
6536: x_return_status,
6537: p_prefix =>l_debug_prefix,
6538: p_msg_level=>fnd_log.level_statement);
6539: END IF;

Line 6566: -- Validated against ar_charge_schedules.schedule_id.

6562: -- Must be null if penalty_type <> FIXED_RATE OR penalty_type is null
6563: -- penalty_fixed_amount is populated and mandatory only if penalty_type = FIXED_AMOUNT.
6564: -- Must be null if penalty_type <> FIXED_AMOUNT OR penalty_type is null
6565: -- penalty_schedule_id is populated and mandatory if only if penalty_type in CHARGES_SCHEDULE or CHARGE_PER_TIER.
6566: -- Validated against ar_charge_schedules.schedule_id.
6567:
6568: IF p_create_update_flag = 'U' THEN
6569: IF p_cust_profile_amt_rec.penalty_type is NULL THEN
6570: v_cust_profile_amt_rec.penalty_type := l_penalty_type;

Line 6647: hz_utility_v2pub.debug(p_message=>'penalty_schedule_id should be a valid value defined in ar_charge_schedules' ||'x_return_status = ' ||

6643: p_column_value => v_cust_profile_amt_rec.penalty_schedule_id,
6644: x_return_status => x_return_status );
6645:
6646: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6647: hz_utility_v2pub.debug(p_message=>'penalty_schedule_id should be a valid value defined in ar_charge_schedules' ||'x_return_status = ' ||
6648: x_return_status,
6649: p_prefix =>l_debug_prefix,
6650: p_msg_level=>fnd_log.level_statement);
6651: END IF;

Line 11137: -- value in ar_charge_schedules. bug # 5065436

11133: l_dummy VARCHAR2(1);
11134: BEGIN
11135:
11136: -- Validate that the schedule_id passed should be a valid
11137: -- value in ar_charge_schedules. bug # 5065436
11138: SELECT 'Y'
11139: into l_dummy
11140: from ar_charge_schedules
11141: where schedule_id = p_column_value;

Line 11140: from ar_charge_schedules

11136: -- Validate that the schedule_id passed should be a valid
11137: -- value in ar_charge_schedules. bug # 5065436
11138: SELECT 'Y'
11139: into l_dummy
11140: from ar_charge_schedules
11141: where schedule_id = p_column_value;
11142:
11143: EXCEPTION
11144: WHEN NO_DATA_FOUND THEN

Line 11148: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_charge_schedules' );

11144: WHEN NO_DATA_FOUND THEN
11145: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11146: FND_MESSAGE.SET_TOKEN( 'FK', 'schedule_id' );
11147: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11148: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_charge_schedules' );
11149: FND_MSG_PUB.ADD;
11150: x_return_status := FND_API.G_RET_STS_ERROR;
11151: END check_charge_schedule_id_fk;
11152: