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 505: -- if standard terms is NULL, get it defaulted from profile class

501: end if;
502: end if;
503: end if;
504:
505: -- if standard terms is NULL, get it defaulted from profile class
506: if p_customer_profile_rec.standard_terms is NULL then
507: p_customer_profile_rec.standard_terms := l_profile_class_rec.standard_terms;
508: end if;
509:

Line 506: if p_customer_profile_rec.standard_terms is NULL then

502: end if;
503: end if;
504:
505: -- if standard terms is NULL, get it defaulted from profile class
506: if p_customer_profile_rec.standard_terms is NULL then
507: p_customer_profile_rec.standard_terms := l_profile_class_rec.standard_terms;
508: end if;
509:
510: -- if late charge payment term or late charge type or message_text_id is NULL, get it defaulted from profile class

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

503: end if;
504:
505: -- if standard terms is NULL, get it defaulted from profile class
506: if p_customer_profile_rec.standard_terms is NULL then
507: p_customer_profile_rec.standard_terms := l_profile_class_rec.standard_terms;
508: end if;
509:
510: -- if late charge payment term or late charge type or message_text_id is NULL, get it defaulted from profile class
511: if p_customer_profile_rec.late_charge_term_id is NULL then

Line 640: X_STANDARD_TERMS => p_customer_profile_rec.standard_terms,

636: X_PROFILE_CLASS_ID => p_customer_profile_rec.profile_class_id,
637: X_SITE_USE_ID => p_customer_profile_rec.site_use_id,
638: X_CREDIT_RATING => p_customer_profile_rec.credit_rating,
639: X_RISK_CODE => p_customer_profile_rec.risk_code,
640: X_STANDARD_TERMS => p_customer_profile_rec.standard_terms,
641: X_OVERRIDE_TERMS => p_customer_profile_rec.override_terms,
642: X_DUNNING_LETTER_SET_ID => p_customer_profile_rec.dunning_letter_set_id,
643: X_INTEREST_PERIOD_DAYS => p_customer_profile_rec.interest_period_days,
644: X_PAYMENT_GRACE_DAYS => p_customer_profile_rec.payment_grace_days,

Line 998: l_standard_terms NUMBER;

994: l_late_charge_type HZ_CUSTOMER_PROFILES.LATE_CHARGE_TYPE%TYPE;
995: l_late_charge_term_id HZ_CUSTOMER_PROFILES.LATE_CHARGE_TERM_ID%TYPE;
996: l_message_text_id HZ_CUSTOMER_PROFILES.MESSAGE_TEXT_ID%TYPE;
997: l_profile_class_rec HZ_CUST_PROFILE_CLASSES%ROWTYPE;
998: l_standard_terms NUMBER;
999: l_profile_class_changed VARCHAR2(10);
1000:
1001: cursor c_acct_use_profile_dtls IS
1002: select cons_bill_level, cons_inv_type

Line 1025: LATE_CHARGE_TYPE, LATE_CHARGE_TERM_ID, MESSAGE_TEXT_ID, STANDARD_TERMS

1021: BEGIN
1022: SELECT ROWID, OBJECT_VERSION_NUMBER, CUST_ACCOUNT_ID, SITE_USE_ID,
1023: CREATED_BY_MODULE, APPLICATION_ID,PROFILE_CLASS_ID, PARTY_ID,
1024: CREDIT_HOLD , CONS_INV_FLAG, CONS_INV_TYPE, CONS_BILL_LEVEL,
1025: LATE_CHARGE_TYPE, LATE_CHARGE_TERM_ID, MESSAGE_TEXT_ID, STANDARD_TERMS
1026: INTO l_rowid, l_object_version_number, l_cust_account_id, l_site_use_id,
1027: l_created_by_module, l_application_id,l_profile_class_id, l_party_id,
1028: l_credit_hold, l_cons_inv_flag, l_cons_inv_type, l_cons_bill_level,
1029: l_late_charge_type, l_late_charge_term_id, l_message_text_id, l_standard_terms

Line 1029: l_late_charge_type, l_late_charge_term_id, l_message_text_id, l_standard_terms

1025: LATE_CHARGE_TYPE, LATE_CHARGE_TERM_ID, MESSAGE_TEXT_ID, STANDARD_TERMS
1026: INTO l_rowid, l_object_version_number, l_cust_account_id, l_site_use_id,
1027: l_created_by_module, l_application_id,l_profile_class_id, l_party_id,
1028: l_credit_hold, l_cons_inv_flag, l_cons_inv_type, l_cons_bill_level,
1029: l_late_charge_type, l_late_charge_term_id, l_message_text_id, l_standard_terms
1030: FROM HZ_CUSTOMER_PROFILES
1031: WHERE CUST_ACCOUNT_PROFILE_ID = p_customer_profile_rec.cust_account_profile_id
1032: FOR UPDATE NOWAIT;
1033:

Line 1086: if ( p_customer_profile_rec.standard_terms is NULL OR

1082: if ( p_customer_profile_rec.cons_inv_type is NULL OR
1083: p_customer_profile_rec.cons_inv_type = FND_API.G_MISS_CHAR) then
1084: p_customer_profile_rec.cons_inv_type := l_profile_class_rec.cons_inv_type;
1085: end if;
1086: if ( p_customer_profile_rec.standard_terms is NULL OR
1087: p_customer_profile_rec.standard_terms = FND_API.G_MISS_NUM) then
1088: p_customer_profile_rec.standard_terms := l_profile_class_rec.standard_terms;
1089: end if;
1090: END IF;

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

1083: p_customer_profile_rec.cons_inv_type = FND_API.G_MISS_CHAR) then
1084: p_customer_profile_rec.cons_inv_type := l_profile_class_rec.cons_inv_type;
1085: end if;
1086: if ( p_customer_profile_rec.standard_terms is NULL OR
1087: p_customer_profile_rec.standard_terms = FND_API.G_MISS_NUM) then
1088: p_customer_profile_rec.standard_terms := l_profile_class_rec.standard_terms;
1089: end if;
1090: END IF;
1091:

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

1084: p_customer_profile_rec.cons_inv_type := l_profile_class_rec.cons_inv_type;
1085: end if;
1086: if ( p_customer_profile_rec.standard_terms is NULL OR
1087: p_customer_profile_rec.standard_terms = FND_API.G_MISS_NUM) then
1088: p_customer_profile_rec.standard_terms := l_profile_class_rec.standard_terms;
1089: end if;
1090: END IF;
1091:
1092: -- Value for cons_inv_flag should be Y or N

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

1147:
1148: -- Added the below IF condition for Balance Forwarded Billing
1149: -- When cons_inv_flag is changed from 'N' to 'Y' or 'Y' to 'N'
1150: -- and profile class is not changed
1151: -- update the standard_terms of the profile to null
1152: if p_customer_profile_rec.cons_inv_flag IS NOT NULL AND
1153: p_customer_profile_rec.cons_inv_flag <> FND_API.G_MISS_CHAR AND
1154: p_customer_profile_rec.cons_inv_flag <> NVL(l_cons_inv_flag, FND_API.G_MISS_CHAR) AND
1155: l_profile_class_changed = 'N' then

Line 1156: if (p_customer_profile_rec.standard_terms is NULL OR

1152: if p_customer_profile_rec.cons_inv_flag IS NOT NULL AND
1153: p_customer_profile_rec.cons_inv_flag <> FND_API.G_MISS_CHAR AND
1154: p_customer_profile_rec.cons_inv_flag <> NVL(l_cons_inv_flag, FND_API.G_MISS_CHAR) AND
1155: l_profile_class_changed = 'N' then
1156: if (p_customer_profile_rec.standard_terms is NULL OR
1157: p_customer_profile_rec.standard_terms = nvl(l_standard_terms,-999111))
1158: then
1159: --l_standard_terms
1160: p_customer_profile_rec.standard_terms := FND_API.G_MISS_NUM;

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

1153: p_customer_profile_rec.cons_inv_flag <> FND_API.G_MISS_CHAR AND
1154: p_customer_profile_rec.cons_inv_flag <> NVL(l_cons_inv_flag, FND_API.G_MISS_CHAR) AND
1155: l_profile_class_changed = 'N' then
1156: if (p_customer_profile_rec.standard_terms is NULL OR
1157: p_customer_profile_rec.standard_terms = nvl(l_standard_terms,-999111))
1158: then
1159: --l_standard_terms
1160: p_customer_profile_rec.standard_terms := FND_API.G_MISS_NUM;
1161: end if;

Line 1159: --l_standard_terms

1155: l_profile_class_changed = 'N' then
1156: if (p_customer_profile_rec.standard_terms is NULL OR
1157: p_customer_profile_rec.standard_terms = nvl(l_standard_terms,-999111))
1158: then
1159: --l_standard_terms
1160: p_customer_profile_rec.standard_terms := FND_API.G_MISS_NUM;
1161: end if;
1162: end if;
1163:

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

1156: if (p_customer_profile_rec.standard_terms is NULL OR
1157: p_customer_profile_rec.standard_terms = nvl(l_standard_terms,-999111))
1158: then
1159: --l_standard_terms
1160: p_customer_profile_rec.standard_terms := FND_API.G_MISS_NUM;
1161: end if;
1162: end if;
1163:
1164: -- if late charge payment term or late charge type or message_text_id is NULL, get value from database.

Line 1307: X_STANDARD_TERMS => p_customer_profile_rec.standard_terms,

1303: X_PROFILE_CLASS_ID => p_customer_profile_rec.profile_class_id,
1304: X_SITE_USE_ID => p_customer_profile_rec.site_use_id,
1305: X_CREDIT_RATING => p_customer_profile_rec.credit_rating,
1306: X_RISK_CODE => p_customer_profile_rec.risk_code,
1307: X_STANDARD_TERMS => p_customer_profile_rec.standard_terms,
1308: X_OVERRIDE_TERMS => p_customer_profile_rec.override_terms,
1309: X_DUNNING_LETTER_SET_ID => p_customer_profile_rec.dunning_letter_set_id,
1310: X_INTEREST_PERIOD_DAYS => p_customer_profile_rec.interest_period_days,
1311: X_PAYMENT_GRACE_DAYS => p_customer_profile_rec.payment_grace_days,

Line 2237: -- Standard start of API savepoint

2233: l_debug_prefix VARCHAR2(30) := '';
2234:
2235: BEGIN
2236:
2237: -- Standard start of API savepoint
2238: SAVEPOINT create_customer_profile;
2239:
2240: -- Check if API is called in debug mode. If yes, enable debug.
2241: --enable_debug;

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

2276: p_cust_account_profile_id => x_cust_account_profile_id);
2277: END IF;
2278: END IF;
2279:
2280: -- Standard call to get message count and if count is 1, get message info.
2281: FND_MSG_PUB.Count_And_Get(
2282: p_encoded => FND_API.G_FALSE,
2283: p_count => x_msg_count,
2284: p_data => x_msg_data );

Line 2430: -- Standard start of API savepoint

2426: l_debug_prefix VARCHAR2(30) := '';
2427:
2428: BEGIN
2429:
2430: -- Standard start of API savepoint
2431: SAVEPOINT update_customer_profile;
2432:
2433: -- Check if API is called in debug mode. If yes, enable debug.
2434: --enable_debug;

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

2481: p_cust_account_profile_id => l_customer_profile_rec.cust_account_profile_id);
2482: END IF;
2483: END IF;
2484:
2485: -- Standard call to get message count and if count is 1, get message info.
2486: FND_MSG_PUB.Count_And_Get(
2487: p_encoded => FND_API.G_FALSE,
2488: p_count => x_msg_count,
2489: p_data => x_msg_data );

Line 2684: X_STANDARD_TERMS => x_customer_profile_rec.standard_terms,

2680: X_PROFILE_CLASS_ID => x_customer_profile_rec.profile_class_id,
2681: X_SITE_USE_ID => x_customer_profile_rec.site_use_id,
2682: X_CREDIT_RATING => x_customer_profile_rec.credit_rating,
2683: X_RISK_CODE => x_customer_profile_rec.risk_code,
2684: X_STANDARD_TERMS => x_customer_profile_rec.standard_terms,
2685: X_OVERRIDE_TERMS => x_customer_profile_rec.override_terms,
2686: X_DUNNING_LETTER_SET_ID => x_customer_profile_rec.dunning_letter_set_id,
2687: X_INTEREST_PERIOD_DAYS => x_customer_profile_rec.interest_period_days,
2688: X_PAYMENT_GRACE_DAYS => x_customer_profile_rec.payment_grace_days,

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

2780: p_prefix=>l_debug_prefix,
2781: p_msg_level=>fnd_log.level_procedure);
2782: END IF;
2783:
2784: -- Standard call to get message count and if count is 1, get message info.
2785: FND_MSG_PUB.Count_And_Get(
2786: p_encoded => FND_API.G_FALSE,
2787: p_count => x_msg_count,
2788: p_data => x_msg_data );

Line 2937: -- Standard start of API savepoint

2933: l_debug_prefix VARCHAR2(30) := '';
2934:
2935: BEGIN
2936:
2937: -- Standard start of API savepoint
2938: SAVEPOINT create_cust_profile_amt;
2939:
2940: -- Check if API is called in debug mode. If yes, enable debug.
2941: --enable_debug;

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

2975: p_cust_acct_profile_amt_id => x_cust_acct_profile_amt_id);
2976: END IF;
2977: END IF;
2978:
2979: -- Standard call to get message count and if count is 1, get message info.
2980: FND_MSG_PUB.Count_And_Get(
2981: p_encoded => FND_API.G_FALSE,
2982: p_count => x_msg_count,
2983: p_data => x_msg_data );

Line 3131: -- Standard start of API savepoint

3127: l_debug_prefix VARCHAR2(30) := '';
3128:
3129: BEGIN
3130:
3131: -- Standard start of API savepoint
3132: SAVEPOINT update_cust_profile_amt;
3133:
3134: -- Check if API is called in debug mode. If yes, enable debug.
3135: --enable_debug;

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

3182: p_cust_acct_profile_amt_id => l_cust_profile_amt_rec.cust_acct_profile_amt_id);
3183: END IF;
3184: END IF;
3185:
3186: -- Standard call to get message count and if count is 1, get message info.
3187: FND_MSG_PUB.Count_And_Get(
3188: p_encoded => FND_API.G_FALSE,
3189: p_count => x_msg_count,
3190: p_data => x_msg_data );

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

3461: p_prefix=>l_debug_prefix,
3462: p_msg_level=>fnd_log.level_procedure);
3463: END IF;
3464:
3465: -- Standard call to get message count and if count is 1, get message info.
3466: FND_MSG_PUB.Count_And_Get(
3467: p_encoded => FND_API.G_FALSE,
3468: p_count => x_msg_count,
3469: p_data => x_msg_data );