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 2757: * discount_grace_days from the hz_cust_profile_classes.

2753: * on charge_on_finance_charge_flag when interest
2754: * charge is 'Y'.
2755: * 16-09-2002 P.Suresh * Bug No : 2441092. Added a condition that the
2756: * discount_terms should be 'Y' when defaulting the
2757: * discount_grace_days from the hz_cust_profile_classes.
2758: * 05-30-2003 Ramesh Ch * Bug No : 2884220. Added a condition that the
2759: * interest_charges should be 'Y' when initializing
2760: * the interest_period_days from the hz_cust_profile_classes.
2761: * 06-23-2003 Ramesh Ch Bug No : 2884220. Added a condition that the dunning_letters,send_statements

Line 2760: * the interest_period_days from the hz_cust_profile_classes.

2756: * discount_terms should be 'Y' when defaulting the
2757: * discount_grace_days from the hz_cust_profile_classes.
2758: * 05-30-2003 Ramesh Ch * Bug No : 2884220. Added a condition that the
2759: * interest_charges should be 'Y' when initializing
2760: * the interest_period_days from the hz_cust_profile_classes.
2761: * 06-23-2003 Ramesh Ch Bug No : 2884220. Added a condition that the dunning_letters,send_statements
2762: * should be 'Y' when initializing the dunning_letter_set_id,statement_cycle_id resp
2763: * from the hz_cust_profile_classes.
2764: *

Line 2763: * from the hz_cust_profile_classes.

2759: * interest_charges should be 'Y' when initializing
2760: * the interest_period_days from the hz_cust_profile_classes.
2761: * 06-23-2003 Ramesh Ch Bug No : 2884220. Added a condition that the dunning_letters,send_statements
2762: * should be 'Y' when initializing the dunning_letter_set_id,statement_cycle_id resp
2763: * from the hz_cust_profile_classes.
2764: *
2765: */
2766:
2767: PROCEDURE validate_customer_profile (

Line 2783: l_class_status HZ_CUST_PROFILE_CLASSES.status%TYPE;

2779: l_collector_id NUMBER;
2780: l_profile_class_id NUMBER;
2781: l_site_use_id NUMBER;
2782: l_cust_acct_site_id NUMBER;
2783: l_class_status HZ_CUST_PROFILE_CLASSES.status%TYPE;
2784: l_profile_class_name HZ_CUST_PROFILE_CLASSES.name%TYPE;
2785: l_created_by_module HZ_CUSTOMER_PROFILES.created_by_module%TYPE;
2786: l_application_id NUMBER;
2787: l_credit_rating HZ_CUSTOMER_PROFILES.credit_rating%TYPE;

Line 2784: l_profile_class_name HZ_CUST_PROFILE_CLASSES.name%TYPE;

2780: l_profile_class_id NUMBER;
2781: l_site_use_id NUMBER;
2782: l_cust_acct_site_id NUMBER;
2783: l_class_status HZ_CUST_PROFILE_CLASSES.status%TYPE;
2784: l_profile_class_name HZ_CUST_PROFILE_CLASSES.name%TYPE;
2785: l_created_by_module HZ_CUSTOMER_PROFILES.created_by_module%TYPE;
2786: l_application_id NUMBER;
2787: l_credit_rating HZ_CUSTOMER_PROFILES.credit_rating%TYPE;
2788: l_risk_code HZ_CUSTOMER_PROFILES.risk_code%TYPE;

Line 2790: l_profile_class_rec HZ_CUST_PROFILE_CLASSES%ROWTYPE;

2786: l_application_id NUMBER;
2787: l_credit_rating HZ_CUSTOMER_PROFILES.credit_rating%TYPE;
2788: l_risk_code HZ_CUSTOMER_PROFILES.risk_code%TYPE;
2789: l_status HZ_CUSTOMER_PROFILES.status%TYPE;
2790: l_profile_class_rec HZ_CUST_PROFILE_CLASSES%ROWTYPE;
2791: v_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE
2792: := p_customer_profile_rec;
2793: l_discount_terms HZ_CUSTOMER_PROFILES.discount_terms%TYPE;
2794: l_discount_grace_days HZ_CUSTOMER_PROFILES.discount_grace_days%TYPE;

Line 3359: -- profile_class_id is foreign key to hz_cust_profile_classes

3355: ----------------------------------------------
3356: -- validate profile_class_id
3357: ----------------------------------------------
3358:
3359: -- profile_class_id is foreign key to hz_cust_profile_classes
3360: IF p_customer_profile_rec.profile_class_id IS NOT NULL AND
3361: p_customer_profile_rec.profile_class_id <> FND_API.G_MISS_NUM
3362: THEN
3363: IF p_customer_profile_rec.profile_class_id < 0 THEN

Line 3370: FROM HZ_CUST_PROFILE_CLASSES

3366: x_return_status := FND_API.G_RET_STS_ERROR;
3367: ELSE
3368: BEGIN
3369: SELECT STATUS, NAME INTO l_class_status, l_profile_class_name
3370: FROM HZ_CUST_PROFILE_CLASSES
3371: WHERE PROFILE_CLASS_ID = p_customer_profile_rec.profile_class_id;
3372:
3373: IF l_class_status <> 'A' THEN
3374: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INACTIVE_PROFILE_CLASS' );

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

3380: WHEN NO_DATA_FOUND THEN
3381: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
3382: FND_MESSAGE.SET_TOKEN( 'FK', 'profile_class_id' );
3383: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'profile_class_id' );
3384: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_profile_classes');
3385: FND_MSG_PUB.ADD;
3386: x_return_status := FND_API.G_RET_STS_ERROR;
3387: END;
3388: END IF;

Line 3391: 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. ' ||

3387: END;
3388: END IF;
3389:
3390: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3391: 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. ' ||
3392: 'x_return_status = ' || x_return_status,
3393: p_prefix =>l_debug_prefix,
3394: p_msg_level=>fnd_log.level_statement);
3395: END IF;

Line 4150: FROM HZ_CUST_PROFILE_CLASSES

4146: p_customer_profile_rec.profile_class_id <> FND_API.G_MISS_NUM
4147: THEN
4148:
4149: SELECT * INTO l_profile_class_rec
4150: FROM HZ_CUST_PROFILE_CLASSES
4151: WHERE PROFILE_CLASS_ID = p_customer_profile_rec.profile_class_id;
4152:
4153: END IF;
4154:

Line 4831: when initializing dunning_letter_set_id from hz_cust_profile_classes.

4827: v_customer_profile_rec.dunning_letters :=
4828: l_profile_class_rec.dunning_letters;
4829: END IF;
4830: /* Bug Fix:2884220 Added "v_customer_profile_rec.dunning_letters='Y'" Condition
4831: when initializing dunning_letter_set_id from hz_cust_profile_classes.
4832: */
4833: /*Bug 5095478 the column dunning_letter_set_id is obsolete in R12
4834: IF v_customer_profile_rec.dunning_letters='Y' and
4835: v_customer_profile_rec.dunning_letter_set_id IS NULL THEN

Line 4922: when initializing statement_cycle_id from hz_cust_profile_classes.

4918: v_customer_profile_rec.send_statements :=
4919: l_profile_class_rec.statements;
4920: END IF;
4921: /* Bug Fix:2884220 Added "v_customer_profile_rec.send_statements='Y'" Condition
4922: when initializing statement_cycle_id from hz_cust_profile_classes.
4923: */
4924: IF v_customer_profile_rec.send_statements='Y' and
4925: v_customer_profile_rec.statement_cycle_id IS NULL THEN
4926: v_customer_profile_rec.statement_cycle_id :=

Line 5061: when initializing interest_period_days from hz_cust_profile_classes.

5057: v_customer_profile_rec.interest_charges :=
5058: l_profile_class_rec.interest_charges;
5059: END IF;
5060: /* Bug Fix:2884220 Added "v_customer_profile_rec.interest_charges='Y'" Condition
5061: when initializing interest_period_days from hz_cust_profile_classes.
5062: */
5063: IF v_customer_profile_rec.interest_charges='Y' and
5064: v_customer_profile_rec.interest_period_days IS NULL THEN
5065: v_customer_profile_rec.interest_period_days :=

Line 12905: l_profile_class_rec HZ_CUST_PROFILE_CLASSES%ROWTYPE;

12901: p_customer_profile_rec IN HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
12902: x_return_status IN OUT NOCOPY VARCHAR2
12903: ) IS
12904:
12905: l_profile_class_rec HZ_CUST_PROFILE_CLASSES%ROWTYPE;
12906: l_error BOOLEAN := FALSE;
12907:
12908: l_bill_level_count number;
12909: l_bill_type_count number;