APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on AR_CHARGE_SCHEDULES

Line 6511: -- Validated against ar_charge_schedules.schedule_id.

6507: -- Must be null if interest_type <> FIXED_RATE OR interest_type is null
6508: -- interest_fixed_amount is populated and mandatory only if interest_type = FIXED_AMOUNT.
6509: -- Must be null if interest_type <> FIXED_AMOUNT OR interest_type is null
6510: -- interest_schedule_id is populated and mandatory if only if interest_type is CHARGES_SCHEDULE or CHARGE_PER_TIER.
6511: -- Validated against ar_charge_schedules.schedule_id.
6512:
6513: IF p_create_update_flag = 'U' THEN
6514: IF p_cust_profile_amt_rec.interest_type is NULL THEN
6515: v_cust_profile_amt_rec.interest_type := l_interest_type;

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

6588: p_column_value => v_cust_profile_amt_rec.interest_schedule_id,
6589: x_return_status => x_return_status );
6590:
6591: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6592: hz_utility_v2pub.debug(p_message=>'interest_schedule_id should be a valid value defined in ar_charge_schedules' ||'x_return_status = ' ||
6593: x_return_status,
6594: p_prefix =>l_debug_prefix,
6595: p_msg_level=>fnd_log.level_statement);
6596: END IF;

Line 6623: -- Validated against ar_charge_schedules.schedule_id.

6619: -- Must be null if penalty_type <> FIXED_RATE OR penalty_type is null
6620: -- penalty_fixed_amount is populated and mandatory only if penalty_type = FIXED_AMOUNT.
6621: -- Must be null if penalty_type <> FIXED_AMOUNT OR penalty_type is null
6622: -- penalty_schedule_id is populated and mandatory if only if penalty_type in CHARGES_SCHEDULE or CHARGE_PER_TIER.
6623: -- Validated against ar_charge_schedules.schedule_id.
6624:
6625: IF p_create_update_flag = 'U' THEN
6626: IF p_cust_profile_amt_rec.penalty_type is NULL THEN
6627: v_cust_profile_amt_rec.penalty_type := l_penalty_type;

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

6700: p_column_value => v_cust_profile_amt_rec.penalty_schedule_id,
6701: x_return_status => x_return_status );
6702:
6703: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6704: hz_utility_v2pub.debug(p_message=>'penalty_schedule_id should be a valid value defined in ar_charge_schedules' ||'x_return_status = ' ||
6705: x_return_status,
6706: p_prefix =>l_debug_prefix,
6707: p_msg_level=>fnd_log.level_statement);
6708: END IF;

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

11424: l_dummy VARCHAR2(1);
11425: BEGIN
11426:
11427: -- Validate that the schedule_id passed should be a valid
11428: -- value in ar_charge_schedules. bug # 5065436
11429: SELECT 'Y'
11430: into l_dummy
11431: from ar_charge_schedules
11432: where schedule_id = p_column_value;

Line 11431: from ar_charge_schedules

11427: -- Validate that the schedule_id passed should be a valid
11428: -- value in ar_charge_schedules. bug # 5065436
11429: SELECT 'Y'
11430: into l_dummy
11431: from ar_charge_schedules
11432: where schedule_id = p_column_value;
11433:
11434: EXCEPTION
11435: WHEN NO_DATA_FOUND THEN

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

11435: WHEN NO_DATA_FOUND THEN
11436: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11437: FND_MESSAGE.SET_TOKEN( 'FK', 'schedule_id' );
11438: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11439: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_charge_schedules' );
11440: FND_MSG_PUB.ADD;
11441: x_return_status := FND_API.G_RET_STS_ERROR;
11442: END check_charge_schedule_id_fk;
11443: