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 AR_LOOKUPS

Line 125: p_lookup_table IN VARCHAR2 DEFAULT 'AR_LOOKUPS',

121: );
122:
123: PROCEDURE validate_lookup (
124: p_column IN VARCHAR2,
125: p_lookup_table IN VARCHAR2 DEFAULT 'AR_LOOKUPS',
126: p_lookup_type IN VARCHAR2,
127: p_column_value IN VARCHAR2,
128: x_return_status IN OUT NOCOPY VARCHAR2
129: );

Line 3128: p_lookup_table => 'AR_LOOKUPS',

3124: p_customer_profile_rec.review_cycle <> NVL( l_review_cycle, FND_API.G_MISS_CHAR ) ) )
3125: THEN
3126: validate_lookup (
3127: p_column => 'review_cycle',
3128: p_lookup_table => 'AR_LOOKUPS',
3129: p_lookup_type => 'PERIODIC_REVIEW_CYCLE',
3130: p_column_value => p_customer_profile_rec.review_cycle,
3131: x_return_status => x_return_status );
3132:

Line 3134: hz_utility_v2pub.debug(p_message=>'review_cycle is lookup code in lookup type PERIODIC_REVIEW_CYCLE in ar_lookups. ' ||

3130: p_column_value => p_customer_profile_rec.review_cycle,
3131: x_return_status => x_return_status );
3132:
3133: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3134: hz_utility_v2pub.debug(p_message=>'review_cycle is lookup code in lookup type PERIODIC_REVIEW_CYCLE in ar_lookups. ' ||
3135: 'x_return_status = ' || x_return_status,
3136: p_prefix =>l_debug_prefix,
3137: p_msg_level=>fnd_log.level_statement);
3138: END IF;

Line 5144: p_lookup_table => 'AR_LOOKUPS',

5140: p_customer_profile_rec.credit_classification <> NVL( l_credit_classification, FND_API.G_MISS_CHAR ) ) )
5141: THEN
5142: validate_lookup (
5143: p_column => 'credit_classification',
5144: p_lookup_table => 'AR_LOOKUPS',
5145: p_lookup_type => 'AR_CMGT_CREDIT_CLASSIFICATION',
5146: p_column_value => p_customer_profile_rec.credit_classification,
5147: x_return_status => x_return_status );
5148:

Line 5150: hz_utility_v2pub.debug(p_message=>'credit_classification is lookup code in lookup type AR_CMGT_CREDIT_CLASSIFICATION in ar_lookups. ' ||

5146: p_column_value => p_customer_profile_rec.credit_classification,
5147: x_return_status => x_return_status );
5148:
5149: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5150: hz_utility_v2pub.debug(p_message=>'credit_classification is lookup code in lookup type AR_CMGT_CREDIT_CLASSIFICATION in ar_lookups. ' ||
5151: 'x_return_status = ' || x_return_status,
5152: p_prefix =>l_debug_prefix,
5153: p_msg_level=>fnd_log.level_statement);
5154: END IF;

Line 6119: p_lookup_table => 'AR_LOOKUPS',

6115: p_cust_profile_amt_rec.min_fc_invoice_overdue_type <> NVL( l_min_fc_invoice_overdue_type, FND_API.G_MISS_CHAR ) ) )
6116: THEN
6117: validate_lookup (
6118: p_column => 'min_fc_invoice_overdue_type',
6119: p_lookup_table => 'AR_LOOKUPS',
6120: p_lookup_type => 'AR_AMOUNT_PERCENT',
6121: p_column_value => p_cust_profile_amt_rec.min_fc_invoice_overdue_type,
6122: x_return_status => x_return_status );
6123:

Line 6153: p_lookup_table => 'AR_LOOKUPS',

6149: p_cust_profile_amt_rec.min_fc_balance_overdue_type <> NVL( l_min_fc_balance_overdue_type, FND_API.G_MISS_CHAR ) ) )
6150: THEN
6151: validate_lookup (
6152: p_column => 'min_fc_balance_overdue_type',
6153: p_lookup_table => 'AR_LOOKUPS',
6154: p_lookup_type => 'AR_AMOUNT_PERCENT',
6155: p_column_value => p_cust_profile_amt_rec.min_fc_balance_overdue_type,
6156: x_return_status => x_return_status );
6157:

Line 6187: p_lookup_table => 'AR_LOOKUPS',

6183: p_cust_profile_amt_rec.interest_type <> NVL( l_interest_type, FND_API.G_MISS_CHAR ) ) )
6184: THEN
6185: validate_lookup (
6186: p_column => 'interest_type',
6187: p_lookup_table => 'AR_LOOKUPS',
6188: p_lookup_type => 'AR_INTEREST_PENALTY_TYPE',
6189: p_column_value => p_cust_profile_amt_rec.interest_type,
6190: x_return_status => x_return_status );
6191:

Line 6221: p_lookup_table => 'AR_LOOKUPS',

6217: p_cust_profile_amt_rec.penalty_type <> NVL( l_penalty_type, FND_API.G_MISS_CHAR ) ) )
6218: THEN
6219: validate_lookup (
6220: p_column => 'penalty_type',
6221: p_lookup_table => 'AR_LOOKUPS',
6222: p_lookup_type => 'AR_INTEREST_PENALTY_TYPE',
6223: p_column_value => p_cust_profile_amt_rec.penalty_type,
6224: x_return_status => x_return_status );
6225:

Line 11876: l_lookup_type AR_LOOKUPS.lookup_type%TYPE;

11872: l_position1 NUMBER;
11873: l_position2 NUMBER;
11874:
11875: l_lookup_table VARCHAR2(30);
11876: l_lookup_type AR_LOOKUPS.lookup_type%TYPE;
11877: l_lookup_code AR_LOOKUPS.lookup_code%TYPE;
11878:
11879: BEGIN
11880:

Line 11877: l_lookup_code AR_LOOKUPS.lookup_code%TYPE;

11873: l_position2 NUMBER;
11874:
11875: l_lookup_table VARCHAR2(30);
11876: l_lookup_type AR_LOOKUPS.lookup_type%TYPE;
11877: l_lookup_code AR_LOOKUPS.lookup_code%TYPE;
11878:
11879: BEGIN
11880:
11881: -- search for the value

Line 11897: IF UPPER( l_lookup_table ) = 'AR_LOOKUPS' THEN

11893: l_lookup_type := SUBSTRB( p_val, l_position1 + G_LENGTH,
11894: l_position2 - l_position1 - G_LENGTH );
11895: l_lookup_code := SUBSTRB( p_val, l_position2 + G_LENGTH );
11896:
11897: IF UPPER( l_lookup_table ) = 'AR_LOOKUPS' THEN
11898: BEGIN
11899: SELECT 'Y' INTO l_dummy
11900: FROM AR_LOOKUPS
11901: WHERE LOOKUP_TYPE = l_lookup_type

Line 11900: FROM AR_LOOKUPS

11896:
11897: IF UPPER( l_lookup_table ) = 'AR_LOOKUPS' THEN
11898: BEGIN
11899: SELECT 'Y' INTO l_dummy
11900: FROM AR_LOOKUPS
11901: WHERE LOOKUP_TYPE = l_lookup_type
11902: AND LOOKUP_CODE = l_lookup_code
11903: AND ( ENABLED_FLAG = 'Y' AND
11904: TRUNC( SYSDATE ) BETWEEN

Line 12359: p_lookup_table IN VARCHAR2 DEFAULT 'AR_LOOKUPS',

12355: END validate_cannot_update_to_null;
12356:
12357: PROCEDURE validate_lookup (
12358: p_column IN VARCHAR2,
12359: p_lookup_table IN VARCHAR2 DEFAULT 'AR_LOOKUPS',
12360: p_lookup_type IN VARCHAR2,
12361: p_column_value IN VARCHAR2,
12362: x_return_status IN OUT NOCOPY VARCHAR2
12363: ) IS

Line 12586: FROM ar_lookups

12582: else
12583: if p_customer_profile_rec.cons_bill_level IS NOT NULL then
12584: SELECT COUNT(*)
12585: INTO l_bill_level_count
12586: FROM ar_lookups
12587: WHERE lookup_type = 'HZ_CONS_BILL_LEVEL'
12588: AND lookup_code = p_customer_profile_rec.cons_bill_level
12589: AND TRUNC(SYSDATE) BETWEEN NVL(start_date_active,SYSDATE) AND NVL(end_date_active, SYSDATE+1)
12590: AND enabled_flag = 'Y';

Line 12604: FROM ar_lookups

12600: -- For Account use bill level, use Summary or Detail as bill type.
12601: if p_customer_profile_rec.cons_bill_level = 'ACCOUNT' THEN
12602: SELECT COUNT(*)
12603: INTO l_bill_type_count
12604: FROM ar_lookups
12605: WHERE lookup_type = 'HZ_CONS_INV_TYPE'
12606: AND lookup_code = p_customer_profile_rec.cons_inv_type
12607: AND TRUNC(SYSDATE) BETWEEN NVL(start_date_active,SYSDATE) AND NVL(end_date_active, SYSDATE+1)
12608: AND enabled_flag = 'Y'

Line 12620: FROM ar_lookups

12616: -- For Site use bill level, use Summary, Detail, or Imported as bill type.
12617: else
12618: SELECT COUNT(*)
12619: INTO l_bill_type_count
12620: FROM ar_lookups
12621: WHERE lookup_type = 'HZ_CONS_INV_TYPE'
12622: AND lookup_code = p_customer_profile_rec.cons_inv_type
12623: AND TRUNC(SYSDATE) BETWEEN NVL(start_date_active,SYSDATE) AND NVL(end_date_active, SYSDATE+1)
12624: AND enabled_flag = 'Y';