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 2725: * customer standard form and interface.

2721: * MODIFICATION HISTORY
2722: *
2723: * 07-23-2001 Jianying Huang o Created.
2724: * 11-08-2001 P.Suresh * Bug No : 1999532. Added validations as present in
2725: * customer standard form and interface.
2726: * 12-05-2001 P.Suresh * Bug No : 2125994. Commented the mandatory check
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

Line 2781: l_standard_terms HZ_CUSTOMER_PROFILES.STANDARD_TERMS%TYPE;

2777:
2778: l_account_status HZ_CUSTOMER_PROFILES.ACCOUNT_STATUS%TYPE;
2779: l_tolerance HZ_CUSTOMER_PROFILES.TOLERANCE%TYPE;
2780: l_percent_collectable HZ_CUSTOMER_PROFILES.PERCENT_COLLECTABLE%TYPE;
2781: l_standard_terms HZ_CUSTOMER_PROFILES.STANDARD_TERMS%TYPE;
2782: l_override_terms HZ_CUSTOMER_PROFILES.OVERRIDE_TERMS%TYPE;
2783: l_lockbox_matching_option HZ_CUSTOMER_PROFILES.LOCKBOX_MATCHING_OPTION%TYPE;
2784: l_autocash_hierarchy_id HZ_CUSTOMER_PROFILES.AUTOCASH_HIERARCHY_ID%TYPE;
2785: l_autocash_hierarchy_id_for_ad HZ_CUSTOMER_PROFILES.AUTOCASH_HIERARCHY_ID_FOR_ADR%TYPE;

Line 2837: STANDARD_TERMS,OVERRIDE_TERMS,LOCKBOX_MATCHING_OPTION,

2833: DISCOUNT_GRACE_DAYS,DUNNING_LETTERS,DUNNING_LETTER_SET_ID,
2834: SEND_STATEMENTS,STATEMENT_CYCLE_ID,CREDIT_BALANCE_STATEMENTS,
2835: INTEREST_CHARGES,CHARGE_ON_FINANCE_CHARGE_FLAG,
2836: INTEREST_PERIOD_DAYS,ACCOUNT_STATUS,TOLERANCE,PERCENT_COLLECTABLE,
2837: STANDARD_TERMS,OVERRIDE_TERMS,LOCKBOX_MATCHING_OPTION,
2838: AUTOCASH_HIERARCHY_ID,AUTOCASH_HIERARCHY_ID_FOR_ADR,
2839: CLEARING_DAYS,PAYMENT_GRACE_DAYS,GROUPING_RULE_ID,
2840: TAX_PRINTING_OPTION,
2841: REVIEW_CYCLE,LAST_CREDIT_REVIEW_DATE,NEXT_CREDIT_REVIEW_DATE,PARTY_ID,

Line 2852: l_standard_terms,l_override_terms,l_lockbox_matching_option,

2848: l_discount_grace_days,l_dunning_letters,l_dunning_letter_set_id,
2849: l_send_statements,l_statement_cycle_id,l_credit_balance_statements,
2850: l_interest_charges,l_finance_charge_flag,
2851: l_interest_period_days,l_account_status,l_tolerance,l_percent_collectable,
2852: l_standard_terms,l_override_terms,l_lockbox_matching_option,
2853: l_autocash_hierarchy_id,l_autocash_hierarchy_id_for_ad,
2854: l_clearing_days,l_payment_grace_days,l_grouping_rule_id,
2855: l_tax_printing_option,
2856: l_review_cycle,l_last_credit_review_date,l_next_credit_review_date,l_party_id,

Line 4558: ----* Validating standard_terms*---

4554: END IF;
4555:
4556:
4557: ----------------------------------------
4558: ----*** Validating standard_terms***---
4559: ----------------------------------------
4560: IF p_customer_profile_rec.standard_terms IS NOT NULL AND
4561: p_customer_profile_rec.standard_terms <> FND_API.G_MISS_NUM
4562: AND ( p_create_update_flag = 'C' OR

Line 4560: IF p_customer_profile_rec.standard_terms IS NOT NULL AND

4556:
4557: ----------------------------------------
4558: ----*** Validating standard_terms***---
4559: ----------------------------------------
4560: IF p_customer_profile_rec.standard_terms IS NOT NULL AND
4561: p_customer_profile_rec.standard_terms <> FND_API.G_MISS_NUM
4562: AND ( p_create_update_flag = 'C' OR
4563: ( p_create_update_flag = 'U' AND
4564: p_customer_profile_rec.standard_terms <> NVL( l_standard_terms, FND_API.G_MISS_NUM ) ))

Line 4561: p_customer_profile_rec.standard_terms <> FND_API.G_MISS_NUM

4557: ----------------------------------------
4558: ----*** Validating standard_terms***---
4559: ----------------------------------------
4560: IF p_customer_profile_rec.standard_terms IS NOT NULL AND
4561: p_customer_profile_rec.standard_terms <> FND_API.G_MISS_NUM
4562: AND ( p_create_update_flag = 'C' OR
4563: ( p_create_update_flag = 'U' AND
4564: p_customer_profile_rec.standard_terms <> NVL( l_standard_terms, FND_API.G_MISS_NUM ) ))
4565: THEN

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

4560: IF p_customer_profile_rec.standard_terms IS NOT NULL AND
4561: p_customer_profile_rec.standard_terms <> FND_API.G_MISS_NUM
4562: AND ( p_create_update_flag = 'C' OR
4563: ( p_create_update_flag = 'U' AND
4564: p_customer_profile_rec.standard_terms <> NVL( l_standard_terms, FND_API.G_MISS_NUM ) ))
4565: THEN
4566: l_ckeck_acc_bfb_enabled := 'N';
4567: /* Commented the below code and added new set of validations below
4568: for enhancement # 5529044

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

4589: */
4590:
4591: ----------------
4592: -- Below validatins are added for enhancement # 5529044
4593: -- If BFB is enabled, check standard_terms is a BFB standard term
4594: -- If BFB is not enabled, any valid standard_terms ok irrespective of BFB
4595: -- For site profile, if Account level is BFB disabled,
4596: -- validate any valid standard_terms, irrespective of site level BFB
4597: if p_customer_profile_rec.site_use_id is NOT NULL then -- Site profile

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

4590:
4591: ----------------
4592: -- Below validatins are added for enhancement # 5529044
4593: -- If BFB is enabled, check standard_terms is a BFB standard term
4594: -- If BFB is not enabled, any valid standard_terms ok irrespective of BFB
4595: -- For site profile, if Account level is BFB disabled,
4596: -- validate any valid standard_terms, irrespective of site level BFB
4597: if p_customer_profile_rec.site_use_id is NOT NULL then -- Site profile
4598: ll_cons_inv_flag := 'N';

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

4592: -- Below validatins are added for enhancement # 5529044
4593: -- If BFB is enabled, check standard_terms is a BFB standard term
4594: -- If BFB is not enabled, any valid standard_terms ok irrespective of BFB
4595: -- For site profile, if Account level is BFB disabled,
4596: -- validate any valid standard_terms, irrespective of site level BFB
4597: if p_customer_profile_rec.site_use_id is NOT NULL then -- Site profile
4598: ll_cons_inv_flag := 'N';
4599: begin
4600: select cons_inv_flag

Line 4618: check_standard_terms_fk (

4614: ll_cons_inv_flag := p_customer_profile_rec.cons_inv_flag;
4615: end if;
4616: ----------------
4617:
4618: check_standard_terms_fk (
4619: p_column => 'standard_terms',
4620: p_column_value => p_customer_profile_rec.standard_terms,
4621: p_cons_inv_flag => ll_cons_inv_flag,
4622: p_ckeck_acc_bfb_enabled => l_ckeck_acc_bfb_enabled,

Line 4619: p_column => 'standard_terms',

4615: end if;
4616: ----------------
4617:
4618: check_standard_terms_fk (
4619: p_column => 'standard_terms',
4620: p_column_value => p_customer_profile_rec.standard_terms,
4621: p_cons_inv_flag => ll_cons_inv_flag,
4622: p_ckeck_acc_bfb_enabled => l_ckeck_acc_bfb_enabled,
4623: x_return_status => x_return_status );

Line 4620: p_column_value => p_customer_profile_rec.standard_terms,

4616: ----------------
4617:
4618: check_standard_terms_fk (
4619: p_column => 'standard_terms',
4620: p_column_value => p_customer_profile_rec.standard_terms,
4621: p_cons_inv_flag => ll_cons_inv_flag,
4622: p_ckeck_acc_bfb_enabled => l_ckeck_acc_bfb_enabled,
4623: x_return_status => x_return_status );
4624:

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

4622: p_ckeck_acc_bfb_enabled => l_ckeck_acc_bfb_enabled,
4623: x_return_status => x_return_status );
4624:
4625: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4626: hz_utility_v2pub.debug(p_message=>'standard_terms is foreign key to ra_terms . ' ||
4627: 'x_return_status = ' || x_return_status,
4628: p_prefix =>l_debug_prefix,
4629: p_msg_level=>fnd_log.level_statement);
4630: END IF;

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

4631:
4632: END IF;
4633:
4634: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4635: hz_utility_v2pub.debug(p_message=>'(+) after validate standard_terms ... ' ||
4636: 'x_return_status = ' || x_return_status,
4637: p_prefix =>l_debug_prefix,
4638: p_msg_level=>fnd_log.level_statement);
4639: END IF;

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

5449:
5450: ------------------------------------
5451: -- validate message_text_id
5452: ------------------------------------
5453: -- 1. message_text_id should be a valid value defined in AR_STANDARD_TEXT
5454: -- 2. Message text can be entered only when late charge type is debit memo or interest invoice
5455:
5456: IF ((p_customer_profile_rec.late_charge_type = 'ADJ') AND
5457: (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 5478: hz_utility_v2pub.debug(p_message=>'message_text_id should be a valid value defined in AR_STANDARD_TEXT. '||

5474: p_column_value => p_customer_profile_rec.message_text_id,
5475: x_return_status => x_return_status );
5476:
5477: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5478: hz_utility_v2pub.debug(p_message=>'message_text_id should be a valid value defined in AR_STANDARD_TEXT. '||
5479: 'x_return_status = ' || x_return_status,
5480: p_prefix =>l_debug_prefix,
5481: p_msg_level=>fnd_log.level_statement);
5482: END IF;

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

11081: l_dummy VARCHAR2(1);
11082: BEGIN
11083:
11084: -- Validate that the message_text_id passed should be a valid
11085: -- value in AR_STANDARD_TEXT.STANDARD_TEXT_ID. bug # 5065436
11086: SELECT 'Y'
11087: into l_dummy
11088: from AR_STANDARD_TEXT
11089: where STANDARD_TEXT_ID = p_column_value

Line 11088: from AR_STANDARD_TEXT

11084: -- Validate that the message_text_id passed should be a valid
11085: -- value in AR_STANDARD_TEXT.STANDARD_TEXT_ID. bug # 5065436
11086: SELECT 'Y'
11087: into l_dummy
11088: from AR_STANDARD_TEXT
11089: where STANDARD_TEXT_ID = p_column_value
11090: and trunc(sysdate) between
11091: start_date and nvl(end_date,trunc(sysdate));
11092: EXCEPTION

Line 11089: where STANDARD_TEXT_ID = p_column_value

11085: -- value in AR_STANDARD_TEXT.STANDARD_TEXT_ID. bug # 5065436
11086: SELECT 'Y'
11087: into l_dummy
11088: from AR_STANDARD_TEXT
11089: where STANDARD_TEXT_ID = p_column_value
11090: and trunc(sysdate) between
11091: start_date and nvl(end_date,trunc(sysdate));
11092: EXCEPTION
11093: WHEN NO_DATA_FOUND THEN

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

11091: start_date and nvl(end_date,trunc(sysdate));
11092: EXCEPTION
11093: WHEN NO_DATA_FOUND THEN
11094: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11095: FND_MESSAGE.SET_TOKEN( 'FK', 'standard_text_id' );
11096: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11097: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_standard_text' );
11098: FND_MSG_PUB.ADD;
11099: x_return_status := FND_API.G_RET_STS_ERROR;

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

11093: WHEN NO_DATA_FOUND THEN
11094: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11095: FND_MESSAGE.SET_TOKEN( 'FK', 'standard_text_id' );
11096: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11097: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_standard_text' );
11098: FND_MSG_PUB.ADD;
11099: x_return_status := FND_API.G_RET_STS_ERROR;
11100: END check_message_text_id_fk;
11101:

Line 11518: PROCEDURE check_standard_terms_fk (

11514: x_return_status := FND_API.G_RET_STS_ERROR;
11515:
11516: END check_dunning_letid_fk;
11517:
11518: PROCEDURE check_standard_terms_fk (
11519: p_column IN VARCHAR2,
11520: p_column_value IN NUMBER,
11521: p_cons_inv_flag IN VARCHAR2,
11522: p_ckeck_acc_bfb_enabled IN VARCHAR2,

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

11555: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_BAL_FWD_BILL_DISABLED' );
11556: end if;
11557: */
11558: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11559: FND_MESSAGE.SET_TOKEN( 'FK', 'standard_terms' );
11560: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11561: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ra_terms_b');
11562: FND_MSG_PUB.ADD;
11563: x_return_status := FND_API.G_RET_STS_ERROR;

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

11592: p_column_value;
11593: EXCEPTION
11594: WHEN NO_DATA_FOUND THEN
11595: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11596: FND_MESSAGE.SET_TOKEN( 'FK', 'standard_terms' );
11597: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11598: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ra_terms');
11599: FND_MSG_PUB.ADD;
11600: x_return_status := FND_API.G_RET_STS_ERROR;

Line 11602: END check_standard_terms_fk;

11598: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ra_terms');
11599: FND_MSG_PUB.ADD;
11600: x_return_status := FND_API.G_RET_STS_ERROR;
11601: */
11602: END check_standard_terms_fk;
11603:
11604: PROCEDURE check_grouping_ruleid_fk (
11605: p_column IN VARCHAR2,
11606: p_column_value IN NUMBER,