eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on HZ_CUST_PROFILE_CLASSES

Line 2731: * discount_grace_days from the hz_cust_profile_classes.

2727: * on charge_on_finance_charge_flag when interest
2728: * charge is 'Y'.
2729: * 16-09-2002 P.Suresh * Bug No : 2441092. Added a condition that the
2730: * discount_terms should be 'Y' when defaulting the
2731: * discount_grace_days from the hz_cust_profile_classes.
2732: * 05-30-2003 Ramesh Ch * Bug No : 2884220. Added a condition that the
2733: * interest_charges should be 'Y' when initializing
2734: * the interest_period_days from the hz_cust_profile_classes.
2735: * 06-23-2003 Ramesh Ch Bug No : 2884220. Added a condition that the dunning_letters,send_statements

Line 2734: * the interest_period_days from the hz_cust_profile_classes.

2730: * discount_terms should be 'Y' when defaulting the
2731: * discount_grace_days from the hz_cust_profile_classes.
2732: * 05-30-2003 Ramesh Ch * Bug No : 2884220. Added a condition that the
2733: * interest_charges should be 'Y' when initializing
2734: * the interest_period_days from the hz_cust_profile_classes.
2735: * 06-23-2003 Ramesh Ch Bug No : 2884220. Added a condition that the dunning_letters,send_statements
2736: * should be 'Y' when initializing the dunning_letter_set_id,statement_cycle_id resp
2737: * from the hz_cust_profile_classes.
2738: *

Line 2737: * from the hz_cust_profile_classes.

2733: * interest_charges should be 'Y' when initializing
2734: * the interest_period_days from the hz_cust_profile_classes.
2735: * 06-23-2003 Ramesh Ch Bug No : 2884220. Added a condition that the dunning_letters,send_statements
2736: * should be 'Y' when initializing the dunning_letter_set_id,statement_cycle_id resp
2737: * from the hz_cust_profile_classes.
2738: *
2739: */
2740:
2741: PROCEDURE validate_customer_profile (

Line 2757: l_class_status HZ_CUST_PROFILE_CLASSES.status%TYPE;

2753: l_collector_id NUMBER;
2754: l_profile_class_id NUMBER;
2755: l_site_use_id NUMBER;
2756: l_cust_acct_site_id NUMBER;
2757: l_class_status HZ_CUST_PROFILE_CLASSES.status%TYPE;
2758: l_profile_class_name HZ_CUST_PROFILE_CLASSES.name%TYPE;
2759: l_created_by_module HZ_CUSTOMER_PROFILES.created_by_module%TYPE;
2760: l_application_id NUMBER;
2761: l_credit_rating HZ_CUSTOMER_PROFILES.credit_rating%TYPE;

Line 2758: l_profile_class_name HZ_CUST_PROFILE_CLASSES.name%TYPE;

2754: l_profile_class_id NUMBER;
2755: l_site_use_id NUMBER;
2756: l_cust_acct_site_id NUMBER;
2757: l_class_status HZ_CUST_PROFILE_CLASSES.status%TYPE;
2758: l_profile_class_name HZ_CUST_PROFILE_CLASSES.name%TYPE;
2759: l_created_by_module HZ_CUSTOMER_PROFILES.created_by_module%TYPE;
2760: l_application_id NUMBER;
2761: l_credit_rating HZ_CUSTOMER_PROFILES.credit_rating%TYPE;
2762: l_risk_code HZ_CUSTOMER_PROFILES.risk_code%TYPE;

Line 2764: l_profile_class_rec HZ_CUST_PROFILE_CLASSES%ROWTYPE;

2760: l_application_id NUMBER;
2761: l_credit_rating HZ_CUSTOMER_PROFILES.credit_rating%TYPE;
2762: l_risk_code HZ_CUSTOMER_PROFILES.risk_code%TYPE;
2763: l_status HZ_CUSTOMER_PROFILES.status%TYPE;
2764: l_profile_class_rec HZ_CUST_PROFILE_CLASSES%ROWTYPE;
2765: v_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE
2766: := p_customer_profile_rec;
2767: l_discount_terms HZ_CUSTOMER_PROFILES.discount_terms%TYPE;
2768: l_discount_grace_days HZ_CUSTOMER_PROFILES.discount_grace_days%TYPE;

Line 3332: -- profile_class_id is foreign key to hz_cust_profile_classes

3328: ----------------------------------------------
3329: -- validate profile_class_id
3330: ----------------------------------------------
3331:
3332: -- profile_class_id is foreign key to hz_cust_profile_classes
3333: IF p_customer_profile_rec.profile_class_id IS NOT NULL AND
3334: p_customer_profile_rec.profile_class_id <> FND_API.G_MISS_NUM
3335: THEN
3336: IF p_customer_profile_rec.profile_class_id < 0 THEN

Line 3343: FROM HZ_CUST_PROFILE_CLASSES

3339: x_return_status := FND_API.G_RET_STS_ERROR;
3340: ELSE
3341: BEGIN
3342: SELECT STATUS, NAME INTO l_class_status, l_profile_class_name
3343: FROM HZ_CUST_PROFILE_CLASSES
3344: WHERE PROFILE_CLASS_ID = p_customer_profile_rec.profile_class_id;
3345:
3346: IF l_class_status <> 'A' THEN
3347: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INACTIVE_PROFILE_CLASS' );

Line 3357: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_profile_classes');

3353: WHEN NO_DATA_FOUND THEN
3354: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
3355: FND_MESSAGE.SET_TOKEN( 'FK', 'profile_class_id' );
3356: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'profile_class_id' );
3357: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_profile_classes');
3358: FND_MSG_PUB.ADD;
3359: x_return_status := FND_API.G_RET_STS_ERROR;
3360: END;
3361: END IF;

Line 3364: hz_utility_v2pub.debug(p_message=>'profile_class_id should be positive, foreign key of hz_cust_profile_classes and point to an active profile class. ' ||

3360: END;
3361: END IF;
3362:
3363: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3364: hz_utility_v2pub.debug(p_message=>'profile_class_id should be positive, foreign key of hz_cust_profile_classes and point to an active profile class. ' ||
3365: 'x_return_status = ' || x_return_status,
3366: p_prefix =>l_debug_prefix,
3367: p_msg_level=>fnd_log.level_statement);
3368: END IF;

Line 4123: FROM HZ_CUST_PROFILE_CLASSES

4119: p_customer_profile_rec.profile_class_id <> FND_API.G_MISS_NUM
4120: THEN
4121:
4122: SELECT * INTO l_profile_class_rec
4123: FROM HZ_CUST_PROFILE_CLASSES
4124: WHERE PROFILE_CLASS_ID = p_customer_profile_rec.profile_class_id;
4125:
4126: END IF;
4127:

Line 4774: when initializing dunning_letter_set_id from hz_cust_profile_classes.

4770: v_customer_profile_rec.dunning_letters :=
4771: l_profile_class_rec.dunning_letters;
4772: END IF;
4773: /* Bug Fix:2884220 Added "v_customer_profile_rec.dunning_letters='Y'" Condition
4774: when initializing dunning_letter_set_id from hz_cust_profile_classes.
4775: */
4776: /*Bug 5095478 the column dunning_letter_set_id is obsolete in R12
4777: IF v_customer_profile_rec.dunning_letters='Y' and
4778: v_customer_profile_rec.dunning_letter_set_id IS NULL THEN

Line 4865: when initializing statement_cycle_id from hz_cust_profile_classes.

4861: v_customer_profile_rec.send_statements :=
4862: l_profile_class_rec.statements;
4863: END IF;
4864: /* Bug Fix:2884220 Added "v_customer_profile_rec.send_statements='Y'" Condition
4865: when initializing statement_cycle_id from hz_cust_profile_classes.
4866: */
4867: IF v_customer_profile_rec.send_statements='Y' and
4868: v_customer_profile_rec.statement_cycle_id IS NULL THEN
4869: v_customer_profile_rec.statement_cycle_id :=

Line 5004: when initializing interest_period_days from hz_cust_profile_classes.

5000: v_customer_profile_rec.interest_charges :=
5001: l_profile_class_rec.interest_charges;
5002: END IF;
5003: /* Bug Fix:2884220 Added "v_customer_profile_rec.interest_charges='Y'" Condition
5004: when initializing interest_period_days from hz_cust_profile_classes.
5005: */
5006: IF v_customer_profile_rec.interest_charges='Y' and
5007: v_customer_profile_rec.interest_period_days IS NULL THEN
5008: v_customer_profile_rec.interest_period_days :=

Line 12565: l_profile_class_rec HZ_CUST_PROFILE_CLASSES%ROWTYPE;

12561: p_customer_profile_rec IN HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
12562: x_return_status IN OUT NOCOPY VARCHAR2
12563: ) IS
12564:
12565: l_profile_class_rec HZ_CUST_PROFILE_CLASSES%ROWTYPE;
12566: l_error BOOLEAN := FALSE;
12567:
12568: l_bill_level_count number;
12569: l_bill_type_count number;