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_CUSTOMER_PROFILE_V2PUB dependencies on STANDARD

Line 516: -- if standard terms is NULL, get it defaulted from profile class

512: end if;
513: end if;
514: end if;
515:
516: -- if standard terms is NULL, get it defaulted from profile class
517: if p_customer_profile_rec.standard_terms is NULL then
518: p_customer_profile_rec.standard_terms := l_profile_class_rec.standard_terms;
519: end if;
520:

Line 517: if p_customer_profile_rec.standard_terms is NULL then

513: end if;
514: end if;
515:
516: -- if standard terms is NULL, get it defaulted from profile class
517: if p_customer_profile_rec.standard_terms is NULL then
518: p_customer_profile_rec.standard_terms := l_profile_class_rec.standard_terms;
519: end if;
520:
521: -- if late charge payment term or late charge type or message_text_id is NULL, get it defaulted from profile class

Line 518: p_customer_profile_rec.standard_terms := l_profile_class_rec.standard_terms;

514: end if;
515:
516: -- if standard terms is NULL, get it defaulted from profile class
517: if p_customer_profile_rec.standard_terms is NULL then
518: p_customer_profile_rec.standard_terms := l_profile_class_rec.standard_terms;
519: end if;
520:
521: -- if late charge payment term or late charge type or message_text_id is NULL, get it defaulted from profile class
522: if p_customer_profile_rec.late_charge_term_id is NULL then

Line 670: X_STANDARD_TERMS => p_customer_profile_rec.standard_terms,

666: X_PROFILE_CLASS_ID => p_customer_profile_rec.profile_class_id,
667: X_SITE_USE_ID => p_customer_profile_rec.site_use_id,
668: X_CREDIT_RATING => p_customer_profile_rec.credit_rating,
669: X_RISK_CODE => p_customer_profile_rec.risk_code,
670: X_STANDARD_TERMS => p_customer_profile_rec.standard_terms,
671: X_OVERRIDE_TERMS => p_customer_profile_rec.override_terms,
672: X_DUNNING_LETTER_SET_ID => p_customer_profile_rec.dunning_letter_set_id,
673: X_INTEREST_PERIOD_DAYS => p_customer_profile_rec.interest_period_days,
674: X_PAYMENT_GRACE_DAYS => p_customer_profile_rec.payment_grace_days,

Line 1029: l_standard_terms NUMBER;

1025: l_late_charge_type HZ_CUSTOMER_PROFILES.LATE_CHARGE_TYPE%TYPE;
1026: l_late_charge_term_id HZ_CUSTOMER_PROFILES.LATE_CHARGE_TERM_ID%TYPE;
1027: l_message_text_id HZ_CUSTOMER_PROFILES.MESSAGE_TEXT_ID%TYPE;
1028: l_profile_class_rec HZ_CUST_PROFILE_CLASSES%ROWTYPE;
1029: l_standard_terms NUMBER;
1030: l_automatch_set_id NUMBER;
1031: l_profile_class_changed VARCHAR2(10);
1032:
1033: cursor c_acct_use_profile_dtls IS

Line 1057: LATE_CHARGE_TYPE, LATE_CHARGE_TERM_ID, MESSAGE_TEXT_ID, STANDARD_TERMS,

1053: BEGIN
1054: SELECT ROWID, OBJECT_VERSION_NUMBER, CUST_ACCOUNT_ID, SITE_USE_ID,
1055: CREATED_BY_MODULE, APPLICATION_ID,PROFILE_CLASS_ID, PARTY_ID,
1056: CREDIT_HOLD , CONS_INV_FLAG, CONS_INV_TYPE, CONS_BILL_LEVEL,
1057: LATE_CHARGE_TYPE, LATE_CHARGE_TERM_ID, MESSAGE_TEXT_ID, STANDARD_TERMS,
1058: AUTOMATCH_SET_ID
1059: INTO l_rowid, l_object_version_number, l_cust_account_id, l_site_use_id,
1060: l_created_by_module, l_application_id,l_profile_class_id, l_party_id,
1061: l_credit_hold, l_cons_inv_flag, l_cons_inv_type, l_cons_bill_level,

Line 1062: l_late_charge_type, l_late_charge_term_id, l_message_text_id, l_standard_terms,

1058: AUTOMATCH_SET_ID
1059: INTO l_rowid, l_object_version_number, l_cust_account_id, l_site_use_id,
1060: l_created_by_module, l_application_id,l_profile_class_id, l_party_id,
1061: l_credit_hold, l_cons_inv_flag, l_cons_inv_type, l_cons_bill_level,
1062: l_late_charge_type, l_late_charge_term_id, l_message_text_id, l_standard_terms,
1063: l_automatch_set_id
1064: FROM HZ_CUSTOMER_PROFILES
1065: WHERE CUST_ACCOUNT_PROFILE_ID = p_customer_profile_rec.cust_account_profile_id
1066: FOR UPDATE NOWAIT;

Line 1121: if ( p_customer_profile_rec.standard_terms is NULL OR

1117: if ( p_customer_profile_rec.cons_inv_type is NULL OR
1118: p_customer_profile_rec.cons_inv_type = FND_API.G_MISS_CHAR) then
1119: p_customer_profile_rec.cons_inv_type := l_profile_class_rec.cons_inv_type;
1120: end if;
1121: if ( p_customer_profile_rec.standard_terms is NULL OR
1122: p_customer_profile_rec.standard_terms = FND_API.G_MISS_NUM) then
1123: p_customer_profile_rec.standard_terms := l_profile_class_rec.standard_terms;
1124: end if;
1125: --Bug9151634,9197547

Line 1122: p_customer_profile_rec.standard_terms = FND_API.G_MISS_NUM) then

1118: p_customer_profile_rec.cons_inv_type = FND_API.G_MISS_CHAR) then
1119: p_customer_profile_rec.cons_inv_type := l_profile_class_rec.cons_inv_type;
1120: end if;
1121: if ( p_customer_profile_rec.standard_terms is NULL OR
1122: p_customer_profile_rec.standard_terms = FND_API.G_MISS_NUM) then
1123: p_customer_profile_rec.standard_terms := l_profile_class_rec.standard_terms;
1124: end if;
1125: --Bug9151634,9197547
1126: --Assigning Profile Class's value.

Line 1123: p_customer_profile_rec.standard_terms := l_profile_class_rec.standard_terms;

1119: p_customer_profile_rec.cons_inv_type := l_profile_class_rec.cons_inv_type;
1120: end if;
1121: if ( p_customer_profile_rec.standard_terms is NULL OR
1122: p_customer_profile_rec.standard_terms = FND_API.G_MISS_NUM) then
1123: p_customer_profile_rec.standard_terms := l_profile_class_rec.standard_terms;
1124: end if;
1125: --Bug9151634,9197547
1126: --Assigning Profile Class's value.
1127: if ( p_customer_profile_rec.review_cycle is NULL OR

Line 1200: -- update the standard_terms of the profile to null

1196:
1197: -- Added the below IF condition for Balance Forwarded Billing
1198: -- When cons_inv_flag is changed from 'N' to 'Y' or 'Y' to 'N'
1199: -- and profile class is not changed
1200: -- update the standard_terms of the profile to null
1201: -- Bug 8349169 -In NVL function G_MISS_CHAR changed to 'N', null will consider as 'N'
1202: if p_customer_profile_rec.cons_inv_flag IS NOT NULL AND
1203: p_customer_profile_rec.cons_inv_flag <> FND_API.G_MISS_CHAR AND
1204: p_customer_profile_rec.cons_inv_flag <> NVL(l_cons_inv_flag, 'N') AND

Line 1206: if (p_customer_profile_rec.standard_terms is NULL OR

1202: if p_customer_profile_rec.cons_inv_flag IS NOT NULL AND
1203: p_customer_profile_rec.cons_inv_flag <> FND_API.G_MISS_CHAR AND
1204: p_customer_profile_rec.cons_inv_flag <> NVL(l_cons_inv_flag, 'N') AND
1205: l_profile_class_changed = 'N' then
1206: if (p_customer_profile_rec.standard_terms is NULL OR
1207: p_customer_profile_rec.standard_terms = nvl(l_standard_terms,-999111))
1208: then
1209: --l_standard_terms
1210: p_customer_profile_rec.standard_terms := FND_API.G_MISS_NUM;

Line 1207: p_customer_profile_rec.standard_terms = nvl(l_standard_terms,-999111))

1203: p_customer_profile_rec.cons_inv_flag <> FND_API.G_MISS_CHAR AND
1204: p_customer_profile_rec.cons_inv_flag <> NVL(l_cons_inv_flag, 'N') AND
1205: l_profile_class_changed = 'N' then
1206: if (p_customer_profile_rec.standard_terms is NULL OR
1207: p_customer_profile_rec.standard_terms = nvl(l_standard_terms,-999111))
1208: then
1209: --l_standard_terms
1210: p_customer_profile_rec.standard_terms := FND_API.G_MISS_NUM;
1211: end if;

Line 1209: --l_standard_terms

1205: l_profile_class_changed = 'N' then
1206: if (p_customer_profile_rec.standard_terms is NULL OR
1207: p_customer_profile_rec.standard_terms = nvl(l_standard_terms,-999111))
1208: then
1209: --l_standard_terms
1210: p_customer_profile_rec.standard_terms := FND_API.G_MISS_NUM;
1211: end if;
1212: end if;
1213:

Line 1210: p_customer_profile_rec.standard_terms := FND_API.G_MISS_NUM;

1206: if (p_customer_profile_rec.standard_terms is NULL OR
1207: p_customer_profile_rec.standard_terms = nvl(l_standard_terms,-999111))
1208: then
1209: --l_standard_terms
1210: p_customer_profile_rec.standard_terms := FND_API.G_MISS_NUM;
1211: end if;
1212: end if;
1213:
1214: -- if late charge payment term or late charge type or message_text_id is NULL, get value from database.

Line 1369: X_STANDARD_TERMS => p_customer_profile_rec.standard_terms,

1365: X_PROFILE_CLASS_ID => p_customer_profile_rec.profile_class_id,
1366: X_SITE_USE_ID => p_customer_profile_rec.site_use_id,
1367: X_CREDIT_RATING => p_customer_profile_rec.credit_rating,
1368: X_RISK_CODE => p_customer_profile_rec.risk_code,
1369: X_STANDARD_TERMS => p_customer_profile_rec.standard_terms,
1370: X_OVERRIDE_TERMS => p_customer_profile_rec.override_terms,
1371: X_DUNNING_LETTER_SET_ID => p_customer_profile_rec.dunning_letter_set_id,
1372: X_INTEREST_PERIOD_DAYS => p_customer_profile_rec.interest_period_days,
1373: X_PAYMENT_GRACE_DAYS => p_customer_profile_rec.payment_grace_days,

Line 2300: -- Standard start of API savepoint

2296: l_debug_prefix VARCHAR2(30) := '';
2297:
2298: BEGIN
2299:
2300: -- Standard start of API savepoint
2301: SAVEPOINT create_customer_profile;
2302:
2303: -- Check if API is called in debug mode. If yes, enable debug.
2304: --enable_debug;

Line 2343: -- Standard call to get message count and if count is 1, get message info.

2339: p_cust_account_profile_id => x_cust_account_profile_id);
2340: END IF;
2341: END IF;
2342:
2343: -- Standard call to get message count and if count is 1, get message info.
2344: FND_MSG_PUB.Count_And_Get(
2345: p_encoded => FND_API.G_FALSE,
2346: p_count => x_msg_count,
2347: p_data => x_msg_data );

Line 2493: -- Standard start of API savepoint

2489: l_debug_prefix VARCHAR2(30) := '';
2490:
2491: BEGIN
2492:
2493: -- Standard start of API savepoint
2494: SAVEPOINT update_customer_profile;
2495:
2496: -- Check if API is called in debug mode. If yes, enable debug.
2497: --enable_debug;

Line 2548: -- Standard call to get message count and if count is 1, get message info.

2544: p_cust_account_profile_id => l_customer_profile_rec.cust_account_profile_id);
2545: END IF;
2546: END IF;
2547:
2548: -- Standard call to get message count and if count is 1, get message info.
2549: FND_MSG_PUB.Count_And_Get(
2550: p_encoded => FND_API.G_FALSE,
2551: p_count => x_msg_count,
2552: p_data => x_msg_data );

Line 2747: X_STANDARD_TERMS => x_customer_profile_rec.standard_terms,

2743: X_PROFILE_CLASS_ID => x_customer_profile_rec.profile_class_id,
2744: X_SITE_USE_ID => x_customer_profile_rec.site_use_id,
2745: X_CREDIT_RATING => x_customer_profile_rec.credit_rating,
2746: X_RISK_CODE => x_customer_profile_rec.risk_code,
2747: X_STANDARD_TERMS => x_customer_profile_rec.standard_terms,
2748: X_OVERRIDE_TERMS => x_customer_profile_rec.override_terms,
2749: X_DUNNING_LETTER_SET_ID => x_customer_profile_rec.dunning_letter_set_id,
2750: X_INTEREST_PERIOD_DAYS => x_customer_profile_rec.interest_period_days,
2751: X_PAYMENT_GRACE_DAYS => x_customer_profile_rec.payment_grace_days,

Line 2848: -- Standard call to get message count and if count is 1, get message info.

2844: p_prefix=>l_debug_prefix,
2845: p_msg_level=>fnd_log.level_procedure);
2846: END IF;
2847:
2848: -- Standard call to get message count and if count is 1, get message info.
2849: FND_MSG_PUB.Count_And_Get(
2850: p_encoded => FND_API.G_FALSE,
2851: p_count => x_msg_count,
2852: p_data => x_msg_data );

Line 3001: -- Standard start of API savepoint

2997: l_debug_prefix VARCHAR2(30) := '';
2998:
2999: BEGIN
3000:
3001: -- Standard start of API savepoint
3002: SAVEPOINT create_cust_profile_amt;
3003:
3004: -- Check if API is called in debug mode. If yes, enable debug.
3005: --enable_debug;

Line 3043: -- Standard call to get message count and if count is 1, get message info.

3039: p_cust_acct_profile_amt_id => x_cust_acct_profile_amt_id);
3040: END IF;
3041: END IF;
3042:
3043: -- Standard call to get message count and if count is 1, get message info.
3044: FND_MSG_PUB.Count_And_Get(
3045: p_encoded => FND_API.G_FALSE,
3046: p_count => x_msg_count,
3047: p_data => x_msg_data );

Line 3195: -- Standard start of API savepoint

3191: l_debug_prefix VARCHAR2(30) := '';
3192:
3193: BEGIN
3194:
3195: -- Standard start of API savepoint
3196: SAVEPOINT update_cust_profile_amt;
3197:
3198: -- Check if API is called in debug mode. If yes, enable debug.
3199: --enable_debug;

Line 3250: -- Standard call to get message count and if count is 1, get message info.

3246: p_cust_acct_profile_amt_id => l_cust_profile_amt_rec.cust_acct_profile_amt_id);
3247: END IF;
3248: END IF;
3249:
3250: -- Standard call to get message count and if count is 1, get message info.
3251: FND_MSG_PUB.Count_And_Get(
3252: p_encoded => FND_API.G_FALSE,
3253: p_count => x_msg_count,
3254: p_data => x_msg_data );

Line 3529: -- Standard call to get message count and if count is 1, get message info.

3525: p_prefix=>l_debug_prefix,
3526: p_msg_level=>fnd_log.level_procedure);
3527: END IF;
3528:
3529: -- Standard call to get message count and if count is 1, get message info.
3530: FND_MSG_PUB.Count_And_Get(
3531: p_encoded => FND_API.G_FALSE,
3532: p_count => x_msg_count,
3533: p_data => x_msg_data );