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 STANDARD

Line 316: PROCEDURE check_standard_terms_fk (

312: p_column_value IN NUMBER,
313: x_return_status IN OUT NOCOPY VARCHAR2
314: );
315:
316: PROCEDURE check_standard_terms_fk (
317: p_column IN VARCHAR2,
318: p_column_value IN NUMBER,
319: p_cons_inv_flag IN VARCHAR2,
320: p_ckeck_acc_bfb_enabled IN VARCHAR2,

Line 2751: * customer standard form and interface.

2747: * MODIFICATION HISTORY
2748: *
2749: * 07-23-2001 Jianying Huang o Created.
2750: * 11-08-2001 P.Suresh * Bug No : 1999532. Added validations as present in
2751: * customer standard form and interface.
2752: * 12-05-2001 P.Suresh * Bug No : 2125994. Commented the mandatory check
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

Line 2807: l_standard_terms HZ_CUSTOMER_PROFILES.STANDARD_TERMS%TYPE;

2803:
2804: l_account_status HZ_CUSTOMER_PROFILES.ACCOUNT_STATUS%TYPE;
2805: l_tolerance HZ_CUSTOMER_PROFILES.TOLERANCE%TYPE;
2806: l_percent_collectable HZ_CUSTOMER_PROFILES.PERCENT_COLLECTABLE%TYPE;
2807: l_standard_terms HZ_CUSTOMER_PROFILES.STANDARD_TERMS%TYPE;
2808: l_override_terms HZ_CUSTOMER_PROFILES.OVERRIDE_TERMS%TYPE;
2809: l_lockbox_matching_option HZ_CUSTOMER_PROFILES.LOCKBOX_MATCHING_OPTION%TYPE;
2810: l_autocash_hierarchy_id HZ_CUSTOMER_PROFILES.AUTOCASH_HIERARCHY_ID%TYPE;
2811: l_autocash_hierarchy_id_for_ad HZ_CUSTOMER_PROFILES.AUTOCASH_HIERARCHY_ID_FOR_ADR%TYPE;

Line 2864: STANDARD_TERMS,OVERRIDE_TERMS,LOCKBOX_MATCHING_OPTION,

2860: DISCOUNT_GRACE_DAYS,DUNNING_LETTERS,DUNNING_LETTER_SET_ID,
2861: SEND_STATEMENTS,STATEMENT_CYCLE_ID,CREDIT_BALANCE_STATEMENTS,
2862: INTEREST_CHARGES,CHARGE_ON_FINANCE_CHARGE_FLAG,
2863: INTEREST_PERIOD_DAYS,ACCOUNT_STATUS,TOLERANCE,PERCENT_COLLECTABLE,
2864: STANDARD_TERMS,OVERRIDE_TERMS,LOCKBOX_MATCHING_OPTION,
2865: AUTOCASH_HIERARCHY_ID,AUTOCASH_HIERARCHY_ID_FOR_ADR,
2866: CLEARING_DAYS,PAYMENT_GRACE_DAYS,GROUPING_RULE_ID,
2867: TAX_PRINTING_OPTION,
2868: REVIEW_CYCLE,LAST_CREDIT_REVIEW_DATE,NEXT_CREDIT_REVIEW_DATE,PARTY_ID,

Line 2879: l_standard_terms,l_override_terms,l_lockbox_matching_option,

2875: l_discount_grace_days,l_dunning_letters,l_dunning_letter_set_id,
2876: l_send_statements,l_statement_cycle_id,l_credit_balance_statements,
2877: l_interest_charges,l_finance_charge_flag,
2878: l_interest_period_days,l_account_status,l_tolerance,l_percent_collectable,
2879: l_standard_terms,l_override_terms,l_lockbox_matching_option,
2880: l_autocash_hierarchy_id,l_autocash_hierarchy_id_for_ad,
2881: l_clearing_days,l_payment_grace_days,l_grouping_rule_id,
2882: l_tax_printing_option,
2883: l_review_cycle,l_last_credit_review_date,l_next_credit_review_date,l_party_id,

Line 4585: ----* Validating standard_terms*---

4581: END IF;
4582:
4583:
4584: ----------------------------------------
4585: ----*** Validating standard_terms***---
4586: ----------------------------------------
4587: IF p_customer_profile_rec.standard_terms IS NOT NULL AND
4588: p_customer_profile_rec.standard_terms <> FND_API.G_MISS_NUM
4589: AND ( p_create_update_flag = 'C' OR

Line 4587: IF p_customer_profile_rec.standard_terms IS NOT NULL AND

4583:
4584: ----------------------------------------
4585: ----*** Validating standard_terms***---
4586: ----------------------------------------
4587: IF p_customer_profile_rec.standard_terms IS NOT NULL AND
4588: p_customer_profile_rec.standard_terms <> FND_API.G_MISS_NUM
4589: AND ( p_create_update_flag = 'C' OR
4590: ( p_create_update_flag = 'U' AND
4591: p_customer_profile_rec.standard_terms <> NVL( l_standard_terms, FND_API.G_MISS_NUM ) ))

Line 4588: p_customer_profile_rec.standard_terms <> FND_API.G_MISS_NUM

4584: ----------------------------------------
4585: ----*** Validating standard_terms***---
4586: ----------------------------------------
4587: IF p_customer_profile_rec.standard_terms IS NOT NULL AND
4588: p_customer_profile_rec.standard_terms <> FND_API.G_MISS_NUM
4589: AND ( p_create_update_flag = 'C' OR
4590: ( p_create_update_flag = 'U' AND
4591: p_customer_profile_rec.standard_terms <> NVL( l_standard_terms, FND_API.G_MISS_NUM ) ))
4592: THEN

Line 4591: p_customer_profile_rec.standard_terms <> NVL( l_standard_terms, FND_API.G_MISS_NUM ) ))

4587: IF p_customer_profile_rec.standard_terms IS NOT NULL AND
4588: p_customer_profile_rec.standard_terms <> FND_API.G_MISS_NUM
4589: AND ( p_create_update_flag = 'C' OR
4590: ( p_create_update_flag = 'U' AND
4591: p_customer_profile_rec.standard_terms <> NVL( l_standard_terms, FND_API.G_MISS_NUM ) ))
4592: THEN
4593: l_ckeck_acc_bfb_enabled := 'N';
4594: /* Commented the below code and added new set of validations below
4595: for enhancement # 5529044

Line 4620: -- If BFB is enabled, check standard_terms is a BFB standard term

4616: */
4617:
4618: ----------------
4619: -- Below validatins are added for enhancement # 5529044
4620: -- If BFB is enabled, check standard_terms is a BFB standard term
4621: -- If BFB is not enabled, any valid standard_terms ok irrespective of BFB
4622: -- For site profile, if Account level is BFB disabled,
4623: -- validate any valid standard_terms, irrespective of site level BFB
4624: if p_customer_profile_rec.site_use_id is NOT NULL then -- Site profile

Line 4621: -- If BFB is not enabled, any valid standard_terms ok irrespective of BFB

4617:
4618: ----------------
4619: -- Below validatins are added for enhancement # 5529044
4620: -- If BFB is enabled, check standard_terms is a BFB standard term
4621: -- If BFB is not enabled, any valid standard_terms ok irrespective of BFB
4622: -- For site profile, if Account level is BFB disabled,
4623: -- validate any valid standard_terms, irrespective of site level BFB
4624: if p_customer_profile_rec.site_use_id is NOT NULL then -- Site profile
4625: ll_cons_inv_flag := 'N';

Line 4623: -- validate any valid standard_terms, irrespective of site level BFB

4619: -- Below validatins are added for enhancement # 5529044
4620: -- If BFB is enabled, check standard_terms is a BFB standard term
4621: -- If BFB is not enabled, any valid standard_terms ok irrespective of BFB
4622: -- For site profile, if Account level is BFB disabled,
4623: -- validate any valid standard_terms, irrespective of site level BFB
4624: if p_customer_profile_rec.site_use_id is NOT NULL then -- Site profile
4625: ll_cons_inv_flag := 'N';
4626: begin
4627: select cons_inv_flag

Line 4645: check_standard_terms_fk (

4641: ll_cons_inv_flag := p_customer_profile_rec.cons_inv_flag;
4642: end if;
4643: ----------------
4644:
4645: check_standard_terms_fk (
4646: p_column => 'standard_terms',
4647: p_column_value => p_customer_profile_rec.standard_terms,
4648: p_cons_inv_flag => ll_cons_inv_flag,
4649: p_ckeck_acc_bfb_enabled => l_ckeck_acc_bfb_enabled,

Line 4646: p_column => 'standard_terms',

4642: end if;
4643: ----------------
4644:
4645: check_standard_terms_fk (
4646: p_column => 'standard_terms',
4647: p_column_value => p_customer_profile_rec.standard_terms,
4648: p_cons_inv_flag => ll_cons_inv_flag,
4649: p_ckeck_acc_bfb_enabled => l_ckeck_acc_bfb_enabled,
4650: x_return_status => x_return_status );

Line 4647: p_column_value => p_customer_profile_rec.standard_terms,

4643: ----------------
4644:
4645: check_standard_terms_fk (
4646: p_column => 'standard_terms',
4647: p_column_value => p_customer_profile_rec.standard_terms,
4648: p_cons_inv_flag => ll_cons_inv_flag,
4649: p_ckeck_acc_bfb_enabled => l_ckeck_acc_bfb_enabled,
4650: x_return_status => x_return_status );
4651:

Line 4653: hz_utility_v2pub.debug(p_message=>'standard_terms is foreign key to ra_terms . ' ||

4649: p_ckeck_acc_bfb_enabled => l_ckeck_acc_bfb_enabled,
4650: x_return_status => x_return_status );
4651:
4652: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4653: hz_utility_v2pub.debug(p_message=>'standard_terms is foreign key to ra_terms . ' ||
4654: 'x_return_status = ' || x_return_status,
4655: p_prefix =>l_debug_prefix,
4656: p_msg_level=>fnd_log.level_statement);
4657: END IF;

Line 4662: hz_utility_v2pub.debug(p_message=>'(+) after validate standard_terms ... ' ||

4658:
4659: END IF;
4660:
4661: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4662: hz_utility_v2pub.debug(p_message=>'(+) after validate standard_terms ... ' ||
4663: 'x_return_status = ' || x_return_status,
4664: p_prefix =>l_debug_prefix,
4665: p_msg_level=>fnd_log.level_statement);
4666: END IF;

Line 5510: -- 1. message_text_id should be a valid value defined in AR_STANDARD_TEXT

5506:
5507: ------------------------------------
5508: -- validate message_text_id
5509: ------------------------------------
5510: -- 1. message_text_id should be a valid value defined in AR_STANDARD_TEXT
5511: -- 2. Message text can be entered only when late charge type is debit memo or interest invoice
5512:
5513: IF ((p_customer_profile_rec.late_charge_type = 'ADJ') AND
5514: (p_customer_profile_rec.message_text_id IS NOT NULL AND p_customer_profile_rec.message_text_id <> FND_API.G_MISS_NUM)) THEN

Line 5535: hz_utility_v2pub.debug(p_message=>'message_text_id should be a valid value defined in AR_STANDARD_TEXT. '||

5531: p_column_value => p_customer_profile_rec.message_text_id,
5532: x_return_status => x_return_status );
5533:
5534: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5535: hz_utility_v2pub.debug(p_message=>'message_text_id should be a valid value defined in AR_STANDARD_TEXT. '||
5536: 'x_return_status = ' || x_return_status,
5537: p_prefix =>l_debug_prefix,
5538: p_msg_level=>fnd_log.level_statement);
5539: END IF;

Line 11376: -- value in AR_STANDARD_TEXT.STANDARD_TEXT_ID. bug # 5065436

11372: l_dummy VARCHAR2(1);
11373: BEGIN
11374:
11375: -- Validate that the message_text_id passed should be a valid
11376: -- value in AR_STANDARD_TEXT.STANDARD_TEXT_ID. bug # 5065436
11377: SELECT 'Y'
11378: into l_dummy
11379: from AR_STANDARD_TEXT
11380: where STANDARD_TEXT_ID = p_column_value

Line 11379: from AR_STANDARD_TEXT

11375: -- Validate that the message_text_id passed should be a valid
11376: -- value in AR_STANDARD_TEXT.STANDARD_TEXT_ID. bug # 5065436
11377: SELECT 'Y'
11378: into l_dummy
11379: from AR_STANDARD_TEXT
11380: where STANDARD_TEXT_ID = p_column_value
11381: and trunc(sysdate) between
11382: start_date and nvl(end_date,trunc(sysdate));
11383: EXCEPTION

Line 11380: where STANDARD_TEXT_ID = p_column_value

11376: -- value in AR_STANDARD_TEXT.STANDARD_TEXT_ID. bug # 5065436
11377: SELECT 'Y'
11378: into l_dummy
11379: from AR_STANDARD_TEXT
11380: where STANDARD_TEXT_ID = p_column_value
11381: and trunc(sysdate) between
11382: start_date and nvl(end_date,trunc(sysdate));
11383: EXCEPTION
11384: WHEN NO_DATA_FOUND THEN

Line 11386: FND_MESSAGE.SET_TOKEN( 'FK', 'standard_text_id' );

11382: start_date and nvl(end_date,trunc(sysdate));
11383: EXCEPTION
11384: WHEN NO_DATA_FOUND THEN
11385: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11386: FND_MESSAGE.SET_TOKEN( 'FK', 'standard_text_id' );
11387: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11388: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_standard_text' );
11389: FND_MSG_PUB.ADD;
11390: x_return_status := FND_API.G_RET_STS_ERROR;

Line 11388: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_standard_text' );

11384: WHEN NO_DATA_FOUND THEN
11385: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11386: FND_MESSAGE.SET_TOKEN( 'FK', 'standard_text_id' );
11387: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11388: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_standard_text' );
11389: FND_MSG_PUB.ADD;
11390: x_return_status := FND_API.G_RET_STS_ERROR;
11391: END check_message_text_id_fk;
11392:

Line 11810: PROCEDURE check_standard_terms_fk (

11806: x_return_status := FND_API.G_RET_STS_ERROR;
11807:
11808: END check_dunning_letid_fk;
11809:
11810: PROCEDURE check_standard_terms_fk (
11811: p_column IN VARCHAR2,
11812: p_column_value IN NUMBER,
11813: p_cons_inv_flag IN VARCHAR2,
11814: p_ckeck_acc_bfb_enabled IN VARCHAR2,

Line 11851: FND_MESSAGE.SET_TOKEN( 'FK', 'standard_terms' );

11847: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_BAL_FWD_BILL_DISABLED' );
11848: end if;
11849: */
11850: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11851: FND_MESSAGE.SET_TOKEN( 'FK', 'standard_terms' );
11852: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11853: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ra_terms_b');
11854: FND_MSG_PUB.ADD;
11855: x_return_status := FND_API.G_RET_STS_ERROR;

Line 11888: FND_MESSAGE.SET_TOKEN( 'FK', 'standard_terms' );

11884: p_column_value;
11885: EXCEPTION
11886: WHEN NO_DATA_FOUND THEN
11887: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11888: FND_MESSAGE.SET_TOKEN( 'FK', 'standard_terms' );
11889: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11890: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ra_terms');
11891: FND_MSG_PUB.ADD;
11892: x_return_status := FND_API.G_RET_STS_ERROR;

Line 11894: END check_standard_terms_fk;

11890: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ra_terms');
11891: FND_MSG_PUB.ADD;
11892: x_return_status := FND_API.G_RET_STS_ERROR;
11893: */
11894: END check_standard_terms_fk;
11895:
11896: PROCEDURE check_grouping_ruleid_fk (
11897: p_column IN VARCHAR2,
11898: p_column_value IN NUMBER,